QBO vs QIF vs OFX vs QFX: bank file formats explained
Quick answer
QBO and OFX are the formats QuickBooks reads; QIF and QFX are Quicken formats; CSV and Excel open in any spreadsheet. They all carry the same bank transactions - date, amount, and description - just in different wrappers. StatementTidy turns a PDF bank statement into CSV, Excel, QBO, or QIF entirely in your browser.
What is a QBO file?
A QBO file is QuickBooks Web Connect format - a QuickBooks-specific flavor of OFX. It carries bank transactions that QuickBooks Online and QuickBooks Desktop can import directly, with each line holding a date, an amount, and a description.
What is a OFX file?
OFX (Open Financial Exchange) is the open standard that QBO is based on. Many banks and finance tools read OFX. A QBO file is essentially OFX with QuickBooks-specific identifiers.
What is a QIF file?
QIF (Quicken Interchange Format) is a plain-text format that Quicken and many personal-finance tools use to import transactions. Each transaction is a few lines: a date, a signed amount (money in is positive, money out is negative), and a payee or description.
What is a QFX file?
QFX (Quicken Financial Exchange) is Quicken's branded version of OFX, used for transactions downloaded directly from a bank into Quicken. It is similar to OFX and QBO but tagged for Quicken.
What is a CSV and Excel file?
CSV and Excel (XLSX) are universal spreadsheet formats. They are not tied to any accounting tool, so they are the best choice when a human needs to review, edit, or re-map the data before importing it anywhere.
Which format should you use?
| Your tool | Best format |
|---|---|
| QuickBooks Online or Desktop | QBO |
| Quicken | QIF (or QFX from your bank) |
| Excel or Google Sheets | CSV or Excel (XLSX) |
| A reviewer who needs to edit first | CSV or Excel |
Convert your statement to any of these
StatementTidy reads a digital PDF bank or credit card statement in your browser and exports the transactions in the format your tool needs. Nothing is uploaded.
Doing this monthly or across clients?
Batch multi-file conversion and direct QuickBooks/Xero sync — join the early-access list. We only collect your email, never your statement.
Frequently asked questions
What is a QIF file?
A QIF (Quicken Interchange Format) file is a plain-text file that personal-finance software like Quicken uses to import transactions. Each transaction stores a date, a signed amount, and a description.
What is a QBO file?
A QBO file is QuickBooks Web Connect format - a QuickBooks-specific version of the OFX standard. QuickBooks Online and Desktop can import a QBO file directly into a bank or credit card account.
What is the difference between QIF and QBO?
QIF is a Quicken format and QBO is a QuickBooks format. They hold the same kind of data (dated transactions with amounts and descriptions) but in different structures, so QuickBooks imports QBO and Quicken imports QIF.
What is an OFX file?
OFX (Open Financial Exchange) is the open standard for exchanging financial data. QBO and QFX are both based on OFX; a QBO file is OFX with QuickBooks identifiers, and a QFX file is OFX tagged for Quicken.
What is a QFX file?
A QFX (Quicken Financial Exchange) file is Quicken's branded version of OFX, used when you download transactions from a bank directly into Quicken.
Can I import a QIF file into QuickBooks?
Not directly - QuickBooks imports QBO and CSV rather than QIF. If your destination is QuickBooks, use a QBO file instead. StatementTidy can convert a PDF bank statement straight to QBO.
How do I convert QFX to QBO?
StatementTidy converts a PDF bank statement (not a QFX file) into QBO, CSV, Excel, or QIF in your browser. If you already have a QFX file, the simplest path is to download the original PDF statement from your bank and convert that to QBO; QFX and QBO are both OFX-based, so the transactions are equivalent.
Which format should I use for QuickBooks?
Use QBO for the cleanest QuickBooks import. CSV also works if you prefer to map columns during import.