This article applies to Aiwyn Practice.
This article explains how the utilization percentage on your timesheet is worked out, and why it can differ from the utilization figures in reports.
Utilization compares submitted billable and non-billable hours
Utilization is your submitted billable hours divided by your submitted billable plus non-billable hours, shown as a percentage:
Utilization = billable hours ÷ (billable hours + non-billable hours) × 100
Operational time, time off and draft entries are excluded from the calculation. For example, 24 submitted billable hours and 8 submitted non-billable hours give 75% utilization, regardless of any operational time or time off in the same period.
The percentage appears in the summary row at the top of the timesheet, beside the Billable metric. The summary row shows the billable hours and the percentage together, for example "0.0 — 0% utilization".
The calculation uses submitted hours, not a fixed number of working hours. It isn't measured against a 40-hour week, a staff member's capacity or a utilization target. The timesheet doesn't currently support configurable capacity or utilization goals.
The figure answers one question: of your submitted billable and non-billable time, how much was billable work?
Only submitted billable and non-billable time affect utilization
Every entry on the timesheet falls into a category, and the summary row totals each category separately. Total Hours includes all submitted time: billable, non-billable, operational and time off. The utilization calculation uses only the submitted billable and non-billable categories.
| Category | What it is | Where it counts in utilization |
|---|---|---|
| Billable | Client work tied to invoices | Numerator and denominator; also included in Total Hours |
| Non-billable | Client work that isn't going to be billed, such as goodwill or fix-up time | Denominator only; also included in Total Hours |
| Operational | Internal work not tied to any client, such as staff meetings, training or firm admin | Excluded from utilization; included in Total Hours |
| Time off | Paid time off, sick leave, holidays and other non-working time | Excluded from utilization; included in Total Hours |
Time off and operational time count toward Total Hours, but neither affects utilization. Time off is always excluded from utilization; this doesn't depend on a firm reporting configuration.
Draft entries are excluded from both submitted Total Hours and the utilization calculation. The Total Hours metric shows draft hours separately, for example "32.5 + 7.0 draft".
The summary color shows submission status, not utilization performance. Orange means some time entries are still in draft; green means all time entries have been submitted. The colors don't indicate whether a utilization target has been met.
The Billable checkbox on the work code determines whether time entries using that code are billable. It is unchecked by default, so a user must select it when setting up a billable work code. For more on the categories, see How Aiwyn classifies billable, non-billable and operational time.
A full week can show 0% utilization
If you haven't submitted any billable time, utilization reads 0%. This is true even when Total Hours shows a full week of non-billable or operational work. The timesheet isn't empty and nothing is broken. None of the submitted time was billable.
Leaving non-billable time unsubmitted can make utilization look higher
Submitted non-billable hours increase the denominator without increasing billable hours. If non-billable time goes unlogged or stays in draft, utilization can look higher even though no extra billable work was done. Record and submit all your time to give an accurate picture.
Operational time and time off don't affect the percentage, whether or not they have been submitted.
Recording non-billable work as billable also raises the figure, but it has a cost. Approved billable time flows into WIP, where it waits to be billed on a draft invoice.
The percentage covers only the period and staff on screen
The summary row totals the selected date range. When you change the view to Day, Week, Month or Custom, or move to another period, the figure recalculates. Week is the default view and runs from Sunday through Saturday. The week start can't be adjusted.
A short period can swing more than a long one. A day with 4 submitted billable hours and 4 submitted non-billable hours shows 50% utilization. Across a longer period, the figure reflects all submitted billable and non-billable hours in that range. Operational time, such as internal training, doesn't change the percentage.
The staff filter defaults to My Own. Managers and partners can select All Staff or a named staff member. The metrics update to match the filter. All Staff shows utilization across all staff for the selected period.
Check the summary row before you submit. If billable hours are lower than you expect, you can fix the entries before the timesheet goes for approval. For how to submit, see Submit and correct a timesheet.
Billing rounding changes hours before they're counted
Time Entry Rounding for Billing rounds project and task time up when an entry is saved, whether the time is billable or non-billable. Total Hours uses these rounded project and task hours. Operational entries aren't rounded, so Total Hours uses their actual hours. For the rounding options, see Time settings reference.
Reports can show a different figure for the same person
The employee performance report works out its figures differently from the timesheet. For the full list of the report's metrics, see Employee performance report reference. Three differences explain most gaps.
The report can measure against a 40-hour week. Besides the logged-hours percentage, called Utilization, the report has a capacity-based figure called Target Attainment: billable hours divided by workable hours. Workable hours assume a 40-hour, five-day week of 8-hour days, with no adjustment for time off or holidays. A week of leave lowers Target Attainment even if every hour logged was billable. The timesheet percentage doesn't work this way.
The report uses a different period and may place hours differently. The report assigns hours by WIP logged date and defaults to the current calendar year. Target Attainment is worked out by month, so a date range that starts or ends mid-month includes the whole of each month. Time entries use the user's time zone; firms can't currently set a time zone for Practice. [SME to confirm: which date the timesheet uses to place an entry in a period.]
The report uses its own scope and filters. It includes both draft and submitted time and operational entries, and its Created by Aiwyn filter defaults to Yes. Data can take around an hour to reach reports, so a figure you check right after logging time may not match yet.
Other reports can count billable hours differently again. See Aiwyn KPI glossary.
Related
- How Aiwyn classifies billable, non-billable and operational time
- Timesheet screen and field reference
- Work with the timesheet view
- Submit and correct a timesheet
- How timesheet rules shape what staff can log
- Time settings reference
- Employee performance report reference
- Who uses the employee performance report and what for
- Aiwyn KPI glossary