Proper Spreadsheets

Templates › Free to download

Shared House Bills Splitter

Made for housemates, couples and students who share the bills.

Log every household bill, see who has paid what, and who owes or is owed so four housemates split everything evenly. The summary carries a chart that redraws itself as you type.

Tabs
3
Columns
9
Fill themselves in
16

Freeno card, no email, no sign up

Download it free

  • Opens in Excel, Google Sheets and Numbers
  • Free, with nothing to sign up for
  • No macros, nothing to install
  • Describe your own when you are ready

Yours to keep, change and share. Built exactly as every spreadsheet here is, so it is a fair picture of what you would get from describing your own.

The workbook's summary and the table behind it
A row typed into the real file. Every figure that changes is the spreadsheet's own arithmetic.
The summary page, every figure calculated from the tables
The chart, drawn from the totals in the table beside it
What is inside: the tabs, the columns and what fills itself in
Where you type, and the shaded columns that work themselves out
The guide sheet that opens first and explains the file
Everything included in the download

Everything inside, before you pay

This is the whole design: every tab, every column and how each calculated one is worked out. White cells are yours to fill in; the shaded ones work themselves out and are locked so a formula cannot be overwritten by accident. There is room for 412 rows.

Housemates

Everyone who lives in the house, with what they have paid, their fair share and their balance. Room for 12 rows.

ColumnTypeWorked out as
Housematetext
Total PaidcurrencyIF(ISBLANK([name]), "", SUMIF([Bills!paid_by], [name], [Bills!amount]))
Fair SharecurrencyIF(ISBLANK([name]), "", ROUND(IFERROR(SUM([Bills!amount])/COUNTA([Housemates!name]), 0), 2))
Owed or OwescurrencyIF(ISBLANK([name]), "", ROUND(SUMIF([Bills!paid_by], [name], [Bills!amount]) - IFERROR(SUM([Bills!amount])/COUNTA([Housemates!name]), 0), 2))

Bills

Every bill the house pays, who paid it and when. Room for 400 rows.

ColumnType
What It Was Fortext
Categorychoice (list)
Amountcurrency
Date Paiddate
Paid Bychoice (from Housemates › name)

Summary

The house's spending at a glance.

MeasureWorked out as
Total spentSUM([Bills!amount])
Spent this monthSUMIFS([Bills!amount], [Bills!date_paid], ">="&DATE(YEAR(TODAY()), MONTH(TODAY()), 1), [Bills!date_paid], "<="&EOMONTH(TODAY(), 0))
Spent last monthSUMIFS([Bills!amount], [Bills!date_paid], ">="&(EOMONTH(TODAY(), -2)+1), [Bills!date_paid], "<="&EOMONTH(TODAY(), -1))
Each person's share this monthROUND(IFERROR(SUMIFS([Bills!amount], [Bills!date_paid], ">="&DATE(YEAR(TODAY()), MONTH(TODAY()), 1), [Bills!date_paid], "<="&EOMONTH(TODAY(), 0))/COUNTA([Housemates!name]), 0), 2)
Each person's share of everythingROUND(IFERROR(SUM([Bills!amount])/COUNTA([Housemates!name]), 0), 2)
RentSUMIF([Bills!category], "Rent", [Bills!amount])
EnergySUMIF([Bills!category], "Energy", [Bills!amount])
WaterSUMIF([Bills!category], "Water", [Bills!amount])
BroadbandSUMIF([Bills!category], "Broadband", [Bills!amount])
Council taxSUMIF([Bills!category], "Council Tax", [Bills!amount])
FoodSUMIF([Bills!category], "Food", [Bills!amount])
OtherSUMIF([Bills!category], "Other", [Bills!amount])
Number of bills loggedCOUNTA([Bills!description])