CSV to QBO Converter
Menu

QBO File Checker and Fixer

Open a QBO or QFX file, see exactly what is wrong with it, and download a clean copy that follows the OFX structure.

Drop your bank file here or choose a file

QBO, QFX or OFX · stays on your device

No signup. Your file never leaves your computer. Works in your browser.

How to check and fix a QBO file

  1. Drop the QBO or QFX file into the checker The file is read in your browser. OFX files work too.
  2. Read the results Each check shows a green tick, a warning or an error, with a plain explanation and examples from your file.
  3. Choose how to rebuild it Pick QBO (QuickBooks) or QFX (Quicken), the account type, and the bank ID that should go into the file.
  4. Download the fixed file Click Download fixed QBO file. It has the same transactions, written in a clean structure with unique transaction IDs.
  5. Import it again Import the fixed file into QuickBooks or Quicken. You can drop it into the checker first to confirm it passes.

What the QBO file checker looks at

QBO and QFX files are bank statements written in OFX, a tagged text format. QuickBooks and Quicken are strict about it. The checker reads the file the same way and reports on:

  • The file header: the plain-text lines (such as OFXHEADER:100 and VERSION:102) or the XML header at the top.
  • The sign-on section: status, server date and language, which every statement file must have.
  • The bank ID: whether the file has an INTU.BID and whether it appears in Intuit’s list of Web Connect banks.
  • The account: bank ID, account number and account type for bank accounts, or the card number for credit cards.
  • The statement: start and end dates, currency and the ending balance.
  • Every transaction: its ID (FITID), date, amount, type and name.
  • Special characters: an & that isn’t written as &.

QuickBooks error messages and what they mean

These are the Web Connect messages Intuit lists for QBO files that won’t import, with Intuit’s own fixes:

  • “QuickBooks found an error. We can’t read the file [your bank] sent.”, “An error occurred while processing your online banking data.” or “Your data was not imported into QuickBooks.” The file is incomplete or not in a format QuickBooks reads. Drop it into the checker to find the broken part, then rebuild it.
  • “QuickBooks is unable to verify the Financial Institution information for this download.” QuickBooks doesn’t accept the bank in the file. Rebuild the file with another bank from the list. Intuit also gives this message as an example of what happens on a QuickBooks Desktop version it no longer supports (Desktop 2023 lost support after May 31, 2026).
  • “To download and import transactions, sign in with your Intuit account”: sign in to your Intuit account inside QuickBooks Desktop. If you’re already signed in, Intuit suggests switching Bank Feeds modes.
  • OL-222: a QuickBooks team member describes it as QuickBooks being unable to read the imported file, usually because of its format or damaged data. Check the file here and import the rebuilt copy.
  • “Error: Nothing imported. Account up to date.” (QuickBooks for Mac): every transaction in the file was already imported. QuickBooks ignores transaction IDs it has seen before.

Intuit’s general fix list for Web Connect errors: download the file again, switch Bank Feeds to Classic Mode (Banking › Bank Feeds › Change Bank Feeds Mode) and import again, or try the import in a test company file (File › New Company) to see whether the problem is the file or the company file.

Supported banks and file layouts

QBO, QFX, OFX and QIF files from any bank

The reader handles both forms of OFX (the older SGML form used by QBO and QFX files, and the newer XML form), bank and credit card statements, and files that hold more than one account. QIF files from Quicken and other apps are read too, including Quicken's old date styles.

Any bank's CSV or Excel file

The converter finds the header row (even below bank names and account summaries), matches columns by name and by content, and handles one signed amount column, separate debit and credit columns, or an amount with a DR/CR column. Dates like 01/05/2026, 2026-01-05 and Jan 5, 2026 and amounts like (1,234.56) or 1234.56- are all read.

Common problems and fixes

No bank ID (INTU.BID)
QuickBooks and Quicken use the bank ID in the file to know which bank it came from. A file without one is usually refused. Pick a bank in the checker and rebuild the file.
The bank ID is not in Intuit's list
The checker compares the file's bank ID with Intuit's published list of banks that offer Web Connect. If the ID isn't there, pick a bank from the list and rebuild the file.
Transactions without a FITID, or the same FITID twice
Every transaction needs its own ID. Without one, or with repeats, transactions can be skipped or imported twice. The rebuilt file gives every transaction a stable, unique ID.
Dates or amounts in the wrong format
OFX dates are written as YYYYMMDD (for example 20260105) and amounts as plain numbers like -45.10. Dates like 2026-01-05 or amounts with commas break the import. The rebuilt file uses the right formats.
Names longer than 32 characters
The name field holds up to 32 characters. Longer names are cut to 32 in the rebuilt file, and the full text is kept in the memo.
An unescaped "&" in a name
In OFX text, "&" must be written as "&". Some programs reject the file otherwise. The rebuilt file escapes it.

Frequently asked questions

Why won't QuickBooks import my QBO file?

The most common reasons are a bank ID QuickBooks doesn't recognize, missing or repeated transaction IDs, dates or amounts in the wrong format, and a missing file header. Drop the file into the checker above to see which applies.

Does the checker change my file?

No. It only reads it. If you choose to rebuild, it creates a new file and leaves yours as it is.

Does it work with QFX files for Quicken?

Yes. QBO and QFX files share the same OFX structure. Choose QFX when you rebuild a file for Quicken.

Is my file uploaded?

No. The file is read and checked in your browser and never leaves your computer.

The checker finds no problems but QuickBooks still refuses the file. What now?

Check that the account type in the file (bank or credit card) matches the QuickBooks account you link it to, and try another bank ID from the list. If you made the file from a CSV, you can also convert the CSV again with the CSV to QBO converter.

Last updated · EmproIT