How to create an Inventory Management System [using Excel] in 2021

If you would like to create your own Inventory Management system using Excel spreadsheets then this short video tutorial will show you how.

The Inventory Management spreadsheet will use many of Excels functions and commands, including:

Use of Drop Down boxes to select data
Use of the SUMIF command
IF Statements to isolate and select data
The VLOOKUP command
We also introduce the CONCATENATE and MID commands

The Inventory Management spreadsheet will record Inventory transactions and will monitor Inventory Levels, Inventory Valuations and Product Line profitability.

As usual I will show you how to obtain a copy of the completed template at the end of the video.

If you need any help with the commands or functions I have used, then please leave me a comment.

I hope you enjoy watching.

Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks

You can also visit our websites at:

Or our Social channels:

#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting

[abdiaziizjackwar]

I love your lessons
Cuz they support me a lott various jobs and projects

[ivymancia]

Hello, this video has been very helpful! Could you also assist me with including the daily, monthly, and yearly sales and profit calculations?

[somukienibilly]

Thanks for the video. It is very informative. I followed along and was able to create my very own inventory table! Many thanks

[nurudeenabdullateef]

Thanks for sharing. I created my own Inventory Management on Excel after watching this video. Please share Payroll Account in Excel.

[gazmills]

great video. i have made the excel while following this video. it works well i just need to add a stock amendment type to it and not sure how to get it all talking any pointer?

[Mirzaiiui]

hi Mr. s
how are you, thank you for your giving us the best knowledge I am from Pakistan, and I have a problem, there are a lot of videos for stock inventory, but I never find Stock inventory for manufacturing units, From raw materials to finish Goods, For example, I have 3 employees I am giving them raw material and they are giving me finish product how can we deduct raw material by finish goods when they give it back, and how to maintain my stock inventory left with my employee and in my warehouse hope you will resolve my issue i am much needed this time

[andyg-lz]

is it possible to enable barcode reading for both receiving and selling ?

[shaniquebrady]

@mr.spreadsheet I'm for some reason not able to get the formula correct for the purchase & sales column. For sales it's not showing the - minus sign

[kendragriffin]

Thanks for the informative video! Why is profit calculated that way?

[jigsshah]

Hi, Thanks for teaching me the Inventory System on Excel but can you please share the video for same inventory system Excel. I want to create every think in different sheets, so want to know how the formula changes

[ebriuno]

Thanks for this tutorial.
I have a question, though not specifically about this video.

I have a list of over 1300 products. The product names have 3 to 6 words, and some having sizes (e.g 3 Strap Italian Loafer Grey 44; Double Breasted Slimfit Suit Black).
I want to generate SKU Codes for these products using the first letter in each word that forms the product name and the size (if any).

IS THERE A WAY I CAN EXTRACT THESE FIRST LETTER OF RACH WORD AND THE SIZE (E.G 44 ABOVE) WITHOUT HAVING TO DO IT MANUALLY??

[milenaserrato]

Do I need to have a inventory sheet and a inventory management or just one of them?

[chicobing]

I work for a shelter and have been asked to to create a donation tracking SS. It doesn't need to have values just item and quantity on hand as well as item and quantity being donated to guest. It need to be able to do a running daily total in and out as well as a warning of some kind when items get to a specific quantity level so we know what is needed from our donors.
I did what I knew how to do with excel which was created a separate sheet for each bin and items in bins as well as in and out, after 108 sheets were created I realized that I couldn't do a running daily total.
So many videos later and still no resolution. I found your videos and they are great, so is it possible to use the sheets I've already created and have each sheet do a running in and out total or do I have to start all over from scratch? Please help, too many wasted hours. Thank you in advance.

[zanderhuynh]

I love your all videos . However, my single product is combine of multiple item, various codes. Could you please make video how to code that! Thanks

[empirecloset]

I have a question!?! From 7:30 to 7:46. I have tried to put in the formula but it doesn't work. Is there another way?

[TheDeliveryOnline]

Is this for like 1 set time period? How do you record daily sales and purchases so that it updates inventory.

[mohammedfahad]

looks good but you are not taking into consideration the beginning stock ?!

[kennethporras]

Hi i would like to ask what is the purpose of lead time?

[timothykimble]

Love this! Could I get a copy of the spreadsheet.

[phantomsellers]

Are major revisions required for those of us that us Numbers?