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 period | Value |
|---|---|
| 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.

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.

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 status | What you see | Actual cost | COGS | Variance |
|---|---|---|---|---|
| Recorded but in draft | Looks complete on screen | Empty | Empty | Empty |
| Submitted (opening and closing) | Costs locked into the period | Calculates | Calculates | Calculates |
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.

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.

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.

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.


.jpg)





