|
|
|
|
|
Analyst
Budgeting enhances the processing of the spreadsheet-based budgeting process
as follows:
|
|
1. Build System
|
|
Automates generation of financial data
warehouse
|
|
Includes non-GL data
|
|
Uses template model workbook
|
|
Use existing Excel model
|
|
Option to budget at summary-level structures
|
|
2. Initiate Budget
|
|
Initiate budget from database using existing
data (e.g. actuals), protected reference data, and assumptions
|
|
Analyst Author creates template model workbook
|
|
3. Distribute Budget
|
|
Workbook Generator distributes budget workbooks
|
|
Email integration
|
|
Data Mart Generator for devolved processing and
sub-consolidation
|
|
Store workflow information in database for
control reporting
|
|
4. Enter/model
Budget
|
|
Spread Methods and Calculations
|
|
Budget workbooks can be used offline from
database
|
|
Automated workbook protection using Protection
Manager
|
|
Option to add new budget line items and new
worksheets to workbook
|
|
Option to budget at summary-level structures
|
|
5. Submit
Returns
|
|
Option to control write-back of selective items
|
|
Control how data is written-back: either
central bulk load, direct to distributed data mart, or direct to main
database
|
|
Up to 99 separate budget passes
|
|
Update database on the fly from workbooks
|
|
6. Report &
Analyse
|
|
Integrated financial reporting using Analyst
Reporting
|
|
Comparative reporting, incorporating automated
variance analysis
|
|
Interactive drill down capability
|
|
Analyst Web Reporting
|
|
Optional multidimensional analysis using
Microsoft OLAP Services
|
|
7. Revise System
|
|
Automates maintenance of database and template
workbook
|
|
Reorganise reports by adding rollups
|
|
Add new dimensions to database
|
|
|
|
The Budgeting
cycle is an iterative (repeating) process!
|
