Stock Control

[carolynhw]

I sell greetings cards + other products and I would like to be able to keep a record of what I sell so I can then look at the totals of each product so I know what I have in stock and therefore know what I should order.

Does anyone know if the 09/10 Self Employed program can do this for me once I have inputted the data?

Many thanks
Carolyn

[carolynhw]

I do not want to record percentages etc. I want to log all my products and then when I sell some cards then deduct them from the total of a particular product line on the spreadsheet so at any set time I can go to the spreadsheet or however it is recorded and see what stock I have of a particular product.

[antonycc]

The package looks at stock control more to calculate "cost of sales" and the value of the companies stock but I'll take a look and see how best to model the scenario you describe and get back to you.

[carolynhw]

Many thanks

[antonycc]

Hello Carolyn,

I'm afraid there's no simple way to link sales and purchases to a stock tracking in DIY Accounting. Our purchases and sales spreadsheets are focused on the value of stock purchased and sales rather than multiples of units so we can't separate independant product lines or account for multiple levels of discount to feed this into a prediction of what should be on the shelves.

This would be an interesting future development. We could add this as a bolt on. Stock tracking would be independant but the ability to reconcile with purchases would provide a useful error check.

Thanks,

Antony.

[carolynhw]

Very many thanks for looking in to it for me much appreciated.