How to use an accounts receivable aging report (South Africa)

Direct answer: what an aging report does and why it matters

An accounts receivable aging report organises unpaid invoices by age buckets (for example, 030, 3160, 6190, 90+ days). It gives a snapshot of who owes you, how long amounts have been outstanding, and which customers need immediate attention to protect cash flow and reduce credit risk. Use the report to prioritise calls and reminders, escalate at defined thresholds, and feed insights into credit terms and provisioning.

How to prepare an aging report (step-by-step)

1. Collect outstanding invoices and credits from your accounting system or ledger.
2. Confirm invoice dates, due dates, invoice numbers and customer identifiers.
3. Choose ageing cut-offs (common practice is 30-day increments) and assign each invoice to a bucket based on days past due, or days since invoice date if you prefer ageing on invoice date. (See practices and examples below.)
4. Group totals by customer so you can see per-customer exposure and the ageing profile.
5. Reconcile the report to the debtor control account and correct any unapplied receipts or credit notes.

Prepare the report at a consistent cadence (weekly for smaller cash buffers, monthly as a minimum) so changes and trends are visible.

Sources and quick methods

• Use a spreadsheet or accounting package report that exports invoices and due dates, then sort and bucket by days past due. Many accounting guides outline the basic flow of collecting, sorting and bucketing invoices. (See practical guides linked in Sources.)

How to read an aging report

• Look at totals by bucket to spot concentration in older buckets; large totals in the 6190 or 90+ buckets are higher risk.
• Sort by customer to identify accounts with multiple overdue invoices.
• Calculate the proportion of total receivables in each bucket to see whether overall receivables are aging (a rising share in older buckets).
• Flag customers with a long-time small balance versus large single overdue invoices; treatment often differs.

Practical reminder schedule (recommended starting point)

Below is a practical schedule you can adapt to your cash flow and customer relations. Treat this as operational guidance, not legal advice.

• Before due (37 days before due): polite reminder with invoice reference, amount, due date and clear payment options. Use this to reduce accidental late payments.

• On due date: short reminder noting the invoice is due today and repeating payment details.

• Overdue 714 days: first overdue notice , polite but firmer, include any late-payment terms you charge and invite the customer to notify you of any disputes.

• Overdue 30 days: second overdue notice and a phone call. Offer a short payment plan if appropriate for long-term customers or escalate if the customer is unresponsive.

• Overdue 60 0 days: formal demand and internal credit review. Consider holding future deliveries, imposing credit limits or advancing to formal recovery steps depending on your credit policy.

• Overdue 90+ days: high-priority escalation , final demand, leadership sign-off on next steps and possible referral to legal or specialised recovery if your business policy allows.

Tailor tone and escalation to the customer relationship and the size of the debt. Keep records of all communications for audit and compliance purposes.

Best practices when using an aging report

• Run the ageing report before any credit decisions (new credit, increasing terms) so you know existing exposure by customer.
• Reconcile the ageing report to your general ledger (debtor control account) to ensure accuracy.
• Use consistent buckets and a consistent report date to make trends comparable month-to-month.
• Combine ageing with customer notes (disputes, promised payment dates) so the AR team acts on context, not just numbers.
• Review exceptions , small balances in long buckets may be worth writing off after a cost-benefit assessment.

Examples: common scenarios and actions

• Customer A: R150,000 total; R120,000 is 90+ days. Action: urgent contact, check for disputes, request payment plan or escalate credit decision.

• Customer B: R45,000 total spread across 030 days. Action: routine reminders; no escalation unless balance grows.

• Customer C: recurring small invoices but one large stuck at 6190 days. Action: treat the large invoice as a priority while continuing normal process for new invoices.

Operational vs legal considerations

Operational guidance here covers how to prepare and act on aging reports and reminder schedules. Legal matters (for example, whether to issue statutory demands or start litigation) should be handled with legal advice specific to the case and to South African law. Keep operational records so legal or tax advisors can review a clear audit trail if needed.

Record-keeping and standards in South Africa

Keep copies of invoices, communications, reconciliations and the ageing report itself to support balance-sheet assertions and any credit decisions. Retention practices are covered in South African accounting guidance and retention guidelines; follow the retention periods that apply to your entity type and industry and consult your accountant for specifics.

Using automation to keep the report and reminders current

Automation reduces manual work: a properly configured system can generate ageing reports, send scheduled reminders in your businesss name, and record all communications. If you decide to automate, choose a tool that: runs reports from your ledger, sends messages from your business name, and delivers receipts directly to your bank , and offers a trial so you can test the fit with your processes. Zeroed is one option that helps South African businesses send and manage payment reminders in their own name; consider automation once youve defined an internal escalation policy.

Next steps (practical checklist)

1. Run todays ageing report and reconcile to your debtor control account.
2. Identify customers in 6190 and 90+ buckets and prepare a contact plan.
3. Implement a reminder schedule like the one above and assign owners for each escalation step.
4. Decide on automation: trial a tool that sends reminders from your business name and keeps payment receipts going directly to your bank.
5. Review ageing monthly and adjust credit terms or provisioning as needed.

FAQs

Q: How do you prepare an aging report in accounts receivable? A: Export outstanding invoices (with due dates) from your accounting system, choose ageing buckets (commonly 30-day increments), assign each invoice to a bucket based on days past due, and group totals by customer. Use the reconciliation to ensure the report ties to the debtor control account. (See practical preparation steps in linked guides.)

Q: What is the 10 rule for accounts receivable? A: The "10 rule" is an informal heuristic used by some credit teams , practices vary. It is not a mandatory accounting standard. If you use a heuristic, document it in your credit policy so decisions are consistent.

Q: How to read an accounts receivable aging report? A: Read totals by bucket to see where receivables are concentrating, and then review customer-level ageing to prioritise collections. Look for trends month-to-month and reconcile differences back to individual invoices and payments.

Q: How to calculate aging of accounts receivable? A: Calculate days past due (or days since invoice date), and place each invoice into your chosen bucket (for example 030, 3160, 6190, 90+ days). Sum balances per customer and per bucket for reporting.

For more detail on preparing and interpreting ageing reports, see the sources below and consider running a 14-day trial of an accounts receivable reminder tool that operates in your business name if you want to automate reminder schedules.