P&L Report - The Book-keepers Forum (UK)

Boris · Veteran Member

P&L Report

Cheshire · Master Book-keeper

Sounds like your Chart of Accounts has a problem - click on COA and 'check' - will tell you what you are missing.

I would also have a go of the training modules in sage - there is one that will just let you view all the different things you can do and one which lets you play around with sage without impacting on the real business.

if you are doing anything on the real system - backup before you do

Boris · Veteran Member

Thank you,

I have done it and I suppose to use the Partial COA, I never use it until now.

What should I do now to set it?

Regards,

Boris

Eilef · Senior Member

To get as much detail as you or your client requires in the P&L report you need to set up your COA and nominal codes to report.

For example if you have laptop sales as 4000 and desktop sales as 4001 to get the breakdown you need to admend the COA to show this

Laptop sales 4000 Low and 4000 high
Desktop sales 4001 low and 4099 high

The same with purchases to break them down into more detail otherwise you just get one figure grouped together.

Onion4Sage · Senior Member

As a general rule you should never use a chart of accounts that includes [PARTIAL] at the end of the name unless you understand fully and intimately the consequences of using that incomplete chart of accounts. Sage will add this postscript to any chart of accounts it detects as incomplete.

Regards,

Cheshire · Master Book-keeper

Hi Boris
Totally agree with what Ian has put. Question is - have you keyed much since you amended the chart and can you unravel it by way of doing a restore, or would this involve a mountain of keying? Given your experience I would suggest that as your first option if you havent keyed much since amending it.

Otherwise - it really depends on what is missing. Firstly when you go into COA - is there another [default] chart of just the one showing [partial]? For the partial one I would click on check and you will get an error report showing esactly what is wrong. Depends what is on that report as to how easily (or not) it can be rectified. Perhaps try the error check and if you dont understand it - post on here for us to view. Although might need someone else's help - any changes I make to a COA I backup first, then check the impact fully before I start to key anything because Im not sure how to unravel it when it gets complicated.

Onion4Sage · Senior Member

Joanne,

I think COA changes apply to anything that has been keyed. If you change the COA now, all your transactions will reflect the change. Consequently, I don't think there can be anything to unravel unless you used an incorrect one to perform a year end.

Regards,

Edit: Sorry, I see what you are saying now. You were thinking that it would be worth restoring to recover the COA to a pre [PARTIAL] state if there weren't too many transactions going to be lost. Doh!

-- Edited by Onion4Sage on Tuesday 23rd of June 2015 04:03:43 PM

Cheshire · Master Book-keeper

Onion4Sage wrote:

Edit: Sorry, I see what you are saying now. You were thinking that it would be worth restoring to recover the COA to a pre [PARTIAL] state if there weren't too many transactions going to be lost. Doh!

-- Edited by Onion4Sage on Tuesday 23rd of June 2015 04:03:43 PM

Yep.

I was also thinking that if you slung in an extra nominal and moved all the lows/highs, sometimes its harder to work your way through it to correct it especially if youve never done it before. Although its the best way to learn! But would need to see the 'check' list first as it might be easy to sort.