Get this template from here: www.buymeacoffee.com/brainbehindbiz/e/74865 Thank you for watching Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/3uzL2ZA
Thank you @austindaurah3903 I have created an updated version of this stock control sheet and I hope you will like it. th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
How to make excel calculates my sales and inventory where I just insert the sales transactions when they occur by customers I mean I want excel to do the calculation automatically for me giving me this information: Available inventory Cost of the available inventory Count of transactions per month Who the customers made sales Value of the sales Calculate the profit (every week or every month)
Hi @aboibrahim4069 I have created an updated version of this stock control sheet and I hope you will find answers to most of the questions you just asked. th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
Man if I could hug you through this screen, I would! I started a stock pile for my family and members, but we definitely needed a better inventory system. This has definitely helped sooo much! THANK U SO MUCH SIMPLICITY ❤
No frills and straightforward design! I love it! I actually have an inventory template to track stocks for Excel! The whole creation turns out to be easier that I thought it would be so thanks for the video!
Glad it was helpful! I am soon creating a stock control sheet which will be an advanced version of this and you will be able to track all in's and out's along with these alerts Stay tuned for that
Favorite ko talaga mag explain Ang indian dahil sa tulad Kung slow is magical Kasi naintindihan ko ka agd since high school ni research ko talaga indian explanation kapag meron akong Hindi naintindihan sa subject ko❤❤❤ thank you po in God bless
You are welcome, you can download this sheet from here www.buymeacoffee.com/brainbehindbiz/e/74865 and I have also created and advance version of stock control sheet which has more features than this one. th-cam.com/video/-FGLhhifShQ/w-d-xo.html
Hi, I appreciate the tutorial on how to create this inventory log. While I didn't use all of it because my inventory was simple and didn't require unit costs etc., It definitely helped me tons. 🙏👍👍
This is great i think i'm almost ready to go with this short tutorial i just got a job as a warehouse manager in a fast food company and i need a complete inventory sheet control template to manage my stock thanks
You are welcome and thank you for this beautiful comment. Please also check this updated version of the stock control sheet th-cam.com/video/-FGLhhifShQ/w-d-xo.html this is an advanced version with more features so this will be more helpful. After watching that advance version, leave your thoughts there as well.
Thanks, we can make it unit cost (cost of product) and unit price (selling price) Please chech other video on on my channel which is more advance than this one
Glad you liked it! Please check this new interactive stock control sheet video at th-cam.com/video/-FGLhhifShQ/w-d-xo.html Stay connected 🙏 @sumaiyaakther190
Thankyou it helps alot and please can you also make another video especially to give the formula of stock inventory. I like your video it really helps me.
@NathanPaul-fd9ny You are welcome and thank you for watching. I have already created an updated version of stock control sheet that would be more helpful. Please watch this: th-cam.com/video/-FGLhhifShQ/w-d-xo.html
Happy to help, i am working on an stock control sheet where you will even be able to include all in's and out's of your inventory and it will mostly automate the process
Hi, @familyislove6766 I have created an updated version of this stock control sheet and I hope you will like it. th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
Hi Tracey, I can make a customized excel sheet for you but that would be a separate paid task. @traceychivers1988 My Services: www.buymeacoffee.com/brainbehindbiz/commissions Sheets and discussion: www.buymeacoffee.com/brainbehindbiz/extras
Hi dear, this 20 is just a imaginary number where I want excel to warn me about the stock level you can use whatever you like lets say 10 or may be 100.
What i mean is after applying the formula on the first cells,to Avoid repetition on the next you pulled through but when i pull through no figures appears on the next cells
Some retail businesses find it difficult to record each item sold , so they prefer to work with sales summary how can we handle their records to show the value of inventory sold?
Yes, I can make but that would be complicated to mange inventory and debtors at the same time, you should use two separate sheets one for inventory other for debtors.
for that we have an advance version of stock control sheet which has more features than this one where you can add and sell stock as per your business th-cam.com/video/-FGLhhifShQ/w-d-xo.html
Yes I can make something for you as per your requirements but please check an updated stock control sheet on my channel at th-cam.com/video/-FGLhhifShQ/w-d-xo.html which has functions of increasing and decreasing inventory. This might solve your issue if not please let me know
You are welcome, You can add products to the product list as many as you want, you just need to drag formulas beside it. Please check this new interactive stock control sheet video at th-cam.com/video/-FGLhhifShQ/w-d-xo.html and I hope you will like it too Stay connected 🙏
ITs selling price but for proper selling price and costing you can check my updated stock control sheet on my channel which has all these details in it.
How can I help you find a job in UAE. Keep applying and you will get one soon Check famous websites but stay alert there are many scammers as well in Dubai
Thanks kindly Brain Behind Business... But if you come back tomorrow and makes another sales how will you minus?? Am not using laptop... Beside am using stockbook...
Hi, @okaforchidimmablessing2992 I have created an updated version of this stock control sheet and I hope you will like it because it has the options which you were looking for th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
I am glad that you liked it, actually automation is not available in this sheet but I will soon release an advance version of this in that you can automate all in's and out's of the inventory.
Hi, @matthewadebiyi6924 Sorry for being late but I have created an updated version of this stock control sheet and I hope you will like it. th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
For that please check this new interactive stock control sheet video at th-cam.com/video/-FGLhhifShQ/w-d-xo.html and I think your issue will be resolved 🙏 Let me know if you need any further guidance @JosephLouis
question: it's a dumb question but do i update the quantity in hand whenever we restock and quantity sold whenever we sold something? do i not have to make another sheet of there is a restock? do i just add everytime? thanks im new to these
Hi @akidokii that's a good question as many people asked this and the answer is no you need to manually write stock in that sheet But the GOOD NEWS is On the demand of you guys I have created an updated version of stock control sheet that is a advance version and you can manage ever entry and update like in(Purchase) and out(Sold) on daily basis on that sheet Link: th-cam.com/video/-FGLhhifShQ/w-d-xo.html please like comment and share if you like it. Stay connected for more amazing videos like this. You can also get a customized sheet for you business if you want o
I think this video will solve your problem, just add products such as X shoes with different sizes and Y with different sizes like this. th-cam.com/video/-FGLhhifShQ/w-d-xo.html
Get this template from here: www.buymeacoffee.com/brainbehindbiz/e/74865
Thank you for watching
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/3uzL2ZA
Can I have it for free please I don't have s bank account
wonderful tutorial ...
Thank you @austindaurah3903
I have created an updated version of this stock control sheet and I hope you will like it. th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
How to make excel calculates my sales and inventory where I just insert the sales transactions when they occur by customers
I mean I want excel to do the calculation automatically for me giving me this information:
Available inventory
Cost of the available inventory
Count of transactions per month
Who the customers made sales
Value of the sales
Calculate the profit (every week or every month)
Hi @aboibrahim4069
I have created an updated version of this stock control sheet and I hope you will find answers to most of the questions you just asked. th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
Indian youtubers saved me like 100x already! One of the reasons you should love them more.
Nice
I work in a retail store and needed to know this information
Glad to know this
Man if I could hug you through this screen, I would! I started a stock pile for my family and members, but we definitely needed a better inventory system. This has definitely helped sooo much! THANK U SO MUCH SIMPLICITY ❤
Haha, I am glad that it helped. You should also check the updated version of stock control sheet on my channel that is even crazier
I have search,view other video, but yours is better and easier for me to understand.Thank you so much really appreciate it 😊
You are welcome 😊, Please do visit other videos on my channel specially advance stock control sheet
Great video! Sending our best wishes to all the small businesses and freelancers who will benefit from this video. 🙌
Thank you and stay connected for more amazing videos like this
No frills and straightforward design! I love it! I actually have an inventory template to track stocks for Excel! The whole creation turns out to be easier that I thought it would be so thanks for the video!
Glad it was helpful!
I am soon creating a stock control sheet which will be an advanced version of this and you will be able to track all in's and out's along with these alerts
Stay tuned for that
@brentgarret2388 I have created an update version of this stock control sheet and I hope you will like it. th-cam.com/video/-FGLhhifShQ/w-d-xo.html
such a brilliant work. this is a big help to those who are starting yet in the business industry. thank you for this
You are welcome, Stay Connected
You are a good teacher .. God bless you
Thanks, you too!
Great
very professional and straight to the point
An upcoming video will be an advance version of this with a lot automation and tracking of all in's and out's. Stay tuned.
Favorite ko talaga mag explain
Ang indian dahil sa tulad Kung slow is magical Kasi naintindihan ko ka agd since high school ni research ko talaga indian explanation kapag meron akong Hindi naintindihan sa subject ko❤❤❤ thank you po in God bless
Thank you for your kind comments but to clarify I am not an indian. I am a Hindu guy from Pakistan
Thank you so much. I love the way you slowly show us what to do. This will really help me so much.
You are welcome, you can download this sheet from here www.buymeacoffee.com/brainbehindbiz/e/74865 and I have also created and advance version of stock control sheet which has more features than this one.
th-cam.com/video/-FGLhhifShQ/w-d-xo.html
Thank You, it was my biggest problem for my mini shop, now every single items are recorded!
You're welcome!! Stay connected 🙏
Hi, I appreciate the tutorial on how to create this inventory log. While I didn't use all of it because my inventory was simple and didn't require unit costs etc., It definitely helped me tons. 🙏👍👍
Glad it helped!
Stay connected.
@undagroundrican I have created an updated version of this stock control sheet and I hope you will like it. th-cam.com/video/-FGLhhifShQ/w-d-xo.html
This is great i think i'm almost ready to go with this short tutorial i just got a job as a warehouse manager in a fast food company and i need a complete inventory sheet control template to manage my stock thanks
You are welcome and thank you for this beautiful comment.
Please also check this updated version of the stock control sheet th-cam.com/video/-FGLhhifShQ/w-d-xo.html this is an advanced version with more features so this will be more helpful.
After watching that advance version, leave your thoughts there as well.
Great vid I would just say too make sure unit price is specified. Because unit price can be cost of product or selling price
Thanks, we can make it unit cost (cost of product) and unit price (selling price)
Please chech other video on on my channel which is more advance than this one
This vedio is so easy to learn excel store management.
Glad you liked it!
Please check this new interactive stock control sheet video at th-cam.com/video/-FGLhhifShQ/w-d-xo.html
Stay connected 🙏 @sumaiyaakther190
most beautiful work I've seen concerning excel
Thank you for these kind words. 🙏
Please stay connected for more videos.
I hope you also liked my recent video breakeven analysis
Thanks so much be blessed I learnt a lot to save my bussiness
Glad I could help
Way of Explanation is very simple and awesome
Thank you so much 🙂
Keep watching
Thanks for the Information. Got alot of knowledge and made my own stock list easily
Glad it was helpful!
Please check advance stock control sheet on my channel that is an updated version
Thankyou it helps alot and please can you also make another video especially to give the formula of stock inventory. I like your video it really helps me.
@NathanPaul-fd9ny You are welcome and thank you for watching.
I have already created an updated version of stock control sheet that would be more helpful. Please watch this: th-cam.com/video/-FGLhhifShQ/w-d-xo.html
@@BrainBehindBusiness Thankyou brother So powerfu because your next video I hope it will help me to achieve my dream.
You are welcome.
Please check other valuable videos on my channel related to excel
This was so helpful thank you so much
You're so welcome!
I’m a starter , thanks for the detailed info
You are welcome and stay tuned for more informative videos like this and overall business
Thank you for this but I have a worry at the level of pulling the calculation formula to apply through the other products 😊
Glad it was helpful! and pulling formula in excel always work, what issue you are facing?
Thank you!
You are welcome
Nice one, its really good to learn how to work with this software
It really is!
Stay connected for more videos like this
thanks you for your show .
Thanks for watching!
Thank you so much its help me a lot how to handle inventory stock
Happy to help, i am working on an stock control sheet where you will even be able to include all in's and out's of your inventory and it will mostly automate the process
Hi, @familyislove6766
I have created an updated version of this stock control sheet and I hope you will like it. th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
Amazing video! Easy to understand and so direct 💯.
Thank you.
Glad it was helpful!
Stay connected for more informative videos - Coming Soon
Thank you for the help. You are a life saver !
Glad to hear that!
Stay Connected 😀
Thank you this video very helpful
Glad it was helpful!
Thanks for the info. Subscribed.🎉
Thanks for the sub!
Thanks to you it helps a lot
Happy to help, stay connected for more videos
Thanks for a good template.
Glad you like it!
Thanks mate. That helped.
Glad it helped, please check the new stock control sheet on my channel that is a more advance version than this one. 🙏
Brilliant work
Thank you
good information
Thanks, stay connected
Thank you soo much sir it was helped me ❤️
Glad to hear that
Please check updated version of stock control sheet on my channel that is advance version than this one
Thank you so much bro.
🙏🙏🙏🙏🙏🙏🙏🙏🙏
Always welcome
that was amazing, really thank you
You are welcome, stay connected for more videos like this
Very beautiful project in excel
Thank you and stay connected
I would love for you to make us a excel sheet for a self employed person
Hi Tracey, I can make a customized excel sheet for you but that would be a separate paid task. @traceychivers1988
My Services: www.buymeacoffee.com/brainbehindbiz/commissions
Sheets and discussion: www.buymeacoffee.com/brainbehindbiz/extras
Thanks I learnt a lot
Glad it was helpful!
First time here, thank you for the video. May i ask on the status column on the formula where is 20 coming from?
Hi dear, this 20 is just a imaginary number where I want excel to warn me about the stock level you can use whatever you like lets say 10 or may be 100.
Very helpful! Thank you
Glad it was helpful! stay tuned for more videos
Thank you, thank you, thank you!!!!!!
You are welcome. Stay connected
good way to explain.
Thanks for liking. stay connected
You are the best!!!!
Thanks, check out latest video of stock control sheet with advance features
That was really good man thanks
Glad you liked it!
Please check this new interactive stock control sheet video at th-cam.com/video/-FGLhhifShQ/w-d-xo.html
Stay connected 🙏 @JWN154
What i mean is after applying the formula on the first cells,to Avoid repetition on the next you pulled through but when i pull through no figures appears on the next cells
You have to pull formula down and figures will appear in cells below it not next to it
Good and ez tutorial thank you for the video
Glad it helped - Stay connected
Very good.. sir, 👍
Thanks and welcome
Sir love this effort ❤
Glad to hear that. Stay connected for more amazing videos like this
You da man.. thank you!
You are welcome, Stay connected
Thanks
You are welcome
Thank you.
You're welcome!
Very helpful sir
Thank you for the comment, stay tunned for more amazing videos
thanks
you sir
Most welcome
Thank you very much
You are welcome.
Stay Connected 🙏
I hope this work with pet and poultry supply business 😊
Hopefully it will work for you otherwise you can check this updated stock control sheet th-cam.com/video/-FGLhhifShQ/w-d-xo.html
Thank You !!!
You're welcome! Stay connected for more amazing videos like this.
Job well done
Thank you for your comment.
Check out new stock control sheet with updated th-cam.com/video/-FGLhhifShQ/w-d-xo.html and share your thoughts about it 🙏
I like your Excel sheet
Thank you
bohat ache se bataia apne.. ❤ lekin pura right nahi tha apka teaching
Okay sir g kaise pura right nahe tha?
Thanks sir
All the best
Some retail businesses find it difficult to record each item sold , so they prefer to work with sales summary how can we handle their records to show the value of inventory sold?
Thank you for watching, I have created an advance version of stock control sheet for that purpose, please check that on my channel
Do you have inventory and sales mobile software, cloud based, multi users, multi locations?
We can use google sheet instead of excel to make it multi user and multi location
@BrainBehindBusiness please can make inventory that can track my debtors and piece as well
Yes, I can make but that would be complicated to mange inventory and debtors at the same time, you should use two separate sheets one for inventory other for debtors.
please include the monthly sales
For that please check an updated stock control sheet on my channel at th-cam.com/video/-FGLhhifShQ/w-d-xo.html - You can update that on daily basis
This is cool and all but what happens now when I buy more stock I can't add it to this snd see what I've sold previously
for that we have an advance version of stock control sheet which has more features than this one where you can add and sell stock as per your business
th-cam.com/video/-FGLhhifShQ/w-d-xo.html
thank you but I wanna track my inventory decrease or increase can you write for me the formula just for stock inventory
Yes I can make something for you as per your requirements but please check an updated stock control sheet on my channel at th-cam.com/video/-FGLhhifShQ/w-d-xo.html which has functions of increasing and decreasing inventory. This might solve your issue if not please let me know
Easy! Thank you!
You're welcome! stay connected for upcoming video which is advance version of this. 🙏
اسلام علیکم can you please teach us how to make a software for shop
Teach us to make a software❤❤❤❤
Thank you for watching, you can find a advance stock control sheet on my channel which is suitable for a shop
Kindly explain for me on the inventory and sales values?
Inventory value is cost of your purchases and sales value is value you have sold (Revenue)
Thank you
You're welcome
Thank you boss
Any time
Great🎉
Thank you! Cheers!
sooooo helpful
Glad it helped!
Stay Connected
Interesting insights thanks for sharing
You are welcome and there will be an advance version of the stock control sheeting video coming soon. Stay tuned
thank you!
You are most welcome, stay connected for more amazing videos like this
what do you thing now
What if you will have the same product below but with a different Qty sold? How will you get the available stock?
It will work in the same way just figures will be different.
Please re watch the video and you will know that you can add all figures as your own
So good.
Thank you
this is wow!
Thanks, stay connected
Thanx
You are welcome, Stay connected
Please any one tell me which formula apply in inventory value pleade
Inventory value is Qty in hand X Unit Price
I have used "Product" formula but you can multiply Qty in hand with Unit Price.
Thank you, my question is how to add new products ?
You are welcome, You can add products to the product list as many as you want, you just need to drag formulas beside it.
Please check this new interactive stock control sheet video at th-cam.com/video/-FGLhhifShQ/w-d-xo.html and I hope you will like it too
Stay connected 🙏
Thanks sir...
Welcome, Stay tuned for more informative videos
Can you please make a video on pivot table?
Sure, I will make one very soon
For unit price is it what you bought the unit for or what your selling the unit for
ITs selling price but for proper selling price and costing you can check my updated stock control sheet on my channel which has all these details in it.
@@BrainBehindBusiness Thank you :)
Is there a way to compile all the reorder cells (item, reorder amount) into an email and send to the supplier?
No thats not possible with excel alone
thank you :)
You're welcome! Stay Connected
Please outline function of excel you have used for report in warehouse...please answer
I have used many functions like product, sum etc
@@BrainBehindBusiness most important reputed one need sir.
Product is repeatedly used
@@BrainBehindBusiness can you please help me to find a job In UAE..I In deira dubai right now..
How can I help you find a job in UAE.
Keep applying and you will get one soon
Check famous websites but stay alert there are many scammers as well in Dubai
Very easy to follow i subscribed immediately 😀
Awesome, thank you!
Thanks kindly Brain Behind Business...
But if you come back tomorrow and makes another sales how will you minus??
Am not using laptop...
Beside am using stockbook...
I am working on an updated version of stock control sheet so you will be able to do that in new sheet.
Stay tuned
Hi, @okaforchidimmablessing2992
I have created an updated version of this stock control sheet and I hope you will like it because it has the options which you were looking for th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
Nice one, Do you have a telegram channel where we can have a discussion?
Thanks, how may I help you? do you want this sheet or want me to create something for you like this?
Hi, this is very helpful, is there a way to make and automate it continuously for different days?
I am glad that you liked it, actually automation is not available in this sheet but I will soon release an advance version of this in that you can automate all in's and out's of the inventory.
Hi, @matthewadebiyi6924 Sorry for being late but I have created an updated version of this stock control sheet and I hope you will like it. th-cam.com/video/-FGLhhifShQ/w-d-xo.html 🙏
How to update daily stocks in (Purchase IN) and Sales out?
For that please check this new interactive stock control sheet video at th-cam.com/video/-FGLhhifShQ/w-d-xo.html and I think your issue will be resolved 🙏 Let me know if you need any further guidance @JosephLouis
question:
it's a dumb question but do i update the quantity in hand whenever we restock and quantity sold whenever we sold something? do i not have to make another sheet of there is a restock? do i just add everytime? thanks im new to these
Hi @akidokii that's a good question as many people asked this and the answer is no you need to manually write stock in that sheet
But the GOOD NEWS is On the demand of you guys I have created an updated version of stock control sheet that is a advance version and you can manage ever entry and update like in(Purchase) and out(Sold) on daily basis on that sheet
Link: th-cam.com/video/-FGLhhifShQ/w-d-xo.html please like comment and share if you like it.
Stay connected for more amazing videos like this. You can also get a customized sheet for you business if you want o
Sir please make footwear shop excel sheet daily sale and purchase and most important things shoe size available?
I think this video will solve your problem, just add products such as X shoes with different sizes and Y with different sizes like this. th-cam.com/video/-FGLhhifShQ/w-d-xo.html