Tag Archives: excel

August Release: New Reports and Features

This week we’re releasing some new reporting features to Quick Timesheets, so we thought we’d share some of these new improvements on our blog. As always, we’d love to hear from you if you have any feature requests.

Budgeted Hours Report

You can now allocated an “Estimate Hours” to a task, and bring up a report to see the completion of hours logged vs the projects or tasks budget.

Budgeted Hours Report
Example: You might allocate 100 hours to a particular project, and the report will highlight the number of hours completed against the budget. If a project is running over budget, the chart will display the task in Red ( > 100%).

How can I set up a Budgeted Hours Report?
To set up a budget of hours against a project or task, just edit a Task (Settings -> Client/Tasks) and enter the budgeted hours in the “Estimated Hours” field. You can edit this field at any time in case you want to allocate more hours to a task.

Download to Excel / CSV

This has been a frequently asked for feature so we’re very pleased to announce this! You can now download the tabular data for most reports into Excel or any software that accepts CSV (comma separated values) .

Download to ExcelTo download to Excel, download your report data using the “Download to Excel/CSV” link at the bottom of the chart. You can then load this into Excel or your favorite spreadsheet application.

Report Hours By Category

You can now chart the number of hours logged by Category of time. You can set up your own Categories from the Settings page, and the report also breaks down the Rate Type for each Category.

Report Hours By Category

As an example you can chart the breakdown of Billable and Unbillable time for Meetings, Research and Design.

Thanks again to all our customers and for suggesting new features for Quick Timesheets. We build our software for our customers, so please ask us if you have a feature request. If you’re new to Quick Timesheets, why don’t you sign up to a free trial or have a look at more of our features?

- The Quick Timesheets team