Simple inventory management excel template

Purchase price every time different we can not fix unit price. Report of item should display price. I am trying to download the program. I enter my name and email but never receive the link. I would like to try this. Need to add few columns Unit, Packing description, additional for product type. I have one product list with multiple locations and each location need to maintain idle stock separately.

The procurement happens centrally and as per requirement of re ordering stock report based on closing stock of each location for that month — idle stock is issued to each location.

Would need consolidated as well as location wise reports. Also need to understand consumption for the month for each location.

Dear Concern, The inventory system is perfect for me, but i need to customize this excel file. Hi, I want to upload bulk Entry for New product through uploading csv file. Manual Entry for huge items its take more time. Excel sheet is brilliant. Hope to listen from your side. This is great, and it will be very useful in my department.

But I only need to monitor our item for in and out, No price needed. Can I disable the auto-hide? You can do this way: Skip the price while entering stock in and out, and even a new product.

HI PUNEET, I really liked your template, will like to go with pro version, before that i need some help, we have tiles business, so will you do customisation as per my requirement, there are some customisations i want in your template, pls reply at earliest.

I am interested in this product. I have a few questions? Can it used on MAC 2. How Many products will I be able to add? I have over products 3. Is it possible to add discounts on the invoice based on the product. Will I be able to create labels to print? Can you please help me with it? I need a free template to be used the store managing dairy movement and weekly report Status kindly help with that short and clear one for test, Once it works we can go for another greater step. Can I also have a copy of your template?

Hi, I would like to go for Pro version, before that could you please confirm below concern We having parts business, do we able to change stock items?

Do we able to change the currency? Dear Puneet, thanks for the templates, I have managed to download the free version but am unable to enter anything in it. Are the fields modifiable for my specific application? Is your template barcode capable to generate labels and record inventory based on scanning?

I can send you a list my requirements if necessary. Does the Pro or Dev version allow for easy customization? Hi Puneet, I am from Chandigarh. I need your help. I want an excel where I just scan the barcode of the product and it automatically gets deducted from the actual stock likewise with the Stock In. Do you have such template?

The problem is that every customer is getting a different discount on their ordered products. Is there any possibility to integrate this in your application, because I think that this is almost the perfect application for him. I would like to find out how to get a custom document created for me. How can I get this started?

Can this template be used on a Macbook Pro? Also i would like to know if there is an option to create labels to print Costumers and products. I am in desperate need of a Management Software for my company. Trying the free version before going for the pro version. Even on entering values in the user form, the current stock and stock values shows 0 and -ve.

What am i missing? Can you explain the advantage of Dev version How many user can use Pro version? I wanted to try your free version first before buying the full version, but I did not get the email. How can I resolve this? However I would like to see few screen shots or a video of how it works, if you have that please share it with me.

Hi, Thanks for your response. I have tried the free version and I think its suitable for me. However, when I tried to input the master data and stocks plus the price, the value on the very right cell is still 0?

I made sure the format is in numbers but, I still get 0 result. Which part did I messed up? I liked the excel inventory. Many thanks you for the inventory management tool.

I wanted to learn one thing which will allow me to monitor an inventory by getting alert from the excel when target is set. In simple word, how will i set my report to get an alert when the target given me is below the target. How can we fix the sale price of products and discounts so that employees cannot change while selling? Hi is it okei to add location on it?

Thank you very much for the awesome inventory management tool. Also a special thanks for editing the sheet to have the currency from South Africa. Highly appreciated and will recommend and support you. Can you forward the excel template to my email? Hello, I just downloaded the free version. How can I delete the info in the template? Is there an option to edit a product once entered?

Hi, Need a drop down list to see the single product category. Hi am a Steven smoke I like it, please sent template to my email. I recently purchased the PRO version. Everything is great but i would like to ask a favour. Is it possible to have a searchable drop down for stock in and stock out as we have a long list of items? Close the template once and re-open it and make sure you have enabled your macros. In the drop down list for stock in and stock out is it possible to have a search option from the drop down.

As we have many items and it is difficult to scroll and find. Kindly send me this template my email ID is harishapihhc gmail. Hi i have followed step as you told about macro setting in instruction. I am using the free version and it has really made inventory management very easy. All thanks to you for the effort you put in.

I need the iOS version for the same, if you could please help me with it. Is anything for iOS available? Heyy, Is there any iOS version available for the above template?? It would be really helpful if you can reply asap. I wish to serve you with this in future. I have a doubt about the functioning. I work with a lot of electronic devices as monitors, cameras, etc. And another thing would be if i could make receipts out of this, so customers could sign it in prove that they already took what they bought.

Thanks for your time. In this template, you can create a unique Product ID code for each product and when you go with PRO version there is an option to create an invoice for each customer.

Thank you i have just downloaded the free version. When I click on the Download button for the free version it asks me to put in a first name and email ID. When I put in the information it says that an error has occured while submitting the data and to try again.

I keep trying but I get the same thing. Please help if possible. Thanks for your reply Mr. Puneet, May be I am not able the use the link in a correct way. Please let me know the correct process for using the link. In the mail link, when I have clicked on the Download button for the free version its again asking me to put in a first name and email ID.

When I put in the information it says that an error has occured, while submitting the data and to try again. Please guide me. Thanks for all your support Mr. Hello Puneet, I hope you are doing well. Looking forward for you quick and positive response. Hi Puneet, Thanks for your reply. Taptronic, please share your registered email ID. Want to let you know that I received the template now.

