Use a free Google Sheets template with columns for date, description, amount, moving category (e.g., truck rental, deposit), split type (equal, reimbursement), payer, and per-person shares. Add formulas like =SUMIFS for category totals and share via edit links for real-time group tracking. This works for U.S. roommates or moving groups handling one-time costs like utilities deposits, packing supplies, and cleaning fees without paid apps.

Google Sheets provides a no-cost way to log expenses during a move, calculate shares, and settle up. Everyone adds entries as costs come up, such as a U-Haul rental or security deposit. Formulas update balances automatically, and version history tracks changes. For simple moves with 2-6 people, this avoids app subscriptions.

Recommended Columns for a Moving Expense Tracker

Start with these essential columns to capture moving-specific details and enable fair splits. They handle one-time costs like truck rentals, supplies, and fees.

  • Date: When the expense happened (e.g., 2026-03-15). Sort by this for timelines.
  • Description: What was bought (e.g., "U-Haul 20-ft truck for 2 days").
  • Amount: Total cost in USD (e.g., 250.00).
  • Category: Moving type like "Truck Rental", "Deposit", "Packing Supplies", "Cleaning Fees", or "Utilities Transfer". Group similar items for summaries.
  • Payer: Who paid upfront (e.g., "Alex" or email). Track reimbursements from here.
  • Split Type: "Equal" for even shares, "Reimbursement" for one person covering 100% then getting paid back, or "Custom" for usage-based like room size.
  • Share % per Person: Columns for each group member (e.g., Alex 33%, Jordan 33%, Sam 34%) adding to 100%. For reimbursements, mark one at 100% and others at 0%, as in ExpenseSorted's roommate template.

Add a Balance column with a formula like =SUMIFS(Amount range, Payer range, "Alex") - SUM(Share % columns for Alex). This shows who owes or is owed.

These columns support equal splits for shared truck time or reimbursements for personal items like one person's boxes. Input sample data first: truck rental of $250 split equally among three, or $100 deposit paid by one.

Setup Steps to Build and Customize the Template

Follow these steps to create the tracker from scratch.

  1. Go to sheets.google.com and click "Blank" for a new sheet. Name it "Moving Expenses 2026 - [Group Name]".
  2. In row 1, enter headers: Date, Description, Amount, Category, Payer, Split Type, then one column per person (e.g., Alex %, Jordan %, Sam %).
  3. Format columns: Date as date, Amount as currency ($). Use Data > Data validation for Category (list: Truck Rental, Deposit, etc.) and Split Type (Equal, Reimbursement, Custom).
  4. Add sample rows: Date 2026-03-10, Description "Packing tape and boxes", Amount 45, Category "Packing Supplies", Payer "Jordan", Split Type "Equal", shares 33/33/34.
  5. In a Summary sheet (Insert > Sheet), link totals with formulas (detailed below).
  6. Test: Enter a $500 truck rental, split equally. Check if shares calculate right.

Duplicate for "Settled" tracking post-move. Use the "Share" button next for group access.

Key Formulas for Moving Expense Analysis

Formulas pull insights like total truck costs or big expenses. Adjust ranges (e.g., B2:B100) to your data. From RelayFi's expense tracker template:

  • Category totals: =SUMIFS(C2:C100, D2:D100, "Truck Rental") sums truck costs where column D matches.
  • Summary table: In a new sheet, =QUERY(Expenses!A2:G100, "SELECT D, SUM(C) GROUP BY D LABEL SUM(C) 'Total'") lists totals per category (e.g., Deposits: $1000).
  • Large expenses: =FILTER(A2:G100, C2:C100>100) shows rows over $100, like full truck rentals.
  • Budget warning: If you add Budget and Actual columns, =AND(C2>=B2*0.8, C2<=B2) flags when spend hits 80-100% of budget (format yellow via Conditional Formatting).

For per-person owed: In Balance cell, =SUMIFS(C:C, F:F, "Alex") - SUMIFS(C:C, G:G, "Alex %") * total shares. Copy down. These adapt for moving by filtering categories like "Cleaning Fees".

Sharing and Collaboration for Group Use

Real-time edits let roommates update during the move. As in ExpenseSorted's template, grant edit access for live changes.

  1. Click "Share" (top right). Add emails with "Editor" role.
  2. For groups without emails, click "Change to anyone with the link" > "Editor".
  3. Notify via text: "Edit our moving tracker here: [link] - add receipts as you pay."
  4. Track edits: File > Version history > See version history. Restore if needed.

Set notifications (Tools > Notification settings) for changes. Revoke access post-move.

Handling Common Splits and Reimbursements in Moving

Moving costs mix shared and personal. Use split types for fairness.

  • Equal split: Truck gas or group cleaning supplies - 100% / number of people.
  • Reimbursement (100%/0%): One pays deposit, others reimburse. Mark payer 100%, others 0%.
  • Usage-based: Larger room pays more for truck (e.g., 50/30/20 by square footage).
  • Income-based: Proportional to earnings, if agreed upfront.

Workflow: Log expense > Assign % > Payer requests via Venmo/Zelle with sheet link. Review weekly: "Alex owed $150 total - paid?" Update "Settled" column. Tradeoffs: Equal is simple but ignores usage; custom fits uneven moves but needs consensus.

Common Mistakes and When to Use Apps Instead

Avoid these pitfalls:

  • Formula ranges too narrow (e.g., B2:B10 misses new rows) - use B:B or dynamic named ranges.
  • Sharing as "Viewer" only - changes won't save; always "Editor".
  • No version history checks - disputes over "who entered what".
  • Forgetting receipts - add a "Receipt Link" column (Google Drive share).

Spreadsheets suffice for moves under 20 expenses, small groups, or one-time use. They handle tracking and splits without fees. Consider apps if you need receipt scans, auto-payments, or 50+ transactions - but start here for free. For ongoing roommate bills post-move, expand the template or migrate.

FAQ

How do I mark a reimbursement for moving supplies in the template?
Set Split Type to "Reimbursement", payer at 100%, others at 0%. Balance shows amount owed to payer.

What if someone forgets to update the sheet during the move?
Assign one "logger" role, send weekly reminders, or photograph receipts and add later with date noted.

Can I use these formulas for Excel instead of Google Sheets?
Most work (SUMIFS, FILTER), but QUERY is Google-only. Use PivotTables for summaries in Excel.

How often should our group review the moving tracker?
Weekly during move, then monthly until settled. Set Google Calendar reminders linked to the sheet.

Is this template good for tracking security deposit returns?
Yes - log return as negative amount in Deposits category, split equally or per original payer.

What split works best for uneven moving contributions?
Custom % by room size or items moved. Discuss upfront; equal for simplicity if contributions balance overall.