+263 86 12 00 8884
770 Fern Road, Hatfield, Harare, ZW
M&J Consultants
M&J Consultants
Tax
  • Tax Legislation
  • Tax Operations
  • Tax Services
  • Tax Technology Consulting
Management Consulting
  • Strategic Advisory
  • Internal Audits & Controls
  • Mergers & Acquisitions
  • Market Expansion
Enterprise Resource Planning
  • Odoo ERP Zimbabwe
  • Palladium Accounting
Business Systems
  • Sage Pastel
  • Zoho Books
  • Quickbooks
Payroll
  • Odoo Payroll
Content
  • Insights
  • Case Studies
  • Events & Webinars
Tools
  • PAYE Calculator
  • VAT Calculator
  • VAT Checklist
  • Compliance Calendar 2026
  • Zimbabwe Investment Guide
About Us Get In Touch
[email protected] | +263 86 12 00 8884
Get In Touch
business strategy

Debtor Ageing Analysis and Customer Concentration Risk

By M&J Consultants • 11 min read
Debtor Ageing Analysis and Customer Concentration Risk

A finance director can look at a large debtor ledger and conclude that collections need attention. The greater concern may sit behind the total: one customer owes 40% of it, and most of that balance has remained unpaid for more than 90 days.

That is where debtor ageing analysis becomes a management tool, not just a month-end report. It shows when customers pay, which balances have become difficult to collect, and whether one commercial relationship now carries an outsized share of the enterprise’s liquidity risk.

For Zimbabwean businesses, this matters for cash flow forecasting, IFRS 9 impairment assessments and tax compliance. It also gives directors a practical basis for deciding when to reduce credit, request security or escalate a disputed account.

Start with an Ageing Report That Answers Management Questions

A basic debtor ageing report groups outstanding invoices by their due date. Common buckets are current, 1 to 30 days, 31 to 60 days, 61 to 90 days and over 90 days.

Those buckets are useful because the probability of collection often changes as an invoice moves further past due. There is no general Zimbabwe statutory rule that says an ordinary trading company must treat a particular bucket as unacceptable. Management must set credit controls that fit its sector, contracts and customer base.

The first report many teams produce lists a total for each bucket. That report helps the collections team prioritise calls, but it does not reveal concentration risk.

Build the report in two views:

  1. List each customer and its related entities across every age bucket.

  2. Show each customer’s percentage of total receivables and percentage of each overdue bucket.

  3. Identify balances under dispute, repayment plans, security arrangements and credit insurance separately.

  4. Compare the current month with the prior three to six month-end reports.

The second view changes the conversation. A business may have only 15% of its debtors over 90 days, which appears manageable, until it finds that one customer holds 80% of that bucket.

Group Related Customers Before Measuring Exposure

A customer concentration review should not stop at the legal name on the invoice. A holding company, its operating subsidiary and a director-controlled affiliate may create one economic exposure even where the ledger shows three separate accounts.

Ask the commercial team who owns the customer, who approves payments and whether several accounts depend on the same project or funding source. This step often gets skipped because the accounting system does not automatically identify connected entities.

If the same group controls several debtor accounts, report the combined balance to management. The risk comes from the group’s ability and willingness to pay, not from the number of account codes in the ledger.

Calculate the Concentration Risk in Each Bucket

Use two simple calculations for every significant customer or related group:

  • Customer balance divided by total trade receivables.

  • Customer overdue balance in a given bucket divided by the total balance in that bucket.

The first calculation shows exposure to a customer overall. The second shows whether that customer dominates the part of the ledger where collection risk is already highest.

Take an illustrative Zimbabwean distributor. Customer A owes 40% of total trade debtors, and three-quarters of its balance is more than 90 days overdue. Those old balances make up most of the company’s over-90-day bucket.

Customer A therefore represents 40% of all debtors and more than 85% of the over-90-day bucket. A portfolio average may suggest the business has a collection problem. The age-bucket analysis shows a more precise issue: one customer’s payment failure, dispute or funding delay could place most of the oldest debt at risk.

Management should convene a credit review for Customer A, pause further unsecured sales and test whether a payment plan, security or revised terms would reduce the exposure. If the customer has a risk profile that differs from the wider customer base, the finance team should assess its expected credit loss separately rather than burying it in a portfolio average.

The judgement call is straightforward. If a customer dominates the oldest bucket, do not wait for the annual financial statements to assess the account. Treat the issue as a commercial and liquidity decision this month.

