Group trip money

How to Track Prepaid Group Trip Costs: Who Paid for the Flights and the Hotel?

Everyone remembers who paid for dinner on day three. What nobody remembers is who paid for the flights two months before you left. This guide covers the minimum you need to record for each prepaid cost, which exchange rate to trust, how to fold prepaid costs into the same tab as trip spending, and the three situations that usually derail settling up.

閱讀繁體中文版

Splitting & expensesPublished October 14, 2026Updated October 14, 20268 min read

prepaid expenses
split bills
group travel
trip budget

Four friends plan a trip to Japan at the end of the year. Two months out, Sam spots a fare sale and books four return flights on his card. A week later, Mia books a five-night apartment through a booking site with hers. A few days before departure, someone else buys theme park tickets and airport train passes. At this point everyone has a number in their head, but nobody has written them down in one place.

Then comes the trip itself: dinners paid in turn, someone covering a round of drinks, taxis split four ways. Back home, the group chat lights up with the same questions: how much were the flights in the end? Was the apartment charged in yen or in our currency? Who actually bought the park tickets? Scrolling back two months of messages does not answer them, so the group settles on a rough guess, and nobody is quite sure who came out ahead.

Nobody was careless. Prepaid costs simply behave differently from spending on the road, and the fix is to record them separately, then settle them together.

Why prepaid costs need their own list#

Prepaid costs are anything paid before you leave: flights, accommodation, rail passes, attraction tickets, insurance. They differ from on-trip spending in at least four ways, which is exactly why they get lost or double counted when everything goes into one pile.

Different timing: they can be paid weeks or months ahead. By the time anyone starts tracking expenses on the trip, the flights are long forgotten.
Different currencies: flights may be priced in your home currency, a foreign apartment in local currency or US dollars, and daily spending in yet another currency.
Mostly card payments: the final amount is only certain once the statement arrives, and it can include foreign transaction fees, instalments or later refunds.
Large amounts: one flight can cost as much as several days of meals. Missing a coffee does not matter; missing a hotel booking does.

Three common approaches and where they break#

1. Mention it in the group chat

The easiest option: "I booked the flights, it's 275 each" and you are done.
Messages get buried. Two months later nobody can find the right one, and if the price changed or part of it was refunded, it is unclear which message has the final figure.

2. A shared spreadsheet

Someone has to maintain it: who updates it, which day's exchange rate goes in, which rows have already been paid back. It gets messy fast.
Editing a spreadsheet on a phone abroad is awkward, so on-trip spending often never makes it in, and the prepaid and trip numbers no longer line up.

3. One person tracks everything

That person carries the load, may not even know what others paid for, and often skips writing down their own payments because "I know what I paid".
Everyone else sees a single total with no breakdown, which invites the inevitable "how did you get that number?"

All three fail the same way: the "who paid" field is missing, or it is not kept anywhere reliable. Keep that field and any tool will do the job.

The minimum fields for each prepaid cost#

You do not need an elaborate template. Record these five things for every prepaid cost and you will be able to settle up later:

Item: specific enough that anyone understands it, such as "Return flights, 4 people" or "Osaka apartment, 5 nights", not just "flights".
Amount and currency: in the currency you were charged in. Do not convert it yourself yet; conversion happens at settlement.
Payer: whose card or account the money came from. This is the field most often skipped, and the one that matters most.
Shared or personal: your own travel insurance or seat upgrade is yours alone; the apartment is shared.
Who shares it, and how: everyone equally, only some people, or different amounts for different room types or seat classes.

Exchange rates: go by the statement and note the original#

Foreign currency prepaids cause the most arguments. The booking site said ¥60,000, the rate on the day suggested one figure, and the card statement shows another. That is normal: card issuers usually convert at the rate on the day the charge is processed, and many add a foreign transaction fee.

Use the amount actually charged on the statement: that is what the payer really paid, so it is the fairest basis and the hardest to dispute.
Write the original foreign amount in the note: for example "Statement 412.80, original ¥60,000". You will need it when checking the booking or handling a refund.
Before the statement arrives, use the day's rate as a placeholder: mark it "to confirm against statement" and update it later.
Agree on one rule as a group: which rate is more accurate matters less than everyone agreeing on the same basis upfront.

For a quick estimate of what a foreign amount is worth, the currency converter shows today's rate. For settlement, the payer's statement still wins.

Connecting it to the trip: prepaids are just day-zero expenses#

Recording prepaid costs separately does not mean settling them separately. The simplest mental model: a prepaid cost is an expense someone covered before day one. Put it on the same tab as on-trip spending and settle everything together: for every expense, each person who shares it owes the payer their own share.

Say four friends from Taipei travel together, with amounts in TWD. Sam paid 34,000 for four flights, Mia paid 13,240 for the hotel, Jay covered 6,000 of shared dinners during the trip, and Lee has not paid for anything yet. Look at it from each payer's side and it is clear who owes whom; debts running both ways between the same two people are then offset into one transfer. The two tables below mirror the app's settlement card: the first is the breakdown you see when you expand a row, the second is the who-owes-whom rows after offsetting:

What each person owes each payer

