Convert a Bank Statement to QBO
Turn a digital PDF bank statement into a valid QBO (OFX) file you can import into QuickBooks Online or QuickBooks Desktop. Parsing and export happen entirely in your browser — your statement never leaves your device.
Drag & drop your bank statement
PDF only · processed in your browser · nothing is uploaded
Choose a fileDoing this monthly or across clients?
Batch multi-file conversion and direct QuickBooks/Xero sync — join the early-access list. We only collect your email, never your statement.
How to convert a bank statement to QBO
- Drag your digital PDF statement onto the converter above (or click to choose it).
- StatementTidy extracts transactions in your browser and reconciles them against the opening and closing balance.
- Review the preview — flagged rows stay visible and are never dropped.
- Click “Download QBO” to save a QuickBooks-ready .qbo file.
How to import a QBO file into QuickBooks Online
- Open QuickBooks Online and go to Transactions (or Banking).
- Select Upload from file or Import transactions (wording varies by plan).
- Choose the .qbo file you downloaded from StatementTidy.
- Map the import to the correct bank or credit card account when prompted.
- Review the imported rows in the For review list, then accept or categorize them.
How to import a QBO file into QuickBooks Desktop
- Open QuickBooks Desktop and go to File → Utilities → Import → Web Connect Files.
- Select the .qbo file you downloaded from StatementTidy.
- Choose the bank account to receive the transactions.
- Open the Bank Feeds / Online Banking center and review downloaded transactions.
- Match or add each transaction, then accept them into the register.
Before you import
QuickBooks uses placeholder account identifiers in the QBO file — you will map the file to your real account during import. If any rows were flagged during conversion, reconcile them in StatementTidy before importing so nothing surprises you in QuickBooks.
What is a QBO file?
A QBO file is QuickBooks Web Connect format, a QuickBooks-specific version of the OFX standard. It holds your transactions (date, amount, description) so QuickBooks Online or Desktop can import them straight into a bank or credit card account. StatementTidy builds the QBO for you from a digital PDF statement.
QuickBooks Online can read PDFs now — when a QBO file is still the better route
QuickBooks Online added an option to upload a PDF or image statement and have its AI extract the transactions. It's a reasonable choice for occasional use. A QBO file is still the better route when you use QuickBooks Desktop (which has no PDF upload), when you want to check the transactions against the statement totals before anything touches your books, or when you'd rather not send the statement to a third party — Intuit's help page notes that statements flagged for review may be checked by its team.
What's inside the QBO file
| Part of the file | What it holds |
|---|---|
| Account block | A placeholder bank and account ID — you choose the real QuickBooks account during import. |
| Statement dates | The start and end date of the statement period. |
| Transactions | One entry per transaction: date, signed amount, description, and a unique transaction ID. |
| Ending balance | The statement's closing balance, when the statement prints one. |
What is a QBO file? Full explanation
QBO vs QIF vs OFX vs QFX: file formats explained
Frequently asked questions
How do I convert a PDF bank statement to QBO?
Drop the digital PDF statement on the converter at the top of this page, check the reconciled preview, and click Download QBO. Everything happens in your browser, and the file is ready to import into QuickBooks.
Should I import QBO or CSV into QuickBooks Online?
Either works. A QBO file needs no column mapping, so it's the quickest. The QuickBooks CSV (Date, Description, Amount) is handy if you want to edit rows in a spreadsheet before importing.
Can't QuickBooks Online import the PDF directly?
QuickBooks Online now offers a PDF/image statement upload that uses AI to extract transactions. Converting to QBO yourself is still useful for QuickBooks Desktop, for checking the data against the statement balances first, and for keeping the statement off third-party servers.
Will importing the QBO file create duplicate transactions?
Each transaction in the file carries a unique ID, and QuickBooks shows imported rows in its review list where you can match them to existing entries instead of adding them again.
Does it work for credit card statements?
Yes — convert a digital credit card statement the same way. Charges come out as money out and payments as money in, so the import lands in the right direction.
Is the QBO converter free?
Yes. There's no signup, and the statement is never uploaded.