How to Convert Bank Statements to QuickBooks (QBO & OFX)

QuickBooks can import bank transactions — but only in specific formats. If all you have is a PDF statement, you are stuck retyping, unless you convert it first. Here is how to get a bank statement PDF into QuickBooks cleanly, using a native .QBO or .OFX file.

CSV vs. QBO/OFX: which should you use?

QuickBooks accepts a few formats:

• CSV — flexible, but you have to map columns each time, and QuickBooks Online is picky about formatting.
• .QBO (Web Connect) — the native QuickBooks format. It imports directly with dates, amounts, and descriptions already mapped.
• .OFX — an open format that QuickBooks, Xero, and most accounting software read.

For QuickBooks, a native .QBO file is usually the smoothest option: fewer mapping steps and fewer import errors.

Step by step

1. Open Convert Bank Statements and upload your statement PDF.
2. Once it is converted and the balance is verified, download the QuickBooks .QBO file (or OFX).
3. In QuickBooks Online: go to Transactions → Bank transactions → Upload from file, select your .QBO file, and choose the account.
4. In QuickBooks Desktop: go to File → Utilities → Import → Web Connect Files.
5. Review and accept the imported transactions.

A note on account numbers

A .QBO file references a bank account. For your privacy, the converter never embeds your real account number in the exported file — it uses a neutral placeholder. QuickBooks asks which account to import into, so you stay in control.

Getting the numbers right

Before you import, the converter reconciles every statement: opening balance plus transactions should equal the closing balance. If it does not, the file is flagged so you can review it rather than importing broken data into your books.

FAQ

Does this work with QuickBooks Online and Desktop? Yes — .QBO imports into both, and OFX works too.

What if my bank is not on a supported list? The converter reads the statement itself, so it is not limited to specific banks.

Is my data safe? The original PDF is never stored and your data is never used to train AI. See our Privacy Policy.

Convert a statement to QuickBooks now →