Beginning and ending inventory: formulas and examples
By mise · Updated October 7, 2026
Quick answer: ending inventory is the value of what you count at the end of a period; it becomes the next period's beginning inventory. The link to COGS is: beginning inventory + purchases − ending inventory = COGS, so ending inventory = beginning inventory + purchases − COGS. Value counts at the latest purchase price (common in restaurants), FIFO or weighted average — and stay consistent.
Two numbers from two counts drive your whole cost of goods. Here is how they fit together and how to value them.
The formulas
Valuation methods
| Method | How | Used by |
|---|---|---|
| Latest purchase price | Count × last invoice price | Most restaurants and bars |
| FIFO | Oldest cost used first; stock valued at newest costs | Retail, accounting |
| Weighted average | Average cost of units available | Accounting systems |
For weekly food cost, latest price is practical and close to FIFO when stock turns fast. Whatever you choose, use the same method every period.
Where errors come from
- Counting at a different time than the last count.
- A delivery counted in stock but its invoice not in purchases (or the reverse).
- Different units between counts.
In mise each closed count is valued at the price you paid and becomes the starting point of the next period automatically.
Step by step: closing a month
- Count on the last day of the period, at the same time as last month (after close, before deliveries).
- Value the count with the same method as last period (latest purchase price is the practical choice in restaurants and bars).
- Add up purchases for the period from invoices, minus credits and returns. Include deliveries received on the count day only if they were counted.
- Calculate COGS: beginning + purchases − ending.
- Carry the ending figure forward as next month's beginning inventory. Never re-count or re-value it later.
Worked example by category
| Category | Beginning | Purchases | Ending | COGS | Sales | Cost % |
|---|---|---|---|---|---|---|
| Food | $6,100 | $22,400 | $6,800 | $21,700 | $70,000 | 31.0% |
| Liquor | $4,200 | $5,900 | $4,500 | $5,600 | $28,000 | 20.0% |
| Beer | $1,300 | $3,100 | $1,200 | $3,200 | $13,500 | 23.7% |
| Wine | $2,900 | $2,400 | $3,100 | $2,200 | $7,500 | 29.3% |
Splitting by category shows where cost moved. A total cost % can look fine while one category drifts.
When ending inventory looks wrong
- Much higher than usual: a delivery counted that is not in purchases yet, or a unit mix-up (cases entered as units).
- Much lower than usual: an area not counted (walk-in freezer, off-site storage) or a large invoice for stock that has not arrived.
- Swings every month: counting at different times of day or with different people and units.
Related: cost of goods sold for restaurants, inventory valuation methods, and the sales tax side of inventory.
Point the camera and the product comes up complete: name, brand, category, size and photo — the mise AI finds it from the barcode or a photo. Free trial, no card.
Start freeFrequently asked questions
How do you calculate ending inventory?
Count and value what is on hand at the end of the period. Or, from the books: beginning inventory + purchases − COGS.
Is ending inventory the same as next period's beginning inventory?
Yes, as long as both refer to the same moment and valuation method.
What if I forgot to count at month end?
Count as soon as possible and adjust with the deliveries and sales in between, or treat the two months as one period. Estimating the ending figure makes both months wrong.
Does ending inventory include items not yet paid for?
Yes, if you have received them. Inventory is what you own and hold, regardless of whether the invoice is paid.
Where does beginning inventory come from in the first month?
From your first full count. Before that there is no reliable beginning figure, so the first period with real COGS is the one between your first and second counts.
