Spreadsheet vs inventory software: when to move

Spreadsheet vs inventory software is a decision many kitchens put off for years, and often for good reason. A well-built inventory spreadsheet costs nothing, can be shaped to the kitchen exactly, and does the job for a small menu and a careful chef. Inventory software costs a monthly fee, takes time to set up, and asks the team to change how they count. For many venues, the spreadsheet is simply the better tool.

But there comes a point where the sheet costs more than it saves. The count takes longer every week. Prices go out of date. Two people keep two versions. The food cost figure arrives late and cannot be explained. None of these appears on an invoice, so the cost of the spreadsheet stays hidden while the subscription for software is very visible. That is why venues often move too late.

This guide sets out four thresholds at which a stock sheet starts to cost more than a subscription, with the hours behind each one. It covers what a spreadsheet does well, what inventory software adds, how to work out the software ROI for your kitchen, and how to make the move from spreadsheets to software without losing the history in the sheet.

A typical inventory spreadsheet lists every stock item with its unit, its price and the quantity counted at each stock take. Multiplying quantity by price gives the value of stock on hand. Comparing the value at the start and end of a period, with purchases in between, gives the cost of what was used. Divided by sales, that is the food or drink cost percentage.

Many sheets also hold par levels, supplier details and a simple order list. Some link to recipe costing sheets, so that dish costs update when ingredient prices change.

A spreadsheet is flexible: it can be laid out in the order of the store room, use the units the kitchen actually counts, and change whenever the menu does. It costs nothing beyond software most businesses already have. It needs no training for anyone who has used one before. And it is fast for a small number of items counted by one person.

For a small kitchen with a stable menu, a weekly count of the most valuable items and a monthly full count in a spreadsheet can be entirely adequate.

Inventory software adds things a spreadsheet struggles to do. It can be used by several people at once on phones or tablets, so counting is quicker. It can keep prices current from supplier invoices. It can link stock to recipes and to sales from the till, so the system knows what should have been used and can compare it with what was counted. It can suggest orders from par levels and record waste and transfers.

The most valuable of these is the link to sales and recipes, because it shows the gap between what should have been used and what actually was. That is the heart of inventory control: knowing what you hold, what you used and where the difference went.

A spreadsheet tends to cost more than a subscription when the kitchen crosses one or more of four thresholds:

The sections that follow describe each threshold and the hours behind it.

The first threshold is the number of items. A kitchen with a hundred stock lines can count them in an hour and keep their prices current without much trouble. A kitchen with three hundred, across food, drink, packaging and cleaning, finds that the count takes most of a morning and that prices drift out of date because nobody has time to update them.

As a rough guide, once a venue has more than about two hundred lines that it counts regularly, the time spent on the sheet starts to rise quickly. The exact number depends on the kitchen; the trend is what matters.

Here is an illustrative calculation. The figures are examples. Counting takes about fifteen seconds a line on a well-organised sheet, plus time for moving between areas. Three hundred lines take about ninety minutes to count. Updating prices from invoices takes another hour a week. Entering the count into the sheet and checking the totals takes thirty minutes.

That is about three hours a week, or around 150 hours a year, before any analysis. At a chef's or manager's cost, it is a significant sum.

The second threshold is total hours. Add up everything the spreadsheet takes each week: counting, entering counts, updating prices, working out the food cost, building the order list, fixing errors. When the total passes about three or four hours a week, the cost of the sheet is often higher than the cost of a subscription, once those hours are valued.

Count honestly. The hours are usually spread across several people and several days, so nobody sees the total.

An illustrative week for a busy kitchen: a Sunday count of key items, ninety minutes; entering it, thirty minutes; updating prices from the week's invoices, an hour; working out the weekly food cost estimate, forty-five minutes; building orders from the sheet, an hour across the week; finding and fixing a formula error, thirty minutes.

That is about five hours a week. At 25 an hour, it is 125 a week, or about 6,500 a year.

