Aging Report Template

Download our free aging report template

Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.

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:

Aging Report Template Preview

Download the Free Template

Enter your name and email in the form below and download the free template now!

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.

Analyst Certification FMVA® Program

Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.

 

Financial Analyst certification curriculum

 

A well rounded financial analyst possesses all of the above skills!

 

Additional Questions & Answers

CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.

In order to become a great financial analyst, here are some more questions and answers for you to discover:

 

0 search results for ‘