Help With Reconcile Report

[goob90]

Hello!

I have been tasked with reconciling our insurance invoice against payroll deductions. In the past, this has been a "pencil & paper" project, but that takes much too long. This is probably a simple(ish) task, but I am needing a macro to compare two worksheets. First, to see if the employee number matches, and then if the deduction matches the amount due on the invoice. If the employee numbers don't match, I will know that the employee is either not getting their deduction taken out or has a deduction but isn't on the invoice. I would also like to have non-matches go to another sheet.

I have linked a sample worksheet using fictitious employee names for an example:

Loading Google Sheets

Any guidance would be really appreciated. Thank you all for your time!

 

[Jeffrey Mahoney]

I add a formula in cell D2 of the Vendor Invoice sheet and copied down. It shows "Rec" if found on the Payroll Deduction sheet

=IF(COUNTIFS('Payroll Deductions'!C:C,'Vendor Invoice'!B2,'Payroll Deductions'!D:D,'Vendor Invoice'!C2)>0,"Rec","")

 

[goob90]

I add a formula in cell D2 of the Vendor Invoice sheet and copied down. It shows "Rec" if found on the Payroll Deduction sheet

=IF(COUNTIFS('Payroll Deductions'!C:C,'Vendor Invoice'!B2,'Payroll Deductions'!D:D,'Vendor Invoice'!C2)>0,"Rec","")

Thank you! Do you know of a way to show that once it finds them on the Payroll Deduction Sheet that it then compares the amounts?