How to read it
Each row is a customer and each column is an age band. Money in the "not due" column is normal credit. Money moving to the right is money you are lending for free, and the further right it sits, the less likely you are to collect all of it.
What to do about each band
- Not due: nothing, but know the total, because it is the cash you expect this month
- 1–30 days: a reminder on the next visit or by phone
- 31–60 days: the collector asks for a payment date, and the office follows up
- 61–90 days: consider stopping credit until something is paid
- Over 90 days: a decision by the owner, customer by customer
Three numbers to watch every month
- The total outstanding, compared with last month
- The share of it that is over 60 days
- The customers that appear in the 90+ column for the first time
Why the report is often wrong
An ageing report is only as good as the matching behind it. If payments are not matched to the right bills, old bills look unpaid and customers argue. The simplest rule is to settle the oldest bill first, every time, and to show cheques that have not cleared separately.
How Cashrovo does it
Cashrovo settles each shop's oldest bills first as payments are approved, so its Money owed by age report is always current. It shows every shop in the five bands, can be filtered by collector, and downloads as a PDF or an Excel file.