Inlet ber Ertabhehedigs9 Florida Schedule of Revenues and Expenditures Budget and. Actual General Fund (Unaudited) Cash Balances August31,2023 For the Eleven Months EndedJuly. 31, 2023 Check Register & Bank Debits For the Month Ended. August 31, 2023 TOWN OF. JUPITER: INLET COLONY, FLORIDA Schedule ofRevenues and Expenditures Budget and Actual General Fund Fort thel Eleven Months Ended. July 31, 2023 YID Actualt to 83,652 (5,008) 106% 150 (141) 194% 18,000 (32,430) 280% 7,314 100% 71,000 61,190 14% 14,100 13,130 7% August 31,2023 Actual Year ToDate Budget Variance YTD Actual YTDI Budget YTD Variance Ann Bgt Ann Bgt Rem Ann Bgt 16,614 $ 3,443 $ 13,171 $ 2,617,474 $ 2,594,386 $ 23,088 $ 2,597,838 $ (19,636) 101% 196,753 37,445 159,308 384,805 411,895 (27,090) 449,334 64,529 86% REVENUES Taxes Permits, Fees, & Special Assessments Intergovemmental Judgments, Fines & Forfeitures Miscellaneous! Revenue EXPENDITURES Administration Planning Police Fire Control Building Official Beautification Roads & Walkways Surtax Expenditures Excess (delicien)ofrwenue over (under) expenditures and transfers out 10,510 6,971 3,539 13 (13) 2,316 1,501 815 983 88,660 76,681 11,979 291 143 50,430 16,511 33,919 9,810 65,087 55,277 970 12,925 11,955 148 Total Revenues 226,193 49,373 176,820 3,141,660 3,099,616 42,044 3,148,974 167,025 74,651 (92,374) 925,476 821,161 (104,315) 895,763 (29,713) 103% 112,563 85,118 (27,445) 1,055,964 936,298 (119,666) 1,021,387 (34,577) 103% 162,220 40,555 (121,665) 567,771 446,105 (121,666) 486,66! (81,110) 117% 13,779 16,500 2,721 107,949 181,500 73,551 198,000 99,051 55% 9,554 11,292 1,738 215,140 124,212 (90,928) 135,500 (79,640) 159% 466,124 235,208 (230,916) 2,883,080 2,587,288 (295,792) 2,822,411 (60,669) 102% (239,931) s (185,835) $ (54,096) s 258,580 s 512,328 s (253,748) s 326,563 $ 67,983 5,917 4,934 1,175 1,175 0% Total Expenditures TOWN OF JUPITER INLET COLONY,FLORIDA Schedule ofRevenuess and Expenditures Budgets and Actual Genera! Fund Fort thel Eleven Months Ended. July 31,2023 August3 31,2023 Actual 12,930 $ 1,202 1,154 48 544 532 12 1,938 1,757 274 274 188 (188) 100 229 (129) 250 (250) 3,264 916 2,348 15 (15) 3,174 3,040 13 (13) 13 (13) 83 2,233 39,442 417 (417) 167 (167) 417 (417) 417 (417) 2316 1,501 YTD 376 271 (867) (4,611) 2,250 2,250 2,750 2,432 3,000 2,666 (205) 10,994 (2,16!) 175 175 (2,094) (928) (5,008) 105.999 150 (141) 150 (141)194.0094 (10) 1,000 (38,442) 5,000 (3,900) 2,000 2,000 (1,500) 5,000 5,000 4,422 YearT ToDate Annual Anoual Budget Actualto 13,475 12,694 781 13,851 6,114 5,852 262 6,385 4,611 4,611 2,068 (2,068) 318 2,519 (2,201) 334 2,750 (2,416) 13,155 10,076 3,079 165 (165) 134 38,577 33,440 5,137 36,483 291 143 148 291 143 148 10 913 38,529 8,900 4,587 4,313 1,837 (1,837) 1,500 1,500 4,587 (4,587) 578 4,587 (4,009) 5,000 815 50,430 16,511 33,919 18,000 (32,30)280.176 Budget Variance YTDActual YTDI Budget YTDY Variance Budget Remaining Ann Bgt $ 12,930 $2,575,929 $ 2,556,513 $ 19,416 $ 2,556,513 $ (19,416) 181 21,956 19,327 2,629 21,089 REVENUES Taxes AdValorem Taxes Local Optional FuelT Tax New! Local Optional Gas Tax Communications! Services Tax Total Taxes Permits, Fees, & Special Assessments Building Permits Bldg permits surchargefee Bldg Permit Surcharge Retainage Licenses (Registrations)- JIC County Revs Sharing Business Tax Franchise Fees FP&L Total Permits, Fees, & Special Assessments Intergoverameatal State Revenue Sharing Program Dist Alcoholic BevL License Fees Local Governml/2 Cents SalesTax Disc. Infrastructure! Sales Tax Totall Intergovernmental Judgments, Fines & Forfeitures Fines &F Forfitures Total Judgments, Fines &1 Forfeltures Miscellaneous! Revenue Reimbursements Interest! Income Garden Club Donations Donations- -POA Donations- Miscellancous Proceeds from Saleo ofCapital Assets Miscellaneous Reimbursements Total! Miscellaneous Revenue TotalF Revenues 16,614 3,443 13,171 2,617,474 2,594,386 23,088 2,597,838 (19,636/100.769 196,379 33,333 163,046 338,003 366,663 (28,660) 400,000 61,997 3,445 (3,445) 41,539 37,895 3,644 41,334 196,753 37,445 159,308 384,805 411,895 (27,090) 449,334 64,579/85.649 4,072 3,000 1,072 36,928 33,000 3,928 36,000 10,510 6,971 3,539 88,660 76,681 11,979 83,652 2,316 226,193 s 49,373 s 176,820 $3,141,660 $3,099,616 S 42,044 $3,148,974 $ 7,314 99.77% 2 TOWN OFJ JUPITERI INLET COLONY,FLORIDA Schedulec ofRevenues andE Expenditures Badgets andA Actual General Fund Fort thel Eleven! Ended. July3 31,2023 YTD August 31,2023 Annual Annuall Budget Actualto Actua! 4,278 4,647 369 49,696 51,117 1,421 55,769 6,073 3,829 4,160 331 44,474 45,760 1,286 49,924 5,450 481 523 42 5,822 5,753 (69) 6,270 448 327 356 29 3,928 3,916 (12) 4,266 338 293 318 25 3,515 3,498 (17) 3,819 304 820 820 5,164 9,020 3,856 9,836 4,672 558 558 3,090 6,138 3,048 6,692 3,602 499 499 6,915 5,489 (1,426) 5,991 (924) 5,535 5,449 (86) 52,913 59,939 7,026 65,388 12,475 724 618 (106) 6,236 6,798 562 7,416 1,180 (164) 2,141 2,305 13,876 23,551 9,675 25,689 11,813 23 23 253 253 275 275 208 208 2,288 2,288 2,500 2,500 7,910 (7,910) 14,135 (14,135) (14,135) 250 250 72 2,750 1,978 3,000 2,228 9,285 5,000 (41,339) 65,000 8,300 1,266 1,500 234 13,989 16,500 2,511 18,000 4,011 775 1,042 267 8,785 11,462 2,677 12,500 3,715 9,432 9,167 (265) 94,319 100,837 6,518 110,000 15,681 1,667 1,834 167 18,333 20,174 1,841 22,000 3,667 95 417 322 4,707 4,587 (120) 5,000 293 723 417 (306) 5,143 4,587 (556) 5,000 (143) 565 192 (373) 2,481 2,112 (369) 2,300 (181) 631 667 36 7,489 7,337 (152) 8,000 511 736 700 (36) 8,816 7,700 (1,116) 8,400 (416) 42 42 462 462 500 500 208 208 99 2,288 2,189 2,500 2,401 478 42 (436) 1,256 462 (794) 500 (756) 510 38 (472) 1,280 418 (862) 450 (830) 646 167 (479) 21,123 1,837 (19,286) 2,000 (19,123) 71 71 781 781 850 850 1,182 458 (724) 3,928 5,038 1,110 5,500 1,572 YearToDate Badget Variance YTDA Actual YTDE Budget YTDVariance Budget Remaining Aon Bgt. 6,290 $ 6,830 $ 540 73,686 $ 75,130 $ 1,444 $ 81,965 $ 8,279 EXPENDITURES Administration SalaryA Admin. Officer Payroll1 TownClerk SalaryA Admin. Secretary Payrol!1 TaxesA Admin. Officer Payroll TaxesA Admin. Secy. P/R1 Taxes Town Clerk Retirement Retirement7 TownClerk 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- ADPH HR Custodian/Pest Control Refuse/Recycling' Collection CodeE Enforcement Tagplomalatmaehaie Utilities (Electric) Copyl Machine PostageN Meter Liability! Insurance Property &1 Flood Notaryl Insurance Equipment & Repairs Miscellancous! Equip. Rentals Other Maintenance Building! Maintenance Propane Gas/Generator) Maint Memberships Travel Misc. Govemment 28,184 4,167 (24,017) 108,073 45,837 (62,236) 50,000 (58,073) 417 (8,868) 46,339 4,587 (41,752) 6,450 1,125 (5,325) 19,950 12,375 (7,575) 13,500 (6,450) 7,200 5,417 (1,783) 56,700 59,587 2,887 5,467 1,833 (3,634) 26,714 20,163 (6,551) 22,000 (4,714) 6,122 1,000 (5,122) 17,792 11,000 (6,792) 12,000 (5,792) 11,700 1,667 (10,033) 48,033 18,337 (29,696) 20,000 (28,033) TOWN OF JUPITERI INLET COLONY,FLORIDA Schedule ofRevenuess and Expenditures Budgets and Actual Generall Fund Fort theE Eleven Months EndedJ July3 31,2023 YTD August31,2023 YearToDate Annual Aonual Budget Actualto Actual 708 708 $ 528 417 (111) 4,411 4,587 176 5,000 589 583 583 10,611 6,413 (4,198) 7,000 (3,611) 83 83 913 913 1,000 1,000 833 833 9,163 9,163 10,000 10,000 1,667 1,667 189 18,337 18,148 20,000 19,811 2,011 1,610 451 (1,159) 3,903 4,961 1,058 5,412 1,509 208 208 2,288 2,288 2,500 2,500 179 1,250 1,071 17,904 13,750 (4,154) 15,000 (2,904) 192 192 3,385 2,112 (1,273) 2,300 (1,085) 150 150 1,650 1,650 1,800 1,800 83 83 1,400 913 (487) 1,000 (400) 42 604 462 (142) 500 (104) 275 275 3,025 3,025 3,300 3,300 595 595 6,545 6,545 7,142 7,142 983 2,167 1,184 9,810 23,837 14,027 26,000 16,190 417 417 4,587 4,587 5,000 5,000 3,333 3,333 36,663 36,663 40,000 40,000 983 5,917 4,934 9,810 65,087 55,277 71,000 61,190/13.829 Budget Variance YTDActual YTDE Budget YTDV Varianee Budget Remaining Ann Bgt EXPENDITURES (continued) Administration (continued) Municipal Election Offices Supplies OfficeE EquipmenuSofware Officel Fumiture Training AndA AutoN Mileage "CapitalOutlay Principal Payment InterestE Expenditures AidT ToP Private Organizations Social Committee Inlet/Outlet Directory SpecialE Events Bank Charges NRPA Assessment Underground/ AnnualA Assessment Total Adminstration Planning Npdes(Agrmt8 & Consult) Comprehensive Planning Enginer TotalP Planning 7,788 $ 7,788 $ 8,500 $ 8,500 42,091 7,126 (34,965) 83,498 78,386 (5,112) 85,509 167,025 74,651 (92,374) 925,476 821,161 (104,315) 895,763 (29,713) 103.32% TOWN OF JUPITER INLET COLONY,FLORIDA Schedule ofRevenues andE Expenditures Budget and Actual General Fund Fort the Eleven! Months Ended. July 31,2023 August 31,2023 Actual 471 430 (41) 5,640 4,730 (910) 1,378 1,378 12,326 15,158 2,832 4,307 4,307 21,899 47,377 25,478 51,682 29,783 373 373 3,638 4,103 (84) 4,613 1,022 1,022 23,363 11,242 (12,121) 12,268 (11,095) 1,683 1,656 (27) 18,508 18,216 (292) 19,868 3,698 3,698 51,772 40,678 (11,094) 44,376 (7,396) 17,000 167 (16,833) 20,419 1,837 (18,582) 1,799 625 (1,174) 17,435 6,875 (10,560) 175 (175) 876 7,256 7,333 77 79,814 80,663 210 292 82 2,314 3,212 190 500 310 11,753 5,500 (6,253) 6,000 216 1,900 1,900 14,980 20,900 5,920 22,800 2,271 208 (2,063) 15,446 2,288 (13,158) 93 292 199 3,040 3,212 333 333 10,898 3,663 (7,235) 130 (130) 1,696 603 417 (186) 9,279 4,587 (4,692) 3,921 4,167 246 33,725 45,837 12,112 333 333 392 3,663 3,271 1,042 1,042 7,211 11,462 4,251 YTD YearToDate Annual Annual Budget Actualto Budget Variance YTDActual YTDBudget YTDI Variance Budget Remaining Ann Bgt 15,386 $ 18,012 $ 2,626 $ 199,590 $ 198,132 $ (1,458) $ 216,139 $ 16,549 34,412 24,779 (9,633) 327,832 272,569 (55,263) 297,346 (30,486) 3,846 1,896 (1,950) 29,581 20,856 (8,725) 22,747 10,442 7,375 (3,067) 84,982 81,125 (3,857) 88,494 EXPENDITURES (continued) Police Salaries Salaries-Patrol,' Traffic Enf. & Investagate Salary! Incentive Payroll Taxes Patrol Payroll Taxes Police Admin. Retirement Health Dental Life STD,L Life, Accident Worke'sComp. Dispatch Professionals Services Telephonelntemet Custodian/Pest Control Liability! Insurance Auto Insurance Auto Repairs &! Maint. Utilities (Water) Gas&Oil Equip. Repair &N Maint. MembershipsPS Miscellancous Office Supplies Ammo, Uniforms, Dues Computer Maintenance Training Public Safety CapitalOutlay General Equipment Security Cameras Capital Outlay- Security! Bldg Totall Police Fire Coatro! Tequesta Fire-Rescue Total Fire Control 5,160 (480) (6,834) 16,535 4,209 3,512 465 4,472 834 (4,613) (4,613) 1,360 2,000 (18,419) 7,500 (9,935) (876) (876) 849 88,000 8,186 898 3,500 1,186 (5,753) (216) (216) 7,820 2,500 (12,946) 172 3,500 460 4,000 (6,898) (1,696) (1,696) 5,000 (4,279) 50,000 16,275 4,000 3,608 12,500 5,289 4,046 1,250 (2,796) 25,550 13,750 (11,800) 15,000 (10,550) 4,847 1,333 (3,514) 17,176 14,663 (2,513) 16,000 (1,176) 112,563 85,118 (27,445) 1,055,964 936,298 (119,666) 1,021,387 (34,57)103.396 162,220 40,555 (121,665) 567,771 446,105 (121,666) 486,661 (81,110) 162,220 40,555 (121,665) 567,771 446,105 (121,666) 486,661 (81,110)16679 TOWN OF JUPITERI INLET COLONY,FLORIDA Schedule ofRevenuess andE Expenditures Badgets and/ Actual GeneralF Fund Fort thel Eleven Months Ended. July 31,2 2023 August 31,2023 Actual YTD VearToDate Annual Annual Budget Actualto Budget Variance YTDActual YTDI Budget YTDVariance Budget Remaining Ana Bgt 833 $ 833 $ 8,406 $ 9,163 $ 757 $ 10,000 $ 1,594 13,779 9,167 (4,612) 53,683 100,837 47,154 110,000 56,317 6,500 6,500 45,860 71,500 25,640 78,000 32,140 13,779 16,500 2,721 107,949 181,500 73,551 198,000 90,05154.529 4,083 1,500 (2,583) 18,963 16,500 (2,463) 18,000 1,094 3,000 1,906 24,542 33,000 8,458 36,000 11,458 9,554 11,292 1,738 215,140 124,212 (90,928) 135,500 (7,640)158.779 EXPENDITURES (continued) Building Oficial Professional Services- Inspections Zoning Consultant Services Buidling OfficialServices Total Building Official Beautification Utilities (Water) Maintenance- Other Repairylmprovememts Landscape! Maintenance Parkl Improvements Fowmsin.aTIaMata Other Expenses Total Beautification Roads & Walkways Walkways Repair Repaisfianlsapesigys Drains Cleaning Other Total Roads & Walkways Surtax Expenditures Capital Outlay- -Surtax Vehicles/Equipment TotalSurtax Expenditures Total Expenditures: and1 Transfers Out Excess (deficiency) ofrevenues over (uader) expenditures andt transfers out (963) 1,500 (54,486) 600 1,500 2,030 9,000 13,130 6.889 0.00% 125 125 1,149 2,500 1,351 1,915 2,500 1,313 1,667 1,375 1,375 (54,486) 550 550 1,375 1,375 970 2,750 1,780 8,250 8,250 970 12,925 11,955 14,100 1,500 38,961 27,500 (11,461) 30,000 (8,961) 585 49,988 27,500 (22,488) 30,000 (19,988) 354 28,200 18,337 (9,863) 20,000 (8,200) 54,486 600 1,500 3,000 9,000 125 250 250 750 750 1,175 1,175 466,124 235,208 (230,916) 2,883,080 2,587,288 (295,792) 2,822,411 (60,669/102.1596 (239,931) s (185,835) s ($4,096) s 258,580 s 512,328 $ (253,748) $ 326,563 s 67.983 Town of. Jupiter Inlet Colony, Florida Cash Balances August 31,2023 Account Balance $ 886,208 116,719 90,822 10,252 1,104,001 232,088 4,481 51,653 223,124 279,258 11,719 70,529 1,697,595 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 $ $ $ $ $ $ $ 7 Town of] Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended August 31,2023 General Fund Checking Samuel. J.E Pruitt G&A AT&T2 Team Plan Inc Working Gears,LLC Jonathan Folbrecht It-Smarts TDI Bank Diversifield Building Department Nozzle Nolen, Inc. Ocean Breeze Lawn Maintenance, Inc. U.S. Bank Equipment Finance GeoPoint Surveying Inc. Shred-it Usa Pro-Sweep Mix Net Work Source inc communication international Verizon Wireless Village ofTequesta FACC General Robert Schultz CivicPlus TransUnion Richard Hartley, CPA It-Smarts Floridian Signs Ocean Breeze Lawn Maintenance, Inc. Palml Beach County League ofCities Unlimited Auto WashClub It-Smarts Quadient Finance USA, Inc Puritan cleaners Caldwell Pacetti Edwards Schoech & Viator Emerald Gardens Pest Control Mailroute, Inc. Tequesta Tire Company, Inc. Mix Net Work Source inc the plumbing company oft the Treasure Coast Waste Management of Martin County Central Square Edward Mooney Minuteman Press CML pressure washing services It-Smarts Village ofTequesta It-Smarts Date 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/01/2023 08/02/2023 08/02/2023 08/02/2023 08/02/2023 08/02/2023 08/02/2023 08/02/2023 08/03/2023 08/03/2023 08/03/2023 08/03/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/08/2023 08/09/2023 08/09/2023 08/14/2023 08/14/2023 Check Number/Ref.# 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 10014 10015 10016 10017 10018 10019 10020 10021 10022 10023 10024 10025 10026 10027 10028 10029 10030 10031 10032 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 10043 10044 10045 10046 Vendor Amount $ 9,000.00 2,775.00 351.86 7,819.60 17,000.00 152.77 328.00 7,964.51 7,910.00 257.00 900.00 506.77 285.00 748.71 907.50 42.30 2,019.34 1,060.77 2,025.06 75.00 85.58 3,260.25 75.00 7,200.00 328.00 80.00 1,700.00 1,107.00 179.85 248.00 564.87 335.27 9,100.00 250.00 84.00 75.60 85.23 189.00 9,431.94 457.38 195.44 257.00 510.00 128.00 121,665.29 568.00 8 Town of. Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended August 31,2023 General Fund Checking (continued) Tequesta Tire Company, Inc. Terrence Verner Teresa Armwood Teresa Armwood It-Smarts Sixberry, Inc. Locksmith Manno Uniforms Billfish Ocean Breeze Lawn Maintenance, Inc. Kyocera Document Solutions LLC Pro-Sweep Verizon Wireless It-Smarts TurfRemedy Co Works International,Inc Nozzle Nolen, Inc. Chrissy Wheaton Team Plan Inc TD Bank Florida Power and Light Aware Johnson, Anselmo, Murdoch, Burke, Piper.. Esthela N. Lucas Velasquez AFLAC Verizon Wireless Verizon Wireless Village ofTequesta Police Law Institute The Police and Sheriffs Press Gunster, Yoakley & Stewart, P.A. Comcast Johnson, Anselmo, Murdoch, Burke, Piper. Florida Blue 3 It-Smarts Samuel J.I Pruitt The Police and Sheriffs Press Shred-it Usa Teresa Armwood AT&T2 The Police and Sheriffs Press Aware It-Smarts Florida Blue Ins. TD Bank ADP, Inc. Date 08/14/2023 08/14/2023 08/14/2023 08/14/2023 08/14/2023 08/15/2023 08/15/2023 08/15/2023 08/15/2023 08/15/2023 08/15/2023 08/15/2023 08/15/2023 08/17/2023 08/17/2023 08/17/2023 08/18/2023 08/22/2023 08/22/2023 08/22/2023 08/22/2023 08/22/2023 08/22/2023 08/22/2023 08/22/2023 08/22/2023 08/24/2023 08/24/2023 08/24/2023 08/24/2023 08/24/2023 08/24/2023 08/24/2023 08/25/2023 08/29/2023 08/29/2023 08/29/2023 08/29/2023 08/29/2023 08/29/2023 08/29/2023 08/29/2023 08/30/2023 08/01/2023 08/01/2023 08/09/2023 Check Number/Ref.# 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10060 10061 10062 10063 10064 10065 10066 10067 10068 10069 10070 10071 10072 10073 10074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 ACH Debit ACH Debit ACH Debit Vendor Amount 10.40 175.00 100.00 189.00 175.00 696.00 38.00 114.95 94.50 2,120.00 216.62 75.00 37.07 368.00 750.00 5,000.00 257.00 92.98 5,959.80 3,576.21 95.03 6,450.00 3,938.55 300.00 83.59 1,332.78 172.18 1,862.34 2,072.00 17.60 5,805.00 921.70 4,340.00 724.06 248.00 9,000.00 32.60 135.67 200.00 351.85 17.60 2,700.00 1,310.00 15,977.01 43,700.61 34,724.22 the plumbing company of the Treasure Coast 9 Town of. Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended August 31,2023 General Fund Checking (continued) Date 08/23/2023 08/05/2023 08/10/2023 Check Number/Ref.# ACH Debit Rec-ACH Debit Apple, Inc. Rec-ACH Debit ADP, Inc. Total Disbursements General Fund Checking Vendor Amount 34,412.50 75.00 1,266.29 412,601.60 ADP, Inc. 10