What the outstanding AR report contains.
Shows the firm's total outstanding accounts receivable, how long invoices have been outstanding, how AR ages, and every unpaid invoice — with breakdowns by client, partner, and office.
This report shows the current picture rather than activity over a period. The only element that responds to the date filter is the Outstanding AR Over Time chart.
Tabs
| Tab | What it shows |
|---|---|
| AR KPIs and Charts | Firm-wide AR tiles, the AR Aging Summary, and Outstanding AR Over Time |
| Client AR Insights | Outstanding AR by client |
| Partner AR Insights | Outstanding AR by partner |
| Office AR Insights | Outstanding AR by office |
| Unpaid Invoices | Every unpaid invoice |
AR KPIs and Charts
KPI tiles
| KPI | Definition |
|---|---|
| Outstanding AR | Total amount of outstanding accounts receivable |
| Median Days Sales Outstanding | Median days sales outstanding, based on the invoice transaction date or the most recent partial payment date. Days sales outstanding is worked out for each invoice, then the median is taken across all invoices — see below |
How days sales outstanding is calculated for each invoice
- For an invoice with a partial payment, days sales outstanding is the current date minus the last payment date.
- For an invoice with no payment to date, days sales outstanding is the current date minus the invoice transaction date.
Charts
| Chart | Type | What it shows |
|---|---|---|
| AR Aging Summary | Bar | Outstanding AR by aging bucket, based on the invoice transaction date relative to today. This chart shows all outstanding AR regardless of the date filter. It measures the age of accounts receivable — "How old are our current unpaid invoices?" |
| Outstanding AR Over Time |
Line | Total outstanding AR by week, based on the invoice due date. The date filter applies only to this chart |
Aging buckets
The AR Aging Summary and the three Outstanding AR Insights tables use these aging buckets:
- 0 to 30 days
- 31 to 60 days
- 61 to 90 days
- 91 to 120 days
- 121 to 150 days
- 151 to 180 days
- Over 180 days
Insights tabs
| Tab | Table | What it shows |
|---|---|---|
| Client AR Insights | Client Outstanding AR Insights | Outstanding AR for each client |
| Partner AR Insights | Partner Outstanding AR Insights | Outstanding AR for each partner |
| Office AR Insights | Office Outstanding AR Insights | Outstanding AR for each office |
| Unpaid Invoices | Unpaid Invoices | A list of all unpaid invoices |
Client Outstanding AR Insights columns
- Client name
- Billing contact email
- Client number
- Client group
- Client status
- Partner name
- Billing manager name
- Partner office
- AR balance
- Median DSO
- AR balance in each aging bucket listed above
Partner Outstanding AR Insights columns
- Partner name
- Partner office
- AR balance
- Median DSO in days
- AR balance in each aging bucket listed above
Office Outstanding AR Insights columns
- Office name
- AR balance
- Median DSO in days
- AR balance in each aging bucket listed above
Unpaid Invoices columns
- Client name
- Client number
- Client group
- Client status
- Partner name
- Billing manager name
- Invoice number
- AR balance amount
- DSO number of days
- AR aging bucket