First Previous - Page 1 of 1 - Next Last

No Stock take done

  • Fellow PM.Dip
  • 13 posts
  • # 75222

I have recently been appointed to do two connected company retails stores, they have never kept a proper
set of accounts and just submitted a spread sheet of really (income and expenditure) to their accountants
for year end account (Oh the are Ltd). I have insisted that we do the account on Sage which they have agreed.
I have managed to get the 2009/2010 opening balances from the accountants, and have got the 2010/2011 accounts up to date, however, we are now passed there end of financial year and they did not do a stock take, so no closing stock figure. Is it in order to work out their closing stock figure from the accounts, ie take opening stock plus purchases, deduct markup from sales and then deduct this to give me the closing stock figure? Or is there any other way as to
take stock now a deduct stock and add back sales would not be practical.

Thanks Carolyn

  • 153 posts
  • # 75333

It sounds like an estimated stock figure is the only option they've got, it's something that I've noticed small business often neglect.

But instead of working from the opening stock would it be easier/more accurate to do a stock take now and adjust for the sales/purchases since the year end? That might give a truer value, taking into account any losses? 

  • Member
  • Practice Licence
  • 88 posts
  • # 75336

Hi Carolyn,
I'm amazed that over 100 peope have read your post, and not one has ventured a reply, as you clearly need some help here. If I start this off, then maybe some other learned guidance may dip in too afterwards.
Your suggested approach makes sense in the absence of anything else.
The audited opening balance has to be the firm starting point.
Things that may affect your calculation to get to closing stock could include :
- a general sales price rise across the stores part way through the period
- any zero rated VAT items (if records are this poorly kept, do the SDB and PDB analyses make sense ?)
- customer returns policy
- evidence of an authorised credit note process.
- inter store transfers
- do issues and receipts match at each end ?
- allowance for time expired items and pilferage
- staff sales process
- are all inventories held within the two stores, or is there a remote storage facility
- do any inventory provisions exist, and is there evidence of GL postings in 2010/11 that will affect your review. 

Stating the obvious, you need to be advised what valuation policy exists - Standard Cost, LIFO, FIFO, Average Cost etc and be confident that this is consistent from the previous year. 

You should definitely cover your own position in your engagement letter, and have it agreed with a Director.
Directors have a duty of stewardship for business assets, even if they are also the sole shareholders.

The Accountant should be qualifying the accounts if the risk of inventory value mis-statement is material to the financial statements, as this could mean an incorrect corporation tax charge, or owner-directors awarding themselves unrealistic remuneration based upon questionable revenue gain.

Last thought.............are the other assets simply recorded as spreadsheet lists too.....bankings, creditors, fixed assets ?



postscript
Looks like some more help has just been offered - thanks Ruth

Edited at 17 Oct 2011 08:40 PM GMT

  • Fellow PM.Dip
  • 13 posts
  • # 75360

Hi Ruth and Pete

Many thanks for your help, Ruth I did think about adding back the sales and deducting the purchases, but
they have just received their winter stock in (loads of it) so they probably would have to close the shop which
at this time of the year they are very busy (they are a clothing store) I don't think that would go down very well. I will be getting hold of the accountants again, as they are having to do this with the other store, for their 2010/2011 year end which I haven't  even  got onto Sage yet that year end was January 2011 and no stock take was done. Will get that onto Sage as soon as they have completed the year end and have to catch that up to. I have put my foot down and told them they must do a stock take. They are a nice bunch even if their heads are in the clouds but they do listen to me. What a mess but what a challange to get it all correct. Pete yes everything is on a spreadsheet, I asked the accountants for a breakdown of the fixed assets, they did give me the balances, but did say that this was only what
they could pick up from the spread sheet submitted for that set of accounts for the store. The same for outstanding creditors etc. Luckly nothing is sold on account and all is cash takings so that helps as there are no oustanding debtors to worry about. They do make sure that the till readings and banking matches so no problems there. What a mess though but am determined to got it correct.

  • 698 posts
  • # 75475

Hi All

A nice incomplete records problem.

I have attached a link below to an ACCA article on dealing with this issue.

Pete you are correct you start from the opening stock balance and work forward using the known mark up's or margin's

You dont really have to take into account the long list you have stated nor do you have to worry about VAT. The answer lays in the Trading portion of the P&L.

Sales - Opening Stock - Purchases + Closing Stock = Gross profit.

Therefore if you know the sales, opening stock and purchases and you know the mark up or margin you can then calculate the gross profit which will then enable you to work out the Closing stock.   
    
http://www.accountancy.com.pk/articles_students.asp?id=139

I hope this helps

Kind regards
Stuart

  • Fellow PM.Dip
  • 13 posts
  • # 75486

Hi Stuart

Thanks for the confirmation, thats exactly what I have done to get to the closing stock, its nice to have confirmation
as sometimes you think you are on the correct track but being the first time this has arisen for me, I wanted to get
confirmation that I as doing it correctly.

First Previous - Page 1 of 1 - Next Last
bottomBanner
loading