Create Inventory Management System in Google Sheet | Complete Process

[@thebesttechnical3608]

Wonderful simple and clear explanation in words

[@NeotechNavigators]

Thanks

[@sandeepkakani-j5d]

Great explanation....!!! Thanks for sharing

[@NeotechNavigators]

Most welcome

[@Shahzaib_Ahmad1712]

​@@NeotechNavigators I'm getting 0 value in opening balance instead of 100 How can I solve it? There is no any mistake in formula

[@lineynide4672]

love this , thanks

[@NeotechNavigators]

Thanks

[@alexavenus6275]

Thank you so much for this. At least i won't have to spend to buy a worksheet like this. ❤ have a merry Christmas

[@NeotechNavigators]

Merry Christmas 🎁🎁🎁

[@adnanalmass1186]

It is simple and has all important things for warehouse operation

[@NeotechNavigators]

Thanks for your valuable feedback

[@theahmedmamun]

Sir we are from bangladesh.Thanks

[@NeotechNavigators]

Most welcome

[@YippeekiyayResetZero]

This is very helpful for people like me who really wants to understand and know how to make such like this in google sheets. I am vwry much new at this. I would like to ask for more help if how to add the cost and total for each item and how to sort this or search by location? Thank you very much for giving us the opportunity to learn from you. 🙏

[@NeotechNavigators]

Thanks. Will add the more features in the next version

[@alexavenus6275]

Yes, thank u for making this comment. I also like that.

[@SanjaySinghChauhan007]

welldone..impressive..now create payment ledger sheet for retailers.....

[@NeotechNavigators]

Sure will create

[@RaviKumar-ri5kx]

Very nice explanation

[@NeotechNavigators]

Thanks

[@ajaykaushik7263]

Sir, you are fabulous it will help me a lot to do my work so easily.

[@najminmaliki9472]

thanks so much this is so good!

[@NeotechNavigators]

Most welcome

[@satbirkumar9766]

Bhut khoob sir maja aa gya hindi mein bhi banya karo sir video ❤

[@NeotechNavigators]

Thanks

[@RohitYadav-vv6hg]

This is very good, thank you!

[@NeotechNavigators]

Most welcome

[@Mr7sushil]

THANKS... I AM GOING TO USE THIS

[@22jewelryco26]

Thank you for for this wonderful video. Please after entering the formula for the 'Opening Balance' 11:24 , it keeps showing 0. I have checked and rechecked the formula and nothing seems to be wrong, can you help me please? Your response is highly appreciated

[@Shahzaib_Ahmad1712]

Have you solve this error?

[@THEQUILTINGOWL]

Thank you this was wonderful, could you show how to rank best customers or products, thank you

[@DudsDummy]

why is my available stocks in product search not accurate? I dont understand the opening balance and closing balance

[@GetFitWithMozi]

13:13 - everything is fine while I am trying to add a new entry and check, in the summery sheet its not reflecting changes, please let us know what went wrong?

[@vixzer]

make sure date format di top left in summary sheets is formula

[@jaiminprajapati6365]

In my project an item is located in many places. So, what formulas can be used in "19:32" a product search sheet?

[@karthi2714]

For some reason In & Out is not working for me

[@rishabhtiwari1763]

Same

[@rishabhtiwari1763]

How to fix this problem..?

[@TechTopia_Link]

I made a sheet like yours. But date wise closing stock opening stock is not auto updating. Please help me!

[@alexavenus6275]

Hi, I also made a sheet like this. Opening and closing balance auto updates on mine. If you're worried it's not auto updating maybe you are expecting the "in" & "out" to regularly update it? But it won't cause it's formula is set to the current date. Unlike the opening balance which is formulated less than the current date. I hope you get my point because I don't think I make myself clear

[@roialnet]

Thank you for this, I created a new Inventory Management using Google Sheet based on yours and have to modify a little bit to account for Cost per Item and FIFO which I needed for my accounting software.

[@YippeekiyayResetZero]

Can you help me on how to add the cost and total of each item and to sort by location?

[@muhammadasif-lu4yf]

Sir jo ap ne sheet ka link share kia h kia hum os ko edit nhe kr sakte kia .

[@JinelynDugang-th3lp]

❤❤

[@NeotechNavigators]

Thanks 🙏🙏🙏

[@swapnilmhatre8717]

Hi sir, how can I modify to add make and size in this sheet, and when I type product ID, size, and make want to show in stock, Vlaue can do that?

[@MoJo01]

I could not find the link to the demo Google Sheet file?

[@Rubeenaajeed]

hi, how to do product creation for same product with different sizes?

[@maloulallen108]

