Multi-Currency Bank Statement Handling for UK Bookkeepers — Complete Guide (2026)

It's 10pm. You're staring at a Revolut business statement showing transactions in EUR, USD, and GBP — and the clock is ticking toward your client's VAT deadline. The statement has two amounts for every transaction. Some lines have a € symbol. Others use $. A few are in £. You need clean, reconciled figures for the books, and you need them tonight.

If that scenario sounds familiar, you're not alone. Multi-currency bank accounts have exploded in popularity among UK businesses — Revolut Business alone passed 500,000 UK customers in 2025, and Wise (formerly TransferWise) serves over 16 million customers worldwide. But the bookkeeping has not kept pace. Most accounting workflows, software, and training were built for single-currency GBP statements.

This guide covers everything you need to handle multi-currency bank statements confidently — from understanding statement formats to reconciling exchange rate differences, calculating VAT on foreign currency transactions, and building a workflow that doesn't keep you up past midnight.

The Rise of Multi-Currency Business Banking in the UK

Five years ago, a UK business with foreign currency needs had two options: open a foreign currency account with a high-street bank (expensive, slow, minimum balance requirements) or eat the 3-5% spread on every international transaction through their GBP current account. Neither was good.

Then came Revolut, Wise, and a wave of fintechs offering borderless accounts with near-interbank exchange rates and no minimum balances. Suddenly, a small e-commerce business selling to EU customers could hold EUR natively. A freelance developer with US clients could invoice and receive USD without losing 5% to HSBC's exchange rate. An importer could pay Chinese suppliers in CNY through the same app.

The problem? These platforms generate statements that look nothing like a traditional Barclays or HSBC PDF. And the bookkeeping complexity multiplies with every currency you add to a client's portfolio.

The Scale of the Problem

A single Revolut Business statement for an active e-commerce client might contain:

• GBP transactions: UK supplier payments, Shopify payouts converted to GBP, UK tax payments
• EUR transactions: Amazon EU marketplace settlements, EU supplier invoices, EU VAT payments
• USD transactions: US marketplace payouts, SaaS subscriptions billed in USD, US freelancer payments
• Exchange transactions: Internal currency conversions with spreads embedded in the rate
• Fees in multiple currencies: Revolut's own fees deducted in the native currency of each transaction

That's a single bank statement with potentially 5+ currencies, each requiring separate handling for reconciliation, VAT, and accounting software import. Do this manually and a single statement can take over an hour to process. Multiply that by 5 clients, and you've just lost your evening.

Understanding Multi-Currency Statement Formats

Before you can build a workflow, you need to understand what each platform's statement actually contains. The three most common multi-currency statement formats UK bookkeepers encounter are Revolut, Wise, and traditional bank foreign currency accounts. Each has its own quirks.

Revolut's Multi-Currency Statement Format

Revolut statements are the most common multi-currency format UK bookkeepers encounter, and they're also the most complex. Key features:

• Dual-amount display: Every foreign currency transaction shows two amounts — the amount in the original currency (e.g. €149.99) and the equivalent in your base currency (e.g. £128.47). This is Revolut's greatest strength for bookkeeping — the GBP equivalent is calculated and displayed for you — but it also doubles the data volume per transaction.
• Base currency column: Revolut statements include a dedicated column showing the base currency (usually GBP) equivalent. The exchange rate used is Revolut's interbank rate at the time of settlement, including any weekend markup if applicable.
• Currency labels: Each transaction row carries a currency indicator (EUR, USD, GBP, etc.) in a dedicated column. Without this, you'd be guessing which currency a row is in based on the symbol alone.
• Exchange transactions: When you convert between currencies within Revolut (e.g. EUR to GBP), these appear as a pair of transactions: one debit in EUR and one credit in GBP, with the spread implicit in the exchange rate.
• Crypto and commodities: Some Revolut accounts include cryptocurrency or precious metal holdings. These appear in the same statement with their own currency codes (BTC, ETH, XAU) and require completely different VAT treatment.

Wise Borderless Account Statements

Wise (formerly TransferWise) statements are structured differently from Revolut:

