← All insights
Multi-entity 25 Aug 2026 · 10 min read

How to merge two QuickBooks files, and why you usually shouldn't

By the Navigator team ·

There is no way to combine two QuickBooks files inside QuickBooks Online. Intuit's help page says so in one sentence, and the workarounds are copying lists, re-entering transactions by hand, or exporting to a new Desktop file. Desktop files can be merged by third-party services, with payroll, reconciliations, memorized transactions and sales-tax items left behind. Before you try any of it, ask which problem you are solving. Two files for one legal entity should become one, at a clean cut-off date. Two files for two legal entities should stay two, and the single picture you want comes from a reporting layer that reads both, not from a merge.

Why owners ask, and what Intuit actually allows

The question arrives in about five shapes. A bookkeeper started a fresh file because the old one was "a mess", and now there are two for the same company. A bookkeeper changed and the new one cannot get into the old file. Two LLCs are being combined legally. A business was bought and came with its own file. Or, and this is the one we see most, the owner is simply tired of opening three files to answer one question.

Only the first three are merging problems. A bought business usually stays its own entity with its own file, and the last case is a reporting problem; treating either as a merge costs money and destroys evidence you may need.

A company file is one set of books in QuickBooks: one chart of accounts, one set of customers and vendors, one bank feed, one subscription. Intuit charges per file.

Intuit's help article "Merge companies, data files or copy lists", updated 5 August 2026, is short. The ability to merge two company data files into one company is currently not available in QuickBooks Online, on every plan from Simple Start to Advanced. Instead, you can export lists (customers, vendors, chart of accounts, products) to Excel and import them into another company. You can enter transactions again by hand. Or you can export a QuickBooks Online company, but only into a new QuickBooks Desktop file.

There is a second rule that shapes everything below. A new QuickBooks Online company can import data only within the first 60 days after it is created. Past 60 days, the only ways in are journal entries and manual entry.

An Intuit employee gave the same answer on a December 2023 community thread from an accounting firm that had merged with another firm and wanted one file: merging is unavailable, and the suggestions were a third-party consolidation tool, manual entry, or accountant access to both. The article's August 2026 update date says Intuit has looked at the question recently and left the answer as it is.

The Desktop route and what it leaves behind

Because Online exports to Desktop, a route exists: export both companies to Desktop, pay a service to merge the two Desktop files, and bring the result back. Dancing Numbers, a data migration firm, lists in a guide updated in June 2025 what a Desktop merge cannot carry across: payroll checks, memorized transactions, bank reconciliations, negative inventory, sales tax groups and items, customer notes and custom customer fields. Every reconciliation you have ever done is gone from the merged file.

Forums recommend exactly this. We think it is the worst of the available routes for an Online company. The import back is only possible into a brand-new company inside its first 60 days, which means a new subscription, a new bank connection and new user and app connections, and the merged file arrives without its reconciliations. You pay twice to end up with less evidence than you started with.

This is the case where you should end up with one file, and the method is a cut-off, not a merge.

A cut-off date is the day on which one file stops being the record and the other starts. Everything dated on or before it lives in the old file. Everything after it lives in the survivor.

The old file had 1,340 unreconciled transactions, so on 1 March 2026 the new bookkeeper at a landscaping company with one EIN opened a fresh one. The old bookkeeper had kept the first file since January 2024 and stayed until April, so for two months both files were in use. The survivor is the new file. The cut-off is 28 February 2026.

An opening balance journal entry brings the balance sheet of the old file into the survivor as of the cut-off. The bookkeeper runs a trial balance in the old file dated 28 February 2026 and posts one entry in the new file on the same date: checking $38,210, fixed assets $112,600 less $41,900 of accumulated depreciation, the truck loan at $56,730, the line of credit at $25,000, and equity as the figure that makes it balance. Receivables and payables are left out of that entry and entered as the individual open items instead, 19 unpaid invoices totaling $47,300 and 7 unpaid bills totaling $12,850, each with its original date, so that the aging report works and March payments apply to the right invoice.

The two months of overlap are handled by the bank. The new file's March and April reconciliations prove it has every transaction the bank saw, and whatever the old file recorded for those months is not used. Then the old file is frozen: the general ledger, the trial balance for each year and the reconciliation reports are exported to PDF and Excel and kept with the tax returns, the old bookkeeper's access is removed, and the CPA is told which file is the record from which date.

This is a day or two of a bookkeeper's time if the old file's trial balance is trustworthy. If it is not, you are into a cleanup first, which NerdWallet's guide puts at $1,000 and up and which we describe in what a QuickBooks cleanup costs and what it covers.

Do not merge them. Each entity files its own tax return, built from that entity's books. Each has its own bank account, and usually its own loan and sales tax registration. One may have a partner the other does not, or a lender whose covenant reads that entity's statements alone. A merged file cannot be unmerged, so if the entities are ever sold or audited one at a time, the books that would have answered the question no longer exist.

The choice between separate files and classes is a real one for locations inside a single entity, and we walk through it in separate QuickBooks files or classes for multiple LLCs. For separate entities the tax return makes that choice for you, the file boundary is doing legal work, and the picture across them has to come from somewhere else.

