Hello friends, i just started a ecommerce business i need to track my sale return and stock in excel to keep track of profit and loss cz i am selling offline too.. can somebody help me in improvising my excel by telling what else column/sheets needs to added for generating good reports to improvise my business which help me choosing the right products..
1. Pirchase sheet: product id, product name, date of purchase, quantity, price per unit
2. Sale sheet: product id, product name, date of sale,quantity, source of sale(offline/online), sold price, return(Y/N), return Adjustment,
3. Stock sheet: productid, product name, total quantity, quantity avaible, total stock value, total sold value
1. Pirchase sheet: product id, product name, date of purchase, quantity, price per unit
2. Sale sheet: product id, product name, date of sale,quantity, source of sale(offline/online), sold price, return(Y/N), return Adjustment,
3. Stock sheet: productid, product name, total quantity, quantity avaible, total stock value, total sold value
