Skip to content
BankConv
Get started

OFX, QFX and QBO viewer

Open an OFX, QFX or QBO file to see the account, the date range and every transaction, with a list of problems that would stop QuickBooks, Quicken or Xero from importing it. Export the transactions to CSV in one click.

Runs in your browser. Your file is never uploaded.

Reading the checks

  • Errors stop most software from importing the file, or make it skip transactions: no header, no account number, missing dates or amounts, missing or repeated FITIDs, or a .qbo/.qfx file without an Intuit ID.
  • Warnings usually import, but check them: transactions outside the statement’s date range, DEBIT entries with a positive amount, or payee names over 32 characters, which some software cuts.

Need to make a file rather than read one? The CSV to OFX and CSV to QBO converters build one from a spreadsheet.

Questions

How do I open an OFX file without accounting software?

Open it here. The viewer reads OFX, QFX and QBO files in your browser and shows the account, the date range and every transaction. You can then export the transactions to CSV for Excel or Google Sheets.

Are OFX, QFX and QBO files different?

They share the same structure. QFX and QBO add Intuit fields, such as the bank’s Intuit ID (INTU.BID), that Quicken and QuickBooks read. The viewer reads all three and shows the Intuit ID when there is one.

What does the viewer check?

The header, the statement and account blocks, the date range, each transaction’s date, amount and FITID, repeated FITIDs, transaction types that don’t match the amount’s sign, payee names longer than the OFX 1.x limit of 32 characters, and the Intuit ID in .qfx and .qbo files.

Why are some of my transactions missing after import?

The most common cause is a repeated or missing FITID: accounting software treats transactions with the same FITID as duplicates and skips them. The viewer counts repeated FITIDs for you.

Is my file uploaded?

No. The file is read by JavaScript in this page and never sent anywhere.

More free tools