Tracking Expenses in Multiple Currencies Without Losing Your Mind

A week of travel can leave you with receipts in three currencies, a card statement that disagrees with all of them, and no memory of what the euro was worth on Tuesday. The fix is not more spreadsheets. It is deciding once how you convert, and capturing the original amount every single time.

Record the original amount first, always

The single most useful habit in multi-currency bookkeeping: never overwrite the foreign amount. A receipt for 48.20 EUR is a fact. Its value in your home currency is an estimate that depends on which rate you pick and when you pick it. If you only write down "about 52 dollars," you have destroyed the fact and kept the estimate, and you can never redo the conversion when your accountant asks for a different basis.

So every foreign expense should carry three things: the original currency, the original amount, and the transaction date. Everything else can be recalculated later. Scanning the receipt gets you all three for free, because the merchant already printed them. Expense Rabbit reads the merchant, date, total, tax, and line items straight off the photo, so the source amount is preserved even if you sort out the conversion weeks later.

Which exchange rate should you actually use?

There are three defensible answers, and the wrong move is mixing them within one set of books.

• The rate on the transaction date. The most accurate and the default expectation of most tax authorities for individual transactions. Use the daily rate published by a central bank or a consistent public source.
• An average rate for the period. Many tax agencies, including the IRS and CRA, publish or accept annual or monthly average rates for converting foreign amounts. This is a legitimate simplification if you apply it consistently and the amounts are not unusual in size.
• The rate your card actually charged. Arguably the most honest number, because it is what left your account. If you are reimbursing yourself or claiming an actual cost, the settled amount on your statement is hard to argue with.

Pick one basis, write it down somewhere your future self will find it, and stick to it for the whole tax year. Consistency matters more than which of the three you chose. Rules differ by country, so if the amounts are large, confirm the basis with your accountant before the year closes rather than after.

Do not forget the conversion fee

The gap between the mid-market rate you looked up and the number on your statement is not rounding error. It is a foreign transaction fee, a card network markup, or both, and it is frequently in the low single digit percentages. On a two week trip that quietly becomes real money.

Two practical options. If the fee is broken out as its own line on your statement, book it separately as a bank charge, which keeps your expense categories clean and makes the cost of that card visible. If it is baked silently into the converted amount, then using the settled statement figure as your basis already captures it, which is one more reason that basis is popular with people who travel often. What you should not do is claim the mid-market conversion and then also claim the fee, because you would be counting part of it twice.

Reconciling receipts against a statement

Foreign transactions post late and post differently. A dinner on the 3rd can settle on the 6th at a rate from somewhere in between, so matching by amount alone will fail. Match by merchant and approximate date instead, and treat the receipt as the record of what you bought and the statement as the record of what you paid.

Hotels and car rentals deserve extra attention because of pre-authorization holds, which appear, vanish, and reappear as a different final figure. Wait for the settled charge before reconciling those, and keep the folio, not the hold notification.

One more trap: dynamic currency conversion, the point of sale prompt asking whether you would like to be charged in your home currency. It looks helpful and it almost always uses a worse rate than your card would. Decline it, pay in local currency, and keep your conversion basis consistent.

A workflow that survives a real trip

Nothing here works if it depends on discipline you will not have at 11pm in an airport. Keep it to three steps.

1. Scan at the table. Photograph the receipt when it arrives, before it is folded into a pocket and before thermal paper fades. The original currency amount and date are captured permanently.
2. Confirm the category once. Auto-categorization with a confidence score means most receipts need a glance, not data entry. Fix the few that are genuinely ambiguous while you still remember the meal.
3. Convert in one sitting, after the trip. Apply your chosen basis to everything at once. One pass, one rate source, one set of assumptions, rather than a different guess per receipt.

Because Expense Rabbit syncs one account across iPhone and the web, you can capture on the phone while travelling and do the tidy-up pass on a real keyboard when you get home, then export a books-ready CSV with the original amounts intact. Your accountant gets clean data instead of a folder of blurry photos and a story about Tuesday.

← More guides