Inlet er Co Esfablished1959 Florida Schedule of Revenues and. Expenditures Budgetand Actual General Fund (Unaudited)* Cash Balances December 31, 2022 Check Register & Bank Debits For the Month Ended. December 31, 2022 For the Three Months Ended December 31, 2022 TOWN OF. JUPITER INLET COLONY, FLORIDA Schedule of Revenues and Expenditures Budget and Actual General! Fund For the Three Months Ended December31,2022 December. 31,2022 Actual $ Year To Date Budget Variance YTD Actual YTD Budget YTD Variance Ann Bgt Ann Bgt Rem 949,600 $ 943,300 $ 6,300 2,183,492 $ 2,159,700 $ 23,792 $ 2,597,838 $ 414,346 REVENUES Taxes Permits, Fees, & Special Assessments Intergovemmental Judgments, Fines & Forfeitures Miscellaneous Revenue 6,747 6,969 3,542 966,858 957,925 83,997 79,655 40,555 9,143 14,147 9,978 6,025 6,400 2,200 722 569 1,342 33,215 21,631 7,363 30,630 20,800 2,600 2,585 831 4,763 449,334 416,119 83,652 62,021 150 150 18,000 10,637 Total Revenues 8,933 2,245,701 2,213,730 31,971 3,148,974 903,273 EXPENDITURES Administration Planning Police Fire Control Building Official Beautification Roads & Walkways Surtax Expenditures 59,707 (24,290) 80,883 40,555 10,000 16,000 252,170 162,594 (89,576) 2,475 270,969 265,117 121,665 121,665 28,843 29,000 46,593 50,000 31,649 895,763 643,593 71,000 (5,852) 1,021,387 750,418 486,661 364,996 198,000 169,157 135,500 14,100 (2,475) 157 3,407 (31,649) 68,525 1,228 857 1,853 (9,978) 88,907 14,100 (31,649) Total Expenditures Transfer Out 237,475 207,145 (30,330) 754,364 628,376 (125,988) 2,822,411 2,068,047 Total Expenditures and' Transfers Out Excess (deficiency) of revenues over (under) expenditures and transfers out 237,475 207,145 (30,330) 754,364 628,376 (125,988) 2,822,411 2,068,047 $ 729,383 $ 750,780 $ (21,397) $ 1,491,337 $ 1,585,354 $ (94,017) $ 326,563 $(1,164,774) TOWN OF. JUPITER NLETCOLONIPLORIDA Schedule of Revenues and Expenditures Budget and Actual General Fund For the Three Months Ended December: 31,2022 December 31,2022 Actual $ Vear Tol Date Annual Annual Budget Budget Variance YTD Actual YTD Budget YTD Variance Budget Remaining 945,861 $ 940,000 $ 5,861 $ 2,172,561 $ 2,150,000 $ 22,561 $ 2,556,513 $ 383,952 REVENUES Taxes Ad' Valorem' Taxes Local Optional Fuel Tax New Local Optional Gas Tax Communications Services' Tax Total Taxes Permits, Fees, & Special Assessments Building Permits Bldg permits surcharge fee Bldg Permit Surcharge Retainage Licenses (Registrations)- JIC County Rev Sharing Business Tax Franchise Fees FP&L Total Permits, Fees, & Special Assessments Intergovernmental Statel Revenue Sharing Program Dist Alcoholic Bev License Fees Local Governml/2 Cent Sales Tax Disc. Infrastructure Sales Tax Total Intergovernmental Judgments, Fines & Forfeitures Fines & Forfitures Total. Judgments, Fines & Forfeitures Miscellaneous Revenue Interest Income Garden Club Donations Donations- POA Donations- - Miscellaneous Proceeds from Sale ofCapital Assets Miscellaneous Reimbursements Total Miscellaneous Revenue Total Revenues 1,205 1,000 205 544 500 44 1,990 1,800 190 949,600 943,300 2,784 2,500 284 79 79 44 25 19 3,840 3,500 340 6,747 6,025 722 979 900 79 3,363 3,000 363 2,627 2,500 127 6,969 6,400 569 3,512 3,000 1,600 1,200 5,819 5,500 18,822 18,000 822 400,000 381,178 484 484 2,250 154 100 54 2,750 44 30 14 3,000 13,711 12,500 1,211 41,334 2,936 2,800 136 10,994 175 9,652 9,000 652 36,483 9,043 9,000 43 36,000 21,631 20,800 831 83,652 150 150 3,321 250 3,071 1,000 2,250 2,100 150 5,000 2,000 1,500 1,500 5,000 292 250 42 5,000 7,363 2,600 4,763 18,000 512 13,851 400 6,385 319 21,089 10,339 4,785 15,270 6,300 2,183,492 2,159,700 23,792 2,597,838 414,346 (484) 2,250 2,596 2,956 27,623 33,215 30,630 2,585 449,334 416,119 8,058 175 26,831 26,957 62,021 150 150 (2,321) 2,750 2,000 (1,500) 5,000 4,708 10,637 2,250 2,000 1,000 292 3,542 250 1,000 200 92 2,200 1,342 966,858 $ 957,925 $ 8,933 $ 2,245,701 $ 2,213,730 $ 31,971 $ 3,148,974 S 903,273 2 TOWN OF. JUPITER INLET COLONY, FLORIDA Schedule of Revenues and Expenditures Budget and Actual General Fund For the Three! Months Ended December. 31,2022 December 31,2022 Actual $ Year To Date Annual Annual Budget 6,290 $ 6,290 $ 19,595 $ 19,595 $ $ 81,965 $ 62,370 4,278 4,278 13,330 13,330 55,769 42,439 3,829 3,829 11,929 11,929 49,924 37,995 20,000 20,000 481 481 1,684 1,684 6,270 4,586 327 327 1,146 1,146 4,266 3,120 293 293 1,025 1,025 3,819 2,794 1,421 4,000 2,579 4,263 8,000 3,737 9,836 5,573 1,545 (1,545) 6,692 5,147 5,991 5,991 5,141 5,500 359 23,139 16,500 (6,639) 65,388 42,249 167 200 33 475 400 (75) 7,416 6,941 214 250 36 (748) 500 1,248 25,689 26,437 275 275 2,500 2,500 2,825 3,000 175 11,050 12,000 950 50,000 38,950 575 1,000 425 3,000 2,425 6,369 3,000 (3,369) 5,000 (1,369) 13,500 13,500 6,300 5,500 (800) 11,800 11,000 (800) 65,000 53,200 1,266 1,300 34 3,799 4,000 201 18,000 14,201 633 800 167 1,861 1,000 (861) 12,500 10,639 9,432 9,167 (265) 27,958 27,501 (457) 110,000 82,042 1,667 500 (1,167) 5,000 1,000 (4,000) 2,000 (3,000) 3,113 3,300 187 8,196 7,000 (1,196) 22,000 13,804 398 500 102 1,325 1,000 (325) 5,000 3,675 184 250 66 1,359 500 (859) 5,000 3,641 201 300 99 2,300 2,099 5,468 1,200 (4,268) 16,405 2,400 (14,005) 8,000 (8,405) 736 900 164 2,208 1,600 (608) 8,400 6,192 500 500 2,500 2,500 500 500 450 450 2,000 (168) 850 850 5,500 3,512 12,000 12,000 Budget Variance YTD/ Actual YTD Budget YTD Variance Budget Remaining EXPENDITURES Administration Salary Admin. Officer Payroll Town Clerk Salary Admin, Secretary Code Enforcement Officer Payroll Taxes Admin. Officer Payroll Taxes Admin. Secy. P/R Taxes" Town Clerk Retirement Retirement Town Clerk Retirement- Admin. Secy Health Dental STD, Life, Accident Workers Comp. Codification Legal Legal Advertisments Professional Services - Other Professional Services Auditor Professional Services- - Finance Professional Services- ADPI HR Custodian/Pest Control Refuse/Recycling Collection Code Enforcement Tesplone-mtemewebic Utilities (Electric) Copy Machine Postage Meter Liability Insurance Property & Flood Notary Insurance Equipment & Repairs Miscellaneous Equip. Rentals Other Maintenance Building Maintenance Propane Gas/Generator Maint Memberships Travel Misc. Government 690 800 421 500 110 79 2,168 1,988 1,000 (1,168) 1,000 (988) 25,617 2,500 (23,117) 56,569 5,000 (51,569) 20,000 (36,569) 3 TOWN OF. JUPITER INLET COLONY, FLORIDA Schedule of Revenues and Expenditures Budget and Actual General Fund For the' Three Months Ended December. 31,2022 December. 31,2022 Actual $ Year Tol Date Annual Annual Budget $ $ $ $ $ $ 8,500 $ 8,500 316 400 84 669 850 181 5,000 392 600 208 1,034 750 (284) 7,000 1,000 10,000 500 500 189 1,000 811 20,000 85,509 5,412 2,500 1,557 2,000 443 7,729 15,000 350 500 150 700 2,300 1,800 1,000 191 42 (149) 569 500 3,300 7,142 Budget Variance YTD Actual YTD Budget YTD Variance Budget Remaining EXPENDITURES (continued) Administration (continued) Municipal Election Office Supplies Office Equipment/Soflware Office Fumiture Training And Auto Mileage Capital Outlay Principal Payment Interest Expenditures Aid" Tol Private Organizations Social Committee Inlet/Outlet Directory Special Events Bank Charges NRP. Assessment Underground Annual. Assessment Total Adminstration Planning Npdes (Agrmt & Consult) Comprehensivel Planning Engineer Total Planning 4,331 5,966 1,000 10,000 19,811 85,509 5,412 2,500 7,271 1,600 1,800 1,000 (69) 3,300 7,142 23,525 5,000 40,000 68,525 5,000 (2,729) 500 (200) 84 (485) 83,997 59,707 (24,290) 252,170 162,594 (89,576) 895,763 643,593 2,475 2,475 (2,475) 26,000 5,000 40,000 (2,475) 71,000 TOWN OF. JUPITER INLET COLONY, FLORIDA Schedule of Revenues and Expenditures Budget and Actual General Fund For the' Three Months Ended December. 31,2 2022 December 31,2022 Actual $ Year" Tol Date Annual Annual Budget Budget Variance YTD/ Actual YTD Budget YTD' Variance Budget Remaining 16,286 $ 16,500 $ 214 $ 54,622 $ 58,000 $ 3,378 $ 216,139 $ 161,517 EXPENDITURES (continued) Police Salaries Salaries-Patrol, Traffic Enf. & Investagate Salary Incentive Payroll Taxes Patrol Payroll Taxes Police Admin. Retirement Health Dental STD, Life, Accident Worker's Comp. Dispatch Professional: Services Telephone/nteret Custodian/Pest Control Liability Insurance Autol Insurance Auto Repairs & Maint. Utilities (Water) Gas &Oil Equip. Repair & Maint. Memberships PS Miscellaneous Office Supplies Ammo, Uniforms, Dues Computer Maintenance Training Public Safety Capital Outlay General Equipment Security Cameras Total Police Fire Control Tequesta Fire-Rescue Total Fire Control 25,500 26,000 500 363 500 137 1,381 1,800 419 5,160 1,961 2,000 39 6,183 7,000 817 22,747 1,263 1,500 237 4,640 5,000 360 16,535 51,682 5,825 6,000 175 25,086 25,000 (86) 88,494 408 500 92 1,224 1,500 276 4,472 12,268 1,683 2,500 817 5,048 5,500 452 19,868 11,893 12,000 107 44,376 550 (550) 2,000 1,470 1,500 30 4,101 3,000 (1,101) 7,500 7,676 7,500 (176) 23,028 21,000 (2,028) 88,000 210 300 90 631 750 119 3,500 970 1,000 30 6,708 5,000 (1,708) 6,000 1,095 1,200 105 4,690 6,000 1,310 22,800 124 200 76 2,601 2,000 (601) 2,500 335 400 65 2,302 2,400 98 3,500 1,981 333 (1,648) 9,605 667 (8,938) 4,000 2,106 2,500 394 2,106 3,000 894 5,000 1,772 1,800 28 5,669 6,000 331 15,000 8,379 8,400 21 8,483 9,000 517 16,000 9,658 12,000 2,342 50,000 248 250 2 248 500 252 4,000 8,509 3,000 (5,509) 12,500 72,003 75,000 2,997 297,346 225,343 3,779 16,564 11,895 51,682 63,408 3,248 12,268 14,820 32,483 1,450 3,399 64,972 2,869 (708) 18,110 (101) 1,198 (5,605) 2,894 9,331 7,517 40,342 3,752 3,991 79,655 80,883 1,228 270,969 265,117 (5,852) 1,021,387 750,418 40,555 40,555 40,555 40,555 121,665 121,665 121,665 121,665 486,661 364,996 486,661 364,996 5 TOWNOFJUPITER INLET COLONY, FLORIDA Schedule of Revenues and Expenditures Budget and Actual General Fund For the' Three Months Ended December. 31,2022 December 31,2022 Actual $ Year Tol Date Annual Annual Budget Budget Variance YTD Actual YTD Budget YTD Variance Budget Remaining EXPENDITURES (continued) Building Official Professional Services Inspections Zoning Consultant Services Buidling Official Services Total Building Official Beautification Utilities (Water) Maintenance- Other Repalirs/mprovements Landscape Maintenance Fbwe.San.bafTres.Muah Other Expenses Total Beautification Roads & Walkways Walkways Repair Repair/HardscapelSigns Drains Cleaning Other Totall Roads & Walkways Surtax Expenditures Capital Outlay- -Surtax Vehicles/Equipment Total Surtax Expenditures $ $ $ 1,615 $ 3,785 4,000 215 13,187 14,000 5,358 6,000 642 14,040 15,000 9,143 10,000 857 28,843 29,000 1,152 1,500 348 4,759 5,000 2,599 3,000 401 5,989 6,000 2,729 3,000 271 13,377 14,500 4,548 5,000 452 15,281 16,000 3,119 3,500 381 7,187 8,500 1,313 $ (1,615) $ 10,000 $ 8,385 813 110,000 960 78,000 157 198,000 169,157 241 18,000 11 36,000 1,500 1,123 30,000 719 30,000 20,000 3,407 135,500 96,813 63,960 13,241 30,011 1,500 16,623 14,719 12,813 88,907 600 1,500 3,000 9,000 14,100 (31,649) (31,649) 14,147 16,000 1,853 46,593 50,000 600 1,500 3,000 9,000 14,100 9,978 9,978 (9,978) 31,649 (9,978) 31,649 (31,649) (31,649) Total Expenditures and Transfers Out Excess (deficiency) of revenues over (under) expenditures and transfers out 237,475 207,145 (30,330) 754,364 628,376 (125,988) 2,822,411 2,068,047 729,383 S 750,780 $ (21,397) $ 1,491,337 $ 1,585,354 s (94,017) $ 326,563 $ (1,164,774) 6 Town of. Jupiter Inlet Colony, Florida Cash Balances December 31, 2022 Account Balance $ 2,361,146 114,727 89,205 10,006 2,575,084 228,126 3,516 50,771 954,871 $ 1,009,158 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 $ $ $ $ 199,826 30,992 $ 4,043,186 7 Town of Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended December 31,2022 Date 12/01/2022 12/01/2022 12/01/2022 12/02/2022 12/02/2022 12/02/2022 12/02/2022 12/02/2022 12/02/2022 12/02/2022 12/02/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/06/2022 12/07/2022 12/07/2022 12/07/2022 12/07/2022 Check Number/Ref.# 9402 9404 9405 9406 9407 9408 9409 9410 9411 9412 9413 9415 9416 9417 9418 9419 9420 9421 9422 9423 9424 9425 9426 9427 9428 9429 9430 9431 9432 9433 9434 9435 9436 9437 9438 9439 9440 9441 9442 9443 9445 9446 9447 9448 Vendor Amount $ 6,300.00 1,169.84 169.64 32.07 370.00 661.36 185.06 288.86 292.00 314.55 248.00 128.00 2,825.00 225.00 126.93 4,075.00 110.00 7,480.00 75.00 258.27 9,978.38 31,547.25 400.00 400.00 250.00 175.00 175.00 175.00 175.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 623.88 9,431.94 119.85 311.92 368.88 17.60 General Fund Checking Richard Hartley, CPA Teryn Weintz Heather Rotondi Jan Gardiner Lubyn Limenez Verizon Wireless Elizabeth Hailman AT&T2 Daniel Comerford communication international It-Smarts It-Smarts Caldwell Pacetti Edwards Schoech & Viator Palm Beach County Assoc. ofPolice Chiefs Manno Uniforms Ocean Breeze Lawn Maintenance, Inc. Tequesta Tire Company, Inc. Samuel J. Pruitt Mailroute, Inc. Quadient Finance USA, Inc communication international Florida Municipal Insurance Trust Samuel J. Pruitt Kevin Lucas Ivelisse Chico-Randazzo kathi Cornelius Richard Roberts Robert Schultz James Matthews Anthony Lutz Robert Beckmann Robert Curry William Aguillon Jonathan Folbrecht Raymond Desmarais Michael Blake Steven Huskission parrett Daniel Delta Dental Waste Management of! Martin County Unlimited Auto WashClub Metro Embroidery Petty Cash Receipts Thel Police and Sheriffs Press 8 Town of. Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended December 31, 2022 General Fund Checking (continued) Georgia Clinic Pc Team Plan Inc t-Smarts Robert Schultz ICMA The Police and Sheriffs Press Emerald Gardens Pest Control Polar Engraving Strobes-R-Us Ocean Breezel Lawn Maintenance, Inc. Tequesta Tire Company, Inc. Blue360 Media RCB Electric, Co. Inc. Diversifield Building Department Triple MI Brick Pavers, Inc. Rood-Willams Post 271 It-Smarts B.P, ELECTRIC INC. Billfish It-Smarts Steven Huskission TDI Bank It-Smarts Rood-Willams Post 271 John Walsh CML pressure washing services Verizon Wireless Alert Media Ubermac Catherine Sanchez CivicPlus Ocean Breeze Lawn Maintenance, Inc. Kyocera Document Solutions LLC AT&T2 Nozzlel Nolen, Inc. AFLAC CEA Building Group It-Smarts Lubyn Limenez Ocean Breeze Lawn Maintenance, Inc. Florida Power and Light Village ofTequesta Minuteman Press It-Smarts Date 12/07/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/13/2022 12/15/2022 12/15/2022 12/15/2022 12/15/2022 12/15/2022 12/15/2022 12/20/2022 12/20/2022 12/20/2022 12/21/2022 12/21/2022 12/21/2022 12/21/2022 12/22/2022 12/28/2022 12/28/2022 12/28/2022 12/28/2022 12/28/2022 12/28/2022 12/28/2022 12/28/2022 12/28/2022 12/28/2022 12/29/2022 12/29/2022 12/20/2022 12/20/2022 12/20/2022 12/20/2022 Check Number/Ret. # 9449 9450 9451 9452 9453 9454 9455 9456 9457 9458 9459 9460 9461 9462 9463 9464 9465 9466 9467 9468 9479 9480 9482 9483 9484 9485 9486 9487 9488 9489 9490 9491 9492 9493 9494 9495 9496 9497 9498 9499 9500 9501 9502 9503 Vendor Amount 898.83 3,784.80 972.00 156.54 421.20 17.60 200.00 85.07 123.80 900.00 100.51 185.64 6,500.00 5,357.50 2,500.00 1,200.00 208.00 4,500.00 2,826.00 208.00 310.82 8,453.15 208.00 912.50 1,400.00 690.00 1,778.59 6,084.00 35.00 350.00 1,590.46 4,282.00 183.67 264.63 251.00 83.59 1,100.00 168.00 270.00 920.00 397.82 1,151.51 214.25 88.00 9 Town ofJ Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended December 31,2022 General Fund Checking (continued) Tequesta Fire Rescue Staples Esthela N. Lucas Velasquez Nozzle Nolen, Inc. Ocean Breeze Lawn Maintenance, Inc. Comcast Florida Blue Ins. Davison Fuels & Oill LLC Florida Municipal Pension Trust Davison Fuels & Oil LLC ADP, Inc. TD Bank ADP, Inc. Davison Fuels & Oil LLC Davison Fuels & Oil LLC Apple, Inc. ADP, Inc. Date 12/20/2022 12/20/2022 12/20/2022 12/20/2022 12/20/2022 12/20/2022 12/01/2022 12/05/2022 12/12/2022 12/12/2022 12/14/2022 12/15/2022 12/28/2022 12/07/2022 12/27/2022 12/05/2022 12/10/2022 Check Number/Ref. # 9504 9505 9506 9507 9508 9509 ACH Debit ACH Debit ACH Debit ACH Debit ACH Debit ACH Debit ACH Debit CL37732 CL40104 ACH Debit ACH Debit Vendor Amount 121,665.29 101.26 300.00 251.00 2,818.00 1,663.40 10,965.60 451.95 15,076.61 256.90 30,304.34 190.81 30,304.34 93.48 292.53 75.00 1,266.29 358,568.56 Total Disbursements- - General Fund Checking 10 Town of. Jupiter Inlet Colony, Florida Check Register andl Bank Debits For the Month Ended December 31,2022 Date 12/01/2022 12/01/2022 Check Number/Ref.: # ACH Debit ACHI Debit Vendor Amount 61,435.96 42,104.90 103,540.86 Sewer Project Fund Checking TDI Bank TDI Bank Total Disbursements- Sewer Project Fund Checking Underground Fund Checking No checks issued in current month Total Disbursements- Underground Fund Checking $ 11