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

Global Compliance Desk – Dubai

The New DIFC Employment Law 2019 On June 12, 2019, the Dubai International Financial Center (the DIFC) announced the enactment of DIFC Law 2 of 2019 (the New DIFC Employment…Read More

Global Compliance Desk – Luxembourg

Increase of the Minimum Wage On June 25, 2019, the draft law no. 7416 amending Article L. 222-9 of the Labor Code and increasing the minimum social wage by 0.9%,…Read More

Global Compliance Desk – Ireland

New Unpaid Parental Leave Entitlement The Parental Leave Acts allow parents to take parental leave from employment in respect of certain children. Under the Parental Leave Act 1998, parents of…Read More

Demystifying the millennial workforce: 5 tips from Trunk Club’s Andrew Anderson Devine

Time magazine labels the millennial generation the “most threatening and exciting generation,” infamous for “narcissism [and] its effect: entitlement.” In the workplace, the perception of the millennial workforce is no…Read More

Common pitfalls in professional services organizations & how to avoid them (1/3)

The professional services organization (PSO) landscape is changing -- employees are harder to recruit and retain, a globalized marketplace increases competition for clients, clients want more for less, and management…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
  • 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?