Loading...
HomeMy WebLinkAbout2019-01 Combined Financials January 2019TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JANUARY 2019 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,083,646 PREPAID EXPENSES 11,930 ADVALOREM PROPERTY TAXES RECEIVABLE 142,469 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,238,046 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 142,470 TOTAL LIABILITIES 142,470 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 543,884 551,693 1,095,577 1,238,046 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 122-40010-000-000 1 122-40011-000-000 1 122-40020-000-000 Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&i Trophy Club MUD No.1 Page 1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 1/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 338,169.04- 226.67- 236.39- 989,942.37- 666.02- 434.83- 88.625 127,057.63- 666.02 434.83 Subtotal: 1,117,000.00- 1,117,000.00- 338,632.10- 991,043.22- 88.724 125,956.78- 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- 338,632.10- 991,043.22- 83.141 200,956.78 - Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 338,632.10- 991,043.22- 83.141 200,956.78 - Revenues Subtotal 1,192,000.00- 1,192,000.00- 338,632.10- 991,043.22- 83.141 200,956.78- glbase_tbam skrolczyk 18:55 02/13/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 1 122-60030-045-000 1 122-60055-045-000 1 122-60337-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Program: Period Ending: 1/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 56,204.33 5,964.84 224,816.99 33.138 33.333 215,979.00 12,035.16 449,635.01 Page 2 Subtotal: 908,431.00 908,431.00 57,695.54 230,781.83 25.404 677,649.17 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 57,695.54 439,350.43 36.858 752,649.57 Department number: Fire 1,192,000.00 1,192,000.00 57,695.54 439,350.43 36.858 752,649.57 Expenditures Subtotal 1,192,000.00 1,192,000.00 57,695.54 439,350.43 36.858 752,649.57 Fund number: 122 Trophy Club MUD Fire Dept. 280,936.56- 551,692.79- 551,692.79 glpdatb2 skrolczyk 18:55 02/13/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 1/2019 JE Detail Description/Comment Page 1 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 718 01/02/2019 Property Taxes 719 01/03/2019 Property Taxes 720 01/04/2019 Property Taxes 721 01/07/2019 Property Taxes 722 01/08/2019 Property Taxes 723 01/09/2019 Property Taxes 724 01/10/2019 Property Taxes 725 01/11/2019 Property Taxes 726 01/14/2019 Property Taxes 728 01/15/2019 Property Taxes 729 01/16/2019 Property Taxes 730 01/17/2019 Property Taxes 731 01/18/2019 Property Taxes 732 01/22/2019 Property Taxes 733 01/23/2019 Property Taxes 734 01/24/2019 Property Taxes 735 01/25/2019 Property Taxes 736 01/28/2019 Property Taxes 737 01/29/2019 Property Taxes 738 01/30/2019 Property Taxes 739 01/31/2019 Property Taxes (651,773.33) (18,406.66) (670,179.99) GL (16,727.97) (686,907.96) GL (8,675.55) (695,583.51) GL (11,870.41) (707,453.92) GL (15,996.59) (723,450.51) GL (10,902.09) (734,352.60) GL (10,143.99) (744,496.59) GL (52,856.83) (797,353.42) GL (6,084.58) (803,438.00) GL (15,209.93) (818,647.93) GL (6,464.95) (825,112.88) GL (3,362.63) (828,475.51) GL (11,448.81) (839,924.32) GL (6,418.03) (846,342.35) GL (7,926.97) (854,269.32) GL (10,572.50) (864,841.82) GL (43,291.23) (908,133.05) GL (13,396.32) (921,529.37) GL (41,419.69) (962,949.06) GL (14,447.42) (977,396.48) GL (12,545.89) (989,942.37) GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (338,169.04) (989,942.37) ** (1,117,000.00) Budgeted (127,057.63) Remaining 89 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 718 01/02/2019 Property Taxes 719 01/03/2019 Property Taxes 725 01/11/2019 Property Taxes 728 01/15/2019 Property Taxes 735 01/25/2019 Property Taxes 736 01/28/2019 Property Taxes 737 01/29/2019 Property Taxes (439.35) (3.20) (442.55) GL (.55) (443.10) GL (90.28) (533.38) GL (2.77) (536.15) GL (42.58) (578.73) GL (86.66) (665.39) GL (.63) (666.02) GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (226.67) (666.02) ** .00 Budgeted 666.02 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 718 01/02/2019 Property Taxes (198.44) (.26) (198.70) GL 719 01/03/2019 Property Taxes (.07) (198.77) GL glpdatb2 skrolczyk 18:55 02/13/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 721 01/07/2019 Property Taxes 722 01/08/2019 Property Taxes 723 01/09/2019 Property Taxes 725 01/11/2019 Property Taxes 728 01/15/2019 Property Taxes 733 01/23/2019 Property Taxes 734 01/24/2019 Property Taxes 736 01/28/2019 Property Taxes 737 01/29/2019 Property Taxes 738 01/30/2019 Property Taxes 739 01/31/2019 Property Taxes Account: 122-40020-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 1/2019 JE Detail Description/Comment Page 2 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (198.44) (5.23) (204.00) GL (39.83) (243.83) GL (5.26) (249.09) GL (10.68) (259.77) GL (6.96) (266.73) GL (.21) (266.94) GL (12.12) (279.06) GL (80.39) (359.45) GL (.08) (359.53) GL (2.38) (361.91) GL (72.92) (434.83) GL Property Taxes/Fire P&L Totals: (236.39) (434.83) ** .00 Budgeted Account: 122-49035-000-000 Prior Year Reserves Account: 122-49035-000-000 Department Totals: 434.83 Remaining 0 % Used Prior Year Reserves Totals: (75,000.00) Budgeted (75,000.00) Remaining 0 % Used (338,632.10) Monthly Total (1,192,000.00) Budgeted .00 .00 .00 .00 ** (991,043.22) ** (200,956.78) Remaining 83 % Used glpdatb2 skrolczyk 18:55 02/13/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 1/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 3 Check Source Number Department 45 Totals: 127,149.00 Budgeted 57,695.54 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 439,350.43 ** 752,649.57 Remaining 37 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 215,979.00 Budgeted 215,979.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 128 01/01/2019 Insurance/Wrk Comp Expense Jan 4,473.63 1,491.21 5,964.84 GL Account: 122-60055-045-000 Insurance Totals: 1,491.21 5,964.84 ** 18,000.00 Budgeted 12,035.16 Remaining 33 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 599 01/18/2019 January A/P January Fire Admin 168,612.66 56,204.33 224,816.99 TOWN OF TROPHY CLUB 4946 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 56,204.33 224,816.99 ** 674,452.00 Budgeted 449,635.01 Remaining 33 % 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 57,695.54 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 439,350.43 ** 752,649.57 Remaining 37 % Used glpdatb2 skrolczyk 18:55 02/13/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Page 4 Detailed Accounting Trial Balance Department: 45 Fire Program: Period Ending: 1/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Fund 122 Totals: (551,692.79) (280,936.56) Monthly Total .00 Budgeted 551,692.79 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JANUARY 2019 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 1,260,757 1,260,757 CASH IN BANK -SAVINGS -CASH RESERVE 1,186,075 1,186,075 INVESTMENTS-TEXPOOL 3,519,961 782,846 4,302,807 CASH- ESCROW 3,681 3,681 PREPAID EXPENSES 71,871 71,871 ADVALOREM PROPERTY TAXES RECEIVABLE 16,108 16,108 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,003,448 2,003,448 TOTAL ASSETS 8,062,501 782,846 8,845,347 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 16,108 16,108 ACCOUNTS AND OTHER PAYABLES 429,127 429,127 CUSTOMER DEPOSITS 313,215 313,215 TOTAL LIABILITIES 758,450 758,450 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 (320,135) (320,135) TOTAL FUND BALANCE 7,304,051 782,846 8,086,897 TOTAL LIABILITIES AND FUND BALANCE 8,062,501 782,846 8,845,347 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 Subtotal: 135-49010-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 135-49901-000-000 Subtotal: Program number: Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income Records Management Revenue Department number: Revenues Revenues Subtotal Department: Adopted Budget 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 20,000.00- 14,146.00- 7,000.00- 10,000.00- 18,522.00- 7,000.00- 76,668.00- 10,613,202.00- 10,613,202.00- 10,613,202.00- Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 1/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 38,502.67- 38.05- 35.12- 38,575.84- 287,951.59- 262,046.02- 6,089.82- 1,525.00 - Program: YTD Total 112,711.18- 93.89- 57.65- 112,862.72- 1,181,180.09- 1,000,135.95- 34,312.75- 5,750.00- 250.00- 750.00- 17.60- 557,612.43- 2,222,396.39- 12,336.55- 39,687.71- 1,178.81- 5,041.91- 583.33- 2,333.32- 251.49- 14,350.18- 1,715.00- 3,208.08- 2.00- 51,988.02- 610,538.45- 2,387,247.13- 610,538.45- 2,387,247.13- 610,538.45- 2,387,247.13- % of Budget 85.140 31.297 19.217 37.008 17.898 29.307 25.153 33.824 16.667 16.667 .029 Remaining Budget 19,672.82- 206.11- 242.35- 171,983.00- 192,104.28- 5,418,303.91- 2,412,529.05- 102,105.25- 11,250.00- 1,250.00- 3,750.00- 59,982.40- 21.721 8,009,170.61- 198.439 35.642 33.333 9.259 45.830 67.809 19,687.71 9,104.09- 4,666.68- 10,000.00- 16,807.00- 3,791.92- 2.00 ,104.09 -4,666.68-10,000.00-16,807.00- 3,791.92- 2.00 24,679.98- 22.493 8,225,954.87- 22.493 8,225,954.87- 22.493 8,225,954.87 - Page 3 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund Account 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 Description Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Department: Adopted Budget 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Period Ending: 1/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 91,395.43 27.971 533.10 3,047.14 15.236 3,620.00 100.000 175.00 750.00 15.625 2,177.00 10,191.47 30.601 4,219.68 13,066.08 17.464 261.55 902.50 20.906 42.47 150.23 21.431 19.00 876.44 27.992 1,394.03 6,012.23 27.302 326.03 1,406.09 27.303 423.63 423.63 39.225 930.94 3,723.76 28.878 Remaining Budget 235,359.57 16,952.86 4,050.00 23,112.53 61,751.92 3,414.50 550.77 2,254.56 16,008.77 3,743.91 656.37 9,171.24 200.00 300.00 Page 4 Subtotal: 513,092.00 513,092.00 33,329.57 135,565.00 26.421 377,527.00 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 1,903.30 14,870.91 14.871 963.30 1,906.30 63.543 73.07 927.25 18.545 547.40 1,375.10 21.155 20,000.00 85,129.09 1,093.70 4,072.75 3,500.00 5,214.00 5,124.90 Subtotal: 143,214.00 143,214.00 3,487.07 19,079.56 13.322 124,134.44 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,309.56 26.191 15,429.73 41,630.72 26.997 280.00 691.00 14.857 126,939.74 25,172.81 4,600.00 7,685.65 13.251 381,585.11 12.663 2,090.00 14.169 100,691.24 17.206 18,400.00 33.338 3,690.44 112,573.28 1,000.00 500.00 3,960.00 400.00 2,345.00 1,500.00 50,314.35 2,631,908.89 200.00 3,000.00 12,660.00 484,517.76 36,793.00 200,000.00 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Subtotal: 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 Subtotal: 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtotal: Program number: Description Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Department: Adopted Budget 2,500.00 4,101,946.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 Trophy Club MUD No.1 Page 5 Budget Summary with Amendment 10 Water Period Ending: 1/2019 Amended Total Budget Encumb. 2,500.00 4,101,946.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 Current Month 172,708.07 651.63 1,817.96 6,555.80 31,482.00 40,507.39 95,497.23 30,068.00 2,283.93 41,944.38 169,793.54 419,825.64 Program: YTD Total 554,083.28 2,944.53 1,417.41 7,393.84 17,861.60 31,482.00 61,099.38 152,689.83 30,068.00 2,283.93 75,000.00 99,877.11 359,918.87 1,129,746.09 % of Budget 13.508 19.630 27.310 36.969 25.517 36.186 30.643 33.706 100.000 55.381 100.000 83.231 52.759 20.032 Remaining Budget 2,500.00 3,547,862.72 12,055.47 3,772.59 12,606.16 1,200.00 1,000.00 52,138.40 55,518.00 138,290.62 300,310.17 1,840.07 20,122.89 322,273.13 4,510,087.91 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 18:55 02/13/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/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 447.70 22.385 447.70 22.385 447.70 419,825.64 1,130,193.79 22.385 20.032 1,552.30 1,552.30 1,552.30 4,511,640.21 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 18:55 02/13/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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,119.04 104,757.49 24.842 316,941.51 135-50010-020-000 Overtime 30,000.00 30,000.00 2,767.93 11,211.72 37.372 18,788.28 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 650.00 2,700.00 31.034 6,000.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,732.18 13,182.27 30.461 30,093.73 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,588.48 21,529.46 23.497 70,097.54 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 340.56 1,456.23 28.531 3,647.77 135-50028-020-000 Vision Insurance 826.00 826.00 55.64 232.34 28.128 593.66 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 38.00 1,044.71 23.242 3,450.29 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 1,725.81 7,321.88 25.243 21,684.12 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 403.63 1,712.39 25.242 5,071.61 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 531.67 531.67 42.196 728.33 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 4,822.92 28.469 12,118.08 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,158.67 177,986.08 26.650 489,876.92 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 891.00 891.00 5.940 14,109.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 2,142.58 22,535.66 25.609 65,464.34 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 3,677.32 4,300.82 43.008 5,699.18 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 27.47 183.67 2.296 7,816.33 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,505.51 1,533.28 102.219 33.28- 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 3,409.58 24,999.76 33.333 50,000.24 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 5,550.67 16,326.24 46.646 18,673.76 Subtotal: 267,714.00 267,714.00 17,204.13 70,770.43 26.435 196,943.57 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 369.40 1,492.06 29.841 3,507.94 135-60020-020-000 Electricity 174,165.00 174,165.00 26,348.69 64,079.09 36.792 110,085.91 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 630.00 741.00 10.356 6,414.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 100.74 100.74 10.074 899.26 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 1,895.00 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 57.84 647.84 5.585 10,952.16 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 10,913.90 43,655.60 36.364 76,397.40 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund Account 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Description Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 Department: Adopted Budget 688,330.00 125,187.00 200,000.00 3,500.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 1/2019 Amended Total Budget Encumb. 688,330.00 125,187.00 200,000.00 3,500.00 Current Month 54,203.45 10,432.00 Program: YTD Total 216,813.80 41,728.00 % of Budget 31.499 33.333 Remaining Budget 471,516.20 83,459.00 200,000.00 3,500.00 Page 8 Subtotal: 1,381,335.00 1,381,335.00 103,056.02 386,097.53 27.951 995,237.47 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 570.93 81.17 1,161.96 39.98 291.37 678.41 3,953.89 2,059.90 2,753.78 54.95 843.55 3,138.64 31.631 37.487 9.179 4.579 70.296 15.693 8,546.11 3,435.10 27,246.22 1,145.05 356.45 16,861.36 Subtotal: 70,395.00 70,395.00 2,823.82 12,804.71 18.190 57,590.29 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement 330,000.00 109,858.00 14,917.00 30,000.00 330,000.00 109,858.00 14,917.00 30,000.00 361,680.49 39,858.59 3,027.55 405,880.81 39,858.59 3,027.55 30,000.00 122.994 36.282 20.296 100.000 75,880.81- 69,999.41 11,889.45 Subtotal: 484,775.00 484,775.00 404,566.63 478,766.95 98.761 6,008.05 135-70020-020-000 Capital Lease Issuance Cost 1,500.00 1,500.00 1,500.00 - Subtotal: 1,500.00 1,500.00 1,500.00 - Program number: 2,872,082.00 2,872,082.00 571,309.27 1,127,925.70 39.272 1,744,156.30 Department number: Wastewater 2,872,082.00 2,872,082.00 571,309.27 1,127,925.70 39.272 1,744,156.30 glbase_tbam skrolczyk 18:55 02/13/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: 1/2019 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 2.12 Program: YTD Total 8.48 % of Remaining Budget Budget 28.267 21.52 Page 9 Subtotal: 30.00 30.00 2.12 8.48 28.267 21.52 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 338.57 650.00 565.00 338.57 86.667 14.125 6.771 150.00 100.00 1,300.00 3,435.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 338.57 1,553.57 11.769 11,646.43 Program number: 13,230.00 13,230.00 340.69 1,562.05 11.807 11,667.95 Department number: Board of Directors 13,230.00 13,230.00 340.69 1,562.05 11.807 11,667.95 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 18:55 02/13/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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,294.61 2,617.26 4,824.42 259.52 42.51 19.00 1,670.65 390.71 509.31 106.55 103.95 63.18 112,373.14 10.45 1,832.50 11,925.20 17,260.14 1,038.08 170.04 1,154.62 6,799.79 1,590.27 509.31 426.20 103.95 2,883.23 25.481 .523 99.973 28.981 21.076 24.192 24.257 25.687 24.655 24.655 40.421 32.911 20.790 57.665 328,632.86 1,989.55 .50 29,222.80 64,634.86 3,252.92 530.96 3,340.38 20,780.21 4,859.73 750.69 868.80 396.05 2,116.77 Subtotal: 619,454.00 619,454.00 38,901.67 158,076.92 25.519 461,377.08 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 18,661.09 13,231.73 869.06 579.59 36,781.68 48,410.62 795.00 2,607.18 59,205.00 2,321.98 47.247 27.663 3.975 26.072 89.630 25.800 41,067.32 126,589.38 19,205.00 10,000.00 7,392.82 6,850.00 6,678.02 Subtotal: 367,904.00 367,904.00 33,341.47 150,121.46 40.805 217,782.54 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60125-030-000 135-60235-030-000 Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Advertising Security 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 1,529.86 237.55 932.40 53.86 1,710.93 4,869.25 6,302.73 135.00 24.00 6,028.82 950.02 1,490.11 215.12 6,675.30 23,023.78 25.655 23.751 17.147 10.756 22.251 41.439 25,210.92 38.786 3,801.25 63.354 135.00 1.508 96.00 7.453 17,471.18 3,049.98 7,199.89 1,784.88 23,324.70 32,536.22 1,500.00 39,789.08 1,000.00 2,198.75 400.00 6,000.00 8,815.00 4,345.00 200.00 25,000.00 1,192.00 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund Account Description 135-60245-030-000 135-60246-030-000 135-60360-030-000 Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 Trophy Club MUD No.1 Page 11 Budget Summary with Amendment Department: 30 Administration Program: Period Ending: 1/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 124.49 24.898 375.51 17,000.00 2,500.00 Subtotal: 263,433.00 263,433.00 15,920.07 67,750.81 25.718 195,682.19 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 399.74 700.35 1,246.49 2,295.86 1,704.11 17.646 38.264 42.603 2,050.00 5,817.51 3,704.14 3,500.00 2,295.89 2,500.00 Subtotal: 25,114.00 25,114.00 1,100.09 5,246.46 20.891 19,867.54 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 280,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 277.84 1,111.80 27.795 2,888.20 Subtotal: 284,000.00 284,000.00 277.84 1,111.80 .391 282,888.20 Program number: 1,559,905.00 1,559,905.00 89,541.14 382,307.45 24.508 1,177,597.55 Department number: Administration 1,559,905.00 1,559,905.00 89,541.14 382,307.45 24.508 1,177,597.55 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund Department: Account Description Adopted 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 Trophy Club MUD No.1 Page 12 Budget Summary with Amendment 39 Non Departmental Program: Period Ending: 1/2019 Amended Total Current YTD % of Budget Encumb. Month Total Budget 137,000.00 30,800.00 11,714.00 4,800.00 7,407.50 11,709.53 30,557.18 26,459.53 4,723.22 3,653.00 22.305 85.908 40.321 76.104 Remaining Budget 106,442.82 4,340.47 6,990.78 1,147.00 Subtotal: 184,314.00 184,314.00 19,117.03 65,392.93 35.479 118,921.07 Program number: 184,314.00 184,314.00 19,117.03 65,392.93 35.479 118,921.07 Department number: Non Departmental 184,314.00 184,314.00 19,117.03 65,392.93 35.479 118,921.07 Expenditures Subtotal 10,271,365.00 10,271,365.00 1,100,133.77 2,707,381.92 26.359 7,563,983.08 Fund number: 135 MUD 1 General Fund 341,837.00- 341,837.00- 489,595.32 320,134.79 -93.651 661,971.79- glbase_tbam skrolczyk 18:55 02/13/19 Fund: 137 MUD 1 Consolidated GASB Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 1/2019 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Remaining Budget Page 13 137-49145-000-000 1 137-49146-000-000 Intergov Transfer -General Fund Intergov Transfer -Fire Dept 105,000.00- 81,420.00- 105,000.00 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 1/2019 JE Detail Description/Comment Page 5 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 718 01/02/2019 Property Taxes 719 01/03/2019 Property Taxes 720 01/04/2019 Property Taxes 721 01/07/2019 Property Taxes 722 01/08/2019 Property Taxes 723 01/09/2019 Property Taxes 724 01/10/2019 Property Taxes 725 01/11/2019 Property Taxes 726 01/14/2019 Property Taxes 728 01/15/2019 Property Taxes 729 01/16/2019 Property Taxes 730 01/17/2019 Property Taxes 731 01/18/2019 Property Taxes 732 01/22/2019 Property Taxes 733 01/23/2019 Property Taxes 734 01/24/2019 Property Taxes 735 01/25/2019 Property Taxes 736 01/28/2019 Property Taxes 737 01/29/2019 Property Taxes 738 01/30/2019 Property Taxes 739 01/31/2019 Property Taxes (74,208.51) (2,095.71) (76,304.22) GL (1,904.58) (78,208.80) GL (987.77) (79,196.57) GL (1,351.52) (80,548.09) GL (1,821.31) (82,369.40) GL (1,241.27) (83,610.67) GL (1,154.96) (84,765.63) GL (6,018.08) (90,783.71) GL (692.77) (91,476.48) GL (1,731.75) (93,208.23) GL (736.08) (93,944.31) GL (382.86) (94,327.17) GL (1,303.52) (95,630.69) GL (730.73) (96,361.42) GL (902.54) (97,263.96) GL (1,203.74) (98,467.70) GL (4,928.98) (103,396.68) GL (1,525.25) (104,921.93) GL (4,715.89) (109,637.82) GL (1,644.93) (111,282.75) GL (1,428.43) (112,711.18) GL Account: 135-40000-000-000 Property Taxes Totals: (38,502.67) (112,711.18) ** (132,384.00) Budgeted (19,672.82) Remaining 85 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1 718 01/02/2019 Property Taxes 719 01/03/2019 Property Taxes 725 01/11/2019 Property Taxes 728 01/15/2019 Property Taxes 735 01/25/2019 Property Taxes 736 01/28/2019 Property Taxes 737 01/29/2019 Property Taxes (55.84) (.37) (56.21) GL (.06) (56.27) GL (10.36) (66.63) GL (.32) (66.95) GL (8.18) (75.13) GL (18.70) (93.83) GL (.06) (93.89) GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (38.05) (93.89) ** (300.00) Budgeted (206.11) Remaining 31 % Used Account: 135-40015-000-000 Property Taxes/P & I 718 01/02/2019 Property Taxes 719 01/03/2019 Property Taxes (22.53) (.03) (22.56) GL (.02) (22.58) GL glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 721 01/07/2019 Property Taxes 722 01/08/2019 Property Taxes 723 01/09/2019 Property Taxes 725 01/11/2019 Property Taxes 728 01/15/2019 Property Taxes 733 01/23/2019 Property Taxes 734 01/24/2019 Property Taxes 736 01/28/2019 Property Taxes 738 01/30/2019 Property Taxes 739 01/31/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 1/2019 JE Detail Description/Comment Page 6 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (22.53) (.60) (23.18) GL (4.54) (27.72) GL (.60) (28.32) GL (1.22) (29.54) GL (.79) (30.33) GL (.02) (30.35) GL (1.39) (31.74) GL (17.34) (49.08) GL (.27) (49.35) GL (8.30) (57.65) GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (35.12) (57.65) ** (300.00) Budgeted (242.35) Remaining 19 % 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 604 01/18/2019 UB 01/18/2019 CreditAdjustment UB20190118-20190118 User: 628 01/23/2019 UB 01/23/2019 Water adjustment UB20190123-20190123 User: 669 01/31/2019 UB 02/01/2019 Billing UB20190131-20190131 User: (893,228.50) 21.01 (893,207.49) UB 50.05 (893,157.44) UB (288,022.65) (1,181,180.09) UB Account: 135-47000-000-000 Water Totals: (287,951.59) (1,181,180.09) ** (6,599,484.00) Budgeted (5,418,303.91) Remaining 18 % Used Account: 135-47005-000-000 Sewer 604 01/18/2019 UB 01/18/2019 CreditAdjustment UB20190118-20190118 User: (738,089.93) 669 01/31/2019 UB 02/01/2019 Billing UB20190131-20190131 User: 39.55 (738,050.38) UB (262,085.57) (1,000,135.95) UB Account: 135-47005-000-000 Sewer Totals: (262,046.02) (1,000,135.95) ** (3,412,665.00) Budgeted (2,412,529.05) Remaining 29 6 Used Account: 135-47025-000-000 Penalties 497 01/03/2019 Penalty Removal 01/03/2018 UB20190103-20190103 User: 681 01/03/2019 UB 01/03/2019 Penalty Removal UB20190103-20190103 User: 553 01/09/2019 UB 01/09/2019 Penalty removal UB20190109-20190109 User: (28,222.93) 20.30 (28,202.63) UB 18.53 (28,184.10) UB 582.20 (27,601.90) UB glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 623 01/22/2019 UB 01/22/2019 Penalties 646 01/28/2019 DB 01/28/2019 Penalty Removal 649 01/28/2019 Penalty Removal 01/28/2019 654 01/29/2019 UB 01/29/2019 Penalty Removal Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 1/2019 Beginning Balance JE Detail Description/Comment UB20190122-20190122 User: UB20190128-20190128 User: UB20190128-20190128 User: UB20190129-20190129 User: (28,222.93) Program: Transaction Detail (6,901.42) 134.17 13.40 43.00 Transaction Vendor_Name Detail (SUBTOTAL) (34,503.32) (34,369.15) (34,355.75) (34,312.75) Page 7 Check Source Number UB UB UB UB Account: 135-47025-000-000 Penalties =I Totals: (6,089.82) (34,312.75) ** (136,418.00) Budgeted (102,105.25) Remaining 25 % Used Account: 135-47030-000-000 11111 Service Charges ' 547 01/08/2019 UB 01/08/2019 Disconnect Fees 622 01/22/2019 UB 01/22/2019 NSF check fee 627 01/23/2019 Ub 01/23/2019 NSF Checks 655 01/23/2019 UB 01/23/2019 NSF Check 656 01/24/2019 UB 01/24/2019 NSF Check UB20190108-20190108 User: UB20190122-20190122 User: UB20190123-20190123 User: UB20190123-20190123 User: UB20190124-20190124 User: (4,225.00) (1,400.00) (25.00) (50.00) (25.00) (25.00) (5,625.00) (5,650.00) (5,700.00) (5,725.00) (5,750.00) UB UB UB UB UB Account: 135-47030-000-000 Service Charges Totals: (1,525.00) (5,750.00) ** (17,000.00) Budgeted (11,250.00) Remaining 34 % Used Account: 135-47035-000-000 Plumbing Inspections ' (250.00) .00 (250.00) Account: 135-47035-000-000 Plumbing Inspections ' Totals: .00 (250.00) ** (1,500.00) Budgeted (1,250.00) Remaining 17 % Used Account: 135-47045-000-000 Sewer Inspections (750.00) .00 (750.00) Account: 135-47045-000-000 Sewer Inspections Totals: .00 (750.00) ** (4,500.00) Budgeted (3,750.00) Remaining 17 % Used Account: 135-47070-000-000 TCCC Effluent Charges (17.60) .00 (17.60) Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (17.60) ** (60,000.00) Budgeted (59,982.40) Remaining 0 % Used Account: 135-49010-000-000 Interest Income 715 01/31/2019 Bank Interest- January (27,351.16) (1,101.23) (28,452.39) GL glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 1/2019 JE Detail Description/Comment 715 01/31/2019 Bank Interest- January 715 01/31/2019 Bank Interest- January 756 01/31/2019 Escrow Vaccon Int & Cap Purchs October 2018 Interest 756 01/31/2019 Escrow Vaccon Int & Cap Purchs November 2018 Interest 756 01/31/2019 Escrow Vaccon Int & Cap Purchs December 2018 Interest 756 01/31/2019 Escrow Vaccon Int & Cap Purchs January 2019 Interest Page 8 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (27,351.16) Account: 135-49010-000-000 Interest Inc (20,000.00) Budgeted 19,687.71 Remaining 198 % Used (839.57) (29,291.96) GL (9,139.46) (38,431.42) GL (428.61) (38,860.03) GL (493.53) (39,353.56) GL (328.74) (39,682.30) GL (5.41) (39,687.71) GL (12,336.55) (39,687.71) ** Account: 135-49016-000-000 Cell Tower Revenue 714 01/18/2019 Cell Tower Rev AT&T January (3,863.10) (1,178.81) (5,041.91) GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (5,041.91) ** (14,146.00) Budgeted (9,104.09) Remaining 36 % Used Account: 135-49018-000-000 Building Rent Income 746 01/31/2019 Town BIlled Invoices 1672-1675 AR 20190131-20190131 User: (1,749.99) (583.33) (2,333.32) AR Account: 135-49018-000-000 Building Rent 11111111= (583.33) (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement (1,715.00) .00 (1,715.00) Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 (1,715.00) ** (18,522.00) Budgeted (16,807.00) Remaining Account: 135-49900-000-000 677 01/18/2019 UB Adj-Pannell 669 01/31/2019 UB 02/01/2019 Billing Miscellaneous Income UB20190118-20190118 User: UB20190131-20190131 User: 9 % Used (2,956.59) (.38) (251.11) (2,956.97) UB (3,208.08) UB glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 1/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 9 Check Source Number Department Totals: (610,538.45) Monthly Total (2,387,247.13) ** (10,613,202.00) Budgeted (8,225,954.87) Remaining 22 % Used Account: 135-49900-000-000 Miscellaneous Income Totals: (251.49) (3,208.08) ** (7,000.00) Budgeted (3,791.92) Remaining 46 % 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: (610,538.45) Monthly Total (2,387,247.13) ** (10,613,202.00) Budgeted (8,225,954.87) Remaining 22 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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 548 01/11/2019 MUD Payroll 1/11/2019 Salaries & Wages 615 01/25/2019 MUD Payroll 01/25/19 Salaries & Wages Account: 135-50005-010-000 Account: 135-50010-010-000 Salaries & Wages Totals: 326,755.00 Budgeted 548 01/11/2019 MUD Payroll 1/11/2019 Overtime 615 01/25/2019 MUD Payroll 01/25/19 Overtime Account: 135-50010-010-000 _ Overtime 20,000.00 Budgeted 68,568.29 235,359.57 Remaining 28 % Used 2,514.04 Totals: 16,952.86 Remaining 15 % Used 11,413.57 79,981.86 11,413.57 91,395.43 22,827.14 91,395.43 ** 103.33 429.77 2,617.37 3,047.14 533.10 3,047.14 ** PR PR PR PR Account: 135-50016-010-000 ongevity Account: 135-50016-010-000 Longevity 3,620.00 Budgeted Account: 135-50017-010-000 - Certification 615 01/25/2019 MUD Payroll 01/25/19 Certification Account: 135-50017-010-000 Certification 4,800.00 Budgeted Account: 135-50020-010-000 Retirement 548 01/11/2019 MUD Payroll 1/11/2019 Retirement 615 01/25/2019 MUD Payroll 01/25/19 Retirement Totals: .00 Remaining 3,620.00 100 % Used .00 .00 3,620.00 3,620.00 ** 575.00 175.00 750.00 PR Totals: 4,050.00 Remaining 16 6 Used 8,014.47 175.00 750.00 ** 1,065.32 9,079.79 1,111.68 10,191.47 PR PR Account: 135-50020-010-000 Retirement Totals: 2,177.00 10,191.47 ** 33,304.00 Budgeted Account: 135-50026-010-000 Medical Insurance 548 01/11/2019 MUD Payroll 1/11/2019 Medical Insurance 615 01/25/2019 MUD Payroll 01/25/19 Medical Insurance Account: 135-50026-010-000 23,112.53 Remaining 31 % Used Medical Insurance Totals: 74,818.00 Budgeted 8,846.40 61,751.92 Remaining 17 6 Used 2,109.86 10,956.26 2,109.82 13,066.08 4,219.68 13,066.08 ** PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 548 01/11/2019 MUD Payroll 1/11/2019 Dental Insurance 615 01/25/2019 MUD Payroll 01/25/19 Dental Insurance Account: 135-50027-010-000 Dental Insurance Totals: 4,317.00 Budgeted Account: 135-50028-010-000 Vision Insurance 548 01/11/2019 MUD Payroll 1/11/2019 Vision Insurance 615 01/25/2019 MUD Payroll 01/25/19 Vision Insurance Account: 135-50028-010-000 3,414.50 Remaining Vision Insurance Totals: 701.00 Budgeted Account: 135-50029-010-000 — Life Insurance & Other 661 01/31/2019 January A/P Caf 125 640.95 21 % Used 107.76 550.77 Remaining 21 % Used 130.80 130.75 771.75 902.50 902.50 ** 21.25 129.01 21.22 150.23 42.47 150.23 ** 857.44 19.00 PR PR PR PR 876.44 BenefitMall 4954 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 19.00 876.44 ** 3,131.00 Budgeted 2,254.56 Remaining 28 % Used Account: 135-50030-010-000 Social Security Taxes 548 01/11/2019 MUD Payroll 1/11/2019 Social Security Taxes 615 01/25/2019 MUD Payroll 01/25/19 Social Security Taxes 4,618.20 682.86 5,301.06 PR 711.17 6,012.23 PR Account: 135-50030-010-000 Social Security Taxes Totals: 1,394.03 6,012.23 ** 22,021.00 Budgeted Account: 135-50035-010-000 Medicare Taxes 548 01/11/2019 MUD Payroll 1/11/2019 Medicare Taxes 615 01/25/2019 MUD Payroll 01/25/19 Medicare Taxes 16,008.77 Remaining 27 % Used 1,080.06 159.70 1,239.76 PR 166.33 1,406.09 PR Account: 135-50035-010-000 Medicare Taxes Totals: 326.03 1,406.09 ** 5,150.00 Budgeted 3,743.91 Remaining 27 % Used Account: 135-50040-010-000 Unemployment Taxes 548 01/11/2019 MUD Payroll 1/11/2019 Unemployment Taxes 207.29 207.29 PR 615 01/25/2019 MUD Payroll 01/25/19 Unemployment Taxes 216.34 423.63 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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-010-000 Unemployment Taxes Totals: 1,080.00 Budgeted 656.37 Remaining 39 % Used Account: 135-50045-010-000 Workman's Compensation 128 01/01/2019 Insurance/Wrk Comp Expense Jan 2,792.82 Account: 135-50045-010-000 Workman's Compensation Totals: 12,895.00 Budgeted Account: 135-50060-010-000 Pre-emp Physicals/Testing Account: 135-50060-010-000 Account: 135-50070-010-000 Account: 135-50070-010-000 9,171.24 Remaining 29 % Used Pre-emp Physicals/Testing Totals: 200.00 Budgeted 200.00 Remaining Employee Relations Employee Relations Totals: 300.00 Budgeted Account: 135-55005-010-000 Engineering Account: 135-55005-010-000 0 % Used 300.00 Remaining 0 % Used Engineering Totals: 20,000.00 Budgeted Account: 135-55080-010-000 Maintenance & Repairs 610 01/21/2019 January A/P Parts 682 01/28/2019 PCARD 12/27/2018-1/28/2019 airchuck 661 01/31/2019 January A/P repairs 661 01/31/2019 January A/P quickie saw Account: 135-55080-010-000 20,000.00 Remaining 0 % Used Maintenance & Repairs Totals: 100,000.00 Budgeted 423.63 423.63 ** 930.94 3,723.76 GL 930.94 3,723.76 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** 12,967.61 423.32 13,390.93 Core & Main LP 4928 AP 24.98 13,415.91 ROANOKE AUTO SUPPLY LT PC 490.00 13,905.91 DHS AUTOMATION, INC 4959 AP 965.00 14,870.91 Core & Main LP 4956 AP 85,129.09 Remaining 15 % Used Account: 135-55085-010-000 Generator Maint. and Repair 1,903.30 14,870.91 ** glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 602 01/18/2019 January A/P Account: 135-55085-010-000 Account: 135-55090-010-000 682 01/28/2019 PCARD 682 01/28/2019 PCARD 682 01/28/2019 PCARD 682 01/28/2019 PCARD 682 01/28/2019 PCARD Account: 135-55090-010-000 Account: 135-55105-010-000 Account: 135-55105-010-000 Account: 135-55120-010-000 Account: 135-55120-010-000 1 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 1/2019 JE Detail Beginning Balance Description/Comment generator maintenance Generator Maint. and Repair Totals: 3,000.00 Budgeted 1,093.70 Remaining Vehicle 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 Maintenance app for cert of title & renew fee for online .gov veh registration for plate fee for internet renewal diesel exhaust fluid ■ Vehicle Maintenance 5,000.00 Budgeted ■ Account: 135-55135-010-000 661 01/31/2019 January A/P 661 01/31/2019 January A/P Account: 135-55135-010-000 Totals: 4,072.75 Remaining Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 3,500.00 Remaining Cleaning Services Cleaning Services 5,214.00 Budgeted Lab Analysis lab testing lab testing Lab Analysis 6,500.00 Budgeted Totals: 5,214.00 Remaining Totals: 5,124.90 Remaining Account: 135-60010-010-000 Communications/Mobiles 558 01/10/2019 January A/P Cell phones -January Account: 135-60010-010-000 Communications/Mobiles 5,000.00 Budgeted Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 13 Check Source Number 943.00 963.30 1,906.30 Sluder Emergency Power Service 4942 AP 854.18 64 % Used 19 % Used 0 o Used 0 9 Used 963.30 22.00 1.00 16.50 4.00 29.57 73.07 .00 .00 .00 .00 1,906.30 ** 876.18 877.18 893.68 897.68 927.25 DENTON COUNTY, TX SOUT DENTON COUNTY, TX SOUT DENTON VEHREG TX.GOV SERVICEFEE- ROANOKE AUTO SUPPLY LT 927.25 ** .00 .00 ** .00 .00 ** 827.70 317.40 1,145.10 OXIDOR LABORATORIES LLC 230.00 1,375.10 OXIDOR LABORATORIES LLC 21 % Used 1,023.77 Totals: 3,690.44 Remaining 26 % Used 547.40 285.79 285.79 1,375.10 ** 1,309.56 VERIZON WIRELESS 1,309.56 ** PC PC PC PC PC 4977 AP 4977 AP 4925 AP glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 1/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 14 Check Source Number Account: 135-60020-010-000 Electricity 602 01/18/2019 January A/P Electricity 12/7-1/8 26,200.99 15,429.73 41,630.72 HUDSON ENERGY SERVICES, LLC 4935 AP Account: 135-60020-010-000 Electricity Totals: 15,429.73 41,630.72 ** 154,204.00 Budgeted 112,573.28 Remaining 27 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 682 01/28/2019 PCARD 12/27/2018-1/28/2019 school 411.00 280.00 691.00 TARRANT COUNTY COLLEGE PC Account: 135-60080-010-000 Schools & Training Totals: 280.00 691.00 ** 4,651.00 Budgeted 3,960.00 Remaining 15 % Used Account: 135-60090-010-000 ' Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem .00 .00 Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 2,345.00 Budgeted 2,345.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 1/2019 JE Detail Description/Comment Page 15 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 7,685.65 .00 7,685.65 Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 7,685.65 ** 58,000.00 Budgeted Account: 135-60150-010-000 Wholesale Water 661 01/31/2019 January A/P Wholesale water Account: 135-60150-010-000 Account: 135-60245-010-000 Account: 135-60245-010-000 50,314.35 Remaining 13 % Used 254,645.37 126,939.74 381,585.11 CITY OF FORT WORTH 4955 AP Wholesale Water Totals: 126,939.74 381,585.11 ** 3,013,494.00 Budgeted 2,631,908.89 Remaining 13 % Used Miscellaneous Expenses Miscellaneous Expenses Totals: 200.00 Budgeted 200.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-60280-010-000 Property Maintenance .00 .00 Account: 135-60280-010-000 Property Maintenance Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 12,660.00 Remaining Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 716 01/31/2019 TexPool Transfers January TexPool O&M to 16Swift Rev I&S 2,090.00 .00 2,090.00 .00 2,090.00 ** 14 % Used 75,518.43 25,172.81 100,691.24 GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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-60332-010-000 Interfund Transfer Out -Rev I5S Totals: 585,209.00 Budgeted 484,517.76 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve 716 01/31/2019 TexPool Transfers January TexPool O&M to Rev Bond Resevr Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted 36,793.00 Remaining Account: 135-60334-010-000 Interfund Transfer Out Account: 135-60334-010-000 Account: 135-60360-010-000 25,172.81 100,691.24 ** 17 % Used 13,800.00 4,600.00 33 6 Used 4,600.00 18,400.00 GL 18,400.00 ** .00 .00 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining Furniture/Equipment < $5000 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Account: 135-65005-010-000 645 01/24/2019 January Fuel A/P Account: 135-65005-010-000 Fuel & Lube Fuel Fuel & Lube Totals: 15,000.00 Budgeted Account: 135-65010-010-000 Uniforms Account: 135-65010-010-000 0 % Used .00 .00 .00 .00 ** 0 % Used 2,292.90 651.63 2,944.53 US Bank Voyager Fleet Systems 4980 AP 12,055.47 Remaining 20 % Used 1,417.41 651.63 2,944.53 ** .00 1,417.41 Uniforms Totals: .00 1,417.41 ** 5,190.00 Budgeted Account: 135-65030-010-000 Chemicals 602 01/18/2019 January A/P Testing samples 695 01/31/2019 January A/P Chlorine 3,772.59 Remaining 27 % Used 5,575.88 924.51 893.45 6,500.39 HACH COMPANY 4933 AP 7,393.84 DPC INDUSTRIES, INC 4985 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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-65030-010-000 Chemicals Totals: 1,817.96 7,393.84 ** 20,000.00 Budgeted 12,606.16 Remaining 37 % Used Account: 135-65035-010-000 Small Tools .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted Account: 135-65050-010-000 Meter Expense 661 01/31/2019 January A/P meters 661 01/31/2019 January A/P meters 661 01/31/2019 January A/P mag meter well# 4 1,000.00 Remaining 0 % Used 11,305.80 10.80 4,250.00 2,295.00 11,316.60 ATLAS UTILITY SUPPLY CO. 15,566.60 ATLAS UTILITY SUPPLY CO. 17,861.60 ATLAS UTILITY SUPPLY CO. 4953 AP 4953 AP 4953 AP Account: 135-65050-010-000 Meter Expense Totals: 6,555.80 17,861.60 ** 70,000.00 Budgeted Account: 135-65053-010-000 Meter Change Out Program 661 01/31/2019 January A/P meters 52,138.40 Remaining 26 % Used 31,482.00 31,482.00 ATLAS UTILITY SUPPLY CO. 4953 AP Account: 135-65053-010-000 Meter Change Out Program Totals: 31,482.00 31,482.00 ** 87,000.00 Budgeted 55,518.00 Remaining 36 6 Used Account: 135-69005-010-000 Capital Outlays 558 01/10/2019 January A/P Truck decals -2019 Dodge 15000 57,192.60 125.00 57,317.60 M-KAM LTD. 4918 AP 600 01/18/2019 Reclass VFD Star Telegram invo863.40 58,181.00 GL 661 01/31/2019 January A/P Water plant fence 1st draw 45,500.00 103,681.00 Allied Fence Company 4952 AP 661 01/31/2019 January A/P 16" waterline phase II 21,112.83 124,793.83 Halff Associates, INC 4962 AP 662 01/31/2019 January A/P flashers 906.00 125,699.83 Defender Supply 4958 AP 705 01/31/2019 January A/P Fence @ water plant 26,990.00 152,689.83 Alliance Fence Company 5008 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-010-000 Capital Outlays Totals: 95,497.23 152,689.83 ** 453,000.00 Budgeted 300,310.17 Remaining 34 % Used Account: 135-69008-010-000 Short Term Debt -Principal 661 01/31/2019 January A/P Vaccon Interest payment 30,068.00 Account: 135-69008-010-000 Short Term Debt -Principal 30,068.00 Budgeted Account: 135-69009-010-000 Short Term Debt -Interest 661 01/31/2019 January A/P Account: 135-69009-010-000 Totals: .00 Remaining 100 % Used 30,068.00 FIRST FINANCIAL BANK 4960 AP 30,068.00 30,068.00 ** Vaccon Interest payment 2,283.93 Short Term Debt -Interest Totals: 4,124.00 Budgeted 1,840.07 Remaining Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 55 % Used 2,283.93 FIRST FINANCIAL BANK 4960 AP 2,283.93 2,283.93 ** .00 75,000.00 Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining Account: 135-69281-010-000 Water Tank Inspection Contract 695 01/31/2019 January A/P Tank inspections Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 20,122.89 Remaining 100 % Used 57,932.73 41,944.38 83 % Used 99,877.11 UTILITY SERVICE CO, INC. 4996 AP 41,944.38 99,877.11 ** glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 19 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/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 447.70 .00 447.70 Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 447.70 ** 2,000.00 Budgeted 1,552.30 Remaining 22 % Used Department 10 Totals: 1,130,193.79 ** 419,825.64 Monthly Total 5,641,834.00 Budgeted 4,511,640.21 Remaining 20 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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 548 01/11/2019 MUD Payroll 1/11/2019 Salaries & Wages 615 01/25/2019 MUD Payroll 01/25/19 Salaries & Wages Account: 135-50005-020-000 Account: 135-50010-020-000 78,638.45 13,044.14 91,682.59 PR 13,074.90 104,757.49 PR Salaries & Wages Totals: 26,119.04 104,757.49 ** 421,699.00 Budgeted 316,941.51 Remaining 25 % Used 548 01/11/2019 MUD Payroll 1/11/2019 Overtime 8,443.79 1,911.50 615 01/25/2019 MUD Payroll 01/25/19 Overtime 856.43 Account: 135-50010-020-000 Overtime Totals: 2,767.93 30,000.00 Budgeted 18,788.28 Remaining 37 % Used Account: 135-50016-020-000 gev.ty Account: 135-50016-020-000 Longevity Totals: 7,445.00 Budgeted .00 Remaining Account: 135-50017-020-000 Certification 615 01/25/2019 MUD Payroll 01/25/19 Certification Account: 135-50017-020-000 Certification 8,700.00 Budgeted Account: 135-50020-020-000 Retirement 548 01/11/2019 MUD Payroll 1/11/2019 Retirement 615 01/25/2019 MUD Payroll 01/25/19 Retirement 7,445.00 .00 10,355.29 11,211.72 PR PR 11,211.72 ** 7,445.00 .00 100 % Used 2,050.00 650.00 2,700.00 PR Totals: 6,000.00 Remaining 31 % Used 10,450.09 650.00 2,700.00 ** 1,383.41 11,833.50 1,348.77 13,182.27 PR PR Account: 135-50020-020-000 Retirement Totals: 2,732.18 13,182.27 ** 43,276.00 Budgeted Account: 135-50026-020-000 Medical Insurance 548 01/11/2019 MUD Payroll 1/11/2019 Medical Insurance 615 01/25/2019 MUD Payroll 01/25/19 Medical Insurance Account: 135-50026-020-000 30,093.73 Remaining 30 % Used Medical Insurance Totals: 91,627.00 Budgeted 15,940.98 70,097.54 Remaining 23 % Used 2,794.26 18,735.24 2,794.22 21,529.46 5,588.48 21,529.46 ** PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 548 01/11/2019 MUD Payroll 1/11/2019 Dental Insurance 615 01/25/2019 MUD Payroll 01/25/19 Dental Insurance Account: 135-50027-020-000 Dental Insurance Totals: 5,104.00 Budgeted Account: 135-50028-020-000 Vision Insurance 548 01/11/2019 MUD Payroll 1/11/2019 Vision Insurance 615 01/25/2019 MUD Payroll 01/25/19 Vision Insurance Account: 135-50028-020-000 3,647.77 Remaining Vision Insurance Totals: 826.00 Budgeted Account: 135-50029-020-000 — Life Insurance & Other 661 01/31/2019 January A/P Caf 125 1,115.67 29 % Used 176.70 593.66 Remaining 28 % Used 170.29 170.27 1,285.96 1,456.23 340.56 1,456.23 ** 27.83 204.53 27.81 232.34 55.64 232.34 ** 1,006.71 38.00 PR PR PR PR 1,044.71 BenefitMall 4954 AP Account: 135-50029-020-000 Life Insurance & Other Totals: 38.00 1,044.71 ** 4,495.00 Budgeted 3,450.29 Remaining 23 % Used Account: 135-50030-020-000 Social Security Taxes 548 01/11/2019 MUD Payroll 1/11/2019 Social Security Taxes 615 01/25/2019 MUD Payroll 01/25/19 Social Security Taxes 5,596.07 889.70 6,485.77 PR 836.11 7,321.88 PR Account: 135-50030-020-000 Social Security Taxes Totals: 1,725.81 7,321.88 ** 29,006.00 Budgeted Account: 135-50035-020-000 Medicare Taxes 548 01/11/2019 MUD Payroll 1/11/2019 Medicare Taxes 615 01/25/2019 MUD Payroll 01/25/19 Medicare Taxes 21,684.12 Remaining 25 % Used 1,308.76 208.08 1,516.84 PR 195.55 1,712.39 PR Account: 135-50035-020-000 Medicare Taxes Totals: 403.63 1,712.39 ** 6,784.00 Budgeted 5,071.61 Remaining 25 % Used Account: 135-50040-020-000 Unemployment Taxes 548 01/11/2019 MUD Payroll 1/11/2019 Unemployment Taxes 269.20 269.20 PR 615 01/25/2019 MUD Payroll 01/25/19 Unemployment Taxes 262.47 531.67 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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 728.33 Remaining 42 % Used Account: 135-50045-020-000 Workman's Compensation 128 01/01/2019 Insurance/Wrk Comp Expense Jan 3,617.19 Account: 135-50045-020-000 Workman's Compensation Totals: 16,941.00 Budgeted 12,118.08 Remaining Account: 135-50060-020-000 Pre-emp Physicals/Testing Account: 135-50060-020-000 Account: 135-50070-020-000 Account: 135-50070-020-000 Pre-emp Physicals/Testing Totals: 400.00 Budgeted 362.00 Remaining Employee Relations Employee Relations Totals: 300.00 Budgeted Account: 135-55005-020-000 Engineering Account: 135-55005-020-000 Account: 135-55070-020-000 695 01/31/2019 January A/P Account: 135-55070-020-000 38.00 28 % Used 10 % Used 300.00 Remaining 0 % Used Engineering Totals: 30,000.00 Budgeted Independent Labor Calibration Independent Labor 15,000.00 Budgeted 30,000.00 Remaining 0 % Used Totals: 14,109.00 Remaining 6 % Used Account: 135-55080-020-000 Maintenance & Repairs 602 01/18/2019 January A/P wire up WAS pump on MBR 92 602 01/18/2019 January A/P bushings 20,393.08 531.67 531.67 ** 1,205.73 1,205.73 .00 .00 4,822.92 4,822.92 ** 38.00 38.00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** GL 891.00 891.00 Prime Controls, LP 4994 AP 891.00 891.00 ** 1 645.00 21,038.08 DHS AUTOMATION, INC 79.99 21,118.07 Alfa Laval, Inc 4930 AP 4926 AP glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE Number 682 682 682 682 682 682 682 661 661 JE Date 01/28/2019 01/28/2019 01/28/2019 01/28/2019 01/28/2019 01/28/2019 01/28/2019 01/31/2019 01/31/2019 JE Description PCARD PCARD PCARD PCARD PCARD PCARD 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 PCARD 12/27/2018-1/28/2019 January A/P January A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 1/2019 JE Detail Beginning Balance Description/Comment hoses rope, carb medic, carb choke pipe fitting pipe fitting, ball valve filters for blowers lock tight for pump station pvc repairs Bushings 20,393.08 Program: Transaction Detail 209.57 14.77 8.28 95.79 347.94 24.99 94.24 490.00 132.01 Transaction Vendor_Name Detail (SUBTOTAL) 21,327.64 21,342.41 21,350.69 21,446.48 21,794.42 21,819.41 21,913.65 22,403.65 22,535.66 INT*IN *HOSE TECH USA ROANOKE AUTO SUPPLY LT AMZN MKTP US*MB5AE9121 AMAZON.COM*MB44K4FY2 FILTER ELEMENT STORE ROANOKE AUTO SUPPLY LT FERGUSON ENT 1241 DHS AUTOMATION, INC Alfa Laval, Inc Page 23 Check Source Number PC PC PC PC PC PC PC 4959 AP 4951 AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 2,142.58 22,535.66 ** 88,000.00 Budgeted 65,464.34 Remaining 26 % Used Account: 135-55085-020-000 Generator Maint. and Repair 602 01/18/2019 January A/P 602 01/18/2019 January A/P 682 01/28/2019 PCARD 12/27/2018-1/28/2019 695 01/31/2019 January A/P generator repair LS 91 battery charge replacement rain cap supplies 623.50 2,440.02 1,050.00 10.99 176.31 3,063.52 4,113.52 4,124.51 4,300.82 DHS AUTOMATION, INC Sluder Emergency Power Service TRACTOR SUPPLY COMPANY LUBRICATION ENGINEERS, INC 4930 AP 4942 AP PC 4992 AP Account: 135-55085-020-000 Generator Maint. and Repair Totals: 3,677.32 4,300.82 ** 10,000.00 Budgeted 5,699.18 Remaining 43 o Used Account: 135-55090-020-000 Vehicle Maintenance 682 01/28/2019 PCARD 12/27/2018-1/28/2019 coupling 156.20 27.47 183.67 ROANOKE AUTO SUPPLY LT PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 27.47 183.67 ** 8,000.00 Budgeted 7,816.33 Remaining 2 8 Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 558 01/10/2019 January A/P 682 01/28/2019 PCARD 12/27/2018-1/28/2019 682 01/28/2019 PCARD 12/27/2018-1/28/2019 682 01/28/2019 PCARD 12/27/2018-1/28/2019 682 01/28/2019 PCARD 12/27/2018-1/28/2019 Backhoe maintenance mini excavator battery duplicate refund oil filter, air filter duplicate oil filter, air Tilt 27.77 1,261.54 133.99 (109.98) 109.98 109.98 1,289.31 1,423.30 1,313.32 1,423.30 1,533.28 RDO Equipment Co ROANOKE AUTO SUPPLY LT ROANOKE AUTO SUPPLY LT ROANOKE AUTO SUPPLY LT ROANOKE AUTO SUPPLY LT 4922 AP PC PC PC PC Account: 135-55105-020-000 1 Maintenance-Backhoe/SkidLoader Totals: 1,505.51 1,533.28 ** 1,500.00 Budgeted (33.28) Remaining 102 % Used Account: 135-55120-020-000 Cleaning Services glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 1/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Page 24 Check Source Number 504 01/03/2019 January A/P 504 01/03/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 661 01/31/2019 January A/P 661 01/31/2019 January A/P 661 01/31/2019 January A/P 661 01/31/2019 January A/P 661 01/31/2019 January A/P 695 01/31/2019 January A/P 695 01/31/2019 January A/P Lab testing lab testing testing supplies lab testing lab testing soil and effluent testing lab testing lab testing testing supplies testing supplies testing supplies effluent testing effluent testing chemicals bio monitoring 10,775.57 246.00 176.00 132.25 317.40 230.00 1,053.98 317.40 230.00 416.62 105.45 54.15 317.40 230.00 644.02 1,080.00 11,021.57 OXIDOR LABORATORIES LLC 11,197.57 OXIDOR LABORATORIES LLC 11,329.82 HACH COMPANY 11,647.22 OXIDOR LABORATORIES LLC 11,877.22 OXIDOR LABORATORIES LLC 12,931.20 OXIDOR LABORATORIES LLC 13,248.60 OXIDOR LABORATORIES LLC 13,478.60 OXIDOR LABORATORIES LLC 13,895.22 HACH COMPANY 14,000.67 HACH COMPANY 14,054.82 HACH COMPANY 14,372.22 OXIDOR LABORATORIES LLC 14,602.22 OXIDOR LABORATORIES LLC 15,246.24 HACH COMPANY 16,326.24 HUTHER AND ASSOCIATES,INC 4894 AP 4894 AP 4933 AP 4940 AP 4940 AP 4940 AP 4940 AP 4940 AP 4963 AP 4963 AP 4963 AP 4977 AP 4977 AP 4988 AP 4989 AP Account: 135-55135-020-000 Lab Analysis Totals: 5,550.67 16,326.24 ** 35,000.00 Budgeted 18,673.76 Remaining 47 % Account: 135-55120-020-000 Cleaning Services Totals: Account: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used 369.40 1,492.06 VERIZON WIRELESS 4925 AP Account: 135-60010-020-000 Account: 135-55125-020-000 Dumpster Services 1,492.06 ** 5,000.00 Budgeted 3,507.94 Remaining 30 5 Used 661 01/31/2019 661 01/31/2019 695 01/31/2019 January A/P January A/P January A/P sludge haul off sludge haul off Sludge haul off Account: 21,590.18 Electricity 874.58 1,690.00 845.00 22,464.76 24,154.76 24,999.76 L.H. L.H. L.H. CHANEY MATERIALS, CHANEY MATERIALS, CHANEY MATERIALS, INC. INC. INC. 4970 4970 4991 AP AP AP Account: 135-55125-020-000 Dumpster Services Totals: 3,409.58 24,999.76 ** 75,000.00 Budgeted 50,000.24 Remaining 33 % Used Account: 135-55135-020-000 Lab Analysis 504 01/03/2019 January A/P 504 01/03/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 602 01/18/2019 January A/P 661 01/31/2019 January A/P 661 01/31/2019 January A/P 661 01/31/2019 January A/P 661 01/31/2019 January A/P 661 01/31/2019 January A/P 695 01/31/2019 January A/P 695 01/31/2019 January A/P Lab testing lab testing testing supplies lab testing lab testing soil and effluent testing lab testing lab testing testing supplies testing supplies testing supplies effluent testing effluent testing chemicals bio monitoring 10,775.57 246.00 176.00 132.25 317.40 230.00 1,053.98 317.40 230.00 416.62 105.45 54.15 317.40 230.00 644.02 1,080.00 11,021.57 OXIDOR LABORATORIES LLC 11,197.57 OXIDOR LABORATORIES LLC 11,329.82 HACH COMPANY 11,647.22 OXIDOR LABORATORIES LLC 11,877.22 OXIDOR LABORATORIES LLC 12,931.20 OXIDOR LABORATORIES LLC 13,248.60 OXIDOR LABORATORIES LLC 13,478.60 OXIDOR LABORATORIES LLC 13,895.22 HACH COMPANY 14,000.67 HACH COMPANY 14,054.82 HACH COMPANY 14,372.22 OXIDOR LABORATORIES LLC 14,602.22 OXIDOR LABORATORIES LLC 15,246.24 HACH COMPANY 16,326.24 HUTHER AND ASSOCIATES,INC 4894 AP 4894 AP 4933 AP 4940 AP 4940 AP 4940 AP 4940 AP 4940 AP 4963 AP 4963 AP 4963 AP 4977 AP 4977 AP 4988 AP 4989 AP Account: 135-55135-020-000 Lab Analysis Totals: 5,550.67 16,326.24 ** 35,000.00 Budgeted 18,673.76 Remaining 47 % Used Account: 135-60010-020-000 Communications/Mobiles 558 01/10/2019 January A/P Cell phones -January 1,122.66 369.40 1,492.06 VERIZON WIRELESS 4925 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 369.40 1,492.06 ** 5,000.00 Budgeted 3,507.94 Remaining 30 5 Used Account: 135-60020-020-000 Electricity glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 602 01/18/2019 January A/P Electricity 11/27-12/27 602 01/18/2019 January A/P Electricity 11/27-12/27 602 01/18/2019 January A/P Electricity 11/27-12/27 602 01/18/2019 January A/P Electricity 12/7-1/8 746 01/31/2019 Town Bllled Invoices 1672-1675 AR 20190131-20190131 User: 37,730.40 156.39 37,886.79 TRI COUNTY ELECTRIC 4947 AP 242.80 38,129.59 TRI COUNTY ELECTRIC 4947 AP 27.83 38,157.42 TRI COUNTY ELECTRIC 4947 AP 26,362.38 64,519.80 HUDSON ENERGY SERVICES, LLC 4935 AP (440.71) 64,079.09 AR Account: 135-60020-020-000 Electricity Totals: 26,348.69 64,079.09 ** 174,165.00 Budgeted 110,085.91 Remaining 37 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 6 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 682 01/28/2019 PCARD 12/27/2018-1/28/2019 Wtr Safety Course DeWayne&Jeff 111.00 630.00 741.00 TRWA PC Account: 135-60080-020-000 Schools & Training Totals: 630.00 741.00 ** 7,155.00 Budgeted Account: 135-60090-020-000 Safety Program 661 01/31/2019 January A/P safety suuplies 6,414.00 Remaining 10 % Used 100.74 100.74 Ritz Safety, LLC 4978 AP Account: 135-60090-020-000 Safety Program Totals: 100.74 100.74 ** 1,000.00 Budgeted 899.26 Remaining 10 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,895.00 Budgeted 1,895.00 Remaining 0 o Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 Account: 135-60125-020-000 Account: 135-60125-020-000 Account: 135-60135-020-000 Account: 135-60135-020-000 Account: 135-60245-020-000 Rent/Lease Equipment Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Advertising Advertising Totals: 2,500.00 Budgeted TCEQ Fees & Permits TCEQ Fees & Permits 30,000.00 Budgeted Miscellaneous Expenses 2,500.00 Remaining 16,545.22 0 % Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 16,545.22 Totals: 13,454.78 Remaining 55 % Used .00 16,545.22 ** .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** Account: 135-60280-020-000 Account: 135-60280-020-000 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 450.00 Remaining 225.18 0 % Used Totals: 4,774.82 Remaining 5 % Used .00 225.18 .00 225.18 ** Account: 135-60285-020-000 Lawn Equipment & Maintenance 682 01/28/2019 PCARD 12/27/2018-1/28/2019 battery 590.00 57.84 647.84 ROANOKE AUTO SUPPLY LT Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 11,600.00 Budgeted 10,952.16 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax ISS PC 57.84 647.84 ** 6 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 716 01/31/2019 TexPool Transfers January TexPool O&M to I&S- PID Debt 32,741.70 10,913.90 43,655.60 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,913.90 43,655.60 ** 120,053.00 Budgeted 76,397.40 Remaining 36 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 716 01/31/2019 TexPool Transfers January TexPool O&M to Rev Bd WWTP I&S 162,610.35 54,203.45 216,813.80 GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 54,203.45 216,813.80 ** 688,330.00 Budgeted 471,516.20 Remaining 31 9 Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 716 01/31/2019 TexPool Transfers January TexPool O&M to Rev Bond Resevr 31,296.00 10,432.00 41,728.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 10,432.00 41,728.00 ** 125,187.00 Budgeted 83,459.00 Remaining 33 % Used Account: 135-60334-020-000 Interfund Transfer Out ' .00 .00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 6 Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 645 01/24/2019 January Fuel A/P Fuel 3,382.96 515.97 3,898.93 US Bank Voyager Fleet Systems 4980 AP 682 01/28/2019 PCARD 12/27/2018-1/28/2019 diesel add for crane & BackHoe 33.98 3,932.91 ROANOKE AUTO SUPPLY LT PC 682 01/28/2019 PCARD 12/27/2018-1/28/2019 funnels 20.98 3,953.89 TRACTOR SUPPLY COMPANY PC Account: 135-65005-020-000 Fuel & Lube Totals: 570.93 3,953.89 ** 12,500.00 Budgeted 8,546.11 Remaining 32 % Used Account: 135-65010-020-000 _ Uniforms glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 682 01/28/2019 PCARD 12/27/2018-1/28/2019 682 01/28/2019 PCARD 12/27/2018-1/28/2019 682 01/28/2019 PCARD 12/27/2018-1/28/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 1/2019 JE Detail Beginning Balance Description/Comment uniforms -duplicate refund pants pants, duplicate Account: 135-65010-020-000 Uniforms 5,495.00 Budgeted Account: 135-65030-020-000 504 01/03/2019 January A/P 682 01/28/2019 PCARD 12/27/2018-1/28/2019 661 01/31/2019 January A/P Totals: 3,435.10 Remaining Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 1,978.73 (81.17) 1,897.56 #02 DICKIES OUTLET FW 81.17 1,978.73 #02 DICKIES OUTLET FW 81.17 2,059.90 #02 DICKIES OUTLET FW Page 28 Check Source Number PC PC PC 81.17 2,059.90 ** 37 % Used Chemicals chemicals rodent traps, sprays, hawk chu Chemicals Account: 135-65030-020-000 Chemicals 30,000.00 Budgeted Account: 135-65035-020-000 Small Tools 682 01/28/2019 PCARD 12/27/2018-1/28/2019 wire, snips Account: 135-65035-020-000 Small Tools 1,200.00 Budgeted Account: 135-65040-020-000 Safety Equipment 661 01/31/2019 January A/P Mats Account: 135-65040-020-000 Safety Equipment 1,200.00 Budgeted Totals: 27,246.22 Remaining Totals: 1,145.05 Remaining Totals: 356.45 Remaining 1,591.82 536.00 2,127.82 Valley Solvent Company, INC 89.96 2,217.78 TRACTOR SUPPLY COMPANY 536.00 2,753.78 Valley Solvent Company, INC 4906 AP PC 4981 AP 1,161.96 2,753.78 ** 9 % Used 14.97 39.98 54.95 TRACTOR SUPPLY COMPANY 552.18 5 % Used 70 % Used 39.98 291.37 291.37 54.95 ** 843.55 Ritz Safety, LLC 843.55 ** PC 4978 AP Account: 135-65045-020-000 Lab Supplies 558 01/10/2019 558 01/10/2019 602 01/18/2019 682 01/28/2019 661 01/31/2019 695 01/31/2019 Account: 135-65045-020-000 January A/P January A/P January A/P PCARD 12/27/2018-1/28/2019 January A/P January A/P Gloves Lab supplies oven thermometer distilled water Thermometer parts retune Lab Supplies 20,000.00 Budgeted Totals: 16,861.36 Remaining 2,460.23 152.00 2,612.23 LOU'S GLOVES INCORPORATED 4917 AP 153.13 2,765.36 HD SUPPLY FACILITIES MAINT LTD 4914 AP 115.41 2,880.77 HD SUPPLY FACILITIES MAINT LTD 4934 AP 1.98 2,882.75 TOM THUMB #1789 PC 320.84 3,203.59 HD SUPPLY WATERWORKS, LTD. 4964 AP (64.95) 3,138.64 HD SUPPLY FACILITIES MAINT LTD AP 16 % Used 678.41 3,138.64 ** Account: 135-69005-020-000 Capital Outlays glpdatb2 skrolczyk Trophy Club MUD No.1 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 29 600 01/18/2019 Reclass VFD Star Telegram Invo 602 01/18/2019 January A/P WWTP legal 661 01/31/2019 January A/P WWTP water system 756 01/31/2019 Escrow Vaccon Int & Cap Purchs Freightliner of Austin Purch 44,200.32 (863.40) 807.50 3,135.99 358,600.40 43,336.92 44,144.42 Dubois Bryant Campbell LLP 47,280.41 Halff Associates, INC 405,880.81 GL 4932 AP 4962 AP GL Account: 135-69005-020-000 Capital Outlays Totals: 361,680.49 405,880.81 ** 330,000.00 Budgeted (75,880.81) Remaining 123 % Used Account: 135-69008-020-000 Short Term Debt -Principal 661 01/31/2019 January A/P Vaccon Interest payment 39,858.59 39,858.59 FIRST FINANCIAL BANK 4960 AP Account: 135-69008-020-000 Short Term Debt -Principal Totals: 39,858.59 39,858.59 ** 109,858.00 Budgeted 69,999.41 Remaining 36 % Used Account: 135-69009-020-000 Short Term Debt -Interest 661 01/31/2019 January A/P Vaccon Interest payment 3,027.55 3,027.55 FIRST FINANCIAL BANK 4960 AP Account: 135-69009-020-000 Short Term Debt -Interest Totals: 3,027.55 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 558 01/10/2019 January A/P Fee for camera van lease 1,500.00 1,500.00 Government Capital Corporation 4913 AP Account: 135-70020-020-000 Capital Lease Issuance Cost Totals: 1,500.00 1,500.00 ** Department 20 Totals: .00 Budgeted 571,309.27 Monthly Total (1,500.00) Remaining 0 % Used 1,127,925.70 ** 2,872,082.00 Budgeted 1,744,156.30 Remaining 39 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/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 128 01/01/2019 Insurance/Wrk Comp Expense Jan Account: 135-50045-026-000 Workman's Compensation Totals: Account: 135-60066-026-000 Account: 135-60066-026-000 30.00 Budgeted Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 6.36 2.12 8.48 GL 21.52 Remaining 28 % Used 2.12 8.48 ** .00 0 % Used .00 .00 .00 ** Account: 135-60070-026-000 Dues & Memberships Dues & Memberships 750.00 Budgeted Account: 135-60070-026-000 650.00 .00 650.00 Totals: 100.00 Remaining 87 % Used .00 650.00 ** Account: 135-60075-026-000 Meetings Account: 135-60075-026-000 Meetings 1,300.00 Budgeted Totals: 1,300.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-60080-026-000 Schools & Training 565.00 .00 565.00 Account: 135-60080-026-000 Schools & Training Totals: .00 565.00 ** 4,000.00 Budgeted 3,435.00 Remaining 14 % Used Account: 135-60100-026-000 Travel & per diem 661 01/31/2019 January A/P AWBD conference -B111 Rose 338.57 338.57 William Rose 4982 AP Account: 135-60100-026-000 Travel & per diem Totals: 338.57 338.57 ** 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 4,661.43 Remaining 7 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/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,562.05 ** 340.69 Monthly Total 13,230.00 Budgeted 11,667.95 Remaining 12 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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 548 01/11/2019 MUD Payroll 1/11/2019 Salaries & Wages 615 01/25/2019 MUD Payroll 01/25/19 Salaries & Wages 84,078.53 14,158.53 98,237.06 PR 14,136.08 112,373.14 PR Account: 135-50005-030-000 Salaries & Wages Totals: 28,294.61 112,373.14 ** 441,006.00 Budgeted 328,632.86 Remaining 25 % Used Account: 135-50010-030-000 Overtime 10.45 .00 10.45 Account: 135-50010-030-000 Overtime Totals: .00 10.45 ** 2,000.00 Budgeted 1,989.55 Remaining 1 % Used Account: 135-50016-030-000 Longevity 1,832.50 Account: 135-50016-030-000 Longevity Totals: 1,833.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 548 01/11/2019 MUD Payroll 1/11/2019 Retirement 615 01/25/2019 MUD Payroll 01/25/19 Retirement Account: 135-50020-030-000 .00 1,832.50 1,832.50 ** 9,307.94 1,309.66 10,617.60 PR 1,307.60 11,925.20 PR 11111 Retirement Totals: 2,617.26 11,925.20 ** 41,148.00 Budgeted 29,222.80 Remaining 29 % Used Account: 135-50026-030-000 Medical Insurance 548 01/11/2019 MUD Payroll 1/11/2019 Medical Insurance 615 01/25/2019 MUD Payroll 01/25/19 Medical Insurance 12,435.72 2,412.24 14,847.96 PR 2,412.18 17,260.14 PR Account: 135-50026-030-000 Medical Insurance Totals: 4,824.42 17,260.14 ** 81,895.00 Budgeted Account: 135-50027-030-000 Dental Insurance 548 01/11/2019 MUD Payroll 1/11/2019 Dental Insurance 615 01/25/2019 MUD Payroll 01/25/19 Dental Insurance 64,634.86 Remaining 21 % Used 778.56 129.78 908.34 PR 129.74 1,038.08 PR Account: 135-50027-030-000 Dental Insurance Totals: 259.52 1,038.08 ** 4,291.00 Budgeted 3,252.92 Remaining 24 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-030-000 Vision Insurance 548 01/11/2019 MUD Payroll 1/11/2019 Vision Insurance 615 01/25/2019 MUD Payroll 01/25/19 Vision Insurance Account: 135-50028-030-000 127.53 21.28 148.81 PR 21.23 170.04 PR Vision Insurance Totals: 42.51 170.04 ** 701.00 Budgeted Account: 135-50029-030-000 Life Insurance & Other 661 01/31/2019 January A/P Caf 125 Account: 135-50029-030-000 Account: 135-50030-030-000 - 548 01/11/2019 MUD Payroll 1/11/2019 615 01/25/2019 MUD Payroll 01/25/19 Account: 135-50030-030-000 530.96 Remaining 24 % Used Life Insurance & Other Totals: 4,495.00 Budgeted 1,135.62 19.00 3,340.38 Remaining 26 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Totals: 27,580.00 Budgeted Account: 135-50035-030-000 Medicare Taxes 548 01/11/2019 MUD Payroll 1/11/2019 Medicare Taxes 615 01/25/2019 MUD Payroll 01/25/19 Medicare Taxes Account: 135-50035-030-000 5,129.14 20,780.21 Remaining 25 % Used Medicare Taxes Totals: 6,450.00 Budgeted Account: 135-50040-030-000 Unemployment Taxes 548 01/11/2019 MUD Payroll 1/11/2019 Unemployment Taxes 615 01/25/2019 MUD Payroll 01/25/19 Unemployment Taxes Account: 135-50040-030-000 1,199.56 4,859.73 Remaining 25 % Used Unemployment Taxes Totals: 1,260.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 128 01/01/2019 Insurance/Wrk Comp Expense Jan Account: 135-50045-030-000 750.69 Remaining 40 % Used 1,154.62 BenefitMall 4954 AP 19.00 1,154.62 ** 837.49 5,966.63 833.16 6,799.79 1,670.65 6,799.79 ** 195.86 194.85 390.71 1,395.42 1,590.27 1,590.27 ** 254.86 254.86 254.45 509.31 509.31 509.31 ** 319.65 106.55 PR PR PR PR PR PR 426.20 GL Workman's Compensation Totals: 106.55 426.20 ** 1,295.00 Budgeted 868.80 Remaining 33 % Used glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-50060-030-000 695 01/31/2019 January A/P Account: 135-50060-030-000 1 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 1/2019 JE Detail Beginning Balance Description/Comment Pre-emp Physicals/Testing New employment check -Glenda Pre-emp Physicals/Testing Totals: 500.00 Budgeted 396.05 Remaining Account: 135-50070-030-000 Employee Relations 682 01/28/2019 PCARD 12/27/2018-1/28/2019 safety meeting breakfast 682 01/28/2019 PCARD 12/27/2018-1/28/2019 safety meeting breakfast Account: 135-50070-030-000 Account: 135-55030-030-000 Employee Relations 5,000.00 Budgeted ■ Software & Support 558 01/10/2019 January A/P Annual software lease 2019 558 01/10/2019 January A/P Internet -January 602 01/18/2019 January A/P signature change A/P 602 01/18/2019 January A/P Microsoft exchange 682 01/28/2019 PCARD 12/27/2018-1/28/2019 110.13 682 01/28/2019 PCARD 12/27/2018-1/28/2019 internet 682 01/28/2019 PCARD 12/27/2018-1/28/2019 internet 682 01/28/2019 PCARD 12/27/2018-1/28/2019 internet 682 01/28/2019 PCARD 12/27/2018-1/28/2019 adobe 21 6 Used 2,820.05 Totals: ' 2,116.77 Remaining 58 % Used Account: 135-55030-030-000 Account: 135-55070-030-000 695 01/31/2019 January A/P 695 01/31/2019 January A/P Account: 135-55070-030-000 Account: 135-55080-030-000 Account: 135-55080-030-000 Software & Support 77,849.00 Budgeted Independent Labor GM January GM January Independent Labor 175,000.00 Budgeted Maintenance & Repairs Totals: 41,067.32 Remaining Totals: 126,589.38 Remaining Maintenance & Repairs Totals: 20,000.00 Budgeted 19,205.00 Remaining 18,120.59 47 % Used Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 34 Check Source Number 103.95 103.95 FIRST CHECK APPLICANT SCREENIN 4987 AP 103.95 51.70 11.48 63.18 103.95 ** 2,871.75 SALAD BOWL 10 2,883.23 KROGER 60516 2,883.23 ** 111 16,800.00 34,920.59 903.72 35,824.31 72.50 35,896.81 504.00 36,400.81 110.13 36,510.94 127.15 36,638.09 69.12 36,707.21 42.02 36,749.23 32.45 36,781.68 18,661.09 STW INC Charter Communications STW INC M3 Networks ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS 36,781.68 ** 35,178.89 111.73 35,290.62 Carman Consulting LLC. 795.00 28 % Used 13,120.00 13,231.73 .00 4 o Used .00 48,410.62 Carman Consulting LLC. 48,410.62 ** 795.00 795.00 ** PC PC 4923 AP 4910 AP 4943 AP 4938 AP PC PC PC PC PC 4983 AP 4983 AP glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 1/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 35 Check Source Number 504 01/03/2019 682 01/28/2019 682 01/28/2019 682 01/28/2019 682 01/28/2019 746 01/31/2019 January A/P PCARD 12/27/2018-1/28/2019 PCARD 12/27/2018-1/28/2019 PCARD 12/27/2018-1/28/2019 PCARD 12/27/2018-1/28/2019 Town Billed Invoices 1672-1675 Answering service phone phone Phone fax 750 AR 20190131-20190131 User: 4,498.96 207.75 862.49 461.43 163.20 14.99 (180.00) 4,706.71 5,569.20 6,030.63 6,193.83 6,208.82 6,028.82 KEYSTONE PARK SECRETARIAL ATT*BUS PHONE PMT ATT*BUS PHONE PMT ATT*BILL PAYMENT RINGCENTRAL, INC 4884 AP PC PC PC PC AR Account: 135-60005-030-000 Telephone Totals: 1,529.86 6,028.82 ** 23,500.00 Budgeted 17,471.18 Remaining 26 o Used Account: 135-60010-030-000 Communications/Mobiles 558 01/10/2019 January A/P Cell phones -January 615 01/25/2019 MUD Payroll 01/25/19 Communications/Mobiles 712.47 87.55 150.00 800.02 VERIZON WIRELESS 950.02 4925 AP PR Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 661 01/31/2019 January A/P Janitorial service -December 1,738.12 869.06 2,607.18 MEMBER'S BUILDING MAINTENANCE 4974 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 2,607.18 ** 10,000.00 Budgeted 7,392.82 Remaining 26 % Used Account: 135-55160-030-000 Professional Outside Services 59,205.00 .00 59,205.00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 59,205.00 ** 66,055.00 Budgeted 6,850.00 Remaining 90 % Used Account: 135-55205-030-000 Utility Billing Contract 695 01/31/2019 January A/P January Billings 1,742.39 579.59 2,321.98 DATAPROSE LLC 4984 AP Account: 135-55205-030-000 Utility Billing Contract Totals: 579.59 2,321.98 ** 9,000.00 Budgeted 6,678.02 Remaining 26 % Used Account: 135-60005-030-000 Telephone 504 01/03/2019 682 01/28/2019 682 01/28/2019 682 01/28/2019 682 01/28/2019 746 01/31/2019 January A/P PCARD 12/27/2018-1/28/2019 PCARD 12/27/2018-1/28/2019 PCARD 12/27/2018-1/28/2019 PCARD 12/27/2018-1/28/2019 Town Billed Invoices 1672-1675 Answering service phone phone Phone fax 750 AR 20190131-20190131 User: 4,498.96 207.75 862.49 461.43 163.20 14.99 (180.00) 4,706.71 5,569.20 6,030.63 6,193.83 6,208.82 6,028.82 KEYSTONE PARK SECRETARIAL ATT*BUS PHONE PMT ATT*BUS PHONE PMT ATT*BILL PAYMENT RINGCENTRAL, INC 4884 AP PC PC PC PC AR Account: 135-60005-030-000 Telephone Totals: 1,529.86 6,028.82 ** 23,500.00 Budgeted 17,471.18 Remaining 26 o Used Account: 135-60010-030-000 Communications/Mobiles 558 01/10/2019 January A/P Cell phones -January 615 01/25/2019 MUD Payroll 01/25/19 Communications/Mobiles 712.47 87.55 150.00 800.02 VERIZON WIRELESS 950.02 4925 AP PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-030-000 Communications/Mobiles Totals: 4,000.00 Budgeted Account: 135-60020-030-000 Electricity/Gas 599 01/18/2019 January A/P Account: 135-60020-030-000 3,049.98 Remaining 24 % Used Electricity admin 10/10-11/08, 557.71 Electricity/Gas Totals: 8,690.00 Budgeted 7,199.89 Remaining 17 6 Used Account: 135-60025-030-000 Water 695 01/31/2019 January A/P Water -January 746 01/31/2019 Town Bllled Invoices 1672-1675 AR 20190131-20190131 User: Account: 135-60025-030-000 237.55 950.02 ** 932.40 1,490.11 TOWN OF TROPHY CLUB 4946 AP 932.40 1,490.11 ** 161.26 107.71 268.97 TROPHY CLUB MUD (WATER BILLS) 4995 AP (53.85) 215.12 Water Totals: 53.86 , 215.12 ** 2,000.00 Budgeted Account: 135-60035-030-000 Postage 661 01/31/2019 January A/P Postage lease 695 01/31/2019 January A/P January Billings Account: 135-60035-030-000 Account: 135-60040-030-000 551 01/11/2019 Child Support Fee 616 01/25/2019 Child Support Fee 695 01/31/2019 January A/P 643 01/31/2019 Pace Credit Card Fees 643 01/31/2019 Pace Credit Card Fees Postage 30,000.00 Budgeted Service Charges & Fees Direct send fees' 1,784.88 Remaining 11 % Used 4,964.37 100.91 5,065.28 FRANCOTYP-POSTALIA, INC. 23,324.70 Remaining Account: 135-60040-030-000 Service Charges & Fees 55,560.00 Budgeted 32,536.22 Remaining Account: 135-60050-030-000 Bad Debt Expense Account: 135-60050-030-000 Bad Debt Expense Totals: 1,500.00 Budgeted 22 6 Used AR 4961 AP 1,610.02 6,675.30 DATAPROSE LLC 4984 AP 1,710.93 6,675.30 ** 1 1- 18,154.53 1.50 18,156.03 GL 1.50 18,157.53 GL 50.00 18,207.53 Fisery Solutions, LLC 4986 AP 4,707.22 22,914.75 GL 109.03 23,023.78 GL 41 % Used 1 1,500.00 Remaining 0 % Used 4,869.25 23,023.78 ** .00 .00 .00 .00 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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 128 01/01/2019 Insurance/Wrk Comp Expense Jan Account: 135-60055-030-000 Insurance 65,000.00 Budgeted 18,908.19 6,302.73 Totals: 39,789.08 Remaining 39 % Used 6,302.73 25,210.92 GL 25,210.92 ** Account: 135-60066-030-000 Publications/Books/Subscripts Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining .00 0 % Used .00 .00 .00 ** Account: 135-60070-030-000 Dues & Memberships Account: 135-60070-030-000 Dues & Memberships 6,000.00 Budgeted 3,801.25 .00 3,801.25 Totals: 2,198.75 Remaining 63 % Used .00 3,801.25 ** Account: 135-60075-030-000 Meetings Account: 135-60075-030-000 Meetings 400.00 Budgeted Account: 135-60079-030-000 Public Education Account: 135-60079-030-000 Public Education 6,000.00 Budgeted .00 .00 Totals: 400.00 Remaining 0 % Used .00 .00 ** Totals: 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 682 01/28/2019 PCARD 12/27/2018-1/28/2019 pub funds invest act course .00 .00 .00 .00 ** 135.00 135.00 NCTCOG RTC TRAINING PC Account: 135-60080-030-000 Schools & Training Totals: 135.00 135.00 ** 8,950.00 Budgeted 8,815.00 Remaining 2 % Used Account: 135-60100-030-000 Travel & per diem glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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 Account: 135-60125-030-000 Account: 135-60235-030-000 602 01/18/2019 January A/P Account: 135-60235-030-000 Advertising 25,000.00 Budgeted .00 .00 Totals: 4,345.00 Remaining 0 % Used .00 .00 ** .00 .00 Totals: 200.00 Remaining 0 % Used tals: 25,000.00 Remaining 0 % Used Security monitoring service-january Security A Totals: 1,288.00 Budgeted 1,192.00 Remaining Account: 135-60245-030-000 Miscellaneous Expenses 682 01/28/2019 PCARD 12/27/2018-1/28/2019 flowers for CarolBorges family Account: 135-60245-030-000 Miscellaneous Expenses Totals: 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency Account: 135-60246-030-000 .00 .00 ** .00 .00 .00 .00 ** 72.00 24.00 96.00 Digital Air Control, Inc 7 % Used 375.51 Remaining 25 % Used General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Account: 135-60360-030-000 Furniture/Equipment < $5000 0 % Used 24.00 96.00 ** 4931 AP 124.49 124.49 ROANOKE FLORIST PC 124.49 124.49 ** .00 .00 .00 .00 ** .00 .00 glpdatb2 skrolczyk 18:55 02/13/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 1/2019 JE Detail Beginning Balance Description/Comment Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 39 Check Source Number .00 .00 ** O % Used Account: 135-65010-030-000 Uniforms Account: 135-65010-030-000 Uniforms Totals: 2,050.00 Budgeted 2,050.00 Remaining O % Used .00 .00 .00 .00 ** Account: 135-65055-030-000 Hardware Account: 135-65055-030-000 Hardware Totals: 7,064.00 Budgeted 5,817.51 Remaining Account: 135-65085-030-000 Office Supplies 602 01/18/2019 January A/P dry erase board for wwtp 602 01/18/2019 January A/P office supplie 682 01/28/2019 PCARD 12/27/2018-1/28/2019 purell, batteries 661 01/31/2019 January A/P USB drives 661 01/31/2019 January A/P office supplies Account: 135-65085-030-000 Office Supplies Totals: 6,000.00 Budgeted 3,704.14 Remaining 1,246.49 1,896.12 18 % Used 38 % Used .00 .00 187.58 112.54 47.54 21.63 30.45 399.74 1,246.49 1,246.49 ** 2,083.70 2,196.24 2,243.78 2,265.41 2,295.86 OFFICE DEPOT, INC OFFICE DEPOT, INC AMAZON.COM*MB6719JW0 OFFICE DEPOT, INC OFFICE DEPOT, INC 2,295.86 ** , 4939 AP 4939 AP PC 4976 AP 4976 AP Account: 135-65090-030-000 Printer Supplies & Maintenance 1 Account: 135-65090-030-000 Account: 135-65095-030-000 ■ 682 01/28/2019 PCARD 682 01/28/2019 PCARD 682 01/28/2019 PCARD 682 01/28/2019 PCARD 682 01/28/2019 PCARD 1 Printer Supplies & Maintenance Totals: 3,500.00 Budgeted 3,500.00 Remaining Maintenance Supplies 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 12/27/2018-1/28/2019 water, paper goods, soap, etc coffee coffee water filter air filters 1,003.76 .00 O % Used .00 244.67 77.90 56.99 41.80 278.99 .00 .00 ** 1,248.43 1,326.33 1,383.32 1,425.12 1,704.11 SAMSCLUB.COM AMZN MKTP US*MB3UM30Y2 AMZN MKTP US*MB2QW0V80 AMAZON.COM*MB9JF64R0 AMAZON.COM*M26AG59A2 PC PC PC PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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-65095-030-000 Maintenance Supplies Totals: 700.35 1,704.11 ** 4,000.00 Budgeted 2,295.89 Remaining 43 % Used Account: 135-65105-030-000 Printing .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays .00 .00 Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** Account: 135-69170-030-000 602 01/18/2019 January A/P 661 01/31/2019 January A/P Account: 135-69170-030-000 Department 30 Totals: 280,000.00 Budgeted 280,000.00 Remaining 0 o Used Copier Lease Installments copier lease Copier lease Copier Lease Installments Totals: 4,000.00 Budgeted 2,888.20 Remaining 89,541.14 Monthly Total 833.96 165.00 998.96 TIAA COMMERCIAL FINANCE 112.84 1,111.80 KYOCERA DOCUMENT SOLUTIONS 277.84 28 5 Used 1,111.80 ** 382,307.45 ** 1,559,905.00 Budgeted 1,177,597.55 Remaining 25 % Used 4945 AP 4969 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 602 01/18/2019 January A/P 661 01/31/2019 January A/P 661 01/31/2019 January A/P Legal legal -Westlake easement legal Legal 23,149.68 2,877.50 3,480.00 1,050.00 26,027.18 WHITAKER CHALK SWINDLE 29,507.18 McLean & Howard, L.L.P. 30,557.18 McLean & Howard, L.L.P. 4949 AP 4973 AP 4973 AP Account: 135-55045-039-000 Legal Totals: 7,407.50 30,557.18 ** 137,000.00 Budgeted 106,442.82 Remaining 22 % Used Account: 135-55055-039-000 Auditing 661 01/31/2019 January A/P FY 18 Audit 14,750.00 11,709.53 26,459.53 LAFOLLETT & ABBOTT PLLC 4971 AP Account: 135-55055-039-000 Auditing Totals: 11,709.53 26,459.53 ** Account: 135-55060-039-000 Account: 135-55060-039-000 30,800.00 Budgeted Appraisal 4,340.47 Remaining 86 % Used 4,723.22 .00 4,723.22 Appraisal Totals: .00 4,723.22 ** 11,714.00 Budgeted 6,990.78 Remaining 40 6 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 ** 4,800.00 Budgeted 1,147.00 Remaining 76 6 Used Department 39 Totals: 65,392.93 ** Fund 135 Totals: 19,117.03 Monthly Total 184,314.00 Budgeted 118,921.07 Remaining 35 % Used 320,134.79 489,595.32 Monthly Total (341,837.00) Budgeted (661,971.79) Remaining -94 % Used glpdatb2 skrolczyk 18:55 02/13/19 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 1/2019 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 42 Check Source Number Department Totals: Fund 137 Totals: .00 Budgeted .00 Monthly Total .00 Monthly Total 81,420.00 Remaining 0 o Used .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) ** Department Totals: Fund 137 Totals: .00 Budgeted .00 Monthly Total .00 Monthly Total 81,420.00 Remaining 0 o Used .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 - TAX BOND CONSTRUCTION BALANCE SHEET JANUARY 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 517 CONSTRUCTION FUND 1,595,680 1,595,680 (1,479,465) (116,216) (1,595,680) glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 18:55 02/13/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 7.29- 7.29 Subtotal: 7.29- 7.29 Program number: 7.29- 7.29 Department number: Revenues 7.29- 7.29 Revenues Subtotal 7.29- 7.29 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 18:55 02/13/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 116,222.93 116,222.93 - Subtotal: 116,222.93 116,222.93 - Program number: 116,222.93 116,222.93 - Department number: Wastewater 116,222.93 116,222.93 - Expenditures Subtotal 116,222.93 116,222.93 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 116,215.64 116,215.64- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/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 44 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 116,222.93 .00 116,222.93 Account: 517-69005-020-000 Capital Outlays Totals: .00 116,222.93 ** .00 Budgeted (116,222.93) Remaining 0 % Used Department 20 Totals: 116,222.93 ** Fund 517 Totals: .00 Monthly Total .00 Budgeted .00 Monthly Total .00 Budgeted (116,222.93) Remaining 0 % Used 116,215.64 (116,215.64) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET JANUARY 2019 CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 519 REVENUE BOND ASSETS 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 FUTURE REVENUE BOND BALANCE SHEET JANUARY 2019 MIr Icm.i 1.17«[ n[7rN[T 520 SWIFT REVENUE ASSETS BONDI&S CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 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 (366,246) NET REVENUES / EXPENDITURES TOTAL FUND BALANCE (366,246) TOTAL LIABILITIES AND FUND BALANCE 45,000 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JANUARY 2019 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TRSPry COLIC, nnrnicmAL In:LCTY DE TNC7 528 REVENUE BOND ASSETS RESERVE 671,857 TOTAL ASSETS 671,857 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 606,910 64,947 671,857 TOTAL LIABILITIES AND FUND BALANCE 671,857 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 528 2015 Revenue Bond Reserve Fund Department: Account Description 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 Trophy Club MUD No.1 Page 16 Budget Summary with Amendment Program: Period Ending: 1/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 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,331.13- 4,600.00- 10,432.00- 4,819.49- 18,400.00- 41,728.00- 16,363.13- 64,947.49- 16,363.13- 64,947.49- 16,363.13- 16,363.13- 16,363.13- 64,947.49- 64,947.49- 64,947.49- 96.390 33.338 33.333 35.035 180.51- 36,793.00- 83,459.00- 120,432.51- 35.035 120,432.51- 35.035 35.035 35.035 120,432.51- 120,432.51- 120,432.51- glpdatb2 skrolczyk 18:55 02/13/19 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 528-49010-000-000 Interest Income 715 01/31/2019 Bank Interest- January Account: 528-49010-000-000 Trophy Club MUD No.1 Page 45 Detailed Accounting Trial Balance Program: Period Ending: 1/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (5,000.00) Budgeted (3,488.36) (1,331.13) (180.51) Remaining 96 6 Used Account: 528-49142-000-000 Interfund transfer in -Water 716 01/31/2019 TexPool Transfers January TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (13,800.00) (55,193.00) Budgeted (36,793.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 716 01/31/2019 TexPool Transfers January TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (4,819.49) GL (1,331.13) (4,819.49) ** (4,600.00) (18,400.00) GL 33 % Used (31,296.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (83,459.00) Remaining (4,600.00) (18,400.00) ** (10,432.00) (41,728.00) GL 33 6 Used (10,432.00) (41,728.00) ** (64,947.49) ** (16,363.13) Monthly Total (185,380.00) Budgeted (120,432.51) Remaining 35 6 Used (16,363.13) Monthly Total (185,380.00) Budgeted (64,947.49) (120,432.51) Remaining 35 6 Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JANUARY 2019 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 703,957 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 87,492 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 796,022 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 87,492 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 87,492 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 655,241 TOTAL FUND BALANCE 708,530 TOTAL LIABILITIES AND FUND BALANCE 796,022 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 533 MUD 1 I&S Consolidated Account Description 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 1/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- 208,065.44- 218.45- 128.35- 609,082.29- 533.64- 184.86- 88.636 29.647 9.243 78,092.71- 1,266.36- 1,815.14 - Page 17 Subtotal: 690,975.00- 690,975.00- 208,412.24- 609,800.79- 88.252 81,174.21- 533-49010-000-000 533-49015-000-000 533-49141-000-000 Interest Income Lease/Rental Income Interfund Trans In -PID Surchg 2,000.00- 215,979.00- 120,053.00- 2,000.00- 215,979.00- 120,053.00- 1,117.79- 1,784.47- 10,913.90- 43,655.60- 89.224 36.364 215.53- 215,979.00- 76,397.40 - Subtotal: 338,032.00- 338,032.00- 12,031.69- 45,440.07- 13.443 292,591.93 - Program number: 1,029,007.00- 1,029,007.00- 220,443.93- 655,240.86- 63.677 373,766.14 - Department number: Revenues 1,029,007.00- 1,029,007.00- 220,443.93- 655,240.86- 63.677 373,766.14 - Revenues Subtotal 1,029,007.00- 1,029,007.00- 220,443.93- 655,240.86- 63.677 373,766.14- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 18:55 02/13/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 533-70025-051-000 Bond Interest Expense -Tax 266,058.00 266,058.00 533-70035-051-000 Bond Principal Payment -Tax 755,000.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 Department number: Administration Expenditures Fund number: 533 MUD 1 I&S Consolidated Subtotal 2,150.00 266,058.00 755,000.00 1,023,208.00 1,023,208.00 1,023,208.00 1,023,208.00 1,023,208.00 1,023,208.00 1,023,208.00 5,799.00- 5,799.00- 220,443.93- 655,240.86- ############### 1,023,208.00 1,023,208.00 649,441.86 glpdatb2 skrolczyk 18:55 02/13/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 1/2019 JE Detail Description/Comment Page 46 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 718 01/02/2019 Property Taxes 719 01/03/2019 Property Taxes 720 01/04/2019 Property Taxes 721 01/07/2019 Property Taxes 722 01/08/2019 Property Taxes 723 01/09/2019 Property Taxes 724 01/10/2019 Property Taxes 725 01/11/2019 Property Taxes 726 01/14/2019 Property Taxes 728 01/15/2019 Property Taxes 729 01/16/2019 Property Taxes 730 01/17/2019 Property Taxes 731 01/18/2019 Property Taxes 732 01/22/2019 Property Taxes 733 01/23/2019 Property Taxes 734 01/24/2019 Property Taxes 735 01/25/2019 Property Taxes 736 01/28/2019 Property Taxes 737 01/29/2019 Property Taxes 738 01/30/2019 Property Taxes 739 01/31/2019 Property Taxes (401,016.85) (11,325.01) (412,341.86) GL (10,292.16) (422,634.02) GL (5,337.83) (427,971.85) GL (7,303.55) (435,275.40) GL (9,842.24) (445,117.64) GL (6,707.74) (451,825.38) GL (6,241.27) (458,066.65) GL (32,521.24) (490,587.89) GL (3,743.64) (494,331.53) GL (9,358.21) (503,689.74) GL (3,977.69) (507,667.43) GL (2,068.95) (509,736.38) GL (7,044.12) (516,780.50) GL (3,948.81) (520,729.31) GL (4,877.24) (525,606.55) GL (6,504.95) (532,111.50) GL (26,635.82) (558,747.32) GL (8,242.40) (566,989.72) GL (25,484.30) (592,474.02) GL (8,889.08) (601,363.10) GL (7,719.19) (609,082.29) GL Account: 533-40000-000-000 Property Taxes Totals: (208,065.44) (609,082.29) ** (687,175.00) Budgeted (78,092.71) Remaining 89 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1 718 01/02/2019 Property Taxes 719 01/03/2019 Property Taxes 725 01/11/2019 Property Taxes 728 01/15/2019 Property Taxes 735 01/25/2019 Property Taxes 736 01/28/2019 Property Taxes 737 01/29/2019 Property Taxes (315.19) (2.03) (317.22) GL (.35) (317.57) GL (57.34) (374.91) GL (1.76) (376.67) GL (22.73) (399.40) GL (133.83) (533.23) GL (.41) (533.64) GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (218.45) (533.64) ** (1,800.00) Budgeted (1,266.36) Remaining 30 % Used Account: 533-40015-000-000 Property Taxes/P & I 725 01/11/2019 Property Taxes (56.51) 728 01/15/2019 Property Taxes (4.01) (60.52) GL (.13) (60.65) GL glpdatb2 skrolczyk 18:55 02/13/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description 736 01/28/2019 Property Taxes 737 01/29/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 1/2019 JE Detail Description/Comment Page 47 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (56.51) (124.15) (.06) (184.80) (184.86) GL GL Department Totals: (120,053.00) Budgeted (220,443.93) Monthly Total (76,397.40) Remaining 36 % Used (655,240.86) ** (1,029,007.00) Budgeted (373,766.14) Remaining 64 % Used Account: 533-40015-000-000 ' Property Taxes/P & I Totals: (128.35) (184.86) ** (2,000.00) Budgeted (1,815.14) Remaining 9 % Used Account: 533-49010-000-000 Interest Income 715 01/31/2019 Bank Interest- January (666.68) (1,117.79) (1,784.47) GL Account: 533-49010-000-000 Interest Income Totals: (1,117.79) (1,784.47) ** (2,000.00) Budgeted (215.53) Remaining 89 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (215,979.00) Budgeted (215,979.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 716 01/31/2019 TexPool Transfers January TexPool O&M to I&S- PID Debt (32,741.70) (10,913.90) (43,655.60) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,913.90) (43,655.60) ** Department Totals: (120,053.00) Budgeted (220,443.93) Monthly Total (76,397.40) Remaining 36 % Used (655,240.86) ** (1,029,007.00) Budgeted (373,766.14) Remaining 64 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee Account: 533-70005-051-000 Paying Agent Fee Totals: 2,150.00 Budgeted 2,150.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 533-70025-051-000 Bond Interest Expense -Tax Account: 533-70025-051-000 Account: 533-70035-051-000 Department 51 Totals: .00 .00 Bond Interest Expense -Tax Totals: .00 .00 ** 266,058.00 Budgeted 266,058.00 Remaining .00 .00 Bond Principal Payment -Tax Totals: .00 .00 ** 755,000.00 Budgeted 755,000.00 Remaining 0 % Used .00 ** Account: 533-70035-051-000 Bond Principal Payment -Tax 0 % Used .00 Monthly Total 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used Fund 533 Totals: (655,240.86) (220,443.93) Monthly Total (5,799.00) Budgeted 649,441.86 Remaining 8888888888 TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JANUARY 2019 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Tp4PHk [ L LI nmrm [PAL MI T = 534 REVENUE BOND ASSETS I&S 237,216 TOTAL ASSETS 237,216 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 19,562 217,655 237,216 TOTAL LIABILITIES AND FUND BALANCE 237,216 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 18:55 02/13/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 1/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 1,000.00- 1,000.00- 374.20- 840.93- 84.093 159.07- 534-49143-000-000 Interfund Transfer In -WW Sales 596,238.00- 596,238.00- 54,203.45- 216,813.80- 36.364 379,424.20 - Subtotal: 597,238.00- 597,238.00- 54,577.65- 217,654.73- 36.444 379,583.27 - Program number: 597,238.00- 597,238.00- 54,577.65- 217,654.73- 36.444 379,583.27 - Department number: Revenues 597,238.00- 597,238.00- 54,577.65- 217,654.73- 36.444 379,583.27 - Revenues Subtotal 597,238.00- 597,238.00- 54,577.65- 217,654.73- 36.444 379,583.27- glbase_tbam skrolczyk 18:55 02/13/19 Fund: 534 2015 Revenue Bond I&S Account 1 534-70005-051-000 Description Rev Bond Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 1/2019 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month Program: YTD Total % of Remaining Budget Budget 400.00 Page 20 534-70040-051-000 1 534-70045-051-000 Revenue Bond Interest Expense Revenue Bond Principal Expense 215,838.00 380,000.00 215,838.00 380,000.00 215,838.00 380,000.00 Subtotal: 596,238.00 596,238.00 596,238.00 Program number: 596,238.00 596,238.00 596,238.00 Department number: Administration 596,238.00 596,238.00 596,238.00 Expenditures Subtotal 596,238.00 596,238.00 596,238.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 54,577.65- 217,654.73- ############### 216,654.73 glpdatb2 skrolczyk 18:55 02/13/19 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 1/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 49 Check Source Number Department Totals: (596,238.00) Budgeted (54,577.65) Monthly Total (379,424.20) Remaining 36 % Used (597,238.00) Budgeted (217,654.73) ** (379,583.27) Remaining 36 % Used Account: 534-49010-000-000 Interest Income 715 01/31/2019 Bank Interest- January (466.73) (374.20) (840.93) GL Account: 534-49010-000-000 Interest Income Totals: (374.20) (840.93) ** (1,000.00) Budgeted (159.07) Remaining 84 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 716 01/31/2019 TexPool Transfers January TexPool O&M to Rev Bd WWTP I&S (162,610.35) (54,203.45) (216,813.80) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.45) (216,813.80) ** Department Totals: (596,238.00) Budgeted (54,577.65) Monthly Total (379,424.20) Remaining 36 % Used (597,238.00) Budgeted (217,654.73) ** (379,583.27) Remaining 36 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 400.00 Budgeted 400.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 215,838.00 Budgeted 215,838.00 Remaining O % Used .00 .00 .00 .00 ** .00 O % Used g .00 .00 ** Account: 534-70045-051-000 Revenue Bond Principal Expense Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: 380,000.00 Budgeted 380,000.00 Remaining Department 51 Totals: Fund 534 Totals: .00 .00 O % Used .00 Monthly Total 596,238.00 Budgeted .00 ** .00 ** 596,238.00 Remaining 0 % Used (217,654.73) (54,577.65) Monthly Total (1,000.00) Budgeted 216,654.73 Remaining NNNNNN(NNN TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JANUARY 2019 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 535 SWIFT REVENUE ASSETS BONDI&S 103,616 TOTAL ASSETS 103,616 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 2,584 101,032 103,616 TOTAL LIABILITIES AND FUND BALANCE 103,616 glbase_tbam skrolczyk 18:55 02/13/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 1 535-49010-000-000 1 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 1/2019 Adopted Amended Total Budget Budget Encumb. 600.00- 600.00 - Current Month 160.53 - Program: YTD Total 340.93- % of Remaining Budget Budget 56.822 259.07 - Page 21 535-49142-000-000 Interfund Tran In -Water Sales 276,901.00- 276,901.00- 25,172.81- 100,691.24- 36.364 176,209.76 - Subtotal: 277,501.00- 277,501.00- 25,333.34- 101,032.17- 36.408 176,468.83 - Program number: 277,501.00- 277,501.00- 25,333.34- 101,032.17- 36.408 176,468.83 - Department number: Revenues 277,501.00- 277,501.00- 25,333.34- 101,032.17- 36.408 176,468.83 - Revenues Subtotal 277,501.00- 277,501.00- 25,333.34- 101,032.17- 36.408 176,468.83- glbase_tbam skrolczyk 18:55 02/13/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 535-70005-051-000 Description Rev Bond Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 1/2019 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month Program: YTD Total % of Remaining Budget Budget 400.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 61,501.00 215,000.00 Subtotal: 276,901.00 276,901.00 276,901.00 Program number: 276,901.00 276,901.00 276,901.00 Department number: Administration 276,901.00 276,901.00 276,901.00 Expenditures Subtotal 276,901.00 276,901.00 276,901.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,333.34- 101,032.17- ############### 100,432.17 ******* End of Report ********* glpdatb2 skrolczyk 18:55 02/13/19 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 1/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 51 Check Source Number Department Totals: (276,901.00) Budgeted (25,333.34) Monthly Total (176,209.76) Remaining 36 % Used (277,501.00) Budgeted (101,032.17) ** (176,468.83) Remaining 36 % Used Account: 535-49010-000-000 Interest Income 715 01/31/2019 Bank Interest- January (180.40) (160.53) (340.93) GL Account: 535-49010-000-000 Interest Income Totals: (160.53) (340.93) ** (600.00) Budgeted (259.07) Remaining 57 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 716 01/31/2019 TexPool Transfers January TexPool O&M to 16Swift Rev I&S (75,518.43) (25,172.81) (100,691.24) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.81) (100,691.24) ** Department Totals: (276,901.00) Budgeted (25,333.34) Monthly Total (176,209.76) Remaining 36 % Used (277,501.00) Budgeted (101,032.17) ** (176,468.83) Remaining 36 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 18:55 02/13/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 1/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: 400.00 Budgeted 400.00 Remaining Account: 535-70040-051-000 Revenue Bond Interest Expense Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 61,501.00 Budgeted 61,501.00 Remaining O % Used O % Used .00 .00 .00 .00 ** .00 g .00 .00 ** Account: 535-70045-051-000 Revenue Bond Principal Expense Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining Department 51 Totals: Fund 535 Totals: Grand Totals: .00 O % Used .00 Monthly Total 276,901.00 Budgeted .00 .00 ** .00 ** 276,901.00 Remaining 0 % Used (101,032.17) (25,333.34) Monthly Total (600.00) Budgeted 100,432.17 Remaining 8888888888 (108,059.29) Monthly Total ******* End of Report ********* (1,340,637.61) **** (534,616.00) Budgeted 806,021.61 Remaining 251 % Used