How do we prepare a simple budget vs actual report for the board?
A budget versus actual report shows what you planned, what happened and the difference. It is the single most useful page a board can have.
Short answer: List each income and spending line with the budget, the actual for the period, the year to date and the difference. Add a sentence of explanation for the big differences, show grant balances separately, and end with the decisions you need from the board.
This is not tax, legal or accounting advice. It describes common practice. Where a rule depends on law, ask your adviser, and follow your own organization’s rules and your bank’s requirements.
The steps
Start from the approved budget
Use the budget the board approved. If it changed during the year, use the latest approved version and note the date.
Match your headings
Make sure the headings in your books match the headings in the budget. If they do not, create a simple map between them.
Pick the period
Decide whether the report covers the month, the quarter or both. Show the year to date every time.
Set out the columns
Line, budget for the year, actual for the period, actual year to date, difference and percent used. Keep the layout the same each time.
Fill in income
Show each income line, such as donations, grants, events and fees. Be careful not to count a grant as income twice.
Fill in spending
Show each spending line against its budget. Mark lines that are close to or over the limit.
Show the difference clearly
Use plain wording: under budget, over budget. Say whether the difference is a timing issue or a real change.
Show grants separately
For each grant, show the amount awarded, received, spent and left. See tracking grant money so you can report on it.
Add a note for big differences
One sentence each. Do not guess at causes you cannot support.
Mention the bank balance
Show the balance and say whether the reconciliation is done. See monthly bank reconciliation.
List decisions needed
For example: approve a budget change, move money between lines, or confirm a payment.
File it
Give the board a copy before the meeting and file the signed version with the minutes.
A small example (illustration, not real data)
| Line | Budget | Year to date | Difference |
|---|---|---|---|
| Donations | $30,000 | $17,500 | $12,500 left |
| Program costs | $22,000 | $13,800 | $8,200 left |
| Office and fees | $4,000 | $2,300 | $1,700 left |
Reading it together
Halfway through the year, a line near half used is on track. A line well ahead needs a conversation. A donation line behind plan may call for an appeal. The point of the report is to start the right conversation early.
Rules and advice
We do not give accounting advice. How your organization must present its figures to funders, regulators or the public depends on law and on your terms. Ask your adviser. For the questions boards should ask, see what a board should ask the treasurer each month.
Keeping it short
One page of numbers and a few lines of notes is enough. Attach details for anyone who wants them. Boards read short reports.
Common traps
Watch for income counted when promised but not received, costs counted twice, and grant money mixed with general funds. Check that the actual figures come from the reconciled books, not from memory. If a line looks wrong, trace one or two items back to their receipts before presenting it. A small check before the meeting saves a long discussion during it. Send the report a few days ahead.
Questions people ask
How often should the board see this?
Monthly or quarterly are both common. Choose what suits your board and keep to it.
What if we have no formal budget?
Make a simple one now. Even a rough plan gives you something to compare with, and the board can approve it.
Should the report include cash flow?
A short list of expected income and bills for the next two or three months is useful, especially if grants arrive in installments.