Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceTax Planning1099 Contractor Payment Tracker

SpreadsheetTax PlanningFree

1099 Contractor Payment Tracker

Log contractor payments through the year, check W-9s, exclude card payments and see exactly who needs a 1099-NEC or 1099-MISC.

Shown with sample data

Colour

1099 Contractor Payment Tracker

Log contractor payments through the year, check W-9s, exclude card payments and see exactly who needs a 1099-NEC or 1099-MISC.

Paid to contractors
$29,370
Reportable payments
$26,530
1099s to file
5
W-9s missing
2
Days to filing deadline
75
Reportable payments by contractor
  • Brightline Web LLC$7,000
  • Lakeside Storage (unit rent)$5,400
  • Maya Chen Design$4,000
  • Peak Cleaning Co$2,880
  • Ortiz Legal PC$2,350
  • Quickprint Studio$2,150
  • Jordan Ellis (bookkeeping)$1,800
  • Sam Rivera (photography)$950

How to use it

  1. 1On Settings, check the reporting threshold and filing deadline for the tax year.
  2. 2Add each contractor with entity type, the form that applies and whether you hold a signed W-9.
  3. 3Log every payment with date, contractor, amount and payment method.
  4. 4Request a W-9 from anyone marked Request W-9 or Get W-9 now before paying them again.
  5. 5In January, file a 1099 for everyone marked Yes in 1099 needed and send each contractor their copy.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

January is a bad time to discover a missing W-9. Record each contractor with their entity type and W-9 status, log every payment with how it was made, and the tracker totals reportable payments (card and payment-app payments are reported by the processor on a 1099-K instead), compares them with the filing threshold and tells you who needs a 1099, who is missing paperwork and how long you have until the deadline.

Who it’s for

  • US businesses that pay freelancers and contractors
  • Landlords and nonprofits paying for services or rent
  • Bookkeepers preparing year-end 1099 filings

What’s included

  • Contractors sheet: Each contractor, their paperwork and whether they need a 1099.
  • Payments sheet: Every payment to a contractor this year.
  • Settings sheet: Threshold and deadline for the tax year.

How to use it

  1. 1On Settings, check the reporting threshold and filing deadline for the tax year.
  2. 2Add each contractor with entity type, the form that applies and whether you hold a signed W-9.
  3. 3Log every payment with date, contractor, amount and payment method.
  4. 4Request a W-9 from anyone marked Request W-9 or Get W-9 now before paying them again.
  5. 5In January, file a 1099 for everyone marked Yes in 1099 needed and send each contractor their copy.

Tips

  • Collect a W-9 before the first payment. If a contractor will not provide a TIN, backup withholding (24%) may apply.
  • Payments to attorneys for legal services are generally reportable even if the firm is a corporation.
  • Store full TINs only in your secure payroll or accounting system; this tracker keeps the last four digits.

Questions

Who needs a 1099-NEC?

Generally, any unincorporated individual, partnership or LLC (not taxed as a corporation) you paid for services in the course of your business, at or above the reporting threshold in the year. Employees get a W-2 instead.

What is the 1099 threshold?

For payments made in 2026 and later, the threshold for Forms 1099-NEC and 1099-MISC rose from $600 to $2,000 under recent US legislation, with inflation indexing after that. Check the IRS instructions for the year you are filing and update Settings.

Do I send a 1099 if I paid by credit card or PayPal?

Usually no. Card and third-party network payments are reported by the payment processor on Form 1099-K, so they are excluded from your reportable total here.

When are 1099s due?

1099-NEC is due to the IRS and the contractor by January 31 (the next business day if it falls on a weekend). For 2026 payments that is February 1, 2027.

Related searches1099 tracker1099 contractor trackerwho needs a 10991099-nec spreadsheetw-9 trackerindependent contractor payments

Details

Format
Spreadsheet
Category
Tax Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetTax PlanningFree

1099 Contractor Payment Tracker

Log contractor payments through the year, check W-9s, exclude card payments and see exactly who needs a 1099-NEC or 1099-MISC.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Tax Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More tax planning templates

View all
Sales Tax & VAT Log2 sheets

Output tax (sales)

$3,178

Input tax (purchases)

$383

Net tax due

$2,795

Net tax due by quarter
$1,715
$1,080
Q4 2026Q3 2026
SpreadsheetTax Planning

Sales Tax & VAT Log

Output and input tax on every sale and purchase, the quarter worked out from the date, and the net due for each return.

10 min setupPreview
Tax Deduction Tracker3 sheets

Expenses deductible

$4,048

Mileage deduction

$92

Estimated tax saving

$1,242

ABCD
1DateVendorCategoryDescription
2Jan 8AdobeSoftwareCreative Cloud annual
3Feb 14AppleEquipmentMacBook Air
4Mar 1ComcastPhone & internetInternet: March
5Mar 22ShellVehicle & travelFuel: client visit
Expenses
SpreadsheetTax Planning

Tax Deduction Tracker

Deductible expenses with business-use share and receipts, plus a mileage log, totalled by category for your return.

10 min setupPreview
Mileage Log2 sheets

Business miles

285

Amount to claim

$191

Trips

6

ABCD
1DateFromToCategory
2Nov 2OfficeHarbor LogisticsClient visit
3Nov 3OfficeWholesale depotSupplies
4Nov 5HomeBluepeak HQClient visit
5Nov 6OfficeThree customer dropsDelivery
Trips
SpreadsheetTax Planning

Mileage Log

Business trips with odometer readings, purpose, miles and the deduction or reimbursement at your rate.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