Do Not Import Banking Thresholds Into Ordinary Trading Decisions

Banks and banking groups operate under a separate regulatory framework. The Reserve Bank of Zimbabwe, through its Bank Supervision Division, requires reporting of significant concentration risk at least quarterly. Under the Risk Management Prudential Standard No. 1 of 2024, exposures to a client, group of clients or related entities that reach 10% of the banking group’s capital base must be reported.

That 10% trigger applies to banks and banking groups. It does not create a universal legal concentration limit for a Harare manufacturer, a Bulawayo wholesaler or a Victoria Falls hospitality business.

Ordinary companies should still set internal escalation points. For example, a board may require a credit committee review when one customer exceeds an agreed percentage of receivables, or when one customer holds a defined share of balances beyond 60 or 90 days. The right threshold depends on margins, available working capital, contract terms and the ability to replace the customer.

Apply IFRS 9 Before an Old Balance Becomes a Write-Off

For IFRS reporters, trade receivables require an expected credit loss assessment under IFRS 9. The standard has applied to reporting periods beginning on or after 1 January 2018.

A provision matrix that uses days past due is an accepted practical expedient. It does not permit a business to apply the same loss rate to every customer without thought. Loss rates should reflect historical collection experience, current conditions and reasonable forecasts.

Segment the debtor book where customers behave differently. A company may need separate segments for government-funded projects, export customers, retailers, construction contractors or customers with collateral. The reason is practical: different payment cycles and financial pressures produce different loss patterns.

Take a retailer with twelve staff and a substantial debtor book. Its usual provision matrix applies a 3% loss rate to balances 31 to 60 days overdue and a 20% loss rate to balances over 90 days, based on its recent collection history.

One construction customer owes close to a third of the debtor book, all over 90 days, after its project funder delayed certification. The retailer should not automatically apply the 20% portfolio rate and move on. It should review correspondence, certified work, the customer’s funding position, any contractual retention and the likelihood of a negotiated payment plan.

If management expects to recover only half the balance based on the evidence available at reporting date, the account needs a more specific assessment. The retailer would also stop supplying further stock on open credit until it receives a credible payment arrangement. It would have reduced its exposure earlier if it had reviewed the customer’s share of the 61 to 90-day bucket, rather than waiting until the balance entered the oldest column.

Financial reporting advisory should connect this accounting assessment to the commercial evidence behind it. A number in an expected credit loss schedule needs support from the debtor ledger, collection notes and a documented management judgement.

Keep Accounting, Tax and Legal Collection Decisions Separate

A common error is to assume that an accounting impairment provision automatically creates a Zimbabwe income-tax deduction. It does not.

ZIMRA may allow a bad-debt deduction only where the debt was previously included in income and the taxpayer proves to the Commissioner’s satisfaction that the debt is bad. An ageing schedule is relevant evidence, but age alone does not prove that a debt has become irrecoverable.

Keep the underlying records with the debtor file: invoices, signed delivery evidence, statements, emails, demand letters, dispute correspondence, payment plans and evidence of insolvency where relevant. These records show both that the debt exists and that the business took reasonable collection steps.

The Income Tax position should be reviewed against the consolidated legislation and current ZIMRA practice before a return is submitted. The treatment described here requires verification for the relevant tax year.

Old debts also require attention before rights expire. Ordinary contractual debts generally prescribe after three years, subject to the contract, acknowledgements of debt, security and other legal considerations. The cited version of the Prescription Act is dated 31 December 2016, so legal advice should confirm any amendments and the facts of the claim before the business allows an account to lapse.

Do not write off an account simply because it has passed 90 days or three years. Check whether the debtor acknowledged the liability, made a part payment, offered security or disputed the invoice. Each fact can affect both recoverability and the appropriate next step.

Put a Monthly Review Around the Numbers

A useful debtor ageing analysis follows a repeatable monthly process. It should take place soon after month-end, while the sales and operations teams still remember what changed on each account.

Step 1: Reconcile the Ledger

Reconcile the receivables ledger to the general ledger before analysing trends. An unreconciled ledger can overstate risk through unallocated receipts, duplicate invoices or credits that the accounts team has not posted.

Step 2: Age by Due Date, Not Invoice Date

Age invoices from the contractual due date. An invoice issued on 1 June with 60-day terms should not appear overdue on 30 June. Due-date ageing gives management a fair view of whether the customer breached the agreed terms.

Step 3: Rank Customers Within Every Overdue Bucket

