Free Inventory Management in Excel for Manufacturing Businesses - Inventory Spreadsheet

[@Sabitalwar85]

This has taken away months worth of headache for me! Thank you so much!!!

[@indzara]

Glad it helped! Best wishes.

[@greenday1guitarfreak]

This is MASSIVE help and you have just saved me so much head ache. Thanks so much!!

[@indzara]

You are welcome, we are glad that our template was helpful. Please do check our premium version of the template with additional features at the below link: indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

[@ghulamullahkhan597]

Absolutely amazing sir please add with this sale invoice to arrange stock automatically .

[@indzara]

Thank you for the compliments. Really sorry for the delayed response. Somehow missed it. indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ combines inventory calculations with invoice generation as well. Best wishes.

[@itzasma7514]

Thank you sir, this video is very helpful may god bless you

[@indzara]

Glad it helped. Best wishes.

[@jasonjebeles6517]

This sheet meets my needs perfectly. I saw in a previous comment (2years ago) you have not tested them with Google sheets. Is that still the case? I have tried to import it and most of it works great but some glitches that keeps me from using it correctly. is there any guidance you can give toward this end. Again this sheet is perfect for me but I will have to use it on Google. Thanks in advance.

[@indzara]

Thank you. Sorry, I have not tested further with Google Sheets. I don't work in Google Sheets regularly. Thanks & Best wishes.

[@HilalKhan-rq6bh]

exactly what I wan, and tried a lot, you save my tone of time. Thank you so much.

[@indzara]

You are welcome. Best wishes.

[@somesbhowmick2082]

Simply Great, It helps lots of small business

[@indzara]

Thank you for sharing your valuable feedback. Best wishes.

[@SaMiChi]

is there a version that calculates COGs? I would like to see margins on my products and how each product performs.

[@indzara]

Thank you for showing interest in our template. Yes, our premium version of the template has the requested feature. Following is the link to the same for quick reference: indzara.com/product/inventory-management-excel-templates/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

[@gatoe21]

Hi Thanks for this - Works perfectly in what i need to achieve - IS there possibility to change order type ?

[@indzara]

Thank you for showing interest in our template and you are welcome. Order types present in the dropdown are hardcoded into multiple formulas, hence changing the same involves multiple formula correction as well. We take customization projects for additional fee, you can write to [e-mail] for estimation. Best wishes.

[@KidsShowtimeOfficial]

How would I trace all those manufactured selling items? Example, if will make pancakes with 1kg flour as main ingredient and that flour I can create let say 10 portions…but the system knows only by 1kg and the selling items by per pc so how the systems deduct the selling items to manufacturing?

[@indzara]

Thank you for showing interest in our template. The requested feature is available in our premium version of the template. Following is the link to the same for quick reference: indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

[@apurevaaquatech7952]

thank you indzara you have solved my stock keeping headache soon will contact you for pro version

[@indzara]

You are welcome. Glad to hear. Best wishes.

[@mikot4439]

Thank you sir, this template is a Great help . Is there any way to factor in finished goods in the template. I wanted to differentiate finished goods and sales . Thanks Again !

[@indzara]

You are welcome and thank you for showing interest in our template. The requested feature is available in our premium version of the template. Following is the link to the same for quick reference: indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

[@mikot4439]

@@indzara Thanks for the prompt reply

[@marcosdelmestre8899]

Thank you very much!! Great work!! Do you have any cashflow tool to link with this sales and puchase file?

[@indzara]

Thank you for sharing your valuable feedback. Yes, we have a cashflow management tool for small business. Requesting to check the same in the below link: indzara.com/product/small-business-finance-manager-excel-template/ Best wishes.

[@lazmarface]

Hello sir. This is very helpful and well done ! It could be even better if you could make it following the cost of BOM used in every order. That means that we give in BOM the initial price per unit of row materials and then in every reorder of row material the new amount is added to the initial, and in every order that we produce a product the cost must calculated from the average price of the row materials.. thanks again

[@indzara]

Thanks for feedback. Thanks for suggestion to add cost. Will look into adding it in the next version. Best wishes.

[@gigigigi5181]

would this be good for candle making and does it deduct materials as you create a new product?

[@indzara]

