Live Reporting Data from your ERP into Excel
We understand accessing up to the minute data beyond the General Ledger within Excel is critical to your daily operations. With Spreadsheet Server, you have the power to build financial and operational reports with drill-down capability right in Excel from your ERP. Spreadsheet Server eliminates the re-keying or downloading of data into the spreadsheet and makes the spreadsheet an integral part your business environment.
Pre-configured Microsoft Excel Add-in for financial and operational reporting across ERP platforms
While maintaining the functionality of their Excel spreadsheet application, Spreadsheet Server allow the user to mix GL and Non-GL data from multiple platforms into a single worksheet. The combination live information from your ERP platform and powerful spreadsheet functions (charting, text formatting and sorting) provides the basics for building accurate, elegant income statements, balance sheets, and other critical statements.
The Spreadsheet Server application consists of four components:
Pre–Configured Microsoft® Excel Add-In for Reporting across ERP platforms - Spreadsheet Server formulas used in Microsoft Excel allow users to create reports using familiar business and accounting terms, not technical specifications.
QueryExchange™ - An online repository of queries from which the user may download selected queries to the QueryDesigner and then utilize them in Excel. The SmartPak™ feature, utilized in the QueryExchange™, is a method to group pre–configured queries together
QueryDesigner - A user friendly tool which enables users to design and maintain designer queries over any relational database. These queries can be combined with pre–configured formulas in a single Excel spreadsheet.
Distribution Manager - Eliminating the time-consuming tasks of printing, copying, or creating email attachments just to get information to your end-users, this tool automates the scheduling of report distribution from directly within Excel.
Some Modules supported by Spreadsheet Server:
- Financial Accounting
- Sales and Distribution
- Human Resources
- Plant Maintenance
- General Ledger
- Quality Management
- Purchase Orders
ERP Systems Supported
- Mitchell Humphrey
Spreadsheet Server is used by 4500+ customers all over the world...