cancel
Showing results for 
Search instead for 
Did you mean: 
nyba225
Level 2

Quickbooks Time will not export to Quickbooks Desktop without Payroll Item Mapping Tool

When attempting to export time from Quickbooks Time to Quickbooks Desktop after the recent Quickbooks Desktop update, we are getting errors such as :  "[Employee Name] Aug 1: Error exporting 5.00 hours, the user doesn't have any payroll items assigned. Use the Payroll Item Mapping Tool to assign payroll items to this user and then re-export the time."  Research says that the Payroll Item Mapping Tool requires a Quickbooks Desktop Payroll subscription, which we have no interest in purchasing.

 

Is there any way to export time to Quickbooks Desktop without involving the Payroll Item Mapping Tool?  I have tried unchecking the "Use time data to create paychecks" option in each employee profile, and deactivating the Payroll from Edit>Preferences>Payroll & Employees>Company Preferences> No Payroll.  Neither had any effect on the error.

 

 

Solved
Best answer September 21, 2023

Best Answers
nyba225
Level 2

Quickbooks Time will not export to Quickbooks Desktop without Payroll Item Mapping Tool

Got in touch with Quickbooks support via chat.  After being redirected twice (!) the tech who helped me said to do the following (this only works if you use the Quickbooks Web Connector)

 

  1. Uninstall the current web connector by going in Quickbooks Desktop to File>App Management>Update Web Services, clicking "Remove" on the Quickbooks time application
  2. On the Quickbookstime web page, go to the "QB quickbooks" logo in the top right page,  go to preferences and redownload the web connector via link. Reinstall the connector.

 

After doing this, I had to go into Quickbooks Desktop then go into the Employees menu> Employee Center > [Employee]> The pencil to the right of the "Employee Information" > Payroll Info tab > Then add Item names into the Earnings table.  This added payroll items into Quickbookstime without the need for a premium subscription.

 

I hope this helps future users of Quickbooks Desktop and Quickbooks time.

View solution in original post

6 Comments 6
LollyNino_C
QuickBooks Team

Quickbooks Time will not export to Quickbooks Desktop without Payroll Item Mapping Tool

I appreciate your effort in posting the details of your concern here in the Community, @nyba225. I've come to help you import employee time entries into QuickBooks Desktop.

 

To have the option for the Payroll Item Mapping Tool in TSheets, the QuickBooks account you're connecting should have an active payroll service. Otherwise, you can manually assign payroll items for each employee.

 

When exporting hours from QuickBooks Time to QuickBooks you'll use the Payroll Item Mapping Tool to assign payroll items to it. For each type of hour your employee tracks, there'll be a payroll item assigned. Here's how:

 

  1. Access your QuickBooks Time and select the QuickBooks dropdown.
  2. Next, choose Preferences and click Payroll Item Mapping Tool.
  3. Then, on the Map Employees tab, select an employee's name.
  4. In each hour type column, select one payroll item for each. Selections are saved automatically.
  5. Once finished, close the window.

 

To properly map your payroll items, please refer to this article: Map QuickBooks payroll items

 

Additionally, the links below will guide you on how to integrate QuickBooks Time and QuickBooks Desktop and frequently ask questions about the programs.

 

 

Please reply to this post if you have a QuickBooks Desktop Time-related query. I'll be willing to lend a hand. Have a good day ahead!

JKPowell
Level 2

Quickbooks Time will not export to Quickbooks Desktop without Payroll Item Mapping Tool

I'm having the same problem which has not been answered by in the Quickbooks team response above.

 

nyba225 specifically stated in the subject and body of the question that the solution needed to avoid using the Payroll Mapping tool as that resource is not available without additional subscriptions.  The Quickbooks team response states, "Otherwise, you can manually assign payroll items for each employee." which would mean there is an answer to the question nyba225 raised.  In attempts to resolve the issue using a manually assigned option, this, too, appears to be a dead end in recent QB updates. 

 

Please provide a specific resolution and instruction how to "manually assign payroll items" in order to use QuickbooksTime without a Payroll subscription.

JKPowell
Level 2

Quickbooks Time will not export to Quickbooks Desktop without Payroll Item Mapping Tool

I'm having the same problem which has not been answered by in the Quickbooks team response above.

 

nyba225 specifically stated in the subject and body of the question that the solution needed to avoid using the Payroll Mapping tool as that resource is not available without additional subscriptions.  The Quickbooks team response states, "Otherwise, you can manually assign payroll items for each employee." which would mean there is an answer to the question nyba225 raised.  In attempts to resolve the issue using a manually assigned option, this, too, appears to be a dead end in recent QB updates. 

 

Please provide a specific resolution and instruction how to "manually assign payroll items" in order to use QuickbooksTime without a Payroll subscription.

MJoy_D
Moderator

Quickbooks Time will not export to Quickbooks Desktop without Payroll Item Mapping Tool

Hello, @JKPowell

 

I can share additional information about mapping payroll items in QuickBooks Time to QuickBooks Desktop (QBDT).

 

You can map your payroll items by having an active subscription payroll. Then, import your data from QuickBooks Desktop to QuickBooks Time using web connector. It'll make sure that your data will be updated and synced. 

 

Refer to this article for more information about using the Payroll Item Mapping Tool to assign payroll items to your hours: Map QuickBooks payroll items in QuickBooks Time

 

I suggest reaching out to our Customer Support team to check for any workarounds that can help you with mapping your payroll items without a payroll subscription. Refer to this article for detailed guidance on how to contact them and their availability: Contact QuickBooks Time support

 

I'm always here if you need help with mapping your. Let me know by leaving a reply below. Take care and have a great rest of the day!

nyba225
Level 2

Quickbooks Time will not export to Quickbooks Desktop without Payroll Item Mapping Tool

Got in touch with Quickbooks support via chat.  After being redirected twice (!) the tech who helped me said to do the following (this only works if you use the Quickbooks Web Connector)

 

  1. Uninstall the current web connector by going in Quickbooks Desktop to File>App Management>Update Web Services, clicking "Remove" on the Quickbooks time application
  2. On the Quickbookstime web page, go to the "QB quickbooks" logo in the top right page,  go to preferences and redownload the web connector via link. Reinstall the connector.

 

After doing this, I had to go into Quickbooks Desktop then go into the Employees menu> Employee Center > [Employee]> The pencil to the right of the "Employee Information" > Payroll Info tab > Then add Item names into the Earnings table.  This added payroll items into Quickbookstime without the need for a premium subscription.

 

I hope this helps future users of Quickbooks Desktop and Quickbooks time.

AlcaeusF
Moderator

Quickbooks Time will not export to Quickbooks Desktop without Payroll Item Mapping Tool

Hello nyba225,

 

I have reviewed the solution you’ve shared and it's correct and accurate. Thank you for sharing your input to help address the issue.

 

We love to see members supporting one another! Have a great day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us