{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["QuickBooks Desktop Export Tips","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":193,"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":122,"n_cols":5,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
[null,null,"Dec 31, 23"]
[null,null,"Debit",null,"Credit"]
[null,"131 · Cash-:131.1 · Cash on Hand-",0]
[null,"131 · Cash-:131.10 · REGIONS-HICKORY O&M",0]
[null,"131 · Cash-:131.11 · REGIONS-HICKORY RESERVE",0]
[null,"131 · Cash-:131.12 · REGIONS-HICKORY CUSTOMER DEP",0]
[null,"131 · Cash-:131.2 · FNB-O&M",119996.28]
[null,"131 · Cash-:131.25 · FNB Money Mkt",236846.7]
[null,"131 · Cash-:131.3 · FNB-Capital Improvement",0]
[null,"131 · Cash-:131.4 · FNB-Customer Deposits",55356.67]
[null,"131 · Cash-:131.5 · FNB-Debt Service",0]
[null,"131 · Cash-:131.6 · FNB-WATER LOSS REDUCTION",156278.99]
[null,"131 · Cash-:131.7 · FNB-HICKORY DEBT RETIREMENT",1.21]
[null,"131 · Cash-:131.8 · FCB-Capital Improvement CD's",0]
[null,"131 · Cash-:131.8 · FCB-Capital Improvement CD's:131.81 · FCB FF - CD 11134",0]
[null,"131 · Cash-:131.8 · FCB-Capital Improvement CD's:131.82 · FCB FF CD 11133",0]
[null,"131 · Cash-:131.8 · FCB-Capital Improvement CD's:131.83 · FCB FF CD 11132",0]
[null,"131 · Cash-:131.9 · FNB - KIA Reserve",97012.7]
[null,"131 · Cash-:131.95 · FNB HICKORY KIA RESERVE",5.84]
[null,"131.15 · Cash in Bank-Fnb Sedalia O & M",0]
[null,"Current and Accrued Assets:135 · Temporary Cash Investments:135.11 · REGIONS-HICKORY CD",0]
[null,"Current and Accrued Assets:135 · Temporary Cash Investments:135.12 · FNB-CD 86664-HICKORY",0]
[null,"Current and Accrued Assets:135 · Temporary Cash Investments:135.13 · FNB-CD-86199-HICKORY",0]
[null,"Current and Accrued Assets:135 · Temporary Cash Investments:135.14 · FNB-CD-86265-HICKORY",0]
[null,"Current and Accrued Assets:135 · Temporary Cash Investments:135.51 · FNB-CD-86663-HICKORY",0]
[null,"Current and Accrued Assets:135 · Temporary Cash Investments:135.52 · FNB-CD-86665-HICKORY",0]
[null,"Current and Accrued Assets:141 · Customer Accounts Receivable",183075.07]
[null,"Current and Accrued Assets:142 · Other Accounts Receivable",0]
[null,"Current and Accrued Assets:146 · N/R from Associated Companies",0]
[null,"Current and Accrued Assets:174 · Mis. Current & Accrued Assets",18500.46]
[null,"Utility Plant:101 · Utility Plant in Serivce",0]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.1 · Land and Land Rights",50185.82]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.2 · Structures and Improvements",1639428.7]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.3 · Wells and Springs",562844.25]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.4 · Pumping Equipment",327415.77]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.44 · Power Operated Equipment",31209.42]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.45 · Power Generation Equip",17141]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.5 · Water Treatment Equipment",529053.72]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.6 · Distribution Reservoirs & Stand",3104839.95]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.7 · Transmission & Distr Mains",8610106.5500000007]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.8 · Services",319700.83]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.9 · Meters and Meter Installation",2770588.8]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.91 · Hydrants",127103.53]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.92 · Other Plant & Misc Equip",77796.160000000003]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.93 · Office Furniture & Equip",75566.23]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.94 · Franchise",7921]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.95 · Collecting & Impounding Reservi",54620]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.96 · Lake, River & Other Intake",88226]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.97 · Miscellaneous Equipment",6456]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.98 · Organization",85680]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.99 · Other Tangible Equipment",4000]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.991 · Tools. Shop & Garage",2158]
[null,"Utility Plant:101 · Utility Plant in Serivce:101.992 · Transportation Equipment Stores",10750]
[null,"Utility Plant:102 · Utility Plant Leased to Others",0]
[null,"Utility Plant:104 · Utility Plant Purchased or Sold",0]
[null,"Utility Plant:108 · Accumulated Depreciation:108.1 · A/Depreciation of Utility Plant",null,null,11193293.970000001]
[null,"107 · Utility Plant Sewer",1735726.83]
[null,"107 · Utility Plant Sewer:107.1 · A/D Sewer Utility",null,null,1471280.8]
[null,"Deferred Debits:181 · Unamortized Debt Discount & Exp",0]
[null,"20000 · Accounts Payable",null,null,118319.91]
[null,"Current & Accrued Liabilities:231 · Accounts Payable",0]
[null,"Current & Accrued Liabilities:232 · Notes Payable",0]
[null,"Current & Accrued Liabilities:234 · N/P to Associated Companies",0]
[null,"Current & Accrued Liabilities:235 · Customer Deposits",null,null,190124.78]
[null,"Current & Accrued Liabilities:236 · Accrued Taxes:236.1 · Utility Operating Income",0]
[null,"Current & Accrued Liabilities:236 · Accrued Taxes:236.1 · Utility Operating Income:236.11 · Taxes Other Than Income",0]
[null,"Current & Accrued Liabilities:237 · Accrued Interest:237.1 · Accrued Interest on L/T Debt",0]
[null,"Current & Accrued Liabilities:241 · Tax Collections Payable",null,null,7813.99]
[null,"Deferred Credits:252 · Advances for Construction",0]
[null,"Water Utility Plant Accounts:311 · Pumping Equipment",0]
[null,"238 · Payroll Liabilities",null,null,1365.04]
[null,"Long Term Debt:224 · Other Long Term Debt",null,null,3344]
[null,"Long Term Debt:224 · Other Long Term Debt:224.1 · N/P KIA Fancy Farm B05-04",null,null,51822.33]
[null,"Long Term Debt:224 · Other Long Term Debt:224.2 · N/P Fancy Farm Area 2",0]
[null,"Long Term Debt:224 · Other Long Term Debt:224.3 · N/P KIA- South Graves B07-03",null,null,154072.82]
[null,"Long Term Debt:224 · Other Long Term Debt:224.4 · N/P KIA AMI PROJECT B11-02",null,null,428678.64]
[null,"Long Term Debt:224 · Other Long Term Debt:224.5 · N/P KIA Hickory B96-04",0]
[null,"Long Term Debt:224 · Other Long Term Debt:224.6 · N/P FNB Loan (FF)",0]
[null,"Long Term Debt:224 · Other Long Term Debt:224.7 · CFSB - Revolving Line of Credit",0]
[null,"231.1 · Land Condemnation Escrow",null,null,5478]
[null,"Equity Capital:215 · Unappropriated R/E:215.1 · R/E from Income Before Contribt",null,null,208719.93]
[null,"Equity Capital:215 · Unappropriated R/E:215.2 · Donated Capital",null,null,7559546.5599999996]
[null,"32000 · Unrestricted Net Assets",336589.4]
[null,"432 · Proceeds Capital Contributions",null,null,159554]
[null,"439 · Adj. to Retained Earnings",220.21]
[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,"400 · Operating Revenues",null,null,100632.74]
[null,"413 · Utility Plant Leased to Others",null,null,7000]
[null,"Water Maintenace Expense Accts:603 · Salaries & Wages - Officers etc",24300]
[null,"Water Maintenace Expense Accts:610 · Purchased Water",312334.56]
[null,"Water Maintenace Expense Accts:615 · Purchased Power",112221.28]
[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",58842.26]
[null,"Water Maintenace Expense Accts:620 · Materials & Supplies",203204]
[null,"Water Maintenace Expense Accts:631 · Contractual Service Engineering",37755]
[null,"Water Maintenace Expense Accts:634a · Contracted Services:632 · Contractual Service Accounting",8800]
[null,"Water Maintenace Expense Accts:634a · Contracted Services:633 · Contractual Service Legal",21306.62]
[null,"Water Maintenace Expense Accts:634a · Contracted Services:634 · Contractual Ser. Management Fee",1032338.98]
[null,"Water Maintenace Expense Accts:634a · Contracted Services:636 · Contractual Service Other",50665.88]
[null,"Water Maintenace Expense Accts:642 · Rental of Equipment",127749.68]
[null,"Water Maintenace Expense Accts:656A · Insurance:657 · Insurance - General Liability",10618.64]
[null,"Water Maintenace Expense Accts:656A · Insurance:659 · Insurance Other",17133.099999999999]
[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",41005.07]
[null,"403 · Depreciation Expense",362993.73]
[null,"408 · Taxes Other than Income:408.10 · Utility Reg. Assessment Fees",3129.8]
[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",682.53]
[null,"415 · Merchandising Jobbing & Contrac",21066.94]
[null,"419 · Interest & Dividend Income",null,null,15254.23]
[null,"422 · Grant Income",null,null,75042.350000000006]
["TOTAL",null,{"$f":"ROUND(SUM(C3:C121),5)","v":24028030.329999998},null,{"$f":"ROUND(SUM(E3:E121),5)","v":24028030.329999998}]