Bank statements

Month abroad on your card: importing foreign lines without a mess

A month abroad creates dozens of foreign currency lines. Learn to group them by trip, match fee lines, check rates and import them in Australian dollars.

Editorial illustration for Month abroad on your card: importing foreign lines without a mess

After a month overseas your statement may carry sixty or seventy foreign currency lines, some with separate fee lines beneath them. Importing them as a lump leaves you unable to say what the trip cost. Tag each line with the trip, keep the original amount and code, and treat any fee lines as their own rows linked by a note.

Start by tagging the trip, not the line

Add a Trip column and fill it for every foreign line, for example Japan May. Filtering on that tag later gives you the cost of the trip in one move, and it also separates travel from ordinary spending that happened to be abroad, such as the phone bill that kept running at home.

What does a typical foreign sequence look like?

DateDescriptionOriginalCodeA$ amountTrip
2026-05-06Ramen restaurant2,800JPY-30.24Japan
2026-05-06Foreign transaction feenonenone-0.91Japan
2026-05-07Rail pass counter15,000JPY-162.00Japan
2026-05-07Foreign transaction feenonenone-4.86Japan

Whether your statement shows separate fee lines at all depends on the card, so read your own statement and agreement rather than assuming. If yours does, record them as rows of their own, and put the purchase they belong to in the note so a later reader can see why a A$0.91 line exists.

Why do original amounts sometimes lack decimals?

Some currencies, such as the yen in the example, are normally written without decimals. Keep them as printed: 2,800 means two thousand eight hundred, with the comma as a thousands separator. Store it as 2800, a number, with no comma. A cell that holds 2,800 as text will not add up.

Does the implied rate make sense?

Divide the Australian dollar amount by the original: 30.24 divided by 2,800 is 0.0108, and 162.00 divided by 15,000 is also 0.0108. Because yen amounts are large, many people prefer to quote the rate per hundred: 1.08 dollars per 100 yen. Same rate, easier to read, and a quick way to see if one line is off.

  1. Add a Rate per 100 column for currencies with large numbers: =ABS(E2)/D2*100.
  2. Sort by code and then by date.
  3. Look down each group for a value that stands apart.
  4. Investigate that line: a wrong digit, a pending amount or a different currency code is the usual cause.

How do I total the trip?

Use a SUMIFS on the Trip column: =SUMIFS($E$2:$E$400, $F$2:$F$400, "Japan"). For the four lines in the table, that is -30.24 - 0.91 - 162.00 - 4.86 = -198.01. Add a second SUMIFS with the code as a condition to see how much was billed in each currency if you visited more than one country.

What if the importer rejects the whole file?

  • Check that the currency code column holds exactly three letters.
  • Make sure original amounts have no thousands separators or currency symbols.
  • Remove any blank rows between the purchase and its fee line.
  • If the tool cannot take an original currency, put it in the description, for example Ramen restaurant JPY 2800, and keep the A$ amount in the amount column.

SpendixAI stores the original currency and a base-currency amount for each transaction, and its foreign-currency spend report groups them; the base currency is set before importing and cannot change once transactions exist. It is built around India and INR, so it is relevant to readers who also track Indian accounts, and the Trip column idea above works in any sheet.

After you get home

  • Import only posted lines.
  • Tag the trip on every foreign row.
  • Match fee lines to purchases.
  • Check the rate per 100.
  • Total the trip and note the figure.
SPENDIXAI JOURNAL

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

Explore your reports