Scroll the table horizontally

	Owes Sam (flights 34,000)	Owes Mia (hotel 13,240)	Owes Jay (dinners 6,000)
Mia	8,500	—	1,500
Jay	8,500	3,310	—
Lee	8,500	3,310	1,500
Sam	—	3,310	1,500

Each cell is that expense ÷ 4 people. This is what the app's settlement card shows when you expand a row's breakdown. Nobody repays themselves, hence the dashes.

Actual transfers after offsetting

Scroll the table horizontally

	To Sam	To Mia	To Jay
Mia	5,190	—	—
Jay	7,000	1,810	—
Lee	8,500	3,310	1,500

Each pair offsets first: for example Mia owes Sam 8,500 and Sam owes Mia 3,310, so Mia only sends 5,190. Totals per person: Sam +20,690, Mia −70, Jay −7,310, Lee −13,310.

You could instead boil everyone down to a single net balance (the four totals in the note above) and settle in three transfers, with the same totals for each person. But those three transfers reshuffle the debts: Lee pays Sam 13,310, of which 3,310 is really hotel money and 1,500 is dinner money, and Mia and Jay never see who repaid what they covered. The six-transfer version takes a few more payments, and in return every one of them traces back to specific expenses.

If some of you share a wallet (a couple or a family), use "Group settlement" on the split-bill page to put them in one group: nothing is tracked inside the group, and they pay and receive as one, which cuts the number of transfers further. For a grouped example and the full settle-up process, see how to settle up after a group trip.

Three situations that derail settling up#

Someone drops out#

Flights and accommodation are often not fully refundable. Whether the person who dropped out should cover cancellation fees or their share of a non-refundable room has no universal answer, but agree on it at the time and write it in the note. If they are covering it, keep them on that prepaid's split; if not, remove them and let the rest share it. Leaving the conversation until after the trip is how friendships get strained.

Someone joins for only part of the trip#

One person arrives two days late, another only stays three nights, a third skips the theme park. Equal splits stop working, so set the participants for each prepaid individually or use custom amounts. If one person stays three of five nights, set their share in proportion to the nights; park tickets are split only among those who went.

Refunds arrive late, and for a different amount#

A cancelled night or a rebooked flight can take a while to refund, and the amount may differ from the original because of exchange rates or fees. Use the amount actually credited back to the payer, reduce the original prepaid to what was actually paid after the refund, and note the refund date and amount. If the refund has not arrived yet, mark it as pending and hold off on marking that item settled.

Tracking prepaid costs in TripBoard#

TripBoard keeps prepaid costs, on-trip expenses and bill splitting in the same trip, with a place for each of the minimum fields above. It runs in the browser with no sign-up.

Prepaid costs have a payer field: flights a friend booked or an apartment someone else paid for can be recorded as theirs. If you leave it unset, it counts as paid by you.
Split them with trip mates directly: turn on "Split with trip mates" on a prepaid cost, choose an equal split or custom amounts, and a linked split record is created that is settled alongside on-trip expenses.
A nudge when a friend paid and nothing is split yet: if the payer is someone else and the cost has not been split, the card says so, so a large booking does not slip through.
Settlement shows where the money came from: it lists what each payer covered and what each person owes them, offsets what each pair owes each other, and leaves only the transfers that actually need to happen.
Excel export includes the payer: every expense's payer is written to the spreadsheet, handy for friends who do not use TripBoard (Excel export is a Pro feature).
Merged backups keep payers: restoring a backup in merge mode keeps split links and payers intact.
A settle-up reminder the day after the trip: with trip reminders on, if this device still has unsettled expenses, you get a push reminder the day after the trip ends.

For foreign currency prepaids, TripBoard converts the amount into the trip's display currency. If you would rather go by your statement, record the prepaid in your home currency and put the original foreign amount in the note. To compare other tools, see the best split-bill apps with no sign-up; for the rest of your preparation, the pre-trip checklist covers it.

FAQ#

One person paid for everyone's flights. How do we split it?

Record the total, the currency and the payer (whoever's card was charged), then choose who shares it. Split equally if everyone paid the same fare, or use custom amounts for different seat classes. At the end of the trip, settle it together with on-trip expenses: each person owes the cardholder their share, and if the cardholder also owes someone, the two directions are offset into one transfer.

Which exchange rate should we use for prepaid foreign costs?

Use the amount actually charged on the payer's card statement. It reflects what they really paid, usually including the bank's rate and any foreign transaction fee. Until the statement arrives, use the day's rate as a placeholder and note the original foreign amount, then update it.

What happens to the deposit if someone drops out?

First find out how much can be refunded, then agree as a group who covers the rest and write it in the note on that prepaid cost. If the person who dropped out is covering it, keep them in the split; if not, remove them and let the others share it.

Is there an app that tracks both prepaid costs and trip expenses?

TripBoard records prepaid costs with a payer, on-trip expenses and shared bills in the same trip and settles them together, and flags prepaid costs a friend paid that have not been split yet. It runs in the browser with no sign-up. Create a trip to try it.

Record it when you pay, not when you get home

No sign-up, no download. Create a trip, add the flights and accommodation as prepaid costs with the right payer, and track on-trip spending in the same place so you settle once.

Start planning your trip