{"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":177,"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":107,"n_cols":5,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[null,null,"Dec 31, 23"]
[null,null,"Debit",null,"Credit"]
[null,"99999 -",null,null,500.98]
[null,"131-100 · Operation & Main Town Square",482440.38]
[null,"131-110 · Water Revenue  - Town Square",735039.24]
[null,"131-120 · Bond & Interest - Town Square",220467.09]
[null,"131-130 · New Customer Deposits",68285.7]
[null,"131-160 · Surcharge PSC Account",638358.5]
[null,"131-190 · Rural Development",0]
[null,"131-700 · Regions Bank Trust Remittance",98561.33]
[null,"131-900 · Petty Cash",1000]
[null,"135-100 · Bond & Interest - CD # 1459",68381.22]
[null,"135-200 · Line Replacement & Extension -",78901.37]
[null,"135-300 · Depreciation Fund - CD # 2139",92663.32]
[null,"471-100 · Surcharge",0]
[null,"11000 · Accounts Receivable",0]
[null,"Deposits In Transit",null,null,512733.12]
[null,"132-000 · Prepaid Postage",null,null,0.14000000000000001]
[null,"141-000 · Water Customer Accounts Receiva",486477.14]
[null,"143-000 · Provision for Uncollectable Acc",null,null,38554.269999999997]
[null,"162-000 · Prepaid Expenses",12189.72]
[null,"166-000 · Deferred Outflows of Resources",470620]
[null,"108-000 · Accumulated Amortization & Depr",null,null,5211997.42]
[null,"151-000 · Plant Material & Supplies",128012.62]
[null,"17000 · Accumulated Depreciation",0]
[null,"272-000 · Construction in Progress USDA",0]
[null,"303-000 · Land & Land Rights",20810.3]
[null,"304-000 · Structures & Improvements",172027.21]
[null,"305-000 · Leasehold Improvements",11322.5]
[null,"311-000 · Pumping Equipment",461266.17]
[null,"330-000 · Distribution Reservoirs & Stand",617972.82999999996]
[null,"331-000 · Transmission & Distribution Mai",7359208.0499999998]
[null,"334-000 · Meters & Meter Installation",1474180.69]
[null,"335-000 · Hydrants",83391.37]
[null,"338-100 · Computer Hardware",12042.2]
[null,"338-300 · Computer Software",26859.75]
[null,"340-000 · Office Furniture & Equipment",90288.03]
[null,"341-000 · Transportation Equipment",96984.27]
[null,"341-100 · Transportation Equipment - Admi",30283]
[null,"343-000 · Tools, Shop & Garage Equipment",80569.06]
[null,"345-000 · Operating Equipment",306505]
[null,"20000 · *Accounts Payable",0]
[null,"Federal Unemployment Payable",null,null,853.41]
[null,"FICA & Federal W/H Payable",null,null,4394]
[null,"Miscellaneous Payroll Deduction",0]
[null,"2110 · Direct Deposit Liabilities",0]
[null,"231-000 · Accounts Payable",null,null,160653.46]
[null,"235-000 · Water Customer Deposits",null,null,21749.89]
[null,"236-000 · Sales Tax Payable",35033.599999999999]
[null,"236-100 · Utility & School Tax Payable",null,null,8193.86]
[null,"24000 · Payroll Liabilities",null,null,3000.43]
[null,"241-200 · Kentucky Withholding Payable",2884.82]
[null,"241-300 · Boyd County Withholding Payable",null,null,1466.7]
[null,"244-000 · Accrued Sick Leave",null,null,17193.64]
[null,"251-000 · Health Insurance Payable",null,null,51148.11]
[null,"263-100 · Pension Payable",null,null,34634.75]
[null,"263-200 · Savings Deductions Payable",0]
[null,"263-300 · KY Unemployment Payable",384.7]
[null,"264-000 · Accrued Expenses",null,null,3191.51]
[null,"271-100 · Federal Grants in Aid of Constr",0]
[null,"410-000 · Net Pension Liability new acct",null,null,1231968]
[null,"415-000 · Net OPEB Liability",null,null,336267]
[null,"222-000 · Bonds - FHA 91-03",0]
[null,"222-100 · KY RWFC Variable Bond",null,null,123000]
[null,"222-200 · Rural Development 2015",null,null,1546000]
[null,"230-001 · KIA loan B018-011",null,null,49899]
[null,"231-001 · KIA loan C20-001",null,null,317189]
[null,"265-001 · Deferred inflows of resources",null,null,324046]
[null,"271-400 · USDA Grant 2016",231951.86]
[null,"215-000 · Retained Earnings",null,null,4564678.79]
[null,"270-000 · Contri Line Extension Naples",0]
[null,"271-200 · Grant Kia",0]
[null,"461-100 · Metered Sales",null,null,2678215]
[null,"461-600 · Fire Sprinkler",null,null,8920]
[null,"470-000 · Water Penalties",null,null,40987.01]
[null,"471-000 · Miscellaneous Service Revenue",null,null,89961.49]
[null,"471-200 · Connect & Reconnect Charges",null,null,13780]
[null,"480-000 · Contribution - Tap Fees",null,null,25335.53]
[null,"Payroll Taxes",48993.31]
[null,"Salaries & Wages",558556.36]
[null,"Utilities:617-200 · Columbia Gas - Office & Shop",5821.8]
[null,"420-000 · Retirement Plan Expenses",163648.1]
[null,"427-300 · Interest Expense",23.48]
[null,"610-000 · Purchased Water:610-100 · Ashland",1045987.32]
[null,"612-000 · Dues and Subscriptions",51552.95]
[null,"615-200 · KENTUCKY POWER",66226.03]
[null,"616-200 · Cell Phones",11202.79]
[null,"620-000 · Materials & Supplies",160283.60999999999]
[null,"632-000 · Accounting Services",8950]
[null,"633-000 · Legal Services",1306.5]
[null,"635-000 · Contracted Services - Other",157491.04]
[null,"650-000 · Auto & Truck Expenses:650-200 · Repairs",2914.08]
[null,"650-100 · Fuel Expense",24057.88]
[null,"657-000 · Insurance - General Liability",41252.629999999997]
[null,"658-000 · Workers Comp Insurance",13163]
[null,"659-000 · Health Insurance",285317.96999999997]
[null,"659-100 · Dental Insurance",7234.24]
[null,"659-200 · Disability Insurance",1807.2]
[null,"66000 · Payroll Expenses",8215.92]
[null,"675-000 · Copier Lease Expense",5082.84]
[null,"675-500 · Miscellaneous Expense - General",26487.18]
[null,"676-600 · Miscellaneous Operating Expense",16195.52]
[null,"676-700 · Backhoe Fuel",1248.6600000000001]
[null,"678-000 · Water Testing",14208]
[null,"685-000 · Water Pump Repair",1130]
[null,"Interest Income",null,null,3208.94]
["TOTAL",null,{"$f":"ROUND(SUM(C3:C106),5)","v":17423721.449999999},null,{"$f":"ROUND(SUM(E3:E106),5)","v":17423721.449999999}]