Thanks a lot, i am an engineering professional and my boss wanted me to keep track of supplies, i searched numerous videos but i made excel sheet from scratch watching your video because of your clear instructions. Thank you so much for the video. I really appreciate your work brother. :)
i think this is perfect to keep tracking for current inventory , but how you keep track if the current stock is tali? inventory head tell their labor to count it everyday right and tali it ?
Learned so much!! Been wanting to learn Vlookup formulas for a while now, and your tutorial made it super easy to understand. Will definitely try to implement with my inventory logs. Thank you!!
Hello, Thank you for the video. It was 100% understandable. It is really acknowledged that you understand the needs of the analytics in the warehouse management system. Just as a perspective of costs, technology upgrades, and inflation, how could you summarize old stocks and new stock together, i.e. price changes every 6 months for some products and the sum of their actual prices? This is something I am really interested in as I deal with a big quantity of materials and also with a considerable time span from 0 to 2 years. I would love to hear from you. Thank You!
First thank you so much for this video. Second I have a question, if we want to change the Price of units on opening stock it doesn't change automatically on current status stock Units price. So how to make it automatically that if we change the price on units on opening stock it change on current status stock??
Hi Farhad, thanks for your question. Please note that a new tutorial is coming this week with inventory management system that will incorporate updated price changes of stock items. Please stay tuned. 😇
This a greate video thank you so much. It helped me a lot. But i have one question if you can please answer it. Isn't the "opening stock" the same as the "purchases/stock in". Because bothe of them indicate the stocks on hand right.
Hi sir, i would like to ask what if the stock in's price change or increase what should we record and it will mess up with the calculation. Can you please help
Hi, thank you for the details. Sir how can we make a printed document of all items for a particular month. For example no. of an item bought and sold in a month and the amount. Thank you
I really appreciate your help, thank you very much! On my excel I have Purchase & Sale column together. Purchase can be in cash & in Credit & also the same way Sale can be in cash & in Credit. Now I need to get total credit in purchase & total credit in Sale. The same to credit for sale. Can I do this with this function?? Or shall I send you please?
This is the simplest among all the videos i have seen. Fortunately u talked about Motor parts but as u may have seen that same product is made by different manufacturers n we need to keep stock of every other company & remembering code item of every stock is almost impossible. So kindly educate how to take two cells instead of one like product n company. Also let us educate how to get automatically average pricing if i purchase or sale same product at different prices.
I facing error... When i enter in linked purchase or sales table that time showing no change in current status purchase and sales table.. Only showing 0 ...what's the problem??
Thank you so much for this. I have 1 question though. Price per unit of buying and selling items may change with time as its not a constant...how do we show this on this system?
Hey Very good video but audio was not good to hear with speakers use headphone and one more thing if we dont have opening stock than we can also use vlookup function in the current stock status tab to automatically add item name unit price etc
Sir i have a curtain shop please guide me to maintain stock, i sell curtain and cloths both. (a)Gate curtain made 2.5m (b)windows curtain made 1.5m Suppose that:- 1. Cloths is 50Meters 2. 5pic of gate curtain sellout. 3. 3pic of window curtains sellout . 4. 5meters cloths is sellout. 5. 2 pic gate curtain is return. 1 - What is rest stock ? 2 - how much profit ? Pease make a video on this how to create sheen on this table.
All ok bro I have big doubt when you purchase item you enter this item abc company we are delivery like stock tracking Example Mobile opening stock 5pcs Then abc Customer need 10 PCs mobile Then you check stock report available qty 5 Then you purchase 5 PCs Then abc Customer cancel the order then 5pcs mobile goto store now total 10 stock no customer only stock Then abcd customer send order 15 PCs mobile then purchase 5pcs we have already 10 PCs now ready to deliver but customer hold the order Then other customer order 5 PCs mobile We are changing stock report show 15 PCs mobile but this waiting for delivery to customer so we are ordering new 5pcs
Sir, can you help me with an excel program to calculate consumption of raw material based on BOM of finished goods and also the cost of production. We will input the opening stock, purchases, consumption will be calculated based on BOM of finished goods. We need this urgently. Thank you.
Is there a way where I can monitor the in, out, stock, re-stock and stock value all at the same time on daily basis? Or is there a way that the sumifs function can be set on daily basis?
I made an inventory sheet based on this one. Thank you very much!.. Just one thing, Is there a way to restrict the input in stock out / sales if the current inventory is not sufficient?
You can use simply a "IF" function saying the sales should not cross the inventory limit. So that you may know when the purchases become insufficient for the inventory.
@@PraveenKumar-jp4sl would be a big help if you can give me a formula basing on your sheet shown in the video so I can pattern it to my sheet. cant seem to find the correct formula. Hoping you can help me out. Thanks so much!
HI MATE ! i need your help i create this template but my business keep bringing new stuff everyday and was wondering, how can i add new stock that is coming in to my business, whenever i try to add rows it does not allow me to do it and if i add it to the purchases table it does not appear in the current status of stock. thanks for your help
If I was to have 20 cells each with a different hire date what function would highlight each cell that the month occurred every year. For instance... I have these dates listed, 05/04/2021, 01/09/2021, 05/27/2021. For the dates of May the cell would be highlighted because the current month is may .
Hi Ashlen...please follow these steps 1. Select column in which you have dates 2. Go to Home Tab 3. Go to conditional formatting 4. Select "new rule" from conditional formatting 5. Select "use a formula to determine which cells to format" 6. Write following formula (in formula you need to use column number in whicb you have dates... I am using column J) =Month(J1) =Month(Today()) 7. From formar change format of cells the way you want them to highlighted ........ Please let me know if you understand otherwise i can give you my whatsapp no.
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
I've watched lots of videos on this subject but non explained it better as you did. Thank you very much.
This is the breakthrough for me
Thanks a lot, i am an engineering professional and my boss wanted me to keep track of supplies, i searched numerous videos but i made excel sheet from scratch watching your video because of your clear instructions. Thank you so much for the video. I really appreciate your work brother. :)
i think this is perfect to keep tracking for current inventory , but how you keep track if the current stock is tali?
inventory head tell their labor to count it everyday right and tali it ?
This tutorial is exactly what I've been looking for, thank you so much for taking the time to make it and explain it. I now need to give it a go.
Thanks so much for this great work
you have help me with employment
I had always needed this to complete my jobs
Learned so much!! Been wanting to learn Vlookup formulas for a while now, and your tutorial made it super easy to understand. Will definitely try to implement with my inventory logs. Thank you!!
Really appreciate this lecture of inventory management on excel
Wow. Just amazing. I was looking for this, will save so much trouble for me. Thank you boss!
exactly what i was looking for! Easy and precise. Perfect!! Thank you for making this video ❤️
Thanks.. I found the best Inventory management sheet as i want !! Thanks a lot
Sometimes, we've got a problem of credit, as, many times we've to give the things on credit....so is there a way to manage the credit part as well?
this was very helpful and easy to follow. you broke it down into bite sized bits instead of cramming the info at your audience :)
Amazing and truly helpful for my inventory. Thank you so much sir for sharing this video.
Thank you very much it was very useful, i have found it at the right time, thanks
Thank you very much. Very helpful and simple to understand.
Very helpful for my small business. Thanks for sharing!
Thanks for the video. It is very easy to understand and also very helpful. I refer to it often
I am facing a problem in the last range of closing stock the sum of sale is showing 0
What if we want to add an existing product with a different price ? than how we can manage the change in price while selling that item?
Thanks same I want to know that
This was amazing!! I learned so much. Thank you!!
Thanks a lot! This save me a lot of labour time key in data manually! 🤩
you save my timee, thank you so much for uploading this video!!
Great teacher. I'm using this for my business.
Hello,
Thank you for the video. It was 100% understandable. It is really acknowledged that you understand the needs of the analytics in the warehouse management system. Just as a perspective of costs, technology upgrades, and inflation, how could you summarize old stocks and new stock together, i.e. price changes every 6 months for some products and the sum of their actual prices? This is something I am really interested in as I deal with a big quantity of materials and also with a considerable time span from 0 to 2 years. I would love to hear from you. Thank You!
Shah sahb ap UAE mn wearhouse mn kam krty hn plz help me
How about same product but different price? Sometimes it happens
magnificent my friend..
Very good tutorial, really every step guided in very good manner
thank you! great video, following step by step make my own tracking sheet. subscribed
Thank you for this learning but I have a doubt, how to add a new item to existing stock ?
hi really helpful, is there any where i can download the template?
First thank you so much for this video. Second I have a question, if we want to change the Price of units on opening stock it doesn't change automatically on current status stock Units price. So how to make it automatically that if we change the price on units on opening stock it change on current status stock??
Hi Farhad, thanks for your question. Please note that a new tutorial is coming this week with inventory management system that will incorporate updated price changes of stock items. Please stay tuned. 😇
We are waiting for this kind of vedio with changes in prices
Thanks....it was realistic to implement this in working environment
Thank you very much. This is really helpful.
The great and impressive tutorial ever in Inventory management, keep it up
Thanks
I will always appreciate a teacher who knows how to brake it down and clarify. I did have trouble with the low volume but I'm glad I found you.
Do you have any video showing how to create warehouse locations in Excel for a beginner?
When you paste
How do you maintain previous width of table
you are the best! Thx.
Thank you so much for your guide
What if the unit price changes for an already stock item while replenishing. Where can we show this? Can u assist
Really helpful! Thanks!!!! Salute from Philippines!!
Thank you for this, Mr. It is very helpful
Thank you and more power to your channel
Thanks 😍
I have a question if I don't want opening stock table, just need purchase, sales and stock how can I joint the tables?
Thanks
This a greate video thank you so much. It helped me a lot. But i have one question if you can please answer it. Isn't the "opening stock" the same as the "purchases/stock in". Because bothe of them indicate the stocks on hand right.
Also the "price/unit" in "opening stock" is it the purchasing price or the selling price of the product
pls i need help, what if the price of an item purchased increases, how do i come around it or o i have to create another list every week ?
Thank you, learnt much about Vlookup function.
one doubt if I add any new item in opening stock it is not updating in current status of stock why is that what I have to do
U made it super easy 👏
Hi sir,
i would like to ask what if the stock in's price change or increase what should we record and it will mess up with the calculation. Can you please help
It is a very valuable Video, thanks for making it, one thing what if there is a price difference in opening stock and purchases?
Hi, thank you for the details. Sir how can we make a printed document of all items for a particular month. For example no. of an item bought and sold in a month and the amount. Thank you
I really appreciate your help, thank you very much! On my excel I have Purchase & Sale column together. Purchase can be in cash & in Credit & also the same way Sale can be in cash & in Credit. Now I need to get total credit in purchase & total credit in Sale. The same to credit for sale. Can I do this with this function?? Or shall I send you please?
Very nice video, but how do you add products?
Thanks to the teacher, he explained is so well. Do you have any website?
Very informative video, Thank you so much
You are great.super easy way to teach.
Stay Blessed Bro
Thanks for valuable explanation.
Hi.thank you so much for your tutorial. awesome 👍
This is the simplest among all the videos i have seen. Fortunately u talked about Motor parts but as u may have seen that same product is made by different manufacturers n we need to keep stock of every other company & remembering code item of every stock is almost impossible. So kindly educate how to take two cells instead of one like product n company. Also let us educate how to get automatically average pricing if i purchase or sale same product at different prices.
I facing error... When i enter in linked purchase or sales table that time showing no change in current status purchase and sales table.. Only showing 0 ...what's the problem??
You are the best
Thank you so much for this. I have 1 question though. Price per unit of buying and selling items may change with time as its not a constant...how do we show this on this system?
did you ever figure out a way to handle this?
1
Did you figure this out eventually?
New video will be released next week containing same inventory management system dealig with changing prices. Stay tuned 😉
@@MicrosoftOfficeTutorials we are waiting for it
Sir can it be done without using macros??
Are you able to set up and complete this same process without having item codes? Thank you for your help
Yes
So you would reference "item name" rather than "code" ?
Hey Very good video but audio was not good to hear with speakers use headphone and one more thing if we dont have opening stock than we can also use vlookup function in the current stock status tab to automatically add item name unit price etc
wao amazing
Amazing tutorial....Helped me lot.. :) Thanks for sharing
Great video
does it work when working in different spreadsheets ??
Yes, it does
Thank you very good explanation ❤
Thank you for your great lesson!!
This is amazing. Can u help me setup a inventory system?
Nice this is exactly what I was looking for
for the stock out Date you wrote 5*9/2019? is it suppose to be like that?
thanks, ver informative 👍
Can you the link for temple so we can watch video and try on that temple
GREAT CONTENT! Quick question and I hope your still answering questions for this, is this for daily update inventory?
Yes you can use it for daily update
@@MicrosoftOfficeTutorials ty for quick response, i'll be subscribing!!!
Thank you! I learned from seeing your video.
Thanks for video, it was very clear and perfect class
Excellent
very helpful thanks
Hello sir, what if we need to add more products in future to this list? Do we need to add from scratch?
Very useful and great explanations.
Thank you so much for this knowledgeable video!
Sir i have a curtain shop please guide me to maintain stock, i sell curtain and cloths both.
(a)Gate curtain made 2.5m
(b)windows curtain made 1.5m
Suppose that:-
1. Cloths is 50Meters
2. 5pic of gate curtain sellout.
3. 3pic of window curtains sellout .
4. 5meters cloths is sellout.
5. 2 pic gate curtain is return.
1 - What is rest stock ?
2 - how much profit ?
Pease make a video on this how to create sheen on this table.
Apne Jo formulas use liye last like M5 N5 ACS etc plz us pr koi video BNA dijiye
All ok bro I have big doubt when you purchase item you enter this item abc company we are delivery like stock tracking
Example
Mobile opening stock 5pcs
Then abc Customer need 10 PCs mobile
Then you check stock report available qty 5
Then you purchase 5 PCs
Then abc Customer cancel the order then 5pcs mobile goto store now total 10 stock no customer only stock
Then abcd customer send order 15 PCs mobile then purchase 5pcs we have already 10 PCs now ready to deliver but customer hold the order
Then other customer order 5 PCs mobile
We are changing stock report show 15 PCs mobile but this waiting for delivery to customer so we are ordering new 5pcs
Sir, can you help me with an excel program to calculate consumption of raw material based on BOM of finished goods and also the cost of production. We will input the opening stock, purchases, consumption will be calculated based on BOM of finished goods. We need this urgently. Thank you.
Is there a way where I can monitor the in, out, stock, re-stock and stock value all at the same time on daily basis?
Or is there a way that the sumifs function can be set on daily basis?
yes u can use sumifs with current date criteria
I made an inventory sheet based on this one. Thank you very much!.. Just one thing, Is there a way to restrict the input in stock out / sales if the current inventory is not sufficient?
You can use simply a "IF" function saying the sales should not cross the inventory limit. So that you may know when the purchases become insufficient for the inventory.
@@PraveenKumar-jp4sl would be a big help if you can give me a formula basing on your sheet shown in the video so I can pattern it to my sheet. cant seem to find the correct formula. Hoping you can help me out. Thanks so much!
HI MATE ! i need your help i create this template but my business keep bringing new stuff everyday and was wondering, how can i add new stock that is coming in to my business, whenever i try to add rows it does not allow me to do it and if i add it to the purchases table it does not appear in the current status of stock. thanks for your help
If I was to have 20 cells each with a different hire date what function would highlight each cell that the month occurred every year. For instance... I have these dates listed, 05/04/2021, 01/09/2021, 05/27/2021. For the dates of May the cell would be highlighted because the current month is may .
Hi Ashlen...please follow these steps
1. Select column in which you have dates
2. Go to Home Tab
3. Go to conditional formatting
4. Select "new rule" from conditional formatting
5. Select "use a formula to determine which cells to format"
6. Write following formula (in formula you need to use column number in whicb you have dates... I am using column J)
=Month(J1) =Month(Today())
7. From formar change format of cells the way you want them to highlighted
........
Please let me know if you understand otherwise i can give you my whatsapp no.
This is exactly what I was looking for, a crisp concise video on small inventory maintenance. Thanks. I have just subscribed to your channel.
Kem cho Kaki?
Excellent
U solved my problem. Thanx
If you purchase more Door Handles at a different price isn't that going to give an incorrect value both in Inventory and COGS ??
Thank you 👌
Purchase and sell price will not be same, if both price will be different then how we adjust inventory??
Use f4 with fn key to fix, super boss
Hi, would like to ask help,..☹ how to add 2 look up values from different table set???