Why Excel Fails for Joinery — 5 Problems Spreadsheets Can't Solve
Excel is the default tool for every small business. Quotes, stock lists, schedules, wage calculations — it all starts in a spreadsheet. For a solo joiner doing three jobs at a time, it works well enough. But the moment your workshop grows beyond one person and a handful of projects, Excel starts breaking in ways that cost you real money.
This isn't a theoretical argument. These are problems I dealt with in my own joinery workshop before building something better.
1. You can't schedule production visually
A joinery workshop runs on phases. Timber cutting, assembly, spraying, glazing, quality check, dispatch. Each phase has a different duration, uses different people, and depends on the one before it. You need to see all of this across ten or fifteen projects at once.
Excel can't do this. You can build a crude Gantt chart with conditional formatting, but you can't drag a phase to next week when the spray booth is occupied. You can't see at a glance that your joiner is double-booked on Thursday. Every change means editing dozens of cells by hand — and hoping you don't break a formula.
2. Stock data is always stale
In Excel, stock levels are only accurate at the moment someone updates the sheet. Your sprayer uses ten litres of lacquer on Monday. Does the spreadsheet know? Only if someone types it in. Meanwhile, the office quotes a new job assuming stock is available.
This creates two expensive problems: you over-order materials you already have, and you run out of materials mid-project and pay rush delivery fees. Both happen because the spreadsheet is a snapshot, not a live system.
3. There's no connection between data
In a real workshop, everything is connected. A project has a client, a set of materials, a production schedule, a team of workers, financial records, and files. In Excel, each of these lives in a separate sheet or a separate file. Nothing links them.
When a client calls about their kitchen project, you open one spreadsheet for the quote, another for the schedule, a third for stock, and hope the project number matches across all of them. One typo, one wrong tab, one forgotten update — and the data is wrong.
A typical Excel setup for a joinery workshop
- Project list — one spreadsheet
- Stock levels — another spreadsheet
- Team schedule — a third spreadsheet (or a whiteboard)
- Wage calculations — yet another file
- Client contacts — somewhere in email
- Project files and drawings — in a folder on someone's desktop
Six places for information about the same job. That's where money gets lost.
4. Version control doesn't exist
Someone emails the master spreadsheet to the workshop. The workshop manager adds three rows. Meanwhile, the office updates the original. Now there are two versions with different data. Which one is correct? Nobody knows until something goes wrong.
Cloud-based spreadsheets (Google Sheets, SharePoint) help with this, but they introduce their own problems — slow performance with large files, accidental edits, and the fact that a spreadsheet with 40 tabs and 2,000 rows becomes unusable on a phone.
5. It doesn't scale with your team
A spreadsheet has no concept of permissions. Your apprentice can see the same financial data as your accountant. There's no role-based access — everyone sees everything, or you create separate files and lose the connections between them.
When your workshop grows from three people to eight, the spreadsheet becomes a bottleneck. Too many people editing, too many versions, too many manual processes that should be automatic.
What actually works for joinery
A joinery workshop needs a system where the project, the schedule, the stock, the team, and the money all live in one place. Where changing a delivery date automatically shifts the production phases. Where using materials updates stock levels in real time. Where the office and the workshop see the same information.
That's what Joinery Core does. It replaced Excel in our own workshop, and everything that used to take hours of spreadsheet maintenance now happens automatically.
Replace your spreadsheets in an hour
Import your projects, add your team, set up your stock. Everything connected, nothing lost. 14-day free trial.