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.


