Ready to use Excel Inventory Management Template [User form + Stock Sheet]

Last Updated: January 16, 2024
puneet-gogia-excel-champs

- Written by Puneet

Sometimes it’s really hard to track stock or inventory in a normal spreadsheet. And you do need a template that can help you to track your stock effectively.

So if you are searching for an Excel inventory management template that can help you track your stock easily then you are landed in a right place. For me, it’s an honor to tell you that here I have an amazing template in which you can track your inventory easily.

This is an automated template that will help you to save a lot of time. As all the formulas and data sheets are already arranged this way you don’t need to do anything. It’s simple, quick, and easy to use and I’m sure you’ll love it.

Dashboard

Here all the important insights are in a single sheet. And, you don’t have to worry about updating it again and again.

ready to use excel inventory management template for free download with dashboard for insights

These insights will get updated in real-time, as soon as you add new data. This dashboard will help you to track the following important insights.

Current Stock

This figure is the current stock units as of date. It will update with every single entry done by you for stock-in and stock-out. It will calculate by deducting stock-out from stock-in.

check out current stock from dashboard in this excel inventory management template

Stock Value

Stock value is the total value of the current stock after deducting stock out from stock in. It’s calculated by using the unit price of each product.

stock value in excel inventory management template

Stock In

Stock In is the units you have entered in stock-in data in the current month. If you are using pro version you can use the drop-down to check stock in quantity for previous months as well.

stockin in excel inventory management template

Stock In Return [Pro]

This section will show you the stock-in units which you have returned back to suppliers. In pro version, you can track them supplier-wise.

track stock in in ready to use excel inventory management template

Stock Out

The stock out is the units you have entered in stock out data in the current month. Using the drop-down menu, you can check for other months as well.

stockout in excel inventory management template

Stock Out Return [Pro]

This section will show you the stock-out units which your customers have returned back to you. In pro version, you can track them customer-wise.

track stock out in ready to use excel inventory management template

Category Wise Stock

The current stock value is for each product category. You can specify the category for each product in the product master sheet.

category wise current stock in excel inventory management template

Product Wise Stock and Reorder Level

This part of the dashboard will show you the product’s current stock and value. It will also tell you about the re-order level of a product. And, you will get an alert message if the stock level is less than the re-order level. There is a drop-down to select different products.

product level reorder status in excel inventory management template

User Forms

You can use these user forms to enter data. I have managed user forms in this way that you have to enter minimum data. Here are the things you can capture with these user forms.

New Product

By using this user form you can create a new product. The best part is we are using data from the product master to fill other user forms with minimum data.

Stock In

Whenever there is new stock, you can enter that stock using this user form. In this user form, you just have to insert the product name (using a drop-down list), supplier name, and quantity. It will get the rest of the data from your product master sheet.

enter stock in in excel inventory management template

Stock Out

Use this user form to enter stock-out data. All you have to enter, is the product name, customer name, and quantity. The rest of the data will be captured from the product master sheet.

enter stock out in excel inventory management template

Invoice Generation [Pro]

In the Pro Version, you can also generate invoices. With an invoice generation sheet, you can instantly create invoices & track data on the sheet. It just works like a stock-out user form, but specifically for invoices.

You can create a proper invoice with all the customer details & further you can also generate a custom report as well. This form stores data in the same sheet where you have stock-out data.

generate invoices with ready to excel inventory management template

Data Sheets

You can access the data sheets where the entire data will capture from user forms. Every entry in user forms has a serial number which you can use to refer to it.

Product Master

Product Master is the most important sheet in this template. Your all products will be listed here with details.

stock in sheet in excel inventory management template

Stock-In Sheet

The stock-in sheet will contain your entire stock-in data. Each entry is captured with a unique serial number, and you can use that serial number to refer to a specific entry. And, if you are using the pro version, the stock-in return will also be captured here in this sheet.

Stock-Out Sheet

