What Is Ending Inventory (And Why Does It Matter)?

Ending inventory is simply the value of all the unsold products your business has left at the end of an accounting period: a month, quarter, or year.

It matters a lot because it shows up in two critical places:

• Your balance sheet: as a current asset (something your company owns and can convert to cash)
• Your income statement: because it directly affects your Cost of Goods Sold (COGS), which determines your profit

Here’s the key thing to understand: if your ending inventory number is wrong, your profit is wrong. Overstate your inventory and you’re artificially inflating your profits. Understate it and you’re selling yourself short. Either way, the IRS, your investors, and your bank all care.

How to Calculate Ending Inventory: The Basic Formula

Before diving into the different methods, every approach starts from the same foundational formula:

Ending Inventory = Beginning Inventory + Net Purchases − Cost of Goods Sold (COGS)

Let’s break each piece down in plain English:

• Beginning Inventory — What you had left over from the previous period. Last month’s ending inventory becomes this month’s beginning inventory.
• Net Purchases — Everything you bought or manufactured during the period, minus any returns, damaged-goods allowances, or early-payment discounts you received.
• COGS (Cost of Goods Sold) — The cost of everything you actually sold during the period.

Quick example:

• Beginning inventory: $10,000
• Net purchases: $5,000
• COGS: $8,000
• Ending inventory = $10,000 + $5,000 − $8,000 = $7,000

One important note: “cost” isn’t just the price on the invoice. It includes everything it took to get that product ready to sell — shipping costs, insurance during transit, and any prep or assembly required.

The Two Ways Businesses Track Inventory

Before you can calculate ending inventory accurately, you need to know how your business tracks it day to day.

 There are two main systems:

Perpetual Inventory System

Think of this as the always-on approach. Every single time a product is received or sold, the records update automatically — usually through barcode scanners, RFID tags, or point-of-sale software.

Pros: You always know exactly what you have in real time. Great for reordering decisions and spotting theft quickly.

Cons: Expensive to set up. Requires software, hardware, and training.

Best for: Large retailers, e-commerce businesses, or any company with high transaction volume.

Periodic Inventory System

This is the old-school approach. You don’t update records constantly — instead, you do a full physical count at set intervals (monthly, quarterly, annually), and calculate COGS from that count.

The formula flips slightly under this system:

COGS = Beginning Inventory + Net Purchases − Ending Inventory (from physical count)

Pros: Simple and cheap. No fancy technology required.

Cons: You’re flying blind between counts. No real-time visibility into stock levels, and you won’t know about theft or damage until the count happens.

Best for: Small businesses, startups, or companies with low transaction volume.

The 4 Methods for Calculating Ending Inventory

Here’s where it gets interesting. Once you know how many units you have left, you still need to decide what cost to assign to them. Because prices change over time, accounting gives you four accepted methods to do this.

1. FIFO (First-In, First-Out)

The idea: The first items you bought are the first ones you sell. The newest purchases stay in inventory.

Think of it like: A grocery store rotating milk — the oldest cartons go to the front, newest to the back.

What it means for your numbers:

• COGS uses your oldest (usually cheaper) costs
• Ending inventory reflects your newest (usually higher) costs
• In times of inflation: higher reported profit, higher taxes, higher inventory value on your balance sheet

Best for: Businesses with perishable goods (food, medicine, cosmetics) or any product that can expire or become outdated.

2. LIFO (Last-In, First-Out)

The idea: The most recently purchased items are assumed to be sold first. The oldest inventory stays on the books.

Think of it like: A pile of lumber — you always grab from the top of the stack, which is the newest delivery.

What it means for your numbers:

• COGS uses your newest (usually higher) costs
• Ending inventory reflects your oldest (usually cheaper) costs
• In times of inflation: lower reported profit, lower taxes, lower inventory value on your balance sheet

Important catch: LIFO is only allowed under U.S. GAAP. It is banned under international accounting standards (IFRS), so global companies can’t use it.

Best for: U.S. businesses that want to reduce their tax burden during inflationary periods.

3. Weighted Average Cost (WAC)

The idea: Average out the cost of everything you had available to sell, then apply that single average to both what was sold and what remains.

The formula:

Weighted Average Unit Cost = Total Cost of Goods Available ÷ Total Units Available

Think of it like: Making a smoothie — instead of tracking each individual fruit, you blend everything together and treat it as one uniform mixture.

What it means for your numbers:

• Smooths out price swings — no extreme highs or lows
• Results land right in the middle between FIFO and LIFO

