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