Last verified · v1.0

Calculator · business

Ending Inventory Calculator

Calculate ending inventory using beginning inventory, net purchases, and COGS. Get instant, accurate period-end stock valuations for any business.

FreeInstantNo signupOpen source

Inputs

Beginning Inventory

Net Purchases

Cost of Goods Sold (COGS)

Ending Inventory Value

—

Get a plain-English breakdown of your result with practical next steps.

Ending Inventory Value—

The formula

How the
result is
computed.

What Is Ending Inventory?

Ending inventory is the total dollar value of goods a business holds at the close of an accounting period—a month, quarter, or fiscal year. This figure appears on the balance sheet as a current asset and feeds directly into gross profit calculations on the income statement. Accurate ending inventory measurement drives financial reporting integrity, tax compliance, and procurement decisions for retailers, manufacturers, and distributors of all sizes.

The Ending Inventory Formula

The foundational equation used across managerial accounting curricula expresses the movement of goods through a business:

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

This formula captures the perpetual flow of stock: a business opens a period with existing goods, adds new purchases, and removes units it sold. Whatever remains constitutes ending inventory.

Variable Definitions

Beginning Inventory: The verified dollar value of inventory at the start of the period, equal to the prior period's ending inventory balance. For a January statement, this equals the December 31 closing value.
Net Purchases: Total inventory acquisition cost after deducting purchase returns, allowances, and discounts. If gross purchases total $75,000 with $3,500 in returns and $1,000 in allowances, net purchases equal $70,500.
Cost of Goods Sold (COGS): The cost allocated to all inventory units sold during the period, reported on the income statement. COGS depends on the valuation method selected—FIFO, LIFO, or weighted average.

Step-by-Step Calculation Example

A home goods retailer reports the following figures for Q3:

Beginning Inventory: $140,000
Gross Purchases: $92,000
Purchase Returns and Allowances: $5,500
COGS: $108,000

Step 1 — Calculate Net Purchases: $92,000 − $5,500 = $86,500.

Step 2 — Apply the formula: $140,000 + $86,500 − $108,000 = $118,500 ending inventory.

This $118,500 posts to the September 30 balance sheet as a current asset and rolls forward as beginning inventory for Q4.

Inventory Valuation Methods and Their Effect

Because COGS varies with the valuation method chosen, the resulting ending inventory figure changes accordingly:

FIFO (First-In, First-Out): Assigns oldest costs to COGS first. During inflation, FIFO produces higher ending inventory values and higher reported net income.
LIFO (Last-In, First-Out): Assigns most recent costs to COGS first, yielding lower ending inventory and taxable income when prices rise. LIFO is prohibited under IFRS standards.
Weighted Average Cost: Divides total cost of goods available by total units to derive an average cost applied equally to COGS and ending inventory, smoothing price volatility across the period.

Physical Counts and Inventory Adjustments

The calculated ending inventory figure must align with a physical count to detect shrinkage, theft, or clerical errors. Many businesses perform cycle counts monthly and a full physical count annually. When physical count totals differ from the calculated balance, adjustments record obsolete stock write-downs, damaged goods reserves, or inventory valuation allowances. These adjustments ensure the balance sheet ending inventory reflects actual fair value available for sale, not just the mathematical result of the formula.

Why Accurate Ending Inventory Matters

Overstating ending inventory understates COGS, artificially inflating gross profit and net income—a frequent source of financial misstatement. Understating it reduces reported profit and may trigger unnecessary reorder activity. Lenders, auditors, and tax authorities depend on this figure for credit assessments, financial audits, and deductible expense validation. As documented in the University of North Georgia's Principles of Managerial Accounting, inventory valuation forms a cornerstone of cost accounting and period-end financial close. Eastern Connecticut State University's Ten Managerial Accounting Formulas similarly identifies the ending inventory equation as essential knowledge for every business analyst and accountant.

Practical Applications

Retail: Monthly stock reconciliation to identify shrinkage and set reorder points.
Manufacturing: Valuing finished goods and work-in-process at period close.
E-commerce: Matching fulfillment center physical counts to accounting records.
Tax Preparation: Computing deductible COGS for annual business tax filings.
Audit and Compliance: Reconciling book inventory to physical counts to detect and correct discrepancies.

Reference

Frequently asked questions

What is an ending inventory calculator?

An ending inventory calculator automates the formula: Beginning Inventory + Net Purchases minus Cost of Goods Sold. Users enter their period-start stock value, total net purchases, and COGS to instantly determine how much inventory remains on hand at period end. The tool eliminates manual arithmetic errors and accelerates period-end financial close for retailers, manufacturers, and distributors of any size.

How do you calculate ending inventory step by step?

First, identify the beginning inventory balance from the prior period's closing records. Second, calculate net purchases by subtracting purchase returns and allowances from gross purchases. Third, subtract COGS from the combined total. For example: $80,000 beginning inventory + $40,000 net purchases minus $65,000 COGS equals $55,000 ending inventory. Always verify that COGS matches the income statement before finalizing the figure.

What is the difference between beginning inventory and ending inventory?

Beginning inventory is the stock value carried forward from the prior period's closing balance, while ending inventory is the remaining value after accounting for all purchases and sales in the current period. The ending inventory of one accounting period automatically becomes the beginning inventory of the next, forming a continuous chain of valuation that links successive financial reporting periods together.

How does the FIFO valuation method affect ending inventory?

Under FIFO (First-In, First-Out), the oldest and typically lowest-cost inventory units are assigned to COGS first, leaving newer, higher-cost units in ending inventory. During periods of rising prices, FIFO produces a higher ending inventory balance on the balance sheet compared to LIFO or weighted average. This increases reported current assets and net income, which matters for loan covenants and investor analysis.

Why does ending inventory appear as a current asset on the balance sheet?

Ending inventory represents goods the business still owns that can be converted to cash through future sales, meeting the accounting definition of a current asset. Accurate reporting ensures the balance sheet reflects the company's true financial position. Lenders and investors analyze inventory levels to evaluate liquidity, assess operational efficiency, and detect potential demand slowdowns or supply chain disruptions before they affect overall cash flow.

What are the most common causes of errors in ending inventory calculations?

Frequent sources of ending inventory errors include unrecorded purchase returns, misclassified freight-in costs, miscounted physical stock, applying inconsistent valuation methods across periods, and failing to write down damaged or obsolete goods to net realizable value. Each error distorts COGS, gross profit, and net income. Regular cycle counts, systematic reconciliation of book records to physical counts, and consistent method application prevent these costly inaccuracies.