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
Raw hours
0
Weighted
0
+4.80 from weights
Clients
0
People
0
September 2026
Client
Person
Raw
Weight
Weighted
North Quay Print
Sarah Cole
18.00
1.20
21.60
North Quay Print
Helen Ward
22.00
1.00
22.00
Hearth Studio
James Hale
16.00
1.00
16.00
Hearth Studio
Sarah Cole
6.00
1.20
7.20
Mill Lane Accounts
Helen Ward
12.00
1.00
12.00
Vale Civic Hall
James Hale
8.00
0.75
6.00
North Quay Print
Sarah Cole
18.00
1.20
21.60
Hearth Studio
Sarah Cole
6.00
1.20
7.20
Raw hours
0
Weighted
0
+2.80 from weights
Clients
0
People
0
Raw hours
0
Weighted
0
+2.80 from weights
Clients
0
People
0
August 2026
Client
Person
Raw
Weight
Weighted
North Quay Print
Sarah Cole
10.00
1.20
12.00
North Quay Print
Helen Ward
8.00
1.00
8.00
Hearth Studio
James Hale
20.00
1.00
20.00
Mill Lane Accounts
Sarah Cole
4.00
1.20
4.80
Vale Civic Hall
Helen Ward
14.00
1.00
14.00
North Quay Print
Sarah Cole
10.00
1.20
12.00
Mill Lane Accounts
Sarah Cole
4.00
1.20
4.80
Billing block
Builds a block you can paste into an invoice
September 2026, team
September 2026
North Quay Print 43.60
Hearth Studio 23.20
Mill Lane Accounts 12.00
Vale Civic Hall 6.00
Total 84.80
September 2026, Sarah Cole
September 2026
North Quay Print 21.60
Hearth Studio 7.20
Total 28.80
August 2026, team
August 2026
North Quay Print 20.00
Hearth Studio 20.00
Mill Lane Accounts 4.80
Vale Civic Hall 14.00
Total 58.80
August 2026, Sarah Cole
August 2026
North Quay Print 12.00
Mill Lane Accounts 4.80
Total 16.80
Who was busy
Week by week
123456789101112
Sarah Cole
Helen Ward
James Hale
Sarah Cole
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.
Sarah Cole, weighted hours by client
Own rows only. Helen Ward and James Hale are not on this sign-in.
Week by week
123456789101112
Sarah Cole
Helen Ward
James Hale
Sarah Cole
Quiet to busy
Weighted hours by person
Weighted hours by client
August shifts the load onto Hearth Studio. Mill Lane Accounts is a short principal booking.
Sarah Cole, weighted hours by client
Own rows only. The Hearth Studio week belongs to James Hale.
How it works
Pick a month or two dates.
Add up completed entries in minutes.
Apply the rate weights and group by company and person.
Limit a non-admin to their own entries.
Draw company and person activity charts.
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"]