Free — no signup, no email required

Financial Report Template

All three reports, set up for a small association, with sample line items and the variance column already built in — so you're not starting from a blank spreadsheet.

Download Excel workbook Download PDF

The Excel workbook is the fill-in version — formulas and print setup included. The PDF is generated from the same workbook, so the two never disagree. Nothing is sent to us either way.

Most months, almost nobody reads the financial reports, and a lot of small boards stop producing them for exactly that reason. But owners were never the audience that matters most. The real audience shows up when someone sells: the buyer’s lender asks for the reserve balance, the budget and how many owners are behind on dues, and the financial statements are how they check those numbers. An association that doesn’t have them can look like a risk.

This template is the three reports the video walks through, set up for a small association and laid out so they can be produced from bank statements in a spreadsheet — no accountant required. The line items are labelled and the formulas are built; the numbers are yours.

Three reports, three questions

The income statement answers how much the association collected and how much it spent over a month or a quarter. What it doesn’t show is how much money the association has — it can take in more than it spent this month and still not have enough saved for a new roof.

The balance sheet is a snapshot of one day, usually the last of the month: what the association owns, what it owes, and the difference — the fund balance. This is where the reserve balance sits, and the first number a lender asks for.

Budget vs actual puts the budget you adopted next to what you actually spent, line by line, and answers one question: are we on track? Say insurance was budgeted at $12,000 and the renewal came in at $14,000. This report shows it the month it happens, while there is still time in the year to adjust, instead of at year-end. It also answers most of what owners ask — why dues went up, where the money went, whether an assessment is coming.

The same template, every month

The value is in comparing this month to last month, so the categories have to stay the same and sit in the same place. The expense lines match the Budget Worksheet, so what you budget there is what you report against here. Monthly is the cadence that makes budget vs actual useful; a very small association with simple books can get by quarterly. And when a new treasurer takes over, they pick up the same template and the same process.

Check it, then send it

The last tab is the part most boards skip. Before anything goes out, a cheap first pass is to drop the reports into ChatGPT or Claude and ask it to look for problems — totals that don’t add up, reports that disagree, something miscategorized. Treat it as a first pass, not a sign-off, and take out owner names and account numbers first. If nobody has ever looked at the books professionally, a one-time CPA review gives the next board a clean starting point.

Then email the reports to every owner, with a few sentences on top for the few who open it. What matters is that each one went out, with a date on it, so that when a lender or an attorney asks later, nothing has to be recreated.

When an owner asks to see the books

Owners have a right to see these records, and many states spell it out. In Illinois, an owner can make a written request; the association keeps its books for the current fiscal year and the ten before it, and if the records aren’t made available within ten business days, the law treats that as a refusal. A board producing three clean reports every month, with a sent log to show for it, can answer that request quickly.

Not legal advice. Your state’s rules will differ — check your statute and your governing documents.

Who it's for

Treasurers of small self-managed associations who have never produced monthly reports, and boards that want the same template to outlast whoever is treasurer.

What's inside

Every section, so you know before you download

1 · Income statement

Everything the association took in and everything it spent, in the same categories as the Budget Worksheet, with the reserve contribution on its own line. This period, last period, the change and year to date — and the net before and after the reserve contribution.
2 · Balance sheet

What the association owns and owes on one day: the operating and reserve accounts, anything paid ahead, assessments owners still owe, unpaid invoices, loans and assessments paid in advance. The difference is the fund balance, against last month-end.
3 · Budget vs actual

Enter the annual budget once and the months completed; budget to date, the variance and the variance % calculate. An Over or Short flag marks the lines running off plan, beside a one-line 'why' for the summary.
4 · The email, top to bottom

The headline, what's running over and why, answers to last month's repeat questions, and the three reports attached underneath.
Five checks before you send

The totals add up, the three reports agree with each other, nothing is miscategorized, owner names and account numbers are out before anything goes to an AI tool, and a one-time CPA review if nobody has ever done one.
The sent log

One row per period: what it covered, the date it went out, who it went to and where the copies are kept. That date is the paper trail.

Formats: Excel · PDF Updated: October 23, 2026

Related episode

Nobody Reads Your HOA Financial Reports. Except the Lender.

This worksheet accompanies an episode of HOA Essentials, our video series for self-managed boards.

Watch the episode →

Next step

Found gaps while filling this in?

The Building Health Score asks your board the same kind of questions across six areas — reserves, governance, maintenance and more — and tells you where you actually stand. Free, and about ten minutes.