Showing results for 
Search instead for 
Did you mean: 
Level 1

Payroll and Excel



We are looking at getting a new time clock, however, this does not directly get imported in to QB like our last time clock.


We only have the option of exporting as an excel file and importing into Quickbooks.


Can this be done? If so, how?


Thank you!!!

2 Comments 2
QuickBooks Team

Payroll and Excel

Hi CT1231,


Welcome to Community!  Having the ability to import your payroll data in QuickBooks Desktop would be a valuable time saver.  I'd be happy to provide some insight here!


QuickBooks enables you to import specific lists and transactions multiple ways.  It's important to note this cannot be undone, so it's always recommended to create a backup file.  To learn more about the file types and areas that can be imported, follow this link.


Please don't hesitate to contact our Customer Care team outside of Community, for personal assistance with the process.


If you have any other questions, feel free to touch base with us again.  We're here for you!

Fiat Lux - ASIA
Level 15

Payroll and Excel


You can prepare Time Tracking data with the following template

NameTransaction DateCustomerService ItemPayroll itemDurationClassBillableNotes
John Marks01/09/2020Nguyen, TuanLaborRegular Pay1:25   
John Smith02/09/2020Nguyen, TuanLaborRegular Pay2:00   
Karen Marks02/09/2020Links, JohnLaborRegular Pay1:25   
Kathy Linklater02/09/2020Links, JohnLaborRegular Pay1:25   
Johnny Deep02/09/2020Links, JohnLaborRegular Pay2:00   


then use an importer tool to proceed. It's a one time license.


Need to get in touch?

Contact us