Login / Sign Up

/ Guides File types

What is a QBO file?

The file your bank gives you when you click “Download for QuickBooks”. Here is what is inside it, what opens it, and what to do when QuickBooks won’t take it.

By Zishan Khan · Last checked · Sources

Short answer

A QBO file is a list of bank transactions saved in the format QuickBooks imports. Your bank makes one when you choose “QuickBooks Web Connect” as the download type. It holds each transaction’s date, amount and payee, plus the bank’s own ID for it, so QuickBooks can tell new transactions from ones it already has. You open it in QuickBooks; to read it yourself, convert it to Excel.

Extension
.qbo
Official name
QuickBooks Web Connect
Made for
QuickBooks Online and Desktop
Inside
Plain text (OFX)

Two things are called QBO

Accountants say “QBO” for QuickBooks Online, Intuit’s web version of QuickBooks. A file ending in .qbo is something else: a bank download. The two meet because you can upload a .qbo file into QuickBooks Online, but they are not the same thing.

So if someone sends you a .qbo file and you were expecting a copy of their books, it isn’t one. QuickBooks Online companies live on Intuit’s servers and can’t be saved as a single file, and QuickBooks Desktop company files end in .qbw. A .qbo file only ever holds transactions from one bank or card account, for one stretch of dates.

What’s inside a QBO file

A QBO file is plain text. Open one in Notepad or TextEdit and you will see short tags in angle brackets, one value per line. Underneath, it is an OFX file, the open standard banks use for downloads, with one extra line from Intuit. Here is a real one, cut down to a single transaction:

sample-transactions.qboOpened as plain text

  1. 1OFXHEADER:100
  2. DATA:OFXSGML
  3. VERSION:102
  4. … six more header lines, then the bank’s sign-on block …
  5. <FI>
  6. <ORG>Sample Bank
  7. <FID>3000
  8. </FI>
  9. 2<INTU.BID>3000
  10. … the start of the statement …
  11. <CURDEF>USD
  12. <BANKACCTFROM>
  13. <BANKID>000000000
  14. 3<ACCTID>000123456789
  15. <ACCTTYPE>CHECKING
  16. </BANKACCTFROM>
  17. <BANKTRANLIST>
  18. <DTSTART>20260901120000
  19. <DTEND>20260914120000
  20. <STMTTRN>
  21. <TRNTYPE>DEBIT
  22. 4<DTPOSTED>20260902120000
  23. <TRNAMT>-1850.00
  24. 5<FITID>20260902691cd7d3a96ce9be
  25. 6<NAME>DD HARBOUR PROPERTIES RENT 02SEP
  26. </STMTTRN>
  27. … seven more transactions, each in its own <STMTTRN> block …
  28. </BANKTRANLIST>
  29. <LEDGERBAL>
  30. 7<BALAMT>18425.50
  31. <DTASOF>20260914120000
  32. </LEDGERBAL>
  1. The header. It says the rest of the file is OFX version 1.0.2, the open format for bank downloads. A QBO file is an OFX file underneath.
  2. Intuit’s bank ID, the line that makes an OFX file a QBO file. QuickBooks checks it against Intuit’s list of banks. Our converter writes 3000, the ID most converters use, which belongs to Wells Fargo, so QuickBooks Desktop may label the account “Wells Fargo”. The transactions are still yours.
  3. The account number and, below it, the account type: checking here. Card accounts use a slightly different block.
  4. One transaction starts. Dates are written year, month, day: 20260902 is 2 September 2026. Money out is a negative amount.
  5. The FITID: the bank’s own ID for this one transaction. QuickBooks remembers it, and skips the transaction if it ever sees the same ID again. This is what stops duplicates.
  6. The payee. QuickBooks keeps the first 32 characters, so long bank descriptions are cut short here; our converter puts the full text in a separate memo line.
  7. The closing balance on the last date in the file.
Made by our converter from the demo statement on our home page. Bank files have the same parts, with the bank’s own IDs.

Notice what is missing. There is no running balance after each transaction, no categories, and nothing about your books. A QBO file says what happened in the bank account. Deciding what each transaction was for happens inside QuickBooks, after the import.

Where QBO files come from

Many US banks and card companies offer one in online banking. Look for Download or Export on the account’s transactions page, then pick “QuickBooks Web Connect”, “QuickBooks (.qbo)” or similar from the list of formats. How far back you can go depends on the bank.

When there is no QBO option, you have three ways round it:

  • Your bank offers CSV or Excel. Convert it with a CSV to QBO converter. QuickBooks Online also takes CSV directly, but only in a strict three- or four-column layout.
  • Your bank offers OFX or QFX. QuickBooks Online accepts QFX files as they are. For QuickBooks Desktop, an OFX to QBO converter adds the Intuit bank ID it looks for.
  • All you have is the PDF statement. This is common for older months, closed accounts and banks outside the US. A bank statement to QBO converter reads the PDF and writes the QBO file.

How to open a QBO file

Which program you open it in depends on what you want from it.

QuickBooks Online

Don’t double-click it. Go to Bank transactions, then Link account › Upload from file, and pick the file. Up to 350 KB and 1,000 transactions per upload. Full steps.

