client login
Home   /   Services   /   Design   /   Solution Architecture   /   Solution Architecture Process

Solution Architecture Process

Review Financial Processes

  • Current State Assessment
  • Pain points / limitations / opportunities

Build Process Maps

  • Future State
  • By Function by Task By Role
    • Consolidations
      • Roll-forwards
      • Intercompany Eliminations
      • Journal Entries & Topsides
      • Restatements / Reclasses
      • Ledgers & Dimensions / Granularity
      • KPI / Metrics
    • Planning
      • Revenue / Margin
      • Expenses / Overhead
      • Payroll
      • Capital
      • Operations
    • Either
      • Income Statement / P&L
      • Balance Sheet / Cash Flow
      • Calculations / Logic / Allocations
  • Link Processes to Requirements & Goals

Conceptual Solution Model

  • EPM models defined
  • Dimensions defined
  • KPI’s, Statistics, Ratios
  • Integration Strategy (Data and application)

Report Assessment

  • Reporting requirements
  • XBRL (future state)

Defined Templates

 

Typical interfaces for capturing Consolidations or Budget/Forecast details, including

Consolidations:

  1. Currency Rates (manual or upload)
  2. Ownership Percentages
  3. Journal Entries
  4. Topside Adjustment Template
  5. Reclass / Restatement Template
  6. Balance Sheet Movements
  7. Cash Flow Adjustments and Movements
  8. Elimination Entries
  9. Acquisition / Divestiture (future)
  10. Flash Consolidation

Planning:

  1. Unit * Price (revenue / cost / expense)
  2. Whole dollar values
  3. Spread / Trend
  4. Allocations
  5. Driver-based

Calculations & Logic

Define functional logic for the business process components, such as

  1. Currency Translations
  2. Intercompany Eliminations
  3. Balance Sheet and Cash Flow Carry Forward
  4. Equity Pickup
  5. Payroll taxes, benefits, and merit
  6. Capital spend and depreciation

SAP EPM Features defined

  1. Controls
    • e. Assets = Liabilities + Owner Equity
    • e. Closing Balance = Beginning Balance + Sum of Flows
  2. Business Process Flows
    • User checklist for completion of a functional process
    • Consolidation process focused
    • Security-based tasks
    • Notification and Approval processes
  3. Work Flow
    • Allows the EPM admin or users to set the status of their monthly submission: Open for Input, Submitted, In Review, Approved. Can also be used to lock the current month.
  4. Journal Entries
    • Used to make adjustments to accounting data directly in the BPC Consolidation model.
  5. Security
    • User level security that controls data access (None / Read / Write) and task authority (run calc, load data, etc)
  6. Audit
    • Tracks who/when/what changed in data, metadata and process

Key Decisions –

  • Follow-up sessions
  • Documentation
  • Steering Committee Review
  • Documentation of Blueprint findings
    • Presentation
    • Functional Design Doc
    • Technical Design Doc
    • Release strategy
    • Functional releases
    • Project Plan
    • Staffing / Investment

Solution Architecture