While you deliver
Timesheet vs Plan Analyzer
See where your team's hours actually went against where the resource plan put them, and which gaps are worth a conversation.
Open the timesheets and the resource plan, and the charge code list if you have one. They are read inside your browser; nothing is uploaded.
Timesheets
Drop a spreadsheet here
Hours logged, one row per person and project for a day, a week or a month. Weekly rows are spread over their Monday to Friday.
Resource plan
Drop a spreadsheet here
Who is planned on which project: a column of hours per month, a row per person, project and month, or an allocation (50%, 0.5) with from and to dates.
Charge codes (optional)
Drop a spreadsheet here
The code list: code, project name, effort estimate in hours, status and the date each closed. It lets codes in the timesheets match names in the plan.
The plan and the timesheets rarely meet
A resource plan says who works on what each month. The timesheets say what they charged. Nobody lines the two up until something has gone wrong: a developer quietly absorbed into support, a project that got half the hours it was promised, a closed code still collecting time months later.
What is found
Hours on work the plan did not have for that person and month. Planned assignments that got less than half their hours. Projects that took more than 10% over plan. With the code list, time charged after a code closed, and projects that pass their effort estimate once the hours still planned are added. And months where someone planned logged nothing at all, which is usually a missing timesheet or leave the plan does not show.
Codes, names and partial months
Timesheets tend to use charge codes and plans tend to use names; the code list joins them. Only the months the timesheets cover are compared, and a month they cover in part has its plan cut to the working days covered, so a timesheet export that stops mid-month does not read as everyone falling behind.
What this does not do
It does not judge whether anyone worked hard enough, and it is not a tool for checking up on individuals: the gaps it shows are usually the plan being out of date. It compares hours, not progress; for cost, see the Labor Burn Forecast, and for a supplier’s bills, the Vendor Invoice Reconciler.