# Reserve and emergency fund sheet for owners' associations

> Free Excel HOA reserve fund tracker: deposits and withdrawals with running balance, major maintenance projects and the monthly amount to set aside for each.

Source: https://softwiro.com/templates/hoa-reserve-fund
Language: English
Softwiro, softwiro.com

---

Free Excel template

A free Excel sheet for the maintenance and emergency (reserve) fund of an owners' association in a building or compound. You record every deposit and withdrawal with its date, description, source and decision or receipt number, and the running balance shows after each transaction. You also enter the major maintenance projects you have planned (painting, elevator, water tank) with their estimated cost and target year, and the sheet calculates how much to set aside each month for every project compared with what you have saved. The figures in the sheet are illustrative examples for a made-up building.

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

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

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

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

| التاريخ | النوع | البيان | المبلغ | الرصيد الجاري |
| --- | --- | --- | --- | --- |
| 46053 | إيداع | اشتراكات الصيانة - يناير | 24,000.00 | 144,000.00 |
| 46081 | إيداع | اشتراكات الصيانة - فبراير | 23,500.00 | 167,500.00 |
| 46096 | سحب | إصلاح مضخة المياه | 9,500.00 | 158,000.00 |
| 46112 | إيداع | اشتراكات الصيانة - مارس | 24,000.00 | 182,000.00 |
| 46122 | إيداع | رسوم تأخير (مثال) | 1,500.00 | 183,500.00 |
| 46142 | إيداع | اشتراكات الصيانة - أبريل | 24,500.00 | 208,000.00 |
| 46162 | سحب | صيانة طارئة للمصعد | 18,000.00 | 190,000.00 |
| 46173 | إيداع | اشتراكات الصيانة - مايو | 24,000.00 | 214,000.00 |

Example from the “الحركات” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "الإعدادات" (Settings): Today's date, the fund's opening balance, the monthly fee assigned to it and the minimum safe balance.
- "الحركات" (Transactions): Each deposit or withdrawal with its date, type, description, amount, source or beneficiary and decision or receipt number, then the effect on the balance and the running balance after each transaction. The opening balance and current balance are shown at the top of the sheet.
- "المشروعات" (Projects): For each major maintenance project: estimated cost, target year and what you have saved for it. Then months left, the amount still to be raised, the monthly amount needed, the savings percentage and the status (being funded, past due or complete).
- "الملخص" (Summary): The current balance, total deposits and withdrawals and a minimum-balance alert; project cost, amount saved, remaining amount and the monthly amount needed against the monthly fee; the monthly gap; the unallocated balance; the percentage of project cost the balance covers; and the number of projects in each status.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

You know on any day how much is in the fund and where every pound went, with a decision or receipt behind it. Years before the painting or the elevator is due, you know how much has to be set aside each month, and whether the current fee is enough or there is a gap that needs a decision from the owners.

## How to use it

1. In "الإعدادات" (Settings), enter today's date, the fund's opening balance, the monthly fee assigned to it and the minimum safe balance.
2. In "الحركات" (Transactions), record every deposit or withdrawal: date, type, description, amount, source or beneficiary and decision or receipt number.
3. The running balance after each transaction appears automatically, so you know the balance on any date. Enter transactions in date order.
4. In "المشروعات" (Projects), enter each major maintenance project you have planned: its name, estimated cost, target year and what you have saved for it from the fund.
5. The sheet calculates the months remaining, the amount still to be raised, the monthly amount needed and the status of each project.
6. Open the summary sheet to see the current balance, whether the monthly fee is enough for your projects, and the percentage of their cost that the balance covers.

**Before you start:**

- The figures in the sheet are illustrative examples for a made-up building, not the figures of a real association. Delete them and enter your own.
- Running balance = opening balance + deposits − withdrawals up to that transaction, so enter transactions in date order.
- Months remaining are counted from the current month (inclusive) to December of the target year.
- Monthly amount needed = (estimated cost − saved for the project) ÷ months remaining. If a project's date has passed, its status shows "past due" and no monthly amount is calculated for it.
- The amount saved for a project is part of the fund balance that you earmark for it, not a separate transaction. Unallocated balance = current balance − total saved.
- A project that is past due is left out of the "monthly amount needed" and the coverage gap, so review the "past due" status and update its date or cost.
- The sheet holds 1,000 transactions and 200 projects.

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

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

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

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

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: HOA maintenance and emergency reserve (1/3)](https://softwiro.com/uploads/cheatsheets/hoa-reserve-fund/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/hoa-reserve-fund/en-1.jpg)[![Cheat sheet: HOA maintenance and emergency reserve (2/3)](https://softwiro.com/uploads/cheatsheets/hoa-reserve-fund/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/hoa-reserve-fund/en-2.jpg)[![Cheat sheet: HOA maintenance and emergency reserve (3/3)](https://softwiro.com/uploads/cheatsheets/hoa-reserve-fund/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/hoa-reserve-fund/en-3.jpg)

0 downloads · 3 pages

## 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 |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

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

## Frequently asked questions

### How is the monthly amount for each project calculated?

The sheet subtracts what you have saved for the project from its estimated cost, then divides the rest by the months remaining. Months are counted from the current month, inclusive, to December of the target year. If the date has passed, the project's status shows "past due" and no monthly amount is calculated for it.

### What does "saved for the project" mean?

It is the part of the fund balance that you earmark for this project, and you enter it by hand in the projects sheet. It does not leave the balance. The total is subtracted from the current balance so you can see the balance that is not allocated to any project.

### Do I have to enter transactions in a certain order?

Yes, enter them in date order, because the running balance is calculated by adding up the transactions from the top of the table down to each row. The sheet holds up to 1,000 transactions.

### Are the figures in the sheet real?

No, they are illustrative examples for a made-up building. Delete them and enter your association's figures. It is a simple template and does not replace the association's official books and documents.

### 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

- Owners' association dues collection tracker
- Owners' association budget and expenses sheet
- Maintenance requests and complaints log for owners' associations
- Service contracts and suppliers tracker for owners' associations
- Owners association meetings and decisions tracker
- Shared electricity and water bill splitter for building units
- Residents, units and vehicles register for an owners' association
- Monthly transparency report for owners' associations
- Compound assets and periodic maintenance sheet
- Gate and security sheet
- Compound shared facilities booking sheet
- Building maintenance sheet: flat fees, expenses, elevator and pump
- Gym memberships tracker (Excel)
- Beauty salon bookings tracker (Excel)
- Car workshop job orders tracker (Excel)
- Nursery and school fees tracker (Excel)
- Tutoring center manager (Excel)
- Poultry farm cycle tracker (Excel)
- Crop season expenses and revenue tracker (Excel)
- Racing pigeon loft sheet

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