財務(wù)信息系統(tǒng)設(shè)計方案

PetroChina

RequirementsanddesignofFMISmodifications

FMISenhancementprojectDecember19991財務(wù)信息系統(tǒng)設(shè)計方案第1頁Contents1. Businessrequirements 32. Gapanalysis 103. Overallapproachanddesignprinciples 134. Businessprocessoverview 155. Overviewofsystemchanges 186.Newdatafilesandassociatedprocesses 247.Systemprocessesforconsolidationandreporting 29AppendixA-Reportformats 322SystemDesignforFMISModification2財務(wù)信息系統(tǒng)設(shè)計方案第2頁BusinessrequirementsChapter13財務(wù)信息系統(tǒng)設(shè)計方案第3頁TobeabletodoanIPO,PetroChinaneedtobeabletoproducecertainkeyfinancialreportsToproducethesereports,somechangestoFMISneedstobeimplemented.BusinessrequirementoverviewTheFMISsystemneedtobeabletoproducethefollowingreports:AnnualconsolidationreportsasrequiredbyChinaFinanceMinistrybasedonthePRCGAAPforjoint-stockcompany.QuarterlyconsolidationofreportsoftheoverallListCobasedontheIASisrequiredforpubliclylistedcompanies.DisclosureitemsarealsorequiredbyIASandPRCGAAPforjoint-stockcompany.Someotherinformationisrequiredtosupportannualauditing.Alltheabovereports(excepttheauditinformation)willneedtobeproducedalongthenewPetroChinaorganizationstructureasdescribedinthefollowingpage.Theabovereportingrequirementsaredetailedinthenextpages.4財務(wù)信息系統(tǒng)設(shè)計方案第4頁PetroChinaLevel1PetroChinaLevel2SpecializedCo/BusinessGroupLevel3SegmentLevel4TypeE&P.........Level5BusinessUnits......Gas&PipelineDownstreamOil&GasE&PNaturalgas(inc.gaspipeline)Refining&MarketingPetrochemicals&marketingOthersRefiningPetroChinareportingstructureMarketingR&DChinaoilHQBeijingE&PHuaBeiG&PHuaBeiRefineryHuaBeiNorthChinaPetr.TradeChinaO&GresearchinstituteLevel6OperationsUnitsLevel7SuboperationsUnitsOilfield#1Oilfield#2Oilfield#3District1District2District35財務(wù)信息系統(tǒng)設(shè)計方案第5頁PRCGAAPconsolidationreportrequiresthefollowingdata:BusinessrequirementsforPRCconsolidationIndividualPRCGAAPreportsofallentityinvolvedinconsolidation.Balancesheet(PRCGAAP)IncomestatementCashflowstatementInternaltransactionsreportsInternaltransactionlistInternalproductsalesorpurchasereportInternalrenderingofservicereportorinternalservicepurchasereportInternallong-termequityinvestmentreport,capitalstructurereportInternalpayableorreceivablesRequiredinformationforinternaltransactionsCounterpart,transactiontype,period,beginningbalance,creditamount,debitamount,endingbalance6財務(wù)信息系統(tǒng)設(shè)計方案第6頁TherearetwotypesofchangesthatneedtobemadetocomplywithIASBusinessrequirementsforIASconsolidationPRCconsolidatedfinancialstatementswithspecificdetailsIndividualPRCreportslistedearlierLedgerreportTransactionswithdifferentaccountingtreatmentinIASandPRCGAAPDevelopmentcosts-E&PsegmentspecificCostofsuccessfulwell(succeededintheperiod)Assetsanddepreciation(straightlinemethodvsUOP)andrelatedtaxcreditAssetsclass,accumulateddepreciationamountbasedonreevaluatedcarryingamountbystraightlinemethod;depreciationamountbasedonun-reevaluatedamountbyunitofproductionmethodorstraightlinemethod(dependonassetsclass)Deferredbusinessinitialcost(pre-operationexpenditures)Beginningbalance,endingbalanceMonthlyrevaluationofnon-currentmonetaryassets&liabilities(foreigncurrencyitem)Historicalvalue(calculatedbyexchangerateofoccurringdate),reevaluatedvalueoflong-termloan(foreigncurrency),long-termdeposit(foreigncurrency),otherlong-termmonetaryassetsorliabilities.7財務(wù)信息系統(tǒng)設(shè)計方案第7頁IASandPRCGAAPrequiresthefollowingitemsfordisclosurepurpose:BusinessrequirementsfordisclosurepurposesAgingreportofaccountsreceivable(PRCGAAP)Long-termequityinvestment(PRCGAAP)

