https://help.tallysolutions.com/docs/te9rel65/Payroll/E24Q.htm

E-24Q e-Return (Payroll)

E-24Q is a Quarterly e-return that contains the details of the salary paid and tax deducted from the employees, which an Employer needs to submit to the department in each quarter.

On this page

Export E-24Q

Updates supported as per the latest changes in the tool

To export E-24Q

1. Go to Gateway of Tally > Display > Statutory Reports > Payroll Reports > Income Tax > E-Return > E-24Q .

2. Press Backspace in the Quarterly Return screen to make changes in Person Responsible Details or Other Details fields.

o By default, the Language and Format is preset as Restricted (ASCII Only) and SDF (Fixed Width) respectively.

o In Export Location field enter the details of the path to where the txt file to be exported

o In Output File Name field the test file name will be displayed as ITeTDS.txt which can be changed by the users.

o The option Open Exported Folder will be set to Yes by default.

o Press Enter to accept the Person Responsible Details (The Address details are automatically defaulted from the Company masters in the Person Responsible Details column)

Specify the Mobile Number or STD Code with Telephone number in the E-24Q file.

o Mobile Number : This field is provided to specify the mobile number of the assessee.

o STD Code : This field is provided to enter the STD code.

o Telephone : This field is provided to enter the telephone number of the assessee.

Note: As per the e-return structure, it is mandatory to specify either Mobile Number or STD Code with Telephone number in the E-24Q file.

If you try to navigate without specifying the Mobile number or STD Code or Telephone number application will not allow to move further.

o Enter the E-mail ID of the Person responsible for income tax deduction and payment to the income tax department.

o Select Yes or No as applicable, in Is Change in Address since last Return field.

o Appearance of Employee Names : Select the Display Style for the Employee Names, like Name Only , Alias Only , and so on.

o Under Other Details ,

o Type of Deductor details will be captured form the TDS Details defined in F11: Features .

o In Category (deductor/Collector) field select the Deductor Category . e.g. Association of Person (AOP)

o In Quarter Period for field select the appropriate Quarter for which the e-return to be generated.

o Set the option Is Regular Return Filed for Previous Period to Yes / No as applicable.

The Quarterly Return configuration screen is displayed as shown:

3. Press Enter to Export Quarterly Return in 24Q.

The exported file is placed in the Tally.ERP 9 Directory with the file name as specified above.

The exported file (form 24Q) is required to be validated with the File Validation Utility (a freely downloadable utility from NSDL website) and after validation, the returns should be submitted to the department in CD along with Form 27A in Physical Form.

Note: It is mandatory to validate the TDS returns with File Validation Utility to confirm to the requirements as prescribed by the Income tax department. In case of any errors in exported file (Returns), the FVU prompts a error message with error code, the assessee may correct the same and revalidate the returns. The File Validation Utility is available for Quarterly and Annual returns separately. Tally.ERP 9 exports Form 24Q in the text (.txt) format as prescribed by NSDL.

Updates Supported as per the Latest Changes in the Tool

Changes in the tool are applicable for Quarter 4.

Field No.

Field Name

Updates

13

Total amount of salary (338+339)

This consists of the values of field no. 34 & 35.

Field 34 includes the following:

Gross salary as per provisions contained in section 17(1)

Value of perquisites under section 17(2) (as per form no. 12BA, wherever applicable)

Profit in lieu of salary under section 17(3) (as per form no. 12BA, wherever applicable)

35: Reported taxable amount on which tax is deducted by the previous employer

17

Income chargeable under the head Salary

Field no. 13-(16+76)

13: Total amount of salary (field no. 34 and 35)

16: Total deduction under section 16

76: Total amount of exemption claimed under section 10

18

Income (including admissible loss from house property) under any head other than income under the head Salaries offered for TDS [section 192 (2B)]

Income from other sources and interest on housing loan

19

Gross Total Income (351 + 352 + 354)

Field no. 17+18+77

17: Income chargeable under the head Salaries

18: Income (including admissible loss from house property) under any head other than income under the head Salaries offered for TDS [section 192 (2B)]

77: Income under the head Other Sources offered for TDS [section 192 (2B)]

23

Total taxable Income (355-356)

Field no. 19-22

19: Gross Total Income (field no. 17+18+77)

22: Gross total income under Chapter VIA

28

Net Income Tax payable [368+370+371-(369+372)]

Field no. 24+25+26-(78+27)

24: Income tax on total income

25: Surcharge

26: Education cess

27: Income Tax Relief under section 89 when salary is paid in arrears or advance

78: Rebate under section 87A, if applicable

31

Aggregate amount of deductions admissible under section 80C, 80CCC and 80CCD(1)

Aggregate amount of deduction under section 80C, 80CCC and 80CCD(1) should be less than or equal to Rs 150,000.00/-.

34

Taxable Amount on which tax is deducted by the current employer (335 + 336 + 337)

Field no. 67 + 68 + 69

67: Gross salary as per provisions contained in section 17(1)

68: Value of perquisites [section 17(2)] (as per form no. 12BA, wherever applicable)

69: Profits in lieu of salary [section 17(3) (as per form no. 12BA, wherever applicable)

New fields

Field No.

Field Name

Details

67

Gross Salary as per section 17(1)

Gross salary as per provisions contained in Sec 17(1)

68

Value of perquisites [section 17(2)]
(as per form no. 12BA, wherever applicable)

Value of perquisites under section 17(2) (as per form12BA)

69

Profits in lieu of salary [section 17(3)]
(as per form no. 12BA, wherever applicable)

Value of perquisites declared under Profit in lieu of salary under section 17(3) (as per Form 12BA)

70

Travel concession or assistance [section 10(5)]

The value of Leave Travel Assistance under Allowance under section 10

71

Death cum retirement gratuity under section 10(10)

The value of Gratuity under Allowance under section 10

72

Commuted value of pension under section 10(10A)

In Tally.ERP 9, this can be created under any other exemption.

73

Cash equivalent of leave salary encashment under section 10(10AA)

The value of Leave Encashment on Retirement under Allowance under section 10

74

H ouse rent allowance [section 10(13A)]

The value of House Rent Allowance under Allowance under section 10

75

Amount of any other exemption under section 10

Any exemptions declared under Allowance under Section 10 other than exemptions (70th to 74th)

76

Total amount of exemption claimed under section 10 (340+341+342+343+345+346)

The total amount of exemption claimed under section 10, that is, total of 70+71+72+73+74+75

77

Income under the head Other Sources offered for TDS [section 192 (2B)]

The qualifying value of income from other sources

78

Rebate under section 87A, if applicable

Tax rebate value under section 87A

Chapter VIA details after the SD line

The breakup of the Chapter VIA should appear with the section details (80CCG, Others, 80C, 80CCC, 80CCD(1), 80CCD(1B), 80CCD(2), 80D, 80E, 80G, 80TTA).

Note : Aggregate amount of deduction under section 80C, 80CCC and 80CCD(1) should be less than or equal to Rs 150,000.00/-.