CEComplyEaze Tools

tools.complyeaze.com

Schedule 112A Capital Gains CSV Builder

Turn pasted scrip-wise sale rows into a Schedule 112A field structure, with Section 55(2)(ac) grandfathering and the July 2024 rate-period split.

Files are processed in your browser.No account required.No file upload required.Draft output for professional review.Not affiliated with government portals.

Input format

Paste rows with scripName, isin, quantity, salePricePerUnit, saleDate, and costOfAcquisitionActual. Add fmv31Jan2018PerUnit together with acquisitionDate, purchaseDate, or acquiredBefore31Jan2018 when grandfathering should apply.

Expected columns: scripName, isin, quantity, salePricePerUnit, saleDate, costOfAcquisitionActual, acquisitionDate, purchaseDate, or acquiredBefore31Jan2018 when fmv31Jan2018PerUnit is used

This field stays in your browser. Use synthetic data while testing.

Input diagnostics

  • Rows accepted for draft: 2 of 2 parsed.

Draft output updated. Review it before downloading or sharing.

Source posture

What this creates

  • plain-text scrip-wise capital gains table
  • CSV-style field export for reuse
  • grandfathering review checklist

Downloaded draft includes

  • generated timestamp, local artifact ID, tool page, and package version
  • expected columns, detected delimiter, input headers, and row diagnostics
  • source links, source review dates, unsupported cases, and review caveats
  • Terms and disclaimer reference

Supported inputs

  • pasted scrip-wise sale rows with ISIN, quantity, sale price, and cost of acquisition
  • optional 31-Jan-2018 FMV per scrip for grandfathering

What this does not decide

  • Does not download or confirm the live e-filing portal bulk-upload template; the department's own published instructions PDF and its AY 2025-26 validation rules disagree on the exact column set, so headers must be re-checked against the current portal template before upload.
  • Does not maintain or supply 31-Jan-2018 FMV figures; you must enter your own per scrip.
  • Does not cover unlisted shares or Schedule 115AD foreign-portfolio-investor rows.
  • Does not compute final tax payable, surcharge, or cess.

Axal path

Track capital-gains working papers, broker statement history, and filing review across assessment years in Axal.

Source explainer

The department's Schedule 112A CSV instructions and the gazetted Finance (No. 2) Act, 2024 are used for the field structure, the Section 55(2)(ac) grandfathering formula, and the 23 July 2024 rate cutover; the live portal template itself must still be re-checked each filing season.

Review workflow

Use the draft as a starting point, not a decision.

This page is meant for a one-off local review pass. Keep source documents beside the output and verify identities, dates, amounts, and assumptions before sending or filing anything.

Input guide

  • Use one row per scrip sale with isin, quantity, salePricePerUnit, saleDate, and costOfAcquisitionActual.
  • Add fmv31Jan2018PerUnit only if you want Section 55(2)(ac) grandfathering applied; leave it blank otherwise.

Example workflow

  1. Paste scrip-wise rows from your broker capital-gains statement.
  2. Review the before/on-or-after 23 July 2024 classification and the grandfathered cost of acquisition for each row.
  3. Re-download the current Schedule 112A bulk-upload template from the ITR utility and align headers before uploading.

Review checklist

  • Confirm the ISIN is a 12-character alphanumeric code.
  • Confirm the before/on-or-after 23 July 2024 classification matches the actual transfer date.
  • Re-verify the live bulk-upload template's column order before uploading anything to the portal.
  • Remember the Section 112A LTCG exemption threshold is Rs 1,25,000 applied on an aggregate basis across both rate periods, not per period; this tool does not apply that exemption for you.

Common mistakes

  • Uploading this tool's export directly without checking it against the live portal template, which has changed column requirements before.
  • Leaving out the 31-Jan-2018 FMV and then treating the resulting cost of acquisition as grandfathered when it is not.

When to move to Axal

Track capital-gains working papers, broker statement history, and filing review across assessment years in Axal.

Common questions

Boundaries before you rely on the output.

Is the exported table ready to upload as-is?

No. Re-download the current bulk-upload template from the ITR-2/ITR-3 utility and confirm the column headers and order match before uploading; the department's own instructions PDF is known to lag its live validation rules.

What happens if I do not enter a 31-Jan-2018 FMV?

The tool uses your actual cost of acquisition without grandfathering and flags the row so you know grandfathering was not applied.

Need this as a recurring workflow?

Keep this page for a one-off local draft. Use Axal when the same work needs saved mappings, client context, evidence trails, tasks, and review history.

Open Axal