We currenly use Tsheets to track time and import it into Quickbooks. We also recently switched from Quickbooks Desktop to Quickbooks Online.
When I export time from Tsheets, it is mapped according to the Payroll Item Mapping Tool. However, our payroll items are more complex than Tsheets allows. We used to simply correct the pay item in Quickbooks desktop after Tsheets exported time. However, with Quickbooks online, we can't change the pay item.
Specifically we pay Overtime for evenings and Saturdays and Double Time for Sundays. As it is now, Tsheets is exporting time for the weekend as regular pay and we can't change it to Overtime or Double Time.
The attached image shows the greyed out field.
Welcome to the Community. I'd be happy to help with changing the pay item in QuickBooks Online.
Thanks for sending the screenshot! When you click on the drop-down (regular pay), do you see an option for other pay types? If not, you may need to add additional pay types through your settings. Here's a helpful article from our Community that has more info:
I want to make sure I steer you in the right direction. Are you using Standard Payroll or Advanced Payroll powered by Wagepoint?
Thanks for the reply. I am using Standard Payroll.
I do have additional pay types setup. The problem is that I can't change the pay type after a row has been saved. In the screenshot you can see that:
- Row 1 has previously been saved. The dropdown box for pay item is greyed out and clicking on it does nothing.
- Row 2 has not yet been saved. I can click on the pay item box and the dropdown box appears, showing my pay options.
The only way I can change the pay item of a saved row is to delete the row and remake it.
I see why this is happening. Weekly timesheets only captures one pay type, which in this case is regular pay. You'd have to manually calculate the other pay types when you're running payroll. Let me know if you need help with that. Otherwise, this is valuable feedback for our engineers. I encourage you to send it over to them by clicking the gear icon and looking for Feedback. New product improvements are largely based on the feedback we get from users like you. Feel free to ask questions.
I don't know if that is quite accurate. I have attached a screenshot showing a timesheet with 5 rows showing different pay items on each row.
Rows 1-3 have already been saved. Each with a different pay item. You can see they are all greyed out can't be changed.
Row 4 is currently being edited. It is currently set to Stat Holiday pay but can still be changed to a different pay item.
Row 5 has not been edited at all yet.
I will definitely send feedback on this. It seems odd to me that the the customer, description, class and billable fields can all be changed but the pay item can't. Even the hours can be changed.
Thanks for describing this in more detail. I'd like for one of our phone support agents to take a closer look at this issue. Please call at 855-253-1536. The hours of operation are Mon - Fri 9 am to 8 pm EST. An agent will be able to share your screen and make sure everything is the way it should be. Let me know if you've got questions.
I called the tech support number you gave me and it seems like the problem is related to using Tsheets. They are going to do a few tests and get back to me.
I appreciate you taking the time out to call. Our agents will make sure they gather enough information to come back with a favourable response for you. In the meantime, feel free to ask questions.
I'll try to keep this thread updated.
In the meantime I have found a workaround. If I remove the Tsheets app from Quickbooks Online, I can then make my changes to my timesheets. Then I have to reconnect the Tsheets app. It is certainly not an ideal solution but it is faster than remaking my weekly timesheets by hand.
I can see how that can take up much of your time. Thanks for your patience with this. Let me know if you have questions.