StatementoHome →

QBO, QFX, OFX or QIF: which file do you need?

Four file types carry bank and credit card transactions into accounting software. Here is what each one is, which software uses it, and how to choose.

The short answer

Which formats a tool accepts depends on the tool and its version, so check its import page before you start.

What each format is

QBO

A QuickBooks file for importing the transactions of a bank or credit card account. It is built on the OFX standard and carries an Intuit identifier so QuickBooks recognizes it.

QFX

The Quicken version of the same idea. Like QBO, it is OFX with an Intuit identifier, and it is the format Quicken uses to import transactions from a file.

OFX

Open Financial Exchange, an open standard that banks and many accounting programs use to exchange transactions. It has no software company's identifier in it, so it suits tools that read the standard directly.

QIF

An older text format with one entry per transaction. It carries less information than OFX, such as no account balance, and support for it varies by program and version.

Bank accounts and credit cards

A credit card statement is the other way round from a bank statement: a charge raises what you owe. Statemento recognizes a credit card statement from its balances and writes the file as a credit card account, with the closing balance as the amount owed, so charges and payments keep the right sign when you import.

Limits worth knowing

QuickBooks Online accepts up to 1,000 lines in one upload, according to Intuit's help page (checked November 16, 2026). Statemento splits a QBO or QFX file with more than 1,000 transactions into numbered parts in one ZIP, so you can import them one at a time.

Every transaction gets a stable ID. If you import the same statement twice, tools that check those IDs skip the transactions they already have instead of adding duplicates.

Which formats Statemento exports

CSV and Excel are included on the free plan. OFX, QIF, QBO and QFX come with the free trial or a paid plan. Every conversion is checked against the statement's own opening and closing balances before you download.

Try one statement free, no account needed. Source for the QuickBooks limits: Intuit: manually upload transactions into QuickBooks Online.