8.3.2. Pan Modification Through Excel For Correction Return

For Correction Return, apart from manual modification of the PAN , it can also be modified through Excel and get imported in the system. This would save effort in entering data through formats of the software interface.

Importing data from Excel can be done in 3 steps:
1 Download the pre-defined blank Excel format in the desired location
2 Prepare the required data in this Excel sheet
3 Upload this data from the Excel sheet into the system

1. In order to import the data from Excel, first download the Pre-defined blank Excel format in the desired location. In order to do so, select the Correction Return which needs to be rectified. Select the Batch for which the PAN Number need to be corrected the following screen will appear:

Click on then following screen will appear :

Figure - Pan Modification by using Excel

Click on Modify Deductees

Click on PAN Modification

Click on to create the blank Excel file and save it the desired location.

2. Prepare the PAN Modification Data in the Pre-defined blank sheet, make sure about the following:
i. The ‘CD serial no.’ , ‘DD Serial no.’ ,’PAN of Party’ , and ‘Name of Party’ as per Justification Report need to be placed in the Excel Sheet and the correct PAN under ‘NEW PAN’ has to be entered for each Record.

3. In order to import this data into the system enter the Excel file path. Excel File Path : Enter the Excel file path from which the data has to be imported.
Color coding in Excel for error (this may take a few more minutes) – If there is any error in the data provided in the Excel sheet, the system will highlight the same. The user is expected to rectify the data and import the entire file again. However, in order to display these errors using the color code, check this box.

Validate Excel File: Click here, the system will validate the excel data.

Figure - Validate Pan Modify Excel

If the data is correct then the following screen will appear :

Click on The data with the modified PAN will get imported into the system.
In case, there is any error in the data, the system will highlight the errors. The errors have to be rectified and the Excel sheet has to be imported again.