Use a Google Sheets template to calculate and track moving costs split equally. Set up columns for date, expense description, total cost, number of sharers, and per-person share. For example, enter the total cost and number of sharers, then divide to find the per-person amount.

This works for U.S. roommates or friends handling one-time moves in 2026, such as truck rentals, boxes, deposits, and labor. Enter expenses row by row, and the sheet tallies balances owed. Share the link for group edits without needing payment apps, as long as everyone agrees on equal splits upfront.

When to Use a Spreadsheet for Equal Moving Cost Splits

Spreadsheets suit simple, equal splits on one-time moves where tracking records matters more than chasing payments. For example, four roommates splitting a $300 U-Haul rental enter the total once, divide by four, and note who paid upfront.

They work well if your group trusts each other and handles reimbursements informally, like cash or Venmo outside the sheet. No automation for reminders or payments, so manual updates keep it accurate.

Switch to apps if you need payment requests, receipt scans, or notifications - spreadsheets stay lightweight for records only. Tradeoffs include manual entry versus apps' speed for frequent reimbursements, or group size limits in free sharing.

Recommended Columns for Your Moving Costs Tracker

Build a clear structure with these columns tailored to moving expenses:

  • Date: When the expense happened (e.g., 2026-01-15).
  • Description: Specific item (e.g., U-Haul truck rental, packing boxes, security deposit).
  • Total Cost: Full amount paid (e.g., $300).
  • # Sharers: Number splitting it equally (e.g., 4).
  • Per-Person Share: Formula for equal amount (e.g., total cost divided by # sharers).
  • Paid By: Who covered it upfront (e.g., Alice).
  • Notes: Details like receipt link or agreement notes.
Example row: Date Description Total Cost # Sharers Per-Person Share Paid By Notes
2026-01-15 Moving truck $300 4 $75 Alice Equal split agreed

Add summary rows at the bottom: total costs with =SUM(C:C), total per-person owed with =SUM(E:E), and individual balances using =SUMIF(F:F, "Alice", E:E) to track who owes what.

Setup Steps in Google Sheets or Excel

  1. Open Google Sheets or Excel and create a new sheet named "Moving Costs Split."

  2. Enter the column headers in row 1 as listed above.

  3. In the Per-Person Share column (e.g., column E), enter a formula to divide the total cost by the number of sharers, such as =D2/E2. For a check against zero sharers, consider =IF(D2>0, C2/D2, 0).

  4. Add category totals: In a summary section, use =SUMIFS(C:C, B:B, "Truck Rental") to sum costs by description.

  5. Test with sample data: Enter a $120 boxes expense split by 4 ($30 each), then a $200 deposit by 3 ($66.67 each). Verify sums update.

  6. Format currency in cost columns via Format > Number > Currency.

Copy this setup to Excel; formulas translate directly, though sharing needs OneDrive links.

Sharing and Permissions for Group Access

Share via link without emails. Click Share > Get link, set to "Editor" for full access or "Commenter" for reviews, per Tiller Help Center.

For safety, protect formula ranges: Go to Data > Protect sheets and ranges. Select the Per-Person Share column, set warnings or restrict edits to yourself while allowing group input elsewhere.

Use the activity dashboard (Tools > Activity dashboard) to see changes. View-only users can request edit access via a button. Chat directly in the sheet for questions.

Common Mistakes and Fixes

  • Unprotected formulas: Groups overwrite formulas with numbers. Fix: Protect ranges before sharing.
  • Forgetting # sharers updates: If someone opts out mid-move, per-person jumps. Fix: Discuss and adjust column before formula runs.
  • Over-sharing permissions: Anyone with link edits freely. Fix: Use specific links or require sign-in.
  • No backups: Accidental deletes lose records. Fix: File > Version history weekly; export to PDF.
  • Inconsistent categories: "Deposit" vs. "Security deposit" breaks SUMIFS. Fix: Standardize descriptions.
  • Rare review cadence: Check only at move end misses errors. Fix: Weekly huddles during packing.

Review the sheet before final reimbursements.

FAQ

How do I calculate equal shares if someone pays upfront?
Track in Paid By column, then use =SUMIF(F:F, "Alice", E:E) for her total credits. Others owe her that amount.

Can I protect just the formulas in Google Sheets?
Yes, via Data > Protect sheets and ranges - select formula cells only, per Tiller Help Center.

What's a simple SUM formula for total moving costs by category?
=SUMIFS(C:C, B:B, "Truck Rental") sums Total Cost where Description matches.

When should I switch from spreadsheet to an app?
If needing payment links, auto-reminders, or scans - spreadsheets handle tracking fine for equal, one-off moves.

How do I handle moving deposits or refunds in the template?
Enter as negative Total Cost (e.g., -$100 refund); formula adjusts shares automatically.

Are there Excel-specific differences for this setup?
Formulas match, but sharing uses OneDrive links; protect via Review > Protect Sheet.

Next, test your sheet with real numbers, agree on rules verbally, and keep receipts linked. For ongoing households, expand to monthly tabs.