Convert a PDF bank statement to a QBO file for QuickBooks

Many banks only offer a QuickBooks download for recent months, and a PDF statement can't go into QuickBooks Desktop as it is. Converting the PDF to a .qbo file fills that gap. This guide covers what the file is, when you don't need to convert at all, what a good conversion keeps, and how to check it before anything reaches the books.

What a .qbo file is, and who uses it

• A .qbo file is a QuickBooks Web Connect file: a list of one account's transactions, built on the OFX format and tagged with bank and account identifiers. Intuit describes Web Connect as downloading a .QBO file from your bank and importing it into QuickBooks (Intuit: set up Bank Feeds in QuickBooks Desktop).
• QuickBooks Desktop: Web Connect is the file route for bank transactions. Intuit: "Web connect only works with .qbo files. Other types like QFX and QIF Quicken files won't work" (Intuit: download bank feed transactions in QuickBooks Desktop, updated Aug 5, 2026).
• QuickBooks Online: takes a list of transactions as a QBO file (Intuit's suggested format), QFX or CSV. It can now also take an account statement as a PDF or image, which its AI extracts for you to check side by side (Intuit: manually upload transactions into QuickBooks Online, updated Aug 24, 2026). For one month in Online, that built-in upload may be all you need; see importing a PDF statement into QuickBooks Online.
• A .qbo file is a transaction list, not a statement. Keep the PDF: you need its opening and closing balances to prove the file is complete.

First, check whether the bank offers a .qbo download

• Look in online banking for a download labeled QuickBooks, Web Connect or .qbo. Intuit says every bank has a different method, and to ask the bank if you can't find its steps (Intuit).
• Some banks let you pick a date range. If yours doesn't, Intuit says the first download brings the maximum available, which "may be 30, 60, 90 days, or more depending on the bank" (Intuit).
• If the bank's .qbo covers the months you need, use it. Converting a PDF makes sense for months the bank no longer offers as a download, or for banks that don't offer .qbo at all.
• Bank-specific download steps are in our guides by bank.

What a good conversion must keep

• Dates. Every transaction keeps its statement date, in the right year. Watch statements that run across December and January.
• Signs. Deposits in, withdrawals out. On a credit card, purchases are charges and payments are credits. One flipped sign makes the month miss by twice that amount.
• Payee text. The description as printed, not cut to the first line, so bank rules and matching still work.
• Balances that tie, month by month. Opening balance + deposits − withdrawals = closing balance, using the totals printed on the statement, and each month's closing balance equals the next month's opening balance.
• Unique transaction IDs. Each transaction in an OFX-based file carries an ID (often called the FITID). Two different transactions should never share one. Be careful re-converting a month you already imported: depending on how the new file's IDs compare, the same transactions could be skipped or come in a second time. Intuit says you can't download transactions into the same Desktop company file more than once (Intuit), but we have not seen Intuit document exactly how Desktop or Online decides a transaction is a repeat. Don't rely on it: import each month once and check the dates on either side of any bank feed. See duplicate transactions after a bank upload.
• One account per file. Checking, savings and each card get their own files. Desktop links a .qbo file to an account through identifiers inside it, so files from mixed sources can make it offer to create a new account (Desktop Web Connect guide). Intuit's Online article also says to know whether transactions go to one account or individual accounts before you upload (Intuit).
• One month per file is easiest to check, and easy to leave out if something is wrong. It also helps in Online, where Intuit limits a transaction list to 350 KB and 1,000 lines per upload (Intuit).

Check the file before you import it

1. Tie out each month against its PDF: opening + deposits − withdrawals = closing. The full method, with a worked example, is in check a statement PDF is complete before you import it.
2. Spot-check the first and last days of the month and the largest few items against the statement.
3. Working from a CSV? The free tie-out checker runs in your browser, shows the row where a CSV stops balancing, and can turn the CSV into a .qbo file.
4. If the account already has a bank feed, end the last file the day before the feed's first transaction.

Import into QuickBooks Desktop

1. Back up the company file first. Intuit lists this among its guidelines before downloading transactions (Intuit).
2. Go to Banking → Bank Feeds → Import Web Connect Files, select the .qbo file and choose Open.
3. Choose Use an existing account if the account is already in QuickBooks, or create a new one if it isn't. Then Continue and OK.
4. Review the transactions in the Bank Feeds Center (Intuit), and add or match them to ones already entered (Intuit).

More: QuickBooks Desktop Web Connect (.qbo) and can QuickBooks Desktop import a PDF bank statement.

Import into QuickBooks Online

1. Go to Bank transactions, open Link account ▾ → Upload from file and select the .qbo file.
2. Choose the QuickBooks account to upload into (or Add New), then Continue.
3. Select the transactions to import, then Continue, Yes and Done (Intuit).
4. Match and categorize, then reconcile each month to its statement.

Choosing between a file and Online's own PDF upload: importing a PDF statement into QuickBooks Online. A stack of months: importing multiple months of bank statements. Other formats: QBO vs CSV vs OFX.

Where LedgerReady fits

If you'd rather not convert and check each month yourself, LedgerReady turns digital statement PDFs into a QBO file, a Xero CSV, a plain CSV and a tie-out sheet showing every month matches its opening and closing balance. It costs $15 per statement-month, and we aim to deliver within 12 hours. Tie-out guarantee: if the output doesn't reconcile to the statement's opening and closing balances and we can't fix it, you don't pay for that statement.

Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.