Loading...
HomeMy WebLinkAbout2019-03 Combined Financials March 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MARCH 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 56,204 856,471 8,947 41,505 TOTAL ASSETS 963,128 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 41,505 TOTAL LIABILITIES 41,505 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 377,739 TOTAL FUND BALANCE 921,623 TOTAL LIABILITIES AND FUND BALANCE 963,128 glbase_tbam skrolczyk 15:36 04/16/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: 3/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 11,967.15- 125.50 812.63- 1,087,073.13- 1,807.76- 3,374.22- 97.321 29,926.87- 1,807.76 3,374.22 Subtotal: 1,117,000.00- 1,117,000.00- 12,654.28- 1,092,255.11- 97.785 24,744.89- 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- 12,654.28- 1,092,255.11- 91.632 99,744.89 - Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 12,654.28- 1,092,255.11- 91.632 99,744.89 - Revenues Subtotal 1,192,000.00- 1,192,000.00- 12,654.28- 1,092,255.11- 91.632 99,744.89- glbase_tbam skrolczyk 15:36 04/16/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: 3/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 1,491.21 215,979.00 8,947.26 281,021.32 100.000 49.707 41.667 9,052.74 393,430.68 Page 2 Subtotal: 908,431.00 908,431.00 1,491.21 505,947.58 55.695 402,483.42 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 1,491.21 714,516.18 59.943 477,483.82 Department number: Fire 1,192,000.00 1,192,000.00 1,491.21 714,516.18 59.943 477,483.82 Expenditures Subtotal 1,192,000.00 1,192,000.00 1,491.21 714,516.18 59.943 477,483.82 Fund number: 122 Trophy Club MUD Fire Dept. 11,163.07- 377,738.93- 377,738.93 glpdatb2 skrolczyk 15:36 04/16/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 Period Ending: 3/2019 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Page 1 Check Source Number Account: 122-40010-000-000 Property Taxes/MUD Fire 1062 03/01/2019 Property Taxes 1063 03/04/2019 Property Taxes 1095 03/05/2019 Property Taxes 1072 03/06/2019 Property Taxes 1073 03/07/2019 Property Taxes 1074 03/08/2019 Property Taxes 1075 03/11/2019 Property Taxes 1076 03/12/2019 Property Taxes 1077 03/13/2019 Property Taxes 1078 03/14/2019 Property Taxes 1079 03/15/2019 Property Taxes 1080 03/18/2019 Property Taxes 1081 03/19/2019 Property Taxes 1082 03/20/2019 Property Taxes 1083 03/21/2019 Property Taxes 1084 03/22/2019 Property Taxes 1085 03/25/2019 Property Taxes 1087 03/26/2019 Property Taxes 1088 03/27/2019 Property Taxes 1089 03/28/2019 Property Taxes 1090 03/29/2019 Property Taxes (1,075,105.98) (907.76) (1,076,013.74) (54.30) (1,076,068.04) (224.61) (1,076,292.65) (1,523.28) (1,077,815.93) (537.65) (1,078,353.58) (28.34) (1,078,381.92) (625.49) (1,079,007.41) (782.08) (1,079,789.49) (101.55) (1,079,891.04) (278.74) (1,080,169.78) 605.09 (1,079,564.69) (602.95) (1,080,167.64) (2,628.19) (1,082,795.83) (392.45) (1,083,188.28) (335.94) (1,083,524.22) (379.53) (1,083,903.75) (585.77) (1,084,489.52) (463.24) (1,084,952.76) (788.66) (1,085,741.42) (465.60) (1,086,207.02) (866.11) (1,087,073.13) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (11,967.15) (1,087,073.13) ** (1,117,000.00) Budgeted (29,926.87) Remaining 97 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1073 03/07/2019 Property Taxes 1079 03/15/2019 Property Taxes 1080 03/18/2019 Property Taxes 1088 03/27/2019 Property Taxes (1,933.26) .40 (1,932.86) 446.55 (1,486.31) (.40) (1,486.71) (321.05) (1,807.76) GL GL GL GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 125.50 (1,807.76) ** .00 Budgeted 1,807.76 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 1 1062 03/01/2019 Property Taxes 1063 03/04/2019 Property Taxes 1095 03/05/2019 Property Taxes 1072 03/06/2019 Property Taxes 1073 03/07/2019 Property Taxes (2,561.59) (63.54) (13.59) (20.91) (107.28) (39.01) (2,625.13) (2,638.72) (2,659.63) (2,766.91) (2,805.92) GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1074 03/08/2019 Property Taxes 1075 03/11/2019 Property Taxes 1076 03/12/2019 Property Taxes 1077 03/13/2019 Property Taxes 1078 03/14/2019 Property Taxes 1079 03/15/2019 Property Taxes 1080 03/18/2019 Property Taxes 1081 03/19/2019 Property Taxes 1082 03/20/2019 Property Taxes 1084 03/22/2019 Property Taxes 1085 03/25/2019 Property Taxes 1087 03/26/2019 Property Taxes 1088 03/27/2019 Property Taxes 1090 03/29/2019 Property Taxes Account: 122-40020-000-000 Property Taxes/Fire P6I Totals: .00 Budgeted 3,374.22 Remaining Account: 122-49035-000-000 Prior Year Reserves Account: 122-49035-000-000 Department Totals: Prior Year Reserves Totals: (75,000.00) Budgeted (12,654.28) Monthly Total (2,561.59) (.57) (2,806.49) GL (50.20) (2,856.69) GL (60.94) (2,917.63) GL (1.39) (2,919.02) GL (26.10) (2,945.12) GL (10.20) (2,955.32) GL (.13) (2,955.45) GL (216.72) (3,172.17) GL (1.27) (3,173.44) GL (4.79) (3,178.23) GL (24.85) (3,203.08) GL (20.60) (3,223.68) GL (108.79) (3,332.47) GL (41.75) (3,374.22) GL 0 % Used (75,000.00) Remaining 0 6 Used (812.63) .00 (3,374.22) ** .00 .00 .00 ** (1,092,255.11) ** (1,192,000.00) Budgeted (99,744.89) Remaining 92 % Used glpdatb2 skrolczyk 15:36 04/16/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: 3/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 3 Check Source Number Department 45 Totals: 127,149.00 Budgeted 1,491.21 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 714,516.18 ** 477,483.82 Remaining 60 % Used Account: 122-60030-045-000 Rent And/Or Usage 215,979.00 215,979.00 .00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 215,979.00 ** 215,979.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 130 03/01/2019 Insurance/Wrk Comp Expense Mar 7,456.05 1,491.21 8,947.26 GL Account: 122-60055-045-000 Insurance Totals: 1,491.21 8,947.26 ** 18,000.00 Budgeted 9,052.74 Remaining 50 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 281,021.32 .00 281,021.32 Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: ' .00 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 1,491.21 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 714,516.18 ** 477,483.82 Remaining 60 % Used glpdatb2 skrolczyk 15:36 04/16/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Fund 122 Totals: Trophy Club MUD No.1 Page 4 Detailed Accounting Trial Balance Department: 45 Fire Program: Period Ending: 3/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment (11,163.07) Monthly Total .00 Budgeted (377,738.93) 377,738.93 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET MARCH 2019 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 1,280,774 1,280,774 CASH IN BANK -SAVINGS -CASH RESERVE 1,188,472 1,188,472 INVESTMENTS-TEXPOOL 3,341,306 782,846 4,124,152 PREPAID EXPENSES 54,774 54,774 ADVALOREM PROPERTY TAXES RECEIVABLE 4,614 4,614 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,169,430 2,169,430 TOTAL ASSETS 8,039,971 782,846 8,822,817 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,614 4,614 ACCOUNTS AND OTHER PAYABLES 490,420 490,420 CUSTOMER DEPOSITS 315,300 315,300 TOTAL LIABILITIES 810,334 810,334 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 (394,548) (394,548) TOTAL FUND BALANCE 7,229,637 782,846 8,012,483 TOTAL LIABILITIES AND FUND BALANCE 8,039,971 782,846 8,822,817 glbase_tbam skrolczyk 15:36 04/16/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: 3/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 1,362.52- 14.39 92.59- 1,440.72 - Program: YTD Total 123,770.12- 221.54- 392.47- 124,384.13- 330,179.33- 1,801,298.10- 291,678.68- 1,565,558.12- 7,886.58- 50,543.65- 1,275.00- 8,425.00- 200.00- 750.00- 600.00- 2,250.00- 4.80- 22.40- 631,824.39- 3,428,847.27- 12,373.46- 1,178.81- 583.33- 1,372.00- 1,249.61- 16,757.21- 63,781.16- 7,399.53- 3,499.98- 52,600.00- 5,488.00- 9,627.76- 2.00- 142,398.43- 650,022.32- 3,695,629.83- 650,022.32- 3,695,629.83- 650,022.32- 3,695,629.83- % of Budget 93.493 73.847 130.823 40.786 27.295 45.875 37.051 49.559 50.000 50.000 .037 Remaining Budget 8,613.88- 78.46- 92.47 171,983.00- 180,582.87- 4,798,185.90- 1,847,106.88- 85,874.35- 8,575.00- 750.00- 2,250.00- 59,977.60- 33.512 6,802,719.73- 318.906 52.308 50.000 526.000 29.630 137.539 185.734 43,781.16 6,746.47- 3,500.02- 42,600.00 13,034.00- 2,627.76 2.00 65,730.43 34.821 6,917,572.17- 34.821 6,917,572.17- 34.821 6,917,572.17 - Page 3 glbase_tbam skrolczyk 15:36 04/16/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: 3/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,827.14 137,047.14 41.942 1,459.69 5,312.77 26.564 3,620.00 100.000 175.00 1,100.00 22.917 2,262.71 14,656.21 44.007 4,219.68 21,505.44 28.744 261.55 1,425.60 33.023 42.47 235.17 33.548 209.67 1,297.78 41.449 1,452.78 8,900.16 40.417 339.77 2,081.49 40.417 57.97 767.78 71.091 930.94 5,315.04 41.218 Remaining Budget 189,707.86 14,687.23 3,700.00 18,647.79 53,312.56 2,891.40 465.83 1,833.22 13,120.84 3,068.51 312.22 7,579.96 200.00 300.00 Page 4 Subtotal: 513,092.00 513,092.00 34,239.37 203,264.58 39.616 309,827.42 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 58,301.54 90,107.54 90.108 1,906.30 63.543 648.75 1,642.80 32.856 522.70 3,170.20 48.772 20,000.00 9,892.46 1,093.70 3,357.20 3,500.00 5,214.00 3,329.80 Subtotal: 143,214.00 143,214.00 59,472.99 96,826.84 67.610 46,387.16 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,881.14 37.623 7,964.24 49,977.64 32.410 61.00 12.200 996.00 21.415 12,124.23 20.904 98,995.56 590,339.29 19.590 336.00 11.200 750.00 2,840.00 19.254 25,172.81 151,036.86 25.809 4,600.00 27,600.00 50.006 3,118.86 104,226.36 1,000.00 439.00 3,655.00 400.00 2,345.00 1,500.00 45,875.77 2,423,154.71 200.00 2,664.00 11,910.00 434,172.14 27,593.00 200,000.00 glbase_tbam skrolczyk 15:36 04/16/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 Description Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program 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 Trophy Club MUD No.1 Page 5 Budget Summary with Amendment 10 Water Period Ending: 3/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 Current Month 137,768.40 927.06 1,659.00 Program: YTD Total 837,192.16 4,708.27 1,417.41 11,336.68 17,861.60 31,482.00 % of Budget 20.410 31.388 27.310 56.683 25.517 36.186 Subtotal: 199,390.00 199,390.00 2,586.06 66,805.96 33.505 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtotal: 135-70040-010-000 Subtotal: Program number: Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Bond Related Expenses 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 68,736.65 68,736.65 7,080.00 7,080.00 309,883.47 429,046.77 30,068.00 2,283.93 75,000.00 99,877.11 636,275.81 7,080.00 7,080.00 1,847,445.35 94.712 100.000 55.381 100.000 83.231 93.269 32.757 Remaining Budget 2,500.00 3,264,753.84 10,291.73 3,772.59 8,663.32 1,200.00 1,000.00 52,138.40 55,518.00 132,584.04 23,953.23 1,840.07 20,122.89 45,916.19 7,080.00- 7,080.00- 3,792,388.65 glbase_tbam skrolczyk 15:36 04/16/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: 3/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 207.70 207.70 207.70 310,091.17 815.40 40.770 815.40 40.770 815.40 1,848,260.75 40.770 32.760 1,184.60 1,184.60 1,184.60 3,793,573.25 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 15:36 04/16/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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,596.82 157,491.76 37.347 264,207.24 135-50010-020-000 Overtime 30,000.00 30,000.00 2,517.01 16,191.92 53.973 13,808.08 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 700.00 4,300.00 49.425 4,400.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,757.79 18,668.85 43.139 24,607.15 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,588.48 32,706.42 35.695 58,920.58 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 340.56 2,137.35 41.876 2,966.65 135-50028-020-000 Vision Insurance 826.00 826.00 55.64 343.62 41.600 482.38 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 384.94 1,836.19 40.850 2,658.81 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 1,741.66 10,787.09 37.189 18,218.91 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 407.32 2,522.79 37.187 4,261.21 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 24.90 972.00 77.143 288.00 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 6,884.58 40.639 10,056.42 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,320.85 262,325.57 39.278 405,537.43 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 2,030.00 2,921.00 19.473 12,079.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 13,853.54 86,808.52 98.646 1,191.48 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 250.00 4,550.82 45.508 5,449.18 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 818.87 1,119.39 13.992 6,880.61 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 123.12 6,803.00 453.533 5,303.00- 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,945.90 38,705.66 51.608 36,294.34 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 3,731.89 23,731.34 67.804 11,268.66 Subtotal: 267,714.00 267,714.00 27,753.32 164,639.73 61.498 103,074.27 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 418.98 2,345.99 46.920 2,654.01 135-60020-020-000 Electricity 174,165.00 174,165.00 12,128.94 76,406.15 43.870 97,758.85 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 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 19.85 174.96 9.233 1,720.04 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 1,236.17 1,884.01 16.241 9,715.99 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 10,913.90 65,483.40 54.545 54,569.60 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 15:36 04/16/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 325,220.70 62,592.00 47.248 49.999 363,109.30 62,595.00 200,000.00 3,500.00 Subtotal: 1,381,335.00 1,381,335.00 89,353.29 551,910.30 39.955 829,424.70 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 632.00 13,000.46 6,195.85 2,059.90 16,301.24 54.95 1,095.69 3,349.83 49.567 37.487 54.337 4.579 91.308 16.749 6,304.15 3,435.10 13,698.76 1,145.05 104.31 16,650.17 Subtotal: 70,395.00 70,395.00 13,632.46 29,057.46 41.278 41,337.54 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 41,222.68 485,751.87 39,858.59 3,027.55 30,000.00 147.198 36.282 20.296 100.000 155,751.87- 69,999.41 11,889.45 Subtotal: 484,775.00 484,775.00 41,222.68 558,638.01 115.237 73,863.01- 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 214,282.60 1,568,071.07 54.597 1,304,010.93 Department number: Wastewater 2,872,082.00 2,872,082.00 214,282.60 1,568,071.07 54.597 1,304,010.93 glbase_tbam skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 3/2019 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 2.12 Program: YTD Total 12.72 % of Remaining Budget Budget 42.400 17.28 Page 9 Subtotal: 30.00 30.00 2.12 12.72 42.400 17.28 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem 150.00 750.00 1,300.00 4,000.00 5,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 10.98 355.00 650.00 34.38 920.00 338.57 86.667 2.645 23.000 6.771 150.00 100.00 1,265.62 3,080.00 4,661.43 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 365.98 1,942.95 14.719 11,257.05 Program number: 13,230.00 13,230.00 368.10 1,955.67 14.782 11,274.33 Department number: Board of Directors 13,230.00 13,230.00 368.10 1,955.67 14.782 11,274.33 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 15:36 04/16/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 28,282.76 36.95 2,619.58 5,123.40 289.84 45.48 281.26 1,651.75 386.28 69.72 106.55 64.94 170,645.69 47.40 1,832.50 17,318.82 27,207.96 1,587.44 258.03 1,748.60 10,227.29 2,391.86 910.73 599.70 103.95 3,018.51 38.695 2.370 99.973 42.089 33.223 36.995 36.809 38.901 37.082 37.083 72.280 46.309 20.790 60.370 270,360.31 1,952.60 .50 23,829.18 54,687.04 2,703.56 442.97 2,746.40 17,352.71 4,058.14 349.27 695.30 396.05 1,981.49 Subtotal: 619,454.00 619,454.00 38,958.51 237,898.48 38.405 381,555.52 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 1,446.17 11,416.35 200.00 927.52 869.06 2,500.00 591.39 40,815.12 69,593.51 4,540.00 927.52 4,345.30 61,705.00 3,495.78 52.429 39.768 22.700 9.275 43.453 93.415 38.842 37,033.88 105,406.49 15,460.00 9,072.48 5,654.70 4,350.00 5,504.22 Subtotal: 367,904.00 367,904.00 17,950.49 185,422.23 50.400 182,481.77 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 29.74 237.55 1,576.99 53.86 1,627.93 4,922.17 6,302.73 24.00 7,575.39 1,425.12 3,067.10 333.15 9,977.41 33,607.91 32.236 35.628 35.295 16.658 33.258 60.489 37,816.38 58.179 4,109.25 68.488 135.00 8.70 1.508 .200 144.00 11.180 15,924.61 2,574.88 5,622.90 1,666.85 20,022.59 21,952.09 1,500.00 27,183.62 1,000.00 1,890.75 400.00 6,000.00 8,815.00 4,336.30 200.00 25,000.00 1,144.00 glbase_tbam skrolczyk 15:36 04/16/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: 3/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 14,774.97 98,323.90 37.324 165,109.10 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 576.44 137.83 3,025.81 4,928.95 2,110.77 42.834 82.149 52.769 2,050.00 4,038.19 1,071.05 3,500.00 1,889.23 2,500.00 Subtotal: 25,114.00 25,114.00 714.27 10,065.53 40.079 15,048.47 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 40,281.00 40,774.00 14.562 239,226.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 236.00 1,643.77 41.094 2,356.23 Subtotal: 284,000.00 284,000.00 40,517.00 42,417.77 14.936 241,582.23 Program number: 1,559,905.00 1,559,905.00 112,915.24 574,127.91 36.805 985,777.09 Department number: Administration 1,559,905.00 1,559,905.00 112,915.24 574,127.91 36.805 985,777.09 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 15:36 04/16/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/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 8,167.09 2,111.10 60,815.51 26,459.53 6,834.32 3,653.00 44.391 85.908 58.343 76.104 76,184.49 4,340.47 4,879.68 1,147.00 Subtotal: 184,314.00 184,314.00 10,278.19 97,762.36 53.041 86,551.64 Program number: 184,314.00 184,314.00 10,278.19 97,762.36 53.041 86,551.64 Department number: Non Departmental 184,314.00 184,314.00 10,278.19 97,762.36 53.041 86,551.64 Expenditures Subtotal 10,271,365.00 10,271,365.00 647,935.30 4,090,177.76 39.821 6,181,187.24 Fund number: 135 MUD 1 General Fund 341,837.00- 341,837.00- 2,087.02- 394,547.93 -115.420 736,384.93- glbase_tbam skrolczyk 15:36 04/16/19 Fund: 137 MUD 1 Consolidated GASB Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 3/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 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2019 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Page 5 Check Source Number Account: 135-40000-000-000 Property Taxes 1062 03/01/2019 Property Taxes 1063 03/04/2019 Property Taxes 1095 03/05/2019 Property Taxes 1072 03/06/2019 Property Taxes 1073 03/07/2019 Property Taxes 1074 03/08/2019 Property Taxes 1075 03/11/2019 Property Taxes 1076 03/12/2019 Property Taxes 1077 03/13/2019 Property Taxes 1078 03/14/2019 Property Taxes 1079 03/15/2019 Property Taxes 1080 03/18/2019 Property Taxes 1081 03/19/2019 Property Taxes 1082 03/20/2019 Property Taxes 1083 03/21/2019 Property Taxes 1084 03/22/2019 Property Taxes 1085 03/25/2019 Property Taxes 1087 03/26/2019 Property Taxes 1088 03/27/2019 Property Taxes 1089 03/28/2019 Property Taxes 1090 03/29/2019 Property Taxes (122,407.60) (103.36) (6.18) (25.57) (173.43) (61.22) (3.23) (71.21) (89.04) (11.56) (31.74) 68.89 (68.64) (299.24) (44.68) (38.25) (43.22) (66.69) (52.74) (89.79) (53.01) (98.61) (122,510.96) (122,517.14) (122,542.71) (122,716.14) (122,777.36) (122,780.59) (122,851.80) (122,940.84) (122,952.40) (122,984.14) (122,915.25) (122,983.89) (123,283.13) (123,327.81) (123,366.06) (123,409.28) (123,475.97) (123,528.71) (123,618.50) (123,671.51) (123,770.12) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (1,362.52) (123,770.12) ** (132,384.00) Budgeted (8,613.88) Remaining 93 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1073 03/07/2019 Property Taxes 1079 03/15/2019 Property Taxes 1080 03/18/2019 Property Taxes 1088 03/27/2019 Property Taxes (235.93) .05 (235.88) 51.22 (184.66) (.05) (184.71) (36.83) (221.54) Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (300.00) Budgeted (78.46) Remaining 74 % Used GL GL GL GL (221.54) ** Account: 135-40015-000-000 Property Taxes/P & I 1062 03/01/2019 Property Taxes 1063 03/04/2019 Property Taxes 1095 03/05/2019 Property Taxes 1072 03/06/2019 Property Taxes 1073 03/07/2019 Property Taxes (299.88) (7.23) (1.55) (2.38) (12.22) (4.44) (307.11) (308.66) (311.04) (323.26) (327.70) GL GL GL GL GL glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1074 03/08/2019 Property Taxes 1075 03/11/2019 Property Taxes 1076 03/12/2019 Property Taxes 1077 03/13/2019 Property Taxes 1078 03/14/2019 Property Taxes 1079 03/15/2019 Property Taxes 1080 03/18/2019 Property Taxes 1081 03/19/2019 Property Taxes 1082 03/20/2019 Property Taxes 1084 03/22/2019 Property Taxes 1085 03/25/2019 Property Taxes 1087 03/26/2019 Property Taxes 1088 03/27/2019 Property Taxes 1090 03/29/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 3/2019 JE Detail Description/Comment Page 6 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (299.88) (.06) (327.76) GL (5.72) (333.48) GL (6.94) (340.42) GL (.16) (340.58) GL (2.97) (343.55) GL (1.16) (344.71) GL (.02) (344.73) GL (24.67) (369.40) GL (.15) (369.55) GL (.54) (370.09) GL (2.83) (372.92) GL (2.35) (375.27) GL (12.45) (387.72) GL (4.75) (392.47) GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (92.59) (392.47) ** (300.00) Budgeted 92.47 Remaining 131 % 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 1024 03/19/2019 water adj UB20190319-20190319 User: 978 03/21/2019 UB 03/21/2019 credit adjustmen UB20190321-20190321 User: 995 03/26/2019 Ub 03/26/2019 credit adjustmen UB20190326-20190326 User: 1025 03/31/2019 UB 03/31/2019 Billing UB20190331-20190331 User: (1,471,118.77) 54.38 (1,471,064.39) UB 23.05 (1,471,041.34) UB 345.88 (1,470,695.46) UB (330,602.64) (1,801,298.10) UB Account: 135-47000-000-000 Water Totals: (330,179.33) (1,801,298.10) ** (6,599,484.00) Budgeted (4,798,185.90) Remaining 27 % Used Account: 135-47005-000-000 Sewer 1025 03/31/2019 UB 03/31/2019 Billing UB20190331-20190331 User: (1,273,879.44) (291,678.68) (1,565,558.12) UB Account: 135-47005-000-000 Sewer Totals: (291,678.68) (1,565,558.12) ** (3,412,665.00) Budgeted (1,847,106.88) Remaining 46 % Used Account: 135-47025-000-000 Penalties glpdatb2 skrolczyk 15:36 04/16/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: 3/2019 JE Detail Description/Comment 976 03/21/2019 UB 03/21/2019 penalty removal UB20190321-20190321 User: 977 03/21/2019 UB 03/21/2019 Penalties 0320190321-20190321 User: 1001 03/27/2019 Ub 03/27/2019 Penalty removal U320190327-20190327 User: 1005 03/28/2019 UB 03/28/2009 Penalty removal UB20190328-20190328 User: 1009 03/28/2019 UB 03/28/2019 Penalty Removal UB20190328-20190328 User: 1016 03/29/2019 UB 03/29/2019 Penalty removal UB20190329-20190329 User: Page 7 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (42,657.07) 13.37 (8,197.57) 225.45 10.41 11.76 50.00 (42,643.70) (50,841.27) (50,615.82) (50,605.41) (50,593.65) (50,543.65) UB UB UB UB UB UB Account: 135-47025-000-000 Penalties M Totals: (7,886.58) (50,543.65) ** Account: 135-47045-000-000 Sewer Inspections Totals: (136,418.00) Budgeted (85,874.35) Remaining 37 % Used ** (4,500.00) Budgeted (2,250.00) Remaining Account: 135-47030-000-000 Service Charges Account: 135-47070-000-000 TCCC Effluent Charges 878 03/01/2019 UB 03/01/2019 NSF Check UB20190301-20190301 User: 907 03/07/2019 UB 03/07/2019 Disconnect Fees U820190307-20190307 User: (7,150.00) (25.00) (1,250.00) (7,175.00) (8,425.00) (17.60) UB UB Account: 135-47030-000-000 Service Charges Totals: UB Account: (1,275.00) (8,425.00) ** (22.40) ** (17,000.00) Budgeted (8,575.00) Remaining 50 % Used 0 % Used Account: 135-47035-000-000 Plumbing Inspections 1042 03/08/2019 Permits 1042 03/08/2019 Permits 1043 03/14/2019 Permits 1043 03/14/2019 Permits 517 Asheville Lane 410 Abbot Lane 5 Sadie Court 21 Katie Lane (550.00) (50.00) (50.00) (50.00) (50.00) (600.00) Ashton Woods Homes (650.00) Ashton Woods Homes (700.00) Drees Homes (750.00) Drees Homes CR CR CR CR Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (750.00) ** (1,500.00) Budgeted (750.00) Remaining 50 % Used Account: 135-47045-000-000 Sewer Inspections 1042 03/08/2019 Permits 1042 03/08/2019 Permits 1043 03/14/2019 Permits 1043 03/14/2019 Permits 517 Asheville Lane 410 Abbot Lane 5 Sadie Court 21 Katie Lane (1,650.00) (150.00) (150.00) (150.00) (150.00) (1,800.00) Ashton Woods Homes (1,950.00) Ashton Woods Homes (2,100.00) Drees Homes (2,250.00) Drees Homes CR CR CR CR Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (2,250.00) ** (4,500.00) Budgeted (2,250.00) Remaining 50 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1025 03/31/2019 UB 03/31/2019 Billing UB20190331-20190331 User: (17.60) (4.80) (22.40) UB Account: 135-47070-000-000 TCCC Effluent Charges Totals: (4.80) (22.40) ** (60,000.00) Budgeted (59,977.60) Remaining 0 % Used glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 8 Check Source Number 1042 03/08/2019 Permits 1042 03/08/2019 Permits 1043 03/14/2019 Permits 1043 03/14/2019 Permits 517 Asheville Lane 410 Abbot Lane 5 Sadie Court 21 Katie Lane (4,116.00) (343.00) (343.00) (343.00) (343.00) (4,459.00) Ashton Woods Homes (4,802.00) Ashton Woods Homes (5,145.00) Drees Homes (5,488.00) Drees Homes CR CR CR CR Account: 135-49075-000-000 Oversize Meter Reimbursement Totals (1,372.00) (5,488.00) (18,522.00) Budgeted (13,034.00) Remaining 30 % Used Account: 135-49900-000-000 Miscellaneous Income 1042 03/08/2019 Permits 517 ASheville Lane (8,378.15) 1023 03/15/2019 Camera line fee UB20190315-20190315 User: (800.00) (9,178.15) Ashton Woods Homes (150.00) (9,328.15) UB Account: 135-49010-000-000 Interest Income 1097 03/31/2019 Bank Interest- March (51,407.70) 1097 03/31/2019 Bank Interest- March 1097 03/31/2019 Bank Interest- March (633.09) (1,260.40) (10,479.97) (52,040.79) (53,301.19) (63,781.16) GL GL GL Account: 135-49010-000-000 Interest Income Totals: (12,373.46) (63,781.16) ** (20,000.00) Budgeted 43,781.16 Remaining 319 % Used Account: 135-49016-000-000 Cell Tower Revenue 1101 03/05/2019 Cell Tower Rev AT&T March (6,220.72) (1,178.81) (7,399.53) GL Account: 135-49016-000-000 Cell Tower Revenue Totals: i (1,178.81) (7,399.53) ** (14,146.00) Budgeted (6,746.47) Remaining 52 % Used Account: 135-49018-000-000 Building Rent Income 1110 03/31/2019 Town Billed Invoices 1680-1683 AR 20190331-20190331 User: (2,916.65) (583.33) (3,499.98) AR Account: 135-49018-000-000 Building Rent Income 1 Totals: (583.33) (3,499.98) ** (7,000.00) Budgeted (3,500.02) Remaining 50 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (52,600.00) .00 (52,600.00) Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (52,600.00) ** (10,000.00) Budgeted 42,600.00 Remaining 526 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1042 03/08/2019 Permits 1042 03/08/2019 Permits 1043 03/14/2019 Permits 1043 03/14/2019 Permits 517 Asheville Lane 410 Abbot Lane 5 Sadie Court 21 Katie Lane (4,116.00) (343.00) (343.00) (343.00) (343.00) (4,459.00) Ashton Woods Homes (4,802.00) Ashton Woods Homes (5,145.00) Drees Homes (5,488.00) Drees Homes CR CR CR CR Account: 135-49075-000-000 Oversize Meter Reimbursement Totals (1,372.00) (5,488.00) (18,522.00) Budgeted (13,034.00) Remaining 30 % Used Account: 135-49900-000-000 Miscellaneous Income 1042 03/08/2019 Permits 517 ASheville Lane (8,378.15) 1023 03/15/2019 Camera line fee UB20190315-20190315 User: (800.00) (9,178.15) Ashton Woods Homes (150.00) (9,328.15) UB glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 9 Check Source Number Department Totals: (650,022.32) Monthly Total (3,695,629.83) ** (10,613,202.00) Budgeted (6,917,572.17) Remaining 35 % Used 1025 03/31/2019 UB 03/31/2019 Billing UB20190331-20190331 User: (8,378.15) (299.61) (9,627.76) UB Account: 135-49900-000-000 Miscellaneous Income Totals: (1,249.61) (9,627.76) ** (7,000.00) Budgeted 2,627.76 Remaining 138 % Used Account: 135-49901-000-000 Records Management Revenue (2.00) .00 (2.00) Account: 135-49901-000-000 Records Management Revenue Totals: .00 (2.00) ** .00 Budgeted 2.00 Remaining 0 % Used Department Totals: (650,022.32) Monthly Total (3,695,629.83) ** (10,613,202.00) Budgeted (6,917,572.17) Remaining 35 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 875 03/08/2019 MUD Payroll 03/08/2019 Salaries & Wages 961 03/22/2019 MUD Payroll 03/22/2019 Salaries & Wages Account: 135-50005-010-000 114,220.00 11,413.57 125,633.57 PR 11,413.57 137,047.14 PR Salaries & Wages Totals: 22,827.14 137,047.14 ** 326,755.00 Budgeted Account: 135-50010-010-000 Overtime 875 03/08/2019 MUD Payroll 03/08/2019 Overtime 961 03/22/2019 MUD Payroll 03/22/2019 Overtime 189,707.86 Remaining 42 9 Used 3,853.08 625.00 4,478.08 PR 834.69 5,312.77 PR Account: 135-50010-010-000 Overtime Totals: 1,459.69 5,312.77 ** 20,000.00 Budgeted 14,687.23 Remaining 27 % Used Account: 135-50016-010-000 Longevity 3,620.00 .00 3,620.00 Account: 135-50016-010-000 Longevity Totals: .00 3,620.00 ** 3,620.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 - Certification 961 03/22/2019 MUD Payroll 03/22/2019 Certification 925.00 175.00 1,100.00 PR Account: 135-50017-010-000 Certification Totals: 175.00 1,100.00 ** 4,800.00 Budgeted Account: 135-50020-010-000 Retirement 875 03/08/2019 MUD Payroll 03/08/2019 Retirement 961 03/22/2019 MUD Payroll 03/22/2019 Retirement 3,700.00 Remaining 23 9 Used 12,393.50 1,113.56 13,507.06 1,149.15 14,656.21 PR PR Account: 135-50020-010-000 Retirement Totals: 2,262.71 14,656.21 ** 33,304.00 Budgeted Account: 135-50026-010-000 Medical Insurance 875 03/08/2019 MUD Payroll 03/08/2019 Medical Insurance 961 03/22/2019 MUD Payroll 03/22/2019 Medical Insurance Account: 135-50026-010-000 18,647.79 Remaining 44 8 Used 17,285.76 2,109.86 19,395.62 2,109.82 21,505.44 Medical Insurance Totals: 4,219.68 21,505.44 ** 74,818.00 Budgeted 53,312.56 Remaining 29 8 Used PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 1 Dental Insurance 875 03/08/2019 MUD Payroll 03/08/2019 Dental Insurance 961 03/22/2019 MUD Payroll 03/22/2019 Dental Insurance Account: 135-50027-010-000 ' Dental Insurance Totals: 4,317.00 Budgeted Account: 135-50028-010-000 Vision Insurance 875 03/08/2019 MUD Payroll 03/08/2019 Vision Insurance 961 03/22/2019 MUD Payroll 03/22/2019 Vision Insurance 1,164.05 130.80 1,294.85 PR 130.75 1,425.60 PR 2,891.40 Remaining 33 % Used 5 1,425.60 ** 1 192.70 21.25 213.95 PR 21.22 235.17 PR Account: 135-50028-010-000 Vision Insurance Totals: 42.47 235.17 ** Account: 135-50029-010-000 820 03/01/2019 March A/P 824 03/01/2019 March A/P 1017 03/29/2019 March A/P 701.00 Budgeted Life Insurance & Other Employee Benefits Employee LTD & STD Caf 125 465.83 Remaining 34 % Used 1,088.11 98.56 1,186.67 Humana Inc 91.11 1,277.78 METLIFE GROUP BENEFITS 20.00 1,297.78 BenefitMall 5043 AP 5054 AP 5128 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 209.67 1,297.78 ** 3,131.00 Budgeted 1,833.22 Remaining 41 % Used Account: 135-50030-010-000 Social Security Taxes 875 03/08/2019 MUD Payroll 03/08/2019 Social Security Taxes 961 03/22/2019 MUD Payroll 03/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 875 03/08/2019 MUD Payroll 03/08/2019 Medicare Taxes 961 03/22/2019 MUD Payroll 03/22/2019 Medicare Taxes 7,447.38 13,120.84 Remaining 40 % Used 1,741.72 716.51 736.27 1,452.78 8,163.89 8,900.16 8,900.16 ** 167.57 1,909.29 172.20 2,081.49 PR PR PR PR Account: 135-50035-010-000 Medicare TaxesTotals: 339.77 2,081.49 ** 5,150.00 Budgeted Account: 135-50040-010-000 _ Unemployment Taxes 875 03/08/2019 MUD Payroll 03/08/2019 Unemployment Taxes 3,068.51 Remaining 40 % Used 709.81 57.97 767.78 PR glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-50040-010-000 JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 3/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes 1,080.00 Budgeted Account: 135-50045-010-000 Workman's Compensation 130 03/01/2019 Insurance/Wrk Comp Expense Mar Account: 135-50045-010-000 Account: 135-50060-010-000 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 993 03/26/2019 1053 03/26/2019 1053 03/26/2019 1053 03/26/2019 1053 03/26/2019 1010 03/28/2019 1010 03/28/2019 1032 03/31/2019 1058 03/31/2019 March A/P-Zepeda PCards 2/27/2019 PCards 2/27/2019 PCards 2/27/2019 PCards 2/27/2019 March A/P March A/P March A/P March A/P Workman's Compensation 12,895.00 Budgeted Pre-emp Physicals/Testing Totals: 312.22 Remaining Totals: 7,579.96 Remaining Pre-emp Physicals/Testing Totals: 200.00 Budgeted 200.00 Remaining Employee Relations Employee Relations 300.00 Budgeted Engineering Engineering 20,000.00 Budgeted Maintenance & Repairs Settlement - 3/26/2019 - 3/26/2019 - 3/26/2019 - 3/26/2019 Totals: 300.00 Remaining Totals: 20,000.00 Remaining Settlement payment-Zepeda 1040 silicone, putty, umberella adapter adapters and couplings maint & repairs Couplings, pipe Parts tank refill parts 4,384.10 Program: Transaction Detail 71 % Used 41 6 Used O % Used O 6 Used O % Used 57.97 930.94 930.94 .00 .00 .00 .00 .00 .00 Transaction Vendor_Name Detail (SUBTOTAL) 767.78 ** 5,315.04 5,315.04 ** .00 .00 ** .00 .00 ** .00 .00 ** Page 12 Check Source Number GL 31,806.00 53,000.00 84,806.00 Guillermo & Patricia Zepeda 5125 AP 15.02 84,821.02 THE HOME DEPOT #6581 PC 20.62 84,841.64 THE HOME DEPOT #6581 PC 131.12 84,972.76 THE HOME DEPOT #6581 PC 23.80 84,996.56 TEX-TURF PC 1,275.30 86,271.86 Core & Main LP 5130 AP 281.25 86,553.11 Core & Main LP 5130 AP 30.00 86,583.11 ALLIED WELDING SUPPLY, INC 5175 AP 3,373.95 89,957.06 Core & Main LP 5186 AP glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1058 03/31/2019 March A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 3/2019 JE Detail Beginning Balance Description/Comment Parts 31,806.00 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 150.48 90,107.54 Core & Main LP Page 13 Check Source Number 5186 AP 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 veh registration fee vehicle registration rims labor tire tires 994.05 4.00 998.05 TX.GOV SERVICEFEE- 30.25 1,028.30 DENTON VEHREG 54.00 1,082.30 DISCOUNT TIRE TXD 75 40.00 1,122.30 INLAND TRUCK PARTS # 95.50 1,217.80 DISCOUNT TIRE TXD 75 425.00 1,642.80 DISCOUNT TIRE TXD 75 PC PC PC PC PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 648.75 Account: 135-55080-010-000 Maintenance & Repairs Totals: 58,301.54 90,107.54 ** 33 100,000.00 Budgeted 9,892.46 Remaining 90 5 Used Account: 135-55085-010-000 Generator Maint. and Repair Maintenance-Backhoe/SkidLoader 1,906.30 .00 1,906.30 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 .00 1,906.30 ** Account: 135-55105-010-000 3,000.00 Budgeted 1,093.70 Remaining 64 % Used .00 Account: 135-55090-010-000 Vehicle Maintenance 3,500.00 Budgeted 3,500.00 Remaining 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 veh registration fee vehicle registration rims labor tire tires 994.05 4.00 998.05 TX.GOV SERVICEFEE- 30.25 1,028.30 DENTON VEHREG 54.00 1,082.30 DISCOUNT TIRE TXD 75 40.00 1,122.30 INLAND TRUCK PARTS # 95.50 1,217.80 DISCOUNT TIRE TXD 75 425.00 1,642.80 DISCOUNT TIRE TXD 75 PC PC PC PC PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 648.75 1,642.80 ** 5,000.00 Budgeted 3,357.20 Remaining 33 % 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 935 03/13/2019 March A/P water samples 2,647.50 60.00 2,707.50 CITY OF FORT WORTH 5090 AP 935 03/13/2019 March A/P 1114 03/31/2019 March A/P TCEQ samples water samples 207.70 2,915.20 LOWER COLORADO RIVER AUTHORITY 5105 AP 255.00 3,170.20 TARRANT CTY PUBLIC HEALTH LAB 5204 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-000 Account: 135-60010-010-000 935 03/13/2019 March A/P Account: 135-60010-010-000 Lab Analysis Totals: 6,500.00 Budgeted Communications/Mobiles Cell phones -March 3,329.80 Remaining 49 % Used 522.70 3,170.20 ** 1,595.35 285.79 1,881.14 VERIZON WIRELESS 5121 AP Communications/Mobiles Totals: 285.79 1,881.14 ** 5,000.00 Budgeted 3,118.86 Remaining 38 8 Used Account: 135-60020-010-000 Electricity 1010 03/28/2019 March A/P Electricity 2/8-3/11 Account: 135-60020-010-000 Account: 135-60066-010-000 42,013.40 7,964.24 49,977.64 HUDSON ENERGY SERVICES, LLC 5139 AP Electricity Totals: 7,964.24 49,977.64 ** 154,204.00 Budgeted 104,226.36 Remaining 32 % Used Publications/Books/Subscripts Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining Account: 135-60070-010-000 Dues & Memberships Account: 135-60070-010-000 Dues & Memberships Totals: 500.00 Budgeted 439.00 Remaining 12 % Used Account: 135-60080-010-000 Schools & Training Account: 135-60080-010-000 Schools & Training Totals: 4,651.00 Budgeted 3,655.00 Remaining 21 % Used Account: 135-60090-010-000 Safety Program .00 .00 .00 .00 ** 0 8 Used 61.00 .00 996.00 61.00 .00 61.00 ** .00 996.00 .00 996.00 ** .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-60090-010-000 Safety Program Totals: 400.00 Budgeted Account: 135-60100-010-000 Travel & per diem Account: 135-60100-010-000 400.00 Remaining 0 % Used Travel & per diem Totals: 2,345.00 Budgeted Account: 135-60105-010-000 Rent/Lease Equipment Account: 135-60105-010-000 2,345.00 Remaining 0 % Used Rent/Lease Equipment Totals: 1,500.00 Budgeted Account: 135-60135-010-000 TCEQ Fees & Permits Account: 135-60135-010-000 1,500.00 Remaining 0 o Used 12,124.23 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 12,124.23 TCEQ Fees & Permits Totals: .00 12,124.23 ** 58,000.00 Budgeted Account: 135-60150-010-000 Wholesale Water 1010 03/28/2019 March A/P Wholesale water Account: 135-60150-010-000 Account: 135-60245-010-000 Account: 135-60245-010-000 Account: 135-60280-010-000 45,875.77 Remaining 21 % Used Wholesale Water Totals: 491,343.73 98,995.56 3,013,494.00 Budgeted 2,423,154.71 Remaining 20 % Used Miscellaneous Expenses Miscellaneous Expenses Totals: 200.00 Budgeted Property Maintenance 200.00 Remaining 336.00 0 % Used 590,339.29 CITY OF FORT WORTH 5129 AP 98,995.56 590,339.29 ** .00 .00 .00 .00 ** .00 336.00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-60280-010-000 Property Maintenance Totals: 3,000.00 Budgeted .00 336.00 ** 2,664.00 Remaining 11 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1045 03/31/2019 march A?P March mowing 2,090.00 Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 11,910.00 Remaining Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 1100 03/31/2019 TexPool Transfers March TexPool O&M to 16Swift Rev I&S 125,864.05 Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 585,209.00 Budgeted 434,172.14 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve 1100 03/31/2019 TexPool Transfers March TexPool O&M to Rev Bond Resevr Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted 27,593.00 Remaining 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 Account: 135-60360-010-000 Furniture/Equipment < $5000 750.00 2,840.00 WATTS ELLISON LLC 5183 AP 750.00 19 6 Used 2,840.00 ** 25,172.81 151,036.86 GL 25,172.81 151,036.86 ** 26 % Used 23,000.00 4,600.00 27,600.00 GL 50 % Used 0 6 Used 4,600.00 .00 27,600.00 ** .00 .00 .00 ** .00 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 Account: 135-65005-010-000 991 03/24/2019 Fuel 2,500.00 Budgeted 2,500.00 Remaining 0 % Used .00 .00 ** Fuel & Lube Fuel 3,781.21 927.06 4,708.27 US Bank Voyager Fleet Systems 5159 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-65005-010-000 Fuel & Lube Totals: 927.06 4,708.27 ** 15,000.00 Budgeted 10,291.73 Remaining 31 % Used Account: 135-65010-010-000 Uniforms 1,417.41 .00 1,417.41 Account: 135-65010-010-000 Uniforms Totals: .00 1,417.41 ** 5,190.00 Budgeted Account: 135-65030-010-000 Chemicals 935 03/13/2019 March A/P testing supplies 1017 03/29/2019 March A/P chlorine 3,772.59 Remaining 27 % Used 9,677.68 988.91 10,666.59 BACH COMPANY 5101 AP 670.09 11,336.68 DPC INDUSTRIES, INC 5134 AP Account: 135-65030-010-000 Chemicals Totals: 1,659.00 11,336.68 ** 20,000.00 Budgeted 8,663.32 Remaining 57 % Used Account: 135-65035-010-000 Small Tools Account: 135-65035-010-000 Small Tools 1,200.00 Budgeted Account: 135-65040-010-000 Safety Equipment Account: 135-65040-010-000 Safety Equipment 1,000.00 Budgeted Account: 135-65050-010-000 Meter Expense .00 .00 Totals: 1,200.00 Remaining 0 8 Used .00 .00 ** .00 .00 Totals: 1,000.00 Remaining 0 9 Used .00 .00 ** 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 8 Used Account: 135-65053-010-000 Meter Change Out Program 31,482.00 .00 31,482.00 glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 3/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 18 Check Source Number Account: 135-65053-010-000 Meter Change Out Program Totals: .00 31,482.00 ** 87,000.00 Budgeted 55,518.00 Remaining 36 % Used Account: 135-69005-010-000 Capital Outlays 935 03/13/2019 1053 03/26/2019 1053 03/26/2019 1053 03/26/2019 1010 03/28/2019 1010 03/28/2019 1010 03/28/2019 1010 03/28/2019 1127 03/31/2019 March A/P PCards 2/27/2019 PCards 2/27/2019 PCards 2/27/2019 March A/P March A/P March A/P March A/P March A?P - 3/26/2019 - 3/26/2019 - 3/26/2019 decals for camera vac fee for notice of bond notice of bond notice of bond water line replacement water line replacement 16" water line phase II 16" water line Phase I Phase II -16 in water line 360,310.12 125.00 1.00 76.60 1,874.19 4,000.00 2,250.00 15,708.32 40,882.00 3,819.54 360,435.12 360,436.12 360,512.72 362,386.91 366,386.91 368,636.91 384,345.23 425,227.23 429,046.77 M-KAM LTD. DENTON COUNTY, TX SOUT DENTON RECORDCHRONICLE STAR TELEGRAM ADVERTIS TEAGUE, NALL & PERKINS,INC TEAGUE, NALL & PERKINS,INC Halff Associates, INC La Banda, LLC Halff Associates, INC 5106 AP PC PC PC 5158 AP 5158 AP 5137 AP 5146 AP 5208 AP Account: 135-69005-010-000 Capital Outlays Totals: 68,736.65 429,046.77 ** 453,000.00 Budgeted 23,953.23 Remaining 95 % Used Account: 135-69008-010-000 Short Term Debt -Principal 30,068.00 .00 30,068.00 Account: 135-69008-010-000 Short Term Debt -Principal Totals: .00 30,068.00 ** 30,068.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt -Interest 2,283.93 .00 2,283.93 Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 2,283.93 ** 4,124.00 Budgeted 1,840.07 Remaining 55 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 99,877.11 .00 99,877.11 glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 3/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 19 Check Source Number Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 99,877.11 ** 120,000.00 Budgeted 20,122.89 Remaining 83 % Used Account: 135-70040-010-000 Bond Related Expenses 939 03/14/2019 955 03/19/2019 956 03/19/2019 March A/P Incorrect amount on March A/P TCMUD 16IN Water check TCMUD 161N Water TCMUD 16in water & WWTP Overru & WWTP Overru & WWTP Overru 7,200.00 (7,200.00) 7,080.00 7,200.00 .00 7,080.00 ATTORNEY GENERAL/STATE OF TX ATTORNEY GENERAL/STATE OF TX ATTORNEY GENERAL/STATE OF TX 5086 5086 5124 AP AP AP Account: 135-70040-010-000 Bond Related Expenses Totals: 7,080.00 7,080.00 ** .00 Budgeted (7,080.00) Remaining 0 % Used glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 20 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 938 03/14/2019 March A/P TCEQ samples 607.70 207.70 815.40 LOWER COLORADO RIVER AUTHORITY 5105 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 207.70 815.40 ** 2,000.00 Budgeted 1,184.60 Remaining 41 % Used Department 10 Totals: 1,848,260.75 ** 310,091.17 Monthly Total 5,641,834.00 Budgeted 3,793,573.25 Remaining 33 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 875 03/08/2019 MUD Payroll 03/08/2019 Salaries & Wages 961 03/22/2019 MUD Payroll 03/22/2019 Salaries & Wages Account: 135-50005-020-000 130,894.94 13,213.36 144,108.30 PR 13,383.46 157,491.76 PR Salaries & Wages Totals: 26,596.82 157,491.76 ** 421,699.00 Budgeted Account: 135-50010-020-000 Overtime 875 03/08/2019 MUD Payroll 03/08/2019 Overtime 961 03/22/2019 MUD Payroll 03/22/2019 Overtime 264,207.24 Remaining 37 % Used 13,674.91 823.89 14,498.80 PR 1,693.12 16,191.92 PR Account: 135-50010-020-000 Overtime Totals: 2,517.01 16,191.92 ** 30,000.00 Budgeted 13,808.08 Remaining 54 % Used Account: 135-50016-020-000 Longevity 7,445.00 .00 7,445.00 Account: 135-50016-020-000 Longevity Totals: .00 7,445.00 ** 7,445.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 - Certification 961 03/22/2019 MUD Payroll 03/22/2019 Certification 3,600.00 700.00 4,300.00 PR Account: 135-50017-020-000 Certification Totals: 700.00 4,300.00 ** 8,700.00 Budgeted Account: 135-50020-020-000 Retirement 875 03/08/2019 MUD Payroll 03/08/2019 Retirement 961 03/22/2019 MUD Payroll 03/22/2019 Retirement 4,400.00 Remaining 49 % Used 15,911.06 1,298.47 17,209.53 1,459.32 18,668.85 PR PR Account: 135-50020-020-000 Retirement Totals: 2,757.79 18,668.85 ** 43,276.00 Budgeted Account: 135-50026-020-000 Medical Insurance 875 03/08/2019 MUD Payroll 03/08/2019 Medical Insurance 961 03/22/2019 MUD Payroll 03/22/2019 Medical Insurance Account: 135-50026-020-000 24,607.15 Remaining 43 % Used 27,117.94 2,794.26 29,912.20 2,794.22 32,706.42 Medical Insurance Totals: 5,588.48 32,706.42 ** 91,627.00 Budgeted 58,920.58 Remaining 36 % Used PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 1 Dental Insurance 875 03/08/2019 MUD Payroll 03/08/2019 Dental Insurance 961 03/22/2019 MUD Payroll 03/22/2019 Dental Insurance Account: 135-50027-020-000 1,796.79 170.29 1,967.08 PR 170.27 2,137.35 PR ' Dental Insurance Totals: 340.56 2,137.35 ** 5,104.00 Budgeted Account: 135-50028-020-000 Vision Insurance 875 03/08/2019 MUD Payroll 03/08/2019 Vision Insurance 961 03/22/2019 MUD Payroll 03/22/2019 Vision Insurance 2,966.65 Remaining 42 % Used 1 287.98 27.83 315.81 PR 27.81 343.62 PR Account: 135-50028-020-000 Vision Insurance Totals: 55.64 343.62 ** Account: 135-50029-020-000 820 03/01/2019 March A/P 824 03/01/2019 March A/P 1017 03/29/2019 March A/P 826.00 Budgeted Life Insurance & Other Employee Benefits Employee LTD & STD Caf 125 482.38 Remaining 42 % Used 1,451.25 184.80 1,636.05 Humana Inc 162.14 1,798.19 METLIFE GROUP BENEFITS 38.00 1,836.19 BenefitMall 5043 AP 5054 AP 5128 AP Account: 135-50029-020-000 Life Insurance & Other Totals: 384.94 1,836.19 ** 4,495.00 Budgeted 2,658.81 Remaining 41 % Used Account: 135-50030-020-000 Social Security Taxes 875 03/08/2019 MUD Payroll 03/08/2019 Social Security Taxes 961 03/22/2019 MUD Payroll 03/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 875 03/08/2019 MUD Payroll 03/08/2019 Medicare Taxes 961 03/22/2019 MUD Payroll 03/22/2019 Medicare Taxes 9,045.43 18,218.91 Remaining 37 9 Used 2,115.47 830.17 911.49 1,741.66 9,875.60 10,787.09 10,787.09 ** 194.14 2,309.61 213.18 2,522.79 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 407.32 2,522.79 ** 6,784.00 Budgeted Account: 135-50040-020-000 _ Unemployment Taxes 875 03/08/2019 MUD Payroll 03/08/2019 Unemployment Taxes 4,261.21 Remaining 37 % Used 947.10 24.90 972.00 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes Totals: 1,260.00 Budgeted 288.00 Remaining 77 % Used 24.90 972.00 ** Account: 135-50045-020-000 Workman's Compensation 130 03/01/2019 Insurance/Wrk Comp Expense Mar 5,678.85 1,205.73 Account: 135-50045-020-000 Workman's Compensation Totals: 16,941.00 Budgeted 10,056.42 Remaining 41 % Used 1,205.73 Account: 135-50060-020-000 Pre-emp Physicals/Testing 38.00 .00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 400.00 Budgeted 362.00 Remaining 10 % Used Account: 135-50070-020-000 Employee Relations .00 Account: 135-50070-020-000 Employee Relations Totals: .00 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 Account: 135-55005-020-000 Engineering Totals: 30,000.00 Budgeted 30,000.00 Remaining 0 % Used 6,884.58 6,884.58 ** 38.00 38.00 ** .00 .00 ** .00 .00 .00 ** Account: 135-55070-020-000 Independent Labor 938 03/14/2019 March A/P Sound/Noise testing WWTP 891.00 2,030.00 Account: 135-55070-020-000 - Independent Labor Totals: 2,030.00 15,000.00 Budgeted 12,079.00 Remaining 19 % Used GL 2,921.00 SRP ENVIRONMENTAL LLC 5113 AP 2,921.00 ** Account: 135-55080-020-000 Maintenance & Repairs 916 03/08/2019 March A/P Dumpsters 72,954.98 3,733.64 76,688.62 Global Equipment Company 5099 AP 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 prem aw 32 hyd fl 5g 51.99 76,740.61 ROANOKE AUTO SUPPLY LT PC glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1053 03/26/2019 PCards 2/27/2019 1053 03/26/2019 PCards 2/27/2019 1053 03/26/2019 PCards 2/27/2019 1053 03/26/2019 PCards 2/27/2019 1053 03/26/2019 PCards 2/27/2019 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P Account: 135-55080-020-000 Account: 135-55085-020-000 938 03/14/2019 March A/P Account: 135-55085-020-000 Account: 135-55090-020-000 1053 03/26/2019 PCards 1053 03/26/2019 1053 03/26/2019 1053 03/26/2019 1053 03/26/2019 1053 03/26/2019 Account: 135-55090-020-000 PCards PCards PCards PCards PCards - 3/26/2019 - 3/26/2019 - 3/26/2019 - 3/26/2019 - 3/26/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 3/2019 JE Detail Beginning Balance Description/Comment wrench, ext tube,broom, etc nozzle, strainer,coupling, etc v -belt, flashlight fed sfty red ga, spray handle, funnel, prem aw 46 hyd fl 5g pump for LS #9 is #9 repair pressure transmitter for TMP Maintenance & Repairs Totals: 88,000.00 Budgeted 1,191.48 Remaining Generator Maint. and Repair grease Generator Maint. and Repair Totals: 10,000.00 Budgeted 5,449.18 Remaining Vehicle Maintenance 2/27/2019 - 3/26/2019 lamp 2/27/2019 - 3/26/2019 camera van 2/27/2019 - 3/26/2019 pvc, fitting 2/27/2019 - 3/26/2019 car ash 2/27/2019 - 3/26/2019 oil change 2/27/2019 - 3/26/2019 oil change Account: 135-55105-020-000 1017 03/29/2019 March A/P Account: 135-55105-020-000 Account: 135-55120-020-000 Account: 135-55120-020-000 Vehicle Maintenance Totals: 8,000.00 Budgeted 6,880.61 Remaining Maintenance-Backhoe/SkidLoader glow plug Maintenance-Backhoe/SkidLoader Totals: 1,500.00 Budgeted (5,303.00) Remaining Cleaning Services Cleaning Services 5,214.00 Budgeted 72,954.98 4,300.82 300.52 6,679.88 Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 75.42 76,816.03 95.19 76,911.22 84.98 76,996.20 121.09 77,117.29 83.98 77,201.27 8,181.25 85,382.52 490.00 85,872.52 936.00 86,808.52 99 % Used 46 % Used 14 % Used 454 % Used Totals: 5,214.00 Remaining 0 % Used 13,853.54 250.00 250.00 425.68 7.50 227.46 12.00 69.67 76.56 818.87 123.12 123.12 .00 .00 THE HOME DEPOT #6581 THE HOME DEPOT 6581 ROANOKE AUTO SUPPLY LT THE HOME DEPOT #6581 ROANOKE AUTO SUPPLY LT DHS AUTOMATION, INC DHS AUTOMATION, INC ENDRESS + HAUSER, INC 86,808.52 ** 4,550.82 NORTH TEXAS PUMP CO. 4,550.82 ** 726.20 733.70 961.16 973.16 1,042.83 1,119.39 LESLIES POOL SPLY 574 DENTON COUNTY, TX SOUT THE HOME DEPOT 6581 CARMEL CARWASH - ROANO KWIK KAR LUBE & TUNE 0 KWIK KAR LUBE & TUNE 0 1,119.39 ** ' 6,803.00 HOLT CAT 6,803.00 ** .00 .00 ** Page 24 Check Source Number PC PC PC PC PC 5132 AP 5132 AP 5135 AP 5108 AP PC PC PC PC PC PC 5138 AP glpdatb2 skrolczyk 15:36 04/16/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: 3/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 25 Check Source Number 913 03/08/2019 March A?P 938 03/14/2019 March A/P 938 03/14/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P lab testing WW sampling WW sampling effluent testing effluent teting effluent testing effluent testing lab supplies 230.00 317.40 230.00 317.40 230.00 317.40 230.00 1,542.29 20,546.85 OXIDOR LABORATORIES LLC 20,864.25 OXIDOR LABORATORIES LLC 21,094.25 OXIDOR LABORATORIES LLC 21,411.65 OXIDOR LABORATORIES LLC 21,641.65 OXIDOR LABORATORIES LLC 21,959.05 OXIDOR LABORATORIES LLC 22,189.05 OXIDOR LABORATORIES LLC 23,731.34 IDEXX DISTRIBUTION, INC 5111 AP 5111 AP 5111 AP 5153 AP 5153 AP 5153 AP 5153 AP 5140 AP Account: 135-55135-020-000 Lab Analysis Totals: 3,731.89 23,731.34 ** ' Account: 135-55125-020-000 Dumpster Services 68 o Used Account: 135-60010-020-000 Communications/Mobiles 1010 03/28/2019 March A/P 1032 03/31/2019 March A/P 1114 03/31/2019 March A/P sludge haul off sludge haul off sludge haul off 31,759.76 2,672.31 1,690.00 2,583.59 34,432.07 36,122.07 38,705.66 L.H. CHANEY MATERIALS, L.H. CHANEY MATERIALS, L.H. CHANEY MATERIALS, INC. INC. INC. 5145 5178 5199 AP AP AP Account: 135-55125-020-000 Dumpster Services Totals: 2,345.99 VERIZON WIRELESS 6,945.90 38,705.66 ** 135-60010-020-000 Communications/Mobiles Totals: 75,000.00 Budgeted 36,294.34 Remaining 52 % Used 5,000.00 Budgeted 2,654.01 Remaining 47 Account: 135-55135-020-000 Lab Analysis Account: 135-60020-020-000 Electricity 913 03/08/2019 March A?P Labe testing 19,999.45 317.40 20,316.85 OXIDOR LABORATORIES LLC 5111 AP 913 03/08/2019 March A?P 938 03/14/2019 March A/P 938 03/14/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P lab testing WW sampling WW sampling effluent testing effluent teting effluent testing effluent testing lab supplies 230.00 317.40 230.00 317.40 230.00 317.40 230.00 1,542.29 20,546.85 OXIDOR LABORATORIES LLC 20,864.25 OXIDOR LABORATORIES LLC 21,094.25 OXIDOR LABORATORIES LLC 21,411.65 OXIDOR LABORATORIES LLC 21,641.65 OXIDOR LABORATORIES LLC 21,959.05 OXIDOR LABORATORIES LLC 22,189.05 OXIDOR LABORATORIES LLC 23,731.34 IDEXX DISTRIBUTION, INC 5111 AP 5111 AP 5111 AP 5153 AP 5153 AP 5153 AP 5153 AP 5140 AP Account: 135-55135-020-000 Lab Analysis Totals: 3,731.89 23,731.34 ** ' 35,000.00 Budgeted 11,268.66 Remaining 68 o Used Account: 135-60010-020-000 Communications/Mobiles 935 03/13/2019 March A/P Cell phones -March 1,927.01 418.98 2,345.99 VERIZON WIRELESS 5121 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 418.98 2,345.99 ** 5,000.00 Budgeted 2,654.01 Remaining 47 % Used Account: 135-60020-020-000 Electricity 935 03/13/2019 March A/P 935 03/13/2019 March A/P 935 03/13/2019 March A/P 1010 03/28/2019 March A/P Electricity 1/28-2/26 Electricity 1/28-2/26 Electricity 1/28-2/26 Electricity 2/8-3/11 1110 03/31/2019 Town Billed Invoices 1680-1683 AR 20190331-20190331 User: 64,277.21 173.12 254.10 27.81 12,166.61 (492.70) 64,450.33 TRI COUNTY ELECTRIC 64,704.43 TRI COUNTY ELECTRIC 64,732.24 TRI COUNTY ELECTRIC 76,898.85 HUDSON ENERGY SERVICES, LLC 76,406.15 5119 AP 5119 AP 5119 AP 5139 AP AR Account: 135-60020-020-000 ' Electricity Totals: 12,128.94 76,406.15 ** 174,165.00 Budgeted 97,758.85 Remaining 44 % Used Account: 135-60066-020-000 Publications/Books/Subscripts glpdatb2 skrolczyk 15:36 04/16/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: 3/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Page 26 Check Source Number Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 69.00 .00 69.00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 69.00 ** 300.00 Budgeted 231.00 Remaining 23 % Used Account: 135-60080-020-000 Schools & Training 862.95 .00 862.95 Account: 135-60080-020-000 Schools & Training ' Totals: .00 862.95 ** 7,155.00 Budgeted 6,292.05 Remaining 12 % Used Account: 135-60090-020-000 Safety Program 100.74 .00 100.74 Account: 135-60090-020-000 Safety Program Totals: .00 100.74 ** 1,000.00 Budgeted 899.26 Remaining 10 % Used Account: 135-60100-020-000 Travel & per diem 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P tolls to lab tolls to lab 155.11 16.24 3.61 171.35 174.96 Texas Tollways/TxTag Texas Tollways/TxTag 5157 5157 AP AP Account: 135-60100-020-000 Travel & per diem Totals: 19.85 174.96 ** 1,895.00 Budgeted 1,720.04 Remaining 9 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising glpdatb2 skrolczyk 15:36 04/16/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: 3/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Page 27 Check Source Number Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 16,545.22 .00 16,545.22 Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 16,545.22 ** 30,000.00 Budgeted 13,454.78 Remaining 55 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 Account: 135-60245-020-000 ' Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 225.18 .00 225.18 Account: 135-60280-020-000 Property Maintenance Totals: .00 225.18 ** 5,000.00 Budgeted 4,774.82 Remaining 5 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 lawn mower repairs 1045 03/31/2019 march A?P March mowing 647.84 646.17 590.00 1,294.01 1,884.01 PIONEER OUT DOOR POWER WATTS ELLISON LLC 5183 PC AP Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,236.17 1,884.01 ** 11,600.00 Budgeted 9,715.99 Remaining 16 % Used Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1100 03/31/2019 TexPool Transfers March TexPool O&M to I&S- PID Debt 54,569.50 10,913.90 65,483.40 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,913.90 65,483.40 ** 120,053.00 Budgeted 54,569.60 Remaining 55 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1100 03/31/2019 TexPool Transfers March TexPool O&M to Rev Ed WWTP I&S 271,017.25 Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 688,330.00 Budgeted 363,109.30 Remaining Account: 135-60333-020-000 Interfund Transfer Out -Reserve 1100 03/31/2019 TexPool Transfers March TexPool O&M to Rev Bond Resevr Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 125,187.00 Budgeted 62,595.00 Remaining Account: 135-60334-020-000 Interfund Transfer Out Account: 135-60334-020-000 Account: 135-60360-020-000 Account: 135-60360-020-000 Account: 135-65005-020-000 991 03/24/2019 Fuel Account: 135-65005-020-000 Account: 135-65010-020-000 Account: 135-65010-020-000 Interfund Transfer Out Totals: 200,000.00 Budgeted 200,000.00 Remaining Furniture/Equipment < $5000 Furniture/Equipment < $5000 Totals: 3,500.00 Budgeted 3,500.00 Remaining Fuel & Lube Fuel Fuel & Lube Totals: 12,500.00 Budgeted Uniforms Uniforms 5,495.00 Budgeted 6,304.15 Remaining 54,203.45 325,220.70 GL 54,203.45 325,220.70 ** 47 % Used 52,160.00 10,432.00 50 % Used 0 % Used 0 6 Used 62,592.00 GL 10,432.00 62,592.00 ** .00 .00 .00 .00 .00 ** .00 .00 .00 ** 5,563.85 632.00 6,195.85 US Bank Voyager Fleet Systems 5159 AP 2,059.90 50 % Used Totals: 3,435.10 Remaining 37 6 Used 632.00 6,195.85 ** .00 .00 2,059.90 2,059.90 ** Account: 135-65030-020-000 Chemicals 938 03/14/2019 March A/P Chemicals 3,300.78 547.00 3,847.78 Valley Solvent Company, INC 5120 AP glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1010 03/28/2019 March A/P 1017 03/29/2019 March A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 3/2019 JE Detail Beginning Balance Description/Comment power powder power powder chemicals chemicals chemicals Bacteria for wastewater treatm Bacteria for waste water treat chemicals 3,300.78 Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 212.84 4,060.62 3.43 4,064.05 2,856.60 6,920.65 794.00 7,714.65 547.00 8,261.65 2,857.12 11,118.77 2,830.47 13,949.24 2,352.00 16,301.24 LESLIES POOL SPLY 574 ROANOKE AUTO SUPPLY LT POLYDYNE, INC Valley Solvent Company, INC Valley Solvent Company, INC MARYLAND BIOCHEMICAL CO, INC MARYLAND BIOCHEMICAL CO, INC Valley Solvent Company, INC Page 29 Check Source Number PC PC 5154 AP 5160 AP 5160 AP 5149 AP 5149 AP 5160 AP Account: 135-65030-020-000 Chemicals Totals: 13,000.46 16,301.24 ** 1 30,000.00 Budgeted 13,698.76 Remaining 54 % Used Account: 135-65035-020-000 Small Tools 1 54.95 .00 54.95 Account: 135-65035-020-000 Small Tools Totals: .00 54.95 ** 1 1,200.00 Budgeted 1,145.05 Remaining 5 % Used Account: 135-65040-020-000 Safety Equipment 1,095.69 .00 1,095.69 Account: 135-65040-020-000 Safety Equipment Totals: .00 1,095.69 ** 1,200.00 Budgeted 104.31 Remaining 91 % Used Account: 135-65045-020-000 Lab Supplies 3,349.83 .00 3,349.83 Account: 135-65045-020-000 Lab Supplies Totals: .00 3,349.83 ** 20,000.00 Budgeted 16,650.17 Remaining 17 % Used Account: 135-69005-020-000 Capital Outlays 935 03/13/2019 March A/P 1010 03/28/2019 March A/P 1032 03/31/2019 March A/P 1070 03/31/2019 March A/P 1117 03/31/2019 March A/P PD30 sewer line plant water system wwtp Security-WWTP Security WWTP WWTP Improvement 444,529.19 1,021.26 1,810.40 11,772.51 17,842.00 8,776.51 445,550.45 447,360.85 459,133.36 476,975.36 485,751.87 CP6Y/WALLACE GROUP, INC. Star -Telegram Media 3RD EYE SURVEILLANCE SYSTEMS 3RD EYE SURVEILLANCE SYSTEMS CP6Y/WALLACE GROUP, INC. 5093 AP 5155 AP 5174 AP 5189 AP 5192 AP Account: 135-69005-020-000 Capital Outlays Totals: 41,222.68 485,751.87 ** 330,000.00 Budgeted (155,751.87) Remaining 147 o Used glpdatb2 skrolczyk 15:36 04/16/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: 3/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 30 Check Source Number Department 20 Totals: .00 Budgeted 214,282.60 Monthly Total (1,500.00) Remaining 0 % Used 1,568,071.07 ** 2,872,082.00 Budgeted 1,304,010.93 Remaining 55 o 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 214,282.60 Monthly Total (1,500.00) Remaining 0 % Used 1,568,071.07 ** 2,872,082.00 Budgeted 1,304,010.93 Remaining 55 o Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/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 130 03/01/2019 Insurance/Wrk Comp Expense Mar Account: 135-50045-026-000 Account: 135-60066-026-000 Account: 135-60066-026-000 Account: 135-60070-026-000 Account: 135-60070-026-000 Workman's Compensation Totals: 10.60 2.12 12.72 GL 30.00 Budgeted 17.28 Remaining 42 6 Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining Dues & Memberships Immom Dues & Memberships Totals: 750.00 Budgeted Account: 135-60075-026-000 Meetings 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 board meeting snacks 650.00 2.12 12.72 ** .00 0 % Used .00 .00 .00 ** .00 650.00 100.00 Remaining 87 % Used .00 650.00 ** 23.40 10.98 34.38 TOM THUMB #2580 PC Account: 135-60075-026-000 Meetings 11111Totals: 10.98 34.38 ** 1,300.00 Budgeted Account: 135-60080-026-000 Schools & Training 938 03/14/2019 March A/P AWED conference 1,265.62 Remaining 3 % Used 565.00 355.00 920.00 AWED 5087 AP Account: 135-60080-026-000 Schools & Training Totals: 355.00 920.00 ** 4,000.00 Budgeted 3,080.00 Remaining 23 % 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 32 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/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,955.67 ** 368.10 Monthly Total 13,230.00 Budgeted 11,274.33 Remaining 15 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 875 03/08/2019 MUD Payroll 03/08/2019 Salaries & Wages 961 03/22/2019 MUD Payroll 03/22/2019 Salaries & Wages Account: 135-50005-030-000 142,362.93 14,147.21 156,510.14 PR 14,135.55 170,645.69 PR Salaries & Wages Totals: 28,282.76 170,645.69 ** 441,006.00 Budgeted Account: 135-50010-030-000 Overtime 875 03/08/2019 MUD Payroll 03/08/2019 Overtime 961 03/22/2019 MUD Payroll 03/22/2019 Overtime 270,360.31 Remaining 39 % Used 10.45 12.91 23.36 PR 24.04 47.40 PR Account: 135-50010-030-000 Overtime Totals: 36.95 47.40 ** 2,000.00 Budgeted 1,952.60 Remaining 2 % Used Account: 135-50016-030-000 Longevity Account: 135-50016-030-000 Longevity 1,833.00 Budgeted Account: 135-50020-030-000 Retirement 875 03/08/2019 MUD Payroll 03/08/2019 Retirement 961 03/22/2019 MUD Payroll 03/22/2019 Retirement Account: 135-50020-030-000 ' Retirement 41,148.00 Budgeted Account: 135-50026-030-000 Medical Insurance 875 03/08/2019 MUD Payroll 03/08/2019 Medical Insurance 961 03/22/2019 MUD Payroll 03/22/2019 Medical Insurance 1,832.50 .00 1,832.50 Totals: .00 1,832.50 ** .50 Remaining 100 % Used 14,699.24 1,309.82 16,009.06 PR 1,309.76 17,318.82 PR Totals: 23,829.18 Remaining 42 % Used 2,619.58 17,318.82 ** 22,084.56 2,060.03 24,144.59 PR 3,063.37 27,207.96 PR Account: 135-50026-030-000 Medical Insurance Totals: 5,123.40 27,207.96 ** 81,895.00 Budgeted Account: 135-50027-030-000 Dental Insurance 875 03/08/2019 MUD Payroll 03/08/2019 Dental Insurance 961 03/22/2019 MUD Payroll 03/22/2019 Dental Insurance 54,687.04 Remaining 33 6 Used 1,297.60 113.20 1,410.80 PR 176.64 1,587.44 PR glpdatb2 skrolczyk 15:36 04/16/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: 3/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 34 Check Source Number Account: 135-50027-030-000 Dental Insurance Totals: 289.84 1,587.44 ** 4,291.00 Budgeted 2,703.56 Remaining 37 % Used Account: 135-50028-030-000 Vision Insurance 875 03/08/2019 MUD Payroll 961 03/22/2019 MUD Payroll 03/08/2019 Vision Insurance 03/22/2019 Vision Insurance 212.55 17.98 27.50 230.53 258.03 PR PR Account: 135-50028-030-000 Vision Insurance Totals: 45.48 258.03 ** 701.00 Budgeted 442.97 Remaining 37 % Used Account: 135-50029-030-000 Life Insurance & Other 820 03/01/2019 March A/P 824 03/01/2019 March A/P 1017 03/29/2019 March A/P Employee Benefits Employee LTD & STD Caf 125 1,467.34 131.04 130.22 20.00 1,598.38 1,728.60 1,748.60 Humana Inc METLIFE GROUP BENEFITS BenefitMall 5043 5054 5128 AP AP AP Account: 135-50029-030-000 Life Insurance & Other Totals: 281.26 1,748.60 ** 4,495.00 Budgeted 2,746.40 Remaining 39 % Used Account: 135-50030-030-000 Social Security Taxes 875 03/08/2019 MUD Payroll 961 03/22/2019 MUD Payroll 03/08/2019 Social Security Taxes 03/22/2019 Social Security Taxes 8,575.54 837.75 814.00 9,413.29 10,227.29 PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 1,651.75 10,227.29 ** 27,580.00 Budgeted 17,352.71 Remaining 37 % Used Account: 135-50035-030-000 Medicare Taxes 875 03/08/2019 MUD Payroll 961 03/22/2019 MUD Payroll 03/08/2019 Medicare Taxes 03/22/2019 Medicare Taxes 2,005.58 195.92 190.36 2,201.50 2,391.86 PR PR Account: 135-50035-030-000 Medicare Taxes Totals: 386.28 2,391.86 ** 6,450.00 Budgeted 4,058.14 Remaining 37 % Used Account: 135-50040-030-000 Unemployment Taxes 875 03/08/2019 MUD Payroll 03/08/2019 Unemployment Taxes 841.01 69.72 910.73 PR Account: 135-50040-030-000 Unemployment Taxes Totals: 69.72 910.73 ** 1,260.00 Budgeted 349.27 Remaining 72 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-030-000 Workman's Compensation 130 03/01/2019 Insurance/Wrk Comp Expense Mar Account: 135-50045-030-000 Account: 135-50060-030-000 Account: 135-50060-030-000 Workman's Compensation Totals: 1,295.00 Budgeted Pre-emp Physicals/Testing Pre-emp Physicals/Testing Totals: 500.00 Budgeted 396.05 Remaining 493.15 106.55 599.70 GL 695.30 Remaining 46 6 Used Account: 135-50070-030-000 Employee Relations 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 Steven's get well gift 103.95 106.55 .00 21 % Used 599.70 ** 103.95 .00 103.95 ** 2,953.57 64.94 3,018.51 FRUIT BOUQUETS.COM PC Account: 135-50070-030-000 Employee Relations Totals: 64.94 3,018.51 ** 5,000.00 Budgeted 1,981.49 Remaining 60 % Used Account: 135-55030-030-000 Software & Support 913 03/08/2019 March A?P Internet 39,368.95 903.72 40,272.67 Charter Communications 5089 AP 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 adobe subscription 32.45 40,305.12 ADOBE *ACROPRO SUBS PC 1010 03/28/2019 March A/P Microsoft exchange 510.00 40,815.12 M3 Networks 5148 AP Account: 135-55030-030-000 Software & Support Totals: 1,446.17 40,815.12 ** Account: 135-55070-030-000 1045 03/31/2019 march A?P 1045 03/31/2019 march A?P 77,849.00 Budgeted Independent Labor GM March 2019 GM March 2019 37,033.88 Remaining 52 % Used 58,177.16 11,400.00 69,577.16 Carman Consulting LLC. 5176 AP 16.35 69,593.51 Carman Consulting LLC. 5176 AP Account: 135-55070-030-000 Independent Labor Totals: 11,416.35 69,593.51 ** 175,000.00 Budgeted Account: 135-55080-030-000 Maintenance & Repairs 1010 03/28/2019 March A/P pest control 105,406.49 Remaining 40 6 Used 4,340.00 200.00 4,540.00 Exclusive Pest Control 5136 AP Account: 135-55080-030-000 Maintenance & Repairs Totals: 200.00 4,540.00 ** 20,000.00 Budgeted 15,460.00 Remaining 23 o Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-55085-030-000 Generator Maint. and Repair 1114 03/31/2019 March A/P Office generator repair 927.52 Account: 135-55085-030-000 Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,072.48 Remaining Account: 135-55120-030-000 Cleaning Services 1010 03/28/2019 March A/P Janitorial service -February 927.52 HOLT CAT 5195 AP 927.52 927.52 ** 9 % Used 3,476.24 869.06 4,345.30 MEMBER'S BUILDING MAINTENANCE 5150 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 4,345.30 ** 10,000.00 Budgeted 5,654.70 Remaining 43 % Used Account: 135-55160-030-000 Professional Outside Services 1010 03/28/2019 March A/P winter average review Account: 135-55160-030-000 Professional Outside Services Totals: 66,055.00 Budgeted 4,350.00 Remaining Account: 135-55205-030-000 Utility Billing Contract 1114 03/31/2019 March A/P Water billings -March Account: 135-55205-030-000 Utility Billing Contract Totals: 9,000.00 Budgeted 5,504.22 Remaining Account: 135-60005-030-000 Telephone 834 03/01/2019 March A/P Answering svc-March 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 answering service 1110 03/31/2019 Town Billed Invoices 1680-1683 AR 20190331-20190331 User: 59,205.00 2,500.00 61,705.00 NEW GEN STRATEGIES & SOLUTIONS 5152 AP 2,500.00 61,705.00 ** 93 % Used 2,904.39 591.39 39 % Used 3,495.78 DATAPROSE LLC 5193 AP 591.39 3,495.78 ** 7,545.65 194.75 7,740.40 KEYSTONE PARK SECRETARIAL 5048 AP 14.99 7,755.39 RINGCENTRAL, INC PC (180.00) 7,575.39 AR Account: 135-60005-030-000 Telephone Totals: 29.74 7,575.39 ** 23,500.00 Budgeted 15,924.61 Remaining 32 % Used Account: 135-60010-030-000 Communications/Mobiles 935 03/13/2019 March A/P Cell phones -March 961 03/22/2019 MUD Payroll 03/22/2019 Communications/Mobiles 1,187.57 87.55 1,275.12 VERIZON WIRELESS 5121 AP 150.00 1,425.12 PR Account: 135-60010-030-000 Communications/Mobiles Totals: 237.55 1,425.12 ** 4,000.00 Budgeted 2,574.88 Remaining 36 % Used glpdatb2 skrolczyk 15:36 04/16/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: 3/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 37 Check Source Number 877 03/08/2019 Child Support Fee 962 03/22/2019 Child Support fee 1045 03/31/2019 march A?P 1098 03/31/2019 Pace Credit Card Fees 1098 03/31/2019 Pace Credit Card Fees Digtess-march 28,685.74 1.50 28,687.24 GL 1.50 28,688.74 GL 265.05 28,953.79 Texas Excavation Safety System 5180 AP 4,547.36 33,501.15 GL 106.76 33,607.91 GL Account: 135-60040-030-000 Service Charges & Fees Totals: 4,922.17 33,607.91 ** Account: 135-60020-030-000 Electricity/Gas 60 % Used 11111 Account: 135-60050-030-000 Bad Debt Expense 1045 03/31/2019 march A?P Electricity 12/10-1/8, 1/9-2/8 1,490.11 1,576.99 3,067.10 TOWN OF TROPHY CLUB 5181 AP Account: 135-60020-030-000 Electricity/Gas Totals: .00 1,576.99 3,067.10 ** Account: 135-60050-030-000 Bad Debt Expense Totals: 8,690.00 Budgeted 5,622.90 Remaining 35 % Used ** 1,500.00 Budgeted 1,500.00 Remaining 0 Account: 135-60025-030-000 Water Account: 135-60055-030-000 Insurance 1045 03/31/2019 march A?P water -march 1110 03/31/2019 Town Billed Invoices 1680-1683 AR 20190331-20190331 User: 279.29 107.71 (53.85) 387.00 333.15 TROPHY CLUB MUD (WATER BILLS) 5182 AP AR Account: 135-60025-030-000 Water Totals: GL 53.86 333.15 ** 2,000.00 Budgeted 1,666.85 Remaining 17 % Used Account: 135-60035-030-000 Postage 1114 03/31/2019 March A/P Water billings -March 8,349.48 1,627.93 9,977.41 DATAPROSE LLC 5193 AP Account: 135-60035-030-000 Postage Totals: 1,627.93 9,977.41 ** 30,000.00 Budgeted 20,022.59 Remaining 33 % Used Account: 135-60040-030-000 Service Charges & Fees 877 03/08/2019 Child Support Fee 962 03/22/2019 Child Support fee 1045 03/31/2019 march A?P 1098 03/31/2019 Pace Credit Card Fees 1098 03/31/2019 Pace Credit Card Fees Digtess-march 28,685.74 1.50 28,687.24 GL 1.50 28,688.74 GL 265.05 28,953.79 Texas Excavation Safety System 5180 AP 4,547.36 33,501.15 GL 106.76 33,607.91 GL Account: 135-60040-030-000 Service Charges & Fees Totals: 4,922.17 33,607.91 ** 55,560.00 Budgeted 21,952.09 Remaining 60 % 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 5 Used Account: 135-60055-030-000 Insurance 130 03/01/2019 Insurance/Wrk Comp Expense Mar 31,513.65 6,302.73 37,816.38 GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-60055-030-000 Insurance Totals: 6,302.73 37,816.38 ** 65,000.00 Budgeted 27,183.62 Remaining 58 % 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 4,109.25 .00 Account: 135-60070-030-000 Dues & Memberships Totals: .00 6,000.00 Budgeted 1,890.75 Remaining 68 % Used Account: 135-60075-030-000 Meetings .00 4,109.25 4,109.25 ** .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 .00 .00 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 8 Used Account: 135-60100-030-000 Travel & per diem 8.70 .00 8.70 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-030-000 Travel & per diem 4,345.00 Budgeted Account: 135-60110-030-000 Physicals/Testing Account: 135-60110-030-000 Physicals/Testing 200.00 Budgeted Account: 135-60125-030-000 Advertising Totals: 4,336.30 Remaining 0 % Used Totals: 200.00 Remaining 0 % Used .00 8.70 ** .00 .00 .00 .00 ** .00 Account: 135-60125-030-000 Advertising Totals: .00 Account: 135-60235-030-000 1010 03/28/2019 March A/P Account: 135-60235-030-000 25,000.00 Budgeted 25,000.00 Remaining 0 % Used Security monitoring svc-march Security Totals: 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 .00 .00 ** 120.00 24.00 144.00 Digital Air Control, Inc 1,144.00 Remaining 11 % Used 124.49 24.00 144.00 ** .00 124.49 Miscellaneous Expenses Totals: .00 124.49 ** 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency 375.51 Remaining 25 % Used .00 .00 Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining Account: 135-60360-030-000 Furniture/Equipment < $5000 0 % Used .00 .00 5133 AP glpdatb2 skrolczyk 15:36 04/16/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-60360-030-000 Account: 135-65010-030-000 Account: 135-65010-030-000 Account: 135-65055-030-000 Account: 135-65055-030-000 Account: 135-65085-030-000 938 03/14/2019 March A/P 938 03/14/2019 March A/P 1053 03/26/2019 PCards 2/27/2019 1053 03/26/2019 PCards 2/27/2019 1045 03/31/2019 march A?P 1045 03/31/2019 march A?P 1045 03/31/2019 march A?P 1045 03/31/2019 march A?P Account: 135-65085-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 3/2019 JE Detail Beginning Balance Description/Comment Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Uniforms Uniforms 2,050.00 Budgeted Hardware Hardware 7,064.00 Budgeted Totals: 2,050.00 Remaining Totals: 4,038.19 Remaining Office Supplies credit for broken trays office supplies - 3/26/2019 stand up desk - 3/26/2019 battery backup office supplies office supplies office supplies office supplies Office Supplies 6,000.00 Budgeted Totals: 1,071.05 Remaining 3,025.81 4,352.51 Program: Transaction Detail O % Used O % Used 43 % Used 82 % Used .00 .00 .00 .00 .00 (8.94) 71.18 239.99 74.00 72.41 8.09 4.23 115.48 576.44 Transaction Vendor_Name Detail (SUBTOTAL) .00 ** .00 .00 ** 3,025.81 3,025.81 ** 4,343.57 4,414.75 4,654.74 4,728.74 4,801.15 4,809.24 4,813.47 4,928.95 OFFICE DEPOT, INC OFFICE DEPOT, INC AMZN MKTP US*MI7V43YM2 AMAZON.COM*MW2KD54U1 OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC 4,928.95 ** Page 40 Check Source Number 5110 AP 5110 AP PC PC 5179 AP 5179 AP 5179 AP 5179 AP Account: 135-65090-030-000 Printer Supplies & Maintenance Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 3,500.00 Budgeted 3,500.00 Remaining Account: 135-65095-030-000 Maintenance Supplies 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 Disposable gloves 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 tea .00 .00 O % Used .00 .00 ** 1,972.94 10.94 1,983.88 AMZN MKTP US*MW2B68ZG2 14.24 1,998.12 AMAZON.COM*MWSCA6EV0 PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 water,storage bag, truvia, fsw 1053 03/26/2019 PCards 2/27/2019 - 3/26/2019 coffee Account: 135-65095-030-000 . Maintenance Supplies Totals: 4,000.00 Budgeted 1,972.94 41.62 2,039.74 WM SUPERCENTER #5247 71.03 2,110.77 AMZN MKTP US*M16WW6W72 1,889.23 Remaining 53 % Used 137.83 2,110.77 ** PC PC Account: 135-65105-030-000 Printing Account: 135-65105-030-000 Account: 135-69005-030-000 1006 03/28/2019 March A?P 1114 03/31/2019 March A/P Account: 135-69005-030-000 Account: 135-69170-030-000 935 03/13/2019 March A/P 1010 03/28/2019 March A/P Account: 135-69170-030-000 Department 30 Totals: Printing Totals: 2,500.00 Budgeted .00 .00 2,500.00 Remaining 0 % Used Capital Outlays Security project -adjust fence Budgeting software Capital Outlays J Totals: 239,226.00 Remaining 15 % Used 280,000.00 Budgeted .00 .00 ** 493.00 394.00 887.00 3RD EYE SURVEILLANCE SYSTEMS 5126 AP 39,887.00 40,774.00 OpenGov, Inc 5201 AP Copier Lease Installments copier lease copier lease -march Copier Lease Installments Totals: 4,000.00 Budgeted 2,356.23 Remaining 40,281.00 40,774.00 ** 1,407.77 165.00 1,572.77 TIAA COMMERCIAL FINANCE 71.00 1,643.77 KYOCERA DOCUMENT SOLUTIONS 41 % Used 112,915.24 Monthly Total 1,559,905.00 Budgeted 236.00 1,643.77 ** 574,127.91 ** 985,777.09 Remaining 37 % Used 5117 AP 5144 AP glpdatb2 skrolczyk Trophy Club MUD No.1 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 42 Account: 135-55045-039-000 Legal 1102 03/05/2019 Wilbow- Legal Solana Fire Hydr Reimburs Solana Legal Fire Hyd 935 03/13/2019 March A/P 935 03/13/2019 March A/P 938 03/14/2019 March A/P 1114 03/31/2019 March A/P 1114 03/31/2019 March A/P 1114 03/31/2019 March A/P legal Legal Legal -Westlake easement Legal legal Legal 52,648.42 (2,500.00) 4,350.00 1,050.00 1,650.50 2,529.98 1,050.00 36.61 50,148.42 54,498.42 McLean & Howard, L.L.P. 55,548.42 McLean & Howard, L.L.P. 57,198.92 WHITAKER CHALK SWINDLE 59,728.90 McLean & Howard, L.L.P. 60,778.90 McLean 9 Howard, L.L.P. 60,815.51 McLean & Howard, L.L.P. GL 5107 AP 5107 AP 5123 AP 5200 AP 5200 AP 5200 AP Account: 135-55045-039-000 Legal Totals: 8,167.09 60,815.51 ** 137,000.00 Budgeted 76,184.49 Remaining 44 % Used Account: 135-55055-039-000 Auditing 26,459.53 .00 26,459.53 Account: 135-55055-039-000 Auditing Totals: .00 26,459.53 ** 30,800.00 Budgeted 4,340.47 Remaining 86 % Used Account: 135-55060-039-000 Appraisal 935 03/13/2019 March A/P 2nd quarter allocation 4,723.22 2,111.10 6,834.32 DENTON CENTRAL APPRAISAL DISTR 5095 AP Account: 135-55060-039-000 Appraisal Totals: 2,111.10 6,834.32 ** 11,714.00 Budgeted 4,879.68 Remaining 58 % Used Account: 135-55065-039-000 Tax Admin Fees 3,653.00 .00 3,653.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,653.00 ** Department 39 Totals: Fund 135 Totals: 4,800.00 Budgeted 10,278.19 Monthly Total 1,147.00 Remaining 76 % Used 184,314.00 Budgeted 97,762.36 ** 86,551.64 Remaining 53 % Used 394,547.93 (2,087.02) Monthly Total (341,837.00) Budgeted (736,384.93) Remaining NNNNNNN(NN glpdatb2 skrolczyk 15:36 04/16/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: 3/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 MARCH 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,674,771 1,674,771 (1,479,465) (195,306) (1,674,771) glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 15:36 04/16/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/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 15:36 04/16/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 3/2019 Adopted Amended Total Budget Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 15 517-69005-020-000 Capital Outlays 50,393.24 195,313.32 195,313.32 - Subtotal: 50,393.24 195,313.32 195,313.32 - Program number: 50,393.24 195,313.32 195,313.32 - Department number: Wastewater 50,393.24 195,313.32 195,313.32 - Expenditures Subtotal 50,393.24 195,313.32 195,313.32 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 50,393.24 195,306.03 195,306.03- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/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 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/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 935 03/13/2019 March A/P 935 03/13/2019 March A/P 1032 03/31/2019 March A/P Account: 517-69005-020-000 Capital Outlays WWTP legal WWTP Improvements wwtp IMPROVEMENTS 144,920.08 340.00 12,724.24 37,329.00 145,260.08 Dubois Bryant Campbell LLP 157,984.32 CP&Y/WALLACE GROUP, INC. 195,313.32 WEBBER-CADAGUA PARTNERS Capital Outlays Totals: 50,393.24 195,313.32 ** .00 Budgeted (195,313.32) Remaining 0 % Used Department 20 Totals: 195,313.32 ** 50,393.24 Monthly Total .00 Budgeted (195,313.32) Remaining 0 % Used Fund 517 Totals: 195,306.03 50,393.24 Monthly Total .00 Budgeted (195,306.03) Remaining 0 % Used 5097 AP 5093 AP 5184 AP TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET MARCH 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 MARCH 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 MARCH 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 704,573 TOTAL ASSETS 704,573 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 97,663 704,573 704,573 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 15:36 04/16/19 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/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,415.31- 7,471.32- 4,600.00- 27,600.00- 10,432.00- 62,592.00- 16,447.31- 97,663.32- 16,447.31- 97,663.32- 16,447.31- 97,663.32- 16,447.31- 97,663.32- 16,447.31- 97,663.32- 149.426 50.006 49.999 52.683 52.683 52.683 52.683 52.683 2,471.32 27,593.00- 62,595.00- 87,716.68- 87,716.68- 87,716.68- 87,716.68- 87,716.68- glpdatb2 skrolczyk 15:36 04/16/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 1097 03/31/2019 Bank Interest- March Account: 528-49010-000-000 Trophy Club MUD No.1 Page 46 Detailed Accounting Trial Balance Program: Period Ending: 3/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (5,000.00) Budgeted (6,056.01) (1,415.31) 2,471.32 Remaining 149 % Used Account: 528-49142-000-000 Interfund transfer in -Water 1100 03/31/2019 TexPool Transfers March TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (23,000.00) (55,193.00) Budgeted (27,593.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 1100 03/31/2019 TexPool Transfers March TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (7,471.32) GL (1,415.31) (7,471.32) ** (4,600.00) (27,600.00) GL 50 % Used (52,160.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (62,595.00) Remaining (4,600.00) (27,600.00) ** (10,432.00) (62,592.00) GL 50 % Used (16,447.31) Monthly Total (185,380.00) Budgeted (16,447.31) Monthly Total (185,380.00) Budgeted (10,432.00) (62,592.00) ** (97,663.32) ** (87,716.68) Remaining 53 % Used (97,663.32) (87,716.68) Remaining 53 % Used TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET MARCH 2019 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 871,962 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 25,355 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 901,890 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 25,355 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 25,355 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 823,246 TOTAL FUND BALANCE 876,535 TOTAL LIABILITIES AND FUND BALANCE 901,890 glbase_tbam skrolczyk 15:36 04/16/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: 3/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- 7,362.97- 79.70 492.66- 668,843.78- 1,243.98- 1,327.16- 97.332 69.110 66.358 18,331.22- 556.02- 672.84 - Subtotal: 690,975.00- 690,975.00- 7,775.93- 671,414.92- 97.169 19,560.08- 533-49010-000-000 1 533-49015-000-000 Interest Income Lease/Rental Income 2,000.00- 215,979.00- 2,000.00- 215,979.00- 1,755.62- 4,847.31- 215,979.00- 242.366 100.000 2,847.31 533-49141-000-000 Interfund Trans In -PID Surchg 120,053.00- 120,053.00- 10,913.90- 65,483.40- 54.545 54,569.60 - Subtotal: 338,032.00- 338,032.00- 12,669.52- 286,309.71- 84.699 51,722.29 - Program number: 1,029,007.00- 1,029,007.00- 20,445.45- 957,724.63- 93.073 71,282.37 - Department number: Revenues 1,029,007.00- 1,029,007.00- 20,445.45- 957,724.63- 93.073 71,282.37 - Revenues Subtotal 1,029,007.00- 1,029,007.00- 20,445.45- 957,724.63- 93.073 71,282.37- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 15:36 04/16/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 533-70025-051-000 Bond Interest Expense -Tax 533-70035-051-000 Bond Principal Payment -Tax Subtotal: Program number: Department number: Administration Expenditures Fund number: 533 MUD 1 I&S Consolidated Subtotal 2,150.00 266,058.00 755,000.00 2,150.00 266,058.00 755,000.00 1,023,208.00 1,023,208.00 1,450.00 133,028.75 134,478.75 1,023,208.00 1,023,208.00 134,478.75 1,023,208.00 1,023,208.00 5,799.00- 1,023,208.00 1,023,208.00 5,799.00- 134,478.75 134,478.75 67.442 50.000 700.00 133,029.25 755,000.00 13.143 888,729.25 13.143 888,729.25 13.143 13.143 20,445.45- 823,245.88- ############### 888,729.25 888,729.25 817,446.88 glpdatb2 skrolczyk 15:36 04/16/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 Period Ending: 3/2019 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Page 47 Check Source Number Account: 533-40000-000-000 Property Taxes 1062 03/01/2019 Property Taxes 1063 03/04/2019 Property Taxes 1095 03/05/2019 Property Taxes 1072 03/06/2019 Property Taxes 1073 03/07/2019 Property Taxes 1074 03/08/2019 Property Taxes 1075 03/11/2019 Property Taxes 1076 03/12/2019 Property Taxes 1077 03/13/2019 Property Taxes 1078 03/14/2019 Property Taxes 1079 03/15/2019 Property Taxes 1080 03/18/2019 Property Taxes 1081 03/19/2019 Property Taxes 1082 03/20/2019 Property Taxes 1083 03/21/2019 Property Taxes 1084 03/22/2019 Property Taxes 1085 03/25/2019 Property Taxes 1087 03/26/2019 Property Taxes 1088 03/27/2019 Property Taxes 1089 03/28/2019 Property Taxes 1090 03/29/2019 Property Taxes (661,480.81) (558.53) (33.41) (138.19) (937.23) (330.80) (17.44) (384.85) (481.19) (62.48) (171.50) 372.30 (370.95) (1,617.05) (241.44) (206.68) (233.51) (360.40) (285.00) (485.24) (286.49) (532.89) (662,039.34) (662,072.75) (662,210.94) (663,148.17) (663,478.97) (663,496.41) (663,881.26) (664,362.45) (664,424.93) (664,596.43) (664,224.13) (664,595.08) (666,212.13) (666,453.57) (666,660.25) (666,893.76) (667,254.16) (667,539.16) (668,024.40) (668,310.89) (668,843.78) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (7,362.97) (668,843.78) ** (687,175.00) Budgeted (18,331.22) Remaining 97 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1 1073 03/07/2019 Property Taxes 1079 03/15/2019 Property Taxes 1080 03/18/2019 Property Taxes 1088 03/27/2019 Property Taxes (1,323.68) .25 (1,323.43) 283.59 (1,039.84) (.25) (1,040.09) (203.89) (1,243.98) GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 79.70 (1,243.98) ** (1,800.00) Budgeted (556.02) Remaining 69 % Used Account: 533-40015-000-000 Property Taxes/P & I 1062 03/01/2019 Property Taxes 1063 03/04/2019 Property Taxes 1095 03/05/2019 Property Taxes 1072 03/06/2019 Property Taxes 1073 03/07/2019 Property Taxes (834.50) (39.10) (3.01) (9.81) (65.60) (24.03) (873.60) (876.61) (886.42) (952.02) (976.05) GL GL GL GL GL glpdatb2 skrolczyk 15:36 04/16/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description 1074 03/08/2019 Property Taxes 1075 03/11/2019 Property Taxes 1076 03/12/2019 Property Taxes 1077 03/13/2019 Property Taxes 1078 03/14/2019 Property Taxes 1079 03/15/2019 Property Taxes 1080 03/18/2019 Property Taxes 1081 03/19/2019 Property Taxes 1082 03/20/2019 Property Taxes 1084 03/22/2019 Property Taxes 1085 03/25/2019 Property Taxes 1087 03/26/2019 Property Taxes 1088 03/27/2019 Property Taxes 1090 03/29/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 3/2019 JE Detail Description/Comment Page 48 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (834.50) (.35) (30.88) (37.49) (.85) (15.44) (6.27) (.08) (133.33) (.78) (2.93) (15.29) (13.30) (68.44) (25.68) (976.40) (1,007.28) (1,044.77) (1,045.62) (1,061.06) (1,067.33) (1,067.41) (1,200.74) (1,201.52) (1,204.45) (1,219.74) (1,233.04) (1,301.48) (1,327.16) GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (492.66) (1,327.16) ** (2,000.00) Budgeted (672.84) Remaining 66 o Used Account: 533-49010-000-000 Interest Income 1097 03/31/2019 Bank Interest- March (3,091.69) (1,755.62) (4,847.31) GL Account: 533-49010-000-000 Interest Income Totals: (1,755.62) (4,847.31) ** (2,000.00) Budgeted 2,847.31 Remaining 242 % Used Account: 533-49015-000-000 Lease/Rental Income (215,979.00) .00 (215,979.00) Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (215,979.00) ** (215,979.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 1100 03/31/2019 TexPool Transfers March TexPool O&M to I&S- PID Debt (54,569.50) (10,913.90) (65,483.40) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,913.90) (65,483.40) ** Department Totals: (120,053.00) Budgeted (20,445.45) Monthly Total (54,569.60) Remaining 55 5 Used (1,029,007.00) Budgeted (957,724.63) ** (71,282.37) Remaining 93 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee Account: 533-70005-051-000 1,450.00 .00 1,450.00 Paying Agent Fee Totals: .00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 5 Used Account: 533-70025-051-000 Bond Interest Expense -Tax 133,028.75 .00 133,028.75 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 133,028.75 ** 266,058.00 Budgeted 133,029.25 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 .00 ** 755,000.00 Budgeted 755,000.00 Remaining 0 % Used Department 51 Totals: 134,478.75 ** .00 Monthly Total 1,023,208.00 Budgeted 888,729.25 Remaining 13 % Used Fund 533 Totals: (823,245.88) (20,445.45) Monthly Total (5,799.00) Budgeted 817,446.88 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET MARCH 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 238,283 TOTAL ASSETS 238,283 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 218,721 238,283 238,283 glbase_tbam skrolczyk 15:36 04/16/19 Fund: 534 2015 Revenue Bond I&S Account 534-49010-000-000 534-49143-000-000 Description Interest Income Interfund Transfer In -WW Sales Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 3/2019 Amended Total Budget Encumb. 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Program: Current YTD Month Total 388.11- 1,619.06- 54,203.45- 325,220.70- 54,591.56- 326,839.76- 54,591.56- 326,839.76- 54,591.56- 326,839.76- 54,591.56- 326,839.76- % of Budget Remaining Budget 161.906 619.06 54.545 271,017.30- 54.725 270,398.24- 54.725 270,398.24- 54.725 270,398.24- 54.725 270,398.24 - Page 19 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 15:36 04/16/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/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 Program number: 596,238.00 596,238.00 Department number: Administration 596,238.00 596,238.00 Expenditures Subtotal 596,238.00 596,238.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 200.00 107,918.75 108,118.75 108,118.75 108,118.75 108,118.75 50.000 50.000 18.133 18.133 18.133 18.133 54,591.56- 218,721.01- ############### 200.00 107,919.25 380,000.00 488,119.25 488,119.25 488,119.25 488,119.25 217,721.01 glpdatb2 skrolczyk 15:36 04/16/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: 3/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,591.56) Monthly Total (271,017.30) Remaining 55 % Used (597,238.00) Budgeted (326,839.76) ** (270,398.24) Remaining 55 % Used Account: 534-49010-000-000 Interest Income 1097 03/31/2019 Bank Interest- March (1,230.95) (388.11) (1,619.06) GL Account: 534-49010-000-000 Interest Income Totals: ' (388.11) (1,619.06) ** (1,000.00) Budgeted 619.06 Remaining 162 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales • 1100 03/31/2019 TexPool Transfers March TexPool O&M to Rev Bd WWTP I&S (271,017.25) (54,203.45) (325,220.70) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.45) (325,220.70) ** Department Totals: (596,238.00) Budgeted (54,591.56) Monthly Total (271,017.30) Remaining 55 % Used (597,238.00) Budgeted (326,839.76) ** (270,398.24) Remaining 55 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 200.00 .00 200.00 Rev Bond Paying Agent Fee Totals: .00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 107,918.75 .00 107,918.75 Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 107,918.75 ** 215,838.00 Budgeted 107,919.25 Remaining 50 % Used 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 ** .00 Monthly Total 596,238.00 Budgeted 488,119.25 Remaining 18 % Used Fund 534 Totals: (218,721.01) (54,591.56) Monthly Total (1,000.00) Budgeted 217,721.01 Remaining QQQQQQQQ#9 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET MARCH 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 123,395 TOTAL ASSETS 123,395 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 2,583 120,812 123,395 123,395 glbase_tbam skrolczyk 15:36 04/16/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49010-000-000 535-49142-000-000 Subtotal: Program number: Department number: Revenues Revenues Description Interest Income Interfund Tran In -Water Sales Subtotal Department: Adopted Budget 600.00- 276,901.00- 277,501.00- 277,501.00- 277,501.00- 277,501.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 3/2019 Amended Total Budget Encumb. 600.00- 276,901.00- 277,501.00- 277,501.00- 277,501.00- 277,501.00 - Program: Current YTD Month Total 206.34- 725.23- 25,172.81- 151,036.86- 25,379.15- 151,762.09- 25,379.15- 151,762.09- 25,379.15- 151,762.09- 25,379.15- 151,762.09- % of Budget Remaining Budget 120.872 125.23 54.545 125,864.14- 54.689 125,738.91- 54.689 125,738.91- 54.689 125,738.91- 54.689 125,738.91 - Page 21 glbase_tbam skrolczyk 15:36 04/16/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: 3/2019 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month Program: YTD Total 200.00 % of Remaining Budget Budget 50.000 200.00 Page 22 535-70040-051-000 Revenue Bond Interest Expense 1 535-70045-051-000 Revenue Bond Principal Expense 61,501.00 215,000.00 61,501.00 215,000.00 30,750.50 50.000 30,750.50 215,000.00 Subtotal: 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Program number: 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Department number: Administration 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Expenditures Subtotal 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,379.15- 120,811.59- ############### 120,211.59 ******* End of Report ********* glpdatb2 skrolczyk 15:36 04/16/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: 3/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,379.15) Monthly Total (125,864.14) Remaining 55 % Used (277,501.00) Budgeted (151,762.09) ** (125,738.91) Remaining 55 % Used Account: 535-49010-000-000 Interest Income 1097 03/31/2019 Bank Interest- March (518.89) (206.34) (725.23) GL Account: 535-49010-000-000 Interest Income Totals: (206.34) (725.23) ** (600.00) Budgeted 125.23 Remaining 121 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1100 03/31/2019 TexPool Transfers March TexPool O&M to 16Swift Rev I&S (125,864.05) (25,172.81) (151,036.86) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.81) (151,036.86) ** Department Totals: (276,901.00) Budgeted (25,379.15) Monthly Total (125,864.14) Remaining 55 % Used (277,501.00) Budgeted (151,762.09) ** (125,738.91) Remaining 55 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 15:36 04/16/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 3/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 200.00 .00 200.00 Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 30,750.50 .00 30,750.50 Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 30,750.50 ** 61,501.00 Budgeted 30,750.50 Remaining 50 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 ** Department 51 Totals: Fund 535 Totals: Grand Totals: 215,000.00 Budgeted 215,000.00 Remaining 0 % Used .00 Monthly Total 276,901.00 Budgeted (25,379.15) Monthly Total 30,950.50 ** 245,950.50 Remaining 11 % Used (120,811.59) (600.00) Budgeted 120,211.59 Remaining 8888888888 (79,720.32) Monthly Total ******* End of Report ********* (1,234,746.77) **** (534,616.00) Budgeted 700,130.77 Remaining 231 % Used