Skip to main content
FinanceConvert.
FORMAT REFERENCE

QBO files: bank transactions vs company backups

The letters QBO can refer to QuickBooks Online, but a .qbo file is a bank transaction file. It is not a complete export of an online company or a QuickBooks company backup.

Reviewed · Scope and editorial method

A file extension is not a company database

A bank QBO file carries transaction records and institution/account metadata. It does not give this converter the customers, invoices, attachments, reconciliation state or chart-of-accounts settings of a company.

If you need to move an entire company between products, a bank-file conversion is too narrow. Keep company backups and use the destination's migration workflow. The converter's CSV/Excel output is a transaction extract, not a replacement for that migration.

Inspect the bank transaction fields

FinanceConvert reads the underlying bank fields directly, including dates, signed amounts, descriptions and identifiers when supplied. This avoids OCR because the source already contains explicit transaction values.

Check the account identity, currency and period before mapping the output. Available FITIDs and account IDs survive in tabular exports; spreadsheet identifiers should stay text rather than being converted to numbers.

Creating a QBO from another format needs more context

A CSV, QIF or PDF often lacks the institution BID and account metadata expected by a Web Connect workflow. The export writer cannot obtain those facts merely by changing syntax. Supply genuine identifiers and verify the target product's supported import path.

Mixed accounts and currencies are refused for single-account bank outputs. Repeated transaction identifiers are also refused instead of silently deleting rows. Neither restriction proves that a supported bank import will succeed; it prevents specific forms of data confusion.

Choose CSV, Excel, a report or IIF for a reason

CSV exposes columns for another tool to map. Excel makes date and numeric types explicit for review. A PDF creates a reading report. IIF creates paired accounting import entries with configurable account names.

The IIF path requires particular care: bank data does not identify the correct expense or income account for every row. Default contra accounts are placeholders. Test the mapping with a copied company and review the classification before use.

A synthetic source example

<OFX><BANKMSGSRSV1><STMTTRNRS><STMTRS><CURDEF>USD</CURDEF><BANKACCTFROM><BANKID>123456789</BANKID><ACCTID>DEMO-ACCOUNT</ACCTID><ACCTTYPE>CHECKING</ACCTTYPE></BANKACCTFROM><BANKTRANLIST><STMTTRN><DTPOSTED>20260115</DTPOSTED><TRNAMT>-45.00</TRNAMT><FITID>demo-1</FITID><NAME>Office supplies</NAME><BALAMT>955.00</BALAMT></STMTTRN><STMTTRN><DTPOSTED>20260116</DTPOSTED><TRNAMT>1200.00</TRNAMT><FITID>demo-2</FITID><NAME>Client payment</NAME><BALAMT>2155.00</BALAMT></STMTTRN></BANKTRANLIST></STMTRS></STMTTRNRS></BANKMSGSRSV1></OFX>

This is an example for the reader, not a customer document or a certified bank export. Use “Try a sample file” on a converter to test the complete local workflow.

Checks for this format

Available conversions from QBO

  • QBO to CSV converter — Read QBO bank transaction fields into CSV with debit, credit and identifier columns. Review the preview before downloading.
  • QBO to Excel converter — Read QBO bank transaction fields into Excel with typed dates and amounts. Review the preview before downloading.
  • QBO to PDF converter — Read QBO bank transaction fields into PDF as a readable transaction report. Review the preview before downloading.
  • QBO to IIF converter — Read QBO bank transaction fields into IIF transaction records. Review the preview before downloading.

Format and product references

Publisher documentation describes the format or destination product. It does not certify this converter or any generated file.

All format guides · Check extraction quality · Document storage and deletion