Running an HOA on spreadsheets: what works, what breaks, and when to switch

Updated Oct 20, 2026 · rules checked against state statutes and the IRS

A spreadsheet can run a small HOA's dues list and budget for free, and many self-managed boards start there. Spreadsheets break on what the law and the IRS expect: separate operating and reserve funds, owner-ready financial statements, records kept for years, and the income split behind Form 1120-H. HOA software that does those starts at $399 a year.

Kahoa makes HOA software, so we have a side. The rules below link to the statutes and the IRS.

What does a spreadsheet handle, and what doesn't it?

Job	Spreadsheet	HOA software
Budget	Free templates	Built in
Dues owed by each home	By hand	Automatic
Online payments	Needs a separate processor	Built in
Late fees and reminders	By hand	Automatic
Operating and reserve funds	Separate tabs, reconciled by hand	Separate funds
Bank reconciliation	By hand	Bank feeds, in some tools
Owner portal	Not offered	Built in
Form 1120-H	CPA, from the sheet	Included in Kahoa and RunHOA
Handing off to the next treasurer	The file, if it's found	Board logins

What do the law and the IRS ask of the books?

Rule	Example	Source
Board reviews operating and reserve reconciliations monthly	California	Cal. Civ. Code § 5500
Annual budget to owners before the year ends	California, 30–90 days ahead	Cal. Civ. Code § 5300
Annual financial report, stricter with revenue	Florida: cash report under $150k, audit at $500k+	Fla. Stat. § 720.303
Accrual statements; audit at $100k+ in assessments	Washington	RCW 64.90.530
Keep financial books 7 years	Texas, 15+ lots; Florida	Tex. Prop. Code § 209.005
60% of income from dues, 90% of spending on the property	Every HOA filing 1120-H	IRS, Form 1120-H instructions

Rules vary by state; these are examples, not a full list. Form 1120-H taxes non-dues income at 30% (32% for timeshares) after a $100 deduction.

How do you move off a spreadsheet?

4 steps · about 2 hours

01
Clean the owner tab
One row per home, with the owner's name and email. Save that tab as CSV.
Time30 minutes
02
Total what each home owes
Pick a cutover date and list each home's balance on it. CSV or Excel both work.
Time30 minutes
03
Connect the bank
Link the operating and reserve accounts. Kahoa pulls 24 months of history for the treasurer to sort.
In KahoaSetup → Bank
Time15 minutes
04
Import and invite
Upload the owner list and balances, check the total against the sheet, then send homeowners the payment link.
In KahoaSetup → Upload directory, then Enter opening balances
Time45 minutes

Keep the spreadsheet if

It's still enough

The HOA has a handful of homes and few transactions.
Dues are collected once a year, by check.
A CPA keeps the real books and files the 1120-H.

Time to switch if

The sheet is the risk

Only one person understands the file.
Reserve money and operating money share a tab.
Owners ask for statements the sheet can't produce.

What else do boards ask about HOA spreadsheets?

Can an HOA use Excel for accounting?

Yes, for a small HOA with few transactions. Excel and Google Sheets can track dues and a budget, but the board reconciles the bank, separates reserve money and prepares owner statements by hand.

Does an HOA need fund accounting?

Most do in practice. Reserve money is set aside for future repairs, and states like California require the board to review operating and reserve reconciliations separately every month.

What does an HOA need to file Form 1120-H?

At least 60% of gross income must come from dues and assessments, and at least 90% of spending must go to the association's property. The books have to show both, which is why income categories matter.

Is there free HOA software instead of a spreadsheet?

Rarely with accounting included. RunHOA costs $399 a year and Kahoa $50 a month, both with fund accounting and the 1120-H.

Outgrowing the spreadsheet?

Bring it to Kahoa

Thirty days, no card. Upload the owner tab and the balances; the bank fills in the rest.

Start a 30-day trial See pricing

$50a month, flat, at any size. The 1120-H is included.