Skip to main content

Time Reporting: columns, filters and export

What each Time Reporting column, filter, grouping and export level shows, and how parent projects add up.

Written by Ellen Kajca

This article describes each part of the Time Reporting screen: grouping, time periods, columns, filters and export levels. To open Reporting, export it and control who can see it, see Timesheet Reporting.

Some columns and filters are different for the Timesheets data source and the Time tracking data source. To find the source of your workspace, see Timesheet Reporting.

Grouping

  • Rows have two levels. For each level, select Project, Person or Category. (Your workspace can use a different name for Category.)

  • To change the order of the two levels, select the switch icon between the two lists.

  • A row opens to the second level only. Rows do not show single actions.

  • Parent projects add up their sub-projects only when you group by Project first and Person second. See Parent projects below.

Time periods

In Show time by, select how to divide time into columns:

  • By week: one column for each week. Weeks start on Monday.

  • By month: one column for each month.

  • By year: one column for each year.

  • All time: one total for all logged time. The date fields are not available.

In Time period, select the start date and the end date.

Columns

In Display, select the columns to show. Some columns show only with a permission or a grouping. The Total rows column tells you how a project, person or parent row adds up the rows below it.

Time

Column

What it shows

Total rows

Shows when

Hours

Hours logged in each period

Sum

Always

Total Hours

Hours logged in the whole date range

Sum

Always

Estimate (Est hours)

Estimated hours on actions. Shows N/A with the Timesheets source.

Sum

Always

Utilization

Column

What it shows

Total rows

Shows when

Utilization

Hours logged ÷ capacity from Resourcing

Timesheets source: the group's hours ÷ the group's capacity. Time tracking source: sum of the rows below.

Always

Utilization Target

The target in each person's Resourcing profile

Highest value

Person is the first level

Money

Column

What it shows

Total rows

Shows when

Billable amount

Hours × bill rate

Sum

You have the Bill rates permission

Bill Rate

Hourly bill rate

Average, weighted by hours

You have Bill rates, and the grouping is not Project and Category

Budget

The project budget

Sum

You have Budget read, and Project is the first level

Other Costs

Costs that are not time

Sum

You have Budget read, and Project is the first level

Remaining budget

Budget minus other costs minus the billable amount, period by period

Calculated

Shows with Budget. With the Timesheets source, you also need Bill rates.

Remaining budget %

Remaining budget ÷ Budget

Calculated

Shows with Budget

Cost Rate

Hourly cost rate

Average, weighted by hours

You have the Cost rates permission, and Person is the second level

Total Hours Cost

Hours × cost rate

Sum

You have Cost rates, and Person is the second level

By default, only workspace admins have Bill rates and Cost rates. Admins and members have Budget read. For more, see Timesheet Reporting.

Custom fields

Project custom fields are also columns in Display. They show a value on each project row.

Filters

Select Filters to open the filter panel. You can use more than one filter.

Filter

What it does

Project

Shows only the projects that you select

Project tag

Shows only projects with the tags that you select

Custom field

Shows only projects with the custom field values that you select

User

Shows only the people that you select

Team

Shows only the teams that you select

Role

Shows only people with the roles that you select

Category

Shows only the time categories that you select. Your workspace can use a different name.

Timesheet status

Timesheets source only. Approved (default) or Unapproved, or both.

Label

Time tracking source only. Shows only time on actions with the labels that you select.

Show archived projects

Includes archived projects

Show Projects without time

Shows projects that have no time. Only when you group by Project first and Person second.

Tip: to see only some sub-projects, select them in the Project filter.

Export levels

Level

What the file has

Daily

One row for each day, for each person and project

Detailed

Data for each person on each project. With Show time by set to By week, the file also has the timesheet comments and approval comments.

Summary

Data for each project

  • Format: with the Timesheets source, CSV or Excel (.xlsx). With the Time tracking source, CSV.

  • The file uses your filters.

  • Columns that you do not have permission to see have no values. With the Timesheets source, these columns are not in the file.

Parent projects

When you group by Project first and Person second, Reporting shows the project tree. A parent project row adds up all its sub-projects, at every level. You can expand a parent row to see each sub-project and each person.

  • A parent project shows even if nobody logs time on it directly.

  • With the Timesheets source, a parent project that you cannot open shows its name and the total of the sub-projects that you can open. It does not show its own budget, other costs or custom field values.

Frequently asked questions

How is Remaining budget calculated?

Remaining budget starts with the project budget and subtracts the other costs. Then it subtracts the billable amount of each period, in date order. Each period shows the budget that is left at the end of that period. Because of this, the value depends on your date range.

Why does a parent project show no budget?

With the Timesheets source, this happens when you cannot open the parent project. The row shows the total of the sub-projects that you can open. Ask a project owner to share the parent project with you.

Did this answer your question?