Loading...
HomeMy WebLinkAbout2019-12 Combined Financials December 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET DECEMBER 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 20,000 811,555 14,768 636,454 TOTAL ASSETS 1,482,778 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 232,548 TOTAL FUND BALANCE 836,317 636,461 10,000 646,461 TOTAL LIABILITIES AND FUND BALANCE 1,482,778 glbase tbam skrolczyk 12:51 01/13/20 Fund: 122 Trophy Club MUD Fire Dept. Account 1 1 122-40010-000-000 1 122-40011-000-000 1 Description Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Period Ending: 12/2019 Program: Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,214,230.00- 1,214,230.00- 552,022.60- 98.82- 627,586.54- 353.97 51.686 586,643.46- 353.97 - Page 1 122-40020-000-000 Property Taxes/Fire P&i 72.91- 1,221.32- 1,221.32 Subtotal: 1,214,230.00- 1,214,230.00- 552,194.33- 628,453.89- 51.757 585,776.11 - Program number: 1,214,230.00- 1,214,230.00- 552,194.33- 628,453.89- 51.757 585,776.11 - Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 552,194.33- 628,453.89- 51.757 585,776.11 - Revenues Subtotal 1,214,230.00- 1,214,230.00- 552,194.33- 628,453.89- 51.757 585,776.11- glbase tbam skrolczyk 12:51 01/13/20 Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Budget Summary with Amendment 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 1,640.88 122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00 59,888.08 Subtotal: 957,661.00 957,661.00 122-69005-045-000 122-69009-045-000 122-69195-045-000 122-69305-045-000 Subtotal: Program number: Capital Outlays Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases Department number: Fire Expenditures Subtotal Fund number: 122 Trophy Club MUD Fire Dept. 48,000.00 48,000.00 81,420.00 81,420.00 127,149.00 127,149.00 256,569.00 256,569.00 4,922.64 179,664.24 61,528.96 184,586.88 1,214,230.00 1,214,230.00 61,528.96 1,214,230.00 1,214,230.00 1,214,230.00 1,214,230.00 61,528.96 61,528.96 490,665.37- 2,750.00 11,958.24 81,420.00 115,190.36 211,318.60 23.441 25.000 19.275 5.729 100.000 90.595 82.363 395,905.48 32.605 395,905.48 395,905.48 232,548.41- 32.605 32.605 218,004.00 16,077.36 538,992.76 773,074.12 45,250.00 11,958.24- 11,958.64 45,250.40 818,324.52 818,324.52 818,324.52 232,548.41 Page 2 glpdatb2 skrolczyk Trophy Club MUD No.1 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 1 Check Source Number Account: 122-40010-000-000 Property Taxes/MUD Fire 534 12/02/2019 Property Taxes 535 12/03/2019 Property Taxes 537 12/04/2019 Property Taxes 538 12/05/2019 Property Taxes 539 12/06/2019 Property Taxes 540 12/09/2019 Property Taxes 542 12/10/2019 Property Taxes 543 12/11/2019 Property Taxes 544 12/12/2019 Property Taxes 545 12/13/2019 Property Taxes 546 12/16/2019 Property Taxes 547 12/17/2019 Property Taxes 548 12/18/2019 Property Taxes 549 12/19/2019 Property Taxes 550 12/20/2019 Property Taxes 551 12/23/2019 Property Taxes 552 12/26/2019 Property Taxes 553 12/27/2019 Property Taxes 554 12/30/2019 Property Taxes 555 12/31/2019 Property Taxes (75,563.94) (2,941.47) (4,609.00) (5,943.78) (2,564.83) (3,587.83) (6,873.47) (8,338.28) (9,193.81) (9,963.59) (9,402.39) (234,854.75) (104,408.13) (5,941.05) (7,991.69) (37,154.23) (32,088.55) (24,082.23) (16,450.48) (12,374.03) (13,259.01) (78,505.41) (83,114.41) (89,058.19) (91,623.02) (95,210.85) (102,084.32) (110,422.60) (119,616.41) (129,580.00) (138,982.39) (373,837.14) (478,245.27) (484,186.32) (492,178.01) (529,332.24) (561,420.79) (585,503.02) (601,953.50) (614,327.53) (627,586.54) 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: (552,022.60) (627,586.54) ** (1,214,230.00) Budgeted (586,643.46) Remaining 52 8 Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 534 12/02/2019 Property Taxes 535 12/03/2019 Property Taxes 539 12/06/2019 Property Taxes 549 12/19/2019 Property Taxes 552 12/26/2019 Property Taxes 452.79 (13.80) (13.39) (14.71) (33.86) (23.06) 438.99 425.60 410.89 377.03 353.97 GL GL GL GL GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (98.82) 353.97 ** .00 Budgeted (353.97) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 534 12/02/2019 Property Taxes 535 12/03/2019 Property Taxes 537 12/04/2019 Property Taxes 539 12/06/2019 Property Taxes 547 12/17/2019 Property Taxes (1,148.41) (5.64) (2.09) (5.97) (3.38) (16.68) (1,154.05) (1,156.14) (1,162.11) (1,165.49) (1,182.17) GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 549 12/19/2019 Property Taxes 550 12/20/2019 Property Taxes 552 12/26/2019 Property Taxes 553 12/27/2019 Property Taxes 555 12/31/2019 Property Taxes Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: .00 Budgeted 1,221.32 Remaining Account: 122-43415-000-000 Denton County Pledge -Fire 464 12/30/2019 December A/P Denton County Treasurer Fire P 493 12/30/2019 recut CK to seperate invoices Denton County Treasurer Fire P 494 12/31/2019 December A/P Denton County Treasurer Fire P 506 12/31/2019 Denton County Fire Pledge FY20 Account: 122-43415-000-000 Department Totals: Denton County Pledge -Fire .00 Budgeted (552,194.33) Monthly Total Totals: .00 Remaining (1,148.41) (5.07) (1,187.24) GL (.29) (1,187.53) GL (4.21) (1,191.74) GL (14.62) (1,206.36) GL (14.96) (1,221.32) GL 0 6 Used 0 6 Used (1,214,230.00) Budgeted (72.91) (1,221.32) ** 10,000.00 (10,000.00) 10,000.00 (10,000.00) 10,000.00 TOWN OF TROPHY CLUB 6047 AP .00 TOWN OF TROPHY CLUB 6047 AP 10,000.00 TOWN OF TROPHY CLUB 6079 AP .00 GL .00 .00 ** (628,453.89) ** (585,776.11) Remaining 52 % Used glpdatb2 skrolczyk 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Trophy Club MUD No.1 Page 3 Account: 122-60030-045-000 Rent And/Or Usage Account: 122-60030-045-000 Rent And/Or Usage Totals: 218,004.00 Budgeted 218,004.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 68 12/01/2019 Insurance/Wrk Comp Expense Dec 3,281.76 Account: 122-60055-045-000 Insurance Totals: 21,000.00 Budgeted .00 .00 .00 .00 ** 1,640.88 4,922.64 GL 16,077.36 Remaining 23 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 475 12/31/2019 December A/P Fire admin December 1,640.88 119,776.16 59,888.08 Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 718,657.00 Budgeted 538,992.76 Remaining 25 % Used 4,922.64 ** 179,664.24 TOWN OF TROPHY CLUB 6055 AP 59,888.08 179,664.24 ** Account: 122-69005-045-000 Capital Outlays 2,750.00 .00 2,750.00 Account: 122-69005-045-000 Capital Outlays Totals: .00 2,750.00 ** 48,000.00 Budgeted 45,250.00 Remaining 6 % Used Account: 122-69009-045-000 Short Term Debt -Interest 11,958.24 .00 11,958.24 Account: 122-69009-045-000 Short Term Debt -Interest Totals: .00 11,958.24 ** .00 Budgeted (11,958.24) Remaining 0 6 Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 6 Used Account: 122-69305-045-000 Capital Leases glpdatb2 skrolczyk 12:50 01/13/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 45 Fire Program: Period Ending: 12/2019 JE Detail Description/Comment Page 4 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) 115,190.36 .00 115,190.36 Account: 122-69305-045-000 Capital Leases Totals: .00 115,190.36 ** Department 45 Totals: Fund 122 Totals: 127,149.00 Budgeted 11,958.64 Remaining 91 % Used 61,528.96 Monthly Total 1,214,230.00 Budgeted (490,665.37) Monthly Total .00 Budgeted 395,905.48 ** 818,324.52 Remaining 33 % Used (232,548.41) 232,548.41 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET DECEMBER 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,721,282 2,721,282 CASH IN BANK -SAVINGS -CASH RESERVE 1,399,384 1,399,384 INVESTMENTS-TEXPOOL 4,137,698 919,266 5,056,964 PREPAID EXPENSES 84,368 84,368 ADVALOREM PROPERTY TAXES RECEIVABLE 70,570 70,570 UTILITY AND OTHER ACCOUNTS RECEIVABLE 845,321 845,321 TOTAL ASSETS 9,259,223 919,266 10,178,489 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 70,570 70,570 ACCOUNTS AND OTHER PAYABLES 397,244 397,244 CUSTOMER DEPOSITS 320,344 320,344 TOTAL LIABILITIES 788,158 788,158 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 69,681 69,681 TOTAL FUND BALANCE 8,471,065 919,266 9,390,331 TOTAL LIABILITIES AND FUND BALANCE 9,259,223 919,266 10,178,489 glbase tbam skrolczyk 12:51 01/13/20 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 Subtotal: 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 134,871.00- 300.00- 300.00- 164,253.00- 299,724.00- 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 10,171,516.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 173,837.00- 10,645,077.00- 10,645,077.00- 10,645,077.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 12/2019 Amended Total Budget Encumb. 134,871.00- 300.00- 300.00- 164,253.00- 299,724.00- 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 10,171,516.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 173,837.00- 10,645,077.00- 10,645,077.00- 10,645,077.00 - Current Month 61,281.21- 11.26- 8.17- 61,300.64- 348,070.71- 262,148.58- 6,126.33- 2,125.00 - Program: YTD Total 69,669.73- 40.14 136.34- 69,765.93- 1,214,983.21- 739,527.31- 26,629.05- 5,350.00- 1,800.00- 400.00- 15,048.80- 618,470.62- 2,003,738.37- 10,064.35- 31,542.78- 2,357.62- 3,536.43- 583.33- 1,749.99- 5,355.28- 320.88- 7,922.02- 13,326.18- 50,106.50- 693,097.44- 2,123,610.80- 693,097.44- 2,123,610.80- 693,097.44- 2,123,610.80- % of Budget 51.657 -13.380 45.447 23.277 18.731 21.106 23.648 35.314 240.000 16.000 30.098 Remaining Budget 65,201.27- 340.14- 163.66- 164,253.00- 229,958.07- 5,271,639.79- 2,764,357.69- 85,978.95- 9,800.00- 1,050.00 2,100.00- 34,951.20- 19.700 8,167,777.63- 26.286 25.000 25.000 42.197 113.172 28.824 19.949 19.949 19.949 88,457.22- 10,609.57- 5,250.01- 13,000.00- 7,335.72- 922.02 8,457.22 -10,609.57-5,250.01-13,000.00- 7,335.72- 922.02 123,730.50- 8,521,466.20- 8,521,466.20- 8,521,466.20- Page 23,730.50-8,521,466.20-8,521,466.20- 8,521,466.20- Page 3 glbase tbam skrolczyk 12:51 01/13/20 Fund: 135 MUD 1 General Fund Account 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 Description Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Department: Adopted Budget 350,267.00 17,000.00 3,920.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 3,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 10 Water Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 12/2019 Total Encumb. Amended Budget 350,267.00 17,000.00 3,920.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 3,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 Current Month Program: YTD Total % of Budget 27,261.05 78,619.24 22.446 1,189.55 5,390.37 31.708 5,082.50 129.656 425.00 1,225.00 22.685 2,671.00 9,435.00 27.063 4,877.65 13,928.54 16.517 293.69 847.92 17.945 48.78 139.75 18.220 412.35 871.12 27.814 1,765.96 5,538.84 23.723 412.98 1,295.35 23.720 6.54 16.68 1.544 771.49 2,314.47 19.531 Remaining Budget 271,647.76 11,609.63 1,162.50- 4,175.00 25,428.00 70,397.46 3,877.08 627.25 2,260.88 17,809.16 4,165.65 1,063.32 9,535.53 400.00 300.00 Page 4 Subtotal: 546,839.00 546,839.00 40,136.04 124,704.78 22.805 422,134.22 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 802.41 13,919.78 13.920 171.36 379.24 7.585 920.37 920.37 26.296 87.50 175.00 17.500 407.70 1,147.70 15.303 20,000.00 86,080.22 3,000.00 4,620.76 2,579.63 825.00 6,352.30 Subtotal: 140,000.00 140,000.00 2,389.34 16,542.09 11.816 123,457.91 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out 5,000.00 125,677.00 1,000.00 500.00 7,426.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 3,000.00 14,750.00 527,381.00 55,193.00 180,000.00 5,000.00 125,677.00 1,000.00 500.00 7,426.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 3,000.00 14,750.00 527,381.00 55,193.00 180,000.00 385.18 1,624.35 32.487 7,278.92 33,423.43 26.595 129,480.07 47,943.74 4,600.00 295.00 3.973 14,207.15 22.551 350,392.70 12.907 462.00 15.400 143,831.22 27.273 13,800.00 25.003 3,375.65 92,253.57 1,000.00 500.00 7,131.00 400.00 2,845.00 1,500.00 48,792.85 2,364,317.30 200.00 2,538.00 14,750.00 383,549.78 41,393.00 180,000.00 glbase tbam skrolczyk 12:51 01/13/20 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Subtotal: 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 Subtotal: 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtotal: Program number: Description Furniture/Equipment < $5000 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 Department: Adopted Budget 2,500.00 3,705,082.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 913,618.00 5,504,929.00 10 Water Trophy Club MUD No.1 Page 5 Budget Summary with Amendment Period Ending: 12/2019 Total Encumb. Amended Budget 2,500.00 3,705,082.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 913,618.00 5,504,929.00 Current Month 461.15 190,149.06 685.10 1,187.98 1,533.48 3,406.56 60,763.65 60,763.65 296,844.65 Program: YTD Total 561.72 558,597.57 2,428.93 2,917.33 4,865.04 8,875.28 19,086.58 90,568.03 75,000.00 57,932.73 223,500.76 942,431.78 % of Budget 22.469 15.077 16.193 56.211 24.325 12.679 9.572 13.224 100.000 48.277 24.463 17.120 Remaining Budget 1,938.28 3,146,484.43 12,571.07 2,272.67 15,134.96 1,200.00 1,000.00 61,124.72 87,000.00 180,303.42 594,306.97 30,512.00 3,231.00 62,067.27 690,117.24 4,562,497.22 glbase tbam skrolczyk 12:51 01/13/20 Fund: 135 MUD 1 General Fund Department: 10 Water Trophy Club MUD No.1 Budget Summary with Amendment Program: 1 Lab Analysis for PID Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 Subtotal: 2,000.00 2,000.00 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 Department number: Water 5,506,929.00 5,506,929.00 307.70 307.70 307.70 387.70 19.385 387.70 19.385 387.70 297,152.35 942,819.48 19.385 17.121 1,612.30 1,612.30 1,612.30 4,564,109.52 Page 6 glbase tbam skrolczyk Trophy Club MUD No.1 Page 7 12:51 01/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 30,544.82 87,226.30 19.743 354,572.70 135-50010-020-000 Overtime 33,000.00 33,000.00 1,911.74 6,099.72 18.484 26,900.28 135-50016-020-000 Longevity 8,035.00 8,035.00 6,872.50 85.532 1,162.50 135-50017-020-000 Certification 9,000.00 9,000.00 650.00 1,900.00 21.111 7,100.00 135-50020-020-000 Retirement 45,531.00 45,531.00 3,062.36 10,982.75 24.121 34,548.25 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 6,339.33 18,313.59 17.465 86,544.41 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 374.72 1,091.02 18.756 4,725.98 135-50028-020-000 Vision Insurance 948.00 948.00 62.51 180.95 19.088 767.05 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 334.92 1,014.05 22.534 3,485.95 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 1,907.82 5,963.49 19.556 24,530.51 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 446.18 1,394.67 19.555 5,737.33 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 1,110.20 3,330.60 21.665 12,042.40 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 708,447.00 708,447.00 46,744.60 144,369.64 20.378 564,077.36 135-55005-020-000 Engineering 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 8,938.10 15,624.92 17.756 72,375.08 135-55081-020-000 Mainten & Re/Pairs Collections 10,000.00 10,000.00 14,277.16 142.772 4,277.16- 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 241.75 404.23 10.106 3,595.77 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 23.00 1,860.08 23.251 6,139.92 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 1,360.92 504.68 16.823 2,495.32 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 87.50 175.00 11.667 1,325.00 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 8,337.08 20,576.50 20.577 79,423.50 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 5,649.94 10,059.14 25.148 29,940.86 Subtotal: 309,500.00 309,500.00 24,638.29 66,481.71 21.480 243,018.29 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 410.83 1,585.66 31.713 3,414.34 135-60020-020-000 Electricity 160,067.00 160,067.00 12,456.23 35,143.35 21.955 124,923.65 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 111.00 37.000 189.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 297.32 1,470.85 29.476 3,519.15 135-60090-020-000 Safety Program 1,000.00 1,000.00 109.14 109.14 10.914 890.86 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 356.71 23.088 1,188.29 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 200.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 12:51 01/13/20 Fund: 135 MUD 1 General Fund Account 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Description Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 Department: Adopted Budget 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 12/2019 Amended Total Budget Encumb. 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Current Month Program: YTD Total % of Budget 10,414.81 31,244.43 27.273 61,260.70 183,781.50 27.273 5,750.00 17,250.00 13.779 190.00 9.500 Remaining Budget 14,000.00 83,318.57 490,085.50 107,937.00 180,000.00 1,810.00 Page 8 Subtotal: 1,310,669.00 1,310,669.00 91,010.03 281,330.66 21.465 1,029,338.34 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65031-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Fuel & Lube Uniforms Chemicals Chemicals Collections Small Tools Safety E uipment Lab Supplies 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 505.14 2,335.18 18.681 504.00 3,507.93 63.839 3,425.60 6,820.56 34.103 4,994.00 28.537 1,088.92 1,088.92 90.743 4,028.06 8,006.39 40.032 10,164.82 1,987.07 13,179.44 12,506.00 1,200.00 111.08 11,993.61 Subtotal: 77,895.00 77,895.00 9,551.72 26,752.98 34.345 51,142.02 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtotal: Program number: Department number: Wastewater 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 3,623.55 94,215.85 17.760 130,000.00 100.000 3,623.55 224,215.85 29.859 175,568.19 743,150.84 23.537 175,568.19 743,150.84 23.537 436,284.15 79,133.00 11,277.00 526,694.15 2,414,270.16 2,414,270.16 glbase tbam skrolczyk Trophy Club MUD No.1 Page 9 12:51 01/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Budget Budget Encumb. Month Total Budget Program: 135-50045-026-000 Subtotal: Workman's Compensation 30.00 30.00 30.00 30.00 135-60066-026-000 Publications/Books/Subscripts 150.00 135-60070-026-000 Dues & Memberships 750.00 135-60075-026-000 Meetings 1,300.00 135-60080-026-000 Schools & Training 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 Subtotal: 13,200.00 Program number: 13,230.00 Department number: Board of Directors 13,230.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 13,200.00 13,230.00 13,230.00 1.99 5.97 1.99 5.97 14.20 14.20 16.19 16.19 675.00 170.56 19.900 Remaining Budget 24.03 19.900 24.03 90.000 13.120 845.56 6.406 851.53 851.53 6.436 6.436 150.00 75.00 1,129.44 4,000.00 5,000.00 2,000.00 12,354.44 12,378.47 12,378.47 glbase tbam skrolczyk Trophy Club MUD No.1 Page 10 12:51 01/13/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 135-50010-030-000 135-50016-030-000 135-50020-030-000 135-50026-030-000 135-50027-030-000 135-50028-030-000 135-50029-030-000 135-50030-030-000 135-50035-030-000 135-50040-030-000 135-50045-030-000 135-50060-030-000 135-50070-030-000 Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations 628,298.00 628,298.00 2,000.00 2,000.00 2,208.00 2,208.00 58,554.00 58,554.00 124,394.00 124,394.00 6,464.00 6,464.00 1,035.00 1,035.00 4,500.00 4,500.00 39,215.00 39,215.00 9,171.00 9,171.00 1,440.00 1,440.00 1,775.00 1,775.00 500.00 500.00 8,000.00 8,000.00 30,155.98 8.71 2,790.24 5,488.81 306.40 48.77 321.21 1,742.30 407.49 104.82 2,791.88 88,963.65 11.82 2,207.50 9,940.22 16,466.43 919.20 146.31 943.63 5,338.43 1,248.53 314.46 3,078.10 14.159 539,334.35 .591 1,988.18 99.977 .50 16.976 48,613.78 13.237 107,927.57 14.220 5,544.80 14.136 888.69 20.970 3,556.37 13.613 33,876.57 13.614 7,922.47 1,440.00 1,460.54 500.00 4,921.90 17.716 38.476 Subtotal: 887,554.00 887,554.00 44,166.61 129,578.28 14.599 757,975.72 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 Cleaning Services Professional Outside Services Utility Billing Contract 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 5,206.68 10,655.08 540.00 869.06 1,117.54 73,404.13 34,035.79 1,055.00 1,738.12 1,699.69 54.502 25.212 7.033 17.381 18.885 61,276.87 100,964.21 13,945.00 10,000.00 8,261.88 65,600.00 7,300.31 Subtotal: 379,281.00 379,281.00 18,388.36 111,932.73 29.512 267,348.27 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60115-030-000 135-60125-030-000 Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Elections 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 Advertising 2,500.00 2,500.00 1,487.98 238.02 592.00 61.59 3,099.91 6,461.89 7,019.39 125.00 3,886.55 26.19 180.00 558.81 4,455.76 714.06 592.00 184.77 4,875.95 20,732.67 21,016.17 125.00 4,086.55 61.37 476.20 1,152.71 686.89 43.01 18.817 17.852 8.606 12.318 16.253 30.944 25.019 12.500 68.109 15.343 7.937 16.828 19.376 19,224.24 3,285.94 6,287.00 1,315.23 25,124.05 46,267.33 1,500.00 62,983.83 875.00 1,913.45 338.63 5,523.80 5,697.29 2,858.11 200.00 43.01- 2,500.00 glbase tbam skrolczyk 12:51 01/13/20 Fund: 135 MUD 1 General Fund Account Description 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 Trophy Club MUD No.1 Page 11 Budget Summary with Amendment Department: 30 Administration Program: Period Ending: 12/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,288.00 500.00 17,000.00 2,500.00 1,288.00 500.00 17,000.00 2,500.00 24.00 72.00 5.590 1,216.00 500.00 17,000.00 2,500.00 Subtotal: 266,342.00 266,342.00 23,761.33 59,275.11 22.255 207,066.89 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing 2,050.00 26,485.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 26,485.00 6,000.00 3,500.00 4,000.00 2,500.00 3,235.24 578.12 543.16 3,235.24 1,677.74 1,220.88 12.215 27.962 30.522 2,050.00 23,249.76 4,322.26 3,500.00 2,779.12 2,500.00 Subtotal: 44,535.00 44,535.00 4,356.52 6,133.86 13.773 38,401.14 135-69005-030-000 1 135-69170-030-000 Capital Outlays Copier Lease Installments 195,000.00 4,000.00 195,000.00 4,000.00 302.62 795.98 19.900 195,000.00 3,204.02 Subtotal: 199,000.00 199,000.00 302.62 795.98 .400 198,204.02 Program number: 1,776,712.00 1,776,712.00 90,975.44 307,715.96 17.319 1,468,996.04 Department number: Administration 1,776,712.00 1,776,712.00 90,975.44 307,715.96 17.319 1,468,996.04 glbase_tbam skrolczyk 12:51 01/13/20 Fund: 135 MUD 1 General Fund Account 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Description Legal Auditing,. Appraisal Tax Admin Fees Subtotal: Program number: Department number: Non Departmental Expenditures Subtotal Fund number: 135 MUD 1 General Fund Department: Adopted Budget 135,000.00 33,800.00 11,761.00 4,000.00 Trophy Club MUD No.1 Budget Summary with Amendment 39 Non Departmental Period Ending: 12/2019 Amended Total Budget Encumb. 135,000.00 33,800.00 11,761.00 4,000.00 184,561.00 184,561.00 184,561.00 184,561.00 184,561.00 184,561.00 10,638,853.00 10,638,853.00 6,224.00- 6,224.00 - Current Month 9,802.96 5,191.91 3,756.00 18,750.87 18,750.87 18,750.87 582,463.04 110,634.40 - Program: YTD Total 35,307.89 15,150.00 5,178.56 3,756.00 59,392.45 59,392.45 59,392.45 2,053,930.26 69,680.54- % of Budget 26.154 44.822 44.032 93.900 32.180 32.180 32.180 19.306 1,119.546 Remaining Budget 99,692.11 18,650.00 6,582.44 244.00 125,168.55 125,168.55 125,168.55 8,584,922.74 63,456.54 Page 12 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 12:51 01/13/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/2019 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 Subtotal: 286,420.00- 286,420.00 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 glpdatb2 skrolczyk Trophy Club MUD No.1 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 5 Check Source Number Account: 135-40000-000-000 Property Taxes 534 12/02/2019 Property Taxes 535 12/03/2019 Property Taxes 537 12/04/2019 Property Taxes 538 12/05/2019 Property Taxes 539 12/06/2019 Property Taxes 540 12/09/2019 Property Taxes 542 12/10/2019 Property Taxes 543 12/11/2019 Property Taxes 544 12/12/2019 Property Taxes 545 12/13/2019 Property Taxes 546 12/16/2019 Property Taxes 547 12/17/2019 Property Taxes 548 12/18/2019 Property Taxes 549 12/19/2019 Property Taxes 550 12/20/2019 Property Taxes 551 12/23/2019 Property Taxes 552 12/26/2019 Property Taxes 553 12/27/2019 Property Taxes 554 12/30/2019 Property Taxes 555 12/31/2019 Property Taxes (8,388.52) (326.54) (511.65) (659.83) (284.73) (398.29) (763.04) (925.65) (1,020.63) (1,106.08) (1,043.78) (26,071.73) (11,590.57) (659.53) (887.17) (4,124.57) (3,562.22) (2,673.42) (1,826.20) (1,373.67) (1,471.91) (8,715.06) (9,226.71) (9,886.54) (10,171.27) (10,569.56) (11,332.60) (12,258.25) (13,278.88) (14,384.96) (15,428.74) (41,500.47) (53,091.04) (53,750.57) (54,637.74) (58,762.31) (62,324.53) (64,997.95) (66,824.15) (68,197.82) (69,669.73) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (61,281.21) (69,669.73) ** (134,871.00) Budgeted (65,201.27) Remaining 52 6 Used Account: 135-40002-000-000 Property Taxes/Delinquent 534 12/02/2019 Property Taxes 535 12/03/2019 Property Taxes 539 12/06/2019 Property Taxes 549 12/19/2019 Property Taxes 552 12/26/2019 Property Taxes 51.40 Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (300.00) Budgeted (340.14) Remaining -13 % Used (1.58) (1.52) (1.68) (3.86) (2.62) 49.82 48.30 46.62 42.76 40.14 GL GL GL GL GL (11.26) 40.14 ** Account: 135-40015-000-000 Property Taxes/P & I 534 12/02/2019 Property Taxes 535 12/03/2019 Property Taxes 537 12/04/2019 Property Taxes 539 12/06/2019 Property Taxes 547 12/17/2019 Property Taxes (128.17) (.65) (.25) (.66) (.38) (1.85) (128.82) (129.07) (129.73) (130.11) (131.96) GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 6 549 12/19/2019 Property Taxes 550 12/20/2019 Property Taxes 552 12/26/2019 Property Taxes 553 12/27/2019 Property Taxes 555 12/31/2019 Property Taxes (128.17) (.58) (.03) (.48) (1.63) (1.66) (132.54) (132.57) (133.05) (134.68) (136.34) GL GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (8.17) (136.34) ** (300.00) Budgeted (163.66) Remaining 45 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (164,253.00) Budgeted (164,253.00) Remaining 0 % Used Account: 135-47000-000-000 Water 418 12/18/2019 UB 12/18/2019 Water credit UB20191218-20191218 User: (866,912.50) 478 12/31/2019 UB 12/31/2019 Billing 0820191231-20191231 User: 1.22 (348,071.93) (866,911.28) (1,214,983.21) UB UB Account: 135-47000-000-000 Water Totals: (348,070.71) (1,214,983.21) ** (6,486,623.00) Budgeted (5,271,639.79) Remaining 19 % Used Account: 135-47005-000-000 Sewer 418 12/18/2019 UB 12/18/2019 Water credit UB20191218-20191218 User: (477,378.73) 478 12/31/2019 UB 12/31/2019 Billing U820191231-20191231 User: .74 (262,149.32) (477,377.99) (739,527.31) UB UB Account: 135-47005-000-000 Sewer Totals: (262,148.58) (739,527.31) ** (3,503,885.00) Budgeted (2,764,357.69) Remaining 21 % Used Account: 135-47025-000-000 Penalties 401 12/12/2019 UB 12/12/2019 Penatly removal UB20191212-20191212 User: 442 12/23/2019 UB 12/23/2019 Penalties UB20191223-20191223 User: 443 12/23/2019 UB 12/23/2019 Penalty removal UB20191223-20191223 User: 456 12/27/2019 UB 12/27/2019 Penalty removal UB20191227-20191227 User: (20,502.72) 238.71 (6,923.28) 382.34 175.90 (20,264.01) (27,187.29) (26,804.95) (26,629.05) UB UB UB UB Account: 135-47025-000-000 _ Penalties Totals: (6,126.33) (26,629.05) ** (112,608.00) Budgeted (85,978.95) Remaining 24 % Used Account: 135-47030-000-000 1 Service Charges glpdatb2 skrolczyk 12:50 01/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 12/2019 Page 7 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 343 12/05/2019 UB 12/05/2019 Disconnect Fees UB20191205-20191205 User: 424 12/12/2019 UB 12/12/2019 NSF Check UB20191212-20191212 User: (3,225.00) (2,100.00) (25.00) (5,325.00) (5,350.00) UB UB Account: 135-47030-000-000 ' Service Charges ' Totals: (2,125.00) (5,350.00) ** (15,150.00) Budgeted (9,800.00) Remaining 35 % Used Account: 135-47035-000-000 ' Plumbing Inspections (1,800.00) .00 (1,800.00) Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (1,800.00) ** (750.00) Budgeted 1,050.00 Remaining 240 % Used Account: 135-47045-000-000 Sewer Inspections (400.00) .00 (400.00) Account: 135-47045-000-000 Sewer Inspections Totals: .00 (400.00) ** (2,500.00) Budgeted (2,100.00) Remaining 16 % Used Account: 135-47070-000-000 TCCC Effluent Charges ' (15,048.80) .00 (15,048.80) Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (15,048.80) ** (50,000.00) Budgeted (34,951.20) Remaining 30 % Used Account: 135-49011-000-000 Interest Income 503 12/31/2019 Bank Interest- December 503 12/31/2019 Bank Interest- December 503 12/31/2019 Bank Interest- December (21,478.43) (1,205.24) (1,068.85) (7,790.26) (22,683.67) (23,752.52) (31,542.78) GL GL GL Account: 135-49011-000-000 Interest Income Totals: (10,064.35) (31,542.78) ** (120,000.00) Budgeted (88,457.22) Remaining 26 % Used Account: 135-49016-000-000 Cell Tower Revenue 504 12/17/2019 Cell Tower Rev AT&T December 505 12/31/2019 Cell Tower Rev AT&T January (1,178.81) (1,178.81) (1,178.81) (2,357.62) (3,536.43) GL GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (2,357.62) (3,536.43) ** (14,146.00) Budgeted (10,609.57) Remaining 25 % Used glpdatb2 skrolczyk 12:50 01/13/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: 12/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 8 Check Source Number Department Totals: (7,000.00) Budgeted (693,097.44) Monthly Total 922.02 Remaining 113 % Used (2,123,610.80) ** (10,645,077.00) Budgeted (8,521,466.20) Remaining 20 % Used Account: 135-49018-000-000 Building Rent Income 515 12/31/2019 Town Billed Invoices 1718-1721 AR 20191231-20191231 User: (1,166.66) (583.33) (1,749.99) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,749.99) ** (7,000.00) Budgeted (5,250.01) Remaining 25 % 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 (5,355.28) .00 (5,355.28) Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 (5,355.28) ** (12,691.00) Budgeted (7,335.72) Remaining 42 % Used Account: 135-49900-000-000 Miscellaneous Income - 478 12/31/2019 UB 12/31/2019 Billing UB20191231-20191231 User: (7,601.14) (320.88) (7,922.02) UB Account: 135-49900-000-000 Miscellaneous Income ' Totals: (320.88) (7,922.02) ** Department Totals: (7,000.00) Budgeted (693,097.44) Monthly Total 922.02 Remaining 113 % Used (2,123,610.80) ** (10,645,077.00) Budgeted (8,521,466.20) Remaining 20 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2019 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 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Account: 135-50005-010-000 Salaries & Wages Salaries & Wages Salaries & Wages 51,358.19 14,348.05 65,706.24 PR 12,913.00 78,619.24 PR Salaries & Wages Totals: 27,261.05 78,619.24 ** 350,267.00 Budgeted Account: 135-50010-010-000 Overtime 391 12/13/2019 MUD Payroll 12/13/19 Overtime 445 12/27/2019 MUD Payroll 12/27/19 Overtime 271,647.76 Remaining 22 % Used 4,200.82 668.09 4,868.91 PR 521.46 5,390.37 PR Account: 135-50010-010-000 Overtime Totals: 1,189.55 5,390.37 ** 17,000.00 Budgeted 11,609.63 Remaining 32 % 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 445 12/27/2019 MUD Payroll 12/27/19 Certification 800.00 425.00 1,225.00 Account: 135-50017-010-000 Certification Totals: =I= 425.00 1,225.00 ** 5,400.00 Budgeted 4,175.00 Remaining 23 % Used Account: 135-50020-010-000 Retirement 391 12/13/2019 MUD Payroll 12/13/19 Retirement 445 12/27/2019 MUD Payroll 12/27/19 Retirement 6,764.00 1,388.99 8,152.99 1,282.01 9,435.00 PR PR PR Account: 135-50020-010-000 Retirement Totals: 2,671.00 9,435.00 ** 34,863.00 Budgeted Account: 135-50026-010-000 Medical Insurance 391 12/13/2019 MUD Payroll 12/13/19 Medical Insurance 445 12/27/2019 MUD Payroll 12/27/19 Medical Insurance Account: 135-50026-010-000 25,428.00 Remaining 27 6 Used Medical Insurance Totals: 84,326.00 Budgeted 9,050.89 70,397.46 Remaining 17 % Used 2,614.96 11,665.85 2,262.69 13,928.54 4,877.65 13,928.54 ** PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Account: 135-50027-010-000 Account: 135-50028-010-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Dental Insurance Dental Insurance Dental Insurance 554.23 155.16 709.39 PR 138.53 847.92 PR Dental Insurance Totals: 293.69 847.92 ** 4,725.00 Budgeted Vision Insurance Vision Insurance Vision Insurance 3,877.08 Remaining 18 % Used 90.97 26.06 117.03 PR 22.72 139.75 PR Account: 135-50028-010-000 Vision Insurance Totals: 48.78 139.75 ** 767.00 Budgeted 627.25 Remaining 18 % Used Account: 135-50029-010-000 Life Insurance & Other 351 12/01/2019 Payroll Benefits December 351 12/01/2019 Payroll Benefits December 464 12/30/2019 December A/P Employee LTD & STD Employee Benefits caf 125 -November 458.77 177.31 636.08 METLIFE GROUP BENEFITS 215.04 851.12 Humana Inc 20.00 871.12 BenefitMall 5975 AP 5972 AP 6028 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 412.35 871 3,132.00 Budgeted 2,260.88 Remaining 28 8 Used Account: 135-50030-010-000 Social Security Taxes 391 12/13/2019 MUD Payroll 12/13/19 Social Security Taxes 445 12/27/2019 MUD Payroll 12/27/19 Social Security Taxes Account: 135-50030-010-000 Account: 135-50035-010-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Social Security Taxes Totals: 23,348.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes 3,772.88 17,809.16 Remaining 24 8 Used 882.37 921.69 844.27 1,765.96 4,694.57 5,538.84 5,538.84 ** 215.54 1,097.91 197.44 1,295.35 PR PR PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 412.98 1,295.35 ** 5,461.00 Budgeted Account: 135-50040-010-000 employment Taxes 391 12/13/2019 MUD Payroll 12/13/19 Unemployment Taxes 4,165.65 Remaining 24 8 Used 10.14 3.04 13.18 PR glpdatb2 skrolczyk 12:50 01/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 445 12/27/2019 MUD Payroll 12/27/19 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 12/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes 10.19 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 3.50 16.68 Page 11 Check Source Number PR Account: 135-50040-010-000 Unemployment Taxes Totals: 6.54 16.68 ** 1,080.00 Budgeted 1,063.32 Remaining 2 % Used Account: 135-50045-010-000 Workman's Compensation 68 12/01/2019 Insurance/Wrk Comp Expense Dec 1,542.98 771.49 2,314.47 GL Account: 135-50045-010-000 Workman's Compensation Totals: 771.49 2,314.47 ** 11,850.00 Budgeted 9,535.53 Remaining 20 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations .00 .00 Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 402 12/12/2019 December A/P parts 481 12/26/2019 PCards 11/27/19 - 12/26/19 locks for disconnects 13,117.37 24.50 777.91 13,141.87 13,919.78 Core & Main LP THE WILSON BOHANNAN CO 5988 AP PC Account: 135-55080-010-000 Maintenance & Repairs Totals: 802.41 13,919.78 ** 100,000.00 Budgeted 86,080.22 Remaining 14 % Used Account: 135-55085-010-000 Generator Maint. and Repair glpdatb2 skrolczyk 12:50 01/13/20 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 12/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail .00 Transaction Vendor_Name Detail (SUBTOTAL) .00 Page 12 Check Source Number Account: 135-55085-010-000 Generator Maint. and Repair Totals .00 00 3,000.00 Budgeted 3,000.00 Remaining 0 8 Used Account: 135-55090-010-000 Vehicle Maintenance 481 481 481 481 481 481 481 481 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 PCards PCards PCards PCards PCards PCards PCards PCards 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 Vehicle registration 2 vehical registrations vehicle registration fee Vehical registration fees safety inspection inspection oil change fuel cap 207.88 7.50 16.50 2.00 4.00 7.00 51.00 69.37 13.99 215.38 231.88 233.88 237.88 244.88 295.88 365.25 379.24 DENTON VEHREG DENTON VEHREG TX.GOV*SERVICEFEE-DIR TX.GOV*SERVICEFEE-DIR KWIK KAR LUBE & TUNE 0 KWIK KAR LUBE & TUNE 0 KWIK KAR LUBE & TUNE 0 ROANOKE AUTO SUPPLY LT PC PC PC PC PC PC PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 171.36 379.24 ** 5,000.00 Budgeted 4,620.76 Remaining 8 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 522 12/31/2019 December A/P yearly backhoe service 920.37 920.37 HOLT CAT 6084 AP Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 920.37 920.37 ** 3,500.00 Budgeted 2,579.63 Remaining 26 % Used Account: 135-55120-010-000 Cleaning Services 433 12/20/2019 December A/P janitorial svc-November 87.50 87.50 175.00 MEMBER'S BUILDING MAINTENANCE 6015 AP Account: 135-55120-010-000 Cleaning Services Totals: 87.50 175.00 ** 1,000.00 Budgeted 825.00 Remaining 18 % Used Account: 135-55135-010-000 Lab Analysis 433 12/20/2019 December A/P 433 12/20/2019 December A/P water samples TCEQ samples 740.00 200.00 207.70 940.00 1,147.70 TARRANT CTY PUBLIC HEALTH LAB LOWER COLORADO RIVER AUTHORITY 6022 6014 AP AP Account: 135-55135-010-000 Lab Analysis Totals: 407.70 1,147.70 ** 7,500.00 Budgeted 6,352.30 Remaining 15 % Used Account: 135-60010-010-000 Communications/Mobiles glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 402 12/12/2019 December A/P Cell phones -December 481 12/26/2019 PCards 11/27/19 - 12/26/19 usb splitter 1,239.17 376.19 1,615.36 VERIZON WIRELESS 6001 AP 8.99 1,624.35 AMZN MKTP US*WD67D3IW3 PC Account: 135-60010-010-000 11111 Communications/Mobiles Totals: 385.18 1,624.35 ** 5,000.00 Budgeted 3,375.65 Remaining 32 6 Used Account: 135-60020-010-000 Electricity 433 12/20/2019 December A/P Electricity 11/8-12/10 26,144.51 7,278.92 33,423.43 HUDSON ENERGY SERVICES, LLC 6011 AP Account: 135-60020-010-000 Electricity Totals: 7,278.92 33,423.43 ** 125,677.00 Budgeted 92,253.57 Remaining 27 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 295.00 .00 295.00 Account: 135-60080-010-000 Schools & Training Totals: .00 295.00 ** 7,426.00 Budgeted 7,131.00 Remaining 4 6 Used Account: 135-60090-010-000 Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60100-010-000 Travel & per diem Totals: 2,845.00 Budgeted Account: 135-60105-010-000 Rent/Lease Equipment Account: 135-60105-010-000 .00 2,845.00 Remaining 0 % Used Rent/Lease Equipment Totals: 1,500.00 Budgeted Account: 135-60135-010-000 TCEQ Fees & Permits Account: 135-60135-010-000 .00 .00 1,500.00 Remaining 0 % Used 14,207.15 .00 .00 .00 ** .00 .00 ** .00 14,207.15 TCEQ Fees & Permits Totals: .00 14,207.15 ** 63,000.00 Budgeted Account: 135-60150-010-000 Wholesale Water 464 12/30/2019 December A/P wholesale water Account: 135-60150-010-000 48,792.85 Remaining 23 % Used 220,912.63 129,480.07 350,392.70 CITY OF FORT WORTH 6029 AP Wholesale Water Totals: 129,480.07 350,392.70 ** 2,714,710.00 Budgeted Account: 135-60245-010-000 Miscellaneous Expenses Account: 135-60245-010-000 2,364,317.30 Remaining 13 % Used .00 .00 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted Account: 135-60280-010-000 Property Maintenance Account: 135-60280-010-000 200.00 Remaining 0 % Used 462.00 .00 462.00 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 Trophy Club MUD No.1 Page 15 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2019 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-010-000 Lawn Equipment & Maintenance Totals: -0 .00 ** 14,750.00 Budgeted 14,750.00 Remaining 0 8 Used Account: 135-60332-010-000 Interfund Transfer Out -Rev I6S 474 12/31/2019 TexPool Transfers December TexPool O&M to 16Swift Rev I&S 95,887.48 474 12/31/2019 TexPool Transfers December TexPool O&M to 19 W&WW Rev I&S 25,047.72 120,935.20 GL 22,896.02 143,831.22 GL Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 47,943.74 143,831.22 ** 527,381.00 Budgeted 383,549.78 Remaining 27 % Used Account: 135-60333-010-000 Interfund Transfer Out -Reserve 474 12/31/2019 TexPool Transfers December TexPool O&M to Rev Bond Resevr 9,200.00 4,600.00 13,800.00 GL Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 4,600.00 13,800.00 ** 55,193.00 Budgeted 41,393.00 Remaining 25 % Used Account: 135-60334-010-000 Interfund Transfer Out ' .00 .00 Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 481 12/26/2019 PCards 11/27/19 - 12/26/19 refridgerator 481 12/26/2019 PCards 11/27/19 - 12/26/19 refridgerator 100.57 (77.85) 22.72 LOWES #00907* PC 539.00 561.72 LOWES #00907* PC Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 461.15 561.72 ** 2,500.00 Budgeted 1,938.28 Remaining 22 % Used Account: 135-65005-010-000 • Fuel & Lube 454 12/24/2019 Fuel Fuel -DEC 1,743.83 685.10 2,428.93 US Bank Voyager Fleet Systems 6049 AP Account: 135-65005-010-000 Fuel & Lube Totals: 685.10 2,428.93 ** 15,000.00 Budgeted 12,571.07 Remaining 16 % Used Account: 135-65010-010-000 Uniforms glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 433 12/20/2019 December A/P uniforms 481 12/26/2019 PCards 11/27/19 - 12/26/19 pants 481 12/26/2019 PCards 11/27/19 - 12/26/19 Bert Shoes 481 12/26/2019 PCards 11/27/19 - 12/26/19 pants 1,729.35 666.14 2,395.49 RON MONTGOMERY & ASSOC INC 6020 AP 162.95 2,558.44 ACADEMY SPORTS #141 PC 80.99 2,639.43 RED WING SHOES #573 PC 277.90 2,917.33 ACADEMY SPORTS *141 PC Account: 135-65010-010-000 Uniforms Totals: 1,187.98 2,917.33 ** 5,190.00 Budgeted 2,272.67 Remaining 56 % Used Account: 135-65030-010-000 Chemicals 402 12/12/2019 December A/P chlorine 464 12/30/2019 December A/P testing supplies 464 12/30/2019 December A/P chlorine 3,331.56 446.72 416.67 670.09 3,778.28 DPC INDUSTRIES, INC 4,194.95 HACH COMPANY 4,865.04 DPC INDUSTRIES, INC 5990 AP 6033 AP 6032 AP Account: 135-65030-010-000 Chemicals Totals: 1,533.48 4,865.04 ** 20,000.00 Budgeted 15,134.96 Remaining 24 % Used Account: 135-65035-010-000 Small Tools .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 6 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 8,875.28 .00 8,875.28 Account: 135-65050-010-000 Meter Expense Totals: .00 8,875.28 ** 70,000.00 Budgeted 61,124.72 Remaining 13 % Used Account: 135-65053-010-000 Meter Change Out Program .00 .00 Account: 135-65053-010-000 Meter Change Out Program Totals: .00 .00 ** 87,000.00 Budgeted 87,000.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-010-000 402 12/12/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P Capital Outlays Storz fittings & cups Badger touch pad 2020 dodge 2500 Indian Creek & Phoenix Final p 29,804.38 4,858.52 34,662.90 Core 6 Main LP 5988 AP 5,200.00 39,862.90 ATLAS UTILITY SUPPLY CO. 6003 AP 30,114.00 69,976.90 Grapevine Dodge Chrysler Jeep 6009 AP 20,591.13 90,568.03 Quality Excavation, LTD 6018 AP Account: 135-69005-010-000 Capital Outlays Totals: 60,763.65 90,568.03 ** 684,875.00 Budgeted 594,306.97 Remaining 13 % Used Account: 135-69008-010-000 Short Term Debt -Principal .00 .00 Account: 135-69008-010-000 Short Term Debt -Principal Totals: .00 .00 ** Account: 135-69009-010-000 30,512.00 Budgeted 30,512.00 Remaining Short Term Debt -Interest 0 % Used .00 .00 Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 .00 ** 3,231.00 Budgeted 3,231.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement Account: 135-69195-010-000 75,000.00 .00 75,000.00 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 57,932.73 .00 57,932.73 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 57,932.73 ** 120,000.00 Budgeted 62,067.27 Remaining 48 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 402 12/12/2019 December A/P 433 12/20/2019 December A/P TCEQ samples water samples 80.00 207.70 287.70 LOWER COLORADO RIVER AUTHORITY 5994 AP 100.00 387.70 TARRANT CTY PUBLIC HEALTH LAB 6022 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 307.70 387.70 ** 2,000.00 Budgeted 1,612.30 Remaining 19 % Used Department 10 Totals: 942,819.48 ** 297,152.35 Monthly Total 5,506,929.00 Budgeted 4,564,109.52 Remaining 17 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2019 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-020-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Salaries & Wages Salaries & Wages Salaries & Wages 56,681.48 14,544.58 71,226.06 PR 16,000.24 87,226.30 PR Account: 135-50005-020-000 Salaries & Wages Totals: 30,544.82 87,226.30 ** 441,799.00 Budgeted 354,572.70 Remaining 20 % Used Account: 135-50010-020-000 Overtime 391 12/13/2019 MUD Payroll 12/13/19 Overtime 4,187.98 1,311.64 445 12/27/2019 MUD Payroll 12/27/19 Overtime 600.10 5,499.62 6,099.72 PR PR Account: 135-50010-020-000 Overtime Totals: 1,911.74 6,099.72 ** 33,000.00 Budgeted 26,900.28 Remaining 18 % Used Account: 135-50016-020-000 Longevity 6,872.50 .00 6,872.50 Account: 135-50016-020-000 Longevity Totals: .00 6,872.50 ** 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 445 12/27/2019 MUD Payroll 12/27/19 Certification 1,250.00 650.00 1,900.00 PR Account: 135-50017-020-000 Certification Totals: 650.00 1,900.00 ** 9,000.00 Budgeted Account: 135-50020-020-000 Retirement 391 12/13/2019 MUD Payroll 12/13/19 Retirement 445 12/27/2019 MUD Payroll 12/27/19 Retirement 7,100.00 Remaining 21 % Used 7,920.39 1,466.71 9,387.10 1,595.65 10,982.75 PR PR Account: 135-50020-020-000 Retirement Totals: 3,062.36 10,982.75 ** 45,531.00 Budgeted Account: 135-50026-020-000 Medical Insurance 391 12/13/2019 MUD Payroll 12/13/19 Medical Insurance 445 12/27/2019 MUD Payroll 12/27/19 Medical Insurance Account: 135-50026-020-000 34,548.25 Remaining 24 % Used Medical Insurance Totals: 104,858.00 Budgeted 11,974.26 86,544.41 Remaining 17 % Used 2,993.58 14,967.84 3,345.75 18,313.59 6,339.33 18,313.59 ** PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Account: 135-50027-020-000 Account: 135-50028-020-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Dental Insurance Dental Insurance Dental Insurance Dental Insurance Totals: 5,817.00 Budgeted Vision Insurance Vision Insurance Vision Insurance 4,725.98 Remaining 716.30 118.44 19 % Used 179.09 195.63 895.39 1,091.02 374.72 1,091.02 ** 29.62 148.06 32.89 180.95 PR PR PR PR Account: 135-50028-020-000 Vision Insurance Totals: 62.51 180.95 ** 948.00 Budgeted 767.05 Remaining 19 % Used Account: 135-50029-020-000 Life Insurance & Other 351 12/01/2019 Payroll Benefits December 351 12/01/2019 Payroll Benefits December 464 12/30/2019 December A/P Employee LTD & STD Employee Benefits caf 125 -November 679.13 150.80 829.93 METLIFE GROUP BENEFITS 148.12 978.05 Humana Inc 36.00 1,014.05 BenefitMall 5975 AP 5972 AP 6028 AP Account: 135-50029-020-000 Life Insurance & Other Totals: 334.92 1,014.05 ** Account: 135-50030-020-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Account: 135-50030-020-000 Account: 135-50035-020-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 4,500.00 Budgeted 3,485.95 Remaining 23 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Totals: 30,494.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes 4,055.67 24,530.51 Remaining 20 % Used 948.49 924.82 983.00 1,907.82 4,980.49 5,963.49 5,963.49 ** 216.28 1,164.77 229.90 1,394.67 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 446.18 1,394.67 ** 7,132.00 Budgeted 5,737.33 Remaining 20 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted Account: 135-50045-020-000 Workman's Compensation 68 12/01/2019 Insurance/Wrk Comp Expense Dec Account: 135-50045-020-000 1,260.00 Remaining 0 % Used Workman's Compensation Totals: 15,373.00 Budgeted 12,042.40 Remaining 2,220.40 1,110.20 22 % Used 1,110.20 3,330.60 GL 3,330.60 ** Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations Account: 135-50070-020-000 Account: 135-55005-020-000 .00 Employee Relations Totals: .00 300.00 Budgeted 300.00 Remaining 0 % Used Engineering .00 .00 .00 ** .00 Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 3,000.00 .00 3,000.00 Account: 135-55070-020-000 Independent Labor Totals: .00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs 481 12/26/2019 PCards 11/27/19 - 12/26/19 coupling, pipette, tape 481 12/26/2019 PCards 11/27/19 - 12/26/19 ant killer, hand pump, RU Conc 6,686.82 38.31 6,725.13 THE HOME DEPOT #6581 PC 159.47 6,884.60 THE HOME DEPOT #6581 PC glpdatb2 skrolczyk Trophy Club MUD No.1 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 22 481 12/26/2019 PCards 11/27/19 - 12/26/19 coupling 481 12/26/2019 PCards 11/27/19 - 12/26/19 pump, pvc coupling 481 12/26/2019 PCards 11/27/19 - 12/26/19 kneepads 481 12/26/2019 PCards 11/27/19 - 12/26/19 concrete 481 12/26/2019 PCards 11/27/19 - 12/26/19 pvc coupling, cleaner, etc. 481 12/26/2019 PCards 11/27/19 - 12/26/19 repair supplies 481 12/26/2019 PCards 11/27/19 - 12/26/19 gate stems for MBAs 481 12/26/2019 PCards 11/27/19 - 12/26/19 pvc couplings, pvc tee, etc 464 12/30/2019 December A/P Butterfly valve WWTP 522 12/31/2019 December A/P Sewer clean up- 13 Heritage Co 6,686.82 7.91 258.82 39.94 153.60 29.94 46.48 3,600.65 39.20 175.50 4,388.28 6,892.51 GRAINGER 7,151.33 GRAINGER 7,191.27 THE HOME DEPOT #6581 7,344.87 THE HOME DEPOT 96581 7,374.81 THE HOME DEPOT #6581 7,421.29 THE HOME DEPOT 96581 11,021.94 MCW*WATERMANVALVE 11,061.14 THE HOME DEPOT #6581 11,236.64 Core & Main LP 15,624.92 Blackmon Mooring Company PC PC PC PC PC PC PC PC 6030 AP 6081 AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 8,938.10 15,624.92 ** 88,000.00 Budgeted 72,375.08 Remaining 18 % Used Account: 135-55081-020-000 Mainten & Repairs Collections 14,277.16 .00 14,277.16 Account: 135-55081-020-000 Mainten & Repairs Collections Totals: .00 14,277.16 ** 10,000.00 Budgeted (4,277.16) Remaining 143 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 481 12/26/2019 PCards 11/27/19 - 12/26/19 tire 162.48 241.75 404.23 DISCOUNT TIRE TXD 75 PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 241.75 404.23 ** 4,000.00 Budgeted 3,595.77 Remaining 10 % Used Account: 135-55091-020-000 Veh Maintenance Collections 481 12/26/2019 PCards 481 12/26/2019 PCards 11/27/19 11/27/19 - 12/26/19 vac truck registration fee - 12/26/19 Vac Truck Tags 1,837.08 1.00 22.00 1,838.08 1,860.08 DENTON COUNTY, TX SOUT DENTON COUNTY, TX SOUT PC PC Account: 135-55091-020-000 Veh Maintenance Collections Totals: 23.00 1,860.08 ** 8,000.00 Budgeted 6,139.92 Remaining 23 % Used glpdatb2 skrolczyk 12:50 01/13/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: 12/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 23 Check Source Number 433 12/20/2019 December A/P 464 12/30/2019 December A/P 464 12/30/2019 December A/P 475 12/31/2019 December A/P sludge haul off sludge haul off sludge haul off sludge grit -Invoice from June 12,239.42 Account: 135-55125-020-000 Dumpster Services Totals: 100,000.00 Budgeted 79,423.50 Remaining 21 % Used 1,342.30 2,489.92 3,659.86 845.00 13,581.72 L.H. CHANEY MATERIALS, INC. 16,071.64 L.H. CHANEY MATERIALS, INC. 19,731.50 L.H. CHANEY MATERIALS, INC. 20,576.50 L.H. CHANEY MATERIALS, INC. 6013 AP 6039 AP 6039 AP 6052 AP 8,337.08 20,576.50 ** Account: 135-55135-020-000 Lab Analysis 357 12/06/2019 December A/P 402 12/12/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 482 12/31/2019 December A/P 482 12/31/2019 December A/P 482 12/31/2019 December A/P 482 12/31/2019 December A/P 482 12/31/2019 December A/P lab testing annual slude lab testing lab testing lab testing lab testing lab testing lab testing Golf course lab testing lab testing lab testing lab testing 4,409.20 230.00 1,628.97 317.40 230.00 317.40 230.00 317.40 230.00 1,053.97 317.40 230.00 317.40 230.00 4,639.20 OXIDOR LABORATORIES LLC 6,268.17 OXIDOR LABORATORIES LLC 6,585.57 OXIDOR LABORATORIES LLC 6,815.57 OXIDOR LABORATORIES LLC 7,132.97 OXIDOR LABORATORIES LLC 7,362.97 OXIDOR LABORATORIES LLC 7,680.37 OXIDOR LABORATORIES LLC 7,910.37 OXIDOR LABORATORIES LLC 8,964.34 OXIDOR LABORATORIES LLC 9,281.74 OXIDOR LABORATORIES LLC 9,511.74 OXIDOR LABORATORIES LLC 9,829.14 OXIDOR LABORATORIES LLC 10,059.14 OXIDOR LABORATORIES LLC 5978 AP 5997 AP 6016 AP 6016 AP 6016 AP 6016 AP 6016 AP 6016 AP 6057 AP 6057 AP 6057 AP 6057 AP 6057 AP Account: 135-55135-020-000 Lab Analysis Totals: 5,649.94 10 -* 40,000.00 Budgeted 29,940.86 Remaining 25 % Used Account: 135-60010-020-000 Communications/Mobiles Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 433 12/20/2019 December A/P back hoe maintenance/John Deer (856.24) 1,360.92 504.68 RDO Construction Equipment Co 6019 AP Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 1,360.92 504.68 ** 3,000.00 Budgeted 2,495.32 Remaining 17 % Used Account: 135-55120-020-000 • Cleaning Services 433 12/20/2019 December A/P janitorial svc-November 87.50 87.50 175.00 MEMBER'S BUILDING MAINTENANCE 6015 AP Account: 135-55120-020-000 Cleaning Services Totals: 87.50 175.00 ** 1,500.00 Budgeted 1,325.00 Remaining 12 % Used Account: 135-55125-020-000 Dumpster Services 433 12/20/2019 December A/P 464 12/30/2019 December A/P 464 12/30/2019 December A/P 475 12/31/2019 December A/P sludge haul off sludge haul off sludge haul off sludge grit -Invoice from June 12,239.42 Account: 135-55125-020-000 Dumpster Services Totals: 100,000.00 Budgeted 79,423.50 Remaining 21 % Used 1,342.30 2,489.92 3,659.86 845.00 13,581.72 L.H. CHANEY MATERIALS, INC. 16,071.64 L.H. CHANEY MATERIALS, INC. 19,731.50 L.H. CHANEY MATERIALS, INC. 20,576.50 L.H. CHANEY MATERIALS, INC. 6013 AP 6039 AP 6039 AP 6052 AP 8,337.08 20,576.50 ** Account: 135-55135-020-000 Lab Analysis 357 12/06/2019 December A/P 402 12/12/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 433 12/20/2019 December A/P 482 12/31/2019 December A/P 482 12/31/2019 December A/P 482 12/31/2019 December A/P 482 12/31/2019 December A/P 482 12/31/2019 December A/P lab testing annual slude lab testing lab testing lab testing lab testing lab testing lab testing Golf course lab testing lab testing lab testing lab testing 4,409.20 230.00 1,628.97 317.40 230.00 317.40 230.00 317.40 230.00 1,053.97 317.40 230.00 317.40 230.00 4,639.20 OXIDOR LABORATORIES LLC 6,268.17 OXIDOR LABORATORIES LLC 6,585.57 OXIDOR LABORATORIES LLC 6,815.57 OXIDOR LABORATORIES LLC 7,132.97 OXIDOR LABORATORIES LLC 7,362.97 OXIDOR LABORATORIES LLC 7,680.37 OXIDOR LABORATORIES LLC 7,910.37 OXIDOR LABORATORIES LLC 8,964.34 OXIDOR LABORATORIES LLC 9,281.74 OXIDOR LABORATORIES LLC 9,511.74 OXIDOR LABORATORIES LLC 9,829.14 OXIDOR LABORATORIES LLC 10,059.14 OXIDOR LABORATORIES LLC 5978 AP 5997 AP 6016 AP 6016 AP 6016 AP 6016 AP 6016 AP 6016 AP 6057 AP 6057 AP 6057 AP 6057 AP 6057 AP Account: 135-55135-020-000 Lab Analysis Totals: 5,649.94 10 -* 40,000.00 Budgeted 29,940.86 Remaining 25 % Used Account: 135-60010-020-000 Communications/Mobiles glpdatb2 skrolczyk 12:50 01/13/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 402 12/12/2019 December A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 12/2019 JE Detail Beginning Balance Description/Comment Cell phones -December 1,174.83 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 410.83 1,585.66 VERIZON WIRELESS Page 24 Check Source Number 6001 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 410.83 1,585.66 ** 5,000.00 Budgeted 3,414.34 Remaining 32 % Used Account: 135-60020-020-000 Electricity 402 12/12/2019 December A/P electricity 10/29-11/27 433 12/20/2019 December A/P Electricity 11/8-12/10 515 12/31/2019 Town Billed Invoices 1718-1721 AR 20191231-20191231 User: 22,687.12 372.93 12,659.63 (576.33) 23,060.05 35,719.68 35,143.35 TRI COUNTY ELECTRIC HUDSON ENERGY SERVICES, LLC 6000 6011 AP AP AR Account: 135-60020-020-000 Electricity Totals: 12,456.23 35,143.35 ** 160,067.00 Budgeted 124,923.65 Remaining 22 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 481 12/26/2019 PCards 11/27/19 - 12/26/19 L Holt WW operator license 111.00 111.00 TCEQ EPAYMENT PC Account: 135-60070-020-000 Dues & Memberships Totals: 111.00 111.00 ** 300.00 Budgeted 189.00 Remaining 37 % Used Account: 135-60080-020-000 Schools & Training 481 12/26/2019 PCards 11/27/19 - 12/26/19 Training 481 12/26/2019 PCards 11/27/19 - 12/26/19 training refund 1,173.53 299.95 (2.63) 1,473.48 1,470.85 SKILLPATH / NATIONAL SKILLPATH / NATIONAL PC PC Account: 135-60080-020-000 Schools & Training Totals: 297.32 1,470.85 ** 4,990.00 Budgeted 3,519.15 Remaining 29 % Used Account: 135-60090-020-000 Safety Program 528 12/31/2019 December A/P gloves 528 12/31/2019 December A/P lockout station 56.82 52.32 56.82 109.14 Ritz Safety, LLC Ritz Safety, LLC 6091 6091 AP AP Account: 135-60090-020-000 Safety Program Totals: 109.14 109.14 ** 1,000.00 Budgeted 890.86 Remaining 11 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60100-020-000 Travel & per diem Account: 135-60100-020-000 Account: 135-60105-020-000 Account: 135-60105-020-000 Account: 135-60125-020-000 Account: 135-60125-020-000 Account: 135-60135-020-000 464 12/30/2019 December A/P 356.71 Travel & per diem Totals: 1,545.00 Budgeted 1,188.29 Remaining 23 5 Used Rent/Lease Equipment Rent/Lease Equipment Totals: 5,000.00 Budgeted Advertising 5,000.00 Remaining 0 % Used .00 356.71 .00 356.71 ** .00 .00 .00 .00 ** .00 Advertising Totals: 2,500.00 Budgeted 2,500.00 Remaining 0 5 Used TCEQ Fees & Permits stormwater permit FY20 .00 .00 .00 ** 9,888.02 200.00 10,088.02 TX COMMISSION ENVIRONMENTAL QU 6048 AP Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 200.00 10,088.02 ** Account: 135-60245-020-000 Account: 135-60245-020-000 Account: 135-60280-020-000 Account: 135-60280-020-000 15,000.00 Budgeted Miscellaneous Expenses Miscellaneous Expenses 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 4,911.98 Remaining 67 % Used Totals: 450.00 Remaining 0 8 Used Totals: 5,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 .00 .00 ** .00 .00 .00 .00 ** glpdatb2 skrolczyk 12:50 01/13/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: 12/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Page 26 Check Source Number Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,000.00 Budgeted 14,000.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 474 12/31/2019 TexPool Transfers December TexPool O&M to I&S- PID Debt 20,829.62 10,414.81 31,244.43 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax ISS Totals: 10,414.81 31,244.43 ** 114,563.00 Budgeted 83,318.57 Remaining 27 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 474 12/31/2019 TexPool Transfers December TexPool O&M to Rev Bd WWTP I&S 122,520.80 474 12/31/2019 TexPool Transfers December TexPool O&M to 19 W&WW Rev I&S 54,421.63 6,839.07 176,942.43 183,781.50 GL GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 61,260.70 183,781.50 ** 673,867.00 Budgeted 490,085.50 Remaining 27 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 474 12/31/2019 TexPool Transfers December TexPool O&M to Rev Bond Resevr 11,500.00 5,750.00 17,250.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 5,750.00 17,250.00 ** 125,187.00 Budgeted 107,937.00 Remaining 14 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 190.00 .00 190.00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 190.00 ** 2,000.00 Budgeted 1,810.00 Remaining 10 % Used Account: 135-65005-020-000 Fuel & Lube glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 454 12/24/2019 Fuel Fuel -DEC 1,830.04 505.14 2,335.18 US Bank Voyager Fleet Systems 6049 AP Account: 135-65005-020-000 Fuel & Lube Totals: 505.14 2,335.18 ** 12,500.00 Budgeted 10,164.82 Remaining 19 % Used Account: 135-65010-020-000 Uniforms 433 12/20/2019 December A/P uniforms 3,003.93 504.00 3,507.93 RON MONTGOMERY & ASSOC INC 6020 AP Account: 135-65010-020-000 Uniforms Totals: 504.00 3,507.93 ** 5,495.00 Budgeted 1,987.07 Remaining 64 % Used Account: 135-65030-020-000 Chemicals 433 12/20/2019 December A/P 522 12/31/2019 December A/P polymer 3,394.96 2,856.60 6,251.56 POLYDYNE, INC 6017 AP sodium hypo 569.00 6,820.56 Valley Solvent Company, INC 6090 AP Account: 135-65030-020-000 Chemicals Totals: 3,425.60 6,820.56 ** 20,000.00 Budgeted 13,179.44 Remaining 34 % Used Account: 135-65031-020-000 Chemicals Collections 4,994.00 .00 4,994.00 Account: 135-65031-020-000 Chemicals Collections Totals: .00 4,994.00 ** 17,500.00 Budgeted 12,506.00 Remaining 29 % Used Account: 135-65035-020-000 Small Tools .00 .00 Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 6 Used Account: 135-65040-020-000 Safety Equipment 464 12/30/2019 December A/P non -potable water signs 179.12 179.12 HD SUPPLY FACILITIES MAINT LTD 6034 AP 528 12/31/2019 December A/P gloves 43.42 222.54 Ritz Safety, LLC 6091 AP 528 12/31/2019 December A/P glove liners 183.20 405.74 Ritz Safety, LLC 6091 AP 528 12/31/2019 December A/P drum accumulation center 683.18 1,088.92 Ritz Safety, LLC 6091 AP Account: 135-65040-020-000 Safety Equipment Totals: 1,088.92 1,088.92 ** 1,200.00 Budgeted 111.08 Remaining 91 % Used glpdatb2 skrolczyk 12:50 01/13/20 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-65045-020-000 464 12/30/2019 December A/P 475 12/31/2019 December A/P 522 12/31/2019 December A/P 522 12/31/2019 December A/P Account: 135-65045-020-000 Account: 135-69005-020-000 433 12/20/2019 December A/P 433 12/20/2019 December A/P 464 12/30/2019 December A/P 493 12/30/2019 recut CK to seperate invoices 494 12/31/2019 December A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 12/2019 JE Detail Beginning Balance Description/Comment Lab Supplies PH -probe gel Lab PH meter lab suplies lab supplies Lab Supplies 20,000.00 Budgeted Totals: 11,993.61 Remaining 3,978.33 40 % Used Program: Transaction Detail 476.94 1,794.94 372.55 1,383.63 4,028.06 Transaction Vendor_Name Detail (SUBTOTAL) 4,455.27 6,250.21 6,622.76 8,006.39 HACH COMPANY HACH COMPANY HACH COMPANY IDEXX DISTRIBUTION, INC 8,006.39 ** Page 28 Check Source Number 6033 AP 6051 AP 6083 AP 6085 AP Capital Outlays Hose's for capital Hose's for capital WWTP Sound curtain/building WWTP Sound curtain/building WWTP Sound curtain/building Account: 135-69005-020-000 Capital Outlays Totals: 530,500.00 Budgeted 436,284.15 Remaining 90,592.30 1,876.80 92,469.10 1,246.75 93,715.85 500.00 94,215.85 (500.00) 93,715.85 500.00 94,215.85 18 % Used 3,623.55 Stuart Hose & Pipe Stuart Hose & Pipe TOWN OF TROPHY CLUB TOWN OF TROPHY CLUB TOWN OF TROPHY CLUB 94,215.85 ** 6021 AP 6021 AP 6047 AP 6047 AP 6080 AP Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 Short Term Debt -Principal Totals: 79,133.00 Budgeted 79,133.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Short Term Debt -Interest Totals: 11,277.00 Budgeted 11,277.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-69195-020-000 Gasb34/Reserve for Replacement Account: 135-69195-020-000 Department 20 Totals: 130,000.00 Gasb34/Reserve for Replacement Totals: 130,000.00 Budgeted .00 Remaining 175,568.19 Monthly Total 100 % Used .00 130,000.00 .00 130,000.00 ** 743,150.84 ** 3,157,421.00 Budgeted 2,414,270.16 Remaining 24 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 68 12/01/2019 Insurance/Wrk Comp Expense Dec Account: 135-50045-026-000 Account: 135-60066-026-000 Account: 135-60066-026-000 Account: 135-60070-026-000 Account: 135-60070-026-000 Workman's Compensation Totals: 3.98 1.99 5.97 GL 30.00 Budgeted 24.03 Remaining 20 5 Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining Dues & Memberships Dues & Memberships Totals: 750.00 Budgeted 675.00 1.99 5.97 ** .00 0 % Used .00 .00 .00 ** .00 675.00 75.00 Remaining 90 5 Used Account: 135-60075-026-000 Meetings 481 12/26/2019 PCards 11/27/19 - 12/26/19 Candy for board meeting .00 675.00 ** 156.36 14.20 170.56 WM SUPERCENTER #5247 PC Account: 135-60075-026-000 _ Meetings Totals: 14.20 170.56 ** 1,300.00 Budgeted 1,129.44 Remaining 13 % Used Account: 135-60080-026-000 Schools & Training .00 .00 Account: 135-60080-026-000 Schools & Training Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 6 Used Account: 135-60100-026-000 Travel & per diem .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 5,000.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2019 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 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 851.53 ** 16.19 Monthly Total 13,230.00 Budgeted 12,378.47 Remaining 6 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2019 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-030-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Salaries & Wages Salaries & Wages Salaries & Wages 58,807.67 15,084.97 73,892.64 PR 15,071.01 88,963.65 PR Account: 135-50005-030-000 Salaries & Wages Totals: 30,155.98 88,963.65 ** Account: 135-50010-030-000 628,298.00 Budgeted ertime 391 12/13/2019 MUD Payroll 12/13/19 Overtime Account: 135-50010-030-000 Overtime 2,000.00 Budgeted 539,334.35 Remaining 14 % Used 3.11 8.71 11.82 PR Totals: 1,988.18 Remaining 1 5 Used 8.71 11.82 ** Account: 135-50016-030-000 Longevity 2,207.50 .00 2,207.50 Account: 135-50016-030-000 Longevity Totals: .00 2,207.50 ** 2,208.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 391 12/13/2019 MUD Payroll 12/13/19 Retirement 445 12/27/2019 MUD Payroll 12/27/19 Retirement 7,149.98 1,396.16 8,546.14 PR 1,394.08 9,940.22 PR Account: 135-50020-030-000 Retirement Totals: 2,790.24 9,940.22 ** Account: 135-50026-030-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 58,554.00 Budgeted Medical Insurance Medical Insurance Medical Insurance 48,613.78 Remaining 17 % Used 10,977.62 2,744.43 13,722.05 PR 2,744.38 16,466.43 PR Account: 135-50026-030-000 Medical Insurance Totals: 5,488.81 16,466.43 ** Account: 135-50027-030-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 124,394.00 Budgeted Dental Insurance Dental Insurance Dental Insurance 107,927.57 Remaining 135 Used 612.80 153.21 766.01 PR 153.19 919.20 PR Account: 135-50027-030-000 Dental Insurance Totals: 306.40 919.20 ** 6,464.00 Budgeted 5,544.80 Remaining 14 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-030-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Vision Insurance Vision Insurance Vision Insurance 97.54 24.40 121.94 PR 24.37 146.31 PR Account: 135-50028-030-000 Vision Insurance Totals: 48.77 146.31 ** 1,035.00 Budgeted 888.69 Remaining 14 % Used Account: 135-50029-030-000 Life Insurance & Other 351 12/01/2019 Payroll Benefits December 351 12/01/2019 Payroll Benefits December 464 12/30/2019 December A/P Employee LTD & STD Employee Benefits caf 125 -November 622.42 151.69 774.11 METLIFE GROUP BENEFITS 149.52 923.63 Humana Inc 20.00 943.63 BenefitMall 5975 AP 5972 AP 6028 AP Account: 135-50029-030-000 Life Insurance & Other Totals: 321.21 943.63 ** Account: 135-50030-030-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Account: 135-50030-030-000 . 4,500.00 Budgeted 3,556.37 Remaining 21 % Used Social Security Taxes Social Security Taxes Social Security Taxes 3,596.13 873.42 4,469.55 868.88 5,338.43 PR PR Social Security Taxes Totals: 1,742.30 5,338.43 ** 39,215.00 Budgeted Account: 135-50035-030-000 391 12/13/2019 MUD Payroll 12/13/19 445 12/27/2019 MUD Payroll 12/27/19 Account: 135-50035-030-000 Account: 135-50040-030-000 Account: 135-50040-030-000 Medicare Taxes Medicare Taxes Medicare Taxes 33,876.57 Remaining 14 % Used Medicare Taxes Totals: 841.04 9,171.00 Budgeted 7,922.47 Remaining 14 % Used Unemployment Taxes Unemployment Taxes Totals: 1,440.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 68 12/01/2019 Insurance/Wrk Comp Expense Dec 1,440.00 Remaining 0 % Used 204.28 203.21 407.49 .00 1,045.32 1,248.53 1,248.53 ** .00 .00 .00 ** PR PR 209.64 104.82 314.46 GL glpdatb2 skrolczyk 12:50 01/13/20 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-50045-030-000 JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 12/2019 JE Detail Beginning Balance Description/Comment Workman's Compensation 1,775.00 Budgeted Totals: 1,460.54 Remaining Program: Transaction Detail 18 % Used 104.82 Transaction Vendor_Name Detail (SUBTOTAL) 314.46 ** Page 33 Check Source Number Account: 135-50060-030-000 Pre-emp Physicals/Testing Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 500.00 Budgeted 500.00 Remaining 0 % Used .00 .00 .00 ** Account: 135-50070-030-000 Employee Relations - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 481 481 481 481 481 481 481 481 481 481 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 12/26/2019 Account: 135-50070-030-000 Account: 135-55030-030-000 433 12/20/2019 433 12/20/2019 481 12/26/2019 481 12/26/2019 481 12/26/2019 481 12/26/2019 475 12/31/2019 Account: 135-55030-030-000 PCards PCards PCards PCards PCards PCards PCards PCards PCards PCards 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 11/27/19 gift cards for Christmas party Christmas Party Food Christmas party drinks,gcs Christmas party gifts Christmas party GCs and Gifts Christmas party gifts name tags Christmas Party GCs, decor GCs for Christmas party Desiree get well flowers Employee Relations Totals: 8,000.00 Budgeted 4,921.90 Remaining 286.22 38 6 Used Software & Support Peak software annual fee internet-December Internet Internet internet Adobe subscription Microsoft exchange December A/P December A/P PCards 11/27/19 PCards 11/27/19 PCards 11/27/19 PCards 11/27/19 December A/P Account: 135-55070-030-000 482 12/31/2019 December A/P - 12/26/19 - 12/26/19 - 12/26/19 - 12/26/19 Software & Support Totals: 134,681.00 Budgeted 61,276.87 Remaining Independent Labor GM -December 68,197.45 55 6 Used 400.00 686.22 269.93 956.15 95.41 1,051.56 30.21 1,081.77 225.40 1,307.17 37.29 1,344.46 3.93 1,348.39 661.53 2,009.92 1,000.00 3,009.92 68.18 3,078.10 2,791.88 ACADEMY SPORTS 976 COTTON PATCH CAFE - GR TOM THUMB 81789 WAL-MART 85247 WALGREENS 96047 FIVE BELOW 1168 AMAZON.COM*6Q5Z80CH3 WM SUPERCENTER 85247 TOM THUMB 81789 FYF*FROMYOUFLOWERS 3,078.10 ** 3,638.25 71,835.70 899.00 72,734.70 42.37 72,777.07 42.37 72,819.44 53.91 72,873.35 36.78 72,910.13 494.00 73,404.13 5,206.68 GRANICUS, INC Charter Communications ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS M3 Networks 73,404.13 ** PC PC PC PC PC PC PC PC PC PC 6010 AP 6004 AP PC PC PC PC 6053 AP 23,380.71 10,640.00 34,020.71 Carman Consulting LLC. 6056 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 482 12/31/2019 December A/P GM -December 23,380.71 15.08 34,035.79 Carman Consulting LLC. Account: 135-55070-030-000 Account: 135-55080-030-000 475 12/31/2019 December A/P Account: 135-55080-030-000 Independent Labor Totals: 10,655.08 34,035.79 ** 135,000.00 Budgeted 100,964.21 Remaining 25 % Used Maintenance & Repairs Fire alarm monitoring -Dec 2019 515.00 540.00 1,055.00 PRO FIRE & SPRINKLER LLC Maintenance & Repairs Totals: 540.00 1,055.00 ** 15,000.00 Budgeted 13,945.00 Remaining 7 % Used Account: 135-55085-030-000 Generator Maint. and Repair Account: 135-55085-030-000 Account: 135-55120-030-000 433 12/20/2019 December A/P Account: 135-55120-030-000 Account: 135-55160-030-000 Account: 135-55160-030-000 Account: 135-55205-030-000 433 12/20/2019 December A/P Account: 135-55205-030-000 .00 Generator Maint. and Repair Totals: .00 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Cleaning Services janitorial svc-November 869.06 869.06 Cleaning Services Totals: 869.06 10,000.00 Budgeted 8,261.88 Remaining 17 % Used Professional Outside Services .00 Professional Outside Services Totals: .00 65,600.00 Budgeted 65,600.00 Remaining 0 % Used Utility Billing Contract November billings 582.15 1,117.54 Utility Billing Contract Totals: 1,117.54 9,000.00 Budgeted 7,300.31 Remaining Account: 135-60005-030-000 Telephone 481 12/26/2019 PCards 11/27/19 - 12/26/19 phone service 19 % Used 2,967.78 180.20 .00 .00 ** 6056 AP 6054 AP 1,738.12 MEMBER'S BUILDING MAINTENANCE 6015 AP 1,738.12 ** .00 .00 ** 1,699.69 DATAPROSE LLC 6006 AP 1,699.69 ** 3,147.98 ATT*BILL PAYMENT PC glpdatb2 skrolczyk 12:50 01/13/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 481 12/26/2019 PCards 11/27/19 - 12/26/19 481 12/26/2019 PCards 11/27/19 - 12/26/19 481 12/26/2019 PCards 11/27/19 - 12/26/19 466 12/30/2019 December A?P 515 12/31/2019 Town Billed Invoices 1718-1721 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 12/2019 JE Detail Beginning Balance Description/Comment phone service phone service answering service Answering service -December AR 20191231-20191231 User: 2,967.78 Program: Transaction Detail 793.33 471.71 14.99 207.75 (180.00) Transaction Vendor_Name Detail (SUBTOTAL) 3,941.31 4,413.02 4,428.01 4,635.76 4,455.76 ATT*BUS PHONE PMT ATT*BUS PHONE PMT RINGCENTRAL, INC KEYSTONE PARK SECRETARIAL Page 35 Check Source Number PC PC PC 6037 AP AR Account: 135-60005-030-000 Telephone Totals: 1,487.98 4,455.76 ** 23,680.00 Budgeted 19,224.24 Remaining 19 % Used Account: 135-60010-030-000 Communications/Mobiles 402 12/12/2019 December A/P 445 12/27/2019 MUD Payroll 12/27/19 Cell phones -December Communications/Mobiles 476.04 88.02 150.00 564.06 714.06 VERIZON WIRELESS 6001 AP PR Account: 135-60010-030-000 Communications/Mobiles Totals: 238.02 714.06 ** 4,000.00 Budgeted 3,285.94 Remaining 18 % Used Account: 135-60020-030-000 Electricity/Gas 402 12/12/2019 December A/P Gexa energy 10/10-11/8 592.00 592.00 TOWN OF TROPHY CLUB 5999 AP Account: 135-60020-030-000 Electricity/Gas Totals: 592.00 592.00 ** 6,879.00 Budgeted 6,287.00 Remaining 9 % Used Account: 135-60025-030-000 Water 482 12/31/2019 December A/P 515 12/31/2019 Town Billed Invoices water -December 1718-1721 AR 20191231-20191231 User: 123.18 123.17 (61.58) 246.35 184.77 TROPHY CLUB MUD (WATER BILLS) 6059 AP AR Account: 135-60025-030-000 Water Totals: 61.59 184.77 ** 1,500.00 Budgeted 1,315.23 Remaining 12 % Used Account: 135-60035-030-000 Postage 433 12/20/2019 December A/P November billings 1,776.04 3,099.91 4,875.95 DATAPROSE LLC 6006 AP Account: 135-60035-030-000 Postage Totals: 3,099.91 4,875.95 ** 30,000.00 Budgeted 25,124.05 Remaining 16 5 Used Account: 135-60040-030-000 Service Charges & Fees 509 12/31/2019 Pace Credit Card Fees 14,270.78 6,326.72 20,597.50 GL 509 12/31/2019 Pace Credit Card Fees 135.17 20,732.67 GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees Totals: 67,000.00 Budgeted 46,267.33 Remaining 31 % Used 6,461.89 20,732.67 ** Account: 135-60050-030-000 Bad Debt Expense Account: 135-60050-030-000 .00 .00 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 68 12/01/2019 Insurance/Wrk Comp Expense Dec 388 12/09/2019 December A/P Bond notary renewal Laurie Sla Account: 135-60055-030-000 Insurance 84,000.00 Budgeted 13,996.78 Totals: 62,983.83 Remaining 25 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 481 12/26/2019 PCards 11/27/19 - 12/26/19 Election laws book Account: 135-60066-030-000 Account: 135-60070-030-000 433 12/20/2019 December A/P 433 12/20/2019 December A/P Publications/Books/Subscripts Totals: 1,000.00 Budgeted 875.00 Remaining Dues & Memberships Dues 2020 Social security program fee 13 % Used 6,998.39 20,995.17 GL 21.00 21,016.17 Secretary of State/Notary Div 5987 AP 7,019.39 21,016.17 ** 125.00 125.00 TEXASELECTIONLAWS.COM PC 125.00 ** 125.00 200.00 3,851.55 4,051.55 Texas Rural Water Assoc 6024 AP 35.00 4,086.55 TX SOCIAL SECURITY PROGRAM 6026 AP Account: 135-60070-030-000 Dues & Memberships Totals: 3,886.55 4,086.55 ** 6,000.00 Budgeted Account: 135-60075-030-000 Meetings 481 12/26/2019 PCards 11/27/19 - 12/26/19 Safety Meeting 482 12/31/2019 December A/P GM -December 1,913.45 Remaining 68 % Used 35.18 15.69 50.87 WM SUPERCENTER 95247 10.50 61.37 Carman Consulting LLC. PC 6056 AP Account: 135-60075-030-000 Meetings Totals: 26.19 61.37 ** 400.00 Budgeted 338.63 Remaining 15 % Used Account: 135-60079-030-000 Public Education glpdatb2 skrolczyk 12:50 01/13/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 Period Ending: 12/2019 JE Detail Beginning Balance Description/Comment 476.20 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 476.20 Page 37 Check Source Number 481 12/26/2019 PCards 11/27/19 - 12/26/19 fuel 481 12/26/2019 PCards 11/27/19 - 12/26/19 meal 481 12/26/2019 PCards 11/27/19 - 12/26/19 hotel 481 12/26/2019 PCards 11/27/19 - 12/26/19 meal 481 12/26/2019 PCards 11/27/19 - 12/26/19 fuel 481 12/26/2019 PCards 11/27/19 - 12/26/19 meal 481 12/26/2019 PCards 11/27/19 - 12/26/19 meal 445 12/27/2019 MUD Payroll 12/27/19 Travel & per diem 464 12/30/2019 December A/P tolls to lab 128.08 21.24 149.32 CONOCO - TOMMYS 20 2 4.32 153.64 TACO BELL #016048 QPS 428.00 581.64 DOUBLETREE 16.24 597.88 RENAISSANCE HOTELS 22.44 620.32 LOVE S TRAVEL 00007195 23.46 643.78 HYDE PARK BAR & GRILL 19.72 663.50 DOUBLETREE AUSTIN FB N 8.24 671.74 15.15 686.89 NTTA PC PC PC PC PC PC PC PR 6043 AP Account: 135-60100-030-000 Travel & per diem Totals: 558.81 686.89 ** 3,545.00 Budgeted 2,858.11 Remaining Account: 135-60079-030-000 Public Education Totals: 135-60110-030-000 Physicals/Testing .00 476.20 ** 6,000.00 Budgeted 5,523.80 Remaining 8 % Used Account: 135-60110-030-000 Physicals/Testing Account: 135-60080-030-000 .00 .00 Schools & Training 200.00 Budgeted 200.00 Remaining 0 % Used 481 12/26/2019 PCards 11/27/19 - 12/26/19 Gaap update training 972.71 180.00 1,152.71 GOVERNMENT FINANCE OFF PC Account: 135-60080-030-000 .00 43.01 Schools & Training Totals: 135-60115-030-000 Elections 180.00 1,152.71 ** 43.01 ** .00 Budgeted 6,850.00 Budgeted 5,697.29 Remaining 17 % Used Account: 135-60125-030-000 Advertising Account: 135-60100-030-000 Travel & per diem 481 12/26/2019 PCards 11/27/19 - 12/26/19 fuel 481 12/26/2019 PCards 11/27/19 - 12/26/19 meal 481 12/26/2019 PCards 11/27/19 - 12/26/19 hotel 481 12/26/2019 PCards 11/27/19 - 12/26/19 meal 481 12/26/2019 PCards 11/27/19 - 12/26/19 fuel 481 12/26/2019 PCards 11/27/19 - 12/26/19 meal 481 12/26/2019 PCards 11/27/19 - 12/26/19 meal 445 12/27/2019 MUD Payroll 12/27/19 Travel & per diem 464 12/30/2019 December A/P tolls to lab 128.08 21.24 149.32 CONOCO - TOMMYS 20 2 4.32 153.64 TACO BELL #016048 QPS 428.00 581.64 DOUBLETREE 16.24 597.88 RENAISSANCE HOTELS 22.44 620.32 LOVE S TRAVEL 00007195 23.46 643.78 HYDE PARK BAR & GRILL 19.72 663.50 DOUBLETREE AUSTIN FB N 8.24 671.74 15.15 686.89 NTTA PC PC PC PC PC PC PC PR 6043 AP Account: 135-60100-030-000 Travel & per diem Totals: 558.81 686.89 ** 3,545.00 Budgeted 2,858.11 Remaining 19 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 43.01 .00 43.01 Account: 135-60115-030-000 Elections Totals: .00 43.01 ** .00 Budgeted (43.01) Remaining 0 % Used Account: 135-60125-030-000 Advertising glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60125-030-000 Account: 135-60235-030-000 433 12/20/2019 December A/P Account: 135-60235-030-000 .00 .00 Advertising Totals: .00 .00 ** 2,500.00 Budgeted Security monitoring svc-dec 2,500.00 Remaining 0 % Used 48.00 24.00 72.00 Digital Air Control, Inc Security Totals: 24.00 72.00 ** 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses 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 1,216.00 Remaining 6 % Used Miscellaneous Expenses Totals: 500.00 Budgeted 500.00 Remaining 0 % Used General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Furniture/Equipment < $5000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Uniforms Uniforms Totals: 2,050.00 Budgeted Account: 135-65055-030-000 Hardware 464 12/30/2019 December A/P GM laptop 0 o Used 0 % Used 2,050.00 Remaining 0 % Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 6008 AP 1,779.32 1,779.32 M3 Networks 6041 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 475 12/31/2019 December A/P WWTP computer 1,455.92 3,235.24 M3 Networks 6053 AP Account: 135-65055-030-000 Hardware Totals: 3,235.24 3,235.24 ** 26,485.00 Budgeted 23,249.76 Remaining 12 % Used Account: 135-65085-030-000 Office Supplies 402 12/12/2019 December A/P 402 12/12/2019 December A/P 464 12/30/2019 December A/P 464 12/30/2019 December A/P Business cards -Bert office supplies office supplies office supplies 1,099.62 58.00 1,157.62 SIGMA SIGNS & PRINTING 158.99 1,316.61 OFFICE DEPOT, INC 153.33 1,469.94 OFFICE DEPOT, INC 207.80 1,677.74 OFFICE DEPOT, INC 5998 AP 5996 AP 6044 AP 6044 AP Account: 135-65085-030-000 Office Supplies Totals: 578.12 1,677.74 ** 6,000.00 Budgeted 4,322.26 Remaining 28 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 481 12/26/2019 PCards 11/27/19 - 12/26/19 water, cups, pt, tp, lysol 677.72 250.23 927.95 SAMSCLUB.COM PC 481 12/26/2019 PCards 11/27/19 - 12/26/19 coffee 31.98 959.93 AMZN MKTP US*KK2FH6CR3 PC 481 12/26/2019 PCards 11/27/19 - 12/26/19 hand sanatizer 89.27 1,049.20 AMAZON.COM*6S05N3VA3 PC 481 12/26/2019 PCards 11/27/19 - 12/26/19 Tea 13.42 1,062.62 AMAZON.COM*IM5FA5L13 PC 481 12/26/2019 PCards 11/27/19 - 12/26/19 tea 12.29 1,074.91 AMAZON.COM*FP9XU60W3 PC 481 12/26/2019 PCards 11/27/19 - 12/26/19 coffee 56.99 1,131.90 AMZN MKTP US*C71OJ6853 PC 481 12/26/2019 PCards 11/27/19 - 12/26/19 coffee 55.23 1,187.13 AMAZON.COM*4E5NE9243 PC 481 12/26/2019 PCards 11/27/19 - 12/26/19 gloves 33.75 1,220.88 AMZN MKTP US*P08WL7LQ3 PC Account: 135-65095-030-000 _ Maintenance Supplies Totals: 543.16 1,220.88 ** 4,000.00 Budgeted 2,779.12 Remaining 31 % Used Account: 135-65105-030-000 Printing .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 6 Used glpdatb2 skrolczyk 12:50 01/13/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 Period Ending: 12/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 40 Check Source Number Department 30 Totals: 4,000.00 Budgeted 90,975.44 Monthly Total 3,204.02 Remaining 20 % Used 307,715.96 ** 1,776,712.00 Budgeted 1,468,996.04 Remaining 17 % Used Account: 135-69005-030-000 Capital Outlays .00 .00 Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** 195,000.00 Budgeted 195,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 433 12/20/2019 December A/P 467 12/30/2019 December A/P copier lease-dec copies 493.36 165.00 137.62 658.36 795.98 TIAA COMMERCIAL FINANCE KYOCERA DOCUMENT SOLUTIONS 6025 6038 AP AP Account: 135-69170-030-000 Copier Lease Installments Totals: 302.62 795.98 ** Department 30 Totals: 4,000.00 Budgeted 90,975.44 Monthly Total 3,204.02 Remaining 20 % Used 307,715.96 ** 1,776,712.00 Budgeted 1,468,996.04 Remaining 17 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 402 12/12/2019 December A/P 402 12/12/2019 December A/P Legal Southlake easement legal 25,504.93 7,732.96 2,070.00 33,237.89 WHITAKER CHALK SWINDLE 6002 AP 35,307.89 McLean & Howard, L.L.P. 5995 AP Account: 135-55045-039-000 Legal Totals: 9,802.96 35,307.89 ** 135,000.00 Budgeted 99,692.11 Remaining 26 % Used Account: 135-55055-039-000 Auditing 15,150.00 .00 15,150.00 Account: 135-55055-039-000 Auditing .00 15,150.00 ** 33,800.00 Budgeted 18,650.00 Remaining 45 % Used Account: 135-55060-039-000 Appraisal 321 12/02/2019 December A/P Tax Year 2019 Annual Appraisal 433 12/20/2019 December A/P 1st qtr 2020 appraisel/DCAD (13.35) 2,948.43 2,935.08 TARRANT APPRAISAL DISTRICT 5966 AP 2,243.48 5,178.56 DENTON CENTRAL APPRAISAL DISTR 6007 AP Account: 135-55060-039-000 Appraisal Totals: 5,191.91 5,178.56 ** 11,761.00 Budgeted 6,582.44 Remaining 44 % Used Account: 135-55065-039-000 Tax Admin Fees 557 12/17/2019 Tax Collection fees/Denton Cty 3,756.00 3,756.00 GL Account: 135-55065-039-000 Tax Admin Fees Totals: 3,756.00 3,756.00 ** 4,000.00 Budgeted 244.00 Remaining 94 % Used Department 39 Totals: 59,392.45 ** 18,750.87 Monthly Total 184,561.00 Budgeted 125,168.55 Remaining 32 % Used Fund 135 Totals: (69,680.54) (110,634.40) Monthly Total (6,224.00) Budgeted 63,456.54 Remaining ########## glpdatb2 skrolczyk 12:50 01/13/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: 12/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 42 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 DECEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL / UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 550,368 TOTAL ASSETS 550,368 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (118,410) NET REVENUES / EXPENDITURES (16,698) TOTAL FUND BALANCE (135,109) TOTAL LIABILITIES AND FUND BALANCE 550,368 glbase_tbam skrolczyk 12:51 01/13/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 12/2019 Amended Total Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 14 517-49011-000-000 Interest Income 783.15- 2,605.23- 2,605.23 Subtotal: 783.15- 2,605.23- 2,605.23 Program number: 783.15- 2,605.23- 2,605.23 Department number: Revenues 783.15- 2,605.23- 2,605.23 Revenues Subtotal 783.15- 2,605.23- 2,605.23 glbase tbam skrolczyk Trophy Club MUD No.1 Page 15 12:51 01/13/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 12,912.50 19,303.50 19,303.50 - Subtotal: 12,912.50 19,303.50 19,303.50 - Program number: 12,912.50 19,303.50 19,303.50 - Department number: Wastewater 12,912.50 19,303.50 19,303.50 - Expenditures Subtotal 12,912.50 19,303.50 19,303.50 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 12,129.35 16,698.27 16,698.27- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/2019 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 503 12/31/2019 Bank Interest- December (1,822.08) Account: 517-49011-000-000 Interest Income Totals: .00 Budgeted 2,605.23 Remaining 0 6 Used (783.15) (2,605.23) GL (783.15) (2,605.23) ** Department Totals: (2,605.23) ** (783.15) Monthly Total .00 Budgeted 2,605.23 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 402 12/12/2019 December A/P 402 12/12/2019 December A/P 464 12/30/2019 December A/P Account: 517-69005-020-000 Capital Outlays Soil testing WWTP WWTP Legal fees WWTP soil legal 6,391.00 7,250.00 4,170.00 1,492.50 13,641.00 ECS Southwest, LLP 17,811.00 CP&Y/WALLACE GROUP, INC. 19,303.50 Wiss, Janney, Elstner Assoc Capital Outlays Totals: 12,912.50 19,303.50 ** .00 Budgeted (19,303.50) Remaining 0 % Used Department 20 Totals: 19,303.50 ** 12,912.50 Monthly Total .00 Budgeted (19,303.50) Remaining 0 % Used Fund 517 Totals: 16,698.27 12,129.35 Monthly Total .00 Budgeted (16,698.27) Remaining 0 % Used 5991 AP 5989 AP 6050 AP TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET DECEMBER 2019 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 782,771 TOTAL ASSETS 782,771 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 2,432 701,080 782,771 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 12:51 01/13/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49011-000-000 Interest Income 2,432.45- 2,432.45- 2,432.45 Subtotal: 2,432.45- 2,432.45- 2,432.45 Program number: 2,432.45- 2,432.45- 2,432.45 Department number: Revenues 2,432.45- 2,432.45- 2,432.45 Revenues Subtotal 2,432.45- 2,432.45- 2,432.45 Fund number: 519 2016 Rev Bond Const -SWIFT 2,432.45- 2,432.45- 2,432.45 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 12/2019 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 560 12/31/2019 Swift & Sers19 Bond Escrow Int October 2019 Interest (941.56) (941.56) GL 560 12/31/2019 Swift & Sers19 Bond Escrow Int November 2019 Interest (819.09) (1,760.65) GL 560 12/31/2019 Swift & Sers19 Bond Escrow Int December 2019 interest (671.80) (2,432.45) GL Account: 519-49011-000-000 Interest Income Totals: (2,432.45) (2,432.45) ** .00 Budgeted 2,432.45 Remaining 0 % Used Department Totals: (2,432.45) ** (2,432.45) Monthly Total .00 Budgeted 2,432.45 Remaining 0 % Used Fund 519 Totals: (2,432.45) (2,432.45) Monthly Total .00 Budgeted 2,432.45 Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET DECEMBER 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 556,551 INVESTMENTS 3,881,637 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,438,188 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,102) 4,438,188 4,438,188 glbase tbam skrolczyk 12:51 01/13/20 Fund: 520 Revenue Bond 16" Waterline Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 12/2019 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Remaining Budget Page 17 520-49011-000-000 Interest Income 12,868.97- 14,636.18- 14,636.18 Subtotal: 12,868.97- 14,636.18- 14,636.18 Program number: 12,868.97- 14,636.18- 14,636.18 Department number: 12,868.97- 14,636.18- 14,636.18 Revenues Subtotal 12,868.97- 14,636.18- 14,636.18 glbase tbam skrolczyk 12:51 01/13/20 Fund: 520 Revenue Bond 16" Waterline Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 12/2019 Adopted Amended Total Budget Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 18 520-69005-010-000 Capital Outlays 24,734.48 30,737.98 30,737.98 - Subtotal: 24,734.48 30,737.98 30,737.98 - Program number: 24,734.48 30,737.98 30,737.98 - Department number: Water Department 24,734.48 30,737.98 30,737.98 - Expenditures Subtotal 24,734.48 30,737.98 30,737.98 - Fund number: 520 Revenue Bond 16" Waterline 11,865.51 16,101.80 16,101.80- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-49011-000-000 Interest Income 503 12/31/2019 Bank Interest- December 560 12/31/2019 Swift & Sers19 Bond Escrow Int October 2019 Interest 560 12/31/2019 Swift & Sers19 Bond Escrow Int November 2019 Interest 560 12/31/2019 Swift & Sers19 Bond Escrow Int December 2019 interest (1,767.21) (806.87) (2,574.08) GL (4,669.05) (7,243.13) GL (4,061.71) (11,304.84) GL (3,331.34) (14,636.18) GL Account: 520-49011-000-000 Interest Income Totals: (12,868.97) (14,636.18) ** .00 Budgeted 14,636.18 Remaining 0 % Used Department Totals: (14,636.18) ** (12,868.97) Monthly Total .00 Budgeted 14,636.18 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 12/2019 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 402 12/12/2019 December A/P 402 12/12/2019 December A/P Account: 520-69005-010-000 Department 10 Totals: Fund 520 Totals: Capital Outlays Water Line Interconnect 16" waterline easement acquisi 6,003.50 8,440.57 16,293.91 14,444.07 Halff Associates, INC 5992 AP 30,737.98 Jackson Walker LLP 5993 AP Capital Outlays Totals: 24,734.48 30,737.98 ** .00 Budgeted (30,737.98) Remaining 0 % Used 24,734.48 Monthly Total .00 Budgeted 11,865.51 Monthly Total .00 Budgeted 30,737.98 ** (30,737.98) Remaining 0 % Used 16,101.80 (16,101.80) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET DECEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 838,083 TOTAL ASSETS 838,083 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 34,626 838,083 838,083 glbase_tbam skrolczyk 12:51 01/13/20 Fund: 528 2015 Revenue Bond Reserve Fund Department: Account Description 528-49011-000-000 528-49142-000-000 528-49143-000-000 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund Trophy Club MUD No.1 Page 19 Budget Summary with Amendment Program: Period Ending: 12/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 11,000.00- 307,049.00- 200,417.00- 11,000.00- 307,049.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 1,139.61- 4,600.00- 5,750.00- 11,489.61- 3,576.40- 13,800.00- 17,250.00- 34,626.40- 11,489.61- 34,626.40- 11,489.61- 11,489.61- 11,489.61- 34,626.40- 34,626.40- 34,626.40- 32.513 4.494 8.607 6.679 7,423.60- 293,249.00- 183,167.00- 483,839.60- 6.679 483,839.60- 6.679 6.679 6.679 483,839.60- 483,839.60- 483,839.60- glpdatb2 skrolczyk 12:50 01/13/20 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 528-49011-000-000 Interest Income 503 12/31/2019 Bank Interest- December Account: 528-49011-000-000 Trophy Club MUD No.1 Page 48 Detailed Accounting Trial Balance Program: Period Ending: 12/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (11,000.00) Budgeted (2,436.79) (1,139.61) (7,423.60) Remaining 33 6 Used Account: 528-49142-000-000 Interfund transfer in -Water 474 12/31/2019 TexPool Transfers December TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (307,049.00) Budgeted (293,249.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 474 12/31/2019 TexPool Transfers December TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: Interfund transfer in -WW Totals: (3,576.40) GL (1,139.61) (3,576.40) ** (9,200.00) (4,600.00) (13,800.00) GL (11,500.00) (200,417.00) Budgeted (183,167.00) Remaining (11,489.61) Monthly Total 4 % Used (4,600.00) (13,800.00) ** (5,750.00) (17,250.00) GL 9 % Used (518,466.00) Budgeted (11,489.61) Monthly Total (518,466.00) Budgeted (5,750.00) (17,250.00) ** (34,626.40) ** (483,839.60) Remaining 7 6 Used (34,626.40) (483,839.60) Remaining 7 6 Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET DECEMBER 2019 ASSETS CASH IN BANK INVESTMENTS 467,518 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 358,499 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 826,017 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 358,499 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 358,499 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES 384,564 TOTAL FUND BALANCE 467,518 TOTAL LIABILITIES AND FUND BALANCE 826,017 glbase tbam skrolczyk 12:51 01/13/20 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 12/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 310,257.16- 61.08- 12.08- 352,726.88- 213.48 153.24- 51.686 -21.348 7.662 329,714.12- 1,213.48- 1,846.76 - Page 20 Subtotal: 685,441.00- 685,441.00- 310,330.32- 352,666.64- 51.451 332,774.36- 533-49011-000-000 1 533-49015-000-000 Interest Income Lease/Rental Income 5,000.00- 218,004.00- 5,000.00- 218,004.00- 348.61- 652.46- 13.049 4,347.54- 218,004.00- 533-49141-000-000 Interfund Trans In -PID Surchg 114,563.00- 114,563.00- 10,414.81- 31,244.43- 27.273 83,318.57 - Subtotal: 337,567.00- 337,567.00- 10,763.42- 31,896.89- 9.449 305,670.11 - Program number: 1,023,008.00- 1,023,008.00- 321,093.74- 384,563.53- 37.591 638,444.47 - Department number: Revenues 1,023,008.00- 1,023,008.00- 321,093.74- 384,563.53- 37.591 638,444.47 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 321,093.74- 384,563.53- 37.591 638,444.47- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 12:51 01/13/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 533-70025-051-000 Bond Interest Expense -Tax 247,858.00 247,858.00 533-70035-051-000 Bond Principal Payment -Tax 765,000.00 765,000.00 Subtotal: 1,015,008.00 1,015,008.00 Program number: 1,015,008.00 1,015,008.00 Department number: Administration 1,015,008.00 1,015,008.00 Expenditures Subtotal 1,015,008.00 1,015,008.00 Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 321,093.74- 384,563.53- 4,807.044 2,150.00 247,858.00 765,000.00 1,015,008.00 1,015,008.00 1,015,008.00 1,015,008.00 376,563.53 glpdatb2 skrolczyk Trophy Club MUD No.1 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 49 Check Source Number Account: 533-40000-000-000 Property Taxes 534 12/02/2019 Property Taxes 535 12/03/2019 Property Taxes 537 12/04/2019 Property Taxes 538 12/05/2019 Property Taxes 539 12/06/2019 Property Taxes 540 12/09/2019 Property Taxes 542 12/10/2019 Property Taxes 543 12/11/2019 Property Taxes 544 12/12/2019 Property Taxes 545 12/13/2019 Property Taxes 546 12/16/2019 Property Taxes 547 12/17/2019 Property Taxes 548 12/18/2019 Property Taxes 549 12/19/2019 Property Taxes 550 12/20/2019 Property Taxes 551 12/23/2019 Property Taxes 552 12/26/2019 Property Taxes 553 12/27/2019 Property Taxes 554 12/30/2019 Property Taxes 555 12/31/2019 Property Taxes (42,469.72) (1,653.20) (2,590.40) (3,340.62) (1,441.53) (2,016.50) (3,863.13) (4,686.43) (5,167.25) (5,599.88) (5,284.48) (131,997.04) (58,681.23) (3,339.08) (4,491.62) (20,882.11) (18,034.99) (13,535.13) (9,245.83) (6,954.64) (7,452.07) (44,122.92) (46,713.32) (50,053.94) (51,495.47) (53,511.97) (57,375.10) (62,061.53) (67,228.78) (72,828.66) (78,113.14) (210,110.18) (268,791.41) (272,130.49) (276,622.11) (297,504.22) (315,539.21) (329,074.34) (338,320.17) (345,274.81) (352,726.88) 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: (310,257.16) (352,726.88) ** (682,441.00) Budgeted (329,714.12) Remaining 52 6 Used Account: 533-40002-000-000 Property Taxes/Delinquent 534 12/02/2019 Property Taxes 535 12/03/2019 Property Taxes 539 12/06/2019 Property Taxes 549 12/19/2019 Property Taxes 552 12/26/2019 Property Taxes 274.56 (8.77) (8.24) (9.05) (20.84) (14.18) 265.79 257.55 248.50 227.66 213.48 GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (61.08) 213.48 ** (1,000.00) Budgeted (1,213.48) Remaining -21 % Used Account: 533-40015-000-000 Property Taxes/P & I 534 12/02/2019 Property Taxes 535 12/03/2019 Property Taxes 539 12/06/2019 Property Taxes 549 12/19/2019 Property Taxes 552 12/26/2019 Property Taxes (141.16) (2.98) (1.28) (2.09) (3.13) (2.60) (144.14) (145.42) (147.51) (150.64) (153.24) GL GL GL GL GL glpdatb2 skrolczyk 12:50 01/13/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 12/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 50 Check Source Number Department Totals: (114,563.00) Budgeted (321,093.74) Monthly Total (83,318.57) Remaining 27 6 Used (384,563.53) ** (1,023,008.00) Budgeted (638,444.47) Remaining 38 5 Used Account: 533-40015-000-000 Property Taxes/P & I Totals: (12.08) (153.24) ** (2,000.00) Budgeted (1,846.76) Remaining 8 5 Used Account: 533-49011-000-000 Interest Income 503 12/31/2019 Bank Interest- December (303.85) (348.61) (652.46) GL Account: 533-49011-000-000 Interest Income Totals: (348.61) (652.46) ** (5,000.00) Budgeted (4,347.54) Remaining 13 % 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 474 12/31/2019 TexPool Transfers December TexPool O&M to I&S- PID Debt (20,829.62) (10,414.81) (31,244.43) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,414.81) (31,244.43) ** Department Totals: (114,563.00) Budgeted (321,093.74) Monthly Total (83,318.57) Remaining 27 6 Used (384,563.53) ** (1,023,008.00) Budgeted (638,444.47) Remaining 38 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee Account: 533-70005-051-000 Paying Agent Fee Totals: 2,150.00 Budgeted 2,150.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 533-70025-051-000 Bond Interest Expense -Tax Account: 533-70025-051-000 Account: 533-70035-051-000 Department 51 Totals: .00 .00 Bond Interest Expense -Tax Totals: .00 .00 ** 247,858.00 Budgeted 247,858.00 Remaining .00 .00 Bond Principal Payment -Tax Totals: .00 .00 ** 765,000.00 Budgeted 765,000.00 Remaining 0 % Used .00 ** Account: 533-70035-051-000 Bond Principal Payment -Tax 0 % Used .00 Monthly Total 1,015,008.00 Budgeted 1,015,008.00 Remaining 0 % Used Fund 533 Totals: (384,563.53) (321,093.74) Monthly Total (8,000.00) Budgeted 376,563.53 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET DECEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 188,162 TOTAL ASSETS 188,162 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 163,645 188,162 188,162 glbase tbam skrolczyk 12:51 01/13/20 Fund: 534 2015 Revenue Bond I&S Account 534-49011-000-000 534-49143-000-000 Description Interest Income Interfund Transfer In -WW Sales Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 2,500.00- 598,638.00- 601,138.00- 601,138.00- 601,138.00- 601,138.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 12/2019 Amended Total Budget Encumb. 2,500.00- 598,638.00- 601,138.00- 601,138.00- 601,138.00- 601,138.00 - Program: Current YTD Month Total 186.46- 380.35- 54,421.63- 163,264.29- 54,608.09- 163,644.64- 54,608.09- 163,644.64- 54,608.09- 163,644.64- 54,608.09- 163,644.64- % of Budget Remaining Budget 15.214 2,119.65- 27.273 435,373.71- 27.222 437,493.36- 27.222 437,493.36- 27.222 437,493.36- 27.222 437,493.36 - Page 22 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 12:51 01/13/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 208,238.00 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 Subtotal: 598,638.00 598,638.00 598,638.00 Program number: 598,638.00 598,638.00 598,638.00 Department number: Administration 598,638.00 598,638.00 598,638.00 Expenditures Subtotal 598,638.00 598,638.00 598,638.00 Fund number: 534 2015 Revenue Bond I&S 2,500.00- 2,500.00- 54,608.09- 163,644.64- 6,545.786 161,144.64 glpdatb2 skrolczyk 12:50 01/13/20 Fund: 534 2015 Revenue Bond ISS JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 12/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 52 Check Source Number Department Totals: (598,638.00) Budgeted (54,608.09) Monthly Total (435,373.71) Remaining 27 % Used (601,138.00) Budgeted (163,644.64) ** (437,493.36) Remaining 27 % Used Account: 534-49011-000-000 Interest Income 503 12/31/2019 Bank Interest- December (193.89) (186.46) (380.35) GL Account: 534-49011-000-000 = Interest Income Totals: (186.46) (380.35) ** (2,500.00) Budgeted (2,119.65) Remaining 15 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 474 12/31/2019 TexPool Transfers December TexPool O&M to Rev Bd WWTP ISS (108,842.66) (54,421.63) (163,264.29) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (163,264.29) ** Department Totals: (598,638.00) Budgeted (54,608.09) Monthly Total (435,373.71) Remaining 27 % Used (601,138.00) Budgeted (163,644.64) ** (437,493.36) Remaining 27 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond IBS Department: 51 Administration Program: Period Ending: 12/2019 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 Rev Bond Paying Agent Fee Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 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 O 6 Used .00 .00 .00 .00 ** .00 O % Used .00 .00 .00 ** Account: 534-70045-051-000 Revenue Bond Principal Expense Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining Department 51 Totals: Fund 534 Totals: .00 .00 O % Used .00 Monthly Total 598,638.00 Budgeted (54,608.09) Monthly Total .00 .00 ** .00 ** 598,638.00 Remaining 0 % Used (163,644.64) (2,500.00) Budgeted 161,144.64 Remaining 9999666666 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET DECEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 80,257 TOTAL ASSETS 80,257 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 4,967 75,290 80,257 TOTAL LIABILITIES AND FUND BALANCE 80,257 glbase tbam skrolczyk 12:51 01/13/20 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49011-000-000 535-49142-000-000 Subtotal: Program number: Department number: Revenues Revenues Description Interest Income Interfund Tran In -Water Sales Subtotal Department: Adopted Budget 1,000.00- 275,525.00- 276,525.00- 276,525.00- 276,525.00- 276,525.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 12/2019 Amended Total Budget Encumb. 1,000.00- 275,525.00- 276,525.00- 276,525.00- 276,525.00- 276,525.00 - Program: Current YTD Month Total 77.08- 147.29- 25,047.72- 75,143.16- 25,124.80- 75,290.45- 25,124.80- 75,290.45- 25,124.80- 75,290.45- 25,124.80- 75,290.45- % of Budget Remaining Budget 14.729 852.71- 27.273 200,381.84- 27.227 201,234.55- 27.227 201,234.55- 27.227 201,234.55- 27.227 201,234.55 - Page 24 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 12:51 01/13/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 12/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account Description 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 535-70040-051-000 Revenue Bond Interest Expense 386,811.00 386,811.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: 602,611.00 602,611.00 Program number: 602,611.00 Department number: Administration Expenditures Subtotal Fund number: 535 2016 Rev Bond I&S-SWIFT 800.00 386,811.00 215,000.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 326,086.00 326,086.00 25,124.80- 75,290.45- -23.089 602,611.00 602,611.00 401,376.45 glpdatb2 skrolczyk 12:50 01/13/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: 12/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 54 Check Source Number Department Totals: (275,525.00) Budgeted (25,124.80) Monthly Total (200,381.84) Remaining 27 % Used (276,525.00) Budgeted (75,290.45) ** (201,234.55) Remaining 27 % Used Account: 535-49011-000-000 Interest Income 503 12/31/2019 Bank Interest- December (70.21) (77.08) (147.29) GL Account: 535-49011-000-000 Interest Income Totals: (77.08) (147.29) ** (1,000.00) Budgeted (852.71) Remaining 15 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 474 12/31/2019 TexPool Transfers December TexPool O&M to 16Swift Rev I&S (50,095.44) (25,047.72) (75,143.16) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,047.72) (75,143.16) ** Department Totals: (275,525.00) Budgeted (25,124.80) Monthly Total (200,381.84) Remaining 27 % Used (276,525.00) Budgeted (75,290.45) ** (201,234.55) Remaining 27 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 12/2019 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 Rev Bond Paying Agent Fee Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: 800.00 Budgeted 800.00 Remaining Account: 535-70040-051-000 Revenue Bond Interest Expense Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 386,811.00 Remaining O 6 Used .00 .00 .00 .00 ** .00 O % Used Account: 535-70045-051-000 Revenue Bond Principal Expense Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining Department 51 Totals: Fund 535 Totals: O % Used .00 Monthly Total 602,611.00 Budgeted (25,124.80) Monthly Total .00 .00 .00 ** .00 .00 .00 .00 ** .00 ** 602,611.00 Remaining 0 % Used (75,290.45) 326,086.00 Budgeted 401,376.45 Remaining -23 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET DECEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 89,354 TOTAL ASSETS 89,354 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 89,354 TOTAL FUND BALANCE 89,354 TOTAL LIABILITIES AND FUND BALANCE 89,354 glbase tbam skrolczyk Trophy Club MUD No.1 12:51 01/13/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 12/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 536-49011-000-000 536-49142-000-000 536-49143-000-000 Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales Subtotal: Program number: Department number: Revenues Revenues Subtotal Fund number: 536 2019 Rev Bond I&S- W&WW System End of Report ********* 83.36- 149.05- 22,896.02- 68,688.06- 6,839.07- 20,517.21- 29,818.45- 89,354.32- 29,818.45- 89,354.32- 29,818.45- 89,354.32- 29,818.45- 89,354.32- 29,818.45- 89,354.32- 149.05 68,688.06 20,517.21 89,354.32 89,354.32 89,354.32 89,354.32 89,354.32 Page 26 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 12:50 01/13/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 12/2019 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 503 12/31/2019 Bank Interest- December (65.69) Account: 536-49011-000-000 Interest Income Totals: .00 Budgeted 149.05 Remaining 0 8 Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 474 12/31/2019 TexPool Transfers December TexPool O&M to 19 W&WW Rev I&S (45,792.04) Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: .00 Budgeted 68,688.06 Remaining Account: 536-49143-000-000 Interfund Transfer In -WW Sales 474 12/31/2019 TexPool Transfers December TexPool O&M to 19 W&WW Rev I&S (13,678.14) Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 Budgeted 20,517.21 Remaining (83.36) (149.05) GL (83.36) (149.05) ** (22,896.02) (68,688.06) GL 0 8 Used (22,896.02) (68,688.06) ** (6,839.07) (20,517.21) GL 0 % Used (6,839.07) (20,517.21) ** Department Totals: (89,354.32) ** (29,818.45) Monthly Total .00 Budgeted 89,354.32 Remaining 0 % Used Fund 536 Totals: (89,354.32) (29,818.45) Monthly Total .00 Budgeted 89,354.32 Remaining 0 8 Used Grand Totals: (1,305,760.67) **** (1,021,872.05) Monthly Total (209,104.00) Budgeted 1,096,656.67 Remaining 624 8 Used ******* End of Report *********