Best for: Businesses selling indistinguishable goods like gasoline, grain, chemicals, or bulk materials where tracking individual batches is impossible.

4. Specific Identification

The idea: Track the exact cost of each individual unit from purchase to sale.

Think of it like: A car dealership knowing exactly what they paid for each vehicle on the lot, and recording that precise cost when each specific car is sold.

What it means for your numbers:

• The most accurate method available
• But it requires every item to be uniquely tagged or serialized
• Vulnerable to manipulation (a seller could choose which unit to record as sold to hit a profit target)

Best for: Low-volume, high-value, one-of-a-kind items — luxury cars, fine jewelry, artwork, custom machinery.

Side-by-Side Comparison (During Inflation)

Note: In a deflationary environment (falling prices), the FIFO and LIFO effects reverse.

How to Estimate Ending Inventory (Without a Full Count)

Sometimes a full physical count isn’t practical, like at the middle of a quarter, or after a fire destroys your warehouse. In those cases, accountants use two estimation methods.

The Gross Profit Method

This method uses your historical profit margin to work backwards and estimate inventory.

Step-by-step:

1. Start with your Cost of Goods Available for Sale (Beginning Inventory + Net Purchases)
2. Multiply your Net Sales by your historical gross profit rate to estimate Gross Profit
3. Subtract estimated Gross Profit from Net Sales to get estimated COGS
4. Subtract estimated COGS from Goods Available for Sale to get estimated Ending Inventory

Limitation: This is an estimate only. It’s useful for interim reports but is not allowed for annual financial statements under GAAP. If your profit margins have shifted, the estimate can be significantly off.

The Retail Inventory Method

This is used by large retailers who track products at both their cost and their retail (selling) price.

The key calculation:

Cost-to-Retail Ratio = Total Cost ÷ Total Retail Value

Then:

Ending Inventory at Cost = Ending Inventory at Retail × Cost-to-Retail Ratio

There are two variations:

• Conventional (Conservative) Method — Includes markups but excludes markdowns. Gives a lower, more cautious inventory value.
• Average Cost Method — Includes both markups and markdowns. Gives a more historically accurate value.

When Inventory Loses Value: The Conservatism Rules

What happens when your inventory drops in value, because it’s damaged, outdated, or the market price has fallen? Accounting rules say you can never report inventory at more than it’s worth. You have to write it down.

There are two rules depending on which cost method you use:

• LCNRV (Lower of Cost or Net Realizable Value): Used with FIFO and Weighted Average. You compare your inventory’s cost to what you could realistically sell it for (minus any costs to complete or ship it), and report the lower number.
• LCM (Lower of Cost or Market): Used with LIFO and the Retail Method. “Market” here means the current replacement cost, but it’s kept within a range: it can’t be higher than what you can sell it for (the ceiling), and can’t be lower than that selling price minus a normal profit margin (the floor).

Both rules exist to protect readers of financial statements from being misled by inflated asset values.

Real-World Complications You Should Know About

Inventory Shrinkage

Shrinkage is the difference between what your records say you should have and what you actually have when you count it. It happens because of:

• Shoplifting or employee theft
• Vendor fraud
• Administrative errors
• Damage or spoilage

When shrinkage is discovered, it gets recorded as an expense. Tracking your shrinkage rate as a percentage of total inventory value is a key operational metric — a rising rate is a red flag worth investigating.

Goods in Transit: FOB Terms

Here’s a scenario that trips people up all the time: at the end of your accounting period, you have a shipment on a truck somewhere between you and your supplier. Does that inventory belong to you or them?

It depends on the shipping terms:

• FOB Shipping Point — Ownership transfers the moment the goods leave the supplier’s dock. If it’s in transit at year-end, it’s your inventory and must be included in your count.
• FOB Destination — Ownership doesn’t transfer until the goods physically arrive at your location. If it’s in transit at year-end, it still belongs to the supplier.

Getting this wrong can lead to double-counting or omitting inventory entirely — a material error on your balance sheet.

What Happens When You Make an Inventory Error

Inventory errors are sneaky because they have a ripple effect across two years:

If you overstate ending inventory in Year 1:

• Year 1: COGS is too low → profit is overstated → taxes might be overpaid
• Year 2: Beginning inventory is too high → COGS is overstated → profit is understated
• Net result: The error cancels itself out by the end of Year 2, but both individual years are wrong

This can trigger audit flags, violate debt covenants tied to current assets, and mislead investors about your true profit margins.

Quick-Reference Summary