How to Convert an Excel (XLSX) Bank Statement to .QBO for QuickBooks
QuickBooks won't import a raw .xlsx bank statement, but it happily accepts a .QBO Web Connect file. The fix is to convert your Excel spreadsheet into QBO first. Here's exactly how to do it in your browser in under a minute, free, with nothing uploaded to a server.
Why QuickBooks rejects your Excel file
QuickBooks Desktop has no built-in way to read an .xlsx spreadsheet into its bank feed. Its native import path is the Web Connect format, which uses the .QBO extension. QBO is really an OFX-based file behind the scenes: structured XML-style data with bank IDs, account numbers, dates, amounts and unique transaction IDs that QuickBooks uses for matching and de-duplication.
An Excel file has none of that structure. It's just rows and columns, and the layout is different for every bank. So before QuickBooks will touch it, you need to translate the spreadsheet into a properly formed QBO file. That translation is what this tool does.
Prepare your Excel spreadsheet first
A few minutes of cleanup makes the conversion painless. Open your statement in Excel and check that you have at least three usable columns:
- Date, one column, in a consistent format (e.g.
06/14/2026or2026-06-14). Mixed formats in the same column cause headaches. - Description / Payee, the merchant or memo text.
- Amount, either a single signed column (negatives for money out) or separate Debit and Credit columns. Both layouts are supported.
Two cleanup tips that prevent most errors: strip currency symbols and thousands separators so an amount reads 1250.00 rather than $1,250.00, and delete any blank rows, subtotals, or running-balance summary lines that aren't real transactions. You don't need to delete header rows, the converter lets you pick which row your headers are on.
Convert Excel to QBO in your browser
Head to the converter and follow these steps:
- Drag your
.xlsx(or.xls) file onto the drop zone. The tool reads it locally, the file never leaves your computer. - If your workbook has multiple sheets, choose the sheet that holds the transactions.
- Map the columns: tell the tool which column is Date, which is Description, and which is Amount (or Debit/Credit). It will try to auto-detect these.
- Set the output format to QBO and enter your account type (bank or credit card). For QBO, supplying a routing/bank ID helps QuickBooks recognize the account, though it's optional.
- Click convert and download your
.QBOfile.
That's it. The same engine also produces .QFX for Quicken and .OFX for other accounting apps if you need a different target.
Import the QBO file into QuickBooks
QuickBooks Desktop: go to File → Utilities → Import → Web Connect Files, select your downloaded .QBO file, and choose the account it belongs to (or create a new one). The transactions land in your bank feed ready to review, match, and categorize.
QuickBooks Online: QBO Web Connect import isn't available in every QBO plan, many users on QuickBooks Online import the cleaned spreadsheet as a CSV instead. If that's your situation, see our guide on importing CSV into QuickBooks Online, which walks through the Banking → Upload route.
Common conversion problems and fixes
- "The file you selected can't be read." Usually a malformed date column. Make every date the same format and re-convert.
- Amounts import with the wrong sign. If money-out shows as positive, your Amount column may not be signed correctly, or you mapped a Debit column as a generic Amount. Use the separate Debit/Credit mapping instead.
- Duplicate transactions. QuickBooks de-duplicates using transaction IDs. The converter generates stable IDs, but if you import the same statement twice you can still get duplicates, import each date range once.
- Excel dropped leading zeros or reformatted numbers. Format the relevant columns as Text in Excel before saving, or re-type the affected cells.
Want to sanity-check the output before importing? Run it through our OFX/QBO validator to confirm the structure is well-formed.
Is it safe and how much does it cost?
The conversion runs entirely in your browser using JavaScript. Your bank statement is parsed on your own device and never transmitted to any server, which matters when you're handling account numbers and financial detail. The free tier converts one file of a full statement with unlimited transactions, which covers a short statement or a quick test. If you process statements regularly, Pro at $29/mo gives you unlimited conversions, saved per-bank column templates so you skip the mapping step each month, and batch conversion for multiple files at once.
Ready to go? Convert your Excel statement to QBO now.
Frequently asked questions
Can I convert .xls as well as .xlsx?
Yes. Both modern .xlsx and legacy .xls Excel workbooks are supported, along with .csv. If your workbook has several tabs, you choose which sheet to convert.
Does this work for QuickBooks Online or only Desktop?
The .QBO Web Connect format is designed for QuickBooks Desktop. QuickBooks Online users often import a cleaned CSV instead, see our QuickBooks Online CSV guide. The converter can output either format from the same Excel file.
My statement is a PDF, not Excel. Can I use this?
No. This tool converts spreadsheet data (Excel and CSV) into OFX/QBO/QFX. It also reads text-based (digital) PDFs directly in your browser (beta); only scanned or photographed PDFs need a CSV step first.
Is my financial data uploaded anywhere?
No. Conversion happens client-side in your browser. The Excel file is read and converted on your own machine, so nothing is sent to or stored on a server.
Do I need my bank's routing number for a QBO file?
It's optional but recommended. Providing a bank/routing ID and account number helps QuickBooks correctly associate the imported transactions with the right account during Web Connect import.