Hi All. Trying to get QB to equal bank accounts. There were heaps of duplicate transfers in one account so I've deleted them but it's put the other out of balance. thanks

Thanks for checking in with us, userinfo93.

I appreciate you for removing the duplicate bank entries on your account.  To resolve out of balance in your register, we'll need to review the actual bank statement. Then, compare it on what transactions are downloaded in QuickBooks Online (QBO) if there are missing transactions we need to enter or duplicate ones need to remove. 

If there are missing ones, just enter them manually into your account. Just check out the Enter historical information article for the steps and details. However, if the out of balance is caused by duplicate entries, just exclude them to completely remove the transactions in QBO. Let me show you how:

1. Go to the For Review section and mark the banking transactions we want to exclude.
2. Click the Batch actions button and select Exclude Selected.
3. Go to the Excluded section and mark again the said transactions.
4. Click the Batch actions button and select Delete.

Here are tips that I can share to avoid duplicates in your register:

• If you have existing transactions in QuickBooks Online, you can select Match from the Banking page.
• Otherwise, you can select Add or Transfer.

Feel free to visit our Banking and transactions page for more insights about managing your bank feeds and reconciling accounts.

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you, Take care always.

Hello - thanks for responding. My problem is with transfers between my two accounts.  When one account balances the other is out & same the other way around.  I found a heap of duplicates in one account so I deleted them & then the other account was out.  I then tried excluding transactions & perhaps it was a mistake but I then deleted the excluded ones, which didn't help.  Then I imported the transactions again but wasn't sure if the credit amount should go under "Credit" or "Debit" in the QB system.  And basically I still can't figure out how to get the accounts to balance. A lot of the transfers are also listed as "deposits" which they're not & I can't seem to change them to read "transfer".

I really would appreciate getting this sorted soon.

Many thanks again!!

Julie

Thanks for coming back, userinfo93.

QuickBooks Online (QBO) uses double-entry accounting, which means each transaction or event changes two or more accounts in the ledger. Each of these changes involves a debit and a credit applied to one or more accounts. To learn more about this one, see the How accounts are affected by debits and credits article. 

To change the deposits to transfers, we'll have to manually delete the deposit and record it as a bank transfer to correct this. You can refer to the Transfer funds between bank accounts article for the steps and details about handling a bank transfer.

If you need further assistance about this one, I'd suggest contacting our Customer Support Team. They'll pull up your account in a secure environment and help you with this one. You may send a message via chat, call us at a time convenient to you, or we’ll get in touch with you instead. Here's how:

1. Go to the Help icon on the top right. 
2. Enter your concern in the search field.
3. Choose Talk to a human.
4. Click the OK. To get you to the right human, in a few words, tell me what you need help with option and tap I still need a human. 
5. Press Contact us.
6. Tick Continue. 
7. Choose Message an agent or Get a callback.

Feel free to visit our Banking and transactions page for more insights about managing your bank feeds and reconciling accounts.

Fill me in if you need a hand with reconciling your accounts or any QBO related. I'll be here to ensure your success. Keep safe always.

Hello again

I tried contacting support via both the call-back option (they said they'd call back in 5 minutes, over 2 hours ago) and via online chat (they said the wait was 5 minutes over 2 hours ago).  I'd really like some help with this but I'm still finding that every time I delete a duplicate transaction in one account it puts the other account out and I cannot figure out how to balance both accounts.  The offending transactions are transfers between the two accounts.

All help is much appreciated.

Thanks.

Julie

Hi Julie, 

Thank you for reaching out and welcome to our community!

Based on what you mentioned, I think some of the transfer transactions were recorded correctly in QuickBooks Online. Here I found an article on recording bank transfers for your reference:

Transfer funds between bank accounts

Should you require additional assistance on this, please don't hesitate to Contact Us.

Thank you and please let us know if you require any additional assistance.