To track contractor payments in a spreadsheet, keep two linked sheets—a Contractor directory (legal name, TIN, address, entity type, W-9 status) and a Payment log (date, contractor, amount, method, invoice #, project, tax year)—plus a YTD rollup that flags who is approaching Form 1099-NEC. For payments made in 2026, the IRS general threshold for nonemployee compensation is $2,000 (it was $600 for payments made before 2026). Still file if you withheld any backup withholding. Log the payment method carefully: some card and third-party network payments may be reported on Form 1099-K instead of your 1099-NEC. Run the sheet year-round and export the $2,000+ list in January.
Research note: Educational guide for US small-business payers. Not tax, legal, or accounting advice. Rules and state thresholds can differ—confirm with a CPA or tax pro and the current IRS instructions before you file. This page may include affiliate links to Melio and Gusto; we may earn a commission at no extra cost to you. IRS 1099-NEC threshold facts below were checked on IRS.gov on 2026-09-29.
Who this spreadsheet is for (and who should skip it)
Takeaway: Use a spreadsheet when you pay a handful of freelancers or subs and still want clean 1099 data; skip it once volume, approvals, or multi-entity complexity outgrow one owner’s Sheets habit.
This guide is for the payer—the LLC, S corp, or sole prop that hires independent contractors and must decide who gets a Form 1099-NEC. It is not a freelancer income log for Schedule C (plenty of those exist). If you already run contractors inside Gusto or a full AP stack, keep reading only for the column checklist and threshold math; you may not need a second system.
A spreadsheet fits when you have roughly 1–15 active contractors, payments are ACH/check/wire (or a mix you can classify), and one person can own the file. It breaks down when three people edit competing copies, when you need bill approvals before money moves, or when January filing means reconstructing Venmo history from screenshots. For the broader payment options landscape, see best ways to pay 1099 contractors without payroll software and our bill pay hub.
The three tabs you actually need
Takeaway: Directory, Payment log, and Threshold dashboard are enough; add more tabs only after those three are trustworthy.
Excel and Google Sheets both work. Prefer Sheets if two people need concurrent access; prefer Excel if your CPA wants a frozen .xlsx export. Either way, freeze the header row, protect formula columns, and store the file in a backed-up drive—not on one laptop Desktop folder named “final-FINAL-v3.”
- Directory: one row per contractor. This is where W-9 data lives so you never retype a TIN in January.
- Payment log: one row per payment. Same-day entry is the whole system.
- Threshold: one row per contractor with YTD total, distance to $2,000, and a file/do-not-file flag for the current tax year.
Column-by-column blueprint
Takeaway: Capture legal name, TIN, address, W-9 status, and every payment’s date/amount/method—those fields map straight to Form 1099-NEC.
Directory tab
| Column | Why it matters | Example / tip |
|---|---|---|
| Contractor ID | Stable key for SUMIF / joins | C-014 |
| Legal name (as on W-9) | Must match Form 1099-NEC | River Design Studio LLC |
| DBA / preferred name | What invoices show | River Design |
| TIN type | SSN vs EIN formatting | EIN |
| TIN (last 4 displayed) | Full TIN in a locked column or password vault—not Slack | ****1234 |
| Address (street, city, ST, ZIP) | Required for filing / recipient copy | From W-9 line 5–7 |
| Entity type | Corp vs LLC tax classification affects whether you usually file | LLC taxed as partnership |
| W-9 status | Gate before first payment | On file / Requested / Missing |
| W-9 date received | Audit trail | 2026-01-12 |
| Default payment method | Helps method exclusions later | ACH |
| Active? (Y/N) | Hide old vendors from daily view | Y |
| Notes | Exceptions (foreign payee, attorney, etc.) | See tax pro |
Payment log tab
| Column | Why it matters | Example / tip |
|---|---|---|
| Payment ID | Unique row key | P-2026-0088 |
| Payment date | Tax year = calendar year of payment | 2026-03-20 |
| Contractor ID | Links to Directory | C-014 |
| Amount (gross) | Box 1a nonemployee compensation base | 1200.00 |
| Currency | Keep USD unless you have FX process | USD |
| Payment method | NEC vs possible 1099-K path | ACH / Check / Wire / Card / PayPal / Venmo / Other |
| Invoice # | Reconcile to AP / bank | INV-441 |
| Project / job | Ops visibility, not IRS-required | Website redesign |
| Bank confirmation / check # | Proof if totals disagree later | ACH 982331 |
| Counts toward 1099-NEC? (Y/N) | Manual override for method exclusions | Y |
| Tax year | =YEAR(payment date) formula | 2026 |
| Entered by / timestamp | Discipline when multiple editors | auto |
Threshold dashboard tab
Build one summary row per active contractor for the current tax year:
- YTD NEC total —
SUMIFSof Amount where Contractor ID matches, Tax year = 2026, and Counts toward 1099-NEC = Y - Distance to threshold —
MAX(0, 2000 - YTD)for 2026 payments - Flag — “Monitor” under $1,500; “Likely file” at $1,500–$1,999.99; “File 1099-NEC” at $2,000+; “Backup withholding” if any Box 4 withholding occurred (file regardless of amount)
- W-9 OK? — pull status from Directory; block “File” rows that still say Missing
2026 Form 1099-NEC threshold: what to put in the dashboard
Takeaway: For payments made in 2026, plan around a $2,000 Form 1099-NEC threshold for nonemployee compensation—and verify the current IRS instructions before you file.
According to the IRS page Am I required to file a Form 1099 or other information return?, for payments made before 2026 the reporting threshold is $600; for payments made in 2026 the reporting threshold is $2,000; for payments after 2026, see Publication 1099 for any inflation-adjusted figure. The December 2026 Instructions for Forms 1099-MISC and 1099-NEC likewise state that for tax years beginning after 2025 the minimum threshold for certain information returns increased to $2,000 and may be adjusted for inflation beginning in calendar year 2027.
Put that number in a single Settings cell (for example Threshold_2026 = 2000) and reference it in your Flag formulas. Do not hard-code “600” across fifty rows—many free templates on the open web still do, which is why your workbook should win on accuracy for 2026 payments.
Two caveats that belong in the sheet notes:
- Backup withholding: If you withheld federal income tax under the backup withholding rules, you generally must file Form 1099-NEC for that person regardless of the payment amount.
- Entity type: Payments to many corporations are not reported the same way as payments to individuals/LLCs—but payments for legal services and certain other categories have special rules. When entity type is “C corp” or “law firm,” add a note and confirm with your tax pro before you skip a form. Our Do I need to 1099 an LLC? guide covers the LLC classification questions owners ask most.
For filing mechanics once the list is clean, use how to file 1099-NEC and the tax compliance pillar. Worker status questions belong in W-2 vs 1099—do not use the payment tracker as a classification tool.
Payment methods: what counts toward your 1099-NEC
Takeaway: Track every payment, but mark Counts toward 1099-NEC carefully—card and some third-party network settlements often follow Form 1099-K rules instead of your NEC filing.
Your spreadsheet should still log every contractor payment for cash control. The IRS reporting path can differ by rail:
| Method (typical) | Usually log in sheet? | Often counts toward payer’s 1099-NEC? | Notes |
|---|---|---|---|
| ACH / bank transfer | Yes | Yes (if services + threshold met) | Common Melio / bank bill-pay path |
| Paper check | Yes | Yes | Record check # |
| Wire | Yes | Yes | Watch FX fees vs gross paid |
| Business credit card to contractor | Yes (cash control) | Often No for NEC—processor may issue 1099-K | Confirm with tax pro; still need W-9 discipline |
| PayPal / Venmo / similar (business) | Yes | Often No for NEC when treated as third-party network | Do not assume “app = ignore forever” |
| Cash | Yes | Yes (if services) | Highest audit/friction risk—prefer bank rails |
If you pay vendors by card for float or rewards, that is an AP decision as much as a tax one—see pay vendors with credit card and Can you pay contractors with Melio? Melio’s ACH/check rails are a common way to keep contractor pay on bank methods your NEC log can treat cleanly; public fee context is in Melio pricing.
Operating cadence: same-day log, quarterly audit, January export
Takeaway: The sheet only works if you log payments the same day you send them, not sometime before tax season.
- Before payment #1: W-9 requested and preferably on file. No TIN fishing in December.
- Same day as payment: Add the Payment log row; attach or link the invoice PDF if you use Drive folders named by Contractor ID.
- Weekly (optional): Reconcile log totals to bank/Melio export for that week.
- Quarterly: Sort Threshold by YTD. Anyone over ~$1,500 gets a W-9 completeness check. Fix address typos while people still answer email.
- January: Filter Flag = File 1099-NEC. Export CSV/xlsx for your e-filer or CPA. Federal recipient and IRS copies are generally due by January 31 for Form 1099-NEC—confirm the current year’s IRS due dates. If you file 10 or more information returns, e-filing rules apply (see IRS information-return guidance).
Pair this cadence with a light AP checklist if vendors and contractors share the same bank account clutter—our accounts payable checklist and bill approval workflow guides help when more than one person can approve spend.
When to graduate from a spreadsheet
Takeaway: Keep Sheets while the log is clean and small; move to Melio for payment rails, Gusto for contractor pay + 1099 workflow, or your ledger when approvals and volume demand it.
| Signal | Stay on spreadsheet | Graduate to… |
|---|---|---|
| Contractor count | ~1–15, one owner edits | Gusto (or similar) when you want pay + forms in one product |
| Pain | “I forget who I paid in June” | Melio / bank bill pay when sending ACH/checks is the chore |
| Approvals | Owner pays from one card/bank login | AP workflow + Melio or QBO Bill Pay when managers approve first |
| Books | Export CSV to accountant quarterly | QuickBooks / Xero / Wave bill + vendor records when volume is weekly |
| Filing | CPA e-files from your export | Payroll/contractor platform that files 1099s for you |
If the bottleneck is sending clean ACH or mailed checks to contractors and vendors, try Melio and keep exporting payment history into your log (or retire the log once Melio + your ledger cover the audit trail). If the bottleneck is running contractor payments and 1099 season inside a payroll-style product, compare Gusto using our how to pay contractors with Gusto walkthrough. For stack comparisons more broadly, browse the comparisons and payroll hubs.
Common mistakes that break January filing
Takeaway: Most 1099 emergencies are data problems created in March–November, not form problems created in January.
- Paying before the W-9 arrives. You can still request it—but leverage drops after money moves.
- Using the invoice “nickname” as the legal name. File with the W-9 legal name / TIN pair.
- One cell for “total paid” that you overwrite monthly. History must be row-based or January math fails.
- Ignoring method exclusions—or over-excluding. Blindly marking everything “N” undercounts; blindly marking card payouts “Y” can double-count with 1099-K paths. When unsure, ask.
- Mixing employees and contractors in one unpaid “people” tab without a type column. W-2 wages do not belong in NEC YTD.
- Leaving TINs in plaintext email or shared Slack screenshots. Keep full TINs in a locked column or password manager; show last-4 in the working view.
- Still filtering the dashboard at $600 for 2026 payments. Update the Settings cell to $2,000 for 2026 calendar-year payments (and re-read IRS instructions each January).
FAQ: tracking contractor payments in a spreadsheet
What is the best spreadsheet to track contractor payments?
The best one is the workbook you will actually update the same day you pay. Excel or Google Sheets both work if they include a Directory, a Payment log, and a Threshold dashboard with SUMIF/SUMIFS. Complete W-9 fields and honest payment-method flags matter more than a polished chart tab.
What is the Form 1099-NEC threshold for 2026 payments?
Per IRS guidance checked 2026-09-29, for payments made in 2026 the Form 1099-NEC reporting threshold is generally $2,000 (it was $600 for payments made before 2026). You must also file if you withheld backup withholding, regardless of amount. Confirm the instructions for the year you are filing.
Do I still need a W-9 if I use a spreadsheet?
Yes. The spreadsheet stores what the W-9 already proved. Without a W-9 (or equivalent TIN documentation), you risk backup withholding issues and January mailings that bounce. Start with collect W-9 from contractor.
Should I track employees and contractors in the same sheet?
Only if you have a hard Type column (W-2 vs 1099) and the Threshold formulas ignore W-2 rows. Most small teams keep contractors in this workbook and employees inside payroll software.
Do credit card payments to contractors go on Form 1099-NEC?
Often card and certain third-party network payments are reported on Form 1099-K by the processor rather than on your Form 1099-NEC—but you should still log them for cash control and confirm treatment with your tax pro. Confirm with your tax pro rather than relying on an old forum thread.
Can I use Google Sheets instead of Excel?
Yes. Use the same three-tab design. Turn on version history, restrict TIN columns, and export a frozen .xlsx or CSV for your CPA in January.
When should I switch from a spreadsheet to Gusto or Melio?
Switch payment rails to Melio (or similar) when sending ACH/checks is the weekly chore. Switch contractor ops to Gusto (or similar) when you want payments plus 1099 filing assistance in one product—or when multiple people need permissions a Sheet cannot safely provide.
What do I need to file Form 1099-NEC in January?
For each contractor you must file for: legal name, address, TIN, and Box 1a nonemployee compensation total for the calendar year (plus any backup withholding). Your Threshold export should produce that list; filing steps are in how to file 1099-NEC.
Related reading and next step
If classification is still fuzzy, read W-2 vs 1099 before you automate anything. If LLC payees confuse your Directory entity column, use Do I need to 1099 an LLC? For paying without mailing paper checks, see how to pay business bills online without mailing checks.
Next step: Create the three tabs today, paste last quarter’s contractor payments into the log, and request any missing W-9s this week. When you are ready to send cleaner ACH or check payments while you keep (or retire) the log, start with Melio. When you want contractor payments and 1099 workflow inside a payroll-style platform, start with Gusto. Then file from a complete list—not from inbox search—using how to file 1099-NEC.