This report is only available to firms on Aiwyn Practice.
What the billing performance report contains.
Tracks the full billing cycle — work logged, work billed, write-ups and write-downs, unbilled WIP, collections, and outstanding AR — with breakdowns by client, employee, office, service line, project, and invoice.
Report defaults
| Setting | Value |
|---|---|
| Default view period | Current calendar year |
| Default filters | Date: Current Calendar Year; Created by Aiwyn: Yes |
Each KPI responds to its own date basis when you apply the date filter — the table below states the basis for every tile.
Tabs
| Tab | What it shows |
|---|---|
| Billing KPIs and Charts | Firm-wide billing KPI tiles and the WIP Aging Summary |
| Client Billing Insights | Billed and logged-time figures by client |
| Employee Billing Insights | Billed and logged-time figures by logged employee |
| Office Billing Insights | Billed and logged-time figures by office |
| Service Line Billing Insights | Billed and logged-time figures by service line |
| Project Billing Insights | Billed and logged-time figures by project |
| Invoice Billing Insights | Invoice-level detail |
Billing KPIs and Charts
KPI tiles
| KPI | Definition | Date basis (what the date filter applies to) |
|---|---|---|
| Total Billed | Sum of invoice amounts | Invoice transaction date |
| Billed WIP and Expenses | Total amount of billed time and billed expenses | Invoice transaction date |
| Billed WIP | Total amount of billed time | Invoice transaction date |
| Billed Expenses | Total amount of billed expenses | Invoice transaction date |
| Billed Progress | Total amount of billed progress | Invoice transaction date |
| Realization Rate | Percentage of billed time that is revenue after WIP adjustments | Invoice transaction date |
| Billing Effective Rate | Average dollars earned per billable hour, weighted by hours logged | Invoice transaction date |
| Collections | Total amount of payments either pending or deposited into the bank account, including payments not allocated to an invoice. The Created by Aiwyn filter separates payments processed by Aiwyn from those not processed by Aiwyn | Receipt transaction date |
| Outstanding AR | Total outstanding accounts receivable | Invoice transaction date |
| Net WIP Adjustments | Net amount of WIP adjustments applied to billing. A negative amount is an overall write-down; a positive amount is an overall write-up | WIP logged date |
| Median Days to Bill | Median number of days from WIP logged date to invoice transaction date. The number of days is worked out for each WIP record, then the median is taken across all records in the filtered data set. Includes only invoices that have been sent; drafts are excluded. This measures the cycle time from work completion to client billing — "How long until our clients receive invoices?" | WIP logged date |
| Unbilled WIP (Net) | Value of logged work not yet invoiced, excluding unapplied progress | WIP logged date |
| Unapplied Progress | Value of logged progress not yet invoiced | WIP logged date |
| Unallocated Payments | Total amount of unallocated (unapplied) payments — payments that have not been applied to an invoice | — |
| WIP Production | Monetary value of all time logged. Includes both billed WIP and unbilled WIP | WIP logged date |
Charts
| Chart | What it shows |
|---|---|
| WIP Aging Summary | Lifetime unbilled WIP (net) by aging bucket, based on the WIP logged date relative to today. Buckets are 0–30 days, 31–60 days, 61–90 days, 91–120 days, 121–150 days, 151–180 days, and over 180 days. This chart shows all aging WIP regardless of the date filter. It measures the age of unbilled work — "How old is our currently unbilled work?" |
Insights tabs
Every Insights tab has the same two tables, broken out by a different dimension. The Billed Insights table is based on the invoice date; the Logged Time Insights table is based on the WIP logged date.
| Tab | Billed Insights table | Logged Time Insights table |
|---|---|---|
| Client Billing Insights | Billing performance, realization, and billed amounts by client. Use it to track invoicing activity and collections per client | WIP production, billed WIP, and unbilled WIP by client. Use it to assess work in progress and the billing pipeline per client |
| Employee Billing Insights | Billing performance and billed amounts by logged employee. Use it to track each staff member's contribution to invoiced revenue | WIP production, billed WIP, and unbilled WIP by logged employee. Use it to assess each staff member's contribution to the billing pipeline |
| Office Billing Insights | Billing performance and billed amounts by office. Use it to compare invoicing activity and realization across offices | WIP production, billed WIP, and unbilled WIP by office. Use it to compare work in progress and billing pipelines across offices |
| Service Line Billing Insights | Billing performance and billed amounts by service line. Use it to compare invoicing activity and realization across service lines | WIP production, billed WIP, and unbilled WIP by service line. Use it to compare work in progress and billing pipelines across service lines |
| Project Billing Insights | Billing performance and billed amounts by project. Use it to track invoicing activity at the job level | WIP production, billed WIP, and unbilled WIP by project. Use it to assess work in progress and the billing pipeline at the job level |
The Invoice Billing Insights tab has a single table, Invoice Billed Insights: invoice-level detail including billed amounts, outstanding balances, and payment status, based on the invoice date. Use it to review individual invoices and monitor collections.
Related
- Report reference
- Aiwyn KPI glossary
- Aging buckets used in Aiwyn reports
- Employee performance report reference
- Outstanding AR report reference