How to import a PDF bank statement into QuickBooks Online and Desktop

Intuit's help on manually uploading transactions, checked on 16 October 2026, describes two kinds of upload from the same place.

A PDF or image statement:

1. Go to Accounting → Bank transactions and select the account's tile if it has one.
2. Open the Link account menu and choose Upload from file.
3. Upload the PDF, or an image such as JPG, PNG or HEIC.
4. Choose the QuickBooks account it belongs to, or add a new one, and select Continue.
5. Compare the extracted lines with the statement side by side, correct anything wrong, and save.

Intuit says the statement must be in English and can come from any bank. The extraction is automated, so the side-by-side review is your job, and Intuit notes that some statements may be reviewed by its team before they are ready.

A transaction file (CSV, TXT, QBO or OFX) goes through the same Upload from file screen. You pick the account, map the columns if it is a CSV, choose which transactions to import, and confirm. Intuit's limits for these files are 350 KB and 1,000 transactions per upload, with one transaction per line.

Start the upload at least a day before your oldest QuickBooks transaction for that account, or the day after the most recent one if the account already has history, so nothing is duplicated.

Try the built-in route first when you have a single, digitally issued statement in English and you are happy to check its lines on screen. It costs nothing extra and puts the transactions straight into the register.

Convert first instead when:

• You want to inspect the rows outside QuickBooks before anything touches your books, or keep a spreadsheet copy for a client or an auditor.
• You have many statements and want one reviewed file per account rather than a long series of on-screen checks.
• The statement is a scan or photo and you want a balance check that flags the row where a misread digit breaks the running balance.
• The statement is not in English, which Intuit's PDF route does not accept.
• You use QuickBooks Desktop, which has no PDF route at all.

Yes. QuickBooks Online accepts a CSV with either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), one consistent date format, and the 350 KB and 1,000-transaction limits. Intuit's CSV formatting guide recommends day/month/year dates. Its four-column example puts payments in Credit and deposits in Debit, which is the reverse of what many people expect, so check one payment and one deposit in the preview.

The bank statement converter writes both QuickBooks Online layouts from the CSV layout selector. Each file uses DD/MM/YYYY and holds at most 999 transactions plus a header, and files are split before they reach 350,000 bytes. Several statements, or one long statement split into parts, download together as a ZIP; upload each file into the right account. The full transaction CSV stays available as your review copy, and one CSV purchase covers every layout of the same result. Bank statement to CSV explains the layouts.

A QBO file is what a bank gives you when you choose "download for QuickBooks": OFX transaction data plus an Intuit bank code. To make one from a PDF, upload the statement to a converter, check the result and download the .qbo file. The PDF to QBO converter does this after its balance checks, and the first two pages a day are free to read.

A PDF carries no bank code, so Sonomir's QBO uses 3000, the code in Wells Fargo's own Web Connect files. QuickBooks may therefore show Wells Fargo during the import. That is a label only: you choose your own account, and nothing connects to Wells Fargo. Real imports of Sonomir's QBO files into QuickBooks have not yet been tested and recorded, so try a fictional sample or a short statement in a test company before relying on it for a year of history.

1. Back up your company file.
2. Choose File → Utilities → Import → Web Connect Files, select the .qbo file and choose Open. Importing through this menu is more reliable than double-clicking the file.
3. Choose Use an existing QuickBooks account and pick the bank or card account, or create a new one, then Continue.
4. Review and add the transactions in the Bank Feeds Center.

If QuickBooks says it is unable to verify the Financial Institution information, the bank code in the file was not accepted for that account. Our guide to fixing "QuickBooks is unable to verify the Financial Institution information" goes through the causes and fixes in order. Bear in mind that Intuit has been retiring older Desktop versions, and a version past its service date can lose bank feeds; check that yours is still supported.

Before importing, compare the row count, the first and last transactions, one payment and one deposit with the statement. If the converter says the statement reconciles, the amounts agree with the printed balances, but a wrong date or description can still pass that check.

After importing, match and categorise the transactions in QuickBooks and reconcile the account against the statement's closing balance. Remove any overlap with transactions already brought in by a live bank feed; those carry different IDs, so QuickBooks will not always recognise them as duplicates. For the differences between QBO, QFX, OFX and QIF, see which bank import file you need.