Loading...
HomeMy WebLinkAbout2023-10 October Combined FinancialsCheck Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 10/01/2023 - 10/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular 3197 BenefitMall 10/02/2023 Regular 0.00 52.00 9918 4033 Health Care Service Corporation 10/02/2023 Regular 0.00 22,147.36 9919 3216 M3 Networks 10/02/2023 Regular 0.00 70,347.00 9920 3115 Metlife Group Benefits 10/02/2023 Regular 0.00 2,301.06 9921 2763 Novotx 10/02/2023 Regular 0.00 10,300.00 9922 2809 Rod L Abbott CPA LLC 10/02/2023 Regular 0.00 4,500.00 9923 2798 Tyler Technologies Inc 10/02/2023 Regular 0.00 24,058.24 9924 3298 308 Construction LLC 10/18/2023 Regular 0.00 80,512.50 9925 3127 Allied Welding Supply Inc. 10/18/2023 Regular 0.00 20.25 9926 3299 Bickerstaff Heath Delgado Acosta LLP 10/18/2023 Regular 0.00 2,288.90 9927 1030 City of Fort Worth 10/18/2023 Regular 0.00 176,002.49 9928 3184 Dataprose LLC 10/18/2023 Regular 0.00 2,867.02 9929 2807 Denton Record -Chronicle 10/18/2023 Regular 0.00 1,265.00 9930 2711 Endress+Hauser Inc. 10/18/2023 Regular 0.00 4,894.78 9931 2606 Fisery Solutions LLC 10/18/2023 Regular 0.00 50.00 9932 3093 Four Man Furnace Inc. 10/18/2023 Regular 0.00 835.00 9933 2796 Garver 10/18/2023 Regular 0.00 2,695.00 9934 2635 Halff Associates Inc. 10/18/2023 Regular 0.00 737.22 9935 2983 NTTA 10/18/2023 Regular 0.00 3.62 9936 4019 Peterson Pump & Motor Service LLC 10/18/2023 Regular 0.00 800.00 9937 2696 Texas Excavation Safety System 10/18/2023 Regular 0.00 236.55 9938 1001 Town of Trophy Club 10/18/2023 Regular 0.00 128,651.29 9939 1081 Tri County Electric 10/18/2023 Regular 0.00 726.60 9940 2798 Tyler Technologies Inc 10/18/2023 Regular 0.00 11,969.00 9941 1058 Verizon Wireless 10/18/2023 Regular 0.00 584.19 9942 1512 Association of Water Board Directors 10/18/2023 Regular 0.00 750.00 9943 2683 Charter Communications 10/18/2023 Regular 0.00 903.72 9944 2655 Core & Main LP 10/18/2023 Regular 0.00 5,761.58 9945 1372 Hach Company 10/18/2023 Regular 0.00 3,222.71 9946 2635 Halff Associates Inc. 10/18/2023 Regular 0.00 7,500.00 9947 1834 Idexx Distribution, Inc 10/18/2023 Regular 0.00 13,747.96 9948 1056 Office Depot Inc 10/18/2023 Regular 0.00 356.77 9949 4019 Peterson Pump & Motor Service LLC 10/18/2023 Regular 0.00 1,120.00 9950 1481 TML Intergovernmental Risk 10/18/2023 Regular 0.00 163,381.92 9951 1001 Town of Trophy Club 10/18/2023 Regular 0.00 99,620.00 9952 2634 Valley Solvents & Chemicals 10/18/2023 Regular 0.00 2,664.09 9953 4018 BP Energy Holding Company LLC 10/31/2023 Regular 0.00 50,174.74 9954 3176 Rey -Mar Construction 10/31/2023 Regular 0.00 15,919.96 9955 3156 Southern Petroleum Lab Inc 10/31/2023 Regular 0.00 2,352.80 9956 4029 Trojan Technologies Group ULC 10/31/2023 Regular 0.00 1,625.00 9957 3225 US Bank Voyager Fleet Systems 10/31/2023 Regular 0.00 397.10 9958 3298 308 Construction LLC 10/31/2023 Regular 0.00 19,000.00 9959 2222 Aflac 10/31/2023 Regular 0.00 446.16 9960 2772 Allied Waste Industries 10/31/2023 Regular 0.00 4,837.42 9961 2667 BD Holt Co 10/31/2023 Regular 0.00 1,911.94 9962 2655 Core & Main LP 10/31/2023 Regular 0.00 3,725.00 9963 1737 DPC Industries Inc. 10/31/2023 Regular 0.00 1,751.72 9964 2641 Huber Technology Inc 10/31/2023 Regular 0.00 2,874.54 9965 3297 J&L Construction LLC 10/31/2023 Regular 0.00 83,624.41 9966 2943 JP Morgan Chase Bank NA 10/31/2023 Regular 0.00 4,385.13 9967 3278 Kyocera Document Solutions 10/31/2023 Regular 0.00 107.39 9968 3132 Legal Shield 10/31/2023 Regular 0.00 15.95 9969 1053 North Central TX Council of Government 10/31/2023 Regular 0.00 100.00 9970 11/7/2023 7:09:39 PM Page 1 of 4 Check Report Vendor Number 1056 2633 4002 1973 1000 3225 Vendor Name Office Depot Inc Sluder Emergency Power Service SmartSights Technologies LLC Texas Commission on Environmental Quality Trophy Club Mud (Water Bills) US Bank Voyager Fleet Systems Payment Date 10/31/2023 10/31/2023 10/31/2023 10/31/2023 10/31/2023 10/31/2023 Payment Type Regular Regular Regular Regular Regular Regular Total Regular: Discount Amount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Date Range: 10/01/2023 - 10/31/2023 Payment Amount Number 58.99 1,668.39 800.00 9,888.02 423.50 2,074.18 1,056,036.16 9971 9972 9973 9974 9975 9976 11/7/2023 7:09:39 PM Page 2 of 4 Check Report Date Range: 10/01/2023 - 10/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payment Type: Bank Draft 3197 BenefitMall 10/13/2023 Bank Draft 0.00 266.67 DFT0000108 3113 TCDRS 10/31/2023 Bank Draft 0.00 9,770.16 DFT0000109 3124 IRS Tax Payment 10/13/2023 Bank Draft 0.00 13,494.44 DFT0000110 3197 BenefitMall 10/27/2023 Bank Draft 0.00 266.67 DFT0000111 3113 TCDRS 10/31/2023 Bank Draft 0.00 10,078.79 DFT0000112 3124 IRS Tax Payment 10/27/2023 Bank Draft 0.00 13,763.80 DFT0000113 3294 Texas Workforce Commission 10/31/2023 Bank Draft 0.00 1.83 DFT0000114 Total Bank Draft: 0.00 47,642.36 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 86 59 0.00 1,056,036.16 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 7 7 0.00 47,642.36 EFT's 0 0 0.00 0.00 93 66 0.00 1,103,678.52 11/7/2023 7:09:39 PM Page 3 of 4 Check Report Date Range: 10/01/2023 - 10/31/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 86 59 0.00 1,056,036.16 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 7 7 0.00 47,642.36 EFT's 0 0 0.00 0.00 93 66 0.00 1,103,678.52 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 10/2023 1,103,678.52 1,103,678.52 11/7/2023 7:09:39 PM Page 4 of 4 FY 2024 Combined Financials YTD as of 10/31/2023 YTD Revenues YTD Expenses o ted Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses 51,182,909 51,263,334 $14,423,933 $14,423,933 $867 54,500 0% $241,352 19% 1% YTD Expenses By Departments YTD Expense- Water 5699,212 $317,403 55% YTD Expense- WW 25% YTD Expense -Admin YTD Expense- BOD ■ YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 0 Water Consumption Budget vs Actual 112,006,200 92,198,177 —II—Budget Consumption —*-Actual Consumption Oct 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 888,486,879 Total Water Consumption ■ Budgeted Water Consumption ■ Projected Water Consumption Presented by: Finance Department $1,000,000 $900,000 5800,000 5700,000 5600,000 5500,000 5400,000 $300,000 5200,000 5100,000 50 Water Revenue Budget vs Actual $809,265 •- ----- $554,257 —0—Budget Revenue —a—Actual Revenue Oct 56,000,000 55,000,000 $4,000,000 $3,000,000 52,000,000 $1,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue 55,166,291 55,421,298 $2,510,794 1 Total Water Revenue $2,765,801 ■ Budgeted Water Revenue ■ Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses ■ Net Projected Water Revenue Minus Projected Expenses 183,143.49 183,143.49 0.00 0.00 183,143.49 100.00 % Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund Revenue Department: 000 - Revenue, 135-000-40000-000 135-000-40002-000 135-000-40015-000 135-000-40025-000 135-000-47000-000 135-000-47005-000 135-000-47025-000 135-000-47030-000 135-000-47035-000 135-000-47045-000 135-000-47070-000 135-000-49011-000 135-000-49016-000 135-000-49026-000 135-000-49035-000 135-000-49036-000 135-000-49075-000 135-000-49141-000 135-000-49900-000 Asset, Liability, & Equity Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Interfund Transfer In 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 135-010-50060-000 135-010-50070-000 135-010-55080-000 135-010-55085-000 135-010-55090-000 135-010-55105-000 135-010-55120-000 135-010-55135-000 135-010-55135-001 135-010-60010-000 Original Current Total Budget 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 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 Budget Report Account Summary For Fiscal: 2023-2024 Period Ending: 10/31/2023 Period Activity 0.00 127.09 26.18 0.00 809,265.11 308,113.46 8,175.96 875.00 150.00 0.00 14, 310.40 41,437.44 0.00 0.00 0.00 0.00 428.00 0.00 0.00 Fiscal Activity 0.00 127.09 26.18 0.00 809,265.11 308,113.46 8,175.96 875.00 150.00 0.00 14, 310.40 41,437.44 0.00 0.00 0.00 0.00 428.00 0.00 0.00 Variance Favorable Percent (Unfavorable) Remaining -85,733.51 -172.91 -273.82 -143,223.25 -6,130,732.89 -3,371,672.54 -97,624.04 -2,475.00 -150.00 -100.00 -55,689.60 -108,562.56 -49,320.00 -25,000.00 -1,933,264.00 -50,000.00 -1,630.00 -1,178,400.00 -7,000.00 100.00 % 57.64 % 91.27 % 100.00 % 88.34 % 91.63 % 92.27 % 73.88 % 50.00 % 100.00 % 79.56 % 72.38 % 100.00 % 100.00 % 100.00 % 100.00 % 79.20 % 100.00 % 100.00 % 14,42 3, 932.76 14,42 3, 932.76 1,182,908.64 1,182,908.64 -13,241,024.12 91.80% Revenue Total: 14,423,932.76 14,423,932.76 1,182,908.64 1,182,908.64 -13,241,024.12 91.80% Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis Lab Analysis for PID Communications/Mobiles 431,575.02 17,000.00 6,252.50 3,600.00 56,730.41 116,527.50 4,834.55 1,051.01 4,000.00 28,422.51 6,647.20 1,260.00 11,898.56 400.00 300.00 201, 500.00 2,000.00 5,000.00 1,000.00 2,500.00 7,500.00 2,000.00 7,500.00 431,575.02 17,000.00 6,252.50 3,600.00 56,730.41 116,527.50 4,834.55 1,051.01 4,000.00 28,422.51 6,647.20 1,260.00 11,898.56 400.00 300.00 201, 500.00 2,000.00 5,000.00 1,000.00 2,500.00 7,500.00 2,000.00 7,500.00 32,841.76 1,913.22 0.00 225.00 4,197.59 8,444.02 350.33 71.29 290.69 2,126.07 497.23 0.00 1,060.94 0.00 0.00 7,266.94 0.00 953.90 1,911.94 0.00 0.00 0.00 0.00 32,841.76 1,913.22 0.00 225.00 4,197.59 8,444.02 350.33 71.29 290.69 2,126.07 497.23 0.00 1,060.94 0.00 0.00 7,266.94 0.00 953.90 1,911.94 0.00 0.00 0.00 0.00 398,733.26 15,086.78 6,252.50 3,375.00 52,532.82 108,083.48 4,484.22 979.72 3,709.31 26,296.44 6,149.97 1,260.00 10,837.62 400.00 300.00 194,233.06 2,000.00 4,046.10 -911.94 2,500.00 7,500.00 2,000.00 7,500.00 92.39 % 88.75 % 100.00 % 93.75 % 92.60 % 92.75 % 92.75 % 93.22 % 92.73 % 92.52 % 92.52 % 100.00 % 91.08 % 100.00 % 100.00 % 96.39 % 100.00 % 80.92 % -91.19 % 100.00 % 100.00 % 100.00 % 100.00 % 135-010-60020-000 Electricity 135-010-60066-000 135-010-60080-000 Publications/Books/Subscripts Schools & Training 1,000.00 2,630.00 1,000.00 2,630.00 0.00 0.00 0.00 0.00 1,000.00 100.00 % 2,630.00 100.00 % 11/9/2023 11:16:28 PM Budget Report For Fiscal: 2023-2024 Period Ending: 10/31/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-010-60100-000 Travel & per diem 577.50 577.50 0.00 0.00 577.50 100.00 % 135-010-60135-000 TCEQ Fees & Permits 29,500.00 29,500.00 0.00 0.00 29,500.00 100.00 % 135-010-60135-001 TCEQ Fees & Permits for PID 500.00 500.00 0.00 0.00 500.00 100.00 % 135-010-60150-000 Wholesale Water 2,655,497.13 2,655,497.13 0.00 0.00 2,655,497.13 100.00 % 135-010-60285-000 Lawn Equipment & Maintenance 12,500.00 12,500.00 0.00 0.00 12,500.00 100.00 % 135-010-60332-000 Interfund Transfer Out -Rev l&S 565,796.88 565,796.88 51,500.52 51,500.52 514,296.36 90.90 % 135-010-65005-000 Fuel & Lube 23,575.00 23,575.00 1,203.18 1,203.18 22,371.82 94.90 % 135-010-65010-000 Uniforms 4,355.00 4,355.00 0.00 0.00 4,355.00 100.00 % 135-010-65030-000 Chemicals 58,200.00 58,200.00 5,699.30 5,699.30 52,500.70 90.21 % 135-010-65050-000 Meter Expense 20,000.00 20,000.00 0.00 0.00 20,000.00 100.00 % 135-010-65053-000 Meter Change Out Program 124,500.00 124,500.00 0.00 0.00 124,500.00 100.00 % 135-010-69005-000 Capital Outlays 4,200,000.00 4,200,000.00 199,999.41 199,999.41 4,000,000.59 95.24 % 135-010-69195-000 GASB Reserve for Replacement 378,659.00 378,659.00 378,659.00 378,659.00 0.00 0.00 % Department: 010 - Water Total: 9,179,933.26 9,179,933.26 699,212.33 699,212.33 8,480,720.93 92.38% Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 290,304.62 290,304.62 18,143.58 18,143.58 272,161.04 93.75 % 135-020-50010-000 Overtime 20,000.00 20,000.00 944.94 944.94 19,055.06 95.28 % 135-020-50016-000 Longevity 2,367.50 2,367.50 0.00 0.00 2,367.50 100.00 % 135-020-50017-000 Certification 5,100.00 5,100.00 225.00 225.00 4,875.00 95.59 % 135-020-50020-000 Retirement 40,934.05 40,934.05 2,317.62 2,317.62 38,616.43 94.34 % 135-020-50026-000 Medical Insurance 93,222.04 93,222.04 4,503.48 4,503.48 88,718.56 95.17 % 135-020-50027-000 Dental Insurance 3,385.28 3,385.28 166.51 166.51 3,218.77 95.08 % 135-020-50028-000 Vision Insurance 818.82 818.82 42.52 42.52 776.30 94.81 % 135-020-50029-000 Life Insurance & Other 3,000.00 3,000.00 166.26 166.26 2,833.74 94.46 % 135-020-50030-000 Social Security Taxes 20,507.87 20,507.87 1,161.28 1,161.28 19,346.59 94.34 % 135-020-50035-000 Medicare Taxes 4,796.20 4,796.20 271.58 271.58 4,524.62 94.34 % 135-020-50040-000 Unemployment Taxes 1,008.00 1,008.00 0.00 0.00 1,008.00 100.00 % 135-020-50045-000 Workman's Compensation 8,403.61 8,403.61 748.93 748.93 7,654.68 91.09 % 135-020-50060-000 Pre-emp Physicals/Testing 400.00 400.00 0.00 0.00 400.00 100.00 % 135-020-50070-000 Employee Relations 300.00 300.00 0.00 0.00 300.00 100.00 % 135-020-55080-000 Maintenance & Repairs 137,000.00 137,000.00 4,352.17 4,352.17 132,647.83 96.82 % 135-020-55081-000 Mainten & Repairs Collections 270,000.00 270,000.00 251.55 251.55 269,748.45 99.91 % 135-020-55085-000 Generator Maint. and Repair 11,000.00 11,000.00 0.00 0.00 11,000.00 100.00 % 135-020-55090-000 Vehicle Maintenance 4,600.00 4,600.00 0.00 0.00 4,600.00 100.00 % 135-020-55091-000 Veh Maintenance Collections 13,000.00 13,000.00 30.75 30.75 12,969.25 99.76 % 135-020-55105-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % 135-020-55120-000 Cleaning Services 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 135-020-55125-000 Dumpster Services 100,000.00 100,000.00 4,837.42 4,837.42 95,162.58 95.16 % 135-020-55135-000 Lab Analysis 55,000.00 55,000.00 0.00 0.00 55,000.00 100.00 % 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 0.00 0.00 7,500.00 100.00 % 135-020-60020-000 Electricity 242,978.33 242,978.33 0.00 0.00 242,978.33 100.00 % 135-020-60080-000 Schools & Training 2,119.00 2,119.00 0.00 0.00 2,119.00 100.00 % 135-020-60100-000 Travel & per diem 527.50 527.50 0.00 0.00 527.50 100.00 % 135-020-60135-000 TCEQ Fees & Permits 12,000.00 12,000.00 9,888.02 9,888.02 2,111.98 17.60 % 135-020-60285-000 Lawn Equipment & Maintenance 16,000.00 16,000.00 0.00 0.00 16,000.00 100.00 % 135-020-60331-000 Interfund Transfer Out -Tax I&S 115,885.76 115,885.76 10,535.09 10,535.09 105,350.67 90.91 % 135-020-60332-000 Interfund Transfer Out -Rev l&S 698,542.63 698,542.63 63,548.65 63,548.65 634,993.98 90.90 % 135-020-65005-000 Fuel & Lube 13,000.00 13,000.00 871.00 871.00 12,129.00 93.30 % 135-020-65010-000 Uniforms 3,520.00 3,520.00 0.00 0.00 3,520.00 100.00 % 135-020-65030-000 Chemicals 32,500.00 32,500.00 2,664.09 2,664.09 29,835.91 91.80 % 135-020-65031-000 Chemicals Collections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % 135-020-65045-000 Lab Supplies 33,000.00 33,000.00 16,970.67 16,970.67 16,029.33 48.57 % 135-020-69005-000 Capital Outlays 1,050,000.00 1,050,000.00 19,000.00 19,000.00 1,031,000.00 98.19 % 135-020-69008-000 Short Term Debt -Principal 22,398.34 22,398.34 0.00 0.00 22,398.34 100.00 % 135-020-69009-000 Short Term Debt -Interest 442.39 442.39 0.00 0.00 442.39 100.00 % 135-020-69195-000 GASB Reserve for Replacement 155,762.00 155,762.00 155,762.00 155,762.00 0.00 0.00 % Department: 020 - Wastewater Total: 3,506,323.94 3,506,323.94 317,403.11 317,403.11 3,188,920.83 90.95% 11/9/2023 11:16:28 PM Budget Report For Fiscal: 2023-2024 Period Ending: 10/31/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 15.00 15.00 0.66 0.66 14.34 95.60 % 135-026-60070-000 Dues & Memberships 750.00 750.00 750.00 750.00 0.00 0.00 % 135-026-60075-000 Meetings 1,500.00 1,500.00 115.99 115.99 1,384.01 92.27 % 135-026-60080-000 Schools & Training 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00 % 135-026-60100-000 Travel & per diem 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % 135-026-60245-000 Miscellaneous Expenses 500.00 500.00 0.00 0.00 500.00 100.00 % Department: 026 - Board of Directors Total: 11,765.00 11,765.00 866.65 866.65 10,898.35 92.63% Department: 030 - Administration 135-030-50005-000 Salaries & Wages 663,185.25 663,185.25 50,328.53 50,328.53 612,856.72 92.41 % 135-030-50010-000 Overtime 2,000.00 2,000.00 70.94 70.94 1,929.06 96.45 % 135-030-50016-000 Longevity 2,532.50 2,532.50 0.00 0.00 2,532.50 100.00 % 135-030-50020-000 Retirement 82,631.07 82,631.07 6,020.96 6,020.96 76,610.11 92.71 % 135-030-50026-000 Medical Insurance 108,759.00 108,759.00 6,755.22 6,755.22 102,003.78 93.79 % 135-030-50027-000 Dental Insurance 3,816.74 3,816.74 241.48 241.48 3,575.26 93.67 % 135-030-50028-000 Vision Insurance 886.17 886.17 55.35 55.35 830.82 93.75 % 135-030-50029-000 Life Insurance & Other 4,800.00 4,800.00 382.56 382.56 4,417.44 92.03 % 135-030-50030-000 Social Security Taxes 41,398.50 41,398.50 3,014.33 3,014.33 38,384.17 92.72 % 135-030-50035-000 Medicare Taxes 9,681.91 9,681.91 704.96 704.96 8,976.95 92.72 % 135-030-50040-000 Unemployment Taxes 1,512.00 1,512.00 0.00 0.00 1,512.00 100.00 % 135-030-50045-000 Workman's Compensation 1,597.19 1,597.19 139.51 139.51 1,457.68 91.27 % 135-030-50060-000 Pre-emp Physicals/Testing 500.00 500.00 0.00 0.00 500.00 100.00 % 135-030-50070-000 Employee Relations 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00 % 135-030-55030-000 Software & Support 130,311.00 130,311.00 44,927.11 44,927.11 85,383.89 65.52 % 135-030-55080-000 Maintenance & Repairs 23,000.00 23,000.00 0.00 0.00 23,000.00 100.00 % 135-030-55085-000 Generator Maint. and Repair 1,000.00 1,000.00 716.79 716.79 283.21 28.32 % 135-030-55120-000 Cleaning Services 13,825.00 13,825.00 0.00 0.00 13,825.00 100.00 % 135-030-55160-000 Professional Outside Services 100,000.00 100,000.00 69,549.00 69,549.00 30,451.00 30.45 % 135-030-55205-000 Utility Billing Contract 9,000.00 9,000.00 0.00 0.00 9,000.00 100.00 % 135-030-60005-000 Telephone 6,000.00 6,000.00 490.74 490.74 5,509.26 91.82 % 135-030-60010-000 Communications/Mobiles 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % 135-030-60020-000 Electricity/Gas 17,684.51 17,684.51 0.00 0.00 17,684.51 100.00 % 135-030-60025-000 Water 5,000.00 5,000.00 423.50 423.50 4,576.50 91.53 % 135-030-60035-000 Postage 30,000.00 30,000.00 9.97 9.97 29,990.03 99.97 % 135-030-60040-000 Service Charges & Fees 140,000.00 140,000.00 18,669.07 18,669.07 121,330.93 86.66 % 135-030-60050-000 Bad Debt Expense 13,000.00 13,000.00 0.00 0.00 13,000.00 100.00 % 135-030-60055-000 Insurance 116,158.22 116,158.22 9,618.44 9,618.44 106,539.78 91.72 % 135-030-60070-000 Dues & Memberships 6,800.00 6,800.00 100.00 100.00 6,700.00 98.53 % 135-030-60080-000 Schools & Training 3,900.00 3,900.00 0.00 0.00 3,900.00 100.00 % 135-030-60100-000 Travel & per diem 1,227.50 1,227.50 0.00 0.00 1,227.50 100.00 % 135-030-60115-000 Elections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % 135-030-60285-000 Lawn Equipment & Maintenance 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % 135-030-60360-000 Furniture/Equipment < $5000 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % 135-030-65010-000 Uniforms 530.00 530.00 0.00 0.00 530.00 100.00 % 135-030-65055-000 Hardware 8,200.00 8,200.00 2,476.46 2,476.46 5,723.54 69.80 % 135-030-65085-000 Office Supplies 5,000.00 5,000.00 731.69 731.69 4,268.31 85.37 % 135-030-65095-000 Maintenance Supplies 5,000.00 5,000.00 914.66 914.66 4,085.34 81.71 % 135-030-69170-000 Copier Lease Installments 4,000.00 4,000.00 107.39 107.39 3,892.61 97.32 % 135-030-69195-000 GASB Reserve for Replacement 24,903.00 24,903.00 24,903.00 24,903.00 0.00 0.00 % Department: 030 - Administration Total: 1,612,839.56 1,612,839.56 241,351.66 241,351.66 1,371,487.90 85.04% Department: 039 - Non Departmental 135-039-55045-000 Legal 65,000.00 65,000.00 0.00 0.00 65,000.00 100.00 % 135-039-55055-000 Auditing 30,000.00 30,000.00 4,500.00 4,500.00 25,500.00 85.00 % 135-039-55060-000 Appraisal 13,071.00 13,071.00 0.00 0.00 13,071.00 100.00 % 11/9/2023 11:16:28 PM Budget Report For Fiscal: 2023-2024 Period Ending: 10/31/2023 135-039-55065-000 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Tax Admin Fees 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % Department: 039 - Non Departmental Total: 113,071.00 113,071.00 4,500.00 4,500.00 108,571.00 96.02% Expense Total: 14,423,932.76 14,423,932.76 1,263,333.75 1,263,333.75 13,160,599.01 91.24% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 -80,425.11 -80,425.11 -80,425.11 0.00% Report Surplus (Deficit): 0.00 0.00 -80,425.11 -80,425.11 -80,425.11 0.00% 11/9/2023 11:16:28 PM TROPHY CLUB WONEMPAL UTILETY 1 r T 1.Frr Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Total Asset: 122 - Trophy Club MUD Fire Dept. 135 - MUD 1 General Fund 1, 890, 887.70 11,366,817.50 Balance Sheet Funds 122 - 528 Account Summary As Of 10/31/2023 137 - MUD 1 519-2016 Rev 520 -Revenue 528-2015 Consolidated Bond Const -SWIFT Bond 16" Revenue Bond GASB Waterline Reserve Fund 3,898,890.58 820,199.16 1,890, 887.70 11,366, 817.50 3,898,890.58 820,199.16 1,184,425.11 1,184,425.11 Total 946, 631.50 20,107, 851.55 946,631.50 20,107,851.55 Liability 000 - Revenue, Asset, Liability, & Equity 1,313,188.85 938,717.89 0.00 81,691.15 0.00 0.00 2,333,597.89 Total Liability: 1,313,188.85 Equity 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 759,281.93 938,717.89 0.00 10,508,524.72 3,258,146.58 81,691.15 0.00 735, 325.73 1,179,058.79 0.00 2,333,597.89 942,342.55 17,382,680.30 759,281.93 1,503.60 183,086.68 10,508,524.72 1,182,908.64 1,263,333.75 3,258,146.58 640, 744.00 0.00 735,325.73 3,182.28 0.00 1,179,058.79 5,366.32 0.00 942,342.55 4,288.95 0.00 17,382,680.30 1,837,993.79 1,446,420.43 -181,583.08 577,698.85 1,890,887.70 -80,425.11 10,428,099.61 11,366,817.50 640,744.00 3,898,890.58 3,898,890.58 3,182.28 738,508.01 820,199.16 5,366.32 1,184,425.11 1,184,425.11 4,288.95 946,631.50 946,631.50 391,573.36 17,774,253.66 20,107,851.55 Monthly Financial Activity Footnotes: Fund 122 Activity Daily property tax deposits Monthly transfer OUT to MUD General Fund to cover Town transfers and any other A/P expenses Fund 135 Activity Daily property tax deposits All A/P checks are cut through the General Fund Monthly transfer IN to cover other fund A/P expenses Monthly transfer OUT for l&S Revenue Bond payments for Fund 534, 535, & 536 Monthly bank interest Fund 137 Activity Transfer IN at beginning of fiscal year based on yearly budget and transfer OUT at fiscal year-end based on reserves balances Fund 519 Activity Monthly bank interest Fund 520 Activity Transfer OUT to MUD General Fund to cover Interconnect Waterline construction project expenses Monthly bank interest Fund 528 Activity Monthly bank interest Department Trophy Club Municipal Utility District No. 1 533 - MUD 1 I&S 534 - 2015 Consolidated Revenue Bond I&S Asset 000 - Revenue, Asset, Liability, & Equity 297,300.15 Liability 000 - Revenue, Asset, Liability, & Equity Equity 000 - Revenue, Asset, Liability, & Equity 535 - 2016 Rev Bond I&S-SWIFT 94,926.90 36,671.94 536 - 2019 Rev Bond I&S- W&WW System Balance Sheet I&S Funds 533 - 536 Account Summary As Of 10/31/2023 Total 41,054.94 469,953.93 Total Asset: 297,300.15 94,926.90 36,671.94 41,054.94 469,953.93 199,684.88 0.00 0.00 0.00 199,684.88 Total Liability: 199,684.88 0.00 0.00 0.00 199,684.88 85,836.20 39,137.14 11,713.62 6,476.05 143,163.01 Total Total Beginning Equity: 85,836.20 39,137.14 11,713.62 6,476.05 143,163.01 Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 11,779.07 0.00 55,789.76 0.00 24,958.32 0.00 34,578.89 0.00 11,779.07 97,615.27 297,300.15 55,789.76 94,926.90 94,926.90 24,958.32 36,671.94 36,671.94 34,578.89 41,054.94 41,054.94 127,106.04 0.00 127,106.04 270,269.05 469,953.93 Monthly Financial Activity Footnotes: Fund 533 Activity Daily property tax deposits Monthly transfer IN from Fund 135 for PID portion of semi-annual GO Bond payments 3/1 & 9/1 GO Bond payments (Interest and Principal) Monthly bank interest Fund 534 Activity Monthly transfer IN for semi-annual I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 535 Activity Monthly transfer IN for semi-annual MS Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 536 Activity Monthly transfer IN for semi-annual MS Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest CASH STATUS AS OF OCTOBER 2023 TexPool 0 & 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 (XXX8701) Fire Operating $0 $2,997,691 $2,997,691 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $145,755 $4,659,795 $4,805,550 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,942,054 $0 $1,942,054 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 $3,898,891 $0 $3,898,891 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) $820,199 $0 $820,199 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,184,425 $0 $1,184,425 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $946,632 $0 $946,632 533-10250 TexPool Tax I & S (XXXXX0003) $97,614 $0 $97,614 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $94,927 $0 $94,927 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $36,672 $0 $36,672 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $41,055 $0 $41,055 $7,658,086 $16,866,310 Amount available in cash for spending (MUD Accounts) *10/31/2023 Customer Water Deposits $145,755 Fire Department Cash $7,658,086 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $555,185 $555,185 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $555,185 $555,185 Amount available in cash for spending (Fire Department Accounts) $555,185 General Fund 135 Available $ 4,659,795 Prosperity General Fund $ 2,997,691 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 7,658,086 General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) $ 3,880 Assigned Fund Balance (FY2024 Capital Projects plus prior year carry forward) $ 6,575,044 Unassigned Fund Balance $ 3,929,601 Current Year Revenue/Expenses $ (80,425) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,428,100 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections MUD Connections PID Connections Town October Utility Billing Report Fiscal Year 2023 - 2024 October 2022 November 2022 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 August 2023 September 2023 October 2023 1,667 1,710 1,746 1,765 1,777 1,773 1,767 1,794 1,766 1,750 1,744 1,742 1,745 3,822 3,801 3,768 3,741 3,751 3,744 3,743 3,734 3,755 3,749 3,747 3,747 3,737 706 711 630 606 599 599 590 588 589 585 578 572 569 1,501 1,494 2,251 2,540 2,719 3,016 2,998 2,754 3,134 3,101 2,957 3,086 3,072 1,159 1,049 337 0 0 0 547 413 289 290 327 327 268 344 255 0 4 0 0 0 0 8 9 9 13 7 7 13 3,399 3,399 3,399 3,394 3,394 3,394 3,394 3,394 3,395 3,395 3,395 3,395 3,395 1,444 1,444 1,444 1,444 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,443 0 0 0 0 0 0 0 0 0 0 0 0 1 October Permits Fiscal Year 2024 Date of Permit Permit No. Customer Deposit Due to FW Water Oversize Meter Plumbing Inspections Sewer Inspections Fire Line Misc. Income Total 10/3/2023 2024-01 $ 100.00 $ 4,396.00 $ 428.00 $ 150.00 $ - $ - $ - $ 5,074.00 Total $ 100.00 $ 4,396.00 $ 428.00 $ 150.00 $ - $ - $ - $ 5,074.00