Spreadsheets are a brilliant first system. They are cheap, fast, and forgiving — until they are not. For a made-to-order brand, the breaking point usually arrives quietly: not one big crash, but a series of small moments where the cells no longer match what is actually happening. This is a field guide to those moments, so you can recognize yourself before the wrong client gets the wrong date.
The short version
Five symptoms show up in roughly this order: double-booked production slots, margin you can only calculate after the month closes, a status question that takes three places to answer, a deposits tab that disagrees with a balances tab, and a running total of who owes what that lives in your head. None of them means the spreadsheet is wrong. They mean the order has outgrown the place it is stored. Most makers hit this between ten and twenty concurrent orders.
The problem is rarely that the spreadsheet is wrong. The problem is that it is no longer where the work actually lives.
What a spreadsheet is genuinely good at
It is worth being fair to the tool before listing its failures, because the honest reason most made-to-order businesses run on spreadsheets is that spreadsheets are very good. They cost nothing. They take any shape you need on the day you need it. They never force your workflow through someone else's idea of how an order should behave, which is exactly the complaint most makers have about the software they tried before going back to a sheet.
At three or four open orders, a spreadsheet beats almost anything you could buy. The failure modes below only appear once the number of things you are holding in your head passes what a human can comfortably hold — which means every sign on this list is a symptom of growth, not of carelessness.
1. You double-booked the same production slot for two different orders
It happened because the workshop calendar lives in one tab, the order list in another, and neither talks to the other. You only notice when both clients ask for an update on the same Tuesday. At that point you are not running a schedule — you are negotiating a schedule with reality.
The cost is never the slot itself. It is the conversation where you tell someone their piece is three weeks later than promised, for a reason that has nothing to do with them. One of those a quarter is survivable. One a month starts shaping how you sound to your own customers.
The tell: you have started checking the calendar twice before confirming anything, because you no longer trust it on the first look.
2. You do not know the real margin until the month is closed and reconciled by hand
Revenue is in the income tab. Materials are in the batch tab. Shipping was filed under 'misc' because you were in a hurry. By the time you add it all up, the piece has already shipped and the lesson is too late to use. You are profitable in theory until the spreadsheet proves otherwise.
A quote is a forecast written before production; the cost is the truth that arrives after it. If the two only meet at month end, every order you price in between is priced from a guess. That is how a studio can run a busy quarter and finish it with less money than it started.
The tell: you can name your revenue for last month instantly, and you have to open something to name your margin.
3. A client asked for a status and you opened three places to find out
Email for the last message, spreadsheet for the payment, notes app for the production note, and your own memory for the rest. The answer you give is 80% accurate and 20% hopeful, and you spend the next ten minutes hoping you did not promise the wrong ready-by date.
Ten open orders, each customer checking in two or three times before delivery, is a normal month — and each of those messages is a small research task before it is a reply. The reply takes a minute. Reconstructing the truth behind it takes considerably longer.
The tell: you delay answering simple questions, not because you are busy, but because answering properly means an investigation.
4. You have a Deposits tab and a Balances tab and they keep disagreeing
A payment arrives, you update one sheet, you mean to update the other, you get a message mid-edit, and now the same customer is fully paid in one place and owes $800 in another. You are not even sure which one is wrong until someone asks for a refund.
Two records of the same fact will always drift, because keeping them in step depends on discipline at exactly the moments you have least of it — mid-conversation, mid-delivery, mid-week. The spreadsheet is not failing. It is doing precisely what two disconnected tables do.
The tell: you have a habit of checking both tabs against the bank before you invoice anyone, and you consider that normal.
5. You keep the running total of who owes what in your head
This is the moment the spreadsheet stops being a tool and starts being a second job. You are not a maker anymore; you are a human reconciliation engine with a dusty workshop. The scary part is how proud you are of remembering it all — because it means you have normalized the chaos.
Memory is a genuinely good system at three open orders and a genuinely bad one at fifteen. The failure is not dramatic: nothing crashes, no alarm goes off. A balance simply goes uncollected for two months because nobody, including you, was holding that thread.
The tell: someone asks what you are owed in total, and your honest answer starts with roughly.
The five signs, and what each one actually costs
They do not carry equal weight. Two of them cost you a customer's trust; two cost you money directly; one costs you the ability to plan at all.
| Sign | What it costs you | How long it stays cheap |
|---|---|---|
| Double-booked slots | A delivery date you have to walk back | Until two orders overlap in one week |
| Margin known late | Every quote in between is priced from a guess | Until material prices move |
| Status takes three places | Minutes per message, and a wrong promise now and then | Until about ten open orders |
| Deposits vs balances drift | Invoicing the wrong amount to a real customer | Until a payment lands mid-conversation |
| Totals live in your head | A balance nobody collects | Until you take a week off |
The common pattern underneath all five
Every one of these symptoms has the same root cause: the order, the schedule, the money, and the client communication are stored in separate places that only you know how to connect. While you are the connection, the business cannot scale past your memory. And your memory is too valuable to spend on whether the deposit tab matches the balance tab.
What to do this week, before you buy anything
You do not need new software to remove the worst of this, and trying the cheap fix first tells you whether the problem is really the tool.
- Collapse to one row per order. Deposit, balance, batch cost, status and ready-by date as columns on a single sheet. Most tab-versus-tab disagreements disappear the moment the same fact stops being stored twice.
- Record the cost when it is known, not when it is convenient. The supplier invoice arrives on a Tuesday; that is the day it belongs in the row, not the day you reconcile.
- Write the outstanding total somewhere visible. One cell, summed from the rows. If it is only in your head, it is not a number — it is a feeling.
- Give a range, not a date. Until the schedule is trustworthy, promise a window. It costs nothing and removes most of the damage from sign one.
If those four changes hold for a month, your spreadsheet had room left in it. If they quietly stop being maintained by week three, that is the real answer — the discipline required is the cost, and it is being paid out of the same attention that runs the workshop.
If any of these sound familiar, here is what we built to fix it.
See how it worksWhen is it actually time to move?
Not at the first sign. A messy spreadsheet is still a working system. The time to move is when you realize the spreadsheet is costing you more in avoidable mistakes and mental load than a proper tool would cost you in setup. For most makers, that is somewhere between ten and twenty open orders — or the first time a double booking costs you a client you wanted to keep.
The comparison worth making is not spreadsheet against software in the abstract, but against the specific alternatives that exist for deposit-based work — including accounting tools you may already pay for. That is laid out in how to track deposits on custom orders.
Until then, keep the spreadsheet. Just stop pretending it is going to grow up and become software on its own.
The bottom line
None of these five signs means you did something wrong. They are what happens when the volume of work outgrows the place the work is recorded, and they arrive in the same order for almost everyone: first the schedule slips, then the margin goes dark, then the money starts living in your head. Recognizing which one you are on is more useful than any argument about tools — it tells you whether you have a year of runway left in the sheet, or a month.
Frequently asked questions
Is a spreadsheet actually bad for a made-to-order business?
No — it is usually the correct first system. It costs nothing, it bends to any workflow, and at a handful of open orders it genuinely outperforms software you have to learn. The question is not whether it is bad, but whether the order volume has passed the point where its weaknesses start costing more than its flexibility saves.
How many open orders can a spreadsheet realistically handle?
Most makers describe the strain starting somewhere between ten and twenty concurrent orders, though the trigger is usually complexity rather than count: variable deposit percentages, batches shared across several orders, and long lead times all bring the breaking point forward.
Can I fix this by building a better spreadsheet?
Partly, and it is worth trying before you buy anything. A single sheet where one row is one order — with deposit, balance, batch cost and status as columns — removes most of the disagreement between tabs. What it cannot do is update itself, show a customer their own status, or stop two people editing the same cell.
What breaks first when a made-to-order business outgrows its spreadsheet?
Almost always the money view rather than the schedule: what has been collected, what is still owed across every open order, and what each one actually cost. Production dates tend to survive longer because they are visible and someone chases them; an uncollected balance is silent.
Is it worth moving mid-year, or should I wait until things are quiet?
Quiet periods are easier, but they rarely arrive on schedule, and the cost of waiting compounds while you wait. A practical middle path is to start new orders in the new system and let the existing ones finish where they are, rather than migrating history you will never look at again.
How much of my old spreadsheet data do I actually need to bring over?
Far less than instinct suggests. Open orders with their deposits, balances and dates are worth moving. Completed orders are usually only worth keeping as a file for your accountant — you are unlikely to query them again, and migrating them is the step where most attempts stall.
What should I check before choosing a replacement?
Whether it understands a deposit and a balance on the same order, whether it can attach a production cost that is not an average, and whether your customer can see their own status without you sending anything. Plenty of tools do inventory or invoicing well and none of those three.