READY to use Excel Inventory Management TEMPLATE [User form + Stock Sheet]
Track your inventory in Excel, like a pro. Sometimes it’s really hard to track stock or inventory in a normal spreadsheet.
And you do need a template which can help you to track your stock effectively.
So if you are searching for an Excel inventory management template which can help you track your stock easily then you are landed on a right place.
For me, it’s an honor to tell you that here I have an amazing template in which you can track your inventory easily.
This is an automated template which will help you to save your a lot of time.
As all the formulas and data sheet are already arranged this way that you don't need to do anything.
It’s simple, quick and easy to use and I’m sure you’ll love it.
Dashboard
Here all the important insights are in a single sheet. And, you don’t have to worry about updating it again and again.
These insights will get updated in real time, as soon as you add new data. This dashboard will help you to track following important insights.
Current Stock
This figure is the current stock units as on date. It will update with every single entry done by you for stock-in and stock-out. It will calculate by deducting stock-out from stock-in.
Stock Value
Stock value is the total value of the current stock after deducting stock out from stock in. It’s calculated by using the unit price of each product.
Stock In
Stock In is the units you have entered in stock-in data in the current month. If you are using pro version you can use the drop down to check stock in quantity for previous months as well.
Stock In Return [Pro]
This section will show you the stock-in units which you have returned back to suppliers. In pro version, you can track them supplier wise.
Stock Out
Stock Out is the units you have entered in stock out data in the current month. Using the drop down menu, you can check for other months as well.
Stock Out Return [Pro]
This section will show you the stock-out units which your customers have returned back to you. In pro version, you can track them customer wise.
Category Wise Stock
Current stock value is for each product category. You can specify the category for each product in product master sheet.
Product Wise Stock And Reorder Level
This part of the dashboard will show you product’s current stock and value.
It will also tell you about the re-order level of a product. And, you will get an alert message if the stock level is less than re-order level.
There is a drop down to select different products.
User Forms
You can use these user forms to enter data. I have managed user forms in this way that you have to enter minimum data.
Here are the things you can capture with these user forms.
New Product
By using this user form you can create a new product.
The best part is we are using data from product master to fill another user forms with minimum data.
Stock In
Whenever there is new stock, you can enter that stock using this user form. In this user form, you just have to insert the product name (using drop down list), supplier name, and quantity.
It will get the rest of the data from your product master sheet.
Stock Out
Use this user form to enter stock out data. All you have to enter, product name, customer name and quantity.
Rest of the data will be captured from product master sheet.
Invoice Generation [Pro]
In Pro Version, you can also generate invoices.
With invoice generation sheet you can instantly create invoices & track data into the sheet. It just works like stock out user form, but specifically for invoices.
You can create a proper invoice with all the customer details & further you can also generate a customer report as well.
This form stores data into the same sheet where you have stock-out data.
Data Sheets
You can access the data sheets where entire data will capture from user forms. Every entry in user forms has a serial number which you can use to refer it.
Product Master
Product Master is the most important sheet in this template. Your all products will be listed here with details.
Stock In Sheet
Stock-In sheet will contain your entire stock-in data. Each entry is captured with a unique serial number, and you can use that serial number to refer to a specific entry.
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. You can enter your data in this sheet using stock out user form. Entries in this form are also captured with a unique serial number.
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.
Reports
In this template, all the major insight are on the dashboard. But, you can also extract the following reports.
Stock Report
This stock report will be generated from your product master sheet. It will give you the complete summary for the current stock.
Customer Wise Stock Out [Pro]
You have the option to create a customer wise report with pivot table for stock out. It will show you the quantity and values of stock out.
Supplier Wise Stock Out [Pro]
You also have the option to create a supplier wise report with pivot table for stock out. It will show you the quantity and values of stock in.
Product Wise Current Stock [Pro]
In 1-click you can also generate a product wise current stock report. It will show you the product wise quantity and value of current stock.
Instructions
This template is user-friendly and easy to use, and here are some instructions to follow which will help you to use this template effectively.
Menu Button
This template has a dynamic menu bar which has all the option buttons on it. You can call it anytime using this menu button.
From this menu bar, you can navigate to any of the data sheets, user forms, and generate reports.
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. And, data from each user from will be captured into a separate data sheet.
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.
can i add in the accounting system profit and loss and statement?
Greetings, very nice template. I will need to add some info not presently in it.
Is it possible, how to contact you
Dear Claudio, You can have a look at the developer version where you can make changes https://excelchamps.com/inventory-template-buy/
I need your help Inventory Template for stock in an out
Thanks
I need to learn it first.
first time downloading
I need your help Inventory Template for stock out+ in
I need to see the example
we need inventory with sales
Hello dear
I need your help Inventory Template for stock out+ in
🙂
I need to try it out
i need it
Ready to try it out
plz send the templet.
Please share Inventory Management TEMPLATE.
Hi,
Thanks to provide Inventory Management TEMPLATE.
I am facing the problem in Product Wise Stock And Reorder Level dashboard, I entered new product (as Grinding Disc), stock in & stock out quantities using user forms, but in dashboard did not show any status, only show N/A.
kindly guide me
Thanks
need this
Excited to try
Very good
is this Template download ready to use or you need to Buy the Pro version to be able to start using it as I used the Downloaded template
change Product to my items but it would not update the stocks in or outs of total
nice thing
hi
need this temp
Good
Thanks
good
Hi Support,
Good day!
I hope that you’re well.
I’m interested in your excel program. Is it possible to add a function to manage the Stock BIN location of the stocks and Pick lists management based on the inventory lists with respective reports? Also, keep tracks the movement of the stock and reports.
I looking forward to hear from you soon.
Thanks
I wish to try the template.
Nice temblate. Can I make some changes and adding features in this template?.
Hello, I would love to work with your inventory file to help me work better as a supply chain manager.
wow
fantastic
Hello, I would love to work with your inventory file to help me work better as a supply chain manager.
very nice format
This is amazing excel, i really want want get it.
Cqn anyone share this file i am unable to downlaod thanks for your all support.
Thanks man!!!
Now for the big question before I continue with this template.
I have about 2000 unique items that I wish to track. (about 26 categories)
Will this template be able to work for such a high number of unique stock items and categories?
Please excuse my ignorance as I am not very experienced with Excel.
Surely. reply me if you need further help.
Hi Paneet
In the “Enter New Product” Sheet..
You have formatted the Product ID cell as “Date format”
Many of my product ID’s start with a zero.
eg. Product ID 02807356
Is there a way to overcome this?
Can I add a ( ‘ ) before the number or change the format to text?
Exactly. 🙂
Thank you for the Prompt Reply
Hi Paneet
In the “Enter New Product” tab..
You have formatted the Product ID cell as “Date format”
Many of my product ID’s start with a zero.
eg. Product ID 02807356
Is there a way to overcome this?
Can I add a ( ‘ ) before the number or change the format to text?
Sorry Instead of “Tab” I should have said “Sheet”
thank you
Very Good
Need the pro version.
Thank you
Very Nice..
Good Template
helpful
I like this template
Good looking easy to use
this is what i’ve been looking for
good template
amazing stuff
Nice
we need this type Excel
check out from here https://excelchamps.store/inventory-template/
Clean Report!
thanks for sharing
Great concept
Thanks for sharing me
Its great
actit2018@gmail.com
Please send me a Quote for the Pro version
Hey Beandra, please check out the following link:
https://excelchamps.store/inventory-template/
how to get pro version. i need invoice.
i like your concept, how can i edit excel as per my requirement, please help
you can go with the developer version if you want to edit it as per your requirement.
Hi, can I know how much is the Pro version and what are features that I can customize in the Pro version?
i like this software
i want warehouse management system if its fulfil our requirement we will contact you.
this is amazing
thanks
can you help resend ?
can we change $ symbol to Rupee symbol
Thank you for providing this template for free.
Thanks for providing and sharing knowledge.
Do you have a pro one that I can use?
Very Helpful
thank you
Hi, there cannot download the template, have tried sending it to all my emails, but I’m not receiving any of your templates
thx u
Hi
Tried the downloaded sample template. If we can’t amend the template means we will forever have the dummy stock in our inventory :).
How do you charge for simple modification or add-ons?
Thanks
not really, you can delete the dummy entires simply by the right click -> delete row.
Go In Review Option then Click Unprotect Sheet. the sheet is not password-protected, it will unlock immediately.
Very Good Format
Hello! Can i have a copy please. Thank you so much
Great template and easy to follow
very good
It’s very helpfull
hello i want this templet to use our office in indian RS. so can you change and fress templet send me with our comaopny name so i will pay
Thanks
Let’s try it
Nice
tanks
Thanks for this application
That is what I’m looking for
thanks
The given tempalate is of very much use & have simplified the issue of Inventory management.
Thank You..!!
perfect
Thank you
LOVE IT!
I will be oblige
nicce one
Awesome template… I have registered but havent received the template. Could you please resend it to my email address..
Thanks
nice one
Nice Template
Great!
thanks
great big job
Hi good evening,
Thanks it really looks good. But I have tried to download it all in vain do you mind if you can send it via my email, please.
did not receive the file
How i can costomize this aplication
Can I get a code for view code editing
Please resend to my email. Thank you
great work
haven’t received
This seems great, but I registered my email address and I haven’t received Excel Inventory Management Template
resent
Registered but did not receive the email. please resend
resent
GOOD
Hello there,
I have registered my email but have not seen the download link in my inbox. Please send it.
Thanks
Didnt received the sheet on email after many tries. Could you please help?
re sent
12345
SO GOOD
good
Lets see how it will work
For try inventory management excel template
Great
Good afternoon , I have registered with various emails but didn’t get the inventory management excel template in any of the emails (checked SPAM as well). Could you advise on the sending?
re-sent. 🙂
received brother thanks!
exelent
Small business that sells to other vendors.
Hoping this helps to have a control on my sauce inventory in house
Holding on High hopes that this software will be the ultimate answer to my management of my organization’s stock levels and tracking thereof
Nice
Looking forward to using this
Great
nice
hi
Can I make changes to the template? I need something to track down medicines
good
it is very useful template. but why i cannot use to add any new product ?? it shows error message as password protected
Hi Puneet,
I just downloaded the inventory template from your website and also checked the pro version features. It meets many of the features that I require to run a Automotive parts Business .However if the following additional features can be incorporated it will be great .Also what would the additional cost be to add them.
1) Have a fields for 2 x additional part numbers for each item.
2) Have provisions for 2 x currencies . Import currency and Local selling currency.
3) To have rate conversion feature between the 2 x currencies.
4) To have a template similar to the invoice template for adding supplier invoice information.
Kind Regards
GOOD
I need Excel Inventory template, to maintain receipts, issues, stock statement to maintain general store & engineering stores
I need this excel template to manage my business (ecommerce)
please send
akershitagarwal@gmail.com
Need an inventory management template
I NEED STOCK OF FLOAT GLASS
I wanted an excel sheet that is simple to maintain sale, expense, purchases, credit bills etc with end of the month report and end of the year report for a small restaurant. How much do you charge for creating one
thank you
looking for the templates and education
thanks
easy to use
Let me try first.
its so amazing
Sir
I need Excel Inventory template, to maintain receipts, issues, stock statement to maintain general store & engineering stores
My Need to S/N, Date, Customer Name, Address, Cell Number, Bill Number, Delivery Man, Product Name, Size, Quntity, Rate , Total Taka, DISC, Paid amount, Due amount
i can access it, am only seeing dashboard.
Kindly assist me on what to do.
activate your macros first. see the pdf shared along with it.
how do I change the currency symbol in the workbook? I’m going crazy trying to find the way. thank you for your help!
Hi
Do you have a parts location in the stock card?
And a parts search?
nice site to download templates
Just checking your template to see if it fits my purpose. Thanks and I will give feedback
How would you manage price changes for same product?
Value of stock becomes a problem for stock take.
can weighted average be built in?
Would have like to input multiple items for stock in and out. Single input will take to long.
Order form would also be nice.
Hi,
I haven’t received any file/email. Could you please re-check?
Thanks.
Best,
Re-Sent
Hi Sir, i want to download stock in and stock out sheet
thanks
hello. i want to download stock out sheet. many thanks
HELLO, I NEED STOCK OUT TEMPLATE
thanks
we have approx 300 items. Purchase price every time different we can not fix unit price. we didn’t want category wise stock in dash board .we want delivery challan returnable and non returnable challan not invoice. Report of item should display price .
Thank you
It is great, I must have
Thanks !
THANKS GREAT SERVICE TOO.
HI
HOW MUCH IS PRO ?
SIMON
all the details :https://excelchamps.store/inventory-template/
HI That’s a great effort, Can i edit product description in out form.
I am trying to download the program. I enter my name and email but never receive the link. I would like to try this
resent
Even I am not able to get the link
good
Hi Puneet
I liked your free template and tried using it though have some queries :
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.
How do I achieve this?
Regards
S Patwardhan
emailed.
I never got that email. Is there any way to contact you.
check now
not received yet. Need this very urgently.
sent three time at 2020-07-21 15:17:39. and I’m sending it again.
This is the one of the best selection of workers to keep maintaining their goods
helpful as I was needed..
excellent!
This sounds great, can’t wait to use it.
Graphs can be edited by us.
hi
Dear Concern,
The inventory system is perfect for me, but i need to customize this excel file. If you don’t mind can you help me out.
Thanks in advance
looks useful
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.
simply copy-paste in the product master sheet
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? and for the description to be pre-filled if possible.
You can do this way: Skip the price while entering stock in and out, and even a new product. And, it’s okay if you skip the description.
First I will use and after that i will published my comment
Hi,
I did not get the file in my inbox.
please can you check this.
Thanks
hi
Looking for somthing for my startup
Hi,
I have not got any Template in my inbox.
Plz help
re-sent.
Thank you
Hi Puneet,
I got only dashboard…How to enter all components In out And stock??????/
You need to enable macros, first. See the guide that I have shared with the template.
When you fill out an invoice, does it automatically calculate your stock ins and outs?
Absolutely
Hi Puneet,
This looks like the exact thing I’ve been looking for for my dad.
Would it be possible in the “stock in” function to add a “storage location” I.e rack 1 box 2, and would it then be possible to search the inventory when trying to locate where a sold product is being stored?
Regards,
Matt
Looks worth trying using
Looks like something worth trying.
I’ll try and find out about this template
Looks good
How do you get the pro version? I don’t see a link anywhere
PRO: https://excelchamps.com/inventory-management-template/
DEV: https://excelchamps.com/inventory-management-template/dev/
It Looks very useful. All in one package
Looking forward to it
Stock management template
It seems fantastic, need this as soon as possible
I’m interested to download this template.
looking good and easy understanding
really excellent
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.
This looks very good!
I am looking for the pro version but the website does nothing when I click on download.
Try once again, please.
I requested a download but haven’t received it yet. Can you please resend it?
Done
Interested in the template.
I would like your free: “READY to use Excel Inventory Management TEMPLATE [User form + Stock Sheet]” Thank you!
Very useful
Thanks for the template it covers all the formulas that I need to track with.
I am interested in this product. I have a few questions?
1. Can it used on MAC
2. How Many products will I be able to add? I have over 2000 products
3. Is it possible to add discounts on the invoice based on the product.
3. Will I be able to create labels to print?
Thanks
Yes, for all. Once you buy it, mail me back and we’ll do little tweaks for you.
Still not received, what is the file name?
Please check, I have requested your free version but have not received it yet.
Sent
is it possible to incorporate sales feature to the pro version? i got multiple stores and just few sku’s to monitor. send me an e-mail how to add and cost, randy.caoctoy@gmail.com
can I also have a free version?
Hi Puneet,
I got the FREE version of your excel. I liked and wanted to learn more about how the ‘ENTER’ in ‘EnterNewProduct’ formula/macro works. Can you please help me with it?
Sent.
Hi Puneet,
I didn’t receive any mail from you. Can you please re-send it?
Hello,
I haven’t received the template even though I signed up. Please resend.
Hi,
Please send purchase order month wise delivery schedule sheet
HOPE IT WILL BE USEFUL FOR ME
Hi
How can i change the dates for stock in/out on free version?
Could you please me the reply to my email.
Thanks
You can edit them in the data worksheet.
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.
Sent
Hi Puneet,
Can you please change the format on the dashboard to INR
it is downloaded with stock already in how do you clear to start with a fresh clean stock inventory?
Hi Mr. Puneet,
Can I also have a copy of your template ? I can’t access the download link of FREE VERSION.
Please send me to this email
yannax1998@yahoo.com
Thank you so much in advance.
Regards,
YannaSilva
Hi
Can I have also the template ? I can’t download it directly.
Here’s the emai yannax1998@yahoo.com
Thank you so much.
Does anyone have the Dev version? Can I import data? Or am I limited to the user form?
Hey Veronica, to import the existing data you need to simply copy-paste it.
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?
Yes, you can change currency, but need to understand more from about changing stock items.
how to activate macros sir
no email sent to me
hello thank very musch how do i activate the macros that will be part of the excel file that you send
free version not able to download
Dear Puneet, thanks for the templates, I have managed to download the free version but am unable to enter anything in it
Please activate your macros.
No mail recived
check now.
Are the fields modifiable for my specific application?
As an inventory tool, does your programing include high/low limits and reorder points; programmed in?
Is your template barcode capable to generate labels and record inventory based on scanning?
I can send you a list my requirements if necessary.
I have this question too; did you get a response by any chance?
Does the Pro or Dev version allow for easy customization? I’d at least want to add additional header columns..
Hey Veronica,
WIth Developer Version, you can do all kind of customizations and if you go PRO version you can mail us you requirments (what columns you want to add) we’ll try to make it up for you.
…with love, Puneet.
Hi I don’t receive any email
Try again
Absolutely marvelous!!
nice
i dont get any email
Try again
Hi Puneet, I am from Chandigarh. I need your help.
I want a simple excel Stock Management System for smartphones wherein I just need the EAN(Product ID), Description & Quantity. 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?
nice
Hi despite rying more 3 times, i am not receiving the link in my mail for the trial version.
Can you please help me please
check now…
same issue im also not getting any link in my inbox
Done
no template in email
Sent
Hi i tried to download but nothing was sent to me thanks
Hello,
I’m looking for a friend who is searching for a program that automatically can make an invoice for his customer. 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.
Also is it possible to set the currency into euro’s (€) and a choice to set another language? (Dutch).
Please let me know.
Hello again,
I don’t want to be rude but can I get an answer to these questions for my friend so we can see if we will buy this application/
Thanks in advance.
Hey Randolf,
There’s an option where you can define the discount percentage in the invoice manually.
Hello,
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
Yes, you can use it in MAC BOOK. How you want to print, I mean as a report or something else?
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 we create challan of out material .
please send me trail version.
You can create an invoice with the PRO version.
Dear Sir,
We haven’t received the mail regarding the downloading of the free trial version.
Kindly advice
Re-Sent
looks great will try it out
i try to purchase pro version but can not complete the process can please help me out,
Mailed You.
Not received any email
Can you explain the advantage of Dev version
How many user can use Pro version ?
if it’s multiuser can I create user password ?
1. With DEV Version you get the Developer Code as well with which you can make changes into it if you want (if you know VBA).
2. If you are using Excel’s latest version (365 or 2019) then you can use it with multiple users + you need to use One Drive/Google Drive to share it across the systems.
3. No, it doesn’t support User/Password but you can create a password to the main Excel file.
VBA is working on the One Drive/Google Drive to share it across the systems?
You can use one drive to sync files between two computers, but you can’t use VBA to work with a file which you have opened in Excel Online.
After enter new data like product id
how we can change
would love to try it
Hello,
I would want to try the free version before I purchase the pro one, thank you.
Hello
I will like to try the free version before buying it, thank you.
I couldn’t see the doc
enter email to get it into the inbox.
No email hasn’t received.
Re-Sent.
I haven’t received the mail for the free version.
Please resent it. Thank you.
Sent
Hi, I’d try the free version before I purchased pro one. But haven’t received any emails yet.
sent again
Is this a monthly fee or one time price?
One Time
not receive any mail
Re-Sent
Sir, Not received any email
check now
Hello
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?
thanks
check your mail, sent again.
Requested free version download. No link has been sent.
Check your mail now.
Hi there,
I’m interested in purchasing your pro version. 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.
Thank you
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?
Thanks
share a screenshot with me @ puneetatgogia.me
Email Sent, looking forward for your reply Puneet.
Replied
I applied for free trail download but couldnot.
does it work with excel office 365 2019 for mac? As per my past experience I faced lots of error with VBA on Excel Mac
OH, I’m sad for your past experiences but this template works with MAC.
I am trying the free version, however I dont get the download in my email
Re-Sent
Hi,
Need option of entering multiple items,
Possible?
Nope
The link in the email just opens a blank window. Unable to download the template.
Sent again, please check.
Dear Puneet,
I liked the excel inventory. is there any option to edit the product details or price of the product once entered
You can do it from the main data sheet.
To change an error occurred during new product entry. How should I go in to make changes?
What kind of error you have faced? Can I have a snapshot?
I need to add one more attribute to stock out form. can you help?
Awesome software
This is exactly what I was looking for. Thank you.
hi after use can share comments
I highly appreciate your program
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?
How i can download this tamplete???
Hi is it okei to add location on it? and also i want to search by code and also per item. not by scrolling
Dear Puneet
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.
Chris
Hi,
How can i edit a item name entered in the list.
hi Navin,
Can you forward the excel template to my email? safdarfaruq@gmail.com
Thanks again.
Regards,
Safdar
Forwarded.
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 Navin,
Can you forward the excel template to my email? safdarfaruq@gmail.com
Thanks again.
Regards,
Safdar
Hi, Need a drop down list to see the single product category. and same need to required on “Product wise current stock vs. reorder level”
one product category have different different product name, so can see categories wise.
Hi
am a Steven smoke I like it, please sent template to my email. smokesteven22@gmail.com
thanks
Dear Puneet,
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?
Hi not received email for trial verion
Dear Puneet
can i get the link to download 3
I’m having an error it displays “Cannot run the macro”excel-inventory-management-template.xlsm’!OpenMenu”. I have already done enabling the macros but i can’t still navigate the system.
Close the template once and re-open it and make sure you have enabled your macros. Excel Options ➜ Trust Center ➜ Trust Center Settings ➜ Macro Settings ➜ Trust access to the VBA project object model
Dear Puneet,
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
please send me a trial copy of inventory template to wccllcinfo@gmail.com
Kindly send me this template my email ID is harishapihhc@gmail.com
Hi
i have followed step as you told about macro setting in instruction . but when i open inventory template, this message pop in excel
run-time error “1004”:
Method “Worksheet” of object”_Global”failed
what i should about this messages?
2) can you please help in deleting old sample data? or is possible to send me excel pro to email without any sample data
it is a good blog about Pos billing Software.
is there any app for this
when i use stock in then it is not showing in product master
how can i clear the sample data?
i can’t add a new product it’s. the cells are protected. what will i do?
it is asking for password
i have given the request for free trial version with my email id yesterday at 2.02pm but till now didn’t receive any email
i need to know how to clean the table to start using my staff,
so i need a clean one
asap
Really helpful. Best to maintain inventory.
Need this for iOS is there any help available?
Hey Puneet,
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?
GOOD
Thanks
Heyy, Is there any iOS version available for the above template?? It would be really helpful if you can reply asap.
Ankit this template uses macros and unfortunately, Excel’s IOS version doesn’t come with VBA functionality. 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 each one of this products has a serial number, like an identity code (I imagine you know how it works). I need to register every serial number code to keep track of out product, to know when someone returns something it is certain that he/she got it from me.
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.
Hey, Lgnacio,
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 . this is the template that i was looking for thank you.
I’m so glad you liked it. 🙂
Hi! Can I Use It with Barcode Reader.
You need to get the developer version and add a barcode font into it.
Hi… I am not able to make payment. Pl. do revert us with needy support.
Hey, Anand please check your mail I have reverted with a new link for Payment.
Did not receive a link.. would try it
Could you please try it one more time?
Put email in to receive free version and get no response
Could you please try it one more time?
didn’t received the link in mail. I tried to submit it twice.
Sent
Not received the link in mail.
Please check other folders as well, otherwise try again once.
didn’t received the download link
Please try again once.
Please Provide me the download link
Hi Puneet, did not recieve the link
i have paid 2 times for DEV version but it is not downloaded, if it is not available for Pakistan, then plz reverse the transaction
.
A mail has sent to you, please refer to that email.
Sir, no email received yet
Can you please re-check Umair?
how much it costs
Please advice how to get the download link.
Click on download now in Free Version section.
Please help me to get the link of Inventory management template.
Please click on download now in Free Version section.
i am unable to get the free version link on my mail inbox and want to know how much time the link available for me to download
Link is active forever.
plzz send me or tell me where to download
Please click on download now in Free Version section.
Trying to download the Free version ,but unable to download it.
Click on download now in Free Version section.
Trying to download Free version but can not..please can send me the link
Sent again. I’m sorry you have faced this error.
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.
check your mail now.
Got it thanks.
Not working, please explain the process for using the link
Please reply.
Link is working very much, please try again.
Thanks.
May be I am using it in a correct way.
Please let me know the process.
I’m afraid I’m not able to understand you. You can write me on my email.
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.
Waiting for reply.
Thanks..
What’s the problem with the link.
Thanks.
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. I keep trying but I get the same thing.
Please help, I think I am “not understanding” or “not using the correct link” which you have sent.
Please guide me.
Sent again. I’m sorry you have faced this problem.
In you mail from “Disqus”, there is no link available.
Thanks for all your support Mr. Puneet,
Please provide the link for Inv. Management System
Om, link is there.
Thanks Mr. Puneet.
I have not received the link. Please provide.
Sent again. Please check.
Not working, please explain the process for using the link
How i can download this tamplete???
If yes so please send the link on my mail.
Ram, link is there.
Hello Puneet,
I hope you are doing well.
I appreciate if you can please tell me how I can change the $ sign for Stock Value.
I just want the numbers no $ sign.
Looking forward for you quick and positive response.
Thanks
Hey Haris Arif, please unhide help worksheet and remove $ sign from it.
Where I can see this option ?
Unhide worksheet by right click on worksheet tab.
Right click on worksheet tab and unhide help worksheet.
Hi Puneet,
Thanks for your reply.
I am unable to change the $ sign from the product wise stock value where it shows the item in stock
I also need your help to change the $ sign in Daily Sales Report I am unable to change.
I purchased this back in January 2017. Is this an updated version which I need to download now?
Taptronic, please share your registered email ID. I’ll send you updated version, if you have not received.
It was originally purchased under: OPTIMALNAMES AT gmail DOT com on January 13, 2017 Thank you!
Sharing with you updated.
So far no updated version at email address above..
Check your inbox now.
Want to let you know that I received the template now. Thank you! One final question, about the Expense Tracker template from https://excelchamps.com/blog/expense-tracker I keep getting a 404-not found error after entering my name and email address. Can you send that template to me too?
Hi.
What a fantastic template.
Question, how do I change the currency?
Nevermind,
Sorted it out.
how to reset the sheet. as there are few entries in the template.
if we delete anything from any sheet. it effect the template result.
or
if i enter data in template. the sample data that is already in the sheet remains in the template.
Hey Jatinder, It’s very simple, select that old data (just data not headings) and right click and then delete. Just make sure you haven’t delete the entire table.
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.
Thanx in advance
There are 3 sheets for data ==> Stock In | Stock Out | Product Master.
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.
hi puneet.
still struggling with the issue.
stock in & stock out s fine.
but when i add new product after deleting data in stock in and stock out sheet . serial number starts from 11 onwards in prodct master sheet.
once new product data is added & stock in also added.
if i try to delete old data from product master sheet. something went wrong as help sheet shows error resulted in wrong display of data in template
HI PUNEET
STILL STRUGGLING WITH THE TEMPLATE.
CAN U SEND ANY BLANK EXCEL TEMPLATE SHEET .
OR
REPLY THE QUERRY.
THANX
Just change that serial number to 1 that’s it. 🙂
Hi Puneet Gogia,
How can i change or disable Currency
i want to download the pro version please
@alsadiqabbas:disqus, you can buy it from here ==> https://excelchamps.com/inventory-management-template/
Good
I’m glad you liked it.
Is it possible to generate the items which are below the re-order level on dashboard or any report? It’s quite complicate if I have to check it one by one from drop-down list on dashboard.
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.
how to download sir
https://excelchamps.com/sample-files/sample/inventory-template.html
this is not full version and i want it to customize as per my convenience.
is it possible??
You can buy full version from here ==> https://excelchamps.com/inventory-management-template/
hello is there any free template i can download
Use this link: https://excelchamps.com/sample-files/sample/inventory-template.html
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 have just replied you on your mail which you have sent.
I bought this Excel Inventory Management Template and its AWESOME 🙂 . 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. I wish to see more templates by Puneet 🙂 Keep Rocking Brother 🙂 and Thank you so much again for making complex things simple for us 🙂
Thank you Rahim for your valuable words.
WHATS THE PASSWORD SIR THANKS
You need pro for that.
Dear Sir,
I cannot download this template. please help?
Download from here. https://excelchamps.com/sample-files/sample/inventory-template.html
I don’t have problem in buying but how will I change it as per my requirement ??
Prashant, please share your requirements with me on puneet@gogia.me. I’ll tell you if this template will solve your problem or not.
Hi Puneet, did not recieve the link
Already sent. Please check your email.
Hi sir Puneet Gogia! can you please e-mail me? I have transaction for you thanks.
Hey Edmond, didn’t get you.
hi again sir! just wanna inquire how will you cost me if I order the same template?, but has a little bit customization according to my work needs. thanks sir. here is my email erquiban@gmail.com
Check Out PRO version.
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
Try to download again and use it.
I just bought the Pro Template. Found all the hidden tabs and can’t believe how much work you put into this! What a great value for all the more you are charging. I consider myself an Excel Super User, but I will never be as “super” with it as you, Puneet. I’m struggling right now with keeping track of custom-made items for my employer; this will help me a great deal. I can’t wait to get back to work in the morning and try it out! Thank you so much for sharing all your efforts with us.
Thanks Brenda for your awesome words.
Hi plz send me the download link in my in box nasirniaz.ns@gmail.com
Like is already there.
hi, what is the password for reviewing the code
Hello Diyana,
Developer code is only available with Pro Version.
I can’t downloa
What problem you are facing?
my brother i can’t see the download link
can i put list of data at once in your template
Yes.
How i can download this template
Hey Chandan.
Download link is already there.
CAN YOU SEND ME THE LINK PLEASE
Download link is already there.
I want to view the code, there is requiring password? what is the password? thanks godbless
i cannot download this template. please help?
Hey Shaukin,
Please check your inbox.
no link.. 🙁
Please check again.
Hi Puneet,
I was checking the template and its features a few days ago but forgot to come back and report how it went. IMO, is really useful and you’ve made a nice work with it. Thank you very much for sharing!
Thanks Jorge.
Please send me the link. thank you
Link is already there
i got it, Very useful. thank you.
Plz send me download link
i got it, thank you. Very useful.
You’re welcome
How i can download this tamplete???
Hey Muhammad,
Download from the link mentioned above.
i doesm’t found download link. please give me link on chat box
Check Your Mail.
i have no recv any download link in mail
I have updated the link in the post. Fill your email ID and download from there.
Hi, did the subscription but no template has been sent, so far… how do i get it?
thank you
Yes, Migu.
I’m sorry about that. Can you please check your mail again? I’ve sent a new mail with the template. I’m here if you need further help.
can i also have this template thanks..
🙂
I also have it thanks..