This is one of the best formulas to control inventories and get alert to procure required materials. Since long I was searching for same type of inventory system but I couldn't. I'm so happy to see this formula and thank you very much for this,
Wow this was one of the best tutorials I have viewed in a very long time, you have explained everything in such a excellent manner I could understand from the beginning what you were saying, thank you for your great video it helped me to successfully create my work sheet, Well Done.
Omg I did it.... thank you so much your going to have everyone at work thinking I know what I'm doing.....I do trying to make my job easier hahahahahah
@@smart-office12 *VERY NICE* 👌🏻 but EVERONE MISS OUT DAMAGE ITEM COLOUM Please make one like I mention Below: 1) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION Please add that coloum of Damage but it should be like - Damage 1pc + 9pc Good = 10pc in STOCK ( Damage Item is return to Supplier & get New in Return ) 2) Need to be able to Add Full items of PURCHASE or Sales under One Invoice # not individually Eg: in one day we make Sale 10pc so need to see in Coloum = 4pc Inv#-44 / 3pc Invoice#-45 / 3pc Inv#-46 so need to know how many PC in each Invoice # Good to have Total Stock COST NEED Extra Coloum to show what's the weight of each Item Would be glad to pay for this Sheet if made according to my requirements Thanks
Hi Sir u are a blessing to us and our comp. this is exactly what we have been looking for, for a very long time we appreciate u. Pls can u teach on closing this stock and opening it in different month, thank very much ❤
It is a very good video. However, if you talk about the formula a bit earlier, that will be better for the members so we will be easy to understand the purpose of your system quicker.
Such an effective tutorial! I want to ask a question, Regarding R/T status. What if the orders are placed on the same date but each orders are received on different dates. Because the R/T status is right above the column. I want to put R for one order only but the other orders is still in transit. How to fix this? I would appreciate it so much if you reply to my comment sir 🥺
Nice But...... ▪︎ Need to make one where we make a Invoice & it should show Profit of Sale & STOCK Auto Adjust when we make Invoice ▪︎ Stock Auto Adjust & in hand Stock Total Amount ▪︎ Color Should go RED when desire Stock Amount goes LESS ▪︎ Sale to Every Customer of Item is made in Different Prices Retail Wholesale & different prices in Retail ▪︎ Add a Coloum for Damage Item to return to company Need to Add option for Different Sale Rates to Different Customers *Will Pay if you Make a Excel Sheet as per my Requirements*
This is very helpfull to control stock. Please, I would like to see how the sheet is created formated. I will really much appreciate if you Can reply to my comment and share how you build the system from begining. Thank you
Great tutorial. I enjoyed the sequential approach. It was very helpful. Please how do you handle a situation where you placed an other for two different products, say Products A and B, but had only product A delivered. If you replace the 'T' with 'R' for Product A, how do you deal with product B which you are yet to receive? Thanks.
It assumes that the transit quantity in one column is delivered together. If not, we have to keep undelivered product in another column and mark it as transit
Thank you for your great work just I want to inquire if the formla SUMIF can used between many pages and if yes, kindly let me know the way since I'm using your formula and adding to it '01:31'! but its showing #VALUE!
Good video. Thanks. Just a quick question do we make this inventory on a month by month. Are able to connect all months on a second separate spread sheet to show trends
Hello thank you for sharing this with us... But I want to use different sheet for stock in, and different sheet for stock out. But it's not working. Please help.
If you can do one on converting a recipe from cups to pounds. I work at a prison a lot of the recipes are in cups but I need them in pounds or the tea and tablespoons in cups due to the mass cooking we do. my average number of offenders on my unit is 800
Thank you for this tutorial , now my question is about the formula you made mention of something like eco key while using the formular but I don't understand pls . Please kindly Explain to me better about the steps of the formula. Thanks.
Boss I want to know in excel suppose we have 100 item then I cell 40 then balance item shows 60. Then how can see how much percent balance. Can u make one vidio please
Hi, I’m working my way through this video. I’m a novice when it comes to this so it’s taking a minute but I’ve watched the entire video once and I like the functionality of the completed spreadsheet. I have a question. At 29:20-29:30 you reference pressing a certain key to correct the formula. I can’t understand, what key are you saying?
Hi, thank you for this video, but my question is : it is confined to the specified boxes (14 in your video), and i want to use them throughout the month, so there are many boxes that i need, so what should i do? thanks
If you are trying to say the number of rows(14) , the row can be expanded by simply copy the row num 14 and paste them down. I have taken till row 14 just for example , it can be expanded till your requirements
👍👍Wow, This was a fantastic tutorial! Thank you so much! I have followed all your instructions and it works fantastic. I have 2 questions. 1. Can I add more products (by inserting rows and adding the new product name) as I grow my business? 2. Could you please tell me a formula for total stock out for each product. I made a column under Balance Stock and to the right of Quantity and Labeled it Total Out. I would like it to update each product as it is sold for total sold of each product. Thank you so much. 👍👍
Hi, thank you for the lovely comment, Yes you can add more products at the last row of stock balance section, when you add more products, you need to update the formula and drop down list validation. I am not clear with the second question, could you please make it more clear?
I hope you see this, the substraction and addition to get a balance stopped at a point, whenever i want to add or subtract stocks from a certain point, it doesnt work, i hope you can solve this for me
if fora certain date I have 200 items to stock in and 20 items stock out, All items should stay and it will be a long list. For the next date of stock in and 500 items are added, this will be a long list, is that correct. we can't minimize the stock in list.
Hi great progect a bit hard to follow as a novice. is there a part of the fumula missing as the opening ballance colum never changes its value. or can you only change it manuly. Again thanks for a good prgect
Bro i get problem. I putt formula if i add new item it should be not show in stock out list butt its show on a stock in list. How can i solve this problem pls let me know fast.
I am almost done and I don't understand the R/T Status - it doesn't for. I have followed everything. You showed sheet 1, but I didn't see where two difference sheets were created.
This is one of the best formulas to control inventories and get alert to procure required materials.
Since long I was searching for same type of inventory system but I couldn't. I'm so happy to see this formula and thank you very much for this,
Thank you for the appreciation 🙏
I've been trying to expand my knowledge in Excel and it's really helpful to me. Thank you for this.
Welcome 🙏
A lesson I was looking for.
Very good & clear explanation
I 'm from sri lanka.
Thank you very mach sir,
God bless you.ok
Thank you
Amazing Content..i remember my mentor in SAP who's Bangladesh Woman Indirah S..approved from 🇵🇭
Amazing , Excel , explained and showed in a great way!! Thank you Sir
Thank you.
Wow this was one of the best tutorials I have viewed in a very long time, you have explained everything in such a excellent manner I could understand from the beginning what you were saying, thank you for your great video it helped me to successfully create my work sheet, Well Done.
Thank you🙏
Very simple yet effective inventory worksheet. Thank you
Welcome 🙏
After Watch this Video, I immediately Subscribed your channel sir
Thank you
Omg I did it.... thank you so much your going to have everyone at work thinking I know what I'm doing.....I do trying to make my job easier hahahahahah
Thanks
How did you set it up my procurement suggestions is responding
@@smart-office12
*VERY NICE* 👌🏻 but EVERONE MISS OUT DAMAGE ITEM COLOUM
Please make one like I mention Below:
1) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION
Please add that coloum of Damage but it should be like - Damage 1pc + 9pc Good = 10pc in STOCK ( Damage Item is return to Supplier & get New in Return )
2) Need to be able to Add Full items of PURCHASE or Sales under One Invoice # not individually
Eg: in one day we make Sale 10pc so need to see in Coloum = 4pc Inv#-44 / 3pc Invoice#-45 / 3pc Inv#-46 so need to know how many PC in each Invoice #
Good to have Total Stock COST
NEED Extra Coloum to show what's the weight of each Item
Would be glad to pay for this Sheet if made according to my requirements
Thanks
Very useful thank you, ive adjusted it slightly for a project im working on and its perfect.
Excellent teaching and moved slow enough to follow. Amazing!
Thank you 🙏
Hi Sir u are a blessing to us and our comp. this is exactly what we have been looking for, for a very long time we appreciate u. Pls can u teach on closing this stock and opening it in different month, thank very much ❤
Thank you! Exactly what I needed. I was able to follow your instructions very easily.
Welcome 🙏
It is a very good video. However, if you talk about the formula a bit earlier, that will be better for the members so we will be easy to understand the purpose of your system quicker.
Thank you for the valuable suggestion
Yeah anyone wanting to skip the intro... He starts at 15:00
Either way i like what they did. Thats what a good teacher does, stARTS WD intro then main subject.
Thank-you for Sharing a very useful information here. Very beneficial to my current role.
Welcome 🙏
Awesome, very helpful information sir ,thanks for spreading knowledge... knowledge is everything.
Thank you so much 🙏
Such an effective tutorial! I want to ask a question, Regarding R/T status. What if the orders are placed on the same date but each orders are received on different dates. Because the R/T status is right above the column. I want to put R for one order only but the other orders is still in transit. How to fix this? I would appreciate it so much if you reply to my comment sir 🥺
Each order should be kept in separate column, once received, need to change T to R
th-cam.com/video/m6yBIQ-GQRg/w-d-xo.html@@smart-office12
Oh my God, this is very good. It is very helpful for me. This is exactly what I was looking out for. Thank you very much.
Glad it was helpful!
This is to the simplest way of understanding thanks
Thank you so much 🙏
Easy to follow instructions, works perfectly, cheers mate
Thank you 🙏🙏
Thank you so much bro. I love your way to explained. ❤❤❤
Welcome 🙏
Just Loved your Cheque Receipt software, regards from Noida
wow! this is really amazing, thanks for sharing.
Welcome 🙏
Nice But......
▪︎ Need to make one where we make a Invoice & it should show Profit of Sale & STOCK Auto Adjust when we make Invoice
▪︎ Stock Auto Adjust & in hand Stock Total Amount
▪︎ Color Should go RED when desire Stock Amount goes LESS
▪︎ Sale to Every Customer of Item is made in Different Prices Retail Wholesale & different prices in Retail
▪︎ Add a Coloum for Damage Item to return to company
Need to Add option for Different Sale Rates to Different Customers
*Will Pay if you Make a Excel Sheet as per my Requirements*
it was so easy and productive,really thanks
Welcome 🙏🙏
this was extremely insightful
Wow! Amazing template, please kindly help factor in Damages and Returns in the next update video. Thanks well done.
thankyou for your useful and clear suggestion this was exactly what I want
Thank you
Woow....It was the simply Best video I have seen on this flatform. Wish you all the best Bro
Thank you so much for your inspiring comment
Thank you for sharing this video.
Welcome 🙏
Perfect.... Love the way you explained it...
Thanks a lot 😊
A great and amazing Watch to this video from pakistan
Thank you
Thank you for this video, its just and exactly what i was looking for.
Welcome
This is very helpfull to control stock. Please, I would like to see how the sheet is created formated. I will really much appreciate if you Can reply to my comment and share how you build the system from begining. Thank you
Hi, the template is available to download in the link given in video description
My balance Quantity is =Opening stock +sumif()+sumif()+ total transit and it gave me the same result as yours.
It should be opening + sumif - sumif
Thank you. Your template help me a lot..
Glad to hear that!! Thank you 🙏
I suggest using named tables and have different sheets for the stock in and out
This was extremely helpful, thank you!
Thank you for this great tutorial. Bless you.
Welcome 🙏
Thank you for this video, it was reeeeaaaaly helpful.
Thanks and welcome
this was a fantastice video, if possible please make this stock manangement with item price and caculations.
Okey, we will definitely work into it.
Much thank you sir watching you from Kenya i am grateful, my question is, is it possible to put the month range from January to December
Yes, you can
Great Job 👍. Thank you so much.
Most welcome 🙏
Thanks Buddy that was so helpful
Really very useful and easy to use... thanks
kindly one with the price as well thank you for this great work
Noted, thank you so much
Very helpful and easy to follow.
Great to hear!
This is very helpful. Thanks
Great tutorial. I enjoyed the sequential approach. It was very helpful. Please how do you handle a situation where you placed an other for two different products, say Products A and B, but had only product A delivered. If you replace the 'T' with 'R' for Product A, how do you deal with product B which you are yet to receive? Thanks.
It assumes that the transit quantity in one column is delivered together. If not, we have to keep undelivered product in another column and mark it as transit
thank you.. it was very useful.
Welcome
very informative thank you i learned a lot
Glad it was helpful!
Thanks for sharing 🙏
very useful video thank you so much.
Glad it was helpful!
Can you add a column to the “out” when inventory is sent that will track the expiration date?
Thank you very much, this is very helpful
Thank you
Thank you for your great work just I want to inquire if the formla SUMIF can used between many pages and if yes, kindly let me know the way since I'm using your formula and adding to it '01:31'! but its showing #VALUE!
Woww it worked thanks alot!!
Welcome 🙏
Do you have another formula which product sold the most? Like a chart? Thanks in advance 🙏
Great video - after applying the formula my upper cells of stock out aren't working. Can you help?
Hi im sorry. I find your video very helpful. Did you by any chance sell the template?
Hello, this template is free to download in video description
@@smart-office12 Hi Thanks!! Will this work for a large inventory? Since we are keeping track for purchase item this too will help right?
hello sir. keep it up. thanks ❤❤
Pls can we update dx template with different stock items that x not part of the list of known stock items.tnk you
Superb sir I will try
Good video. Thanks. Just a quick question do we make this inventory on a month by month. Are able to connect all months on a second separate spread sheet to show trends
Ya, this can be done monthly or yearly. Values can be linked to other sheets to analyze trend.🙏
Hello thank you for sharing this with us... But I want to use different sheet for stock in, and different sheet for stock out. But it's not working. Please help.
Plz visit below link
th-cam.com/video/Q9PaPMW657g/w-d-xo.html
Really great work 🙏🙏🙏
If you can do one on converting a recipe from cups to pounds. I work at a prison a lot of the recipes are in cups but I need them in pounds or the tea and tablespoons in cups due to the mass cooking we do. my average number of offenders on my unit is 800
Thanks, BRO...Great Work...!!!
Thank you for this tutorial , now my question is about the formula you made mention of something like eco key while using the formular but I don't understand pls . Please kindly Explain to me better about the steps of the formula. Thanks.
That is F4 key in the keyboard, to fix the cell reference in formula
VERY USEFUL
Bro please arrange video in Android mobile Excel me
We need mobile Excel
How are you sir
This video is very very helpful sir.
But can you tell me what is the meaning of the (epro key )
F4 key
Thank you, this helps my inventory so much, can yiu also tell me, if im going to October, how do i bring the new opening stock to the next new sheet?
For October month, you have to create a new file, closing stock of September will go to October by copy and paste
@@smart-office12 thank you, we oways forgt the basic ehee a matter of copy paste 😁 thank you again, have a nice day frm Brunei 👍🏽
very good.
Boss I want to know in excel suppose we have 100 item then I cell 40 then balance item shows 60. Then how can see how much percent balance. Can u make one vidio please
Hi, I’m working my way through this video. I’m a novice when it comes to this so it’s taking a minute but I’ve watched the entire video once and I like the functionality of the completed spreadsheet. I have a question. At 29:20-29:30 you reference pressing a certain key to correct the formula. I can’t understand, what key are you saying?
Its F4 key in Keyboard, F4 key is used to fix the cell reference in formula, alternatively we can also write dollar sign($)
@@smart-office12 thank you!
oh yeah it was my question too, Thankyou for your reply now I got it f4
how do you get the R/T to remove the Place Order under Procurement
Suggestion. Nothing happens when I put a R or T in R/T Status
just watched again and saw the steps to make this work. THANKS for the template. It is exactly what I needed!
Thanks and welcome
Hi, thank you for this video, but my question is : it is confined to the specified boxes (14 in your video), and i want to use them throughout the month, so there are many boxes that i need, so what should i do?
thanks
to be more clear, what should i do if i have more than 14 operation in the month?
If you are trying to say the number of rows(14) , the row can be expanded by simply copy the row num 14 and paste them down.
I have taken till row 14 just for example , it can be expanded till your requirements
can we get one for manufacturing business where we enter raw material, usage and product sale? along with summary page
Nice ♥️
Tq
👍👍Wow, This was a fantastic tutorial! Thank you so much! I have followed all your instructions and it works fantastic. I have 2 questions. 1. Can I add more products (by inserting rows and adding the new product name) as I grow my business? 2. Could you please tell me a formula for total stock out for each product. I made a column under Balance Stock and to the right of Quantity and Labeled it Total Out. I would like it to update each product as it is sold for total sold of each product. Thank you so much. 👍👍
Hi, thank you for the lovely comment, Yes you can add more products at the last row of stock balance section, when you add more products, you need to update the formula and drop down list validation. I am not clear with the second question, could you please make it more clear?
How to update the formula and drop-down list validation. Thank you.@@smart-office12
Thank you very much!!!
Wc
Very useful but I dont understand the formule when u said “Click cookie on your keyboard” part😔 help pls
Its F4 key in Keyboard
It won’t work😔 I need help
I’m using a laptop
what does it mean for poke i cant understand .. or dollar sign ! please reply what keys on keyboard we click
F4 key, which applies dolor sign
I hope you see this, the substraction and addition to get a balance stopped at a point, whenever i want to add or subtract stocks from a certain point, it doesnt work, i hope you can solve this for me
Hi Sir! It is so good but I'm not understand what is meaning of Letter R and T? If possible Please fill full meaning of it. Thanks!
R is just the short form of Receipt and T is Transit, Thank you
Thank you boss.
You're welcome!
Hello; What do you mean by Fix the Column. fix the sumrange
By pressing the F4 key in keyboard, that applies dollar symbols
Nice one
Thanks so much bother
I need your help i have 2000+ products names here is one collum 1100 spaech how i selected 2 product collum and 2 opening stock
If there is a video about profit and loss, can you send the link or I'm waiting for you to shoot it?
Thank you, sir!
Welcome
if fora certain date I have 200 items to stock in and 20 items stock out, All items should stay and it will be a long list. For the next date of stock in and 500 items are added, this will be a long list, is that correct. we can't minimize the stock in list.
Ya, In case of too many items, its quite inappropriate . This template best works in case we have limited number of items.
very impressive, how can access it
Thank you,
Please visit www.spreadsheetlearning.com for the template
Hello, can you share this spread sheet? It is good tool you have build
What key did you press again at 29:22 for the range?
F4 key
thank you very much for nice format . Can I get template, Sir?
i watched the video it's very nice but if i have more than 100 goods how can i fit them all
Hi, In case of 100 goods, the rows will expand to 100 rows, method is same
Hi great progect a bit hard to follow as a novice. is there a part of the fumula missing as the opening ballance colum never changes its value. or can you only change it manuly. Again thanks for a good prgect
Hi, thanks for appreciation, opening stock is supposed to keep manually at the begining of the period.. month/year
@@smart-office12 ok thanks for the quick reply now I understand
Bro i get problem. I putt formula if i add new item it should be not show in stock out list butt its show on a stock in list. How can i solve this problem pls let me know fast.
I am almost done and I don't understand the R/T Status - it doesn't for. I have followed everything. You showed sheet 1, but I didn't see where two difference sheets were created.