How to track expenses in multiple currencies

A trip through four countries produces four sets of prices in four currencies, and one question you cannot answer at the end: what did it actually cost? Doing the conversion afterwards is where most travel records fall apart, because by then you have lost the rates, the dates and half the receipts.

Convert as you go, and keep both numbers

The single habit that fixes this is recording both the local amount and its converted value at the moment you spend. Keep the local price and you can still compare what a coffee costs in Lisbon against Hanoi. Keep the converted value and your running total is meaningful today rather than after a reconciliation session in January.

Converting at the end also gets the rate wrong. Rates move, sometimes several percent across a two week trip, and applying one closing rate to everything smears that across the whole record. On a long trip in a volatile currency this is a genuinely large error.

It also breaks your daily budget while you are travelling, which is the part that actually changes behaviour. A budget you can only evaluate after the trip is a receipt, not a budget.

Which rate to record

For personal budgeting, use the mid-market rate for the date of the expense. That is the rate you will see quoted publicly, and the European Central Bank publishes reference rates daily that anyone can check. It is not exactly what your bank charged, but it is close, it is defensible, and it is consistent across every expense.

For an expense claim, ask what the person paying wants. Many organisations specify a published mid-market rate for the transaction date. Some want the rate on the statement. Some accept either as long as you are consistent and can show your working, which is a good argument for recording the rate and the rate date on each expense rather than only the converted total.

Whatever you choose, be consistent. Mixing methods within one trip produces a total nobody can reconstruct, including you.

Cards, fees and the real cost

Your bank will not give you the mid-market rate. It gives you the mid-market rate plus a margin, typically somewhere between half a percent and three percent, and possibly a fixed foreign transaction fee on top. So the number on your statement will be a little higher than the mid-market conversion of the local price.

You have two honest ways to handle this:

• Accept the gap. Log local prices at mid-market rates and treat your total as accurate to within a couple of percent. For most personal budgets this is fine, and it is far faster.
• Match the statement. Log the amount your card was charged and set the rate manually so the converted figure is exact. Slower, but right if you are claiming the money back.

On a long trip, there is a third thing worth doing regardless: log the fees themselves as their own category. Two percent on six weeks of spending is a real number, and seeing it written down is how people work out that a different card would have paid for itself.

Cash and ATM withdrawals

A cash withdrawal is not an expense. It is a transfer between two forms of your own money, and logging the withdrawal as spending double counts everything you then buy with it.

The clean approach:

1. Do not log the withdrawal itself as an expense.
2. Log any ATM or withdrawal fee as an expense under fees, because that is real money gone.
3. Log each purchase you make with that cash at its local price, as normal.

This keeps cash and card spending directly comparable, which matters in countries where you use both heavily.

The airport currency trap

When a card terminal or an ATM offers to charge you in your home currency instead of the local one, decline it. This is dynamic currency conversion, and the exchange rate it uses is set by the terminal operator rather than your bank. It is reliably worse, often by three to six percent, and it is presented as a convenience.

Always choose the local currency and let your own bank do the conversion. This one habit saves more money over a trip than most budgeting decisions.

Trips through several countries

Once a trip crosses borders, a single total stops being useful. What you want to know is what each country cost, and specifically what each country cost per day, because that is the only comparison that survives spending four days in one place and eleven in another.

That means every expense needs to carry the country it happened in, not just the currency. They are not the same thing: you can pay in euros in several countries, in US dollars in places that do not use them, and in the previous country's leftover cash for the first day after a border.

It also means being able to pass through a country twice without breaking the record. A tracker that assumes one country per trip, or that ties the currency to the country, will fight you on a route like Thailand to Laos to Thailand. Tasca keeps country and currency independent for exactly this reason, and gives each country its own total, cost per day and share of the trip.

Questions