Cards and UPI

Working out the forex mark-up you paid from your statement

Work out the forex mark-up you paid on a credit card statement: a formula, a worked example with made-up figures, and a spreadsheet version.

Editorial illustration for Working out the forex mark-up you paid from your statement

To estimate the forex mark-up you paid, compare the rupees charged with the foreign amount converted at a reference rate for the day. The mark-up percentage is (rupees charged ÷ (foreign amount × reference rate) − 1) × 100. It is an estimate, because the card's conversion date and rate source may differ from yours.

What is the formula in plain steps?

  1. Note the foreign amount and currency from the statement, for example USD 120.
  2. Pick a reference rate for the transaction date from one source, and use the same source every time.
  3. Multiply: foreign amount × reference rate. This is what the purchase would cost with no extra margin.
  4. Take the total rupees you were charged, including any separate fee line.
  5. Subtract step 3 from step 4 for the extra cost, then divide by step 3 and multiply by 100 for the percentage.

What does a worked example look like?

All figures here are made up for illustration. A card statement shows a purchase of USD 120. The reference rate you picked is ₹84.00 per dollar, so 120 × 84 = ₹10,080. The statement shows ₹10,200 for the purchase and a separate ₹250 forex fee, a total of ₹10,450.

ItemCalculationAmount
Reference value120 × 84.00₹10,080
Rate difference₹10,200 − ₹10,080₹120
Separate fee lineShown on statement₹250
Total extra cost₹120 + ₹250₹370
Mark-up percentage₹370 ÷ ₹10,080about 3.67%

You can split the 3.67 percent: ₹120 ÷ ₹10,080 is about 1.19 percent from the rate difference, and ₹250 ÷ ₹10,080 is about 2.48 percent from the fee. The implied rate on the purchase line is ₹10,200 ÷ 120 = ₹85.00 per dollar against the ₹84.00 reference.

How do I do it in a spreadsheet?

Put the foreign amount in B2, your reference rate in C2 and the total rupees charged in D2. Then:

  • Reference value in E2: =B2*C2
  • Extra cost in F2: =D2-E2
  • Mark-up percentage in G2: =F2/E2, formatted as a percentage

Why is my result only an estimate?

Several things can make your number differ from the real mark-up. The card may convert on the date the transaction is processed, which can be later than the purchase date. The rate source can differ from yours. Some statements do not break the fee out at all. A fair way to use the result is to compare across transactions, using the same reference source throughout.

What if the statement shows no separate fee?

Then the mark-up is inside the rate. Your total rupees divided by the foreign amount gives the implied rate. Compare it with your reference rate: if the implied rate is ₹85.50 against ₹84.00, the difference is ₹1.50 on ₹84.00, about 1.79 percent. In that case there is no fee line to add, and the percentage you get is the whole extra cost.

Do the calculation for three or four transactions, not one. If the percentages cluster, you have a fair picture of what the card typically costs. If one stands out, look at its date and details.

What should I do with the answer?

Use it to compare. If one card's percentage is consistently higher than another's, that is worth knowing before a trip. Check your card's terms for the stated charge, and check the figure against the statement lines. If a fee seems inconsistent with the stated terms, ask the issuer to explain it. Where the statement shows only a single rupee amount, divide by the foreign amount to find the effective rate and compare that with your reference rate.

If you keep foreign spending in SpendixAI, the rate saved with each transaction and the Foreign-currency spend report help gather the figures in one place. The mark-up calculation itself you would still do in a sheet.

SPENDIXAI JOURNAL

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

Explore your reports