Book a Call
Send a Message

Schedule a Complimentary Consultation

Loading Calendly...

Book a Call
Send a Message

Schedule a Complimentary Consultation

Schedule time with Eric Saumure, CPA, CA to discuss your small business’s financial needs and business goals and how we can help you achieve them.

Join the Zenbooks Team

Sample Non-Profit Board Reporting Package with Variance Analysis (Excel Download)

An association was reporting a quarter-million-dollar surplus against a budgeted deficit, and nobody at the board table could explain how much of it was performance. Rebuilding the reporting package answered that, and surfaced two unfavourable revenue trends the headline number had been hiding.


Image

Download: Board reporting package, eleven months (anonymized) Six tabs: statement of operations with phased budget and forecast, statement of financial position, variance notes, basis and assumptions, and two general ledger appendices.

Download a Sample Non-Profit Board Reporting Package (Excel)

1. Client profile

A Canadian national not-for-profit member association with annual revenue of approximately $2 million to $5 million, operating on a fiscal year that does not end December 31. The association employs fewer than twelve full-time equivalent staff, holds no capital assets and carries no debt, and funds operations from three revenue streams: an annual national conference, membership dues, and investment income on a reserve portfolio held as a laddered guaranteed investment certificate portfolio. It reports to a volunteer board through a finance and audit committee, and is audited annually.

The complexity here is not scale. It is that almost every dollar of revenue is recognised on a schedule that has nothing to do with the calendar: dues and conference sponsorships for the coming year are billed in the final month of the fiscal year, and the conference itself falls just after year end. Straight-line reporting against that pattern produces numbers that are arithmetically correct and practically meaningless.


2. The decision or problem

The executive director asked: “Our statements show a surplus of almost $250,000 against a budget that said we’d lose money, and our bookkeeper says May will be a loss. Which is real? And why can the board never tell from these reports whether we’re actually doing well?”

Restated technically: how should an association with seasonally recognised revenue present eleven-month interim results so that a volunteer board can separate timing differences from permanent variances, assess how much of a favourable result reflects performance rather than unspent capacity, and rely on a forecast of the remaining period before the annual audit begins?


3. What Zenbooks Analysed

Budget phasing

The year-to-date budget column was rebuilt so that each budget line is phased across the year on its own recognition pattern rather than allocated evenly across twelve months. For an association whose conference revenue lands in a single month and whose dues are recognised across the year, a straight-line year-to-date budget generates large variances that reverse by year end and masks the ones that will not.

Comparative basis on the statement of financial position

The prior comparative column was changed from the last fiscal year end to the same date in the prior fiscal year. This is the single most consequential change in the package. Comparing an eleven-month balance sheet against a year-end balance sheet is not like for like: because dues and sponsorships for the following year are billed in the association’s final month, the year-end column always carries a deferred revenue balance that a mid-year column cannot. Under the original presentation, deferred membership dues appeared to have collapsed by more than $160,000 year over year. On a like-for-like basis the balance is near nil at that date in both years, and there is no variance at all. The board had previously been asked to interpret an artefact of the billing calendar as a decline in membership.

Contribution by program

Costs were separated into direct program costs and support and shared costs, allowing each program to be reported at a contribution level. Shared costs were deliberately left in a single support pool rather than allocated across programs.

Variance classification

Every material variance was classified as timing or permanent, favourable or unfavourable, and written up as a numbered note stating the dollar amount, the cause, and the management action. Notes are referenced directly from the line item on the statement, so a board member reading a number can reach the explanation in one step.

Forecast construction

The remaining month was forecast from individually stated assumptions, each with a documented basis, rather than by extrapolating a run rate. Where an assumption depends on something not yet committed, that is stated on the face of the assumptions tab.

Balance sheet and measurement review

The review covered the measurement basis of the investment portfolio against CPA Canada Handbook Part II Section 3856, the reconciliation of a GST/HST suspense balance that had crossed a fiscal year end, the composition of six payment clearing accounts, and the aged composition of accounts receivable.


