# Free trip expense splitter template

> Free group trip expense spreadsheet for Excel and Google Sheets: log who paid for the stay, food and tickets, split equally, and see who owes whom.

Canonical: https://www.traxpend.com/templates/trip-expense-splitter
Last updated: 2026-10-16

A group trip expense spreadsheet. Everyone pays for different things; the sheet adds it up, splits it equally (or however you agree) and shows who owes whom.

Download: https://www.traxpend.com/templates/traxpend-trip-expense-splitter.xlsx

## What is inside

### Expenses

Each trip cost with who paid it: stay, travel, food, activities.

### Balances

Equal shares by default, with each person’s total paid and their balance.

## Preview

| Person | Share | Paid | Fair share | Balance |
| --- | --- | --- | --- | --- |
| Meera | 25% | 42,200 | 14,700 | +27,500 |
| Dev | 25% | 4,200 | 14,700 | −10,500 |
| Sana | 25% | 4,900 | 14,700 | −9,800 |
| Kunal | 25% | 7,500 | 14,700 | −7,200 |

## Limits

- Foreign-currency costs need converting by hand before you add them.
- It shows balances, not the fewest transfers to settle them.
- Everyone has to send their costs to one person to type in.

## FAQ

### How do I settle up with the fewest payments?

Copy each person’s total paid into our free trip expense calculator. It works out the minimum number of transfers, so four friends rarely need more than three payments.

### Does it work in Google Sheets?

Download the file, open Google Sheets, choose File → Import → Upload, pick the file and select “Create new spreadsheet”. The formulas carry over.

### What if someone skipped an activity?

Either change their share on the Balances sheet for the whole trip, or keep that activity in a separate copy of the sheet with only the people who joined.

### Can it handle different currencies?

Convert each cost to one currency before adding it. Traxpend can do this automatically across 40+ currencies.

## Related

- [Trip expense calculator](https://www.traxpend.com/tools/trip-split)
- [Traxpend for group trips](https://www.traxpend.com/for/trips)
- [All templates](https://www.traxpend.com/templates)