HOA Dues Tracker Spreadsheet

About this template

This HOA dues tracker is made for the volunteer hoa treasurer of a homeowners or condo association. List the homes once and log each payment as it arrives, and every home's year fills in, so the homes behind are plain to see.

Please read: This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).

The dashboard

Choose any month of the association's year, or the whole year, and the page follows.

• Dues paid against dues due so far, and collected against expected each month
• Every month's homes paid, part paid and late
• Every home that owes the association, most owed first
• Spending so far against the budget's pace through the year
• Each category's spending against its budget, with overs in red
• The reserve fund balance now, with this year's money in and out
• Operating and reserve accounts at the start of the year and now, and the biggest bills paid

Every home, every month

The Dues by Month tab fills from the payments, oldest month first, marking each month paid, part paid or late and showing the month each home is paid through. The Payments tab is a plain payment ledger behind it.

What each home owes

The Homes tab lists every home and owner with dues so far, paid, last year's balance and any special assessment, kept separate, with a status for each.

Budget against actual

The Budget tab sets each category's spending against its hoa budget and against how far through the year you are, from the expenses you log.

The two accounts

Operating and reserve each show the opening balance, money in, money out and what is there now, which makes the board report easy to put together.

Eight connected tabs

Start Here, Setup, Homes, Dues by Month, Payments, Expenses, Budget and Dashboard.

Works with

• Microsoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice
• Google Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.
• No dynamic arrays, no macros, no add-ins and no subscription

What you download

• The Excel workbook, filled with a worked example: a year of dues and spending for a 36-home association
• The same workbook, blank and ready for yours
• The instruction guide, which has one-click links to the Google Sheets versions (filled and blank)
• The terms of use as a PDF

Your files are ready to download as soon as payment clears. They are for personal and business use on your own devices, so please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.

Frequently asked questions

Can the board share it in Google Sheets?

Yes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.

How does it mark late dues?

Payments fill each home's months oldest first. Each month is marked paid, part paid or late, with the month each home is paid through.

Can it handle special assessments?

Yes. Special assessments are kept separate and included in what each home owes, alongside last year's balance.

Does it track the reserve fund?

Yes. The operating account and the reserve fund each show the opening balance, money in, money out and the balance now.

Is there a filled example?

Yes. The example copy holds a year of dues and spending for a 36-home association, and a blank copy is included.