click to scroll images
W9 1099 Tool
Keeping track of who needs a 1099-NEC or 1099-MISC (and for how much) can be a headache. This automated tool does the heavy lifting for you—calculating thresholds, tracking W-9 statuses, and organizing your payment data into a clean, ready-to-use format for tax filing. This tool is fully customizable so you can update your settings as IRS rules evolve.
This tool enables efficiency and does NOT replace professional tax advice! Walk through your settings and calculations with your tax professional to make sure it works for your specific needs.
ralphio
Capabilities
Tax Settings (2026 Ready): Pre-configured with 2026 IRS rules and thresholds for NEC and MISC forms. Includes direct IRS links for easy reference. You can manually adjust these settings if tax laws change or to fit your specific business needs.
Vendor Manager: Your central hub for vendor details. Log addresses and Tax IDs, and use the built-in tracking to see exactly which vendors still owe you a W-9 at a glance.
Payments: Simply log your expenses here. The sheet automatically identifies which payments are reportable and sums them up against IRS thresholds based on payment method and business type.
Data for 1099s: No more digging through bank statements! This sheet pulls everything together, showing you exactly what to put in each box for every vendor.
1099s Sent: Keep an audit trail. Log when you’ve submitted forms to the IRS and the vendor, which then updates the status in your Vendor Manager.
Visual Dashboard: Get a bird's-eye view of your spending. View monthly payment trends, identify your top vendors, and see a breakdown of payment methods through clean, professional charts.
FAQ
Q: Do I need a paid Google account?
A: No. A free personal Gmail/Google account is all you need.
Q: Is my data safe?
A: 100%. This is a private template that lives in your secure Google Drive. I never have access to your file or your data.
Q: Can I use this on my phone?
A: Yes, via the free Google Sheets app. However, Google limits certain dropdown and slicer functionality on mobile; for the best comparison experience, I recommend using the desktop version.
Video Tutorial
Returns
Els Paxton creates digital products designed to save time and solve real problems. Because these products are delivered immediately after purchase, returns aren't available once a file has been downloaded.
If something isn't right, Els Paxton will make every reasonable effort to fix the issue. Please get in touch if:
The wrong product was delivered.
A file is missing, corrupted, or won't open.
A technical issue prevents the product from working as intended.
When possible, Els Paxton will provide replacement files, updates, or troubleshooting assistance. If a problem can't be resolved, a refund may be issued at Els Paxton's discretion.
Purchased the wrong product or made a mistake during checkout? Reach out.
Every request receives individual consideration, although refunds can't be guaranteed.
Need Assistance? Questions before purchasing are always welcome.
If there's a problem after your purchase, please include:
The product name
A brief description of the issue
I will respond as quickly as possible and work toward a fair resolution.
Thank you for supporting this small business!
Reviews
Loading product reviews...
Specs for Search Answers
Support
Support Contact
help@elspaxton.io
Embedded Support
Links to video tutorials, links to IRS references, data error flags
Video Tutorial Link
General Info
Delivered Product
1 PDF Download containing the secure link to your private Google Sheets Template.
License
Single user license; never expires
Product Created
May 3, 2026
Product Updated
May 3, 2026
Use Info
Minimal Skillset Required
Basic spreadsheet usage; no formula writing required
Typical Use Function
Computing 1099 amounts, tracking W9s received and 1099s issued
Typical User Type
Small Business
Typical Setup Time
w9 5 minutes
Product Info
Computation Framework
Advanced formulas (lambda and array formulas), Query formulas, Pivots with Slicers
User Sheet Count
7
User Sheet Names & Functions
SETTINGS - User sets the tax year for the sheet (make a new sheet for each tax year), thresholds for the 1099s that apply, box setups for each 1099 type, Business Types, and Payment Methods. Comes with defaults for 1099-NEC and 1099-MISC for 2026 to allow user to start out-of-the-box; user can customize as desired.
VENDORS - user establishes the vendors they pay, captures W9/1099 applicable info (Tax ID, business type, address), and tracks W9 receipt. User can also see 1099 status for each vendor
PAYMENTS - user tracks payments made to vendors here, simply selecting the vendor (1099 application for 1099 threshold using vendor business type established in VENDORS sheet) and payment type (defines 1099 application for 1099 threshold using payment methods established in SETTINGS sheet.
1099 DATA - provides data the user needs to build each 1099, including vendor name/address/tin, amount for each box in each type of 1099
1099 TRACKING - user tracks the 1099s they build to ensure they send them to both the vendor and the IRS
DASHBOARD - user sees visual breakdowns of vendors paid, what they paid vendors for, payments over time (by month), and how they paid (check, card, etc)
READ ME - provides How To instruction with links, link to tutorial video, and includes terms/disclaimer small print
Hidden Sheet Count
2
Hidden Sheet Names & Functions
ADMIN - Setup columns to enable formulas; improved simplicity for user experience; formula protection from accidental deletion
ADMIN VENDOR REPORT - pulls the data required for all Dashboard Charts.
Hidden Sheets User Cannot Access
None - user can unhide all sheets
Dashboard Chart Count
4
Dashboard Charts & Functions
WHO YOU PAY: pie chart show the percent of payments made to each vendor, with supporting amounts in a table below
WHAT YOU PAY FOR: pie chart showing the percent paid by service categories (i.e., service labor, medical expenses, rent, etc), with supporting amounts in a table below
WHEN YOU PAY: line chart showing the total paid by month over the year, providing a view of trend, peaks, and valleys; includes supporting amounts in a table below
HOW YOU PAY: bar chart showing the total by payment type (e.g., checks, credit card, choice of fintech provider, etc), with supporting amounts in a table below
Image Descriptions
Listing Image Descriptions
Image 1
W9 / 1099 Tool — Google Sheet. Track vendors, W9 Status, & 1099 Status with the Vendor Tracking sheet; instantly get data to build your 1099s with the 1099 Data Build sheet; summarize your year with the Dashboard view.
Image 2
Adds Eligible Payments — Easily capture your payments and let formulas do the rest. Screenshot of the payment tracking ledger showing the fields you complete with dropdowns, date, and payment amount, while the tool automatically calculates eligibility against your configured thresholds.
Image 3
W9 Tracking — Instantly see who owes you a W9 and who you owe a 1099 to. Screenshot of the Vendor Tracking sheet showing visual flagging for a Tax ID entered as sequential digits. Visual cues flag missing W9s, missing data, and common Tax ID entry errors.
Image 4
1099 Data — See every vendor’s information and the amount for every 1099 box. Screenshot of the 1099 Data sheet showing each vendor’s reportable amounts by 1099 box. 1099 boxes dynamically adjust to your settings.
Image 5
Thresholds — Comes with 2026 default settings for NEC & MISC. Easy to change for any year and customize to your tax situation. Screenshot of the Settings sheet showing options to change the tax year, business types, payment methods, and 1099 types. All settings are organized on one sheet.
Image 6
Exemptions — Tracks payment method exemptions from reporting thresholds, as well as business type exemptions. Screenshot of the Settings sheet showing which payment methods count toward a threshold and which do not. Includes links to IRS rules for reference.
Image 7
1099 Tracking — Screenshot of the 1099 Tracking sheet for keeping track of required 1099s sent to vendors and the IRS. Checklist to ensure you send all required 1099s to the IRS and your vendors.
Image 8
Visualize your year — See who you paid, what you paid for, when you paid, and how you paid. Screenshot of the dashboard showing charts that summarize vendor and payment activity. Slicers let you adjust the charts and tables to focus on the information you need.
Image 9
What’s Included — One PDF download containing a secure link to your private Google Sheets template, plus a step-by-step setup tutorial. Includes tax-year setup, payment tracking, visual cues for data-quality issues, a year-end dashboard, and step-by-step support with tutorial videos. You can copy the sheet for future tax years at no additional cost, and direct support is available from the creator.
Search Optimization
Other Titles Possibly Searched
Tax Preparation Helper, 1099 Data Calculator, Vendor Management Tool, 1099 Builder, Subcontractor Payment Tracking
Description for SEO
Spreadsheet for small businesses to track W-9s, vendor information, contractor payments, 1099-NEC and 1099-MISC reporting thresholds, and forms sent to vendors and the IRS. Includes 2026 tax settings, payment tracking, vendor management, 1099 preparation data, and a visual spending dashboard.
Terms & Disclaimers
TERMS OF USE - SINGLE USER LICENSE. BY PURCHASING THIS PRODUCT, YOU AGREE TO THE FOLLOWING:
Single-User License: Your purchase grants you one (1) non-transferable license for personal use only.
No Redistribution: You may not share, sell, resell, give away, or distribute the actual file, or any modified version of it, to any third party.
No "Tool" Reselling: You may not use the logic, formulas, or unique design of this spreadsheet to create a competing product for sale.
Usage: You are welcome to save multiple copies of the file for your own personal use (e.g., a "2025 Tracker" and a "2026 Tracker").
Copyright: The design, formulas, and intellectual property within this spreadsheet remain the sole property of Els Paxton LLC.
DISCLAIMER & LIMITATION OF LIABILITY: This spreadsheet tool is provided by Els Paxton LLC for informational and organizational purposes only. While every effort is made to ensure accuracy, Els Paxton LLC does not guarantee the results obtained from using this tool.
Not Professional Advice: This tool does not constitute financial, legal, tax, or accounting advice.
User Responsibility: The user is solely responsible for the accuracy of data entered and for verifying all final calculations.
No Warranty: This product is provided "as is" without any warranties. In no event shall Els Paxton LLC be liable for any damages (including, without limitation, loss of data or profit) arising out of the use or inability to use this tool.
Privacy
Effective Date: July 17, 2026
At Els Paxton, privacy matters. This policy explains what information the company collects, how it is used, and the choices customers have regarding their information.
Information Collected
Depending on how the website is used, Els Paxton may collect:
Contact information, such as your name, email address, and the information you choose to include in your message when you use the Contact page.
Order information needed to process purchases and deliver digital products.
Basic website usage information, such as pages visited, browser type, device information, and general location.
Information you voluntarily provide through emails or customer support requests.
Els Paxton collects only the information needed to operate the business and provide its products and services.
How Information Is Used
Information may be used to:
Process purchases and deliver digital products.
Respond to questions and provide customer support.
Improve products, the website, and the customer experience.
Measure website performance and marketing effectiveness.
Detect fraud, protect the security of the website, and comply with legal obligations.
Els Paxton does not sell or rent your personal information. Personal information is shared only with trusted service providers when necessary to operate the business and provide products or services.
Payments
Payments are securely processed by Lemon Squeezy. Els Paxton does not collect or store your payment card information. Payment information is handled according to Lemon Squeezy's privacy and security practices.
Cookies and Analytics
This website uses cookies and similar technologies to understand how visitors use the site and to improve the customer experience.
Els Paxton may use:
Google Analytics to measure website traffic and understand how visitors use the site.
Google Ads to measure advertising performance and conversions.
Microsoft Clarity to better understand how visitors interact with the website through anonymous usage data, such as heatmaps and session recordings.
These services may collect information such as pages visited, browser type, device information, approximate location, and interactions with the website. This information helps improve the website and measure the effectiveness of marketing efforts.
You can control or disable cookies through your browser settings, although some features of the website may not function as intended.
Third-Party Services
Els Paxton relies on trusted third-party providers to operate the business. These providers may process information only as needed to provide their services.
Current providers may include:
Lemon Squeezy for payment processing and digital product delivery.
Google Analytics for website analytics.
Google Workspace for securely storing and managing customer inquiries submitted through the Contact page.
Google Ads for advertising measurement.
Microsoft Clarity for website usability analytics.
Each provider maintains its own privacy policy and is responsible for the information it collects through its services.
Data Security
Els Paxton uses reasonable administrative, technical, and organizational safeguards to protect personal information. However, no method of transmitting or storing information over the internet can be guaranteed to be completely secure.
Data Retention
Els Paxton keeps personal information only as long as reasonably necessary to provide products and services, respond to customer inquiries, comply with legal obligations, resolve disputes, and maintain business records.
Your Rights
Depending on where you live, you may have the right to:
Request access to your personal information.
Request correction of inaccurate information.
Request deletion of your personal information where permitted by law.
Object to or limit certain processing activities.
To exercise these rights, please contact Els Paxton using the Contact page on this website.
Children's Privacy
This website is not intended for children under the age of 13, and Els Paxton does not knowingly collect personal information from children.
Changes to This Policy
This Privacy Policy may be updated from time to time. The current version will always be posted on this page with the effective date shown above.
Contact
If you have questions about this Privacy Policy, please use the Contact page on this website.