Import a PDF Bank Statement Into QuickBooks Online
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.
Short answer
QuickBooks Online does not import a raw PDF as a file. You have three options: use the built-in AI upload (capped at 1,000 transactions and 350 KB per file, Online only, no review before posting), convert the PDF to a QBO Web Connect file and import it under Bank Feeds (reviewable, no caps, works on Online and Desktop), or convert it to a CSV and map the columns. For accuracy, larger statements, and Desktop, converting to a QBO file is the most reliable route.
Last updated June 2026.
You downloaded a bank statement, it came as a PDF, and now QuickBooks Online will not take it. This is one of the most common bookkeeping snags, and it has a few good fixes. Below are the three ways that actually work, when to use each, and the exact clicks for the method most people want: a clean QBO file that imports under Bank Feeds.
Can QuickBooks Online read a PDF bank statement?
Yes, but with limits. QuickBooks Online added an AI-powered upload that reads a PDF or image statement and pulls out the transactions. It caps each file at 1,000 transactions and 350 KB, works in QuickBooks Online only (not Desktop), and posts the transactions without letting you review them first. For a quick one-off month it is fine. For long statements, scans, multiple accounts, or when you need to check the numbers before they hit your books, converting the PDF to a QBO file gives you more control.
Method 1: Upload the PDF straight into QuickBooks Online
This uses the built-in statement upload. It is the fastest path when your statement is short and clean.
- In QuickBooks Online, go to Transactions, then Bank transactions.
- Pick the account you want the transactions to land in (or add the account first).
- Select Upload from file, then drag in your PDF or image statement.
- Map the account, confirm, and let QuickBooks read and post the transactions.
Watch the limits: 1,000 transactions and 350 KB per file. If your statement is longer, split it into shorter date ranges and upload each piece. Because there is no review step before posting, check the imported total against the statement total afterward and fix any misread lines.
Method 2: Convert the PDF to a QBO file and import under Bank Feeds
This is the route most bookkeepers and accountants prefer. You turn the PDF into a QBO Web Connect file, then import it the same way QuickBooks handles a connected bank feed: the transactions wait in the Banking center so you review, match, and accept them. Nothing posts until you say so, there is no 1,000-line cap, and the same QBO file works in QuickBooks Online and Desktop.
- Convert the statement with a PDF bank statement to QuickBooks converter. Upload the PDF, check the extracted dates, descriptions, and amounts against the statement, then export a QBO (Web Connect) file. You can do this at the top of this page.
- In QuickBooks Online, open Transactions, then Bank transactions, and choose the right account.
- Select Upload from file and choose your QBO file.
- Review the transactions in the For review tab, set categories and rules, then add them to the register.
Because you verify the data before exporting and again before adding it to the register, this method catches OCR errors that a straight upload would post silently. It is the better choice for scanned statements, statements with hundreds of lines, or any time accuracy matters. Banks like Chase and Wells Fargo have their own statement layouts, so a converter that reads each format cleanly saves a lot of retyping.
Method 3: Convert the PDF to a CSV and map the columns
QuickBooks Online also accepts a three-column or four-column CSV (date, description, amount, or separate debit and credit columns). If you would rather work in a spreadsheet first, convert the PDF to CSV, clean it up, and upload it.
- Convert the statement to a spreadsheet. A dedicated PDF bank statement to Excel and CSV converter keeps the columns aligned, which saves you from re-aligning rows by hand.
- Trim the file to the columns QuickBooks expects and save it as CSV.
- In QuickBooks Online, choose Upload from file, select the CSV, and map your columns to the QuickBooks fields.
CSV gives you the most control over messy statements, but it is also the most manual. If your data already lives in a spreadsheet and you only need the QuickBooks format, a CSV to QBO converter turns it into a Web Connect file so you get the reviewable Bank Feeds workflow instead of a raw column map.
Which method should you use?
| Method | Best for | Review before posting? | Size limit | Works on Desktop? |
|---|---|---|---|---|
| Built-in PDF upload | One short, clean statement | No | 1,000 txns / 350 KB | No, Online only |
| Convert to QBO file | Accuracy, long statements, scans, batches | Yes, in Bank Feeds | None | Yes |
| Convert to CSV | Spreadsheet cleanup before import | Yes, you edit the file | Practical, not hard-capped | Workarounds only |
How do I import a PDF bank statement into QuickBooks Desktop?
QuickBooks Desktop does not have the AI PDF upload, so you convert first. Turn the PDF into a QBO (Web Connect) file and import it through Banking, then Bank Feeds, then Import Web Connect File. If you need transactions to land straight in the register with no bank-feed matching, an IIF file works on any Desktop version offline. See our QuickBooks Desktop IIF import guide for the difference.
Troubleshooting common errors
Why won't my PDF upload into QuickBooks Online?
The most common causes are a file over 350 KB, more than 1,000 transactions, a password-protected PDF, or a scanned image the reader cannot parse. Remove the password, split long statements into shorter date ranges, and if it is a scan, use a converter with OCR. Converting to a QBO file sidesteps the size and line caps entirely.
The amounts imported as positive when they should be negative
This happens when debits and credits land in one column with the wrong sign. In a CSV, split them into separate debit and credit columns before upload. In a QBO file from a good converter, the sign is set from the statement, so review the first few rows to confirm before you import.
Duplicate transactions after import
If a date range overlaps with transactions already in QuickBooks, you will see duplicates in the For review tab. Exclude the overlap or narrow the statement date range before converting, and use the Bank Feeds review step to skip anything already in the register.
Frequently asked questions
Does QuickBooks Online accept PDF bank statements?
Yes, through the built-in upload that reads a PDF with AI, but it caps each file at 1,000 transactions and 350 KB, runs on QuickBooks Online only, and posts without a review step. For long statements, scans, or when accuracy matters, convert the PDF to a QBO file and import it under Bank Feeds so you can review first.
What is a QBO file?
A QBO file is a QuickBooks Web Connect file in the OFX format. QuickBooks treats it like a download from your bank: the transactions appear in the Banking center for you to review, match, and accept. It carries dates, descriptions, and amounts, and works in both QuickBooks Online and Desktop.
Is it safe to convert a bank statement to QBO?
A reputable converter processes the file, returns your QBO output, and does not change your bank or QuickBooks login. Review the extracted transactions against the original statement before importing. Keep the source PDF until the import reconciles cleanly so you always have the record to check against.
How many transactions can I import at once?
The built-in QuickBooks Online upload caps each file at 1,000 transactions. A converted QBO or IIF file has no such cap, so it is the better choice for full-year catch-up work or statements with hundreds of lines. Split very large files only if your bank statement spans multiple accounts.
Once your statements import cleanly, the next job is usually catching the books up and reconciling. If you are several months behind, see our guide on catch-up bookkeeping from PDF bank statements, or compare the tools that do this in our best PDF to QBO converter roundup. On QuickBooks Self-Employed or Solopreneur instead? Those products import CSV, not PDF, so see how to get a PDF bank statement into QuickBooks Self-Employed.