General Fund Finance Report (July 2021)

        Jul 21 Oct ’20 – Jul 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 0.00 72,353.57 72,558.00 99.72%
    312410 · 1st Local Opt Fuel Tax (LOCOP) 3,350.68 34,575.45 31,000.00 111.53%
    312600 · Discretionary Surtax (DISC) 6,778.90 80,277.66 124,000.00 64.74%
    314100 · Utility Service Tax (FPL-MT) 4,023.06 43,832.41 52,000.00 84.29%
    314800 · Utility Service Tax – Propane 195.34 3,318.08 2,000.00 165.9%
    315000 · Communication Svc Tax (CST) 1,206.14 11,983.29 13,000.00 92.18%
    322000 · Building Permit Fee 9,432.00 48,517.05 7,500.00 646.89%
    323100 · Franchise Fee/Electric (FPL-FR) 2,749.61 30,983.26 37,000.00 83.74%
    329000 · Other Fees – (State Surcharges) 156.90 1,052.78 300.00 350.93%
    334360 · State Grant – StormWater (CDBG) 133,018.64 251,983.56 512,000.00 49.22%
    334801 · State Grant – Playground Park 0.00 0.00 50,000.00 0.0%
    335120 · State Revenue Sharing 3,965.85 35,097.32 41,365.00 84.85%
    335180 · Local Govt 1/2 ct Tx (Sale) 4,383.50 40,475.73 43,300.00 93.48%
    335490 · Other (FDOT Lighting/Signal) 0.00 4,591.53 8,000.00 57.39%
    337100 · Local Grant (Historical Museum) 12,750.43 39,962.93 30,000.00 133.21%
    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 27.01 467.43 2,400.00 19.48%
    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 17,646.22 23,152.24 100.00 23,152.24%
    381000 · Water Utility Transfer In 4,177.41 42,497.45 52,894.00 80.35%
    381002 · WW/Sewer Transfer In 3,494.02 29,760.87 32,085.00 92.76%
    389900 · Building Permit Capital (2019) 0.00 56,656.35 57,647.00 98.28%
    389901 · Building Permit Capital (2020) 0.00 49,171.29 50,000.00 98.34%
    389902 · Ad Valorem Capital (2019) 0.00 0.00 3,950.00 0.0%
  Total Income 207,355.71 908,444.11 1,269,286.00 71.57%
  Expense          
    5110000 · Legislative Salaries (Council)        
      5119000 · Council Reserve Fund 1,710.53 1,910.53 6,975.00 27.39%
    Total 5110000 · Legislative Salaries (Council) 1,710.53 1,910.53 6,975.00 27.39%
    5121000 · Executive Salaries        
      5121100 · Town Manager Salary 4,421.30 49,553.88 57,977.00 85.47%
      5122100 · Payroll Tax Expense 876.75 9,373.40 11,595.00 80.84%
      5122200 · Pension Plan Expense 442.14 4,787.47 5,747.00 83.3%
      5122300 · Health Insurance 418.52 4,007.48 5,040.00 79.51%
    Total 5121000 · Executive Salaries 6,158.71 67,722.23 80,359.00 84.28%
    5131000 · Reg Salaries & Wages        
      5131200 · Water Admin Salary (Wendy) 0.00 999.99 1,000.00 100.0%
      5131201 · Town Clerk Salary (Anita) 2,541.14 27,352.88 35,025.00 78.1%
      5131202 · Admin Asst Salary (Rachael) 0.00 13,393.00 13,393.00 100.0%
      5131203 · Admin Asst Salary (Ashley) 0.00 7,789.76 7,790.00 100.0%
      5131204 · Admin Asst (Jenna) 365.40 1,171.98 8,596.00 13.63%
      5131205 · Admin Asst (Eva) 1,932.00 4,110.75 8,596.00 47.82%
      5132100 · Payroll Tax Expense 983.62 9,314.24 10,993.00 84.73%
      5132200 · Pension Plan Expense 440.74 5,905.09 7,886.00 74.88%
      5132300 · Health Insurance 1,291.17 13,849.73 19,315.00 71.71%
      5132400 · Workers’ Comp 0.00 5,626.50 7,393.00 76.11%
    Total 5131000 · Reg Salaries & Wages 7,554.07 89,513.92 119,987.00 74.6%
    5133000 · Financial & Admin – (Oper Exp)        
      5133100 · Professional Services 200.00 1,349.48 2,500.00 53.98%
      5133200 · Accounting/Auditing 4,500.00 5,750.00 8,000.00 71.88%
      5134100 · Telephone 644.45 5,963.40 6,500.00 91.75%
      5134600 · Repair & Maintenance 0.00 286.00 500.00 57.2%
      5134901 · Legal Ads 123.00 1,534.00 1,500.00 102.27%
      5135200 · Operating Supplies (Bank Fees) 79.26 1,937.21 3,000.00 64.57%
      5135400 · Dues/Subscriptions 189.80 4,201.91 4,500.00 93.38%
      5135500 · Education/Training 0.00 15.50 300.00 5.17%
    Total 5133000 · Financial & Admin – (Oper Exp) 5,736.51 21,037.50 26,800.00 78.5%
    5140000 · Legal Services        
      5140001 · Town Attorney Expense 600.00 2,400.00 2,500.00 96.0%
    Total 5140000 · Legal Services 600.00 2,400.00 2,500.00 96.0%
    5191000 · General Govt Salaries        
      5191200 · Grant Writer Salary 400.00 4,300.00 5,200.00 82.69%
      5192100 · Payroll Taxes 30.60 328.95 416.00 79.08%
    Total 5191000 · General Govt Salaries 430.60 4,628.95 5,616.00 82.42%
    5193000 · General Government (Oper Exp)        
      5194200 · Postage/Freight 140.70 929.73 750.00 123.96%
      5194300 · Utilities Expense 530.76 3,562.86 3,500.00 101.8%
      5194400 · Rentals/Leases 399.00 4,282.80 4,200.00 101.97%
      5194500 · Insurance (Property) 0.00 5,314.50 6,525.00 81.45%
      5195100 · Office Supplies 321.84 7,540.39 8,000.00 94.26%
      5195102 · Emergency Plan Exp (CEMP) 0.00 529.39 1,000.00 52.94%
    Total 5193000 · General Government (Oper Exp) 1,392.30 22,159.67 23,975.00 92.43%
    5196000 · Capital Expenditure (> $5,000)        
      5196001 · Capital Outlay (Restricted) 0.00 0.00 79,132.00 0.0%
      5196200 · Capital Outlay – Unrestricted 0.00 6,282.61 39,339.59 15.97%
      5196202 · Historic Museum – Restricted 0.00 0.00 2,600.00 0.0%
      5196300 · Passive Park – Restoration-ADV 0.00 1,512.66 3,950.00 38.3%
      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 870.67 870.67 1,000.00 87.07%
      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 0.00 40,741.29 45,000.00 90.54%
      5196313 · Town Hall Back Hallway – BPR 0.00 0.00 5,000.00 0.0%
    Total 5196000 · Capital Expenditure (> $5,000) 870.67 114,493.78 254,648.25 44.96%
    5210000 · TOPF – Grants        
      5210001 · State Grant – CDBG Storm Water 133,018.64 246,604.01 512,000.00 48.17%
      5210002 · State Grant –  Park Upgrades 0.00 0.00 50,000.00 0.0%
      5210003 · Local Grant – Historical Museum 12,750.43 33,898.93 30,000.00 113.0%
    Total 5210000 · TOPF – Grants 145,769.07 280,502.94 592,000.00 47.38%
    5243000 · Protective Inspections        
      5243100 · Inspections / Plan Reviews 700.00 9,595.00 5,000.00 191.9%
      5244900 · State Surcharge Fees 26.06 122.91 300.00 40.97%
    Total 5243000 · Protective Inspections 726.06 9,717.91 5,300.00 183.36%
    5411000 · Public Works (Salaries)        
      5411204 · Public Works (Trevor) 1,653.14 20,139.03 24,450.00 82.37%
      5411205 · Public Works (Josh) 586.25 6,334.09 7,610.00 83.23%
      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,687.50 5,263.61 10,180.00 51.71%
      5412100 · Payroll Tax Expense 485.29 5,634.44 7,914.00 71.2%
      5412200 · Pension Plan Expense 214.73 2,274.87 8,563.00 26.57%
      5412300 · Health Insurance 608.10 6,389.81 12,869.00 49.65%
      5412400 · Workers’ Compensation 0.00 5,626.50 7,393.00 76.11%
    Total 5411000 · Public Works (Salaries) 5,235.01 60,627.96 87,944.75 68.94%
    5413000 · Public Works (Oper Exp)        
      5414100 · Telephone 571.51 4,314.41 5,000.00 86.29%
      5414300 · Utilities/Electric Expense 1,069.15 10,346.24 11,000.00 94.06%
      5414500 · Insurance (Auto/Truck) 0.00 1,239.00 1,518.00 81.62%
      5414600 · Repair & Maintenance 1,334.88 4,600.22 8,000.00 57.5%
      5415200 · Operating Supplies 418.26 7,920.47 9,000.00 88.01%
      5415201 · Fuel 695.19 5,069.96 5,900.00 85.93%
      5415202 · Uniforms 0.00 2,248.41 3,000.00 74.95%
      5415300 · Road Materials/Supplies/Equip 171.54 392.52 1,000.00 39.25%
      5415500 · Training (Certification) 0.00 0.00 100.00 0.0%
    Total 5413000 · Public Works (Oper Exp) 4,260.53 36,131.23 44,518.00 81.16%
    5723000 · Parks & Recreation (Oper Exp)        
      5724300 · Utilities/Electric Expense 64.93 681.53 1,000.00 68.15%
      5724500 · Insurance (General Liability) 0.00 8,753.25 13,463.00 65.02%
      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) 64.93 9,528.01 18,463.00 51.61%
    5810000 · Interfund Transfers Out        
      5810001 · Transfer Out to Sewer Fund 19,571.22 23,421.22 100.00 23,421.22%
      5810003 · Transfer Out to Water Utility 1,400.00 4,200.00 100.00 4,200.0%
    Total 5810000 · Interfund Transfers Out 20,971.22 27,621.22 200.00 13,810.61%
  Total Expense 201,480.21 747,995.85 1,269,286.00 58.93%
Net Income   5,875.50 160,448.26 0.00 100.0%