QBO Validator
Drop any .qbo file to instantly check its structure. Validates OFX headers, required SGML elements, transaction integrity, date formats, amounts, FITID uniqueness, and account info. Nothing leaves your browser.
QBO File
Drop a .qbo file here, or
Supports .qbo and .ofx files up to 50 MB
⛔
Wrong file type — only .qbo or .ofx files are supported. You dropped a file.
Validation Errors
Warnings
✓ Valid QBO
File & Account Details
Transaction Preview (first 10)
How It Works
1
Drop your QBO fileDrag it onto the drop zone or click "browse" to select it. Supports .qbo and .ofx files exported from your bank or accounting software.
2
Structure analysisThe validator checks the OFX header block, required SGML elements, every transaction's required fields (TRNTYPE, DTPOSTED, TRNAMT, FITID), date formats, amount formats, and FITID uniqueness.
3
Review the reportGet a pass/fail result plus full stats: transaction count, date range, currency, account type, balance, and a live preview of the first 10 transactions.
What Gets Validated
- OFX header block — checks that all 9 required header fields are present (
OFXHEADER,DATA,VERSION,SECURITY,ENCODING,CHARSET,COMPRESSION,OLDFILEUID,NEWFILEUID). - Required SGML elements — verifies the presence of
<OFX>,<STMTRS>,<CURDEF>,<BANKACCTFROM>, and<BANKTRANLIST>. - Transaction fields — every
<STMTTRN>block is checked for the four required fields:TRNTYPE,DTPOSTED,TRNAMT, andFITID. - Date formats — validates that all
DTPOSTED,DTSTART, andDTENDvalues follow the OFX date format (YYYYMMDDorYYYYMMDDHHMMSS) and represent real calendar dates. - Amount formats — checks that
TRNAMTvalues are valid decimal numbers and flags transactions with a zero amount. - FITID uniqueness — detects duplicate Financial Institution Transaction IDs, which cause QuickBooks to silently skip re-imports.
- Transaction type values — validates that
TRNTYPEis one of the 11 OFX-standard values (CREDIT, DEBIT, INT, DIV, FEE, SRVCHG, DEP, ATM, POS, XFER, CHECK, PAYMENT, CASH, DIRECTDEP, DIRECTDEBIT, REPEATPMT, OTHER). - Account & balance info — extracts account ID, bank routing number, account type, currency, and ledger balance for quick review.
🔒 Privacy & Security
All validation is performed locally using the Web File API and the FileReader API. Your bank transaction data is never sent to a server. Suitable for sensitive financial records, business accounts, or any private QBO content.