Transcript www.fesacloud.com

FESA Consol
for Internal Management
& Statutory Compliance
www.fesaconsol.com/consol.pdf
www.fesaconsol.com/consol.pptx
Last update: 6-Mar-2014
Agenda
Stage 3:
Demonstration
& Further
Requirement
Study
Stage 1:
Introduction &
Requirement
Study
Stage 2:
Drafting &
Evaluation of
Suggested
Solution
Stage 5:
Implementation
Stage 4:
Finalization
of Solution
Offered
Supports Flexible Consolidation of Historical & Prospective Data
Overseas
Listed
PRC
Taiwan
Property
Development
Property
Investment
Property
Investment
Manufacturing
Manufacturing
HK Listed
Property
Development
Property
Investment
Manufacturing
Macau
Hospitality
Others
Treasury
Analyzing in Different Dimensions (Single Level & Multi-Level)
Hong Kong
Property
Development
Property
Investment
Manufacturing
Hospitability
Treasury
Taiwan
PRC
Macau
Others
Analyzing in Different Dimensions (Single Level & Multi-Level)
Hong Kong
Property
Development
Property
Investment
Manufacturing
Hospitability
Treasury
Taiwan
PRC
Macau
Others
Analyzing in Different Dimensions (Single Level & Multi-Level)
Hong Kong
Property
Development
Property
Investment
Manufacturing
Hospitability
Treasury
Taiwan
PRC
Macau
Others
Analyzing in Different Dimensions (Single Level & Multi-Level)
Hong Kong
Property
Development
Property
Investment
Manufacturing
Hospitability
Treasury
Taiwan
PRC
Macau
Others
Analyzing in Different Dimensions (Single Level & Multi-Level)
Hong Kong
Property
Development
Property
Investment
Manufacturing
Hospitability
Treasury
Taiwan
PRC
Macau
Others
Analyzing in Different Dimensions (Single Level & Multi-Level)
Hong Kong
Property
Development
Property
Investment
Manufacturing
Hospitability
Treasury
Taiwan
PRC
Macau
Others
From User Requirements to Best Fit Solutions
Your Reporting Issues
Our Reporting Solutions
Our Reporting Framework
Budgeting &
Standardization
Rolling Forecast
Analytical
Tagging
Performance
Management
Collection
Reporting
FESA Query
FESA Analyst
Financial
Management
Group
Consolidation
Transformation
Storage
FESA Planning
FESA Consol
Financial
Management
Your Recording
Issues
AVESTA
Management
OurFinancial
Recording
Framework
Finance
Computing
Our Recording Solutions
FESA
Solutions
AVESTA Aims At Achieving Advanced Accounting Automation At Anywhere
Solving AVESTA Computing Issues in 3 Different Phases
AVESTA Aims at Achieving Advanced Accounting Automation at Anywhere on Phase by Phase Basis
Recording
Issues
Versioning
Phase 1
AVESTA
Standardization
Tagging
Phase 2
AVESTA
Alert
Phase 3
AVESTA
Elimination
Aggregation
Budgeting &
Rolling Forecast
A ggregation
Recording
Reporting
Issues
V ersioning
Financial Management &
Group Consolidation
E limination
Analytical
Performance
Management
S tandardization
Recording to Reporting
T agging
A lert
Reporting
Finance Computing Framework
User Interface
Processing Rules
Data
Sources
Master Settings
Query Formulas
Outputs
Collection
Reporting
Transformation
Storage
System Control
Collection
Transformation
Storage
Rule Processor
System Control
Reporting
Query Processor
FESA Application Server
Recording
Recording to Reporting
Reporting
FESA Empowers Our Enterprise Solutions in 6 Different Aspects
FESA
Data
What
Process
How
Network
Where
User
Who
Time
When
Rationality
Why
FESA Consolidation Comprises 6 Software Modules
FESA
Control
Collection
Transform
Storage
Reporting
FESA Supports Each Software Module in 6 Different Aspects
FESA
Control
Collection
Transform
Storage
Reporting
Data
What
What
What
What
What
Process
How
How
How
How
How
Network
Where
Where
Where
Where
Where
User
Who
Who
Who
Who
Who
Time
When
When
When
When
When
Rationality
Why
Why
Why
Why
Why
Configures Each Module to Resolve AVESTA Computing Issues
AVESTA
FESA
Control
Collection
Transform
Storage
Reporting
Aggregation
Configuration
Configuration
Configuration
Configuration
Configuration
Configuration
Versioning
Configuration
Configuration
Configuration
Configuration
Configuration
Configuration
Elimination
Configuration
Configuration
Configuration
Configuration
Configuration
Configuration
Standardize
Configuration
Configuration
Configuration
Configuration
Configuration
Configuration
Tagging
Configuration
Configuration
Configuration
Configuration
Configuration
Configuration
Alert
Configuration
Configuration
Configuration
Configuration
Configuration
Configuration
FESA Supports Web & Windows Login Client
FESA Supports Optimization of Scalable Implementation
Data Collection – With or Without External System Integration
Extract data from
external system
directly
Upload multiple
Excel Workbooks
A Quick Review of Your Group
1. Differing Transaction & Reporting Currencies
2. Differing Account Codes & Other Dimensional Codes
3. Differing Accounting Policies & Practices
4. Differing Allocation/Amortization Policies & Practices
5. Differing Year End Dates
AVESTA
Standardize
A Quick Review of Your Group
1. Differing Transaction & Reporting Currencies
2. Differing Account Codes & Other Dimensional Codes
3. Differing Accounting Policies & Practices
4. Differing Allocation/Amortization Policies & Practices
5. Differing Year End Dates
6. Inter-Co/BU & Related Party Transactions
7. Changing Legal & Management Group Structure
8. Analyzing Group Performance in Different Dimensions
A Quick Review of Your Group
• Group Mgn’t Accounts
• Group Cash Flow
• Consolidated Financial
Statements /w notes
• Group Stock Control
• IFRS, Statutory Audit
• Group Credit Control
• Listing Rules
• Group Risk Management
• Results Announcement
• Group Budget, Forecast
• Interim / Annual Report
Internal
Management
Statutory
Compliance
Finance Computing Framework
User Interface
Processing Rules
Data
Sources
Master Settings
Query Formulas
Outputs
Collection
Reporting
Transformation
Storage
System Control
Collection
Transformation
Storage
Rule Processor
System Control
Reporting
Query Processor
FESA Application Server
Recording
Recording to Reporting
Reporting
Data Collection
Supports Different Types of Data Collection Methods
Processing
Rules
Existing
Database
Query
Formulas
SQL
User-defined
Data Entry Forms
Web
Windows
Existing
Data File
Processing
Rules
Single Sheet
External
NoSQL
Mobile
Excel
Multi-sheet
Internal
Data
Data
Storage
Collecting Transaction Detail and/or Aggregated Information
Storage
Collecting Structured Data and/or Unstructured Data
Supports Different Types of Data Sources
Data Collection: Support “Green” Excel Workbook
No Macro and No VBA are Required to Insert into Your Excel
Workbooks Customized for Data Collection, Includes
 “Transaction Like” or “Row” Form:
 “Pivot Table Like” or “Column” Form:
