Softwiro
Free Excel template

Building maintenance sheet: flat fees, expenses, elevator and pump

A free Excel sheet for a single residential building run by one of the residents or a small owners' association. Enter the building's flats, each flat's floor and whether it uses the elevator, and the sheet calculates each flat's fee (equal, or by share, with an elevator extra by floor). In a flat × month grid you enter what each flat paid, and the arrears and the list of who owes money appear. You record electricity, pump, doorman and elevator contract expenses by category, track periodic maintenance dates, split big repairs across the flats by their shares, and the sheet prints a monthly statement of money in, money out and the cash box balance to show your neighbors.

Excel file (.xlsx) · 99 KB · 14 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.
الشقةالساكنالاشتراكإجمالي المدفوعالمستحق حتى اليومالمتأخرالحالة
1حسن عبد الله60.003003000منتظم
2سعاد محمود100.00400500100متأخر
3محمد الشريف100.00200500300متأخر كثيرًا
4هدى فتحي110.005505500منتظم
5أحمد سعيد120.007206000مدفوع مقدمًا
6نادية رشدي120.0054060060متأخر
7عمرو خليل130.006506500منتظم
8مها عبد الرحمن130.00390650260متأخر
9إبراهيم نصار140.007007000منتظم
10شيماء جابر140.00560700140متأخر
11وليد منصور150.007507500منتظم

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

What is inside

  • الإعدادات (Settings): Building name, first month of the collection grid, today's date and the statement month, the fee method (equal or by share), the elevator extra per floor, the opening cash box balance, and the list of expense categories.
  • الشقق (Flats): Flat number, floor, resident, owner or tenant, phone, share and whether it uses the elevator, plus a special-fee cell for a particular flat. Each flat's fee and actual share are shown. Holds 40 flats.
  • التحصيل (Collection): A flat × 12 months grid where you enter the amount paid. A cell turns red if the month is due and not fully paid, and each flat shows paid, due to date, arrears, months overdue and status.
  • المتأخرات (Arrears): A sorted list of the flats that owe money, largest amount first, with the resident, phone, number of months and total arrears.
  • المصروفات (Expenses): Each expense with its date, category, description and amount, with the big repair number if it is a payment to a contractor, and an alert for an incomplete record or one outside the period. Holds 500 expenses.
  • إيرادات أخرى (Other income): Donations, roof or billboard rent, fines, and what you collect from the flats for each big repair, with dates. Holds 200 records.
  • الصيانة الدورية (Periodic maintenance): Each task (elevator service, tank cleaning, pump maintenance, pest control and so on), how many months between repeats and the last time done. Its next date, days remaining, status (overdue, soon or on schedule) and yearly cost are shown.
  • الإصلاحات الكبرى (Big repairs): Up to 6 repairs with their cost, what was paid to the contractor, what was collected from the flats and what remains, and a table with each flat's share of each repair by its share, what it paid and what it still owes.
  • الخزنة (Cash box): For each month: opening balance, fees collected, other income, expenses, closing balance and the number of flats that paid.
  • تحليل المصروفات (Expense analysis): Each category in each of the 12 months, its total, its share of all expenses and its monthly average.
  • كشف الشفافية (Transparency statement): Choose the month and a print-ready statement appears: opening balance, money in and out by item, closing balance and the number of flats that paid.
  • الملخص (Summary): Collection rate, arrears, cash box balance and how many months it covers, overdue maintenance tasks and the remainder of the repairs, with charts of collected versus expenses, cash box balance and the share of each item.

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

What makes it different

Fees, expenses, maintenance, big repairs and the neighbors' statement are in one file. A payment is entered once in the collection grid and appears in the arrears, the cash box and the monthly statement together, and an overdue maintenance date shows up before the elevator breaks down or the tank overflows.

How to use it

  1. In «الإعدادات» (Settings) enter the building name, the first month of the collection grid, today's date, the fee method (equal or by share), the elevator extra per floor and the opening cash box balance, then edit the list of expense categories.
  2. In «الشقق» (Flats) enter for each flat its number, floor, resident name, phone, whether it uses the elevator, and its share (optional). Each flat's monthly fee appears by itself.
  3. In «التحصيل» (Collection) enter the amount each flat paid in the month cell. A red cell is a due month not fully paid, and the arrears and status appear by themselves.
  4. In «المصروفات» (Expenses) record each expense with its date, category and amount. In «إيرادات أخرى» (Other income) record donations and what you collect from the flats for big repairs.
  5. In «الصيانة الدورية» (Periodic maintenance) enter each task, how many months it repeats and the date it was last done, and its next date appears with whether it is overdue or near. In «الإصلاحات الكبرى» (Big repairs) enter the repair and its cost and it is split across the flats by share.
  6. Open «الخزنة» (Cash box) for each month's balance, «كشف الشفافية» (Transparency statement) to print and post on the staircase, and «الملخص» (Summary) for the figures and charts.

Before you start:

  • Flat fee = base fee (or total needed × the flat's share if you choose "by share") + elevator extra × the flat's floor number if it uses the elevator. The ground floor is number 0. The «اشتراك خاص» (special fee) cell overrides this calculation for a particular flat.
  • The actual share is the percentage entered in «الشقق» (Flats); if left blank, every flat gets an equal share. Big repairs are split by it.
  • Due to date = fee × the number of months from the start of the collection grid to the month of today's date. Arrears = due − paid, and an advance payment does not show as arrears.
  • The cash box balance counts fees in the month they fall due, and other income and expenses on their date. The sheet warns about any record dated outside the 12 months.
  • Enter the repair number (1 to 6) in «المصروفات» (Expenses) for what is paid to the contractor, and in «إيرادات أخرى» (Other income) for what you collect from the flats, so the remainder shows for each side.
  • Do not sort «الشقق» (Flats) after you have recorded collection, because the collection grid follows the order of the rows. The sheet holds 40 flats, 500 expenses, 200 income records, 30 maintenance tasks and 6 big repairs.
  • This sheet is for a single building. For a large compound, use the HOA dues collection sheet (hoa-dues-collection) and the HOA budget and expenses sheet (hoa-budget-expenses). The sheet is an organizing tool, not legal advice; matters of the owners' association and the splitting of shares follow local law and the owners' agreement.

Excel file (.xlsx) · 99 KB · 14 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: building maintenance (1/3)Cheat sheet: building maintenance (2/3)Cheat sheet: building maintenance (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 do I calculate each flat's fee if the elevator serves the upper floors more?

Enter each flat's floor and choose whether it uses the elevator, then enter the base fee and the elevator extra per floor in «الإعدادات» (Settings). The sheet calculates flat fee = base + extra × floor number. Alternatively choose "حسب الحصة" (by share) and the monthly amount needed is split by each flat's share.

How do I know who is behind on the fee?

Enter the amount each flat paid in the month cell of the «التحصيل» (Collection) grid. A red cell means a due month that was not fully paid, and the «المتأخرات» (Arrears) list appears sorted by largest amount, with the phone and number of months.

How do I split the cost of a big repair across the flats?

Enter the repair and its cost in «الإصلاحات الكبرى» (Big repairs). Each flat's share = cost × its actual share. Then record what each flat pays in «إيرادات أخرى» (Other income) with the repair number so you know what remains. The method of splitting is agreed with the owners according to local law.

Does the sheet work for a compound with several buildings?

It is designed for a single building. For a larger compound, use the HOA dues collection and the HOA budget and expenses sheets published in the free templates.

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