Utility cost split calculator for landlords and tenants
How much of the bill do you charge the tenant? Pick how it is split — by consumption, a fixed amount or a percentage — and get the tenant's share, what stays with you, and the working you can paste into the statement.
Inputs
Optional — a fixed monthly amount (waste, building manager) added to the tenant's share.
Result
How it is calculated
11 / 30 × €120.00 = €44.00
€120.00 − €44.00 = €76.00
Three ways to split, and they cover almost everything
By consumption: the tenant pays their share based on a meter or heat allocator. Fairest for water, electricity and heating, but it needs regular readings — without them there is no statement.
Fixed: an agreed flat amount, say €40 a month for waste and common areas. Predictable for both sides, but it has to be revised when prices rise, or you quietly cover the difference.
Percentage: for when there are no separate meters. The share is set by floor area or by the number of occupants and written into the lease, so nobody argues about it later.
Why this gets messy in a spreadsheet
Bills arrive late and the usage is for the previous month, so the statement never quite lines up with the calendar.
With two tenants, one meter and some common area, a single wrong formula means every month is wrong — and you usually notice at the annual reconciliation.
What the lease should say about costs
Which costs the tenant pays, and how each of them is split — by consumption, fixed or as a percentage.
The payment deadline for the statement, and an agreement on meter readings at move-in and move-out. A photo of the meter at handover settles more disputes than any clause.
Frequently asked questions
Who pays for water — landlord or tenant?+
Running costs created by using the flat (water, electricity, heating, waste) are usually paid by the tenant. Costs that come with ownership — reserve fund, building insurance, land use charge — stay with the landlord. The lease decides.
How do I split one bill between two tenants?+
Charge each of them their metered usage, then split the remainder up to the total bill (common areas, losses) by the agreed key — per person or per square metre. Run the calculator once per tenant.
What about costs while the flat is empty?+
Costs during a vacancy are the landlord's. Include them as a vacancy cost in your yield calculation, otherwise the return looks better than it is.
Can I charge a flat monthly amount?+
You can, if the lease says so. It is worth reconciling once a year against the actual bills, so nobody over- or underpays for a whole year.