Split Moving Costs by Budget Share in Google Sheets

Why split a $600 moving truck down the middle if one roommate earns three times as much?

A standard 50/50 split seems simple on paper. In practice, it forces the lower earner to take on a disproportionate financial hit before moving day even starts.

Budget-share splits solve this tension. Instead of splitting every receipt right down the center, your group divides shared move expenses proportionally based on monthly take-home income or agreed moving allowances. If your combined household income is $6,000, and you bring in $3,600, your share is 60%. Your roommate covers the remaining 40%.

Google Sheets handles these ratios cleanly without requiring paid subscription apps. Here is how to structure the sheet, write the formulas, and avoid calculation mistakes.

When Proportional Splits Make Sense

Proportional splitting works best for high-dollar joint expenses that benefit everyone equally. Shared truck rentals, professional movers, parking permits, communal cleaning supplies, and security deposit holding fees fit this category.

Turns out, not every moving charge belongs in a proportional pool. Personal bedroom boxes, specialty packing for one person's piano, or storage units used exclusively by one roommate should be assigned 100% to that individual.

Cash settles fast when rules are clear. For major logistics expenses, proportional shares prevent resentment. Use an equal split for minor incidental items if everyone agreed in advance.

The Sheet Blueprint

Set up your ledger on a single tab named "Move Ledger". Put overall income figures in a top header block, then build out the expense rows below.

A layout like this mirrors the flexible tracking approach popularized in the Split Expenses spreadsheet guide, giving you a visible paper trail for every line item.

The Formulas and Formatting Rules

Getting percentages right in spreadsheets trips up a lot of people.

Google Sheets treats percentages as decimals behind the scenes. When you enter 60% or format a cell as a percentage, Sheets stores the underlying value as 0.6. As explained in this Google Sheets percentage formula tutorial, typing =C5*60% or =C5*0.6 works, but multiplying by 100 on a cell formatted with the percent symbol will inflate the number to 6000%.

I once watched two roommates argue for an hour over an eight-hundred-dollar moving truck invoice because someone accidentally formatted the calculation column twice, effectively billing one person sixty times their actual income, which obviously was impossible but still caused immense panic before anyone spotted the rogue decimal point.

Suppose Alex takes home $3,600 per month in cell B1 and Taylor takes home $2,400 per month in cell B2. Total combined income is $B$1+$B$2.

To generate Alex's base share percentage in row 5:

=$B$1/($B$1+$B$2)

Lock fixed header cells with dollar signs before dragging formulas down. That prevents broken references.

The dollar amount Alex owes for the expense in row 5 is:

=C5*F5

For Taylor in row 5:

=C5*G5

When an expense belongs to one person alone, change the Split Type to Solo. Set the buyer's share to 100% and the other person's share to 0%. The math updates automatically.

Calculating Net Balances Without Confusion

Tracking what each person owes is only half the job. You also need to track who actually pulled out their credit card at the rental counter.

Thing is, people frequently confuse what they owe with what they paid. If Alex puts down $450 for the rental truck, Alex does not owe another $270 on that bill. Alex already fronted the cash. Taylor owes Alex their $180 share.

To calculate this automatically, build a small summary block with three rows for each participant:

1. Total Paid Out of Pocket: =SUMIFS(C5:C100, D5:D100, "Alex")
2. Total Share Owed: =SUM(H5:H100)
3. Net Balance: =Total Paid Out of Pocket - Total Share Owed

A positive net position means the group owes that person money. A negative position means that person must send cash to settle up. One bank transfer at the end wipes the slate clean.

Step-by-Step Setup

1. Open a blank Google Sheet and label the first tab "Moving Costs".
2. Enter take-home monthly incomes in cells B1 and B2, labeling column A with participant names.
3. Add the ledger headers across row 4 from column A through column J.
4. Format column C, column H, and column I as Currency. Format columns F and G as Percentages.
5. Create the summary block in cells L4 to N7 using the SUMIFS and SUM formulas.
6. Test your math with a mock $300 deposit to make sure the net balances offset to zero.
7. Share the file with edit permissions with your moving group.

Mistakes That Wreck Shared Move Trackers

• Mixing pre-tax salaries with take-home pay: Always use net take-home cash, because pre-tax numbers distort how much disposable money someone actually has on moving day.
• Forgetting to lock cell references: Dragging formulas without dollar signs shifts your income cell references down into empty rows.
• Omitting receipt links: Keep a Google Drive folder for digital receipts and drop the URL directly into the notes column to prevent memory disputes later.
• Letting unsettled balances linger: Establish a strict rule to settle all moving balances within seven days after unloading the truck.

Spreadsheet vs. Dedicated App

A shared spreadsheet gives you complete control over custom budget percentages and expense classifications. It costs nothing. There are no monthly subscriptions or paywalled export features.

To be honest, dedicated expense-splitting apps offer convenience when everyone is grabbing quick fast food on moving day and nobody wants to open a mobile browser. But for multi-hundred-dollar deposits, truck rentals, and uneven salary splits, a clean Google Sheet provides clear accounting that both parties can audit and archive indefinitely.

Finalize your budget percentages before booking the truck, input expenses as they occur, and reconcile the final net balance on your first weekend in the new home.