Moving day generates a messy trail of separate expenses. You pay $160 for the cargo van. Another roommate buys $45 worth of cardboard boxes and bubble wrap. Someone else pays for parking permits, ratchet straps, or lunch for friends carrying sofas. Why download a paid budgeting app just to split ten receipts across a single weekend?
Turns out, a basic spreadsheet handles this without forcing everyone to download new software. You can enter moving expenses line by line, assign who participated using simple 1 or 0 marks, and let basic formulas tally who owes what.
Setting Up the Itemized Receipt Layout
Structure your sheet so each physical receipt item gets its own row. Setting it up by line item rather than whole receipts works better because mixed purchases happen constantly. One person might grab moving tape for the living room and a personal shower curtain on the same Home Depot run.
| Column | Header | What to Enter | Sample Entry |
|---|---|---|---|
| A | Date | Date on receipt | 2026-06-01 |
| B | Item Description | What was bought | 26ft Moving Truck Rental |
| C | Total Cost | Final amount with tax | $185.50 |
| D | Paid By | Name of buyer | Jordan |
| E | Alex | 1 if Alex shares cost, 0 if not | 1 |
| F | Jordan | 1 if Jordan shares cost, 0 if not | 1 |
| G | Taylor | 1 if Taylor shares cost, 0 if not | 1 |
A binary mark under each roommate keeps data entry fast. Type a 1 if that person benefits from the expense. Leave it at 0 if they do not.
Formulas to Calculate Item Shares and Totals
Once your columns are ready, you need three calculations: each person's cost per item, the total each person paid at checkout, and their net final balance.
-
Cost per participant on a single line: In helper columns next to your raw data, calculate each person's dollar share for that specific purchase. For Alex in row 2:
=IF(E2=1, $C2/SUM($E2:$G2), 0)If three roommates share a $180 truck, the formula detects three 1s and assigns $60 to Alex. If you leave a row empty, dividing by zero causes a#DIV/0!error. Wrapping formulas with IFERROR in Google Sheets keeps your sheet clean by displaying a zero instead of a formula crash. -
Total paid upfront by each person: Above or below your receipt log, create a small summary box. To sum every dollar Jordan paid across all receipts, use SUMIF in Google Sheets:
=SUMIF($D$2:$D$50, "Jordan", $C$2:$C$50)This inspects column D, matches Jordan's name, and sums the corresponding charges in column C. -
Total owed versus net balance: Add up each roommate's individual share column to see their total cost responsibility:
=SUM(H2:H50)Finally, subtract what someone owes from what they already paid upfront:=Total_Paid - Total_OwedA positive number means the group owes that person money. A negative number means they need to send money out.
Managing Unequal Shares and Solo Purchases
Moving costs rarely divide cleanly into equal thirds.
Thing is, someone always has an irregular expense that trips up basic division. Maybe one person takes the master bedroom with an attached bath and agrees to cover 45% of the security deposit, or someone buys packing foam strictly for their private computer monitors.
- Personal supplies: Mark 1 under the buyer and 0 for everyone else, which charges the entire receipt line directly to them without affecting group totals.
- Custom percentage splits: Replace the 1/0 flags on that row with decimal percentages such as 0.50, 0.30, and 0.20, then multiply total cost by that percentage.
- Cash reimbursements: Log cash handed directly to the truck driver as an expense paid by that person so their balance stays accurate.
Protecting Cells and Sharing Access
Collaboration gets messy when multiple people edit numbers from their phones during a move.
To keep roommates from accidentally typing over your math, protect ranges in Google Sheets before sending the share link. Select your formula cells and summary tables, right-click, and pick Protect range. Set the permissions so only you can alter formulas, while leaving columns A through G open for anyone with the link to type in receipts.
I usually drop a link to a shared Google Drive photo folder right in row 1, because somebody always loses the paper fuel receipt between the gas station pump and the new apartment hallway, and having the photo saved saves twenty minutes of frantic searching later.
Spreadsheets Versus Expense Apps
Do you really need a spreadsheet instead of Splitwise or Venmo groups?
Spreadsheets make the most sense for closed, one-time projects with a definite end date. Moving is the classic example.
- Spreadsheets work best when your move involves under 40 receipts and you want an unchangeable audit log without requiring app accounts.
- Dedicated apps work better if you plan to track recurring household utilities, split groceries weekly, and request direct bank settlements over the next year.
Final Settlement Steps
Settling moving debt does not need complex multi-way transfers.
Look at your net balance row. If Alex is +$70, Jordan is -$40, and Taylor is -$30, Jordan and Taylor simply send payments directly to Alex. Done.
To be honest, arguing over pennies after hauling furniture up three flights of stairs ruins relationships faster than anything else. Round off the odd cents, confirm payments over text, and archive the sheet.