Using Employee Timesheet for keeping track of hours showing overtime and vacation.

WayneCarter · ‎August 11, 2017

I need an hourly tracking software that will keep track of hours and show the total over 40 hours per week and keep them accumulated as overtime hours total, but will deduct from them when they are used. I also want it to track my vacation hours. I have been using Quickbooks Online Timesheet to keep track of my hours, but do not know if that module allows you to input a 40 hour week and it to calcualte the overtime available per week along with keeping a running tally of it over the year along with deductions when those overtime hours are used / credited and also to track vacation time used. If quickbooks online timeline module does not allow this is there a ad on to use with it I can purchase or a stand alone software product that will handle this that is reasonably priced. I am not looking for any legal hourly governemtn rules only a program to track the hours and keep a tally of how many over 40 per week and allow me to edit this when some are used / credited / paid and also track vacation hours.

If anyone knows if there is a way to do this with the timesheet module of quickbooks online, or with an addon to quickbooks or with another reasonbaly priced stand alone program please let me know.

Feel free to email me at [Removed] or call [Removed] Thanks Wayne Carter

qbteachmt · ‎August 11, 2017

I see your area code implies you are in the US.

If that is true, then you should ask your own Department of Labor if this is legal:

"then show the amount of overtime"

A. Salary typically = No OT. Whether you work 30 hours or 50 hours, Salary = Salary = you are paid for the services. There are some current rules undergoing review for the "Salary Subject to OT" regulations, based on a Low Salary set by the employer to try to avoid the OT trigger. Whether that is you or not, is something to review with your Dept of Labor.

"available as comptime,"

Most private employers in the US cannot allow Comp Time. You have to Pay for the time worked, and cannot Bank it in lieu of Paying for it. You can Pay for it, then offer Unpaid time off, later. Again, Ask Your State about your labor laws.

"and I can input when I am using the comptime for less than a 40 hour week, which will also accomodate and tract my vacation time."

Again, Salary = No such thing as paid or unpaid vacation. The use of Salary = this person gets, for instance, $5,000 a month. It doesn't matter if they work 20 hours a week, and then 60 the next week, or take a day off for "vacation" from the perspective of Pay Rate or OT.

Yes, you can and should track attendance, in case the person isn't meeting required performance.

You need to discuss this with your State.

Now, I usually point people to the Local Job Service or Workforce Center. They love to hear from and work with Employers, because they want to help you Know your Requirements. You pay for this service through your Unemployment rates for FUTA and SUI.

And in my State, the Legislature meets every other year, so the rules might change. That's why I stay in touch with the lady at Job Service that works with Employers.

View solution in original post

qbteachmt · ‎August 11, 2017

I see your area code implies you are in the US.

If that is true, then you should ask your own Department of Labor if this is legal:

"then show the amount of overtime"

A. Salary typically = No OT. Whether you work 30 hours or 50 hours, Salary = Salary = you are paid for the services. There are some current rules undergoing review for the "Salary Subject to OT" regulations, based on a Low Salary set by the employer to try to avoid the OT trigger. Whether that is you or not, is something to review with your Dept of Labor.

"available as comptime,"

Most private employers in the US cannot allow Comp Time. You have to Pay for the time worked, and cannot Bank it in lieu of Paying for it. You can Pay for it, then offer Unpaid time off, later. Again, Ask Your State about your labor laws.

"and I can input when I am using the comptime for less than a 40 hour week, which will also accomodate and tract my vacation time."

Again, Salary = No such thing as paid or unpaid vacation. The use of Salary = this person gets, for instance, $5,000 a month. It doesn't matter if they work 20 hours a week, and then 60 the next week, or take a day off for "vacation" from the perspective of Pay Rate or OT.

Yes, you can and should track attendance, in case the person isn't meeting required performance.

You need to discuss this with your State.

Now, I usually point people to the Local Job Service or Workforce Center. They love to hear from and work with Employers, because they want to help you Know your Requirements. You pay for this service through your Unemployment rates for FUTA and SUI.

And in my State, the Legislature meets every other year, so the rules might change. That's why I stay in touch with the lady at Job Service that works with Employers.

