1099 Contractor Payment Tracker Spreadsheet for Excel and Google Sheets
It is Q4. You paid a handful of contractors this year, a designer here, a handyman there, maybe an attorney, and you just realised that January is coming and you have no idea who you owe a 1099 to. You are also fairly sure you never collected a W-9 from at least two of them.
A 1099 contractor payment tracker spreadsheet fixes this by answering two questions all year long: who do I owe a form to, and do I have their tax ID? This guide shows exactly how to build one in Excel or Google Sheets, with a fully worked example you can copy.
A note before we start: this guide organises your own payment records. It is not tax, legal or accounting advice, and it files nothing for you. Thresholds, rates and deadlines change, so confirm the current figures for your filing year with the IRS or your accountant.
Why a plain ledger is not enough
Most people start by typing contractor payments into a list. That records money. It does not tell you what to do about it, and the questions that matter are all calculations:
- What is the total paid to each contractor for the year?
- Has that total crossed the reporting threshold?
- Do I hold a W-9 for everyone who crossed it?
- Which payments are reported by someone else (a card or payment app) and must stay off my form?
- What is the total for each box on the form?
A tracker answers all of these with formulas, so nobody has to add columns at 11pm on January 30th.
The five tabs you need
You can build a useful tracker with five tabs.
1. Settings. Put every rule that can change in its own cell: the reporting threshold, your backup withholding rate, your tax year, and your filing deadline. Nothing is hard-coded anywhere else, so when a rule changes you update one cell and every verdict re-decides itself.
2. Contractor Roster. One row per contractor: legal name, business name, entity type (sole proprietor, LLC, corporation, attorney), W-9 on file (Yes/No), taxpayer ID on file (Yes/No), and mailing address.
3. Payment Ledger. One row per payment: date, contractor, amount, payment method, and category. Two helper columns do the work: Reportable amount (the amount, or zero if the payment method is a card or payment app) and Box (which form box the category belongs in).
4. 1099 Determination. One row per contractor with the running total, a threshold test and a plain-English verdict.
5. W-9 Chase List. Everyone over the threshold whose W-9 is missing, with the follow-up date and the withholding exposure.
Worked example: six contractors, one year
All names and numbers below are fictional and the threshold is an assumption set in Settings: $2,000 per contractor per year, with a 24% backup withholding rate. Confirm the figures for your own year.
Here is the ledger summarised by contractor:
| Contractor | Service | Paid by | Total paid | W-9 on file |
|---|---|---|---|---|
| Maya Ortiz | Graphic design | ACH, 4 × $750 | $3,000 | Yes |
| Tom Reyes | Handyman | Check, 6 × $350 | $2,100 | No |
| Priya Shah | Bookkeeping | ACH, 12 × $150 | $1,800 | Yes |
| Lakeside Media | Marketing | PayPal goods & services | $4,500 | Yes |
| Jordan Lee | Video editing | ACH $1,400 + credit card $900 | $2,300 | Yes |
| Harbor Law | Legal fees | Check | $5,000 | Yes |
Total paid across all six contractors: $18,700.
Step 1: strip out payments someone else reports
If you pay by credit card, debit card, or through a third-party payment network such as PayPal goods and services, Venmo business or Stripe, those payments are generally reported by the payment processor, not by you. Putting them on your own form as well would report the same money twice.
In the ledger, add a Reportable amount column. Suppose the payment method is in column D and the amount in column C:
=IF(OR(D2="Credit card",D2="PayPal G&S",D2="Venmo business",D2="Stripe"),0,C2)
In our example that removes Lakeside Media’s $4,500 and Jordan Lee’s $900 card payment, a total of $5,400, leaving $13,300 that is genuinely yours to report.
Step 2: total each contractor’s reportable payments
On the Determination tab, with contractor names in column A:
=SUMIFS(Ledger!F:F, Ledger!B:B, A2)
Where column F is the Reportable amount. The results: Maya $3,000, Tom $2,100, Priya $1,800, Lakeside $0, Jordan $1,400, Harbor $5,000.
Step 3: run the threshold test
Compare each total to the Settings cell. The threshold applies to the yearly total, not to any single payment, which is why Tom’s six $350 payments matter even though none looks big:
=IF(C2>=Settings!$B$2, "Over", "Below")
Maya, Tom and Harbor are over. Priya is below at $1,800. Jordan paid $2,300 in total, but only $1,400 is reportable because $900 went through a card, so he is also below. Lakeside is at $0 reportable.
Step 4: turn the number into a sentence
A number does not tell you what to do. A verdict does:
=IF(C2<Settings!$B$2,"Below threshold - no form required",IF(E2="No","THRESHOLD MET BUT NO W-9 ON FILE","Threshold met - 1099-NEC required"))
Where column E is “W-9 on file”. The Determination tab now reads: Maya, form required; Tom, threshold met but no W-9 on file; Priya, no form; Lakeside, no form; Jordan, no form; Harbor, form required.
That is 3 forms out of 6 contractors, and one of them, Tom, is a problem.
Step 5: price the missing W-9
If a contractor over the threshold never provides a taxpayer ID, you may be required to apply backup withholding. Put the rate in Settings and calculate your exposure:
=IF(AND(D2="Over",E2="No"),C2*Settings!$B$3,0)
Tom: $2,100 × 24% = $504 that you could be on the hook to withhold and send to the IRS. That number is what makes people pick up the phone. Add a date first requested column and a follow-up date (=F2+14, for a 14-day chase window) and the chase list builds itself.
Step 6: total the boxes
Each category belongs in a form box. Nonemployee compensation, which covers most services, goes in one box; rents, royalties and other categories go elsewhere, and attorney payments have their own treatment (an attorney’s own fee is different from settlement money passing through an attorney). Build a small mapping table of category to box, then use SUMIFS to total each box. In our example, Maya ($3,000), Tom ($2,100) and Harbor Law’s fee ($5,000) total $10,100 of nonemployee compensation, ready to transcribe once Tom’s W-9 arrives.
What else is worth tracking
Once the core works, a few additions pay for themselves:
- Entity type. Payments to corporations are often exempt from this reporting, with notable exceptions such as attorneys. Record the entity type from the W-9 so you can make the call with evidence.
- E-delivery consent. If you plan to send forms electronically, record that the contractor agreed.
- Deadline countdowns. A cell with
=Settings!B4-TODAY()turns your filing date into a live “days left” counter. - A year-end checklist. Collect missing W-9s, reconcile the ledger to your bank statements, confirm card payments are excluded, total the boxes, and file and furnish the forms by the deadline.
- A multi-year archive so next January starts from this January.
A 10-minute year-end check you can copy today
- List every person or business you paid for services this year. Pull from your bank, card and payment-app statements.
- Mark who is a corporation, who is not, and who is an attorney.
- For each, mark whether you hold a signed W-9.
- Total payments by contractor, excluding card and payment-app payments.
- Circle anyone at or over the threshold.
- Circle anyone circled in step 5 with no W-9, and send the request today.
- Write your filing deadline on the calendar.
If you want to go deeper on any of these steps, these guides take each one on its own:
- Which contractors need a 1099-NEC? A threshold test with a worked example
- Contractor has not sent a W-9: backup withholding and a chase list
- Paid a contractor by credit card or PayPal: do I still send a 1099?
- Contractor or employee? A checklist for small business owners
Skip the build
If you would rather not build and debug all of this, the 1099 Contractor Payment Tracker has it done: 12 linked tabs including a Dashboard, a 50-contractor roster, a 250-row payment ledger that categorises itself, a 1099 Determination tab with a plain-English verdict for every contractor, a W-9 chase list with follow-up dates and priced withholding exposure, box-by-box totals, a filing checklist with live countdowns, ten automatic year-end checks, a 15-question worker classification self-check, and a multi-year archive. It handles the card and payment-app exclusion automatically, ships with a complete fictional sample year, and works in Excel and Google Sheets with no macros or add-ons.
Featured on ReadySheetGo
1099 Contractor Payment Tracker — $16.99
Enter your payments and the file tells you who needs a 1099, who is missing a W-9, and how much withholding is at risk. Works in Excel and Google Sheets.
The bottom line
A 1099 contractor payment tracker earns its place by turning a pile of payments into decisions. Keep every rule in a Settings tab, strip out card and payment-app payments, total each contractor against the threshold, and let a verdict column say who needs a form. Chase every missing W-9 the day you notice it, because the cost of waiting shows up as withholding exposure. Build it from the formulas above or start from a finished template, but start before January.
This article is general information, not tax, legal or accounting advice. Confirm current thresholds, rates and deadlines with the IRS or a qualified professional.
Frequently Asked Questions
What should a 1099 contractor payment tracker include?
At minimum: a roster of every contractor with legal name, entity type, and whether you hold a signed W-9; a payment ledger with date, amount, payment method and category; a per-contractor total that compares the yearly sum to the reporting threshold; and a list of missing W-9s. Better trackers also separate card and payment-app payments, which are reported by the processor, and total each form box.
Is the 1099 threshold per payment or per year?
It is measured on the total you paid one contractor during the calendar year, not on any single payment. Six payments of $350 add up to $2,100 and cross a $2,000 threshold even though no single payment looks large. Always confirm the current threshold for your filing year with the IRS or your accountant, since it has changed over time.
When are 1099-NEC forms due?
Form 1099-NEC is generally due to the contractor and to the IRS by January 31 following the tax year, with the date shifting to the next business day when it falls on a weekend or holiday. Confirm the exact date for your filing year, and keep a deadline cell in your tracker so it counts down automatically.
Do I need a W-9 from every contractor?
Collect one before you make the first payment, because it holds the legal name, entity type and tax ID you need to file a form. If a contractor who crosses the reporting threshold never supplies a taxpayer ID, you may be required to apply backup withholding, so a missing W-9 is a money problem, not just a paperwork problem. Check current rules with your accountant.