Use the rate that actually turned the foreign amount into rupees on your own statement, charge by charge, and apply the same rule all year. A rate you looked up on a search engine is a guess; the rupee figure your bank or card debited, or credited, is a record. For a gig worker paying for a design tool in dollars or being paid by an overseas client, that one habit settles most of the confusion.
Why the statement rate beats the headline rate
When a foreign charge lands on a card, the rupee amount includes the rate the card network and your bank applied on that day, and often a markup. When a foreign client pays you, the credit that reaches your account is what the intermediary or bank converted to. Neither matches the rate you saw on a news site that morning. Since your cash flow is what you are trying to understand, the rupees that really moved are the honest number.
Your statement does not always print the rate. Divide the rupee debit by the foreign amount and you have the effective rate for that one transaction. Keep it in a column beside the entry.
A worked example with made-up numbers
Say a freelance video editor has three foreign items in a month.
| Item | Foreign amount | Rupees on statement | Effective rate |
|---|---|---|---|
| Editing software subscription | $12 | ₹1,020 | ₹85.00 per $1 |
| Stock footage pack | $40 | ₹3,380 | ₹84.50 per $1 |
| Client payment received | $150 | ₹12,600 | ₹84.00 per $1 |
Expenses in rupees: ₹1,020 + ₹3,380 = ₹4,400. Income in rupees: ₹12,600. Net from this foreign work: ₹12,600 - ₹4,400 = ₹8,200. Notice the three rates differ slightly. That is normal, because each conversion happened on a different day or through a different route. Do not average them or replace them with one neat rate.
What if the statement only shows the foreign amount?
Some statements list the foreign amount in one column and the rupee debit in another; some show only one of the two on the line. If the rupee figure is missing, check the next page or the card's billing summary for the converted amount. If you still cannot find it, note the date, record the foreign amount, and enter the rupee amount as soon as the bill arrives instead of estimating it from memory.
- Record the foreign amount and currency exactly as charged.
- Record the rupee amount your account was debited or credited.
- Divide rupees by the foreign amount to get the effective rate.
- Write the date of the charge, not the date you reviewed it.
- Keep the receipt or invoice with the entry.
Which rate should I use if I am just estimating a budget?
For planning ahead, a single round rate is fine, as long as you label it as an assumption. Pick a rate a little worse than today's for your side of the trade: for a dollar expense, assume you will pay a bit more rupees; for dollar income, assume you will receive a bit fewer. Then record real rates as the transactions happen and compare. If your plan said ₹86 and the actual rates ran ₹84 to ₹85, you will see where the plan was cautious on income and loose on costs.
Can an expense tracker keep the rate for me?
If you track in a sheet, add three columns: foreign amount, rupee amount and a formula such as =C2/B2 for the effective rate. If you would rather not maintain that yourself, SpendixAI lets each expense carry its own currency and totals everything 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, so pick rupees if rupees are what you live on.
A short checklist before month end
- Every foreign charge has a rupee figure beside it.
- The rate was worked out from your own statement, not copied from a website.
- Foreign income and foreign costs are in separate lines so you can see the net.
- Refunds in foreign currency are recorded at the rate the refund arrived, which may differ from the original charge.
- You have one written rule, for example: use the statement rupee amount always.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