QuickBooks Desktop

File › Utilities › Import › Web Connect Files. Pick the account, then review the transactions in Bank Feeds. Full steps.

Quicken

Quicken won’t import a QuickBooks file. It wants the Quicken version of the same thing, a QFX. Convert QBO to QFX.

Excel or Google Sheets

Convert it to a spreadsheet first, below. You get one row per transaction with the date, payee, memo and amount in their own columns.

Read a QBO file here, in your browser

Drop your .qbo file in the box. It is read on your computer, not uploaded, and you get an Excel file with every transaction. There is a sample file in the box if you want to see how it works first.

No file to hand?

When QuickBooks won’t take the file

“The file is too large”

QuickBooks Online takes up to 350 KB and 1,000 transactions in one upload. Download a shorter date range from your bank, a quarter or a month at a time, and upload the pieces one after another.

It went into the wrong account, or made a new one

When you import, QuickBooks asks which account the file belongs to. Pick your existing bank account. If you let it create a new one by mistake, exclude or delete those transactions and import again into the right account.

Some transactions came in twice

QuickBooks skips transactions whose bank ID it has seen before, so the same file can’t double up. Doubles come from the same transactions arriving with different IDs: once through the bank feed and once from a file, or from two different converters. Review before you accept, and exclude the copies.

The account shows the wrong bank name

QuickBooks Desktop names the bank from the Intuit bank ID in the file. Files made by converters often carry Wells Fargo’s ID, as ours do, so the account may be labelled “Wells Fargo”. You can rename the account; the transactions are not affected.

Double-clicking opens the wrong program

On a computer with QuickBooks Desktop installed, double-clicking a .qbo file usually opens it in Desktop. For QuickBooks Online, always upload from the Bank transactions page instead.

QBO compared with QFX, OFX, QIF and IIF

These five formats all carry bank transactions. They differ in which program they were made for and in how much they protect you from duplicates.

The five bank-download formats
FormatMade forInsideBank’s ID per transactionWhere it lands
QBOQuickBooks Online and DesktopOFX plus Intuit’s bank IDYesBank feed, to review
QFXQuickenOFX plus Intuit’s bank IDYesQuicken’s downloads, to review
OFXXero, Sage, MYOB, GnuCash and most othersTagged text, an open standardYesThe app’s import screen
QIFQuicken, GnuCash, Banktivity, older appsOne field per lineNoStraight into the register
IIFQuickBooks Desktop onlyTab-separated rowsNoStraight into the books

The bank’s ID on each transaction is what lets software skip transactions it already has. Without it, importing the same file twice means doubles.

QBO and QFX are the same format with different names: QBO for QuickBooks, QFX for Quicken. In the files our converter writes, the .qbo and the .qfx are identical line for line. Still use the one your program asks for, because QuickBooks Desktop and Quicken each expect their own extension.

An IIF file is the other way into QuickBooks Desktop. It skips the review step and posts transactions straight into your books, which is faster and riskier.

Questions

Can I open a QBO file in Excel?

Excel will open it, but you will see the raw tags shown above, one per line, not a table. To get a proper spreadsheet with a date, payee and amount column, convert the file to Excel or CSV. The converter on this page does it in your browser, free, without uploading the file.

Can I edit a QBO file?

It is plain text, so any text editor can change it. Small slips break it, though: a deleted tag makes QuickBooks reject the file, and a changed FITID makes QuickBooks treat a transaction as new. The safer way is to convert it to Excel, make your changes there, and convert it back to QBO.

Is a QBO file the same as QuickBooks Online?

No. QBO is also short for QuickBooks Online, which is confusing. A .qbo file is only a list of bank transactions. Your QuickBooks Online company lives on Intuit’s servers, and a QuickBooks Desktop company file ends in .qbw.

Can I turn a PDF bank statement into a QBO file?

Yes. A bank statement converter reads the transaction table in the PDF and writes it as a QBO file. Ours checks every row against the statement’s own balances before you download, and runs in your browser. QuickBooks Online can also read some PDF statements itself now, without a QBO file.

Will importing the same QBO file twice create duplicates?

Not if the file is the same: QuickBooks skips transactions whose FITID it already has. Duplicates appear when the same transactions arrive with different IDs, for example once through the bank feed and again from a file made by another tool. Check the “For review” list (Online) or Bank Feeds (Desktop) before you accept anything.

Is it safe to share a QBO file?

Treat it like a bank statement. It holds your account number and every transaction in the period, so send it only to people you would show your statement to, such as your bookkeeper.

Sources

Read on 6 October 2026. Software changes its menus often; if a step here no longer matches what you see, please tell us at hello@safebankstatementconverter.com and we will fix it.

  1. Intuit: Manually upload transactions into QuickBooks Online
  2. Intuit QuickBooks Community: Import web connect (.qbo) files
  3. Financial Data Exchange: OFX Work Group (the OFX standard)
  4. Quicken: How do I import data into Quicken for Windows?
  5. Xero Central: About manually importing bank transactions

→ Keep going

Related guides and converters.

Guides

Stop retyping
bank statements.

Convert a statement free →