Shared Flat Bills Split Calculator

Who this is for

Every household bill for one month, split between the flat. Each bill is divided by the number of people sharing, with the amount the others owe whoever paid it, and a flatmate table for anyone on an unequal share.

Students and renters sharing a flat or house where bills arrive in one name but are paid for by everyone, and the flatmate who ends up chasing the money.

What this helps you track

• Every bill due this month, who supplies it and when it is due
• Which flatmate paid each bill out of their own account
• Each person's share of every bill and of the month's total
• How much the rest of the flat owes the person who paid
• Agreed unequal shares, such as a larger room paying more

How to use it

1. Write the address, the month and the number of people sharing the bills at the top.
2. Enter every bill for the month with its supplier, amount, due date and the person who paid it.
3. List each flatmate with their room and, if you have agreed unequal shares, the percentage each pays.
4. Read the per-person share and the amount owed to the payer on each line; the browser and Excel versions work these out, and on paper divide the amount by the number sharing.
5. Where shares are unequal, apply each person's percentage to the total bills instead of the equal share.
6. Settle up once the month's bills are in, then start a fresh sheet for the next month.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

How does the sheet split a bill?

It divides each amount by the number of flatmates you enter at the top. The owed-to-payer column is the bill minus the payer's own share, which is what the rest of the flat owes that person between them.

What if we don't split everything equally?

Enter each flatmate's agreed percentage in the flatmates table. Multiply the total bills by that percentage to get what each person owes. Check that the percentages add up to 100 before you rely on them.

Should rent go on the sheet?

If one person pays the landlord and the rest pay them, yes: add it as a bill. If everyone pays their rent directly, leave it off and use the sheet for the shared bills only.

Can we keep it online?

The browser version saves in your own browser on the device you use, so it suits whoever manages the bills. For the whole flat to see it, share the Excel file or print it for the kitchen wall.