SunSystems Consolidation Tools

1
SunSystems Consolidation Tools
Sapphire Systems plc

• Prepared for User Day 11th May 2006

2
Challenges for Consolidations Process

• Sequence of Consolidations
• Mapping of Accounts etc
• Incremental Updates
• Training
• Flexibility
• Ongoing Maintenance
• Excluded Transactions
• Balance flow thru txns
• Choice of summary or detailed transactions

• Reference Data Consolidation
• Summary Information
• Speed
• Level of Automation
• Limited Reliance on Macros
• Rollback Error Checking
• Multi server environment
• Visual presentation
• Non contiguous ranges of data

3
Different Approaches

• Spreadsheets
• Reports accessing different entities
• Data transfer entity 1 to entity 2
• Automated non SunSystems specific solution -
  Hyperion
• Automated SunSystems specific software solution

4
Consolidations

• Options
• Single Database
• Hard Consolidations
• Soft Consolidations
• Hybrid
• Consolidations Module

SunSystems Database
5
Hard Consolidation
Consolidation Database
6
Soft Consolidation
7
Hybrid Consolidation
Consolidation Database
Single Business Unit UK Only
8
Consolidation Module

• Multi layer sequential consolidation of all
  entity types catering for
• wholly owned subsidiaries
• partially owned subsidiaries
• joint ventures
• partnerships
• Sophisticated corporate tree structure
• Totally user definable
• Accounts for elimination of intercompany
  transactions.
• Full audit control
• Automatic roll back
• Caters for different chart of accounts
• Scheduling capability

9
SunSystems Consolidation Module

• Ability to run it at multiple levels
• Speed
• Roll back
• Full Audit
• Eliminations
• Report on excluded transactions
• Lowest cost of ownership
• Non contiguous range selections
• Permit and or SQL statements
• Schedule unattended running

10
(No Transcript)