QBO to CSV Converter

How to Convert QBO to CSV

1. Find the .qbo file - the download your bank offers as "QuickBooks", "QuickBooks Web Connect" or "QBO".
2. Drop it above. The statement is read in your browser; the account number is shown masked.
3. Pick the layout. For QuickBooks Online's CSV upload, choose MM/DD/YYYY and one Amount column.
4. Download the CSV, or the Excel workbook if you want to work on it in Excel.

When a QBO File Will Not Import

The most common reason to convert a .qbo is that QuickBooks refused it. QuickBooks Desktop rejects a file whose bank ID it does not recognise ("unable to verify the Financial Institution information") and, on versions past Intuit's service cut-off, stops importing Web Connect files at all. QuickBooks Online refuses uploads over roughly 350 KB. In each case the transactions are fine - only the wrapper is the problem.

• QuickBooks Online: convert to CSV here with MM/DD/YYYY dates and one Amount column, then use Transactions > Bank transactions > Link account > Upload from file and map Date, Description and Amount. For a file over the size limit, split the CSV by date range.
• QuickBooks Desktop: convert to CSV, then turn the CSV into an IIF file with CSV to IIF and import it with File > Utilities > Import > IIF Files. IIF does not depend on online banking services, so it also works on older versions.
• A rejected bank ID: convert to CSV here, then back to a .qbo with CSV to QBO, which writes Intuit bank ID 3000 - an ID QuickBooks accepts - and keeps your transactions' dates and amounts.

Check a Download Before It Reaches Your Books

Once QuickBooks has imported a Web Connect file, undoing it means finding and excluding or deleting the imported transactions. Converting the .qbo first shows you exactly what it contains: the date range, the totals in and out, and every transaction. If the range overlaps a file you imported last month, the Transaction ID column shows which rows QuickBooks will skip as duplicates - it remembers FITIDs per account and ignores repeats.

What Is Inside a QBO File

A .qbo file is an OFX statement - usually the older SGML form, where tags such as <TRNAMT>-42.50 are opened but never closed - plus an Intuit bank ID in the sign-on block. The converter reads the account (number, type and routing number), the ledger balance, and each transaction's posting date, payee, memo, amount, type, check number and FITID. The same reader handles QFX and OFX files.