Rank the top customers in the 31 to 60, 61 to 90 and over-90-day categories. Include the customer group’s percentage of each bucket beside the currency amount.

This ranking identifies a growing dependency before the total ledger reaches a crisis point. A customer whose balance rises in each monthly report deserves attention even if it has not reached the oldest bucket.

Step 4: Record the Reason for Delay

Require a short collection note against material overdue accounts. The note should state whether the customer disputes price, quantity, quality, delivery, certification, foreign-currency availability or simply lacks funds.

Different reasons need different actions. A valid delivery dispute calls for operational evidence; a funding delay calls for a revised payment plan; repeated broken promises call for tighter credit terms.

Step 5: Make and Track a Decision

For each concentrated overdue exposure, assign an owner, action and date. Possible actions include a director-level call, suspension of new credit, a settlement proposal, security, legal demand or a specific expected-credit-loss review.

Track whether the action reduced the balance at the next month-end. A credit meeting without named actions becomes a discussion forum rather than a control.

Cash flow forecasting should use the same evidence. Do not forecast a 120-day debtor balance as next week’s cash receipt merely because the sales team expects payment. Use the agreed payment plan, payment history and current dispute status.

Frequently Asked Questions

What is debtor ageing analysis?

Debtor ageing analysis groups unpaid customer balances by how long they have remained outstanding after their due dates. It helps management prioritise collections, estimate expected credit losses and identify customers who represent an excessive share of overdue debt.

Is there a legal debtor concentration limit for Zimbabwean companies?

No general statutory percentage applies to ordinary Zimbabwean trading companies based on the available guidance. The Reserve Bank of Zimbabwe has a 10% reporting trigger for specified banking-group exposures under its May 2024 prudential standard, but that is not a universal rule for non-financial enterprises.

Can we claim a tax deduction for an IFRS 9 expected credit loss provision?

Do not assume so. ZIMRA may allow a bad-debt deduction where the debt was previously included in income and is proved to the Commissioner’s satisfaction to be bad. Review the evidence and current tax treatment before filing.

When should we stop supplying an overdue customer on credit?

Consider stopping further unsecured credit when the customer dominates the oldest ageing bucket, repeatedly misses agreed payment dates, disputes material invoices without evidence or cannot explain how it will fund payment. The decision depends on the contract, security, margin and strategic value of the relationship.

A debtor ageing report should tell directors where cash is tied up and where one customer could alter the enterprise’s financial position. We build ageing reports that rank customers in every bucket, group related accounts and connect collections to IFRS 9 and ZIMRA evidence, so you can act on a risky account long before it becomes a write-off. Our team can help you build the reporting, financial reporting advisory and tax compliance process around that insight. Speak With Our Team and request a quote tailored to your debtor book.

Share this article:

About the Author

M&J Consultants

Expert insights from the M&J Consultants team.

Free consultation

Need expert guidance?

Tell us about your business and one of our consultants will get back to you within one working day.

No spam. We only use your details to respond to this inquiry.

Something went wrong. Please try again or contact us directly.

Thanks, we've got it.

A consultant will reach out within one working day.

Prefer to talk now? Contact page

Related Articles

10 Lucrative Investment Opportunities in Zimbabwe for 2025
business strategy | M&J Consultants

10 Lucrative Investment Opportunities in Zimbabwe for 2025

Read Article
15 Low-Cost Small Business Ideas You Can Start in Zimbabwe with Limited Capital
business strategy | M&J Consultants

15 Low-Cost Small Business Ideas You Can Start in Zimbabwe with Limited Capital

Read Article
2026 ZIMRA Compliance Calendar for Zimbabwe Companies
business strategy | M&J Consultants

2026 ZIMRA Compliance Calendar for Zimbabwe Companies

Read Article

Subscribe to Our Newsletter

Get the latest insights delivered to your inbox.

M&J Consultants

Building Timeless Businesses

Africa's Premier Business Consultancy.

Services

  • Tax
  • Management Consulting
  • Digital Transformation

Industries

  • Agriculture
  • Manufacturing
  • Energy
  • Education

Company

  • About Us
  • Case Studies
  • Insights
  • Contact

Free Tools

  • PAYE Calculator
  • VAT Calculator
  • VAT Readiness Checklist
  • Compliance Calendar 2026
  • Zimbabwe Investment Guide

Contact

[email protected]

+263 86 12 00 8884

+263 78 098 2877 (WhatsApp)

770 Fern Road, Hatfield, Harare

© 2026 M&J Consultants. All rights reserved.