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.This guide will walk you through constructing an aging report in Excel, focusing on key formulas and methodologies. Understanding Aging Reports. In this training this is what I'll be showing you how to analyze account receivables or adapters in 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. I need to create an aging worksheet. I have a template I downloaded from Officeupdate. Everyone in the VUU community strives to promote the highest levels of academic achievement.