Trip expense splitter
A group trip expense sheet that records who paid for what and works out who owes whom.
- ๐บ๐ธ US format ยท Letter size
- Free
Pick your options and the preview updates. The file opens in Excel, Google Sheets or Numbers.
The file is built in your browser. Nothing is uploaded or saved.
Sheets
- How to use
- Settlement: names, paid, share, balance (+ is owed, - owes) and who pays whom (formulas)
- Expenses: date, item, amount, paid by (dropdown), Yes/No per person (who splits it), per-person share
Color key
- Yellow cells: fill these in
- Blue cells: formulas, leave them as they are
- Gray rows: examples you can delete
1 / 2
Trip expenses, who owes what
| Name | Paid | Share | Balance (+ is owed, - owes) | Settle up |
|---|---|---|---|---|
| Person 1 | 360.00 | 130.00 | 230.00 | Gets 230.00 from Person 1 |
| Person 2 | 120.00 | 130.00 | -10.00 | Pays 10.00 to Person 1 |
| Person 3 | 0.00 | 130.00 | -130.00 | Pays 130.00 to Person 1 |
| Person 4 | 0.00 | 90.00 | -90.00 | Pays 90.00 to Person 1 |
| Total | =SUM(โฆ) | =SUM(โฆ) | =SUM(โฆ) |
Expenses
| Date | Item | Amount | Paid by | Person 1 | Person 2 | Person 3 | Person 4 | Per person |
|---|---|---|---|---|---|---|---|---|
| 2026-11-21 | Hotel, 2 nights | 360 | Person 1 | Yes | Yes | Yes | Yes | 90 |
| 2026-11-21 | Dinner | 120 | Person 2 | Yes | Yes | Yes | No | 40 |
| (auto) | ||||||||
| Total | =SUM(โฆ) |
This shows the first part of each sheet as it prints on Letter paper. The file also has a how-to sheet and formulas, and every column fits one page width when you print from Excel.
How to use it
Pick how many people are on the trip. You get a Settlement sheet and an Expenses sheet. Type the names on the Settlement sheet, then log each expense on the Expenses sheet with who paid. Paid, share, balance and who pays whom are all formulas.
Everything splits evenly by default. For an expense that only some people share, such as drinks or a tour, switch the people who sat it out to No and that line splits among the Yes people only.
Things to watch
Rounding to cents can leave the totals a few cents off. The settle-up plan routes every payment through one person, the collector, which keeps the number of transfers small; if you prefer paying each other directly, use the Balance column and sort it out from there.
Calculators that go with this
Frequently asked questions
One person paid for several things.
One line per payment. Paid on the Settlement sheet adds up every line with that name in Paid by.
What about an expense some people did not share?
Switch those people to No on that line. The per-person amount is recalculated from the people marked Yes.
We have more than 10 people.
The file goes up to 10. Split the group into two files, or copy a person column on the Expenses sheet and extend the formula ranges by hand.
Is what I type saved anywhere?
No. Everything stays in your browser and nothing is sent to our server. If you refresh the page it is gone, so print, save a PDF or download the DOCX when you are done.