{"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":337,"n_cols":6,"rows_kept":337,"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 April 30, 2021"]
[]
[]
[null,"Account","Account Description","Beginning Balance","Current Period","Ending Balance"]
[]
["%,V10100000","10100000","Plant In Service-Beg Bal",{"$f":"F10-E10","v":560954380.38},0,560954380.38]
["%,V10100001","10100001","Plant In Service-Additions",11209933.659999998,8271411.5800000001,19481345.239999998]
["%,V10100002","10100002","Plant In Service-Retirements",-1954798.13,-687484.68,-2642282.81]
["%,V10110000","10110000","Capital Leases-Beg Bal",400000,0,400000]
["%,V10112000","10112000","Right of Use Asset-Beg Bal",530680.52,0,530680.52]
["%,V10112001","10112001","Right of Use Asset-Additions",70212.47,12433.7,82646.17]
["%,V10112002","10112002","Right of Use Asset-Retirements",-78644.049999999988,-44399.340000000004,-123043.39]
["%,V10112004","10112004","Right of Use Asset-Amort",-69121.119999999995,-7351.5,-76472.62]
["%,V10140000","10140000","Cloud Plant In Svc-Beg Bal",445509.8,0,445509.8]
["%,V10140001","10140001","Cloud Plant in Svc-Additions",44610.55,45447.770000000004,90058.32]
["%,V10600000","10600000","Comp Constr Not Class Beg Bal",31925634.239999998,0,31925634.239999998]
["%,V10600003","10600003","Comp Const not Class Other",-548491.04999999981,-2469019.7000000002,-3017510.75]
["%,V10700000","10700000","CWIP-Beg Balance",12900609.609999999,0,12900609.609999999]
["%,V10700001","10700001","CWIP-Additions",12797728.189999998,6077318.96,18875047.149999999]
["%,V10700003","10700003","CWIP-Other Changes",-10661442.609999999,-5802391.8799999999,-16463834.49]
["%,V10740000","10740000","Cloud CWIP-Beg Balance",294344.10000000003,0,294344.10000000003]
["%,V10740001","10740001","Cloud CWIP-Additions",221693.22999999998,115608.07,337301.3]
["%,V10740003","10740003","Cloud CWIP-Oth Changes",-44610.55,-45447.770000000004,-90058.32]
["%,V10800000","10800000","Accum Deprec Plant -Beg Bal",-162395239.84999999,0,-162395239.84999999]
["%,V10800001","10800001","Accum Deprec Plant-Additions",-3596462.6100000003,-1209116.43,-4805579.04]
["%,V10800002","10800002","Accum Deprec Plant-Retiremnt",1108366.5599999998,514360.3,1622726.8599999999]
["%,V10800003","10800003","Accum Deprec Plant-Other Chg",961841.64,322360.14,1284201.78]
["%,V10800010","10800010","Retirement WIP-Beg Bal",820744.24,0,820744.24]
["%,V10800011","10800011","Retirement WIP-Additions",829854.18,214647.09,1044501.27]
["%,V10800013","10800013","Retirement WIP-Other Changes",-962447.66,-326392.87,-1288840.53]
["%,V10800100","10800100","Accum Deprec Cap Lease-Beg Bal",-145454.57,0,-145454.57]
["%,V10800101","10800101","Accum Deprec Cap Lease-Add",-9917.34,-3305.78,-13223.12]
["%,V11100000","11100000","Accum Amortization-Beg Bal",-6337654.0599999996,0,-6337654.0599999996]
["%,V11100001","11100001","Accum Amortization-Additions",-397844.83999999997,-141730.04,-539574.88]
["%,V11100002","11100002","Accum Amortization-Retiremnt",846431.57,173124.38,1019555.95]
["%,V11140000","11140000","Cloud Accum Amortiz-BegBal",-90129.46,0,-90129.46]
["%,V11140001","11140001","Cloud Accum Amortiz-Additions",-26821.599999999999,-9962.68,-36784.28]
["%,V11401000","11401000","Tang Plant Acq Adj-BegBal",-777092,0,-777092]
["%,V11501000","11501000","Tang Acc Amort Plnt Acq Adj-BB",131495.54999999999,0,131495.54999999999]
["%,V11501010","11501010","Tang Acc Amor Plnt Acq Adj-ADD",6475.77,2158.59,8634.36]
["%,V12310000","12310000","Inv Sub Co-Common Stock",174261,0,174261]
["%,V12310001","12310001","Inv Sub Co-PL",565999.35,61.63,566060.98]
["%,V12800000","12800000","Funds Held in Trust",1901475.51,35938.050000000003,1937413.56]
["%,V13100000","13100000","Cash",891822.6,-458134.68,433687.92]
["%,V13500000","13500000","Working Funds",211.64000000000001,1,212.64000000000001]
["%,V14200160","14200160","Cust AR-Credit Balances",3845623.85,-1343890.23,2501733.62]
["%,V14200220","14200220","Cust AR-CAB",6068142.8900000006,-1375481.56,4692661.33]
["%,V14200250","14200250","Cust AR-GMB",143760.56,-71107.87,72652.69]
["%,V14200260","14200260","Cust AR-Cust Premise Work",328110.99,-232658.72,95452.27]
["%,V14300001","14300001","Misc Accts Rec-Other",36185.560000000005,1934.64,38120.200000000004]
["%,V14300018","14300018","Other AR-Billed OSS",43700,-3150,40550]
["%,V14300220","14300220","Other AR-GMB Estimate",4729.96,-811.48,3918.48]
["%,V14300240","14300240","Other AR-GTS",1353288.99,-213111,1140177.99]
["%,V14300270","14300270","Other AR-Retail Service",1552.6000000000001,-1.9000000000000001,1550.7]
["%,V14300290","14300290","Other AR-CNR",478609.65,12054.01,490663.66000000003]
["%,V14300330","14300330","Other AR Choice Trans-Columbia",-703286.58,164613.97,-538672.61]
["%,V14300350","14300350","Other AR Choice Trans-Purchase",1383945.21,-418566.16000000003,965379.05]
["%,V14300395","14300395","Other AR-CPG Non-Transit Srvcs",88356.31,0,88356.31]
["%,V14311111","14311111","Other AR-Curr-MA Project",4686.29,0,4686.29]
["%,V14400000","14400000","Acc Prov for Uncol-Beg Bal",-2232456.62,0,-2232456.62]
["%,V14400100","14400100","Acc Prov for Uncol-Reserve",555725.55000000005,70506.86,626232.41]
["%,V14400150","14400150","Acc Prov for Uncol-Charge-Offs",212154.15,115611.29000000001,327765.44]
["%,V14400200","14400200","Acc Prov for Uncol-Recoveries",-82474.549999999988,-17138.93,-99613.48]
["%,V14400600","14400600","Accm Prov Uncoll-Unbilled",-20171.82,13258.67,-6913.1500000000005]
["%,V14400700","14400700","Accm Prov Uncoll-Misc",-401312.87,0,-401312.87]
["%,V14600000","14600000","AR Assoc Co-Mech",-6285.63,6082.86,-202.77]
["%,V14600002","14600002","AR Assoc Co-Misc",9465,0,9465]
["%,V14620000","14620000","Foreign Cash",-17228.169999999984,186052.18,168824.01]
["%,V15400000","15400000","Plant Materials-Oth Supplies",305511.48,0,305511.48]
["%,V15400800","15400800","Plant Mat-Meter Shop Clearing",{"$f":"F74-E74","v":0},1786.1000000000001,1786.1000000000001]
["%,V15420000","15420000","FabShop LP OH Build Ahead",5060.3300000000008,23.98,5084.3100000000004]
["%,V16411000","16411000","Gas Stored-Current-LIFO",3408377.0199999996,1549886.7,4958263.72]
["%,V16500000","16500000","Other Misc Prepayments",-47239.11,1972.14,-45266.97]
["%,V16503600","16503600","Prepaid Taxes - Other",67538.22,-22634.77,44903.450000000004]
["%,V16520000","16520000","Prepaid-Insurance Affiliate",377369.61000000004,-84743.150000000009,292626.46000000002]
["%,V16521000","16521000","Prepaid-Insurance NonAffil",478868.92000000004,-127320.97,351547.95]
["%,V16591000","16591000","Prepaid-NC Cloud Cost Incurred",0.19,0.03,0.22]
["%,V17300000","17300000","AR Accrued Revenues",8476240.3800000008,-1701224.57,6775015.8100000005]
["%,V17302000","17302000","AR Accrd Rev Unbill Exch Gas",31749.960000000003,-19574.330000000002,12175.630000000001]
["%,V17401000","17401000","Misc Assets-Exch Gas Receiv",1401444.24,-1116165.53,285278.71000000002]
["%,V17403200","17403200","Misc Assets-Property Tax",4616350.04,-339150,4277200.04]
["%,V17406000","17406000","Misc Assets-Storage",22239033.810000002,835675.36,23074709.170000002]
["%,V18230200","18230200","Reg Asset Cr Bal Transf",0,225039.32,225039.32]
["%,V18230440","18230440","Reg Asset GTI Funding",77924.209999999992,1938.57,79862.78]
["%,V18230450","18230450","Reg Asset EAP",58168.169999999984,-283207.49,-225039.32]
["%,V18233420","18233420","Reg Asset-Prf Base Rt Adj PBRA",1915106.07,-92908.26,1822197.81]
["%,V18235114","18235114","NC Reg Asset FAS 158 OPEB",1482799.05,-10243.33,1472555.72]
["%,V18235115","18235115","NC Reg Asset FAS158 Pension",3699653.48,-17575.28,3682078.2]
["%,V18235440","18235440","NC Reg Asset Rate Case Non-Cur",5930.34,13796.41,19726.75]
["%,V18235450","18235450","NC Reg Asset Pen NQulfd FAS158",8284.7000000000007,-0.42,8284.2800000000007]
["%,V18235506","18235506","NC Reg Asset Def Depr Cap Lse",18984.859999999997,137.58000000000001,19122.439999999999]
["%,V18235530","18235530","NC Reg Asset COVID Costs",25385.38,8568.59,33953.97]
["%,V18320000","18320000","Oth Prelim Survey B Bal",1564504.5899999999,0,1564504.5899999999]
["%,V18320001","18320001","Oth Prelim Survey Additions",117478.65,-58314.75,59163.9]
["%,V18400101","18400101","Convenience Bill Clearing",279.89999999999998,475,754.9]
["%,V18400200","18400200","Car Clearing",0.10000000000000142,-21.650000000000002,-21.55]
["%,V18400250","18400250","Truck Clearing",-5.0000000000000017E-2,-0.09,-0.14000000000000001]
["%,V18400275","18400275","Clearing-Fleet",21.180000000000291,16888.77,16909.95]
["%,V18400400","18400400","General Tool Clearing",-7.9999999999999988E-2,0.12,0.04]
["%,V18600200","18600200","Def Debit-Maint and Jobng WIP",274655.49,38686.68,313342.17]
["%,V18600400","18600400","DefDebitCusAdv_DEPPST12-31-99",2817204.26,0,2817204.26]
["%,V19005000","19005000","ADIT-Other-Noncurr-Fed",7608007,28695,7636702]
["%,V19005100","19005100","ADIT Reg Liability NC - Fed",22660,-1048,21612]
["%,V19005400","19005400","ADIT FIT Gross Up",6764115,-22843,6741272]
["%,V19006000","19006000","ADIT-Other-Noncurr-State",806003,7240,813243]
["%,V19006100","19006100","ADIT Reg Liability NC - State",2963,-197,2766]
["%,V19006400","19006400","ADIT SIT Gross Up",2255263,-1065,2254198]
["%,V19100100","19100100","Unrecov Purchs Gas Costs-Com",-4223929.87,-809469.70000000007,-5033399.57]
["%,V19100400","19100400","End User Exchange",-1266895.24,253237.32,-1013657.92]
["%,V19100800","19100800","Unrecov Purch Gas Cst-Unbill",-2254316.3499999996,614047.72,-1640268.63]
["%,V20100000","20100000","Common Stock-Beg Balance",-23806200,0,-23806200]
["%,V21100000","21100000","APIC Beg Balance",-14951788.640000001,0,-14951788.640000001]
["%,V21108000","21108000","APIC Tax Savings Allocation",-66735,0,-66735]
["%,V21600000","21600000","Retained Earnings-Beg Bal",-91509290.549999997,0,-91509290.549999997]
["%,V21600003","21600003","Retained Earnings-Pre Merger",-55928934,0,-55928934]
["%,V22300000","22300000","Adv from Assoc Co-Beg Bal",-138375000,0,-138375000]
["%,V22305000","22305000","Curr Adv from Assoc Co-Beg Bal",-16000000,0,-16000000]
["%,V22700000","22700000","Oblig Und Cap Leas B Bal",-234736.6,0,-234736.6]
["%,V22700002","22700002","Oblig Und Cap Leas NC Transfer",9808.83,3290.26,13099.09]
["%,V22710000","22710000","Oblig Operating Leas Beg Bal",-213646.87,0,-213646.87]
["%,V22710002","22710002","Oblig Operating Leas NC Transf",20481.559999999998,6871.76,27353.32]
["%,V22820000","22820000","Accum Prov Prop Injur Damg",-37085.5,-10025,-47110.5]
["%,V22830010","22830010","Accum Prov-Banked Vacation",-483525.23,-99531.91,-583057.14]
["%,V22833000","22833000","Accum Provisions FAS 112",-290496.45,0,-290496.45]
["%,V22834010","22834010","Accum Provisions OPEB",-1430643.95,72112.84,-1358531.1099999999]
["%,V22838000","22838000","Accum Provisions Pen Cost Qual",-0.04,0,-0.04]
["%,V22838020","22838020","Accum Prov LT PenCost Non-Qual",-350.3,-0.42,-350.72]
["%,V22840030","22840030","NC Payroll Taxes Cares Act",-394678.44,0,-394678.44]
["%,V23200000","23200000","AP - AP Module Use Only",-3251860.97,132982.18,-3118878.79]
["%,V23200001","23200001","AP-Misc",-896219.3899999999,-160247.05000000002,-1056466.44]
["%,V23201058","23201058","AP-PNC Land Disbursement",-14778.99,35,-14743.99]
["%,V23201061","23201061","AP-MellonBank Disbursement_ACH",-548442.39,-17907.68,-566350.07000000007]
["%,V23202300","23202300","AP-Gas Purchases-Producer",-968273.92000000039,-1835190.15,-2803464.0700000003]
["%,V23202400","23202400","AP-Gas Purchases-Transport",{"$f":"F138-E138","v":-2518511.44},403149.67,-2115361.77]
["%,V23202500","23202500","AP-Choice Marketer Payable",-1712798.85,861081.56,-851717.29]
["%,V23202900","23202900","AP-CPG Non-Transition Srvces",-14633,-500,-15133]
["%,V23400000","23400000","AP Assoc Co-Mech",-2354242.0100000002,-335709.3,-2689951.31]
["%,V23400010","23400010","AP Assoc Co-Interest",-2536200.5099999998,-628810.03,-3165010.54]
["%,V23400111","23400111","AP Assoc Co-ERS_Only",-117241.45000000001,64581.630000000005,-52659.82]
["%,V23410000","23410000","Money Pool Borrowings",-18979434.41,-307599.12,-19287033.530000001]
["%,V23410001","23410001","Money Pool Borrowings Int Pay",-2630.6800000000003,861.79,-1768.89]
["%,V23500000","23500000","Customer Deposits",-1820587.02,168988,-1651599.02]
["%,V23601000","23601000","Accrd Fed Inc Tax-Current",-3429619.84,-23287,-3452906.84]
["%,V23602000","23602000","Accrd ST Inc Tax-Current Year",45733.19,16036,61769.19]
["%,V23603200","23603200","Accrd Property Tax",-12175066.17,-14088.42,-12189154.59]
["%,V23603300","23603300","Accrd Sales and Use Tax",10632.86,26685.29,37318.15]
["%,V23603400","23603400","Accrd Tax-FICA OASDI",-424662.55,0,-424662.55]
["%,V23603700","23603700","Accrued FICA Taxes",-32773.75,-15435.61,-48209.36]
["%,V23604000","23604000","Accrd Unempl Insur-Fed",-8433.880000000001,8570.2100000000009,136.33000000000001]
["%,V23604100","23604100","Accrd Unempl Insur-State",-21552.66,5998.42,-15554.24]
["%,V23700010","23700010","Int Accrued-Cust Deposit",-28100.880000000001,127.09,-27973.79]
["%,V24103130","24103130","Tax Coll Pay Loc Inc Tx",462.02,0,462.02]
["%,V24103140","24103140","Tax Coll Pay Tx WH OASDI",671.07,0,671.07]
["%,V24103300","24103300","Tax Coll Pay Sales and Use Tax",-140718.85,98757.98,-41960.87]
["%,V24103400","24103400","Tax Coll Pay Util Gross Rcpts",-1181762.26,437370.94,-744391.32000000007]
["%,V24103600","24103600","Tax Coll Pay State-Local Oth",-293.14999999999998,-62.22,-355.37]
["%,V24200070","24200070","Accd Liab-Severance",-316599.83,-336157.35000000003,-652757.18000000005]
["%,V24201629","24201629","Accd Liab-Unclaimed AP Checks",-359055.93,48987.62,-310068.31]
["%,V24203000","24203000","Accd Liab-Profit Sharing",-49258.680000000008,-16419.560000000001,-65678.240000000005]
["%,V24203100","24203100","Accd Liab-Incentive Compnstion",-303123.24,-101041.08,-404164.32]
["%,V24203200","24203200","Accd Liab-Vacation Pay PY",-1588157.36,151135.81,-1437021.55]
["%,V24203201","24203201","Accd Liab-Vacation Pay CY",-386466.92000000004,-26329.72,-412796.64]
["%,V24203305","24203305","Accd Liab-Gross Payroll",-125291.42000000001,-184601.91,-309893.33]
["%,V24204000","24204000","Accd Liab-PR Ded Misc",-32100.27,0,-32100.27]
["%,V24204050","24204050","Accd Liab-PR Ded Wage Attchmt",-1695.18,9,-1686.18]
["%,V24204060","24204060","Accd Liab-PR Ded United Way",-91.67,0,-91.67]
["%,V24204070","24204070","Accd Liab-PR Ded PAC",-997.55000000000007,0,-997.55000000000007]
["%,V24204080","24204080","Accd Liab-PR Ded ThrftPlan Pyt",-6328.8600000000006,0,-6328.8600000000006]
["%,V24204081","24204081","Accd Liab-PR Ded ThrftPlan EE",-38165.620000000003,-2170.9499999999998,-40336.57]
["%,V24204082","24204082","Accd Liab-PR Ded Roth401k Plan",-2680.91,0,-2680.91]
["%,V24204090","24204090","Accd Liab-PR Ded FSA Health",-83.34,0,-83.34]
["%,V24204091","24204091","Accd Liab-PR Ded FSA Dep Care",-375,0,-375]
["%,V24204092","24204092","Accd Liab-PR Ded HSA Benefits",-25528.49,17.64,-25510.850000000002]
["%,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",-14285,-4885,-19170]
["%,V24207000","24207000","Accd Liab-Professional Srvcs",-63807.650000000009,-14269,-78076.650000000009]
["%,V24207020","24207020","Accd Liab-Benefits Admin Fees",-5016.2599999999993,-6929.47,-11945.73]
["%,V24208000","24208000","Accd Liab-Health Benefits",-157394.68,0,-157394.68]
["%,V24208010","24208010","Accd Liab-Rx Drug",-36388.639999999999,0,-36388.639999999999]
["%,V24208020","24208020","Accd Liab-Dental",-18365.490000000002,0,-18365.490000000002]
["%,V24211263","24211263","Accd Liab-ST FAS112",-73427.56,0,-73427.56]
["%,V24220300","24220300","Accd Liab-Rate Refunds",-2313.3900000000003,2789.36,475.97]
["%,V24224000","24224000","Customer AR Credit Balances",-3993788.85,1355206.23,-2638582.62]
["%,V24240050","24240050","Accd Liab-Shipper Gas",-571742,387194,-184548]
["%,V24250110","24250110","Accd Liab-Heatshare Cust Cntri",0,-1373,-1373]
["%,V24250160","24250160","Accd Liab-Gas Supply Cr Dep",-25000,0,-25000]
["%,V24300000","24300000","Oblig Cap Leases Curr-Beg Bal",-38321.279999999999,0,-38321.279999999999]
["%,V24300002","24300002","Oblig Cap Leases Curr-Payments",9444.93,3168.2000000000003,12613.130000000001]
["%,V24300003","24300003","Oblig Cap Leases Curr-Transfer",-9808.83,-3290.26,-13099.09]
["%,V24310000","24310000","Oblig Operating Lease Curr-BB",-337920.06,0,-337920.06]
["%,V24310001","24310001","Oblig Operating Lease Curr-Add",-70212.47,-12433.7,-82646.17]
["%,V24310002","24310002","Oblig Operating Lease Curr-Pay",147784.44,50033.62,197818.06]
["%,V24310003","24310003","Oblig Operating Lease Curr-Trn",-20481.559999999998,-6871.76,-27353.32]
["%,V25200000","25200000","Custmr Advn for Constr NonCur",-2817204.26,1533.05,-2815671.21]
["%,V25400450","25400450","Reg Liab Curr-Other",-7741.87,-4760.72,-12502.59]
["%,V25401000","25401000","Reg Liab Curr-Inc Tax Fed/St",-1106351,0,-1106351]
["%,V25401350","25401350","Reg Liab Curr-DSM Uncollect",{"$f":"F202-E202","v":-55637.69},-23104.97,-78742.66]
["%,V25402400","25402400","Reg Liab Curr-Asset Reclass",0,-225039.32,-225039.32]
["%,V25402900","25402900","Reg Lia Curr-AMRP",-967435.14,5056.5200000000004,-962378.62]
["%,V25405000","25405000","Reg Liab NC-Inc Tax Fed-St",-36451136.18,84950,-36366186.18]
["%,V25405050","25405050","Reg Liab NC-Deferred ITC",-26913.600000000002,1245,-25668.600000000002]
["%,V25500000","25500000","Investment Tax Credit-ITC",-46719,2037,-44682]
["%,V28205000","28205000","Fed ADIT-Property",-56125947,-211216,-56337163]
["%,V28206000","28206000","St ADIT-Property",-10888468,-74859,-10963327]
["%,V28305000","28305000","Fed ADIT-Other NC",-30839,149417,118578]
["%,V28306000","28306000","ST ADIT-NC Other",-7730,37449,29719]
["%,V40300000","40300000","Dep Exp",3586204.5300000003,1208691.1599999999,4794895.6900000004]
["%,V40430000","40430000","Amortization Exp-Other",104574.92000000001,34733.9,139308.82]
["%,V40434000","40434000","Cloude Amortizaiton Expense",26821.599999999999,9962.68,36784.28]
["%,V40500000","40500000","Amortization of Oth Plant",293269.92,106996.14,400266.06]
["%,V40813100","40813100","Tax Exp-License_Franchise",3000,0,3000]
["%,V40813200","40813200","Tax Exp-Property",1581015.25,310893.42,1891908.67]
["%,V40813300","40813300","Tax Exp-Sales and Use Tax",-2.0000000000436557E-2,10632.84,10632.82]
["%,V40814100","40814100","Tax Exp-Payroll-Incentive",-20991.94,4588.32,-16403.62]
["%,V40814500","40814500","Tax Exp-Payroll FICA-OASDI",201729.25,54776.01,256505.26]
["%,V40814600","40814600","Tax Exp-Payroll FICA-Medicar",47412.54,12975.42,60387.96]
["%,V40814700","40814700","Tax Exp-FUTA Employer",5189.07,1.27,5190.34]
["%,V40814800","40814800","Tax Exp-SUTA Employer",12898.769999999999,162.37,13061.14]
["%,V40911000","40911000","Util Cur Fed Exp",2574040,6101,2580141]
["%,V40912000","40912000","Util Cur ST Exp",126283,-20344,105939]
["%,V40921000","40921000","Non Util Cur Fed Exp",132458,17186,149644]
["%,V40922000","40922000","Non Util Cur ST Exp",33197,4308,37505]
["%,V41011000","41011000","Util Def Fed Exp-Dr",1708104,252833,1960937]
["%,V41012000","41012000","Util Def ST Exp-Dr",862031,69939,931970]
["%,V41111000","41111000","Util Def Fed Exp-Cr",-1328262,-272787,-1601049]
["%,V41112000","41112000","Util Def ST Exp-Cr",-232053,-47753,-279806]
["%,V41141000","41141000","Def Inc Tax-Fed-Cr-Util ITC",-6111,-2037,-8148]
["%,V41700000","41700000","Non Util Revenues",-167699.71,-21207.600000000002,-188907.31]
["%,V41715000","41715000","Non Util Operating Exp",-2315.5,-307.70999999999998,-2623.21]
["%,V41810000","41810000","Affil Equity in Earngs of Subs",-263.46000000000004,-61.63,-325.09000000000003]
["%,V41910000","41910000","Allow for Other FUDC",-52652.66,-21191.03,-73843.69]
["%,V42101450","42101450","Gas Cost Recovery Initiatives",-515312.33000000007,-53857.120000000003,-569169.45000000007]
["%,V42121000","42121000","Loss on Disposition of Asset",39513.950000000004,0,39513.950000000004]
["%,V42500000","42500000","Misc Amortization",-6475.77,-2158.59,-8634.36]
["%,V42610000","42610000","Other Inc_Exp-Donations",9345,530.98,9875.98]
["%,V42630000","42630000","Penalties-Others",44001.36,12000,56001.36]
["%,V42640000","42640000","Oth Inc_Exp Political Contrib",2265,183.5,2448.5]
["%,V42655000","42655000","Other Income Deductions",46795.119999999995,17661.34,64456.46]
["%,V43000000","43000000","Int on Debt to Assoc Co",1886430.0799999998,628810.03,2515240.11]
["%,V43002000","43002000","Int on Debt to Assoc Co MonyPl",11173.050000000001,1768.89,12941.94]
["%,V43100000","43100000","Other Interest Exp",-13041.900000000001,-8568.59,-21610.49]
["%,V43105100","43105100","Oth Int Exp-Cust Deposits",614.26,179.56,793.82]
["%,V43200000","43200000","Allow for Borrowd FUDC",-34826.57,-13562.33,-48388.9]
["%,V48000000","48000000","Residential Sales",-38085180.129999995,-6678381.5899999999,-44763561.719999999]
["%,V48000100","48000100","Residential Sales Norm",-4173.2699999999995,-1768.43,-5941.7]
["%,V48101000","48101000","Commercial Gas Sales",-15493669.470000001,-2633394.92,-18127064.390000001]
["%,V48101200","48101200","Commercial Gas Sales Norm",-2095.5299999999997,-945.61,-3041.14]
["%,V48102000","48102000","Industrial Gas Sales",-768490.91,-141850.84,-910341.75]
["%,V48102300","48102300","Industrial Gas Sales Norm",-104.92999999999999,-75.320000000000007,-180.25]
["%,V48300000","48300000","Sales for Resale-Gas",-33561.39,-7336.76,-40898.15]
["%,V48700000","48700000","Forfeited Discounts-Gas",-230559.06,-58204.020000000004,-288763.08]
["%,V48800000","48800000","Misc Service Revenues-Gas",-10694.349999999999,-11867.7,-22562.05]
["%,V48930000","48930000","Transp Rev Distr Residential",-3039609.23,-643191.32999999996,-3682800.56]
["%,V48930200","48930200","Unbilled Residential Trans Vol",164785.40000000002,94899.7,259685.1]
["%,V48930300","48930300","Unbilled Res Trans Cust chrg",4400,1456,5856]
["%,V48931000","48931000","Transp Rev Distr Commercial",-3207209.63,-748024.84,-3955234.4699999997]
["%,V48931300","48931300","Unbilled Comm Trans Vol",121011.82999999999,61613.79,182625.62]
["%,V48931400","48931400","Unbilled Comm Trans Cust chrg",4018.05,491.59000000000003,4509.6400000000003]
["%,V48932000","48932000","Transp Rev Distr Industrial",-1528417.87,-406258.91000000003,-1934676.78]
["%,V48932400","48932400","Unbilled Ind Trans Vol",3405.2200000000003,22.080000000000002,3427.3]
["%,V49300000","49300000","Rent from Gas Property",{"$f":"F266-E266","v":-8556},-2852,-11408]
["%,V49500000","49500000","Other Gas Revenue",-158323.74000000002,-53408.03,-211731.77000000002]
["%,V49500050","49500050","Billed Off System Sales",-799173.74,-39962.5,-839136.24]
["%,V49500485","49500485","Unbilled Residential-Vol",3403918.8,1114928.22,4518847.0199999996]
["%,V49501485","49501485","Unbilled Res Customer Chrg",-14736.2,7712,-7024.2]
["%,V49510485","49510485","Unbilled Commercial-Vol",1284244.0300000003,378967.4,1663211.4300000002]
["%,V49511485","49511485","Unbilled Comm Customer Chrg",-1876.9799999999998,3664.58,1787.6000000000001]
["%,V49520485","49520485","Unbilled Industrial-Vol",44875.05,-6605.55,38269.5]
["%,V49521485","49521485","Unbilled Ind Customer Chrg",-44.69,44.69,0]
["%,V80100000","80100000","Natural gas field line purchas",74434.239999999991,30555.100000000002,104989.34]
["%,V80300300","80300300","Short Term Producer Purch",6992230.3099999987,2796482.14,9788712.4499999993]
["%,V80300400","80300400","Transportation Pipeline Exp",2819332.1799999997,614371.22,3433703.4]
["%,V80300500","80300500","Storage Charges Pipeline Exp",-1753242.7,-345561.22000000003,-2098803.92]
["%,V80300600","80300600","OFS_System Supply Credit",-221759.91999999998,-7363.17,-229123.09]
["%,V80300808","80300808","Storage Demand",3627607.9399999995,1502153.12,5129761.0599999996]
["%,V80400000","80400000","Natural Gas City Gate Purchase",1037278.83,54062.65,1091341.48]
["%,V80510000","80510000","Purchased Gas Cost Adjustments",359808.12,-57815.360000000001,301992.76]
["%,V80601000","80601000","Exchange Gas-Received",-3119952.05,728971.53,-2390980.52]
["%,V80720000","80720000","Oper-Purch Gas Measrg Stations",112846.65,31076.09,143922.74]
["%,V80751000","80751000","Purch Gas Exp - Mgmt Fee",15565.720000000001,5150.55,20716.27]
["%,V80810000","80810000","Gas Withdrawn",14528592.02,-534718.16,13993873.859999999]
["%,V80820000","80820000","Gas Delivered",-419018.78000000026,-1850843.9,-2269862.6800000002]
["%,V81220000","81220000","Gas Used-Other-Offset",-48346.9,-7916.29,-56263.19]
["%,V85200030","85200030","Communication System Exp",336.75000000000045,3804.73,4141.4800000000005]
["%,V87000000","87000000","Op Superv-Eng-Gas Distr",262073.81999999998,87286.6,349360.42]
["%,V87100000","87100000","Distribution Load Dispatching",58502.259999999995,7926.4400000000005,66428.7]
["%,V87400000","87400000","Mains and Services Exp",1636886.04,582664.12,2219550.16]
["%,V87500000","87500000","Measur-Reg Statn Exp Gen",56809.45,15626.880000000001,72436.33]
["%,V87600000","87600000","Measur-Reg Statn Exp-Indus",16622.870000000003,7629.08,24251.95]
["%,V87800000","87800000","Meter and House Regulator Exp",364244.47000000003,126515.05,490759.52]
["%,V87900000","87900000","Oper Installation Service Exp",695620.57000000007,240170,935790.57000000007]
["%,V87900200","87900200","Oper Install-Chrg Labor",28.03,0,28.03]
["%,V88000000","88000000","Operations Exp Other",352153.62,76550.78,428704.4]
["%,V88100000","88100000","Gas Distr Rents",1387.4900000000002,950,2337.4900000000002]
["%,V88500000","88500000","Maint Supv-Eng-Gas Distr",22174.690000000002,7478.75,29653.440000000002]
["%,V88600000","88600000","Maint Struct-Improv-Gas Distr",18582.28,2139.09,20721.37]
["%,V88700000","88700000","Maint of Mains",617195.19999999995,167103.16,784298.36]
["%,V88900000","88900000","Maint Msr-Reg Statn Equi Gen",115788.6,58415.16,174203.76]
["%,V89000000","89000000","Maint Meas_Reg Stn Equip-Distr",23491.54,5950.72,29442.260000000002]
["%,V89200000","89200000","Maint of Services",252517.34,73576.09,326093.43]
["%,V89300000","89300000","Maint Meters_House Regulators",21510.569999999996,19937.850000000002,41448.42]
["%,V89400000","89400000","Other Maint Equipment",124248.84,23614.510000000002,147863.35]
["%,V90100000","90100000","Customer Acnt Supervision",45.94,88.66,134.6]
["%,V90200000","90200000","Cust Accnt Meter Reading Exp",48583.64,1832.93,50416.57]
["%,V90300000","90300000","Cust Records Collection Exp",673039.58000000007,233826.07,906865.65]
["%,V90400000","90400000","Uncollectible Accounts",-657447.6100000001,-41469.08,-698916.69000000006]
["%,V90500000","90500000","Misc Cust Accts Exp",3054.8199999999997,1012.7,4067.52]
["%,V90800000","90800000","Customer Assistance Exp",39540,13180,52720]
["%,V91000000","91000000","Misc Cust Serv and Info Exp",62447.210000000006,24080.639999999999,86527.85]
["%,V91200000","91200000","Demonstrating and Selling Exp",1529.22,1105.28,2634.5]
["%,V91300000","91300000","Sales Advertising Exp",-376.12,1055.2,679.08]
["%,V92000000","92000000","A_G Salaries",2036018.1300000004,1041660.61,3077678.74]
["%,V92001000","92001000","Discretionary and Spot Awards",11356.6,1117.05,12473.65]
["%,V92002000","92002000","Stock Compensation Expense",93394.419999999984,77164.540000000008,170558.96]
["%,V92100000","92100000","Office Supplies and Exp",198943.05,98227.02,297170.07]
["%,V92101000","92101000","Employee Expenses",38070.06,13375.33,51445.39]
["%,V92300000","92300000","Outside Service Employed",1208924.0499999998,504779.79000000004,1713703.8399999999]
["%,V92301000","92301000","Mgmt Fee Actuals-Affil",480728.60000000009,148437.21,629165.81000000006]
["%,V92400000","92400000","Property Insurance",10602.63,3534.76,14137.39]
["%,V92500000","92500000","Injuries and Damages",546496.96000000008,188604.84,735101.8]
["%,V92600000","92600000","Employee Pensions and Benefits",1128113.29,304417.91999999998,1432531.21]
["%,V92601000","92601000","Non Service Pension & OPEB",-76413.829999999987,-79058.69,-155472.51999999999]
["%,V92800000","92800000","Regulatory Commission Exp",67968.640000000014,22636.400000000001,90605.040000000008]
["%,V93010000","93010000","General Advertising Exp",3742.2000000000003,90.52,3832.7200000000003]
["%,V93020000","93020000","Misc General Exp",{"$f":"F330-E330","v":14713.92},1318.1200000000001,16032.04]
["%,V93100000","93100000","Rents Admin and General",223095.56999999998,76226.91,299322.48]
["%,V93200000","93200000","Maint General Plant",285819.18,116759.40000000001,402578.58]
["%,V99000001","99000001","Gross Payroll Hyperion",1717548.14,863182.82000000007,2580730.96]
["%,V99000004","99000004","Management Fee Hyperion",12003.93,6651.91,18655.84]
["%,V99900001","99900001","Gross Pay Offset Hyperion",-1717548.14,-863182.82000000007,-2580730.96]
["%,V99900002","99900002","Mgmt Fee Offset Hyperion",-12003.93,-6651.91,-18655.84]
["%,FACCOUNT,X,_",null,"Total:",{"$f":"F337-E337","v":5.243782652541995E-8},-8.985807653516531E-10,5.1539245760068297E-8]