Inlet er CaS Esfablshed1959 Florida Schedule of Revenues and Expenditures Budget and Actual General Fund (Unaudited) Cash Balances January 31, 2023 Forthe. Four Months Ended January 31,2023 Check Register & Bank Debits For the Month Ended January 31, 2023 TOWN OF JUPITER INLET COLONY, FLORIDA Schedule of Revenues and Expenditures Budget and Actual General Fund For the Four Months Ended January 31,2023 January31,2023 Actual $ Year Tol Date Budget Variance YTD Actual YTDI Budget YTD Variance Ann Bgt Ann Bgt Rem 42,014 $ 38,443 $ 3,571 2,225,507 $ 2,221,627 $ 3,880 $ 2,597,838 $ 372,331 REVENUES Taxes Permits, Fees, & Special Assessments Intergovemmental Judgments, Fines & Forfeitures Miscellaneous Revenue 17,037 16,112 925 7,134 6,971 163 10 13 (3) 11,729 1,501 10,228 77,924 54,576 908 73,811 40,555 9,599 37,801 50,251 48,448 28,764 27,884 10 52 20,791 6,004 1,803 880 (42) 14,787 449,334 399,083 83,652 54,888 150 150 18,000 (2,791) Total Revenues 63,040 14,884 2,325,323 2,304,015 21,308 3,148,974 823,661 EXPENDITURES Administration Planning Police Fire Control Building Official Beautification Roads & Walkways Surtax Expenditures 76,498 21,922 2,584 1,676 98,666 24,855 40,555 16,500 6,901 42,292 4,491 1,175 1,175 249,436 315,303 3,383 10,336 354,724 376,754 162,220 162,220 24,923 66,000 99,746 108,168 4,700 26,639 35,000 65,867 6,953 41,077 8,422 4,700 8,361 950,276 700,840 71,000 486,661 324,441 198,000 173,077 198,500 14,100 35,000 67,617 22,030 1,055,687 700,963 98,754 14,100 8,361 Total Expenditures Transfer Out 217,250 278,270 61,020 921,071 1,078,481 157,410 3,009,224 2,088,153 Total Expenditures and' Transfers Out Excess (deficiency) of revenues over (under) expenditures and transfers out 217,250 278,270 61,020 921,071 1,078,481 157,410 3,009,224 2,088,153 $ (139,326) $ (215,230) $ 75,904 1,404,252 $ 1,225,534 $ 178,718 $ 139,750 $(1,264,492) TOWNO OF JUPITER INLET COLONY, FLORIDA Schedule of Revenues and Expenditures Budget and Actual General Fund For thel Four Months Ended. January 31,2023 January 31,2023 Actual $ Year To Date Annual Annual Budget Budget Variance YTD Actual YTD Budget YTD Variance Budget Remaining 38,294 $ 35,000 $ 3,294 $ 2,210,855 $ 2,207,855 $ 3,000 $ 2,556,513 $ 345,658 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 Intergoveramental State 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,237 1,154 83 553 532 21 1,930 1,757 173 13,003 12,000 1,003 376 376 (860) 188 (188) 2,250 50 229 (179) 2,546 54 250 (196) 2,902 3,554 3,445 109 24,069 17,037 16,112 925 979 916 63 3,914 3,664 250 10,994 7,080 15 (15) 60 (60) 175 175 3,428 3,040 388 13,080 12,160 920 36,483 23,403 2,727 3,000 (273) 11,770 12,000 (230) 36,000 24,230 7,134 6,971 163 28,764 27,884 880 83,652 54,888 13 (13) 52 (52) 150 150 10 13 (3) 10 52 (42) 150 150 4,886 83 4,803 12,448 332 12,116 1,000 (11,448) 6,700 417 6,283 6,700 1,668 5,032 5,000 (1,700) 167 (167) 668 (668) 2,000 2,000 1,500 1,500 (1,500) 417 (417) 1,668 (1,668) 5,000 5,000 143 417 (274) 143 1,668 (1,525) 5,000 4,857 11,729 1,501 10,228 20,791 6,004 14,787 18,000 (2,791) 4,749 4,616 133 13,851 2,154 2,128 26 6,385 7,749 7,028 721 21,089 3,880 2,597,838 372,331 31,824 32,000 (176) 400,000 368,176 860 860 752 (752) 2,250 204 916 (712) 2,750 98 1,000 (902) 3,000 9,102 4,231 13,340 42,014 38,443 3,571 2,225,507 2,221,627 17,265 13,780 3,485 41,334 50,251 48,448 1,803 449,334 399,083 $ 77,924 $ 63,040 $ 14,884 $ 2,325,323 $ 2,304,015 S 21,308 $3,148,974 $ 823,661 2 TOWNOFJUPITER INLET COLONY,FLORIDA Schedule ofl Revenues and Expenditures Budget and Actual General Fund For the Four Months Ended. January31,2023 January31,2023 Actual $ Year To Date Annual Annual Budget Budget Variance YTD Actual YTD Budget YTD Variance Budget Remaining 6,290 $ 6,830 $ 540 $ 25,885 $ 27,320 $ 1,435 $ 81,965 $ 56,080 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 Codel Enforcement Traephome-lntema/Websic Utilities (Electric) Copy Machine Postage Meter Liability Insurance Property & Flood Notary Insurance Equipment &1 Repairs Miscellaneous Equip. Rentals Other Maintenance Building Maintenance Propane Gas/Generator Maint Memberships Travel Misc. Government 4,278 4,647 369 17,608 18,588 980 55,769 38,161 3,829 4,160 331 15,758 16,640 882 49,924 34,166 481 523 42 2,165 2,092 (73) 6,270 4,105 327 356 29 1,473 1,424 (49) 4,266 2,793 293 318 25 1,318 1,272 (46) 3,819 2,501 820 820 2,719 4,460 1,741 21,016 18,297 558 558 1,545 2,232 687 6,692 5,147 499 499 1,996 1,996 5,991 5,991 20,922 21,796 874 65,388 44,466 167 618 451 641 2,472 1,831 7,416 6,775 3,761 4,141 380 7,152 12,564 5,412 29,689 22,537 23 23 92 92 275 275 208 208 832 832 2,500 2,500 1,800 4,167 2,367 8,025 8,668 643 50,000 41,975 250 250 575 1,000 425 3,000 2,425 6,252 7,000 748 9,281 10,583 1,302 11,000 1,719 13,500 13,500 7,600 8,000 400 19,400 24,251 4,851 65,000 45,600 1,301 1,500 199 5,100 6,000 900 18,000 12,900 570 1,042 472 2,431 4,168 1,737 12,500 10,069 9,432 9,500 68 28,296 37,001 8,705 110,333 82,037 1,667 1,833 166 6,667 7,332 665 22,000 15,333 270 2,000 1,730 10,596 10,500 (96) 22,000 11,404 393 417 24 1,295 1,668 373 5,000 3,705 413 417 4 1,772 1,668 (104) 5,000 3,228 192 192 201 768 567 2,300 2,099 631 4,000 3,369 2,524 6,000 3,476 8,000 5,476 736 700 (36) 2,944 2,800 (144) 8,400 5,456 42 42 168 168 500 500 208 208 11,180 12,832 1,652 14,500 3,320 42 42 168 168 500 500 38 38 152 152 450 450 83 167 84 2,252 2,668 416 4,000 1,748 71 71 284 284 850 850 458 458 1,988 1,832 (156) 5,500 3,512 1,000 1,000 292 4,000 3,708 12,000 11,708 1,742 2,667 925 19,542 19,668 126 33,000 13,458 3 TOWNOFJUPITER INLET COLONYFLORIDA Schedule of! Revenues and Expenditures Budget and Actual General Fund For the Four Months Ended. January31,2023 January3 31,2023 Actual $ Year Tol Date Annual Annual Budget Budget Variance YTD Actual YTD Budget YTD' Variance Budget Remaining EXPENDITURES (continued) Administration (continued) Municipal Election Office! Supplies Office Equipment/Soflware Office Furniture Training. And Autol Mileage Capital Outlay Principal Payment Interest Expenditures Aid1 Tol Private Organizations Social Committee Inlet/Outlet Directory Special Events Bank Charges NRP Assessment Underground. Annual. Assessment Total. Adminstration Planning Npdes (Agrmt & Consult) Comprehensive Planning Engineer Total Planning $ 708 $ 708 $ 417 (66) 1,335 1,668 333 5,000 583 (478) 1,585 2,332 747 7,000 83 83 332 332 1,000 833 833 3,332 3,332 10,000 1,667 1,667 189 6,668 6,479 20,000 85,509 5,412 208 208 832 832 2,500 616 1,250 634 8,345 8,000 (345) 15,000 100 192 92 800 768 (32) 2,300 150 150 600 600 1,800 83 83 332 332 1,000 42 42 569 168 (401) 500 275 275 1,100 1,100 3,300 595 595 2,380 2,380 7,142 908 2,167 1,259 26,000 417 417 5,000 40,000 908 2,584 1,676 71,000 $ 2,832 $ 2,832 $ 8,500 $ 8,500 483 1,061 3,665 5,415 1,000 10,000 19,811 85,509 5,412 2,500 6,655 1,500 1,800 1,000 (69) 3,300 7,142 22,617 5,000 40,000 67,617 54,576 76,498 21,922 249,436 315,303 65,867 950,276 700,840 3,383 8,668 5,285 1,668 1,668 3,383 10,336 6,953 TOWN OFJUPITER INLET COLONY,FLORIDA Schedule ofl Revenues and Expenditures Budget and. Actual General Fund For thel Four Months Ended. January31,2023 January31,2023 Actual $ YearToDate Annual Annual Budget Budget Variance YTDActual YTDI Budget YTD Variance Budget Remaining 16,964 $ 18,012 $ 1,048 $ 70,999 $ 72,048 $ 1,049 $ 216,139 $ 145,140 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/Internet Custodian/Pest Control Liability Insurance Auto Insurance Autol 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 Totall Police Fire Control Tequesta Fire-Rescue Total Fire Control 27,578 27,779 201 474 500 26 1,911 1,790 (121) 5,160 2,129 1,896 (233) 8,137 7,584 (553) 22,747 1,315 1,378 63 6,007 5,512 (495) 16,535 4,307 4,307 10,813 17,228 6,415 51,682 961 7,375 6,414 23,902 29,500 5,598 88,494 830 1,373 543 2,054 2,492 438 5,472 985 1,000 15 2,136 4,000 1,864 21,268 1,683 1,656 (27) 6,730 6,624 (106) 19,868 3,698 3,698 15,591 14,792 (799) 44,376 570 167 (403) 2,385 668 (1,717) 2,000 1,105 625 (480) 4,718 2,500 (2,218) 7,500 701 (701) 7,256 12,333 5,077 29,023 34,332 5,309 88,000 210 292 82 841 1,168 327 3,500 275 500 225 6,864 7,000 136 11,000 216 (216) 1,833 1,900 67 6,866 7,600 734 22,800 248 208 (40) 2,849 3,132 283 4,800 292 292 2,284 1,168 (1,116) 3,500 209 333 124 9,814 1,332 (8,482) 4,000 502 500 (2) 824 1,500 676 1,500 727 1,417 690 2,833 3,168 335 6,500 2,240 3,250 1,010 7,399 9,000 1,601 19,000 1,333 1,333 8,483 8,332 (151) 16,000 4,167 4,167 9,658 16,668 7,010 50,000 144 333 189 392 1,332 940 4,000 1,875 2,042 167 10,235 11,168 933 19,500 40,555 40,555 162,220 162,220 40,555 40,555 162,220 162,220 97,233 102,116 4,883 297,346 200,113 3,249 14,610 10,528 40,869 64,592 3,418 19,132 13,138 28,785 (385) 2,782 (701) 58,977 2,659 4,136 (216) 15,934 1,951 1,216 (5,814) 676 3,667 11,601 7,517 40,342 3,608 9,265 73,811 98,666 24,855 354,724 376,754 22,030 1,055,687 700,963 486,661 324,441 486,661 324,441 5 TOWN OF JUPITER INLET COLONY, FLORIDA Schedule of Revenues and Expenditures Budget and Actual General Fund For thel Four Months Ended. January: 31,2023 January 31,2023 Actual $ Year To Date Annual Annual Budget Budget Variance YTD Actual YTD Budget YTD Variance Budget Remaining $ 833 $ 833 $ 1,615 $ 3,332 $ 1,717 $ 10,000 $ 8,385 EXPENDITURES (continued) Building Official Professional Services Inspections Zoning Consultant Services Buidling Official Services Totall Building Official Beautification Utilities (Water) Maintenance- Other Repairs/mprovements Landscape Maintenance Park Improvements FoweShn.haTres.Much Other Expenses Total Beautification Roads & Walkways Walkways Repair Repain/andsapeSigns Drains Cleaning Other Total Roads & Walkways Surtax Expenditures Capital Outlay -Surtax Vehicles/Equipment Total Surtax Expenditures 3,960 9,167 5,207 5,639 6,500 861 9,599 16,500 6,901 6,788 6,500 (288) 1,203 3,000 1,797 125 125 1,263 2,500 1,237 24,012 25,000 988 2,106 2,500 394 2,429 2,667 238 37,801 42,292 4,491 50 50 125 125 250 250 750 750 1,175 1,175 10,197 36,668 26,471 13,111 26,000 12,889 110,000 78,000 99,803 64,889 11,453 28,808 1,500 15,360 5,835 20,414 15,384 98,754 600 1,500 3,000 9,000 14,100 8,361 8,361 24.923 66,000 41,077 198,000 173,077 11,547 11,000 (547) 23,000 7,192 12,000 4,808 36,000 500 500 1,500 14,640 10,000 (4,640) 30,000 44,165 50,000 5,835 50,000 12,586 13,000 414 33,000 9,616 11,668 2,052 25,000 99,746 108,168 8,422 198,500 200 200 500 500 1,000 1,000 3,000 3,000 4,700 4,700 600 1,500 3,000 9,000 14,100 35,000 35,000 26,639 35,000 8,361 26,639 35,000 8,361 Total Expenditures and' Transfers Out Excess (deficiency) of revenues over (under) expenditures and transfers out 217,250 278,270 61,020 921,071 1,078,481 157,410 3,009,224 2,088,153 (139,326) s (215,230) s 75,904 S 1,404,252 s 1,225,534 s 178,718 s 139,750 $ (1,264,492) 6 Town of. Jupiter Inlet Colony, Florida Cash Balances January 31,2023 Account Balance $ 2,255,112 115,143 89,544 10,081 $ 2,469,880 $ $ 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 228,953 3,529 50,955 970,845 $ 1,025,329 $ $ 204,226 33,719 $ 3,962,107 7 Town ofJ Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended January 31,2023 General Fund Checking Village ofTequesta It-Smarts U.S. Bank Equipment Finance Rocky's Ace Hardware Sixberry, Inc. Locksmith Diversifield Building Department Kimley Hom Ocean Breeze Lawn Maintenance, Inc. MCD Sprinklers Team Plan Inc It-Smarts Teryn Weintz Thel Handyman It-Smarts Date 01/04/2023 01/04/2023 01/04/2023 01/04/2023 01/04/2023 01/04/2023 01/04/2023 01/04/2023 01/04/2023 01/04/2023 01/05/2023 01/05/2023 01/05/2023 01/05/2023 01/09/2023 01/09/2023 01/09/2023 01/09/2023 01/09/2023 01/09/2023 01/09/2023 01/09/2023 01/09/2023 01/09/2023 01/09/2023 01/10/2023 01/10/2023 01/10/2023 01/10/2023 01/11/2023 01/12/2023 01/12/2023 01/17/2023 01/17/2023 01/18/2023 01/18/2023 01/18/2023 01/18/2023 01/18/2023 01/18/2023 01/18/2023 01/18/2023 01/19/2023 01/19/2023 Check Number/Ref.# 9500 9501 9502 9503 9504 9505 9506 9507 9508 9509 9510 9511 9512 9513 9514 9515 9516 9517 9518 9519 9520 9521 9522 9523 9524 9525 9526 9527 9528 9529 9530 9531 9532 9533 9534 9535 9536 9537 9538 9539 9540 9541 9542 9543 Vendor Amount $ 5,000.00 1,309.00 227.71 83.28 209.00 5,638.75 3,416.87 1,700.00 5,100.00 3,959.80 88.00 616.00 1,500.00 9,431.94 296.00 11,094.00 119.85 300.00 1,550.00 1,800.00 907.50 7,305.90 1,046.07 3,200.00 270.00 241.94 324.98 514.88 648.70 441.79 208.00 901.00 570.00 1,160.00 501.65 5,169.28 7,833.00 392.91 98.05 543.56 230.94 248.00 20.00 408.00 Waste Management ofl Martin County City ofl Palm Beach Gardens Unlimited Auto WashClub Esthela N. Lucas Velasquez Ocean Breeze Lawn Maintenance, Inc. Caldwell Pacetti Edwards Schoech & Viator Pro-Sweep Combined Insurance Company Delta Dental B.P, ELECTRIC: INC. Emerald Gardens Pest Control National Document Solution LLC Petty Cash Receipts Jonathan Folbrecht Kevin Lucas Colony Garden Club It-Smarts United. American Insurance Company Earl E. Griffith, Ph.D. Ocean Breeze Lawn Maintenance, Inc. Staples Credit Plan TDI Bank Woodland Landscaping Florida Power and Light Georgia Clinic Pc Polar Engraving Loxahatchee River District It-Smarts Comcast It-Smarts 8 Town of. Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended January 31,2023 General Fund Checking (continued) It-Smarts Village of Tequesta Woodland Landscaping Richard Hartley, CPA Guardinan Hawk Security Floridian Signs Ocean Breeze Lawn Maintenance, Inc. AFLAC AT&T2 Verizon Wireless kathi Cornelius It-Smarts Tequesta Tire Company, Inc. Mag Instrument Tequesta Tire Company, Inc. Mix Net Work Source inc It-Smarts Petty Cash Receipts Kimley Horn It-Smarts Jeff Biege Tequesta Tire Company, Inc. Kyocera Document Solutions LLC It-Smarts Jonathan Folbrecht Davison Fuels & OilLLC Davison Fuels & Oil LLC Davison Fuels & Oil LLC ADP, Inc. Florida Blue Ins. Davison Fuels & OilLLC Davison Fuels & Oill LLC Davison Fuels & Oil LLC Date 01/24/2023 01/24/2023 01/24/2023 01/24/2023 01/24/2023 01/24/2023 01/24/2023 01/24/2023 01/24/2023 01/24/2023 01/25/2023 01/25/2023 01/25/2023 01/25/2023 01/25/2023 01/25/2023 01/26/2023 01/26/2023 01/26/2023 01/27/2023 01/27/2023 01/27/2023 01/27/2023 01/27/2023 01/24/2023 01/03/2023 01/09/2023 01/09/2023 01/11/2023 01/20/2023 01/17/2023 01/23/2023 01/29/2023 01/05/2023 01/10/2023 01/25/2023 Check Number/Ref. # 9546 9548 9549 9550 9551 9552 9553 9554 9555 9556 9557 9558 9559 9560 9561 9562 9563 9564 9565 9566 9567 9568 9569 9570 43916 ACH Debit ACH Debit ACH Debit ACH Debit ACH Debit CL42862 CL43914 CL44570 Rec-ACH Debit Apple, Inc. Rec-ACH Debit ADP, Inc. Rec-ACH Debit ADP, Inc. Total Disbursements- General Fund Checking Vendor Amount 288.00 1,456.62 12,978.81 7,600.00 1,874.91 15.00 1,605.85 83.59 265.07 1.48 77.74 168.00 10.40 143.64 91.49 180.31 128.00 142.55 2,834.99 408.00 100.00 67.41 185.44 833.00 462.73 318.28 363.18 52.50 31,948.35 863.26 267.36 402.58 337.88 75.00 1,301.17 31,746.07 186,305.01 9 Town of Jupiter Inlet Colony, Florida Check Register and Bank Debits For the Month Ended January 31,2023 Date Check Number/Ref.# Vendor Amount Sewer Project Fund Checking 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