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

    • 24G - Excel import error regarding DDO number

      24G - Excel import error regarding DDO number  Solution  This error come when you import the 24 G detail from excel and entering duplicate DDO number in transaction sheet for same month, as per NSDL guide line same DDO number for same form and month ...

    • Excel Import Error "challan is not getting mapped"

      Excel Import Error "challan is not getting mapped" Possible Resolution To solve this excel import issue, here are some suggestions are given below. 1.  All mandatory details should be filled in the "Challan Details" Sheet. * Challan number * Deposit ...

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

    • Express TDS - Deductee/employee master import from excel

      Express TDS - Deductee/employee master import from excel  Step 1 - Go into deductee master and click on import deductee  Step 2- Now click on "downlaod excel template " Enter detail in excel template  you are required to browse the excel file  from ...