Inlet Ertablshed1959 Florida Schedule of Revenues and Expenditures Budget and Actual General Fund (Unaudited) Cash Balances January 31, 2024 Check Register & Bank Debits For the Month Ended.January 31, 2024 For the Four Months Ended. January 31, 2024 TOWN OF. JUPITER INLET COLONY, FLORIDA Schedule ofR Revenues and Expenditures Budget and Actual General Fund For the Four Months Ended. January 31, 2024 YTD Actual to 87,175 53,496 39% 150 (147) 198% 41,000 17,328 58% 51,000 46,901 8% (2) 515,861 343,907 33% 163,000 121,325 26% 4,600 January31,2024 Actual 7,266 9,945 (2,679) 8,740 7,265 1,475 22 13 9 11,855 3,416 8,439 1,076 4,251 3,175 42,988 42,988 12,388 13,583 1,195 383 Year Tol Date 33,679 29,060 297 23,672 13,664 10,008 4,099 17,004 12,905 171,954 171,952 41,675 54,332 12,657 1,532 Budget Variance YTD Actual YTD Budget YTD Variance Ann Bgt Ann Bgt Rem Ann Bgt 52,731 $ 52,433 S 298 $ 2,508,895 $ 2,409,732 $ 99,163 $ 3,029,201 $ 520,306 83% 80,614 73,072 7,542 2,629,521 2,537,288 92,233 3,456,860 827,339 76% 79,376 68,845 (10,531) 338,517 337,380 (1,137) 1,093,062 754,545 31% 100,108 87,913 (12,195) 391,064 408,044 16,980 1,153,363 762,299 34% 12,891 10,000 (2,891) 61,577 40,000 (21,577) 120,000 58,423 51% 248,827 227,963 (20,864) 1,008,886 1,030,244 21,358 3,100,886 2,092,000 33% 248,827 227,963 (20,864) 1,008,886 1,030,244 21,358 3,456,860 2,447,974 (168,213) s (154,891) s (13,322) S 1,620,635 s 1,507,044 s 113,591 $ REVENUES Taxes Permits, Fees, & Special Assessments Intergovermmental Judgments, Fines & Forfeitures Miscellancous Revenue EXPENDITURES Administration Planning Police Fire Control Building Official Beautification Roads & Walkways Surtax Expenditures 62,978 84,780 (21,802) 299,334 236,356 21% 4,619 52 245 Totall Revenues 383 1,532 4,600 0% 0% Total Expenditures Fund Balance Reserv_ 355,974 355,974 Total Expenditures and Fund Balance Reserve Excess (deficieney)ofreveaues over (under) expenditures andt transfers out $(1,620,635) TOWN OFJ JUPITERI INLET COLONY, FLORIDA Schedule ofRevenues: and Expenditures Budget and Actual General Fund Fort the Four Months Ended. January 31,2024 YID January 31,2024 Year ToDate Actual $ 864 1,154 (290) 4,650 4,616 34 13,851 9,201 412 532 (120) 2,135 2,128 7 6,385 4,250 1,977 1,757 220 7,746 7,028 718 21,089 13,343 52,731 52,433 77 77 186 186 (186) 188 (188) 752 (752) 2,250 2,250 30 30 30 30 (30) 229 (229) 100 916 (816) 2,750 2,650 57 250 (193) 269 1,000 (731) 3,000 2,731 4,114 3,445 1,084 917 167 4,337 3,668 669 11,000 6,663 15 (15) 60 (60) 175 175 3,498 3,333 165 13,167 13,332 (165) 40,000 26,833 80 36,000 23,920 1,300 1,300 4,095 4,095 (4,095), 22 13 9 247 52 195 150 (97) 50 50 (S0) 22 13 297 52 245 150 (147)198.0094 3,359 3,359 (3,359) 5,790 3,333 2,457 15,342 13,332 2,010 40,000 24,658 (1,094) (1,094) 1,094 400 400 400 400 (400) 4,500 4,500 4,500 4,500 (4,500) 1,165 83 1,082 1,165 332 833 1,000 (165), 17,328 57.749 Annual Annual Budget Actunito Budget Variance YTDActual YTDE Budget YTD Variance Budget Remaining AmnBgt 49,478 $ 48,990 $ 488 2,494,364 $ 2,395,960 $ 98,404 $ 2,987,876 $ 493,512 REVENUES Taxes AdValorem Taxes Local Optional! Fuel Tax Newl Local Optional GasT Tax Communications Services Tax Total Taxes Permits, Fees, & Special Assessments Building! Permits Bldg permit surcharge fee Bldg Permit Surcharge! Retainage MiscF Permits(For Sale, Yards Sale. etc.) Licenses (Registrations): JC Countyl Revs Sharing Business Tax Franchise Foes FP&L Total Permits, Fees, & Special Assessments Intergoveramental State Revenue Sharing Program DistA Alcoholic BevL LicenseF Fees Local Governml/2 Cents Sales Tax Disc. Infrastructure Sales Tax JLONAI Detail Totall Intergovernmental Judgments, Fines & Forfeitures Fines &F Forfitures Other Charges Total Judgments, Fines &1 Forfeitures Miscellaneous! Reveaue Reimbursements Interest Income Garden Club Donations Beach Club Security Detail Proceeds from Saleo ofCapital Assets Misceilancous) Reimbursements Total Miscellaneous! Revenue Total Revenues 298 2,508,895 2,409,732 99,163 3,029,201 520,306 82829 2,988 5,833 (2,845) 42,468 68,332 (25,864) 250,000 207,532 669 19,925 13,780 6,145 41,334 21,409 7,266 9,945 (2.679) 62,978 84,780 (21,802) 299,334 236,35621.049 2,858 3,000 (142) 12,080 12,000 8,740 7,265 1,475 33,679 29,060 4,619 87,175 53,496 38.63% 11,855 3,416 8,439 23,672 13,664 10,008 41,000 80,614 $ 73,072 $ 7,542 $2,629,521 $ 2,537,288 $ 92,233 3,456,860 s 827,339 76.079 TOWN OFJ JUPITERI INLET COLONY,FLORIDA Schedulec ofRevenues andE Expenditures Budget andA Actual General Fund Fort thel Four Months Ended. January 31, 2024 YTD January3 31,2 2024 Annual AnnualE Budget Actualto Actual 75,000 75,000 4,450 4,820 370 37,280 3,982 4,314 332 (936) 51,771 33,579 1,733 1,733 10,400 500 542 42 6,505 4,212 305 330 25 (72) 3,961 2,569 340 369 29 (97) 4,425 2,852 2,445 850 (1,595) 955 10,204 7,759 1,664 578 (1,086) 648 6,941 5,277 1,489 518 (971) 583 6,213 4,724 5,535 6,100 565 1,487 5,610 3,373 2,924 2,000 (924) 24 24 96 96 283 283 208 208 832 832 2,500 2,500 250 250 1,000 1,000 3,000 3,000 2,648 1,667 (981) 4,823 6,668 1,845 20,000 15,177 14,000 14,000 65,000 46,700 1,219 1,500 281 4,960 6,000 1,040 18,000 13,040 1,042 1,042 1,797 4,168 2,371 12,500 10,703 77,364 9,084 339 530 191 2,335 2,120 (215) 6,360 4,025 886 458 (428) 2,428 1,832 (596) 5,500 3,072 82 175 93 356 700 344 2,100 1,744 83 83 332 332 1,000 1,000 713 708 (5) 2,850 2,832 (18) 8,500 5,650 831 1,250 419 3,325 5,000 1,675 15,000 11,675 42 42 168 168 500 500 83 208 125 490 832 342 2,500 2,010 63 63 4,240 252 (3,988) 750 (3,490) 610 167 (443) 6,272 668 (5,604) 2,000 (4,272) 71 71 284 284 850 850 140 417 277 1,789 1,668 (121) 5,000 3,211 83 83 332 332 1,000 1,000 1,667 1,667 YearToDate Budget Variance YTDA Actual YTDE Budget YTDY Variance Budget Remaining Annl Bgt 6,541 $ 7,086 $ 545 29,975 $ 28,344 $ (1,631) $ 85,031 $ 55,056 EXPENDITURES Administration Salary Admin. Officer Salary Town Manager Payroll Town Clerk Salary Admin. Secretary Codel Enforcement Officer Payroll1 Taxes Admin. Officer Payroll Taxes Admin. Secy. PR1 Taxes Town Clerk Retirement Retirement Town Clerk Retirement- Admin. Secy Health Dental STD, Life, Accident Workers Comp. Codification Inspections- Building Legal Legal Advertisments Professional Services- Other Professional Services- Auditor Professional Services- Finance Professional Services- ADPI HR Custodian/Pest Control RefuseRecycling Collection CodeE Enforcement Telphomelnema/Wehaie Utilities (Electric) Copy Machine Postage! Meter Miscellaneous! Equip. Rentals Liability Insurance Property &F Flood Notary Insurance Equipment&R Repairs Other Maintenance Building Maintenance Propane Gas/Generator) Maint Memberships Travel Misc. Government 20,565 19,280 (1.285) 57,845 18,192 17,256 10,400 6,932 (3,468) 20,800 2,293 2,168 (125) 1,392 1,320 1,573 1,476 2,445 3,400 1,664 2,312 1,489 2,072 30,716 24,400 (6,316) 73,200 42,484 2,402 8,000 5,598 24,000 21,598 468 (1,019) 2,237 1,872 (365) 7,149 5,000 (2,149) 58,956 60,000 1,044 120,000 61,044 6,900 5,417 (1,483) 18,300 21,668 3,368 10,021 9,750 (271) 39,636 39,000 (636) 117,000 9,168 2,083 (7,085) 15,916 8,332 (7,584) 25,000 8,723 6,668 (2,055) 20,000 11,277 TOWN OF JUPITER INLET COLONY, FLORIDA ScheduleofRevenues and Expenditures Budget and Actual General Fund Forthel Four Months Ended. January 31,2024 January 31,2024 YearToDate Annual Annual Budget Actualto YID Actual 1,250 $ 1,250 $ 5,000 $ 5,000 $ 15,000 $ 417 321 239 1,668 1,429 5,000 15,000 178 750 572 5,682 3,000 (2,682) 9,000 4,761 83 83 332 332 1,000 3,318 1,000 833 833 555 3,332 2,777 10,000 14,715 15,000 285 15,000 9,445 285 * 85,509 85,509 63 252 5,412 5,412. 250 (190) 6,236 8,000 252 750 750 250 (1,095) 2,145 1,000 (1,145) 1,764 15,000 3,000 8,764 150 150 600 600 1,800 855 1,250 1,250 5,000 5,000 15,000 1,800 108 (4,758) 4,866 432 15,000 275 275 1,100 (4,434) 1,100 1,300 3,300 (3,566) 595 595 1,540 2,380 840 7,142 3,300 1,076 2,167 1,091 4,099 8,668 4,569 26,000 417 417 1,668 1,668 5,000 21,901 1,667 1,667 6,668 5,000 1,076 4,251 3,175 4,099 17,004 12,905 6,668 51,000 20,000 46,901 20,000 8.049 EXPENDITURES (continued) Administration (continued) Municipal Office Election Supplies Office EqupmenuSoflware Office Fumiture Training AndA AutoN Mileage Capital Outlay Principal Payment Interest Expenditures AidT ToF Private Organizations Social Committee Inlev/Outlet Directory Contingency Bank Charges NRPA Assessment Underground Annual Assessment Total Administration Planning Npdes (Agri& Consult) Comprchensive! Planning Engincer Total Planning Budget Variance YTDA Actual YTDE Badget YTD Variance Budget Remaining AmBR 1,345 4,866 79,376 68,845 (10,531) 338,517 337,380 (1,137) 1,093,062 754,54530974 5,602 TOWN OF. JUPITERI INLET COLONY, FLORIDA Schedulec ofRevenues and Expenditures Budget and Actual General Fund Fort theF Four Months Ended. January 31,2024 YID January 31,2024 Annual Annual Budget Actualto Actual Ann Bgt 877 770 (107) 3,891 3,080 (811) 9,240 207,353 42.65% 2,913 2,305 (608) 14,156 9,220 (4,936) 27,661 5,349 42.11% 800 1,498 698 3,636 5,992 2,356 17,978 13,505 51.18% 9,481 5,966 (3,515) 9,481 23,864 14,383 71,590 14,342 20.22% 517 1,300 783 1,581 5,200 3,619 15,600 23,798 14,019 61.62% 10.13% 4,088 2,017 (2,071) 4,088 8,068 3,980 24,208 1,900 2,083 183 7,601 8,332 731 25,000 20,120 16.89% 3,875 3,875 13,567 15,500 1,933 46,500 17,399 30.40% 292 292 1,168 1,168 3,500 32,933 3,500 29.18% 0.00% 44.91% 8,194 7,917 (277) 32,778 31,668 (1,110) 95,000 8,264 238 292 54 950 1,168 218 3,500 62,222 34.50% 16 583 567 1,110 2,332 1,222 7,000 2,550 27.14% 1,709 1,833 124 5,540 7,332 1,792 22,000 5,890 15.86% 1,125 208 (917) 2,310 832 (1,478) 2,500 16,460 25.18% 75 292 217 2,244 1,168 (1,076) 3,500 190 92.40% 333 333 915 1,332 417 4,000 1,256 64.11% 1,745 917 (828) 3,011 3,664 653 11,000 3,085 22.88% 1,227 1,667 440 5,336 6,668 1,332 20,000 14,664 7,989 27.37% 499 1,333 834 499 5,332 4,833 16,000 26.68% 2,917 2,917 11,664 11,664 35,000 15,501 3.12% 333 333 1,332 1,332 4,000 35,000 4,000 0.00% 0.00% 2,164 1,250 (914) 4,159 5,000 841 15,000 Year ToDate Budget Variance YTDActual YTDI Budget YTDVariance Budget Remaining 16,301 $ 16,384 $ 83 $ 74,456 $ 71,936 $ (2,520) $ 235,006 $ 160,550 31.68% 31,358 25,131 (6,227) 154,223 150,524 (3,699) 361,576 8,548 5,167 (3,381) 38,206 20,668 (17,538) 62,004 62,109 13.24% EXPENDITURES (continued) Police Salaries Salaries-E Patrol, Trafficl Enf. & Investagate Salary Incentive Payroll1 Taxes Patro! Payroll7 Taxes Police Admin. Retirement Health Dental SID, Life, Accident Worker's Comp. Dispatch Professionals Services Telephone/lntemet Liabilityl Insurance Autol Insurance AutoR Repairs & Maint Gas& Oil Equip. Repair & Maint. Memberships PS Miscellancous Ammo, Uniforms, Dues Computer Maintenance Training Publics Safety Capital Outlay General Equipment Security Cameras Total Police 2,393 1,250 (1,143) 6,736 5,000 (1,736) 15,000 100,108 87,913 (12,195) 391,064 408,044 16,980 1,153,363 762,79933.914 10,841 27.73% TOWN OF JUPITERI INLET COLONY,FLORIDA Schedule ofRevenues and Expenditures Budget and Actual General Fund Fort theF Four Months Ended. January 31,2024 Janugry 31,2024 Actual 42,988 42,988 42,988 42,988 YID YearToDate 171,954 171,952 171,954 171.952 7,585 26,000 18,415 1,900 3,332 1,432 1,668 1,668 9,310 8,000 (1,310) 24,000 15,540 16,652 1,112 1,232 1,232 9,641 1,000 (8,641) Annual Annuall Budget Actualto (2) 515,861 343,907 (2) 515,861 343,907 33.33% 78,000 70,415 10,000 8,100 5,000 5,000 14,690 49,950 34,410 3,700 3,700 3,000 (6,641) 4,932 7,332 58,2351.319 600 1,000 3,000 4,600 0.00% 0.00% Budget Variance YTD/ Actual YTDE Budget YTDV Variance Budget Remaining AmnBgt Fire Control Tequesta Fire-Rescue Total Fire Control EXPENDITURES (continued) Building Officia! Zoning Consultant Services Building Officials Services Plan Reviews Engineer Plan Review Totall Building Official Beautification Utilities (Water) Maintenance- Other Repain/mprovemens Landscapel Maintenance Park Improvements FsaSan.aIesMue Other Expenses Total Beautification Roads & Walkways Walkways Repair Repin/ardsapeSigs Drains Cleaning Other Total Roads & Walkways Surtax Expenditures CapitalOutlay- -Surtax VehiclesEquipment Total Surtax Expenditures Reserves FundBalance Total FundE Balance Reserves Totall Expenditures and Fund Reserve_ Excess (deficiency) ofrevenues over (under) expenditures and fund balance reserves 6,860 $ 5,833 $ (1,027) $ 21,529 $ 23,332 $ 1,803 $ 70,000 $ 48,471 12,388 13,583 1,195 41,675 54,332 12,657 163,000 121,37525.574 6,500 6,500 833 833 417 417 2,300 2,000 (300) 2,118 4,163 2,045 308 308 2,224 250 (1.974) 3,707 1,750 (1.957) 16,068 7,000 (9,068) 21,000 2,542 1,529 (1.013) 11,018 6,116 (4.902) 18,350 12,891 10,000 (2.891) 61,577 40,000 (21,577) 120,000 50 50 83 83 250 250 383 383 200 200 332 332 1,000 1,000 1,532 1,532 600 1,000 3,000 4,600 355,974 355,974 355,974 355,974 s (1,620,635) 248,827 227,963 (20,864) 1,008,886 1,030,244 21,358 3,456,860 2,447,974 29.199 (168,213) s (154.891) $ (13,322) $1,620,635 $ 1,507,044 s 113.591 Town of Jupiter Inlet Colony, Florida Cash Balances January31,2024 Bank Account General Fund Checking Account Money Market Account Prime Account Sewer Project Fund Checking Account Reserve Account Assessment Account Underground Project Fund Checking Account One Penny Surtax Fund Checking Account Total Cash Int. Rate 2.35% TDI Bank 2.38% TDI Bank Purpose Balance $ 2,556,400 117,648 91,759 10,585 $ 2,776,392 $ 4,525 52,163 819,145 $ 875,833 $ 97,904 85,107 3,835,259 Operating Reserve Debt Service Reserve Reserve 50 Colony Account 2.48% TDI Bank 5.60% FL: State Bd of Admin Reserve 2.38% TDI Bank 2.38% TD Bank 2.38% TDI Bank 2.38% TDI Bank 2.38% TD Bank Restricted for Debt Service Debt Service Reserve Restricted for Debt Service Restricted for Debt Service Restricted for Infrastructure $ 7 Town of. Jupiter Inlet Colony, Florida Check Register and Bank Debits Fort the Month Ended. January 31,2024 General Fund Checking Florida Blue 3 Earl E. Griffith, Ph.D. AT&T2 It-Smarts Rocky's Ace Hardware The Police and Sheriffs Press Diversifield Building Department Manno Uniforms J.R. Manno Uniforms & Police Equip Kimley Horn Waste Management ofl Martin County Ocean Breeze Lawn Maintenance, Inc. U.S. Bank Equipment Finance Kyocera Document Solutions LLC Shred-it Usa TransUnion Alert Media It-Smarts Richard Hartley, CPA Chrissy Wheaton Bruce Walther Caldwell Pacetti Edwards Schoech & Viator Manno Uniforms Pro-Sweep Tequesta' Tire Company, Inc. Combined Insurance Company Thel Police and Sheriffs Press Emerald Gardens Pest Control It-Smarts It-Smarts Dan Kerr franciso's Irrigation Mix Net Work Source inc The Police and Sheriffs Press Prime TurfManagementlec Ocean Breeze Lawn Maintenance, Inc. Strobes-R-US Mailroute, Inc. Pro-Sweep TDI Bank It-Smarts CML pressure washing services Village ofTequesta Florida Power and Light Guardinan Hawk Security Prime TurfManagementyllc Date 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/03/2024 01/04/2024 01/04/2024 01/04/2024 01/04/2024 01/04/2024 01/04/2024 01/08/2024 01/08/2024 01/08/2024 01/08/2024 01/08/2024 01/09/2024 01/10/2024 01/16/2024 01/16/2024 01/16/2024 01/16/2024 01/16/2024 01/16/2024 01/16/2024 01/16/2024 01/23/2024 01/23/2024 01/23/2024 01/23/2024 01/23/2024 01/23/2024 01/23/2024 Check Number/Ref.# 10361 10362 10363 10364 10365 10366 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 10386 10387 10388 10389 10390 10391 10392 10393 10394 10395 10396 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 Vendor Amount $ 1,033.61 285.00 352.25 93.00 52.06 5,527.50 1,222.00 42.00 2,648.13 9,881.76 2,000.00 243.65 228.51 141.65 75.00 7,192.16 356.00 6,900.00 271.80 168.30 4,825.00 33.98 926.00 15.75 6,915.00 32.60 450.00 93.00 93.00 213.76 160.00 42.97 65.20 3,180.00 4,250.00 1,125.14 75.00 75.00 4,865.71 441.00 80.00 2,139.71 339.24 2,164.49 1,080.00 8 Town of] Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended. January: 31,2024 General Fund Checking (continued) Manno Uniforms Nozzle Nolen, Inc. Date 01/23/2024 01/23/2024 01/23/2024 01/23/2024 01/23/2024 01/23/2024 01/23/2024 01/23/2024 01/23/2024 01/29/2024 01/29/2024 01/29/2024 01/29/2024 01/29/2024 01/29/2024 01/29/2024 01/29/2024 01/29/2024 01/29/2024 01/30/2024 01/30/2024 01/30/2024 01/30/2024 01/01/2024 01/02/2024 01/02/2024 01/03/2024 01/08/2024 01/10/2024 01/10/2024 01/11/2024 01/18/2024 01/24/2024 01/25/2024 01/31/2024 Check Number/Ref.# 10407 10408 10409 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 ACHI Debit ACH Debit ACHI Debit ACHI Debit ACHI Debit ACHI Debit ACHI Debit ACHI Debit ACHI Debit ACH Debit ACH Debit ACH Debit Vendor Amount $ 208.00 170.00 140.00 169.92 2,323.65 942.91 37.87 82.00 108.00 76.08 83.00 969.75 6,859.80 238.98 352.25 139.55 75.00 1,417.46 178.00 1,269.06 243.65 1,191.20 557.50 14,082.57 122.96 15,078.98 442.62 216.17 1,219.25 36,130.93 393.66 417.23 32,086.70 239.21 122.96 190,782.80 International Institute Municipal Clerks wells Fargo Vendor Financial Services,LLC Johnson, Anselmo, Murdoch, Burke, Piper.. Comcast Verizon Wireless Quadient Finance USA, Inc It-Smarts Leanna Landsmann It-Smarts Florida Blue 3 Team Plan Inc Manno Uniforms AT&T2 Shred-it Usa Pro-Sweep Verizon Wireless It-Smarts Sir Speedy U.S. Bank Equipment Finance Globalstar USA BGG electric Florida Blue Ins. Combined Insurance Florida Municipal Pension Trust Davison Fuels & Oill LLC Davison Fuels & Oill LLC ADP, Inc. ADP, Inc. Davison Fuels & Oill LLC Davison Fuels & Oil LLC ADP, Inc. Davison Fuels & Oill LLC Combined Insurance Total Disbursements- General Fund Checking 9 Town ofJ Jupiter Inlet Colony, Florida Check Register and Bank Debits Fort the Month Ended. January31,2024 Sewer Project Fund Checking Date Check Number/Ref.# Vendor Amount $ No checks issued in current month Total Disbursements- Sewer Project Fund Checking Underground Fund Checking No checks issued in current month Total Disbursements- Underground Fund Checking $ 10