Withholding Tax Report — every WHT deducted from vendor payments

Lists every vendor payment line in the period where you withheld tax at source, grouped by category (5% WHT, 10% Rent WHT, etc.) with a summary panel at the top showing totals per category.

This is the working paper for the periodic WHT schedule you file with the tax authority (Nigerian FIRS or equivalent) — the summary panel gives you the per-rate totals to type into the return, and the detailed list gives you the backup should the authority ask for evidence.

Before you start

• You need Financial Statements permission.
• WHT is captured on each Pay Bill payment line — in the WHT field on the line, and the withheld amount in TaxAmount. If your Pay Bill form doesn't capture WHT for some payment types, they won't appear here.
• The Category is the free-text WHT descriptor typed on the payment line (e.g. "5% WHT", "10% Rent WHT"). Use consistent labels so the summary panel groups cleanly.

Steps

1. Open Reports → Withholding Tax.
2. Pick a From / To date range. Defaults to the current month.
3. Read the Summary by category panel at the top — one row per distinct WHT descriptor showing line count, gross, and WHT.
4. Read the detailed list below — each row is a vendor payment line with date, vendor, category, gross amount, and WHT deducted.
5. Export → Excel to attach to your WHT filing workpaper.

Tips

• Consistent WHT labels matter. If you type "5% WHT" on some payments and "5% Withholding" on others, the summary panel treats them as separate categories. Standardise your labels.
• Total WHT withheld on the summary panel is the number to sum against your WHT liability account movement — they should match.
• The report picks up any Pay Bill line where TaxAmount is set, so it works whether you enter WHT as a fixed amount or via a formula on the Pay Bill screen.

Common problems

• "(uncategorised)" in the summary panel — a payment line has WHT amount but no WHT descriptor typed. Not blocking for the report, but fix by editing the line and adding the category label so future filings look tidy.
• No entries in this period — verify that recent vendor payments actually recorded WHT. The Pay Bill form's WHT column is optional; if operators aren't filling it in, this report will be empty even when WHT was deducted on paper.
• Totals don't match your WHT liability account — cross-check via General Ledger on the WHT liability account. The gap is usually either a Pay Bill line with WHT deducted from gross but no TaxAmount typed (report misses it) or a manual journal to the liability account (report doesn't see it — GL will).
• Wrong period — the report uses payment date (when the vendor was paid), not the source invoice date. That's the correct basis for WHT filing since remittance is due based on when you paid.