Manufacturing – Inventory and Sales Manager – Excel Template Support

This is the Support page for the Manufacturing – Inventory and Sales Manager – Excel Template. Please post any questions related to this template in the comments below.

Product Page:

Manufacturing – Inventory and Sales Manager – Excel Template

Version History:

  • v2 published July 24, 2015
  • v1 published Apr 25, 2015

Useful Links:



  • I just purchased the manufacturing and inventory spread sheet and none of the cells contain formulas for calculations and there are no drop down cells as shown in the videos. It is essentially a a static group of cells without any functions.

    • Thank you for purchasing the template.

      You will get a email response from our support team shortly.

      Best wishes.

  • hi
    i got MANUFACTURING – INVENTORY AND SALES MANAGER v2.0, but i want to know how to make the material stock since i bought material in MT. and manufacturing in KG.
    for example: water tank 1000 us/gallon total weight is 90kg and have 3 layer’s first layer is 50kg, second layer 17kg & third layer 23kg & we have another like 1000 us/gallon total weight is 103kg and have 4 layer’s first layer is 50kg, second layer 14kg, third layer 17kg & forth layer 22kg.
    please let me know about this and how to add them to the program so i can know my stock after manufacturing.

    • Thank you for purchasing the template.

      You will have to convert the MT to KG during the time of purchase or you will have to convert the KG to MT in Manufacturing details tab. For ex.,
      Manufacturing details
      Product A – Layer 1 – 0.05 MT
      Product A – Layer 2 – 0.017 MT
      Product A – Layer 3 – 0.023 MT

      Best wishes.

      • Hi Indzara,

        I am using ounces. How do you suggest I fix the issue Im having? its not creating any finished goods and no sales reports are generated.

  • Hello,

    I am using v2 of the template. I need to add additional columns to the products (PRODUCT ID#), and raw materials (RAW MATERIALS ID#, SUPPLIER, SUPPLIER ID#) sheets without disrupting existing formulas. I then need the manufacturing_details sheet to pull the product/raw materials ID# rather than the product/raw materials name. How can I do this?

  • Hi,
    I have the V2 of the template, but when I place any type of order MFG, SALES or PURCHASE none of the inventory levels are updating. I have tried using the refresh button as you suggest but this doesn’t seem to be making any difference. I am desperate to get my system up and running as I am spending hours updating everything manually in another set of spreadsheets. please can you help.

    • Thanks for using our template.

      At times a broken link or a deleted formula can be a reason for these issues. We will request you to download the file again and use it. In case the issue persists, please email your file along with the list of issues to

      Best wishes

  • How would I track batch numbers associated with the raw materials into a specific product? Every new order of raw materials would have a different batch number and I would need to know which batch I used to make a specific product in case of recall (for example)?

    • Thanks.
      The template does not track the raw materials used to a specific order. If possible, you can use the custom column in Order Details to record the batch number of raw materials used in a Sale or Mfg order. It has to be manually entered.
      Please let us know your feedback.
      Best wishes.


Leave a Reply

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