110 likes | 347 Views
IBM Cognos FSR Automatisera skapandet av externa och interna rapporter med IBM Cognos FSR Andreas Bernlind, CPM Consultant Thomas Ekbom, CPM Consultant Corporate Performance Management, Affecto. Important Disclaimer.
E N D
IBM Cognos FSRAutomatisera skapandet av externa och interna rapporter med IBM Cognos FSRAndreas Bernlind, CPM ConsultantThomas Ekbom, CPM ConsultantCorporate Performance Management, Affecto
Important Disclaimer THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSES ONLY. WHILE EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THE INFORMATION CONTAINED IN THIS PRESENTATION, IT IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. IN ADDITION, THIS INFORMATION IS BASED ON IBM’S CURRENTPRODUCT PLANS AND STRATEGY, WHICH ARE SUBJECT TO CHANGE BYIBM WITHOUT NOTICE. IBM SHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OFTHE USE OF, OR OTHERWISE RELATED TO, THIS PRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN THIS PRESENTATION IS INTENDED TO, OR SHALL HAVE THE EFFECT OF: CREATING ANY WARRANTY OR REPRESENTATION FROM IBM (OR ITS AFFILIATESOR ITS OR THEIR SUPPLIERS AND/OR LICENSORS); OR ALTERING THE TERMS AND CONDITIONS OF THE APPLICABLE LICENSE AGREEMENT GOVERNING THE USE OF IBM SOFTWARE.
Agenda • Introduktion ”The last mile” • Introduktion till Cognos FSR • Demo av FSR • Sammanfattning • Frågor och diskussion
“The last mile” “The last mile” i den finansiellarapporteringen Årsredovisning, Kvartalsrapport, Styrelserapport Planering Budgetering Forecast Konsolidering Rapportering • Manuella processer dominerar “The last mile” • Omfattande användning av Word och Excel som skickas via e-post • Problem med tillförlitligheten av datan • Bristfälliga interna kontroller • Ingen AuditTrail • Många moment som upprepas för varje rapporteringsperiod och som måste göras om från början
Informationsdelning inom organisationen • Press Releases • Årsredovisning • Prospekt • Styrelsematerial • Management Reporting “En version av sanningen” inom hela organisationen Cognos FSR • Myndighetsrapportering • Årsredovisningar • Kvartalsrapporter Investor Relations Internal Reporting • Deklarationer • Fullmakter mm External Reporting Regulatory Reporting Legal
Report Cognos FSR – Såfunkardet Cognos FSR Application Output Options Byggerpåverktygsomredanofta används - Microsoft Word and Excel Främjar samarbete Data ifrån en central databas Olika format förutdata
2010 Cognos FSR – Så funkar det Konsoliderad data ERP Datakällor Cognos FSR Application ##V M$8.242 2010-M$8.201 M$8.201 2010-M$8.242 Report Relational M$8.201 M$8.242 M$8.201 M$8.242 M$8.242 M$8.201 OLAP ##V Variabler(##V) gördetmöjligtattskapadynamiskauppdateringaravsiffroroch text närinformationenändrasidatakällen Direktåtkomst till källdatan
Reinsurance and other amounts recoverable reflect amounts due from reinsurers and policyholders to cover incurred but not reported and pending claims for minimum premium products and certain administrative services only business where the right of offset does not exist. See Note 10 for additional information on reinsurance. For the three months ended March 31, 2009, actual experience differed from the Company’s key assumptions resulting in favorable incurred claims related to prior years’ medical claims payable of $40 million, or 0.5% of the current year incurred claims as reported for the year ended December 31, 2008. Actual completion factors resulted in a reduction in medical claims payable of $17 million, or 0.2% of the current year incurred claims as reported for the year ended December 31, 2008 for the insured book of business. Actual medical cost trend resulted in a reduction in medical claims payable of $23 million, or 0.3% of the current year incurred claims as reported for the year ended December 31, 2008 for the insured book of business. Reinsurance and other amounts recoverable reflect amounts due from reinsurers and policyholders to cover incurred but not reported and pending claims for minimum premium products and certain administrative services only business where the right of offset does not exist. See Note ##rnote for additional information on reinsurance. For the ##D<cqmel> ##D<cqe>, actual experience differed from the Company’s key assumptions resulting in ##D<cqqheamcpfavor> incurred claims related to prior years’ medical claims payable of $##D<cqqheamcppyin*-1> million, or ##D<cqqheamcppyd%in> of the current year incurred claims as reported for the year ended ##D<cye-1>. Actual completion factors resulted in ##D<cqqheamcpcfactordir> in medical claims payable of $##D<cqqheamcpcfactor> million, or ##D<cqqheamcpcfactor%> of the current year incurred claims as reported for the year ended ##D<cye-1> for the insured book of business. Actual medical cost trend resulted in ##D<cqqheamcptrenddir> in medical claims payable of $##D<cqqheamcptrend> million, or ##D<cqqheamcptrend%> of the current year incurred claims as reported for the year ended ##D<cye-1> for the insured book of business.
Finansiell data Cognos FSR Applikationen Format ERP Systems Consolidations • Front Page • Table of Contents • Chairman’s Statement • Business Overview Relational Strukturerad information • Income Statement • Balance Sheet • Cash Flow • Reconciliations OLAP • Notes – Policies • Notes – Assets • Notes – Liabilities • Notes – Equity Ickefinansielldata (Operational / Statistical / CSR) Cognos FSR – Hur fungerar det? Workflow Checklistor Audit Trail Variabler/ referenser i text “En version av sanningen” Versionshantering Business Rules Samarbete
1 3 2 “En version av sanningen” Främjar samarbete Kontrollerad process 4 Ökad effektivitet Cognos FSR sammanfattning