“My multi-currency statement imports with the wrong amounts”
Short answer
Wise and Revolut rows carry several amounts: the transaction currency, the account currency, the fee and the rate, and a single-currency importer picks one, often the wrong one. Split the export by currency, import each part into an account held in that currency, and keep exactly one amount column per file. Fees arriving as separate rows are a bookkeeping decision to settle once.
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.
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