---
title: "W-9 Tracker Script: Missing W-9s, TINs & Request Emails"
description: "See which vendors you paid with no W-9 or TIN on file and who is near the $2,000 1099 threshold, then get personalized W-9 request emails. Runs offline."
url: "https://mcc-solutionsnj.com/bookkeeping/w9-tracker-python-script"
---

Paid script

# W-9 Tracker with Personalized Request Emails

Find out which contractors still owe you a W-9 before 1099 season, starting with the ones closest to the reporting threshold. The script drafts a personalized request email for each one, and you review and send them yourself.

[![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)

Paid script

## W-9 Tracker & Request Emails

Buy this script on its own for $29, one time. No membership needed. It runs on your own computer and nothing you enter leaves it. Read how it works and the questions below first.

The [Automation Suite](/bookkeeping/automation-suite) includes this and 10 more tools for $99. Members get this included. [See the membership](/membership) or [sign in](/membership/login). Already bought it? Email me my access link.

How it works

## How it works

Give the script your vendor list (name, TIN, W-9 on file, email) and your payments export. It totals each vendor's payments for the year, leaving out card and payment-network payments (those go on 1099-K) and anything categorized as goods or wages. It then flags vendors with **no W-9**, **no TIN**, a **TIN that fails a format check**, and anyone you paid who is not on your vendor list. Each vendor is marked over, approaching or under the **$2,000 threshold for 2026 payments** and ranked by priority. You get a status report that explains 24% backup withholding, a status CSV, and one plain-text W-9 request email per vendor plus a mail-merge CSV. Nothing is ever sent automatically.

FAQ

## About this calculator

**What do I need to run it?**

Python 3.9 or newer and two CSV files: your vendor list and your payments. It uses only the standard library and works offline. Run it with --demo to see sample output.

**Does it send the emails?**

No. It writes each email as a text file and adds a mail-merge CSV, so you can review the wording first. The emails ask vendors not to put their SSN or EIN in a regular email. You can supply your own template with --template.

**Does it verify TINs with the IRS?**

No. It checks only the format, such as the digit count and number ranges that are never issued. To confirm that a name and TIN match, use the IRS TIN Matching program through e-Services.

**Is this tax or legal advice?**

No. It is a general-information tool for keeping your vendor records organized. Ask a tax professional about specific backup withholding or reporting questions.

See [all free tools](/free-tools). More free tools: [Self-employed tax calculator](/bookkeeping/self-employed-tax-calculator), [1099 contractor payment tracker](/bookkeeping/1099-contractor-payment-tracker), [Bank reconciliation difference finder](/bookkeeping/bank-reconciliation-difference-finder), or [see all free tools](/free-tools).

Free

### Month-End Close Checklist (PDF)

The five-day close, one page to print. Enter your email and we send a link to confirm it is yours, then the download. We may email you about new toolkits, and every email has an unsubscribe link.

General information, not tax or legal advice. [How we write and check our tools](/editorial-standards).

## Want your books and numbers handled?

[Free health check](/bookkeeping/health-check)[Call (908) 444-6373](tel:+19084446373)