During the July ITR filing rush in India, tech professionals holding US Restricted Stock Units (RSUs) or Employee Stock Purchase Plans (ESPPs) across multinational technology firms (Microsoft, Google, Amazon, Adobe) face one of the most punishing compliance audits under the Black Money (Undisclosed Foreign Income and Assets) and Imposition of Tax Act, 2015.
Section 42 and Section 43 of the Black Money Act impose a strict liability annual penalty of ₹10 Lakh for omitting or inaccurately reporting foreign assets under Schedule FA of ITR-2 or ITR-3—even if your foreign shares generated zero income and you have paid all taxes in full.
Why do traditional Excel VLOOKUP spreadsheets fail during Schedule FA audits?
1. The Preceding Month-End SBI TTBR Nuance (Income Tax Rule 115)
When converting foreign currency stock values into Indian Rupees (INR), you cannot use the vesting date exchange rate shown on your Form 16, nor can you use closing market rates from Yahoo Finance or RBI reference rates.
Under Income Tax Rule 115, capital assets acquired abroad must be converted to INR strictly using the Telegraphic Transfer Buying Rate (TTBR) issued by the State Bank of India (SBI) on the last day of the month immediately preceding the month of acquisition.
For example:
- If your Microsoft RSU vested on July 15, 2025, the acquisition rate must be the SBI TTBR on June 30, 2025.
- If your ESPP shares were purchased on November 14, 2025, the acquisition rate must be the SBI TTBR on October 31, 2025.
When brokers like Fidelity NetBenefits, Charles Schwab, E-Trade, or Morgan Stanley issue transaction histories involving split lots, sell-to-cover withholding taxes, and reinvested dividend fractional shares (0.412 shares), manually mapping historical SBI TTBR rates across 50+ vesting tranches takes hours of error-prone manual calculation.
2. Table A2 (Custodial Accounts) vs. Table A3 (Equity & Debt Interest)
A common defect notice triggered under AIS/26AS matching stems from clubbing every balance into Table A3.
- Table A3 (Foreign Equity and Debt Interest): Must contain your actual vested share holdings, including initial acquisition value (at preceding month-end SBI TTBR) and peak calendar-year valuation (at preceding month-end SBI TTBR).
- Table A2 (Foreign Depository / Custodial Accounts): If your offshore brokerage account holds any uninvested cash, dividend sweeps, or fractional share cash proceeds alongside your shares, that cash balance must be separately reported under Table A2.
3. The Calendar Year vs. Indian Financial Year Window
Schedule FA operates strictly on the Calendar Year (January 1 to December 31) for jurisdictions where the tax year aligns with the calendar year (such as the United States).
When filing your Assessment Year (AY) 2026-27 tax return, you must report holdings and transactions specifically from the January 1, 2025 to December 31, 2025 window. Including Q4 FY26 (January–March 2026) transactions inside this year's Schedule FA triggers instant cross-verification discrepancies against AIS data.
⚡ The Automated Architecture: 60-Second Lot-Wise CSV Parsing
To eliminate hours of manual spreadsheet math and guarantee exact Rule 115 compliance before the July 31st deadline, we built the ITRFA Schedule FA Lot-Wise Automated Conversion Engine.
Core Capabilities:
- Direct CSV Parsing: Supports raw transaction exports directly from Fidelity NetBenefits, Charles Schwab, E-Trade, and Morgan Stanley.
- Hardcoded SBI TTBR Database: Automatically matches every single acquisition lot, sale, and dividend receipt to the exact State Bank of India Telegraphic Transfer Buying Rate on the last day of the preceding month (2018–2026 database hardcoded).
- Automated Table A2 / A3 Segregation: Automatically separates custodial cash sweeps into Table A2 and calculates exact peak calendar-year valuations across Table A3 without manual intervention.
- 100% Client-Side / Local Processing Privacy: Designed with zero PII retention so practitioners and tech employees can verify multi-year vesting histories securely.
Test your raw broker CSV exports in seconds and generate audit-ready Schedule FA disclosures before July 31st at:
👉 https://itrfa.in - The Schedule FA Lot-Wise Rule 115 Automation Engine
Top comments (0)