Investee,stocktype,sharenumberofstock,sharepercentage,amount,remarksLong-termbondinvestment(PRCGAAP)

Bondtype,parvalue,rate,purchasedamount,duedate,interestofthisyear,accumulatedinterest,remarksOthernon-equitylong-terminvestment(PRCGAAP)

Debtor,principal,rate,duedate,interestincomeofcurrentperiod,accumulatedinterest,remarksLong-termloan(PRCGAAP)

Loaner,amount,duedate,rate,term

(Ifforeignloan)Foreigncurrencyamount,RMBamountbyexchangerateofbalancesheetdateBondspayable(PRCGAAP)

Bondname,parvalue,issueddate,issuedamount,duedate,interestexpenseofcurrentyear,accumulatedinterestRelatedpartytransactions(PRCGAAP&IAS)

Alldatalistedininternaltransactionreports,onlydifferententitynameIncomeanalysisreport(IAS)

Specialdeductionsrelatingtoexplorationandproductionactivities,Incomenotsubjecttotax;ExpensesnotdeductiblefortaxpurposesMovementofallowancefordoubtfulaccounts

Balanceatbeginningofperiod,

Provision,Deductions,

BalanceatendofperiodMovementsinallowancefordiminutioninvalueofinventories

Balanceatbeginningofperiod;Provision;Deductions;Balanceatendofperiod MovementreportofPPE&accumulateddepreciationCost:Beginningbalance,additions,disposals,endingbalance;Accumulateddepreciation:Beginningbalance,chargefortheyear,disposals,endingbalanceMovementofallowanceofinvestmentvaluediminution

Beginningbalance;Provision;Deductions;Endingbalance LoansAnalysisReport

Director’sremunerationreport

Salaries,allowancesandotherbenefits

Contributiontoretirementbenefitscheme8財務(wù)信息系統(tǒng)設(shè)計方案第8頁FMISalsoneedtoproducecertaininformationthatisrequiredtofacilitateannualaudit.BusinessrequirementsforannualauditTherequiredinformationforaccountsreceivable,long-termequityinvestment,long-termnon-equityinvestmenthasbeenlistedindisclosurerequirement.Theonlyremainingitemsforannualauditarelistedbelow:Short-terminvestment

Investmenttype,investee,securitytype,parvalue,historicalcost,rate,duedate,interestreceivableordividendsreceivable,premium/discountanditsamortisationNotesreceivable

Notestype,parvalue,rate,drawer,duedateOtherreceivable

Debtor,amount,postduedaysAssetsrevaluation

Assetsclass,bookvaluebeforerevaluation,bookvalueafterrevaluationShort-termloan

Loaner,amount,rate,duedateNotespayable

Owner,parvalue,rate,duedate9財務(wù)信息系統(tǒng)設(shè)計方案第9頁GapanalysisChapter210財務(wù)信息系統(tǒng)設(shè)計方案第10頁ChangesinfinancialreportingprocessPetroChinaneedstoimplementalargescalechangeinitsfinancialreportingprocess.CurrentConsolidationisdonebytheauditorsusingspreadsheetsandmanualdatacollectionandmanipulationFMISreportisnotcompliantwithPRCaccountingstandardforjoint-stockcompany.IASreportisproducedbytheauditorsusingmanualmethodReportingisdoneforthewholeCNPCwiththecurrentorgstructure

