All posts

Money & trust · 4 min read

HOA Financial Statements Template: Balance Sheet and Income Statement (Free Spreadsheet)

By Travis Sawyer ·

An HOA's financial statements show owners what the association has, what it owes and how the year went against the budget. For a small self-managed association, that's three short statements:

  • Balance sheet: what the HOA owns and owes on one date, split into operating and reserve money.
  • Income statement: the year's income and spending, next to the budget.
  • Reserve fund activity: how the reserve fund moved from the start of the year to the end.

This post covers the association's own statements. A statement of what one owner owes is a different document: that's an owner ledger, and it lives with your dues records.

Download the free HOA financial statements template (.xlsx). It works in Excel, Google Sheets and Numbers, with no macros. It's pre-filled with an illustrative 40-unit example, and it checks that the balance sheet balances and the reserve ties to reserve cash.

Rather not fill in a spreadsheet? GnomeOwner builds these statements from your bank statements, free.

What goes on an HOA balance sheet?

A balance sheet is a snapshot on one date, usually the last day of the year or month. Assets on one side, liabilities and fund balances on the other, and the two sides must match.

SectionTypical lines for a small HOA
AssetsOperating checking, reserve savings or CDs, assessments owners owe, prepaid bills such as insurance
LiabilitiesDues owners paid ahead, bills received but not yet paid
Fund balancesReserve fund, operating fund

Two lines confuse new treasurers:

  • Dues owners paid ahead are a liability. The association hasn't earned them yet.
  • Money owners owe is an asset, but it isn't cash. That's why the fund balance and your bank balance rarely match.

In the template's example, the association holds $18,400 in operating checking and $62,000 in reserve savings, is owed $1,350, prepaid $2,100 of insurance, and owes $2,100 in prepaid dues and unpaid bills. That leaves a $62,000 reserve fund and a $19,750 operating fund: last year's $20,960, less this year's $1,210 deficit.

What does an HOA income statement look like?

The income statement (also called the income and expense statement) covers a period, such as the year to date. The standard layout puts the budget, the actual amount and the difference side by side for every line. The template labels each difference as over or under budget, so no one has to decode a minus sign.

LineBudgetActualStatus
Regular dues$96,000$95,100$900 behind budget
Insurance$22,000$23,150$1,150 over budget
Repairs & Maintenance$8,000$9,320$1,320 over budget
Reserve contribution (transfer)$40,000$40,000On budget

Keep the reserve contribution on its own line, below operating expenses. Owners can then see that the reserve was funded as budgeted, even in a year when insurance came in high. In the example, that's what happened: the year ended with a $1,210 deficit, and the full $40,000 still went to reserves.

What is reserve fund activity?

Reserve fund activity tells the reserve's story in four lines: the beginning balance, contributions, interest and what was spent. In the example: $58,500 at the start, plus $40,000 contributed and $500 interest, minus $37,000 for a roof repair, leaves $62,000. That ending balance must match reserve cash on the balance sheet, and the template checks it for you.

If you have a reserve study, add its recommended balance to see how funded you are.

What goes in an HOA annual financial report?

For most small boards, the year-end package is the three statements plus a delinquency summary and short notes:

  1. Balance sheet
  2. Income statement, budget versus actual
  3. Reserve fund activity
  4. A delinquency summary: who owes and how long it's been
  5. Short notes, such as the accounting basis and any large one-time costs

The HOA treasurer report template covers the monthly version. The HOA budget template gives you the budget column.

Does state law require annual financial statements?

It varies by state, and many states set it by the association's size. Three examples:

  • Florida condominiums (Fla. Stat. 718.111(13)): the required report steps up with annual revenue: a report of cash receipts and expenditures under $150,000, then compiled, reviewed and audited statements, with audited at $500,000 and above.
  • North Carolina planned communities (G.S. 47F-3-118): an annual income and expense statement and balance sheet are made available to all lot owners within 75 days after the fiscal year ends.
  • California (Civ. Code 5305): a review by an independent CPA when gross income exceeds $75,000, distributed within 120 days after the fiscal year ends.

Other states differ. Virginia and Texas, for example, give owners the right to inspect records, and we found no annual-statement requirement there. Your governing documents can require more than the statute does. Our state pages list what we've verified for each state.

Cash basis or accrual?

Cash basis counts income when the money arrives. Accrual counts it when it comes due. Many small self-managed boards keep cash books because they match the bank statement. The template tracks money owed and dues paid ahead, which puts it close to accrual. If your state or documents require a specific basis, or a CPA review or audit, follow them.

Where GnomeOwner fits

GnomeOwner's Financial Report builds the balance sheet, budget versus actual and a reserve fund statement from your bank records, along with a delinquency list aged by days. It's included on the free plan, and you can print it or download CSVs for your accountant. See HOA accounting software for how the books get there.