• Per-currency sub-accounts: Wise organises transactions by currency balance. If your client holds EUR, USD, and GBP in Wise, the statement groups transactions under each currency heading rather than mixing them chronologically.
• Conversion transactions: Wise's core product is currency conversion, so their statements include detailed conversion transactions showing the source amount, target amount, exchange rate applied, and Wise's fee — all as separate line items.
• Fee transparency: Unlike Revolut (where fees are sometimes embedded in the exchange rate), Wise explicitly breaks out their fee as a separate transaction, which is easier for bookkeeping but means you have more rows to categorise.
• No base currency column: Wise statements typically do not include an automatic GBP equivalent column. You'll need to calculate or extract GBP equivalents yourself, which adds a manual step to the workflow.

Traditional Bank Foreign Currency Accounts

High-street banks like Barclays, HSBC, and Lloyds also offer foreign currency accounts, but their statements are simpler — often just a single-currency statement in EUR or USD with no GBP equivalent shown. The challenge here is purely one of exchange rate calculation: you need to apply a consistent rate to convert the entire balance or individual transactions to GBP for your client's UK books.

The Exchange Rate Problem: Which Rate Do You Use?

This is the question that causes the most anxiety among bookkeepers handling multi-currency statements. There is no single "correct" answer — there are several acceptable methods, and the key is consistency plus HMRC compliance.

Method 1: The Bank-Applied Rate (Recommended Where Available)

If the statement includes the actual exchange rate applied to each transaction (Revolut statements do; Wise conversion transactions do), use it. This is the rate that determined how much actually left or entered the client's account in GBP terms. It's defensible, auditable, and requires no external lookup.

For Revolut statements, the GBP equivalent is already calculated for you in the base currency column. For Wise, you'll find the rate on each conversion transaction row and can apply it to calculate the GBP equivalent of fees and other currency-specific transactions.

Method 2: HMRC Published Monthly Rates

HMRC publishes monthly average exchange rates for major currencies. These are available on GOV.UK and are updated at the start of each month. Using HMRC rates has one major advantage: HMRC cannot dispute the rate you used because it's their own published rate.

The downside is that HMRC monthly rates are averages. If the client made a large EUR purchase on a day when the rate was significantly different from the monthly average, the GBP equivalent you calculate won't match the amount that actually left their bank account. For most bookkeeping purposes, this discrepancy is acceptable — but for large, material transactions, it's worth flagging the difference.

Method 3: Spot Rate on Transaction Date

Using the spot rate (from the Bank of England, XE.com, or OANDA) on the date of each transaction provides precision but creates an enormous administrative burden. You'd need to look up the rate for every single transaction, on every single date, for every single currency. For a Revolut statement with 120 transactions across a month, that's potentially 30+ rate lookups.

Exchange Rate Fluctuations and Reconciliation Drift

Here's a scenario every multi-currency bookkeeper has faced: your client's Revolut statement shows an opening balance of €10,000 and a closing balance of €8,500. In GBP terms, those amounts don't reconcile cleanly because the EUR/GBP rate moved during the month. The €10,000 was worth £8,600 at the start of the month and the €8,500 is worth £7,395 at month-end — but the actual GBP movement includes both genuine spending (£1,380) and exchange rate loss (£175).

This "reconciliation drift" is not an error. It's an unavoidable consequence of holding foreign currency. The right approach is to separate the bookkeeping into two layers:

1. Transaction-level reconciliation: Reconcile each transaction at the rate that applied when it settled. This tells you the genuine business income and expenditure.
2. Period-end revaluation: At month-end (or year-end), revalue any remaining foreign currency balances at the current rate. The difference is a currency gain or loss — a non-trading item that belongs in the P&L as "foreign exchange gain/loss."

This two-layer approach is standard accounting practice (IFRS and UK GAAP both require it for material foreign currency balances), but remarkably few small-practice bookkeepers apply it consistently. If you're charging for bookkeeping, this is exactly the kind of value-add that justifies your fees.

VAT Implications of Foreign Currency Transactions

VAT on foreign currency transactions is where multi-currency bookkeeping gets genuinely dangerous. Get this wrong, and your client's VAT return is inaccurate — which means you, as the bookkeeper or accountant, carry the liability risk.

VAT on Imports: The GBP Conversion Rule

When a UK VAT-registered business imports goods from outside the UK, the VAT value must be calculated in GBP. HMRC requires you to use:

• The UK market selling rate at the time of supply (i.e. the rate on the invoice date or the date the goods were dispatched), or
• HMRC's published period rates of exchange (monthly averages)