The third threshold is the number of people and places involved. A spreadsheet is built for one person at a time. When the head chef counts the kitchen, the bar manager counts the bar and a supervisor counts the dry store, there are soon three versions, or one shared sheet that people overwrite. When stock moves between a kitchen and a bar, or between two venues, the transfers are easy to forget.

Once a venue has several storage areas counted by different people, or a second site, the sheet starts to lose accuracy as well as time.

The hours here come from reconciling. Someone has to combine the counts, find out why two versions disagree, chase transfers that were not recorded, and correct the totals. In a venue with three counters and two sites, that can easily add two or three hours a week, and mistakes slip through regardless.

The cost is not only the hours. A food cost figure built on inconsistent counts can lead to wrong decisions about menus and prices.

The fourth threshold is the gap between expected and actual food cost. Expected, or theoretical, food cost is what the food should have cost given what was sold and the recipes. Actual food cost is what the stock count and purchases say it cost. The difference is waste, over-portioning, theft, recording errors or price changes.

A spreadsheet can show the actual figure. Working out the theoretical figure needs every dish sold multiplied by its recipe, which is hard to keep current in a sheet. When the gap is large and nobody can say where it comes from, the spreadsheet has reached its limit.

Working out theoretical usage by hand means exporting sales by dish from the till, multiplying each by its recipe quantities, and comparing the result with the count. For a menu of forty dishes, that can take two or three hours each time, and it is often skipped. Without it, the gap stays unexplained.

Our guide to actual vs theoretical food cost explains what the gap usually contains and how to find it.

Add up the hours from the thresholds that apply to your kitchen, value them at the cost of the people who spend them, and add an allowance for mistakes: orders that were too large, stock that was wasted, prices that were wrong. That is the real cost of the spreadsheet.

Compare it with the full cost of inventory software: the subscription, any hardware such as tablets, set-up, training and the time spent using it. If the sheet costs more, it is time to move.

The software ROI for inventory comes from hours saved, waste avoided and better decisions. Hours saved are the easiest to estimate: count the hours the sheet takes now and estimate the hours the software would take. Waste avoided is harder: it comes from better ordering, earlier warnings and a clearer view of the gap.

Be cautious. Inventory software does not reduce waste on its own; it shows where waste is, and the kitchen has to act. Our guide to software ROI shows how to do the sum conservatively.

Whatever tool is used, the restaurant stock count itself needs to be done properly: at the same time and in the same order each time, by trained people, with units that match how items are bought and used. Software makes counting faster and arithmetic reliable; it does not make a careless count accurate.

Our guide to running a restaurant stock count properly covers the method. Improve the count before changing the tool, and both will work better.

Before moving to software, consider counting differently. Many kitchens count everything once a month and nothing in between. Counting the twenty or thirty most valuable items every week, and everything once a month, gives an early warning without the burden of a full weekly count.

This often extends the life of a spreadsheet by a year or more, because the weekly work is small and the monthly count is still manageable.

Par levels, the amount of each item to hold, turn a stock count into an order: count what is there, subtract it from the par level, and order the difference. A spreadsheet can do this for a small number of items. For hundreds of items with several suppliers and delivery days, software that builds the orders automatically saves time and reduces over-ordering.

Our guide to par levels covers how to set them.

Recording waste is one of the most useful habits in a kitchen: what was thrown away, how much and why. A simple waste sheet by the bin works well in any kitchen. Software can make it quicker and link it to the stock count, so waste shows up in the food cost directly.

Transfers between the kitchen and the bar, or between venues, also need recording. A spreadsheet can track them if everyone remembers; software makes them part of the count.

In many venues, the bar crosses the thresholds before the kitchen. A bar holds many bottles of high value, counted in fractions, with frequent price changes, and losses are hard to see without careful counting. Some venues move the bar to inventory software first and keep the kitchen on a spreadsheet.

