What is accounts receivable aging (aged debtors) and how does it guide collections?
Accounts receivable aging—also called an aged debtors report—is a table that groups unpaid customer invoices by how many days have passed since their due date. Instead of showing one lump-sum receivable figure, it reveals which customer balances are current and which ones are dangerously overdue.
An accounts receivable aging report sorts open customer balances into time buckets: Current (not yet due), 1–30 days overdue, 31–60 days, 61–90 days, and 90+ days overdue. The older an unpaid invoice gets, the harder it is to collect and the higher its priority.
How aging buckets work and how they are calculated
Looking only at your total accounts receivable can hide serious cash flow trouble. Two businesses might both have 100,000 in open receivables, but one has invoices due next week while the other is chasing bills from four months ago. Aging calculates the exact day difference between each approved invoice's due date and today.
Standard aging schedules divide unpaid balances into thirty-day intervals. When a customer has already made a partial payment on an invoice, only the remaining unpaid balance is placed into the corresponding overdue bucket.
- 1–30 days past due: Recently overdue invoices that usually respond quickly to a polite reminder and a statement of account
- 31–60 and 61–90 days past due: Balances slowing down your cash flow that require a direct call and a structured payment schedule
- 90+ days past due: High-risk receivables where new credit sales should pause until the old balance is settled or paid down
Why aging is essential for setting collection priorities
Small business owners often waste time chasing the largest customer balance without checking whether that invoice is actually due yet. Calling a loyal buyer whose bill is not due for another two weeks does little for today's cash flow compared with following up on three medium balances that are 65 days overdue.
Reviewing your aged debtors report once a week gives you an action list: send a friendly PDF statement of account to customers in the 1–30 day bucket, and negotiate immediate full or partial collections with contacts sitting in the 61–90 and 90+ day columns.
Using the Accounts Receivable Aging report in GiroPS
GiroPS builds the Accounts Receivable Aging report automatically from your approved sales invoices, their due dates, and recorded customer collections; draft invoices are never included. You can see every customer's unpaid balance broken down across overdue day ranges on a single screen.
From there, you can open any overdue customer contact, share a clean PDF statement of account, and log full or partial collections that immediately update both your cash or bank account and the aging report.
Practical scenario
Example: aging schedule across four customers
A wholesale distributor has 100,000 in total accounts receivable across four contacts. The aging report shows Customer A owes 50,000 due in 10 days (Current), Customer B owes 25,000 that is 18 days overdue (1–30 days), Customer C owes 15,000 that is 45 days overdue (31–60 days), and Customer D owes 10,000 that is 105 days overdue (90+ days). Exactly 50% of total receivables are past due, telling the owner to prioritize Customer D and Customer C first.
Frequently Asked Questions
Is receivable aging based on the invoice date or the due date?
Overdue aging is measured from the invoice due date, because a bill only becomes past due once the agreed payment term expires. If no separate due date was set, the invoice date serves as the starting point.
How does a partially paid invoice appear in the aging report?
Only the remaining unpaid balance of the approved invoice is shown, placed in the age bucket that matches the number of days elapsed since its due date.
What should I do when balances pile up in the 90+ days column?
Pause further credit sales to those contacts, send an updated PDF statement of account immediately, and arrange a concrete partial-payment schedule so cash starts returning to your business.