Loading...
HomeMy WebLinkAbout2023-08 August Finance ReportsTrophy Club Municipal Utility District No. 1 Vendor Number Vendor Name Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular Check Report By Check Number Date Range: 08/01/2023 - 08/31/2023 Payment Date Payment Type Discount Amount Payment Amount Number 3127 Allied Welding Supply Inc. 08/02/2023 Regular 0.00 21.78 9780 3197 BenefitMall 08/02/2023 Regular 0.00 52.00 9781 2655 Core & Main LP 08/02/2023 Regular 0.00 460.00 9782 2606 Fisery Solutions LLC 08/02/2023 Regular 0.00 50.00 9783 1372 Hach Company 08/02/2023 Regular 0.00 512.10 9784 2759 Hardys Painting 08/02/2023 Regular 0.00 4,538.00 9785 4033 Health Care Service Corporation 08/02/2023 Regular 0.00 22,147.36 9786 3297 J&L Construction LLC 08/02/2023 Regular 0.00 251,133.30 9787 3115 Metlife Group Benefits 08/02/2023 Regular 0.00 2,301.06 9788 3176 Rey -Mar Construction 08/02/2023 Regular 0.00 17,484.00 9789 3156 Southern Petroleum Lab Inc 08/02/2023 Regular 0.00 706.80 9790 4000 UST General Contracting LLC 08/02/2023 Regular 0.00 58,492.53 9791 2772 Allied Waste Industries 08/16/2023 Regular 0.00 6,636.75 9792 2683 Charter Communications 08/16/2023 Regular 0.00 899.00 9793 3184 Dataprose LLC 08/16/2023 Regular 0.00 4,751.66 9794 2800 Ferguson Enterprises LLC 08/16/2023 Regular 0.00 480.00 9795 3093 Four Man Furnace Inc. 08/16/2023 Regular 0.00 1,097.50 9796 1372 Hach Company 08/16/2023 Regular 0.00 1,312.00 9797 2785 Kleen Pipe, Inc 08/16/2023 Regular 0.00 10,310.00 9798 2754 Lower Colorado River Authority 08/16/2023 Regular 0.00 213.92 9799 3216 M3 Networks 08/16/2023 Regular 0.00 373.58 9800 1056 Office Depot Inc 08/16/2023 Regular 0.00 109.53 9801 4019 Peterson Pump & Motor Service LLC 08/16/2023 Regular 0.00 960.00 9802 3176 Rey -Mar Construction 08/16/2023 Regular 0.00 17,915.00 9803 3156 Southern Petroleum Lab Inc 08/16/2023 Regular 0.00 1,335.60 9804 2440 Tarrant County Public Health Laboratory 08/16/2023 Regular 0.00 420.00 9805 2696 Texas Excavation Safety System 08/16/2023 Regular 0.00 165.30 9806 1001 Town of Trophy Club 08/16/2023 Regular 0.00 208,429.17 9807 1081 Tri County Electric 08/16/2023 Regular 0.00 633.16 9808 4029 Trojan Technolgoies Group ULC 08/16/2023 Regular 0.00 1,695.00 9809 1000 Trophy Club Mud (Water Bills) 08/16/2023 Regular 0.00 438.33 9810 1058 Verizon Wireless 08/16/2023 Regular 0.00 608.56 9811 3197 BenefitMall 08/23/2023 Regular 0.00 52.00 9812 3299 Bickerstaff Heath Delgado Acosta LLP 08/23/2023 Regular 0.00 2,291.00 9813 2796 Garver 08/23/2023 Regular 0.00 9,686.00 9814 2635 Halff Associates Inc. 08/23/2023 Regular 0.00 500.00 9815 4033 Health Care Service Corporation 08/23/2023 Regular 0.00 22,147.36 9816 3278 Kyocera Document Solutions 08/23/2023 Regular 0.00 102.14 9817 3216 M3 Networks 08/23/2023 Regular 0.00 1,091.00 9818 3186 Member's Building Maintenance 08/23/2023 Regular 0.00 1,289.80 9819 3115 Metlife Group Benefits 08/23/2023 Regular 0.00 2,301.06 9820 2760 NDS Leasing 08/23/2023 Regular 0.00 175.00 9821 3179 NewGen Strategies & Solutions 08/23/2023 Regular 0.00 497.50 9822 3111 North Texas Groundwater 08/23/2023 Regular 0.00 4,633.70 9823 3156 Southern Petroleum Lab Inc 08/23/2023 Regular 0.00 1,021.20 9824 3283 TK Contractors Inc 08/23/2023 Regular 0.00 4,200.00 9825 4000 UST General Contracting LLC 08/23/2023 Regular 0.00 121,380.76 9826 2222 Aflac 08/31/2023 Regular 0.00 446.16 9827 2772 Allied Waste Industries 08/31/2023 Regular 0.00 4,089.79 9828 4018 BP Energy Holding Company LLC 08/31/2023 Regular 0.00 49,551.08 9829 1030 City of Fort Worth 08/31/2023 Regular 0.00 403,632.12 9830 2655 Core & Main LP 08/31/2023 Regular 0.00 420.96 9831 1737 DPC Industries Inc. 08/31/2023 Regular 0.00 1,946.35 9832 9/14/2023 7:31:52 PM Page 1 of 4 Check Report Vendor Number 2800 3093 2635 2943 3132 2801 3134 2809 1907 3156 2440 1000 1120 3225 4060 Vendor Name Ferguson Enterprises LLC Four Man Furnace Inc. Halff Associates Inc. JP Morgan Chase Bank NA Legal Shield Pipeline Analysis LLC Prime Controls LP Rod L Abbott CPA LLC Ron Montgomery & Assoc Inc Southern Petroleum Lab Inc Tarrant County Public Health Laboratory Trophy Club Mud (Water Bills) Trophy Club Mud Petty Cash US Bank Voyager Fleet Systems Xylem Dewatering Solutions, Inc. Payment Date 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 08/31/2023 Payment Type Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Total Regular: Discount Amount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Date Range: 08/01/2023 - 08/31/2023 Payment Amount 5,082.96 1,841.25 600.00 6,185.56 15.95 19,505.10 9,280.00 612.85 306.50 2,042.40 80.00 423.50 257.00 3,396.47 18,900.00 0.00 1,316,667.51 Number 9833 9834 9835 9836 9837 9838 9839 9840 9841 9842 9843 9844 9845 9846 9847 9/14/2023 7:31:52 PM Page 2 of 4 Check Report Date Range: 08/01/2023 - 08/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payment Type: Bank Draft 3197 BenefitMall 08/04/2023 Bank Draft 0.00 266.67 DFT0000091 3113 TCDRS 08/31/2023 Bank Draft 0.00 9,587.08 DFT0000092 3124 IRS Tax Payment 08/04/2023 Bank Draft 0.00 12,897.57 DFT0000093 3197 BenefitMall 08/18/2023 Bank Draft 0.00 266.67 DFT0000094 3113 TCDRS 08/31/2023 Bank Draft 0.00 9,615.95 DFT0000095 3124 IRS Tax Payment 08/18/2023 Bank Draft 0.00 13,035.55 DFT0000096 3294 Texas Workforce Commission 08/04/2023 Bank Draft 0.00 7.17 DFT0000097 3113 TCDRS 08/31/2023 Bank Draft 0.00 66.78 DFT0000098 3124 IRS Tax Payment 08/25/2023 Bank Draft 0.00 53.78 DFT0000099 Total Bank Draft: 0.00 45,797.22 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 92 68 0.00 1,316,667.51 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 9 9 0.00 45,797.22 EFT's 0 0 0.00 0.00 101 77 0.00 1,362,464.73 9/14/2023 7:31:52 PM Page 3 of 4 Check Report Date Range: 08/01/2023 - 08/31/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 92 68 0.00 1,316,667.51 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 9 9 0.00 45,797.22 EFT's 0 0 0.00 0.00 101 77 0.00 1,362,464.73 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 8/2023 1,362,464.73 1,362,464.73 9/14/2023 7:31:52 PM Page 4 of 4 1 FY 2023 Combined Financials YTD as of 8/31/2023 YTD Revenues YTD Expenses Amended Revenues is Amended Expenses Adopted Revenues Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $10,840,182 $12,442,977 $12,921,200 511,733,354 $11,733,354 $2,743 $64,184 0% $1,387,787 $3,557,799 33% 13% 1% $5,703,297 53% YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD ■ YTD Expense- Non Dept Water Budget vs Actual Water Consumption Budget vs Actual 140,000,000 134,083,000 120,000,000 108,707,084 126,270,812 100,000,000 0 683,000 79,654,000 104,510,967 80,000,000 70,083,7• r. 80,784,200 52,466,000 88979,203 49,007,000 49,082,000 46,119,000 61,944,185 , 60,000,000 40,000,000 41,702,881 41,572,326 36,351,669 20,000,000 34,501,000 0 -0-Budget Consumption 33,732,116 54,266,627 34,390,563 }Actual Consumption Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug 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 998,602,388 808,128,121 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $1,000,000 5900,000 5800,000 5700,000 $600,000 $664,453 $500,000 5400,000 5300,000 5200,000 5100,000 50 Water Revenue Budget vs Actual $536,842 $440,564 8438,585 $424,445 $404,421 $355,608 $779,457 597,742 5 395,329 8365,714 $335,705 8351,905 $466,063 3520,969 -0-Budget Revenue -a-Actual Revenue 8636,314 $940,104 8792,444 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug $8,000,000 57,000,000 $6,000,000 55,000,000 $4,000,000 53,000,000 $2,000,000 51,000,000 50 Adopted Budget Water Revenue Vs Projected Water Revenue 714 076 $7,567,593 $4,070,848 1 Total Water Revenue 54,801,243 • 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: 08/31/2023 ANNUAL BUDGET TOTAL REMAINING % REVENUE SUMMARY Revenue, Asset, Liability, & Equity 1,616,385.74 1,687,011.37 (70,625.63) 10,840,181.71 11,460,895.07 (620,713.36) 87 12,442,977.00 (1,602,795.29) 13 TOTAL REVENUE 1,616,385.74 1,687,011.37 (70,625.63) 10,840,181.71 11,460,895.07 (620,713.36) 87 12,442,977.00 (1,602,795.29) 13 EXPENSE SUMMARY Revenue, Asset, Liability, & Equity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water 1,066,432.65 1,056,606.66 (9,825.99) 5,703,297.31 6,536,023.26 832,725.95 80 7,086,597.00 (1,383,299.69) 20 Wastewater 215,460.45 977,260.74 761,800.29 3,557,798.55 3,886,038.14 328,239.59 85 4,178,314.00 (620,515.45) 15 Board of Directors 232.60 (7,984.99) (8,217.59) 2,742.60 1,815.11 (927.49) 98 2,800.00 (57.40) 2 Administration 103,047.72 171,427.23 68,379.51 1,387,786.84 1,450,069.53 62,282.69 88 1,578,549.00 (190,762.16) 12 Non Departmental 9,993.10 (32,075.56) (42,068.66) 64,184.35 65,168.84 984.49 86 74,940.00 (10,755.65) 14 TOTAL EXPENSE 1,395,166.52 2,165,234.08 770,067.56 10,715,809.65 11,939,114.88 1,223,305.23 83 12,921,200.00 2,205,390.35 17 REVENUE OVER/(UNDER) EXPENDITURE 221,219.22 (478,222.71) 699,441.93 124, 372.06 (478,219.81) 602,591.87 (478,223.00) (3,808,185.64) 9/15/2023 12:06:27 AM 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 135-000-49903-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 August Budget August Activity Variance Favorable Percent (Unfavorable) Remaining YTD Budget Monthly Budget Report Account Summary For Fiscal: Current Period Ending: 08/31/2023 YTD Activity Variance Favorable Percent (Unfavorable) Remaining Total Budget Asset, Liability, & Equity Property Taxes 7,326.73 159.74 -7,166.99 -97.82% 80,594.03 86,503.60 5,909.57 7.33% 87,956.00 Property Taxes/Delinquent 24.99 8.44 -16.55 -66.23% 274.89 1,296.90 1,022.01 371.79% 300.00 Property Taxes/P & I 24.99 19.82 -5.17 -20.69% 274.89 1,099.05 824.16 299.81% 300.00 PID Surcharges 12,080.91 0.00 -12,080.91 -100.00% 132,890.01 0.00 -132,890.01 -100.00% 145,029.00 Water 990,300.55 1,205,245.69 214,945.14 21.71% 6,580,546.05 6,780,101.43 199,555.38 3.03% 7,142,255.00 Sewer 150,159.84 317,464.24 167,304.40 111.42% 3,348,618.24 3,365,788.15 17,169.91 0.51% 3,670,000.00 Penalties 6,497.40 9,895.49 3,398.09 52.30% 71,471.40 64,015.25 -7,456.15 -10.43% 78,000.00 Service Charges 466.48 425.00 -41.48 -8.89% 5,131.28 3,375.00 -1,756.28 -34.23% 5,600.00 Plumbing Inspections 24.99 0.00 -24.99 -100.00% 274.89 0.00 -274.89 -100.00% 300.00 Sewer Inspections 8.33 0.00 -8.33 -100.00% 91.63 0.00 -91.63 -100.00% 100.00 TCCC Effluent Charges 44,998.00 19,554.40 -25,443.60 -56.54% 94,978.00 85,396.72 -9,581.28 -10.09% 100,000.00 Interest Income 361,666.00 36,787.34 -324,878.66 -89.83% 378,326.00 362,448.60 -15,877.40 -4.20% 380,000.00 Cell Tower Revenue 24,211.36 4,000.00 -20,211.36 -83.48% 35,994.96 41,178.81 5,183.85 14.40% 37,179.00 Proceeds from Sale of Assets 27,082.50 22,750.00 -4,332.50 -16.00% 47,907.50 45,886.22 -2,021.28 -4.22% 50,000.00 Prior Year Reserves 47,722.57 0.00 -47,722.57 -100.00% 524,948.27 0.00 -524,948.27 -100.00% 572,900.00 GASB Reserves 13,661.20 0.00 -13,661.20 -100.00% 150,273.20 0.00 -150,273.20 -100.00% 164,000.00 Oversize Meter Reimbursement ii 171.43 0.00 -171.43 -100.00% 1,885.73 0.00 -1,885.73 -100.00% 2,058.00 Miscellaneous Income 583.10 0.00 -583.10 -100.00% 6,414.10 3,016.40 -3,397.70 -52.97% 7,000.00 Recovery of Prior Year Expense =MI 0.00 75.58 A 75.58 0.00% i 0.00 Mi5.58 j 75.58 0.00% A. 0.00 nt: 000 - Revenue, Asset, Liability, & Equity: 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Total Revenue: 1,687,011.37 1,616,385.74 33,914.67 31,364.33 1,416.10 3,211.26 498.38 0.00 299.88 225.00 4,264.96 4,176.09 11,795.74 8,444.02 406.17 350.33 62.05 71.31 199.92 290.69 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 2,550.34 7.52% 373,061.37 348,646.84 24,414.53 6.54% 407,139.00 -1,795.16 -126.77% 15,577.10 13,308.63 2,268.47 14.56% 17,000.00 498.38 100.00% 5,482.18 5,982.50 -500.32 -9.13% 5,983.00 74.88 24.97% 3,298.68 2,475.00 823.68 24.97% 3,600.00 88.87 2.08% 46,914.56 44,548.28 2,366.28 5.04% 51,200.00 3,351.72 28.41% 80,703.14 79,181.19 1,521.95 1.89% 87,627.00 55.84 13.75% 4,467.87 3,609.59 858.28 19.21% 4,876.00 -9.26 -14.92% 682.55 672.90 9.65 1.41% 745.00 -90.77 -45.40% 2,199.12 3,276.22 -1,077.10 -48.98% 2,400.00 9/15/2023 12:13:20 AM Page 1 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 Variance Variance August August Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-010-50030-000 Social Security Taxes 2,240.02 2,092.45 147.57 6.59% 24,640.22 22,491.73 2,148.49 8.72% 26,891.00 135-010-50035-000 Medicare Taxes 523.87 489.36 34.51 6.59% 5,762.57 5,060.09 702.48 12.19% 6,289.00 135-010-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 1,154.45 53.98 1,100.47 95.32% 1,260.00 135-010-50045-000 Workman's Compensation 937.04 1,109.40 -172.36 -18.39% 10,307.44 12,203.40 -1,895.96 -18.39% 11,249.00 135-010-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 366.52 420.45 -53.93 -14.71% 400.00 135-010-50070-000 Employee Relations 24.99 334.55 -309.56 -1,238.74% 274.89 467.50 -192.61 -70.07% 300.00 135-010-55080-000 Maintenance & Repairs -5,857.66 47,707.02 -53,564.68 914.44% 185,565.74 180,714.68 4,851.06 2.61% 204,800.00 135-010-55085-000 Generator Maint. and Repair 166.60 0.00 166.60 100.00% 1,832.60 875.96 956.64 52.20% 2,000.00 135-010-55090-000 Vehicle Maintenance 7,482.50 0.00 7,482.50 100.00% 11,647.50 12,871.11 -1,223.61 -10.51% 12,066.00 135-010-55105-000 Maintenance-Backhoe/SkidLoader 83.30 0.00 83.30 100.00% 916.30 2,516.06 -1,599.76 -174.59% 1,000.00 135-010-55120-000 Cleaning Services 208.25 161.23 47.02 22.58% 2,290.75 1,934.75 356.00 15.54% 2,500.00 135-010-55135-000 Lab Analysis 624.75 790.00 -165.25 -26.45% 6,872.25 5,212.44 1,659.81 24.15% 7,500.00 135-010-55135-001 Lab Analysis for PID 166.60 80.00 86.60 51.98% 1,832.60 2,026.58 -193.98 -10.58% 2,000.00 135-010-60010-000 Communications/Mobiles 624.75 486.64 138.11 22.11% 6,872.25 5,151.08 1,721.17 25.05% 7,500.00 135-010-60020-000 Electricity -14,426.78 25,507.09 -39,933.87 276.80% 175,705.42 166,158.11 9,547.31 5.43% 194,810.00 135-010-60066-000 Publications/Books/Subscripts 83.30 0.00 83.30 100.00% 916.30 0.00 916.30 100.00% 1,000.00 135-010-60080-000 Schools & Training 302.37 211.00 91.37 30.22% 3,326.07 3,123.72 202.35 6.08% 3,630.00 135-010-60100-000 Travel & per diem 78.13 0.00 78.13 100.00% 859.43 44.79 814.64 94.79% 938.00 135-010-60135-000 TCEQ Fees & Permits 2,499.00 4,633.70 -2,134.70 -85.42% 27,489.00 27,945.73 -456.73 -1.66% 30,000.00 135-010-60135-001 TCEQ Fees & Permits for PID 214.00 0.00 214.00 100.00% 214.00 213.92 0.08 0.04% 214.00 135-010-60150-000 Wholesale Water 219,922.99 403,632.12 -183,709.13 -83.53% 2,419,152.89 2,095,551.61 323,601.28 13.38% 2,640,132.00 135-010-60285-000 Lawn Equipment & Maintenance 1,041.25 0.00 1,041.25 100.00% 11,453.75 4,800.00 6,653.75 58.09% 12,500.00 135-010-60332-000 Interfund Transfer Out -Rev I&S 47,296.24 51,616.70 -4,320.46 -9.13% 520,258.64 567,783.30 -47,524.66 -9.13% 567,782.00 135-010-60360-000 Furniture/Equipment < $5000 208.25 1,355.00 -1,146.75 -550.66% 2,290.75 1,355.00 935.75 40.85% 2,500.00 135-010-65005-000 Fuel & Lube 1,249.50 2,057.50 -808.00 -64.67% 13,744.50 16,460.88 -2,716.38 -19.76% 15,000.00 135-010-65010-000 Uniforms 362.77 200.00 162.77 44.87% 3,990.47 3,097.65 892.82 22.37% 4,355.00 135-010-65030-000 Chemicals 22,582.50 2,367.31 20,215.19 89.52% 43,407.50 46,189.83 -2,782.33 -6.41% 45,500.00 135-010-65050-000 Meter Expense -11,914.00 0.00 -11,914.00 100.00% 4,746.00 0.00 4,746.00 100.00% 6,420.00 135-010-65053-000 Meter Change Out Program 7,247.10 0.00 7,247.10 100.00% 79,718.10 87,000.00 -7,281.90 -9.13% 87,000.00 135-010-69005-000 Capital Outlays 693,941.60 575,468.55 118,473.05 17.07% 2,153,357.60 1,726,016.85 427,340.75 19.85% 2,300,000.00 135-010-69008-000 Short Term Debt -Principal 2,655.77 0.00 2,655.77 100.00% 29,213.47 31,882.11 -2,668.64 -9.13% 31,882.00 135-010-69009-000 Short Term Debt -Interest 39.15 0.00 39.15 100.00% 430.65 470.26 -39.61 -9.20% 470.00 135-010-69195-000 GASB Reserve for Replacement Uhl13,547.82 illaiganglim 115,547.82 852.89% 149,026.02 60,639.00 88,387.02 51111., 162,639.00 135-010-69281-000 Water Tank Inspection Contract 9,454.55 0.00 9,454.55 100.00% 104,000.05 110,863.59 -6,863.54 -6.60% 113,500.00 Total Department: 010 - Water: 1,056,606.66 1,066,432.65 -9,825.99 -0.93% 6,536,023.26 5,703,297.31 832,725.95 12.74% 7,086,597.00 Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 6,318.26 17,146.69 -10,828.43 -171.38% 264,260.86 262,326.09 1,934.77 0.73% 290,179.00 135-020-50010-000 Overtime -14,665.10 1,767.85 -16,432.95 112.05% 12,823.90 14,353.51 -1,529.61 -11.93% 15,586.00 135-020-50016-000 Longevity 336.11 0.00 336.11 100.00% 3,697.21 4,035.00 -337.79 -9.14% 4,035.00 135-020-50017-000 Certification 524.79 225.00 299.79 57.13% 5,772.69 4,125.00 1,647.69 28.54% 6,300.00 135-020-50020-000 Retirement 3,471.19 2,296.75 1,174.44 33.83% 38,183.09 34,189.56 3,993.53 10.46% 41,671.00 135-020-50026-000 Medical Insurance -24,672.97 4,503.48 -29,176.45 118.25% 55,777.33 59,344.92 -3,567.59 -6.40% 63,861.00 9/15/2023 12:13:20 AM Page 2 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 Variance Variance August August Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-020-50027-000 Dental Insurance 452.06 166.51 285.55 63.17% 4,972.66 2,476.61 2,496.05 50.20% 5,427.00 135-020-50028-000 Vision Insurance 66.05 42.52 23.53 35.62% 726.55 520.98 205.57 28.29% 793.00 135-020-50029-000 Life Insurance & Other 199.92 144.16 55.76 27.89% 2,199.12 2,358.15 -159.03 -7.23% 2,400.00 135-020-50030-000 Social Security Taxes 1,823.02 1,138.78 684.24 37.53% 20,053.22 17,232.75 2,820.47 14.06% 21,885.00 135-020-50035-000 Medicare Taxes 426.32 266.33 159.99 37.53% 4,689.52 4,030.23 659.29 14.06% 5,118.00 135-020-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 1,154.45 43.66 1,110.79 96.22% 1,260.00 135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 8,234.71 9,749.08 -1,514.37 -18.39% 8,987.00 135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 366.52 150.00 216.52 59.07% 400.00 135-020-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 274.89 1,167.97 -893.08 -324.89% 300.00 135-020-55080-000 Maintenance & Repairs 87,612.18 15,441.65 72,170.53 82.37% 199,733.98 201,538.68 -1,804.70 -0.90% 211,000.00 135-020-55081-000 Mainten & Repairs Collections 76,007.30 31,696.10 44,311.20 58.30% 310,080.30 254,112.55 55,967.75 18.05% 333,600.00 135-020-55085-000 Generator Maint. and Repair -5,414.30 0.00 -5,414.30 100.00% 2,082.70 2,836.29 -753.59 -36.18% 2,836.00 135-020-55090-000 Vehicle Maintenance 383.18 10.90 372.28 97.16% 4,214.98 639.87 3,575.11 84.82% 4,600.00 135-020-55091-000 Veh Maintenance Collections 1,082.90 0.00 1,082.90 100.00% 11,911.90 4,821.91 7,089.99 59.52% 13,000.00 135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 0.00 249.90 100.00% 2,748.90 2,435.44 313.46 11.40% 3,000.00 135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 1,832.60 1,934.65 -102.05 -5.57% 2,000.00 135-020-55125-000 Dumpster Services 3,330.00 10,726.54 -7,396.54 -222.12% 86,630.00 85,077.11 1,552.89 1.79% 95,000.00 135-020-55135-000 Lab Analysis 8,332.00 3,063.60 5,268.40 63.23% 41,652.00 42,587.37 -935.37 -2.25% 45,000.00 135-020-60010-000 Communications/Mobiles 624.75 200.72 424.03 67.87% 6,872.25 3,777.76 3,094.49 45.03% 7,500.00 135-020-60020-000 Electricity -9,327.72 23,176.41 -32,504.13 348.47% 220,845.08 223,155.23 -2,310.15 -1.05% 243,973.00 135-020-60080-000 Schools & Training 302.37 0.00 302.37 100.00% 3,326.07 2,560.75 765.32 23.01% 3,630.00 135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 951.06 0.00 951.06 100.00% 1,038.00 135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 10,995.60 9,888.02 1,107.58 10.07% 12,000.00 135-020-60285-000 Lawn Equipment & Maintenance -6,167.20 0.00 -6,167.20 100.00% 7,160.80 5,740.00 1,420.80 19.84% 8,500.00 135-020-60331-000 Interfund Transfer Out -Tax I&S 9,683.20 10,567.70 -884.50 -9.13% 106,515.20 116,245.00 -9,729.80 -9.13% 116,245.00 135-020-60332-000 Interfund Transfer Out -Rev l&S 57,637.85 62,902.90 -5,265.05 -9.13% 634,016.35 691,931.70 -57,915.35 -9.13% 691,931.00 135-020-60360-000 Furniture/Equipment < $5000 41.65 346.60 -304.95 -732.17% 458.15 346.60 111.55 24.35% 500.00 135-020-65005-000 Fuel & Lube 1,041.25 1,338.97 -297.72 -28.59% 11,453.75 10,111.67 1,342.08 11.72% 12,500.00 135-020-65010-000 Uniforms 367.76 0.00 367.76 100.00% 4,045.36 2,931.96 1,113.40 27.52% 4,415.00 135-020-65030-000 Chemicals -7,292.75 0.00 -7,292.75 100.00% 19,779.75 22,109.42 -2,329.67 -11.78% 22,500.00 135-020-65031-000 Chemicals Collections 833.00 0.00 833.00 100.00% 9,163.00 6,002.80 3,160.20 34.49% 10,000.00 135-020-65045-000 Lab Supplies 2,748.90 213.79 2,535.11 92.22% 30,237.90 27,754.83 2,483.07 8.21% 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 757,553.50 89,029.00 668,524.50 88.25% 1,503,088.50 1,230,778.23 272,310.27 18.12% 1,578,000.00 135-020-69008-000 Short Term Debt -Principal 7,144.30 0.00 7,144.30 100.00% 78,587.30 85,762.59 -7,175.29 -9.13% 85,766.00 135-020-69009-000 Short Term Debt -Interest 233.32 0.00 233.32 100.00% 2,566.52 2,834.91 -268.39 -10.46% 2,801.00 135-020-69195-000 GASB Reserve for Replacement 13,809.22 -62,000.00 75,809.22 548.98% 151,901.42 103,777.00 48,124.42 31.68% 165,777.00 Total Department: 020 - Wastewater: 977,260.74 215,460.45 761,800.29 77.95% 3,886,038.14 3,557,798.55 328,239.59 8.45% 4,178,314.00 Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 1.24 0.62 0.62 50.00% 13.64 6.82 6.82 50.00% 15.00 135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 687.17 750.00 -62.83 -9.14% 750.00 135-026-60075-000 Meetings 124.95 231.98 -107.03 -85.66% 1,374.45 1,450.78 -76.33 -5.55% 1,500.00 9/15/2023 12:13:20 AM Page 3 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 135-026-60080-000 135-026-60100-000 135-026-60245-000 Schools & Training Travel & per diem Miscellaneous Expenses Total Department: 026 - Board of Directors: Department: 030 - Administration 135-030-50005-000 135-030-50010-000 135-030-50016-000 135-030-50020-000 135-030-50026-000 135-030-50027-000 135-030-50028-000 135-030-50029-000 135-030-50030-000 135-030-50035-000 135-030-50040-000 135-030-50045-000 135-030-50060-000 135-030-50070-000 135-030-55030-000 135-030-55070-000 135-030-55080-000 135-030-55085-000 135-030-55120-000 135-030-55160-000 135-030-55205-000 135-030-60005-000 135-030-60010-000 135-030-60020-000 135-030-60025-000 135-030-60035-000 135-030-60040-000 135-030-60050-000 135-030-60055-000 135-030-60070-000 135-030-60079-000 135-030-60080-000 135-030-60100-000 135-030-60245-000 135-030-60285-000 135-030-60360-000 135-030-65010-000 Salaries & Wages Overtime Longevity 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 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleaning Services Professional Outside Services Utility Billing Contract Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Dues & Memberships Public Education Schools & Training Travel & per diem Miscellaneous Expenses Lawn Equipment & Maintenance Furniture/Equipment < $5000 Uniforms August Budget -3,131.80 -4,583.50 -458.35 -7,984.99 Variance Variance August Favorable Percent YTD YTD Favorable Percent Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 0.00 -3,131.80 100.00% 200.20 535.00 -334.80 -167.23% 535.00 0.00 -4,583.50 100.00% -418.50 0.00 -418.50 100.00% 0.00 0.00 -458.35 100.00% -41.85 0.00 -41.85 100.00% 0.00 232.60 -8,217.59 102.91% 1,815.11 2,742.60 -927.49 -51.10% 2,800.00 51,724.13 47,701.69 4,022.44 7.78% 568,965.43 533,453.50 35,511.93 6.24% 620,938.00 166.60 86.77 79.83 47.92% 1,832.60 1,053.27 779.33 42.53% 2,000.00 201.83 0.00 201.83 100.00% 2,220.13 2,422.50 -202.37 -9.12% 2,423.00 6,149.53 5,697.59 451.94 7.35% 67,644.83 64,275.26 3,369.57 4.98% 73,824.00 -27,251.05 6,755.22 -34,006.27 124.79% 69,618.45 70,908.28 -1,289.83 -1.85% 79,352.00 504.04 241.48 262.56 52.09% 5,544.44 2,822.50 2,721.94 49.09% 6,051.00 74.88 55.37 19.51 26.06% 823.68 573.53 250.15 30.37% 899.00 199.92 100.35 99.57 49.80% 2,199.12 4,377.15 -2,178.03 -99.04% 2,400.00 3,229.70 2,834.81 394.89 12.23% 35,526.70 31,707.36 3,819.34 10.75% 38,772.00 755.36 662.99 92.37 12.23% 8,308.96 7,481.29 827.67 9.96% 9,068.00 125.94 0.00 125.94 100.00% 1,385.34 58.55 1,326.79 95.77% 1,512.00 124.61 107.60 17.01 13.65% 1,370.71 1,183.60 187.11 13.65% 1,496.00 41.65 0.00 41.65 100.00% 458.15 198.45 259.70 56.68% 500.00 333.20 178.33 154.87 46.48% 3,665.20 2,741.90 923.30 25.19% 4,000.00 10,970.61 1,372.49 9,598.12 87.49% 120,676.71 88,448.69 32,228.02 26.71% 131,700.00 -5,750.50 450.00 -6,200.50 107.83% 6,744.50 6,473.19 271.31 4.02% 8,000.00 -16,668.00 4,538.00 -21,206.00 127.23% 16,652.00 22,532.91 -5,880.91 -35.32% 20,000.00 249.90 0.00 249.90 100.00% 2,748.90 0.00 2,748.90 100.00% 3,000.00 999.60 967.35 32.25 3.23% 10,995.60 12,356.44 -1,360.84 -12.38% 12,000.00 6,250.83 497.50 5,753.33 92.04% 68,759.13 74,769.87 -6,010.74 -8.74% 75,040.00 749.70 178.96 570.74 76.13% 8,246.70 7,053.87 1,192.83 14.46% 9,000.00 499.80 485.56 14.24 2.85% 5,497.80 5,231.46 266.34 4.84% 6,000.00 249.90 48.22 201.68 80.70% 2,748.90 121.33 2,627.57 95.59% 3,000.00 -5,382.07 1,577.04 -6,959.11 129.30% 14,917.23 15,328.54 -411.31 -2.76% 16,957.00 416.50 423.50 -7.00 -1.68% 4,581.50 4,518.20 63.30 1.38% 5,000.00 -3,501.00 167.11 -3,668.11 104.77% 21,489.00 22,006.92 -517.92 -2.41% 24,000.00 53,913.50 15,525.91 38,387.59 71.20% 133,048.50 137,452.45 -4,403.95 -3.31% 141,000.00 11,624.95 0.00 11,624.95 100.00% 12,874.45 48.65 12,825.80 99.62% 13,000.00 16,547.06 8,117.81 8,429.25 50.94% 90,017.66 89,295.91 721.75 0.80% 97,400.00 541.45 160.00 381.45 70.45% 5,955.95 6,964.55 -1,008.60 -16.93% 6,500.00 -6,668.00 1,731.25 -8,399.25 125.96% 26,652.00 26,863.83 -211.83 -0.79% 30,000.00 270.72 348.97 -78.25 -28.90% 2,977.92 626.14 2,351.78 78.97% 3,250.00 132.28 0.00 132.28 100.00% 1,455.08 0.00 1,455.08 100.00% 1,588.00 0.00 0.00 0.00 0.00% 0.00 88.00 -88.00 0.00% 0.00 416.50 0.00 416.50 100.00% 4,581.50 2,998.73 1,582.77 34.55% 5,000.00 3,886.00 0.00 3,886.00 100.00% 12,216.00 13,052.82 -836.82 -6.85% 13,053.00 44.14 306.50 -262.36 -594.38% 485.54 306.50 179.04 36.87% 530.00 9/15/2023 12:13:20 AM Page 4 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 Variance Variance August August Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-030-65055-000 Hardware 5,513.72 373.58 5,140.14 93.22% 12,510.92 13,587.13 -1,076.21 -8.60% 13,214.00 135-030-65085-000 Office Supplies 499.80 650.32 -150.52 -30.12% 5,497.80 4,209.64 1,288.16 23.43% 6,000.00 135-030-65095-000 Maintenance Supplies 333.20 428.31 -95.11 -28.54% 3,665.20 5,551.09 -1,885.89 -51.45% 4,000.00 135-030-69005-000 Capital Outlays 56,346.00 0.00 56,346.00 100.00% 56,346.00 74,952.60 -18,606.60 -33.02% 56,346.00 135-030-69170-000 Copier Lease Installments 333.20 *277.14 * 56.06 16.82% * 3,665.20 1 2,954.24 710.96 19.40% 4,000.00 135-030-69195-000 GASB Reserve for Replacement 2,227.10 0.00 2,227.10 100.00% 24,498.10 26,736.00 -2,237.90 -9.13% 26,736.00 Total Department: 030 -Administration: 171,427.23 103,047.72 68,379.51 39.89% 1,450,069.53 1,387,786.84 62,282.69 4.30% 1,578,549.00 Department: 039 - Non Departmental 135-039-55045-00k Legal -29,585.50 9,380.25 -38,965.75 131.71% 24,559.50 27,874.25 -3,314.75 -13.50% 30,000.00 135-039-55055-000 Auditing -3,984.46 612.85 -4,597.31 115.38% 24,170.94 23,163.95 1,006.99 4.17% 27,000.00 135-039-55060-000 Appraisal 1,077.90 ` 0.00 1,077.90 100.00% 11,856.90 _ 9,100.15 2,756.75 23.25% 12,940.00 135-039-55065-000 Tax Admin Fees 416.50 0.00 416.50 100.00% 4,581.50 4,046.00 535.50 11.69% 5,000.00 Total Department: 039 - Non Departmental: -32,075.56 9,993.10 -42,068.66 131.15% 65,168.84 64,184.35 984.49 1.51% 74,940.00 Total Expense: 2,165,234.08 1,395,166.52 770,067.56 35.57% 11,939,114.88 10,715,809.65 1,223,305.23 10.25% 12,921,200.00 Total Revenues 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Total Fund: 135 - MUD 1 General Fund: -478,222.71 221,219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 Report Total: -478,222.71 221,219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 9/15/2023 12:13:20 AM Page 5 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 Group Summary Variance Variance August August Favorable Percent YTD YTD Favorable Percent Departmen... Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget Fund: 135 - MUD 1 General Fund Revenue 000 - Revenue, Asset, Liability, & Equity 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Total Revenue: 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Expense 010 - Water 1,056,606.66 1,066,432.65 -9,825.99 -0.93% 6,536,023.26 5,703,297.31 832,725.95 12.74% 7,086,597.00 020 - Wastewater 977,260.74 215,460.45 761,800.29 77.95% 3,886,038.14 3,557,798.55 328,239.59 8.45% 4,178,314.00 026 - Board of Directors -7,984.99 232.60 -8,217.59 102.91% 1,815.11 2,742.60 -927.49 -51.10% 2,800.00 030 -Administration 171,427.23 103,047.72 68,379.51 39.89% 1,450,069.53 1,387,786.84 62,282.69 4.30% 1,578,549.00 039 - Non Departmental -32,075.56 9,993.10 -42,068.66 131.15% 65,168.84 64,184.35 984.49 1.51% 74,940.00 Total Expense: 2,165,234.08 1,395,166.52 770,067.56 35.57% 11,939,114.88 10,715,809.65 1,223,305.23 10.25% 12,921,200.00 Total Revenues 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Total Fund: 135 - MUD 1 General Fund: -478,222.71 221,- 219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 Report Total: -478,222.71 221,- 219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 9/15/2023 12:13:20 AM Page 6 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 Fund Summary Variance Variance August August Favorable Percent YTD YTD Favorable Percent Fund Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135 - MUD 1 General Fund -478,222.71 221,219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 Report Total: -478,222.71 221,219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 9/15/2023 12:13:20 AM Page 7 of 7 Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Liability 000 - Revenue, Asset, Liability, & Equity Equity 000 - Revenue, Asset, Liability, & Equity 122 - Trophy Club MUD Fire Dept. 135 - MUD 1 General Fund 824,015.05 11,586, 690.55 Balance Sheet Funds 122 - 528 Account Summary As Of 08/31/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 813,745.15 1,173,923.91 938,238.63 18,594,759.87 Total Asset: 824,015.05 11,586,690.55 3,258,146.58 813,745.15 1,173,923.91 938,238.63 18,594,759.87 -17,884.96 1,014,780.42 0.00 81,691.15 0.00 0.00 1,078,586.61 Total Liability: -17,884.96 1,014,780.42 0.00 81,691.15 0.00 0.00 1,078,586.61 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,515,556.81 10,840,181.71 272,572.00 26,523.80 51,015.19 37,634.22 12,743,483.73 1,355,460.37 10,715,809.65 0.00 0.00 216,188.21 0.00 12,287,458.23 160,096.44 841,900.01 824,015.05 124,372.06 10,571,910.13 11,586,690.55 272,572.00 3,258,146.58 3,258,146.58 26,523.80 732,054.00 813,745.15 -165,173.02 1,173,923.91 1,173,923.91 37,634.22 938,238.63 938,238.63 456,025.50 17,516,173.26 18,594,759.87 Monthly Financial Activity Footnotes: Fund 122 Activity Daily property tax deposits Monthly transfer OUT to MUD General Fund to cover Town transfers and any other A/P expenses Fund 135 Activity • Daily property tax deposits All A/P checks are cut through the General Fund Monthly transfer IN to cover other fund A/P expenses Monthly transfer OUT for l&S Revenue Bond payments for Fund 534, 535, & 536 Monthly bank interest Fund 137 Activity Transfer IN at beginning of fiscal year based on yearly budget and transfer OUT at fiscal year-end based on reserves balances Fund 519 Activity Monthly bank interest Fund 520 Activity Transfer OUT to MUD General Fund to cover Interconnect Waterline construction project expenses Monthly bank interest Fund 528 Activity Monthly bank interest 9/15/2023 12:48:54 AM 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 66,075.90 Total Asset: 66,075.90 lity 000 - Revenue, Asset, Liability, 8t Equity Total Liability: 29,302.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): 29,302.23 535 - 2016 Rev Bond l&S-SWIFT 38,966.70 11,662.57 38,966.70 11,662.57 536 - 2019 Rev Bond I&S- W&WW System 6,447.81 6,447.81 0.00 0.00 0.00 0.00 0.00 0.00 4,145.11 27,958.35 6,554.77 1,429.17 Balance Sheet I&S Funds 533 - 536 Account Summary As Of 08/31/2023 Total 123,152.98 123,152.98 29,302.23 4,145.11 1,041,311.14 1,008,682.58 27,958.35 615,645.85 604,637.50 6,554.77 1,429.17 280,646.30 275,538.50 384,556.14 379,537.50 29,302.23 40,087.40 40,087.40 2,322,159.43 2,268,396.08 32,628.56 36,773.67 66,075.90 11,008.35 38,966.70 38,966.70 5,107.80 11,662.57 11,662.57 5,018.64 6,447.81 6,447.81 53,763.35 93,850.75 123,152.98 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 9/15/2023 12:52:11 AM Page 1 of 1 CASH STATUS AS OF AUGUST 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,600,731 $2,600,731 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $142,305 $5,660,898 $5,803,203 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,355,177 $0 $1,355,177 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 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) $813,745 $0 $813,745 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,173,924 $0 $1,173,924 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $938,239 $0 $938,239 533-10250 TexPool Tax I & S (XXXXX0003) $84,590 $0 $84,590 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $38,967 $0 $38,967 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $11,663 $0 $11,663 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $6,448 $0 $6,448 $8,262,229 $16,085,432 Amount available in cash for spending (MUD Accounts) *8/31/2023 Customer Water Deposits $142,305 Fire Department Cash $8,262,229 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $762,984 $762,984 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $71,155 $71,155 $0 $834,139 $834,139 Amount available in cash for spending (Fire Department Accounts) $834,139 General Fund 135 Available $ 5,660,898 Prosperity General Fund $ 2,600,731 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 8,262,229 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 $ 124,372 Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,571,910 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections MUD Connections PID August Utility Billing Report Fiscal Year 2022 - 2023 August 2022 September 2022 October 2022 November 2022 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 July 2023 1,629 1,654 1,667 1,710 1,746 1,765 1,777 1,773 1,767 1,794 1,766 1,750 1,744 3,850 3,832 3,822 3,801 3,768 3,741 3,751 3,744 3,743 3,734 3,755 3,749 3,747 704 703 706 711 630 606 599 599 590 588 589 585 578 1,484 1,481 1,501 1,494 2,251 2,540 2,719 3,016 2,998 2,754 3,134 3,101 2,957 1,170 1,203 1,159 1,049 310 326 337 0 0 0 547 413 289 290 327 327 268 5 2 0 4 0 0 0 0 8 9 9 13 7 3398 3399 3399 3399 3399 3394 3394 3394 3394 3394 3395 3395 3395 1443 1444 1444 1444 1444 1444 1443 1443 1443 1443 1443 1443 1443 August 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 $ - $ - $ - $ - $ - $ - $ - $