1DRAFT–CONFIDENTIALNOTTOBEDISTRIBUTEDBPODeepDiveProcessReviewJune2003Reconciliations2DRAFT–CONFIDENTIALNOTTOBEDISTRIBUTEDReconciliations:PrimaryPrimaryProcessOwnerProcessOwnerSecondarySecondaryProcessOwnerProcessOwnerProcessProcessOverviewOverviewReconciliationsisperformedgloballybyateamof244people(May‘03)locatedinSharedServicesCenter1(including2stafflocatedinSharedServicesCenter2).Theteamreconcilesaccounts,assignsownershipforunreconciledaccountsandreportstheagedstatusofDiversifiedFinancialInstitutionBalanceSheetAccounts.InputstothereconciliationprocessareMonth-endtransactionfiles,bankstatements–electronicandmanual,othersupports,GeneralLedger(GL)extracts,sub-ledgerextractsandtrialbalances.InputsareloadedintoReconstep(thereconciliationsystem)andanautomatchperformed.InadditiontoReconstepEMEArelatedaccounts(atSharedServiceCenter2&SharedServiceCenter1)arereconciledonWARS.Thesereconciliationsystemsalsocreatesvariousreportsandanalysis(openitemsreports,agingreportsetc.).Thesereportsaresenttotherespectiveaccount/processowners.Reconciliationreportsarecurrentlydistributedona6-7weeklag.TherearetwotypesofReconciliationsperformed(TimingdifferencereconciliationsieGLtoGL/BankandTotalBalanceverificationi.e.supportbasedaccounts.ForTDRaccounts,99%oftheinputsareelectronic(exceptionsarephysicalcopyofbankstatementsreceived).ForTBVaccounts,48%ofthesupportsarereceivedthrusoft/hardcopy(notthroughsystems).AllMIS&analyticsforkeycustomersandDiversifiedFinancialInstitutionleadershiparepreparedmanuallyusingExcel/Powerpoint.AninitiativetodevelopacommonglobalreconciliationsystemtoenablereconciliationandreportingforallDiversifiedFinancialInstitutionbusinessunitsisunderdevelopment.TheprojectstartedinQ2’02anditisexpectedtobedeployedintheSharedServicesCenter1inQ1’04.SystemSystemOverviewOverviewProcessOverview3DRAFT–CONFIDENTIALNOTTOBEDISTRIBUTEDReconciliations:ApplicationNameVendorNameVersionSupportedbyPlatformPrimaryReconciliationSystemsIn-houseNATechnologyClientServerApplicationIn-houseNATechnologyMainframeDataSourcesandDataFormatManipulationsystemsIn-houseNATechnologyMainframeIn-houseNATechnologyMainframeIn-houseNATechnologyMainframeIn-houseNATechnologyMainframeIn-houseNATechnologyMainframeIn-houseNATechnologyMainframeIn-houseNATechnologyMainframeIn-houseNATechnologyMainframeIn-houseNATechnologyMainframeIn-houseNATechnologyMainframeIn-houseNATechnologyClient-ServerChaseNATechnologyClient-ServerIn-houseNANotechsupportExcelbasedIn-houseNATechnologyMainframeNANAMacros–ExcelbasedMonarch–softwareMicrosoft/Monarchetc.SystemInventory4DRAFT–CONFIDENTIALNOTTOBEDISTRIBUTEDReconciliation:1.DatabaseManagement1.1Preparemonth-endtransactionfiles.1.2CollectGLandTBextract1.3NewAccountSetup3.Upload/UpdateTBVrecs.inReconstep6.PrepareMIS/AnalyticsGARperformsResearch&Clearance?3.6GeneratefinalExhibit&sendtoProcess/AccountOwners4.ConductResearchandClearanceN3.Reconciliationpreparation5.Recs.Review&TrackerUpdate7.Accountingfunction8.UpdateGL.Y3.ReconciliationPreparation3.1Preparedataformatching3.2PerformAutomatchinReconstep3.3PerformManualMatchinReconstep3.4Manualrecs.,settlementanalysis,useofcontrafiles3.5GenerateExhibitsfromReconstepUpdatedGLDistributedMIS/AnalyticsBankStatementsTransactionfilesGLandTBExtracts2.Recinputcollation,creation,formatting,review,validation2.1Collect&createsupportingdocuments2.2OtherDo...
