I have a Macros enabled spreadsheet that I import sales data into, which then works out profit on all sales (via page where I enter cost values to SKU's). I would like this spreadsheet edited to be able to accomodate a few extra features.
I would like the spreadsheet to be able to give me an overview of sales for the week/month/quarter/year, I would like it to automaticlly generate data of best selling product/biggest profit items etc.
I would also like to incorporate a stock control element, so I can enter when I buy stock, and it is deducted from the stock as and when it sells (through the use of SKU's) and then this data collated on a weekly, monthly basis to show how much stock is being used on a weekly/monthly basis which will enable me to see trends and also and easy way to see when we are running low on stock.
Best Regards,
Ben
Not good with Accounting & Finance but developing Excel macros since 1997. So, if you have a clear vision of what is to be achieved, I can be of assistance. Regards, Svet.
Hi, do you have something more detailed about the things you need? I mean, like a template in the excel with some step/step about how to get each value? Thanks
i understand SKU based inventory management. i will add features to your spreadsheet by which you will get qty/amount of stock at any time, most selling and most revenue creating inventory will be highlighted seperately (any time). SKU wise soock will be updated as you enters a stock procured or sold in the main sheet. Inventory will be highlighted when it reached a certain level (min/max) to avoid stockouts or blockage of funds in dead inventory, as the case may be. I can surely help you updating your existing system. Regards Hiba