Inventory
Food cost

How to Set a Restaurant Opening Stock Balance for Accurate COGS

Why your cost of goods sold report stays empty until you set an opening balance

An opening stock balance is the value of everything you hold at the moment you start tracking. Actual cost of goods sold (COGS) is calculated as opening stock plus purchases minus closing stock. Without a submitted opening count, that opening value is zero. The report has nothing to work from, so it shows only your purchases, or nothing at all.

Say a group opens a period with $42,800 of stock, buys $128,500 during the month and counts $39,600 on hand at the end. Remove the opening count and the sum has no starting value, so it cannot run.

Line in the periodValue
Opening stock (submitted opening count)$42,800
Plus purchases during the month$128,500
Minus closing stock (submitted closing count)$39,600
Cost of goods sold$131,700

This catches almost every new operator, and it is not a bug. Two submitted counts define a reporting period: an opening one and a closing one. Until the opening count exists and is submitted, the system has no starting point for the period. So your month-one cost results stay empty or reflect purchases alone, even after you have "done a count". Getting this one balance right is what makes the first month of numbers usable.

In practice this usually surfaces as a food cost dashboard that will not show a true cost of sales. It sits empty, or it reflects only what you have purchased. The instinct is to count again, but a second count does not help when the missing piece is the opening balance. The period has no opening figure to measure against, so recounting returns the same empty result. The fix is the opening count, not another closing one. Once a submitted opening balance exists for the period, the dashboard has both sides of the calculation and your cost of sales finally populates.

Stat callout showing cost of goods sold reads zero when no opening stock count has been submitted

The cost report follows the same rule: its date picker only offers dates with a completed stock count, so a site that skipped its opening count has no start date to pick.

Theoretical cost works as an interim view while the period is open, but it needs your POS items mapped to recipes. The actual number waits on the opening count, and the cost reports show each period once both counts are in.

Enter the opening count first, before your first purchase order

The opening count is a migration step, not just the first of your regular counts. It sets the starting position for the location. So it has to be the first activity there, before any purchase order or goods receipt is posted. Operators who treat it as an ordinary count end up with zero-value or misconfigured results. Run it after orders have already flowed and you lose the first month to rework.

So the sequence for a new site is simple: open the location, enter and submit the opening count, and only then raise the first purchase order. Regular counts follow on their normal schedule. If you are rolling out several sites, our restaurant inventory go-live checklist covers where this step sits in the wider launch.

Timeline of a new site setup: open location, enter opening count, submit it, then raise the first purchase order, then ongoing counts

Set the unit costs that anchor every future variance, then submit

The opening count has its own report view with an editable cost column, separate from a regular count. This is where you set the unit cost of each item you are holding. It is worth entering or checking these costs deliberately, because the opening valuation anchors every variance the system calculates afterwards. Many operators prefer their own team to key the opening costs rather than accept an automated default. That way the numbers are owned by the people doing the counting. This is part of Supy's restaurant inventory management software.

Once you submit the opening count, those costs flow into the inventory ledger and the COGS report. The step people miss is the submit itself. A count that is recorded but left in draft looks done, yet it silently blocks every cost and variance report for the period. If your report is still empty after counting, check this first.

Count statusWhat you seeActual costCOGSVariance
Recorded but in draftLooks complete on screenEmptyEmptyEmpty
Submitted (opening and closing)Costs locked into the periodCalculatesCalculatesCalculates

Our guide to stock count accuracy covers the checks that catch a half-finished count before you submit it, and the stock counting workflow shows the submitted state on every count.

Why the first variance after go-live is not real

The first variance report after go-live is almost always fiction when the opening count is missing. With no opening balance, on-hand quantities read negative and every variance is measured against a starting point that was never set. A warehouse created after the count date reads as zero stock, which inflates the numbers further.

Stat callout showing a reported variance of minus 18,400 dollars that is not a real loss

A reported variance of -$18,400 in that first period is not a real loss. It is the arithmetic of an empty opening balance, so treating it as real sends a team chasing discrepancies that do not exist. Check three things before you trust any figure:

  • Export. Pull the variance into a spreadsheet so you can sort it.
  • Rank. Look at the largest discrepancies first.
  • Set the baseline. Submit the opening count before you treat any variance as real.

Our explainer on negative stock reports walks through the same root cause from the inventory side.

What to do if you missed the window or lack full history

If orders and receipts have already posted, the count can no longer be marked as the initial one. Do not key hundreds of prices by hand to force it. Revert to a normal count and let your purchase-order receipts auto-populate item prices over the next few cycles, which corrects the valuation without the manual work. The theoretical-versus-actual gap this creates in the meantime is explained in our guide to theoretical versus actual food cost variance.