Thank you for showing interest in our template. This template can be used for all Manufacturing business. Best wishes.

[@satoshi.1999]

Very Helpful, home can share the template. Thanks

[@indzara]

We are glad that it was helpful. indzara.com/2016/08/free-manufacturing-inventory-tracker/ Best wishes.

[@chakablazy]

Thank you. Will this work if exported to Google Sheets?

[@indzara]

We have a separate template with same functionalities created exclusively for Google Sheets, here's the link for the same: indzara.com/free-google-sheet-template-for-manufacturing-inventory-tracker/ Best wishes.

[@zmeme-9]

what will be the unit of measure in BOM, not working properly because below the header unit of measure nothing appears.

[@indzara]

Thank you for showing interest in our template. The unit measurement in BOM must be same as the unit measure entered in Raw material sheet as starting inventory or Raw Material purchase order. It does not depends on the Unit measurement entered in BOM and it is just for reference. Best wishes.

[@stevesolero4958]

Hi dear and good day , kindly advice how much u might charge to customise a helpful excell for manufactury needs , for different products at once , in stock , out stock , invoice numbers , raw material available , consumed , raw material ordering plan etc .....

[@indzara]

Thank you for reaching out to us. Requesting to check our Manufacturing Business Manager template which has all your mentioned requirement. Following is the link to the template: indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ Requesting to contact [e-mail] to know more about our customisation fee. Best wishes.

[@brunotvthebrunochannel]

Hello , I am ready to customise a template for your need i.e procurement , order , store management, production to finished goods template

[@rossmarchand3804]

Much appreciated for your time and share of this.

[@indzara]

Thank you for sharing your valuable feedback.

[@mibkl]

Thank you for this great tool!

[@indzara]

You are welcome. Best wishes.

[@ayushsoni7107]

i wish you to make stock managment video on jewellery manufacturing

[@indzara]

Thank you for showing interest in our template. Please share us your requirement that are not fulfilled in this template at the below link to assist further. support.indzara.com/support/tickets/new Best wishes.

[@youthrevivalforchrist4922]

Hello how are you? I have the latest window but it won’t let me download it. It says the link contains some blocked contents. How can I fix it? Also do have a paying version of this where you can see the cost of good sold?

[@indzara]

I am doing well. Hope you are doing well. I believe I have emailed you a reply. Please let me know if you didn't receive it. Please send me screenshots of the error message. I have seen Internet Explorer / Edge throw error sometimes. We want to resolve it. There is no issues with Chrome. Best wishes.

[@elizabeth9270]

thank you very simple and easy to use

[@indzara]

Thank you for sharing your valuable feedback and you are welcome. Best wishes.

[@dricstyles]

Please I already have stock of finished goods in stock already , how do I factor that into the raw materials needed to had produced it?

[@indzara]

Thank you for showing interest in our template. Yes, first you will have to create a manufacturing order to add the starting inventory. Then enter the starting inventory of the Raw material equal to the negative quantity displayed. Then add that starting inventory quantity with your current available raw material. You can also purchase our premium template where you can enter the starting inventory for products. Following is the link to the template: indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

[@kunal2000jee]

Could u plz make same type of inventory for construction field to find out the matching front analysis for piping spool based on the material availability

[@indzara]

If you are referring to finding the number of products that can be made with the available materials, you can get the same from our Manufacturing Inventory and Sales Manager template. Following is the link to template for quick reference: indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ If this does not solve your requirement, please share your requirement at the below link in an excel sheet with sample input and sample out required for estimation. We take customization projects for a fee: support.indzara.com/support/tickets/new Best wishes.

[@jhoward1088]

did you have any WIP temple?

[@indzara]

Thank you for reaching out to us. I believe WIP refers to Work In Progress. If it is Work In Progress, we have multiple template to track the same starting with EVM (Earned Value Management), Project Planner, Project Manager, Task Manager. Following are the link to the templates: EVM: indzara.com/2016/02/earned-value-management-free-excel-template/ Project Planner: (Multiple projects) indzara.com/product/project-planner-advanced-excel-template/ Project Manager: (1 project in-depth analysis) indzara.com/product/project-manager-excel-template/ Task Manager: indzara.com/product/task-manager-advanced/ Best wishes.

