Sage 50 UKI Ideas Portal

Second level totalling in the Chart of Accounts allowing for split ranges

Our Sage was set up years ago under a previous finance manager.  Over the years nominals have been slotted in and budgets rearranged that now we have split ranges of nominal codes that ought to be reported together.

As it is neigh impossible to renumber a nominal could it be possible to modify the CoA so that under each area you can define secondary (Sub) areas which on the BS or P&L are totalled into the area, thus allowing split-ranges.  For example, under Profit & Loss:

Sales Sub area Low High                       Generating -->                  Income Period
Shop Sales Food 5000 5049 Shop Sales x
Drink 5100 5149 Bar Sales X
Bar Sales Food 5050 5099 Online Sales x
Drink 5150 5199
Online Sales 5200 5299 Telephone Sales x
Telephone Sales 5300 5399

Possibly an option to either just display the total (as above) or to expand the areas so that all detail is given, eg:

Income Sub area         Period
Shop Sales Food x
Drink x
x
Bar Sales Food x
Drink x
x
Online Sales x
 
Telephone Sales x

(Only ours are much worse than that simple example.)

  • Guest
  • Mar 30 2022