Loading...
HomeMy WebLinkAbout2023-12 December Combined FinancialsCheck Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 12/01/2023 - 12/31/2023 Vendor Number Vendor Name Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular Payment Date Payment Type Discount Amount Payment Amount Number 2558 First Check Applicant Screenin 12/06/2023 Regular 3298 308 Construction LLC 12/06/2023 Regular 2222 Aflac 12/06/2023 Regular 2691 All Test Fire Protection LLC 12/06/2023 Regular 2772 Allied Waste Industries 12/06/2023 Regular 3127 Allied Welding Supply Inc. 12/06/2023 Regular 3197 BenefitMall 12/06/2023 Regular 3299 Bickerstaff Heath Delgado Acosta LLP 12/06/2023 Regular 1250 Bio -Aquatic Testing Inc. 12/06/2023 Regular 4018 BP Energy Holding Company LLC 12/06/2023 Regular 1030 City of Fort Worth 12/06/2023 Regular 2786 Cleargov Inc 12/06/2023 Regular 3184 Dataprose LLC 12/06/2023 Regular 1737 DPC Industries Inc. 12/06/2023 Regular 1026 Federal Express Corp 12/06/2023 Regular 2558 First Check Applicant Screenin 12/06/2023 Regular 3093 Four Man Furnace Inc. 12/06/2023 Regular 2796 Garver 12/06/2023 Regular 3292 Grapevine Dodge Chrysler Jeep 12/06/2023 Regular 4033 Health Care Service Corporation 12/06/2023 Regular 2802 Industrial Disposal Supply LLC 12/06/2023 Regular 3297 J&L Construction LLC 12/06/2023 Regular 2783 JJ HVAC LLC 12/06/2023 Regular 2943 JP Morgan Chase Bank NA 12/06/2023 Regular 3278 Kyocera Document Solutions 12/06/2023 Regular 3132 Legal Shield 12/06/2023 Regular 3186 Member's Building Maintenance 12/06/2023 Regular 3115 Metlife Group Benefits 12/06/2023 Regular 3200 Mettler -Toledo LLC 12/06/2023 Regular 2760 NDS Leasing 12/06/2023 Regular 1056 Office Depot Inc 12/06/2023 Regular 4019 Peterson Pump & Motor Service LLC 12/06/2023 Regular 3134 Prime Controls LP 12/06/2023 Regular 2703 RDO Equipment Co. 12/06/2023 Regular 3176 Rey -Mar Construction 12/06/2023 Regular 2821 Ricochet Fuel Distributors,Inc 12/06/2023 Regular 2809 Rod L Abbott CPA LLC 12/06/2023 Regular 2633 Sluder Emergency Power Service 12/06/2023 Regular 1578 Smith Pump Company, Inc. 12/06/2023 Regular 3156 Southern Petroleum Lab Inc 12/06/2023 Regular 2659 Tarrant Appraisal District 12/06/2023 Regular 2696 Texas Excavation Safety System 12/06/2023 Regular 1000 Trophy Club Mud (Water Bills) 12/06/2023 Regular 2798 Tyler Technologies Inc 12/06/2023 Regular 3225 US Bank Voyager Fleet Systems 12/06/2023 Regular 2196 Victor Insurance Managers 12/06/2023 Regular 2970 Air Mac 12/18/2023 Regular 2772 Allied Waste Industries 12/18/2023 Regular 2683 Charter Communications 12/18/2023 Regular 3184 Dataprose LLC 12/18/2023 Regular 1018 Denton Central Appraisal District 12/18/2023 Regular 3118 Exclusive Pest Control 12/18/2023 Regular 2606 Fisery Solutions LLC 12/18/2023 Regular 0.00 -160.45 9347 0.00 158,650.00 10018 0.00 446.16 10019 0.00 719.88 10020 0.00 1,833.80 10021 0.00 21.15 10022 0.00 52.00 10023 0.00 5,575.05 10024 0.00 1,170.00 10025 0.00 42,181.06 10026 0.00 253,960.96 10027 0.00 13,498.73 10028 0.00 456.48 10029 0.00 1,557.08 10030 0.00 6.05 10031 0.00 160.45 10032 0.00 31.25 10033 0.00 8,700.30 10034 0.00 37,791.00 10035 0.00 22,147.36 10036 0.00 2,002.44 10037 0.00 294,652.86 10038 0.00 825.00 10039 0.00 7,163.74 10040 0.00 94.50 10041 0.00 15.95 10042 0.00 1,207.35 10043 0.00 2,301.06 10044 0.00 402.82 10045 0.00 350.00 10046 0.00 439.99 10047 0.00 4,345.00 10048 0.00 1,028.75 10049 0.00 1,374.77 10050 0.00 7,394.47 10051 0.00 4,491.53 10052 0.00 5,500.00 10053 0.00 2,431.25 10054 0.00 8,635.00 10055 0.00 1,728.00 10056 0.00 2,142.72 10057 0.00 252.70 10058 0.00 393.83 10059 0.00 150.00 10060 0.00 1,969.13 10061 0.00 142.00 10062 0.00 3,924.50 10072 0.00 6,567.28 10073 0.00 903.72 10074 0.00 2,594.79 10075 0.00 1,967.85 10076 0.00 245.00 10077 0.00 50.00 10078 1/11/2024 1:07:41 PM Page 1 of 4 Check Report Vendor Number 2796 2754 3216 2784 4019 3156 3182 2440 1001 1058 3280 Vendor Name Garver Lower Colorado River Authority M3 Networks Manning Concrete Sawing Peterson Pump & Motor Service LLC Southern Petroleum Lab Inc Strategic Government Resources Tarrant County Public Health Laboratory Town of Trophy Club Verizon Wireless Watts Ellison LLC Payment Date 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 Payment Type Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Total Regular: Date Range: 12/01/2023 - 12/31/2023 Discount Amount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Payment Amount 8,418.60 828.00 1,047.00 2,496.39 690.00 4,028.40 180.00 500.00 228,233.40 584.11 3,559.34 1,167,051.55 Number 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 1/11/2024 1:07:41 PM Page 2 of 4 Check Report Vendor Number Payment Type: 3197 3113 3124 3197 3113 3124 Vendor Name Bank Draft BenefitMall TCDRS IRS Tax Payment BenefitMall TCDRS IRS Tax Payment Payment Type Regular Checks Manual Checks Voided Checks Bank Drafts EFT's Date Range: 12/01/2023 - 12/31/2023 Payment Date Payment Type Discount Amount Payment Amount Number 12/08/2023 12/31/2023 12/08/2023 12/22/2023 12/31/2023 12/22/2023 Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Total Bank Draft: Bank Code Prosperity Bank Summary Payable Count 94 0 0 6 0 100 Payment Count 63 0 1 6 0 70 Discount Payment 0.00 1,167,212.00 0.00 0.00 0.00 -160.45 0.00 46,770.04 0.00 0.00 0.00 1,213,821.59 0.00 0.00 0.00 0.00 0.00 0.00 0.00 266.67 9,914.43 13,391.92 266.67 10,038.11 12,892.24 46,770.04 DFT0000123 DFT0000124 DFT0000125 DFT0000126 DFT0000127 DFT0000128 1/11/2024 1:07:41 PM Page 3 of 4 Check Report Date Range: 12/01/2023 - 12/31/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 94 63 0.00 1,167,212.00 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -160.45 Bank Drafts 6 6 0.00 46,770.04 EFT's 0 0 0.00 0.00 100 70 0.00 1,213,821.59 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 12/2023 1,213,821.59 1,213,821.59 1/11/2024 1:07:41 PM Page 4 of 4 FY 2024 Combined Financials YTD as of 12/31/2023 YTD Revenues • YTD Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $2,671,103 $3,224,430 $14,423,933 $14,423,933 51,100 529,818 0% $514,579 16% 1 1% YTD Expenses By Departments YTD Expense- Water $1,790,529 $888,403 55% YTD Expense- WW 28% 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 92,198,177 Oct Water Consumption Budget vs Actual 112,006,200 61,555,000 48,355,000 51,503,997 46,670,584 Budget Consumption—1—Actual Consumption Nov Dec 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 900,222,298 868.678,857 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $1,000,000 5900,000 $800,000 $700,000 $600,000 5500,000 5400,000 5300,000 5200,000 $100,000 $0 Water Revenue Budget vs Actual $493,961 $554,257 s $413,727 Oct 3297,607 Budget Revenue --Actual Revenue Nov $272,019 Dec $6,000,000 55,000,000 $4,000,000 $3,000,000 52,000,000 51,000,000 50 Adopted Budget Water Revenue Vs Projected Water Revenue $5,166,291 $5,626,525 $2,510,794 Total Water Revenue $2,990,721 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses Fund: 135 - MUD 1 Ge Revenue Department: 000 - 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 Trophy Club Municipal Utility District No. 1 neral Fund Revenue, 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 135-010-60020-000 135-010-60066-000 135-010-60080-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 14,423,932.76 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: 12/31/2023 Period Activity 39,740.28 -39.07 3.37 0.00 413,726.80 298,222.57 15,399.02 400.00 300.00 100.00 470.40 40,713.97 4,120.00 0.00 0.00 0.00 856.00 0.00 0.00 814,013.34 Variance Fiscal Favorable Percent Activity (Unfavorable) Remaining 43,258.00 65.66 38.14 0.00 1,584,117.97 859,106.92 32,450.86 1,650.00 450.00 100.00 14,781.60 121,559.76 12,240.00 0.00 0.00 0.00 1,284.00 0.00 0.00 2,671,102.91 -42,475.51 -234.34 -261.86 -143,223.25 -5,355,880.03 -2,820,679.08 -73,349.14 -1,700.00 150.00 0.00 -55,218.40 -28,440.24 -37,080.00 -25,000.00 -1,933,264.00 -50,000.00 -774.00 -1,178,400.00 -7,000.00 -11,752,829.85 49.54 78.11 % 87.29 100.00 % 77.17 76.65 % 69.33 50.75 % 150.00 % 0.00 % 78.88 % 18.96 % 75.18 % 100.00 % 100.00 % 100.00 % 37.61 % 100.00 % 100.00 % 81.48% Revenue Total: 14,423,932.76 14,423,932.76 814,013.34 2,671,102.91 -11,752,829.85 81.48% Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental lnsurance 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 Electricity Publications/Books/Subscripts Schools & Training 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 400.00 400.00 300.00 300.00 201,500.00 201,500.00 2,000.00 2,000.00 5,000.00 5,000.00 1,000.00 1,000.00 2,500.00 2,500.00 7,500.00 7,500.00 2,000.00 2,000.00 7,500.00 7,500.00 183,143.49 183,143.49 1,000.00 1,000.00 2,630.00 2,630.00 33,845.44 658.44 0.00 225.00 4,167.48 8,444.02 350.33 71.27 286.69 2,087.99 488.31 0.00 1,060.94 0.00 0.00 5,569.85 0.00 0.00 0.00 0.00 220.00 0.00 334.77 14,805.45 0.00 1,550.00 92,467.61 3,075.97 6,252.50 675.00 13,273.65 25,332.06 1,050.99 213.87 864.07 6,182.81 1,445.96 0.00 3,182.82 0.00 0.00 13,247.83 951.60 953.90 1,911.94 40.31 1,434.00 574.00 1,004.41 34,019.68 0.00 1,663.75 339,107.41 13,924.03 0.00 2,925.00 43,456.76 91,195.44 3,783.56 837.14 3,135.93 22,239.70 5,201.24 1,260.00 8,715.74 400.00 300.00 188,252.17 1,048.40 4,046.10 -911.94 2,459.69 6,066.00 1,426.00 6,495.59 149,123.81 1,000.00 966.25 78.57 % 81.91 % 0.00 % 81.25 % 76.60 % 78.26 % 78.26 % 79.65 % 78.40 % 78.25 % 78.25 % 100.00 % 73.25 % 100.00 % 100.00 % 93.43 % 52.42 % 80.92 % -91.19 % 98.39 % 80.88 % 71.30 % 86.61 % 81.42 % 100.00 % 36.74 % 1/11/2024 3:56:33 PM Budget Report 135-010-60100-000 135-010-60135-000 135-010-60135-001 135-010-60150-000 135-010-60285-000 135-010-60332-000 135-010-65005-000 135-010-65010-000 135-010-65030-000 135-010-65050-000 135-010-65053-000 135-010-69005-000 135-010-69195-000 For Fiscal: 2023-2024 Period Ending: 12/31/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Travel & per diem 577.50 577.50 590.44 590.44 -12.94 -2.24 % TCEQ Fees & Permits 29,500.00 29,500.00 0.00 8,964.55 20,535.45 69.61 TCEQ Fees & Permits for PID 500.00 500.00 0.00 0.00 500.00 100.00 % Wholesale Water 2,655,497.13 2,655,497.13 166,425.88 420,386.84 2,235,110.29 84.17 % Lawn Equipment & Maintenance 12,500.00 12,500.00 1,200.00 2,400.00 10,100.00 80.80 % Interfund Transfer Out -Rev I&S 565,796.88 565,796.88 51,500.52 154,501.56 411,295.32 72.69 Fuel & Lube 23,575.00 23,575.00 995.20 4,275.56 19,299.44 81.86 % Uniforms 4,355.00 4,355.00 415.96 725.86 3,629.14 83.33 % Chemicals 58,200.00 58,200.00 2,465.15 10,584.44 47,615.56 81.81 % Meter Expense 20,000.00 20,000.00 0.00 0.00 20,000.00 100.00 % Meter Change Out Program 124,500.00 124,500.00 0.00 0.00 124,500.00 100.00 % Capital Outlays 4,200,000.00 4,200,000.00 96,367.82 599,622.39 3,600,377.61 85.72 % GASB Reserve for Replacement 378,659.00 378,659.00 0.00 378,659.00 0.00 0.00 % Department: 010 - Water Total: 9,179,933.26 9,179,933.26 394,126.95 1,790,529.37 7,389,403.89 80.50% Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 290,304.62 290,304.62 18,286.05 50,768.76 239,535.86 82.51 % 135-020-50010-000 Overtime 20,000.00 20,000.00 618.50 2,809.51 17,190.49 85.95 % 135-020-50016-000 Longevity 2,367.50 2,367.50 0.00 2,540.00 -172.50 -7.29 % 135-020-50017-000 Certification 5,100.00 5,100.00 225.00 675.00 4,425.00 86.76 % 135-020-50020-000 Retirement 40,934.05 40,934.05 2,295.54 7,336.22 33,597.83 82.08 % 135-020-50026-000 Medical Insurance 93,222.04 93,222.04 4,503.48 13,510.44 79,711.60 85.51 % 135-020-50027-000 Dental Insurance 3,385.28 3,385.28 166.51 499.53 2,885.75 85.24 % 135-020-50028-000 Vision Insurance 818.82 818.82 42.52 127.56 691.26 84.42 % 135-020-50029-000 Life Insurance & Other 3,000.00 3,000.00 148.16 506.78 2,493.22 83.11 % 135-020-50030-000 Social Security Taxes 20,507.87 20,507.87 1,138.15 3,393.82 17,114.05 83.45 % 135-020-50035-000 Medicare Taxes 4,796.20 4,796.20 266.18 793.69 4,002.51 83.45 % 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 2,246.79 6,156.82 73.26 % 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 17,274.50 39,877.25 97,122.75 70.89 % 135-020-55081-000 Mainten & Repairs Collections 270,000.00 270,000.00 320.00 37,843.99 232,156.01 85.98 % 135-020-55085-000 Generator Maint. and Repair 11,000.00 11,000.00 4,678.06 6,478.06 4,521.94 41.11 % 135-020-55090-000 Vehicle Maintenance 4,600.00 4,600.00 0.00 142.94 4,457.06 96.89 % 135-020-55091-000 Veh Maintenance Collections 13,000.00 13,000.00 40.75 3,347.76 9,652.24 74.25 % 135-020-55105-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 0.00 1,374.77 1,625.23 54.17 % 135-020-55120-000 Cleaning Services 2,000.00 2,000.00 0.00 40.31 1,959.69 97.98 % 135-020-55125-000 Dumpster Services 100,000.00 100,000.00 0.00 13,238.50 86,761.50 86.76 % 135-020-55135-000 Lab Analysis 55,000.00 55,000.00 6,271.20 19,748.02 35,251.98 64.09 % 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 200.92 602.70 6,897.30 91.96 % 135-020-60020-000 Electricity 242,978.33 242,978.33 21,767.03 44,007.86 198,970.47 81.89 % 135-020-60080-000 Schools & Training 2,119.00 2,119.00 425.00 425.00 1,694.00 79.94 % 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 0.00 9,888.02 2,111.98 17.60 % 135-020-60285-000 Lawn Equipment & Maintenance 16,000.00 16,000.00 1,420.00 2,720.00 13,280.00 83.00 % 135-020-60331-000 Interfund Transfer Out -Tax I&S 115,885.76 115,885.76 10,535.09 31,605.27 84,280.49 72.73 % 135-020-60332-000 Interfund Transfer Out -Rev I&S 698,542.63 698,542.63 63,548.65 190,645.95 507,896.68 72.71 % 135-020-65005-000 Fuel & Lube 13,000.00 13,000.00 527.55 5,782.03 7,217.97 55.52 % 135-020-65010-000 Uniforms 3,520.00 3,520.00 441.02 581.90 2,938.10 83.47 % 135-020-65030-000 Chemicals 32,500.00 32,500.00 0.00 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 0.00 16,970.67 16,029.33 48.57 % 135-020-69005-000 Capital Outlays 1,050,000.00 1,050,000.00 3,909.10 219,448.10 830,551.90 79.10 % 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 0.00 155,762.00 0.00 0.00 % Department: 020 - Wastewater Total: 3,506,323.94 3,506,323.94 159,797.89 888,403.29 2,617,920.65 74.66% 1/11/2024 3:56:33 PM Budget Report For Fiscal: 2023-2024 Period Ending: 12/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 135-026-60070-000 Dues & Memberships 135-026-60075-000 Meetings 135-026-60080-000 Schools & Training 135-026-60100-000 Travel & per diem 135-026-60245-000 Miscellaneous Expenses Department: 026 - Board of Directors Total: Department: 030 - Administration 135-030-50005-000 Salaries & Wages 135-030-50010-000 Overtime 135-030-50016-000 Longevity 135-030-50020-000 Retirement 135-030-50026-000 Medical Insurance 135-030-50027-000 Dental lnsurance 135-030-50028-000 Vision Insurance 135-030-50029-000 Life Insurance & Other 135-030-50030-000 Social Security Taxes 135-030-50035-000 Medicare Taxes 135-030-50040-000 Unemployment Taxes 135-030-50045-000 Workman's Compensation 135-030-50060-000 Pre-emp Physicals/Testing 135-030-50070-000 Employee Relations 135-030-55030-000 Software & Support 135-030-55080-000 Maintenance & Repairs 135-030-55085-000 Generator Maint. and Repair 135-030-55120-000 Cleaning Services 135-030-55160-000 Professional Outside Services 135-030-55205-000 Utility Billing Contract 135-030-60005-000 Telephone 135-030-60010-000 Communications/Mobiles 135-030-60020-000 Electricity/Gas 135-030-60025-000 Water 135-030-60035-000 Postage 135-030-60040-000 Service Charges & Fees 135-030-60050-000 Bad Debt Expense 135-030-60055-000 Insurance 135-030-60070-000 Dues & Memberships 15.00 750.00 1,500.00 4,000.00 5,000.00 500.00 15.00 750.00 1,500.00 4,000.00 5,000.00 500.00 11,765.00 11,765.00 663,185.25 2,000.00 2,532.50 82,631.07 108,759.00 3,816.74 886.17 4,800.00 41,398.50 9,681.91 1,512.00 1,597.19 500.00 4,000.00 130,311.00 23,000.00 1,000.00 13,825.00 100,000.00 9,000.00 6,000.00 3,000.00 17,684.51 5,000.00 30,000.00 140,000.00 13,000.00 116,158.22 6,800.00 663,185.25 2,000.00 2,532.50 82,631.07 108,759.00 3,816.74 886.17 4,800.00 41,398.50 9,681.91 1,512.00 1,597.19 500.00 4,000.00 130,311.00 23,000.00 1,000.00 13,825.00 100,000.00 9,000.00 6,000.00 3,000.00 17,684.51 5,000.00 30,000.00 140,000.00 13,000.00 116,158.22 6,800.00 0.66 0.00 115.99 0.00 0.00 0.00 116.65 51,393.43 134.41 0.00 6,138.57 6,755.22 241.48 55.33 252.58 2,565.10 716.27 0.00 139.51 0.00 2,859.44 25,490.40 2,732.73 0.00 1,200.00 430.00 672.73 546.98 48.26 1,293.36 336.18 1,988.30 26,979.32 0.00 9,618.44 794.00 1.98 750.00 347.97 0.00 0.00 0.00 13.02 0.00 1,152.03 4,000.00 5,000.00 500.00 86.80 % 0.00 76.80 % 100.00 100.00 % 100.00 % 1,099.95 10,665.05 90.65% 141,118.53 205.35 2,597.50 18,592.97 20,265.66 724.44 166.05 1,147.68 8,081.78 2,006.48 0.00 418.53 0.00 2,859.44 92,253.57 2,732.73 1,348.04 3,374.70 73,120.30 1,964.89 1,465.64 144.78 2,537.88 1,153.51 7,460.92 63,483.65 0.00 28,855.32 1,285.00 522,066.72 1,794.65 -65.00 64,038.10 88,493.34 3,092.30 720.12 3,652.32 33,316.72 7,675.43 1,512.00 1,178.66 500.00 1,140.56 38,057.43 20,267.27 -348.04 10,450.30 26,879.70 7,035.11 4,534.36 2,855.22 15,146.63 3,846.49 22,539.08 76,516.35 13,000.00 87,302.90 5,515.00 78.72 % 89.73 % -2.57 % 77.50 % 81.37 % 81.02 % 81.26 % 76.09 % 80.48 % 79.28 % 100.00 % 73.80 % 100.00 % 28.51 % 29.21 % 88.12 % -34.80 % 75.59 % 26.88 % 78.17 % 75.57 % 95.17 % 85.65 % 76.93 % 75.13 % 54.65 % 100.00 % 75.16 % 81.10 % 135-030-60080-000 Schools & Training 3,900.00 3,900.00 800.00 1,313.10 2,586.90 66.33 % 135-030-60100-000 135-030-60115-000 135-030-60285-000 135-030-60360-000 135-030-65010-000 135-030-65055-000 135-030-65085-000 135-030-65095-000 135-030-69170-000 135-030-69195-000 Travel & per diem 1,227.50 1,227.50 0.00 0.00 1,227.50 100.00 % Elections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % Lawn Equipment & Maintenance 5,000.00 5,000.00 939.34 1,409.01 3,590.99 71.82 % Furniture/Equipment < $5000 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % Uniforms 530.00 530.00 0.00 0.00 530.00 100.00 % Hardware 8,200.00 8,200.00 0.00 2,476.46 5,723.54 69.80 % Office Supplies 5,000.00 5,000.00 383.75 1,650.77 3,349.23 66.98 % Maintenance Supplies 5,000.00 5,000.00 812.41 2,784.80 2,215.20 44.30 % Copier Lease Installments 4,000.00 4,000.00 124.78 676.67 3,323.33 83.08 % GASB Reserve for Replacement 24,903.00 24,903.00 0.00 24,903.00 0.00 0.00 % Department: 030 - Administration Total: 1,612,839.56 1,612,839.56 146,442.32 514,579.15 1,098,260.41 68.09% Department: 039 - Non Departmental 135-039-55045-000 Legal 65,000.00 65,000.00 6,191.15 11,766.20 53,233.80 81.90 % 135-039-55055-000 Auditing 30,000.00 30,000.00 5,500.00 10,000.00 20,000.00 66.67 % 135-039-55060-000 Appraisal 13,071.00 13,071.00 1,967.85 4,110.57 8,960.43 68.55 % 1/11/2024 3:56:33 PM Budget Report Original Current Total Budget Total Budget For Fiscal: Period Activity 2023-2024 Period Ending: 12/31/2023 Variance Fiscal Favorable Percent Activity (Unfavorable) Remaining 135-039-55065-000 Tax Admin Fees 5,000.00 5,000.00 3,941.00 3,941.00 1,059.00 21.18 Department: 039 - Non Departmental Total: 113,071.00 113,071.00 17,600.00 29,817.77 83,253.23 73.63% Expense Total: 14,423,932.76 14,423,932.76 718,083.81 Fund: 135 - MUD 1 General Fund Surplus (Deficit): Report Surplus (Deficit): 3,224,429.53 11,199,503.23 77.65% 0.00 0.00 95,929.53 -553,326.62 -553,326.62 0.00% 0.00 0.00 95,929.53 -553,326.62 -553,326.62 0.00% 1/11/2024 3:56:33 PM Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Liability 000 - Revenue, Asset, Liability, & Equity Total Asset: Total Liability: 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): Balance Sheet Funds 122 - 528 Account Summary As Of 12/31/2023 122 - Trophy Club 135 - MUD 1 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 MUD Fire Dept. General Fund Consolidated Bond Const- Bond 16" Revenue Bond GASB SWIFT Waterline Reserve Fund 1,704,677.66 1,704,677.66 11,220,355.35 3,898,890.58 911,784.38 1,195,080.37 11,220,355.35 3 898,890.58 911,784.38 1,195,080.37 955,147.53 955,147.53 656,464.88 656,464.88 766,150.10 1,066,110.87 0.00 81,691.15 0.00 1,066,110.87 0.00 81,691.15 0.00 10,707,571.10 3,258,146.58 735,325.73 1,179,058.79 766,150.10 668,482.72 386,420.04 282,062.68 1,048,212.78 1,704,677.66 0.00 0.00 942,342.55 10,707,571.10 3,258,146.58 735,325.73 1,179,058.79 2,671,102.91 640,744.00 9,715.58 16,021.58 3,224,429.53 0.00 -85,051.92 0.00 -553,326.62 640,744.00 94,767.50 16,021.58 10,154,244.48 3,898,890.58 830,093.23 1,195,080.37 11,220,355.35 3 898 890.58 911,784.38 1,195,080.37 Monthly Financial Activity Footnotes: 942,342.55 12,804.98 0.00 12,804.98 955,147.53 955,147.53 Total 19,885,935.87 19 885,935.87 1,804,266.90 1,804,266.90 17,588,594.85 17,588,594.85 4,018,871.77 3,525,797.65 493,074.12 18,081,668.97 19,885,935.87 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 I&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 1/11/2024 4:07:36 PM Page 1 of 1 Department Trophy Club Municipal Utility District No. 1 533 - MUD 1 I&S 534 - 2015 535 - 2016 Rev 536 - 2019 Rev Consolidated Revenue Bond Bond I&S-SWIFT Bond I&S- I&S W&WW System Balance Sheet I&S Funds 533 - 536 Account Summary As Of 12/31/2023 Total Asset 000 - Revenue, Asset, Liability, & Equity 341,308.52 207,364.13 86,973.06 110,746.79 746,392.50 Total Asset: 341,308.52 207,364.13 86,973.06 110,746.79 746,392.50 Liability 000 - Revenue, Asset, Liability, & Equity 107,922.76 0.00 0.00 0.00 107,922.76 Total Liability: 107,922.76 0.00 0.00 0.00 107,922.76 Equity 000 - Revenue, Asset, Liability, & Equity 89,219.04 39,137.14 11,713.62 6,476.05 146,545.85 Total Total Beginning Equity: 89,219.04 39,137.14 11,713.62 6,476.05 146,545.85 Total Revenue 144,166.72 168,226.99 75,259.44 104,270.74 491,923.89 Total Expense 0.00 0.00 0.00 0.00 0.00 Revenues Over/Under Expenses 144,166.72 168,226.99 75,259.44 104,270.74 491,923.89 Total Equity and Current Surplus (Deficit): 233,385.76 207,364.13 86,973.06 110,746.79 638,469.74 Total Liabilities, Equity and Current Surplus (Deficit): 341,308.52 207,364.13 86,973.06 110,746.79 746,392.50 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 l&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 l&S 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 l&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest 1/11/2024 4:11:06 PM Page 1 of 1 CASH STATUS AS OF DECEMBER 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,852,451 $2,852,451 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $146,080 $5,166,102 $5,312,182 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,952,291 $0 $1,952,291 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-10300 Prosperity Bank (XXX8701) SWIFT $85,052 $0 $85,052 51 9-1 11 55 Cash -Bond Escrow Bank of Texas (SWIFT) $826,732 $0 $826,732 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,195,080 $0 $1,195,080 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $955,148 $0 $955,148 533-10250 TexPool Tax I & S (XXXXX0003) $230,002 $0 $230,002 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $207,364 $0 $207,364 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $86,973 $0 $86,973 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $110,747 $0 $110,747 $8,019,153 $17,713,513 Amount available in cash for spending (MUD Accounts) *12/31/2023 Customer Water Deposits $146,080 Fire Department Cash $8,019,153 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $1,022,924 $1,022,924 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $1,022,924 $1,022,924 Amount available in cash for spending (Fire Department Accounts) Total General Fund 135 Available for Spending $1,022,924 General Fund 135 Available $ 5,166,102 Prosperity General Fund $ 2,852,451 Texpool General Fund $ 600 Petty Cash $ 8,019,153 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,187,684 Current Year Revenue/Expenses $ (553,327) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,154,244 ebills Bills Mailed Bank Draft Online Payments Late Notices Disconnects Connections MUD Connections Town December Utility Billing Report Fiscal Year 2023 - 2024 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 August 2023 September 2023 October 2023 November 2023 December 2023 1,746 1,765 1,777 1,773 1,767 1,794 1,766 1,750 1,744 1,742 1,745 1,740 1,737 3,768 3,741 3,751 3,744 3,743 3,734 3,755 3,749 3,747 3,747 3,737 3,739 3,742 630 606 599 599 590 588 589 585 578 572 569 562 567 2,251 2,540 2,719 3,016 2,998 2,754 3,134 3,101 2,957 3,086 3,072 3,006 3,133 0 0 547 413 289 290 327 327 268 344 255 298 342 0 0 0 0 8 9 9 13 7 7 13 4 5 3,399 3,394 3,394 3,394 3,394 3,394 3,395 3,395 3,395 3,395 3,395 3,395 3,395 1,444 1,444 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,444 1,444 1,446 December 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 12/8/2023 2024-02 $ 100.00 $ 4,396.00 $ 428.00 $ 150.00 $ 50.00 $ - $ - $ 5,124.00 12/21/2023 2024-03 $ 100.00 $ 4,396.00 $ 428.00 $ 150.00 $ 50.00 $ - $ - $ 5,124.00 Total $ 200.00 $ 8,792.00 $ 856.00 $ 300.00 $ 100.00 $ - $ - $ 10,248.00