View aggregated time and budget information across parent and child projects in Time Reporting.
Overview
In the Time Reporting section, Hive rolls up timesheet or tracked time, utilization, budgets, and billable amounts from child projects to their parent project. The parent project line displays aggregated totals so you can see portfolio-level performance at a glance.
A common way to organize projects in Hive is to use a parent project for a client, department, or initiative, with child projects for day-to-day work where team members track time. Time Reporting does the math for you, eliminating the need for exports and manual calculations to see totals at the parent level.
Where to Find Time Reporting
Time Reporting is accessible from two places depending on your workspace setup:
If your workspace uses Timesheets:
Navigate to the Timesheets app, then select the "Reporting" tab. This tab is available to workspace admins, managers, and project creators.
If your workspace uses Time Tracking (without Timesheets):
Navigate to the Time app, then click the Reporting icon to open the reporting view.
Note
The roll-up feature applies to the Time Reporting UI only. It does not affect the Project Overview page or Portfolio View.
How Roll-Up Works
When your Time Reporting is grouped by Project (first level), Hive automatically builds a project hierarchy tree. Parent projects appear with expandable rows, and their data reflects the aggregated totals of all child projects underneath them.
You can expand or collapse parent project rows to see the breakdown by child project and, within each project, by person, time category, or other grouping dimensions.
Available Columns
Use the "Display" dropdown to choose which columns appear in your report. The following columns are available (some require specific permissions or grouping configurations):
Time Columns
Column | Description | Aggregation |
Hours | Timesheet or tracked hours for the period | Sum |
Total Hours | Cumulative hours across all periods | Sum |
Est Hours | Estimated hours assigned to work | Sum |
Allocation | Allocated hours from resourcing | Sum |
Utilization Columns
Column | Description | Aggregation |
Utilization % | Percentage of available time used | Sum |
Utilization Target | Target utilization percentage per person | Max |
Utilization Target is only available when the first grouping dimension is Person.
Financial Columns
Column | Description | Aggregation |
Budget | Total budget allocated to the project | Sum |
Other Costs | Non-time costs associated with the project | Sum |
Billable Amount | Total billable amount based on hours and bill rates | Sum |
Remaining Budget | Budget minus billable amounts and other costs | Calculated |
Remaining Budget % | Remaining budget as a percentage of total budget | Calculated |
Bill Rate | Hourly bill rate | Average |
Cost Rate | Hourly cost rate for internal tracking | Average |
Total Hours Cost | Total cost of hours based on cost rates | Sum |
Budget and Other Costs require the budget permission. Bill Rate requires the bill rates permission. Cost Rate and Total Hours Cost require the cost rates permission.
Custom Fields
If your workspace has project-level custom fields, they also appear as selectable columns in the Display dropdown. Custom field values are shown per project row.
Grouping Options
Time Reporting supports two levels of grouping to organize your data. Use the grouping control in the report header to configure how rows are nested.
First Level (rows)
Second Level (nested under each first-level row)
The parent-child project tree roll-up is active when the first grouping dimension is Project. Some column options change depending on your grouping selection.
Time Periods
Use the "Show time by" dropdown to control how time is bucketed into columns:
Use the date range pickers to set the start and end dates for the report. Date pickers are disabled when "All Time" is selected.
Filters
Click the Filters button to open the filter panel. You can narrow your report using any combination of the following filters:
Filter | Description |
Project | Select specific projects using a hierarchical project tree picker |
Project Tag | Filter by project tags assigned to your projects |
Custom Field | Filter by project custom field values |
User | Show time for specific team members only |
Team | Show time for specific teams only |
Role | Filter by user roles |
Label | Filter by action labels (when using Timesheets as the data source) |
Timesheet Status | Filter by Approved or Unapproved status (when using Time Tracking as the data source) |
Time Category | Filter by time category (the label may vary based on your workspace settings) |
Show Archived Projects | Include archived projects in the report |
Show Projects Without Time | Display projects that have no time tracked (only available when grouped by Project then Person) |
Tip
To see only child projects and exclude parents from the view, use the Project filter to select specific child projects. To see all projects including those without any tracked time, enable "Show Projects Without Time."
Exporting
Click the export icon in the top-right corner to download your Time Reporting data as a CSV file. You can choose from three export levels:
Export Level | Description |
Daily | One row for each day, per user, per project based on your applied filters |
Detailed | User-level data per project based on your applied filters |
Summary | Project-level data based on your applied filters |
The export button is disabled when there is no data to export. A notification will appear while the download is being prepared.
FAQ
Which projects show the roll-up?
Any parent project with child projects will display aggregated data from its children. This works at any depth in the project hierarchy.
What if no time is tracked on the parent project itself?
The parent project row still appears and shows the sum of all child project data. You don't need to track time directly on a parent project for roll-up to work.
How is Remaining Budget calculated?
Remaining Budget starts with the project budget, subtracts other costs, then subtracts billable amounts period by period. It is not a simple sum -- it is computed dynamically based on your time range.
Why don't I see certain columns?
Some columns are gated by workspace permissions (budget, bill rates, cost rates) and by your grouping selection. For example, Utilization Target only appears when the first grouping is Person, and Budget only appears when the first grouping is Project.
Can I hide the Allocation column?
Yes. If your workspace has the allocation feature disabled, the Allocation column will not appear in the column picker.
Who can access Time Reporting?
Access is controlled by your workspace's Time Reporting access settings. Typically, workspace admins, managers, and project creators can view Time Reporting. Your workspace admin can configure which teams or users have access.