Comparing Data Between Two Spreadsheets

I have two spreadsheets that includes account number, name, and a charge amount for one (positive number) and a waiver amount (negative number) on the other. Both lists are very similar and may contain the same people, but one may have names the other does not.

Exampe:
List A
ID NAME Charge
1 Joe 50
2 Jane 50
2 Jane 50
3 Judy 50

List B
ID NAME Waiver
1 Joe -50
2 Jane -50

In this example, Joe was charged $50 and then it was waived. Jane was charged $50 twice, but one was waived, so she still owes $50. Judy was charged $50, but was never waived so she owes this amount.

How can get Excel to auto compare these for me and either highlight the differences or pop into a new spreadsheet/cell?

Example of different data:
ID NAME Charge
2 Jane 50
3 Judy 50

Can anyone help me? I'm thinking a Macro or an IF statement of some kind. Maybe even a VLookup?

Thank you,
Keltikroze
<<email address removed>>@aol.com