Create Inventory Management System in Google Sheet | Complete Process
Vložit
- čas přidán 26. 07. 2024
- Hello Friends,
In this video, we have explained how to create an Inventory Management System in Google sheet. Below are the features of this template:
Product Search: You can search any product using Product ID and you can see the Available Stocks, Location within Store, Re-order level and Re-order required or not.
Inventory Summary: In this sheet tab, we have displayed the summary of all products as on today. Here we are showing, Opening Balance, In, Out, Closing Balance, Re-order level and Re-order Required or not.
Input Sheet: In this worksheet, User needs to enter the transaction data for In and out Qty for the product.
Product Master: In this worksheet, user needs to maintain the product details including the location of the product within store and re-order level.
Below is the google sheet link for Inventory Management System:
neotechnavigators.com/invento...
Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial
• Project Plan (Gantt Ch...
Create Attendance Template in Google Sheet | Complete Process
• Create Attendance Temp...
Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial
• Best Google Sheet To-D...
How to create dynamic Calendar in Google Sheet
• How to create dynamic ...
Conditional formatting in Google Sheet Chart | Step by Step tutorial
• Conditional formatting...
This is very good, thank you!
Most welcome
Great explanation....!!! Thanks for sharing
Most welcome
@@NeotechNavigators I'm getting 0 value in opening balance instead of 100
How can I solve it? There is no any mistake in formula
thanks so much this is so good!
Most welcome
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.
Can you help me on how to add the cost and total of each item and to sort by location?
It is simple and has all important things for warehouse operation
Thanks for your valuable feedback
why is my available stocks in product search not accurate? I dont understand the opening balance and closing balance
Thank you this was wonderful, could you show how to rank best customers or products, thank you
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?
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. 🙏
Thanks. Will add the more features in the next version
welldone..impressive..now create payment ledger sheet for retailers.....
Sure will create
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
Bhut khoob sir maja aa gya hindi mein bhi banya karo sir video ❤
Thanks
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)?
I could not find the link to the demo Google Sheet file?
Sir jo ap ne sheet ka link share kia h kia hum os ko edit nhe kr sakte kia .
product master data is not getting update, how to link it with input sheet
Give a video on whether automatic salary pay slip can be done through Google Sheet
Sure. will create soon.
sir footwear ka liya bhi banao
sure. will create soon
How to include Image. Please Help
Nice video! But why not include the link to the already made sheet for ease of following as you explain ?
We have added the link in the video's description box.
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?
Me to @NeotechNavigators same problem here
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
Have you solve this error?
how to record ledger of daily in and out of an item
Will create a video on this soon
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
We have added the link in the video's description box.
i want to add a return section can you guide me how i add this i try butt not get success.
Will add in next version
Hello, I'm having problem with opening balance it become zero instead of 100 i can't see which formula is not okay.
Same here bro.
Have you solve this error??
just use the link in description, im trying and fed-up and finding easy way😂
@@nuramalianadia872 I have resolved it.
@@nuramalianadia872 I have also create Google sheets like that but in a little nice way
For some reason In & Out is not working for me
Same
How to fix this problem..?
can i ask for a copy of this file?
File link is in the videos description box
How I contact you?
Can we create this in ms excel
Please watch the below video
czcams.com/video/6kFmnt4dab0/video.html
opening balace showing zero how to fix that error sir,
Im having the same problem.
Can we have traceability by serial number and lot number
How I can contact with you?
Yes we can, I will try to in next version
Please let me know
Jb hum edit krte h to Request edit Access kehta h
HOW CAN DO IN CYCLE FOR MONTH TO MONTH
Yes we can
same problem...but how can i do?
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)
Same here after putting formula 0 opening balance