Subcontractor + Vendor Tracker (1099)
Every January it's the same: digging through the checkbook to figure out who you paid, how much, and whether you ever got their W-9. This keeps one running list all year — log each payment as you go, and it totals every sub and vendor, flags who crosses the $600 line for a 1099-NEC, and shows you exactly who you're still missing a W-9 from. While they're still answering your calls.
Excel & Google Sheets · one-time purchase · vendor dropdown built in
It knows the edges: the incorporated supplier and the under-$600 vendor are correctly left off.
Missing 1099s and un-collected W-9s are a quiet, avoidable headache — penalties for late filings, a scramble to reconstruct a year of payments, and subs who've moved on and stopped replying. The fix isn't more effort at tax time; it's a list you keep current all year. Log the payment when you make it, collect the W-9 before you pay, and the flags take care of the rest.
What's inside
A one-page guide and the color legend so you know which cells are yours.
Your list of subs and vendors, with W-9 status and whether each is 1099-eligible.
Log every payment — vendor from a dropdown, plus job, amount, and method.
Totals each vendor and flags who needs a 1099-NEC and who's missing a W-9.
The 1099-NEC rules that matter — threshold, exemptions, deadlines — sourced from the IRS.
How it fits together
You're already paying these subs. This just makes sure the paperwork keeps up.
The subcontractor costs you track in the Job-Costing Tracker are the same payments that drive your 1099s. This tool keeps the compliance side in order so tax time is a five-minute export, not a lost weekend.
Get the tool
One running list all year, automatic 1099-NEC and missing-W-9 flags, and the IRS rules that matter — so January is boring. One-time purchase.
Questions
No. It tells you who likely needs a 1099-NEC and flags missing W-9s so you're organized — it doesn't file anything, and it isn't tax advice. File the flagged forms yourself or hand the list to your accountant.
Generally each individual or unincorporated business you paid $600 or more for services during the year. Corporations are usually exempt (with exceptions like attorneys). You mark each vendor's eligibility and the tool applies the $600 threshold.
Card and third-party-network payments are reported by the processor on a 1099-K, so you don't report those on a 1099-NEC. The Reference tab explains it; mark card-only vendors so you don't double-report.
Both. No macros — open it in Excel or free in Google Sheets. The payment log even has a dropdown of your vendors.
It ships ready for 10 vendors and 20 logged payments, which covers a typical remodeler's year, and you can add rows as you grow.