Use the Withholding Tax By Invoice Report to review detailed invoice withholding tax information for a supplier, including invoice number, amount subject to withholding, and tax amounts withheld. Submit this report if your Apply Withholding Tax Payables option is At Invoice Validation Time. This report lists withholding tax information only for invoices that have amounts withheld.
Use the information in this report to satisfy management, supplier, and tax authority reporting requirements.
Withholding Tax by Invoice report show the amount withheld both at the time of invoice and payment and also shows the amount withheld at the time of only payment.
Payables sorts this report first by supplier, then by currency (if you select the Original currency as a report parameter).
You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.
Begin/End Date. Payables lists all invoices that have Withholding Tax type invoice distributions with GL Dates on or between the Begin Date and the End Date.
Currency
Functional. Payables lists invoices in the ledger currency.
Original. Payables lists invoices in the entered currency.
Tax File Number. Taxpayer ID for the supplier.
Amount Exempt. The amount of the invoice that is not subject to withholding tax for the displayed Withholding Tax type tax code and invoice. An invoice distribution is subject to withholding tax if it is assigned a Withholding Tax Group.
Cert. Num. The Withholding Tax Certificate number that applies to a Withholding Tax type tax code for a supplier.
Tax Code. The Withholding Tax type tax code for which an amount is withheld for the displayed invoice. Payables displays one line for each Withholding Tax type tax code and amount range that is in effect for the displayed invoice.
Tax Rate. The tax rate that is in effect for the displayed Withholding Tax type tax code and invoice. Payables displays the exception or certificate rate, if it applies.
Gross Amount. The amount subject to withholding tax for the displayed Withholding Tax type tax code and invoice. An invoice distribution is subject to withholding tax if it is assigned a Withholding Tax Group.
W'Tax Amount. The amount withheld for the displayed Withholding Tax type tax code and invoice. The withheld amount might be less than the rate times the amount subject to withholding due to amount limits you define for a Withholding Tax type tax code.
Date Paid. If the displayed withheld amount was created during payment batch processing, Payables displays the payment date for the payment batch. If the displayed withheld amount was created during, Invoice Validation, Payables displays the last payment date for the displayed invoice.