opening + purchased - sales v closing Stock : validation query?

UK Discussion in 'Technical Queries' started by Stuart, Jan 9, 2017.

  1. Stuart

    Stuart

    Joined:
    Jan 9, 2017
    Messages:
    2
    Likes Received:
    0
    Hello All
    I am a newbie, this my first post I am an OAP and wish you all a successful year.

    I would be interested to know what I should make of the Statement of Accounts for my Allotment Club.
    Apart from not balancing it shows stock entries as follows:
    opening stock: 1488.66
    Stock Purchased: 1528.36
    Sales: 970.94
    Closing Stock: 2993.27

    My questions are:
    Is this possible? (I wish I could replicate it in the real world).
    Can I insist on a recount?
    The auditor of the accounts is a close relation to both Secretary & Treasurer - Is this illegal or just inadvisable?
    I hope my attempt to upload a copy has succeeded.

    Thanks in advance
    Stu
     

    Attached Files:

    Stuart, Jan 9, 2017
    #1
    1. Advertisements

  2. Stuart

    Radek Výtisk

    Joined:
    Dec 19, 2016
    Messages:
    14
    Likes Received:
    0
    Well, I see one flaw in your calculation and that is the sales. These should definitely not be included in the equation. Or, to be more precise, there should be cost of those sales included, not the sales. So the equation should go like:

    Opening balance + purchases - cost of products sold = Closing balance

    Not sure that I understand what the SoA is trying to say, though. Never seen something like that, it looks like some cash based recap of transactions but I am used to accrual based ones so someone with more experience with this.

    Hope this helps a least a bit.
     
    Radek Výtisk, Jan 10, 2017
    #2
    1. Advertisements

  3. Stuart

    Stuart

    Joined:
    Jan 9, 2017
    Messages:
    2
    Likes Received:
    0
    Thanks Radek - What I was meaning was that opening stock + stock Purchased = 3017.02
    then closing stock is 2993.27
    it seems to say £23.75 stock value produced £970.94 sales income.
    Which is surely not possible?
     
    Stuart, Jan 15, 2017 at 2:57 AM
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bamboo Sticks in Gelly

    What is the role of opening/closing inventory in COGS?

    Bamboo Sticks in Gelly, Sep 15, 2005, in forum: Quickbooks
    Replies:
    10
    Views:
    2,727
  2. Marilyn & Bob

    Closing the backup dialog without closing Money

    Marilyn & Bob, Feb 22, 2006, in forum: Microsoft Money
    Replies:
    1
    Views:
    771
    Chris Cowles
    Feb 22, 2006
  3. Andrea

    RMS- shift work and opening/closing the drawer

    Andrea, Dec 2, 2005, in forum: Microsoft Point Of Sale
    Replies:
    1
    Views:
    415
  4. Willie Whelan

    Opening & Closing Times on Open And Blind Closed Batches

    Willie Whelan, Oct 20, 2006, in forum: Microsoft Point Of Sale
    Replies:
    3
    Views:
    460
    Willie Whelan
    Oct 23, 2006
  5. taze
    Replies:
    1
    Views:
    950
    Jason
    Nov 26, 2006
  6. gregfrgusa

    Cash Drawer Opening when inputting closing amounts

    gregfrgusa, Oct 3, 2008, in forum: Microsoft Point Of Sale
    Replies:
    2
    Views:
    401
    gregfrgusa
    Oct 5, 2008
  7. Diane Koers

    Slow opening and closing

    Diane Koers, Aug 3, 2004, in forum: Peachtree Accounting
    Replies:
    2
    Views:
    428
  8. spiny

    UK sole trader car v van

    spiny, Dec 29, 2016, in forum: General Accountancy Discussion
    Replies:
    1
    Views:
    66
    spiny
    Dec 30, 2016
Loading...