UsecurrentchartofaccountsFutureConsolidationwillbedonebyPetroChinaaccountantsaspartoftheregularaccountingprocessusingFMISFMISreportwillbecompliantwithPRCaccountingstandardforjoint-stockcompany.ASreportisproducedbyPetrochinaaccountantsusingFMISReportingstructureforPetroChinawillbeseparatedfromtheoldCNPC.NeworgstructurewillbeputinplaceNewchartofaccountswillbeineffect11財務(wù)信息系統(tǒng)設(shè)計方案第11頁SystemsissuesThefollowingsystemsissuesareidentifiedascriticaltotheabilityforPetroChinatobeabletodoconsolidationandproducetherequiredreportsREQUIREMENTReconciliationoftransactionsthatoccursacrossdifferentaccountingentities.

Somedetailedinformationneedtobepassedupthecorporatereportingstructure.SYSTEMISSUEThisisdifficulttodowiththecurrentFMISsinceFMIStreatseachaccountingentityasindependentfromotheraccountingentities.ThisisnotpossibleinthecurrentFMISsinceFMISonlytransferreports,notdetailedinformation.CONSOLIDATIONPROCESSREQUIREMENTIASreporthavesomedifferentgroupingofaccountscomparedtoPRCreports

Intheinterim,CNPCrequiresreportingbasedonlocationsinadditiontothe“normal”reportingprocedurealongsegmentDisclosureitemsneedtobeproducedandrolledupSYSTEMISSUECurrentFMISaggregatesreportupthehierarchyanditisnotpossibletoseeorreconstructtheindividualaccounts,thereforeitisnotpossibletoregroupaccountsathigherlevel.CurrentlyFMISreportinghierarchyfollowsastricttreepatternwithoneentityreportingtoonlyoneparent.CurrentFMIScannotproducethisdatanorrollitupREPORTINGPROCESS12財務(wù)信息系統(tǒng)設(shè)計方案第12頁OverallapproachanddesignprinciplesChapter313財務(wù)信息系統(tǒng)設(shè)計方案第13頁Designprinciples/goalsThedesignhastobeimplementablepriortotheIPOModifiedFMISmustbeabletoproduceallrequiredreportswithminimalmanualworkAvoidmajorchangesinbusinessprocessAvoidmajorchangesinFMISwhichneedslongdevelopmenttimeand/orhighriskofdestabilizingFMISMarginalchangestoFMISispreferredtomarginalchangeinbusinessprocessChangesinbusinessprocessorFMISshouldhaveminimaldependencyonshort-termimprovementtoITinfrastructure.Duetocurrentlimitationsintelecommunication,theamountofdatathatneedstobetransferredshouldbeminimized.Toeasetransition,themodifiedFMISneedtohavedatacompatibilitywithcurrentFMISThefollowingprincipleshavebeenfollowedincreatingthedesignforthenewsystem:14財務(wù)信息系統(tǒng)設(shè)計方案第14頁BusinessprocessoverviewChapter415財務(wù)信息系統(tǒng)設(shè)計方案第15頁LocationLevel5SegmentLevel3HQCorpLevel1LgrLgrLgr+Lgr+IASIASPRCSegmentASegmentBElimElimPRCElimIASElimIASElimIASLgr+Lgr+IASIASElimIASElimIASIASDifferentsegment,differentlocationSamesegment,differentlocationSamesegment,samelocationDifferentsegment,samelocationLEGENDLedgersReportsModifiedreport/consldtnsystemConsolidationentryConsolidationfileDataflowdiagramofrollupprocessPRCPRCLgrLgrNotes:Lgr+=ledgerreportplussomeother specialreports.16財務(wù)信息系統(tǒng)設(shè)計方案第16頁Rollupandconsolidationprocesschart1.1EntertransactionsforLevel6HO1.5Entersame-segment,same-locationeliminationentries1.4Importreportsfromlevel6HOledgers1.2CreatereportsforLevel6HOledgers1.3Receivereports&importdatafromlevel7(district)1.8ProduceIASadjustmentfile(IASfile)1.7ProduceBUsegmentPRCreport1.6DetermineIASadjustments1.9SendPRCBUsegmentreportandIASfiletoBeijingBusinessgroupFinance2.1ReceivePRCreportfromBULocationsegments2.2Enterdifferent-segmentsame-locationeliminationentries2.4Senddifferent-segment,same-locationeliminationfiletoBeijingH.Q.2.3ProduceLocationPRCreport3.1ReceiveBUsegmentPRCreportandIASfile1.10SendPRCreporttoLocationHOfinance3.2Entersame-segment,different-locationseliminationentries3.3Producebus.groupPRCreportandIASadjustedreport4.1ReceivePRC

