for internal management & statutory compliance

for Internal Management & Statutory Compliance

FESA Consol

Website: http://www.fesa-s.comEmail: avesta@flexsystem.comLast update: 6-Mar-2014

Stage 1: Introduction & Requirement

Study

Stage 2: Drafting &

Evaluation of Suggested Solution

Stage 3: Demonstration

& Further Requirement

Study

Stage 4: Finalization

of Solution Offered

Stage 5:Implementation

Agenda

Overseas Listed

PRC

Property Developmen

t

Property Investment

Manufacturing

Taiwan

Property Investment

Manufacturing

HK Listed

PropertyDevelopmen

t

Property Investment

Manufacturing

Macau

Hospitality

Others

Treasury

Supports Flexible Consolidation of Historical & Prospective Data

Manufacturing

Hong Kong PRC Taiwan

Hospitability

Treasury

Others

Property Investment

Property Development

Macau

Analyzing in Different Dimensions (Single Level & Multi-Level)

Manufacturing

Hong Kong PRC Taiwan

Hospitability

Treasury

Others

Property Investment

Property Development

Macau

Analyzing in Different Dimensions (Single Level & Multi-Level)

Manufacturing

Hong Kong PRC Taiwan

Hospitability

Treasury

Others

Property Investment

Property Development

Macau

Analyzing in Different Dimensions (Single Level & Multi-Level)

Manufacturing

Hong Kong PRC Taiwan

Hospitability

Treasury

Others

Property Investment

Property Development

Macau

Analyzing in Different Dimensions (Single Level & Multi-Level)

Manufacturing

Hong Kong PRC Taiwan

Hospitability

Treasury

Others

Property Investment

Property Development

Macau

Analyzing in Different Dimensions (Single Level & Multi-Level)

Manufacturing

Hong Kong PRC Taiwan

Hospitability

Treasury

Others

Property Investment

Property Development

Macau

Analyzing in Different Dimensions (Single Level & Multi-Level)

Collection

Storage

ReportingStandardization

Tagging

Financial Management

Financial Management

Analytical Performance Management

Group Consolidation

Budgeting & Rolling

Forecast

Your Reporting Issues

Your Recording Issues Financial Management

Transformation

Our Reporting Framework

Our Recording Framework

Our Reporting Solutions

FESA Query FESA Analyst

FESA Planning FESA Consol

Our Recording Solutions

AVESTA Finance Computing Solutions FESA

AVESTA Aims At Achieving Advanced Accounting Automation At Anywhere

From User Requirements to Best Fit Solutions

Analytical Performance Management

Budgeting & Rolling

Forecast

Phase 3 AVESTA

Phase 2 AVESTA

Aggregation

Recording Issues Versioning Standardizatio

n Tagging

Elimination

Alert Reporting Issues

Phase 1 AVESTA

Financial Management & Group Consolidation

AVESTA Aims at Achieving Advanced Accounting Automation at Anywhere on Phase by Phase Basis

A ggregation V ersioning E limination S tandardization T agging A lert

Solving AVESTA Computing Issues in 3 Different Phases

ReportingRecording to ReportingRecording

FESA Application Server

Data Sources

Collection Transformation

Storage Reporting

Outputs

Processing Rules

ReportingRecording to Reporting

Query Formulas

System Control

Collection

Transformation

Storage

Reporting

Recording

Rule Processor Query Processor

User Interface

System Control

Master Settings

Finance Computing Framework

FESA

Data

Process

Network

User

Time

Rationality

What

How

Where

Who

When

Why

FESA Empowers Our Enterprise Solutions in 6 Different Aspects

Control CollectionFESA ReportingStorageTransform

FESA Consolidation Comprises 6 Software Modules

FESA ReportingStorageTransform

Data

Process

Network

User

Time

Rationality

What

How

Where

Who

When

Why

What

How

Where

Who

When

Why

What

How

Where

Who

When

Why

What

How

Where

Who

When

Why

What

How

Where

Who

When

Why

FESA Supports Each Software Module in 6 Different Aspects

Control Collection

Control Collection

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

FESA ReportingStorageTransform

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuration

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

AVESTA

Aggregation

Versioning

Elimination

Standardize

Tagging

Alert

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configuratio

n

Configures Each Module to Resolve AVESTA Computing Issues

FESA Supports Web & Windows Login Client

FESA Supports Optimization of Scalable Implementation

Extract data from external system directly

Upload multiple Excel Workbooks

Data Collection – With or Without External System Integration

1. Differing Transaction & Reporting Currencies2. Differing Account Codes & Other Dimensional Codes 3. Differing Accounting Policies & Practices4. Differing Allocation/Amortization Policies & Practices5. Differing Year End Dates

A Quick Review of Your Group

Standardize

AVESTA

1. Differing Transaction & Reporting Currencies2. Differing Account Codes & Other Dimensional Codes 3. Differing Accounting Policies & Practices4. Differing Allocation/Amortization Policies & Practices5. Differing Year End Dates

6. Inter-Co/BU & Related Party Transactions7. Changing Legal & Management Group Structure8. Analyzing Group Performance in Different Dimensions

A Quick Review of Your Group

• Group Mgn’t Accounts• Group Cash Flow• Group Stock Control• Group Credit Control• Group Risk Management• Group Budget, Forecast Internal Management

• Consolidated Financial Statements /w notes• IFRS, Statutory Audit• Listing Rules• Results Announcement• Interim / Annual ReportStatutory Compliance

A Quick Review of Your Group

FESA Application Server

Data Sources

Collection Transformation

Storage Reporting

Outputs

Processing Rules

ReportingRecording to Reporting

Query Formulas

System Control

Collection

Transformation

Storage

Reporting

Recording

Rule Processor Query Processor

User Interface

System Control

Master Settings

Finance Computing Framework

Processing Rules

Processing Rules

Windows Single SheetSQL

Supports Different Types of Data Sources

Internal

Data

Storage

External

Data

Storage

NoSQL Multi-sheetExcel

Supports Different Types of Data Collection Methods

Existing Database

User-defined Data Entry Forms

Existing Data File

Collecting Transaction Detail and/or Aggregated Information

Collecting Structured Data and/or Unstructured Data

Web

Mobile

Query Formulas

Data Collection

“Pivot Table Like” or “Column” Form:

No Macro and No VBA are Required to Insert into Your Excel Workbooks Customized for Data Collection, Includes “Transaction Like” or “Row” Form:

Automation of reversal of Pivot Table

Data Collection: Support “Green” Excel Workbook

Tagging

AVESTA

Elimination Amongst Different Business Units

Elimination Amongst Different Legal Entities

Elimination Amongst Different Geographical Regions

Data Transformation: Supports User-defined Elimination Rules

Effective Date of Change

System Control of Recording to Reporting

Basic

DimensionsCode Reorganization

Code Standardization

Top/Sub Consol

Code Identification

Recognition

Multi-scenario

Multi-version

Other Tagging

Tagged

Dimensions

Effective Date of Change

Basic

AdjustmentsElimination Adjustments

Audit Adjustments

Value TypeGAAP Adjustments

Year-end Date

Reversal

Disposal

Other

Adjustments

Basic

AssumptionsProportional Consolidation

Equity Accounting

AmortizationFull Consolidation

Allocation

Revaluation

Translation

Re-measurement

Assumptions

Measurement

Data Transformation

Data Transformation: Supports Query Formula for Elimination

Elimination

AVESTA

Service Department

HR Finance Admin Marketing IT Others

Hotel

Retailing

Financial Services

Other Business

••••••••••••••••••••••••••••••••••

Business Unit

FESA Allocation

Overseas Listed

PRC

Property Development

Property Investment

Manufacturing

Taiwan

Property Investment

Manufacturing

HK ListedPropertyDevelopmen

t

Property InvestmentManufacturing

MacauHospitality

OthersTreasury

CNY NTD HKD

MOP

EUR

USDA Multi-currency Subgroup

Data Transformation: Supports Multi-currency Subgroup

FESA Application Server

User Interface

DBMS Model Data Type Data Schema

Master Settings Supplementary Audit Trial (Excel / pdf / Text Files)

Statutory Database

Management System

ManagementDatabase

ManagementSystem

PrimaryDataStore

CompressedDataCube

LedgerForm

Heterogeneous

Form

Data Storage

User can assign Segmental Rewrite Code (RW Code) to their worksheet so as to rewrite relevant posted data

Management DBMS: Supports Data Rewritable Methodology

Ledger

Budget

Projection

Forecast

Actual

Time Dimensions- Daily / Weekly- Monthly / Quarterly - Yearly - Month-To-Date- Year-To-Date

Business Dimensions- Income / Expense- Assets / Liability- Off/Post-Balance Sheet- BU / Department- Project / Product

Location Dimensions- Branch- District- City- Country

Other Dimensions- Version / Scenario- Internal / External- Currency / Amount- Quantity / Statistics

Ledger Form: Extendable Analysis Dimensions

Analysis Category Analysis Code

Ledger Form: Configuration of Master Files

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

Ledger Form: Supports Dual Database Posting

Tagging

AVESTA

FESA Application Server

Collection Transformation

Storage Reporting

High Performance Reporting Services

User Interface (Windows, Excel and/or Web)

Primary Reporting Services

Standard Enquiry/

ReportingStandard

Query

Reporting Tools

Compressed Data Cube

Primary Data Store

Query & Extraction Processor

Traditional Reporting Tool: Standard Report

Aggregation

AVESTA

1 December 2009Opening Balance

December 2009 Movement

31 December 2009 Closing Balance

Aggregation

AVESTA

Aggregation

AVESTA

FESA Query, An End-user Reporting Tool

Aggregation

AVESTA

Reporting: Consol Income Statement – By Product

Aggregation

AVESTA

Reporting: Consol Trial Balance

Aggregation

AVESTA

Reporting: Consol Trial Balance

Aggregation

AVESTA

Reporting: Drill Down Step by Step

Aggregation

AVESTA

Reporting: Empowers You to Configure Many Analysis Reports

Aggregation

AVESTA

Reporting: Empowers You to Configure Many Analysis Reports

Aggregation

AVESTA

Aggregation

AVESTA

Versioning

AVESTA

Hotel Business

Room F&B Other BusinessTelecom

Golf &

Shop

Health

Club

Parking

Garage

RentalHRFinanceAdminMarketi

ngPropert

yUtilitie

s

Reporting: An Example of Report Package

Aggregation

AVESTA

Aggregation

AVESTA

Aggregation

AVESTA

Aggregation

AVESTA

Aggregation

AVESTA

FESA Application Server

Collection Transformation

Storage Reporting

High Performance Reporting Services

User Interface (Windows, Excel and/or Web)

Primary Reporting Services

Document Designer

&

Document Viewer

Standard Enquiry/

ReportingLedger FormReport Writer

Standard Query

Scheduled Query

Pivot Chart Message & Alert Pivot

QueryBrick Query

DashboardDesigner

&

Dashboard Viewer

Reporting

Compressed Data Cube

Primary Data Store

Query & Extraction Processor

Reporting: Drill Down by Pivot View

Aggregation

AVESTA

Reporting: Query Formula Can Create Pivot Table

Aggregation

AVESTA

Reporting: Query Formula Can Create Pivot Table

Aggregation

AVESTA

Reporting: Dashboard Designer

Aggregation

AVESTA

Dashboard Viewer

Aggregation

AVESTA

Our Latest Innovation

Introductionwww.fesaconsol.com/fionbrick.pdf

Demo Videowww.fesaconsol.com/fionbrick.mp4

FionBrick

Aggregation

AVESTA

FionBrick

Aggregation

AVESTA

To define report header

To define report body

FESA RW Supports You to Define New Reports within Excel

Aggregation

AVESTA

FESA RW Supports You to Run New Reports within Excel

Aggregation

AVESTA

Traditional Reporting Tool: Report Writer

Aggregation

AVESTA

Report Writer Supports You to Define New Reports

Aggregation

AVESTA

System Control

FESA Application Server

User Control

Log Control

EventControl

Period Control

Data Control

Data PostingControl

PeriodClosingControl

System Administration

Data Integrity Control

Data Transform

Control

Data Encryption

Control

General AccessControl

Data Collection

Control

Data Authorization

Control

Report Management

Control

System Control

Audit Trial

Version Control

Scheduled Processing

Alert Control

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

Pending Complete

d

Restored

Status

1. Data File Upload

User A 2. Posting

Void

User D

System Control: Workflow Scenario 1

Pending

Validated

Validated Completed

Restored

Status

1. Data File Upload

User A User B User C 2. Validation Only

3. Save as Batch

4. Posting

Void

Void

Void

User D

System Control: Workflow Scenario 2

Provide comprehensive enquiry function for administrator or auditor to monitor and audit data processing activities

System Control: Provides Comprehensive Log Control

Download button

Download button Versioning

AVESTA

System Control: Report Manager

Versioning

AVESTA

Control CollectionFESA ReportingStorageTransform AVESTA

Aggregation

Versioning

Elimination

Standardize

Tagging

Alert

From User Requirements to Best Fit Solutions

Better Strategic ManagementProvides 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 EfficiencySupports 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 ControlSupports the configuration of segregation of duties and approval workflows over the consolidation processes. Ensured Statutory ComplianceSupports rule based configuration so that you can implement new accounting practices to comply with new or amended statutory requirements. Adapted Dynamic ChangeProvides a business mapping engine so as to empower you to adapt to a rapidly changing business practices and environments.

Benefits of FESA Consol