How to import a QBO file into QuickBooks Desktop
Import a Web Connect QBO statement with File, Utilities, Import, Web Connect.
- 1
Start from a statement, not a renamed CSV
A QBO file is OFX 1.0.2 in SGML form, with the INTU tags QuickBooks Desktop expects. Changing a CSV extension to .qbo does not make a Web Connect file.
- 2
Download QBO
Read the bank statement, confirm the dates and the sign of each amount, and download QuickBooks Web Connect (.qbo).
- 3
Import it
In QuickBooks Desktop choose File, then Utilities, then Import, then Web Connect Files. You can also double-click the file and let Desktop open it. Pick the register the statement belongs to.
- 4
Review the account it offers
Desktop matches the file to an account with the institution id and the account number inside the file. If it offers the wrong register, cancel and set the institution id and account number on the converter before you download again.
- StatementZap writes OFX 1.0.2 SGML in ASCII, which is the Web Connect shape. OFX 2 XML is a different download and is not what the .qbo path expects.
Questions
Desktop says it cannot read the file. What now?
See the guide on that message. The usual causes are a CSV renamed to .qbo, a missing institution id, or a date the reader rejected.