Timesheets to Margin: How Zoho Projects, Books and Analytics Join Up

Ask a services business what its most profitable project was last year and you usually get a confident answer that turns out to be based on revenue. Revenue is not margin, and the difference is where services businesses quietly lose money.

Time has to be logged against something specific

Time logged against a project tells you what it cost in total. Time logged against a task tells you where the cost went — and only the second is actionable. When configuration consistently overruns while training consistently finishes early, that is an estimating correction worth thousands over a year, and it is invisible at project level.

The practical threshold is that tasks should be small enough for a day’s work to belong to one or two of them. Beyond that, people log to whatever is nearest and the detail stops meaning anything.

Billable, non-billable, and the honesty in between

Write-offs are worth their own report. They are usually treated as a goodwill decision taken case by case, and in aggregate they are a measurement of where scope and estimate diverge.

The link to invoicing

Approved billable time flows into Zoho Books as invoice lines with their rate applied, which removes the monthly exercise of reconstructing what was done from memory and email. Two configurations decide how well this works: whether rates are held per role, per person or per project, and whether approval happens before or after invoicing. Approval first is the version that avoids credit notes.

Where margin actually gets calculated

Neither Projects nor Books holds both halves of the margin equation. Projects knows the hours; Books knows the revenue; the cost of an hour comes from the salary and overhead side of the business. Zoho Analytics is where those meet, which is why margin reporting is an Analytics exercise in every estate that does it properly. A useful discipline is to fix the cost rate per role annually and stay with it — chasing a precise cost per person per month produces a more accurate number that nobody trusts and everyone argues about.

Retainers, fixed price and time-and-materials

Each commercial model changes what the numbers mean. Time-and-materials margin is the simplest: rate minus cost. Fixed price margin only becomes real at the end, so the number to watch during delivery is effort consumed against effort estimated. Retainers need utilisation of the retained capacity, because an unused retainer looks profitable and is usually a relationship at risk. The same timesheet data supports all three, read differently.

Frequently asked questions

How do we get people to log time honestly?

Make it quick, make it daily, and never use it to police individuals. The moment timesheets become a performance instrument, the data becomes fiction and the margin report goes with it.

Should non-billable time be logged at all?

Yes. A business that only logs billable hours knows its revenue and not its capacity, which makes every resourcing decision a guess.

What utilisation is healthy?

It depends on the model, and the more useful comparison is against your own trend rather than an industry figure. A number that is falling while headcount grows is the signal worth acting on.

Where does pre-sales effort belong?

Internal non-billable, tracked separately. Businesses that hide pre-sales in project cost systematically understate the cost of winning work.

Where to start

Take last quarter’s largest project and calculate its margin using logged hours and a fixed cost rate per role. If the answer surprises you, that is not an accounting problem — it is the number your pricing should have been based on.

References

Topic inspiration: the Project Management section of the Zoho Blog. This article is Kelevo Software’s own analysis and wording, written from our implementation experience; no text has been reproduced from Zoho’s publications.