What is a QBO file?

A .QBO file (QuickBooks Web Connect file) is a small text file in the OFX 1.0.2 format that QuickBooks Desktop and QuickBooks Online can import directly. It contains your bank transactions — dates, amounts, payees and a unique id per transaction — wrapped in tags QuickBooks understands, plus an INTU.BID code that tells QuickBooks which bank the file came from.

QBO vs CSV — why your CSV won't import

A CSV is just a spreadsheet of rows. QuickBooks' bank-feed importer expects the structured OFX/QBO format with a specific header block and identifiers. That's why dropping a raw CSV into the Web Connect importer fails — it needs to be converted first. (QuickBooks Online does have a CSV importer, but it's finicky about column order, can create duplicates, and isn't available for every workflow — a clean QBO is more reliable.)

What's inside a QBO file

Header block — OFXHEADER:100, DATA:OFXSGML, VERSION:102… (no XML prolog).
SIGNON — the financial institution org/FID and the INTU.BID.
Account info — routing number (BANKID), account number, account type.
Transactions — each with type, date, amount, a unique FITID, name and memo.

The FITID matters: it's a stable unique id so QuickBooks won't import the same transaction twice if you re-import a file. LedgerBridge generates these for you automatically.

How to create a QBO from your bank CSV

Export your transactions from your bank as CSV or Excel.
Drop the file into the LedgerBridge converter.
Confirm the column mapping and pick QBO.
Download and import into QuickBooks (File → Utilities → Import → Web Connect).

It's free for small files and runs entirely in your browser — your statement is never uploaded.

Convert a CSV to QBO now →