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. 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 inventoryand 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.

 

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.

Contact Us:

To enquire about our Quickbooks File Merge Service, please fill out the form below. We will get back to you ASAP