Softwiro
Free Excel template

Reserve and emergency fund sheet for owners' associations

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.

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

Example from the “الحركات” tab (Arabic), with the numbers and formulas that are in the file.
التاريخالنوعالبيانالمبلغالرصيد الجاري
46053إيداعاشتراكات الصيانة - يناير24,000.00144,000.00
46081إيداعاشتراكات الصيانة - فبراير23,500.00167,500.00
46096سحبإصلاح مضخة المياه9,500.00158,000.00
46112إيداعاشتراكات الصيانة - مارس24,000.00182,000.00
46122إيداعرسوم تأخير (مثال)1,500.00183,500.00
46142إيداعاشتراكات الصيانة - أبريل24,500.00208,000.00
46162سحبصيانة طارئة للمصعد18,000.00190,000.00
46173إيداعاشتراكات الصيانة - مايو24,000.00214,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.

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)Cheat sheet: HOA maintenance and emergency reserve (2/3)Cheat sheet: HOA maintenance and emergency reserve (3/3)
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 sheetIn 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 · Ask for a demo

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

All the templates in this group: Compound and owners' association sheets: dues, maintenance and property

More free templates for: Owners associations and compounds

More free templates

All templates · Free tools