HHorixa

Time Tracking Reports: The Five Reports Every Agency Needs

A time tracking report is a summary of logged hours, grouped and totalled for one specific reader: per person for the team lead, per project for the project lead, per month and per type for management, per engagement for the client or the accountant. The same hours produce different reports, and a report meant for everyone at once usually helps no one. Most agencies have plenty of hours on record. What they lack is a fixed set of reports that reach the right person at a fixed moment, each with a number that person can act on.

This article walks through the five reports an agency or consultancy pulls from its time tracking, with the columns, the frequency and what to look for in each. Which numbers management should check every week is covered in agency KPIs: 8 numbers to review weekly; this is about the reports those numbers come from.

Terms that get mixed up

Term What it is For whom
Time report Any totalled view of hours, internal or external Anyone who manages by hours
Timesheet export The raw list of entries over a period, no analysis Team member, admin
Timesheet specification Attachment to the invoice with the billed entries Client
Time records Evidence that hours were spent on a stated purpose Accountant, grant body, tax authority
Weekly timesheet One person's hours for one week Team member, team lead

The difference between an export and a report is the most useful one here. An export shows what was logged; a report puts it next to something else: a budget, a target, last month. That is the point where a number becomes a signal.

Five reports, five readers

Report Reader Frequency The question it answers
1. Completeness Team lead or office manager Weekly, Monday morning Has everyone logged last week?
2. Hours against budget Project lead Weekly per active project Will this project stay within budget?
3. Billable and non-billable hours Management Monthly, with trend Where does our time go?
4. Timesheet specification Client With every invoice What am I paying for?
5. Time records Accountant, grant body, tax authority Yearly or on request Can we show where the hours went?

The order matters. Each report depends on the one before it: without complete hours no budget report is right, and without correct project hours the monthly report is an estimate.

1. The completeness report

The least exciting report and the most important one. Per person it shows how many hours were logged last week against how many should have been, based on contract and schedule, with leave and public holidays already taken out.

Person Contract Leave Expected Logged Status
Anna 40 0 40 40 Complete
Ben 32 8 24 24 Complete
Chloe 40 0 40 22 Missing 18 hours
David 36 0 36 0 Nothing logged

What to look for: the names, not the total. A team that is 90% complete on average can still have one person who has logged nothing for three weeks, and that is exactly the person whose projects you cannot invoice. Do not circulate the report as an attachment; turn the outcome into a reminder for whoever is behind. Everyone else has nothing to do.

2. Hours against budget per project

The project lead needs one answer: how much of the budget is used, and how much of the work is done? The report puts budgeted hours next to logged hours per project or phase, and ideally next to an estimate of the remaining work.

Phase Budget Logged Still needed (estimate) Expected total Variance
Strategy 40 46 0 46 +15%
Design 80 52 30 82 +3%
Build 160 35 140 175 +9%
Total 280 133 170 303 +8%

What to look for: the expected total column, not the logged column. Knowing that 133 of 280 hours are gone tells you nothing until you know whether the work is halfway. A project at 50% of budget and 30% of the work is in trouble, even when the report looks green. How to catch overruns early and what to do next is covered in prevent project budget overruns.

On fixed-price work this is the only report that tells you whether the price was right. Keep it after the project closes: this project's actuals are the next project's estimate.

3. Billable and non-billable hours

This is the report management steers by, and the one most often misread. It splits all logged hours per month into billable and non-billable, and the non-billable part again by type.

Type Sep Oct Nov
Billable 1,120 1,180 1,050
Internal meetings 140 150 145
Sales and proposals 95 160 210
Training 40 30 25
Admin 85 80 90
Leave and sickness 160 120 200
Total 1,640 1,720 1,720
Billable, against hours present 76% 74% 69%

How to read it. The percentage at the bottom drops five points in November, and the reflex is to talk to the team about productivity. The report itself tells another story: billable hours fell by 130, and sales hours more than doubled in two months. The agency did not work less, it wrote proposals. Whether that is good news depends on what happens to those proposals; see improving your proposal win rate.

Three rules keep this report honest:

  • Always show hours next to the percentage. A percentage without absolute numbers hides whether the numerator or the denominator moved.
  • Keep leave and sickness separate. They are in the report so the total adds up, but they do not belong in the denominator. Whichever denominator you use, state it; the two common ones are explained in increase billable utilization.
  • Report monthly, read quarterly. One month with holidays or a big pitch says little. A line over a quarter shows whether something is shifting.