Our guide to bar inventory management covers counting a bar without closing it.

When the move is made, keep the history. Archive the old spreadsheets, read-only, so past counts and food cost figures can be compared. Move only what the new system needs: current items, units, prices, suppliers and par levels. Clean them first: remove duplicates, items no longer used and units that do not match.

Our guide to from spreadsheets to software at the right moment covers the move in detail.

Run the spreadsheet and the software side by side for one or two counts. Compare the totals and the food cost figures. Where they differ, find out why: the software may be set up differently, or the spreadsheet may have had an error. Once they agree, stop updating the sheet.

Choose a quiet month for the first counts in the new system, so the team has time to learn it.

Set-up takes time: entering items with their units and prices, linking them to suppliers, setting par levels, and, for the full benefit, linking recipes to dishes on the till. Plan it as a small project with an owner and a deadline. The recipe links take the longest and are worth doing carefully, because they make the theoretical food cost possible.

Start with the most valuable items and the most popular dishes, and add the rest over a few weeks.

Train everyone who counts, receives deliveries or records waste. Show them how to count on a phone or tablet, how to find items quickly, and what to do when an item is missing from the list. Keep the counting order the same as the store room, so the habit carries over from the spreadsheet.

Expect the first count to take longer than the old one. By the third, it should be quicker.

Stay with the spreadsheet if none of the four thresholds apply: a small number of items, a few hours a week at most, one person counting in one place, and a food cost gap that is small and explained. For many small venues, that describes the kitchen exactly, and a subscription would cost more than it saves.

Revisit the decision once a year, or when the menu, the team or the number of venues changes.

In a group, the thresholds are often crossed quickly. Several venues with several counters each, stock moving between sites, and an owner who wants comparable food cost figures across all of them: these are exactly the conditions where spreadsheets struggle.

A group that standardises on one inventory system gains comparable figures across venues, as well as the time saved in each. Our guide to multi-venue operations covers what a group should share.

Here is an illustrative venue weighing the move. The figures are examples.

Three of the four thresholds applied. The venue moved the bar first, then the kitchen, and kept the old sheets archived for comparison.

servearound does not handle stock, so it does not replace an inventory spreadsheet or inventory software. It does hold two things a stock sheet needs. The menu report shows every dish that sold, with units, checks and revenue, which is the sales side of a theoretical usage sum. Each dish can carry its cost, so the report shows gross margin and how much of the revenue has a cost behind it, and an 86 takes a dish off everywhere when it runs out.

If you are weighing subscriptions for the parts of the venue servearound does cover, such as bookings, orders, the kitchen and guests, see pricing and Analytics.

When the kitchen crosses one or more of four thresholds: too many items, too many hours, several people or places, or a food cost gap nobody can explain.

As a rough guide, more than about two hundred lines counted regularly, though it depends on the kitchen.

When the sheet takes more than three or four hours a week in total, its cost often exceeds a subscription.

It shows where waste happens and makes ordering easier. The kitchen still has to act on what it shows.

What the food should have cost given what was sold and the recipes. The gap with actual food cost is waste, portioning and errors.

Often, yes. Bars hold valuable stock counted in fractions, and losses are hard to see without careful counting.

Archive the old spreadsheets read-only, and move only current items, prices, suppliers and par levels.

Yes, if none of the thresholds apply. Many small kitchens run well on a weekly count of key items and a monthly full count.

Spreadsheet vs inventory software is decided by four thresholds: the number of stock items, the hours the sheet takes each week, the number of people and places involved, and an unexplained gap between expected and actual food cost. Below them, a well-built inventory spreadsheet is often the better tool; above them, the hidden hours usually cost more than a subscription.

Count the hours honestly, value them, and do the software ROI sum conservatively. Improve the restaurant stock count first, consider counting key items weekly, move the bar first if it is the bigger problem, and make the move from spreadsheets to software with the old sheets archived and both systems run side by side until they agree.