Tag Archives: payroll timesheet

Why is TimeControl so popular with the Payroll Department?

TimeControl Payday, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisWe often talk about TimeControl in association with project management tools but, because it is a multi-function timesheet system, TimeControl is often managed by the Payroll department.  What is it about TimeControl that makes it so popular with Payroll Departments?

First of all, let’s acknowledge that virtually every Payroll system has some kind of timesheet attached to it. We have nothing bad to say about any of them.  But Payroll timesheets are single purpose.  They’re designed to give that particular Payroll system what it needs to process employee pay.  The attractiveness of TimeControl is that it can be used not only for Payroll but also for updating Project Management, Human Resources, Billing, Job Costing and other internal systems and processes.  The benefit for Payroll is, that if the timesheet can do what they need, then everyone in the organization can be using one timesheet instead of several and that will create huge efficiencies in reducing reconciliation between disparate systems.  TimeControl was designed from its inception to meet the needs of Payroll.

So, what are some aspects of TimeControl that make Payroll happy?

It’s Auditable

If a project finance report is off by a hundred dollars or more, no one gets too excited.  But, if a paycheck is off by a single penny, there is all kinds of upset.  So, all entries, changes and approvals of time in the TimeControl timesheet is tracked and is completely auditable.  Even post posting changes are traced on a line-by-line basis.  This is an essential element of a Payroll system.  If the numbers are questioned, they can be recovered from the original entry and any changes will be immediately visible.

Approvals

If your timesheet is going to Payroll, then it almost certainly has to go through some level of approval.  It might be very simple or have multiple levels but knowing that the data that arrives into the Payroll system has passed the approvals required is a must.

Automated Validation Rules

When we explain this to prospective clients, the eyes of the Payroll staff light up.  TimeControl can have as many automated Validation Rules as desired.  A rule might be simple like “for salaried staff, no timesheet should be more than 24 hours a day” or “no salaried person can book more than 40 hours of regular (meaning paid-for) time in a week. Or a rule could be complex like “your timesheet cannot have more than 8 hours of sick leave on a weekday and no sick leave at all on a weekend”.  You get the idea.  Some clients have a handful of validation rules.  Some clients have dozens or more.  It’s all about catching potential and obvious errors at the point of entry rather than in a long cycle where someone has to start communicating from Payroll back to an employee about timesheet problems affecting their pay.

Validation Rules can be errors which must be corrected before the timesheet is released or they might just be a warning like “Be advised you have now used all of your paid-for sick leave.”  It’s up to the client to determine what rules are important to create in TimeControl.

Accommodating both Wage and Salary staff at the same time

Rules for Payroll for salaried employees and wage employees are often quite different.  Salary employees, for example, rarely are paid overtime.  Wage employees are often paid for overtime.  Some organizations want to pay overtime at different rates.  “Time-and-a-half” or “Double-time” are common requests.  Some organizations want to give employees an option to book their overtime into a bank to be used to take time off later.  All of these options and more are a part of TimeControl.  This means that both Wage and Salary staff are easily managed within the same system even if the calculations and rules are different.  Vacation time for example might be calculated at the end of each month as a number of days of vacation earned for the last 30 days for salaried staff.  Wage staff might have vacation accrued automatically by TimeControl also but calculated based on the number of hours worked that week.  Two different calculations, both handled in the same system.

Rates for Payroll, Billing and Project Management at the same time

Payroll’s perspective on rates is what will result in an employee’s paycheck.  But the Billing department looks at Rates differently.  First of all, the values of what we bill at vs. what we pay are almost always different and secondly, there will be hours counted for Payroll that might not be counted for Billing.  Project Management usually uses an aggregate or average rate to keep their reporting simpler.  TimeControl handles all of this and much, much more by allowing distinct values for each rate code.  So, for a particular employee, TimeControl might record their pay rate as $40, their billing rate at $60 and their project rate at $50.  Plus, security in TimeControl goes all the way to the field level.  Employees are almost never shown the values associated to their timesheet and individual pay rates are almost always restricted to only the limited number of Payroll staff who are allowed to see them.

Batch Transfer

Once the timesheets are complete in TimeControl, the data usually needs to go somewhere else; sometimes to several somewhere else’s.  TimeControl’s export mechanisms can track the batch of exported records so that a timesheet line is never accidentally sent twice.  Even after adjustments and corrections, only the new changed records are sent.  Batch Transfers are kept in TimeControl so a batch could be recreated if necessary.  The ability to know what was sent to the Payroll system and when and know that those records won’t ever be sent twice to inadvertently doubling someone’s pay is a favorite with Payroll.

What about Contractors?

As we’ve described in recent blog posts, TimeControl can accommodate both employees and contractors within the same time.  These records can be flagged distinctly so the contractor hours don’t go to Payroll, but rather to Accounts Payable and the hours of both employees and contractors can go to Billing.  Sound confusing?  It’s nothing compared to keeping separate systems and then trying to reconcile them later.  TimeControl was built for this.

