Ending inventoryis the total value of goods you have available for sale at the end of an accounting period, like the end of your fiscal year. It’s an inventory accounting method that helps retailers benchmark net income, obtain financing, and run accurate stock checks.
Knowing your ending inventory value will impact your balance sheets and taxes. Before filing your income taxes or other importanttax deadlines, it's important to calculate the total value of your inventory for that year correctly.
This guide shares how to do it, with examples and tips to help youcontrol inventorymore accurately (and less stressfully).
Table of Contents
What is inventory value?
Inventory value is the total dollar value of the inventory you have left to sell at the end of an accounting period. You’ll often see it listed on financial statements, including your balance sheet, at the end of an accounting year.
In simple terms: If you start the month with $500 worth of items and sell $300 worth of stock, your ending inventory would be $200.
Why do you need to calculate ending inventory?
Your ending inventory balance isn’t just a metric to keep an eye on at year end. It’s aninventory valuationmethod to consider throughout the year. Here’s why.
Accurate inventory count
"Completing a fullphysical inventory countis the best way to calculate your ending inventory and start the new year on the right foot," explains Jara Moser, Digital Marketing Manager atShopventory.
"While counting every product in the store seems tedious, it ensures the products on your shelves match what’s in your books. It also means getting eyes on inventory hiding in the corner of your backstore and discovering operational trends, such as receiving errors."
If the ending inventory for your homeware line is $5,000 but you only counted $4,650 worth of goods in your stockroom, for example, you havephantom inventoryand it’s time to investigate what's causinginventory shrinkage. Employee theft,return fraud, or shoplifting could be the issue.
While manually counting inventory can feel tedious, it's essential for calculating ending inventory value. Businesses should invest in inventory management software to automate the monitoring process and get accurate inventory data with less manual work.
Accurate inventory counting helps plan youropen-to-buy budget, too. There’s not much sense in investing $10,000 into stock replenishment if you have $7,500 worth of unsold inventory. Avoid relying on intuition and ordering excesssafety stockif sellable products are lingering in your stockroom–awell-organized stockroomcan help mitigate this issue as well.
Calculate net income
Net income is one of the most important financial metrics for retailers to consider. It’s the money left in your bank account after paying for expenses—such as staff salaries, tax, and production costs—over a given period, usually shown on an income statement.
Benchmark your ending inventory value against your net income to see whether you’re overpaying for goods or underpricing stock.
If your ending inventory is $25,000 but your net income is just $20,000, you’re holding more money in inventory than you’ve generated in sales. Overpaying for stock could be the issue. Consider bartering with suppliers or increasing product prices for a healthier net income–to–ending inventory ratio.
These calculations can help businesses properly forecast their inventory needs and proactively engage with suppliers, which are both important to ensure profitability.
Inform future reports
Once year end passes, the ending inventory recorded on your balance sheet acts as the beginning inventory for the following year. Get your calculations wrong, or use a combination of methods (more on that later), and you’re setting yourself up for problems down the road.
Manage inventory from one back office
Shopify POS comes with tools to help you manage warehouse and store inventory in one place. Forecast demand, set low stock alerts, create purchase orders, know which items are selling or sitting on shelves, count inventory, and more.
Let’s put that into perspective and say your ending inventory for 2021 was valued at $50,000. Going into the following year, that figure would be listed as your starting inventory. Once 2022 ends, you’ll use it to calculate your ending inventory for that financial year. That’s much easier to do if the ending inventory for the year prior was accurate.
Obtain financing
Whether you’re looking for extra cash to buy more physical inventory items or take on newretail associates, lenders will want to see your financial statements before giving away money.
Loans exist to help retailers survive tough financial periods. They’re available so you don’t join the82% of small businesseswho shut up shop because of poor cash-flow management.
"From opening a second retail location to manufacturing your own product line, lenders need an accurate portrayal of your business," explains Jara.
准确的存货估价,股票数量,sales records are key. Properinventory managementeases financial obstacles and gives lenders insight into your profitability and demand volume.
Ending inventory is one metric they’re looking at, because it’s considered an asset. Lenders may be more willing to give your business funding—on more favorable terms—if the business has a low debt-to-asset ratio.
How to calculate ending inventory
Knowing your ending inventory gives you greater control over stock-related and financial decisions. So, how do you calculate it? Below are six methods to choose from.
- Ending inventory formula
- FIFO method
- 后进先出法
- Weighted average cost method
- Gross profit method
- Retail method
Bear in mind that whichever method you choose, you’ll need to stick with it. Financial reports become inaccurate—and the chance for mistakes become higher—if you’re switching between multiple ending inventory formulas.
专家提示:Rather than wait until the end of the year, view theMonth-end inventory value reportin Shopify admin to get a snapshot of yourinventory’s cost, ending quantity, and total value each month. If you see negative ending quantities, that’s a sign your inventory quantities for that product are incorrect and need to be reconciled.
Ending inventory formula
The simplest way to calculate ending inventory is using this formula:
Beginning inventory + new purchases -cost of goods sold(COGS) = ending inventory
For example, if your beginning inventory was worth $10,000 and you’ve invested $5,000 in new products, you’d be sitting on $15,000 worth of inventory. Minus the $12,000 worth of products you’ve sold through the same period, ending inventory would be $3,000.
5 Free Templates to Better Understand Your Inventory
Calculate your businesses cost of goods sold, sell through rate, inventory turnover, saftey stock, economic order quantity, or reorder point with ease using these custom templates. (No math required!)
Get your Inventory Templates delivered right to your inbox.
Almost there: please enter your email below to gain instant access.
We'll also send you updates on new educational guides and success stories from the Shopify newsletter. We hate SPAM and promise to keep your email address safe.
FIFO method
Other retailers prefer to calculate ending inventory using the first-in, first-out (FIFO) method. It assumes that the products you bought first were sold first, and is used by accountants throughout periods of economic uncertainty.
Let’s put it into practice and say you’re calculating the ending inventory for your retail store. You bought 150 candles at $7. Mid-way through the year, a supplier increased their prices. You bought another 150 candles at their new $9 price point. That’s 300 candles purchased at a total cost of $2,400.
Your order management system shows 130 candle sales at the end of the accounting period. You bought the $7 candles first, so COGS would be calculated as $7 x 130 = $910.
You’d then use the FIFO method to calculate ending inventory: Beginning inventory ($5,000) + new purchases ($2,400) - COGS ($910) = $6,490 ending inventory.
后进先出法
The last -in, first out (LIFO) method is another common way to calculate ending inventory. It assumes that products purchased most recently are the first items to be sold.
Using the same example as above, COGS would be calculated with the new $9 candle supplier price point (since those candles were ordered most recently). Selling 130 candles would mean your COGS equals $1,170.
That would make the ending inventory formula: Beginning inventory ($5,000) + new purchases ($2,400) - COGS ($1,170) = $6,230 ending inventory.
Weighted average cost method
Theweighted average cost (WAC) methodis the middle ground between FIFO and LIFO. It gives an average of how much eachstock keeping unit (SKU)is worth by dividing the total cost by the volume of inventory you have in your stockroom.
Sticking with the same example: $2,400 / 300 = average cost of $8 per candle. When we multiply this by 130 candle sales throughout the year, the COGS would total $1,040.
Here’s what that would look like: Beginning inventory ($5,000) + new purchases ($2,400) - COGS ($1,040) = $6,360 ending inventory.
Gross profit method
Gross profit, also known as gross margin, is the percentage of profit you’ll make on each product after subtracting the cost to produce it. Use this figure to calculate ending inventory using the following formula:
- Beginning inventory + COGS = total cost of goods available for sale
- Gross profit x sales = estimated cost of goods sold
- Total cost of goods available for sale - cost of goods sold = ending inventory
专家提示:Confused with all the math? Speed things up with thisfree profit margin calculator.
Retail method
Designed for stores that dophysical stock checks, you’ll need a few metrics on hand before using theretail inventory methodto calculate ending inventory:
- 因为t-to-retail ratio:因为t / retail price x 100
- 因为t of goods available for sale:Beginning inventory + cost of goods
- 因为t of sales: Sales x cost-to-retail ratio
From there, calculate ending inventory with this formula:因为t of goods available for sale - cost of sales = ending inventory.
Find your ending inventory
Knowing how much cash is tied up in inventory helps you make smarter business decisions—from accurate stock-taking reports to sensible open-to-buy budgets.
Just remember that whichever formula you use is the one that’ll see you throughout your store’s lifetime. Accurate and clear financial reports make your life easier down the road.
Stay on top of your finances
With Shopify POS, it’s easy to create reports and review your finances including sales, inventory value, returns, taxes, payments, and more. View your financial data for all销售渠道from the same easy-to-understand back office.
