Blog · Board and management reporting
Build a nonprofit monthly financial report from approved ledger exports. Compare program spending with budget, separate donor restrictions, and reconcile operating results to available cash.
A monthly financial report for a nonprofit organization separates program spending, donor restrictions, and cash available for operations. A balanced total can hide a shortfall in resources without donor restrictions, while a healthy bank balance can include money committed to a particular purpose. Show each view and reconcile them before asking management to act.
The starting layout can follow the monthly financial report template. The nonprofit additions are a program and function comparison, a restriction rollforward, and a bridge from bank cash to the amount management can use for general operations.
Take the closed September 2026 ledger, the approved monthly budget, a donor restriction schedule, and reconciled bank balances. Use one reporting cutoff and one version of each file. An expense-positive ledger export should identify posting date, program or function, transaction class, amount, donor restriction, and account.
Finance should confirm how shared expenses are allocated and how restriction releases are recorded. A grant deposit is not enough evidence to decide how revenue or a release should be classified. Carry approved accounting classifications into the report, and send unresolved classifications back to finance.
The IRS Form 990 instructions distinguish program services, management and general, and fundraising in the statement of functional expenses. They also distinguish net assets with and without donor restrictions for organizations following ASC 958. Use those distinctions to keep the monthly review understandable, while retaining the organization's approved accounting policies.
Harbor Learning Network, a fictional US nonprofit, uses the following September spending comparison. Its budget and actual expenses include shared costs on the same approved allocation basis.
| Program or function | Budget (USD) | Actual (USD) | Actual minus budget (USD) | Variance |
|---|---|---|---|---|
| Tutoring | 30,000 | 32,000 | 2,000 | 6.7% |
| Food access | 20,000 | 18,000 | -2,000 | -10.0% |
| Management and general | 10,000 | 11,000 | 1,000 | 10.0% |
| Fundraising | 5,000 | 4,000 | -1,000 | -20.0% |
| Total | 65,000 | 65,000 | 0 | 0.0% |
Put these labels in A2:A5 and budgets in B2:B5. On the Ledger worksheet, A is posting date, B is program or function, C is transaction class, and D is the expense-positive amount. Set H1 to the month start:
=DATE(2026,9,1)
In C2, sum the matching expenses, then fill down:
=SUMIFS(Ledger!$D:$D,Ledger!$B:$B,$A2,Ledger!$C:$C,"Expense",Ledger!$A:$A,">="&$H$1,Ledger!$A:$A,"<"&EDATE($H$1,1))
Microsoft's SUMIFS documentation describes summing amounts that meet multiple criteria. This formula selects the function, transaction class, and posting period together.
Calculate D2 and E2 with these Excel formulas:
=C2-B2
=IF(B2=0,"",D2/B2)
Positive expense variance means spending exceeds budget. Percentages are rounded to one decimal place; a zero budget returns a blank percentage for separate review. The total percentage divides the total dollar variance by total budget.
The check is that actual expenses sum to $65,000 in both this comparison and the approved ledger. The zero total variance does not remove the need to explain tutoring's $2,000 overage or food access's $2,000 underspend. Ask whether activity shifted, invoices arrived late, or delivery fell behind schedule before deciding what to change.
The same month's approved activity contains these amounts. Releases move resources between the two classes; they do not create new organization-wide revenue.
| September activity | Without donor restrictions (USD) | With donor restrictions (USD) | Total (USD) |
|---|---|---|---|
| Contributions recognized | 30,000 | 25,000 | 55,000 |
| Program fees | 10,000 | 0 | 10,000 |
| Approved restriction releases | 20,000 | -20,000 | 0 |
| Expenses | -65,000 | 0 | -65,000 |
| Change in net assets | -5,000 | 5,000 | 0 |
| Opening net assets | 175,000 | 80,000 | 255,000 |
| Closing net assets | 170,000 | 85,000 | 255,000 |
If this table begins at A1, its first activity row is row 2. The change and closing formulas for column B are:
=SUM(B2:B5)
=B6+B7
Fill across both classes. The release row must total zero, and closing balances must match the net asset accounts in the approved trial balance.
Total change in net assets is zero, but the without-donor-restrictions column declined by $5,000. Management needs to understand whether that was a planned use of accumulated resources. Do not describe the $5,000 increase in the other class as cash available to solve the shortfall.
The bank reconciliation shows the following movement. The example has no other cash adjustments.
| Cash movement | Amount (USD) |
|---|---|
| Opening bank cash | 100,000 |
| Cash receipts | 75,000 |
| Cash payments | -67,000 |
| Closing bank cash | 108,000 |
Cash increased by $8,000 despite no total change in net assets. The ledger explains that difference:
| Accrual-to-cash bridge | Amount (USD) |
|---|---|
| Change in net assets | 0 |
| Decrease in contribution receivables | 10,000 |
| Increase in prepaid expenses | -2,000 |
| Increase in cash | 8,000 |
Recognized contributions and fees totaled $65,000; collecting receivables added $10,000 to receipts. Expenses totaled $65,000; increasing prepayments added $2,000 to payments. Each difference ties to the cash movement above. The broader distinction is covered in cash flow vs profit.
Next, the approved restriction schedule identifies $50,000 of cash subject to donor restrictions. It also identifies $35,000 of contribution receivables subject to those restrictions, reconciling to the $85,000 closing restricted net assets in this simplified example. There are no other restricted assets or associated liabilities here.
| Cash availability | Amount (USD) |
|---|---|
| Closing bank cash | 108,000 |
| Less cash subject to donor restrictions | -50,000 |
| Less board-designated reserve cash | -20,000 |
| Cash available for general operations under current policy | 38,000 |
With signed amounts in B2:B4, the availability formula is =SUM(B2:B4). A board designation differs from a donor restriction; show it separately because changing it requires the organization's own decision process. This availability measure also needs context from upcoming payroll, payables, and expected receipts.
Keep the requested decisions in the management reporting package. An early flash report should identify estimates and close items still outstanding. Covirage is not affiliated with Microsoft.
Bring approved ledger, budget, and restriction exports to Covirage; it maps the columns, and its tools compute and check the figures. The external AI model explains the results with every figure traced to its rows, helping you discuss program variances and cash availability from the supplied classifications. Create a free Covirage account and bring a sample of your own data.
See financial planning and reporting with Covirage for the supporting workflow.
No. Recognized revenue may include an unpaid contribution, and expenses may include amounts not yet paid. Donor restrictions and board designations can also limit the use of cash already in the bank. Show operating results and a separate cash availability reconciliation.
Use the organization's approved allocation policy and identify whether the program comparison includes allocated costs. Apply the same basis to the budget and actual results. Keep the allocation schedule so a reviewer can trace amounts back to the original expense accounts.
The executive director, finance lead, program budget owners, and the appropriate board or finance committee need views suited to their responsibilities. Share program variances with accountable managers and summarize restriction balances, liquidity concerns, and decisions required for the governing group.