Why the hours are the product
A consulting firm sells time. Whatever the engagement is called, the money comes from hours that a customer agrees to pay for, at a rate, on a project. If the hours are wrong, late or missing, the invoice is wrong, the margin is a guess and the plan for next month is built on nothing.
That is why "time tracking for consultants" is a bigger topic than a timer. A consultant timesheet answers four questions at once: who worked, on which project, for how many hours, and whether the customer pays for them. Everything else a firm wants to know follows from those four.
The sections below follow the hours down a chain of five parts. Each part works on its own, and each adds one thing to the hours that the part before it recorded.
The chain at a glance
| Part | What it adds to the hours | Price |
|---|---|---|
| Timesheet | Records them: logged, approved, locked, with utilisation | Free for every user |
| Project management | Puts them on projects, budgets and invoices | EUR 9.99 per user with access, per month |
| Costs and rates | Gives every hour a cost price and a rate | EUR 1 per employee, per month |
| Allocation and Resources | Plans them ahead | EUR 1 per employee, per month |
| Standard hours | Compares them with each employee's schedule | EUR 1 per employee, per month |
You do not need all five. A firm that only wants hours for payroll stops at the first row and pays nothing. The rest is there for the questions a growing firm asks next.
Link one: the free Timesheet records the hours
Every employee registers time with a timer, a week sheet, from and to times, or the total. Meetings from Outlook or Google Calendar and a small app on the computer suggest time, and the employee approves each suggestion. Expenses go in with their receipts.
Then the hours are checked and approved. A check before the week is sent points out empty days and missing fields. Approvers approve or reject per project and week, in one or more steps. Approved time is locked, and a payroll period sent to payroll is locked for good.
This is where billable hours tracking starts. The Timesheet shows utilisation: billable hours divided by the hours employees had available, per employee, team and week. Available hours follow working hours and holidays. For the metric itself, see utilisation rate in consulting.
Link two: Project management puts the hours on projects, budgets and invoices
With Project management, the team registers time on the tasks of each project in the free Timesheet. The project then shows what is spent and what is left.
Time against the plan
Each task shows its estimate, the time spent and what is left. A budget in hours has a warning at the limits you choose, and a date when the budget runs out at today's pace.
Work outside the plan
Time on new tasks after the plan is locked is collected in one place, as a basis for a change request.
Invoices from the plan
A billing plan invoices on milestones or at fixed intervals. Invoices can need approval in several steps before they are sent as PDF, with reminders until they are paid.
Cashflow
Expected payments per week or month, from billing plans and invoices, with overdue amounts flagged.
Hourly billing and the money side of a project, such as budget, forecast and margin, need the next part.
Link three: Costs and rates give every hour a cost price and a rate
An hour in the timesheet is only an amount of time until it has a price on it. With Costs and rates, Matrix works out a real cost per hour for each employee. For permanent staff, the cost price is the salary divided by billable hours, plus a share of the company expenses. The cost price of the working day is saved on the time entry when it is created and again when it is approved, so a later change does not rewrite the past unless you choose to recalculate.
On the other side, each project has price groups, each with an hourly rate, and each employee sits in a price group. If you choose a group whose rate is below an employee's cost price, Matrix warns you that it can give negative margins. With a margin target, it also warns when the rate is under the target.
With Project management too, this is where project cost tracking becomes a number on the project: budget, forecast and margin, each explained, and the project list can show revenue, forecast total cost and result. Hours registered become costs in the cashflow forecast at the cost price of the day. For the metrics to track, see project profitability tracking.
Link four: Allocation and Resources plans the hours ahead
Timesheets look back. Allocation and Resources looks forward. You book employees on projects in hours or percent, see who is booked and who is free per day, week or month, and get a warning before someone is overbooked.
- Capacity follows each employee's working hours and their country's public holidays, so a booking does not land on a day off.
- Tentative bookings hold an employee while a proposal is with the customer, and you choose whether they count in capacity.
- Placeholders book a role before you know who fills it, and can be replaced with an employee later.
- Skill gaps show where you fall short, for example how many hours of a skill you lack next quarter.
- Fixed reports on capacity and utilisation can be downloaded as a file.
The plan and the timesheet then answer each other: what you booked, and what people really logged.
Link five: Standard hours compares the hours with the schedule
People do not all work the same week. With Standard hours, each employee has a weekly schedule, and Matrix compares the time registered each day with it, showing the difference over or under. Differences are explained in lines with tags of your own, which go on to payroll. Missing time can remind the employee the day after a working day with less time than the schedule.
It also makes the timesheet more accurate in the Timesheet itself. A week check and reminders follow each employee's own schedule, and utilisation is measured against it.
Where hours go wrong in consulting firms
The same few problems turn up in most firms that bill by the hour. Each has a place in the chain where it can be caught.
| What goes wrong | Where it gets caught |
|---|---|
| Hours registered late, or not at all | The Timesheet: the week check points out empty days, and reminders cover the unsent week and a forgotten timer |
| Time on a project after the budget is used up | Project management: a budget in hours with a warning and a run-out date |
| Work done that is not in the plan | Project management: time on new tasks after the plan is locked is collected for a change request |
| A rate that does not cover the cost | Costs and rates: a warning when a price group's hourly rate is below the employee's cost price |
| Someone booked for more than they can do | Allocation and Resources: a warning before overbooking |
| Overtime nobody planned for | Standard hours: the difference between registered time and the schedule, each day |
Seen as a chain, the parts are not separate tools to buy. They are the answers to six questions a consulting firm keeps asking, in the order they usually come up.
Where to start
Most firms start in the same place: the free Timesheet, for everyone. After a month of real hours, the next question usually shows itself.
- "Which projects are over budget?" Add Project management for the users who manage projects.
- "Are we making money on this project?" Add Costs and rates.
- "Who is free in March?" Add Allocation and Resources.
- "Why does overtime keep showing up?" Add Standard hours.
Each of these is a separate decision with a 7-day free trial. You can see all the prices on the prices page. For the wider picture of billable time, see billable hours tracking software.