Excel Reporting

To have the ability to export and import your Excel financial statement layouts like you can with the main ones. Seems mad that you can't already.

The current VAT Transactions report (Excel) records the VAT on Sales Invoices as a positive amount, rather than as a negative amount and Sales Credits as negatives instead of positives so that the cumulative total differs from the VAT return. Can ...

Report directly from excel to help analyse the data in a more in depth manor and in line with existing processes

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...

I would find the Supplier Transactions report, which can be found in the excel reports, much more useful if a column showing the narrative was included. When processing invoices we leave the default narrative, which includes the supplier code and ...

A client is using the Excel Revenue and Cost report to extract budgets and actuals from Sage 200 for reporting. The actual values are signed flipped, so that the revenue credits are displayed as positives and the cost debits as negatives. Budgets,...

Hi, I have identified an issue with the Nominal Transactions Report in Excel reporting when you pull this off the reports section for us as we have been with Sage just over 2 years so on this report it shows Current Year, Last Year 2 Year but when...

We have rolled out "My Budget Overview" access to our managers for keeping more up to date view on budget spend than monthly management accounts allow. However it would be useful if the figures in actual/committed POs/etc columns were able to be d...

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 ...