# Compound and owners' association sheets

> Free Excel templates for running a compound or an owners' association: dues collection, budget and emergency fund, maintenance requests and assets, gate and…

Source: https://softwiro.com/templates/for-compound
Language: English
Softwiro, softwiro.com

---

Free Excel templates

# Compound and owners' association sheets: dues, maintenance and property

Ready-made sheets with working formulas that a compound manager or an owners' association committee can use instead of scattered notebooks: finance (dues, budget, maintenance fund and shared electricity and water bills), maintenance (requests and complaints, assets, periodic maintenance and supplier contracts), operations (gate, visitors, shifts and facility booking), property (units, residents and rentals) and governance (meetings, decisions and a transparency report for owners). Start with the units and residents sheet, because the other sheets link to it by unit code.

The workbooks are in Arabic (right-to-left); each template's page explains every tab in English.

## The templates

[Owners' association dues collection tracker Free Excel tracker for HOA maintenance dues: fixed or per-square-metre fees, payments log, arrears, months late, late-payers list and unit statements. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-dues-collection) [Owners' association budget and expenses sheet Free Excel HOA budget and expenses sheet: budget lines, expenses log, dues revenue, actual vs budget by item and month, over-budget alerts and yearly summary. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-budget-expenses) [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. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-reserve-fund) [Maintenance requests and complaints log for owners' associations Free Excel maintenance request log for a building or compound: type, priority, owner, status, days open with late alerts and a cost summary. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-maintenance-requests) [Service contracts and suppliers tracker for owners' associations Free Excel tracker for HOA service contracts and suppliers: monthly values, dates, payments, due vs paid, expiry alerts, yearly commitments and a renewal list. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-service-contracts) [Owners association meetings and decisions tracker Owners and shares, a meetings log, attendance in person, by proxy or absent, quorum check against your set percentage, votes by shares, and open decisions. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-meetings-decisions) [Shared electricity and water bill splitter for building units Split shared electricity, water, gas and elevator bills across building units by area, equally, by household size or fixed share, with printable statements and a check. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-common-utilities-split) [Residents, units and vehicles register for an owners' association Register building or compound units with residents, phones, household size, cars, plates, stickers and parking spots, with alerts, totals and a quick contact list. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-residents-vehicles) [Monthly transparency report for owners' associations Log an association's income and expenses and get a one-page printable monthly report: spending by category, net, balances, last-month comparison, arrears and a year summary. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-transparency-report) [Compound assets and periodic maintenance sheet A register of compound assets (lifts, generators, pumps, gates, CCTV, pool) with maintenance interval, next due date, overdue status, a log and costs. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-assets-maintenance) [Gate and security sheet A compound gate log: visitors with duration and still-inside flag, units, work permits with status, a monthly guard-shift grid and a summary. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-gate-security) [Compound shared facilities booking sheet Booking log for a compound's club hall, pool, tennis court, rooftop and meeting room: fees, deposits, clash and out-of-hours flags, and monthly occupancy. Workbook in Arabic Details and download](https://softwiro.com/templates/hoa-facilities-booking) [Building maintenance sheet: flat fees, expenses, elevator and pump Monthly flat fees with an elevator extra by floor, collection grid, arrears, building expenses, maintenance dates, big repairs, cash box and resident statement. Workbook in Arabic Details and download](https://softwiro.com/templates/building-maintenance)

## Templates that go well with them

[Rental portfolio tracker: properties, units, tenants and contracts For owners with several buildings: properties, units, tenants, contracts and payments, overdue tenants by name and phone, renewals and a monthly report. Workbook in Arabic Details and download](https://softwiro.com/templates/rental-portfolio) [Rent collection tracker for properties Rent tracker: units, tenants, lease dates, payments log, balance and months late, lease-ending alerts, follow-up list and expected vs collected summary. Workbook in Arabic Details and download](https://softwiro.com/templates/rent-collection)

## Frequently asked questions

### Where do we start if we have no records at all?

Start with the units and residents register, then dues collection, then maintenance requests. These three give you a picture of the compound, what it is owed and what it owes; add the rest when you need them.

### Are the sheets linked to each other?

Each sheet is a separate file, but they all use the same unit code, so you copy the list of units from one sheet to another by copy and paste and the link stays simple.

### Are these sheets enough for a large compound?

They handle hundreds of units. If you need a login for each official, notifications for residents and an app for owners, a custom system can be built for your compound.

### Are the templates free?

Yes. You download and use them with no sign-up. They work in Excel and Google Sheets, and each one also opens in the browser on a worked example.

### Do the templates follow an official regulation?

No. The templates are calculation tools. Grade boundaries, subjects and weights in them are example values that you type in the settings sheet according to the rules of your school or the body you follow, so check the official source before relying on any result.

### Where is my data kept?

In your file, on your device. The version that opens in the browser keeps its data in your browser and sends nothing to a server, so export it to Excel before you close the page.

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