Ending Inventory Calculator

Calculate ending inventory using beginning inventory, purchases, and cost of goods sold.

What Is Ending Inventory?

Ending inventory is the total value of goods a business still has in stock at the end of an accounting period. It appears as a current asset on the balance sheet and directly affects the cost of goods sold (COGS) calculation for the next period. Accurate ending inventory figures are essential for financial reporting, tax filings, and inventory management decisions.

How the Ending Inventory Calculation Works

The calculator uses the standard inventory accounting formula:

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

Each input represents a specific component of inventory flow during a period:

Beginning Inventory — the value of inventory at the start of the period (carried over from the prior period's ending inventory).
Purchases — the total cost of additional inventory acquired during the period, including freight and handling costs.
Cost of Goods Sold (COGS) — the direct costs attributable to the inventory sold during the period.

The formula assumes no inventory write-downs, theft, or spoilage unless those losses are already reflected in the COGS figure.

How to Use the Ending Inventory Calculator

Enter the Beginning Inventory value for the period.
Enter the total Purchases made during the period.
Enter the Cost of Goods Sold (COGS) for the same period.
The calculator instantly returns the Ending Inventory value.

All values should be in the same currency. The tool works for any accounting period — monthly, quarterly, or annually.

Example Calculation

A retail store starts the quarter with $50,000 in inventory. During the quarter, it purchases $30,000 worth of additional stock. The cost of goods sold for the quarter is $45,000.

Ending Inventory = $50,000 + $30,000 − $45,000 = $35,000

The store's ending inventory value is $35,000, which becomes the beginning inventory for the next quarter.

Understanding Your Results

The ending inventory figure represents the cost value of unsold goods, not their retail selling price. This value is used to calculate gross profit and appears on the balance sheet as a current asset.

If the result seems unexpectedly high or low, verify that all purchases and COGS figures are complete and accurate for the period. Discrepancies often stem from omitted purchase invoices, unrecorded sales, or inventory losses not yet accounted for in COGS.

Common Mistakes When Calculating Ending Inventory

Using retail prices instead of cost — ending inventory must reflect the cost paid to acquire goods, not the selling price.
Omitting period adjustments — returns, discounts, and freight costs should be included in purchases or COGS as appropriate.
Mixing accounting methods — consistency in inventory valuation (FIFO, LIFO, or weighted average) is critical for accurate period-over-period comparisons.
Ignoring shrinkage — theft, damage, or spoilage that isn't captured in COGS will cause the calculated ending inventory to differ from physical counts.

Limitations of the Basic Formula

The standard ending inventory formula provides a simplified view of inventory flow. It does not account for:

Inventory write-downs due to obsolescence or market value declines.
Physical inventory shrinkage from theft, damage, or administrative errors.
Differences between periodic and perpetual inventory systems.
Multi-warehouse or multi-currency inventory scenarios.

For businesses with complex inventory operations, the calculated figure should be reconciled with a physical inventory count at period end.

Practical Use Cases

Monthly financial reporting — quickly estimate ending inventory for internal management reports before physical counts are completed.
Budgeting and forecasting — project future inventory needs based on expected sales and purchasing patterns.
Tax preparation — calculate COGS and ending inventory for income tax filings that require periodic inventory valuations.
Inventory turnover analysis — use ending inventory figures to compute turnover ratios and assess stock management efficiency.

Frequently Asked Questions

What is the difference between ending inventory and closing stock?

They refer to the same concept. Ending inventory and closing stock both describe the value of unsold goods at the end of an accounting period. "Closing stock" is more commonly used in manufacturing contexts, while "ending inventory" is standard in retail and general accounting.

Can ending inventory be negative?

No. A negative ending inventory indicates an error in the input data — typically COGS exceeding the sum of beginning inventory and purchases. This can happen if purchases are understated, beginning inventory is incorrect, or COGS includes goods that were never actually in stock.

How does the inventory valuation method affect ending inventory?

The valuation method (FIFO, LIFO, or weighted average) determines how costs are assigned to sold versus unsold goods. Under FIFO, ending inventory reflects the most recent purchase costs. Under LIFO, it reflects older costs. Weighted average spreads costs evenly. The calculator assumes a single cost basis — you must apply your chosen method consistently when entering purchase and COGS values.

Should I include freight costs in purchases?

Yes. Freight-in, handling, and other costs directly incurred to acquire inventory are typically included in the purchase cost. This aligns with accounting standards that require inventory to be recorded at its full acquisition cost.

How often should ending inventory be calculated?

Most businesses calculate ending inventory at the end of each accounting period — monthly, quarterly, or annually. The frequency depends on reporting requirements, inventory turnover rate, and the need for timely financial data. Regular calculation helps identify discrepancies early and supports accurate financial reporting.