Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
I am wondering if there is a way to export timesheets in Excel file from Quickbooks desktop version.
Please advise.
Prepare the data with the following template
Name | Transaction Date | Customer | Service Item | Payroll item | Duration | Class | Billable | Notes |
John Marks | 01/09/2020 | Nguyen, Tuan | Labor | Regular Pay | 1:25 | |||
John Smith | 02/09/2020 | Nguyen, Tuan | Labor | Regular Pay | 2:00 | |||
Karen Marks | 02/09/2020 | Links, John | Labor | Regular Pay | 1:25 |
Then utilize one of these 3rd party importer tools
https:// transactionpro.grsm.io/qbd
https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
I was wondering about export not import.
Thanks.
You'll have to pull up the Timesheet report from the Reports Center page in QuickBooks Desktop (QBDT), @Lookout1. This way, you can export the said report in Excel and keep a copy of your employees' time spent at work.
You can easily export reports to Excel from QBDT. This is to let you analyze your payroll data and save reports for your reference. Let me guide you how.
I've attached screenshots below that show the first five steps.
Additionally, you can also select either the Summarize Payroll Data in Excel or More Payroll Reports in Excel option to export other payroll data in QBDT. Just go to the Reports menu, then select Employees & Payroll.
I'm also adding this article for the list of payroll reports that can be exported to Excel in QBDT: Excel based payroll reports. It also provides a step-by-step guide on how to generate them in the system.
Please let me know if you have other concerns. I'm just around to help. Take care always.
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