Free Aging Report Template | Categorize Receivables & Improve Cash Flow - CFI

Download our free aging report template

Published May 13, 2019

Read Time 2 minutes

Over 2.8 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course. Start Free

Aging Report Template

This aging report template will help you categorize accounts receivables by how long invoices have been outstanding, as well as calculate your allowance for doubtful accounts.

Here is a preview of CFI’s aging report template:

Download the Free Template

Categorizing Accounts Receivables

An aging report is a report that categorizes the balances of a company’s clients based on the length of time their invoices are outstanding – its age. These accounts are usually categorized into 30-day intervals. Thus, allowing the company to assess its clients in greater detail than if they only evaluated them based on their outstanding balances.

This is important because it allows a company to take a step back and evaluate which of their clients are risky to do business with. In these cases, the company might contact their client to notify them of their outstanding invoices and further negotiate business terms if the client fails to pay for their invoices. Thus, the aging report is a tool that helps firms weed out bad clients and improve accounts receivable turnover.

Using the example shown in the preview above, you can see that Company C owes debts of 100, which have been outstanding for over 90 days. Alternatively, this means that Company C fails to pay for 16.7% (100/600= 0.1667) of its purchases. Further business with Company C will need to be evaluated.

The aging report can also be used for other purposes. Most companies usually have provisions for how they evaluate bad debts or doubtful accounts. The longer an invoice is outstanding, the higher the chance it will go unpaid. Companies need to represent these unpaid outstanding debts in their financials. This is referred to as a company’s allowance for doubtful accounts. This aging report template can be used to calculate a company’s allowance for doubtful accounts using assumptions for each time interval.

For example, looking at the preview again, we can see that this company has an allowance for doubtful accounts of $64, based on their assumptions for bad debts.

More Free Templates

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.

• Excel Modeling Templates
• PowerPoint Presentation Templates
• Transaction Document Templates
• Accounts Receivable Aging
• See all financial modeling resources
• See all Excel resources