普华永道-中石油财务信息系统设计报告(1).ppt

PetroChinaRequirementsanddesignofFMISmodificationsFMISenhancementproject,December1999,Contents,1.Businessrequirements32.Gapanalysis103.Overallapproachanddesignprinciples134.Businessprocessoverview155.Overviewofsystemchanges186.Newdatafilesandassociatedprocesses247.Systemprocessesforconsolidationandreporting29AppendixA-Reportats32,2,,,SystemDesignforFMISModification,3,Businessrequirements,Chapter1,4,,,TobeabletodoanIPO,PetroChinaneedtobeabletoproducecertainkeyfinancialreports,Toproducethesereports,somechangestoFMISneedstobeimplemented.,Businessrequirementoverview,TheFMISsystemneedtobeabletoproducethefollowingreportsAnnualconsolidationreportsasrequiredbyChinaFinanceMinistrybasedonthePRCGAAPforjoint-stockcompany.QuarterlyconsolidationofreportsoftheoverallListCobasedontheIASisrequiredforpubliclylistedcompanies.DisclosureitemsarealsorequiredbyIASandPRCGAAPforjoint-stockcompany.Someotherinationisrequiredtosupportannualauditing.AlltheabovereportsexcepttheauditinationwillneedtobeproducedalongthenewPetroChinaorganizationstructureasdescribedinthefollowingpage.Theabovereportingrequirementsaredetailedinthenextpages.,5,,,,PetroChina,Level1PetroChina,Level2SpecializedCo/BusinessGroup,Level3Segment,Level4Type,EProvision;Deductions;BalanceatendofperiodMovementreportofPPEEndingbalanceLoansAnalysisReportDirector’sremunerationreportSalaries,allowancesandotherbenefitsContributiontoretirementbenefitscheme,9,FMISalsoneedtoproducecertaininationthatisrequiredtofacilitateannualaudit.,Businessrequirementsforannualaudit,Therequiredinationforaccountsreceivable,long-termequityinvestment,long-termnon-equityinvestmenthasbeenlistedindisclosurerequirement.TheonlyremainingitemsforannualauditarelistedbelowShort-terminvestmentInvestmenttype,investee,securitytype,parvalue,historicalcost,rate,duedate,interestreceivableordividendsreceivable,premium/discountanditsamortisationNotesreceivableNotestype,parvalue,rate,drawer,duedateOtherreceivableDebtor,amount,postduedaysAssetsruationAssetsclass,bookvaluebeforeruation,bookvalueafterruationShort-termloanLoaner,amount,rate,duedateNotespayableOwner,parvalue,rate,duedate,10,Gapanalysis,Chapter2,11,Changesinfinancialreportingprocess,PetroChinaneedstoimplementalargescalechangeinitsfinancialreportingprocess.,,,Current,,ConsolidationisdonebytheauditorsusingspreadsheetsandmanualdatacollectionandmanipulationFMISreportisnotcompliantwithPRCaccountingstandardforjoint-stockcompany.IASreportisproducedbytheauditorsusingmanualReportingisdoneforthewholeCNPCwiththecurrentorgstructureUsecurrentchartofaccounts,Future,ConsolidationwillbedonebyPetroChinaaccountantsaspartoftheregularaccountingprocessusingFMISFMISreportwillbecompliantwithPRCaccountingstandardforjoint-stockcompany.ASreportisproducedbyPetrochinaaccountantsusingFMISReportingstructureforPetroChinawillbeseparatedfromtheoldCNPC.NeworgstructurewillbeputinplaceNewchartofaccountswillbeineffect,12,Systemsissues,ThefollowingsystemsissuesareidentifiedascriticaltotheabilityforPetroChinatobeabletodoconsolidationandproducetherequiredreports,REQUIREMENTReconciliationoftransactionsthatoccursacrossdifferentaccountingentities.Somedetailedinationneedtobepassedupthecorporatereportingstructure.,SYSTEMISSUEThisisdifficulttodowiththecurrentFMISsinceFMIStreatseachaccountingentityasindependentfromotheraccountingentities.ThisisnotpossibleinthecurrentFMISsinceFMISonlytransferreports,notdetailedination.,CONSOLIDATIONPROCESS,REQUIREMENTIASreporthavesomedifferentgroupingofaccountscomparedtoPRCreportsIntheinterim,CNPCrequiresreportingbasedonlocationsinadditiontothe“normal”reportingprocedurealongsegmentDisclosureitemsneedtobeproducedandrolledup,SYSTEMISSUECurrentFMISaggregatesreportupthehierarchyanditisnotpossibletoseeorreconstructtheindividualaccounts,thereforeitisnotpossibletoregroupaccountsathigherlevel.CurrentlyFMISreportinghierarchyfollowsastricttreepatternwithoneentityreportingtoonlyoneparent.CurrentFMIScannotproducethisdatanorrollitup,REPORTINGPROCESS,,,,,,13,Overallapproachanddesignprinciples,Chapter3,14,Designprinciples/goals,ThedesignhastobeimplementablepriortotheIPOModifiedFMISmustbeabletoproduceallrequiredreportswithminimalmanualworkAvoidmajorchangesinbusinessprocessAvoidmajorchangesinFMISwhichneedslongdevelopmenttimeand/orhighriskofdestabilizingFMISMarginalchangestoFMISispreferredtomarginalchangeinbusinessprocessChangesinbusinessprocessorFMISshouldhaveminimaldependencyonshort-termimprovementtoITinfrastructure.Duetocurrentlimitationsintelecommunication,theamountofdatathatneedstobetransferredshouldbeminimized.Toeasetransition,themodifiedFMISneedtohavedatacompatibilitywithcurrentFMIS,Thefollowingprincipleshavebeenfollowedincreatingthedesignforthenewsystem,15,Businessprocessoverview,Chapter4,16,,,,,,,,,LocationLevel5,SegmentLevel3,HQCorpLevel1,,,Lgr,Lgr,Lgr,Lgr,,,IAS,IAS,PRC,SegmentA,SegmentB,Elim,Elim,PRC,ElimIAS,,ElimIAS,Elim,IAS,Lgr,Lgr,,,IAS,IAS,ElimIAS,Elim,IAS,IAS,Differentsegment,differentlocation,Samesegment,differentlocation,Samesegment,samelocation,Differentsegment,samelocation,Dataflowdiagramofrollupprocess,PRC,PRC,Lgr,Lgr,NotesLgrledgerreportplussomeotherspecialreports.,17,Rollupandconsolidationprocesschart,,,,1.1EntertransactionsforLevel6HO,1.5Entersame-segment,same-locationeliminationentries,1.4Importreportsfromlevel6HOledgers,1.2CreatereportsforLevel6HOledgers,1.3ReceivereportsAdjusteddebitamountofonereportitemaccountConsolidateddebitamountofthereportitemaccountTotaldebitamountofalladjustmententries;AdjustedcreditamountofonereportitemaccountConsolidatedcreditamountofthereportitemaccountTotalcreditamountofalladjustmententries3.ProducetheIASreportfromtheIASadjustedtemporaryledgerreport.ThisisdonebycreatingthereportsusingtheIASadjustedtemporaryledgerreportasthesource.AftertheIASreportiscreated,itisrecommendedthatthereportbestoredforlong-termrecordandarchive.,IASreportingprocessisperedbyapplyingIASadjustmententriestotheconsolidatedledgerreport,ConsolidatedLedgerReports,F4IASadjustmentdatafile,F4IASadjustmentdatafile,P12ExportIASadjustment,P15PrintIASreports,T3IASadj,IASadjustmententries,AnalyzeinfoanddeterminerequiredIASadjustment,P9QueryIASadjustmentdata,IASadjustmentinforeports,P10EnterIASadjustments,F2DisclosureIASsupportingdatafile,Lowerlevelreports,32,Reportats,AppendixA,33,ListofReports,EliminationandadjustmententryreportA-1IASadjustmentreportA-5ReceivableagingreportA-6NotesreceivableA-7OtherreceivableA-8Long-termequityinvestmentreportA-9ShortterminvestmentreportA-10LongtermbondinvestmentA-11Othernon-equitylong-terminvestmentA-12NotespayablereportA-13Short/LongtermloanreportA-14BondspayablereportA-15RelatedpartytransactionA-16,