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

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

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

    • Income Tax || Trial balance Import through Excel Template

      How to Import Trial Balance Through Excel Template: Preparing a trial balance through Excel involves organizing your financial data to ensure that all debits and credits balance. Here's a step-by-step guide to creating a trial balance in Excel: Step ...