To track a foreign card statement properly, record each charge in two columns: the original USD amount and the rupee amount actually billed. Divide the second by the first to get the effective rate for that charge. The rate varies by transaction, so keep it per row and never apply one rate to the whole month.
Why do the INR amounts differ for the same dollars?
The rupee figure is fixed on the day the charge is converted, which may be later than the day you made the purchase. Card networks and banks apply their own rates, and a markup or fee may appear in the amount or as a separate row. Look at your own statement and card terms rather than assuming any figure.
A worked example with made-up numbers
| Charge | USD | INR billed | Effective rate |
|---|---|---|---|
| Software tool | 45.00 | 3,870 | 86.00 |
| Online course | 120.00 | 10,320 | 86.00 |
| Travel booking | 60.00 | 5,250 | 87.50 |
| Total | 225.00 | 19,440 | 86.40 |
The dollar total is 45 plus 120 plus 60, which is 225. The rupee total is 3,870 plus 10,320 plus 5,250, which is 19,440. The overall effective rate is 19,440 divided by 225, which is 86.40. Notice that the third charge cost more per dollar (5,250 divided by 60 is 87.50), which is why a single monthly rate would misstate it.
How do you set it up in a sheet?
Put the date in A, description in B, USD in C, INR billed in D. Then:
- Effective rate per row: =D2/C2
- Total USD: =SUM($C$2:$C$200)
- Total INR: =SUM($D$2:$D$200)
- Overall effective rate: =SUM($D$2:$D$200)/SUM($C$2:$C$200)
Add a column for a fee row if your statement lists foreign-transaction fees separately, and mark it so you can total fees on their own.
What should you check each month?
- Does every USD charge have a matching INR charge?
- Are fees shown as separate rows or hidden in the rate?
- Did any charge post on a date different from the purchase date?
- Are there refunds in USD whose rupee value differs from the original charge?
- Do the rupee totals match your statement total?
How do you handle refunds and reversals?
A refund in dollars comes back converted at the rate on the day it is processed, so the rupee amount can differ from what you originally paid. Record it as a negative row with its own USD and INR figures, rather than deleting the original charge. If a hotel puts a hold on your card and later releases it, the hold may show as a charge and a reversal; match the two so they cancel out, and keep only the final settled amount in your totals. Check that the effective rate on a refund is not wildly different from the original, because that points to a typing error.
Which base currency should you use?
Pick the currency in which you think about your budget, usually rupees if you live in India, and use it consistently. Converting some months in one currency and others in another makes comparisons meaningless.
What does SpendixAI offer?
In SpendixAI each expense can be in its own currency, and totals are shown in a base currency using the rate saved with each transaction. You choose the base currency before importing, and it cannot be changed once transactions exist. There is also a Foreign-currency spend report. Because statement layouts differ, review the imported rows before saving, especially for the currency and the amount.
A quick end of month routine
- Import or enter every foreign charge with currency and rupee figure.
- Check the effective rates for outliers.
- Total fees separately.
- Compare the INR total with the statement.
- Note any refunds still pending.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


