80 reviews for Manufacturing – Inventory and Sales Manager – Excel Template
Manufacturing – Inventory and Sales Manager – Excel Template
If you buy raw materials and convert them to products by assembling or manufacturing, then you can use this Inventory Sales Excel Template to manage the inventory of products and raw materials.
Manage price changes in your products and raw materials. You can also create three different types of orders (Purchase, Manufacture, Sale and Stocktaking Variances) and print invoices.


In the first scenario, you are not holding finished goods. In the second one, you are.
Enter list of raw materials in the RAW_MATERIALS sheet. Each line should be a separate raw material as shown below:

Enter the starting inventory needed and the point at which a re-order needs to be placed.
Similar to the product sheet, here too the template allows you to specify whether the raw materials are taxable or not.
A key feature of this template, you can enter the price details (Sale Price) of each of the products while also specifying its manufacturing cost.

Similarly, for all the raw materials you can enter the purchase price in this sheet.

The manufacturing cost is automatically calculated in the sheet, all that you need to enter is the product name and the price effective date, as shown:

Enter details on how raw materials are converted to products.
In the image below, please see rows 1 and 2. You can see that 2 Bananas and 3 Strawberries are needed to make 1 unit of Banana Berry Shake (L).
See rows 3 and 4. 2 Apples and 2 Bananas are needed to make Apple Banana Shake (L). The Excel template can now understand how inventory needs to be calculated for raw materials and products.

Additionally, the template shows the raw material status after each entry of raw materials required per product.
In detail, you can view the inventory that are to be used , what inventory count is available after the corresponding product is made. This also shows, with the remaining inventory, how many finished products can be made after the current product.
Enter Partners’ (Suppliers and Customers) information in the PARTNERS sheet. This will be used in invoice later.

Once the details are used in different order types, this sheet updates each partner’ sale and its rank and purchase and its rank:

Enter the list of orders in the ORDERS sheet. Each line represents an order.

Here, the template can handle the scenario where the order date and the expected delivery date are different.
Here, at order level, one can specify the payment due date, additional charges, discounts and tax rates as shown above.
Note: Expected date is the date when the inventory will be impacted.
It’s easy to enter the order line items in the Manufacturing Inventory Sales Excel Template.

Can handle discounts at unit level.
Kindly ensure to enter the order details in the same order in which you would enter/raise invoices. This is because the available inventory calculations are based on chronological entries.
INVENTORY LEVELS
You can instantly view overall current inventory levels (Products available, Quantity and also number products to be re-ordered).

CHECK INVENTORY AVAILABILITY
You can see availability of any product by selecting it from the drop down menu.

View the product report (fully automated) which provides all the inventory information at the product level.

This report shows inventory which are under manufacturing, as finished good and as raw material for the corresponding product:

View the report (fully automated) which provides the inventory information for each raw material.

Enter Order Number to create the invoice. Amount calculations, Tax calculations and discounts will be automatically handled by the template.

You can customize the invoice to choose from different header information like Partner Name or Partner Id etc.
Similarly the descriptions for the invoice can also be customized.

You can change the logo easily by right clicking on the image and changing picture.

As an additional feature, you can evaluate whether there are enough inventories and/or raw materials available (based on invoice type) to achieve the particular order. This detail is not in the printable part of the invoice, but can be viewed immediately to the right once the required order no is entered.

The template can track any expenses made based on the date.

This dashboard is fully automated and displays key reports and metrics needed for manufacturing inventories and sales.
The current status of products and raw materials and status on the inventories.
This also includes, accounts receivables (from customers) and payables (due to suppliers) and also the corresponding ageing report.

For a given start and end date duration, this gives a snapshot of product sales and raw material manufactured report; the stocktaking variances as quantities and variance amounts, along with profits as shown:

Important sale and purchase metrics are provided per month along with the monthly trend chart for a chosen metric.

Sort the top and bottom-performing products based on various metrics like quantity, amount or margin.

This shows how each product has performed (i.e the sale trend) which can further aid in choosing whether the product actually drives profits.

Here, you can get a quick view of each of your partners’ performance based on the quantity of sales, purchases, and stocktaking variances. You can also see the top-performing customers and suppliers based on sales and value (amount), respectively.

All files are free. Download only the ones you need.
Some sheets are protected so their formulas aren’t changed by mistake. To unprotect a sheet, choose Review › Unprotect Sheet and type the password indzara (how to unprotect sheets).
| File Name | Download |
|---|---|
| Manufacturing Inventory and Sales Manager Excel Template v3.6 | Download Now |
| Manufacturing Inventory and Sales Manager Excel Sample v3.6 | Download Now |
Manufacturing – Inventory and Sales Manager – Excel Template
Yes. Every INDZARA template is free to download, and there are no recurring fees.
See Can the file be shared? License Terms for how you can use and share the files.
Some sheets are protected so their formulas aren’t changed by mistake. To unprotect a sheet, choose Review › Unprotect Sheet and type the password indzara (how to unprotect sheets).
Start with the guides below. Our knowledge base has step-by-step articles for every template, and you can always ask us.
Simple and Very easy to use and understand. Got stuck once, but a quick look at the YouTube update on MANUFACTURING – INVENTORY AND SALES MANAGER v2.0 and all sorted. Really like that I can choose the option to hold stock of some of my Items and also manufacture per order, All on one page. BIG HELP!! Set up and adding the data did take a bit long but once it’s all done the template does all the work from there. Love It!!!! Takes 5 mins now to add 3 things daily: what did I “Purchase, Sale and MFG”. Partner Page also helped to keep track of Suppliers reliability. A day delay here or there used to be unnoticeable and costs money in the long run! But NOT ANYMORE!!! Highly Recommend Indzara.
very easy to use and help my business a lot
I really Love the Product it solved my all problem. please keep up the good work. hope we will have version three soon….
I would be interested to buy paid version in google spreadsheets too. Is it hard to transfer?
At the moment, we have a free manufacturing inventory tracker but not a Google Spreadsheet of this premium template. It is not a hard task, since we at Indzara use formulas to achieve our solutions and most of the Google Spreadsheet formulas are different from that of the excel formulas, we take time to test and bring a product to the store. Please mail your product request to support@indzara.com, we can pick it from there – hope this answers your questions. Thanks for your interest, looking forward to bring a premium Google Spreadsheet template very soon. Thank you!
Hey! I tried free version and I love it. Do you have an extended version available in google sheets also? Thx
At the moment, we do not have the extended (premium) version of the template in google sheet. However, you can try our free Manufacturing Inventory Tracker in google sheet.