The Book-keepers Forum (BKF)

Post Info TOPIC: Proforma's


Expert

Status: Offline
Posts: 1536
Date:
Proforma's
Permalink Closed


Hi gang,

I'm just getting into my level 3 AAT studies and could use some help. I am familiar with the profit and loss accounts and balance sheets and i'm going through the activities in the Kaplan AP1 book (yep i went with Kaplan in the end, don't know if that was wise or not at this stage.) Anyhow i know which accounts to put where on the P & L and bal sheet and my totals are correct but im having trouble with the layout. Has anyone got any samples of typical P & L's and bal sheets? the P & L proforma i've got has 3 columns with pound symbols at the top, is there any specific way to fill these columns? do the columns have names?

Please feel free to PM me if this sounds confusing and i'll try to explain better.

Thanx

Spam.



__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Neil,

Look at the accounts of two different companies and your likely to have two seemingly completely different sets of financial statements.

Quite often (bit not always) with a three column format the first two columns will be current period to the left, prior period to the right.

The first two columns are both current period with constituent values to the left and total to the right.

Lets take a trading P&L as an example.

Normally the format that you will see will be as per example (A) but when you see a real set of books often the format will be per Example B with the actual calculation relegated to being a note to the accounts.

Example (C) (the format I use) is thrown into the pot just to show yet another common presentation and it also swaps the current and previous year around.

neil example.png

Basically, the importance is not in the format per se but in the content and the consistency of presentation. You already know that certain information has to be presented. Whether that is presented on the face of the documents or in the notes or indeed the column format of the information is more flexible.

Just stick with the format that the course dictates for now but be aware that the financial statements do not always look quite the way that they do in the text books.

kind 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.



Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Hi Neil

I agree with Shaun, you will come across various ways to present the financial statements.

Shauns are good examples of the common ones.

What you may also be seeing in your study books is an extension of Shauns example A, without the comparative year. In a lot of text books they show the P&L extended into sub totals, which will not have any header titles to the columns

example

Trading and Profit & Loss Account for year ended 31 December 200x

 

 

 

 

Sales

 

 

 £    109800  

Opening Stock

 £      26000  

 

 

Purchases

         87000  

       113000  

 

Closing Stock

 

£      (18725) 

 

Cost of Sales

 

 

        (94275)  

Gross Profit

 

 

         15525  

Commission Received

 

 

            100  

 

 

 

         15625  

Expenses:

 

 

 

Depreciation

           2950  

 

 

Bad Debts

            400  

 

 

Bad Debt Provision

            820  

 

 

Rents & Rates

            450  

 

 

Salaries

           5000  

 

 

Selling Expenses

           2090  

 

 

Bank Interest

              80  

 

 

Total Expenses

 

 

        (11790) 

Net Profit

 

 

           3835  



__________________

 

 



Expert

Status: Offline
Posts: 1536
Date:
Permalink Closed

Thanks for the replies and yeah Wella thats what my proformas look like, i was stuck on which figures go in the first column which in the second and third and i have no
knowledge of why and cant find the information. So if i was to put my figures in one column, just a straight down column using the correct figures would this be
acceptable? I mean why are purchases and closing stock in the middle? I know its neat and tidy but i can find nothing written about why its configured this way.


Edit: Arghhhh i was just looking at Wella's example again and something clicked, if i keep the trading account seperate then it makes sense, like, work out the trading
account then come back to the left to total the expenses. Damn my ounce of brain hurts.

__________________


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Spamkebab wrote:

Edit: Arghhhh i was just looking at Wella's example again and something clicked, if i keep the trading account seperate then it makes sense, like, work out the trading
account then come back to the left to total the expenses. Damn my ounce of brain hurts.


 Been there, done it smile

Glad the penny dropped.

Bill

 



__________________

 

 



Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

To be honest, I don't know why the expenses (in Bill's example) aren't in the middle column other than it's easier to read which figures relate to the expense category when they are closer together.

__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/



Expert

Status: Offline
Posts: 1536
Date:
Permalink Closed

Could you write the expenses in the middle column and still be correct?

__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Yes but then you just end up with only two columns with anything in them. (would just end up looking like my option (A) but without comparatives).

__________________

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: 2256
Date:
Permalink Closed

Spamkebab wrote:

Edit: Arghhhh i was just looking at Wella's example again and something clicked, if i keep the trading account seperate then it makes sense, like, work out the trading
account then come back to the left to total the expenses. Damn my ounce of brain hurts.


 

 Just re read you comment, and the penny dropped with me. You say "keep the trading account seperate" which is the normal convention. Dont forget the full title is a Trading and Profit & Loss Account. We tend to just shorten it to P&L account. The Trading Account is always calculated first, to give the gross profit.

Frank Woods Book Keeping and Accounts ISBN0273685481 (I use 6th edition but there are later editions now), has good examples of TPLs and balance sheets.

 

HTH

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