Use Excel to determine which customers are paying on time, which are not, and how far they are behind the payment date. This accounts receivable aging is an excel template that makes it easy to age invoices.In today's video I'm going to go about how to create an accounts receivable aging Rapport in Microsoft Excel. Learn how to create an aging report in excel for accounts receivable. Use the provided formulas to find out who is most overdue and how much you are owed. Struggling with managing your client's accounts receivable process? An accounts receivable aging report is a summary of customers' unpaid invoices composed according to date categories. News and Information from the New York State Assembly. The course incorporates the use of Excel spreadsheet modeling capabilities in order to prepare students to model and solve real world problems.