How to Merge Duplicate Accounts, Customers, and Vendors in QuickBooks Online

QuickBooks is an accounting software which is used by businesses of all classes globally. In QuickBooks, once the accounts are […]

Voiced by Amazon Polly

QuickBooks is an accounting software which is used by businesses of all classes globally. In QuickBooks, once the accounts are merged, there is no way to discard the applied changes, so please do not forget that merging accounts is permanent. To put it simply, you need to be certain. The accounts merging process works best to cater to the unique needs of the organization. However, only two accounts can be merged simultaneously, and for that accounts should be identical to each other. Know how to Merge Duplicate Accounts, Customers, and Vendors in QuickBooks Online .

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

In most of the cases, you can modify the account type to match the new account. The accounts you are moving should also belong to the same parent or sublevel. For example, if one account is of a parent and the other account is a subaccount, you cannot, or you are not able to merge these accounts till the time you change their place to match. In this module we will provide all the related information important for accounts merger. So, read the article till the end.

Users can merge two bank accounts without any hassle in QuickBooks, however, kindly ensure that both of the accounts are the same type of accounts. Furthermore, both the accounts should be on the same sublevel or parent level.

We can understand it with the help of a quick example like if there is a parent account and another one is a subaccount or sublevel then you cannot merge them together as the details will not be similar/mismatched. If you are seeking assistance to learn how to merge two bank accounts in QuickBooks, our team of experts will be happy to assist you. By merging the two accounts, you can move all the financial reports, accounting information, credits, and accounting entries automatically to a unified account.

What Happens When You Merge Accounts in QuickBooks?

All transactions from the deleted account will be transferred to the retained account once two QuickBooks accounts have been merged. At that point, the deleted account will no longer be present in your QuickBooks Online file.

Remember that once a merge has been finished, it cannot be undo. Therefore, before merging any accounts, it is important that you take the time to carefully review all the data.

We advise you to export your QuickBooks Online data to Excel before merging to avoid any data loss.

Can You Merge Two Accounts in QuickBooks?

Yes, QuickBooks Online allows you to merge two accounts. In QuickBooks Online, merging accounts is a two-step process. You must first choose the accounts you want to merge. In the second step, you must specify which accounts you want to keep and which accounts you want to delete.

Once you have done that, QuickBooks will combine the data from both accounts and delete the duplicate account. Although this procedure is very simple, it’s important to remember that after a merge has been finished, it cannot be undone. Therefore, before merging any accounts, it is important that you take the time to carefully review all the data.

We advise you to export your QuickBooks data before merging any accounts in order to avoid data loss. In case something goes wrong, you will have a backup of all the data if you do it that way.

When would You Recommend Merging Accounts in QuickBooks?

In QuickBooks, there are few situations where merging accounts can make sense

  • You have multiple accounts for the same vendor or customer.
  • You must integrate the data from two different QuickBooks files.
  • You wish to clear up your data after unintentionally creating duplicate accounts.

The easiest way to resolve any of these situations is by merging your accounts in QuickBooks.

How to Merge Duplicate Accounts in QuickBooks Online?

As mentioned above, that merging accounts is permanent and there is no such way to undo option.. QuickBooks uses some accounts as the default for certain functions. These, like accounts connected to online banking, cannot be merged or deleted.

  • You are required to save the reports first if you are merging accounts which has the reconciliation reports.
  • Firstly you are required to navigate to the Settings⚙ and after that choose the Chart of Accounts.
  • After that you need to search the account which you want to keep and now choose the dropdown▼ in the Action column and then Edit. Also, you need to know that if you see the New Category window instead of the Account window, you are creating a subaccount. If you are required to create a new parent account, then you need to move to the accountant view.
  • Now, at this point you are required to know that the Account Type, Name, and Detail Type of the account. These must be the same between the accounts you are required to merge.
  • If it is, note the parent account it is tied to and verify if the Is subaccount option is marked.

