Hi Justina,

Thanks for using Community Hub.

I believe you spoke to Technical Support yesterday about this, but the following article identifies the various options for P&L reporting: What additional profit and Loss reports are available >

Regards,

Andy
Sage UKI

Hi Justina, 

ProudNumbers Management Accounts for Sage 50  provide departmental P&L spreadsheet reports with a drill down functionality displaying transactions. You can get a free 30 day trial.

Hope this helps.

Pavol

Disclaimer: I'm the author of the software.