Co-Living Space Expense Splitter

A co-living house is not a three-person flat. More residents, rooms of genuinely different sizes, shared spaces everyone uses, and a constant drip of shared consumables — splitting that fairly with a free 3-person template stops working fast. This splitter is built for the whole house: up to 6 residents, rent blended two ways, bills split per head, and a house fund that actually gets settled.

The sample house: 5 residents, $3,850 rent. 70% of the rent is priced by private room size (Ava’s 200 sq ft room carries $700.00 of it), 30% splits equally for the common areas ($231.00 each) — Ava’s total share is $931.00, Esme’s (120 sq ft) is $651.00. Shared bills total $811.00, or $162.20 each; Ava fronted $541.00 of them. Settlement nets it all into 5 transfers: the four other residents pay Ava their bill balances, and Chloe — who paid $25.00 of her $40.00 house-fund share — pays the missing $15.00 into the fund. Bills AND fund end at zero, which no free splitter on the shelf can say.

What it does for you:
– Splits rent for up to 6 residents by a blend YOU set: part by private room size, part equally for common areas
– Splits every shared bill equally per resident and tracks who fronted each one
– Runs a house fund for shared consumables — due, collected, shortfall and who is behind, all visible
– Settles EVERYTHING: the who-pays-whom matrix for bills plus fund arrears as an explicit transfer
– Adds a house admin expense log, zero-based monthly budget, dashboard and 12-month summary

What’s inside (.xlsx, works in Excel AND Google Sheets):
– Start Here — setup steps, total rent, size-share % and house fund settings
– House Split — resident roster with two-part rent shares, shared bills, house fund position
– Settlement — per-resident balances, the netted who-pays-whom matrix, fund arrears and transfer count
– Expense Log, Monthly Budget, Dashboard, Monthly Summary

Instant download. Type only in the yellow cells — formula cells are locked (password: sheetdaily, disclosed on the Start Here tab so you can unlock if you ever need to). Sample house is pre-filled so you can see exactly how it works; clear the yellow cells and type your own. House tracking tool only — not financial or legal advice.