{"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":340,"n_cols":6,"rows_kept":340,"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, 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",29322995.840000004,2764954.76,32087950.600000001]
["%,V10100002","10100002","Plant In Service-Retirements",-2395881.2400000002,-347241.33,-2743122.5700000003]
["%,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",156913.44,30897.31,187810.75]
["%,V10112002","10112002","Right of Use Asset-Retirements",-163956.56,-84577.19,-248533.75]
["%,V10112004","10112004","Right of Use Asset-Amort",-118599.04000000001,42994.450000000004,-75604.59]
["%,V10140001","10140001","Cloud Plant in Svc-Additions",376117.61,30.080000000000002,376147.69]
["%,V10600000","10600000","Comp Constr Not Class Beg Bal",25494536.100000001,0,25494536.100000001]
["%,V10600003","10600003","Comp Const not Class Other",-15229957.949999999,2381303.0499999998,-12848654.9]
["%,V10700000","10700000","CWIP-Beg Balance",6796654.0499999998,0,6796654.0499999998]
["%,V10700001","10700001","CWIP-Additions",24951586.369999997,5751082.8499999996,30702669.219999999]
["%,V10700003","10700003","CWIP-Other Changes",-14093037.890000001,-5146257.8099999996,-19239295.699999999]
["%,V10740001","10740001","Cloud CWIP-Additions",528048.1,28612.41,556660.51]
["%,V10740003","10740003","Cloud CWIP-Oth Changes",-376117.61,-30.080000000000002,-376147.69]
["%,V10800000","10800000","Accum Deprec Plant -Beg Bal",-158204680.40000001,0,-158204680.40000001]
["%,V10800001","10800001","Accum Deprec Plant-Additions",-5524707.5,-1106858.74,-6631566.2400000002]
["%,V10800002","10800002","Accum Deprec Plant-Retiremnt",1689737.91,332425,2022162.91]
["%,V10800003","10800003","Accum Deprec Plant-Other Chg",1267922.98,276835.49,1544758.47]
["%,V10800010","10800010","Retirement WIP-Beg Bal",663564.85,0,663564.85]
["%,V10800011","10800011","Retirement WIP-Additions",1131778.78,268343.28999999998,1400122.07]
["%,V10800013","10800013","Retirement WIP-Other Changes",-1286069.1400000001,-297486,-1583555.1400000001]
["%,V10800100","10800100","Accum Deprec Cap Lease-Beg Bal",-105785.15000000001,0,-105785.15000000001]
["%,V10800101","10800101","Accum Deprec Cap Lease-Add",-16528.940000000002,-3305.78,-19834.72]
["%,V11100000","11100000","Accum Amortization-Beg Bal",-6072689.5800000001,0,-6072689.5800000001]
["%,V11100001","11100001","Accum Amortization-Additions",-644088.64,-131454.23000000001,-775542.87]
["%,V11100002","11100002","Accum Amortization-Retiremnt",706143.33000000007,14816.33,720959.66]
["%,V11140001","11140001","Cloud Accum Amortiz-Additions",-34017.06,-6925.93,-40942.99]
["%,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",10792.95,2158.59,12951.54]
["%,V12310000","12310000","Inv Sub Co-Common Stock",174261,0,174261]
["%,V12310001","12310001","Inv Sub Co-PL",551557.19000000006,1202.0899999999999,552759.28]
["%,V12800000","12800000","Funds Held in Trust",446612.64999999997,31665.33,478277.98]
["%,V13100000","13100000","Cash",429989.76,26916.639999999999,456906.4]
["%,V14200160","14200160","Cust AR-Credit Balances",1985434.46,1142375.6299999999,3127810.09]
["%,V14200220","14200220","Cust AR-CAB",4138403.92,-2322862.83,1815541.0899999999]
["%,V14200250","14200250","Cust AR-GMB",147734.01,-85153.61,62580.4]
["%,V14200260","14200260","Cust AR-Cust Premise Work",644213.41,2585.13,646798.54]
["%,V14300001","14300001","Misc Accts Rec-Other",1027004.69,1157.3,1028161.99]
["%,V14300018","14300018","Other AR-Billed OSS",0,54039,54039]
["%,V14300220","14300220","Other AR-GMB Estimate",3214.75,-1426.8500000000001,1787.9]
["%,V14300240","14300240","Other AR-GTS",1027343.6000000001,-88494.94,938848.66]
["%,V14300270","14300270","Other AR-Retail Service",1557.75,1646.94,3204.69]
["%,V14300290","14300290","Other AR-CNR",512227.81000000006,16052.86,528280.67000000004]
["%,V14300330","14300330","Other AR Choice Trans-Columbia",-347969,-477148.27,-825117.27]
["%,V14300350","14300350","Other AR Choice Trans-Purchase",902262.62,-295757.39,606505.23]
["%,V14300395","14300395","Other AR-CPG Non-Transit Srvcs",61935.930000000008,6192,68127.930000000008]
["%,V14400000","14400000","Acc Prov for Uncol-Beg Bal",-207653.9,0,-207653.9]
["%,V14400100","14400100","Acc Prov for Uncol-Reserve",-460325.21,-458010.45,-918335.66]
["%,V14400150","14400150","Acc Prov for Uncol-Charge-Offs",287306.15999999997,34018.71,321324.87]
["%,V14400200","14400200","Acc Prov for Uncol-Recoveries",-95983.57,-30946.07,-126929.64]
["%,V14400600","14400600","Accm Prov Uncoll-Unbilled",-41373.43,385.85,-40987.58]
["%,V14400700","14400700","Accm Prov Uncoll-Misc",-401312.87,0,-401312.87]
["%,V14600000","14600000","AR Assoc Co-Mech",38600.380000000005,26422.920000000002,65023.3]
["%,V14600002","14600002","AR Assoc Co-Misc",9545,0,9545]
["%,V14620000","14620000","Foreign Cash",816.82,521.09,1337.91]
["%,V15400000","15400000","Plant Materials-Oth Supplies",295833.7,402.44,296236.14]
["%,V15420000","15420000","FabShop LP OH Build Ahead",550,-550,0]
["%,V16411000","16411000","Gas Stored-Current-LIFO",7658804.2699999977,11959345.470000001,19618149.739999998]
["%,V16500000","16500000","Other Misc Prepayments",-15358.029999999999,-10592.84,-25950.87]
["%,V16500030","16500030","Prepaid Payroll",0,324850.89,324850.89]
["%,V16503600","16503600","Prepaid Taxes - Other",23000.81,-23000.82,-0.01]
["%,V16520000","16520000","Prepaid-Insurance Affiliate",{"$f":"F74-E74","v":186707.47},-61294.99,125412.48]
["%,V16521000","16521000","Prepaid-Insurance NonAffil",185667.14,-62509.87,123157.27]
["%,V16591000","16591000","Prepaid-NC Cloud Cost Incurred",0.13,0,0.13]
["%,V17300000","17300000","AR Accrued Revenues",5140774.9799999995,-762222.22,4378552.76]
["%,V17302000","17302000","AR Accrd Rev Unbill Exch Gas",70598.080000000002,89843.76,160441.84]
["%,V17401000","17401000","Misc Assets-Exch Gas Receiv",0,105725,105725]
["%,V17403200","17403200","Misc Assets-Property Tax",3331358.35,-475908.33,2855450.02]
["%,V17406000","17406000","Misc Assets-Storage",26983464.190000001,-7990061.7300000004,18993402.460000001]
["%,V18230200","18230200","Reg Asset Cr Bal Transf",302011.08999999997,21847.72,323858.81]
["%,V18230440","18230440","Reg Asset GTI Funding",83699.790000000008,14933.61,98633.400000000009]
["%,V18230450","18230450","Reg Asset EAP",-211801.83,-56077.91,-267879.74]
["%,V18233420","18233420","Reg Asset-Prf Base Rt Adj PBRA",2455709.8499999996,22417.24,2478127.09]
["%,V18235114","18235114","NC Reg Asset FAS 158 OPEB",2142245.29,-12691.75,2129553.54]
["%,V18235115","18235115","NC Reg Asset FAS158 Pension",5741965.8600000003,-33444.42,5708521.4400000004]
["%,V18235440","18235440","NC Reg Asset Rate Case Non-Cur",1369.94,0,1369.94]
["%,V18235450","18235450","NC Reg Asset Pen NQulfd FAS158",13550.15,-80.17,13469.98]
["%,V18235506","18235506","NC Reg Asset Def Depr Cap Lse",17066.07,235.84,17301.91]
["%,V18320000","18320000","Oth Prelim Survey B Bal",476567.58,0,476567.58]
["%,V18320001","18320001","Oth Prelim Survey Additions",451565.48,45615.58,497181.06]
["%,V18400100","18400100","Building Clearing",426.48,0,426.48]
["%,V18400101","18400101","Convenience Bill Clearing",10.44,0,10.44]
["%,V18400200","18400200","Car Clearing",-3145.34,2337.5,-807.84]
["%,V18400250","18400250","Truck Clearing",-5.0000000000000044E-2,0.78,0.73]
["%,V18400275","18400275","Clearing-Fleet",309.06,-309.06,0]
["%,V18400400","18400400","General Tool Clearing",0,-0.05,-0.05]
["%,V18400900","18400900","Sand-Gravel Clearing",-4.43,0,-4.43]
["%,V18600200","18600200","Def Debit-Maint and Jobng WIP",-71599.360000000001,42477.17,-29122.190000000002]
["%,V18600400","18600400","DefDebitCusAdv_DEPPST12-31-99",2987774.69,-2105.11,2985669.58]
["%,V19005000","19005000","ADIT-Other-Noncurr-Fed",8821571,83533,8905104]
["%,V19005100","19005100","ADIT Reg Liability NC - Fed",33151,-1049,32102]
["%,V19005400","19005400","ADIT FIT Gross Up",7129719,-20297,7109422]
["%,V19006000","19006000","ADIT-Other-Noncurr-State",1121435,11012,1132447]
["%,V19006100","19006100","ADIT Reg Liability NC - State",4933,-197,4736]
["%,V19006400","19006400","ADIT SIT Gross Up",2288400,-883,2287517]
["%,V19100100","19100100","Unrecov Purchs Gas Costs-Com",-6289959.3600000003,-1716992.71,-8006952.0700000003]
["%,V19100400","19100400","End User Exchange",-435194.88,-22579.97,-457774.85000000003]
["%,V19100800","19100800","Unrecov Purch Gas Cst-Unbill",-647861,328285.61,-319575.39]
["%,V20100000","20100000","Common Stock-Beg Balance",-23806200,0,-23806200]
["%,V21100000","21100000","APIC Beg Balance",-8951788.6400000006,0,-8951788.6400000006]
["%,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",0,-12000000,-12000000]
["%,V22700000","22700000","Oblig Und Cap Leas B Bal",-273057.88,0,-273057.88]
["%,V22700002","22700002","Oblig Und Cap Leas NC Transfer",15791.329999999998,3188.2200000000003,18979.55]
["%,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",37271.149999999994,740.16,38011.31]
["%,V22820000","22820000","Accum Prov Prop Injur Damg",-12425.5,25,-12400.5]
["%,V22830010","22830010","Accum Prov-Banked Vacation",-422153.29,-68030.45,-490183.74]
["%,V22833000","22833000","Accum Provisions FAS 112",-271479.45,0,-271479.45]
["%,V22834010","22834010","Accum Provisions OPEB",-2509030.5,67777.34,-2441253.16]
["%,V22838000","22838000","Accum Provisions Pen Cost Qual",-2705.04,-332,-3037.04]
["%,V22838020","22838020","Accum Prov LT PenCost Non-Qual",-56858.79,-244.75,-57103.54]
["%,V22840030","22840030","NC Payroll Taxes Cares Act",-140962.43,-85507.08,-226469.51]
["%,V23200000","23200000","AP - AP Module Use Only",-2202607.39,-866168.08000000007,-3068775.47]
["%,V23200001","23200001","AP-Misc",-1100070.76,-299918.08000000002,-1399988.84]
["%,V23201058","23201058","AP-PNC Land Disbursement",14600.010000000002,24700,39300.01]
["%,V23201061","23201061","AP-MellonBank Disbursement_ACH",-894204.99,280310.45,-613894.54]
["%,V23202300","23202300","AP-Gas Purchases-Producer",-1841545.13,411078.5,-1430466.63]
["%,V23202400","23202400","AP-Gas Purchases-Transport",-1320053.23,-2736.08,-1322789.31]
["%,V23202500","23202500","AP-Choice Marketer Payable",-740250.39999999991,393386.48,-346863.92]
["%,V23202900","23202900","AP-CPG Non-Transition Srvces",-9633,-500,-10133]
["%,V23400000","23400000","AP Assoc Co-Mech",{"$f":"F138-E138","v":-2044802.5499999998},-814491.71,-2859294.26]
["%,V23400010","23400010","AP Assoc Co-Interest",-3598553.05,3001050.15,-597502.9]
["%,V23400030","23400030","AP Assoc Co-Transportation",-11585.98,-29.580000000000002,-11615.56]
["%,V23400111","23400111","AP Assoc Co-ERS_Only",-93049.48,62039,-31010.48]
["%,V23410000","23410000","Money Pool Borrowings",-14813048.079999998,6466790.5199999996,-8346257.5599999996]
["%,V23410001","23410001","Money Pool Borrowings Int Pay",-4181.8999999999996,1924.4,-2257.5]
["%,V23500000","23500000","Customer Deposits",-2288903.02,58322,-2230581.02]
["%,V23601000","23601000","Accrd Fed Inc Tax-Current",-2728311.84,321541,-2406770.84]
["%,V23602000","23602000","Accrd ST Inc Tax-Current Year",-622257.81000000006,106745,-515512.81]
["%,V23603200","23603200","Accrd Property Tax",-6166832.3899999997,-17363.830000000002,-6184196.2199999997]
["%,V23603300","23603300","Accrd Sales and Use Tax",-15446.36,8068.9000000000005,-7377.46]
["%,V23603400","23603400","Accrd Tax-FICA OASDI",0.03,0,0.03]
["%,V23603700","23603700","Accrued FICA Taxes",-17580.77,-7689.75,-25270.52]
["%,V23604000","23604000","Accrd Unempl Insur-Fed",-258.64999999999998,-20.350000000000001,-279]
["%,V23604100","23604100","Accrd Unempl Insur-State",-115.27999999999999,-89.51,-204.79]
["%,V23700010","23700010","Int Accrued-Cust Deposit",-16087.83,-2382.06,-18469.89]
["%,V24103130","24103130","Tax Coll Pay Loc Inc Tx",-2.0699999999999998,0,-2.0699999999999998]
["%,V24103140","24103140","Tax Coll Pay Tx WH OASDI",497.09000000000003,0,497.09000000000003]
["%,V24103300","24103300","Tax Coll Pay Sales and Use Tax",-53525.22,15346.24,-38178.980000000003]
["%,V24103400","24103400","Tax Coll Pay Util Gross Rcpts",-595955.43999999994,147392.95000000001,-448562.49]
["%,V24103600","24103600","Tax Coll Pay State-Local Oth",-172.53000000000003,-64.739999999999995,-237.27]
["%,V24201629","24201629","Accd Liab-Unclaimed AP Checks",-166189.48000000001,-85201.600000000006,-251391.08000000002]
["%,V24203000","24203000","Accd Liab-Profit Sharing",-80658.400000000009,80658.400000000009,0]
["%,V24203200","24203200","Accd Liab-Vacation Pay PY",-76152.5,-1144331.1100000001,-1220483.6100000001]
["%,V24203201","24203201","Accd Liab-Vacation Pay CY",-1883287.04,1267583.77,-615703.27]
["%,V24203305","24203305","Accd Liab-Gross Payroll",-229814.09999999998,-100519.52,-330333.62]
["%,V24204000","24204000","Accd Liab-PR Ded Misc",-4370.1900000000005,0,-4370.1900000000005]
["%,V24204050","24204050","Accd Liab-PR Ded Wage Attchmt",-1822.68,12,-1810.68]
["%,V24204060","24204060","Accd Liab-PR Ded United Way",-138.31,23.32,-114.99000000000001]
["%,V24204070","24204070","Accd Liab-PR Ded PAC",-997.55000000000007,0,-997.55000000000007]
["%,V24204080","24204080","Accd Liab-PR Ded ThrftPlan Pyt",-3542.78,394.69,-3148.09]
["%,V24204081","24204081","Accd Liab-PR Ded ThrftPlan EE",-41471.729999999996,1334.8500000000001,-40136.879999999997]
["%,V24204082","24204082","Accd Liab-PR Ded Roth401k Plan",-2668.79,0,-2668.79]
["%,V24204090","24204090","Accd Liab-PR Ded FSA Health",-162.09,-5.23,-167.32]
["%,V24204091","24204091","Accd Liab-PR Ded FSA Dep Care",-516.66999999999996,0.01,-516.66]
["%,V24204092","24204092","Accd Liab-PR Ded HSA Benefits",-26366.07,-101.52,-26467.59]
["%,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",-8775,-4750,-13525]
["%,V24206000","24206000","Accd Liability - Pension ST-NQ",-9100,0,-9100]
["%,V24207000","24207000","Accd Liab-Professional Srvcs",-81814.81,23791.670000000002,-58023.14]
["%,V24207020","24207020","Accd Liab-Benefits Admin Fees",-14963.16,-342.68,-15305.84]
["%,V24207500","24207500","Accd Liab-Insurance",-81035.48,300,-80735.48]
["%,V24208000","24208000","Accd Liab-Health Benefits",-164800.47,0,-164800.47]
["%,V24208010","24208010","Accd Liab-Rx Drug",-36644.46,0,-36644.46]
["%,V24208020","24208020","Accd Liab-Dental",-21091.119999999999,0,-21091.119999999999]
["%,V24211263","24211263","Accd Liab-ST FAS112",-88087.56,0,-88087.56]
["%,V24220300","24220300","Accd Liab-Rate Refunds",-18959,334.2,-18624.8]
["%,V24224000","24224000","Customer AR Credit Balances",-2290134.46,-1036639.63,-3326774.09]
["%,V24240050","24240050","Accd Liab-Shipper Gas",-1397737.3699999999,-764715.03,-2162452.4]
["%,V24250110","24250110","Accd Liab-Heatshare Cust Cntri",-1508,6,-1502]
["%,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",15205.480000000001,3069.94,18275.420000000002]
["%,V24300003","24300003","Oblig Cap Leases Curr-Transfer",-15791.329999999998,-3188.2200000000003,-18979.55]
["%,V24310000","24310000","Oblig Operating Lease Curr-BB",-400096.45,0,-400096.45]
["%,V24310001","24310001","Oblig Operating Lease Curr-Add",-148659.76,-30897.31,-179557.07]
["%,V24310002","24310002","Oblig Operating Lease Curr-Pay",297975.52,54929.04,352904.56]
["%,V24310003","24310003","Oblig Operating Lease Curr-Trn",-37271.129999999997,-740.16,-38011.29]
["%,V25200000","25200000","Custmr Advn for Constr NonCur",-2985669.5799999996,23184.07,-2962485.51]
["%,V25400450","25400450","Reg Liab Curr-Other",-59678.87,-10725.04,-70403.91]
["%,V25401000","25401000","Reg Liab Curr-Inc Tax Fed/St",-1106351,0,-1106351]
["%,V25401350","25401350","Reg Liab Curr-DSM Uncollect",90209.260000000009,-34230.19,55979.07]
["%,V25402400","25402400","Reg Liab Curr-Asset Reclass",-302011.08999999997,-21847.72,-323858.81]
["%,V25402900","25402900","Reg Lia Curr-AMRP",{"$f":"F202-E202","v":-925326.19000000006},6963.03,-918363.16]
["%,V25403150","25403150","Reg Liab Rate Reserve - Curren",-33244.75,-97.22,-33341.97]
["%,V25405000","25405000","Reg Liab NC-Inc Tax Fed-St",-37651331.18,85515,-37565816.18]
["%,V25405050","25405050","Reg Liab NC-Deferred ITC",-39374.6,1246,-38128.6]
["%,V25408300","25408300","Reg Liab NC-State Tax Reform",-16.310000000000002,1.58,-14.73]
["%,V25500000","25500000","Investment Tax Credit-ITC",-64346,2037,-62309]
["%,V28205000","28205000","Fed ADIT-Property",-53567215,-323921,-53891136]
["%,V28206000","28206000","St ADIT-Property",-10351588,-106812,-10458400]
["%,V28305000","28305000","Fed ADIT-Other NC",-1244971,128604,-1116367]
["%,V28306000","28306000","ST ADIT-NC Other",-312023,32230,-279793]
["%,V40300000","40300000","Dep Exp",5491746.1900000004,1114281.05,6606027.2400000002]
["%,V40430000","40430000","Amortization Exp-Other",191954.82,38314.74,230269.56]
["%,V40434000","40434000","Cloude Amortizaiton Expense",34017.06,6925.93,40942.99]
["%,V40500000","40500000","Amortization of Oth Plant",452133.82000000007,93139.49,545273.31000000006]
["%,V40813100","40813100","Tax Exp-License_Franchise",2000,0,2000]
["%,V40813200","40813200","Tax Exp-Property",2466360.8099999996,493272.16000000003,2959632.9699999997]
["%,V40813300","40813300","Tax Exp-Sales and Use Tax",-0.05,0.02,-0.03]
["%,V40814100","40814100","Tax Exp-Payroll-Incentive",-48193.66,0,-48193.66]
["%,V40814500","40814500","Tax Exp-Payroll FICA-OASDI",324726.93,48163.82,372890.75]
["%,V40814600","40814600","Tax Exp-Payroll FICA-Medicar",77240.78,11412.54,88653.32]
["%,V40814700","40814700","Tax Exp-FUTA Employer",5769.74,12.67,5782.41]
["%,V40814800","40814800","Tax Exp-SUTA Employer",4438.63,47.12,4485.75]
["%,V40911000","40911000","Util Cur Fed Exp",1484287,-334011,1150276]
["%,V40912000","40912000","Util Cur ST Exp",246398,-109870,136528]
["%,V40921000","40921000","Non Util Cur Fed Exp",60194,12470,72664]
["%,V40922000","40922000","Non Util Cur ST Exp",15086,3125,18211]
["%,V41011000","41011000","Util Def Fed Exp-Dr",3507385,486751,3994136]
["%,V41012000","41012000","Util Def ST Exp-Dr",895926,128844,1024770]
["%,V41111000","41111000","Util Def Fed Exp-Cr",-1939844,-394380,-2334224]
["%,V41112000","41112000","Util Def ST Exp-Cr",-343321,-72709,-416030]
["%,V41121000","41121000","Non Util Def Fed Exp-Cr",0,-37487,-37487]
["%,V41141000","41141000","Def Inc Tax-Fed-Cr-Util ITC",-10185,-2037,-12222]
["%,V41700000","41700000","Non Util Revenues",-184867.79,-5141.05,-190008.84]
["%,V41715000","41715000","Non Util Operating Exp",-3673.9300000000003,-795.13,-4469.0600000000004]
["%,V41810000","41810000","Affil Equity in Earngs of Subs",-28053.37,-1202.0899999999999,-29255.46]
["%,V41910000","41910000","Allow for Other FUDC",-41766.539999999994,-12515.45,-54281.99]
["%,V42101450","42101450","Gas Cost Recovery Initiatives",-156109.25,-59629.22,-215738.47]
["%,V42110000","42110000","Gain on Disposition of Asset",0.02,-0.04,-0.02]
["%,V42121000","42121000","Loss on Disposition of Asset",3.23,0,3.23]
["%,V42500000","42500000","Misc Amortization",-10792.95,-2158.59,-12951.54]
["%,V42610000","42610000","Other Inc_Exp-Donations",7342.64,1418.78,8761.42]
["%,V42630000","42630000","Penalties-Others",80021.919999999998,28000,108021.92]
["%,V42640000","42640000","Oth Inc_Exp Political Contrib",2672.61,0,2672.61]
["%,V42655000","42655000","Other Income Deductions",87025.02,16625.560000000001,103650.58]
["%,V43000000","43000000","Int on Debt to Assoc Co",3028888.25,597502.85,3626391.1]
["%,V43002000","43002000","Int on Debt to Assoc Co MonyPl",81959.7,2257.5,84217.2]
["%,V43100000","43100000","Other Interest Exp",-17918.060000000001,0,-17918.060000000001]
["%,V43105100","43105100","Oth Int Exp-Cust Deposits",16450.160000000003,3122.94,19573.100000000002]
["%,V43200000","43200000","Allow for Borrowd FUDC",-74585.549999999988,-22441.29,-97026.84]
["%,V48000000","48000000","Residential Sales",-44909602.850000001,-3472791.58,-48382394.43]
["%,V48000100","48000100","Residential Sales Norm",112551.67999999999,111.63,112663.31]
["%,V48101000","48101000","Commercial Gas Sales",-17683257.829999998,-1321143.17,-19004401]
["%,V48101200","48101200","Commercial Gas Sales Norm",54236.51,151.49,54388]
["%,V48102000","48102000","Industrial Gas Sales",-985140.25,-44137.11,-1029277.36]
["%,V48102300","48102300","Industrial Gas Sales Norm",2957.8900000000003,-208.32,2749.57]
["%,V48103000","48103000","Gas Sales-Other",-116.32000000000001,-18.920000000000002,-135.24]
["%,V48300000","48300000","Sales for Resale-Gas",-45143.840000000004,506.57,-44637.270000000004]
["%,V48700000","48700000","Forfeited Discounts-Gas",-171405.54,8.32,-171397.22]
["%,V48800000","48800000","Misc Service Revenues-Gas",-34564.400000000001,215,-34349.4]
["%,V48930000","48930000","Transp Rev Distr Residential",-4763786.6400000006,-462713.35000000003,-5226499.99]
["%,V48930200","48930200","Unbilled Residential Trans Vol",489123.30000000005,23422.799999999999,512546.10000000003]
["%,V48930300","48930300","Unbilled Res Trans Cust chrg",8320,1664,9984]
["%,V48931000","48931000","Transp Rev Distr Commercial",-4690357.4000000004,-527341.04,-5217698.4400000004]
["%,V48931300","48931300","Unbilled Comm Trans Vol",268917.33,42754.62,311671.95]
["%,V48931400","48931400","Unbilled Comm Trans Cust chrg",{"$f":"F266-E266","v":3441.13},580.97,4022.1]
["%,V48932000","48932000","Transp Rev Distr Industrial",-2248160.44,-325028.02,-2573188.46]
["%,V48932400","48932400","Unbilled Ind Trans Vol",2106.79,1692.8600000000001,3799.65]
["%,V49300000","49300000","Rent from Gas Property",-13955,-2791,-16746]
["%,V49500000","49500000","Other Gas Revenue",-126484.68000000001,-57820.800000000003,-184305.48]
["%,V49500050","49500050","Billed Off System Sales",-103367.25,-53436,-156803.25]
["%,V49500485","49500485","Unbilled Residential-Vol",3944097.89,382303.65,4326401.54]
["%,V49501485","49501485","Unbilled Res Customer Chrg",2236.6000000000004,13456,15692.6]
["%,V49510485","49510485","Unbilled Commercial-Vol",1508900.2200000002,248003.48,1756903.7000000002]
["%,V49511485","49511485","Unbilled Comm Customer Chrg",1206.6300000000001,3351.75,4558.38]
["%,V49520485","49520485","Unbilled Industrial-Vol",11607.48,5352.68,16960.16]
["%,V49521485","49521485","Unbilled Ind Customer Chrg",134.07,-44.69,89.38]
["%,V80100000","80100000","Natural gas field line purchas",95848.959999999992,19559.010000000002,115407.97]
["%,V80300300","80300300","Short Term Producer Purch",3189398.12,1322519.05,4511917.17]
["%,V80300400","80300400","Transportation Pipeline Exp",5043985.74,678093.5,5722079.2400000002]
["%,V80300500","80300500","Storage Charges Pipeline Exp",-1610823.04,-91395.97,-1702219.01]
["%,V80300600","80300600","OFS_System Supply Credit",-137859.53,-98506.760000000009,-236366.29]
["%,V80300808","80300808","Storage Demand",3214514.21,623301.64,3837815.85]
["%,V80400000","80400000","Natural Gas City Gate Purchase",753295.63,7358.04,760653.67]
["%,V80510000","80510000","Purchased Gas Cost Adjustments",3171338.5,1411287.07,4582625.57]
["%,V80601000","80601000","Exchange Gas-Received",-2177159.9699999997,658990.03,-1518169.94]
["%,V80720000","80720000","Oper-Purch Gas Measrg Stations",115550.52,24974.23,140524.75]
["%,V80751000","80751000","Purch Gas Exp - Mgmt Fee",26714.41,5500.86,32215.27]
["%,V80810000","80810000","Gas Withdrawn",13962787.130000001,-1535671.8,12427115.33]
["%,V80820000","80820000","Gas Delivered",-4208024.82,-2433611.94,-6641636.7599999998]
["%,V81220000","81220000","Gas Used-Other-Offset",-43964.99,-2751.7200000000003,-46716.71]
["%,V85200030","85200030","Communication System Exp",244.99,0.99,245.98000000000002]
["%,V87000000","87000000","Op Superv-Eng-Gas Distr",592781.66999999993,92585.06,685366.73]
["%,V87100000","87100000","Distribution Load Dispatching",29645.9,5652.57,35298.47]
["%,V87400000","87400000","Mains and Services Exp",3126524.27,512730.75,3639255.02]
["%,V87500000","87500000","Measur-Reg Statn Exp Gen",130202.43000000002,10799.4,141001.83000000002]
["%,V87600000","87600000","Measur-Reg Statn Exp-Indus",51720.81,3163.62,54884.43]
["%,V87800000","87800000","Meter and House Regulator Exp",520581.45,85221.55,605803]
["%,V87900000","87900000","Oper Installation Service Exp",1195951.57,210754.51,1406706.08]
["%,V88000000","88000000","Operations Exp Other",526083.57000000007,79949.570000000007,606033.14]
["%,V88100000","88100000","Gas Distr Rents",-1666.0499999999997,4182.25,2516.2000000000003]
["%,V88500000","88500000","Maint Supv-Eng-Gas Distr",34896.269999999997,5737.61,40633.879999999997]
["%,V88600000","88600000","Maint Struct-Improv-Gas Distr",34101.699999999997,5257.26,39358.959999999999]
["%,V88700000","88700000","Maint of Mains",899343.28,167825.80000000002,1067169.08]
["%,V88900000","88900000","Maint Msr-Reg Statn Equi Gen",202074.42,23177.8,225252.22]
["%,V89000000","89000000","Maint Meas_Reg Stn Equip-Distr",35746,6113.68,41859.68]
["%,V89200000","89200000","Maint of Services",265966.39,50164.14,316130.53000000003]
["%,V89300000","89300000","Maint Meters_House Regulators",48198.61,14276.970000000001,62475.58]
["%,V89400000","89400000","Other Maint Equipment",144386.02000000002,30932.61,175318.63]
["%,V90200000","90200000","Cust Accnt Meter Reading Exp",103483.72,26366.37,129850.09]
["%,V90300000","90300000","Cust Records Collection Exp",1131226.55,193119.32,1324345.8700000001]
["%,V90400000","90400000","Uncollectible Accounts",745900.47000000009,496286.12,1242186.5900000001]
["%,V90500000","90500000","Misc Cust Accts Exp",4592.3900000000003,751.30000000000007,5343.6900000000005]
["%,V90800000","90800000","Customer Assistance Exp",38039.53,11196.28,49235.81]
["%,V90900000","90900000","Inform_Instruct Advertisng Exp",9040.880000000001,4439.6099999999997,13480.49]
["%,V91000000","91000000","Misc Cust Serv and Info Exp",104819.76999999999,20928.350000000002,125748.12]
["%,V91100000","91100000","Sales Supervision",4382.0400000000009,481.52,4863.5600000000004]
["%,V91200000","91200000","Demonstrating and Selling Exp",2381.25,-239.85,2141.4]
["%,V91300000","91300000","Sales Advertising Exp",1513.6100000000001,0,1513.6100000000001]
["%,V92000000","92000000","A_G Salaries",2470310.0499999998,440842,2911152.05]
["%,V92001000","92001000","Discretionary and Spot Awards",5381.59,789.61,6171.2]
["%,V92002000","92002000","Stock Compensation Expense",351898.91000000003,-82823.28,269075.63]
["%,V92100000","92100000","Office Supplies and Exp",467174.12,180175.67,647349.79]
["%,V92101000","92101000","Employee Expenses",192263.44,10120.64,202384.08000000002]
["%,V92300000","92300000","Outside Service Employed",1901719.05,287464.34000000003,2189183.39]
["%,V92301000","92301000","Mgmt Fee Actuals-Affil",720516.87,168196.09,888712.96]
["%,V92400000","92400000","Property Insurance",7764.3200000000006,7047.37,14811.69]
["%,V92500000","92500000","Injuries and Damages",765176.38,138176.49,903352.87]
["%,V92600000","92600000","Employee Pensions and Benefits",1727838.0099999998,204949.39,1932787.4]
["%,V92601000","92601000","Non Service Pension & OPEB",{"$f":"F330-E330","v":-195460.64},-38688.5,-234149.14]
["%,V92800000","92800000","Regulatory Commission Exp",115004.1,23000.82,138004.92000000001]
["%,V93010000","93010000","General Advertising Exp",226.54999999999927,4286.9400000000005,4513.49]
["%,V93020000","93020000","Misc General Exp",24973.200000000001,3925.75,28898.95]
["%,V93100000","93100000","Rents Admin and General",349880.22000000003,62445.130000000005,412325.35000000003]
["%,V93200000","93200000","Maint General Plant",346154.27,47454.1,393608.37]
["%,V99000001","99000001","Gross Payroll Hyperion",2831933.5,864422.68,3696356.18]
["%,V99000004","99000004","Management Fee Hyperion",189.09000000000003,140,329.09000000000003]
["%,V99900001","99900001","Gross Pay Offset Hyperion",-2831933.5,-864422.68,-3696356.18]
["%,V99900002","99900002","Mgmt Fee Offset Hyperion",-189.09000000000003,-140,-329.09000000000003]
["%,FACCOUNT,X,_",null,"Total:",{"$f":"F340-E340","v":1.9740775769605534E-7},3.4924596548080444E-10,1.9775700366153615E-7]