Time Variance Report

Track member time planned or budgeted against how much time was actually shown as spent on timesheets to see when things are getting off track and improve your budgeting.

Click to View Video Tutorial

The Time Variance Report allows you to look at a project's initial estimates or planned time vs. the actual time spent.

The report data can be grouped either by Projects or by Members.

info icon
On this page, the "Planned Time" and "Spent Time" values show data from past dates only. This is different from the "Planned Time" displayed in the "Time" tab, which includes future planned hours.

To see all time periods, including future planned hours, you can use the "Custom Date" option.

Project Tab

You can use this to view to see how you are tracking toward project goals or viewing completed projects to assist how you should plan/bid for similar projects.

  1. Select the project(s) you would like to view. Use the Portfolios button to group projects by Portfolios, All Projects, or All Members.

  2. Decide which variance you would like to view: "Spent Time vs. Planned" or "Spent Time vs. Member Budget”.

    • Spent vs. Planned Time

      The Planned and Spent columns are displayed. The Planned column represents the total hours derived from Work Plans, while the Spent column reflects the total hours recorded in the timesheets.

    • Spent vs. Member Budget

      The Budget column indicates the estimated hours assigned to the member in the budget modal, while the Spent column displays the total hours logged in the timesheets. The aggregated estimated hours for members are displayed at the work category, phase, and project levels.

  3. The desired time period can be selected when viewing by the Planned Time.

  4. On the right hand side of project you will see a green or red percentage displaying the project's overall performance.

    Red = overestimate (spent amount exceeds planned amount)

    Green = underestimate (spent amount is below planned amount)

  5. Expanding a project displays the variance for each individual phase. Further expansion of a phase provides details about its members and their specific contributions to the variance.

  6. The No Variance button filters out projects or phases without variance, meaning those without planned/estimated hours or spent hours recorded.

View and Modify Project Details

Click on the three dots of a Project to:

  • Go To Project: Open the Project in a new tab

  • View Project Budget: Open Project Budget Space

  • Edit Project Info: Open Project Info Modal

  • Set Project Color: Change the color of the Project

  • Manage Members: Change Member Project permission, add or remove Members

  • Edit Phases: Edit Phases information and dates.

Member Tab

Allows you to look at one individual Member and view their overall contributions.

  1. Click on the Member tab.

  2. Select the members you would like to view.

    Click All Members to group Members by Departments, Disciplines, Offices, Portfolios, Roles, Regions, and Skills.

    You can filter your members list by clicking on the Filter button in the top left.

    info icon
    The Role filter considers only the member's Default Role, which are listed on Org settings > Members > All Members tab. For example, if a member has "Editor" as their default role and "Viewer" as a non-default role, the role filter will only show them if "Editor" is selected in the filter options.
  3. You will see two bars next to each member's name.

    • Yellow = planned hours

    • Green = spent across all projects

  4. On the very right-hand side of each member row, a green or red percentage is displayed.

    1. Green = underestimate (spent amount is below planned amount)

    2. Red = overestimate (spent amount exceeds planned amount)

  5. Expand the Member to see how the Member's variance breaks down by Project and by Phases, Subphases and Work Categories.

View Filter

The shown Projects can also be filtered based on their Phases, whether they are billable or not, and Members or Projects depending on the view.

When the filter is active, it will display in dark green.

Additionally, filters for Members and Projects are available on ALL REPORTS, allowing for effortless data drill-down.

Private Projects

Work Planners with the following permissions:

  • Work Planner > Can Edit > Projects they are a Member of

  • Work Planner > Can Edit > Projects they are a Project Manager of

can only view Projects they have access to (either as a Member or as a Project Manager).

info icon
Budget Managers inherit the Work Planner > Can Edit > All Projects permission. Therefore, they are able to see all the information on this report.

Learn more about Permissions

Projects without access permissions will appear as "Private Project" and will not display a bar.

Learn more about Private Projects in Work Plans

Learn more about Private Projects in Planner

Did this answer your question?
😞
😐
😁