Multi currency bank statements in a batch need one rule above all: treat each currency as its own account. A statement can hold dollar and euro sections, a currency column, or exchange lines that move money between them. Run a separate balance check per currency, export each currency to its own file, and never add amounts across currencies.
What makes a bank statement multi currency?
A bank statement is multi currency when it reports balances or transactions in more than one currency. That can mean one document covering several currency sub-accounts, one account whose lines carry their own currency codes, or a home-currency account that shows the foreign amount next to each converted charge. Each shape converts differently.
The three shapes you are likely to meet:
- Sectioned statements. One PDF with a block per currency, each with its own opening balance, transactions and closing balance. Common for business accounts that hold balances in several currencies.
- Line-level currency. One transaction list where each line has a currency code column, and balances are kept per currency elsewhere on the page.
- Converted lines. A home-currency account or card where each foreign purchase shows the original amount and currency, the rate, and the amount charged in the account's own currency.
The third shape is the most common and the easiest. The account itself has one currency. The foreign amount is extra information on the line, not a second balance. A dollar card used on a trip to Europe produces this shape, and in most cases you book the dollar amount.
The first two shapes are true multi currency statements, and they are what this post is mostly about. They hold real balances in more than one currency, and each balance has to be checked and exported on its own.
Currency columns and exchange lines on multi currency statements
Currency on a multi currency statement shows up in one of three places: a section heading, a column on each line, or the description text. Exchange lines are the transactions that move money from one currency balance to another. Each exchange appears twice, once as money out of one currency and once as money in to another.
Where the currency is printed
Look for the currency before you look at amounts. A section heading such as "EUR account" or a code beside each balance tells you which balance a line belongs to. When the statement has a currency column, every line carries its own code, and the converted rows need to keep that code. A line that loses its currency code becomes a bare number, and a bare 500.00 could be dollars, euros or pounds.
Some statements print a currency symbol inside the amount instead of a code. Symbols are less reliable than codes because several currencies share one symbol. The dollar sign, for instance, is used by more than one country. When only a symbol is printed, take the currency from the section heading or account details instead.
How exchange lines appear
An exchange line records a conversion inside the client's own accounts, for example selling dollars to buy euros. On a sectioned statement it shows as a debit in the dollar section and a credit in the euro section, often with matching reference text. The two amounts differ because of the rate, and that difference is the point: the dollar side and the euro side are each correct in their own currency.
In the books, an exchange is a transfer between two bank accounts held in different currencies, not income or an expense. How the client's accounting file records it, and where any exchange gain or loss lands, depends on how that file is set up for foreign currency. Check that setup with the client's accountant before the first export rather than after.
Why does each currency need its own balance check?
Each currency needs its own balance check because a balance check only works when every number in it is in the same unit. Opening balance plus credits minus debits equals closing balance is arithmetic on one currency. Add a euro line to a dollar balance and the check fails, or worse, passes by coincidence.
On a sectioned statement, run the check once per section:
- Take the section's opening balance in that currency.
- Add every credit and subtract every debit in that section only.
- Compare the result with the section's printed closing balance.
A statement with three currencies has three checks, and the statement is done only when all three pass. If one section fails, the others may still be right, so a single failed section is a narrower problem than it first looks.
On a line-level currency statement, group the lines by currency code first, then run each group against that currency's printed balances. Where a statement prints no per-currency balances at all, the check can only run at whatever level the statement does print, and the review needs to work harder.
AutoBankConvert checks that opening balance plus transactions equals closing balance before a statement is marked done, and flags a statement that fails instead of exporting it. For multi currency statements, test a sample from your own client before a full batch, and confirm the check is applied per currency balance on that layout.
Exporting multi currency statement lines without mixing amounts
Exporting multi currency statement lines safely means one export file per currency balance, each going to the bank account in the books that holds that currency. Never mix currencies in one amount column. A bank file is imported into one account, so it should carry one currency.
Before exporting, check each file against these points:
- One currency per file. Every line in the file carries the same currency code.
- The right ledger account. The dollar file goes to the dollar bank account and the euro file to the euro bank account in the client's books.
- Exchange lines on both sides. The dollar debit appears in the dollar file and the matching euro credit in the euro file. Once both are imported, they can be matched as a transfer.
- Dates kept as printed. An exchange often shows the same date on both sides. If the dates differ, keep each as the bank printed it.
File names help keep this straight. Add the currency code to each export file's name, next to the client, account and month. The guide to a bulk bank statement converter covers when per-client exports suit a batch better than a combined one, and for multi currency clients, per-client exports split by currency are the safer choice.
A worked example: dollar and euro sections in one batch
This worked example follows one made-up client whose bank sends a single statement with a dollar section and a euro section. It shows the two balance checks, the exchange line on both sides, and the two export files. All values are illustrative.
The statement
USD section, March
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| Mar 1 | Opening balance | 20,000.00 | ||
| Mar 4 | Client payment, invoice 114 | 6,000.00 | 26,000.00 | |
| Mar 10 | FX sale USD to EUR, ref 5521 | 5,440.00 | 20,560.00 | |
| Mar 22 | Software subscription | 120.00 | 20,440.00 | |
| Mar 31 | Closing balance | 20,440.00 |
EUR section, March
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| Mar 1 | Opening balance | 3,000.00 | ||
| Mar 10 | FX purchase EUR from USD, ref 5521 | 5,000.00 | 8,000.00 | |
| Mar 18 | Supplier payment, Lyon | 4,200.00 | 3,800.00 | |
| Mar 31 | Closing balance | 3,800.00 |
The two balance checks
- USD: 20,000.00 + 6,000.00 − 5,440.00 − 120.00 = 20,440.00. That matches the printed closing balance, so the USD section passes.
- EUR: 3,000.00 + 5,000.00 − 4,200.00 = 3,800.00. That matches the printed closing balance, so the EUR section passes.
Notice what would happen with a single check across both sections. Adding everything gives an opening of 23,000.00 and a closing of 24,240.00, a figure that means nothing in any currency. The single check is not just less precise. It is wrong.
The two export files
The USD file holds three lines and goes to the client's dollar bank account. The EUR file holds two lines and goes to the euro bank account. The exchange, reference 5521, appears as a 5,440.00 debit in the USD file and a 5,000.00 credit in the EUR file. In the books it is a transfer between the two accounts. The difference between the two figures reflects the exchange rate, and how it is treated depends on the client's foreign currency setup.
Multi currency statements to hold back from a batch
Some multi currency statements are better held back and handled one at a time. A batch works well when every statement has a clear structure the same checks can use. A statement that hides its currency, prints no per-currency balances, or mixes currencies in one balance column needs a person to read it first.
Hold a statement back when:
- No currency code or heading is printed for some lines, so you cannot tell which balance they belong to.
- One balance column mixes currencies, so no per-currency balance exists to check against.
- The client's books have no account for a currency that appears on the statement. Set up the account first, or the export has nowhere to go.
- The statement comes from a payment platform rather than a bank, with fees, holds and conversions bundled into single lines.
- It is the first statement of its kind for your practice. Convert it alone, check every section by hand, and batch later months once the first one is proven.
For clients onboarding with balances in several currencies, ask about foreign accounts at intake, not after the first statement arrives. The guide to onboarding multiple clients at once has an intake list where this question fits. Getting the statements in the first place follows the same routes as any other account, which the post on how to download multiple bank statements at once covers. After the run, reviewing a batch of converted statements gives the review order, and multi currency statements belong near the front of it. To try a batch of your own clients' statements, Get started explains how to request a spot.