google sheets for my business
I need to be able to keep track of:
-item check in (multiple vendors)
-item check out (from product inventory --> multiple vendors --> consumers)
-daily net profit
there will be a main inventory list. I am going to be adding stock in my inventory almost everyday. I want to be able to pick a vendor for each inventory product. Everyday I will be selling inventory to different clients of mine. My clients will be selling the products to there own clients. I need to keep track of what I give to my clients as well as what they sell to thier clients as well as how much profit each sale is making. I want to keep track of daily profits and input that into a separate sheet where I can add in what I am making everyday.
Also I want the inventory to be highlighted when it is running low on stock