In QuickBooks Online, you can easily merge accounts, customers, or suppliers. This is helpful if you want to have a single representation in your Chart of Accounts or in your financial reports.
|Warning: The merging process is not reversible. It is permanent and cannot be undone at a later point.|
Some accounts cannot be changed or cannot be merged into an existing account because of their Type. The Uncategorised Asset is one example of this kind of account. If a user, who has Online Banking, tries to change the Type to a different one, this warning will appear: "Please correct the following errors: You can't change the type of this account because it is reserved for the Online Banking feature."
There are other accounts that you cannot delete or merge because they are needed by the system. They are as follows:
- Open Balance Equity
- Retained Earnings
- Undeposited Funds
- Uncategorised Income
- Uncategorised Expense
- TDS Payable
- TDS Receivable
- Default Service Tax accounts
- Default GST/VAT accounts
- Default PAYG/PAYE accounts
- Default CST accounts
- Default Service Income account
- Default tax accounts created when a Custom Tax Agency is created
|Note: If one of the accounts you are merging has a symbol in the name, an error message will appear during the process. Remove the symbol and retry merging.|
Merging accounts with reconciliation reports
If you are merging bank accounts that have reconciliation reports, the reports will be deleted from the account that has been merged but the reconcile status (R) will remain on the merged transactions.
To avoid data loss, we highly recommend saving reconciled reports before merging.
To merge two accounts:
- Go to Settings ⚙️.
- Under Your Company, select Chart of Accounts.
- Go to the account you want to keep and select Edit from the drop-down in the Action column.
- Take note of the Name and Detail Type, and check if the Is subaccount option is marked. If it is marked, remember the parent account associated.
- Select Cancel to return to the Chart of Accounts.
- Go to the account which you don't want to use, and select Edit from the drop-down in the Action column.
- Change the Name and Detail Type, and mark Is subaccount as appropriate. Remember the following regarding the Is subaccount option:
- You won't be able to merge parent accounts that has existing sub-accounts.
- If you are merging sub-accounts, make sure they are associated with the same parent account.
- If only one is a sub-account, make it a parent account by deselecting the Is subaccount option.
- Select Save, then choose Yes to confirm that you want to merge the two accounts.
Here's how to merge customers:
- Select Sales, then select Customers.
- Select the name of the customer you don’t want to use, then select Edit. (Note: Make sure that the customers you want to merge are at the same level. You can mark the Is sub-customer box as appropriate.)
- Change the Title, First name, Middle name, Last name, and Suffix to make it identical to the customer you're merging it with. Ensure that the Display Name is also the same.
- Select Save, then select Yes to confirm that you want to merge the two customers.
Here's how to merge suppliers:
- Select Expenses, then Suppliers.
- Select the name of the supplier you don't want to use, then select Edit.
- Change the Title, First name, Middle name, Last name, and Suffix to make it identical to the supplier you're merging it with. Ensure that the Display Name is also the same.
- Select Save, then select Yes to confirm that you want to merge the two suppliers.
Now you're able to merge accounts, customers and suppliers.