About Services Tools Blog Contact us

Hours and Activity Reports

Reports hours, and hours adjusted for pay rate, by company and person, with an activity chart and a list of hours ready to copy into an invoice.

  • Reporting Dashboards
  • Professional services
  • Dashboard feature
  • Product
  • Hybrid
  • 2026

The problem

Monthly billing needs weighted hours, and a raw timer total treats every hour the same. Nobody could see who had been busy either. Then the totals had to be copied into an invoice, which was a second job after the report.

What it does

You pick a month or two dates. Completed entries between them are summed in minutes, weighted by the rate for each type of work, and grouped by company and person. Non-admins see only their own entries. The same screen draws activity charts and can show a decimal-hours text block with a total, ready to copy.

Outcomes

  • Billing uses weighted hours.
  • A person sees their own figures without asking an admin for an export.
  • The activity chart shows who was busy.
  • A text block of hours is ready to paste into an invoice.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Weights: principal 1.20, consultant 1.00, assistant 0.75. Minutes are stored. A non-admin sign-in keeps only that person’s rows.

Hours by client

Raw hours
0
Weighted
0
+2.80 from weights
Clients
0
People
0
September 2026
ClientPersonRawWeightWeighted
North Quay PrintSarah Cole18.001.2021.60
North Quay PrintHelen Ward22.001.0022.00
Hearth StudioJames Hale16.001.0016.00
Hearth StudioSarah Cole6.001.207.20
Mill Lane AccountsHelen Ward12.001.0012.00
Vale Civic HallJames Hale8.000.756.00
Billing block
Builds a block you can paste into an invoice

Who was busy

Week by week
123456789101112
Sarah Cole
Helen Ward
James Hale
Quiet to busy
Weighted hours by person
Weighted hours by client

Helen Ward carries the month. Vale Civic Hall is the assistant rate, so eight raw hours become six weighted.

How it works

  1. Pick a month or two dates.
  2. Add up completed entries in minutes.
  3. Apply the rate weights and group by company and person.
  4. Limit a non-admin to their own entries.
  5. Draw company and person activity charts.
  6. Reveal a text list of hours in decimals with a total.

Pipeline

flowchart LR
  Entries["Completed entries"] --> Weight["Apply weights"]
  Weight --> Group["By company and person"]
  Group --> Table["Hours table"]
  Group --> Chart["Activity graph"]
  Table --> Block["Decimal-hours block"]