Loading...
HomeMy WebLinkAbout2024-05 May Combined FinancialsNI TROPHY CLUB MUNICIPAL UTILITY DISTRICT Trophy Club Municipal Utility District No. 1 Check Report By Check Number Date Range: 04/01/2024 - 04/30/2024 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank -Prosperity Bank 3298 308 Construction LLC 04/08/2024 Regular 0.00 29,185.17 10304 3045 3RD Eye Surveillance LLC 04/08/2024 Regular 0.00 349.00 10305 3127 Allied Welding Supply Inc. 04/08/2024 Regular 0.00 27.12 10306 1005 Atlas Utility Supply Co. 04/08/2024 Regular 0.00 47,150.00 10307 4018 BP Energy Holding Company LLC 04/08/2024 Regular 0.00 37,196.26 10308 1030 City of Fort Worth 04/08/2024 Regular 0.00 4,953.00 10309 2655 Core & Main LP 04/08/2024 Regular 0.00 1,382.20 10310 3184 Dataprose LLC 04/08/2024 Regular 0.00 4,889.05 10311 2804 Fortiline Inc. 04/08/2024 Regular 0.00 6,102.00 10312 2788 G -Force Parking Lot Striping 04/08/2024 Regular 0.00 1,966.50 10313 4004 lnsituform Technologies LLC 04/08/2024 Regular 0.00 70,995.00 10314 2808 J&J Ramirez Tree Trimmers LLC 04/08/2024 Regular 0.00 2,000.00 10315 2943 JP Morgan Chase Bank NA 04/08/2024 Regular 0.00 8,906.89 10316 3179 NewGen Strategies & Solutions 04/08/2024 Regular 0.00 2,445.00 10317 2801 Pipeline Analysis LLC 04/08/2024 Regular 0.00 13,827.00 10318 3176 Rey -Mar Construction 04/08/2024 Regular 0.00 38,380.00 10319 3156 Southern Petroleum Lab Inc 04/08/2024 Regular 0.00 338.40 10320 3182 Strategic Government Resources 04/08/2024 Regular 0.00 1,034.89 10321 2440 Tarrant County Public Health Laboratory 04/08/2024 Regular 0.00 300.00 10322 2696 Texas Excavation Safety System 04/08/2024 Regular 0.00 318.55 10323 1000 Trophy Club Mud (Water Bills) 04/08/2024 Regular 0.00 144.10 10324 2798 Tyler Technologies Inc 04/08/2024 Regular 0.00 11,657.35 10325 3280 Watts Ellison LLC 04/08/2024 Regular 0.00 3,979.67 10326 2691 All Test Fire Protection LLC 04/24/2024 Regular 0.00 961.60 10327 3299 Bickerstaff Heath Delgado Acosta LLP 04/24/2024 Regular 0.00 1,897.50 10328 4018 BP Energy Holding Company LLC 04/24/2024 Regular 0.00 33,069.06 10329 2683 Charter Communications 04/24/2024 Regular 0.00 903.74 10330 3187 CLS Sewer Equipment Co.lnc 04/24/2024 Regular 0.00 593.33 10331 2606 Fisery Solutions LLC 04/24/2024 Regular 0.00 50.00 10332 2796 Garver 04/24/2024 Regular 0.00 5,007.00 10333 2635 Halff Associates Inc. 04/24/2024 Regular 0.00 7,674.85 10334 3278 Kyocera Document Solutions 04/24/2024 Regular 0.00 108.29 10335 2760 NDS Leasing 04/24/2024 Regular 0.00 175.00 10336 4019 Peterson Pump & Motor Service LLC 04/24/2024 Regular 0.00 1,760.00 10337 2440 Tarrant County Public Health Laboratory 04/24/2024 Regular 0.00 210.00 10338 1001 Town of Trophy Club 04/24/2024 Regular 0.00 136,746.38 10339 1081 Tri County Electric 04/24/2024 Regular 0.00 739.22 10340 1058 Verizon Wireless 04/24/2024 Regular 0.00 583.68 10341 2970 Air Mac 04/24/2024 Regular 0.00 11,364.34 10342 2772 Allied Waste Industries 04/24/2024 Regular 0.00 9,306.80 10343 1005 Atlas Utility Supply Co. 04/24/2024 Regular 0.00 35,500.00 10344 1030 City of Fort Worth 04/24/2024 Regular 0.00 158,127.35 10345 2655 Core & Main LP 04/24/2024 Regular 0.00 3,682.23 10346 2800 Ferguson Enterprises LLC 04/24/2024 Regular 0.00 371.45 10347 2796 Garver 04/24/2024 Regular 0.00 15,774.20 10348 3132 Legal Shield 04/24/2024 Regular 0.00 15.95 10349 2784 Manning Concrete Sawing 04/24/2024 Regular 0.00 3,717.00 10350 1737 PVS DX INC 04/24/2024 Regular 0.00 778.54 10351 3176 Rey -Mar Construction 04/24/2024 Regular 0.00 27,215.30 10352 1578 Smith Pump Company, Inc. 04/24/2024 Regular 0.00 8,247.80 10353 3156 Southern Petroleum Lab Inc 04/24/2024 Regular 0.00 2,176.80 10354 1001 Town of Trophy Club 04/24/2024 Regular 0.00 99,620.00 10355 3197 BenefitMall 04/12/2024 Bank Draft 0.00 373.33 DFT0000149 3113 TCDRS 04/30/2024 Bank Draft 0.00 9,843.77 DFT0000150 6/13/2024 10:16:40 AM Page 1 of 3 Check Report Date Range: 04/01/2024 - 04/30/2024 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 3124 IRS Tax Payment 04/12/2024 Bank Draft 0.00 13,259.70 DFT0000151 3294 Texas Workforce Commission 04/12/2024 Bank Draft 0.00 1,638.00 DFT0000152 3197 BenefitMall 04/26/2024 Bank Draft 0.00 373.33 DFT0000153 3113 TCDRS 04/30/2024 Bank Draft 0.00 14,901.43 DFT0000154 3124 IRS Tax Payment 04/26/2024 Bank Draft 0.00 25,515.67 DFT0000155 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 75 52 0.00 853,904.56 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 7 7 0.00 65,905.23 EFT's 0 0 0.00 0.00 82 59 0.00 919,809.79 6/13/2024 10:16:40 AM Page 2 of 3 Check Report Date Range: 04/01/2024 - 04/30/2024 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 75 52 0.00 853,904.56 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 7 7 0.00 65,905.23 EFT's 0 0 0.00 0.00 82 59 0.00 919,809.79 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 4/2024 919,809.79 919,809.79 6/13/2024 10:16:40 AM Page 3 of 3 Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund Revenue Department: 000 - Revenue, Asset, Liability, & Equity 135-000-40000-000 Property Taxes 135-000-40002-000 Property Taxes/Delinquent 135-000-40015-000 Property Taxes/P & I 135-000-40025-000 PID Surcharges 135-000-47000-000 Water 135-000-47005-000 Sewer 135-000-47025-000 Penalties 135-000-47030-000 Service Charges 135-000-47035-000 Plumbing Inspections 135-000-47045-000 Sewer lnspections 135-000-47070-000 TCCC Effluent Charges 135-000-49011-000 Interest Income 135-000-49016-000 Cell Tower Revenue 135-000-49026-000 Proceeds from Sale of Assets 135-000-49035-000 Prior Year Reserves 135-000-49036-000 GASB Reserves 135-000-49075-000 Oversize Meter Reimbursement 135-000-49141-000 Interfund Transfer In 135-000-49900-000 Miscellaneous Income Department: 000 - Revenue, Asset, Liability, & Equity Total: Expense Department: 010 - Water 135-010-50005-000 135-010-50010-000 135-010-50016-000 135-010-50017-000 135-010-50020-000 135-010-50026-000 135-010-50027-000 135-010-50028-000 135-010-50029-000 135-010-50030-000 135-010-50035-000 135-010-50040-000 135-010-50045-000 Original Total Budget 85,733.51 300.00 300.00 143,223.25 6,939,998.00 3,679,786.00 105,800.00 3,350.00 300.00 100.00 70,000.00 150,000.00 49,320.00 25,000.00 1,933,264.00 50,000.00 2,058.00 1,178,400.00 7,000.00 14,423,932.76 Current Total Budget 85,733.51 300.00 300.00 143,223.25 6,939,998.00 3,679,786.00 105,800.00 3,350.00 300.00 100.00 70,000.00 150,000.00 49,320.00 25,000.00 1,933,264.00 50,000.00 2,058.00 1,178,400.00 7,000.00 14,423,932.76 Budget Report Account Summary For Fiscal: 2023-2024 Period Ending: 04/30/2024 Period Activity 662.91 (69.97) 47.11 479,045.25 300,031.54 4,755.26 175.00 600.00 200.00 45,338.70 51,450.00 1,712.00 1,500.00 885,447.80 Fiscal Activity 84,008.32 63.98 243.74 3,179,564.47 2,051,901.39 50,298.87 2,800.00 1,200.00 350.00 14,977.60 303,940.31 28,720.00 51,450.00 3,424.00 1,200,330.86 2,821.00 6,976,094.54 Variance Favorable Percent (Unfavorable) Remaining (1,725.19) (236.02) (56.26) (143,223.25) (3,760,433.53) (1,627,884.61) (55,501.13) (550.00) 900.00 250.00 (55,022.40) 153,940.31 (20,600.00) 26,450.00 (1,933,264.00) (50,000.00) 1,366.00 21,930.86 (4,179.00) (7,447,838.22) 2.01% 78.67% 18.75% 100% 54.18% 44.24% 52.46% 16.42% 400% 350% 78.60% 202.63% 41.77% 205.80% 100% 100% 166.38% 101.86% 59.70% 51.64% Revenue Total: 14,423,932.76 14,423,932.76 Salaries & Wages Overtime Longevity Certification Retirement Medical lnsurance Dental lnsurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation 431,575.02 431,575.02 17,000.00 17,000.00 6,252.50 6,252.50 3,600.00 3,600.00 56,730.41 56,730.41 116, 527.50 116,527.50 4,834.55 4,834.55 1,051.01 1,051.01 4,000.00 4,000.00 28,422.51 28,422.51 6,647.20 6,647.20 1,260.00 1,260.00 11,898.56 11,898.56 885,447.80 33,743.25 323.59 225.00 4,115.03 7,619.49 367.85 71.30 286.69 2,076.52 485.63 539.99 1,060.94 6,976,094.54 244,896.99 6,259.22 6,252.50 1,575.00 32,055.19 55,810.06 2,522.39 499.07 2,010.83 15,642.15 3,658.21 585.00 4,768.58 (7,447,838.22) 51.64% 186,678.03 43.26% 10,740.78 63.18% 0% 2,025.00 56.25% 24,675.22 43.50% 60,717.44 52.11% 2,312.16 47.83% 551.94 52.52% 1,989.17 49.73% 12,780.36 44.97% 2,988.99 44.97% 675.00 53.57% 7,129.98 59.92% Budget Report For Fiscal: 2023-2024 Period Ending: 04/30/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-010-50060-000 Pre-emp Physicals/Testing 400.00 400.00 - - 400.00 100% 135-010-50070-000 Employee Relations 300.00 300.00 - 300.00 100% 135-010-55080-000 Maintenance & Repairs 201,500.00 201,500.00 23,658.92 92,582.04 108,917.96 54.05% 135-010-55085-000 Generator Maint. and Repair 2,000.00 2,000.00 12,518.33 13,469.93 (11,469.93) -573.50% 135-010-55090-000 Vehicle Maintenance 5,000.00 5,000.00 1,281.05 3,281.15 1,718.85 34.38% 135-010-55105-000 Maintenance-Backhoe/SkidLoader 1,000.00 1,000.00 1,911.94 (911.94) -91.19% 135-010-55120-000 Cleaning Services 2,500.00 2,500.00 40.31 2,459.69 98.39% 135-010-55135-000 Lab Analysis 7,500.00 7,500.00 714.00 3,387.00 4,113.00 54.84% 135-010-55135-001 Lab Analysis for PID 2,000.00 2,000.00 744.00 2,102.00 (102.00) -5.10% 135-010-60010-000 Communications/Mobiles 7,500.00 7,500.00 334.72 2,008.69 5,491.31 73.22% 135-010-60020-000 Electricity 183,143.49 183,143.49 19,592.51 80,350.44 102,793.05 56.13% 135-010-60066-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 100% 135-010-60080-000 Schools & Training 2,630.00 2,630.00 950.00 3,546.74 (916.74) -34.86% 135-010-60100-000 Travel & per diem 577.50 577.50 604.10 (26.60) -4.61% 135-010-60135-000 TCEQ Fees & Permits 29,500.00 29,500.00 15,134.15 14,365.85 48.70% 135-010-60135-001 TCEQ Fees & Permits for PID 500.00 500.00 500.00 100% 135-010-60150-000 Wholesale Water 2,655,497.13 2,655,497.13 158,127.35 970,482.43 1,685,014.70 63.45% 135-010-60285-000 Lawn Equipment & Maintenance 12,500.00 12,500.00 4,800.00 7,700.00 61.60% 135-010-60332-000 Interfund Transfer Out -Rev I&S 565,796.88 565,796.88 309,003.12 256,793.76 45.39% 135-010-60334-000 Interfund Transfer Out - 920,912.00 (920,912.00) 0% 135-010-65005-000 Fuel & Lube 23,575.00 23,575.00 1,541.98 9,702.57 13,872.43 58.84% 135-010-65010-000 Uniforms 4,355.00 4,355.00 200.00 1,852.91 2,502.09 57.45% 135-010-65030-000 Chemicals 58,200.00 58,200.00 4,460.77 24,454.59 33,745.41 57.98% 135-010-65050-000 Meter Expense 20,000.00 20,000.00 20,000.00 100% 135-010-65053-000 Meter Change Out Program 124,500.00 124,500.00 35,500.00 82,650.00 41,850.00 33.61% 135-010-69005-000 Capital Outlays 4,200,000.00 4,200,000.00 314,307.00 1,373,220.39 2,826,779.61 67.30% 135-010-69195-000 GASB Reserve for Replacement 378,659.00 378,659.00 378,659.00 0% Department: 010 - Water Total: 9,179,933.26 9,179,933.26 624,845.91 4,670,690.69 4,509,242.57 0.491206465 Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 290,304.62 290,304.62 16,870.50 132,120.37 158,184.25 54.49% 135-020-50010-000 Overtime 20,000.00 20,000.00 358.30 5,355.48 14,644.52 73.22% 135-020-50016-000 Longevity 2,367.50 2,367.50 2,540.00 (172.50) -7.29% 135-020-50017-000 Certification 5,100.00 5,100.00 375.00 1,725.00 3,375.00 66.18% 135-020-50020-000 Retirement 40,934.05 40,934.05 2,112.47 17,529.92 23,404.13 57.18% 135-020-50026-000 Medical Insurance 93,222.04 93,222.04 4,354.00 30,926.44 62,295.60 66.82% 135-020-50027-000 Dental Insurance 3,385.28 3,385.28 202.37 1,309.01 2,076.27 61.33% 135-020-50028-000 Vision Insurance 818.82 818.82 42.52 297.64 521.18 63.65% 135-020-50029-000 Life Insurance & Other 3,000.00 3,000.00 170.26 1,187.82 1,812.18 60.41% 135-020-50030-000 Social Security Taxes 20,507.87 20,507.87 1,052.37 8,485.17 12,022.70 58.62% 135-020-50035-000 Medicare Taxes 4,796.20 4,796.20 246.13 1,984.41 2,811.79 58.63% 135-020-50040-000 Unemployment Taxes 1,008.00 1,008.00 324.00 350.98 657.02 65.18% 135-020-50045-000 Workman's Compensation 8,403.61 8,403.61 748.93 3,119.51 5,284.10 62.88% 135-020-50060-000 Pre-emp Physicals/Testing 400.00 400.00 - 400.00 100% 135-020-50070-000 Employee Relations 300.00 300.00 - 300.00 100% 135-020-55080-000 Maintenance & Repairs 137,000.00 137,000.00 29,141.81 110,529.93 26,470.07 19.32% Budget Report For Fiscal: 2023-2024 Period Ending: 04/30/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-020-55081-000 Mainten & Repairs Collections 270,000.00 270,000.00 26,400.44 245,557.06 24,442.94 9.05% 135-020-55085-000 Generator Maint. and Repair 11,000.00 11,000.00 6,478.06 4,521.94 41.11% 135-020-55090-000 Vehicle Maintenance 4,600.00 4,600.00 227.94 4,372.06 95.04% 135-020-55091-000 Veh Maintenance Collections 13,000.00 13,000.00 593.33 4,301.52 8,698.48 66.91% 135-020-55105-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 1,541.03 1,458.97 48.63% 135-020-55120-000 Cleaning Services 2,000.00 2,000.00 40.31 1,959.69 97.98% 135-020-55125-000 Dumpster Services 100,000.00 100,000.00 17,899.46 61,906.71 38,093.29 38.09% 135-020-55135-000 Lab Analysis 55,000.00 55,000.00 5,103.60 37,509.22 17,490.78 31.80% 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 200.71 1,686.77 5,813.23 77.51% 135-020-60020-000 Electricity 242,978.33 242,978.33 39,301.91 129,426.82 113,551.51 46.73% 135-020-60080-000 Schools & Training 2,119.00 2,119.00 727.50 1,391.50 65.67% 135-020-60100-000 Travel & per diem 527.50 527.50 - 527.50 100% 135-020-60135-000 TCEQ Fees & Permits 12,000.00 12,000.00 9,888.02 2,111.98 17.60% 135-020-60285-000 Lawn Equipment & Maintenance 16,000.00 16,000.00 - 8,240.00 7,760.00 48.50% 135-020-60331-000 Interfund Transfer Out-Tax I&S 115,885.76 115,885.76 - 63,210.54 52,675.22 45.45% 135-020-60332-000 Interfund Transfer Out-Rev l&S 698,542.63 698,542.63 - 381,291.90 317,250.73 45.42% 135-020-60334-000 Interfund Transfer Out - 96,630.00 (96,630.00) 0% 135-020-65005-000 Fuel & Lube 13,000.00 13,000.00 522.50 8,174.77 4,825.23 37.12% 135-020-65010-000 Uniforms 3,520.00 3,520.00 400.00 1,581.63 1,938.37 55.07% 135-020-65030-000 Chemicals 32,500.00 32,500.00 16,029.05 16,470.95 50.68% 135-020-65031-000 Chemicals Collections 10,000.00 10,000.00 5,709.00 4,291.00 42.91% 135-020-65045-000 Lab Supplies 33,000.00 33,000.00 789.66 25,620.22 7,379.78 22.36% 135-020-69005-000 Capital Outlays 1,050,000.00 1,050,000.00 53,934.50 670,812.97 379,187.03 36.11% 135-020-69008-000 Short Term Debt-Principal 22,398.34 22,398.34 22,132.30 266.04 1.19% 135-020-69009-000 Short Term Debt-Interest 442.39 442.39 425.07 17.32 3.92% 135-020-69195-000 GASB Reserve for Replacement 155,762.00 155,762.00 155,762.00 - 0% Department: 020 - Wastewater Total: 3,506,323.94 3,506,323.94 201,144.77 2,272,372.09 1,233,951.85 35.19% Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 15.00 15.00 0.66 4.62 10.38 69.20% 135-026-60070-000 Dues & Memberships 750.00 750.00 750.00 0% 135-026-60075-000 Meetings 1,500.00 1,500.00 115.99 811.93 688.07 45.87% 135-026-60080-000 Schools & Training 4,000.00 4,000.00 4,000.00 100% 135-026-60100-000 Travel & per diem 5,000.00 5,000.00 5,000.00 100% 135-026-60245-000 Miscellaneous Expenses 500.00 500.00 - 500.00 100% Department: 026 - Board of Directors Total: 11,765.00 11,765.00 116.65 1,566.55 10,198.45 86.68% Department: 030 - Administration 135-030-50005-000 Salaries & Wages 663,185.25 663,185.25 78,300.16 398,872.68 264,312.57 39.86% 135-030-50010-000 Overtime 2,000.00 2,000.00 303.56 1,620.34 379.66 18.98% 135-030-50016-000 Longevity 2,532.50 2,532.50 2,597.50 (65.00) -2.57% 135-030-50020-000 Retirement 82,631.07 82,631.07 9,401.05 49,576.34 33,054.73 40% 135-030-50026-000 Medical lnsurance 108,759.00 108,759.00 6,531.00 46,389.66 62,369.34 57.35% 135-030-50027-000 Dental Insurance 3,816.74 3,816.74 253.55 1,738.64 2,078.10 54.45% 135-030-50028-000 Vision Insurance 886.17 886.17 55.36 387.49 498.68 56.27% 135-030-50029-000 Life Insurance & Other 4,800.00 4,800.00 386.56 2,685.87 2,114.13 44.04% Budget Report For Fiscal: 2023-2024 Period Ending: 04/30/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-030-50030-000 Social Security Taxes 41,398.50 41,398.50 4,749.38 23,635.24 17,763.26 42.91% 135-030-50035-000 Medicare Taxes 9,681.91 9,681.91 1,110.74 5,643.99 4,037.92 41.71% 135-030-50040-000 Unemployment Taxes 1,512.00 1,512.00 647.98 702.00 810.00 53.57% 135-030-50045-000 Workman's Compensation 1,597.19 1,597.19 139.51 621.57 975.62 61.08% 135-030-50060-000 Pre-emp Physicals/Testing 500.00 500.00 210.45 210.45 289.55 57.91% 135-030-50070-000 Employee Relations 4,000.00 4,000.00 120.26 3,111.83 888.17 22.20% 135-030-55030-000 Software & Support 130,311.00 130,311.00 8,320.98 121,584.32 8,726.68 6.70% 135-030-55080-000 Maintenance & Repairs 23,000.00 23,000.00 4,709.87 11,325.61 11,674.39 50.76% 135-030-55085-000 Generator Maint. and Repair 1,000.00 1,000.00 1,348.04 (348.04) -34.80% 135-030-55120-000 Cleaning Services 13,825.00 13,825.00 1,600.00 9,454.70 4,370.30 31.61% 135-030-55160-000 Professional Outside Services 100,000.00 100,000.00 7,960.06 85,274.89 14,725.11 14.73% 135-030-55205-000 Utility Billing Contract 9,000.00 9,000.00 177.79 4,485.11 4,514.89 50.17% 135-030-60005-000 Telephone 6,000.00 6,000.00 529.36 3,463.22 2,536.78 42.28% 135-030-60010-000 Communications/Mobiles 3,000.00 3,000.00 48.25 289.55 2,710.45 90.35% 135-030-60020-000 Electricity/Gas 17,684.51 17,684.51 2,623.11 9,813.89 7,870.62 44.51% 135-030-60025-000 Water 5,000.00 5,000.00 1,735.92 3,264.08 65.28% 135-030-60035-000 Postage 30,000.00 30,000.00 330.92 15,813.49 14,186.51 47.29% 135-030-60040-000 Service Charges & Fees 140,000.00 140,000.00 8,376.00 108,317.22 31,682.78 22.63% 135-030-60050-000 Bad Debt Expense 13,000.00 13,000.00 13,000.00 100% 135-030-60055-000 Insurance 116,158.22 116,158.22 9,618.44 67,329.08 48,829.14 42.04% 135-030-60070-000 Dues & Memberships 6,800.00 6,800.00 2,016.00 4,784.00 70.35% 135-030-60080-000 Schools & Training 3,900.00 3,900.00 - 1,313.10 2,586.90 66.33% 135-030-60100-000 Travel & per diem 1,227.50 1,227.50 - - 1,227.50 100% 135-030-60115-000 Elections 10,000.00 10,000.00 - - 10,000.00 100% 135-030-60285-000 Lawn Equipment & Maintenance 5,000.00 5,000.00 3,287.69 1,712.31 34.25% 135-030-60360-000 Furniture/Equipment < $5000 3,000.00 3,000.00 - 3,000.00 100% 135-030-65010-000 Uniforms 530.00 530.00 - 530.00 100% 135-030-65055-000 Hardware 8,200.00 8,200.00 4,562.24 3,637.76 44.36% 135-030-65085-000 Office Supplies 5,000.00 5,000.00 102.46 2,400.68 2,599.32 51.99% 135-030-65095-000 Maintenance Supplies 5,000.00 5,000.00 514.76 4,768.15 231.85 4.64% 135-030-69170-000 Copier Lease Installments 4,000.00 4,000.00 283.29 1,939.24 2,060.76 51.52% 135-030-69195-000 GASB Reserve for Replacement 24,903.00 24,903.00 24,903.00 0% Department: 030 - Administration Total: 1,612,839.56 1,612,839.56 147,404.85 1,023,218.74 589,620.82 36.56% Department: 039 - Non Departmental 135-039-55045-000 Legal 65,000.00 65,000.00 3,712.00 25,180.95 39,819.05 61.26% 135-039-55055-000 Auditing 30,000.00 30,000.00 21,784.29 8,215.71 27.39% 135-039-55060-000 Appraisal 13,071.00 13,071.00 6,078.42 6,992.58 53.50% 135-039-55065-000 Tax Admin Fees 5,000.00 5,000.00 3,941.00 1,059.00 21.18% Department: 039 - Non Departmental Total: 113,071.00 113,071.00 3,712.00 56,984.66 56,086.34 49.60% Expense Total: 14,423,932.76 14,423,932.76 977,224.18 8,024,832.73 6,399,100.03 44.36% Fund: 135 - MUD 1 General Fund Surplus (Deficit): (91,776.38) (1,048,738.19) (1,048,738.19) 0 Report Surplus (Deficit): (91,776.38) (1,048,738.19) (1,048,738.19) 0 CASH STATUS AS OF MAY 2024 TexPool O & M (XXXXX0002)-Fire Operating Cash Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating *** Prosperity Bank (XXXXX2660) Fire Operating $0 $2,643,420 $2,643,420 135-10300 Prosperity Bank (XXXXX2660) General Fund Operating * $148,005 $4,697,866 $4,845,871 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,977,965 $0 $1,977,965 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement $4,916,433 $0 $4,916,433 519-10300 Prosperity Bank (XXXXX2660) SWIFT $85,052 $0 $85,052 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) $836,522 $0 $836,522 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $0 $0 $0 520-10300 Prosperity Bank (XXXXX2660)- Construction Water & Waste Water Systems $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $976,511 $0 $976,511 533-10250 TexPool Tax I & S (XXXXX0003) $534,146 $0 $534,146 533-10300 Prosperity Bank (XXXXX2660) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $403,242 $0 $403,242 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $187,447 $0 $187,447 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $181,282 $0 $181,282 $7,341,886 $17,588,490 Amount available in cash for spending (MUD Accounts) *5/31/2024 Customer Water Deposits $148,005 Fire Department Cash $7,341,886 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $959,564 $959,564 122-10300 Prosperity Bank (XXXXX2660) Fire Operating $0 $0 $0 $0 $959,564 $959,564 Amount available in cash for spending (Fire Department Accounts) Total General Fund 135 Available for Spending $959,564 General Fund 135 Available $ 4,697,866 Prosperity General Fund $ 2,643,420 Texpool General Fund $ 600 Petty Cash $ 7,341,886 General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) $ 3,880 Assigned Fund Balance (FY2024 Capital Projects plus prior year carry forward) $ 6,516,007 Unassigned Fund Balance $ 4,185,596 Current Year Revenue/Expenses $ (1,087,115) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $9,618,367 ebills Bills Mailed Bank Draft Online Payments Late Notices Disconnects Connections MUD Connections Town May Utility Billing Report Fiscal Year 2023 - 2024 May 2023 June 2023 July 2023 August 2023 September 2023 October 2023 November 2023 December 2023 January 2024 February 2024 March 2024 April 2024 May 2024 1,794 1,766 1,750 1,744 1,742 1,745 1,740 1,737 1,736 1,734 1,744 1,741 1,738 3,734 3,755 3,749 3,747 3,747 3,737 3,739 3,742 3,726 3,729 3,737 3,747 3,753 588 589 585 578 572 569 562 567 568 565 565 562 562 2,754 3,134 3,101 2,957 3,086 3,072 3,006 3,133 3,023 3,036 3,246 2,992 3,152 290 327 327 268 344 255 298 342 249 298 299 245 295 9 9 13 7 7 13 4 5 4 8 7 3 3 3,394 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,394 3,394 3,394 1,443 1,443 1,443 1,443 1,443 1,444 1,444 1,446 1,446 1,447 1,447 1,450 1,453 May Permits Fiscal Year 2023 - 2024 Date of Permit Permit No. Customer Deposit Due to FW Water Oversize Meter Plumbing Inspections Sewer Inspections Fire Line Misc. Income Total 5/3/2024 2024-09 $ 100.00 $ 4,953.00 $ 428.00 $ 150.00 $ 50.00 $ 1,500.00 $ 7,181.00 5/10/2024 2024-10 $ 100.00 $ 4,953.00 $ 428.00 $ 150.00 $ 50.00 $ 5,681.00 5/10/2024 2024-11 $ 100.00 $ 4,953.00 $ 428.00 $ 150.00 $ 50.00 $ 5,681.00 $ Total $ 300.00 $ 14,859.00 $ 1,284.00 $ 450.00 $ 150.00 $ 1,500.00 $ - $ 18,543.00