Raw Material Inventory Management 2025 in Excel

This free inventory tracker template is designed for small businesses which manufacture or assemble products from raw materials.

You can use this manufacturing inventory management excel template to automatically calculate the current raw material stock as well as determining how many units of each product you can make using the raw materials available.

We can input simple Bill of Materials (BOM) where we define how we can manufacture a products from its raw materials. We let the template take care of all the calculations.

Manufacturing Inventory Tracker - Free Inventory Excel Template — Manufacturing Inventory Tracker – Free Inventory Excel Template

Free Download

Manufacturing Inventory Tracker 2025 – Excel Template

Manufacturing Inventory Tracker 2025- Excel Template Sample5

Video Tour

How to track raw material inventory in Excel

There are five sheets in the raw material inventory management excel template: 1) Home 2) Products 3) Raw Materials 4) BOM and 5) Orders

Overview of steps

Enter Products in Products sheet
Enter Raw Materials in Raw Materials sheet
Enter Bill of Materials in BOM shet
Enter orders in Orders sheet after checking availability
View Current raw material stock in Raw Materials sheet

Steps in Detail

I will use an example of a Juice/Smoothie company which creates juices from fruits & vegetables. However, this template can be used in any industry.

**Enter list of parts or products in the Products sheet as shown below**

Inventory Tracker - Enter List of Products — Inventory Tracker – Enter List of Products

The Sales Quantity column is calculated based on sales orders that we will be entering soon.

**Enter list of raw materials you use in your business in the Raw Materials sheet.**

Inventory Template - Enter Raw Materials used in Business, their starting inventory and Re-Order Point — Inventory Template – Enter Raw Materials used in Business, their starting inventory and Re-Order Point

Starting Inventory: In this sample data, we have 10 Apples and 10 Bananas in stock when we begin using the template.
Re-Order Point: We have re-order points (Wikipedia Article on Re-Order Point) set for each raw material.
Available Now: Displays the current stock level of each raw material.
To Order: When current stock for a raw material goes below its re-order level, this field displays YES. Also, the template highlights the raw material name in red font.

Use this raw material stock register format in excel to handle all your raw materials availability.

**Enter Bill of Materials (BOM) in BOM sheet**

Inventory Template: Enter Bill Of Materials for each product

In the sample above, 1 unit of Banana Berry Shake is created from 1 Banana, 5 Strawberries and 10 Blueberries. 1 unit of Apple Banana Shake is created from 2 Apples and 2 Bananas. Unit of Measure column is just for your reference.

Once you have entered BOM for all your products, the initial set up is done.

**Entering purchase and sale orders in Orders sheet.**

As a manufacturing business, you may buy raw materials from your suppliers and sell the finished products to your customers. So, there are two key transactions – Purchase and Sale.

We can enter Purchase and Sale Orders in a single table in Orders sheet.

Excel Inventory Template – Enter Raw material Purchase and Product Sale Orders

Order Type: Order P1 is to purchase 50 Apples and 20 Bananas – So, we use Order Type of PURCHASE. Order S1 is an order to sell 5 Banana Berry Shakes. We use SALE order type.
Order Date: Date when the order is placed.
Expected Date: Date when the inventory is impacted. For example, order P1 was placed on 3rd Jan, but raw materials will reach us only on 4th Jan. So, Order date is 3rd Jan and Expected Date is 4th Jan.
Product or Raw Material Name: The template allows drop down selection for product / raw material name. If the order type is Purchase, it will allow Raw Materials and if order type is Sale, it will allow Products.
Quantity: Enter quantity or units of items on the order

If an order has 5 line items, then enter as 5 rows.

Check Availability

Before entering a new Sale order, if you would like to check the current capacity for a product, you can easily do that.

Inventory Availability - Check capacity to make a Product — Inventory Availability – Check capacity to make a Product

When you select a product, the template runs the calculations to figure out how many units of the product can be manufactured using the raw materials in stock right now. In the image above, we see that we can make 13 Apple Banana Shakes.

Limit

This free excel template for manufacturing company cannot handle complex scenarios where sub-assemblies of raw materials are raw materials to the final product.

Retail Inventory Tracker (Free)
Rental Inventory Tracker (Free)

Recommended Template for Manufacturing Businesses

Manufacturing Inventory & Sales Manager (Inventory, Orders, Invoice, Sales Reporting, Customer Data Management)

Manufacturing – Inventory and Sales Manager – Excel Template

$59

178 Comments

mayank May 31, 2018

Thanks for sharing this type of files.
Initially its help me very well with me.
As I have started my machine manufacturing business. Do u have any templet related to this ?

Process is as follow.
Machine design generate the Part list. Than raw material is purchased as per part list, Material are send to the manufacturing department. than ready parts are submitted to store. than store keeper issue this part list to the assembly shop. All part list com

Reply
- June 03, 2018
  
  Hello
  
  Thank you for sharing your requirements. Our current template will need a complete resign to process the workflow.
  We are not accepting any customized projects now.
  
  We will try to develop something similar in future. Keep a watch on the space until then.
  
  Best wishes
  
  Reply
Aaditya Pancharya May 27, 2018