The critical point: you cannot simply use whatever rate Revolut happened to apply when it debited the account. Revolut's rate includes a spread and may be applied on a different date than the supply date. For VAT purposes, the supply date rules. If your client bought goods from a German supplier on 5th May but Revolut settled the EUR payment on 7th May, the VAT conversion should use the 5th May rate.

VAT on Services: Place of Supply Rules

Services to non-UK customers are generally outside the scope of UK VAT (the place of supply is where the customer belongs). But you still need to record the transaction in GBP for your client's accounts. And if the client is on the Flat Rate Scheme, the gross including foreign currency turnover counts toward the flat rate threshold and calculation.

Practical VAT Workflow for Multi-Currency Statements

1. Flag foreign currency VAT transactions during your reconciliation so they don't get treated as standard GBP transactions.
2. Record both amounts: the original currency amount (for the audit trail) and the GBP equivalent used for the VAT calculation (for the return).
3. Document your rate source for each VAT-period transaction. A simple note in your working papers: "EUR/GBP rate source: HMRC May 2026 monthly average (1.163)" is sufficient.
4. Keep the original statement showing the foreign currency amounts. If HMRC queries the return, you'll need to demonstrate that the GBP figures on the return trace back to actual bank transactions.

Practical Multi-Currency Bookkeeping Workflow

Let's build a workflow you can use tonight, even with that Revolut statement that's been sitting in your inbox. This isn't theoretical — it's how real bookkeeping practices handle multi-currency statements efficiently.

Step 1: Convert the Statement to a Structured Format

You cannot work effectively from a PDF of a multi-currency statement. You need the data in a format you can sort, filter, and calculate. Use BankScan AI to convert multi-currency statements to Excel or CSV. The AI extracts every field — date, description, original currency, original amount, base currency equivalent, exchange rate, and transaction type — into structured columns.

Step 2: Separate by Currency

Once you have the data in Excel, create a separate sheet (or separate CSV file) for each currency. Filter the raw data by the currency column and copy each currency's transactions to its own sheet. This gives you:

• GBP sheet: All GBP transactions, including GBP equivalents of exchange conversions
• EUR sheet: All EUR transactions in their original amounts
• USD sheet: All USD transactions in their original amounts
• Exchange sheet: Internal currency conversions, matched as pairs

Step 3: Reconcile Each Currency Independently

Treat each currency as a separate bank account for reconciliation purposes. Reconcile the EUR sheet against EUR opening and closing balances. Reconcile USD against USD. This catches missing transactions and data extraction errors much faster than trying to reconcile a mixed-currency file.

Step 4: Calculate GBP Equivalents (Where Missing)

For transactions where the statement doesn't provide a GBP equivalent (common with Wise and traditional bank foreign currency accounts), add a column for the GBP equivalent and calculate it using your chosen method (bank rate, HMRC monthly average, or spot rate). If you're using HMRC rates, you can import the monthly rate table as a lookup sheet and use VLOOKUP or XLOOKUP to pull the rate automatically.

Step 5: Identify and Match Exchange Transactions

Currency exchanges within the account should net to zero (minus any spread). Match each "EUR debit — exchange to GBP" with its corresponding "GBP credit — exchange from EUR." The difference between the two is the effective exchange spread, which is a bank charge and should be categorised as such in the P&L.

Step 6: Flag VAT-Sensitive Transactions

Add a "VAT Treatment" column and categorise each foreign currency transaction:

• UK VAT: Transaction is subject to UK VAT (e.g. purchase from UK supplier invoiced in EUR)
• Import VAT: Goods imported from outside UK with import VAT due
• OSS/IOSS: EU sales under the One Stop Shop scheme
• Out of scope: Services to non-UK customers, B2B intra-community supplies
• No VAT: Bank fees, exchange gains/losses, internal transfers

Step 7: Import into Accounting Software

Most accounting software (Xero, QuickBooks, FreeAgent) handles multi-currency if you set up separate bank accounts for each currency. Import each currency sheet as a separate bank feed. BankScan AI can format the output specifically for Xero import or QuickBooks import, including multi-currency CSV layouts.

How BankScan AI Handles Multi-Currency Statements

We built BankScan AI to handle exactly the multi-currency bookkeeping nightmare described in this guide. Here's what it does specifically for multi-currency statements:

