AR ageing

Age alone does not explain what happens next.

Read overdue concentration alongside the customer context, owner and action that can change it.

14-day free trial, no card needed.
In brief

An AR ageing report groups open customer invoices by how long they have remained unpaid, while days sales outstanding summarises collection speed over a period. Invoicera pairs receivables visibility with reminder, exception and ownership context so finance can act on the balances behind the totals. It does not claim predictive credit-risk scoring.

Recognise the work

The report is accurate. The action is still missing.

A 61–90 day bucket can contain a forgotten reminder, a disputed invoice and a payment awaiting a match. The bucket measures age; it cannot replace the operating state of each receivable.

  1. 01

    The oldest balance is not always first

    A younger high-value exception may require a decision before an older routine invoice.

  2. 02

    DSO moves without explaining why

    The period metric changes, but the underlying invoices still need customer and owner context.

  3. 03

    Paid work remains reported as open

    An unmatched payment keeps the invoice in ageing until reconciliation resolves it.

How it works

Move from portfolio signal to invoice action.

Ageing and DSO help finance locate concentration; the receivable record explains what to do about it.

  1. 01

    Measure

    Group open balances by age and calculate collection speed over a defined period.

  2. 02

    Explain

    Inspect the reminder stage, dispute, promise or payment evidence behind the material balances.

  3. 03

    Assign

    Give each actionable exception an owner and review the metric again after resolution.

A practical decision rule

Use age to locate work. Use state to choose it.

The same ageing bucket can contain different decisions, so the portfolio view and invoice-level queue must remain connected.

SituationDecisionControl to retain
01Current or 1–30 daysConfirm routine pathDue date and reminder stage
0231–60 daysReview customer responsePromise, exception and owner
0361+ daysPrioritise resolutionEscalation reason and next action

Worked example

A simple DSO calculation

Average accounts receivable
$120,000
Credit sales in 90-day period
$360,000
Period length
90 days
DSO
30 days
($120,000 ÷ $360,000) × 90 = 30 days. Compare like periods and investigate the invoices driving any material change.

Questions buyers ask

Know where this fits.

Each answer stands on its own, including the boundary of what Invoicera does and does not do.

What is an AR ageing report?

An AR ageing report groups open customer invoices by the time they have remained unpaid. Common buckets are current, 1–30, 31–60, 61–90 and more than 90 days overdue. The report shows concentration and timing, but the invoice record is still needed to explain disputes, payment evidence, ownership and the next action.

What is days sales outstanding?

Days sales outstanding, or DSO, estimates how long a business takes to collect credit sales over a defined period. A common calculation divides average accounts receivable by credit sales and multiplies by the number of days. Use consistent inputs and periods; seasonality, billing mix and large invoices can materially change interpretation.

Is the oldest invoice always the highest priority?

No. Age is important, but amount, customer response, dispute status, payment evidence, commitment date and strategic context can change priority. A paid invoice awaiting a match belongs in reconciliation, while a younger material dispute may require immediate ownership. The useful queue combines age with the operational state and assigned owner.

Can ageing predict whether a customer will pay?

Ageing shows how long balances have remained open; it does not by itself predict payment or provide credit-risk scoring. Historical behaviour may inform an organisation’s judgement, but the page does not claim automated risk models. Use the report as an operational signal and retain the evidence behind any separate credit decision.

Why can a paid invoice remain in an ageing report?

An invoice can remain open when payment has arrived but has not yet been matched to the correct record, amount or customer. The ageing view should therefore connect to reconciliation status. Once the payment is verified and applied, the resolved balance should leave the open-receivables population according to the organisation’s process.

Start with the real billing case

Bring the schedule, exception or approval that is hardest to control.

See how Invoicera would run it without moving the ledger out of the system your finance team already uses.

Book a Demo