How to dedouble transactions

Hi, I have a list from Google Analytics with transaction ID's and a list from our affiliate partner with their transaction ID's for which we are charged commission. I wish to dedouble the transacti...