Timesheet report
Tracking the time taken to complete the work items is easier now with the 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.
- Go to the Reports module.
- Select View by as Timesheet Reports.
- Select Sprint.
- Select Report type as Sprint. Here, X-axis represents the Sprint Name and Y-axis represents the Log Hours.
Example
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.
View 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.
- Go to the Reports module.
- Select View by as Timesheet Reports.
- Select Sprint.
- Select Report type as Work Item. Here, X-axis represents the Work Item Type and Y-axis represents the Log Hours.
Example
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.
- Go to the Reports module.
- Select View by as Timesheet Reports.
- Select Sprint.
- Select Report type as User. Here, X-axis represents the Log Hours and Y-axis represents the Users
Example
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.
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.
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.
Export and export history
You can export the actual vs planned report and view the export history anytime. Click the Export button. Click the ellipsis icon and select Export history to view the export and download it.
Access your files securely from anywhere
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:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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
Zoho Sprints Quickstart Guide
Zoho Sprints is a project management tool that functions on the principles of Agile Scrum methodology. Here, each project is divided into multiple phases. Each phase comprises select work items for the team to complete. When those work items are ...Canceled sprints
You can cancel the sprints that cannot be completed within the scheduled end date. Learn more. View canceled sprints Navigate to Report module. Select View by as Sprint Reports. Select Report type as Canceled Sprints. The canceled sprints will be ...Completed sprints
This is a consolidated report of completed sprints. This report displays the sprint name, start date, actual and planned end dates, and completed estimation points. It includes an archived view of all the completed sprints in your project, displayed ...Create and manage timesheet
Timesheet in Zoho Sprints is a useful to record and monitor the work hours for work items and sprints. It enables you to measure the completed work in terms of hours. Add log hours Adding log hours is synonymous with creating a timesheet. To add log ...Configure timesheet settings
Timesheet enables you to log your work hours for the purpose of tracking billed and non-billed hours. Zoho Sprints allows you to enable billing status and approval process for timesheet. The are advanced features that enable you to define item based ...
New to Zoho LandingPage?
Zoho LandingPage Resources