Revolut Statement to Excel: Multi-Currency Guide

TL;DR A Revolut account often holds more than one currency, and each currency behaves like its own mini account with its own opening and closing balance. To get a Revolut statement into Excel properly, generate a statement for each currency you use, convert each one so every transaction is one row with a signed amount, and keep a Currency column. Treat currency exchanges as transfers between two balances rather than as income or spending, record fees as their own lines, and check each currency's balance separately. Only convert to a single reporting currency at the end, using a rate source you can explain.

Revolut is popular with freelancers, frequent travellers, remote workers and small businesses that get paid in more than one currency. That flexibility is exactly what makes its statements harder to work with in a spreadsheet than a plain current account. A single month can include card payments in three currencies, an exchange from pounds to euros, a top-up from another bank, a refund that arrived in a different currency from the original purchase, and a subscription fee.

This guide explains how to get Revolut data into Excel in a way that still adds up: how to think about multi-currency balances, how to convert the statements, how to treat exchanges and fees, how to check the results, and how to produce a single summary in your home currency. App screens change regularly, so we describe the options in general terms instead of giving exact menu paths.

Why Revolut statements need a different approach

With a traditional single-currency account, a statement is one list of transactions with one opening and one closing balance. With a multi-currency account, you effectively have several lists:

• a GBP balance with its own opening balance, transactions and closing balance;
• a EUR balance, likewise;
• a USD balance, and so on.

An exchange from GBP to EUR shows up twice: money out of the GBP balance and money into the EUR balance, at different amounts because of the rate. If you dump everything into one column and sum it, you're adding pounds to euros, which produces a number that means nothing.

So the core rule for this whole guide is simple: keep a Currency column on every row, and never add amounts across currencies without converting them first.

Getting the data out

Revolut lets you generate statements from the app or the web, typically by choosing an account or currency balance and a date range. Depending on the account type, you'll usually be offered a PDF and, in many cases, a spreadsheet-style export. Business accounts may have additional export options for accounting software.

Which should you use?

The spreadsheet export is convenient if it's available for the period and currency you need. Check that it includes the columns you care about (date, description, amount, fee, currency and balance) and that it covers the whole period, not just recent activity.

The PDF statement is the version you'd send to a landlord, lender, embassy or accountant, and it's what you'll often be asked for as proof. It's also the document with clear starting and ending balances. If you've been sent PDFs by someone else, or you only kept PDFs, converting them is the way to get a spreadsheet.

Either way, generate one file per currency balance per period, and name them consistently: revolut-gbp-2026-06.pdf, revolut-eur-2026-06.pdf. Sorted names make it obvious if a currency or a month is missing.

What a Revolut statement usually contains

Exact layouts change, but a Revolut statement for one currency typically shows:

• the account holder and the currency;
• the period covered;
• a balance summary: opening balance, money in, money out, closing balance;
• a transaction list with date, description, money out, money in, and a balance after each transaction.

Some statements also list fees separately, or include notes about exchange rates on card payments in other currencies. Some show pending or reverted card transactions in a separate section. Read the first page of your statement before converting so you know which sections exist.

Converting a Revolut statement to Excel

Option 1: use the spreadsheet export directly

If you have a spreadsheet export, open it in Excel and check three things before doing anything else:

1. Dates are real dates, not text. Sort oldest to newest and confirm the range.
2. Amounts are numbers with a consistent sign. Some exports show money out as negative; others use separate columns.
3. Fees are either included in the amount or listed in a separate column. If separate, you'll need to decide how to handle them (see below).

Option 2: convert the PDF

For PDFs, you can copy and paste small pages, try Power Query's PDF import on Windows Excel (see our Power Query bank statement guide), or use a converter. SheetStatement reads the statement, puts each transaction on one row with a signed amount, and checks the opening balance plus activity against the closing balance before you export to Excel, CSV, Xero or QuickBooks. The free plan includes 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans cover more.

The target layout

Aim for one table across all currencies with these columns:

These figures are illustrative, including the exchange rate. Use your own statement's numbers.

The Type column is something you add. It isn't on the statement, but it makes the later steps far easier.

Handling currency exchanges

An exchange is not income and not spending. It's money moving from one of your balances to another. If you categorize the GBP side as an expense and the EUR side as income, your totals will be inflated on both sides.

The cleanest approach:

1. Mark both sides with a Type of Exchange out and Exchange in.
2. Give them a shared reference, for example EX-0604-1, in a separate column so you can pair them.
3. Exclude both from income and expense summaries.

If you need to know what the exchange cost you, compare the rate you got with a reference rate for that day. The difference is the effective cost of the exchange. Whether you record that as a separate expense depends on how precise your bookkeeping needs to be; many individuals don't bother, many businesses do.

Handling fees

Fees can appear in a few ways:

• As separate lines, for example a monthly plan fee or a fee for a particular service. Treat these as their own expense rows.
• Bundled into a transaction, where the amount shown already includes a fee.
• In a separate fee column next to the transaction.

If fees are in a separate column, create a total-impact column so your balance check works:

=[@Amount] - N([@Fee])

Adjust the sign depending on whether the fee column shows positive or negative numbers. Then check which version (amount alone or amount plus fee) makes the balance column agree. That tells you how your statement presents fees.

Card payments in another currency

If you pay in a currency you don't hold, the payment is usually converted at the time and taken from a balance you do hold. The statement then shows the amount in the balance's currency, sometimes with the original amount and rate noted in the description.

For bookkeeping, record the amount that actually left your balance. If you want the original amount for receipts matching, split it into separate columns with Excel's text functions or TEXTSPLIT.

Refunds and reverted transactions

Card refunds often arrive days or weeks after the original purchase. If the refund was converted at a different rate, it may not exactly cancel the original payment. That's normal. Match them by merchant and approximate amount, and note the small difference as an exchange gain or loss if you need that level of detail.

