金融保险机构合规及管理会计解决方案

金融保险机构合规及管理会计解决方案Topic:OverviewofTagetik’sSolvencyIIandTagetikEPMSolutionAudience:PartnerswhodoingconsultingbaseonSolvencyIIrequirementsConsultingpartnerforEPM+BIContent:WhoisTagetik?BackgroundonSolvencyII&ChallengesinReportingandComplianceSolvencySolutionOverview+EPM/BIPlatformOverviewDifferentiatorwithothersolutionsDemoAboutthisPresentation关于Tagetik专注于财务绩效领域（EPM+BI）业界最高客户满意度方案)超过1200+客户（200+金融服务行业客户）预置多行业专业财务报表解决方案包集预算、合并、报表、战略管理，BI等财务分析应用于一体最新技术：支持移动端，云，高速计算(PassiononNewTech)159第三方调查评价结果：Tagetik是业界客户满意度最高的方案InsuranceSectorTagetik在本年的客户满意度调查中名列榜首.Tagetik#1最佳客户的战略伙伴大奖客户满意度满分5/5Forrester

CPMWave

2013Tagetik:专注于卓越的财务管理.Tagetik击败了所有其他号称完整解决方案的供应商，在客户满意度方面以4.8分（满分5分）的优异成绩脱颖而出.148

Tagetik系统平台案例149

Tagetik系统平台其他保险、金融案例（200+金融机构使用Tagetik

）OtherFinancialSvr.InsuranceSectorMANULIFEMEDIOLANUMASSICURAZIONIMEDITERRANEOVIDANATIONALESUISSENEWLINEGROUPOCASOODYSSEYREGROUPONVZPLATINUMUNDERWRITERSPOSTEVITAPROTECTORFORSIKRINGSAVASNSREAALSTICHTINGMENZISBEHEERTALANXTOWERGATEINSURANCETVMVERZEKERINGENUNIGARANTUNIVE'VERSICHERUNGSKAMMERBAYERN-VKBZAVAROVALNICATRIGLAVZLMInsuranceSectorBankingABBEYLIFEASSURANCEADVANTAGEINSURANCEAEGONNederlandAGINSURANCEAIGALLIANZAMERISUREMUTUALINSURANCEASEMASASISAASPENINSURANCEASSICURAZIONIGENERALIBANCASSURANCEPOPOLARI-BAPBIEPIEMMEASSICURAZIONIBOVEMIJVERZEKERINGENCOMPANHIADESEGUROSAÇOREANACREDEMASSICURAZIONICZGROEPZORGVERZEKERINGENDINAFÖRSÄKRINGDSWZorgverzekeraarENOFIDEURAMVITAGENERALIVERZEKERINGSGROEPHCCUNDERWRITINGAGENCYINTESASANPAOLOVITAInsuranceSectorAdiraFinanceAXAREALESTATEINVESTMENTSMANAGERSBABSONCAPITALMANAGEMENTBANCOTOYOTABNPPARIBASREIMBXRGROUPCAREYGROUPCASSADEPOSITOECOMPASSCONAFIGROUPCONSELCREDITISSERVIZIFINANZIARIESLFEDERALCREDITUNIONFIATFINANCEGREENCOURTEPARTNERSHEARTLANDPAYMENTINVESTINDUSTRIALADVISORKGALMEDIOBANCASERVICESMITTELNELNETOMNIFINANCEIRAPIONEERINVESTMENTMANAGEMENTSELMABIPIEMMELEASINGUNICREDITLEASINGWINTRUSTFINANCIALCORPORATIONBANCAITALEASEBANCAPOPOLAREBANCOBHDBANCODIDESIOEDELLABRIANZABANCOPOPOLAREBANKAUSTRIABANQUEDEFRANCEBNPPARIBASCASSAERSTEGROUPBANKEXORBANCAAGRICOLABANCALEONARDOHALKBANKHVB-UNICREDITGROUPICCREAHOLDINGLONESTARNATIONALMEDIOBANCA(Luxembourg)OVAGRABOBANKRAIFFEISENINTERNATIONALBANKSANTANDERBANKSEKERBANKSIDBANKAST.GALLERKANTONALSUSQUEHANNABANKTANGERINEBANKUBIBANCAUNICREDITGROUPWEBSTERBANKZIRAATBANKASI*标记的为行业领先的企业对标管理架构合并规则法定架构合并规则法定合并管理合并合并管控体系财政部XBRL上报国资委报表上市公司披露税务、统计……披露数据库(数据仓库

