Tables A2 and A3
The custodial account row and one row per security held at any time in the year.
Calendar year 2025 · ready for AY 2026-27
Schedule FA reports from your IBKR statement
Turn an Interactive Brokers Flex statement into Tables A2 and A3 for the Indian ITR — with SBI TT buying-rate conversion, the exact peak value, and an audit trail behind every figure.
Runs entirely in your browser
Free, no sign-up
Calendar-year basis, enforced
HTML · PDF · CSV · JSON
What it handles for you
The fiddly parts of Schedule FA — the ones people most often get wrong.
SBI TTBR conversion
Every figure converted at the TT buying rate, falling back to the preceding published day.
Exact peak value
Daily holdings × daily price × that day's rate, maximised in rupees — not just year-end.
Audit trail
Source amount, rate applied and exact rate date behind every rupee figure.
How it works
Four steps, about ten minutes the first time.
1
Export from IBKR
Create an Activity Flex Query in XML for the calendar year and download it.
2
Drop the file in
Parsed in your browser. Your holdings and account number never reach a server.
3
Confirm the details
Holdings are matched by ISIN and currency-checked; add issuer addresses.
4
Download
Printable report, CSV for the ITR utility, or JSON — each with the audit trail.
Generate your report
Nothing is uploaded. Only ticker symbols leave your browser, to fetch public rates and prices.
1
Your IBKR statement
How do I get the Flex Query XML from IBKR? (one-time setup, ~5 minutes)
- Log in to IBKR Client Portal → Performance & Reports → Flex Queries.
- Next to Activity Flex Query, click ＋. Name it e.g. ScheduleFA.
- Set Format: XML and Period: Last Calendar Year — Schedule FA uses the calendar year (Jan–Dec), not the April–March financial year.
- Enable: Account Information, Open Positions (Lot Details = Yes), Trades, Cash Transactions (including Dividends, Withholding Tax and Broker Interest), Corporate Actions, Financial Instrument Information.
- For cash in Table A2, also tick Cash Report and Net Asset Value (NAV) in Base. Without the second, the peak covers securities only — and the report will say so.
- Save, then Run ▶ → pick the year → Download the XML.
Drop your Flex Query XML here
or click to choose a file
1 Jan – 31 Dec. Schedule FA never uses the April–March year.
Frequently asked questions
Schedule FA, exchange rates, peak values and privacy.
What is Schedule FA?
Schedule FA (Foreign Assets) is the part of the Indian income tax return where a resident discloses foreign assets — including shares and ETFs held in a foreign broker account such as Interactive Brokers. It is reported on the calendar year (1 Jan – 31 Dec), not the April–March financial year, which is the single most common mistake.
Which exchange rate is used to convert to INR?
The SBI TT buying rate (TTBR) for the relevant valuation date. If no rate was published that day — a weekend, holiday or gap in the data — the nearest preceding published day is used. The report shows the source amount, the rate applied and the exact rate date behind every figure, so each number can be checked.
How is the peak value calculated?
With daily prices available, the tool reconstructs your daily share count from your trades, values it against each day's closing price and that day's TTBR, and takes the maximum in rupees. Maximising in rupees matters: the currency moves independently of the share price, so the peak in INR often falls on a different date than the peak in dollars. Without daily prices it falls back to an approximate peak from trade dates and the year-end close, and marks the figure as approximate.
Does it include cash held in the account?
Yes, if your Flex query includes the Cash Report and NAV in Base sections. Cash is then added to the closing balance, and the peak balance becomes IBKR's true daily maximum account value — a balance that actually existed on a real date, rather than a sum of per-security highs that never occurred at the same moment. Interest credited to the account counts as income; deposits and withdrawals do not, since that is your own capital moving. If those sections are missing, the report says so plainly.
Is my brokerage statement uploaded anywhere?
No. The statement is parsed and every figure computed inside your browser. Only ticker symbols are sent to the server, to fetch public exchange rates and share prices. Your holdings, account number and address are never transmitted or stored.
What do I get out?
Table A2 (the custodial account) and Table A3 (one row per security held at any time in the year), with initial, peak, closing, dividend and sale-proceeds values in INR. Download as a printable report (Print → Save as PDF), a CSV for transcribing into the ITR utility, or Markdown and JSON. Rows with missing data are flagged for manual review rather than guessed.
Is this tax advice?
No. The output is a working draft to verify — ideally with a chartered accountant — before filing. You remain responsible for what you file.