Blogger
Share this content
0
12
4244

Sage 50 - Trace accounts in Chart after set up?

When one sets up a new account in Sage (50) one places in in one of the sub-groups that make up the summary financials.  Is there an easy way to see where in the accounts an individual account fiunishes up once it is in use?

You would think that it would appear in the account details when double clicked but as far as I can see there is no way to see it, short of trawling through the chart of accounts line by line to see where it is.

Any help appreciated.

Replies

Please login or register to join the discussion.

31st May 2012 16:24

Chart of Accounts is the only place to find it

That's Sage for you!

Thanks (0)
avatar
01st Jun 2012 11:26

is this what you mean?

if you want to know where your RENT end  up in the p+l as printed..

 

nominals are 'ranged' and categorised

so adding a new n/l account needs to be within certain bands to be meaningful - if using sage reports

so:

start on COMPANY down the left [ am using v 15!]

then select COA on the ribbon over the workspace

select EDIT tab[ and from here on be very careful, as having a nom in x2 it will appear x2 on the p+l report !! for example,   always use the CHECK function here to ensure in reasonable order ]

have fun it is pretty much customisable except the sage CATEGORY

 

[sorry for shouting!]

Thanks (0)
avatar
02nd Jun 2012 22:58

Re: Trace accounts in Chart after set up?

As kiwilondon99 quite rightly says the accounts (as you call them), or Nominals, are 'ranged' and categorised ' in the COA

The easy way to understand these is by going to Company, COA then click Edit then click Print at the bottom of the COA box

This will print out the details of the Catagories and explain the From and To Nominal codes contained within in each one. The grouping of Nominal codes as they appear of the P & L and Balance Sheet is totally logical. 0010 to 3999 are Balance Sheet and 4000 to 9999 are P & L

I would suggest you try to familiarise yourself with these Catagories. As kiwilondon99 also says it is extreamly important that any new ones you choose to add are in the right group and within the from/to codes given. Any outside these groups will generate a warning pop up and require you to amend the COA to accomodate them

Thanks (0)
avatar
05th Jun 2012 12:57

Thanks everyone

I do know how the CofA works; I just find it so frustrating that simple information, such as where the grouping breaks are or which group an individual account is in, is unavailable without jumping through hoops.

Another rant!

In Line 200 one can R mouse in any screen and one option is 'send to Excel'.  To do this in L50 it appears that this can only be done via File/Office integration/ send to Excel (or similar; I am not on my work PC).  The problem is that if the output is full screen it covers the menu bar so one has to switch it to window mode to get at the menu!  I know L200 is SQL and wasn't an original Sage product but for goodness sake, don't they talk to each other there?

Thanks (0)
avatar
05th Jun 2012 20:10

USE THE Nominal ANALYSER

Hi Richard 

I hope this helps. Sorry if I have misunderstood your question.   I believe Sage has had the ability to do this for a long time. Going back to Version 9 not 2009 which is a much later .  

You can do what you are looking for without going into the COA I have attached pictures and instructions for you .  This is available on most versions. My pictures may be appearing big so you may need to scroll bar 

 

1 Go to you Nominal Ledger Module and to the screen where you have all your nominal codes listed. 

 

 

2 Where it says on the second line CHART OF ACCOUNTS use your drop box to choose which layout you want as you may have a few setup as I do . Remember you may have another plus the default set of accounts.  

 DISPLAY pick the period you want  .   You do not need to change this if you do not want to.  Only if you what to see a period in question. 

Go across to the far right and and were you see LAYOUT  instead of List pick  ANALYSER in the drop box.

 

As you will see you now have  headings with + these all have drill down functions and all the subheadings and codes you are looking for .  See below for example. 

 

 

 

If you press the Expand All button below you can see all the codes automatically see picture below 

 

 

Richard it is very easy to see were groups start and stop and what codes are been used for subheadings .   Also you can drill down in the figures for the individual codes and subheadings.  All you you need to do to see the list again is pick list in the drop down box.

You can have a many layouts as you like to suit the business.  

 

In relation to your question about excel you can export to excel using the preview button in the reports with out having to use the sage integration.  In the new version of sage you will be able to send every screen directly to excel.

 

Kind Regards Sarah Douglas.   Douglas Accountancy and Bookkeeping Services. Bearsden, Glasgow 

 

Thanks (0)
avatar
05th Jun 2012 19:56

PLEASE accounting web

Hi 

Would it be possible for accounting web to add this to sage discussion group as it is very good question and would be useful in the group discussion. 

Thanks Sarah 

Thanks (0)
avatar
06th Jun 2012 09:26

Sarah D

The question was rubbish; the answers were brilliant!

Thanks (0)
avatar
By Vidpark
06th Jun 2012 10:49

Sage 200 is an original Sage product

Just a minor point - Sage 200 is a Sage product from the ground up. They wrote it to replace Line 100 which was "bought in".

Thanks (0)
avatar
06th Jun 2012 19:33

Vidpark

In that case they should be even more ashamed of themselves as they missed so many opportunities to get it right.

Just as a 'for instance', in an SQL product it is possible to enable the scrollover addition feature, as in Excel, where the aggregate of a highlighted list is displayed at the bottom of the screen.  Is it there (in 200)?  Nope!

Thanks (0)
avatar
By Vidpark
07th Jun 2012 14:03

Sage can speak for themselves but

Richard Willis wrote:

In that case they should be even more ashamed of themselves as they missed so many opportunities to get it right.

Just as a 'for instance', in an SQL product it is possible to enable the scrollover addition feature, as in Excel, where the aggregate of a highlighted list is displayed at the bottom of the screen.  Is it there (in 200)?  Nope!

Sounds like a very useful feature and, as you say, a missed opportunity if it is not there.

Not quite so sure that this kind of thng comes automatically in an accounting app just becase it happen to be storing the data in a SQL database though....

 

Thanks (0)
avatar
07th Jun 2012 22:10

Vidpark

[Not quite so sure that this kind of thng comes automatically in an accounting app just becase it happen to be storing the data in a SQL database though....

 

[/quote]

No, it isn't automatically included; it takes someone with the vision and knowledge to program it in!

Thanks (0)
avatar
21st Aug 2013 16:59

How can I create sage 50 CoA which contains: nominal account,dept,customer,geography?

any practical experience for architecural companies would be really appreciated

thanking You in advance

 

Wallce

Thanks (0)