The Book-keepers Forum (BKF)

Post Info TOPIC: Stock Records for a Small Shop with many items


Veteran Member

Status: Offline
Posts: 34
Date:
Stock Records for a Small Shop with many items
Permalink Closed


Background: One of those shops selling all manner of individual fashionable knick knacks like small table, jewellry, bath soap tablets etc etc.  Items costs would range from many at next to nothing up to say £100/£200.  There may be hundreds of ever changing items as well.

Question: is there a need to keep individual stock records (number, cost, sale price) of every item coming in and out?  And what accounting detail should be recorded when any item is sold?  Bear in mind 

Why I ask this: Because if a good stock system is not in place, surely the owners (and shoplifters!) could just remove items to their hearts content, and surely they need to know their stock value at any given time, not just at the year end.

 

Please please can someone just give me general guidance on how best to advise the best way to run their accounts. They are VAT registered.



__________________
nr


Expert

Status: Offline
Posts: 1501
Date:
Permalink Closed

If there is hundreds of unique items and is a small business then it probably isnt worth having an up to date stock system in place.  As the time to enter purchases and bar code them etc would probably outweight the benefit.

All that needs to be done is keep a track of the purchases.  Keep a track of sales (probably via till register) then at the year end do a stock count to get a value for stock and the cost of sales will be whatever stock was at the start plus the purchase less the stock at the year end.  Compare this will the sales in the year and this will give the gross profit.

Regards

MarkS



__________________

Mark Stewart CA

http://stewartaccounting.co.uk/

Providing accounting, bookkeeping, payroll and tax services to small and medium sized businesses across Central Scotland and beyond.



Senior Member

Status: Offline
Posts: 201
Date:
Permalink Closed

Hi Neil

Has the shop got an "open all hours" style till or modern Point of Sale?

Many items already come with a barcode label. All you need to do with modern POS is assign price with barcode and process volume of stock coming in. everytime barcode reader picks up a transaction, the stock quantity goes down.

when you do physical stock count, write off the difference bettween quantity of stock in till and actual volume of stock.


security - I can imagine being a nightmare unless the owner has security tags.


Dalbir



__________________

EalingMA in partnership with Arithmo Accounting Software for small business.

From £20 plus Vat per client per annum; No more excuses for small business owners and their accountants in managing their books on spreadsheets.



Veteran Member

Status: Offline
Posts: 34
Date:
Permalink Closed

Dear MarkS,

thank you very kindly for your advice.  I am just worried that unless you have a good individual item stock record system it will invite HMRC to say how do you know that goods are not being taken for personal use.  They aren't but how can you prove it!!!!  Yes I also appreciate "missing stock" can also be due to wastage and shoplifting as well!!

I tried to point this out in my question badly.

 



__________________
nr


Veteran Member

Status: Offline
Posts: 34
Date:
Permalink Closed

Dear Dalbir,

Thank you so much, but yes if you bar code everything a) it will be so costly b) you need expensive software and readers etc c) how do you barcode small trinkets and postcards etc etc.

 

Oh the list goes on.  I want to prove that the owners are honest and accurate in their accounting records but how do you draw up a happy medium!!



__________________
nr


Expert

Status: Offline
Posts: 1501
Date:
Permalink Closed

Basically

It cant be proved to the penny that everything is being accounted for properly.

HMRC will review the reasonableness of the business by review of gross profit %s.

If turnover is only about £100k per year they probably wont be worried if a few £000 worth of items is stolen/taken personally.

HMRC have bigger fish to fry.

Regards

MarkS



__________________

Mark Stewart CA

http://stewartaccounting.co.uk/

Providing accounting, bookkeeping, payroll and tax services to small and medium sized businesses across Central Scotland and beyond.



Veteran Member

Status: Offline
Posts: 34
Date:
Permalink Closed

Dear MarkS,

You are a hero sir.  I agree with your approach you advise 100%, and think it takes the right balance; or else most smallish shops in the whole country must be taking the wrong approach and risking potential HMRC problems perhaps .  Only HMRC knows where their own balance is.

 

Thank you once again.



__________________
nr
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