An aging report groups open receivables (or payables) by how long they've been outstanding, typically in buckets like current, 1-30, 31-60, 61-90, and 90+ days past due. It shows which customers owe overdue amounts (AR) or which invoices are due/overdue (AP), guiding collections, payment prioritization, and provisioning.
Real-world exampleThe credit team works the AR aging each week, chasing the 90+ bucket first to reduce bad-debt risk.
Common follow-ups: What are typical aging buckets? | How is AR aging different from AP aging?
Collections & Bad DebtsCredit ControlAging Analysis
What is the difference between AR aging and AP aging?
Beginner
AR aging shows money customers owe you, aged from the invoice/due date—used to drive collections and estimate bad debts. AP aging shows money you owe suppliers, aged by due date—used to prioritize payment runs, capture discounts, and avoid late-payment issues. One manages incoming cash, the other outgoing.
Real-world exampleAR aging highlights an overdue customer to chase, while AP aging highlights an invoice due tomorrow to include in the run.
Common follow-ups: Which aging drives collections? | Which drives payment prioritization?
Collections & Bad DebtsPayment RunsAging Analysis
How are aging buckets determined—by invoice date or due date?
Beginner
Aging can be calculated from the invoice date or the due date; due-date aging is more meaningful because it reflects amounts actually past their payment deadline. A report aged by due date with terms applied shows true delinquency, whereas invoice-date aging overstates 'overdue' by ignoring the credit period.
Invoice date 1 June, Net 30 -> due 1 July.
On 15 July: due-date aging = 14 days overdue;
invoice-date aging = 45 days (misleading).
Real-world exampleSwitching the report to due-date aging stops the team from chasing invoices that are still within terms.
Common follow-ups: Why is due-date aging preferred? | How do payment terms factor in?
Credit ControlCollections & Bad DebtsAging Analysis
How is Days Sales Outstanding (DSO) calculated and what does it indicate?
Intermediate
DSO measures the average days to collect receivables: (Accounts Receivable / Total Credit Sales) x number of days in the period. A rising DSO signals slower collections, looser credit, or customer distress; a falling DSO indicates faster cash conversion. It's a core AR efficiency and working-capital metric.
DSO = (AR / Credit Sales) x Days
= (300,000 / 1,800,000) x 90 = 15 days for the quarter.
Real-world exampleA jump in DSO from 35 to 48 days prompts a review that finds a major customer stretching payments.
Common follow-ups: What causes DSO to rise? | What is a 'good' DSO?
Credit ControlCollections & Bad DebtsAging Analysis
What is Days Payable Outstanding (DPO) and how does it relate to aging?
Intermediate
DPO is the average days you take to pay suppliers: (Accounts Payable / COGS) x days. AP aging is the detail behind DPO—showing how far outstanding payables are. Higher DPO preserves cash but risks supplier relations and missed discounts; aging shows whether you're paying on time, early, or late.
DPO = (AP / COGS) x 365 = (500,000 / 5,000,000) x 365 ~= 36.5 days.
Real-world exampleManagement targets a 45-day DPO; the AP aging confirms most invoices are paid near, not before, their due date.
Common follow-ups: How do DPO and DSO affect the cash conversion cycle? | Can DPO be too high?
Payment RunsCredit ControlAging Analysis
What is the cash conversion cycle and how do AR/AP aging feed it?
Intermediate
The cash conversion cycle (CCC) = DSO + DIO (days inventory) - DPO. It measures how long cash is tied up in operations. AR aging drives DSO, AP aging drives DPO; improving collections (lower DSO) or extending payables sensibly (higher DPO) shortens the CCC and frees working capital.
CCC = DSO + DIO - DPO = 45 + 60 - 35 = 70 days.
Cutting DSO to 35 shortens CCC to 60 days.
Real-world exampleReducing DSO by 10 days through better collections cuts the cash conversion cycle and reduces borrowing needs.
Common follow-ups: How does a shorter CCC help? | Which levers shorten the CCC?
Collections & Bad DebtsPayment RunsAging Analysis
How is aging used to prioritize collections activity?
Intermediate
Aging focuses effort where risk and value are highest: chase large and older balances first, apply escalating actions as items move into later buckets, and segment by customer risk. It turns a large ledger into a prioritized worklist, improving cash recovery and reducing the chance items reach write-off.
Real-world exampleCollectors work a risk-weighted list: high-value 60-90 day items get calls today, small current items get automated reminders.
Common follow-ups: Why chase older/larger items first? | How does risk segmentation refine the worklist?
Collections & Bad DebtsCredit ControlAging Analysis
How does aging drive the allowance for doubtful accounts under the aging method?
Advanced
The aging method applies increasing loss percentages to each bucket (older = higher risk) to estimate the required allowance for doubtful accounts. The total estimated uncollectible sets the allowance balance; the period's bad-debt expense is the amount needed to adjust the existing allowance to that target.
Bucket x rate:
Current 100k x 1% = 1,000
31-60 20k x 5% = 1,000
61-90 10k x 15% = 1,500
90+ 8k x 40% = 3,200
Required allowance = 6,700.
Real-world exampleThe aging schedule sets a required allowance of $6,700; with $4,000 already provided, the team books $2,700 of bad-debt expense.
Common follow-ups: How do you compute the expense from the required allowance? | Why do older buckets carry higher rates?
Collections & Bad DebtsReconciliationsAging Analysis
What is CECL/expected credit loss and how does it change receivables provisioning?
Advanced
CECL (US GAAP) and the IFRS 9 expected-credit-loss model require estimating lifetime expected losses using historical loss rates adjusted for current conditions and reasonable forecasts—not waiting for an incurred loss. Aging still informs it, but provisioning becomes forward-looking, often via a provision matrix of loss rates by aging bucket adjusted for macro outlook.
Provision matrix (loss % by bucket) x balances, adjusted for a forecast
downturn multiplier -> lifetime expected credit loss allowance.
Real-world exampleUnder CECL the team raises provisions ahead of a forecast recession, even for current receivables, using an adjusted loss-rate matrix.
Common follow-ups: How does CECL differ from the incurred-loss model? | What is a provision matrix?
Collections & Bad DebtsAging AnalysisReconciliations
How do you reconcile the aging report to the general ledger control account?
Intermediate
The total of the AR (or AP) aging/sub-ledger must equal the GL control account balance. Reconcile by comparing the two, then investigating differences from unposted transactions, direct GL journals bypassing the sub-ledger, timing, or misapplied cash. The aged sub-ledger is the detail supporting the single control-account figure.
AR sub-ledger (aging) total: 320,500
GL AR control account: 321,000
Difference 500 = a manual GL journal not in the sub-ledger -> correct.
Real-world exampleA $500 gap between the aging and the GL is traced to a manual journal posted directly to the control account and reversed.
Common follow-ups: What causes sub-ledger to GL differences? | Why avoid direct journals to control accounts?