• Currency-aware extraction: The AI recognises currency symbols (£, €, $, ¥, etc.) and three-letter currency codes (GBP, EUR, USD) and tags each transaction with the correct currency. No more guessing which column is which.
• Dual-amount preservation: For Revolut statements, BankScan AI preserves both the original currency amount and the base currency (GBP) equivalent as separate columns. You get clean, structured data without losing any information.
• Exchange rate extraction: Where the statement includes an applied exchange rate, BankScan AI extracts it into a dedicated column. This makes audit trails, VAT documentation, and client reporting dramatically easier.
• Multi-currency export: Export transactions grouped by currency, or export a unified file with all currencies with currency tags — whichever fits your workflow.
• Wise, Revolut, and traditional bank support: The same engine handles Revolut Business PDFs, Wise borderless account statements, and traditional bank foreign currency statements from Barclays, HSBC, and Lloyds.

Comparison: Multi-Currency Statement Handling Methods

Common Multi-Currency Bookkeeping Mistakes (and How to Avoid Them)

Mistake 1: Using the Wrong Exchange Rate Date

Bookkeepers often use the statement date rather than the transaction settlement date for exchange rate lookups. For a Revolut transaction that settled on 3rd May, but you're processing the statement on 15th May, the rate on 3rd May is what matters. Using the wrong date can cause material discrepancies on large transactions.

Fix: Always use the transaction date recorded on the statement, not the date you're doing the bookkeeping. BankScan AI extracts the transaction date automatically from each row.

Mistake 2: Mixing Original and Converted Amounts

This is the most dangerous error: entering an original EUR amount into a GBP-denominated ledger. A €5,000 purchase entered as £5,000 in the accounts overstates the expense by approximately £650 (at a ~1.15 EUR/GBP rate). Over a full year of transactions, this can misstate profits by thousands of pounds.

Fix: Maintain strict separation between original currency amounts and GBP equivalents in your working papers. Label every column clearly. When in doubt, keep the original amount as your source of truth and calculate the GBP equivalent as a derived field.

Mistake 3: Ignoring Exchange Rate Gains and Losses

If your client held €20,000 in their Revolut account throughout January and the EUR/GBP rate moved from 1.15 to 1.17, they've effectively lost £227 in GBP value — even though they didn't make a single transaction. Many bookkeepers ignore this because it's "unrealised." But for businesses with material foreign currency balances, failing to recognise revaluation gains and losses produces inaccurate accounts.

Fix: For any client with foreign currency balances above £1,000 equivalent, perform a period-end revaluation. For most small businesses, quarterly revaluation is sufficient. For larger balances or volatile currencies, monthly revaluation is appropriate.

Mistake 4: Inconsistent VAT Treatment

Treating a EUR supplier invoice as no-VAT because "it's in euros" is wrong. The VAT treatment depends on what was supplied, from where, and to whom — not the currency of the invoice. A UK supplier invoicing in EUR is still subject to UK VAT. An EU supplier may be subject to reverse charge VAT.

Fix: Apply VAT rules based on the nature of the supply and the location of the supplier and customer. The currency is irrelevant to the VAT treatment.

Multi-Currency Statements and Accounting Software

Xero Multi-Currency

Xero's multi-currency support is the strongest of the major small-business accounting platforms. It supports 160+ currencies with automatic daily exchange rate feeds from XE.com. You set up each currency as a separate bank account within Xero, and Xero handles the conversion to your base currency (GBP) automatically using the daily rate.

However, Xero's automatic rates can diverge from the actual rate applied by Revolut or Wise on specific transactions. For important transactions, you can override Xero's automatic rate with the actual rate from your statement. If you use BankScan AI to extract the bank-applied rate into a column, you can transfer this into Xero for precise matching.

QuickBooks Online Multi-Currency

QuickBooks Online supports multi-currency on Essentials and above. For CSV imports, you specify the transaction currency during import. QuickBooks maintains its own exchange rate table (updated daily) and applies the rate on the transaction date automatically. As with Xero, you can override the automatic rate with the actual rate from your statement.

The key limitation: QuickBooks imports one currency per CSV file. If your Revolut statement contains EUR, USD, and GBP transactions in a single export, you'll need to split them into separate CSV files per currency before importing. BankScan AI can export split-by-currency files for this purpose.

FreeAgent Multi-Currency

