{"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":208,"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":136,"n_cols":5,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
[null,null,"Dec 31, 19"]
[null,null,"Debit",null,"Credit"]
[null,"9604685 · Emergency Savings Revenue",50.02]
[null,"MCWD Region Account",103.47]
[null,"Regent Bank - KRWFA Sinking Fun",76618.64]
[null,"AML Water Line Ext. 9549641",297.24]
[null,"Water Revenue Savings 9490531",20568.400000000001]
[null,"Phase 14 Savings - 9487581",583.47]
[null,"Dep-Refund Acct. Check 5134552",2519.11]
[null,"Deposit Savings 5134552",21435.19]
[null,"O & M Checking 3020703",null,null,20790.830000000002]
[null,"Payroll Checking 3030938",49.6]
[null,"Funded DepreciatReserve Savings",500.92]
[null,"Revenue  Fund 65212",97020.13]
[null,"Cash Drawer",914.32]
[null,"Waterlines - MCWD System Improv",729990.84]
[null,"Water Lines Phase 14",1623703.85]
[null,"Capital Lease - Office Space an",423364.21]
[null,"Capital Lease - Office Space an:Accumulated Amortization",null,null,34211.279999999999]
[null,"Phase 12 A Water Lines",1317000]
[null,"Phase 12 Water Lines",2632374.2400000002]
[null,"Water Line Phase 11",4073607.64]
[null,"Water Line Phase 10",4228030.45]
[null,"A/D - Equipment",null,null,148492.24]
[null,"A/D - Office Equipment",null,null,1099.23]
[null,"A/D - Vehicles",null,null,246200.18]
[null,"A/D - Water Lines",null,null,6179277.9900000002]
[null,"Land",71076]
[null,"Water Lines",3496491]
[null,"Water Lines - Ezel Expansion Pr",993077.97]
[null,"Water Lines - Hwy 172 Project",1709559.46]
[null,"Water Lines - White Oak Expansi",1722021.2]
[null,"Vehicles",178087.7]
[null,"Equipment",334660]
[null,"Office Equipment:Computer",1099.23]
[null,"Deferred Outflows OPEB",44309.71]
[null,"Deferred Outflows",90415.27]
[null,"Allowance for Doubtful Accounts",null,null,13595.03]
[null,"Accounts Receivable Water Colle",109429.57]
[null,"Prepaid Expenses",7412.3]
[null,"UnBilled Receivables",59672.4]
[null,"Accounts Payable",null,null,122836.76]
[null,"Accounts Payable:Sales Tax Payable",null,null,420.13]
[null,"Accounts Payable:2010 · Paychecks Payable",null,null,8627.14]
[null,"Accounts Payable:2005 · Retirement Buyback Payable",null,null,5219.6400000000003]
[null,"O & M Refundable Security Depos",null,null,21049.279999999999]
[null,"S/T Leasing Obligation",null,null,27985.49]
[null,"Water Purchases Accounts Payabl",null,null,42010]
[null,"Accrued Compensated Absences",null,null,8244.5499999999993]
[null,"Accrued Interest",null,null,75296.25]
[null,"Payroll Tax Liability",null,null,6712.26]
[null,"Loan Payable Bank of the Mounta",null,null,30000]
[null,"Leasing Obligation:Leased - Ford F350 VIN #1178",null,null,14759.64]
[null,"Leasing Obligation:Leased - Ford F250 VIN #1176",null,null,10608.06]
[null,"Leasing Obligation:Leased - Ford F150 VIN #6461",null,null,19602.02]
[null,"Leasing Obligation:Leased - Ford F150 VIN #0366",null,null,13135.36]
[null,"Deferred Inflows:Deferred Inflows - Pension",null,null,33050]
[null,"Deferred Inflows:Deferred Inflows OPEB",null,null,47335]
[null,"Deferred Inflows:Refunding Bond Premium",null,null,43765.1]
[null,"Net OPEB Liability",null,null,116290]
[null,"Net Pension Liability",null,null,485843]
[null,"Bonds Payable",null,null,1271890]
[null,"Bonds Payable:KRWFA Refunding Bond Series 201",null,null,1250000]
[null,"Bonds Payable:Bonds Payable - 91-25",null,null,829000]
[null,"Bonds Payable:Bonds Payable  91-11",null,null,231000]
[null,"Contributed Capital",null,null,5674422.3499999996]
[null,"contributions In Aid of Constru",null,null,10880928.51]
[null,"Retained Earnings - Restricted",null,null,125614]
[null,"Retained Earnings - Unrestricte",null,null,40261.800000000003]
[null,"3000 · Opening Bal Equity",null,null,87282.36]
[null,"3900 · Retained Earnings",3588563.08]
[null,"Misc. Service Revenues-Other",null,null,23850.17]
[null,"Meter Sales to Commercial Custo",null,null,116448.45]
[null,"Meter Sales to Residential Cust",null,null,1307226.23]
[null,"Forfeited Discounts",null,null,26325.58]
[null,"Budget Items:General Revenue:Bulk Sales",null,null,309]
[null,"Budget Items:General Revenue:Reimbursement Revenue",8165]
[null,"Budget Items:General Revenue:Tap-on-Fee:Tap-on-Fee - Other",null,null,39715]
[null,"Non-Budget Items:Interest Income",null,null,75.010000000000005]
[null,"Non-Budget Items:US 460 Relocation Project",null,null,1403]
[null,"4999 · Uncategorized Income",null,null,3578.05]
[null,"Leasing Maintenance and Fees",4639.9399999999996]
[null,"408.1 UtilityRegAssessmentFee",3010.08]
[null,"Capital Lease Amortization",4276.41]
[null,"Contractual Services Other",8236]
[null,"Insurance - General Liability",16981.25]
[null,"Tranportation Expense:Auto Repair & Maint.",1730.51]
[null,"Contractual Services",null,null,1540]
[null,"Contractual Services:Constractual Services - Water T",7375]
[null,"Contractual Services:Contractual Services - Legal",8775]
[null,"Contractual Services:Contractual Services Acct.",6525]
[null,"Materials and Supplies - Other",57442.84]
[null,"Depreciation",508422.18]
[null,"Administrative Fees",25.19]
[null,"5040 · Uniforms",363.14]
[null,"Advertising",1285.8800000000001]
[null,"Auto:Repair & Maint. Auto",330]
[null,"Auto:Parts",102.15]
[null,"Fuel",16600.740000000002]
[null,"Health Ins",49304.13]
[null,"Local Taxes",38636.019999999997]
[null,"Office Supplies",5275.1]
[null,"Payroll Expense:Employee Pensions & Benefit-Oth",91.91]
[null,"Payroll Expense:CERS",84573]
[null,"Payroll Expense:941 Federal Payroll Tax",14433.04]
[null,"Payroll Expense:Employee Check",189310.42]
[null,"Interest Expense",142931.53]
[null,"Bank Charge",599.41]
[null,"Insurance - Bond:Encroachment Bond",534.45000000000005]
[null,"License/Certification Fees",571.61]
[null,"Membership Dues",2219.1999999999998]
[null,"Misc:Clothing Allowances",105.99]
[null,"Outside Services",1750]
[null,"Outside Services:Pump Repair & Service",1310.44]
[null,"Postage",13223.66]
[null,"Supplies Other",1481.8]
[null,"Supplies & Testing:Supplies & Testing - Other",1006.24]
[null,"Travel Expense",134]
[null,"Travel Expense:Travel Expense - Other",630.04]
[null,"Travel Expense:Misc Travel",265.39999999999998]
[null,"UC Tax:KACO UI Fund",255.5]
[null,"6999 · Uncategorized Expenses",1500]
[null,"Utilities:Utilities - Other",1434.69]
[null,"Utilities:American Power",16153.1]
[null,"Utilities:Cellular",2116.85]
[null,"Utilities:RECC",19028.5]
[null,"Utilities:Telephone",6032.94]
[null,"Water Purchases:Cave Run Water Commission",293997.43]
[null,"Water Purchases:West Liberty Waterworks",476595.1]
[null,"Water Class Fee",400]
[null,"Workers' Comp",2694]
[null,"Non -Budget Items",500]
[null,"Non -Budget Items:Sales & Use Tax",3834.53]
[null,"AML Grant Funds",null,null,6575]
[null,"OPEB Expense",12078]
["TOTAL",null,{"$f":"ROUND(SUM(C3:C135),5)","v":29693900.969999999},null,{"$f":"ROUND(SUM(E3:E135),5)","v":29693900.969999999}]