Timesheets in consulting firms: where the hours go and what they cost

In a consulting firm the hours are the product. A timesheet that only records them stops short. Here is the chain from the free Timesheet to project budgets, cost prices, plans and schedules, and what each link adds.

9 min read

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

PartWhat it adds to the hoursPrice
TimesheetRecords them: logged, approved, locked, with utilisationFree for every user
Project managementPuts them on projects, budgets and invoicesEUR 9.99 per user with access, per month
Costs and ratesGives every hour a cost price and a rateEUR 1 per employee, per month
Allocation and ResourcesPlans them aheadEUR 1 per employee, per month
Standard hoursCompares them with each employee's scheduleEUR 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 wrongWhere it gets caught
Hours registered late, or not at allThe 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 upProject management: a budget in hours with a warning and a run-out date
Work done that is not in the planProject management: time on new tasks after the plan is locked is collected for a change request
A rate that does not cover the costCosts 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 doAllocation and Resources: a warning before overbooking
Overtime nobody planned forStandard 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.

Questions and answers

Start with the hours

Log your first week in the free Timesheet. Add the next link when you need it.

Open the live demo

Free. No card needed.