Protect Cash

Which Customers Owe Me Money?

An accounts receivable ageing report shows each unpaid customer invoice, how long it has been outstanding and where collection action is needed.

Customer receivables grouped into current and overdue ageing categories totalling RM30,000

The Short Answer

Review an updated accounts receivable ageing report. Confirm that invoices and customer payments are recorded correctly, then separate amounts that are not yet due from those that are overdue.

Total receivables = current invoices + overdue invoicesKnowing who owes money is only the start. Each overdue amount needs a named action, owner and follow-up date.

Read The Ageing Report

Ageing categoryWhat it means
CurrentInvoiced but not yet due for payment.
1–30 days overduePast the agreed due date; confirm payment timing.
31–60 days overdueActively follow up and resolve any issue.
Over 60 days overdueEscalate and assess whether it is recoverable.

A Simple Example

This illustrative report reconciles to total receivables of RM30,000.

Ageing categoryAmount
CurrentRM12,000
1–30 days overdueRM8,000
31–60 days overdueRM6,000
Over 60 days overdueRM4,000
Total receivablesRM30,000

RM18,000 is overdue. Management should identify the customers and invoices behind that amount rather than relying only on the total.

Turn The Report Into Action

Customer positionImmediate action
RM12,000 currentMonitor due dates and send documents promptly.
RM8,000 overdue 1–30 daysConfirm the invoice and payment date.
RM6,000 overdue 31–60 daysResolve disputes and obtain a firm commitment.
RM4,000 overdue over 60 daysEscalate collection and review recoverability.
Read The More Detailed Answer

Begin With A Reliable Report

Generate the ageing report from the customer ledger as at a clearly stated date. Reconcile its total to the accounts receivable balance in the general ledger. Investigate differences before using the report for decisions.

Post customer receipts, credit notes and approved adjustments promptly. Otherwise, staff may chase invoices that have already been paid or overlook amounts that remain outstanding.

Age Invoices Consistently

Age invoices from the contractual due date. Confirm that agreed credit terms are recorded correctly and use the same method each month.

CheckWhy it matters
Cut-off dateShows when the balances were measured.
Later receiptsIdentifies invoices collected after month-end.
Credit termsPlaces invoices in the correct ageing band.
Credits and disputesSeparates collection work from corrections.

Review Customers, Not Only Totals

For each material balance, list the invoice number, due date, amount, contact person, reason for delay, promised payment date and staff member responsible. Separate genuine disputes, missing documents, payment plans and customers who have not responded.

Review concentration too. One customer may represent most of the risk even when the total overdue balance appears manageable.

Set Collection Priorities

PrioritySuggested focus
FirstLarge, old balances and broken promises.
SecondDisputes or missing documents to resolve.
ThirdNewly overdue invoices before they worsen.
OngoingCurrent invoices approaching due dates.

Keep a record of calls, emails, commitments and next steps. Obtain appropriate advice before legal recovery action.

Connect Collections To Cash Planning

An ageing report shows what is owed; it does not guarantee when cash will arrive. Put realistic promised payment dates into the cash forecast and test the effect of delays.

Review Credit Risk Weekly

Repeated late payment may require new credit limits, deposits, milestone billing or shorter terms. Assign an owner to each material action and update the collection list every week. Consider whether any balance may be irrecoverable with appropriate accounting, tax and legal advice.

Avoid These Mistakes

  • Reviewing only the total receivables balance.
  • Leaving receipts or credit notes unallocated.
  • Ageing invoices from the wrong date.
  • Accepting repeated promises without follow-up.
  • Failing to assign an owner and next action.

Quick Review

  • Does the ageing total agree with the accounts?
  • Which customers and invoices are overdue?
  • Why has each material invoice not been paid?
  • Who owns the next action and by what date?
  • Are collection dates reflected in the cash forecast?

Key Takeaway

Do not manage receivables as one number. Know the customer, invoice, age, reason, responsible person and next action for every material overdue balance.

This guide provides general educational information. Collection, credit, accounting, tax and legal decisions should be assessed using the business’s circumstances and appropriate professional advice.