Loading...
HomeMy WebLinkAbout2023-09 September Finance ReportsCheck Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 09/01/2023 - 09/30/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular 2796 Garver 09/29/2023 Regular 0.00 -610.00 9639 3298 308 Construction LLC 09/20/2023 Regular 0.00 25,650.00 9857 3127 Allied Welding Supply Inc. 09/20/2023 Regular 0.00 20.76 9858 3299 Bickerstaff Heath Delgado Acosta LLP 09/20/2023 Regular 0.00 7,089.25 9859 4025 Caldwell Country Chevrolet LLC 09/20/2023 Regular 0.00 38,815.00 9860 2683 Charter Communications 09/20/2023 Regular 0.00 903.72 9861 2655 Core & Main LP 09/20/2023 Regular 0.00 1,175.00 9862 3184 Dataprose LLC 09/20/2023 Regular 0.00 346.07 9863 1018 Denton Central Appraisal District 09/20/2023 Regular 0.00 2,163.63 9864 3118 Exclusive Pest Control 09/20/2023 Regular 0.00 365.00 9865 2800 Ferguson Enterprises LLC 09/20/2023 Regular 0.00 88.42 9866 2606 Fisery Solutions LLC 09/20/2023 Regular 0.00 50.00 9867 1372 Hach Company 09/20/2023 Regular 0.00 293.54 9868 2635 Halff Associates Inc. 09/20/2023 Regular 0.00 1,380.32 9869 2750 Handling Systems & Conveyors 09/20/2023 Regular 0.00 775.60 9870 3297 J&L Construction LLC 09/20/2023 Regular 0.00 313,668.25 9871 2785 Kleen Pipe, Inc 09/20/2023 Regular 0.00 52,950.00 9872 3216 M3 Networks 09/20/2023 Regular 0.00 678.23 9873 1056 Office Depot Inc 09/20/2023 Regular 0.00 500.36 9874 4019 Peterson Pump & Motor Service LLC 09/20/2023 Regular 0.00 1,710.00 9875 3134 Prime Controls LP 09/20/2023 Regular 0.00 872.00 9876 3176 Rey -Mar Construction 09/20/2023 Regular 0.00 45,797.00 9877 3156 Southern Petroleum Lab Inc 09/20/2023 Regular 0.00 1,728.00 9878 3182 Strategic Government Resources 09/20/2023 Regular 0.00 450.00 9879 2440 Tarrant County Public Health Laboratory 09/20/2023 Regular 0.00 790.00 9880 2696 Texas Excavation Safety System 09/20/2023 Regular 0.00 192.85 9881 1001 Town of Trophy Club 09/20/2023 Regular 0.00 205,680.33 9882 1081 Tri County Electric 09/20/2023 Regular 0.00 709.46 9883 4029 Trojan Technolgoies Group ULC 09/20/2023 Regular 0.00 898.00 9884 4029 Trojan Technolgoies Group ULC 09/20/2023 Regular 0.00 -898.00 9884 4000 UST General Contracting LLC 09/20/2023 Regular 0.00 8,509.43 9885 1058 Verizon Wireless 09/20/2023 Regular 0.00 703.60 9886 2222 Aflac 09/29/2023 Regular 0.00 446.16 9887 1250 Bio -Aquatic Testing Inc. 09/29/2023 Regular 0.00 1,290.00 9888 4018 BP Energy Holding Company LLC 09/29/2023 Regular 0.00 57,645.76 9889 1030 City of Fort Worth 09/29/2023 Regular 0.00 466,489.41 9890 1737 DPC Industries Inc. 09/29/2023 Regular 0.00 1,557.08 9891 2796 Garver 09/29/2023 Regular 0.00 610.00 9892 2796 Garver 09/29/2023 Regular 0.00 7,192.74 9893 2635 Halff Associates Inc. 09/29/2023 Regular 0.00 1,325.00 9894 3297 J&L Construction LLC 09/29/2023 Regular 0.00 255,204.77 9895 2943 JP Morgan Chase Bank NA 09/29/2023 Regular 0.00 5,507.72 9896 3278 Kyocera Document Solutions 09/29/2023 Regular 0.00 81.07 9897 3132 Legal Shield 09/29/2023 Regular 0.00 15.95 9898 2754 Lower Colorado River Authority 09/29/2023 Regular 0.00 213.92 9899 2784 Manning Concrete Sawing 09/29/2023 Regular 0.00 2,510.82 9900 3186 Member's Building Maintenance 09/29/2023 Regular 0.00 1,319.80 9901 2760 NDS Leasing 09/29/2023 Regular 0.00 175.00 9902 4019 Peterson Pump & Motor Service LLC 09/29/2023 Regular 0.00 960.00 9903 3134 Prime Controls LP 09/29/2023 Regular 0.00 6,229.00 9904 3156 Southern Petroleum Lab Inc 09/29/2023 Regular 0.00 1,335.60 9905 4029 Trojan Technolgoies Group ULC 09/29/2023 Regular 0.00 1,271.25 9906 1000 Trophy Club Mud (Water Bills) 09/29/2023 Regular 0.00 453.16 9907 10/18/2023 7:58:11 PM Page 1 of 4 Check Report Date Range: 09/01/2023 - 09/30/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 2798 Tyler Technologies Inc 09/29/2023 Regular 0.00 260.00 9908 3225 US Bank Voyager Fleet Systems 09/29/2023 Regular 0.00 3,896.43 9909 3280 Watts Ellison LLC 09/29/2023 Regular 0.00 1,719.67 9910 Total Regular: 0.00 1,531,156.13 10/18/2023 7:58:11 PM Page 2 of 4 Check Report Date Range: 09/01/2023 - 09/30/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payment Type: Bank Draft 3197 BenefitMall 09/01/2023 Bank Draft 0.00 266.67 DFT0000100 3113 TCDRS 09/30/2023 Bank Draft 0.00 9,455.68 DFT0000101 3124 IRS Tax Payment 09/01/2023 Bank Draft 0.00 12,735.51 DFT0000102 3197 BenefitMall 09/15/2023 Bank Draft 0.00 266.67 DFT0000103 3113 TCDRS 09/30/2023 Bank Draft 0.00 9,861.73 DFT0000104 3124 IRS Tax Payment 09/15/2023 Bank Draft 0.00 13,220.30 DFT0000105 3113 TCDRS 09/30/2023 Bank Draft 0.00 9,189.82 DFT0000106 3124 IRS Tax Payment 09/29/2023 Bank Draft 0.00 12,907.53 DFT0000107 Total Bank Draft: 0.00 67,903.91 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 78 54 0.00 1,532,664.13 Manual Checks 0 0 0.00 0.00 Voided Checks 0 2 0.00 -1,508.00 Bank Drafts 8 8 0.00 67,903.91 EFT's 0 0 0.00 0.00 86 64 0.00 1,599,060.04 10/18/2023 7:58:11 PM Page 3 of 4 Check Report Date Range: 09/01/2023 - 09/30/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 78 54 0.00 1,532,664.13 Manual Checks 0 0 0.00 0.00 Voided Checks 0 2 0.00 -1,508.00 Bank Drafts 8 8 0.00 67,903.91 EFT's 0 0 0.00 0.00 86 64 0.00 1,599,060.04 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 9/2023 1,599,060.04 1,599,060.04 10/18/2023 7:58:11 PM Page 4 of 4 FY 2023 Combined Financials YTD as of 9/30/2023 101 YTD Revenues • YTD Expenses Amended Revenues • Amended Expenses Adopted Revenues Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $12,494,949 $12,442,977 $12,921,200 $11,733,354 $11,733,354 $2,743 $68,637 YTD Expenses By Departments YTD Expense- Water YTD Expense- WW 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 88,979,203 40,000,000 41,702,881 20,000,000 Water Consumption Budget vs Actual 01,683,000 134,083,000 108,707,084 79,654,000 26,270,812 103,622,571 104,510,967 52,466,000 70,083,700 80,784,200 49,007,000 49,082,000 46,119,000 61,944,185 0 34,501,000 41,572,326 36,351,669 33,732,116 Budget Consumption 54,266,627 34,390,563 -1-Actual Consumption Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep 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 1,049,951,517 808,128,121 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 $600,000 $664,453 $500,000 -$703,717 $400,000 $300,000 $200,000 $100,000 $0 $395,319 Water Revenue Budget vs Actual $440,564 $438,585 $424,445 5404,421 $355,608 $536,842 $952,641 $940,104 $779,457 $787,492 - $597,742 $792,444 $636,314 $520,969 $395,329 $365,714 335,705 $351,905 $466,063 -0-Budget Revenue -e-Actual Revenue Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 00 Adopted Budget Water Revenue Vs Projected Water Revenue $6 710 979 $7,869,119 $4,070,848 Total Water Revenue $5,131,075 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses -1,794.00 -0.92 % 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-49900-000 135-000-49903-000 Department: 000 - R 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 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 Miscellaneous Income Recovery of Prior Year Expense evenue, Asset, Liability, & Equity Total: Original Current Total Budget Total Budget 87,956.00 300.00 300.00 145,029.00 6,710,979.00 3,839,686.00 78,000.00 5,600.00 300.00 100.00 60,000.00 20,000.00 14,146.00 25,000.00 572,900.00 164,000.00 2,058.00 7,000.00 0.00 87,956.00 300.00 300.00 145,029.00 7,142,255.00 3,670,000.00 78,000.00 5,600.00 300.00 100.00 100,000.00 380,000.00 37,179.00 50,000.00 572,900.00 164,000.00 2,058.00 7,000.00 0.00 Budget Report Account Summary For Fiscal: 2022-2023 Period Ending: 09/30/2023 Period Activity 91.15 2.25 20.06 0.00 1,089,018.22 321,068.87 13,185.34 725.00 0.00 0.00 22,889.60 34,673.78 4,000.00 5,092.85 0.00 164,000.00 0.00 0.00 0.00 Fiscal Activity 86,594.75 1,299.15 1,119.11 0.00 7,869,119.65 3,686,857.02 77,200.59 4,100.00 0.00 0.00 108,286.32 397,122.38 45,178.81 50,979.07 0.00 164,000.00 0.00 3,016.40 75.58 Variance Favorable Percent (Unfavorable) Remaining -1,361.25 999.15 819.11 -145,029.00 726,864.65 16,857.02 -799.41 -1,500.00 -300.00 -100.00 8,286.32 17,122.38 7,999.81 979.07 -572,900.00 0.00 -2,058.00 -3,983.60 75.58 1.55 % 433.05 % 373.04 % 100.00 % 110.18 % 100.46 % 1.02 % 26.79 % 100.00 % 100.00 % 108.29 % 104.51 % 121.52 % 101.96 % 100.00 % 0.00 % 100.00 % 56.91 % 0.00 % 11,733,354.00 12, 442, 977.00 1, 654, 767.12 12, 494, 948.83 51,971.83 0.42% Revenue Total: 11,733,354.00 12,442,977.00 1,654,767.12 12,494,948.83 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 407,139.00 17,000.00 5,983.00 3,600.00 51,200.00 82,722.00 4,876.00 745.00 2,400.00 26,891.00 6,289.00 1,260.00 11, 249.00 400.00 300.00 229,800.00 2,000.00 5,000.00 1,000.00 2,500.00 7,500.00 2,000.00 7,500.00 407,139.00 17,000.00 5,983.00 3,600.00 51,200.00 87,627.00 4,876.00 745.00 2,400.00 26,891.00 6,289.00 1,260.00 11, 249.00 400.00 300.00 204,800.00 2,000.00 12,066.00 1,000.00 2,500.00 7,500.00 2,000.00 7,500.00 47,167.28 3,917.29 0.00 225.00 6,157.18 8,444.01 350.33 71.31 290.69 3,116.00 728.72 0.00 1,109.39 0.00 172.83 48,261.70 0.00 47.51 374.58 161.23 0.00 213.92 314.78 395,814.12 17,225.92 5,982.50 2,700.00 50,705.46 87,625.20 3,959.92 744.21 3,566.91 25,607.73 5,788.81 53.98 13,312.79 420.45 640.33 228,976.38 875.96 12,918.62 2,890.64 2,095.98 5,212.44 2,240.50 5,465.86 51,971.83 0.42% 11,324.88 -225.92 0.50 900.00 494.54 1.80 916.08 0.79 -1,166.91 1,283.27 500.19 1,206.02 -2,063.79 -20.45 -340.33 -24,176.38 1,124.04 -852.62 -1,890.64 404.02 2,287.56 -240.50 2,034.14 2.78 % -1.33 % 0.01 % 25.00 % 0.97 % 0.00 % 18.79 % 0.11 % -48.62 % 4.77 % 7.95 % 95.72 % -18.35 % -5.11 % -113.44 % -11.80 % 56.20 % -7.07 % -189.06 % 16.16 % 30.50 % -12.03 % 27.12 % 135-010-60020-000 Electricity 228,250.00 194,810.00 30,445.89 196,604.00 135-010-60066-000 135-010-60080-000 Publications/Books/Subscripts Schools & Training 1,000.00 3,630.00 1,000.00 3,630.00 0.00 0.00 0.00 3,123.72 1,000.00 100.00 % 506.28 13.95 % 10/19/2023 2:18:46 PM Budget Report For Fiscal: 2022-2023 Period Ending: 09/30/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-010-60100-000 Travel & per diem 938.00 938.00 0.00 44.79 893.21 95.22 % 135-010-60135-000 TCEQ Fees & Permits 30,000.00 30,000.00 0.00 27,945.73 2,054.27 6.85 % 135-010-60135-001 TCEQ Fees & Permits for PID 0.00 214.00 0.00 213.92 0.08 0.04 % 135-010-60150-000 Wholesale Water 2,640,132.00 2,640,132.00 642,491.90 2,738,043.51 -97,911.51 -3.71 % 135-010-60285-000 Lawn Equipment & Maintenance 12,500.00 12,500.00 600.00 5,400.00 7,100.00 56.80 % 135-010-60332-000 Interfund Transfer Out -Rev l&S 567,782.00 567,782.00 0.00 567,783.30 -1.30 0.00 % 135-010-60360-000 Furniture/Equipment < $5000 2,500.00 2,500.00 0.00 1,355.00 1,145.00 45.80 % 135-010-65005-000 Fuel & Lube 15,000.00 15,000.00 1,873.46 18,334.34 -3,334.34 -22.23 % 135-010-65010-000 Uniforms 4,355.00 4,355.00 0.00 3,097.65 1,257.35 28.87 % 135-010-65030-000 Chemicals 25,000.00 45,500.00 1,557.08 47,746.91 -2,246.91 -4.94 % 135-010-65050-000 Meter Expense 20,000.00 6,420.00 0.00 0.00 6,420.00 100.00 % 135-010-65053-000 Meter Change Out Program 87,000.00 87,000.00 0.00 87,000.00 0.00 0.00 % 135-010-69005-000 Capital Outlays 1,752,000.00 2,300,000.00 298,384.51 2,024,401.36 275,598.64 11.98 % 135-010-69008-000 Short Term Debt -Principal 31,882.00 31,882.00 0.00 31,882.11 -0.11 0.00 % 135-010-69009-000 Short Term Debt -Interest 470.00 470.00 0.00 470.26 -0.26 -0.06 % 135-010-69195-000 GASB Reserve for Replacement 162,639.00 162,639.00 102,000.00 162,639.00 0.00 0.00 % 135-010-69281-000 Water Tank Inspection Contract 113,500.00 113,500.00 0.00 110,863.59 2,636.41 2.32 % Department: 010 - Water Total: 6,577,932.00 7,086,597.00 1,198,476.59 6,901,773.90 184,823.10 2.61% Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 309,655.00 290,179.00 25,837.82 288,163.91 2,015.09 0.69 % 135-020-50010-000 Overtime 33,000.00 15,586.00 1,561.01 15,914.52 -328.52 -2.11 % 135-020-50016-000 Longevity 4,035.00 4,035.00 0.00 4,035.00 0.00 0.00 % 135-020-50017-000 Certification 6,300.00 6,300.00 225.00 4,350.00 1,950.00 30.95 % 135-020-50020-000 Retirement 41,671.00 41,671.00 3,314.86 37,504.42 4,166.58 10.00 % 135-020-50026-000 Medical Insurance 96,579.00 63,861.00 4,503.48 63,848.40 12.60 0.02 % 135-020-50027-000 Dental Insurance 5,427.00 5,427.00 166.51 2,643.12 2,783.88 51.30 % 135-020-50028-000 Vision Insurance 793.00 793.00 42.52 563.50 229.50 28.94 % 135-020-50029-000 Life Insurance & Other 2,400.00 2,400.00 188.36 2,546.51 -146.51 -6.10 % 135-020-50030-000 Social Security Taxes 21,885.00 21,885.00 1,664.79 18,897.54 2,987.46 13.65 % 135-020-50035-000 Medicare Taxes 5,118.00 5,118.00 389.32 4,419.55 698.45 13.65 % 135-020-50040-000 Unemployment Taxes 1,260.00 1,260.00 0.00 43.66 1,216.34 96.53 % 135-020-50045-000 Workman's Compensation 8,987.00 8,987.00 886.30 10,635.38 -1,648.38 -18.34 % 135-020-50060-000 Pre-emp Physicals/Testing 400.00 400.00 0.00 150.00 250.00 62.50 % 135-020-50070-000 Employee Relations 300.00 300.00 60.00 1,227.97 -927.97 -309.32 % 135-020-55080-000 Maintenance & Repairs 134,600.00 211,000.00 14,699.03 216,237.71 -5,237.71 -2.48 % 135-020-55081-000 Mainten & Repairs Collections 281,000.00 333,600.00 1,260.00 255,372.55 78,227.45 23.45 % 135-020-55085-000 Generator Maint. and Repair 9,000.00 2,836.00 0.00 2,836.29 -0.29 -0.01 % 135-020-55090-000 Vehicle Maintenance 4,600.00 4,600.00 0.00 639.87 3,960.13 86.09 % 135-020-55091-000 Veh Maintenance Collections 13,000.00 13,000.00 2,000.75 6,822.66 6,177.34 47.52 % 135-020-55105-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 0.00 2,435.44 564.56 18.82 % 135-020-55120-000 Cleaning Services 2,000.00 2,000.00 161.22 2,095.87 -95.87 -4.79 % 135-020-55125-000 Dumpster Services 100,000.00 95,000.00 0.00 85,077.11 9,922.89 10.45 % 135-020-55135-000 Lab Analysis 40,000.00 45,000.00 4,353.60 46,940.97 -1,940.97 -4.31 % 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 238.60 4,016.36 3,483.64 46.45 % 135-020-60020-000 Electricity 276,318.00 243,973.00 26,126.79 249,282.02 -5,309.02 -2.18 % 135-020-60080-000 Schools & Training 3,630.00 3,630.00 0.00 2,560.75 1,069.25 29.46 % 135-020-60100-000 Travel & per diem 1,038.00 1,038.00 3.62 3.62 1,034.38 99.65 % 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 8,500.00 650.00 6,390.00 2,110.00 24.82 % 135-020-60331-000 Interfund Transfer Out -Tax I&S 116,245.00 116,245.00 0.00 116,245.00 0.00 0.00 % 135-020-60332-000 Interfund Transfer Out -Rev I&S 691,931.00 691,931.00 0.00 691,931.70 -0.70 0.00 % 135-020-60360-000 Furniture/Equipment < $5000 500.00 500.00 0.00 346.60 153.40 30.68 % 135-020-65005-000 Fuel & Lube 12,500.00 12,500.00 2,022.97 12,134.64 365.36 2.92 % 135-020-65010-000 Uniforms 4,415.00 4,415.00 0.00 2,931.96 1,483.04 33.59 % 135-020-65030-000 Chemicals 32,500.00 22,500.00 0.00 22,109.42 390.58 1.74 % 135-020-65031-000 Chemicals Collections 10,000.00 10,000.00 0.00 6,002.80 3,997.20 39.97 % 135-020-65045-000 Lab Supplies 33,000.00 33,000.00 79.75 27,834.58 5,165.42 15.65 % 135-020-65095-000 Maintenance Supplies 0.00 0.00 -2.70 0.00 0.00 0.00 % 10/19/2023 2:18:46 PM Budget Report For Fiscal: 2022-2023 Period Ending: 09/30/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-020-69005-000 Capital Outlays 895,000.00 1,578,000.00 87,360.50 1,318,138.73 259,861.27 16.47 % 135-020-69008-000 Short Term Debt -Principal 85,766.00 85,766.00 0.00 85,762.59 3.41 0.00 % 135-020-69009-000 Short Term Debt -Interest 2,801.00 2,801.00 0.00 2,834.91 -33.91 -1.21 % 135-020-69195-000 GASB Reserve for Replacement 165,777.00 165,777.00 62,000.00 165,777.00 0.00 0.00 % Department: 020 - Wastewater Total: 3,491,931.00 4,178,314.00 239,794.10 3,797,592.65 380,721.35 9.11% Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 15.00 15.00 0.62 7.44 7.56 50.40 % 135-026-60070-000 Dues & Memberships 750.00 750.00 0.00 750.00 0.00 0.00 % 135-026-60075-000 Meetings 1,500.00 1,500.00 0.00 1,450.78 49.22 3.28 % 135-026-60080-000 Schools & Training 4,000.00 535.00 0.00 535.00 0.00 0.00 % 135-026-60100-000 Travel & per diem 5,000.00 0.00 0.00 0.00 0.00 0.00 % 135-026-60245-000 Miscellaneous Expenses 500.00 0.00 0.00 0.00 0.00 0.00 % Department: 026 - Board of Directors Total: 11,765.00 2,800.00 0.62 2,743.22 56.78 2.03% Department: 030 - Administration 135-030-50005-000 Salaries & Wages 620,938.00 620,938.00 71,297.45 604,750.95 16,187.05 2.61 % 135-030-50010-000 Overtime 2,000.00 2,000.00 41.11 1,094.38 905.62 45.28 % 135-030-50016-000 Longevity 2,423.00 2,423.00 0.00 2,422.50 0.50 0.02 % 135-030-50020-000 Retirement 73,824.00 73,824.00 8,532.56 72,807.82 1,016.18 1.38 % 135-030-50026-000 Medical Insurance 116,290.00 79,352.00 6,755.22 77,663.50 1,688.50 2.13 % 135-030-50027-000 Dental Insurance 6,051.00 6,051.00 241.48 3,063.98 2,987.02 49.36 % 135-030-50028-000 Vision Insurance 899.00 899.00 55.37 628.90 270.10 30.04 % 135-030-50029-000 Life Insurance & Other 2,400.00 2,400.00 512.52 4,889.67 -2,489.67 -103.74 % 135-030-50030-000 Social Security Taxes 38,772.00 38,772.00 4,299.54 36,006.90 2,765.10 7.13 % 135-030-50035-000 Medicare Taxes 9,068.00 9,068.00 1,005.53 8,486.82 581.18 6.41 % 135-030-50040-000 Unemployment Taxes 1,512.00 1,512.00 0.00 58.55 1,453.45 96.13 % 135-030-50045-000 Workman's Compensation 1,496.00 1,496.00 107.55 1,291.15 204.85 13.69 % 135-030-50060-000 Pre-emp Physicals/Testing 500.00 500.00 0.00 198.45 301.55 60.31 % 135-030-50070-000 Employee Relations 4,000.00 4,000.00 100.00 2,841.90 1,158.10 28.95 % 135-030-55030-000 Software & Support 131,700.00 131,700.00 5,210.41 93,659.10 38,040.90 28.88 % 135-030-55070-000 Independent Labor 15,000.00 8,000.00 0.00 6,473.19 1,526.81 19.09 % 135-030-55080-000 Maintenance & Repairs 40,000.00 20,000.00 245.00 22,777.91 -2,777.91 -13.89 % 135-030-55085-000 Generator Maint. and Repair 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % 135-030-55120-000 Cleaning Services 12,000.00 12,000.00 997.35 13,353.79 -1,353.79 -11.28 % 135-030-55160-000 Professional Outside Services 75,040.00 75,040.00 0.00 74,769.87 270.13 0.36 % 135-030-55205-000 Utility Billing Contract 9,000.00 9,000.00 647.07 7,700.94 1,299.06 14.43 % 135-030-60005-000 Telephone 6,000.00 6,000.00 482.50 5,713.96 286.04 4.77 % 135-030-60010-000 Communications/Mobiles 3,000.00 3,000.00 69.13 190.46 2,809.54 93.65 % 135-030-60020-000 Electricity/Gas 24,369.00 16,957.00 1,799.68 17,128.22 -171.22 -1.01 % 135-030-60025-000 Water 5,000.00 5,000.00 453.16 4,971.36 28.64 0.57 % 135-030-60035-000 Postage 30,000.00 24,000.00 2,219.95 24,226.87 -226.87 -0.95 % 135-030-60040-000 Service Charges & Fees 95,000.00 141,000.00 28,038.99 165,491.44 -24,491.44 -17.37 % 135-030-60050-000 Bad Debt Expense 1,500.00 13,000.00 0.00 48.65 12,951.35 99.63 % 135-030-60055-000 Insurance 88,200.00 97,400.00 8,117.82 97,413.73 -13.73 -0.01 % 135-030-60070-000 Dues & Memberships 6,500.00 6,500.00 0.00 6,964.55 -464.55 -7.15 % 135-030-60079-000 Public Education 40,000.00 30,000.00 931.30 27,795.13 2,204.87 7.35 % 135-030-60080-000 Schools & Training 3,250.00 3,250.00 0.00 626.14 2,623.86 80.73 % 135-030-60100-000 Travel & per diem 1,588.00 1,588.00 0.00 0.00 1,588.00 100.00 % 135-030-60125-000 Advertising 0.00 0.00 1,265.00 1,265.00 -1,265.00 0.00 % 135-030-60245-000 Miscellaneous Expenses 0.00 0.00 0.00 88.00 -88.00 0.00 % 135-030-60285-000 Lawn Equipment & Maintenance 5,000.00 5,000.00 469.67 3,468.40 1,531.60 30.63 % 135-030-60360-000 Furniture/Equipment < $5000 10,000.00 13,053.00 0.00 13,052.82 0.18 0.00 % 135-030-65010-000 Uniforms 530.00 530.00 0.00 306.50 223.50 42.17 % 135-030-65055-000 Hardware 8,400.00 13,214.00 678.23 14,265.36 -1,051.36 -7.96 % 135-030-65085-000 Office Supplies 6,000.00 6,000.00 93.69 4,303.33 1,696.67 28.28 % 135-030-65095-000 Maintenance Supplies 4,000.00 4,000.00 282.33 5,833.42 -1,833.42 -45.84 % 135-030-69005-000 Capital Outlays 0.00 56,346.00 0.00 74,952.60 -18,606.60 -33.02 % 135-030-69170-000 Copier Lease Installments 4,000.00 4,000.00 256.07 3,210.31 789.69 19.74 % 10/19/2023 2:18:46 PM Budget Report For Fiscal: 2022-2023 Period Ending: 09/30/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-030-69195-000 GASB Reserve for Replacement 26,736.00 26,736.00 0.00 26,736.00 0.00 0.00 % Department: 030 - Administration Total: 1,534,986.00 1,578,549.00 145,205.68 1,532,992.52 45,556.48 2.89% Department: 039 - Non Departmental 135-039-55045-000 Legal 65,000.00 30,000.00 2,288.90 30,163.15 -163.15 -0.54 % 135-039-55055-000 Auditing 33,800.00 27,000.00 0.00 23,163.95 3,836.05 14.21 % 135-039-55060-000 Appraisal 12,940.00 12,940.00 2,163.63 11,263.78 1,676.22 12.95 % 135-039-55065-000 Tax Admin Fees 5,000.00 5,000.00 1 0.00 1 4,046.00 954.00 19.08 % Department: 039 - Non Departmental Total: 116,740.00 74,940.00 4,452.53 68,636.88 6,303.12 8.41% Expense Total: 11,733,354.00 12,921,200.00 1,587,929.52 12,303,739.17 617,460.83 4.78% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 -478,223.00 66,837.60 191,209.66 669,432.66 139.98% Report Surplus (Deficit): 0.00 -478,223.00 66,837.60 191,209.66 669,432.66 139.98% 10/19/2023 2:18:46 PM Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity 122 - Trophy Club MUD Fire Dept. 135 - MUD 1 General Fund 745,948.81 11,584, 865.82 Balance Sheet Funds 122 - 528 Account Summary As Of 09/30/2023 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 Consolidated Bond Const -SWIFT Bond 16" Revenue Bond Total GASB Waterline Reserve Fund 3,258,146.58 817,016.88 1,179,058.79 942,342.55 18,527,379.43 Total Asset: 745,948.81 11,584,865.82 3,258,146.58 817,016.88 1,179,058.79 942,342.55 18,527,379.43 Liability 000 - Revenue, Asset, Liability, & Equity -13,333.12 947,570.09 0.00 81,691.15 0.00 0.00 1,015,928.12 Total Liability: -13,333.12 947,570.09 0.00 81,691.15 0.00 0.00 1,015,928.12 Equity 000 - Revenue, Asset, Liability, & Equity 675,927.57 10,446,086.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 17,052,819.76 Total Total Beginning Equity: 675,927.57 10,446,086.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 17,052,819.76 Total Revenue 1,529,468.23 12,494,948.83 436,572.00 29,795.53 56,150.07 41,738.14 14,588,672.80 Total Expense 1,446,113.87 12,303,739.17 164,000.00 0.00 216,188.21 0.00 14,130,041.25 Revenues Over/Under Expenses 83,354.36 191,209.66 272,572.00 29,795.53 -160,038.14 41,738.14 458,631.55 Total Equity and Current Surplus (Deficit): 759,281.93 10,637,295.73 3,258,146.58 735,325.73 1,179,058.79 942,342.55 17,511,451.31 Total Liabilities, Equity and Current Surplus (Deficit): 745,948.81 11,584,865.82 3,258,146.58 817,016.88 1,179,058.79 942,342.55 18,527,379.43 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 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 10/19/2023 3:43:19 PM Page 1 of 1 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 66,588.02 Liability 000 - Revenue, Asset, Liability, & Equity Equity 000 - Revenue, Asset, Liability, & Equity 535 - 2016 Rev Bond I&S-SWIFT 39,137.14 11,713.62 536 - 2019 Rev Bond I&S- W&WW System Balance Sheet I&S Funds 533 - 536 Account Summary As Of 09/30/2023 Total 6,476.05 123,914.83 Total Asset: 66,588.02 39,137.14 11,713.62 6,476.05 123,914.83 -19,248.18 0.00 0.00 0.00 -19,248.18 Total Liability: -19,248.18 0.00 0.00 0.00 -19,248.18 51,962.11 27,958.35 6,554.77 1,429.17 87,904.40 Total Total Beginning Equity: 51,962.11 27,958.35 6,554.77 1,429.17 87,904.40 Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 1,042,556.67 615,816.29 280,697.35 384,584.38 2,323,654.69 1,008,682.58 604,637.50 275,538.50 379,537.50 2,268,396.08 33,874.09 11,178.79 5,158.85 5,046.88 55,258.61 85,836.20 39,137.14 11,713.62 6,476.05 143,163.01 66,588.02 39,137.14 11,713.62 6,476.05 123,914.83 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 I&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 I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest 10/19/2023 3:46:58 PM Page 1 of 1 CASH STATUS AS OF SEPTEMBER 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 $3,647,646 $3,647,646 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $145,180 $4,134,026 $4,279,206 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,936,872 $0 $1,936,872 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,258,147 $0 $3,258,147 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 51 9-1 11 55 Cash -Bond Escrow Bank of Texas (SWIFT) $817,017 $0 $817,017 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,179,059 $0 $1,179,059 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $942,343 $0 $942,343 533-10250 TexPool Tax I & S (XXXXX0003) $85,835 $0 $85,835 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $39,137 $0 $39,137 535-10250 Texpool Revenue 1 & S (XXXXX017) SWIFT $11,714 $0 $11,714 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $6,476 $0 $6,476 $7,782,273 $16,204,052 Amount available in cash for spending (MUD Accounts) *9/30/2023 Customer Water Deposits $145,180 Fire Department Cash $7,782,273 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $746,977 $746,977 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $12,305 $12,305 $0 $759,282 $759,282 Amount available in cash for spending (Fire Department Accounts) $759,282 General Fund 135 Available $ 4,134,026 Prosperity General Fund $ 3,647,646 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 7,782,273 General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) $ 3,880 Assigned Fund Balance (FY2023 Capital Projects plus prior year carry forward) $ 4,770,878 Unassigned Fund Balance $ 5,671,328 Current Year Revenue/Expenses $ 191,210 Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,637,296 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections MUD Connections PID September Utility Billing Report Fiscal Year 2022 - 2023 September 2022 October 2022 November 2022 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 August 2023 September 2023 1,654 1,667 1,710 1,746 1,765 1,777 1,773 1,767 1,794 1,766 1,750 1,744 1,742 3,832 3,822 3,801 3,768 3,741 3,751 3,744 3,743 3,734 3,755 3,749 3,747 3,747 703 706 711 630 606 599 599 590 588 589 585 578 572 1,481 1,501 1,494 2,251 2,540 2,719 3,016 2,998 2,754 3,134 3,101 2,957 3,086 1,203 1,159 1,049 326 337 0 0 0 547 413 289 290 327 327 268 344 2 0 4 0 0 0 0 8 9 9 13 7 7 3,399 3,399 3,399 3,399 3,394 3,394 3,394 3,394 3,394 3,395 3,395 3,395 3,395 1,444 1,444 1,444 1,444 1,444 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,443 September Permits Fiscal Year 2023 Date of Permit Permit No. Customer Deposit Due to FW Water Oversize Meter Plumbing Inspections Sewer Inspections Fire Line Misc. Income Total $ Total $ - $ - $ - $ - $ - $ - $ - $