Aging Analysis Interview Questions & Answers

Q: What red flags can an aging report reveal?

Aging can reveal concentration risk (one customer dominating overdue balances), a growing 90+ bucket (rising bad-debt risk), recurring small unresolved differences (disputes or short pays), credits sitting unapplied, and customers whose aging worsens over time (distress). These signals prompt credit review, dispute resolution, or provisioning.

Q: How can automation and analytics improve aging management?

Automated aging with dashboards, alerts on bucket movements, predictive scoring of payment likelihood, and integration with collections workflows turns static reports into proactive management. Analytics can prioritize accounts by expected recovery, forecast cash inflows, and flag deteriorating accounts earlier than manual review.

Q: What does the 90+ days bucket typically signify and how is it treated?

The 90+ bucket holds the most overdue items, carrying the highest risk of non-payment. These receivables get the strongest collection actions (final demands, holds, escalation, possible legal/collection agency) and the highest provisioning rates, and are the leading candidates for write-off if recovery efforts fail.

Q: How do you read an AR aging summary at a glance?

Scan the total outstanding, then the distribution across buckets: a high proportion in current is healthy; growing later buckets signal collection problems. Compare customers to spot concentration, and watch the 90+ column for bad-debt risk. Trends over months matter more than a single snapshot.

Q: What is 'best possible DSO' and how does it differ from standard DSO?

Best possible DSO (BPDSO) uses only current (not-yet-overdue) receivables: (Current AR / Credit Sales) x days. It represents the DSO achievable if all customers paid exactly on terms. Comparing actual DSO to BPDSO shows the collection gap caused by overdue balances, isolating collection performance from sales terms.

Q: How does disputed AR distort aging and what should you do about it?

Disputed invoices sit in the aging as overdue even though the customer is withholding payment pending resolution, overstating collectible overdue balances and understating collection performance. Flagging disputes separately (a dispute/deduction status) gives a truer view and directs effort to resolving the dispute so the cash can flow.

Q: How can you forecast cash collections from an aging report?

Apply historical collection-probability curves to each bucket (e.g., current pays ~95% next month, 31-60 ~70%) to project when outstanding balances will convert to cash. Layering these roll-rates over the aging produces a weekly/monthly cash-inflow forecast that treasury uses for liquidity planning.

Q: What does it mean when receivables are 'current' versus 'past due'?

'Current' means within the agreed payment terms—not yet due—so no action is needed. 'Past due' means the due date has passed without payment, triggering collection activity. The split, based on due-date aging, separates normal open balances from those needing follow-up.

Q: How does aging support inventory of unapplied credits on customer accounts?

Aging can include credit balances and unapplied cash, not just debits. Surfacing aged credits ensures they are applied to open invoices or refunded rather than forgotten, which otherwise understates what customers really owe and can create unclaimed-property (escheatment) obligations for very old credits.

Q: What is a weighted-average days overdue and why is it useful?

Weighted-average days overdue weights each overdue balance by its size, giving a single figure that reflects how late money is on a dollar-weighted basis. It's more meaningful than a simple average because a large, slightly-late balance matters more than a tiny, very-late one.

What red flags can an aging report reveal?

Intermediate

Aging can reveal concentration risk (one customer dominating overdue balances), a growing 90+ bucket (rising bad-debt risk), recurring small unresolved differences (disputes or short pays), credits sitting unapplied, and customers whose aging worsens over time (distress). These signals prompt credit review, dispute resolution, or provisioning.

Real-world example A steadily growing 90+ bucket for one customer signals financial distress, prompting a credit hold and closer monitoring.

Common follow-ups: What does concentration risk mean here? | How do unapplied credits distort aging?

Credit Control Collections & Bad Debts Cash Application

How can automation and analytics improve aging management?

Advanced

Automated aging with dashboards, alerts on bucket movements, predictive scoring of payment likelihood, and integration with collections workflows turns static reports into proactive management. Analytics can prioritize accounts by expected recovery, forecast cash inflows, and flag deteriorating accounts earlier than manual review.

Real-world example A predictive model ranks overdue accounts by likelihood to pay, so collectors focus on recoverable balances and cash forecasts improve.

Common follow-ups: What can predictive scoring add to collections? | How does aging feed cash forecasting?

Collections & Bad Debts Credit Control Aging Analysis

What does the 90+ days bucket typically signify and how is it treated?

Beginner

The 90+ bucket holds the most overdue items, carrying the highest risk of non-payment. These receivables get the strongest collection actions (final demands, holds, escalation, possible legal/collection agency) and the highest provisioning rates, and are the leading candidates for write-off if recovery efforts fail.