4. What Zenbooks delivered

  • Summary statement of operations showing year-to-date actual, phased year-to-date budget, dollar and percentage variance, full-year budget, full-year forecast, forecast versus budget, and a note reference on every line.
  • Statement of financial position with like-for-like prior-year comparatives, the prior fiscal year end retained as a third reference column, a balance check that must return nil, and key position measures including working capital and current ratio.
  • Numbered variance notes, each stating amount, timing or permanent classification, cause, and management action.
  • Basis of preparation and forecast assumptions tab naming the reporting entity, fiscal year, basis of accounting, ledger extraction date, preparer, reviewer, and every forecast assumption with its basis and amount.
  • Two general ledger level appendices: budget versus actual by account, and a balance sheet by account, retained unchanged from the accounting system export for members who want to trace any summary line to its source.

5. A walkthrough of the reporting package, tab by tab

The full package is six tabs. Every figure below is reproduced from the anonymized sample, so the structure and the depth can be assessed without downloading anything.

Tab 1. Statement of operations, summary level

This first tab is the only page most board members will read closely, so everything on it has to earn its space. It carries a single summary line for each program rather than the roughly 130 general ledger accounts behind it, and it puts seven columns beside each line.

The first two columns are the ones that matter most. Year-to-date actual sits beside a year-to-date budget that has been phased, meaning each budget line is spread across the year on its own recognition pattern rather than divided by twelve. For this association that distinction is the difference between a useful report and a misleading one: conference revenue arrives in a single month, so a straight-line budget would show an enormous favourable variance for most of the year and an enormous unfavourable one at the end, and neither would mean anything.

The next block puts the full-year budget beside a full-year forecast, so the board can see not just where the association has landed after eleven months but where the year is going to finish. The right-hand column is the note reference. A board member who wants to know why conference direct costs are $164,000 under budget follows the number 4 to the notes tab and reads the answer, rather than asking the question at the meeting.

The subtotal worth pointing at is contribution from programs. Direct program costs are shown against the revenue that generated them, before any support or shared costs are brought in. That is as far as the association’s cost data honestly reaches, and pushing further would mean inventing an allocation.

Tab 1: statement of operations, eleven months, with phased budget, full-year forecast and note references on the face of the statement.

Tab 2. Statement of financial position, and why we compare April to April

This is the change that mattered most, and it is worth explaining slowly because it is the kind of thing that quietly misleads a board for years.

The report as it previously stood compared the eleven-month balance sheet against the last fiscal year end. That looks reasonable and is how most interim statements are built. For this association it is not like for like. Membership dues and conference sponsorships for the following year are invoiced in the final month of the fiscal year. That means the year-end balance sheet always carries a large deferred revenue balance representing money billed but not yet earned, and a balance sheet dated eleven months in cannot carry it, because the billing has not happened yet.

Look at what that does to a single line. Deferred membership dues stood at $1,100 at April 30, 2026. At the last fiscal year end they stood at $166,100. Compared that way, deferred dues appear to have collapsed by $165,000, which reads like a membership crisis. Compared against the same date in the prior year, where the balance was $4,200, the change is $3,100 and there is nothing there at all. The board had been asked, in effect, to interpret the invoicing calendar as a decline in membership.

So the prior-year column on this tab is April 30 of the prior year. The old year-end column is kept as a third reference column rather than deleted, because it still ties to the audited statements and people will look for it. The reason for the change is written on the face of the tab, not buried in a footnote, so that nobody has to reconstruct the logic next year.

Two other things on this tab are worth noticing. The commentary column sits inside the statement rather than in a separate memo, so the explanation of an unusual balance is attached to the balance. And near the bottom there is a check line that subtracts total liabilities and net assets from total assets and must return nil. It is a trivial formula and it is there because a board pack that does not balance should never reach a board.

Tab 2: statement of financial position on a like-for-like comparative basis, with inline commentary, a nil balance check, and key position measures.

Tab 3. Notes to the variances

This commentary is the part of the package that takes the time, and it is the part that separates a report from a printout. Every note follows the same four-part discipline: the dollar amount, whether the variance is timing or permanent, what caused it, and what management is doing about it. A variance without that classification is just a number that moved.

