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.
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.
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.
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:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.