Freelancer:
tassie11
inventory management
Here it is my proposition for your inventory and sales tracking. I have created 2 tables, one for the sales and one for the purchases, to be updated each day, so you can have all the records for all your transactions. In the Inventory tab, the actual stock (current date) it's automatically calculated, but you can also choose a different date if you want to see what was the stock you had in the end of last month for example. For the Sales analysis, I created a pivot table, where you choose the desired week (or date) and the pivot gives you the top 10 sales for the period. This is, of course, 100% customizable.