OFX, QFX, QBO and QIF file viewer

See what a downloaded bank or credit card file holds before you import it: the account, the date range, money in and out, the closing balance and every transaction. Nothing is imported anywhere and nothing is uploaded.

OFX / QFX / QBO / QIFCSV / XLSX

Choose your files

Choose OFX, QFX, QBO or QIF files

or drop one or more bank or card statement files here

Up to 20 files at a time. Your files stay on this device.

Keep a copy in History on this deviceView history

This converter is taking a while to load. Check your connection, then reload the page.

Your files stay on this device: the conversion runs in your browser and nothing is uploaded. Learn how your files are handled

How to open a bank statement file

Choose the file your bank or app downloaded: .ofx, .qfx, .qbo or .qif. You can add several.
Check the summary: which account it is (the last four digits of the number), the first and last dates, money in, money out and, for OFX-type files, the closing balance the bank sent.
Read or search the transactions, newest first. Search finds payees and memos, or an amount such as 42.50.
Save a copy as an Excel or CSV file if you want the transactions as a table.

What these files are

OFX (Open Financial Exchange) is the standard format banks use for statement downloads. Version 1 is SGML-like text; version 2 is XML.
QFX and QBO are OFX files made for Quicken and QuickBooks (Web Connect). They carry an extra Intuit bank ID (INTU.BID) that those programs check.
QIF (Quicken Interchange Format) is an older plain-text format, still offered by some banks and used to move data out of Quicken and Microsoft Money.

Opened in a text editor or Excel, all of them show tags and codes, not a statement. The viewer reads them the way a finance app would.

What to check before importing

The dates. If the range overlaps transactions you already imported, some apps add them twice. OFX, QFX and QBO files carry a transaction ID (FITID) that lets apps skip repeats; QIF files have none.
The account. Make sure the last digits match the account you import into.
The signs. Purchases should be negative. A card file with purchases as positive amounts will make the balance go the wrong way.
The balance. Compare the closing balance with your statement.

When the app wants a different format

QuickBooks wants QBO, Quicken wants QFX, and other apps want OFX or QIF. The bank format converter turns one into another and keeps the transaction IDs. For a statement in CSV or Excel, use the CSV to OFX converter.

Frequently asked questions

Does opening the file import anything?

No. The viewer only shows what the file contains. Nothing is imported into any app, and the file is not uploaded.

Why does Excel show code instead of transactions?

OFX, QFX, QBO and QIF files are made for finance apps, so Excel shows their tags. Save a copy here as an Excel file to get proper columns: date, payee, memo and amount.

What is the difference between QFX and QBO?

Both are OFX files with an Intuit bank ID. QFX is for Quicken and QBO for QuickBooks; the inside is almost the same, and the bank format converter turns one into the other.

Can it open investment statements?

Only bank and credit card transactions are shown. Investment holdings and trades are left out, with a note: investment sections of a QIF file and investment statements in an OFX file.

The QIF dates look wrong. Why?

QIF files don’t say whether the day or the month comes first. When every date could be read either way, month first is used. Choose “Dates in the file” to change it.