Getting started

Tracking a foreign trip when the card statement shows two currencies

A ten-day trip worked through: card lines with original currency and rupee amounts, cash in local currency, and the combined base-currency total.

Editorial illustration for Tracking a foreign trip when the card statement shows two currencies

When a card statement shows both the original currency and the rupee amount, import it into your tracker, check that each line kept both figures, add cash spending by hand in local currency, and your base-currency total will combine them. Here is a ten-day trip, with invented numbers, to show how the pieces fit together.

What does the trip look like?

Say you spend ten days abroad with a credit card and some cash. The card statement lists each purchase with the foreign amount and the rupee amount debited. You also withdraw cash and spend it on small things, with no statement to show for it.

SourceEntriesWhat the tracker needs
Card lines14Original amount and currency, rupee amount
Cash in local currency9Amount, currency, a rate you note
Rupee-only charges (forex fee, GST on fee)2Plain rupee amounts

How do I get the card lines in?

  1. Download the statement for the billing cycle that covers the trip, as PDF, CSV or Excel.
  2. Choose the credit card account in SpendixAI before importing, so every line keeps that account.
  3. Review the rows before saving, and look closely at a foreign line. You want the original currency and the rupee figure both visible.
  4. Fix categories: restaurants, transport, hotel, shopping.
  5. Check for a charge that appears twice, which happens if the trip spans two statements and you import overlapping periods.

Statement layouts differ, and not every layout will parse perfectly, so the review step is not optional. If a foreign line shows only a rupee amount, note the original amount from your receipt where you can.

How do I add the cash spending?

Cash has no statement, so enter it by hand. Several expenses can be added at once, which suits a day's worth of small purchases. For each, set the currency to the local one and enter the amount spent. A rate has to come from somewhere: use the rate on the receipt for your currency exchange, or work it out from what you paid. If you changed ₹40,000 into local currency and received 480 units, your rate is about ₹83.33 a unit, and a 60-unit purchase is around ₹5,000.

How do both land in the base total?

Each transaction is converted into the base currency using the rate saved with it. Say the card lines total ₹58,200 and the nine cash entries come to ₹9,800. The two rupee-only charges are ₹720 and ₹130. The trip's cost is ₹58,200 + ₹9,800 + ₹720 + ₹130 = ₹68,850. Because each line carries its own rate, that total will not move when the market does.

How do I see the whole trip together?

Use a consistent label so the trip is easy to pull out later. Keep a written list of the trip's first and last dates, and let category choices stay normal. SpendixAI has a foreign-currency spend report, which groups what you spent in other currencies, and the Report builder can filter by date, so you can look at the ten days alone.

One more point about timing: card statements close on a cycle, not a calendar month. A trip from the 24th to the 3rd may land on two statements, and the charges for the last days can arrive weeks later. Import both statements, and revisit the trip total after the second one arrives.

After you get home

  • Compare the card section of your total with the rupee total on the statement.
  • Check that the cash total in rupees is close to what you converted and did not spend elsewhere.
  • Look for refunds, such as a hotel deposit, that come back on a later statement and should net against the trip.
  • Attach receipts for any large expense, such as the hotel, to its transaction.
  • If the trip was for work, tell your CA which entries belong to it and keep the invoices handy.
SPENDIXAI JOURNAL

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

Explore your reports