How to fix QuickBooks can't read this file
What to check when QuickBooks Desktop refuses a Web Connect statement.
- 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
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
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
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.
- OFX 2 is XML. The .qbo download is OFX 1 SGML on purpose. If a tool asked for XML, download OFX 2 instead of renaming the QBO file.
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.