If you simply do not have complete historical figures, do not wait for perfect data. Enter a defensible best estimate for the opening balance now, submit it, and let your first full physical count correct it at the end of the period. A reasonable starting figure that you improve on beats an empty report you cannot use.

Recovery flow: activity already posted, revert to a normal count, let purchase-order receipts populate prices, then the first full count corrects the balance

Most empty or wrong cost results come from one of two situations. If the dashboard is empty or the cost report offers no start date, the opening count is missing or still in draft, so submit it and then the closing count.

If the dashboard shows data but the variance looks wrong, the period is open and the numbers are real measurements, so investigate before you trust them.

Decision tree matching an empty dashboard or a working dashboard to its one fix

A clean opening stock balance is the smallest onboarding step with the biggest payoff, because every cost and variance report you run afterwards depends on it. Before you trust your first COGS report, confirm three things. The opening count came first on the location. The unit costs on it are verified. And the count is submitted, not sitting in draft. Get those right and month one reads true.

Book a Demo with Supy - accurate COGS from your opening stock balance

Ready to optimize your restaurant operations?

Blog

Our operational insights

4-wall EBITDA by site: the group average hides the spread between a strong and a weak restaurant
Profit
Food cost

4-Wall EBITDA for Multi-Site Restaurants: Compare Every Site Fairly

Head chef comparing an over-portioned plate with an AI analysis of actual vs theoretical food cost
Food cost
Inventory

Actual vs Theoretical Food Cost: Find the Ingredient That Moved It

Four restaurants in one group seen from above, three healthy margins and one site losing money
Food cost

Average Restaurant Profit Margin and the Typical Range by Segment

Your questions 
answered

Everything you need to know about Supy — from setup to integrations, pricing, and daily use. If it’s not covered here, just ask.

What is an opening stock balance in a restaurant?
+

An opening stock balance is the value of all the inventory you are holding at the moment you start tracking, whether that is a brand-new site or your first period on a new system. It is the starting point every later number builds on. Cost of goods sold is calculated as opening stock plus purchases minus closing stock, so without an opening figure the calculation has nothing to begin from. In an inventory platform it is set through an initial stock count with the unit costs attached, and once submitted it anchors the valuation for the whole first period.

Why is my COGS report empty after I did a stock count?
+

Why the report is empty is almost always one of two things, and neither is a bug. First, the period has no opening count, so the opening side of opening plus purchases minus closing is zero and the report shows only purchases. Second, and easy to miss, the count was recorded but left in draft rather than submitted, which silently blocks every cost and variance report for that period. Check the submit state before anything else. A count that looks complete on screen still does nothing for your reporting until it is submitted.

What happens if I did not enter an opening balance before ordering?
+

What happens is that the count can no longer be marked as the initial one, because orders and receipts have already posted to the location. You do not have to key hundreds of prices by hand to fix it. Revert to a normal count and let your purchase-order receipts auto-populate item prices over the next few cycles, then let the first full physical count correct the balance. Your valuation lands right without the manual work. The trade-off is that cost and variance figures are less reliable for the first period, so treat that period as a settling-in window.

How do I set an opening balance without complete historical data?
+

How you handle missing history is to enter a defensible best estimate rather than wait for perfect figures. Count what you physically hold now, apply the most recent known unit costs, and submit that as the opening balance. It does not need to be flawless to be useful, because your first full physical count at the end of the period will correct it. A reasonable starting figure you improve on beats an empty report you cannot use at all. The important thing is to establish a submitted starting point so cost of goods sold has something to calculate from.

How do I fix a cost report with no selectable start date?
+

Submit the opening stock count for that period. The cost report's date picker only offers dates on which a stock count was completed. A month whose opening count was skipped therefore has no selectable start date, so no cost result can be generated. Complete and submit the opening count, and the date becomes available. Then submit the closing count to close the period. Confirm both counts read submitted rather than draft, because a draft count leaves the date picker empty and the report blank.

Why is my first variance report after go-live so large?
+

Because the opening balance was never established. With no opening stock count, on-hand quantities read negative and every variance is measured against a starting point of zero. A warehouse created after the count date also reads as zero stock, which inflates the numbers further. The result is a huge variance that is arithmetic, not real loss. Before you act on it, export the variance to a spreadsheet, rank the largest discrepancies, and submit the opening count. Only then does the variance reflect real movement rather than a missing baseline.

Can I see any cost figure before the period is closed?
+

Yes, theoretical cost is available as an interim view while the period is still open. It estimates cost from your recipes and sales rather than from counted stock, so it needs your POS items mapped to recipes to be accurate. It is useful for a running read between counts, but it is not the actual cost. For the real actual cost and cost of goods sold, you still need the opening and closing counts submitted to close the period. Treat theoretical cost as a guide, not the final number.

Ready to transform your operations?

Join 5,000+ restaurant operators cutting costs, streamlining operations and making smarter decisions with Supy.