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

Ready to Use Excel Inventory Management Template [User form + Stock Sheet]2016-08-11T12:12:58+00:00

Track your inventory in Excel, like a pro.

Sometimes it’s really hard to track stock or inventory in a normal spreadsheet.

And you do need a template which can help you to track your stock effectively.

So if you are searching for an Excel inventory management template which can help you track your stock easily then you are landed on 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 which will help you to save your a lot of time.

As all the formulas and data sheet are already arranged this way that you don't need to do anything.

It’s simple, quick and easy to use and I’m sure you’ll love it.

(1) Dashboard

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

Lite Version

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

PRO Version

ready to use excel inventory management template for free download with pro 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 following important insights.

Current Stock

This figure is the current stock units as on 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

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

Current stock value is for each product category. You can specify the category for each product in 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 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 re-order level.

There is a drop down to select different products.

product level reorder status in excel inventory management template

(2) 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 product master to fill another 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 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, product name, customer name and quantity.

Rest of the data will be captured from product master sheet.

enter stock out in excel inventory management template

Invoice Generation [Pro]

In Pro Version, you can also generate invoices.

​With invoice generation sheet you can instantly create invoices & track data into the sheet. It just works like 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 customer report as well.

This form stores data into the same sheet where you have stock-out data.

generate invoices with ready to excel inventory management template

(3) Data Sheets

You can access the data sheets where entire data will capture from user forms. Every entry in user forms has a serial number which you can use to refer 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

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 pro version, the stock-in return will also be captured here in this sheet.

Stock Out Sheet

Same like stock-in sheet stock-out will contain entire stock out data. You can enter your data in this sheet using stock out user form. Entries in this form are also captured with a unique serial number.

And, if you are using pro version, 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 stock out 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

(4) Reports

In this template, all the major insight 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 the complete summary for 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 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 pivot table for stock out. It will show you the quantity and values of stock in.

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

Product Wise Current Stock [Pro]

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

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

(5) 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 which 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, user forms, and generate reports.

menu in excel inventory management template

Use back button at the top of the menu bar to go to 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 from will be captured into a separate data sheet.

In user form, after entering your data, click on enter button to save the entry.

enter button in excel inventory management template in excel

(6) Things to Avoid

  1. Do not change the name of any worksheet.
  2. Do not delete any worksheet.
  3. Do not add or remove any cell, row, or column in the user form.

(7) Things you can try

  1. You can create your pivot table from data sheets (available in pro version).
  2. You can take print out of your dashboard.
  3. Before using this template make sure to enable macros in excel.

(8) Download Your Template

FREE Version

  • Dashboard
  • Stock In Form
  • Sto​​​​ck Out Form
  • Stock Report
  • Stock Return
  • Invoice Creator
  • Supplier Report
  • Customer Report
  • Developer Code

PRO Version

  • Dashboard
  • Stock In Form
  • Sto​​​​ck Out Form
  • Stock Report
  • Stock Return
  • Invoice Creator
  • Supplier Report
  • Customer Report
  • Developer Code

DEV Version

  • Dashboard
  • Stock In Form
  • Sto​​​​ck Out Form
  • Stock Report
  • Stock Return
  • Invoice Creator
  • Supplier Report
  • Customer Report
  • Developer Code
