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 would like to know the different methods available to import timesheets into QuickBooks. As far as I know, the list is:
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!
You can prepare the time tracking 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 | |||
Kathy Linklater | 02/09/2020 | Links, John | Labor | Regular Pay | 1:25 | |||
Johnny Deep | 02/09/2020 | Links, John | Labor | Regular Pay | 2: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.
Thank you Fiat Lux. This helps alot.
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.
Thanks BigRed. That looks pretty good. I'll check it out more on Monday.
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