SageForum for UK versions of Sage 50- Help and support.

I'm new to this forum & pretty new to Sage.
I've been tasked with improving the management reports we produce in Sage & our MD is keen to implement department reporting.

We're using Sage 50 Accounts Professional 2013 19.01.11.285.
I know there is a function within Sage to report by department but I find this very basic & not very user friendly.
It doesn't allow drill down into the cost categories, as with the main P&L.
Also, I would ideally like to export to Excel all of the departments without having to run it for every department separately.
Even when I do export to Excel it's not overly user friendly as it merges cells etc.

Is there a good add on I could get? Or can I develop the reports within Sage?
Any help would be greatly appreciated.

Thanks in advance.

I have written some spreadsheets that create side by side department columns on a P&L. I am not sure how up to date it is, contact me using the link below and let me know what version of Sage and Excel you are using and I will see what I can do for you.