Inlet ker 9 Established1959 Florida Schedule of Revenues and Expenditures Budget and Actual General Fund (Unaudited) Cash Balances July 31, 2024 For the Ten Months Ended. July 31, 2024 Check Register & Bank Debits For the Month EndedJ July 31, 2024 TOWN OF JUPITERI INLETCOLONY, FLORIDA Schedule of Revenues and Expenditures Budget andA Actual General Fund Fort the7 Ten Months Ended. July 31,2024 YTD Actualt to 5,575 98% 87,175 (1,033) 101% 150 (781) 621% 41,000 (127,085) 410% 51,000 50,850 0% (4) 515,861 85,977 83% 4,600 July 31,2024 Actual 7,236 6,526 710 8 (8) 5,182 2,961 2,221 74,592 121,767 47,175 150 3,255 3,105 42,988 42,988 11,466 133 133 Year Tol Date Budget Variance YTD Actual YTDI Budget YTD Variance Annl Bgt Ann Bgt Rem Ann Bgt 25,846 $ 36,823 $ (10,977) $ 2,962,293 $ 3,007,410 $ (45,117) $ 3,029,201 $ 66,908 98% 8,169 27,071 (18,902) 293,759 126,252 167,507 299,334 46,433 73,389 (26,956) 3,513,276 3,242,240 271,036 3,456,860 (56,416) 102% 101,072 145,311 44,239 1,039,994 976,979 (63,015) 1,153,363 113,369 90% 16,718 12,352 (4,366) 139,337 104,823 (34,514) 120,000 (19,337) 116% 246,986 327,354 80,368 3,101,925 2,518,747 (583,178) 3,100,886 (1,039) 100% 246,986 327,354 80,368 3,103,465 2,518,747 (584,718) 3,456,860 353,395 (200,553) $ (253,965) S 53,412 $ 409,811 $ 723,493 S (313,682) $ REVENUES Taxes Permits, Fees, & Special Assessments Intergovernmental Judgments, Fines & Forfeitures Miscellaneous) Revenue EXPENDITURES Administration Planning Police Fire Control Building Official Beautification Roads, Walkways, &E Beach Beach Erosion Surtax Expenditures 88,208 71,805 16,403 931 109 168,085 36,664 131,421 150 44,112 43,962 429,884 429,880 552,079 1,540 822 Totall Revenues 783,066 826,457 43,391 1,093,062 309,996 72% 1,548 (9,918) 157,415 132,166 (25,249) 163,000 5,585 97% 4,600 0% (552,079) 95% 0% 4,330 4,330 (552,079) Totall Expenditures Fund Balance Reserv Total Expenditures: and Fund Balance Reserve Excess (deficiency) ofr revenues over (under) expenditures andt transfers out (1,540) 355,974 354,434 (409,811) TOWN OFJ JUPITERI INLETCOLONY, FLORIDA Schedulec ofRevenues: andE Expenditures Budget andA Actual General Fund Fort the'l Ten Months! Ended. July 31,2024 YID July3 31,2024 Year ToDate Actual 1,225 1,180 45 11,812 11,594 218 13,851 2,039 537 546 (9) 5,402 5,331 71 6,385 983 1,966 1,742 224 21,286 17,607 3,679 21,089 (197) 331 (937) (937) 4,216 4,216 (4,216) 188 (188) 1,880 (1,880) 2,250 2,250 750 2,017 (1,267) 2,750 2,000 15 (15) 431 540 (109) 3,000 2,569 90 90 (90) 2,731 5,575 98.14% 572 572 (572) 1,058 838 220 10,916 7,642 3,274 11,000 84 15 (15) 150 (150) 175 175 3,279 3,247 32 34,630 34,025 605 40,000 5,370 2,899 2,426 473 33,575 29,988 3,587 36,000 2,425 7,860 7,860 (7,860) 655 655 (655) 7,236 6,526 (8) 881 109 772 150 (731) 50 50 (S0) (8) 931 109 822 150 (781) 620.674 1,094 1,094 (1,094) 221 2,000 3,100 3,100 (3,100) 117,839 117,839 (117,839) 2,870 999 1,871 1,000 (1,870) Annual Annual Budget Actualto Budget Variance YTDA Actual YTDB Budget YTDVariance Budget Remaining Ann! Bgt 22,118 $ 33,355 $ (11,237) $ 2,923,793 $ 2,972,878 $ (49,085) $ 2,987,876 $ 64,083 25,846 36823 (10,977) 2,962,293 3,007,410 (45,117) 3,029,201 66,908 97.7994 9,566 23,159 (13,593) 249,669 94,140 155,529 250,000 (460) 3,709 (4,169) 38,603 27,675 10,928 41,334 8,169 27,071 (18,902) 293,759 126,252 167,507 299,334 REVENUES Taxes AdValorem Taxes Local Optional Fuel7 Tax NewL Local OptionalG GasT Tax Communications: Services Tax Totall Taxes Permits, Fees, &s Special Assessments Building Permits Bldgp permit surcharge fee BidgP Permit Surcharge! Retainage Licenses (Registrations)- JIC County Rev Sharing! Business Tax MiscP Permits(Fors Sale, Yards Sale, etc..) Franchise! Fees FP&L Totall Permits, Fees, & SpecialA Assessments Intergovernmental Bullet ProofV Vest Program StateR Revenue Sharing Program DistA Alcoholic BevL LicenseF Fees Local Govemml/2 Cents Sales Tax Disc.I Infrastructures Sales Tax JLONAI Detail JLONAI Detail-Admin Fee Totall Intergovermental Judgments, Fines &E Forfeitures Fines& & Forfeitures Other Charges TotalJ Judgments, Fines & Forfeitures Miscellaneous! Revenue Reimbursements Interest Income Beach Clubs Security Detail Proceedsf froms Saleo ofCapitalA Assets Miscellaneous Reimbursements TotalN Miscellaneous Revenue Total Revenues 710 88.208 71,805 16,403 87,175 (1,033) 101.189 3,182 2,961 2,000 43,182 35,665 7,517 40,000 (3,182) 5,182 2,961 2,221 168,085 36,664 131,421 41,000 (127,085) 409.9694 46,433 $ 73,389 S (26,956) $3,513,276 s 3,242,240 s 271,036 $3,456,860 $ (56,416 101.6394 TOWN OFJ JUPITERI INLETO COLONY,FLORIDA Scheduleo ofR Revenues and Expenditures Budgeta andA Actual General Fund Fort the TenN Ended. July 31,2024 July3 31,2024 Actual 12,500 12,500 50,000 50,000 75,000 75,000 4,278 4,585 307 49,316 48,673 (643) 57,845 8,529 3,829 4,104 275 43,924 43,566 (358) 51,771 7,847 1,733 1,733 20,800 17,330 (3,470) 20,800 481 538 57 5,526 5,969 443 6,505 979 327 305 (22) 3,395 3,354 (41) 3,961 566 293 340 47 3,738 3,742 4 4,425 687 2,747 2,482 (265) 5,193 7,723 2,530 10,204 5,011 1,869 1,703 (166) 3,532 5,109 1,577 6,941 3,409 1,673 636 (1,037) 3,161 5,224 2,063 6,213 3,052 6,163 6,332 169 63,206 60,534 (2,672) 73,200 9,994 432 1,802 1,370 7,059 4,437 (2,622) 5,610 (1,449) 2,048 5,061 3,013 15,928 24,000 8,072 24,000 8,072 24 24 240 240 283 283 208 208 2,080 2,080 2,500 2,500 9,140 35,575 26,435 84,419 67,126 (17,293) 120,000 35,581 154 (154) 617 3,000 2,383 3,000 2,383 591 4,849 4,258 10,384 14,998 4,614 20,000 9,616 2,500 9,474 6,974 14,000 11,500 6,250 6,334 84 58,000 48,237 (9,763) 65,000 7,000 1,256 1,428 172 12,529 15,050 2,521 18,000 5,471 1,420 567 (853) 12,869 11,119 (1,750) 12,500 (369) 19,764 10,636 (9,128) 99,667 95,724 (3,943) 117,000 17,333 1,530 1,765 235 29,209 16,551 (12,658) 25,000 (4,209) 79 1,914 1,835 3,952 5,501 1,549 6,360 2,408 380 776 396 4,396 4,523 127 5,500 1,104 395 395 669 1,462 793 2,100 1,431 559 559 1,000 1,000 713 654 (59) 7,126 7,193 67 8,500 1,374 831 1,145 314 8,313 12,715 4,402 15,000 6,687 42 42 420 420 500 500 1,056 2,500 1,444 2,500 1,444 72 209 137 7,505 251 (7,254) 750 (6,755) 1,067 2,000 (19,807) 71 71 710 710 850 850 231 231 2,334 3,434 1,100 5,000 2,666 640 640 4,267 656 (3,611) 1,000 (3,267) YID VearToDate Annual Annual Budget Actualto Budget Variance YTD/ Actual YTDE Budget YTDVariance Budget Remaining Ann Bgt_ 6,290 $ 6,687 $ 397 $ 72,239 $ 71,656 $ (583) $ 85,031 $ 12,792 EXPENDITURES Administration Salary Admin. Officer Salary Town! Manager Payroll Town Clerk Salary Admin. Secretary CodeE Enforcement Ofticer Payroll Taxes Admin. Ofncer Payroll TaxesA Admin. Secy. PR1 Taxes Town Clerk Retirement Retirement Town Clerk Retirement- Admin. Secy Heaith Dental STD, Life, Accident Workers Comp. Codification Inspections. Building Legal Legal Advertisements Professional Services- Other Professional Services- Auditor Professional Services- Finance Professional Services- ADPHR Custodian/Pest Control Refuse/Recycling Collection Code Enforcement Talphomelatema/Wehaie Utilities (Electric) Copy! Machine PostageN Meter Miscellaneous Equip. Rentals Liability Insurance Property &F Flood Notary Insurance Equipment &F Repairs Other Maintenance Building Maintenance Propane Gas/Generator Maint Memberships Travel Misc. 156 (911) 21,807 1,832 (19,975) 3,935 10,714 6,779 20,000 16,065 TOWN OFJ JUPITERI INLETO COLONY,FLORIDA Schedule ofRevenues and Expenditures Budgeta andA Actual General Fund FortheT TenM EndedJ July3 31,2024 July3 31,2024 Year ToDate Annual Annual Budget Actualto Actual 858 $ 15,000 $ 14,142 $ 15,000 $ 14,142 462 1,248 4,664 3,416 5,000 3,752 915 1,289 374 14,191 8,004 (6,187) 9,000 (5,191) 83 830 830 1,000 1,000 833 833 555 8,330 7,775 10,000 9,445 14,715 15,000 285 15,000 285 42,733 42,404 (329) 85,509 42,776 967 3,180 2,213 5,412 4,445 63 63 630 630 750 750 340 340 15,021 14,349 (672) 15,000 (21) 3,345 2,681 (664) 3,000 (345) 150 150 1,500 1,500 1,800 1,800 1,250 1,250 12,500 12,500 15,000 15,000 16,862 1,299 (15,563) 1,300 (15,562) 275 275 2,750 2,750 3,300 3,300 595 595 5,950 5,950 7,142 7,142 150 1,171 1,021 150 23,272 23,122 26,000 25,850 417 417 4,170 4,170 5,000 5,000 1,667 1,667 16,670 16,670 20,000 20,000 150 3,255 3,105 150 44,112 43,962 51,000 50,850 0.2995 YTD Budget Variance YTD Actual YTDE Budget YTDY Variance Budget Remaining AnnE Bgt EXPENDITURES (continued) Administration (continued) Municipal Election Offices Supplies Officel EquipmentSoflware Officel Fumiture Training AndA Auto Mileage Capital Outlay Principal Payment InterestE Expendirures AidTo Private Organizations Social Committee Inlet/Outlet Directory Contingency Bank Charges NRPA Assessment Underground/ Annual/ Assessment Total Administration Planning Npdes( (Agrmt8 & Consult) Comprehensive! Planning Engineer TotalF Planning 74,592 121,767 47,175 783,066 826,457 43,391 1,093,062 309,996 71.6494 TOWN OFJ JUPITERI INLET COLONY, ofR Revenuesa andE Expenditures Budgeta andA Actual General Fund Fort the Ten Months Ended. July3 31,2024 July3 31,2024 Actual 474 1,367 482 2,595 2,087 1,900 2,061 161 3,875 3,875 1,951 2,496 238 289 51 269 695 426 868 1,490 622 1,170 1,170 980 295 (685) 3,133 4,000 429 1,915 1,486 11,776 8,877 (2,899) 11,000 2,728 1,965 (763) 14,244 15,337 1,093 20,000 4,634 1,839 (2,795) 2,164 14,615 12,451 YTD Year ToDate 617 Annual Annual Budget Actualto Budget Variance YTDA Actual YTDE Budget YTDVariance Budget Remaining AmnBgt 17,642 $ 16,671 $ (971) $ 181,641 $ 199,598 $ 17,957 $ 235,006 $ 53,365 77.29% 20,804 27,814 7,010 342,447 305,952 (36,495) 361,576 19,129 94.71% 1,611 3,130 1,519 29,192 20,568 (8,624) 27,661 19,459 16312 (3,147) 28,940 60,888 31,948 71,590 42,650 40.42% 8,339 7,166 (1,173) 73,574 53,423 (20,151) 62,004 (11,570) 118.66% 8,194 7,891 (303) 81,944 79,931 (2,013) 95,000 13,056 86.26% EXPENDITURES (continued) Police Salaries Salaries-F -Patroi, Traffic Enf. &1 Investigate Salaries-E Emergencyl Detail Salaryl Incentive Payroll Taxes Patrol Payroll TaxesF Police Admin. Retirement Health Dental STD, Life. Accident Worker'sComp. Dispatch Professional Services Telephone/Iintemet Liability! Insurance Autol Insurance AutoR Repairs &1 Maint. Gas&Oil Equip. Repair & Maint. Memberships PS Miscellaneous Ammo, Uniforms, Dues Computer! Maintenance Training Publics Safety Capital Outlay General Equipment Security Cameras Total Police (617) (617) 100,00% 145 98.43% (1,531) 105,53% 5,694 68.33% 13,538 13.22% 4,881 79.84% 5,998 76.01% 7,750 83.33% 3,500 0.00% 72 99.52% 1,125 67.86% 7,788 64.60% (2,129) 185.16% (998) 128.51% 867 78.33% (776) 107.05% 5,756 71.22% 7,073 55.79% 3,803 4.93% 6,512 56.59% 712 238 9,095 7,817 (1,278) 9,240 (1,367) 12,284 17,583 5,299 17,978 (482) 2,062 15,599 13,537 15,600 (508) 19,327 24,207 4,880 24,208 19,002 20,877 1,875 25,000 38,750 38,750 46,500 586 586 3,500 545 14,928 13,357 (1,571) 15,000 2,375 2,927 552 3,500 8,190 6,779 (1,411) 7,000 (1,190) 117.00% 14,212 17,904 3,692 22,000 4,629 2,123 (2,506) 2,500 4,498 2,011 (2,487) 3,500 867 4,000 8,927 11,073 2,146 16,000 197 881 684 4,000 8,488 15,000 6,512 15,000 30,823 30,823 104,985 30,931 (74,054) 35,000 (69,985) 299.96% 101,072 145,311 44,239 1,039,994 976,979 (63,015) 1,153,363 113,369 90.17% TOWN OFJ JUPITER INLET COLONY, Scheduleo ofR Revenuesa and Expenditures Budgeta and Actual General Fund Fort the'l TenN Months Ended. July3 31,2024 July31,2024 Actual 42,988 42,988 42,988 42,988 5,246 760 833 73 2,658 3,094 308 308 2,701 YID VearT ToDate Budget Variance YTDA Actual YTDE Budget YTDVariance Budget Remaining Ann Bgt 429,884 429,880 429,884 429,880 5,460 $ 298 $ (5,162) $ 74,458 $ 41,666 $ (32,792) $ 70,000 $ (4,458) (5,246) 57,813 78,000 20,187 78,000 20,187 7,410 8,330 417 417 17,734 4,170 (13,564) 5,000 (12,734) 11,466 1,548 (9,918) 157,415 132,166 (25,249) 163,000 436 20,666 17,458 (3,208) 24,000 3,772 5,015 1,243 27,015 45,510 18,495 49,950 22,935 2,415 3,080 194 (2,507) 27,090 2,766 (24,324) 5,400 4,501 1,821 (2,680) 32,604 19,360 (13,244) 21,000 (11,604) 3,086 1,920 (1,166) 24,147 16,649 (7,498) 18,350 (5,797) 16,718 12,352 (4,366) 139,337 104,823 (34,514) 120,000 (19,337) 116119 Annual Annual Budget Actualto 515,861 85,977 e 515,861 85,977 83.339 Fire Control Tequestal Fire-Rescue Total Fire Control EXPENDITURES (continued) Building Official Zoning Consultants Services Building Official Services PlanR Reviews Engineer! PlanR Review Total Building Official Beautification Utilities (Water) Maintenance- Other Reparylmprovements LandscapeN Maintenance Benches FowaSin.TesMua: Other Expenses Total Roads, Walkways, & Beach Walkways Repair Repairllandcapelsigs Drains Cleaning TotalF Roads & Walkways BeachE Erosion BeachE Erosion Cost Total Beach Erosion) Expenditures Surtax Expenditures Capital Outlay- Surtax Vehicles/Equipment Total Surtax Expenditures Reserves FundBalance Total FundE Reserves TotalE Expenditures: and FundE Balance! Reser_ Excess (deficiency)ofn revenues over (under)expendinures: andf fundb balance reserves_ s 920 10,000 2,590 5,585 96.579 3,334 665 3,700 1,285 3,000 (24,090) (5,400) (5,400) 500 500 600 600 830 830 1,000 1,000 3,000 3,000 3,000 3,000 4,330 4,330 4,600 4,600 0.00% (552,079) (552,079) (552,079) (552,079)L 95,00% 0.00% 50 83 133 133 552,079 552,079 1.540 1,540 (L,540). 355.974 354.434 (1,540) 355,974 354,434 246,986 327,354 80,368 3,103,465 2,518,747 (584,718) 3,456,860 353,395 89.789 (200,553) S (253,965) $ 53.412 S 409.811 s 723,493 S (313,682) (409,811) Town of] Jupiter Inlet Colony, Florida Cash Balances July31,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 Onel Penny Surtax Fund Checking Account Total Cash Int. Rate 2.35% TDI Bank 2.38% TDI Bank Purpose Balance $ 1,204,651 119,028 92,696 10,685 $ 1,427,060 $ 4,569 52,674 346,007 $ 403,250 232,607 104,746 2,167,678 Operating Reserve Debt Service Reserve Reserve 500 Colony Account 2.48% TDI Bank 5.60% FL: State Bd of Admin Reserve 2.38% TDI Bank 2.38% TDI Bank 2.38% TDI Bank 2.38% TDI Bank 2.38% TDI Bank Restricted for Debt Service Debt Service Reserve Restricted for Debt Service Restricted: for Debt Service Restricted: for Infrastructure $ $ 7 Town ofJ Jupiter Inlet Colony, Florida Check Register and Bank Debits Fort the Month Ended. July 31,2024 General Fund Checking It-Smarts SASA Cleaning Services LLC Ocean Breeze Lawn Maintenance, Inc. Rocky's Acel Hardware Mailroute, Inc. Center Park SelfStorage Combined Insurance Company Mix Net Work Source inc Emerald Gardens Pest Control TransUnion Pro-Sweep It-Smarts Ocean Breeze Lawn Maintenance, Inc. Waste Management of Martin County Puritan cleaners Center Park Self Storage Manno Uniforms Kyocera Document Solutions LLC Mailroute, Inc. GeoPoint Surveying Inc. Unlimited Auto WashClub Johnson, Anselmo, Murdoch, Burke, Piper.. The' True Pros Tequesta Tire Company, Inc. Rocky's Ace Hardware Caldwell Pacetti Edwards Schoech & Viator Rocky's Acel Hardware It-Smarts Carl's Air Conditioning & Appliance Service INC. Gannett Florida Localiq Verizon Wireless SASA Cleaning ServicesI LLC Ocean Breeze! Lawn Maintenance, Inc. It-Smarts Emilio Rodriguez Team Plan Inc Diversifield Building Department Richard Hartley, CPA TDI Bank franciso's Irrigation City of Palm Beach Gardens Dan Kerr CML pressure washing services Village ofTequesta Florida Power and Light Franchise Payment Ocean Breeze Lawn Maintenance, Inc. Date 07/01/2024 07/01/2024 07/01/2024 07/01/2024 07/01/2024 07/01/2024 07/02/2024 07/02/2024 07/02/2024 07/02/2024 07/02/2024 07/02/2024 07/02/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/10/2024 07/11/2024 07/12/2024 07/12/2024 07/15/2024 07/15/2024 07/15/2024 07/15/2024 07/16/2024 07/16/2024 07/16/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 Check Number/Ref.: # 10800 10801 10802 10803 10804 10805 10807 10808 10809 10810 10811 10813 10814 10817 10818 10819 10820 10821 10822 10823 10824 10825 10826 10827 10828 10829 10830 10831 10832 10833 10834 10835 10836 10837 10838 10839 10840 10841 10842 10843 10844 10845 10846 10847 10848 10849 Vendor Amount $ 2,195.00 300.00 3,620.00 28.99 84.00 305.00 4,185.88 42.95 670.00 75.00 926.00 263.00 2,000.00 19,763.52 398.19 305.00 31.07 210.42 84.00 760.00 179.85 1,890.00 243.00 88.97 119.99 7,250.00 68.72 661.50 185.00 154.18 37.87 250.00 4,995.00 483.50 980.00 5,459.80 5,246.25 6,250.00 9,243.54 265.00 11,451.00 465.50 1,200.00 2,152.46 459.76 1,795.00 8 Town of. Jupiter Inlet Colony, Florida Check Register and Bank Debits For thel Month Ended. July 31,2024 General Fund Checking (continued) The Police and Sheriffs Press wells Fargo Vendor Financial Services,LLC Florida Power and Light Pro-Sweep It-Smarts Loxahatchee River District Comcast Verizon Wireless Palm Beach County Property Appraiser Gurdian Hawk Security Nozzle Nolen, Inc. Carl's Air Conditioning &. Appliance Service INC. Ivelisse Chico-Randazzo Florida Blue 3 SASA Cleaning Services LLC King Tree Service Kimley! Horn AT&T2 Pro-Sweep Ocean Breeze Lawn Maintenance, Inc. Florida Blue Ins. Florida Department of B&PR Date 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/23/2024 07/24/2024 07/24/2024 07/24/2024 07/24/2024 07/25/2024 07/29/2024 07/29/2024 07/29/2024 07/29/2024 07/29/2024 07/29/2024 07/29/2024 07/01/2024 07/01/2024 07/03/2024 07/11/2024 07/18/2024 Check Number/Ref. # 10850 10851 10852 10853 10854 10855 10856 10857 10858 10859 10861 10862 10863 10864 10865 10866 10867 10868 10869 10870 ACH Debit ACH Debit Vendor Amount $ 17.60 169.92 79.05 75.00 218.00 240.18 1,092.86 1,538.77 150.00 2,164.49 170.00 185.00 670.77 963.44 200.00 72.00 590.63 422.06 75.00 450.00 14,502.07 937.01 255.96 297.40 314.44 $ 123,675.56 D-44595-070324 Davison Fuels & Oill LLC D-45343-071124 Davison Fuels & Oill LLC D-46224-071824 Davison Fuels & Oill LLC Total Disbursements- General Fund Checking 9 Town of Jupiter Inlet Colony, Florida Check Register and Bank Debits Fort the Month Ended. July 31,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