SunSystems Consolidation Tools

1
SunSystems Consolidation Tools
Sapphire Systems plc

• User Day 16th November 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
• Corporate Allocations
• Automated non SunSystems specific solution e.g.
  Hyperion
• Automated SunSystems specific software solution
  e.g. SunSystems Consolidations

4
Different Approaches

• Spreadsheets
• Reports accessing different entities
• Data transfer entity 1 to entity 2
• Corporate Allocations
• Automated non SunSystems specific solution e.g.
  Hyperion
• Automated SunSystems specific software solution
  e.g. SunSystems Consolidations

5
Consolidations

• Options
• Single Database
• Soft Consolidations
• Hard Consolidations
• Hybrid
• Consolidations Tool (outside Sun)

SunSystems Database
6
Soft Consolidation
7
Hard Consolidation
Consolidation Database
8
Hybrid Consolidation
Consolidation Database
Single Business Unit UK Only
9
Corporate Allocations Building Blocks
Source
Target
Set-up
Ratio

• Data held within Memo Accounts

10
Corporate Allocations
Source
Target
ABC Co
CON
Ratio
11
11
Corporate Allocations
Source
Target
ABC Co
CON
Ratio
11
12
Consolidations Building Blocks
Groups

• manage the consolidation process
• perform Rules in a defined sequence

• define the consolidation procedure, i.e. performs
  the Steps in a defined sequence
• may consist of many Steps

Rules

• define the data for selection from the source
  database
• define any details that are to be eliminated
• define the target database
• contained within Rules

Steps
Source
Target
Eliminations
13
Consolidations

• Multi layer sequential consolidation of all
  entity types catering for
• wholly owned subsidiaries
• partially owned subsidiaries
• joint ventures
• partnerships
• Sophisticated corporate tree structure
• Caters for different chart of accounts

14
Consolidation Module

• Eliminations (e.g. Inter-company, assets)
• Non contiguous range selections
• Full audit control
• Automatic roll back on error
• Scheduling capability

15
Tree Structure
16
Source Journal Type
17
Source Analysis Code
18
Source - Currency
19
Source Multi Server
20
Target - Mapping
21
Target Account Mapping
22
Target Mapping Report
23
Eliminations - Exclusions
24
Report - Selections
25
Report Missing References
26
Consolidation Options
27
Comparison
28
Comparison
29
Comparison