<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Start Free

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.

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

Download Excel 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.

 M1.jpg

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.

 Manu-BOM.jpg

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

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


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:

Posted by Gwen Chen on Dec 4, 2017 8:00:00 AM

Popular Posts

Recent Posts

Share Your App Experience

Recommended Resources

Subscribe for updates