Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 24, 2018
Question

Tsheets & QBO Job Costing Reports

  • October 24, 2018
  • 26 replies
  • 91 views

We have our employees attached to an item and the number of hours sync with the job QBO, however, the amounts are all zero. How can it pick up the employee's pay rate? Or does every employee need to have an item with their own rate? Also, some employees have OT, how can the job costing pickup the different rates? 

 

So in theory, we did set up items for everyone, how would it know to pickup that this is time and a half? Payroll knows... so this should be possible.

 

This seems like a lot of items having over 50 employees.

26 replies

Level 9
October 24, 2018

Hello there, @JLR9.
 

At the moment, there isn’t a way for job costing to pick up employees pay rates. While this option is not yet available in QBO, I encourage you send this as a suggestion to our Product Development Team through your feedback feature and I'll do the same thing from my side.

We'll want to have new features based  on the value they'll add to the most users possible. Your suggestions will be kept in mind for future development plans.

 

To send feedback, here's how:

  1. Click on the Gear icon.

  2. Click Feedback.

  3. Type in your feedback or feature request.

  4. Click Send Message.

You may also want to submit feature requests through this link: http://feedback.qbo.intuit.com/forums/168199.


Stay tuned for now. If there's anything else I can do to help, just let me know by leaving a comment below.

January 7, 2019

So to be clear I need to create a line item for each employee/subcontractor that is in Tsheets and enter their rate of pay for the amount so that I can get effective job costing? Does their name need to be their user name or their full name as it is seen in Tsheets in order for the sync to pick it up?

Rose-A
Level 10
January 7, 2019

Hi, alexisn1.

Allow me to provide additional information about Tsheets and job costing in QuickBooks Online.

 

Yes, you'll need to create a line item for each employee/contractor if they have different rates. Make sure to use the full employee/contractors name to ensure the information records properly after importing.

 

For additional help. feel free to reach out to our QuickBooks Online Support:

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

I'll be around to help if there's anything else you need.

May 13, 2019

Hi 

 

Most of our employees have only one rate, but it seems that we're having the same issue. Employee time is shown as hours on the project page, but doesn't show up as dollar amounts on project expense reports. Is there any way to do that?

MaryLandT
Level 10
July 12, 2019

Hello @sgf292,

 

I've already updated my answer above about voiding your payroll.

 

The article you've found is for QuickBooks Desktop, and that's why you're unable to see the Send Payroll Data option.

 

Let me guide you on how to change the posting account for your payroll expenses.

 

Here's how:

  1. Click the Gear icon at the top.
  2. Select Payroll Settings under Your Company.
  3. Click Accounting under Preferences.
  4. Once you are there, you can see which expense and liability accounts are affected when you create a paycheck, make a tax payment, or create a deduction.
  5. Choose your desired account name from the drop-down list.
  6. Click OK after choosing all your desired accounts.

Changing the settings will only affect for future transactions. If you need to apply these changes to your past transactions, you can backdate previous transactions. This will update all accounts except the selected bank account.

 

Keep me posted if you have follow-up questions concerning payroll. I'd be glad to provide the information you need.