Bank statement file formats, explained

• .qboWhat Is a QBO File?A .qbo is a Web Connect bank statement: an OFX document carrying a transaction list, a closing balance and a number identifying the institution.6 min read
• .ofxWhat Is an OFX File?An OFX file is a bank statement in Open Financial Exchange, the format .qbo and .qfx are both built on. It comes in two dialects that look nothing alike.5 min read
• .qfxWhat Is a QFX File?A .qfx is Quicken's Web Connect statement: the same OFX document as a .qbo, registered to a different product and carrying a different extension.5 min read
• .qifWhat Is a QIF File?A QIF is Quicken's plain-text transaction format: one single-letter code per line, a caret between entries, and no balance or bank named anywhere in it.7 min read
• .iifWhat Is an IIF File?An IIF is QuickBooks Desktop's tab-delimited interchange format: typed blocks that declare their own columns, double-entry transactions, and no balance.6 min read
• .mt940What Is an MT940 File?MT940 is SWIFT's customer statement message: a tagged text format used across European banking, where the comma is the decimal point.6 min read
• .qbjWhat Is a QBJ File?A .qbj holds general journal entries an accountant prepared for a client's QuickBooks Desktop file. Here is who makes one, and what to do with it.6 min read
• .csvBank Statement CSV Format ExplainedThere is no standard bank statement CSV. Here is what every one has in common, the five things that differ between banks, and how to tell what you have.6 min read

Need to change one into another?

Understanding the format is usually the step before converting it. The converters read every format described here, in whichever direction the formats allow, and reconcile the result before you download it.