This excelbased aging template makes collections prioritization easier for your collectors. 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. Our guide explains the 9 steps to optimize the AR process using accounts receivable flow charts. Institutions are required to properly age accounts receivable to assist in the determination of collectability. 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. Use the Accounts Receivable Configuration form to specify ledger headings, invoice mapping accounts, and AR mapping accounts. AR implies anticipated payments are enforceable and legally binding. In an accounting system, accounts receivable is recorded on the balance sheet as an asset.