I'm new to this forum & pretty new to Sage.
I've been tasked with improving the management reports we produce in Sage & our MD is keen to implement department reporting.
We're using Sage 50 Accounts Professional 2013 19.01.11.285.
I know there is a function within Sage to report by department but I find this very basic & not very user friendly.
It doesn't allow drill down into the cost categories, as with the main P&L.
Also, I would ideally like to export to Excel all of the departments without having to run it for every department separately.
Even when I do export to Excel it's not overly user friendly as it merges cells etc.
Is there a good add on I could get? Or can I develop the reports within Sage?
Any help would be greatly appreciated.
Thanks in advance.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Department Reporting
- brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Department Reporting
I have written some spreadsheets that create side by side department columns on a P&L. I am not sure how up to date it is, contact me using the link below and let me know what version of Sage and Excel you are using and I will see what I can do for you.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Google [Bot] and 5 guests