Every interior designer has built the spreadsheet. Columns for room, item, supplier, price, status. Colour-coding you invented at midnight. It worked beautifully — for a while. Then the projects multiplied, a client changed the sofa twice, and now there are three versions of the file and none of them agree.
The spreadsheet isn't breaking because you're careless. It's breaking because FF&E data changes faster than any one person can retype it. Here are the specific failure modes — you'll recognise most of them — and what the alternative actually looks like.
Failure one: version chaos
The file starts as Henderson_FFE.xlsx. Within a month there's Henderson_FFE_v2, Henderson_FFE_FINAL, and Henderson_FFE_FINAL_client copy. Your assistant updates one while you present another. The client approves a version that no longer exists.
Spreadsheets fork because sharing them means copying them. Every copy is a fresh chance for two sources of truth to disagree — and reconciling them is an evening you'll never bill.
Failure two: the prices go stale the day you paste them
An FF&E schedule is a list of claims about the outside world: this chair costs this much, ships in this many weeks. Those facts change without telling your spreadsheet. The price you pasted in March is a small landmine in your June budget meeting — the total at the bottom of the sheet is only ever as current as the last time somebody checked every row by hand.
Failure three: "where's my dining table?"
The client question that exposes the whole system. The honest answer lives across a supplier email thread, a PO in your downloads folder, and a tracking number in someone else's inbox. The spreadsheet says "ordered" — a word you typed five weeks ago that has meant nothing since.
Order status is exactly the kind of data a static grid can't hold: it changes constantly, it matters to three different people, and being wrong about it costs real money in missed lead times and double-orders.
Failure four: the sheet can't talk to the client
Even a perfect spreadsheet is unpresentable. Nobody shares raw Excel with a client paying for a considered aesthetic — so you rebuild the same information as a PDF or deck, and now there are two more artefacts to keep in sync. The approval that comes back ("love it, but in the green") lands in an email, detached from the row it refers to.
What the connected version looks like
None of these are spreadsheet-skill problems, so the fix isn't a better template — it's connecting the data so each fact lives once:
- One live schedule, not copies. Items belong to the project; everyone — including the client, through a branded portal — looks at the same current version.
- Product data captured, not retyped. Paste a product URL and the details fill in; import an existing sheet from CSV or Excel to start. (How Mortar handles sourcing.)
- Status that means something. Each item carries its procurement state — quoted, ordered, lead time, expected delivery, received — updated where the work happens.
- Approvals attached to the item. A yes lands with a date against the actual product, not loose in an inbox.
- A budget that adds itself up. Totals recompute as selections change, with colour-coded warnings before a room goes over — not after.
For the full picture of a procurement workflow that doesn't run on retyping, see our complete guide to interior design procurement.
Keep the spreadsheet for what spreadsheets are good at
This isn't spreadsheet hatred. Excel is superb at one-off analysis — margin experiments, a quick fee calculation. What it can't be is a multiplayer, always-current system of record for physical goods moving through the world. That was never a formula problem. If your FF&E sheet keeps breaking, it isn't asking for better formulas — it's asking to be retired from a job it was never built for.
(And if you're staying on spreadsheets a while longer, do it with the best version: our free budget template has the room rollups, status dropdowns, and over-budget warnings already built.)
Start a Mortar trial — import your current spreadsheet and see the difference by this afternoon.
