Financial Oversight

The Fund Change Roll-Forward: The One Number That Tells You Whether the Year Worked

CIC-SC Editorial Team··~8 minutes read

The Bottom Line

The fund balance roll-forward — beginning balance, plus revenue, less expenses, plus or minus transfers, equals ending balance — is the only statement that answers whether the association got richer or poorer. Read it one fund at a time, because a combined total can look healthy while the Operating Fund bleeds. Then run one test on the result: would the deficit disappear at full collections, normal costs and no surprises? If not, you do not have a bad year. You have a bad budget, and next year will not fix it.

The statement your board is not reading

Most boards read the income statement, note the variances, and adjourn. The income statement is a good document for the question it answers, which is: what did we earn and spend during this period? It is not built to answer the question the board actually has, which is: did this year leave the association better off or worse off than it started?

That question belongs to a different statement. The fund balance roll-forward starts with what the association had at the beginning of the year, adds everything that came in, subtracts everything that went out, accounts for money moved between funds, and lands on what the association has now. It is four lines and a subtraction. It is also the only page in the packet that measures the thing the board is actually responsible for.

Two features make it uncomfortable, which is probably why it goes unread. It nets the transfer to reserves into the result, so the operating surplus a board is proud of frequently turns out to be a deficit once the reserve contribution is counted. And it cannot be explained away by a variance narrative, because it is a stock, not a flow. Either the number at the bottom is bigger than the number at the top or it is not.

Magnolia's two funds, walked separately

Magnolia Recreational HOA runs two funds — an Operating Fund and a Reserve Fund — and the roll-forward has to be run on each of them independently before it is run on the pair.

Magnolia Recreational HOA is a composite illustration built for the FOAM series. The community, its vendors, and its financial institutions are fictional; the structures and the arithmetic are real.

Operating Fund — FY2025Amount
Beginning fund balance (1/1/2025)$148,000
Assessments — residential (41000)$1,224,000
Other income (42100–42900)$61,400
Total revenue$1,285,400
Operating expenses (51100–55700)($1,129,800)
Transfer to Reserve Fund (49000)($180,000)
Change in fund balance($24,400)
Ending fund balance (12/31/2025)$123,600
Reserve Fund — FY2025Amount
Beginning fund balance (1/1/2025)$1,470,800
Reserve assessment allocation (48000)$180,000
Interest income — reserve (48500)$56,000
Pool resurfacing (58100)($84,500)
Playground surfacing (58200)($22,300)
Change in fund balance$129,200
Ending fund balance (12/31/2025)$1,600,000

Magnolia budgeted a $9,000 operating surplus for FY2025 and finished $24,400 in the hole. The gap is $33,400, and it came from two places: other income landed at $61,400 against a $66,000 budget, and operating expenses landed at $1,129,800 against a $1,101,000 budget. Neither miss is large. Neither would have produced a dramatic month. Together they turned a planned surplus into a real deficit, and the Operating Fund ended the year with $24,400 less in it than it started.

$1.5M $1.0M $500k $0 $148.0k +$1,285.4k −$1,129.8k −$180.0k $123.6k Beginning Revenue Op. expenses Reserve transfer Ending Change in fund balance: −$24,400
Figure 1. Magnolia's operating year is two enormous, nearly equal flows. What survives the collision is a residue of $123,600 — smaller than the $148,000 the association started with. The residue is the only part of this picture the board is accountable for.

The combined number is the one that lies

Presented as a single line, Magnolia had a good year. The two funds together started at $1,618,800 and ended at $1,723,600, a combined increase of $104,800. A board looking at that number would reasonably conclude that the association is building financial strength.

It is not. The entire increase, and more, came from the Reserve Fund, which grew because the Operating Fund gave it $180,000 and because it collected $56,000 of interest on money contributed in prior years. Strip that out and what is left is an Operating Fund that consumed $24,400 of accumulated balance to deliver twelve months of service it billed $1,224,000 for. The combined presentation does not report that. It absorbs it.

