Furniture Split Calculator for Roommates in Google Sheets

Furnishing a new apartment hits all at once: the living room couch, the dining set, the cookware, usually within the same few weeks. Who pays for the sofa, and what happens if only two of the three roommates actually use the second desk? Those are the questions that turn into arguments when nobody keeps a record. A basic spreadsheet, set up before anyone swipes a credit card, removes the friction before it starts.

You don't need paid software, to be honest. One simple sheet tracks every receipt, divides each cost among the specific people involved, and tallies running balances automatically. It keeps everyone honest.

How to Structure Your Furniture Tracker

Keep item details and personal contributions in separate columns. That separation sounds fussy until you're three or four people sharing a place, at which point some purchases clearly belong to the common room while others belong strictly to whichever pair shares the bedroom, and without clean columns you'll never remember who was in on what. Use this column order across row 1:

Row 2 is where the real expenses start. A 1 in a roommate column marks that person as a participant; a 0 leaves them out. If Alex buys a desk that Jordan never uses, Alex gets a 1, Taylor gets a 1, and Jordan gets a 0. Zero just means they opted out.

Core Formulas for Shares and Balances

Shared sheets get messy the moment someone leaves a blank cell or deletes a number. Turns out, unhandled division errors are the most common reason roommate sheets break down. Plan for them.

In the Cost Per Person column, enter this in row 2:

=IFERROR(C2 / SUM(E2:G2), 0)

The formula divides total cost by the number of marked participants. If nobody is marked yet, wrapping it in IFERROR to handle empty cells returns zero instead of a broken error code. Empty cells cause errors without it.

Running balances go in a small summary box at the top of the sheet. The math per person: everything they paid upfront, minus what they owe for the items they use.

=SUMIF($D$2:$D$50, "Alex", $C$2:$C$50) - SUMPRODUCT($H$2:$H$50, $E$2:$E$50)

The first part sums every dollar Alex paid. The second calculates what Alex actually owes for the items used. A positive balance means the group owes Alex money. A negative one means Alex pays the others.

Setting Permissions and Locking Formulas

It takes one accidental keystroke to type over a formula cell, and someone will do it eventually. Secure the file first:

1. Highlight your header row and freeze it under View, then Freeze, then 1 row.
2. Share the sheet with your roommates as Editors so they can log items.
3. Select your formula columns and the summary box.
4. Right-click, select View more cell actions, and click Protect range.
5. Follow the standard process for protecting ranges in Google Sheets to restrict editing to yourself.

Accidental overwrites stop there. Roommates can log purchases from their phones and the math stays safe.

What Happens at Move-Out?

Thing is, buying furniture together is easy. Dividing it two years later is where arguments start. Couches lose value fast; a sofa bought for $800 drops significantly in resale value the moment someone sits on it. Before anyone spends money, pick one of three standard approaches:

• The silo method: Skip joint ownership altogether. Alex buys the sofa, Jordan buys the dining table, Taylor buys the TV, and everyone takes their own furniture when leaving.
• Depreciated buyouts: If an item is truly co-owned, someone keeps it at move-out by paying out the remaining roommates. Common household pieces lose about 20% of their value per year, so calculate buyout shares against depreciated value, not retail cost.
• Sell and split: Sell shared items online before moving out and divide the cash evenly.

Decide this early. Put the rule in your sheet notes.

Routine Habits to Prevent Disputes

A tracker only prevents disputes if people actually keep it updated. Months of silence followed by a surprise debt is exactly what you're trying to avoid.

Log every new purchase within two days of checkout. Note the store and the receipt total so any expense stays easy to verify later. Settle balances once a month over bank transfers, since monthly settlements are what stop balances from turning massive.

And don't change someone else's participation numbers without asking first. That rule is about trust more than math.

Next Steps for Your Apartment Setup

Open a blank spreadsheet, add the column headers above, and lock the calculation cells before sending out the invite link. Then agree on your ownership rule while the move-out date still feels far away. That's the part a spreadsheet can't do for you.