Get the latest from
Eshopbox

Enter email to subscribe to our newsletter
Thank you for subscribing to Eshopbox newsletter
Oops! Something went wrong while submitting the form.
Closing stock - Ecommerce metric refresher
Ecommerce metrics

Closing stock - Ecommerce metric refresher

Yukta Anand
December 27, 2022
5
mins read

Key Performance Indicators (KPIs) are the metrics used to measure the performance of a business. Similarly, ecommerce metrics are the KPIs that can help online businesses evaluate their performance, set benchmarks, and take corrective measures to steer the business in the right direction.

In this ecommerce metric refresher, you will learn what is closing stock, how to calculate closing stock, why businesses should calculate closing stock, the benefits of decreasing closing stock, and the strategies to decrease closing stock.

What is closing stock?

Closing stock is an ecommerce metric that refers to the unsold inventory with a seller at any given time period. Closing stock can be calculated for any time period (monthly, quarterly, half-yearly, yearly) and is also referred to as ending inventory or closing inventory.

The following illustration shows the closing stock formula:

Let's see how to calculate closing stock with an example,

The value of your beginning inventory at the start of the quarter= Rs.2,00,000

Inventory purchased over the course of the quarter= Rs.1,50,000

Cost of Goods Sold (COGS)= Rs.1,70,000

Therefore, Closing stock = 2,00,000 + 1,50,000- 1,70,000= Rs.1,80,000

Note: The lower your closing stock, the higher your sales for that time period. Also, a lower closing stock will allow you to stock up on fresher inventory and reduce the chances of it becoming obsolete.

What are the methods of calculating closing stock?

The simplest way to calculate closing stock is to do a physical inventory count. However, manually counting inventory can be cumbersome for ecommerce sellers maintaining high levels of inventory in multiple ecommerce warehouses. You can use specific formulas to calculate closing stock easily.

It is advisable to choose one method of calculating closing stock and use it consistently to ensure minimum discrepancies. Let’s have a look at how closing stock can be calculated:

1. First In First Out (FIFO)

The first method of calculating closing stock is FIFO; herein, it is assumed that the inventory is sold in the order in which it was obtained. In FIFO, inventory bought first is sold first; thus, older inventory is counted in the Cost of Goods Sold (COGS), and newer inventory becomes the closing stock.

2. Last In First Out (LIFO)

In this method, inventory that is acquired later is sold first. The LIFO is prominently used in the case of perishable inventory. Herein, the earlier inventory becomes the closing stock, and the later inventory is calculated as COGS.

3. Weighted Average Cost (WAC)

The Weighted Average Cost (WAC) method divides the total cost of acquiring all inventory (earlier or later) by the total number of items. This gives an average of the cost of inventory acquired. The WAC method is a highly straightforward and beneficial method for ecommerce brands selling identical products.

Why should businesses calculate closing stock?

All ecommerce sellers would want to know how much inventory they could sell or not, and closing stock is how they can do so. Ecommerce businesses should calculate closing stock for the following reasons:

  • It helps match recorded inventory levels with actual inventory levels to ensure there is no accounting error, theft, or inventory loss.
  • Closing stock aids in forecasting and planning, such as calculating the prices of products.
  • Useful in calculating required inventory levels to prevent stock-outs or excess stock situations.
  • Helps calculate the net income generated during a given accounting period.

Benefits of decreasing closing stock

1. Higher sales

A lower amount of closing stock means that you could sell more and generate more revenue during a given time period.

2. Lower operational costs

By decreasing closing stock, ecommerce sellers can reduce the costs of maintaining and storing inventory. Moreover, you would need less labour to handle the inventory.

3. Lesser obsolete inventory and waste

If your closing stock is low, you can purchase or manufacture fresher inventory, thus reducing the chances of inventory becoming obsolete. Moreover, unused inventory can become waste.

How to reduce closing stock?

Here are some strategies you can use to reduce closing stock:

1. Calculate consumer demand

Forecasting consumer demand can give you an idea about the appropriate amount of inventory you should order. This helps you stock up on inventory such that inventory is not so high that it becomes obsolete and not so low that you cannot fulfil orders on time. Ecommerce sellers can use historical sales data and Inventory Management Systems (IMS) to calculate consumer demand.

2. Automate replenishment

Maintaining sufficient inventory levels is a must for ecommerce sellers, and for that, automating inventory replenishment is key. Automating your replenishment processes can help you order inventory at the right time because if ordered too early, it becomes outdated, and if ordered too late, orders cannot be processed on time. Automation also helps reduce errors and maximise efficiency.

3. Sell on multiple sales channels

By selling on multiple sales channels like Amazon, Flipkart, and Meesho, ecommerce brands can tap into a wider customer base. Thus, increasing sales, conversion rates, product visibility, and sales velocity.

Eshopbox’s integration with sales channels
Eshopbox’s integration with sales channels

4. Use strategies to boost sales

Ecommerce sellers can take steps to boost ecommerce sales as more sales mean lower closing stock. Some strategies to boost sales are:

Promotional sale poster by Nike
Promotional sale poster by Nike

Bottom line

Inventory is an important asset for ecommerce businesses, but if left unsold for too long, it can become a burden. Closing stock is a critical inventory metric that can help ecommerce sellers maintain optimum inventory levels and avoid the risk of stock-outs or excess stock to maximise operational efficiency.

Connect with our fulfilment expert today.

Talk to sales

Related Articles

Ecommerce metrics

On-time delivery: Unveiling the secrets to meeting customer expectations

Learn what is on-time delivery, the challenges of providing on-time delivery, how you can overcome them, and how you can measure the on-time delivery rate.
Suraj Verma, Eshopbox
June 16, 2023
Ecommerce metrics

Top 10 warehouse KPIs ecommerce businesses must track

Learn what is meant by warehouse KPIs and how they can serve as a guidepost to help you measure your warehouse operations to drive better efficiency and streamline order fulfilment.
Versha Kamwal, Eshopbox
November 19, 2022
Ecommerce metrics

Top 10 Key Performance Indicators (KPIs) for ecommerce businesses

Learn what is meant by key performance indicators and how they can help you assess your business performance and initiate improvements to achieve your business goals.
Versha Kamwal, Eshopbox
April 29, 2022

Get the latest from Eshopbox

Enter email to subscribe to our newsletter
Thank you for subscribing to Eshopbox newsletter
Oops! Something went wrong while submitting the form.
Eshopbox

Get actionable insights straight in your inbox!

Sign up for our mailing list and we'll send you latest updates and tutorials about ecommerce.