{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":36,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":344,"n_cols":6,"rows_kept":344,"cut":false,"hidden":false,"merged":[[5,1,5,5]]}
["%,LACTUALS","%,AFT,FACCOUNT,UACCOUNT","%,AFT,FDESCR,UDESCR","%,C","%,LACTUALS,UPOSTED_TRAN_AMT,SPER,FBOOK_CODE,VR","%,LACTUALS,UPOSTED_TRAN_AMT,SBAL,FBOOK_CODE,VR"]
[null,"Columbia Gas of Kentucky Inc"]
[null,"Trial Balance-Reg"]
[null,"Regulatory View"]
[null,"As of November 30, 2020"]
[]
[]
[null,"Account","Account Description","Beginning Balance","Current Period","Ending Balance"]
[]
["%,V10100000","10100000","Plant In Service-Beg Bal",{"$f":"F10-E10","v":514500198.98000002},0,514500198.98000002]
["%,V10100001","10100001","Plant In Service-Additions",44634160.57,5548940.79,50183101.359999999]
["%,V10100002","10100002","Plant In Service-Retirements",-5561503.4500000002,-778208.42,-6339711.8700000001]
["%,V10110000","10110000","Capital Leases-Beg Bal",400000,0,400000]
["%,V10112000","10112000","Right of Use Asset-Beg Bal",653625.02,0,653625.02]
["%,V10112001","10112001","Right of Use Asset-Additions",461503.35,48901.520000000004,510404.87]
["%,V10112002","10112002","Right of Use Asset-Retirements",-530133.56000000006,-20316.11,-550449.67000000004]
["%,V10112004","10112004","Right of Use Asset-Amort",80609.11,3962.3,84571.41]
["%,V10140001","10140001","Cloud Plant in Svc-Additions",444584.73,87.58,444672.31]
["%,V10600000","10600000","Comp Constr Not Class Beg Bal",25494536.100000001,0,25494536.100000001]
["%,V10600003","10600003","Comp Const not Class Other",-6997872.0899999999,7249017.4900000002,251145.4]
["%,V10700000","10700000","CWIP-Beg Balance",6796654.0499999998,0,6796654.0499999998]
["%,V10700001","10700001","CWIP-Additions",54791846.43,5918114.9500000002,60709961.380000003]
["%,V10700003","10700003","CWIP-Other Changes",-37636288.479999997,-12797958.279999999,-50434246.759999998]
["%,V10740001","10740001","Cloud CWIP-Additions",672477.62,28733.87,701211.49]
["%,V10740003","10740003","Cloud CWIP-Oth Changes",-444584.73,-87.58,-444672.31]
["%,V10800000","10800000","Accum Deprec Plant -Beg Bal",-158204680.40000001,0,-158204680.40000001]
["%,V10800001","10800001","Accum Deprec Plant-Additions",-11166971.33,-1151408.4099999999,-12318379.74]
["%,V10800002","10800002","Accum Deprec Plant-Retiremnt",4677890.9400000004,770904.92,5448795.8600000003]
["%,V10800003","10800003","Accum Deprec Plant-Other Chg",2447221.6599999997,196703.31,2643924.9699999997]
["%,V10800010","10800010","Retirement WIP-Beg Bal",663564.85,0,663564.85]
["%,V10800011","10800011","Retirement WIP-Additions",2445118.79,278329.67,2723448.46]
["%,V10800013","10800013","Retirement WIP-Other Changes",-2488787.4300000002,-196704.19,-2685491.62]
["%,V10800100","10800100","Accum Deprec Cap Lease-Beg Bal",-105785.15000000001,0,-105785.15000000001]
["%,V10800101","10800101","Accum Deprec Cap Lease-Add",-33057.85,-3305.79,-36363.64]
["%,V11100000","11100000","Accum Amortization-Beg Bal",-6072689.5800000001,0,-6072689.5800000001]
["%,V11100001","11100001","Accum Amortization-Additions",-1315509.03,-139047.01999999999,-1454556.05]
["%,V11100002","11100002","Accum Amortization-Retiremnt",883612.51,7303.5,890916.01]
["%,V11140001","11140001","Cloud Accum Amortiz-Additions",-73987.25,-8066.89,-82054.14]
["%,V11401000","11401000","Tang Plant Acq Adj-BegBal",-777092,0,-777092]
["%,V11501000","11501000","Tang Acc Amort Plnt Acq Adj-BB",105592.47,0,105592.47]
["%,V11501010","11501010","Tang Acc Amor Plnt Acq Adj-ADD",21585.9,2158.59,23744.49]
["%,V12310000","12310000","Inv Sub Co-Common Stock",174261,0,174261]
["%,V12310001","12310001","Inv Sub Co-PL",565163.13,-8853.86,556309.27]
["%,V12800000","12800000","Funds Held in Trust",415195.3,42995.33,458190.63]
["%,V13100000","13100000","Cash",231962.83999999997,347345.62,579308.46]
["%,V14200160","14200160","Cust AR-Credit Balances",12022814.07,886294.99,12909109.060000001]
["%,V14200220","14200220","Cust AR-CAB",-4938664.18,283998.03999999998,-4654666.1399999997]
["%,V14200250","14200250","Cust AR-GMB",46407.61,66865.88,113273.49]
["%,V14200260","14200260","Cust AR-Cust Premise Work",154072.66999999998,258537.69,412610.36]
["%,V14300001","14300001","Misc Accts Rec-Other",1028048.52,-1730.74,1026317.78]
["%,V14300018","14300018","Other AR-Billed OSS",96102.5,-96102.5,0]
["%,V14300220","14300220","Other AR-GMB Estimate",2590.8600000000006,2348.87,4939.7300000000005]
["%,V14300240","14300240","Other AR-GTS",1449806.47,25440.78,1475247.25]
["%,V14300270","14300270","Other AR-Retail Service",1561.25,-21.95,1539.3]
["%,V14300290","14300290","Other AR-CNR",557036.75,19248.21,576284.96]
["%,V14300330","14300330","Other AR Choice Trans-Columbia",-3191911.6599999997,-82062.14,-3273973.8]
["%,V14300350","14300350","Other AR Choice Trans-Purchase",502142.75000000006,189397.69,691540.44000000006]
["%,V14300395","14300395","Other AR-CPG Non-Transit Srvcs",74060.14,184.52,74244.66]
["%,V14400000","14400000","Acc Prov for Uncol-Beg Bal",-207653.9,0,-207653.9]
["%,V14400100","14400100","Acc Prov for Uncol-Reserve",-1859386.96,-95596.87,-1954983.83]
["%,V14400150","14400150","Acc Prov for Uncol-Charge-Offs",497965.61,42347.1,540312.71]
["%,V14400200","14400200","Acc Prov for Uncol-Recoveries",-178322.64,-37648.42,-215971.06]
["%,V14400600","14400600","Accm Prov Uncoll-Unbilled",-76226.680000000008,-75240.509999999995,-151467.19]
["%,V14400700","14400700","Accm Prov Uncoll-Misc",-401312.87,0,-401312.87]
["%,V14600000","14600000","AR Assoc Co-Mech",45861.610000000008,61342.82,107204.43000000001]
["%,V14600002","14600002","AR Assoc Co-Misc",37275.08,-27730.080000000002,9545]
["%,V14620000","14620000","Foreign Cash",-10492.08,-13691.99,-24184.07]
["%,V15400000","15400000","Plant Materials-Oth Supplies",296810.83,1897.6000000000001,298708.43]
["%,V15420000","15420000","FabShop LP OH Build Ahead",2042.04,-1954.71,87.33]
["%,V16411000","16411000","Gas Stored-Current-LIFO",47750040.57,-1493879.7,46256160.869999997]
["%,V16500000","16500000","Other Misc Prepayments",-34529.310000000005,-34674.35,-69203.66]
["%,V16503600","16503600","Prepaid Taxes - Other",180712.07,-22634.77,158077.30000000002]
["%,V16520000","16520000","Prepaid-Insurance Affiliate",414832.81000000006,53823.1,468655.91000000003]
["%,V16521000","16521000","Prepaid-Insurance NonAffil",{"$f":"F74-E74","v":987569.55999999994},-83530.7,904038.86]
["%,V16591000","16591000","Prepaid-NC Cloud Cost Incurred",0.22,0.01,0.23]
["%,V17300000","17300000","AR Accrued Revenues",6242408.6900000013,4129372.44,10371781.130000001]
["%,V17302000","17302000","AR Accrd Rev Unbill Exch Gas",705673.54,193932.09,899605.63]
["%,V17401000","17401000","Misc Assets-Exch Gas Receiv",0,642512.9,642512.9]
["%,V17403200","17403200","Misc Assets-Property Tax",951816.7,-475908.33,475908.37]
["%,V18230200","18230200","Reg Asset Cr Bal Transf",439971.28,36747.410000000003,476718.69]
["%,V18230440","18230440","Reg Asset GTI Funding",149447.47,-653.79,148793.68]
["%,V18230450","18230450","Reg Asset EAP",-439971.28,-29313.37,-469284.65]
["%,V18233420","18233420","Reg Asset-Prf Base Rt Adj PBRA",2777792.2800000003,-18667.580000000002,2759124.7]
["%,V18235114","18235114","NC Reg Asset FAS 158 OPEB",2078786.54,-12691.75,2066094.79]
["%,V18235115","18235115","NC Reg Asset FAS158 Pension",5271340.76,-29888.920000000002,5241451.84]
["%,V18235440","18235440","NC Reg Asset Rate Case Non-Cur",1369.94,0,1369.94]
["%,V18235450","18235450","NC Reg Asset Pen NQulfd FAS158",13149.300000000001,-80.17,13069.130000000001]
["%,V18235506","18235506","NC Reg Asset Def Depr Cap Lse",18148.09,187.1,18335.189999999999]
["%,V18235530","18235530","NC Reg Asset COVID Costs",0,11783.94,11783.94]
["%,V18320000","18320000","Oth Prelim Survey B Bal",476567.58,0,476567.58]
["%,V18320001","18320001","Oth Prelim Survey Additions",894290.17,105448.37,999738.54]
["%,V18400100","18400100","Building Clearing",428.35,0,428.35]
["%,V18400101","18400101","Convenience Bill Clearing",609.84,0,609.84]
["%,V18400200","18400200","Car Clearing",-2765.95,963.19,-1802.76]
["%,V18400250","18400250","Truck Clearing",-0.14000000000000001,0.05,-0.09]
["%,V18400275","18400275","Clearing-Fleet",1385.8200000000002,-805.69,580.13]
["%,V18400400","18400400","General Tool Clearing",0.02,-0.04,-0.02]
["%,V18400610","18400610","Clearing-Prem Bill Stmt AllOth",14700,0,14700]
["%,V18400900","18400900","Sand-Gravel Clearing",-4.87,0,-4.87]
["%,V18600200","18600200","Def Debit-Maint and Jobng WIP",484827.82000000007,46420.480000000003,531248.30000000005]
["%,V18600400","18600400","DefDebitCusAdv_DEPPST12-31-99",2951299.07,-44300.61,2906998.46]
["%,V19005000","19005000","ADIT-Other-Noncurr-Fed",9428176,-177705,9250471]
["%,V19005100","19005100","ADIT Reg Liability NC - Fed",27905,-1050,26855]
["%,V19005400","19005400","ADIT FIT Gross Up",7028238,-20296,7007942]
["%,V19006000","19006000","ADIT-Other-Noncurr-State",1180637,12042,1192679]
["%,V19006100","19006100","ADIT Reg Liability NC - State",3948,-197,3751]
["%,V19006400","19006400","ADIT SIT Gross Up",2283985,-883,2283102]
["%,V19100100","19100100","Unrecov Purchs Gas Costs-Com",-6167563.54,1353023.33,-4814540.21]
["%,V19100400","19100400","End User Exchange",-142248.83999999997,739236.54,596987.70000000007]
["%,V19100800","19100800","Unrecov Purch Gas Cst-Unbill",-1110921.0699999998,-2232762.75,-3343683.82]
["%,V20100000","20100000","Common Stock-Beg Balance",-23806200,0,-23806200]
["%,V21100000","21100000","APIC Beg Balance",-8951788.6400000006,0,-8951788.6400000006]
["%,V21101020","21101020","APIC Issuances",-6000000,0,-6000000]
["%,V21108000","21108000","APIC Tax Savings Allocation",-66735,0,-66735]
["%,V21600000","21600000","Retained Earnings-Beg Bal",-79931267.599999994,0,-79931267.599999994]
["%,V21600003","21600003","Retained Earnings-Pre Merger",-55928934,0,-55928934]
["%,V22300000","22300000","Adv from Assoc Co-Beg Bal",-142375000,0,-142375000]
["%,V22300010","22300010","Adv from Assoc Co-Issuances",-12000000,0,-12000000]
["%,V22300030","22300030","Adv from Assoc Co-Transfers",0,16000000,16000000]
["%,V22305030","22305030","Curr Adv from Assoc Co-Transfr",0,-16000000,-16000000]
["%,V22700000","22700000","Oblig Und Cap Leas B Bal",-273057.88,0,-273057.88]
["%,V22700002","22700002","Oblig Und Cap Leas NC Transfer",31833.37,3238.84,35072.21]
["%,V22710000","22710000","Oblig Operating Leas Beg Bal",-287619.24,0,-287619.24]
["%,V22710001","22710001","Oblig Operating Leas-NC Issuan",-7864.97,0,-7864.97]
["%,V22710002","22710002","Oblig Operating Leas NC Transf",68293.67,6760.81,75054.48]
["%,V22820000","22820000","Accum Prov Prop Injur Damg",-22500.5,-25,-22525.5]
["%,V22830010","22830010","Accum Prov-Banked Vacation",-487839.14,0,-487839.14]
["%,V22833000","22833000","Accum Provisions FAS 112",-271479.45,-19017,-290496.45]
["%,V22834010","22834010","Accum Provisions OPEB",-2286821.14,-37052.300000000003,-2323873.44]
["%,V22838000","22838000","Accum Provisions Pen Cost Qual",-4365.04,-332,-4697.04]
["%,V22838020","22838020","Accum Prov LT PenCost Non-Qual",-58082.54,-244.75,-58327.29]
["%,V22840030","22840030","NC Payroll Taxes Cares Act",-580384.32000000007,-85633.83,-666018.15]
["%,V23200000","23200000","AP - AP Module Use Only",-3930982.9699999997,-75167.58,-4006150.55]
["%,V23200001","23200001","AP-Misc",-1842137.71,539029.32999999996,-1303108.3799999999]
["%,V23201058","23201058","AP-PNC Land Disbursement",14700.010000000002,-50994,-36293.99]
["%,V23201061","23201061","AP-MellonBank Disbursement_ACH",-661282.91,-295319.62,-956602.53]
["%,V23202300","23202300","AP-Gas Purchases-Producer",-970692.42,250448.78,-720243.64]
["%,V23202400","23202400","AP-Gas Purchases-Transport",{"$f":"F138-E138","v":-1558926.1199999999},-43278.11,-1602204.23]
["%,V23202500","23202500","AP-Choice Marketer Payable",-322292.45,-330680.28999999998,-652972.74]
["%,V23202900","23202900","AP-CPG Non-Transition Srvces",-12133,-500,-12633]
["%,V23400000","23400000","AP Assoc Co-Mech",-2317508.84,-400424.01,-2717932.85]
["%,V23400010","23400010","AP Assoc Co-Interest",-3176667.58,-628810.03,-3805477.61]
["%,V23400030","23400030","AP Assoc Co-Transportation",-11706.78,11706.78,0]
["%,V23400111","23400111","AP Assoc Co-ERS_Only",-67376.77,-32140.14,-99516.91]
["%,V23410000","23410000","Money Pool Borrowings",-25296238.140000001,-4275111.3499999996,-29571349.489999998]
["%,V23410001","23410001","Money Pool Borrowings Int Pay",-2575.44,-2084.7800000000002,-4660.22]
["%,V23500000","23500000","Customer Deposits",-2122257.02,2768,-2119489.02]
["%,V23601000","23601000","Accrd Fed Inc Tax-Current",-1183830.8400000001,0,-1183830.8400000001]
["%,V23602000","23602000","Accrd ST Inc Tax-Current Year",-23588.809999999998,-30953,-54541.81]
["%,V23603200","23603200","Accrd Property Tax",-6102223.54,-4984.9000000000005,-6107208.4400000004]
["%,V23603300","23603300","Accrd Sales and Use Tax",-10205.130000000001,-11818.02,-22023.15]
["%,V23603400","23603400","Accrd Tax-FICA OASDI",-29984.02,0,-29984.02]
["%,V23603700","23603700","Accrued FICA Taxes",-18895.3,-1690.48,-20585.78]
["%,V23604000","23604000","Accrd Unempl Insur-Fed",139.67000000000002,-423.69,-284.02]
["%,V23604100","23604100","Accrd Unempl Insur-State",95.740000000000009,0,95.740000000000009]
["%,V23700010","23700010","Int Accrued-Cust Deposit",-26969.590000000004,-1600.58,-28570.170000000002]
["%,V24103130","24103130","Tax Coll Pay Loc Inc Tx",192.04,0,192.04]
["%,V24103140","24103140","Tax Coll Pay Tx WH OASDI",497.09000000000003,0,497.09000000000003]
["%,V24103300","24103300","Tax Coll Pay Sales and Use Tax",-70973.39,-19819.350000000002,-90792.74]
["%,V24103400","24103400","Tax Coll Pay Util Gross Rcpts",-428387.71,-109031.57,-537419.28]
["%,V24103600","24103600","Tax Coll Pay State-Local Oth",-309.61,-64.13,-373.74]
["%,V24200070","24200070","Accd Liab-Severance",-112619.88,-51536.82,-164156.70000000001]
["%,V24201629","24201629","Accd Liab-Unclaimed AP Checks",-313421.92,392.98,-313028.94]
["%,V24203200","24203200","Accd Liab-Vacation Pay PY",-812882.95,135386.68,-677496.27]
["%,V24203201","24203201","Accd Liab-Vacation Pay CY",-1027541.3400000001,-89915.48,-1117456.82]
["%,V24203305","24203305","Accd Liab-Gross Payroll",-246997.38,-5527.49,-252524.87]
["%,V24204000","24204000","Accd Liab-PR Ded Misc",-32100.27,0,-32100.27]
["%,V24204050","24204050","Accd Liab-PR Ded Wage Attchmt",-1756.68,12,-1744.68]
["%,V24204060","24204060","Accd Liab-PR Ded United Way",-91.670000000000016,-23.32,-114.99000000000001]
["%,V24204070","24204070","Accd Liab-PR Ded PAC",-997.55000000000007,0,-997.55000000000007]
["%,V24204080","24204080","Accd Liab-PR Ded ThrftPlan Pyt",-4107.38,0,-4107.38]
["%,V24204081","24204081","Accd Liab-PR Ded ThrftPlan EE",-37921.930000000008,-1853.27,-39775.200000000004]
["%,V24204082","24204082","Accd Liab-PR Ded Roth401k Plan",-2392.0300000000002,27.36,-2364.67]
["%,V24204090","24204090","Accd Liab-PR Ded FSA Health",-167.32999999999998,55.78,-111.55]
["%,V24204091","24204091","Accd Liab-PR Ded FSA Dep Care",-421.66,-0.01,-421.67]
["%,V24204092","24204092","Accd Liab-PR Ded HSA Benefits",-28098.710000000003,220.38,-27878.33]
["%,V24204140","24204140","Accd Liab-PR Ded Fitness Cent",-30,0,-30]
["%,V24204150","24204150","Accd Liab-PR Ded Parking",-245,0,-245]
["%,V24204210","24204210","Accd Liab-PR Ded Employee Stk",-4255,-4600,-8855]
["%,V24206000","24206000","Accd Liability - Pension ST-NQ",-9100,0,-9100]
["%,V24207000","24207000","Accd Liab-Professional Srvcs",-36213.130000000005,-15156,-51369.130000000005]
["%,V24207020","24207020","Accd Liab-Benefits Admin Fees",-21060.579999999998,-933.58,-21994.16]
["%,V24207500","24207500","Accd Liab-Insurance",-80435.48,0,-80435.48]
["%,V24208000","24208000","Accd Liab-Health Benefits",-164800.47,7405.79,-157394.68]
["%,V24208010","24208010","Accd Liab-Rx Drug",-36644.46,255.82,-36388.639999999999]
["%,V24208020","24208020","Accd Liab-Dental",-21091.120000000003,2725.63,-18365.490000000002]
["%,V24211263","24211263","Accd Liab-ST FAS112",-88087.56,14660,-73427.56]
["%,V24220300","24220300","Accd Liab-Rate Refunds",-14672.27,7015.42,-7656.85]
["%,V24224000","24224000","Customer AR Credit Balances",-12179929.07,-867109.99,-13047039.060000001]
["%,V24240050","24240050","Accd Liab-Shipper Gas",-3032324.16,-1095569.8400000001,-4127894]
["%,V24250110","24250110","Accd Liab-Heatshare Cust Cntri",0,-1401,-1401]
["%,V24250160","24250160","Accd Liab-Gas Supply Cr Dep",-25000,0,-25000]
["%,V24300000","24300000","Oblig Cap Leases Curr-Beg Bal",-36899.58,0,-36899.58]
["%,V24300002","24300002","Oblig Cap Leases Curr-Payments",30652.37,3118.69,33771.06]
["%,V24300003","24300003","Oblig Cap Leases Curr-Transfer",-31833.37,-3238.84,-35072.21]
["%,V24310000","24310000","Oblig Operating Lease Curr-BB",-400096.45,0,-400096.45]
["%,V24310001","24310001","Oblig Operating Lease Curr-Add",-453249.67,-48901.520000000004,-502151.19]
["%,V24310002","24310002","Oblig Operating Lease Curr-Pay",487888.8,51283.08,539171.88]
["%,V24310003","24310003","Oblig Operating Lease Curr-Trn",-68293.650000000009,-6760.81,-75054.460000000006]
["%,V25200000","25200000","Custmr Advn for Constr NonCur",-2939154.1500000004,76270.490000000005,-2862883.66]
["%,V25400450","25400450","Reg Liab Curr-Other",-65091.210000000006,-6626.95,-71718.16]
["%,V25401000","25401000","Reg Liab Curr-Inc Tax Fed/St",{"$f":"F202-E202","v":-1106351},0,-1106351]
["%,V25401350","25401350","Reg Liab Curr-DSM Uncollect",-166125.29,-58049.23,-224174.52000000002]
["%,V25402400","25402400","Reg Liab Curr-Asset Reclass",-439971.28,-36747.410000000003,-476718.69]
["%,V25402900","25402900","Reg Lia Curr-AMRP",-943556.46,-11277.77,-954834.23]
["%,V25405000","25405000","Reg Liab NC-Inc Tax Fed-St",-37223756.18,85515,-37138241.18]
["%,V25405050","25405050","Reg Liab NC-Deferred ITC",-33143.600000000006,1247,-31896.600000000002]
["%,V25407150","25407150","Reg Liab NC-BA Lost Credits",0,-75295,-75295]
["%,V25500000","25500000","Investment Tax Credit-ITC",-54161,2037,-52124]
["%,V28205000","28205000","Fed ADIT-Property",-55186823,-323921,-55510744]
["%,V28206000","28206000","St ADIT-Property",-10885650,-106812,-10992462]
["%,V28305000","28305000","Fed ADIT-Other NC",-603048,122941,-480107]
["%,V28306000","28306000","ST ADIT-NC Other",-151140,30814,-120326]
["%,V40300000","40300000","Dep Exp",11150245.520000001,1161004.1100000001,12311249.630000001]
["%,V40430000","40430000","Amortization Exp-Other",383706.5,38424.81,422131.31]
["%,V40434000","40434000","Cloude Amortizaiton Expense",73987.25,8066.89,82054.14]
["%,V40500000","40500000","Amortization of Oth Plant",931802.53,100622.21,1032424.74]
["%,V40813100","40813100","Tax Exp-License_Franchise",2505,0,2505]
["%,V40813200","40813200","Tax Exp-Property",4932721.6099999994,493272.16000000003,5425993.7699999996]
["%,V40813300","40813300","Tax Exp-Sales and Use Tax",-0.03,-0.01,-0.04]
["%,V40814100","40814100","Tax Exp-Payroll-Incentive",-48193.66,0,-48193.66]
["%,V40814500","40814500","Tax Exp-Payroll FICA-OASDI",585613.53,51171.41,636784.94000000006]
["%,V40814600","40814600","Tax Exp-Payroll FICA-Medicar",140677.72999999998,13453.98,154131.71]
["%,V40814700","40814700","Tax Exp-FUTA Employer",5784.63,7.0000000000000007E-2,5784.7]
["%,V40814800","40814800","Tax Exp-SUTA Employer",4492.7699999999995,0.09,4492.8599999999997]
["%,V40911000","40911000","Util Cur Fed Exp",-206608,-60973,-267581]
["%,V40912000","40912000","Util Cur ST Exp",-388966,15671,-373295]
["%,V40921000","40921000","Non Util Cur Fed Exp",206608,60973,267581]
["%,V40922000","40922000","Non Util Cur ST Exp",51781,15282,67063]
["%,V41011000","41011000","Util Def Fed Exp-Dr",5628059,403813,6031872]
["%,V41012000","41012000","Util Def ST Exp-Dr",1468869,109577,1578446]
["%,V41111000","41111000","Util Def Fed Exp-Cr",-3936456,-82030,-4018486]
["%,V41112000","41112000","Util Def ST Exp-Cr",-639461,-53055,-692516]
["%,V41121000","41121000","Non Util Def Fed Exp-Cr",-37487,0,-37487]
["%,V41141000","41141000","Def Inc Tax-Fed-Cr-Util ITC",-20370,-2037,-22407]
["%,V41700000","41700000","Non Util Revenues",-213556.97,-15244.52,-228801.49]
["%,V41715000","41715000","Non Util Operating Exp",-8216.83,-248.09,-8464.92]
["%,V41810000","41810000","Affil Equity in Earngs of Subs",-41659.31,8853.86,-32805.449999999997]
["%,V41910000","41910000","Allow for Other FUDC",-105903.10999999999,-83639.820000000007,-189542.93]
["%,V42101450","42101450","Gas Cost Recovery Initiatives",-841028.57000000007,-220574.03,-1061602.6000000001]
["%,V42110000","42110000","Gain on Disposition of Asset",-0.03,0,-0.03]
["%,V42121000","42121000","Loss on Disposition of Asset",3.2300000000000004,0.88,4.1100000000000003]
["%,V42500000","42500000","Misc Amortization",-21585.9,-2158.59,-23744.49]
["%,V42610000","42610000","Other Inc_Exp-Donations",17596.420000000002,0,17596.420000000002]
["%,V42630000","42630000","Penalties-Others",219521.92000000001,-4000,215521.92000000001]
["%,V42640000","42640000","Oth Inc_Exp Political Contrib",4708.33,0,4708.33]
["%,V42654000","42654000","Other Misc Exp Deduction",249.79,0,249.79]
["%,V42655000","42655000","Other Income Deductions",135217.06,16542.87,151759.93]
["%,V43000000","43000000","Int on Debt to Assoc Co",6205555.7800000003,628810.03,6834365.8100000005]
["%,V43002000","43002000","Int on Debt to Assoc Co MonyPl",91553.15,4660.22,96213.37]
["%,V43100000","43100000","Other Interest Exp",-17918.059999999998,-11783.94,-29702]
["%,V43105100","43105100","Oth Int Exp-Cust Deposits",31899.730000000003,2895.57,34795.300000000003]
["%,V43200000","43200000","Allow for Borrowd FUDC",-191882.90000000002,63817.16,-128065.74]
["%,V48000000","48000000","Residential Sales",-60517843.5,-4607847.26,-65125690.759999998]
["%,V48000100","48000100","Residential Sales Norm",109860.16,-4290.32,105569.84]
["%,V48101000","48101000","Commercial Gas Sales",-23931509.310000002,-1791191.3599999999,-25722700.670000002]
["%,V48101200","48101200","Commercial Gas Sales Norm",51904.66,-2483.2600000000002,49421.4]
["%,V48102000","48102000","Industrial Gas Sales",-1201471.25,-104647.95,-1306119.2]
["%,V48102300","48102300","Industrial Gas Sales Norm",2520.89,-241.85,2279.04]
["%,V48103000","48103000","Gas Sales-Other",-135.24,0,-135.24]
["%,V48300000","48300000","Sales for Resale-Gas",-59408.350000000006,-3075.2000000000003,-62483.55]
["%,V48700000","48700000","Forfeited Discounts-Gas",-171389.48,-52.77,-171442.25]
["%,V48800000","48800000","Misc Service Revenues-Gas",-47384.45,-3147.4700000000003,-50531.92]
["%,V48930000","48930000","Transp Rev Distr Residential",-6900298.4399999995,-560958.82000000007,-7461257.2599999998]
["%,V48930200","48930200","Unbilled Residential Trans Vol",400229.8,-134706.79999999999,265523]
["%,V48930300","48930300","Unbilled Res Trans Cust chrg",{"$f":"F266-E266","v":16624},-2288,14336]
["%,V48931000","48931000","Transp Rev Distr Commercial",-7190170.8200000003,-644946.62,-7835117.4400000004]
["%,V48931300","48931300","Unbilled Comm Trans Vol",234843.68,-106022.3,128821.38]
["%,V48931400","48931400","Unbilled Comm Trans Cust chrg",-1117.25,9653.0400000000009,8535.7900000000009]
["%,V48932000","48932000","Transp Rev Distr Industrial",-4160429.75,-406963.8,-4567393.55]
["%,V48932400","48932400","Unbilled Ind Trans Vol",2632.4900000000002,-1591.8400000000001,1040.6500000000001]
["%,V48932500","48932500","Unbilled Ind Trans Cust chrg",0,-2007,-2007]
["%,V49300000","49300000","Rent from Gas Property",-27910,-2791,-30701]
["%,V49500000","49500000","Other Gas Revenue",-331405.91000000003,-101268.53,-432674.44]
["%,V49500050","49500050","Billed Off System Sales",-332767.53999999998,2500,-330267.53999999998]
["%,V49500485","49500485","Unbilled Residential-Vol",3180788.3200000003,-2712163.49,468624.83]
["%,V49501485","49501485","Unbilled Res Customer Chrg",21820.6,-18416,3404.6]
["%,V49510485","49510485","Unbilled Commercial-Vol",1300371.56,-1000232.76,300138.8]
["%,V49511485","49511485","Unbilled Comm Customer Chrg",14971.150000000001,-16579.990000000002,-1608.8400000000001]
["%,V49520485","49520485","Unbilled Industrial-Vol",1838.0699999999997,-20043.97,-18205.900000000001]
["%,V49521485","49521485","Unbilled Ind Customer Chrg",89.380000000000024,134.07,223.45000000000002]
["%,V80100000","80100000","Natural gas field line purchas",202249.19,27969.7,230218.89]
["%,V80300300","80300300","Short Term Producer Purch",12074213.84,342012.64,12416226.48]
["%,V80300400","80300400","Transportation Pipeline Exp",8670938.120000001,962325.21,9633263.3300000001]
["%,V80300500","80300500","Storage Charges Pipeline Exp",-1990044.9500000002,-208078.73,-2198123.6800000002]
["%,V80300600","80300600","OFS_System Supply Credit",-822023.20000000007,-196432.09,-1018455.29]
["%,V80300808","80300808","Storage Demand",6331022.3700000001,623301.64,6954324.0099999998]
["%,V80400000","80400000","Natural Gas City Gate Purchase",1383340.13,273406.21000000002,1656746.3399999999]
["%,V80510000","80510000","Purchased Gas Cost Adjustments",3256680.2199999997,140502.91,3397183.13]
["%,V80601000","80601000","Exchange Gas-Received",-542573.18000000005,453056.94,-89516.24]
["%,V80720000","80720000","Oper-Purch Gas Measrg Stations",231628.03,29916.920000000002,261544.95]
["%,V80751000","80751000","Purch Gas Exp - Mgmt Fee",53052.97,5270.72,58323.69]
["%,V80810000","80810000","Gas Withdrawn",13317048.01,2249141.48,15566189.49]
["%,V80820000","80820000","Gas Delivered",-16670057.810000001,-755261.78,-17425319.59]
["%,V81220000","81220000","Gas Used-Other-Offset",-56427.97,-5708.89,-62136.86]
["%,V85200030","85200030","Communication System Exp",853.56000000000006,128.13,981.69]
["%,V87000000","87000000","Op Superv-Eng-Gas Distr",1114542.3800000001,106620.71,1221163.0900000001]
["%,V87100000","87100000","Distribution Load Dispatching",71396.23000000001,14757.31,86153.540000000008]
["%,V87400000","87400000","Mains and Services Exp",5724157.0499999998,503155.99,6227313.04]
["%,V87500000","87500000","Measur-Reg Statn Exp Gen",256973.58000000002,22748.05,279721.63]
["%,V87600000","87600000","Measur-Reg Statn Exp-Indus",72219.77,12363.56,84583.33]
["%,V87800000","87800000","Meter and House Regulator Exp",1137682.53,120963.32,1258645.8500000001]
["%,V87900000","87900000","Oper Installation Service Exp",2398355.0299999998,184653.37,2583008.4]
["%,V88000000","88000000","Operations Exp Other",984058.36999999988,108724.26000000001,1092782.6299999999]
["%,V88100000","88100000","Gas Distr Rents",10263.94,3771.09,14035.03]
["%,V88500000","88500000","Maint Supv-Eng-Gas Distr",66739.490000000005,4898.1099999999997,71637.600000000006]
["%,V88600000","88600000","Maint Struct-Improv-Gas Distr",75762.58,30411.22,106173.8]
["%,V88700000","88700000","Maint of Mains",2018627.92,339796.27,2358424.19]
["%,V88900000","88900000","Maint Msr-Reg Statn Equi Gen",496925.44999999995,176837.02,673762.47]
["%,V89000000","89000000","Maint Meas_Reg Stn Equip-Distr",62159.16,17329.939999999999,79489.100000000006]
["%,V89200000","89200000","Maint of Services",580270.64999999991,79612.44,659883.09]
["%,V89300000","89300000","Maint Meters_House Regulators",104148.82,11343.58,115492.40000000001]
["%,V89400000","89400000","Other Maint Equipment",288152.93,19510.11,307663.03999999998]
["%,V90200000","90200000","Cust Accnt Meter Reading Exp",203330.43,20196.689999999999,223527.12]
["%,V90300000","90300000","Cust Records Collection Exp",2072121.48,165053.98000000001,2237175.46]
["%,V90400000","90400000","Uncollectible Accounts",2388095.27,215322.17,2603417.44]
["%,V90500000","90500000","Misc Cust Accts Exp",8053.7,977.97,9031.67]
["%,V90800000","90800000","Customer Assistance Exp",57217.440000000002,14.450000000000001,57231.89]
["%,V90900000","90900000","Inform_Instruct Advertisng Exp",29753.39,543.75,30297.14]
["%,V91000000","91000000","Misc Cust Serv and Info Exp",204457.02000000002,20499.900000000001,224956.92]
["%,V91100000","91100000","Sales Supervision",6588.54,0,6588.54]
["%,V91200000","91200000","Demonstrating and Selling Exp",4543.920000000001,1.73,4545.6500000000005]
["%,V91300000","91300000","Sales Advertising Exp",17273.309999999998,270.31,17543.62]
["%,V92000000","92000000","A_G Salaries",5635281.2999999998,636615.87,6271897.1699999999]
["%,V92001000","92001000","Discretionary and Spot Awards",12101.96,739.95,12841.91]
["%,V92002000","92002000","Stock Compensation Expense",499958.33000000007,97252.62,597210.95000000007]
["%,V92100000","92100000","Office Supplies and Exp",934175.25,72059.77,1006235.02]
["%,V92101000","92101000","Employee Expenses",261802.58000000002,20018.13,281820.71000000002]
["%,V92300000","92300000","Outside Service Employed",3611997.3,381526.28,3993523.58]
["%,V92301000","92301000","Mgmt Fee Actuals-Affil",{"$f":"F330-E330","v":1570523.2199999997},152016.89000000001,1722540.1099999999]
["%,V92400000","92400000","Property Insurance",31748.53,3533.11,35281.64]
["%,V92500000","92500000","Injuries and Damages",1682223.6300000001,181331.76,1863555.3900000001]
["%,V92600000","92600000","Employee Pensions and Benefits",3205448.76,329432.58,3534881.34]
["%,V92601000","92601000","Non Service Pension & OPEB",93819.6,-58835.79,34983.81]
["%,V92800000","92800000","Regulatory Commission Exp",228910.05000000002,22634.77,251544.82]
["%,V93010000","93010000","General Advertising Exp",7851.47,6244.3,14095.77]
["%,V93020000","93020000","Misc General Exp",22709.75,-2996.64,19713.11]
["%,V93100000","93100000","Rents Admin and General",693501.03,74563.41,768064.44000000006]
["%,V93200000","93200000","Maint General Plant",647498.31000000006,58322.21,705820.52]
["%,V99000001","99000001","Gross Payroll Hyperion",6563771.96,678076.07000000007,7241848.0300000003]
["%,V99000004","99000004","Management Fee Hyperion",13660.75,12427.14,26087.89]
["%,V99900001","99900001","Gross Pay Offset Hyperion",-6563771.96,-678076.07000000007,-7241848.0300000003]
["%,V99900002","99900002","Mgmt Fee Offset Hyperion",-13660.75,-12427.14,-26087.89]
["%,FACCOUNT,X,_",null,"Total:",{"$f":"F344-E344","v":3.0500814318656921E-7},3.8562575355172157E-9,3.0886440072208643E-7]