Glossary

What Is a QBO File?

A QBO file is a bank statement written in Web Connect, the format QuickBooks Desktop reads when you download transactions from a bank's website instead of letting the program fetch them itself. Inside is Open Financial Exchange data, the same tagged text that OFX and QFX use, with one difference that decides everything: the header names the bank and addresses QuickBooks specifically. QuickBooks reads that header before it reads a single transaction, so a file can be perfectly intact and still be turned away at the door.

TL;DR

A .qbo is an OFX statement addressed to QuickBooks by name, and the names in its header decide whether the import starts at all. If you only need to read the file rather than import it, convert it to PDF or CSV instead.

5,766
institutions in our bank directory that come straight from Intuit's own published list - the block that supplies a real INTU.BID alongside the FID

QBO the File Is Not QuickBooks Online

Two unrelated things share the same three letters, and the confusion is the reason most people end up on a page like this. QuickBooks Online is Intuit's subscription accounting service that runs in a browser, and accountants shorten its name to QBO in conversation. A .qbo file is a statement sitting on your disk: one account, one period, a list of transactions. It is not an export of a QuickBooks Online company and it is not a company file holding your books. When somebody says they are sending you the QBO, the thing that arrives by email is the statement.

Nothing on a plain Windows install opens a .qbo by double-click, because the format was never given a viewer of its own. It was designed to be handed from a bank to one accounting program, and everything else about it follows from that.

What the Header Actually Declares

Open a .qbo in a text editor and the first thing you meet is not a tag but a short preamble of key and value lines: which version of the specification the file follows, and which character set it is written in. Then the sign-on block arrives. Inside it sits FI, holding ORG, a short code for the institution, and FID, the institution's number. Directly after comes INTU.BID, Intuit's own tag, which plain OFX does not define at all - it is the mark that makes the file a .qbo rather than a neutral .ofx. Only past that point does the file get to the account, the statement period, and the transactions, each with a date, an amount and an id of its own.

Renaming the extension changes nothing. An .ofx renamed to .qbo still has no Intuit tag for QuickBooks to find, and a .qbo renamed to .qfx still addresses the wrong product. Those identifiers are written inside the file, and the only way to change them is to write the file again.

Why a Valid File Still Gets Turned Away

Because the check happens on the header, the failures cluster there too. The institution code and number in the file may not match anything QuickBooks recognises. The bank may have dropped off Intuit's list since the file was made. The copy of QuickBooks may simply be too old to take a Web Connect import at all. In every one of those cases the transactions inside are fine and the wording of the refusal talks about the financial institution, which sends people hunting for corruption in a file that has none. It is also worth knowing that Web Connect accepts only .qbo - an OFX or QFX download from the same bank is not an alternative route into the same window.

Reading a QBO File Without QuickBooks

The format is plain text, which tempts people into opening it in Notepad, but plain text is not the same as readable. A single transaction is spread over a dozen tags, dates are run together as digits, and the amounts sit next to identifiers meant for a machine. Turning the file into a printed statement or a spreadsheet is a conversion job, and it can be done on your own PC, without an account and without the statement leaving the disk it is already on.

What you'll need
  • QBO to PDF Converter: opens .qbo and .ofx files without QuickBooks and saves them as a printable PDF statement or a CSV table, on Windows
  • A Windows PC, version 10 or 11
  • The .qbo file your bank or your bookkeeper sent you

O que irá aprender

Related Guides

Related Terms