Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowLet's see what report we can pull up to get the data you need, FinanceDog.
Currently, we have three specific project reports that we can easily pull up and customize:
We don't have a direct way of getting the average time spent for services. However, we can customize the Time cost by employee or vendor report and export it to Excel:
Meanwhile, we can also filter the Projects list by status. This way, we can see what projects are in progress, completed, or canceled.
You can also use this link for reference: Customize reports in QuickBooks Online.
Let us know if you want another report that can pull up the data you need.
Thank you for your response. Unfortunately, my query should have been more specific. I want a report that analyzes average time across all non-canceled projects. I'm assuming I can only get the average by exporting a report to Excel.
That leaves how to filter for non-canceled projects. I used the Time Activities by Customer Detail report but do not see how to filter out canceled projects. Any way to do that?
Also, is there a way to have that same report show only the total for each project without having to collapse them manually? This would make it easier to run a quick average in Excel.
Thank you for your time.
Thank you for your response. Unfortunately, my query should have been more specific.
I want a report that analyzes average time across all non-canceled projects. I'm assuming I can only get the average by exporting a report to Excel.
That leaves how to filter for non-canceled projects. I used the Time Activities by Customer Detail report but do not see how to filter out canceled projects. Any way to do that?
Also, is there a way to have that same report show only the total for each project without having to collapse them manually? This would make it easier to run a quick average in Excel.
Thank you for your time.
Hi there, FinanceDog.
Thank you for coming back here to QuickBooks Community to
As mentioned above, running a report that analyzes average time across all non-canceled projects is currently unavailable. And, the workaround is exporting the report in Excel and manually calculate the average time spent from there.
On the other hand, filtering or customizing the Time Activities by Customer Detail report to show non-canceled projects. or canceled projects is unavailable. With this, all the Time Activities you entered in the system associated with ongoing or canceled projects will still show on the said report. Please make sure that you choose the correct customer/employee.
Also, there's no way to have the same report that shows only the total for each project. You can only visit the Project page and manually see the total for each project.
Please refer to this article to see different information about how Projects in QuickBooks Online works: Projects FAQ.
I can see the importance of the features stated above in your business. Rest assured, I'll take note of your idea so that it's included in other customers' requests for future product enhancement of QuickBooks Online. With this, I recommend visiting our Blog site. This is where we share recent happenings and future developments, such as updates to newly added features.
I'm only a couple of clicks away if you need further assistance in managing your account. It's always a pleasure to help. Have a great day!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.