{"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 June 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",29836464.149999999,9502280.8599999994,39338745.009999998]
["%,V10100002","10100002","Plant In Service-Retirements",-3256895.26,-414935.35000000003,-3671830.61]
["%,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",127447.59,31174.53,158622.12]
["%,V10112002","10112002","Right of Use Asset-Retirements",-181468.33,-147166.23000000001,-328634.56]
["%,V10112004","10112004","Right of Use Asset-Amort",-64844.81,99368.23,34523.42]
["%,V10140000","10140000","Cloud Plant In Svc-Beg Bal",445509.8,0,445509.8]
["%,V10140001","10140001","Cloud Plant in Svc-Additions",90554.070000000036,193646.78,284200.85000000003]
["%,V10600000","10600000","Comp Constr Not Class Beg Bal",31925634.239999998,0,31925634.239999998]
["%,V10600003","10600003","Comp Const not Class Other",-8756302.6700000018,-5082235.0599999996,-13838537.73]
["%,V10700000","10700000","CWIP-Beg Balance",12900609.609999999,0,12900609.609999999]
["%,V10700001","10700001","CWIP-Additions",25840779.880000003,5461411.3799999999,31302191.260000002]
["%,V10700003","10700003","CWIP-Other Changes",-21080161.48,-4420045.8,-25500207.280000001]
["%,V10740000","10740000","Cloud CWIP-Beg Balance",294344.10000000003,0,294344.10000000003]
["%,V10740001","10740001","Cloud CWIP-Additions",402509.83,37141.599999999999,439651.43]
["%,V10740003","10740003","Cloud CWIP-Oth Changes",-90554.070000000036,-193646.78,-284200.85000000003]
["%,V10800000","10800000","Accum Deprec Plant -Beg Bal",-162395239.84999999,0,-162395239.84999999]
["%,V10800001","10800001","Accum Deprec Plant-Additions",-6039084.2599999998,-1245840.6000000001,-7284924.8600000003]
["%,V10800002","10800002","Accum Deprec Plant-Retiremnt",2164134.69,333732.62,2497867.31]
["%,V10800003","10800003","Accum Deprec Plant-Other Chg",1486666.14,218359.28,1705025.42]
["%,V10800010","10800010","Retirement WIP-Beg Bal",820744.24,0,820744.24]
["%,V10800011","10800011","Retirement WIP-Additions",1325985.8599999999,278046.84999999998,1604032.71]
["%,V10800013","10800013","Retirement WIP-Other Changes",-1491865.2899999998,-218438.82,-1710304.1099999999]
["%,V10800100","10800100","Accum Deprec Cap Lease-Beg Bal",-145454.57,0,-145454.57]
["%,V10800101","10800101","Accum Deprec Cap Lease-Add",-16528.91,-3305.79,-19834.7]
["%,V11100000","11100000","Accum Amortization-Beg Bal",-6337654.0599999996,0,-6337654.0599999996]
["%,V11100001","11100001","Accum Amortization-Additions",-682572.42,-146416.89000000001,-828989.31]
["%,V11100002","11100002","Accum Amortization-Retiremnt",1092760.57,81202.73,1173963.3]
["%,V11140000","11140000","Cloud Accum Amortiz-BegBal",-90129.46,0,-90129.46]
["%,V11140001","11140001","Cloud Accum Amortiz-Additions",-46374.59,-11208.800000000001,-57583.39]
["%,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",10792.95,2158.59,12951.54]
["%,V12310000","12310000","Inv Sub Co-Common Stock",174261,0,174261]
["%,V12310001","12310001","Inv Sub Co-PL",566071.69999999995,9.43,566081.13]
["%,V12800000","12800000","Funds Held in Trust",1973351.6099999999,35938.050000000003,2009289.66]
["%,V13100000","13100000","Cash",257366.05999999994,322542.65000000002,579908.71]
["%,V13500000","13500000","Working Funds",212.64000000000001,0,212.64000000000001]
["%,V14200160","14200160","Cust AR-Credit Balances",2198402.44,1018076.6,3216479.04]
["%,V14200220","14200220","Cust AR-CAB",4145399.6,-2494840.69,1650558.9100000001]
["%,V14200250","14200250","Cust AR-GMB",60224.090000000004,-32242.260000000002,27981.83]
["%,V14200260","14200260","Cust AR-Cust Premise Work",103687.94,11188.23,114876.17]
["%,V14300001","14300001","Misc Accts Rec-Other",38061.560000000005,-1894.8600000000001,36166.700000000004]
["%,V14300018","14300018","Other AR-Billed OSS",86427.5,343748.24,430175.74]
["%,V14300220","14300220","Other AR-GMB Estimate",1706.49,-221.01,1485.48]
["%,V14300240","14300240","Other AR-GTS",1333338.4300000002,-234539.36000000002,1098799.07]
["%,V14300270","14300270","Other AR-Retail Service",3089.7,1546.75,4636.45]
["%,V14300290","14300290","Other AR-CNR",462317.49,0,462317.49]
["%,V14300330","14300330","Other AR Choice Trans-Columbia",-431286.48000000004,-433631.92,-864918.4]
["%,V14300350","14300350","Other AR Choice Trans-Purchase",793508.29,-253837.77000000002,539670.52]
["%,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",570599.69999999995,-342771.3,227828.4]
["%,V14400150","14400150","Acc Prov for Uncol-Charge-Offs",657142.08000000007,250834.68,907976.76]
["%,V14400200","14400200","Acc Prov for Uncol-Recoveries",-114259.53,-84501.62,-198761.15]
["%,V14400600","14400600","Accm Prov Uncoll-Unbilled",-2995.65,-2924.32,-5919.97]
["%,V14400700","14400700","Accm Prov Uncoll-Misc",-401312.87,0,-401312.87]
["%,V14600000","14600000","AR Assoc Co-Mech",7035.8,-2102.5100000000002,4933.29]
["%,V14600002","14600002","AR Assoc Co-Misc",9465,0,9465]
["%,V14620000","14620000","Foreign Cash",96335.510000000009,-25752.71,70582.8]
["%,V15400000","15400000","Plant Materials-Oth Supplies",305459.93,0,305459.93]
["%,V15400800","15400800","Plant Mat-Meter Shop Clearing",{"$f":"F74-E74","v":1786.1000000000001},0,1786.1000000000001]
["%,V15420000","15420000","FabShop LP OH Build Ahead",5084.3100000000004,0,5084.3100000000004]
["%,V16411000","16411000","Gas Stored-Current-LIFO",10335433.09,15912627.300000001,26248060.390000001]
["%,V16500000","16500000","Other Misc Prepayments",-49467.15,-1778.8700000000001,-51246.020000000004]
["%,V16500030","16500030","Prepaid Payroll",0,333403.46000000002,333403.46000000002]
["%,V16503600","16503600","Prepaid Taxes - Other",22268.68,-22634.77,-366.09000000000003]
["%,V16520000","16520000","Prepaid-Insurance Affiliate",207883.31,-77964.13,129919.18000000001]
["%,V16521000","16521000","Prepaid-Insurance NonAffil",224226.97999999998,-75848.710000000006,148378.26999999999]
["%,V16591000","16591000","Prepaid-NC Cloud Cost Incurred",0.19,0.01,0.2]
["%,V17300000","17300000","AR Accrued Revenues",6197242.2800000003,-1291576.6200000001,4905665.66]
["%,V17302000","17302000","AR Accrd Rev Unbill Exch Gas",2751.26,-2751.26,0]
["%,V17403200","17403200","Misc Assets-Property Tax",3742550.04,-534650,3207900.04]
["%,V17406000","17406000","Misc Assets-Storage",21328046.579999998,-11593319.300000001,9734727.2799999993]
["%,V18230200","18230200","Reg Asset Cr Bal Transf",292279.7,31579.11,323858.81]
["%,V18230440","18230440","Reg Asset GTI Funding",87832.78,14314.42,102147.2]
["%,V18230450","18230450","Reg Asset EAP",-288395.40000000002,-48154.44,-336549.84]
["%,V18233420","18233420","Reg Asset-Prf Base Rt Adj PBRA",1769114.73,-8715.4699999999993,1760399.26]
["%,V18235114","18235114","NC Reg Asset FAS 158 OPEB",1462312.3900000001,-10243.33,1452069.06]
["%,V18235115","18235115","NC Reg Asset FAS158 Pension",3664502.92,-86611.28,3577891.64]
["%,V18235440","18235440","NC Reg Asset Rate Case Non-Cur",21092.410000000003,205784.19,226876.6]
["%,V18235450","18235450","NC Reg Asset Pen NQulfd FAS158",8283.86,-0.42,8283.44]
["%,V18235506","18235506","NC Reg Asset Def Depr Cap Lse",19250.030000000002,117.57000000000001,19367.600000000002]
["%,V18235530","18235530","NC Reg Asset COVID Costs",36980.75,2491.38,39472.129999999997]
["%,V18320000","18320000","Oth Prelim Survey B Bal",1564504.5899999999,0,1564504.5899999999]
["%,V18320001","18320001","Oth Prelim Survey Additions",-665450.16,58024.76,-607425.4]
["%,V18400101","18400101","Convenience Bill Clearing",754.9,-754.9,0]
["%,V18400200","18400200","Car Clearing",-16835.79,16835.79,0]
["%,V18400250","18400250","Truck Clearing",0.28000000000000003,-0.28000000000000003,0]
["%,V18400275","18400275","Clearing-Fleet",25361.22,-25361.22,0]
["%,V18400400","18400400","General Tool Clearing",0.1,-0.1,0]
["%,V18400610","18400610","Clearing-Prem Bill Stmt AllOth",15085,-15085,0]
["%,V18600200","18600200","Def Debit-Maint and Jobng WIP",188708.22000000003,-226182.86000000002,-37474.639999999999]
["%,V18600400","18600400","DefDebitCusAdv_DEPPST12-31-99",2814335.5300000003,3114.36,2817449.89]
["%,V19005000","19005000","ADIT-Other-Noncurr-Fed",7556001,102341,7658342]
["%,V19005100","19005100","ADIT Reg Liability NC - Fed",20563,-1048,19515]
["%,V19005400","19005400","ADIT FIT Gross Up",6718429,-22842,6695587]
["%,V19006000","19006000","ADIT-Other-Noncurr-State",792783,75890,868673]
["%,V19006100","19006100","ADIT Reg Liability NC - State",2569,-197,2372]
["%,V19006400","19006400","ADIT SIT Gross Up",2253132,-1066,2252066]
["%,V19100100","19100100","Unrecov Purchs Gas Costs-Com",-3900166.9400000004,1517604.97,-2382561.9700000002]
["%,V19100400","19100400","End User Exchange",-878033.5,434030.95,-444002.55]
["%,V19100800","19100800","Unrecov Purch Gas Cst-Unbill",-1271534.97,762909.11,-508625.86]
["%,V20100000","20100000","Common Stock-Beg Balance",-23806200,0,-23806200]
["%,V21100000","21100000","APIC Beg Balance",-14951788.640000001,0,-14951788.640000001]
["%,V21101020","21101020","APIC Issuances",0,-11000000,-11000000]
["%,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]
["%,V22300010","22300010","Adv from Assoc Co-Issuances",0,-22000000,-22000000]
["%,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",16399.739999999998,3311.06,19710.8]
["%,V22710000","22710000","Oblig Operating Leas Beg Bal",-213646.87,0,-213646.87]
["%,V22710002","22710002","Oblig Operating Leas NC Transf",34247.47,6916.6500000000005,41164.120000000003]
["%,V22820000","22820000","Accum Prov Prop Injur Damg",-23975.5,36.200000000000003,-23939.3]
["%,V22830010","22830010","Accum Prov-Banked Vacation",-584278.57999999996,0,-584278.57999999996]
["%,V22833000","22833000","Accum Provisions FAS 112",-290496.45,0,-290496.45]
["%,V22834010","22834010","Accum Provisions OPEB",-1289092.18,-52494.770000000004,-1341586.95]
["%,V22838000","22838000","Accum Provisions Pen Cost Qual",-0.04,0,-0.04]
["%,V22838020","22838020","Accum Prov LT PenCost Non-Qual",-351.14,-0.42,-351.56]
["%,V22840030","22840030","NC Payroll Taxes Cares Act",-394678.44,0,-394678.44]
["%,V23200000","23200000","AP - AP Module Use Only",-3111231.02,-103566.68000000001,-3214797.7]
["%,V23200001","23200001","AP-Misc",-1414530.58,615785.65,-798744.93]
["%,V23201055","23201055","AP-PNC Wires_ACH",{"$f":"F138-E138","v":0},-6109.36,-6109.36]
["%,V23201058","23201058","AP-PNC Land Disbursement",-32149.99,1656,-30493.99]
["%,V23201061","23201061","AP-MellonBank Disbursement_ACH",-440430.99000000005,170377.58000000002,-270053.41000000003]
["%,V23202300","23202300","AP-Gas Purchases-Producer",-5071822.3899999997,-430821.7,-5502644.0899999999]
["%,V23202400","23202400","AP-Gas Purchases-Transport",-2219070.4500000002,-61414.61,-2280485.06]
["%,V23202500","23202500","AP-Choice Marketer Payable",-565044.38,247382.71,-317661.67]
["%,V23202900","23202900","AP-CPG Non-Transition Srvces",-9633,-500,-10133]
["%,V23400000","23400000","AP Assoc Co-Mech",-2702361.7600000002,-175020.23,-2877381.99]
["%,V23400010","23400010","AP Assoc Co-Interest",-3814780.9,3185970.79,-628810.11]
["%,V23400111","23400111","AP Assoc Co-ERS_Only",-40817.699999999997,-8528.59,-49346.29]
["%,V23410000","23410000","Money Pool Borrowings",-24822682.550000001,21325151.370000001,-3497531.18]
["%,V23410001","23410001","Money Pool Borrowings Int Pay",-324.90999999999997,-143.41,-468.32]
["%,V23500000","23500000","Customer Deposits",-1612890.02,23539,-1589351.02]
["%,V23601000","23601000","Accrd Fed Inc Tax-Current",-3341360.84,496156,-2845204.84]
["%,V23602000","23602000","Accrd ST Inc Tax-Current Year",111880.19,93333,205213.19]
["%,V23603200","23603200","Accrd Property Tax",-12160898.01,405287.12,-11755610.890000001]
["%,V23603300","23603300","Accrd Sales and Use Tax",-2430.04,3715.65,1285.6100000000001]
["%,V23603400","23603400","Accrd Tax-FICA OASDI",-424662.55,0,-424662.55]
["%,V23603700","23603700","Accrued FICA Taxes",-56893.440000000002,-20620.38,-77513.820000000007]
["%,V23604000","23604000","Accrd Unempl Insur-Fed",134.76,-11.09,123.67]
["%,V23604100","23604100","Accrd Unempl Insur-State",-163.51999999999998,72.16,-91.36]
["%,V23700010","23700010","Int Accrued-Cust Deposit",-28055.48,-57.910000000000004,-28113.39]
["%,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",-71646.45,21006.98,-50639.47]
["%,V24103400","24103400","Tax Coll Pay Util Gross Rcpts",-546884.82000000007,118061.5,-428823.32]
["%,V24103600","24103600","Tax Coll Pay State-Local Oth",-360.87,39.9,-320.97000000000003]
["%,V24200070","24200070","Accd Liab-Severance",-283805.31,-38652.61,-322457.92]
["%,V24201629","24201629","Accd Liab-Unclaimed AP Checks",-310068.31,87.18,-309981.13]
["%,V24203000","24203000","Accd Liab-Profit Sharing",-82097.799999999988,-14021.07,-96118.87]
["%,V24203100","24203100","Accd Liab-Incentive Compnstion",-505205.39999999997,-105510.06,-610715.46]
["%,V24203200","24203200","Accd Liab-Vacation Pay PY",-1282841.17,117445.48,-1165395.69]
["%,V24203201","24203201","Accd Liab-Vacation Pay CY",-519339.13000000006,-106329.56,-625668.69000000006]
["%,V24203305","24203305","Accd Liab-Gross Payroll",-238499.20000000004,-164037.4,-402536.60000000003]
["%,V24204000","24204000","Accd Liab-PR Ded Misc",-32100.27,0,-32100.27]
["%,V24204040","24204040","Accd Liab-PR Ded Union Dues",0,6432.81,6432.81]
["%,V24204050","24204050","Accd Liab-PR Ded Wage Attchmt",-1677.18,581.25,-1095.93]
["%,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",-5967.25,7286.1,1318.8500000000001]
["%,V24204081","24204081","Accd Liab-PR Ded ThrftPlan EE",-38574.400000000001,-4812.51,-43386.91]
["%,V24204082","24204082","Accd Liab-PR Ded Roth401k Plan",-2399.38,-596.04,-2995.42]
["%,V24204090","24204090","Accd Liab-PR Ded FSA Health",-83.33,0,-83.33]
["%,V24204091","24204091","Accd Liab-PR Ded FSA Dep Care",-375,0,-375]
["%,V24204092","24204092","Accd Liab-PR Ded HSA Benefits",-25241.55,-73.22,-25314.77]
["%,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",-9355,-4840,-14195]
["%,V24207000","24207000","Accd Liab-Professional Srvcs",-92345.65,-13972.130000000001,-106317.78]
["%,V24207020","24207020","Accd Liab-Benefits Admin Fees",-16163.62,4684.3500000000004,-11479.27]
["%,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",2364.12,-50.69,2313.4299999999998]
["%,V24224000","24224000","Customer AR Credit Balances",-2331348.44,-1021541.6,-3352890.04]
["%,V24240050","24240050","Accd Liab-Shipper Gas",-98838.499999999942,-434030.95,-532869.44999999995]
["%,V24250110","24250110","Accd Liab-Heatshare Cust Cntri",0,-1455,-1455]
["%,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",15791.329999999998,3188.2200000000003,18979.55]
["%,V24300003","24300003","Oblig Cap Leases Curr-Transfer",-16399.739999999998,-3311.06,-19710.8]
["%,V24310000","24310000","Oblig Operating Lease Curr-BB",-337920.06,0,-337920.06]
["%,V24310001","24310001","Oblig Operating Lease Curr-Add",-127447.59,-31174.53,-158622.12]
["%,V24310002","24310002","Oblig Operating Lease Curr-Pay",{"$f":"F202-E202","v":249070.29000000004},48823.99,297894.28000000003]
["%,V24310003","24310003","Oblig Operating Lease Curr-Trn",-34247.47,-6916.6500000000005,-41164.120000000003]
["%,V25200000","25200000","Custmr Advn for Constr NonCur",-2817449.89,2495.64,-2814954.25]
["%,V25400450","25400450","Reg Liab Curr-Other",3304.3,6622.38,9926.68]
["%,V25401000","25401000","Reg Liab Curr-Inc Tax Fed/St",-1106351,0,-1106351]
["%,V25401350","25401350","Reg Liab Curr-DSM Uncollect",-111600.80000000002,-36013.279999999999,-147614.08000000002]
["%,V25402400","25402400","Reg Liab Curr-Asset Reclass",-292279.7,-31579.11,-323858.81]
["%,V25402900","25402900","Reg Lia Curr-AMRP",-1193811.8,-129935.47,-1323747.27]
["%,V25405000","25405000","Reg Liab NC-Inc Tax Fed-St",-36281236.18,84949,-36196287.18]
["%,V25405050","25405050","Reg Liab NC-Deferred ITC",-24422.600000000002,1245,-23177.600000000002]
["%,V25500000","25500000","Investment Tax Credit-ITC",-42645,2037,-40608]
["%,V28205000","28205000","Fed ADIT-Property",-56548379,-211216,-56759595]
["%,V28206000","28206000","St ADIT-Property",-11038185,-74859,-11113044]
["%,V28305000","28305000","Fed ADIT-Other NC",243634,2567,246201]
["%,V28306000","28306000","ST ADIT-NC Other",61062,3342,64404]
["%,V40300000","40300000","Dep Exp",6013013.1000000006,1225837.22,7238850.3200000003]
["%,V40430000","40430000","Amortization Exp-Other",173872.01,34558.449999999997,208430.46]
["%,V40434000","40434000","Cloude Amortizaiton Expense",46374.59,11208.800000000001,57583.39]
["%,V40500000","40500000","Amortization of Oth Plant",508700.41,111858.44,620558.85]
["%,V40813100","40813100","Tax Exp-License_Franchise",3000,0,3000]
["%,V40813200","40813200","Tax Exp-Property",2440647.09,548738.42000000004,2989385.51]
["%,V40813300","40813300","Tax Exp-Sales and Use Tax",-0.04,0.02,-0.02]
["%,V40814100","40814100","Tax Exp-Payroll-Incentive",-11815.3,5148.82,-6666.4800000000005]
["%,V40814500","40814500","Tax Exp-Payroll FICA-OASDI",305149.03000000003,60282.25,365431.28]
["%,V40814600","40814600","Tax Exp-Payroll FICA-Medicar",72055.510000000009,14566.51,86622.02]
["%,V40814700","40814700","Tax Exp-FUTA Employer",5191.57,6.01,5197.58]
["%,V40814800","40814800","Tax Exp-SUTA Employer",4323.33,14.67,4338]
["%,V40911000","40911000","Util Cur Fed Exp",2447421,-503698,1943723]
["%,V40912000","40912000","Util Cur ST Exp",50521,-95223,-44702]
["%,V40921000","40921000","Non Util Cur Fed Exp",170818,7542,178360]
["%,V40922000","40922000","Non Util Cur ST Exp",42812,1890,44702]
["%,V41011000","41011000","Util Def Fed Exp-Dr",2266822,318151,2584973]
["%,V41012000","41012000","Util Def ST Exp-Dr",1015801,35253,1051054]
["%,V41111000","41111000","Util Def Fed Exp-Cr",-1793130,-264901,-2058031]
["%,V41112000","41112000","Util Def ST Exp-Cr",-307646,-47609,-355255]
["%,V41141000","41141000","Def Inc Tax-Fed-Cr-Util ITC",-10185,-2037,-12222]
["%,V41700000","41700000","Non Util Revenues",-197671.58000000002,3197.48,-194474.1]
["%,V41715000","41715000","Non Util Operating Exp",-2903.0099999999998,-2472.2000000000003,-5375.21]
["%,V41810000","41810000","Affil Equity in Earngs of Subs",-335.81,-9.43,-345.24]
["%,V41910000","41910000","Allow for Other FUDC",-164446.92000000001,-39968.559999999998,-204415.48]
["%,V42101450","42101450","Gas Cost Recovery Initiatives",-587675.15999999992,-8543.42,-596218.57999999996]
["%,V42121000","42121000","Loss on Disposition of Asset",39513.950000000004,0,39513.950000000004]
["%,V42500000","42500000","Misc Amortization",-10792.95,-2158.59,-12951.54]
["%,V42610000","42610000","Other Inc_Exp-Donations",13189.98,0,13189.98]
["%,V42630000","42630000","Penalties-Others",96001.36,12000,108001.36]
["%,V42640000","42640000","Oth Inc_Exp Political Contrib",2448.5,0,2448.5]
["%,V42654000","42654000","Other Misc Exp Deduction",0,1275,1275]
["%,V42655000","42655000","Other Income Deductions",81123.460000000006,16667,97790.46]
["%,V43000000","43000000","Int on Debt to Assoc Co",3165010.4699999997,628810.03,3793820.5]
["%,V43002000","43002000","Int on Debt to Assoc Co MonyPl",13266.85,468.32,13735.17]
["%,V43100000","43100000","Other Interest Exp",-24637.27,-2491.38,-27128.65]
["%,V43105100","43105100","Oth Int Exp-Cust Deposits",962.1400000000001,159.07,1121.21]
["%,V43200000","43200000","Allow for Borrowd FUDC",-54504.98,-17183.96,-71688.94]
["%,V48000000","48000000","Residential Sales",-49928919.160000004,-3862071.7199999997,-53790990.880000003]
["%,V48000100","48000100","Residential Sales Norm",-7084.18,64.97,-7019.21]
["%,V48101000","48101000","Commercial Gas Sales",-20273215.23,-1710620.87,-21983836.100000001]
["%,V48101200","48101200","Commercial Gas Sales Norm",-3732.23,44.87,-3687.36]
["%,V48102000","48102000","Industrial Gas Sales",-1014892.05,-62214.26,-1077106.31]
["%,V48102300","48102300","Industrial Gas Sales Norm",-234.83,6.88,-227.95000000000002]
["%,V48103000","48103000","Gas Sales-Other",0,-88.18,-88.18]
["%,V48300000","48300000","Sales for Resale-Gas",-47188.3,-4433.74,-51622.04]
["%,V48700000","48700000","Forfeited Discounts-Gas",-326450.32999999996,-41950.16,-368400.49]
["%,V48800000","48800000","Misc Service Revenues-Gas",-38221.229999999996,-4273.55,-42494.78]
["%,V48930000","48930000","Transp Rev Distr Residential",-4215425.4700000007,-431375.56,-4646801.03]
["%,V48930200","48930200","Unbilled Residential Trans Vol",{"$f":"F266-E266","v":272480.09999999998},68587.600000000006,341067.7]
["%,V48930300","48930300","Unbilled Res Trans Cust chrg",7328,1472,8800]
["%,V48931000","48931000","Transp Rev Distr Commercial",-4547124.3699999992,-514465.69,-5061590.0599999996]
["%,V48931300","48931300","Unbilled Comm Trans Vol",202514.4,39615.57,242129.97]
["%,V48931400","48931400","Unbilled Comm Trans Cust chrg",4733.09,536.28,5269.37]
["%,V48932000","48932000","Transp Rev Distr Industrial",-2333991.59,-402405.87,-2736397.46]
["%,V48932400","48932400","Unbilled Ind Trans Vol",2707.66,41.34,2749]
["%,V49300000","49300000","Rent from Gas Property",-14260,-2852,-17112]
["%,V49500000","49500000","Other Gas Revenue",-226863.2,-12357.52,-239220.72]
["%,V49500050","49500050","Billed Off System Sales",-924145.24,-396941.8,-1321087.04]
["%,V49500485","49500485","Unbilled Residential-Vol",4906117.1599999992,1049593.1100000001,5955710.2699999996]
["%,V49501485","49501485","Unbilled Res Customer Chrg",3423.7999999999993,13376,16799.8]
["%,V49510485","49510485","Unbilled Commercial-Vol",1971575.14,214018.61000000002,2185593.75]
["%,V49511485","49511485","Unbilled Comm Customer Chrg",3441.13,1787.6000000000001,5228.7300000000005]
["%,V49520485","49520485","Unbilled Industrial-Vol",51290.57,59.42,51349.99]
["%,V80100000","80100000","Natural gas field line purchas",135933.56,33719.33,169652.89]
["%,V80300300","80300300","Short Term Producer Purch",14904461.740000002,5493297.8099999996,20397759.550000001]
["%,V80300400","80300400","Transportation Pipeline Exp",4127815.4699999997,729142.49,4856957.96]
["%,V80300500","80300500","Storage Charges Pipeline Exp",-2325992.3000000003,-118572.32,-2444564.62]
["%,V80300600","80300600","OFS_System Supply Credit",-231917.22000000003,-33233.94,-265151.16000000003]
["%,V80300808","80300808","Storage Demand",6631914.2000000002,1502153.12,8134067.3200000003]
["%,V80400000","80400000","Natural Gas City Gate Purchase",1143731.99,14788.62,1158520.6100000001]
["%,V80510000","80510000","Purchased Gas Cost Adjustments",-1335597.94,-2714545.0300000003,-4050142.97]
["%,V80601000","80601000","Exchange Gas-Received",-2191411.31,434030.95,-1757380.3599999999]
["%,V80720000","80720000","Oper-Purch Gas Measrg Stations",181800.27000000002,29734.99,211535.26]
["%,V80751000","80751000","Purch Gas Exp - Mgmt Fee",25635.100000000002,4272.16,29907.260000000002]
["%,V80810000","80810000","Gas Withdrawn",14903463.16,279102.03000000003,15182565.189999999]
["%,V80820000","80820000","Gas Delivered",-6809958.7599999988,-4598410.03,-11408368.789999999]
["%,V81220000","81220000","Gas Used-Other-Offset",-62136.340000000004,-3441.87,-65578.210000000006]
["%,V85200030","85200030","Communication System Exp",4332.0200000000004,64.53,4396.55]
["%,V86600000","86600000","Trans Maint Commun Equip",0,30255,30255]
["%,V87000000","87000000","Op Superv-Eng-Gas Distr",469949.36,82387.66,552337.02]
["%,V87100000","87100000","Distribution Load Dispatching",77734.069999999992,10511.44,88245.51]
["%,V87400000","87400000","Mains and Services Exp",2784086.8400000003,526674.65,3310761.49]
["%,V87500000","87500000","Measur-Reg Statn Exp Gen",96510.97,12366.91,108877.88]
["%,V87600000","87600000","Measur-Reg Statn Exp-Indus",30057.919999999998,6723.97,36781.89]
["%,V87800000","87800000","Meter and House Regulator Exp",601357.75,134733.82,736091.57000000007]
["%,V87900000","87900000","Oper Installation Service Exp",1119336.9500000002,272154.21000000002,1391491.1600000001]
["%,V87900200","87900200","Oper Install-Chrg Labor",28.03,0,28.03]
["%,V88000000","88000000","Operations Exp Other",500816.13,68940.61,569756.74]
["%,V88100000","88100000","Gas Distr Rents",2637.49,4236.38,6873.87]
["%,V88500000","88500000","Maint Supv-Eng-Gas Distr",36463.17,6512.01,42975.18]
["%,V88600000","88600000","Maint Struct-Improv-Gas Distr",34240.670000000006,1150.99,35391.660000000003]
["%,V88700000","88700000","Maint of Mains",919698.09000000008,191529.02,1111227.1100000001]
["%,V88900000","88900000","Maint Msr-Reg Statn Equi Gen",223188.29000000004,68097.31,291285.60000000003]
["%,V89000000","89000000","Maint Meas_Reg Stn Equip-Distr",34052.639999999999,7083.09,41135.730000000003]
["%,V89200000","89200000","Maint of Services",399780.59,86891.87,486672.46]
["%,V89300000","89300000","Maint Meters_House Regulators",61365.840000000004,33174.51,94540.35]
["%,V89400000","89400000","Other Maint Equipment",182462,28135.23,210597.23]
["%,V90100000","90100000","Customer Acnt Supervision",134.6,47.28,181.88]
["%,V90200000","90200000","Cust Accnt Meter Reading Exp",80493.399999999994,21025.79,101519.19]
["%,V90300000","90300000","Cust Records Collection Exp",1098316.2000000002,204582.9,1302899.1000000001]
["%,V90400000","90400000","Uncollectible Accounts",-625606.73,376262.18,-249344.55000000002]
["%,V90500000","90500000","Misc Cust Accts Exp",4845.57,784.26,5629.83]
["%,V90800000","90800000","Customer Assistance Exp",55998.01,748,56746.01]
["%,V91000000","91000000","Misc Cust Serv and Info Exp",113069.99,20736.920000000002,133806.91]
["%,V91200000","91200000","Demonstrating and Selling Exp",2634.5,0,2634.5]
["%,V91300000","91300000","Sales Advertising Exp",1888.45,246.72,2135.17]
["%,V92000000","92000000","A_G Salaries",3387123.2800000003,696611.59,4083734.87]
["%,V92001000","92001000","Discretionary and Spot Awards",16496.25,11714.82,28211.07]
["%,V92002000","92002000","Stock Compensation Expense",250752.35000000003,77233.86,327986.21000000002]
["%,V92100000","92100000","Office Supplies and Exp",358064.43000000005,65194.91,423259.34]
["%,V92101000","92101000","Employee Expenses",65756.81,19787.78,85544.59]
["%,V92300000","92300000","Outside Service Employed",2095273.57,507825.68,2603099.25]
["%,V92301000","92301000","Mgmt Fee Actuals-Affil",{"$f":"F330-E330","v":792829.86},153770.26999999999,946600.13]
["%,V92400000","92400000","Property Insurance",17672.149999999998,5317.81,22989.96]
["%,V92500000","92500000","Injuries and Damages",893215.78999999992,198556.11000000002,1091771.8999999999]
["%,V92600000","92600000","Employee Pensions and Benefits",1724188.68,262634.01,1986822.69]
["%,V92601000","92601000","Non Service Pension & OPEB",-233612.53000000003,-10652.83,-244265.36000000002]
["%,V92800000","92800000","Regulatory Commission Exp",113248.87999999999,22650.14,135899.01999999999]
["%,V93010000","93010000","General Advertising Exp",5971.8899999999994,2244.41,8216.2999999999993]
["%,V93020000","93020000","Misc General Exp",16193.400000000001,-7300.7,8892.7000000000007]
["%,V93100000","93100000","Rents Admin and General",376922.76,74162.97,451085.73]
["%,V93200000","93200000","Maint General Plant",601669.51,108103.62,709773.13]
["%,V99000001","99000001","Gross Payroll Hyperion",3180255.5100000002,629568.44000000006,3809823.95]
["%,V99000004","99000004","Management Fee Hyperion",33858.939999999995,41875.51,75734.45]
["%,V99900001","99900001","Gross Pay Offset Hyperion",-3180255.5100000002,-629568.44000000006,-3809823.95]
["%,V99900002","99900002","Mgmt Fee Offset Hyperion",-33858.939999999995,-41875.51,-75734.45]
["%,FACCOUNT,X,_",null,"Total:",{"$f":"F344-E344","v":1.0379153536632657E-7},-7.2104739956557751E-9,9.6581061370670795E-8]