Timesheet Reports
Tracking the time taken to complete the work items is easier now with the all-new Timesheet Reports.
Benefits of timesheet reporting
- Compare the progress of the sprints and track the sprint that has recorded the maximum hours.
- Track the work item type that has logged the maximum hours in your sprint.
- Track the users who have worked the maximum and minimum hours.
- Track the month in which your team members have worked the maximum hours.
- Keep a regular track of the overall hours (billable and non-billable) your project and sprint has met.
If you are looking for timesheet tracking reports, Zoho Sprints provides four new reports that tracks the total number of hours logged under each category.
Sprint log hour report
Track the total log hours of all the sprints in your team.
Benefits
- Track the total hours spent on a particular sprint in the project.
- Track the sprint that has achieved the maximum log hours.
- Track the work item type that has achieved the maximum hours.
- Track the sprint that has logged the minimum hours.
- Track the work item type that has logged the minimum hours.
Viewing the sprint log hour report
- Navigate to Reports.
- Select Sprint in Timesheet Reports.
- Here, X-axis represents the Sprint Name and Y-axis represents the Log Hours.
Use case
Let's say Helen wants to track the total time spent on different sprints in the project. How can she track the details?
She can also track specific details of the log hours like:
- She can view details of the work items specific to the work item type.
- She can click on a work item and navigate to its details page from the reports tab.
- She can customize the report with the filter option.
Work item type log hour report
Track the time taken for each work item type in the project.
Benefits
- Track the log hours of all the work item types in the project.
- Track the work item type that has recorded the maximum hours.
- Track the work item type that has recorded the minimum hours.
- Schedule meetings with the team to get more insights on the time taken for specific work item types.
Viewing the work item type log hour report
Work item type report tracks the time taken for each work item type in the project. With this chart you can identify the most complex work items type based on the time taken to complete.
- Navigate to Reports.
- Select Work Item Type in Timesheet Reports.
- Here, X-axis represents the Work Item Type and Y-axis represents the Log Hours.
Use case
Helen wants to track the total time taken for each work item type in the project. She wants to know the work item type that requires more time to complete. This estimation of time will help her plan the upcoming sprints better. How can she track it?
Helen can also track the work items specific to the work item type. She can also view the hours logged for the work items individually. With the filter option, she can customize the report.
User log hour report
Track the user who has logged maximum hours in the project.
Benefits
- Track the total log hours of the users in the project.
- Track the user with the maximum log hours.
- Track the user with the minimum log hours in the project.
- Track the work item type with the maximum and minimum log hours.
- Track the user with the maximum log hours for a particular work item type.
Viewing the user log hour report
User log hour report tracks all the users in the project and the number of hours logged.
- Navigate to Reports.
- Select User in the Timesheet Reports.
- Here, X-axis represents the Log Hours and Y-axis represents the Users.
Use case
Helen wants to track the log hours of the users in the project and the user with the maximum log hours. She heads on to the
User Log Hour Report and views the log hour details of the users in the project.
- Members can view only their log hours.
- Managers can view the log hours of other members only if they are assigned as the sprint owners.
Monthly log hour report
Track the monthly log hours of the work item types.
Benefits
- Track the monthly total log hours of the work item types in the project.
- Track the work item type with the logged maximum hours.
- Track the month when users have logged maximum and minimum hours.
- Track the date when users have logged maximum hours.
Viewing the monthly log hour report
-
Navigate to Reports.
-
Select Month in Timesheet Reports.
-
Here, X-axis represents the Month and Y-axis represents the Log Hours.
Use case
Helen wants to track the total logged hours of the project monthly. She also looks out for ways to track the hours that are billable and non-billable. She can track the work item type with maximum and minimum log hours on a daily basis.
She can set filter criteria and customize the reports. She can select a particular work item type and view the list of work items.
Filter timesheet reports
You can filter reports with specific criteria.
- Navigate to Reports.
- Choose Timesheet Reports.
- Select a particular report and click
in the upper-right corner.
- Choose the relevant criteria and click Apply Filter.
Export timesheet reports
You can also export the reports and use them in your progress meet-ups.
- Navigate to Reports.
- Click
next to the Timesheet Report name.
- Select Export.
You can access the exported reports in your downloads.
Actual vs planned report
Actual vs planned report will help you track the planned and actual time spent on a particular set of work items. It is based on the planned vs the actual start and end dates of the work items. The difference (i.e. the variance) between the planned and actual hours will determine the efficiency of the project users. The manager can track the maximum and minimum hours spent on a work item, sprint, or user in the project.
Use case
A software team wants to track the actual vs planned time taken by the Dev and QA teams. This will help the manager track the difference in the hours committed vs the hours accomplished by both the teams. Based on the results, they can know the team that takes the maximum time to complete a feature request.
How to solve the purpose?
To differentiate the story, task, and bug created by both the Dev and QA team, the team can create custom item type. The work items related to Dev can be tagged under the Dev Items (Custom work item type) and the work items related to QA can be tagged under QA items (Custom work item type). This will help the manager to filter the Dev and QA items individually to find the actual vs planned hours.
How to track the actual vs planned report?
The sprint owner wants to find out the difference between the actual vs planned time taken by both teams.
Using the filter option, the team can select the Dev items (Item type).
- Track the planned and actual time for individual items and its overall total.
- Track the variance in the planned vs actual hours of individual items and overall variance of all the dev items.
- Determine the variance %
- Variance = (Planned hours - Actual hours)
- Variance % = (Variance / Planned) * 100
- Variance in Green : Actual hour is less than the planned hour.
- Variance in Red : Actual hour is more than the planned hour.
Similarly, the team can find the actual vs planned time taken by the QA items (Item type).
The variance obtained in both the teams will help the manager track which team is performing better by completing the items within the planned hours.
If you are a client based company, you can track all the billable hours and estimate the total hours of the project. The team can export the report and share them to the clients.
Similarly, the team can find the actual vs planned time taken by the QA items (Item type). The variance obtained in both the teams will help the manager track the team that shows a better progress.
If you are a client based company, you can track all the billable hours and estimate the total hours of the project. The team can export the report and share them to their clients.
Where should I access this report?
You can directly navigate to the Reports module and access the Actual vs Planned report under Timesheet Reports. This report can be fetched either based on the sprints or users in the project.
Two types of actual vs planned report
Zoho Sprints comes up with two different types of actual vs planned report.
Sprint based actual vs planned report
Track the actual vs planned progress for all the work items across the sprints in your project. Choose Sprint in View by and fetch the work items.
The duration is represented either using the:
- Actual start and end dates of the work item vs the planned start and end dates of the work item.
- Planned log hours vs actual log hours
You can click the drop-down next to the work item and view the actual vs planned progress of the assignees as well. You can also track the total hours logged for all the work items.
The overall progress will determine the total of the actual vs planned hours and their variance.
User based actual vs planned report
Similar to the sprint based report, the managers can track the actual vs planned report for all the users in the project. Choose
Users in
View By to fetch all the work items assigned to the users.
The duration is tracked by the actual vs planned log hours of the work items assigned to them.
You can select the drop-down next to the user to view all the work items assigned to that particular user. You can also track the overall total of the actual vs planned report of all the users in the project.
Filter
If you would like to filter a particular set of criteria and fetch the actual vs planned report, you can do so using the filter option. Click
next to
View By and select the filter criteria.
Export and export history
You can export the actual vs planned report and view the export history anytime. Choose the
Other Actions icon in the upper-right corner and select
Export or
Export History .
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Export log hours
You can export the logged hours from your timesheet to generate invoices for your team members. You can also export the maximum logged hours for the users in your project. Schedule export Navigate to Timesheets. Click in the upper-right corner. ...Work item reminders
You will be able to carry out the following actions based on your profile permissions. Click the Permission Helper at the bottom of the page to know your profile permissions. Are you finding it difficult to manage a whole lot of work items? Set ...Zoho Cliq Extension
In a rapid work culture, there is rarely enough time to discuss things thoroughly. Communication is a key element in any workspace. Your team members are looking for the quickest way to get instant notifications on project updates chatting with their ...Zoho Projects Integration
No matter how many projects you have on your list or teams to coordinate - Managing everything in the right way matters the most. Project management methodologies are many, and every team is bound to follow a standard process. That's why moving to a ...Work item linking
Linking work items helps you create an association between similar, identical, or inter-dependant work items. This allows you to track and manage those work items that are related to each other and be aware of how the progress of those work items ...
New to Zoho LandingPage?
Zoho LandingPage Resources