The distinction does real work here. A $17,700 favourable variance on research and policy is timing: the work was deferred, not cancelled, so the cost returns next year and the amount has to be carried into the next budget rather than banked as a saving. A $65,317 unfavourable variance on membership is permanent: dues are 99.8% recognised at the reporting date, so there is no remaining month in which it could recover.

Two notes on this tab are not variances at all, and they are included deliberately. One raises the measurement basis of the investment portfolio and asks the committee to confirm the portfolio holds no quoted equity instruments, which would trigger fair value measurement under Section 3856 rather than amortised cost. The other traces a suspense balance in the GST/HST accounts that has crossed a fiscal year end and notes, plainly, that the prior year balance indicates the reconciliation has been outstanding for more than one period. Writing that down in a document the board will read is the difference between a controller and a bookkeeper.

Tab 3: numbered variance notes, each classifying the variance and naming the management action. Notes 8 and 9 are committee items rather than variances.

Tab 4. Basis of preparation, assumptions and sources

This tab is the one nobody asks for and everybody needs. The top half states what the reader is holding: the reporting entity, the fiscal year, the basis of accounting, the date the general ledger was extracted, who prepared the package, who reviewed it, and which meetings it goes to. It also says, in plain terms, that these are unaudited internal management statements and are not general purpose financial statements prepared under Part III of the CPA Canada Handbook. A board should never have to guess what level of rigour sits behind a number.

The bottom half is the forecast, and it is built one assumption at a time. Each line names the amount and the basis for it, so a reader can disagree with a specific assumption rather than distrusting the whole forecast. The audit fee line is the clearest example: $24,000 is accrued in the closing month, and the basis states openly that no engagement letter is signed at the date of the report. That single disclosure tells the board the year-to-date surplus is overstated by that amount.

The last line is the one that answers the executive director’s original question. The closing month is forecast at a loss of $120,678, and the basis explains that this is a loss by design: dues are fully recognised before the closing month and the conference sits in the following year. The same month produced a loss of $75,493 the year before on exactly the same pattern. The surplus and the loss were both real, and they were never in conflict.

Tab 4: basis of preparation, followed by every forecast assumption with its amount and stated basis.

Tabs 5 and 6. General ledger appendices

These two appendices are deliberately unedited. One is budget versus actual by general ledger account across roughly 130 accounts, and the other is the balance sheet by account. Both are retained exactly as exported from the accounting system, which means every summary line on tab 1 and tab 2 can be traced to the accounts behind it by anyone who wants to check.

Keeping them raw is a choice. A tidied appendix is easier to read and impossible to verify.

Tab 5: general ledger appendix, retained unchanged from the accounting system export so every summary figure can be traced to source.

6. What the analysis showed

The reported year-to-date surplus was roughly $250,000 against a phased budget that anticipated a deficit, a favourable swing of approximately $445,000. Decomposing it changed the conversation substantially.

Composition of the favourable variance, eleven months, rounded


Component

Classification

Approx. effect

Conference direct costs below budget, principally renegotiated audio visual and an untriggered hotel room block attrition clause

Permanent, favourable

$164,000

Conference revenue above budget on delegate volume, not fee increases

Permanent, favourable

$143,000

Two positions vacant since the fourth month of the year

Permanent for the year, reversing next year

$112,000

Research and policy work deferred, not cancelled

Timing

$18,000

Audit fee not yet accrued at the reporting date

Overstatement of the interim surplus

($24,000)

Events and training program, cancelled mid-year

Permanent, unfavourable on revenue, largely offset on cost

($89,000)

Four conclusions followed from that decomposition.

Roughly a quarter of the favourable variance was unspent capacity, not performance. Two vacant positions the association had budgeted and intended to fill accounted for approximately $112,000. That is not a saving. It is a year of work the association planned to do and did not do, and the cost returns as soon as the roles are filled. Reported as a favourable variance without that framing, it invites a board to treat a staffing gap as good news.

The interim surplus was overstated. The full annual audit fee was unaccrued at the reporting date because the audit had not yet been engaged. Once accrued, the surplus falls by that amount, and the assumptions tab now carries it explicitly rather than leaving it to be discovered at year end.