FreeAgent supports multi-currency bank accounts but with more limited automation than Xero or QuickBooks. Exchange rate management is more manual. If your client uses FreeAgent, the structured Excel export from BankScan AI with pre-calculated GBP equivalents saves significant manual effort.

Building a Scalable Multi-Currency Workflow for Your Practice

If multi-currency clients are a growing part of your practice, you need a workflow that scales. Here's how to build one:

Layer 1: Statement Ingestion

Standardise how statements arrive. Ask clients to download their Revolut or Wise statements as PDFs and upload them to a shared folder, or forward them to a dedicated email address. Avoid receiving screenshots — they can't be reliably converted.

Layer 2: Automated Conversion

Use BankScan AI to convert every multi-currency statement to structured Excel. The AI handles currency detection, dual-amount extraction, and GBP equivalent calculation in one pass. Bulk upload means you can process a month's worth of client statements in minutes rather than hours.

Layer 3: Reconciliation in Excel

Build a template Excel workbook with sheets for each currency, pre-configured with:

• Exchange rate lookup tables (HMRC monthly rates)
• VAT treatment categorisation columns
• Opening/closing balance reconciliation formulas
• Exchange gain/loss calculation cells

Layer 4: Accounting Software Import

From your reconciled Excel workbook, export currency-specific CSV files for import into Xero, QuickBooks, or FreeAgent. This gives you a documented audit trail: original statement → BankScan AI conversion → reconciliation workbook → accounting software import.

Frequently Asked Questions

How do I calculate GBP equivalent amounts for foreign currency transactions on a bank statement?

You need the transaction's original currency amount and the exchange rate on the date the transaction settled. Multiply the foreign currency amount by the rate to get the GBP equivalent. Be careful: banks like Revolut apply their own interbank rate plus a markup, and the rate on the transaction date may differ from the statement date. For HMRC compliance, use HMRC's published monthly exchange rates or the actual rate applied by the bank — whichever is more consistent across your bookkeeping. Automated tools like BankScan AI can extract both the original amount and, where available, the GBP equivalent directly from the statement, eliminating manual rate lookups.

Why do Revolut statements show two different amounts for the same transaction?

Revolut displays transactions in both the original transaction currency and your account's base currency (e.g. GBP). This dual-amount display is essential for bookkeeping — the original currency amount tells you what was actually spent, while the base currency amount is what left your account after conversion. When converting the statement to Excel, you must preserve both amounts: the original currency column for audit trails and the GBP equivalent for your UK bookkeeping ledgers. BankScan AI's Revolut converter handles this automatically.

What exchange rate should UK bookkeepers use for foreign currency transactions?

For UK bookkeeping, you have three options: (1) the actual rate applied by the bank at the time of the transaction — most accurate but requires extracting it from the statement; (2) HMRC's published monthly average exchange rates — acceptable for VAT and tax returns and cannot be disputed by HMRC; (3) the spot rate from a reliable source like the Bank of England or XE.com on the transaction date. Consistency is key: pick one method and apply it across all clients. For Revolut and Wise statements, using the bank-applied rate is ideal because it's the actual amount debited from the account.

Are foreign currency transactions subject to UK VAT, and how do I account for them?

Yes, foreign currency transactions can be subject to UK VAT. The VAT treatment depends on the nature of the transaction, not the currency. For VAT-registered businesses, you must convert the foreign currency amount to GBP using HMRC's published exchange rates (or the UK market selling rate at the time of supply) for your VAT return. Services to non-UK customers may be outside the scope of UK VAT (place of supply rules apply). Imported goods attract import VAT at the point of entry. Always record both the original currency amount and the GBP equivalent used for the VAT calculation — HMRC may request both during a compliance check.

Can I import multi-currency bank statements directly into Xero or QuickBooks?

Xero supports multi-currency accounts natively, including automatic exchange rate feeds from XE.com. For CSV imports, you must provide the transaction amount in the account's base currency. QuickBooks Online also supports multi-currency but requires the transaction currency to be specified during import. The challenge is that Revolut and Wise statements often list transactions in multiple currencies within a single statement file — most accounting software expects one currency per bank account. BankScan AI can separate multi-currency transactions by currency and prepare separate import files for each currency account in your software.

Last updated: 19 May 2026. Have a question about handling multi-currency bank statements? Visit BankScan AI or read our other guides for UK accountants and bookkeepers.