How to Prepare 1099-NEC Forms From Bank Statements

Jul 21, 2026

Convert your bank statement to Excel now

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940

Upload your bank statement

Last updated July 2026.

To prepare 1099-NEC forms from bank statements, total the direct payments (check, ACH, and bank transfer) you made to each US contractor during the year, then issue a 1099-NEC to any vendor you paid $2,000 or more. Payments you made by credit or debit card or through an app like PayPal do not count, because the processor reports those on a 1099-K. Convert your statement PDFs into a spreadsheet and sum by payee, and the list of who gets a form falls out in minutes.

Most small businesses do not run a clean vendor ledger all year, so at tax time the checking account is the only complete record of who was paid what. That is why the January scramble almost always starts with a stack of bank statements. If yours are PDFs, convert each statement to a spreadsheet first so you can sort and total the rows instead of reading them line by line.

Why bank statements are the source record for 1099-NEC

A 1099-NEC reports nonemployee compensation you paid to independent contractors, freelancers, and unincorporated service vendors. The catch is that not every payment you made belongs on it. Under IRS rules, any payment made with a credit card, debit card, or third-party network (PayPal, Venmo business, and similar apps) is reported by the payment settlement entity on Form 1099-K, not by you. You only report the payments that left your bank directly: checks, ACH transfers, wire, and bill-pay.

That single rule is what makes the bank statement the right document to work from. Your accounting software might show a vendor's full spend for the year, but a chunk of that could be card payments the processor already covers. The bank statement shows exactly what you paid by check and ACH, which is precisely the set of payments the 1099-NEC threshold is measured against.

The 2026 threshold is $2,000, not $600

The One Big Beautiful Bill Act raised the 1099-NEC filing threshold. For payments made on or after January 1, 2026, you file a 1099-NEC when total qualifying payments to a payee reach $2,000 or more. The old $600 line still applies to 2025 payments you report in early 2026, and the new $2,000 amount is indexed for inflation starting in 2027.

Tax year (payments made)1099-NEC thresholdForms due to recipient and IRS
2025$600 or moreJanuary 31, 2026
2026$2,000 or moreFebruary 2, 2027
2027 and later$2,000, inflation-indexedLate January or early February

One exception overrides the dollar line entirely: if you withheld federal income tax from a contractor under backup withholding, you file a 1099-NEC no matter how small the payment was.

How to find contractor payments in your bank statements

The work is mechanical once the statements are in a spreadsheet. Here is the sequence that produces a clean, defensible 1099 list.

  1. Gather every business checking statement for the year. Pull all twelve monthly PDFs (plus any from a closed account you used during the year). Keep personal accounts out of it.
  2. Convert the PDFs to rows. Turn each statement into a spreadsheet with date, description, and amount columns so every payment is one sortable line. Merge all months into a single sheet.
  3. Isolate the money that left by check and ACH. Filter out deposits, transfers between your own accounts, card payments, and app transfers. What remains is the pool of payments that can trigger a 1099-NEC.
  4. Group by payee and total each one. Use SUMIF or a pivot table on the description or a cleaned vendor name to get one annual total per contractor. Standardize spellings first so "Acme LLC" and "ACME" do not split into two lines.
  5. Flag every vendor at or above the threshold. Any US individual or unincorporated business you paid $2,000 or more by check or ACH in 2026 needs a form. Request a completed Form W-9 from each so you have the legal name and TIN.

The cleanest long-term fix is to categorize every vendor payment as it clears during the year instead of reconstructing twelve months of spending each January. But when the year is already over, the statement-to-spreadsheet route gets you an accurate list fast.

Which payments count toward the 1099-NEC threshold

Use this to decide whether a given line on the statement belongs in the total.

PaymentCounts toward 1099-NEC?Why
Check to a contractorYesDirect payment you must report
ACH or bill-pay to a vendorYesDirect payment you must report
Wire transfer for servicesYesDirect payment you must report
Business credit or debit cardNoProcessor reports it on 1099-K
PayPal, Venmo business, other appsNoThird-party network reports it on 1099-K
Payment to a C or S corporationNoCorporations are generally exempt (except attorneys)
Reimbursement of goods or materialsNo1099-NEC covers services, not products

Payments to a law firm are the notable exception: gross proceeds and fees paid to an attorney are reportable even when the firm is incorporated.

Do I need to send a 1099 if I paid by credit card?

No. Payments made with a credit card, debit card, or a third-party payment network are excluded from the 1099-NEC. The card processor or app reports them to the IRS on a 1099-K instead, so reporting them again would double-count the income. This is exactly why you screen out card lines when you total payments from your bank statement.

What is the 1099-NEC threshold for 2026?

For payments made during 2026, you must file a 1099-NEC for any payee who received $2,000 or more in qualifying nonemployee compensation. That is up from the $600 threshold that still applies to 2025 payments. Starting in 2027 the $2,000 figure is adjusted for inflation each year.

How do I find out how much I paid a contractor during the year?

Add up every check and ACH payment to that contractor across all twelve months of bank statements. The fastest way is to convert the statement PDFs to a spreadsheet, standardize the payee names, and run a SUMIF or pivot table by payee. That gives you one annual total per vendor, which you compare against the $2,000 threshold.

Do I issue a 1099-NEC to an LLC?

Usually yes. A single-member LLC or an LLC taxed as a partnership is treated as unincorporated, so it gets a 1099-NEC if you paid it $2,000 or more for services. An LLC that elected C-corp or S-corp taxation is generally exempt. The W-9 tells you which box the vendor checked, so collect it before you decide.

What happens if I do not file a 1099-NEC?

The IRS charges a per-form penalty that rises the longer you wait, from a smaller amount for filing within 30 days late up to a larger amount for intentional disregard. Filing late is far cheaper than not filing, and keeping a clean spreadsheet of vendor totals from your bank statements is the simplest way to make sure no reportable contractor is missed.

Turn the statements into a 1099 worksheet

The whole job comes down to one clean spreadsheet of payments grouped by payee. Start by turning your statement PDFs into rows with the bank statement converter, then categorize the transactions so contractor payments sit in one bucket you can total. If you also need year-end profit numbers, the same data feeds a profit and loss report. For deduction planning on the expense side, the Schedule C expense categories list maps the rest of your spending.

Ready to convert your bank statement?

Upload a PDF and get clean Excel or CSV in seconds. Works with statements from any bank.

Convert to Excel now

Free to try, no credit card required

From the same family of tools