Merge Two QuickBooks Online Company Files Through Desktop Conversion

Last reviewed 2026-07-05 4 min read

QuickBooks Online files cannot be merged directly; our engineers explain the Desktop-format conversion path required to combine two company files into one.

QuickBooks Online does not offer a native merge function for combining two separate company files into one. The only viable path is to convert each Online file to QuickBooks Desktop format, merge them on the Desktop side, and then migrate the combined file back to QuickBooks Online. This page walks through the full workflow, the preconditions, and the points where data fidelity can break down.

Preconditions

Before starting, both QuickBooks Online files must be frozen — no new transactions, edits, or deletions in either file from the moment you begin. Any entry posted after the export will be absent from the merged result and will cause trial-balance discrepancies that are difficult to reconcile later.

You will need:

A licensed copy of QuickBooks Desktop (Premier or Enterprise), installed and activated on a single workstation.
Enough free disk space to hold both converted files plus the merged result — at least three to four times the combined file size.
A current backup of each QuickBooks Online file. Export to Desktop creates a new file; it does not modify the Online original, but having the backup is essential if you need to restart.
Single-user mode enabled in QuickBooks Desktop for every step below. Multi-user mode during import or merge operations can introduce locking errors and transaction corruption.
The same QuickBooks Desktop edition and year for both conversions. Mixing editions (for example, Premier 2021 for one file and Enterprise 2024 for the other) creates version-compatibility problems during the merge.

Step 1 — Export Each Online File to Desktop

In each QuickBooks Online file, use the Export to Desktop function (found under the Gear icon or Settings). QuickBooks Online generates a .qbo migration file and prompts you to download the QuickBooks Desktop migration tool. Run the tool on your Desktop workstation and import each file separately, saving them as distinct .qbw company files in different folders.

After each import, open the file in Desktop and press F2 to verify the Product Information screen shows the correct company name, transaction count, and trial-balance date range. Compare the trial balance in each Desktop file against the Online source as of the same cutoff date. If the numbers do not match, stop and re-export before proceeding — the discrepancy will only compound after merging.

Step 2 — Designate a Primary and Secondary File

Decide which file is the primary (the one that will receive data from the other). The primary file retains its full chart of accounts, item lists, and name lists. The secondary file's transactions will be imported into the primary, but its list elements must be mapped to existing entries in the primary chart of accounts.

Before importing, clean up the secondary file: merge duplicate customers, vendors, and accounts so that the import mapping is as clean as possible. The fewer unmatched list elements the import encounters, the fewer manual decisions you will face during mapping.

Step 3 — Export Transactions from the Secondary File

From the secondary file, use the Desktop export tools to produce an IIF (Intuit Interchange Format) or CSV transaction export. Include the full date range of historical transactions. If the secondary file is large, export in smaller date-range batches to reduce the chance of a failed import.

Step 4 — Import into the Primary File

With the primary file open in single-user mode, use the Desktop import function to bring in the secondary file's transactions. During import, map each account, customer, vendor, and item from the secondary file to the corresponding entry in the primary. Unmatched list elements will need to be added or mapped manually.

After import, run the trial balance again and confirm that the combined total equals the sum of the two individual trial balances as of the cutoff date. Run Verify Data from the File → Utilities menu to check for structural errors. If Verify reports problems, run Rebuild Data and then re-run Verify until it passes clean.

Step 5 — Migrate the Merged File Back to QuickBooks Online

Once the merged Desktop file is verified and the trial balance reconciles, use the Desktop-to-Online migration tool to upload the combined file to a new QuickBooks Online subscription. The target file size for a smooth Online import is under 1 GB, with 500 MB being ideal. If the merged file exceeds that threshold, consider supercondensing the file to remove historical transactions before a cutoff date before attempting the Online migration.

Where This Can Go Deeper Than the Workaround Reaches

This workflow assumes both files share a compatible chart-of-accounts structure and that transaction-level detail is the primary data being combined. It does not handle payroll service records, sales-tax agency setups, or bank-feeds configurations — those elements do not transfer cleanly through IIF or CSV and typically require manual reconfiguration in the final Online file. Multi-currency files add another layer of complexity, as exchange-rate tables and currency-specific accounts may not map correctly during import. In cases where the files are large, structurally complex, or span many fiscal years, a manual merge in Desktop may not fully reconcile without professional data-combination work on the underlying file structures.