The Book-keepers Forum (BKF)

Post Info TOPIC: how to do opening balance?


Newbie

Status: Offline
Posts: 1
Date:
how to do opening balance?
Permalink Closed


 

Trial Balance
             Dr               Cr
Commission                 300
Room rent            1,800 
Sale                4,855
Purchase            2,700 
Sundry exp            200 
Carriage inward            200 
Carriage outward            200 
Capital                3,300
Salaries            3,800 
Wages            380 
Bank Interest                300
Discount All            102 
Discount Rec                225
Purchase Return                450
Sale Return            285 
Opening Balance               10,500
Cash            795 
Bank         9,468 
           19,930

             

           19,930

 

***********************************************

 

Trading, Profit and Loss
Opening Stock           500  Sale    4,855 
Purchase         2,700  Sale Return       285 
       3,200      4,570
Purchase Return           450    
       2,750    
Carriage Inward           200    
       2,950    
 closing stock            500    
          2,450    
G.P         2,120    
          4,570      4,570
Room rent         1,800  G.P       2,120
Sundry exp           200 Commission         300
Carriage outward           200 Bank Interest         300
Salaries         3,800 Discount Rec         225
Wages           380    
Discount All           102    
    Net Loss       3,537
      
       6,482      6,482
      

**********************************************************

Balance Sheet

    Opening Balance     10,500
    Capital       3,300
        13,800
Cash           795  Net loss       3,537
Bank    9,468.00      10,263
Closing stock           500    
      
      
     10,763    10,263

My Balance sheet is not equal. pls find to me error.

many thanks.



__________________
biggest


Expert

Status: Offline
Posts: 1501
Date:
Permalink Closed

At a quick glance appears to be stock.

Where is your opening stock in the trial balance?  You have opening stock of £500 in the P&L but nothing in the trial balance.  The closing stock in the P&L and balance sheet is £500 will of course be a period end adjustment but the opening stock in the P&L should come from the trial balance but isnt there. If the opening stock is included in purchases of £2700 then this will make opening stock £500 and purchases £2200.  This will reduce your loss by £500 from £3537 to £3037 and increases your reserves to £10763 on the balance sheet.   Altenatively opening stock could be £nil.  This will have the same effect to reduce loss by £500 to £3037 and increase reserves to £10763.  Probably the 2nd scenario is correct in that there isnt any opening stock at the start of the period.

What is my commission for doing your homework/assignment?

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.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Sawatdeekap Biggest,

kun sabai dee mai?

In the above where are your opening and closing stock figures coming from?

They do not appear in the original trial balance.

If removed as both opening and closing stock in the P&L and as closing stock in the B/S your figures balance.

The key would therefore seem to be an eroneous £500 closing stock figure in the balance sheet (as the P&L figures cancel each other out).

Happy to rethink my answer in the light of more available information if you have it.

I've reformatted your answers slightly but the figures are the same and in the same places.

Reformatted version of your answer :

Biggest with opening stock.jpg

 

As above but with Opening and closing stock removed. (please supply further information from original question if this is not correct).

biggest without closing stock.jpg

Kindest regards,

Shaun.



__________________

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.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Mark,

Snap... ish. I get the answer to £10,263 but your welcome to check my workings.

talk in a bit,

Shaun.



__________________

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.



Expert

Status: Offline
Posts: 1501
Date:
Permalink Closed

Hi Shaun

My feeling is that given is looks like a school assignment or similar that there is £nil opening stock and £500 closing stock which would reduce the loss to £3037 and and increase reserves to £10763.

Looks like the poster has got confused with stock when they were probably told that closing stock was £500 and they have recorded it as both opening and closing stock.

Mark



__________________

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.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Biggest,

just to fill out the third option per Marks reply in the same format as my answer above (just to complete the set) :

biggest marks answer.jpg

Note that either mine or Marks answer is potentially correct dependant upon the bit that you missed out of the question in relation to stock.

... So I'm after half of Mark's homework commission wink lol

Where in Thailand are you from?

I used to live in KhonKaen... Well, when not living in the Chareon Thani Princess I actually lived mostly just outside it in the village of Kut Nam Si close to Nam Pong.

talk soon,

Shaun.



__________________

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.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Good point Mark.

I thought about it afterwards and concluded that either of us could be right dependant upon the missing information and my money is coming down more on your side as I'm sure that Biggest didn't just dream up £500.

And here was me thinking it was just clients that only gave us half of the information. lol.

__________________

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.

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