How to Prepare 1099s From Bank Statements in QuickBooks
Convert a PDF bank statement to a QuickBooks file
Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.
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.
| # | Step | What it fixes |
|---|---|---|
| 1 | Import every bank and credit card statement for the year | The complete record of what you paid |
| 2 | Reconcile each account to its statements | Confirms no payment is missing or duplicated |
| 3 | Collect a W-9 from every contractor | Legal name, address and TIN for the form |
| 4 | Mark reportable vendors as Track for 1099 | Tells QuickBooks who gets a form |
| 5 | Map the expense accounts to 1099 boxes | Puts each payment in the right box |
| 6 | Exclude card and third-party payments | Those are reported on 1099-K by the processor |
| 7 | Review the 1099 summary and file by January 31 | Totals tie to the reconciled register |
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.
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 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.