sir question, what if i have only 1 warehouse but i have 3 store / location to transfer item everyday. how i will compute the total qty transfer every month in 3 different location

[@twitteratitalks7105]

separate sheet for different stores will help

[@ajaykaushik7263]

sir please suggest how to add unit in this sheet

[@SHELLY-k8m]

product master data is not getting update, how to link it with input sheet

[@VsaraavananPMX]

Can i buy this sheet from you?

[@NeotechNavigators]

This is free of cost. Link is given in the video description box

[@ramsadhsameen4343]

Can we create this in ms excel

[@NeotechNavigators]

Please watch the below video kzbin.info/www/bejne/bJypnqGqacmUmJI

[@sycee3100]

Hello, I'm having problem with opening balance it become zero instead of 100 i can't see which formula is not okay.

[@Shahzaib_Ahmad1712]

Same here bro. Have you solve this error??

[@nuramalianadia872]

just use the link in description, im trying and fed-up and finding easy way😂

[@Shahzaib_Ahmad1712]

@@nuramalianadia872 I have resolved it.

[@Shahzaib_Ahmad1712]

@@nuramalianadia872 I have also create Google sheets like that but in a little nice way

[@briankisten3137]

Good day Sir, why am I getting a zero value return at point 12:33 minutes

[@vixzer]

make sure date in summary sheets is correct formula =today()

[@RealMelodyStar]

the fact i am doing this on 7th december 2024 exactly 1 year

[@eFilet-O-Fish]

It's a wonderful concept; however, it's restricted to viewing transactions only within the specified day requested. How can you modify and view transactions within a range of dates? ie: (week, biweekly, monthly)?

[@megabite3178]

how to record ledger of daily in and out of an item

[@NeotechNavigators]

Will create a video on this soon

[@tay.cosgrove]

Nice video! But why not include the link to the already made sheet for ease of following as you explain ?

[@NeotechNavigators]

We have added the link in the video's description box.

[@tay.cosgrove]

awesome@@NeotechNavigators . I would like to add a barcode line between the Product ID and Product name, so that the Product ID when entered will also automatically show the relative Barcode number, and I am getting an ERROR message. What do you advice?

[@Jurickh]

Me to @NeotechNavigators same problem here

[@nstocib3591]

Give a video on whether automatic salary pay slip can be done through Google Sheet

[@NeotechNavigators]

Sure. will create soon.

[@renavelardo788]

can i ask for a copy of this file?

[@NeotechNavigators]

File link is in the videos description box

[@msmsajal8334]

Need Download link this format. For use

[@NeotechNavigators]

Link is in videos description box or visit our website WWW.NeotechNavigators.Com

[@mdsafikulislam9113]

How to include Image. Please Help

[@Abhishekkumar-lw5jo]

sir footwear ka liya bhi banao

[@NeotechNavigators]

sure. will create soon

[@DkcarplanetuaeDeepak]

opening balace showing zero how to fix that error sir,

[@ronanandres7862]

Im having the same problem.

[@Gaurav-lt4de]

In and out of stock is not reflecting

[@easylife6987]

How I contact you?

[@SushilKumar-j9o4z]

Hello sir kya aap es sheets ka formet de sakte hai . jisse mai acchi trah se sheekh sakoo .mujhe ye sheet bahut acchi lagi hai

[@NeotechNavigators]

We have added the link in the video's description box.

[@masoombhatti3172]

i want to add a return section can you guide me how i add this i try butt not get success.

[@NeotechNavigators]

Will add in next version

[@anitabhateja5771]

Please show inventory with BOM for manufacturing firm

[@badruddin78]

Can we have traceability by serial number and lot number How I can contact with you?

[@NeotechNavigators]

Yes we can, I will try to in next version

[@badruddin78]

Please let me know

[@msmsajal8334]

Need Download link

[@NeotechNavigators]

Link is in videos description box or visit our website WWW.NeotechNavigators.Com

[@travellerraj3261]

HOW CAN DO IN CYCLE FOR MONTH TO MONTH

[@NeotechNavigators]

Yes we can

[@ismartsuvoo]

same problem...but how can i do?

[@muhammadasif-lu4yf]

Jb hum edit krte h to Request edit Access kehta h

[@khadarhassan711]

THIS FORMULA IS NOT WORKING I MEAN I CANT SEE Any number insed the OUT CELL PLEASE HELP ME (=SUMIFS('Input sheet '!$E:$E,'Input sheet '!E:E,"Out",'Input sheet '!$B:$B,$A6,'Input sheet '!$A:$A,$B$3)

[@trolledto8476]

Same here after putting formula 0 opening balance