Softwiro
Commissioning a system

Managing a compound or owners association in Excel: every free sheet and where to start

A guide to the free sheets for dues, maintenance, assets, gate, facilities, property and governance, and what each one solves.

5 min read

A compound manager or owners committee runs finance, maintenance, security, facilities, residents and decisions all at once. When these scatter across notebooks and chat messages, dues slip, maintenance runs late, and an owner asking "where did our money go?" gets no answer. This guide gathers the free compound-management sheets and says what each solves and the order to start in. The templates and their pages are in Arabic.

Where to start

  1. Units, residents and vehicles: the list of units, owners and residents. The other sheets use the unit code.
  2. Maintenance dues collection: who paid, who is late and by how much.
  3. Maintenance requests and complaints: every report with its priority, owner and days open.

These three show what the compound is owed, owes and is complained about; add the rest as you need them.

Finance

Maintenance and assets

Daily operations

Property and rentals

If the association or owners rent out units, use rental portfolio and rent collection.

Governance and transparency

Using the online versions

Each sheet opens on a worked example on its own page, so try it before downloading Excel; your data stays in your browser. All of them are gathered on the compound page and the full list.

When sheets are not enough

When each manager needs a login with permissions, residents should get notifications on their phones, or you want links to the gate and meters, sheets become a burden. Softwiro can build a custom system for your compound at competitive prices, starting from the sheets you already use.

FAQ

Where do I start? Units, then dues, then maintenance requests.

Are the sheets linked? Each is its own file using the same unit code, so you copy the list between them.

Do they cover a large compound? Hundreds of units; beyond that a custom system helps.

Questions this raises

Where do I start managing a compound in Excel?

Start with the units and residents register, then dues, then maintenance requests.

Are the sheets linked?

Each is its own file using the same unit code, so you copy the unit list between them.

When do I need a system instead of sheets?

When each manager needs a login with permissions, residents need notifications, or you want gate and meter links.

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