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

Overtime doesn't work right

This is really frustrating! TSheets keeps reporting that employees have overtime. I can't figure out how it calculates it. They aren't working more than 40 hours per week and I don't have any settings on for "over x number of hours" yet anything someone works over 8 hours is in red. It somehow comes up with some OT and not even the hours over 8 add up to this. What 's going on?

Solved
Best answer April 15, 2020

Best Answers
Ami_D
Intuit

Overtime doesn't work right

@HaveBlue I completely understand the frustration here. However, I do think there are some settings we can tweak to have your Overtime appear correctly and transfer accurately. 

If at anytime I've misunderstood anything you said above, please let me know and I'll circle back. 

1) You mention setting Daily Overtime to pay after 23 hours. 

Calculating Daily Overtime is completely optional, so if you do not wish to calculate or pay daily overtime, you can

 

  • Open Company Settings
  • Select Payroll and Overtime
  • Open the Overtime tab
  • Uncheck the box next to "Also calculate daily overtime after:"
  • Save

This will prevent overtime calculations on a daily basis, no matter how many hours an employee works. 

 

2) You mention Overtime being calculated on a different schedule than your pay periods. 

 

If you calculate Overtime based on pay periods instead of calendar weeks, there are definitely options for that! There's something in TSheets called the Payrate Engine that offers more advanced options for Overtime. 

This article has all of the details on how to set-up advanced Overtime rules: https://quickbooks.intuit.com/learn-support/en-us/feature-preferences/configure-and-change-advanced-...

3) You mention reporting in a different format than QuickBooks

 

You can adjust the format of any TSheets report when running the report. For example, when running the Payroll Report, in Filters, you'll see a line labeled "Show hour totals in:" and you can change that to HH:MM. 

I hope these suggestions help out! I definitely want to make sure that we leave here with TSheets not only tracking and reporting correctly but saving you time instead of creating frustration. :) Let me know if you run into any roadblocks above and we'll work through them together. 

View solution in original post

6 Comments 6
Ami_D
Intuit

Overtime doesn't work right

Hi there @HaveBlue! I'm more than happy to help here, and please accept my apologies for the frustration you're experiencing.

A few things here. :) In TSheets, regardless of Overtime rules, timesheets that exceed 8 hours will appear red in color even though they are not actually marked as Overtime. It's a bit confusing, I know, but don't worry. If you see it turn red, it's just an indicator that your employee worked more than the typical amount of hours that day. 

However, I'm still concerned if OT is appearing in your payroll reports when you don't expect it. When you run the Payroll Report for a defined pay period, you'll see your actual calculated Overtime at the top of the report in a red box. Does that number align with what you expect for, say, last pay period?

HaveBlue
Level 2

Overtime doesn't work right

I changed the overtime rules to pay overtime after 23 hours of work. At least that stopped the red display after 8 hours. Someone hard coded something. Hours still show as overtime because it calculates on a calendar week and our payroll is not  a calendar week. Not sure if that's how the federal law works or it's another hard coded setting based on someone's local idea. Can't imagine what someone from another country does using Tsheets. In any case, paying someone extra money in another pay period counts as hours for that week. I guess maybe the bonus feature gets around that somehow? So I moved that entry to another week within the already paid period otherwise there is no way not to again pay overtime. I tried turning off overtime in Quickbooks but it refuses to pay the overtime hours even at straight time. They simply vanish entirely though they show on reports in QB and now the employee is getting paid less hours than they worked. I can't reliably compare the hours in Tsheets to Quickbooks to see what's missing because Tsheets reports in DECIMAL hours and and Quickbooks reports in HOURS:MINUTES. There doesn't seem to be a report to show whats considered overtime anyway. It just calculates it on the fly. 

Ami_D
Intuit

Overtime doesn't work right

@HaveBlue I completely understand the frustration here. However, I do think there are some settings we can tweak to have your Overtime appear correctly and transfer accurately. 

If at anytime I've misunderstood anything you said above, please let me know and I'll circle back. 

1) You mention setting Daily Overtime to pay after 23 hours. 

Calculating Daily Overtime is completely optional, so if you do not wish to calculate or pay daily overtime, you can

 

  • Open Company Settings
  • Select Payroll and Overtime
  • Open the Overtime tab
  • Uncheck the box next to "Also calculate daily overtime after:"
  • Save

This will prevent overtime calculations on a daily basis, no matter how many hours an employee works. 

 

2) You mention Overtime being calculated on a different schedule than your pay periods. 

 

If you calculate Overtime based on pay periods instead of calendar weeks, there are definitely options for that! There's something in TSheets called the Payrate Engine that offers more advanced options for Overtime. 

This article has all of the details on how to set-up advanced Overtime rules: https://quickbooks.intuit.com/learn-support/en-us/feature-preferences/configure-and-change-advanced-...

3) You mention reporting in a different format than QuickBooks

 

You can adjust the format of any TSheets report when running the report. For example, when running the Payroll Report, in Filters, you'll see a line labeled "Show hour totals in:" and you can change that to HH:MM. 

I hope these suggestions help out! I definitely want to make sure that we leave here with TSheets not only tracking and reporting correctly but saving you time instead of creating frustration. :) Let me know if you run into any roadblocks above and we'll work through them together. 

HaveBlue
Level 2

Overtime doesn't work right

Thanks I'll look at those suggestions

john-pero
Community Champion

Overtime doesn't work right

Federal law is 40 hours per calendar week. Some states do have rules that impose OT for daily above 8, which you would have to determine your state rule

tammylucero
Level 2

Overtime doesn't work right

I hope you have it all straightened out now.  I just wanted to add also in the company settings you can specify your week start date.

>Company Settings

>>Payroll & Overtime

>>>Pay Period

Need to get in touch?

Contact us