# HOA Budget Template Excel (Budget vs Actual)

> A free HOA budget template for Excel: set the yearly budget by line, log expenses and see budget vs actual, pace, status, monthly income and the reserve fund.

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

---

Free Excel template

# HOA Budget Template for Excel

A free HOA budget spreadsheet for a volunteer treasurer or a small board. You list the budget lines for the year, log each bill as it is paid, and the workbook shows for every line what has been spent, what is left, whether spending is on pace for the point in the year, and a status. It also tracks monthly dues and other income, the operating balance and the reserve fund. It opens in Excel, LibreOffice and Google Sheets, and it works in any currency.

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

Excel file (.xlsx) · 144 KB · 8 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

| Budget year | 2026 | As of | 46340 | Change the year, the as-of date and the opening balances on the Settings sheet. |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  |  |  |  |  |  |  |  |  |  |
| Expense budget (year) | 137,600.00 | Income so far |  | 126,435.00 |  |  |  |  |  |
| Budget to date | 126,133.33 | Income budget to date |  | 126,500.00 |  |  |  |  |  |
| Spent so far | 123,190.00 | Operating balance |  | 21,745.00 |  |  |  |  |  |
| Under (+) or over (-) budget to date | 2,943.33 | Reserve fund balance |  | 64,000.00 |  |  |  |  |  |
| Share of yearly budget used | 89.5% | Lines over annual budget |  | 1 |  |  |  |  |  |
| Largest line by spend | Reserve fund contribution | Lines near annual limit |  | 2 |  |  |  |  |  |
|  |  | Expense rows to review |  | 0 |  |  |  |  |  |
| Group | Annual budget | Budget to date | Spent so far | Left for the year | Month | Income | Expenses | Net | Operating balance |
| Administrative | 25,800.00 | 23,650.00 | 21,795.00 | 4,005.00 | Jan | 11,200.00 | 9,040.00 | 2,160.00 | 20,660.00 |
| Insurance | 14,400.00 | 13,200.00 | 13,200.00 | 1,200.00 | Feb | 11,600.00 | 10,225.00 | 1,375.00 | 22,035.00 |
| Utilities | 22,800.00 | 20,900.00 | 21,380.00 | 1,420.00 | Mar | 11,500.00 | 11,570.00 | -70.00 | 21,965.00 |
| Grounds | 26,600.00 | 24,383.33 | 24,345.00 | 2,255.00 | Apr | 11,380.00 | 10,360.00 | 1,020.00 | 22,985.00 |
| Maintenance | 24,000.00 | 22,000.00 | 20,470.00 | 3,530.00 | May | 11,800.00 | 12,065.00 | -265.00 | 22,720.00 |
| Reserve contributions | 24,000.00 | 22,000.00 | 22,000.00 | 2,000.00 | Jun | 11,500.00 | 10,800.00 | 700.00 | 23,420.00 |
|  |  |  |  |  | Jul | 11,335.00 | 10,655.00 | 680.00 | 24,100.00 |
|  |  |  |  |  | Aug | 11,500.00 | 12,115.00 | -615.00 | 23,485.00 |
|  |  |  |  |  | Sep | 11,500.00 | 11,250.00 | 250.00 | 23,735.00 |
|  |  |  |  |  | Oct | 11,620.00 | 14,905.00 | -3,285.00 | 20,450.00 |
|  |  |  |  |  | Nov | 11,500.00 | 10,205.00 | 1,295.00 | 21,745.00 |
|  |  |  |  |  | Dec | 0.00 | 0.00 | 0.00 | 21,745.00 |

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

## What is inside

- Dashboard: The board summary: yearly budget, budget to date, spent, and the difference, the biggest expense line, income so far against the dues budget, the operating balance, the reserve fund and how many lines are over or near their limit. Below it, each budget group with its budget and spending, and charts for budget vs actual and monthly income vs expenses.
- Budget: Your budget lines, each with a group and a budget for the whole year. It works out the monthly budget, the budget to date, spent, left for the year, how spending compares with the budget to date, the percent used and a status (On track, Over pace, Near annual limit or Over annual budget). Room for 40 lines.
- Expenses: The log you type into: date, budget line from a dropdown, vendor, description, invoice number, amount and payment method. A Check column flags a row that cannot be counted because its budget line is not on the Budget sheet. Room for 2,000 expenses.
- Monthly: Every budget line across the twelve months of the year, with a total for each line and each month.
- Income: Dues collected and other income (late fees, clubhouse rental) for each month, with the dues budget per month and the difference.
- Settings: The association name, currency symbol, budget year, the as-of date, opening operating cash and reserve balances, yearly dues budget, the warning level and the list of budget groups, including the group that holds reserve contributions.

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

## What makes it different

Most HOA budget templates are a list of lines with a yearly total. This one is built for the second half of the job: comparing the budget with what you have actually paid. It compares against the budget to date, not only the full year, so it tells you a line is running ahead of pace in October rather than after it has gone over in December. The sample is a 15-line association budget with spending to mid-November 2026.

## What should an HOA budget include?

Start with income: the regular dues you expect, then late fees and other income. Then the operating expenses by group: management and administration, insurance, utilities, grounds, maintenance and repairs. Last, the contribution to the reserve fund for big future repairs such as roofs and paving.

