AVESTA
Modules
Solutions
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
► Dynamic on-line aggregation breakdown
► Dynamic on-line aggregation summary to summary
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