Cash: Question 2 (In-class Work) Compare cash receipts to sales invoices. a) Using the data provided (2021 & 2022), check to ensure the accuracy of the Mailroom Control list. To do this, compare each cash receipt as recorded to the amount invoiced (Sales and Delivery Invoices). Identify any cases in which the Mailroom Control amount does not match the total billed on the invoice. b) If you find discrepancies, what might you report to the company. Do you believe the discrepancies require further investigation? Hints: In this problem, you will need to link together information from Mailroom Control List and Product & Delivery Invoice data sets. To do this, consider using the "VLOOKUP" function. Once you have the information from the invoices and cash receipts on one worksheet, think about how you can easily compare one to the other without having to page through the entire worksheet. For example, is there a formula you can use that will give you one answer if there is a difference and another if they are the same? Combine Mailroom Control List & Product & Delivery Invoices Date Check Amount Invoiced Invoice # amount Customer Name Customer # Difference

Fig: 1