+$100k +$50k $0 −$25k As the packet presents it As the year actually went +$104,800 −$24,400 +$129,200 Combined fund change Operating Fund Reserve Fund
Figure 2. The same twelve months, presented two ways. The combined bar is not wrong; it is just useless. It reports that money moved from a pocket that is now empty into a pocket the board is not allowed to spend from.

The transfer that never moved

There is a second thing hiding in the reserve column, and boards find it late or never. A transfer between funds is a bookkeeping entry. It becomes cash only when someone actually moves the money between two bank accounts.

Magnolia's Reserve Fund shows a $180,000 allocation received. Its bank statements show $135,000 arriving from the operating account. The remaining $45,000 sits on the reserve balance sheet as a receivable from the Operating Fund — an amount owed, from a fund that just lost $24,400 and holds $123,600. Read plainly: the Reserve Fund's $1,600,000 is not $1,600,000 of cash and certificates. It is $1,555,000 of cash and certificates plus a $45,000 IOU written by a debtor whose income does not cover its costs.

The common error. Treating the reserve allocation as funded because the general ledger says it was made. Ask for the reserve bank statements and the interfund receivable balance at every meeting where the reserve is discussed. If the two funds are pooled in one bank account, ask your accountant what evidence exists that the reserve is not being used as operating working capital.

The structural-versus-cyclical test

A deficit is either bad luck or bad arithmetic, and there is a clean test that tells you which. Macroeconomics distinguishes a cyclical deficit — one caused by a downturn, which reverses when conditions return to normal — from a structural deficit, which persists even at full employment because the commitments simply exceed the revenue. The distinction is textbook (Case, Fair and Oster, ch. 14) and it translates to an association without modification.

The association version is a single question: would this deficit disappear at full collections, normal costs, and no surprises? Run it by taking the reported fund change and reversing only the things that genuinely will not recur. Everything you cannot honestly call bad luck stays.

FY2025 Operating Fund — the structural testAmountBad luck?Adjustment
Reported change in fund balance($24,400)
51200 Landscape extras and storm cleanup above budget$13,900 overYes — weather+$13,900
55300 Insurance renewal$9,400 overNo — it repriced, and it reprices again$0
51300 Irrigation repairs on a twenty-year-old system$8,426 overNo — fourth consecutive year over$0
42300 Amenity center rentals$4,600 underNo — the line has missed three years running$0
52400 / 55600 Favorable variances from budgeted work not performed$10,500 underNo — the work is still owed−$10,500
55700 Bad debt, booked at the budgeted $30,000 while actual delinquency ran 6.0% of the roll$0 varianceNo — the budget was wrong, not the year$0
Deficit at normal weather and work actually performed($21,000)
Figure 3. Strip out the bad luck and Magnolia still loses $21,000. That is the structural deficit — the amount by which the budget, as designed, does not cover the community as it exists. Spread across 1,200 lots it is about $17.50 a year. It is not large. It is permanent. And note the last row: because the association booked bad debt at the budgeted $30,000 rather than at the 6.0% its aging report says it actually lost, the reported deficit understates the year by a further $43,440 of cash that was billed and never arrived.

Two rules make this test honest. First, a favorable variance is not automatically good news: $10,500 of underspending on courts and playground maintenance and on community events is $10,500 of work the association promised and did not deliver, so it gets added back as a cost, not banked as a saving. Second, a line that has missed in the same direction for three or four consecutive years is not a surprise. It is a forecast error the budget keeps repeating, and reversing it would be dishonest.

If the deficit survives the test, the association does not have a bad year. It has a bad budget, and next year will not fix it. Most of what the industry files under "underfunded reserves" is a structural deficit that a board has spent five or six years treating as cyclical — "we will catch up next year," annually, until the roof fails.

The misdiagnosis is easy to make and hard to notice, because a structural deficit produces the same evidence as a cyclical one in any given twelve months. There is always a storm, always a renewal, always a quarter where the rentals disappointed. What separates the two is not the evidence in front of the board; it is whether the same explanation was available last year, and the year before. A cyclical deficit has a cause that changes. A structural deficit has a cause that repeats and a story that changes.

Zero is the target

