Skip to content

How to Merge Customers in QuickBooks

Merge Customers in QuickBooks

When it comes to manage the accounts of customers of your business organization, QuickBooks is one of the most advanced and useful accounting tools. By using this accounting tool, it is very easy to add the complete details of any customer to your accounts. This business tool gives you option to manage the business accounts of all customers at one time.

But there can be some similar customers and you may want to make the management easy by merging them in your QuickBooks. If you are also looking to get this option of merging customers in your QuickBooks, it will be very helpful to manage the accounts of similar customers in your accounting tool.

If you are choosing the process of merging similar customers in your QuickBooks, it will delete the account of one customer and will assign all the data and information of that customer to another customer’s account. Before deleting the customer’s account for merging, it is also important that you delete the statements of that customer first. If you are merging the accounts of similar customers, you need to keep in mind that you will not be able to reverse this process and the process of merging is always permanent in QuickBooks.

How to Restore QuickBook 2015 on Desktop without any Error

In QuickBooks, combining customer records necessitates careful preparation. Once you’ve determined which records you want to combine, mark one as the “final” record and the rest as records that will be combined. Prior to consolidating customer records if you track jobs together with customers, you must merge customers in QuickBooks and their work records. You must keep distinct records when a single person or business fills multiple roles in QuickBooks, such as vendor and customer. Make a backup of your QuickBooks database before doing any record consolidation because there is no “undo” tool available once you’ve merged customer records.

Basic steps to combine similar accounts in QuickBooks

Remember that account mergers are irreversible. This cannot be undone later. For several functions, QuickBooks uses a set of default accounts. These cannot be combined or removed, just like accounts linked to Internet banking.

Save those reports first if you’re merging accounts that include reconciliation reports. The transactions continue to be reconciled and remain on the consolidated account.

  1. Choose the Chart of Accounts by going to Settings.
  2. The account you want to keep can be found. Then choose Edit from the dropdown menu in the Action column.
  3. Take note of the account’s Account Type, Name, and Detail Type.
  4. Verify whether the Is sub-account checkbox is selected. Note the parent account to which it is connected if it is.

For the account you choose to keep, you have all the information you require. Let’s deal with the duplication now:

  1. Visit the Chart of Accounts once more.
  2. Locate the duplicate account that you won’t be maintaining. Then choose Edit from the dropdown menu in the Action column.
  3. The information on the duplicate account should exactly match that of the account you want to preserve, so change the Name and Detail Type. If you must mark Is sub-account, bear the following in mind:
    Note: Make sure there are no sub-accounts in the two parent accounts you are merging.
    • Make sure the two sub-accounts you’re combining have the same parent account.
    • Uncheck the Is sub-account box to make the account a parent account if only one is a sub-account.
    • When prepared, click Save and confirm 

Ways to track the transactions in QuickBooks

Add a new customer.

You may track your clients’ future transactions in QuickBooks Online by adding them to the customer list.

1. When connecting for the first time:

  1. Click on Customers.
  2. Select manual customer addition
  3. Enter the details about your client.
  4. Choose Save.

2. To add more clients:

Maintaining organization and keeping track of your clients is crucial as your company expands. Customers can be added to transactions or invoices in QuickBooks Online by adding their profiles.

Here’s how to add clients and maintain the accuracy of your client list.

  1. Click on Customers.
  2. Choose a New client.
  3. Enter the details of your client.
  4. Choose Save.

How to Remove a Payment or Deposit Against a Customer Before Merging

  1. First, open QuickBooks and select List from the top menu bar, followed by Chart of Accounts.
  2. To delete a specific payment, you must first double-click the account and then the deposit.
  3. At this point, you first click on edit and then line deletion.
  4. After erasing the deposits and payments made to the customer, you can merge the customers by following the steps below.

How to merge customers in QuickBooks?

