Timelog Report

What it's for: understanding your team's tracked time — utilization, billable value, and what hasn't been invoiced yet.

KPI cards (seven):

• Total Hours — billable + non-billable.

• Billable % — utilization (billable hours ÷ total hours).

• Billable Amount — total billable dollars.

• Avg. Bill Rate — billable $ ÷ billable hours.

• Effective Rate — all invoiceable value ÷ total hours (your real hourly yield).

• Realization — invoiced $ ÷ billable $ (how much of billable work actually got billed).

• Not Invoiced — billable dollars not yet invoiced (highlighted as a warning). A banner calls out the project with the largest outstanding amount.

Charts: Hours by Project, by Task, by Team Member, and Invoiced vs Not Invoiced.

Table: an expandable tree — Project → Phase → Task → Employee — with toggleable columns for Billable (hrs/$), Non-billable, Invoiced, Not Invoiced, and GPM (gross profit margin on labor = (billable − cost) ÷ billable). "Not Invoiced $" is highlighted.

Filters: Start/End dates (these re-query your time data by work date), and Client / Project / Team Member multi-selects (projects narrow to the chosen client), plus a "Not Invoiced only" toggle.

Where the data comes from: your timelogs, with the people, clients, projects, and phases they belong to.

What to understand: the date filters actually pull from the server (not just hide rows), so widening the range fetches more. GPM depends on each member's labor cost being set — without cost data, margin can't be calculated. The CSV is a hierarchical roll-up with subtotal rows and a grand total.