House Share Bills Split Calculator

Who this is for

The month's rent and bills, settled up. Each housemate's part, split equally or by agreed shares, and who still owes or is owed.

Housemates and flatmates sharing rent and bills where different people pay different bills, or where a bigger room or an extra occupant pays a larger share.

What this helps you track

• Every bill for the month, its total and who paid it
• Which bills are split equally and which by agreed shares
• What each housemate owes for the month
• What each housemate has already paid out for the house
• Who needs to pay in and who should be paid back

How to use it

1. Write the address, the month and the number of housemates in the header.
2. List each bill with its total and who paid it, and put the amount under split equally or split by share.
3. Copy the two totals from the bills table into the equal total and share total boxes in the header.
4. Enter each housemate with their agreed share % for share-based bills and what they paid out this month.
5. What each person owes, and what they pay in or get back, is worked out in the browser and the workbook; tick each one off when settled.

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 do equal and share-based bills combine?

Each housemate owes the equal total divided by the number of housemates, plus their share % of the share-based total. A house that splits everything equally can leave the share column empty.

Why do I copy the totals into the header?

The housemate lines work from those two figures. The summary compares them with the bills table, so a difference other than zero means a total has not been copied across or a bill has been added since.

How should shares be set?

However the house agrees, for example by room size or for a couple sharing a room. The sheet applies your percentages and does not suggest any; they should add up to 100.

What about one-off shared purchases?

Everyday shared shopping is easier to track on the house share kitty and shared purchases log. Use this sheet for rent and the regular bills.