subject: The Analyser - Sage and Excel Add-in for Management Accounts by Trax UK Ltd www.traxuk.com [print this page] The Analyser - Sage and Excel Add-in for Management Accounts by Trax UK Ltd www.traxuk.com
"The Analyser" Sage and Excel add-in transforming management reporting
We've come a long way from listing our accounts manually, using our fingers and toes for adding, a blackboard for presentation and a pigeon for sending. We now have accounting software to help us, yet still, a recurring issue for many companies is the inability for that software, to produce accurate, timely and meaningful management information, presented in a format that they require.
Yes, they have Sage 50 or Sage 200, but are they taking advantage of its full potential? Would they benefit from being able to use the versatility of Excel to produce and recalculate management accounts directly from their Sage data, without having to re-key it first? Excel has been an important development in IT for accountants and financial managers, enabling a clearer vision and analysis of data. Yet still, too few professionals fully understand Excels capabilities.
Enter "The Analyser" - a Sage and Excel add-in developed by Trax UK and transforming the way management reports are created.
Trax are a SAGE accredited partner, whose vision was to fill the void between IT and Accounting whilst developing solutions to suit the client's individual needs. The Analyser was born out of the constraints other report writers place upon the user. It is an impressive yet simple, timesaving Reporting Tool that extracts the figures directly from the Sage data into Excel. "If you use Sage then you must have The Analyser", said Kevin Salter (BBS Computing Ltd) of the software, naming it "product of the month if not for the year" on his Accountants PowerTools website.
The Analyser functions can be added to any existing management reporting templates or alternatively new spreadsheets can be created. In-depth training is not essential; if you can use Excel then you can use "The Analyser". Within minutes you will be able to calculate and analyse reports, with the minimum of effort.
At the click of a button, "The Analyser" extracts actual current and budget data from nominal codes, departments and funds for any date range and for any combination of nominal ranges. Additional benefits include the option to add prior year's data alongside the current year for comparative purposes and to report on single or multiple Sage companies, all in one workbook. Furthermore from the face of the Excel values can be drilled down to show the under-lying transactions, without the need to even open the Sage application.
Existing users are now able to report upon their own business characteristics, in a manner not previously possible. An example highlighting this unique capability, is a company in the leisure industry, which can now monitor their financial data by seasonal holidays, alongside their traditional monthly reporting, over a rolling five-year period. With this comprehensive information, effective and efficient decision-making, planning and control can be achieved and built upon.
"The Analyser" has already drawn high praise from national and international accounting professionals, KK Tang of the Institute of Business Analytics Pte Ltd commented that he was "very impressed with [The Analyser] and I am sure it would be of great help to all Sage users". Trax clients have been instantly impressed with its capabilities and wonder how they ever "analysed" data without it!
