Excel workbook previewProcure-to-pay and accounts payable
Vendor Onboarding Form and Checklist
3 free downloads per account. Just your email and a 6-digit code.
About this template
Vendor onboarding is the gate between a supplier someone wants to use and a record in the vendor master that the payment run will pay. Fake vendors, duplicate records and hijacked bank details all enter through this gate, so auditors and insurers ask to see how it is controlled. The form captures the facts and the checklist proves each check was done by someone other than the person who pays.
This Excel workbook has a Vendor Form with live checks, a 33 item Onboarding Checklist in six groups, a Vendor Register for tracking requests and a Summary sheet. The tax steps follow IRS guidance for Form W-9, Forms W-8BEN and W-8BEN-E, TIN Matching, backup withholding and Form 1099-NEC. The bank detail steps follow FBI IC3 advice to verify account information through a separate channel.
Who it is for
The accounts payable lead or controller asked to show how new suppliers are vetted before the first payment, after a fake vendor or a bank detail fraud.
What is inside
- Vendor Form sheet with 30 fields in 6 sections, filled with a worked example supplier
- Live form checks: tax form needed, Form 1099 tracking, backup withholding and a ready to activate gate
- Onboarding Checklist with 33 items in 6 groups, a status dropdown and a required items gate
- Vendor Register with 10 worked onboarding requests plus 20 blank rows
- Register formulas for days to onboard and a control check that flags vendors activated without verified bank details
- Summary sheet with live counts by status, average days to onboard and checklist completion by group
- Built on IRS guidance for Forms W-9, W-8BEN, W-8BEN-E and 1099-NEC and on FBI IC3 business email compromise advice
How to use it
Fill the Vendor Form for one supplier, then work through the Onboarding Checklist before the vendor is activated.
Files
- XLSXvendor-onboarding-form-and-checklist.xlsx20 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What information do you need to onboard a new vendor?
You need the legal name and tax classification from a signed Form W-9, or Form W-8BEN or W-8BEN-E for a foreign payee, the remittance address, a contact, bank details confirmed through an independent channel, the payment terms and the business need. Many organizations also screen the name against the OFAC sanctions list and check for conflicts of interest before activation.
Why verify vendor bank details by phone?
Business email compromise schemes send fake bank details from real or lookalike email accounts. The FBI's IC3 advises using secondary channels to verify requests for changes in account information. A call to a number from an independent source, never the number in the request, confirms the account belongs to the vendor before the first payment is made.
Which vendors need a Form 1099-NEC?
Generally, a business that pays a non-employee for services in the course of its trade or business reports the payments on Form 1099-NEC once they reach the threshold. The IRS instructions set USD 2,000 for tax years beginning after 2025. Payments to C or S corporations are generally exempt, except payments for legal services. Check the current instructions on irs.gov.




