Loading...
HomeMy WebLinkAbout20210119Suez to Staff Attachment-Update 2.xlsRevisions Layout APN ASD bun BUV Dash DEVNAM LYN NvsASD V2020-12-31 NvsAutoDrillOk VY NvsDrillHyperLink https://swfin92prd.unitedwater.com/psp/swf92prd_newwin/EMPLOYEE/ERP/c/REPORT_BOOKS.IC_RUN_DRILLDOWN.GBL?Action=A&NVS_INSTANCE=2189029_2878055 NvsElapsedTime 9.26E-05 NvsEndTime 44210.68 NvsInstLang VENG NvsInstSpec % NvsInstSpec1 , NvsInstSpec2 , NvsInstSpec3 , NvsInstSpec4 , NvsInstSpec5 , NvsInstSpec6 , NvsInstSpec7 , NvsInstSpec8 , NvsInstSpec9 , NvsLayoutType M3 NvsNplSpec %,X,RZF..R00B,CZF..C00B NvsPanelBusUnit V NvsPanelEffdt V1901-01-01 NvsPanelSetid VSHARE NvsReqBU V00060 NvsReqBUOnly VY NvsSheetType M NvsStyleNme UWGenBS.xls NvsTransLed VN NvsTree.ACCT_ROLLUP_01 YNNYN NvsTreeASD V2020-12-31 NvsValTbl.ACCOUNT GL_ACCOUNT_TBL NvsValTbl.BOOK_CODE BOOK_CODE_TBL PED PER RBN RBU RID RTT SCD SCN SFD SFN SFV STAT01 STAT02 STAT03 YY YYYY General Ledger System %,AFT,FDESCR,UDESCR %,AFT,FACCOUNT,UACCOUNT Period Beginning Balance Period Ending Balance Style: UWGNEBS Debits Credits Date: 1) W.A. - changed Query to not have criteria for Ledger and put it in the nVision cell %,FACCOUNT,TUW_ACCOUNT_ALL,XDYNNYY08,NALL_ACCOUNTS CY P0 %,C Period Account GAAP Trial Balance - Actuals Ledger %,QUW_NVS_ACTIVITY_DEBIT_CREDIT,CEXPR5_5,SPER,FBOOK_CODE,VCOMM %,QUW_NVS_ACTIVITY_DEBIT_CREDIT,CEXPR6_6,SPER,FBOOK_CODE,VCOMM %,LACTUALS,UPOSTED_TOTAL_AMT,SPER0,FBOOK_CODE,VCOMM %,LACTUALS,UPOSTED_TOTAL_AMT,SBALP,FBOOK_CODE,VCOMM %,LACTUALS,UPOSTED_TOTAL_AMT,SBAL,FBOOK_CODE,VCOMM %,V10100000 10100000 %,V10600000 10600000 %,V10700000 10700000 %,V10750000 10750000 %,V10800000 10800000 %,V10810000 10810000 %,V10900000 10900000 %,V11100000 11100000 %,V11400000 11400000 %,V11500000 11500000 %,V12100000 12100000 %,V13120000 13120000 %,V13501000 13501000 %,V14200000 14200000 %,V14201000 14201000 %,V14400000 14400000 %,V14605000 14605000 %,V14606000 14606000 %,V14610000 14610000 %,V15000000 15000000 %,V15010000 15010000 %,V15020000 15020000 %,V15030000 15030000 %,V16531000 16531000 %,V16599000 16599000 %,V17300000 17300000 %,V18300000 18300000 %,V18404000 18404000 %,V18608000 18608000 %,V18609000 18609000 %,V18618000 18618000 %,V18620000 18620000 %,V18621000 18621000 %,V18623000 18623000 %,V18625000 18625000 %,V18633000 18633000 %,V18650000 18650000 %,V18653000 18653000 %,V18680000 18680000 %,V18681000 18681000 %,V18698000 18698000 %,V18699000 18699000 %,V18714000 18714000 %,V18718000 18718000 %,V19010000 19010000 %,V19012000 19012000 %,V19013000 19013000 %,V19015000 19015000 %,V19017000 19017000 %,V19101000 19101000 %,V19103000 19103000 %,V19131000 19131000 %,V19132000 19132000 %,V20100000 20100000 %,V20800000 20800000 %,V21600000 21600000 %,V21800000 21800000 %,V21805000 21805000 %,V23200000 23200000 %,V23210000 23210000 %,V23211000 23211000 %,V23220000 23220000 %,V23230000 23230000 %,V23601000 23601000 %,V23610000 23610000 %,V23641000 23641000 %,V23651000 23651000 %,V23661000 23661000 %,V23662000 23662000 %,V23663000 23663000 %,V23667000 23667000 %,V23670000 23670000 %,V23699000 23699000 %,V23711000 23711000 %,V24205000 24205000 %,V24211000 24211000 %,V24213000 24213000 %,V24215000 24215000 %,V24220000 24220000 %,V24245000 24245000 %,V24246000 24246000 %,V24247000 24247000 %,V24248000 24248000 %,V24299000 24299000 %,V24301000 24301000 %,V24306000 24306000 %,V24330000 24330000 %,V25200000 25200000 %,V25200001 25200001 %,V25201000 25201000 %,V25311000 25311000 %,V25316000 25316000 %,V25317000 25317000 %,V25340000 25340000 %,V25380000 25380000 %,V25390000 25390000 %,V25402000 25402000 %,V25500000 25500000 %,V25501000 25501000 %,V26200000 26200000 %,V26310000 26310000 %,V27100000 27100000 %,V27100001 27100001 %,V27100002 27100002 %,V27101000 27101000 %,V27101001 27101001 %,V27101002 27101002 %,V27110000 27110000 %,V28100000 28100000 %,V28203000 28203000 %,V28204000 28204000 %,V28206000 28206000 %,V28211000 28211000 %,V28212000 28212000 %,V28221000 28221000 %,V28251000 28251000 %,V28300000 28300000 %,V28301000 28301000 %,V28302000 28302000 %,V28303000 28303000 %,V28304000 28304000 %,V28305000 28305000 %,V28306000 28306000 %,V28307000 28307000 %,V28308000 28308000 %,V28310000 28310000 %,V28311000 28311000 %,V28312000 28312000 %,V28313000 28313000 %,V28314000 28314000 %,V28350000 28350000 %,V28353000 28353000 %,V28354000 28354000 %,V28355000 28355000 %,V28356000 28356000 %,V28357000 28357000 %,V28358000 28358000 %,V28359000 28359000 %,V28360000 28360000 %,V28363000 28363000 %,V28364000 28364000 %,V28365000 28365000 %,V28405000 28405000 %,V28406000 28406000 %,V28408000 28408000 %,V40105461 40105461 %,V40106461 40106461 %,V40110461 40110461 %,V40111461 40111461 %,V40120461 40120461 %,V40121461 40121461 %,V40130474 40130474 %,V40136461 40136461 %,V40137461 40137461 %,V40140462 40140462 %,V40145463 40145463 %,V40200471 40200471 %,V40245471 40245471 %,V40300474 40300474 %,V40301474 40301474 %,V50000000 50000000 %,V50100600 50100600 %,V50100601 50100601 %,V50100614 50100614 %,V50100620 50100620 %,V50100622 50100622 %,V50100624 50100624 %,V50100630 50100630 %,V50100633 50100633 %,V50100640 50100640 %,V50100642 50100642 %,V50100643 50100643 %,V50100650 50100650 %,V50100660 50100660 %,V50100670 50100670 %,V50100673 50100673 %,V50100675 50100675 %,V50100901 50100901 %,V50100902 50100902 %,V50100903 50100903 %,V50100920 50100920 %,V50105600 50105600 %,V50105611 50105611 %,V50105622 50105622 %,V50105624 50105624 %,V50105631 50105631 %,V50105632 50105632 %,V50105633 50105633 %,V50105642 50105642 %,V50105643 50105643 %,V50105651 50105651 %,V50105652 50105652 %,V50105662 50105662 %,V50105663 50105663 %,V50105664 50105664 %,V50105665 50105665 %,V50105673 50105673 %,V50105675 50105675 %,V50105676 50105676 %,V50105677 50105677 %,V50105901 50105901 %,V50105902 50105902 %,V50105903 50105903 %,V50105920 50105920 %,V50105932 50105932 %,V50110600 50110600 %,V50115600 50115600 %,V50120624 50120624 %,V50120660 50120660 %,V50120901 50120901 %,V50120920 50120920 %,V50125665 50125665 %,V50125903 50125903 %,V50125920 50125920 %,V50300600 50300600 %,V50300611 50300611 %,V50300624 50300624 %,V50300631 50300631 %,V50300632 50300632 %,V50300633 50300633 %,V50300642 50300642 %,V50300651 50300651 %,V50300652 50300652 %,V50300662 50300662 %,V50300663 50300663 %,V50300665 50300665 %,V50300672 50300672 %,V50300673 50300673 %,V50300675 50300675 %,V50300676 50300676 %,V50300677 50300677 %,V50300902 50300902 %,V50300903 50300903 %,V50300932 50300932 %,V50310603 50310603 %,V50310604 50310604 %,V50310624 50310624 %,V50310626 50310626 %,V50310921 50310921 %,V50310931 50310931 %,V50400601 50400601 %,V50400603 50400603 %,V50400624 50400624 %,V50400631 50400631 %,V50400632 50400632 %,V50400633 50400633 %,V50400635 50400635 %,V50400642 50400642 %,V50400643 50400643 %,V50400651 50400651 %,V50400652 50400652 %,V50400662 50400662 %,V50400665 50400665 %,V50400672 50400672 %,V50400673 50400673 %,V50400675 50400675 %,V50400902 50400902 %,V50400903 50400903 %,V50400905 50400905 %,V50400920 50400920 %,V50400921 50400921 %,V50400923 50400923 %,V50400932 50400932 %,V50405903 50405903 %,V50605602 50605602 %,V50610623 50610623 %,V50610643 50610643 %,V50610665 50610665 %,V50620622 50620622 %,V50620626 50620626 %,V50620633 50620633 %,V50620651 50620651 %,V50620665 50620665 %,V50620673 50620673 %,V50620921 50620921 %,V50620930 50620930 %,V50625626 50625626 %,V50625642 50625642 %,V50625643 50625643 %,V50635614 50635614 %,V50635626 50635626 %,V50635640 50635640 %,V50635641 50635641 %,V50635642 50635642 %,V50635652 50635652 %,V50645000 50645000 %,V50645600 50645600 %,V50645601 50645601 %,V50645611 50645611 %,V50645614 50645614 %,V50645620 50645620 %,V50645622 50645622 %,V50645624 50645624 %,V50645631 50645631 %,V50645632 50645632 %,V50645633 50645633 %,V50645642 50645642 %,V50645643 50645643 %,V50645650 50645650 %,V50645651 50645651 %,V50645652 50645652 %,V50645660 50645660 %,V50645662 50645662 %,V50645663 50645663 %,V50645664 50645664 %,V50645673 50645673 %,V50645675 50645675 %,V50645676 50645676 %,V50645677 50645677 %,V50645901 50645901 %,V50645902 50645902 %,V50645903 50645903 %,V50645920 50645920 %,V50645932 50645932 %,V50646000 50646000 %,V50650600 50650600 %,V50650624 50650624 %,V50650626 50650626 %,V50650633 50650633 %,V50650642 50650642 %,V50650650 50650650 %,V50650652 50650652 %,V50650660 50650660 %,V50650661 50650661 %,V50650662 50650662 %,V50650665 50650665 %,V50650673 50650673 %,V50650675 50650675 %,V50650903 50650903 %,V50650905 50650905 %,V50650920 50650920 %,V50650921 50650921 %,V50650923 50650923 %,V50650930 50650930 %,V50650932 50650932 %,V50651660 50651660 %,V50655603 50655603 %,V50655614 50655614 %,V50655631 50655631 %,V50655651 50655651 %,V70100403 70100403 %,V70203408 70203408 %,V70250408 70250408 %,V70700428 70700428 %,V70800430 70800430 %,V70900419 70900419 %,V71000431 71000431 %,V71010431 71010431 %,V71050419 71050419 %,V71051419 71051419 %,V71052419 71052419 %,V71200422 71200422 %,V71251418 71251418 %,V71253426 71253426 %,V71255406 71255406 %,V71257426 71257426 %,V71258426 71258426 %,V80100409 80100409 %,V80150409 80150409 %,V80200410 80200410 %,V80250410 80250410 %,V80400411 80400411 %,V90400904 90400904 %,V90405904 90405904 %,V90850923 90850923 %,V90890426 90890426 %,V90950000 90950000 %,V90950600 90950600 %,V90950601 90950601 %,V90950611 90950611 %,V90950614 90950614 %,V90950620 90950620 %,V90950622 90950622 %,V90950624 90950624 %,V90950631 90950631 %,V90950632 90950632 %,V90950633 90950633 %,V90950642 90950642 %,V90950643 90950643 %,V90950650 90950650 %,V90950651 90950651 %,V90950652 90950652 %,V90950660 90950660 %,V90950662 90950662 %,V90950663 90950663 %,V90950664 90950664 %,V90950673 90950673 %,V90950675 90950675 %,V90950676 90950676 %,V90950677 90950677 %,V90950901 90950901 %,V90950902 90950902 %,V90950903 90950903 %,V90950920 90950920 %,V90950932 90950932 %,V91400924 91400924 %,V91460925 91460925 %,V91500926 91500926 %,V91550926 91550926 %,V91700926 91700926 %,V91800926 91800926 %,V91850000 91850000 %,V91860926 91860926 %,V91900928 91900928 %,V92052930 92052930 %,V92053672 92053672 %,V92064930 92064930 %,V92200620 92200620 %,V92200624 92200624 %,V92200626 92200626 %,V92200632 92200632 %,V92200633 92200633 %,V92200642 92200642 %,V92200651 92200651 %,V92200652 92200652 %,V92200665 92200665 %,V92200673 92200673 %,V92200675 92200675 %,V92200902 92200902 %,V92200903 92200903 %,V92200921 92200921 %,V92200930 92200930 %,V92200932 92200932 %,V92300930 92300930 %,V92600923 92600923 %,V92600932 92600932 Utility Plant in Service Cnstrction Csts Not Classified Construction work in progress CWIP – Suspense Utility Accumulated Depr Retirement work in progress Accumulated Cost of Removal Utility Accumulated Depr -CIAC Utility plant acquisition adj Amort Utility Plant Acquis Adj Non-Utility Property Collections Working Funds Customer AR - CC&B AR Cash Accrual Provision Uncllctble Acct (Cr) IC Money Pool Receivable Utility Money Pool Receivable SW IC Receivable (net) Capital&Maint Inv Nonexempt Small Repairs Inventory Exempt Other Inventory Chemical Inventory Prepaid General Insurance Prepaid Expenses-Other Unbilled Revenue Prelim Survey and Inv. Chrgs Clearing - Capital Work Order COR Regulatory Assets Deferred Emplyee Benefits-Othr Deferred Unamort Debt Exp Deferred Tank Painting Expense Dfrrd Relocation Exp - Approve Deferred AFUDC Equity Gross Up Deferred Pwr Costs - Approved Deferred AFUDC Equity Reg Defrrd Tank Pnting - Amort Dfrrd AFUDC Eq Gross-Up Amort. Deferred rate charges Deferred State Tax Charges Other Reg Assets- Acquisitions Other Regulatory Assets Deferred Power Costs - Pending Cloud Computing Arrangements Def. Federal Inc Taxes- Other Def State Income Taxes- Other Def FIT - ROU Assets Def SIT - ROU Assets Def Fed NOL Tax Benefit Def. FIT-FAS109 ITC Def. FIT-F71/F109 G/U ITC Def.SIT-FAS109 ITC Def. SIT-F71/F109 G/U ITC Common Stock Issued Additional Paid-in Capital RE - Cumulated Income AOCI - Pension AOCI - PBOP Accounts Payable Accounts Payable Reversing Accounts Payable Non Reversing AP - Inventory Accrued AP - Lease Clearing Property Taxes Accrued Franchise taxes Accrued Federal Income Tax Accrued State Income Tax Accrued FICA Tax Accrued Federal Unemployment Tax Accr State Unemployment Tax Accrued FICA Tax Accrued – Deferral Sales & Use Taxes Accrued Other Accrued Taxes Accrued Interest Accrued - Payroll Accrued Insurance Accrued IBNR Accrued - Power Accrued - Sludge Removal Accrued - Vacation Accrued - Bonus Accrued - Employee Related Accr - Employee Related Other Accrued Other Employee W/hg-401K Employee withholding – PAC Employee Withholding- Other Advances for Construction CWIP non-taxable advances Taxable Advncs/Servce Laterals Pension Regulatory Account Regulatory Liab-Tax NewFedRate Reg Liab-NewFedRate2018portion PBOP Liability - Trustee Other Deferred Credits Accrued SE LTIP DefRegLiab F71/F109-Fed:ITC Deferred ITC Deferred State ITC Idaho Injuries and Damages Reserve Pension Accrued Contribution in Aid of Cnstrct CWIP non-taxable CIAC In Service non-taxable CIAC Taxable CIAC - Serv Laterals CWIP taxable CIAC In Service taxable CIAC Accumulated Amortization CIAC Def. FIT- Accelerated Amort Def. FIT-MACRS Def SIT-MACRS Def. FIT- OCI Pension/PBOP Def. FIT Benefit on DSIT Def SIT - Utility Def FIT - COR Def SIT - COR Def. FIT-Other Def. FIT-Tank Painting Def. FIT-Rate Expenses Def. FIT-Deferred Charges Def. FIT-Relocation Expense Def. FIT-M_S Fees Def. FIT-Pensions Def. FIT-PEBOP Def. FIT-Cost of Removal Def. FIT-Uncollectibles Def. FIT-Injuries and Damages Def. FIT - AFUDC Equity Def. FIT - AFUDC Equity GU Def. FIT - AFUDC Equity GU-TRF Def. SIT- Other Def. SIT - Tank Painting Def. SIT-Pensions Def. SIT-Post Retrmnt Benefits Def. SIT-AFUDC Equity Def. SIT-Excess Depreciation Def. SIT- Cost of Removal Def. SIT- Relocation Def. SIT- OCI Pension/PBOP Def. SIT -Shared Services Fees Def. SIT - AFUDC Equity GU Def. SIT - AFUDC Equity GU-TRF Def FIT - New Federal Tax Rate Def FIT-New Federal TaxRate GU Def FIT-Tax Reform for GU2018 Meter Sale-Residential consump Meter Sale-Residential facili Meter Sale-Commercial consump Meter Sale-Commercial facility Meter Sale-public auth consump Meter Sale-public auth fac Surcharges Meter Sale–Const Mtr–Consump Meter Sale–Const Mtr–Fac Chgs Private Fire protection facili Public Fire protection facilit Miscellaneous service revenue Turn on fees Reg Unbill consumption revenue Reg Unbill facility charge rev Payroll Clearing Supv Lbr-SOS Ops Sup & Eng Supv Lbr-SOS Ops Lbr & Exp Supv Lbr-SOS Maint Wlls&Spr Supv Lbr-Pump Ops Sup & Eng Supv Lbr-Pump Ops Pwr Prd Lbr Supv Lbr-Pump Ops Lbr & Exp Supv Lbr-Pump Maint Sup&Eng Supv Lbr-Pump Maint Equip Supv Lbr-Wtr Tmt Ops Sup&Eng Supv Lbr-Wtr Tmt Ops Lbr&Exp Supv Lbr-Wtr Tmt Ops Misc Exp Supv Lbr-Wtr Tmt Maint Sup&Eng Supv Lbr-T&D Ops Sup&Eng Supv Lbr-T&D Maint Sup &Eng Supv Lbr-T&D Maint - Main Supv Lbr-T&D Maint - Services Supv Lbr-Cust Acct Suprvsn Supv Lbr-Cust Acct Mtr Rdng Supv Lbr-Cust Acct Rcrds&Coll Supv Lbr-A&G Ops Salaries Drct Lbr-SOS Ops Sup & Eng Drct Lbr-SOS Maint Strctrs Drct Lbr-Pump Ops Pwr Prd Lbr Drct Lbr-Pump Ops Lbr & Exp Drct Lbr-Pump Maint Strctrs Drct Lbr-Pump Maint Pwr Prd Drct Lbr-Pump Maint Equip Drct Lbr-Wtr Tmt Ops Lbr&Exp Drct Lbr-Wtr Tmt Ops Misc Exp Drct Lbr-Wtr Tmt Maint Strct Drct Lbr-Wtr Tmt Maint Equip Drct Lbr-T&D Ops Line Ex Drct Lbr-T&D Ops Meter Exp Drct Lbr-T&D Ops Cust instl Drct Lbr-T&D Ops Misc Ex Drct Lbr-T&D Maint - Main Drct Lbr-T&D Maint - Services Drct Lbr-T&D Maint - Meters Drct Lbr-T&D Maint - Hydrants Drct Lbr-Cust Acct Suprvsn Drct Lbr-Cust Acct Mtr Rdng Drct Lbr-Cust Acct Rcrds&Coll Drct Lbr-A&G Ops Salaries Drct Lbr-A&G Maint Plnt S L T-SOS Ops Sup & Eng D L T-SOS Ops Sup & Eng S L T out-Pump Ops Lbr & Exp S L T out-T&D Ops Sup&Eng S L T out-Cust Acct Suprvsn S L T out-A&G Ops Salaries D L T out-T&D Ops Misc Ex D L T out-Cust Acct Rcrds&Coll D L T out-A&G Ops Salaries Material-SOS Ops Sup & Eng Material-SOS Maint Strctrs Material-Pump Ops Lbr & Exp Material-Pump Maint Strctrs Material-Pump Maint Pwr Prd Material-Pump Maint Eq Material-Wtr Tmt Ops Lbr&Exp Material-Wtr Tmt Maint Strct Material-Wtr Tmt Maint Equip Material-T&D Ops Line Ex Material-T&D Ops Meter Exp Material-T&D Ops Misc Ex Material-T&D Maint Rsrvrs&Stn Material-T&D Maint - Main Material-T&D Maint - Services Material-T&D Maint - Meters Material-T&D Maint - Hydrants Material-Cust Acct Mtr Rdng Material-Cust Acct Rcrds&Coll Material-A&G Maint Plnt Rent-SOS Ops Misc Rent-SOS Ops Rent-Pump Ops Lbr & Exp Rent-Pump Ops Misc Exp Rent-A&G Ops Off Suppl&Exp Rent-A&G Ops Out Servs-SOS Ops Lbr & Exp Out Servs-SOS Ops Misc Out Servs-Pump Ops Lbr & Exp Out Servs-Pump Maint Strctrs Out Servs-Pump Maint Pwr Prd Out Servs-Pump Maint Eq Out Servs-Wtr Tmt Lab Testing Out Servs-Wtr Tmt Ops Lbr&Exp Out Servs-Wtr Tmt Ops Misc Exp Out Servs-Wtr Tmt Maint Strct Out Servs-Wtr Tmt Maint Equip Out Servs-T&D Ops Line Ex Out Servs-T&D Ops Misc Ex Out Servs-T&D Maint Rsrvrs&Stn Out Servs-T&D Maint - Main Out Servs-T&D Maint - Services Out Servs-Cust Acct Mtr Rdng Out Servs-Custr Acct Rcrds&Col Out Servs-Cust Acct Misc Exp Out Servs-A&G Ops OffSuppl&Exp Out Servs-A&G Ops Out Servs-A&G Maint Plnt Print & Postage-Cust Acct Rcrd Prchsd Wtr-SOS Ops Prchsd Pwr-Pump Ops Fuel Pwr Prchsd Pwr-Wtr Tmt Ops Misc Prchsd Pwr-T&D Ops Misc Ex Utilities-Pump Ops Pwr Prd Lbr Utilities-Pump Ops Misc Exp Utilities-Pump Maint Eq Utilities-Wtr Tmt Maint Strct Utilities-T&D Ops Misc Exp Utilities-T&D Maint - Main Utilities-A&G Ops Off Suppl Utilities-A&G Misc Sludge Dspsl-Pump Ops Misc Exp Sludge Dspsl-Wtr Tmt Ops Lbr Sludge Dspsl-Wtr Tmt Ops Misc Chmcals-SOS Maint Wlls&Spr Chmcals-Pump Ops Misc Exp Chmcals-Wtr Tmt Ops Sup&Eng Chmcals-Wtr Tmt Ops Lbr&Exp Chmcals-Wtr Tmt Maint Equip Trnsprt Cst-ES Trnsprt Cst-SOS Ops Sup & Eng Trnsprt Cst-SOS Ops Lbr & Exp Trnsprt Cst-SOS Maint Strctrs Trnsprt Cst-SOS Maint Wlls&Spr Trnsprt Cst-Pump Ops Sup & Eng Trnsprt Cst-Pump Ops Pwr Prd L Trnsprt Cst-Pump Ops Lbr & Exp Trnsprt Cst-Pump Maint Strctrs Trnsprt Cst-Pump Maint Pwr Prd Trnsprt Cst-Pump Maint Eq Trnsprt Cst-Wtr Tmt Ops Lbr&Ex Trnsprt Cst-Wtr Tmt Ops Misc Trnsprt Cst-Wtr Tmt Maint Sprv Trnsprt Cst-Wtr Tmt Maint Strc Trnsprt Cst-Wtr Tmt Maint Eq Trnsprt Cst-T&D Ops Sup&Eng Trnsprt Cst-T&D Ops Line Ex Trnsprt Cst-T&D Ops Meter Exp Trnsprt Cst-T&D Ops Cust Instl Trnsprt Cst-T&D Maint - Main Trnsprt Cst-T&D Maint-Services Trnsprt Cst-T&D Maint - Meters Trnsprt Cst-T&D Maint-Hydrants Trnsprt Cst-Cust Acct Suprvsn Trnsprt Cst-Cust Acct Mtr Rdng Trnsprt Cst-Cust Acct Rcrds&Co Trnsprt Cst-A&G Salaries Trnsprt Cst-A&G Maint Plnt Transportation Cost -Trnsfrred Office Exp-SOS Ops Sup & Eng Office Exp-Pump Ops Lbr & Exp Office Exp-Pump Ops Misc Exp Office Exp-Pump Maint Eq Office Exp-Wtr Tmt Ops Lbr&Exp Office Exp-Wtr Tmt Maint Sprv Office Exp-Wtr Tmt Maint Equip Office Exp-T&D Ops Sup&Eng Office Exp-T&D Ops Strg Faclt Office Exp-T&D Ops Line Ex Office Exp-T&D Ops Misc Ex Office Exp-T&D Maint - Main Office Exp-T&D Maint-Services Office Exp-Cust Acct Rcrds&Col Office Exp-Cust Acct Misc Exp Office Exp-A&G Ops Salaries Office Exp-A&G Ops Off Suppl Office Exp-A&G Accntng & Audtn Office Exp-A&G Ops Misc Gen Office Exp-A&G Maint Plnt Advertising Exp-A&G Misc Exp-SOS Ops Misc Misc Exp-SOS Maint Wlls&Spr Misc Exp-Pump Maint Strctrs Misc Exp-Wtr Tmt Maint Strct Depreciation - Utility Plant Real Estate Tax Payroll Taxes Amort of Debt Issuance Cost Interest Exp-SWI/Can cons co's Interest income Other interest Other interest – Regulatory AFUDC Gross Up AFUDC Debt AFUDC Equity Gain - Disposition of Property Misc Non Oper Rental Income Non Recoverable Amort of Util Plt Acquis Adj Pension-Other componts of NPPC PBOP-Other components of NPPC Current-federal Current-state Deferred-Federal Income Taxes Deferred-State Income taxes Investment Tax Cr,amortization Bad Dbt-WO-Custr Acct Uncollct Bad Dbt-Provsn-Cust Acct Uncol Corporate Shared Services Fees Corp Shrd Svcs-Non Recoverable F B T-ES F B T-SOS Ops Sup & Eng F B T-SOS Ops Lbr & Exp F B T-SOS Maint Strctrs F B T-SOS Maint Wlls&Spr F B T-Pump Ops Sup & Eng F B T-Pump Ops Pwr Prd Lbr F B T-Pump Ops Lbr & Exp F B T-Pump Maint Strctrs F B T-Pump Maint Pwr Prd Imprv F B T-Pump Maint Eq F B T-Wtr Tmt Ops Lbr&Exp F B T-Wtr Tmt Ops Misc Exp F B T-Wtr Tmt Maint Sup&Eng F B T-Wtr Tmt Maint Strct F B T-Wtr Tmt Maint Equip F B T-T&D Ops Sup&Eng F B T-T&D Ops Line Ex F B T-T&D Ops Meter Exp F B T-T&D Ops Cust Instl F B T-T&D Maint - Main F B T-T&D Maint - Services F B T-T&D Maint - Meters F B T-T&D Maint - Hydrants F B T-Cust Acct Suprvsn F B T-Cust Acct Mtr Rdng F B T-Cust Acct Rcrds&Coll F B T-A&G Salaries F B T-A&G Maint Plnt Liability Insurance-A&G Ops Worker comp-A&G Ops-Inj&Dmages Pension-A&G Ops Post Rtrmnt PBOP-A&G Ops-Pnsn Emplyee Grp Hlth&L-A&G Op-Pnsn Emplyee 401K-A&G Ops-Pension Other Employee Benefits-ES Other Awards-A&G Ops-Emp Pnsns Regulatory Commission-A&G Ops Amort Reloc-A&G Ops-Misc Gen Amort Tnk Pntng-T&D Maint rsrv Amort AFUDC Eq GU-A&G Ops Misc Uni&Sfty Eq-Pump Ops Sup & Eng Uni&Sfty Eq-Pump Ops Lbr & Exp Uni&Sfty Eq-Pump Ops Misc Exp Uni&Sfty Eq-Pump Maint Pwr Prd Uni&Sfty Eq-Pump Maint Eq Uni&Sfty Eq-Wtr Tmt Ops Lbr&Ex Uni&Sfty Eq-Wtr Tm Maint Strct Uni&Sfty Eq-Wtr Tmt Maint Eq Uni&Sfty Eq-T&D Ops Misc Ex Uni&Sfty Eq-T&D Maint - Main Uni&Sfty Eq-T&D Maint-Services Uni&Sfty Eq-Cust Acct Mtr Rdng Uni&Sfty Eq-Cust Acct Rcrds&Co Uni&Sfty Eq-A&G Ops OffSup&Exp Uni&Sfty Eq-A&G Ops Misc Gen Uni&Sfty Eq-A&G Maint Plnt Bank Charges-A&G Ops Misc Gen Other G&A Exp-A&G Outs Srvcs E Other G&A Exp-A&G Maint Plnt UW All Accounts TBCOR100 2020 SUEZ Water Idaho Trial Balance C/M change 2020-12-31 Error 12 00060 December ?8?/?13?/?2012 SUZ-W-20-02 IPUC DR 1 Update 2 Attachment of - - Report ID: Report ID: TBCOR100 Layout ID: Layout ID: TBCOR100 Business Unit: 00060