The instinct a board brings from business is that a surplus is a win and a bigger surplus is a bigger win. Managerial accounting encourages this: the net profit margin is taught as a ratio where higher is better (Garrison, ch. 15). For an association, that interpretation inverts, and it is worth saying out loud that we are inverting it.

An association does not sell anything. It bills its members the cost of running the community and then runs the community. A large operating surplus therefore means one of exactly two things. Either the association over-billed its members and is holding money that was theirs, or it took the money and did not do the work it billed for. A $60,000 surplus at Magnolia is not $60,000 of strength. It is $50 per lot that should not have been collected, or $60,000 of maintenance that did not happen. Both are alarms; they simply point in opposite directions.

Zero is the target, plus or minus a deliberate contingency the board sets on purpose and can defend. The reserve contribution is not the residue left over after a good year. It is a cost, budgeted above the line, and a year that "balanced" only by leaving it short did not balance.

One year is an anecdote. Five years is a case.

Any single year's fund change can be explained away, and it usually is. Trend analysis is the standard remedy: place the same line side by side across several periods and let the direction speak (Garrison, ch. 15, horizontal analysis). It is the lowest-effort technique in the entire discipline. It requires no new data — only a second, third and fourth column of numbers the association already has.

+$10k $0 −$10k −$20k −$30k +$4,200 −$8,600 −$11,900 −$17,300 −$24,400 FY2021 FY2022 FY2023 FY2024 FY2025 Cumulative five-year change in the Operating Fund: −$58,000
Figure 4. No single one of these years was alarming enough to act on, and each was explained at the time. Together they are a straight line pointed at the floor, and they have removed $58,000 from the fund that pays the vendors.

This is also the practical reason to keep the trend. The year-over-year fund-change deficit is what builds the case for an assessment increase, and a board that walks into the annual meeting holding a single year loses that argument every time. One year invites the counter-argument — it was the storm, it was the insurance renewal, it was a bad quarter for rentals — and the counter-argument is always available, because in any single year it is always partly true. Five consecutive years of the same-signed deficit cannot be attributed to weather, and owners can see that for themselves. The chart makes the argument; the board only has to stand next to it.

What to do with this

  1. Ask for the roll-forward, per fund, on the monthly packet. Beginning balance, revenue, expenses, transfers, ending balance — one column for the Operating Fund, one for the Reserve Fund, and only then a combined column. Many management systems produce this on request; it is a report setting, not a project.
  2. Reconcile the reserve transfer to the reserve bank statement every month. Compare the amount booked to the amount that actually moved, and ask for the interfund receivable balance as a standing line in the treasurer's report.
  3. Run the structural test once, in writing, at budget time. Take the current year's fund change, reverse only what genuinely will not recur, add back favorable variances that represent work not performed, and record the residue. That residue is the number the budget has to solve.
  4. Put five years of fund change on one page and keep it in the budget packet permanently. It costs nothing to maintain and it is the only exhibit that survives a room full of people who each remember one year.
  5. Stop celebrating the surplus. Ask what was over-billed or what was not done, and ask the same question about a deficit. Set an explicit contingency target instead, and measure against that.
  6. Take the results to the association's accountant before drawing conclusions about basis of accounting, interfund balances, or how any of it should be presented. What is described here is how to read the statement, not how to prepare it.

Sources and further reading.

  • Case, Fair & Oster, Principles of Macroeconomics, 13th ed. (Pearson, 2020), ch. 14 — the distinction between cyclical deficits, which reverse with conditions, and structural deficits, which persist even when conditions are normal.
  • Garrison, Noreen & Brewer, Managerial Accounting, 16th ed. (McGraw-Hill, 2018), ch. 15 — horizontal (trend) analysis, and the conventional reading of margin ratios in a for-profit setting, which an association must deliberately invert.

Notice: CICSC provides educational resources, governance standards, and practical advisory support. CICSC does not provide legal advice, accounting advice, tax advice, engineering advice, insurance advice, or reserve study services. Board members and associations should consult qualified professionals for matters requiring professional judgment or legal interpretation.