Same as the stock-in sheet stock-out will contain the entire stock-out data. You can enter your data in this sheet using the stock-out user form. Entries in this form are also captured with a unique serial number. And, if you are using the pro version, the stock-out return will also be captured here in this sheet.

Customer Details [Pro]

You can enter customer details in this sheet which will further use in the stock user form to track customer-wise stock details.

customer sheet in ready to use excel inventory management template for free download

Supplier Sheet [Pro]

You can enter supplier details in this sheet which will further use in stock in user form to track supplier-wise stock details.

supplier sheet in ready to use excel inventory management template for free download

Reports

In this template, all the major insights are on the dashboard. But, you can also extract the following reports.

Stock Report

This stock report will be generated from your product master sheet. It will give you a complete summary of the current stock.

stock report in excel inventory management template

Customer Wise Stock Out [Pro]

You have the option to create a customer-wise report with a pivot table for stock out. It will show you the quantity and values of stock out.

get customer wise current stock report in ready to use excel inventory management template

Supplier Wise Stock Out [Pro]

You also have the option to create a supplier-wise report with a pivot table for stock out. It will show you the quantity and values of the stock.

get supplier wise current stock report in ready to use excel inventory management template

Product Wise Current Stock [Pro]

In one click you can also generate a product-wise current stock report. It will show you the product-wise quantity and value of the current stock.

get product wise current stock report in ready to use excel inventory management template

Instructions

This template is user-friendly and easy to use, and here are some instructions to follow which will help you to use this template effectively

Menu Button

This template has a dynamic menu bar that has all the option buttons on it. You can call it anytime using this menu button.

menu button in excel inventory management template

From this menu bar, you can navigate to any of the data sheets, and user forms, and generate reports.

menu in excel inventory management template

Use the back button at the top of the menu bar to go to the dashboard

menu close button for excel inventory management template

Entering Data

As I have already mentioned that you have user-forms to capture your data. And, data from each user form will be captured into a separate data sheet. In the user form, after entering your data, click on the enter button to save the entry.

enter button in excel inventory management template in excel

Don’t

  • Change the name of any worksheet.
  • Delete any worksheet.
  • Add or remove any cell, row, or column in the user form.

Things You Can Try

  • You can create your pivot table from data sheets (available in the pro version).
  • You can take a printout of your dashboard.
  • Before using this template make sure to enable macros.

Download Your Template

