Restaurant Inventory: Spreadsheet or Software?

By Rob Bruni, founder of OpsEdge Hospitality, twenty years running restaurants, bars, clubs and resorts. Prices checked on vendor websites November 10, 2026. Part of our spreadsheet or software series.

Inventory is the job where the spreadsheet or software question matters most, because it is the one with the most typing. The count takes the same time either way. What changes is everything around it: keeping prices current, extending the count, and finding out which items are walking out the door. This page shows how to do it properly in a spreadsheet, what the software adds and costs, and how to tell which one you need.

The short answer

A spreadsheet handles inventory well for one or two locations taking fewer than about 150 invoices a month, as long as one person owns the file and counts on the same day every week. You will get an accurate cost of goods sold and food cost percentage, which is what most operators need.

Software is worth paying for when invoice entry is eating more than a couple of hours a week, when you need variance by item instead of one food cost number, or when you count at three or more locations.

We sell spreadsheet templates, so weigh our view with that in mind. The main comparison covers the full cost math and a five question test.

What the job takes

Whichever tool you use, inventory is the same six steps. If a step is being skipped today, software will not add it back by itself.

1. Build the item list in shelf order. Walk in, dry storage, freezer, line. The sheet should follow the room so the count goes shelf to shelf.
2. Set one count unit per item. Case, each, pound. Mixed units are the most common source of bad numbers.
3. Count on a fixed day and time. Same day, before deliveries, after close or before open.
4. Update prices from invoices. Use the last price paid for every item that changed.
5. Extend and total. Quantity times price for every item, totaled by category.
6. Calculate usage and act on it. Cost of goods sold, food cost percentage, and a look at the items that moved the most.

How to run it in a spreadsheet

A good inventory spreadsheet has three tabs: the item list with units and current prices, the count sheet in shelf order, and a summary that calculates cost of goods sold and food cost for the period. Here is the weekly rhythm.

1. Print the count sheet, or open it on a tablet, and count shelf to shelf with two people where you can: one counts, one writes.
2. Enter the counts. On a tablet this step disappears.
3. Go through the week's invoices and update any price that changed. This is the slow part, about one to two hours a week at a single location by our estimate.
4. Enter total purchases for the period by category.
5. Read the summary: cost of goods sold, food cost percentage, and days on hand. Compare with last week and with your target.

The restaurant inventory guide walks through the full method, and the par level calculator sets order quantities. If you would like a file that is already built, our Restaurant Inventory and Ordering Guide has the count sheets, pars and order guide in one workbook, and the Invoice and Vendor Credit Tracker keeps purchases and credits in one place.

What software adds, and what it costs

Inventory software does four things a spreadsheet cannot do without a lot of manual work.

• Reads invoices for you. You photograph or forward the invoice and every item price updates. It also flags price increases line by line.
• Counts on a phone. The count goes straight into the system, with no second step.
• Calculates theoretical usage. With recipes and POS sales connected, it shows what you should have used, item by item, next to what you did use.
• Suggests orders. Pars and usage produce an order you can send to the vendor from the app.

Prices are from each vendor's website on November 10, 2026. Ask for a written quote that includes setup, and check the invoice limit on the plan you are quoted.

Side by side

Stay or switch

Mistakes either way

Most inventory problems have nothing to do with the tool.

• Counting monthly. A month is too long to find a problem. Count the full inventory weekly, or count your top twenty items by cost weekly and everything monthly.
• Using old prices. A count extended at last quarter's prices understates what is on the shelf and distorts food cost.
• Buying software to fix a counting habit. If nobody counts on a fixed day now, nobody will count in an app either.
• Skipping the setup. Software variance reports are only as good as the recipes behind them. Unfinished recipe mapping is the main reason groups stop trusting the system. See actual versus theoretical food cost for what the report should show.

Questions

Keep reading