This method is not applicable from FY 2020-21 as the I-T Dept. has launched a new JSON utility which has an inbuilt method to import multiple entries through a CSV template. The template can be obtained from within the JSON utility.
Help with the new template:
1. Column No.1a (Share/Unit acquired) : Use "BE" for entries pertaining to assets acquired before 01-02-2018.
2. For assets acquired on or after 01-02-2018, a single consolidated entry is enough. This entry can be made manually in the utility and need not import through template.
Help with the new template:
1. Column No.1a (Share/Unit acquired) : Use "BE" for entries pertaining to assets acquired before 01-02-2018.
2. For assets acquired on or after 01-02-2018, a single consolidated entry is enough. This entry can be made manually in the utility and need not import through template.
Background: With the introduction of grandfathering of gains prior to 01-02-2018 in case of LTCG from equity shares / equity mutual fund units in budget-2018, the calculation of LTCG requires more details. A new schedule was introduced in ITR-2 named 112A, where the details of each batch of shares / mutual fund units need to be entered separately, and the aggregate LTCG will be populated to Schedule-CG. This means each batch of purchase sold as a single transaction or a single purchase sold as separate transactions need to be entered as separate rows in Schedule-112A for calculation. This was optional for FY-2018-19, but it is mandatory (as of now) for FY-2019-20.
Purpose: This is a simple method to populate Schedule-112A in the Java utility from the values maintained in an excel sheet. This is useful only if you have a substantial number of transactions. Else, please don't attempt this method, as it is always better to enter each row manually.
Requirements: Moderate skill in excel. Basic knowledge about ITR-2 e-filing.
Known issues:
1) When opening a file with large number of transactions, like more than 10K, the Java Utility may freeze for a long time or even crash. This is an issue with the Java Utility.
2) In the column "Name of the Share / Mutual Fund", if the value has an "&" (ampersand) in it, the upload fails in the ITR java utility. Use the words "AND" instead or simply omit it the symbol in such cases.
Updated: 06-01-2021 for FY-2019-20
Step 1: Download the Excel template here. (MD5: 050634CBE9F491105E9C72CC6E4FE0A3)
Step 2: Fill values in the respective columns. It can be pasted from another sheet, or use formulae to populate it here.
Step 3: Use the Fill-handle - Double-click on bottom-right corner of the blue & green color cells to fill the values to all rows.
Step 4: Copy the green-colored cells.
Step 5: Download ITR-2 Java Utility. Download pre-filled XML or fill necessary values in the General Tab. Remember to mark residential status as Resident/NRI.
Step 6: Make one single entry in Schedule-112A, and save as draft.
Step 7: Open the draft file in a text editor like Notepad++.
Step 8: Find the block of text starting from <ITRForm:Schedule112ADtls> to </ITRForm:Schedule112ADtls>
Step 9: Paste data copied from Excel to replace this.
Step 10: Open the draft file in the Java Utility. Go to Schedule-112A. Make a change in the value of the column "No. of shares / Units" of any one row. Move the cursor to the next cell. All the rows will be re-calculated. Now reverse the change back to original value.
Complete
unable to load more than 60 scripts. it shows ITR version error
ReplyDeleteUse the latest utility for the relevant AY.
DeleteAfter pasting the data from Excel, I am getting the following error:
ReplyDelete"Invalid ITR or Assessment year".
Please suggest a solution.
Download the latest java utility. If the error still persists, please see if there are any special characters in your data. "&" in scrip / MF name usually creates error.
DeleteThanks a lot. The Problem was because of "&" in the name of an L&T scrip. Corrected that and succeeded in uploading the entire MF data in Sch 112A - I have 178 rows of data. But I am facing a new problem. When I try to generate XML using the Save button, I get error saying "Amount should be numeric not exceeding 14 characters or numeric with two decimals". There is no numeric data in amount column in Sch 112A or anywhere else which is longer than 14 characters or which has more then 2 decimal places. Any idea how to resolve this?
ReplyDeleteThanks for the update. The new error must most probably due to comma separators in the numbers. Else, please check for any other special characters crept into any field.
DeleteI have tracked the issue and found a solution. I had rounded off the no of units and amounts to two decimal places using the Comma Tool of Excel. Then I realised that this tool only changes the display of the numbers to two decimal places, but the underlying data does not change. So, I used the Round function to round off the data to two decimal places and then uploaded the modified data to Javea utility. This solved the problem and the Utility is not generating any error now.
ReplyDeleteThanks for the update.
DeleteI have generated the XML after filling up the ITR2 in Java Utility. But when I tried to e-file the return, following error message was generated:
ReplyDelete"The XML Schema is invalid.Please upload the XML in the correct schema.
At line no 608: invalid content was found starting with element 'ITRForm:ISINCode'. One of '{"http;//incometaxindiaefiling.gov.in/master".ShareOnOrBefore}' is expected.
Can you suggest how to resolve this issue?
Either the ISIN code on a row is invalid, or there are unexpected special characters in your data.
DeleteGetting error. FMV incorrect. Do we need to round off FMV or it is OK in decimals.
ReplyDeleteThis method is not applicable from FY 2020-21 as the I-T Dept. has launched a new JSON utility which has an inbuilt method to import multiple entries through a CSV template.
Delete