Which Contractors Need a 1099-NEC? A Threshold Test With a Worked Example
You have a list of everyone you paid this year and a nagging feeling that some of them need a form. The question “which contractors need a 1099-NEC” comes down to a short test you can run on each person in about a minute, and a spreadsheet can run it on all of them at once.
This is a record-keeping walkthrough, not tax advice. Thresholds and exceptions change, so confirm the current rules for your filing year with the IRS or your accountant.
The four-question test
For each person or business you paid, ask:
- Did I pay them for services in the course of my business? Personal payments are generally out of scope.
- Are they a corporation? Payments to corporations are often exempt, with notable exceptions such as attorneys. Check the entity type on their W-9.
- Did I pay them by card or through a payment app? Those payments are generally reported by the processor, so they come off your total.
- Does the remaining total for the calendar year reach the threshold? For this example we assume $2,000, and the figure lives in one spreadsheet cell so you can change it.
Only someone who passes all four gets a form.
Worked example: five contractors
Fictional numbers, assumed $2,000 threshold:
| Contractor | Entity | Paid | Method | Reportable total | Result |
|---|---|---|---|---|---|
| Maya Ortiz | Sole proprietor | 4 × $750 | ACH | $3,000 | Form required |
| Tom Reyes | Sole proprietor | 6 × $350 | Check | $2,100 | Form required |
| Priya Shah | Sole proprietor | 12 × $150 | ACH | $1,800 | Below threshold |
| Jordan Lee | Sole proprietor | $1,400 + $900 | ACH + card | $1,400 | Below threshold |
| Harbor Law | Law firm | $5,000 | Check | $5,000 | Form required |
Two results surprise people. Tom’s payments are small individually, but the yearly total is what counts, so he crosses the line. Jordan was paid $2,300 in all, but $900 went through a credit card, so the amount you would report is only $1,400 and he stays below.
The formulas
Assume the ledger has contractor in column B, amount in C, method in D, and a helper column F holding the reportable amount:
=IF(OR(D2="Credit card",D2="PayPal G&S",D2="Venmo business",D2="Stripe"),0,C2)
On a summary tab, total per contractor:
=SUMIFS(Ledger!F:F,Ledger!B:B,A2)
Then test against the Settings cell:
=IF(B2>=Settings!$B$2,"Form required","Below threshold - no form")
Copy the formula down the roster and you have a verdict for everyone. Change the threshold cell and every verdict re-decides itself.
Common mistakes
- Testing each payment instead of the yearly total. The threshold is cumulative.
- Counting card payments. They inflate your total and can cause a duplicate report.
- Ignoring attorneys. The corporation exemption does not generally cover legal services, so a law firm can still need a form.
- Not recording the entity type. Without it you cannot defend an exemption.
- Forgetting the W-9. Knowing a form is required is only half the job. You need the legal name and taxpayer ID to file it. If one is missing, see what to do when a contractor has not sent a W-9.
Copy-ready year-end checklist
- Export every payment from your bank, cards and payment apps.
- Group payments by payee.
- Tag each payment with its method.
- Remove card and payment-app payments from the reportable column.
- Total by payee and compare with the threshold.
- Record entity type and W-9 status for every payee over the line.
- Request any missing W-9 immediately.
- Put the filing deadline on your calendar.
The full build, with the roster, ledger and verdict columns wired together, is covered in the main guide: 1099 contractor payment tracker spreadsheet for Excel and Google Sheets.
The 1099 Contractor Payment Tracker runs this exact test automatically: it categorises each payment, excludes card and payment-app amounts, and gives each contractor a plain-English verdict such as “Threshold met - 1099-NEC required” or “Below threshold - no form required”. It works in Excel and Google Sheets.
Featured on ReadySheetGo
1099 Contractor Payment Tracker — $16.99
A threshold engine that reaches a verdict for every contractor, plus a missing-W-9 chase list. Works in Excel and Google Sheets.
General information only, not tax, legal or accounting advice.
Frequently Asked Questions
Which contractors need a 1099-NEC?
Generally, the people and unincorporated businesses you paid for services in the course of your business, once the total paid to them during the calendar year reaches the reporting threshold. Payments to corporations are often exempt, with notable exceptions such as attorneys, and card or payment-app payments are reported by the processor instead. Confirm the current threshold and exceptions with the IRS or your accountant.
Is the 1099 threshold per payment or per year?
Per year, per contractor. You add up everything you paid one contractor in the calendar year and compare the total with the threshold. Six payments of $350 total $2,100 and cross a $2,000 threshold even though each payment is small.
Do I send a 1099 if I paid someone less than the threshold?
Usually no form is required below the threshold, but keep the payment records and the W-9 anyway. Totals can change if you pay the same contractor again before year end, and records support your business deductions.
What if I do not know whether a contractor is a corporation?
Ask for a W-9. It states the entity type and taxpayer ID, so you are deciding from evidence rather than guessing. A tracker with an entity-type column on the roster makes the exemption call visible at year end.