# HOA Dues Tracking Spreadsheet (Free Excel)

> A free Excel HOA dues tracker: payments and charges per unit, balance and status, a unit-by-month grid, billed vs collected and the largest balances.

Source: https://softwiro.com/templates/hoa-dues-tracker
Language: English
Softwiro, softwiro.com

---

Free Excel template

# HOA Dues Tracking Spreadsheet for Excel

A free Excel spreadsheet for a homeowners or condo association treasurer. List the units once, log each payment as it arrives, and add any extra charges such as fees or fines. The sheet works out what each unit has been billed, what it has paid, its balance and whether it is paid up, current, overdue or needs escalating. It also shows who paid in which month, how much was billed against collected each month, and the ten units that owe the most. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-hoa-dues-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-hoa-dues-tracker-blank.xlsx)

Excel file (.xlsx) · 233 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| As of | 46342 | Change the as-of date, dues and billing start on the Settings sheet. |
| --- | --- | --- |
|  |  |  |
| Units | 20 |  |
| Charged to date (all sources) | 62,705.00 |  |
| Collected to date | 56,495.00 |  |
| Outstanding (owed by units in debt) | 6,510.00 |  |
| Collection rate | 90.1% |  |
| Credit balances held | 300.00 |  |
| Status | Units | Balance |
| Paid up | 10 | -300.00 |
| Current | 5 | 1,480.00 |
| Overdue | 2 | 1,275.00 |
| Escalate | 3 | 3,755.00 |
| Total | 20 | 6,210.00 |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Units, amount charged and collected to date, outstanding balances, collection rate and credit balances, the number of units in each status, billed versus collected by month, and the ten largest balances, with three charts.
- Units: One row per unit: owner, contact, optional monthly dues, optional billing start and opening balance. It adds dues billed, other charges, paid to date, balance, months behind and status. Room for 150 units.
- Payments: The payment log: date, unit, amount, method, reference, note. It looks up the owner and flags an unknown unit, a missing amount or a payment dated after the as-of date. Room for 3,000 payments.
- Charges: Anything billed on top of monthly dues, such as late fees, fines or a special assessment for one unit. A negative amount records a waiver or credit. Room for 300 rows.
- Payment Grid: Every unit across the twelve months of the year with the amount received in each month. A month up to the as-of month that was paid short turns red.
- Collection: Dues billed and collected for each month of the year, with the collection rate and a chart.
- Settings: Association name, currency, as-of date, report year, default monthly dues, billing start month, the months-behind limit for Escalate, and the list of payment methods.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Many HOA spreadsheets are a grid of ticks. This one keeps a real ledger: dues are billed month by month from your start date, payments and extra charges are logged separately, and each balance is worked out from them. In the sample of 20 units, 10 are paid up, 5 current, 2 overdue and 3 flagged to escalate, with 6,510.00 outstanding and 56,495.00 collected of 62,705.00 charged (90.1%).

## How do I track HOA dues in a spreadsheet?

Keep three lists: the units, the payments received and the extra charges. Bill the monthly dues by formula from a start date instead of typing a charge for every unit every month. Then each unit's balance is its opening balance plus dues billed plus charges, minus payments.

That is how this sheet works. Add a payment on the Payments sheet and the unit's balance, status, row in the Payment Grid and the monthly collection figure all update.

## How do I know which owners are delinquent?

The Units sheet shows months behind, which is the balance divided by that unit's monthly dues, and a status. Current means up to one month owed, Overdue means more, and Escalate means the unit has reached the limit you set on Settings (3 months in the sample). Filter the Status column to build your follow-up list.

What happens at each stage, including notices, fees and interest, depends on your governing documents and local rules, so check them. The sheet does not add late fees on its own: record them on the Charges sheet.

## Can a spreadsheet replace HOA accounting software?

For a small association, a clear ledger of dues is often enough. It stops being enough when several board members need to enter payments at once, owners expect to pay or see their balance online, or you want automatic reminders. For the rest of the books, see the [cash book template](https://softwiro.com/templates/cash-book-template) and the [cash flow forecast](https://softwiro.com/templates/cash-flow-forecast-template).

## How to use it

1. On the Settings sheet type the association name, currency symbol, the "as of" date, the year to report, the default monthly dues, the month billing starts, and after how many months behind a unit is flagged Escalate.
2. On the Units sheet list every unit with its owner and contact. Leave Monthly dues empty to use the default, or type a different amount for a unit. Use Billing from only for a unit that joined after billing started, and Opening balance for arrears (or a credit, as a negative number) carried in.
3. On the Payments sheet add one row per payment received: date, unit (pick from the list), amount, method, reference.
4. On the Charges sheet add anything billed on top of the monthly dues: late fees, fines, key fobs, special assessments for one unit. Use a negative amount for a credit or waiver.
5. Open Units to read each unit's balance, months behind and status. Open Payment Grid to see who paid in which month (red means a month paid short). Collection shows billed against collected for each month.
6. Open Dashboard for the totals, the status mix, the charts and the ten units with the largest balance.

**Before you start:**

- Capacity: 150 units, 3,000 payments and 300 extra charges.
- The sheet does not use TODAY(): type the as-of date on Settings. Payments and charges dated after it are left out of balances.
- Dues are billed on the first of every month from the billing start month up to the as-of month. Balance = opening balance + dues billed + other charges - payments.
- Status: Paid up = nothing owed. Current = owes up to one month of dues. Overdue = more than one month. Escalate = at or beyond the months-behind limit on Settings.
- Late fees and interest are not added automatically. Enter them on the Charges sheet using your own rules and your local requirements.
- Use one currency in one workbook. The currency symbol on Settings is only a label.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-hoa-dues-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-hoa-dues-tracker-blank.xlsx)

Excel file (.xlsx) · 233 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| You type each payment | Payments arrive from the bank or an online portal and match the unit |
| You filter for late units | Reminders go out automatically on the schedule you choose |
| One person edits the file | Treasurer, manager and board each have their own login and permissions |
| Late fees entered by hand | Fees calculated by your association's own rules |
| Charts in the workbook | A live dashboard on your phone for the board |

### Extra features in the app

- Owners see their own balance and pay online, and receipts are issued automatically
- Reminders sent by email or message before and after the due date
- Late fees and notices calculated by rules you set
- Several board members entering payments at once, with a record of who changed what
- Bank deposits matched to units automatically
- Reports for the annual meeting produced in one click

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### Is this HOA dues tracker really free?

Yes. Download it, use it for your association and change anything you like. There is nothing to sign up for to open the file.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses only ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

### How many units can it hold?

150 units, 3,000 payments and 300 extra charges. For a new year, save a copy and enter each unit's closing balance as its opening balance.

### Can some units pay different dues?

Yes. Type an amount in Monthly dues for that unit. Leave it empty to use the default from Settings.

### How do I record a unit that joined part way through?

Type the first month it should be billed in Billing from. Months before that are not billed to the unit.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

All the templates in this group: [Compound and owners' association sheets: dues, maintenance and property](https://softwiro.com/templates/for-compound)

More free templates for: Owners associations and compounds

## More free templates

- HOA Budget Template for Excel
- Car Rental Booking Tracker for Excel
- Employee Leave Tracker Template for Excel
- Monthly Habit Tracker Template for Excel (With Streaks)
- General Journal and Trial Balance Template for Excel
- Delivery Tracking Spreadsheet for Excel (Dispatch Tracker)
- Real Estate Lead Tracking Spreadsheet (Excel)
- Production Tracking Spreadsheet for Excel
- Piece Rate Payroll Calculator for Excel

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
