Client linked the same bank feed to three GL accounts. I need to delete all the transactions that were posted in the duplicate accounts. Is there an easy solution?

Hi gmarko,

Thanks for reaching out here.  QuickBooks Online understands that issues such as this can arise.  I'd be glad to assist!

Deleting transactions isn't recommended as this cannot be undone.  Transactions deleted in error will need to be recreated.  However, you can exclude them by following the steps here.  In QuickBooks Online Accountant, you can reclassify and move the transactions in one batch.  This method is a great time saver!

Feel free to contact us for additional assistance.  Your success is our number one priority, and it would be a pleasure to work with you directly and ensure you're able to accomplish your QuickBooks goals as soon as possible!

Schedule a Callback or start a Chat: click (?) Help in the upper right in QuickBooks Online > enter "Contact support" > hit Contact Us > provide a brief summary of your situation > hit Let's Talk > choose Get a callback or Start a Chat.
Social Media: Facebook, Twitter, and Instagram.
Support hours are from Monday to Friday between 9 a.m. and 8 p.m. ET.
 

Feel free to reach back out with other questions.  We're always happy to help!

Hi Trish

Thanks for the reply. "Exclude" does not work as the transactions were already posted in error and exclude only applies to transactions in the feed not posted. I have removed the bank feed to stop any new posts.

Reclassify doesn't work as qbo won't reclassify transactions that are linked to a bank match.

My current work around is a gl report to summarize the duplicate transactions, then AJE to zero the balance on the duplicate account, then making it inactive. Repeat for each duplicate account. This is not ideal as there are duplicate transactions in the remaining "real" bank accounts. Year End balances are correct but monthly reconciliations are inaccurate and as a result the need to delete all transactions in the duplicated accounts.

Any additional suggestions?

Greg

Hi there gmarko,

Within QuickBooks Online, there isn't a way to batch-delete transactions that are in the books. The only option to actually delete them would be to individually delete each of the incorrect transactions. Otherwise, the quickest way to balance the accounts otherwise would be to use journal entries to move the money from the incorrect accounts back to the accounts that were supposed to have the money.

If you have any other questions, feel free to reach out here.