If your finance team keeps a spreadsheet beside the accounting system just to answer “how much of the education agreement is left?”, you are already doing fund accounting by hand. The right ERP setup does that work for you, and it makes year-end and funder reporting far less painful.
What fund accounting is
Most businesses track one pool of money. A First Nation, education authority or non-profit tracks many: money for education, health, housing, capital projects and band-owned revenue, often each with its own rules about how it can be spent and when it must be reported. Fund accounting keeps each of those pools separate, so you can show every funder exactly what came in, what went out and what is left.
Which rules apply to you
| Organization | Accounting standards | What it means day to day |
|---|---|---|
| First Nations, Tribal Councils and First Nations political organizations | Canadian Public Sector Accounting Standards (PSAS) | Audited consolidated statements, usually with a schedule for each fund or program, plus the reporting each funding agreement requires. |
| Non-profits and charities | Accounting Standards for Not-for-Profit Organizations (ASNPO) | A choice between the deferral method and the restricted fund method for restricted contributions. |
Indigenous Services Canada expects First Nations to follow the Public Sector Accounting Standards. Non-profits using fund accounting can choose either method: under the deferral method, restricted money is held as deferred revenue until it is spent; under the restricted fund method, it is recorded as revenue in its own restricted fund when received. Your auditor should confirm which approach fits your organization.
What your ERP needs to track
- A fund or program dimension on every transaction. Each entry should carry the fund and program it belongs to, not just a general ledger account. That lets you report by fund without rebuilding your chart of accounts.
- Funding agreements as their own records. Amount, start and end dates, reporting dates and eligible costs. Multi-year agreements need to roll forward cleanly.
- Deferred revenue and carry-forwards. Money received this year for next year’s work should not look like a surplus.
- Interfund transfers with a clear trail. When one program covers another’s costs for a while, the system should record it and show it at year-end.
- Capital assets by fund. Schools, vehicles and equipment bought with restricted money need to be tracked and amortized against the right fund.
- Budget versus actual for each fund. Program managers should be able to see their own numbers without asking finance for a report.
- Approval workflows and role-based access. Funders and auditors ask who approved what, so the system should record it.
Signs you have outgrown your current setup
- Year-end takes weeks of reconciling spreadsheets before the auditor can start.
- Program managers cannot see their remaining budget without asking finance.
- You re-key the same numbers into several funder reports.
- Only one person knows how the allocations work.
Questions to ask before choosing or changing an ERP
- Can it tag every transaction by fund and program, and report on both?
- Does it handle multi-year agreements and deferred revenue without manual journal entries?
- Can it produce the fund schedules your auditor expects, or export cleanly to them?
- How will historical data move over, and who checks it?
- Where is the data stored, and how is it backed up? See our 3-2-1 backup guide.
- What training is included for finance staff and program managers?
Related reading
- Cybersecurity checklist for small schools and First Nations education authorities
- School data backups: the 3-2-1 rule in practice
Need help with your ERP?
A+ IT Services helps First Nations, education authorities and non-profits in Alberta and Manitoba set up and support ERP systems, from chart of accounts design to staff training. Learn more about our ERP services, call or text (825) 966-7690, or send us a message.
This article is general information, not accounting advice. Confirm your reporting requirements with your auditor and funders.