> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dualentry.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to Use the Withholding Register

> Use the Withholding Register in DualEntry to review tax withheld on bills, direct expenses, and vendor credits, check what is unremitted, and export it.

The Withholding Register lists every amount of withholding tax (WHT) withheld on your posted bills, direct expenses, and vendor credits, and shows whether each one has been remitted to the tax agency. Use it to check what you owe a tax agency before you remit, to reconcile your withholding tax payable account, and to support withholding tax returns and certificates for vendors.

After completing the steps below, you have the withheld amounts for your period, split into remitted and unremitted, and an export ready for filing or review. For how withholding tax works, see [Withholding Tax](https://docs.dualentry.com/accountants/core-financials/tax-management/withholding-tax.md).

## 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](https://docs.dualentry.com/accountants/core-financials/tax-management/set-up-withholding-tax.md).
* **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.

1. Navigate to **Reports → Tax → Withholding Register**, or search for `Withholding Register` in global search.
2. Set the date range. The report includes records whose date falls in the range.
3. Optionally, filter by company, **Vendor**, **Tax Agency**, or **Record Type** (**Bill**, **Direct Expense**, or **Vendor Credit**).
4. 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.

| Column | Description |
| - | - |
| **Vendor** | The vendor on the record |
| **Tax Agency** | The tax agency on the posted remittance, or the vendor's tax agency if the amount isn't remitted |
| **Record No** | The bill, direct expense, or vendor credit number |
| **Record Type** | Bill, Direct Expense, or Vendor Credit |
| **Posting Date** | The record date |
| **Withholding Rate** | The withholding category name |
| **Rate** | The withholding rate percentage |
| **Currency** | The currency of the amounts |
| **Net Amount** | The line amount before VAT, GST, or sales tax, which is the amount withholding tax is calculated on |
| **Gross Amount** | The payable amount plus the withheld amount |
| **Withheld Amount** | The withholding tax on the line |
| **Payable Amount** | The amount owed to the vendor: the net amount plus tax, minus the withheld amount |
| **Remittance Status** | **Remitted** or **Unremitted** |
| **Remittance No** | The posted remittance that paid the amount |

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.

To pay the unremitted amounts, select **New Withholding Remittance** on the report. See [How to Remit Withholding Tax](https://docs.dualentry.com/accountants/core-financials/tax-management/remit-withholding-tax.md).

## 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](https://docs.dualentry.com/accountants/reporting-analytics/exporting-and-report-groups.md).

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.

Exported amounts are in the company's base currency, the same as on screen.

## 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](https://docs.dualentry.com/accountants/core-financials/tax-management/withholding-tax.md): how withholding tax is calculated and posted
* [How to Remit Withholding Tax](https://docs.dualentry.com/accountants/core-financials/tax-management/remit-withholding-tax.md)
* [Exporting and report packages](https://docs.dualentry.com/accountants/reporting-analytics/exporting-and-report-groups.md): export formats and scheduled delivery


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.