1 / 84

for Internal Management & Statutory Compliance

FESA C onsol. for Internal Management & Statutory Compliance. www.fesaconsol.com/consol.pdf www.fesaconsol.com/consol.ppt x Last update: 6-Mar-2014. Agenda. Supports Flexible Consolidation of Historical & Prospective Data. Analyzing in Different Dimensions (Single Level & Multi-Level).

iokina
Download Presentation

for Internal Management & Statutory Compliance

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FESAConsol for Internal Management & Statutory Compliance www.fesaconsol.com/consol.pdf www.fesaconsol.com/consol.pptx Last update: 6-Mar-2014

  2. Agenda

  3. Supports Flexible Consolidation of Historical & Prospective Data

  4. Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing

  5. Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing

  6. Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing

  7. Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing

  8. Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing

  9. Analyzing in Different Dimensions (Single Level & Multi-Level) • Hong Kong • PRC • Property Development • Taiwan • Property Investment Hospitability • Treasury • Others • Macau • Manufacturing

  10. 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

  11. 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

  12. 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

  13. FESA Empowers Our Enterprise Solutions in 6 Different Aspects FESA Data Process Network User Time Rationality What How Where Who When Why

  14. FESA Consolidation Comprises 6 Software Modules FESA Control Transform Storage Reporting Collection

  15. 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

  16. 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

  17. FESA Supports Web & Windows Login Client

  18. FESA Supports Optimization of Scalable Implementation

  19. Data Collection – With or Without External System Integration Extract data from external system directly Upload multiple Excel Workbooks

  20. A Quick Review of Your Group AVESTA Standardize

  21. A Quick Review of Your Group

  22. A Quick Review of Your Group

  23. 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

  24. 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

  25. 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

  26. Data Transformation: Supports User-defined Elimination Rules • Elimination Amongst Different Business Units • Elimination Amongst Different Legal Entities • Elimination Amongst Different Geographical Regions

  27. 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

  28. Data Transformation: Supports Query Formula for Elimination Elimination AVESTA

  29. Business Unit Other Business Retailing Hotel • Financial Services FESAAllocation •••••••••••••••••••••••••••••••••• Service Department HR Finance Admin • Others Marketing • IT Provide Services to Business Units

  30. Data Transformation: Supports Multi-currency Subgroup USD HKD CNY NTD A Multi-currency Subgroup EUR MOP

  31. 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

  32. Management DBMS: Supports Data Rewritable Methodology User can assign Segmental Rewrite Code (RW Code) to their worksheet so as to rewrite relevant posted data

  33. 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

  34. Ledger Form: Configuration of Master Files Analysis Category Analysis Code

  35. 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

  36. 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

  37. Traditional Reporting Tool: Standard Report AVESTA Aggregation

  38. 1 December 2009 Opening Balance December 2009 Movement 31 December 2009 Closing Balance AVESTA Aggregation

  39. AVESTA Aggregation

  40. FESA Query, An End-user Reporting Tool AVESTA Aggregation

  41. Reporting: Consol Income Statement – By Product AVESTA Aggregation

  42. Reporting: Consol Trial Balance AVESTA Aggregation

  43. Reporting: Consol Trial Balance AVESTA Aggregation

  44. Reporting: Drill Down Step by Step AVESTA Aggregation

  45. Reporting: Empowers You to Configure Many Analysis Reports AVESTA Aggregation

  46. Reporting: Empowers You to Configure Many Analysis Reports AVESTA Aggregation

  47. AVESTA Versioning AVESTA Aggregation

  48. Reporting: An Example of Report Package

More Related