Untitled Document

Are you currently frustrated with preparing your financial analyses and reports in Microsoft® Excel? Have you been looking for ways to achieve Excel automation?

Spreadsheet Server is a powerful Excel automation tool which brings real-time data from your General Ledger directly into directly into Excel spreadsheets, with drill-down ERP details in AR, AP, etc.. The user has complete control and ultimate flexibility to design their dynamic reports leveraging the familiarity of Excel, as well as its vast features and functions. Summary balances and all levels of detail can be retrieved and manipulated within Excel.

Because of the highly volatile nature of financial reporting in business today, the combination of powerful spreadsheet functions (charting, graphing, text formatting and sorting) and real-time information provides the basis for building accurate and elegant financial reports while maintaining the integrity of critical financial data.

Spreadsheet Server is a great complement to Hyperion Essbase and other analytical tools when finance users need direct access to GL transaction detail.

Spreadsheet Server Key Features


		Eliminate requirement for IT or super-users to create/change financial reports
		Combine reporting, account inquiry, and journal inquiry into one application
		Publish executive-quality reports from your current spreadsheet software
		Perform corporate consolidations with instant access to real-time data
		Leverage spreadsheet skills and write reports within minutes
		No staging areas or data warehousing needed

Real Time Balances
Retrieve real-time period, year-to-date, or life-todate 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, category codes 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
Real-time drill down capabilities allow for review of detailed account balances and journal entry information. Drill-down panels allow full visibility to account information, category codes, and journal entry reference information, plus access to Accounts Receivable, Accounts Payable, Fixed Assets and Inventory subsystems. 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 amount of data that an individual can access. The security, which is controlled by an administrator, is based upon account segment information.

Request brochure and/or web demonstration