The federal 1099-NEC threshold for payments made in 2026 is $2,000, up from $600 (IRS). That means more tracking, not less: you still need to know, payment by payment, who will cross the line by December 31, who never sent a W-9, and which payments do not count at all.
Covers Form 1099-NEC only. It does not track 1099-MISC items such as rent, royalties, or gross proceeds paid to an attorney (still $600).
What it does
- Contractors tab: entity type, legal services flag, W-9 status and date, last 4 of TIN only, state. Each contractor gets a federal status (File 1099-NEC, File 1099-NEC (tax withheld), Approaching, Corporation – not reported, Below threshold) plus State check and W-9 check flags.
- Payments tab (1,000 rows): date, contractor dropdown, amount, method and what it was for. Left out of the 1099-NEC total: the IRS says card and third-party network payments are not reported on 1099-NEC. The card company or network reports them on Form 1099-K only if its own thresholds are met (for networks, over $20,000 and over 200 transactions). These payments are shown separately. Goods are left out, “Other (check)” waits for your decision, payments from another year are flagged, and names that don’t match a contractor are flagged.
- Monthly tab: counted payments per contractor by month.
- Dashboard: forms to file, contractors approaching, missing W-9s, state checks, backup withholding, the due date (Monday, Feb 1, 2027, because Jan 31, 2027 is a Sunday) with a countdown, and an e-file reminder.
- Filing List tab: every contractor to file, with box 1a and box 4 totals, ready in January.
- Settings: tax year, federal threshold, optional state threshold (state rules vary; you enter yours), warning level, due date.
- Every rule in the file cites its IRS source (Instructions for Forms 1099-MISC and 1099-NEC, Rev. December 2026; Publication 1099 (2026); IRS “Am I required to file a Form 1099” page).
What’s included (instant download)
- 1099-Contractor-Payment-Tracker-2026.xlsx (7 tabs, room for 100 contractors and 1,000 payments)
- Quick-start guide (PDF, 4 pages) with sources
- Note for importing into Google Sheets
Good to know
- Example data in yellow rows shows every status; delete it before use.
- Tested in LibreOffice only (0 errors with example data, blank, a full 100-contractor / 1,000-payment fill, and a changed threshold; totals matched an independent calculation). Uses common functions only, but not tested by the maker in other spreadsheet apps.
- This is a record-keeping tool, not tax or legal advice. It does not file forms, does not decide whether a worker is a contractor or an employee, and has no built-in state rules. Confirm filing decisions with the current IRS instructions or a tax professional.
- Digital download only. Licensed for use in your own business.
How this was made: Workbook structure, formulas, guide and wording were built with AI assistance and checked by recalculating in LibreOffice against an independent calculation. The tax rules are taken from the IRS documents named above, opened on 14 Nov 2026, and quoted rather than paraphrased where it matters.



Reviews
There are no reviews yet.