cancel
Showing results for 
Search instead for 
Did you mean: 
Coastroad4733
Level 1

Two Accounts Linked to One Bank Account

Hi all.  I've recently acquired the bookkeeper position at a company and I need help with a reporting issue when running payroll.  There are two different chart of accounts that were set up, one called the "cookie jar" and one called "payroll".  Only one is linked to the bank account for payroll, however, if you do not change the "pay from" account when running payroll it automatically pulls from the one marked "cookie jar".  How can I get rid of that account so that it does not show up anymore?  When I update bank accounts it pulls the bank transactions over to the "payroll" register but it doesn't show up as direct deposit payroll because those are linking in the other register.  I do not even know if I'm explaining this correctly because it's all so confusing.  Hopefully this will make sense to someone who can help.  Thanks so much!

5 Comments 5
MariaSoledadG
QuickBooks Team

Two Accounts Linked to One Bank Account

Let me share some information about getting rid of the bank accounts that are showing when running payroll, Coastroad4733.

 

I can see the importance of deleting accounts showing when running payroll. For now, the option to remove them from the drop-down list isn't possible. You can only get rid of them when you set your account to inactive. You'll want to manually select the account instead when running payroll. 

 

Additionally, you can review the resources from this link for more resources while handling your payroll entries: Help on common payroll topics.

 

Feel free to mention my name in your reply. I'm always around if you need help. 

Coastroad4733
Level 1

Two Accounts Linked to One Bank Account

Thanks so much for your reponse.  Is there a way to possibly merge the two chart of accounts since they are basically for the same purpose anyway?  

DivinaMercy_N
Moderator

Two Accounts Linked to One Bank Account

I got your back, @Coastroad4733. I'm here to help you merge accounts in QuickBooks Online (QBO). 

 

In QBO, you can simply merge two accounts by editing the account you won't keep and making the details similar to the one you want to retain. Before that, below are a few things you need to know:

 

  • If the accounts have reconciliation reports, save those reports first. Transactions remain on the merged account and stay reconciled.
  • In case both account registers have an opening balance equity transaction, delete the transaction with the most recent date before merging. The older transaction becomes the opening balance of the newly merged account.

 

Once ready, refer to these steps:

 

  1. Switch your QBO account display to Accountant view.
  2. After that, select the Settings icon and click Chart of Accounts.
  3. From there, look for the account you want to keep, select the dropdown under Action, and choose Edit.
  4. Take note of the Save account under (Account Type), Account name (Name), and Tax form section (Detail Type) of the account. It should be the same between the accounts you want to merge.
  5. Next, check if the account is a subaccount or a parent account. The names of subaccounts are indented in the Name column of the chart of accounts list. If it is, take note of the parent account it's tied to.
  6. Once everything is fine, navigate to the Chart of Accounts page again. 
  7. Look for the account you won't keep and select Edit in the dropdown.
  8. Modify the Account name (Name), and Tax form section (Detail Type) so the info exactly matches the account you want to keep. If you need to make this a subaccount, please visit this link for the things you need to keep in mind. 
  9. When finished, select Save and click Yesmerge accounts.

 

For reference, feel free to check this article: Merge duplicate accounts, customers, and vendors in QuickBooks Online. 

 

I'd be willing to lend further assistance if you have any other concerns about merging accounts in QBO. Please don't hesitate to get back here. Have a good day ahead and keep safe. 

NeatAndCoolAccountingGuy
New Member

Two Accounts Linked to One Bank Account

I think you solution is the fix I am looking for, but I am curious. My situation has both of these accounts showing (some) duplicate transactions. What happens to those duplicate transactions when the accounts are merged?

CarlSJ
QuickBooks Team

Two Accounts Linked to One Bank Account

I recognize the relevance of clarifying what happens to duplicate transactions during the process of merging accounts in QuickBooks Online (QBO), @NeatAndCoolAccountingGuy. I'd be glad to explain you further.

 

When you merge two accounts, you’ll choose one as the primary account, and the other will be integrated into it. This means that all transactions from the account being merged will be transferred to the primary account.

 

Additionally, keep in mind that there are important information to consider when merging accounts:

 

  • When merging two parent accounts, make sure that neither account has any sub-accounts attached to them.
  • If you’re merging with two sub-accounts, both need to be linked to the same parent account.
  • If one of the accounts is a sub-account, you’ll need to adjust its Account Type to match the other parent account exactly, turning it into a parent account.

 

For complete guidance on merging accounts, please visit this resource: Merge duplicate accounts, customers, and vendors in QBO.

 

However, if there are duplicate transactions in both accounts, the system won’t automatically remove those duplicates during the merge. You’ll need to take some time afterward to review and manually delete any duplicates as needed.

 

To do this, kindly follow these steps:

 

  1. Go to the Settings icon and select Chart of Accounts.
  2. Select the merged account, then click View Register.
  3. Manually locate the duplicate transactions and delete them.

 

Furthermore, I’d like to share a useful guide that gives you a snapshot of your business performance and aids in your decision-making: Run a report in QBO.

 

I know it can take some time and effort to keep your records accurate, but I’m here to help you every step of the way. If you need any extra guidance on merging accounts or removing duplicates, or if there's anything else on your mind, please feel free to reach out. I’m more than happy to assist.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us