TDS || 80CCD(2) Figure not coming in excel Import

TDS || 80CCD(2) Figure not coming in excel Import

Clint entered the 80CCD(2) amount in - 'Deduction U/s 80CCD(2)' column in 24Q Excel sheet and when he imports the same Amount is not coming in Salary Details Under 80CCD(2) Deduction.


Section 80CCD (2) allows salaried individuals to claim deductions up to 10% of their salary which includes the basic pay and dearness allowance or is equal to the contributions made by the employer towards the NPS.

Solution :
Regarding this You are requested to please enter the same amount in - 'Contribution by Employer to NPS (up to 10% of Salary)' Column in Excel sheet and then Import the excel.


Import the excel sheet, Data automatically picked through this column in 80CCD(2) Deduction.

Hope this helps.

    • Related Articles

    • TDS || Excel export and Import Procedure

      To reduce complications of data entry in TDS software, a facility has been provided where the user can import data through excel and can export data in excel. The process below explains Data import and export through excel in TDS software. Excel ...
    • TDS || Correction → Excel export and Import Procedure

      The procedure below outlines the data import and export through Excel in the TDS software, along with the correction process: To initiate a correction, first download and import the consolidated file into the software. To do so, click on "Click Here ...
    • TDS || Deductee/Employee Master → Import from Excel

      To import the Deductee/Employee Master through an Excel sheet, follow these steps: Download the "Deductee/Employee Master Excel Template": Navigate to "Master" → "Deductee/Employee Master". In the "Excel Import" dropdown menu, click on "Template ...
    • TDS || Excel Import → Import of already in progress

      Root Cause of the Error → This issue occurs when Excel is importing data and encounters a malfunction, causing it to get stuck midway through the process. Solution → To resolve the error, click the "Clear Excel Import Flag" button. After that, click ...
    • Excel import - Tax Rate should be numeric

      Excel import  - Tax Rate should be numeric Solution  This error comes when TDS details (24q,26q,27q,27eq) are imported from Excel Template and the tax rate is not entered in the numeric format Open excel template > "deductee detail" sheet Select a ...