reportandsegmentIASfile4.2Receivedifferent-segment,same-locationeliminationfiles4.3Enterdifferent-segment,different-locationeliminationentries4.5ProducecorporatePRCreportsandIASreportsBULocationLocationHOFinanceSegmentFinance(Beijing)CorpFinance3.4SendbusinessgroupPRCreportandIASfiletocorp4.4EnterIASadjustments(corporatelevel)Level5Level3Level117財務(wù)信息系統(tǒng)設(shè)計方案第17頁OverviewofsystemchangesChapter518財務(wù)信息系統(tǒng)設(shè)計方案第18頁Dataflowdiagram-TransactionsystemSomechangesarerequiredintheFMISTransactionsystemtocollectrequireddatafromallaccountingentitiesExistingfunctionalityTransactionDBEnteraccountingentriestoFMISProduceLedgerreportT1SpecialdisclosureitemsLedgerreportsfileF2Disclosure&IASsupportingdatafileF1InternaltransactiondatafileNewfunctionalityP4ProducespecialdisclosureitemsreportP2ProduceinternaltransactionsdatafileP3Enterspecialdisclosure&IASsupportdataP1Forinternaltransactions,entercustomer/suppliercode19財務(wù)信息系統(tǒng)設(shè)計方案第19頁Newormodifiedfunctionalities-TransactionsystemNewdatafileF1-InternaltransactiondatafileF2-Disclosure&IASsupportingdatafileNewtablesT1-SpecialdisclosureitemsNewsystemprocessesP1-InternaltransactiondataentryP2-InternaltransactionfileexportP3-Specialdisclosureitems&IASsupportingdataentryP4-Specialdisclosureitems&IASsupportingfileexportChangestoFMISTransactionsystemissummarizedinthefollowinglist:20財務(wù)信息系統(tǒng)設(shè)計方案第20頁F3EliminationdatafileDataflowdiagram-ReportingsystemNewfunctionalityLowerlevelReportsLedgerreportfilesAggregationP7EliminationprocessExistingfunctionalityAggregatedReportsConsolidatedLedgerReportP16Export/printconsolidatedledgerreportT2EliminationF2Disclosure&IASsupportingdatafileF1InternaltransactiondatafileT4InternalTransactionP13ExportremaininginternaltransactionEliminationEntriesInternaltransaction&eliminationreports&queriesAnalyzeinfoanddeterminerequiredeliminationP5Query,view,printP14Exportdisclosures&IASsupportingdataP8ExportEliminationentriesF4IASadjustmententryfileF3EliminationdatafileLedgerreportfilesF2Disclosure&IASsupportingdatafileF1InternaltransactiondatafileF4IASadjustmententryfileP12ExportIASadjustmentP15PrintIASreportsT3IASadjIASadjustmententriesAnalyzeinfoanddeterminerequiredIASadjustmentP9QueryIASadjustmentdataIASadjustmentinforeportsSomemajorchangesarerequiredintheFMISReportingsystemP19ImportinternaltransactionP6EntereliminationentriesP18ImporteliminationentriesP17ImportIASadjustmentsP10EnterIASadjustmentsP15PrintPRCreportsP20Importdisclosure/IASsupportdataT5Consolidationaccountpair21財務(wù)信息系統(tǒng)設(shè)計方案第21頁Newormodifiedfunctionalities-ReportingsystemNewdatafileF1-InternaltransactiondatafileF2-Disclosure&IASsupportingdatafileF3-EliminationdatafileF4-IASadjustmententryfileNewdatatablesT2-EliminationentrytableT3-IASadjustmententrytableT4-InternaltransactiontableT5-ConsolidationaccountpairtableThechangestotheFMISReportingsystemisshowninthefollowinglist:NewsystemprocessesP5-QueryinfoforeliminationP6-EntereliminationentriesP7-EliminationprocessP8-ExporteliminationP9-QueryinfoforIASadjustmentP10-EnterIASadjustmentsP11-IASadjustmentprocessP12-ExportIASadjustmentsP13-ExportremaininginternaltransactionsP14-Exportdisclosure&IASsupportdataP15-PrintIASreportP16-Print/ExportPRCreportP17-ImportIASadjustmentsP18-ImporteliminationentriesP19-ImportinternaltransactionsP20-Importdisclosure/AISsupportdata22財務(wù)信息系統(tǒng)設(shè)計方案第22頁Requirednew/modifiedreportsPRCreport&disclosurerequirement PRCIncomestatementreportmodification PRCBalancesheetmodification PRCCashflowstatementmodification Internaltransactionreport Agingreportofaccountsreceivable Long-termequityinvestmentreport Long-termbondinvestmentreport Otherlong-terminvestmentreport Long-termloanreport Bondspayablereport Relatedpartytransactionreport IASreport&disclosurerequirementIASincomestatementdefinitionIASbalancesheetdefinitionIAScashflowstatementdefinitionStatementofowner'sequityNote4EmployeecompensationcostsNote5interestexpense Note6IncomebeforeincometaxesNote7IncometaxesNote8CashandcashequivalentsNote9AccountsreceivableNote10InventoriesNote11PrepaidexpensesandothercurrentassetsNote12Property,plant,andequipmentNote13InvestmentsNote14IntangibleandotherassetsNote15AccountspayableandaccruedliabilitiesNote16DebtNote17DeferredincometaxesNote22,23,24AuditingrequiredreportsShort-terminvestmentreportNotesreceivablereportOtherreceivablereportShort-termloanreportNotespayablereportInadditiontothesystemchanges,thefollowingreportsmustbedevelopedandproduced23財務(wù)信息系統(tǒng)設(shè)計方案第23頁NewdatafilesandassociatedprocessesChapter624財務(wù)信息系統(tǒng)設(shè)計方案第24頁ReportingsystemTransactionSystemF1-InternaltransactiondatafileandassociatedprocessesP1. Modificationtovoucherentryintransactionsystemneedtobedone.Currentlythetransactiontablehasafieldtorecordcustomer/vendorcodethatisonlyusedforA/RorA/P.Thesystemneedstobemodifiedtomakethecustomer/vendorcodeapplicableforallinternaltransactiontypes.Thesystemshouldmakecustomer/vendorcodeentrymandatoryforallinternaltransactions.P2. Whencounterpartcodesofallinternaltransactionshavebeenrecorded,transactionsystemwillbeabletoexportdataofinternaltransactionsandtransferthedatauptothehigherlevels.P5. Thereportingsystemmusthavefacilitiesforuserstoquery,viewandprinttheinternaltransactiondataandtheeliminationentries.Thisreportisthekeyinputfortheusersintheeliminationprocess.Userscreateeliminationentriesbasedontheinformationcontainedintheinternaltransactiontable.Tofacilitatethecreationofthisreport,tableT5-(Accountpairs)isneededtorecordtheaccount“pairs”fortheoffsetingaccounts.Thisprocessmustalsobeabletoprinteliminationreportwhichcomparestheinternaltransactionswiththeeliminationentriesthathasbeendone.Theeliminationreportmustbereportedtothehigherlevelasacontrolreporttoensurethateliminationsaredoneproperlyatthelevelwhereitisperformed.P13. Aspartoftheconsolidationprocess,thesystemwillfiltertheinternaltransactionsandrolluptheinternaltransactionsinformationthathasnotbeeneliminatedbyignoringalltheinternaltransactionswithintheaccountingentityanditslowerentities,androlluptheremaininginternaltransactionswithoutaggregation.Theinternaltransactiondatafileisakeyinputtotheconsolidationprocess.F1InternaltransactiondatafileP2ProduceinternaltransactionsdatafileP1Forinternaltransactions,entercustomer/suppliercodeTransactionDBT4InternalTransactionP13ExportremaininginternaltransactionInternaltransactionreports&queriesP5Query,view,printInternaltransactiondatafileImportinternaltransactionsT5AccountpairsTABLESTRUCTUREF5-ConsolidationAccountpairSourceacctcodeCounterpartacctcodeT2EliminationFILEFORMAT&TABLESTRUCTURE

