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:
- How to Migrate data from v1 to v2 in less than 10 mins?
- Enhancements in v2 compared to v1
- v1 Support Page
145 Comments
Dear Dinesh
I bought v2.0 a while ago, now I really start working with it. It’s such a fantastic tool, thanks again for this great piece of work!
May I ask a question? Since I’m importing raw materials, I have different cost for each order (e.g. product costs from the supplier, shipping, import costs, duty) and I also need to convert currencies.
To know the final costs of a raw material, I need to collect these costs for each order, but I don’t want to have a separate EXCEL file for collecting these information.
Now I wonder if I just could add more colums into the “orders” worksheet for entering and keeping these additional costs per order, what do you think?
Thanks a lot for your hint,
Peter
Thanks for purchasing. I am really glad to hear that it is useful. Please post your review on the product page. https://indzara.com/product/manufacturing-inventory-sales-manager-excel-template/ Thanks.
Yes, you can add columns to the Orders sheet and track other costs which are at order level. Please do not edit existing columns. Use available custom columns and add new ones.
Best wishes.
Hi…I just purchased the Mfg_Inventory_and_Sales manager. It is very useful.
I got one question.
Currently the column “RAW_MATERIALS.RAW MATERIAL NAME” is propagated to column “RAWMATERIAL_REPORT.RAW MATERIAL” .
I would like to add a new column call “RAWMATERIAL_REPORT.RAW_MATERIAL_DESC” which propogate from “RAWMATERIAL_REPORT.RAW MATERIAL DESCRIPTION”.
How can I do that?
Thanks for purchasing.
Steps to add:
1. Unprotect the ‘Raw Material Report’ sheet using password provided in the ‘About’ sheet.
2. Insert a column after column A in the ‘Raw Material Report’ sheet.
3. Copy the formula from cell A4 and paste in the newly created column B cell B4.
4. Edit the formula in cell B4 and replace reference to ‘raw material name’ with ‘raw material desc’.
Best wishes.
Hi, Just purchased the package and downloaded the file. In Manufacturing details and Order details, the formulas are not there for GREEN columns. Please advice.
Thanks for purchasing.
Please note that the formulas will not appear when no data has been entered in the table. Once you enter data in the input cells, for example, A12, then the formulas will appear. This is just how Excel works by default with tables.
If there are further questions, please email the file to support@indzara.com
Best wishes.
How do I update inventory levels when I do a month end audit?
You can enter the appropriate purchase and sales orders to update inventory. Purchase orders to increase inventory levels and sales orders to reduce inventory levels.
Please let me know if there are any questions.
Best wishes.
This method works when updating the inventory levels of finished goods but what about updating the inventory levels of raw materials?
I added the raw materials as products and sold some units of that product but this doesn’t seem to work for my goal to reduce the inventory level of a specific raw material.
Oh well, I found a way to reduce or increase raw material. I adjusted the purchase orderdetails and reduced or increased the units I purchased from my supplier.
Raw material inventory will be increased by placing purchase orders of raw materials. When products are manufactured or sold, the raw materials (needed to manufacture those products) are reduced automatically from inventory.
Best wishes.
I am interested in buying the manufacturing-inventory-sales manager template. But I have a few questions to check if it suits my needs
1. Can we add new formulae?
2. Once the Raw material order is received, I need to track raw material consumption by production dept and also the number of finished products produced on a daily basis. Also we r not assuming all products made are sold. How can I handle that
3. I will not be using the invoice feature as we have another software that does it.Will that be fine?
4. I want to add reason column with drop down for purchase returns and sales returns..Is that possible
5. I will be implementing it at a production centre and then they would manage it. Would there be any license issues??
Thanks
Thanks for your interest.
The user can edit the template as needed, as password for unlocking will be provided. You can add new formulae. It depends on the type of formula and user’s Excel experience. Template is completely unlockable.
Current inventory of raw materials and finished products are automatically calculated. Product sales is separately tracked.
Invoice sheet can be ignored if you don’t need.
Adding columns can be done by the user.
License is for single user only. Please see license terms https://indzara.com/license-terms/
Please let me know if there are any questions.
Best wishes.
Thanks for your response
I will need multi user license. Which version of your product supports this??
You are welcome.
If you meant multiple users using the same file and entering data at the same time, I don’t have such a template. You can post the file in a shared drive and then multiple users can view it but only one can edit at a time.
Please let me know if there are any questions.
Best wishes.
I would like the item description to show up on me sales invoice. is there an easy way to do this? I could start customizing the spread sheet but I would rather not. can you help me out with this please? My email address is nitingarg2910@gmail.com. From what I have used this spreadsheet is amazing and I have already recommended the retail sheet to my father. I think you have a great product here.
Thanks,
nitin
Thanks for your feedback. I have replied to your email address.
Best wishes.
Hi,
I have bought the excel file and so far so good.
However, I’m having a problem when I enter the data for manufacturing details.
I have entered the data for raw material formula and manufacturing detail but in the column of raw material in order details, it is showing it as 0.
Can you please advise what I’m doing wrong?
Thanks in advance,
Jason
Thanks for purchasing. Can you please email the file to support@indzara.com
I will review and get back to you.
Thanks & Best wishes.
Hello, I just bought your product yesterday. It is really good and I appreciated for your work. I found this problem the invoice has only 1 page with 40 lines so when I try to purchase more than 40 raw materials I do not have the second page of my invoice.
Thank you
Thanks for purchasing. Glad to hear that you find it useful.
The template limits the invoice to 1 page and 40 rows. Is it possible for you to split the order to 2 separate orders?
Thanks & Best wishes.
on a Mac running OS X El Capitan, v.10.11.6
The reporting feature will be limited in Mac. Otherwise, the inventory calculations will work. Thanks & Best wishes.
Will this work with Office 365 on a Mac?
Sorry for the delayed response. The reporting feature will be limited in Mac. Otherwise, the inventory calculations will work. Thanks & Best wishes.