The Spreadsheet server (SSS) from Key Concepts Consulting helps Financial Managers / CFOs in producing Financial Analysis and General Ledger (GL) reports in Microsoft Excel, save time in preparing financial reports and significantly reduce financial reporting time and manual errors by automating Excel with 'live' data from the GL.
Spreadsheet Server is an Excel plug-in, which automatically brings dynamic data from the General Ledger directly into Excel spreadsheets. Summary balances and detail drill down can be retrieved and manipulated within the desktop tool everyone is familiar with, Excel.
Easier compliance with International Financial Reporting Standards (IFRS):
The highly volatile nature of financial reporting creates a need for dynamic information. Leveraging spreadsheet functionality with Global’s technology, the integrity of critical GL financial data is maintained. Compliance with International Financial Reporting Standards (IFRS) is that much easier working with live data within familiar Excel.
Spreadsheet Server is simply intuitive to install and use. No server-side installation means no IT support is required to change standard views. (Excel plug-in is installed and mapped to the GL that is ready to use within 30 minutes.) Its direct Excel to Database connection means no complicated IT Data Warehousing, or any ‘Screen Scraping’ technology
Excel based reporting tool can be used with ERP systems including: BPCS, SAP, MOVEX, JD EDWARDS, Oracle, PEOPLESOFT, LAWSON, INFINIUM, SAGE, Infor ERP SYTELINE, Infor ERP XA, Infor ERP A+ , IBM AS/400 / iSeries systems.
Excel plug-in also compliments the BI tools including Cognos, Business Objects and Hyperion. Over 80% of the 3,000+ clients in 39 countries use BI tool in conjunction with Spreadsheet Server Excel automation. Automating GL data in Excel improves the speed and accuracy of monthly financial reporting.
Baxter, Financial Controller of FASCO Australia has provided a testimonial on the benefits of Key Concepts Consulting’s spreadsheet server (SSS). FASCO Australia have used the spreadsheet server to create many management reports, ledger balancing reports and reconciliations using the simple formulas that draw the data from their Legacy system (BPCS) into excel.
They found that the BPCS had a cumbersome report writing tool and data could not be drawn without query writing from the green screen. FASCO Australia have found that using SSS provided the ability to vary reports as required, year on year, to copy, share and quickly drill down to data using SSS driven excel formulas. Access to QTD, MTD or YTD data by changing 1 cell was also possible. In their opinion, SSS does not require extensive query knowledge and training to run reports. It offers the flexibility of using excel to customise reports.