Cena dla członków założycieli€499normalnie €799Zobacz, co w cenie
Dashboard

Restaurant operations dashboard: why spreadsheets are killing you

Everybody starts with a spreadsheet, and everybody should. Here is where they break, why it always happens in the weeks that matter most, and what has to be true for a dashboard to be worth the switch.

zespół master.restaurant6 min czytania

Everyone starts with a spreadsheet, and that is fine

There is nothing wrong with a spreadsheet. It is the correct first tool: free, immediate, and shaped exactly like the restaurant that made it. Most good operators we know built one, and the act of building it usually taught them more about their own numbers than any course would have.

The problem is not the file. It is that a spreadsheet is a personal instrument being asked to do an institutional job, and it fails in ways that are almost invisible until the moment you need it most.

How spreadsheets actually fail

They rarely fail loudly. Nobody gets an error message saying the food cost has been wrong since March.

They fail because someone dragged a cell and the formula now references the wrong row. Because there are four versions in an email thread and nobody is sure which is current. Because the whole thing lives on one laptop in the back office, which means your restaurant runs on one laptop in the back office. Because the person who built it understood the formulas, and they left in March, and now the file is a black box that everyone politely stops opening.

And most of all, they fail by being slightly too much work on the days you are slightly too busy.

  • One overwritten formula, and every number after it is quietly wrong
  • Version drift — four copies, no source of truth, nobody sure which is live
  • Single machine, single point of failure, no history when it dies
  • One author who understood it, and is no longer here
  • No trend without building the trend yourself, by hand, every time

The real cost is not the file. It is the weeks you skipped

Here is the part that actually costs money. A spreadsheet is a chore, and chores get skipped in busy weeks.

Busy weeks are exactly when costs run away. It is the week you were two people short, the week the walk-in was left open, the week you comped four tables and ordered heavy for a function. It is the week the number would have told you something. It is also, reliably, the week nobody opened the file.

So the tracking that exists is a record of your calm weeks. The expensive weeks are missing from your own data, which means the trend has a hole in it precisely where the trend was about to say something. This is not a discipline failure by the operator. It is a design failure by the tool.

The other half: nobody trusts a number they cannot check

There is a second, quieter cost. A number nobody trusts does not change any decisions, and after a certain number of unexplained results, people stop believing the file.

Once that happens the spreadsheet still gets updated — sometimes for years — but it has stopped being an instrument and become a ritual. Operators in this position often describe themselves as tracking their numbers. They are maintaining a document. The two are not the same activity, and only one of them affects a Tuesday.

What a dashboard has to do to be worth the switch

The alternative most independent operators are offered is enterprise restaurant software: priced for chains, configured over months, and packed with modules a single dining room will never open. Between a fragile spreadsheet and a system built for fifty locations, there has historically been very little for the restaurant with one room and an owner who also works the floor.

What that restaurant needs is smaller than most software wants to be. It has one job: show the truth about this week, fast enough that you can still change it.

  • Entry short enough to survive a busy week — minutes, not an hour
  • Food cost, payroll cost and break-even from the same set of inputs
  • Trend over time, without anyone having to build the trend
  • Reachable from anywhere, because your numbers should not live on one machine
  • Nothing to install, nothing to configure, nothing to break when a formula moves

Why we do not connect to your POS

This is the most common question we get, and the answer is deliberate: in master.restaurant, the data is entered manually.

Integrations sound like a feature and behave like a liability. They break on updates, they map categories in ways that quietly distort food cost, and every provider needs a different connector. But the real reason is different. Automation puts distance between an owner and their numbers, and that distance is where the drift lives.

Entering the week takes a few minutes, and it is the moment most operators actually notice that produce is up, or that Tuesday’s payroll does not match Tuesday’s covers. That noticing is the product. Nobody has ever noticed anything from a figure that appeared while they were asleep.

Five minutes a week, from anywhere

The entry is short on purpose: revenue, purchases, inventory, payroll — figures you already have, from invoices and rotas you are already handling. A few minutes on a fixed weekday, and the numbers come back without a formula for anyone to maintain.

Because it runs in the browser, that can happen anywhere: the office before service, the pass on a quiet Tuesday, or a phone in another country while somebody else runs the room. Nothing to sync, no file to lose, no version to argue about.

If you want to test that against your own restaurant rather than take our word for it, the three-day demo gives you full access without a card. Lifetime access is €499, paid once — no monthly fee for the dashboard, and no per-seat pricing, because a restaurant with one dining room should not be billed like a chain.

Keep the spreadsheet if it is working

We are not going to tell you a spreadsheet cannot work. If yours survives your busy weeks, if two people can read it, and if you could say from memory what last week’s food cost was, then it is doing its job and you should keep it.

The test is not sophistication. It is whether the number was there in the week you needed it, and whether you believed it. If the honest answer is no — and for most operators, on most busy months, it is — then the file is not tracking your restaurant. It is describing the calm parts of it.

Sprawdź to na własnych liczbach

Trzy dni pełnego dostępu, bez karty. Albo dożywotni dostęp do dashboardu i kursu za €499, jednorazowo.

Więcej z bloga