Ending Inventory Calculator

What does this ending inventory calculator estimate?

This calculator reconciles the inventory cost flowing through one accounting period. It starts with the inventory already on hand, adds net purchases, and then divides the resulting goods available for sale between cost of goods sold and ending inventory. You can work in either direction: enter cost of goods sold to calculate ending inventory, or enter ending inventory to calculate cost of goods sold. The tool also estimates average inventory, inventory turnover, and the percentage of goods available that remains unsold at period end.

The outputs are accounting estimates, not a replacement for a physical inventory count, a perpetual inventory system, or professional review of your costing method. The IRS accounting-period and methods guidance explains why consistent inventory accounting matters, while the IRS Tax Guide for Small Business provides broader context for cost of goods sold and inventory records.

How should each input be completed?

Calculation mode

Select “Yes — calculate ending inventory” when cost of goods sold is already available from your accounting records. Select “No — calculate cost of goods sold” when you have completed an ending inventory count or valuation and need to derive COGS. This field is required because it determines which amount is treated as an input and which amount is solved by the model.

Starting inventory

Starting inventory is the carrying value of inventory at the beginning of the period. It normally equals the prior period’s ending inventory. Enter the amount in U.S. dollars and include all inventory categories covered by the same COGS figure. A higher starting balance increases goods available for sale and, with other inputs unchanged, increases ending inventory or calculated COGS. A common mistake is mixing a quantity count with a monetary cost value.

Net purchases

Net purchases represent inventory acquired during the period after purchase returns, allowances, and discounts, plus freight-in or other costs capitalized into inventory under your accounting policy. Enter zero when no inventory was purchased. Higher net purchases increase goods available for sale. Avoid entering total vendor payments when those payments include equipment, services, sales tax treated separately, or noninventory expenses.

Cost of goods sold

When COGS is known, enter the direct inventory cost assigned to goods sold during the period. COGS should be measured on the same basis as starting inventory and purchases. Increasing COGS reduces calculated ending inventory dollar for dollar. COGS cannot logically exceed goods available for sale in this simplified reconciliation; the calculator flags that condition instead of displaying a misleading negative inventory balance.

Ending inventory

When COGS is unknown, enter the cost value of inventory remaining at period end. This amount may come from a physical count, cycle count, or reliable perpetual inventory record. Increasing ending inventory lowers calculated COGS dollar for dollar. Ending inventory should not exceed goods available for sale unless there is an omitted purchase, an incorrect beginning balance, or another reconciliation issue.

How does the ending inventory formula work?

Ending inventory = Starting inventory + Net purchases − Cost of goods sold

The first two terms form goods available for sale. The model then subtracts the cost assigned to units sold. When ending inventory is known instead, the formula is rearranged to COGS = Starting inventory + Net purchases − Ending inventory. This is a cost-flow equation: it tracks dollars, not selling prices or gross profit. FIFO, LIFO, weighted-average, and specific-identification methods may assign different costs to COGS and ending inventory even when the physical quantities are identical.

For additional background on cost-flow assumptions, review the Investopedia overview of inventory. The model here does not choose a valuation method; it assumes all entered amounts were produced under one internally consistent method.

How should the results be interpreted?

Ending inventory or calculated COGS

The primary result is whichever amount the selected mode solves. A zero ending inventory means all goods available were assigned to COGS. A zero COGS means none of the available inventory cost was assigned to sales. Negative values are not presented because they indicate inconsistent inputs rather than a meaningful operating result.

Goods available for sale

This total equals starting inventory plus net purchases. It is the maximum amount that can be split between COGS and ending inventory in the simplified model. If this figure is unexpectedly high, check whether purchases include noninventory items or whether beginning inventory was duplicated.

Average inventory and inventory turnover

Average inventory is the simple mean of starting and ending inventory. Inventory turnover equals COGS divided by average inventory. A higher turnover generally indicates that inventory cost moved through the business more frequently, but an unusually high figure can also signal insufficient stock, stockouts, or volatile purchasing. A low figure can indicate slow-moving goods, excess buying, obsolescence, or seasonal buildup. There is no universal “good” turnover ratio; compare it with your own history and relevant peers. The inventory turnover explanation from Investopedia provides additional interpretation.

Ending inventory share

This percentage divides ending inventory by goods available for sale. A high share means more inventory cost remains on the balance sheet, while a low share means more cost flowed into COGS. The ratio is sensitive to seasonality, purchasing timing, demand, markdowns, write-downs, and the chosen costing method.

How do the chart and table support review?

The donut chart shows the disposition of goods available for sale: the portion assigned to COGS and the portion remaining as ending inventory. Its legend and data table use the exact same current model values, so the visual can be audited numerically. The calculation-detail table provides each intermediate amount, formula, and result in sequence. After changing any input, both sections update immediately.

Use the Excel download to preserve the current scenario. The workbook includes summary, input, breakdown, calculation-detail, and notes sheets. Because it is generated from the current state, change an assumption first and then download to capture that exact version.

What mistakes should be avoided?

• Do not mix retail selling prices with inventory cost values.
• Do not combine amounts calculated under different cost-flow methods.
• Do not treat purchases as net purchases without deducting returns, allowances, and discounts when applicable.
• Do not interpret turnover in isolation from seasonality, product mix, lead times, and service-level targets.
• Do not use the analytical reconciliation as proof that physical quantities exist; periodic counts and record controls remain important.

For operating practice rather than accounting measurement, the U.S. Small Business Administration’s business management resources can help place inventory controls within a broader management system.