QB File Merge Service

How to merge two or more Quickbooks company files into a single company file?

  • No fix, no fee
  • Free evaluation
  • PC and Mac, all editions

No fix, no fee

If we cannot resolve your issue there is no charge at all. That applies to every service on this site.

Free evaluation first

We look at the file before you pay anything, then give you a firm fixed quote. Nothing starts until you accept it.

Every version

Every version from QuickBooks 1 for DOS through the current Pro, Premier, Accountant and Enterprise releases.

US, UK, Canada, AU, NZ

We work with all five regional editions of QuickBooks, on both PC and Mac, and convert between them.

The track record

Twenty years of files
brought back to life.

95%+recovery success rate
20+years with QuickBooks files
1000sof businesses served worldwide
5regional editions, PC and Mac
Merging Quickbooks Company Files

Do you need to merge two or more Quickbooks company files into a single company file? We offer an industry-standard solution to combine data from multiple company files into a single company file. The results are guaranteed. We can additionally add classes to all transactions in each company file which can be used for reporting purposes. The merged file is audited to ensure all transactions were merged correctly.

To combine multiple company data files, the chart of accounts in both files cannot have the same account name with different types. For example, if one company file has an account with name 'Accounts Receivable' of type AccountsReceivable, the second company cannot have an account name with the name 'Accounts Receivable' of another type. To resolve this issue, rename one of the accounts to 'Accounts Receivable1'.

Also, only one company file can have Payroll transactions. If both company files have payroll, the payroll transactions cannot be merged. Other than that, all transactions types can be merged. Any number of files can be merged into a single Quickbooks data file or converted to Quickbooks Online.

Why use a File Merge Service?

A file merge service can be used in any of the following scanarios:

  • You used a local data file to enter data into and not the networked data file.
  • You entered data into two different data files and want to combine the files.
  • Consolidating multiple Quickbooks data files into a single file after adding a class to each data file.
  • Merging data files prior to uploading to Quickbooks Online.
  • Amalgamating companies and continuing operations as a single entity.


Can Quickbooks Online (QBO) Files be Merged?

To merge two QBO Online companies, each QBO dataset will need to be converted to a Desktop version of Quickbooks first (US versions only). The desktop files are merged and will need to be uploaded to a new QBO company file.
Can the merged desktop files be re-uploaded back to the QBO account? Yes, the merged desktop file can be uploaded back to the QBO account but if your account is older than than 60 days, you will need to contact Inuit to get permission to upload the merged data back to the original QBO account. If not, you will need to create a new QBO account.

What data cannot be merged?

  • Payroll checks are merged as regular checks and won't appear in payroll reports or W2 calculations. This is because Quickbooks does not allow payroll checks to be transferred from one file to another. Also time activities are not merged.
  • Bank Reconciliations cannot be merged because Quickbooks does not support the transfer of Bank Reconciliations. You will need to do a single reconciliation for each bank acount after the merge.
  • Data files with negative inventory and assembly builds do not merge correctly because there is insufficient quantity on hand to build the assemblies and they transfer over as pending builds.
  • Data files with sales tax items and sales tax groups that were modified after their initial use may not be transferred correctly since Quickbooks does not store historical rate changes.
  • Data files with group items that were modified after their initial use may not be transferred correctly since Quickbooks does not store historical group modification data.
  • Templates cannot be transferred from secondary files to the primary file as Quickbooks does not support the trasnfer of templates. (However, you can manually export templates and import them into the merged file after the merge).
  • Attachments are not transferred because Quickbooks does not support the transfer of attachments.
  • Customer Notes and To-Do lists are NOT merged.
  • Custom fields in transactions are NOT merged from the secondary file(s) to the primary file.
  • Memorized Transaction definitions from secondary files are not transferred, and will need to be memorized again.
  • Memorized Reports from secondary files are not transferred, and will need to be memorized again.
  • Budgets/Forecasts from secondary files are not transferred, and will need to be memorized again.
  • Users from secondary files are not transferred and will need to be re-entered.


Why reports may differ after a merge?

