Skip to main content
C
CT1231
September 28, 2023
Question

Payroll and Excel

  • September 28, 2023
  • 2 replies
  • 0 views

Hi,

 

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 replies

T
Trish_T
September 28, 2023

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
Fiat Lux - ASIA
September 29, 2023

@CT1231 

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.

https://get.transactionpro.com/qbd

 

Terms & ConditionsAccessibility statement