# Multi Currency Bank Statement to Excel, One Sheet

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-17
- Category: Statements and documents
- Canonical: https://cheapbankconvert.com/blog/multi-currency-bank-statement-to-excel

> Turn a multi currency bank statement into Excel: separate currency sections, conversion rows and fees, and one total in your home currency.
To turn a multi currency bank statement into Excel, keep each currency's rows in their original currency with a currency column, record conversions between your own balances as paired rows, and add one home currency column using a rate you choose and note. Total that column for the overall figure. Never add euros to dollars directly.

## How is a multi currency bank statement laid out?

A multi currency bank statement usually prints one section per currency, each with its own opening balance, transactions and closing balance. Some accounts print all currencies in one list with a currency code on each line instead. Either way, every amount belongs to one currency, and that currency must travel with the amount into Excel.

The section layout is the more common one on accounts that hold several balances at once. A statement might open with a summary box listing each currency balance, then run a euro section, a pound section and a dollar section, each a few pages long. Inside a section, the rows look like any statement: a date, a description, money in, money out and a running balance in that currency.

The single-list layout mixes currencies line by line. A row reads, for example, "2026-09-04, Hotel booking, EUR, -240.00". There may be no running balance at all, because a balance in mixed currencies means nothing.

A few lines need special attention in either layout:

- **Conversion lines**, where you move money from one of your balances to another, such as pounds into euros.
- **Fee lines**, which may sit in a separate fees section or follow the conversion they belong to.
- **Card purchases abroad**, which can show a foreign amount, the rate applied and the amount taken from your balance, all on one line or across two.

Before you convert or copy anything, flip through the PDF and note which layout you have and where the section breaks fall. That decides how you lay out the sheet.

## A sheet layout for multi currency rows

The sheet layout that works for multi currency rows keeps one row per transaction, with the amount in its original currency, a currency code column, and a separate home currency column. Do not make one amount column per currency. That layout breaks filters and totals as soon as a fourth currency appears.

Use these columns, from left to right:

| Column | What goes in it | Example value |
| --- | --- | --- |
| date | Posting date of the transaction | 2026-09-04 |
| description | The text the bank printed | HOTEL LISBOA |
| currency | Three-letter currency code | EUR |
| amount | Signed amount in that currency | -240.00 |
| section_balance | The running balance printed in that section | 1,385.50 |
| rate | The rate you used to reach your home currency | 1.0850 |
| amount_home | amount multiplied by rate | -260.40 |
| type | purchase, income, conversion or fee | purchase |

The example values are made up for illustration, and the example rate means 1 euro equals 1.0850 home currency units. Keep the original amount and the converted one side by side. The original is what the bank printed and what you check against. The home currency figure is your own calculation, and the rate column records how you got it.

Three-letter codes such as EUR, GBP and USD are the safe choice for the currency column. Symbols are ambiguous, because "$" can mean several different dollars.

## Currency conversion rows and fees on a multi currency statement

A conversion between your own currency balances is one transfer that shows up twice: money out of one section and money in to another. Record it as two rows with the type "conversion" and a shared reference, so that the pair cancels out in your home currency total and only the fee counts as a cost.

Here is an example, with made-up figures. You convert 500.00 pounds into euros. The pound section shows "-500.00 GBP, Converted to EUR". The euro section shows "+578.20 EUR, Converted from GBP". A separate line shows "-2.10 GBP, Conversion fee".

In the sheet, that becomes three rows. The two conversion rows share a reference, such as "conv-0912". In your home currency column, they should come close to cancelling. They rarely cancel exactly, because the bank's rate and the rate you use for your sheet are not the same. That small difference is not spending. Some people put it on its own row as an exchange difference so the totals stay honest.

The fee row is real spending and should stay typed as "fee". Fees on currency accounts can appear in three places: as a separate line, as a markup built into the rate with no line at all, or as a monthly charge for holding a balance. Only the first and last show on the statement as amounts. A markup inside the rate shows only if you compare the rate the bank used with a published reference rate for the same day.

## Which exchange rate should a home currency total use?

A home currency total should use one rate rule that you choose, write down and apply to every row. The two common choices are the rate on the day of each transaction and an average rate for the year. For tax, the rule usually comes from your tax authority, so check theirs before you pick.

