1099 Contractor Payment Tracking
Overview
Track payments to independent contractors throughout the tax year. Total payments by vendor, flag anyone approaching or exceeding the $600 IRS reporting threshold, and prepare data for 1099-NEC filing.
Wilson Tools Used
transaction_search — find all payments to contractor-related vendors by name or category
export_transactions — export contractor payment details for tax filing preparation
Workflow
- Ask for the tax year (defaults to current year) and any known contractor names or payment categories.
- Use
transaction_search to find all outgoing payments categorized as contractor, freelancer, consulting, or professional services.
- Also search by specific vendor names if provided (e.g., "John Smith", "Design LLC").
- Group results by vendor/payee and sum total payments per vendor for the year.
- Generate the tracking report:
1099-NEC CONTRACTOR TRACKING — Tax Year [Year]
══════════════════════════════════════════════════
Contractor Payments YTD Total Status
──────────────────────────────────────────────────
Jane Smith Design 8 $12,400 REPORTABLE
Mike's IT Services 4 $3,200 REPORTABLE
Sarah Copywriting 2 $550 APPROACHING
Tom Photography 1 $200 Under threshold
──────────────────────────────────────────────────
Total Contractors: 4
Reportable (>=$600): 2
Approaching ($400-$599): 1
Total Contractor Spend: $16,350
══════════════════════════════════════════════════
- Flag contractors as:
- REPORTABLE: Total >= $600 (1099-NEC required)
- APPROACHING: Total $400-$599 (may cross threshold)
- Under threshold: Total < $400
- Use
export_transactions to create a CSV of all contractor payments for tax preparation.
Without Wilson
- Export your full year of bank transactions as CSV from your bank.
- In a spreadsheet, filter for outgoing payments (negative amounts in Chase CSV, or debit transactions).
- Add a "Contractor" column. Manually tag each contractor payment with the contractor's name.
- Create a pivot table: Rows = Contractor name, Values = Sum of Amount (absolute value).
- Add a status column:
=IF(ABS(Total)>=600,"REPORTABLE",IF(ABS(Total)>=400,"APPROACHING","Under threshold")).
- For 1099-NEC filing, you need each contractor's legal name, address, and TIN/SSN. Keep a W-9 on file for every contractor you pay.
- E-file 1099-NECs through IRS FIRE system (fire.irs.gov) or use a service like Tax1099.com, Track1099.com, or QuickBooks 1099 filing. Due date: January 31 of the following year.
Important Notes
- The $600 threshold applies to payments for services, not goods. Payments to corporations (S-corp, C-corp) are generally exempt unless for legal or medical services.
- Collect W-9 forms from contractors BEFORE making the first payment. Backup withholding (24%) is required if no W-9 is provided.
- This tracks calendar year totals. If you need to check mid-year, specify the date range from January 1 through the current date.
- Payments made via credit card or payment processor (PayPal, Stripe) are reported by the processor on 1099-K, not by you on 1099-NEC.
1---
2name: contractor-tracking
3description: >
4 Monitor 1099 contractor payments and flag $600 threshold.
5metadata:
6 source: https://skillmd.com/skills/openaccountant/contractor-tracking
7---
8
9# 1099 Contractor Payment Tracking
10
11## Overview
12Track payments to independent contractors throughout the tax year. Total payments by vendor, flag anyone approaching or exceeding the $600 IRS reporting threshold, and prepare data for 1099-NEC filing.
13
14## Wilson Tools Used
15- `transaction_search` — find all payments to contractor-related vendors by name or category
16- `export_transactions` — export contractor payment details for tax filing preparation
17
18## Workflow
191. Ask for the tax year (defaults to current year) and any known contractor names or payment categories.
202. Use `transaction_search` to find all outgoing payments categorized as contractor, freelancer, consulting, or professional services.
213. Also search by specific vendor names if provided (e.g., "John Smith", "Design LLC").
224. Group results by vendor/payee and sum total payments per vendor for the year.
235. Generate the tracking report:
24
25```
261099-NEC CONTRACTOR TRACKING — Tax Year [Year]
27══════════════════════════════════════════════════
28Contractor Payments YTD Total Status
29──────────────────────────────────────────────────
30Jane Smith Design 8 $12,400 REPORTABLE
31Mike's IT Services 4 $3,200 REPORTABLE
32Sarah Copywriting 2 $550 APPROACHING
33Tom Photography 1 $200 Under threshold
34──────────────────────────────────────────────────
35Total Contractors: 4
36Reportable (>=$600): 2
37Approaching ($400-$599): 1
38Total Contractor Spend: $16,350
39══════════════════════════════════════════════════
40```
41
426. Flag contractors as:
43 - **REPORTABLE**: Total >= $600 (1099-NEC required)
44 - **APPROACHING**: Total $400-$599 (may cross threshold)
45 - **Under threshold**: Total < $400
467. Use `export_transactions` to create a CSV of all contractor payments for tax preparation.
47
48## Without Wilson
491. Export your full year of bank transactions as CSV from your bank.
502. In a spreadsheet, filter for outgoing payments (negative amounts in Chase CSV, or debit transactions).
513. Add a "Contractor" column. Manually tag each contractor payment with the contractor's name.
524. Create a pivot table: Rows = Contractor name, Values = Sum of Amount (absolute value).
535. Add a status column: `=IF(ABS(Total)>=600,"REPORTABLE",IF(ABS(Total)>=400,"APPROACHING","Under threshold"))`.
546. For 1099-NEC filing, you need each contractor's legal name, address, and TIN/SSN. Keep a W-9 on file for every contractor you pay.
557. E-file 1099-NECs through IRS FIRE system (fire.irs.gov) or use a service like Tax1099.com, Track1099.com, or QuickBooks 1099 filing. Due date: January 31 of the following year.
56
57## Important Notes
58- The $600 threshold applies to payments for services, not goods. Payments to corporations (S-corp, C-corp) are generally exempt unless for legal or medical services.
59- Collect W-9 forms from contractors BEFORE making the first payment. Backup withholding (24%) is required if no W-9 is provided.
60- This tracks calendar year totals. If you need to check mid-year, specify the date range from January 1 through the current date.
61- Payments made via credit card or payment processor (PayPal, Stripe) are reported by the processor on 1099-K, not by you on 1099-NEC.