What it is
Preparing Forms 1099 starts with payments by payee. This schedule totals quarterly payments, removes card payments, applies your threshold and shows who needs a form.
It also shows payees with no Form W-9 and estimates backup withholding exposure at the rate you enter.
When to use it
- In December and January.
- When reviewing a vendor ledger.
- When setting up a client’s contractor process.
What’s inside
- Payees tab with 80 rows
- Threshold and rate inputs with sources in the Legend
- Form needed and W-9 action columns
- Summary and tie-outs
Standard cited
This template follows Forms 1099-NEC / 1099-MISC. 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
What is the threshold?
The IRS states $2,000 for Forms 1099-NEC and 1099-MISC for payments made after December 31, 2025, indexed from 2027. It was $600 before. The workbook starts at $2,000 and you can change it.
Why exclude card payments?
Payments made by credit card or a payment network are reported by the payment settlement entity. Confirm the rule in the IRS instructions.
Is the withholding rate fixed?
IRS Publication 15 gives 24%. Confirm the rate each year.
Related templates
- Form 1099 Vendor Tracker (Excel)
- Form W-9 Collection and Backup Withholding Procedure
- Year-End Payroll and 1099 Close Checklist
- Worker Classification Worksheet: Employee or Contractor
Last updated 11/06/2026. All free templates.