What is a QBO File? How to Open, Create, and Convert One

What is a QBO File?

A QBO file is a bank statement file used by QuickBooks Online to import transactions directly from your bank. Despite the name, QBO files are actually OFX (Open Financial Exchange) files — a standardized XML-like format for financial data.

When you download a bank statement from your bank, you might see options like:

• CSV / Excel — plain spreadsheet data
• OFX / QBO — QuickBooks-compatible format
• QFX — Quicken-compatible format (similar to QBO)

What's Inside a QBO File?

A QBO file is a plain text file structured like this:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
  <SIGNONMSGSRSV1>
    <SONRS>
      <STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY></STATUS>
      <DTSERVER>20260301</DTSERVER>
      <LANGUAGE>ENG</LANGUAGE>
    </SONRS>
  </SIGNONMSGSRSV1>
  <BANKMSGSRSV1>
    <STMTTRNRS>
      <STMTRS>
        <CURDEF>USD</CURDEF>
        <BANKACCTFROM>
          <BANKID>123456789</BANKID>
          <ACCTID>987654321</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20260101</DTSTART>
          <DTEND>20260228</DTEND>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20260115</DTPOSTED>
            <TRNAMT>-125.00</TRNAMT>
            <FITID>2026011500001</FITID>
            <MEMO>Office Supplies Co</MEMO>
          </STMTTRN>
        </BANKTRANLIST>
      </STMTRS>
    </STMTTRNRS>
  </BANKMSGSRSV1>
</OFX>

How to Open a QBO File

QBO files are plain text — you can open them with:

• Notepad (Windows) or TextEdit (Mac) to view the raw content
• QuickBooks Online to import the transactions

To import into QuickBooks Online:

1. Go to Banking > Transactions
2. Click Upload transactions
3. Select your QBO file
4. Map to the correct bank account

How to Create a QBO File from CSV

Most banks only export CSV, not QBO. That's where a converter helps:

1. Download your bank statement as CSV
2. Use QBOConvert — free and unlimited
3. Map your columns — Date, Description, Amount
4. Download the QBO file
5. Import into QuickBooks Online

This is the most common workflow for people who can't find a QBO download option at their bank.

QBO vs QFX vs OFX — What's the Difference?

All three are based on the OFX standard. QuickBooks Online specifically recognizes the .qbo extension.

Common QBO Import Errors

• "File type not supported" — Make sure you're uploading a .qbo file, not .csv
• "Duplicate transactions" — QuickBooks will warn you if the date range overlaps a previous import
• "No transactions found" — Check that your QBO file has STMTTRN records with valid dates