Once you get all the information about the account that are required to keep, you need to handle the duplicate. Here are few steps given below:

  • Firstly, you are required to navigate to the Chart of Accounts.
  • After that, search the duplicate account which you do not wish to keep. After that, in the action column choose the dropdown ▼ and then Edit.
  • You are required to change the Name and Detail Type, so the duplicate accounts information matches the account you wish to keep exactly. You need to know that if you need to mark Is subaccount:
    • You are required to ensure that you don’t have any Is subaccount if you’re merging two parent accounts.
    • You are required to ensure that they both have the same parent account if you’re merging two subaccounts.
    • You are required to ensure that you need to uncheck the Is subaccount option, so it becomes a parent account if only one is a subaccount.
  • Select the Save option and after that click on Yes to confirm once you are done with the all above-mentioned steps.

After the accounts are merged, so you end up with one. QuickBooks moves past entries from the duplicate to the account you wish to keep with you.

What is the Procedure to Merge the Duplicate Customers?

For merging customer profiles, you are advised to delete one account manually. This will help you to transfer the data of that one account to the customer profile you want to hold.

See more information: How to Merge Two Customers in QuickBooks

How to Merge Duplicate Vendors in QuickBooks Online?

Once the accounts are merged there is no way to make the change discard so always remember that merging accounts is permanent.

  • Firstly, you need to navigate to the Get paid & pay and choose the Vendors.
  • After that, you need to find and open the vendor profile you wish to keep. After that, choose the Edit option.
  • Now, make the note of the Company Name and the Display Name.
  • Once it’s done, now it’s time to go back to the Vendors tab and find and open the vendor you do not need to keep and after that choose the Edit option.
  • At this step, you are required to modify the display name to make it same to the vendor you need to merge with.
  • Now, in the last step, choose Save, then click on Yes.
  • After the accounts are merged, so you end up with one. QuickBooks moves past transactions from the duplicate to the vendor you wish to keep.

To merge the accounts is the much faster solution to get the issue resolved.

More Useful info: How to Merge Vendors in QuickBooks Desktop?

How to Merge Chart of Accounts in QuickBooks

Follow the below mentioned instruction for merge chart of accounts in QuickBooks:

  • Firstly, navigate to the Chart of Accounts and click right on the account you are required to keep and after that click on the Edit option.
  • Now, you need to Copy the Name of the account you need to keep.
  • After that, move back to the chart of account and right-click on the account you wish to Merge with the Account you are keeping.
  • In the next step, you need to Paste the Name of the account you are keeping over the name of the account you wish to get rid of and now click on Save and Close.
  • There will be a message will display in the QuickBooks: “This name is already being used“. Would you like to merge them?
  • Once you are Done with the all above steps you need to hit the Yes options and the accounts will be merged.

Here are few critical points which you are required to Consider Before Merging Duplicate Accounts in QuickBooks:

There are a few Account Types which cannot be changed, or you cannot merge them with other accounts. This happens due to various accounts are required by the system, and you cannot remove or merge them. However, if you are required to merge such an account, you might need to find the error for that particular account because it may be reserved by online banking features.

  • Uncategorized Income
  • Default Service Tax accounts
  • Default Service Income account
  • TDS Payable
  • Default PAYG/PAYE accounts
  • Retained Earnings
  • Undeposited Funds
  • TDS Receivable
  • Opening Balance Equity
  • Uncategorized Expense

These are the accounts which are required by the system or online banking features.

How do I Merge Transactions in QuickBooks?

In QuickBooks, you can combine transactions that are identical. This is useful if you mistakenly entered the same transaction twice or if the same product is the subject of two different transactions.

To Merge Transactions in QuickBooks:

  • Click on the Gear icon and then you have to choose Tools.
  • Choose Merge Customers, Vendors, or Items under Combine Data.
  • Select the data type you want to merge, then click Next.
  • Click Next after selecting the accounts you want to merge.
  • After mapping the fields on the two accounts you have to click Merge.

QuickBooks gives you the facility to merge accounts so that it becomes easy for you to see the details in one account. With the help of this article, we hope you understood how you can merge two bank accounts in QuickBooks. Suppliers, and others in QuickBooks. If you still have any query or issue, please do not hesitate to connect with our Dancing Numbers experts via LIVE CHAT.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Call Now+1-800-596-0806
Top