How to Track Foreign Currency Credit Card Transactions

If you've traveled internationally, hired overseas contractors, or run ads on platforms that bill in foreign currencies, you've seen the problem: your credit card statement lists charges in multiple currencies, with exchange rates applied at different times, and sometimes two separate line items for a single transaction. This is especially tricky when you're managing multiple credit cards in Excel and need a unified view across domestic and international spending.

Tracking these expenses accurately — and reporting them correctly — is genuinely more complicated than domestic-only statements. Here's how to handle it.

How Foreign Currency Charges Appear on Statements

When you make a purchase in a foreign currency, most US card issuers handle it one of two ways:

Single converted line: The transaction appears in USD, with the original foreign currency amount sometimes listed in the description. Example: AIR FRANCE 12/15 $842.50 (EUR 775.00).

Two separate lines: Some issuers show the original foreign charge and then a separate foreign transaction fee line. Others break it into the purchase and a "foreign currency conversion" line. This can look like a duplicate if you're not paying attention.

Your statement may also show the exchange rate used, though this varies by issuer. Chase shows the original foreign amount in the description; American Express provides a separate foreign exchange rate field in its detailed statements.

Why This Complicates Your Spreadsheet

When you convert a PDF statement to a spreadsheet, foreign currency transactions need special handling:

1. Amount column may need cleanup. If the original currency amount is embedded in the description (e.g., "EUR 775.00"), you'll want to extract it into its own column for accurate multicurrency reporting.

2. Duplicate-looking lines. A foreign transaction fee that posts separately from the original charge will appear as a second line item. Without context, it looks like a duplicate transaction.

3. Different posting dates vs. transaction dates. International charges sometimes take longer to post. The exchange rate applied is based on the posting date, not when you swiped the card — which means the USD amount in your statement may differ slightly from what your bank app showed at the moment of purchase.

4. Annual exchange rate fluctuations. If you're tracking expenses over a year with regular foreign charges, the "same" recurring charge (say, a monthly subscription in EUR) will have a different USD value each month.

Setting Up Your Spreadsheet for Multi-Currency Statements

Add these columns to your raw data tab when you're dealing with international transactions:

Not every row will have original currency data — many statements only show the USD amount. Fill in what's available.

Extracting Foreign Currency Amounts from Descriptions

If your statement description includes the original foreign amount (like many Chase and Citi statements do), you can extract it with an Excel formula.

For descriptions formatted like MERCHANT NAME EUR 775.00:

=IFERROR(VALUE(MID(A2, FIND("EUR",A2)+4, 10)), "")

This extracts the number after "EUR ". You'd build similar formulas for other currencies you encounter (GBP, CAD, AUD, etc.).

It's not perfect — merchant names occasionally contain number strings that trigger false matches — but it gets you most of the way there without manual extraction.

Handling Foreign Transaction Fees

Most US cards charge a foreign transaction fee of 1-3% on international purchases (some premium travel cards waive this). The fee either appears as a separate line item or is included in the converted USD amount with no separate disclosure.

If it appears separately, look for lines like:

• "Foreign Transaction Fee"
• "International Transaction Fee"
• "Currency Conversion Fee"

These should be matched to their parent transaction and tracked together. For business expense reporting, the fee is typically included in the total cost of the purchase — not split out separately.

If the fee is embedded in the exchange rate (no separate line), the only way to know you paid it is to compare the exchange rate on your statement to the mid-market rate on that date. The difference is approximately your fee.

Reporting Foreign Expenses for Taxes

For US tax purposes, all income and expenses are reported in USD. If you incurred business expenses in foreign currencies, you need to use the USD amount that was actually charged to your card (or the IRS-approved exchange rate for the transaction date if you paid cash). Once you have the USD figures, categorizing those expenses for taxes follows the same process as domestic charges.

The USD amount on your credit card statement is the correct figure to use — it's what actually came out of your financial system. You don't need to do your own currency conversion if the statement shows the USD charge.

For IRS compliance on foreign business expenses, keep:

• The credit card statement showing the USD charge
• The original receipt showing the foreign currency amount
• A note of the business purpose

Tracking International Subscriptions

Subscriptions billed in foreign currencies are a specific headache. A software subscription at €29/month costs different USD amounts every month depending on the EUR/USD exchange rate.

For budget tracking purposes, use actual USD charges rather than a fixed converted amount. Your monthly totals will be slightly different each month even if the subscription price didn't change — and that's accurate, because your actual cost did vary.

If you're reporting to a finance team or trying to create a consistent budget line, note the foreign currency amount and the exchange rate range. Use an average rate for annual budget estimates.

Converting PDF Statements with Foreign Currency Charges

CreditCardToExcel handles statements from all major US issuers, including cards with foreign currency transactions. The conversion preserves the description field, which typically contains the original currency amount for issuers that include it.

After conversion, you'll have a clean spreadsheet where you can add the additional columns mentioned above and apply formulas to extract foreign currency data from descriptions. For the full step-by-step conversion process, see our credit card statement to Excel guide.

A Practical Note on Exchange Rate Tracking

Unless you're doing treasury management or detailed foreign expense reporting for a finance team, you don't need to track exchange rates transaction-by-transaction. Use the USD amounts from your statement — they're accurate, documented, and what actually hit your finances.

Tracking original currency amounts is useful for:

• Verifying you were charged the correct amount (is that EUR 775 what the airline quoted you?)
• Understanding whether a currency change affected a recurring subscription cost
• International expense reimbursement in local currency

For most individual and small business purposes, USD amounts are sufficient.

---

International transactions add a layer of complexity to statement tracking, but the core process is the same: get the data into a spreadsheet, add the columns you need, and work with structured data instead of PDFs.

More guides on working with credit card statements: CreditCardToExcel blog.