Prerequisites for Leave Encashment in Excel format

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 ...