1099 Contractor Payment Tracker | W-9 Tracking, Tax Prep (Digital Download)
Price:$16.99
Star Seller
Star Sellers have an outstanding track record for providing a great customer experience—they consistently earned 5-star reviews, shipped orders on time, and replied quickly to any messages they received.
You can only make an offer when buying a single item
Star Seller. This seller consistently earned 5-star reviews, shipped on time, and replied quickly to any messages they received.
Highlights
YEAR-END 1099-NEC AND W-9 CONTRACTOR PAYMENT TRACKER
🎁 FREE BONUS INCLUDED — 1099 Determination + W-9 Chase List (a $22 value): tells you exactly who needs a 1099 and whose W-9 is still missing. Yours free with this template.
Every other contractor spreadsheet is a ledger. You type payments in, it adds them up, and in January you are still sitting there at 11pm asking the only two questions that actually matter.
Who do I owe a form to? And do I have their tax ID?
This file answers both.
In the sample year loaded in the workbook, 177 payments totalling $201,452.99 were made to 22 contractors. The Dashboard reads: "You owe a form to 18 of the 22 contractors you paid, and 3 of them have no W-9 on file." Nobody typed that sentence. The file worked it out.
THE PART NOBODY ELSE HANDLES
If you paid a contractor by credit card, PayPal goods and services, Venmo business or Stripe, that money is reported by the payment processor. Not by you. Put it on a 1099 as well and the same money gets reported twice.
Set the payment method on each row and the file removes those payments from your reportable totals on its own. In the sample year that is $18,014 correctly taken out of $201,453, leaving $172,421 that is genuinely yours to report.
This is the single most common mistake made on these forms, and not one competing template deals with it.
WHAT'S INCLUDED - 12 TABS, 2,785 WORKING FORMULAS
- Dashboard - forms required, reportable spend, W-9s outstanding, withholding at risk, box-by-box totals, a month-by-month view and eight plain-English lines telling you what needs attention
- Start Here - five-minute setup plus the four rules that keep the numbers honest
- Settings - every threshold, rate, deadline and category in the workbook. Nothing is hard-coded anywhere
- Contractor Roster - 50 slots: legal name, business name, entity type, W-9 held, TIN held, address, e-delivery consent
- Payment Ledger - 250 rows that categorise themselves, work out whether they are reportable, and assign their own form box
- 1099 Determination - one row per contractor with the running total, the threshold test, the form required and a plain-English verdict
- W-9 Chase List - who to chase, when the follow-up is due, and exactly how much backup withholding is riding on it
- Box Mapping - which box each of the 15 categories belongs in, in plain English, with your total beside it
- Filing Checklist - 14 tasks with live countdowns to every deadline you set
- Year-End Close-Out - 10 automatic checks that read your own data, plus 10 manual items
- Worker Classification - a 15-question weighted self-check for anyone who is starting to look like an employee
- Multi-Year Archive - three years side by side so next January starts from this January
THE VERDICT COLUMN IS THE PRODUCT
Every contractor gets a sentence, not a number.
"Below threshold - no form required." "Threshold met - 1099-NEC required." "Threshold met - 1099-NEC and 1099-MISC required." And the one that saves you: "THRESHOLD MET BUT NO W-9 OR TIN ON FILE", in red.
The threshold runs on the yearly total, not on any single payment, so six payments of $150 still cross it. And the threshold itself is a cell on the Settings tab, not a rule baked into the file - change it and every verdict re-decides itself.
THE CHASE LIST PRICES THE PROBLEM
A missing tax ID is not a paperwork problem. It is a withholding problem.
Log the date you first asked for the W-9 and the file adds your own chase window to work out when the follow-up is due, then flags the row amber the day it goes late. Beside it sits the number that makes you pick up the phone: what you may have to withhold if that TIN never arrives. In the sample year that is $1,726.37 across 3 contractors.
Mark the W-9 as received on the roster and the row clears itself. The list is finished when it is empty.
SIX BOXES, TOTALLED FOR YOU
Nonemployee compensation. Rents. Royalties. Other income. Medical and health care payments. Gross proceeds paid to an attorney. Each one gets its own running total, ready to transcribe, already net of anything a processor is reporting on your behalf.
The Box Mapping tab explains in plain English what belongs in each - including the difference between an attorney's own fee and settlement money passing through an attorney, which are two different boxes and catch people out every year.
CONTRACTOR OR EMPLOYEE?
Fifteen weighted questions across behavioural control, financial control and the nature of the relationship, producing a risk score and a reading. It is a prompt for a conversation with your accountant, not a determination - but the cost of asking is a fraction of the cost of getting it wrong.
KEY FEATURES
- 12 linked tabs and 2,785 working formulas
- A threshold engine that reaches a verdict instead of just totalling a column
- Automatic exclusion of card and third-party-network payments
- A missing-W-9 chase list with follow-up dates and priced withholding exposure
- Per-box totals ready to transcribe onto the forms
- Live countdowns to five deadlines you set yourself
- Ten automatic close-out checks that read your own data
- Drop-down menus, conditional formatting, charts and protected formula cells
- A complete fictional sample year already loaded so you can see every calculation working
- Room for 50 contractors and 250 payments
HOW IT WORKS
1. Download instantly after purchase - nothing is shipped
2. Open Settings and enter your business, your tax year, your reporting threshold, your withholding rate and your five filing deadlines
3. List everyone you paid on the Contractor Roster, and be honest about whether you hold their W-9
4. Enter payments on the ledger as they happen. The file does the categorising, the boxing and the deciding
5. Read the Dashboard. It tells you who needs a form and who you still need to chase
COMPATIBILITY
Works in Microsoft Excel (2016 and later, and Microsoft 365) and in Google Sheets. No macros, no add-ons, no subscription and no array formulas - which is exactly why it calculates identically in both. Desktop, laptop, tablet or phone. Yours forever.
WHO IT IS FOR
Small business owners, agencies, construction contractors, salon owners, e-commerce sellers and anyone who paid a handful of subcontractors this year, has never filed one of these forms before, and has just realised in Q4 that January is coming and half the tax IDs are missing.
If you already sell on a marketplace and track the money coming in, this is the other half - the money going out, and whether you owe someone a form for it.
FREE CUSTOMIZATION
Need a category we have not included, a different set of boxes, or more contractor rows? Message the shop and we will add it for you at no charge.
PLEASE NOTE
This file organises your own payment records so you can see your reporting position in one place. It is not tax, legal or accounting advice, it does not file anything for you, and it does not replace your accountant. Every threshold, rate and deadline in it is whatever you enter on the Settings tab - confirm the current figures for your filing year with the IRS or your accountant. Every person, business and amount in the sample data is fictional.
This is a digital download, not a physical product. Nothing will be shipped. Because it is an instant download, all sales are final - but any questions before or after you buy, just message us and we will help.
ReadySheetGo - spreadsheets that actually do the work.
📗 HOW TO OPEN IN GOOGLE SHEETS (free & easy):
This is one file that works in BOTH Excel and Google Sheets — there's no separate file to find, you just import the download once:
1. Go to sheets.google.com and open a blank spreadsheet
2. Click File ▸ Import ▸ Upload
3. Drag in the .xlsx file you downloaded from this order
4. Choose "Replace spreadsheet" and click Import data
All tabs load as a full Google Sheet saved in your Drive — edit it on any device. (Prefer Excel? Just double-click the file to open.)
———————————————
VIDEO TUTORIAL INCLUDED
This template comes with a step-by-step video walkthrough to help you get set up in minutes. Your tutorial link is included with the instant download.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
Be the first to review this item
Speedy replies Has a history of replying to messages quickly.
Rave reviews Average review rating is 4.8 or higher.
More from this shop
Visit shop-
Digital download
Nonprofit Church Treasurer Spreadsheet Template Excel Google Sheets | Donation Tracker, Restricted Fund and Budget Board Report Dashboard
$18.99
-
Digital download
Small Business Payroll Calculator Spreadsheet Template Excel Google Sheets | Pay Stub Generator, Employee Paycheck and W-2 Tax Tracker
$19.99
-
Digital download
PTA Treasurer Spreadsheet | Budget, Bank Reconciliation, Fundraiser Tracker (Excel, Google Sheets)
$18.99
-
Digital download
Side Hustle Income Tracker Spreadsheet 2027, Multiple Income Streams & Expense Log | Freelance Profit Loss Tax Estimator, Google Sheets
$14.99
-
Digital download
Form 1099 NEC Guide
$10.00
-
Digital download
Tax Deduction Tracker Google Sheets Self-Employed Tax Spreadsheet Small Business Freelancer Tax Prep Template Itemized Expense Tracker 1099
Sale Price $8.99
Original Price $17.98
-
Digital download
Tax Deduction Tracker Google Sheets Small Business Tax Prep Self-Employed Tax Tracker Spreadsheet Excel Tax Planner Tax Checklist 1099 Form
Sale Price $8.78
Original Price $17.55
-
Digital download
excel spreadsheet payroll taxes, ptin contractors tax prep logo report
$12.50
-
Digital download
Tax Deduction Tracker Excel Spreadsheet, Editable Tax Deductions List, Tax Organizer Planner, Small Business Tax Preparation Google Sheets
Sale Price $3.67
Original Price $7.35
-
Digital download
1099 Subcontractor Tracker Bundle | Excel Google Sheets | W-9 Log 1099 Organizer | Auto Calculating Editable Tax Prep Spreadsheet | Bonus W9
$11.99
-
Digital download
Payment Reporting Due Dates and Forms Checklist for Compliance
$14.99
-
Digital download
Tax and Bookkeeping Template | Profit & Loss Spreadsheet | Quarterly Estimate| Income Analysis | Receipt Tracking | CPA Approved
$15.99
-
Digital download
Tax Office Client Tracker: Excel & Google Sheets (Digital Download)
$19.99
-
Digital download
1099 Self-Employed Bookkeeping Spreadsheet | Income and Expense Tracker | Profit and Loss | Excel | Google Sheets | Accounting | Tax Tracker
$16.49
-
Digital download
Tax Prep Pricing Template CPA Fee Schedule Excel Tax Preparation Price List for Accountants Bookkeepers Editable Pricing Sheet Template PDF
$14.99
-
Digital download
Gig Worker Income Tracker, 1099 delivery driver tax deductions Tracker Spreadsheet, rideshare accounting
$19.99
Shoppers with similar taste loved these
-
Digital download
Small Business Bundle Bookkeeping Inventory Tracker Order Tracker Product Handmade Pricing Calculator Smart Bill Calendar Google Sheet Excel
Sale Price $14.63
Original Price $29.26
-
Digital download
Biweekly Paycheck Budget Spreadsheet Bill Calendar Weekly Monthly Budget Planner Expense Savings Debt Tracker Google Sheets Excel Template
Sale Price $12.67
Original Price $21.12
-
New House Savings Binder: Budget Planner with Envelopes
$33.00
-
Savings Challenge Books | 1,000-30,000 Savings | 96 Envelope Challenge | Available In Various Colours | Cash Stuffing | Saving Challenge
$69.17
-
Digital download
Debt Reduction Calculator Excel: Excel Credit Score Spreadsheet (Digital Download)
$9.99
-
Savings Challenge Mini Binder 500 or 1000.
$16.00
-
Digital download
Bill Tracker Spreadsheet Google Sheets Excel Bill Calendar Monthly Smart Bill Planner Editable 2026 Calendar Budget Calendar Budget Tracker
Sale Price $2.56
Original Price $5.12
-
Digital download
Debt Snowball Spreadsheet Google Sheet Excel Debt Payoff Tracker Debt Snowball Calculator Student Loan Payoff House Debt Payoff Credit Cards
Sale Price $3.20
Original Price $6.40
-
Digital download
ADHD Life Planner Google Sheets Daily Planner Budget Tracker Excel Productivity Planner Habit Tracker Monthly Calendar Weekly To Do List
Sale Price $7.31
Original Price $14.63
-
Digital download
Paycheck Budget Fortnightly, Biweekly, Weekly, Semi-Monthly, Monthly Budget Spreadsheet Planner with Debt Tracker | Excel & Google Sheets
Sale Price $12.67
Original Price $21.12
-
Digital download
Biweekly Budget Planner Digital Book Bill Tracker Debt Snowball Financial Planner Paycheck Budget Remarkable 2 Planner Bill Calendar Budget
$27.06
-
Digital download
ADHD Digital Planner 2026, Neurodivergent Daily Weekly Monthly Life Journal, 2026 Digital Planner, For Goodnotes Notability iPad Android
Sale Price $2.41
Original Price $9.64