We speak Spanish and Mandarin to better assist you !! We speak Spanish and Mandarin to better assist you !!
We speak Spanish and Mandarin to better 
assist you !!
We speak Spanish and Mandarin to better 
assist you !!
/
Picture of Ana Singh

Ana Singh

Lead Coordinator

Managing stock requires more than knowing how many products enter or leave a warehouse. In addition, businesses must determine the financial value of goods remaining after a reporting period. The ending inventory formula provides a way to calculate this amount using beginning inventory, purchases and cost of goods sold. As a result, this figure helps accounting teams prepare financial statements, assess inventory value and calculate gross profit. Additionally, it gives warehouse managers a useful reference when reviewing stock records and investigating differences between recorded and physical quantities. However, different costing approaches, such as FIFO, LIFO and weighted average, can produce different closing values. Understanding these methods helps businesses maintain consistent inventory accounting and make better decisions about purchasing, storage and stock management.

A warehouse may contain thousands of products, but the quantity on its shelves does not tell the complete financial story. Some goods arrived recently, others were purchased months ago, and many have already been dispatched to customers. Therefore, at the end of an accounting period, the business needs to establish the value of everything it still owns.

This is the purpose of the ending inventory formula. It connects the opening stock balance with purchases and the cost of products sold during the period.

The calculation has a direct connection with financial reporting. It determines the inventory amount shown on the balance sheet and helps establish the cost of goods sold. Both figures influence the financial results presented by a business.

For retailers, distributors, ecommerce companies and third-party logistics providers, the calculation also supports operational control. Accurate stock figures make it easier to investigate discrepancies, review purchasing requirements and understand how much capital remains tied up in products.

What Is Ending Inventory?

Ending inventory is the recorded cost value of goods a business owns at the close of an accounting period. It includes eligible products that remain unsold or otherwise remain part of inventory at that date.

Depending on the reporting cycle, the period could cover a month, quarter or full financial year. In this way, the closing figure provides a financial snapshot of the company’s remaining stock.

Consider a furniture retailer that starts the month with 120 chairs. It receives another 80 chairs from suppliers and sells 150 during the month. If there are no other stock movements, 50 chairs remain.

Those 50 chairs represent the remaining quantity. However, their financial value depends on the costs assigned to them under the company’s inventory valuation method.

The ending inventory formula helps determine this financial value by using the relevant accounting figures.

Why Does a Business Need an Ending Inventory Figure?

Moreover, a closing stock balance serves several practical purposes.

  • It identifies the value of products that remain available or held in inventory.

  • It provides information for balance sheet preparation.

  • It helps accountants calculate the cost of goods sold.

  • It supports purchasing and replenishment decisions.

  • It helps identify differences between physical and recorded stock.

  • It provides a reference for reviewing inventory performance.

For example, a distributor may discover that its recorded stock value is higher than expected. A review could reveal damaged products, unrecorded dispatches or incorrect receiving entries.

Therefore, tracking remaining inventory is useful for both accounting and warehouse operations.

Difference Between Stock Quantity and Stock Value

These terms describe two separate measurements.

While stock quantity tells a business how many units remain, stock value expresses the financial cost assigned to those units.

For example, 100 products purchased at $8 each have a total cost of $800. If the same products were purchased at $10 each, the quantity would remain unchanged, but their total cost would become $1,000.

Therefore, understanding this distinction is essential when preparing accurate inventory records.

What Is the Ending Inventory Formula?

Businesses can calculate closing stock value using a straightforward accounting equation.

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

To calculate the closing value, businesses start with the inventory available at the beginning of the period. They then add eligible purchases and subtract the cost assigned to goods sold.

The result represents the calculated value of remaining inventory before any additional adjustments required by the accounting method.

Beginning Inventory

Beginning inventory is the cost value of stock carried forward from the previous accounting period.

For example, a wholesale company closes March with inventory worth $24,000. Consequently, that amount normally becomes its opening inventory for April.

