Using spreadsheets as an employee time-tracking tool may seem harmless. After all, it's not a document that multiple employees need to access. It doesn’t require collaboration. So, why is it a problem?

One big problem arises from the fact that errors are so easy to make in spreadsheets. A simple misclick can ruin the entire time-tracking spreadsheet, or produce inaccurate results. And, as mentioned below, that's just the tip of the iceberg.

"Spreadsheets and even paper-based processes are rife in many companies to track employee hours," says Jose Gaona, Vice President of Product Strategy at Replicon. “Not only can this be fraught with errors as spreadsheets weren't optimized to manage multiple staff rates, projects and tasks – but it's also not able to integrate seamlessly with payroll for quick and accurate processing. This issue is magnified as a company grows and it needs to take into account global wage and hour regulations including mandates on overtime pay and time off, as timesheets using spreadsheets have weak controls, making them more susceptible to time theft and inaccurate data entry.”

Potential problems created when you use spreadsheets as a time-tracking tool

Data errors: Spreadsheets make data errors easy to make, yet hard to catch. Do you really want to risk data errors with something as important as time tracking (which impacts payroll)?

Wasted time: Manually reviewing and managing timesheets wastes time. Just imagine how much time gets wasted manually checking timesheets and importing that data into payroll software.

Risk of noncompliance and lawsuits: Poor time tracking can lead to audit failures and a failure to comply with wage-and-hour restrictions. According to the National Employment Lawyers’ Association, there has been a 77% rise in FLSA lawsuits tied to wage-and-hour disputes since 2004.

Original Source: mrc

Get started today.
Set up a free trial based on your business needs. Start Free Trial

4 Ways to Drive Efficiency in Your Nonprofit

HR Daily Advisor | Dec 03, 2019 By Maggie Deptuck, Global SVP at Replicon Nonprofit organizations (NPOs) have a lot on their plates. Aside from operating with limited funds, maintaining…Read More

Global Compliance Desk – Nevada

Nevada Enacts Bill Regarding Paid Personal Leave and Minimum Wage Nevada has recently passed a personal leave law (SB312), which, valid from January 1, 2020, will require private employers with…Read More

Global Compliance Desk – United States

Overtime Pay Update The U.S. Department of Labor has declared a final rule to make 1.3 million American workers qualified for overtime pay under the Fair Labor Standards Act (FLSA). …Read More

Exempt vs non-exempt workers: simplify employee classification

In the United States, most jobs are governed by the Fair Labor Standards Act (FLSA), which classifies workers into two broad categories: exempt and non-exempt. Under the FLSA, non-exempt employees are…Read More

The five reasons employees work overtime

Very few people enjoy working overtime, and even fewer companies want their employees stretching their hours. Besides the costs of paying overtime (and a few extra costs), research has shown…Read More

The 7 must-haves for choosing the right professional services management solution

Not too long ago, if you asked any professional services organization to tell you how they managed client projects, resources and utilization rates, the answer was always the same: spreadsheets.…Read More
  • Cloud
  • In The News
  • Corporate
  • Professional Services Management
  • Project and Program Management
  • Shared Services Management
  • Time and Attendance Management
  • Workforce Management
  • Customer Feature
  • Feature Update
  • Time Intelligence
  • Industry News
  • Webinar Recap
  • Global Compliance Updates
  • 
    Chat with us
    How can we help you?