For a record of what you actually spent, use the rupee amount your card statement billed, because that is the money that left your account. Use a daily market rate only when the statement amount is missing, and a fixed rate only for budgeting a trip in advance. Whichever you choose, write the choice down in the sheet.
What are the three options?
| Method | What you enter | Best for | Weak point |
|---|---|---|---|
| Billed INR amount | The rupee figure on the statement | Records, month totals, checking bills | Known only after the statement or alert |
| Daily market rate | A published rate for the transaction date, times foreign amount | Estimates before the bill arrives | Differs from what the card used |
| Fixed budgeting rate | One rate you choose for the whole plan | Trip budgets | Drifts from reality over time |
Why does the billed amount differ from the market rate?
Several things can sit between the market rate and your statement: the rate the bank or card network applied, the day the transaction was settled, and fees that may appear on their own line. Banks differ, so look at your own statement and card terms rather than assuming. A hypothetical example: you pay USD 1,200 for a hotel. A daily rate of ₹83.00 gives 1,200 x 83.00 = ₹99,600. The statement bills ₹1,00,560. The gap is ₹960, and the effective rate is 1,00,560 / 1,200 = ₹83.80 per dollar.
Which one should I choose for each job?
- Recording actual spending: the billed rupee amount, entered in its own column, with the foreign amount and currency kept for reference.
- Estimating this month's spend before statements arrive: a recent daily rate, clearly marked as an estimate.
- Planning a trip: a fixed rate you pick, perhaps slightly on the cautious side. A budget of USD 1,500 at a fixed ₹85 is ₹1,27,500.
- Comparing trips year to year: keep the original currency amounts, so a change in the exchange rate is not confused with a change in what you bought.
What happens to refunds and fees?
Refunds may be credited at a different rate from the original charge, so record the refund as the rupee credit that actually appears, not as a reversal of the earlier amount. If the statement shows a currency conversion or markup line separately, add it as its own row, for example in a Bank charges category, so you can see the cost of paying abroad over a year. Check the line against the card's terms if the total looks high.
Should the rate be the same for the whole month?
Not necessarily. A single monthly rate is easy but can misstate a month in which the rupee moved noticeably. If you must estimate, use the rate for each transaction date and keep the estimate in a separate column from the billed amount. When the statement arrives, replace the estimate with the real figure and keep the old one only if you want to see the difference.
How do I keep estimates and billed amounts together?
Use separate columns so nothing is overwritten. Put the foreign amount in C, the currency in D, the billed rupee amount in E (blank until the statement arrives), your estimate rate in F, and in G the rupee figure you use: =IF(ISNUMBER(E2),E2,C2*F2). While E2 is blank the sheet uses the estimate; the day you type the billed amount, it takes over. A count of rows with an empty E column tells you how many transactions are still estimated.
Checklist for each foreign transaction
- Record the foreign amount and currency exactly as on the receipt.
- Record the INR amount billed once the statement posts.
- Mark estimates until replaced.
- Add fee lines as separate rows.
- Keep the receipt or screenshot with the row.
SpendixAI saves a rate with each foreign transaction and totals in a base currency, so you can keep the billed amounts you enter and still view a Foreign-currency spend report. For tax or accounting treatment of foreign payments, ask your CA, since rules change.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