[@jhoward1088]

@@indzara thank you so much

[@brunotvthebrunochannel]

Do you require a wip or finished goods products ??

[@ammarsaneej]

yes it's useful.have you already done this inventory management for other manufacturing business like which manufacture machines or tables & chairs or specially for caravans or something like that. if so can you give me the link or can you do a video about that ? thank you

[@indzara]

Thanks. Can you please clarify what the difference is with other manufacturing businesses like tables or chairs? This template can be applied to businesses where we can have a simple recipe (BOM), and there are no sub-assemblies. Best wishes.

[@harshagarwal9862]

Dear Sir, Greeting!! This template is very useful for my organization.. However some customization is required for my business.. I am ready to the pay the price for the changes.. Are u taking personal projects now? Would b glad if the answer is in affirmative!! Would help me a lot in my business

[@indzara]

Thanks. Glad to hear that it is useful. I am planning to open up for customization projects soon - hopefully within a couple of months. Please send your requirements to [e-mail]. Depending on the requirements, I can provide my feedback on cost, feasibility and timeline. If you need something immediate, I am sorry that that might not be possible at this time. Best wishes.

[@brunotvthebrunochannel]

Hello I am ready to assist you to get a good template , i.e for procurement , stores and production and finished goods

[@jersonmoreno1212]

Hello one question, what if I have a firm orders, banana Berry Shake 4 and Apple banana Shake 2, since they both have the same raw material (banana) you have enough bananas to build 2 shakes, If I check on the report how many I can build for berry shake it will say 2 if I I select apple banana shake it will say 2, I go with the customers and tell them I can make 2 each and I have enough to fulfill their demand but truly I only make two total, when a FGs use same raw material how can I check how many pcs can o build considering each FG has its own demand?? Thanks for your help

[@indzara]

Thanks for this thoughtful question. Currently this functionality is not in the template. I need to build in a future version. Best wishes.

[@eltonleung1387]

@@indzara may I know if the share raw materials issue has been fixed. I love to buy your template if it let me spent less time on tracking raw materials. My products have a lot of share parts and will definitely run into the false projection that mentioned above.

[@tesshensch]

​@@indzara Thank you for sharing this template. I seems easy enough to modify some aspects of it to suit my business model. However, I have the same question regarding one raw material being used for multiple products which can result in misleading calculation of availability of the raw material. Has this issue been addressed in an updated version? Looking forward to your reply.

[@indzara]

@@tesshensch Currently, the feature is available in our premium template. In our premium version of the template, once the orders are added you will have the option to check what are the products that can be fulfilled using the available Raw Material is shown in the invoice sheet. For example: Product 1 uses RM 1 and RM 2 Product 2 uses RM 1 and RM 3 Order placed for Product 1 and Product 2 one after another and RM 1 is available only for Product 1, the template will let you know that you cannot fulfill the Product 2 order. Following is the link to the template for quick reference: indzara.com/product/inventory-management-excel-templates/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

[@dricstyles]

Please I am into the manufacturing of animal feed. Can I use this template?

[@indzara]

Thank you for showing interest in our template. Yes, you can use this template for all manufacturing related business. Best wishes.

[@niweblaise807]

hey, please ! let me know if you practice this templates and I wish you can share me your experience. thanks

[@zainabcham8152]

This is very helpful but I definitely need the formulas for the order colum on the raw material sheet.

[@indzara]

Thank you for showing interest in our template. You will have full access to the template and you can view/edit all the formulas in the template. For further assistance, please share you copy of the template along with some screenshot highlighting your requirement at the below link: support.indzara.com/support/tickets/new Best wishes.

[@commonkumar3710]

How can we sahre this with my different workers...or how can we work in Google sheet

[@commonkumar3710]

Share* online

[@indzara]

Thank you for showing interest in our template. You can upload the template to Microsoft OneDrive and use Excel online to share the template to your employees and edit simultaneously. This is similar to Google Sheet and Google Drive. We also have a Google Sheet version of the template. Following is the link to the same for quick reference: indzara.com/2020/04/manufacturing-inventory-tracker-free-google-sheet-template/ Best wishes.

[@stevestrange8130]

Can apple numbers do this as well?

[@indzara]

