# Building maintenance Excel sheet (free) for residents

> Free building maintenance sheet: flat fees with elevator extra, collection grid, arrears, expenses, maintenance dates and a monthly resident statement.

Source: https://softwiro.com/blog/building-maintenance-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Building maintenance sheet in Excel (free): flat fees, expenses, elevator and water pump

Know who paid, what is in the cash box, where the money went and which maintenance is due, and show the neighbours a clear monthly statement.

15 November 2026 5 min read

## In short

- Flat fee = base fee + elevator extra × floor number, or the monthly total × the flat's share; a special fee can override it for one flat.
- Type what each flat paid in a flat × month grid; red cells are due months not paid in full, and the arrears list sorts by amount.
- Log expenses by category and set each maintenance task's interval and last date to get its next due date and status.
- A big repair is split by share, and the cash box and a printable statement show residents where the money went.

You are the resident who took charge of the building, and you want to know at any moment who has paid and who is late, what is in the cash box, where this month's money went, and which maintenance job is due. At month end you want to show the neighbours the accounts clearly so no argument starts. The free [building maintenance sheet](https://softwiro.com/templates/building-maintenance) (the page is in Arabic) gives you all of that in one file.

## The problem it solves

A building's accounts usually live in a notebook, WhatsApp messages and memory. Some neighbours pay in advance, some late, someone asks "where did last month's money go?", and nobody knows whether the cash box can cover the elevator and the water pump if an unexpected bill arrives. When a big repair comes up, neighbours argue over each flat's share. The sheet puts fees, expenses and maintenance in one place and does the arithmetic.

## How the sheet works, step by step

1. Settings: type the building name, the first month of the collection grid and today's date, choose the fee method ("equal" or "by share"), the elevator extra per floor and the opening cash balance.
2. Flats: list each flat with its floor, resident, phone and whether it uses the elevator. The fee appears by itself. For a flat with a special agreement, type a "special fee".
3. Collection: type what each flat paid in the month's cell. A red cell is a due month not paid in full.
4. Expenses and other income: log every expense with its category, and every donation or repair payment.
5. Periodic maintenance: type each task, how many months between jobs and the last date done; the next date and status appear.
6. Cash box, transparency statement and summary: read each month's balance, print the statement for neighbours, and see the numbers and charts.

## What is in each sheet

- Flats: resident details, the flat's fee and its effective share.
- Collection: a flat × 12-month grid with paid, due, arrears and a status for each flat.
- Arrears: a list sorted from the largest amount, with phone and months behind.
- Expenses: each expense with its category, and a warning for incomplete or out-of-period rows.
- Other income: donations, roof rent and what you collect from flats for repairs.
- Periodic maintenance: tasks, next due dates and yearly cost.
- Big repairs: the repair cost, each flat's share and what it has paid.
- Cash box and expense analysis: each month's balance, and each category month by month.
- Transparency statement and summary: a printable statement, plus numbers and charts.

## Walk-through on the sample numbers

These numbers are sample data inside the sheet, not a real building: 12 flats, a grid starting in July 2026 and today's date 15 November 2026, so five months are due (July to November).

- Flat fee: base 100 plus an elevator extra of 10 per floor. A fourth-floor flat pays 100 + 10 × 4 = 140, a first-floor flat that does not use the elevator pays 100, and flat 1 has a special agreement of 60. The building's monthly total is 1,450.
- Collection: November collected 1,060 of 1,450, which is 73.1%.
- Arrears: six flats owe 1,010 in total. Flat 3 paid only 200 of 500, so it owes 300 (three months) and shows "very late"; flat 8 owes 260 (two months). Flat 5 paid up to December, so it shows "paid in advance".
- Expenses, July to November: 19,133 in total, of which 11,000 are big-repair payments, then the caretaker's pay at 3,000 and the elevator contract at 2,000.
- Big repair: painting the stairwell costs 9,600, so a flat with a 9% share owes 9,600 × 9% = 864. 5,000 has been paid to the contractor and 4,800 collected from flats, leaving 4,800 to collect and 4,600 to pay.
- Cash box: the current balance is 3,707, enough for about one month at the average monthly spend (about 3,827). That is a sign to raise the fee or postpone repairs.
- Maintenance: tank cleaning is 5 days overdue (due 10 November); the elevator service in 5 days and pest control in 10 days show "soon". The expected yearly cost of periodic maintenance is 9,370.
- October statement: opening balance 4,595, fees 1,220 and other income 2,408, expenses 6,638, closing balance 1,585, and 10 of 12 flats paid.

## Common mistakes

- Sorting the "Flats" sheet after logging payments, which moves payments onto other flats because the grid follows row order.
- Forgetting the repair number on a contractor payment or a flat's repair payment, so the remaining amount on each side does not appear.
- Typing an expense with a category that is not in Settings, which raises "category not registered".
- Not updating today's date, which delays arrears and maintenance statuses.
- Mixing in what belongs to the owners' union and how shares are split; that follows local law and the owners' agreement. The sheet organises numbers, it does not set rights.

## When to move to a system

Move when you have several buildings or a second manager entering data, or when you want each resident notified on WhatsApp of what they owe and an online vote on a big repair. For a larger compound see the [compound dues collection sheet](https://softwiro.com/templates/hoa-dues-collection) and the [compound budget and expenses sheet](https://softwiro.com/templates/hoa-budget-expenses), the bigger version of this idea.

## Start now

Open the [sheet page](https://softwiro.com/templates/building-maintenance), download it, type your real flats and their shares in "Flats", then log what each neighbour paid this month in "Collection". In an hour you will know the arrears, the cash balance and have your first statement to show the neighbours.

## 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)](https://softwiro.com/uploads/cheatsheets/building-maintenance/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/building-maintenance/en-1.jpg)[![Cheat sheet: building maintenance (2/3)](https://softwiro.com/uploads/cheatsheets/building-maintenance/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/building-maintenance/en-2.jpg)[![Cheat sheet: building maintenance (3/3)](https://softwiro.com/uploads/cheatsheets/building-maintenance/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/building-maintenance/en-3.jpg)

0 downloads · 3 pages

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

## Questions this raises

### How do I work out each flat's fee when the elevator serves the upper floors more?

Type each flat's floor and whether it uses the elevator, then set the base fee and the elevator extra per floor in Settings. Fee = base + extra × floor number. Or choose "by share" to split the monthly total by each flat's share.

### How do I see who is late?

Type each flat's payment in the month's cell of the Collection grid. A red cell is a due month not paid in full, and the Arrears sheet lists flats from the largest amount with phone and months behind.

### How is a big repair split among flats?

Enter the repair and its cost in Big repairs. Each flat's part = cost × its effective share. Record what each flat pays in Other income with the repair number to see what remains. How to split is agreed with the owners under local law.

### Is it enough for a compound with several buildings?

It is designed for one building. For a larger compound use the compound dues collection and compound budget sheets in the free templates.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
