Combine Multiple QBO Files in QuickBooks: Merge QBO Exports and Company Data

TL;DR: QuickBooks has no built-in button to merge two .qbo files, and no way to merge two QuickBooks Online companies into one. You have two practical paths for .qbo files: import each file separately into the same QuickBooks company (they stack in the bank feed, and QuickBooks flags likely duplicates), or produce one .qbo file that already covers every statement period or account you need before you import. For combining two separate QuickBooks Online companies, Intuit's own answer is that companies cannot be merged: you export lists and transactions from one and bring them into the other, or use a third-party migration service.

Last updated July 2026.

Why people search for a way to combine QBO files

The same search hides three different problems, and each one needs a different answer. It helps to figure out which one you actually have before you touch anything.

(a) You have twelve monthly .qbo files for one bank account and want them in as a single import. That is the file-combining question, covered in the next two sections.

(b) You have several bank accounts and want them all sitting in one QuickBooks company. That is really an import question, and each account keeps its own file. See the sections on importing per account and building one clean file.

(c) You have two entire QuickBooks Online companies, say an old one and a new one, or a business you acquired, and you want them as one. That is the hardest case and it is answered further down under combining two companies. Skip ahead if that is you.

Can you merge two .qbo files into one?

Not by pasting them together, and usually you should not try. A .qbo file makes sense to merge only when both files are the exact same bank account, because a .qbo file maps to one account when QuickBooks imports it. Two accounts means two files.

Here is why the naive approach fails. A .qbo file (Web Connect, based on the OFX standard) is a structured file. It opens with a header block that names one financial institution, one account number, and one date range, and then lists the transactions inside tags that open and close cleanly. If you concatenate two files in a text editor, you end up with two headers and two sets of closing tags stacked in one document. QuickBooks reads that as broken and rejects it. Even when both files really are the same account, a valid manual merge is fiddly, and there is an easier route.

The simpler answer: import each file into the same account

You do not need one merged file. QuickBooks will happily take several files into the same account, one after another, and they all land in the same review queue.

In QuickBooks Online: go to Transactions, then Bank transactions, then Upload from file. Choose the .qbo, map it to the right account, and import. QuickBooks Online takes one file at a time, so repeat for each file. Full steps live in our guide to importing a bank statement into QuickBooks Online.

In QuickBooks Desktop: go to File, then Utilities, then Import, then Web Connect Files, and pick the file. Repeat per file.

Import them in chronological order so the running balance and any opening balance make sense, and reconcile month by month instead of all at once. It is slower to set up but far easier to check.

How QuickBooks handles duplicate transactions

The real risk when you combine files is overlapping date ranges. If March shows up in two different files, some transactions get imported twice. QuickBooks flags likely duplicates on import by matching transaction IDs, but the flag is not perfect, so the safest fix is to make sure your periods do not overlap in the first place.

If a few slip through, you do not have to wipe the account history. You can exclude transactions in the For Review tab instead of deleting anything. For the wider cleanup, including matched versus added copies, see our walkthrough on fixing duplicate bank transactions in QuickBooks.

Combining several statement periods into one QBO file

If you would rather import once, build one file that already covers the whole stretch. Convert all your statements together and produce coverage for the full period, then do a single import per account.

This site's converter takes a PDF statement, or several PDFs at once, and produces a .qbo Web Connect file per account, plus Excel and CSV copies of the same data. Load a stack of months in our bulk bank statement to QuickBooks tool, or start with a single file on the PDF to QBO converter page. A manual .qbo import has no 90-day lookback limit the way a live bank feed does, which is why this route works for older statements the feed will not reach.

One caveat on inputs: the converter reads PDF statements and images, not spreadsheet exports. If what you have is a CSV export from your bank rather than a PDF, you can turn that CSV into a QBO file instead, then import that.

Can you combine two QuickBooks Online companies?

No. Intuit does not offer a merge of two QuickBooks Online companies into one. Each company file is separate, and that is by design. What you can do falls into three realistic options.

First, pick the surviving company and bring the other one's history into it: export the lists (chart of accounts, customers, vendors, products and services) and then import transactions by file, account by account. Start with the chart of accounts so everything else has somewhere to land.

Second, keep the old company as a read-only archive for the prior years and start clean in the new one. This is often the least painful choice when the old data is messy.

Third, if the two entities are genuinely separate legal entities, they should stay separate. Use Classes or Locations inside one company, or a consolidation and reporting tool, to see combined results without physically merging the books. Squeezing two legal entities into one QuickBooks company is a bad idea for tax and audit reasons, so talk to a CPA before you do anything permanent. Third-party migration and consolidation tools exist if you go that way; check what they actually move before you commit, and check Intuit's current guidance for the export steps.

Merging duplicate accounts inside one company

Sometimes the real problem is smaller: you have two chart-of-accounts entries for the same bank account, maybe because an import created a new one instead of matching the existing one. QuickBooks does let you merge accounts, by renaming one so it exactly matches the other. That merge is not reversible, so read our steps on merging accounts in QuickBooks before you rename anything.

Frequently asked questions

Can you merge two QBO files?

Not by combining them into a single file in a text editor: that produces an invalid file with two headers, and QuickBooks rejects it. Instead, import each .qbo into the same account one at a time, or build one clean file that covers the whole period before importing. Both approaches give you the same result.

Can you combine two QuickBooks Online companies?

No. Intuit does not support merging two QuickBooks Online companies into one, because each company file is separate. You pick one company to keep, export lists and transactions from the other, and import them in. For big migrations, people use a third-party service. Check Intuit's current guidance for the exact export steps.

How many QBO files can I import into QuickBooks?

There is no fixed cap on how many files you can import over time. QuickBooks Online takes one file per upload, so twelve months means twelve uploads into the same account. Import them in date order and reconcile as you go. Avoid overlapping date ranges so you do not create duplicates.

Can I open a QBO file in Excel?

A .qbo file is a tagged text file, so Excel can display it but it will look like code, not a tidy table. If you want the transactions as rows and columns, convert the statement to Excel or CSV directly. Our converter outputs Excel and CSV alongside the .qbo from the same PDF.

Why won't QuickBooks import my QBO file?

Usually the header is wrong, the file was edited and broke its tags, the date range falls outside what QuickBooks accepts, or the bank ID does not match. A cleanly generated file avoids most of this. We walk through each cause in our guide on why QuickBooks won't import a QBO file.

How far back can I import bank transactions into QuickBooks?

A live bank feed typically reaches back about 90 days. A manual .qbo import has no such window, so you can bring in years of history from PDF statements. Details and the exact limits are in our post on how far back QuickBooks can import bank transactions.

Still deciding which file type to feed QuickBooks? Our rundown of accepted bank import file formats compares QBO, CSV, and the rest, or start straight from the QBO converter or the homepage.