Thank you for showing interest in our template. Currently, the excel template does not work in Apple Numbers application. Best wishes.

[@stevestrange8130]

@@indzara would you be interested in building a simple inventory only template for me as paid job. Your current paid for inventory has many extra features we don’t want in it. I would need most of the $ side of things removed without messing up the other formulas. We really would like an inventory that removes all the sub components when the main product is built and put into inventory but not adjust them when it’s sold from the shelf. That’s all it needs to do

[@breaknews360]

Good day, I have a question, when I enter data in the ORDER tab, there is NO EFFECT in the formula, the data never change

[@indzara]

Thank you for showing interest in our template. We are unable to replicate the highlighted issue. Hence requesting to share your sheet with the highlighted issue to [e-mail] to check further. Best wishes.

[@777patha]

Helped a lot. Thanks.

[@indzara]

You are welcome. Best wishes.

[@jibranzafar4795]

Hey that's a great work you did. But I still have issues as I am a window door fabricator and all windows are completely customised products ( size, hardwares, etc). Can you please help me build an inventory management sheet which gives me accurate inventory tracking.

[@indzara]

Thank you. Please email your sample data and requirements to [e-mail] We will review and provide you feasibility and cost for development. Thanks & best wishes.

[@emmanuelobioma1520]

Can this template work for libra office

[@indzara]

Thank you for showing interest in our template. No, our Excel templates are not compatible with open office or libra office. Best wishes.

[@justarandomthought33]

Can you please share the formula of how many products can be made and available raw material now

[@indzara]

Thank you for showing interest in our template. The number of products that can be made and raw material available both are calculated from the BOM sheet. It is not calculated using a single formula. The number of Products that can be made is the minimum Raw Material available quantity according to the units required. Available Raw Material Now is the Starting Inventory + Purchase - Sum of Used Raw materials from BOM sheet. You can download the template from the below link to view the formulas: indzara.com/free-excel-template-for-manufacturing-inventory-tracker/ Best wishes.

[@northofsixty2]

Great template, it would be nice to have a cost column in the raw materials tab the would calculate total cost per product in the BOM tab,

[@indzara]

Requested feature is available in our following product: indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

[@sai1766]

Good , i am working in civil store . I want material management for each department like civil, electrical, plumbing, etc in one excel sheet . How can I make inventory and find out material easy. Please help me

[@indzara]

This template is to track inventory in a manufacturing setup. Please provide more specifics on your requirements. Best wishes.

[@hrithikjain5645]

I have a major product which has 2 sub products, which are made up of raw materials,how to make a entry of that? Please help.

[@indzara]

Sorry, that is not supported in the template. The template currently only supports manufacturing of products from raw materials - no sub assemblies. We will try to build in future. Best wishes.

[@mconconnector4521]

Rawmaterial quantiy not automatically updating while entering sales and purchase..What to do?

[@indzara]

Please email file with questions to [e-mail] Best wishes.

[@kdedhia]

Hi what if there are multiple level of finished product can use semifinished products as product and as raw material

[@kdedhia]

Btw the sheet template is simply amazing thank you so much

[@indzara]

Thank you for sharing your valuable feedback. You are welcome. Currently, the template does not support manufacturing the product using another manufactured sub product. This can be taken as a customization project for a fee. Write to us at the below link for estimation. support.indzara.com/support/tickets/new Best wishes.

[@manishasheth2391]

What if you have a few steps in the process - so if it goes from flour to dough to cookies for eg and I need to track how much dough I have at any point as well as how many cookies are available? So its a two step calculation... pl advise

[@indzara]

Sorry, it is designed for only one level of BOM. Best wishes.

[@yogeshagrawal1608]

also in order page against product , availability is not displaying ( auot calculation ), same sale item , the raw material should be deducted , not happening , pl guide

[@indzara]

We are unable to replicate the highlighted issue. Please verify whether the formula is available, if it was accidently deleted, please duplicate the formula from the previous row by pressing CTRL+D. If the issue still persist, please share your copy of the template with sample data having the highlighted issue at the below link to assist further: support.indzara.com/support/tickets/new Best wishes.

[@Pankaj-Verma-]

Best ~~ thank you for your kind help sir !

[@indzara]

You are welcome. Best wishes.

[@zuhaibm5]

