The rate on your statement differs from the one a search shows because the card converts on its own processing date, uses its own rate source, adds a mark-up and sometimes charges a separate fee. You can see how much by dividing the total rupees charged by the foreign amount.
What causes the gap?
- Timing. The card converts when the transaction is processed, which can be a day or more after you paid, so the rate may have moved.
- Rate source. A search engine usually shows a mid-market rate. Cards use a rate from the card network, adjusted by the issuer.
- Mark-up. The issuer adds a percentage on top of the rate. It may be built into the rate or shown separately.
- Fees. Some cards show a forex fee as its own statement line.
- Rounding. Small, but it can matter on low-value purchases.
How do I work out my effective rate?
Divide the total rupees charged, including any separate fee line, by the foreign amount. Say EUR 50 shows up on the statement as ₹4,900 in total. Your effective rate is ₹4,900 ÷ 50 = ₹98.00 per euro.
How much of the gap is timing and how much is mark-up?
Say the search rate on the day you paid was ₹95.00, so the plain conversion is 50 × 95 = ₹4,750. Your card charged ₹4,900, which is ₹150 more, or about 3.16 percent (₹150 ÷ ₹4,750). Now suppose you look up the rate on the processing date and find ₹95.80. At that rate the plain conversion is 50 × 95.80 = ₹4,790.
| Piece | Calculation | Amount |
|---|---|---|
| Plain conversion on the payment day | 50 × 95.00 | ₹4,750 |
| Plain conversion on the processing day | 50 × 95.80 | ₹4,790 |
| Effect of timing | ₹4,790 − ₹4,750 | ₹40 |
| Mark-up and fees | ₹4,900 − ₹4,790 | ₹110 |
| Total gap | ₹40 + ₹110 | ₹150 |
Timing explains ₹40, or about 0.84 percent of ₹4,750. Mark-up and fees explain ₹110, about 2.30 percent of ₹4,790. All numbers are made up, and in real life the rate might move the other way, which would reduce the gap.
How do I do the same in a sheet?
- Put the foreign amount in B2, total rupees charged in C2.
- Effective rate in D2: =C2/B2
- Put your reference rate for the payment day in E2 and for the processing day in F2.
- Total gap in G2: =C2-B2*E2
- Timing effect in H2: =B2*(F2-E2)
- Mark-up and fees in I2: =C2-B2*F2
Keep a few of these worked lines from different trips. After a handful, you will know what a normal gap looks like for your card.
Why does the same card give a different effective rate on different days?
Because the underlying rate moves every day and the mark-up is applied on top. If your effective rate on one transaction is ₹98.00 and on another a week later ₹99.20, part of the change is the market moving and part may be a different mark-up structure on a different type of transaction, such as a cash withdrawal. To separate them, compute the gap against the reference rate for each day, not the raw effective rate. A steady gap with a moving rate means the mark-up is steady.
Is the difference something to worry about?
Not by itself. A gap is normal and part of how cards convert currency. It becomes useful when you compare cards or payment methods, or when one transaction's gap is far larger than the others. In that case, check the statement for a separate fee line or a charge you did not expect, and ask the issuer if it does not match your card's terms.
Keeping the foreign amount and the rupees charged side by side makes this easy. SpendixAI stores the rate with each foreign-currency transaction and has a Foreign-currency spend report, which is a convenient place to look for the outliers.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


