How a $34/hour spreadsheet costs you $50,000 a year

You don't know which one it is. That's the problem.

It might be the weekly report your operations manager spends every Friday afternoon compiling. Pulling numbers from three different systems, copying them into Excel, formatting it so it makes sense, emailing it to you at 4:47pm. Every week. Fifty weeks a year.

It might be the job sheet your admin team re-enters from handwritten notes because the field guys don't use the app. Or the quoting spreadsheet that takes forty-five minutes per quote because someone built it in 2019 and nobody's touched the formulas since.

It doesn't look expensive. It just looks like work.

The maths of "it only takes a few minutes"

Let's trace one process. The weekly operations report.

Your operations manager pulls data from your job management system. That takes twenty minutes because the reporting in the system is rubbish, so they export raw data and massage it. Then they pull financials from Xero. Ten minutes. Then they check the whiteboard or the shared calendar for what's happening next week. Another ten.

Now they compile. Copy, paste, format, cross-reference, fix the formula that broke again, add the notes from this week's dramas. That's an hour, easy. Probably more.

Then they proof it. Send it. Answer your three questions about it on Monday morning. Another twenty minutes.

Total time: two hours and twenty minutes. Every week.

Your ops manager is on $95,000 a year. Fully loaded with super, leave, and overheads, call it $120,000. That's roughly $62.50 an hour.

Two hours twenty minutes at $62.50 is $146 per week. Fifty weeks a year. That's $7,300.

For one report. That you glance at for four minutes on Monday.

Now multiply

That's one process. One person. One report.

How many of these exist in your business?

The admin person who spends ninety minutes a day chasing timesheets because the guys in the field fill them in wrong. Or don't fill them in at all. At $75,000 fully loaded, that's $36 an hour. Ninety minutes a day, five days, forty-eight weeks. $12,960 a year.

The accounts person who manually reconciles purchase orders against delivery dockets because the two systems don't talk to each other. An hour a day. $80,000 fully loaded. $19,200 a year.

The sales coordinator who re-types customer details from emails into the CRM because nobody set up the integration. Thirty minutes per enquiry, eight enquiries a day. Two people sharing the load. At $70,000 each fully loaded, that's $33.65 an hour, four hours a day total. $32,300 a year.

Add it up. The report: $7,300. The timesheets: $12,960. The reconciliation: $19,200. The data re-entry: $32,300.

That's $71,760 a year. In a business that probably turns over $3 to $5 million.

And these aren't dramatic problems. Nobody's complaining about them. They're just how things work around here.

The Wasted Effort Audit

Here's a template. You can do this with a pen, a piece of paper, and a cup of tea on Sunday night. It takes about fifteen minutes.

Step 1. List every recurring manual process.

Walk through your week mentally. Or better, ask your team: "What do you do every week that you also did last week, and the week before that?" You're looking for anything that involves copying, compiling, re-entering, reconciling, chasing, or formatting.

Common ones in regional businesses:

• Weekly/monthly report compilation
• Timesheet chasing and correction
• Manual data re-entry between systems
• Invoice matching and reconciliation
• Quote preparation from templates
• Roster or schedule building in spreadsheets
• Stock or inventory counts done by hand
• Customer information copied between email, CRM, and job systems

Step 2. Fill in the audit table.

For each process, estimate three things: how often it happens, how long it takes, and who does it.

#	Process	Who does it	Frequency	Time per occurrence	Fully loaded hourly rate	Weekly cost
1	Weekly ops report	Ops manager	1x/week	2.5 hrs	$62.50	$156.25
2	Timesheet chasing	Admin	Daily	1.5 hrs	$36.00	$270.00
3	_________	_________	_________	_________	_________	_________
4	_________	_________	_________	_________	_________	_________
5	_________	_________	_________	_________	_________	_________
6	_________	_________	_________	_________	_________	_________
7	_________	_________	_________	_________	_________	_________
8	_________	_________	_________	_________	_________	_________

Don't know the hourly rate? Use $34/hour as a baseline. That's roughly the Australian median for admin and operations roles, fully loaded. Adjust up for senior people, down for juniors. Or just use $34 for everything and you'll get a conservative number.

Step 3. Calculate the annual cost.

For each row: Weekly cost x 48 weeks = Annual cost.

(Use 48 weeks, not 52. Nobody's at full productivity during Christmas shutdown and public holidays.)

#	Process	Weekly cost	x 48	Annual cost
1	Weekly ops report	$156.25	x 48	$7,500
2	Timesheet chasing	$270.00	x 48	$12,960
3	_________	_________	x 48	_________
TOTAL				$_______

Step 4. Read your number.

• Under $20,000. You've got some waste, but it's manageable. Pick the biggest one and fix it when you get a chance.
• $20,000 to $50,000. That's a part-time salary hiding in your processes. Worth a serious look.
• $50,000 to $100,000. You're paying for a full-time employee who doesn't exist. That money is evaporating into manual work every pay cycle.
• Over $100,000. You've got a structural problem. Your business has outgrown its processes, and every person you add makes it worse.

Most businesses I've been inside land between $50,000 and $120,000. The number always surprises people.

The invisible tax

This is what Wasted Effort looks like. Not one catastrophic failure. A hundred small ones, happening every day, that nobody measures because they've been happening so long they feel normal.

It's a tax on your business. You pay it every week. It shows up nowhere in your P&L. There's no line item called "stuff we do manually because we never got around to fixing it." But it's there, built into your wages bill, hiding in plain sight.

Here's what makes it worse. These aren't your worst employees doing this work. They're often your best ones. The people who are diligent enough to actually compile the report every Friday. Thorough enough to chase every timesheet. Reliable enough to re-enter the data correctly every time.

You're burning your best people's time on work that a system could do in seconds.

What $50,000 actually buys

Here's the counterintuitive bit.

Most of these problems cost less to fix than they cost to keep. The weekly report? An afternoon setting up proper reporting in the system you're already paying for. Maybe $2,000 if you get someone in to configure it. Saves $7,300 a year. Pays for itself in fourteen weeks.

The timesheet drama? A decent field app and half a day of training. $3,000 to $5,000. Saves $12,960 a year. Pays for itself before Easter.

But you won't fix them. Not because you don't want to. Because you can't see them. They're buried in the rhythm of the week. They feel like work, not waste.

Finding your number

Do the audit. Fifteen minutes. A pen and paper. Add up the annual cost column and look at the total.

That number is what your business pays every year for processes that haven't been redesigned since you were half this size. It's not anyone's fault. It's just what happens when a business grows faster than its systems.

That's one dimension of friction. Wasted Effort. There are five others. And they compound.

Found something? Most owners do. The Wasted Effort Audit covers one dimension. The Clarity Conversation covers all six. Four hours, $2,000, and you walk away with a scored friction map, the cascade, and a clear picture of what to fix first.