Stock In Out and Balance Tracker in Excel | Auto suggest inventory order quantity
Вставка
- Опубліковано 3 вер 2020
- Stock In Out and Balance Tracker in Excel | Auto suggest inventory order quantity
In this video you will learn how to make stock management and planning system in Microsoft Excel. It will track Stock IN, Stock OUT, Balance Stock and suggest us procurement to be made based on Minimum stock level and balance stock comparison.
Download the workbook for practice from link below.
Workbook Number: 1
learnexcelandsheets.com/excel...
Very useful thank you, ive adjusted it slightly for a project im working on and its perfect.
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 🙏
Very simple yet effective inventory worksheet. Thank you
Welcome 🙏
Really very useful and easy to use... thanks
Amazing Content..i remember my mentor in SAP who's Bangladesh Woman Indirah S..approved from 🇵🇭
Excellent teaching and moved slow enough to follow. Amazing!
Thank you 🙏
Easy to follow instructions, works perfectly, cheers mate
Thank you 🙏🙏
Really great work 🙏🙏🙏
Thank you for this video, its just and exactly what i was looking for.
Welcome
This was extremely helpful, thank you!
Awesome, very helpful information sir ,thanks for spreading knowledge... knowledge is everything.
Thank you so much 🙏
this was extremely insightful
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
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🙏
Thank you! Exactly what I needed. I was able to follow your instructions very easily.
Welcome 🙏
Just Loved your Cheque Receipt software, regards from Noida
Thank you for this video, it was reeeeaaaaly helpful.
Thanks and welcome
thankyou for your useful and clear suggestion this was exactly what I want
Thank you
Thank you for this great tutorial. Bless you.
Welcome 🙏
This is very helpful. Thanks
Thanks Buddy that was so helpful
Thank you so much bro. I love your way to explained. ❤❤❤
Welcome 🙏
Thanks for sharing 🙏
Thanks, BRO...Great Work...!!!
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
@@increase-work-productivity
*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
it was so easy and productive,really thanks
Welcome 🙏🙏
Thank-you for Sharing a very useful information here. Very beneficial to my current role.
Welcome 🙏
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 ❤
After Watch this Video, I immediately Subscribed your channel sir
Thank you
Thank you for sharing this video.
Welcome 🙏
I suggest using named tables and have different sheets for the stock in and out
Great Job 👍. Thank you so much.
Most welcome 🙏
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 🙏
hello sir. keep it up. thanks ❤❤
Perfect.... Love the way you explained it...
Thanks a lot 😊
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!
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
Superb sir I will try
wow! this is really amazing, thanks for sharing.
Welcome 🙏
Thank you, sir!
Welcome
Thank you very much!!!
Wc
Nice one
Very helpful and easy to follow.
Great to hear!
very good.
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.
A great and amazing Watch to this video from pakistan
Thank you
very informative thank you i learned a lot
Glad it was helpful!
thank you.. it was very useful.
Welcome
Wow! Amazing template, please kindly help factor in Damages and Returns in the next update video. Thanks well done.
VERY USEFUL
Can you add a column to the “out” when inventory is sent that will track the expiration date?
very useful video thank you so much.
Glad it was helpful!
Thank you boss.
You're welcome!
👍👍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.@@increase-work-productivity
this was a fantastice video, if possible please make this stock manangement with item price and caculations.
Okey, we will definitely work into it.
can we get one for manufacturing business where we enter raw material, usage and product sale? along with summary page
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
ua-cam.com/video/m6yBIQ-GQRg/v-deo.html@@increase-work-productivity
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
@@increase-work-productivity thank you, we oways forgt the basic ehee a matter of copy paste 😁 thank you again, have a nice day frm Brunei 👍🏽
Woww it worked thanks alot!!
Welcome 🙏
Do you have another formula which product sold the most? Like a chart? Thanks in advance 🙏
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*
thank you very much for nice format . Can I get template, Sir?
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.🙏
thank y brooo
Welcome 🙏
Great video - after applying the formula my upper cells of stock out aren't working. Can you help?
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
Hello, can you share this spread sheet? It is good tool you have build
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
ua-cam.com/video/Q9PaPMW657g/v-deo.html
Pls can we update dx template with different stock items that x not part of the list of known stock items.tnk you
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
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
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
@@increase-work-productivity ok thanks for the quick reply now I understand
do you have a template for this excel sir
its very useful im work
What abt if u place order and the whole border is used what will u do
Dherai Dhanyabad, maile kehi sike aaja.
Nice ♥️
Tq
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, 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
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($)
@@increase-work-productivity thank you!
oh yeah it was my question too, Thankyou for your reply now I got it f4
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.
where can i download this excel document ?
If there is a video about profit and loss, can you send the link or I'm waiting for you to shoot it?
Good
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
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
Bro please arrange video in Android mobile Excel me
We need mobile Excel
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
May I have the formula of procnumetion?
if amount add then which formula applied?
Thanx
Welcome
for the sum if function which key are we pressing on the keyboard
F4 key, to fix the data range
@@increase-work-productivity thank you so much. Amazing tutorial you have helped me so much with my business
My pleasure to share knowledge, Thank you
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.
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
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
hi please send me the inventory for stock cover for 3 months in excel
Hello; What do you mean by Fix the Column. fix the sumrange
By pressing the F4 key in keyboard, that applies dollar symbols
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 I want for further months, how to do, please?
you have to copy the sheet and create new for new month
Is there a template available for this!? many thanks.
File please ?
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.