Thank you! Can you send that template to me too? Do i need to delete the old data from every sheet sfter unhiding each sheet Or Do i need to delete the data from stock report. Do for stock-in and stock out as I said in the above comment.

And for product master sheet, add your all the products first and then delete all the old. Is it possible to generate the items which are below the re-order level on dashboard or any report? You can generate stock report for that, entire data is there what you need to know about reorder.

I see, but it will show all data, it would be easier if we can generate only re-order report in case we have many products. That is possible but only in PRO version where you can generate a product wise report with total quantity, value and reorder level, instead of complete sheet. Hi i have send the query about the template but no response for last 2 days…anyone guess that still this template is useable for not?

I love the way it has been design keeping in view that all features used are user friendly to understand and apply accordingly. I can see lot of efforts, time and hard work has been placed in this template.

This is really saving my time and no problem in recording and analyzing the inventory position. Dashboard is a value added sheet in this template. Download from here. Prashant, please share your requirements with me on puneet gogia. Need a help to implement it. How current stock level column does it work? While stock outing out, there is no change happening in the current stock.

Once we explorer we would like to go for pro-version. I just bought the Pro Template. What a great value for all the more you are charging. Thank you so much for sharing all your efforts with us.

Hi plz send me the download link in my in box nasirniaz. I was checking the template and its features a few days ago but forgot to come back and report how it went.

Thank you very much for sharing! Can you please check your mail again? Almost There And you do need a template which can help you to track your stock effectively. This is an automated template which will help you to save your a lot of time. Stock Value. Stock In. Stock In Return [Pro]. Stock Out. Stock Out Return [Pro]. Category Wise Stock. There is a drop down to select different products.

User Forms. Here are the things you can capture with these user forms. New Product. By using this user form you can create a new product. It will get the rest of the data from your product master sheet. Rest of the data will be captured from product master sheet. Invoice Generation [Pro]. In Pro Version, you can also generate invoices.

This form stores data into the same sheet where you have stock-out data. Data Sheets. Product Master Product Master is the most important sheet in this template. Stock In Sheet Stock-In sheet will contain your entire stock-in data. And, if you are using pro version, the stock-in return will also be captured here in this sheet.

Stock Out Sheet Same like stock-in sheet stock-out will contain entire stock out data. And, if you are using pro version, stock out return will also be captured here in this sheet.

Customer Details [Pro] You can enter customer details in this sheet which will further use in stock out user form to track customer wise stock details. Supplier Sheet [Pro] You can enter supplier details in this sheet which will further use in stock in user form to track supplier wise stock details. Stock Report This stock report will be generated from your product master sheet. Customer Wise Stock Out [Pro] You have the option to create a customer wise report with pivot table for stock out.

Supplier Wise Stock Out [Pro] You also have the option to create a supplier wise report with pivot table for stock out. Product Wise Current Stock [Pro] In 1-click you can also generate a product wise current stock report.

Menu Button This template has a dynamic menu bar which has all the option buttons on it. Use back button at the top of the menu bar to go to dashboard. Entering Data As I have already mentioned that you have user forms to capture your data. In user form, after entering your data, click on enter button to save the entry.

Things to Avoid. Do not change the name of any worksheet. Do not delete any worksheet. Do not add or remove any cell, row, or column in the user form. Things you can try. You can create your pivot table from data sheets available in pro version.

You can take print out of your dashboard. Before using this template make sure to enable macros in excel. Download Your Template. Download Now. Hello, Its very nice. Is it possible, how to contact you Reply. Bulk purchase depreciation calculator. Inventory List accessibility guide. MACRS property depreciation. Fixed asset record with depreciation. Home contents inventory list. Inventory list.

Intangible asset depreciation. Record of fixed assets with fixed declining-balance depreciation. Probate inventory. Best of all, you can use a barcode scanning app like Britecheck to add new items to the Stock Database sheet and record stock in and stock out onto the Stock Inventory tab using just your smartphone. You can use this template to view current raw material stocks and calculate how many finished products you can make with the materials available.

It features brief instructions on how to use the other tabs. It also retrieves the units purchased from the Orders tab and uses the BOM tab to calculate the raw material units remaining after the finished products ordered are produced.

For good measure, the template compares the units remaining and your reorder point and tells you whether you need to reorder. It shows you the raw materials you have currently and calculates the finished products the raw materials can make.

It ensures you never miss to deliver customer orders because of raw material shortages. It also monitors your purchases and keeps them within your reorder points for optimum stock levels. You can use an app to feed details like product names and available raw materials quickly. Template 3: Office. This template is specific to businesses that store products and raw materials in warehouse bins.

Bins typically vary in size and location. With this template, you can know precisely which section an item is located and its quantity for quicker stock-level analysis and optimized warehouse layouts.

It sums up the quantities in the bins and provides the total stock per item and its value. You can also set reorder levels, and the template will tell you whether or not an item needs reordering.

It stores essential bin information, such as bin size, location, and bin numbers, making it easier to know where to store particular items. This warehousing template from Office. You can know precisely what each bin has and streamline your stock movements. A mobile inventory app allows you to capture bin data quicker than with manual entries.

You can allocate barcodes to your bins and use an app like Britecheck to record bin information directly to the template.