This accounts receivable aging is an excel template that makes it easy to age invoices. This guide will walk you through constructing an aging report in Excel, focusing on key formulas and methodologies.An accounts receivable aging report report serves as an effective way of forecasting cash flow for business. We have put together all you need to create it. 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. Department's calculations of accounts receivable and related accounts.