Convert an Excel bank statement (.xlsx) to QBO

Drop the .xlsx your bank or bookkeeper gave you and get a QuickBooks Web Connect (.qbo) file. The workbook is read by your browser. Nothing is uploaded.

Runs 100% in your browser
No sign-up
Free for 10 transactions per file
Pro: $29 one-time

Drop your bank CSV or Excel (.xlsx) file here or click to choose a file. It is read by your browser and never uploaded.

1. Check how the file was read

Delimiter Header row (0 = no header) Date format in file Decimal separator Flip sign (money out ↔ money in)

Columns

Use either one signed Amount column, or separate Debit and Credit columns.

2. Review transactions

	Date	Description	Amount	Check #	Balance

3. Account details (written into the file)

Account type Account number (or any unique ID) Routing number / bank ID Currency INTU.BID (QBO/QFX only) Bank name (optional) Dates in QIF/CSV output

Use a different account number for each real account, and the same number every time you convert that account. QuickBooks and Quicken use it to recognise the account. See what INTU.BID means.

4. Download

Pro ($29 one-time): coming soon

The output follows the standard Web Connect (QBO/QFX) and OFX formats and has been checked with independent OFX parsers. Try the free 10-transaction export in your software before buying Pro ($29 one-time). If a file you export with Pro won't import into the software you made it for, you get a full refund within 30 days of purchase. Refund policy

Getting the spreadsheet ready

The converter reads the first worksheet. Move the transactions sheet to the front if needed.
Title rows, account summaries and blank rows above the column headings are skipped automatically. Check that "Header row" points at the row with Date/Description/Amount.
Real Excel date cells are read exactly. Dates typed as text use the "Date format in file" setting.
Old .xls files (Excel 97–2003) aren't supported yet. Open them in Excel or LibreOffice and choose Save As → .xlsx (or CSV).
Amounts can be one signed column or separate Withdrawals/Deposits (Debit/Credit) columns.

Importing into QuickBooks

Download the QBO (QuickBooks) file.
QuickBooks Desktop: File → Utilities → Import → Web Connect Files, then choose the account.
QuickBooks Online: Banking → Link account → Upload from file (or Upload transactions), then choose the account and review the transactions in For review.

Step-by-step details and troubleshooting are on the CSV to QBO page.

About INTU.BID and "unable to verify financial institution"

QBO and QFX files carry an Intuit bank identifier (INTU.BID, mirrored in <FID>). QuickBooks Desktop and Quicken check it against Intuit's directory of banks that support Web Connect downloads. If the ID is unknown or the bank has dropped Web Connect, the import fails with an "unable to verify the financial institution" style error.

Like other converters, we default to 3000, the Wells Fargo entry in that directory, which converters commonly use as a generic value. The only visible side effect is that the import dialog may show a Wells Fargo label; the transactions still go into whichever account you pick. If you know your own bank's Web Connect ID, enter it in the INTU.BID box instead. QuickBooks/Quicken remember the combination of bank ID and account number, so keep both the same each time you convert the same account.

FAQ

Does it work with Google Sheets or Numbers files?

Export them as .xlsx or CSV first (File → Download in Google Sheets, File → Export To in Numbers), then drop that file here.

My workbook has several sheets.

Only the first sheet is read. Move the transactions sheet to the first position, or save that sheet alone as CSV.

Formulas in the amount column?

The converter reads the last calculated value saved in the workbook. If a cell shows a value in Excel, it will be picked up.

Is my bank file uploaded anywhere?

No. The page reads the file with your browser's built-in file APIs and builds the output on your device. There is no server-side code: you can open your browser's developer tools, watch the Network tab while converting, and see that no file data is sent. See the privacy page.

Is it free?

Yes for up to 10 transactions per file in every format, with full preview and editing. Pro removes the limit for $29 one-time. Try the free export in your software first. If a file you export with Pro won't import into the software you made it for, you get a full refund within 30 days of purchase. See the refund policy.

QuickBooks and Quicken are trademarks of their respective owners (Intuit Inc. and Quicken Inc.). This site is independent and is not affiliated with, endorsed by, or sponsored by Intuit or Quicken. Product names are used only to describe file compatibility.