Stock In Out and Balance Tracker in Excel | Auto suggest inventory order quantity

Подписаться 12 тыс.

Просмотров 286 тыс.

50% 1

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...

Опубликовано:

3 сен 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 315

@valerier7123 День назад

Thank you! Exactly what I needed. I was able to follow your instructions very easily.

@increase-work-productivity 9 часов назад

Welcome 🙏

@andywaterhouse161 2 года назад

Very useful thank you, ive adjusted it slightly for a project im working on and its perfect.

@raghavendrakulkarniprerana9027 10 месяцев назад

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,

@increase-work-productivity 10 месяцев назад

Thank you for the appreciation 🙏

@roysee4455 Год назад

Very simple yet effective inventory worksheet. Thank you

@increase-work-productivity Год назад

Welcome 🙏

@user-io2kg4du8v 4 месяца назад

Excellent teaching and moved slow enough to follow. Amazing!

@increase-work-productivity 4 месяца назад

Thank you 🙏

@thojp002 Год назад

Easy to follow instructions, works perfectly, cheers mate

@increase-work-productivity Год назад

Thank you 🙏🙏

@aynoormohomad3015 4 месяца назад

A lesson I was looking for. Very good & clear explanation I 'm from sri lanka. Thank you very mach sir, God bless you.ok

@increase-work-productivity 4 месяца назад

Thank you

@xanderisleta1232 2 года назад

Amazing Content..i remember my mentor in SAP who's Bangladesh Woman Indirah S..approved from 🇵🇭

@RahulTiwari-re7vt 2 года назад

Really very useful and easy to use... thanks

@nycolefuller6792 2 года назад

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

@increase-work-productivity 2 года назад

Thanks

@mosesgoodluck5209 Год назад

How did you set it up my procurement suggestions is responding

@iZacq 2 месяца назад

@@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

@faithmunyutha3087 Год назад

Thank you for this video, its just and exactly what i was looking for.

@increase-work-productivity Год назад

Welcome

@abhisheksamantray5244 Год назад

After Watch this Video, I immediately Subscribed your channel sir

@increase-work-productivity Год назад

Thank you

@akshaygaikwad5540 Год назад

Awesome, very helpful information sir ,thanks for spreading knowledge... knowledge is everything.

@increase-work-productivity Год назад

Thank you so much 🙏

@KristinePellegrino 4 месяца назад

This was extremely helpful, thank you!

@martintopo5511 3 месяца назад

Thank-you for Sharing a very useful information here. Very beneficial to my current role.

@increase-work-productivity 3 месяца назад

Welcome 🙏

@pramodparnami6012 11 месяцев назад

Just Loved your Cheque Receipt software, regards from Noida

@lebogangsekolo7594 Месяц назад

this was extremely insightful

@targetbasedlearning5576 2 года назад

Thank you for this video, it was reeeeaaaaly helpful.

@increase-work-productivity 2 года назад

Thanks and welcome

@feqeruwa9208 Год назад

thankyou for your useful and clear suggestion this was exactly what I want

@increase-work-productivity Год назад

Thank you

@christianmayongue Год назад

Thank you for this great tutorial. Bless you.

@increase-work-productivity Год назад

Welcome 🙏

@user-qk3tk5wj8z 8 месяцев назад

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.

@increase-work-productivity 8 месяцев назад

Thank you🙏

@yusuffsesay7331 Месяц назад

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.

@increase-work-productivity Месяц назад

Glad it was helpful!

@eziomachinagorom8500 Год назад

This is to the simplest way of understanding thanks

@increase-work-productivity Год назад

Thank you so much 🙏

@saurabhpaswan2871 3 года назад

Really great work 🙏🙏🙏

@user-fn3rk6nm7r 11 месяцев назад

Thank you so much bro. I love your way to explained. ❤❤❤

@increase-work-productivity 11 месяцев назад

Welcome 🙏

@shabanabaig7508 Год назад

it was so easy and productive,really thanks

@increase-work-productivity Год назад

Welcome 🙏🙏

@eyramnumasor1187 22 дня назад

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 ❤

@prabatvq5338 Год назад

Woow....It was the simply Best video I have seen on this flatform. Wish you all the best Bro

@increase-work-productivity Год назад

Thank you so much for your inspiring comment

@wesamnaem3506 2 года назад

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!

@monbasir5595 11 месяцев назад

Thank you for sharing this video.

@increase-work-productivity 11 месяцев назад

Welcome 🙏

@jonesmafunga1634 9 месяцев назад

wow! this is really amazing, thanks for sharing.

@increase-work-productivity 9 месяцев назад

