Use one shared Excel workbook to record each moving cost, show who paid, apply an agreed split, and track repayments separately. It suits a short move with a manageable number of entries. Excel keeps the record; it does not send money or confirm that a roommate has reimbursed anyone.

Thing is, the cleanest setup is not a fancy dashboard. Create an Expenses sheet for original charges, a Payments sheet for money sent later, and a small Summary or Rules sheet for names and decisions. That separation makes the final settle-up much easier to explain.

Choose a workbook structure that stays readable

Two or three simple sheets are enough for most roommate moves.

Sheet Purpose Suggested fields
Expenses Original moving charges only Date, description, category, total amount, paid by, split method, member shares, receipt link, notes
Payments Reimbursements made after an expense Date, sent by, paid to, amount, method, related expense, status
Summary and Rules People, agreed decisions, and running totals Participant names, split notes, total paid, assigned share, balance

Keep the original expense row unchanged after someone pays back part of it. Record that later transfer in Payments instead.

Add columns that answer reimbursement questions

Your Expenses sheet should make each charge understandable without searching through old group messages.

Column What to enter Example
Date Date the cost occurred 2026-03-15
Description Plain-language detail Moving truck rental
Category A short, consistent label Truck rental
Total Amount Full charge before splitting $250
Paid By Person who paid upfront Alex
Split Method The rule used for this row Equal among four
Member share columns Each person's assigned portion Alex Share, Jamie Share
Receipt Link Link to a stored receipt image or file Shared folder link
Reimbursement Status Current state of the charge Unpaid, partial, or paid
Notes Exceptions or agreements Deposit refund divided by original shares

Use one share column per roommate if splits may vary. A single Amount Owed Per Person column works only for straightforward equal splits.

Useful categories include truck rental, security or utility deposit, packing supplies, cleaning, storage, and miscellaneous costs. Keep the list short. People are more likely to use five clear categories than fifteen nearly identical ones.

Add dropdowns for Category, Paid By, Split Method, and Reimbursement Status. Microsoft's data validation guidance explains how to limit entries to a predefined list and show an alert when someone enters an invalid value.

Agree on the split rule before the move

Write the rule in the workbook before anyone pays. A method buried in a text thread tends to become a debate later.

Split method Works well for Tradeoff
Equal split Shared truck rental or common packing supplies Simple, but it assumes similar use
Participant-only split A cost used by only some roommates Fairer for limited use, but participants must be recorded
Usage-based split Truck space, mileage, boxes, or supplies More precise, though it needs better notes
Room-size split Room-specific supplies or an agreed deposit allocation Requires a clear measurement or agreement
Income-based split A broader contribution arrangement Sensitive and should never be assumed
Nights-stayed split Temporary lodging or short stays Less useful for most one-time moving charges

For example, a $150 truck rental split equally among four people gives each person a $37.50 share. A storage cost used by only three roommates should not automatically be divided among everyone.

One row can be equal, the next usage-based, and a deposit can have its own refund rule; that is fine, but the method needs to travel with the row because people forget the conversation long before they forget the charge.

If a deposit may be returned, write down who receives the refund and how it will be divided. A lease, landlord instruction, or other binding document may control the result, so the spreadsheet should record your group's plan rather than replace those documents.

Build the Excel template in a few passes

  1. Open a blank workbook in Excel. You can also browse the Microsoft Excel template gallery and remove sections you will not use.

  2. Create the Expenses, Payments, and Summary or Rules sheets. Add the headers from the tables above to row 1 of Expenses.

  3. Turn the Expenses range into an Excel Table. Freeze the top row, enable filters, and format Total Amount and share columns as currency.

  4. List every participant on the Rules sheet. Write the default split, exceptions for partial use, receipt expectations, and the review schedule.

  5. Add dropdowns for repeated entries. Use a separate list of roommate names so Paid By stays consistent.

  6. Test the workbook with three to five real or sample costs. Include a $150 truck rental paid by one person and split equally among four people.

  7. Save the file in a shared cloud location before inviting others. Review the totals together, then start entering actual costs as they occur.

Review the sheet weekly while the move is active. Record reimbursements as they happen, not from memory at the end.

