Can you please make something where I will only have: product cost price, its selling price, daily product sales sheet and invested amount and profit amount. Only these few features... The one in this video is very complicated for tiny businesses like mine... Thanks.
Are you for real ... still, there are people like this gentleman sharing knowledge for free.. My God bless you i am so thankful for you .. thanks once again...
sorry to assume your nationality, but if you're Indian, i trusted Indian people with my calculus, i will trust them with my business as well! AND YOU DELIVERED AMAZINGLY. THANK YOU i'll be using this for my business. if I encounter any problems i'll comment here for help and i hope you reply accordingly. love your work!!
U r the master or I can say god of MS excel, brilliant, just brilliant,,I have no words to thank u for ur tremendous effort with these spreadsheet videos, I have just started a small retail shop, I was searching for a readymade excel sheet for my account handling of my business, and I can say I found more and more than enough,, u made it with so much passion and hard work and also put it for all to free download, I am sure u will get all u want in life, coz u r doing a great job for all of us, also sm questions r there also, like 1) in retail business there r many customers on a single day, (like for chocolate, mutton, icecream etc) so how to put them all in Partners and Order Headers section with Unique ID for all ? god bless u bro,, ur one of die-hard fan from Northeast India,
Thank you for such kind words. Very glad to know that the videos and the templates are useful. If you don't need to track at an individual customer level, you can assign a dummy Partner ID and assign all orders to the same Partner. Best wishes. Thanks for your continued support.
Hi! I finished filling all the info and it works:)! Only the raport, however does not show me the top 10 products or suplliers/customers etc. I did fill in the date and all the yellow options. Sales quantity and profits I can see. I hope you can help me out. Best wishes, Debra
This is what i call - "ALL IN A NUTSHELL" - excellent software, in fact, i was trying to design one such warehousing and distribution [inventory tracker] of spare parts for my company, in excel, but this template will assist me, at least to track the inward and outward of spares, that we receive. Thanks a lot, for the designer of this software, you made my day, lucky for me, i landed on this video. GOD Bless................
I bought the Retail Business Manager recently. I am very pleased with it. Definitely worth the buy. Great job Indzara. I am looking for more templates that will make managing my small business more efficient.
Thanks for purchasing. Very glad to hear that you are pleased with it. We look forward to your continued support. Please email us (support@indzara.com) if any questions or suggestions. Best wishes.
I just need to do some smaller tweaks, but overall, I've seen nothing more perfect from what I need than this! And this is all for free! Kudos to you and I'll subscribe to your channel as a token of appreciation for your excellent work!
THANK YOU for this resource and great explanation!! I'm not too excel savvy and need to track my freelance side hustle, this is an epic upgrade from the handwritten notebook I was keeping.
We are glad that we could help you with our template and you are welcome. For more support related to excel, requesting to contact support@indzara.com. Best wishes.
Thank you very much for this software. I really like the way it is structured. However, I want to ask, "if I use this app for a retail clothing store, should I input the purchase order from my supplier together with the sales order from my retail customers?" I am asking because the retail sales list is a long one.
You are welcome. Yes, you can enter one sale order and purchase order for each day in order header and map all the purchase and sale of the day under the same purchase/sale order in order details sheet. Best wishes.
Hey bro! Used your template one year ago. Amazing tracking excel sheet! May I know how I see my 13th-month data (and onwards) in the sales report? Since it only showed 12 months data
Thank you for using our template and sharing your valuable feedback. You can view 12 months of data at a time in monthly metrics. After 12 months, you need to change the start date/end date of the report. In general, it will be better to use the copy of the template separately for each year so the sheet will have less order list and the performance will be high. Best wishes.
Thank you for showing interest in our template. Yes, we take customisation projects for additional fee. Requesting to share your requirement to support@indzara.com for estimation. We also have inventory manager template with multiple warehouse. Requesting to check the same at the below link: indzara.com/product/retail-inventory-and-sales-manager-excel-template/ Best wishes.
Hi this is amazing thank you so much for this!!! :) please an you help when I set something for SALE and enter 1 it doesn't add it to the "SALES" section on the product tab please helppppppppppppppp!! :(
Thank you for sharing your valuable feedback. The sale count in PRODUCTS tab is based on the date range entered in the report tab. Hence, please ensure the sale orders are within the date range in Report tab. Best wishes.
Thank you so much for the help, I am having difficulties with the orders tab: I have a purchase order where all of my inventory is, however, when I make a sale order, the price doesnt come up. It only comes up when I input the purchase unique ID
Thank you for showing interest in our template and you are welcome. If you are referring to order number, yes, purchase order number is mandate to populate the purchase price, else the sales price will be auto populated. Since, the order type (Purchase/Sales) is defined in the Order Headers tab and it is then populated in Order Details tab using the order number. This is done to avoid repeated entry of same information. If this is not your concern, requesting to share some screenshot and cell reference number highlighting your concern to support@indzara.com to check further. Best wishes.
Brilliant ! hope you still respond to comments. I am having challenges as the gross profit is not calculating automatically in the report. Only the sales and purchases quantities are showing but no purchase and sales price hence no Gross profit is being calculated. Is there anything I am missing?
Thanks. Can you please check if the unit price information is getting to the Order Details sheet from the Prices sheet? If the price is not available in the Prices sheet or if you are using an older version of Excel, the price does not come through and that may be why the quantities are updating but not amounts. Best wishes.
Hello! Is there any report here I can generate showing my items I ordered from my supplier minus my sold items as well as remaining inventory? Thank you
Thank you for showing interest in our template. Yes, our report will have the requested information in total. Also the same set of informations will be available in our products tab for individual product. Best wishes.
Hi, this is such a very helpful tool thanks for creating it and making it free to use. I just wanted to know who can I enter the daily sales. In other words, at the end there are numbers of sales are generated in the reports sheet, where are these numbers come from and where are their input cells that I can enter the quantity of sales. Please help.
Thank you for showing interest in our template. There will be two sheets to enter the sales and purchase orders. 1. Order Header sheet (1 order can have multiple order items. This is used to avoid repeated entering order related information for each order items.) 2. Order Details sheets (enter each order item and map each order item with order id. Best wishes.
One comment: The PROFIT that is labelled on 16:37 is actually the GROSS PROFIT(Gross Profit = Revenue - Cost of Goods Sold), and it is NOT the amount of money you have left after all your expenses are accounted for (this is called Net Income. Net Income = Revenue- all expenses) Otherwise, great video! Thanks!
Thank you for sharing your valuable feedback. Yes, it is gross profit, calculating net profit is complicated. If you want to track the entire cashflow of the business, requesting check our Small Business Finance Manager template at the below link: indzara.com/product/small-business-finance-manager-excel-template/ Best wishes.
Thank you for showing interest in our template and you are welcome. Requesting to share your requirement to support@indzara.com to check further. Best wishes.
Thank you for sharing your knowledge - I have a question.. In the "order headers" tab - where am I typing the total order dollar amount? There doesn't seem to be a field for the order amount, only additional order inputs like tax and shipping?
Thank you for showing interest in our template and you are welcome. The purchase and sales price of the product is set in PRICE tab and the total amount in ORDER HEADER tab will be auto calculated according to the products filled in the ORDER DETAILS tab for a particular order number. Best wishes.
Thanks for the video and free template looks like it could defo get me started, one question you have inventory on order and orders to be processed type info, if the inventory comes in is it simple to update stock levels and of course same applies when you sip an order
Thank you showing interest in our template and you are welcome. Sorry, I am unable to understand your exact concern. Requesting to share your concern with some screenshots to support@indzara.com to check further. Best wishes.
thank you Indzara for your time and generosity, you're incredible. I've already downloaded this template, it's very helpful, but i've question, how do I fill the inventory to come and inventory to go column? i didn't find any tutorial to this, please answer my question, thanks in advance :)
You are welcome and thank you for showing interest in our template. The inventory to come and inventory to go are auto calculated fields which will be populated according to the future dated purchase and sales orders respectively. Best wishes.
Yeah, thank you Indzara for your time and generosity. There are just a couple of corrections to make: where it is supposed to say "additional" it says "additonal". You may wanna correct that in your raw file. The other is, I don't know why yet, when I enter Men -S in Category in row 4, it returns an "Invalid Value" error message. For the rest of the rows in the Category column it works fine. I will look into that and I'll correct it. Ok, I just resolved it. I dragged the black dot upwards from row 5 and it works now. Thanks!
@@indzara I will probably get your 40 dollar one as I plan on opening a small business and it seems your manager version is really complete in terms of features n__n
Your videos and templates are amazing! Is there any video where you teach how to do those templates? Because I would like to learn how to do them by myself!
Thank you for sharing this template. I am a freelance agent receiving stock by the box selling items individually. The quantity per box differs per item. My reorder level must be based on pack size (not individual items). The sales price is different when a client buys a full box. I also have a quantity discount per line item, eg. more than 5 certain discount, more than 10 another discount. How would i handle this.
You are welcome and thank you for showing interest in our template. Regarding discount, You will have option to provide order level discount and discount per line item in this template. Regarding box purchased in bulk, You need to have a reference table to get the number of product present in a package. Then you can add a column before to Quantity column and write formula in current quantity to multiply the quantity with the reference table package's product count if it is a purchase order else take the same quantity. Writing the formula in the existing quantity column will minimise the effort on changing the dependent formula's column reference on quantity. We also take customization projects for a fee. You can write to support@indzara.com for estimation. Best wishes.
Very good stuff. Hopefully you still get messages. How would you handle inventory where we you buy a product with variations and all sell for different prices? I guess I am looking at how to calculate COGS. For inventory should we treat each variant separately as you did with sizes of clothes or lump them all together? Can you follow?
Thank you. If each variation is bought as a different SKU and sold, then please enter them as a different product. Please let me know whether I addressed your question. Best wishes.
thank you. Sorry for the delayed response. We have to point some of the formulas to use product name instead of Product ID. Or you could try entering name in the ID column. The name should be unique. Please let me know. Thanks. Best wishes.
it is amazing!!! I want to ask you two questions, 1. when we use adjust option in the order header sheet it gets added up in the total inventory irrespective we are adjusting from supplier or customer, how to solve that ? 2. Also if I want to shift some of the inventory to my other warehouse in another state how will I take into account for that material?
Thank you. 1. When you are adjusting, you can enter the supplier or customer name as the partner name of the order. 2. The template handles only one location of inventory. This other template indzara.com/product/retail-inventory-and-sales-manager-excel-template/ tracks up to 10 locations of inventory - however, it does not have some advanced features. Please review and let me know if any questions. Best wishes.
If you have not made already, can you please share a tutor to create re-order sheet for groceries based on shelf capacity, sales and stock availability and delivery lead time? Also, pls recommend an excel to track products that are nearing expiry date Thanks in advance
at 8:50 as you said if price changes either for buying or selling we have to add new row, so lets say your first item MSBL from 1st nov 2016 till dec 2016 you have sold 200 quantity and now the buying price is changed from 16 to 19 we will add same item MSBL in new row in the bottom with new buying price and if we want to increase selling price we will put with effected date i want this item price was changed. Now i sell another 150 quantity in next 4 months. My question is that when i want to check this item history will it show all from 1st nov 2016 till dec 2016? like history of 350 quantity sold I tried my best to put my question in the most explanatory way and i hope you got my point thanks for the excellent job by the way :)
Yes, whenever a price happens (only purchase, only sales, or both purchase and sales price changes) for a product, we have to enter a new row for that product with the new purchase and sales prices. Then when we go to the Order Details sheet and enter any new order information, the correct prices effective for that order date will be automatically populated. Please let me know if there are any questions. Best wishes.
Thank you for showing interest in our template. Regarding barcode, If you bar code scanner get the product ID on the selected cell as described in the following third party article, then yes. yourbusiness.azcentral.com/double-underline-excel-mac-6583.html Regarding supplier, The supplier details needs to be stored in PARTNERS tab. Best wishes.
So far so good, very helpful...but can data be synced from e- commerce website to update sales automatically? Also, is there a mobile app for this to make updates or enter sales by phone (on the go)?
Thanks. Sorry, there is not a built-in way to sync to any website. You can set up an export file from the website in a specific format (columns in the specific order) and then paste them here in the template. And, there is no mobile version of this. Best wishes.
You are welcome. Please provide more details. Can you see the formulas in the calculated cells? if so, then please check if the data is entered inside the tables correctly and for date fields please check if the date format is correct. If there are further questions, email file to support@indzara.com along with your questions. Best wishes.
good day. thank you for this. questions: 1.can we use barcodes reader to enter the SN of every rpoduct? 2. what can we do if we have 2 - 3 prices for each product (different price for customer category / order quantity)? Thank you.
You are welcome. 1. I have not had a chance to work with bar code scanners yet. Sorry. 2. This template is designed for fixed prices. The other template indzara.com/2013/07/inventory-and-sales-manager-excel-template/ does not do any automatic price population where the user can enter manually price for each order. Best wishes.
Indzara,This is great! I have one question. I have an online business where I accrue the shipping cost for customer orders in order to advertise "free shipping". How can i account for this esp when im analyzing monthly metrics and so on?
Thank you. In the free template, Operational expenses are not separately recorded. In the premium template, indzara.com/product/retail-business-manager-excel-template/ if you put the shipping cost as part of the operational expenses, it will be tracked separately from cost of goods sold (which is the purchase price of product from your supplier). Please let me know if any questions. Best wishes.
Very comprehensive sheet but one thing i would lie to point out, you have calculated gross profit considering purchase price without tax which doesnt suit many of us. I want to calculate my gross profit considering price + tax + any other charges. Please guide what should be the formula in that case.
For partner name for the supplier, if I have multiple pieces and orders from the same supplier, should I leave this blank and just create a new column to keep track of that?
Thank you for showing interest in our template. Regarding partner name, this need to be selected for each order entry. Regarding product 52, you might have entered the product outside the product table or the data validation is removed in any of the prior rows. Excel table will duplicate only the consistent format on the column to new row. To resolve the same copy a cell which has the drop down and select all the cells in the column inside the table and press CTRL+ALT+v -> select validation -> press ok. Best wishes.
Thank you. The template allows a re-order amount to be entered for each product. However, the method to determine what the re-order amount is, is not in-built. Sorry. It is something that needs to be built in the future. Best wishes.
I was wondering- say if I've been using this template for a while, we do inventory again, but a couple items are off by a couple numbers (possibly an error in the initial inventory, or an error in data entry), is there any way to update the most current inventory if it doesn't match what it should be? Thank you
Thanks. If actual inventory is not matching what is in the template, please add an ADJUST order. ADJUST: We can create an ADJUST order and enter negative quantity values to reduce inventory or positive values to increase inventory as needed. This can be used to adjust our inventory numbers to ensure that the numbers match the inventory on hand. For example, we may lose products due to damage or expiry or other reasons. We would want to adjust our inventory accordingly and that’s where we can use ADJUST order type. please read more here: indzara.com/2017/02/free-retail-inventory-management-template/ Best wishes.
Thank you very much for sharing this its really helpful . However , I am facing a problem which is the inventory value still show 0 , what can I do to fix this ? thanks.
Please provide more details on what data has been entered and what is expected in the inventory. Please email file to support@indzara.com Thanks & Best wishes.
The video is well explained. I have filled in all the tabs with my product information and have read 'how to use this template''. However, the green coloms are not automatically filling in the prices... the other coloms work. What am I doing wrong? Their are no blank cells aswell regarding the purple ones. Also, when I save your sample template and want to add a product the prices are gone too. I hope you can help me out.
Hi, Thank you for your reply! I thought that I replied but I do not see an answer... Anyway I checked the excel version and I noticed that it was still 2007.I bought office 365 and the prices showed up. I have filled everything in and I thought it worked. Until I go to the order details. The prices all come up. However, when I go to the second order and I choose product name the price does not show up. Unless I delete the details in the row and try again. It only appears so when I go to the next row, which is below the line. To give a clear example in your video when you explain about the 'order details tab' the last order is in row 45, if I would add an order to row 46 it will change to the colour white/gray and when I insert the order number and than te product name, no prices show up. It also does not matter if I would select product name first and than insert order number. I hope you can help me out. It would be a great template if it would all work:) Have a nice day! Debra
Please email file to contact@indzara.com and specify the cells where there are questions. Please specify if any of the formulas have been edited from the original template. We will review and get back to you. Thanks & Best wishes.
sir better if there is a transfer in and out and then pull out items and damage,and better if u can add a formula for sales and it will automatic populate the on hand...thanks just suggestion
Thanks for the suggestion. I am not sure I understand the difference. Current Inventory is automatically calculated based on purchase and sales order you enter. It is equivalent to transfer in and out. Am I correct?
no sir...example you have 3 or more branches you have main branch which you will received all the items there and you will distribute or allocate how many each item you want to allocate in other branch....example my beginning on january is 500 s,m,l,xl for my inventory,i have sales 100 each sizes for january,i have transfer 100 each sizes,i have transfer each branches 20pcs each sizes then i have damages 10pcs each then how many i have now in my template something like that sir...did u get it? =)..thanks for your reply...i hope you will get my point...and better if you will teach how you make the formula for your template for us to understand...thanks!
Please provide some more details on the products. Categorization depends on a few factors - how your customers perceive the different products, how the industry categories products, how you would like to organize the products,.... Make them such a way that customers can find the products they need easily. You would not want to have too many categories with only 1 or two items in a category. This is just based on my experience with management of products on indzara.com. Hope this helps. Best wishes.
Thank you for showing interest in our template. This is usually occurred when there is no price set for the order date to that particular product. If this is not your concern, requesting to share your sheet to support@indzara.com to check further. Best wishes.
Thank you for showing interest in our template. No, currently, the requested EOQ calculation and First-Expired, First-Out stock calculation is not available. Best wishes.
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](/img/n.gif)
If only our world had more people like you!
Thanks for your kind words. Best wishes.
Can you please make something where I will only have: product cost price, its selling price, daily product sales sheet and invested amount and profit amount. Only these few features... The one in this video is very complicated for tiny businesses like mine...
Thanks.
Thanks for feedback. Best wishes.
Sure.. we must appreciate
@@tazoarahsan1212 Same question here. this video is really helpful. Thank you
Are you for real ... still, there are people like this gentleman sharing knowledge for free.. My God bless you i am so thankful for you ..
thanks once again...
Thanks for your kind words. Glad that you find the templates useful.
Best wishes.
sorry to assume your nationality, but if you're Indian, i trusted Indian people with my calculus, i will trust them with my business as well! AND YOU DELIVERED AMAZINGLY. THANK YOU i'll be using this for my business. if I encounter any problems i'll comment here for help and i hope you reply accordingly. love your work!!
You are welcome. Glad to hear that the template is useful.
Please post feedback or questions.
Best wishes.
Word Thank you is not enough for your Hard Work.
Thank you for sharing your valuable feedback.
Best wishes.
U r the master or I can say god of MS excel, brilliant, just brilliant,,I have no words to thank u for ur tremendous effort with these spreadsheet videos, I have just started a small retail shop, I was searching for a readymade excel sheet for my account handling of my business, and I can say I found more and more than enough,, u made it with so much passion and hard work and also put it for all to free download, I am sure u will get all u want in life, coz u r doing a great job for all of us, also sm questions r there also, like
1) in retail business there r many customers on a single day, (like for chocolate, mutton, icecream etc) so how to put them all in Partners and Order Headers section with Unique ID for all ?
god bless u bro,, ur one of die-hard fan from Northeast India,
Thank you for such kind words. Very glad to know that the videos and the templates are useful.
If you don't need to track at an individual customer level, you can assign a dummy Partner ID and assign all orders to the same Partner.
Best wishes.
Thanks for your continued support.
Hi! I finished filling all the info and it works:)! Only the raport, however does not show me the top 10 products or suplliers/customers etc. I did fill in the date and all the yellow options. Sales quantity and profits I can see. I hope you can help me out. Best wishes, Debra
Please email file to contact@indzara.com
Best wishes.
I can't believe you're sharing this for free. Thank you so much, Sir!
You are welcome. Glad to hear that it is useful. I do have a premium version with additional features. :)
Best wishes.
The profit will be on the link clicks not the content
This is what i call - "ALL IN A NUTSHELL" - excellent software, in fact, i was trying to design one such warehousing and distribution [inventory tracker] of spare parts for my company, in excel, but this template will assist me, at least to track the inward and outward of spares, that we receive. Thanks a lot, for the designer of this software, you made my day, lucky for me, i landed on this video. GOD Bless................
Thanks for the feedback. Glad to hear that it is useful.
Best wishes.
You teachers are doing well with the online and free tutorials
Thanks for the feedback. Glad to hear.
Best wishes.
Thank you. Great help. May you continue to benefit others for years to come.
Thank you for sharing your valuable feedback and you are welcome.
Best wishes.
You are very generous. Your excel template helps me a lot and it is very easy to edit as well. Thank you for sharing this.
Glad to hear that it is useful. You are very welcome.
Best wishes.
Thank you very much for this unpriceable support. I have no words to thank you. Appreciate very much.God bless you more and more!
Very interesting. I am planning to explore more of your templates. Thank you for your smart effort.
We are glad that you like our template and you are welcome.
Best wishes.
Extremely helpful, may lord bless you and your family with all the happiness in the world and hereafter.
Thank you for the kind words. It made my day.
Best wishes to you and your family.
I bought the Retail Business Manager recently. I am very pleased with it. Definitely worth the buy. Great job Indzara. I am looking for more templates that will make managing my small business more efficient.
Thanks for purchasing. Very glad to hear that you are pleased with it.
We look forward to your continued support. Please email us (support@indzara.com) if any questions or suggestions.
Best wishes.
Thank you so much for sharing your knowledge for free, sir! God bless you more and more!
Thank you for sharing your valuable feedback.
Best wishes.
WOW - exactly what I am looking for. Excellent job. I'm a fan!!
Thanks for the feedback. Glad to hear. :)
Best wishes.
I just need to do some smaller tweaks, but overall, I've seen nothing more perfect from what I need than this!
And this is all for free!
Kudos to you and I'll subscribe to your channel as a token of appreciation for your excellent work!
i was exactly looking for this thanks a ton
You are welcome.
Best wishes.
This is very helpful for me since I am just starting with our family business... Highly Recommended!
Very glad to hear.
Best wishes for success in your family business.
Thank you very much Sir. God Bless
This would be very helpful to my small retail business.
Glad it was helpful!
Best wishes for your business.
Thanks a lot! Very helpful and very detailed video, more power to you!
You are welcome and thank you for the compliment.
Best wishes.
Now that is so Amazing! Thank you Indzara, your videos and sample are very useful and you offered more than i expected to get in that excel of yours
Thank you. Glad it is useful.
Best wishes.
THANK YOU for this resource and great explanation!! I'm not too excel savvy and need to track my freelance side hustle, this is an epic upgrade from the handwritten notebook I was keeping.
We are glad that we could help you with our template and you are welcome. For more support related to excel, requesting to contact support@indzara.com.
Best wishes.
Wow😃 so grateful there's someone who has a big heart to share this helpful information. Thank you ❤and please keep it up. God bless you💐
You are welcome.
Best wishes,
Thanks for sharing, but anyway how to enter the daily sales?
Thank you very much for this software. I really like the way it is structured. However, I want to ask, "if I use this app for a retail clothing store, should I input the purchase order from my supplier together with the sales order from my retail customers?" I am asking because the retail sales list is a long one.
You are welcome.
Yes, you can enter one sale order and purchase order for each day in order header and map all the purchase and sale of the day under the same purchase/sale order in order details sheet.
Best wishes.
Hey bro! Used your template one year ago. Amazing tracking excel sheet!
May I know how I see my 13th-month data (and onwards) in the sales report? Since it only showed 12 months data
Thank you for using our template and sharing your valuable feedback.
You can view 12 months of data at a time in monthly metrics. After 12 months, you need to change the start date/end date of the report. In general, it will be better to use the copy of the template separately for each year so the sheet will have less order list and the performance will be high.
Best wishes.
thankyou!! this is so helpful. its quarantine 2020 and I am using this time to maximize my business venture. thankyou!!!
You are welcome. Thanks for taking the time to provide feedback. Glad to hear.
Best wishes for your business venture.
Thank you.
Great help.
May you help create MS Excel Application Inventory Warehouse ??
Thanks.
Thank you for showing interest in our template.
Yes, we take customisation projects for additional fee. Requesting to share your requirement to support@indzara.com for estimation.
We also have inventory manager template with multiple warehouse. Requesting to check the same at the below link:
indzara.com/product/retail-inventory-and-sales-manager-excel-template/
Best wishes.
Excellent video and very useful file. Thank you very much, Indzara!
You are welcome. Thanks for feedback.
Best wishes.
This is really appreciated. An extensive solution most useful.
You are welcome. Thanks for feedback.
Best wishes.
Hi this is amazing thank you so much for this!!! :) please an you help when I set something for SALE and enter 1 it doesn't add it to the "SALES" section on the product tab please helppppppppppppppp!! :(
Thank you for sharing your valuable feedback.
The sale count in PRODUCTS tab is based on the date range entered in the report tab. Hence, please ensure the sale orders are within the date range in Report tab.
Best wishes.
So useful. Thank you for sharing your template.
You are welcome. Thanks for feedback.
Best wishes.
Thank you so much for the help, I am having difficulties with the orders tab: I have a purchase order where all of my inventory is, however, when I make a sale order, the price doesnt come up. It only comes up when I input the purchase unique ID
Thank you for showing interest in our template and you are welcome.
If you are referring to order number, yes, purchase order number is mandate to populate the purchase price, else the sales price will be auto populated. Since, the order type (Purchase/Sales) is defined in the Order Headers tab and it is then populated in Order Details tab using the order number. This is done to avoid repeated entry of same information.
If this is not your concern, requesting to share some screenshot and cell reference number highlighting your concern to support@indzara.com to check further.
Best wishes.
Brilliant ! hope you still respond to comments. I am having challenges as the gross profit is not calculating automatically in the report. Only the sales and purchases quantities are showing but no purchase and sales price hence no Gross profit is being calculated. Is there anything I am missing?
Thanks. Can you please check if the unit price information is getting to the Order Details sheet from the Prices sheet? If the price is not available in the Prices sheet or if you are using an older version of Excel, the price does not come through and that may be why the quantities are updating but not amounts.
Best wishes.
You are best in market sir thanks a lot I am gonna use it in my new office thank you so much
Thank you.
Best wishes.
thanks so much for the knowledge you shared among us, it was the best God bless you richly
Thank you for sharing your valuable feedback and you are welcome.
Best wishes.
Hello! Is there any report here I can generate showing my items I ordered from my supplier minus my sold items as well as remaining inventory? Thank you
Thank you for showing interest in our template.
Yes, our report will have the requested information in total. Also the same set of informations will be available in our products tab for individual product.
Best wishes.
Hi, this is such a very helpful tool thanks for creating it and making it free to use.
I just wanted to know who can I enter the daily sales.
In other words, at the end there are numbers of sales are generated in the reports sheet, where are these numbers come from and where are their input cells that I can enter the quantity of sales.
Please help.
Thank you for showing interest in our template.
There will be two sheets to enter the sales and purchase orders.
1. Order Header sheet (1 order can have multiple order items. This is used to avoid repeated entering order related information for each order items.)
2. Order Details sheets (enter each order item and map each order item with order id.
Best wishes.
One comment: The PROFIT that is labelled on 16:37 is actually the GROSS PROFIT(Gross Profit = Revenue - Cost of Goods Sold), and it is NOT the amount of money you have left after all your expenses are accounted for (this is called Net Income. Net Income = Revenue- all expenses)
Otherwise, great video! Thanks!
Thank you for sharing your valuable feedback.
Yes, it is gross profit, calculating net profit is complicated. If you want to track the entire cashflow of the business, requesting check our Small Business Finance Manager template at the below link:
indzara.com/product/small-business-finance-manager-excel-template/
Best wishes.
First of all, I want to thank you for that, it's very important and useful.
I want to creat an excel database, May you help me please.?
Thank you for showing interest in our template and you are welcome.
Requesting to share your requirement to support@indzara.com to check further.
Best wishes.
You have a kind heart. Thanks for sharing
Thank you.
Best wishes.
wow you put alot of work into this tutorial .. thanks for sharing
Thank you. Glad that it is useful.
Best wishes.
Very very unselfish act, sharing your knowledge for free...thank you
Thanks for the kind words.
Best wishes.
Excellent sir. I'm going to use this in my newly opened clothing store. Thanks
Thanks. Best wishes for your new store.
Thank you. Let me try using the free template, experience it and see if I can purchase the one with more features. Once again, thank you
You are welcome.
Best wishes.
Thank you for sharing your knowledge - I have a question..
In the "order headers" tab - where am I typing the total order dollar amount?
There doesn't seem to be a field for the order amount, only additional order inputs like tax and shipping?
Thank you for showing interest in our template and you are welcome.
The purchase and sales price of the product is set in PRICE tab and the total amount in ORDER HEADER tab will be auto calculated according to the products filled in the ORDER DETAILS tab for a particular order number.
Best wishes.
Thanks for the video and free template looks like it could defo get me started, one question you have inventory on order and orders to be processed type info, if the inventory comes in is it simple to update stock levels and of course same applies when you sip an order
Thank you showing interest in our template and you are welcome.
Sorry, I am unable to understand your exact concern. Requesting to share your concern with some screenshots to support@indzara.com to check further.
Best wishes.
Thank you for sharing this information , EXCELLENT vid ! !
You are welcome. Glad to hear.
Best wishes.
thank you Indzara for your time and generosity, you're incredible. I've already downloaded this template, it's very helpful, but i've question, how do I fill the inventory to come and inventory to go column? i didn't find any tutorial to this, please answer my question, thanks in advance :)
You are welcome and thank you for showing interest in our template.
The inventory to come and inventory to go are auto calculated fields which will be populated according to the future dated purchase and sales orders respectively.
Best wishes.
Thank you for this, i just started to explore it today and so far its great
You are welcome. Thanks for the feedback. Best wishes.
Hi can i insert another sheet for sales, i want to keep my purchases and sales separate.
The template is designed to enter both purchases and sales in same sheet. It will require significant changes in formulas to separate.
Best wishes.
Okay, no problem. Thank you, you have already done so much this spreadsheet has help me out tremendously.
You are welcome. Best wishes.
Yeah, thank you Indzara for your time and generosity. There are just a couple of corrections to make: where it is supposed to say "additional" it says "additonal". You may wanna correct that in your raw file. The other is, I don't know why yet, when I enter Men -S in Category in row 4, it returns an "Invalid Value" error message. For the rest of the rows in the Category column it works fine. I will look into that and I'll correct it. Ok, I just resolved it. I dragged the black dot upwards from row 5 and it works now. Thanks!
Thanks for feedback.
If there are further questions, please email file to support@indzara.com
Best wishes.
Thanks for this useful template .....
You are welcome.
Best wishes.
Thank you so much 😬👏 Very helpful
You are welcome.
Thanks for feedback.
Best wishes.
God bless you sir.
Thank you for showing interest in our template.
Best wishes.
Thank a lot, Sir. Already downloaded the template.
You are welcome.
Best wishes.
Best sheet ever! Subscribed!
Very glad to hear. :) Thanks for your feedback and subscription.
Best wishes.
@@indzara I will probably get your 40 dollar one as I plan on opening a small business and it seems your manager version is really complete in terms of features n__n
Your videos and templates are amazing! Is there any video where you teach how to do those templates? Because I would like to learn how to do them by myself!
Thank you.
Courses are available at indzara.com/excel-training/
Best wishes.
Thank you.
Courses are available at indzara.com/excel-training/
Best wishes.
Thank you.
Courses are available at indzara.com/excel-training/
Best wishes.
Thank you so much for this video! Nice 😍
You are welcome 😊
Best wishes.
Thank you for sharing this template. I am a freelance agent receiving stock by the box selling items individually. The quantity per box differs per item. My reorder level must be based on pack size (not individual items). The sales price is different when a client buys a full box. I also have a quantity discount per line item, eg. more than 5 certain discount, more than 10 another discount. How would i handle this.
You are welcome and thank you for showing interest in our template.
Regarding discount,
You will have option to provide order level discount and discount per line item in this template.
Regarding box purchased in bulk,
You need to have a reference table to get the number of product present in a package. Then you can add a column before to Quantity column and write formula in current quantity to multiply the quantity with the reference table package's product count if it is a purchase order else take the same quantity. Writing the formula in the existing quantity column will minimise the effort on changing the dependent formula's column reference on quantity.
We also take customization projects for a fee. You can write to support@indzara.com for estimation.
Best wishes.
Very good stuff. Hopefully you still get messages. How would you handle inventory where we you buy a product with variations and all sell for different prices? I guess I am looking at how to calculate COGS. For inventory should we treat each variant separately as you did with sizes of clothes or lump them all together? Can you follow?
Thank you. If each variation is bought as a different SKU and sold, then please enter them as a different product.
Please let me know whether I addressed your question.
Best wishes.
Wow! This is a really helpful one. God bless
Thank you for the feedback.
Best wishes.
This is very helpful, i want to know if i dont want to use product id then, rather name of product is sufficient then what should i do?
thank you. Sorry for the delayed response. We have to point some of the formulas to use product name instead of Product ID. Or you could try entering name in the ID column. The name should be unique.
Please let me know. Thanks. Best wishes.
it is amazing!!! I want to ask you two questions, 1. when we use adjust option in the order header sheet it gets added up in the total inventory irrespective we are adjusting from supplier or customer, how to solve that ? 2. Also if I want to shift some of the inventory to my other warehouse in another state how will I take into account for that material?
Thank you.
1. When you are adjusting, you can enter the supplier or customer name as the partner name of the order.
2. The template handles only one location of inventory. This other template indzara.com/product/retail-inventory-and-sales-manager-excel-template/ tracks up to 10 locations of inventory - however, it does not have some advanced features. Please review and let me know if any questions.
Best wishes.
it will be perfect to protect those green calculating columns on PRODUCTS sheet
I agree. That feature has been a request to Microsoft to implement in Excel. I am hoping that they would allow that soon. Best wishes.
If you have not made already, can you please share a tutor to create re-order sheet for groceries based on shelf capacity, sales and stock availability and delivery lead time?
Also, pls recommend an excel to track products that are nearing expiry date
Thanks in advance
Sorry, I don't have a template for that scenario.
I will consider that for future project. Thanks for the suggestion.
Best wishes.
this is very helpful
i am new person to excel
so i cant understand how you have made all this
and the formulas you use
Thanks. It's hard to explain all the formulas here. Sorry.
Best wishes.
Thank you for the Free Template!!
You are welcome.
Best wishes.
I do not have a need for the tax columns. Will it screw up the template if I delete those columns? Thank you so much for the template!
Please do not delete any columns. If not needed, please hide them.
Best wishes.
at 8:50 as you said if price changes either for buying or selling we have to add new row, so lets say your first item MSBL from 1st nov 2016 till dec 2016 you have sold 200 quantity and now the buying price is changed from 16 to 19 we will add same item MSBL in new row in the bottom with new buying price and if we want to increase selling price we will put with effected date i want this item price was changed. Now i sell another 150 quantity in next 4 months. My question is that when i want to check this item history will it show all from 1st nov 2016 till dec 2016? like history of 350 quantity sold
I tried my best to put my question in the most explanatory way and i hope you got my point
thanks for the excellent job by the way :)
Yes, whenever a price happens (only purchase, only sales, or both purchase and sales price changes) for a product, we have to enter a new row for that product with the new purchase and sales prices. Then when we go to the Order Details sheet and enter any new order information, the correct prices effective for that order date will be automatically populated.
Please let me know if there are any questions. Best wishes.
no questions for now except thank you very much sir... :)
+Nastalia Moses you are very welcome. :)
Hello, Would the barcode go in the ID column? Which column is for suppliers?
Thank you for showing interest in our template.
Regarding barcode,
If you bar code scanner get the product ID on the selected cell as described in the following third party article, then yes.
yourbusiness.azcentral.com/double-underline-excel-mac-6583.html
Regarding supplier,
The supplier details needs to be stored in PARTNERS tab.
Best wishes.
So far so good, very helpful...but can data be synced from e- commerce website to update sales automatically? Also, is there a mobile app for this to make updates or enter sales by phone (on the go)?
Thanks. Sorry, there is not a built-in way to sync to any website. You can set up an export file from the website in a specific format (columns in the specific order) and then paste them here in the template.
And, there is no mobile version of this.
Best wishes.
This is very helpful to small business people
Thanks for your feedback. Best wishes.
Hi thank you for the template I have a question why the calculations are not reflected even when I refresh the data?
You are welcome.
Please provide more details. Can you see the formulas in the calculated cells? if so, then please check if the data is entered inside the tables correctly and for date fields please check if the date format is correct.
If there are further questions, email file to support@indzara.com along with your questions.
Best wishes.
WOW. Massive thank you!!
You are welcome.
Best wishes.
You are welcome.
Best wishes.
You are welcome.
Best wishes.
good day. thank you for this.
questions:
1.can we use barcodes reader to enter the SN of every rpoduct?
2. what can we do if we have 2 - 3 prices for each product (different price for customer category / order quantity)?
Thank you.
You are welcome.
1. I have not had a chance to work with bar code scanners yet. Sorry.
2. This template is designed for fixed prices. The other template indzara.com/2013/07/inventory-and-sales-manager-excel-template/ does not do any automatic price population where the user can enter manually price for each order.
Best wishes.
Thank you so much sir. God bless you.
You are very welcome.
Best wishes.
Indzara,This is great! I have one question. I have an online business where I accrue the shipping cost for customer orders in order to advertise "free shipping". How can i account for this esp when im analyzing monthly metrics and so on?
Thank you.
In the free template, Operational expenses are not separately recorded. In the premium template, indzara.com/product/retail-business-manager-excel-template/
if you put the shipping cost as part of the operational expenses, it will be tracked separately from cost of goods sold (which is the purchase price of product from your supplier).
Please let me know if any questions.
Best wishes.
Perfect ... its really useful.
Thanks for the feedback. Best wishes.
Thank you very much for this helpful template!
You are welcome. Best wishes.
Thank you very much for sharing.
You are welcome.
Best wishes.
Very comprehensive sheet but one thing i would lie to point out, you have calculated gross profit considering purchase price without tax which doesnt suit many of us. I want to calculate my gross profit considering price + tax + any other charges. Please guide what should be the formula in that case.
For partner name for the supplier, if I have multiple pieces and orders from the same supplier, should I leave this blank and just create a new column to keep track of that?
And also, now that I am on Product number 52 the category selection has stopped working. Any advice?
Thank you for showing interest in our template.
Regarding partner name, this need to be selected for each order entry.
Regarding product 52, you might have entered the product outside the product table or the data validation is removed in any of the prior rows. Excel table will duplicate only the consistent format on the column to new row. To resolve the same copy a cell which has the drop down and select all the cells in the column inside the table and press CTRL+ALT+v -> select validation -> press ok.
Best wishes.
This is cool!. I appreciate it! But can I know the forecast of amount to be purchased?
Thank you. The template allows a re-order amount to be entered for each product. However, the method to determine what the re-order amount is, is not in-built. Sorry.
It is something that needs to be built in the future.
Best wishes.
I was wondering- say if I've been using this template for a while, we do inventory again, but a couple items are off by a couple numbers (possibly an error in the initial inventory, or an error in data entry), is there any way to update the most current inventory if it doesn't match what it should be?
Thank you
Thanks. If actual inventory is not matching what is in the template, please add an ADJUST order.
ADJUST: We can create an ADJUST order and enter negative quantity values to reduce inventory or positive values to increase inventory as needed. This can be used to adjust our inventory numbers to ensure that the numbers match the inventory on hand. For example, we may lose products due to damage or expiry or other reasons. We would want to adjust our inventory accordingly and that’s where we can use ADJUST order type.
please read more here: indzara.com/2017/02/free-retail-inventory-management-template/
Best wishes.
Thank you very much for sharing this its really helpful . However , I am facing a problem which is the inventory value still show 0 , what can I do to fix this ?
thanks.
Please provide more details on what data has been entered and what is expected in the inventory. Please email file to support@indzara.com
Thanks & Best wishes.
The video is well explained. I have filled in all the tabs with my product information and have read 'how to use this template''. However, the green coloms are not automatically filling in the prices... the other coloms work. What am I doing wrong? Their are no blank cells aswell regarding the purple ones. Also, when I save your sample template and want to add a product the prices are gone too. I hope you can help me out.
Thanks.
Please let me know the Excel version and operating system you are using. The automatic pricing formula needs Excel 2010 or newer.
Best wishes.
Hi,
Thank you for your reply! I thought that I replied but I do not see an answer... Anyway I checked the excel version and I noticed that it was still 2007.I bought office 365 and the prices showed up. I have filled everything in and I thought it worked. Until I go to the order details. The prices all come up. However, when I go to the second order and I choose product name the price does not show up. Unless I delete the details in the row and try again. It only appears so when I go to the next row, which is below the line. To give a clear example in your video when you explain about the 'order details tab' the last order is in row 45, if I would add an order to row 46 it will change to the colour white/gray and when I insert the order number and than te product name, no prices show up. It also does not matter if I would select product name first and than insert order number. I hope you can help me out. It would be a great template if it would all work:)
Have a nice day!
Debra
Please email file to contact@indzara.com and specify the cells where there are questions. Please specify if any of the formulas have been edited from the original template.
We will review and get back to you.
Thanks & Best wishes.
Thank you for the quick response. Will send an email today. Have a good day!
Kind regards,
Debra
thanks , very informative and intuitive, can the template be used to create a barcode and use it o scan in and out products?
You are welcome. It is not built with bar code compatibility.
Best wishes.
SO HELPFUL OMG BLESS YOUR SOUL!
Thank you. Best wishes.
sir better if there is a transfer in and out and then pull out items and damage,and better if u can add a formula for sales and it will automatic populate the on hand...thanks just suggestion
Thanks for the suggestion. I am not sure I understand the difference. Current Inventory is automatically calculated based on purchase and sales order you enter. It is equivalent to transfer in and out. Am I correct?
no sir...example you have 3 or more branches you have main branch which you will received all the items there and you will distribute or allocate how many each item you want to allocate in other branch....example my beginning on january is 500 s,m,l,xl for my inventory,i have sales 100 each sizes for january,i have transfer 100 each sizes,i have transfer each branches 20pcs each sizes then i have damages 10pcs each then how many i have now in my template something like that sir...did u get it? =)..thanks for your reply...i hope you will get my point...and better if you will teach how you make the formula for your template for us to understand...thanks!
this is amazing. thank you
Glad to hear that it is useful. You are very welcome.
Best wishes.
I have a toy shop. Would you please help me making categories? It feels bit confusing to me. Thanks in advance :)
Please provide some more details on the products. Categorization depends on a few factors - how your customers perceive the different products, how the industry categories products, how you would like to organize the products,....
Make them such a way that customers can find the products they need easily. You would not want to have too many categories with only 1 or two items in a category.
This is just based on my experience with management of products on indzara.com.
Hope this helps.
Best wishes.
Is there any way to add a bar code scanner where we can just scan and input inventory amount?
And use scanner for sales and update the inventory?
Sorry, I haven't had a chance to work with a bar code scanner yet for this.
Thanks for this sir! do you have a FIFO template? Thanks very much and more power!
You are welcome. Thank you so much. I don't have a FIFO template yet.
Best wishes
I downloaded the template but the price is not picked in the report and so no value are returned for sales value, cost of sales and gross profit
Thank you for showing interest in our template.
This is usually occurred when there is no price set for the order date to that particular product. If this is not your concern, requesting to share your sheet to support@indzara.com to check further.
Best wishes.
really like the template
How to add the invoice same template?
Thank you.
It is available in the Retail Business Manager template. indzara.com/product/retail-business-manager-excel-template/
Best wishes.
Thank you 🙏🏽
You are welcome.
Best wishes.
do you have a video showing how to do the excel formulas ?
Sorry, I don't have video explaining the formulas yet.
Best wishes.
Can this do EOQ calculation and FEFO stock movement?
Thank you for showing interest in our template.
No, currently, the requested EOQ calculation and First-Expired, First-Out stock calculation is not available.
Best wishes.