Spreadsheet Server is a new add-on product developed for the MXP environment by our partner Global Software.  Most of the information below is taken directly from their website, which you can access at www.glbsoft.com.

Spreadsheet Server is an innovative Microsoft® Excel add-in that allows users to access 'live' data within Excel, while maintaining the full ability to drill down to supporting details. Spreadsheet Server enables users to leverage the familiarity of Microsoft Excel as a reporting and analysis tool while providing up-to-the-minute dynamic data. The key is to keep it simple. Spreadsheet Server is the tool of choice because of its ease of use. Users of Spreadsheet Server can simply open a spreadsheet and watch the balances of their spreadsheet populate with dynamic financial balances. The unique drill down capability takes the tool to a new level of detail by allowing individual transactions to be monitored.

The highly volatile nature of financial reporting creates a need for dynamic information. Leveraging spreadsheet functionality with Global’s technology, the integrity of critical MXP financial data is maintained. Spreadsheet Server for use with Foresight's MXP is also intuitive to install and maintain. No server-side deployment means no day-to-day IT support is required.

Dynamic Balances

Retrieve dynamic period, year-to-date, life-to-date and quarter balances using simple Excel formulas. Formula wizard is available to assist users in creating new formula expressions. Segment descriptions can also be retrieved for single accounts.

Account Combinations

Use wild cards, ranges, or segment lists to retrieve any combination of accounts into a single spreadsheet row. Segment Lists are user defined combinations of segments that are set at the local level or can be shared among multiple users.

Drill Down Capabilities

Dynamic drill down capabilities allow for review of detailed account balances and journal entry information. Capabilities also include configurable drill-down to additional detail, including financial and non-financial data. Combine your financial reporting with account analysis to achieve more efficient analysis of your key data.

 

Security Features

Security can be configured by user to restrict the areas of data that an individual can access. The security, which is controlled by an administrator, is based upon account segment information.

Distribution Manager

Automate the distribution process of your financial statements by using Distribution Manager within Spreadsheet Server. Configure multiple report packages that supply parameters, calculate, and then print or email your reports, all with the click of a button.

Spreadsheet Server for MXP is sold and supported directly by Foresight Software.  For more information about this, or any of our products, please contact us using the links to the left.