I am using desktop pro 2021. when i realized i had to delete the transactions one by one i used the other method mentioned- i exported the files to my new company.It worked. 

all of this because i did a mistake in my reconciliation and everything got messy.

i wish i could explain so you guys can help me but i am not sure what i did wrong . thank you so much for trying though