Welcome 🙏

@sonoropro Год назад

Thanks Buddy that was so helpful

@user-km3fw1ny6w 5 месяцев назад

Perfect.... Love the way you explained it...

@increase-work-productivity 5 месяцев назад

Thanks a lot 😊

@Sky-xg6ck 2 года назад

Thanks for sharing 🙏

@innocentndifireke5133 2 года назад

Thank you very much, this is very helpful

@increase-work-productivity 2 года назад

Thank you

@amilathushara1911 2 года назад

Thanks, BRO...Great Work...!!!

@tonyteresapalla3371 Год назад

I suggest using named tables and have different sheets for the stock in and out

@stanleyakpanah2408 Год назад

Great Job 👍. Thank you so much.

@increase-work-productivity Год назад

Most welcome 🙏

@saurabh17sharma68 3 года назад

Nice one

@rolandtambio Год назад

Can you add a column to the “out” when inventory is sent that will track the expiration date?

@shultonphiri1124 Месяц назад

Very helpful and easy to follow.

@increase-work-productivity Месяц назад

Great to hear!

@Babafixit 2 года назад

A great and amazing Watch to this video from pakistan

@increase-work-productivity 2 года назад

Thank you

@mayurimaheshika1912 3 года назад

hello sir. keep it up. thanks ❤❤

@muideenakanbi6087 3 месяца назад

Wow! Amazing template, please kindly help factor in Damages and Returns in the next update video. Thanks well done.

@cindyc6703 3 года назад

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.

@increase-work-productivity 3 года назад

Thank you for the valuable suggestion

@jayem4467 3 года назад

Yeah anyone wanting to skip the intro... He starts at 15:00

@margaretsusan4533 2 года назад

Either way i like what they did. Thats what a good teacher does, stARTS WD intro then main subject.

@reshentertainment7655 2 месяца назад

Superb sir I will try

@asimsiddiq475 3 года назад

very good.

@BalaiKusina 29 дней назад

very informative thank you i learned a lot

@increase-work-productivity 29 дней назад

Glad it was helpful!

@crystalgiovanni4182 2 года назад

Thank you, sir!

@increase-work-productivity 2 года назад

Welcome

@vijays1157 11 месяцев назад

VERY USEFUL

@mohammednahari1204 2 года назад

Thank you very much!!!

@increase-work-productivity 2 года назад

@007Optima Год назад

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

@increase-work-productivity Год назад

Ya, this can be done monthly or yearly. Values can be linked to other sheets to analyze trend.🙏

@abduljalil1144 2 месяца назад

very useful video thank you so much.

@increase-work-productivity 2 месяца назад

Glad it was helpful!

@sofnak Год назад

thank you.. it was very useful.

@increase-work-productivity Год назад

Welcome

@extra6839 Год назад

can we get one for manufacturing business where we enter raw material, usage and product sale? along with summary page

@norulhashim7495 2 года назад

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?

@increase-work-productivity 2 года назад

For October month, you have to create a new file, closing stock of September will go to October by copy and paste

@norulhashim7495 2 года назад

@@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 👍🏽

@khairmohammadAmiri 9 месяцев назад

this was a fantastice video, if possible please make this stock manangement with item price and caculations.

@increase-work-productivity 8 месяцев назад

Okey, we will definitely work into it.

@Getfitwithkhurram 7 месяцев назад

Great video - after applying the formula my upper cells of stock out aren't working. Can you help?

@feasibleopoku8990 Год назад

Pls can we update dx template with different stock items that x not part of the list of known stock items.tnk you

@fatimaskaikay 3 года назад

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.

@increase-work-productivity 3 года назад

Plz visit below link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q9PaPMW657g.html

@ngengngenggg 11 месяцев назад

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 🥺

@increase-work-productivity 11 месяцев назад

Each order should be kept in separate column, once received, need to change T to R

@inwizyprivatelimited 6 месяцев назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m6yBIQ-GQRg.html@@increase-work-productivity

@iZacq 2 месяца назад

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*

@antonellafarrugia6164 11 месяцев назад

Woww it worked thanks alot!!

@increase-work-productivity 11 месяцев назад

Welcome 🙏

@antonellafarrugia6164 11 месяцев назад

Do you have another formula which product sold the most? Like a chart? Thanks in advance 🙏

@shinningapperals568 2 года назад

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.

@myriambaiguerel2294 6 месяцев назад

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

@increase-work-productivity 6 месяцев назад

Hi, the template is available to download in the link given in video description

@DavidP-ko3bb 3 года назад

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

@increase-work-productivity 3 года назад

