5 min read Collections

Ageing reports: what that report isn't telling you

The most-used receivables report is also the most misleading. Three things it hides that decide whether you get paid.

The report everyone looks at

An ageing report splits what you're owed into buckets: current, 30, 60, 90, over 90. It's the most used collections report in the world and, read properly, it's useful.

The trouble is it gets read as if it said who's going to pay you, and it doesn't say that. It says how long each invoice has gone unpaid, which isn't the same thing.

The three things it hides

  • A customer who's up to date with a big problem. If they pay religiously every month but their total balance has grown 40% in a quarter, the ageing report flags nothing: it's all «current». Your exposure grew and the report doesn't say so.
  • The difference between not paying and being in dispute. An invoice in the 90-day bucket can be a customer who won't pay or an invoice the customer rejects over a delivery problem. They're handled in completely different ways, and the report puts them together.
  • The agreed terms. If you gave a customer 60 days, their 45-day invoice isn't overdue even if it lands in an alarming bucket. An ageing report calculated on the invoice date instead of the due date scares you for nothing — and worse: it reassures you when it shouldn't.

Ageing is calculated from the DUE DATE, not from issue. It's the commonest mistake, and it produces a report that looks right and is wrong for every customer on anything other than cash terms.

What else to look at

  • The trend of each customer's balance, not just the balance. Growth is the early signal; falling overdue is the late one.
  • The real average collection days against the agreed ones. If you agreed 30 and collect at 52, you're financing the customer for 22 days nobody decided on.
  • How much of your balance sits with a few customers. A report that's healthy overall can hide that 60% is owed by a single one.
  • Which invoices are in dispute, flagged as such, with the reason. Chasing by phone an invoice the customer rejected three weeks ago wastes everyone's time twice.

What really decides whether you get paid happened earlier

The uncomfortable conclusion: by the time an invoice shows up in the 90-day bucket, the decisions that mattered have already been made. Who you gave credit to, how much, on what terms, and whether you checked anything first.

That's managed with the credit limit, which is where the problem gets stopped. The ageing report is the thermometer; the limit is the treatment.

Collections and customer credit

On the same topic

Collect earlier, don't chase later

Zyntello Accounts Receivable calculates ageing from the real due date, flags disputed invoices and warns before they fall due.