Loading...
HomeMy WebLinkAbout2019-02 Combined Financials February 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET FEBRUARY 2019 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 900,021 PREPAID EXPENSES 10,438 ADVALOREM PROPERTY TAXES RECEIVABLE 54,626 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 965,085 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 54,626 TOTAL LIABILITIES 54,626 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 366,576 TOTAL FUND BALANCE 910,460 TOTAL LIABILITIES AND FUND BALANCE 965,085 glbase_tbam skrolczyk 18:02 03/13/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 122-40010-000-000 1 122-40011-000-000 1 122-40020-000-000 Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&i Trophy Club MUD No.1 Page 1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 2/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 85,163.61- 1,267.24- 2,126.76- 1,075,105.98- 1,933.26- 2,561.59- 96.249 41,894.02- 1,933.26 2,561.59 Subtotal: 1,117,000.00- 1,117,000.00- 88,557.61- 1,079,600.83- 96.652 37,399.17- 122-49035-000-000 Prior Year Reserves 75,000.00- 75,000.00- 75,000.00 - Subtotal: 75,000.00- 75,000.00- 75,000.00 - Program number: 1,192,000.00- 1,192,000.00- 88,557.61- 1,079,600.83- 90.571 112,399.17 - Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 88,557.61- 1,079,600.83- 90.571 112,399.17 - Revenues Subtotal 1,192,000.00- 1,192,000.00- 88,557.61- 1,079,600.83- 90.571 112,399.17- glbase_tbam skrolczyk 18:02 03/13/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 1 122-60030-045-000 1 122-60055-045-000 1 122-60337-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Program: Period Ending: 2/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 215,979.00 18,000.00 674,452.00 215,979.00 18,000.00 674,452.00 215,979.00 1,491.21 56,204.33 215,979.00 7,456.05 281,021.32 100.000 41.423 41.667 10,543.95 393,430.68 Page 2 Subtotal: 908,431.00 908,431.00 273,674.54 504,456.37 55.531 403,974.63 122-69005-045-000 1 122-69195-045-000 Capital Outlays GASB34/Reserve for Replacement 75,000.00 81,420.00 75,000.00 81,420.00 81,420.00 100.000 75,000.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 283,569.00 283,569.00 208,568.60 73.551 75,000.40 Program number: 1,192,000.00 1,192,000.00 273,674.54 713,024.97 59.818 478,975.03 Department number: Fire 1,192,000.00 1,192,000.00 273,674.54 713,024.97 59.818 478,975.03 Expenditures Subtotal 1,192,000.00 1,192,000.00 273,674.54 713,024.97 59.818 478,975.03 Fund number: 122 Trophy Club MUD Fire Dept. 185,116.93 366,575.86- 366,575.86 glpdatb2 skrolczyk 18:02 03/13/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 2/2019 JE Detail Description/Comment Page 1 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 882 02/01/2019 Property Taxes 885 02/04/2019 Property Taxes 886 02/05/2019 Property Taxes 888 02/06/2019 Property Taxes 933 02/06/2019 Property Taxes- correct JE 888 889 02/07/2019 Property Taxes 890 02/08/2019 Property Taxes 891 02/11/2019 Property Taxes 892 02/12/2019 Property Taxes 893 02/13/2019 Property Taxes 894 02/14/2019 Property Taxes 895 02/15/2019 Property Taxes 896 02/19/2019 Property Taxes 897 02/20/2019 Property Taxes 898 02/21/2019 Property Taxes 899 02/22/2019 Property Taxes 900 02/25/2019 Property Taxes 908 02/26/2019 Property Taxes 902 02/28/2019 Property Taxes (989,942.37) (9,128.78) (999,071.15) GL (10,635.98) (1,009,707.13) GL (19,222.93) (1,028,930.06) GL (13,792.98) (1,042,723.04) GL (.04) (1,042,723.08) GL (21,796.50) (1,064,519.58) GL (543.66) (1,065,063.24) GL (59.66) (1,065,122.90) GL (613.39) (1,065,736.29) GL (1,372.31) (1,067,108.60) GL (229.25) (1,067,337.85) GL (245.54) (1,067,583.39) GL (6,690.55) (1,074,273.94) GL 374.31 (1,073,899.63) GL (306.92) (1,074,206.55) GL 177.82 (1,074,028.73) GL (257.95) (1,074,286.68) GL (722.81) (1,075,009.49) GL (96.49) (1,075,105.98) GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (85,163.61) (1,075,105.98) ** (1,117,000.00) Budgeted (41,894.02) Remaining 96 6 Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 882 02/01/2019 Property Taxes 886 02/05/2019 Property Taxes 888 02/06/2019 Property Taxes 889 02/07/2019 Property Taxes 893 02/13/2019 Property Taxes 894 02/14/2019 Property Taxes 900 02/25/2019 Property Taxes 901 02/27/2019 Property Taxes 902 02/28/2019 Property Taxes (666.02) (.20) (666.22) GL (205.58) (871.80) GL (.52) (872.32) GL (7.46) (879.78) GL (.40) (880.18) GL 42.57 (837.61) GL (76.07) (913.68) GL (983.41) (1,897.09) GL (36.17) (1,933.26) GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (1,267.24) (1,933.26) ** .00 Budgeted 1,933.26 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P6I 882 02/01/2019 Property Taxes (434.83) 885 02/04/2019 Property Taxes (32.12) (466.95) GL (28.89) (495.84) GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 886 02/05/2019 Property Taxes 888 02/06/2019 Property Taxes 889 02/07/2019 Property Taxes 890 02/08/2019 Property Taxes 891 02/11/2019 Property Taxes 892 02/12/2019 Property Taxes 893 02/13/2019 Property Taxes 894 02/14/2019 Property Taxes 895 02/15/2019 Property Taxes 896 02/19/2019 Property Taxes 898 02/21/2019 Property Taxes 900 02/25/2019 Property Taxes 908 02/26/2019 Property Taxes 901 02/27/2019 Property Taxes 902 02/28/2019 Property Taxes Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: .00 Budgeted 2,561.59 Remaining (434.83) (74.26) (570.10) GL (.06) (570.16) GL (18.00) (588.16) GL (34.86) (623.02) GL (29.79) (652.81) GL (42.92) (695.73) GL (96.13) (791.86) GL (16.04) (807.90) GL (17.20) (825.10) GL (1,479.15) (2,304.25) GL (22.57) (2,326.82) GL (37.05) (2,363.87) GL (53.58) (2,417.45) GL (58.21) (2,475.66) GL (85.93) (2,561.59) GL 0 % Used (2,126.76) (2,561.59) ** Account: 122-49035-000-000 Prior Year Reserves Account: 122-49035-000-000 Department Totals: Prior Year Reserves Totals: (75,000.00) Budgeted (75,000.00) Remaining 0 % Used .00 .00 .00 .00 ** (1,079,600.83) ** (88,557.61) Monthly Total (1,192,000.00) Budgeted (112,399.17) Remaining 91 % Used glpdatb2 skrolczyk 18:02 03/13/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 2/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 3 Check Source Number Department 45 Totals: 127,149.00 Budgeted 273,674.54 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 713,024.97 ** 478,975.03 Remaining 60 % Used Account: 122-60030-045-000 Rent And/Or Usage 832 02/28/2019 Fire Rent Transfer 2019 215,979.00 215,979.00 GL Account: 122-60030-045-000 Rent And/Or Usage Totals: 215,979.00 215,979.00 ** 215,979.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 129 02/01/2019 Insurance/Wrk Comp Expense Feb 5,964.84 1,491.21 7,456.05 GL Account: 122-60055-045-000 Insurance Totals: 1,491.21 7,456.05 ** 18,000.00 Budgeted 10,543.95 Remaining 41 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 833 02/28/2019 February A/P Fire admin February 224,816.99 56,204.33 281,021.32 TOWN OF TROPHY CLUB 5061 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 56,204.33 281,021.32 ** 674,452.00 Budgeted 393,430.68 Remaining 42 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 75,000.00 Budgeted 75,000.00 Remaining 0 % 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 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** Department 45 Totals: 127,149.00 Budgeted 273,674.54 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 713,024.97 ** 478,975.03 Remaining 60 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: (366,575.86) 185,116.93 Monthly Total .00 Budgeted 366,575.86 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET FEBRUARY 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 1,207,236 1,207,236 CASH IN BANK -SAVINGS -CASH RESERVE 1,187,212 1,187,212 INVESTMENTS-TEXPOOL 3,434,708 782,846 4,217,554 PREPAID EXPENSES 63,323 63,323 ADVALOREM PROPERTY TAXES RECEIVABLE 6,109 6,109 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,060,388 2,060,388 TOTAL ASSETS 7,959,575 782,846 8,742,421 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 6,109 6,109 ACCOUNTS AND OTHER PAYABLES 411,001 411,001 CUSTOMER DEPOSITS 314,915 314,915 TOTAL LIABILITIES 732,025 732,025 FUND BALANCE NON -SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 1,906,543 1,906,543 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 225,000 225,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 150,000 150,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 97,805 97,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 310,041 310,041 UNASSIGNED FUND BALANCE 5,709,156 5,709,156 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES (396,635) (396,635) TOTAL FUND BALANCE 7,227,550 782,846 8,010,396 TOTAL LIABILITIES AND FUND BALANCE 7,959,575 782,846 8,742,421 glbase_tbam skrolczyk 18:02 03/13/19 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-49010-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 135-49901-000-000 Subtotal: Program number: 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 Records Management Revenue Department number: Revenues Revenues Subtotal Department: Adopted Budget 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 20,000.00- 14,146.00- 7,000.00- 10,000.00- 18,522.00- 7,000.00- 76,668.00- 10,613,202.00- 10,613,202.00- 10,613,202.00- Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 2/2019 Amended Total Budget Encumb. 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 20,000.00- 14,146.00- 7,000.00- 10,000.00- 18,522.00- 7,000.00- 76,668.00- 10,613,202.00- 10,613,202.00- 10,613,202.00- Current Month 9,696.42- 142.04- 242.23 - Program: YTD Total 122,407.60- 235.93- 299.88- 10,080.69- 122,943.41- 289,938.68- 1,471,118.77- 273,743.49- 1,273,879.44- 8,344.32- 42,657.07- 1,400.00- 7,150.00- 300.00- 550.00- 900.00- 1,650.00- 17.60- 574,626.49- 2,797,022.88- 11,719.99- 1,178.81- 583.33- 52,600.00- 2,401.00- 5,170.07- 73,653.20- 51,407.70- 6,220.72- 2,916.65- 52,600.00- 4,116.00- 8,378.15- 2.00- 125,641.22- 658,360.38- 3,045,607.51- 658,360.38- 3,045,607.51- 658,360.38- 3,045,607.51- % of Budget 92.464 78.643 99.960 40.314 22.291 37.328 31.269 42.059 36.667 36.667 .029 Remaining Budget 9,976.40- 64.07- .12- 171,983.00- 182,023.59- 5,128,365.23- 2,138,785.56- 93,760.93- 9,850.00- 950.00- 2,850.00- 59,982.40- 27.337 7,434,544.12- 257.039 43.975 41.666 526.000 22.222 119.688 163.877 31,407.70 7,925.28- 4,083.35- 42,600.00 14,406.00- 1,378.15 2.00 48,973.22 28.696 7,567,594.49- 28.696 7,567,594.49- 28.696 7,567,594.49 - Page 3 glbase_tbam skrolczyk 18:02 03/13/19 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 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Period Ending: 2/2019 Amended Total Budget Encumb. 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 Current Month Program: YTD Total % of Budget 22,824.57 114,220.00 34.956 805.94 3,853.08 19.265 3,620.00 100.000 175.00 925.00 19.271 2,202.03 12,393.50 37.213 4,219.68 17,285.76 23.104 261.55 1,164.05 26.964 42.47 192.70 27.489 211.67 1,088.11 34.753 1,435.15 7,447.38 33.819 335.63 1,741.72 33.820 286.18 709.81 65.723 660.34 4,384.10 33.998 Remaining Budget 212,535.00 16,146.92 3,875.00 20,910.50 57,532.24 3,152.95 508.30 2,042.89 14,573.62 3,408.28 370.19 8,510.90 200.00 300.00 Page 4 Subtotal: 513,092.00 513,092.00 33,460.21 169,025.21 32.942 344,066.79 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 5,214.00 6,500.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 16,935.09 31,806.00 31.806 1,906.30 63.543 66.80 994.05 19.881 1,272.40 2,647.50 40.731 20,000.00 68,194.00 1,093.70 4,005.95 3,500.00 5,214.00 3,852.50 Subtotal: 143,214.00 143,214.00 18,274.29 37,353.85 26.083 105,860.15 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 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 285.79 1,595.35 31.907 382.68 42,013.40 27.245 61.00 61.00 12.200 305.00 996.00 21.415 4,438.58 12,124.23 20.904 109,758.62 491,343.73 16.305 336.00 336.00 11.200 2,090.00 14.169 25,172.81 125,864.05 21.508 4,600.00 23,000.00 41.672 3,404.65 112,190.60 1,000.00 439.00 3,655.00 400.00 2,345.00 1,500.00 45,875.77 2,522,150.27 200.00 2,664.00 12,660.00 459,344.95 32,193.00 200,000.00 glbase_tbam skrolczyk 18:02 03/13/19 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 4,101,946.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 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 Trophy Club MUD No.1 Page 5 Budget Summary with Amendment 10 Water Period Ending: 2/2019 Amended Total Budget Encumb. 2,500.00 4,101,946.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 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 Current Month 145,340.48 836.68 2,283.84 3,120.52 207,620.29 207,620.29 407,815.79 Program: YTD Total 699,423.76 3,781.21 1,417.41 9,677.68 17,861.60 31,482.00 64,219.90 360,310.12 30,068.00 2,283.93 75,000.00 99,877.11 567,539.16 1,537,561.88 % of Budget 17.051 25.208 27.310 48.388 25.517 36.186 32.208 79.539 100.000 55.381 100.000 83.231 83.193 27.263 Remaining Budget 2,500.00 3,402,522.24 11,218.79 3,772.59 10,322.32 1,200.00 1,000.00 52,138.40 55,518.00 135,170.10 92,689.88 1,840.07 20,122.89 114,652.84 4,102,272.12 glbase_tbam skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund Department: 10 Water Trophy Club MUD No.1 Page 6 Budget Summary with Amendment Program: 1 Lab Analysis for PID Period Ending: 2/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,641,834.00 5,641,834.00 160.00 160.00 160.00 407,975.79 607.70 30.385 607.70 30.385 607.70 1,538,169.58 30.385 27.264 1,392.30 1,392.30 1,392.30 4,103,664.42 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 18:02 03/13/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 421,699.00 421,699.00 26,137.45 130,894.94 31.040 290,804.06 135-50010-020-000 Overtime 30,000.00 30,000.00 2,463.19 13,674.91 45.583 16,325.09 135-50016-020-000 Longevity 7,445.00 7,445.00 7,445.00 100.000 135-50017-020-000 Certification 8,700.00 8,700.00 900.00 3,600.00 41.379 5,100.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,728.79 15,911.06 36.766 27,364.94 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,588.48 27,117.94 29.596 64,509.06 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 340.56 1,796.79 35.204 3,307.21 135-50028-020-000 Vision Insurance 826.00 826.00 55.64 287.98 34.864 538.02 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 406.54 1,451.25 32.286 3,043.75 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 1,723.55 9,045.43 31.185 19,960.57 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 403.08 2,115.47 31.183 4,668.53 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 415.43 947.10 75.167 312.90 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 855.93 5,678.85 33.521 11,262.15 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 38.00 9.500 362.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 667,863.00 667,863.00 42,018.64 220,004.72 32.942 447,858.28 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 891.00 5.940 14,109.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 50,419.32 72,954.98 82.903 15,045.02 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 4,300.82 43.008 5,699.18 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 116.85 300.52 3.757 7,699.48 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 5,146.60 6,679.88 445.325 5,179.88- 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 5,214.00 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 6,760.00 31,759.76 42.346 43,240.24 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 3,673.21 19,999.45 57.141 15,000.55 Subtotal: 267,714.00 267,714.00 66,115.98 136,886.41 51.132 130,827.59 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 434.95 1,927.01 38.540 3,072.99 135-60020-020-000 Electricity 174,165.00 174,165.00 198.12 64,277.21 36.906 109,887.79 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 69.00 23.000 231.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 121.95 862.95 12.061 6,292.05 135-60090-020-000 Safety Program 1,000.00 1,000.00 100.74 10.074 899.26 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 155.11 155.11 8.185 1,739.89 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 30,000.00 30,000.00 16,545.22 55.151 13,454.78 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 225.18 4.504 4,774.82 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 647.84 5.585 10,952.16 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 10,913.90 54,569.50 45.455 65,483.50 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 18:02 03/13/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 688,330.00 125,187.00 200,000.00 3,500.00 688,330.00 125,187.00 200,000.00 3,500.00 54,203.45 10,432.00 271,017.25 52,160.00 39.373 41.666 417,312.75 73,027.00 200,000.00 3,500.00 Subtotal: 1,381,335.00 1,381,335.00 76,459.48 462,557.01 33.486 918,777.99 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Lab Supplies 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 1,609.96 547.00 252.14 211.19 5,563.85 2,059.90 3,300.78 54.95 1,095.69 3,349.83 44.511 37.487 11.003 4.579 91.308 16.749 6,936.15 3,435.10 26,699.22 1,145.05 104.31 16,650.17 Subtotal: 70,395.00 70,395.00 2,620.29 15,425.00 21.912 54,970.00 135-69005-020-000 135-69008-020-000 135-69009-020-000 1 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement 330,000.00 109,858.00 14,917.00 30,000.00 330,000.00 109,858.00 14,917.00 30,000.00 38,648.38 444,529.19 39,858.59 3,027.55 30,000.00 134.706 36.282 20.296 100.000 114,529.19- 69,999.41 11,889.45 Subtotal: 484,775.00 484,775.00 38,648.38 517,415.33 106.733 32,640.33- 135-70020-020-000 Capital Lease Issuance Cost 1,500.00 1,500.00 - Subtotal: 1,500.00 1,500.00 - Program number: 2,872,082.00 2,872,082.00 225,862.77 1,353,788.47 47.136 1,518,293.53 Department number: Wastewater 2,872,082.00 2,872,082.00 225,862.77 1,353,788.47 47.136 1,518,293.53 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 18:02 03/13/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 2/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 2.12 10.60 2.12 10.60 23.40 23.40 25.52 25.52 650.00 23.40 565.00 338.57 1,576.97 1,587.57 1,587.57 35.333 Remaining Budget 19.40 35.333 19.40 86.667 1.800 14.125 6.771 11.947 12.000 12.000 150.00 100.00 1,276.60 3,435.00 4,661.43 2,000.00 11,623.03 11,642.43 11,642.43 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 18:02 03/13/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 29,989.79 2,774.04 4,824.42 259.52 42.51 312.72 1,775.75 415.31 331.70 66.95 70.34 142,362.93 10.45 1,832.50 14,699.24 22,084.56 1,297.60 212.55 1,467.34 8,575.54 2,005.58 841.01 493.15 103.95 2,953.57 32.281 .523 99.973 35.723 26.967 30.240 30.321 32.644 31.093 31.094 66.747 38.081 20.790 59.071 298,643.07 1,989.55 .50 26,448.76 59,810.44 2,993.40 488.45 3,027.66 19,004.46 4,444.42 418.99 801.85 396.05 2,046.43 Subtotal: 619,454.00 619,454.00 40,863.05 198,939.97 32.115 420,514.03 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 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 2,587.27 9,766.54 3,545.00 869.06 582.41 39,368.95 58,177.16 4,340.00 3,476.24 59,205.00 2,904.39 50.571 33.244 21.700 34.762 89.630 32.271 38,480.05 116,822.84 15,660.00 10,000.00 6,523.76 6,850.00 6,095.61 Subtotal: 367,904.00 367,904.00 17,350.28 167,471.74 45.520 200,432.26 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-60125-030-000 135-60235-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 Advertising Security 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 1,516.83 237.55 64.17 1,674.18 5,661.96 7,545.65 1,187.57 1,490.11 279.29 8,349.48 28,685.74 6,302.73 31,513.65 308.00 4,109.25 8.70 24.00 32.109 15,954.35 29.689 2,812.43 17.147 7,199.89 13.965 1,720.71 27.832 21,650.52 51.630 26,874.26 1,500.00 48.483 33,486.35 1,000.00 68.488 1,890.75 400.00 6,000.00 135.00 1.508 8,815.00 8.70 .200 4,336.30 200.00 25,000.00 120.00 9.317 1,168.00 glbase_tbam skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund Account Description 135-60245-030-000 135-60246-030-000 135-60360-030-000 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: 2/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 500.00 17,000.00 2,500.00 500.00 17,000.00 2,500.00 124.49 24.898 375.51 17,000.00 2,500.00 Subtotal: 263,433.00 263,433.00 15,798.12 83,548.93 31.715 179,884.07 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 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 1,779.32 2,056.65 268.83 3,025.81 4,352.51 1,972.94 42.834 72.542 49.324 2,050.00 4,038.19 1,647.49 3,500.00 2,027.06 2,500.00 Subtotal: 25,114.00 25,114.00 4,104.80 9,351.26 37.235 15,762.74 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 493.00 493.00 .176 279,507.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 295.97 1,407.77 35.194 2,592.23 Subtotal: 284,000.00 284,000.00 788.97 1,900.77 .669 282,099.23 Program number: 1,559,905.00 1,559,905.00 78,905.22 461,212.67 29.567 1,098,692.33 Department number: Administration 1,559,905.00 1,559,905.00 78,905.22 461,212.67 29.567 1,098,692.33 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 18:02 03/13/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 135-55055-039-000 Auditing 30,800.00 135-55060-039-000 Appraisal 11,714.00 135-55065-039-000 Tax Admin Fees 4,800.00 137,000.00 30,800.00 11,714.00 4,800.00 22,091.24 52,648.42 26,459.53 4,723.22 3,653.00 38.430 85.908 40.321 76.104 84,351.58 4,340.47 6,990.78 1,147.00 Subtotal: 184,314.00 184,314.00 22,091.24 87,484.17 47.465 96,829.83 Program number: 184,314.00 184,314.00 22,091.24 87,484.17 47.465 96,829.83 Department number: Non Departmental 184,314.00 184,314.00 22,091.24 87,484.17 47.465 96,829.83 Expenditures Subtotal 10,271,365.00 10,271,365.00 734,860.54 3,442,242.46 33.513 6,829,122.54 Fund number: 135 MUD 1 General Fund 341,837.00- 341,837.00- 76,500.16 396,634.95 -116.030 738,471.95- glbase_tbam skrolczyk 18:02 03/13/19 Fund: 137 MUD 1 Consolidated GASB Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 2/2019 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Remaining Budget Page 13 137-49145-000-000 1 137-49146-000-000 Intergov Transfer -General Fund Intergov Transfer -Fire Dept 105,000.00- 81,420.00- 105,000.00 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 glpdatb2 skrolczyk 18:02 03/13/19 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: 2/2019 JE Detail Description/Comment Page 5 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 882 02/01/2019 Property Taxes 885 02/04/2019 Property Taxes 886 02/05/2019 Property Taxes 888 02/06/2019 Property Taxes 889 02/07/2019 Property Taxes 890 02/08/2019 Property Taxes 891 02/11/2019 Property Taxes 892 02/12/2019 Property Taxes 893 02/13/2019 Property Taxes 894 02/14/2019 Property Taxes 895 02/15/2019 Property Taxes 896 02/19/2019 Property Taxes 897 02/20/2019 Property Taxes 898 02/21/2019 Property Taxes 899 02/22/2019 Property Taxes 900 02/25/2019 Property Taxes 908 02/26/2019 Property Taxes 902 02/28/2019 Property Taxes (112,711.18) (1,039.37) (1,210.97) (2,188.65) (1,570.42) (2,481.67) (61.90) (6.79) (69.84) (156.25) (26.10) (27.96) (761.76) 42.62 (34.95) 20.25 (29.37) (82.30) (10.99) (113,750.55) (114,961.52) (117,150.17) (118,720.59) (121,202.26) (121,264.16) (121,270.95) (121,340.79) (121,497.04) (121,523.14) (121,551.10) (122,312.86) (122,270.24) (122,305.19) (122,284.94) (122,314.31) (122,396.61) (122,407.60) 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: (9,696.42) (122,407.60) ** (132,384.00) Budgeted (9,976.40) Remaining 92 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 882 02/01/2019 Property Taxes 886 02/05/2019 Property Taxes 888 02/06/2019 Property Taxes 889 02/07/2019 Property Taxes 893 02/13/2019 Property Taxes 894 02/14/2019 Property Taxes 900 02/25/2019 Property Taxes 901 02/27/2019 Property Taxes 902 02/28/2019 Property Taxes (93.89) (.02) (23.58) (.05) (.86) (.05) 8.19 (8.72) (112.80) (4.15) (93.91) (117.49) (117.54) (118.40) (118.45) (110.26) (118.98) (231.78) (235.93) GL GL GL GL GL GL GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (142.04) (235.93) ** (300.00) Budgeted (64.07) Remaining 79 6 Used Account: 135-40015-000-000 Property Taxes/P & I 882 02/01/2019 Property Taxes 885 02/04/2019 Property Taxes 886 02/05/2019 Property Taxes (57.65) (3.66) (3.29) (8.48) (61.31) (64.60) (73.08) GL GL GL glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 888 02/06/2019 Property Taxes 889 02/07/2019 Property Taxes 890 02/08/2019 Property Taxes 891 02/11/2019 Property Taxes 892 02/12/2019 Property Taxes 893 02/13/2019 Property Taxes 894 02/14/2019 Property Taxes 895 02/15/2019 Property Taxes 896 02/19/2019 Property Taxes 898 02/21/2019 Property Taxes 900 02/25/2019 Property Taxes 908 02/26/2019 Property Taxes 901 02/27/2019 Property Taxes 902 02/28/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 2/2019 JE Detail Description/Comment Page 6 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (57.65) (.01) (73.09) GL (2.04) (75.13) GL (3.97) (79.10) GL (3.39) (82.49) GL (4.89) (87.38) GL (10.94) (98.32) GL (1.83) (100.15) GL (1.95) (102.10) GL (168.41) (270.51) GL (2.57) (273.08) GL (4.24) (277.32) GL (6.10) (283.42) GL (6.67) (290.09) GL (9.79) (299.88) GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (242.23) (299.88) ** (300.00) Budgeted (.12) Remaining 100 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (171,983.00) Budgeted (171,983.00) Remaining 0 % Used Account: 135-47000-000-000 Water 699 02/06/2019 UB 02/06/2019 Account credit UB20190206-20190206 User: 755 02/13/2019 UB 02/13/2019 Credit adjustmen UB20190213-20190213 User: 867 02/20/2019 Bill adj UB20190220-20190220 User: 838 02/28/2019 Billing -February 2019 UB20190228-20190228 User: (1,181,180.09) 155.76 (1,181,024.33) UB 41.49 (1,180,982.84) UB 89.10 (1,180,893.74) UB (290,225.03) (1,471,118.77) UB Account: 135-47000-000-000 Water Totals: (289,938.68) (1,471,118.77) ** (6,599,484.00) Budgeted (5,128,365.23) Remaining 22 % Used Account: 135-47005-000-000 Sewer 838 02/28/2019 Billing -February 2019 UB20190228-20190228 User: (1,000,135.95) (273,743.49) (1,273,879.44) UB Account: 135-47005-000-000 Sewer Totals: (273,743.49) (1,273,879.44) ** (3,412,665.00) Budgeted (2,138,785.56) Remaining 37 % Used Account: 135-47025-000-000 Penalties glpdatb2 skrolczyk 18:02 03/13/19 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: 2/2019 JE Detail Description/Comment 698 02/06/2019 UB 02/06/2019 Penalty removal UB20190206-20190206 User: 765 02/15/2019 UB 02/15/2019 Penalty removal UB20190215-20190215 User: 795 02/21/2019 UB 02/21/2019 Penalties UB20190221-20190221 User: 811 02/26/2019 UB 02/26/2019 Penalty removal UB20190226-20190226 User: 813 02/26/2019 UB 02/26/2019 Penalty removal UB20190226-20190226 User: 815 02/26/2019 UB 02/26/2019 Penalty removal UB20190226-20190226 User: 822 02/27/2019 UB 02/27/2019 Penalty removal UB20190227-20190227 User: 866 02/28/2019 UB penalty removals UB20190228-20190228 User: Page 7 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (34,312.75) 25.87 96.73 (8,639.58) 65.93 28.80 18.59 10.84 48.50 (34,286.88) (34,190.15) (42,829.73) (42,763.80) (42,735.00) (42,716.41) (42,705.57) (42,657.07) UB UB UB UB UB UB UB UB Account: 135-47025-000-000 Penalties - Totals: (8,344.32) (42,657.07) ** (136,418.00) Budgeted (93,760.93) Remaining 31 % Used Account: 135-47030-000-000 Service Charges 694 02/06/2019 767 02/11/2019 793 02/20/2019 UB UB UB 02/06/2019 02/11/2019 02/20/2019 Disconnect Fees UB20190206-20190206 User: NSF Check UB20190211-20190211 User: NSF check UB20190220-20190220 User: (5,750.00) (1,350.00) (25.00) (25.00) (7,100.00) (7,125.00) (7,150.00) UB UB UB Account: 135-47030-000-000 ' Service Charges Totals: (1,400.00) (7,150.00) ** (17,000.00) Budgeted (9,850.00) Remaining 42 % Used Account: 135-47035-000-000 Plumbing Inspections 851 02/04/2019 Permits 851 02/04/2019 Permits 851 02/04/2019 Permits 851 02/04/2019 Permits 852 02/22/2019 Permitting 852 02/22/2019 Permitting 602 Hogan's drive 11 Sadie Court 511 Asheville 653 Sheldon Drive 605 Hogan's Drive 509 Asheville Lane (250.00) (50.00) (50.00) (50.00) (50.00) (50.00) (50.00) (300.00) Ashton Woods (350.00) Drees Homes (400.00) Ashton Woods (450.00) Ashton Woods (500.00) Ashton Woods Homes (550.00) Ashton Woods Homes CR CR CR CR CR CR Account: 135-47035-000-000 Plumbing Inspections Totals: (300.00) (550.00) ** (1,500.00) Budgeted (950.00) Remaining 37 % Used Account: 135-47045-000-000 Sewer Inspections 851 02/04/2019 Permits 851 02/04/2019 Permits 851 02/04/2019 Permits 851 02/04/2019 Permits 852 02/22/2019 Permitting 852 02/22/2019 Permitting 602 Hogan's drive 11 Sadie Court 511 Asheville 653 Sheldon Drive 605 Hogan's Drive 509 Asheville Lane (750.00) (150.00) (900.00) Ashton Woods CR (150.00) (1,050.00) Drees Homes CR (150.00) (1,200.00) Ashton Woods CR (150.00) (1,350.00) Ashton Woods CR (150.00) (1,500.00) Ashton Woods Homes CR (150.00) (1,650.00) Ashton Woods Homes CR Account: 135-47045-000-000 Sewer Inspections Totals: (900.00) (1,650.00) ** (4,500.00) Budgeted (2,850.00) Remaining 37 % Used glpdatb2 skrolczyk 18:02 03/13/19 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: 2/2019 JE Detail Description/Comment Account: 135-47070-000-000 TCCC Effluent Charges Account: 135-47070-000-000 Page 8 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (17.60) .00 (17.60) TCCC Effluent Charges Totals: .00 (17.60) ** (60,000.00) Budgeted (59,982.40) Remaining Account: 135-49010-000-000 Interest Income 917 02/12/2019 February Interest- Escrow Vac 868 02/28/2019 Bank Interest- February 868 02/28/2019 Bank Interest- February 868 02/28/2019 Bank Interest- February Account: 135-49010-000-000 (39,687.71) 0 % Used (5.66) (39,693.37) GL (588.94) (40,282.31) GL (1,137.33) (41,419.64) GL (9,988.06) (51,407.70) GL Interest Income Totals: (11,719.99) (51,407 (20,000.00) Budgeted 31,407.70 Remaining 257 % Used Account: 135-49016-000-000 Cell Tower Revenue 839 02/12/2019 Cell Tower Rev AT&T February (5,041.91) (1,178.81) (6,220.72) GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (6,220.72) ** (14,146.00) Budgeted (7,925.28) Remaining 44 % Used Account: 135-49018-000-000 Building Rent Income 880 02/28/2019 Town Billed Invoices 1676-1679 AR 20190228-20190228 User: (2,333.32) Account: 135-49018-000-000 Account: 135-49026-000-000 Building Rent Income Totals: (7,000.00) Budgeted (4,083.35) Remaining 42 % Used Proceeds from Sale of Assets 843 02/28/2019 Salvage Lone Star Auction 843 02/28/2019 Salvage Lone Star Auction 843 02/28/2019 Salvage Lone Star Auction Account: 135-49026-000-000 Account: 135-49075-000-000 851 02/04/2019 Permits 851 02/04/2019 Permits Water On -Call 2011 Ford Truck 2001 Camera Van 2009 Vac Truck (583.33) (2,916.65) AR (583.33) (2,916.65) ** (7,050.00) (7,050.00) GL (6,450.00) (13,500.00) GL (39,100.00) (52,600.00) GL Proceeds from Sale of Assets Totals: (52,600.00) (10,000.00) Budgeted 42,600.00 Remaining Oversize Meter Reimbursement 602 Hogan's drive 11 Sadie Court 526 % Used (1,715.00) (52,600.00) ** (343.00) (2,058.00) Ashton Woods (343.00) (2,401.00) Drees Homes CR CR glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 851 02/04/2019 Permits 851 02/04/2019 Permits 852 02/22/2019 Permitting 852 02/22/2019 Permitting 853 02/25/2019 permitting Account: 135-49075-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 2/2019 JE Detail Description/Comment 511 Asheville 653 Sheldon Drive 605 Hogan's Drive 509 Asheville Lane 9 Heather stone Ct Page 9 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Oversize Meter Reimbursement Totals: (18,522.00) Budgeted (14,406.00) Remaining Account: 135-49900-000-000 852 02/22/2019 Permitting 853 02/25/2019 permitting 853 02/25/2019 permitting 838 02/28/2019 Billing -February 2019 Account: 135-49900-000-000 Account: 135-49901-000-000 Account: 135-49901-000-000 Department Totals: Miscellaneous Income 605 Hogan's Drive 9 Heatherstone Ct 9 Heatherstone Ct UB20190228-20190228 User: Miscellaneous Income Totals: (7,000.00) Budgeted Records Management Revenue Records Management Revenue Totals: (1,715.00) (343.00) (2,744.00) Ashton Woods CR (343.00) (3,087.00) Ashton Woods CR (343.00) (3,430.00) Ashton Woods Homes CR (343.00) (3,773.00) Ashton Woods Homes CR (343.00) (4,116.00) The Knoll HOA CR (2,401.00) (4,116.00) ** 22 % Used ■ (3,208.08) (800.00) (4,008.08) Ashton Woods Homes CR (3,000.00) (7,008.08) The Knoll HOA CR (1,200.00) (8,208.08) The Knoll HOA CR (170.07) (8,378.15) UB 1,378.15 Remaining 120 % Used (2.00) .00 Budgeted (658,360.38) Monthly Total 2.00 Remaining 0 % Used (5,170.07) (8,378.15) ** .00 .00 (2.00) (2.00) ** (3,045,607.51) ** (10,613,202.00) Budgeted (7,567,594.49) Remaining 29 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 Salaries & Wages 687 02/08/2019 MUD Payroll 02/08/2019 Salaries & Wages 776 02/22/2019 MUD Payroll 02/22/2019 Salaries & Wages Account: 135-50005-010-000 1 Salaries & Wages 326,755.00 Budgeted Account: 135-50010-010-000 Overtime 687 02/08/2019 MUD Payroll 02/08/2019 Overtime 776 02/22/2019 MUD Payroll 02/22/2019 Overtime 91,395.43 11,411.00 102,806.43 PR 11,413.57 114,220.00 PR Totals: 212,535.00 Remaining 35 % Used 22,824.57 114,220.00 ** 3,047.14 231.97 3,279.11 PR 573.97 3,853.08 PR Account: 135-50010-010-000 Overtime Totals: 805.94 3,853.08 ** 20,000.00 Budgeted Account: 135-50016-010-000 Longevity Account: 135-50016-010-000 Longevity Totals: 3,620.00 Budgeted .00 Remaining 16,146.92 Remaining 19 % Used 3,620.00 .00 3,620.00 .00 3,620.00 ** 100 % Used Account: 135-50017-010-000 Certification 776 02/22/2019 MUD Payroll 02/22/2019 Certification 750.00 175.00 925.00 PR Account: 135-50017-010-000 Certification Totals: 175.00 925.00 ** 4,800.00 Budgeted Account: 135-50020-010-000 Retirement 687 02/08/2019 MUD Payroll 02/08/2019 Retirement 776 02/22/2019 MUD Payroll 02/22/2019 Retirement 3,875.00 Remaining 19 9 Used 10,191.47 1,077.00 11,268.47 1,125.03 12,393.50 PR PR Account: 135-50020-010-000 Retirement Totals: 2,202.03 12,393.50 ** 33,304.00 Budgeted Account: 135-50026-010-000 Medical Insurance 687 02/08/2019 MUD Payroll 02/08/2019 Medical Insurance 776 02/22/2019 MUD Payroll 02/22/2019 Medical Insurance Account: 135-50026-010-000 20,910.50 Remaining 37 % Used Medical Insurance Totals: 74,818.00 Budgeted 13,066.08 57,532.24 Remaining 23 % Used 2,109.86 15,175.94 2,109.82 17,285.76 4,219.68 17,285.76 ** PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 Dental Insurance 687 02/08/2019 MUD Payroll 02/08/2019 Dental Insurance 776 02/22/2019 MUD Payroll 02/22/2019 Dental Insurance Account: 135-50027-010-000 Dental Insurance Totals: 4,317.00 Budgeted Account: 135-50028-010-000 Vision Insurance 687 02/08/2019 MUD Payroll 02/08/2019 Vision Insurance 776 02/22/2019 MUD Payroll 02/22/2019 Vision Insurance 902.50 130.80 1,033.30 PR 130.75 1,164.05 PR 3,152.95 Remaining 27 % Used 5 1,164.05 ** 150.23 21.25 171.48 PR 21.22 192.70 PR Account: 135-50028-010-000 Vision Insurance Totals: 42.47 192.70 ** Account: 135-50029-010-000 638 02/01/2019 February A/P 638 02/01/2019 February A/P 833 02/28/2019 February A/P 701.00 Budgeted Life Insurance & Other Employee Benefits Employee LTD & STD Caf 125 508.30 Remaining 27 % Used 876.44 98.56 975.00 Humana Inc 91.11 1,066.11 METLIFE GROUP BENEFITS 22.00 1,088.11 BenefitMall 4965 AP 4975 AP 5035 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 211.67 1,088.11 ** 3,131.00 Budgeted 2,042.89 Remaining 35 % Used Account: 135-50030-010-000 Social Security Taxes 687 02/08/2019 MUD Payroll 02/08/2019 Social Security Taxes 776 02/22/2019 MUD Payroll 02/22/2019 Social Security Taxes Account: 135-50030-010-000 Social Security Taxes Totals: 22,021.00 Budgeted Account: 135-50035-010-000 - Medicare Taxes 687 02/08/2019 MUD Payroll 02/08/2019 Medicare Taxes 776 02/22/2019 MUD Payroll 02/22/2019 Medicare Taxes 6,012.23 14,573.62 Remaining 34 % Used 1,406.09 715.03 720.12 1,435.15 6,727.26 7,447.38 7,447.38 ** 167.22 1,573.31 168.41 1,741.72 PR PR PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 335.63 1,741.72 ** 5,150.00 Budgeted Account: 135-50040-010-000 Unemployment Taxes 687 02/08/2019 MUD Payroll 02/08/2019 Unemployment Taxes 3,408.28 Remaining 34 % Used 423.63 161.99 585.62 PR glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 776 02/22/2019 MUD Payroll 02/22/2019 Account: 135-50040-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 2/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes Unemployment Taxes 1,080.00 Budgeted Totals: 370.19 Remaining Account: 135-50045-010-000 Workman's Compensation 129 02/01/2019 Insurance/Wrk Comp Expense Feb 841 02/12/2019 TML Refund W/C FY 18 Water Portion of W/C Refund Account: 135-50045-010-000 Workman's Compensation 12,895.00 Budgeted Totals: 8,510.90 Remaining 423.63 3,723.76 Program: Transaction Detail 124.19 66 % Used 286.18 930.94 (270.60) 34 5 Used 660.34 Transaction Vendor_Name Detail (SUBTOTAL) 709.81 709.81 ** 4,654.70 4,384.10 4,384.10 ** Page 12 Check Source Number PR GL GL Account: 135-50060-010-000 Pre-emp Physicals/Testing Account: 135-50060-010-000 Account: 135-50070-010-000 Account: 135-50070-010-000 Account: 135-55005-010-000 Account: 135-55005-010-000 Account: 135-55080-010-000 872 02/26/2019 872 02/26/2019 872 02/26/2019 872 02/26/2019 833 02/28/2019 846 02/28/2019 912 02/28/2019 PCard PCard PCard PCard 1/29/2019 1/29/2019 1/29/2019 1/29/2019 February A/P February A/P February A/p Pre-emp Physicals/Testing Totals: 200.00 Budgeted 200.00 Remaining Employee Relations Employee Relations 300.00 Budgeted Engineering Engineering 20,000.00 Budgeted Maint - 2/26/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 Totals: 300.00 Remaining Totals: 20,000.00 Remaining enance & Repairs cla-val whitewood stud, aerosol, etc wtr shut off tool reporting Water line repair -1 Colonial Indian creek water line repair Poly 14,870.91 .00 O % Used O % Used O % Used .00 .00 .00 .00 .00 .00 .00 .00 .00 ** .00 .00 ** 34.69 14,905.60 119.40 15,025.00 345.83 15,370.83 65.70 15,436.53 9,760.26 25,196.79 6,363.21 31,560.00 204.00 31,764.00 ALLIED CONTROLS INC THE HOME DEPOT #6581 FERGUSON ENT 1241 SC TRACKING SOLUTIONS REY-MAR CONSTRUCTION REY-MAR CONSTRUCTION Core & Main LP PC PC PC PC 5059 AP 5082 AP AP glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 912 02/28/2019 February A/p Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 2/2019 JE Detail Beginning Balance Description/Comment tank lease Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 14,870.91 42.00 31,806.00 ALLIED WELDING SUPPLY, INC Page 13 Check Source Number AP 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 912 02/28/2019 February A/p lab testing lab testing water samples water samples 1,375.10 317.40 1,692.50 OXIDOR LABORATORIES LLC 230.00 1,922.50 OXIDOR LABORATORIES LLC 490.00 2,412.50 TARRANT CTY PUBLIC HEALTH LAB 235.00 2,647.50 TARRANT CTY PUBLIC HEALTH LAB 5019 AP 5019 AP 5022 AP AP Account: 135-55135-010-000 Lab Analysis Totals: 1,272.40 2,647.50 ** 6,500.00 Budgeted 3,852.50 Remaining 41 % Used Account: 135-55080-010-000 Maintenance & Repairs Totals: 16,935.09 31,806.00 ** 100,000.00 Budgeted 68,194.00 Remaining 32 % Used Account: 135-55085-010-000 Generator Maint. and Repair 1,906.30 .00 1,906.30 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 1,906.30 ** 3,000.00 Budgeted 1,093.70 Remaining 64 % Used Account: 135-55090-010-000 Vehicle Maintenance 872 02/26/2019 PCard 1/29/2019 -2/26/2019 oil change 927.25 66.80 994.05 GIERISCH CARE 0050292 PC Account: 135-55090-010-000 Vehicle Maintenance ' Totals: 66.80 994.05 ** 5,000.00 Budgeted 4,005.95 Remaining 20 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55120-010-000 Cleaning Services .00 .00 Account: 135-55120-010-000 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 912 02/28/2019 February A/p lab testing lab testing water samples water samples 1,375.10 317.40 1,692.50 OXIDOR LABORATORIES LLC 230.00 1,922.50 OXIDOR LABORATORIES LLC 490.00 2,412.50 TARRANT CTY PUBLIC HEALTH LAB 235.00 2,647.50 TARRANT CTY PUBLIC HEALTH LAB 5019 AP 5019 AP 5022 AP AP Account: 135-55135-010-000 Lab Analysis Totals: 1,272.40 2,647.50 ** 6,500.00 Budgeted 3,852.50 Remaining 41 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-60010-010-000 Communications/Mobiles 774 02/18/2019 February A/P Account: 135-60010-010-000 Account: 135-60020-010-000 833 02/28/2019 February A/P Account: 135-60020-010-000 Cell phone -February 1,309.56 Communications/Mobiles Totals: 5,000.00 Budgeted 3,404.65 Remaining 32 % Used Electricity Electricity 1/9-2/8 Electricity Totals: 154,204.00 Budgeted 112,190.60 Remaining 285.79 1,595.35 VERIZON WIRELESS 5030 AP 285.79 1,595.35 ** 41,630.72 382.68 42,013.40 HUDSON ENERGY SERVICES, LLC 27 % Used 382.68 42,013.40 ** 5044 AP Account: 135-60066-010-000 Publications/Books/Subscripts Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining Account: 135-60070-010-000 Dues & Memberships 833 02/28/2019 February A/P Petty cash reimbursement .00 0 % Used .00 .00 .00 ** 61.00 61.00 TROPHY CLUB MUD PETTY CASH 5062 AP Account: 135-60070-010-000 1 Dues & Memberships Totals: 61.00 61.00 ** 500.00 Budgeted 439.00 Remaining 12 % Used Account: 135-60080-010-000 ' Schools & Training 872 02/26/2019 PCard 1/29/2019 -2/26/2019 training class 833 02/28/2019 February A/P Petty cash reimbursement -Steve 691.00 280.00 971.00 TARRANT COUNTY COLLEGE 25.00 996.00 TROPHY CLUB MUD PETTY CASH PC 5062 AP Account: 135-60080-010-000 1 Schools & Training Totals: 305.00 996.00 ** 4,651.00 Budgeted 3,655.00 Remaining 21 % 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 15 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 .00 .00 Travel & per diem Totals: .00 .00 ** 2,345.00 Budgeted Account: 135-60105-010-000 Rent/Lease Equipment Account: 135-60105-010-000 1 Rent/Lease Equipment 1,500.00 Budgeted 2,345.00 Remaining 0 % Used .00 .00 Totals: .00 ** 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 872 02/26/2019 PCard 1/29/2019 -2/26/2019 tier 2 submittal 833 02/28/2019 February A/P Petty cash reimbursement -Steve 869 02/28/2019 February A/P Wellw ater Account: 135-60135-010-000 1 TCEQ Fees & Permits Totals: 58,000.00 Budgeted Account: 135-60150-010-000 Wholesale Water 833 02/28/2019 February A/P wholesale water Account: 135-60150-010-000 7,685.65 50.00 7,735.65 TCEQ EPAYMENT PC 50.00 7,785.65 TROPHY CLUB MUD PETTY CASH 5062 AP 4,338.58 12,124.23 North Texas Groundwater 5083 AP 45,875.77 Remaining 21 % Used 4,438.58 381,585.11 109,758.62 M24.23 ** 491,343.73 CITY OF FORT WORTH 5037 AP Wholesale Water Totals: 109,758.62 491,343.73 ** 3,013,494.00 Budgeted Account: 135-60245-010-000 Miscellaneous Expenses Account: 135-60245-010-000 2,522,150.27 Remaining 16 % Used Miscellaneous Expenses Totals: 200.00 Budgeted Account: 135-60280-010-000 Property Maintenance 872 02/26/2019 PCard 1/29/2019 -2/26/2019 Denton Sand & Gravel 872 02/26/2019 PCard 1/29/2019 -2/26/2019 Denton Sand & Gravel Account: 135-60280-010-000 .00 200.00 Remaining 0 % Used Property Maintenance Totals: 3,000.00 Budgeted .00 .00 .00 ** 168.00 168.00 DENTON SAND & GRAVEL, PC 168.00 336.00 DENTON SAND & GRAVEL, PC 2,664.00 Remaining 11 6 Used 336.00 336.00 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 2,090.00 .00 2,090.00 Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 2,090.00 ** 14,750.00 Budgeted 12,660.00 Remaining 14 % Used Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 828 02/28/2019 TexPool Transfers February TexPool O&M to 16Swift Rev I&S 100,691.24 25,172.81 125,864.05 Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 25,172.81 125,864.05 ** 585,209.00 Budgeted 459,344.95 Remaining 22 % Used Account: 135-60333-010-000 Interfund Transfer Out -Reserve 828 02/28/2019 TexPool Transfers February TexPool O&M to Rev Bond Resevr 18,400.00 4,600.00 23,000.00 Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 4,600.00 23,000.00 ** 55,193.00 Budgeted 32,193.00 Remaining 42 % Used GL GL Account: 135-60334-010-000 Interfund Transfer Out Account: 135-60334-010-000 Interfund Transfer Out Totals: 200,000.00 Budgeted 200,000.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 821 02/24/2019 February Fuel A/P Fuel 2,944.53 836.68 3,781.21 US Bank Voyager Fleet Systems 5063 AP Account: 135-65005-010-000 Fuel & Lube Totals: 836.68 3,781.21 ** 15,000.00 Budgeted 11,218.79 Remaining 25 % Used Account: 135-65010-010-000 Uniforms glpdatb2 skrolczyk Trophy Club MUD No.1 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 17 1,417.41 .00 1,417.41 Account: 135-65010-010-000 Uniforms Totals .00 1,417.41 5,190.00 Budgeted 3,772.59 Remaining 27 % Used Account: 135-65030-010-000 Chemicals 774 02/18/2019 February A/P 788 02/20/2019 February A/P 912 02/28/2019 February A/p 912 02/28/2019 February A/p ammonia testing supplies Chlorine chem keys chlorine 7,393.84 445.88 7,839.72 Valley Solvent Company, INC 5029 AP 692.62 8,532.34 HACH COMPANY 5041 AP 251.89 8,784.23 HACH COMPANY AP 893.45 9,677.68 DPC INDUSTRIES, INC AP Account: 135-65030-010-000 Chemicals Totals: 2,283.84 9,677.68 ** 20,000.00 Budgeted 10,322.32 Remaining 48 % 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 % 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 17,861.60 .00 17,861.60 Account: 135-65050-010-000 Meter Expense Totals: .00 17,861.60 ** 70,000.00 Budgeted 52,138.40 Remaining 26 % Used Account: 135-65053-010-000 Meter Change Out Program 31,482.00 .00 31,482.00 Account: 135-65053-010-000 Meter Change Out Program Totals: .00 31,482.00 ** 87,000.00 Budgeted 55,518.00 Remaining 36 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 774 02/18/2019 February A/P 833 02/28/2019 February A/P 912 02/28/2019 February A/p Capital Outlays Indian Creek water line Valve replacement Crestwood 16" water line -Phase II 152,689.83 173,192.37 325,882.20 Quality Excavation, LTD 5020 AP 8,425.70 334,307.90 REY-MAR CONSTRUCTION 5059 AP 26,002.22 360,310.12 Halff Associates, INC AP Account: 135-69005-010-000 Capital Outlays Totals: 207,620.29 360,310.12 ** 453,000.00 Budgeted 92,689.88 Remaining 80 % Used Account: 135-69008-010-000 Short Term Debt -Principal 30,068.00 Account: 135-69008-010-000 Short Term Debt -Principal 30,068.00 Budgeted Totals: .00 Remaining Account: 135-69009-010-000 Short Term Debt -Interest 100 % Used 2,283.93 Account: 135-69009-010-000 Short Term Debt -Interest Totals: 4,124.00 Budgeted 1,840.07 Remaining Account: 135-69195-010-000 Account: 135-69195-010-000 Gasb34/Reserve for Replacement Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 55 % Used 75,000.00 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 99,877.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 20,122.89 Remaining 83 % Used .00 30,068.00 .00 30,068.00 ** .00 2,283.93 .00 2,283.93 ** .00 75,000.00 .00 75,000.00 ** .00 99,877.11 .00 99,877.11 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/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 774 02/18/2019 February A/P 912 02/28/2019 February A/p water samples water samples 447.70 80.00 527.70 TARRANT CTY PUBLIC HEALTH LAB 5022 AP 80.00 607.70 TARRANT CTY PUBLIC HEALTH LAB AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 160.00 607.70 ** 2,000.00 Budgeted 1,392.30 Remaining 30 % Used Department 10 Totals: 1,538,169.58 ** 407,975.79 Monthly Total 5,641,834.00 Budgeted 4,103,664.42 Remaining 27 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 Salaries & Wages 687 02/08/2019 MUD Payroll 02/08/2019 Salaries & Wages 776 02/22/2019 MUD Payroll 02/22/2019 Salaries & Wages Account: 135-50005-020-000 1 Salaries & Wages 421,699.00 Budgeted Account: 135-50010-020-000 Overtime 687 02/08/2019 MUD Payroll 02/08/2019 Overtime 776 02/22/2019 MUD Payroll 02/22/2019 Overtime Account: 135-50010-020-000 104,757.49 13,043.84 117,801.33 PR 13,093.61 130,894.94 PR Totals: 26,137.45 130,894.94 ** 290,804.06 Remaining 31 9 Used 11,211.72 1,397.20 12,608.92 PR 1,065.99 13,674.91 PR Overtime Totals: 2,463.19 ! 13,674.91 ** 30,000.00 Budgeted Account: 135-50016-020-000 Longevity Account: 135-50016-020-000 Longevity Totals: 7,445.00 Budgeted .00 Remaining 16,325.09 Remaining 46 % Used Account: 135-50017-020-000 Certification 7,445.00 .00 7,445.00 .00 100 % Used 776 02/22/2019 MUD Payroll 02/22/2019 Certification 2,700.00 900.00 3,600.00 PR Account: 135-50017-020-000 Certification Totals: 900.00 3,600.00 ** 8,700.00 Budgeted Account: 135-50020-020-000 Retirement 687 02/08/2019 MUD Payroll 02/08/2019 Retirement 776 02/22/2019 MUD Payroll 02/22/2019 Retirement 5,100.00 Remaining 41 % Used 13,182.27 1,335.78 14,518.05 1,393.01 15,911.06 PR PR Account: 135-50020-020-000 Retirement Totals: 2,728.79 15,911.06 ** 43,276.00 Budgeted Account: 135-50026-020-000 Medical Insurance 687 02/08/2019 MUD Payroll 02/08/2019 Medical Insurance 776 02/22/2019 MUD Payroll 02/22/2019 Medical Insurance Account: 135-50026-020-000 27,364.94 Remaining 37 9 Used Medical Insurance Totals: 91,627.00 Budgeted 21,529.46 64,509.06 Remaining 30 % Used 2,794.26 24,323.72 2,794.22 27,117.94 5,588.48 27,117.94 ** PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 Dental Insurance 687 02/08/2019 MUD Payroll 02/08/2019 Dental Insurance 776 02/22/2019 MUD Payroll 02/22/2019 Dental Insurance Account: 135-50027-020-000 Dental Insurance 5,104.00 Budgeted Account: 135-50028-020-000 Vision Insurance 687 02/08/2019 MUD Payroll 02/08/2019 Vision Insurance 776 02/22/2019 MUD Payroll 02/22/2019 Vision Insurance 1,456.23 Totals: 3,307.21 Remaining 35 % Used 232.34 170.29 170.27 1,626.52 1,796.79 340.56 1,796.79 ** 27.83 260.17 27.81 287.98 PR PR PR PR Account: 135-50028-020-000 Vision Insurance Totals: 55.64 287.98 ** Account: 135-50029-020-000 638 02/01/2019 February A/P 638 02/01/2019 February A/P 833 02/28/2019 February A/P 826.00 Budgeted Life Insurance 6 Other Employee Benefits Employee LTD & STD Caf 125 538.02 Remaining 35 % Used 1,044.71 204.40 1,249.11 Humana Inc 162.14 1,411.25 METLIFE GROUP BENEFITS 40.00 1,451.25 BenefitMall 4965 AP 4975 AP 5035 AP Account: 135-50029-020-000 Life Insurance & Other Totals: 406.54 1,451.25 ** 4,495.00 Budgeted 3,043.75 Remaining 32 % Used Account: 135-50030-020-000 Social Security Taxes 687 02/08/2019 MUD Payroll 02/08/2019 Social Security Taxes 776 02/22/2019 MUD Payroll 02/22/2019 Social Security Taxes Account: 135-50030-020-000 Social Security Taxes Totals: 29,006.00 Budgeted Account: 135-50035-020-000 - Medicare Taxes 687 02/08/2019 MUD Payroll 02/08/2019 Medicare Taxes 776 02/22/2019 MUD Payroll 02/22/2019 Medicare Taxes 7,321.88 19,960.57 Remaining 31 % Used 1,712.39 856.50 867.05 1,723.55 8,178.38 9,045.43 9,045.43 ** 200.29 1,912.68 202.79 2,115.47 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 403.08 2,115.47 ** 6,784.00 Budgeted Account: 135-50040-020-000 Unemployment Taxes 687 02/08/2019 MUD Payroll 02/08/2019 Unemployment Taxes 4,668.53 Remaining 31 % Used 531.67 259.94 791.61 PR glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 776 02/22/2019 MUD Payroll 02/22/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 2/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes 531.67 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 155.49 947.10 Page 22 Check Source Number PR Account: 135-50040-020-000 Unemployment Taxes Totals: 415.43 947.10 ** 1,260.00 Budgeted 312.90 Remaining 75 % Used Account: 135-50045-020-000 Workman's Compensation 129 02/01/2019 Insurance/Wrk Comp Expense Feb 841 02/12/2019 TML Refund W/C FY 18 Wastewater Portion W/C Refund 4,822.92 1,205.73 (349.80) 6,028.65 5,678.85 GL GL Account: 135-50045-020-000 Workman's Compensation Totals: 855.93 5,678.85 ** 16,941.00 Budgeted 11,262.15 Remaining 34 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 38.00 .00 38.00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 400.00 Budgeted 362.00 Remaining 10 % Used Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .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 891.00 .00 891.00 Account: 135-55070-020-000 Independent Labor Totals: .00 891.00 ** 15,000.00 Budgeted 14,109.00 Remaining 6 % Used Account: 135-55080-020-000 Maintenance & Repairs glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE Number JE Date 774 02/18/2019 774 02/18/2019 774 02/18/2019 774 02/18/2019 788 02/20/2019 872 02/26/2019 872 02/26/2019 872 02/26/2019 872 02/26/2019 872 02/26/2019 833 02/28/2019 833 02/28/2019 833 02/28/2019 912 02/28/2019 JE Description February A/P February A/P February A/P February A/P February A/P PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 February A/P February A/P February A/P February A/p - 2/26/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 2/2019 JE Detail Beginning Balance Description/Comment pump rental 10/22-11/19 pump rental 11/19-12/6 gravel LS #5 road Skyline Sewer Pipe erosion Belt press blades & wires hydrant to hose adaptor 2x4, stud,140zmap,etc water nozzle 50 gal mobile job box door maintenance Put pump in LS #6 Petty cash reimbursement Sewer line repair behind skyli pipes and pump for wwtp 22,535.66 Program: Transaction Detail 2,816.53 2,804.53 1,095.00 3,262.50 193.27 121.00 240.44 23.88 128.00 169.95 620.00 7.70 38,720.60 215.92 Transaction Vendor_Name Detail (SUBTOTAL) 25,352.19 28,156.72 29,251.72 32,514.22 32,707.49 32,828.49 33,068.93 33,092.81 33,220.81 33,390.76 34,010.76 34,018.46 72,739.06 72,954.98 United Rentals (North America) United Rentals (North America) TK CONTRACTORS LLC CP&Y/WALLACE GROUP, INC. Alfa Laval, Inc ROANOKE WINNELSON CO THE HOME DEPOT 6581 THE HOME DEPOT #6581 THE HOME DEPOT 6581 TRU ROLL OVERHEAD DOOR DHS AUTOMATION, INC TROPHY CLUB MUD PETTY CASH REY-MAR CONSTRUCTION ROANOKE WINNELSON CO. Page 23 Check Source Number 5028 AP 5028 AP 5026 AP 5011 AP 5034 AP PC PC PC PC PC 5039 AP 5062 AP 5059 AP AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 50,419.32 72,954.98 ** 88,000.00 Budgeted 15,045.02 Remaining 83 % Used Account: 135-55085-020-000 Generator Maint. and Repair 4,300.82 .00 4,300.82 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 4,300.82 ** 10,000.00 Budgeted 5,699.18 Remaining 43 % Used Account: 135-55090-020-000 Vehicle Maintenance 872 02/26/2019 PCard 1/29/2019 -2/26/2019 872 02/26/2019 PCard 1/29/2019 -2/26/2019 872 02/26/2019 PCard 1/29/2019 -2/26/2019 clevis pin triball mount oil change 183.67 8.54 192.21 THE HOME DEPOT 6581 46.79 239.00 THE HOME DEPOT 6581 61.52 300.52 KWIK KAR LUBE & TUNE 0 PC PC PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 116.85 300.52 ** 8,000.00 Budgeted 7,699.48 Remaining 4 6 Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 872 02/26/2019 PCard 1/29/2019 -2/26/2019 833 02/28/2019 February A/P carb clnr mini trackhoe repair 1,533.28 49.98 1,583.26 ROANOKE AUTO SUPPLY LT 5,096.62 6,679.88 HOLT CAT PC 5042 AP Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 5,146.60 6,679.88 ** 1,500.00 Budgeted (5,179.88) Remaining 445 % Used Account: 135-55120-020-000 Cleaning Services glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 2/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail .00 Transaction Vendor_Name Detail (SUBTOTAL) .00 Page 24 Check Source Number 696 02/06/2019 696 02/06/2019 788 02/20/2019 788 02/20/2019 788 02/20/2019 788 02/20/2019 833 02/28/2019 833 02/28/2019 February A/P February A/P February A/P February A/P February A/P February A/P February A/P February A/P Effluent testing effluent testing Lab testing lab testing lab supplies Annual calibration effluent testing Effluent testing 16,326.24 317.40 230.00 317.40 230.00 1,703.47 327.54 230.00 317.40 16,643.64 16,873.64 17,191.04 17,421.04 19,124.51 19,452.05 19,682.05 19,999.45 OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC IDEXX DISTRIBUTION, INC METTLER TOLEDO INTERNATIONAL OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC 4993 4993 5058 5058 5045 5055 5058 5058 AP AP AP AP AP AP AP AP Account: 135-55135-020-000 Lab Analysis Totals: 3,673.21 19,999.45 ** 35,000.00 Budgeted 15,000.55 Remaining 57 % Account: 135-55120-020-000 Cleaning Services Totals: Account: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used 434.95 1,927.01 VERIZON WIRELESS 5030 AP Account: 135-60010-020-000 Account: 135-55125-020-000 Dumpster Services 1,927.01 ** 5,000.00 Budgeted 3,072.99 Remaining 39 % Used 774 02/18/2019 788 02/20/2019 833 02/28/2019 February A/P February A/P February A/P sludge haul off Sludge haul off Account: 24,999.76 Electricity 1,690.00 2,535.00 2,535.00 26,689.76 29,224.76 31,759.76 L.H. L.H. L.H. CHANEY MATERIALS, CHANEY MATERIALS, CHANEY MATERIALS, INC. INC. INC. 5015 5050 5050 AP AP AP Account: 135-55125-020-000 Dumpster Services Totals: 6,760.00 31,759.76 ** 75,000.00 Budgeted 43,240.24 Remaining 42 % Used Account: 135-55135-020-000 Lab Analysis 696 02/06/2019 696 02/06/2019 788 02/20/2019 788 02/20/2019 788 02/20/2019 788 02/20/2019 833 02/28/2019 833 02/28/2019 February A/P February A/P February A/P February A/P February A/P February A/P February A/P February A/P Effluent testing effluent testing Lab testing lab testing lab supplies Annual calibration effluent testing Effluent testing 16,326.24 317.40 230.00 317.40 230.00 1,703.47 327.54 230.00 317.40 16,643.64 16,873.64 17,191.04 17,421.04 19,124.51 19,452.05 19,682.05 19,999.45 OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC IDEXX DISTRIBUTION, INC METTLER TOLEDO INTERNATIONAL OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC 4993 4993 5058 5058 5045 5055 5058 5058 AP AP AP AP AP AP AP AP Account: 135-55135-020-000 Lab Analysis Totals: 3,673.21 19,999.45 ** 35,000.00 Budgeted 15,000.55 Remaining 57 % Used Account: 135-60010-020-000 Communications/Mobiles 774 02/18/2019 February A/P Cell phone -February 1,492.06 434.95 1,927.01 VERIZON WIRELESS 5030 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 434.95 1,927.01 ** 5,000.00 Budgeted 3,072.99 Remaining 39 % Used Account: 135-60020-020-000 Electricity 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 833 02/28/2019 February A/P 880 02/28/2019 Town Billed Invoices 1676-1679 Electricity 12/27-1/28 Electricity 12/27-1/28 Electricity 12/27-1/28 Electricity 1/9-2/8 AR 20190228-20190228 User: 64,079.09 193.64 277.85 29.34 177.47 (480.18) 64,272.73 64,550.58 64,579.92 64,757.39 64,277.21 TRI COUNTY ELECTRIC TRI COUNTY ELECTRIC TRI COUNTY ELECTRIC HUDSON ENERGY SERVICES, LLC 5027 5027 5027 5044 AP AP AP AP AR glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-60020-020-000 Account: 135-60066-020-000 Account: 135-60066-020-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 2/2019 JE Detail Beginning Balance Description/Comment Electricity Totals: 174,165.00 Budgeted 109,887.79 Remaining Account: 135-60070-020-000 Account: 135-60070-020-000 Account: 135-60080-020-000 833 02/28/2019 February A/P 833 02/28/2019 February A/P 833 02/28/2019 February A/P 833 02/28/2019 February A/P Account: 135-60080-020-000 Account: 135-60090-020-000 Account: 135-60090-020-000 Publications/Books/Subscripts Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Dues & Memberships Dues & Memberships Totals: 300.00 Budgeted 231.00 Remaining Schools & Training Petty cash reimbursement Petty cash reimbursement -Steve Petty cash reimbursement -Steve Petty cash reimbursement -Steve Schools & Training Totals: 7,155.00 Budgeted 6,292.05 Remaining Safety Program Safety Program Totals: 1,000.00 Budgeted 899.26 Remaining Account: 135-60100-020-000 Travel & per diem 776 02/22/2019 MUD Payroll 02/22/2019 872 02/26/2019 PCard 1/29/2019 -2/26/2019 Account: 135-60100-020-000 Travel & per diem training class Travel & per diem Totals: 1,895.00 Budgeted 69.00 Program: Transaction Detail 37 % Used 0 % Used 23 % Used 198.12 .00 .00 .00 .00 Transaction Vendor_Name Detail (SUBTOTAL) 64,277.21 ** .00 .00 ** 69.00 69.00 ** 741.00 25.00 766.00 TROPHY CLUB MUD PETTY CASH 25.00 791.00 TROPHY CLUB MUD PETTY CASH 25.00 816.00 TROPHY CLUB MUD PETTY CASH 46.95 862.95 TROPHY CLUB MUD PETTY CASH 100.74 12 % Used 121.95 .00 10 % Used .00 127.53 27.58 1,739.89 Remaining 8 % Used 155.11 862.95 ** 100.74 100.74 ** 127.53 155.11 TURN 3 BBQ 155.11 ** Page 25 Check Source Number 5062 AP 5062 AP 5062 AP 5062 AP PR PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 Account: 135-60125-020-000 Account: 135-60125-020-000 Account: 135-60135-020-000 Account: 135-60135-020-000 Account: 135-60245-020-000 Rent/Lease Equipment Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Advertising Advertising Totals: 2,500.00 Budgeted TCEQ Fees & Permits TCEQ Fees & Permits 30,000.00 Budgeted Miscellaneous Expenses 2,500.00 Remaining 16,545.22 0 % Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 16,545.22 Totals: 13,454.78 Remaining 55 % Used .00 16,545.22 ** .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** Account: 135-60280-020-000 Account: 135-60280-020-000 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 450.00 Remaining 225.18 0 % Used Totals: 4,774.82 Remaining 5 % Used .00 225.18 .00 225.18 ** Account: 135-60285-020-000 Lawn Equipment & Maintenance Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 11,600.00 Budgeted 10,952.16 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax ISS 647.84 .00 647.84 .00 647.84 ** 6 % Used glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 828 02/28/2019 TexPool Transfers February Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 2/2019 JE Detail Beginning Balance Description/Comment TexPool O&M to I&S- PID Debt 43,655.60 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 10,913.90 54,569.50 Page 27 Check Source Number GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,913.90 54,569.50 ** 120,053.00 Budgeted 65,483.50 Remaining 45 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 828 02/28/2019 TexPool Transfers February TexPool O&M to Rev Bd WWTP I&S 216,813.80 54,203.45 271,017.25 GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 54,203.45 271,017.25 ** 688,330.00 Budgeted 417,312.75 Remaining 39 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 828 02/28/2019 TexPool Transfers February TexPool O&M to Rev Bond Resevr 41,728.00 10,432.00 52,160.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 10,432.00 52,160.00 ** 125,187.00 Budgeted 73,027.00 Remaining 42 % Used Account: 135-60334-020-000 Interfund Transfer Out ' .00 .00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 821 02/24/2019 February Fuel A/P Fuel 3,953.89 1,609.96 5,563.85 US Bank Voyager Fleet Systems 5063 AP Account: 135-65005-020-000 Fuel & Lube Totals: 1,609.96 5,563.85 ** 12,500.00 Budgeted 6,936.15 Remaining 45 % Used Account: 135-65010-020-000 Uniforms 2,059.90 .00 2,059.90 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-65010-020-000 Uniforms Totals: .00 2,059.90 ** 5,495.00 Budgeted Account: 135-65030-020-000 Chemicals 774 02/18/2019 February A/P chemicals Account: 135-65030-020-000 3,435.10 Remaining 37 % Used Chemicals Totals: 30,000.00 Budgeted Account: 135-65035-020-000 Small Tools 2,753.78 547.00 3,300.78 Valley Solvent Company, INC 26,699.22 Remaining 11 % Used 54.95 547.00 .00 Account: 135-65035-020-000 Small Tools Totals: .00 1,200.00 Budgeted Account: 135-65040-020-000 Safety Equipment 872 02/26/2019 PCard 1/29/2019 -2/26/2019 earplugs Account: 135-65040-020-000 1,145.05 Remaining 5 5 Used Safety Equipment Totals: 1,200.00 Budgeted 3,300.78 ** 54.95 54.95 ** 5029 AP 843.55 252.14 1,095.69 GRAINGER PC 104.31 Remaining 91 6 Used Account: 135-65045-020-000 Lab Supplies 872 02/26/2019 PCard 1/29/2019 -2/26/2019 water 872 02/26/2019 PCard 1/29/2019 -2/26/2019 cooler minus reward points red 833 02/28/2019 February A/P gloves Account: 135-65045-020-000 Account: 135-69005-020-000 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 912 02/28/2019 February A/p Lab Supplies 20,000.00 Budgeted 3,138.64 Totals: 16,650.17 Remaining 17 % Used Capital Outlays legal-WWTP 405,880.81 WWTP Improvements WWTP water system 252.14 1,095.69 ** 5.94 3,144.58 TOM THUMB #1789 PC 53.25 3,197.83 THE HOME DEPOT 6581 PC 152.00 3,349.83 LOU'S GLOVES INCORPORATED 5052 AP 211.19 3,349.83 ** 1,190.00 5,048.19 23,440.52 8,969.67 407,070.81 Dubois Bryant Campbell LLP 412,119.00 CP6Y/WALLACE GROUP, INC. 435,559.52 CP&Y/WALLACE GROUP, INC. 444,529.19 Halff Associates, INC 5012 AP 5011 AP 5011 AP AP Account: 135-69005-020-000 Capital Outlays Totals: 38,648.38 444,529.19 ** 330,000.00 Budgeted (114,529.19) Remaining 135 % Used glpdatb2 skrolczyk 18:02 03/13/19 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: 2/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 29 Check Source Number Department 20 Totals: .00 Budgeted 225,862.77 Monthly Total (1,500.00) Remaining 0 % Used 1,353,788.47 ** 2,872,082.00 Budgeted 1,518,293.53 Remaining 47 % Used Account: 135-69008-020-000 Short Term Debt -Principal 39,858.59 .00 39,858.59 Account: 135-69008-020-000 Short Term Debt -Principal Totals: .00 39,858.59 ** 109,858.00 Budgeted 69,999.41 Remaining 36 % Used Account: 135-69009-020-000 Short Term Debt -Interest 3,027.55 .00 3,027.55 Account: 135-69009-020-000 Short Term Debt -Interest Totals: .00 3,027.55 ** 14,917.00 Budgeted 11,889.45 Remaining 20 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Account: 135-70020-020-000 Capital Lease Issuance Cost ' 1,500.00 .00 1,500.00 Account: 135-70020-020-000 Capital Lease Issuance Cost Totals: .00 1,500.00 ** Department 20 Totals: .00 Budgeted 225,862.77 Monthly Total (1,500.00) Remaining 0 % Used 1,353,788.47 ** 2,872,082.00 Budgeted 1,518,293.53 Remaining 47 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 129 02/01/2019 Insurance/Wrk Comp Expense Feb 8.48 Account: 135-50045-026-000 Workman's Compensation Totals: 30.00 Budgeted Account: 135-60066-026-000 Publications/Books/Subscripts Account: 135-60066-026-000 Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 19.40 Remaining 35 % Used 2.12 10.60 GL 2.12 10.60 ** .00 0 % Used .00 .00 .00 ** Account: 135-60070-026-000 Dues & Memberships 650.00 .00 650.00 Account: 135-60070-026-000 Dues & Memberships Totals: .00 650.00 ** 750.00 Budgeted 100.00 Remaining 87 % Used Account: 135-60075-026-000 Meetings 872 02/26/2019 PCard 1/29/2019 -2/26/2019 Board meeting refreshments 833 02/28/2019 February A/P Petty cash reimbursement -Steve 18.42 18.42 TOM THUMB #1789 PC 4.98 23.40 TROPHY CLUB MUD PETTY CASH 5062 AP Account: 135-60075-026-000 Meetings Totals: 23.40 23.40 ** 1,300.00 Budgeted Account: 135-60080-026-000 Schools & Training 1,276.60 Remaining 2 % Used 565.00 .00 565.00 Account: 135-60080-026-000 Schools & Training Totals: .00 565.00 ** 4,000.00 Budgeted 3,435.00 Remaining 14 % Used Account: 135-60100-026-000 Travel & per diem 338.57 .00 338.57 Account: 135-60100-026-000 Travel & per diem Totals: .00 338.57 ** 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 4,661.43 Remaining 7 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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: 1,587.57 ** 25.52 Monthly Total 13,230.00 Budgeted 11,642.43 Remaining 12 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 Salaries & Wages 687 02/08/2019 MUD Payroll 02/08/2019 Salaries & Wages 776 02/22/2019 MUD Payroll 02/22/2019 Salaries & Wages Account: 135-50005-030-000 1 Salaries & Wages 441,006.00 Budgeted 112,373.14 14,160.82 126,533.96 PR 15,828.97 142,362.93 PR Totals: 298,643.07 Remaining 32 % Used 29,989.79 142,362.93 ** Account: 135-50010-030-000 Overtime 10.45 .00 10.45 Account: 135-50010-030-000 Overtime Totals: .00 10.45 ** 2,000.00 Budgeted 1,989.55 Remaining 1 % Used Account: 135-50016-030-000 Longevity 1,832.50 .00 1,832.50 Account: 135-50016-030-000 Longevity Totals: .00 1,832.50 ** 1,833.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 687 02/08/2019 MUD Payroll 02/08/2019 Retirement 776 02/22/2019 MUD Payroll 02/22/2019 Retirement 11,925.20 1,309.86 13,235.06 PR 1,464.18 14,699.24 PR Account: 135-50020-030-000 Retirement Totals: 2,774.04 14,699.24 ** 41,148.00 Budgeted Account: 135-50026-030-000 Medical Insurance 687 02/08/2019 MUD Payroll 02/08/2019 Medical Insurance 776 02/22/2019 MUD Payroll 02/22/2019 Medical Insurance 26,448.76 Remaining 36 % Used 17,260.14 2,412.24 19,672.38 PR 2,412.18 22,084.56 PR Account: 135-50026-030-000 Medical Insurance Totals: 4,824.42 22,084.56 ** 81,895.00 Budgeted Account: 135-50027-030-000 Dental Insurance 687 02/08/2019 MUD Payroll 02/08/2019 Dental Insurance 776 02/22/2019 MUD Payroll 02/22/2019 Dental Insurance Account: 135-50027-030-000 59,810.44 Remaining 27 % Used 1,038.08 129.78 1,167.86 PR 129.74 1,297.60 PR Dental Insurance Totals: 259.52 1,297.60 ** 4,291.00 Budgeted 2,993.40 Remaining 30 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 Vision Insurance 687 02/08/2019 MUD Payroll 02/08/2019 Vision Insurance 776 02/22/2019 MUD Payroll 02/22/2019 Vision Insurance 170.04 1 21.28 21.23 191.32 212.55 PR PR Account: 135-50028-030-000 Vision Insurance Totals: 42 5 ** Account: 135-50029-030-000 638 02/01/2019 February A/P 638 02/01/2019 February A/P 833 02/28/2019 February A/P 701.00 Budgeted Life Insurance & Other Employee Benefits Employee LTD & STD Caf 125 488.45 Remaining 30 % Used 1,154.62 147.56 1,302.18 Humana Inc 143.16 1,445.34 METLIFE GROUP BENEFITS 22.00 1,467.34 BenefitMall 4965 AP 4975 AP 5035 AP Account: 135-50029-030-000 Life Insurance & Other Totals: 312.72 1,467.34 ** 4,495.00 Budgeted 3,027.66 Remaining 33 8 Used Account: 135-50030-030-000 Social Security Taxes 687 02/08/2019 MUD Payroll 02/08/2019 Social Security Taxes 776 02/22/2019 MUD Payroll 02/22/2019 Social Security Taxes 6,799.79 837.62 7,637.41 PR 938.13 8,575.54 PR Account: 135-50030-030-000 Social Security Taxes Totals: 1,775.75 8,575.54 ** 27,580.00 Budgeted Account: 135-50035-030-000 Medicare Taxes 687 02/08/2019 MUD Payroll 02/08/2019 Medicare Taxes 776 02/22/2019 MUD Payroll 02/22/2019 Medicare Taxes 19,004.46 Remaining 31 % Used 1,590.27 195.90 1,786.17 PR 219.41 2,005.58 PR Account: 135-50035-030-000 Medicare Taxes Totals: 415.31 2,005.58 ** Account: 135-50040-030-000 687 02/08/2019 MUD Payroll 02/08/2019 776 02/22/2019 MUD Payroll 02/22/2019 6,450.00 Budgeted Unemployment Taxes Unemployment Taxes Unemployment Taxes 4,444.42 Remaining 31 % Used 509.31 180.50 689.81 PR 151.20 841.01 PR Account: 135-50040-030-000 Unemployment Taxes Totals: 331.70 841.01 ** 1,260.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 129 02/01/2019 Insurance/Wrk Comp Expense Feb 418.99 Remaining 67 6 Used 426.20 106.55 532.75 GL glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund OE Number JE JE Date Description 841 02/12/2019 TML Refund W/C FY 18 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 2/2019 Beginning Balance JE Detail Description/Comment Admin Portion of W/C Refund 426.20 Program: Transaction Detail (39.60) Transaction Vendor_Name Detail (SUBTOTAL) 493.15 Page 34 Check Source Number GL 774 774 774 872 872 872 872 02/18/2019 02/18/2019 02/18/2019 02/26/2019 02/26/2019 02/26/2019 02/26/2019 February A/P February A/P February A/P PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 Vision Annual License Internet -Feb Microsoft exchange internet internet internet Adobe Pro 36,781.68 943.20 903.72 504.00 110.13 51.75 42.02 32.45 37,724.88 38,628.60 39,132.60 39,242.73 39,294.48 39,336.50 39,368.95 STW INC Charter Communications M3 Networks ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS 5021 5009 5016 AP AP AP PC PC PC PC Account: 135-55030-030-000 Software & Support Totals: 2,587.27 39,368.95 ** Account: 135-50045-030-000 Workman's Compensation Totals: 77,849.00 Budgeted 38,480.05 Remaining 66.95 493.15 ** Account: 1,295.00 Budgeted 801.85 Remaining 38 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 912 02/28/2019 February A/p 912 02/28/2019 February A/p GM February 2019 GM February 2019 48,410.62 6.54 9,760.00 48,417.16 58,177.16 Carman Consulting LLC. Carman Consulting LLC. AP AP 103.95 135-55070-030-000 .00 103.95 Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 103.95 ** 33 % Used 500.00 Budgeted 396.05 Remaining 21 % Used Account: 135-55080-030-000 Maintenance & Repairs Account: 135-50070-030-000 Employee Relations 872 02/26/2019 PCard 1/29/2019 872 02/26/2019 PCard 1/29/2019 -2/26/2019 safety meeting -2/26/2019 Timis Going Away/safety meetin 2,883.23 33.36 36.98 2,916.59 2,953.57 KIM S DONUT SQU*SQ *CINNABOLIC-S0U PC PC Account: 135-50070-030-000 Employee Relations Totals: 70.34 2,953.57 ** 5,000.00 Budgeted 2,046.43 Remaining 59 % Used Account: 135-55030-030-000 Software & Support 774 774 774 872 872 872 872 02/18/2019 02/18/2019 02/18/2019 02/26/2019 02/26/2019 02/26/2019 02/26/2019 February A/P February A/P February A/P PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 Vision Annual License Internet -Feb Microsoft exchange internet internet internet Adobe Pro 36,781.68 943.20 903.72 504.00 110.13 51.75 42.02 32.45 37,724.88 38,628.60 39,132.60 39,242.73 39,294.48 39,336.50 39,368.95 STW INC Charter Communications M3 Networks ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS 5021 5009 5016 AP AP AP PC PC PC PC Account: 135-55030-030-000 Software & Support Totals: 2,587.27 39,368.95 ** 77,849.00 Budgeted 38,480.05 Remaining 51 % Used Account: 135-55070-030-000 Independent Labor 912 02/28/2019 February A/p 912 02/28/2019 February A/p GM February 2019 GM February 2019 48,410.62 6.54 9,760.00 48,417.16 58,177.16 Carman Consulting LLC. Carman Consulting LLC. AP AP Account: 135-55070-030-000 Independent Labor Totals: 9,766.54 58,177.16 ** 175,000.00 Budgeted 116,822.84 Remaining 33 % Used Account: 135-55080-030-000 Maintenance & Repairs glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 774 02/18/2019 February A/P 788 02/20/2019 February A/P roof repair 795.00 3,350.00 heat repair 195.00 4,145.00 TK CONTRACTORS LLC 5026 AP 4,340.00 BRANDON R REED 5036 AP Account: 135-55080-030-000 Maintenance & Repairs Totals: 3,545.00 4,340.00 ** 20,000.00 Budgeted 15,660.00 Remaining 22 6 Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining Account: 135-55120-030-000 Cleaning Services 788 02/20/2019 February A/P Janitorial service -January 0 % Used 2,607.18 869.06 3,476.24 MEMBER'S BUILDING MAINTENANCE 5053 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 3,476.24 ** 10,000.00 Budgeted 6,523.76 Remaining 35 % Used Account: 135-55160-030-000 Professional Outside Services Account: 135-55160-030-000 Professional Outside Services Totals: 66,055.00 Budgeted 6,850.00 Remaining Account: 135-55205-030-000 Utility Billing Contract 912 02/28/2019 February A/p Billings -Feb Account: 135-55205-030-000 Utility Billing Contract Totals: 9,000.00 Budgeted 6,095.61 Remaining Account: 135-60005-030-000 Telephone 663 02/01/2019 February A/P Answering service -February 872 02/26/2019 PCard 1/29/2019 -2/26/2019 phone 872 02/26/2019 PCard 1/29/2019 -2/26/2019 phone 872 02/26/2019 PCard 1/29/2019 -2/26/2019 phone 872 02/26/2019 PCard 1/29/2019 -2/26/2019 Answering service 880 02/28/2019 Town Billed Invoices 1676-1679 AR 20190228-20190228 User: 59,205.00 90 % Used .00 59,205.00 .00 59,205.00 ** 2,321.98 582.41 32 6 Used 2,904.39 DATAPROSE LLC AP 582.41 2,904.39 ** 6,028.82 194.75 6,223.57 KEYSTONE PARK SECRETARIAL 4968 AP 862.46 7,086.03 ATT*BUS PHONE PMT PC 461.43 7,547.46 ATT*BUS PHONE PMT PC 163.20 7,710.66 ATT*BILL PAYMENT PC 14.99 7,725.65 RINGCENTRAL, INC PC (180.00) 7,545.65 AR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-60005-030-000 Telephone Totals: 1,516.83 7,545.65 ** 23,500.00 Budgeted 15,954.35 Remaining 32 % Used Account: 135-60010-030-000 Communications/Mobiles 774 02/18/2019 February A/P Cell phone -February 776 02/22/2019 MUD Payroll 02/22/2019 Communications/Mobiles 950.02 87.55 1,037.57 VERIZON WIRELESS 5030 AP 150.00 1,187.57 PR Account: 135-60010-030-000 Communications/Mobiles Totals: 237.55 1,187.57 ** 4,000.00 Budgeted 2,812.43 Remaining 30 % Used Account: 135-60020-030-000 Electricity/Gas 1,490.11 .00 1,490.11 Account: 135-60020-030-000 Electricity/Gas ' Totals: .00 1,490.11 ** 8,690.00 Budgeted 7,199.89 Remaining 17 % Used Account: 135-60025-030-000 Wier 870 02/28/2019 February check run Water bill -February 215.12 128.33 343.45 TROPHY CLUB MUD (WATER BILLS) 5084 AP 880 02/28/2019 Town Billed Invoices 1676-1679 AR 20190228-20190228 User: (64.16) 279.29 AR Account: 135-60025-030-000 Water Totals: 64.17 279.29 ** 2,000.00 Budgeted 1,720.71 Remaining 14 % Used Account: 135-60035-030-000 Postage 872 02/26/2019 PCard 1/29/2019 -2/26/2019 Halff TCEQ Paperwork 6,675.30 33.88 6,709.18 FEDEX 31720411 PC 912 02/28/2019 February A/p Billings -Feb 1,640.30 8,349.48 DATAPROSE LLC AP Account: 135-60035-030-000 Postage Totals: 1,674.18 8,349.48 ** 30,000.00 Budgeted 21,650.52 Remaining 28 % Used Account: 135-60040-030-000 Service Charges & Fees 688 02/08/2019 Child Support Fee 774 02/18/2019 February A/P 779 02/22/2019 Child Support Fee 829 02/28/2019 Pace Credit Card Fees 829 02/28/2019 Pace Credit Card Fees 912 02/28/2019 February A/p service fees -Dig Tess Service fees -Dig Tess 23,023.78 1.50 23,025.28 GL 199.50 23,224.78 Texas Excavation Safety System 5024 AP 1.50 23,226.28 GL 5,119.15 28,345.43 GL 90.81 28,436.24 GL 199.50 28,635.74 Texas Excavation Safety System AP glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 912 02/28/2019 February A/p Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 2/2019 JE Detail Beginning Balance Description/Comment Direct send fees Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 23,023.78 50.00 28,685.74 Fisery Solutions, LLC Page 37 Check Source Number AP Account: 135-60040-030-000 Service Charges & Fees Totals: 5,661.96 28,685.74 ** 55,560.00 Budgeted 26,874.26 Remaining 52 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 129 02/01/2019 Insurance/Wrk Comp Expense Feb 25,210.92 6,302.73 31,513.65 GL Account: 135-60055-030-000 Insurance ' Totals: 6,302.73 31,513.65 ** 65,000.00 Budgeted 33,486.35 Remaining 48 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 872 02/26/2019 PCard 1/29/2019 -2/26/2019 SHRM Membership- Desiree 872 02/26/2019 PCard 1/29/2019 -2/26/2019 Prime Membership 3,801.25 189.00 119.00 3,990.25 4,109.25 SHRM*MEMBER601001523 AMAZON PRIME PC PC Account: 135-60070-030-000 Dues & Memberships Totals: 308.00 4,109.25 ** 6,000.00 Budgeted 1,890.75 Remaining 68 % Used Account: 135-60075-030-000 Meetings .00 .00 Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education glpdatb2 skrolczyk 18:02 03/13/19 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: 2/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Page 38 Check Source Number Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 135.00 .00 135.00 Account: 135-60080-030-000 Schools & Training Totals: .00 135.00 ** 8,950.00 Budgeted 8,815.00 Remaining 2 % Used Account: 135-60100-030-000 Travel & per diem 833 02/28/2019 February A/P 912 02/28/2019 February A/p tolls Tolls to lab 6.00 2.70 6.00 8.70 NTTA NTTA 5056 AP AP Account: 135-60100-030-000 Travel & per diem Totals: 8.70 8.70 ** 4,345.00 Budgeted 4,336.30 Remaining 0 % 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-60125-030-000 Advertising .00 .00 Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 25,000.00 Budgeted 25,000.00 Remaining 0 % Used Account: 135-60235-030-000 Security 833 02/28/2019 February A/P monitoring svc-Feb 96.00 24.00 120.00 Digital Air Control, Inc 5040 AP Account: 135-60235-030-000 Security Totals: 24.00 120.00 ** 1,288.00 Budgeted 1,168.00 Remaining 9 % Used Account: 135-60245-030-000 Miscellaneous Expenses glpdatb2 skrolczyk 18:02 03/13/19 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: 2/2019 JE Detail Beginning Balance Description/Comment 124.49 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 124.49 Page 39 Check Source Number 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P ink and water ink cartridges printer -Carmen office supplies office supplies office supplies paper chair-steven 2,295.86 380.60 101.19 79.99 115.42 50.85 16.76 65.98 330.98 2,676.46 OFFICE DEPOT, INC 2,777.65 OFFICE DEPOT, INC 2,857.64 OFFICE DEPOT, INC 2,973.06 OFFICE DEPOT, INC 3,023.91 OFFICE DEPOT, INC 3,040.67 OFFICE DEPOT, INC 3,106.65 OFFICE DEPOT, INC 3,437.63 OFFICE DEPOT, INC 5018 AP 5018 AP 5018 AP 5018 AP 5018 AP 5018 AP 5018 AP 5018 AP Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 124.49 ** 500.00 Budgeted 375.51 Remaining 25 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms ' .00 .00 Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 2,050.00 Budgeted 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware ' 774 02/18/2019 February A/P laptop -Steven 1,246.49 1,779.32 3,025.81 M3 Networks 5016 AP Account: 135-65055-030-000 Hardware Totals: 1,779.32 3,025.81 ** 7,064.00 Budgeted 4,038.19 Remaining 43 % Used Account: 135-65085-030-000 Office Supplies 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P ink and water ink cartridges printer -Carmen office supplies office supplies office supplies paper chair-steven 2,295.86 380.60 101.19 79.99 115.42 50.85 16.76 65.98 330.98 2,676.46 OFFICE DEPOT, INC 2,777.65 OFFICE DEPOT, INC 2,857.64 OFFICE DEPOT, INC 2,973.06 OFFICE DEPOT, INC 3,023.91 OFFICE DEPOT, INC 3,040.67 OFFICE DEPOT, INC 3,106.65 OFFICE DEPOT, INC 3,437.63 OFFICE DEPOT, INC 5018 AP 5018 AP 5018 AP 5018 AP 5018 AP 5018 AP 5018 AP 5018 AP glpdatb2 skrolczyk 18:02 03/13/19 Fund: 135 MUD 1 General Fund JE Number JE Date 774 02/18/2019 872 02/26/2019 872 02/26/2019 872 02/26/2019 872 02/26/2019 872 02/26/2019 833 02/28/2019 833 02/28/2019 Account: 135-65085-030-000 Account: 135-65090-030-000 Account: 135-65090-030-000 JE Description February A/P PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 February A/P February A/P 1 Account: 135-65095-030-000 774 02/18/2019 February A/P 872 872 872 872 872 02/26/2019 02/26/2019 02/26/2019 02/26/2019 02/26/2019 833 02/28/2019 833 02/28/2019 Account: 135-65095-030-000 Account: 135-65105-030-000 Account: 135-65105-030-000 PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 PCard 1/29/2019 February A/P February A/P Account: 135-69005-030-000 833 02/28/2019 February A/P - 2/26/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 2/2019 JE Detail Beginning Balance Description/Comment office supplies folders rubber stamps Door Hanger Paper envelopes phone charger Label tape bookcase-bert Office Supplies 6,000.00 Budgeted Totals: 1,647.49 Remaining Printer Supplies & Maintenance Printer Supplies & Maintenance Totals: 3,500.00 Budgeted 3,500.00 Remaining Maintenance Supplies cups breakroom restock toilet brush water, towels coffee and popcorn coffee Petty cash reimbursement Petty cash reimbursement - 2/26/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 - 2/26/2019 Maintenance Supplies Totals: 4,000.00 Budgeted 2,027.06 Remaining Printing Printing Totals: 2,500.00 Budgeted 2,500.00 Remaining Capital Outlays Security project -Adjustment fe 2,295.86 1,704.11 Program: Transaction Detail 421.53 27.46 176.39 39.26 29.80 16.99 49.47 153.98 73 9 Used O % Used 49 % Used O 6 Used 2,056.65 .00 .00 13.82 96.26 16.95 27.00 59.48 28.00 9.73 17.59 268.83 .00 .00 Transaction Vendor_Name Detail (SUBTOTAL) 3,859.16 3,886.62 4,063.01 4,102.27 4,132.07 4,149.06 4,198.53 4,352.51 OFFICE DEPOT, INC OFFICE DEPOT #406 PACK N MAIL ZAPCO AMZN MKTP US*MB4R36DE2 AMZN MKTP US*MB4PE9502 OFFICE DEPOT, INC OFFICE DEPOT, INC 4,352.51 ** .00 .00 ** 1,717.93 1,814.19 1,831.14 1,858.14 1,917.62 1,945.62 1,955.35 1,972.94 OFFICE DEPOT, INC SAMSCLUB.COM AMZN MKTP US*MI6805XG0 SAMS CLUB #4795 AMZN MKTP US*MI3CC7JY0 AMZN MKTP US*MB8BLOKF1 TROPHY CLUB MUD PETTY CASH TROPHY CLUB MUD PETTY CASH 1,972.94 ** .00 .00 ** 493.00 493.00 3RD EYE SURVEILLANCE SYSTEMS Page 40 Check Source Number 5018 AP PC PC PC PC PC 5057 AP 5057 AP 5018 AP PC PC PC PC PC 5062 AP 5062 AP 5032 AP glpdatb2 skrolczyk 18:02 03/13/19 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: 2/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 41 Check Source Number Department 30 Totals: 78,905.22 Monthly Total 461,212.67 ** 1,559,905.00 Budgeted 1,098,692.33 Remaining 30 5 Used Account: 135-69005-030-000 Capital Outlays Totals: 493.00 493.00 ** 280,000.00 Budgeted 279,507.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 774 02/18/2019 February A/P 833 02/28/2019 February A/P copier lease Copier lease-feb 1,111.80 194.00 101.97 1,305.80 1,407.77 TIAA COMMERCIAL FINANCE KYOCERA DOCUMENT SOLUTIONS 5025 5049 AP AP Account: 135-69170-030-000 Copier Lease Installments Totals: 295.97 1,407.77 ** 4,000.00 Budgeted 2,592.23 Remaining 35 % Used Department 30 Totals: 78,905.22 Monthly Total 461,212.67 ** 1,559,905.00 Budgeted 1,098,692.33 Remaining 30 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/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 774 02/18/2019 February A/P 774 02/18/2019 February A/P 774 02/18/2019 February A/P Account: 135-55045-039-000 Account: 135-55055-039-000 Account: 135-55055-039-000 Account: 135-55060-039-000 Account: 135-55060-039-000 Account: 135-55065-039-000 Account: 135-55065-039-000 Department 39 Totals: Fund 135 Totals: Legal Legal -Westlake easement legal legal Legal 137,000.00 Budgeted Auditing Auditing 30,800.00 Budgeted Appraisal Appraisal 11,714.00 Budgeted Tax Admin Fees Tax Admin Fees 4,800.00 Budgeted Totals: 84,351.58 Remaining Totals: 4,340.47 Remaining Totals: 6,990.78 Remaining 30,557.18 26,459.53 4,723.22 3,653.00 38 % Used 86 % Used 40 % Used Totals: 1,147.00 Remaining 76 5 Used 22,091.24 Monthly Total 184,314.00 Budgeted 11,111.24 9,930.00 1,050.00 22,091.24 .00 .00 .00 41,668.42 WHITAKER CHALK SWINDLE 51,598.42 McLean & Howard, L.L.P. 52,648.42 McLean & Howard, L.L.P. 52,648.42 ** 26,459.53 26,459.53 ** 4,723.22 .00 4,723.22 ** 5031 AP 5017 AP 5017 AP .00 3,653.00 .00 3,653.00 ** 87,484.17 ** 96,829.83 Remaining 47 % Used 396,634.95 76,500.16 Monthly Total (341,837.00) Budgeted (738,471.95) Remaining ########## glpdatb2 skrolczyk 18:02 03/13/19 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: 2/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 43 Check Source Number Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted (186,420.00) ** 186,420.00 Remaining 0 % Used (186,420.00) 186,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund (105,000.00) .00 (105,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,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 (186,420.00) ** 186,420.00 Remaining 0 % Used (186,420.00) 186,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET FEBRUARY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS 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 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 1,624,377 1,624, 377 (1,479,465) (144,913) (1,624,377) glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 18:02 03/13/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 7.29- 7.29 Subtotal: 7.29- 7.29 Program number: 7.29- 7.29 Department number: Revenues 7.29- 7.29 Revenues Subtotal 7.29- 7.29 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 18:02 03/13/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 28,697.15 144,920.08 144,920.08 - Subtotal: 28,697.15 144,920.08 144,920.08 - Program number: 28,697.15 144,920.08 144,920.08 - Department number: Wastewater 28,697.15 144,920.08 144,920.08 - Expenditures Subtotal 28,697.15 144,920.08 144,920.08 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 28,697.15 144,912.79 144,912.79- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/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-49010-000-000 Interest Income Account: 517-49010-000-000 Department Totals: (7.29) .00 (7.29) Interest Income Totals: .00 (7.29) ** .00 Budgeted 7.29 Remaining 0 % Used .00 Monthly Total .00 Budgeted (7.29) ** 7.29 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/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 Capital Outlays 788 02/20/2019 February A/P WWTP Improvements 116,222.93 25,300.00 141,522.93 WEBBER-CADAGUA PARTNERS 5064 AP 912 02/28/2019 February A/p WWTP improvements 3,397.15 144,920.08 WEBBER-CADAGUA PARTNERS AP Account: 517-69005-020-000 Capital Outlays Totals: 28,697.15 144,920.08 ** .00 Budgeted (144,920.08) Remaining 0 % Used Department 20 Totals: 144,920.08 ** 28,697.15 Monthly Total .00 Budgeted (144,920.08) Remaining 0 % Used Fund 517 Totals: 144,912.79 28,697.15 Monthly Total .00 Budgeted (144,912.79) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET FEBRUARY 2019 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 767,358 TOTAL ASSETS 767,358 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 754,200 NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 754,200 TOTAL LIABILITIES AND FUND BALANCE 767,358 TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET FEBRUARY 2019 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND 45,000 TOTAL ASSETS 45,000 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 411,246 TOTAL LIABILITIES 411,246 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE (366,246) (366,246) 45,000 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET FEBRUARY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 688,126 TOTAL ASSETS 688,126 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 606,910 81,216 688,126 688,126 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 18:02 03/13/19 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-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 5,000.00- 5,000.00- 55,193.00- 55,193.00- 125,187.00- 125,187.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 1,236.52- 6,056.01- 4,600.00- 23,000.00- 10,432.00- 52,160.00- 16,268.52- 81,216.01- 16,268.52- 81,216.01- 16,268.52- 81,216.01- 16,268.52- 81,216.01- 16,268.52- 81,216.01- 121.120 41.672 41.666 43.811 43.811 43.811 43.811 43.811 1,056.01 32,193.00- 73,027.00- 104,163.99- 104,163.99- 104,163.99- 104,163.99- 104,163.99- glpdatb2 skrolczyk 18:02 03/13/19 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 528-49010-000-000 Interest Income 868 02/28/2019 Bank Interest- February Account: 528-49010-000-000 Trophy Club MUD No.1 Page 46 Detailed Accounting Trial Balance Program: Period Ending: 2/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (5,000.00) Budgeted (4,819.49) (1,236.52) 1,056.01 Remaining 121 5 Used Account: 528-49142-000-000 Interfund transfer in -Water 828 02/28/2019 TexPool Transfers February TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (18,400.00) (55,193.00) Budgeted (32,193.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 828 02/28/2019 TexPool Transfers February TexPool O&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (6,056.01) GL (1,236.52) (6,056.01) ** (4,600.00) (23,000.00) GL 42 % Used (41,728.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (73,027.00) Remaining (4,600.00) (23,000.00) ** (10,432.00) (52,160.00) GL 42 9 Used (16,268.52) Monthly Total (185,380.00) Budgeted (16,268.52) Monthly Total (185,380.00) Budgeted (10,432.00) (52,160.00) ** (81,216.01) ** (104,163.99) Remaining 44 % Used (81,216.01) (104,163.99) Remaining 44 8 Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET FEBRUARY 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER \4 TROPHY CLUB MUNICIPAL UTILITY (DISTRICT INTEREST & SINKING- 533 4,573 851,517 33,434 TOTAL ASSETS 889,524 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 33,434 TOTAL LIABILITIES 33,434 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 53,289 802,800 TOTAL FUND BALANCE 856,089 TOTAL LIABILITIES AND FUND BALANCE 889,524 glbase_tbam skrolczyk 18:02 03/13/19 Fund: 533 MUD 1 I&S Consolidated Account Description 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 Page 17 Budget Summary with Amendment Department: Revenues Program: Period Ending: 2/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 687,175.00- 1,800.00- 2,000.00- 687,175.00- 1,800.00- 2,000.00- 52,398.52- 790.04- 649.64- 661,480.81- 1,323.68- 834.50- 96.261 73.538 41.725 25,694.19- 476.32- 1,165.50 - Subtotal: 690,975.00- 690,975.00- 53,838.20- 663,638.99- 96.044 27,336.01- 533-49010-000-000 533-49015-000-000 Interest Income Lease/Rental Income 2,000.00- 215,979.00- 2,000.00- 215,979.00- 1,307.22- 215,979.00- 3,091.69- 215,979.00- 154.585 100.000 1,091.69 533-49141-000-000 Interfund Trans In -PID Surchg 120,053.00- 120,053.00- 10,913.90- 54,569.50- 45.455 65,483.50 - Subtotal: 338,032.00- 338,032.00- 228,200.12- 273,640.19- 80.951 64,391.81 - Program number: 1,029,007.00- 1,029,007.00- 282,038.32- 937,279.18- 91.086 91,727.82 - Department number: Revenues 1,029,007.00- 1,029,007.00- 282,038.32- 937,279.18- 91.086 91,727.82 - Revenues Subtotal 1,029,007.00- 1,029,007.00- 282,038.32- 937,279.18- 91.086 91,727.82- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 18:02 03/13/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/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 266,058.00 266,058.00 533-70035-051-000 Bond Principal Payment -Tax 755,000.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 1,023,208.00 Department number: Administration Expenditures Fund number: 533 MUD 1 I&S Consolidated Subtotal 1,023,208.00 1,023,208.00 1,023,208.00 1,023,208.00 5,799.00- 5,799.00- 1,450.00 1,450.00 133,028.75 133,028.75 134,478.75 134,478.75 134,478.75 134,478.75 134,478.75 134,478.75 134,478.75 134,478.75 147,559.57- 802,800.43- ############### 67.442 700.00 50.000 133,029.25 755,000.00 13.143 888,729.25 13.143 888,729.25 13.143 888,729.25 13.143 888,729.25 797,001.43 glpdatb2 skrolczyk 18:02 03/13/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 2/2019 JE Detail Description/Comment Page 47 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 882 02/01/2019 Property Taxes 885 02/04/2019 Property Taxes 886 02/05/2019 Property Taxes 888 02/06/2019 Property Taxes 889 02/07/2019 Property Taxes 890 02/08/2019 Property Taxes 891 02/11/2019 Property Taxes 892 02/12/2019 Property Taxes 893 02/13/2019 Property Taxes 894 02/14/2019 Property Taxes 895 02/15/2019 Property Taxes 896 02/19/2019 Property Taxes 897 02/20/2019 Property Taxes 898 02/21/2019 Property Taxes 899 02/22/2019 Property Taxes 900 02/25/2019 Property Taxes 908 02/26/2019 Property Taxes 902 02/28/2019 Property Taxes (609,082.29) (5,616.64) (6,544.00) (11,827.31) (8,486.39) (13,410.71) (334.50) (36.70) (377.41) (844.33) (141.05) (151.07) (4,116.50) 230.31 (188.84) 109.41 (158.71) (444.73) (59.35) (614,698.93) (621,242.93) (633,070.24) (641,556.63) (654,967.34) (655,301.84) (655,338.54) (655,715.95) (656,560.28) (656,701.33) (656,852.40) (660,968.90) (660,738.59) (660,927.43) (660,818.02) (660,976.73) (661,421.46) (661,480.81) 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: (52,398.52) (661,480.81) ** (687,175.00) Budgeted (25,694.19) Remaining 96 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 882 02/01/2019 Property Taxes 886 02/05/2019 Property Taxes 888 02/06/2019 Property Taxes 889 02/07/2019 Property Taxes 893 02/13/2019 Property Taxes 894 02/14/2019 Property Taxes 900 02/25/2019 Property Taxes 901 02/27/2019 Property Taxes 902 02/28/2019 Property Taxes (533.64) (.12) (130.55) (.33) (4.74) (.25) 22.73 (48.30) (605.51) (22.97) (533.76) (664.31) (664.64) (669.38) (669.63) (646.90) (695.20) (1,300.71) (1,323.68) GL GL GL GL GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (790.04) (1,323.68) ** (1,800.00) Budgeted (476.32) Remaining 74 6 Used Account: 533-40015-000-000 Property Taxes/P & I 882 02/01/2019 Property Taxes 885 02/04/2019 Property Taxes 886 02/05/2019 Property Taxes (184.86) (19.77) (9.11) (25.74) (204.63) (213.74) (239.48) GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 48 888 02/06/2019 Property Taxes 889 02/07/2019 Property Taxes 890 02/08/2019 Property Taxes 891 02/11/2019 Property Taxes 892 02/12/2019 Property Taxes 893 02/13/2019 Property Taxes 894 02/14/2019 Property Taxes 895 02/15/2019 Property Taxes 896 02/19/2019 Property Taxes 898 02/21/2019 Property Taxes 900 02/25/2019 Property Taxes 908 02/26/2019 Property Taxes 901 02/27/2019 Property Taxes 902 02/28/2019 Property Taxes (184.86) (.04) (8.64) (21.44) (18.33) (26.43) (59.14) (9.87) (10.57) (288.16) (13.22) (23.19) (31.13) (34.70) (50.16) (239.52) (248.16) (269.60) (287.93) (314.36) (373.50) (383.37) (393.94) (682.10) (695.32) (718.51) (749.64) (784.34) (834.50) GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (649.64) (834.50) ** (2,000.00) Budgeted (1,165.50) Remaining 42 % Used Account: 533-49010-000-000 Interest Income 868 02/28/2019 Bank Interest- February (1,784.47) (1,307.22) (3,091.69) GL Account: 533-49010-000-000 Interest Income Totals: (1,307.22) (3,091.69) ** (2,000.00) Budgeted 1,091.69 Remaining 155 % Used Account: 533-49015-000-000 Lease/Rental Income 832 02/28/2019 Fire Rent Transfer 2019 (215,979.00) (215,979.00) GL Account: 533-49015-000-000 Lease/Rental Income Totals: (215,979.00) (215,979.00) ** (215,979.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 828 02/28/2019 TexPool Transfers February TexPool O&M to I&S- PID Debt (43,655.60) (10,913.90) (54,569.50) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,913.90) (54,569.50) ** Department Totals: (120,053.00) Budgeted (282,038.32) Monthly Total (65,483.50) Remaining 45 % Used (937,279.18) ** (1,029,007.00) Budgeted (91,727.82) Remaining 91 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 IRS Consolidated Department: 51 Administration Program: Period Ending: 2/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 796 02/22/2019 3/1/19 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 200.00 200.00 GL 796 02/22/2019 3/1/19 Bond Payments INTEREST TCMUD-12 500.00 700.00 GL 796 02/22/2019 3/1/19 Bond Payments INTEREST TCMUD-10 750.00 1,450.00 GL Account: 533-70005-051-000 Paying Agent Fee 1 Totals: 1,450.00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax 796 02/22/2019 3/1/19 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 68,762.50 68,762.50 GL 796 02/22/2019 3/1/19 Bond Payments INTEREST BNY MELLON Unl Tax Series 2010 31,441.25 100,203.75 GL 796 02/22/2019 3/1/19 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2012 16,987.50 117,191.25 GL 796 02/22/2019 3/1/19 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2013 15,837.50 133,028.75 GL Account: 533-70025-051-000 Account: 533-70035-051-000 Account: 533-70035-051-000 Department 51 Totals: Bond Interest Expense -Tax Totals: 266,058.00 Budgeted 133,029.25 Remaining Bond Principal Payment -Tax Bond Principal Payment -Tax Totals: 755,000.00 Budgeted 755,000.00 Remaining 50 % Used 0 % Used 134,478.75 Monthly Total 1,023,208.00 Budgeted 133,028.75 133,028.75 ** .00 .00 .00 .00 ** 134,478.75 ** 888,729.25 Remaining 13 % Used Fund 533 Totals: (802,800.43) (147,559.57) Monthly Total (5,799.00) Budgeted 797,001.43 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET FEBRUARY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 183,691 TOTAL ASSETS 183,691 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 19,562 164,129 183,691 183,691 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 18:02 03/13/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 2/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 1,000.00- 1,000.00- 390.02- 1,230.95- 123.095 230.95 534-49143-000-000 Interfund Transfer In -WW Sales 596,238.00- 596,238.00- 54,203.45- 271,017.25- 45.455 325,220.75 - Subtotal: 597,238.00- 597,238.00- 54,593.47- 272,248.20- 45.585 324,989.80 - Program number: 597,238.00- 597,238.00- 54,593.47- 272,248.20- 45.585 324,989.80 - Department number: Revenues 597,238.00- 597,238.00- 54,593.47- 272,248.20- 45.585 324,989.80 - Revenues Subtotal 597,238.00- 597,238.00- 54,593.47- 272,248.20- 45.585 324,989.80- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 18:02 03/13/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/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 534-70040-051-000 Revenue Bond Interest Expense 215,838.00 215,838.00 534-70045-051-000 Revenue Bond Principal Expense 380,000.00 380,000.00 Subtotal: 596,238.00 596,238.00 200.00 200.00 107,918.75 107,918.75 108,118.75 108,118.75 50.000 200.00 50.000 107,919.25 380,000.00 18.133 488,119.25 Program number: 596,238.00 596,238.00 108,118.75 108,118.75 18.133 488,119.25 Department number: Administration 596,238.00 596,238.00 108,118.75 108,118.75 18.133 488,119.25 Expenditures Subtotal 596,238.00 596,238.00 108,118.75 108,118.75 18.133 488,119.25 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 53,525.28 164,129.45- ############### 163,129.45 glpdatb2 skrolczyk 18:02 03/13/19 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 2/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 50 Check Source Number Department Totals: (596,238.00) Budgeted (54,593.47) Monthly Total (325,220.75) Remaining 45 % Used (597,238.00) Budgeted (272,248.20) ** (324,989.80) Remaining 46 % Used Account: 534-49010-000-000 Interest Income 868 02/28/2019 Bank Interest- February (840.93) (390.02) (1,230.95) GL Account: 534-49010-000-000 Interest Income Totals: (390.02) (1,230.95) ** (1,000.00) Budgeted 230.95 Remaining 123 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 828 02/28/2019 Tex Pool Transfers February Te Pool O&M to Rev Bd WWTP I&S (216,813.80) (54,203.45) (271,017.25) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.45) (271,017.25) ** Department Totals: (596,238.00) Budgeted (54,593.47) Monthly Total (325,220.75) Remaining 45 % Used (597,238.00) Budgeted (272,248.20) ** (324,989.80) Remaining 46 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/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 796 02/22/2019 3/1/19 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 400.00 Budgeted 200.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense 796 02/22/2019 3/1/19 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 215,838.00 Budgeted 107,919.25 Remaining 50 6 Used 200.00 200.00 GL 200.00 200.00 ** 107,918.75 107,918.75 GL 50 % Used 107,918.75 107,918.75 ** Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 380,000.00 Budgeted 380,000.00 Remaining 0 % Used Department 51 Totals: 108,118.75 ** 108,118.75 Monthly Total 596,238.00 Budgeted 488,119.25 Remaining 18 % Used Fund 534 Totals: (164,129.45) 53,525.28 Monthly Total (1,000.00) Budgeted 163,129.45 Remaining QQQQQQQ#99 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET FEBRUARY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 98,016 TOTAL ASSETS 98,016 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 2,584 95,432 98,016 TOTAL LIABILITIES AND FUND BALANCE 98,016 glbase_tbam skrolczyk 18:02 03/13/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 1 535-49010-000-000 1 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 2/2019 Adopted Amended Total Budget Budget Encumb. 600.00- 600.00 - Current Month 177.96 - Program: YTD Total 518.89- % of Remaining Budget Budget 86.482 Page 21 535-49142-000-000 Interfund Tran In -Water Sales 276,901.00- 276,901.00- 25,172.81- 125,864.05- 45.455 151,036.95 - Subtotal: 277,501.00- 277,501.00- 25,350.77- 126,382.94- 45.543 151,118.06 - Program number: 277,501.00- 277,501.00- 25,350.77- 126,382.94- 45.543 151,118.06 - Department number: Revenues 277,501.00- 277,501.00- 25,350.77- 126,382.94- 45.543 151,118.06 - Revenues Subtotal 277,501.00- 277,501.00- 25,350.77- 126,382.94- 45.543 151,118.06- glbase_tbam skrolczyk 18:02 03/13/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 535-70005-051-000 Description Rev Bond Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 2/2019 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month 200.00 Program: YTD Total 200.00 % of Remaining Budget Budget 50.000 200.00 Page 22 1 535-70040-051-000 535-70045-051-000 Revenue Bond Interest Expense Revenue Bond Principal Expense 61,501.00 215,000.00 61,501.00 215,000.00 30,750.50 30,750.50 50.000 30,750.50 215,000.00 Subtotal: 276,901.00 276,901.00 30,950.50 30,950.50 11.177 245,950.50 Program number: 276,901.00 276,901.00 30,950.50 30,950.50 11.177 245,950.50 Department number: Administration 276,901.00 276,901.00 30,950.50 30,950.50 11.177 245,950.50 Expenditures Subtotal 276,901.00 276,901.00 30,950.50 30,950.50 11.177 245,950.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 5,599.73 95,432.44- ############### 94,832.44 ******* End of Report ********* glpdatb2 skrolczyk 18:02 03/13/19 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: 2/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 52 Check Source Number Department Totals: (276,901.00) Budgeted (25,350.77) Monthly Total (151,036.95) Remaining 45 % Used (277,501.00) Budgeted (126,382.94) ** (151,118.06) Remaining 46 % Used Account: 535-49010-000-000 Interest Income 868 02/28/2019 Bank Interest- February (340.93) (177.96) (518.89) GL Account: 535-49010-000-000 Interest Income Totals: (177.96) (518.89) ** (600.00) Budgeted (81.11) Remaining 86 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 828 02/28/2019 TexPool Transfers February TexPool O&M to 16Swift Rev I&S (100,691.24) (25,172.81) (125,864.05) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.81) (125,864.05) ** Department Totals: (276,901.00) Budgeted (25,350.77) Monthly Total (151,036.95) Remaining 45 % Used (277,501.00) Budgeted (126,382.94) ** (151,118.06) Remaining 46 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 18:02 03/13/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 2/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 796 02/22/2019 3/1/19 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: 400.00 Budgeted 200.00 Remaining Account: 535-70040-051-000 Revenue Bond Interest Expense 796 02/22/2019 3/1/19 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 61,501.00 Budgeted 30,750.50 Remaining 50 % Used 200.00 200.00 GL 200.00 200.00 ** 30,750.50 30,750.50 GL 50 % Used 30,750.50 30,750.50 ** Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** Department 51 Totals: Fund 535 Totals: Grand Totals: 215,000.00 Budgeted 215,000.00 Remaining 0 % Used 30,950.50 ** 30,950.50 Monthly Total 276,901.00 Budgeted 245,950.50 Remaining 11 % Used 5,599.73 Monthly Total (95,432.44) (600.00) Budgeted 94,832.44 Remaining 8888888888 185,611.16 Monthly Total ******* End of Report ********* (1,155,026.45) **** (534,616.00) Budgeted 620,410.45 Remaining 216 % Used