DEEP DIVE - Reconciliations.FNL.Jul-14-2003.pptVIP免费

1DRAFT–CONFIDENTIALNOTTOBEDISTRIBUTEDFABDeepDiveProcessReviewJune2003Reconciliations2DRAFT–CONFIDENTIALNOTTOBEDISTRIBUTEDReconciliations:PrimaryPrimaryProcessOwnerProcessOwnerShyamaABijapurkarShyamaABijapurkarSecondarySecondaryProcessOwnerProcessOwnerNaveenJainNaveenJainProcessProcessOverviewOverviewReconciliationsisperformedgloballybyateamof244people(May‘03)locatedinFC-East(including2stafflocatedinFC-Central).Theteamreconcilesaccounts,assignsownershipforunreconciledaccountsandreportstheagedstatusofAXPBalanceSheetAccounts.InputstothereconciliationprocessareMonth-endtransactionfiles,bankstatements–electronicandmanual,othersupports,GeneralLedger(GL)extracts,sub-ledgerextractsandtrialbalances.InputsareloadedintoReconstep(thereconciliationsystem)andanautomatchperformed.InadditiontoReconstepEMEArelatedaccounts(atFCC&FCE)arereconciledonWARS.Thesereconciliationsystemsalsocreatesvariousreportsandanalysis(openitemsreports,agingreportsetc.).Thesereportsaresenttotherespectiveaccount/processowners.Reconciliationreportsarecurrentlydistributedona6-7weeklag.TherearetwotypesofReconciliationsperformed(TimingdifferencereconciliationsieGLtoGL/BankandTotalBalanceverificationi.e.supportbasedaccounts.ForTDRaccounts,99%oftheinputsareelectronic(exceptionsarephysicalcopyofbankstatementsreceived).ForTBVaccounts,48%ofthesupportsarereceivedthrusoft/hardcopy(notthroughsystems).AllMIS&analyticsforkeycustomersandAXPleadershiparepreparedmanuallyusingExcel/Powerpoint.AninitiativetodevelopacommonglobalreconciliationsystemtoenablereconciliationandreportingforallAXPbusinessunits(AEFA,TRS&AEB)isunderdevelopment.TheprojectstartedinQ2’02anditisexpectedtobedeployedintheFC-EastinQ1’04.SystemSystemOverviewOverviewReconstep–In-HousedevelopedapplicationWARS-WorldwideAccountReconciliationSystem-usedonlyinEMEAregionTherearealsomultipleapplications,usedforuploadinganddownloadinginformationfrom/tothereconciliationsystems(refertonexttwocolumns).WalkerAXIOMAPIMSSGenesisODBGlobalMAXMillineumFASVisionPlus/GlobestarMARSASSERTCHASERecBuilderFocusExcelProcessOverview3DRAFT–CONFIDENTIALNOTTOBEDISTRIBUTEDReconciliations:ApplicationNameVendorNameVersionSupportedbyPlatformPrimaryReconciliationSystemsReconstepIn-houseNAAETClientServerApplicationWARSIn-houseNAAETMainframeDataSourcesandDataFormatManipulationsystemsWalkerIn-houseNAAETMainframeAXIOMIn-houseNAAETMainframeAPIMSSIn-houseNAAETMainframeGenesisIn-houseNAAETMainframeODBIn-houseNAAETMainframeGlobalMAXIn-houseNAAETMainframeMillenniumIn-houseNAAETMainframeFASIn-houseNAAETMainframeVisionPlus/GlobestarIn-houseNAAETMainframeMARSIn-houseNAAETMainframeASSERTIn-houseNAAETClient-ServerCHASEChaseNAAETClient-ServerRecBuilderIn-houseNANotechsupportExcelbasedFocusIn-houseNAAETMainframeOtherSoftware(MSExcel,Monarch,Macrosetc)NANAMacros–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.UpdateWalkerGL.Y3.ReconciliationPreparation3.1Preparedatafor...