Analyze a list of revenue items and compare to a GL listing to determine where the discrepancies are and why the totals differ

I have an excel spreadsheet detailing all the revenue booked into Quickbooks. I also have an excel spreadsheet detailing division reports for the year. The total revenues from the two sheets are different and I need to know where the difference is and why. There are 62 transactions in one spreadsheet and 39 statements summarized in the other. The statements may contain revenue from one or more of the revenue transactions summarized. I need supporting documentation showing the reconciliation between the two sheets with noted errors or explanations.