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.

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.

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)

Initial

$1,725 × ₹85.70 (8 Apr)

₹1,47,833

Peak

10 × $259.02 × ₹89.45 (26 Dec)

₹2,31,693

Closing

10 × $255.60 × ₹89.47 (31 Dec)

₹2,28,685

Credited

$2.60 × ₹85.10 (15 May)

₹221

Proceeds

not sold this year

—

↓

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, each at its own date’s rate.

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.

That’s the whole method.

The tool does exactly this for every lot — per-date TTBR, daily-max peak, FIFO, dividend attribution, the cash account — and writes the ready-to-file workbook. Do it by hand to verify; let the tool do it to save the ~250 multiplications per lot.

Build your Schedule FA →