§ Blog · How-to

How to track expenses in multiple currencies without a spreadsheet

Juggling baht, rupiah and dong in the same week wrecks most budgets — not because of exchange rates, but because of scale and mental math. Here's a method that keeps the books honest.

Everyone assumes the hard part of multi-currency spending is the exchange rate. It isn't. The rate is a number you can look up in two seconds. The hard part is scale — the way a Thai coffee reads as "45", an Indonesian lunch as "85,000", and a Vietnamese taxi as "120,000", all in the same afternoon. Three different orders of magnitude, three different currencies, and a tired brain trying to convert each one on the fly. That mental arithmetic is where budgets quietly come apart: every silent conversion introduces a little drift, and a week of drift is the difference between "on track" and "where did it all go." The fix is not to convert harder. It's to stop converting in your head at all.

What follows is a method, not an app pitch — five steps you could run with pen and paper if you were patient enough. The order matters, because each step removes a chance to introduce error. Get them right and the books stay honest across as many borders as you care to cross.

1. Record in the currency you actually paid

This is the whole foundation, so it goes first. When you hand over forty-five baht for a coffee, you write down 45 baht — not its value in dollars, not a rounded guess, not "about a dollar thirty." The number you log is the number on the receipt or the cash in your hand. Converting at the point of payment feels efficient, but it bakes a guess into your permanent record, and you can never recover the true figure afterward. Capture reality first; interpret it later.

2. Keep one running balance per currency

Resist the urge to collapse everything into a single total too early. Hold THB, IDR, VND, PHP, MYR and USD side by side, each with its own running balance. This sounds like more work — it is actually less, because no conversion happens until you decide it should. It also means each balance is exact: your baht total is genuinely your baht spending, untouched by a rate that might shift tomorrow. When you cross a border, you simply start feeding a different column, and the column you left behind stays frozen at its true value, ready to be picked up again on the way home. A mashed-together "total spent" number, by contrast, can never be un-mashed — once you've folded rupiah and ringgit into a single figure at some half-remembered rate, the underlying truth is gone. Our guide to Southeast Asian currencies covers the quirks of each one.

3. Convert only when you need a single total

There are moments you genuinely need one number — a weekly budget check, a monthly review, a tax return. That is the time to convert, and only then. Take each currency balance, apply the daily mid-market rate, and sum the results. Because you converted once, against a real rate, on data you never corrupted with mental math, the total is defensible. Compare that to the alternative, where you've been guessing rates all week and the error compounds invisibly. One clean conversion beats fifty rough ones.

4. Write amounts as the local shorthand says them

Languages already solved the zeros problem for you. Locals don't say "eighty-two thousand dong," they say "82k dong"; a market price in Jakarta is "35k IDR," not thirty-five thousand spelled out. Lean into that. Logging amounts the way they're actually spoken is faster, harder to mistype, and far less error-prone than counting zeros on a phone screen. Let the tool expand the shorthand into the full figure — that's its job, not yours.

5. Categorize and export

A ledger that can't be reviewed is just a list. Tag each entry with one of a small handful of categories — food, transport, lodging, fun, fees — and resist building an elaborate taxonomy you'll never maintain. A handful is enough to see where the money goes. When you need the data elsewhere — a tax filing, an accountant, a spreadsheet review at the end of the trip — export to CSV. The point is that the categorizing happens once, lightly, as you go, so the export is ready the moment you want it.

Why the spreadsheet loses

None of this is an argument against spreadsheets. A spreadsheet is excellent for the monthly review: it sorts, it sums, it charts, and the data is unambiguously yours. The trouble is the moment of capture. Standing at a noodle cart with change in one hand and a phone in the other, you are not going to open a sheet, find the right row, switch the keyboard to numbers, pinch to zoom because the cells are two millimetres wide, and type "120,000" into exactly the right column. So you tell yourself you'll do it later — and later, you've forgotten the taxi entirely, or you remember it as "about a hundred thousand," which is the drift creeping back in. The spreadsheet doesn't fail at math; it fails at the doorway, where the entry never gets made. Capture is the whole game, and a grid of cells is the wrong shape for a thumb in a hurry. For the on-the-spot habit, see our notes on tracking cash spending abroad.

The fast way to do all this

Everything above is a workflow, and ExpenseAI is that workflow with the friction removed. You type a sentence — "coffee 45 baht" or "grab 82k dong" — and it does the rest: detects the currency, expands the shorthand, files the amount under the right running balance, and assigns a category. When you want a single total, it converts on request at the daily mid-market rate. There's a free tier, and it never asks to connect your bank, because the cash at the food stall was never in a bank feed to begin with. If you're weighing it against other tools, our how it compares to other apps page lays out the differences plainly.

Questions

How do I track expenses in more than one currency?+
Record every payment in the currency you actually handed over, and keep a separate running balance for each currency rather than mashing them into one number. Convert to a single home-currency total only when you need the big picture — for a budget check or a tax return — using the daily mid-market rate. The mistake most people make is converting in their heads at the point of payment, which quietly drifts the books off by a few percent every day.
Should I convert foreign expenses to my home currency right away?+
No. Converting at the moment of payment forces a guess about the rate, and those guesses compound into real error over a trip. Log the amount as you paid it — 45 baht stays 45 baht — and let the conversion happen later, all at once, against a real rate. Your per-currency balances stay exact, and the single total you build from them is honest rather than approximate.
What exchange rate should I use for travel expenses?+
Use the daily mid-market rate — the midpoint between the buy and sell prices that banks quote each other. It is the closest thing to a fair, neutral number, and it is what most accountants and tax authorities will accept. Avoid eyeballing the airport board or the rate your card charged on one transaction; apply one consistent daily rate across the whole currency so the math is defensible later.
[ Join the waitlist ] Track cash in any currency by typing a sentence. iOS & Android, free tier, no card.