The Hidden Maths of Manual Timesheets

Let me show you the maths that shocked a Christchurch manufacturer last month.

The company employs 45 people. They make components for agricultural equipment. Every worker fills out a paper timesheet. Every Friday, someone enters those numbers into Excel.

The owner thought this system worked fine. "It only takes our admin person a couple hours," he said.

Then we did the maths together

First, the obvious costs:

• Admin time: 3 hours weekly × $30/hour = $90
• Manager review: 1 hour weekly × $60/hour = $60
• Weekly cost: $150
• Annual cost: $7,800

The owner nodded. "That's not too bad for a business our size."

Then we found the hidden costs. Error rate. Studies show manual data entry has a 1% error rate. That seems tiny. But the company processes $58,000 in weekly payroll. A 1% error means $580 in mistakes every week. Most get caught and fixed. But fixing them takes time. More hours. More cost.

Time theft. Without exact clock-in times, employees naturally round up. Arrive at 7:07 AM? That becomes 7:00 AM on the timesheet. Leave at 4:53 PM? That's recorded as 5:00 PM. Stanford research shows this "rounding" costs employers 2.5% of total payroll.

For this company, that's $75,000 annually.

Dispute resolution. Every payroll dispute takes about 45 minutes to resolve. Check the timesheet. Talk to the employee. Talk to the supervisor. Make the adjustment. They average three disputes per week.

Annual cost: $4,680.

Compliance risk. WorkSafe New Zealand can fine businesses up to $10,000 for poor record-keeping. Their paper system wouldn't satisfy an audit. They're one inspection away from a massive penalty.

Total real cost: Over $97,000 per year.

The owner switched to digital timesheets the next week. His exact words: "I can't afford not to."

Neither can you.