How to fill in csv file for Schedule 112A

This year, csv file for reporting of LTCG on sale of equity shares/Equity oriented Mutual funds, has an additional column 1(b). This is for reporting whether sale transaction was before or on/after 23 July 2024. This is to distinguish taxability of LTCG either @ 10% (for sale before 23.7.24) or @ 12.5% (for sale on/after 23.7.24). Does anyone her know what code is to be mentioned in this column? (In column 1(a), BE is to be mentioned for purchase on/before 31.1.2018 and AE is to be mentioned for purchase on/after 1.2.2018). 

Replies (6)
Quick Summary
Query asks how to fill new Schedule 112A CSV column 1(b) for reporting LTCG sale timing (before or after 23 July 2024) and applicable tax rates. Discussion clarifies use of BE for before 23/07/2024 and AE for on/after 23/07/2024; some users confirm successful upload using these codes.

The code mening remains same  ie BE-Before Eligible _period -Before 23 July 2024;

AE-After Eligible_period On Or After 23 July 2024.  Ref: CSV help tab of schedule 112A.

BE and AE in 1B is giving error

I entered BE (for sale before 23.7.24) and AE (for sale on/after 23.7.24). Data file was smoothly uploaded.

In the Schedule 112A CSV for AY 2026-27, column 1(b) uses two codes to split your equity LTCG by the Budget 2024 cutoff date:

AE = gains from equity sold between April 1, 2024 and July 22, 2024 (Period 1, old LTCG rate of 10% above Rs 1 lakh)
BE = gains from equity sold between July 23, 2024 and March 31, 2025 (Period 2, new LTCG rate of 12.5% above Rs 1.25 lakh)

For each row in your CSV, enter the sale date, purchase date, ISIN, company name, and put the gain or loss figure in the AE column if the sale was before July 23, or in the BE column if the sale was on or after July 23.

If your broker statement already has transaction-level dates, the mapping is straightforward. If the broker has given you a consolidated gain figure, you need to split it manually using individual trade-level data from your statement or demat account.

Note: The Rs 1 lakh and Rs 1.25 lakh exemption limits apply to the respective periods. You cannot club Period 1 and Period 2 gains for the exemption calculation.

This [capital gains tax guide](https://taxgarden.in/blog/tax-on-sale-of-property-india-capital-gains-seller-guide-ay-2026-27) has the full rate table and computation walkthrough for AY 2026-27.

For AY 2025-26 the column 1(b) codes are BE for sales before 23 July 2024 (10% above Rs 1 lakh) and AE for sales on or after that date (12.5% above Rs 1.25 lakh), as the uploaded file confirmed; the later reply reverses them, and for AY 2026-27 every sale falls after the cut-off, so all LTCG is taxed at 12.5% under Sec 112A.

Column 1(b) uses “BE” for a transfer before 23 July 2024 and “AE” for a transfer on or after 23 July 2024. This is separate from column 1(a), which classifies the acquisition date around 31 January 2018. Apply the transfer-date code to each sale transaction; verify against the applicable ITR utility/schema for the assessment year, as labels can differ between utilities.

Preparing the capital-gains schedule means reconciling transaction dates, acquisition details and the CSV before upload. Manual checking across multiple statements is difficult; automation can reduce repetitive work while leaving tax treatment and review under your professional judgment. At Jir AI we provide 2,000+ AI agents and 650+ integrations to streamline your practice’s day-to-day workload. WhatsApp us to see how it fits your filing workflow: https://wa.me/message/3HVOZ7HIY4ESC1

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details