Create Inventory Management System in Google Sheet | Complete Process

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:

Project Plan (Gantt Chart) in Google Sheet | Step by Step tutorial

Create Attendance Template in Google Sheet | Complete Process

Best Google Sheet To-Do List You've NEVER Seen! Step by Step tutorial

How to create dynamic Calendar in Google Sheet

Conditional formatting in Google Sheet Chart | Step by Step tutorial

[adnanalmass]

It is simple and has all important things for warehouse operation

[Michellemkm]

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

[cspbxwy]

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

[pctohvb]

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

[kwgbgdh]

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

[maloulallen]

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

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

[SanjaySinghChauhan]

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

[Honeybea]

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?

[satbirkumar]

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

[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)?

[muhammadasif-luyf]

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

[nstocib]

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

[MoJo]

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

[mtkjpfu]

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

[SHELLY-km]

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

[tay.cosgrove]

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

[jewelryco]

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

[masoombhatti]

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

[megabite]

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