Admin 31 Report post Posted August 18, 2018 Click here to download this automated excel inventory tracking template 2019. Track your inventory in Excel, like a pro. This is an automated template which will help you save a lot of time. As all the formulas and data sheet are already arranged. It’s simple, quick and easy to use and I’m sure you’ll love it. Table of Content Dashboard User Forms Data Sheets Reports Instructions Thing to Avoid Things you can try Download Your Template (1) Dashboard Here all the important insights are in a single sheet. And, you don’t have to worry about updating it again and again. Lite Version PRO Version 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. (2) 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. (3) 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. (4) 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. (5) 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. (6) 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. (7) 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. (8) Download The Template Download Pro Version $20 Download Dev Version $40 Share this post Link to post Share on other sites
Admin 31 Report post Posted August 18, 2018 Comments... Bunny A mail has sent to you, please refer to that email. Umair Sattar Can you please re-check Umair? srinivas nuthalapati how much it costs Sarmin Rain Please advice how to get the download link. Click on download now in pro or dev section. Sarmin Rain Please help me to get the link of Inventory management template. Please click on download now in Free Version section. umakanta 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. Atif N. Kakvi plzz send me or tell me where to download Please click on download now in Free Version section. gurvinder Trying to download the Free version ,but unable to download it. Click on download now in Free Version section. gurvinder Trying to download Free version but can not..please can send me the link Sent again. I’m sorry you have faced this error. Syloxane 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. Syloxane Got it thanks. Om Not working, please explain the process for using the link Om Please reply. Link is working very much, please try again. Om 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. Om Thanks for your reply Mr. admin, 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. Om Waiting for reply. Thanks.. What’s the problem with the link. Om 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. Om In you mail from “Disqus”, there is no link available. Thanks for all your support Mr. admin, Om Please provide the link for Inv. Management System Om, link is there. Om Thanks Mr. admin. I have not received the link. Please provide. Sent again. Please check. Om Not working, please explain the process for using the link Ram Gopal Chauhan How i can download this tamplete??? If yes so please send the link on my mail. Ram, link is there. Haris Arif Hello admin, 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. Haris Arif Where I can see this option ? admin Unhide worksheet by right click on worksheet tab. Right click on worksheet tab and unhide help worksheet. Haris Arif Hi admin, Thanks for your reply. I am unable to change the $ sign from the product wise stock value where it shows the item in stock Haris Arif I also need your help to change the $ sign in Daily Sales Report I am unable to change. Taptronic 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. Taptronic It was originally purchased under: OPTIMALNAMES AT gmail DOT com on January 13, 2017 Thank you! Sharing with you updated. Taptronic So far no updated version at email address above.. Check your inbox now. Taptronic Want to let you know that I received the template now. Thank you! One final question, about the Expense Tracker template from /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? Khilesh Hi. What a fantastic template. Question, how do I change the currency? Khilesh Nevermind, Sorted it out. Jatinder Kumar 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. Jatinder Kumar 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 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. Jatinder Kumar hi admin. 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 Jatinder Kumar HI admin 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. MH Mohsin Hi , How can i change or disable Currency Alsadiq Abbas i want to download the pro version please Good I’m glad you liked it. NuaNear 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. NuaNear 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. Aditya Gorebal how to download sir this is not full version and i want it to customize as per my convenience. is it possible?? hello is there any free template i can download Arifur 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. Rahim Zulfiqar Ali 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 admin keep Rocking Brother and Thank you so much again for making complex things simple for us Thank you Rahim for your valuable words. Edmond Quiban WHATS THE PASSWORD SIR THANKS You need pro for that. Bakhtiyar Ahmed Dear Sir, I cannot download this template. please help? 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 admin@gogia.me. I’ll tell you if this template will solve your problem or not. K B Hi admin, did not recieve the link Already sent. Please check your email. Edmond Quiban Hi sir ! can you please e-mail me? I have transaction for you thanks. Hey Edmond, didn’t get you. Edmond Quiban 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. Vigneshwaran Pitchai 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. Brenda G 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, admin. 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. Nasir Sheikh Hi plz send me the download link in my in box nasirniaz.ns@gmail.com Like is already there. Diyana hi, what is the password for reviewing the code Hello Diyana, Developer code is only available with Pro Version. Mustafe Osman I can’t downloa What problem you are facing? Mustafe Osman my brother i can’t see the download link CHANDAN can i put list of data at once in your template Yes. CHANDAN How i can download this template Hey Chandan. Download link is already there. Nsh RDV CAN YOU SEND ME THE LINK PLEASE Download link is already there. william labian I want to view the code, there is requiring password? what is the password? thanks godbless Shikin Tiansin i cannot download this template. please help? Hey Shaukin, Please check your inbox. Shikin Tiansin no link.. Please check again. Jorge A. Gomez Hi admin, 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. Zubair MK Please send me the link. thank you Link is already there Zubair MK i got it, Very useful. thank you. Mohammad Hasan Plz send me download link Zubair MK i got it, thank you. Very useful. You’re welcome Muhammad Saleem Memon How i can download this tamplete??? Hey Muhammad, Download from the link mentioned above. Muhammad Saleem Memon i doesm’t found download link. please give me link on chat box Check Your Mail. Muhammad Saleem Memon 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. Share this post Link to post Share on other sites
