Skip to Content
FIN Globalization Services

Quarterly Returns for India

Tags:

Purpose

Use the new quarterly returns (RPFIWTIN_QRETURNS) report to generate electronic TDS returns. With this report, you can also generate returns (for residents and non-residents) for the following forms:

  • Form 26Q (TDS returns for payments other than salaries to residents)
  • Form 27Q (TDS returns for payments to non-residents)
  • Form 27EQ (TCS returns under section 206 C)

     

Note that you can also access this report using the FIWTIN_QRETURNS transaction code.

You need to apply the SAP Note 1830832 in order to get this solution. The relevant support package details are as follows:

SAP_APPL                600          SAPKH60024
SAP_APPL                602          SAPKH60214
SAP_APPL                603          SAPKH60313
SAP_APPL                604          SAPKH60414
SAP_APPL                605          SAPKH60511
SAP_APPL                606          SAPKH60609
SAP_APPL                616          SAPKH61603
SAP_FIN                   617          SAPK-61701INSAPFIN


The new quarterly returns report was developed using Object Oriented Programming (OOP) with customer exits. As a result, the users have the option to customize the report for scenarios that are not supported by the standard solution. Also, the file format in this report is implemented using the Data Medium Exchange Engine (DMEE). The DMEE enables you to easily create and maintain file formats. The overall performance of this new report is better when compared to the older version.

This report covers withholding tax items that you have remitted to the tax authorities and for which a bank challan has been entered in the system.

 

Execute the report once you enter all the necessary details on the selection screen. The report generates a list that shows all the withholding tax items for inclusion in the TDS return and generates an electronic file at the location you specify.

Prerequisites

Prior to using this report, ensure that you have made the necessary configurations for Extended Withholding Tax. To enable the report to handle reduced-rate taxes and exemptions, customize the withholding tax codes accordingly. 

Process/Solution

The report retrieves information from SAP standard tables and generates the file as per the latest file format given by the Income Tax Authority. In case any customer-specific documents needs to be included in the file, customers can follow the steps given below.

The first step is to export all parameters present on the selection screen to a class, fetch the extended withholding tax data from the BKPF, BSEG, and RBKP application tables, and then saving that data into 3 internal tables. You can make use of the FIWTIN_QRETURNS Business Add-In (BAdI) to fetch your (customer-specific) data. Use the MODIFY_FI_DOCUMENTS BAdI method to add customer specific records to the internal tables that is retrieved from standard SAP tables.

Once you generate a consolidated internal table (in this case, TDS_TAB) out of the BKPF, BSEG, and EBKP tables, the report provides you with an option to make modifications if required on your (customer-specific) scenarios, using the MODIFY_TDS_TAB BAdI method.

Next, update the challan details using the MODIFY_CHALLAN_DETAILS BAdI method.

Lastly, you need to fill file data to submit to the tax authorities. The file consists of the header, challan, and deductee details. Use the MODIFY_FILE_DATA Business
Add-In if you want to make changes to the file details. Once you update the internal tables with the relevant data, the system generates an output file.

Solution Extension

 

This report has also been extended to the SAP Utilities (SAP IS-U) and SAP for Insurance solutions/layers. Once you transfer data from SAP_APPL system, existing BAdIs in the relevant systems process all utilities and insurance documents and categorize them as per the file data format.

No comments