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