it is hard it takes like week to understand I like it so much thank you
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 th-cam.com/users/shortsFcxt5xGogQs
@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.
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
Please, how to maintain spare parts shop
You can add products and pricing as weight for small items and others as normal items
It depends on business like what, where and how you want to start. some businesses cost less and others cost way too much
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
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/49UYJCD