June 5th 2008
How to arrange Monthly Statements
Accounts receivable aging. If you allow your customers to purchase from you on account you will find that not all of them pay you according to terms. In fact, you will likely end up having some customers who take quite a while to pay . . . if not forever.
To track the quality of your customers‘ payments and as an aid to your collection effort you will want to produce an aging report of your A/R. Generally, it will look like this:
| Customer |
Current 30-60 days 61-90 days 91 days or over |
||||
| ACME | 380.55 | 57.95 | |||
| B-One |
195.49 |
||||
| Century | 549.90 | ||||
| Dave’s |
775.90 |
||||
| E Plus | 88.80 | ||||
| Falcon | 50.50 | ||||
| Total | 980.95 | 146.75 |
195.49 |
775.90 |
2099.09 |
|
Percentage |
47% |
7% |
9% |
37% |
100% |
By spreading your receivables in this way, you get a picture of your situation with outstanding accounts. ACME, Century, and Falcon are probably okay. B-One needs some attention, but Dave’s is serious. E-Plus is a bit past due, but it is a small amount. The situation with Dave’s has even caused your entire aging to be skewed. It is very serious indeed to have 37 percent of your outstanding balances in the ninety-day column. Continue Reading »
