HOA Chart of Accounts: How to Set One Up (Free Template)

HOA Accounting · Free Template

An HOA chart of accounts is the list of categories every dollar gets sorted into. When it matches the budget and keeps operating and reserve money apart, monthly reports almost write themselves. Below is how to set one up, plus a free template with 67 accounts you can download and adapt.

Free download: HOA chart of accounts template (Excel). Account numbers, names, types, the fund each account belongs to, and a note on when to use it.

What makes an HOA chart of accounts different

A regular business tracks one pool of money. An association tracks at least two: the operating fund for this year’s costs and the reserve fund for major repairs and replacements. The chart of accounts has to keep them apart all the way through, from the bank accounts to the income to the expenses. See operating funds vs reserve funds for why that matters.

How the numbering works

Most charts follow the same pattern, and our template does too:

  • 1000s, assets: operating and reserve bank accounts, money owners owe, prepaid insurance.
  • 2000s, liabilities: unpaid bills, owners who paid ahead, taxes owed.
  • 3000s, fund balance: one balance for operating, one for reserves.
  • 4000s, income: dues, special assessments, late fees, interest, other income.
  • 5000s, operating expenses: administration, insurance, utilities, repairs and maintenance.
  • 6000s, reserve expenses: one account per major component in your reserve study.

Leave gaps between numbers (1000, 1010, 1100) so you can add accounts later without renumbering.

Income accounts: split them out

Lumping all income into “Dues” is the most common mistake we see. Split it:

  • Regular assessments, operating share, and reserve contribution as two accounts. This shows owners exactly how much of their dues went to reserves.
  • Special assessments on their own line, so they never blend into regular dues. See HOA special assessments.
  • Late fees and fines separately. Your collections policy decides how they’re charged.
  • Interest, by fund. Reserve interest belongs in the reserve fund.
  • Non-member income, like clubhouse rentals to the public, laundry or a cell tower lease.

That split matters at tax time. To file Form 1120-H, at least 60% of gross income has to be dues, fees or assessments from owners. Interest and non-member income don’t count toward that, so you want them easy to find. See Form 1120-H vs Form 1120, which also covers the short-term rental rule that can push resort buildings onto Form 1120.

Expense accounts: match the budget

Every line in the budget should have its own account, and the names should match. When they do, the monthly budget-vs-actual report lines up with no extra work. Group expenses the way boards think about them:

  • Administrative: management, accounting, tax and CPA fees, legal, bank fees, software, registration.
  • Insurance: property, D&O and fidelity, liability.
  • Utilities: electricity, gas, water and sewer, trash.
  • Repairs and maintenance: landscaping, snow removal, building repairs, elevator, pool, janitorial.

In mountain communities, give snow removal its own line and budget for a heavy winter. It’s often one of the biggest swings from year to year. Our guide to building an HOA budget covers mountain-town costs.

Reserve accounts: follow the reserve study

Name reserve expense accounts after the components in your reserve study: roofing, paving, siding, decks, boilers. When a project is done, the cost lands in the matching account, and the board can compare spending with the study. Keep routine repairs in operating. Only major repairs and replacements go to reserves. See Colorado HOA reserves.

Five mistakes to avoid

  1. One bank account for everything. Reserve money gets spent on operations without anyone deciding to.
  2. Interest recorded in one place. You can’t tell which fund earned it.
  3. Special assessments posted as dues. Owners can’t see where the money went.
  4. A chart that doesn’t match the budget. Every month someone rebuilds the budget report by hand.
  5. “Miscellaneous” accounts that grow. If something happens every year, it deserves its own account.

Changing your chart of accounts

The cleanest time to change is at the start of a fiscal year. Map every old account to a new one, move the balances with one journal entry, and keep the map with your records so prior years still make sense. If you’re changing accountants at the same time, see how to switch HOA accountants mid-year.

New to the reports themselves? Read how to read your HOA’s financial statements, or start with HOA accounting: the complete guide.

This is accounting education, not legal or tax advice. Your governing documents and your CPA’s reporting choices come first.

FAQ

What is an HOA chart of accounts?

It’s the list of accounts an association uses to sort its money: bank accounts, receivables, fund balances, income and expenses. It should match the budget and keep operating and reserve accounts separate.

Should reserve contributions be a separate income account?

Yes. Splitting dues into an operating share and a reserve contribution shows the board and owners exactly how much went to reserves each month.

Where should interest income go?

Record it by fund: operating interest in operating, reserve interest in reserves. Interest is usually taxable, so keeping it separate also makes the tax return easier.

Is the template free?

Yes. Download it, rename accounts and add or delete lines to match your budget.

Does QuickBooks work for an HOA chart of accounts?

It can. Use classes or separate accounts to keep operating and reserve activity apart. The account structure in the template works in QuickBooks and in most HOA software.

Do we have to switch software to work with you?

No. We work in AppFolio, Vantaca, Buildium, CINC, QuickBooks and most other systems. Nine times out of ten we set up the chart of accounts in the software you already use. The board stays the signer on the bank accounts, and we never hold association funds.

Want us to set it up for you?

We’re a Colorado-based accounting firm for HOAs, condo associations and property managers, and we work with associations in any state. We set up the chart of accounts in the software you already use, keep the books and send board-ready financials every month. Your board stays the signer on its accounts.

HOA accounting starts at $200/month. No long-term contract.

Book a Call

Get a free estimate · (970) 633-3997

Sources