Intergrate to a more flexible GL reporting tool Excel, Crystal and Access are all possible solutions but by far the easiest solution I think would be the following.
I have used a package a lot recently called Greentree (GT) its a full featured system but for this case you only need the nominal ledger component, specific consolidation packages would also do the trick but most of those are quite expensive.
Steps:
Setup the 15,000 nominal ledger codes in GT these can be imported from Excel, you would import the nominal code, description and the groupings you want for the account. You can have as many groupings as you want for each account and they are independant of the COA segments so it dosent matter if the accounts are out of order etc.
Ok thats the base setup of the host system done now once a month you export a Trial balance to GT once again just done via excel.
The final step is the reporting and this is where GT allows you to report in Excel based upon the groupings you have setup rather than the nominal accounts themselves. As you can have unlimted groupings for each nominal code you could have different levels of summary that you could report off or maybe accounts grouped together by division etc even when the segments dont have any logic to them.
End result is that you can create and write reports based on your 15,000 accounts that will group those accounts together in whatever way you wish with a single export once a month.
Ive seen this working with 32,000 accounts at a ODPM organisation, why anyone needs so many accounts is beyond me but it worked.
My answers
Intergrate to a more flexible GL reporting tool
Excel, Crystal and Access are all possible solutions but by far the easiest solution I think would be the following.
I have used a package a lot recently called Greentree (GT) its a full featured system but for this case you only need the nominal ledger component, specific consolidation packages would also do the trick but most of those are quite expensive.
Steps:
Setup the 15,000 nominal ledger codes in GT these can be imported from Excel, you would import the nominal code, description and the groupings you want for the account. You can have as many groupings as you want for each account and they are independant of the COA segments so it dosent matter if the accounts are out of order etc.
Ok thats the base setup of the host system done now once a month you export a Trial balance to GT once again just done via excel.
The final step is the reporting and this is where GT allows you to report in Excel based upon the groupings you have setup rather than the nominal accounts themselves. As you can have unlimted groupings for each nominal code you could have different levels of summary that you could report off or maybe accounts grouped together by division etc even when the segments dont have any logic to them.
End result is that you can create and write reports based on your 15,000 accounts that will group those accounts together in whatever way you wish with a single export once a month.
Ive seen this working with 32,000 accounts at a ODPM organisation, why anyone needs so many accounts is beyond me but it worked.