Most not-for-profits produce two financial documents that anyone reads: the annual report and the grant acquittal. Both are produced after the money has moved, making them records of history rather than tools for managing it. The budget vs actual (BvA) report sits between them: a monthly comparison of planned versus actual income and spending, for every program, funding source and restriction.

For an Australian NFP the stakes are higher than for a typical small business. Grant funding arrives with conditions attached, restricted funds cannot be spent on anything but their stated purpose, and the ACNC expects registered charities to manage their financial affairs responsibly. This article sets out a practical Excel framework: restricted versus unrestricted funds, a program-based workbook with worked formulas, and acquittal-ready reporting.

Why NFPs need budget vs actual tracking beyond the annual report

Annual reporting is a compliance deadline, not a management process. Budget vs actual tracking makes the deadline painless, for four reasons.

ACNC reporting. Every registered charity lodges an Annual Information Statement each year, and medium and large charities (annual revenue at or above $500,000) must also lodge financial reports under Australian Accounting Standards. If your monthly BvA has been accurate all year, the annual report is a consolidation task rather than a reconstruction project done under deadline.

Grant acquittals. Most grant agreements require a report showing actual expenditure against the agreed budget lines after the grant term ends. Funders compare what you claim to the budget they approved. Track every dollar against those lines from day one, and the acquittal is an export.

Board visibility. Charities registered as companies limited by guarantee have directors with the same duties as any other company director, including monitoring solvency, and ACNC Governance Standard 5 requires responsible persons to manage financial affairs responsibly. A monthly BvA pack shows the board where the money is, where it is going, and whether restricted funds are intact.

Restricted funds. Donors and funders impose restrictions on how money can be used. The BvA report is the ongoing evidence that those promises are kept; you cannot demonstrate compliance in June if you have not tracked it since July.

There is also a cash flow angle. NFPs frequently operate on a cash basis: grant income arrives in large lump sums, often in advance of the spending it funds. A BvA report forces you to separate income received from income earned, the first step towards understanding whether the organisation is solvent.

Restricted and unrestricted funds: two views, one workbook

The most important distinction in NFP accounting is restricted versus unrestricted funds.

• Restricted funds carry a donor-imposed purpose restriction: a grant for a specific program, a bequest that must fund scholarships, an appeal for a project. The money cannot be used for anything else; unspent balances must be applied to the restricted purpose or returned.
• Unrestricted funds can be used for any purpose consistent with the charity's objects: general donations, membership fees and income from services. This is the pool that keeps the lights on.

The board needs both views, and a common mistake is to force a choice between them. You need to see, per fund, whether the grant has been spent as agreed, and overall, whether the organisation is solvent. In Excel this is a matter of structure:

• Give every transaction a fund or program dimension: a column, not a guess from the account name.
• Build the BvA report grouped by fund, with a total for the overall position.
• Reconcile restricted fund balances monthly: grant received less eligible expenditure must never be negative. A negative balance means restricted money was spent elsewhere, a compliance problem rather than a rounding error.

One timing point matters. Grant money received in advance is not income until earned; unspent amounts sit as deferred income (a liability). Many NFP models treat grant cash receipts as income on receipt, making one month look profitable and the rest of the year look poor.

Building a program-based budget vs actual workbook

A practical NFP BvA workbook has four layers on separate sheets:

1. Budget sheet. One block per program: income sources and expense lines down the rows, 12 months across the columns.
2. Transactions sheet. The coded record of everything that happened, imported from your accounting system (Xero, MYOB or QuickBooks) or keyed directly. The single source of truth for actuals.
3. BvA report. The board-facing output: budget versus actual year-to-date, by program and fund, with variances.
4. Fund summary. Restricted fund balances per grant, reconciled monthly.

The structure is plain, but the modelling discipline underneath separates a workbook the treasurer maintains from one the finance team rebuilds every grant round.

Income sources. Budget income sources separately; they behave differently:

• Grants: project grants, recurrent government funding and capital grants. Timing is set by the agreement; recognition follows the spending.
• Donations: regular giving, one-off gifts and bequests. Volatile and seasonal; monthly rhythm matters.
• Fundraising: events and appeals. Income and direct costs belong to the same program; the net result is what the board wants to see.
• Fees: membership fees and fees for service. Recurring and the most forecastable, the natural base of the unrestricted budget.

Do not net income and expense in the budget. A fundraising event raising $20,000 and costing $18,000 is not a $2,000 income line; it needs its own scrutiny.

Expenses: program versus admin. Every expense is coded either to a program or to administration. Direct costs go straight to the program; shared costs, like rent, insurance and the finance function, need a documented allocation method: full-time equivalent staff, floor area or headcount. Funders routinely cap administration (often 10-15% of the grant) and ACNC reporting asks about the program/admin split.

Month columns versus year-to-date. A full 12-month grid with budget and actual columns for every month is right when timing is material: grant drawdowns, event months, seasonal programs. For most NFPs, a 12-month budget grid with a single year-to-date actual column, driven by SUMIFS from the transactions sheet, is enough.

Variance columns. Every BvA report needs a dollar variance (actual less budget) and a percentage variance (variance divided by budget), with conditional formatting to flag anything outside a threshold you define, such as 10% or $500 on any line. The flag is not the analysis; it points to where the analysis is needed.

Worked example: a grant-funded program in practice

Consider a community organisation running a Food Support Program funded by a $120,000 foundation grant over 12 months, every transaction coded to the program. At 31 July, seven months in, the report looks like this:

Note the sign convention: for expense lines, a negative variance means underspend, which is favourable. Some organisations flip the sign so unfavourable variances are always positive; either works if consistent.

The transactions sheet feeding this report has one row per transaction:

Amounts are entered GST-exclusive, with expenses negative. The actual column is a SUMIFS pulling from this sheet, matching budget line (row) and program (column):

=SUMIFS(Transactions!$E:$E, Transactions!$B:$B, $A5, Transactions!$C:$C, B$4)

The criteria reference the report's own labels, so the same formula copies across the grid, and adding transactions updates the report without touching a formula.

To isolate a single month, add date criteria:

=SUMIFS(Transactions!$E:$E, Transactions!$B:$B, $A5, Transactions!$C:$C, B$4,
        Transactions!$A:$A, ">="&DATE(2026,7,1),
        Transactions!$A:$A, "<="&EOMONTH(DATE(2026,7,1),0))

The variance columns are simple arithmetic:

=C5-B5                                            (variance: actual less budget)
=IF(B5=0, "", D5/B5)                              (% variance, guarded for zero budgets)

Use an Excel Table for the transactions sheet, or full-column references, so the SUMIFS ranges grow automatically.

Now read the report, not just the numbers. Salaries are 9.5% under budget because a coordinator position was vacant for six weeks: timing, not savings, so the year needs reforecasting. Food and materials are 10.5% over, driven by wholesale prices and higher client numbers; at this rate the line will overspend by roughly $6,000 by year end, which may need a reallocation from venue hire (18.3% under) if the funder approves. The admin allocation is a calculated row, not a coded transaction: 12.5% of the grant applied by formula, hence outside the SUMIFS range.

Grant acquittal readiness: make the report write itself

The acquittal is the moment most NFPs scramble, and it is the easiest problem in the workbook to design away. Map your budget lines to the grant agreement's lines one for one at the start of the grant, and build the acquittal template at the same time, in the same shape. If the grant says "staff salaries", "food and materials" and "transport", those exact labels are your budget line names, and the acquittal becomes an export of the BvA report.

Three habits make acquittals painless:

1. Keep an evidence register. One tab listing, per budget line, the invoices and receipts supporting the expenditure, so you are not re-opening boxes at acquittal time.
2. Track the grant cash separately. Grant received, spent, balance remaining. Funders want to see unspent money either committed to eligible expenditure or returned; a simple schedule answers this in seconds.
3. Raise variances before the acquittal, not at it. If a line will overspend, most funders allow reallocations, often up to 10% between lines without prior approval. Raise a material overspend while the program is still running.

Recognition timing matters too. Under AASB 1058, grant income is recognised as the entity satisfies the performance obligations in the agreement, typically as eligible expenditure is incurred. Unspent grant cash at year end is deferred income, not profit; your BvA, acquittal and annual report agree only if all three use the same recognition logic.

Common pitfalls in NFP budget vs actual reporting

Mixing GST-exclusive and GST-inclusive amounts. This is the most common source of wrong variances in NFP workbooks. If the budget was built GST-exclusive and the actuals are pulled inclusive, every line shows a phantom 10% overspend, or the reverse. Pick one basis, GST-exclusive, and reconcile the GST through the BAS. Many NFP supplies are GST-free, including most fundraising events, so a blanket assumption is wrong in both directions.

Misclassifying capital grants. A grant to buy equipment, a vehicle or a fit-out is not an expense when the cash leaves the bank. The asset goes on the balance sheet and the cost is recognised through depreciation over its useful life. If the full purchase runs through the program's expense lines, the program shows a massive overspend in one month and no expense in the months that follow. Keep capital purchases on a capital schedule against the grant's capital lines, and let the P&L show depreciation.

Not separating program and admin overheads. When admin costs hide inside program lines, the board cannot see the true cost of administration, and acquittals overstate program expenditure, which can breach a funder's admin cap even though the organisation is within it on the real numbers. Allocate shared costs on a documented basis and keep the allocation visible.

Fund accounting in one column. A single income column mixing grants, donations, fundraising and fees, with a single expense column underneath, produces a total that nobody can act on. It cannot answer the only question that matters: is each restricted fund intact? Add a fund dimension, a column on the transactions sheet or separate budget blocks, and reconcile restricted balances monthly.

Treating grant receipts as income. When a large grant arrives, the instinct is to record it as income in the month it hits the bank. That inflates one month, deflates the rest, and makes the BvA oscillate between looking great and terrible. Recognise income as it is earned against eligible expenditure, with cash movements on a separate schedule.

A simple monthly review cadence

The value of a BvA workbook comes from rhythm, not the build. A cadence that fits a small NFP with a part-time bookkeeper or treasurer:

Smaller organisations can compress this into half a day a month, and the board pack can be two pages: the BvA report and the fund summary. The discipline that matters is updating the workbook on a fixed day, so the board always sees current numbers.

Conclusion

Budget vs actual reporting is not a compliance chore to be tolerated until the annual report is due. It is the operating report that keeps restricted funds intact, keeps acquittals routine, and gives the board a working picture of the finances instead of a post-mortem. The framework is straightforward: one coded transactions sheet, a fund dimension on every row, budget lines that match grant agreements, and a monthly rhythm of refresh, review and reforecast. Organisations that run this discipline stop treating the annual report and acquittals as reconstruction projects; the board's question changes from "what happened" to "what happens next".

Related reading

• Budget and Forecast for Business
• Excel for Government Reporting and Compliance
• Cash Flow Forecasting for Growing SMEs