Any way to run departmental P&Ls in bulk which are not combined together into one P&L?

SOLVED

Any idea how I'd be able to run multiple p&l reports at once or even just speed up the process, because at the moment if you were to run a p&l for 2 departments, sage would automatically just combine them together into one report.

What I need is for it to show me individual department P&Ls instead of the combined amount, as doing them one by one just for 200 departments is a massive pain and takes ages to do.

Anyone wanna help out?

  • +1
    verified answer

    Go to Departments, then Reports.  Choose Profit & Loss and you should see one that shows P&L per department.  If you are not using budgeting you may want to edit the report to get rid of the budget and variance columns.

    For other reports, you might like to look into Batch reporting.  This lets you run several reports at once, using only one set of criteria. If you want to run the same report for two (or more) departments, you could edit the report and set a filter to pre-set the department and save each with a different name so you can then combine them into the batch report.

  • 0 in reply to Anita Harper

    Wow... Well i'm blind, could've sworn I've run every report just to see if one does it... Thanks