Import a bank statement into QuickBooks Online or Desktop. Convert your PDF to a .qbo file, upload it under Bank transactions, and reconcile to the penny.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF · Max 50MB
Uploading...
To import a bank statement into QuickBooks Online, convert the statement PDF to a .qbo file, then upload it under Transactions, Bank transactions, Upload from file. QuickBooks reads the .qbo as a standard bank feed, so every transaction date, description, and amount lands in the For review tab ready to categorize. The same .qbo file imports into QuickBooks Desktop through File, Utilities, Import, Web Connect Files.
Upload your PDF statement in the converter above and you get a .qbo file back in seconds, plus matching Excel and CSV copies. There is no column mapping and no template to build. It reads statements from any US bank, including checking, savings, and credit card accounts, and verifies the totals before export so nothing is dropped on the way in.
Built for the statements US banks actually send, checked before it exports.
The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.
Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, email [email protected].
Convert the statement to a .qbo file, then in QuickBooks Online go to Transactions, Bank transactions, select the account, open the dropdown next to Link account, and choose Upload from file. Pick your .qbo and confirm the account. The transactions appear in the For review tab, where you accept, categorize, or match each one. Using a .qbo file skips the column-mapping step that CSV uploads require.
QuickBooks Online's Upload from file accepts .qbo (Web Connect), .qfx (Quicken), .ofx, and .csv files. Banks give you a PDF statement, which QuickBooks cannot read directly, so you convert the PDF to one of those formats first. A .qbo file is the cleanest option because it carries the bank identifier and a structured transaction list, so QuickBooks imports it without you matching headers or choosing a date format. For a full breakdown of each option, see QuickBooks bank import file formats.
An uploaded file must be 350 KB or smaller and contain no more than 1,000 transaction lines per upload. A CSV needs either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), with dates in one consistent format. If a statement is too large, split it by month or quarter and upload each file in turn; here is how many transactions QuickBooks imports at once and how to load more. Converting to .qbo sidesteps the column rules entirely, since the format already structures the data the way QuickBooks expects.
Each way of getting transactions into QuickBooks accepts different files and reaches back a different distance. This table lays out the four routes side by side so you can pick the one that fits the statement in front of you. Last updated July 2026.
| Import route | Accepted formats | Size or line limit | How far back it reaches | Key constraint |
|---|---|---|---|---|
| QuickBooks Online, Upload from file | .qbo, .qfx, .ofx, .csv | 350 KB and 1,000 lines per file | Any period you hold a statement for | A CSV needs Date, Description, Amount columns in one date format; a raw PDF or .xlsx is rejected |
| QuickBooks Desktop, Import Web Connect | .qbo only | No fixed line cap, but the install must be within about three years old | Any period you hold a statement for | Rejects .qfx, .ofx, and .csv; only a true .qbo imports |
| Live bank feed (connected account) | Automatic, no file | Not applicable | Often about 90 days on first connect, varies by bank | Aggregator errors and reconnect prompts; it will not backfill older history |
| This converter (PDF to .qbo) | PDF or image in; .qbo, Excel, and CSV out | Convert one statement period per file to stay under 350 KB and 1,000 lines | As far back as you have PDF statements, including archived years | The upload must be a PDF or image, not a scan of a spreadsheet |
In QuickBooks Desktop, go to File, then Utilities, then Import, and choose Web Connect Files, then select your .qbo file and the account to import into. Desktop does not import a raw PDF or a plain CSV bank statement, so the .qbo route is the standard path. One catch: your Desktop version must be no more than three years old to accept a .qbo, so a very old install may need updating first.
Yes, within limits. QuickBooks Online now accepts an account statement as a PDF or image on the Upload from file screen and extracts the transactions with AI, provided the file is in English and 350 KB or smaller. Larger statements, scans, and phone photos get rejected on size, and QuickBooks Desktop has no PDF path at all. Converting the PDF to a .qbo file first avoids every one of those limits, and the converter above handles that step. If you are working from paper or photos, see scanning bank statements into QuickBooks.
Uploading bank transactions and importing a bank statement are the same task in QuickBooks Online: both go through Transactions, Bank transactions, Upload from file. Convert the statement to .qbo or CSV, choose the file, pick the account, and the transactions arrive in the For review tab. From there you match them to existing entries or add them, then reconcile against the statement's printed ending balance.
The most common reasons are an unsupported file (a raw PDF or an Excel .xlsx), a CSV with the wrong column layout or mixed date formats, a file over the 350 KB or 1,000-line limit, or a .qbo missing the bank identifier QuickBooks requires. Converting the statement to a proper .qbo file removes most of these problems at once, since the format is built to the spec QuickBooks validates against. If an import still fails, check the file size and split the statement by month.
A live bank feed in QuickBooks usually pulls only about 90 days of history, which leaves a gap when you open an account or take over books mid-year. Because you can download monthly PDF statements for years, converting each one to .qbo lets you backfill every missing month. Import them oldest first so each month reconciles in order. Our guide to importing old bank statements into QuickBooks covers the catch-up workflow in detail.
Import a .qbo file whenever you can. A .qbo carries the bank account identifier and a clean transaction structure, so QuickBooks imports it without column mapping or date-format choices, and it rarely fails. A CSV makes you match headers to QuickBooks fields, set the date format, and handle signed amounts, and it stops on the first row it cannot parse. For statements, the .qbo route is faster and far less error-prone, which is why most accountants prefer it.
After the transactions are in QuickBooks, accept or match them in the For review tab, then run a reconciliation: open Reconcile, enter the statement's ending balance and date, and check off each transaction until the difference reads zero. Importing a clean, complete statement makes this fast, because every line on the paper statement already exists in QuickBooks. If the difference will not clear, a missing or duplicated transaction is usually the cause.
Yes. The converter reads PDF statements from any US bank, including national banks like Chase, Bank of America, and Wells Fargo, plus regional banks, credit unions, and business accounts like Mercury, Brex, and Relay. Layouts differ wildly between banks, which is why template-based tools that only support specific banks break down. An AI extractor reads each page fresh, so the bank does not matter. We keep per-bank guides for the most common ones.
Convert each monthly PDF to its own .qbo file and import them oldest first, so each month reconciles against its statement in sequence. This keeps the beginning balance correct from one month to the next and produces clean, reconciled books to hand a CPA. If you are catching up an entire year, see our guide to importing bank statements into QuickBooks for taxes, or just upload your first statement above.
Accuracy is the part that matters most, because a tool that quietly misreads or drops a line costs more than it saves. The converter reads each transaction straight from the statement and preserves the debit, credit, and date structure, then checks the page totals against the statement's printed balances before export. After import, compare the .qbo ending balance to the statement's ending balance: if they match, every transaction came through. If you need the same data as a spreadsheet, our sister tool for bank statement to Excel conversion exports it to .xlsx and .csv.
Upload a PDF, see every transaction extracted in seconds. No card to try it.
Still comparing tools? See our bank statement to QuickBooks converter comparison.
You can convert a statement to confirm the result before relying on it, so you can check the data is right for your bank first. The value is the time saved on every statement: an accurate .qbo that imports cleanly and reconciles to the penny replaces an hour of manual entry, which is what bookkeepers and businesses actually pay for. Volume pricing is on the pricing page. For a deeper step-by-step, read our blog on importing bank statements into QuickBooks. Bringing in a whole year or many accounts? See how to bulk convert bank statements to QuickBooks. Or upload a statement above to start. Banking at a credit union? Most are not on the QuickBooks connectable list, so see how to convert a credit union statement to QuickBooks. Before you categorize what lands in For review, make sure the account list is right: see the chart of accounts in QuickBooks Online.
Same converter, tuned for the layout each bank uses. Find yours:
For one bookkeeper running monthly close.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
For an accounting firm or finance team with steady volume. Adds QuickBooks .qbo export and bulk conversion.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
For lenders, audit firms and analysts running thousands of statements a month.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