/数据集市)制造内部企业数据业务外部Tagetik绩效管理架构财务门户/企业门户财务运营外部内部平衡记分卡绩效指标What-if分析钻取分析

例外分析多维矩阵分析KPI管理决策信息ＥＶＡ分析战略管理标杆预算历史大数据分析调研外部数据业务系统

订单系统内部数据

结算系统标杆数据

SAP系统

核算系统

资金管理系统其他外部数据

费用管理系统支付系统

其他业务系统……第三方文件预算分配&控制战略性业务性目标设定和预算预算绩效管理预算、计划与预测现金流计划法定及管理合并/关联公司管理成本分摊和获利能力分析财务快速关帐集团报表分析仪表盘与计分卡生产成本计划与控制费用管理协同披露管理10Q-10KXBRL管理报告监管报告年度报告招股章程内部审计SolvencyII/Basel多GAAP报告(IAS,IFRS,USGAAP)Tagetik功能概览财务监管塞班斯法案内审企业风险管理监管报告商务智能多维分析仪表盘BI工具财务/经营绩效管理应用企业数据层(SAP,Teradata,Oracle,MSFT…)业务数据层(SAP,Oracle,MSFT,…)战略管理BP&F(预算计划与预测)业务计划（销售、人事等）获利能力分析关帐合并披露传统典型的绩效管理架构预定义的关系型数据模型企业数据层(SAP,Teradata,Oracle,MSFT…)业务数据层ERP(SAP,Oracle,MSFT,…)Tagetik架构运营计划（销售，人力资源，生产控制）披露管理全面预算战略管理盈利分析关帐合并报表财务/组织绩效管理SOLVENCYIICOMPLIANCEMadesimplewithTAGETIKBackgroundSolvencyIIReportingChallengesTagetikSolvencyIISolutionTheTagetikDifferenceTagetikinActionAgendaSolvencyIIBackgroundEUDirectivetocodifyandstandardizeinsuranceregulations-SolvencyDefineamountofcapitalEUinsurancecompaniesmustholdtoreduceriskofinsolvencyA

singleregulationtoenhanceconsumerprotectionSimilartoBaselIIIforBanksWillcomeintoeffectonJanuary1,2016ImpactsallinsurancecompanieswithEUoperationsSolvencyIITurningsignificantchangeintocompetitivegain发源地–欧洲从2013年立项,2014年的全部标准建立,到2015年进入试运行过渡期“偿二代”在中国/C－ROSSNonlifeunderwritingLifeunderwritingSpecialhealthunderwritingInterestrateMarketOperationalConcentrationQUANTITATIVEREQUIREMENTSBalancesheetevaluationSolvencyCapitalRequirement(SCR)MinimumCapitalRequirements(MCR)QUALITATIVEREQUIREMENTS&SUPERVISIONSystemofGovernanceOwnrisk&solvencyassessment(ORSA)SupervisoryReviewprocess(SRP)DISCLOSUREREQUIREMENTSPublicdisclosureofFCSR(FinancialConditionandSolvencyReports)RSR(CommonSupervisoryReporting)PillarIPillarIIPillarIIIRiskSolvencyII:The3Pillars20092010201120122013-142015-16FrameworkDirective(L1)DefinitionofprinciplesforthesolvencysystemImplementingMeasuring(L2)Regulationadoption(Dir.SII)Supervisorystandards(L3)GuidelinestoguaranteeaconvergentapplicationandimplementationofregulationsRegulationtranspositionbynationalauthorities2016SolvencyIIenforcementDirectiveDevelopmentDirectiveAdoptionCouncil&ParliamentImplementationMemberStatesQIS51°TagetikPOCTagetikPre-packagedsolutionTagetikMaintenanceServiceSolvencyII:LawRequirementsandDeadlines

