Moving into a new home with roommates is chaos even on a good day. The money is the part nobody plans for. Small bills add up fast. Someone puts $420 on the rental van. Someone else covers the utility setup charges, and two different people buy the packing tape. Weeks after the boxes are unpacked, the balances are still sitting there. Why do these small costs turn into bitter arguments? With no clear repayment deadline, everyone assumes someone else will sort out the math later. The silence is where the resentment starts.
Deadlines cut through that friction. A due date column forces every roommate to agree upfront on when money actually changes hands. Google Sheets gives the group one shared, free workspace where anyone can see what was paid, who paid it, and what's overdue. Nobody has to guess.
Essential Columns for Your Moving Tracker
Your ledger needs just enough detail to verify a receipt later, and not much more. Eight columns will do it:
- Date: the day someone paid, whether by card swipe or cash transfer.
- Description: the exact expense, like a rental truck deposit or mattress bags.
- Amount: the total cost, formatted as standard U.S. currency.
- Category: chosen from a dropdown menu so the spelling stays consistent.
- Due Date: when roommates have to settle their portion.
- Paid Status: a simple Pending, Complete, or Overdue.
- Payer: the person who fronted the money.
- Notes: links to photo receipts or details on uneven splits.
Lean columns matter once the move gets hectic. Three people logging expenses from their phones don't have patience for a cluttered screen. Everyone should know where to look at a glance.
Step-by-Step Sheet Setup
Building the whole tracker takes under ten minutes. Open Google Sheets in a desktop browser, create a blank workbook, and work through these steps:
- Label row 1 with your headers across columns A through H: Date, Description, Amount, Category, Due Date, Paid Status, Payer, and Notes.
- Select column C and click Format > Number > Currency.
- Select columns A and E together and set them to Format > Number > Date.
- Select column D, open Data > Data validation > Add rule, choose "Dropdown", and add values like Moving Truck, Security Deposit, Utility Deposits, Packing Supplies, and Cleaning.
- Give column F its own dropdown with three choices: Pending, Complete, and Overdue.
- Click View > Freeze > 1 row.
That last step sounds trivial. It isn't. With the header frozen, row 1 stays pinned while you scroll down a long receipt list, and the columns still make sense on a phone.
Formulas for Category Totals and Due Date Alerts
Formulas turn a static log into something closer to a dashboard. You don't need to write code. Two or three of them cover the essentials.
To total one category, like truck rentals, use SUMIFS:
=SUMIFS(C2:C100, D2:D100, "Moving Truck")
The formula scans column D for "Moving Truck" and adds up the matching dollar values in column C, updating the moment anything changes. If you'd rather see every category broken out without typing each name by hand, drop this QUERY into a separate summary tab:
=QUERY(A2:H100, "SELECT D, SUM(C) GROUP BY D LABEL SUM(C) 'Total'")
Turns out you can also track tabs across months using =INDIRECT("'"&C3&"'!C2:C100"), which is laid out in this Google Sheets expense tracker tutorial. It's handy when a move stretches over a couple of months and you keep one tab per month. The one catch: tab names have to match cell C3 exactly, or the reference breaks.
Overdue alerts are the part that keeps roommates honest. Select your data rows from A2 through H100, open Format > Conditional formatting, and pick "Custom formula is" from the rule menu. Enter this:
=AND($E2<TODAY(), $F2<>"Complete")
Set the fill color to soft red. As this date-related conditional formatting guide explains, the dollar sign locks column E so the rule can test the due date across the entire row. Once today passes the deadline and the status still reads Pending, the whole row goes red. Nobody misses that.
Keep a running count of overdue items on your dashboard too:
=COUNTIFS(E2:E100, "<"&TODAY(), F2:F100, "<>Complete")
It refreshes itself every day.
Permissions and Preventing Accidental Deletions
Group spreadsheets tend to die the same way. Someone taps the wrong cell on a phone and wipes out a formula. Set your permissions before that happens.
Click Share in the top right and add roommates by email with "Editor" access. They need to log costs and flip their own entries from Pending to Complete, and Viewer access blocks exactly that. Viewer sounds safer on paper. It isn't, because a roommate who can't update their own status can't really use the sheet at all. For a clear walkthrough of the access roles, this Google Sheets permissions guide is worth two minutes.
Then protect the fragile parts. Highlight row 1 or your summary formulas, right-click, and select Protect range. This range protection tutorial shows how to restrict those cells to yourself while leaving the data rows open for everyone else. The setup takes two minutes and saves you from accidental damage during casual mobile browsing.
Handling Splits and Reimbursement Deadlines
Moving costs rarely split evenly. One roommate takes the master bedroom with the attached bath. Another arrives with two suitcases and no furniture. Same truck, same move, very different claim on the space.
Thing is, settling the method upfront is what prevents the resentment later. The FairSplit moving cost checklist recommends clearing outstanding balances within seven days of move-in. A week gives people enough time to review receipts without letting debts drift into the next rent cycle. Clear timelines keep friendships intact.
Choose a split method for each expense before anyone spends:
- Equal shares: the moving truck rental, parking permits, and basic cleaning supplies.
- Room-size ratios: security deposit and first month rent when bedrooms differ significantly in square footage.
- Usage-based splits: fair when one roommate rents a storage unit alone or brings heavy furniture that needs extra movers.
- Shared starter funds: everyone puts $30 into a communal pool for tape, boxes, and cleaning wipes, which saves you from logging ten-dollar receipts.
Log the method in the Notes column. Say Alex pays $300 for the truck and the cost splits three ways. Alex logs the full $300 under Amount and notes that Sam and Jordan each owe $100 by Friday. That single line of notes is what stops the argument three weeks later.
Spreadsheets vs. Expense Apps
Which one fits depends on your group size and how much receipt volume you're actually dealing with.
| Feature or Scenario | Google Sheets Tracker | Bill-Splitting Apps |
|---|---|---|
| Group size | 2 to 4 roommates | 5 or more people |
| Expense volume | Under 30 moving items | High-volume ongoing daily spending |
| Custom due dates | Built-in column with custom alerts | Often lacks rigid calendar deadlines |
| Receipt attachments | Link Google Drive photos in notes | Native mobile camera scanning |
| Cost | 100% free | Free tiers with paid upgrades |
| Direct payments | Manual settlement via cash apps | In-app settlement integrations |
A one-time move sits firmly in spreadsheet territory. You control the columns, the due dates, the entire layout. Apps earn their keep on high-volume ongoing spending, where automated daily push notifications actually matter.
Fixing Common Setup Mistakes
Most errors trace back to minor formatting quirks, and three of them come up over and over.
Mismatched category text. Someone types "Truck" in row 5, your formula hunts for "Moving Truck", and it just skips the row. The SUMIFS total comes back low and nobody knows why. This is exactly what the column D dropdown prevents. Dropdowns kill spelling drift completely.
Dates stored as text. Type "April 1" without a year, or mix up your slash styles, and Sheets can store the entry as text instead of a date. Then TODAY() has nothing real to compare against, and the conditional formatting fails without an error message. It doesn't crash. It just never fires. Use the date picker when you can, and double-check the column formatting after the fact.
Forgetting receipt verification. Someone logs $180 for supplies, loses the paper receipt, and two weeks later another roommate questions the number. To be honest, hunting a lost receipt while you're surrounded by half-unpacked cardboard boxes is miserable, and it usually ends with somebody covering a cost that wasn't theirs. Paper gets lost instantly. Require a photo upload to a shared folder and paste the link into the Notes column instead.
Put a real date on the calendar, like the first Sunday after move-in. Everyone sits down together, opens the sheet, checks the balances, and clears every outstanding one. Build the sheet before the packing starts.