Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2023-07 July Finance Reports
Check Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 07/01/2023 - 07/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular 1500 American Water Works Assoc 07/19/2023 Regular 0.00 -900.00 9631 3197 BenefitMall 07/01/2023 Regular 0.00 52.00 9700 4033 Health Care Service Corporation 07/01/2023 Regular 0.00 22,147.36 9701 3216 M3 Networks 07/01/2023 Regular 0.00 1,091.00 9702 3115 Metlife Group Benefits 07/01/2023 Regular 0.00 2,301.06 9703 2631 Ace Pipe Cleaning, Inc. 07/19/2023 Regular 0.00 5,127.90 9704 2772 Allied Waste Industries 07/19/2023 Regular 0.00 18,405.72 9705 3127 Allied Welding Supply Inc. 07/19/2023 Regular 0.00 18.75 9706 1005 Atlas Utility Supply Co. 07/19/2023 Regular 0.00 66,500.00 9707 3299 Bickerstaff Heath Delgado Acosta LLP 07/19/2023 Regular 0.00 912.00 9708 2683 Charter Communications 07/19/2023 Regular 0.00 753.99 9709 1030 City of Fort Worth 07/19/2023 Regular 0.00 4,396.00 9710 2618 City of Fort Worth 07/19/2023 Regular 0.00 600.00 9711 3184 Dataprose LLC 07/19/2023 Regular 0.00 2,507.56 9712 2807 Denton Record -Chronicle 07/19/2023 Regular 0.00 69.70 9713 2497 DHS Automation Inc 07/19/2023 Regular 0.00 15,902.56 9714 1832 First Financial Bank 07/19/2023 Regular 0.00 22,840.70 9715 2606 Fisery Solutions LLC 07/19/2023 Regular 0.00 50.00 9716 3093 Four Man Furnace Inc. 07/19/2023 Regular 0.00 2,030.00 9717 2796 Garver 07/19/2023 Regular 0.00 19,657.90 9718 2635 Halff Associates Inc. 07/19/2023 Regular 0.00 332.76 9719 2783 JJ HVAC LLC 07/19/2023 Regular 0.00 3,510.00 9720 2785 Kleen Pipe, Inc 07/19/2023 Regular 0.00 15,473.00 9721 3278 Kyocera Document Solutions 07/19/2023 Regular 0.00 99.84 9722 3216 M3 Networks 07/19/2023 Regular 0.00 1,091.00 9723 4032 MAbelson LLC 07/19/2023 Regular 0.00 10,852.20 9724 3186 Member's Building Maintenance 07/19/2023 Regular 0.00 1,289.80 9725 1051 Millican Well Service, Llc 07/19/2023 Regular 0.00 31,999.05 9726 2983 NTTA 07/19/2023 Regular 0.00 16.21 9727 4019 Peterson Pump & Motor Service LLC 07/19/2023 Regular 0.00 640.00 9728 2752 R & D Electrical, Llc 07/19/2023 Regular 0.00 344.16 9729 3176 Rey -Mar Construction 07/19/2023 Regular 0.00 10,275.00 9730 3156 Southern Petroleum Lab Inc 07/19/2023 Regular 0.00 1,514.40 9731 3182 Strategic Government Resources 07/19/2023 Regular 0.00 135.00 9732 2440 Tarrant County Public Health Laboratory 07/19/2023 Regular 0.00 380.00 9733 2696 Texas Excavation Safety System 07/19/2023 Regular 0.00 148.20 9734 1001 Town of Trophy Club 07/19/2023 Regular 0.00 213,365.27 9735 1081 Tri County Electric 07/19/2023 Regular 0.00 614.05 9736 2798 Tyler Technologies Inc 07/19/2023 Regular 0.00 11,144.80 9737 2634 Valley Solvents & Chemicals 07/19/2023 Regular 0.00 2,669.78 9738 1058 Verizon Wireless 07/19/2023 Regular 0.00 570.87 9739 3280 Watts Ellison LLC 07/19/2023 Regular 0.00 2,969.67 9740 3271 Williams Heritage Investments Inc 07/19/2023 Regular 0.00 1,097.00 9741 3298 308 Construction LLC 07/31/2023 Regular 0.00 21,873.75 9742 2222 Aflac 07/31/2023 Regular 0.00 446.16 9743 2970 Air Mac 07/31/2023 Regular 0.00 3,155.00 9744 4030 Alpha Materials Handling Inc 07/31/2023 Regular 0.00 2,980.00 9745 1005 Atlas Utility Supply Co. 07/31/2023 Regular 0.00 20,500.00 9746 4018 BP Energy Holding Company LLC 07/31/2023 Regular 0.00 47,247.72 9747 1030 City of Fort Worth 07/31/2023 Regular 0.00 281,362.92 9748 2655 Core & Main LP 07/31/2023 Regular 0.00 3,577.08 9749 1737 DPC Industries Inc. 07/31/2023 Regular 0.00 1,946.35 9750 3258 Francotyp-Postalia, Inc. 07/31/2023 Regular 0.00 142.41 9751 8/16/2023 10:04:58 AM Page 1 of 4 Check Report Date Range: 07/01/2023 - 07/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 2796 Garver 07/31/2023 Regular 0.00 22,889.20 9752 1372 Hach Company 07/31/2023 Regular 0.00 2,377.58 9753 2635 Halff Associates Inc. 07/31/2023 Regular 0.00 300.00 9754 1834 Idexx Distribution, Inc 07/31/2023 Regular 0.00 2,488.20 9755 2943 JP Morgan Chase Bank NA 07/31/2023 Regular 0.00 8,600.54 9756 2785 Kleen Pipe, Inc 07/31/2023 Regular 0.00 20,590.50 9757 3132 Legal Shield 07/31/2023 Regular 0.00 15.95 9758 3195 Lou's Gloves Incorporated 07/31/2023 Regular 0.00 236.20 9759 3186 Member's Building Maintenance 07/31/2023 Regular 0.00 1,289.80 9760 2760 NDS Leasing 07/31/2023 Regular 0.00 175.00 9761 3179 NewGen Strategies & Solutions 07/31/2023 Regular 0.00 2,082.50 9762 1056 Office Depot Inc 07/31/2023 Regular 0.00 58.64 9763 3156 Southern Petroleum Lab Inc 07/31/2023 Regular 0.00 2,042.40 9764 3182 Strategic Government Resources 07/31/2023 Regular 0.00 67.50 9765 3283 TK Contractors Inc 07/31/2023 Regular 0.00 14,560.00 9766 3225 US Bank Voyager Fleet Systems 07/31/2023 Regular 0.00 2,224.67 9767 3280 Watts Ellison LLC 07/31/2023 Regular 0.00 2,969.67 9768 Total Regular: 0.00 961,196.00 8/16/2023 10:04:58 AM Page 2 of 4 Check Report Date Range: 07/01/2023 - 07/31/2023 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 Payment Date Payment Type 07/07/2023 07/31/2023 07/07/2023 07/21/2023 07/31/2023 07/21/2023 Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Total Bank Draft: Bank Code Prosperity Bank Summary Payable Payment Count Count 105 69 O 0 O 1 6 6 O 0 111 Discount Amount Payment Amount Number Discount Payment 0.00 962,096.00 0.00 0.00 0.00 -900.00 0.00 44,431.49 0.00 0.00 76 0.00 1,005,627.49 0.00 266.67 DFT0000085 0.00 9,269.45 DFT0000086 0.00 12,696.23 DFT0000087 0.00 266.67 DFT0000088 0.00 9,377.64 DFT0000089 0.00 12,554.83 DFT0000090 0.00 44,431.49 8/16/2023 10:04:58 AM Page 3 of 4 Check Report Date Range: 07/01/2023 - 07/31/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 105 69 0.00 962,096.00 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -900.00 Bank Drafts 6 6 0.00 44,431.49 EFT's 0 0 0.00 0.00 111 76 0.00 1,005,627.49 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 7/2023 1,005,627.49 1,005,627.49 8/16/2023 10:04:58 AM Page 4 of 4 FY 2023 Combined Financials YTD as of 7/31/2023 YTD Revenues • YTD Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $9,223,796 $9,320,643 $11,733,354 MIW $11,733,354 $2,510 $54,191 0% $1,284,739 14% $3,342,338 36% 0% $4,636,865 50% 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 88979,20 40,000,000 41,702,881 20,000,000 Water Consumption Budget vs Actual 101,683,000 52,466,000 49007000 49,082,000 134,083,000 108,707,084 79,654,000 70,083,700 104,510,967 46,119,000 34,501,000 54,266,627 41,572,326 36,351,669 Budget Consumption 33,732,116 34,390,563 -1-Actual Consumption 61,944,185 80,784,200 Oct Nov Dec Jan Feb Mar Apr May Jun Jul 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 955,279,167 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 703,717 Water Revenue Budget vs Actual $600,000 3664,453 8440,564 $438,585 $424,445 5404,42 $ $400,000 355,608 $395,319 $300,000 $395,329 $365,714 $500,000 5536,842 $200,000 $100,000 $0 $351,905 $335,705 8779,457 $597,742 $466,063 Budget Revenue --Actual Revenue $520,969 $952,641 -- $636,314 $636,314 $792,444 Oct Nov Dec Jan Feb Mar Apr May Jun Jul $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 so Adopted Budget Water Revenue Vs Projected Water Revenue $6,710,979 $7,302,452 $4,070,848 Total Water Revenue $4,629,635 • 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: 07/31/2023 ANNUAL BUDGET TOTAL REMAINING % REVENUE SUMMARY Revenue, Asset, Liability, & Equity 1,334,724.99 977,388.37 357,336.62 9,223,795.97 9,773,883.70 (550,087.73) 79 11,733,354.00 (2,509,558.03) 21 TOTAL REVENUE 1,334,724.99 977,388.37 357,336.62 9,223,795.97 9,773,883.70 (550,087.73) 79 11,733,354.00 (2,509,558.03) 21 EXPENSE SUMMARY Revenue, Asset, Liability, & Equity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water 582,944.08 547,941.66 (35,002.42) 4,636,864.66 5,479,416.60 842,551.94 70 6,577,932.00 (1,941,067.34) 30 Wastewater 255,211.18 290,877.74 35,666.56 3,342,338.10 2,908,777.40 (433,560.70) 96 3,491,931.00 (149,592.90) 4 Board of Directors 116.61 980.01 863.40 2,510.00 9,800.10 7,290.10 21 11,765.00 (9,255.00) 79 Administration 111,072.75 127,864.23 16,791.48 1,284,739.12 1,278,642.30 (6,096.82) 84 1,534,986.00 (250,246.88) 16 Non Departmental 0.00 9,724.44 9,724.44 54,191.25 97,244.40 43,053.15 46 116,740.00 (62,548.75) 54 TOTAL EXPENSE 949,344.62 977,388.08 28,043.46 9,320,643.13 9,773,880.80 453,237.67 79 11,733,354.00 2,412,710.87 21 REVENUE OVER/(UNDER) EXPENDITURE 385,380.37 0.29 385,380.08 (96,847.16) 2.90 (96,850.06) 0.00 (4,922,268.90) 8/17/2023 7:04:35 PM Page 1 of 1 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: July 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 July Activity 464.76 90.76 57.07 0.00 952,641.07 311,697.28 9,392.35 700.00 0.00 0.00 18,440.72 36,975.48 4,000.00 265.50 0.00 0.00 0.00 0.00 Variance Favorable Percent (Unfavorable) Remaining YTD Budget -6,861.97 -93.66% 73,267.30 65.77 263.19% 249.90 32.08 128.37% 249.90 -12,080.91 -100.00% 120,809.10 393,616.52 70.41% 5,590,245.50 -8,148.56 -2.55% 3,198,458.40 2,894.95 44.56% 64,974.00 233.52 50.06% 4,664.80 -24.99 -100.00% 249.90 -8.33 -100.00% 83.30 13,442.72 268.96% 49,980.00 35,309.48 2,119.42% 16,660.00 2,821.64 239.45% 11,783.60 -1,817.00 -87.25% 20,825.00 -47,722.57 -100.00% 477,225.70 -13,661.20 -100.00% 136,612.00 -171.43 -100.00% 1,714.30 -583.10 -100.00% 5,831.00 Monthly Budget Report Account Summary For Fiscal: Current Period Ending: 07/31/2023 YTD Activity 86,343.86 1,288.46 1,079.23 0.00 5,574,855.74 3,048,323.91 54,119.76 2,950.00 0.00 0.00 65,842.32 325,661.26 37,178.81 23,136.22 0.00 0.00 0.00 3,016.40 Variance Favorable Percent (Unfavorable) Remaining 13,076.56 1,038.56 829.33 -120,809.10 -15,389.76 -150,134.49 -10,854.24 -1,714.80 -249.90 -83.30 15,862.32 309,001.26 25,395.21 2,311.22 -477,225.70 -136,612.00 -1,714.30 -2,814.60 977,388.37 1,334,724.99 17.85% 415.59% 331.86% -100.00% -0.28% -4.69% -16.71% -36.76% -100.00% -100.00% 31.74% 1,854.75% 215.51% 11.10% -100.00% -100.00% -100.00% -48.27% 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 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 977,388.37 1,334,724.99 33,914.67 31,426.49 1,416.10 1,022.27 498.38 0.00 299.88 200.00 4,264.96 3,917.87 6,890.74 8,444.05 406.17 350.34 62.05 71.29 199.92 290.69 2,240.02 1,978.56 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 2,488.18 7.34% 339,146.70 317,282.51 21,864.19 6.45% 407,139.00 393.83 27.81% 14,161.00 10,097.37 4,063.63 28.70% 17,000.00 498.38 100.00% 4,983.80 5,982.50 -998.70 -20.04% 5,983.00 99.88 33.31% 2,998.80 2,250.00 748.80 24.97% 3,600.00 347.09 8.14% 42,649.60 40,372.19 2,277.41 5.34% 51,200.00 -1,553.31 -22.54% 68,907.40 70,737.17 -1,829.77 -2.66% 82,722.00 55.83 13.75% 4,061.70 3,259.26 802.44 19.76% 4,876.00 -9.24 -14.89% 620.50 601.59 18.91 3.05% 745.00 -90.77 -45.40% 1,999.20 2,985.53 -986.33 -49.34% 2,400.00 261.46 11.67% 22,400.20 20,399.28 2,000.92 8.93% 26,891.00 8/17/2023 7:13:07 PM Page 1 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 Variance Variance July July Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-010-50035-000 Medicare Taxes 523.87 462.73 61.14 11.67% 5,238.70 4,570.73 667.97 12.75% 6,289.00 135-010-50040-000 Unemployment Taxes 104.95 1.83 103.12 98.26% 1,049.50 53.98 995.52 94.86% 1,260.00 135-010-50045-000 Workman's Compensation 937.04 1,109.40 -172.36 -18.39% 9,370.40 11,094.00 -1,723.60 -18.39% 11,249.00 135-010-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 333.20 420.45 -87.25 -26.19% 400.00 135-010-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 249.90 132.95 116.95 46.80% 300.00 135-010-55080-000 Maintenance & Repairs 19,142.34 61,611.86 -42,469.52 -221.86% 191,423.40 133,007.66 58,415.74 30.52% 229,800.00 135-010-55085-000 Generator Maint. and Repair 166.60 0.00 166.60 100.00% 1,666.00 875.96 790.04 47.42% 2,000.00 135-010-55090-000 Vehicle Maintenance 416.50 805.59 -389.09 -93.42% 4,165.00 12,871.11 -8,706.11 -209.03% 5,000.00 135-010-55105-000 Maintenance-Backhoe/SkidLoader 83.30 0.00 83.30 100.00% 833.00 2,516.06 -1,683.06 -202.05% 1,000.00 135-010-55120-000 Cleaning Services 208.25 161.23 47.02 22.58% 2,082.50 1,773.52 308.98 14.84% 2,500.00 135-010-55135-000 Lab Analysis 624.75 553.92 70.83 11.34% 6,247.50 4,422.44 1,825.06 29.21% 7,500.00 135-010-55135-001 Lab Analysis for PID 166.60 680.00 -513.40 -308.16% 1,666.00 1,946.58 -280.58 -16.84% 2,000.00 135-010-60010-000 Communications/Mobiles 624.75 334.77 289.98 46.42% 6,247.50 4,664.44 1,583.06 25.34% 7,500.00 135-010-60020-000 Electricity 19,013.22 23,242.44 -4,229.22 -22.24% 190,132.20 140,651.02 49,481.18 26.02% 228,250.00 135-010-60066-000 Publications/Books/Subscripts 83.30 -900.00 983.30 1,180.43% 833.00 0.00 833.00 100.00% 1,000.00 135-010-60080-000 Schools & Training 302.37 776.21 -473.84 -156.71% 3,023.70 2,912.72 110.98 3.67% 3,630.00 135-010-60100-000 Travel & per diem 78.13 0.00 78.13 100.00% 781.30 44.79 736.51 94.27% 938.00 135-010-60135-000 TCEQ Fees & Permits 2,499.00 0.00 2,499.00 100.00% 24,990.00 23,312.03 1,677.97 6.71% 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 281,362.92 -61,439.93 -27.94% 2,199,229.90 1,691,919.49 507,310.41 23.07% 2,640,132.00 135-010-60285-000 Lawn Equipment & Maintenance 1,041.25 1,200.00 -158.75 -15.25% 10,412.50 4,800.00 5,612.50 53.90% 12,500.00 135-010-60332-000 Interfund Transfer Out -Rev I&S 47,296.24 51,616.66 -4,320.42 -9.13% 472,962.40 516,166.60 -43,204.20 -9.13% 567,782.00 135-010-60360-000 Furniture/Equipment < $5000 208.25 0.00 208.25 100.00% 2,082.50 0.00 2,082.50 100.00% 2,500.00 135-010-65005-000 Fuel & Lube 1,249.50 1,679.33 -429.83 -34.40% 12,495.00 14,403.38 -1,908.38 -15.27% 15,000.00 135-010-65010-000 Uniforms 362.77 0.00 362.77 100.00% 3,627.70 2,897.65 730.05 20.12% 4,355.00 135-010-65030-000 Chemicals 2,082.50 6,075.43 -3,992.93 -191.74% 20,825.00 43,822.52 -22,997.52 -110.43% 25,000.00 135-010-65050-000 Meter Expense 1,666.00 0.00 1,666.00 100.00% 16,660.00 0.00 16,660.00 100.00% 20,000.00 135-010-65053-000 Meter Change Out Program 7,247.10 87,000.00 -79,752.90 -1,100.48% 72,471.00 87,000.00 -14,529.00 -20.05% 87,000.00 135-010-69005-000 Capital Outlays 145,941.60 17,468.20 128,473.40 88.03% 1,459,416.00 1,150,548.30 308,867.70 21.16% 1,752,000.00 135-010-69008-000 Short Term Debt -Principal 2,655.77 0.00 2,655.77 100.00% 26,557.70 31,882.11 -5,324.41 -20.05% 31,882.00 135-010-69009-000 Short Term Debt -Interest 39.15 0.00 39.15 100.00% 391.50 470.26 -78.76 -20.12% 470.00 135-010-69195-000 GASB Reserve for Replacement 13,547.82 0.00 13,547.82 100.00% 135,478.20 162,639.00 -27,160.80 -20.05% 162,639.00 135-010-69281-000 Water Tank Inspection Contract 9,454.55 0.00 9,454.55 100.00% 94,545.50 110,863.59 -16,318.09 -17.26% 113,500.00 Total Department: 010 - Water: 547,941.66 582,944.08 -35,002.42 -6.39% 5,479,416.60 4,636,864.66 842,551.94 15.38% 6,577,932.00 Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 25,794.26 17,192.16 8,602.10 33.35% 257,942.60 245,179.40 12,763.20 4.95% 309,655.00 135-020-50010-000 Overtime 2,748.90 622.44 2,126.46 77.36% 27,489.00 12,585.66 14,903.34 54.22% 33,000.00 135-020-50016-000 Longevity 336.11 0.00 336.11 100.00% 3,361.10 4,035.00 -673.90 -20.05% 4,035.00 135-020-50017-000 Certification 524.79 225.00 299.79 57.13% 5,247.90 3,900.00 1,347.90 25.68% 6,300.00 135-020-50020-000 Retirement 3,471.19 2,164.75 1,306.44 37.64% 34,711.90 31,892.81 2,819.09 8.12% 41,671.00 135-020-50026-000 Medical Insurance 8,045.03 4,503.50 3,541.53 44.02% 80,450.30 54,841.44 25,608.86 31.83% 96,579.00 135-020-50027-000 Dental Insurance 452.06 166.52 285.54 63.16% 4,520.60 2,310.10 2,210.50 48.90% 5,427.00 8/17/2023 7:13:07 PM Page 2 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 Variance Variance July July Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-020-50028-000 Vision Insurance 66.05 42.52 23.53 35.62% 660.50 478.46 182.04 27.56% 793.00 135-020-50029-000 Life Insurance & Other 199.92 188.36 11.56 5.78% 1,999.20 2,213.99 -214.79 -10.74% 2,400.00 135-020-50030-000 Social Security Taxes 1,823.02 1,080.81 742.21 40.71% 18,230.20 16,093.97 2,136.23 11.72% 21,885.00 135-020-50035-000 Medicare Taxes 426.32 252.78 173.54 40.71% 4,263.20 3,763.90 499.30 11.71% 5,118.00 135-020-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 1,049.50 43.66 1,005.84 95.84% 1,260.00 135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 7,486.10 8,862.80 -1,376.70 -18.39% 8,987.00 135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 333.20 150.00 183.20 54.98% 400.00 135-020-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 249.90 1,167.97 -918.07 -367.37% 300.00 135-020-55080-000 Maintenance & Repairs 11,212.18 27,286.85 -16,074.67 -143.37% 112,121.80 186,097.03 -73,975.23 -65.98% 134,600.00 135-020-55081-000 Mainten & Repairs Collections 23,407.30 2,233.55 21,173.75 90.46% 234,073.00 222,416.45 11,656.55 4.98% 281,000.00 135-020-55085-000 Generator Maint. and Repair 749.70 0.00 749.70 100.00% 7,497.00 2,836.29 4,660.71 62.17% 9,000.00 135-020-55090-000 Vehicle Maintenance 383.18 0.00 383.18 100.00% 3,831.80 628.97 3,202.83 83.59% 4,600.00 135-020-55091-000 Veh Maintenance Collections 1,082.90 0.70 1,082.20 99.94% 10,829.00 4,821.91 6,007.09 55.47% 13,000.00 135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 0.00 249.90 100.00% 2,499.00 2,435.44 63.56 2.54% 3,000.00 135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 1,666.00 1,773.43 -107.43 -6.45% 2,000.00 135-020-55125-000 Dumpster Services 8,330.00 0.00 8,330.00 100.00% 83,300.00 74,350.57 8,949.43 10.74% 100,000.00 135-020-55135-000 Lab Analysis 3,332.00 4,399.20 -1,067.20 -32.03% 33,320.00 39,523.77 -6,203.77 -18.62% 40,000.00 135-020-60010-000 Communications/Mobiles 624.75 200.68 424.07 67.88% 6,247.50 3,577.04 2,670.46 42.74% 7,500.00 135-020-60020-000 Electricity 23,017.28 23,129.52 -112.24 -0.49% 230,172.80 199,978.82 30,193.98 13.12% 276,318.00 135-020-60080-000 Schools & Training 302.37 470.00 -167.63 -55.44% 3,023.70 2,560.75 462.95 15.31% 3,630.00 135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 864.60 0.00 864.60 100.00% 1,038.00 135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 9,996.00 9,888.02 107.98 1.08% 12,000.00 135-020-60285-000 Lawn Equipment & Maintenance 1,332.80 1,300.00 32.80 2.46% 13,328.00 5,740.00 7,588.00 56.93% 16,000.00 135-020-60331-000 Interfund Transfer Out -Tax l&S 9,683.20 10,567.73 -884.53 -9.13% 96,832.00 105,677.30 -8,845.30 -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% 576,378.50 629,028.80 -52,650.30 -9.13% 691,931.00 135-020-60360-000 Furniture/Equipment < $5000 41.65 0.00 41.65 100.00% 416.50 0.00 416.50 100.00% 500.00 135-020-65005-000 Fuel & Lube 1,041.25 545.34 495.91 47.63% 10,412.50 8,772.70 1,639.80 15.75% 12,500.00 135-020-65010-000 Uniforms 367.76 411.93 -44.17 -12.01% 3,677.60 2,931.96 745.64 20.28% 4,415.00 135-020-65030-000 Chemicals 2,707.25 2,669.78 37.47 1.38% 27,072.50 22,109.42 4,963.08 18.33% 32,500.00 135-020-65031-000 Chemicals Collections 833.00 0.00 833.00 100.00% 8,330.00 6,002.80 2,327.20 27.94% 10,000.00 135-020-65045-000 Lab Supplies 2,748.90 5,177.83 -2,428.93 -88.36% 27,489.00 27,541.04 -52.04 -0.19% 33,000.00 135-020-65095-000 Maintenance Supplies 0.00 0.00 0.00 0.00% 0.00 2.70 -2.70 0.00% 0.00 135-020-69005-000 Capital Outlays 74,553.50 63,588.15 10,965.35 14.71% 745,535.00 1,141,749.23 -396,214.23 -53.14% 895,000.00 135-020-69008-000 Short Term Debt -Principal 7,144.30 21,958.10 -14,813.80 -207.35% 71,443.00 85,762.59 -14,319.59 -20.04% 85,766.00 135-020-69009-000 Short Term Debt -Interest 233.32 882.60 -649.28 -278.28% 2,333.20 2,834.91 -501.71 -21.50% 2,801.00 135-020-69195-000 GASB Reserve for Replacement 13,809.22 0.00 13,809.22 100.00% 138,092.20 165,777.00 -27,684.80 -20.05% 165,777.00 Total Department: 020 - Wastewater: 290,877.74 255,211.18 35,666.56 12.26% 2,908,777.40 3,342,338.10 -433,560.70 -14.91% 3,491,931.00 Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation I= 1.24 0.62 50.00% li 12.4150.00% 135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 624.70 750.00 -125.30 -20.06% 750.00 135-026-60075-000 Meetings Ilr124.95 8.96 7.17% 1,249.50 1,218.80 2.46% ' 135-026-60080-000 Schools & Training 333.20 0.00 333.20 100.00% 3,332.00 535.00 2,797.00 83.94% 4,000.00 8/17/2023 7:13:07 PM Page 3 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 135-026-60100-000 135-026-60245-000 Travel & per diem Miscellaneous Expenses Total Department: 026 - Board of Directors: Variance Variance July July Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 150 0.00 416.50 100.00% 4,165.00 Ai 0.00 4,165.00 100.004 5,000.04 41.65 0.00 41.65 100.00% 416.50 0.00 416.50 100.00% 500.00 980.01 116.61 863.40 88.10% 9,800.10 2,510.00 7,290.10 74.39% 11,765.00 Department: 030 - Administration 135-030-50005-000 Salaries & Wages 51,724.13 47,561.38 4,162.75 8.05% 517,241.30 485,751.81 31,489.49 Mfr. 620,938.00 135-030-50010-000 Overtime 166.60 117.81 48.79 29.29% 1,666.00 966.50 699.50 41.99% 2,000.00 135-030-50016-000 Longevity 201.83 0.00 201.83 100.00% 2,018.30 2,422.50 -404.20 -20.03% 2,423.00 135-030-50020-000 Retirement 6,149.53 5,694.51 455.02 7.40% 61,495.30 58,577.67 2,917.63 4.74% 73,824.00 135-030-50026-000 Medical Insurance 9,686.95 6,755.26 2,931.69 30.26% 96,869.50 64,153.06 32,716.44 33.77% 116,290.00 135-030-50027-000 Dental Insurance 504.04 241.51 262.53 52.09% 5,040.40 2,581.02 2,459.38 48.79% 6,051.00 135-030-50028-000 Vision Insurance 74.88 55.35 19.53 26.08% 748.80 518.16 230.64 30.80% 899.00 135-030-50029-000 Life Insurance & Other 199.92 512.54 -312.62 -156.37% 1,999.20 4,276.80 -2,277.60 -113.93% 2,400.00 135-030-50030-000 Social Security Taxes 3,229.70 2,843.83 385.87 11.95% 32,297.00 28,872.55 3,424.45 10.60% 38,772.00 135-030-50035-000 Medicare Taxes 755.36 665.09 90.27 11.95% 7,553.60 6,818.30 735.30 9.73% 9,068.00 135-030-50040-000 Unemployment Taxes 125.94 0.00 125.94 100.00% 1,259.40 58.55 1,200.85 95.35% 1,512.00 135-030-50045-000 Workman's Compensation 124.61 107.60 17.01 13.65% 1,246.10 1,076.00 170.10 13.65% 1,496.00 135-030-50060-000 Pre-emp Physicals/Testing 41.65 0.00 41.65 100.00% 416.50 198.45 218.05 52.35% 500.00 135-030-50070-000 Employee Relations 333.20 0.00 333.20 100.00% 3,332.00 2,563.57 768.43 23.06% 4,000.00 135-030-55030-000 Software & Support 10,970.61 4,126.76 6,843.85 62.38% 109,706.10 87,076.20 22,629.90 20.63% 131,700.00 135-030-55070-000 Independent Labor 1,249.50 67.50 1,182.00 94.60% 12,495.00 6,023.19 6,471.81 51.80% 15,000.00 135-030-55080-000 Maintenance & Repairs 3,332.00 4,951.16 -1,619.16 -48.59% 33,320.00 17,994.91 15,325.09 45.99% 40,000.00 135-030-55085-000 Generator Maint. and Repair 249.90 0.00 249.90 100.00% 2,499.00 0.00 2,499.00 100.00% 3,000.00 135-030-55120-000 Cleaning Services 999.60 967.35 32.25 3.23% 9,996.00 11,389.09 -1,393.09 -13.94% 12,000.00 135-030-55160-000 Professional Outside Services 6,250.83 2,082.50 4,168.33 66.68% 62,508.30 74,272.37 -11,764.07 -18.82% 75,040.00 135-030-55205-000 Utility Billing Contract 749.70 1,076.49 -326.79 -43.59% 7,497.00 6,874.91 622.09 8.30% 9,000.00 135-030-60005-000 Telephone 499.80 476.50 23.30 4.66% 4,998.00 4,745.90 252.10 5.04% 6,000.00 135-030-60010-000 Communications/Mobiles 249.90 73.11 176.79 70.74% 2,499.00 73.11 2,425.89 97.07% 3,000.00 135-030-60020-000 Electricity/Gas 2,029.93 1,508.92 521.01 25.67% 20,299.30 13,751.50 6,547.80 32.26% 24,369.00 135-030-60025-000 Water 416.50 438.33 -21.83 -5.24% 4,165.00 4,094.70 70.30 1.69% 5,000.00 135-030-60035-000 Postage 2,499.00 3,817.58 -1,318.58 -52.76% 24,990.00 21,839.81 3,150.19 12.61% 30,000.00 135-030-60040-000 Service Charges & Fees 7,913.50 16,246.28 -8,332.78 -105.30% 79,135.00 121,926.54 -42,791.54 -54.07% 95,000.00 135-030-60050-000 Bad Debt Expense 124.95 0.00 124.95 100.00% 1,249.50 48.65 1,200.85 96.11% 1,500.00 135-030-60055-000 Insurance 7,347.06 8,117.81 -770.75 -10.49% 73,470.60 81,178.10 -7,707.50 -10.49% 88,200.00 135-030-60070-000 Dues & Memberships 541.45 244.00 297.45 54.94% 5,414.50 6,804.55 -1,390.05 -25.67% 6,500.00 135-030-60079-000 Public Education 3,332.00 651.25 2,680.75 80.45% 33,320.00 25,132.58 8,187.42 24.57% 40,000.00 135-030-60080-000 Schools & Training 270.72 0.00 270.72 100.00% 2,707.20 277.17 2,430.03 89.76% 3,250.00 135-030-60100-000 Travel & per diem 132.28 0.00 132.28 100.00% 1,322.80 0.00 1,322.80 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 469.67 -53.17 -12.77% 4,165.00 2,998.73 1,166.27 28.00% 5,000.00 135-030-60360-000 Furniture/Equipment < $5000 833.00 0.00 833.00 100.00% 8,330.00 13,052.82 -4,722.82 -56.70% 10,000.00 135-030-65010-000 Uniforms 44.14 0.00 44.14 100.00% 441.40 0.00 441.40 100.00% 530.00 135-030-65055-000 Hardware 699.72 0.00 699.72 100.00% 6,997.20 13,213.55 -6,216.35 -88.84% 8,400.00 8/17/2023 7:13:07 PM Page 4 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 07/31/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 Departmental 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 Departmental: Total Expense: Total Revenues Total Fund: 135 - MUD 1 General Fund: Report Total: July 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 July Activity 307.26 620.56 0.00 274.84 0.00 111,072.75 0.00 0.00 0.00 0.00 Variance Favorable (Unfavorable) 192.54 -287.36 0.00 58.36 2,227.10 0.00 16,791.48 5,414.50 2,815.54 1,077.90 416.50 9,724.44 Percent Remaining 38.52% -86.24% 0.00% 17.52% 100.00 % 13.13% 100.00% 100.00% 100.00% 100.00% 100.00% YTD Budget 4,998.00 3,332.00 0.00 3,332.00 22,271.00 1,278,642.30 54,145.00 28,155.40 10,779.00 4,165.00 97,244.40 YTD Activity 3,559.32 5,122.78 74,952.60 2,677.10 26,736.00 1,284,739.12 18,494.00 22,551.10 9,100.15 4,046.00 Variance Favorable (Unfavorable) 1,438.68 -1,790.78 -74,952.60 654.90 -4,465.00 -6,096.82 35,651.00 5,604.30 1,678.85 119.00 Percent Remaining Total Budget 28.79% 6,000.00 -53.74% 4,000.00 0.00% 0.00 19.65% 4,000.00 -20.05% 26,736.00 -0.48% 1,534,986.00 54,191.25 43,053.15 65.84% 65,000.00 19.90% 33,800.00 15.58% 12,940.00 2.86% 5,000.00 44.27% 116,740.00 977,388.08 949,344.62 28,043.46 2.87% 9,773,880.80 9,320,643.13 453,237.67 4.64% 11,733,354.00 977,388.37 1,334,724.99 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 8/17/2023 7:13:07 PM Page 5 of 7 Monthly Budget Report 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 Departmental Total Revenue: Total Expense: Total Revenues Total Fund: 135 - MUD 1 General Fund: Report Total: For Fiscal: Current Period Ending: 07/31/2023 Group Summary Variance Variance July July Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 977,388.37 1,334,724.99 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 977,388.37 1,334,724.99 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 547,941.66 582,944.08 -35,002.42 -6.39% 5,479,416.60 4,636,864.66 842,551.94 15.38% 6,577,932.00 290,877.74 255,211.18 35,666.56 12.26% 2,908,777.40 3,342,338.10 -433,560.70 -14.91% 3,491,931.00 980.01 116.61 863.40 88.10% 9,800.10 2,510.00 7,290.10 74.39% 11,765.00 127,864.23 111,072.75 16,791.48 13.13% 1,278,642.30 1,284,739.12 -6,096.82 -0.48% 1,534,986.00 9,724.44 0.00 9,724.44 100.00% 97,244.40 54,191.25 43,053.15 44.27% 116,740.00 977,388.08 949,344.62 28,043.46 2.87% 9,773,880.80 9,320,643.13 453,237.67 4.64% 11,733,354.00 977,388.37 1,334,724.99 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 8/17/2023 7:13:07 PM Page 6 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 Fund Summary Variance Variance July July Favorable Percent YTD YTD Favorable Percent Fund Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135 - MUD 1 General Fund 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 Report Total: 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 8/17/2023 7:13:07 PM Page 7 of 7 Department Trophy Club Municipal Utility District No. 1 122 - Trophy Club MUD Fire Dept. Asset 000 - Revenue, Asset, Liability, & Equity 1,025,241.94 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 07/31/2023 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 Consolidated Bond Const -SWIFT Bond 16" Revenue Bond GASB Waterline Reserve Fund 10,991,121.70 3,422,146.58 810, 625.28 1,168, 658.63 Total 934,030.46 18,351,824.59 Total Asset: 1,025,241.94 10,991,121.70 3,422,146.58 810,625.28 1,168,658.63 934,030.46 18,351,824.59 43,046.49 640,430.79 0.00 81,691.15 0.00 0.00 765,168.43 Total Liability: 43,046.49 640,430.79 0.00 81,691.15 0.00 0.00 765,168.43 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,452,937.21 9,223,795.97 436,572.00 23,403.93 45,749.91 33,426.05 11,215,885.07 1,152,545.33 9,320,643.13 0.00 0.00 216,188.21 0.00 10,689,376.67 300,391.88 982,195.45 1,025,241.94 -96,847.16 10,350,690.91 10,991,121.70 436,572.00 3,422,146.58 3,422,146.58 23,403.93 728,934.13 810,625.28 -170,438.30 1,168,658.63 1,168,658.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 l&S Revenue Bond payments for Fund 534, 535, & 536 Monthly bank interest 33,426.05 934,030.46 934,030.46 526,508.40 17,586,656.16 18,351,824.59 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 8/17/2023 9:00:56 PM Page 1 of 1 Department Asset Liabi Equi Trophy Club Municipal Utility District No. 1 533 - MUD 1 I&S 534 - 2015 Consolidated Revenue Bond I&S 000 - Revenue, Asset, Liability, & Equity 985,940.44 Total Asset: 985,940.44 lity 000 - Revenue, Asset, Liability, 8t Equity Total Liability: 30,652.23 ty 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): 30,652.23 4,145.11 535 - 2016 Rev Bond l&S-SWIFT 494, 549.21 233,554.30 536 - 2019 Rev Bond I&S- W&WW System Balance Sheet I&S Funds 533 - 536 Account Summary As Of 07/31/2023 Total 243,354.40 1,957,398.35 494, 549.21 233, 554.30 243,354.40 1,957,398.35 0.00 0.00 0.00 30,652.23 0.00 0.00 0.00 30,652.23 27,958.35 6,554.77 1,429.17 40,087.40 4,145.11 1,025,721.93 74,578.83 27,958.35 558,909.61 92,318.75 6,554.77 1,429.17 254,768.78 27,769.25 349,193.98 107,268.75 40,087.40 2,188,594.30 301,935.58 951,143.10 955,288.21 985,940.44 466,590.86 494,549.21 494,549.21 226,999.53 233,554.30 233,554.30 241,925.23 243,354.40 243,354.40 1,886,658.72 1,926,746.12 1,957,398.35 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 l&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest 8/17/2023 9:02:04 PM Page 1 of 1 CASH STATUS AS OF JULY 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,531,256 $2,531,256 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $140,855 $4,831,809 $4,972,664 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,923,327 $0 $1,923,327 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) $810,625 $0 $810,625 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,168,659 $0 $1,168,659 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $934,030 $0 $934,030 533-10250 TexPool Tax I & S (XXXXX0003) $1,003,104 $0 $1,003,104 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $494,549 $0 $494,549 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $233,554 $0 $233,554 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $243,354 $0 $243,354 $7,363,664 $17,737,869 Amount available in cash for spending (MUD Accounts) *7/31/2023 Customer Water Deposits $140,855 Fire Department Cash $7,363,664 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $911,454 $840,013 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $191,028 $191,028 $0 $1,102,482 $1,031,041 Amount available in cash for spending (Fire Department Accounts) $1,102,482 General Fund 135 Available $ 4,831,809 Prosperity General Fund $ 2,531,256 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 7,363,664 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 $ (96,847) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,350,691 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections MUD Connections PID July Utility Billing Report Fiscal Year 2022 - 2023 July 2022 August 2022 September 2022 October 2022 November 2022 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 1,592 1,629 1,654 1,667 1,710 1,746 1,765 1,777 1,773 1,767 1,794 1,766 1,750 3,872 3,850 3,832 3,822 3,801 3,768 3,741 3,751 3,744 3,743 3,734 3,755 3,749 697 704 703 706 711 630 606 599 599 590 588 589 585 1,471 1,484 1,481 1,501 1,494 2,251 2,540 2,719 3,016 2,998 2,754 3,134 3,101 1,220 1,170 1,203 1,159 1,049 387 310 326 337 0 0 0 547 413 289 290 327 327 7 5 2 0 4 0 0 0 0 8 9 9 13 3401 3398 3399 3399 3399 3399 3394 3394 3394 3394 3394 3395 3395 1443 1443 1444 1444 1444 1444 1444 1443 1443 1443 1443 1443 1443 July 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 $ - $ - $ - $ - $ - $ - $ - $