Format guide
QBO vs QIF vs OFX: which format should you use?
QBO, QIF and OFX are transaction file formats, not spreadsheet files. The right option depends on the accounting software you import into, not on the bank statement itself.
StatementBee works locally. Your PDF is processed on your device, not uploaded to our servers or sent to an AI model.
QBO: best for QuickBooks Online
QBO is QuickBooks' bank-feed format. Use it when importing transactions into QuickBooks Online. It carries dates, payees, amounts and a bank account identifier in a structure QuickBooks understands.
Choose QBO if QuickBooks Online is the destination. Confirm the account and date range before importing to avoid duplicates.
QIF: useful for older desktop workflows
QIF is an older interchange format supported by some desktop accounting and personal-finance applications. Support varies by product and version, so check your import screen before choosing it.
QIF can be useful when a legacy workflow explicitly asks for it, but QBO is generally the better QuickBooks Online choice.
OFX: a common financial-data standard
OFX is a broader financial exchange standard used by many financial applications. Some tools accept OFX directly, while others use a format derived from it.
If your software accepts a spreadsheet instead, use Excel or CSV when you need to inspect or edit the data before import.
Convert without sending out the statement.
Export Excel, CSV, QBO, QIF or OFX and check the balance before you download.