Schedule 112A-uploading with CSV file issues

First of all there is aminor difference in old template and current template .Please use latest template.It works well. You have to use AE or BE abbreviations in Column 1(a) and 1(b) respectively .Also ensure to remove junk data  in the file. You may try rhis way. 

These are the anamoloies found

1. Csv upload not possible

2. Validation error

3. Others not very consenting

I have used the latest vesion of Excel offline utility -ver 1.1 and CSV files. Viscibly there are no junk charaters in the file.Is there any way of checking .Csv file like Ctr+* shortcut used for Ms word files? 

Uploaded  the new   csv_112A in the excel utility under 112a tab , it is getting validated with no error .the total column  is coming correct.

But the last three cells related to the breakup of before and after 23 july, total  not getting populated .

Hence  in the Capital Gains (CG) section, the split-up for before 23 July and after 23 July showed nil, indicating no tax owed. 

But when I enter manually the data in ITR2 ver 1.1 ,it works correctly.

• Summary:
•  my CSV uploads successfully and validates with no errors.
• The total capital gains are correctly calculated.
• But the split between gains before and after 23 July is missing, showing nil in the CG section.
• Manual entry works fine, which confirms the data is correct—but the CSV isn't triggering the split logic.

Incase have I missed any step, please point out.

Thanks it will save a lot of time.

The solution is simple. You have to "AE" or "BE" for two columns. Please follow below rule for the respective columns.

In column "Share/Unit acquired(1a)" AE for shares BOUGHT after 31 Jan 2018, BE for shares BOUGHT before 31 Jan 2018.
In column "Share/Unit Transferred(1b)" AE for shares SOLD after 23 July 2024, BE for shares SOLD before 23 July 2024.

Thank for this great input. Another question - Should FMV be inputted for even the shares bought after Jan 31, 2018

Hi.  Were you able to find a work around?  I have the same issue.   I imported the CSV generated by the AIS Windows Utility.    (I also tried with the sample CSV that comes with the ITR2 utility).   The totals are correct but the split for before and after July 23 2024 is not getting populated and there appears to be no way to manually fix it.

(The final column shows 0 and 0 for the split and as a result LTCG is zero)

Hi.  Were you able to find a work around?  I have the same issue.   I imported the CSV generated by the AIS Windows Utility.    (I also tried with the sample CSV that comes with the ITR2 utility).   The totals are correct but the split for before and after July 23 2024 is not getting populated and there appears to be no way to manually fix it.

(The final column shows 0 and 0 for the split and as a result LTCG is zero)

Hi.  Were you able to find a work around?  I have the same issue.   I imported the CSV generated by the AIS Windows Utility.    (I also tried with the sample CSV that comes with the ITR2 utility).   The totals are correct but the split for before and after July 23 2024 is not getting populated and there appears to be no way to manually fix it.

(The final column shows 0 and 0 for the split and as a result LTCG is zero)

I found a work around.

Even though the split does not show in 112A, proceed to complete as much of the ITR you can and calculte the TAX and GENERATE the  final JSON and save it.   This JSON is not yet complete and we will not submit it  but this step will fix the issue.    Save your excel return as well for good measure.

Now open a NEW empty offline ITR excel sheet as if preparing the return for the first time and IMPORT the generted JSON from the previous step.   It takes several minutes but now you will see that Schedule 112A is properly filled and the columns for before and after July 23, 2024 are also properly filled.

You can now use  this as your return and calculate the tax which will now properly calcuate the LTCG at 10 and 12.5 percent respectively.

I found a work around.

Even though the split does not show in 112A, proceed to complete as much of the ITR you can and calculte the TAX and GENERATE the  final JSON and save it.   This JSON is not yet complete and we will not submit it  but this step will fix the issue.    Save your excel return as well for good measure.

Now open a NEW empty offline ITR excel sheet as if preparing the return for the first time and IMPORT the generted JSON from the previous step.   It takes several minutes but now you will see that Schedule 112A is properly filled and the columns for before and after July 23, 2024 are also properly filled.

You can now use  this as your return and calculate the tax which will now properly calcuate the LTCG at 10 and 12.5 percent respectively.

Congrats... you  could find the way out.

Though I have taken up with CPC, no solution was given.

I did a semi manual process. I have copied from excel file. and pasted columnwise.The split before /after appeared correctly and capital gain also got caculated correctly.