Bank Statement Conversion for 1099 Vendor Prep

What counts as a reportable payment

A 1099-NEC reports what you paid a non-employee vendor for services, but only certain payments count. If you paid by check, cash, or direct bank transfer such as ACH, those payments are yours to report once they reach the annual per-vendor threshold. The IRS itself points to your check register, bank statements, and accounts payable records as where to confirm whether a vendor crossed that line. The problem is that a bank statement arrives as a PDF, so totaling a year of payments to a given vendor by hand across twelve statements is slow and easy to get wrong. Converting the statements to a CSV turns that into a sort-and-sum job.

Convert statements to total payments per vendor

With a year of statements in a single CSV, finding your reportable vendors becomes straightforward. Sort or filter the outflows, group them by payee, and sum each one to get the annual total per vendor. A pivot on the payee column gives you every vendor's yearly figure at once, so the ones at or above the threshold stand out immediately. This is far more reliable than scanning statement pages, and it catches the vendor you paid in several smaller checks across the year whose total quietly crossed the line, exactly the case a page-by-page review tends to miss.

Exclude card and third-party payments

One rule prevents double-reporting and trips up a lot of filers: payments you made by credit card or through a third-party platform like PayPal, Stripe, or Square are not yours to report. The payment processor handles those on a 1099-K, so issuing a 1099-NEC for them too would report the same income twice. That is why bank statements are the right source: they show the checks and ACH transfers you are responsible for, while card spend lives on a separate statement you deliberately leave out. Working from the bank data keeps your 1099-NEC set to just the payments that are actually yours to file.

The threshold, and confirming it

The dollar cutoff is a moving target, so confirm it for the year you are filing. For the 2025 tax year the per-vendor threshold was $600, and beginning with 2026 payments it rises to $2,000 under the 2025 tax law change, with the figure indexed after that. Because this number changed recently and is easy to get wrong, check the current IRS instruction for the filing year rather than relying on memory. Whatever the figure, the method is the same: a converted CSV lets you total each vendor for the calendar year and compare against the threshold in force, so you file for the vendors who cross it and no one else.

W-9s, records, and privacy

Once the CSV tells you which vendors are reportable, you need a valid W-9 on file for each to get the legal name and taxpayer ID for the form; best practice is to collect one before you ever pay a contractor. Keeping the converted payment totals alongside those W-9s gives you a clean, defensible record of how each 1099-NEC figure was derived. Because these are your business's financial records, statements are processed to build the CSV and then deleted automatically, with nothing retained on a server afterward, which keeps vendor and account detail out of a third-party system while you prepare the filing.

Frequently Asked Questions