The HOA dues tracking template
The spreadsheet your treasurer wishes existed: one row per unit, live totals at the top, and a clean way to hand over records when the board changes.
What's inside
Live summary
Total expected, collected, outstanding and % collected — calculated automatically as you mark payments Paid or Due.
Example rows
Six pre-filled rows show exactly how to use it. Replace them with your units and you're running.
Treasurer how-to
A second sheet with the annual rollover, ledger-on-demand and handover tips — the stuff that usually lives only in someone's head.
Questions
Does it work with Google Sheets?
Yes — File > Import > Upload, and all formulas carry over. Everything also works in Excel and LibreOffice.
Why is it free?
We make HOAcove, software that replaces this template when a board outgrows it. The template is ours to give — and if your board stays small and happy on it, that's genuinely fine.
What happens to our data?
The file lives wherever you put it — your drive, your computer. We receive only your email address.
Is a spreadsheet really enough for a board?
For dues tracking at a small association, mostly yes — that's why this template is good. Budgets, meetings, maintenance and document handover are where spreadsheets start to crack. That's what HOAcove adds.