Restaurant inventory: how to manage it without a spreadsheet

Managing inventory at a restaurant isn't just about knowing how many tomatoes or how many packaging units are left at the end of the day.

In practice, inventory is one of the factors that most affects profit, waste, stockouts, and operational predictability. The problem is that many people still try to handle it with manual notes, outdated spreadsheets, or the team's memory.

The result is almost always the same: too much of what moves slowly, not enough of what sells fast, and the problem is discovered too late.

What is COGS and why does it matter so much

COGS stands for Cost of Goods Sold.

Simply put, it's how much of your revenue goes toward producing what was sold.

If the restaurant is selling well but COGS is out of control, revenue goes up while margins disappear.

That's why inventory and COGS go hand in hand. When you don't track intake, output, portion sizes, and waste, COGS becomes a number that looks good on paper but has nothing to do with reality.

A practical way to look at this is:

| Indicator | What to watch | |----------|----------------| | Purchasing | are you buying more than what turns over? | | Consumption | is the kitchen following the correct standard? | | Loss | does food get left over, expire, or spoil regularly? | | Sales | is your top-selling item priced right? | | COGS | does the real margin keep up with sales volume? |

Without this visibility, the owner feels like the restaurant is selling, but can't understand why so little is left in the register.

The most common inventory mistakes in restaurants

Most of the losses don't come from sophisticated fraud. They come from repeated operational errors.

The most common ones are:

• buying impulsively or "just to have a buffer";
• not having a recipe card per product;
• letting each person plate the dish however they want;
• not properly marking an item as out of stock;
• only counting inventory after a problem has already occurred;
• mixing physical stock counts with mental estimates;
• not separating waste, internal consumption, and shrinkage.

When this happens, the restaurant starts operating in the dark.

Overstock, stockouts, and shrinkage: the three inventory villains

Overstock

Buying too much seems safer, but it usually turns into idle capital, expiration, and waste.

Stockout

When an item runs out sooner than expected, the problem isn't just operational. You lose a sale, delay an order, and frustrate the customer.

Shrinkage

Not all shrinkage is direct theft. Sometimes it comes from incorrectly sized portions, wrong entries, unregistered internal consumption, or untracked breakage.

Without a system, all of this gets mixed together.

Why spreadsheets stop working so quickly

Spreadsheets work up to a point. The problem starts when operations gain volume.

That's when situations like these start happening:

• an item was changed on the menu but not in the spreadsheet;
• someone made a purchase but didn't log it;
• the physical count was put off until later;
• the kitchen changed how an ingredient is used and nobody updated the records;
• an item ran out but kept showing as available for sale.

The cost of doing things manually doesn't show up in a single spreadsheet row. It shows up in accumulated errors.

Automated inventory: how it works when linked to the menu

Here's the most important shift.

When inventory talks to the menu, the system stops being just a place to log quantities and starts helping run the operation.

In practice, the ideal flow is:

1. the product is added to the menu;
2. the ingredients or availability limits are linked to it;
3. with each sale, the system reduces the projected balance;
4. when an item gets close to the limit, an alert is triggered;
5. if it runs out, the item can be paused on the menu automatically or with a single click.

In Quickap, you control item availability directly from the dashboard — if a product runs out, you pause it with one click and it disappears from the customer-facing menu immediately.

This greatly reduces that classic scenario of selling something that should no longer be available.

Stockout alerts before you run out

One of the biggest benefits of automated inventory isn't just tracking what's gone. It's warning you before it happens.

That alert matters because it gives you time to decide:

• purchase a restock;
• adjust the shift's production plan;
• temporarily pause an item;
• push another product with a better margin;
• notify the team before the customer complains.

Whoever only discovers a stockout after an order has already come in always pays a higher price.

How much is being spent vs. how much should be spent

There's no single ideal percentage for every restaurant, because COGS varies by segment, concept, average ticket, and operating model.

Even so, it's useful to work with an attention range by business type:

| Segment | COGS attention range | |---------|--------------------------| | Meal prep / lunch boxes | 30% to 38% | | Burger joint | 30% to 35% | | Pizzeria | 28% to 35% | | Açaí and desserts | 25% to 35% | | À la carte restaurant | 32% to 40% |

These ranges serve as an operational reference, not an absolute rule. The most important thing is to track the trend: if COGS rises without explanation, there's a process problem.

The menu needs to reflect inventory reality

This point is decisive.

There's no point having internal control if the customer can still see a sold-out item on the menu or an add-on that's no longer available.

When the menu and inventory are kept separate, the restaurant creates a chain of rework:

• an order comes in wrong;
• the team has to communicate the item's absence;
• the customer swaps or cancels;
• operations waste time;
• the experience gets worse.

When both work together, you sell with far greater confidence.

Well-managed inventory is protected profit

Many people think of inventory as an administrative task. In reality, it's a direct part of the margin.

Managing it well means:

• buying smarter;
• wasting less;
• avoiding stockouts;
• selling with more predictability;
• seeing the real COGS;
• making decisions before losses appear.

A spreadsheet can be the starting point. But after a certain volume, it holds you back more than it helps.

Anyone who wants to operate with greater clarity needs inventory connected to the menu, stockout alerts, and a centralized view of operations.

Organize your menu, availability, and operations in one place →