Loading...
HomeMy WebLinkAbout2023-04 April Finance ReportsCheck Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 04/01/2023 - 04/30/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular 3127 Allied Welding Supply Inc. 04/25/2023 Regular 0.00 -17.83 9417 2222 Aflac 04/03/2023 Regular 0.00 494.92 9468 3127 Allied Welding Supply Inc. 04/03/2023 Regular 0.00 19.21 9469 3197 BenefitMall 04/03/2023 Regular 0.00 52.00 9470 1737 DPC Industries Inc. 04/03/2023 Regular 0.00 1,557.08 9471 2800 Ferguson Enterprises LLC 04/03/2023 Regular 0.00 1,596.12 9472 4033 Health Care Service Corporation 04/03/2023 Regular 0.00 2Q718.46 9473 3216 M3 Networks 04/03/2023 Regular 0.00 606.00 9474 3186 Member's Building Maintenance 04/03/2023 Regular 0.00 1,289.80 9475 3115 Metlife Group Benefits 04/03/2023 Regular 0.00 2,251.18 9476 3156 Southern Petroleum Lab Inc 04/03/2023 Regular 0.00 757.20 9477 1000 Trophy Club Mud (Water Bills) 04/03/2023 Regular 0.00 398.75 9478 2222 Aflac 04/19/2023 Regular 0.00 405.80 9490 2772 Allied Waste Industries 04/19/2023 Regular 0.00 7,810.40 9491 2920 CareNow Corporate 04/19/2023 Regular 0.00 98.00 9492 2683 Charter Communications 04/19/2023 Regular 0.00 899.00 9493 1030 City of Fort Worth 04/19/2023 Regular 0.00 335.60 9494 3184 Dataprose LLC 04/19/2023 Regular 0.00 2,558.23 9495 2807 Denton Record -Chronicle 04/19/2023 Regular 0.00 99.60 9496 2497 DHS Automation Inc 04/19/2023 Regular 0.00 3,182.26 9497 3118 Exclusive Pest Control 04/19/2023 Regular 0.00 120.00 9498 2800 Ferguson Enterprises LLC 04/19/2023 Regular 0.00 3,927.65 9499 2558 First Check Applicant Screenin 04/19/2023 Regular 0.00 162.45 9500 2606 Fisery Solutions LLC 04/19/2023 Regular 0.00 50.00 9501 3093 Four Man Furnace Inc. 04/19/2023 Regular 0.00 1,727.50 9502 2635 Halff Associates Inc. 04/19/2023 Regular 0.00 2,050.00 9503 3076 HD Supply Facilities Maint LTD 04/19/2023 Regular 0.00 1,061.38 9504 2641 Huber Technology Inc 04/19/2023 Regular 0.00 528.61 9505 2808 J&J Ramirez Tree Trimmers LLC 04/19/2023 Regular 0.00 1,400.00 9506 2673 Jack Henry & Assoc, Inc 04/19/2023 Regular 0.00 1,100.00 9507 3278 Kyocera Document Solutions 04/19/2023 Regular 0.00 85.47 9508 4019 Peterson Pump & Motor Service LLC 04/19/2023 Regular 0.00 1,120.00 9509 2801 Pipeline Analysis LLC 04/19/2023 Regular 0.00 17,817.60 9510 3296 Quy Nguyen 04/19/2023 Regular 0.00 1,200.00 9511 3176 Rey -Mar Construction 04/19/2023 Regular 0.00 204,820.48 9512 1066 Roanoke Winnelson Co. 04/19/2023 Regular 0.00 2,268.10 9513 2805 Scott Tucker Construction LLC 04/19/2023 Regular 0.00 63,683.82 9514 2805 Scott Tucker Construction LLC 04/19/2023 Regular 0.00 9Q202.50 9515 3156 Southern Petroleum Lab Inc 04/19/2023 Regular 0.00 442.80 9516 3182 Strategic Government Resources 04/19/2023 Regular 0.00 742.50 9517 2440 Tarrant County Public Health Laboratory 04/19/2023 Regular 0.00 340.00 9518 2696 Texas Excavation Safety System 04/19/2023 Regular 0.00 198.55 9519 3133 Texas Rural Water Assoc 04/19/2023 Regular 0.00 3,851.55 9520 1001 Town of Trophy Club 04/19/2023 Regular 0.00 218,018.46 9521 1081 Tri County Electric 04/19/2023 Regular 0.00 612.04 9522 2798 Tyler Technologies Inc 04/19/2023 Regular 0.00 3,305.15 9523 1058 Verizon Wireless 04/19/2023 Regular 0.00 857.42 9524 3280 Watts Ellison LLC 04/19/2023 Regular 0.00 2,079.67 9525 2222 Aflac 04/28/2023 Regular 0.00 494.92 9526 3127 Allied Welding Supply Inc. 04/28/2023 Regular 0.00 17.83 9527 4018 BP Energy Holding Company LLC 04/28/2023 Regular 0.00 35,938.43 9528 1010 Car Concepts Commercial LLC 04/28/2023 Regular 0.00 1,026.50 9529 2497 DHS Automation Inc 04/28/2023 Regular 0.00 1,219.92 9530 Check Report Vendor Number 1737 3258 3292 1372 2635 2641 1249 1834 2943 3132 3195 3216 2760 3176 3156 1973 1000 2798 3225 Vendor Name DPC Industries Inc. Francotyp-Postalia, Inc. Grapevine Dodge Chrysler Jeep Hach Company Halff Associates Inc. Huber Technology Inc Huther And Associates Inc Idexx Distribution, Inc JP Morgan Chase Bank NA Legal Shield Lou's Gloves Incorporated M3 Networks NDS Leasing Rey -Mar Construction Southern Petroleum Lab Inc Texas Commission on Environmental Quality Trophy Club Mud (Water Bills) Tyler Technologies Inc US Bank Voyager Fleet Systems Payment Date 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 04/28/2023 Payment Type Discount Amount Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Regular 0.00 Total Regular: 0.00 888,120.17 Date Range: 04/01/2023 - 04/30/2023 Payment Amount Number 2,140.99 9531 142.41 9532 62,410.00 9533 237.22 9534 529.44 9535 3,000.00 9536 1,290.00 9537 649.87 9538 9,406.50 9539 34.90 9540 236.20 9541 135.74 9542 175.00 9543 89,813.00 9544 2,271.60 9545 4,788.71 9546 438.33 9547 487.50 9548 2,349.68 9549 Check Report Date Range: 04/01/2023 - 04/30/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payment Type: Bank Draft 3197 BenefitMall 04/14/2023 Bank Draft 0.00 266.67 DFT0000061 3124 IRS Tax Payment 04/14/2023 Bank Draft 0.00 13,225.03 DFT0000062 3113 TCDRS 04/14/2023 Bank Draft 0.00 9,559.37 DFT0000063 3294 Texas Workforce Commission 04/20/2023 Bank Draft 0.00 143.61 DFT0000066 3197 BenefitMall 04/28/2023 Bank Draft 0.00 266.67 DFT0000067 3124 IRS Tax Payment 04/28/2023 Bank Draft 0.00 12,825.51 DFT0000068 3113 TCDRS 04/28/2023 Bank Draft 0.00 9,480.03 DFT0000069 Total Bank Draft: 0.00 45,766.89 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 98 71 0.00 888,138.00 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -17.83 Bank Drafts 7 7 0.00 45,766.89 EFT's 0 0 0.00 0.00 105 79 0.00 933,887.06 Check Report Date Range: 04/01/2023 - 04/30/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 98 71 0.00 888,138.00 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -17.83 Bank Drafts 7 7 0.00 45,766.89 EFT's 0 0 0.00 0.00 105 79 0.00 933,887.06 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 4/2023 933,887.06 933,887.06 FY 2023 Combined Financials YTD as of 4/30/2023 YTD Revenues • YTD Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $5,742,963 $6,372,458 $11,733,354 MIW $11,733,354 $1,675 $43,704 0% $952,741 15% $2,365,507 37% 1% $3,008,832 47% 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 88,979,203 60,000,000 40,000,000 20,000,000 0 Oct Water Consumption Budget vs Actual 01,683,000 49,007,000 52,466,000 49,082,000 41,702,881 41,572,326 Budget Consumption 70,083,700 46,119,000 34,501,000 54,266,627 36,351,669 34,390,563 33,732,116 —A—Actual Consumption Nov Dec Jan Feb Mar Apr 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 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 $500,000 $400,000 $300,000 $200,000 $100,000 30 $664,453 5703,717 Water Revenue Budget vs Actual $438,585 $440,564 5424,445 5536,842 5404,421 5355,608 5466,063 $395,319 5395,329 $365,714 5335,705 $351,905 Budget Revenue —A—Actual Revenue Oct Nov Dec Jan Feb Mar Apr $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 30 Adopted Budget Water Revenue Vs Projected Water Revenue $6,710,979 $6,922,338 $4,070,848 Total Water Revenue $4,349,931 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund CURRENT MONTH YEAR TO DATE ACTUAL BUDGETED VARIANCE ACTUAL BUDGETED VARIANCE Budget Variance Report As Of: 04/30/2023 ANNUAL BUDGET TOTAL REMAINING % REVENUE SUMMARY Revenue, Asset, Liability, & Equity 896,608.58 977,388.37 (80,779.79) 5,742,963.03 6,841,718.59 (1,098,755.56) 49 11,733,354.00 (5,990,390.97) 51 TOTAL REVENUE 896,608.58 977,388.37 (80,779.79) 5,742,963.03 6,841,718.59 (1,098,755.56) 49 11,733,354.00 (5,990,390.97) 51 EXPENSE SUMMARY Revenue, Asset, Liability, & Equity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water 183,052.19 547,941.66 364,889.47 3,008,831.68 3,835,591.62 826,759.94 46 6,577,932.00 (3,569,100.32) 54 Wastewater 429,259.33 290,877.74 (138,381.59) 2,365,506.95 2,036,144.18 (329,362.77) 68 3,491,931.00 (1,126,424.05) 32 Board of Directors 181.51 980.01 798.50 1,675.17 6,860.07 5,184.90 14 11,765.00 (10,089.83) 86 Administration 109,088.37 127,864.23 18,775.86 952,740.69 895,049.61 (57,691.08) 62 1,534,986.00 (582,245.31) 38 Non Deparmental 0.00 9,724.44 9,724.44 43,703.62 68,071.08 24,367.46 37 116,740.00 (73,036.38) 63 TOTAL EXPENSE 721,581.40 977,388.08 255,806.68 6,372,458.11 6,841,716.56 469,258.45 54 11,733,354.00 5,360,895.89 46 REVENUE OVER/(UNDER) EXPENDITURE 175,027.18 0.29 175,026.89 (629,495.08) 2.03 (629,497.11) 0.00 (11,351,286.86) 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 Total Departme 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 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 nt: 000 - Revenue, Asset, Liability, & Equity: Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Total Revenue: April Budget 7,326.73 24.99 24.99 12,080.91 559,024.55 319,845.84 6,497.40 466.48 24.99 8.33 4,998.00 1,666.00 1,178.36 2,082.50 47,722.57 13,661.20 171.43 583.10 April Activity 301.90 6.22 44.06 0.00 536,841.77 301,548.89 7,932.48 475.00 0.00 0.00 9,260.80 35,702.76 4,000.00 494.70 0.00 0.00 0.00 0.00 Variance Favorable Percent (Unfavorable) Remaining -7,024.83 -18.77 19.07 -12,080.91 -22,182.78 -18,296.95 1,435.08 8.52 -24.99 -8.33 4,262.80 34,036.76 2,821.64 -1,587.80 -47,722.57 -13,661.20 -171.43 -583.10 -95.88% -75.11% 76.31% -100.00% -3.97% -5.72% 22.09% 1.83% -100.00% -100.00% 85.29% 2,043.02% 239.45% -76.24% -100.00% -100.00% -100.00% -100.00% YTD Budget 51,287.11 174.93 174.93 84,566.37 3,913,171.85 2,238,920.88 45,481.80 3,265.36 174.93 58.31 34,986.00 11,662.00 8,248.52 14,577.50 334,057.99 95,628.40 1,200.01 4,081.70 Monthly Budget Report Account Summary For Fiscal: Current Period Ending: 04/30/2023 YTD Activity 84,370.39 896.94 624.94 0.00 3,245,015.47 2,115,875.99 29,648.50 1,175.00 0.00 0.00 21,136.00 215,138.59 25,178.81 886.00 0.00 0.00 0.00 3,016.40 Variance Favorable Percent (Unfavorable) Remaining 33,083.28 722.01 450.01 -84,566.37 -668,156.38 -123,044.89 -15,833.30 -2,090.36 -174.93 -58.31 -13,850.00 203,476.59 16,930.29 -13,691.50 -334,057.99 -95,628.40 -1,200.01 -1,065.30 64.51% 412.74% 257.25% -100.00% -17.07% -5.50% -34.81% -64.02% -100.00% -100.00% -39.59% 1,744.78% 205.25% -93.92% -100.00% -100.00% -100.00% -26.10% 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 977,388.37 896,608.58 -80,779.79 -8.26% 6,841,718.59 5,742,963.03 -1,098,755.56 -16.06% 11,733,354.00 977,388.37 896,608.58 -80,779.79 -8.26% 6,841,718.59 5,742,963.03 -1,098,755.56 -16.06% 11,733,354.00 33,914.67 27,755.09 1,416.10 304.73 498.38 0.00 299.88 0.00 4,264.96 3,367.19 6,890.74 6,207.51 406.17 272.02 62.05 54.58 199.92 383.91 2,240.02 1,717.68 6,159.58 18.16% 237,402.69 231,329.93 1,111.37 78.48% 9,912.70 7,982.79 498.38 100.00% 3,488.66 0.00 299.88 100.00% 2,099.16 0.00 897.77 21.05% 29,854.72 28,771.18 683.23 9.92% 48,235.18 45,359.89 134.15 33.03% 2,843.19 2,206.82 7.47 12.04% 434.35 387.36 -183.99 -92.03% 1,399.44 2,720.92 522.34 23.32% 15,680.14 14,584.94 6,072.76 1,929.91 3,488.66 2,099.16 1,083.54 2,875.29 636.37 46.99 -1,321.48 1,095.20 2.56% 19.47% 100.00% 100.00% 3.63% 5.96% 22.38% 10.82% -94.43% 6.98% 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 Monthly Budget Report For Fiscal: Current Period Ending: 04/30/2023 Variance Variance April April Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-010-50035-000 Medicare Taxes 523.87 401.71 122.16 23.32% 3,667.09 3,210.97 456.12 12.44% 6,289.00 135-010-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 734.65 44.98 689.67 93.88% 1,260.00 135-010-50045-000 Workman's Compensation 937.04 1,109.40 -172.36 -18.39% 6,559.28 7,765.80 -1,206.52 -18.39% 11,249.00 135-010-50060-000 Pre-emp Physicals/Testing 33.32 108.00 -74.68 -224.13% 233.24 420.45 -187.21 -80.26% 400.00 135-010-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 174.93 132.95 41.98 24.00% 300.00 135-010-55080-000 Maintenance & Repairs 19,142.34 1,407.89 17,734.45 92.65% 133,996.38 58,916.17 75,080.21 56.03% 229,800.00 135-010-55085-000 Generator Maint. and Repair 166.60 0.00 166.60 100.00% 1,166.20 875.96 290.24 24.89% 2,000.00 135-010-55090-000 Vehicle Maintenance 416.50 4,527.51 -4,111.01 -987.04% 2,915.50 7,748.85 -4,833.35 -165.78% 5,000.00 135-010-55105-000 Maintenance-Backhoe/SkidLoader 83.30 0.00 83.30 100.00% 583.10 0.00 583.10 100.00% 1,000.00 135-010-55120-000 Cleaning Services 208.25 161.23 47.02 22.58% 1,457.75 1,289.83 167.92 11.52% 2,500.00 135-010-55135-000 Lab Analysis 624.75 0.00 624.75 100.00% 4,373.25 2,217.84 2,155.41 49.29% 7,500.00 135-010-55135-001 Lab Analysis for PID 166.60 0.00 166.60 100.00% 1,166.20 693.92 472.28 40.50% 2,000.00 135-010-60010-000 Communications/Mobiles 624.75 335.79 288.96 46.25% 4,373.25 3,598.61 774.64 17.71% 7,500.00 135-010-60020-000 Electricity 19,013.22 12,460.97 6,552.25 34.46% 133,092.54 84,944.33 48,148.21 36.18% 228,250.00 135-010-60066-000 Publications/Books/Subscripts 83.30 0.00 83.30 100.00% 583.10 0.00 583.10 100.00% 1,000.00 135-010-60080-000 Schools & Training 302.37 25.00 277.37 91.73% 2,116.59 1,400.52 716.07 33.83% 3,630.00 135-010-60100-000 Travel & per diem 78.13 0.00 78.13 100.00% 546.91 44.79 502.12 91.81% 938.00 135-010-60135-000 TCEQ Fees & Permits 2,499.00 0.00 2,499.00 100.00% 17,493.00 20,280.63 -2,787.63 -15.94% 30,000.00 135-010-60135-001 TCEQ Fees & Permits for PID 0.00 0.00 0.00 0.00% 0.00 213.92 -213.92 0.00% 0.00 135-010-60150-000 Wholesale Water 219,922.99 0.00 219,922.99 100.00% 1,539,460.93 798,163.91 741,297.02 48.15% 2,640,132.00 135-010-60285-000 Lawn Equipment & Maintenance 1,041.25 0.00 1,041.25 100.00% 7,288.75 1,200.00 6,088.75 83.54% 12,500.00 135-010-60332-000 Interfund Transfer Out -Rev l&S 47,296.24 51,616.66 -4,320.42 -9.13% 331,073.68 361,316.62 -30,242.94 -9.13% 567,782.00 135-010-60360-000 Furniture/Equipment < $5000 208.25 0.00 208.25 100.00% 1,457.75 0.00 1,457.75 100.00% 2,500.00 135-010-65005-000 Fuel & Lube 1,249.50 1,322.55 -73.05 -5.85% 8,746.50 9,736.27 -989.77 -11.32% 15,000.00 135-010-65010-000 Uniforms 362.77 412.18 -49.41 -13.62% 2,539.39 2,617.74 -78.35 -3.09% 4,355.00 135-010-65030-000 Chemicals 2,082.50 2,140.99 -58.49 -2.81% 14,577.50 26,322.86 -11,745.36 -80.57% 25,000.00 135-010-65050-000 Meter Expense 1,666.00 0.00 1,666.00 100.00% 11,662.00 0.00 11,662.00 100.00% 20,000.00 135-010-65053-000 Meter Change Out Program 7,247.10 0.00 7,247.10 100.00% 50,729.70 0.00 50,729.70 100.00% 87,000.00 135-010-69005-000 Capital Outlays 145,941.60 66,959.60 78,982.00 54.12% 1,021,591.20 976,474.97 45,116.23 4.42% 1,752,000.00 135-010-69008-000 Short Term Debt -Principal 2,655.77 0.00 2,655.77 100.00% 18,590.39 31,882.11 -13,291.72 -71.50% 31,882.00 135-010-69009-000 Short Term Debt -Interest 39.15 0.00 39.15 100.00% 274.05 470.26 -196.21 -71.60% 470.00 135-010-69195-000 GASB Reserve for Replacement 13,547.82 0.00 13,547.82 100.00% 94,834.74 162,639.00 -67,804.26 -71.50% 162,639.00 135-010-69281-000 Water Tank Inspection Contract 9,454.55 0.00 9,454.55 100.00% 66,181.85 110,863.59 -44,681.74 -67.51% 113,500.00 Total Department: 010 - Water: 547,941.66 183,052.19 364,889.47 66.59% 3,835,591.62 3,008,831.68 826,759.94 21.55% 6,577,932.00 Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 25,794.26 23,134.79 2,659.47 10.31% 180,559.82 191,609.08 -11,049.26 -6.12% 309,655.00 135-020-50010-000 Overtime 2,748.90 1,578.52 1,170.38 42.58% 19,242.30 10,362.47 8,879.83 46.15% 33,000.00 135-020-50016-000 Longevity 336.11 0.00 336.11 100.00% 2,352.77 0.00 2,352.77 100.00% 4,035.00 135-020-50017-000 Certification 524.79 0.00 524.79 100.00% 3,673.53 0.00 3,673.53 100.00% 6,300.00 135-020-50020-000 Retirement 3,471.19 2,965.61 505.58 14.57% 24,298.33 24,290.39 7.94 0.03% 41,671.00 135-020-50026-000 Medical lnsurance 8,045.03 5,614.18 2,430.85 30.22% 56,315.21 40,250.19 16,065.02 28.53% 96,579.00 135-020-50027-000 Dental lnsurance 452.06 201.18 250.88 55.50% 3,164.42 1,776.82 1,387.60 43.85% 5,427.00 Monthly Budget Report For Fiscal: Current Period Ending: 04/30/2023 Variance Variance April April Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-020-50028-000 Vision Insurance 66.05 51.26 14.79 22.39% 462.35 342.40 119.95 25.94% 793.00 135-020-50029-000 Life Insurance & Other 199.92 257.12 -57.20 -28.61% 1,399.44 2,241.85 -842.41 -60.20% 2,400.00 135-020-50030-000 Social Security Taxes 1,823.02 1,494.51 328.51 18.02% 12,761.14 12,306.85 454.29 3.56% 21,885.00 135-020-50035-000 Medicare Taxes 426.32 349.52 76.80 18.01% 2,984.24 2,878.19 106.05 3.55% 5,118.00 135-020-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 734.65 43.66 690.99 94.06% 1,260.00 135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 5,240.27 6,203.96 -963.69 -18.39% 8,987.00 135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 233.24 150.00 83.24 35.69% 400.00 135-020-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 174.93 663.09 -488.16 -279.06% 300.00 135-020-55080-000 Maintenance & Repairs 11,212.18 17,287.85 -6,075.67 -54.19% 78,485.26 118,924.64 -40,439.38 -51.52% 134,600.00 135-020-55081-000 Mainten & Repairs Collections 23,407.30 28,019.85 -4,612.55 -19.71% 163,851.10 135,605.30 28,245.80 17.24% 281,000.00 135-020-55085-000 Generator Maint. and Repair 749.70 0.00 749.70 100.00% 5,247.90 2,836.29 2,411.61 45.95% 9,000.00 135-020-55090-000 Vehicle Maintenance 383.18 5.45 377.73 98.58% 2,682.26 497.26 2,185.00 81.46% 4,600.00 135-020-55091-000 Veh Maintenance Collections 1,082.90 75.95 1,006.95 92.99% 7,580.30 4,741.97 2,838.33 37.44% 13,000.00 135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 1,026.50 -776.60 -310.76% 1,749.30 2,435.44 -686.14 -39.22% 3,000.00 135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 1,166.20 1,289.77 -123.57 -10.60% 2,000.00 135-020-55125-000 Dumpster Services 8,330.00 7,810.40 519.60 6.24% 58,310.00 48,514.63 9,795.37 16.80% 100,000.00 135-020-55135-000 Lab Analysis 3,332.00 3,876.00 -544.00 -16.33% 23,324.00 26,254.17 -2,930.17 -12.56% 40,000.00 135-020-60010-000 Communications/Mobiles 624.75 60.09 564.66 90.38% 4,373.25 3,000.94 1,372.31 31.38% 7,500.00 135-020-60020-000 Electricity 23,017.28 22,663.81 353.47 1.54% 161,120.96 134,133.29 26,987.67 16.75% 276,318.00 135-020-60080-000 Schools & Training 302.37 236.00 66.37 21.95% 2,116.59 1,977.00 139.59 6.60% 3,630.00 135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 605.22 0.00 605.22 100.00% 1,038.00 135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 6,997.20 9,888.02 -2,890.82 -41.31% 12,000.00 135-020-60285-000 Lawn Equipment & Maintenance 1,332.80 0.00 1,332.80 100.00% 9,329.60 1,720.00 7,609.60 81.56% 16,000.00 135-020-60331-000 Interfund Transfer Out -Tax l&S 9,683.20 10,567.73 -884.53 -9.13% 67,782.40 73,974.11 -6,191.71 -9.13% 116,245.00 135-020-60332-000 Interfund Transfer Out -Rev l&S 57,637.85 62,902.88 -5,265.03 -9.13% 403,464.95 440,320.16 -36,855.21 -9.13% 691,931.00 135-020-60360-000 Furniture/Equipment < $5000 41.65 0.00 41.65 100.00% 291.55 0.00 291.55 100.00% 500.00 135-020-65005-000 Fuel & Lube 1,041.25 1,027.13 14.12 1.36% 7,288.75 6,752.28 536.47 7.36% 12,500.00 135-020-65010-000 Uniforms 367.76 231.68 136.08 37.00% 2,574.32 2,520.03 54.29 2.11% 4,415.00 135-020-65030-000 Chemicals 2,707.25 0.00 2,707.25 100.00% 18,950.75 12,677.47 6,273.28 33.10% 32,500.00 135-020-65031-000 Chemicals Collections 833.00 0.00 833.00 100.00% 5,831.00 6,002.80 -171.80 -2.95% 10,000.00 135-020-65045-000 Lab Supplies 2,748.90 1,279.80 1,469.10 53.44% 19,242.30 19,958.29 -715.99 -3.72% 33,000.00 135-020-65095-000 Maintenance Supplies 0.00 2.70 -2.70 0.00% 0.00 2.70 -2.70 0.00% 0.00 135-020-69005-000 Capital Outlays 74,553.50 235,491.32 -160,937.82 -215.87% 521,874.50 786,827.64 -264,953.14 -50.77% 895,000.00 135-020-69008-000 Short Term Debt -Principal 7,144.30 0.00 7,144.30 100.00% 50,010.10 63,804.49 -13,794.39 -27.58% 85,766.00 135-020-69009-000 Short Term Debt -Interest 233.32 0.00 233.32 100.00% 1,633.24 1,952.31 j9.07 -19.54% 2,801.00 135-020-69195-000 GASB Reserve for Replacement 13,809.22 0.00 13,809.22 100.00% 96,664.54 165,777.00 -69,112.46 -71.50% 165,777.00 Total Department: 020 - Wastewater: 290,877.74 429,259.33 -138,381.59 -47.57% 2,036,144.18 2,365,506.95 -329,362.77 -16.18% 3,491,931.00 Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation I= 1.24 0.62 50.00% 1 8.1111 4.1IMM 4.34 50.00% 135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 437.29 750.00 -312.71 -71.51% 750.00 135-026-60075-000 Meetings Ilr124.95 -55.94 -44.77% 874.65 870.83 3.82 0.44% 135-026-60080-000 Schools & Training 333.20 0.00 333.20 100.00% 2,332.40 50.00 2,282.40 97.86% 4,000.00 Monthly Budget Report For Fiscal: Current Period Ending: 04/30/2023 135-026-60100-000 135-026-60245-000 Travel & per diem Miscellaneous Expenses Total Department: 026 - Board of Directors: Variance Variance April April Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 0.00 416.50 100.00% 2,915.50 J 0.00 2,915.50 100.001 5,000.04 41.65 0.00 41.65 100.00% 291.55 0.00 291.55 100.00% 500.00 980.01 181.51 798.50 81.48% 6,860.07 1,675.17 5,184.90 75.58% 11,765.00 Department: 030 - Administration 135-030-50005-000 Salaries & Wages 51,724.13 4,106.15 7.94% 362,068.91 345,234.62 16,834.29 Mr 620,938.00 135-030-50010-000 Overtime 166.60 41.11 125.49 75.32% 1,166.20 615.53 550.67 47.22% 2,000.00 135-030-50016-000 Longevity 201.83 0.00 201.83 100.00% 1,412.81 0.00 1,412.81 100.00% 2,423.00 135-030-50020-000 Retirement 6,149.53 5,692.11 457.42 7.44% 43,046.71 41,477.43 1,569.28 3.65% 73,824.00 135-030-50026-000 Medical Insurance 9,686.95 8,444.08 1,242.87 12.83% 67,808.65 42,198.91 25,609.74 37.77% 116,290.00 135-030-50027-000 Dental Insurance 504.04 294.19 209.85 41.63% 3,528.28 1,839.39 1,688.89 47.87% 6,051.00 135-030-50028-000 Vision Insurance 74.88 68.64 6.24 8.33% 524.16 347.54 176.62 33.70% 899.00 135-030-50029-000 Life Insurance & Other 199.92 492.38 -292.46 -146.29% 1,399.44 3,382.15 -1,982.71 -141.68% 2,400.00 135-030-50030-000 Social Security Taxes 3,229.70 2,841.84 387.86 12.01% 22,607.90 20,357.03 2,250.87 9.96% 38,772.00 135-030-50035-000 Medicare Taxes 755.36 664.62 90.74 12.01% 5,287.52 4,826.74 460.78 8.71% 9,068.00 135-030-50040-000 Unemployment Taxes 125.94 0.01 125.93 99.99% 881.58 58.55 823.03 93.36% 1,512.00 135-030-50045-000 Workman's Compensation 124.61 107.60 17.01 13.65% 872.27 753.20 119.07 13.65% 1,496.00 135-030-50060-000 Pre-emp Physicals/Testing 41.65 0.00 41.65 100.00% 291.55 198.45 93.10 31.93% 500.00 135-030-50070-000 Employee Relations 333.20 0.00 333.20 100.00% 2,332.40 2,563.57 -231.17 -9.91% 4,000.00 135-030-55030-000 Software & Support 10,970.61 6,906.21 4,064.40 37.05% 76,794.27 73,994.86 2,799.41 3.65% 131,700.00 135-030-55070-000 Independent Labor 1,249.50 315.00 934.50 74.79% 8,746.50 5,550.69 3,195.81 36.54% 15,000.00 135-030-55080-000 Maintenance & Repairs 3,332.00 1,443.77 1,888.23 56.67% 23,324.00 11,684.96 11,639.04 49.90% 40,000.00 135-030-55085-000 Generator Maint. and Repair 249.90 0.00 249.90 100.00% 1,749.30 0.00 1,749.30 100.00% 3,000.00 135-030-55120-000 Cleaning Services 999.60 967.35 32.25 3.23% 6,997.20 8,037.04 -1,039.84 -14.86% 12,000.00 135-030-55160-000 Professional Outside Services 6,250.83 458.02 5,792.81 92.67% 43,755.81 70,134.53 -26,378.72 -60.29% 75,040.00 135-030-55205-000 Utility Billing Contract 749.70 630.63 119.07 15.88% 5,247.90 4,533.56 714.34 13.61% 9,000.00 135-030-60005-000 Telephone 499.80 435.94 63.86 12.78% 3,498.60 3,276.74 221.86 6.34% 6,000.00 135-030-60010-000 Communications/Mobiles 249.90 0.00 249.90 100.00% 1,749.30 0.00 1,749.30 100.00% 3,000.00 135-030-60020-000 Electricity/Gas 2,029.93 1,343.09 686.84 33.84% 14,209.51 10,363.87 3,845.64 27.06% 24,369.00 135-030-60025-000 Water 416.50 438.33 -21.83 -5.24% 2,915.50 2,779.71 135.79 4.66% 5,000.00 135-030-60035-000 Postage 2,499.00 2,045.77 453.23 18.14% 17,493.00 13,782.08 3,710.92 21.21% 30,000.00 135-030-60040-000 Service Charges & Fees 7,913.50 11,837.89 -3,924.39 -49.59% 55,394.50 72,608.98 -17,214.48 -31.08% 95,000.00 135-030-60050-000 Bad Debt Expense 124.95 0.00 124.95 100.00% 874.65 48.65 826.00 94.44% 1,500.00 135-030-60055-000 Insurance 7,347.06 8,117.81 -770.75 -10.49% 51,429.42 56,824.67 -5,395.25 -10.49% 88,200.00 135-030-60070-000 Dues & Memberships 541.45 4,271.55 -3,730.10 -688.91% 3,790.15 6,560.55 -2,770.40 -73.09% 6,500.00 135-030-60079-000 Public Education 3,332.00 2,143.75 1,188.25 35.66% 23,324.00 20,241.23 3,082.77 13.22% 40,000.00 135-030-60080-000 Schools & Training 270.72 50.00 220.72 81.53% 1,895.04 170.00 1,725.04 91.03% 3,250.00 135-030-60100-000 Travel & per diem 132.28 0.00 132.28 100.00% 925.96 0.00 925.96 100.00% 1,588.00 135-030-60245-000 Miscellaneous Expenses 0.00 0.00 0.00 0.00% 0.00 88.00 -88.00 0.00% 0.00 135-030-60285-000 Lawn Equipment & Maintenance 416.50 0.00 416.50 100.00% 2,915.50 1,589.72 1,325.78 45.47% 5,000.00 135-030-60360-000 Furniture/Equipment < $5000 833.00 0.00 833.00 100.00% 5,831.00 13,052.82 -7,221.82 -123.85% 10,000.00 135-030-65010-000 Uniforms 44.14 0.00 44.14 100.00% 308.98 0.00 308.98 100.00% 530.00 135-030-65055-000 Hardware 699.72 135.74 563.98 80.60% 4,898.04 3,582.84 1,315.20 26.85% 8,400.00 Monthly Budget Report For Fiscal: Current Period Ending: 04/30/2023 135-030-65085-000 Office Supplies 135-030-65095-000 Maintenance Supplies 135-030-69005-000 Capital Outlays 135-030-69170-000 Copier Lease Installments 135-030-69195-000 GASB Reserve for Replacement Total Department: 030 - Administration: Department: 039 - Non Deparmental 135-039-55045-000 Legal 135-039-55055-000 Auditing 135-039-55060-000 Appraisal 135-039-55065-000 Tax Admin Fees Total Department: 039 - Non Deparmental: Total Expense: Total Revenues Total Fund: 135 - MUD 1 General Fund: Report Total: April Budget 499.80 333.20 0.00 333.20 2,227.10 127,864.23 5,414.50 2,815.54 1,077.90 416.50 9,724.44 April Activity 115.01 419.98 487.50 260.47 0.00 109,088.37 0.00 0.00 0.00 0.00 Variance Favorable Percent (Unfavorable) Remaining 384.79 76.99% -86.78 -26.04% -487.50 0.00% 72.73 21.83% 2,227.10 100.00% 18,775.86 14.68% 0.00 5,414.50 2,815.54 1,077.90 416.50 9,724.44 100.00% 100.00% 100.00% 100.00% 100.00% YTD Budget 3,498.60 2,332.40 0.00 2,332.40 15,589.70 895,049.61 37,901.50 19, 708.78 7,545.30 2,915.50 68,071.08 YTD Activity 2,872.69 3,553.94 74,952.60 1,866.85 26,736.00 952,740.69 10,170.00 22,551.10 6,936.52 4,046.00 Variance Favorable (Unfavorable) 625.91 -1,221.54 -74,952.60 465.55 -11,146.30 -57,691.08 27,731.50 -2,842.32 608.78 -1,130.50 43,703.62 24,367.46 Percent Remaining Total Budget 17.89% 6,000.00 -52.37% 4,000.00 0.00% 0.00 19.96% 4,000.00 -71.50% 26,736.00 -6.45% 1,534,986.00 73.17% 65,000.00 -14.42% 33,800.00 8.07% 12,940.00 -38.78% 5,000.00 35.80% 116,740.00 977,388.08 721,581.40 255,806.68 26.17% 6,841,716.56 6,372,458.11 469,258.45 6.86% 11,733,354.00 977,388.37 896,608.58 -80,779.79 -8.26% 6,841,718.59 5,742,963.03 -1,098,755.56 -16.06% 11,733,354.00 0.29 175,027.18 175,026.89 2.03 -629,495.08 -629,497.11 0.00 0.29 175,027.18 175,026.89 2.03 -629,495.08 -629,497.11 0.00 Monthly Budget Report For Fiscal: Current Period Ending: 04/30/2023 Group Summary Departmen... Fund: 135 - MUD 1 General Fund Revenue 000 - Revenue, Asset, Liability, & Equity Expense 010 - Water 020 - Wastewater 026 - Board of Directors 030 - Administration 039 - Non Deparmental Total Revenue: Total Expense: Total Revenues Total Fund: 135 - MUD 1 General Fund: Report Total: Variance Variance April April Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 977,388.37 896,608.58 -80,779.79 -8.26% 6,841,718.59 5,742,963.03 -1,098,755.56 -16.06% 11,733,354.00 977,388.37 896,608.58 -80,779.79 -8.26% 6,841,718.59 5,742,963.03 -1,098,755.56 -16.06% 11,733,354.00 547,941.66 183,052.19 364,889.47 66.59% 3,835,591.62 3,008,831.68 826,759.94 21.55% 6,577,932.00 290,877.74 429,259.33 -138,381.59 -47.57% 2,036,144.18 2,365,506.95 -329,362.77 -16.18% 3,491,931.00 980.01 181.51 798.50 81.48% 6,860.07 1,675.17 5,184.90 75.58% 11,765.00 127,864.23 109,088.37 18,775.86 14.68% 895,049.61 952,740.69 -57,691.08 -6.45% 1,534,986.00 9,724.44 0.00 9,724.44 100.00% 68,071.08 43,703.62 24,367.46 35.80% 116,740.00 977,388.08 721,581.40 255,806.68 26.17% 6,841,716.56 6,372,458.11 469,258.45 6.86% 11,733,354.00 977,388.37 896,608.58 -80,779.79 -8.26% 6,841,718.59 5,742,963.03 -1,098,755.56 -16.06% 11,733,354.00 0.29 175,027.18 175,026.89 2.03 -629,495.08 -629,497.11 0.00 0.29 175,027.18 175,026.89 2.03 -629,495.08 -629,497.11 0.00 Monthly Budget Report For Fiscal: Current Period Ending: 04/30/2023 Fund Summary Variance Variance April April Favorable Percent YTD YTD Favorable Percent Fund Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135 - MUD 1 General Fund 0.29 175,027.18 175,026.89 2.03 -629,495.08 -629,497.11 0.00 Report Total: 0.29 175,027.18 175,026.89 2.03 -629,495.08 -629,497.11 0.00 Department Trophy Club Municipal Utility District No. 1 122 - Trophy Club MUD Fire Dept. Asset 000 - Revenue, Asset, Liability, & Equity 1,266,646.11 Liability 000 - Revenue, Asset, Liability, & Equity Equity 000 - Revenue, Asset, Liability, & Equity 135 - MUD 1 General Fund Balance Sheet Funds 122 - 528 Account Summary As Of 04/30/2023 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 Consolidated Bond Const -SWIFT Bond 16" Revenue Bond GASB Waterline Reserve Fund 10,521,399.62 3,422,146.58 801,905.50 1,153, 877.73 Total 922, 217.09 18,088,192.63 Total Asset: 1,266,646.11 10,521,399.62 3,422,146.58 801,905.50 1,153,877.73 922,217.09 18,088,192.63 17,689.88 703,356.63 0.00 81,691.15 0.00 0.00 802,737.66 Total Liability: 17,689.88 703,356.63 0.00 81,691.15 0.00 0.00 802,737.66 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 17,060,147.76 Total Total Beginning Equity: 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 17,060,147.76 Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 1,416,602.62 5,742,963.03 436,572.00 14,684.15 30,969.01 21,612.68 7,663,403.49 849,449.96 6,372,458.11 0.00 0.00 216,188.21 0.00 7,438,096.28 567,152.66 1,248,956.23 1,266,646.11 -629,495.08 9,818,042.99 10,521,399.62 436,572.00 3,422,146.58 3,422,146.58 14,684.15 720,214.35 801,905.50 -185,219.20 1,153,877.73 1,153,877.73 21,612.68 922,217.09 922,217.09 225,307.21 17,285,454.97 18,088,192.63 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 MS Revenue Bond payments for Fund 534, 535, & 535 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 939,834.44 Liability 000 - Revenue, Asset, Liability, & Equity Equity 000 - Revenue, Asset, Liability, & Equity 535 - 2016 Rev Bond I&S-SWIFT 324,756.73 156, 074.83 536 - 2019 Rev Bond I&S- W&WW System Balance Sheet I&S Funds 533 - 536 Account Summary As Of 04/30/2023 Total 137,622.19 1,558,288.19 Total Asset: 939,834.44 324,756.73 156,074.83 137,622.19 1,558,288.19 49,324.56 0.00 0.00 0.00 49,324.56 Total Liability: 49,324.56 0.00 0.00 0.00 49,324.56 4,145.11 27,958.35 6,554.77 1,429.17 40,087.40 Total Total Beginning Equity: 4,145.11 27,958.35 6,554.77 1,429.17 40,087.40 Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 960,943.60 389,117.13 177,289.31 243,461.77 1,770,811.81 74,578.83 92,318.75 27,769.25 107,268.75 301,935.58 886,364.77 890,509.88 939,834.44 296,798.38 324,756.73 324,756.73 149,520.06 156,074.83 156,074.83 136,193.02 137,622.19 137,622.19 1,468,876.23 1,508,963.63 1,558,288.19 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 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 I&S Revenue Bond payment from Fund 533 • 3/1 & 9/1 Revenue Bond payments (Interest and Principal) • Monthly bank interest CASH STATUS AS OF APRIL 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,812,932 $2,812,932 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $141,525 $4,549,977 $4,691,502 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,908,136 $0 $1,908,136 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,422,147 $0 $3,422,147 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 51 9-1 11 55 Cash -Bond Escrow Bank of Texas (SWIFT) $801,906 $0 $801,906 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,153,878 $0 $1,153,878 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $922,217 $0 $922,217 533-10250 TexPool Tax I & S (XXXXX0003) $938,326 $0 $938,326 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $324,757 $0 $324,757 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $156,075 $0 $156,075 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $137,622 $0 $137,622 $7,363,509 $17,270,097 Amount available in cash for spending (MUD Accounts) *4/30/2023 Customer Water Deposits $141,525 Fire Department Cash $7,363,509 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $1,042,625 $1,042,625 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $191,028 $191,028 $0 $1,233,654 $1,233,654 Amount available in cash for spending (Fire Department Accounts) $1,233,654 General Fund 135 Available $ 4,549,977 Prosperity General Fund $ 2,812,932 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 7,363,509 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,672,780 Current Year Revenue/Expenses $ (629,495) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $9,818,043 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections MUD Connections PID April Utility Billing Report Fiscal Year 2022 - 2023 April 2022 May 2022 June 2022 July 2022 August 2022 September 2022 October 2022 November 2022 December 2022 January 2023 February 2023 March 2023 April 2023 1,465 1,518 1,566 1,592 1,629 1,654 1,667 1,710 1,746 1,765 1,777 1,773 1,767 3,868 3,865 3,882 3,872 3,850 3,832 3,822 3,801 3,768 3,741 3,751 3,744 3,743 676 692 700 697 704 703 706 711 630 606 599 599 590 1,455 1,450 1,456 1,471 1,484 1,481 1,501 1,494 2,251 2,540 2,719 3,016 2,998 1,171 1,196 1,188 1,220 1,170 1,203 1,159 1,049 355 284 339 387 310 326 337 0 0 0 547 413 289 9 9 4 7 5 2 0 4 0 0 0 0 8 3400 3400 3401 3401 3398 3399 3399 3399 3399 3394 3394 3394 3394 1443 1443 1443 1443 1443 1444 1444 1444 1444 1444 1443 1443 1443 April 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 $ - $ - $ - $ - $ - $ - $ - $