DataIntegrationandQualityComplexityofCalculationsChangingRegulatoryRequirementsCreatingandMaintainingGovernanceProcessesDifferingFinancialvs.ManagementReportingandDisclosureRequirementsReconcilingDifferentReportingFormatsEnsuringAdequateAuditTrailsandControlsSolvencyIISolvencyII:ReportingandComplianceChallengesSolvencyII:ReportingChallengesSolvencyIRegulatoryRequirementsSolvencyIIRegulatoryRequirementsSolvencyIIIManagementModelSurplusCapitalTechnicalProvisionsSurplusCapitalCapitalAdd-onSCRMCRMarginBestEstimateofLiabilitiesSurplusCapitalIECRMarginBestEstimateofLiabilities321321a1bStandardSCRAdjustedSCRMGFRMM1.Technicalprovisionstomatchinsurers’liabilities a)Bestestimateofliabilities b)MarketValueMargin2.Regulatorycapitalrequirements3.Capitalheldinexcessofregulatorycapitalrequirements

SolvencyII:StateofReadinessinEuropeFigure1:EuropeanSolvencyIIreadiness60%50%40%30%20%10%0%AlreadycompliantInthecourseof2014Inthecourseof2015Inthecourseof2016Inthecourseof2017Later2%56%20%32%58%11%19%1%1%20132012Figure2:Overallimplementationstatusbypillar201220133.53.02.52.01.51.00.50.0Pillar1Pillar2Pillar31.Therequirementsarenotmet2.Someoftherequirementsaremet3.Mostoftherequirementsaremet

4.Alloftherequirementsaremet5.ThecompanyalreadygoesbeyondtheSolvencyIIrequirementsOverall,theinsuranceindustryisontracktoimplementSolvencyIIby1January2016;however,asignificantamountofworkisneededbetweennowandthentoaddresspreparednessacrossallthreepillars.“WithTagetik’ssolutioninplace,TVMisproudtobethefirstEuropeaninsurancecompanywithanintegratedandstandardizedstatutoryandSolvencyII-compliantreportingprocesses.”EmileKaal,FinancedirectorTVMLeadingtheWaytoSolvencyIICompliancePre-builtcompletesetofaccounts,dataentryforms,reports,diagnosticchecks,calculationrules,narrativetemplatesandXBRLoutputtosatisfytheEIOPArequirementsforSolvencyIITagetikoffersaservicepackagetomaintain

alignmentwithchangestoEIOPAregulationsTagetikdistributorsandpartnersofferaservice

tomaintainnationalspecificrequirementsCompliancenow,complianceinthefuturePre-packagedSolutionforSolvencyIIWhatdoesthepre-packagedsolutioncover?PillarIPre-packagedcalculationstocoverstandardformulasPillarIIExpectedSolvencyposition&ORSAnarrativeelementsPillarIII100%coverageEIOPARequirementswithQRT,FCSRandRSRSolvencyIIPre-PackagedSolutionScopePillarI(onlystandardformula)HelperTabsMarketrisk:Interestraterisk;Equityrisk;Propertyrisk;Spreadrisk;Concentrationrisk;Currencyrisk;

Counterpartydefaultrisk:Type1;Type2.Non-Lifeunderwritingrisk;HealthsimilarNon-Life;CATriskRiskMargin

SimplificationFormulasSpreadriskforbondsandloans;Lifeunderwritingrisk;Healthsimilarliferisk.AutomaticQRTgeneration:ThePrepackagedsolutioncontainsacockpitthatsummarizesalltherisksthatcanbecalculatedinsidetheSIIPPS.TheusercanchoosewhichofthemshouldbecalculatedinsideTagetikandwhichofthemoutside.PillarII

Datacollectionforprojecteddata:thepre-packagedincludessomesimpledataentrybutacustomizedconfigurationforeachcustomerispossiblebecausetherelevantinformationforprojecteddataarecommonlydifferentfromcustomertocustomerSupportfortheORSAdocument(withCDM):thisissupportedasfunctionalitybutatthemomentthereisnotapreconfigureddocumentavailableSupportforthedataprojection:notonlydatacollection.Inthiscasetheconfigurationhastobedoneonthebasisoftheprojectionmodelofthecustomer(nopre-package)PillarII

