x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 56 subscribers
  • Views 525 views
  • Users 0 members are here
Browse Forums
Announcements
764
topics
17
replies
Financial year end
78
topics
179
replies
General Discussion UK
7k
topics
19k
replies
General Discussion Ireland
176
topics
312
replies
Install your software
139
topics
378
replies
Making Tax Digital
286
topics
692
replies
Manage your VAT
152
topics
324
replies
Protect and repair your data
45
topics
138
replies
Run your accounts remotely
86
topics
198
replies
Working with the bank
116
topics
294
replies
nerley

Amending Chart of Accounts Categories

SOLVED
Posted By

Hi all,

I am creating a new chart of accounts to match the P&L to the financial documents produced by our auditors.  

In the Detailed P&L they have multiple Main expense categories (Employment Costs, General Admin Costs, Establishment Costs etc).  Within those categories are the sub-categories and within those the nominal codes.

In Sage I only have 5 Main P&L categories - Sales, Purchases, Direct Expenses, Overhead, Taxation.   I can edit the description of these for example changing Overhead to General Admin Costs and then create and assign the relevant sub-categories and nom. codes. 

However, I need more Main Categories in order to replicate the P&L of the auditors.  Is it possible to add more of these? 

Many thanks

Paul

  • +1
    verified answer

    Unfortunately it is not possible to add additional categories but certainly worth logging it as an idea here www.sagecity.com/.../sage-50-accounts-and-sage-50cloud-accounts-ideas

  • 0

    Having inherited a system with nominal codes all over the place (plus previously having been a professional Pick programmer), to solve such a problem for our MA (as Sage can't handle split ranges in the CoA) I've re-created the P&L and BS (as required) in a spreadsheet1 using a transaction report exported from Sage (with a bit of macro processing to handle the funds as we're a charity).

    My basic methodology is take the transactions since [the date of] the last year end [P&L cleardown] and assign each nominal code a code depending upon where in the CoA it's required, then use lots of "=ROUND(SUMIFS(table[amount],table[CoA Code],<Whatever>),2)" formulae1 to create the required P&L - it doesn't care about split ranges as each nominal code is assigned a CoA code (via a "=VLOOKUP(table[nom code],list_of_noms,2,FALSE)" formula, where list_of_noms is a two column list with column 1 the list of nominal codes and column 2 the area of the CoA to which that nominal code belongs) which hen assigns the CoA code to each transaction for summing.  Word of warning, when using excel, make sure it's the only spreadsheet in the instance of excel, otherwise excel will recalculate the formulae in all the spreadsheets open in that instance of excel, regardless of the fact of whether there is any linking or not.   (For the BS it's slightly different as I store the balances on the nominal codes as at [the date of] the last year end [P&L cleardown].)

    1I find it much easier and quicker to take the raw data from a report and manipulate it in a spreadsheet than go bald trying to work out how to get the report designer to do it.

    2I automatically include the ROUND(...,2) as excel uses weird FP processing which results in ridiculous 0.0000000000001s, etc, which I don't meet elsewhere.

  • 0 in reply to Robert N

    Thanks Robert, that's really helpful. 

    Thats similar to how I've been doing things so far to be honest, I was just hoping there would be a way I could quickly run the report in a few seconds rather than exporting into a file, adding to a master spreadsheet etc.  

    However as you say, it sounds like continuing in excel will be the easiest solution.

    Paul

*Community Hub is the new name for Sage City