Inlet er C Esfablshed1959 Florida Schedule of Revenues and Expenditures For the Six Months Ended March 31, 2023 Budget and. Actual General Fund (Unaudited) Cash Balances March 31, 2023 Check Register & Bank Debits For the Month Ended March 31, 2023 TOWN OF. JUPITERI INLET COLONY,FLORIDA Schedulec ofRevenues and Expenditures Budgeta and Actual Genera! Fund Fort thes Six Months Ended! March31,2023 March: 31,2023 Actual 37,934 34,112 3,822 7,353 6,971 382 66 13 53 4,654 1,501 3,153 908 1,751 843 106,023 107,678 1,655 40,555 40,555 9,979 12,668 2,689 7,243 9,292 2,049 925 925 Year7 ToDate 95,903 90,172 46,476 41,826 99 32,055 Budget Variance YTDActual YTDE Budget YTDV Variance Ann Bgt Annl Bgt Rem 26,765 $ 25,443 $ 1,322 $ 2,340,133 S 2,330,513 $ 9,620 $ 2,597,838 $ 257,705 76,772 68,040 8,732 2,514,666 2,471,595 43,071 3,148,974 634,308 REVENUES Taxes Permits, Fees, & Special Assessments Intergovemmental Judgments, Fines &Forfeitures Miscellancous Revenue EXPENDITURES Administration Planning Police Fire Contro! Building Official Beautification Roads & Walkways Surtax Expenditures Total Expenditures Excess (deficiency) ofr revenues over (under)e expenditures and transfers out 5,731 4,650 78 21 9,006 23,049 449,334 353,431 83,652 37,176 18,000 150 (14.055) 51 980,610 541,905 66,710 71,000 194,000 149,204 80,836 14,100 13,130 35,000 7,742 Total Revenues 67,880 72,490 4,610 438,705 525,324 86,619 4,290 12,504 551,046 588,961 44,796 54,500 132,664 150,752 18,088 970 7,550 27,258 35,000 8,214 9,704 6,580 213,500 7,742 243,331 243,330 37,915 (I) 1,104,082 486,661 553,036 243,330 232,588 245,359 12,771 1,443,060 1,617,921 174,861 3,098,953 1,655,893 (155,816) (177319) 21,503 $1,071,606 S 853,674 s 217,932 S 50,021 $(1,021,585) TOWN OF JUPITERI INLET COLONY, FLORIDA Scheduled ofRevenues andE Expeaditures Budgets and Actual GeneralF Fund FertheSix Months Ended March 31,2023 March3 31,2023 YearToDate Annusl AnnualE Budget Actual 1,208 1,154 54 7,215 6,924 291 $ 238,674 $68 532 36 3,278 3,192 86 13,851 6,636 2,068 1,757 311 11,801 10,542 1,259 21,089 6,385 3,107 248 248 1,202 1,202 330,591 188 (188) 1,128 (1,128) (1,202) 229 (229) 206 1,374 (1,168) 2,250 2,250 59 250 (191) 239 1,500 (1,261) 2,750 2,544 3,815 3.445 370 24,847 3,000 2,761 979 916 63 5,871 5,496 375 IS (15) 90 10,994 5,123 3,536 3,040 496 21,002 18,240 2,762 (90) 175 175 2.838 3,000 (162). 19,603 36,483 15,481 7,353 6,971 66 13 53 99 150 66 13 53 150 SL 10 10 4,331 21,097 498 20,599 (10) 200 (217) 8,900 2,502 6,398 1,000 (20,097) 167 (167) 1,002 5,000 0.900) 1,500 (1,002) 2,000 2,000 417 (417) 2,502 (2,502) 1,500 (1,500) 40 417 (377) 548 5,000 5,000 Budget Variance YTDActua! YTDI Budget YTDVariance Budget Remaining 22,921 S 22,000 s 921 $ 2,317,839 $ 2,309,855 s 7,984 $2,556,513 26,765 25.443 1322 2,340,133 2.330.513 9,620 2.597.438 257,705 9,288 33,812 30,000 3,812 69,409 65,500 3,909 400,000 REVENUES Taxes AdValoremT Taxes Local OptionalF FuelT Tax NewL Local Optional Gas Tax Communicationss ServicesT Tax Totall Tazes Permits, Fees, SpecialA Assessments Building! Permits Bldgp permits surcharge fee Bldg Permits Surcharge Retainage Licenses (Registrations)- -JIC County Revs SharingE Business Tax FranchiseF Fces FP&L Totall Permits, Fees, &s Special Assessments Intergovermmental StateR Revenues Sharing Program DistA Alcoholic BevL Licensel Fecs Local Govemml/2 Cents Sales Tax Dise. Infrastructure! SalesT Tax Total Intergoveramental Judgments, Fines & Forfeitures Fines&Forfitures Tolal Judgments, Fines & Forfeitures Miscellancous! Reveaue Reimbursements Interest! Income Garden ClubDonations Donations- POA Donations- Miscellancous Proceedsf froms Salec ofCapitalA Asscts Miscellaneous Reimbursements Totall Miscellaneous! Revenue Total Revenues 37.934 34,112 3,822 95.903 20,670 90,172 4,177 5.731 449.334 41,334 353.431 16,487 382 46,476 18,000 41,826 4,650 1,603 36,000 83,651 16397 37.176 4,654 1,501 3,153 32,055 2,502 9.006 (1,954) 23,049 18,000 5,000 (14,055) 4.452 76,772 $ 68,040 S 8,732 $ 2,514,666 $ 2,471,595 s 43,071 $3,148974 S 634,308 2 TOWN OF. JUPITER MLETCOLONV,FLORDA Scheduled ofRevenues and! Espenditures Budget andA Actual General Fund Fort thes SiN Months Ended March 31,2023 March 31,2023 Annual Annual Badget Actur! 4,278 4,647 369 26,165 27,882 1,717 55,769 41,501 3,829 4,160 331 23,415 24,960 1,545 49,924 29,604 481 523 42 3,128 3,138 10 6,270 26,509 327 356 29 2,127 2,136 3,142 293 318 25 1,904 1,908 9 4 4,266 2,139 2,445 2,640 195 5,164 7,100 3,819 1,915 1,545 1,116 (429) 3,090 3,348 1,936 21,016 15,852 959 499 (460) 6,915 258 6,692 3,602 5,535 5,449 (86) 28,888 8,495 1,580 11,492 4,577 (49) 618 667 1,622 32,694 3,708 3,806 2,086 65,388 36,500 (214) 2,141 2,355 8,942 16,846 7,416 5,794 23 23 138 7,904 138 29,689 20,747 208 208 1,248 275 275 1,248 2,500 2,500 2,325 2,500 175 11,700 5,066 15,335 6,000 934 6,000 934 250 250 575 1,500 3,635 50,000 38,300 2,276 417 (1,859) 13,350 925 3,000 2,425 13,000 (350) 13,000 (350) 13,500 13,500 1,335 1,500 165 7,771 9,000 65,000 35,900 360 1,042 682 3,953 6,252 2,299 1,229 18,000 12,500 10,229 9,432 9,167 (265) 47,160 55,335 8,547 1,667 1,833 166 10,000 10,998 8,175 998 110,333 22,000 63,173 827 331 (496) 13,097 12,000 393 417 24 2,065 12,831 2,502 (266) 437 22,000 8,903 369 417 48 2,746 2,502 (244) 5,000 2,935 192 192 701 1,152 451 5,000 2,254 631 (631) 3,786 8,000 2,300 1,599 736 700 (36) 4,417 4,200 4,214 8,000 4,214 42 252 (217) 252 8,400 500 3,983 208 208 11,279 13,248 1,969 500 396 42 (354) 396 14,500 3,221 38 38 228 252 (144) 500 104 2,414 2,167 (247) 13,831 14,835 228 450 450 71 71 426 1,004 426 15,833 2,002 458 458 2,561 2,748 850 850 187 5,500 2,939 7,011 1,000 6,500 1,000 5,011 Year ToDate EXPENDITURES Administration Salary Admin. Officer Payrol!T TownClerk Salary Admin. Secrelary PayrallT Taxes Admin. Officer Payrol! Taxes Admin. Secy. PRT TaxesT Town Clerk Retirement Retirement Town Clerk Retirement- Admin. Secy Health Dental STD, Life, Accident Workers Comp. Codification Inspections- Building Legal LegalA Advertisments Professionals Services. Other Professionals Services- Auditor Professionals Services- Finance Professionals Services. ADPH HR CusodianPstCoatrol Refuse/Reryeling' Collection CodeE Enforcement Taghomelatemai/Vehie Utilitics (Electric) Copy! Machine Postagen Meter Liability Insurance Property & Flood Notary! Insurance Equipment& Repairs Miscellancous Equip. Rentals Other! Maintenance Buildingn Maintenance Propane Gas/Generator) Maint Memberships Travel Misc. Govement Budget Variance YTDActua! YTDE Budget YTDVariance Budget Remmining 6,290 $ 6,830 $ $40 S 38,464 $ 40,980 S 2,516 S 81,965 s 4,500 2,751 (1,749) 29,100 32,502 3,402 292 6,000 5,708 12,000 11,708 (511) 31,989 31,835 (154) 37,000 TOWNO OFJ JUPITERI INLET COLONY, FLORIDA SehedaleofRevenue andE Expeaditures Budget and/ Actusl GeneralF Fand Forthes Siz Moaths Ended March 31,2023 March: 31,2023 Actus! 708 708 277 6,309 6,583 274 $3 833 833 208 555 750 95 350 192 (158) 150 150 83 83 42 275 275 595 595 908 1,334 426 417 417 908 1,751 YearToDate Annual AnnualBudget 4,248 $ 4,248 S $,500 s 8,500 2,170 2,502 332 5,000 2,830 8,731 9,498 767 498 498 13,000 1,000 4,269 1,000 4,998 4,998 10,000 10,000 189 8,335 8,146 20,000 19,811 41,407 42,755 1,348 85,509 2,294 2,706 412 5,412 44,102 3,118 1,248 1,248 14,616 14,000 (616) 15,000 2,500 2,500 3,035 2,152 (883) 3,300 384 900 900 1,800 265 498 498 1,000 1,800 604 252 (352) 1,000 1,650 1,650 3,300 500 3,300 (104) 3,570 3,570 7,142 4,290 10,002 $,712 26,000 2,502 2,502 5,000 21,710 5,000 843 4,290 12,504 8,214 40,000 71.000 40,000 66,710 Budget Variance YTDActual YTDE Budget YTDVarinnee Budget Remxining EXPENDITURES (continued) Administration (continued) Municipa! Election Office Supplies Office Equipmen/Soflware Office Furniture Training AndA AutoN Mileage CapitalOulay Principal Payment Interest Expenditures AidToPrivale Organizations Social Committee Inlet/Outlet Directory SpecialE Events Bank Charges NRPA Assessment Underground AnnualA Assessment TolalA Adminstration Planning Npdes(Agrmt& Consult) Comprehensive Planning Engincer TatalP Planning 67,880 72.490 4.610 438.705 525,324 86,619 980,610 541,905 7,142 TOWN OFJ JUPITERI INLET COLONY,FLORIDA Schedulec ofRevenues andE Expenditures Budgel andA Actual General Fuad Fort thes Six Months Ended Marcb3 31,2023 March 31,2 2023 Actual 24,452 24,779 327 143,667 148,674 5,007 297,346 153,679 418 430 12 2,748 2,580 (168) 5,160 1,885 1,896 11 11,738 11,376 1,280 1,378 98 8,576 8,268 11,086 12,614 1,528 21,899 29,842 15,017 17,375 2,358 44,744 54,250 9,506 98,494 53,750 135 135 3,466 5,000 1,534 1,030 1,200 170 3,250 5,400 2,150 1,022 1,022 12,532 13,132 1,683 1,656 (27) 10,095 9,936 (159) 19,868 167 167 2,385 1,002 (1,383) 1,493 625 (868) 9,314 6,750 (2,564) 10,500 701 10,206 10,333 127 46,486 51,998 5,512 210 292 82 1,262 1,752 187 (187) 8,747 9,000 216 1,686 1,900 214 10,094 11,400 1,306 (216) 22,800 12,706 (216) 1,479 208 (1,271) 4,963 3,548 (1,415) 297 292 (5) 2,581 1,752 (829) 799 333 (466) 15,165 15,165 27 (27) 1,097 1,500 1,541 417 (1,124) 4,162 4,002 752 333 (419) 10,529 9,998 (531) 16,000 333 333 9,658 392 16,668 1,998 7,010 1,606 6,491 7,000 509 17,410 19,210 1,800 25,458 2,826 3,000 40,555 40,555 243,331 243.330 40,555 40.555 243.331 243.330 YearToDate Annual AnnualE Budget Budget Variance YTDActua! YTDE Budget YTDY Variance Budget Remainiag 16,509 $ 18,012 S 1,503 $ 104,133 $ 108,072 $ 3,939 S 216,139 $ 112,006 EXPENDITURES (continued) Police Salarics Salaries-Patrol, Traffic Enf. &I Investagate Salary Incentive Payroll" Taxes Patral PayrollT TaxesP Police Admin. Retirement Health Dental Life STD, Life, Accident Worker's Comp. Dispatch Professionals Services Telephone/lintemet CustodianPsiComtro! Liability Insurance Autol Insurance AutoR Repairs &N Maint. Utilities( (Water) Gas& Oil Equip. Repair&n Maint. Memberships PS Miscellancous Office! Supplies Ammo, Uniforms, Dues Computer) Maintenance Training Public Safety Capital Outlay General Equipment Sccurity Cameras Capital Outlay- Securiry Bldg Total Police Fire Control TequestaF Fire-Rescue Total Fire Control (362) 22,747 11,009 2,412 (308) 16,535 7,959 7,943 55,682 33,783 5,742 2,276 9,000 600 19,268 5,750 9,773 6,736 2,000 19,432 (385) (701) 1,186 (701) 490 93,000 3,500 46,514 253 2,238 11,000 2,253 4,800 3,500 (163) 919 403 17,167 1,500 2,002 (160) 6,500 403 234 19,000 2,338 7,734 5,471 50,000 4,000 40,342 3,608 8,048 486,661 B 486,661 243330 243.330 5,390 3,698 (1,692) 24,944 22,188 (2,756) 44,376 2,105 1,250 (855) 11,266 11,500 106,023 107,678 1,655 551,046 588,961 37.915 174 1,104,082 3,000 553.036 174 TOWN OFJ JUPITER INLET COLONY,FLORIDA Schedule ofRevenues and Expenditures Budgeta andA Actual General Fund For thes Six Months Ended March3 31,2023 March 31,2 2023 Actual 3,950 5,835 1,885 1,237 1,500 263 2,336 3,000 664 125 125 740 2,500 1,760 846 YearToDate Annual AnnualE Budget Budget Variance YTDActual YTDE Budget YTDY Variance Badget Remaining 6,029 S 6,833 $ 804 $ 7,644 $ 10,998 S 3,354 S 16,000 s 8,356 9.979 12,668 2,689 44,796 54,500 9,704 194,000 149.204 47,532 EXPENDITURES (continued) Building Oficia! Professionals Services- Inspections Zoningo Consultants Services Buidlingo Officials Services Total Bulding Omcial Beautification Utilities (Water) Maintenance- Other Repiny/mprovements Landscape! Maintenance Park! Improvements FownSaniafinats OtherE Experses Total Beautification Ronds& Walkways Walkways Repair Repainfianicapelsigs Drains Cleaning Other Total Roads & Walkways Surtar Expenditures CapitalOutlay- -Surtax Vehicles/Equipment Totals Surtax Expenditures Total Expenditures: and1 TransfersOut Excess (deficiency)o ofrevenues over (under)e expenditures andt transfersout 16,684 21,002 4,318 110,000 93,316 20,468 22,500 2,032 68,000 13,993 14,000 7 23,000 9,007 11,745 18,000 6,255 36,000 24,255 750 750 1,500 1,500 17,708 20,000 2,292 30,000 12,292 $7,546 65,000 7,454 65,000 7,454 600 1,500 2,030 9,000 7,742 7,742 2,084 1,500 (584) 18,550 18,000 (550) 33,000 14,450 7.243 9,192 2,049 132664 150,752 18.088 213,500 25.000 11,878 80,836 667 (179) 13,122 15,002 1,880 50 125 125 750 750 925 925 300 300 750 750 970 2,000 1,030 4.500 4,500 970 7,550 6,580 14,100 13,130 27,258 35,000 7,742 35,000 27,258 35,000 7,742 35,000 600 1,500 3,000 9.000 232,588 245,359 12,771 1,443,060 1,617.921 174,861 3,098,953 1,655,893 (155,816) $ (177319) S 21.503 $1,071.606 S 853,674 S 217.932 50,021 $(1.021.585) Town of. Jupiter Inlet Colony, Florida Cash Balances March 31,2023 Account Balance $ 1,915,107 115,576 89,895 10,119 $ 2,130,697 $ 229,815 $ $ $ $ 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 9,086 51,147 803,247 863,480 220,317 25,946 3,470,255 7 Town of Jupiter Inlet Colony, Florida Check Register and Bank Debits For thel Month Ended March: 31,2023 General Fund Checking Rocky's Ace Hardware Mailroute, Inc. Alex Freeman Emilio Rodriguez Catherine Sanchez Guardinan! Hawk Security Diversifield Building Department Richard Hartley, CPA Caldwell Pacetti Edwards Schoech & Viator Pro-Sweep It-Smarts Manno Uniforms Ocean Breeze Lawn Maintenance, Inc. Mix Net Work Source inc Waste Management ofMartin County Team Plan Inc Triple MI Brick Pavers, Inc. Central Square Quadient Finance USA, Inc Lubyn. Jimenez It-Smarts Esthelal N.I Lucas' Velasquez It-Smarts franciso's Irrigation Robert Schultz It-Smarts It-Smarts Blue Water Landscape Nozzle Nolen, Inc. Radiotronics, Inc. Jupiter Inlet Beach Club, Inc. It-Smarts Staples Guardinan Hawk Security TDI Bank Village ofTequesta Florida Records Mgmt. Assoc. Emilio Rodriguez Florida Power and Light Comcast Verizon Wireless Florida Power and Light United American Insurance Company Police Lawl Institute Date 03/01/2023 03/01/2023 03/02/2023 03/02/2023 03/02/2023 03/02/2023 03/02/2023 03/03/2023 03/03/2023 03/03/2023 03/07/2023 03/07/2023 03/07/2023 03/07/2023 03/07/2023 03/07/2023 03/08/2023 03/08/2023 03/08/2023 03/09/2023 03/10/2023 03/13/2023 03/13/2023 03/13/2023 03/13/2023 03/13/2023 03/15/2023 03/15/2023 03/15/2023 03/15/2023 03/21/2023 03/21/2023 03/21/2023 03/21/2023 03/21/2023 03/21/2023 03/21/2023 03/21/2023 03/21/2023 03/21/2023 03/21/2023 03/21/2023 03/22/2023 03/22/2023 Check Number/Ref.# 9651 9652 9653 9654 9655 9656 9657 9658 9659 9660 9661 9662 9663 9664 9665 9666 9667 9668 9669 9670 9671 9672 9673 9674 9675 9676 9677 9678 9679 9680 9681 9682 9683 9684 9685 9686 9687 9688 9689 9690 9691 9692 9693 9694 Vendor Amount $ 143.44 87.00 288.85 1,333.00 350.00 1,700.00 6,028.75 4,500.00 2,325.00 907.50 208.00 219.98 1,700.00 42.41 9,431.94 3,950.00 2,500.00 1,691.99 258.27 225.00 208.00 200.00 248.00 875.00 752.40 208.00 208.00 4,375.00 160.00 120.00 26.75 456.00 139.98 90.74 6,231.95 1,237.46 756.00 100.05 841.70 931.08 292.89 946.00 210.00 8 Town of. Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended March 31, 2023 General Fund Checking (continued) Kimley Horn Mailroute, Inc. It-Smarts Ubermac Nozzle Nolen, Inc. Tony"sTree Service Flock Group,INC Superior Party Rental AFLAC Central Square Ocean Breeze Lawn Maintenance, Inc. U.S. Bank Equipment Finance Kyocera Document Solutions LLC AT&T2 Shred-it Usa Emilio Rodriguez Combined Insurance Company Manno Uniforms Robert Schultz East Coast' Towing It-Smarts Apple, Inc. Anne M. Gannon, Tax Collector Anne M. Gannon, Tax Collector Florida! Blue Ins. WEXI Inc. ADP, Inc. ADP, Inc. TDI Bank Florida Municipal Pension Trust ADP, Inc. Davison Fuels & Oil LLC Davison Fuels & Oill LLC Davison Fuels & Oill LLC Davison Fuels & Oil LLC Davison Fuels & OilLLC Sewer Project Fund Checking Murray Logan Construction: LLC Underground Fund Checking Date 03/22/2023 03/22/2023 03/23/2023 03/23/2023 03/23/2023 03/23/2023 03/28/2023 03/28/2023 03/28/2023 03/28/2023 03/28/2023 03/28/2023 03/28/2023 03/28/2023 03/28/2023 03/29/2023 03/29/2023 03/29/2023 03/30/2023 03/30/2023 03/30/2023 03/05/2023 03/08/2023 03/08/2023 03/01/2023 03/06/2023 03/08/2023 03/10/2023 03/15/2023 03/22/2023 03/22/2023 03/06/2023 03/07/2023 03/13/2023 03/20/2023 03/27/2023 03/09/2023 Check Number/Ref.# 9695 9696 9697 9698 9699 9700 9701 9702 9703 9704 9705 9706 9707 9708 9709 9710 9711 9712 9713 9714 9715 ACH Debit ACH Credit ACH Credit ACH Debit ACH Debit ACH Debit ACH Debit ACH Debit ACHI Debit ACHI Debit CL49297 CL50433 CL51073 CL51724 CL52804 1283 Vendor Amount 2,275.87 78.00 1,542.00 35.00 850.00 4,700.00 655.16 83.59 799.00 1,825.00 227.71 141.54 264.91 137.98 938.00 5,167.68 810.00 222.53 187.00 291.00 75.00 9,702.99 2,684.89 20,552.28 135.95 29,690.70 1,335.41 35.00 16,035.78 30,088.77 475.15 112.17 350.91 344.60 403.23 190,760.93 74,400.00 $ 74,400.00 Total Disbursements- General Fund Checking Total Disbursements- - Sewer Project Fund Checking No checks issued in current month Total Disbursements - Underground Fund Checking $ 9