cancel
Showing results for 
Search instead for 
Did you mean: 
KJC-CPA
Level 2

Methods to Import Timesheets into QuickBooks (And Possibly Completed Paychecks)

Hi, I would like to know the different methods available to import timesheets into QuickBooks. As far as I know, the list is:

  • Sync between QuickBooks and your timesheet application, which is how it's done with QuickBooks Time
  • IIF file import

I'm asking because the company I work for is searching for a new timesheet application and I want to know all the possibilities.

Now there are times when an employee will work under one particular pay code, but is paid at two different pay rates under that pay code, because they are working under different projects/customers. As of now, when that happens, we edit such paychecks manually because QuickBooks doesn't have the option for storing two different pay rates for a employee based on project/customer. That leads to my second question:

If you use a timesheet application that stores the pay rates for employees on its end, is there a way to import completed paychecks directly into QuickBooks that already contain the hours and pay rates (and maybe even expense reimbursements)? It seems unlikely because I know the timesheets in QuickBooks actually feed the paychecks before you "Create" them. But maybe there is a way to turn that off if you're importing completed paychecks directly?

We're currently using QuickBooks Desktop under Right Networks, but that is not set in stone.

Thanks for any help!

4 Comments 4
Fiat Lux - ASIA
Level 15

Methods to Import Timesheets into QuickBooks (And Possibly Completed Paychecks)

You can prepare the 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 utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

As another option, you can utilize a time tracker app to integrate with your QB Desktop. You can compare QB Time and other 3rd party apps. But I am not sure Right Networks allows your QBD to sync with random apps. You should host your QBD on another host or deploy your private cloud environment with a simple solution to manage. 

KJC-CPA
Level 2

Methods to Import Timesheets into QuickBooks (And Possibly Completed Paychecks)

Thank you Fiat Lux. This helps alot.

BigRedConsulting
Community Champion

Methods to Import Timesheets into QuickBooks (And Possibly Completed Paychecks)

@KJC-CPA 

RE: I would like to know the different methods available to import timesheets into QuickBooks.

 

You're right that there's the sync from the Intuit time product and, for Desktop, importing IIF files. If you have your time data in Excel and want to create reliable IIF files from it, use our BRC Timesheet Link.  It'll create IIF files that follow the various QuickBooks rules, such as only recording time using payroll items that are set up on the employee.

 

RE: Now there are times when an employee will work under one particular pay code, but is paid at two different pay rates under that pay code, because they are working under different projects/customers. As of now, when that happens, we edit such paychecks manually because QuickBooks doesn't have the option for storing two different pay rates for a employee based on project/customer.

 

There is a way to handle this that may work for you. In the case where an employee earns two more more different rates of pay depending on what they're doing, set up and use different earnings items on the employee, each with its own rate. Then use those earnings items on time records. Later - when transferred to paychecks - the correct rate will be used by default, gathered from the employee record.

 

RE: If you use a timesheet application that stores the pay rates for employees on its end, is there a way to import completed paychecks directly into QuickBooks that already contain the hours and pay rates (and maybe even expense reimbursements)?

 

Unfortunately no. It actually isn't possible to import paychecks using any method.

KJC-CPA
Level 2

Methods to Import Timesheets into QuickBooks (And Possibly Completed Paychecks)

Thanks BigRed. That looks pretty good. I'll check it out more on Monday.

Need to get in touch?

Contact us