{"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":159,"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":90,"n_cols":5,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[null,null,"Dec 31, 23"]
[null,null,"Debit",null,"Credit"]
[null,"131 · Cash-:131.10 · REGIONS-HICKORY O&M",null,null,24965.73]
[null,"131 · Cash-:131.11 · REGIONS-HICKORY RESERVE",null,null,26066.71]
[null,"131 · Cash-:131.12 · REGIONS-HICKORY CUSTOMER DEP",null,null,3744.26]
[null,"131 · Cash-:131.2 · FNB-O&M",null,null,1360241.42]
[null,"131 · Cash-:131.25 · FNB Money Mkt",28709.99]
[null,"131 · Cash-:131.6 · FNB-WATER LOSS REDUCTION",1195976.07]
[null,"131 · Cash-:131.7 · FNB-HICKORY DEBT RETIREMENT",51832]
[null,"131 · Cash-:131.8 · FCB-Capital Improvement CD's:131.81 · FCB FF - CD 11134",616.58000000000004]
[null,"131 · Cash-:131.8 · FCB-Capital Improvement CD's:131.83 · FCB FF CD 11132",null,null,54677.34]
[null,"131 · Cash-:131.9 · FNB - KIA Reserve",45938.81]
[null,"131 · Cash-:131.95 · FNB HICKORY KIA RESERVE",null,null,338.34]
[null,"131.15 · Cash in Bank-Fnb Sedalia O & M",4156.1899999999996]
[null,"Current and Accrued Assets:135 · Temporary Cash Investments:135.11 · REGIONS-HICKORY CD",null,null,29638.33]
[null,"Current and Accrued Assets:135 · Temporary Cash Investments:135.14 · FNB-CD-86265-HICKORY",447.2]
[null,"Current and Accrued Assets:141 · Customer Accounts Receivable",416260.83]
[null,"Current and Accrued Assets:142 · Other Accounts Receivable",null,null,7715.66]
[null,"Current and Accrued Assets:174 · Mis. Current & Accrued Assets",null,null,158016.87]
[null,"Utility Plant:101 · Utility Plant in Serivce",1274650.47]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.1 · Land and Land Rights",440]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.2 · Structures and Improvements",50565.07]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.3 · Wells and Springs",45597]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.4 · Pumping Equipment",70075.710000000006]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.44 · Power Operated Equipment",1407.42]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.5 · Water Treatment Equipment",8036.68]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.6 · Distribution Reservoirs & Stand",762939.41]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.7 · Transmission & Distr Mains",661642.56000000006]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.8 · Services",7035]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.9 · Meters and Meter Installation",886742.72]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.91 · Hydrants",6879.02]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.92 · Other Plant & Misc Equip",33962.94]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.93 · Office Furniture & Equip",4142]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.98 · Organization",18944]
[null,"Utility Plant:102 · Utility Plant Leased to Others",null,null,2700]
[null,"Utility Plant:104 · Utility Plant Purchased or Sold",null,null,8100]
[null,"Utility Plant:108 · Accumulated Depreciation:108.1 · A/Depreciation of Utility Plant",null,null,4802763.74]
[null,"Current & Accrued Liabilities:231 · Accounts Payable",54917.17]
[null,"Current & Accrued Liabilities:232 · Notes Payable",219314.96]
[null,"Current & Accrued Liabilities:234 · N/P to Associated Companies",null,null,30000]
[null,"Current & Accrued Liabilities:235 · Customer Deposits",null,null,105255.36]
[null,"Current & Accrued Liabilities:236 · Accrued Taxes:236.1 · Utility Operating Income:236.11 · Taxes Other Than Income",null,null,150]
[null,"Current & Accrued Liabilities:237 · Accrued Interest:237.1 · Accrued Interest on L/T Debt",1611.48]
[null,"Current & Accrued Liabilities:241 · Tax Collections Payable",null,null,772918.42]
[null,"238 · Payroll Liabilities",null,null,68000.3]
[null,"Long Term Debt:224 · Other Long Term Debt",16194.67]
[null,"Long Term Debt:224 · Other Long Term Debt:224.1 · N/P KIA Fancy Farm B05-04",258818.79]
[null,"Long Term Debt:224 · Other Long Term Debt:224.2 · N/P Fancy Farm Area 2",121553.68]
[null,"Long Term Debt:224 · Other Long Term Debt:224.3 · N/P KIA- South Graves B07-03",620790.24]
[null,"Long Term Debt:224 · Other Long Term Debt:224.4 · N/P KIA AMI PROJECT B11-02",null,null,403727.12]
[null,"Long Term Debt:224 · Other Long Term Debt:224.5 · N/P KIA Hickory B96-04",204638.84]
[null,"Long Term Debt:224 · Other Long Term Debt:224.6 · N/P FNB Loan (FF)",null,null,3121.69]
[null,"Equity Capital:215 · Unappropriated R/E:215.2 · Donated Capital",null,null,467259.84]
[null,"32000 · Unrestricted Net Assets",null,null,535336.56000000006]
[null,"432 · Proceeds Capital Contributions",null,null,159554]
[null,"Water Operating Revenue Account:Other Water Revenues:470 · Forfeited Discounts",null,null,622.5]
[null,"Water Operating Revenue Account:Other Water Revenues:471 · Mis. Service Revenues",null,null,104961.04]
[null,"Water Operating Revenue Account:Other Water Revenues:472 · Rents from Water Property",null,null,1400]
[null,"Water Operating Revenue Account:Other Water Revenues:474 · Other Water Revenues",null,null,707.3]
[null,"Water Operating Revenue Account:Other Water Revenues:474 · Other Water Revenues:474.1 · HICKORY DEBT SURCHARGE",null,null,7225]
[null,"Water Operating Revenue Account:Other Water Revenues:474 · Other Water Revenues:474.2 · WATER LOSS REDUCTION SURCHARGE",null,null,284700]
[null,"Water Operating Revenue Account:Water Sales:461 · Metered Water Revenue:461.1 · Residential Customers",null,null,1506286.84]
[null,"Water Operating Revenue Account:Water Sales:461 · Metered Water Revenue:461.2 · Commercial Customers",null,null,348241.6]
[null,"Water Operating Revenue Account:Water Sales:466 · Sales for Resale",null,null,22541.96]
[null,"413 · Utility Plant Leased to Others",null,null,7000]
[null,"Water Maintenace Expense Accts:603 · Salaries & Wages - Officers etc",22225]
[null,"Water Maintenace Expense Accts:610 · Purchased Water",312334.56]
[null,"Water Maintenace Expense Accts:615 · Purchased Power",103380.64]
[null,"Water Maintenace Expense Accts:618A · Chemical & Analysis:618 · Chemicals",102467.68]
[null,"Water Maintenace Expense Accts:618A · Chemical & Analysis:635 · Contractual Service Water Testi",43254.74]
[null,"Water Maintenace Expense Accts:620 · Materials & Supplies",198130.81]
[null,"Water Maintenace Expense Accts:631 · Contractual Service Engineering",37755]
[null,"Water Maintenace Expense Accts:634a · Contracted Services:632 · Contractual Service Accounting",8066.68]
[null,"Water Maintenace Expense Accts:634a · Contracted Services:633 · Contractual Service Legal",20778.75]
[null,"Water Maintenace Expense Accts:634a · Contracted Services:634 · Contractual Ser. Management Fee",996056.55]
[null,"Water Maintenace Expense Accts:634a · Contracted Services:636 · Contractual Service Other",49568.95]
[null,"Water Maintenace Expense Accts:642 · Rental of Equipment",127749.68]
[null,"Water Maintenace Expense Accts:656A · Insurance:657 · Insurance - General Liability",9754.59]
[null,"Water Maintenace Expense Accts:656A · Insurance:659 · Insurance Other",15684.61]
[null,"Water Maintenace Expense Accts:667 · Reg. Comm. Expense Other",500]
[null,"Water Maintenace Expense Accts:670 · Bad Debt Expense",23233.38]
[null,"Water Maintenace Expense Accts:675 · Miscellaneous Expense",39188.21]
[null,"403 · Depreciation Expense",341953.98]
[null,"408 · Taxes Other than Income:408.10 · Utility Reg. Assessment Fees",2868.98]
[null,"408 · Taxes Other than Income:408.12 · Payroll Taxes",1880.55]
[null,"427 · Interest Expense:427.3 · Long-Term Debt",11398.56]
[null,"427 · Interest Expense:427.4 · Customer Deposits",667.97]
[null,"419 · Interest & Dividend Income",null,null,14690.03]
[null,"422 · Grant Income",null,null,75042.350000000006]
["TOTAL",null,{"$f":"ROUND(SUM(C3:C89),5)","v":9543737.3699999992},null,{"$f":"ROUND(SUM(E3:E89),5)","v":11397710.310000001}]