Free Inventory Management Software in Excel – Inventory Spreadsheet Template




The inventory Spreadsheet can be downloaded for free from,

This free Inventory and Sales Manager Excel template is suited for managing inventory and sales if you are running a business of buying products from suppliers and selling to customers. The template will assist in knowing the inventory levels (Stock management) of each product and understanding which products to re-order.

Also, you can quickly view the purchases/sales patterns over time and the best performing products.

For more advanced version of the template –

FEATURES:
• Enter and manage up to 2000 different Products
• Set custom re-order points for each product
• Simple and Easy data entry
• Know current inventory (stock) levels of each product
• Identify the products to be re-ordered
• Know if the sale orders can be fulfilled
• Easily understand the sales and purchase patterns (monthly and cumulative)
• Quickly see your top customers and suppliers
• Identify your best performing products
• Know how the different product categories contribute to sales
• Easily retrieve and view your order details

You can also try,

Retail Inventory and Sales Manager Template (for up to 10 warehouse locations):

For Manufacturing businesses, try our Manufacturing Inventory and Sales Manager Excel Template

For Rental businesses, try our Rental Inventory and Sales Manager Excel Template,

Simple and Effective Excel Templates:
Free Excel Templates:
Premium Excel Templates:
Small Business Templates:
Project Management Templates:
Inventory Management Templates:
HR Excel Templates:
Free Excel Course:

Social:
Subscribe to YouTube:
Facebook:
YouTube:
LinkedIn:
Twitter:

Previous How To Make Arabic (or Turkish) Coffee
Next Contact juggling tutorial - Enigma isolations

