For each foreign income entry, record the amount in the foreign currency, the rupee amount your bank actually credited, and the source and date of any exchange rate you note for reference. Which rate is the right one to use for a particular purpose is the CA's call, and it depends on rules that change. Your job is to save the facts that let them apply whichever rate they choose.
Why not just pick a rate and use it?
Because several different rates can exist for the same day: the bank's own conversion rate, a published reference rate, the rate on a card statement, a mid-market rate on a website. They differ, sometimes noticeably, and a rule or practice may call for a specific one. If you quietly choose one and write it down as the answer, you may have to redo the work. Record the facts that do not depend on that choice.
What facts should I record for each entry?
- The date the money was paid by the foreign payer.
- The foreign amount and the currency.
- The date and rupee amount that credited to your Indian account, from the bank statement.
- The charges deducted, if the bank shows them.
- The remittance advice or credit advice that shows the conversion.
- Any rate you looked up, with its source and the date you looked it up.
What does a rate log look like?
Here is a made-up example. The figures are only to show the arithmetic.
| Date | Foreign amount | Rupee credit | Implied rate | Source of any rate note |
|---|---|---|---|---|
| 5 June | 3,000 | ₹2,38,500 | 79.50 | Bank credit advice |
| 5 July | 3,000 | ₹2,40,300 | 80.10 | Bank credit advice |
| 5 August | 3,000 | ₹2,41,500 | 80.50 | Bank credit advice |
The implied rate is simply the rupee credit divided by the foreign amount. In a spreadsheet, if the foreign amount is in column B and the rupee credit is in column C, the formula in D2 is =C2/B2. For the first row, ₹2,38,500 divided by 3,000 is 79.50. This implied rate includes any bank margin and charges, so it is not the same as a published rate for the day; label it as implied, not official.
Should I also note a reference rate?
You may, as a convenience, if you write down exactly where it came from and when. For example: "Reference rate noted on 6 June from the central bank's published page, for information only." That lets the CA see what you saw and decide whether to use it. If you are not sure which source to use, leave the cell blank and ask. A missing rate costs nothing; a wrong rate with no source costs the CA's time.
Where does an expense tracker fit in?
For spending, a tracker can handle the arithmetic. In SpendixAI, each expense can be in its own currency, and totals come out in a base currency using the rate saved with each transaction. That suits day-to-day spending records. It is not a tax computation, and the rate saved there is a tracking figure, so use your CA's instructions for income entries, and keep the log above for them.
A small routine to follow
- On the day money arrives, save the foreign payer's advice and the bank's credit entry together.
- Add a row to the log with the facts above.
- Note a reference rate only if you can name the source.
- At each year end, send the log to your CA with the supporting papers.
- Ask whether they want a different layout for next year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


