The Book-keepers Forum (BKF)

Post Info TOPIC: Stock supplies used in workshop


Member

Status: Offline
Posts: 13
Date:
Stock supplies used in workshop


Hi all,

I am going round in circle with this so thought I would ask for some ideas:

A client runs stock module on Sage 50C. About 12 times a month workshop staff use some of the shop stock for workshop/cleaning use.

They have been using the adjustments out module just to alter the stock which needs to change.

Any ideas on how I reduce the stock items used and at the same time charge the company the cost price of the stock under workshop consumables so it appears in the P&L as an expense.

Thanks

Jenny.



__________________
Jenny


Member

Status: Offline
Posts: 18
Date:

retsub35 wrote:

Hi all,

I am going round in circle with this so thought I would ask for some ideas:

A client runs stock module on Sage 50C. About 12 times a month workshop staff use some of the shop stock for workshop/cleaning use.

They have been using the adjustments out module just to alter the stock which needs to change.

Any ideas on how I reduce the stock items used and at the same time charge the company the cost price of the stock under workshop consumables so it appears in the P&L as an expense.

Thanks

Jenny.


Why would you 'charge the company' when the company has quite clearly already been expensed for this when they bought them?!!!!



__________________


Member

Status: Offline
Posts: 13
Date:

When stock arrives in it is booked in as goods for resale under nominal code '5000' and obviously the stock cost value becomes part of the stock value figure on the balance sheet. You do have to make an adjustment to your accounts if you are going to use some of the stock for business use and not for resale, this is to ensure that the stock expense goes back into '5000' and goes out of say '6000' workshop supplies or overheads for cleaning products etc. The process has to ensure the stock figure is altered to reflect the number now in stock, any ideas anyone?

thanks

Jenny.



__________________
Jenny


Member

Status: Offline
Posts: 18
Date:

5000 is an expense/cost code.
6000 is an expense code.

So you have two expenses in the SPL!

Adjustments are done to the SFP/SPL.


So when you code to 5000, when stock arrives how are you adjusting then in the SFP. How are you adjusting the SFP when you sell stock?

edited to correct initials



-- Edited by Sage on Monday 12th of April 2021 04:25:46 PM

__________________


Member

Status: Offline
Posts: 18
Date:

ie how does ''obviously the stock cost value becomes part of the stock value figure on the balance sheet'' happen?



__________________


Member

Status: Offline
Posts: 13
Date:

Hi Sage,

can you clarify your abbreviations SPF - stock price figure, SPL?

thanks

jenny.



__________________
Jenny


Member

Status: Offline
Posts: 18
Date:

typed wrong way round - should be SFP not SPF. Statement of Financial position. Balance sheet in old money.

__________________


Member

Status: Offline
Posts: 13
Date:

Hi Sage,

I have realised I have completely over thought this process. My P&L is analysed with '5000' purchases (for resale in shop) and then '6901' workshop supplies, cleaning products '7801' charged to overheads etc. When staff take stock from the shelf that was intended for resale I wanted to shift the expense from '5000' to say maybe rags used for the workshop '6901', it also had to show that the stock was being reduced. The solution suddenly clicked this evening:

Use adjustments out to take out the stock used in the workshop or cleaning products used for the office then at month end I run a product analysis report, add up the cost price of all stock used by staff and then post a journal as follows:

credit '5000' net cost price of total amount used.

debit '6901' net cost price of rags

debit '7801' net cost price of cleaning products

Hope that makes sense, hopefully that's right, sorry to confuse!

thanks

Jenny.



__________________
Jenny


Newbie

Status: Offline
Posts: 1
Date:

Hi, new here and a bit late to the party, but that's exactly what I was thinking... the key is it comes off the balance sheet and into the P&L, and not sure how automated Sage is, as it might automatically dump all stock write offs to cost of sales... but a journal entry can reclassify it..

Sounds like you have it spot on..

Phil



__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
2007-2021 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: info@bookcert.co.uk.

Privacy & Cookie Policy  About