Manufacturing – Inventory and Sales Manager – Excel Template Support

Posted on

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:


119 thoughts on “Manufacturing – Inventory and Sales Manager – Excel Template Support

  1. 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?

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

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

  3. 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)?

    1. 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 *