Ledger Format

QBO to CSV and Excel converter

Open transactions from a QBO bank or credit card statement in a spreadsheet.

Use one .qbo statement with posted transactions. For company reports or lists, use QuickBooks Online's export options.

How to convert your file

Choose a QBO statement, check the transaction count and totals, then download CSV or XLSX.

What the spreadsheet contains

Download sample QBO ยท Download matching CSV

Each row is one posted transaction. The export includes the date, description, signed amount, currency, memo, transaction ID and check number when present. Amounts keep the signs used by the source file; currencies are not converted.

Fictional transactions from Try a sample
DateDescriptionAmountCurrency
2026-10-01Example deposit1500.00USD
2026-10-04Example supplies-29.95USD

QBO to CSV and Excel FAQ

Should I download CSV or XLSX?

Use CSV for a plain text export or an app that expects comma separated values. Use XLSX to open the export as a workbook in Excel. Both exports contain the same transaction fields.

Can I export my entire QuickBooks Online company?

This page reads a bank or credit card statement ending in .qbo. For company lists, invoices or reports, use the export options in QuickBooks Online.

Why does the converter reject my QBO file?

Use one complete bank or credit card statement with posted transactions, up to 2 MB and 15,000 transactions. Files with multiple transaction lists, investment records or transaction corrections are outside this converter's scope. If the download was interrupted, export the statement again from the source.

Want to create a QBO file from a bank spreadsheet instead? Use CSV to QBO.