Fund accounting without spreadsheets: A guide for not-for-profits and schools
Fund accounting is a structural problem, not a diligence issue. The team is not tracking funds badly; they are tracking them by hand because the ledger was never built to do it for them. Structured correctly, funds reconcile as you go, and reporting stops being a monthly rebuild.
Fund accounting is the framework that keeps a finance team clear on where every dollar comes from and what it is for. The more the team can see in real time, rather than switching between spreadsheets to work out whether money is a donation, a grant, or funding tied to a legal obligation, the easier it becomes to manage each funding stream.
Tracking funds accurately in Australia is not optional.
Funding can be subject to grant conditions, donor restrictions, governing arrangements, and other legal or reporting requirements, so organisations need a clear way to track what money was provided for and how it has been used.
But consider what happens when those funding streams sit in fragile workbooks, or in platforms never built to handle them. The pressure builds:
● Finance teams spend every month looking back at the formula they last used.
● The board is not confident in the numbers.
● Reconciliations fall behind.
● Acquittals are rebuilt from scratch each period.
● Visibility is never real-time, and audit pressure grows with it.
That is the challenge not-for-profits and schools share. Different sectors have the same underlying problem: funds that must be tracked to its purpose, held in spreadsheets that was never designed to do it.
The anchor point?
The anchor point is accountability, not profit. Rather than money flowing through one funnel and sitting in a single pool, the finance team is drawing branches, separating each funding stream and holding it to its purpose.
That structure comes down to four principles: structure your funds first, tag every transaction at the point of entry, reconcile continuously, and report and acquit on demand. They hold for every organisation, but they apply differently to a charity than to a school. Here is how they play out in each sector, first for not-for-profits, then for schools.
Part one: Fund accounting for not-for-profits
Here are the four principles, mapped to the not-for-profit world.
For a not-for-profit, many funding streams arrive with conditions or expectations attached. A program grant may need to be spent on that program. An appeal needs to be used consistently with what donors were told. Other funding may be available for the organisation to direct more broadly. The finance team needs to keep those streams clear, for the board, treasurer, funders and other stakeholders, while maintaining the records needed to meet the organisation’s governance, reporting and regulatory obligations.
1. Structure your funds before you post a transaction.
Each program grant, appeal, or other funding stream that needs separate tracking gets its own place in the ledger, with the structure reflecting the organisation’s funding conditions and reporting needs rather than relying on a column someone maintains by hand.
This operational structure is separate from the accounting question of when income is recognised under standards such as AASB 15 or AASB 1058. Set up well, it means consolidation and reporting across programs and entities stop being a manual rebuild, the view already exists.
2. Tag every transaction to its fund at the point of entry.
A grant receipt or donation is coded to its fund and purpose the moment it lands, not sorted out later, when someone has to work out which appeal it belonged to. Done at entry, "which fund was this?" stops being a month-end question, because it was answered when the money came in.
3. Reconcile continuously, not at period end.
Fund balances stay current all month, so spend against each restricted grant is always known against its budget. There is no surprise at quarter-end that a fund has been overspent or drawn on for the wrong purpose.
For an NFP, that is more than tidy bookkeeping ,continuous reconciliation provides an important control, helping the organisation identify issues early and demonstrate that funding is being managed in line with the relevant grant conditions and restrictions.
4. Report on demand.
This is where the structure pays off most.
Instead of rebuilding the financial component of a grant acquittal from spreadsheets each period, current fund data can already be coded and reconciled, ready to feed the reporting process.
Some acquittals will still require supporting evidence, certifications, narrative reporting, or funder-specific formats, but the underlying financial information no longer has to be reconstructed from scratch. The same is true for the board and treasurer: current numbers, produced on demand, with less reconciliation lag sitting behind them.
Part two: Fund accounting for schools and education providers
The same four, now mapped to a school or education provider.
A school's funding comes from streams with different purposes and conditions. There may be recurrent government funding, specific capital grants, donations to school building or scholarship funds, other tied donations, and general fee income. Each can carry different requirements for how it is spent, accounted for, and reported.
A business manager usually maintains this to keep those streams clear, for the board, governing body, funders and school community, without relying on a spreadsheet to stop money with different purposes from quietly running together.
1. Structure your funds before you post a transaction.
Each funding stream that needs separate tracking gets its own place in the ledger. Whether that is a school building fund, scholarship fund, specific capital grant, or tied donation, with the structure reflecting the conditions and reporting requirements attached to it. Because education finance is so often analysed by campus, faculty, or program, this is also where the dimensional structure is set: so a report by campus or program is a view that already exists, not one rebuilt each time it is requested.
2. Tag every transaction to its fund at the point of entry.
A capital grant receipt, scholarship drawdown, or donation to a school building fund is coded to its fund and purpose as it is entered, with its campus or program dimension attached at the same time. Done at entry, the school is not left working out after the fact which funding stream a cost belonged to. That matters particularly where funding is subject to specific grant, trust, DGR, or other requirements governing how it may be used.
3. Reconcile continuously, not at period end.
Fund and grant balances stay current all month, so the school always knows what a capital grant or scholarship fund has left against its purpose.
Capital project accounting in particular benefits: spend tracks against the project in real time rather than being reconstructed at year-end. For an education provider, that continuous view provides an important control over funding with specific conditions, helping the team identify issues early and giving auditors a clearer trail to review.
4. Report on demand.
This is where it pays off. Reporting to the board, governing body, or funder becomes a pull rather than a project: current numbers, produced on demand, broken down by campus, faculty, program, or funding stream because those dimensions were captured at entry.
Where a grant or fund requires acquittal or other financial reporting, the underlying numbers are already structured and reconciled, reducing the amount of manual reconstruction required. The business manager walks into the finance committee with numbers that did not take a week to assemble.
The same method, side by side
| Principle | Not-for-profits | Schools & education |
|---|---|---|
| 1. Structure funds first | A fund per program grant, appeal, and restricted gift; structured according to funding conditions and reporting needs. | A fund per building fund, scholarship, capital grant, and tied donation, with campus/faculty/program dimensions set here. |
| 2. Tag at point of entry | Grants and donations coded to fund and purpose as they land — no “which appeal was this?” at month-end. | Capital grants, scholarship drawdowns, and building-fund gifts coded to fund, purpose, and campus at entry. |
| 3. Reconcile continuously | Spend against each fund stays current, helping identify issues early and support compliance with funding conditions. | Fund and project spend stays current, giving the team clearer oversight of funding with specific conditions. |
| 4. Report & acquit on demand | Current, reconciled fund data reduces the manual work involved in board reporting and grant acquittals. | Board, governing-body, and funder reporting can be produced by campus, faculty, program, or funding stream. |
What changes when it's structured this way
The shift is not that the team works harder at fund tracking. It is that the tracking largely stops being work at all.
When funds are structured once and coded at entry, the finance function gains back what the spreadsheet quietly took.
Control, because each fund holds to its purpose by design,nothing drifts across the lines it is not meant to cross.
Confidence, because the numbers are current and trusted, not reconstructed at period end and second-guessed.
Credibility, because acquittals, board packs, and audit evidence come out of the system on demand, so finance walks in prepared rather than scrambling. And capacity, because the hours once spent rebuilding fund positions every month are returned to the team for the work that actually needs judgement.
It is the same principle as a continuous close, applied to funds. The money keeps pace because the work moved upstream, decided when the structure was built and the transaction was entered, not deferred to a clean-up that never quite ends. Audit stops being a rescue and becomes a review of a system that was in order all along.
That is fund accounting without spreadsheets: not a tidier version of the manual process, but a different model, where the structure does the tracking and the team does the thinking.
Where to start
The first step is knowing where your fund accounting stands today.
This is where Sage Intacct enters the conversation: it is the platform we implement to support these four principles in practice, using funds and dimensions to structure financial information, tagging transactions at entry, maintaining clearer visibility over balances, and producing dimensional financial reports without rebuilding them in spreadsheets. Combined with the right finance processes and controls, that structure can support more continuous reconciliation and make board, funder, and acquittal reporting substantially easier.