is that possible that i want to write all Daily availability Check in next sheet where i dont want to drag one by one juices i want to see availability of all juices in next sheet is that possible because im doing it from last 3 hours but unsuccessful in that

[@zuhaibm5]

@Indzara ??

[@indzara]

The formula is entered as an array formula. Please make sure that when you copy, it is an array formula. Alternatively, you can use the MINIFS function support.office.com/en-us/article/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599 for newer Excel versions. Best wishes.

[@jaimebrown8097]

How can I modify it to include an extra step, ie I process 3 raw materials into a new material that is then, in essence, a raw material for the final product for sale. The inventories of raw materials, processed materials, and finished goods need to all be tracked

[@indzara]

Thank you for using our template. The requested feature is currently not available in our template but we can take it as a customization project for additional fee. Requesting to contact [e-mail] to receive a quotation. Best wishes.

[@jeduarmar1007]

Hi there I am having an issue with the BOM sheet. it could be due to the fact that I am using google sheet for this document. but I am not entirely sure. For some reason, I cannot select the products that I have plugged in on the Product worksheet. and I get the note from google sheet anytime I type "There was a problem The data that you entered in cell A10 violates the data validation rules set on this cell."

[@indzara]

Thank you for using our template. I hope you are using the template from the below link: indzara.com/2020/04/manufacturing-inventory-tracker-free-google-sheet-template/ If yes, requesting to share your sheet to [e-mail] to check further. If you have uploaded the Excel template to Google Sheet, I would like to inform you that Excel template will not be supported in Google Sheet. Hence requesting to use the template from the above link to use this template in Google Sheet. Best wishes.

[@jeduarmar1007]

@@indzara Thanks downloaded and sent the request to edit! Look forward to hearing back

[@HatisaXarin]

The sheet is very good but there is no traceability and report option

[@indzara]

Thank you for showing interest in our template and sharing your valuable feedback. Currently, our premium version of the template has the Reporting feature. Following is the link to the template for quick reference: indzara.com/product/inventory-management-excel-templates/manufacturing-inventory-sales-manager-excel-template/ Regarding traceablity, Can you share more details of this concern to us at the below link to check further? support.indzara.com/support/tickets/new Best wishes.

[@amosusegun500]

Thank you for the video... Please I have a fabrics factory, and employees that produce for me.. sometime they do bad job and no one will tell truth about who does the job. Now i want to assigned a default bar code that will reveal who does the job. how do i go about it?

[@indzara]

You are welcome. You can add a column to track who created the order. However, the template is not connected to any bar code scanner. Sorry. Best wishes.

[@BlueWrenFilms]

Is there a way to have multiple lot's/batches for each raw material and product?

[@indzara]

Currently lots/batches are not tracked individually. Once the raw materials are purchased, they becomes part of the total inventory. Best wishes.

[@yogeshagrawal1608]

sir i want to add @ 50 item per product ( 15 products ) to process . i am unable to enter more than 5 items per product just now . how can we resolve that . pl guide

[@indzara]

Thank you for showing interest in our template. Our template is not limited to the number of items to be configured in BOM to manufacture a product. You can manufacture a product with any number of items. We use Excel tables for data entry. Hence please ensure whether the data is entered inside the table. If the data is entered inside the table and still facing issue, please share your copy of the template file with sample data having the highlighted issue at the below link to assist further: support.indzara.com/support/tickets/new Best wishes.

[@chewieonthefarm9332]

How could i add automated purchase order with number to my suppliers with this template

[@indzara]

Thank you for showing interest in our template. Please share some sample input data along with the requirement of expected output at the below link to assist further: support.indzara.com/support/tickets/new Best wishes.

[@lovedbeyond2710]

Hello, for some reason our "Today's Availability Check" function doesnt work, any way that we can fix that? When we choose a product on the cell E4, nothing shows up in the cell F4 and it remains blank even if the call F4 has the formula written for it.

[@indzara]

Please email your file with questions to [e-mail] Best wishes.

[@howtonotbefunny9560]

The raw materials isnt being deducted when I place a sale order in the Orders sheet. Why is that?

[@indzara]

We regret the inconvenience caused. We are unable to replicate the highlighted concern. Hence please share your copy of the template with sample data and some screenshots highlighting your concern at the below link to assist further: support.indzara.com/support/tickets/new Best wishes.

