What Ending Inventory Means on the Balance Sheet
Ending inventory is the cost of unsold goods at period close, and it lands in current assets — usually the largest line after cash and receivables for product businesses. The same number reaches the income statement in disguise: because COGS equals beginning inventory plus purchases minus ending inventory, whatever you report as closing stock directly changes gross profit. Overstate it by $10,000 and COGS drops $10,000, profit rises the same amount, and the tax bill follows.
Because the figure flows through both statements, auditors treat it as a high-risk account. They test the cut-off of purchases and sales around period end, observe physical counts, and check valuation at the lower of cost or net realizable value. The arithmetic is trivial; the evidence behind each input is where audits find problems. A clean calculation built on sloppy purchase accruals still produces a wrong balance sheet.
Liquidity ratios lean on the number too. The current ratio calculator treats inventory as a current asset, though a stock-heavy ratio can hide weak cash conversion. If your closing balance keeps climbing while sales stay flat, the working capital story behind the ratio is deteriorating even when the headline number looks stable.
The Ending Inventory Formula, Term by Term
The identity is ending inventory = beginning inventory + net purchases − COGS. Beginning inventory is last period's closing figure — carry it forward untouched or every downstream number drifts. Net purchases means invoice cost plus freight-in and any import duties, minus purchase returns and early-payment discounts. Booking freight-in as an operating expense is the classic error that quietly understates the closing stock.
COGS is the cost of the units actually delivered to customers this period, not the cost of what was bought. Under a periodic system you derive COGS through this same formula after counting; under perpetual it accumulates scan by scan. Either way the equation balances: goods available for sale minus what left the building equals what remains on the shelf.
Run the default numbers: $40,000 beginning + $250,000 net purchases − $245,000 COGS = $45,000 ending inventory. Average inventory is ($40,000 + $45,000) ÷ 2 = $42,500, turnover is 245,000 ÷ 42,500 = 5.76 turns, and days on hand is 365 ÷ 5.76 ≈ 63 days. The COGS calculator covers the cost-of-sales side of the same identity when you need that figure on its own.
Estimating Without a Count: The Gross Profit Method
When a full physical count is impractical — interim months, destroyed records, a fire claim — the gross profit method approximates the closing balance. Multiply period sales by (1 − historical gross margin) to estimate COGS, then subtract that from goods available for sale. The tool's second mode runs this directly from your sales and margin inputs and labels the output as an estimate rather than a measured figure.
The estimate is only as good as the margin assumption. On $320,000 of sales, a 30% margin implies $224,000 of COGS and a $66,000 closing balance on the default inputs. Shift the margin to 25% and the estimate drops to $50,000; push it to 35% and it climbs to $82,000. Five points of margin moves the answer $16,000, so enter the margin you actually earned recently, not a pricing target.
Historical margin comes from your own records: the markup calculator converts between markup and margin when your pricing file quotes one convention and your statements report the other. GAAP permits the gross profit method for interim estimates but requires a physical count or an accepted technique such as the retail inventory method for annual statements.
Turnover, Days on Hand, and What They Signal
The calculator converts the closing balance into turnover and days on hand because a dollar figure alone says little. Turnover equals COGS ÷ average inventory, and days on hand equals 365 ÷ turnover. The default scenario lands at 5.76 turns and 63 days, meaning about two months of forward stock at the current sell rate.
Benchmarks are sector-specific: grocery chains turn 12–15 times a year, general merchandise 5–8, machinery dealers 3–4, and jewelers 1–2. Compare against your own history first — a drop from 6 turns to 4 on flat sales means roughly 50% more cash parked on shelves, and that cash earns nothing while storage, insurance, and handling keep billing.
Days on hand is the inventory leg of the cash cycle. Feed the figure into the days inventory outstanding calculator for the DIO convention analysts use, then see how it combines with receivable and payable days in the cash conversion cycle calculator. At 63 inventory days, 45 receivable days, and 30 payable days, cash completes a full 78-day cycle.
Periodic vs Perpetual Systems
Under a periodic system, ending inventory is only known for certain when you count; between counts the book figure is derived from purchases and sales records. Under a perpetual system, each sale decrements the records in real time and the book balance should match the shelf. The formula is identical in both — the difference is whether COGS is measured directly or derived from the closing count.
In practice perpetual records drift: receiving errors, unscanned deliveries, theft, and damage all widen the gap. Most perpetual businesses still count annually or cycle-count continuously and book the difference as shrinkage. When the count says $43,200 and the derived book says $45,000, the $1,800 gap is 4% of the book balance and about 0.56% of sales — within retail norms, but worth investigating above the 1–2% band.
Shrinkage is not cosmetic. The write-off flows through COGS, so it reduces gross profit and operating income, and inventory write-downs also depress the figure a EBITDA calculator produces for lenders tracking coverage covenants. Persistent unexplained shrinkage is one of the first places forensic accountants look for theft and fraud.
Shrinkage, Write-Downs, and Lower of Cost or NRV
Inventory carries at the lower of cost or net realizable value — estimated selling price minus costs to complete and sell. Damage, obsolescence, and price erosion trigger write-downs in the period they occur. A warehouse of last year's model valued at cost while the market pays 60% of that is an overstated asset and an overstated profit waiting to correct next quarter.
Write-downs also reset the base for the following period: a written-down ending inventory becomes a lower beginning figure, which suppresses next period's COGS and quietly lifts gross margin. Analysts watch for this see-saw after a large inventory charge — part of the next quarter's margin improvement is mechanical rather than operational, and models that ignore it overstate the rebound.
Heavy inventory positions distort distress metrics too. The altman z score calculator includes working capital in its score, and stale stock inflates that input even though slow inventory converts to cash poorly. Auditors read the inventory footnote against liquidity scores before trusting either number on its own.
How Lenders and Analysts Read the Number
Lenders financing inventory through revolvers or floor plans advance against a borrowing-base percentage of appraised stock — commonly 50% for general merchandise and 80–90% only for fast-turn goods like groceries or fuel. The closing balance you report sets the collateral value, so inflated numbers surface at field exams, and a retraction tightens the credit line immediately after.
For valuation work, inventory is usually a working-capital adjustment in the purchase agreement: the deal price assumes a normal stock level, and surplus or obsolete inventory is excluded or heavily discounted. A clean, count-backed closing figure with documented turnover shortens that negotiation. The business valuation calculator shows where the working capital assumption lands inside a multiples-based price.
Margins move the estimate from the outside too. A lender re-deriving your gross profit from comparable companies gets a different implied inventory than your books show, and when the two disagree by more than a few percent, expect questions before the next advance. Clean purchase accruals keep both numbers aligned and audits boring.
Inventory Inside the Working Capital Sequence
Cash flows through inventory in a fixed order: pay suppliers, hold stock, sell on terms, collect receivables. The closing inventory balance is the middle leg, and its days directly measure how long cash sits idle. Compressing inventory days by ten at the same sales rate frees about 10/365 of annual COGS in cash — roughly $6,700 on $245,000 of yearly cost of sales.
The other two legs have their own clocks. The AR days calculator measures how long receivables take to convert to cash, and the days payable outstanding calculator shows how long you hold supplier money before paying. Optimizing one leg in isolation often backfires — stretching payables while inventory balloons just moves the squeeze to a different part of the cycle.
Set a target closing balance each period instead of letting it drift: sales forecast ÷ target turns × cost ratio gives the stock level the sales plan supports. Compare that target to the calculated closing figure every month. A persistent gap points to either future stockouts or future write-downs, and both are cheaper to find in a spreadsheet than on the shelf.