Underdevelopment:Riskidentificationandassessment.We’llstartsoontheimplementationofthisnewpartforTalanx.Thiswillbecomeanewmoduleforthepre-packagedsolution.Riskidentificationandassessment(itwillbereleasedJune2015).

Thisnewconfigurationofthepre-packagewillincludeaprocessofidentificationoftheriskstobeconsistentlydefinedbytheundertakingandtoberecordedandclassifiedthroughouttheundertaking(i.e.inalloperationalprocessesandatallfunctionalandhierarchicallevels)inastructured,timelyandsystematicmanner.Basedontheresultsoftheriskidentification,theundertakingshallanalyzeandevaluatetherisks.Riskshavetobeclassifiedintothecompanies’riskcategories,theimpactandtheprobabilityoftheiroccurrencehavetobeestimated.Riskidentificationhastoberepeatedperiodically.Riskwillbesubmittedbyriskowners.PillarIII-PPS

QRT(QuantitativeReportingTemplates)asissuedbyEIOPA:alltheQRTcanbeusedinTagetiktocollectdataandforoutputpurposeChartofaccountcorrespondingtothedetailscontainedinQuantitativeReportingTemplatesControlgroupstocheckdatacoherencewithinQRTETLstandardtouploaddatacorrespondingtothetagetikdatamodel(e.g.chartofaccount,etc)Checkofdataqualityintheuploadphase(e.g.notexistingaccountsorcalculatedaccountscannotbeuploaded)CalculationrulescorrespondingtoallthecalculatedcellsinQRT(includingSCR,MCR,etc.)CDMTemplatefortheFCSRandRSRdocumentTrascodificationforXBRLpurpose(immediatepossibilitytodownloaddatainXBRLformat)PillarIII–typicalspecificconfiguration

ETLtouploaddatacorrespondingdirectlyfromanydatasourceREPORTforanalysisanddisclosureCDM:customizedformattinganddocumentsWORKFLOWandPROCESS:dependingfromorganizationprocessandresponsibilitiesPillarIII–comingin2015-2016

LocalcountryspecificOthers:tobeplanned,dependingfromspecificationsoflocalauthoritiesPrepackagedSolution(PPS):PillarIIIChartofaccountsTheaccountsdedicatedtoSolvencyIIhavebeenaddedSolvencyII–DatamodelCustomDimensionsThemaindimensionistheBusinessLine.

SolvencyII–DatamodelCustomDimensionsThedimensionGeographicalAreasisusedforsomereportwheregeographicaldiversificationisrequired(e.g.Premiums,claims&expenses).

SolvencyII–DatamodelCustomDimensionsTheotherdimensionsare:DETAILEDLIST:It’susedwhenisrequieredalistofsomeitem;CURRENCY:itisusedforsomereportwherecurrencysplitisrequired;CONTEXT:itisusedforadditionalinformationrequired.

SolvencyII–DatamodelControlGroupsTheControlGroupsverifye.g.thecoherence/balancingbetweenSolvencyIIdata,SolvencyIevaluationandAccountingdata.Theuserhasthechangetoreconciledatachoosingamongdifferentcasuals(Reclassification,Increase,Decrease,etc)

SolvencyII–DatamodelLegalentitiesEachentitycanbeenabledononlyonebusiness(e.g.life,nonlife)oronmorethenonebusiness(composite).SolvencyII–DatamodelLegalentitiesToenablecompaniesonlifeor/andnolifebusinesslinesplease:Addthenode“L”and“LT”forlifecompaniesAddthenode“NL”and“NLT”fordatarelatedtonolifebusinessSolvencyII–DatamodelQRTscanbereachedfromthetasks