33 Comments

  1. Iman Himawan
    February 17, 2017
    Reply

    Thanks sir, very helpful.. ^_^

  2. Deviantapplestudios
    February 18, 2017
    Reply

    Fantastic video! Is there a way to filter the reports daily instead of monthly? I am an artist and I sell my artwork at conventions and I would like to know what and how much was sold of each of my piece by the specific show. I sometimes do multiple conventions in one month so it would just combine all the sales numbers together. Or even better a date range then show the reports specified within the dates I selected?? Thank you again for this fantastic template!

  3. Ripal Savla
    April 2, 2017
    Reply

    thank you so much sir, seriously I am crying coz I got emotional. you don't know you saved my job and helped me to increase my salary. I love you. god bless you… thanks for everything. actually u know what…if we share knowledge it becomes double, eg., if you have 1idea and I have 1 idea, if we share it becomes double. same way if I have a 1rs. coin and you have 1rs. coin, if we share it, it remains same.

  4. Mohammad Younas
    May 12, 2017
    Reply

    you are Really Great Person

  5. Rishi Kishore
    June 6, 2017
    Reply

    thanks a lot, i really loved your tamplet. If there were few things added to tamplet i would have loved it more. Like if excel file was some how attached to billing software where quantity could be automatically deducted when product is sold or added when purchased. It would be nice if bar code scanner could even be assimilated to everything.

  6. abraham yonas
    June 10, 2017
    Reply

    how to input sold items (issued )items quantity?

  7. om wood
    June 20, 2017
    Reply

    download link not open its says loading problem

  8. dragonx xx
    June 26, 2017
    Reply

    can this template work well for my liquor store? or do you have a specific template for a liquor store business? kindly reply

  9. Danna Hunter
    July 2, 2017
    Reply

    Many thanks sir. I must say i think you should start tutoring in this field it could pay you some extra bucks and trust me i would pay you to teach me how to create these things in excel as i am an Accountant.

  10. Danna Hunter
    July 2, 2017
    Reply

    I just realize on your website that you sell various things trust me i will be ordering some of them. You are a life saver!!!!!!!

  11. Jibril Doto
    July 2, 2017
    Reply

    Why doesn't it show in the report column when I use 2017 in the year???

  12. Kimberly Ann Leorag
    July 23, 2017
    Reply

    Thanks a bunch! Very useful template 🙂 Job well done

  13. Kunal Trivedi
    July 30, 2017
    Reply

    Thank you so much! Superb work

  14. Srijan Malla
    July 31, 2017
    Reply

    Very useful and excellent for us entrepreneurs

  15. Airron Ble
    August 1, 2017
    Reply

    Thanks so much for this spreadsheet and video! This will be very helpful for the small business my husband and I are starting. I am having one problem though, the products I entered are not reflected in the Product Name dropdown menu on the Orders and Inventory sheet. When selecting the Product Name dropdown, it just says "Loading…". Can you please advise me on how to fix this? Thanks in advance!

  16. vivendra viven
    August 15, 2017
    Reply

    good

  17. lawrence Okoh
    August 15, 2017
    Reply

    GREAT TEMPLATE. HELPFUL. I WOULD APPRECIATE TUTORIAL ON HOW TO CREATE SUCH A TEMPLATE. THANK YOU

  18. US S
    September 1, 2017
    Reply

    Need to buy or can use for sample

  19. Carlos Eduardo Ohep Gomez
    September 1, 2017
    Reply

    Thank you for sharing this video. It is a very helpful tool for people who wants to organize their inventory, even if they are just starting. I have one question, I've downloaded the this temple but for mac you said in you webpage, the mac version "does not have the slicer based Report sheet. Instead, Pivot tables are provided in separate sheets". Do you have a video where you explain how to use the mac excel temple? Thank you so much for your help.

    Best Regards.,

  20. S Kumar
    September 9, 2017
    Reply

    Thanks ..is it free

  21. Cookingat Home
    September 21, 2017
    Reply

    just amazing

  22. Gurjit Singh
    September 25, 2017
    Reply

    Sir one urgent request on report how to filter by certain day. I would like purchase if u can please add this feature

  23. Yves Seybel
    September 27, 2017
    Reply

    Excellent template – and congrats for the array formula on 'Orders and Inventory'!H5:H9 !!

  24. KeanGz
    October 18, 2017
    Reply

    Thank you sir!! but i want to know where Tbl_Current_Inventory i can't find it please tell me

  25. Rohan Pommels
    October 23, 2017
    Reply

    Awesome!!! I should be starting a Food Truck business in about 3 months. Any advice?

  26. Daniel Pino
    October 28, 2017
    Reply

    The best. Congratulations FROM COLOMBIA SOUTH AMERICA

  27. MD AZHAR
    December 1, 2017
    Reply

    Hi,
    I am fan of your work sir, Your really master of excel
    I have done with copy and paste all data in excel and its working all tabs except Report Tab.
    its showing error Given below plz check
    (This shape represents a slicer. Slicers are supported in Excel 2010 or later.If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used.)

  28. Efosa Omoroghomwan
    December 2, 2017
    Reply

    Hello sir,
    You are one of my favorite Excel Lecturers.
    I did something like this with a lot of functionalities (mobile friendliness etc) but it is not gaining popularity.
    Kindly see link below and advise me on what to do.
    http://www.efosmart.com/2017/11/free-offline-business-inventory-manager.html
    Thank you and God bless you in Jesus name, amen.

  29. Pennsy
    December 8, 2017
    Reply

    Thks wonderful template, keep it up !

  30. usman suleman
    January 9, 2018
    Reply

    Dear Sir
    I want to know how can i manage 4 sheet with a one master sheet ,whenever i change in master sheet the change also effect on other sheet which are connected with master sheet plz help me ?

  31. yebogogo64
    January 13, 2018
    Reply

    Thanks Indzara. Great work

  32. God's lion Commander
    January 16, 2018
    Reply

    Great work sir , i have one question please ,how i can select all products in reorder list?

  33. Rady Purbakawaca
    February 2, 2018
    Reply

    great sir, you teach me more

Leave a reply

Your email address will not be published. Required fields are marked *