1099 Vendor Tracking Template (W-9 Collection)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A 1099 vendor tracker is the list that tells accounts payable which vendors get a Form 1099-NEC or 1099-MISC, which ones are exempt, and whose Form W-9 is still missing. It is needed every January, and again whenever the auditor or the IRS asks how the company decided who was reportable. For payments made in 2026, the IRS instructions raise the main threshold from $600 to $2,000.
The workbook classifies each vendor by formula from three inputs: the tax classification on the W-9, the payment category and the amount paid by check, ACH or wire. Thresholds, forms and boxes sit in a settings table built from the Instructions for Forms 1099-MISC and 1099-NEC (Rev. December 2026) and the Form W-9 instructions, so a change next year means editing one table.
Who it is for
The accounts payable lead or controller who has to file Forms 1099 in January and does not know which vendors are reportable or which W-9s are missing.
What is inside
- Vendor Register with 12 worked vendors and 24 blank formatted rows
- Settings sheet with 8 payment categories, each with form, box and threshold, prefilled from the December 2026 instructions
- Form result by formula: 1099-NEC, 1099-MISC, below threshold, exempt corporation, not reportable or W-8 review
- Card and payment network payments kept out of the reportable amount, because they are reported on Form 1099-K
- Action column that flags missing W-9s on reportable vendors in red and requests in amber, plus days outstanding
- Summary sheet with counts and totals per form, W-9 coverage, an e-file check and the filing dates for the tax year
- Backup withholding rate as an input cell with the Form W-9 source
How to use it
Confirm the thresholds on the Settings sheet against the current IRS instructions, then enter each vendor with its W-9 status and payments to date.
Files
- XLSX1099-vendor-tracking-template.xlsx17 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What is the 1099 reporting threshold for 2026?
The Instructions for Forms 1099-MISC and 1099-NEC (Rev. December 2026) say the minimum threshold for certain payments increased to $2,000 for tax years beginning after 2025, and may be adjusted for inflation from 2027. Some amounts stay lower, such as $10 for royalties and $600 for gross proceeds paid to an attorney. Always check the current instructions.
Do payments to corporations need a Form 1099?
Generally no, but the instructions list exceptions. Attorneys' fees are reported on Form 1099-NEC even when the law firm is a corporation, and medical and health care payments and gross proceeds paid to an attorney are reported on Form 1099-MISC. The tracker applies these exceptions by payment category.
When are Forms 1099-NEC and 1099-MISC due?
Form 1099-NEC is furnished to the recipient and filed with the IRS by January 31. Form 1099-MISC is furnished to the recipient by January 31 and filed by February 28 on paper or March 31 electronically. A date that falls on a weekend or legal holiday moves to the next business day. The summary sheet works out the dates for the tax year you enter.




