This article applies to all firms. The Collections report area is available to all firms.
This article explains what the key Collections metrics measure and how to interpret them. For Billing metrics, see How the Billing report metrics are defined.
Median DSO measures how far overdue open invoices are
Firms currently see a Median Days Sales Outstanding tile on Outstanding AR and a Median DSO column in the Client, Partner, and Office tables. Both measure the median number of days open invoices are past their due date. Invoices that are not yet due count as 0 days. A higher value means the typical open invoice is further past due; a lower value means open invoices are near their due dates or not yet due. The ratio-based DSO (Trailing 12 Months) metric is not currently live, so that definition does not describe the metrics firms see today.
Read billing speed and overdue AR as separate parts of the cash cycle
Median Days to Bill is a separate Billing metric: it measures the time from WIP logged date to invoice transaction date. Billing reports are available only to firms using Aiwyn Practice. For firms with access to Billing, Median Days to Bill tracks the time before invoicing, while Median DSO tracks how far open invoices are past due. They describe different parts of the cash cycle and should not be added together.
Neither number on its own tells you where a delay is:
- Long Median Days to Bill, low Median DSO: Work is taking longer to invoice, while the typical open invoice is near its due date or not yet due. The WIP Aging Summary on Billing Performance shows how old unbilled work is. A low Median DSO alone does not mean every client is paying promptly.
- Short Median Days to Bill, high Median DSO: Invoicing is relatively quick, but the typical open invoice is past due. The AR Aging Summary on Outstanding AR and the Collections report can help identify the balances and reminder responses involved.
- Both high: Both longer time to invoice and overdue open invoices may need attention. Work on them separately: one calls for a change to the billing process; the other may call for client outreach.
AR Aging Summary follows the Date filter
The Date filter applies to the invoice transaction date. By default, it is set to before today, so the chart shows all outstanding AR. Each invoice’s age is the number of days between its transaction date and today. See Aging buckets used in Aiwyn reports for the bucket boundaries.
Payment Rate measures payment activity on invoices included in reminders
The Collections report measures payment activity for invoices included in Smart Statement reminders.
Payment Rate is the percentage of invoices on Smart Statement reminders that have had at least one payment applied. There is no time window.
The metric records payment activity for invoices included in reminders; it does not prove that a reminder caused a payment. Read Payment Rate as a signal about payment activity, not as proof that reminders produced the payments.
Payment Rate by Bucket shows results by the statement’s assigned bucket
Payment Rate by Bucket groups Payment Rate by the bucket assigned to each statement. The bucket is fixed when the statement is created; it does not move into an older bucket as time passes.
Each statement takes the bucket of its most overdue invoice. The invoice’s days past due are measured on the statement-generation date for legacy (V1) statements and on the sent date for current (V2) statements. The fixed ranges are 1–30, 31–60, 61–90, 91–120, and over 120 days past due. A firm’s Smart Statement bucket settings control the email content for each bucket, not these day ranges. If every invoice on a statement is not yet due, the statement has no bucket and does not appear in Payment Rate by Bucket.
The AR Aging Summary on Outstanding AR uses a different basis: it ages invoices from their transaction date to today. As a result, an invoice’s bucket on that chart may differ from the bucket assigned to its Smart Statement.
Multiple Reminder Rate shows payment after a second reminder
Multiple Reminder Rate is the percentage of invoices that received a second reminder, were still unpaid between the first and second reminders, and were then paid after the second reminder. It is calculated as invoices paid after the second reminder divided by invoices that received a second reminder and were not paid between the first and second reminders, times 100. It is measured per invoice, not per client.
A high rate means a larger share of invoices that remained unpaid after the first reminder were paid after a second reminder. The metric alone does not prove that the second reminder caused the payment.
Related
- Outstanding AR report reference
- Smart Statements report reference
- Aging buckets used in Aiwyn reports
- How Smart Statement reminders change payment behaviour
- Billing performance report reference