What about timesheets that are only by exception?

Some employees do the same thing every day and are not tracked by Project Management, or Billing.  Imagine a receptionist for example.  They don’t even really need to do a timesheet except when there’s an exception such as a vacation day or a sick leave day.  TimeControl handles this with a function called Autofill.  If there are no exceptions, TimeControl will created an fill in an automatic timesheet for that employee with the appropriate number of hours per day.  If someone took a half-day of personal time off, then they can enter that and Autofill will just “top-up” the hours to the expected total for the day.  It can save enormous amounts of time making sure we have complete records for all the staff but not make people do work that creates no value to the company.

Is that it?

Goodness no.  There’s lots more in the TimeControl functionality that Payroll will find of interest.  Here are a couple of areas of the TimeControl website that will have more information that includes webcasts, white papers, slide shows and more:

Managing non-project hours in TimeControl

TimeControl is so often talked about as a project management tool that we sometimes forget how important it is to manage hours that aren’t part of a project at all.  One of the most powerful aspects of TimeControl is being able to be the timesheet that can track hours for tasks as well as all the non-project time.  This allows a timesheet to be entered that is complete.  It has all the hours spent in the organization for all purposes.

Unlike the timesheets that are included with many project management systems, TimeControl is designed to serve both Project Management and Human Resources at the same time. A TimeControl timesheet may have entries that are destined for updating tasks in a project but it might also have hours that are key for invoicing, for job costing, for vacation, sick leave and other entitlements and, of course, for payroll.  Only an auditable timesheet is suitable for these multiple purposes at once and TimeControl is designed with this in mind.

Aside from the obvious time and attendance functionality, there are numerous functions within TimeControl to support these many non-project processes they include:

  • TimeControl’s Banks management includes functionality to track time off, overtime, sick leave, banked overtime, vacation management, training time and more. This gives Human Resources powerful auditable tools for tracking entitlements that have been taken and time remaining for those categories.
  • TimeControl’s TimeRequest™ lets timesheet users request vacation or personal time off in advance and once approved, have that time automatically inserted right into their timesheet on the appropriate day.
  • TimeControl Accruals does automatic, auditable calculations of overtime, banked time, rate changes and keeps a traceable record of when time and extra earnings were earned.
  • TimeControl’s TimeRequest™ Wizard lets an administrator pre-approve days off for such as holidays for large groups of users and have those timesheet entries automatically appear in user’s timesheets on the appropriate day.
  • TimeControl’s business Validation Rules lets you configure the rules that are appropriate for using entitlements like vacation time or personal time off so that users don’t accidentally take sick leave on a weekend or vacation time that wasn’t approved or personal time off that exceeds the time in their bank.

The free TimeControl and Human Resources Portal has extensive information on the non-project use of TimeControl including white papers, webcasts, factsheets and video lessons to help you understand how TimeControl timesheets can play and important role far beyond your project management needs.

 

Timesheets by exception

autofill1.pngNot every organization expects all their staff to fill in a timesheet every single week.  Instead, theses salaried staff are instructed to fill in a timesheet only “by exception” meaning only if they were not at their intended post for the entire pay period.  If the employee has an exception such as a sick day, vacation, a day when they left early, etc.  they must then enter only the exception.

TimeControl can be used like this of course because if that is what your payroll system expects, then TimeControl export to the payroll system will have only the expected exceptions.

Ah, but if life were only that easy.

Here’s a much more difficult scenario:  Imagine an organization where some of the staff who are project oriented must fill out timesheets to account for their entire week and other non-project personnel will be asked to only fill in timesheets by exception.  Must there then be two separate timesheet systems?

Not at all.

TimeControl’s AutoFill functionality is designed to fill in where the exception timesheet leaves off.  Here’s how it works.

First, define who will be entering timesheets by exception.

Next, create a process that allows people who have exceptions to enter them by a certain time in the timesheet period.  For example on a weekly timesheet perhaps exceptions must be entered by noon on Monday.

Now run the AutoFill functionality and have it “fill-up” the timesheets for the people defined to the total number of hours per day that you define.

In this manner TimeControl will create blank timesheets and automaticall fill them in or add to the exceptions that are already there to fill in a complete timesheet.  Now the project staff who enter a complete task-based timesheet every week and the non-project staff who enter a timesheet only by exception will end up with a completed timesheet that can be reported on together, exported or analyzed together and, if you still need to send only the exceptions to the payroll system, that too can be filtered to send only the appropriate data.

TimeControl’s AutoFill is one of the more popular features for HR and Payroll adminstrators for the enormous time it saves by automating a simple function and allowing a single timesheet to replace multiple timesheets.

You can see more HR related functions in the TimeControl and HR use-case area of the TimeControl.com website.