Add to Favourites

View E-24Q e-Return in TallyPrime (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.

The tax deducted is based on the tax regime selected by the employee. The regular and u/s 115BAC tax regime have different tax slabs.

Export E-24Q

1. Gateway of Tally > Display More Reports >  Statutory Reports > Payroll Reports > Income Tax > E-24Q.
2. Press Alt+B (Save Return) in Form 27Q report, to save the return (Form 27Q can be exported only after it is saved). The report closes on saving. Open Form 27Q again.
3. Press Alt+E (Export) and select E-Return to view the Export Report screen.
4. By default, File Format is SDF (Fixed Width) respectively.
5. In Folder path field enter or select the path to where the txt file to be exported.
6. By default, File Name will be displayed as ITeTDS.txt which can be changed by the users.
7. Select required Quarter Period for.
8. Specify the required option in Is Regular Return Filed for Previous Period.
9. Enter the Receipt No. /Token No.
10. Press Enter to accept and select Configure if need to add Person.
    Responsible Details.
    

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

    • Mobile Number: This field is provided to specify the mobile number of the assessee.
    • STD Code: This field is provided to enter the STD code.
    • 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.

    • Enter the E-mail ID of the Person responsible for income tax deduction and payment to the income tax department.
    • Select Yes or No as applicable, in Is Change in Address since last Return field. 
    • Appearance of Employee Names: Select the Display Style for the Employee Names, like Name Only, Alias Only, and so on.
    • Under Other Details,
    • Type of Deductor details will be captured form the TDS
      Details defined in F11 (Features).
    • In Category (deductor/Collector) field select the Deductor Category. e.g. Association of Person (AOP)
    • In Quarter Period for field select the appropriate Quarter for which the e-return to be generated.
    • Set the option Is Regular Return Filed for Previous
      Period to Yes/No as applicable.
      The Quarterly Return configuration screen is displayed as shown:
11. Press Enter to Export Quarterly Return in 24Q.
    The exported file is placed in the TallyPrime 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. TallyPrime 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.

New fields

Update Form E-24Q Text File As Per FVU 7.5/7.6 | Section 194P

The latest version of the File Validation Utility (FVU), 7.5/7.6, is available. Accordingly, you can generate the Form E-24Q text file in TallyPrime for filing e-TDS. However, you have to make a few updates in the text file before validating it in the FVU and filing e-TDS returns. This will ensure that your returns comply with the latest requirements.

The latest updates are regarding deduction of tax in case of specified senior citizen (under section 194P). Accordingly, the following new fields under the batch header information have been added:

1. Field 70: Count of Section 194P Details Record 
2. Field 71:  Batch Total of – Gross Total Income as per Section 194P Details 

For these changes, it is recommended that you open the exported text file of the return, as you will be able to update the batch header information easily.

1. In TallyPrime, export the E-24Q text file.
   1. Gateway of Tally > Display More Reports >  Statutory Reports > Payroll Reports > Income Tax > E-24Q.
   2. In the Export screen, configure the Folder Path, as needed, and select Send.
2. Open the ITeTDS text file (Notepad), from the Folder Path.
3. Update the Batch Header.
   • For Q1 to Q3, after the GSTIN field, type two caret symbols (^^) manually for field 70 and field 71, as shown below:
     
     
     
     
   • For Q4, after the GSTIN field, type 0 (zero) for field 70 and type 0.00 for field 71, as shown below:
     
     
     

     Note: If you have transactions related to section 194P, enter the senior citizen employee count in field 70, and the respective gross total income in field 71. 

4. Save the text file.

Now the E-24Q – ITeTDS text file is ready as per FVU 7.5/7.6. You can successfully validate it and file the e-TDS returns.

Update Form E-24Q Text File as per FVU 8.2

The latest File Validation Utility (FVU) 8.2 version is available. Accordingly, you can generate the Form 24Q text file in TallyPrime for filing Salary returns. However, you have to make a few updates in the text file before validating it in the latest FVU tool and filing returns. This will ensure that your returns comply with the latest requirements. The changes to be made in the Salary E-24Q text file under Deductee Details (DD) and Salary  Details Record (DD) are mentioned below.

Form 24Q (Q1 to Q3)

Field 48, 49, 50, 51, 52, 53

As per the latest updates, six new fields from 48 to 53 have been added under the Deductee Details line and no value should be specified here.  

For these changes, it is recommended that you open the exported Form E-24Q text file and add six delimiters as ^^^^^^ in field numbers 48 to 53 in the Deductee Details (DD) line.

1. Gateway of Tally > Display More Reports > Payroll Statutory Reports > Income Tax > E-24Q.
2. Configure the Export form as required.
   1. Select the Folder Path and File Name.
   2. Select Q1 from the list of Period in Quarter Period for.
3. Press E (Export).
4. In the exported Form e-24Q text file add six delimiters as ^^^^^^ from fields 48 to 53 in the Deductee Details (DD) line.
   
5. Save the text file.
   

   You can validate it in FVU 8.2 and proceed to file Salary TDS returns.

Form 24Q (Q4)

Field 48, 49, 50, 51, 52, 53

As per the latest updates, six new fields from 48 to 53 have been added under the Deductee Details line and no value should be specified here.  

For these changes, it is recommended that you open the exported Form E-24Q text file and add six delimiters as ^^^^^^ in field numbers 48 to 53 in the Deductee Details (DD) line.

1. Gateway of Tally > Display More Reports > Payroll Statutory Reports > Income Tax > E-24Q.
2. Configure the Export form as required.
   1. Select the Folder Path and File Name.
   2. Select Q4 from the list of Period in Quarter Period for.
3. Press E (Export).
4. In the exported Form e-24Q text file add six delimiters as ^^^^^^ from fields 48 to 53 in the Deductee Details (DD) line.
5. Save the text file.
   

   You can validate it in FVU 8.2 and proceed to file Salary TDS returns.

Field 80, 81, 82, 83, 84, 85, 86, 87

As per the latest updates, eight new fields from 80 to 87 have been added under the Salary  Details Record (DD) details and no value should be specified here.

For these changes, it is recommended that you open the exported e- 24Q text file and add eight delimiters as ^^^^^^^^ in field numbers 80 to 87 of the SD line.

1. Gateway of Tally > Display More Reports > Payroll Statutory Reports > Income Tax > E-24Q.
2. Configure the Export form as required.
   1. Select the Folder Path and File Name.
   2. Select Q4 from the list of Period in Quarter Period for.
3. Press E (Export).
4. In the exported Form e-24Q text file add eight delimiters as ^^^^^^^^ at the end in the Salary Details Record (SD) line.
   
5. Save the text file.
   

   You can validate it in FVU 8.2 and proceed to file Salary TDS returns.