QBO file: what it is and the limits for uploading bank files to QuickBooks Online

What a QBO file is

Intuit’s partner documentation describes Web Connect as the connection that starts in a bank’s online banking site: you download a .qbo (QuickBooks) or .qfx (Quicken) file and import it into QuickBooks or Quicken. No bank credentials are entered in QuickBooks, because the download happens in the bank’s own site. Web Connect works with QuickBooks Desktop, QuickBooks Online and Quicken.

Intuit’s help on Web Connect import errors says the QuickBooks Desktop Web Connect import reads only .qbo files. Intuit’s upload guidelines for QuickBooks Online say it suggests a QBO file and also accepts QFX or CSV. The pages cited here do not describe the inside of a QBO file, so this page does not either.

Upload limits for QuickBooks Online

CSV column rules

A CSV upload needs either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit). Intuit lists these clean-up rules:

• Remove the word “amount” from the Credit and Debit headings.
• Leave blank any cell in Amount, Credit or Debit that only holds zero.
• Remove numbers from the Description column.
• Write every date in the same format; Intuit recommends dd/mm/yyyy.
• If the bank adds the day of the week to the date (for example 20/11/2022 TUE), split the date and the weekday into separate columns.

During the upload you match the file’s columns to QuickBooks fields, and a later screen lets you reverse all values if positive and negative amounts came in the wrong way round.

How to upload a file

1. Open Bank transactions under Accounting.
2. Select the account’s tile if it is there, then the Link account dropdown, then Upload from file.
3. Drag in or select the file, then Continue.
4. Choose the QuickBooks account to upload into (add a new one if none exists), then Continue.
5. Match the file’s columns to QuickBooks fields, Continue, select the transactions to import, and Continue.

Intuit’s guidelines also describe uploading an account statement itself: from any bank, in English, as a PDF or an image file such as JPG, PNG or HEIC. That is a separate route from the transaction-list files above, with its own steps in the same Intuit article.

QBO, QFX and OFX

Common questions

Does QuickBooks Online accept QFX files?

Yes. Intuit’s upload guidelines say that along with a suggested QBO file, you can upload QFX or CSV files.

Can QuickBooks read a PDF statement?

Intuit’s guidelines describe a separate statement upload route that takes a PDF or an image file. Transaction-list uploads use the file types in the table above.

What is the difference between QBO and IIF?

A .qbo file is the Web Connect download that brings bank transactions into QuickBooks. IIF is tab-separated text for importing lists and transactions into QuickBooks Desktop. See the IIF page.

What Statementizer does with this

Related formats

• OFX file: what it is, a sample, and how to read one
• QIF file: what it is, a sample and how to import one
• QFX file: what it is, where it comes from and how to import one
• IIF file for QuickBooks Desktop: structure, a sample and limits

Sources

Every limit and column rule on this page is quoted from Intuit’s upload guidelines for QuickBooks Online. The Web Connect description comes from Intuit’s partner page, and the Desktop statement from its Web Connect error page.

• Manually upload transactions into QuickBooks OnlineIntuit QuickBooks Help · Primary source · accessed 2026-10-18
• Connectivity Types (OFX): Web Connect, Direct Connect, AggregationIntuit · Primary source · accessed 2026-10-18
• Fix Web Connect import errorsIntuit QuickBooks Help · Primary source · accessed 2026-10-17

Verified on 2026-10-18 by the Statementizer Team.