{"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":181,"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":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"PREVIOUS YEAR","Jul '20 - May 21",null,null,"Projected 2021/22"]
["Income"]
[null,"EF"]
[null,null,"4620 · Sewer Income",72995.679999999993,null,null,70000]
[null,null,"4620.1 · Trash Income",54293.83,null,null,50000]
[null,null,"4620.2 · Water Income",72336.5,null,null,70000]
[null,null,"4870 · Discounts and Fees",0,null,null,0]
[null,null,"4870.4 · Misc. Enterprise Income",0,null,null,0]
[null,"Total EF",null,{"$f":"ROUND(SUM(D4:D9),5)","v":199626.01},null,null,{"$f":"SUM(G5:G9)","v":190000}]
[null,"GENERAL FUND"]
[null,null,"4010 · Current Secured Taxes",85307.04,null,null,85000]
[null,null,"4020 · Current unsecured Taxes",3224.02,null,null,3200]
[null,null,"4030 · Prior Secured Taxes",16702.13,null,null,16000]
[null,null,"4040 · Prior Unsecured Taxes",82.51,null,null,100]
[null,null,"4080 · Supplemental Taxes",496.92,null,null,100]
[null,null,"4451 · HOPTR",916.39,null,null,1000]
[null,null,"4890.3 · Other GF Income"]
[null,"Total GENERAL FUND",null,{"$f":"ROUND(SUM(D11:D18),5)","v":106729.01},null,null,{"$f":"SUM(G12:G18)","v":105400}]
[null,"GOV F"]
[null,null,"4060 · Current assessments-Fire",230450,null,null,230000]
[null,null,"4065 · Prior assessments- Fire",19967.5,null,null,20000]
[null,null,"4870.1 · Lot Mowing Income",62645,null,null,62000]
[null,null,"4870.2 · Pest Control Income",6109.77,null,null,6000]
[null,null,"4890.1 · Fire Assignment Income",716686.98,null,"NEED TO BALANCE",330000]
[null,null,"4890.2 · Fire Income - Other",0,null,null,0]
[null,"Total GOV F",null,{"$f":"ROUND(SUM(D20:D26),5)","v":1035859.25},null,null,{"$f":"SUM(G21:G26)","v":648000}]
[null,"4060.1 · Current assessments-CSD",null,80329.5,null,null,80000]
[null,"4060.2 · Current assessments-Refuse",null,18436,null,null,18000]
[null,"4065.1 · Prior assessments- CSD",null,11642.45,null,null,11600]
[null,"4065.2 · Prior assessments-Refuse",null,2026.55,null,null,2000]
[null,"4190 · Interest Income",null,19.739999999999998,null,null,55]
[null,"4890 · Cash Overages",null,16,null,null,0]
["Total Income",null,null,{"$f":"ROUND(D3+D10+D19+SUM(D27:D33),5)","v":1454684.51},null,null,{"$f":"SUM(G28:G33)","v":111655}]
[null,null,null,{"$f":"D34","v":1454684.51},null,"TOTAL INCOME",{"$f":"G10+G19+G27+G34","v":1055055}]
["Expense"]
[null,"BENEFITS"]
[null,null,"5020 · Retirement",62064.72,null,null,63000]
[null,null,"5035 · Workmans Comp",-23496.9,null,null,65000]
[null,"Total BENEFITS",null,{"$f":"ROUND(SUM(D37:D39),5)","v":38567.82},null,null,{"$f":"SUM(G38:G39)","v":128000}]
[null,"CAPITAL OUTLAY"]
[null,null,"5350 · Capital Expense - Land",0]
[null,null,"5370 · Capital Expense - Equipment",104772.53,null,null,30000]
[null,"Total CAPITAL OUTLAY",null,{"$f":"ROUND(SUM(D41:D43),5)","v":104772.53},null,null,{"$f":"SUM(G42:G43)","v":30000}]
[null,"OTHER CHARGES"]
[null,null,"5300 · Interest on Long-Term Debt",5503.44]
[null,null,"5310 · Penalties",10367.299999999999,null,null,0]
[null,null,"5340 · Assessment Collection Fees",null,null,null,0]
[null,null,"5345 · Bad Debt",null,null,null,20000]
[null,"Total OTHER CHARGES",null,{"$f":"ROUND(SUM(D45:D49),5)","v":15870.74},null,null,{"$f":"SUM(G47:G49)","v":20000}]
[null,"PR"]
[null,null,"5010 · Directors Stipend",5900,null,null,6000]
[null,null,"5010.1 · Gross Wages",368052.87,null,null,400000]
[null,null,"5010.2 · Health Stipend",18000,null,null,21000]
[null,null,"5010.3 · sick pay",2472.3200000000002,null,null,5000]
[null,null,"5010.4 · Holiday pay",13997.35,null,null,18000]
[null,null,"5010.5 · vacation",4005.96,null,null,6000]
[null,null,"5010.6 · Contracted Fire Pay",274945.95,null,null,150000]
[null,null,"5010.7 · Employer PR taxes",32441.97,null,null,35000]
[null,"Total PR",null,{"$f":"ROUND(SUM(D51:D59),5)","v":719816.42},null,null,{"$f":"SUM(G52:G59)","v":641000}]
[null,"SS"]
[null,null,"5050 · Uniforms",2314.77,null,null,3000]
[null,null,"5060 · Communications",22164.17,null,null,16000]
[null,null,"5080 · Meals",3729.25,null,null,4000]
[null,null,"5090 · Lake Station Expense",2220.59,null,null,2000]
[null,null,"5090.1 · Dump Fees",7962.5,null,null,8800]
[null,null,"5100 · Insurance Exp-liab",5205.33,null,null,45000]
[null,null,"5120 · R&M Equiptment",26943.3,null,"$3300.00 month",35000]
[null,null,"5130 · R&M - Facilities",13474.46,null,"$2050.00 month",20000]
[null,null,"5140 · Medical Equiptment",546.6,null,null,600]
[null,null,"5150 · Dues and Subscriptions",9271.16,null,null,9000]
[null,null,"5170 · Office Supplies",1381.76,null,null,2000]
[null,null,"5170.1 · Postage and Delivery",1317.34,null,null,2000]
[null,null,"5170.2 · Fees",1867.59,null,null,1800]
[null,null,"5180 · Professional Services",12259.15,null,null,15000]
[null,null,"5180.1 · Water Test Expense",1397.5,null,null,1500]
[null,null,"5180.4 · Physical & Drug Test Expense",642,null,null,828]
[null,null,"5180.5 · Contract Labor Expense",0]
[null,null,"5180.6 · Permits & licencing",4955.62,null,null,4500]
[null,null,"5190 · Publications and Legal Notices",885.68,null,null,1000]
[null,null,"5200 · Lease Expense",1818.89,null,null,3000]
[null,null,"5220 · District Expense",718.32,null,null,4500]
[null,null,"5230 · District Special Expense",0]
[null,null,"5231.1 · Safety Expense",4317.99,null,null,6000]
[null,null,"5250 · Training & Travel",699.3,null,null,4000]
[null,null,"5250.1 · Fuel",19179.96,null,null,30000]
[null,null,"5260 · Utilities",16611.66,null,null,20000]
[null,null,"5370.2 · Computer expense",3889.89,null,null,4000]
[null,"Total SS",null,{"$f":"ROUND(SUM(D61:D88),5)","v":165774.78}]
[null,"5160.1 · Cash Shortages",null,0,null,null,0]
[null,"5160.2 · Bank Service Charges",null,89.64,null,null,220]
["Total Expense","5160.3 · Miscellaneous Expense",null,27.45]
[null,"5160.4 · Collections (LM)",null,0]
[null,null,null,null,null,null,{"$f":"SUM(G62:G93)","v":243748}]
[null,null,null,null,null,"TOTAL EXPENSE"]
["OFS",null,null,null,null,null,{"$f":"G40+G44+G50+G60+G94","v":1062748}]
[null,"4460 · Airport CA Disbursement"]
[null,"4460.1 · State-Aid"]
[null,"4580 · Federal Aid",null,null,null,null,10000]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G99:G101)","v":10000}]
[]
[]
[null,null,null,null,null," 2020/21  NET "]
[null,null,null,null,null,null,{"$f":"G35-G96+G102","v":2307}]