Cards and UPI

Tracking international transactions on your credit card

How to track international transactions on your credit card: tag foreign-currency lines, keep the original amount and gather the extra charges.

Editorial illustration for Tracking international transactions on your credit card

To track international transactions, mark every foreign-currency line on your card statement, keep the original amount and currency alongside the rupee charge, and put any extra charges in their own category. Then a single report shows what overseas spending really cost in rupees.

Which transactions count as international?

Spending abroad is the obvious case. Many online purchases also count, when the merchant is based or processed in another country, even if you pay from home. Statements often show a foreign currency code or a country code, but layouts differ, so check how yours marks them.

What should I record for each one?

FieldExample (made up)Why it matters
Date14 MarchRates change by day
MerchantHotel in SingaporeFor your categories
Original amount and currencySGD 220Lets you check the rate later
Rupees charged₹13,910What actually left your account
Extra charge lines₹250 forex feeThe real cost beyond the purchase
TagForeignSo you can filter later

How do I set it up?

  1. Add a tag or column called Foreign, and mark every international line, including online ones billed in another currency.
  2. Keep the original amount and currency in two columns, not in the notes, so they can be summed.
  3. Enter the rupee amount as shown on the statement, not an amount you worked out from a rate.
  4. Create a category called Forex charges and put any mark-up or fee lines there. That keeps them out of the category of the purchase.
  5. At month end, filter by the Foreign tag and total the rupees, then total the Forex charges.

What about the exchange rate?

The card issuer decides the rate that converts the foreign amount, and it can differ from the rate you see on a search engine on the same day. You do not have to work it out for each line. The rupee figure on the statement is what you actually paid. If you want to know the effective rate, divide the rupees charged by the foreign amount. For SGD 220 and ₹13,910 that is about ₹63.23 per dollar, a figure you can compare across lines.

How does SpendixAI handle foreign-currency spending?

Each expense can be in its own currency, and totals are shown in your base currency using the rate saved with each transaction. Choose the base currency before importing, since it cannot be changed once transactions exist. A Foreign-currency spend report collects those lines in one place, and you can add a category for the extra charges.

Do this review before you travel as well as after. Last year's foreign lines tell you which cards and merchants to expect on the next statement.

What should I do about subscriptions billed abroad?

A subscription billed in a foreign currency is a regular international transaction, month after month. List each one with its original amount, the rupees charged and the date it renews. Because the rate changes, the rupee amount may differ slightly each month. Over a year, the total of such a subscription is a better figure than any single month, and the forex charge on each renewal adds to it.

It is worth checking at renewal whether the charge is the same foreign amount, since prices in the original currency can also change, and the rupee increase may not be down to the rate alone.

A monthly review

  • Count the foreign lines and add up the rupees.
  • Add up the separate fee lines and see what share of the total they are.
  • Check each foreign line has its original amount.
  • Compare the effective rate across the month, and look at any that stand out.
SPENDIXAI JOURNAL

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

Explore your reports