Upload
luis-barragan
View
1.611
Download
4
Embed Size (px)
DESCRIPTION
Presentacion de la solucion de consolidacion financiera de IBM Cognos a cargo de su asociado de negocios en Peru DWConsulware
Citation preview
DWConsulware ®
The Business Intelligence Company
TM
CPM
Una Solución Integral para laAdministración del Rendimiento Empresarial
Luis Barragán
Gerente Comercial Perú
Oracle
CPM: Construido Exclusivamente para Administrar el Rendimiento
SAPPSFT
JDESiebel
Aplicaciones
Automatización de TransaccionesRecolección de Datos
Administración del RendimientoAnálisis de Información
Efectividad
Eficiencia
Ventaja Competitiva
FUNCTIONS PROCESSESWHOLE-COMPANY
MANAGEMENT
CO
MP
ET
ITIV
E A
DV
AN
TAG
E
EFFICIENCYREPORTINGREPORTING
EFFECTIVENESS
BUSINESS INTELLIGENCE
BUSINESS INTELLIGENCE
GL, AR, AP…GL, AR, AP…
SCMSCMERPERP
CRMCRM
CORPORATEPERFORMANCEMANAGEMENT
Alto Rendimiento
■ Rendimiento
■ Decisiones
■ Información
Tres Preguntas que Determinan el Rendimineto
La Realidad en Muchas Organizaciones
La mayor parte es manual
Resultado Tiene que ser repetido y hecho
en forma diferente cada vez
Un proceso impredecible – riesgoso y no auditable
La Realidad en Muchas Organizaciones
Reporteo y análisis utilizando múltiples herramientas
Resultado Desconfianza en los números
Alto costo de mantenimiento No se comparten habilidades,
reportes, ni soporte técnico No hay economía de escala
La Realidad en Muchas Organizaciones
Muchas hojas de cálculo producidas individualmente
Resultado No se optimizan recursos
Demoras en la entrega
Se introduce un factor de riesgo
Planificar, Monitorear y Comprender Su Rendimiento
El Reto
AlineaciónVisibilidadConfiabilidadRendición de Cuentas
Bodega de Datos Centralizada
Warehouses, ODS, Excel ..Oracle, SAP, JD Edwards, PeopleSoft, Siebel
CPM Plataforma Tecnológica
Clientes Corporativos
Clientes en Perú
Consolidación Financiera
IBM Cognos Controller
Failing Financial Systems
Financial Systems and Procedures50%
IT controls4%
Revenue Recognition5%
Documentation7%
Other34%
SOURCE: Compliance Week, SEC filings
Weaknesses, Deficiencies in 2007
Encuesta CFO´s
What percentage of organizations want to reduce the length of time for the financial close cycle?
45% 64% 74% 90%
How may believe automation would significantly help shorten the close?
41% 64% 81% 90%
Asked of 250 Senior Financial Managers, Executives
Consolidation: Structure and Practice
ERP
Manufacturing
GL
Foreign Subsidiaries
ERP
ERP
GL
ERP
Global Distribution and Sales
Consolidation Process
Moving Data Accounting Adjustments Inter-company
elimination's Currency conversion Consolidating entities Differing Accounting
Standards (e.g. GAAP) Legislation (SOX, IFRS,
IAS)
Corporate Reporting
External and Internal Reports:
Key FinancialStatements
Internal Operations, Variance, Comparative Analysis, FinancialRatios
THE CLOSING CYCLE CHALLENGES
Root Causes
Financial and management data collection difficult
Data quality/error checking
Lack of audit ability
Hard to deliver GAAP and Management reports
Difficult to setup
Hard to manage business and accounting changes
Tactical Pains
MultipleGAAPReporting
InterCompanyMultiCurrency
ComplexOwnership
Div 1Div 1
Div 2Div 2
HQ 1HQ 1
Company 1Company 1
Company 2Company 2
Company 3Company 3
IncompleteFunctionality
Business Changes
DisparateData
INEFFICIENT AND INEFFECTIVE CLOSE CYCLES
Spreadsheets
1st Generation Solutions
ERP
Multiple Data Sources
ROOT CAUSE CONSEQUENTIAL PAINS
Long close cycles Risk of misstatement Higher auditing
and accounting costs Unable to sustain compliance and
performance initiatives
Customer Response – Improve process
Risk
Deliver financial statements within few business days
Automate & structure consolidation collection & processing
Introduce certification & authorization processes
Automated data submissions
COGNOS 8FOR PERFORMANCE MANAGEMENT
Embrace and Extend Your Existing Infrastructure
Resolve Pain For Immediate Gains
1Adopt & Sustain Best Practices
Radiate Beyond Finance
PM for Strategy Execution
AUTOMATION ---------------------------------- TRANSFORMATION ----------------------------
2 3 4
PERFORMANCE MANAGEMENT ROADMAP
Improve cycle time
Better control of close process
Eliminate errors and improve data quality
Introduce greater accountability, repeatability and audit ability
Embrace and Extend Your Existing Infrastructure
Resolve Pain For Immediate Gains
1Adopt & Sustain Best Practices
Radiate Beyond Finance
PM for Strategy Execution
AUTOMATION ---------------------------------- TRANSFORMATION ----------------------------
2 3 4
COGNOS CONTROLLERStep 1: AUTOMIZATION
Best
practices
functionality
Performance
platform
11
22
33
Finance
managed
200+ Pre Built working reports
Multi jurisdictional GAAP reporting
Deep domain FX, IC, MI, SOX
Application approach no coding
Familiar work environments like Excel, Web
Enterprise reach centralized control
Leading in BI Leading in Planning PM Standardization
Resolve Pain For Immediate Gains
1
PERFORMANCE MANAGEMENT ROADMAP
Improve cycle time
Better control of close process
Eliminate errors and improve data quality
Introduce greater accountability, repeatability and audit ability
Identify gaps and establish close process
Standardize key controls
Optimize end to end close process
Integrate technology into close process
Resolve Pain For Immediate Gains
1Radiate Beyond Finance
PM for Strategy Execution
AUTOMATION ---------------------------------- TRANSFORMATION ----------------------------
Adopt & Sustain Best Practices
2 3 4
PERFORMANCE MANAGEMENT ROADMAP
Improve cycle time
Better control of close process
Eliminate errors and improve data quality
Introduce greater accountability, repeatability and audit ability
Identify gaps and establish close process
Standardize key controls
Optimize end to end close process
Integrate technology into close process
Resolve Pain For Immediate Gains
1
AUTOMATION ---------------------------------- TRANSFORMATION ----------------------------
Adopt & Sustain Best Practices
2Radiate Beyond Finance
3PM for Strategy Execution
4
Deliver financial information to business stakeholders
Accelerate performance reporting
Management and Financial Reporting Performance Blueprint
PERFORMANCE MANAGEMENT ROADMAP
Integrate financial information for planning
Accelerate performance understanding
Integrate financial and operational information
Improve cycle time
Better control of close process
Eliminate errors and improve data quality
Introduce greater accountability, repeatability and audit ability
Identify gaps and establish close process
Standardize key controls
Optimize end to end close process
Integrate technology into close process
Resolve Pain For Immediate Gains
1
AUTOMATION ---------------------------------- TRANSFORMATION ----------------------------
Adopt & Sustain Best Practices
2Radiate Beyond Finance
3PM for Strategy Execution
4
Deliver financial information to business stakeholders
Accelerate performance reporting
Why Cognos for Enterprise Planning?CPG Energy & Services Financial Services Manufacturing
Demonstrating Consolidation Leadership1400 Groups in 100+ Countries with Controller
AB-Foods
Resolve Pain For Immediate Gains
1
Consolidation and Financial Reporting
Screenshots
Consolidation Management Heirarchy
Standard Report of the Organization Heirarchy
Data Submission and Overall Reporting Status Workflow
Data Collection and Review – Overall Review and Signoff
Data Collection and Review – Balance Sheet
Data Collection and Review – Inter-Company Detail
Data Collection and Review – Journal Entry
Consolidation Steps
Consolidation Trial Balance Report Eliminations
DEMO Cognos Planning
DWConsulware ® The Business Intelligence
Company TM