Prerequisites for Leave Encashment in Excel format

Prerequisites for Leave Encashment in Excel format
To export the Template Go into → Tools →Microsoft Excel Sheet → Form 24Q (Salary)
Here the option is given in the Salary Detail sheet to enter the Leave Encashment
Here put "Gross amount" and "exempt" value of Leave Encashment

and enter Salary U/s 17(1) (Excluding Allowances)
The data which will be imported in the salary details will be shown to you in this way.
Basic Salary 90000
Leave Encashment (Taxable) 1000
Total Salary u/s 17 (1) 10000
Hope this Helps
Related Articles
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 ...
TDS || How to fill Annexure II (Salary) details
Salary Detail (Annexure II): Please note that Salary detail data is mandatory for e-filing of Fourth Quarter for all the employees. You can enter the salary Income in Deductee Transaction > Salary Detail (Annexure II) feature given in menu bar. Now, ...
Excel Import → Subscript Out of Range - Error in Excel Import
Root Cause of the Error: This issue primarily occurs when you import an Excel sheet and modify the formatting of the software's predefined Excel sheet. Solution: To resolve this issue, please follow these steps: Step 1: Open the Excel sheet that you ...
TDS || Excel Import Error → Tax Rate should 2/3 digit after decimal
Excel Import Error → "Tax Rate should 2-3 digit after decimal" Root Cause of the error → The error occurs in the Zen TDS Excel import due to an incorrect tax rate format. The tax rate must be specified with exactly two decimal places (e.g., 5.00 or ...
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 ...