Back to Details

contractor-tracking

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

1099 Contractor Payment Tracking

1099承包商付款追踪

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.
在整个纳税年度追踪向独立承包商支付的款项。按供应商统计付款总额，标记接近或超过美国国税局（IRS）600美元申报阈值的对象，并为1099-NEC申报准备数据。

Wilson Tools Used

使用的Wilson工具

  • transaction_search
    — find all payments to contractor-related vendors by name or category
  • export_transactions
    — export contractor payment details for tax filing preparation
  • transaction_search
    — 通过名称或类别查找所有支付给承包商相关供应商的款项
  • export_transactions
    — 导出承包商付款详情，为税务申报做准备

Workflow

工作流程

  1. Ask for the tax year (defaults to current year) and any known contractor names or payment categories.
  2. Use 
    transaction_search
    to find all outgoing payments categorized as contractor, freelancer, consulting, or professional services.
  3. Also search by specific vendor names if provided (e.g., "John Smith", "Design LLC").
  4. Group results by vendor/payee and sum total payments per vendor for the year.
  5. 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
══════════════════════════════════════════════════
  1. Flag contractors as:
    • REPORTABLE: Total >= $600 (1099-NEC required)
    • APPROACHING: Total $400-$599 (may cross threshold)
    • Under threshold: Total < $400
  2. Use 
    export_transactions
    to create a CSV of all contractor payments for tax preparation.
  1. 询问纳税年度（默认为当前年度）以及已知的承包商姓名或付款类别。
  2. 使用
    transaction_search
    查找所有归类为承包商、自由职业者、咨询或专业服务的对外付款。
  3. 如果提供了特定供应商名称（例如“John Smith”、“Design LLC”），也按名称进行搜索。
  4. 按供应商/收款人分组结果，并统计每位供应商本年度的付款总额。
  5. 生成追踪报告：
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
══════════════════════════════════════════════════
  1. 按以下规则标记承包商：
    • REPORTABLE：付款总额≥600美元（需申报1099-NEC）
    • APPROACHING：付款总额在400-599美元之间（可能超过阈值）
    • Under threshold：付款总额<400美元
  2. 使用
    export_transactions
    创建所有承包商付款的CSV文件，用于税务准备。

Without Wilson

未使用Wilson的流程

  1. Export your full year of bank transactions as CSV from your bank.
  2. In a spreadsheet, filter for outgoing payments (negative amounts in Chase CSV, or debit transactions).
  3. Add a "Contractor" column. Manually tag each contractor payment with the contractor's name.
  4. Create a pivot table: Rows = Contractor name, Values = Sum of Amount (absolute value).
  5. Add a status column: 
    =IF(ABS(Total)>=600,"REPORTABLE",IF(ABS(Total)>=400,"APPROACHING","Under threshold"))
    .
  6. 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.
  7. 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.
  1. 从银行导出全年的银行交易记录为CSV文件。
  2. 在电子表格中筛选对外付款（Chase CSV中为负数金额，或借记交易）。
  3. 添加“承包商”列，手动为每笔承包商付款标记承包商姓名。
  4. 创建数据透视表：行=承包商姓名，值=金额总和（绝对值）。
  5. 添加状态列：
    =IF(ABS(Total)>=600,"REPORTABLE",IF(ABS(Total)>=400,"APPROACHING","Under threshold"))
    。
  6. 申报1099-NEC时，你需要每位承包商的法定姓名、地址以及纳税人识别号（TIN）/社会保险号（SSN）。为每位付款的承包商留存W-9表格。
  7. 通过IRS FIRE系统（fire.irs.gov）电子申报1099-NEC，或使用Tax1099.com、Track1099.com或QuickBooks 1099申报等服务。截止日期：次年1月31日。

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.
  • 600美元阈值适用于服务付款，不适用于商品付款。向公司（S型公司、C型公司）的付款通常无需申报，除非是法律服务或医疗服务付款。
  • 在首次付款前，务必向承包商收集W-9表格。如果未收到W-9表格，需预扣24%的备用税款。
  • 此流程追踪日历年总额。如果需要年中查看，请指定从1月1日至当前日期的时间范围。
  • 通过信用卡或支付处理器（PayPal、Stripe）支付的款项由处理器在1099-K上申报，无需你在1099-NEC上申报。