Guide

What a debtors ageing report tells you, and what to do about it

A debtors ageing report lists what each customer owes, split by how long it has been overdue: not yet due, 1–30 days, 31–60, 61–90 and over 90 days. It shows at a glance which customers to chase first and how much of your money is at risk.

By Sumindu Ekanayaka, who builds Cashrovo ·

Guides / What a debtors ageing report tells you, and what to do about it

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.

Questions people ask

What is the difference between outstanding and debtors ageing?

Outstanding is the total a customer owes. Ageing splits that total by how long each part has been due, which tells you how urgent it is and which customers to follow up first.

How often should a distributor check the ageing report?

Weekly is a good habit for a business that delivers every week: once before planning the week's collections, and again at month end to compare with the month before.

Want this done for you?

Cashrovo runs these routines for your office and your collectors. We'll show you with your own kind of shops.