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 in 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.
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.
- Choose the Chart of Accounts by going to Settings.
- The account you want to keep can be found. Then choose Edit from the dropdown menu in the Action column.
- Take note of the account’s Account Type, Name, and Detail Type.
- 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:
- Visit the Chart of Accounts once more.
- Locate the duplicate account that you won’t be maintaining. Then choose Edit from the dropdown menu in the Action column.
- 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:
- Click on Customers.
- Select manual customer addition
- Enter the details about your client.
- 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.
- Click on Customers.
- Choose a New client.
- Enter the details of your client.
- Choose Save.
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.
1. 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.
- Click on Customers.
- The customer profile you want to delete is selected and opened.
- Choose Edit.
- Enter the name of the customer profile you want to preserve in the Display name as section. The names must completely match.
- Choose Save.
- 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.
How to Remove a Payment or Deposit Against a Customer Prior to Merging
- First, open QuickBooks and select List from the top menu bar, followed by Chart of Accounts.
- In order to delete a specific payment, you must first double-click the account and then the deposit.
- At this point, you first click on edit and then line deletion.
- After erasing the deposits and payments made to the customer, you can merge the customers by following the steps below.
Conclusion
Hope so, that you can successfully merge customers in QuickBooks. But if you do run into problems, connect to the expert team.
Frequently Asked Questions
Could you provide a step-by-step explanation on how to merge two QuickBooks company files in QuickBooks Enterprise?
You must first click on the Reports menu from the QuickBooks main menu. Click on the combined reports from various firms link to bring up the sub-menu list, then select Add files. You must repeat the process for more files. Next, you must search for another company file and click on open. Now navigate to the part where you can pick the reports for combining, specify a date range, and select a reported basis. Then look for the option to consolidate reports in Excel and click it. Once you do this, an Excel sheet displaying the merged data will open.
How to import customers from an Excel file in QuickBooks?
You can import all of your client data from a spreadsheet into QuickBooks Online at once. Follow the procedures listed below to import your completed Excel sheet into QuickBooks Online.
- Click on Customers.
- Choose Import customers from the dropdown menu next to New customers.
- Choose Browse.
- Select Next after completing the steps to upload your Excel file.
- Select Next after mapping the fields in your file to the fields in QuickBooks Online.
- Choose Import after selecting the clients to be imported.
What are the steps to add a sub-customer to QuickBooks?
Under your top-level customers, you can build sub-customers (also known as parent customers). If you want to track specific clients who are also a part of a group or a sizable organization, this is helpful.
While parent accounts can only have sub-customers up to four layers deep, you are allowed an infinite number of sub-customers. Add the parent customer first, if you haven’t already, as a new client. This is how to add each sub-customer:
- Click on Customers.
- Choose a New client.
- Then select the option add sub-customer.
- Enter the details for the sub-client.
- Choose the parent account from the Enter Parent Customer option.
- Choose Save.
How to merge customers in quickbooks?
To merge customers in quickbooks, follow the instructions below;
- Open QuickBooks and go to the “Customers” menu.
- Select “Customer Center.”
- Find the two customers you want to merge and select one of them. Right-click on that customer and select “Edit Customer.”
- Make a note of the customer’s name, address, phone number, and other relevant information.
- Close the Edit Customer window.
- Go back to the Customer Center and select the other customer you want to merge.
- Right-click on that customer and select “Edit Customer.”
- 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.
- Save the changes to the customer’s record.
- A window will appear that asks if you want to merge the two customers. Click “Yes” to confirm.
- In the Merge Customers window, select the first customer’s name from the drop-down menu.
- Select the second customer’s name from the drop-down menu.
- Select the information that you want to keep from each customer’s record.
- Click “Merge.”
How to merge customers in quickbooks desktop?
To merge customers in quickbooks desktop, you need to;
- Make a backup of your QuickBooks company file before proceeding.
- Open QuickBooks and go to the “Customers” menu.
- Select “Customer Center.”
- Find the two customers you want to merge and select one of them. Right-click on that customer and select “Edit Customer.”
- Make a note of the customer’s name, address, phone number, and other relevant information.
- Close the Edit Customer window.
- Go back to the Customer Center and select the other customer you want to merge.
- Right-click on that customer and select “Edit Customer.”
- Replace the customer’s name with the name of the first customer you selected.
- Save the changes to the customer’s record.
- A window will appear that asks if you want to merge the two customers. Click “Yes” to confirm.
- In the Merge Customers window, select the first customer’s name from the drop-down menu.
- Select the second customer’s name from the drop-down menu.
- Select the information that you want to keep from each customer’s record.
- Click “Merge.”
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