Report this item to Etsy

W9 Tracker & 1099 Contractor Log for Nonprofits and Churches, Vendor Payments, Google Sheets Excel

Price:$17.00

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

W-9 tracker and 1099 contractor log for nonprofits and churches: track vendor payments, W-9s and which payees may need a 1099. Google Sheets + Excel. Built for church treasurers, small nonprofit bookkeepers, and volunteer finance teams.

The IRS 1099-NEC/1099-MISC reporting threshold rose from $600 to $2,000 for payments made in 2026 (the IRS may adjust it for inflation in later years). This tracker uses $2,000 by default, and you can change it in one cell.

WHAT'S INSIDE (8 connected tabs)
• Start Here: your org, tax year, threshold, and program names, plus step-by-step setup
• Dashboard: who likely needs a 1099, missing W-9s, deadline countdown, spending by grant/program
• Vendors & W-9 Log: payee type, W-9 requested/received, "TIN on file" Yes/No, and an automatic W-9 chase list
• Payment Log: up to 500 payments, tagged by grant or program. Card and PayPal/Venmo payments are flagged as likely reported on a 1099-K and set aside from your 1099-NEC totals for review
• 1099 Summary: tax-year totals per payee compared with your threshold, a "Needs 1099?" column that flags payees who likely need a 1099, form type, and W-9 ready status
• Payee Type Guide: plain-language notes on individuals, LLCs, corporations, attorneys, and exempt orgs, with links to IRS pages
• Jan 31 Checklist & Calendar: year-end tasks with dates that move off weekends (1099-NEC for 2026 is generally due by Mon, Feb 1, 2027; confirm current IRS dates)
• Preparer Handoff: a one-page summary to print or save as PDF for your tax preparer

PRIVACY BY DESIGN
The tracker never asks for SSNs or EINs. You record only whether a TIN is on file (Yes/No). Keep the signed W-9s somewhere secure, outside the spreadsheet.

YOU GET
• SAMPLE file (a fictional small church) and BLANK file (.xlsx)
• Quick-start PDF guide
• Works in Google Sheets (upload to Drive, then File > Save as Google Sheets) and Excel 2016 or newer
• No macros

PLEASE NOTE
This is a digital download. Nothing physical ships. It is an organizing tool, not tax or legal advice, and it does not file forms. Confirm your situation with the IRS instructions or a tax preparer.

Questions? Email missionsheets [!at] gmail.com. We usually reply within one business day.

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

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Nov 4, 2026