Split the same report per person and you see who has too little client work and who has too much. Both are a planning question before they are a performance question.

4. The timesheet specification for the client

On time-and-materials work every invoice goes out with a specification: date, person or role, description and hours per line. It is the only report that leaves the building, and so the only one someone else judges you on. What belongs in it and how to write descriptions a client signs off without questions is covered in billing hours to clients.

For reporting, one thing matters: build the specification from the same approved hours as your internal reports. The moment a separate, cleaned-up version for the client exists, your internal numbers and your invoices drift apart, and nobody knows which one is right.

5. Time records for your accountant

An accountant looks at hours differently from management. The question is not whether the team was productive, but whether the figures in the annual accounts and the tax return can be backed up. For an agency that comes up in three places.

Work in progress. Hours logged before year end but not yet invoiced appear as work in progress on the balance sheet. The accountant asks for the logged, uninvoiced hours per project with the cost price or rate used to value them. A report per project as of 31 December turns that into fifteen minutes of work instead of a week of searching; the calculation itself is in calculating work in progress.

R&D tax credits. Many countries reward in-house development work, and nearly all of them require time records per person and per project kept during the year rather than reconstructed afterwards. In the Netherlands this is the WBSO, which requires an R&D time administration per employee and per project with a short description of the work. A separate hour type or project for R&D work makes the report a matter of filtering.

Hours tests for the self-employed. Some tax reliefs depend on the hours an owner spends on the business. In the Netherlands the self-employed deduction requires at least 1,225 hours per calendar year, and non-billable hours such as sales, admin and training count towards it. If you only record billable hours, you are missing the hardest part of the evidence when it is checked.

Keep the underlying entries as long as the rest of your records; in the Netherlands the retention period for tax purposes is seven years. A report without the entries behind it is not evidence.

Five mistakes in time reports

  • Reporting on unapproved hours. Hours that may still be on the wrong project produce a report that changes next week. Report on closed, approved periods, or label the report as provisional.
  • One report for everyone. A dashboard with thirty charts gets read by no one. Five short reports, each with one reader, do get read.
  • Percentages without counts. 74% of 400 hours is not 74% of 1,700 hours. Always show the absolute number.
  • Only looking back. A budget report without an estimate of remaining work only tells you a project overran once it is too late.
  • Too late. A monthly report about October that arrives in mid-December describes an agency that no longer exists. The sooner after closing, the more you can still do with it.

Time tracking reports in Horixa

In Horixa people log hours against a project and an hour type, and the hour type decides if that hour can be billed. The weekly timesheet shows per person which days are complete, and anyone behind gets a weekly reminder. Each project shows logged hours next to its budget. In Insights, from the Growth plan, you get hours per month split into billable and non-billable with the percentage, productivity per person over the last 28 days and billable utilization per project. For your own report in Excel you export the time entries as CSV, and through the REST API you pull the same data into your own dashboard. The AI assistant answers the one-off questions in between, such as which projects are over budget this month.

Frequently asked questions

What is a time tracking report? A summary of logged hours, totalled and grouped for one reader and one question: per person to check that everything is logged, per project to watch the budget, per month and type to see where the time goes. Unlike a raw timesheet export, a report puts the hours next to something else, such as a budget, a target or the previous period.

Which time reports does an agency need? Five: a weekly completeness report, hours against budget per active project, a monthly billable and non-billable report, the timesheet specification with each invoice and yearly time records for the accountant. Making more reports is easy; getting these five to the right person on time is the actual work.

How do you build a billable hours report? Total all approved hours for a month per hour type, split them into billable and non-billable and break the non-billable part down by type: meetings, sales, training, admin. Keep leave and sickness separate, put the utilization percentage at the bottom with its denominator stated and compare it with the two months before.

How often should you report on hours? Completeness weekly, on Monday morning. Hours against budget weekly for active projects. The billable and non-billable split monthly, within a week of closing. Time records for the accountant yearly, or whenever a grant or an audit asks for them.

What time records does an accountant need? Per project, the logged and uninvoiced hours at year end, to value work in progress. For R&D tax credits, the R&D hours per person and per project, kept during the year. For an owner-run business that relies on an hours test, all hours worked, including non-billable ones.

Can you build time reports in Excel? Yes, a pivot table over an export of your time entries gets you a long way. It gets harder once budgets, approvals and several people are involved: you are then reporting on a copy that is out of date the moment you make it. A starting layout is in timesheet template for Excel.