Schedule FA · how the numbers are made
What the tool does — in plain English.
Every figure in your workbook comes from one simple idea: convert each foreign amount to rupees using the SBI rate for its exact date. Here’s the whole method, so you can check it — or do it by hand.
The rules
Understand the rules
Go deeper
Full walkthroughs, step by step
The short version
How to build Schedule FA from a US broker statement
The whole job, end to end. Every step below is expanded in the rest of this page — start here if you just need the shape of it.
Pick the calendar year
Schedule FA runs on the calendar year, so AY 2026-27 means 1 January to 31 December 2025. Everything below is scoped to that window.
Download every statement covering that year
From Charles Schwab, the monthly or quarterly PDF statements for the account. From Interactive Brokers, the annual Activity statement as CSV. From Morgan Stanley, the quarterly and annual StockPlan Connect statements plus the Shareworks activity reports. From E*TRADE, the Employee Stock Plan release and purchase confirmations plus the benefit portfolio spreadsheet. From Fidelity, the Year-End Investment Report and the Stock Plan Services reports for the year, as PDFs. Every month of the year needs to be covered by at least one statement.
Add the statement from the year each older holding was bought
A lot still held but bought in an earlier year takes its acquisition date and cost from that earlier year's statement — the current year's statement only shows what it is worth now, not what it cost.
Upload the statements
Drop the PDFs and CSVs in as-is — no renaming, no conversion. They are uploaded to our server so your filing can be prepared from them.
Every figure is traced to its source
Each rupee figure carries the SBI TT-buying rate date and the statement line it came from, so the CSV is a check rather than a guess. Anything that cannot be sourced is flagged, never estimated.
Receive the CSV and file
The Schedule FA CSV carries the Table A2 cash-account row, one Table A3 row per purchase lot, and the dividend working — ready to transfer into Schedule FA in ITR-2 or ITR-3.
Before you start
How to get your statement
Charles Schwab (PDF), Interactive Brokers (CSV), Morgan Stanley Shareworks (PDF & spreadsheet), E*TRADE (PDF & spreadsheet) and Fidelity NetBenefits (PDF) drop straight in — you never convert, rename or re-key anything. Full walkthroughs: Charles Schwab · Interactive Brokers · Morgan Stanley Shareworks · E*TRADE · Fidelity NetBenefits.
Charles Schwab (PDF)
- From schwab.com, go to Accounts → Statements & Tax Forms.
- Use the account dropdown to check both Equity Award Center (RSUs) and your Individual brokerage account — they’re the same login, not separate sites, and each needs its own statements if you have both.
- Download each monthly or quarterly PDF statement that falls in the calendar year you’re filing, through 31 December, for every account view you use, plus the Year-End Summary if one was issued.
- If you’ve already exported an Equity Award Center Transaction History for the year, include it too — it can fill in vest and sale detail the statements alone don’t show.
- Drop the PDFs in as-is — no conversion needed.
Interactive Brokers (CSV)
- In IBKR Client Portal, go to Performance & Reports → Statements, then click the Run arrow next to Activity.
- Set Period → Annually and pick the calendar year you’re filing.
- Set Format → CSV (not PDF or HTML) and click Download.
- IBKR only keeps 5 previous years of statements — if you still hold a lot bought earlier than that, request that year’s statement from IBKR directly rather than estimating it.
Morgan Stanley Shareworks
- From stockplanconnect.morganstanley.com, or the Shareworks portal your employer uses, open the Documents area for your stock-plan account.
- Download each quarterly statement and the annual summary that fall in the calendar year you’re filing, through 31 December.
- If your plan runs on Shareworks, also export the releases, ESPP purchase and transactions reports as spreadsheets — they carry the vest and purchase detail the statements only summarise.
- Upload the PDFs and spreadsheets exactly as they downloaded — no conversion or renaming needed.
E*TRADE
- From us.etrade.com, go to At Work, then My Account and Documents, for your employee stock-plan account.
- Download each Employee Stock Plan release confirmation and ESPP purchase confirmation dated in the calendar year you’re filing, as PDFs.
- Export the benefit portfolio spreadsheet — the one with the ESPP and Restricted Stock tabs — so every held lot is covered.
- Upload the PDFs and the spreadsheet exactly as they downloaded — no conversion or renaming needed.
Fidelity NetBenefits
- From netbenefits.fidelity.com, open Stock Plan Services, then Documents, for your stock-plan account.
- Download the Year-End Investment Report and any Stock Plan Services report covering the calendar year you’re filing, as PDFs.
- Make sure the reports span 1 January to 31 December of the year you’re filing, so every held lot and sale is included.
- Upload the PDFs exactly as they downloaded — no conversion needed.
First
Two things everyone gets wrong
Calendar year
Schedule FA runs on the calendar year (1 Jan – 31 Dec), not the April–March financial year the rest of your ITR uses. “Schedule FA for AY 2026-27” means everything you held during calendar 2025.
One row per lot
You report one line per purchase, not per stock. Bought Apple 15 times? That’s 15 rows — each with its own purchase date and cost. Clubbing them hides the real acquisition dates.
The idea
Watch one lot become five numbers
Take a single purchase from your statement. Every rupee figure is that lot’s dollars × the SBI TT-buying rate on the relevant date. You can check any one of those rates yourself: look up the SBI TT-buying rate for a date — free, and it links to the SBI card the rate was published on.
Input · one purchase lot
8 Apr 2025 — bought 10 shares of AAPL at $172.40 · total cost $1,725
Also known about Apple in 2025: high of $259.02 on 26 Dec · price $255.60 on 31 Dec · a $0.26/share dividend on 15 May (you held all 10) · you didn’t sell.
Convert each with the TTBR for its date
column = native × ₹rate(date)
Result · one Table A3 row
USA · Apple Inc (AAPL) · acquired 08/04/2025 · initial ₹1,47,833 · peak ₹2,31,693 · closing ₹2,28,685 · credited ₹221 · proceeds —
Then repeat for every purchase lot. A second Apple buy on 21 Nov is its own row, with its own cost and only the dividends paid after 21 Nov.
Sales
If you sold some — first in, first out
Foreign shares sell FIFO: the oldest lot goes first. Say you own 25 NVDA (bought 15 Jan) and sell 5 on 3 Oct. The sale hits that lot, so it now shows:
Remaining
20 shares → drive the closing value
Proceeds
5 × $188.40 × ₹rate(3 Oct)
Initial & Peak
unchanged — still for all 25 while held
A lot sold entirely during the year still gets a row — closing ₹0, with its sale in proceeds.
The tricky bits
Two subtleties worth knowing
Peak is a daily maximum
The peak is in rupees, and both the price and the rate move daily. The highest ₹ value can land on a day the price was slightly below its high but the rupee was weaker. So it’s the max of price × that day’s rate across all ~250 days — which is why a tool helps.
The stock-split trap
Free price feeds often show split-adjusted history. If a stock split 4-for-1, its past prices are divided by 4 — so a naive peak comes out wrong. The fix: anchor the feed to your broker’s own 31-Dec close. This tool does it automatically.
Table A2
The account itself — just the cash
Table A3 is your securities. Table A2 is the broker account, and it wants the un-invested cash — not the securities again.
- Closing = the account’s ending cash on 31 Dec × 31-Dec rate.
- Peak = walk the ledger day by day (deposits + sales + dividends − buys − fees), track the highest ₹ the running balance hit.
- Credited = all dividends/interest, converted at the Rule 115 rate for the preceding month-end.
Watch out
Common mistakes
- Using the April–March financial year — Schedule FA is calendar year.
- Reporting the Jan-1 opening balance as a purchase — report lots at their real buy dates.
- One row per stock — it's one row per purchase lot.
- A single average FX rate for the year — each date gets its own TTBR.
- Putting securities into Table A2 — A2 is cash only.
- Guessing an old lot's date or cost — get the earlier year's statement, never estimate.
Last reviewed 27 July 2026 by GetScheduleFA · current for AY 2026-27.
That’s the whole method.
We do exactly this for every lot — per-date TTBR, daily-max peak, FIFO, dividend attribution, the cash account — and prepare your ready-to-file CSV. Do it by hand to verify; upload your statements and let us do it to save the ~250 multiplications per lot. See exactly what happens once you upload.
Get your Schedule FA prepared