This accounts receivable aging is an excel template that makes it easy to age invoices. 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. This guide will walk you through constructing an aging report in Excel, focusing on key formulas and methodologies. An accounts receivable aging report is a summary of customers' unpaid invoices composed according to date categories. Assisting in the accounting, analysis and budgeting of various accounts. Accounts and the University's receivables.