General Fund Finance Report (May 2020)

        May 21 Oct ’20 – May 21 YTD Budget % of Budget
  Income          
    311001 · Ad Valorem (2019) Future 0.00 0.00 28,787.00 0.0%
    311002 · Ad Valorem (2020) Assessment 1,194.17 70,031.44 72,558.00 96.52%
    312410 · 1st Local Opt Fuel Tax (LOCOP) 3,943.39 27,597.02 31,000.00 89.02%
    312600 · Discretionary Surtax (DISC) 12,723.58 66,276.08 124,000.00 53.45%
    314100 · Utility Service Tax (FPL-MT) 4,017.45 35,867.18 52,000.00 68.98%
    314800 · Utility Service Tax – Propane 316.56 2,921.40 2,000.00 146.07%
    315000 · Communication Svc Tax (CST) 1,369.33 9,684.34 13,000.00 74.5%
    322000 · Building Permit Fee 1,241.75 34,308.45 7,500.00 457.45%
    323100 · Franchise Fee/Electric (FPL-FR) 3,005.57 25,502.46 37,000.00 68.93%
    329000 · Other Fees – (State Surcharges) 36.01 765.28 300.00 255.09%
    334360 · State Grant – StormWater (CDBG) 9,025.00 22,494.50 512,000.00 4.39%
    334801 · State Grant – Playground Park 0.00 0.00 50,000.00 0.0%
    335120 · State Revenue Sharing 3,459.05 27,672.41 41,365.00 66.9%
    335180 · Local Govt 1/2 ct Tx (Sale) 4,578.82 31,563.41 43,300.00 72.9%
    335490 · Other (FDOT Lighting/Signal) 0.00 0.00 8,000.00 0.0%
    337100 · Local Grant (Historical Museum) 0.00 20,838.47 30,000.00 69.46%
    342500 · Svc Chg/Annual Fire Inspection 0.00 60.00 1,500.00 4.0%
    343900 · Other – (FDOT Mowing/Misc) 0.00 7,499.86 15,500.00 48.39%
    347200 · Service Charge – Parks & Rec 0.00 150.00 150.00 100.0%
    351500 · Judgments & Fees (Traffic) 0.00 0.00 100.00 0.0%
    361200 · Interest Income 29.01 414.38 2,400.00 17.27%
    366000 · Contribution/Donations/Private 0.00 0.00 100.00 0.0%
    367000 · License (Business) 0.00 24.00 50.00 48.0%
    369900 · Other Miscellaneous Revenues 159.54 10,794.92 100.00 10,794.92%
    381000 · Water Utility Transfer In 4,051.08 34,080.95 52,894.00 64.43%
    381002 · WW/Sewer Transfer In 2,946.69 22,768.46 32,085.00 70.96%
    389900 · Building Permit Capital (2019) 0.00 56,656.35 57,647.00 98.28%
    389901 · Building Permit Capital (2020) 469.83 48,754.40 50,000.00 97.51%
    389902 · Ad Valorem Capital (2019) 0.00 0.00 3,950.00 0.0%
  Total Income 52,566.83 556,725.76 1,269,286.00 43.86%
  Expense        
    5110000 · Legislative Salaries (Council)        
      5119000 · Council Reserve Fund 100.00 200.00 6,975.00 2.87%
    Total 5110000 · Legislative Salaries (Council) 100.00 200.00 6,975.00 2.87%
    5121000 · Executive Salaries        
      5121100 · Town Manager Salary 4,421.30 40,711.28 57,977.00 70.22%
      5122100 · Payroll Tax Expense 876.75 7,619.89 11,595.00 65.72%
      5122200 · Pension Plan Expense 350.41 3,903.19 5,747.00 67.92%
      5122300 · Health Insurance 418.52 3,170.44 5,040.00 62.91%
    Total 5121000 · Executive Salaries 6,066.98 55,404.80 80,359.00 68.95%
    5131000 · Reg Salaries & Wages        
      5131200 · Water Admin Salary (Wendy) 0.00 999.99 1,000.00 100.0%
      5131201 · Town Clerk Salary (Anita) 2,326.56 22,493.06 35,025.00 64.22%
      5131202 · Admin Asst Salary (Rachael) 552.00 13,393.00 13,641.00 98.18%
      5131203 · Admin Asst Salary (Ashley) 0.00 7,789.76 7,790.00 100.0%
      5131204 · Admin Asst (Jenna) 426.48 426.48 8,596.00 4.96%
      5131205 · Admin Asst (Eva) 294.00 294.00 8,596.00 3.42%
      5132100 · Payroll Tax Expense 776.42 7,355.82 10,745.00 68.46%
      5132200 · Pension Plan Expense 493.58 5,022.82 7,886.00 63.69%
      5132300 · Health Insurance 1,102.36 11,456.20 19,315.00 59.31%
      5132400 · Workers’ Comp 0.00 3,751.00 7,393.00 50.74%
    Total 5131000 · Reg Salaries & Wages 5,971.40 72,982.13 119,987.00 60.83%
    5133000 · Financial & Admin – (Oper Exp)        
      5133100 · Professional Services 669.48 1,149.48 2,500.00 45.98%
      5133200 · Accounting/Auditing 0.00 1,250.00 8,000.00 15.63%
      5134100 · Telephone 640.92 4,678.74 6,500.00 71.98%
      5134600 · Repair & Maintenance 0.00 286.00 500.00 57.2%
      5134901 · Legal Ads 108.00 1,342.00 1,500.00 89.47%
      5135200 · Operating Supplies (Bank Fees) 100.95 1,596.00 1,500.00 106.4%
      5135400 · Dues/Subscriptions 95.99 4,012.11 3,000.00 133.74%
      5135500 · Education/Training 0.00 15.50 300.00 5.17%
    Total 5133000 · Financial & Admin – (Oper Exp) 1,615.34 14,329.83 23,800.00 60.21%
    5140000 · Legal Services        
      5140001 · Town Attorney Expense 0.00 1,800.00 2,500.00 72.0%
    Total 5140000 · Legal Services 0.00 1,800.00 2,500.00 72.0%
    5191000 · General Govt Salaries        
      5191200 · Grant Writer Salary 400.00 3,500.00 5,200.00 67.31%
      5192100 · Payroll Taxes 30.60 267.75 416.00 64.36%
    Total 5191000 · General Govt Salaries 430.60 3,767.75 5,616.00 67.09%
    5193000 · General Government (Oper Exp)        
      5194200 · Postage/Freight 37.05 553.95 750.00 73.86%
      5194300 · Utilities Expense 528.71 2,598.37 3,500.00 74.24%
      5194400 · Rentals/Leases 399.00 3,883.80 4,200.00 92.47%
      5194500 · Insurance (Property) 0.00 3,543.00 6,525.00 54.3%
      5195100 · Office Supplies 387.93 6,677.34 8,000.00 83.47%
      5195102 · Emergency Plan Exp (CEMP) 0.00 0.00 1,000.00 0.0%
    Total 5193000 · General Government (Oper Exp) 1,352.69 17,256.46 23,975.00 71.98%
    5196000 · Capital Expenditure (> $5,000)        
      5196001 · Capital Outlay (Restricted) 0.00 0.00 79,132.00 0.0%
      5196200 · Capital Outlay – Unrestricted 256.36 6,282.61 42,339.59 14.84%
      5196202 · Historic Museum – Restricted 0.00 0.00 2,600.00 0.0%
      5196300 · Passive Park – Restoration-ADV 0.00 0.00 3,950.00 0.0%
      5196302 · Paint/Landscape Town Hall – BPR 0.00 0.00 4,812.00 0.0%
      5196303 · ADA Restrooms – BPR 0.00 39,806.55 38,964.66 102.16%
      5196305 · Town Hall / Storage Room – BPR 0.00 16,850.00 16,850.00 100.0%
      5196308 · Park Benches – ADV 0.00 0.00 1,000.00 0.0%
      5196309 · Storm Drain Covers – ADV 0.00 0.00 3,000.00 0.0%
      5196310 · Sidewalk Railings – ADV 0.00 0.00 5,000.00 0.0%
      5196311 · Sidewalk Repairs – ADV 0.00 8,430.00 10,000.00 84.3%
      5196312 · Town Hall Front Office – BPR 469.83 40,324.40 45,000.00 89.61%
      5196313 · Town Hall Back Hallway – BPR 0.00 0.00 5,000.00 0.0%
    Total 5196000 · Capital Expenditure (> $5,000) 726.19 111,693.56 257,648.25 43.35%
    5210000 · TOPF – Grants        
      5210001 · State Grant – CDBG Storm Water 9,025.00 17,114.95 512,000.00 3.34%
      5210002 · State Grant –  Park Upgrades 0.00 0.00 50,000.00 0.0%
      5210003 · Local Grant – Historical Museum 0.00 20,838.47 30,000.00 69.46%
    Total 5210000 · TOPF – Grants 9,025.00 37,953.42 592,000.00 6.41%
    5243000 · Protective Inspections        
      5243100 · Inspections / Plan Reviews 0.00 6,350.00 5,000.00 127.0%
      5244900 · State Surcharge Fees 0.00 96.85 300.00 32.28%
    Total 5243000 · Protective Inspections 0.00 6,446.85 5,300.00 121.64%
    5411000 · Public Works (Salaries)        
      5411204 · Public Works (Trevor) 1,858.45 16,700.54 24,450.00 68.31%
      5411205 · Public Works (Josh) 560.00 5,181.27 7,610.00 68.09%
      5411206 · Public Works (Tyler) 0.00 1,370.25 1,370.25 100.0%
      5411207 · Public Works (Hunter) 0.00 565.50 565.50 100.0%
      5411208 · Public Works (Michael) 0.00 7,029.86 7,030.00 100.0%
      5411209 · Public Works (Ryan) 1,794.38 1,794.38 14,180.00 12.65%
      5412100 · Payroll Tax Expense 542.53 4,623.98 7,914.00 58.43%
      5412200 · Pension Plan Expense 232.62 1,834.17 8,563.00 21.42%
      5412300 · Health Insurance 498.10 5,283.61 12,869.00 41.06%
      5412400 · Workers’ Compensation 0.00 3,751.00 7,393.00 50.74%
    Total 5411000 · Public Works (Salaries) 5,486.08 48,134.56 91,944.75 52.35%
    5413000 · Public Works (Oper Exp)        
      5414100 · Telephone 428.17 3,339.73 5,000.00 66.8%
      5414300 · Utilities/Electric Expense 1,047.93 8,213.80 11,000.00 74.67%
      5414500 · Insurance (Auto/Truck) 0.00 826.00 1,518.00 54.41%
      5414600 · Repair & Maintenance 0.00 2,627.27 8,000.00 32.84%
      5415200 · Operating Supplies 845.35 6,130.29 5,000.00 122.61%
      5415201 · Fuel 0.00 3,227.71 5,900.00 54.71%
      5415202 · Uniforms 531.83 2,248.41 3,000.00 74.95%
      5415300 · Road Materials/Supplies/Equip 0.00 220.98 1,000.00 22.1%
      5415500 · Training (Certification) 0.00 0.00 100.00 0.0%
    Total 5413000 · Public Works (Oper Exp) 2,853.28 26,834.19 40,518.00 66.23%
    5723000 · Parks & Recreation (Oper Exp)        
      5724300 · Utilities/Electric Expense 66.36 550.75 1,000.00 55.08%
      5724500 · Insurance (General Liability) 0.00 5,835.50 13,463.00 43.35%
      5724600 · Repair & Maintenance 0.00 0.00 1,500.00 0.0%
      5724800 · Special Events (Parades, etc) 0.00 93.23 2,500.00 3.73%
    Total 5723000 · Parks & Recreation (Oper Exp) 66.36 6,479.48 18,463.00 35.09%
    5810000 · Interfund Transfers Out        
      5810001 · Transfer Out to Sewer Fund 0.00 3,850.00 100.00 3,850.0%
      5810003 · Transfer Out to Water Utility 0.00 2,800.00 100.00 2,800.0%
    Total 5810000 · Interfund Transfers Out 0.00 6,650.00 200.00 3,325.0%
  Total Expense 33,693.92 409,933.03 1,269,286.00 32.3%
Net Income   18,872.91 146,792.73 0.00 100.0%