How this instrument works
Ending inventory is the dollar value of stock still on the shelf at the close of a period, and this instrument gets there by rearranging the same three-line identity used to compute cost of goods sold — solved for the opposite unknown. A controller closing monthly books already has cost of goods sold from the point-of-sale system or the income statement and needs the balance-sheet figure without walking every aisle with a clipboard; a loss-prevention manager wants to know what the shelf should hold so a physical count can be measured against it.
The arithmetic is elimination, not measurement. Beginning inventory plus everything purchased or produced during the period is every dollar of stock the business could have had on hand; subtracting whatever cost of goods sold already claims was sold leaves whatever is left over — the ending inventory this instrument returns. Because the answer is derived rather than counted, it is only as trustworthy as the cost of goods sold and purchase figures feeding it, and it says nothing about which specific units remain or whether they are damaged, obsolete, or simply missing.
The number's real use shows up in the gap between it and reality. A retailer that runs this calculation and then walks the stockroom will often find a smaller physical count than the arithmetic predicts — that shortfall is shrinkage: theft, breakage, or a receiving error, and it is exactly why insurers and auditors lean on this identity to estimate a fire or theft loss when no count is possible at all. Treating the computed figure as an audited balance, rather than a benchmark to test a real count against, is the mistake this page exists to head off.
- Enter Beginning inventory, $ — the value of stock on hand at the start of the period, taken from the prior period's closing balance.
- Enter Purchases during the period, $ — the cost of stock bought or produced since then, not outbound shipping or selling costs.
- Enter Cost of goods sold, $ — the expense already computed from sales records or the income statement for the same period.
- Read Ending inventory — the stock value the arithmetic implies, ready to compare against a physical count for the same date.
Worked example — $50,000 opening, $210,000 sold
Take a retailer that opened the period holding $50,000 of inventory and bought $200,000 more stock over the following months. Add those two figures and $250,000 of goods were available to sell, whether every unit moved or not — the same starting point cost of goods sold is built from.
The income statement already shows $210,000 of cost of goods sold for the period. Subtract that from the $250,000 available and $40,000 of inventory should remain on the shelf — the figure this instrument returns for exactly these inputs, and the number a stockroom count ought to land near if nothing was lost to shrinkage or damage along the way.
Questions
Why does this differ from just counting the stockroom?
Because it is a derived figure, not a measurement. It assumes every dollar of purchases minus cost of goods sold is still sitting on the shelf, with nothing lost to theft, breakage, spoilage, or a miscount. A physical count captures reality; this arithmetic captures what reality should be if nothing went wrong, which is exactly why comparing the two is useful.
What does it mean if the physical count comes in lower than this figure?
It usually points to shrinkage — inventory lost to theft, damage, spoilage, or clerical error between receiving and the shelf. Retailers track this gap as a percentage of sales; a growing gap across several periods is a signal worth investigating rather than writing off as rounding noise.
Can this replace a year-end physical count?
No. Most accounting standards and many tax rules still require a periodic physical count to validate the inventory a business reports. This calculation is a planning and reconciliation tool for the periods between counts, not a substitute for counting the shelf itself.
Where does the cost of goods sold figure come from if inventory has not been counted yet?
For a period where a physical count is impractical, businesses estimate cost of goods sold from sales revenue and a historical gross margin percentage, then run that estimate through this same arithmetic — a technique accountants call the gross profit method, common for interim statements and insurance loss claims.
Does Purchases during the period include freight and returns?
Freight paid to bring stock into the business belongs in Purchases, alongside the item cost itself; returns sent back to a supplier should be subtracted before entering the figure, since that stock was never available to sell in the first place.
Can ending inventory come out negative?
Only if cost of goods sold is entered larger than beginning inventory plus purchases combined, meaning more was reported sold than could have been on hand. That signals a data entry error or a cost of goods sold figure drawn from the wrong period, not a real result — a correctly matched period returns zero or a positive number.
References
- IRS — Publication 538, Accounting Periods and Methods
- IRS — Instructions for Form 1125-A, Cost of Goods Sold
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.