ofaworkfloworfromTagetikReportingSAMPLEOF:DataentryandcalculationlogicDatacanbefilledintheformthroughtheETLormanuallyintheeditablecells.Thecalculationlogicarelinkedatthesaveofthetemplateandtheresultswillbeavailableinthebluecellsaftertherefresh.PillarIII–DataentryInsomecasesareimmediatelyvisibleintheQRTsDiagnostictoolcanberunthroughtheworkflowtocheckcoherencesbetweenvaluesinsideasingleQrtorbetweenQrtsPillarIII–ValidationrulesTagetik

hasthepossibilitytoautomaticallygeneratestheQRTsthroughaspecialcockpit.FromthistemplateispossibletoselectwhatHelperTabaremanagedinsideTagetik.Ifyouchoosetheoption“HELPERTABINSIDETAGETIK”informationwilltransferredintherelatedQRTs.

PillarIII–QRTgenerationSampleofgenenerationQRTS.26.01.b(B3A)PereachinformationcomingfromtheHTorSFispossibletoseetheoriginsourcethroughaspecialdrilldownPillarIII–QRTgenerationCreateafoundationofreliable,traceabledataLoadingandmappingfrominternal/externaldatasourcesDatacollectionandconsolidationWorkflowSCRandMCRCalculationIntegrationwithfinancialdataDatavalidationAsthebasisforallreportinganddisclosurerequirementsFinancialReportingManagementReportingDashboardsDisclosureManagementXBRLoutputIntegrationwithSharePointTagetik:TheUnifiedApproachtoSolvencyII

datamodelTVM

fase1

Mgt.

ReportingQRT’s,XBRL,NarrativesGeneralledgerTagetikSolvencyIIpre-packaged

solutionTagetik

FinancialStatementsDatamodel&calculations

SolvencyIIpre-packagedsolutionLocalSIIrequire-mentsQRT

sourcedataPillar1sourcedataInputsOutputsETLCustomerDataModelTagetikSolvencyIIArchitectureTagetikSolvencyIISolutionComponentsAllQRTsAnnualQuarterly,Group,SoloData-checksandlog-filesTemplatesforRSR/SFCRUpdatesfromEIOPAXBRLoutputDocumentationPre-packagedTagetikapplicationwithallbuildingblocksAnalyticalCalculationsIntegratedReportingDWH/DatamartLIFEALMOperation…DataSourcesAssetsRiskPoliciesGLManualinput…CONSOLIDATION&REPORTINGICreconciliation,IFRS,ConsolidationCalculations&ReportingDataqualityFCSRPublicReportingCDMRSRReportingtoAuthorityETLMANUALENTRYRiskCalculationEngineTagetik:ArchitectureandTechnologyPerspective

TagetikwasselectedastheSoftwareSolutiontosupportalltheprocessesintheCFOArea.PhaseIRequestforProposalPhaseIISoftwareEvaluationPhaseIIISoftwareSekectionSoftwareVendorsinvited:SAS,SAP,Oracle,Tagetik,IBM,andMoody’s(onlyforPillar3)December2013evaluationoutcome:SAPandTagetiksolutionswereconsideredcomparableregardingtheproductsfunctionalitiesandtechnicalfeatures.Tagetikbestassessmentfor:programapproach,customersatisfactionandstrategiclongtermpartnershiprelationship.Theonlyconcern,aboutTagetik’scoverageinspecificcountries,hasbeenovercomethankstotheavailabilityoftheTagetikCorporateCenterandPwC/KPMGresources.SoftwareSelectionResults

