<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Filter By Categories
Gwen Chen
December 04, 2017

How to Manage Stock in Excel: Three Free Excel Templates

Inventory Management Has Never Been Easier

Inventory Excel Photo.jpeg

Inventory management apps (like Store Inventory and Equipment Inventory) have been on AppSheet’s top 10 most popular sample app list since we started tracking this in 2016. Over the last two years, we’ve seen tremendous growth in the number of inventory management use cases with no end in sight.

The Store Inventory Sample App has the following powerful features:

  • The app automatically enters dates and uses the phone/tablet camera as a Barcode reader.
  • A daily email report reminds the user to reorder stock.
  • You can navigate the different inventory items by Category, by Date or by Inventory Values.
  • An independent view to see all items that need to be restocked.

Inventory 1

Turn Your Excel Spreadsheet into an Inventory App

Why the trend? Businesses and organizations are automating data capture by tracking and updating inventory data in real-time through bar code scanning or image capture. What does an Excel spreadsheet have to do with this? Well, it’s actually a great starting point for creating an app that automates the inventory management process for you. My recommendation: Start with a spreadsheet and turn it into an app using an app maker platform like AppSheet’s. Of course, we’re not the only platform out there but we’re the only one that can easily take a spreadsheet and turn it into an app!

If you are considering making an inventory app on your own, you will need to begin the process with a spreadsheet and there are some great Excel inventory management templates. The following sections describe some free inventory management excel templates that can help you get started. Of course, you can just use the templates and adopt them to your own business needs or you can turn them into apps—it’s up to you! 

General Inventory Excel

Never tracked inventory but want to start tracking it now? This easy-to-get-started template has all the key items you need to track. It’s made up of three tabs:

  • Daily Stocktake records stock coming in and going out of a company on a daily basis.
  • Stock Database allows you to enter more detailed information about each item.
  • Stock Inventory links Stock In and Stock Out columns to Daily Stocktake, and after you enter Initial Stock, the spreadsheet will calculate Final Stock for you.

Of course, to meet your business needs you can add or update columns. For example, to manage reordering, you can add columns for reorder levels and reorder quantities.

General Inventory 2-1

Bonus: I modified the above excel template and convert it into an Inventory Management App. The app enables inventory managers to do the following:
  • Use a bar-code scanner to record stock in and stock out (your phone or tablet can serve as a bar-code scanner);
  • Automatically calculate current stock level;
  • Display on a view what items need to be restocked;
  • Send “Add Stock” email notifications to the purchasing department.

Copy the excel template and the app, and customize your own way. If you want to learn how the app was made, read this blog.

Store Inventory Screenshot

Download Excel Template
Open Google Sheet Template


Manufacturing Inventory Excel Template

This template, developed by Indzara, works for any business that purchases raw materials, manufactures inhouse and then sells products to customers. For example, a fresh drinks store, cupcake store or even a sawmill.

This template is made up of four main tabs—Products, Raw Materials, Bill of Materials and Orders, all color coded in orange or green. Orange columns allow you to enter data. Based on that, the template calculates and auto-fills data in the Green columns.

In the Products tab, you enter product names and the template calculates Sales Quantity As of Today.


In the Raw Material tab, you enter the Raw Material Name, Starting Inventory and define the Re-order Point; the template auto-fills how many units are left and tells you whether or not you should order more raw materials.
Manu_Raw Material.jpg

In the BOM tab, you define the relationship between raw materials and final products; the template generates the quantity of products that can be made.


In the Orders tab, you enter the purchase and sales data; the template then tells you how many products are available.

Download the template here.

Bonus Template: Indzara has a very cool template for retail businesses that purchase products from suppliers and sells them to customers. With the template, you can track orders, inventory, and finance. Reporting is what I like most about this template. You can view overall metrics on sales, purchases and returns by month. You can sort products by quantity, amount and margin.

Download Excel Template

Warehouse Inventory Excel Template

The template is for companies who have warehouses and put their raw materials in bins of different sizes in different bin locations. The template has three tabs—Inventory List, Inventory Pick List, and Bin Lookup.

The Inventory List tab tracks the quantity of SKUs in different bins and locations and flags SKUs that need to be reordered. The Inventory Pick List tab allows users to easily locate where to pick up an item and the quantity of the item. The Bin Lookup tab acts as a bin database where information such as size, location and bin number are stored.

Warehouse 1.jpg

Download Excel Template

Bonus: An App for Streamlining Inventory Updates

This app can replace paper logging of product inventory, for quicker input, real time analysis of stock levels and alerts when items require a check or re-order.

Features include:

  • Barcode and NFC Tag scanning for quick inventory edits;
  • Custom Formats to highlight popular products and the ones with low inventory level;
  • Email Alerts on low inventory products;
  • Charts on receiving and shipping.

What’s Next?

These are just some of my favorite Excel templates for inventory management. You can use them as is OR easily turn them into apps. Check out our sample inventory management apps here and here—and note, they were all made from spreadsheets!

If you have other favorite Excel templates, let me know by submitting a comment or tweet. I'm always looking for templates to add to this list!

Related stories:

Ready to take your inventory tracking to the next level? Copy the following app and customize in your own way! 

Turn Your Excel Spreadsheet into an Inventory App

Google Search

Subscribe Email