Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Trying to merge two accounts that are different account types and it is not allowing me.
The first account is named "Accounts Receivable" and it's an "Accounts Receivable" account type.
The second account is named "Opening AR" and it's an "Other Current Asset" account type.
I want to merge the two accounts by changing the name of the "Opening AR" account to "Accounts Receivable". But, when I try to do that, I get the following error message:
"This name is already in use as a different type. Please use a different name."
Solved! Go to Solution.
Hi there, @ptownbro985.
You can only merge accounts with the same account type. Since you're unable to change an account type from or to Accounts Receivable (A/R), I'd suggest using a clearing account. This way, you can transfer the amount from one A/R to another A/R account.
Here's how o set up a clearing account:
To move your money using the clearing account, please refer to this article: Set up a clearing account.
You can check this article to give you an idea of what else you can do with Chart of Accounts: Understand the chart of accounts.
Please let me know if you need further assistance. I'll be around to help. Have a great day.
Hi there, @ptownbro985.
You can only merge accounts with the same account type. Since you're unable to change an account type from or to Accounts Receivable (A/R), I'd suggest using a clearing account. This way, you can transfer the amount from one A/R to another A/R account.
Here's how o set up a clearing account:
To move your money using the clearing account, please refer to this article: Set up a clearing account.
You can check this article to give you an idea of what else you can do with Chart of Accounts: Understand the chart of accounts.
Please let me know if you need further assistance. I'll be around to help. Have a great day.
Thank you for your help, but one follow-up question. If you can only set up 1 Accounts Receivable account, how then do you set up an "Allowance for Doubtful Accounts" account and have it be grouped with your A/R account? The "Allowance for Doubtful Accounts" is an A/R account
Hello, @ptownbro985.
You can set up another A/R for Allowance for Doubtful accounts and group it with the default Accounts Receivable. Just set it up as a sub-account, then choose this account when creating invoices.
To do that, here’s how.
1. Go to the Lists tab.
2. Select Chart of Accounts.
3. On the bottom part, click the drop-down arrow beside Account and select New.
4. Click on the Other Account types drop-down.
5. Select Account Receivable.
6. Click Continue.
7. Fill in the Account Name (Allowance for Doubtful Accounts)
8. Put a checkmark on the Subaccount of the box. On the drop-down arrow select the Accounts Receivable. Fill in the other information needed (optional).
9. Click Save & Close.
Please check the screenshots below.
Please check out this article for additional understanding about the sub-account. Create subaccounts in your chart of accounts in QuickBooks Online.
Please leave a comment below if you need further assistance about Accounts Receivable, I’ll be glad to help. Take care!
I appreciate the suggestion, but to be honest that does something I hate about QuickBooks. Which is it will then set up the scenario where you have a parent account (the AR account) and child account (the sub-account) and then you do postings to both. Then QB creates this "other" account.
Thanks for coming back, ptownbro985.
You're right, QuickBooks creates the Other account for the sub-accounts when running a report. This helps us to easily verify the sub-account is linked to the parent account.
However, when running Transactions by Account report, the Total AR sub-account and Total AR sub-account - Other amounts will show separately in the report (see the screenshot below).
For more details about creating an account, check out this article: Create, edit, or delete an account in QuickBooks Desktop.
I've got a link here that provides you with articles about running reports in QuickBooks: https://quickbooks.intuit.com/learn-support/en-us/reports/07?product=QuickBooks%20Desktop.
Keep me posted if you need a hand with managing your Chart of Accounts or any QuickBooks related. I'll be here to ensure your success. Take care always.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here