QuickBooks does not import PDF bank statements directly. If your bank feed does not cover the months you need — or it disconnected and left gaps — the statement PDF from your bank is the source of truth, and you need to turn it into a file QuickBooks accepts: QBO (Web Connect) or CSV. This guide walks through the full process for QuickBooks Online and QuickBooks Desktop. You can convert the PDF with the QuickBooks converter on Convert Statement.
Step 1: Download the official statement PDF from your bank
Use the official monthly statement PDF, not screenshots or transaction exports stitched together. The statement has a fixed opening and closing balance, which is what makes reconciliation possible later. If the PDF is password-protected, remove the password first or unlock it with the password your bank gave you (usually your date of birth or account-linked ID, depending on the bank).
Step 2: Convert the PDF to QBO or CSV
Upload the PDF to a converter built for bank statements and export the format your QuickBooks version needs:
- QuickBooks Online: QBO, QFX, OFX, or CSV all work through manual upload. QBO is the safest choice because dates and amounts are already structured the way QuickBooks expects.
- QuickBooks Desktop: use the QBO file through Web Connect (File → Utilities → Import → Web Connect Files).
- CSV: works in QuickBooks Online if you map the columns during upload. Use a single Amount column (negative for money out) or separate Money In / Money Out columns — do not mix the two styles.
Before importing, spot-check the converted file: the first and last transaction dates should match the statement period, and the total of the transactions should move the opening balance to the closing balance on the statement.
Step 3: Import into QuickBooks Online
Go to Transactions → Bank transactions, open the drop-down next to Link account and choose Upload a file. Select your QBO or CSV file, pick the bank or credit card account it belongs to, map the columns if QuickBooks asks, and confirm. The transactions land in the Pending / For review tab — importing a file does not post anything to your books until you categorize and add each transaction.
Step 4: Avoid the two mistakes that break reconciliation
- Duplicates: never import a period that the live bank feed already downloaded. Overlap even one day and you will double-count income or expenses. Check the date range of the file against what is already in QuickBooks before you upload.
- Wrong opening balance: if this is the first import for an account, QuickBooks uses the file's starting point as the opening position. Import statements in chronological order, oldest first, so balances build correctly.
Step 5: Categorize and reconcile
Work through the For review tab, categorizing each transaction and matching anything QuickBooks suggests. Then reconcile the account against the statement's closing balance for that month. If the reconciliation difference is not zero, the cause is almost always a duplicate, a missing transaction, or an edited prior-period entry — the reconciliation discrepancy report and the audit log will show which one.
When the books are months behind
Converting statements fixes the data-entry problem, not a backlog problem. If several months are unreconciled, accounts were set up inconsistently, or the chart of accounts has years of duplicates, importing files alone will not make the reports trustworthy. That is a cleanup job: diagnose, import in order, categorize, and re-reconcile month by month. Convert Statement offers a free cleanup assessment — tell us how many months you are behind and how many accounts you have through the contact page and we will reply with a fixed quote before any work starts.