Loading...
HomeMy WebLinkAbout2018-01 January Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JANUARY 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,066,777 PREPAID EXPENSES 10,159 ADVALOREM PROPERTY TAXES RECEIVABLE 118,579 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,195,515 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 118,579 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 118,579 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 554,684 TOTAL FUND BALANCE 1,076,936 TOTAL LIABILITIES AND FUND BALANCE 1,195,515 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 22:48 02/14/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 1,054,433.00- 1,054,433.00- 353,767.32- 968,101.14- 91.812 86,331.86- 122-40011-000-000 Property Taxes/Fire-Delinquent 251.22- 2,828.52- 2,828.52 122-40020-000-000 Property Taxes/Fire P&I 1,386.05- 1,862.54- 1,862.54 Subtotal: 1,054,433.00- 1,054,433.00- 355,404.59- 972,792.20- 92.257 81,640.80- Program number: 1,054,433.00- 1,054,433.00- 355,404.59- 972,792.20- 92.257 81,640.80- Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 355,404.59- 972,792.20- 92.257 81,640.80- Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 355,404.59- 972,792.20- 92.257 81,640.80- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 22:48 02/14/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 1,490.49 1,490.49- Subtotal: 1,490.49 1,490.49- 122-60030-045-000 Rent And/Or Usage 218,954.00 218,954.00 218,954.00 122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.87 5,079.48 28.219 12,920.52 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 202,970.00 33.333 405,940.00 Subtotal: 845,864.00 845,864.00 52,012.37 208,049.48 24.596 637,814.52 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 52,012.37 418,108.57 39.652 636,324.43 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 418,108.57 39.652 636,324.43 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 418,108.57 39.652 636,324.43 Fund number: 122 Trophy Club MUD Fire Dept. 303,392.22- 554,683.63- 554,683.63 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 764 01/02/2018 Property Taxes (614,333.82) (24,800.52) (639,134.34) GL 770 01/02/2018 Property Taxes (24,403.03) (663,537.37) GL 765 01/03/2018 Property Taxes (15,344.79) (678,882.16) GL 766 01/04/2018 Property Taxes (23,143.75) (702,025.91) GL 771 01/08/2018 Property Taxes (14,423.06) (716,448.97) GL 772 01/09/2018 Property Taxes (17,643.35) (734,092.32) GL 773 01/10/2018 Property Taxes (7,343.72) (741,436.04) GL 774 01/11/2018 Property Taxes (8,640.57) (750,076.61) GL 775 01/12/2018 Property Taxes (4,626.65) (754,703.26) GL 776 01/16/2018 Property Taxes (4,103.74) (758,807.00) GL 777 01/17/2018 Property Taxes (13,866.80) (772,673.80) GL 778 01/18/2018 Property Taxes (4,756.56) (777,430.36) GL 779 01/19/2018 Property Taxes (4,088.61) (781,518.97) GL 780 01/19/2018 Property Taxes (11,683.54) (793,202.51) GL 781 01/23/2018 Property Taxes (17,970.79) (811,173.30) GL 783 01/24/2018 Property Taxes (4,220.43) (815,393.73) GL 784 01/25/2018 Property Taxes (46,646.08) (862,039.81) GL 785 01/26/2018 Property Taxes (7,938.00) (869,977.81) GL 786 01/30/2018 Property Taxes (57,081.73) (927,059.54) GL 787 01/30/2018 Property Taxes (25,104.10) (952,163.64) GL 788 01/31/2018 Property Taxes (15,937.50) (968,101.14) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (353,767.32) (968,101.14) ** (1,054,433.00) Budgeted (86,331.86) Remaining 92 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 766 01/04/2018 Property Taxes (2,577.30) (6.36) (2,583.66) GL 772 01/09/2018 Property Taxes (162.23) (2,745.89) GL 773 01/10/2018 Property Taxes (4.86) (2,750.75) GL 777 01/17/2018 Property Taxes (16.21) (2,766.96) GL 783 01/24/2018 Property Taxes (.72) (2,767.68) GL 785 01/26/2018 Property Taxes (60.75) (2,828.43) GL 787 01/30/2018 Property Taxes (.09) (2,828.52) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (251.22) (2,828.52) ** .00 Budgeted 2,828.52 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 765 01/03/2018 Property Taxes (476.49) (13.98) (490.47) GL 766 01/04/2018 Property Taxes (2.79) (493.26) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 772 01/09/2018 Property Taxes (476.49) (49.08) (542.34) GL 773 01/10/2018 Property Taxes (1.17) (543.51) GL 775 01/12/2018 Property Taxes (.80) (544.31) GL 777 01/17/2018 Property Taxes (3.89) (548.20) GL 778 01/18/2018 Property Taxes (11.11) (559.31) GL 779 01/19/2018 Property Taxes (2.39) (561.70) GL 780 01/19/2018 Property Taxes (12.07) (573.77) GL 781 01/23/2018 Property Taxes (1,275.63) (1,849.40) GL 783 01/24/2018 Property Taxes (.25) (1,849.65) GL 784 01/25/2018 Property Taxes (2.85) (1,852.50) GL 786 01/30/2018 Property Taxes (4.17) (1,856.67) GL 787 01/30/2018 Property Taxes (5.87) (1,862.54) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,386.05) (1,862.54) ** .00 Budgeted 1,862.54 Remaining 0 % Used Department Totals: ----------------------------------- (972,792.20) ** (355,404.59) Monthly Total (1,054,433.00) Budgeted (81,640.80) Remaining 92 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 1,490.49 .00 1,490.49 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 1,490.49 ** .00 Budgeted (1,490.49) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 218,954.00 Budgeted 218,954.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 235 01/01/2018 Insurance/Wrk Comp Exp Jan 3,809.61 1,269.87 5,079.48 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 5,079.48 ** 18,000.00 Budgeted 12,920.52 Remaining 28 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 538 01/04/2018 January A/P January Fire Admin 152,227.50 50,742.50 202,970.00 TOWN OF TROPHY CLUB 3829 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 202,970.00 ** 608,910.00 Budgeted 405,940.00 Remaining 33 % 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 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 418,108.57 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 636,324.43 Remaining 40 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ----------------------------------- (554,683.63) (303,392.22) Monthly Total .00 Budgeted 554,683.63 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JANUARY 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,753,167 - 1,753,167 CASH IN BANK-SAVINGS-CASH RESERVE 581,493 - 581,493 CD-BANK OF THE WEST/THB DEPOSIT 35,316 - 35,316 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 714,493 - 714,493 INVESTMENTS-TEXPOOL 1,243,264 596,426 1,839,690 PREPAID EXPENSES 71,279 - 71,279 ADVALOREM PROPERTY TAXES RECEIVABLE 13,535 - 13,535 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,012,892 - 1,012,892 TOTAL ASSETS 5,426,040 596,426 6,022,465 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 13,535 - 13,535 ACCOUNTS AND OTHER PAYABLES 626,041 - 626,041 CUSTOMER DEPOSITS 313,680 - 313,680 - TOTAL LIABILITIES 953,256 - 953,256 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,778,760 1,778,760 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 180,000 180,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 120,000 120,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 67,805 67,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 228,621 228,621 UNASSIGNED FUND BALANCE 2,368,122 - 2,368,122 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 322,415 - 322,415 - TOTAL FUND BALANCE 4,472,783 596,426 5,069,209 TOTAL LIABILITIES AND FUND BALANCE 5,426,040 596,426 6,022,465 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 120,950.00- 120,950.00- 40,577.72- 111,042.78- 91.809 9,907.22- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 15.62- 185.30- 92.650 14.70- 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 156.81- 192.65- 96.325 7.35- 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 40,750.15- 111,420.73- 37.241 187,768.27- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 286,156.01- 1,575,323.01- 24.371 4,888,695.99- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 237,229.09- 943,447.18- 31.680 2,034,619.82- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 6,316.46- 44,011.03- 41.411 62,267.97- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,325.00- 4,875.00- 22.834 16,475.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 100.00- 1,150.00- 76.667 350.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 2,650.00- 58.889 1,850.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- .80- 9,118.40- 15.197 50,881.60- Subtotal: 9,635,715.00- 9,635,715.00- 531,427.36- 2,580,574.62- 26.781 7,055,140.38- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 3,741.53- 12,251.66- 102.097 251.66 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 3,846.96- 35.209 7,079.04- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,333.32- 33.333 4,666.68- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 686.00- 7,033.76- 38.692 11,145.24- 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 152.34- 5,615.57- 112.311 615.57 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.00- 135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00- Subtotal: 315,125.00- 315,125.00- 6,142.01- 31,081.27- 9.863 284,043.73- Program number: 10,250,029.00- 10,250,029.00- 578,319.52- 2,723,076.62- 26.567 7,526,952.38- Department number: Revenues 10,250,029.00- 10,250,029.00- 578,319.52- 2,723,076.62- 26.567 7,526,952.38- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 578,319.52- 2,723,076.62- 26.567 7,526,952.38- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 274,279.00 274,279.00 16,367.84 64,187.45 23.402 210,091.55 135-50010-010-000 Overtime 20,000.00 20,000.00 805.75 2,741.08 13.705 17,258.92 135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 96.642 115.00 135-50017-010-000 Certification 3,300.00 3,300.00 175.00 725.00 21.970 2,575.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,604.75 7,974.09 28.639 19,868.91 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,359.04 9,209.43 17.644 42,986.57 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 174.96 886.58 17.109 4,295.42 135-50028-010-000 Vision Insurance 994.00 994.00 29.33 172.47 17.351 821.53 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 177.21 817.18 27.404 2,164.82 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,082.38 4,381.13 23.476 14,280.87 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 253.13 1,024.61 23.473 3,340.39 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 17.36 26.04 2.411 1,053.96 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 3,599.68 30.367 8,254.32 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 63.00 226.05 113.025 26.05- 135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 24,009.67 99,299.78 23.274 327,362.22 135-55005-010-000 Engineering 275,000.00 275,000.00 275,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 12,725.39 31,203.31 31.203 68,796.69 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 4,000.00 4,000.00 1,310.53 2,577.66 64.442 1,422.34 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 762.70 2,093.44 38.063 3,406.56 Subtotal: 391,000.00 391,000.00 14,798.62 35,874.41 9.175 355,125.59 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 370.64 1,010.98 21.510 3,689.02 135-60020-010-000 Electricity 175,356.00 175,356.00 9,568.00 48,098.00 27.429 127,258.00 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 2,785.00 2,785.00 235.00 235.00 8.438 2,550.00 135-60090-010-000 Safety Program 400.00 400.00 8.36 2.090 391.64 135-60100-010-000 Travel & per diem 1,735.00 1,735.00 87.48 5.042 1,647.52 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 55,176.00 55,176.00 7,685.65 13.929 47,490.35 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 130,694.09 505,492.71 17.905 2,317,677.29 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 108.00 322.70 10.757 2,677.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 2,250.00 15.254 12,500.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 101,121.24 36.364 176,962.76 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 16,332.00 33.333 32,664.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,613,852.00 3,613,852.00 170,339.04 687,663.78 19.029 2,926,188.22 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 786.60 2,983.58 19.891 12,016.42 135-65010-010-000 Uniforms 4,488.00 4,488.00 829.64 18.486 3,658.36 135-65030-010-000 Chemicals 20,000.00 20,000.00 685.84 4,398.38 21.992 15,601.62 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 12,400.00 12,400.00 24.800 37,600.00 135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 48,900.00 48,900.00 58.214 35,100.00 Subtotal: 175,688.00 175,688.00 62,772.44 69,511.60 39.565 106,176.40 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 56,073.41 120,056.27 14.822 689,955.73 135-69008-010-000 Short Term Debt-Principal 38,731.00 38,731.00 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 5,713.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 107,864.38 90.814 10,910.62 Subtotal: 1,048,231.00 1,048,231.00 56,073.41 302,920.65 28.898 745,310.35 Program number: 5,655,433.00 5,655,433.00 327,993.18 1,195,270.22 21.135 4,460,162.78 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/2018 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 367.70 743.89 37.195 1,256.11 Subtotal: 2,000.00 2,000.00 367.70 743.89 37.195 1,256.11 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 367.70 743.89 37.195 1,256.11 Department number: Water 5,657,433.00 5,657,433.00 328,360.88 1,196,014.11 21.141 4,461,418.89 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 410,866.00 410,866.00 30,662.80 122,762.40 29.879 288,103.60 135-50010-020-000 Overtime 30,000.00 30,000.00 3,442.39 10,130.76 33.769 19,869.24 135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 100.000 135-50017-020-000 Certification 8,400.00 8,400.00 700.00 2,725.00 32.440 5,675.00 135-50020-020-000 Retirement 42,243.00 42,243.00 3,219.48 14,695.03 34.787 27,547.97 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 6,108.45 20,239.05 32.552 41,935.95 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 375.10 1,573.06 29.844 3,697.94 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 65.49 318.48 28.589 795.52 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 368.70 1,518.13 35.462 2,762.87 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,997.25 8,369.06 29.558 19,944.94 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 467.10 1,957.28 29.557 4,664.72 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 34.80 34.80 2.762 1,225.20 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 5,392.00 29.972 12,598.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 48,789.56 197,130.05 31.460 429,470.95 135-55070-020-000 Independent Labor 20,550.00 20,550.00 1,069.50 1,069.50 5.204 19,480.50 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 11,953.03 19,023.35 22.094 67,076.65 135-55085-020-000 Generator Maint. and Repair 14,000.00 14,000.00 28.78 .206 13,971.22 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 303.69 3,131.88 39.149 4,868.12 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 289.69 289.69 57.938 210.31 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 16,416.25 31,529.50 52.549 28,470.50 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 4,345.00 14,528.82 48.429 15,471.18 Subtotal: 219,150.00 219,150.00 34,377.16 69,601.52 31.760 149,548.48 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 848.34 1,611.71 34.292 3,088.29 135-60020-020-000 Electricity 266,709.00 266,709.00 16,299.17 59,754.10 22.404 206,954.90 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 5,677.00 135-60090-020-000 Safety Program 550.00 550.00 8.37 1.522 541.63 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 49.89 73.06 4.469 1,561.94 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 5,000.00 5,000.00 5,000.00 135-60135-020-000 TCEQ Fees & Permits 85,000.00 85,000.00 250.00 30,272.52 35.615 54,727.48 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 4,000.00 4,000.00 4,000.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,770.00 15.259 9,830.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 44,379.24 36.364 77,663.76 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 217,722.88 36.364 381,015.12 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 41,112.00 33.333 82,224.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 4,000.00 Subtotal: 1,438,938.00 1,438,938.00 93,250.93 396,703.88 27.569 1,042,234.12 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 800.45 2,987.64 23.901 9,512.36 135-65010-020-000 Uniforms 4,459.00 4,459.00 1,614.63 36.211 2,844.37 135-65030-020-000 Chemicals 27,500.00 27,500.00 3,226.20 3,892.03 14.153 23,607.97 135-65035-020-000 Small Tools 1,000.00 1,000.00 741.81 1,083.22 108.322 83.22- 135-65040-020-000 Safety Equipment 750.00 750.00 750.00 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 1,068.58 4,718.29 33.702 9,281.71 Subtotal: 60,209.00 60,209.00 5,837.04 14,295.81 23.744 45,913.19 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 1,868.44 13,396.93 2.448 533,930.07 135-69008-020-000 Short Term Debt-Principal 51,342.00 51,342.00 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 7,573.00 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 636,242.00 636,242.00 1,868.44 43,396.93 6.821 592,845.07 Program number: 2,981,140.00 2,981,140.00 184,123.13 721,128.19 24.190 2,260,011.81 Department number: Wastewater 2,981,140.00 2,981,140.00 184,123.13 721,128.19 24.190 2,260,011.81 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 30.00 30.00 2.42 9.68 32.267 20.32 Subtotal: 30.00 30.00 2.42 9.68 32.267 20.32 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 600.00 600.00 650.00 108.333 50.00- 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,135.00 28.375 2,865.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 289.98 289.98 5.800 4,710.02 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,021.73 51.087 978.27 Subtotal: 12,950.00 12,950.00 289.98 3,096.71 23.913 9,853.29 Program number: 12,980.00 12,980.00 292.40 3,106.39 23.932 9,873.61 Department number: Board of Directors 12,980.00 12,980.00 292.40 3,106.39 23.932 9,873.61 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 432,863.00 432,863.00 25,152.49 130,363.03 30.116 302,499.97 135-50010-030-000 Overtime 2,000.00 2,000.00 49.05 391.47 19.574 1,608.53 135-50016-030-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50020-030-000 Retirement 40,553.00 40,553.00 2,331.14 14,729.87 36.323 25,823.13 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 14,902.73 23.474 48,582.27 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 251.50 1,241.90 22.572 4,260.10 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 256.39 21.858 916.61 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 407.63 1,515.29 29.952 3,543.71 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,484.20 8,024.43 29.522 19,156.57 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 347.11 1,876.67 29.521 4,480.33 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 25.21 36.98 2.935 1,223.02 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 494.00 32.309 1,035.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 124.95 24.990 375.05 135-50070-030-000 Employee Relations 4,960.00 4,960.00 63.91 2,370.40 47.790 2,589.60 Subtotal: 595,970.00 595,970.00 34,423.49 179,875.61 30.182 416,094.39 135-55030-030-000 Software & Support 78,391.00 78,391.00 17,633.31 39,879.40 50.872 38,511.60 135-55070-030-000 Independent Labor 154,000.00 154,000.00 14,334.57 50,041.99 32.495 103,958.01 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 728.15 1,296.50 9.261 12,703.50 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55100-030-000 Building Maint & Supplies 360.00- 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 2,027.95 20.280 7,972.05 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 56,475.00 89.183 6,850.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 588.19 2,392.64 26.585 6,607.36 Subtotal: 338,916.00 338,916.00 33,793.28 152,113.48 44.882 186,802.52 135-60005-030-000 Telephone 27,300.00 27,300.00 2,991.34 5,734.55 21.006 21,565.45 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.44 1,087.18 27.180 2,912.82 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 1,053.08 1,697.60 10.440 14,563.40 135-60025-030-000 Water 2,500.00 2,500.00 53.36 227.66 9.106 2,272.34 135-60030-030-000 Rent And/Or Usage 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 1,641.09 8,024.20 26.747 21,975.80 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,828.59 21,282.89 38.306 34,277.11 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 56,000.00 56,000.00 6,100.36 24,401.44 43.574 31,598.56 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 3,566.25 3,701.25 61.688 2,298.75 135-60075-030-000 Meetings 400.00 400.00 48.62 12.155 351.38 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 7,600.00 7,600.00 2,608.00 34.316 4,992.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 29.32 469.84 9.618 4,415.16 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 4,500.00 4,500.00 145.00 3.222 4,355.00 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 2,700.00 2,700.00 24.00 24.00 .889 2,676.00 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 8.480 2,288.01 Subtotal: 249,506.00 249,506.00 20,524.83 70,280.62 28.168 179,225.38 135-65010-030-000 Uniforms 700.00 700.00 700.00 135-65055-030-000 Hardware 7,420.00 7,420.00 597.95 8.059 6,822.05 135-65085-030-000 Office Supplies 7,000.00 7,000.00 512.75 2,475.55 35.365 4,524.45 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 244.99 1,903.05 95.153 96.95 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 572.21 1,729.49 43.237 2,270.51 135-65105-030-000 Printing 4,000.00 4,000.00 144.00 3.600 3,856.00 Subtotal: 25,120.00 25,120.00 1,329.95 6,850.04 27.269 18,269.96 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 7,841.00 60.315 5,159.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 326.56 971.23 21.114 3,628.77 Subtotal: 17,600.00 17,600.00 326.56 8,812.23 50.069 8,787.77 Program number: 1,227,112.00 1,227,112.00 90,398.11 417,931.98 34.058 809,180.02 Department number: Administration 1,227,112.00 1,227,112.00 90,398.11 417,931.98 34.058 809,180.02 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 22:48 02/14/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 137,000.00 12,084.56 29,343.55 21.419 107,656.45 135-55055-039-000 Auditing 24,500.00 24,500.00 11,108.70 25,508.70 104.117 1,008.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 4,660.18 40.714 6,785.82 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 78.116 831.60 Subtotal: 176,746.00 176,746.00 23,193.26 62,480.83 35.351 114,265.17 Program number: 176,746.00 176,746.00 23,193.26 62,480.83 35.351 114,265.17 Department number: Non Departmental 176,746.00 176,746.00 23,193.26 62,480.83 35.351 114,265.17 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 626,367.78 2,400,661.50 23.874 7,654,749.50 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 48,048.26 322,415.12- 165.666 127,797.12 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 22:48 02/14/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.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 Trophy Club MUD No.1 Page 5 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 764 01/02/2018 Property Taxes (70,465.06) (2,844.66) (73,309.72) GL 770 01/02/2018 Property Taxes (2,799.07) (76,108.79) GL 765 01/03/2018 Property Taxes (1,760.07) (77,868.86) GL 766 01/04/2018 Property Taxes (2,654.63) (80,523.49) GL 771 01/08/2018 Property Taxes (1,654.35) (82,177.84) GL 772 01/09/2018 Property Taxes (2,023.73) (84,201.57) GL 773 01/10/2018 Property Taxes (842.33) (85,043.90) GL 774 01/11/2018 Property Taxes (991.09) (86,034.99) GL 775 01/12/2018 Property Taxes (530.69) (86,565.68) GL 776 01/16/2018 Property Taxes (470.71) (87,036.39) GL 777 01/17/2018 Property Taxes (1,590.55) (88,626.94) GL 778 01/18/2018 Property Taxes (545.59) (89,172.53) GL 779 01/19/2018 Property Taxes (468.97) (89,641.50) GL 780 01/19/2018 Property Taxes (1,340.13) (90,981.63) GL 781 01/23/2018 Property Taxes (2,061.28) (93,042.91) GL 783 01/24/2018 Property Taxes (484.09) (93,527.00) GL 784 01/25/2018 Property Taxes (5,350.38) (98,877.38) GL 785 01/26/2018 Property Taxes (910.50) (99,787.88) GL 786 01/30/2018 Property Taxes (6,547.36) (106,335.24) GL 787 01/30/2018 Property Taxes (2,879.48) (109,214.72) GL 788 01/31/2018 Property Taxes (1,828.06) (111,042.78) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (40,577.72) (111,042.78) ** (120,950.00) Budgeted (9,907.22) Remaining 92 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 766 01/04/2018 Property Taxes (169.68) (1.22) (170.90) GL 772 01/09/2018 Property Taxes (9.54) (180.44) GL 773 01/10/2018 Property Taxes (.29) (180.73) GL 777 01/17/2018 Property Taxes (.95) (181.68) GL 783 01/24/2018 Property Taxes (.04) (181.72) GL 785 01/26/2018 Property Taxes (3.57) (185.29) GL 787 01/30/2018 Property Taxes (.01) (185.30) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (15.62) (185.30) ** (200.00) Budgeted (14.70) Remaining 93 % Used Account: 135-40015-000-000 Property Taxes/P & I 765 01/03/2018 Property Taxes (35.84) (1.60) (37.44) GL 766 01/04/2018 Property Taxes (.54) (37.98) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 772 01/09/2018 Property Taxes (35.84) (3.54) (41.52) GL 773 01/10/2018 Property Taxes (.07) (41.59) GL 775 01/12/2018 Property Taxes (.09) (41.68) GL 777 01/17/2018 Property Taxes (.23) (41.91) GL 778 01/18/2018 Property Taxes (1.27) (43.18) GL 779 01/19/2018 Property Taxes (.27) (43.45) GL 780 01/19/2018 Property Taxes (1.38) (44.83) GL 781 01/23/2018 Property Taxes (146.32) (191.15) GL 783 01/24/2018 Property Taxes (.02) (191.17) GL 784 01/25/2018 Property Taxes (.33) (191.50) GL 786 01/30/2018 Property Taxes (.48) (191.98) GL 787 01/30/2018 Property Taxes (.67) (192.65) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (156.81) (192.65) ** (200.00) Budgeted (7.35) Remaining 96 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (177,839.00) Budgeted (177,839.00) Remaining 0 % Used Account: 135-47000-000-000 Water 717 01/11/2018 UB adj-15 salida dr UB20180111-20180111 User: (1,289,167.00) 20.05 (1,289,146.95) UB 718 01/15/2018 UB adj-2858 milson-2605 bellsh UB20180115-20180115 User: 624.81 (1,288,522.14) UB 637 01/17/2018 Bill adj for 228 Oak Hill UB20180117-20180117 User: 6.54 (1,288,515.60) UB 714 01/31/2018 UB 01/31/2018 Billing UB20180131-20180131 User: (286,811.47) (1,575,327.07) UB 724 01/31/2018 UB 1/31/18 UB20180131-20180131 User: 4.06 (1,575,323.01) UB _______________ Account: 135-47000-000-000 Water Totals: (286,156.01) (1,575,323.01) ** (6,464,019.00) Budgeted (4,888,695.99) Remaining 24 % Used Account: 135-47005-000-000 Sewer 717 01/11/2018 UB adj-15 salida dr UB20180111-20180111 User: (706,218.09) 31.99 (706,186.10) UB 718 01/15/2018 UB adj-2858 milson-2605 bellsh UB20180115-20180115 User: 26.90 (706,159.20) UB 637 01/17/2018 Bill adj for 228 Oak Hill UB20180117-20180117 User: 36.55 (706,122.65) UB 714 01/31/2018 UB 01/31/2018 Billing UB20180131-20180131 User: (237,364.36) (943,487.01) UB 724 01/31/2018 UB 1/31/18 UB20180131-20180131 User: 39.83 (943,447.18) UB _______________ Account: 135-47005-000-000 Sewer Totals: (237,229.09) (943,447.18) ** (2,978,067.00) Budgeted (2,034,619.82) Remaining 32 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47025-000-000 Penalties 638 01/17/2018 UB 01/17/2018 Penalty Removal UB20180117-20180117 User: (37,694.57) 502.11 (37,192.46) UB 674 01/23/2018 UB Penalties UB20180123-20180123 User: (7,222.14) (44,414.60) UB 700 01/29/2018 UB 01/29/2018 Penalties UB20180129-20180129 User: 105.22 (44,309.38) UB 704 01/30/2018 UB 01/30/2018 Penalties UB20180130-20180130 User: 54.53 (44,254.85) UB 710 01/31/2018 UB 01/31/2018 Penalties UB20180131-20180131 User: 243.82 (44,011.03) UB _______________ Account: 135-47025-000-000 Penalties Totals: (6,316.46) (44,011.03) ** (106,279.00) Budgeted (62,267.97) Remaining 41 % Used Account: 135-47030-000-000 Service Charges 571 01/09/2018 UB 01/09/2018 Diconnect Fees UB20180109-20180109 User: (3,550.00) (164,000.00) (167,550.00) UB 573 01/09/2018 UB 1/9/2018 Disconnect Fees UB20180109-20180109 User: (1,250.00) (168,800.00) UB 716 01/09/2018 UB disconnect fees-err UB20180109-20180109 User: 164,000.00 (4,800.00) UB 663 01/12/2018 UB NSF January 2018 UB20180112-20180112 User: (50.00) (4,850.00) UB 664 01/22/2018 UB 01/22/2018 NSF UB20180122-20180122 User: (25.00) (4,875.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,325.00) (4,875.00) ** (21,350.00) Budgeted (16,475.00) Remaining 23 % Used Account: 135-47035-000-000 Plumbing Inspections 726 01/02/2018 Permits-607 Hogan's Drive 607 Hogan's Drive (1,050.00) (50.00) (1,100.00) Ashton woods homes CR 727 01/31/2018 Permits-12 Sadie Court 12 Sadie Court (50.00) (1,150.00) Ashton Woods homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,150.00) ** (1,500.00) Budgeted (350.00) Remaining 77 % Used Account: 135-47045-000-000 Sewer Inspections 726 01/02/2018 Permits-607 Hogan's Drive 607 Hogan's Drive (2,350.00) (150.00) (2,500.00) Ashton woods homes CR 727 01/31/2018 Permits-12 Sadie Court 12 Sadie Court (150.00) (2,650.00) Ashton Woods homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (2,650.00) ** (4,500.00) Budgeted (1,850.00) Remaining 59 % Used Account: 135-47070-000-000 TCCC Effluent Charges 714 01/31/2018 UB 01/31/2018 Billing UB20180131-20180131 User: (9,117.60) (.80) (9,118.40) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (.80) (9,118.40) ** (60,000.00) Budgeted (50,881.60) Remaining 15 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49010-000-000 Interest Income 802 01/31/2018 Bank Interest- January (8,510.13) (161.46) (8,671.59) GL 802 01/31/2018 Bank Interest- January (515.15) (9,186.74) GL 802 01/31/2018 Bank Interest- January (3,064.92) (12,251.66) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (3,741.53) (12,251.66) ** (12,000.00) Budgeted 251.66 Remaining 102 % Used Account: 135-49016-000-000 Cell Tower Revenue 768 01/04/2018 Cell Tower Revenue AT&T (2,868.15) (978.81) (3,846.96) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (3,846.96) ** (10,926.00) Budgeted (7,079.04) Remaining 35 % Used Account: 135-49018-000-000 Building Rent Income 811 01/31/2018 Town Billed Invoices 1618-1622 AR 20180131-20180131 User: (1,749.99) (583.33) (2,333.32) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 % 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 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 726 01/02/2018 Permits-607 Hogan's Drive 607 Hogan's Drive (6,347.76) (343.00) (6,690.76) Ashton woods homes CR 727 01/31/2018 Permits-12 Sadie Court 12 Sadie Court (343.00) (7,033.76) Ashton Woods homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (7,033.76) ** (18,179.00) Budgeted (11,145.24) Remaining 39 % Used Account: 135-49900-000-000 Miscellaneous Income 722 01/11/2018 Rfd 15 salida drive UB20180111-20180111 User: (5,463.23) (.37) (5,463.60) UB 719 01/30/2018 UB penalty removals UB20180130-20180130 User: 51.04 (5,412.56) UB 714 01/31/2018 UB 01/31/2018 Billing UB20180131-20180131 User: (203.01) (5,615.57) UB . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (152.34) (5,615.57) ** (5,000.00) Budgeted 615.57 Remaining 112 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (20.00) Budgeted (20.00) Remaining 0 % Used Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (2,723,076.62) ** (578,319.52) Monthly Total (10,250,029.00) Budgeted (7,526,952.38) Remaining 27 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 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 600 01/12/2018 MUD PR 01/12/2018 Salaries & Wages 47,819.61 7,483.92 55,303.53 PR 685 01/26/2018 MUD PR 01/26/18 Salaries & Wages 8,883.92 64,187.45 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,367.84 64,187.45 ** 274,279.00 Budgeted 210,091.55 Remaining 23 % Used Account: 135-50010-010-000 Overtime 600 01/12/2018 MUD PR 01/12/2018 Overtime 1,935.33 214.25 2,149.58 PR 685 01/26/2018 MUD PR 01/26/18 Overtime 591.50 2,741.08 PR _______________ Account: 135-50010-010-000 Overtime Totals: 805.75 2,741.08 ** 20,000.00 Budgeted 17,258.92 Remaining 14 % Used Account: 135-50016-010-000 Longevity 3,310.00 .00 3,310.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,310.00 ** 3,425.00 Budgeted 115.00 Remaining 97 % Used Account: 135-50017-010-000 Certification 685 01/26/2018 MUD PR 01/26/18 Certification 550.00 175.00 725.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 725.00 ** 3,300.00 Budgeted 2,575.00 Remaining 22 % Used Account: 135-50020-010-000 Retirement 600 01/12/2018 MUD PR 01/12/2018 Retirement 6,369.34 712.08 7,081.42 PR 685 01/26/2018 MUD PR 01/26/18 Retirement 892.67 7,974.09 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,604.75 7,974.09 ** 27,843.00 Budgeted 19,868.91 Remaining 29 % Used Account: 135-50026-010-000 Medical Insurance 600 01/12/2018 MUD PR 01/12/2018 Medical Insurance 6,850.39 1,179.52 8,029.91 PR 685 01/26/2018 MUD PR 01/26/18 Medical Insurance 1,179.52 9,209.43 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,359.04 9,209.43 ** 52,196.00 Budgeted 42,986.57 Remaining 18 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 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 600 01/12/2018 MUD PR 01/12/2018 Dental Insurance 711.62 87.48 799.10 PR 685 01/26/2018 MUD PR 01/26/18 Dental Insurance 87.48 886.58 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 174.96 886.58 ** 5,182.00 Budgeted 4,295.42 Remaining 17 % Used Account: 135-50028-010-000 Vision Insurance 600 01/12/2018 MUD PR 01/12/2018 Vision Insurance 143.14 14.68 157.82 PR 685 01/26/2018 MUD PR 01/26/18 Vision Insurance 14.65 172.47 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 29.33 172.47 ** 994.00 Budgeted 821.53 Remaining 17 % Used Account: 135-50029-010-000 Life Insurance & Other 538 01/04/2018 January A/P STD & LTD Benefits 639.97 86.49 726.46 METLIFE GROUP BENEFITS 3820 AP 538 01/04/2018 January A/P Benefits-Insurance, Dental, Vi 90.72 817.18 Humana Inc 3814 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 177.21 817.18 ** 2,982.00 Budgeted 2,164.82 Remaining 27 % Used Account: 135-50030-010-000 Social Security Taxes 600 01/12/2018 MUD PR 01/12/2018 Social Security Taxes 3,298.75 488.72 3,787.47 PR 685 01/26/2018 MUD PR 01/26/18 Social Security Taxes 593.66 4,381.13 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,082.38 4,381.13 ** 18,662.00 Budgeted 14,280.87 Remaining 23 % Used Account: 135-50035-010-000 Medicare Taxes 600 01/12/2018 MUD PR 01/12/2018 Medicare Taxes 771.48 114.30 885.78 PR 685 01/26/2018 MUD PR 01/26/18 Medicare Taxes 138.83 1,024.61 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 253.13 1,024.61 ** 4,365.00 Budgeted 3,340.39 Remaining 23 % Used Account: 135-50040-010-000 Unemployment Taxes 600 01/12/2018 MUD PR 01/12/2018 Unemployment Taxes 8.68 7.70 16.38 PR 685 01/26/2018 MUD PR 01/26/18 Unemployment Taxes 9.66 26.04 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 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: 17.36 26.04 ** 1,080.00 Budgeted 1,053.96 Remaining 2 % Used Account: 135-50045-010-000 Workman's Compensation 235 01/01/2018 Insurance/Wrk Comp Exp Jan 2,699.76 899.92 3,599.68 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 3,599.68 ** 11,854.00 Budgeted 8,254.32 Remaining 30 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 752 01/31/2018 Jan A/P Post accident testing 163.05 63.00 226.05 CARENOW CORPORATE 3887 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 63.00 226.05 ** 200.00 Budgeted (26.05) Remaining 113 % Used Account: 135-50070-010-000 Employee Relations 18.99 .00 18.99 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 18.99 ** 300.00 Budgeted 281.01 Remaining 6 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 275,000.00 Budgeted 275,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 538 01/04/2018 January A/P 609 Hogan's Drive 18,477.92 7,209.54 25,687.46 REY-MAR CONSTRUCTION 3825 AP 631 01/15/2018 January A/P Hand pumps 149.16 25,836.62 Core & Main LP 3841 AP 676 01/23/2018 January A/P Fire hydrant parts 1,041.39 26,878.01 Core & Main LP 3863 AP 676 01/23/2018 January A/P Angle stops 1,702.32 28,580.33 Core & Main LP 3863 AP 676 01/23/2018 January A/P Meter boxes 1,899.60 30,479.93 Core & Main LP 3863 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ROANOKE WINNELSON CO 25.10 30,505.03 ROANOKE WINNELSON CO PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ROANOKE WINNELSON CO 42.13 30,547.16 ROANOKE WINNELSON CO PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 BABBITTS ONLINE 36.15 30,583.31 BABBITTS ONLINE PC 752 01/31/2018 Jan A/P Transducer repair on 1/29/18 @ 620.00 31,203.31 DHS AUTOMATION, INC 3891 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 12,725.39 31,203.31 ** 100,000.00 Budgeted 68,796.69 Remaining 31 % Used Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 750 01/26/2018 Pcard 12/27/17 - 01/26/18 TX.GOV SERVICEFEE- 1,267.13 2.00 1,269.13 TX.GOV SERVICEFEE- PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 DENTON VEHREG 8.25 1,277.38 DENTON VEHREG PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 GIERISCH CARE 0050292 131.09 1,408.47 GIERISCH CARE 0050292 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 GIERISCH CARE 0050292 62.69 1,471.16 GIERISCH CARE 0050292 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 DISCOUNT TIRE TXD 75 269.00 1,740.16 DISCOUNT TIRE TXD 75 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 DISCOUNT TIRE TXD 75 662.00 2,402.16 DISCOUNT TIRE TXD 75 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 DISCOUNT TIRE TXD 75 150.00 2,552.16 DISCOUNT TIRE TXD 75 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 KWIK KAR LUBE & TUNE O 25.50 2,577.66 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,310.53 2,577.66 ** 4,000.00 Budgeted 1,422.34 Remaining 64 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 631 01/15/2018 January A/P water samples 1,330.74 285.00 1,615.74 TARRANT CTY PUBLIC HEALTH LAB 3855 AP 752 01/31/2018 Jan A/P TCEQ samples 207.70 1,823.44 LOWER COLORADO RIVER AUTHORITY 3904 AP 801 01/31/2018 January A/P Water samples 270.00 2,093.44 TARRANT CTY PUBLIC HEALTH LAB 3942 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 762.70 2,093.44 ** 5,500.00 Budgeted 3,406.56 Remaining 38 % Used Account: 135-60010-010-000 Communications/Mobiles . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 631 01/15/2018 January A/P phones 640.34 370.64 1,010.98 VERIZON WIRELESS 3859 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 370.64 1,010.98 ** 4,700.00 Budgeted 3,689.02 Remaining 22 % Used Account: 135-60020-010-000 Electricity 676 01/23/2018 January A/P Electricity 12/8-1/10 38,530.00 9,347.70 47,877.70 HUDSON ENERGY SERVICES, LLC 3869 AP 789 01/31/2018 Jan A/P Electricity 12/8-1/10 161.67 48,039.37 HUDSON ENERGY SERVICES, LLC 3935 AP 789 01/31/2018 Jan A/P Electricity 12/7-1/9 58.63 48,098.00 HUDSON ENERGY SERVICES, LLC 3935 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,568.00 48,098.00 ** 175,356.00 Budgeted 127,258.00 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 750 01/26/2018 Pcard 12/27/17 - 01/26/18 SUNCOAST LEARNING SYST 235.00 235.00 SUNCOAST LEARNING SYST PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 235.00 235.00 ** 2,785.00 Budgeted 2,550.00 Remaining 8 % Used Account: 135-60090-010-000 Safety Program 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 87.48 .00 87.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % 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 ** 55,176.00 Budgeted 47,490.35 Remaining 14 % Used Account: 135-60150-010-000 Wholesale Water 732 01/31/2018 January A/P Fort worth water 374,798.62 130,694.09 505,492.71 CITY OF FORT WORTH 3888 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 130,694.09 505,492.71 ** 2,823,170.00 Budgeted 2,317,677.29 Remaining 18 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 750 01/26/2018 Pcard 12/27/17 - 01/26/18 DENTON SAND & GRAVEL, 214.70 108.00 322.70 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 108.00 322.70 ** 3,000.00 Budgeted 2,677.30 Remaining 11 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2,250.00 .00 2,250.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 2,250.00 ** 14,750.00 Budgeted 12,500.00 Remaining 15 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 711 01/31/2018 Texpool Transfers Jan 75,840.93 25,280.31 101,121.24 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 101,121.24 ** 278,084.00 Budgeted 176,962.76 Remaining 36 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 711 01/31/2018 Texpool Transfers Jan 12,249.00 4,083.00 16,332.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 16,332.00 ** 48,996.00 Budgeted 32,664.00 Remaining 33 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 5,019.66 .00 5,019.66 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 5,019.66 ** 2,500.00 Budgeted (2,519.66) Remaining 201 % Used Account: 135-65005-010-000 Fuel & Lube 732 01/31/2018 January A/P Fuel 2,196.98 786.60 2,983.58 US Bank Voyager Fleet Systems 3916 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 786.60 2,983.58 ** 15,000.00 Budgeted 12,016.42 Remaining 20 % Used Account: 135-65010-010-000 Uniforms 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON.COM 829.64 (21.00) 808.64 AMAZON.COM PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON.COM (20.98) 787.66 AMAZON.COM PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON.COM 829.64 (20.99) 766.67 AMAZON.COM PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON.COM (62.97) 703.70 AMAZON.COM PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON.COM (20.99) 682.71 AMAZON.COM PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON.COM 146.93 829.64 AMAZON.COM PC _______________ Account: 135-65010-010-000 Uniforms Totals: .00 829.64 ** 4,488.00 Budgeted 3,658.36 Remaining 18 % Used Account: 135-65030-010-000 Chemicals 676 01/23/2018 January A/P Testing supplies 3,712.54 132.73 3,845.27 HACH COMPANY 3867 AP 676 01/23/2018 January A/P Chlorine 553.11 4,398.38 DPC INDUSTRIES, INC 3864 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 685.84 4,398.38 ** 20,000.00 Budgeted 15,601.62 Remaining 22 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 558 01/08/2018 January A/P Meters 12,400.00 12,400.00 ATLAS UTILITY SUPPLY CO. 3796 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 12,400.00 12,400.00 ** 50,000.00 Budgeted 37,600.00 Remaining 25 % Used Account: 135-65053-010-000 Meter Change Out Program 558 01/08/2018 January A/P Meters 48,900.00 48,900.00 ATLAS UTILITY SUPPLY CO. 3796 AP _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: 48,900.00 48,900.00 ** 84,000.00 Budgeted 35,100.00 Remaining 58 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2018 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 631 01/15/2018 January A/P 16" waterline 63,982.86 24,057.96 88,040.82 Halff Associates, INC 3845 AP 631 01/15/2018 January A/P 16" water line 6,479.01 94,519.83 Halff Associates, INC 3845 AP 631 01/15/2018 January A/P Bond application 16" upgrade 1,755.00 96,274.83 CP&Y/WALLACE GROUP, INC. 3842 AP 631 01/15/2018 January A/P VFD 7,281.44 103,556.27 CP&Y/WALLACE GROUP, INC. 3842 AP 752 01/31/2018 Jan A/P Street projects w/ town (India 16,500.00 120,056.27 TEAGUE, NALL & PERKINS,INC 3911 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 56,073.41 120,056.27 ** 810,012.00 Budgeted 689,955.73 Remaining 15 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 107,864.38 .00 107,864.38 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 631 01/15/2018 January A/P water samples-PID 376.19 80.00 456.19 TARRANT CTY PUBLIC HEALTH LAB 3855 AP 801 01/31/2018 January A/P Water samples 80.00 536.19 TARRANT CTY PUBLIC HEALTH LAB 3942 AP 801 01/31/2018 January A/P TCEQ samples 207.70 743.89 LOWER COLORADO RIVER AUTHORITY 3939 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 367.70 743.89 ** 2,000.00 Budgeted 1,256.11 Remaining 37 % Used Department 10 Totals: ----------------------------------- 1,196,014.11 ** 328,360.88 Monthly Total 5,657,433.00 Budgeted 4,461,418.89 Remaining 21 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 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 600 01/12/2018 MUD PR 01/12/2018 Salaries & Wages 92,099.60 15,303.74 107,403.34 PR 685 01/26/2018 MUD PR 01/26/18 Salaries & Wages 15,359.06 122,762.40 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 30,662.80 122,762.40 ** 410,866.00 Budgeted 288,103.60 Remaining 30 % Used Account: 135-50010-020-000 Overtime 600 01/12/2018 MUD PR 01/12/2018 Overtime 6,688.37 2,161.15 8,849.52 PR 685 01/26/2018 MUD PR 01/26/18 Overtime 1,281.24 10,130.76 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,442.39 10,130.76 ** 30,000.00 Budgeted 19,869.24 Remaining 34 % Used Account: 135-50016-020-000 Longevity 7,415.00 .00 7,415.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 7,415.00 ** 7,415.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 685 01/26/2018 MUD PR 01/26/18 Certification 2,025.00 700.00 2,725.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 2,725.00 ** 8,400.00 Budgeted 5,675.00 Remaining 32 % Used Account: 135-50020-020-000 Retirement 600 01/12/2018 MUD PR 01/12/2018 Retirement 11,475.55 1,615.51 13,091.06 PR 685 01/26/2018 MUD PR 01/26/18 Retirement 1,603.97 14,695.03 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,219.48 14,695.03 ** 42,243.00 Budgeted 27,547.97 Remaining 35 % Used Account: 135-50026-020-000 Medical Insurance 600 01/12/2018 MUD PR 01/12/2018 Medical Insurance 14,130.60 3,054.24 17,184.84 PR 685 01/26/2018 MUD PR 01/26/18 Medical Insurance 3,054.21 20,239.05 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 6,108.45 20,239.05 ** 62,175.00 Budgeted 41,935.95 Remaining 33 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 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 600 01/12/2018 MUD PR 01/12/2018 Dental Insurance 1,197.96 187.57 1,385.53 PR 685 01/26/2018 MUD PR 01/26/18 Dental Insurance 187.53 1,573.06 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 375.10 1,573.06 ** 5,271.00 Budgeted 3,697.94 Remaining 30 % Used Account: 135-50028-020-000 Vision Insurance 600 01/12/2018 MUD PR 01/12/2018 Vision Insurance 252.99 32.76 285.75 PR 685 01/26/2018 MUD PR 01/26/18 Vision Insurance 32.73 318.48 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 65.49 318.48 ** 1,114.00 Budgeted 795.52 Remaining 29 % Used Account: 135-50029-020-000 Life Insurance & Other 538 01/04/2018 January A/P STD & LTD Benefits 1,149.43 176.34 1,325.77 METLIFE GROUP BENEFITS 3820 AP 538 01/04/2018 January A/P Benefits-Insurance, Dental, Vi 192.36 1,518.13 Humana Inc 3814 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 368.70 1,518.13 ** 4,281.00 Budgeted 2,762.87 Remaining 35 % Used Account: 135-50030-020-000 Social Security Taxes 600 01/12/2018 MUD PR 01/12/2018 Social Security Taxes 6,371.81 1,023.18 7,394.99 PR 685 01/26/2018 MUD PR 01/26/18 Social Security Taxes 974.07 8,369.06 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,997.25 8,369.06 ** 28,314.00 Budgeted 19,944.94 Remaining 30 % Used Account: 135-50035-020-000 Medicare Taxes 600 01/12/2018 MUD PR 01/12/2018 Medicare Taxes 1,490.18 239.30 1,729.48 PR 685 01/26/2018 MUD PR 01/26/18 Medicare Taxes 227.80 1,957.28 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 467.10 1,957.28 ** 6,622.00 Budgeted 4,664.72 Remaining 30 % Used Account: 135-50040-020-000 Unemployment Taxes 600 01/12/2018 MUD PR 01/12/2018 Unemployment Taxes 17.47 17.47 PR 685 01/26/2018 MUD PR 01/26/18 Unemployment Taxes 17.33 34.80 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 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: 34.80 34.80 ** 1,260.00 Budgeted 1,225.20 Remaining 3 % Used Account: 135-50045-020-000 Workman's Compensation 235 01/01/2018 Insurance/Wrk Comp Exp Jan 4,044.00 1,348.00 5,392.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 5,392.00 ** 17,990.00 Budgeted 12,598.00 Remaining 30 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 676 01/23/2018 January A/P Annual meter calibration 751.50 751.50 Prime Controls, LP 3877 AP 732 01/31/2018 January A/P annual calibration 318.00 1,069.50 METTLER TOLEDO INTERNATIONAL 3905 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 1,069.50 1,069.50 ** 20,550.00 Budgeted 19,480.50 Remaining 5 % Used Account: 135-55080-020-000 Maintenance & Repairs 676 01/23/2018 January A/P 10 longo pack bag 7,070.32 1,170.00 8,240.32 Huber Technology Inc 3868 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 SITEONE LANDSCAPE S 547.10 8,787.42 SITEONE LANDSCAPE S PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 WW GRAINGER 219.33 9,006.75 WW GRAINGER PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 WW GRAINGER 4.15 9,010.90 WW GRAINGER PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AUTOZONE #4206 46.99 9,057.89 AUTOZONE #4206 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 SC TRACKING SOLUTIONS 10.95 9,068.84 SC TRACKING SOLUTIONS PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 THE HOME DEPOT #6581 74.31 9,143.15 THE HOME DEPOT #6581 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 TOM THUMB #1789 1.29 9,144.44 TOM THUMB #1789 PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ARS*RR FT WORTH 9127 7,070.32 3,975.00 13,119.44 ARS*RR FT WORTH 9127 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ROYAL TRUCK BODY 249.34 13,368.78 ROYAL TRUCK BODY PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ARS RR FT WORTH 9127 1,193.00 14,561.78 ARS RR FT WORTH 9127 PC 732 01/31/2018 January A/P Maintenance parts for belt pre 4,302.07 18,863.85 ALFA LAVAL ASHBROOK 3883 AP 732 01/31/2018 January A/P Black scraper for belt press 159.50 19,023.35 ALFA LAVAL ASHBROOK 3883 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 11,953.03 19,023.35 ** 86,100.00 Budgeted 67,076.65 Remaining 22 % Used Account: 135-55085-020-000 Generator Maint. and Repair 28.78 .00 28.78 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 28.78 ** 14,000.00 Budgeted 13,971.22 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 750 01/26/2018 Pcard 12/27/17 - 01/26/18 TX.GOV SERVICEFEE- 2,828.19 2.00 2,830.19 TX.GOV SERVICEFEE- PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 DENTON VEHREG 8.25 2,838.44 DENTON VEHREG PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 MUSTANG ELITE CAR 267.94 3,106.38 MUSTANG ELITE CAR PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 MUSTANG ELITE CAR 25.50 3,131.88 MUSTANG ELITE CAR PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 303.69 3,131.88 ** 8,000.00 Budgeted 4,868.12 Remaining 39 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 752 01/31/2018 Jan A/P Backhoe front tire-original in 289.69 289.69 BLAGG TIRE & SERVICE 3884 AP _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 289.69 289.69 ** 500.00 Budgeted 210.31 Remaining 58 % Used Account: 135-55125-020-000 Dumpster Services 631 01/15/2018 January A/P sludge haul off 15,113.25 2,022.51 17,135.76 L.H. CHANEY MATERIALS, INC. 3847 AP 631 01/15/2018 January A/P sludge haul off 2,014.90 19,150.66 L.H. CHANEY MATERIALS, INC. 3847 AP 631 01/15/2018 January A/P Sludge Haul off 1,023.30 20,173.96 L.H. CHANEY MATERIALS, INC. 3847 AP 676 01/23/2018 January A/P Sludge hual off 2,792.73 22,966.69 L.H. CHANEY MATERIALS, INC. 3872 AP 676 01/23/2018 January A/P sludge haul off 1,802.81 24,769.50 L.H. CHANEY MATERIALS, INC. 3872 AP 732 01/31/2018 January A/P Sludge haul off 3,380.00 28,149.50 L.H. CHANEY MATERIALS, INC. 3902 AP 732 01/31/2018 January A/P Sludge haul off 3,380.00 31,529.50 L.H. CHANEY MATERIALS, INC. 3902 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55125-020-000 Dumpster Services Totals: 16,416.25 31,529.50 ** 60,000.00 Budgeted 28,470.50 Remaining 53 % Used Account: 135-55135-020-000 Lab Analysis 631 01/15/2018 January A/P Testing 10,183.82 246.00 10,429.82 OXIDOR LABORATORIES LLC 3853 AP 631 01/15/2018 January A/P Testing 176.00 10,605.82 OXIDOR LABORATORIES LLC 3853 AP 631 01/15/2018 January A/P Testing 246.00 10,851.82 OXIDOR LABORATORIES LLC 3853 AP 631 01/15/2018 January A/P Testing 877.50 11,729.32 OXIDOR LABORATORIES LLC 3853 AP 631 01/15/2018 January A/P Testing 1,357.50 13,086.82 OXIDOR LABORATORIES LLC 3853 AP 631 01/15/2018 January A/P Testing 176.00 13,262.82 OXIDOR LABORATORIES LLC 3853 AP 676 01/23/2018 January A/P Lab testing 176.00 13,438.82 OXIDOR LABORATORIES LLC 3876 AP 676 01/23/2018 January A/P Testing 246.00 13,684.82 OXIDOR LABORATORIES LLC 3876 AP 732 01/31/2018 January A/P lab supplies 246.00 13,930.82 OXIDOR LABORATORIES LLC 3908 AP 732 01/31/2018 January A/P Lab supplies 176.00 14,106.82 OXIDOR LABORATORIES LLC 3908 AP 732 01/31/2018 January A/P Lab supplies 246.00 14,352.82 OXIDOR LABORATORIES LLC 3908 AP 732 01/31/2018 January A/P Lab supplies 176.00 14,528.82 OXIDOR LABORATORIES LLC 3908 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 4,345.00 14,528.82 ** 30,000.00 Budgeted 15,471.18 Remaining 48 % Used Account: 135-60010-020-000 Communications/Mobiles 631 01/15/2018 January A/P annual monitoring fee 763.37 276.00 1,039.37 OMNISITE 3852 AP 631 01/15/2018 January A/P phones 382.35 1,421.72 VERIZON WIRELESS 3859 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 BEST BUY 00001487 89.99 1,511.71 BEST BUY 00001487 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 PHONETECH & REPAIR 100.00 1,611.71 PHONETECH & REPAIR PC _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 848.34 1,611.71 ** 4,700.00 Budgeted 3,088.29 Remaining 34 % Used Account: 135-60020-020-000 Electricity 631 01/15/2018 January A/P Electricity 11/27-12/27/17 43,454.93 163.75 43,618.68 TRI COUNTY ELECTRIC 3857 AP 631 01/15/2018 January A/P electricity 1127-12/27/17 268.43 43,887.11 TRI COUNTY ELECTRIC 3857 AP 631 01/15/2018 January A/P electricity 11/27-12/27/17 27.71 43,914.82 TRI COUNTY ELECTRIC 3857 AP 676 01/23/2018 January A/P Electricity 12/7-1/9 483.96 44,398.78 HUDSON ENERGY SERVICES, LLC 3869 AP 676 01/23/2018 January A/P Electricity 12/8-1/10 6,339.58 50,738.36 HUDSON ENERGY SERVICES, LLC 3869 AP 676 01/23/2018 January A/P Electricity 12/18-01/10 293.49 51,031.85 HUDSON ENERGY SERVICES, LLC 3869 AP 732 01/31/2018 January A/P Electricity 12/8-1/10 8,616.50 59,648.35 ENGIE Resources LLC 3893 AP 789 01/31/2018 Jan A/P Electricity 12/7-1/9 30.55 59,678.90 HUDSON ENERGY SERVICES, LLC 3935 AP 789 01/31/2018 Jan A/P Electricity 12/27-1/25 184.85 59,863.75 TRI COUNTY ELECTRIC 3945 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 789 01/31/2018 Jan A/P Electricity 12/27-1/25 43,454.93 297.94 60,161.69 TRI COUNTY ELECTRIC 3945 AP 789 01/31/2018 Jan A/P Electricity 12/27-1/25 27.79 60,189.48 TRI COUNTY ELECTRIC 3945 AP 811 01/31/2018 Town Billed Invoices 1618-1622 AR 20180131-20180131 User: (435.38) 59,754.10 AR _______________ Account: 135-60020-020-000 Electricity Totals: 16,299.17 59,754.10 ** 266,709.00 Budgeted 206,954.90 Remaining 22 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 5,677.00 Budgeted 5,677.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 8.37 .00 8.37 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 8.37 ** 550.00 Budgeted 541.63 Remaining 2 % Used Account: 135-60100-020-000 Travel & per diem 676 01/23/2018 January A/P Tolls to lab 23.17 3.99 27.16 Texas Tollways/TxTag 3879 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 NTTA CALL CENTER 31.12 58.28 NTTA CALL CENTER PC 732 01/31/2018 January A/P Tolls-Lab 14.78 73.06 NTTA 3906 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 49.89 73.06 ** 1,635.00 Budgeted 1,561.94 Remaining 4 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 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 .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 631 01/15/2018 January A/P permit 30,022.52 200.00 30,222.52 TX COMMISSION ENVIRONMENTAL QU 3858 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 TCEQ EPAYMENT 50.00 30,272.52 TCEQ EPAYMENT PC _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 250.00 30,272.52 ** 85,000.00 Budgeted 54,727.48 Remaining 36 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1,770.00 .00 1,770.00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 1,770.00 ** 11,600.00 Budgeted 9,830.00 Remaining 15 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 711 01/31/2018 Texpool Transfers Jan 33,284.43 11,094.81 44,379.24 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 44,379.24 ** 122,043.00 Budgeted 77,663.76 Remaining 36 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 711 01/31/2018 Texpool Transfers Jan 163,292.16 54,430.72 217,722.88 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 217,722.88 ** 598,738.00 Budgeted 381,015.12 Remaining 36 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 711 01/31/2018 Texpool Transfers Jan 30,834.00 10,278.00 41,112.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 41,112.00 ** 123,336.00 Budgeted 82,224.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 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 732 01/31/2018 January A/P Fuel 2,187.19 800.45 2,987.64 US Bank Voyager Fleet Systems 3916 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 800.45 2,987.64 ** 12,500.00 Budgeted 9,512.36 Remaining 24 % Used Account: 135-65010-020-000 Uniforms 1,614.63 .00 1,614.63 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,614.63 ** 4,459.00 Budgeted 2,844.37 Remaining 36 % Used Account: 135-65030-020-000 Chemicals 631 01/15/2018 January A/P Checmicals 665.83 2,760.00 3,425.83 POLYDYNE, INC 3854 AP 631 01/15/2018 January A/P credit from invoice#991750 dat (1,080.00) 2,345.83 POLYDYNE, INC 3854 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 INT*IN *AQUAFIX, INC. 658.48 3,004.31 INT*IN *AQUAFIX, INC. PC 732 01/31/2018 January A/P Chemicals 887.72 3,892.03 Valley Solvent Company, INC 3917 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 3,226.20 3,892.03 ** 27,500.00 Budgeted 23,607.97 Remaining 14 % Used Account: 135-65035-020-000 Small Tools 750 01/26/2018 Pcard 12/27/17 - 01/26/18 WAL-MART #5247 341.41 19.97 361.38 WAL-MART #5247 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 THE HOME DEPOT #6581 147.53 508.91 THE HOME DEPOT #6581 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 THE HOME DEPOT #6581 81.25 590.16 THE HOME DEPOT #6581 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 THE HOME DEPOT #6581 89.91 680.07 THE HOME DEPOT #6581 PC 732 01/31/2018 January A/P tools for repair 403.15 1,083.22 HD SUPPLY FACILITIES MAINT LTD 3897 AP _______________ Account: 135-65035-020-000 Small Tools Totals: 741.81 1,083.22 ** 1,000.00 Budgeted (83.22) Remaining 108 % Used Account: 135-65040-020-000 Safety Equipment .00 .00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-65045-020-000 Lab Supplies 631 01/15/2018 January A/P lab supplies/gloves 3,649.71 162.00 3,811.71 LOU'S GLOVES INCORPORATED 3848 AP 631 01/15/2018 January A/P pipet 205.00 4,016.71 HACH COMPANY 3846 AP 676 01/23/2018 January A/P Lab supplies 457.89 4,474.60 IDEXX DISTRIBUTION, INC 3870 AP 676 01/23/2018 January A/P Lab support 197.92 4,672.52 IDEXX DISTRIBUTION, INC 3870 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 HACH COMPANY 45.77 4,718.29 HACH COMPANY PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,068.58 4,718.29 ** 14,000.00 Budgeted 9,281.71 Remaining 34 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2018 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-020-000 Capital Outlays 676 01/23/2018 January A/P 2017 VFD pump 11,528.49 1,868.44 13,396.93 Star-Telegram Media 3878 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 1,868.44 13,396.93 ** 547,327.00 Budgeted 533,930.07 Remaining 2 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 51,342.00 Budgeted 51,342.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 7,573.00 Budgeted 7,573.00 Remaining 0 % 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 Department 20 Totals: ----------------------------------- 721,128.19 ** 184,123.13 Monthly Total 2,981,140.00 Budgeted 2,260,011.81 Remaining 24 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2018 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 235 01/01/2018 Insurance/Wrk Comp Exp Jan 7.26 2.42 9.68 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 9.68 ** 30.00 Budgeted 20.32 Remaining 32 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 650.00 .00 650.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 650.00 ** 600.00 Budgeted (50.00) Remaining 108 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 1,135.00 .00 1,135.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,135.00 ** 4,000.00 Budgeted 2,865.00 Remaining 28 % Used Account: 135-60100-026-000 Travel & per diem 732 01/31/2018 January A/P AWBD mileage, hotel & parking 289.98 289.98 William Rose 3918 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 289.98 289.98 ** 5,000.00 Budgeted 4,710.02 Remaining 6 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,021.73 .00 1,021.73 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,021.73 ** 2,000.00 Budgeted 978.27 Remaining 51 % Used Department 26 Totals: ----------------------------------- 3,106.39 ** 292.40 Monthly Total 12,980.00 Budgeted 9,873.61 Remaining 24 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 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 600 01/12/2018 MUD PR 01/12/2018 Salaries & Wages 105,210.54 12,652.38 117,862.92 PR 685 01/26/2018 MUD PR 01/26/18 Salaries & Wages 12,500.11 130,363.03 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 25,152.49 130,363.03 ** 432,863.00 Budgeted 302,499.97 Remaining 30 % Used Account: 135-50010-030-000 Overtime 600 01/12/2018 MUD PR 01/12/2018 Overtime 342.42 4.98 347.40 PR 685 01/26/2018 MUD PR 01/26/18 Overtime 44.07 391.47 PR _______________ Account: 135-50010-030-000 Overtime Totals: 49.05 391.47 ** 2,000.00 Budgeted 1,608.53 Remaining 20 % Used Account: 135-50016-030-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 600 01/12/2018 MUD PR 01/12/2018 Retirement 12,398.73 1,170.80 13,569.53 PR 685 01/26/2018 MUD PR 01/26/18 Retirement 1,160.34 14,729.87 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,331.14 14,729.87 ** 40,553.00 Budgeted 25,823.13 Remaining 36 % Used Account: 135-50026-030-000 Medical Insurance 600 01/12/2018 MUD PR 01/12/2018 Medical Insurance 10,757.49 2,072.63 12,830.12 PR 685 01/26/2018 MUD PR 01/26/18 Medical Insurance 2,072.61 14,902.73 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 14,902.73 ** 63,485.00 Budgeted 48,582.27 Remaining 23 % Used Account: 135-50027-030-000 Dental Insurance 600 01/12/2018 MUD PR 01/12/2018 Dental Insurance 990.40 125.76 1,116.16 PR 685 01/26/2018 MUD PR 01/26/18 Dental Insurance 125.74 1,241.90 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 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-030-000 Dental Insurance Totals: 251.50 1,241.90 ** 5,502.00 Budgeted 4,260.10 Remaining 23 % Used Account: 135-50028-030-000 Vision Insurance 600 01/12/2018 MUD PR 01/12/2018 Vision Insurance 213.88 21.28 235.16 PR 685 01/26/2018 MUD PR 01/26/18 Vision Insurance 21.23 256.39 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 256.39 ** 1,173.00 Budgeted 916.61 Remaining 22 % Used Account: 135-50029-030-000 Life Insurance & Other 538 01/04/2018 January A/P STD & LTD Benefits 1,107.66 183.67 1,291.33 METLIFE GROUP BENEFITS 3820 AP 538 01/04/2018 January A/P Benefits-Insurance, Dental, Vi 145.04 1,436.37 Humana Inc 3814 AP 676 01/23/2018 January A/P Flex admin fee 68.00 1,504.37 BenefitMall 3862 AP 730 01/31/2018 Jan PR A/P Rounding adjustment 10.96 1,515.33 Legal Shield 3903 AP 730 01/31/2018 Jan PR A/P Rounding adjustment (.04) 1,515.29 Legal Shield 3903 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 407.63 1,515.29 ** 5,059.00 Budgeted 3,543.71 Remaining 30 % Used Account: 135-50030-030-000 Social Security Taxes 600 01/12/2018 MUD PR 01/12/2018 Social Security Taxes 6,540.23 747.04 7,287.27 PR 685 01/26/2018 MUD PR 01/26/18 Social Security Taxes 737.16 8,024.43 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,484.20 8,024.43 ** 27,181.00 Budgeted 19,156.57 Remaining 30 % Used Account: 135-50035-030-000 Medicare Taxes 600 01/12/2018 MUD PR 01/12/2018 Medicare Taxes 1,529.56 174.71 1,704.27 PR 685 01/26/2018 MUD PR 01/26/18 Medicare Taxes 172.40 1,876.67 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 347.11 1,876.67 ** 6,357.00 Budgeted 4,480.33 Remaining 30 % Used Account: 135-50040-030-000 Unemployment Taxes 600 01/12/2018 MUD PR 01/12/2018 Unemployment Taxes 11.77 12.66 24.43 PR 685 01/26/2018 MUD PR 01/26/18 Unemployment Taxes 12.55 36.98 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 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-030-000 Unemployment Taxes Totals: 25.21 36.98 ** 1,260.00 Budgeted 1,223.02 Remaining 3 % Used Account: 135-50045-030-000 Workman's Compensation 235 01/01/2018 Insurance/Wrk Comp Exp Jan 370.50 123.50 494.00 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 494.00 ** 1,529.00 Budgeted 1,035.00 Remaining 32 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 124.95 .00 124.95 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 124.95 ** 500.00 Budgeted 375.05 Remaining 25 % Used Account: 135-50070-030-000 Employee Relations 740 01/08/2018 Wrong address vendor / reissue Office supplies 2,306.49 (18.99) 2,287.50 COSTCO WHOLESALE 3800 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 HOT & CREAMY DONUTS 43.45 2,330.95 HOT & CREAMY DONUTS PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 TOM THUMB #1789 20.46 2,351.41 TOM THUMB #1789 PC 752 01/31/2018 Jan A/P reissuing check due to wrong r 18.99 2,370.40 Capital One Commercial 3886 AP _______________ Account: 135-50070-030-000 Employee Relations Totals: 63.91 2,370.40 ** 4,960.00 Budgeted 2,589.60 Remaining 48 % Used Account: 135-55030-030-000 Software & Support 631 01/15/2018 January A/P Internet 22,246.09 1,051.94 23,298.03 WHOLESALE CARRIER SERVICES INC 3860 AP 631 01/15/2018 January A/P Outlook license 365 168.00 23,466.03 M3 Networks 3849 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ADOBE SYSTEMS, INC. 32.46 23,498.49 ADOBE SYSTEMS, INC. PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ADOBE SYSTEMS, INC. 19.99 23,518.48 ADOBE SYSTEMS, INC. PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 CANVA FOR WORK MONTHLY 12.95 23,531.43 CANVA FOR WORK MONTHLY PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BILL PAYMENT 63.49 23,594.92 ATT*BILL PAYMENT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BILL PAYMENT 184.68 23,779.60 ATT*BILL PAYMENT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BILL PAYMENT 85.56 23,865.16 ATT*BILL PAYMENT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BILL PAYMENT 111.88 23,977.04 ATT*BILL PAYMENT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ADOBE SYSTEMS INC 16.23 23,993.27 ADOBE SYSTEMS INC PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BILL PAYMENT 63.49 24,056.76 ATT*BILL PAYMENT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BILL PAYMENT 102.08 24,158.84 ATT*BILL PAYMENT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BILL PAYMENT 85.56 24,244.40 ATT*BILL PAYMENT PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 732 01/31/2018 January A/P STW Annual Software lease 22,246.09 15,635.00 39,879.40 STW INC 3909 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 17,633.31 39,879.40 ** 78,391.00 Budgeted 38,511.60 Remaining 51 % Used Account: 135-55070-030-000 Independent Labor 732 01/31/2018 January A/P Gm-January 35,707.42 14,328.15 50,035.57 Carman Consulting LLC. 3919 AP 732 01/31/2018 January A/P Gm-January 6.42 50,041.99 Carman Consulting LLC. 3919 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 14,334.57 50,041.99 ** 154,000.00 Budgeted 103,958.01 Remaining 32 % Used Account: 135-55080-030-000 Maintenance & Repairs 538 01/04/2018 January A/P 568.35 66.47 634.82 G & K SERVICES 3808 AP 631 01/15/2018 January A/P Rug service 66.47 701.29 G & K SERVICES 3844 AP 676 01/23/2018 January A/P Server room A?C repair 92.00 793.29 NORTH TX HEATING & AIR, INC 3875 AP 676 01/23/2018 January A/P Rug service 66.47 859.76 G & K SERVICES 3866 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON MKTPLACE PMTS 109.97 969.73 AMAZON MKTPLACE PMTS PC 752 01/31/2018 Jan A/P Rug service 66.47 1,036.20 G & K SERVICES 3895 AP 767 01/31/2018 Recode Bld Main-Main/Reprs 537 360.00 1,396.20 GL 811 01/31/2018 Town Billed Invoices 1618-1622 AR 20180131-20180131 User: (99.70) 1,296.50 AR _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 728.15 1,296.50 ** 14,000.00 Budgeted 12,703.50 Remaining 9 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 767 01/31/2018 Recode Bld Main-Main/Reprs 537 360.00 (360.00) .00 GL _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: (360.00) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 676 01/23/2018 January A/P Janitorial service 1,158.89 869.06 2,027.95 MEMBER'S BUILDING MAINTENANCE 3874 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 2,027.95 ** 10,000.00 Budgeted 7,972.05 Remaining 20 % Used Account: 135-55160-030-000 Professional Outside Services 56,475.00 .00 56,475.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 56,475.00 ** 63,325.00 Budgeted 6,850.00 Remaining 89 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 752 01/31/2018 Jan A/P January mailings 1,804.45 588.19 2,392.64 DATAPROSE LLC 3890 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 588.19 2,392.64 ** 9,000.00 Budgeted 6,607.36 Remaining 27 % Used Account: 135-60005-030-000 Telephone 558 01/08/2018 January A/P Answering service 2,743.21 217.00 2,960.21 KEYSTONE PARK SECRETARIAL 3817 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BILL PAYMENT 190.95 3,151.16 ATT*BILL PAYMENT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT* BILL PAYMENT 453.57 3,604.73 ATT* BILL PAYMENT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT* BILL PAYMENT 852.49 4,457.22 ATT* BILL PAYMENT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 RINGCENTRAL, INC 13.96 4,471.18 RINGCENTRAL, INC PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BUS PHONE PMT 452.67 4,923.85 ATT*BUS PHONE PMT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BUS PHONE PMT 851.57 5,775.42 ATT*BUS PHONE PMT PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 ATT*BILL PAYMENT 190.26 5,965.68 ATT*BILL PAYMENT PC 732 01/31/2018 January A/P Answering service 195.11 6,160.79 KEYSTONE PARK SECRETARIAL 3901 AP 811 01/31/2018 Town Billed Invoices 1618-1622 AR 20180131-20180131 User: (426.24) 5,734.55 AR _______________ Account: 135-60005-030-000 Telephone Totals: 2,991.34 5,734.55 ** 27,300.00 Budgeted 21,565.45 Remaining 21 % Used Account: 135-60010-030-000 Communications/Mobiles . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 631 01/15/2018 January A/P phones 849.74 87.44 937.18 VERIZON WIRELESS 3859 AP 685 01/26/2018 MUD PR 01/26/18 Communications/Mobiles 150.00 1,087.18 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.44 1,087.18 ** 4,000.00 Budgeted 2,912.82 Remaining 27 % Used Account: 135-60020-030-000 Electricity/Gas 752 01/31/2018 Jan A/P 10/13-11/8 & 11/8-12/8 Electri 644.52 1,053.08 1,697.60 TOWN OF TROPHY CLUB 3913 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,053.08 1,697.60 ** 16,261.00 Budgeted 14,563.40 Remaining 10 % Used Account: 135-60025-030-000 Water 732 01/31/2018 January A/P Water-January 174.30 106.71 281.01 TROPHY CLUB MUD (WATER BILLS) 3914 AP 811 01/31/2018 Town Billed Invoices 1618-1622 AR 20180131-20180131 User: (53.35) 227.66 AR _______________ Account: 135-60025-030-000 Water Totals: 53.36 227.66 ** 2,500.00 Budgeted 2,272.34 Remaining 9 % Used Account: 135-60030-030-000 Rent And/Or Usage 616.40 .00 616.40 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage 676 01/23/2018 January A/P Postage Lease 6,383.11 96.10 6,479.21 FRANCOTYP-POSTALIA, INC. 3865 AP 752 01/31/2018 Jan A/P January mailings 1,544.99 8,024.20 DATAPROSE LLC 3890 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,641.09 8,024.20 ** 30,000.00 Budgeted 21,975.80 Remaining 27 % Used Account: 135-60040-030-000 Service Charges & Fees 601 01/12/2018 Child Support Fee 16,454.30 1.50 16,455.80 GL 675 01/26/2018 Child Support Fee 1.50 16,457.30 GL 723 01/31/2018 Pace Credit Card Fees 4,632.95 21,090.25 GL 723 01/31/2018 Pace Credit Card Fees 142.64 21,232.89 GL 732 01/31/2018 January A/P Direct send fees 50.00 21,282.89 Fiserv Solutions, LLC 3894 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,828.59 21,282.89 ** 55,560.00 Budgeted 34,277.11 Remaining 38 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 235 01/01/2018 Insurance/Wrk Comp Exp Jan 18,301.08 6,100.36 24,401.44 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 24,401.44 ** 56,000.00 Budgeted 31,598.56 Remaining 44 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 538 01/04/2018 January A/P DUes-2018 135.00 3,566.25 3,701.25 Texas Rural Water Assoc 3828 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 3,566.25 3,701.25 ** 6,000.00 Budgeted 2,298.75 Remaining 62 % Used Account: 135-60075-030-000 Meetings 48.62 .00 48.62 _______________ Account: 135-60075-030-000 Meetings Totals: .00 48.62 ** 400.00 Budgeted 351.38 Remaining 12 % Used Account: 135-60079-030-000 Public Education .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 2,608.00 .00 2,608.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,608.00 ** 7,600.00 Budgeted 4,992.00 Remaining 34 % Used Account: 135-60100-030-000 Travel & per diem 685 01/26/2018 MUD PR 01/26/18 Travel & per diem 440.52 29.32 469.84 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 29.32 469.84 ** 4,885.00 Budgeted 4,415.16 Remaining 10 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 145.00 .00 145.00 _______________ Account: 135-60115-030-000 Elections Totals: .00 145.00 ** 4,500.00 Budgeted 4,355.00 Remaining 3 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security 732 01/31/2018 January A/P Monthly monitoring for panic b 24.00 24.00 Digital Air Control, Inc 3892 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60235-030-000 Security Totals: 24.00 24.00 ** 2,700.00 Budgeted 2,676.00 Remaining 1 % Used Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 211.99 .00 211.99 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 211.99 ** 2,500.00 Budgeted 2,288.01 Remaining 8 % Used Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 700.00 Budgeted 700.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 597.95 .00 597.95 _______________ Account: 135-65055-030-000 Hardware Totals: .00 597.95 ** 7,420.00 Budgeted 6,822.05 Remaining 8 % Used Account: 135-65085-030-000 Office Supplies 631 01/15/2018 January A/P Office supplies 1,962.80 68.69 2,031.49 OFFICE DEPOT, INC 3851 AP 631 01/15/2018 January A/P office supplies 35.37 2,066.86 OFFICE DEPOT, INC 3851 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 750 01/26/2018 Pcard 12/27/17 - 01/26/18 KELLER TROPHY AND AWAR 1,962.80 10.00 2,076.86 KELLER TROPHY AND AWAR PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 TOM THUMB #1789 7.99 2,084.85 TOM THUMB #1789 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 STAPLES 00111641 154.93 2,239.78 STAPLES 00111641 PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 MICHAELS KEYS 15.99 2,255.77 MICHAELS KEYS PC 732 01/31/2018 January A/P Office supplies and paper 219.78 2,475.55 OFFICE DEPOT, INC 3907 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 512.75 2,475.55 ** 7,000.00 Budgeted 4,524.45 Remaining 35 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON.COM 1,658.06 244.99 1,903.05 AMAZON.COM PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 244.99 1,903.05 ** 2,000.00 Budgeted 96.95 Remaining 95 % Used Account: 135-65095-030-000 Maintenance Supplies 740 01/08/2018 Wrong address vendor / reissue Office supplies 1,157.28 (17.56) 1,139.72 COSTCO WHOLESALE 3800 AP 750 01/26/2018 Pcard 12/27/17 - 01/26/18 COFFEEICON COM 39.98 1,179.70 COFFEEICON COM PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON MKTPLACE PMTS 44.96 1,224.66 AMAZON MKTPLACE PMTS PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON.COM 21.52 1,246.18 AMAZON.COM PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON MKTPLACE PMTS 19.65 1,265.83 AMAZON MKTPLACE PMTS PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON MKTPLACE PMTS (17.96) 1,247.87 AMAZON MKTPLACE PMTS PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 SAMSCLUB.COM 37.25 1,285.12 SAMSCLUB.COM PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 SAMSCLUB.COM 156.40 1,441.52 SAMSCLUB.COM PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON MKTPLACE PMTS 50.40 1,491.92 AMAZON MKTPLACE PMTS PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON MKTPLACE PMTS 70.29 1,562.21 AMAZON MKTPLACE PMTS PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON MKTPLACE PMTS 27.91 1,590.12 AMAZON MKTPLACE PMTS PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 AMAZON MKTPLACE PMTS 76.03 1,666.15 AMAZON MKTPLACE PMTS PC 750 01/26/2018 Pcard 12/27/17 - 01/26/18 WALMART.COM 45.78 1,711.93 WALMART.COM PC 752 01/31/2018 Jan A/P reissuing check due to wrong r 17.56 1,729.49 Capital One Commercial 3886 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 572.21 1,729.49 ** 4,000.00 Budgeted 2,270.51 Remaining 43 % Used Account: 135-65105-030-000 Printing 144.00 .00 144.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2018 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-030-000 Capital Outlays 7,841.00 .00 7,841.00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 7,841.00 ** 13,000.00 Budgeted 5,159.00 Remaining 60 % Used Account: 135-69170-030-000 Copier Lease Installments 631 01/15/2018 January A/P Copier lease payment 644.67 194.00 838.67 EVERBANK COMMERCIAL FINANCE 3843 AP 676 01/23/2018 January A/P Copies 132.56 971.23 KYOCERA DOCUMENT SOLUTIONS 3871 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 326.56 971.23 ** 4,600.00 Budgeted 3,628.77 Remaining 21 % Used Department 30 Totals: ----------------------------------- 417,931.98 ** 90,398.11 Monthly Total 1,227,112.00 Budgeted 809,180.02 Remaining 34 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2018 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 Legal 631 01/15/2018 January A/P legal 17,258.99 6,570.00 23,828.99 McLean & Howard, L.L.P. 3850 AP 631 01/15/2018 January A/P Legal 1,050.00 24,878.99 McLean & Howard, L.L.P. 3850 AP 818 01/31/2018 January A/P Legal 3,414.56 28,293.55 McLean & Howard, L.L.P. 3948 AP 818 01/31/2018 January A/P Legal- Board Meeting 1,050.00 29,343.55 McLean & Howard, L.L.P. 3948 AP _______________ Account: 135-55045-039-000 Legal Totals: 12,084.56 29,343.55 ** 137,000.00 Budgeted 107,656.45 Remaining 21 % Used Account: 135-55055-039-000 Auditing 676 01/23/2018 January A/P Audit (final) FYE 17 14,400.00 11,108.70 25,508.70 LAFOLLETT & ABBOTT PLLC 3873 AP _______________ Account: 135-55055-039-000 Auditing Totals: 11,108.70 25,508.70 ** 24,500.00 Budgeted (1,008.70) Remaining 104 % Used Account: 135-55060-039-000 Appraisal 4,660.18 .00 4,660.18 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,660.18 ** 11,446.00 Budgeted 6,785.82 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 2,968.40 .00 2,968.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,968.40 ** 3,800.00 Budgeted 831.60 Remaining 78 % Used Department 39 Totals: ----------------------------------- 62,480.83 ** 23,193.26 Monthly Total 176,746.00 Budgeted 114,265.17 Remaining 35 % Used Fund 135 Totals: ----------------------------------- (322,415.12) 48,048.26 Monthly Total (194,618.00) Budgeted 127,797.12 Remaining 166 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (105,000.00) .00 (105,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (186,420.00) ** .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET JANUARY 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 1,298,892 ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,298,892 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 680,448 TOTAL LIABILITIES 680,448 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (374,135) TOTAL FUND BALANCE 618,444 TOTAL LIABILITIES AND FUND BALANCE 1,298,892 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 22:48 02/14/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,457.58- 5,861.16- 5,861.16 Subtotal: 1,457.58- 5,861.16- 5,861.16 Program number: 1,457.58- 5,861.16- 5,861.16 Department number: Revenues 1,457.58- 5,861.16- 5,861.16 Revenues Subtotal ----------- 1,457.58- 5,861.16- 5,861.16 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 22:48 02/14/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 24,660.50 379,996.28 379,996.28- Subtotal: 24,660.50 379,996.28 379,996.28- Program number: 24,660.50 379,996.28 379,996.28- Department number: Wastewater 24,660.50 379,996.28 379,996.28- Expenditures Subtotal ----------- 24,660.50 379,996.28 379,996.28- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 23,202.92 374,135.12 374,135.12- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2018 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 802 01/31/2018 Bank Interest- January (4,403.58) (1,457.58) (5,861.16) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,457.58) (5,861.16) ** .00 Budgeted 5,861.16 Remaining 0 % Used Department Totals: ----------------------------------- (5,861.16) ** (1,457.58) Monthly Total .00 Budgeted 5,861.16 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2018 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 631 01/15/2018 January A/P WWTP Upgrades 355,335.78 24,660.50 379,996.28 CP&Y/WALLACE GROUP, INC. 3842 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 24,660.50 379,996.28 ** .00 Budgeted (379,996.28) Remaining 0 % Used Department 20 Totals: ----------------------------------- 379,996.28 ** 24,660.50 Monthly Total .00 Budgeted (379,996.28) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 374,135.12 23,202.92 Monthly Total .00 Budgeted (374,135.12) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET JANUARY 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 4,496,529 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,496,529 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 270,948 TOTAL LIABILITIES 270,948 FUND BALANCE ASSIGNED FUND BALANCE 4,225,581 NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE 4,225,581 TOTAL LIABILITIES AND FUND BALANCE 4,496,529 TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET JANUARY 2018 520 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 39,899 TOTAL LIABILITIES 39,899 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE (39,899) TOTAL LIABILITIES AND FUND BALANCE 0 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JANUARY 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 485,757 ACCOUNTS RECEIVABLE - TOTAL ASSETS 485,757 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,578 NET REVENUES / EXPENDITURES 59,179 TOTAL FUND BALANCE 485,757 TOTAL LIABILITIES AND FUND BALANCE 485,757 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 22:48 02/14/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 1,000.00- 1,000.00- 519.98- 1,734.68- 173.468 734.68 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 16,332.00- 33.333 32,664.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 41,112.00- 33.333 82,224.00- Subtotal: 173,332.00- 173,332.00- 14,880.98- 59,178.68- 34.142 114,153.32- Program number: 173,332.00- 173,332.00- 14,880.98- 59,178.68- 34.142 114,153.32- Department number: 173,332.00- 173,332.00- 14,880.98- 59,178.68- 34.142 114,153.32- Revenues Subtotal ----------- 173,332.00- 173,332.00- 14,880.98- 59,178.68- 34.142 114,153.32- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 14,880.98- 59,178.68- 34.142 114,153.32- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 802 01/31/2018 Bank Interest- January (1,214.70) (519.98) (1,734.68) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (519.98) (1,734.68) ** (1,000.00) Budgeted 734.68 Remaining 173 % Used Account: 528-49142-000-000 Interfund transfer in-Water 711 01/31/2018 Texpool Transfers Jan (12,249.00) (4,083.00) (16,332.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (16,332.00) ** (48,996.00) Budgeted (32,664.00) Remaining 33 % Used Account: 528-49143-000-000 Interfund transfer in-WW 711 01/31/2018 Texpool Transfers Jan (30,834.00) (10,278.00) (41,112.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (41,112.00) ** (123,336.00) Budgeted (82,224.00) Remaining 33 % Used Department Totals: ----------------------------------- (59,178.68) ** (14,880.98) Monthly Total (173,332.00) Budgeted (114,153.32) Remaining 34 % Used Fund 528 Totals: ----------------------------------- (59,178.68) (14,880.98) Monthly Total (173,332.00) Budgeted (114,153.32) Remaining 34 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JANUARY 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 689,921 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 75,145 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 769,639 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 75,145 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 75,145 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 662,153 TOTAL FUND BALANCE 694,494 TOTAL LIABILITIES AND FUND BALANCE 769,639 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 22:48 02/14/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 669,660.00- 669,660.00- 224,670.77- 614,822.33- 91.811 54,837.67- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 162.61- 1,854.88- 103.049 54.88 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 29.27- 277.27- 13.864 1,722.73- Subtotal: 673,460.00- 673,460.00- 224,862.65- 616,954.48- 91.610 56,505.52- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 576.01- 819.05- 40.953 1,180.95- 533-49015-000-000 Lease/Rental Income 218,954.00- 218,954.00- 218,954.00- 533-49141-000-000 Interfund Trans In-PID Surchg 122,043.00- 122,043.00- 11,094.81- 44,379.24- 36.364 77,663.76- Subtotal: 342,997.00- 342,997.00- 11,670.82- 45,198.29- 13.177 297,798.71- Program number: 1,016,457.00- 1,016,457.00- 236,533.47- 662,152.77- 65.143 354,304.23- Department number: Revenues 1,016,457.00- 1,016,457.00- 236,533.47- 662,152.77- 65.143 354,304.23- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 236,533.47- 662,152.77- 65.143 354,304.23- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 22:48 02/14/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2018 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 2,150.00 533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 283,508.00 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 Subtotal: 1,010,658.00 1,010,658.00 1,010,658.00 Program number: 1,010,658.00 1,010,658.00 1,010,658.00 Department number: Administration 1,010,658.00 1,010,658.00 1,010,658.00 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 1,010,658.00 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 236,533.47- 662,152.77- ############### 656,353.77 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 764 01/02/2018 Property Taxes (390,151.56) (15,750.31) (405,901.87) GL 770 01/02/2018 Property Taxes (15,497.92) (421,399.79) GL 765 01/03/2018 Property Taxes (9,745.19) (431,144.98) GL 766 01/04/2018 Property Taxes (14,698.21) (445,843.19) GL 771 01/08/2018 Property Taxes (9,159.85) (455,003.04) GL 772 01/09/2018 Property Taxes (11,204.94) (466,207.98) GL 773 01/10/2018 Property Taxes (4,663.87) (470,871.85) GL 774 01/11/2018 Property Taxes (5,487.44) (476,359.29) GL 775 01/12/2018 Property Taxes (2,938.27) (479,297.56) GL 776 01/16/2018 Property Taxes (2,606.18) (481,903.74) GL 777 01/17/2018 Property Taxes (8,806.52) (490,710.26) GL 778 01/18/2018 Property Taxes (3,020.83) (493,731.09) GL 779 01/19/2018 Property Taxes (2,596.62) (496,327.71) GL 780 01/19/2018 Property Taxes (7,420.02) (503,747.73) GL 781 01/23/2018 Property Taxes (11,412.89) (515,160.62) GL 783 01/24/2018 Property Taxes (2,680.29) (517,840.91) GL 784 01/25/2018 Property Taxes (29,624.02) (547,464.93) GL 785 01/26/2018 Property Taxes (5,041.27) (552,506.20) GL 786 01/30/2018 Property Taxes (36,251.44) (588,757.64) GL 787 01/30/2018 Property Taxes (15,943.14) (604,700.78) GL 788 01/31/2018 Property Taxes (10,121.55) (614,822.33) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (224,670.77) (614,822.33) ** (669,660.00) Budgeted (54,837.67) Remaining 92 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 766 01/04/2018 Property Taxes (1,692.27) (3.39) (1,695.66) GL 772 01/09/2018 Property Taxes (105.45) (1,801.11) GL 773 01/10/2018 Property Taxes (3.16) (1,804.27) GL 777 01/17/2018 Property Taxes (10.53) (1,814.80) GL 783 01/24/2018 Property Taxes (.54) (1,815.34) GL 785 01/26/2018 Property Taxes (39.49) (1,854.83) GL 787 01/30/2018 Property Taxes (.05) (1,854.88) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (162.61) (1,854.88) ** (1,800.00) Budgeted 54.88 Remaining 103 % Used Account: 533-40015-000-000 Property Taxes/P & I 766 01/04/2018 Property Taxes (248.00) (1.50) (249.50) GL 772 01/09/2018 Property Taxes (24.25) (273.75) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 773 01/10/2018 Property Taxes (248.00) (.76) (274.51) GL 777 01/17/2018 Property Taxes (2.53) (277.04) GL 783 01/24/2018 Property Taxes (.20) (277.24) GL 787 01/30/2018 Property Taxes (.03) (277.27) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (29.27) (277.27) ** (2,000.00) Budgeted (1,722.73) Remaining 14 % Used Account: 533-49010-000-000 Interest Income 802 01/31/2018 Bank Interest- January (243.04) (576.01) (819.05) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (576.01) (819.05) ** (2,000.00) Budgeted (1,180.95) Remaining 41 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (218,954.00) Budgeted (218,954.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 711 01/31/2018 Texpool Transfers Jan (33,284.43) (11,094.81) (44,379.24) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (44,379.24) ** (122,043.00) Budgeted (77,663.76) Remaining 36 % Used Department Totals: ----------------------------------- (662,152.77) ** (236,533.47) Monthly Total (1,016,457.00) Budgeted (354,304.23) Remaining 65 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2018 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 .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,150.00 Budgeted 2,150.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 283,508.00 Budgeted 283,508.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 725,000.00 Budgeted 725,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 1,010,658.00 Budgeted 1,010,658.00 Remaining 0 % Used Fund 533 Totals: ----------------------------------- (662,152.77) (236,533.47) Monthly Total (5,799.00) Budgeted 656,353.77 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JANUARY 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 234,350 ACCOUNTS RECEIVABLE - TOTAL ASSETS 234,350 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 218,140 TOTAL FUND BALANCE 234,350 TOTAL LIABILITIES AND FUND BALANCE 234,350 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 22:48 02/14/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 1/2018 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- 200.25- 416.38- 41.638 583.62- 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 217,722.88- 36.364 381,015.12- Subtotal: 599,738.00- 599,738.00- 54,630.97- 218,139.26- 36.372 381,598.74- Program number: 599,738.00- 599,738.00- 54,630.97- 218,139.26- 36.372 381,598.74- Department number: Revenues 599,738.00- 599,738.00- 54,630.97- 218,139.26- 36.372 381,598.74- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,630.97- 218,139.26- 36.372 381,598.74- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 22:48 02/14/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 223,338.00 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 Subtotal: 598,738.00 598,738.00 598,738.00 Program number: 598,738.00 598,738.00 598,738.00 Department number: Administration 598,738.00 598,738.00 598,738.00 Expenditures Subtotal ----------- 598,738.00 598,738.00 598,738.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 54,630.97- 218,139.26- ############### 217,139.26 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 802 01/31/2018 Bank Interest- January (216.13) (200.25) (416.38) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (200.25) (416.38) ** (1,000.00) Budgeted (583.62) Remaining 42 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 711 01/31/2018 Texpool Transfers Jan (163,292.16) (54,430.72) (217,722.88) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (217,722.88) ** (598,738.00) Budgeted (381,015.12) Remaining 36 % Used Department Totals: ----------------------------------- (218,139.26) ** (54,630.97) Monthly Total (599,738.00) Budgeted (381,598.74) Remaining 36 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 1/2018 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 .00 .00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 223,338.00 Budgeted 223,338.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 375,000.00 Budgeted 375,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 598,738.00 Budgeted 598,738.00 Remaining 0 % Used Fund 534 Totals: ----------------------------------- (218,139.26) (54,630.97) Monthly Total (1,000.00) Budgeted 217,139.26 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JANUARY 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 102,241 ACCOUNTS RECEIVABLE - TOTAL ASSETS 102,241 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 101,289 TOTAL FUND BALANCE 102,241 TOTAL LIABILITIES AND FUND BALANCE 102,241 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 22:48 02/14/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 600.00- 600.00- 85.73- 168.14- 28.023 431.86- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 101,121.24- 36.364 176,962.76- Subtotal: 278,684.00- 278,684.00- 25,366.04- 101,289.38- 36.346 177,394.62- Program number: 278,684.00- 278,684.00- 25,366.04- 101,289.38- 36.346 177,394.62- Department number: Revenues 278,684.00- 278,684.00- 25,366.04- 101,289.38- 36.346 177,394.62- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,366.04- 101,289.38- 36.346 177,394.62- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 22:48 02/14/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 1/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 62,684.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: 278,084.00 278,084.00 278,084.00 Program number: 278,084.00 278,084.00 278,084.00 Department number: Administration 278,084.00 278,084.00 278,084.00 Expenditures Subtotal ----------- 278,084.00 278,084.00 278,084.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,366.04- 101,289.38- ############### 100,689.38 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 1/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 802 01/31/2018 Bank Interest- January (82.41) (85.73) (168.14) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (85.73) (168.14) ** (600.00) Budgeted (431.86) Remaining 28 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 711 01/31/2018 Texpool Transfers Jan (75,840.93) (25,280.31) (101,121.24) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (101,121.24) ** (278,084.00) Budgeted (176,962.76) Remaining 36 % Used Department Totals: ----------------------------------- (101,289.38) ** (25,366.04) Monthly Total (278,684.00) Budgeted (177,394.62) Remaining 36 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 22:49 02/14/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 1/2018 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 .00 .00 _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 62,684.00 Budgeted 62,684.00 Remaining 0 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 215,000.00 Budgeted 215,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 278,084.00 Budgeted 278,084.00 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (101,289.38) (25,366.04) Monthly Total (600.00) Budgeted 100,689.38 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (1,730,143.72) **** (563,552.50) Monthly Total (375,349.00) Budgeted 1,354,794.72 Remaining 461 % Used ******* End of Report *********