When your account is in euros but you spent in another currency, the statement shows the foreign figure and a euro figure, and importers tend to read the wrong one. The method is simple: pick the euro amount as the amount that counts, store the foreign amount and its three-letter code in their own columns, and make sure decimals are consistent before you load anything.
A weekend abroad as a worked example
Say a euro current account is used on a short trip to Switzerland. The statement shows three lines. A mountain railway ticket is CHF 64.00, billed as €66.56. A lunch is CHF 38.50, billed as €40.04. A souvenir shop is CHF 22.00, billed as €22.88. The foreign amounts are in the description text, the euro amounts in the amount column.
| Description | Original | Code | Euro amount |
|---|---|---|---|
| Mountain railway | 64.00 | CHF | -66.56 |
| Lunch | 38.50 | CHF | -40.04 |
| Souvenir shop | 22.00 | CHF | -22.88 |
Why does the importer get confused?
- The currency code appears inside the description, so the amount column and the description disagree.
- Some exports put the foreign amount in the amount column and the euro figure elsewhere, so the importer reads CHF 64.00 as €64.00.
- Decimal commas in one column and full stops in another produce nonsense totals.
- Pending lines show only the foreign amount until they post.
The cure is the same for all four: decide which column holds the euro amount, make it numeric, and keep everything else as information.
How do I decide which amount is the real one?
The one in your account's currency, the euro figure the bank actually debited. Take the three lines above: 66.56 + 40.04 + 22.88 = 129.48. That is what the weekend cost your account, whatever the exchange rate on any other day. If a tool asks you to enter a rate, use the one implied by the statement, not one you looked up later.
What does the implied rate tell me?
Divide the euro amount by the foreign amount: 66.56 divided by 64.00 gives 1.04, 40.04 divided by 38.50 gives 1.04, and 22.88 divided by 22.00 gives 1.04. Identical results across three lines show a consistent conversion. If one line came out as 1.40, you would suspect that a digit was swapped, since 22.88 might have been 32.88 or a different amount.
What should I do about a refund in another currency?
A refund of a foreign purchase is credited at the rate on the day it posts, so it may not equal the original euro charge even if the foreign amount is identical. Say the CHF 38.50 lunch is refunded and the credit shows €39.40. Record it as +39.40 with the same original amount and code, and add a note linking it to the lunch. The 0.64 difference is a real effect of the timing, and your records should keep it rather than force the two to cancel.
A column plan that keeps both numbers
- Date as YYYY-MM-DD.
- Description exactly as printed.
- Amount in euros, signed, numeric.
- Original amount, numeric, no symbols.
- Original currency, three capital letters.
- Note, for fees, refunds or the trip name.
To total the foreign spending by currency: =SUMIFS($D$2:$D$300, $C$2:$C$300, "CHF"), with codes in C and euro amounts in D.
SpendixAI stores each transaction's original currency alongside an amount in your base currency, and has a report for foreign-currency spending; the base is chosen before importing and cannot change once transactions exist. It is built around India and INR, so it is meant for readers who also track Indian accounts rather than euro ones. The column plan above works in any sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
