Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
J
juniorwarden9893
February 15, 2021
Question

I f i merge two accounts receivable accts (or payables) how does that impact my P

  • February 15, 2021
  • 2 replies
  • 134 views
I am not sure when the second accts were created or why, but they are causing issues

2 replies

C
Charies_M
Level 9
February 15, 2021

Nice to have you here, juniorwarden9893.

 

When you merge two accounts, this moves all the data into the one you want to keep and remove the duplicate. QuickBooks moves past transactions from the duplicate to the account you want to keep.

  1. If you’re merging accounts that have reconciliation reports, save those reports first. The transactions remain on the merged account and stay reconciled.
  2. Go to Settings and then select the Chart of Accounts.
  3. Find the account you want to keep. Then select the dropdown in the Action column and then Edit.
  4. Note the name and detail type of the account.
  5. Check if the Is sub-account option is marked. If it is, notes the parent account it's tied to.

Once you have all the information needed for the account you want to keep, go on, and manage the duplicates.

 

Here's how:

 

  1. Go back to the Chart of Accounts.
  2. Find the duplicate account (the one you won't keep). Then select the dropdown ▼ in the Action column and then Edit.
  3. Change the Name and Detail Type so the duplicate account's info matches the account you want to keep exactly. If you need to mark Is sub-account, keep in mind:
    • If you’re merging two parent accounts, make sure they don’t have any sub-accounts.
    • If you’re merging two sub-accounts, make sure they both have the same parent account.
    • If only one is a sub-account, uncheck the Is sub-account option so it becomes a parent account.
  4. When you're ready, select Save and then Yes to confirm.

Find out more about this whole process by visiting this article: Merge duplicate accounts, customers, and vendors in QuickBooks Online.

 

To help you with the future task and tips when using QBO, you might want to visit our Help Articles.

 

If you have another question in mind, please let me know. I'd be happy to answer them for you. Have a good one.

M
mjhantsche
March 25, 2021

When you merge the 2 AR accounts together, will all the payments previously applied remain in tact?

Z
ZackE_Moderator
Moderator
March 25, 2021

Thanks for reaching out to the Community, mjhantsche.
 

Merging accounts moves all of your transaction data into the one you've chose to keep, while removing the duplicate. Any payments you previously applied will remain intact.
 

You'll want to be aware that merges are permanent and can't be undone afterwards. Additionally, your books use some accounts as a default for certain features. Because of this, they can't be merged or deleted. The same applies to accounts connected through a bank feed.
 

For more information about merging duplicates, I'd recommend reviewing some of our resources linked in Charies_M's post.
 

I've also included an extensive archive of tutorials about using QuickBooks that may come in handy moving forward: Video tutorials
 

I'll be here to help if there's any questions. Enjoy the rest of your day!

C
Charies_M
Level 9
February 16, 2021

Hi, juniorwarden9893

 

Hope you’re doing great. I wanted to see how everything is going about merging two accounts receivable you had yesterday. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.


Looking forward to your reply. Have a pleasant day ahead!

J
juniorwarden9893Author
March 25, 2021

Charles, I am still holding off with the merge.  I understand how to do it, but I am worried about impact.  The two accounts were created in different years.  If I merge into the newer account, what happens to the financial statements with regard to the older financial statements - do the transactions from the former account show up under the merged account number?  Or do they "disappear"?  I don't want to "tamper" with dollar values 

 

Second concern:  What transaction process determines which Acct.Rec is used?  I want to understand how to control it.  Currently, when I create invoices, sometimes the invoice shows up in either receivables with no particular pattern.  I.e, my receivable accounts are 13000 and 13000.T.  If I create 3 invoices today, some invoices post to 13000 and some to 13000.T  I can't find a pattern and I can't find the "trigger" to make them all post to 13000.  I want to control where they post.  This also applies to my payables.  

 

I have reviewed most all of the resources you recommend, I have looked at internet resources, and I contracted a CPA who uses Quickbooks.  But I cannot find the specific answer.  I appreciate your efforts to help.    

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement