The cost of uncollected invoices
For small and medium enterprises (SMEs) across Africa, profit on paper does not pay salaries or purchase raw materials. In high-inflation markets like Nigeria, where the central bank’s monetary policy rate exceeds 26 percent, cash tied up in unpaid invoices is an expensive drain on working capital.
Many founders mistake rising sales for financial health, only to discover their cash is trapped in unpaid accounts receivable. A structured accounts receivable ageing report is the primary tool to prevent this leak and ensure cash flow matches sales growth.
What is an ageing report and how to structure it
An accounts receivable ageing report is a financial document that categorises outstanding customer invoices by the length of time they have remained unpaid. It provides a visual overview of who owes money, how much they owe, and how long the payment has been delayed.
To build a basic ageing report in a spreadsheet or accounting software, you must sort outstanding invoices into specific time intervals. These standard buckets are: current (not yet due), 1 to 30 days overdue, 31 to 60 days overdue, 61 to 90 days overdue, and over 90 days overdue.
For example, a logistics provider in Nairobi or a packaging manufacturer in Lagos should list each client on a separate row. The columns should represent these time intervals, allowing the management team to see exactly which clients are sliding into high-risk categories.
Using the ageing report to drive collections
An ageing report is useless if it is merely viewed at the end of the month. To drive collections, the report must guide specific operational actions based on the age of the debt.
For invoices in the 1 to 30 days bucket, a polite, automated email reminder or a friendly phone call on the day after the due date is usually sufficient. This step ensures that minor administrative errors or missing bank details are resolved quickly.
When an invoice moves to the 31 to 60 days bucket, the communication should become more formal. A phone call from the finance manager should establish a clear date for payment and document any disputes the client might have regarding the delivered goods or services.
For debts beyond 60 days, senior management must intervene. This stage requires halting further supply or service delivery to the client and initiating formal demand letters to protect the company’s margins.
Common mistakes African SMEs must avoid
A frequent error among small businesses is failing to update the ageing report in real time. If a client pays their invoice but the report is not updated, your team may mistakenly harass a paying customer, damaging a valuable relationship.
Another common mistake is treating all overdue clients the same way. A long-standing client with a temporary cash flow issue requires a different follow-up approach compared to a new client who has ignored multiple payment reminders.
Finally, many founders fail to link sales commissions to actual collections. When sales representatives are paid bonuses based on closed deals rather than cash received, they have little incentive to assist with the collections process.
Take immediate action
Review your accounts receivable ledger today and classify every outstanding invoice into standard ageing buckets. Identify any client with a balance outstanding for more than 60 days and call them immediately to secure a specific payment commitment.
