Ending inventory (also called closing inventory) is the value of the stock your business still holds at the end of an accounting period. Get that number right and you can size orders correctly, price with confidence, and close the books without second-guessing.
This guide walks through how to find ending inventory: the formula, the main costing methods, and three ways to estimate the value. Use it to keep precise records, optimize stock levels, and protect your bottom line.
Key takeaways
- Ending inventory equals beginning inventory plus net purchases minus cost of goods sold (COGS).
- The costing method you choose, first in, first out (FIFO), last in, first out (LIFO), or weighted average cost, changes your ending inventory value.
- Three estimation methods, the gross profit method, the work-in-process method, and the retail method, value ending inventory when a full count isn’t practical.
- Accurate ending inventory keeps financial statements honest and guides smarter purchasing, stock, and cash-flow decisions.
What is ending inventory?
Ending inventory is the value of stock a business still has on hand at the close of an accounting period. It usually combines finished goods, raw materials, and work-in-process (WIP), the partially built items that sit between the two.
The figure matters because it feeds your balance sheet, your COGS, and your tax bill. Undercount it and profits look thin; overcount it and you overstate your assets.
Ending inventory also sets the starting line for the next period. Because today’s closing value becomes tomorrow’s opening value, a single mistake carries forward until someone catches it. That makes a clean count worth the effort every period, not just at year-end.
What is the ending inventory formula?
You can find ending inventory calculators online, but the math is simple enough to do yourself. Add the period’s net purchases to your beginning inventory, then subtract the cost of goods sold (COGS).
Ending inventory = beginning inventory + net purchases – cost of goods sold (COGS)
Work it in four steps:
- Pull beginning inventory: use last period’s ending inventory.
- Total net purchases: add purchases, then subtract returns and allowances.
- Calculate COGS: apply your chosen costing method for the period.
- Solve the formula: add beginning inventory to net purchases, then subtract COGS.
Say you open the quarter with $40,000 in stock, buy another $25,000, and record $45,000 in COGS. Your ending inventory works out to $20,000. That figure becomes the beginning inventory for the next quarter, so an accurate number compounds over time.
What are the ending inventory costing methods?
There’s no single correct way to value closing inventory, because different businesses have different needs. The method you choose shapes your COGS, which then feeds the ending inventory calculation.
Below are the three main inventory costing methods, FIFO, LIFO, and weighted average cost, followed by three methods built specifically for estimating ending inventory.
1. First in, first out (FIFO)
FIFO assumes your oldest inventory sells first. COGS reflects the cost of your oldest stock, so newer and often pricier items stay in ending inventory. In a rising-price environment, that leaves a higher inventory value on your balance sheet.
- Best for: perishable goods like food and pharmaceuticals, plus businesses that want inventory value to track current market prices.
- Drawback: during inflation, FIFO produces higher reported profits and, with them, a higher tax bill.
2. Last in, first out (LIFO)
LIFO assumes your newest inventory sells first. COGS reflects the most recently acquired items, leaving older, cheaper stock in ending inventory. That timing can trim taxable income when costs climb, which is why some US businesses favor it.
According to the KPMG IFRS Institute, LIFO is prohibited under IFRS (IAS 2), though it remains permitted under US GAAP.
- Best for: reducing tax liability during inflation, since higher COGS means lower taxable income.
- Drawbacks: LIFO isn’t allowed under IFRS, it can understate inventory value, and LIFO liquidations can spike profits and taxes.
3. Weighted average cost
Weighted average cost blends the cost of all inventory over the period into one figure, giving you a consistent COGS and ending inventory value. How you apply it depends on your system: a periodic approach averages cost at period-end, while a perpetual system recalculates after each purchase.
- Best for: businesses holding large quantities of interchangeable goods or commodities.
- Drawback: it’s simpler than FIFO and LIFO but hides cost fluctuations across the period.
Getting the method right pays off in precision. Fidalgo Coffee Roasters, a coffee roaster, credits Fishbowl with getting its “costing down to the penny.”
Three methods for estimating ending inventory
When a full physical count isn’t practical, these three methods estimate the value instead. Each one interacts with your costing choice, so the numbers shift depending on whether you use FIFO, LIFO, or weighted average cost.
1. Gross profit method
The gross profit method estimates ending inventory from your gross profit margin. It’s quick when you need a figure between physical counts, and accountants often use it to reconstruct inventory after a fire, theft, or other loss.
How it works:
- Find goods available for sale: add beginning inventory and purchases.
- Estimate COGS: apply your gross profit margin to sales.
- Estimate ending inventory: subtract estimated COGS from goods available for sale.
How your costing method shifts the estimate:
- FIFO: during inflation, lower COGS raises the estimated ending inventory value.
- LIFO: higher COGS during inflation lowers the estimated ending inventory value.
- Weighted average cost: blended costs smooth the estimate, landing between FIFO and LIFO.
Worked example:
- Beginning inventory: $50,000
- Net purchases: $30,000
- Sales: $100,000
- Gross profit margin: 40%
- Estimated COGS: $100,000 x 0.60 = $60,000
- Cost of goods available for sale: $50,000 + $30,000 = $80,000
- Ending inventory: $80,000 – $60,000 = $20,000
2. Work-in-process method
The work-in-process (WIP) method tracks partially completed goods by adding up direct materials, labor, and overhead. It’s ideal for manufacturers that carry stock mid-production, where value sits on the shop floor rather than in finished goods. Without it, a job halfway through assembly would drop off your books.
How valuation methods affect WIP costs:
- FIFO: values transferred goods at the oldest input costs first.
- LIFO: values transferred goods at the most recent input costs first.
- Weighted average cost: averages input costs across the period.
WIP example:
- Beginning WIP: $15,000
- Costs added: $30,000
- Costs completed and transferred out: $30,000
- Ending WIP: $15,000
3. Retail method
The retail method applies a cost-to-retail ratio to estimate ending inventory. It suits retailers carrying large inventories of similar goods, where counting every SKU by cost would be slow. Instead, you work from retail prices you already track at the register.
Retail method steps:
- Find the cost-to-retail ratio: divide cost of goods available for sale by retail value.
- Value inventory at retail: total your ending inventory at retail prices.
- Convert to cost: multiply the retail figure by the cost-to-retail ratio.
How the costing method shifts the ratio:
- FIFO: the ratio leans on older costs, nudging the estimate higher during inflation.
- LIFO: the ratio leans on recent costs, pulling the estimate lower during inflation.
- Weighted average cost: the ratio uses blended costs for a steadier estimate.
Retail example:
- Cost of goods available for sale: $60,000
- Total retail value: $100,000
- Cost-to-retail ratio: 0.6
- Ending inventory at retail: $20,000
- Ending inventory at cost: $20,000 x 0.6 = $12,000
The way you value closing inventory affects both your financial statements and your tax liability. Check your approach with an accounting professional before you file.
How do you use ending inventory?
Knowing how to find ending inventory is step one; putting the number to work is where it pays off. Beyond the balance sheet, the value drives decisions across finance, purchasing, and operations. Here are four ways operators use ending inventory day to day.
1. Accurate financial reporting
Ending inventory is a key line on your balance sheet, so an accurate valuation keeps your financial statements true and fair. Investors weighing your business, lenders sizing a loan, and your own planning team all lean on that figure.
IHL Group estimates that inventory distortion, meaning overstocks and out-of-stocks, costs retailers roughly $1.73 trillion worldwide each year. An accurate ending inventory figure is one of your best defenses against it.
A 2025 study in the International Journal of Current Science Research and Review found that 52.85% of one warehouse’s products showed record discrepancies during a single year’s stock count, a reminder that book values drift from reality without disciplined counts.
Fishbowl customers feel the difference. Prince Michel Vineyard & Winery cut its inventory adjustments from 12% to 2% after moving to Fishbowl. The winery also shifted cost-to-manufacture calculations from six months after year-end to immediately after manufacture, improving accuracy by more than 10%.
2. Optimizing stock levels
An accurate ending inventory figure helps you right-size stock, so you carry what sells and skip what stalls. It supports three practical wins:
- Minimize holding costs: Avoid tying up too much capital and reduce obsolescence risk.
- Meet customer demand: Keep enough stock to fill orders without overbuying.
- Improve cash flow: Free up capital that would otherwise sit on shelves.
3. Aligning inventory with market demand and business goals
Ending inventory data reveals your sales patterns, which sharpens planning. Watch how the closing figure moves period to period and you can read demand before it becomes a stockout. Put those insights to use in three ways:
- Adjust purchasing decisions: buy to match real demand instead of guesswork.
- Identify slow-moving items: spot stock that ties up cash and shelf space.
- Align inventory with business goals: match stock to your growth or margin targets.
4. Benchmarking performance across locations
Tracking ending inventory alongside inventory turnover lets you compare sites fairly. Once every location values stock the same way, the differences you see reflect performance, not accounting quirks. That comparison helps you:
- Identify operational inefficiencies: flag locations holding too much or too little.
- Optimize inventory distribution: shift stock toward where demand actually is.
- Improve overall supply chain management: tighten the flow from supplier to customer.
How can Fishbowl simplify ending inventory?
Manual counts and spreadsheet math leave room for error, and those errors surface in your financial statements. Fishbowl’s inventory management solution tracks stock in real time and keeps your ending inventory accurate as goods move.
The system enforces the discipline that keeps counts honest: you can’t ship what you don’t have, and you can’t skip a receive. When the ledger is trustworthy, your ending inventory calculation stops being a quarterly scramble.
Because Fishbowl syncs with QuickBooks, your inventory and accounting stay aligned, giving you clean COGS and a faster close. That’s ERP-level control without an ERP project.
When you need a custom view, Fishbowl AI Insights generates dashboards and reports in plain language, without SQL or custom report requests. Setup takes time, but you’re not doing it alone: you get a dedicated implementation specialist, hands-on training, and AI-guided data migration before go-live.
Once you know how to find ending inventory, the real work is keeping it accurate every period. Book a Demo and see the numbers work with your own data.
Frequently asked questions about ending inventory
Which inventory costing method should a small business use: FIFO, LIFO, or weighted average?
The best method depends on the goods you sell and your tax goals. FIFO suits perishable or fast-moving stock and reports remaining inventory near current market prices, which many owners prefer. LIFO can lower taxable income during inflation, but IFRS bans it, so many small businesses default to weighted average cost.
How do you calculate ending inventory without knowing COGS?
Two estimation methods let you skip a direct COGS figure. The gross profit method multiplies sales by your expected gross margin to approximate COGS, then subtracts it from goods available for sale. The retail method applies a cost-to-retail ratio to your ending inventory at retail value, giving a quick estimate between physical counts.
What’s the difference between ending inventory and beginning inventory?
Beginning inventory is the stock you hold at the start of an accounting period, and ending inventory is what remains at the close. They connect directly, because this period’s ending inventory becomes next period’s beginning inventory. Both feed the ending inventory formula and shape your COGS, and the gap between them shows whether stock grew or shrank.
Does ending inventory affect gross profit?
Yes, directly, because gross profit equals sales minus COGS, and COGS depends on ending inventory. A higher ending inventory value lowers COGS and raises gross profit, while a lower value does the opposite. That link is why accuracy matters: an error in ending inventory flows straight into reported profit, and often into your tax bill.
Where does ending inventory appear on financial statements?
Ending inventory appears on the balance sheet as a current asset, usually listed under “Inventory.” It also shapes the income statement, because it feeds the COGS calculation that determines gross profit. The same figure touches both statements in one period, so a small counting error can distort your assets and profit at once.
Related posts
Explore these related inventory guides: