A simple Google Sheets moving-cost calculator can do two jobs: divide each expense equally and show who should be reimbursed. Put one expense on each row, calculate the per-person share with a protected formula, and record the person who paid upfront.
For a $300 moving truck split among four people, each share is $75. If Alice paid the full bill, Alice has a $225 credit after her own share. That is the basic equal-split model used here.
Set the rule before entering numbers
Equal splitting works best when the same people participate in each cost. If someone skips a truck, storage fee, or labor charge, use the participant method below instead of forcing one number across the whole sheet.
Agree on deposits and refunds before anyone pays. Write the rule in the Notes column. The notes can be plain. You don't need a mini accounting system.
Build the expense log
Start with one expense log. One row, one charge.
| Column | Header | What to enter |
|---|---|---|
| A | Date | 2026-01-15 |
| B | Description | Moving truck |
| C | Category | Truck rental |
| D | Total Cost | 300 |
| E | # Sharers | 4 |
| F | Per-Person Share | =IF(E2>0,D2/E2,0) |
| G | Paid By | Alice |
| H | Notes / Receipt | Receipt link and equal split agreed |
Use positive numbers for charges. A negative number is a credit or refund shared by the people included in that row.
The formula belongs in F2, not D2 or E2. Copy it down the column, then format D and F as currency. Keep the # Sharers field numeric; typing a word such as "four" may break the calculation.
Set up the sheet in Google Sheets
-
Open Google Sheets and create a blank spreadsheet. Name the tab
Moving Costs Split. -
Add the headers from the table to row 1. Enter each moving expense on its own row, including truck rental, boxes, deposits, labor, and other agreed costs.
-
In F2, enter
=IF(E2>0,D2/E2,0). This divides Total Cost by # Sharers and returns zero while a row is unfinished. -
Fill the formula down. Format D and F as currency, and format E as a number.
-
Test the sheet with two rows. A $120 boxes charge split four ways should display $30 per person. A $200 deposit split three ways should display $66.67 per person.
-
Add summary formulas below the log or in a separate area. Use
=SUM(D2:D)for net moving costs and=SUMIFS(D2:D,C2:C,"Truck rental")for the truck category. When the same members share every row,=SUM(F2:F)is one member's total fair share.
Turns out, two test rows quickly expose a bad column reference. Test before sharing the file.
Calculate who is owed
Add a member summary to the right of the expense log. Use one row for each person.
| Column | Header | Formula or entry |
|---|---|---|
| J | Person | Enter a name, such as Alice |
| K | Paid toward expenses | =SUMIF($G:$G,J2,$D:$D) |
| L | Fair share | =SUM($F:$F) |
| M | Net position | =K2-L2 |
These formulas assume the same members share every expense row. Copy the formulas down for each person.
For one $300 truck charge paid by Alice, the result looks like this:
| Person | Paid | Fair share | Net position |
|---|---|---|---|
| Alice | $300 | $75 | +$225 |
| Ben | $0 | $75 | -$75 |
| Cara | $0 | $75 | -$75 |
| Dev | $0 | $75 | -$75 |
A positive net position means the group still owes that person. A negative position means that person owes the group. Match negative balances with positive balances, then record the actual payments separately.
Keep repayments separate from expenses
Thing is, a repayment is not a moving expense, and putting it back into the expense log makes the total look larger even though the group is only moving money from one person to another.
Create a second tab named Payments with these columns:
| Column | Header | Example |
|---|---|---|
| A | Date | 2026-01-20 |
| B | From | Ben |
| C | To | Alice |
| D | Amount | 75 |
| E | Note | Truck split |
Record cash, check, or payment-app transfers after they are sent. Do not add them to Total Cost.
To show the remaining position after repayments, add an optional column N named Remaining Net. In N2, use:
=M2+SUMIF(Payments!$B:$B,J2,Payments!$D:$D)-SUMIF(Payments!$C:$C,J2,Payments!$D:$D)
A positive result still represents money owed to that person. A negative result still represents money that person owes. Use the same spelling for names on both tabs.
Handle expenses that not everyone shares
One # Sharers cell works only when the same group shares each row. For optional costs, add one participation flag per person, using 1 for yes and 0 for no.
| Expense | Alice | Ben | Cara | Dev | # Sharers |
|---|---|---|---|---|---|
| Moving truck | 1 | 1 | 1 | 1 | =SUM(I2:L2) |
| Storage fee | 1 | 0 | 1 | 1 | =SUM(I3:L3) |
Put the flags in I:L. Then create a share column for each person. Alice's share in M2 can use:
=IF($E2>0,IF(I2=1,$D2/$E2,0),0)
Copy that formula across for the other people, changing the participation reference as it moves. Sum each person's share column for their fair-share total.
Use this participant layout instead of the simple =SUM($F:$F) summary. If the group agrees on unequal percentages or fixed amounts, record those amounts openly rather than labeling the split equal. Fairness is a rule, not a formula.
Share and protect the sheet
Share the file with specific people when it contains names, receipts, or balances. Use Editor for people entering expenses, Commenter for review, and Viewer for read-only access. Tiller's sharing and permissions guide provides a useful reference for these permission levels.
Protect the formula cells before sharing. Select the F column and summary cells, open Data > Protect sheets and ranges, and choose a warning or restricted editing option. A warning still lets someone continue, so test the setting before relying on it.
Keep receipt links in H. Use version history if a row changes unexpectedly. Avoid a broad edit link when the group only needs to review the numbers.
Check these mistakes before settling up
| Problem | Fix |
|---|---|
| The formula was overwritten with a number | Restore the formula in F and protect the formula range |
| # Sharers is blank or zero | Complete the row before counting its result; the IF formula returns zero for unfinished rows |
| A refund was split incorrectly | Use a negative amount only when the refund belongs to the row's participants |
| A refund went to one person only | Record the recipient clearly or use the Payments tab rather than splitting it across everyone |
| A repayment was added as a moving cost | Remove it from the expense log and record it on Payments |
| A category total is wrong | Use consistent labels such as Truck rental on every matching row |
| A person's balance looks wrong | Check the Paid By name, participant flags, and whether that person shares every row |
| A receipt is missing | Add a link or short note in H before final reimbursement |
Review the sheet before anyone sends the final payment. Small corrections are easier before the group settles up.
Google Sheets or Excel?
The basic formulas also work in Excel. Sharing and protection menus differ, so use Excel's own sharing controls rather than copying the Google Sheets menu path.
Before the truck arrives, enter the member names and two sample rows. Confirm the shares, agree on deposit and refund rules in Notes, protect the formulas, and add receipt links as expenses occur.