Description: There are two tabs included within this download, a picture of each is included above. The first tab - Aging Analysis allows you to evaluate the trend of an accounts receivable aging over a 5 year period. The information input into the first tab will automatically update the next tab, and be used to develop key ratios associated with accounts receivable. The only additional information necessary is Net Sales, Allowance for Bad Debt, and Bad Debt Expense. Note, all formulas are in blue.
Need an accounts receivable aging template? You can download an AR Aging here.
Other Useful Tools
Question or comments? Reach us Here
* Note, utilizing the features of these graphs requires Microsoft Excel® 2007 or later - some of the attributes such as the graded shading or 3-D formatting are not compatible with earlier versions.