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

How to Manage Stock: Three Free Inventory Management Excel Templates

Inventory Management Has Never Been Easier

Inventory management apps (like Inventory Management App and Store Inventory App ) 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 Inventory Management 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.
  • An independent view to see all items that need to be restocked.
  • Current stock data is connected with sales and purchasing data.

Inventory Management App 3

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.

Store Inventory Screenshot

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. 

Download Excel Template
Open Google Sheet Template
Turn Your Excel Spreadsheet into an Inventory App

Manufacturing Inventory Excel Template

This template works for any business that purchases raw materials, manufactures in-house and then sells products to customers. For example, a bicycle producer, a furniture manufacturer or even a car company.

This template is made up of three main tabs—Sales, Parts and Inventory. Orange columns allow you to enter data. Based on that, the template calculates and auto-fills data.

In the Sales tab, you enter Sales_Quantity and the template calculates Sales Quantity per day and send the data to the Inventory table.

Screen Shot 2018-11-30 at 3.41.43 PM

In the Parts tab, there are Parts, Parts_Barcode and Low Inventory Alert. I suggest you use Parts_Barcode if you have a lot of parts. With Barcode, you can easily scan a part and update its sales and production data. Low Inventory Alert or Re-produce Point tells you market demand exceeds supply and you need to produce more.

In the Inventory tab, the template auto-generates Initial Stock and Daily Inventory. Initial Stock is equal to the previous day's inventory. Daily Inventory is equal to Initial Stock plus Daily Production minus Daily Sales.

Screen Shot 2018-11-30 at 3.49.32 PM


Bonus: I converted this spreadsheet into a mobile app. You can use it on iOS and Android devices. The app fosters team collaboration—manufacturing team, sales team and warehouse inventory team can enter data simultaneously. It allows inventory managers to check inventory data anywhere and any time. It eliminates data entry errors and data migration errors from paper to computers. It enables sales managers, production managers and inventory mangers to pull historical data, conduct analysis and make decisions on that.

The Inventory View shows each part group's Daily Inventory and previous day's Inventory.
Manufacturing InventoryCopy the Manufacturing Inventory App


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.

Inventory Management App-1Copy the Warehouse Inventory App


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