Foreign currency transactions and fees in a bank statement CSV
Published 19 October 2026 · by Tekiba
Short answer: On an account in your own currency, a purchase abroad arrives already converted: import the amount the bank charged, not one you work out from a rate. A foreign transaction fee may be its own line or inside that amount; if it is its own line, record it as a bank charge. Expect the rate not to match a converter's for the date on the statement. An account held in another currency is a separate account in your books, with its own file, and the accounting software has to be set up for it first.
What card networks, banks and payment services say about rates and fees is from their own pages; the steps in QuickBooks Online and Xero are from their help pages; the tax rules are the IRS's and HMRC's, all read on 19 October 2026.
What a foreign line looks like
A card or account in your home currency cannot hold euros or yen, so the bank converts each foreign payment and the statement shows the result. Some banks print the original amount and the rate in the description; some print nothing but a merchant name in another country. Either way, the amount column is in your currency, and that is the figure the balance moves by.
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-05-11 | HOTEL CANAL VIEW AMSTERDAM 200.00 EUR @ 1.1500 | -230.00 | 3,170.00 |
| 2026-05-11 | FOREIGN TRANSACTION FEE | -6.90 | 3,163.10 |
| 2026-05-14 | SOFTWARE SUBSCRIPTION SGD | -36.40 | 3,126.70 |
The fee: a line of its own, or inside the amount
Banks do this both ways, and a bank's own page may not say which it uses. Chase's guide to the fee puts it like this: “If you are charged this fee, you can usually find it listed on your credit card statement on the next billing cycle, either in the fees section or as a separate line item in your recent transactions.” Note the timing as well: a fee that arrives the next cycle is in next month's CSV, not beside the purchase.
- A line of its own: import it like any other line and categorise it as a bank charge or fee, not as part of the purchase. A bank rule on the fee's description does this every month.
- Inside the amount: leave the amount as it is. It is what you paid. If the statement prints the fee separately within the description and you want it visible, split the line in the accounting software into the purchase and the fee; the two parts must add up to the statement's figure.
Why the rate does not match a converter
The card network converts the payment, and the date it uses is not necessarily the date printed on your statement. Visa's exchange rate calculator explains: “As of April 2021, VisaNet introduced an enhancement to currency conversion by applying the foreign exchange rate available at the time of the authorization for purposes of clearing and settlement.” The same page adds what the bank may do on top: “Your bank may or may not use the rate indicated by this calculator to bill you and may impose additional fees for foreign transactions.”
So the rate you find for the posting date, multiplied by the foreign amount, will often miss the statement's figure by a little. Do not correct the CSV to your own sum. The statement's amount is the one the bank charged, and the closing balance depends on it.
One more case changes the line entirely. When a shop or cash machine abroad offers to charge you in your own currency, that is dynamic currency conversion, and the conversion is then the merchant's, not the network's. Visa describes it: “if the merchant offers DCC (Dynamic Currency Conversion), you may receive the option to pay in your home currency, which includes exchange rate and additional fees.” On the statement such a line can look like a home purchase from a foreign merchant, with no separate fee; the cost is in the rate.
Accounts held in another currency
A US dollar account, a Wise balance or a PayPal balance in euros is a different matter: its statement is in that currency, and so is its CSV. It needs its own bank account in your books, in that currency, and its own file each month. Do not put two currencies in one file.
The accounting software has to know about the currency first.
- QuickBooks Online calls it multicurrency, and turning it on is a one-way decision. Intuit: “Once Multicurrency is on, you can no longer turn it off.” and “Once multicurrency is enabled, you can no longer change your home currency.” With it on, “If you have connected banks that use foreign currencies, you can add transactions in those currencies to QuickBooks Online.” Its rate is written the other way round from many banks': “In QuickBooks, the exchange rate is the number of home currency units it takes to get to 1 foreign currency unit.” Talk to your accountant before switching it on.
- Xero needs the right plan: “You need a trial organisation or a pricing plan with multicurrency (Xero website) to add a foreign currency.”
Where the software asks for both the foreign amount and a rate on a transaction, Intuit's advice is to use the bank's figures: “In the currency fields, enter the foreign amount or the exchange rate your bank provides.”
Payment services add conversions of their own. PayPal's rate “includes a currency conversion spread applied and retained by us on a base exchange rate to form the rate applicable to your conversion.”, and its transaction codes list a conversion as a transaction type of its own, “General currency conversion”. PayPal, Stripe and Wise statements to CSV covers how their files show fees, conversions between balances and payouts.
A statement with two amount columns
Some statements print the foreign amount and the converted amount side by side. A bank CSV for import needs one of them: the one in the account's currency, the one the balance moves by. Keep the other as text in the description, or in a column of your own in a working copy, and leave it out of the file you import; an importer that takes the foreign column as the amount writes a wrong figure on every foreign line. The balance check shows which is which: only the account-currency column adds up from the opening to the closing balance.
Converting for tax
A line on a home-currency account is already in your currency. For items that are not, the tax agencies set the rule. The IRS: “You must express the amounts you report on your U.S. tax return in U.S. dollars.” and “Use the exchange rate prevailing when you receive, pay, or accrue the item.” HMRC allows a monthly figure in the business's accounts: “The business can use an average exchange rate provided that exchange rates do not fluctuate significantly in the relevant period.” It also accepts a bank's rate: “Equally they may use other exchange rates, such as an exchange rate quoted by their bank, or the monthly average rates published by HMRC for VAT purposes.” Which rate suits you, and how gains and losses on a foreign balance are treated, is a question for your accountant.
Where LedgerDrop fits
LedgerDrop reads statement PDFs in your browser and checks every row against the balances the statement prints; the statement is not uploaded. A figure printed with a currency symbol in front, such as €12.00, or with none is read as an amount; one printed with a three-letter code, such as 12.00 EUR or USD 12.00, is not. The CSV has one amount column and no currency column, so convert one currency's statement at a time. Where a statement prints two amounts, the balance check tells you whether the column that came through is the one that adds up. LedgerDrop Pro writes the column layouts QuickBooks Online, Xero and freee ask for. When a line looks wrong after import, how to check a converted bank statement CSV for errors covers the arithmetic.
Convert a statement → Every row, checked against the printed balances, free at any length; the CSV is free for files of up to 3 pages. LedgerDrop Pro is $39 once.
What this page cannot tell you
Which rate or fee your bank applies, which only its terms and its statements show; whether to turn on multicurrency, which changes your books for good; or how currency gains and losses are taxed where you are. Mastercard's and Australia's tax office's pages were not reachable when this page was written, so they are not quoted. Fee rates differ by card and country and are not covered.
Questions
Why doesn't the amount on my statement match the exchange rate for that day?
The network may convert at the rate available when the payment was authorised, not on the date the statement shows, and your bank may add a fee. Import the statement's amount; it is what you were charged.
Is the foreign transaction fee included in the purchase amount?
It depends on the bank. Some show it as a separate line, some in a fees section, and Chase notes it can arrive on the next billing cycle. If it is a line of its own, record it as a bank charge.
Can I import a foreign currency account into my accounting software?
Yes, as its own bank account in that currency, after the software is set up for it: multicurrency in QuickBooks Online, which cannot be turned off again, or a Xero plan with multicurrency. Use one file per currency.
Should I convert foreign amounts myself before importing?
Not on a home-currency account; the bank has done it. For an account held in another currency, import its own amounts and let the software or your accountant convert them under the rules that apply to you.