Matter-level lockup day KPI tracking is a vital part of ayora’s alerts functionality. Lockup days are defined as WIP days + Debtor days.
NB: Individual-level KPIs represent aggregate KPIs for the matters on which the fee earner is the Matter Partner.
WIP days
WIP days are computed on a rolling 60-day lookback basis:
- Billed in the last 60 days
- WIP days for that entry = time taken to bill
- No billing
- WIP days = time from that entry to now
Weighting in each case is time booked amount.
The above are predicated on ayora identifying time entries with earliest time billed in the last 60 days, or which have no billing. To achieve that, for every time booked entry, ayora finds the earliest time it appears on WIP billing, if at all.
Debtor days
Debtor days are computed on a rolling 60-day lookback basis. Ayora computes debtor days using two approaches:
- Receipt events in the last 60 days
- Debtor days = days between receipt event and the initial billing date
- Weight is receipt amount
- Bills with unpaid debt
- Debtor days = days since the initial billing date to today
- Weight is unpaid bill amount
The above are predicated on ayora computing two key parameters:
- The initial billing date (the first date on which there was a bill issued (bill not equal to 0))
- Total unpaid bill to date (calculated from the rolled up summary of that bill - total bill, total receipt, and total write-off)