Find 1099 Contractor Payments in Bank Statements

TL;DR If your business pays freelancers or other contractors, you may need to file information returns such as Form 1099-NEC for some of them. Your bank statements are often the most complete record of who you paid. Convert a full year of statements for every business account, give each contractor a single clean payee name, record how each payment was made (check, ACH, wire, card, or payment app), and total payments per payee with a pivot table. Payments made by credit card or through some payment platforms are generally reported by the payment company rather than by you, so keep them separate. Then compare each payee's total with the current IRS rules and thresholds, gather W-9s, and check the list with your tax preparer. This is general information, not tax advice.

January has a habit of arriving with a question many small business owners haven't thought about since the previous January: who did we pay this year, and do any of them need a 1099? If you used accounting software with vendor tracking all year, the answer may be a report away. If you didn't, or if payments went out from several accounts in several ways, your bank statements are the place to start.

This guide shows how to build a contractor payment list from bank and card statements in Excel: which statements to gather, how to clean up payee names, why the payment method matters, how to total by payee, a worked example, and the checks to do before filing. Rules for information returns, including who must receive a form and the dollar thresholds, are set by the IRS and have changed in recent years. We describe the process of organising your records; check current IRS instructions and confirm with a tax professional.

Why bank statements are the right starting point

Contractor payments leave a trail in your bank and card accounts regardless of how organised your other records are. Invoices may be missing, emails may be scattered, and a contractor may have been paid partly by check and partly by transfer. The statements show every payment that actually happened, with the date and amount.

What statements don't show, at least not reliably, is the payee's legal name, their tax status, or what the payment was for. You'll fill those gaps from W-9 forms, invoices and your own records. The statements give you the list to work from.

Step 1: gather and convert a full year

For the tax year in question, collect statements for every account you might have used to pay contractors:

• Business checking accounts.
• Business credit cards.
• Payment apps or platforms used to pay people.
• Personal accounts, if any business payments went through them (and make a note to stop doing that).

Convert each statement into rows. SheetStatement turns PDF statements into Excel or CSV and checks that each statement's opening balance plus transactions equals its closing balance, so you know nothing is missing. The free plan covers 3 pages a month; for a full year, a paid plan at $9, $19 or $39 a month is usually easier.

Stack all months and accounts into one table with these columns:

Our guide to combining multiple bank statements in Excel explains how to stack them cleanly.

Step 2: filter to payments out

You only care about money going out, so filter Amount to negatives. Then exclude rows that clearly aren't payments to people or businesses for services:

