Beginning Inventory Calculator

Start of Period Inventory Calculator

Beginning Inventory Formula

Formula

\[ \text{Beginning Inventory} = \text{Ending Inventory} + \text{Cost of Goods Sold} - \text{Purchases} \]

Where:

$\text{Ending Inventory}$ — the value of stock remaining at the close of the period ($)
$\text{Cost of Goods Sold}$ (COGS) — the direct costs of the goods sold during the period ($)
\text{Purchases}\) — the cost of inventory purchased during the period ($)

The formula is simply the standard COGS equation rearranged. Since $ \text{COGS} = \text{Beginning Inventory} + \text{Purchases} - \text{Ending Inventory} $, solving for beginning inventory gives the expression above.

Beginning Inventory – Calculation Example

Example: a retailer ends the quarter with $35,000 of inventory on hand. During the quarter, it recorded $90,000 in cost of goods sold and purchased $60,000 of new stock.

\[ \text{Beginning Inventory} = 35{,}000 + 90{,}000 - 60{,}000 \]

\[ \text{Beginning Inventory} = 65{,}000 \]

Result: the beginning inventory was $65,000.

How to Use the Calculator

Enter the Ending inventory — the value of stock remaining at the end of the accounting period, in dollars.
Enter the Cost of goods sold (COGS) — the total direct cost of the goods your business sold during the period.
Enter the Purchases during the period — the cost of all inventory you bought in that period.
Read the Beginning Inventory result, which shows the estimated value of your stock at the start of the period.

What Is Beginning Inventory?

Beginning inventory (also called opening inventory) is the value of goods a business has in stock at the start of an accounting period — a month, quarter, or year. It equals the ending inventory of the previous period, so the two figures form a continuous chain through your financial records. On the balance sheet it is classified as a current asset and typically sits within the inventory line of current assets.

Beginning inventory matters because it feeds directly into two of the most important figures in accounting: cost of goods sold and gross profit. If the opening inventory figure is wrong, COGS will be wrong, and so will gross profit, taxable income, and the value of assets reported to lenders or investors. It is also a required figure in periodic inventory systems, where physical counts are done only at the end of each period and intermediate figures are derived by calculation rather than continuous tracking.

In practice, the formula above is most often used to reconstruct a missing opening balance — for example, when records from the start of a period were lost, when an auditor needs to verify reported figures, or when you want to check the consistency of your inventory accounting. A negative result is a red flag: it usually means one of the inputs is wrong, since a business cannot hold less than zero stock.

Interpreting the Result

The number you get represents the dollar value (at cost, not retail price) of the goods available for sale at the start of the period, before any new purchases. Compare it with the ending inventory to see the direction of stock movement: a beginning inventory much higher than ending inventory suggests you sold through stock faster than you replaced it, while the opposite suggests accumulating stock that ties up cash.

Beginning inventory also pairs with other metrics. Combined with average inventory, it feeds into days in inventory, which measures how quickly stock turns over. If you want to optimize how much you reorder and when, the economic order quantity calculator can help find the cost-efficient order size.

Assumptions and Limitations

All figures must be at cost, not retail price. Mixing cost and selling prices will distort the result.
Purchases should include all inventory bought in the period — freight-in and related costs are usually added to inventory cost, while purchase discounts reduce it.
The formula assumes a periodic inventory system. Under a perpetual system, beginning inventory is tracked directly and rarely needs to be reconstructed.
COGS must cover the same period as purchases and ending inventory, otherwise the calculation is meaningless.
Inventory valuation method matters. FIFO, LIFO, and weighted average cost assign different values to the same physical stock, so keep the method consistent across periods.

Related Calculators

To work in the other direction, the ending inventory calculator finds closing stock from the opening balance, purchases, and COGS. If you know inventory levels but are missing costs, the cost of goods sold calculator completes the same equation from a different angle, and the inventory stock calculator helps track overall stock levels.

Frequently Asked Questions

How do I calculate beginning inventory by hand?

Add ending inventory to cost of goods sold, then subtract purchases made during the period: $ \text{Beginning Inventory} = \text{Ending Inventory} + \text{COGS} - \text{Purchases} $. For example, with ending inventory of $12,000, COGS of $40,000, and purchases of $30,000, the beginning inventory is $ 12{,}000 + 40{,}000 - 30{,}000 = 22{,}000 $ dollars. The formula is just the standard COGS equation rearranged.

Why does my beginning inventory not match last period's ending inventory?

In a consistent accounting system, beginning inventory must equal the prior period's ending inventory. If the two differ, look for a change in valuation method (for example switching from FIFO to weighted average cost), a bookkeeping error, unrecorded purchases or returns, or goods in transit counted in one period but not the other. A discrepancy almost always signals a data problem worth investigating before filing reports.

What does a negative beginning inventory result mean?

A negative result is a red flag, because a business cannot hold less than zero stock. It usually means one of the inputs is wrong: COGS may be overstated, purchases underreported (for example, freight-in or invoices received after period close were omitted), or figures from different periods were mixed. Reconcile each input against source documents before trusting the number.

Should purchases include freight, discounts, and returns?

Yes, purchases should reflect the full cost of inventory acquired. Add freight-in and other costs needed to get goods ready for sale, subtract purchase discounts and purchase returns and allowances. Using only invoice prices while ignoring these adjustments is one of the most common mistakes and can distort both beginning inventory and COGS.

Can I use this formula with retail prices instead of cost?

No. All three inputs — ending inventory, COGS, and purchases — must be valued at cost, not selling price. Mixing retail and cost values will produce a meaningless result. If your records only show retail values, convert them first using a cost-to-retail ratio, or use the retail inventory method to estimate cost before applying the formula.

Does FIFO or LIFO affect the beginning inventory calculation?

Yes. FIFO, LIFO, and weighted average cost assign different dollar values to the same physical stock, so your valuation method changes every input in the formula. The calculation itself works under any method, but you must apply one method consistently across periods. Switching methods mid-stream makes beginning and ending inventory figures incomparable and can require disclosure in financial statements.

How is beginning inventory used in other inventory metrics?

Beginning inventory feeds average inventory, usually computed as $ (\text{Beginning} + \text{Ending}) / 2 $, which in turn drives the inventory turnover ratio and days in inventory metrics. A higher-than-usual beginning inventory relative to sales can signal overstocking that ties up cash and increases holding costs, while an unusually low figure may suggest stockout risk.