F1/T4InternaltransactiondataPeriodCounterpartcodeSourceentitycodedebitBegbalcreditdebitMovementcreditdebitEndBalcreditAccountcode25財務(wù)信息系統(tǒng)設(shè)計方案第25頁F2-DisclosureandIASsupportdatafileandassociatedprocessesP3 ThedisclosuredataandIASsupportingdatawillberecordedtothespecialdisclosuretable(T1).Thispurposeofthistableistocollectdatathatcannotbederivedfromaccountbalances,e.g.UOPvsstraightlinedepreciationinIASadjustment.Althoughdifferentdisclosuretypesarerequiredfordifferenttransactiontypes,thesystemwillusethesametabletostorethedata. Eachfieldinthetablehasdifferentmeaningfordifferentdisclosuretype.Thedisclosuretypesarepre-definedbyPetroChinaheadquarterandclearinstructionstotheaccountingentitiesneedtobegivenaboutwhichdisclosuretypesmustbefilledoutbyeachaccountingentity. FMISshouldbeenhancedto“understand”thedifferentdisclosuretypeandforeachdisclosuretype,thesystemneedstobeabletodisplayaspecialinputscreenforthedisclosuretypetopreventwrongentrytobemadetothedisclosuredatabase.P4 AllrecordeddisclosuredataandIASsupportdatawillbeexportedtoafileandsentup.Thefileisthenimportedtoreportingsystem(P20)andstoredinthereportdatabase.P9 UsersreviewtheIASsupportingdatainreportingsystemtoproducetheIASadjustmententries.P14 AlldetailsofdisclosureandIASsupportingdatareceivedfromlowerlevelinreportingsystemwillbeexportedandsentuptohigherlevelwithoutaggregation.Thisfileisdesignedtocollectnon-ledgerdataforPRC&IASdisclosuresandsupportingdataforusertodoIASadjustment.REPORTINGSYSTEMLowerlevelReportsP14Exportdisclosures&IASsupportingdataDisclosure&IASsupportingdatafilesP9QueryIASadjustmentdataIASadjustmentinforeportsTRANSACTIONSYSTEMT1SpecialdisclosureitemsF2Disclosure&IASsupportingdatafilesP4ProducespecialdisclosureitemsreportP3Enterspecialdisclosure&IASsupportdataP20Importdisclosure&IASsupportFILEFORMAT&TABLESTRUCTUREF2/T1DisclosuresandIASsupportingdataUser-definednum1(number)User-definednum2(number)Disclosurecode…num6User-definedchar1(char.)User-definedchar2(char)….char6(char)Businessentitycode26財務(wù)信息系統(tǒng)設(shè)計方案第26頁F3-EliminationdatafileandassociatedprocessesP6 Thisfunctionletsusersentereliminationentriestotheeliminationtable.Theentrieswillbecheckedandpostedifapproved.Iftheentriesarenotapproved,usercanmodifyitpriortoposting.P8 Theeliminationentrieswillbeusedinconsolidationatthevariouslevels(See7.Systemprocessesforconsolidationandreporting).Toalloweliminationathigherlevels,F3filewillbeexportedandsentuptohigherlevelwithoutanyaggregation.Note:thebusinessentitycodeinthistablereferstothebusinessentitywhichcreatetheeliminationentry.Eliminationentriesareinputandrolledupinconsolidationindifferentlevel.REPORTINGSYSTEMT2EliminationEliminationEntriesInternaltransactionreports&queriesAnalyzeinfoanddeterminerequiredeliminationP8ExportEliminationentriesF3EliminationdatafileP6EnterEliminationEntriesF3EliminationdatafileImportEliminationEntriesFILEFORMAT-F3-EliminationdataTABLESTRUCTURE-T2EliminationDescriptionCreditamountAccountcodeDebitamountPeriodBusinessentitycodeP5Query,view,print27財務(wù)信息系統(tǒng)設(shè)計方案第27頁F4-IASadjustmententryfileandassociatedprocessesP10.TheusercreatesIASadjustmententriesbasedonanalysisofIASadjustmentsupportingdataandtheninputsthedatatoIASadjustmententrytable(T3)inthereportingsystem.Theentrieswillbecheckedbyapproverandiftheyarecorrect,theywillbepostedtodisablefurtherchange.Iftheyarenot,itwillbemodifiedandrechecked.P12.IASadjustmententriesareexportedandrolledupwithoutaggregationtothehigherlevels.TheentrieswillbeusedinIASreporting,basicallyonthehighestlevelsinthecorporationontheoriginallevelTheIASadjustmentfilecollectsdatatofulfillIASadjustmentindifferentlevelandrollituptothecorporatelevelREPORTINGSYSTEMT3IASadj.IASadj.EntriesP12ExportIASadj.entriesF4IASadj.datafileP10EnterIASadj.EntriesF4IASadj.datafileIASreportingprocessAnalyzeinfoanddeterminerequiredIASadjustmentIASadjustmentinforeportsF3/T2IASAdjustmentEntriesFILEFORMAT&TABLESTRUCTUREDescriptionCreditamountAccountcodeDebitamountPeriodBusinessentitycode28財務(wù)信息系統(tǒng)設(shè)計方案第28頁SystemprocessesforconsolidationandreportingChapter729財務(wù)信息系統(tǒng)設(shè)計方案第29頁P9-EliminationprocessandPRCreportingTheeliminationprocessinvolvestwosteps:1) Eliminationentrypreparation-includesstepP6&P8.Thisstephasbeendescribedearlierinthisdocument2) Performtheeliminationofinternaltransactions-stepP7TheresultoftheeliminationprocessisaLedgerreportadjustedbyeliminatingtheeffectofinternaltransactions.Eliminationentryrecorddefinitionis:(accountcode,entrydescription,period,creditamount,debitamount)Toperformtheeliminationoftheinternaltransactions,systemperformthefollowingcalculations: Consolidatedbalanceofoneledgerreportitem=

aggregatedbalanceoftheledgerreportitem

+(-)totalcreditamountofalleliminationentriesfortheitem

-(+)totaldebitamountofalleliminationentriesfortheitem Consolidateddebitamountofoneledgerreportitem=

aggregateddebitamountoftheledgerreportitem

+totaldebitamountofalleliminationentriesfortheitem Consolidatedcreditamountofonereportitem=

aggregatedcreditamountofthereportitem

+totalcreditamountofalleliminationentriesfortheitemTheresultingconsolidatedledgerreport