You run the owners' association of a building or compound. The electricity, water, gas and elevator bills come in one name, and you must tell each unit what its share is, with a number a neighbour can check. The free shared utilities splitter does that: you enter the bills and every unit gets its statement.
The problem
Splitting with a calculator looks easy for one month. It gets messy when there are several bills and the units differ. One owner wants it split by area, another says water should follow household size, a third wants it equal. At the end of the month you do not know whether what you collected covers the bill, and when a neighbour asks how his figure was reached you cannot show it. If the association changes the method at a meeting, you redo everything.
How the sheet solves it, step by step
- Pick the method. From a list in "Settings": by area, equally, by household size, or by a fixed share. Type the months you work with as 2026-09.
- Enter the units. In "Units" write the code, owner, area, household size and fixed share. Fill the column your method needs; the sheet computes each unit's weight and its percentage of the total.
- Record the bills. In "Bills" write the month, the type (electricity, water, gas, elevator) and the amount. Two bills of the same type in one month are fine.
- Read the results. "Shares" adds up what each unit owes per month; "Unit statement" shows the detail.
- Verify. "Summary" compares each month's bills with the sum of the unit shares and says "مطابق" (matches) or "راجع" (review).
What each sheet does
- Settings: the method, the allowed rounding difference and the month list. Changing the method recalculates everything.
- Units: unit data with weight and percentage. A unit missing what the method needs (an area, for example) gets a "data missing" flag so it is not forgotten.
- Bills: the log of shared bills, with a warning if you type a month that is not in the list.
- Shares: each unit's share per month and its total.
- Unit statement: pick the unit and the month from two lists and get a clean statement by bill type, plus a ready sentence you can copy into a message, or print the page.
- Summary: bills by month and type, the sum of the shares, the difference and the status.
Why it matters
People accept a number they understand. A statement that shows the method, the unit's percentage and each bill leads to fewer questions and fewer arguments. For the treasurer, the match check means the books will not come out short or over because of an addition slip. And changing the method costs nothing, so you can try area against household size and see the difference before the association meets.
A walk-through with the sample sheet
These numbers come from the sample data in the sheet; they are not real people. There are nine units: eight have areas totalling 900 square metres and the ninth (B301) has no area, so it shows "data missing" and pays nothing until it is completed. The method is "by area".
- 2026-08: electricity 4,500, water 1,800, elevator 900, total 7,200, which is 8 pounds per square metre. Unit A101 (100 m²) pays 800.
- 2026-09: total 7,650, or 8.5 per square metre, so A101 pays 850.
- 2026-10: electricity 3,600 (two bills: main meter 2,700 and stair lighting 900), water 2,250, gas 1,000, elevator 900, total 7,750. A101 pays 861.11.
- Unit A202 (150 m²) in 2026-10 pays 600 for electricity, 375 for water, 166.67 for gas and 150 for the elevator: 1,291.67 in all.
- A101 across the three months: 2,511.11.
The Summary shows the October shares add up to 7,749.99 against 7,750 of bills. The one-piastre gap is rounding, so the status is "matches".
The online version
The online version on the template page opens on the same example, so you edit cells and see results immediately. You can add a unit or a bill with a simple form instead of typing into the table, import and export .xlsx files, and your data stays in your browser on your own device.
Who it suits
A treasurer or chairman of an owners' association in a small or medium building or compound who pays shared bills and splits them every month. If you also track neighbours' fees, try the owners' association dues sheet, and for repairs and complaints the maintenance requests sheet. If several people need to enter data at once, we can build software around the way you work.