How to Convert a PDF Bank Statement to a QBO File for QuickBooks

To convert a PDF bank statement to a QBO file, upload the text-based PDF to a converter that exports Web Connect (.qbo) files, check the extracted transactions, and download the .qbo. Then import it in QuickBooks Online through Bank transactions → Link account → Upload from file, or in QuickBooks Desktop through Banking → Bank Feeds → Import Web Connect Files. The whole job takes a few minutes per statement, and the .qbo route skips the column mapping that CSV imports need.

What is a QBO (Web Connect) file?

A QBO file is a bank transaction file in Intuit's Web Connect format, which QuickBooks reads without any column mapping. Web Connect is Intuit's name for the file download that many banks offer in online banking. Inside, a .qbo is plain text that follows the Open Financial Exchange (OFX) specification, now maintained by the Financial Data Exchange's OFX Work Group.

Each transaction in the file is a tagged block with a posted date, a signed amount, a payee name and a unique transaction ID called a FITID. In the OFX specification, the FITID is the identifier that lets accounting software recognise a transaction it has already seen. Here is a shortened example of one transaction block:

<!-- one transaction inside a .qbo file -->
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20261003000000
<TRNAMT>-67.43
<FITID>3f9a2c7e1b4d8a6e0c5f2b19
<NAME>OFFICE SUPPLIES STORE
</STMTTRN>

Because dates, amounts and signs are already labelled, QuickBooks doesn't ask you which column is which. That is the main advantage over CSV, which you can read about in our guide to importing a bank statement CSV into QuickBooks.

Why QuickBooks won't take most PDF statements

QuickBooks Desktop has no PDF import at all. Intuit's Bank Feeds setup article for Desktop names a downloaded Web Connect (.QBO) file as the file to import. For years, answers in the QuickBooks Community have given the same advice to people holding PDF-only statements, such as this thread on converting bank statement PDFs to QBO for old statements: get a supported file from the bank, or convert the PDF.

QuickBooks Online has changed. Intuit's US help article "Manually upload transactions into QuickBooks Online" (last updated August 2026) now describes two uploads: a transaction file (.csv, .txt, .qbo or .ofx) and an account statement as a PDF or image. For the statement upload, the article says Intuit's AI extracts the information and that its "team of global experts may review your statement" before you check the result side by side.

So why convert at all? Three reasons come up often:

• You use QuickBooks Desktop, which has no PDF option.
• You want to see the data before it reaches your books. A .qbo file is a file you can open, check and keep.
• You'd rather not have a third party review the statement. With a converter, you decide which service sees it. (We explain how we handle files in is it safe to upload a bank statement online?)

How to convert a PDF bank statement to QBO

1. Download the statement PDF from your bank. Use the "Statements" or "Documents" area of online banking. Downloaded statements have a text layer; scans and photos don't. A quick test: if you can highlight and copy a transaction description in your PDF reader, the file has text.
2. Upload it at BankStatementToCSVFile.com. No signup is needed for the free tier, which covers 30 pages a month. The rule-based parser finds dates and amounts by pattern matching and works with most US banks' text-based PDF statements.
3. Check the preview. Compare the transaction count and a few amounts against the PDF, and confirm that withdrawals and deposits have the right direction. Fixing a problem here is much quicker than undoing an import later.
4. Download the .qbo file. On the results page, set the account type (checking, savings or credit card) and, optionally, the account's last 4 digits, then choose QBO. Use the same last 4 digits every time so QuickBooks keeps adding to the same account. The file is named after your PDF, ending in _converted.qbo. Save it somewhere you'll find it, because you'll need it in the next section.

For more than 30 pages a month, paid plans start at $4.99/month (Starter, 500 pages), with Professional at $9.99 and Business at $19.99. Every plan includes QBO, OFX, CSV and Excel exports.

Import the .qbo file into QuickBooks Online

The steps below follow Intuit's manual upload article. Menu labels can differ by region and by the version of the interface you see.

1. Go to All apps → Accounting → Bank transactions. If a tile for the target account is shown, select it first.
2. Open the Link account ▼ dropdown and select Upload from file.
3. Select "Drag and drop or select files" and choose your .qbo file.
4. Pick the QuickBooks account in the QuickBooks account ▼ dropdown, then select Continue. For a credit card statement, pick the credit card account, not a bank account.
5. Select the transactions to import, then select Yes and Done.
6. Review, categorize and match the new transactions on the Bank transactions page, then reconcile the account against the statement's closing balance.

Check the file against Intuit's limits before you upload. The article says transaction files must be 350 KB or less and can hold up to 1,000 lines per upload. If a long date range breaks either limit, convert the statements in smaller groups, such as one quarter at a time.

Import the .qbo file into QuickBooks Desktop

QuickBooks Desktop calls this a Web Connect import. Intuit's Bank Feeds article gives this path:

1. Back up your company file before any import. Intuit recommends this in its troubleshooting steps too.
2. Go to Banking → Bank Feeds → Import Web Connect Files. Intuit's older help article gives File → Utilities → Import → Web Connect Files.
3. Select the .qbo file and select Open.
4. Choose "Use an existing account" if the account is already in QuickBooks, or "Create a new QuickBooks account" if it isn't. Then select Continue.
5. Select OK when the dialog confirms the data was read, then open the Bank Feeds Center to review and add the transactions.

Common problems and how to fix them

When to use CSV or OFX instead

QBO is the quickest route into QuickBooks, but it isn't always the right file. This table compares the three formats our converter exports for accounting software:

Choose CSV when you want to clean up descriptions, split a file or add categories in a spreadsheet first. Our guide to converting a PDF bank statement to Excel covers that workflow. Choose OFX for Quicken and other personal-finance apps that read the OFX standard. If you're moving the same statements into Xero, follow our walkthrough on importing a bank statement into Xero.

Limitations to know before you start

• Scanned PDFs aren't supported. The converter reads the PDF's text layer and has no OCR, so image-only statements return nothing useful. See how to extract transactions from a scanned bank statement for your options.
• Always check the preview. Pattern matching works for most US banks' text-based statements, but unusual layouts can still produce a wrong row. The preview is there so you catch it before QuickBooks does.
• Transaction IDs are generated, not issued by your bank. Our FITIDs are built from each transaction's date, amount and payee, so the same transaction gets the same ID when two statements overlap and QuickBooks can skip it. Two genuinely identical charges on the same day still get separate IDs. Don't rely on this alone, though; check the dates before importing.
• Data handling. Your PDF isn't stored. Extracted data is held in memory for up to 2 hours so you can download it, then discarded.

Sources

• Intuit, Manually upload transactions into QuickBooks Online (updated August 2026, retrieved October 28, 2026)
• Intuit, Set up or edit bank accounts for Bank Feeds in QuickBooks Desktop (retrieved October 28, 2026)
• Intuit, Fix duplicate transactions in QuickBooks Online bank feeds (retrieved October 28, 2026)
• QuickBooks Community, Fix Web Connect import errors (retrieved October 28, 2026)
• QuickBooks Community, How do I convert bank statement PDF files to QBO file to import old bank statements
• Financial Data Exchange, OFX Work Group and OFX specifications

Related Guides