Travel and trips · TT-10

Group Trip Cost Split Sheet

A free printable group trip cost split — who paid for what, how it was shared, what each person's total comes to and the settle-up at the end.

Download Free · no sign-up

2 pages. Choose your paper size — both versions are laid out identically, so neither one gets shrunk to fit.

Print it and write on it

A4 57 kB US Letter 57 kB

Fill it in type and save

A4 172 kB US Letter 172 kB

The fillable versions have real form fields — open them in any PDF reader, type into them and save. Printing help.

What this sheet is for

Settle a shared trip once, in front of everybody, from a list that was written down at the time rather than reconstructed from four different memories.

Who it is for

Groups of friends sharing a holiday, families travelling together, stag and hen trips, walking and cycling groups, and anyone who ends up being the one who pays.

How to use it

Agree at the start who writes on the sheet and keep it somewhere everyone can reach it.
Log every payment as it happens, with who paid and who it was shared between.
Keep receipts with the sheet — a disputed line is nearly always a missing receipt.
Work out the settle-up together at the end, and tick each person off as they pay.
Photograph the finished sheet before anyone goes home.

What is on the sheet

2 pages, in this order:

Page 1

Printed under the title: Who paid for what on a trip shared between several people, what each person's share comes to, and the settle-up at the end.

Your figures, in one place. Nothing is worked out for you here. Every figure in every column is one you write yourself, in your own currency, from your own receipts — the sheet's job is to keep them all in one place so the arithmetic at the end is done once, in front of everybody, rather than four times in four heads.

Write-on lines: Trip · Dates · Currency · In the group

What was paid — one row per payment, whoever made it

Table, 12 rows: Date · What it was for · Who paid · Amount · Shared by · Each · Notes

Page 2

Settle up — fill this in once, together, at the end

Table, 8 rows: Person · Paid out in total · Share of the total · Owes · Is owed · Settled · How

Ruled lines: Notes — what was agreed, who is still to pay, what is left over

Questions

Does the sheet work the split out for me?

No. Every figure on it is one you write yourself, from your own receipts and in your own currency. The sheet's job is to have all of them in one place so the arithmetic is done once, in front of everybody, instead of four times in private.

What if people joined for only part of the trip?

Use the shared by column for names rather than a number, so a payment shared between three of the five is recorded as exactly that. The settle-up table then adds up per person rather than dividing everything equally.