Say I have a price for one product that changes one day to the next, how do I go about entering this into the inventory sheet without messing up the profit from the same product sold at a different price the day before. Do I need to make a new sheet for price changes each time?
No, you don't need to create a whole new sheet just do a simple thing and add that as a different product let's say You had "Venom Tee" at 20 cost and 30 Price then add a new product "Venom Tee V2" with the new price if you don't want to mess with anything in the past I hope this is helpful @lukewooten8084 🙏
@Brain Behind Business thanks for this. Very helpful. One challenge for me though, the product list doesn't update in the ins&outs when i add new products to the list in data. Any tips to resolve this.
I am trying to create a furniture inventory sheet, and I want to ask you what kind of formula can I use if I want the value I place in (for example) column A(inventory In) to add to column C(current inventory), and the value that I put in column B (inventory out) to subtract from column C. Is there a way that you can suggest I can accomplish this?
Hi @Dwalk416, Please watch this whole video again you need to add products in product sheet and then ins and outs in different sheet. If you want a paid consultation then we can book it from the description of the video
This actually has a lot o small things that if you follow the exact steps by steps it will show you errors. From the first vlookup formula it’s wrong. You’ve entered too many arguments for this function
you need to check all your cost and expenses. 1- you must have a good location 2- then you should set a side atleast 6 months of rent apart (for example 20k rent then keep 120k separate for rent) 3- Try to find place to buy auto parts in good price (Cheap but good quality) for 4 lakhs keep other money for buying goods later on. This is a general overview further you can research in your city about it. I am not a proper advisor in this and dont know your location, situation, and experience
How to have customer information in this excel file where we insert only the customers names and sales during the time and excel calculate the left inventory the sales and profits
sales, inventory left and profit are already explained in this video, please watch complete video for that. Customer option can be added but that would be more complex but will make that in future for you. Stay tuned
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/49UYJCD
it is hard it takes like week to understand I like it so much thank you
Glad it helped! Stay Connected for more content like this.
God bless you🙌 you're helping me alot 🙏 ❤️ 😊
Happy to help!
Thankyou ❤
Very nice vedio, i am learning alot in this video. Thanks
Stay connected for more amazing videos like this.
Subscribe and hit bell icon to stay updated
Say I have a price for one product that changes one day to the next, how do I go about entering this into the inventory sheet without messing up the profit from the same product sold at a different price the day before. Do I need to make a new sheet for price changes each time?
No, you don't need to create a whole new sheet just do a simple thing and add that as a different product let's say
You had "Venom Tee" at 20 cost and 30 Price then add a new product "Venom Tee V2" with the new price if you don't want to mess with anything in the past
I hope this is helpful @lukewooten8084 🙏
Which formula did you use for the date please, I'm interested 😢
Its =Today() to get date of current day
I have made a video on this ua-cam.com/users/shortsFcxt5xGogQs
Very helpful! Thank you very much!
Glad it was helpful!
What if cost of the product varies time to time?
You can add that product separately with different price like ABC @ $10 then ABC2 @ $12
Thank you,
You are welcome!
@Brain Behind Business thanks for this. Very helpful. One challenge for me though, the product list doesn't update in the ins&outs when i add new products to the list in data. Any tips to resolve this.
It should update, may be you have not properly followed the video. You can also download my version of the file from description and it should work
@@BrainBehindBusiness thank you. I figured it out. It had to do with validation of the data.
Okay great. Stay connected
I am trying to create a furniture inventory sheet, and I want to ask you what kind of formula can I use if I want the value I place in (for example) column A(inventory In) to add to column C(current inventory), and the value that I put in column B (inventory out) to subtract from column C. Is there a way that you can suggest I can accomplish this?
Hi @Dwalk416,
Please watch this whole video again you need to add products in product sheet and then ins and outs in different sheet. If you want a paid consultation then we can book it from the description of the video
This actually has a lot o small things that if you follow the exact steps by steps it will show you errors. From the first vlookup formula it’s wrong. You’ve entered too many arguments for this function
Thank you for your comment and constructive criticism but I think all those formulas are working fine and what you mean by many arguments?
Please, how to maintain spare parts shop
You can add products and pricing as weight for small items and others as normal items
@@BrainBehindBusiness how many budget needed to start business
It depends on business like what, where and how you want to start. some businesses cost less and others cost way too much
@@BrainBehindBusiness will 8Lakh enough for normal
you need to check all your cost and expenses.
1- you must have a good location
2- then you should set a side atleast 6 months of rent apart (for example 20k rent then keep 120k separate for rent)
3- Try to find place to buy auto parts in good price (Cheap but good quality) for 4 lakhs
keep other money for buying goods later on.
This is a general overview further you can research in your city about it. I am not a proper advisor in this and dont know your location, situation, and experience
Wow😮😮😊😊😊❤
Thank you
How to have customer information in this excel file where we insert only the customers names and sales during the time and excel calculate the left inventory the sales and profits
sales, inventory left and profit are already explained in this video, please watch complete video for that.
Customer option can be added but that would be more complex but will make that in future for you. Stay tuned
@@BrainBehindBusinessI'll subscribe if u upload that, lol
Okay then please wait till that video :P
Sir apanka clear bhabare assuni 😢
@mkdtapuyt2673 Sorry can you please write in English?