How to create simple IN and OUT Inventory System in Excel

Can you use this setup with a barcode scanner if so how would you intergrade it thank you

well done, u did a great job. is it possible to have this file ?

Thank you dear for such type of video

Thanks

Thank you for this great video. One question/suggestion: to solve the identical names issue, refer to item codes instead of item description and you won't need to change or edit the item descriptions.

You lost me in the stock inventory section bruh lol

Sir paano po kung di naccopy ung formula pag fill down ko

Great video. Shocking music - hypnotic/repetitive... had to turn it off.

This help me a lot in my first Barcode System. I made it in just an hour with more features. Thanks a lots for this gem!!

Thank you.

Hi Cris, this is an awesome video. What troubled me is my incoming stock has different batch numbers. How do i manage the inventory with the ever changing batch numbers?

Hello po s Purchased po ng dagdag ako kso ng rered ung availble stock khit n na I lagay k nmn s ITEM d p dn nya m kita pno po un d n k mka dagdag gang 59 lng

thanks for this video

I think I finally understand VLOOKUPs after this video!

how can I automate Code No in stock inventory table?

also if i have multiple entries "A1" in purchase table, how do I combine them in Stock inventory table?

Thank you Cris

Why music? Please talk us through what you are doing.

Can you do for aswey management?? Please?? Like how to maintain an asset register

hi i want this file can u email me

It's amazing!! Thank you so much for sharing this content

Aww... I got my DL and ssn From thomas davy on telegram and to my surprise I’m so happy and comfortable

Thanks for the referral I just purchased a good dL lookup site from thomas davy on telegram he is so nice.

NOT UPTO THE MARK

Instead of changing product name you should’ve just referenced the codes. That’s what codes are for.

How to download this template?

exactly what im looking for, thank you so much.

V4 is a problem, product name is repeated. I think you should choose U4

helps me alot!

Product name should be unique. I am worried about that. Thanks.

Thank you xoxoxo.U help a lot for my Quiz😂😘

Maybe its too late for me but this really helps me a lot. Thank you for sharing your knowledge.

what if the sales exceeds the received table. on that case how do we insert a function not to enter more quantity than received items ?

How i export this to Power Bi

your inventory look like easy but I would need to calculate profit and lose at the end of the month ect.

I am facing one issue in this sheet if we have same product or item code at different price how we can deal in this senerio?

thank you very much for this video

i hope you add tutorials like your are speaking at the same time

Thanks 🙏🏻

itry to follow your step but my vlookup formula always show error dont know why

Thank u

Thank you so much for helping us get control of our inventory and making it simple for us. I have a question with regards to the price/item. In reality, the price of an item is a variable. How do we account for it in this system?

Very good

Thank you so much sir!

hi, sorry but how do i expand my items list if ever i want to add products to the list of items i sell?

This REALLY helped a lot..thnx

please stop that iritating music

Do we need the annoying and distracting music?

Stocks are crashing bitcoin investment right now will be at every wise individual's list. In a month you'll be ecstatic with the decision you made today.

How can I make changes like unprotect category,items and so on

great job, but what happens when the received list is full? we need to delete the input in the row to make place for new one but that changes to quantity in the storage too,right?