Start free

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

COGS = beginning inventory + purchases − ending inventory
Ending inventory = beginning inventory + purchases − COGS
Example: March 1 count $9,400 (beginning). March purchases $31,200. March 31 count $10,100 (ending). COGS = 9,400 + 31,200 − 10,100 = $30,500. The $10,100 is April's beginning inventory.

Valuation methods

MethodHowUsed by
Latest purchase priceCount × last invoice priceMost restaurants and bars
FIFOOldest cost used first; stock valued at newest costsRetail, accounting
Weighted averageAverage cost of units availableAccounting 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

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

  1. Count on the last day of the period, at the same time as last month (after close, before deliveries).
  2. Value the count with the same method as last period (latest purchase price is the practical choice in restaurants and bars).
  3. Add up purchases for the period from invoices, minus credits and returns. Include deliveries received on the count day only if they were counted.
  4. Calculate COGS: beginning + purchases − ending.
  5. Carry the ending figure forward as next month's beginning inventory. Never re-count or re-value it later.

Worked example by category

CategoryBeginningPurchasesEndingCOGSSalesCost %
Food$6,100$22,400$6,800$21,700$70,00031.0%
Liquor$4,200$5,900$4,500$5,600$28,00020.0%
Beer$1,300$3,100$1,200$3,200$13,50023.7%
Wine$2,900$2,400$3,100$2,200$7,50029.3%

Splitting by category shows where cost moved. A total cost % can look fine while one category drifts.

When ending inventory looks wrong

Related: cost of goods sold for restaurants, inventory valuation methods, and the sales tax side of inventory.

Count your stock by scanning barcodes

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 free
Download on the App StoreGet it on Google Play
Keep reading Food cost calculator Restaurant COGS: how to calculate cost of goods sold Restaurant inventory turnover: formula and industry average All guides

Frequently 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.