[@tarunsharma5951]

Hello Sir I need one help I want to know that how can I increase my HIT RATE B as it's based on safety stock and service level.

[@indzara]

Can you please explain Hit Rate B in detail? Best wishes.

[@abdeali5321]

Can you please advise How to calculate COGS with this report or with the help of this report????

[@indzara]

Very Sorry, COGS is not built-in. Best wishes.

[@chasaston8254]

Is it easy to add an SKU column for each new raw material ?

[@indzara]

Thank you for showing interest in our template. Yes, you can add column to store the raw material's SKU but barcode scanning is currently not available in the template. Best wishes.

[@rkexcel2686]

सर,- मिल्क(MILK) कलेक्शन के लिए एक्सेल की फाइल चाहिए थी क्या आपके पास कोई ऐसी फाइल है जिसमें AM PM का मिल्क स्टोर हो जाए | और उस का बिल मंथली बन जाए|अगर है तो मैं उसे खरीद सकता हूं आप मुझे उसका मूल्य बता दीजिए अगर नहीं है तो क्या आप उसे बना सकते हैं अगर बना सकते हैं तो उसका मुझे डेमो दे सकते हैं ताकि मैं उसे चेक कर सकूं और जो भी कमी है उसे मैं आपके द्वारा ठीक करवा सकूं

[@sarveshsingh1867]

How can I manage my inventory in case we we buy spent mix solvents and send it for recovery to another and then get back recovered products like Isopropyl Alcohol, Methylene Chloride, Acetone etc, which we sale. Please help me to maintain stock of these items in excel.

[@indzara]

Thank you. Can you confirm if you convert raw materials to products and sell those products? if so, the template should work. If your business process is different, please clarify. Best wishes.

[@sarveshsingh1867]

@@indzara Yes We send crude materials to recovery plant and get recovered various products. Thanks for reply.

[@sarveshsingh1867]

I want to include Units of measurements like Bags, kgs, tonne, litres, and also GSTIN, HSN Code in this template for the products without interfering macros in this template.

[@Lebomoyo]

Thank you so much for this. Is there anyway i can factor in damages or defects of raw materials into the template? Or do you have a template that has that?

[@indzara]

You are welcome. You can enter a dummy purchase order with negative quantity to reduce the inventory due to defects/damages. Best wishes.

[@rkdistributors7801]

Sir purchase order karne ke baad iska effect raw material ya bom Pe nahi aa raha

[@indzara]

Thank you for using our template. Requesting to share your sheet to [e-mail] with some screenshot highlighting your concern to check further. Best wishes.

[@shahabjavidfard7699]

I can't thank you more ❤

[@shahabjavidfard7699]

my order sheet doesn't work properly, it seems that doesn't recognize other tabs, what should I do?

[@indzara]

Thank you for showing interest in our template. We regret the inconvenience caused. I am unable to replicate an issue on the orders page from my end. Hence, please share your copy of the template with sample data and some screenshots highlighting your concern at the below link to replicate check further from our end: support.indzara.com/support/tickets/new Best wishes.

[@rajdeepchatterjee4880]

sir, what if the recipe/formula for a product has to be altered often as per requirement? Then where to change it so that it would be effective throughout the whole template.

[@indzara]

In this template, each product can have only one recipe/BOM. For a new recipe, please use a new product entry and enter BOM details. Best wishes.

[@muttalibmusah2762]

what does the L and S in front of the product name in the bill of material sheet mean?

[@indzara]

Thank you for using our template. The L and S in product name refers to Large cup and Small cup juice. Best wishes.

[@ahsonrehman8449]

Can you modify this to some of my needs if I were to compensate you?

[@indzara]

Thanks for your interest. I am currently not able to take on new customization projects. Sorry. Best wishes.

[@brunotvthebrunochannel]

Hello I can help customise the template for you

[@NehaSingh-jg5ob]

Hi sir Do I need to see your last year video on manufacturing inventory template or not after learning this?

[@indzara]

Can you please clarify your question? Which video are you referring to? Best wishes.

[@Kobe26592]

Great...Thanks a ton

[@indzara]

