Convert a Revolut Statement to Excel
Revolut statement conversion, the multi-currency structure that trips up most tools, and how to verify per currency.
Revolut statements have one dominant characteristic: they are multi-currency, and that changes almost everything about how they should be converted and verified.
Several currencies, several balances
A Revolut account can hold GBP, EUR, USD and a dozen others simultaneously. Each currency has its own balance, and each moves independently. There is no single account balance.
Flattening all currencies into one table with one amount column produces something actively misleading: a total that sums pounds and euros as though they were the same unit.
Exchanges appear twice
A currency exchange in Revolut is two transactions: a debit in the source currency and a credit in the target currency. Both are real, both appear, and they are not duplicates of each other.
A converter that deduplicates on amount and date could remove one side of an exchange, which breaks the balance of one currency and not the other.
| Event | Rows produced |
|---|---|
| Card payment in EUR | One EUR debit |
| Exchange GBP → EUR | One GBP debit and one EUR credit |
| Transfer received in USD | One USD credit |
| Fee on an exchange | One debit in the fee currency |
Verifying per currency
Filter to one currency, then check that currency's opening balance, transactions and closing balance form a valid chain. Repeat per currency. Any single figure covering the whole statement is meaningless.
Analysing a Revolut export
The most common mistake with Revolut data is treating it as one account. It is several, and they only make sense read separately.
- Filter to one currency Every analysis starts here. Nothing meaningful spans currencies without an explicit conversion.
- Verify that currency's chain Its own opening balance, transactions and closing balance.
- Separate exchanges from spending An exchange is a transfer between your own balances, not expenditure.
- Then total the spending Excluding exchanges, top-ups and transfers between your own accounts.
Why exchanges distort a spending total
If you exchange £1,000 into euros and then spend €900, a naive total of all debits shows £1,000 of GBP outflow plus €900 of EUR outflow — roughly double your actual spending.
The exchange was not spending; it was moving your own money. Excluding own-transfers is the single most important step in making Revolut data meaningful.
Frequently asked questions
Is the currency exported as a column?
Only where Revolut prints one. The table comes through as printed and no currency column is added, so where each currency has its own section, split the rows where each currency's section starts before totalling anything.
Why is my Revolut spending total so high?
Exchanges and top-ups are probably being counted as transactions. Both move your own money between your own balances and should be excluded before totalling spend.
Are crypto holdings included?
Crypto transactions appear where the statement includes them, exactly as printed. Nothing separates them from fiat automatically, so filter them out before totalling a fiat balance.
Related posts
- Convert an HSBC UK Statement to Excel
- Convert a TSB Bank Statement to Excel
- Convert a Monzo Statement to Excel
Convert a statement now
Bank Statement PDF to Excel, or see every format. More in the guides.