Utilization report
The Utilization report shows, for each person, the hours they recorded in a period, how many of them were billable, and their billable utilization against their goal. Use it to see who is below target before the month closes, and to check that time is recorded as billable or non-billable as it should be.
Jump to:
- Run the report
- What the report shows
- How billable utilization is calculated
- Print or export
- Example: checking August
Run the report
- Open Reporting and click 01. Utilization report, under 5. Administrative in EVX Software's suggested setup.
- Choose the options below.
- Click Generate report.
| Option | What it does |
|---|---|
| Date range | The period: Today, This week, Last week, This month, Last month, or Select dates... for your own dates. The report counts the time entries whose start date falls in the period. Last month is selected when the report opens. |
| Total hours to consider | What billable hours are compared with. Contract hours uses each person's Contract hours per day times the working days of the period. Actual total hours uses the hours they recorded. |
| Working days of the week | Monday to Friday counts five working days a week. Set in general config option uses the working days in your firm's settings. |
| Include contract hours | Adds a first column with each person's contract hours for the period. |
| Exclude users without utilization goal | Leaves out the people who have no utilization goal. |
Each person's Contract hours per day and Utilization goal are on the Basic data tab of their user form. See Users.
What the report shows
One row per person, with a Total row at the end:
| Column | What it shows |
|---|---|
| Name | The person. |
| Contract hours | Their contract hours for the period, when Include contract hours is ticked. |
| Total | All the hours they recorded in the period. |
| One column per labor category group | Their hours in each group, such as 1. Billable, 2. Indirect Labor, 3. Preliminary & Proposal work, and 4. Time off in the suggested setup. |
| Without Labor categories | Hours with no labor category. They still count in Total. |
| Billable | Hours recorded as billable. Each time entry decides whether it is billable. |
| Non billable | Hours recorded as non-billable. Time off counts in neither column. |
| Billable utilization | Billable hours as a percentage of the hours they could have worked. See the formula below. |
| Utilization goal | The person's goal, from their user form. |
| Variation | Billable utilization minus the goal. |
A billable utilization below the person's goal shows in red, and so does its variation.
Each person's billable utilization is compared with their goal.
How billable utilization is calculated
Time off is taken out of the hours the person could have worked, so leave does not lower their utilization.
| Total hours to consider | Billable utilization |
|---|---|
| Contract hours | Billable hours / (contract hours − time off hours) |
| Actual total hours | Billable hours / (total hours − time off hours) |
Time off hours are the hours recorded on labor categories with Is time off set. See Setting up labor categories.
Variation = billable utilization − utilization goal. A person with no goal has a variation equal to their billable utilization.
Print or export
Use Print, CSV, PDF, or Excel at the top of the report. See Exports.
Example: checking August
At the start of September, an operations manager runs the report for Last month with Contract hours. August had 21 working days, so a person with 8 contract hours a day could work 168 hours. A field technician recorded 8 billable hours: 8 / 168 is 4.76%, in red against her 80% goal. Her timesheet shows she spent most of August on a site visit she never recorded, and she adds the hours before invoicing.
What you can do next
- Time reports for the hours recorded by person, project, or period.
- Billable and non-billable time for how each time entry is marked billable.
- Users to set each person's contract hours and utilization goal.