Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
When I create a T&M invoice I select the "time and costs tab". Is there a report that has this information combined, with subtotals if possible? So I can review prior to populating my invoice? If not, can I please get a reference on hiring someone to create this report for my company?
Hello there, @Brenda17200. Let me share information about the report that you want to pull up in QuickBooks Desktop.
You'll want to run two separate reports for the time and cost that need to be combined. Please note that the cost data will not be displayed if payroll has not been completed or expenses have not been generated for employees/vendors linked to the billable time for the customer.
That said, you can run the Time by Job Detail and Payroll Item Detail reports in QBDT. To run the two reports, follow the steps below:
To run the Payroll Item Detail report, follow the steps below:
Then, you can consider exporting the report in Excel. From there add the totals and other other details on the report. In the same manner, here's an article you can read to learn more about how you can customize a report: Customize customer, job, and sales reports in QuickBooks Desktop.
Additionally, to learn more about how QuickBooks generates reports, you can refer to this article: Understand reports. It also includes the complete lists of available reports in QBDT
Please let me know in the comment section below if you have follow-up questions while working on your reports. I'll be right here to help you out. Have a good one!
Yes, that is what I have been utilizing. I need "real time" updates in excel, without having to export and manipulate. Can anyone refer someone I can hire to create this report? Either in Advanced Reporting or ODBC? I need the reports listed to be combined, with subtotals by items and in real time.
Thanks for getting back here in the thread, @Brenda17200. We'll share details about accessing reports and adding specific details to them inside QuickBooks Desktop (QBDT).
Before anything else, please know that we see the relevance of having the option to get real-time updates for Excel reporting without exporting and editing your business report details. As we check here on our end, the option you're trying to access isn't available inside the program. That said, you'll need to export them to refresh or get updated data whenever you want to view business reports from the QBDT program.
You may also visit a separate thread where developers, engineers, and IT personnel can help you achieve advanced reporting or ODBC using the program. We'll write down the steps below to get you going:
With regards to having to adding more details to your business report, know there's an option to customize them inside the program. You can check this page for more details: Customize reports in QuickBooks Desktop.
In addition, you can visit this page to help you keep your current report settings for future use: Create, access and modify memorized reports.
We're open 24/7 if you need further assistance managing business reports inside the program, @Brenda17200. Feel free to visit the Community space or comment below so we can help you out right away. Have a good one.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here