Forum

• # 77853
• Wed 21 Dec 2011 06:54 PM

Hi


i am working in a small company where the stock is small. However as i cannot produce a product/service invoice combined i am not imputting stock in to the sage system.   What would be the best way of recording stock so that at the end of the year the accountant can work out the opening stock/closing stock. I have currently set up a stock analysis sheet in sage but not sure if thats the right way to go. Also i am doing all the account work in sage so do i need to keep a separate manual cashbook.


Can you help! 

• 
  Quote
  

• # 77861
• Thu 22 Dec 2011 01:46 PM

Hi Domino,

You can either buy an off-the-shelf stock programme or, if the stock movements/quantities are not that vast, keep a record of all the stock codes and their movements on a spreadsheet. What ever method you choose, I would recommend that you reconcile the stock movement reports with your product invoices on a regular basis (monthly/quarterly), as both systems are being processed independently. You should maybe also do a physical stock count every quarter and reconcile to book stock. I wouldn't recommend leaving it to year end.

Regarding a manual cash book - this is your choice. You could process all the cash transactions in a manual cash book (maybe an Excel spreadsheet) and post them periodically, in batches, every week or month into Sage....or just key them straight into Sage.

Hope this helps a wee bit.

• Dave Reynolds

  Dataflow Business Services
   

• 
  Quote
  

• # 77873
• Fri 23 Dec 2011 11:53 AM

thanks Dave


I have already set up a spreadsheet for the stock and since there will not be large volumes of stock anyway i will be able to do a stock take regulary. I thought i would be ok with the cashbook query as i am doing everything in sage. I just got confused with the accountant which made me question what i was doing. Thanks for that have a hapy xmas.  

• 
  Quote