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. This accounts receivable aging is an excel template that makes it easy to age invoices. Aging of Accounts Receivables and Payables 1-12 (460E). Discover how an Excel aging balance template can simplify receivables management, improve cash flow, and prioritize collections. Discover how an Excel aging balance template can simplify receivables management, improve cash flow, and prioritize collections. Accounts will be reported. Use the Accounts Receivable Configuration form to specify ledger headings, invoice mapping accounts, and AR mapping accounts.