The Book-keepers Forum (BKF)

Post Info TOPIC: Month end stock adjustments Sage


Veteran Member

Status: Offline
Posts: 40
Date:
Month end stock adjustments Sage
Permalink Closed


I've to complete a month end, I realise my opening balance will be last months closing balance then I will have to add purchases and deduct returns then minus closing stock, please can someone explain the procedure I will go through for month end, to arrive at the correct figures.  I'm ok working this manually but apprehesive with Sage line 50 and I don't want to mess up.
no
Chriss

__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Chriss,

Sorry, I'm with you on Sage. I use it but I don't like to give advice as I'm no expert with it (Excel is my baby).

Bear with it this evening as many of the regulars may take some time to come back on line.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Veteran Member

Status: Offline
Posts: 40
Date:
Permalink Closed

Thanks for replying Shamus,

I'm no expert on Sage and lack confidence, I seem to freeze at the simplest transactions, I feel stupid asking but I just need someone to walk me through the month end procedures on it. no

Chriss

__________________


Guru

Status: Offline
Posts: 1329
Date:
Permalink Closed

With Sage, the program does the work (provided the input is correct in the first place).

If you have sorted out accruals, prepayments and depreciation using the tools provided within the program. You go to Tools, Period End, Month End and press the button.

To be honest I never use this (except in exams) as I leave everything to the accountants at the year end,.

Opps misread the post.  Yes with stock you need to transfer opening stock and closing stock just as you would manually.

-- Edited by semsley on Tuesday 6th of July 2010 09:37:07 PM

__________________

Advice from beyond the grave!!!

E&OE



Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

imagine the computer is just a piece of paper but on a screen and then work as if you were doing it manually.

Computers only work on the figures that have been input, and sage does have automatic stuff whereby you just press a button, but I still prefer to do manual journals as then I know what I have done. I dont use period end, month end etc nor accruals, prepayments, I do them all manually!!

With stock, make the journals as you would normally.

P



__________________


Member

Status: Offline
Posts: 22
Date:
Permalink Closed

Hi Chriss

The entries I make in Sage each month for stock adjustments are:

Dr 5216 Opening stock
Cr 1000 Opening stock

Dr 1000 Closing stock
Cr 5216 Closing stock

This ensures that the BS shows the correct closing stock, and adjustments to stock levels are taken throught the P/L.

Hope that this helps

__________________

Claire



Veteran Member

Status: Offline
Posts: 40
Date:
Permalink Closed

Thanks for all your replies.

I've got different nominal codes, they aren't the standard ones, I can't use the wizards or the normal nominals, it makes a straight forward job, become really difficult. frustrated.gif

Chriss

__________________
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-2024 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: bookcertltd@gmail.com.

Privacy & Cookie Policy  About