1099 vendor worksheet from a payments export

Drop in a vendor payments export: a CSV from QuickBooks (e.g. a Transaction List by Vendor report, with title, group and total lines handled), Xero or a bank. You get 2026 totals per vendor, which vendors are at or over USD 2,000 (the 2026 Form 1099-NEC threshold), whether a TIN and address are present in the export, and likely duplicate vendor names to confirm. Undated or invalid rows are listed for review, and totals are reconciled to the input.

Your file never leaves your computer. Everything runs in this browser tab; nothing is uploaded. TIN values are never shown or copied, only whether one is present.

Data preparation for your review, not a filing determination or tax advice. 1099-MISC thresholds vary by payment type, and backup withholding can require reporting below a threshold (IRS).

Want to see it first? Before/after sample with fictional data.
The Trillium Company · 145 Columbia Street West, Unit 1803, Waterloo, Ontario N2L 0K7, Canada · [email protected] · +1 (548) 490-9330