Withholding tax reports in sap

This article will help you understand how withholding tax report is generated in sap. These reports are needed in filling withholding tax returns with withholding tax authority.

What's the need for tax reports ?

The person/ authority which deduct withholding tax from payment to payee are liable to file withholding tax returns with the tax authority before a date specified by tax authority. Non-compliance results in heavy penalty.

For filling withholding tax return, company has to submit withholding tax data and other details of the transactions in specific report format as described by tax authority.

How SAP helps in producing withholding tax report quickly ?

Whenever an accounting document is posted in sap which has withholding tax involved, withholding tax data along with other details of the transaction gets stored in various tables in the database.

Document header data gets stored in table BKPF

Document line item data gets stored in table BSEG

Withholding tax information gets stored in table WITH_ITEM

 

Now you know that data is present in tables, all you need to do is write a program (ABAP code) which can fetch data from these tables and display in the report format.

Sap provides some standard reports (standard program) which can fetch data from tables and display output in report format. Custom program can also be developed to fetch data from tables and display output in specific format as needed.

Let’s take example to understand how withholding tax reports can be prepared

Below accounting document is posted in sap

Withholding tax data gets stored in table WITH_ITEM

Sap offers some standard reports; one of them is shown below (just as an example).

Standard withholding tax report: S_P00_07000134

Similarly customer programs (reports) can be written to fetch data from tables (database) and display output in specific report format.

GL ACCOUNTING

ACCOUNTS PAYABLE

ACCOUNTS RECEIVABLE

TAX ACCOUNTING

WITHHOLDING TAX

ASSET ACCOUNTING

SAP CONTROLLING

Training Enquiry Form

We are happy to help you

Call Now Button