• Transfers between your own accounts.
• Credit card payments from checking (the card's own statement has the individual purchases).
• Loan repayments, tax payments, bank fees.
• Payroll for employees, which is reported through payroll, not 1099s.

Tag those rows rather than deleting them, so you can always see what you excluded and why. Our guide to Excel FILTER for bank transactions shows how to pull out the remaining rows into a working list.

Step 3: record the payment method

This step is easy to skip and important not to. How you paid a contractor can affect who is responsible for reporting the payment.

Under general IRS rules, payments made by credit card, debit card or through certain third-party payment networks are generally reported by the card company or payment settlement entity, typically on Form 1099-K, rather than by you on a 1099-NEC. Payments by check, ACH, wire or cash are generally ones you would consider for your own reporting. The details matter, including how particular payment apps treat business payments, so check the current instructions.

Fill the Method column from the account and description:

• Rows from a credit card statement: Card.
• Rows from checking with check numbers: Check.
• Transfers described as ACH, online transfer or bill pay: ACH or Bill pay.
• Wires: Wire.
• Payment app transfers: Payment app, with a note of which one.

Bill pay services deserve a second look. Depending on how the bank sends them, a bill pay payment may go out as an electronic transfer or a mailed check. Either way, it's usually a payment from your bank account rather than by card.

Step 4: normalise payee names

Bank descriptions are messy. The same contractor might appear as "ONLINE TRANSFER TO J SMITH DESIGN", "Check 1042" and "ZELLE TO JANE SMITH". To total by payee, every payment to the same person needs the same Payee value.

Practical approach:

1. Checks: the bank description usually shows only the check number. Use your check register, copies of cancelled checks if your bank provides images, or invoices to identify the payee.
2. Transfers: extract the name from the description. Our guide to splitting transaction descriptions in Excel has formulas for pulling text after "TO" or before a reference.
3. Build a mapping table of description patterns to clean payee names, and use a lookup to fill the Payee column automatically. The approach is the same as categorising with keywords; see our guide to Excel formulas for categorising transactions.

Use the payee's legal or business name as it appears on their W-9 if you have it. That's the name you'll need for any form.

Step 5: mark contractors

Not every payee is a contractor. Software companies, landlords, utilities and suppliers of goods appear in the list too. Add a Contractor? column and mark the payees who provided services to your business as non-employees: freelancers, consultants, designers, developers, bookkeepers, cleaners, repair people, and so on.

Some payees may be exempt from reporting depending on their business structure, for example many corporations. Others, such as attorneys, may have different rules. These are judgement calls that depend on current rules, so mark what you know and flag the rest for your preparer.

Step 6: total by payee and method

Insert a pivot table:

• Filters: Contractor? = Yes.
• Rows: Payee.
• Columns: Method.
• Values: Sum of Amount.

You'll see each contractor's total split by how they were paid. The total for non-card methods is the figure to compare with the reporting threshold. Our guide to bank statement pivot tables in Excel explains the setup. If you prefer formulas:

=-SUMIFS(Tx[Amount], Tx[Payee], H2, Tx[Contractor?], "Yes", Tx[Method], "<>Card")

The leading minus turns the negative total into a positive amount paid. If you use a payment app category that's reported by the platform, exclude it the same way.

About the threshold. According to the IRS, the Form 1099-NEC threshold for nonemployee compensation was $600 per payee for payments made before 2026, and it is $2,000 for payments made in 2026, with inflation adjustments planned for later years. Separately, if you withheld federal income tax under the backup withholding rules, a form is generally required regardless of the amount. Because these figures change, check the IRS instructions for the year you're filing, and set your threshold in a cell (say K1) so the list updates if you change it:

=IF(I2>=$K$1, "Review for 1099", "Below threshold")

where column I holds each payee's non-card total. The label says "review" deliberately: crossing the threshold tells you to look closely, not that a form is definitely required, because the payee's status and the type of payment also matter.

A worked example

A small marketing agency pays several people during 2026, so the $2,000 threshold for payments made in 2026 applies. The agency's owner sets that figure in the threshold cell and works through the list in early December, which leaves time to chase any missing W-9s before the January deadline. After converting statements for the business checking account and business credit card, tagging transfers and non-contractor payments, normalising names and marking contractors, the pivot table looks like this:

Observations:

• Jane Smith Design was paid partly by check and partly by ACH. Without combining both methods, her total would have been understated. Her $6,000 total is above both the old $600 and the 2026 $2,000 threshold.
• Lee Photography was paid only by card. Under the general rule, the card company handles reporting for those payments. The agency notes it but doesn't count it toward its own reporting.
• Patel Web Services LLC is an LLC. Whether a form is needed depends on how the LLC is taxed, which the W-9 should show.
• Rivera Copywriting received $2,250, which is above the 2026 threshold, so it's flagged for review.
• K. Nguyen received $450, below the threshold for 2026 payments, unless backup withholding applied.

The agency sends this list, with W-9s attached, to its preparer, who confirms which forms are needed.

Payments to attorneys and other special cases

A few kinds of payee are worth flagging in your list because the usual assumptions may not apply.

Attorneys and law firms. IRS instructions treat payments to attorneys for legal services as reportable on Form 1099-NEC, and the general exemption many businesses rely on for corporations doesn't necessarily apply to them. If your list includes legal fees, mark them for your preparer.

Parts and materials. If a contractor's invoice included parts or materials as part of the service, such as a repair job, the IRS describes nonemployee compensation as including parts and materials. Don't strip the materials out of the total without checking.

Rent and other non-service payments. Some payments that aren't for services, such as rent paid to an individual landlord, can be reportable on a different form (Form 1099-MISC). If you pay rent to a person rather than a property company, flag it.

Payments to your own employees. People on your payroll receive a W-2, not a 1099, for their wages. If you also paid an employee separately for something outside payroll, ask your preparer how it should be handled rather than guessing.

Reimbursed expenses. If a contractor billed you for travel or supplies and you reimbursed them, keep those rows with a note. Whether they're included depends on how the arrangement works.

Marking these rows in a Notes column keeps the decisions visible. When you sit down with your preparer, you can filter to the flagged rows and resolve them in one go, instead of hunting through hundreds of transactions.

Step 7: collect W-9s and check names

For each payee who may need a form, you need their legal name, address and taxpayer identification number, usually collected on Form W-9. Ideally, request a W-9 before the first payment. If you haven't, request it now.

Compare the W-9 name with your Payee column. If a contractor operates under a business name, the form typically uses the name and number on the W-9, not the name on the bank description.

Step 8: tie totals back to the statements

Before anything is filed, make sure your totals are trustworthy:

• Every statement balances, and months chain together.
• Every payment to a contractor is included, including checks you identified from images or the register.
• No duplicates. If statements overlapped when you combined them, duplicates inflate totals. Our guide to removing duplicate bank transactions helps.
• Refunds or returned payments are netted. If a payment bounced and was re-sent, the returned amount should cancel the original.

Keep the workbook and statements together. If a contractor queries the amount on their form, you can show them every payment. It's also worth saving a copy of the final payee list as a PDF alongside the forms you file, so next year you can see at a glance who was paid and how the decisions were made.

Common mistakes

Ignoring checks. Check payments show only a number on the statement, so they're easy to miss when filtering by name.

Counting card payments. Generally reported by the card company, not you. Keep them visible but separate.

Splitting one contractor into several names. Normalise payee names or totals will be too low.

Including reimbursements as fees. If you reimbursed a contractor for expenses separately, discuss with your preparer how those should be treated.

Waiting until the deadline. Form 1099-NEC is generally due by January 31, and collecting missing W-9s takes time. Start in December if you can.

Do it monthly next year

The easiest January is one where the list already exists. Each month:

1. Convert and check the month's statements.
2. Fill Payee, Method and Contractor? for payments out.
3. Request a W-9 from any new contractor straight away.

At year end, the pivot table is ready. Our guide to month-end close for small businesses has a routine that fits this in.

Start from your statements

Upload a year of business bank and card statements to SheetStatement, confirm each balance, and export one spreadsheet you can total by payee. The free plan covers 3 pages a month; Starter, Pro and Business plans are $9, $19 and $39 a month.

FAQ

Can I use bank statements to find contractor payments for 1099s?

Yes. Bank and card statements show every payment that was made, which makes them a good starting list. You'll still need W-9s and invoices for names, tax IDs and the nature of each payment.

Do I count payments made by credit card?

Payments made by card or through certain payment networks are generally reported by the payment company rather than by you. Keep them separate in your list and check current IRS instructions.

What is the 1099-NEC threshold?

The IRS states it was $600 for payments made before 2026 and is $2,000 for payments made in 2026, with inflation adjustments planned after that. Always check the instructions for the year you're filing.

How do I identify who a check was paid to?

Use your check register, check images from your bank if available, or the matching invoice.

Do I need to send a 1099 to an LLC?

It depends on how the LLC is taxed. The W-9 should indicate its tax classification; confirm with your preparer.

Is this tax advice?

No. It's general information about organising records. Consult a tax professional and the current IRS instructions.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Paid plans are Starter at $9 a month, Pro at $19 and Business at $39.