AVESTA
Tagging
Automation of reversal of Pivot Table
Data Transformation: Supports User-defined Elimination Rules
 Elimination Amongst
Different Business Units
 Elimination Amongst
Different Legal Entities
 Elimination Amongst
Different Geographical
Regions
Data Transformation
Measurement
System Control of Recording to Reporting
Full Consolidation
Basic
Proportional Consolidation
Assumptions
Amortization
Revaluation
Allocation
Translation
Value Type
Reversal
Year-end Date
Disposal
Top/Sub
Consol
Multi-version
Multi-scenario
Other Tagging
Re-measurement
Assumptions
Equity Accounting
Effective Date of Change
GAAP Adjustments
Basic
Other
Elimination Adjustments
Adjustments
Adjustments
Audit Adjustments
Effective Date of Change
Code Identification
Basic
Tagged
Code Reorganization
Dimensions
Dimensions
Code Standardization
Recognition
Data Transformation: Supports Query Formula for Elimination
AVESTA
Elimination
Business Unit
Other
Business
Retailing
Financial
Services
Hotel
••••••••••••••••••••••••••••••••••
FESA Allocation
Service Department
HR
Finance
Admin
Marketing
IT
Others
Data Transformation: Supports Multi-currency Subgroup
Overseas
Listed
CNY
NTD
PRC
Taiwan
USD
HKD
A Multi-currency Subgroup
HK Listed
EUR
Property
Development
Property
Investment
Property
Investment
Manufacturing
Manufacturing
Property
Development
Property
Investment
Manufacturing
MOP
Macau
Hospitality
Others
Treasury
Data Storage
User Interface
Master Settings
Statutory
Management
Database
Database
Management
Management
System
System
DBMS Model
Supplementary Audit Trial (Excel / pdf / Text Files)
Primary
Compressed
Data
Data
Store
Cube
Data Type
FESA Application Server
Ledger
Heterogeneous
Form
Form
Data Schema
Management DBMS: Supports Data Rewritable Methodology
User can assign Segmental Rewrite Code (RW Code) to their
worksheet so as to rewrite relevant posted data
Ledger Form: Extendable Analysis Dimensions
Business Dimensions
- Income / Expense
- Assets / Liability
- Off/Post-Balance Sheet
- BU / Department
- Project / Product
Budget
Actual
Time Dimensions
- Daily / Weekly
- Monthly / Quarterly
- Yearly
- Month-To-Date
- Year-To-Date
Ledger
Forecast
Other Dimensions
- Version / Scenario
- Internal / External
- Currency / Amount
- Quantity / Statistics
Projection
Location Dimensions
- Branch
- District
- City
- Country
Ledger Form: Configuration of Master Files
Analysis Category
Analysis Code
Ledger Form: Supports Dual Database Posting
User can opt to implement dual ledger posting so as to
support generation of consolidated reports for traditional
reporting tools such as Standard Report and Report Writer
Match Data Source
Return User-defined Value
AVESTA
Tagging
Reporting Tools
User Interface (Windows, Excel and/or Web)
Standard
Enquiry/
Reporting
Collection
Primary Reporting Services
Standard
Query
Transformation
Storage
Reporting
High Performance Reporting Services
FESA Application Server
Query & Extraction Processor
Primary
Data Store
Compressed Data Cube
Traditional Reporting Tool: Standard Report
AVESTA
Aggregation
1 December 2009
Opening Balance
December 2009
Movement
31 December 2009
Closing Balance
AVESTA
Aggregation
AVESTA
Aggregation
FESA Query, An End-user Reporting Tool
AVESTA
Aggregation
Reporting: Consol Income Statement – By Product
AVESTA
Aggregation
Reporting: Consol Trial Balance
AVESTA
Aggregation
Reporting: Consol Trial Balance
AVESTA
Aggregation
Reporting: Drill Down Step by Step
AVESTA
Aggregation
Reporting: Empowers You to Configure Many Analysis Reports
AVESTA
Aggregation
Reporting: Empowers You to Configure Many Analysis Reports
AVESTA
Aggregation
AVESTA
Versioning
AVESTA
Aggregation
Reporting: An Example of Report Package
Hotel Business
Room
F&B
Other Business
Telecom
HR
Finance
Admin
Golf &
Shop
Health
Club
Marketing
Rental
Parking
Garage
Property
Utilities
AVESTA
Aggregation
AVESTA
Aggregation
AVESTA
Aggregation
AVESTA
Aggregation
AVESTA
Aggregation
Reporting
User Interface (Windows, Excel and/or Web)
Document
Designer
Pivot
Chart
Pivot
Query
Message & Alert
Brick
Query
&
Dashboard
Designer
&
Document
Viewer
Standard
Enquiry/
Reporting
Collection
Primary Reporting Services
Ledger Form
Report Writer
Transformation
Standard
Query
Storage
Scheduled
Query
Reporting
High Performance Reporting Services
FESA Application Server
Query & Extraction Processor
Primary
Data Store
Compressed Data Cube
Dashboard
Viewer
Reporting: Drill Down by Pivot View
AVESTA
Aggregation
Reporting: Query Formula Can Create Pivot Table
AVESTA
Aggregation
Reporting: Query Formula Can Create Pivot Table
AVESTA
Aggregation
Reporting: Dashboard Designer
AVESTA
Aggregation
Dashboard Viewer
AVESTA
Aggregation
Our Latest Innovation
FionBrick
AVESTA
Introduction
www.fesaconsol.com/fionbrick.pdf
Demo Video
www.fesaconsol.com/fionbrick.mp4
Aggregation
FionBrick
AVESTA
Aggregation
FESA RW Supports You to Define New Reports within Excel
To define report body
AVESTA
To define report header
Aggregation
FESA RW Supports You to Run New Reports within Excel
AVESTA
Aggregation
Traditional Reporting Tool: Report Writer
AVESTA
Aggregation
Report Writer Supports You to Define New Reports
AVESTA
Aggregation
System Control
System Administration
General
Data
Data
Data
Access
Collection
Encryption
Integrity
Control
Control
Control
Control
Data
Report
Data
Data
Authorization
Management
Transform
Posting
Control
Control
Control
Control
Period
Scheduled
Audit
Processing
Trial
Alert
Version
Control
Control
Closing
Control
User
Data
Period
Event
Log
Control
Control
Control
Control
Control
System Control
FESA Application Server
System Control: Supports You to Configure User Control
System Control: Data Posting Control
System Control: Data Posting/Period Control
System Control: Supports You to Configure Advanced User Control
System Control: Workflow Scenario 1
User D
User A
2. Posting
1. Data File Upload
Void
Pending
Completed
Restored
System Control: Workflow Scenario 2
User A
1. Data File Upload
User B
2. Validation Only
User C
3. Save as Batch
User D
4. Posting
Void
Pending
Validated
Completed
Validated
Void
Void
Restored
System Control: Provides Comprehensive Log Control
Provide comprehensive enquiry function for administrator or
auditor to monitor and audit data processing activities
Download button
AVESTA
Download button
Versioning
System Control: Report Manager
AVESTA
Versioning
From User Requirements to Best Fit Solutions
AVESTA
Aggregation
Versioning
Elimination
Standardize
Tagging
Alert
FESA
Control
Collection
Transform
Storage
Reporting
Benefits of FESA Consol
Better Strategic Management
Provides you with deep insight of historical, current or futures data from multiple
systems so as to support you with the management of a group of companies /
business units more effectively.
Optimized Operating Efficiency
Supports advanced automation to avoid heavy manual intervention of data resulting
in the shortening of lead times from period closing and account reconciliation to
report generation.
Improved Internal Control
Supports the configuration of segregation of duties and approval workflows over the
consolidation processes.
Ensured Statutory Compliance
Supports rule based configuration so that you can implement new accounting
practices to comply with new or amended statutory requirements.
Adapted Dynamic Change
Provides a business mapping engine so as to empower you to adapt to a rapidly
changing business practices and environments.