AR Analysis

Cost: Free
System Requirements: Microsoft Excel® 2007 or later*
User Agreement: Read it Here
Creator: SpreadsheetShoppe.com
AR Analysis
File Size: 119 kb
File Type: xls
Download File
 +1 This Page
Picture
Aging Analysis - 5 yr trend
Picture
AR Analytics - 5 yr trend
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.

 

Picture
Click to view large picture
When you begin entering information (completing the items in red) this information will flow through to other portions of this template.  For example, once you enter the date, all other dates are automatically calculated.  This information is carried over to the next tab.

 

Download Example Data

Example
File Size: 118 kb
File Type: xls
Download File
There are a total of 8 key ratios or measures of AR that can be evaluated on the Analytics tab.  Each of these can be viewed graphically, as shown in the picture to the right.  Included within the chart area is a drop down box, allowing you to select the measure of interest.  

At the bottom of each tab is an area referred to as 'Tickmarks' - this area provides space to document analysis conducted associated with any unusual or significant activity identified.
Need an accounts receivable aging template?  You can download an AR Aging here.
blog comments powered by Disqus

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.