How to Track Workshop Costs Without Drowning in Admin

Most joinery workshop owners know their costs are higher than they'd like. Fewer know exactly where the money goes. Timber prices are visible — you see the invoice from the merchant. But the invisible costs are the ones that quietly eat your margin: the hour spent remaking a component because the spec wasn't clear, the half-sheet of MDF that went in the skip because nobody tracked the offcut, the two afternoons your best joiner spent fixing someone else's mistake on site.

The problem isn't that workshop owners don't care about costs. It's that tracking costs has traditionally meant paperwork, and paperwork is the last thing anyone wants to do at the end of a twelve-hour day in the shop.

The three cost layers every workshop has

Workshop costs fall into three layers, and most people only track the first one properly.

If you only track Layer 1, you're seeing roughly 40-50% of your actual project cost. The rest is invisible. You might look at a completed kitchen project and think "materials cost £6,000, we charged £18,000, good margin." But when you account for the 280 hours of labour across production, spraying, and installation, plus the overhead those hours consumed, the real cost might be £14,500. Your margin isn't 67% — it's 19%.

That gap between perceived margin and actual margin is where workshops get into trouble. They take on work thinking it's profitable, underquote the next similar job based on the same false assumption, and wonder why the bank balance doesn't match the order book.

Why spreadsheets break under pressure

The obvious solution is a spreadsheet. Create a sheet per project, log materials and hours, calculate the totals. It works in theory. In practice, it breaks within two weeks.

The spreadsheet lives on the office computer. Your joiners are in the workshop. Nobody walks to the office to log that they spent 45 minutes on a door frame. Nobody updates the material column when they pull three boards from the rack. The spreadsheet stays accurate for the first project while you're motivated, then falls behind on the second, and by the fourth project it's three weeks out of date and useless.

Even if someone does maintain it, a spreadsheet can't connect the dots. It doesn't know that the 18mm oak you allocated to Project A is the same stock that's running low in your timber store. It doesn't know that the hours your sprayer logged last Tuesday were split across two projects. It stores numbers, but it doesn't understand your workshop.

The minimum viable tracking system

You don't need to track everything to see a massive improvement. You need to track the right things consistently. Here's the minimum that gives you real visibility:

First, materials per project. Every time timber, sheet material, hardware, or finishing products are used on a job, record it against that project. Not at the end of the week from memory — at the point of use. This doesn't have to be precise to the gram. "4 boards of 25mm American white oak" is sufficient. The cost comes from your purchase records.

Second, hours per project per phase. Your joiners should log their time daily, split by which project and which phase they worked on. Cutting, machining, assembly, finishing, installation — whatever phases your workshop uses. This takes two minutes at the end of each day. The value it creates is enormous: you discover which phases are eating more time than you estimated and which projects are silently running over budget.

Third, a monthly overhead number. Add up your fixed costs — rent, rates, insurance, machinery finance, utilities, vehicles — and divide by the number of productive hours your workshop delivered that month. That gives you a cost-per-hour that you can apply to each project's labour hours. Now every project carries its fair share of overhead, and your profitability picture is real.

What changes when you can see the numbers

The first thing that happens when you start tracking costs properly is unpleasant: you discover that some of your favourite jobs weren't as profitable as you thought. That beautifully detailed oak staircase that the client loved and you were proud of? It actually lost money because the installation took three days longer than planned and you ate the cost to maintain the relationship.

The second thing that happens is useful: you start spotting patterns. Maybe your installation phase consistently runs over. That's not bad luck — it's a systemic problem. Maybe site measurements are regularly wrong, or your production tolerances don't account for site conditions. Fix the pattern and you fix the overrun on every future project.

The third thing that happens is profitable: your quoting improves. Instead of guessing what a project will cost, you quote based on what similar projects actually cost. Your estimates become more accurate, your margins stabilise, and you stop accidentally taking on work at a loss.

Tracking costs as part of the workflow, not on top of it

The reason most tracking systems fail is that they're bolted onto the workflow as extra work. "After you finish cutting, update the spreadsheet. After you finish installation, fill in the timesheet. At the end of the month, reconcile everything."

The systems that actually work are the ones that capture data as a byproduct of managing the work. When you move a project to the next phase in your production system, the hours get logged. When you allocate stock to a project, the material cost records automatically. When a team member clocks their day, their hours split across the projects they touched.

Joinery Core was built with this principle. Material allocation, time tracking, and project finances aren't separate modules — they're connected to the same production workflow your team uses every day. You don't track costs because you're disciplined. You track costs because the system you already use to manage production captures them automatically.