after reviewing bank transactions , i attempt to generate a detailed vat report for the specified period, unfortunately , i get numerous duplications of transactions on the same date. i have to go back and remove manually , time consuming

Thank you for sharing details on your post, @raving-mweb-co-z. I'll help you take care of those duplicate transactions.
 

You did the right thing, also to add up. We can delete them from the register or Undo the bank reconciliation.

To remove them from the register, here’s how:

1. Go to Accounting and then select your bank account.
2. Under Action, select View register.
3. Choose the transaction in question, one at a time.
4. Select Delete and then click Yes.

You can refer to this thread to learn more about how to undo the bank reconciliation.

Keep me posted if you have other banking concerns with QuickBooks. I'll be around to help you. Have a nice day.