“My multi-currency statement imports with the wrong amounts”
Multi-currency accounts export a shape single-currency software was never designed to read: several balances, a transaction currency, an account currency, and sometimes a conversion rate. Importers pick one column, and it is frequently the wrong one.
Symptoms
Amounts are right in magnitude but wrong in value, as though converted Transactions from one currency import correctly while others do not Fee rows appear as separate transactions with no obvious counterpart
What actually causes it
Several amount columns in one file
A single row may carry the amount in the transaction currency, the amount in the account currency, the fee, and the rate applied. Only one of these belongs in a single-currency ledger.
Currencies mixed in one file
Exports frequently include every currency balance in one download. Imported into one account, the values are added together as though they were the same money.
Fees exported as separate rows
The transaction and its fee arrive as two rows. Apps that expect a single net amount show a duplicate-looking pair.
How to fix it
- Run the file through the checker below to confirm the structure is sound — delimiter, alignment and blank rows — before you start editing columns.
- Split the export by currency and import each into an account held in that currency.
- Keep exactly one amount column per file: the one denominated in that account's currency.
- Decide deliberately whether fees are separate transactions or part of the net amount, and apply that consistently — mixing the two makes reconciliation impossible later.
Related import problems
Skip the manual edit — fix it automatically
The checker validates the file mechanically; which currency column belongs in which account is a bookkeeping decision no tool should make for you. Free, no signup, no upload.
Open the fixer