Loading...
HomeMy WebLinkAbout2020-01 Combined Financials January 2020TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JANUARY 2020 5,11 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,220,452 PREPAID EXPENSES 13,127 ADVALOREM PROPERTY TAXES RECEIVABLE 177,817 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,411,396 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 629,804 TOTAL FUND BALANCE 1,233,573 177,823 177,823 TOTAL LIABILITIES AND FUND BALANCE 1,411,396 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-40010-000-000 122-40011-000-000 122-40020-000-000 Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 1/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Property Taxes/MUD Fire 1,214,230.00- 1,214,230.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P51 Program number: Department number: Fire Revenues Revenues Subtotal 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- MEMII 1,214,230.00- 1,214,230.00- 456,982.39- 1,376.20- 426.40- 1,084,568.93- 1,022.23- 1,647.72- 458,784.99- 1,087,238.88- 458,784.99- 1,087,238.88- 458,784.99- 1,087,238.88- 458,784.99- 1,087,238.88- 89.322 129,661.07- 1,022.23 1,647.72 89.541 126,991.12- Page 89.541 126,991.12- 89.541 126,991.12- 89.541 126,991.12 - glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00 122-60055-045-000 Insurance 21,000.00 21,000.00 122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00 tota1: 957,661.00 957,661.00 122-69005-045-000 Capital Outlays 48,000.00 48,000.00 122-69009-045-000 Short Term Debt -Interest 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 Subtota1: 256,569.00 256,569.00 Program number: 1,214,230.00 1,214,230.00 Department number: Fire 1,214,230.00 1,214,230.00 Expenditures Subtotal 1,214,230.00 1,214,230.00 Fund number: 122 Trophy Club MUD Fire Dept. 1,640.88 59,888.08 61,528.96 61,528.96 61,528.96 61,528.96 397,256.03- 6,563.52 239,552.32 31.255 33.333 218,004.00 14,436.48 479,104.68 2,750.00 5.729 45,250.00 11,958.24 11,958.24- 81,420.00 100.000 115,190.36 90.595 11,958.64 211,318.60 , 82.363 45,14181 457,434.44 , 37.673 756,795.56 457,434.44 , 37.673 756,795.56 457,434. 37.673 756,795.56 629,804.E 629,804.44 Page 2 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 L Property Taxes/MUD Fire 670 01/02/2020 Property Taxes 671 01/03/2020 Property Taxes 672 01/06/2020 Property Taxes 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 693 01/13/2020 Property Taxes 694 01/14/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 698 01/21/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes 705 01/28/2020 Property Taxes 706 01/29/2020 Property Taxes 707 01/30/2020 Property Taxes 708 01/31/2020 Property Taxes (627,586.54) (24,040.24) (15,369.98) (12,677.57) (23,873.74) (22,592.43) (6,233.18) (11,411.00) (8,720.18) (4,702.34) (25,633.01) (8,539.62) (11,615.77) (5,588.50) (11,955.93) (10,781.89) (85,374.77) (22,897.23) (105,049.46) (13,630.74) (12,832.45) (13,462.36) (651,626.78) (666,996.76) (679,674.33) (703,548.07) (726,140.50) (732,373.68) (743,784.68) (752,504.86) (757,207.20) (782,840.21) (791,379.83) (802,995.60) (808,584.10) (820,540.03) (831,321.92) (916,696.69) (939,593.92) (1,044,643.38) (1,058,274.12) (1,071,106.57) (1,084,568.93) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (456,982.39) (1,084,568.93) ** (1,214,230.00) Budgeted (129,661.07) Remaining 89 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent • 670 01/02/2020 Property Taxes 673 01/07/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 704 01/27/2020 Property Taxes 353.97 (18.99) 334.98 GL (14.71) 320.27 GL (43.85) 276.42 GL (1,175.83) (899.41) GL (99.82) (999.23) GL (.01) (999.24) GL (22.99) (1,022.23) GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (1,376.20) (1,022.23) ** .00 Budgeted 1,022.23 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 670 01/02/2020 Property Taxes 671 01/03/2020 Property Taxes (1,221.32) (60.57) (1,281.89) GL (3.87) (1,285.76) GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 672 01/06/2020 Property Taxes 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes Account: 122-40020-000-000 (1,221.32) (7.75) (1,293.51) GL (3.38) (1,296.89) GL (1.94) (1,298.83) GL (15.13) (1,313.96) GL (22.77) (1,336.73) GL (282.92) (1,619.65) GL (1.03) (1,620.68) GL (.69) (1,621.37) GL (15.77) (1,637.14) GL (.25) (1,637.39) GL (5.89) (1,643.28) GL (4.44) (1,647.72) GL Property Taxes/Fire P&I Totals: (426.40) 1,647.72) ** .00 Budgeted 1,647.72 Remaining 0 % Used Department Totals: (1,087,238.88) ** (458,784.99) Monthly Total (1,214,230.00) Budgeted (126,991.12) Remaining 90 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 3 Account: 122-60030-045-000 Rent And/Or U� .00 .00 Account: 122-60030-045-000 Rent And/Or Usage Totals: 218,004.00 Budgeted Account: 122-60055-045-000 Insurance 69 01/01/2020 Insurance/Wrk Comp Expense Jan Account 218,004.00 Remaining 0 % Ueed 21,000.00 Budgeted 14,436.48 Remaining Accoun - Transfer to Town/Fire Budget 483 01/02/2020 January A/P Jan Fire Admin Account: 122-60337-045-00 Transfer to T•: •• 718,657.00 Budgeted Account: 122-69005-045-000 Capital Outlays Account: 122-69005-045-000 Capital Outlays 48,000.00 Budgeted 479,104.68 4,922.64 1,640.88 6,563.52 31 % Ueed 59,888.08 239,552.32 TOWN OF TROPHY CLUB 179,664.24 Remaining 45,250.00 Remaining 2,750.00 33 % Ueed 6 % Ueed .00 2,750.00 GL 6058 AP Account: 122-69009-045-000 Account: 122-69009-045-000 Short Term Debt -Interest Totals: .00 Budgeted (11,958.24) Remaining Account: 122-69195-045-000 GASB34/Reserve for Replacement Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 Budgeted .00 Remaining 11,958.24 0 % Used 81,420.00 100 % Used .00 .00 11,958.24 81,420.00 Account: 122-69305-045-000 Capital Leases glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Capital Leases 127,149.00 Budgeted 115,190.36 .00 115,190.36 Totals: 00 11,958.64 Remaining 91 % Used Department 45 Totals: 457,434.44 ++ 61,528.96 Monthly Total 1,214,230.00 Budgeted 756,795.56 Remaining 38 % Used Fund 122 Totals: (629,804.44) (397,256.03) Monthly Total .00 Budgeted 629,804.44 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET JANUARY 2020 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,594,636 2,594,636 CASH IN BANK -SAVINGS -CASH RESERVE 1,400,451 1,400,451 INVESTMENTS-TEXPOOL 4,066,755 919,266 4,986,021 PREPAID EXPENSES 75,381 75,381 ADVALOREM PROPERTY TAXES RECEIVABLE 19,651 19,651 UTILITY AND OTHER ACCOUNTS RECEIVABLE 809,277 809,277 TOTAL ASSETS 8,966,751 919,266 9,886,017 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 19,651 19,651 ACCOUNTS AND OTHER PAYABLES 393,299 393,299 CUSTOMER DEPOSITS 318,815 318,815 TOTAL LIABILITIES 731,765 731,765 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,072,098 2,072,098 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 270,000 270,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 30,000 30,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 127,805 127,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 391,461 391,461 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 100,000 100,000 UNASSIGNED FUND BALANCE 6,325,800 6,325,800 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES (166,399) (166,399) TOTAL FUND BALANCE 8,234,985 919,266 9,154,251 TOTAL LIABILITIES AND FUND BALANCE 8,966,751 919,266 9,886,017 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 134,871.00- 134,871.00- 300.00- 300.00- 300.00- 300.00- 164,253.00- 164,253.00- 50,730.63- 120,400.36- 89.271 14,470.64- 157.13- 116.99- 38.997 183.01- 47.81- 184.15- 61.383 115.85- 164,253.00- 71 135-47000-000-000 Water 6,486,623.00- 6,486,623.00- 135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 135-47030-000-000 Service Charges 15,150.00- 15,150.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 308,153.82- 1,523,137.03- 23.481 4,963,485.97- 255,733.19- 995,260.50- 28.404 2,508,624.50- 8,437.81- 35,066.86- 31.141 77,541.14- 1,400.00- 6,750.00- 44.554 8,400.00- 350.00- 2,150.00- 286.667 1,400.00 650.00- 1,050.00- 42.000 1,450.00- 19.20- 15,068.00- 30.136 34,932.00- 10,171,516.00- 10,171,516.00- 574,744.02- 2,578,482.39- 7,593,033.61- 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income ENSubtota. Program number: Department number: Revenues Revenues 120,000.00- 120,000.00- 14,146.00- 14,146.00- 7,000.00- 7,000.00- 13,000.00- 13,000.00- 12,691.00- 12,691.00- 7,000.00- 7,000.00- 10,396.30- 41,939.08- 34.949 78,060.92- 3,536.43- 25.000 10,609.57- 583.33- 2,333.32- 33.333 4,666.68- 13,000.00- 1,765.00- 7,120.28- 56.105 5,570.72- 231.52- 8,153.54- 116.479 1,153.54 173,837.00- 12,976.15- 110,754.3 0- 10,645,077.00- 638,655.74- 25.949 7,882,810 Subtotal 11!0- 10,645,077.00- 638,655 25.949 7,882,810 glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 350,267.00 350,267.00 135-50010-010-000 Overtime 17,000.00 17,000.00 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 135-50020-010-000 Retirement 34,863.00 34,863.00 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 135-50028-010-000 Vision Insurance 767.00 767.00 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 25,800.75 104,419.99 2,257.31 7,647.68 5,082.50 425.00 1,650.00 2,637.53 12,072.53 5,225.04 19,153.58 316.93 1,164.85 48.18 187.93 352.65 1,223.77 1,737.92 7,276.76 406.45 1,701.80 28.48 45.16 771.49 3,085.96 29.812 44.986 129.656 30.556 34.628 22.714 24.653 24.502 39.073 31.167 31.163 4.181 26.042 245,847.01 9,352.32 1,162.50- 3,750.00 22,790.47 65,172.42 3,560.15 579.07 1,908.23 16,071.24 3,759.20 1,034.84 8,764.04 400.00 300.00 FSubtotal: ' 546,839.00 546,839.00 .121 382,126.49 135-55005-010-000 Engineering 20,000.00 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 7,256.26 21,176.04 21.176 78,823.96 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 62.41 441.65 8.833 4,558.35 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 920.37 26.296 2,579.63 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50 262.50 26.250 737.50 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 200.00 1,347.70 17.969 6,152.30 Page 4 140,000.00 140,000.00 24,148.26 135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00 135-60020-010-000 Electricity 125,677.00 125,677.00 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 135-60080-010-000 Schools & Training 7,426.00 7,426.00 135-60090-010-000 Safety Program 400.00 400.00 135-60100-010-000 Travel & per diem 2,845.00 2,845.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 135-60135-010-000 TCHQ Fees & Permits 63,000.00 63,000.00 135-60150-010-000 Wholesale Water 2,714,710.00 2,714,710.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 135-60332-010-000 Interfund Transfer Out -Rev I&S 527,381.00 527,381.00 135-60333-010-000 Interfund Transfer Out -Reserve 55,193.00 55,193.00 135-60334-010-000 Interfund Transfer Out 180,000.00 180,000.00 424.30 5,903.40 2,048.65 39,326.83 111.00 406.00 50.00 14,257.15 118,562.59 468,955.29 462.00 47,943.74 191,774.96 4,600.00 18,400.00 40.973 2,951.35 31.292 86,350.17 1,000.00 500.00 5.467 7,020.00 400.00 2,845.00 1,500.00 22.630 48,742.85 17.275 2,245,754.71 200.00 15.400 2,538.00 14,750.00 36.364 335,606.04 33.338 36,793.00 180,000.00 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Description Furniture/Equipment < $5000 Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Period Ending: 1/2020 Program: Amended Total Current YTD % of Remaining Budget Encumb. Month Total Budget Budget 2,500.00 2,500.00 561.72 22.469 1,938.28 Page 2,968,889.40 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract 15,000.00 15,000.00 5,190.00 5,190.00 20,000.00 20,000.00 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 684,875.00 684,875.00 30,512.00 30,512.00 3,231.00 3,231.00 75,000.00 75,000.00 120,000.00 120,000.00 3,618.00 5,504,929.00 5,0-4-,-41111r 1,140.42 3,569.35 2,917.33 2,760.11 7,625.15 7,229.50 16,104.78 36,900.00 36,900.00 75,222.00 165,790.03 30,512.00 30,512.00 1,840.00 1,840.00 75,000.00 44,144.38 102,077.11 23.796 56.211 38.126 23.007 42.414 11,430.65 2,272.67 12,374.85 1,200.00 1,000.00 53,895.22 50,100.00 33.661 M2727 24.207 519,084.97 100.000 56.948 1,391.00 100.000 85.064 17,922.89 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 135 MUD 1 General Fund Account Description 1 1 135-55135-010-001 Lab Analysis for PID Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 80.00 467.70 23.385 1,532.30 Page 6 Subtotal: 2,000.00 2,000.00 80.00 467.70 23.385 1,532.30 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 80.00 467.70 23.385 1,532.30 Department number: Water 5,506,929.00 5,506,929.00 425,037.34 1,367,856.82 24.839 4,139,072.18 glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 135-50010-020-000 135-50016-020-000 135-50017-020-000 135-50020-020-000 135-50026-020-000 135-50027-020-000 135-50028-020-000 135-50029-020-000 135-50030-020-000 135-50035-020-000 135-50040-020-000 135-50045-020-000 135-50060-020-000 135-50070-020-000 FSubtotal: 135-55005-020-000 Engqinee ing 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 3,000.00 20.000 12,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 13,090.25 28,715.17 32.631 59,284.83 135-55081-020-000 Mainten & Repairs Collections 10,000.00 10,000.00 1,101.29 15,378.45 153.785 5,378.45- 135-55085-020-000 Generator Meant. and Repair 10,000.00 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 278.75 682.98 17.075 3,317.02 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 72.87 1,932.95 24.162 6,067.05 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 504.68 16.823 2,495.32 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 87.50 262.50 17.500 1,237.50 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 12,210.28 32,786.78 32.787 67,213.22 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 2,657.31 12,716.45 31.791 27,283.55 Salaries & Wages 441,799.00 441,799.00 31,950.85 119,177.15 26.975 322,621.85 Overtime 33,000.00 33,000.00 1,965.55 8,065.27 24.440 24,934.73 Longevity 8,035.00 8,035.00 6,872.50 85.532 1,162.50 Certification 9,000.00 9,000.00 650.00 2,550.00 28.333 6,450.00 Retirement 45,531.00 45,531.00 3,200.84 14,183.59 31.152 31,347.41 Medical Insurance 104,858.00 104,858.00 7,738.24 26,051.83 24.845 78,806.17 Dental Insurance 5,817.00 5,817.00 447.50 1,538.52 26.449 4,278.48 Vision Insurance 948.00 948.00 69.74 250.69 26.444 697.31 Life Insurance & Other 4,500.00 4,500.00 376.31 1,390.36 30.897 3,109.64 Social Security Taxes 30,494.00 30,494.00 1,988.22 7,951.71 26.076 22,542.29 Medicare Taxes 7,132.00 7,132.00 464.99 1,859.66 26.075 5,272.34 Unemployment Taxes 1,260.00 1,260.00 34.56 34.56 2.743 1,225.44 Workman's Compensation 15,373.00 15,373.00 1,110.20 4,440.80 28.887 10,932.20 Pre-emp Physicals/Testing 400.00 400.00 400.00 Employee Relations 300.00 300.00 300.00 7.00 194,366.64 Page 7 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 684.87 2,270.53 45.411 2,729.47 135-60020-020-000 Electricity 160,067.00 160,067.00 12,730.12 47,873.47 29.908 112,193.53 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 111.00 37.000 189.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 440.00 1,910.85 38.294 3,079.15 135-60090-020-000 Safety Program 1,000.00 1,000.00 109.14 10.914 890.86 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 4.13 360.84 23.355 1,184.16 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 10,088.02 67.253 4,911.98 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 5,000.00 glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Subtotal: r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 625.22 2,960.40 23.683 9,539.60 135-65010-020-000 Uniforms 5,495.00 5,495.00 3,507.93 63.839 1,987.07 135-65030-020-000 Chemicals 20,000.00 20,000.00 3,047.71 9,868.27 49.341 10,131.73 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 4,994.00 28.537 12,506.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 1,088.92 90.743 111.08 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 2,830.97 10,837.36 54.187 9,162.64 Lawn Equipment & Maintenance 14,000.00 14,000.00 14,000.00 Interfund Transfer Out -Tax I&S 114,563.00 114,563.00 10,414.81 41,659.24 36.364 72,903.76 Interfund Transfer Out -Rev I&S 673,867.00 673,867.00 61,260.70 245,042.20 36.364 428,824.80 Interfund Transfer Out -Reserve 125,187.00 125,187.00 5,750.00 23,000.00 18.373 102,187.00 Interfund Transfer Out 180,000.00 180,000.00 180,000.00 Furniture/Equipment < $5000 2,000.00 2,000.00 190.00 9.500 1,810.00 1,310,669.00 91,284.63 372,615.29 28.429 938,053.71 135-69005-020-000 Capital Outlays 530,500.00 530,500.00 51,656.24 145,872.09 27.497 384,627.91 135-69008-020-000 Short Term Debt -Principal 79,133.00 79,133.00 59,604.74 59,604.74 75.322 19,528.26 135-69009-020-000 Short Term Debt -Interest 11,277.00 11,277.00 6,122.03 6,122.03 54.288 5,154.97 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 130,000.00 130,000.00 100.000 Subtota. - 750,910.00 3.01 341,598.86 -91 409,311.14 Program number: 3,157,421.00 6.79 1,037,817.63 IIIIIIIIA 2,119,603.37 Department number: Wastewater 3,157,421.00 6.79 1,037,817.63 119,603.3U Page 8 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 1/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 1.99 Program: YTD Total 7.96 % of Remaining Budget Budget 26.533 22.04 Page 9 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 5.72 675.00 176.28 90.000 13.560 150.00 75.00 1,123.72 4,000.00 5,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 5.72 851.28 6.449 12,348.72 Program number: 13,230.00 13,230.00 7.71 859.24 6.495 12,370.76 L Department number: Board of Directors 13,230.00 13,230.00 7.71 859.24 6.495 12,370.76 glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 628,298.00 628,298.00 30,152.71 119,116.36 18.959 509,181.64 135-50010-030-000 Overtime 2,000.00 2,000.00 4.75 16.57 .829 1,983.43 135-50016-030-000 Longevity 2,208.00 2,208.00 2,207.50 99.977 .50 135-50020-030-000 Retirement 58,554.00 58,554.00 2,792.56 12,732.78 21.745 45,821.22 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 6,345.77 22,812.20 18.339 101,581.80 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 349.75 1,268.95 19.631 5,195.05 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 51.68 197.99 19.129 837.01 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 347.91 1,291.54 28.701 3,208.46 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 1,729.08 7,067.51 18.022 32,147.49 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 404.39 1,652.92 18.023 7,518.08 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 30.16 30.16 2.094 1,409.84 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 104.82 419.28 23.621 1,355.72 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 3,078.10 38.476 4,921.90 Page 10 42,313.58 171, 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleanin7 Services Professional Outside Services Utility Billing Contract 135-60005-030-000 Telephone 135-60010-030-000 Communications/Mobiles 135-60020-030-000 Electricity/Gas 135-60025-030-000 Water 135-60035-030-000 Postage 135-60040-030-000 Service Charges & Fees 135-60050-030-000 Bad Debt Expense 135-60055-030-000 Insurance 135-60066-030-000 Publications/Books/Subscripts 135-60070-030-000 Dues & Memberships 135-60075-030-000 Meetings 135-60079-030-000 Public Education 135-60080-030-000 Schools & Training 135-60100-030-000 Travel & per diem 135-60110-030-000 Physicals/Testing 135-60115-030-000 Elections 135-60125-030-000 Advertising 2,500.00 2,500.00 134,681.00 134,681.00 135,000.00 135,000.00 15,000.00 15,000.00 10,000.00 10,000.00 10,000.00 10,000.00 65,600.00 65,600.00 9,000.00 9,000.00 23,680.00 23,680.00 4,000.00 4,000.00 6,879.00 6,879.00 1,500.00 1,500.00 30,000.00 30,000.00 67,000.00 67,000.00 1,500.00 1,500.00 84,000.00 84,000.00 1,000.00 1,000.00 6,000.00 6,000.00 400.00 400.00 6,000.00 6,000.00 6,850.00 6,850.00 3,545.00 3,545.00 200.00 200.00 51,870.09 125,274.22 93.016 20,788.70 54,824.49 40.611 110.00 1,165.00 7.767 869.06 2,607.18 26.072 775.12 2,474.81 27.498 1,669.83 6,125.59 25.868 237.75 951.81 23.795 690.43 1,282.43 18.643 56.40 241.17 16.078 1,930.85 6,806.80 22.689 5,286.16 26,018.83 38.834 3,415.53 24,431.70 29.085 125.00 12.500 80.00 4,166.55 69.443 61.37 15.343 476.20 7.937 1,152.71 16.828 8.25 695.14 19.609 43.01 9,406.78 80,175.51 13,835.00 10,000.00 7,392.82 65,600.00 6,525.19 9 , 17,554.41 3,048.19 5,596.57 1,258.83 23,193.20 40,981.17 1,500.00 59,568.30 875.00 1,833.45 338.63 5,523.80 5,697.29 2,849.86 200.00 43.01- 2,500.00 glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 2,500.00 2,500.00 135-65010-030-000 Uniforms 2,050.00 2,050.00 135-65055-030-000 Hardware 26,485.00 26,485.00 135-65085-030-000 Office Supplies 6,000.00 6,000.00 135-65090-030-000 Printer Supplies & Maintenance 3,500.00 3,500.00 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 135-65105-030-000 Printing 2,500.00 2,500.00 135-69005-030-000 Capital Outlays 195,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 Program number: Department number: Administration 195,000.00 4,000.00 ,000.00 ,712.00 .712.00 24.00 96.00 7.453 13,399.20 72,674.31 188.73 3,235.24 1,866.47 1,175.74 2,396.62 1,364.47 7,498.33 241.68 1,037.66 241.68 131,731.90 131,731.90 1,037.66 439,447.86 439,447.86 12.215 31.108 59.916 25.942 24.734 24.734 1,192.00 500.00 17,000.00 2,500.00 2,050.00 23,249.76 4,133.53 3,500.00 1,603.38 2,500.00 195,000.00 2,962.34 1,337,2 1.33 Page 11 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 1 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 1/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,761.00 4,000.00 135,000.00 33,800.00 11,761.00 4,000.00 10,728.50 12,563.27 46,036.39 27,713.27 5,178.56 3,756.00 34.101 81.992 44.032 93.900 88,963.61 6,086.73 6,582.44 244.00 Page 12 ir Subtotal: ' 184,561.00 184,561.00 23,291.77 82,684.22 44.800 101,876.78 Program number: 184,561.00 184,561.00 23,291.77 82,684.22 44.800 101,876.78 Department number: Non Departmental 184,561.00 184,561.00 23,291.77 82,684.22 44.800 101,876.78 Expenditures Subtotal 10,638,853.00 10,638,853.00 874,735.51 2,928,665.77 27.528 7,710,187.23 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 236,079.77 166,399.23 -2,673.509 172,623.23- glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer -General Fund 205,000.00- 205,000.00 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtot 286, H Program number: 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00 Revenues Subtotal 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00 Page 13 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-40000-000- 670 01/02/2020 Property Taxes 671 01/03/2020 Property Taxes 672 01/06/2020 Property Taxes 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 693 01/13/2020 Property Taxes 694 01/14/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 698 01/21/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes 705 01/28/2020 Property Taxes 706 01/29/2020 Property Taxes 707 01/30/2020 Property Taxes 708 01/31/2020 Property Taxes 40000-000-000 Account: 135-40002-000-00 670 01/02/2020 Property Taxes 671 01/03/2020 Property Taxes 673 01/07/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 699 01/22/2020 Property Taxes 704 01/27/2020 Property Taxes 670 01/02/2020 Property Taxes 672 01/06/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 1/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes (134,871.00) Budgeted (300.00) Budgeted Property Taxes/P & I (69,669.73) (14,470.64) Remaining 89 % Used 40.14 (183.01) Remaining 39 % Used (136.34) (2,668.76) (72,338.49) (1,706.26) (74,044.75) (1,407.36) (75,452.11) (2,650.28) (78,102.39) (2,508.04) (80,610.43) (691.96) (81,302.39) (1,266.76) (82,569.15) (968.05) (83,537.20) (522.02) (84,059.22) (2,845.58) (86,904.80) (948.00) (87,852.80) (1,289.49) (89,142.29) (620.39) (89,762.68) (1,327.25) (91,089.93) (1,196.92) (92,286.85) (9,477.64) (101,764.49) (2,541.87) (104,306.36) (11,661.77) (115,968.13) (1,513.18) (117,481.31) (1,424.56) (118,905.87) (1,494.49) (120,400.36) (2.17) (.43) (1.68) (4.99) (133.88) (11.36) (2.62) 37.97 37.54 35.86 30.87 (103.01) (114.37) (116.99) (6.74) (143.08) (.86) (143.94) Page 5 Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes 5-40015-001.1 Account: 135-40025-000-000 J Account: 135-40025-000-000 AMM Property Taxes/P & I (300.00) Budgeted PID Surcharges PID Surcharges Totals: (136.34) (.38) (144.32) GL (.21) (144.53) GL (1.68) (146.21) GL (2.56) (148.77) GL (32.20) (180.97) GL (.12) (181.09) GL (.08) (181.17) GL (1.80) (182.97) GL (.03) (183.00) GL (.65) (183.65) GL (.50) (184.15) GL (115.85) Remaining 61 % Used (164,253.00) Budgeted Account: 135- 511 01/06/2020 UB 01/06/2020 Bill adjustment 664 01/31/2020 UB 01/31/2020 Billing .00 .00 (164,253.00) Remaining 0 % Used UB20200106-20200106 User: UB20200131-20200131 User: (1,214,983.21) 34.11 (1,214,949.10) (308,187.93) (1,523,137.03) UB UB Account: 135 (6,486,623.00) Budgeted (4,963,485.97) Remaining 23 % Used Account: 135-47005-00 Sewe 511 01/06/2020 UB 01/06/2020 Bill adjustment UB20200106-20200106 User: 664 01/31/2020 UB 01/31/2020 Billing UB20200131-20200131 User: (739,527.31) 43.00 (255,776.19) (739,484.31) (995,260.50) UB UB Account: 135-47005-000-000 (3,503,885.00) Budgeted (2,508,624.50) Remaining 28 % Used Account: :- - - Penalt 526 01/07/2020 UB 01/07/2020 Penalty removal UB20200107-20200107 User: 606 01/20/2020 UB 01/20/2020 Penalty removal UB20200120-20200120 User: 617 01/21/2020 UB 01/21/2020 Penalties UB20200121-20200121 User: (26,629.05) 108.64 40.34 (9,257.00) (26,520.41) (26,480.07) (35,737.07) UB UB glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 636 01/27/2020 UB 01/27/2020 Penalty removal UB20200127-20200127 User: 650 01/30/2020 UB 01/30/2020 Penalty Removal UB20200130-20200130 User: 652 01/30/2020 UB 10/30/2020 Penalty removal UB20200130-20200130 User: (26,629.05) 397.35 (35,339.72) UB 256.10 (35,083.62) UB 16.76 (35,066.86) UB Account: 135-47025-000-000 ■ Penalties Totals: (8,437.81) (35,066.86) ** (112,608.00) Budgeted (77,541.14) Remaining 31 % Used Account: 135-47030-000-000 Service Chargee 541 01/02/2020 UB 01/02/2020 NSF Check UB20200102-20200102 User: 521 01/07/2020 UB 07/07/2020 Disconnect Fees UB20200107-20200107 User: 575 01/13/2020 UB 01/13/2020 DF adjustment UB20200113-20200113 User: 619 01/21/2020 UB 01/21/2020 NSF Check UB20200121-20200121 User: 620 01/22/2020 UB 01/22/2020 NSF Check UB20200122-20200122 User: 624 01/22/2020 UB 01/22/2020 NSF Check UB20200122-20200122 User: (5,350.00) (25.00) (5,375.00) UB (1,350.00) (6,725.00) UB 50.00 (6,675.00) UB (25.00) (6,700.00) UB (25.00) (6,725.00) UB (25.00) (6,750.00) UB Account: 135-47030-000-000 Service Charges Totals: (1,400.00) (6,750.00) ** (15,150.00) Budgeted (8,400.00) Remaining 45 % Used Account: 135-47035-000-000 Plumbing Inspections 654 01/02/2020 Permits 25 KATIE LANE 654 01/02/2020 Permits 27 KATIE LANE 655 01/02/2020 permits 3 655 01/02/2020 permits 32 KATIE LANE 655 01/02/2020 permits 3 687 01/05/2020 Permits -25/27 Katie Lane 25 Katie Lane 687 01/05/2020 Permits -25/27 Katie Lane 27 Katie Lane (1,800.00) (50.00) (1,850.00) Drees Homes CR (50.00) (1,900.00) DREES HOMES CR (50.00) (1,950.00) DREES HOMES CR (50.00) (2,000.00) DREES HOMES CR 50.00 (1,950.00) DREES HOMES CR (50.00) (2,000.00) Drees Homes CR (150.00) (2,150.00) Drees Homes CR Account: 135-47035-000-000 Plumbing Inepectione Totals: 1.1 (350.00) (2,150.00) ** (750.00) Budgeted 1,400.00 Remaining 287 % Used Account: 135-47045-000-000 Sewer Inspections 654 01/02/2020 Permits 654 01/02/2020 Permits 655 01/02/2020 permits 655 01/02/2020 permits 655 01/02/2020 permits 687 01/05/2020 Permits -25/27 Katie Lane 687 01/05/2020 Permits -25/27 Katie Lane 25 KATIE LANE 27 KATIE LANE 3 32 KATIE LANE 3 25 Katie Lane 27 Katie Lane (400.00) (150.00) (150.00) (150.00) (150.00) 150.00 (150.00) (50.00) (550.00) Drees Homes (700.00) DREES HOMES (850.00) DREES HOMES (1,000.00) DREES HOMES (850.00) DREES HOMES (1,000.00) Drees Homes (1,050.00) Drees Homes CR CR CR CR CR CR CR Account: 135-47045-000-000 Sewer Inspections Totals: (650.00) (1,050.00) ** (2,500.00) Budgeted (1,450.00) Remaining 42 % Used glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 1/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 8 Check Source Number 654 01/02/2020 Permits 654 01/02/2020 Permits 655 01/02/2020 permits 655 01/02/2020 permits 655 01/02/2020 permits 25 KATIE LANE 27 KATIE LANE 3 32 KATIE LANE 3 (5,355.28) (353.00) (353.00) (343.00) (353.00) 343.00 (5,708.28) Drees Homes (6,061.28) DREES HOMES (6,404.28) DREES HOMES (6,757.28) DREES HOMES (6,414.28) DREES HOMES CR CR CR CR CR Account: 135-47070-000-000 TCCC Effluent Charges 664 01/31/2020 UB 01/31/2020 Billing UB20200131-20200131 User: (15,048.80) (19.20) (15,068.00) UB Account: 135-47070-000-000 TCCC Effluent Charges Totals: (19.20) (15,068.00) ** (50,000.00) Budgeted (34,932.00) Remaining 30 5 Used Account: 135-49011-000-000 , Interest Income 724 01/31/2020 724 01/31/2020 724 01/31/2020 Bank Interest- Bank Interest- Bank Interest- January (31,542.78) January January (1,238.68) (1,066.75) (8,090.87) (32,781.46) (33,848.21) (41,939.08) GL GL GL Account: 135-49011-000-000 ■ ' Interest Income Totals: (10,396.30) (41,939.08) ** (120,000.00) Budgeted (78,060.92) Remaining 35 5 Used Account: 135-49016-000-000 Cell Tower Revenue (3,536.43) .00 (3,536.43) Account: 135-49016-000-000 Cell Tower Revenue Totals: .00 (3,536.43) ** (14,146.00) Budgeted (10,609.57) Remaining 25 % Used Account: 135-49018-000-000 Building Rent Income 733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User: (1,749.99) (583.33) (2,333.32) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 5 Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (13,000.00) Budgeted (13,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 654 01/02/2020 Permits 654 01/02/2020 Permits 655 01/02/2020 permits 655 01/02/2020 permits 655 01/02/2020 permits 25 KATIE LANE 27 KATIE LANE 3 32 KATIE LANE 3 (5,355.28) (353.00) (353.00) (343.00) (353.00) 343.00 (5,708.28) Drees Homes (6,061.28) DREES HOMES (6,404.28) DREES HOMES (6,757.28) DREES HOMES (6,414.28) DREES HOMES CR CR CR CR CR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 687 01/05/2020 Permits -25/27 Katie Lane 687 01/05/2020 Permits -25/27 Katie Lane 25 Katie Lane 27 Katie Lane (5,355.28) (353.00) (6,767.28) Drees Homes (353.00) (7,120.28) Drees Homes CR CR Accal1111035-4907 Oversize Meter Reimbursement Totals: '0.28) ** (12,691.00) Budgeted (5,570.72) Remaining Account: 135-49900-000-000 Miscellaneous Income 680 01/10/2020 Rfd of deposit for portable me UB20200110-20200110 User: 664 01/31/2020 UB 01/31/2020 Billing UB20200131-20200131 User: Account: 135-49900-000-000 Miscellaneous Income (7,000.00) Budgeted 56 % Used (7,922.02) (.30) (7,922.32) UB (231.22) (8,153.54) UB 1,153.54 Remaining 116 % Used (8,153.54) ** Department Totals: (2,762,266.54) ** (638,655.74) Monthly Total (10,645,077.00) Budgeted (7,882,810.46) Remaining 26 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 513 01/10/2020 MUD Payroll 1/10/2020 Salaries & Wages 611 01/24/2020 MUD Payroll 1/24/2020 Salaries & Wages 78,619.24 12,900.38 91,519.62 PR 12,900.37 104,419.99 PR Account: 135-50005-010-000 Salaries & Wages Totals: 25,800.75 104,419.99 ** 350,267.00 Budgeted 245,847.01 Remaining 30 % Used Account: 135-50010-010-000 Overtime 513 01/10/2020 MUD Payroll 1/10/2020 Overtime 5,390.37 981.83 6,372.20 PR 611 01/24/2020 MUD Payroll 1/24/2020 Overtime 1,275.48 7,647.68 PR Account: 135-50010-010-000 Overtime Totals: 2,257.31 7,647.68 ** 17,000.00 Budgeted 9,352.32 Remaining 45 % Used Account: 135-50016-010-000 Longevity 5,082.50 .00 5,082.50 Account: 135-50016-010-000 Longevity Totals: .00 5,082.50 ** 3,920.00 Budgeted (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 611 01/24/2020 MUD Payroll 1/24/2020 Certification 1,225.00 425.00 1,650.00 PR Account: 135-50017-010-000 Certification Totals: 425.00 1,650.00 ** 5,400.00 Budgeted 3,750.00 Remaining 31 5 Used Account: 135-50020-010-000 Retirement 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Retirement Retirement 9,435.00 1,285.49 10,720.49 PR 1,352.04 12,072.53 PR Account: 135-50020-010-000 Retirement Totals: 2,637.53 12,072.53 ** 34,863.00 Budgeted 22,790.47 Remaining 35 % Used Account: 135-50026-010-000 Medical Insurance 513 01/10/2020 MUD Payroll 1/10/2020 Medical Insurance 13,928.54 611 01/24/2020 MUD Payroll 1/24/2020 Medical Insurance 2,612.55 16,541.09 PR 2,612.49 19,153.58 PR Account: 135-50026-010-000 Medical Insurance Totals: 5,225.04 19,153.58 ** 84,326.00 Budgeted 65,172.42 Remaining 23 s Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOunt: 135-50027}0- ental IneuI 513 01/10/2020 MUD Payroll 1/10/2020 Dental Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Dental Insurance Account: - Dental Ineuranc Totals: 4,725.00 Budgeted 3,560.15 Remaining Account: 135-50028-010-000 Vision Insurance 513 01/10/2020 MUD Payroll 1/10/2020 Vision Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Vision Insurance Account: 135-50028-01C1 Vision Insurance Totals: 767.00 Budgeted 847.92 158.47 1,006.39 PR 158.46 1,164.85 PR 1 25 % Used 139.75 24.10 163.85 PR 24.08 187.93 PR 579.07 Remaining 25 % Used Life Insurance & Other 432 01/01/2020 Payroll Benefits January 452 01/01/2020 Payroll Benefits January 646 01/29/2020 January A/P Employee Benefits Employee LTD & STD caf 125 -December 871.12 200.64 1,071.76 Humana Inc 132.01 1,203.77 METLIFE GROUP BENEFITS 20.00 1,223.77 BenefitMall 6035 AP 6042 AP 6128 AP Account: 135-50029-010-000 Life Insurance & Other Totals: Account: 135-50030-010-000 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Account: 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 3,132.00 Budgeted 1,908.23 Remaining 39 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social S- 23,348.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes Account: Medicare Taxe, 5,461.00 Budgeted Account: 135-50 513 01/10/2020 MUD Payroll 1/10/2020 16,071.24 Unemployment Taxes Remaining 3,759.20 Remaining 5,538.84 1,295.35 16.68 31 848.22 889.70 Used 6,387.06 7,276.76 198.38 1,493.73 208.07 1,701.80 31 % Used 13.88 30.56 PR PR PR PR PR glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Department: 10 Water JE Detail Description/Comment 611 01/24/2020 MUD Payroll 1/24/2020 Unemployment Taxes Account: 135-50040-010-8 Unemployment Taxes 1,080.00 Budgeted Account: 135-50045-010-00 Workman's Compensation 69 01/01/2020 Insurance/Wrk Comp Expense Jan Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 1/2020 Beginning Balance Totals: 1,034.84 Remaining Account: 135-50045-010-006 Compensation 11,850.00 Budgeted 8,764.04 Remaining Account: 135-50060-010-000 Pre-emp Physicals/Testing Account: 135-50060-010-000 * Pre-emp Physicals/Testing Tota 400.00 Budgeted 400.00 Remaining Employee Relations Account: 135-50070-010-000 Account: 135-50070-010-000 Account: 135-55005-010-000 Account: 135-55005-010-000 Account: 135-55080-010-000 ■ 596 01/17/2020 January A/P 596 01/17/2020 January A/P 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 646 01/29/2020 January A/P 646 01/29/2020 January A/P 723 01/31/2020 January A/P Employee Relations Totals: 300.00 Budgeted 300.00 Remaining Engineering Engineering Totals: 20,000.00 Budgeted 20,000.00 Remaining Maintenance & Repairs masin break repair -Inverness & water clamps door handle for breakroom paint, cement, tape antenna @ TW Ring Tank blue marking flags parts 16.68 2,314.47 13,919.78 Program: Transaction Detail 14.60 4 % Used 26 % Used O % Used O % Used 28 771.49 .00 .00 .00 0 % Ueed Transaction Vendor Name Detail (SUBTOTAL) 45.16 3,085.96 .00 .00 .00 4,375.00 18,294.78 464.00 18,758.78 14.09 18,772.87 157.87 18,930.74 1,965.30 20,896.04 100.00 20,996.04 180.00 21,176.04 REY-MAR CONSTRUCTION Core & Main LP AMAZON.COM*AG9SJ5XM3 THE HOME DEPOT 86581 DHS AUTOMATION, INC Core & Main LP Core & Main LP Page 12 Check Source Number PR GL 6115 AP 6094 AP PC PC 6132 AP 6130 AP AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135 Account: 135-55085-010-000 Account: 135-55085-010-000 Trophy Club MUD No.1 Page 13 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 1/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Maintenance & Repairs 100,000.00 Budgeted 78,823.96 Remaining Generator Maint. and Repair Generator Maint. and Repair Totals: 3,000.00 Budgeted 3,000.00 Remaining Account: 135-111111111.1 Vehicle Maintenance 653 01/26/2020 PCards 12/27/2019-01/26/2020 windshield wipers 658 01/27/2020 PCards 1/27/2020 trailer wire, connector Account: 135-55090-010-000 Account: 135-55105-010-000 Account: 135-55105-010-000 Vehicle Maintenance Totals: 5,000.00 Budgeted 21 % Ueed .00 0 % Used .00 379.24 39.98 419.22 AUTOZONE #4206 PC 22.43 441.65 ROANOKE AUTO SUPPLY LT PC 4,558.35 Remaining 9 % Used ■ Maintenance-Backhoe/SkidLoader 920.37 Maintenance-Backhoe/SkidLoader Totals: i 3,500.00 Budgeted 2,579.63 Remaining 26 % Used Account: 135-55120-010-000 - Cleanin 646 01/29/2020 January A/P Janitorial svc-December Account: 135-55120-010-000 Cleaning Services otals: 1,000.00 Budgeted 737.50 Remaining Account: 135-55135-010-000 596 01/17/2020 January A/P Account: 135-55135-010-000 Account: 135-6' 597 01/20/2020 January A/P Lab Analysis water samples Lab Analysis 7,500.00 Budgeted 6,152.30 Remaining cell phones -January 175.00 .00 920.37 87.50 26 % Ueed 262.50 MEMBER'S BUILDING MAINTENANCE 6144 AP 1,147.70 200.00 1,347.70 TARRANT CTY PUBLIC HEALTH LAB 6116 AP 1,624.35 18 % Used 424.30 2,048.65 VERIZON WIRELESS 6124 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accair Account: Communications/Mobiles 5,000.00 Budgeted Electric 2,951.35 Remaining 41 % Used 598 01/20/2020 January A/P Electricity 12/10-1/10 Electricity Totals: 125,677.00 Budgeted 86,350.17 Remaining Account: 135-60066-010-000 lir Publications/Books/Subscripts Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining Account: 135-60070-010-000 Dues & Memberships Account: 135-60070-010-00 Dues & Memberships 500.00 Budgeted Account: 135-60080-010- choole & Traini 653 01/26/2020 PCards 12/27/2019-01/26/2020 Account: 135-60080-0 Account: 135-60090-01 Account: 135-60090-010-000 Account: 135-60100-010-000 500.00 Remaining Clayton Water License 7,426.00 Budgeted Safety Program Safety Program 400.00 Budgeted Travel & per diem 7,020.00 Remaining 33,423.43 5,903.40 295.00 31 % Used 0 % Used 0 % Used 2,048.65 ** 39,326.83 HUDSON ENERGY SERVICES, LLC 6104 AP .00 .00 00 .00 .00 111.00 5 % Used 406.00 .00 .00 400.00 Remaining 0 % Used .00 .00 TCEQ EPAYMENT PC glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 1/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 15 Check Source Number Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 2,845.00 Budgeted 2,845.00 Remaining 0 5 Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 5 Used Account: 135-60135-010-000 TCEQ Fees & Permits 646 01/29/2020 January A/P TIER 2 Submittal 14,207.15 50.00 14,257.15 TX COMMISSION ENVIRONMENTAL QU 6154 AP Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 50.00 14,257.15 ** 63,000.00 Budgeted 48,742.85 Remaining 23 % Used Account: 135-60150-010-000 Wholesale Water 651 01/30/2020 January A/P wholesale water 350,392.70 118,562.59 468,955.29 CITY OF FORT WORTH 6129 AP Account: 135-60150-010-000 Wholesale Water Totals: 118,562.59 468,955.29 ** 2,714,710.00 Budgeted 2,245,754.71 Remaining 17 5 Used Account: 135-60245-010-000 M Miscellaneous Expenses .00 .00 Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 462.00 .00 462.00 Account: 135-60280-010-000 Property Maintenance Totals: .00 462.00 ** 3,000.00 Budgeted 2,538.00 Remaining 15 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account Trophy Club MUD No.1 Page 16 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 1/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 14,750.00 Remaining LInterfund Transfer Out -Rev I&S 645 01/30/2020 TexPool Transfers January TexPool O&M to 16Swift Rev I&S 645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S Account: 135-603S1 Interfund Transfer Out - 527,381.00 Budgeted 335,606.04 143,831.22 Remaining 0 % Ueed 25,047.72 168,878.94 22,896.02 36 % Used 191,774.96 GL GL Acco:ont: 115-60133-010-000 Interfund 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bond Resevr AccouR r Out -Reserve Tota 55,193.00 Budgeted 36,793.00 Remaining 13,800.00 4,600.00 18,400.00 GL 33 % Ueed Account: 135-60334-010-000 Interfund Transfer Out Account: 135-60334-010-000 Account: 135-60360-010-000 Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-010-000 Account: 135-65005-010-000 640 01/24/2020 Fuel Furniture/Equipment < $5000 .00 .00 0 % Ueed 561.72 .00 561.72 Furniture/Equipment < $5000 Totals: .00 2,500.00 Budgeted 1,938.28 Remaining 22 % Ueed AIL 1 & Lube Fuel -JAN 2,428.93 1,140.42 3,569.35 US Bank Voyager Fleet Systeme 6155 AP Account: 135-65005-010-000 1,140.42 15,000.00 Budgeted 11,430.65 Remaining 24 % Used Account: 135-65010-010-000 2,917.33 .00 2,917.33 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 1/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 17 Check Source Number Account: 135-65010-010-000 Uniforms Totals: .00 2,917.33 ** MIL 5,190.00 Budgeted 2,272.67 Remaining 56 5 Used Account: 135-65030-010-000 Chemical= 596 01/17/2020 651 01/30/2020 723 01/31/2020 January A/P January A/P January A/P testing supplies chlorine Testing supplies 4,865.04 977.77 558.40 1,223.94 5,842.81 6,401.21 7,625.15 HACH COMPANY DPC INDUSTRIES, INC HACH COMPANY 6103 6133 AP AP AP Account: 135-65030-010-000 ` Chemicals IP Totals: 2,760.11 7,625.15 ** 20,000.00 Budgeted 12,374.85 Remaining 38 % Used Account: 135-65035-010-000 Small Tools .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** M 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 596 01/17/2020 596 01/17/2020 January A/P January A/P meters meters 8,875.28 2,970.00 4,259.50 11,845.28 16,104.78 ATLAS UTILITY SUPPLY ATLAS UTILITY SUPPLY CO. CO. 6092 6092 AP AP Account: 135-65050-010-000 Meter Expense Totals: 7,229.50 16,104.78 ** 70,000.00 Budgeted 53,895.22 Remaining 23 5 Used Account: 135-65053-010-000 Meter Change Out Program 596 01/17/2020 January A/P meter heads 36,900.00 36,900.00 ATLAS UTILITY SUPPLY CO. 6092 AP Account: 135-65053-010-000 Meter Change Out Program Totals: 36,900.00 36,900.00 ** 87,000.00 Budgeted 50,100.00 Remaining 42 5 Used Account: 135-69005-010-000 Capital Outlays glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Detailed Accounting Trial Balance Page 18 596 01/17/2020 January A/P well #1 646 01/29/2020 January A/P LS upgrades FY 19 646 01/29/2020 January A/P easement 90,568.03 58,645.00 9,125.00 7,452.00 149,213.03 MILLICAN WELL SERVICE, LLC 158,338.03 DHS AUTOMATION, INC 165,790.03 Jackson Walker LLP 6111 AP 6132 AP 6138 AP Account: 135 Capital Outlays Totals: 684,875.00 Budgeted 519,084.97 Remaining 24 % Used Account: 135-69008-010-000 Alb Short Term Debt -Principal 646 01/29/2020 January A/P Vaccon P & I payment 30,512.00 Account: 135-69008-010-000 Short Term Debt -Principal 30,512.00 Budgeted Account: 135-69009-010-000 IlLriferm Debt -Interest 646 01/29/2020 January A/P Vaccon P & I payment Account: 135-69009-010-000 Totals: .00 Remaining Short Term Debt -Interest Totals: 3,231.00 Budgeted 1,391.00 Remaining 100 Used 57 % Used 1,840.00 1,840.00 30,512.00 FIRST FINANCIAL BANK 1,840.00 FIRST FINANCIAL BANK 6134 AP 6134 AP Account: 135-69195-010-000 Gasb34/Reserve for Replacement Account: 135-69195-010-000 mil Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 596 01/17/2020 January A/P 596 01/17/2020 January A/P Account: 135-69281-010-000 Water Tank Inspection Contract PID tank inspection tank contract Water Tank Inspection Contract Total 120,000.00 Budgeted 17,922.89 Remaining 75,000.00 .00 75,000.00 100 % Used 57,932.73 2,200.00 41,944.38 85 % Used 60,132.73 UTILITY SERVICE CO, INC. 6122 AP 102,077.11 UTILITY SERVICE CO, INC. 6122 AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 19 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 596 01/17/2020 January A/P water samples 387.70 80.00 467.70 TARRANT CTY PUBLIC HEALTH LAB 6116 AP A000unt: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 467.70 ** 2,000.00 Budgeted 1,532.30 Remaining 23 9 Used Department 10 Totals: 1,367,856.82 ** 425,037.34 Monthly Total 5,506,929.00 Budgeted 4,139,072.18 Remaining 25 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOUnt: 135-5000 020- Salaries & Wa 513 01/10/2020 MUD Payroll 1/10/2020 Salaries & Wages 611 01/24/2020 MUD Payroll 1/24/2020 Salaries & Wages Account :-'5nrelSalaries & Wages Totals: 441,799.00 Budgeted Account: 135-50010-020-000vertime 513 01/10/2020 MUD Payroll 1/10/2020 Overtime 611 01/24/2020 MUD Payroll 1/24/2020 Overtime Account: 135-50010-020-000 87,226.30 16,024.41 103,250.71 PR 15,926.44 119,177.15 PR 322,621.85 Remaining 27 % Used 6,099.72 1,050.62 7,150.34 PR 914.93 8,065.27 PR 33,000.00 Budgeted 24,934.73 Remaining 24 % Used Account: 135 - Account: 135-50016-020-000 Longevit 6,872.50 .00 6,872.50 Longevity Totals: 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 611 01/24/2020 MUD Payroll 1/24/2020 Certification Account: 135-50017-020-000 ertification 9,000.00 Budgeted Account: 135-50020-020-000 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Account: 135-50020-020-000 Retirement Retirement 1,900.00 650.00 6,450.00 Remaining 28 % Used Retirement 3 Totals: 45,531.00 Budgeted Account: 135 Medical Insurance 513 01/10/2020 MUD Payroll 1/10/2020 Medical Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Medical Insurance Account: 135 10,982.75 31,347.41 Remaining 31 % Used Medical Insurance Totals: 104,858.00 Budgeted 1,581.15 1,619.69 2,550.00 PR 12,563.90 14,183.59 PR PR 18,313.59 3,869.14 22,182.73 PR 3,869.10 26,051.83 PR 78,806.17 Remaining 25 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACCOunt: 135-50027020- ental InsuI 513 01/10/2020 MUD Payroll 1/10/2020 Dental Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Dental Insurance Account: -1.1 Dental Insuranc Totals: 5,817.00 Budgeted 4,278.48 Remaining Account: 135-50028-020-000 Vision Insurance 513 01/10/2020 MUD Payroll 1/10/2020 Vision Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Vision Insurance Account: 135-50028-020-000 Vision Insurance Totals: 948.00 Budgeted 1,091.02 223.77 1,314.79 PR 223.73 1,538.52 PR 26 s Used 180.95 34.87 215.82 PR 34.87 250.69 PR 697.31 Remaining 26 5 Used Life Insurance & Other 432 01/01/2020 Payroll Benefits January 452 01/01/2020 Payroll Benefits January 646 01/29/2020 January A/P Employee Benefits Employee LTD & STD caf 125 -December 1,014.05 174.57 1,188.62 Humana Inc 165.74 1,354.36 METLIFE GROUP BENEFITS 36.00 1,390.36 BenefitMall 6035 AP 6042 AP 6128 AP Account: 135-50029-020-000 Life Insurance & Other Totals: .36 Account: 135-50030-020-000 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Account: 135-50035-020-000 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 4,500.00 Budgeted 3,109.64 Remaining 31 5 Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security T 30,494.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes Account: 135-50035-020-000 Medicare Tax 7,132.00 Budgeted 22,542.29 Account: 135-50040-0 513 01/10/2020 MUD Payroll 1/10/2020 Unemployment Taxes Remaining 5,963.49 1,394.67 26 1,000.04 988.18 Used 6,963.53 7,951.71 233.88 1,628.55 231.11 1,859.66 5,272.34 Remaining 26 5 Used PR PR PR PR 17.07 17.07 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 611 01/24/2020 MUD Payroll 1/24/2020 Unemployment Taxes 17.49 34.56 PR Account: 135-50040-020-0 Unemployment Taxes Totals: 34 1,260.00 Budgeted Account: 135-50045-020-00 Workman's Compensation 69 01/01/2020 Insurance/Wrk Comp Expense Jan Account: 135-50045-020-00 s Compensation 15,373.00 Budgeted 1,225.44 Remaining 3 % Used 3,330.60 1,110.20 10,932.20 Remaining 29 % Used 4,440.80 GL Account: 135-50060-020-000 � Pre-emp Physicals/Testing .00 .00 Account: 135-50060-020-000 * Pre-emp Physicals/Testing Tota 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 Account: 135-55005-020-000 — Engineering Totals: 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 3,000.00 Account: 135-55070-020-000 Independent Labor 15,000.00 Budgeted Account: 135-5511:4 & R 523 01/07/2020 January A/P oil .00 3,000.00 12,000.00 Remaining 20 % Used 15,624.92 366.09 15,991.01 LUBRICATION ENGINEERS, INC 6088 AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date 596 01/17/2020 596 01/17/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 646 01/29/2020 646 01/29/2020 651 01/30/2020 Account: 135-55080-020-000 JE Description January A/P January A/P Pcarda 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 Pcarda 12/27/2019-01/26/2020 January A/P January A/P January A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 1/2020 JE Detail Beginning Balance Description/Comment 3 sets forks for back hoe butterfly valve Tape, pvc, adapters Nuts, washers, u post adapters, clamps floats & install for WWTP 10" flanges for RAS pumps Emergency repair -13 Heritage C Maintenance & Repairs 88,000.00 Budgeted 59,284.83 Remaining 15,624.92 Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 9,900.00 25,891.01 220.00 26,111.01 182.63 26,293.64 25.81 26,319.45 21.72 26,341.17 765.00 27,106.17 1,150.00 28,256.17 459.00 28,715.17 33 % Used RDO Equipment Co Core & Main LP THE HOME DEPOT #6581 THE HOME DEPOT #6581 THE HOME DEPOT #6581 DHS AUTOMATION, INC NORTH TEXAS PUMP CO. Sandra Stiltner 28,715.17 ** Page 23 Check Source Number 6114 AP 6094 AP PC PC PC 6132 AP 6146 AP 6150 AP ACCO : 135 -55081 -020 - Mainten & Repairs Co 523 01/07/2020 January A/P 653 01/26/2020 PCards 12/27/2019-01/26/2020 646 01/29/2020 January A/P Account: 135 Account: 135-55085-020-000 Account: 135-55085-020-000 LS twenty pvc pipes clean out shie Mainten & Repairs Collections Totals: 10,000.00 Budgeted (5,378.45) Remaining Generator Maint. and Repair Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining 14,277.16 154 % Used 646.00 14,923.16 DHS AUTOMATION, INC 337.87 15,261.03 FERGUSON ENT 1241 117.42 15,378.45 Core & Main LP .00 0 % Used .00 6082 AP PC 6130 AP Vehicle Maintenance 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 oil change oil change Air Filter, fluids Account: 135-55090-020-00 Vehicle Maintenance Totals: 4,000.00 Budgeted 3,317.02 Remaining 404.23 87.89 492.12 GIERISCH CARE 0050292 88.91 581.03 GIERISCH CARE 0050292 101.95 682.98 ROANOKE AUTO SUPPLY LT 17 % Used PC PC PC Account: Veh Maintenance Collections 653 01/26/2020 PCarde 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 Tax on oil change oil change plus tax vehicle registration Fee for Vehicle Registration 1,860.08 (27.86) 90.48 8.25 2.00 1,832.22 1,922.70 1,930.95 1,932.95 FERGUSON ENT 1241 KWIK KAR LUBE & TUNE 0 DENTON VEHREG TX.GOV*SERVICEFEE-DIR PC PC PC PC glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number Account: 135 JE Date Account: 135-55105-020-000 Account: 135-55105-020-000 JE Description Account: 135-55120-020-000 646 01/29/2020 January A/P Account: 135-55120-020-000 Account: 135-55125-020-000 596 01/17/2020 January A/P 596 01/17/2020 January A/P 646 01/29/2020 January A/P 723 01/31/2020 January A/P 734 01/31/2020 January A/P Account: 135-55125-020-000 Account: 135-55135-020-000 ' 596 01/17/2020 January A/P 596 01/17/2020 January A/P 596 01/17/2020 January A/P 596 01/17/2020 January A/P 646 01/29/2020 January A/P 646 01/29/2020 January A/P 723 01/31/2020 January A/P 723 01/31/2020 January A/P 723 01/31/2020 January A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 1/2020 JE Detail Beginning Balance Description/Comment Veh Maintenance Collectio 8,000.00 Budgeted 6,067.05 Remaining Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Totals: 3,000.00 Budgeted 2,495.32 Remaining Cleaning Services janitorial svC-December Cleaning Services 1,500.00 Budgeted Dumpster Services sludge/grit sludge haul off sludge/grit sludge/grit sludge/grit Dumpster Services 100,000.00 Budgeted Total.. 1,237.50 Remaining 67,213.22 lab testing lab testing lab testing lab trsting lab testing lab trsting lab testing lab trsting Calibrate lab scale 1"411.40,000.00 ysis 40,000.00 Budgeted Remaining 27,283.55 Remaining 504.68 Program: Transaction Detail 24 % Used 17 % Used 7a .00 Transaction Vendor Name Detail (SUBTOTAL) 504.68 175.00 87.50 262.50 MEMBER'S BUILDING MAINTENANCE 18 % Used Page 24 Check Source Number 6144 AP 20,576.50 2,573.62 23,150.12 L.H. CHANEY MATERIALS, INC. 6107 AP 2,183.02 25,333.14 L.H. CHANEY MATERIALS, INC. 6107 AP 2,505.42 27,838.56 L.H. CHANEY MATERIALS, INC. 6141 AP 2,600.90 30,439.46 L.H. CHANEY MATERIALS, INC. AP 2,347.32 32,786.78 L.H. CHANEY MATERIALS, INC. AP 10,059.14 33 % Used 32 % Used 317.40 10,376.54 230.00 10,606.54 341.55 10,948.09 241.50 11,189.59 341.55 11,531.14 241.50 11,772.64 341.55 12,114.19 241.50 12,355.69 360.76 12,716.45 OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC METTLER TOLEDO INTERNATIONAL 6113 AP 6113 AP 6113 AP 6113 AP 6148 AP 6148 AP AP AP AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 465 01/02/2020 January A/P 597 01/20/2020 January A/P Account: ..0-02 - Communications/Mobiles — PID inverted siphon cell phones -January 1,585.66 276.00 1,861.66 OMNISITE 408.87 2,270.53 VERIZON WIRELESS Communications/Mobil Totals: 5,000.00 Budgeted 2,729.47 Remaining Account: 135-60020-020-000 Electricity 596 01/17/2020 January A/P electricity 11/27-1/2 598 01/20/2020 January A/P Electricity 12/10-1/10 733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User: Account: 135-60020-020-000— Electri. 160,067.00 Budgeted 112,193.53 Remaining 45 % Used 6045 AP 6124 AP 35,143.35 624.40 35,767.75 TRI COUNTY ELECTRIC 6121 AP 12,728.09 48,495.84 HUDSON ENERGY SERVICES, LLC 6104 AP (622.37) 47,873.47 AR 30 Used Account: 135-60066-020-000 Publications/Books/Subscripts Account: 135-60066-020-000 .00 .00 Publications/Books/Subscripts Tot .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships Account: 135-60070-020-000 Account: 135 DueS & Memberships Totals: 300.00 Budgeted Schools & Training 111.00 189.00 Remaining 37 % Used 658 01/27/2020 PCards 1/27/2020 Surface water class- F. Isola Account: 135-60080-020-00 Schools & Training 4,990.00 Budgeted .00 111.00 1,470.85 440.00 Totals: 3,079.15 Remaining 38 % Used 111.00 ** 1,910.85 TEEX ECOMMERCE PC Account: 135-60090-020-000 Safety Program Account: 135-60090-020-00 109.14 Safety Program Totals: 1,000.00 Budgeted 890.86 Remaining 11 % Used .00 109.14 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 1/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 26 Check Source Number Account: 135-60100-020-000 Travel & per diem 646 01/29/2020 January A/P tolls to Austin -GM car 356.71 4.13 360.84 Texas Tollways/TxTag 6153 AP Account: 135-60100-020-000 Travel & per diem Totals: 4.13 360.84 ** 1,545.00 Budgeted 1,184.16 Remaining 23 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 10,088.02 .00 10,088.02 Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 10,088.02 ** 15,000.00 Budgeted 4,911.98 Remaining 67 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60285-020-000- Lawn Equipment & Maintenance Totals: 14,000.00 Budgeted 14,000.00 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 645 01/30/2020 TexPool Tlansfers January TexPool O&M to I&S- PID Debt Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Tot 114,563.00 Budgeted 72,903.76 Remaining Account: 135-60332 020- aterfund T -Rev I&S 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bd WWTP I&S 645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S Account1111332-019.11Interfund Transfer Ou 673,867.00 Budgeted .00 .00 0 % Used 31,244.43 10,414.81 41,659,24 GL 183,781.50 36 % Used 54,421.63 238,203,13 6,839.07 245,042.20 428,824.80 Remaining 36 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bond Resevr Account: 135-60333-020-000 Account: 135-60334-020-000 Account: 135-60334-020-000 Account: 135-60360-020-000 Account: 135-60360-020-000 Account: 135-65005-020-000 Interfund Transfer Out -Reserve Tota 125,187.00 Budgeted 102,187.00 Remaining Interfund Transfer Ou 180,000.00 Budgeted 180,000.00 Furniture/Equipment < $5000 Furniture/Equipment < $500 2,000.00 Budgeted 1,810.00 Remaining Remaining 17,250.00 190.00 18 % Used 0 10 Used Used GL GL 5,750.00 23,000.00 GL 00 .00 .00 190.00 Fuel & Lube glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 640 01/24/2020 Fuel Account: 135-65010-020-000 Account: 135-65010-020-00 Account: 135-65030-020- 596 01/17/2020 January A/P 646 01/29/2020 January A/P 734 01/31/2020 January A/P Account: 135- Account: 135-65031-020-000 Account: 135-65031-020-000 Account: 135-65035-020-000 Account: 135-65035-020-000 Account: 135-65040-020-000 Account: 135-65040-020-000 Account: 135-65045-020-000 12,500.00 5,495.00 Chemical Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 1/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Fuel -JAN Budgeted Budgeted sodium hypo sodium hypo 12.5% De foamier 20,000.00 Budgeted Chemicals Collections Chemicals Collections 17,500.00 Budgeted Small Tools 9,539.60 1,987.07 Remaining Remaining Page 28 Check Source Number 2,335.18 625.22 2,960.40 US Bank Voyager Fleet Systems 6155 AP 3,507.93 6,820.56 24 % Used 64 % Used Totals: 10,131.73 Remaining 49 % Used 4,994.00 12,506.00 Remaining 29 % Used Small Tools Totals: 1,200.00 Budgeted Safety Equipment Safety Equipment 1,200.00 Budgeted 1,200.00 Remaining 0 % Ueed 1,088.92 .00 569.00 717.50 1,761.21 3,507.93 7,389.56 Valley Solvent Company, INC 8,107.06 Valley Solvent Company, INC 9,868.27 MARYLAND BIOCHEMICAL CO, INC .00 4,994.00 .00 .00 .00 1,088.92 Totals: 111.08 Remaining 91 % Used 6123 AP 6156 AP AP Lab Supplies glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 523 01/07/2020 January A/P gloves 523 01/07/2020 January A/P lab supplies 523 01/07/2020 January A/P Lab supplies 596 01/17/2020 January A/P lab supplies 596 01/17/2020 January A/P lab supplies 653 01/26/2020 PCards 12/27/2019-01/26/2020 distilled water 8,006.39 169.20 8,175.59 LOU'S GLOVES INCORPORATED 6087 AP 1,463.76 9,639.35 IDEXX DISTRIBUTION, INC 6085 AP 458.66 10,098.01 IDEXX DISTRIBUTION, INC 6085 AP 229.33 10,327.34 IDEXX DISTRIBUTION, INC 6105 AP 505.07 10,832.41 IDEXX DISTRIBUTION, INC 6105 AP 4.95 10,837.36 TOM THUMB #1789 PC Account: 135-65045-020-000 Lab Supplies Totals: 2,830.97 10,837.36 ** 20,000.00 Budgeted 9,162.64 Remaining 54 % Used Account: 135-69005-020-000 Capital Outlays 646 01/29/2020 January A/P 646 01/29/2020 January A/P 651 01/30/2020 January A/P hoes for plants and reels hoses for plants and reels In -plant water system WWTP 94,215.85 1,074.13 187.41 50,394.70 95,289.98 Stuart Hose & Pipe 95,477.39 Stuart Hose & Pipe 145,872.09 REY-MAR CONSTRUCTION 6151 AP 6151 AP 6149 AP Account: 135-69005-020-000 Capital Outlays Totals: 51,656.24 145,872.09 ** 530,500.00 Budgeted 384,627.91 Remaining 27 % Used Account: 135-69008-020-000 Short Term Debt -Principal 646 01/29/2020 January A/P 646 01/29/2020 January A/P Camera van P & I pymnt 19,158.74 Vaccon P & I payment 40,446.00 19,158.74 FIRST FINANCIAL BANK 6134 AP 59,604.74 FIRST FINANCIAL BANK 6134 AP Account: 135-69008-020-000 Short Term Debt -Principal Totals: 59,604.74 ** 79,133.00 Budgeted 19,528.26 Remaining 75 % Used Account: 135-69009-020-000 Short Term Debt -Interest 646 01/29/2020 January A/P Camera van P & I pymnt 3,681.96 646 01/29/2020 January A/P Vaccon P & I payment 2,440.07 3,681.96 FIRST FINANCIAL BANK 6134 AP 6,122.03 FIRST FINANCIAL BANK 6134 AP Account: 135-69009-020-000 Short Term Debt -Interest Totals: 6,122.03 6,122.03 ** 11,277.00 Budgeted 5,154.97 Remaining 54 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 .00 130,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 130,000.00 ** 130,000.00 Budgeted .00 Remaining 100 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1 Department 20 Totals: 1,037,817.63 ** 294,666.79 Monthly Total 3,157,421.00 Budgeted 2,119,603.37 Remaining 33 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 31 Account: 135-50045-026-0 Workman's Compensation 69 01/01/2020 Insurance/Wrk Comp Expense Jan 5.97 Acal Workman's Compensation 30.00 Budgeted Total 22.04 Remaining 27 % Used 1.99 7.96 GL 1 Account: 135-60066-026-000 ■ Publications/Books/Subscripts Account: 135-60066-026-000 Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining .00 .00 0 % Used 111 Dues & Memberships Aocount7S.1115919.1171T Dues & Memberships Total= 750.00 Budgeted 75.00 Remaining Account: 135-60075-026-000 Meetings 653 01/26/2020 PCarde 12/27/2019-01/26/2020 candy Account: 135-60075-026-00 Meeting. 1,300.00 Budgeted 1,123.72 Remaining 675.00 170.56 .00 90 % Used 14 Used 5.72 Account: 135-60080-026-000 .00 Account: 135-60080-026-000 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem 675.00 176.28 WM SUPERCENTER #5247 .00 .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used PC Account: 135-60245-026-000 Miscellaneous Expenses glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 ** Department 26 Totals: 2,000.00 Budgeted 2,000.00 Remaining 0 % Used 7.71 Monthly Total 13,230.00 Budgeted 859.24 ** 12,370.76 Remaining 6 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOUnt: 135-5000 030- Salaries & 415 - 513 01/10/2020 MUD Payroll 1/10/2020 Salaries & Wages 611 01/24/2020 MUD Payroll 1/24/2020 Salaries & Wages 88,963.65 15,092.71 104,056.36 PR 15,060.00 119,116.36 PR Account: - Salaries & Wages Totals: 628,298.00 Budgeted 509,181.64 Remaining 19 % Used Account: 135-50010-030-000 Overtime 513 01/10/2020 MUD Payroll 1/10/2020 Overtime Account: 135-50010-030-000 Overtime 2,000.00 Budgeted 11.82 1,983.43 Remaining 1 % Used 4.75 16.57 PR Account: 135-50016-030-000 Account: 135-50016-030-00 Totals: 2,208.00 Budgeted .50 Remaining Account: 135-50020-030-00 irement 513 01/10/2020 MUD Payroll 1/10/2020 Retirement 611 01/24/2020 MUD Payroll 1/24/2020 Retirement 2,207.50 100 % Used 9,940.22 .00 2,207.50 1,398.03 1,394.53 11,338.25 12,732.78 PR PR Account: 135-50020-030-000 58,554.00 Budgeted Account: 135-50026-030-000edical ce 513 01/10/2020 MUD Payroll 1/10/2020 Medical Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Medical Insurance Account: 135-50026-030-000 45,821.22 Remaining Medical Insurance Totals: 124,394.00 Budgeted 101,581.80 Remaining 16,466.43 Account: 135 Dental Insurance M 513 01/10/2020 MUD Payroll 1/10/2020 Dental Insurance 919.20 611 01/24/2020 MUD Payroll 1/24/2020 Dental Insurance Account: 135 `Dental Insuraa. Totals: 6,464.00 Budgeted 5,195.05 Remaining 22 % Used 3,172.91 19,639.34 3,172.86 22,812.20 18 % Used 20 % Used 174.88 1,094.08 PR PR PR 174.87 1,268.95 PR glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 1/2020 JE Detail Description/Comment Page 34 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) ACCO -5002:-030- sion Ins 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Account: Vision Insurance Vision Insurance ision Insuranc> 1,035.00 Budgeted Account: 135-50029-030-000 Life Insurance & Other 432 01/01/2020 Payroll Benefits January Employee Benefits 452 01/01/2020 Payroll Benefits January Employee LTD & STD 646 01/29/2020 January A/P caf 125 -December Totals: 146.31 1 837.01 Remaining 19 % Used 25.85 172.16 25.83 197.99 943.63 176.22 1,119.85 Humana Inc 151.69 1,271.54 METLIFE GROUP BENEFITS 20.00 1,291.54 BenefitMall PR PR 6035 AP 6042 AP 6128 AP Account: 135-50029-030 4,500.00 Budgeted 3,208.46 Account: 135-50030-030-000 ity Taxes 513 01/10/2020 MUD Payroll 1/10/2020 Social Security Taxes 611 01/24/2020 MUD Payroll 1/24/2020 Social Security Taxes Remaining 5,338.43 29 Used 868.66 6,207.09 860.42 7,067.51 PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 39,215.00 Budgeted Account: 135-50035-030-000 Medicare Taxes 513 01/10/2020 MUD Payroll 1/10/2020 Medicare Taxes 611 01/24/2020 MUD Payroll 1/24/2020 Medicare Taxes Account: 135-50040-030-000 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Account: 135-50040-030-000 32,147.49 Remaining 18 % Used Medicare Taxes Totals: 9,171.00 Budgeted Unemployment Taxes Unemployment Taxes Unemployment Taxes Unemployment Taxes 1,440.00 Budgeted Account: 135-50045-03s Compens 69 01/01/2020 Insurance/Wrk Comp Expense Jan 1,248.53 7,518.08 Remaining 18 % Used 1,409.84 Remaining 314.46 203.16 1,451.69 PR 201.23 1,652.92 PR 15.09 15.09 15.07 30.16 2 % Used 104.82 419.28 PR PR GL glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number Account: 135 JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 1/2020 JE Detail Beginning Balance Description/Comment Workman's Compensation 1,775.00 Budgeted Account: 135-50060-030-000 Pre-emp Physicals/Testing Account: 135-50060-030-000 Pre-emp Physicals/Testing 500.00 Budgeted Account: 135-50070-030-000 Employee Relations Account: 135-50070-030-000 Employee Relations Account: 135-55030-030-000 596 01/17/2020 596 01/17/2020 596 01/17/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 723 01/31/2020 723 01/31/2020 734 01/31/2020 8,000.00 Budgeted Software & Support GIS development Microsoft exchange internet-January Internet internet Adobe subscription internet Annual software leaaeFY 20 Annual license fee Vision Annual License January A/P January A/P January A/P PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 January A/P January A/P January A/P 723 01/31/2020 January A/P 740 01/31/2020 January A/p 740 01/31/2020 January A/p Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 1,355.72 Remaining 500.00 Remaining 4,921.90 Remaining Software & Support 134,681.00 Budgeted 9,406.78 Remaining Independent Labor GM recruitment gm consulting -January gm consulting -January Independent Labor 135,000.00 Budgeted 80,175.51 Remaining 3,078.10 73,404.13 34,035.79 24 Used 0 % Used 38 % Used 93 % Used 41 % Used .00 .00 .00 3,078.10 9,952.61 83,356.74 494.00 83,850.74 899.00 84,749.74 42.37 84,792.11 42.37 84,834.48 36.78 84,871.26 53.91 84,925.17 16,800.00 101,725.17 22,587.00 124,312.17 962.05 125,274.22 10,000.00 10,780.00 8.70 Halff Associates, INC M3 Networks Charter Communications ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS ATT*BILL PAYMENT STW INC OpenGov, Inc STW INC 44,035.79 Strategic Government Resources 54,815.79 Carman Consulting LLC. 54,824.49 Carman Consulting LLC. Page 35 Check Source Number 6102 AP 6108 AP 6093 AP PC PC PC PC AP AP AP AP AP AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 1/2020 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) Page 36 Check Source Number 465 01/02/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 646 01/29/2020 January A/P PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 January A/P Answering service-january Telephone Answering Service phone phone Answering service -February 4,455.76 207.75 176.78 14.99 788.45 467.11 194.75 4,663.51 4,840.29 4,855.28 5,643.73 6,110.84 6,305.59 KEYSTONE PARK SECRETARIAL ATT*SILL PAYMENT RINGCENTRAL, INC ATT*BUS PHONE PMT ATT*BUS PHONE PMT KEYSTONE PARK SECRETARIAL 6037 AP PC PC PC PC 6139 AP Account: 135-55080-030-000 Maintenance & Repairs 597 01/20/2020 January A/P pest control -quarterly 1,055.00 110.00 1,165.00 Exclusive Pest Control 6100 AP Account: 135-55080-030-000 Maintenance & Repairs Totals: 110.00 1,165.00 ** 15,000.00 Budgeted 13,835.00 Remaining 8 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 646 01/29/2020 January A/P janitorial svc-December 1,738.12 869.06 2,607.18 MEMBER'S BUILDING MAINTENANCE 6144 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 2,607.18 ** 10,000.00 Budgeted 7,392.82 Remaining 26 5 Used Account: 135-55160-030-000 Professional Outside Services .00 .00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 65,600.00 Budgeted 65,600.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 596 01/17/2020 January A/P 726 01/31/2020 January A/P December billings January Billings 1,699.69 182.94 592.18 1,882.63 2,474.81 DATAPROSE DATAPROSE LLC LLC 6097 AP AP Account: 135-55205-030-000 Utility Billing Contract Totals: 775.12 2,474.81 ** 9,000.00 Budgeted 6,525.19 Remaining 27 5 Used Account: 135-60005-030-000 Telephone 465 01/02/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 646 01/29/2020 January A/P PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 January A/P Answering service-january Telephone Answering Service phone phone Answering service -February 4,455.76 207.75 176.78 14.99 788.45 467.11 194.75 4,663.51 4,840.29 4,855.28 5,643.73 6,110.84 6,305.59 KEYSTONE PARK SECRETARIAL ATT*SILL PAYMENT RINGCENTRAL, INC ATT*BUS PHONE PMT ATT*BUS PHONE PMT KEYSTONE PARK SECRETARIAL 6037 AP PC PC PC PC 6139 AP glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 37 733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User: 4,455.76 ccouut: 135-60005-030- Telephone 23,680.00 Budgeted (180.00) 6,125.59 17,554.41 Remaining 26 % Used Account: 135-60010-030-000 Communications/Mobiles 597 01/20/2020 January A/P cell phones -January 611 01/24/2020 MUD Payroll 1/24/2020 Communications/Mobiles Account: Communications/Mobile 4,000.00 Budgeted 3,048.19 Account: Electricity/Gas 596 01/17/2020 January A/P gexa energy 11/8-12/10 Account: 135-60020-030-00 Electricity/Ga= 6,879.00 Budgeted 5,596.57 Account: 135-60025-030-000 Wat. 723 01/31/2020 January A/P water -January 733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User: Account: 135-60025-030-000 1,500.00 Budgeted Account: 135-60035-030-000 Postage 596 01/17/2020 January A/P December billings 646 01/29/2020 January A/P Postage lease 726 01/31/2020 January A/P January Billings Account: 135-60035-030-000 596 01/17/2020 January A/P 596 01/17/2020 January A/P 710 01/31/2020 Pace Credit Card Fees 710 01/31/2020 Pace Credit Card Fees Remaining Remaining 714.06 592.00 1,669.83 87.75 150.00 24 % Used 690.43 19 % Used 801.81 VERIZON WIRELESS 951.81 1,282.43 TOWN OF TROPHY CLUB 184.77 112.79 297.56 TROPHY CLUB MUD (WATER BILLS) (56.39) 1,258.83 Remaining 16 % Used Postage = Totals: 30,000.00 Budgeted 241.17 AR 6124 AP PR 6120 AP AP AR 4,875.95 158.50 5,034.45 DATAPROSE LLC 6097 AP 105.96 5,140.41 FRANCOTYP-POSTALIA, INC. 6135 AP 1,666.39 6,806.80 DATAPROSE LLC AP 23,193.20 Remaining 23 % Used Service Charges & Fees Dig Tess -December Direct send fees -December 20,732.67 190.00 20,922.67 Texas Excavation Safety System 6118 AP 50.00 20,972.67 Fisery Solutions, LLC 6101 AP 4,879.37 25,852.04 GL 116.79 25,968.83 GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 723 01/31/2020 January A/P Direct send fees -January ccoun - - - Service Charges & Fees Totals: Account: 135-60050-030-000 67,000.00 Budgeted Bad Debt Expense Account: 135-60050-030-000 Bad Debt Expense 1,500.00 Budgeted Acco : 135-60055-030- 69 01/01/2020 Insurance/Wrk Comp Expense Jan 596 01/17/2020 January A/P Notary-Slaght 725 01/31/2020 TML Liability Insurance Refund Account: 135-60055-030-000 Account: 135-60066-030-000 20,732.67 50.00 26,018.83 Fisery Solutions, LLC 40,981.17 Remaining 39 % Used 1,500.00 Remaining Ias ale: 84,000.00 Budgeted 59,568.30 Remaining Publications/Books/Subscript Account: 135-60066-030-00P Publications/Books/Subscripts Totals: 1,000.00 Budgeted 875.00 Remaining 11'& & Memberahipai 658 01/27/2020 PCards 1/27/2020 GFOAT membership Accoun Account: 135-60075-030-000 Account: 135-60075-030-000 Dues & Memberships' Totals: 6,000.00 Budgeted Meetings • 21,016.17 .00 .00 0 % Used 29 % Used 6,998.39 50.00 (3,632.86) 28,014.56 28,064.56 24,431.70 AP GL VICTOR 0 SCHINNERER & CO, INC 6125 AP GL 125.00 .00 125.00 13 % Used 4,086.55 80.00 4,166.55 PAYPAL *TEMUNLEAGUE 1,833.45 Remaining 69 % Used Me. otals: 400.00 Budgeted 61.37 .00 338.63 Remaining 15 % Used 61.37 PC Account: 135-60079-030-000 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60079-030-000 Account: 135-60080-030-000 Account: 135-60080-030-000 Public Education 6,000.00 Budgeted Schools & Training Schools & Training 6,850.00 Budgeted Account: 135-60100-030- Travel & per diem 596 01/17/2020 January A/P tolls to lab Travel & per diem 3,545.00 Budgeted Account Physicals/Testing Account Physicals/Testing 200.00 Budgeted 5,523.80 Remaining 5,697.29 Remaining 2,849.86 Remaining Totals: 476.20 .00 476.20 8 % Used 1,152.71 17 % Used .00 1,152.71 686.89 8.25 695.14 NTTA 6112 AP 20 % Used 200.00 Remaining 0 % Used .00 .00 Account: 135-60115-030-000 Elections 43.01 .00 43.01 Account: 135-60115-030-000 Elections Totals: .00 Budgeted Account: 135-60125-030-000 Advertising Account: 135-60125-030-000 Advertising 2,500.00 Budgeted (43.01) Remaining 0 % Used dMa Account: 135-60235-0 596 01/17/2020 January A/P monitoring svc-jan .00 .00 2,500.00 Remaining 0 % Used 72.00 24.00 96.00 Digital Air Control, Inc 6098 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60235-03t Security 1,288.00 Budgeted Account: 135-60245-030-000 Account: 135-60245-030-000 Account: 135-60246-030-000 Account: 135-60246-030-000 Account: 135-60360-030-000 Account: 135-60360-030-000 Account: 135-65010-030-000 Account: 135-65010-030-000 Account: 135-65055-030-000 Account: 135-65055-030-000 1,192.00 Remaining 7 % Ueed Miscellaneous Expenses Miscellaneous Expenses 500.00 Budgeted General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Furniture/Equipment < $5000 Furniture/Equipment c $50: 2,500.00 Budgeted 500.00 Remaining 0 % Ueed Uniforms 2,050.00 Budgeted Hardware Hardware 26,485.00 Budgeted 2,500.00 Remaining 0 % Used 0 Used 2,050.00 Remaining 0 % Used 3,235.24 23,249.76 Remaining 12 % Used .00 .00 .00 .00 .00 .00 .00 .00 .00 3,235.24 Account: 135-65085-030-00 Office Supplies 653 01/26/2020 PCards 12/27/2019-01/26/2020 Notary Stamp 1,677.74 26.90 1,704.64 AMER ASSOC NOTARIES PC 646 01/29/2020 January A/P office supplies 161.83 1,866.47 OFFICE DEPOT, INC 6147 AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number Account: 135 JE Date JE Description Account: 135-65090-030-000 Account: 135-65090-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 1/2020 JE Detail Beginning Balance Description/Comment Office Supplies 6,000.00 Budgeted Program: Transaction Detail Transaction Vendor Name Detail (SUBTOTAL) 4,133.53 Printer Supplies & Maintenance Remaining Printer Supplies & Maintenance Totals: 3,500.00 Budgeted 3,500.00 Remaining Account: 135 Maintenance Supplies 653 01/26/2020 PCarde 12/27/2019-01/26/2020 adapter 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCarde 653 01/26/2020 PCards 653 01/26/2020 PCarde 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCarde 653 01/26/2020 PCards 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 paper products, air freshner, coffee creamer popcorn coffee tea coffee coffee coffee water filter air filters air filters batteries air filters air filter tea .- '95-030-0 Maintenance Supplies Account: 135-65105-030-000 Account: 135-65105-030-000 Account: 135-69005-030-000 33. Used 0 % Used 1,220.88 .00 .00 7.45 1,228.33 197.88 1,426.21 12.99 1,439.20 47.25 1,486.45 101.98 1,588.43 12.01 1,600.44 25.70 1,626.14 51.39 1,677.53 27.45 1,704.98 30.99 1,735.97 259.84 1,995.81 259.84 2,255.65 18.48 2,274.13 59.88 2,334.01 51.61 2,385.62 11.00 2,396.62 AMZN MRTP US*IV5L658D3 SAMSCLUB.COM AMAZON.COM*7173V4YD3 AMAZON.COM*HJ2657H73 AMZN MKTP US*017K89KQ3 AMAZON.COM*YA50Y4J73 AMAZON.COM*J45GI9G53 AMAZON.COM*E96AA3UJ3 AMAZON.COM*BE2SW1HM3 AMZN METP US*WW9HZ2AL3 AMAZON. COM*R04Y134N3 AMAZON.COM*BT0NZ5703 AMAZON.COM*CZ42N8P43 HOMEDEPOT .COM AMAZON. COM*0W2238HE3 AMAZON. COM*P33Q27R53 Page 41 Check Source Number PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC Totals: 4,000.00 Budgeted 1,603.38 Remaining Printing Priatin• 2,500.00 Budgeted 2,500.00 Remaining 60 % Used 0 Used .00 .00 .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 596 01/17/2020 January A/P 646 01/29/2020 January A/P Account: 135 Department 30 Totals: Capital Outlays 195,000.00 Budgeted 195,000.00 Remaining 0 % Used Copier Lease Installments copier lease-jan copies L Copier Lease Installments Tota 4,000.00 Budgeted 2,962.34 Remaining 0 .00 ** 795.98 165.00 960.98 TIAA COMMERCIAL FINANCE 76.68 1,037.66 RYOCERA DOCUMENT SOLUTIONS 26 % Used 439,447.86 •* 131,731.90 Monthly Total 1,776,712.00 Budgeted 1,337,264.14 Remaining 25 % Used 6119 AP 6140 AP glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 43 Account: 135-55045-039-000 Legal 596 01/17/2020 January A/P 596 01/17/2020 January A/P 596 01/17/2020 January A/P 734 01/31/2020 January A/P Westlake easement legal legal legal 35,307.89 6,198.50 2,430.00 1,050.00 1,050.00 41,506.39 WHITAKER CHALK SWINDLE 43,936.39 McLean & Howard, L.L.P. 44,986.39 McLean & Howard, L.L.P. 46,036.39 McLean & Howard, L.L.P. 6126 AP 6109 AP 6109 AP AP Account: 135-55045-039-000 Legal Totals: 10,728.50 46,036.39 ** 135,000.00 Budgeted 88,963.61 Remaining 34 % Used Account: 135-55055-039-000 Auditing 651 01/30/2020 January A/P FY 19 Audit completed work 15,150.00 12,563.27 27,713.27 LAFOLLETT & COMPANY, PLLC 6142 AP Account: 135-55055-039-000 Auditing Totals: 12,563.27 27,713.27 ** 33,800.00 Budgeted 6,086.73 Remaining 82 % Used Account: 135-55060-039-000 Appraisal 5,178.56 .00 5,178.56 Account: 135-55060-039-000 Appraisal Totals: .00 5,178.56 ** 11,761.00 Budgeted 6,582.44 Remaining 44 % Used Account: 135-55065-039-000 Tax Admin Fees 3,756.00 .00 3,756.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,756.00 ** Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 23,291.77 Monthly Total 244.00 Remaining 94 % Used 82,684.22 ** 184,561.00 Budgeted 101,876.78 Remaining 45 % Used 166,399.23 236,079.77 Monthly Total (6,224.00) Budgeted (172,623.23) Remaining ########## glpdatb2 skrolczyk 10:44 02/11/20 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 1/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Page 44 Check Source Number Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund (205,000.00) .00 (205,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept (81,420.00) .00 (81,420.00) Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: ; .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 547,320 TOTAL ASSETS 547,320 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (118,409) (19,747) TOTAL FUND BALANCE (138,156) TOTAL LIABILITIES AND FUND BALANCE 547,320 glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 743.88- 3,349.11- 3,349.11 Page 14 Subtotal: 743.88- 3,349.11- 3,349.11 Program number: 743.88- 3,349.11- 3,349.11 Department number: Revenues 743.88- 3,349.11- 3,349.11 Revenues Subtotal 743.88- 3,349.11- 3,349.11 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account 1 517-69005-020-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 1/2020 Adopted Amended Total Current Budget Budget Encumb. Month 3,792.50 Program: YTD Total 23,096.00 % of Remaining Budget Budget 23,096.00 - Page 15 Subtotal: 3,792.50 23,096.00 23,096.00 - Program number: 3,792.50 23,096.00 23,096.00 - Department number: Wastewater 3,792.50 23,096.00 23,096.00 - Expenditures Subtotal 3,792.50 23,096.00 23,096.00 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP ! 3,048.62 19,746.89 19,746.89- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (2,605.23) (743.88) (3,349.11) GL Account: 517-49011-000-000 Interest Income Totals: Department Totals: .00 Budgeted 3,349.11 Remaining 0 % Used (743.88) Monthly Total .00 Budgeted (3,349.11) ** 3,349.11 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) A000unt: 517-69005-020- 596 01/17/2020 January A/P 596 01/17/2020 January A/P Capital Outl WWTP legal WWTP Legal Account: - Capital Outlays Totals: Department 20 Totals: Fund 517 Totals: .00 Budgeted 19,303.50 1,572.50 2,220.00 (23,096.00) Remaining 0 % Used 3,792.50 Monthly Total .00 Budgeted 3,048.62 Monthly Total .00 Budgeted 20,876.00 Dubois Bryant Campbell LLP 6099 AP 23,096.00 CP&Y/WALLACE GROUP, INC. 6096 AP 23,096.00 ** (23,096.00) Remaining 0 % Used 19,746.89 (19,746.89) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 783,441 TOTAL ASSETS 783,441 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 81,691 81,691 698,648 3,102 701,750 783,441 669.42- 3,101.87- 3,101.87 Revenues Subtotal 3,101.87- 3,101.87 glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 519-49011-000-000 Interest Income 669.42- 3,101.87- 3,101.87 Page 16 Subtotal: 669.42- 3,101.87- 3,101.87 Program number: 669.42- 3,101.87- 3,101.87 Department number: Revenues 669.42- 3,101.87- 3,101.87 I Fund number: 519 2016 Rev Bond Const -SWIFT ! 669.42- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (2,432.45) (669.42) (3,101.87) GL Account: 519-49011-000-000 Interest Income Totals: Department Totals: Fund 519 Totals: .00 Budgeted 3,101.67 Remaining 0 % Used (669.42) Monthly Total .00 Budgeted (669.42) Monthly Total .00 Budgeted (3,101.87) ** 3,101.87 Remaining 0 % Used (3,101.87) 3,101.87 Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET JANUARY 2020 gli TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 552,598 INVESTMENTS 3,884,957 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,437,555 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 4,454,290 (16,735) 4,437,555 4,437,555 glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 4,071.63- 18,707.81- 18,707.81 Page 17 Subtotal: 4,071.63- 18,707.81- 18,707.81 Program number: 4,071.63- 18,707.81- 18,707.81 Department number: 4,071.63- 18,707.81- 18,707.81 Revenues Subtotal 4,071.63- 18,707.81- 18,707.81 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 520 Revenue Bond 16" Waterline Account 1 520-69005-010-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 1/2020 Adopted Amended Total Current Budget Budget Encumb. Month 4,704.93 Program: YTD Total 35,442.91 % of Remaining Budget Budget 35,442.91 - Page 18 Subtotal: 4,704.93 35,442.91 35,442.91 - Program number: 111111 4,704.93 35,442.91 35,442.91 - Department number: Water Department 4,704.93 35,442.91 35,442.91 - Expenditures Subtotal 4,704.93 35,442.91 35,442.91 - Fund number: 520 Revenue Bond 16" Waterline ! 633.30 16,735.10 16,735.10- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 724 01/31/2020 Bank Interest- January (14,636.18) 724 01/31/2020 Bank Interest- January Account: 520-490 nterest Income Totals: .00 Budgeted 18,707.81 Remaining 0 % Used (752.10) (15,388.28) GL (3,319.53) (18,707.81) GL Department Totals: (18,707.81) ** (4,071.63) Monthly Total .00 Budgeted 18,707.81 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 Capital Outlays 596 01/17/2020 January A/P Right away acquisition- 16" wa 30,737.98 4,704.93 35,442.91 Halff Associates, INC 6102 AP Account: 520-69005-010-000 Capital Outlays Totals: 4,704.93 35,442.91 ** Department 10 Totals, Fund 520 Totals: .00 Budgeted (35,442.91) Remaining 0 5 Used 4,704.93 Monthly Total .00 Budgeted 633.30 Monthly Total .00 Budgeted 35,442.91 ** (35,442.91) Remaining 0 % Used 16,735.10 (16,735.10) Remaining 0 5 Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Si TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 849,568 TOTAL ASSETS 849,568 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 803,457 46,111 849,568 849,568 glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49011-000-000 528-49142-000-000 528-49143-000-000 Interest Income Interfund transfer in -Water Interfund transfer in -WW 11,000.00- 307,049.00- 200,417.00- 11,000.00- 307,049.00- 200,417.00- 1,134.84- 4,600.00- 5,750.00- 4,711.24- 18,400.00- 23,000.00- 42.829 5.993 11.476 6,288.76- 288,649.00- 177,417.00 - Subtotal: m 518,466.00- 518,466.00- 11,484.84- 46, 8.894 472,354.76 - Program number: 518,466.00- 518,466.00- 11,484.84- 46, - 8.894 472,354.76 - Department number: 518,466.00- 518,466.00- 11,484.84- 46, 8.894 472,354.76 - Revenues Subtotal 518,466.00- 518,466.00- 11,484.84- L1.24- 8.894 472,354.76 - Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 11,484.84- 1.24- 8.894 472,354.76 - Page 19 glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 50 Account: 528-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (3,576.40) (1,134.84) Account: 528-49011-000-000 come Total (11,000.00) Budgeted (6,288.76) Remaining 43 % Used Account: 528-49142-000-000 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bond Resevr (13,800.00) (4,711.24) GL (4,600.00) (18,400.00) GL Account (307,049.00) Budgeted (288,649.00) Remaining 6 % Used Interfund transfer in -WW 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bond Resevr Account: 528-49143- nterfund transfer i (200,417.00) Budgeted (17,250.00) (5,750.00) (23,000.00) GL (177,417.00) Remaining 11 % Used Department Totals: (46,111.24) ** (11,484.84) Monthly Total (518,466.00) Budgeted (472,354.76) Remaining 9 % Used Fund 528 Totals: (46,111.24) (11,484.84) Monthly Total (518,466.00) Budgeted (472,354.76) Remaining 9 % Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS 736,540 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 100,659 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 837,199 FRI TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 100,659 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 100,659 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES 653,586 TOTAL FUND BALANCE 736,540 TOTAL LIABILITIES AND FUND BALANCE 837,199 glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 533-49011-000-000 533-49015-000-000 533-49141-000-000 Subtot Property Taxes Property Taxes/Delinquent Property Taxes/P & I Interest Income Lease/Rental Income Interfund Trans In -PID Surchg Program number: Department number: Revenues Revenues Subtotal 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 685,441.00- 685,441.00- 5,000.00- 218,004.00- 114,563.00- 5,000.00- 218,004.00- 114,563.00- 337,567.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 0- 0- 1,023,008.00- 256,840.76- 846.94- 196.25- 257,883.95- 609,567.64- 633.46- 349.49- 610,550.59- 723.25- 1,375.71- 10,414.81- 41,659.24- 01- 89.322 63.346 17.475 89.074 27.514 36.364 72,873.36- 366.54- 1,650.51- 3,624.29- 218,004.00- 72,903.76- 6 369,422.46- 653,585.54- 369,422.46- 653,585.54- 369,422.46 - Page 20 glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 533-70005-051-000 1 533-70025-051-000 1 533-70035-051-000 Payin$g Agent Fee Bond 2nterest Expense -Tax Bond Principal Payment -Tax 2,150.00 247,858.00 765,000.00 2,150.00 247,858.00 765,000.00 2,150.00 247,858.00 765,000.00 Page 21 Subtotal: 1,015,008.00 1,015,008.00 1,015,008.00 Program number: 1,015,008.00 1,015,008.00 1,015,008.00 Department number: Administration 1,015,008.00 1,015,008.00 1,015,008.00 Expenditures Subtotal 1,015,008.00 1,015,008.00 1,015,008.00 p Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 269,022.01- 653,585.54- 8,169.819 645,585.54 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Page 51 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 1/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 L Property Taxes 670 01/02/2020 Property Taxes 671 01/03/2020 Property Taxes 672 01/06/2020 Property Taxes 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 693 01/13/2020 Property Taxes 694 01/14/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 698 01/21/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes 705 01/28/2020 Property Taxes 706 01/29/2020 Property Taxes 707 01/30/2020 Property Taxes 708 01/31/2020 Property Taxes (352,726.88) (13,511.47) (366,238.35) (8,638.50) (374,876.85) (7,125.22) (382,002.07) (13,417.94) (395,420.01) (12,697.75) (408,117.76) (3,503.28) (411,621.04) (6,413.40) (418,034.44) (4,901.08) (422,935.52) (2,642.89) (425,578.41) (14,406.75) (439,985.16) (4,799.57) (444,784.73) (6,528.49) (451,313.22) (3,140.90) (454,454.12) (6,719.64) (461,173.76) (6,059.81) (467,233.57) (47,983.71) (515,217.28) (12,869.15) (528,086.43) (59,041.65) (587,128.08) (7,660.94) (594,789.02) (7,212.31) (602,001.33) (7,566.31) (609,567.64) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (256,840.76) (609,567.64) ** (682,441.00) Budgeted (72,873.36) Remaining 89 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 670 01/02/2020 Property Taxes 673 01/07/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 699 01/22/2020 Property Taxes 704 01/27/2020 Property Taxes 213.48 (11.91) (9.05) (26.98) (723.45) (61.41) (14.14) 201.57 192.52 165.54 (557.91) (619.32) (633.46) GL GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (846.94) (633.46) ** (1,000.00) Budgeted (366.54) Remaining 63 % Used Account: 533-40015-000-000 ` Property Taxes/P & I 670 01/02/2020 Property Taxes 673 01/07/2020 Property Taxes 692 01/10/2020 Property Taxes (153.24) (3.36) (2.09) (5.67) (156.60) (158.69) (164.36) GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 52 695 01/15/2020 Property Taxes 699 01/22/2020 Property Taxes 704 01/27/2020 Property Taxes (153.24) (173.64) (8.76) (2.73) (338.00) (346.76) (349.49) GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (196.25) (349.49) ** (2,000.00) Budgeted (1,650.51) Remaining 17 % Used Account: 533-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (652.46) (723.25) (1,375.71) GL Account: 533-49011-000-000 Interest Income Totals: (723.25) (1,375.71) ** (5,000.00) Budgeted (3,624.29) Remaining 28 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (218,004.00) Budgeted (218,004.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 645 01/30/2020 TexPool Transfers January TexPool O&M to I&S- PID Debt (31,244.43) (10,414.81) (41,659.24) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,414.81) (41,659.24) ** Department Totals: (114,563.00) Budgeted (269,022.01) Monthly Total (72,903.76) Remaining 36 % Used (653,585.54) ** (1,023,008.00) Budgeted (369,422.46) Remaining 64 % Used glpdatb2 skrolczyk 10:44 02/11/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 51 Administration Period Ending: 1/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 53 Check Source Number Department 51 Totals: Fund 533 Totals: .00 Monthly Total (269,022.01) Monthly Total .00 ** 1,015,008.00 Budgeted 1,015,008.00 Remaining 0 5 Used (653,585.54) (8,000.00) Budgeted 645,585.54 Remaining ########## Account: 533-70005-051-000 Paying Agent Fee .00 .00 Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,150.00 Budgeted 2,150.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax .00 .00 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 .00 ** 247,858.00 Budgeted 247,858.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 ** 765,000.00 Budgeted 765,000.00 Remaining 0 % Used Department 51 Totals: Fund 533 Totals: .00 Monthly Total (269,022.01) Monthly Total .00 ** 1,015,008.00 Budgeted 1,015,008.00 Remaining 0 5 Used (653,585.54) (8,000.00) Budgeted 645,585.54 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 242,846 TOTAL ASSETS 242,846 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 24,518 218,328 242,846 242,846 glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 534-49143-000-000 Interfund Transfer In-ww Sales 598,638.00- Subtot Program number: Department number: Revenues Revenues Subtotal 60I�0- 601 00- 6011'38.00- 601,138.00- 2,500.00- 598,638.00- 6011.38.00- 601,138.00- 601,138.00- 601,138.00- 261.57- 641.92- 54,421.63- 217,685.92- 54,683.20- 218,3./. 54,683.20- 54,683.20- 54,683.20- 218,327.84- 218,327.84- 218,327.84 - Page 22 25.677 1,858.08- I 36.364 380,952.08- I 36.319 36.319 36.319 36.319 38 382. 382,810.16- glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 23 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 I 534-70040-051-000 Revenue Bona Interest Expense 208,238.00 208,238.00 208,238.00 I 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 I Subtotal: , 598,638.00 598,638.00 598,638.00 Program number: III 598,638.00 598,638.00 598,638.00 Department number: Administration III 598,638.00 598,638.00 598,638. fl Expenditures Subtotal III 598,638.00 598,638.00 598,638.00 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,683.20- 218,327.84- 8,733.114 215,827.84 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 1/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 54 Check Source Number Department Totals: (54,683.20) Monthly Total (218,327.84) ** (601,138.00) Budgeted (382,810.16) Remaining 36 % Used Account: 534-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (380.35) (261.57) (641.92) GL Account: 534-49011-000-000 Interest Income Totals: (261.57) (641.92) ** (2,500.00) Budgeted (1,858.08) Remaining 26 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bd WWTP I&S (163,264.29) (54,421.63) (217,685.92) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (217,685.92) ** (598,638.00) Budgeted (380,952.08) Remaining 36 % Used Department Totals: (54,683.20) Monthly Total (218,327.84) ** (601,138.00) Budgeted (382,810.16) Remaining 36 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I0S Department: 51 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Account: 534-70005-051-000 Rev Bond Paying Agent Fee Rev Bond Paying Agent Fee Total 400.00 Budgeted 400.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 208,238.00 Remaining Account: 534-70045-051-000 Revenue Bond Principal Expense t: 534-70045-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining O % Used • O % Used .00 .00 .00 .00 .00 .00 0 % Used Department 51 Totals: .00 ** .00 Monthly Total 598,638.00 Budgeted 598,638.00 Remaining 0 % Used Fund 534 Totals: (218,327.84) (54,683.20) Monthly Total (2,500.00) Budgeted 215,827.84 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Pa TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 105,417 TOTAL ASSETS 105,417 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 4,967 100,450 105,417 105,417 glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 535-49011-000-000 1 535-49142-000-000 Interest Income Interfund Tran In -Water Sales 1,000.00- 275,525.00- 1,000.00- 275,525.00- 111.83- 25,047.72- 259.12- 100,190.88- 25.912 36.364 740.88- 175,334.12 - Page 24 Subtotal: 276,525.00- 276,525.00- 1 25,159.55- 100,450.00- 36.326 176,075.00 - Program number: 276,525.00- 276,525.00- 25,159.55- 100,450.00- 36.326 176,075.00 - Department number: Revenues 276,525.00- 276,525.00- 25,159.55- 100,450.00- 36.326 176,075.00 - Revenues Subtotal 276,525.00- 276,525.00- 25,159.55- 100,450.00- 36.326 176,075.00- glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 535-70040-051-000 Revenue Bona Interest Expense 386,811.00 386,811.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: ,111111102,611.00 602,611.00 Program number: _b02,611.00 602,611.00 Department number: Administration mEr 602,611.00 602,611.00 Expenditures Subtotal 602,611.00 602,611.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 25,159.55- 100,450.00- -30.805 800.00 386,811.00 215,000.00 602,611.00 602,611.00 602,611.00 602,611.00 426,536.00 Page 25 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 1/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 56 Check Source Number Department Totals: (25,159.55) Monthly Total (100,450.00) ** (276,525.00) Budgeted (176,075.00) Remaining 36 5 Used Account: 535-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (147.29) (111.83) (259.12) GL Account: 535-49011-000-000 Interest Income Totals: (111.83) (259.12) ** (1,000.00) Budgeted (740.88) Remaining 26 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 645 01/30/2020 TexPool Transfers January TexPool O&M to 16Swift Rev I&S (75,143.16) (25,047.72) (100,190.88) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: Ur (25,047.72) (100,190.88) ** (275,525.00) Budgeted (175,334.12) Remaining 36 5 Used Department Totals: (25,159.55) Monthly Total (100,450.00) ** (276,525.00) Budgeted (176,075.00) Remaining 36 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Account: 535-70005-051-000 Account: 535-70040-051-000 Rev Bond Paying Agent Fee Rev Bond Paying Agent Fee Total 800.00 Budgeted 800.00 Remaining Revenue Bond Interest Expense Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 386,811.00 Remaining Account: 535-70045-051-000 Revenue Bond Principal Expense Department 51 Totals: Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining .00 Monthly Total 0 % Used 0 % Used .00 .00 .00 .00 .00 .00 0 % Used .00 ** 602,611.00 Budgeted 602,611.00 Remaining 0 % Used Fund 535 Totals: (100,450.00) (25,159.55) Monthly Total 326,086.00 Budgeted 426,536.00 Remaining -31 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Rip TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 119,214 TOTAL ASSETS 119,214 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 119,214 TOTAL FUND BALANCE 119,214 TOTAL LIABILITIES AND FUND BALANCE 119,214 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 1 1 536-49011-000-000 1 536-49142-000-000 1 536-49143-000-000 Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 1/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 124.73- 22,896.02- 6,839.07- 273.78- 91,584.08- 27,356.28- 273.78 91,584.08 27,356.28 Page 26 Subtotal: "mmm797W-59.82- 119,1i4.14- 119,214.14 Program number: 29,859.82- 119,214.14- 119,214.14 Department number: Revenues 29,859.82- 119,214.14- 119,214.14 Revenues Subtotal 29,859.82- 119,214.14- 119,214.14 Fund number: 536 2019 Rev Bond I&S- W&WW System 29,859.82- 119,214.14- 119,214.14 ******* End of Report ********* glpdatb2 skrolczyk Trophy Club MUD No.1 Page 58 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (149.05) (124.73) (273.78) GL Account: 536-49011-000-000 Interest Income Total .00 Budgeted 273.78 Remaining 0 % Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S Account (68,688.06) (22,896.02) (91,584.08) GL Interfund Tran In -Water Sales Totals: .00 Budgeted 91,584.08 Remaining Interfund Transfer In -WW Sales i 645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S 0 % Used (20,517.21) (6,839.07) (27,356.28) GL Account: 536-49143-11rfund Transfer In -WW Sales Total .00 Budgeted 27,356.28 Remaining 0 % Used Department Totals: (119,214.14) ** (29,859.82) Monthly Total .00 Budgeted 119,214.14 Remaining 0 % Used Fund 536 Totals: (119,214.14) (29,859.82) Monthly Total .00 Budgeted 119,214.14 Remaining 0 % Used Grand Totals: (1,854,133.85) **** (548,373.18) Monthly Total (209,104.00) Budgeted 1,645,029.85 Remaining 887 % Used ******* End of Report *********