Inlet C Establshed1959 Florida Schedule of Revenues and Expenditures Budget and Actual General Fund (Unaudited) Cash Balances May 31,2023 For the Eight Months Ended May 31, 2023 Check Register & Bank Debits For the Month Ended. May. 31, 2023 TOWN OF. JUPITER: INLETCOLONY, FLORIDA Schedule of Revenues and) Expenditures Budget and Actual General Fund Fort the Eight! Months Ended! May 31,2 2023 May 31,2023 Actual 11,446 12,112 9,922 6,971 2,951 69 13 56 3,965 1,501 2,464 Year Tol Date 63,794 55,768 269 41,801 12,008 29,793 Budget Variance YTDActual YTDI Budget YTD Variance Annl Bgt Ann Bgt) Rem 33,213 $ 28,443 $ 4,770 $ 2,564,414 $ 2,509,057 $ 55,357 $ 2,597,838 S 33,424 REVENUES Taxes Permits, Fees, & Special Assessments Intergovemmental Judgments, Fines &I Forfeitures Miscellaneous) Revenue EXPENDITURES Administration Planning Police Fire Control Building Official Beautification Roads & Walkways Surtax Expenditures Totall Expenditures Excess (deficiency) ofr revenues over (under) expenditures and transfers out (666) 127,821 136,396 (8,575) 449,334 321,513 8,026 165 83,652 19,858 150 (119) 18,000 (23,801) 71,000 63,987 (1) 486,661 162,220 144,000 63,352 216,000 44,353 9,371 60,000 104 Totall Revenues 58,615 49,040 9,575 2,798,099 2,713,333 84,766 3,148,974 350,875 89,595 100,580 10,985 908 134,495 148,988 14,493 40,555 40,555 16,105 17,333 24,925 24,625 41,668 25,000 (16,668) 601,263 728,886 127,623 1,007,680 406,417 772,976 844,128 71,152 1,154,262 381,286 5,917 5,009 1,228 425 425 7,013 47,336 40,323 324,441 324,440 80,648 90,833 10,185 (300) 171,647 189,169 17,522 970 3,650 68,926 60,000 (8.926) 2,680 8,401 (8,926) 348,251 363,423 15,172 2,027,884 2,288,442 260,558 3,148,974 1,121,090 (289,636) $ (314,383) $ 24,747 S 770,215 S 424,891 S 345,324 $ S (770,215) TOWN OF. JUPITERI INLET COLONY,FLORIDA Scheduleo ofRevenues: and Expenditures Budgeta andA Actual General Fund Fort thel Eight! Months Endedi May 31,2023 May 31,2023 Actual 1,396 1,154 242 613 532 81 2,038 1,757 7,428 8,000 187 187 188 (188) 10 229 (219) 31 250 (219) 3,790 3,445 11,446 12,112 979 916 63 15 (15) 4,012 3,040 972 69 13 56 69 13 56 3,965 83 3,882 417 (417) 167 (167) 417 (417) 417 (417) 3,965 1,501 2,464 Year ToDate Annual Annual Budget 9,828 9,232 596 13,851 4,023 4,455 4,256 199 6,385 1,930 281 15,888 14.056 1,832 21,089 5.201 33,424 (572) 92,902 103,500 (10,598) 400,000 307,098 1,840 1,840 (1,840) 1,504 (1,504) 2,250 2,250 218 1,832 (1,614) 2,750 2,532 334 2,000 3,000 345 32.527 27,560 (1,666) 4,967 41,334 8,807 2,666 (666) 127,821 136.396 (8.575) 449,334 321,513 7,828 7,328 500 10,994 3,166 120 (120) 175 175 28,556 24,320 4,236 36,483 7,927 8,590 19,858 269 104 165 150 (119) 269 104 165 150 (119) 10 10 (10) 30,813 664 30,149 1,000 (29,813) 8,900 3,336 5,564 5,000 (3,900) 1,336 (1,336) 2,000 2,000 1,500 1,500 (1,500) 3,336 (3,336) 5,000 5,000 578 3,336 (2.758) 5,000 4,422 Budget Variance YTD/ Actual YTDI Budget YTDVariance Budget Remaining 29,166 S 25,000 S 4,166 $ 2,534,243 $ 2,481,513 $ 52,730 $2,556,513 $ 22,270 33,213 28,443 4.770 2,564,414 2,509,057 55,357 2,597,838 REVENUES Taxes AdV Valorem Taxes Local Optional Fuel Tax NewLocal Optional Gas Tax Communications Services Tax Total Taxes Permits, Fees, & Special Assessments Building Permits Bldgp permit surchargef fee Bldg Permit Surcharge Retainage Licenses( (Registrations)- JIC County Rev Sharing Business Tax Franchise Fees FP&L Totall Permits, Fees, & Special Assessments Intergovernmental State Revenue Sharing! Program Dist Alcoholic BevL License Fees Local Goverml/2 Cent Sales Tax Disc. Infrastructure Sales Tax Totall Intergovernmental Judgments, Fines & Forfeitures Fines& Forfitures Total. Judgments, Fines & Forfeitures Miscellancous Revenue Reimbursements InterestI Income Garden ClubI Donations Donations- POA Donations- Miscellancous Proceedsf from Sale ofCapital Assets Miscellaneous Reimbursements Total Miscellaneous) Revenue Total Revenues 4.931 3,000 1,931 27,410 24,000 3,410 36,000 9.922 6.971 2.951 63,794 55,768 8,026 83,652 41,801 12,008 29,793 18,000 (23.801) 58,615 $ 49,040 S 9,575 S 2,798,099 $ 2,713,333 $ 84,766 $ 3,148,974 S 350,875 TOWN OFJ JUPITER NLETCOLONVFLORIDA Schedule of Revenues andE Expenditures Budget andA Actual GeneralF Fund Fort the Eight Months Ended! May 31,2 2023 May3 31,2023 Year Tol Date Annual Annual Budget Actual 6,418 6,647 229 36,861 39,176 2,315 55,769 18,908 5,743 5,860 117 32,987 36,480 3,493 51,624 18,637 746 823 77 4,354 4,784 430 6,870 2,516 491 556 65 2,946 3,248 302 4,666 1,720 439 518 79 2,636 2,944 308 4,119 1,483 820 820 5,164 17,740 12,576 21,016 15,852 558 558 3,090 4,464 1,374 6,692 3,602 499 499 6,915 9,493 2,578 11,492 4,577 5,535 5,449 (86) 39,958 43,592 3,634 65,388 25,430 839 618 (221) 3,274 4,944 1,670 7,416 4,142 2,313 2,141 (172) 11,042 21,128 10,086 29,689 18,647 23 23 184 184 275 275 208 208 1,664 1,664 2,500 2,500 10,650 11,000 350 26,250 40,335 14,085 55,000 28,750 198 250 52 772 2,000 1,228 3,000 2,228 5,704 6,000 296 19,054 19,000 (54) 19,000 (54) 13,500 13,500 13,500 4,600 5,417 817 38,900 43,336 4,436 65,000 26,100 1,335 1,500 165 10,442 12,000 1,558 18,000 7,558 760 1,042 282 6,685 8,336 1,651 12,500 5,815 9,432 9,167 (265) 66,024 73,669 7,645 110,333 44,309 1,667 1,833 166 13,333 14,664 1,331 22,000 8,667 2,601 2,500 (101) 17,860 17,831 (29) 23,334 5,474 479 417 (62) 3,007 3,336 329 5,000 1,993 449 417 (32) 3,434 3,336 (98) 5,000 1,566 192 192 701 1,536 835 2,300 1,599 1,180 1,500 320 5,597 9,500 3,903 9,500 3,903 736 700 (36) 5,889 5,600 (289) 8,400 2,511 42 42 336 336 500 500 208 208 11,279 13,664 2,385 14,500 3,221 42 42 1,036 336 (700) 500 (536) 130 38 (92) 130 304 174 450 320 5,717 9,200 3,483 30,293 33,202 2,909 33,866 3,573 71 71 568 568 850 850 458 458 2,561 3,664 1,103 5,500 2,939 200 200 292 7,200 6,908 7,200 6,908 7,424 8,000 576 43,630 40,003 (,627) 40,003 (3,627) 3 Budget Variance YTD/ Actual YTDE Budget YTDY Variance Budget Remaining 9,749 $ 9,830 $ 81 $ 54,503 S 57,640 S 3,137 $ 81,965 S 27,462 EXPENDITURES Administration Salary Admin. Officer Payroll7 Town Clerk Salary Admin. Secretary Payroll7 Taxes. Admin. Officer Payroll7 Taxes Admin. Secy. P/R1 Taxes7 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-E Finance Professional Services- ADPH HR Custodian/Pest Control Refuse/Recycling' Collection Code Enforcement TelgplonelatemeVebsie Utilities (Electric) Copy? Machine Postagel Meter Liability Insurance Property &E Flood Notary! Insurance Equipment8 & Repairs Miscellancous! Equip. Rentals OtherN Maintenance Building Maintenance Propane Gas/Generator) Maint Memberships Travel Misc. Government TOWNG OF. JUPITERI INLET COLONY,FLORIDA Schedule of Revenuess and Expenditures Budget andA Actaal General Fund Fort theE Eight? Months Ended! May 31,2023 May3 31,2023 Actual 708 $ 708 $ 179 417 238 35 583 548 83 83 833 833 1,667 1,667 208 208 3,696 (3,696) 350 192 (158) 150 150 83 83 42 42 275 275 595 595 908 2,167 1,259 417 417 3,333 3.333 908 5,917 5,009 Year Tol Date Annual Annuall Budget 2,778 3,336 558 5,000 8,902 10,664 1,762 13,000 664 664 1,000 6,664 6,664 10,000 189 13,336 13,147 20,000 41,407 42,755 1,348 85,509 2,294 2,706 412 5,412 1,664 1,664 2,500 17,305 15,000 (2,305) 15,000 3,385 2,536 (849) 3,300 1,200 1,200 1,800 664 664 1,000 604 336 (268) 500 2,200 2,200 3,300 4,760 4.760 7,142 7,013 17,336 10,323 26,000 3,336 3,336 5,000 26,664 26,664 40.000 40,000 7,013 47,336 40,323 71,000 Budget Variance YTDA Actual YTDI Budget YTDVariance Budget Remaining EXPENDITURES (continued) Administration (continued) Municipal Election Office Supplies Office Equipment/Soflware Office Furniture Training AndA AutoN Mileage Capital Outlay Principal Payment InterestE Expenditures AidT ToPrivate Organizations Social Committee Inlet/Outlet Directory SpecialE Events Bank Charges NRP Assessment Underground. Annual Assessment Total Adminstration Planning Npdes (Agrmta & Consult) Comprehensivel Planning Engineer Total Planning 5,664 $ 5,664 $ 8,500 $ 8,500 2,222 4,098 1,000 10,000 19,811 44,102 3,118 2,500 (2,305) (85) 1,800 1,000 (104) 3,300 7.142 18,987 5,000 63,987 89,595 100,580 10,985 601,263 728.886 127,623 1,007,680 406,417 TOWN OF JUPITER INLET COLONY,FLORIDA Schedulec of Revenues andE Expenditures Budget and Actual GeneralF Fund Fort thek Eight Months Ended May3 31,2023 May 31,2023 Year ToDate Actual 85,739 933 946 430 (516) 4,227 3,440 (787) 3,782 4,353 4,896 543 18,386 18,168 (218) 120 22,168 14,798 2,472 2,487 2,800 313 12,326 38,456 12,446 55,682 33,783 4,307 4,307 21,899 64,235 16,557 9,765 115,500 51,265 10,155 172 10,375 (172) 220 3,638 74,000 5,000 1,362 5,742 2,104 84 3,000 2,916 3,417 9,000 5,583 9,000 5,583 2,584 3,022 438 18,066 17,176 (890) 21,268 3,202 1,683 1,656 (27) 13,460 13,248 (212) 19,868 12,036 6,408 3,698 3,698 32,340 29,584 (2,756) 44,376 167 167 2,385 1,336 (1,049) 2,000 (385) 1,235 625 (610) 11,731 8,000 (,731) 10,500 (1,231) 701 (701) (701) 7,256 7,333 77 58,047 66,664 8,617 96,000 37,953 210 292 82 1,683 2,336 653 3,500 1,817 945 633 (633) 10,055 9,000 (1,055) 11,000 (216) 2,458 1,900 (558) 14,194 216 15,200 1,006 (216) 22,800 8,606 120 208 88 7,934 5,964 (1,970) 6,800 (1,134) 919 292 292 2,581 2,336 (245) 3,500 392 333 (59) 15,557 15,831 274 17,167 1,610 1,097 1,500 403 1,500 403 99 417 318 4,376 4,836 460 6,500 2,124 4,150 4,250 100 17,784 17,000 (784) 23,000 5,216 3,325 3,833 508 14,316 14,164 (152) 19,500 5,184 9,658 29,169 19,511 40,000 30,342 3,608 333 333 392 2,664 2,272 4,000 7,251 1,042 1,042 23,207 26,294 3,087 30,458 2,826 3,000 174 1.154.262 3,000 381,286 174 324.441 324,440 (I) 486,661 162,220 324.441 324,440 () 486,661 162,220 Annual Annual Budget Budget Variance YTD/ Actual YTDE Budget YTDVariance Budget Remaining 32,213 $ 35,000 $ 2,787 S 152,633 $ 161,084 S 8,451 $ 224,127 $ 71,494 56,242 58,779 2,537 229,609 237,232 7,623 315,348 5,160 EXPENDITURES (continued) Police Salaries Salaries-F Patrol, Traffic. Enf. &I Investagate Salary Incentive Payroll Taxes Patrol Payrol!1 Taxes Police Admin. Retirement Health Dental Life STD, Life, Accident Worker's Comp. Dispatch Professional Services Telephonellnternet Custodian/Pest Control Liability Insurance Autol Insurance Auto Repairs &N Maint. Utilities (Water) Gas&Oil Equip. Repair8 &1 Maint. Memberships! PS Miscellancous Offices Supplies Ammo, Uniforms, Dues Computer Maintenance Training Public Safety Capital Outlay GeneralE Equipment Security Cameras Capital Outlay- Security! Bldg TotalP Police Fire Tequesta Control Fire-Rescue Total Fire Control 134,495 148,988 14,493 772,976 844,128 71,152 40,555 40,555 40,555 40,555 TOWN OFJ JUPITERI INLET COLONY,FLORIDA Schedulec of Revenues and Expenditures Budgeta andA Actual General Fund Fort the Eight Months Ended May 31,2023 May 31, 2023 Actual 8,945 10,000 1,055 7,160 6,500 16,105 17,333 1.228 1,640 1,500 (140) 17,342 17,000 3,957 4,000 43 125 125 4,155 4,000 (155) 10,425 10,000 4,748 5,000 252 24,925 24,625 50 50 125 125 250 250 425 425 Year ToDate 33,173 36,169 2,996 (660) 45,860 42,000 (3,860) 68,000 22,140 80,648 90,833 10,185 144,000 17,466 25,000 7,534 1,000 1,000 26,142 29,000 2,858 57,546 65,000 7,454 (425) 33,356 30,500 (2,856) 35,500 19,795 21,669 1,874 25,000 (300) 171,647 189,169 17.522 216.000 Annual Annual Budget 60,000 26,827 63,352 (342) 23,000 5,658 36,000 18,534 1,500 1,500 30,000 3,858 65,000 7,454 2,144 5,205 44,353 600 600 1,500 1,500 3,000 2,030 4,271 4,271 9,371 8,401 (8.926) (8.926) S (770,215) Budget Variance YTDActual YTDB Budget YTDV Variance Budget Remaining $ 833 $ 833 S 1,615 $ 12,664 $ 11,049 $ 16,000 $ 14,385 EXPENDITURES (continued) Building Official Professional Services- Inspections Zoning Consultant Services Buidling Officials Services TotalE Building Official Beautification Utilities (Water) Maintenance- Other Repairslimprovements Landscape Maintenance Parkl Improvements FowarSlna/Tanaua Other Expenses Totall Beautification Roads & Walkways WalkwaysF Repair Repaisliardscapesigns Drains Cleaning Other Totall Roads & Walkways Surtax Expenditures Capital Outlay -Surtax Vehicles/Equipment Total Surtax Expenditures Total Expenditures: andl Transfers Out Excess( (deficiency) ofrevenues over (under) expenditures: andt transferso out 400 400 1,000 1,000 970 2,250 1,280 970 3,650 2,680 41,668 25,000 (16,668) 68,926 60,000 (8,926) 60,000 41,668 25,000 (16,668) 68,926 60,000 (8,926) 60,000 348,251 363,423 15,172 2,027,884 2,288,442 260,558 3,148,974 1,121,090 (289,636) $ (314,383) s 24.747 s 770,215 $ 424.891 $ 345,324 Town of Jupiter Inlet Colony, Florida Cash Balances May 31, 2023 Account Balance 1,580,268 116,031 90,264 10,203 $ 1,796,766 $ $ $ $ $ General Fund Checking Account Money Market Account Reserve 50 Colony Account Prime Account ARPA Fund Checking Account Sewer Project Fund Checking Account Reserve. Account Assessment Account Underground Project Fund Checking Account One Penny Surtax Fund Checking Account Total Cash 230,718 4,454 51,348 813,929 869,731 11,643 2,908,858 7 Town of. Jupiter Inlet Colony, Florida Check Register and Bank Debits For thel Month Ended) May 31,2023 General Fund Checking Combined Insurance Company Team Plan Inc James Matthews It-Smarts Linda Davis Esthela N. Lucas Velasquez Ocean Breeze Lawn Maintenance, Inc. Pet Waste Eliminator U.S. Bank Equipment Finance GeoPoint Surveying Inc. Pro-Sweep TDI Bank Richard Hartley, CPA Duval Chevrolet Sixberry, Inc. Locksmith Catherine Sanchez It-Smarts The Sweet Spot Creamery Ilc Caldwell Pacetti Edwards Schoech & Viator BGG electric It-Smarts Kevin Lucas Robert Schultz CML pressure washing services Ocean Breeze Lawn Maintenance, Inc. Lubyn Jimenez Woodland Landscaping It-Smarts Unlimited Auto WashClub Mailroute, Inc. Waste Management of Martin County Diversifield! Building Department John Li Kimley Horn Ocean Breeze Lawnl Maintenance, Inc. Verizon Wireless Prime TurfN Management,llc It-Smarts It-Smarts Earl] E. Griffith, Ph.D. Mix Net Work Source inc Heather Rotondi Sixberry, Inc. Locksmith Chick-fil-A The Sweet Spot Creamery, llc Jupiter Medical Center Phys. Group Date 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/02/2023 05/03/2023 05/03/2023 05/03/2023 05/03/2023 05/04/2023 05/04/2023 05/04/2023 05/04/2023 05/04/2023 05/04/2023 05/04/2023 05/04/2023 05/05/2023 05/05/2023 05/05/2023 05/08/2023 05/08/2023 05/08/2023 05/08/2023 05/09/2023 05/09/2023 05/09/2023 05/09/2023 05/09/2023 05/09/2023 05/09/2023 05/10/2023 05/10/2023 05/11/2023 05/13/2023 Check Number/Ref.# 9797 9798 9799 9800 9801 9802 9803 9804 9805 9806 9807 9808 9809 9810 9811 9812 9813 9814 9815 9816 9817 9818 9819 9820 9821 9822 9823 9824 9825 9826 9827 9828 9829 9830 9831 9832 9833 9834 9835 9836 9837 9838 9839 9840 9841 9842 Vendor Amount $ 5,167.68 8,184.80 2,656.34 168.00 1,067.21 300.00 1,540.00 263.99 227.71 760.00 907.50 5,783.39 4,600.00 41,668.00 1,045.00 350.00 168.00 400.00 10,650.00 1,100.00 168.00 548.90 172.06 1,845.00 1,700.00 315.00 3,500.00 328.00 119.85 90.00 9,431.94 7,160.00 6,800.00 4,829.74 11,206.50 483.42 560.00 456.00 248.00 285.00 42.00 94.15 1,043.00 1,569.60 565.00 820.00 8 Town of Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended May 31,2023 General Fund Checking (continued) jupiter kiteboarding franciso's Irrigation It-Smarts VOIDED Sixberry, Inc. Locksmith Emilio Rodriguez It-Smarts CA florida holdings lc Esthela N. Lucas Velasquez Tequesta Fire Rescue It-Smarts Staples Florida Power and Light Nozzle Nolen, Inc. Arch/Con Copies Manno Uniforms Kyocera Document Solutions LLC Comcast Ubermac TDI Bank Village ofTequesta AFLAC Verizon Wireless Axon Enterprise inc. It-Smarts It-Smarts Kimley Horn Florida Blue 3 Lubyn. Jimenez Palm Beach County) League of Cities Tequesta Tire Company, Inc. Florida Blue Ins. ADP, Inc. Apple, Inc. ADP, Inc. ADP, Inc. ADP, Inc. Davison Fuels & Oill LLC Davison Fuels & Oil LLC Davison Fuels & Oil LLC Davison Fuels & Oil LLC Davison Fuels & Oill LLC Date 05/16/2023 05/16/2023 05/16/2023 05/16/2023 05/16/2023 05/16/2023 05/16/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/23/2023 05/25/2023 05/25/2023 05/26/2023 05/26/2023 05/26/2023 05/26/2023 05/01/2023 05/03/2023 05/05/2023 05/10/2023 05/17/2023 05/31/2023 05/01/2023 05/08/2023 05/15/2023 05/22/2023 05/30/2023 Check Number/Ref.# 9843 9844 9845 9846 9847 9848 9849 9850 9851 9852 9853 9854 9855 9856 9857 9858 9859 9860 9861 9862 9863 9864 9865 9866 9867 9868 9869 9870 9871 9872 9873 ACHI Debit ACHI Debit ACH Debit ACH Debit ACH Debit ACH Debit CL57642 CL58870 CL59551 CL60492 CL61306 Vendor Amount 684.48 130.00 1,830.00 112.00 4,778.00 448.00 197.64 300.00 121,665.29 168.00 163.18 478.71 160.00 16.00 98.99 221.24 921.70 35.00 7,365.92 1,639.56 83.59 1,089.81 668.25 894.00 408.00 874.13 863.26 225.00 360.00 93.41 14,870.22 34,305.00 75.00 1,335.41 46,079.72 39,145.74 421.29 641.73 396.57 601.74 396.54 $ 426,630.90 Total Disbursements General Fund Checking 9 Town of. Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended May 31,2023 Sewer Project Fund Checking Murray Logan Construction LLC Underground Fund Checking Date 05/03/2023 Check Number/Ref.: # 1285 Vendor Amount 5,500.00 $ 5,500.00 Total Disbursements- - Sewer Project Fund Checking No checks issued in current month Total Disbursements Underground Fund Checking $ 10