Macro for Reconciling Intercompany GL Activity

Hello,

I am looking for code to try and clear as many items within a GL that net to zero. Some may be a one to one match where others could be a 2 to 1 match or possibly even a 10 to 1 match or more so that the only amounts remaining are items that do not net to zero. Attached is an example of activity. Any help would be appreciated. I have found a lot of code but most of it is not working the way I had hoped. I have another file with code as well but you have to run through each scenario and delete rows after each macro is run before running the next.