Inventory control is about discipline and data. Spreadsheets are one of the most popular ways to manage inventory for early stage retail businesses. We thought we’ll share a simple inventory management spreadsheet template for you to understand and manage your stock better. Below is a screenshot of what this data will look like. There is also a glossary sheet to better understand the terms.

Inventory Spreadsheet

Why did we put this up? Aren’t we an inventory management software? Well, yes. But Primaseller isn’t just a plain spreadsheet. It’s about live tracking inventory based on orders from all channels and updating all channels with the available inventory. It also supports this across multiple locations. Feel free to check out more about us here.

But till then, if your business is at a very early stage, this file will work just fine to help you get started.

Download The Free Inventory Management Spreadsheet Now!

How to manage Inventory using Excel?

Once you have downloaded the template, add all your products along with current inventory into the excel.

The fields are:

SKU Code (Stock Keeping Unit Code) This is the unique code with which you identify your product – It should be unique across parameters like color, size, shape etc.
Name This is the Name by which you identify the product
Supplier Name Name of the Preferred Supplier of the product
UOM (Unit of Measurement) – This is how you quantify the product – Is it by pieces, pounds, gallons, liters, dozen – Could be as per the typical selling unit or packaging
Listing Price This is the price on the label without any discounts – Also known as MRP/MSRP in some countries
Selling Price Selling price is the actual price at which the product is sold – this does not include, however, transaction level discounts that you may give on particular orders
Cost Price This is the cost at which you purchased the product
Stock Quantity Actual Quantity in hand
Stock Value This is a formula – Stock Quantity * Cost price – as you add rows, you need to drag the formula down in excel
Re-order Level This is the min quantity at which you will raise a purchase order to your supplier for replenishment
Need to Re-order This is a formula based on Stock Quantity and Re-Order Levels  – as you add rows, you need to drag the formula down in excel

Once you have updated all your SKUs in the excel, every time there is an order, deduct the Stock Quantity accordingly and when there is a Purchase, increase the stock quantity.

If this spreadsheet is too simple for your needs, we recommend you check out Primaseller’s Inventory Management Software that you can evaluate for your business.

Subscribe to Primaseller's Retail Blog
Want to read more articles like this?
Subscribe to our blog and get regular insights on best retail practices
Subscribe to Primaseller's Retail Blog
Thank you for subscribing to our newsletter. Prepare your inbox for awesomeness!
You can always Unsubscribe to the newsletter from your inbox. But why would you?

Premna is the Digital Marketing Analyst at Primaseller. She is an avid reader and an adrenaline junkie. When she's not working, you can find her exploring food joints, watching movies or TV shows, or working out.