Google Sheets Reconciliation File with Google App Script

I need a google sheet file that can help me reconcile some payments from equipment sold, I have the data from the equipment sold on one sheet and the data from the payments received on another sheet, I need a Google App Script that finds the serial of the equipment sold on the payments sheet and then return the amount paid per category on the equipment sold sheet.