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.We've included a free downloadable accounts receivable Excel template in this piece. If you prefer, you can also use it in Google Sheets. 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. The Analytical Review of Aging worksheet is the analytical review of the prior year to current year aging. Age the accounts receivable information of all customers in the statement cycle. You create and post invoice records in the Vision Transaction Center. The claims will have no impact on ValueOptions' financial status or ability to perform under the contract.