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
- In "الإعدادات" (Settings), enter today's date, the fund's opening balance, the monthly fee assigned to it and the minimum safe balance.
- In "الحركات" (Transactions), record every deposit or withdrawal: date, type, description, amount, source or beneficiary and decision or receipt number.
- The running balance after each transaction appears automatically, so you know the balance on any date. Enter transactions in date order.
- 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.
- The sheet calculates the months remaining, the amount still to be raised, the monthly amount needed and the status of each project.
- 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.
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.
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. |
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
- 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