In the US, the IRS page on [yearly average currency exchange rates](https://www.irs.gov/individuals/international-taxpayers/yearly-average-currency-exchange-rates) says that in general you should "use the exchange rate prevailing (i.e., the spot rate) when you receive, pay or accrue the item". The same page publishes yearly average rates and tells you to divide the foreign currency amount by the rate in its table to reach dollars. It also says those rates do not apply when you pay US taxes.

For a budget or a spending review, the stakes are lower. An average rate for the month or the year is simpler and good enough to see where money went. For anything you will file or show to an accountant, use the rule that applies to you and keep the rate source in the sheet, so the numbers can be rebuilt.

Watch the direction of the rate. A rate can be quoted as home currency per foreign unit, or foreign units per home currency. One means multiply and the other means divide. Test the formula on one row where you already know the answer before you fill the column.

## Worked example: three currency sections, one home currency total

This worked example takes a statement with euro, pound and dollar sections and produces one total in US dollars. Every figure, including the rates, is made up for illustration. The rates are written as dollars per one unit of the foreign currency, so the formula multiplies.

| Section | Rows | Net movement | Example rate to USD | Net in USD |
| --- | --- | --- | --- | --- |
| EUR | 14 | -812.40 EUR | 1.0850 | -881.45 |
| GBP | 6 | -502.10 GBP | 1.2700 | -637.67 |
| USD | 9 | +1,140.00 USD | 1.0000 | +1,140.00 |
| Total | 29 | | | -379.12 |

The GBP figure includes the 500.00 converted into euros and the 2.10 fee. The EUR figure includes the 578.20 that arrived from that conversion. In dollars, those two conversion rows come to -635.00 and +627.35, a difference of 7.65 that is mostly the gap between the bank's rate and the example rates, not new spending. Tagging both rows as conversions lets a filter remove them, leaving only real purchases, income and fees.

To build the total in Excel, fill the amount_home column with the amount times the rate, then use a SUMIF on the type column to total purchases, income and fees separately. A pivot table with currency as rows and type as columns gives the same view with less typing.

If you are working through a whole year of spending in one currency, a card's own year-end summary can save time, and [turning an annual credit card summary into Excel](/blog/annual-credit-card-summary-to-excel) compares that one file with twelve statements.

## Multi currency edge case: one balance check per currency

The balance check on a multi currency statement must run per currency: each section's opening balance plus its rows must equal that section's closing balance. A single check across currencies always fails, because a running balance only means something in one currency. Run one check per section and the gaps point to the missing rows.

In the sheet, a SUMIF on the currency column gives the net movement for each currency. Add that to the section's printed opening balance and compare with its printed closing balance. If the euro section matches and the pound section is 2.10 short, the conversion fee line is probably missing from your pound rows.

Two traps catch people here:

- **Pending card purchases** that appear in one currency section with a foreign amount but no final posted amount yet. They may not count toward the closing balance.
- **Summary boxes in a single currency.** Some statements show a total value of all balances in one currency at the top. That figure uses the bank's rate on the statement date and will not match your own home currency total. Do not use it as a check.

A statement in a single list with no section balances cannot be checked line by line. Check the closing balance per currency against the account's balance page in online banking instead.

## Multi currency statement pages and the conversion price

A multi currency statement is often longer than a single-currency one, because each currency section repeats a header, a summary and its own balance lines. That length sets the price on a per-document converter. At CheapBankConvert's early prices, up to 10 pages is $2.99, 11 to 40 pages is $5.99, and 2 pages or fewer converts free.

The homepage describes the tool for text-based PDF statements from checking, savings and credit card accounts, and it returns a date, description, amount and balance for each row. It does not mention currency columns, so use the free preview of the first 2 pages to see how one section comes out. If the currency is shown only in a section header, plan to add the currency column yourself after converting, one block of rows at a time.

Some multi currency statements run long for a busy business account. Past 40 pages, the early prices list no tier, and [the guide to converting very long PDFs](/blog/pdf-to-excel-converter-online-500-pages) covers splitting a file at a sensible break, which for a sectioned statement is the start of a currency section.

Short single-currency statements behave differently. A store card statement, for example, is often a page or two, and [converting a store card statement to Excel](/blog/store-card-statement-to-excel) shows why those often fit a free preview. Whatever the statement, start from the bank's own PDF rather than a printout. For one US bank, [downloading PNC statements in online banking](/blog/download-pnc-statements) gives the steps, and the [CheapBankConvert homepage](/) has the price check for the file you end up with.