I am hoping someone can help me with Sage profit and loss reports. My MD wants a nominal activity report of the information in the P&L for each month, but I can only find activity for each nominal, which produces reams of paper which she doesn't want.
Is this the sort of thing you had in mind? You probably had paper reports in mind but I'm trying to develop an Excel alternative.
Each month is shown as a column, and the P&L detail can be broken down to nominal, supplier/customer or transaction level as required.
The full example extract is available from the link below if you'd like to look more closely at the approach (no macros - just a standard workbook and standard formulae):
Hi, I know this is some time later but I was looking for the same report and, after abit of searching through Sage nominal reports, I came across Nominal Ledger Departmental Analysis, which allows you to choose a date range and produces the balances against each nominal ledger. This can be printed off to supplement the P&L report for the same period :)
if you only want certain nominal codes and they arent close together in range just highlight the ones needed then run nominal activity-it will only include the ones highlighted
Note: you will need to enable macros and external data refresh, it has only been tested on the 32 bit desktop versions of office
-- Edited by BruceDenney on Tuesday 4th of February 2014 10:22:13 AM
__________________
For just about anything Sage :- switch to renting, pay-as-you-go sage support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me.