If two LLCs are actually merging, one survives in law and the other is absorbed, and the books follow the law. The survivor's file continues without interruption. The absorbed company's balance sheet arrives in the survivor's file by journal entry on the merger date, with the CPA deciding how the equity and any intercompany balances are treated, and the absorbed company's file is frozen the same way as in Route A.

What you do not do is import the absorbed company's history. Its 2024 and 2025 transactions belong to an entity that filed its own returns for those years, and they stay in the frozen file where an examiner or a buyer can find them. Any due-to and due-from balances between the two need to cancel on the merger date, and how intercompany transactions work is worth reading before that entry is posted.

What a merge costs in money and in evidence

The money is the bookkeeper's hours, the cleanup if one is needed, a second subscription until the exports are done, and a paid merge service on the Desktop route, whose price we could not read and will not guess at.

The evidence costs more. It is the cost nobody puts on the estimate. A merged file has lost its reconciliation history, so it cannot show a lender or a buyer that its bank balance was ever tied to the bank. It has lost the audit trail of who entered what and when. And it has lost the boundary between two entities' transactions, which is the single thing an examiner or a buyer's accountant most wants to see. A company with a clean cut-off and a frozen old file can produce all of that years later.

The question behind the question

Most owners who ask us how to merge files do not want one file. They want one number: what the three companies made last month, or the cash across all of them. Every such question has an answer that leaves the files alone.

The manual answer is to export the P&L from each file, stack them in a spreadsheet, and cancel the transactions between the companies by hand; we set it out in how to consolidate multiple companies in QuickBooks Online. Intuit's own tool for this is Spreadsheet Sync, which comes with Advanced and stacks several companies' reports into one sheet as long as the account names match exactly, and does nothing about intercompany; its limits are in what Spreadsheet Sync does and where it stops. The balance sheet side is in how to build a consolidated balance sheet from QuickBooks Online.

Navigator connects to each of your QuickBooks Online files read-only and shows the per-entity and consolidated view on the base plan, and on Pro cancels the intercompany transactions so the consolidated figures are not overstated. Nothing in any file is merged or changed, and each figure opens to the entry it came from. Details at navigatorhq.ai.

None of this fixes a file that is wrong. A consolidated figure from three files, one of them six weeks behind and one with an unreconciled bank account, has two holes in it, and a reporting layer can show you the holes but cannot fill them. That remains the bookkeeper's job, whether there is one file or three.

Questions owners ask

Can you merge two QuickBooks Online companies?

No. Intuit's help article, updated 5 August 2026, says the ability to merge two company data files into one is not available in QuickBooks Online, on any plan from Simple Start to Advanced. You can export lists to Excel and import them into another company, re-enter transactions by hand, or export a company to a new QuickBooks Desktop file. There is no button.

How do I combine two QuickBooks Desktop files?

Desktop Enterprise with the Accountant edition can combine reports from several files, which is reporting, not a merge. Third-party services will merge two Desktop files into one, but Dancing Numbers' guide lists what does not come across: payroll checks, memorized transactions, bank reconciliations, sales tax groups and items, negative inventory, customer notes and custom fields. Reconciliations have to be redone.

Can I import old data into a new QuickBooks Online company after 60 days?

Not through Intuit's import tool. The help article says a new QuickBooks Online company can import data only within the first 60 days after it is created. After that you are entering transactions by hand, bringing balances in by journal entry, or using a third-party migration tool. This is why the choice of which file survives should be made early.

Should I merge my two LLCs into one QuickBooks file?

Only if you have legally merged the LLCs. Two entities file separate returns, hold separate bank accounts, and may have different partners or lenders, and a merged file cannot be unmerged. Keep one file per legal entity. If the reason you want one file is to see both businesses at once, that is a reporting problem, and it has answers that leave both files intact.

What is the alternative to merging QuickBooks files?

For a combined view, a reporting layer that reads each file and adds them up, with the transactions between your companies canceled out. Intuit's own answer in a 2023 community thread was a third-party consolidation tool or an accountant's access. Spreadsheet Sync on Advanced can stack matching charts of accounts into one sheet. None of these touches the underlying files.

If the goal is one picture across companies rather than one file, start with how to consolidate multiple companies in QuickBooks Online. The structural choice that leads to two files in the first place is in separate QuickBooks files or classes for multiple LLCs, and the balance sheet half of the combined view is in building a consolidated balance sheet from QuickBooks Online.

If you would rather see all of your files together without merging any of them, the trial connects each one read-only in about fifteen minutes and needs no card: navigatorhq.ai.

Navigator Insights by email

Get the next post by email.

One email when a new post goes up: cash, lenders, running several companies and AI. Unsubscribe in one click.

By subscribing you agree to our Privacy Policy.

Published . Last updated . Reviewed by a CFO on the Navigator team.

See every company you own in one place. Every morning.

Navigator connects to QuickBooks Online read-only, consolidates your entities, and answers the questions in these posts on your own numbers. Thirty days free, no card.

Start free trial Run the free Health Check