Add formulas without hiding the math

Name the Excel Table Expenses. Suppose Total Amount is in column D and three member share columns run from G through I.

For an equal split among three participants, use:

=D2/3

For a 60 percent share, use:

=D2*60%

To check whether the member shares equal the original charge, use:

=SUM(G2:I2)-D2

A result of zero means the shares match the total. If rounding leaves a one-cent difference, assign that cent according to the written group rule and note it.

On the Summary sheet, use columns named Person, Paid, Share, Payments Sent, Payments Received, and Balance. If Alex is listed in row 2, Alex's total paid can be calculated with:

=SUMIF(Expenses[Paid By],"Alex",Expenses[Total Amount])

Alex's assigned share can use:

=SUM(Expenses[Alex Share])

With Paid in B2, Share in C2, Payments Sent in D2, and Payments Received in E2, use this balance formula in F2:

=B2-C2+D2-E2

A positive balance means the group owes that person. A negative balance means that person still owes the group. Change the person name and share-column reference for each roommate.

Do not enter a reimbursement as a negative moving expense. The truck rental, deposit, or supply purchase should remain visible, while the later transfer belongs in Payments.

Share the file without losing control

Cloud sharing helps when several roommates need to add costs from different devices. If your Excel version supports coauthoring, save the workbook to OneDrive or SharePoint and use Excel's Share option. Microsoft's coauthoring guidance lists account, file-location, and version requirements.

Give edit access to people who will enter expenses. Give view access to anyone who only needs to check the totals. Keep formulas and summary cells clearly marked so nobody replaces a calculation with a typed number.

Use one shared file instead of several emailed copies. Before adding receipt links, check that the linked folder has the same intended audience. Never store banking passwords, full account numbers, or unrelated personal records in the workbook.

Common mistakes and the simple fix

Turns out, most spreadsheet disputes start with an unclear process, not a difficult formula.

Problem Better practice
A repayment is entered as a negative expense Keep the charge in Expenses and log the transfer in Payments
The split rule exists only in a group chat Repeat it in Split Method and on the Rules sheet
Different names appear for the same person Use a Paid By dropdown
A receipt is missing Add a receipt link or explain the missing proof in Notes
Someone overwrites a formula Mark formula columns and limit edit access where practical
A returned deposit was never discussed Record the refund recipient and allocation rule before move-in
Several file copies circulate Choose one shared workbook as the record

The workbook should show what happened, not force people to reconstruct it later.

When Excel is enough

Excel is a reasonable fit for a one-time move with a short list, such as fewer than 20 expense rows, when the group can review the file by text or in person.

It becomes less comfortable when costs keep arriving, each person has many exceptions, or the group wants receipt capture, automatic reminders, or payment requests built into the same workflow. At that point, consider a tool that explicitly supports the missing function, and confirm how your group can retain a readable record.

To be honest, using phones is not the deciding issue by itself. A shared cloud workbook may work well for a few people, but test the file before the move if several members will edit it at once.

The spreadsheet still does not send cash, approve a reimbursement, or replace lease, employer, or tax records. For a U.S. deposit dispute or employer moving reimbursement, keep the relevant documents and check the applicable policy or professional guidance.

FAQ

Should a repayment change the original moving expense?

No. Leave the original charge intact and record the repayment separately. This preserves the receipt, original payer, assigned shares, and remaining balance.

What if one roommate uses only part of an expense?

Choose participant-only, usage-based, or another agreed method. Enter the exact share for each person and use the share-check formula before marking the expense complete.

Can I import bank transactions into the tracker?

If your bank offers a downloadable CSV file, you can open it in Excel and copy only the relevant moving transactions. Bank formats vary, so check each copied row against the receipt and do not include login details or unrelated account information.

Is the workbook enough for tax records or a deposit dispute?

It can document your group's expenses and reimbursement history, but it is not tax or legal advice. Keep leases, receipts, employer policies, and other formal records separately when they apply.

Before the next moving purchase, create the workbook, add participant names, write the split rule, and run the $150 test row. If the Summary balance makes sense, share the file and start logging actual costs.