Indzara
Shop
Support
Login

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

  1. Enter Products in Products sheet
  2. Enter Raw Materials in Raw Materials sheet
  3. Enter Bill of Materials in BOM shet
  4. Enter orders in Orders sheet after checking availability
  5. 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
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
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.

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

182 Comments

  • The downloaded template file and the video appear to be different. For example, the video shows a dashboard called “SALES_REPORT,” but this dashboard is not available in the Excel file I downloaded. Could you please clarify this issue?

    Reply

    • Thank you for reaching out!

      The video demonstrates an older version of the template, while the downloaded file is the latest version. The latest version includes all the features from the previous Sales Report dashboard and more — just organized and presented differently.

      If you have any further questions, please feel free to open a support ticket and we’ll be happy to help!

      Best wishes.

      Reply

  • Hi
    In the Order sheet when I am entering the selling or purchasing of any item , the stock remains unchanged in the inventory. Do I need to do anything more for the change to reflect?

    Reply

      • I have the same issue as Gaurav. Please let me know about how to fix it.
        Thank you

        Reply

        • Thank you for reaching out.

          We regret the inconvenience caused and appreciate you bringing this to our attention.

          Please be assured that there are no issues with the template itself. To help us assist you better, we request that you share your copy of the template along with some sample data highlighting the issue using the link below:
          https://support.indzara.com/support/tickets/new

          Our team will review your file promptly and guide you with the appropriate steps to resolve the issue.

          Best wishes.

          Reply

  • Great spread sheet! Any way to add costs to raw materials so we can get the cost for each product?

    Reply

  • Hi. I had downloaded this template a few months ago and it worked great! I spent a long time getting everything just right for what I’m working on then it just vanished. All my other files are still there and when I download the template again now, it won’t open in google sheets. Do you know if there was recent a google update that makes this template incompatible?

    Reply

  • hi i am starting a pvc solvents manufacturing unit. a number of products can be made from the same set of raw materials. i just downloaded your free management inventory spreadsheet for my understanding before making the purchase. it was simply superb. I have a few doubts.
    1. i dont understand the colour codes in the product sheet. do they mean anything.
    2. As i said, same raw materials are used in different products, but availability just shows for one product alone and rest as zero. (eg: pvc solvent 250 l & pvc solvent 500 ml are my products. but checking availability shows for 25oml alone and the other as zero)
    3. I have entered sale of pvc 500ml but its not getting deducted in the raw material sheet.

    kindly guide me pls

    Reply

    • Thank you for showing interest in our template and sharing your valuable feedback.

      1. Yes, the columns with green color contains formulas. Hence modifying or deleting it will have impact on sheet’s calculation.
      Regarding 2 and 3, I am unable to replicate the highlighted issue in our end, please share your sheet to us at the below link to assist further:
      https://support.indzara.com/support/tickets/new

      Best wishes.

      Best wishes.

      Reply

  • Good day
    Thank you for this free template.

    I am struggling with the Purchases in the Raw Materials tab. When an order is placed for a Raw Material (Purchase) in the Orders tab then the Purchases column in the Raw Materials tab is not being updated. Similarly, when a sale is recorded in the Orders tab then it’s not updated in the Products tab under “Sales quantity as of today”

    Please assist
    Thank you

    Reply

  • Hello…thank you for sharing this template for free, specially useful for small and startup businesses. But 2 things pls:
    1. I would like to establish value/amount of beginning and ending inventories of raw materials – can we add columns on the right without disrupting the formula of the template?
    2. We tried using this template as a shared file in google sheet, how to correct parse errors in most of the data fields of the google sheet?
    Thank you for your help/reply on this.

    Reply

  • Is there a way to link multiple lot numbers of the same raw material and have it reflect in the BOM and product availability

    Reply

  • Hi,
    Can 1 more feature be added to it wherein if I enter a sale order (for eg 50 banana milkshake) then the number of raw materials required to fulfill that sale order should be displayed (Available banana-25, Required banana – 25)?

    Reply

  • I downloaded the template and input data. However I would like to upload this to google drive so I can access it on the move. When I put the file in drive, none of the formulas work.

    Is there a way I can use this on google sheets / drive?

    Reply

  • Just downloaded this workbook and trying to get to know it.
    Why isn’t “Product” in the BOM sheet picked up from “Product” in the Products sheet? It seems that would make the most sense, connecting the two. Am I missing something here?

    Reply

    • Thank you for showing interest in our template.

      I have verified the template and the drop down is available to select product name from Product table in BOM tab. If you copy paste the cell into the product name which does not have the drop down instead of pasting as value, then the drop down will be removed.

      If this is not your concern, requesting to share your sheet to support@indzara.com along with some screenshot highlighting your issue to check further.

      Best wishes.

      Reply

      • Hello, I am facing the same issue. The product in the BOM tab is not directly updating product name from the “PRODUCTS” tab. I hope there won’t be any issue in other values if I copy paste or manually write the product name in the BOM tab. Also, does your sheet work on Microsoft teams? Thanks

        Reply

        • Thank you for showing interest in our template.

          Currently, we have not made the products to auto-populate in BOM table since 1 product might require multiple raw materials to manufacture, in such scenario, the same product name has to be repeated again and again for each raw material to be mapped with the product along with its quantity.

          I also would like to inform you that copy pasting the product name will not impact the sheet’s calculation, however I would recommend you to paste it as values to save the cells format.

          Sorry, I have not tested with Microsoft Teams yet but if you are referring to Excel online, yes it works.

          Best wishes.

          Reply

  • Can this template be adapted for use in a pharmaceutical manufacturing company?

    Reply

    • Thank you for showing interest in our template.

      Yes, this template can be used for any company with fixed quantity of required raw material. But if you are manufacturing a product from a manufactured sub-product instead of purchased raw material, currently, this feature is not available in the template and we have planned to include the same in the next version of the template.

      We also take customization project for a fee. You can share your requirement to support@indzara.com for estimation.

      Best wishes.

      Reply

  • Hello,
    The Free Excel Inventory Template for Manufacturing Businesses is not downloading. Are you still offering a free template? Do you have another link to download?
    Thank you
    Victor

    Reply

    • Thank you for showing interest in our template.

      Yes, it is still available as a free template. I tried downloading the template and I am unable to replicate an issue. Requesting to share a screenshot of the download error to support@indzara.com to check further.

      Best wishes.

      Reply

  • I have been using the Manufacturing Inventory Tracking Spreadsheet and it works great. I ran into a problem when I created a new raw material gave it a starting quantity and then tried to insert it into an existing BOM. The spread sheet assigns a quantity to the raw material used for this item even though there is no history for this raw material. It also deducts the amount in the history used column from the available raw materials number leaving me with a negative available quantity. How can I correct this problem?

    Reply

  • Hello,
    I appreciate you making and sharing this template, it will be a tremendous help. How would you recommend accounting for waste/loss of raw materials?

    Many thanks!

    Reply

    • Thank you for your feedback. You can add it as a order type and tweak the formulas a little bit to get the required output. We can also take it as a customization project for additional fee. Please contact support@indzara.com for a quotation of this customization project.
      Best wishes.

      Reply

  • Hi! I don’t know what to do with my “sales quantity as of today” it didn’t automatically calculated my sales. Can you please help me with this? Maybe I have deleted that column. Thank you!

    Reply

    • We would be happy to help you in this regards. Requesting to share your sheet with some screenshots highlighting your concern to our support team at support@indzara.com to further check on your concern.

      Best wishes.

      Reply

  • Thanks a lot.. It’s really helpfull.. I’ll definitely donate you as a help for this template

    Reply

  • Hi can you plz design a template for aluminium fabrication work normaly use for making sliding windows and door for 1,2,3,4,5 tracks and the raw material are use are of generally 10,11 15 foot sizes aluminium extruded section
    It should give me the quotation with the raw material used if i mention square foot and the number of track window i want to make..

    Regards

    Reply

    • Thanks for your message.

      Due to a heavy workload, we are not accepting any customized projects. However, you may review our Manufacturing – Inventory and Sales Manager – Excel Template at https://indzara.com/product/manufacturing-inventory-sales-manager-excel-template/. This template has the following features:

      Manage inventory at a manufacturing/assembly business
      Automate inventory calculations of raw materials based on products
      Choose whether you hold manufactured goods or not (at the product level)
      Know current inventory levels of each product and raw material
      Identify the products and raw materials to be re-ordered
      Print automatically created invoices
      Easily understand the sales and purchase patterns
      Identify your best-performing products
      Know how the different product categories contribute to sales
      Easily retrieve and view your order details

      Best wishes

      Reply

  • Hi, I really would like this to work in google sheets so i can share with my copacker.
    When I upload it it seems to convert everything fine EXCEPT on the orders tab, it can’t select from both product names and raw material names. What do you suggest I do?

    Reply

  • Can you design an inventory spreadsheet to control raw material stock for a nut and bolt manufacturer? We need to be able to load material into the system. I need to speak with you in some detail. Please contact me.

    Reply

  • I need to enter another column for the part number next to the part name. How can I add it and make it part of the table?

    Reply

    • Thanks for using our template.

      You can insert a column. However, please note that it will not be part of any calculation.

      Best wishes

      Reply

  • Hello again,
    how can I determine the QUANTITY I need to purchase if raw materials are shared across multiple products? Do this spreadsheet calculate what I need to order? If not, do you have one that does?

    THANKS SO MUCH!

    Reply

    • Hello

      When you enter the raw material details, it asks for the Reorder point. This needs to be mentioned. In case the inventory falls below it, final products cannot be manufactured using the same.

      Best wishes

      Reply

      • But where does it calculate what I need to order? If I have multiple products using the same part# I need to add everything I need for all products.
        THANK YOU!

        Reply

        • Hello

          Once a reorder level is advised you will be alerted when the inventory falls for that item below this level.You not be able to manufacture the items that use the raw material. Please review the video and the blog on the page.

          Thanks

          Reply

  • Hello, this looks like a great tool. How does it count/allocate for shared raw material parts?
    Thank you!

    Reply

    • Thanks for using our template.

      Suppose a material A is shared in two products, in that case, the number of two products that can be manufactured using A will depend upon the quantity of material A available at that time.

      Best wishes

      Reply

  • I have raw materials that appear across different products. I have set up each product in the BoM sheet of the free template and also in the Manufacturing details sheet on the template I have purchased. However, when I look to see how many of this product can be made all is shows me is the quantity of the very first raw material for that product. I thought maybe it would look at all the raw materials required, versus the stock level and then tell me how many products could be made?

    When I enter a sales order for a particular product, will it reduce the raw materials inventory by the right amount for all the raw materials in the BoM?

    Many thanks

    Reply

    • Thanks for using the templates.

      Could you please share the files along with the list of issues for us to review. You may email them at contact@indzara.com

      Best wishes

      Reply

  • Hi

    this template does not factor in damages during production or defects to give me the total number of raw material left. May you kindly assist?

    Reply

    • Thanks for using our template.

      This template does not account for damages during production or defects. We have noted your feedback and try to incorporate this feature in the future releases.

      Best wishes

      Reply

    • Hello

      The expected date provides the date when the inventory gets impacted. Please share more details, maybe with an example.

      Best wishes

      Reply

  • Wonderful template. Thanks a lot.
    As I am trying to edit this template, I would like to check with you ig you already have remade temple for my use case.
    I have a manufacturing unit which makes concrete blocks of different sizes.
    Now I will be having raw materials and finished product stock.
    So I need a way to track both the raw materials and the manufactured stock.

    Thanks in Advance!

    Reply

  • Just want to tell you how awesome this spread sheet is. We are a small craft based provider of custom jewelry and needed a BOM and Inventory system. Your spread sheet is the perfect solution as we can now account for the components that go into each item and reduce the inventory levels with each sale. This has improved our costing abilities as well.

    Reply

    • Thanks for using our template and sharing a positive experience.
      We always endeavor to exceed expectations.

      Best wishes

      Reply

  • Excellent web site. A lot of helpful info here. I’m sending it to some pals ans additionally
    sharing in delicious. And certainly, thanks in your effort!

    Reply

  • Is there any way to adjust the inventory levels aside from Purchases and Sales. If we need to adjust a quantity after counting the stock does the template offer an adjustment entry?

    Reply

    • Thanks for using the template. Currently, that is the only way to adjust inventory levels. Please try entering a dummy sale order to reduce inventory.
      Best wishes.

      Reply

  • Hi!

    Do you have any solutions that overcome the limit of sub-assembling raw materials that are raw materials to the final product?

    Reply

    • Thanks for your message.

      The template is not designed to handle the sub assembling to the other raw materials. We might have this feature in the next release.

      Best wishes

      Reply

  • I entered data in the available now field in my Manufacturing Inventory Tracker and it stopped calculating that row. Is there any way to correct this without downloading the spread sheet and starting over?

    Reply

    • Thanks for using our template.

      Please ensure that none of the formulas are missing. If the issue persists, we will advise you to download the template again.

      Best wishes

      Reply

  • Once downloaded can I use the Manufacturing – Inventory and Sales Manager – Excel spreadsheet in multiple computers?

    Reply

  • Amazing!!!

    The only thing missing for me is the price of materials

    Reply

  • OK, my bad. I found my mistake and the Raw Materials sheet now shows the calculated reduction of raw materials due to SALE on Orders sheet. However, Products sheet still does not calculate Sales Quantity as of Today.

    Reply

  • I downloaded your Manufacturing Inventory Tracker template on June 29, 2019. I am having the same problem Urvashi noted on June 3, 2019, that is, entry of a SALE on the Orders sheet does not calculate reduction of raw materials inventory on the Raw Materials sheet for the manufacture of the product sold , nor does it calculate the number of the products sold as of today on the Products sheet. Please advise me when you have made corrections to the template so I can download a working version. I am very excited about this template – it will be perfect for my situation if you can get it working.

    Reply

  • please help for change Expected date: It only working with year 2016 not the updated year .
    Please suggest to resolve this query.

    Reply

  • Hi,
    We have a business of batteries, where we manufacture our own batteries which consists of many raw materials.
    So I tried the template and updated all the products, raw materials, BOM and orders.
    When update an order we expect raw material should be deducted automatically from raw material but it is not happening.
    Request you please suggest how we can do that.

    Reply

    • Thanks for using our template.
      Please ensure that the formulas and links are not broken. You may download a fresh copy of the sheet and enter the data. In case it still does not work, please email your issues along with a copy of your file to contact@indzara.com

      Best wishes

      Reply

  • Love this template. Is there a way to convert it to google sheets? In uploading it, some of the formulas are lost. Thanks

    Reply

    • Thanks for using our template.

      We have designed and tested our templates on MS Excel. Some features will not work on the Google platform.

      Best wishes

      Reply

  • Hello,
    In the orders sheet – is it possible to make a sale of the raw materials. I have a manufacturing business in which raw materials are also sold as spare parts.
    Thanks

    Reply

  • How to add even service, with Purchase and Sale in oders?

    Reply

    • Thanks for your message.

      Could you please elaborate more so that we can address the issues.

      Best wishes

      Reply

  • Hello. I just found your template and am wondering if you can help me figure out how to use for our business. We have live training seminars and need a certain amount of materials for each attendee, as well as just some materials that we have out that don’t necessarily count on each guest getting one, but for them to use while they are there. I could use your help in how to set this up. Is that something you might be able to work with me on?

    Reply

    • Thanks for your message.

      We are not accepting any customized projects now.

      Best wishes

      Reply

  • Hi

    I cant enter order type,the excel says the value you entered is not valid.

    Reply

    • Hello

      Please select either a purchase or sales from the drop-down list.

      Best wishes

      Reply

    • Thanks for using the template.
      You can change the order type in the “Order Type” column in the Orders tab.
      Thanks

      Reply

  • Sir,

    Thanks for sharing a wonderful and use excel for the manufacturing unit along with the tutorial in youtube . We are running a small industry and for which we want to differentiate the ready material available and its sale as we keep the ready material in stock for future sale. The ready material comes from the raw material and sale from the ready material so that we can easily track the ready material in hand its sale.

    Thanks

    Reply

    • Thanks for your feedback. We hope our templates will help you to grow your business.

      Best wishes

      Reply

  • Hi Thank you for the template, I just want to know how I can show my raw materials, for a bakery, in kilograms, grams and ml?
    Thank you

    Reply

    • Hello

      Thanks for your feedback. Since you are using the metric system, you can standardize weight as kg and volume as liters, then enter data in decimals. Like 100 grams would be 0.10 kg and 500 ml would be 0.5 liters.

      Best wishes

      Reply

    • I would like to appreciate your template,it’s really helping us. I have a question on Raw material worksheet,may you kindly assist me with a formula to indicate Yes/No when raw material reach Re-order point.
      Kind regards

      Reply

      • Thanks for your feedback.

        In the raw materials tab, the current value and the reorder level can be mentioned. Once the inventory level goes down the reorder level, the last column would indicate if an order needs to be placed or not.

        Best wishes

        Reply

  • hi
    i should be thankful to to get free education from you as i trying so much watching a video

    Reply

  • Thanks for sharing such a wonderful sheet with everybody. It works really well and has almost all functions needed. It’s of great help and very user-friendly. Kudos!

    Reply

  • Hi,
    Thanks so much for the template, it helps a lot. I only have one question:

    In the ORDERS tab, when I enter a new purchase order, it should give a list of RAW MATERIAL NAME (from the raw materials tab I suppose). However I only get the PRODUCT list, both when I enter Sales order or Purchase order. How can I adjust this?

    Also, can I see a total list of raw materials that have been substracted from the inventory in accordance with the sales orders?

    Reply

  • 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

    • 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

  • 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

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

    Reply

    • 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

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

    Reply

    • 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

  • 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

      • 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

        • Hello
          The Raw Material purchased and entered in the “Orders” sheet will reflect in the Purchases column.
          Best regards

          Reply

          • 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]])

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

    Reply

    • 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

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

    Reply

  • 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

    • 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

  • Greetings, I think I’ll like this product if I can get it to work…nothing seems to happen when I try to enter a Purchase or Sale. I am assuming that a purchase will be reflected across the sheets? Thanks Thomas

    Reply

    • Please provide more details to explain. Email the file to support@indzara.com and clearly highlight the questions. More the details provided, easier it will be for me to answer.
      Thanks & Best wishes.

      Reply

    • You can add one more order type in the drop down by just adding the value in the Data Validation list. Then we have to implement what that new order type should do to inventory calculations.
      Best wishes.

      Reply

  • i need to classified shelf life of porduct in warehouse by expired date.. can you help me?

    Reply

  • I am a small manufacturing whereby I buy raw material and/or components and assemble them to form a finish product. I would like to add a certain amount of labor as well as overhead cost into the total cost when building the BOM and eventually become the cost of sale. Can that be done?

    Reply

  • Hi
    just need to know if you have done any work in progress for machineshop because I am interested in having one

    Reply

    • Sorry, I don’t have any template specifically designed for machineshop. Best wishes.

      Reply

  • Hi,

    impressive work.
    I would like to buy your spreadsheet but first I have few questions:

    Can it be customised and edited? For example more sheets being added?
    I am currently looking for a way to import sales out of a POS in csv format for stock depletion and sale report. Do you have anything in line with my needs?

    Reply

    • Thanks for your interest.
      Yes, the templates can be edited. New sheets can be added as needed. However, if you need the new sheets to integrate with the existing sheets, you would have to add the necessary formulas.
      I don’t have any other templates that are set up to import POS data. Please let me know if there are any questions.
      Best wishes.

      Reply

  • Is it possible to add a column that supplies at what date the inventory level will be depleted based on the customer orders.

    Reply

  • Hi, do u have a example of inventory related to safety match inventory where it shows also the detailed raw materials computation either by grams or kilograms..example I need to produce 10 boxes.

    Reply

  • Hi,

    We are a manufacturing firm and purchase raw materials from many suppliers and then use that raw material to manufacture a final product and then sell that final product to different dealers.
    Is this template useful in keeping a track of
    – the raw material purchased vendor wise
    – inventory
    – ready stock
    – dealers to whom final product is sold

    Reply

  • Hi Indzara team,

    we have raw materials and different combination of raw materials as assembled raw materials and then combination of different assembled raw materials as finished products, for example

    A1, A2, B1 are the raw materials and combination of A1, A2 is C1(assembled raw material)
    then combination of C1 and B1 is called D1(finished part).

    so now my problem is how can I check the availability of C1 and also D1(combined with C1(A1, A2) ,B1 raw materiasl) on the top of orders page.

    I hope you understand my issue, if you dont understand please let me know, I will be waiting for your reply.

    Reply

    • Thanks for the details.

      The template supports only one level of manufacturing/assembly – Raw materials being converted to products. I am sorry that your scenario of two levels is not supported.

      Best wishes.

      Reply

  • Hi Indzara team,

    Some times we purchase 10 raw materials and only 7 will be usefull and remaining 3 will be defective products so this three will go to trash, so in this case how can I track usefull and non usefull raw materials count through this template.

    Reply

    • To reduce the inventory of raw materials (due to wastage), please enter a purchase order for the raw material and use negative quantity value (for example: -5). This will reduce the raw material inventory accordingly.
      Thanks & Best wishes.

      Reply

  • Hi Indzara team,

    Can I add extra column of tables near orange tables(at starting of the tables)? does it effect the template?

    Reply

    • Yes, you should be able to add columns to the tables. Please do not edit any formulas in calculated columns. Thanks. Best wishes.

      Reply

    • The template is ready to enter your own data. The calculations are built-in and once you enter your input data, you will see the results. Thanks. Best wishes.

      Reply

  • Dear Sir,
    We are trying to find a Template to track in-house office “Supplies Purchased, Issued & When to Reorder”. I have been searching for something so that we can enter our “Purchases” (i.e. safety goggles, gloves, band saw blades, etc..) Our Industry is in Steel Fabrication and we have a lot of in-house office/safety & shop supplies that we are purchasing & issuing to our employees on a daily basis. As of right now we have no system in place to track how much of each item has been purchased vs. what we have on hand and what needs to be reordered as well as Who, What, & When was it issued? Any suggestions on what Template to purchase if any would work for this? Your help & working Template to resolve our issue would be GREATLY Appreciated! Thank You!

    Reply

    • Thanks for your comment. I have replied to your email address with some questions. Thanks & Best wishes.

      Reply

  • this is good Ind. quick question. can you also develop and inventory system for an automotive industry or booking a service and maintenance template for automotive industry.

    Reply

    • Thanks. I am sorry I don’t have such a template yet. Please subscribe to our social media outlets to be notified of new templates. Thanks. Best wishes.

      Reply

  • Dear Sir,

    Thank you very much for the efforts that you have put in making these trackers available for us. Your templates and trackers are very useful for us in various areas of our operations.

    We are a small company trying to use this tracker for tracking goods issued and receipt in our store room. We generally procure raw materials and stock it in store room. In this tracker, it is recorded as ‘Purchase’ when goods are received and while goods are issued to indenting department, we record it as ‘Issue’ in place of ‘sales’. It would be a great support if you could to kindly help us with ‘Purchase Return’ and ‘Goods Return’ options where the inventory adjustments happens automatically.

    Will be awaiting for your valuable response at the earliest.

    Many thanks in advance!

    Reply

    • You are welcome. Please try entering negative values in Quantity field in ORDERS sheet. This should create the reverse inventory logic. A sale order with negative quantity should increase inventory = Goods return. A Purchase order with negative quantity should decrease inventory = Purchase return.
      Please let me know if there are questions. Thank you.

      Reply

  • Dear sir,

    I am interested with the Manufacturing Inventory & sales manager template, could you give me trial version on this template for analyzing whether this template suitable with my need or not.
    If suitable, I will buy for your template

    Thank you

    Reply

    • Thanks for the interest. I don’t have a trial version, but the purchase is risk free. Please email me if the product does not meet your needs and I will issue a full refund.
      Thanks & Best wishes.

      Reply

  • Thank u so much
    I have a problem that when i go to column F and G there is no balance showing. in Column F i put formula of subtraction in it then the results come out
    But in column G no results found.

    Reply

    • You are very welcome. Please email the file to indzara at gmail and I will be glad to take a look at the data. Thanks.

      Reply

  • Thanks so much for the template. I am entering raw materials and when I got to line 41 the red text ended. How can I extend that feature?

    Reply

    • You are very welcome. The red font indicating raw materials below re-order points should automatically extend in the table. If it is not, please check the Conditional Formatting rule (Home Ribbon –> Conditional Formatting –> Manage Rules –> This Table. You can view/edit the cell range accordingly. Thanks.

      Reply

Leave a Reply

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