654 thoughts on “Ready to use Excel Inventory Management Template [User form + Stock Sheet]”

  1. I would like to use the spreadsheet as it seems to answer my immediate needs for a small inventory management tool with a Charity I am helping out. I am in the UK and I would like to have the currency symbols as £ – is there any way that I can change this please?

    Reply
  2. Hi, I downloaded the pro-version and use the Invoice Generation to record stockouts. It works fine until the the stockout report reaches the row 999 and then it would not record any new Invoice transaction anymore. It just keeps on overwriting the last few rows every time you create a new invoice.

    Is there a limit of the number of transactions?

    Reply
  3. Hi
    Can the INV be changed to stock issue as all stock gets issued out
    and can you add a stock count function and bin locations then I will pay for the provision

    Reply
  4. pouvez me l’envoyer par mail s’il vous plait ? Je vois plus ou est le lien !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Reply
  5. Hi,
    can you please add feature to enter stock-in items with value to capture the changing purchase price of same product? the product master sheet will not have the value column then. the cost for stock out product can be based on First In First Out method. kindly let me know if it is possible to add it in this template
    Best Regards

    Reply
  6. Hi,
    I liked your Inventory and accounts managment Excel software .
    But i have to use on MacBook after some amendments as per my requirements .
    Pls. Let me know what charges for Amendment ?
    Pls. contact me to discuss.

    Reply
  7. I need to make IN / OUT entry of the material.
    I also need to make challans for vendors for material issue, is it possible to make such changes in pro version?

    Reply
  8. Hi, I downloaded the template from the link in my mail but it only has the dashboard the actual date sheet isn;t available, kindly Assist.
    regards,

    Mwiingu

    Reply
  9. i like this template and i think got to try with the PRO version, Do you have other payment options? aside from the paypal and card? i have GCASH in our country as our payment..

    Reply
  10. in entering stock out, how can I add a name (of someone withdraw stocks) that can also be seen in stock out data sheets? which data of employee that withdraws stocks can also be seen in stock out data sheets.

    cause i think that is the only missing.. and everything is perfect.. i really appreciate it for sharing it for free.. thank you so much. By the way, i am using your free excel Inventory management.

    Reply
  11. Hi, in the Pro Template, the drop down list for current stock vs. Re-order isn’t working on my Mac. Please help!

    Reply
  12. Hi there,
    System works PERFECT!!

    However, how can I change the currency from (USA) $ to (South African) R?

    Thanks,

    Reply
  13. Hi,

    can you please provide Garments Inventory Management System where we can record raw cloth , cutting , stiwtching and finished goods , also purcases and seles.

    Reply
  14. Hi Puneet,

    I downloaded the folder, only dashboard displayed. Not able to edit or no macro is working for me.

    Please help…

    Reply
  15. have entered the name and mail id but could not get through , was not able download the template . Please help out

    Reply
  16. Hi, I am working for humanitarian organization in Afghanistan, doing food basket distribution with 4 items
    I can not download the template, please share. and also our process a bit different do u think it will work
    Supplies(Flour-cooking oil-beans-salt) come to Main warehouses (3 main warehouses)
    Supplies moved to provincial warehouses
    Supplies moved to Food Distribution Point (FDP)
    Supplies distributed from FDP to beneficiaries

    Reply
  17. hi there i am trying to download the sheet but not able to do it after sharing my mail id.

    Request you to please send the same in mail

    will be great help to me.

    .

    Reply
  18. Hi, gone through the entire article. I seems really helpful to maintain and track the stocks please mail me template.

    Reply
  19. the only problem is that we need to update data for 400 products in daily basis which is not possible here manually.

    Reply
  20. sir ekdam easy hai, iska update version milega kya, aur aapka contact no. bhi send karna,
    very good job

    Reply
  21. Hi Puneet,

    Hope you are doing well!

    I am Nainika, a Procurement professional. Was in search of Inventory/Spare management with Reorder level. I think I got it from your sheet. Just loved It. But I am looking for changes/additions. Just let me know how you can be contacted. Please write me on the email mentioned below.

    Thanks!

    Reply
  22. Greetings, very nice template. I will need to add some info not presently in it.
    Is it possible, how to contact you

    Reply
  23. Hi,

    Thanks to provide Inventory Management TEMPLATE.

    I am facing the problem in Product Wise Stock And Reorder Level dashboard, I entered new product (as Grinding Disc), stock in & stock out quantities using user forms, but in dashboard did not show any status, only show N/A.

    kindly guide me
    Thanks

    Reply
  24. is this Template download ready to use or you need to Buy the Pro version to be able to start using it as I used the Downloaded template
    change Product to my items but it would not update the stocks in or outs of total

    Reply
  25. Hi Support,

    Good day!

    I hope that you’re well.

    I’m interested in your excel program. Is it possible to add a function to manage the Stock BIN location of the stocks and Pick lists management based on the inventory lists with respective reports? Also, keep tracks the movement of the stock and reports.

    I looking forward to hear from you soon.

    Thanks

    Reply
  26. Hello, I would love to work with your inventory file to help me work better as a supply chain manager.

    Reply
  27. Hello, I would love to work with your inventory file to help me work better as a supply chain manager.

    Reply
  28. Now for the big question before I continue with this template.

    I have about 2000 unique items that I wish to track. (about 26 categories)
    Will this template be able to work for such a high number of unique stock items and categories?

    Please excuse my ignorance as I am not very experienced with Excel.

    Reply
  29. Hi Paneet

    In the “Enter New Product” Sheet..
    You have formatted the Product ID cell as “Date format”

    Many of my product ID’s start with a zero.
    eg. Product ID 02807356

    Is there a way to overcome this?
    Can I add a ( ‘ ) before the number or change the format to text?

    Reply
  30. Hi Paneet

    In the “Enter New Product” tab..
    You have formatted the Product ID cell as “Date format”

    Many of my product ID’s start with a zero.
    eg. Product ID 02807356

    Is there a way to overcome this?
    Can I add a ( ‘ ) before the number or change the format to text?

    Reply
  31. Hi, can I know how much is the Pro version and what are features that I can customize in the Pro version?

    Reply
  32. Hi, there cannot download the template, have tried sending it to all my emails, but I’m not receiving any of your templates

    Reply
    • Go In Review Option then Click Unprotect Sheet. the sheet is not password-protected, it will unlock immediately.

      Reply
  33. Hi

    Tried the downloaded sample template. If we can’t amend the template means we will forever have the dummy stock in our inventory :).
    How do you charge for simple modification or add-ons?

    Thanks

    Reply
  34. hello i want this templet to use our office in indian RS. so can you change and fress templet send me with our comaopny name so i will pay

    Reply
  35. The given tempalate is of very much use & have simplified the issue of Inventory management.
    Thank You..!!

    Reply
  36. Thanks it really looks good. But I have tried to download it all in vain do you mind if you can send it via my email, please.

    Reply
  37. This seems great, but I registered my email address and I haven’t received Excel Inventory Management Template

    Reply
  38. Hello there,

    I have registered my email but have not seen the download link in my inbox. Please send it.

    Thanks

    Reply
  39. Good afternoon , I have registered with various emails but didn’t get the inventory management excel template in any of the emails (checked SPAM as well). Could you advise on the sending?

    Reply
  40. Small business that sells to other vendors.
    Hoping this helps to have a control on my sauce inventory in house

    Reply
  41. Holding on High hopes that this software will be the ultimate answer to my management of my organization’s stock levels and tracking thereof

    Reply
  42. it is very useful template. but why i cannot use to add any new product ?? it shows error message as password protected

    Reply
  43. Hi Puneet,

    I just downloaded the inventory template from your website and also checked the pro version features. It meets many of the features that I require to run a Automotive parts Business .However if the following additional features can be incorporated it will be great .Also what would the additional cost be to add them.

    1) Have a fields for 2 x additional part numbers for each item.
    2) Have provisions for 2 x currencies . Import currency and Local selling currency.
    3) To have rate conversion feature between the 2 x currencies.
    4) To have a template similar to the invoice template for adding supplier invoice information.

    Kind Regards

    Reply
  44. I need Excel Inventory template, to maintain receipts, issues, stock statement to maintain general store & engineering stores

    Reply
  45. I wanted an excel sheet that is simple to maintain sale, expense, purchases, credit bills etc with end of the month report and end of the year report for a small restaurant. How much do you charge for creating one

    Reply
    • My Need to S/N, Date, Customer Name, Address, Cell Number, Bill Number, Delivery Man, Product Name, Size, Quntity, Rate , Total Taka, DISC, Paid amount, Due amount

      Reply
    • how do I change the currency symbol in the workbook? I’m going crazy trying to find the way. thank you for your help!

      Reply
  46. Sir

    I need Excel Inventory template, to maintain receipts, issues, stock statement to maintain general store & engineering stores

    Reply
  47. How would you manage price changes for same product?
    Value of stock becomes a problem for stock take.
    can weighted average be built in?

    Reply
  48. Would have like to input multiple items for stock in and out. Single input will take to long.
    Order form would also be nice.

    Reply
  49. we have approx 300 items. Purchase price every time different we can not fix unit price. we didn’t want category wise stock in dash board .we want delivery challan returnable and non returnable challan not invoice. Report of item should display price .

    Reply
  50. I am trying to download the program. I enter my name and email but never receive the link. I would like to try this

    Reply
  51. Hi Puneet

    I liked your free template and tried using it though have some queries :

    Need to add few columns Unit, Packing description, additional for product type.
    I have one product list with multiple locations and each location need to maintain idle stock separately. The procurement happens centrally and as per requirement of re ordering stock report (based on closing stock of each location for that month – idle stock) is issued to each location. Would need consolidated as well as location wise reports. Also need to understand consumption for the month for each location.

    How do I achieve this?
    Regards

    S Patwardhan

    Reply
  52. Dear Concern,
    The inventory system is perfect for me, but i need to customize this excel file. If you don’t mind can you help me out.

    Thanks in advance

    Reply
  53. Hi, I want to upload bulk Entry for New product through uploading csv file. Manual Entry for huge items its take more time.
    Excel sheet is brilliant. Hope to listen from your side.

    Reply
  54. This is great, and it will be very useful in my department. But I only need to monitor our item for in and out, No price needed. Can I disable the auto-hide? and for the description to be pre-filled if possible.

    Reply
      • Hi Puneet,

        This looks like the exact thing I’ve been looking for for my dad.

        Would it be possible in the “stock in” function to add a “storage location” I.e rack 1 box 2, and would it then be possible to search the inventory when trying to locate where a sold product is being stored?

        Regards,

        Matt

        Reply
  55. HI PUNEET,
    I really liked your template, will like to go with pro version, before that i need some help, we have tiles business, so will you do customisation as per my requirement, there are some customisations i want in your template, pls reply at earliest.

    Reply
  56. I would like your free: “READY to use Excel Inventory Management TEMPLATE [User form + Stock Sheet]” Thank you!

    Reply
  57. I am interested in this product. I have a few questions?
    1. Can it used on MAC
    2. How Many products will I be able to add? I have over 2000 products
    3. Is it possible to add discounts on the invoice based on the product.
    3. Will I be able to create labels to print?

    Thanks

    Reply
  58. Hi Puneet,
    I got the FREE version of your excel. I liked and wanted to learn more about how the ‘ENTER’ in ‘EnterNewProduct’ formula/macro works. Can you please help me with it?

    Reply
  59. Hi

    How can i change the dates for stock in/out on free version?

    Could you please me the reply to my email.

    Thanks

    Reply
  60. I need a free template to be used the store managing dairy movement and weekly report (Status) kindly help with that short and clear one for test, Once it works we can go for another greater step.

    Reply
  61. it is downloaded with stock already in how do you clear to start with a fresh clean stock inventory?

    Reply
  62. Hi Mr. Puneet,

    Can I also have a copy of your template ? I can’t access the download link of FREE VERSION.

    Please send me to this email

    yannax1998@yahoo.com

    Thank you so much in advance.

    Regards,
    YannaSilva

    Reply
  63. Hi, I would like to go for Pro version, before that could you please confirm below concern
    We having parts business, do we able to change stock items?
    Do we able to change the currency?

    Reply
      • Hey Veronica,

        WIth Developer Version, you can do all kind of customizations and if you go PRO version you can mail us you requirments (what columns you want to add) we’ll try to make it up for you.

        …with love, Puneet.

        Reply
  64. Dear Puneet, thanks for the templates, I have managed to download the free version but am unable to enter anything in it

    Reply
    • I have this question too; did you get a response by any chance?

      Does the Pro or Dev version allow for easy customization? I’d at least want to add additional header columns..

      Reply
  65. Are the fields modifiable for my specific application?
    As an inventory tool, does your programing include high/low limits and reorder points; programmed in?
    Is your template barcode capable to generate labels and record inventory based on scanning?
    I can send you a list my requirements if necessary.

    Reply
  66. Hi Puneet, I am from Chandigarh. I need your help.
    I want a simple excel Stock Management System for smartphones wherein I just need the EAN(Product ID), Description & Quantity. I want an excel where I just scan the barcode of the product and it automatically gets deducted from the actual stock likewise with the Stock In. Do you have such template?

    Reply
  67. Hi despite rying more 3 times, i am not receiving the link in my mail for the trial version.

    Can you please help me please

    Reply
      • Hello again,

        I don’t want to be rude but can I get an answer to these questions for my friend so we can see if we will buy this application/

        Thanks in advance.

        Reply
  68. Hello,

    I’m looking for a friend who is searching for a program that automatically can make an invoice for his customer. The problem is that every customer is getting a different discount on their ordered products.
    Is there any possibility to integrate this in your application, because I think that this is almost the perfect application for him.
    Also is it possible to set the currency into euro’s (€) and a choice to set another language? (Dutch).

    Please let me know.

    Reply
  69. Hello,

    I would like to find out how to get a custom document created for me. How can I get this started?

    Reply
  70. Can this template be used on a Macbook Pro? Also i would like to know if there is an option to create labels to print (Costumers and products). I am in desperate need of a Management Software for my company

    Reply
  71. Trying the free version before going for the pro version. Even on entering values in the user form, the current stock and stock values shows 0 and -ve. What am i missing?

    Reply
  72. Dear Sir,

    We haven’t received the mail regarding the downloading of the free trial version.

    Kindly advice

    Reply
    • You can use one drive to sync files between two computers, but you can’t use VBA to work with a file which you have opened in Excel Online.

      Reply
  73. Can you explain the advantage of Dev version
    How many user can use Pro version ?
    if it’s multiuser can I create user password ?

    Reply
  74. Hello

    I wanted to try your free version first before buying the full version, but I did not get the email.
    How can I resolve this?

    thanks

    Reply
  75. Hi there,
    I’m interested in purchasing your pro version. However I would like to see few screen shots or a video of how it works, if you have that please share it with me.

    Thank you

    Reply
  76. Hi, Thanks for your response. I have tried the free version and I think its suitable for me. However, when I tried to input the master data and stocks plus the price, the value on the very right cell is still 0? I made sure the format is in numbers but, I still get 0 result. Which part did I messed up?

    Thanks

    Reply
  77. does it work with excel office 365 2019 for mac? As per my past experience I faced lots of error with VBA on Excel Mac

    Reply
  78. Dear Puneet,

    I liked the excel inventory. is there any option to edit the product details or price of the product once entered

    Reply
  79. Many thanks you for the inventory management tool. I wanted to learn one thing which will allow me to monitor an inventory by getting alert from the excel when target is set. In simple word, how will i set my report to get an alert when the target given me is below the target

    Reply
  80. How can we fix the sale price of products and discounts so that employees cannot change while selling?

    Reply
  81. Hi is it okei to add location on it? and also i want to search by code and also per item. not by scrolling

    Reply
  82. Dear Puneet

    Thank you very much for the awesome inventory management tool. Also a special thanks for editing the sheet to have the currency from South Africa. Highly appreciated and will recommend and support you.

    Chris

    Reply
  83. Hello, I just downloaded the free version. How can I delete the info in the template? Is there an option to edit a product once entered?

    Reply
  84. Hi, Need a drop down list to see the single product category. and same need to required on “Product wise current stock vs. reorder level”
    one product category have different different product name, so can see categories wise.

    Reply
  85. Dear Puneet,

    I recently purchased the PRO version. Everything is great but i would like to ask a favour. Is it possible to have a searchable drop down for stock in and stock out as we have a long list of items?

    Reply
    • Close the template once and re-open it and make sure you have enabled your macros. Excel Options ➜ Trust Center ➜ Trust Center Settings ➜ Macro Settings ➜ Trust access to the VBA project object model

      Reply
  86. I’m having an error it displays “Cannot run the macro”excel-inventory-management-template.xlsm’!OpenMenu”. I have already done enabling the macros but i can’t still navigate the system.

    Reply
  87. Hi
    i have followed step as you told about macro setting in instruction . but when i open inventory template, this message pop in excel

    run-time error “1004”:
    Method “Worksheet” of object”_Global”failed

    what i should about this messages?

    2) can you please help in deleting old sample data? or is possible to send me excel pro to email without any sample data

    Reply
  88. i have given the request for free trial version with my email id yesterday at 2.02pm but till now didn’t receive any email

    Reply
    • Ankit this template uses macros and unfortunately, Excel’s IOS version doesn’t come with VBA functionality. I wish to serve you with this in future.

      Reply
  89. Hey Puneet,

    I am using the free version and it has really made inventory management very easy. All thanks to you for the effort you put in. I need the iOS version for the same, if you could please help me with it. Is anything for iOS available?

    Reply
  90. Heyy, Is there any iOS version available for the above template?? It would be really helpful if you can reply asap.

    Reply
  91. I have a doubt about the functioning. I work with a lot of electronic devices as monitors, cameras, etc. and each one of this products has a serial number, like an identity code (I imagine you know how it works). I need to register every serial number code to keep track of out product, to know when someone returns something it is certain that he/she got it from me.
    And another thing would be if i could make receipts out of this, so customers could sign it in prove that they already took what they bought.
    Thanks for your time.

    Reply
  92. Thank you i have just downloaded the free version . this is the template that i was looking for thank you.

    Reply
  93. i have paid 2 times for DEV version but it is not downloaded, if it is not available for Pakistan, then plz reverse the transaction
    .

    Reply
  94. i am unable to get the free version link on my mail inbox and want to know how much time the link available for me to download

    Reply
  95. When I click on the Download button for the free version it asks me to put in a first name and email ID. When I put in the information it says that an error has occured while submitting the data and to try again. I keep trying but I get the same thing. Please help if possible.

    Reply
  96. Hello Puneet,
    I hope you are doing well.
    I appreciate if you can please tell me how I can change the $ sign for Stock Value.
    I just want the numbers no $ sign.
    Looking forward for you quick and positive response.
    Thanks

    Reply
  97. how to reset the sheet. as there are few entries in the template.
    if we delete anything from any sheet. it effect the template result.
    or
    if i enter data in template. the sample data that is already in the sheet remains in the template.

    Reply
    • I see, but it will show all data, it would be easier if we can generate only re-order report in case we have many products.

      Reply
  98. Is it possible to generate the items which are below the re-order level on dashboard or any report? It’s quite complicate if I have to check it one by one from drop-down list on dashboard.

    Reply
  99. Hi i have send the query about the template but no response for last 2 days…anyone guess that still this template is useable for not ?

    Reply
  100. I bought this Excel Inventory Management Template and its AWESOME 🙂 . I love the way it has been design keeping in view that all features used are user friendly to understand and apply accordingly. I can see lot of efforts, time and hard work has been placed in this template. This is really saving my time and no problem in recording and analyzing the inventory position. Dashboard is a value added sheet in this template. I wish to see more templates by Puneet 🙂 Keep Rocking Brother 🙂 and Thank you so much again for making complex things simple for us 🙂

    Reply
  101. Need a help to implement it. How current stock level column does it work ? While stock outing out, there is no change happening in the current stock. Once we explorer we would like to go for pro-version

    Reply
  102. I just bought the Pro Template. Found all the hidden tabs and can’t believe how much work you put into this! What a great value for all the more you are charging. I consider myself an Excel Super User, but I will never be as “super” with it as you, Puneet. I’m struggling right now with keeping track of custom-made items for my employer; this will help me a great deal. I can’t wait to get back to work in the morning and try it out! Thank you so much for sharing all your efforts with us.

    Reply
  103. Hi Puneet,

    I was checking the template and its features a few days ago but forgot to come back and report how it went. IMO, is really useful and you’ve made a nice work with it. Thank you very much for sharing!

    Reply

Leave a Comment