Every day I get reports of more than thousand rows for data cleansing. In that report mainly we have to delete all the related records as per amount like +100 and -100 should be deleted.

I have attached the sample report here for your reference.

Here you go. Got some help from another tech and came up with the following. Open this sheet and run the CLEANSE script. It does what you want, no worries, no fiddling.

The data must be together in a single block, no blank spaces. There is no "undo" with this script, so make sure to save before you run it in case you change your mind.