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
