Schedule 112A CSV template

Hi Team,

Till last year the 112 template was having only one column of "Share/Unit acquired(1a)" which had value of "AE" and "BE", this year we see additional column "Share/Unit Transferred(1b)", does anyone help me what should be the value in this column?

 

Replies (12)
Quick Summary
Query asks about new Schedule 112A CSV template where column 1(b) �Share/Unit Transferred� appears and what values to enter. Discussion clarifies AE/BE codes: BE for before 23 July 2024 and AE for on/after 23 July 2024, based on transfer date, with reference to official CSV instructions and formatting rules.

First one is for shares sold before 22. 07.2024 which is taxed at 10% while second one is for sell after that day which is taxed at 12.5%.

Thanks for the response, however I need to know the exact values that needs to be added in the excel sheet so it doesnt give any validation error.

You are required to fill the sell value, cost of aquisition & expenses relative to transfer, separately for each time segment. Rest utility takes care.

No sir, Vikrant's question is something else. its regarding the second column in the Excel templete. In the templete we need to manually enter whether the share was sold on or after 23rd July. So Vikrant is trying to check if there is a code for the same.

@ Vikrant, In case the shares purchased are after 31st Jan 2018. you will not need to fill in everything. you just need to update it twice by clubbing the 23 July sales categorising it before and after.

In the  new column 1 (b) use BE for "before 23 july" , use AE for "on or After 23 July " based on the transaction date related to share tranfer. 

For the details, you may refer CSV Help file of Schedule 112A tab.

In the  new column 1 (b) use BE for "before 23 july" , use AE for "on or After 23 July " based on the transaction date related to share tranfer. 

For the details, you may refer CSV Help file of Schedule 112A tab.

Instructions to fill CSV file:
1a. For column referring to 1a of schedule 112A in the return, ‘Share/Unit acquired’, enter the value
‘BE’ if the share/unit was acquired on or before 31st January 2018. If share/unit was acquired
after 31st January 2018, enter value ‘AE’.
1b. For column referring to 1b of schedule 112A in the return, ‘Share/Unit Transferred’, enter the
value ‘BE’ if the share/unit was transferred before 23rd July 2024. If share/unit was transferred
on or after 23rd July 2024, enter value ‘AE’.

Refer to the Instructions for filling Schedule 112A on the IT Return Filing portal. Link for youre referece:

https://static.incometax.gov.in/iec/foservices/assets/itr-shared/documents/112A_115AD_CSV_Instructions.pdf

The Schedule 112A CSV template for AY 2026-27 has updated column requirements. The template download is inside the ITR-2 or ITR-3 XML utility, not from the help section.

To get the correct template:
1. Open the Income Tax e-filing portal
2. Go to File Income Tax Return, select AY 2026-27 and the correct ITR form
3. Download the Offline Utility
4. Inside the utility, go to Schedule 112A and look for the "Download Template" button

Common upload errors to fix:
- Date columns must be in DD/MM/YYYY format (not YYYY-MM-DD)
- All amounts in RUPEES only, not lakhs
- ISIN must be exact: 12 characters, no spaces, case-sensitive
- Blank rows at the bottom of the CSV cause a parsing failure ,  delete all empty rows
- Do not change column headers even slightly ,  any mismatch causes the entire upload to reject

For grandfathering: for shares or equity MF units acquired BEFORE 31.01.2018, the cost of acquisition is the higher of the actual cost or the Fair Market Value (FMV) as of 31.01.2018 (limited to sale price). This [capital gains guide with the CII table](https://taxgarden.in/blog/cost-inflation-index-cii-table-formula-indexation-capital-gains) shows how to compute the deemed cost.

Shares purchased post 31.01.2018 , would like to fill .csv file . There are some more fields in 112 a, csv AY 2026-27. Need guidance on filling the .csv

QUERY 

1) cost of acquisition without indexation OR  cost of acquisition. This is mentioned twice - which one to fill ?

2) Expenditure wholly and exclusively in connection with transfer - what all kind of charges comes under this category ??

CHARGES : Brokerage ,Central GST, Securities Transaction Tax, SEBI Turnover Fees, Stamp Duty,Exchange Transaction Charges, Clearing Charges, State GST, Integrated GST, IPFT

OTHER CHARGES : Other Credits & Debit

For shares acquired after 31 Jan 2018 enter 'AE', put the actual purchase price in both cost columns and leave FMV as on 31 Jan 2018 blank, as grandfathering under Sec 55(2)(ac) applies only to 'BE' shares; transfer expenses mean brokerage, exchange charges and GST and stamp duty thereon, not STT, which Sec 48 disallows.

The new “Share/Unit Transferred (1b)” column is for the shares or units disposed of during the year; “Share/Unit acquired (1a)” continues to capture acquisitions. Enter the quantity transferred for the relevant transaction, rather than “AE” or “BE”—those are not quantities. If no shares or units were transferred, follow the utility’s prescribed blank/zero treatment; the exact entry can depend on the current Schedule 112 utility and the transaction reported.

This distinction helps keep acquisition and disposal details clear when preparing Schedule 112. Manual tracking across statements and tax schedules can be difficult; automation reduces repetitive work while leaving classification and tax judgment in your control. At Jir AI we provide 2,000+ AI agents and 650+ integrations to streamline your practice’s day-to-day workload. To explore a workflow for your practice, connect with us on WhatsApp https://wa.me/message/3HVOZ7HIY4ESC1.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details