Accounts Payable > Reports > AP Withholding Tax Report

AP Withholding Tax Report

You use this program to generate a report of withholding tax entries made in the Accounts Payable module.

Before running this report, ensure that you have run the Payment Cycle Maintenance, Payment Cycle Maintenance and Payment Cycle Maintenance programs.

Report Options

Field Description
Report details
Option Description
Check details

Prints the report in supplier sequence with details such as the check number and bank.

A summary withholding tax report by tax code is produced at the end of the report.
Invoice details

Prints the report in supplier sequence with invoice details such as the invoice number and supplier's tax id number.

A summary withholding tax report by tax code is produced at the end of the report.
Summary report by supplier Prints the report in supplier sequence with supplier details such as the supplier's tax id number and default tax code.
Summary report by tax code Prints the report in tax code sequence with details such as the tax code and description, tax rate, taxable amount and tax withheld.
Year to print The financial year for which you want to generate the report.
Options  
Sub-totals by bank

Prints subtotals for each bank on the report if you selected Check details at the Report Details field.
Print supplier address

Prints the supplier's address on the report if you selected Check details or Invoice details at the Report Details field.

Delete withholding tax file

Deletes the withholding tax file if your Accounts Payable module is in period 12.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

Calculations

  • If you enabled the Automatic calculation of withholding tax setup option (Tax Options) then the taxable invoice amount is calculated and printed on the report and the withholding tax is calculated as follows:

    Withholding Tax Amount = (Taxable Amount * Withholding Tax Rate) / 100

    where:

    • Taxable Amount = Gross payment – Tax amount on invoice – Discount amount

      and where the Tax amount on the invoice is calculated from the tax code assigned to the first ledger distribution entry against the invoice. (AP Invoice Posting).

  • If you have not enabled the Automatic calculation of withholding tax setup option, then only the gross invoice amount is printed and withholding tax is calculated as follows:

    Withholding Tax Amount = (Taxable Amount * Withholding Tax Rate) / 100

    where:

    • Taxable Amount = Gross payment – Discount amount

      The Tax amount on the invoice cannot be calculated as it is assumed that multiple tax codes were used and therefore the total tax value cannot be calculated.