This figure should agree with the previous period’s verified closing balance, including any approved corrections.

Purchases

Purchases represent the cost of additional goods acquired during the reporting period.

In other words, the figure should reflect eligible inventory acquisition costs. Depending on the accounting treatment, businesses may need to account for supplier returns, purchase discounts and transportation costs.

For example, a distributor receives products costing $9,000 during April. Consequently, these purchases increase the inventory available for sale.

However, the calculation must use purchase costs rather than the prices customers pay.

Cost of Goods Sold

COGS represents the inventory cost assigned to products sold during the accounting period.

In contrast to sales revenue, COGS measures what the business paid or incurred to acquire the goods sold.

Suppose a retailer sells a table for $450. Its original inventory cost was $280. The COGS for that sale is $280, not $450.

After collecting these figures, businesses can use the ending inventory formula to establish the remaining stock value.

How Is Ending Inventory Calculated?

First, a reliable ending inventory calculation begins with accurate accounting records. Businesses should follow a consistent process rather than estimating their remaining stock.

Step 1: Check the Opening Stock Balance

Start with the verified inventory value at the beginning of the reporting period.

Check the previous accounting records to confirm that the opening figure is correct.

For example, a distribution company starts September with inventory valued at $18,500.

Step 2: Review All Inventory Purchases

To begin with, collect supplier invoices, receiving documents and purchase records.

Calculate the eligible cost of additional products acquired during September. Remove applicable supplier returns and discounts where required.

Assume the company purchases another $11,500 of inventory.

Step 3: Establish the Cost of Goods Sold

Next, review sales transactions and determine the inventory cost associated with products sold.

The business must apply its selected costing method when assigning costs to outgoing units.

Suppose the company’s recorded COGS for September is $13,000.

Step 4: Perform the Calculation

Add the opening inventory and purchases. Subtract the cost of goods sold.

Ending Inventory = $18,500 + $11,500 – $13,000

Ending Inventory = $17,000

Step 5: Review the Result Against Stock Records

The calculated amount should be reviewed alongside warehouse information.

Additionally, review receiving records, dispatch notes, returns and physical stock counts. If any unexplained differences appear, investigate them before finalising the accounts.

The ending inventory formula provides a calculated financial balance. Physical verification is still necessary because accounting records may contain errors or incomplete transactions.

Practical Ending Inventory Calculation Example

Consider a business that distributes office supplies to retailers and corporate customers.

At the beginning of November, its inventory has a recorded value of $14,000. During the month, the company receives additional stock costing $9,000. Its accounting records show $11,000 in COGS.

Therefore, the business must establish the value of products remaining at the end of November.

The available figures are:

  • Beginning inventory: $14,000

  • Purchases: $9,000

  • Cost of goods sold: $11,000

Using the ending inventory formula:

Ending Inventory = Beginning Inventory + Purchases – COGS

Ending Inventory = $14,000 + $9,000 – $11,000

Ending Inventory = $12,000

The company finishes November with inventory valued at $12,000.

This amount represents the cost value assigned to its remaining stock. It does not represent the total revenue the company could generate by selling those products.

The accounting department can use the result when preparing financial statements. Meanwhile, the warehouse team can compare it with physical stock reports to check whether recorded quantities match actual holdings.

Different Inventory Valuation Methods

The method used to assign costs to inventory affects the final closing value.

Businesses must select an appropriate costing approach and apply it consistently under their relevant accounting standards.

Three commonly discussed methods are FIFO, LIFO and weighted average cost.

FIFO: First In, First Out

FIFO assumes that the earliest inventory costs are assigned to goods sold first.

Consequently, the remaining inventory usually contains costs from more recent purchases.

Consider a company that buys:

  • 100 units at $8 per unit.

  • Another 100 units at $11 per unit.

The company sells 120 units during the period.

Under FIFO, COGS is calculated as follows:

100 × $8 = $800

20 × $11 = $220

Total COGS = $1,020

