FESA CONSOL

FlexSystem

Aggregation

Aggregation AVESTA represents a group of users they are working within a computerized environment knowing that automation of aggregation computing supported by their computerized systems are far from perfect.  

 

Simplex form of aggregation 

 1 + 1 = 2

 

 Most common aggregation functions 

 Sum(), Count(), Max(), Min()

 

Assumptions (Based on standardized data source) 

 Measurement and recognition rules 

 Chart of accounts 

 Reporting currencies 

 Data file formats 

 Presentation of transactions or trial balances 

 

Examples 

 Each company of a consolidation group furnishes standardized transactions, vouchers or trial balances to their headquarters for aggregation in order to prepare different kinds of summary reports (i.e. aggregation scenarios)

 

Key problems encountered by headquarters 

 Issues of unexpected speed and accuracy when there are involving many data files, many rows and columns for each data file

 Following are examples of column name: 

Ledger code

Voucher date

Accounting period

Account code

Business unit

Department

Project

Branch

Currency code

Original amount

Exchange rate

Equivalent amount

Quantity

Unit code

Unit price

Particulars


 Many amendments of data files 

 Identifying missing and duplication of data files

 Frequent reporting, from monthly to weekly to daily to...

 Issues of security control, e.g. user send data through email system to wrong recipients

 

 Aggregation scenarios

 Scenario 1: Aggregation for strategic management

 Five-year budget planning with multi-scenario analysis

 Acquisition and disposal decisions involving capital asset, legal entity, branch, product line

 Scenario 2: Aggregation for operational management

 YTD actual profit and loss by business unit by month

 Monthly forecast by business unit by department

 Actual cf buget scenarios cf rolling forecast versions

 Sale-thru analysis by different dimensions

 Scenario 3: Aggregation for statutory compliance

  YTD actual consolidated trial balance by company by different GAAPs including PRC GAAP, US GAAP, HK GAAP, Japan GAAP etc.

 

Aggregation reports

 Dynamic on-line aggregation summary

Aggregation1

 Dynamic on-line aggregation breakdown

Aggregation2

  Dynamic on-line aggregation summary to summary 

Aggregation3   

AVESTA Related Articles

  

 Evolution of accounting model

 Postmodern accounting equation

 The rise of group consolidation & budgeting

 Evolution of advanced accounting automation

 Aggregation  Versioning  Elimination  Standardization  Tagging  Alert

 Evaluation of AVESTA computing issues

 Three progressive phases of implementation

 Finance Computing Framework