How to Prepare 1099s From Bank Statements in QuickBooks

You can prepare accurate 1099s straight from your bank statements, and for a lot of small businesses it is the most reliable way to do it. Every payment you made to a contractor by check or ACH shows up on the statement, so once those transactions are in QuickBooks and reconciled, QuickBooks totals what you paid each vendor for the year and fills in the 1099-NEC. The catch is that payments made by credit card or a third-party app do not belong on your 1099-NEC at all, and your books have to be complete first. Here is how to do it right.

The upload tool at the top of this page converts a PDF bank statement to a QuickBooks file so the vendor payments 1099s are built from are actually in your books before year-end.

Can you create 1099s from bank statements?

Yes. Your bank statements are the record of what you actually paid, so they are a valid source for building 1099s, as long as every payment to a reportable vendor is entered in QuickBooks and coded to that vendor. The workflow is to reconcile each bank account to its statements, confirm every contractor payment is posted, then let QuickBooks run its 1099 report against the vendor totals. Statements are especially useful when a bank feed missed months or the file was started late, because they let you rebuild the full year of payments the 1099s depend on.

How to prepare 1099s from bank statements in QuickBooks

Work in order. Getting the payments in and reconciled first is what makes the 1099 totals trustworthy.

Steps one and two are the ones people skip, and they are the reason a 1099 comes out wrong. If a contractor was paid across two accounts and only one is reconciled, the form understates what you paid. Reconciling both against the statements catches it.

What is the 1099-NEC threshold for 2025 and 2026?

For the 2025 tax year, which you file in early 2026, you must issue a 1099-NEC to any unincorporated contractor you paid $600 or more for services during the year. For the 2026 tax year, the One Big Beautiful Bill Act raises that threshold to $2,000, and it will be adjusted for inflation starting in 2027. The change is only about the reporting floor: a contractor still owes tax on what they earned even if you paid them under the threshold and never send a form. When you build the totals from reconciled bank statements, you can see at a glance who crossed the line for the year you are filing.

Which payments go on a 1099 and which do not?

Only payments made by cash, check or ACH bank transfer go on a 1099-NEC. Payments you made with a credit card, debit card, or a third-party network like PayPal or a payment app are specifically excluded, because the card processor or app reports those on a 1099-K instead. If you put a card charge to a contractor on their 1099-NEC as well, the income gets reported twice. This is exactly why reconciling matters: your bank statement shows the check and ACH payments that belong on the 1099-NEC, and your credit card statement shows the charges that do not. Import both, so convert the credit card statement to QuickBooks as well and keep the card charges clearly separated from the checks.

How do I find how much I paid a contractor in QuickBooks?

Run a report on the vendor for the year and read the total. In QuickBooks Online, open Reports, run a Transaction List by Vendor or the 1099 Transaction Detail report, set the date range to the calendar year, and filter to the contractor. The total of the check and ACH payments is what goes on the 1099-NEC. If the number looks low, an account that was never reconciled is usually hiding payments, so go back to the statements and confirm every month posted before you trust the figure.

What information do I need from each contractor?

You need a completed Form W-9 before you can file. It gives you the contractor's legal name or business name, their address, their taxpayer identification number, and their tax classification, which tells you whether they are exempt from 1099 reporting. Collect the W-9 when you first hire someone, not in January, because chasing a TIN at filing time is where the deadline gets blown. QuickBooks stores the W-9 details on the vendor record so the 1099 populates automatically once the payment totals are in.

When are 1099s due?

Form 1099-NEC is due to both the contractor and the IRS by January 31. If January 31 falls on a weekend, the deadline moves to the next business day. There is no automatic extension for 1099-NEC the way there is for some other forms, and late or incorrect filings carry per-form penalties that climb the longer you wait. Reconciling and totaling from statements in December, rather than scrambling in late January, is the difference between filing on time and paying a penalty.

What if I am missing months of payment history?

If your bank feed skipped months or you started the QuickBooks file partway through the year, the payment totals will be wrong until you fill the gaps, and the fastest fix is the statement. Download the PDF for each missing month and convert a whole year of statements at once so every contractor payment lands in the register, then reconcile and re-run the 1099 report. Keeping vendor bills and payments organized through the year makes this even faster, because the amounts are already coded to the right vendor when December arrives. For a fuller year-end walkthrough, work through the year-end close checklist and make sure the books are reconciled before you generate a single form.

The contractor's name on the statement is not the name on the W-9

This is the single most time-consuming part of rebuilding 1099 totals from statements, and it is worth knowing before you start. A bank statement shows whatever the payment rail captured, which is often a DBA, an abbreviated business name, a payment processor's descriptor, or in the case of a check simply the check number with no payee at all. The W-9 gives you a legal name. Matching one to the other is manual work, and doing it wrong understates a contractor rather than producing a visible error.

Work from the contractor list rather than from the statement. Take each contractor you know you used, then search the converted transactions for every spelling that could be them, including the personal name behind a single member LLC and any shortened form the bank might have truncated to. Checks are the hard case: if the statement shows only a check number, you need the check register, the cleared check images from the bank portal, or your own records to attribute it. Attribute what you can, then total the unattributed checks and work out whose they were before you file, because an unattributed check to a subcontractor is a reportable payment sitting outside your totals.

What about contractors I paid from a personal account?

If the business owes the payment, it is reportable regardless of which account it physically came out of. An owner who pays a subcontractor from a personal checking account and reimburses themselves later has still made a business payment to that contractor, and it counts toward the threshold. The bookkeeping is a two-step: record the expense against the contractor with the owner's contribution or due-to-owner account as the funding source, then record the reimbursement separately as a repayment rather than as a second expense. Booking both as expenses doubles the contractor's 1099 total, which is the more damaging error of the two.

This is a common situation in the first year of a business and in construction, and it is precisely the payment history a bank feed will never surface, because the account is not connected and should not be. The personal statement is the only record.

I already filed and then found more payments. What now?

File a corrected 1099. You mark the form as corrected, report the right total rather than the difference, and send the corrected copy to the contractor as well as to the IRS. Doing it promptly matters more than doing it perfectly, because penalty amounts step down when a correction is filed within 30 days of the due date and step up the longer the wrong figure stands.

Tell the contractor before the corrected form arrives. They may have already filed a return using the original figure, and an unexplained corrected 1099 landing in March creates an amended return for them and a difficult conversation for you. A short email with the reason and the new number costs nothing and preserves the relationship.

Where the rest of this fits

Everything above is the reconstruction job: taking a year that is not in QuickBooks and making it complete. Once the payments are in the file, the mechanics of the forms themselves, the vendor flags, the account-to-box mapping, the card payment exclusion and the current reporting thresholds, are covered on the QuickBooks 1099 forms page, which also carries the 2026 threshold change and the filing deadlines in table form.

The theme is the same one that runs through every clean set of 1099s: the form is only as good as the payment history behind it. Get every check and ACH into QuickBooks from the statements, reconcile, exclude the card payments, and the 1099s almost fill themselves in.