Capital Gains Compiler

This tool reads messy broker, demat and mutual-fund statements and compiles them into an ITR-shaped capital-gains working: a Schedule CG summary, a scrip-wise Schedule 112A, an AIS reconciliation, and a one-page review memo. It is built on one principle — the AI only reads; the tax arithmetic is done in fixed code. No figure on screen is a language-model guess.

Section 1What it does, and what it doesn't

The workflow is a pipeline with reviewable stops at every stage: extract → review → compute → reconcile → render.

• Extract — the agent reads a pasted or uploaded statement and proposes a structured transaction ledger.
• Review — you correct anything in an editable table. This is the control point; you sign off, not the AI.
• Compute — fixed code classifies each row, applies grandfathering, and computes the tax.
• Reconcile (optional) — match the ledger against AIS/TIS to catch omissions.
• Render — a Schedule-CG-shaped output and a printable review memo.

Section 2Before you start

Have these ready (any combination — the tool accepts partial inputs and flags gaps):

• A broker capital-gains report, demat sale statement, or trade book (Zerodha, Groww, ICICI Direct, Kotak, etc.).
• Mutual-fund capital-gain statements (CAMS / KFintech).
• Optionally, the AIS or TIS "Sale of securities and units of mutual fund" extract, for reconciliation.
• Knowledge of which sales were STT-paid (on-exchange delivery) versus off-market, and any corporate actions (bonus, split, merger) that affect cost and ISIN.
• For equity bought before 01-Feb-2018: the per-unit Fair Market Value as on 31-Jan-2018 (the highest quoted price that day), for grandfathering.

Section 3Step 1 — Source intake

1. Enter the Client name and PAN at the top (used only on the review-memo PDF).
2. Paste the statement text into the box, or Upload a .csv / .xlsx — spreadsheets are read and converted to text automatically.
3. Click Extract transactions. The agent profiles the source and returns one row per disposal, parsing Indian date formats and stripping commas. It does not compute tax.

Prefer to skip the AI entirely? Go straight to the ledger and use + Add row for fully manual entry. The tool then works as a pure calculator.

Section 4Step 2 — Review the ledger

Every cell is editable. Reconcile each row against your source and AIS/TIS before compiling. Field guide:

When the ledger is correct, click Compile.

Section 5Step 3 — The compilation

The output mirrors the ITR:

• Schedule CG summary — short-term (111A, slab) and long-term (112A with the ₹1,25,000 exemption, 112), each tagged with the ITR line reference (A3, A5, B4, B1/B2).
• Schedule 112A — the scrip-wise long-term equity table the ITR demands, showing actual cost, 31-Jan-2018 FMV, and the grandfathered cost of acquisition (marked with *).
• Business income — intraday and F&O shown in a separate amber block; they are not capital gains and are excluded from the 111A/112A tax.
• Tax on capital gains — by section, plus cess and (optional) surcharge, with a total.
• Exception & review memo — every gap and divergence the tool found.

Confirmed vs provisional

If any row has a hole (missing date, cost, sale value, or unresolved type), the summary shows provisional totals up top and confirmed totals (resolved rows only) beneath. Resolve the flagged rows to make them equal.

Advanced selectors

STCG (slab) marginal rate — slab-rate short-term gains are added to total income, not taxed at a flat rate. Leave as "Add to total income" or pick a rate for an indicative estimate.
Surcharge — depends on total income; capped at 15% for 111A/112A/112. Set it if it applies.

Section 6AIS reconciliation (optional)

1. Populate the ledger first (extract or manual).
2. Paste or upload the AIS / TIS securities-sale extract in the reconciliation box.
3. Click Reconcile with AIS.

The agent reads the AIS; fixed code then aggregates both sides by ISIN (AIS reports one line per security, your ledger is lot-wise) and compares. The flags:

Section 7The review memo (PDF)

After compiling, click Generate review memo (PDF). You get a one-page, RMA-letterhead document carrying the client/PAN/AY block, the section-wise computation and tax, any business income, the AIS reconciliation verdict with the actual omissions and mismatches listed, and the full exception list. The file is named with the client's name, e.g. CapitalGains_ReviewMemo_T_Sreedhar_AY2026-27.pdf.

Section 8Exports

• Schedule 112A (CSV) — scrip-wise long-term equity with grandfathering columns. Map these to the current e-filing portal's 112A upload template (column order changes year to year).
• Full working (CSV) — every row with classification, recomputed vs source gain, mismatch, and issues, plus provisional and confirmed summary blocks. This is your audit trail.
• AIS reconciliation (CSV) — the four-way comparison with totals.
• Print / Save PDF — prints the on-screen compilation.

Section 9Classification rules reference

For AY 2026-27 the full year falls on/after 23-Jul-2024, so one rate set applies throughout. How each asset type is treated:

* LTCG u/s 112A is taxed at 12.5% only on the amount above the ₹1,25,000 annual exemption. Equity sold without STT moves to slab / 112. Grandfathering (cost stepped up to the 31-Jan-2018 FMV, capped at sale value) applies only to STT-paid equity acquired before 01-Feb-2018. Health & Education cess of 4% applies on the tax. Section 87A rebate is not available against these special-rate gains.

Section 10Cautions & what it does not do

Section 11Troubleshooting