There are three reports that you need to complete. The second and third reports are given in sheets 2 and 3.
(1) Prepare an aging schedule: Use the =IF() function to identify past due invoices and # of days past due.
Use the =IF(AND()) function for the aging schedule.
(2) Prepare an analysis of accounts receivable using Pivot table:
(3) Prepare an analysis of accounts receivable using Pivot chart: