I have just connected my bank feed, but previously created & posted sales invoices, expenses & purchases, the bank transactions have now duplicated , how do i undo this?

Hello Lindsay-woods

Have you added in these bank transactions that have duplicated in the banking section?If so you can go to reviewed and then select the duplicates and hit on undo.

If you have not added the duplicates you can click in the box to the left of the date and go to batch actions and exclude selected.f all the transactions on the page in for review then you can click to the left od the word date and it will tick all of them and then you can select in batch actions exclude selected

Any questions just reply back to this post

Emma

Hi there

I have just added the new feature for a link to my bank and now this year and my previous year have all duplicate transactions? It will take me hours to go through every single item over the past 20 months? is there a quicker way or undo what i have done at all? Thank you, Mandy

Hello Mandy Rimmer

Welcome to the Community

Which bank is this with.When you connect to the bank it should ask you what date range you want to upload from to stop this.If this has not happened you can exclude in bulk the transactions.

Which product are you using QuickBooks Self Employed or QuickBooks Online?

Thanks

Hi Emma

Thank you for your reply :) I was Barclays bank and now I have duplicate transactions even in my 2018-2019 accounts which were finalized and ready to send to my accountant but now it's all over the place? Is there any way of undoing this please as if I was to delete each one it would take hours due to the number of transactions? Thank you and speak soon, Mandy x

Hi Emma, does that mean i have to undo each transaction at a time? as they all loaded at the same time? There are hundreds on there and last years also? Thank you, Mandy 

Hi Mandy

You can batch exclude the transactions

If you are using QuickBooks Online you can do this by going to banking>

put a tick in the box to the left of the word date it will select on the transactions on the page( untick the ones you do not want to exclude)>go to batch actions>exclude selected

If you are using Self Employed you can do this by going to transactions>put a tick in the box to the left of the word date>you will see the word exclude populate and then if you click it will exclude all the selected transactions (so again any you did not want to exclude would need to be unticked

Any questions on this please let us know

Emma

Hi Emma, that's what i mean do i have to go through every single one now and delete? i know you can do lots at a time but there are hundreds to now go through? Can i just go back to this morning when it was all fine? Thank you

Hi Emma, I don't know what has happened since I added Barclays but there are not even two of things there are sometimes six for one transaction? is it easier deleting it all and letting it upload again from scratch as there are thousands of transactions? did you say there is an undo button or can you go on and have a look for me and see if you can do any better? Thank you 

Thank you for the response, @Mandy Rimmer. 

Sometimes those duplicate transactions are caused by how the bank communicates with our systems that can impact how we receive your data, which can sometimes lead to duplicate transactions.

At this time, there’s no undo button in QuickBooks Online (QBO) or QuickBooks Self-Employed (QBSE).

However, there’s an option to delete them. Check this article for more information on how to remove accounts you no longer use in QBO: Remove accounts you no longer use. But if you’re using a QBSE account, here’s how to hide or delete a bank account.

Let me know if there's anything else that I can help with those bank transactions by leaving a post below.