Two currency amounts on a bank statement: which one belongs in totals?

Keep original-currency and account-currency amounts in different fields. For a balance check in the account’s currency, use the booked amount in that currency, not both numbers. A conversion rate is context, not another transaction.

Identify the booked amount before calculating totals

1. Identify the currency of the account and each printed amount. Copy currency codes rather than relying on symbols alone.

2. Create original amount/currency and booked amount/currency pairs. Retain a printed exchange rate separately without inventing a missing rate.

3. Inspect whether any fee is a separate movement or already included. Keep its source location and avoid adding it twice.

Fictional example

A fictional EUR account shows a purchase of USD 100.00, booked as a debit of EUR 92.50, plus a separate EUR 1.20 fee. The account-currency outflow is EUR 93.70. Adding 100.00 to that total mixes currencies. If the PDF instead states that 92.50 includes the fee, the extra 1.20 must not be invented.

Decide whether the fee is a row or an explanation

For the fictional purchase, start at EUR 500.00. If the statement has two booked debits, 92.50 and 1.20, the successive balances are 407.50 and 406.30. Keep two transaction rows, linking the fee to the purchase only when the source supports that relationship. The USD 100.00 remains an attribute of the purchase, not a third debit. If instead there is one debit of 93.70 with a note “including fee 1.20”, keep one booked row of 93.70. A fee-analysis field may contain 1.20, but exclude that field from the account-movement sum.

Mark three fee states: separately booked, included, or unresolved. An explanatory amount beneath a transaction is not proof of a second booking. Compare its date, position and any running balance with the PDF. When the statement is unclear, consult the bank’s transaction detail or native export if available; leave the classification unresolved if those sources do not settle it.

Check the direction of a rate without replacing the debit

In this example, 92.50 ÷ 100.00 = 0.925 EUR per USD before the separate fee. Including the fee gives 93.70 ÷ 100.00 = 0.937 EUR per USD, a different measure; neither is automatically a published bank rate. A printed USD-per-EUR rate would require division, not multiplication, to convert USD to EUR. Keep its units beside it. ABN AMRO’s transfer explanation distinguishes indicative and final rates and describes costs within a rate. That example does not establish every bank’s fee presentation.

Build a sheet whose totals use one currency

Use separate columns for the booked movement and its supporting details. In the fictional purchase, the following fields have different roles; putting them all in one Amount column destroys that distinction. The last table row is an alternative fee presentation, not an additional booking.

Printed information	Spreadsheet destination	Enters the EUR movement total?
Purchase USD 100.00	Original amount 100.00; original currency USD	No
Booked debit EUR 92.50	Account amount −92.50; account currency EUR	Yes
Separately booked fee EUR 1.20	Another account movement −1.20 EUR	Yes, once
Rate 0.925 EUR per USD	Rate value and units	No
Fee included in a single EUR 93.70 debit	Fee detail 1.20 beside account amount −93.70	Only the −93.70 movement

Keep the raw printed amount beside the signed account amount so you can verify the direction. Filter totals by account and account currency; an EUR account and a USD account need separate checks even when they appear in the same file. If the booked EUR amount is missing, leave it unknown and exclude the incomplete row from approved totals with an explicit exception. Consult transaction details rather than fill it from a market rate. The ECB describes its reference rates as informational and discourages their use for transactions.

A refund needs its own booked amount too. In a separate fictional case without fees, a USD 100.00 purchase debits EUR 92.50 and a USD 100.00 refund credits EUR 90.00. The USD amounts cancel, but the EUR net movement is −92.50 + 90.00 = −2.50. Preserve both bookings; do not force the refund to 92.50 or label the difference a separate bank fee without evidence.

Checks and limits

Check each currency independently and preserve the bank’s booked figure. A current market rate cannot repair a missing historical amount or establish the bank’s actual charge. If the layout leaves the fee treatment unclear, flag it before export. This is a data-mapping method, not an exchange-rate recommendation.

Related checks

Keep currency, amount and direction separate when normalizing values. Debit and credit columns to one signed amount: a bank CSV method · Minus signs and parentheses in bank amounts: normalize without reversal · Check a bank statement balance without hiding extraction errors.

BankStatementScan is in preparation. The site offers an access request and a fictional example; it does not currently convert your bank files. See the planned service.

Sources consulted on 16 October 2026

• ABN AMRO — Zakelijke buitenlandoverboeking.
• ECB — Euro foreign exchange reference rates.