The remaining 80 units carry the newer purchase cost.

Ending inventory = 80 × $11 = $880.

This approach can be useful for businesses handling products that need regular stock rotation. However, FIFO is an accounting cost assumption and does not always describe the actual physical movement of goods.

LIFO: Last In, First Out

LIFO assumes that the latest inventory costs are assigned to goods sold first.

As a result, older purchase costs remain in the closing inventory balance.

Using the previous example, the company sells 120 units.

Under LIFO:

100 × $11 = $1,100

20 × $8 = $160

Total COGS = $1,260

The remaining 80 units have an assigned cost of $8 each.

Ending inventory = 80 × $8 = $640.

However, businesses cannot use this method everywhere. IFRS prohibits LIFO for inventory costing, while US GAAP permits it subject to applicable requirements.

Companies must therefore consider the accounting framework and jurisdiction governing their financial statements.

Weighted Average Cost

The weighted average method combines the cost of available units and calculates one average unit cost.

This average is then applied to the inventory sold and remaining.

Using the same purchases:

Total inventory cost = $800 + $1,100 = $1,900

Total available units = 200

Average cost = $1,900 ÷ 200 = $9.50 per unit.

After selling 120 units, 80 remain.

Ending inventory = 80 × $9.50 = $760.

This method is useful when businesses manage large quantities of similar goods. Depending on the inventory system, companies may calculate a periodic or moving weighted average.

Each valuation method affects both ending inventory and COGS. For this reason, businesses should avoid changing methods without considering applicable accounting requirements.

Why Is Ending Inventory Important in Inventory Accounting?

Inventory is an asset that represents money invested in products a business has not yet sold. Its recorded value influences several areas of financial reporting.

The ending inventory formula helps establish this amount at the reporting date.

First, closing inventory appears as a current asset on the balance sheet, subject to applicable valuation rules. This gives financial statement users information about the resources held by the company.

Second, it contributes to the calculation of COGS. Since COGS is deducted from sales revenue to determine gross profit, an incorrect inventory figure can affect reported profitability.

Furthermore, this figure supports internal financial reviews. Accountants can compare inventory balances across reporting periods and investigate unusual changes.

For warehouse managers, the same information can help identify slow-moving products, unexpected stock reductions and possible recording errors.

Accurate inventory accounting therefore connects financial control with everyday stock management.

How Does Ending Inventory Affect COGS and Profit?

The closing inventory balance directly influences the amount of COGS reported for an accounting period.

The connection between ending inventory and COGS can be calculated using the following formula:

COGS = Beginning Inventory + Purchases – Ending Inventory

Consider a retailer with these figures:

Beginning Inventory = $16,000

Purchases = $7,000

Ending Inventory = $8,000

COGS = $16,000 + $7,000 – $8,000

COGS = $15,000

Now assume the closing stock value is incorrectly recorded as $7,000.

The revised calculation becomes:

COGS = $16,000 + $7,000 – $7,000

COGS = $16,000

The lower inventory figure increases COGS by $1,000.

If sales revenue stays unchanged, gross profit falls by the same amount.

The reverse also applies. An overstated inventory balance reduces reported COGS and increases gross profit.

However, a higher accounting value does not create additional sales or cash. It only changes the financial figures presented in the accounts.

Factors That Can Change Ending Inventory

In practice, inventory changes throughout an accounting period. Several business activities can therefore affect the final stock balance.

New Purchases

Additional goods increase the inventory available for sale. Businesses must record the correct quantities, costs and transaction dates.

Sales and Dispatches

When customers purchase products, the associated inventory cost moves into COGS. Warehouse dispatch records should match the corresponding sales transactions.

Customer Returns

A returned product may re-enter inventory if the business regains ownership and the item remains suitable for resale.

Damaged or unsellable returns require separate consideration.

Supplier Returns

Products sent back to suppliers generally reduce eligible purchases or inventory costs. Missing these entries can overstate the closing balance.

