How do i merge two bank accounts?

Glad to see you here in the Community, ellen. I can help you combine two credit cards under one account.

Yes, you can merge them under one account, but you need to know that once you merge your bank account, you're unable to undo them. When you merge an account, all the data moves into the one you want to keep and removes the duplicate. Also, if the account has reconciliation reports, make sure you've saved them. This way, transactions remain on the merged account and stay reconciled.

Here's how:

1. Go to the Accounting menu on the left navigation bar.
2. Select Chart of Accounts.
3. Locate the account you want to keep. Then, click the drop-down arrow next to View register and select Edit.
4. Take note of the account details and click Cancel.
5. Look for the account you want to merge. Then, click the drop-down arrow next to View register and select Edit.
6. Change the duplicate account's info to exactly matches the account you want to keep and click Save.
7. When you're ready, select Save and then Yes, merge accounts.

You can refer to this article for more detailed steps: Merge duplicate accounts, customers, and vendors in QuickBooks Online.

I've also added this article for your guide in reconciling your account in the future: Learn the reconcile workflow in QuickBooks.

Ping me a reply if you need any additional information or clarification about merging your bank accounts. I'll get back to you as soon as possible. Advance Happy New Year, and I wish you well!

thanks so much for your rapid reply, Alaina!

i realize now that the spurious account duplicates all the recent transactions in another account.  i made the spurious account inactive, but see "trails" of the account in other accounts because some transactions are transfers from/to another bank account.  QB won't let me delete these spurious (duplicate) transactions, saying that the transaction is tied to an inactive account.  how can i delete the spurious account?

many thanks-and Happy New year!

QBs does not let you actually Delete any accounts that have transactions in them.  It only lets you make them Inactive (aka Hide them).  And you're correct, even through it's Inactive, the Acct still shows up in some reports.

So how many transactions are there in the account you want to get rid of?  Your best bet is to Delete them and then QBs will allow you to Delete that Acct.  You may want to compare the transactions as your deleting them just to make sure you've got them all.  But when you Reconcile you'll catch any missing entries too, so comparing is just belts and suspenders I guess.

thank you so very much for your suggestions.  i have already engaged in the "compare" the spurious and real account transactions.

on to your suggestion about deleting the entries in the spurious account: how do i fine it to do this since i have hidden it? and once i find it, will the method through which to delete it be obvious to me?

thank you again!

i have been able to find the "deleted" account, but QB will not let me delete individual items (which i understand is needed to be able to delete the entire spurious account). how can i delete the individual line items (that are duplicates of items in another account and therefore make balances wacky)?

 thanks so very much!

ellen

Hi, Ellen. I'm pleased to help you delete the items or transactions under your spurious account.

The system won't allow you to delete entries that are linked to an inactive account. You can make it active to delete individual line items or transactions.

Here's how:

1. Click on Accounting at the left pane, then Chart of Accounts.
2. Locate the account, then tap on Make active under Action.

After that, delete the transactions under the dummy account.

1. Locate the account from the Chart of Accounts.
2. Select Run report under Action.
3. Open, then delete each entry from there.

I'm also adding this link for an additional guide: Void or delete transactions in QuickBooks Online.

Once done, you can inactivate the account again.

If you have additional questions about the steps I provided, let me know by adding a comment below. I'm more than happy to help you again. Keep safe!

thank you so very much, Angelyn, for your step by step directions, which look like they should work if i could locate the account.  however, the account is not listed in the chart of accounts.  When i did find it (not in the chart of accounts but by linking back to it from a report that contained items in it from the spurious account), the name of the account included "deleted." does this provide a clue for a different way to access it to delete it?  thank you again for your help! ellen

please see the attached screen dump

When you have the Chart of Accounts open, go to the Settings in the upper right corner (next to the printer icon).  Then select Include Inactive Accounts.

Your hidden bank account should now show up (and any other Inactive Accts).  At the right end of the Inactive Bank Account, use the drop down to make it Active Again. Then you should be able to go into that Acct and delete the individual Transactions.

thanks IMMENSELY! with your help, i was finally able to delete transactions in this spurious account, reconcile each true account and create end of year reports! thank you so VERY much! ellen

It's nice to see you here in the Community, @ellen-codd.

I’m glad to know that the information provided by my colleague above has helped you to figure this out. Thank you for making business with us in QuickBooks.

If you have any other concerns about QuickBooks count me in. I'll surely get back to you. Take care.

Hey,

The case is the following:

I've set up the multi-currency in QBO. There are several home-currency accounts (USD) plus (from WISE) a GBP (sterling) and EUR (euro) bank account. When setting up QBO converted both in USD accounts, which is completely wrong. They must show up in the currency as they are: in EUR and in GBP. This is important though, to be compliant with the IRS and the citizen home country tax authorities of the member of the LLC.

It should have been like this:

Bank account home currency US LLC 1 - other bank 1 - succesfully added

Bank account home currency US LLC 2 - other bank 2 - sucessfully added

Bank account home + multi currency account US LLC 3 - USD successfully added, £ and € 

The £ and € have been wrongfully and automatically by QBO converted to USD.

