Introducing INR Basis: Automated Foreign Capital Gains & Dividend Calculations for Indian Taxpayers
If you have filed taxes on foreign RSU income, you know how notoriously tedious and error-prone calculating capital gains can be. One needs to go over each sale transaction, make a note of the acquisition date, sale date, number of shares, sale prices, and then convert foreign currency values using the correct historical exchange rates. Doing the whole process manually often takes hours. Not to mention the easy-to-miss errors or typos that can creep in.
To automate this, I built INR Basis—a browser-based tool that reads PDFs of your transactions and statements and prepares a tax-ready Excel statement in less than 5 seconds.
Why INR Basis?
- Speed: Go from raw PDFs to a clean capital gains and foreign dividend income statement in seconds.
- Rule 115 Compliant FX Mapping: Automatically applies the SBI Telegraphic Transfer Buying Rate (TTBR) of the last day of the preceding month, as prescribed under Rule 115 of the Income Tax Rules. No need to manually look up FX rates.
- Multi-platform Support: Currently supports Morgan Stanley and Fidelity statements.
- Designed to be Verifiable: Generates a three-sheet Excel file. First sheet contains the SBI FX rates data, second contains capital gains calculations, and the third contains dividend income and tax withholding. The calculations use live Excel formulas so that you (or your CA) can verify every number.
- 100% Private and Secure by design: All the processing happens entirely in the browser. Your financial data never leaves your device.
Let me know how INR Basis works for you! Feel free to reach out with any questions or suggestions.
If you liked this article, would you consider treating me to a coffee? Even the smallest cup will brew my deepest gratitude. 🙏