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 || 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 ...ExpressTDS || Process to Fill Salary Details (Annexure-II)
Salary details are mandatory for e-filing the Fourth Quarter returns for all employees. You can enter salary details under Salary Details (Annexure-II). Steps to Add Salary Details: Step 1: Navigate to the Deductor Master and select the relevant ...