I've added them manually in £ and €, but those don't update automatically at all, QBO keeps ongoing with the wrongfully converted USD accounts.

I'd really appreciate if you could help me with this.

After 6 weeks of re-trying and because of that having to file a f7004, which I didn't want to and wouldn't have to when this wouldn't have happened, I'm a little bit hopeless. So, I really appreciate every help to set this right.

Thank you so much in advance!

P.S. I'm not sure if I attach a screenshot this would be visible for anybody, so because of keeping my books private I didn't had the guts to add it. Though I hope my question is clear enough to get me back on my feet again. Thanks again!

Hi Pete,

I just send a question to Angeline, but now I read your message, you may have the solution for me.

To be honest I'm a little bit disappointed and since 6-weeks trying to change the currency to what it should be, reading that you can't get rid of wrongfully by QBO added acoounts and converted them without my concensus or agreement to USD. To reading your message today, after 6-weeks of trying to get the £ and € at WISE correctly in those two currencies showing up with NO conversion to USD, I see you have a way to disable them and than delete them?

I added them both afterwards manually, but those two don't get updated by QBO.

Because I need to meet the correct guidelines for. my US LLC, IRS, and my home country Tax authorities in Belgium, I MUST have the £ and € correctly shown in the opening- and end balance as well in all statements.

Can you help me please?

My phone is XXXXXX (please leave a voicemail if I'm not able to respond directly, so I'm able to give you a call back) or you can contact me on my business address e-mail [email address removed].

I'm not sure how this community works. I just signed up with the name The Owl. 

I'm not sure if this message can be seen by everyone, so that's why I haven't added a screenshot from my books.

There are very few transactions in all accounts because its only about max 4 months from a startup that works with pace..

I'd be very thankful if you could help me solve this. It made it necessary to file a f7004 where I just had sorted out everything to upload in the books with all invoices etc. But my bookkeeper wants to submit the tax return with the f5472 and f1120pro forma before the end of May, and whatever I try, it just won't work to accomplish this. So thank you very much if you would be so kind to try to help me solve this problem.

Greetings, @The Owl. 

I appreciate you joining in on this thread. 

The QuickBooks Community is a public platform, so we are unable to review your phone number or email. The best route would be to request a callback from our Customer Support Team. 

You can easily do this within your account, here's how: 

1. Go to the Help (?) icon in the top right-hand corner. 
2. Tap the Contact Us button/hyperlink. 
3. Give a brief description of the issue and hit Let's talk. 
4. Scroll down and choose to Get a callback. 

It's that easy! 

Keep us updated on how it goes. It's my priority that you're able to get back to running your business. Have a great day! 

HELP.  HELP.  We lost connection to our main bank account (goes back to 2017) witih Chase two weeks ago.  Finally got that account reconnected, but somehow QBO created a new account in chart of accts, with a different name and NO account number.  Our origional acct is numbered 11010 in chart of accounts.  

1. If I merge the newest (non-numbered one) that has the bank connection intact, to the original acct (11010) that does not have the bank connection, will the new merged account have the bank connection?

2. If I merge the oldest one into the new (non-numbered) account, can I then change the name to the name of the original account with the chart of account number 11010?

3. If I merge oldest to newest, will I lose six years of reconcillation reports and/or data?  

4. Or, should we delete the "new" account that is linked to Chase bank and try again to link old one?  My boss is not always in town, and doesn't have lots of time, and he is primary on QBO and also on bank.  He will have to do it.  I was trying to save him having to do anymore of the work on this mess, and also trying not to make a bigger mess.  

HELP HELP HELP  Can upper level accounting call me please?  Both accounts appear on the dashboard.  

Candice, I already contacted Intuit and received a callback before I joined this forum.  The person I spoke to sent me the link.  He was very nice, but not as experienced as I needed... I need someone who knows all of the drawbacks of the complication I have.  I can't get that person by using that chat and requesting a callback.  The people I speak to resist my requests to send me to their managers or another department that may have the answer.  Is there any way to get a call back from upper level?  Should I contact my salesperson?

Welcome to the Community, @Kamprod.

You can merge your bank accounts and use the name and account number of the account you want to keep. All data moves into the account you want to keep and removes duplicate transactions. Before we proceed with merging, make sure to save reconciliation reports of the account you are merging. Please note that once you merge bank accounts, you can't undo them.

Here's how:

1. From the left menu, select Accounting.
2. Choose Chart of Accounts.
3. Locate the account you want to keep. Then, click the drop-down arrow next to View register and select Edit.
4. Take note of the account details and click Cancel.
5. Look for the account you want to merge. Then, click the drop-down arrow next to View register and select Edit.
6. Change the duplicate account's info to match the account you want to keep, and click Save.
7. When you're ready, select Save and then Yes, merge accounts.

You can read this article for the detailed process of merging bank accounts: Merge duplicate accounts, customers, and vendors in QuickBooks Online.

For future reference, here is an article to guide you in reconciling your account: Learn the reconcile workflow in QuickBooks.

Feel free to click the Reply button below if you have questions about merging your account. I'm always here to help. Have a great day.