Financial Reports by Fund
Wired Church generates real financial statements that meet nonprofit accounting standards. Every report can be run for a single fund, a selection of funds, or consolidated across all funds. This guide walks through each available report, how to configure it, and how to export and share results.
Navigating to Reports
- From the admin sidebar, click Finance.
- Click Reports.
The page offers inline reports that render directly with interactive controls, and linked reports that open on dedicated pages. A Report Catalog button shows all available reports.
Date Range and Fund Selection
All reports share common controls at the top of the page.
Date Range
- Select a start date and end date for the reporting period.
- Quick-select buttons are available for common ranges: This Month, Last Month, This Quarter, This Year, Last Year.
- For point-in-time reports (Balance Sheet), only the end date matters — it shows balances as of that date.
Fund Filter
- All Funds (Consolidated): Combines all funds into a single report. Interfund transfers net to zero.
- Single Fund: Select one fund to see only its activity. The report header shows the fund name.
- Reports that support multi-fund columns (Statement of Activities, Fund Balance Summary) show each selected fund as a separate column.
Detail Mode
Toggle between Detail and Summary views. Detail mode shows individual accounts; Summary mode groups by account type or subtype.
Available Reports
1. Balance Sheet (Statement of Financial Position)
What it shows: Your church's financial position at a specific point in time — what you own (assets), what you owe (liabilities), and what remains (net assets).
Select the Balance Sheet tab, set the as-of date, choose a fund or All Funds, and click Generate.
| Section | What It Contains |
|---|---|
| Assets | Cash and bank accounts, accounts receivable, fixed assets, other assets |
| Liabilities | Accounts payable, credit cards, loans, other liabilities |
| Net Assets Without Donor Restrictions | Balances from unrestricted and designated funds |
| Net Assets With Donor Restrictions | Balances from temporarily and permanently restricted funds |
| Total Liabilities & Net Assets | Must equal Total Assets (the fundamental accounting equation) |
Verification: If Total Assets does not equal Total Liabilities & Net Assets, there is a data entry error somewhere. Run the Trial Balance report to identify the discrepancy.
2. Profit & Loss (Statement of Activities)
What it shows: Revenue earned and expenses incurred over a period of time. The nonprofit equivalent of an income statement.
Select the Profit & Loss tab, set the date range, choose a fund, and click Generate.
| Section | What It Contains |
|---|---|
| Revenue | Tithes and offerings, designated giving, other income |
| Expenses | Personnel, facilities, ministry, missions, administrative, other |
| Net Income (Change in Net Assets) | Revenue minus Expenses — did the fund grow or shrink this period? |
When running consolidated with multiple funds, the report shows columns for Unrestricted, Temporarily Restricted, Permanently Restricted, and a Total column.
3. Fund Balance Summary
What it shows: Every fund's balance at a glance — beginning balance, total revenue, total expenses, net transfers, and ending balance for the selected period.
How to run it:
- Select the Fund Balance Report tab.
- Set the date range.
- Click Generate.
This is the report your board will ask for most often. It answers the question: "How much is in each fund, and how did it change?"
Columns:
| Column | Description |
|---|---|
| Fund Name | Name and type badge |
| Beginning Balance | Net assets at the start of the period |
| Revenue | Total revenue posted to this fund |
| Expenses | Total expenses posted to this fund |
| Net Transfers | Transfers in minus transfers out |
| Ending Balance | Beginning + Revenue - Expenses + Net Transfers |
4. Trial Balance
What it shows: Every account's total debits and total credits for a period. The sum of all debits must equal the sum of all credits. If they do not, something is wrong.
How to run it:
- Select the Trial Balance tab.
- Set the date range.
- Choose a fund or All Funds.
- Click Generate.
Columns:
| Column | Description |
|---|---|
| Account Number | The account's number from the chart of accounts |
| Account Name | The account's display name |
| Debit | Total debit activity for the period |
| Credit | Total credit activity for the period |
At the bottom, a totals row shows the grand total of debits and credits. These must be equal.
Run the Trial Balance at least once a month. Catching an imbalance after one month of transactions is far easier than debugging after twelve months.
5. Budget vs. Actual
What it shows: How actual spending compares to the budget you set. Highlights over-budget and under-budget accounts.
Prerequisites: You must have a budget configured for the fiscal year. See Finance > Budget to set one up.
How to run it:
- Select the Budget vs Actual tab.
- Select the fiscal year and budget.
- Set the date range (defaults to year-to-date).
- Choose a fund.
- Click Generate.
Columns:
| Column | Description |
|---|---|
| Account | Revenue or expense account name |
| Budget | The budgeted amount for the period |
| Actual | The actual amount posted for the period |
| Variance | Budget minus Actual (positive = under budget, negative = over budget) |
| % Used | Actual divided by Budget, shown as a percentage |
Accounts that exceed their budget are highlighted with a warning color. Accounts significantly under budget are also flagged, as that may indicate unrecorded transactions.
6. General Ledger and Additional Reports
The General Ledger (GL Detail) shows every individual transaction for every account with running balances. Access it from the Report Catalog or directly at Finance > Reports > General Ledger. Filter by date range, account, fund, and journal entry type.
Additional reports available from the Report Catalog:
| Report | Page | Description |
|---|---|---|
| Statement of Cash Flows | /admin/finance/reports/cash-flows |
Operating, investing, and financing cash activity |
| Statement of Functional Expenses | /admin/finance/reports/functional-expenses |
Expenses broken down by program, management & general, and fundraising |
| Year-over-Year Comparison | /admin/finance/reports/comparative |
Side-by-side comparison of two periods (e.g., this year vs. last year) |
| Custom Report Builder | /admin/finance/reports/custom |
Build ad-hoc reports with custom filters, grouping, and column selection |
| A/P Aging Summary | /admin/finance/bills |
Outstanding bills grouped by aging period (current, 30, 60, 90+ days) |
| Check Register | Reports page | All checks written with payee, amount, and clearing status |
Exporting Reports
Every report can be exported in two formats using the buttons in the report toolbar:
- PDF — Click the PDF button to generate a formatted document via jsPDF. Includes report title, date range, fund name, church name, and timestamp. Formatted for 8.5 x 11 landscape.
- Excel — Click the Excel button to generate an .xlsx file via SheetJS with raw data and column headers, ready for pivot tables or custom charts.
Sharing Reports with Board and Leadership
Export reports to PDF or Excel and share via email or your board's document portal. For recurring needs, use Finance > Scheduled Reports to automate generation on a schedule.
Best practice: Send the board a consistent set of reports each month: Fund Balance Summary, Statement of Activities (consolidated), and Budget vs. Actual.
Dashboard Charts
The Finance dashboard at Finance > Dashboard includes interactive SVG charts: Giving Trends (line chart over time), Fund Balances (bar chart across funds), Budget Progress (progress bars for expense categories), and Revenue vs. Expenses (side-by-side comparison). These update in real time as journal entries are posted.
Tips for Effective Financial Reporting
- Run the Trial Balance monthly to catch data entry errors early.
- Use consistent date ranges when comparing periods.
- Review the Fund Balance Summary before board meetings for the clearest snapshot of fund health.
- Export to Excel when you need custom pivot tables or charts beyond the built-in reports.
- Check Year-over-Year Comparison annually to spot trends in giving and spending.
Common Questions
Why does my Balance Sheet not balance? Total Assets must equal Total Liabilities plus Net Assets. If they do not, a journal entry was posted with unequal debits and credits (which the system prevents), or an opening balance was entered incorrectly. Run the Trial Balance to find the discrepancy.
Can I run reports for a closed fiscal year? Yes. All historical data is available. Select the date range for the prior year and generate the report as usual.
Why are interfund transfers showing as zero on the consolidated report? That is correct behavior. On a consolidated report, transfers between funds are internal — money did not enter or leave the organization. They net to zero by design.
Can I customize which accounts appear on a report? The Custom Report Builder at Finance > Reports > Custom lets you select specific accounts, funds, and grouping options.
Related Articles
- Setting Up Funds — Create the funds that power these reports
- Fund Transfers — Understand how transfers appear on reports
- Understanding the Chart of Accounts — The accounts behind every report line item