Skip to the converter
StatementZap

Guides

How to fix QuickBooks can't read this file

What to check when QuickBooks Desktop refuses a Web Connect statement.

  1. 1

    Confirm the file is actually QBO

    Open it in a text editor. A Web Connect file starts with OFXHEADER and is SGML, not a spreadsheet and not XML. A CSV saved as .qbo will not import.

  2. 2

    Check the dates

    An impossible date, or a column read day-first when the bank wrote month-first, makes a statement Desktop will not take. Re-read ambiguous slash dates with an explicit order and download again.

  3. 3

    Check the institution id

    Desktop expects INTU.BID. If the import dialog names the wrong bank, set the institution id for the bank you are importing into and download again. The transactions still go to the register you pick.

  4. 4

    Try the other QuickBooks file

    QuickBooks Online will not import QBO. Use the 3-column or 4-column CSV for Online. Use QBO only for Desktop Web Connect.

Questions

The message appeared on a PDF. What does that mean?

Desktop cannot import a PDF. Convert the text-based statement to QBO first, or to CSV if you are in QuickBooks Online.