Bank statements

Importing foreign currency lines from a bank statement (US)

Foreign currency lines confusing your importer? Keep the original amount and the dollar amount side by side, then check the implied rate, with a travel example.

Editorial illustration for Importing foreign currency lines from a bank statement (US)

A foreign currency line on a US statement carries two amounts: what the shop charged in its own currency and what your account was billed in dollars. Importers get confused when those two numbers share one column or when the original amount sits inside the description text. The fix is to store both amounts in separate columns and treat the dollar figure as the one that counts for your totals.

What does a foreign line look like on a statement?

Imagine a card statement after a week away. One line reads Hotel Lisboa, EUR 412.00, and the amount column shows $451.28. Another reads Metro tickets, EUR 18.50, with $20.26 in the amount column. The currency code sits in the description, and an importer reading only the description sees text, not money.

DateDescriptionOriginal amountOriginal currencyBilled in dollars
2026-05-03Hotel Lisboa412.00EUR-451.28
2026-05-04Metro tickets18.50EUR-20.26
2026-05-05Local pharmacy9.00GBP-11.70

How do I split the description from the money?

  1. Copy the statement lines into a sheet with one transaction per row.
  2. Add two columns: Original amount and Original currency.
  3. If the description contains a pattern such as EUR 412.00, use a formula to pull out the three-letter code, for example =MID(B2, SEARCH("EUR", B2), 3) when you already know the code, or type the code by hand for a short list.
  4. Type or paste the original amount into its column as a plain number.
  5. Keep the dollar column as the signed Amount that your importer reads.
  6. Add a Notes column if the statement shows a separate fee line, so you can match it to the purchase.

Is the implied rate worth checking?

Yes, because it catches typing mistakes. Divide the dollar amount by the original amount: 451.28 divided by 412.00 gives 1.0953. The metro line gives 20.26 divided by 18.50, which is 1.0951. Those agree, so both look correct. If a third line gave 1.9 for the same currency on the same day, you would know a number was keyed wrongly.

In a sheet, put =ABS(E2)/C2 beside each row and look for outliers. Small differences between lines are normal, because the rate can change from day to day and some lines include extra charges. A big jump is a clue.

What if the importer rejects the file because of the currency column?

Some tools want one currency per file or per account. Then choose one of two routes. Either keep only the dollar column and move the original details into the description, so nothing is lost, or split the file so that foreign lines go into their own import with a note. Do not delete the original amount: weeks later you will want to know what the hotel actually charged.

How do I report on foreign spending afterwards?

Sum the dollar column by original currency. With the sheet above, =SUMIFS($E$2:$E$200, $D$2:$D$200, "EUR") returns the dollars spent on euro-priced items. For the lines in the table, that is -451.28 + -20.26 = -471.54. This answers a practical question: how much of my trip was billed in each currency, without relying on a daily rate.

SpendixAI stores the original currency and a base-currency amount for each transaction, which is the same two-amounts idea built in. It is built around India and INR, so it is aimed at readers who also track Indian accounts; a US dollar reader can take the layout above as a pattern for any sheet or tool.

Checklist for any statement with foreign lines

  • Two amount columns: original and billed.
  • A three-letter currency code per line.
  • The billed amount used for totals.
  • Fee lines matched to their purchase.
  • A rate check column to spot typing errors.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports