Solved

Overtime doesn't work right

Forum|Forum|6 years ago
April 15, 2020
2 replies
0 views

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?

QuickBooks Time

Best answer by Ami_D

@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-overtime-settings/00/380808

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.

Ami_D

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?

H

HaveBlueAuthor

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_DAnswer

@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-overtime-settings/00/380808

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.

T

tammylucero

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded