820 likes | 962 Views
FESA C onsol. for Internal Management & Statutory Compliance. Website: http://www.fesa-s.com Email: avesta@flexsystem.com Last update: 6-Mar-2014. Agenda. Supports Flexible Consolidation of Historical & Prospective Data. Analyzing in Different Dimensions (Single Level & Multi-Level).
E N D
FESAConsol for Internal Management & Statutory Compliance Website: http://www.fesa-s.com Email: avesta@flexsystem.com Last update: 6-Mar-2014
Supports Flexible Consolidation of Historical & Prospective Data
Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing
Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing
Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing
Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing
Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing
Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing
From User Requirements to Best Fit Solutions Your Reporting Issues Our Reporting Solutions Our Reporting Framework FESA Query FESA Analyst Analytical Performance Management Budgeting & Rolling Forecast Collection Reporting Standardization Tagging Financial Management Group Consolidation FESA Planning FESA Consol Transformation Storage Your Recording Issues Our Recording Framework Our Recording Solutions Financial Management Financial Management FESA AVESTA Finance Computing 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 Versioning Standardization Tagging Alert Recording Issues Reporting Issues Elimination Aggregation Phase 1 AVESTA Phase 2 AVESTA Phase 3 AVESTA Budgeting & Rolling Forecast Financial Management & Group Consolidation Analytical Performance Management A ggregation V ersioning E limination Standardization Tagging A lert Recording Recording to Reporting Reporting
Finance Computing Framework User Interface Outputs Master Settings Query Formulas Data Sources Processing Rules Reporting Collection Storage Transformation System Control System Control Collection Transformation Storage Reporting Rule Processor Query Processor FESA Application Server Recording Recording to Reporting Reporting
FESA Empowers Our Enterprise Solutions in 6 Different Aspects FESA Data Process Network User Time Rationality What How Where Who When Why
FESA Consolidation Comprises 6 Software Modules FESA Control Transform Storage Reporting Collection
FESA Supports Each Software Module in 6 Different Aspects FESA Control Transform Storage Reporting Data What What What What What Collection 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 FESA Transform Storage Reporting Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Control Configuration Configuration Configuration Configuration • Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Configuration Elimination Configuration Standardize Tagging Configuration Configuration Configuration Configuration Configuration Versioning AVESTA Aggregation Collection Alert
Data Collection – With or Without External System Integration Extract data from external system directly Upload multiple Excel Workbooks
A Quick Review of Your Group AVESTA Standardize
Finance Computing Framework User Interface Outputs Master Settings Query Formulas Data Sources Processing Rules Reporting Collection Storage Transformation System Control System Control Collection Transformation Storage Reporting Rule Processor Query Processor FESA Application Server Recording Recording to Reporting Reporting
Data Collection Supports Different Types of Data Collection Methods Existing Database User-defined Data Entry Forms Existing Data File Processing Rules Processing Rules External Data Storage Query Formulas Web Windows Single Sheet SQL Internal Data Storage NoSQL Mobile Excel Multi-sheet Collecting Transaction Detail and/or Aggregated Information Collecting Structured Data and/or Unstructured Data Supports Different Types of Data Sources
Data Collection: Support “Green” Excel Workbook Tagging 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: Automation of reversal of Pivot Table AVESTA
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 Basic Assumptions Re-measurement Assumptions Full Consolidation Revaluation Amortization Proportional Consolidation Allocation Translation Equity Accounting Effective Date of Change Basic Adjustments Other Adjustments GAAP Adjustments Reversal Value Type Elimination Adjustments Year-end Date Disposal Audit Adjustments Effective Date of Change Basic Dimensions Tagged Dimensions Code Identification Multi-version Top/Sub Consol Code Reorganization Multi-scenario Other Tagging Code Standardization Recognition
Data Transformation: Supports Query Formula for Elimination Elimination AVESTA
Business Unit Other Business Retailing Hotel • Financial Services FESAAllocation •••••••••••••••••••••••••••••••••• Service Department HR Finance Admin • Others Marketing • IT Provide Services to Business Units
Data Transformation: Supports Multi-currency Subgroup USD HKD CNY NTD A Multi-currency Subgroup EUR MOP
Data Storage User Interface Master Settings Supplementary Audit Trial (Excel / pdf / Text Files) Statutory Database Management System Management Database Management System Primary Data Store Compressed Data Cube Ledger Form Heterogeneous Form DBMS Model Data Type Data Schema FESA Application Server
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 • Other Dimensions • Version / Scenario • Internal / External • Currency / Amount • Quantity / Statistics • Time Dimensions • Daily / Weekly • Monthly / Quarterly • Yearly • Month-To-Date • Year-To-Date • Location Dimensions • Branch • District • City • Country
Ledger Form: Configuration of Master Files Analysis Category Analysis Code
Ledger Form: Supports Dual Database Posting Tagging 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
Reporting Tools User Interface (Windows, Excel and/or Web) Standard Enquiry/ Reporting Standard Query Collection Transformation Storage Reporting Primary Reporting Services High Performance Reporting Services FESA Application Server Primary Data Store Query & Extraction Processor 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
AVESTA Aggregation
AVESTA Aggregation