Reverted or declined card transactions sometimes appear in a separate section of the statement. If they never affected the balance, leave them out of your transaction table entirely.

Checking each currency balance

Each currency should balance on its own. With your data in an Excel table named Tx, and an opening and closing balance per currency in a small summary table, use:

=ROUND(Opening + SUMIFS(Tx[Amount], Tx[Currency], [@Currency]) - Closing, 2)

Each row of the summary should return 0. If one currency is out:

• By one transaction amount: a row is missing.
• By twice an amount: a sign is wrong.
• By a fee-sized amount: fees are being counted twice, or not at all.
• By an exchange amount: one side of an exchange was assigned the wrong currency.

Because Revolut statements usually show a balance after each transaction, you can also check line by line within each currency, which pinpoints where an error starts. Our guide to the running balance formula explains the method, and the free balance checker handles quick totals.

Building one summary in your home currency

Once each currency balances, you may want a single view, for example everything in GBP for a tax return or in EUR for a business based in the euro area.

1. Add a Rate column and a Home amount column.
2. Choose a rate source and stick to it. Common choices are a daily rate from a central bank, a monthly average, or the actual rate you received on exchanges. Your accountant or tax authority may have a preferred approach.
3. Look up the rate by date and currency:

=XLOOKUP([@Date]&[@Currency], Rates[Date]&Rates[Currency], Rates[Rate])

4. Calculate =[@Amount] * [@Rate].
5. Exclude exchanges from income and expense totals, as before.

Write down which rate source you used. If anyone asks how a figure was produced, a one-line note answers it.

A worked example: a freelance designer

A freelance designer based in the UK is paid by clients in GBP and EUR and pays for some software in USD. She keeps all three balances in Revolut and wants a clean income and expense summary for the tax year.

1. Statements. She generates a statement for each currency for each month of the tax year, giving 36 files, and names them by currency and month.
2. Convert. Each becomes a table with a Currency column. She appends them into one table.
3. Type column. She tags rows as Income, Card, Transfer in, Transfer out, Exchange in, Exchange out or Fee.
4. Balance each currency per month. Thirty-five files balance. The EUR file for one month is out by the exact amount of an exchange. The GBP-to-EUR exchange had been tagged with GBP as the currency on both sides. Fixing it clears the difference.
5. Pair exchanges. She adds a reference to each pair and excludes them from totals.
6. Convert to GBP. She uses one consistent daily rate source for EUR and USD rows and notes it on a cover sheet.
7. Summarize. A pivot table shows income by client and expenses by category in GBP.

Her accountant gets the original PDFs, the workbook and the cover note. This is general bookkeeping practice; what's required for your tax return depends on your situation, so check with an accountant or your tax authority.

Importing Revolut data into accounting software

Most accounting packages treat each currency as a separate bank account. In practice, that means one import per currency.

• Xero supports multi-currency on certain plans. Create a bank account for each currency and import each CSV separately. Our Xero CSV import format guide covers the column layout.
• QuickBooks Online supports multi-currency once enabled. Each foreign-currency bank account gets its own CSV. See importing a bank statement into QuickBooks Online.
• Exchanges become transfers between the two bank accounts. If your software records a transfer at its own rate, the difference ends up as an exchange gain or loss.

Some business accounts can connect directly to accounting software. If you use a direct feed, convert statements only to fill gaps or to check that the feed is complete.

Troubleshooting

The total looks huge or tiny. You're summing across currencies. Filter by currency or use SUMIFS.

Dates are off by a day. Some exports use a timestamp that's converted to your computer's time zone. If dates shift near midnight, use the statement's dates rather than the timestamp, or strip the time part.

Amounts won't add up. They may be text. See cleaning bank statement data in Excel for removing currency symbols, non-breaking spaces and thousands separators.

A refund doesn't cancel the original purchase. Different exchange rates on the two dates. Expected, and usually small.

Duplicates after combining files. Overlapping date ranges. Use removing duplicate transactions in Excel to clean them up, then re-run the balance check.

Revolut statements as proof of funds or income

Landlords, lenders and visa offices often want the original statement, not a spreadsheet. Generate the official statement for the period requested and send that. Your spreadsheet is still useful for your own preparation: it helps you explain large deposits, regular income and exchanges before you're asked. See bank statements for a visa application and self-employed proof of income.

Convert a Revolut statement

Upload a Revolut statement PDF to SheetStatement, check the rows and the balance check, and download Excel, CSV, Xero or QuickBooks files. The free plan includes 3 pages a month, enough to try it on a real statement.

FAQ

Can I export Revolut transactions straight to Excel?

Many accounts offer a spreadsheet-style export as well as a PDF statement. Check that it covers the period you need and includes fees and balances. If you only have PDFs, convert them.

Why does my Revolut spreadsheet total make no sense?

You're probably adding amounts in different currencies. Keep a Currency column and total each currency separately, or convert everything to one currency with a consistent rate first.

How should I treat currency exchanges?

As transfers between two of your own balances, not as income or spending. Tag both sides, pair them with a reference, and exclude them from income and expense totals.

Do I need a separate statement for each currency?

Usually yes. Each currency balance has its own opening and closing balance, so a separate statement per currency makes checking much easier.

Which exchange rate should I use for a summary?

Pick one consistent source, such as a central bank daily rate or a monthly average, and note it. Your accountant or tax authority may prefer a specific method.

Can I import Revolut data into Xero or QuickBooks?

Yes. Set up one bank account per currency and import each currency's CSV separately. Record exchanges as transfers between those accounts.

Is this tax advice?

No. This is general information about organizing records. Check with a qualified accountant or your tax authority about your own situation.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.