Schedule 112A Generator: Broker P&L → ITR CSV
Upload your Zerodha Tax P&L (or any broker export via column mapping) and get back the scrip-wise CSV that the income-tax utility's Schedule 112A upload actually accepts — long-term equity rows only, grandfathering under Section 55(2)(ac) applied[Sec 55(2)(ac)], and your 12.5% LTCG estimated over the ₹1.25 lakh exemption[Sec 112A].
Your file never leaves this browser tab. Parsing and all calculations run entirely on your device using JavaScript — no upload, no server, no account. Close the tab and the data is gone.
Upload Your Trade File
Drag and drop your Excel file here, or click to browse
How the conversion works
The tool reads the tradewise exits sheet, keeps rows classified as long-term equity (held >12 months), and for each computes sale consideration, per-unit sale price, and the Section 55(2)(ac) cost of acquisition. Pre-Feb-2018 purchases use the grandfathering formula; if the export lacks an FMV, the row is flagged for manual entry instead of being exported with an understated cost. Totals apply the ₹1.25 lakh exemption and the 12.5% rate from the Finance (No. 2) Act 2024.
Worked example
You bought 50 shares of Reliance in May 2017 for ₹60,000 total and sold them this FY for ₹1,45,000. FMV on 31 Jan 2018 was ₹1,850/share → total FMV ₹92,500.
Grandfathered cost = higher of (₹60,000, lower of (₹92,500, ₹1,45,000)) = ₹92,500. Reported LTCG = ₹1,45,000 − ₹92,500 = ₹52,500 — not the ₹85,000 raw profit. That step-up is exactly what Schedule 112A's columns 8-11 capture, and what this tool fills in for you.
Frequently Asked Questions
What is Schedule 112A in the ITR?
Schedule 112A is where ITR-2 and ITR-3 require scrip-wise reporting of long-term capital gains on listed equity shares and equity mutual funds — every sale reported with ISIN, quantity, sale price, cost, and (for pre-Feb-2018 purchases) the fair market value on 31 January 2018. LTCG above ₹1.25 lakh is taxed at 12.5%.
How do I get Schedule 112A data from Zerodha?
Download the Tax P&L statement from Zerodha Console (Reports → Tax P&L) for the financial year as an Excel file, then upload it here. The tool reads the tradewise exits sheet, keeps only long-term equity rows, applies grandfathering, and generates the CSV in the ITR utility's column format.
Is my broker file uploaded to a server?
No. The file is parsed entirely inside your browser with JavaScript — the site has no upload endpoint for it and no data leaves your device. You can verify this in your browser's network tab: no network request carries your file.
What is grandfathering under Section 55(2)(ac)?
For equity bought before 1 February 2018, the cost of acquisition is stepped up to protect gains that accrued before LTCG tax was reintroduced: cost = higher of (actual cost, lower of (FMV on 31 January 2018, sale price)). Zerodha's export usually includes the FMV column; when it's missing, this tool asks you to enter the FMV rather than silently understating your cost.
Does this work with Groww or other broker exports?
Yes, via column mapping. If the file isn't recognised as a Zerodha tradewise Tax P&L, the tool shows a mapping screen where you match your broker's column names (ISIN, buy value, sell value, dates) and it proceeds from there. Any export with those columns works.
Can I upload the generated CSV directly into the ITR utility?
The CSV follows the ITR utility's Schedule 112A template columns (AY 2026-27). Import it via the utility's CSV upload option in Schedule 112A, then verify the totals on-screen against this tool's summary before submitting. Always cross-check — the utility's template can change mid-season.
What about short-term gains and intraday trades?
They don't belong in Schedule 112A. Short-term capital gains go in Schedule CG (taxed at 20% under Section 111A for equity), and intraday is business income. This tool deliberately filters them out; use the Capital Gains Calculator to see your full picture across categories.
Related tools & guides
Sources & References
Legal basis: Section 112A (LTCG at 12.5% over ₹1.25 lakh, Finance (No. 2) Act 2024) and Section 55(2)(ac) (grandfathering of equity acquired before 1 February 2018), Income Tax Act, 1961; Schedule 112A CSV format per the Income Tax Department ITR-2/ITR-3 utility.
Official sources
Last verified against official sources: July 2026. Figures are researched from the government sources above and checked before publishing. See our Editorial & Verification Policy.
This tool is for informational and educational purposes only. Verify the generated figures against your broker statement and the ITR utility's on-screen totals before filing. Estimates exclude cess and surcharge. This is not tax advice — consult a qualified tax professional for your specific situation.