In sheet [RAW MATERIALS] there is no formula in D7-D9, but rather the values
D7 = 20
D8 = 40
D9 = 55

What would be the formula ? The Orders are not being updated at the Purchases column

Reply
- May 27, 2018
  
  Hello
  
  Thank you for using the template.
  We have reviewed the file uploaded at https://indzara.com/2016/08/free-manufacturing-inventory-tracker/. It does not have any fixed values.
  Please download the file and enter the data in the table. In case, you still face an issue, please email the file with all the issues to contact@indzara.com
  
  Best wishes
  
  Reply
Khin Thida Lwin May 23, 2018

Very useful for me. So thanks a lot.

Reply
Khin Thida Lwin May 23, 2018

Very useful for me. So thanks a lot.

Reply
- May 23, 2018
  
  Thanks for your kind attention.
  
  Reply
Sheldon May 18, 2018

Hi. Anyway to adjust so the inventory is deducted by date of order and NOT expected date?

Reply
- indzara May 28, 2018
  
  Can you please clarify the business context for this change? Is it possible to enter the order date again in the Expected date column?
  
  Or we need to adjust the formulas and replace Expected Date references with Order Date.
  Thanks & Best wishes.
  
  Reply
jamie January 27, 2018

Hello this looks like a very useful sheet. Is it also possible to track the cost of goods using this sheet? Thanks

Reply
- January 28, 2018
  
  Hello
  Thanks for your feedback.
  This template does not calculate the Cost of Goods sold as of now. We will try to incorporate it in the future releases.
  Best wishes
  
  Reply
MJ and Pete January 21, 2018

Hello

Thank you for giving away such a valuable tool for free. We are bootstrapping our startup company, so I cannot begin to tell you how much we appreciate you and ll the hard work you have put into this.

I have a query – on the raw materials sheet, the ‘purchases’ column seems to be missing the calculation. We’d really appreciate it if you could provide us with this calculation.

Many thanks

Reply
- January 22, 2018
  
  Hello
  Thanks for using our template.
  All the calculations are done at the back end. Please watch the video on https://indzara.com/2016/08/free-manufacturing-inventory-tracker/, this will give you an overview of the workings.
  Best wishes
  
  Reply
  - MJ and Pete January 23, 2018
    
    Hello
    
    Yep, I watched the video thoroughly, and understand how the template is supposed to work.
    
    Problem is, the excel formula for that particular column is actually missing from the spreadsheet, which is why it’s not calculating on the back end. Please can you take a quick look? You’ll see what I mean.
    
    Cheers
    
    Reply
    - January 25, 2018
      
      Hello
      The Raw Material purchased and entered in the “Orders” sheet will reflect in the Purchases column.
      Best regards
      
      Reply
      - Paul D March 06, 2018
        
        I am seeing the same thing as MJ and Pete. In sheet [RAW MATERIALS] there is no formula in D7-D9, but rather the values
        D7 = 20
        D8 = 40
        D9 = 55
        
        I was able to get this to work with the following formula, but I warn that it is inelegant.
        =SUMIFS(ORDERS!F:F,ORDERS!B:B,”PURCHASE”,ORDERS!E:E,[@[RAW MATERIAL NAME]])
      - March 07, 2018
        
        Hello
        Thank you for your advice.
        Please download the template from https://indzara.com/2016/08/free-manufacturing-inventory-tracker/. The link is just above the video tour of the template.
        Best wishes.
    - Aaditya Pancharya May 27, 2018
      
      Did you get a solution fr this ? I am struggling with the same issue ? If yes could you send me at adit0123@gmail.com
      
      Reply
Mack December 21, 2017

can this be done or help a small cafeteria, with recipe and item are sold are sandwich and plate..

Reply
- indzara December 23, 2017
  
  Yes, you can use it. It may not be suitable for point of sale use, but you can use it to track inventory by end of each day.
  Please let me know if there are any questions.
  Best wishes.
  
  Reply
Thomas December 19, 2017

Is there a way that I can changes “SALE” to “BUILD” in the ORDERS Sheet? Thanks

Reply
- indzara December 20, 2017
  
  We would have to then update formulas as well.
  Best wishes.
  
  Reply
Maya December 16, 2017

Can I use this template to only enter purchase order I. e raw materials alone and not sales orders. Can I add a formula for reorder level of raw material

Also can I use this to enter consumption of raw materials by production dept…

Thanks

Reply
- indzara December 17, 2017
  
  Only purchase orders can be entered. However, then the inventory will only keep growing. Sales orders will reduce inventory as products leave. In order to reduce inventory by consumption of raw materials, we have to enter a sales order.
  Best wishes.
  
  Reply
  - Maya December 17, 2017
    
    We r holding finished goods and not all production = sale. Hence can I enter consumption of raw materials by production dept to reduce inventory without entering sales order..
    
    Thanks
    
    Reply
    - indzara December 18, 2017
      
      Thanks. In the premium template https://indzara.com/product/manufacturing-inventory-sales-manager-excel-template/, there is an order type of Manufacturing which allows creating finished goods in inventory without selling.
      Best wishes.
      
      Reply

Leave a Reply Cancel reply