{"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":347,"n_cols":6,"rows_kept":347,"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 July 31, 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",39338745.010000005,4264581.55,43603326.560000002]
["%,V10100002","10100002","Plant In Service-Retirements",-3671830.6099999994,-604201.41,-4276032.0199999996]
["%,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",158622.12000000002,5658.8,164280.92000000001]
["%,V10112002","10112002","Right of Use Asset-Retirements",-328634.56,-24857.73,-353492.29]
["%,V10112004","10112004","Right of Use Asset-Amort",34523.42,-9335.43,25187.99]
["%,V10140000","10140000","Cloud Plant In Svc-Beg Bal",445509.8,0,445509.8]
["%,V10140001","10140001","Cloud Plant in Svc-Additions",284200.85000000003,383279.29,667480.14]
["%,V10600000","10600000","Comp Constr Not Class Beg Bal",31925634.239999998,0,31925634.239999998]
["%,V10600003","10600003","Comp Const not Class Other",-13838537.729999999,1390139.44,-12448398.289999999]
["%,V10700000","10700000","CWIP-Beg Balance",12900609.609999999,0,12900609.609999999]
["%,V10700001","10700001","CWIP-Additions",31302191.260000002,7159832.1600000001,38462023.420000002]
["%,V10700003","10700003","CWIP-Other Changes",-25500207.280000001,-5654720.9900000002,-31154928.27]
["%,V10740000","10740000","Cloud CWIP-Beg Balance",294344.10000000003,0,294344.10000000003]
["%,V10740001","10740001","Cloud CWIP-Additions",439651.43,83385.820000000007,523037.25]
["%,V10740003","10740003","Cloud CWIP-Oth Changes",-284200.85000000003,-383279.29,-667480.14]
["%,V10800000","10800000","Accum Deprec Plant -Beg Bal",-162395239.84999999,0,-162395239.84999999]
["%,V10800001","10800001","Accum Deprec Plant-Additions",-7284924.8600000013,-1233559.44,-8518484.3000000007]
["%,V10800002","10800002","Accum Deprec Plant-Retiremnt",2497867.31,578301.89,3076169.2]
["%,V10800003","10800003","Accum Deprec Plant-Other Chg",1705025.4200000002,167635.91,1872661.33]
["%,V10800010","10800010","Retirement WIP-Beg Bal",820744.24,0,820744.24]
["%,V10800011","10800011","Retirement WIP-Additions",1604032.7100000002,378322.47000000003,1982355.1800000002]
["%,V10800013","10800013","Retirement WIP-Other Changes",-1710304.11,-167635.91,-1877940.02]
["%,V10800100","10800100","Accum Deprec Cap Lease-Beg Bal",-145454.57,0,-145454.57]
["%,V10800101","10800101","Accum Deprec Cap Lease-Add",-19834.7,-3305.79,-23140.49]
["%,V11100000","11100000","Accum Amortization-Beg Bal",-6337654.0599999996,0,-6337654.0599999996]
["%,V11100001","11100001","Accum Amortization-Additions",-828989.31,-156444.94,-985434.25]
["%,V11100002","11100002","Accum Amortization-Retiremnt",1173963.3,25899.52,1199862.82]
["%,V11140000","11140000","Cloud Accum Amortiz-BegBal",-90129.46,0,-90129.46]
["%,V11140001","11140001","Cloud Accum Amortiz-Additions",-57583.39,-22801.11,-80384.5]
["%,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",12951.54,2158.59,15110.130000000001]
["%,V12310000","12310000","Inv Sub Co-Common Stock",174261,0,174261]
["%,V12310001","12310001","Inv Sub Co-PL",566081.13,20.78,566101.91]
["%,V12800000","12800000","Funds Held in Trust",2009289.66,35938.050000000003,2045227.71]
["%,V13100000","13100000","Cash",579908.71,-97642.72,482265.99]
["%,V13500000","13500000","Working Funds",212.64000000000001,0,212.64000000000001]
["%,V14200160","14200160","Cust AR-Credit Balances",3216479.0399999996,1701741.3900000001,4918220.43]
["%,V14200220","14200220","Cust AR-CAB",1650558.91,-1860674.0899999999,-210115.18]
["%,V14200250","14200250","Cust AR-GMB",27981.829999999998,-2932.28,25049.55]
["%,V14200260","14200260","Cust AR-Cust Premise Work",114876.17,-13798.26,101077.91]
["%,V14300001","14300001","Misc Accts Rec-Other",36166.700000000004,1922.24,38088.94]
["%,V14300018","14300018","Other AR-Billed OSS",430175.74,454769.75,884945.49]
["%,V14300220","14300220","Other AR-GMB Estimate",1485.48,-89.11,1396.3700000000001]
["%,V14300240","14300240","Other AR-GTS",1098799.07,-154664.55000000002,944134.52]
["%,V14300270","14300270","Other AR-Retail Service",4636.45,1545.25,6181.7]
["%,V14300290","14300290","Other AR-CNR",462317.49,0,462317.49]
["%,V14300330","14300330","Other AR Choice Trans-Columbia",-864918.39999999991,-437413.03,-1302331.43]
["%,V14300350","14300350","Other AR Choice Trans-Purchase",539670.52,-50668.69,489001.83]
["%,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",227828.39999999997,114496.02,342324.42]
["%,V14400150","14400150","Acc Prov for Uncol-Charge-Offs",907976.76,227210.77000000002,1135187.53]
["%,V14400200","14400200","Acc Prov for Uncol-Recoveries",-198761.15,-27392.190000000002,-226153.34]
["%,V14400600","14400600","Accm Prov Uncoll-Unbilled",-5919.97,2550.8000000000002,-3369.17]
["%,V14400700","14400700","Accm Prov Uncoll-Misc",-401312.87,0,-401312.87]
["%,V14600000","14600000","AR Assoc Co-Mech",4933.29,5882.39,10815.68]
["%,V14600002","14600002","AR Assoc Co-Misc",9465,0,9465]
["%,V14620000","14620000","Foreign Cash",70582.8,58.76,70641.56]
["%,V15400000","15400000","Plant Materials-Oth Supplies",305459.93,3741.4900000000002,309201.42]
["%,V15400800","15400800","Plant Mat-Meter Shop Clearing",{"$f":"F74-E74","v":1786.1000000000001},0,1786.1000000000001]
["%,V15410000","15410000","Fab Shop Inventory-SCB",0,-0.01,-0.01]
["%,V15420000","15420000","FabShop LP OH Build Ahead",5084.3100000000004,0,5084.3100000000004]
["%,V16411000","16411000","Gas Stored-Current-LIFO",26248060.390000001,12077378.960000001,38325439.350000001]
["%,V16500000","16500000","Other Misc Prepayments",-51246.02,-1860.4,-53106.42]
["%,V16500030","16500030","Prepaid Payroll",333403.46000000002,-333403.46000000002,0]
["%,V16503600","16503600","Prepaid Taxes - Other",-366.08999999999651,238716.37,238350.28]
["%,V16520000","16520000","Prepaid-Insurance Affiliate",129919.18,92093.03,222012.21]
["%,V16521000","16521000","Prepaid-Insurance NonAffil",148378.27000000002,737375.33,885753.6]
["%,V16591000","16591000","Prepaid-NC Cloud Cost Incurred",0.2,-0.08,0.12]
["%,V17300000","17300000","AR Accrued Revenues",4905665.66,26783.49,4932449.1500000004]
["%,V17302000","17302000","AR Accrd Rev Unbill Exch Gas",0,42350,42350]
["%,V17401000","17401000","Misc Assets-Exch Gas Receiv",0,1018413,1018413]
["%,V17403200","17403200","Misc Assets-Property Tax",3207900.04,-534650,2673250.04]
["%,V17406000","17406000","Misc Assets-Storage",9734727.2799999993,-8719464.7699999996,1015262.51]
["%,V18230200","18230200","Reg Asset Cr Bal Transf",323858.81000000006,88275.16,412133.97000000003]
["%,V18230440","18230440","Reg Asset GTI Funding",102147.2,13025.19,115172.39]
["%,V18230450","18230450","Reg Asset EAP",-336549.84,-57401.700000000004,-393951.54000000004]
["%,V18233420","18233420","Reg Asset-Prf Base Rt Adj PBRA",1760399.26,411.25,1760810.51]
["%,V18235114","18235114","NC Reg Asset FAS 158 OPEB",1452069.06,-10243.33,1441825.73]
["%,V18235115","18235115","NC Reg Asset FAS158 Pension",3577891.6399999997,-17575.28,3560316.36]
["%,V18235440","18235440","NC Reg Asset Rate Case Non-Cur",226876.59999999998,79946.39,306822.99]
["%,V18235450","18235450","NC Reg Asset Pen NQulfd FAS158",8283.44,-0.42,8283.02]
["%,V18235506","18235506","NC Reg Asset Def Depr Cap Lse",19367.600000000002,107.5,19475.100000000002]
["%,V18235530","18235530","NC Reg Asset COVID Costs",39472.129999999997,1172.55,40644.68]
["%,V18320000","18320000","Oth Prelim Survey B Bal",1564504.5899999999,0,1564504.5899999999]
["%,V18320001","18320001","Oth Prelim Survey Additions",-607425.4,218541.21,-388884.19]
["%,V18400200","18400200","Car Clearing",0,91.56,91.56]
["%,V18400250","18400250","Truck Clearing",0,0.1,0.1]
["%,V18400400","18400400","General Tool Clearing",0,0.04,0.04]
["%,V18400800","18400800","Meter Shop Clearing",0,46505.87,46505.87]
["%,V18600200","18600200","Def Debit-Maint and Jobng WIP",-37474.639999999999,-184.76,-37659.4]
["%,V18600400","18600400","DefDebitCusAdv_DEPPST12-31-99",2817449.89,-2495.64,2814954.25]
["%,V19005000","19005000","ADIT-Other-Noncurr-Fed",7658342,-73071,7585271]
["%,V19005100","19005100","ADIT Reg Liability NC - Fed",19515,-1049,18466]
["%,V19005400","19005400","ADIT FIT Gross Up",6695587,-22843,6672744]
["%,V19006000","19006000","ADIT-Other-Noncurr-State",868673,227668,1096341]
["%,V19006100","19006100","ADIT Reg Liability NC - State",2372,1182,3554]
["%,V19006400","19006400","ADIT SIT Gross Up",2252066,-1065,2251001]
["%,V19100100","19100100","Unrecov Purchs Gas Costs-Com",-2382561.9700000002,1842465.08,-540096.89]
["%,V19100400","19100400","End User Exchange",-444002.55000000005,573692.69000000006,129690.14]
["%,V19100800","19100800","Unrecov Purch Gas Cst-Unbill",-508625.86,-14472.630000000001,-523098.49]
["%,V20100000","20100000","Common Stock-Beg Balance",-23806200,0,-23806200]
["%,V21100000","21100000","APIC Beg Balance",-14951788.640000001,0,-14951788.640000001]
["%,V21101020","21101020","APIC Issuances",-11000000,0,-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",-22000000,0,-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",19710.8,3321.52,23032.32]
["%,V22710000","22710000","Oblig Operating Leas Beg Bal",-213646.87,0,-213646.87]
["%,V22710002","22710002","Oblig Operating Leas NC Transf",41164.120000000003,6939.18,48103.3]
["%,V22820000","22820000","Accum Prov Prop Injur Damg",-23939.3,6484.3,-17455]
["%,V22830010","22830010","Accum Prov-Banked Vacation",-584278.58000000007,40677.54,-543601.04]
["%,V22833000","22833000","Accum Provisions FAS 112",-290496.45,0,-290496.45]
["%,V22834010","22834010","Accum Provisions OPEB",-1341586.9500000002,63518.12,-1278068.83]
["%,V22838000","22838000","Accum Provisions Pen Cost Qual",-0.04,0,-0.04]
["%,V22838020","22838020","Accum Prov LT PenCost Non-Qual",-351.56,-0.42,-351.98]
["%,V22840030","22840030","NC Payroll Taxes Cares Act",-394678.44,0,-394678.44]
["%,V23200000","23200000","AP - AP Module Use Only",-3214797.7,115324.16,-3099473.54]
["%,V23200001","23200001","AP-Misc",-798744.93,-862769.37,-1661514.3]
["%,V23201055","23201055","AP-PNC Wires_ACH",{"$f":"F138-E138","v":-6109.36},-3348.9700000000003,-9458.33]
["%,V23201058","23201058","AP-PNC Land Disbursement",-30493.99,500,-29993.99]
["%,V23201061","23201061","AP-MellonBank Disbursement_ACH",-270053.40999999992,-1525339.8,-1795393.21]
["%,V23202300","23202300","AP-Gas Purchases-Producer",-5502644.0899999999,-642330.46,-6144974.5499999998]
["%,V23202400","23202400","AP-Gas Purchases-Transport",-2280485.06,44474.67,-2236010.39]
["%,V23202500","23202500","AP-Choice Marketer Payable",-317661.67,92647.08,-225014.59]
["%,V23202900","23202900","AP-CPG Non-Transition Srvces",-10133,-500,-10633]
["%,V23400000","23400000","AP Assoc Co-Mech",-2877381.99,-1380978.58,-4258360.57]
["%,V23400010","23400010","AP Assoc Co-Interest",-628810.11,-712879.62,-1341689.73]
["%,V23400111","23400111","AP Assoc Co-ERS_Only",-49346.29,-41546.840000000004,-90893.13]
["%,V23410000","23410000","Money Pool Borrowings",-3497531.1799999997,-10355573.470000001,-13853104.65]
["%,V23410001","23410001","Money Pool Borrowings Int Pay",-468.32000000000005,313.42,-154.9]
["%,V23500000","23500000","Customer Deposits",-1589351.02,31799,-1557552.02]
["%,V23601000","23601000","Accrd Fed Inc Tax-Current",-2845204.84,946058,-1899146.8399999999]
["%,V23602000","23602000","Accrd ST Inc Tax-Current Year",205213.19,-1,205212.19]
["%,V23603200","23603200","Accrd Property Tax",-11755610.890000001,2410157.2400000002,-9345453.6500000004]
["%,V23603300","23603300","Accrd Sales and Use Tax",1285.6100000000006,-12001.85,-10716.24]
["%,V23603400","23603400","Accrd Tax-FICA OASDI",-424662.55,0,-424662.55]
["%,V23603700","23603700","Accrued FICA Taxes",-77513.820000000007,22722.53,-54791.29]
["%,V23604000","23604000","Accrd Unempl Insur-Fed",123.66999999999999,-46.79,76.88]
["%,V23604100","23604100","Accrd Unempl Insur-State",-91.360000000000014,153.96,62.6]
["%,V23700010","23700010","Int Accrued-Cust Deposit",-28113.390000000003,-65.19,-28178.58]
["%,V24103110","24103110","Tax Coll Pay Fed Inc Tx",0,11.53,11.53]
["%,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",-50639.47,-12865.9,-63505.37]
["%,V24103400","24103400","Tax Coll Pay Util Gross Rcpts",-428823.32,36482.090000000004,-392341.23]
["%,V24103600","24103600","Tax Coll Pay State-Local Oth",-320.96999999999997,8.84,-312.13]
["%,V24200070","24200070","Accd Liab-Severance",-322457.92,0,-322457.92]
["%,V24201629","24201629","Accd Liab-Unclaimed AP Checks",-309981.13,0,-309981.13]
["%,V24203000","24203000","Accd Liab-Profit Sharing",-96118.87,-14021.07,-110139.94]
["%,V24203100","24203100","Accd Liab-Incentive Compnstion",-610715.46,-105510.06,-716225.52]
["%,V24203200","24203200","Accd Liab-Vacation Pay PY",-1165395.69,165849.25,-999546.44000000006]
["%,V24203201","24203201","Accd Liab-Vacation Pay CY",-625668.69000000006,-89521.51,-715190.20000000007]
["%,V24203305","24203305","Accd Liab-Gross Payroll",-402536.60000000003,402536.60000000003,0]
["%,V24204000","24204000","Accd Liab-PR Ded Misc",-32100.27,0,-32100.27]
["%,V24204040","24204040","Accd Liab-PR Ded Union Dues",6432.81,-6432.81,0]
["%,V24204050","24204050","Accd Liab-PR Ded Wage Attchmt",-1095.93,-561.75,-1657.68]
["%,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",1318.8500000000004,-9204.4600000000009,-7885.6100000000006]
["%,V24204081","24204081","Accd Liab-PR Ded ThrftPlan EE",-43386.909999999989,-24329.24,-67716.149999999994]
["%,V24204082","24204082","Accd Liab-PR Ded Roth401k Plan",-2995.42,-4459.22,-7454.64]
["%,V24204090","24204090","Accd Liab-PR Ded FSA Health",-83.330000000000013,41.67,-41.660000000000004]
["%,V24204091","24204091","Accd Liab-PR Ded FSA Dep Care",-375,0,-375]
["%,V24204092","24204092","Accd Liab-PR Ded HSA Benefits",-25314.77,9058.93,-16255.84]
["%,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",-14195,8035,-6160]
["%,V24207000","24207000","Accd Liab-Professional Srvcs",-106317.78,-14269,-120586.78]
["%,V24207020","24207020","Accd Liab-Benefits Admin Fees",-11479.27,-1843.1100000000001,-13322.380000000001]
["%,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.4300000000003,-86.8,2226.63]
["%,V24224000","24224000","Customer AR Credit Balances",-3352890.0399999996,-1691748.3900000001,-5044638.43]
["%,V24240050","24240050","Accd Liab-Shipper Gas",-532869.44999999984,-573692.69000000006,-1106562.1399999999]
["%,V24250110","24250110","Accd Liab-Heatshare Cust Cntri",-1455,88,-1367]
["%,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",18979.55,3198.29,22177.84]
["%,V24300003","24300003","Oblig Cap Leases Curr-Transfer",-19710.8,-3321.52,-23032.32]
["%,V24310000","24310000","Oblig Operating Lease Curr-BB",-337920.06,0,-337920.06]
["%,V24310001","24310001","Oblig Operating Lease Curr-Add",{"$f":"F202-E202","v":-158622.12000000002},-5658.8,-164280.92000000001]
["%,V24310002","24310002","Oblig Operating Lease Curr-Pay",297894.28000000003,36302.61,334196.89]
["%,V24310003","24310003","Oblig Operating Lease Curr-Trn",-41164.120000000003,-6939.18,-48103.3]
["%,V25200000","25200000","Custmr Advn for Constr NonCur",-2814954.25,-5117.0600000000004,-2820071.31]
["%,V25400450","25400450","Reg Liab Curr-Other",9926.68,8255.75,18182.43]
["%,V25401000","25401000","Reg Liab Curr-Inc Tax Fed/St",-1106351,0,-1106351]
["%,V25401350","25401350","Reg Liab Curr-DSM Uncollect",-147614.07999999999,-36022.76,-183636.84]
["%,V25402400","25402400","Reg Liab Curr-Asset Reclass",-323858.81000000006,-88275.16,-412133.97000000003]
["%,V25402900","25402900","Reg Lia Curr-AMRP",-1323747.27,4242.24,-1319505.03]
["%,V25405000","25405000","Reg Liab NC-Inc Tax Fed-St",-36196287.18,84951,-36111336.18]
["%,V25405050","25405050","Reg Liab NC-Deferred ITC",-23177.600000000002,-133,-23310.600000000002]
["%,V25500000","25500000","Investment Tax Credit-ITC",-40608,2037,-38571]
["%,V28205000","28205000","Fed ADIT-Property",-56759595,-211216,-56970811]
["%,V28206000","28206000","St ADIT-Property",-11113044,-74858,-11187902]
["%,V28305000","28305000","Fed ADIT-Other NC",246201,-424449,-178248]
["%,V28306000","28306000","ST ADIT-NC Other",64404,-93327,-28923]
["%,V40300000","40300000","Dep Exp",7238850.3200000003,1234011.27,8472861.5899999999]
["%,V40430000","40430000","Amortization Exp-Other",208430.46000000002,34820.400000000001,243250.86000000002]
["%,V40434000","40434000","Cloude Amortizaiton Expense",57583.39,22801.11,80384.5]
["%,V40500000","40500000","Amortization of Oth Plant",620558.85,121624.54000000001,742183.39]
["%,V40813100","40813100","Tax Exp-License_Franchise",3000,0,3000]
["%,V40813200","40813200","Tax Exp-Property",2989385.5100000002,548738.42000000004,3538123.93]
["%,V40813300","40813300","Tax Exp-Sales and Use Tax",-1.9999999999999997E-2,0.03,0.01]
["%,V40814100","40814100","Tax Exp-Payroll-Incentive",-6666.48,5148.82,-1517.66]
["%,V40814500","40814500","Tax Exp-Payroll FICA-OASDI",365431.28,55156.81,420588.09]
["%,V40814600","40814600","Tax Exp-Payroll FICA-Medicar",86622.02,13346.67,99968.69]
["%,V40814700","40814700","Tax Exp-FUTA Employer",5197.5800000000008,38.65,5236.2300000000005]
["%,V40814800","40814800","Tax Exp-SUTA Employer",4338,21.72,4359.72]
["%,V40911000","40911000","Util Cur Fed Exp",1943723,-953630,990093]
["%,V40912000","40912000","Util Cur ST Exp",-44702,-1897,-46599]
["%,V40921000","40921000","Non Util Cur Fed Exp",178360,7572,185932]
["%,V40922000","40922000","Non Util Cur ST Exp",44702,1898,46600]
["%,V41011000","41011000","Util Def Fed Exp-Dr",2584973,816972,3401945]
["%,V41012000","41012000","Util Def ST Exp-Dr",1051054,-40727,1010327]
["%,V41111000","41111000","Util Def Fed Exp-Cr",-2058031,-161294,-2219325]
["%,V41112000","41112000","Util Def ST Exp-Cr",-355255,-26741,-381996]
["%,V41141000","41141000","Def Inc Tax-Fed-Cr-Util ITC",-12222,-2037,-14259]
["%,V41700000","41700000","Non Util Revenues",-194474.1,-2048.4499999999998,-196522.55000000002]
["%,V41715000","41715000","Non Util Operating Exp",-5375.21,-15.370000000000001,-5390.58]
["%,V41810000","41810000","Affil Equity in Earngs of Subs",-345.24,-20.78,-366.02]
["%,V41910000","41910000","Allow for Other FUDC",-204415.48,-10503.93,-214919.41]
["%,V42101450","42101450","Gas Cost Recovery Initiatives",-596218.57999999996,-35548.78,-631767.36]
["%,V42121000","42121000","Loss on Disposition of Asset",39513.950000000004,0,39513.950000000004]
["%,V42500000","42500000","Misc Amortization",-12951.54,-2158.59,-15110.130000000001]
["%,V42610000","42610000","Other Inc_Exp-Donations",13189.98,1455,14644.98]
["%,V42630000","42630000","Penalties-Others",108001.36000000002,24000,132001.36000000002]
["%,V42640000","42640000","Oth Inc_Exp Political Contrib",2448.5,0,2448.5]
["%,V42654000","42654000","Other Misc Exp Deduction",1275,0,1275]
["%,V42655000","42655000","Other Income Deductions",97790.46,16667,114457.46]
["%,V43000000","43000000","Int on Debt to Assoc Co",3793820.5,712879.62,4506700.12]
["%,V43002000","43002000","Int on Debt to Assoc Co MonyPl",13735.17,154.9,13890.07]
["%,V43100000","43100000","Other Interest Exp",-27128.65,-1172.55,-28301.200000000001]
["%,V43105100","43105100","Oth Int Exp-Cust Deposits",1121.21,161.97999999999999,1283.19]
["%,V43200000","43200000","Allow for Borrowd FUDC",-71688.94,3928.19,-67760.75]
["%,V48000000","48000000","Residential Sales",-53790990.880000003,-3456695.32,-57247686.200000003]
["%,V48000100","48000100","Residential Sales Norm",-7019.21,39.619999999999997,-6979.59]
["%,V48101000","48101000","Commercial Gas Sales",-21983836.099999998,-1567037.55,-23550873.649999999]
["%,V48101200","48101200","Commercial Gas Sales Norm",-3687.36,43.77,-3643.59]
["%,V48102000","48102000","Industrial Gas Sales",-1077106.31,-57873.01,-1134979.32]
["%,V48102300","48102300","Industrial Gas Sales Norm",-227.95,3.41,-224.54]
["%,V48103000","48103000","Gas Sales-Other",-88.18,-47.9,-136.08000000000001]
["%,V48300000","48300000","Sales for Resale-Gas",-51622.04,-3601.88,-55223.92]
["%,V48700000","48700000","Forfeited Discounts-Gas",-368400.49,-34457.89,-402858.38]
["%,V48800000","48800000","Misc Service Revenues-Gas",-42494.780000000006,-6923.49,-49418.270000000004]
["%,V48930000","48930000","Transp Rev Distr Residential",{"$f":"F266-E266","v":-4646801.03},-407075.14,-5053876.17]
["%,V48930200","48930200","Unbilled Residential Trans Vol",341067.7,-3400.7000000000003,337667]
["%,V48930300","48930300","Unbilled Res Trans Cust chrg",8800,1456,10256]
["%,V48931000","48931000","Transp Rev Distr Commercial",-5061590.0600000005,-481706.38,-5543296.4400000004]
["%,V48931300","48931300","Unbilled Comm Trans Vol",242129.97,-10773.84,231356.13]
["%,V48931400","48931400","Unbilled Comm Trans Cust chrg",5269.3700000000008,-8308.2900000000009,-3038.92]
["%,V48932000","48932000","Transp Rev Distr Industrial",-2736397.46,-397097.06,-3133494.52]
["%,V48932400","48932400","Unbilled Ind Trans Vol",2749,-2202.7800000000002,546.22]
["%,V49300000","49300000","Rent from Gas Property",-17112,-2852,-19964]
["%,V49500000","49500000","Other Gas Revenue",-239220.72,-10433.99,-249654.71]
["%,V49500050","49500050","Billed Off System Sales",-1321087.0399999998,-882559.49,-2203646.5299999998]
["%,V49500485","49500485","Unbilled Residential-Vol",5955710.2699999996,-24442.13,5931268.1399999997]
["%,V49501485","49501485","Unbilled Res Customer Chrg",16799.8,6928,23727.8]
["%,V49510485","49510485","Unbilled Commercial-Vol",2185593.75,9216.9,2194810.65]
["%,V49511485","49511485","Unbilled Comm Customer Chrg",5228.7300000000014,8893.31,14122.04]
["%,V49520485","49520485","Unbilled Industrial-Vol",51349.990000000005,-7050.26,44299.73]
["%,V49521485","49521485","Unbilled Ind Customer Chrg",0,44.69,44.69]
["%,V55700000","55700000","Other Exp",0,147.72,147.72]
["%,V80100000","80100000","Natural gas field line purchas",169652.89,34020.800000000003,203673.69]
["%,V80300300","80300300","Short Term Producer Purch",20397759.550000001,6015610,26413369.550000001]
["%,V80300400","80300400","Transportation Pipeline Exp",4856957.959999999,713158.06,5570116.0199999996]
["%,V80300500","80300500","Storage Charges Pipeline Exp",-2444564.62,-86385.59,-2530950.21]
["%,V80300600","80300600","OFS_System Supply Credit",-265151.15999999997,-44736.01,-309887.17]
["%,V80300808","80300808","Storage Demand",8134067.3200000003,1502153.1400000001,9636220.4600000009]
["%,V80400000","80400000","Natural Gas City Gate Purchase",1158520.6099999999,6522.04,1165042.6499999999]
["%,V80510000","80510000","Purchased Gas Cost Adjustments",-4050142.97,-2401685.14,-6451828.1100000003]
["%,V80601000","80601000","Exchange Gas-Received",-1757380.3599999999,-444720.31,-2202100.67]
["%,V80720000","80720000","Oper-Purch Gas Measrg Stations",211535.26,24729.61,236264.87]
["%,V80751000","80751000","Purch Gas Exp - Mgmt Fee",29907.260000000002,4629.25,34536.51]
["%,V80810000","80810000","Gas Withdrawn",15182565.189999999,755007.31,15937572.5]
["%,V80820000","80820000","Gas Delivered",-11408368.789999999,-4112921.5,-15521290.289999999]
["%,V81220000","81220000","Gas Used-Other-Offset",-65578.210000000006,-2673.5,-68251.710000000006]
["%,V85200030","85200030","Communication System Exp",4396.55,11.58,4408.13]
["%,V86600000","86600000","Trans Maint Commun Equip",30255,0,30255]
["%,V87000000","87000000","Op Superv-Eng-Gas Distr",552337.02,72952.89,625289.91]
["%,V87100000","87100000","Distribution Load Dispatching",88245.510000000009,10114.17,98359.680000000008]
["%,V87400000","87400000","Mains and Services Exp",3310761.49,613779.11,3924540.6]
["%,V87500000","87500000","Measur-Reg Statn Exp Gen",108877.87999999999,13515.99,122393.87]
["%,V87600000","87600000","Measur-Reg Statn Exp-Indus",36781.89,5816.01,42597.9]
["%,V87800000","87800000","Meter and House Regulator Exp",736091.57,119127.15000000001,855218.72]
["%,V87900000","87900000","Oper Installation Service Exp",1391491.16,239369.61000000002,1630860.77]
["%,V87900200","87900200","Oper Install-Chrg Labor",28.03,0,28.03]
["%,V88000000","88000000","Operations Exp Other",569756.74,67914.48,637671.22]
["%,V88100000","88100000","Gas Distr Rents",6873.87,1484.39,8358.26]
["%,V88500000","88500000","Maint Supv-Eng-Gas Distr",42975.180000000008,5664.52,48639.700000000004]
["%,V88600000","88600000","Maint Struct-Improv-Gas Distr",35391.660000000003,28207.279999999999,63598.94]
["%,V88700000","88700000","Maint of Mains",1111227.1099999999,176161.52,1287388.6299999999]
["%,V88900000","88900000","Maint Msr-Reg Statn Equi Gen",291285.60000000003,66209.23,357494.83]
["%,V89000000","89000000","Maint Meas_Reg Stn Equip-Distr",41135.730000000003,7186.3600000000006,48322.090000000004]
["%,V89200000","89200000","Maint of Services",486672.46,82686.080000000002,569358.54]
["%,V89300000","89300000","Maint Meters_House Regulators",94540.35,37030.410000000003,131570.76]
["%,V89400000","89400000","Other Maint Equipment",210597.23,19509.55,230106.78]
["%,V90100000","90100000","Customer Acnt Supervision",181.88,0,181.88]
["%,V90200000","90200000","Cust Accnt Meter Reading Exp",101519.19,18972.07,120491.26000000001]
["%,V90300000","90300000","Cust Records Collection Exp",1302899.1000000001,199930.39,1502829.49]
["%,V90400000","90400000","Uncollectible Accounts",-249344.55,-88037.71,-337382.26]
["%,V90500000","90500000","Misc Cust Accts Exp",5629.83,769.96,6399.79]
["%,V90800000","90800000","Customer Assistance Exp",56746.01,-58.870000000000005,56687.14]
["%,V91000000","91000000","Misc Cust Serv and Info Exp",133806.91,23111.87,156918.78]
["%,V91200000","91200000","Demonstrating and Selling Exp",2634.5,652.46,3286.96]
["%,V91300000","91300000","Sales Advertising Exp",2135.17,1903.67,4038.84]
["%,V92000000","92000000","A_G Salaries",4083734.87,622333.13,4706068]
["%,V92001000","92001000","Discretionary and Spot Awards",28211.07,6544.53,34755.599999999999]
["%,V92002000","92002000","Stock Compensation Expense",327986.21000000002,74920.13,402906.34]
["%,V92100000","92100000","Office Supplies and Exp",{"$f":"F330-E330","v":423259.34},59764.630000000005,483023.97000000003]
["%,V92101000","92101000","Employee Expenses",85544.59,12538.130000000001,98082.72]
["%,V92300000","92300000","Outside Service Employed",2603099.25,434582.64,3037681.89]
["%,V92301000","92301000","Mgmt Fee Actuals-Affil",946600.13,156420.86000000002,1103020.99]
["%,V92400000","92400000","Property Insurance",22989.960000000006,69319.53,92309.49]
["%,V92500000","92500000","Injuries and Damages",1091771.8999999999,175437.52,1267209.42]
["%,V92600000","92600000","Employee Pensions and Benefits",1986822.69,388246.17,2375068.86]
["%,V92601000","92601000","Non Service Pension & OPEB",-244265.36,-78140.009999999995,-322405.37]
["%,V92800000","92800000","Regulatory Commission Exp",135899.02000000002,22634.77,158533.79]
["%,V93010000","93010000","General Advertising Exp",8216.3000000000011,37.74,8254.0400000000009]
["%,V93020000","93020000","Misc General Exp",8892.7000000000007,17545.34,26438.04]
["%,V93100000","93100000","Rents Admin and General",451085.73,73741.63,524827.36]
["%,V93200000","93200000","Maint General Plant",709773.13,100529.8,810302.93]
["%,V99000001","99000001","Gross Payroll Hyperion",3809823.9499999997,751939.81,4561763.76]
["%,V99000004","99000004","Management Fee Hyperion",75734.45,-4287.6499999999996,71446.8]
["%,V99900001","99900001","Gross Pay Offset Hyperion",-3809823.9499999997,-751939.81,-4561763.76]
["%,V99900002","99900002","Mgmt Fee Offset Hyperion",-75734.45,4287.6499999999996,-71446.8]
["%,FACCOUNT,X,_",null,"Total:",{"$f":"F347-E347","v":2.0775223674718291E-7},-3.0504452297464013E-9,2.047017915174365E-7]