AR Aging & Collections Dashboard (DSO Template)

Client	Amount	Days overdue
Meridian Health Group	$18,400	72
Bramwell & Co.	$11,200	64
Lodestar Partners	$9,800	58
Ferro Industrial	$7,300	45

For a firm that bills by the hour or on retainer, collections is the difference between a profitable year and a cash crisis in a profitable year. The work is done, the margin is earned, and the money is sitting in somebody else's bank account. An aging dashboard exists to make that visible while it is still fixable.

The four buckets, and which one actually matters

Aging splits receivables by how long each invoice has been outstanding. The preview shows the standard four.

Bucket	What it means	Action
0–30 days	Current, within normal terms	None. Automated reminders only
31–60 days	Past terms, usually a processing problem	Call the AP contact, not the champion
61–90 days	At risk. Something is wrong and nobody has said so	Escalate to a named person, pause new work
90+ days	Assume it is disputed until proven otherwise	Partner-level conversation or collections

The bucket to watch is 61–90, not 90+. By 90 days you already know; the money is either disputed or the client is in trouble, and the outcome is largely decided. The 61–90 bucket is where a fixable problem — a missing PO number, a changed AP contact, a line item that does not match the engagement letter — is still fixable. In the preview, the 60-plus balance grew $6,000 while total AR fell 5%: the headline improved and the risky end got worse.

What DSO is really telling you

Days sales outstanding turns receivables into a time figure: on average, how many days between invoicing and collecting. The 38 days in the preview against net-30 terms means eight days of friction, which is normal and not worth a project.

Read DSO as terms plus friction and it becomes actionable. Under 10 days of friction is process noise. Twenty-five days of friction is a process problem, and almost always a problem on your side of the invoice rather than the client's — the wrong contact, the wrong reference, or an invoice that arrived after the client's payment run had closed for the month.

One caution. DSO is an average and averages conceal exactly what you need to see. The $18,400 invoice at 72 days in the preview barely moves a DSO built on $318,000 of receivables. Always read DSO next to the aging table rather than instead of it.

The dunning schedule that moves the number

Most collections processes begin when an invoice is already late, which is the point at which it has entered somebody else's payment run and cannot move until the next one. Starting before the due date is the single highest-leverage change available.

Seven days before due — a polite confirmation that the invoice was received and is scheduled. This is the step that catches processing failures while they can still be fixed.
On the due date — automated, to the AP inbox and the engagement contact.
Seven days past — a person, not a system, asking whether there is a query on the invoice.
Fourteen days past — the engagement lead, by phone. Email has already failed twice by this point.
Thirty days past — partner to client principal, with a decision about whether work continues.

Automate the first three and escalate the last two to named people. A schedule nobody owns is a schedule that stops at step two.

Fix the invoice before you chase it

A material share of what looks like late payment is not late payment at all — it is an invoice the client's AP function could not process. The usual causes are a missing purchase order number, the wrong billing contact, a description that does not match the engagement letter, or no remittance instructions. Each sends the invoice into a queue nobody is measuring.

Capture the PO number and AP contact at engagement signature rather than at first invoice, send to an AP inbox as well as your day-to-day contact, and match line items to the engagement letter's wording. This is unglamorous and it outperforms every collections technique that follows it.

What the cash is worth

At the preview firm's run rate, cutting DSO from 38 days to 30 releases roughly $67,000 of cash — once, permanently, without dilution or a lender. That is the honest framing: improving collections is a one-time working-capital gain rather than recurring revenue, but it arrives faster and cheaper than any other source of cash a services firm has.

Running the process, rather than reporting on it, is what AR and AP management covers. Bookkeeping for agencies has more on how services firms set the ledger up to produce this view in the first place.

Frequently asked questions

What is an AR aging dashboard?+

A view that splits outstanding receivables into buckets by how long each invoice has been unpaid — typically 0–30, 31–60, 61–90 and 90-plus days — alongside days sales outstanding and the largest overdue invoices. It exists to surface collection problems while they can still be fixed.

What is a good DSO for a professional services firm?+

Read it as your payment terms plus friction rather than against a universal target. On net-30 terms, 30–40 days is normal and under ten days of friction is process noise. A DSO 25 days past your stated terms is a process problem, and usually one on your side of the invoice.

Which aging bucket should I focus on?+

The 61–90 day bucket. By 90 days the outcome is largely decided — the invoice is disputed or the client is in difficulty. At 61–90 days the cause is usually still a fixable processing failure such as a missing PO number or a changed AP contact.

How do I reduce DSO quickly?+

Invoice on the engagement date rather than batching at month end, fix what is on the invoice so AP can process it, and start dunning seven days before the due date rather than after it. Those three move the number more than any escalation process applied after an invoice is already late.

Professional services collections dashboard

AR aging, by bucket

Top overdue invoices