Two permanent unfavourable revenue trends were running underneath a favourable headline. Membership revenue was almost entirely recognised at the reporting date, so the shortfall was not a timing difference. Paid membership had fallen year over year and average dues per member had fallen alongside it as organisations moved into smaller-organisation dues categories. Both count and mix moved against the association at the same time, which is a different problem from either one alone and calls for a different response. Separately, the events and training program had been suspended mid-year after early registrations came in at roughly a quarter of plan.

The conference was materially healthier than budget suggested, on volume rather than price. Contribution margin on the conference improved to 46.7% from 41.8% the previous year. Delegate volume set a record while the registration fee was unchanged. The recommendation was to build the following year’s budget off a delegate number below the record rather than at it, until the trend repeats.

Three items were raised to the finance and audit committee that were not variances at all: the measurement basis of the reserve portfolio, a GST/HST suspense balance that had carried across a fiscal year end and had therefore been outstanding for more than one reporting period, and an overdrawn payment clearing account under reconciliation.


7. What Zenbooks deliberately did not do

Scope decisions are part of the work, and each of these was made for a reason.

  • No assurance. These are unaudited internal management statements for board and committee use. They are not general purpose financial statements prepared under Part III of the CPA Canada Handbook, and no audit or review conclusion is expressed on them.
  • Shared costs were not allocated to programs. A fully allocated program profit and loss is easy to produce and would have made the package look more sophisticated. It was rejected because the association’s underlying cost data does not support a defensible allocation driver, and a program margin built on an arbitrary driver invites boards to make program decisions on a number that is largely an assumption. Contribution above direct costs is the furthest the data honestly reaches.
  • Prior periods were not restated. The comparative basis was corrected going forward and the change was disclosed on the face of the statement, rather than reissuing previously presented reports.
  • The investment portfolio was not valued. The measurement basis was confirmed as consistent with a laddered guaranteed investment certificate portfolio carried at amortised cost. The question of whether the portfolio holds any quoted equity instruments, which would require fair value measurement, was put to the committee to confirm rather than concluded on by the preparer.
  • The following year was not forecast. The engagement covered the remaining month of the current fiscal year. Recommendations for the following year’s budget were stated as recommendations, not modelled.

8. Why the work was complex

The engagement involved seasonally recognised revenue across a non-calendar fiscal year; deferred membership dues and deferred conference sponsorship billed in the month following the reporting date; a conference falling in the subsequent fiscal year with prepaid deposits already carried as an asset; budget phasing by recognition pattern rather than straight-line allocation; contribution reporting requiring the separation of direct program costs from support and shared costs; a laddered guaranteed investment certificate portfolio carried at amortised cost with a measurement question under CPA Canada Handbook Part II Section 3856; a GST/HST suspense reconciliation spanning a fiscal year end and sitting in a net recoverable position inside liabilities; six payment processor clearing accounts including one overdrawn and one denominated in United States dollars; a foreign currency accounts payable account and a resulting exchange loss; accrued professional fees affecting the comparability of an interim surplus; aged accounts receivable concentrated in conference sponsorship and exhibitor billing; and a one-month forecast built from individually documented assumptions rather than run-rate extrapolation.

9. Links, services and supporting sample

Relevant services

Related case studies

Supporting work sample

The full reporting package is available below, anonymized. Figures have been rounded and identifying details altered or removed to protect client confidentiality. The sample is provided so that the structure and level of detail described above can be verified; it is not a template for use without professional advice.


Download: Board reporting package, eleven months (anonymized) Six tabs: statement of operations with phased budget and forecast, statement of financial position, variance notes, basis and assumptions, and two general ledger appendices.

Includes:

✓ Executive board reporting

✓ Statement of Operations

✓ Statement of Financial Position

✓ Budget vs Actual analysis

✓ Management variance commentary

✓ Accounting assumptions

Download a Sample Non-Profit Board Reporting Package (Excel)

The work described is bookkeeping, accounting and management reporting. It is not an audit, review or other assurance engagement, and no assurance is expressed on the figures described. Client details have been altered and figures rounded to protect confidentiality. This page describes one engagement and is not a representation that comparable results are available in other circumstances.


Business Clarity That Helps You Breathe Easy

Achieve your business goals and peace of mind with Zenbooks. As both your finance team and business advisor, we empower you every step of the way.