Excel Reporting

eg Subtotals so that you can show Gross Profit, Operating Profit, EBIT, Net Profit etc Text lines to put spacing in the report At the moment you have manually add a total in the Pivot Table settings for Net Profit etc ...

Can you create a system so we can organise the excel reports - we currently have a long list of reports and it can be hard to find the one you want. A folder system would be useful.

A report in excel that produces a one line summary of budget vs actuals for a specified month and YTD. The report should include totals and full department names to make it as useful as possible. As a school the majority of our internal management...

Budget for the Year & Forecast for the year are key values for financial analysis, these are not currently available in the Pivot Table Field list

client would like to add the user field to excel reporting report cashbook transactions but not on the list of fields available in the pivot table tools analyse section

Some clients, with years + years worth of data, and as such, the functionality to amend the pivot tables, create new graphs etc.. and re upload into Sage to be used next month is not available as the file size is too big. The function to amend and...

Logging on behalf of a customer who cannot access Ideas Hub. The Nominal Outturn and Nominal Outturn by report category shows committed costs of Purchase Orders received but not yet invoiced, via Excel Reporting. You can drill into this to see the...

We have customers running excel reporting and the order goes group - gross profit - sub group - Sales - sub group - purchase. this is for cost and revenue and we all know P and L goes Sales then purchases. What Sage does is sort this alphabeticall...