New to OtterLedger? Read the Documentation
45 Guides Available Quick Start Guide
Learn AI Categorization View Guide
Have Questions? Check the FAQ
New to OtterLedger? Read the Documentation
45 Guides Available Quick Start Guide
Learn AI Categorization View Guide
Have Questions? Check the FAQ

1099 Summary Report

Guide 34: 1099 Summary Report

Track contractor payments for tax reporting


Overview

The 1099 Summary report shows payments to vendors who may require a 1099-NEC or 1099-MISC form (typically $600+ in a calendar year).


Running the Report

  1. Go to Reports1099 Summary
  2. Select tax year
  3. Choose Business (or Both) using the Personal / Business filter — 1099s apply to business payments
  4. Click Run

Report Contents

Vendor Summary

Vendor Total Paid Has TIN 1099 Required
John's Consulting $5,200 Yes Yes
ABC Services $850 Yes Yes
Quick Repair $450 No No (under $600)

Requirements

  • 1099-NEC - Non-employee compensation (services)
  • 1099-MISC - Rents, royalties, other
  • Threshold - Generally $600/year

Vendor Setup

For accurate 1099 tracking, vendors need:

  1. Business name - Legal name
  2. TIN/EIN - Tax ID number
  3. Address - For mailing forms
  4. 1099 eligible - Checkbox enabled

Personal / Business Filter

Use the Personal / Business / Both toggle to focus the report on business transactions only. This ensures personal payments to the same vendor are excluded from 1099 totals.


Exporting & Printing

Use the Export button to save the report as PDF or CSV. Select Print Preview to review the layout before sending to a printer. The PDF export is suitable for record-keeping alongside filed 1099 forms.


Actions

  • Export for filing - Generate e-file data
  • Print forms - Print 1099 forms
  • Review missing TINs - Request W-9s from vendors
  • Flag exceptions - Mark corporations (usually exempt)

Tips

  • Request W-9 before first payment
  • Review mid-year to catch missing info
  • Corporations generally don't get 1099s
  • Keep records for 7 years
  • Due date: January 31 for 1099-NEC

See also: Guide 16: Vendor Management