The file has a header and an OFX body
Older QBO files commonly use an OFX 1.x SGML-style header followed by an <OFX> body. Newer OFX variants may use XML. A parser should inspect the structure instead of relying only on the extension.
QBO file format
A QBO Web Connect file combines an OFX header with account and transaction blocks that supported QuickBooks workflows can read. This is a structural reference, not a compatibility promise.
Updated July 20, 2026 · Examples use fictional data.
Older QBO files commonly use an OFX 1.x SGML-style header followed by an <OFX> body. Newer OFX variants may use XML. A parser should inspect the structure instead of relying only on the extension.
OFXHEADER:100 DATA:OFXSGML VERSION:102 ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE
Bank statements commonly use BANKMSGSRSV1, STMTRS, and BANKACCTFROM. Credit-card statements may use CREDITCARDMSGSRSV1, CCSTMTRS, and CCACCTFROM.
| Tag | Purpose | BankFileKit read support |
|---|---|---|
DTPOSTED | Posting date and optional time/zone | Required |
TRNAMT | Signed transaction amount | Required |
FITID | Transaction identifier | Preserved when present |
NAME | Short transaction name | Used before MEMO |
MEMO | Longer description | Used as fallback |
CHECKNUM | Check reference | Preserved when present |
<STMTTRN> <TRNTYPE>DEBIT <DTPOSTED>20260710120000.000[-5:EST] <TRNAMT>-24.75 <FITID>FICTIONAL-0001 <NAME>Fictional Supply Store </STMTTRN>
A QBO header declares an encoding. BankFileKit's beta writer declares USASCII with character set 1252 and replaces non-ASCII characters with ?. Review names and memos when the source contains accented or non-Latin text.
The file normally carries bank-feed transactions, not invoices, chart-of-accounts rules, reconciliations, payroll, or an entire QuickBooks company. See the QBO definition guide for the distinction from QBW files.
The current reader extracts bank or credit-card transaction blocks with valid dates and amounts. It does not promise support for every OFX message set, investment statement, loan statement, or vendor-specific extension.
The CSV/XLSX to QBO writer creates a candidate US English and USD Web Connect file. It has not been verified in real QuickBooks Desktop, so users must test a fictional file in a blank company.
A structurally plausible QBO file can still fail because the target product, account connection, institution fields, or transaction identifiers are incompatible. Successful download is not proof of successful import.