All posts

Money & trust · 3 min read

HOA Dues Tracker Spreadsheet: Who Paid, Who Owes (Free Template)

By Travis Sawyer ·

An HOA dues tracker answers three questions at a glance: who paid this month, who owes, and how far behind they are. It's one of the treasurer's most hands-on jobs.

Download the free HOA dues tracker (.xlsx). It works in Excel and Google Sheets, with no macros. It's pre-filled with an illustrative 10-unit association in March, the same one as our budget and treasurer report templates.

Rather not track it by hand? GnomeOwner does this on the free plan.

How does the dues tracker work?

You record each payment once, and everything else fills itself in. The workbook has four tabs:

  • Payment Log: one row per check, cash payment or transfer, with the date, unit, amount, method and the month it pays for.
  • Dues Grid: every unit across the months of your fiscal year, filled from the log, with each unit's balance and status.
  • Owner Statement: pick a unit to get its month-by-month charges, payments and running balance, ready to print or email.
  • Deposits Check: what you recorded each month against the dues deposits on your bank statement.

What does the Dues Grid show?

Each unit gets one row: what it was billed so far, what it paid, what it owes and how far behind that is. In the example, the association bills $249 a month and it's March:

UnitPaid so farBalanceStatus
Unit 1$747$0Paid up
Unit 4$498$2491 month behind
Unit 7$249$4982 months behind

Across all ten units, the board has collected $6,723 of $7,470 billed, and $747 is owed. Months behind is the balance divided by the monthly dues, so a partial payment shows up as "less than a month behind" instead of hiding.

When is an HOA account delinquent?

Your governing documents and your collection policy decide that, along with state law. The same goes for late fees, interest, payment plans and when a lien is allowed. The Community Associations Institute recommends a written collection policy that the board adopts, counsel reviews and owners receive (CAI, Developing a Collections Policy).

The tracker doesn't add late fees on its own. If your documents allow one and the board charges it, enter it in that unit's Fees and adjustments column and note why.

How do you keep the tracker accurate?

Check it against the bank every month. The Deposits Check tab compares the payments you recorded in each month with the dues deposits on that month's statement. In the example, March shows $1,992 in both places. If a deposit mixes dues with something else, such as a reimbursement, split it before you compare.

A few habits keep it trustworthy:

  1. Record payments the day they arrive, with the check number or transfer reference.
  2. Say which month each payment covers, especially for partial or catch-up payments.
  3. Keep the owner list private. Share balances with the board, not the whole community.
  4. Keep the records. Many associations keep payment records for about seven years; check your state law and governing documents.

What's an owner account statement?

An owner account statement lists one unit's charges, payments and running balance. Owners ask for one to check their account, and buyers' agents ask for something similar when a unit sells. The Owner Statement tab builds it for any unit you pick.

A sale usually needs a formal document. It goes by several names (estoppel certificate, resale certificate, statement of account), and some states set what it must contain, how fast it's due and what it can cost. The tab is an account statement, not that certificate.

Where GnomeOwner fits

On GnomeOwner's free plan, the board bills dues to every unit and records checks and cash. Upload the bank statement, and GnomeOwner suggests the unit for each deposit so the board can confirm it. Every unit's balance stays current, and Send and Remind emails owners their bill or a reminder. Paid plans add online payments and autopay for owners, a bank feed that syncs itself, and reminders that go out on their own.

See HOA dues collection for how it works.

Collect dues online, straight to your HOA's bank

Owners pay exactly their dues from the email or the portal, and the money lands in your HOA's own account.

See dues collection

Travis Sawyer

Founder of GnomeOwner and volunteer board president of a small self-managed condo association, which is where every one of these guides starts.

This article is general information for HOA and condo boards, not legal advice, and reading it does not create an attorney–client relationship. Statutes change and every association’s governing documents differ — confirm anything you plan to act on with your own attorney or CPA.