📦 Ending Inventory Calculator

Ending inventory is the value of unsold stock when an accounting period closes, and it sits on the balance sheet as a current asset. The formula is pure logic: what you started with, plus what you bought, minus what you sold, equals what remains. Getting it right matters twice, because ending inventory also determines cost of goods sold and therefore gross profit.

How to Use This Calculator

The Formula

Equivalently: COGS = Beginning Inventory + Purchases − Ending Inventory. The two formulas are the same seesaw: raise ending inventory and COGS falls, which raises gross profit. That is why auditors scrutinize inventory counts so closely. For method-specific valuation see our FIFO inventory calculator.

Worked Example

A wholesaler starts the quarter with $80,000 of stock, purchases $220,000 more, and sells goods costing $195,000. Ending inventory = $80,000 + $220,000 − $195,000 = $105,000. Goods available for sale were $300,000, so about 65 percent moved and 35 percent remains. If the physical count comes in at $98,000 instead, the $7,000 gap is shrinkage, theft, damage, or error, and it gets written off against profit.

Tips for Accuracy

Count on the same date you close the books; timing mismatches between counts and cutoffs create phantom variances. Value inventory at cost, not retail price, and apply the lower-of-cost-or-market rule for obsolete stock. Track shrinkage separately rather than burying it in COGS, because a rising shrink rate is an operations problem masquerading as a margin problem. Small businesses should count quarterly at minimum; annual counts let errors compound for a year.

Common Mistakes

Forgetting goods in transit is the classic: inventory you own but have not received still counts if title has passed. Including consignment stock you do not own inflates assets. A subtler error is inconsistent costing methods between periods, which makes trend analysis meaningless; pick FIFO, LIFO, or weighted average and disclose it. And never "plug" ending inventory to hit a profit target: that is fraud, it reverses next period, and auditors are trained to spot exactly that pattern.

Why Auditors Obsess Over It

Inventory is the easiest profit lever to pull dishonestly and the hardest to verify cheaply, which is why audit standards require physical observation of counts. A $10,000 overstatement of ending inventory is a $10,000 overstatement of gross profit, dollar for dollar, with no cash to corroborate it. Lenders care too: inventory secures many credit lines, and borrowing against phantom stock ends badly. The count is boring, and the count is everything.

Tax planning adds another wrinkle: because ending inventory directly sets COGS, it sets taxable income too. Businesses cannot simply choose a low count to cut taxes; the physical count and the costing method bind them. But timing legitimate purchases before year-end does raise ending inventory and defer profit into next year, a standard and legal smoothing tactic. Coordinate counts with your accountant, not after the fact.

Perpetual vs Periodic Systems

Modern inventory systems are perpetual: every sale and purchase updates the count in real time, so ending inventory is known daily without a formula. The periodic formula in this calculator survives for small businesses, year-end closes, and as the audit check on perpetual systems. When the perpetual record says $105,000 and the physical count says $98,000, the $7,000 gap is shrinkage demanding explanation.

Perpetual systems still need the formula's logic at count time. Cycle counting, counting a slice of SKUs daily on rotation, keeps the perpetual record honest without annual shutdown counts. High-value items get counted monthly, fast movers quarterly, slow bulk annually: audit effort follows risk, not the alphabet.

The choice is cost versus control. Barcode or RFID perpetual tracking pays for itself quickly above a few hundred SKUs or meaningful shrink rates; below that, a disciplined periodic count with this calculator's math is perfectly respectable. Either way, the physical count is the ground truth and the system must bow to it.

Inventory and Loan Covenants

When inventory secures a credit line, lenders do not accept your number at face value. Borrowing-base certificates apply haircuts: raw materials at 50 to 60 percent of book, finished goods higher, work-in-progress and obsolete stock often zero. A $105,000 ending inventory might support only $55,000 of borrowing, and the certificate is filed monthly.

This creates a direct link between count accuracy and liquidity. Overstated inventory inflates the borrowing base until the field audit, and the resulting forced paydown arrives exactly when cash is tightest. Conservative valuation is not just good accounting here; it is covenant compliance.

Seasonal businesses feel this hardest: inventory peaks before the selling season while the borrowing need peaks with it, and lenders know the pattern. Negotiate the advance rate and eligible categories when times are good, because amendments signed in distress cost fees and pride. The inventory footnote in your loan agreement deserves the same attention as the interest rate.

Estimates for planning only, not financial advice.