Prerequisites
Confirm the following before you start:- Withholding tax: Withholding tax is set up and applied to posted records. See How to Set Up Withholding Tax.
- Permissions: You have permission to view financial statements. The Admin, Controller, Accountant, Finance, View-Only, and View-Only Admin roles have it by default.
Open the report and set the period
Open the Withholding Register, then choose the date range, filters, and tab for the withheld amounts you want to review.- Navigate to Reports → Tax → Withholding Register, or search for
Withholding Registerin global search. - Set the date range. The report includes records whose date falls in the range.
- Optionally, filter by company, Vendor, Tax Agency, or Record Type (Bill, Direct Expense, or Vendor Credit).
- Choose a tab: Overview shows every withheld amount, Unremitted shows the amounts you haven’t remitted, and Remitted shows the amounts on a posted remittance.
Read the report
The report has one row for each withheld amount, which is one line with withholding tax on a posted bill, direct expense, or vendor credit. Amounts are in the company’s base currency. Vendor credit amounts are negative, because they reverse withholding tax. The report’s columns are listed below.
A Grand total row adds up the Net Amount, Gross Amount, Withheld Amount, and Payable Amount columns. The total is left out when the rows are in more than one currency, for example when you include companies with different base currencies. Filter by company to see it.
Reconcile your withholding tax payable account
The Unremitted tab shows the withholding tax you still owe. Run it for a date range that starts before your earliest unremitted record and filter by company. Its Withheld Amount total should match the current balance of your withholding tax payable account. Remittance status is current as of today, not as of the end of the date range, so compare it with the account’s current balance rather than a past period-end balance. If the amounts don’t match, check for:- Manual journal entries: Check for journal entries posted directly to the withholding tax payable account. The report only includes withheld amounts from bills, direct expenses, and vendor credits.
- More than one payable account: The report has no account filter. Compare its total with the combined balance of all your withholding tax payable accounts.
Export the report
Export the report to Excel, PDF, or CSV from the export menu. Exports use the tab, date range, and filters you have selected, so what you export matches what’s on screen. Export isn’t available when the report has no rows. For more on export formats, see Exporting and report packages. Because the export follows what’s on screen, set the tab and filters for the job before you export:- Before a remittance: Filter by Tax Agency, open the Unremitted tab, and export to Excel to check the amounts you’re about to pay.
- For a vendor: Filter by Vendor, open the Remitted tab, and export to PDF to share what you withheld and paid on the vendor’s behalf, for example to support a withholding certificate.
- For a withholding tax return: Set the date range to the return period, open the Overview tab, and export to CSV or Excel to work with the rows in a spreadsheet.
Limitations
The Withholding Register has these limitations:- Draft remittances show as unremitted: An amount is Remitted only when it’s on a posted remittance. An amount on a draft remittance shows as Unremitted with no Remittance No, but it’s locked and doesn’t appear in the list when you create another remittance.
- Posted records only: Withholding tax on draft bills, direct expenses, and vendor credits isn’t included.
- No grouping: The report doesn’t group or subtotal rows. Export it to Excel to subtotal by vendor or withholding rate.
Related pages
- Withholding Tax: how withholding tax is calculated and posted
- How to Remit Withholding Tax
- Exporting and report packages: export formats and scheduled delivery