The sample budget has 15 lines in six groups and adds up to 137,600 for the year. The yearly dues budget on Settings is 138,000. Put each line in a group and the Dashboard totals each group for the board. Rules on how a budget is approved and what reserves you must hold differ from place to place, so check your governing documents and local law.

## How do I compare HOA budget vs actual?

Type each bill on the Expenses sheet and pick the budget line. The Budget sheet then shows, for each line, the amount spent so far, the amount left for the year and a comparison with the budget to date, which is the yearly budget divided by 12 times the months passed. In the sample, as of 14 November 2026 (11 months), 123,190 has been spent. That is 89.5% of the yearly budget, 14,410 left for the year and 2,943.33 below the budget to date of 126,133.33.

The status column points at the lines that need a conversation. In the sample, Tree trimming is Over annual budget (3,500 against 3,000, after a 2,100 storm cleanup). Common-area electricity (6,930 of 7,200) and Building repairs (8,670 of 9,000) are Near annual limit. Water and sewer is Over pace: 8,950 spent against 8,800 budgeted to date. Lines paid in lumps, such as an annual premium, will show Over pace until the year catches up.

## How do I track the HOA reserve fund?

Give your reserve contribution its own group on Settings and budget it like any other line. Each transfer you log to that line adds to the reserve fund on the Dashboard. In the sample the opening reserve is 42,000, 22,000 has been contributed so far and the reserve fund shows 64,000.

The operating balance is the opening cash plus income entered minus all expenses entered. With opening cash of 18,500, income of 126,435 (125,710 dues and 725 other) and 123,190 of expenses, it comes to 21,745. This sheet does not track money taken out of the reserve. For dues owed by each owner, see [HOA dues collection](https://softwiro.com/templates/hoa-dues-tracker) and for the reserve itself [HOA reserve fund](https://softwiro.com/templates/hoa-reserve-fund).

## How to use it

1. On the Settings sheet type the association name, currency symbol, budget year, the "as of" date, the opening operating cash and reserve balances, the budgeted yearly dues income, the warning level (for example 95%) and the name of the group that holds reserve contributions. Edit the budget groups in the list on the right.
2. On the Budget sheet list every budget line (Landscaping, Insurance, Management fee...), pick its group and type its budget for the whole year. The monthly budget and the budget to date are worked out for you.
3. On the Expenses sheet add one row per bill paid: date, budget line (pick from the list), vendor, description, invoice number, amount and payment method. The Check column tells you if a row cannot be counted.
4. On the Income sheet type, month by month, the dues collected and any other income (late fees, clubhouse rental).
5. Open Budget to read, for each line, what has been spent, what is left for the year, how it compares with the budget to date, and its status. Monthly shows the same expenses month by month.
6. Open Dashboard for the totals, the operating balance, the reserve fund and the charts.

**Before you start:**

- Capacity: 40 budget lines, 8 groups, 2,000 expense rows.
- The sheet does not use TODAY(): type the as-of date on Settings. Budget to date = yearly budget / 12 x the number of months passed in the budget year.
- Only expenses dated in the budget year are counted. An expense whose budget line is not on the Budget sheet is flagged in the Check column and left out.
- Status: Over annual budget = spent more than the whole year. Near annual limit = spent at least the warning level. Over pace = spent more than the budget to date. Otherwise On track. Lines paid in lumps (an annual premium) will show Over pace until the year catches up.
- Operating balance = opening cash + income entered - all expenses entered, including reserve contributions. Reserve fund = opening reserve + reserve contributions spent. Money taken out of the reserve is not tracked here.
- 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-budget-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-hoa-budget-tracker-blank.xlsx)

Excel file (.xlsx) · 144 KB · 8 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 dues month by month | Dues are billed to each unit and payments are matched to the owner |
| One treasurer edits one file | The board, the manager and the accountant each have their own login |
| A status warns you on the sheet | Bills over a limit wait for board approval before they are paid |
| The budget is a yearly number per line | Budgets for several years and reserve plans side by side |
| Reports are charts in the workbook | A report for owners and the annual meeting with one click |

### Extra features in the app

- Owners see their dues and balance in a portal, and pay online
- The board approves bills on their phones before they are paid
- Late-dues reminders and notices sent automatically
- Photograph an invoice and the expense is entered for you
- A yearly report for the annual meeting generated from the data
- Reserve fund projections against future repair costs

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

## Frequently asked questions

### Is this HOA budget template 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 ordinary formulas such as SUMIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. In Google Sheets, upload the file to Drive and open it with Sheets.

### How many budget lines and expenses can it hold?

40 budget lines in 8 groups and 2,000 expense rows. Only expenses dated in the budget year are counted, so you can keep last year's rows or start a new file.

### Why does a line show Over pace when the year is not over?

Over pace means you have spent more than the yearly budget divided by 12 times the months passed. It is a warning, not an overspend. A line paid in one or two lumps, such as insurance, will show it until the year catches up.

### Why is an expense not counted?

The Check column on Expenses says so when the budget line on that row is not on the Budget sheet, usually a spelling difference. Pick it from the dropdown or add the line to the Budget sheet.

### 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 Dues Tracking Spreadsheet 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)