Financial reports in the merged file may be different from the source files i.e. you cannot add two reports from the original files together and expect them to match the same report in the merged file for any merge that involves files with items. The accounts on items in a secondary file can be changed after they are used without changing prior transactions. When they are imported they all post to the account currently selected on the item. Items can also have the same name in two different files but post to different accounts.

How Lists are Merged?

  • ALL Lists (customers, vendors, accounts, items, employees, other names) with the same name are merged. For example, if the Primary file has a Bank Account with the name 'Chase Bank' and the Secondary file also has a Bank Account with the name 'Chase Bank', the merged file will have a single Bank Account with the name 'Chase Bank' regardless of if the account numbers were different.
  • Lists with different names are retained in the merged file. For example, if the Primary file has a Bank Account with the name 'Chase Bank #1' and the Secondary file has a Bank Account with the name 'Chase Bank #2', the merged file will have both Bank accounts regardless of if the account numbers were the same.
  • If a list name in the secondary file clashes with a list name in the primary file, the name in the secondary file will be made unique for the merge. For example, if there was a customer in the Primary file with the name 'ACME Inc', and a vendor in the secondary file with the name 'ACME Inc', the name from the secondary file will be renamed to 'ACME Inc-V' for the merge.


Assigning Classes

Classes can be assigned to the primary and secondary files prior to the merge. You can then run financials (P&L by class, Balance Sheet by class, etc.) in the merged file, and the reports will exactly match the original files. Note that if classes are added, all transactions in each file will be overwritten by a single class for each data file. For example, all transactions in the Primary file will be assigned a class 'PRIMARY', transactions in secondary file 1 will be 'SECONDARY 1', etc.

How it works?

The actual file merge process is simple. You upload backup copies of the Quickbooks files you want to merge. We merge the files and send you a secure download link to download the merged file. This service works with all international versions of Quickbooks including the US, UK, Canadian, and Australian editions. Weekend service is available.



What you get

Every service.
The same promises.

Free evaluation first.

We look at your file before you pay anything, then give you a firm fixed quote. Nothing starts until you accept it, so there are no surprises and no diagnosis fee.

No fix, no fee.

Every service is guaranteed. If we cannot resolve your issue, there is no charge - you pay nothing at all.

Data-level engineering.

When Verify, Rebuild and File Doctor loop or fail, the file needs engineering work rather than another pass of the built-in tools. That is what we do.

Every version.

Every version from QuickBooks 1 for DOS through the current Pro, Premier, Accountant and Enterprise releases.

Private, then deleted.

Your company file is used only for the work you asked for, never shared, and deleted14 days after the job. Immediate deletion on request.

How it works

Send the file. Get a quote. Approve the work.

Send us the file

Tell us what went wrong and upload your company file to our secure server. There is no charge to look at it.

We evaluate it

Our engineers evaluate the file, then give you a firm fixed quote before any work starts.

You approve, we start the service

Nothing proceeds until you accept the quote. If we cannot resolve the issue, you pay nothing.

No fix. No fee.

Every service is guaranteed. If we cannot resolve your issue, there is no charge - you pay nothing at all.

Get a free evaluation
Get started

Tell us about your file.

There is no charge to look at your file. Send the details and we will confirm the expected result for your specific file before you pay anything.

Questions

Common questions

How much smaller will my file get after a condense or size reduction?

It depends on what the file holds - the evaluation tells you the expected result for your specific file before you commit.

Does condensing delete my data?

Condensing summarises closed history to shrink the working file. You keep an untouched copy of the original, and the evaluation spells out exactly what will be summarised.

Can you merge two company files into one?

Yes. We merge two or more files into a single company file, and the merged result is verified against reports from both sources.

I hit the list limit. What are my options?

List reduction removes inactive customers, vendors and items to bring you back under the limit - without losing the transaction history that references them.

What does it cost to find out if my file can be fixed?

Nothing. Send us the file, we evaluate it, and you get a firm fixed quote before any work starts. There is no diagnosis fee.

What if you cannot do it?

Then you pay nothing at all. Every service on this site carries the same guarantee.

Is my data kept private?

Yes. Your company file is used only to carry out the work you asked for, is never shared, and is deleted after the job. Immediate deletion on request.

Not sure where to start?

Send us the file and we will tell you what can be recovered. We resolve your issue, or you pay nothing.