What each Aiwyn report covers, including date scope, aging schemes, and metrics that may not be directly comparable across reports.
Date scope by report
| Report | Date chip | Default | Date type / scope | History range |
|---|---|---|---|---|
| Engagement Performance | Date | This year | Sent Date by default; can switch to Created Date or Executed Date | Engagements created in the current year plus four prior years |
| Billing Performance | Date | This year | Varies by tile: invoice date for billed tiles; WIP logged date for Unbilled WIP, Unapplied Progress, and logged-hours tiles; payment date for Collected (Receipts) | Current year plus two prior years, using each tile's date |
| Project Performance | Date | Last month | Project target end date | Projects with a target end date in the current year plus three prior years; projects without a target end date are excluded |
| Employee Performance | Date | This year | Invoice date for Realization Rate and Billing Effective Rate; WIP logged date for hours; week start date for Target Attainment | Current year plus four prior years |
| Payment Performance | Selected Date | This year | Payment Date by default; can switch to Deposit Date | Current year plus two prior years |
| Payment Failures | Failed on Date | Last 30 days | Failed-on date | Current year plus one prior year |
| Outstanding AR | Date | All invoices dated before today | Invoice transaction date; Outstanding AR Over Time uses week start date | No limit for current balances; Over Time starts with the week of January 6, 2020 |
| Collections | Statement Date | Previous month | Statement date | From October 8, 2025; firms on Collections V2 have data from their upgrade date |
| Undelivered Email Insights | Sent Date | Last 30 days | Email event date, shown as Sent Date | From October 8, 2025; retains the current and prior calendar year, so the oldest dates begin dropping off January 1, 2027 |
Date presets are defaults, not maximum ranges. Users can choose any range within the history retained for that report. “Last 1 Month” means the previous calendar month, including for Collections and Project Performance.
Some visuals ignore the report's Date filter: Engagements Executed by Year and Engagements by Month in Engagement Performance; WIP Aging Summary in Billing Performance; and Active Projects Over Budget in Project Performance. Outstanding AR shows current unpaid balances, not a balance as of a selected past date.
Aging buckets by report
| Report | Chart or filter | Buckets |
|---|---|---|
| Outstanding AR | AR Aging Summary; AR Aging Bucket | 0–30, 31–60, 61–90, 91–120, 121–150, 151–180, Over 180 days |
| Billing Performance | WIP Aging Summary; WIP (Net) Aging Buckets | 0–30, 31–60, 61–90, 91–120, 121–150, 151–180, Over 180 days |
| Collections | Payment Rate by Bucket; Aging Bucket | 0–30, 31–60, 61–90, 91–120, Over 120 days |
Outstanding AR ages each invoice from its invoice date to today. Billing Performance ages each eligible WIP entry from its WIP logged date to today; only time and expense WIP with a remaining unbilled value counts. The WIP Aging Summary always shows all current unbilled WIP, regardless of the Date filter.
Collections uses a different aging basis, not a rollup of Outstanding AR. When a statement is sent, its bucket is set by the most overdue invoice on that statement, measured in days past due. The bucket does not change afterward; statements with nothing past due have no bucket. Firms can rename Collections buckets, but cannot change their day ranges.
Metrics and comparability
| Metric | Reports | Definition and comparison notes |
|---|---|---|
| Realization Rate | Billing Performance; Employee Performance | Same formula in both reports: billed time fees ÷ (billed time fees + time write-offs). Counts submitted time only; excludes expenses and progress billing. Results can differ because the reports retain different history. |
| Billing Effective Rate | Billing Performance; Employee Performance | Same formula in both reports: billed time fees ÷ hours billed on that time. Counts submitted time only; excludes expenses and progress billing. Results can differ because the reports retain different history. |
| Outstanding AR | Billing Performance; Outstanding AR | The Billing Performance tile is filtered by invoice date but shows each invoice's current unpaid balance—not a historical balance as of the selected date. Its default of This year shows today's unpaid balance on invoices dated this year. The Outstanding AR report defaults to all invoices dated before today, showing the firm's full current balance. |
| Billable Hours | Employee Performance; Billing Performance insights | Billing Performance counts submitted time entries only and excludes operational entries. Employee Performance Billable Hours includes draft and submitted entries; its Non-Billable Hours also include operational entries such as PTO. The reports' hours therefore will not match. |
| Unapplied Progress; Unallocated Payments | Billing Performance | These are different measures. Unapplied Progress is logged progress-billing value not yet invoiced, based on WIP logged date. Unallocated Payments is the amount received but not applied to an invoice, based on payment date. Both appear only on Billing Performance. |
| Median Days to Bill; Median Days Sales Outstanding | Billing Performance; Outstanding AR | These measure consecutive, different stages: work completion to invoice sent; then invoice sent to payment received. |
Notes for interpreting reports
- Billing Performance metrics that use time count submitted entries only; operational entries are excluded. Employee Performance's Billable Hours includes both draft and submitted entries, while its Non-Billable Hours can include operational entries such as PTO.
- Realization Rate and Billing Effective Rate use the same formulas in Billing Performance and Employee Performance. Both count submitted time only and exclude expenses and progress billing. The reports can still show different results because Billing Performance retains invoices from the current year plus two prior years, while Employee Performance retains work logged in the current year plus four prior years.
- Outstanding AR is a current-balance report. Its Date filter selects invoices by transaction date; it does not reconstruct the unpaid balance as of a past date. Outstanding AR Over Time uses week start date and begins with the week of January 6, 2020.
- Collections data begins October 8, 2025, or on the firm's Collections V2 upgrade date. Its statement buckets are fixed when statements are sent and are not interchangeable with Outstanding AR's invoice-aging buckets.