The first thing you need to know is that, as we just covered, merging customers who have payments or deposits recorded against them in QuickBooks is not possible. Therefore, before merging them, you must first erase the payment associated with them. The invoice against which you made the payment will reopen when you delete it, which is something we’ll deal with later. 

How to merge customers in quickbooks?

To merge customers in quickbooks, follow the instructions below;

  1. Open QuickBooks and go to the “Customers” menu.
  2. Select “Customer Center.”
  3. Find the two customers you want to merge and select one of them. Right-click on that customer and select “Edit Customer.”
  4. Make a note of the customer’s name, address, phone number, and other relevant information.
  5. Close the Edit Customer window.
  6. Go back to the Customer Center and select the other customer you want to merge.
  7. Right-click on that customer and select “Edit Customer.”
  8. Replace the customer’s name with the name of the first customer you selected. Also, add any missing information from the first customer’s record.
  9. Save the changes to the customer’s record.
  10. A window will appear that asks if you want to merge the two customers. Click “Yes” to confirm.
  11. In the Merge Customers window, select the first customer’s name from the drop-down menu.
  12. Select the second customer’s name from the drop-down menu.
  13. Select the information that you want to keep from each customer’s record.
  14. Click “Merge.”

How to merge customers in quickbooks desktop?

To merge customers in quickbooks desktop, you need to;

  1. Make a backup of your QuickBooks company file before proceeding.
  2. Open QuickBooks and go to the “Customers” menu.
  3. Select “Customer Center.”
  4. Find the two customers you want to merge and select one of them. Right-click on that customer and select “Edit Customer.”
  5. Make a note of the customer’s name, address, phone number, and other relevant information.
  6. Close the Edit Customer window.
  7. Go back to the Customer Center and select the other customer you want to merge.
  8. Right-click on that customer and select “Edit Customer.”
  9. Replace the customer’s name with the name of the first customer you selected.
  10. Save the changes to the customer’s record.
  11. A window will appear that asks if you want to merge the two customers. Click “Yes” to confirm.
  12. In the Merge Customers window, select the first customer’s name from the drop-down menu.
  13. Select the second customer’s name from the drop-down menu.
  14. Select the information that you want to keep from each customer’s record.
  15. Click “Merge.”

Merge duplicate customers:

You can merge the profiles of duplicate customers. The data from the deleted profile is transferred to the profile you want to maintain.

  1. Click on Customers.
  2. The customer profile you want to delete is selected and opened.
  3. Choose Edit.
  4. Enter the name of the customer profile you want to preserve in the Display name as section. The names must completely match.
  5. Choose Save.
  6. Select Yes when prompted if you wish to combine the two profiles.

Note: Make sure that neither client has any sub-clients. If they do, you must first convert their sub-customers to regular clients.

Conclusion

Hope so, that you can successfully merge customers in QuickBooks. But if you do run into problems, connect to the expert team.


FAQs


Could you provide a step-by-step explanation of how to merge two QuickBooks company files in QuickBooks Enterprise?

How to import customers from an Excel file in QuickBooks?

What are the steps to add a sub-customer to QuickBooks?

Speak to A Specialist about QuickBooks Software

Headache🥺. Huh, Save time & money with QuickBooks Support 24×7 @ +1/, we provide assistance to those who face problems while using QuickBooks (Support all U.S. & Canada Editions)

--- Support - We provide solutions for the following QuickBooks (Pro, Premier, Accountant, Enterprise, Payroll, Cloud) ---

  • Error Support
  • Data Import
  • Data Conversion
  • Payment Solutions
  • Upgradation
  • Payroll Support
  • Data Export
  • Software Integration
  • QuickBooks Printer Support
  • Complete QuickBooks Solutions
  • Tax-Related Issues
  • Data Damage Recovery
  • Installation, Activation Help
  • QuickBooks Windows Support


Disclaimer : We are a third party agency working on providing authentic support and full fledged services for for accounting software QuickBooks 2018 version. It is one of… Read more

Phone

+1800-892-1352