# Nigeria Withholding Tax Schedule Worksheet > Source: https://netray.co/tools/nigeria-withholding-tax-schedule-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable worksheet to list supplier payments, apply a withholding rate per line, and total the tax to remit with a schedule you can export to Excel. ## Category regional ## Region Nigeria ## Industry Manufacturing ## Audience - Accountant - Finance manager - Accounts payable ## Tool **Kind:** worksheet **Mode:** editable **Currency:** NGN **Columns:** #### Invoice date **Key:** inv_date **Type:** date #### Payee **Key:** payee **Type:** text #### Payee TIN **Key:** tin **Type:** text #### Nature of payment **Key:** nature **Type:** select **Options:** - Contract or supply - Rent - Professional fees - Interest - Commission - Other #### Gross amount (excl. VAT) **Key:** gross **Type:** number **Format:** currency #### WHT rate (%) **Key:** rate **Type:** number **Unit:** % #### WHT deducted **Key:** wht **Type:** number **Expr:** gross * rate / 100 **Format:** currency #### Net paid before VAT **Key:** net **Type:** number **Expr:** gross - gross * rate / 100 **Format:** currency #### Credit note received **Key:** credit **Type:** select **Options:** - Yes - No **Rows:** **Inv date:** 2026-10-02 **Payee:** Ikeja Steel Suppliers Ltd **Tin:** 00000000-0011 **Nature:** Contract or supply **Gross:** 4500000 **Rate:** 5 **Credit:** Yes **Inv date:** 2026-10-05 **Payee:** Apapa Warehouse Properties **Tin:** 00000000-0012 **Nature:** Rent **Gross:** 1800000 **Rate:** 10 **Credit:** No **Inv date:** 2026-10-09 **Payee:** Eze and Partners Consulting **Tin:** 00000000-0013 **Nature:** Professional fees **Gross:** 950000 **Rate:** 5 **Credit:** Yes **Inv date:** 2026-10-14 **Payee:** Lekki Logistics Ltd **Tin:** 00000000-0014 **Nature:** Contract or supply **Gross:** 2200000 **Rate:** 5 **Credit:** No **Inv date:** 2026-10-18 **Payee:** Abuja Equipment Leasing **Tin:** 00000000-0015 **Nature:** Rent **Gross:** 1200000 **Rate:** 10 **Credit:** Yes **Totals:** #### Total gross **Key:** gross **Agg:** sum **Format:** currency #### Total WHT to remit **Key:** wht **Agg:** sum **Format:** currency #### Total net paid **Key:** net **Agg:** sum **Format:** currency **Summary:** #### Effective WHT rate **Key:** eff **Expr:** sum_wht / sum_gross * 100 **Format:** percent **Primary:** true #### Average gross per payment **Key:** avg_line **Expr:** sum_gross / count **Format:** currency **Notes:** The rates shown are examples only. Confirm the rate for each payment type and payee category against the current Nigerian withholding tax regulations before remitting. WHT is typically computed on the value before VAT. ## Content **Intro:** When a Nigerian company pays a supplier, landlord or consultant it often has to deduct withholding tax and remit it to the tax authority. This worksheet gives the accounts payable team a single schedule of what was deducted, from whom, and whether the supplier received a credit note. **Sections:** #### How to use the worksheet **Body:** Add one row per payment. Enter the invoice date, payee, TIN, nature of payment, the gross amount before VAT and the rate that applies. The sheet computes the tax deducted and the net amount. Mark whether a WHT credit note was issued, and use the totals row for the remittance. Export to Excel for your month end pack or to attach to the remittance request. **Bullets:** - One row per invoice or payment - Use the payee TIN so credit notes can be traced - Review rows with credit note set to No before month end - Export a fresh copy each remittance period #### Method **Body:** Withholding tax is deducted at source as a percentage of the payment value, with rates depending on the type of transaction and the status of the payee. The amount deducted is a credit against the payee's income tax and is remitted by the payer within the statutory deadline. The worksheet applies the rate you enter to the gross amount, so keep your rate list in a separate reference and update it when rules change. #### Reading the result **Body:** The effective rate shows total WHT as a share of gross payments. In the sample data, WHT totals NGN 765,000 on gross payments of NGN 10,650,000, an effective rate of about 7.2 percent, driven by the mix of rent and contract payments. A sharp change in this rate month to month usually means rows are mis-categorised. #### Common mistakes **Body:** Teams apply WHT to the VAT inclusive amount, use the wrong rate for individuals versus companies, forget to issue credit notes, or remit late. In an ERP, set up withholding tax codes on vendors so deduction happens at payment, and use this worksheet to reconcile the schedule to the general ledger. **Cta:** If you want WHT deductions posted and reconciled directly from vendor payments in your ERP, Netray can review the configuration with you. **Faq:** #### Are the rates in the sample correct for my case? **Answer:** They are illustrative. Rates differ by transaction type and payee, and regulations change. Check the current schedule before you deduct, and edit the rate column accordingly. #### Is VAT included in the gross amount? **Answer:** The column is labelled excluding VAT because withholding tax is generally computed on the value before VAT. Confirm the treatment for your transaction with your tax adviser. #### Can I add more rows? **Answer:** Yes. Add and delete rows freely. Totals and the effective rate update automatically, and the whole table exports to Excel or CSV. #### Does it file the return? **Answer:** No. It produces a schedule you can use to prepare the remittance and keep for audit. Filing is done through the tax authority channels. ## Search terms nigeria withholding tax schedule, withholding tax schedule excel nigeria, WHT schedule template nigeria, nigeria WHT remittance schedule, withholding tax worksheet, WHT credit note tracker --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json