Skip to the converter
StatementZap

Guides

How to import a QBO file into QuickBooks Desktop

Import a Web Connect QBO statement with File, Utilities, Import, Web Connect.

  1. 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. 2

    Download QBO

    Read the bank statement, confirm the dates and the sign of each amount, and download QuickBooks Web Connect (.qbo).

  3. 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. 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.

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.