Free tool

Check a QBO, QFX or OFX file before you import it

Find what is wrong inside a bank file: a broken header, a missing account block, impossible dates, unreadable amounts or repeated transaction IDs. Free, no account, and the file is not kept.

Up to 5 MB. OFX 1.x (SGML) and 2.x (XML) files.

Want to see the transactions instead? Open the viewer.

What a pass tells you, and what it does not

The file is well formed

Header, account, period, dates, amounts, transaction types and IDs all pass the validator’s checks, which rules out the problems it checks for.

Not that a program will accept it

QuickBooks or Quicken can still refuse a well-formed file, for example when they cannot verify the bank it comes from or the bank no longer supports Web Connect.

Not that the numbers are right

The file cannot prove its own transactions. Only the original statement can show whether a row is missing, doubled or signed the wrong way.

Starting from a PDF statement?

StatementLoom builds QBO, QFX and OFX files from text PDF statements and only lets you download once the transactions add up to the statement’s own balances. Try the free converter, read about PDF to QBO, or turn a bank file into CSV.

Questions

What does the validator check?
The OFX header, the sign-on and statement blocks, the account block, the currency, the statement period, the ledger balance, and every transaction’s date, amount, type, ID uniqueness and payee name length.
If the file passes, will QuickBooks, Quicken or Xero accept it?
Not necessarily. A well-formed file can still be refused, for example when QuickBooks or Quicken cannot verify the bank it comes from. The validator rules out the problems it checks for, which narrows down where to look.
Does a pass mean the transactions are right?
No. The validator only sees the file. Whether its transactions match the original bank statement can only be checked against that statement.
Is my file stored?
No. It is read to run the checks and is not kept.

QuickBooks, Quicken and Xero are trademarks of their respective owners. StatementLoom is not affiliated with or endorsed by them; their names describe file compatibility only.