Real-world example Items in the 90+ bucket are escalated to a collections agency and provided for at a high loss rate pending recovery.

Common follow-ups: Why provide most heavily for 90+ items? | When does a 90+ item get written off?

Collections & Bad Debts Credit Control Aging Analysis

How do you read an AR aging summary at a glance?

Beginner

Scan the total outstanding, then the distribution across buckets: a high proportion in current is healthy; growing later buckets signal collection problems. Compare customers to spot concentration, and watch the 90+ column for bad-debt risk. Trends over months matter more than a single snapshot.

Real-world example A manager sees 70% current and a small, stable 90+ bucket and concludes collections are under control.

Common follow-ups: What proportion in 'current' is healthy? | Why watch trends over snapshots?

Collections & Bad Debts Credit Control Aging Analysis

What is 'best possible DSO' and how does it differ from standard DSO?

Intermediate

Best possible DSO (BPDSO) uses only current (not-yet-overdue) receivables: (Current AR / Credit Sales) x days. It represents the DSO achievable if all customers paid exactly on terms. Comparing actual DSO to BPDSO shows the collection gap caused by overdue balances, isolating collection performance from sales terms.

BPDSO = (Current AR / Credit Sales) x Days.
Actual DSO 45 vs BPDSO 30 -> 15-day gap from overdue accounts.

Real-world example A 15-day gap between DSO and BPDSO quantifies exactly how much overdue collection is costing in tied-up cash.

Common follow-ups: What does the DSO-BPDSO gap represent? | Why exclude overdue items in BPDSO?

Credit Control Collections & Bad Debts Aging Analysis

How does disputed AR distort aging and what should you do about it?

Intermediate

Disputed invoices sit in the aging as overdue even though the customer is withholding payment pending resolution, overstating collectible overdue balances and understating collection performance. Flagging disputes separately (a dispute/deduction status) gives a truer view and directs effort to resolving the dispute so the cash can flow.

Real-world example Tagging $40k of disputed invoices separately reveals that 'true' overdue AR is far lower, refocusing the team on dispute resolution.

Common follow-ups: Why separate disputes in aging? | Who resolves a disputed invoice?

Cash Application Collections & Bad Debts Aging Analysis

How can you forecast cash collections from an aging report?

Advanced

Apply historical collection-probability curves to each bucket (e.g., current pays ~95% next month, 31-60 ~70%) to project when outstanding balances will convert to cash. Layering these roll-rates over the aging produces a weekly/monthly cash-inflow forecast that treasury uses for liquidity planning.

Expected next-period cash = sum(bucket balance x expected pay rate).
E.g., 100k current x 95% + 30k (31-60) x 70% = 95k + 21k = 116k.

Real-world example Applying roll-rates to the aging gives treasury a reliable projection of next month's receipts for cash planning.

Common follow-ups: What is a roll-rate? | How does this feed liquidity planning?

Cash Application Collections & Bad Debts Aging Analysis

What does it mean when receivables are 'current' versus 'past due'?

Beginner

'Current' means within the agreed payment terms—not yet due—so no action is needed. 'Past due' means the due date has passed without payment, triggering collection activity. The split, based on due-date aging, separates normal open balances from those needing follow-up.

Real-world example An invoice on Net 30 is 'current' for 30 days, then becomes 'past due' and enters the collections cadence.

Common follow-ups: What determines current vs past due? | When does collection activity start?

Collections & Bad Debts Credit Control Aging Analysis

How does aging support inventory of unapplied credits on customer accounts?

Intermediate

Aging can include credit balances and unapplied cash, not just debits. Surfacing aged credits ensures they are applied to open invoices or refunded rather than forgotten, which otherwise understates what customers really owe and can create unclaimed-property (escheatment) obligations for very old credits.

Real-world example An aging review finds a two-year-old $900 customer credit that is applied to open invoices instead of sitting idle.

Common follow-ups: Why track aged credit balances? | What is escheatment?

Cash Application Reconciliations Aging Analysis

What is a weighted-average days overdue and why is it useful?

Beginner

Weighted-average days overdue weights each overdue balance by its size, giving a single figure that reflects how late money is on a dollar-weighted basis. It's more meaningful than a simple average because a large, slightly-late balance matters more than a tiny, very-late one.

Real-world example A weighted-average of 18 days overdue signals the bulk of late money is only moderately late, guiding a measured response.

Common follow-ups: Why weight by balance size? | How does it differ from a simple average?

Collections & Bad Debts Credit Control Aging Analysis