Splitting expenses in different currencies after a trip abroad

The short version

Fix the exchange rate once per expense, on the day it happened, and never touch it again. Then split the converted amounts like any other shared cost.

The alternative, converting the whole trip at one rate when you get home, looks simpler and has a defect that only shows up later: the amount everybody owes moves with the market until the moment somebody pays. A total that was right on Sunday is a different total on Thursday, and nobody knows which version they agreed to.

The question is when, not which

Every page that answers “what exchange rate should I use” answers the wrong question. There is no correct rate. There is the rate on the day you spent the money, the rate today, the rate your card used, and the rate your friend’s card used, and all four are real numbers that differ. What actually decides whether the split holds up is the moment you freeze one.

Lock it per expense

Convert each expense as you record it, at that day’s rate, and store the converted amount. The trip total is then a fact about the past: it cannot change, because none of its inputs can. Somebody settling up three weeks late pays exactly what they owed on the last night.

Or convert at the end

Keep everything in the local currency and convert the total when you get home. This is what most spreadsheets do, and it is not wrong so much as unstable. The split is now a function of the market, so it has a different answer every day, and the person who settles last settles at a different price than the person who settled first.

The same trip, priced two ways

Ana, Ben and Cara spend a week away and share everything. Ana books the apartment early, when the euro costs 1.08 dollars. Ben hires the car mid-week at 1.10. By the last two days the rate is 1.12, which is also where it sits when they get home.

Everyone shared everything, so each of the three owes a third. Locked, that is $546.40 each. Converted today it is $560.00 each. The gap is $13.60 a head, on a trip where the rate moved less than four percent.

It changes the payments too. Ana fronted the apartment and the dinner, so she is owed money either way, but not the same money:

• Locked: Cara pays Ana $378.40, Ben pays Ana $282.40
• Converted today: Cara pays Ana $392.00, Ben pays Ana $291.20

Nobody is cheating anybody. Both sets of numbers are internally consistent and both add up. That is exactly the problem: two honest people can produce two different answers from the same receipts, and without a stated rule there is no way to tell which one is the agreement.

Why neither total matches your bank statement

This is the question people actually arrive with, and the answer is that your card did not use the market rate. Issuers apply their own rate and frequently a foreign-transaction fee on top. At a 1.5% fee, the same €1,500 lands as $1,705.20 against $1,680.00 at the market rate: $25.20 that never appears in anyone’s split.

Do not try to reconcile the group split to a statement. They are answers to different questions. The split says what the trip cost the group; the statement says what one bank charged one person for handling it. If you want the fee shared, add it as its own expense and say so. If not, it is the cost of using that card, and the person who chose the card carries it.

Compare both policies on your own trip

Put in what you spent and the rate on each day, then set the rate you would convert at today. The table shows what each person owes under both policies and the settle-up list each one produces.

Four rules worth agreeing before you go

One base currency, chosen on day one

Pick the currency the group will actually settle in, which is nearly always the one most of you hold. Every expense converts into it. Two people paying each other in a currency neither keeps costs the group two more conversions for no benefit.

Rates get fixed when the expense is recorded

Not at the end, not when someone gets round to it. This is the rule that makes the total a fact rather than a forecast, and it is the one Halvy enforces: every expense stores the rate it was entered with, and that stored rate is what the balances are built from for as long as the group exists.

Record in the currency you paid in

Enter €240, not your guess at what €240 was in dollars. The conversion is arithmetic and the original amount is evidence; keeping the evidence means a wrong rate can be corrected later without anybody trying to remember what a car hire cost.

Settle once, in one currency

Net everybody off and make the smallest set of payments, rather than reimbursing expense by expense across two currencies. The fewest payments that settle everyone up is that method, and it matters more here than at home, because every extra transfer between currencies is another spread somebody pays.

If the trip also had people arriving and leaving on different days, the accommodation is a per-night cost before it is a currency question: splitting a trip when people come for different parts covers that half, and how to split shared costs fairly is the overview of picking a method in the first place.

Common questions

Every figure here was produced by running Halvy’s own split engine on the worked example, and both policies reconcile to their own totals to the cent. The rates are illustrative rather than historical: the argument is about when a rate is fixed, not about any particular week’s market. Card fees vary by issuer, so the 1.5% used above is an example rather than a quote.