Hi, thanks for appreciation, opening stock is supposed to keep manually at the begining of the period.. month/year

@DavidP-ko3bb 3 года назад

@@increase-work-productivity ok thanks for the quick reply now I understand

@ebenezeryawarthur4021 2 года назад

What abt if u place order and the whole border is used what will u do

@antoniypetkov6959 2 года назад

Hello, can you share this spread sheet? It is good tool you have build

@honeylynmabulay5923 2 года назад

what does it mean for poke i cant understand .. or dollar sign ! please reply what keys on keyboard we click

@increase-work-productivity 2 года назад

F4 key, which applies dolor sign

@copperfrogdistilling1943 2 года назад

where can i download this excel document ?

@rizwanhaque3816 2 года назад

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

@lanadrebit9560 Год назад

👍👍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. 👍👍

@increase-work-productivity Год назад

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?

@yukapikin.3249 9 месяцев назад

How to update the formula and drop-down list validation. Thank you.@@increase-work-productivity

@naingnaingzaw7154 Год назад

thank you very much for nice format . Can I get template, Sir?

@unnikrishnan5035 2 года назад

Good

@josetristanmacasero6743 2 года назад

do you have a template for this excel sir its very useful im work

@gladysdomchak4952 5 дней назад

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

@samturner4666 3 года назад

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?

@increase-work-productivity 3 года назад

Its F4 key in Keyboard, F4 key is used to fix the cell reference in formula, alternatively we can also write dollar sign($)

@samturner4666 3 года назад

@@increase-work-productivity thank you!

@feqeruwa9208 Год назад

oh yeah it was my question too, Thankyou for your reply now I got it f4

@SumaiyaAkter-eu1cq Год назад

Nice ♥️

@increase-work-productivity Год назад

@ammswa4837 11 месяцев назад

thank y brooo

@increase-work-productivity 11 месяцев назад

Welcome 🙏

@user-wh2rb5sq6j 10 дней назад

Hi,what happen if we do not received all the transaction in the same date,how can we change the received or transaction.

@holex.6439 2 года назад

If there is a video about profit and loss, can you send the link or I'm waiting for you to shoot it?

@maminayinde589 Год назад

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.

@increase-work-productivity Год назад

That is F4 key in the keyboard, to fix the cell reference in formula

@mazenhou 9 месяцев назад

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

@mazenhou 9 месяцев назад

to be more clear, what should i do if i have more than 14 operation in the month?

@increase-work-productivity 9 месяцев назад

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

@mizanurrahman1217 7 месяцев назад

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

@ToperOnac 3 месяца назад

can you please explain (the min stockto be kept) what is that for?

@tajbir71 Год назад

if amount add then which formula applied?

@barbaratomayko1536 2 года назад

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

@barbaratomayko1536 2 года назад

just watched again and saw the steps to make this work. THANKS for the template. It is exactly what I needed!

@increase-work-productivity 2 года назад

Thanks and welcome

@ibrahimbah8764 Год назад

Sir I tried the f4key but it didn't work When I pressed the f4key it showed me project Sir can you please help me understand this please I need your correction please sir

@feasibleopoku8990 Год назад

Pls after the range in the sum if formula ... do I hear you say press the F4 key to pin the range or what.. please I don't get that part well

@increase-work-productivity Год назад

Its f4 key in the keyboard, to fix range by applying dollar symbol

@feasibleopoku8990 Год назад

Many tnks boss.God bless you

@nycolefuller6792 2 года назад

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

@barbaratomayko1536 2 года назад

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.

@joyceparas969 8 месяцев назад

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.

@increase-work-productivity 8 месяцев назад

Ya, In case of too many items, its quite inappropriate . This template best works in case we have limited number of items.

@oliviaawuorokinyi5065 3 года назад

for the sum if function which key are we pressing on the keyboard

@increase-work-productivity 3 года назад

F4 key, to fix the data range

@oliviaawuorokinyi5065 3 года назад

@@increase-work-productivity thank you so much. Amazing tutorial you have helped me so much with my business

@increase-work-productivity 3 года назад

My pleasure to share knowledge, Thank you

@atifhashimi4 17 дней назад

Hello; What do you mean by Fix the Column. fix the sumrange

@increase-work-productivity 17 дней назад

By pressing the F4 key in keyboard, that applies dollar symbols

@musabali2476 Год назад

Please assist on the formula after selecting after sumif and selected product range you said to press f4 key on the keyboard to fix selection i am pressing but not working

@increase-work-productivity Год назад

If F4 key not working, you can manually apply $ symbol by typing from keyboard