{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["QuickBooks Desktop Export Tips","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":310,"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":"QuickBooks Desktop Export Tips","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":1,"n_rows":227,"n_cols":13,"rows_kept":227,"cut":false,"hidden":false,"merged":[]}
[null,null,"Unadjusted Balance",null,null,null,"Adjustments",null,null,null,"Adjusted Balance"]
[null,null,"Debit",null,"Credit",null,"Debit",null,"Credit",null,"Debit",null,"Credit"]
[null,"9604685 · Emergency Savings Revenue",50.02,null,null,null,null,null,null,null,50.02]
[null,"MCWD Region Account",103.47,null,null,null,null,null,null,null,103.47]
[null,"Regent Bank - KRWFA Sinking Fun",71592.88,null,null,null,5025.76,null,null,null,76618.64]
[null,"AML Water Line Ext. 9549641",297.24,null,null,null,null,null,null,null,297.24]
[null,"Storm Damage Account 9520651",0,null,null,null,null,null,null,null,0]
[null,"Water Revenue Savings 9490531",20568.400000000001,null,null,null,null,null,null,null,20568.400000000001]
[null,"Phase 14 Savings - 9487581",583.47,null,null,null,null,null,null,null,583.47]
[null,"Phase 12A Savings 7531907",0,null,null,null,null,null,null,null,0]
[null,"Phase 12A Coal Dev Grant WX211",0,null,null,null,null,null,null,null,0]
[null,"Phase 12 Water Line Ext 2008",0,null,null,null,null,null,null,null,0]
[null,"Phase 12 - Savings 007522037",0,null,null,null,null,null,null,null,0]
[null,"Phase 11 RD Constr.  3032043",0,null,null,null,null,null,null,null,0]
[null,"KIA Coal Grant Acct  3032094",0,null,null,null,null,null,null,null,0]
[null,"Phase 11A - Savings  7517297",0,null,null,null,null,null,null,null,0]
[null,"Phase 11B - Savings  7515367",0,null,null,null,null,null,null,null,0]
[null,"Dep-Refund Acct. Check 5134552",2519.11,null,null,null,null,null,null,null,2519.11]
[null,"Phase 11 7493487",0,null,null,null,null,null,null,null,0]
[null,"Coal Severance Line",0,null,null,null,null,null,null,null,0]
[null,"ADD ON Part B 7492367",0,null,null,null,null,null,null,null,0]
[null,"1000 · Coal Development Fund 3031780",0,null,null,null,null,null,null,null,0]
[null,"RD Construction Ditney Phase 10",0,null,null,null,null,null,null,null,0]
[null,"Phase 10 Project Ditney Ridge",0,null,null,null,null,null,null,null,0]
[null,"191 Relocation Project",0,null,null,null,null,null,null,null,0]
[null,"White Oak Water Line Ex 3031616",0,null,null,null,null,null,null,null,0]
[null,"Phase 10 Project 7469667",0,null,null,null,null,null,null,null,0]
[null,"Deposit Savings 5134552",21435.19,null,null,null,null,null,null,null,21435.19]
[null,"Ezel Checking",0,null,null,null,null,null,null,null,0]
[null,"Ezel Savings",0,null,null,null,null,null,null,null,0]
[null,"Greasy Bridge Checking",0,null,null,null,null,null,null,null,0]
[null,"Hwy 172 Checking",0,null,null,null,null,null,null,null,0]
[null,"Hwy 172 Savings",0,null,null,null,null,null,null,null,0]
[null,"Hwy 203 Checking",0,null,null,null,null,null,null,null,0]
[null,"O & M Checking 3020703",null,null,20790.830000000002,null,null,null,null,null,null,null,20790.830000000002]
[null,"Payroll Checking 3030938",49.6,null,null,null,null,null,null,null,49.6]
[null,"Funded DepreciatReserve Savings",500.92,null,null,null,null,null,null,null,500.92]
[null,"Revenue  Fund 65212",97020.13,null,null,null,null,null,null,null,97020.13]
[null,"US 460 Relocation",0,null,null,null,null,null,null,null,0]
[null,"White Oak Savings 85290",0,null,null,null,null,null,null,null,0]
[null,"A/R - KIA Grant",0,null,null,null,null,null,null,null,0]
[null,"A/R - A/R",0,null,null,null,null,null,null,null,0]
[null,"Cash Drawer",914.32,null,null,null,null,null,null,null,914.32]
[null,"Construction In Progress",0,null,null,null,null,null,null,null,0]
[null,"Construction In Progress:Phase 12 Construction Account",0,null,null,null,null,null,null,null,0]
[null,"Construction In Progress:CIP Phase 11 RD",0,null,null,null,null,null,null,null,0]
[null,"Construction In Progress:Phase 11",0,null,null,null,null,null,null,null,0]
[null,"Construction In Progress:CIP-Water Line Project",0,null,null,null,null,null,null,null,0]
[null,"Construction In Progress:Construction In Progress-Coal D",0,null,null,null,null,null,null,null,0]
[null,"Construction In Progress:CIP-RD Constr/Ditney Phase 10",0,null,null,null,null,null,null,null,0]
[null,"Construction In Progress:White Oak Project",0,null,null,null,null,null,null,null,0]
[null,"Construction In Progress:Phase 10 Project Ditney Ridge",0,null,null,null,null,null,null,null,0]
[null,"Construction In Progress:191 Relocation",0,null,null,null,null,null,null,null,0]
[null,"Waterlines - MCWD System Improv",729990.84,null,null,null,null,null,null,null,729990.84]
[null,"Water Lines Phase 14",1623703.85,null,null,null,null,null,null,null,1623703.85]
[null,"CIP - Phase 14 Waterline Projec",0,null,null,null,null,null,null,null,0]
[null,"Capital Lease - Office Space an",423364.21,null,null,null,null,null,null,null,423364.21]
[null,"Capital Lease - Office Space an:Accumulated Amortization",null,null,29934.87,null,null,null,4276.41,null,null,null,34211.279999999999]
[null,"Phase 12 A Water Lines",1317000,null,null,null,null,null,null,null,1317000]
[null,"Phase 12 Water Lines",2632374.2400000002,null,null,null,null,null,null,null,2632374.2400000002]
[null,"Water Line Phase 11",4073607.64,null,null,null,null,null,null,null,4073607.64]
[null,"Water Line Phase 10",4228030.45,null,null,null,null,null,null,null,4228030.45]
[null,"A/D - Building",0,null,null,null,null,null,null,null,0]
[null,"A/D - Equipment",null,null,116154.74,null,null,null,32337.5,null,null,null,148492.24]
[null,"A/D - Office Equipment",null,null,1099.23,null,null,null,null,null,null,null,1099.23]
[null,"A/D - Vehicles",null,null,220212.62,null,null,null,25987.56,null,null,null,246200.18]
[null,"A/D - Water Lines",null,null,5729180.8700000001,null,null,null,450097.12,null,null,null,6179277.9900000002]
[null,"Land",71076,null,null,null,null,null,null,null,71076]
[null,"Water Lines",3496491,null,null,null,null,null,null,null,3496491]
[null,"Water Lines - Ezel Expansion Pr",993077.97,null,null,null,null,null,null,null,993077.97]
[null,"Water Lines - Hwy 172 Project",1709559.46,null,null,null,null,null,null,null,1709559.46]
[null,"Water Lines - White Oak Expansi",1722021.2,null,null,null,null,null,null,null,1722021.2]
[null,"Office Building",0,null,null,null,null,null,null,null,0]
[null,"Office Furniture",0,null,null,null,null,null,null,null,0]
[null,"Vehicles",178087.7,null,null,null,null,null,null,null,178087.7]
[null,"CIP:CIP - MCWD System Improv D/C",0,null,null,null,null,null,null,null,0]
[null,"CIP:Phase 12 A Coal Dev. Grant WX21",0,null,null,null,null,null,null,null,0]
[null,"Equipment",334660,null,null,null,null,null,null,null,334660]
[null,"Office Equipment",0,null,null,null,null,null,null,null,0]
[null,"Office Equipment:Computer",1099.23,null,null,null,null,null,null,null,1099.23]
[null,"Deferred Outflows OPEB",36349.78,null,null,null,7959.93,null,null,null,44309.71]
[null,"Deferred Outflows",108825.92,null,null,null,null,null,18410.650000000001,null,90415.27]
[null,"Allowance for Doubtful Accounts",null,null,13595.03,null,null,null,null,null,null,null,13595.03]
[null,"Accounts Receivable Water Colle",109429.57,null,null,null,null,null,null,null,109429.57]
[null,"Prepaid Expenses",7412.3,null,null,null,null,null,null,null,7412.3]
[null,"UnBilled Receivables",59672.4,null,null,null,null,null,null,null,59672.4]
[null,"Accounts Payable - Construction",0,null,null,null,null,null,null,null,0]
[null,"CERS/KY Retirement Payable",0,null,null,null,null,null,null,null,0]
[null,"Accounts Payable",null,null,117828.57,null,null,null,5008.1899999999996,null,null,null,122836.76]
[null,"Accounts Payable:191 Relocation Project",0,null,null,null,null,null,null,null,0]
[null,"Accounts Payable:Payroll Taxes Payable:Fed & FICA Payable",0,null,null,null,null,null,null,null,0]
[null,"Accounts Payable:Payroll Taxes Payable:State Withholding Payable",0,null,null,null,null,null,null,null,0]
[null,"Accounts Payable:Sales Tax Payable",null,null,133.4,null,null,null,286.73,null,null,null,420.13]
[null,"Accounts Payable:2010 · Paychecks Payable",null,null,3000.13,null,null,null,5627.01,null,null,null,8627.14]
[null,"Accounts Payable:2005 · Retirement Buyback Payable",null,null,3197.28,null,null,null,2022.36,null,null,null,5219.6400000000003]
[null,"O & M Refundable Security Depos",null,null,30773.08,null,9723.7999999999993,null,null,null,null,null,21049.279999999999]
[null,"S/T Leasing Obligation",null,null,27985.49,null,null,null,null,null,null,null,27985.49]
[null,"Water Purchases Accounts Payabl",null,null,35508.18,null,null,null,6501.82,null,null,null,42010]
[null,"Accrued Compensated Absences",null,null,10953.45,null,2708.9,null,null,null,null,null,8244.5499999999993]
[null,"MCWD Water Revenue Payable",8389.9,null,null,null,null,null,8389.9,null,0]
[null,"CERS/ Retirement Payable",0,null,null,null,null,null,null,null,0]
[null,"County Payroll Taxes",0,null,null,null,null,null,null,null,0]
[null,"City Taxes Payable",0,null,null,null,null,null,null,null,0]
[null,"Retirement Buyback Payable",0,null,null,null,null,null,null,null,0]
[null,"Paychecks Payable",0,null,null,null,null,null,null,null,0]
[null,"Revenue Sinking Fund",0,null,null,null,null,null,null,null,0]
[null,"Reserve Depreciation Fund",0,null,null,null,null,null,null,null,0]
[null,"Quarterly Return of License Fee",0,null,null,null,null,null,null,null,0]
[null,"A/P Construction",0,null,null,null,null,null,null,null,0]
[null,"Accrued Interest",null,null,75296.25,null,null,null,null,null,null,null,75296.25]
[null,"N/P - KRWA",0,null,null,null,null,null,null,null,0]
[null,"BOTM Truck  Loann",0,null,null,null,null,null,null,null,0]
[null,"Accrued Expenses",0,null,null,null,null,null,null,null,0]
[null,"N/P - KRWFC",0,null,null,null,null,null,null,null,0]
[null,"N/P - S/T - Fifth Third Bank",0,null,null,null,null,null,null,null,0]
[null,"Payroll Tax Liability",null,null,8987.19,null,2274.9299999999998,null,null,null,null,null,6712.26]
[null,"MCWD Revenue Payable",0,null,null,null,null,null,null,null,0]
[null,"MCWD Reserve Payable",0,null,null,null,null,null,null,null,0]
[null,"Loan Payable Bank of the Mounta",null,null,30000,null,null,null,null,null,null,null,30000]
[null,"Leasing Obligation:Leased - Ford F350 VIN #1178",null,null,22509.96,null,7750.32,null,null,null,null,null,14759.64]
[null,"Leasing Obligation:Leased - Ford F250 VIN #1176",null,null,16142.7,null,5534.64,null,null,null,null,null,10608.06]
[null,"Leasing Obligation:Leased - Ford F150 VIN #6461",null,null,26520.38,null,6918.36,null,null,null,null,null,19602.02]
[null,"Leasing Obligation:Leased - Ford F150 VIN #0366",null,null,18764.8,null,5629.44,null,null,null,null,null,13135.36]
[null,"Deferred Inflows:Deferred Inflows - Pension",null,null,34203,null,1153,null,null,null,null,null,33050]
[null,"Deferred Inflows:Deferred Inflows OPEB",null,null,24542,null,null,null,22793,null,null,null,47335]
[null,"Deferred Inflows:Refunding Bond Premium",null,null,45849.15,null,2084.0500000000002,null,null,null,null,null,43765.1]
[null,"Net OPEB Liability",null,null,129361,null,13071,null,null,null,null,null,116290]
[null,"Net Pension Liability",null,null,443801,null,null,null,42042,null,null,null,485843]
[null,"Bonds Payable-Series 91-14",0,null,null,null,null,null,null,null,0]
[null,"Due to Morgan Co. Fiscal Court",0,null,null,null,null,null,null,null,0]
[null,"N/P - L/T Fifth Third Bank",0,null,null,null,null,null,null,null,0]
[null,"Note Payable-RD",0,null,null,null,null,null,null,null,0]
[null,"Bonds Payable",null,null,1218958.01,null,null,null,52931.99,null,null,null,1271890]
[null,"Bonds Payable:KRWFA Refunding Bond Series 201",null,null,1295000,null,45000,null,null,null,null,null,1250000]
[null,"Bonds Payable:Bonds Payable - 91-14",0,null,null,null,null,null,null,null,0]
[null,"Bonds Payable:Bonds Payable - Series 91-14",0,null,null,null,null,null,null,null,0]
[null,"Bonds Payable:Bonds Payable - 91-25",null,null,794432.5,null,null,null,34567.5,null,null,null,829000]
[null,"Bonds Payable:Bonds Payable - RD",0,null,null,null,null,null,null,null,0]
[null,"Bonds Payable:Bonds Payable 91-20",0,null,null,null,null,null,null,null,0]
[null,"Bonds Payable:Bonds Payable  91-09",0,null,null,null,null,null,null,null,0]
[null,"Bonds Payable:Bonds Payable  91-11",null,null,223370.63,null,null,null,7629.37,null,null,null,231000]
[null,"Bonds Payable:Bonds Payable  91-04",0,null,null,null,null,null,null,null,0]
[null,"Bonds Payable:Bonds Payable 91-06",0,null,null,null,null,null,null,null,0]
[null,"Bonds Payable:Bonds Payable  91-01",0,null,null,null,null,null,null,null,0]
[null,"RD LOAN#91-14",0,null,null,null,null,null,null,null,0]
[null,"RD LOAN#91-11",0,null,null,null,null,null,null,null,0]
[null,"RD LOAN #91-09",0,null,null,null,null,null,null,null,0]
[null,"RD LOAN#91-06",0,null,null,null,null,null,null,null,0]
[null,"RD Loan #91-01",0,null,null,null,null,null,null,null,0]
[null,"RD Loan #91-04",0,null,null,null,null,null,null,null,0]
[null,"Contributed Capital",null,null,5674422.3499999996,null,null,null,null,null,null,null,5674422.3499999996]
[null,"contributions In Aid of Constru",null,null,10880928.51,null,null,null,null,null,null,null,10880928.51]
[null,"Retained Earnings - Restricted",null,null,125614,null,null,null,null,null,null,null,125614]
[null,"Retained Earnings - Unrestricte",null,null,40261.800000000003,null,null,null,null,null,null,null,40261.800000000003]
[null,"3000 · Opening Bal Equity",null,null,87282.36,null,null,null,null,null,null,null,87282.36]
[null,"3900 · Retained Earnings",3588563.08,null,null,null,null,null,null,null,3588563.08]
[null,"Misc. Service Revenues-Other",null,null,23850.17,null,null,null,null,null,null,null,23850.17]
[null,"Meter Sales to Commercial Custo",null,null,116448.45,null,null,null,null,null,null,null,116448.45]
[null,"Meter Sales to Residential Cust",null,null,1306179.06,null,null,null,1047.17,null,null,null,1307226.23]
[null,"Forfeited Discounts",null,null,26325.58,null,null,null,null,null,null,null,26325.58]
[null,"Budget Items:General Revenue:Bulk Sales",null,null,309,null,null,null,null,null,null,null,309]
[null,"Budget Items:General Revenue:Reimbursement Revenue",8165,null,null,null,null,null,null,null,8165]
[null,"Budget Items:General Revenue:Tap-on-Fee:Tap-on-Fee - Other",null,null,39715,null,null,null,null,null,null,null,39715]
[null,"Non-Budget Items:Interest Income",null,null,75.010000000000005,null,null,null,null,null,null,null,75.010000000000005]
[null,"Non-Budget Items:US 460 Relocation Project",null,null,1403,null,null,null,null,null,null,null,1403]
[null,"4999 · Uncategorized Income",null,null,11430.05,null,7852,null,null,null,null,null,3578.05]
[null,"Leasing Maintenance and Fees",null,null,null,null,4639.9399999999996,null,null,null,4639.9399999999996]
[null,"Bonds Payable KRWA 2016",99912.48,null,null,null,null,null,99912.48,null,0]
[null,"Mountain Parkway Utility Reloc",1403,null,null,null,null,null,1403,null,0]
[null,"408.1 UtilityRegAssessmentFee",3010.08,null,null,null,null,null,null,null,3010.08]
[null,"Capital Lease Amortization",null,null,null,null,4276.41,null,null,null,4276.41]
[null,"Contractual Services Other",8236,null,null,null,null,null,null,null,8236]
[null,"Insurance - General Liability",16981.25,null,null,null,null,null,null,null,16981.25]
[null,"Tranportation Expense",28394.97,null,null,null,null,null,28394.97,null,0]
[null,"Tranportation Expense:Auto Repair & Maint.",1730.51,null,null,null,null,null,null,null,1730.51]
[null,"Contractual Services",null,null,null,null,null,null,1540,null,null,null,1540]
[null,"Contractual Services:Constractual Services - Water T",7230,null,null,null,145,null,null,null,7375]
[null,"Contractual Services:Contractual Services - Legal",null,null,null,null,8775,null,null,null,8775]
[null,"Contractual Services:Contractual Services Acct.",6525,null,null,null,null,null,null,null,6525]
[null,"Materials and Supplies - Other",57544.99,null,null,null,null,null,102.15,null,57442.84]
[null,"Quarterly Ret. of Lic. Fee Expe",2591.1,null,null,null,null,null,2591.1,null,0]
[null,"Depreciation",null,null,null,null,508422.18,null,null,null,508422.18]
[null,"Administrative Fees",25.19,null,null,null,null,null,null,null,25.19]
[null,"5040 · Uniforms",null,null,null,null,363.14,null,null,null,363.14]
[null,"Advertising",1285.8800000000001,null,null,null,null,null,null,null,1285.8800000000001]
[null,"Auto:Repair & Maint. Auto",null,null,null,null,330,null,null,null,330]
[null,"Auto:Parts",102.15,null,null,null,null,null,null,null,102.15]
[null,"Fuel",17244.080000000002,null,null,null,null,null,643.34,null,16600.740000000002]
[null,"Health Ins",49304.13,null,null,null,null,null,null,null,49304.13]
[null,"Local Taxes",41701.22,null,null,null,null,null,3065.2,null,38636.019999999997]
[null,"Office Supplies",5423.98,null,null,null,null,null,148.88,null,5275.1]
[null,"Payroll Expense:Employee Pensions & Benefit-Oth",2235.87,null,null,null,null,null,2143.96,null,91.91]
[null,"Payroll Expense:Ky State Tax Withholding",10731.37,null,null,null,null,null,10731.37,null,0]
[null,"Payroll Expense:CERS",49122.09,null,null,null,35450.910000000003,null,null,null,84573]
[null,"Payroll Expense:941 Federal Payroll Tax",37625.51,null,null,null,null,null,23192.47,null,14433.04]
[null,"Payroll Expense:Employee Check",134361.26,null,null,null,54949.16,null,null,null,189310.42]
[null,"Interest Expense",null,null,null,null,142931.53,null,null,null,142931.53]
[null,"Bank Charge",599.41,null,null,null,null,null,null,null,599.41]
[null,"Insurance - Bond:Encroachment Bond",534.45000000000005,null,null,null,null,null,null,null,534.45000000000005]
[null,"License/Certification Fees",584.61,null,null,null,null,null,13,null,571.61]
[null,"Membership Dues",2219.1999999999998,null,null,null,null,null,null,null,2219.1999999999998]
[null,"Misc:Clothing Allowances",105.99,null,null,null,null,null,null,null,105.99]
[null,"Outside Services",1750,null,null,null,null,null,null,null,1750]
[null,"Outside Services:Pump Repair & Service",427.89,null,null,null,882.55,null,null,null,1310.44]
[null,"Postage",13223.66,null,null,null,null,null,null,null,13223.66]
[null,"Repair & Maint",61.17,null,null,null,null,null,61.17,null,0]
[null,"Supplies Other",1348.21,null,null,null,133.59,null,null,null,1481.8]
[null,"Supplies & Testing:Supplies & Testing - Other",1006.24,null,null,null,null,null,null,null,1006.24]
[null,"Travel Expense",null,null,null,null,134,null,null,null,134]
[null,"Travel Expense:Travel Expense - Other",630.04,null,null,null,null,null,null,null,630.04]
[null,"Travel Expense:Misc Travel",265.39999999999998,null,null,null,null,null,null,null,265.39999999999998]
[null,"UC Tax:KACO UI Fund",255.5,null,null,null,null,null,null,null,255.5]
[null,"6999 · Uncategorized Expenses",1500,null,null,null,null,null,null,null,1500]
[null,"Utilities:Utilities - Other",1434.69,null,null,null,null,null,null,null,1434.69]
[null,"Utilities:American Power",15866.1,null,null,null,287,null,null,null,16153.1]
[null,"Utilities:Cellular",2278.7600000000002,null,null,null,null,null,161.91,null,2116.85]
[null,"Utilities:RECC",17662.25,null,null,null,1366.25,null,null,null,19028.5]
[null,"Utilities:Telephone",5616.88,null,null,null,416.06,null,null,null,6032.94]
[null,"Water Purchases:Cave Run Water Commission",297267.12,null,null,null,null,null,3269.69,null,293997.43]
[null,"Water Purchases:West Liberty Waterworks",475733.98,null,null,null,861.12,null,null,null,476595.1]
[null,"Water Class Fee",400,null,null,null,null,null,null,null,400]
[null,"Workers' Comp",4491,null,null,null,null,null,1797,null,2694]
[null,"Non -Budget Items",500,null,null,null,null,null,null,null,500]
[null,"Non -Budget Items:Sales & Use Tax",3834.53,null,null,null,null,null,null,null,3834.53]
[null,"AML Grant Funds",null,null,6575,null,null,null,null,null,null,null,6575]
[null,"OPEB Expense",null,null,null,null,12078,null,null,null,12078]
["TOTAL",null,{"$f":"ROUND(SUM(C3:C226),5)","v":29108905.68},null,{"$f":"ROUND(SUM(E3:E226),5)","v":29108905.68},null,{"$f":"ROUND(SUM(G3:G226),5)","v":899127.97},null,{"$f":"ROUND(SUM(I3:I226),5)","v":899127.97},null,{"$f":"ROUND(SUM(K3:K226),5)","v":29693900.969999999},null,{"$f":"ROUND(SUM(M3:M226),5)","v":29693900.969999999}]