Thank you for sharing your valuable feedback and you are welcome. Best wishes.

[@belight-led]

Thanks a lot for sharing this file

[@kindustries17]

I managed to upload this file to Google. I entered my raw materials and list of products. In the BOM and ORDERS Sheet, the drop down says "loading". It's been 10 mins....and I refreshed the page...nothing :(

[@indzara]

Please use in Microsoft Excel. The template is not designed for Google sheets. Best wishes.

[@kindustries17]

@@indzara Thanks!

[@pallavisharma8163]

Hi Sir, Thanks for sharing this file.. request you to please suggest if my unit of measure is leter i.e for liquid inventory...

[@indzara]

You are welcome. The unit can be anything, but it has to be consistent for a product/raw material. Best wishes.

[@keeganjlwandamina3558]

hello thanks alot. I have a little problem there is nothing on the availability.How do i go about it?

[@indzara]

Please email the file and detailed explanation of your questions to [e-mail] Best wishes.

[@indzara]

Please email the file and detailed explanation of your questions to [e-mail] Best wishes.

[@indzara]

Please email the file and detailed explanation of your questions to [e-mail] Best wishes.

[@keeganjlwandamina3558]

@@indzara Thanks I managed

[@FMAyman88]

Hi Indzara, The link for the excel is not working

[@indzara]

We regret the inconvenience caused. We have tested the download link and it is working. Following is the download link for short reference: indzara.com/wp-content/uploads/2016/08/Mfg_Inventory_Tracker_v1.xlsx Best wishes.

[@matthewh9407]

so there is no tracking of costs for your raw material? example: making a "super orange smoothie" costs me: $1.20 in "parts", I sell for $4.00 profit = $2.80 the sheets have no monetary references?

[@indzara]

Yes, you are correct. This template addresses only inventory part and not the costs. I will be adding that to the Manufacturing Inventory and sales manager template soon. indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

[@prashantsatani3730]

verry usefull software but i have a some problem in softwer how manage only PURCHASE RAW MATIRIAL ony SALE PRODUCT how sale raw matirial send me replay

[@indzara]

Thanks. Can you please clarify what you mean by how to manage? Thanks. Best wishes.

[@prashantsatani3730]

how sale 2 apple apple is a raw matirial coloum but apple banana shake is a product so product is sale but raw matirial not sale how sale it ? thank you

[@indzara]

To sell raw materials also, please enter the raw material name again in the Products sheet. then, for BOM, enter 1 unit of Raw material A makes 1 unit of Product A. Best wishes.

[@jillmynard4769]

If I enter B.O.M details first will all items automatically be entered in raw materials??

[@indzara]

After entering the BOM details, when we enter a product sale order, the raw materials inventory level will automatically be updated. Best wishes.

[@teresalgeorge]

I have purchased this spreadsheet and have entered products and raw materials but when I go to build manufacturing of products raw materials are not available as a drop down on that page nor are they available as a drop down on the order sheet so that I can select them. what am I doing wrong?

[@indzara]

+teresa george please email me the file at [e-mail] It should be about where the product was entered or where the drop down is expected. I will review and get back to you. Thanks.

[@numode]

Hi, this template seems great, does not seem to work in google sheets though?

[@indzara]

Thanks. Sorry, I haven't tested my templates with Google Sheets. Most of them are expected to be not compatible due to the difference in features between Google Sheets and Microsoft Excel.

[@TivertonAudio]

Do you have a version that puts purchase orders and sales orders on different pages?

[@indzara]

I am sorry. I don't have a version where purchase and sale orders are on separate pages. Thanks. Best wishes.

[@arvindkumarbhagat7457]

I make doors of same style with with diffrent size then how put into In exeel

[@indzara]

Create each size door as a separate product. They may require different raw materials and quantities. Best wishes.

[@sagorikabasu3005]

pls tell me an inventory management software under the heads of raw materials, processed goods and finished goods.... its quite urgent!!! pls help me

[@indzara]

I am sorry. I don't have any other recommended software for inventory management. Best wishes.

[@siddharthbhagat8458]

I am unable to find solution for my business. I tried countif formula but not worked. I have an stock of accessories. Each accessories have unique number (Serial numbers), I want to count that on another page where I can see how many same items are available. Pls help me.

