Debtor ageing

Debtor ageing is a report that groups unpaid bills by how long they have been outstanding, so the exco can prioritise follow-up.

Debtor ageing (also called an aged debtors or aged receivables report) groups the money residents owe by how long each amount has been outstanding, typically 0-30 days, 31-60 days, 61-90 days and over 90 days.

How it works in a Nigerian estate

Each unpaid demand notice is placed in a time band based on its due date. The report then shows, for each house and for the estate as a whole, how much falls in each band. The older the debt, the less likely it is to be paid without firm action.

Illustrative example: an estate with ₦6,000,000 outstanding finds ₦2,500,000 in the 0-30 day band (mostly residents who pay late every month), ₦1,500,000 at 31-90 days, and ₦2,000,000 over 90 days, owed by just eight houses. The exco sends routine reminders to the first group, calls the second, and takes the eight long-standing debtors through the formal process in the bye-laws.

Why it matters

A single "total outstanding" figure hides the real picture. Ageing shows whether the problem is many residents paying a little late or a few who have stopped paying, and those need different responses. It also helps the treasurer forecast cash and report honestly to residents. See how to reduce estate levy defaulters and service charge budgets and accounts.

In Zenus360

Execs see paid against outstanding, a demand-notice ageing report, collections reports and resident balances, and can export to Excel or PDF. Offline cash or bank payments recorded by managers update balances too. See estate dues collection.

Frequently asked questions

How often should an estate review its debtor ageing?

Monthly is a good rhythm, ideally before each exco meeting, so follow-up is agreed while debts are still young.

Should old debts be written off?

Only after a documented decision by the exco or general meeting in line with the estate’s rules, and after reasonable recovery efforts. Get accounting advice on how to record it.

Run your estate on Zenus360

Gate passes and visitor management, levy and service charge collection, a resident wallet, prepaid electricity tokens, polls and support tickets in one estate app, with a dashboard and full accounts for your exco.