Damaged and Obsolete Products

Goods that become damaged, expired or obsolete may lose part of their recoverable value.

Under IAS 2, inventory is generally measured at the lower of cost and net realisable value.

Missing Stock and Inventory Shrinkage

Theft, handling losses, misplaced products and unrecorded movements can create differences between recorded and physical stock.

Businesses should investigate these issues and record appropriate adjustments.

Changes in Cost

Supplier price changes can affect the value assigned to remaining units. The impact depends on the selected inventory valuation method.

Ending Inventory vs Beginning Inventory

Although both figures describe the value of stock at a particular point in time, they relate to different stages of the accounting cycle.

ComparisonBeginning InventoryEnding Inventory
DefinitionValue of stock at the start of a periodValue of stock at the end of a period
Accounting roleOpening balanceClosing balance
TimingFirst day of the reporting periodFinal day of the reporting period
CalculationCarried forward from the previous closing balanceDetermined after accounting for stock activity
Future useUsed in the current period’s calculationsNormally carried into the next period

For example, a retailer records $13,000 in closing inventory on 31 December.

On 1 January, that amount normally becomes the opening inventory for the new financial year.

This connection maintains continuity between accounting periods and prevents businesses from treating each reporting period as an unrelated set of transactions.

How to Calculate Ending Inventory in a Warehouse

Warehouse accuracy has a direct influence on the reliability of inventory accounting.

However, even a correctly applied ending inventory formula can produce misleading results if receiving, picking or dispatch records contain errors.

Businesses should establish clear procedures for tracking physical stock.

Carry Out Physical Stock Counts

Count products at scheduled intervals and compare actual quantities with recorded balances.

Cycle counting can help large warehouses check selected product categories throughout the year instead of relying only on one annual count.

Record Every Goods Receipt

When suppliers deliver products, warehouse staff should verify quantities against purchase orders and delivery documents.

Record shortages, excess deliveries and damaged goods before updating available stock.

Monitor Outgoing Orders

Dispatch teams should update inventory records when goods leave the warehouse.

This reduces the risk of showing unavailable products as ready for sale.

Track Returns and Damaged Goods

Returned products should be inspected and assigned the correct stock status.

Separate records help distinguish resaleable goods from damaged, quarantined or unsellable items.

Reconcile Physical and System Records

Compare actual quantities with inventory management system reports.

Investigate differences and document approved adjustments.

These processes support accurate warehouse inventory records and help businesses maintain better stock management across multiple storage locations.

Common Mistakes When Calculating Ending Inventory

Several mistakes can make an inventory calculation unreliable.

  • Using an incorrect opening balance: Always verify the previous period’s closing figures before starting a new calculation.

  • Leaving out purchases: Check supplier invoices and receiving documents to ensure all eligible purchases appear in the correct period.

  • Confusing sales revenue with COGS: Use the product’s inventory cost rather than its selling price.

  • Ignoring damaged products: Review unsellable and obsolete stock when assessing inventory value.

  • Counting products twice: Maintain clear warehouse location records to avoid duplicate quantities.

  • Missing customer returns: Review return transactions and determine whether products qualify for inclusion in inventory.

  • Applying inconsistent valuation methods: Follow an appropriate costing policy and maintain consistency.

  • Ignoring warehouse discrepancies: Reconcile system records with physical counts before closing the accounts.

For this reason, preventing these mistakes requires proper coordination between purchasing, warehouse and accounting teams.

How Businesses Can Maintain Accurate Ending Inventory Records

To maintain reliable inventory records, businesses must follow consistent procedures across their operations.

The following practices can help improve reliability.

Update Transactions Promptly

Record purchases, sales, returns and transfers when they occur. Delayed entries can create differences between actual stock and recorded quantities.

Schedule Regular Stock Counts

Use physical counts to check inventory accuracy. Investigate differences rather than making unexplained adjustments.

Maintain Supporting Documents

