Measuring the Effect of Credit
What impact did the credit department really have on the monthly aging? Accurately measure and graphically display the exact impact a credit department has on their monthly aging. Enter two consecutive months of data in the green cells below and compare the effect of sales changes vs credit and collection efforts has on each column of the aging bucket.
|
Current Month A/R Figures
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Prior Month A/R Figures
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Fill in the balances for each aging bucket to compare two consecutive months. |
|
|
|
|
|
|
|
|
Sales Effect
Credit Effect
 | Loading… |
| Loading… |
|