[@indzara]

Please email file with specific questions to [e-mail]. We will do our best to help. Best wishes.

[@niweblaise807]

hey, please can you share me your experience within this templates. thanks

[@gd4677]

Is there any templet for production process scheduling and controling?

[@indzara]

Can you please provide more details? It will be helpful to understand so that we can build in the future. Best wishes.

[@abid786100]

Sir Greeting , We are Manufacturer of a Mechanical Equipment can you please create a Excel Template for me our main requirement is reporting and receiving/ issuing on month end in summary and detail. We procure material as per project base and BOM, i want a template that when i going to receive or issue any item or material the of project must be there and once project complete or in between we want to check how much material we procure and issue for specify project.

[@indzara]

Thanks for your interest. I don't have the template specifically. The template for Manufacturing business indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ includes reporting, invoicing and inventory. Please take a look. Thanks.

[@brunotvthebrunochannel]

Hello I can customise any template to suit your needs

[@samkab677]

Suppose i purchased and entered 100 units and the next day in delivery i received only 90.what to input in here ?

[@indzara]

Thanks. You will have to input that order as two lines. same order number, order date and raw material. However, the expected date will be different. 1st line: 90 units Expected date : Next day date; 2nd line: 10 units Expected date: when you expect the remaining 10. Expected Date is the date when the inventory reaches or leaves your location. Best wishes.

[@gandhravkapahi9971]

Sir do i need to fill up the green templates in bom sheet to fully utilize the software or u just told to ignore the first column of raw materials units used till now

[@indzara]

The green columns are all calculated automatically. Please do not edit them or enter any data there. If there are further questions, please email file to [e-mail] Best wishes.

[@darpan344]

Everything seems to be fine. But it would have been much better if i could print the sale order or purchase order to my staff.

[@indzara]

Thank you. Manufacturing Inventory and Sales Manager Template can generate the invoice indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

[@skyskyaway9768]

I have downloaded the free template I believe but it seems to be view only?

[@indzara]

It should not be read-only. Please save the file in a safe folder (sometimes files in Downloads folder can just open as read-only). Also, if you are not opening in a compatible Excel version, it could happen. Excel for Windows 2010 or above, and Excel for Mac 2016 should be compatible. Please let me know. Thanks.

[@samkab677]

What if a new BOM occurs ?

[@indzara]

Every new BOM needs to be entered as a new product. Best wishes.

[@ThuriGaN]

Hello Sir. If I want to see in parallel multiple products availability how can I do it ? I tried to copy row 4 and insert it below multiple times and delete from formula the "$" but is not working. Although I don't receive an answer many thanks for your file !! It's amazing :D

[@Ceecee384]

Hi, I'm working at a manufacturing company and I think this template is closely related to our business. I was wondering if I can get your email and I can talk to you for help in tailoring it more closely related to my company.

[@indzara]

Thanks for your interest. I am currently not taking any new projects. Sorry.

[@brunotvthebrunochannel]

Hello do you require a good template for production and finished goods products ?

[@KNOWBUDY1]

How do you get this for free?

[@indzara]

Please download for free from indzara.com/2016/08/free-manufacturing-inventory-tracker/ Best wishes.

[@dharmendrayadav-bw2gp]

Thanks sir.

[@indzara]

You are welcome. Best wishes.

[@amazingworldofjoannaandcar4040]

Please the formulas put

[@indzara]

You can download the templates from the following link and explore the formulas: indzara.com/inventory-management-excel-templates/ Password to unprotect the sheet will be indzara Best wishes.

[@utpalbhattacharya429]

We need BOM

[@indzara]

Thank you for showing interest in our template. Yes, the option to setup the BOM is available in the BOM table. Best wishes.

[@pramathparashar5355]

7:10 Availability is not working

[@indzara]

Please email file to [e-mail] and specify your questions. Best wishes.

[@niweblaise807]

hey !! can I reach to you inbox please! if its possible

[@indzara]

Yes, you can email your concern/queries to [e-mail] for further assistance. Best wishes.

[@himanshu641]

Can you halp me

[@indzara]

Thank you for reaching out to us. Yes, we will be glad to help you. Requesting to share your requirement/concern to [e-mail] to check further. Best wishes.