What it is
Year-end 1099 work is easier when W-9s are collected as vendors are set up and payments are tracked all year. The tracker holds both.
Each vendor row records the W-9 date, TIN match result, entity type, exempt status and the form and box, with payments by quarter. A reportable test uses the threshold you enter, backup withholding to consider shows for non-exempt vendors with no W-9, and furnished and filed dates give status flags. Enter the threshold, rate and due date from the IRS instructions for the year.
When to use it
- Vendor onboarding and monthly payment review.
- Year-end 1099-NEC and 1099-MISC preparation.
- Cleaning up missing W-9s before January.
What’s inside
- 60 vendor rows with TIN, entity, form and quarterly payments
- Reportable test and backup withholding formulas
- Furnished, filed and late flags
- Summary of counts and totals
Standard cited
This template follows IRC 6041 / 6041A. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.
Questions
Where do the threshold and due date come from?
The IRS instructions for Forms 1099-NEC and 1099-MISC for the payment year. They are inputs because they change.
Are card payments included?
Payments by credit or debit card or a payment network are reported by the processor on Form 1099-K. Enter only payments that are yours to report.
Are corporations exempt?
Most are, with exceptions such as attorneys. Check the instructions before marking a payee exempt.
Related templates
- Payroll Tax Reconciliation (Form 941 to GL)
- AR and AP Aging Report Template
- Business Tax Return Review Checklist
- Tax Extension and Due Date Tracker (Excel)
Last updated 11/05/2026. All free templates.