The Book-keepers Forum (BKF)

Post Info TOPIC: Stock recording on Sage


Newbie

Status: Offline
Posts: 3
Date:
Stock recording on Sage
Permalink Closed


Hello all

I'm quite new to freelancing although I've been doing BK for employers for 10 ish years, mainly using Sage.

My client runs her own business buying and selling groceries online. She started trading in March 09 and needs to file her first return online by early Jan, which I why I was brought in.

I have loaded on all her paperwork onto Sage and have given her her reports for submission. However Companies House are asking for year end stock figures...she is going to try and work out how much stock she had, but how do i build that figure in to the accounts?

From previous postings here I see 1001, 1002, 5200 and 5201 are touched, but how can I incorporate it the figures. Her opening stock was of course 0.00, but I've posted all her purchases to 5000, not 5200.

The BS currently balances, surely if there's to be an entry in Stock current assets, it won't balance? Similarly, the P&L will be out too....

confuse Confused newby, please help!
Helen x

__________________


Guru

Status: Offline
Posts: 518
Date:
Permalink Closed

Dr Stock BS Current assets
Cr Stock P&L Cost of Sales

Why are Companies House asking for it?

__________________

Phil Hendy, The Accountancy Mentor

Are you thinking of setting up your own practice or have you set up and need some help?

If so a mentor may be the way forward - feel free to get in touch and see how I can assist you. 

 



Guru

Status: Offline
Posts: 518
Date:
Permalink Closed

I would also suggest that if it is a Limited Company your client ought to be speaking to an accountant. The accounts need to be in a certain format for filing both for Companies House and HMRC.

__________________

Phil Hendy, The Accountancy Mentor

Are you thinking of setting up your own practice or have you set up and need some help?

If so a mentor may be the way forward - feel free to get in touch and see how I can assist you. 

 



Newbie

Status: Offline
Posts: 3
Date:
Permalink Closed

Hi Phil, thanks for the replies. She's not Ltd, she's a sole trader.

Her email to me just reads that she needs to enter a closing stock figure.

Re: nominal code in Sage, is that 1001 for BS and 5201 for P&L?

Thanks again
Helen.

__________________


Guru

Status: Offline
Posts: 518
Date:
Permalink Closed

hellonwheels wrote:

Hi Phil, thanks for the replies. She's not Ltd, she's a sole trader.

Her email to me just reads that she needs to enter a closing stock figure.

Re: nominal code in Sage, is that 1001 for BS and 5201 for P&L?

Thanks again
Helen.



Ok understand re: the company - it may be worth making clear to the client the difference between Companies House and HMRC. It may be that they want to have a limited company!

 

Don't know the sage codes off hand but that sounds about right.



__________________

Phil Hendy, The Accountancy Mentor

Are you thinking of setting up your own practice or have you set up and need some help?

If so a mentor may be the way forward - feel free to get in touch and see how I can assist you. 

 



Newbie

Status: Offline
Posts: 3
Date:
Permalink Closed

Hi again

Thanks for the advice, I shall get on it smile

Regards,
Helen.

__________________


Expert

Status: Offline
Posts: 1963
Date:
Permalink Closed

Hi helen,

to confirm Phil's advice it will be dr 1001, cr 5201 (being closing stock). She needs to value stock at the lower of cost or net realisable value. At the moment without any entry for stock, her profits will be reported too low, the closing stock on the P & L will is credited to purchases and so her gross profit will increase, therefore the lower the stock figure obviously the lower the profit (and a lower tax bill).

Rob

__________________
Rob
www.accounts-solutions.com


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Hi Helen

Just to pick up on Robs point about cost and net realisable value. You need to ensure your client understands that concept. You wont believe how many people I have had to explain that to. A lot seemed to think it was the retail value they needed.

Bill

__________________

 

 

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