IFRSGroupFinancialStatementConsolidationMVBS–MarketValueBalanceSheetConsolidationOwnFunds(OF)QuantitativeReportingTemplates(QRTs)RegularSupervisoryReporting(RSR)Solvency&FinancialConditionReport(SFCR)ProcessDetailsActual/MonthlyReportingForecastPlanningIFRSConsolidationMVBSSolvencyIIReportingPillarIIIPlanning&ForecastingProcessinScopeProgramKickOff07/01/2014Go-LiveIFRS,MVBS,P301/2015Go-LiveP&C08/2015TobeintegratedwithotherrelevantstreamsvalidatedafteranalysisphaseProjectTimelineItalySpainSwitzerlandGlobalcorporateLines**AustriaEasternEuropeFranceGermanyBusinessUnits*:TheBUswillbemainlyinvolvedduringathreeprogramphase(1,2,and5):Plan&Set-UpAnalysisDesignImplementationUserAcceptanceTest,Training&Go-Live12345Duringphase3and4,BUsinvolvementwillbelessintensive,whiletheywillbeheavilyinvolvedduringthedataextractionphase.Thedata(bothforIFRS,MVBS,andPillarIII)willbecollectedbytheTagetiksolution.“ReferenceFigures”weredesignedtomaketheinformationflowandthecommunicationsmoothlybetweentheGroupHeadOfficeandtheBUs.*TheNetherlandsinvolvementwillbeevaluatedforIFICCpurposes,inordertoalignedtheTagetikimplementationalreadybeganfortheproductionprocessofdata.**Tobeconsideredspecificasinvolvementoftherelevantstakeholders.BusinessUnitsInteractionManyInsurersTrustTagetikforSolvencyIITheCompany:TVMFoundedin1962,400full-timeemployeesNetherlands-based;officesinBelgium,France,GermanyTransportationInsuranceProjectScopeResults/BenefitsLocalcloseAlignprocessestosimultaneouslyaddressstatutory,SolvencyIIandmanagementreportingAutomateconsolidationandreportingenvironmentfor30separatecompanyentitiesCreateasinglesolutionfordatacollectionandstorage,entryforms,consolidation,reportingProvidebuilt-infinancialcontrolsandvalidations,withfulltraceabilityandtransparentaudittrailsAutomatedSolvencyIIPillar3calculationsandreportsMeetSolvencyIIrequirementsinparallelwithstatutoryreporting,intercoelim,andfastcloseFirstEuropeaninsurancecompanytostandardizestatutoryandSolvencyII-compliantreportingSimpleandcosteffectivesolutionformeetingthereportingrequirementsofSolvencyIIAutomatedprocessconsumesfewerresourcesTheCompany:GruppoCredemListedonItalianstockexchangesinceOctober1997HeadquartersinReggioEmilia,ItalyCommercialBanking,Insurance,AssetManagementCoverSolvencyIIP2-P3andlocalrequirementsSingle-producttomanagesupervisoryreporting,planning&budgetingandmoreEnterpriseDataWarehousetosupportnewinfrastructure,integratewithP1calculationenginesReduceoperatingriskEnhanceinformationquality,efficiency,availabilityEnableusersindependenceSingleplatformformultiplerequirements:reporting,budgeting,planningetc.FullcompliancewithSolvencyIIP2andP3CompleteauditabilityforSolvencyIIprocessesanddatachangesthroughouttheprocessCollaborativereportingonP2,integratedwithDWHGreateranalysiscapabilityforCFOandquickeranswersforCEOBetterbusinessmanagementcapabilitiesforBoardProjectScopeResults/BenefitsTheCompany:TalanxAGHeadquartersinGermany,operatingin150countries22,200EmployeesWorldwideGlobalB2BInsuranceFocusMeetSolvencyIIP3reportingrequirementsinQ12014Implementasinglesolutionforsolo/groupreportingFunctionalguidanceandsupportforlocalPillar3CoordinationandsynchronizationofparallelprojectsSupportofthestandardformulasforPillar1Pillar3reportingmustconsiderthepublicandcapitalmarketperception–i.e.theSolvencyFinancialConditionReport(SFCR)TagetikselectedsinceitwasalreadysuccessfullyusedforIFRS

reportingSolvencyIIsolutionsupportsallPillar3reportingrequirementsSinglesoftwaretoolforsolo/entityandgroupreportingandprovidessupportforstandardformulasProjectScopeResults/BenefitsTheTagetikDifferenceBuilt-inintelligencePre-builtcalcsandreportsWorkflowandvalidationProjectconsultingTechnicalconsultingCheck-upconsultingTrainingandsupportRegulatoryupdatesTagetik“FullService”SolvencyIIReportingAchievefastSolvencyIIcompliancewithourPre-packagedapplicationandflexiblecustomizationsStreamline

yourdatageneration,consolidation,reportinganddisclosureprocessestosavetime,effortandcostseachstepofthewayStayalignedwithchangingregulationswith