Content Protection by DMCA.com
  • edward says:

    i need to know how to clean the table to start using my staff,
    so i need a clean one
    asap

  • Ankit says:

    Really helpful. Best to maintain inventory.
    Need this for iOS is there any help available?

  • Ankit says:

    Heyy 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?

  • hamdi says:

    GOOD

  • Ankit says:

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

    • Puneet says:

      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.

  • Ignacio Sanchez says:

    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.

    • Puneet says:

      Hey, Lgnacio,

      In this template, you can create a unique Product ID code for each product and when you go with PRO version there is an option to create an invoice for each customer.

  • Nella Soobadoo says:

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

  • Pater says:

    Hi! Can I Use It with Barcode Reader.

    • Puneet says:

      You need to get the developer version and add a barcode font into it.

  • Anand says:

    Hi… I am not able to make payment. Pl. do revert us with needy support.

    • Puneet says:

      Hey, Anand please check your mail I have reverted with a new link for Payment.

  • Fokke Post says:

    Did not receive a link.. would try it

  • Michael says:

    Put email in to receive free version and get no response

  • Celeste says:

    didn’t received the link in mail. I tried to submit it twice.

  • Nandini says:

    Not received the link in mail.

    • Puneet says:

      Please check other folders as well, otherwise try again once.

  • Bunny says:

    didn’t received the download link

  • ibrahim says:

    Please Provide me the download link

  • Αικατερίνη Ανδρέου says:

    Hi Puneet, did not recieve the link

  • Umair Sattar says:

    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
    .

    • Puneet Gogia says:

      A mail has sent to you, please refer to that email.

      • Umair Sattar says:

        Sir, no email received yet

        • Puneet Gogia says:

          Can you please re-check Umair?

  • srinivas nuthalapati says:

    how much it costs

  • Sarmin Rain says:

    Please advice how to get the download link.

    • Puneet Gogia says:

      Click on download now in Free Version section.

  • Sarmin Rain says:

    Please help me to get the link of Inventory management template.

    • Puneet Gogia says:

      Please click on download now in Free Version section.

  • umakanta says:

    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

    • Puneet Gogia says:

      Link is active forever.

  • Atif N. Kakvi says:

    plzz send me or tell me where to download

    • Puneet Gogia says:

      Please click on download now in Free Version section.

  • gurvinder says:

    Trying to download the Free version ,but unable to download it.

    • Puneet Gogia says:

      Click on download now in Free Version section.

  • gurvinder says:

    Trying to download Free version but can not..please can send me the link

    • Puneet Gogia says:

      Sent again. I’m sorry you have faced this error.

  • Syloxane says:

    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.

  • Om says:

    Not working, please explain the process for using the link

    • Om says:

      Please reply.

      • Puneet Gogia says:

        Link is working very much, please try again.

        • Om says:

          Thanks.
          May be I am using it in a correct way.
          Please let me know the process.

          • Puneet Gogia says:

            I’m afraid I’m not able to understand you. You can write me on my email.

          • Om says:

            Thanks for your reply Mr. Puneet,
            May be I am not able the use the link in a correct way.
            Please let me know the correct process for using the link.

          • Om says:

            Waiting for reply.
            Thanks..

          • Puneet Gogia says:

            What’s the problem with the link.

          • Om says:

            Thanks.
            In the mail link, when I have clicked on the Download button for the free version its again asking 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, I think I am “not understanding” or “not using the correct link” which you have sent.
            Please guide me.

          • Puneet Gogia says:

            Sent again. I’m sorry you have faced this problem.

          • Om says:

            In you mail from “Disqus”, there is no link available.
            Thanks for all your support Mr. Puneet,

  • Om says:

    Please provide the link for Inv. Management System

    • Puneet Gogia says:

      Om, link is there.

      • Om says:

        Thanks Mr. Puneet.

        I have not received the link. Please provide.

        • Puneet Gogia says:

          Sent again. Please check.

          • Om says:

            Not working, please explain the process for using the link

  • Ram Gopal Chauhan says:

    How i can download this tamplete???
    If yes so please send the link on my mail.

    • Puneet Gogia says:

      Ram, link is there.

  • Haris Arif says:

    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

    • Puneet Gogia says:

      Hey Haris Arif, please unhide help worksheet and remove $ sign from it.

      • Haris Arif says:

        Where I can see this option ?

        • Puneet says:

          Unhide worksheet by right click on worksheet tab.

        • Puneet Gogia says:

          Right click on worksheet tab and unhide help worksheet.

      • Haris Arif says:

        Hi Puneet,
        Thanks for your reply.
        I am unable to change the $ sign from the product wise stock value where it shows the item in stock

        • Haris Arif says:

          I also need your help to change the $ sign in Daily Sales Report I am unable to change.

  • Taptronic says:

    I purchased this back in January 2017. Is this an updated version which I need to download now?

    • Puneet Gogia says:

      Taptronic, please share your registered email ID. I’ll send you updated version, if you have not received.

      • Taptronic says:

        It was originally purchased under: OPTIMALNAMES AT gmail DOT com on January 13, 2017 Thank you!

        • Puneet Gogia says:

          Sharing with you updated.

          • Taptronic says:

            So far no updated version at email address above..

          • Puneet Gogia says:

            Check your inbox now.

          • Taptronic says:

            Want to let you know that I received the template now. Thank you! One final question, about the Expense Tracker template from https://excelchamps.com/blog/expense-tracker I keep getting a 404-not found error after entering my name and email address. Can you send that template to me too?

  • Khilesh says:

    Hi.
    What a fantastic template.
    Question, how do I change the currency?

    • Khilesh says:

      Nevermind,
      Sorted it out.

  • Jatinder Kumar says:

    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.

    • Puneet Gogia says:

      Hey Jatinder, It’s very simple, select that old data (just data not headings) and right click and then delete. Just make sure you haven’t delete the entire table.

      • Jatinder Kumar says:

        Do i need to delete the old data from every sheet sfter unhiding each sheet
        Or
        Do i need to delete the data from stock report.

        Thanx in advance

        • Puneet Gogia says:

          There are 3 sheets for data ==> Stock In | Stock Out | Product Master.

          Do for stock-in and stock out as I said in the above comment. And for product master sheet, add your all the products first and then delete all the old.

          • Jatinder Kumar says:

            hi puneet.
            still struggling with the issue.
            stock in & stock out s fine.
            but when i add new product after deleting data in stock in and stock out sheet . serial number starts from 11 onwards in prodct master sheet.
            once new product data is added & stock in also added.
            if i try to delete old data from product master sheet. something went wrong as help sheet shows error resulted in wrong display of data in template

          • Jatinder Kumar says:

            HI PUNEET
            STILL STRUGGLING WITH THE TEMPLATE.
            CAN U SEND ANY BLANK EXCEL TEMPLATE SHEET .
            OR
            REPLY THE QUERRY.
            THANX

          • Puneet Gogia says:

            Just change that serial number to 1 that’s it. 🙂

          • MH Mohsin says:

            Hi Puneet Gogia,
            How can i change or disable Currency

  • Alsadiq Abbas says:

    i want to download the pro version please

  • Dilshad Ahmad says:

    Good

    • Puneet Gogia says:

      I’m glad you liked it.

  • NuaNear says:

    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.

    • Puneet Gogia says:

      You can generate stock report for that, entire data is there what you need to know about reorder.

      • NuaNear says:

        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.

        • Puneet Gogia says:

          That is possible but only in PRO version where you can generate a product wise report with total quantity, value and reorder level, instead of complete sheet.

  • Aditya Gorebal says:

    how to download sir

  • federico vaplor says:

    hello is there any free template i can download

  • Arifur says:

    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 ?

    • Puneet Gogia says:

      I have just replied you on your mail which you have sent.

  • Rahim Zulfiqar Ali says:

    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 🙂

    • Puneet Gogia says:

      Thank you Rahim for your valuable words.

  • Edmond Quiban says:

    WHATS THE PASSWORD SIR THANKS

  • K B says:

    Hi Puneet, did not recieve the link

    • Puneet Gogia says:

      Already sent. Please check your email.

  • Edmond Quiban says:

    Hi sir Puneet Gogia! can you please e-mail me? I have transaction for you thanks.

    • Puneet Gogia says:

      Hey Edmond, didn’t get you.

      • Edmond Quiban says:

        hi again sir! just wanna inquire how will you cost me if I order the same template?, but has a little bit customization according to my work needs. thanks sir. here is my email erquiban@gmail.com

        • Puneet Gogia says:

          Check Out PRO version.

  • Vigneshwaran Pitchai says:

    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

    • Puneet Gogia says:

      Try to download again and use it.

  • Brenda G says:

    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.

    • Puneet Gogia says:

      Thanks Brenda for your awesome words.

  • Nasir Sheikh says:

    Hi plz send me the download link in my in box nasirniaz.ns@gmail.com

    • Puneet Gogia says:

      Like is already there.

  • Diyana says:

    hi, what is the password for reviewing the code

    • Puneet Gogia says:

      Hello Diyana,

      Developer code is only available with Pro Version.

  • Mustafe Osman says:

    I can’t downloa

    • Puneet Gogia says:

      What problem you are facing?

      • Mustafe Osman says:

        my brother i can’t see the download link

  • CHANDAN says:

    can i put list of data at once in your template

  • CHANDAN says:

    How i can download this template

    • Puneet Gogia says:

      Hey Chandan.

      Download link is already there.

  • Nsh RDV says:

    CAN YOU SEND ME THE LINK PLEASE

    • Puneet Gogia says:

      Download link is already there.

  • william labian says:

    I want to view the code, there is requiring password? what is the password? thanks godbless

  • Shikin Tiansin says:

    i cannot download this template. please help?

    • Puneet Gogia says:

      Hey Shaukin,

      Please check your inbox.

      • Shikin Tiansin says:

        no link.. 🙁

        • Puneet Gogia says:

          Please check again.

  • 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!

  • Zubair MK says:

    Please send me the link. thank you

    • Puneet Gogia says:

      Link is already there

      • Zubair MK says:

        i got it, Very useful. thank you.

        • Mohammad Hasan says:

          Plz send me download link

    • Zubair MK says:

      i got it, thank you. Very useful.

  • How i can download this tamplete???

    • Puneet Gogia says:

      Hey Muhammad,
      Download from the link mentioned above.

      • i doesm’t found download link. please give me link on chat box

        • Puneet Gogia says:

          Check Your Mail.

          • i have no recv any download link in mail

          • Puneet Gogia says:

            I have updated the link in the post. Fill your email ID and download from there.

      • VML says:

        Hi, did the subscription but no template has been sent, so far… how do i get it?

        thank you

        • Puneet Gogia says:

          Yes Migu.

          I’m sorry for that.

          Can you please check your mail again. I’ve sent a new mail with template.

          I’m here if you need further help.

  • >