Keep purchase invoices, delivery confirmations, dispatch records and return documents. These records provide evidence for inventory movements.

Separate Damaged and Returned Stock

Use appropriate inventory categories for goods that cannot be sold immediately. This helps prevent incorrect valuation.

Use Suitable Inventory Software

Inventory management systems can organise stock quantities, transaction records and warehouse locations.

Nevertheless, software cannot correct inaccurate information entered by employees. Therefore, staff training and proper procedures remain essential.

Coordinate Warehouse and Accounting Teams

Both departments should use consistent transaction dates, product records and inventory values.

Regular reconciliation helps identify problems before financial reporting deadlines.

Apply a Consistent Costing Policy

Choose an inventory valuation method that complies with the applicable accounting framework. Apply it consistently and document any permitted changes.

Conclusion

Knowing the value of remaining stock helps businesses maintain control over their finances and warehouse operations. The ending inventory formula provides a practical way to connect opening stock, purchases and the cost of goods sold.

Nevertheless, achieving an accurate result requires more than mathematical calculations. Businesses must also maintain reliable purchase records, apply correct costing methods, conduct physical stock checks and update transactions on time.

When accounting and warehouse teams follow consistent procedures, they can maintain dependable inventory records, improve stock management and prepare more accurate financial reports.

Fast and Reliable Fulfillment for Growing Brands and Large-Scale Retailers

Frequently Asked Questions

The ending inventory formula is Beginning Inventory + Purchases - Cost of Goods Sold (COGS). It determines the recorded cost value of unsold products at the end of an accounting period. Businesses use it when preparing financial statements and reviewing stock balances.

Add the beginning inventory value to eligible purchases made during the reporting period. Then subtract the cost of goods sold. Review the result against physical stock records and account for any required adjustments involving returns, damage or inventory valuation.

The three components are beginning inventory, purchases and cost of goods sold. Beginning inventory is the opening stock value. Purchases represent additional inventory acquired during the period. COGS represents the assigned cost of products sold.

Yes. Ending inventory and closing stock generally describe the same accounting concept. Both refer to the value of goods remaining at the end of a reporting period. The terms are commonly used in retail, warehousing and financial accounting.

Ending inventory is subtracted when calculating COGS. Therefore, a higher closing inventory value produces lower COGS, assuming other figures remain unchanged. A lower closing value produces higher COGS and can reduce reported gross profit.

It establishes the inventory value reported as an asset on the balance sheet. It also helps calculate COGS and gross profit. Reliable closing figures give businesses a clearer view of their financial position and the value of unsold products.

An incorrect figure can distort the balance sheet, COGS and gross profit. Overstated inventory generally makes COGS appear lower, while understated inventory makes it appear higher. The error may also affect the following accounting period's opening balance.

FIFO, LIFO and weighted average cost are common inventory costing methods. They assign different costs to sold and remaining products. However, the permitted methods depend on the accounting standards governing the business. IFRS, for example, does not permit LIFO.

FIFO assigns the oldest inventory costs to goods sold first. Remaining products therefore generally carry more recent purchase costs. When supplier prices increase, this method often produces a higher closing inventory value than LIFO.

Businesses generally determine closing inventory for monthly, quarterly and annual financial reporting. However, warehouses with frequent stock movements may monitor inventory daily. Regular cycle counts also help identify discrepancies between formal reporting periods.

Appreciation

0

guest
0 Comments
Oldest
Newest Most Voted

Our Blogs

Cargo vs Shipment: Understanding the Difference in...
Consider a manufacturer sending 500 boxes of packaged products to a retail distributi...
What Is Ending Inventory Formula and How Is Ending...
A warehouse may contain thousands of products, but the quantity on its shelves does n...
What Is Omnichannel Fulfillment and How Does It Im...
A customer orders a pair of headphones from an online store. At almost the same time,...

Special Services

We are a full-service 3PL offering complete logistics solutions with our own assets.

Warehousing Solutions

Truckload / LTL Solutions