Nonprofit Budgeting for Restricted Funds in Canada

A nonprofit budget is not one number. It is a set of commitments, each tied to a fund, a funder, or a program, and each with its own rules about how the money can be spent.

That is why a budget built like a business budget tends to let nonprofits down. The totals can look healthy while one restricted fund is overspent. This post covers nonprofit budgeting by fund: how to budget restricted funds, build grant budgets that line up with funder reporting, and track budget against actual without rebuilding the numbers every month.

Why a Nonprofit Budget Starts With Funds

A business budget mostly answers one question: will we make a profit? A nonprofit budget answers a different one: are we using each dollar the way the donor or funder said we could?

A board wants to know the organization is sustainable. A funder wants to know its grant was spent as agreed. Both answers depend on seeing the budget by fund, not only in total.

Start by listing every source of money you manage and the rules attached to it. Three views matter:

• By fund: unrestricted money you can use broadly, and restricted money tied to a purpose.
• By grant: each agreement, with its own approved budget, period, and reporting format.
• By program: what it costs to deliver each service, including a fair share of shared costs.

Your budget should roll up cleanly from any of these views. If it only works in one, someone ends up rebuilding it by hand when the board or a funder asks a different question.

Budgeting for Restricted Funds

A restricted contribution comes with a condition. The money has to be used for a stated purpose, often within a stated period. Budgeting for it means treating that money as its own budget, not as a line inside the operating budget.

How you account for contributions matters too. Under the standards for not-for-profit organizations in Part III of the CPA Canada Handbook, an organization that applies fund accounting can use either the deferral method or the restricted fund method. Your auditor will have settled which one you follow, and your budget should be built on the same one so budget and actuals compare cleanly.

The Accounting Standards Board has been reviewing how contributions are recognized, so confirm the current rules with your auditor before you build or change a budget structure.

Either way, you still have to track restricted contributions so they are spent as intended. A practical approach:

1. Set up each restricted fund as its own budget, with its own revenue and expense lines.
2. Record the restriction and the end date alongside the budget, not in an email thread.
3. Allocate shared costs such as rent and administration across funds using a method you can explain, and check what each funder allows.
4. Review the remaining balance on a regular schedule, not only at year-end.

Building Grant Budgets That Match Funder Reporting

A grant budget is a commitment in the funder's own format. The categories, reporting periods, and rules on moving money between lines come from the agreement, and your chart of accounts rarely matches them.

Build the grant budget in the funder's categories first, then map those categories to your accounts. Done at the start, the funder report becomes a view of data you already have instead of a rebuild.

For each grant, confirm four things before you finalize the budget:

• The approved budget categories
• The reporting dates
• Whether you can move money between categories, and by how much
• Which costs are eligible, including administration

If you manage several grants, a one-page summary of these four items for each agreement saves a lot of searching later and makes grant budget tracking easier.

Budget vs. Actual by Fund

A budget is only useful when you compare it to what happened. For a nonprofit, the comparison that matters is by fund and by grant, not only in total.

A total can show you are under budget while one restricted fund is overspent and another has money sitting unused. Totals hide both.

A useful budget vs. actual report shows, for each fund or grant:

• The approved budget
• Actual spending to date
• The remaining balance
• The end date of the funding period

Run it monthly. A board that sees the same report each month spots problems while there is still time to act. A report that only appears at year-end can only explain what already happened.

Where Spreadsheets Break Down

Most nonprofit budgeting starts in spreadsheets, and for an organization with one or two funding sources that can work well. The trouble starts as funds, grants, and people multiply.

Researcher Raymond Panko has collected the results of field audits of real-world spreadsheets. In the five studies that used the strongest methods and reported only serious errors, 91% of the 55 spreadsheets examined contained important errors. Those were business spreadsheets, not nonprofit budgets specifically, but the pattern is a fair warning.

In a nonprofit budget spreadsheet, the failure points are usually practical:

• Several versions circulate by email, and nobody is sure which is current.
• Formulas are overwritten or break when rows are added.
• Budget and actuals live in separate files, so someone re-keys data each month.
• Restrictions and end dates are tracked from memory, not in the model.

None of this means a spreadsheet is the wrong tool for everyone. It means the cost of keeping one accurate rises with every fund and grant you add. If your team is already re-entering the same data, our post on when to upgrade your nonprofit's accounting software covers other signs.

What a Budgeting System Needs to Handle

If you move budgeting out of spreadsheets, the system has to do more than store numbers. For a nonprofit, look for these:

• Budgets by fund, grant, and program from the same underlying data.
• Budget and actuals in one place, with no re-keying.
• Version control and access, so everyone works from the current budget and changes are tracked.
• Restriction and period tracking, with balances visible as they change.
• Reports a board can read without waiting on finance.

A multi-dimensional chart of accounts is what makes this practical. Instead of building a separate account for every combination, each transaction carries tags, called dimensions, so the same data can be reported by fund, grant, or program. Sage Intacct is built this way, and our nonprofit solutions page covers its Grants Tracking and Billing capability.

Forecasting is a separate question from budgeting, and we cover it in our post on the Sage Intacct Planning module. If you are weighing software options more broadly, start with how to choose nonprofit accounting software in Canada.

Next Step

If you want to talk through how your budget is built today, book a 20-minute call with Rob Greeno. We will look at how your funds, grants, and programs are set up, and whether your current approach can keep up.