Nonprofit dashboard: funding, programs, and operating cash

A nonprofit dashboard compares funding, program spending, and operating cash with the approved budget for the same period. Keep recognized revenue, cash receipts, and available cash separate. A balanced expense budget can still leave the organization short of its planned surplus or collecting less cash than it pays out.

Start with files finance can reconcile

Use the monthly general ledger detail, a funding register, the approved budget by account and program, and the reconciled bank balance. Include account, program or function, posting date, amount, and any restriction identifier. The funding register should distinguish recognized revenue from collections and award announcements.

Ask the finance lead to approve the reporting basis and mappings before building the summary. Use one fiscal month throughout and preserve the budget version that management approved. Changing the budget after seeing actual results removes the comparison the dashboard was meant to provide.

The IRS Form 990 instructions distinguish program services, management and general, and fundraising in the statement of functional expenses. Use an approved classification map for those functions; a department name alone does not establish the accounting treatment. This dashboard supports internal management reporting, with finance responsible for formal reporting judgments.

Calculate expense variances by function

Consider an illustrative US community nonprofit reporting September 2026. Its Expenses sheet has function in column A, actual expense in B, and approved budget in C. These are recognized monthly expenses, rather than a list of checks written.

In Google Sheets, enter the following and fill D2 down through D5:

D2: =B2-C2
B6: =SUM(B2:B5)
C6: =SUM(C2:C5)
D6: =B6-C6

A positive expense variance means spending exceeded budget. It is a prompt to investigate, not an automatic unfavorable judgment: extra spending could accompany approved additional service. Program directors explain the activity; finance confirms whether the cost classification and timing are correct.

Program expense is 80,000 + 40,000 = $120,000. Its share of total expense is 120,000 / 150,000 = 80.0%, rounded to one decimal place. That share describes cost allocation, not mission impact. Avoid declaring the lower-spending youth program successful until its service activity is checked.

For larger exports, Google's SUMIFS documentation describes summing amounts that meet multiple conditions. If Ledger columns A, B, and C hold posting date, function, and expense amount, respectively, this formula returns September food access expense:

=SUMIFS(Ledger!$C$2:$C$10000,Ledger!$B$2:$B$10000,A2,Ledger!$A$2:$A$10000,">="&DATE(2026,9,1),Ledger!$A$2:$A$10000,"<"&DATE(2026,10,1))

It assumes the export represents expenses as positive amounts, with reversals negative. Covirage is not affiliated with Google.

Compare recognized funding with the same budget

Use a separate Funding sheet with source in A, actual recognized revenue in B, and budget in C. In this example, all amounts have already been reviewed under the organization's accounting policy.

Use the same subtraction and total formulas, ending at row 5 for this shorter table. Actual operating surplus is 165,000 − 150,000 = $15,000; budget surplus is 170,000 − 150,000 = $20,000. The surplus gap is 15,000 − 20,000 = −$5,000, entirely explained by funding below budget because total expense is on budget.

Actual surplus: =Funding!B5-Expenses!B6
Budget surplus: =Funding!C5-Expenses!C6

That is a different question from donor retention or campaign progress, which belong in a fundraising dashboard. Keep this page focused on the resources funding the current operating plan.

Prove the cash movement separately

The bank reconciliation and cash activity show the following. The example has no other cash movements.

In a Cash sheet, put the first three amounts in B2:B4 and use =SUM(B2:B4) in B5. Closing cash is 100,000 + 140,000 − 155,000 = $85,000, a decrease of $15,000 despite the operating surplus.

For this example only, the entire difference comes from increased funding receivables and prepaid expenses; there are no other reconciliation items.

The result ties to 85,000 − 100,000 = −$15,000. Real organizations must also account for their actual payable changes, noncash expenses, and other movements. The broader cash flow versus profit comparison explains why these bases differ.

Show what management can use

Finance identifies the following nonoverlapping amounts within closing cash:

The calculation is 85,000 − 25,000 − 10,000 = $50,000. Board designation and donor restriction have different meanings; label them separately and do not subtract the same funds twice. This is a management availability measure before considering unpaid obligations, not a formal net asset balance. Use nonprofit cash management for the subsequent payment and collection decisions.

Where it goes wrong

• Awards counted as receipts. An approved award does not establish collection timing or recognized revenue.
• Unmapped shared costs. Allocate shared expenses under a documented policy before comparing programs.
• Cash restrictions double counted. A restriction recorded in multiple reports must reduce available cash only once.
• Surplus read as spending capacity. Reconcile collections, payments, and unpaid commitments before approving new spending.

Apply the same checks to your nonprofit files

Upload your ledger, approved budget, and funding or cash summary to Covirage. Its tools map the columns, compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account in about a minute and bring a sample of your own data.

See financial planning and analysis reporting for the supporting reporting context.