If you are an administrator in NetSuite, you might need to merge duplicate or similar accounts to keep your chart of accounts clean and accurate. Here are some helpful tips and important reminders when merging accounts:
What You Need to Know Before Merging Accounts
You can merge two accounts together in NetSuite, but there are a few key rules to follow. First, the accounts you want to merge must be of the same account type (for example, both are asset accounts). Also, the account you want to merge must not have any subaccounts connected to it. You can merge an account with a parent account or with a subaccount. For example, if a store owner has both a petty cash account and a cash-on-hand account, and wants to keep everything in one place, the petty cash account (if it does not have subaccounts) can be merged into the cash-on-hand account.
Special Considerations for Bank and Credit Card Accounts
If you merge bank accounts or credit card accounts, be aware that NetSuite will automatically un-reconcile any previously reconciled transactions in the account being merged (called the Merge From account). After the merge, you must re-reconcile these transactions in the register of the account you merged into (the Merge To account). This is important for keeping your records correct.
Accounts That Cannot Be Merged
Some accounts in NetSuite cannot be merged at all. In particular, you cannot merge summary accounts. Here’s a list of accounts that are not allowed to be merged:
- Accounts Payable
- Accounts Receivable
- Advances Paid
- Inventory Asset
- Undeposited Funds
- Failed ACH Transactions
- Intercompany Clearing
- Intercompany Payable/Receivable
- Accrued Purchases
- Payroll Liabilities
- Refunds Payable
- Sales Taxes Payable
- Opening Balances
- Cost of Goods Sold
- Uncategorized Income
- Uncategorized Expense
- ALL non-posting registers
Make sure you review this list before attempting to merge any accounts.
We’d love to hear your thoughts – please feel free to share any insights or experiences you have in the comments or post a discussion in the NetSuite Admin Corner and let's continue learning together!