Teri · ‎August 11, 2017

If by chance you are a Govt contractor or are working on getting Govt contracts, I can assist you with this as there is a slew of regulations and requirements on top of what has been mentioned below. In GovCon, what you are referring to is called UCOT (Uncompensated Overtime) and how you handle it can depend on your contract type and the specific contract (agreement) with customer as to how they will be billed for your time.

WayneCarter · ‎August 11, 2017

This unfortunately is not what I am looking for I know employement laws I am looking for a good tracking software.

I need an hourly tracking software that will keep track of hours and show the total over 40 hours per week and keep them accumulated as overtime hours total, but will deduct from them when they are used. I also want it to track my vacation hours. I have been using Quickbooks Online Timesheet to keep track of my hours, but do not know if that module allows you to input a 40 hour week and it to calcualte the overtime available per week along with keeping a running tally of it over the year along with deductions when those overtime hours are used / credited and also to track vacation time used. If quickbooks online timeline module does not allow this is there a ad on to use with it I can purchase or a stand alone software product that will handle this that is reasonably priced. I am not looking for any legal hourly governemtn rules only a program to track the hours and keep a tally of how many over 40 per week and allow me to edit this when some are used / credited / paid and also track vacation hours.

WayneCarter · ‎August 11, 2017

No I am not a goverment employee. I am just looking for a good time tracking software that will handle all this.

I need an hourly tracking software that will keep track of hours and show the total over 40 hours per week and keep them accumulated as overtime hours total, but will deduct from them when they are used. I also want it to track my vacation hours. I have been using Quickbooks Online Timesheet to keep track of my hours, but do not know if that module allows you to input a 40 hour week and it to calcualte the overtime available per week along with keeping a running tally of it over the year along with deductions when those overtime hours are used / credited and also to track vacation time used. If quickbooks online timeline module does not allow this is there a ad on to use with it I can purchase or a stand alone software product that will handle this that is reasonably priced. I am not looking for any legal hourly governemtn rules only a program to track the hours and keep a tally of how many over 40 per week and allow me to edit this when some are used / credited / paid and also track vacation hours.

Teri · ‎August 11, 2017

Hi Wayne,

Just to be clear, I am not referring to Government employees, I am referring to regular companies whose customer is the Govt, so they have Govt contracts, which must follow additional regulations. I can provide many excellent recommendations if you have those requirements, but they would likely cost more than you would want to pay if you do not have the Govt customer reimbursing you for these additional features. For example, Unanet is an excellent timekeeping system that interfaces with QB and can do almost anything if you want to check it out. The President of the company is Chris Craig and he can answer you in minutes. They are an excellent privately-owned company and have interfaced with QB for well over 20 years.

Teri · ‎August 23, 2017

WayneCarter - Did you find what you were looking for? Just checking since I saw your message again.

It is usually difficult to find software that does illegal payroll or accounting functions for obvious reasons.

I have to agree with QBTeachmnt that salaried employees do not generally get overtime or comp time. Perhaps you are some very rare exception to those laws, which I cannot imagine, but I never say never.

In order for any system to do this, would likely require more than the ususal tweaking to customize QB,

and I am sure there are people out there who can do anything, but will be hard to find in an online site.

What I'm curious to know in order to try to help you (and was trying to ask by guessing Govt contractor),

is what is driving you to record hours in the first place and to try to account for comp time hours to use? Seems very unusual to see that level of detailed accounting implying compliance with a requirement for customer or agency considering the extra time and work involved up front, to then conflict with the most basic Federal labor laws which apply to all U.S. companies. This unique combo intriques me to inquire to help you if possible and/or learn something new that I have not seen yet in my 40 years of accounting.

Anonymous · ‎March 21, 2019

wow, you guys know nothing about government contractors. When you are working with government contractors, you must keep track of your uncompensated OT if you are an exempt employee. exempt means you are exempt from the fair labor laws and are usually a salaried employee except if you are a government contractor, then you are working hourly but not being paid or compensated for your OT. these hours MUST be accounted for in an accounting database like QB.

Topics

Training

Community

Resources

Using Employee Timesheet for keeping track of hours showing overtime and vacation.