Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-12 Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET DECEMBER 2017 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 762,115 PREPAID EXPENSES 11,429 ADVALOREM PROPERTY TAXES RECEIVABLE 473,804 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,247,348 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 473,804 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 473,804 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 251,291 TOTAL FUND BALANCE 773,544 TOTAL LIABILITIES AND FUND BALANCE 1,247,348 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 20:22 01/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept.Department: Fire Revenues Program: Period Ending: 12/2017 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-567,258.11- 614,333.82-58.262 440,099.18- 122-40011-000-000 Property Taxes/Fire-Delinquent 323.08- 2,577.30-2,577.30 122-40020-000-000 Property Taxes/Fire P&I 138.42-476.49-476.49 Subtotal:1,054,433.00- 1,054,433.00-567,719.61- 617,387.61-58.552 437,045.39- Program number:1,054,433.00- 1,054,433.00-567,719.61- 617,387.61-58.552 437,045.39- Department number: Fire Revenues 1,054,433.00- 1,054,433.00-567,719.61- 617,387.61-58.552 437,045.39- Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00-567,719.61- 617,387.61-58.552 437,045.39- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 20:22 01/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2017 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 3,809.61 21.165 14,190.39 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 152,227.50 25.000 456,682.50 Subtotal: 845,864.00 845,864.00 52,012.37 156,037.11 18.447 689,826.89 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 366,096.20 34.720 688,336.80 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 366,096.20 34.720 688,336.80 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 366,096.20 34.720 688,336.80 Fund number: 122 Trophy Club MUD Fire Dept. 515,707.24- 251,291.41- 251,291.41 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2017 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 576 12/01/2017 Property Taxes (47,075.71) (802.26) (47,877.97) GL 577 12/04/2017 Property Taxes (2,499.45) (50,377.42) GL 578 12/05/2017 Property Taxes (2,849.13) (53,226.55) GL 579 12/06/2017 Property Taxes (6,625.57) (59,852.12) GL 580 12/07/2017 Property Taxes (3,234.39) (63,086.51) GL 617 12/07/2017 Property Taxes (3,234.39) (66,320.90) GL 618 12/07/2017 Reverse Property Taxes 580 3,234.39 (63,086.51) GL 581 12/08/2017 Property Taxes (5,640.99) (68,727.50) GL 582 12/11/2017 Property Taxes (8,531.98) (77,259.48) GL 583 12/12/2017 Property Taxes (7,685.37) (84,944.85) GL 610 12/12/2017 Property Taxes (7,685.37) (92,630.22) GL 611 12/12/2017 Reverse Property Tax 583 7,685.37 (84,944.85) GL 584 12/13/2017 Property Taxes (7,506.66) (92,451.51) GL 585 12/14/2017 Property Taxes (7,223.89) (99,675.40) GL 586 12/15/2017 Property Taxes (6,336.82) (106,012.22) GL 587 12/18/2017 Property Taxes (249,349.46) (355,361.68) GL 614 12/18/2017 Property Taxes (249,349.46) (604,711.14) GL 615 12/18/2017 Reverse Property Tax 587 249,349.46 (355,361.68) GL 588 12/19/2017 Property Taxes (4,865.25) (360,226.93) GL 589 12/20/2017 Property Taxes (11,675.27) (371,902.20) GL 590 12/21/2017 Property Taxes (3,990.48) (375,892.68) GL 591 12/22/2017 Property Taxes (21,870.81) (397,763.49) GL 612 12/22/2017 Property Taxes (21,870.81) (419,634.30) GL 613 12/22/2017 Reverse Property Tax 591 21,870.81 (397,763.49) GL 592 12/27/2017 Property Taxes (105,227.68) (502,991.17) GL 593 12/28/2017 Property Taxes (92,941.73) (595,932.90) GL 594 12/29/2017 Property Taxes (18,400.92) (614,333.82) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (567,258.11) (614,333.82) ** (1,054,433.00) Budgeted (440,099.18) Remaining 58 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 577 12/04/2017 Property Taxes (2,254.22) (25.01) (2,279.23) GL 578 12/05/2017 Property Taxes (13.40) (2,292.63) GL 579 12/06/2017 Property Taxes (4.63) (2,297.26) GL 580 12/07/2017 Property Taxes (.01) (2,297.27) GL 617 12/07/2017 Property Taxes (.01) (2,297.28) GL 618 12/07/2017 Reverse Property Taxes 580 .01 (2,297.27) GL 585 12/14/2017 Property Taxes 144.22 (2,153.05) GL 589 12/20/2017 Property Taxes (77.43) (2,230.48) GL 591 12/22/2017 Property Taxes (256.19) (2,486.67) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept.Department: Fire Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 612 12/22/2017 Property Taxes (2,254.22)(256.19) (2,742.86)GL 613 12/22/2017 Reverse Property Tax 591 256.19 (2,486.67)GL 592 12/27/2017 Property Taxes (90.63) (2,577.30)GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals:(323.08) (2,577.30) ** .00 Budgeted 2,577.30 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 577 12/04/2017 Property Taxes (338.07)(11.76)(349.83)GL 578 12/05/2017 Property Taxes (4.01)(353.84)GL 579 12/06/2017 Property Taxes (1.07)(354.91)GL 582 12/11/2017 Property Taxes (3.07)(357.98)GL 587 12/18/2017 Property Taxes (17.74)(375.72)GL 614 12/18/2017 Property Taxes (17.73)(393.45)GL 615 12/18/2017 Reverse Property Tax 587 17.74 (375.71)GL 589 12/20/2017 Property Taxes (17.89)(393.60)GL 591 12/22/2017 Property Taxes (58.92)(452.52)GL 612 12/22/2017 Property Taxes (58.92)(511.44)GL 613 12/22/2017 Reverse Property Tax 591 58.92 (452.52)GL 592 12/27/2017 Property Taxes (23.73)(476.25)GL 593 12/28/2017 Property Taxes (.24)(476.49)GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals:(138.42)(476.49) ** .00 Budgeted 476.49 Remaining 0 % Used Department Totals: -----------------------------------(617,387.61) ** (567,719.61) Monthly Total (1,054,433.00) Budgeted (437,045.39) Remaining 59 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2017 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 234 12/01/2017 Insurance/Wrk Comp Exp Dec 2,539.74 1,269.87 3,809.61 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 3,809.61 ** 18,000.00 Budgeted 14,190.39 Remaining 21 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 422 12/08/2017 Dec A/P Dec Fire Admin 101,485.00 50,742.50 152,227.50 TOWN OF TROPHY CLUB 3788 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 152,227.50 ** 608,910.00 Budgeted 456,682.50 Remaining 25 % 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: ----------------------------------- 366,096.20 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 688,336.80 Remaining 35 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2017 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: ----------------------------------- (251,291.41) (515,707.24) Monthly Total .00 Budgeted 251,291.41 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET DECEMBER 2017 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,654,954 - 1,654,954 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,332 - 714,332 INVESTMENTS-TEXPOOL 1,304,616 596,426 1,901,042 PREPAID EXPENSES 79,754 - 79,754 ADVALOREM PROPERTY TAXES RECEIVABLE 54,267 - 54,267 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,097,819 - 1,097,819 TOTAL ASSETS 5,523,150 596,426 6,119,576 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 54,267 - 54,267 ACCOUNTS AND OTHER PAYABLES 633,955 - 633,955 CUSTOMER DEPOSITS 314,100 - 314,100 - TOTAL LIABILITIES 1,002,322 - 1,002,322 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 370,461 - 370,461 - TOTAL FUND BALANCE 4,520,829 596,426 5,117,254 TOTAL LIABILITIES AND FUND BALANCE 5,523,150 596,426 6,119,576 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 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- 65,065.41- 70,465.06- 58.260 50,484.94- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 33.53- 169.68- 84.840 30.32- 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 13.85- 35.84- 17.920 164.16- 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 65,112.79- 70,670.58- 23.621 228,518.42- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 357,013.62- 1,289,167.00- 19.944 5,174,852.00- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 235,176.30- 706,218.09- 23.714 2,271,848.91- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 14,594.33- 37,694.57- 35.468 68,584.43- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,400.00- 3,550.00- 16.628 17,800.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 600.00- 1,050.00- 70.000 450.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 1,000.00- 2,350.00- 52.222 2,150.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 8,570.40- 9,117.60- 15.196 50,882.40- Subtotal: 9,635,715.00- 9,635,715.00- 618,354.65- 2,049,147.26- 21.266 7,586,567.74- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 3,355.22- 8,510.13- 70.918 3,489.87- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 2,868.15- 26.251 8,057.85- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,749.99- 25.000 5,250.01- 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- 3,260.76- 6,347.76- 34.918 11,831.24- 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 1,787.51- 5,463.23- 109.265 463.23 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- 9,965.63- 24,939.26- 7.914 290,185.74- Program number: 10,250,029.00- 10,250,029.00- 693,433.07- 2,144,757.10- 20.924 8,105,271.90- Department number: Revenues 10,250,029.00- 10,250,029.00- 693,433.07- 2,144,757.10- 20.924 8,105,271.90- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 693,433.07- 2,144,757.10- 20.924 8,105,271.90- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 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 22,451.76 47,819.61 17.435 226,459.39 135-50010-010-000 Overtime 20,000.00 20,000.00 1,324.39 1,935.33 9.677 18,064.67 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 150.00 550.00 16.667 2,750.00 135-50020-010-000 Retirement 27,843.00 27,843.00 2,213.17 6,369.34 22.876 21,473.66 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 1,889.76 6,850.39 13.124 45,345.61 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 205.93 711.62 13.733 4,470.38 135-50028-010-000 Vision Insurance 994.00 994.00 40.17 143.14 14.400 850.86 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 147.20 639.97 21.461 2,342.03 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,476.62 3,298.75 17.676 15,363.25 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 345.33 771.48 17.674 3,593.52 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 1.25 8.68 .804 1,071.32 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 2,699.76 22.775 9,154.24 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 163.05 163.05 81.525 36.95 135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 31,308.55 75,290.11 17.646 351,371.89 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 14,394.55 18,477.92 18.478 81,522.08 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 95.71 1,267.13 31.678 2,732.87 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 200.00 1,330.74 24.195 4,169.26 Subtotal: 391,000.00 391,000.00 14,690.26 21,075.79 5.390 369,924.21 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 320.79 640.34 13.624 4,059.66 135-60020-010-000 Electricity 175,356.00 175,356.00 11,225.68 38,530.00 21.972 136,826.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 2,785.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 166,739.52 374,798.62 13.276 2,448,371.38 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 214.70 7.157 2,785.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 75,840.93 27.273 202,243.07 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 12,249.00 25.000 36,747.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 5,019.66 200.786 2,519.66- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 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 212,668.96 517,324.74 14.315 3,096,527.26 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 777.27 2,196.98 14.647 12,803.02 135-65010-010-000 Uniforms 4,488.00 4,488.00 332.42 829.64 18.486 3,658.36 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,104.88 3,712.54 18.563 16,287.46 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 50,000.00 135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 84,000.00 Subtotal: 175,688.00 175,688.00 2,214.57 6,739.16 3.836 168,948.84 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 9,573.61 63,982.86 7.899 746,029.14 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 41,944.38 107,864.38 90.814 10,910.62 Subtotal: 1,048,231.00 1,048,231.00 51,517.99 246,847.24 23.549 801,383.76 Program number: 5,655,433.00 5,655,433.00 312,400.33 867,277.04 15.335 4,788,155.96 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/2017 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 80.00 376.19 18.810 1,623.81 Subtotal: 2,000.00 2,000.00 80.00 376.19 18.810 1,623.81 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 80.00 376.19 18.810 1,623.81 Department number: Water 5,657,433.00 5,657,433.00 312,480.33 867,653.23 15.337 4,789,779.77 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 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 46,019.02 92,099.60 22.416 318,766.40 135-50010-020-000 Overtime 30,000.00 30,000.00 2,691.33 6,688.37 22.295 23,311.63 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,025.00 24.107 6,375.00 135-50020-020-000 Retirement 42,243.00 42,243.00 4,570.46 11,475.54 27.166 30,767.46 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 4,710.20 14,130.60 22.727 48,044.40 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 399.32 1,197.96 22.727 4,073.04 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 84.33 252.99 22.710 861.01 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 361.15 1,149.43 26.850 3,131.57 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 2,933.90 6,374.14 22.512 21,939.86 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 686.16 1,490.73 22.512 5,131.27 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 4,044.00 22.479 13,946.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 64,503.87 148,343.36 23.674 478,257.64 135-55070-020-000 Independent Labor 20,550.00 20,550.00 20,550.00 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 714.10 7,070.32 8.212 79,029.68 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 179.47 2,828.19 35.352 5,171.81 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 7,213.77 15,113.25 25.189 44,886.75 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,356.00 10,183.82 33.946 19,816.18 Subtotal:219,150.00 219,150.00 10,463.34 35,224.36 16.073 183,925.64 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 381.81 763.37 16.242 3,936.63 135-60020-020-000 Electricity 266,709.00 266,709.00 16,458.64 43,454.93 16.293 223,254.07 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 23.17 1.417 1,611.83 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 4,711.25- 30,022.52 35.321 54,977.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 33,284.43 27.273 88,758.57 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 163,292.16 27.273 435,445.84 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 30,834.00 25.000 92,502.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 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 87,932.73 303,452.95 21.089 1,135,485.05 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 653.58 2,187.19 17.498 10,312.81 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 660.48 665.83 2.421 26,834.17 135-65035-020-000 Small Tools 1,000.00 1,000.00 93.65 341.41 34.141 658.59 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,513.08 3,649.71 26.069 10,350.29 Subtotal: 60,209.00 60,209.00 2,920.79 8,458.77 14.049 51,750.23 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 1,657.50 11,528.49 2.106 535,798.51 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,657.50 41,528.49 6.527 594,713.51 Program number: 2,981,140.00 2,981,140.00 167,478.23 537,007.93 18.014 2,444,132.07 Department number: Wastewater 2,981,140.00 2,981,140.00 167,478.23 537,007.93 18.014 2,444,132.07 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2017 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 7.26 24.200 22.74 Subtotal: 30.00 30.00 2.42 7.26 24.200 22.74 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 445.00 1,135.00 28.375 2,865.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,021.73 1,021.73 51.087 978.27 Subtotal: 12,950.00 12,950.00 1,466.73 2,806.73 21.674 10,143.27 Program number: 12,980.00 12,980.00 1,469.15 2,813.99 21.679 10,166.01 Department number: Board of Directors 12,980.00 12,980.00 1,469.15 2,813.99 21.679 10,166.01 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 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 58,622.84 105,210.54 24.306 327,652.46 135-50010-030-000 Overtime 2,000.00 2,000.00 168.22 342.42 17.121 1,657.58 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 5,438.16 12,398.73 30.574 28,154.27 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 3,822.05 10,757.49 16.945 52,727.51 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 348.90 990.40 18.001 4,511.60 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 75.82 213.88 18.234 959.12 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 447.01 1,107.66 21.895 3,951.34 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 3,557.84 6,540.23 24.062 20,640.77 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 832.08 1,529.56 24.061 4,827.44 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 6.73 11.77 .934 1,248.23 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 370.50 24.232 1,158.50 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 1,991.81 2,306.49 46.502 2,653.51 Subtotal: 595,970.00 595,970.00 75,434.96 145,452.12 24.406 450,517.88 135-55030-030-000 Software & Support 78,391.00 78,391.00 9,784.89 22,246.09 28.378 56,144.91 135-55070-030-000 Independent Labor 154,000.00 154,000.00 8,934.63 35,707.42 23.187 118,292.58 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 406.14 568.35 4.060 13,431.65 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 360.00 360.00- 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 672.74 1,158.89 11.589 8,841.11 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 1,230.52 1,804.45 20.049 7,195.55 Subtotal: 338,916.00 338,916.00 21,388.92 118,320.20 34.911 220,595.80 135-60005-030-000 Telephone 27,300.00 27,300.00 1,223.99 2,743.21 10.048 24,556.79 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 361.75 849.74 21.244 3,150.26 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 644.52 3.964 15,616.48 135-60025-030-000 Water 2,500.00 2,500.00 58.10 174.30 6.972 2,325.70 135-60030-030-000 Rent And/Or Usage 616.40 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 4,680.20 6,383.11 21.277 23,616.89 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 5,293.01 16,454.30 29.615 39,105.70 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 18,301.08 32.681 37,698.92 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 35.00 135.00 2.250 5,865.00 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 363.84 440.52 9.018 4,444.48 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 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 100.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 2,700.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 18,832.65 49,755.79 19.942 199,750.21 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 142.79 1,962.80 28.040 5,037.20 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 98.06 1,658.06 82.903 341.94 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 493.61 1,157.28 28.932 2,842.72 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 734.46 5,520.09 21.975 19,599.91 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 230.66 644.67 14.015 3,955.33 Subtotal: 17,600.00 17,600.00 230.66 8,485.67 48.214 9,114.33 Program number: 1,227,112.00 1,227,112.00 116,621.65 327,533.87 26.691 899,578.13 Department number: Administration 1,227,112.00 1,227,112.00 116,621.65 327,533.87 26.691 899,578.13 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/2017 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 9,019.30 17,258.99 12.598 119,741.01 135-55055-039-000 Auditing 24,500.00 24,500.00 14,400.00 58.776 10,100.00 135-55060-039-000 Appraisal 11,446.00 11,446.00 2,011.87 4,660.18 40.714 6,785.82 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 2,968.40 78.116 831.60 Subtotal: 176,746.00 176,746.00 13,999.57 39,287.57 22.228 137,458.43 Program number: 176,746.00 176,746.00 13,999.57 39,287.57 22.228 137,458.43 Department number: Non Departmental 176,746.00 176,746.00 13,999.57 39,287.57 22.228 137,458.43 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 612,048.93 1,774,296.59 17.645 8,281,114.41 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 81,384.14- 370,460.51- 190.353 175,842.51 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 20:22 01/11/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/2017 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 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 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 576 12/01/2017 Property Taxes (5,399.65) (92.02) (5,491.67) GL 577 12/04/2017 Property Taxes (286.69) (5,778.36) GL 578 12/05/2017 Property Taxes (326.80) (6,105.16) GL 579 12/06/2017 Property Taxes (759.97) (6,865.13) GL 580 12/07/2017 Property Taxes (370.99) (7,236.12) GL 617 12/07/2017 Property Taxes (370.99) (7,607.11) GL 618 12/07/2017 Reverse Property Taxes 580 370.99 (7,236.12) GL 581 12/08/2017 Property Taxes (647.03) (7,883.15) GL 582 12/11/2017 Property Taxes (978.63) (8,861.78) GL 583 12/12/2017 Property Taxes (881.52) (9,743.30) GL 610 12/12/2017 Property Taxes (881.52) (10,624.82) GL 611 12/12/2017 Reverse Property Tax 583 881.52 (9,743.30) GL 584 12/13/2017 Property Taxes (861.03) (10,604.33) GL 585 12/14/2017 Property Taxes (828.59) (11,432.92) GL 586 12/15/2017 Property Taxes (726.84) (12,159.76) GL 587 12/18/2017 Property Taxes (28,600.79) (40,760.55) GL 614 12/18/2017 Property Taxes (28,600.78) (69,361.33) GL 615 12/18/2017 Reverse Property Tax 587 28,600.79 (40,760.54) GL 588 12/19/2017 Property Taxes (558.05) (41,318.59) GL 589 12/20/2017 Property Taxes (1,339.17) (42,657.76) GL 590 12/21/2017 Property Taxes (457.72) (43,115.48) GL 591 12/22/2017 Property Taxes (2,508.62) (45,624.10) GL 612 12/22/2017 Property Taxes (2,508.62) (48,132.72) GL 613 12/22/2017 Reverse Property Tax 591 2,508.62 (45,624.10) GL 592 12/27/2017 Property Taxes (12,069.79) (57,693.89) GL 593 12/28/2017 Property Taxes (10,660.56) (68,354.45) GL 594 12/29/2017 Property Taxes (2,110.61) (70,465.06) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (65,065.41) (70,465.06) ** (120,950.00) Budgeted (50,484.94) Remaining 58 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 577 12/04/2017 Property Taxes (136.15) (4.81) (140.96) GL 578 12/05/2017 Property Taxes (1.64) (142.60) GL 579 12/06/2017 Property Taxes (.27) (142.87) GL 585 12/14/2017 Property Taxes 8.48 (134.39) GL 589 12/20/2017 Property Taxes (14.89) (149.28) GL 591 12/22/2017 Property Taxes (15.07) (164.35) GL 612 12/22/2017 Property Taxes (15.07) (179.42) GL 613 12/22/2017 Reverse Property Tax 591 15.07 (164.35) GL 592 12/27/2017 Property Taxes (5.33) (169.68) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (33.53) (169.68) ** (200.00) Budgeted (30.32) Remaining 85 % Used Account: 135-40015-000-000 Property Taxes/P & I 577 12/04/2017 Property Taxes (21.99) (2.24) (24.23) GL 578 12/05/2017 Property Taxes (.62) (24.85) GL 579 12/06/2017 Property Taxes (.06) (24.91) GL 582 12/11/2017 Property Taxes (.35) (25.26) GL 587 12/18/2017 Property Taxes (2.03) (27.29) GL 614 12/18/2017 Property Taxes (2.04) (29.33) GL 615 12/18/2017 Reverse Property Tax 587 2.03 (27.30) GL 589 12/20/2017 Property Taxes (3.44) (30.74) GL 591 12/22/2017 Property Taxes (3.47) (34.21) GL 612 12/22/2017 Property Taxes (3.47) (37.68) GL 613 12/22/2017 Reverse Property Tax 591 3.47 (34.21) GL 592 12/27/2017 Property Taxes (1.60) (35.81) GL 593 12/28/2017 Property Taxes (.03) (35.84) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (13.85) (35.84) ** (200.00) Budgeted (164.16) Remaining 18 % 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 512 12/31/2017 Billing-December 2017 UB20171231-20171231 User: (932,153.38) (357,013.62) (1,289,167.00) UB _______________ Account: 135-47000-000-000 Water Totals: (357,013.62) (1,289,167.00) ** (6,464,019.00) Budgeted (5,174,852.00) Remaining 20 % Used Account: 135-47005-000-000 Sewer 512 12/31/2017 Billing-December 2017 UB20171231-20171231 User: (471,041.79) (235,176.30) (706,218.09) UB _______________ Account: 135-47005-000-000 Sewer Totals: (235,176.30) (706,218.09) ** (2,978,067.00) Budgeted (2,271,848.91) Remaining 24 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 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 522 12/05/2017 Penalty removal UB20171205-20171205 User: (23,100.24) 67.17 (23,033.07) UB 487 12/21/2017 Penalities December 2017 UB20171221-20171221 User: (14,942.36) (37,975.43) UB 523 12/29/2017 Penalty removal UB20171229-20171229 User: 280.86 (37,694.57) UB _______________ Account: 135-47025-000-000 Penalties Totals: (14,594.33) (37,694.57) ** (106,279.00) Budgeted (68,584.43) Remaining 35 % Used Account: 135-47030-000-000 Service Charges 409 12/06/2017 Cut Off List UB20171206-20171206 User: (2,150.00) (1,350.00) (3,500.00) UB 525 12/12/2017 NSF check UB20171211-20171212 User: (50.00) (3,550.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,400.00) (3,550.00) ** (21,350.00) Budgeted (17,800.00) Remaining 17 % Used Account: 135-47035-000-000 Plumbing Inspections 437 12/05/2017 Permits-347 Tenison Trail 347 Tenison Trail (450.00) (50.00) (500.00) First Texas Homes CR 439 12/06/2017 Permits-Beck Intermediate Beck Intermediate (150.00) (650.00) Pogue Construction CR 517 12/15/2017 Permits-Ashton Wood Homes 416 Abbot Lane (50.00) (700.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 601 Hogan's Drive (50.00) (750.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 414 Abbot Lane (150.00) (900.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 412 Abbot Lane (50.00) (950.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 646 Sheldon Drive (50.00) (1,000.00) Ashton Wood Homes CR 518 12/19/2017 Permits-Drees 24 Katie Lane (50.00) (1,050.00) Drees Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (600.00) (1,050.00) ** (1,500.00) Budgeted (450.00) Remaining 70 % Used Account: 135-47045-000-000 Sewer Inspections 437 12/05/2017 Permits-347 Tenison Trail 347 Tenison Trail (1,350.00) (150.00) (1,500.00) First Texas Homes CR 439 12/06/2017 Permits-Beck Intermediate Beck Intermediate (50.00) (1,550.00) Pogue Construction CR 517 12/15/2017 Permits-Ashton Wood Homes 414 Abbot Lane (50.00) (1,600.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 412 Abbot Lane (150.00) (1,750.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 646 Sheldon Drive (150.00) (1,900.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 416 Abbot Lane (150.00) (2,050.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 601 Hogan's Drive (150.00) (2,200.00) Ashton Wood Homes CR 518 12/19/2017 Permits-Drees 24 Katie Lane (150.00) (2,350.00) Drees Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,000.00) (2,350.00) ** (4,500.00) Budgeted (2,150.00) Remaining 52 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47070-000-000 TCCC Effluent Charges 512 12/31/2017 Billing-December 2017 UB20171231-20171231 User: (547.20) (8,570.40) (9,117.60) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (8,570.40) (9,117.60) ** (60,000.00) Budgeted (50,882.40) Remaining 15 % Used Account: 135-49010-000-000 Interest Income 603 12/31/2017 December Bank Interest (5,154.91) (141.86) (5,296.77) GL 603 12/31/2017 December Bank Interest (465.19) (5,761.96) GL 603 12/31/2017 December Bank Interest (2,308.63) (8,070.59) GL 603 12/31/2017 December Bank Interest (439.54) (8,510.13) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (3,355.22) (8,510.13) ** (12,000.00) Budgeted (3,489.87) Remaining 71 % Used Account: 135-49016-000-000 Cell Tower Revenue 546 12/15/2017 AT&T Cell Tower Revenue (1,889.34) (978.81) (2,868.15) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (2,868.15) ** (10,926.00) Budgeted (8,057.85) Remaining 26 % Used Account: 135-49018-000-000 Building Rent Income 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (1,166.66) (583.33) (1,749.99) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,749.99) ** (7,000.00) Budgeted (5,250.01) Remaining 25 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 437 12/05/2017 Permits-347 Tenison Trail 347 Tenison Trail (3,087.00) (343.00) (3,430.00) First Texas Homes CR 439 12/06/2017 Permits-Beck Intermediate Beck Intermediate (859.76) (4,289.76) Pogue Construction CR 517 12/15/2017 Permits-Ashton Wood Homes 412 Abbot Lane (343.00) (4,632.76) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 414 Abbot Lane (343.00) (4,975.76) Ashton Wood Homes CR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 517 12/15/2017 Permits-Ashton Wood Homes 646 Sheldon Drive (3,087.00) (343.00) (5,318.76) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 416 Abbot Lane (343.00) (5,661.76) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 601 Hogan's Drive (343.00) (6,004.76) Ashton Wood Homes CR 518 12/19/2017 Permits-Drees 24 Katie Lane (343.00) (6,347.76) Drees Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (3,260.76) (6,347.76) ** (18,179.00) Budgeted (11,831.24) Remaining 35 % Used Account: 135-49900-000-000 Miscellaneous Income 517 12/15/2017 Permits-Ashton Wood Homes 414 Abbot Lane (3,675.72) (800.00) (4,475.72) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 601 Hogan's Drive (800.00) (5,275.72) Ashton Wood Homes CR 512 12/31/2017 Billing-December 2017 UB20171231-20171231 User: (187.51) (5,463.23) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,787.51) (5,463.23) ** (5,000.00) Budgeted 463.23 Remaining 109 % 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,144,757.10) ** (693,433.07) Monthly Total (10,250,029.00) Budgeted (8,105,271.90) Remaining 21 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 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 327 12/01/2017 MUD PR 12.01.17 Salaries & Wages 25,367.85 7,483.92 32,851.77 PR 434 12/15/2017 MUD PR 12.15.17 Salaries & Wages 7,483.92 40,335.69 PR 501 12/29/2017 MUD PR 12.29.17 Salaries & Wages 7,483.92 47,819.61 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 22,451.76 47,819.61 ** 274,279.00 Budgeted 226,459.39 Remaining 17 % Used Account: 135-50010-010-000 Overtime 327 12/01/2017 MUD PR 12.01.17 Overtime 610.94 534.14 1,145.08 PR 434 12/15/2017 MUD PR 12.15.17 Overtime 61.34 1,206.42 PR 501 12/29/2017 MUD PR 12.29.17 Overtime 728.91 1,935.33 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,324.39 1,935.33 ** 20,000.00 Budgeted 18,064.67 Remaining 10 % 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 434 12/15/2017 MUD PR 12.15.17 Certification 400.00 150.00 550.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 550.00 ** 3,300.00 Budgeted 2,750.00 Remaining 17 % Used Account: 135-50020-010-000 Retirement 327 12/01/2017 MUD PR 12.01.17 Retirement 4,156.17 741.68 4,897.85 PR 434 12/15/2017 MUD PR 12.15.17 Retirement 711.80 5,609.65 PR 501 12/29/2017 MUD PR 12.29.17 Retirement 759.69 6,369.34 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,213.17 6,369.34 ** 27,843.00 Budgeted 21,473.66 Remaining 23 % Used Account: 135-50026-010-000 Medical Insurance 327 12/01/2017 MUD PR 12.01.17 Medical Insurance 4,960.63 944.88 5,905.51 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 434 12/15/2017 MUD PR 12.15.17 Medical Insurance 4,960.63 944.88 6,850.39 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,889.76 6,850.39 ** 52,196.00 Budgeted 45,345.61 Remaining 13 % Used Account: 135-50027-010-000 Dental Insurance 327 12/01/2017 MUD PR 12.01.17 Dental Insurance 505.69 102.98 608.67 PR 434 12/15/2017 MUD PR 12.15.17 Dental Insurance 102.95 711.62 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 205.93 711.62 ** 5,182.00 Budgeted 4,470.38 Remaining 14 % Used Account: 135-50028-010-000 Vision Insurance 327 12/01/2017 MUD PR 12.01.17 Vision Insurance 102.97 20.10 123.07 PR 434 12/15/2017 MUD PR 12.15.17 Vision Insurance 20.07 143.14 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 40.17 143.14 ** 994.00 Budgeted 850.86 Remaining 14 % Used Account: 135-50029-010-000 Life Insurance & Other 307 12/01/2017 Dec A/P Dec Dental, Vision & other 492.77 147.20 639.97 METLIFE GROUP BENEFITS 3708 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 147.20 639.97 ** 2,982.00 Budgeted 2,342.03 Remaining 21 % Used Account: 135-50030-010-000 Social Security Taxes 327 12/01/2017 MUD PR 12.01.17 Social Security Taxes 1,822.13 495.32 2,317.45 PR 434 12/15/2017 MUD PR 12.15.17 Social Security Taxes 470.80 2,788.25 PR 501 12/29/2017 MUD PR 12.29.17 Social Security Taxes 510.50 3,298.75 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,476.62 3,298.75 ** 18,662.00 Budgeted 15,363.25 Remaining 18 % Used Account: 135-50035-010-000 Medicare Taxes 327 12/01/2017 MUD PR 12.01.17 Medicare Taxes 426.15 115.84 541.99 PR 434 12/15/2017 MUD PR 12.15.17 Medicare Taxes 110.10 652.09 PR 501 12/29/2017 MUD PR 12.29.17 Medicare Taxes 119.39 771.48 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 345.33 771.48 ** 4,365.00 Budgeted 3,593.52 Remaining 18 % Used Account: 135-50040-010-000 Unemployment Taxes 327 12/01/2017 MUD PR 12.01.17 Unemployment Taxes 7.43 1.04 8.47 PR 434 12/15/2017 MUD PR 12.15.17 Unemployment Taxes .21 8.68 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 1.25 8.68 ** 1,080.00 Budgeted 1,071.32 Remaining 1 % Used Account: 135-50045-010-000 Workman's Compensation 234 12/01/2017 Insurance/Wrk Comp Exp Dec 1,799.84 899.92 2,699.76 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 2,699.76 ** 11,854.00 Budgeted 9,154.24 Remaining 23 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 543 12/31/2017 Pcard 11/28/17 - 12/26/17 LCA*LABCORPHOLDINGS CL 50.00 50.00 LCA*LABCORPHOLDINGS CL PC 557 12/31/2017 December A/P Water-New Hire check 113.05 163.05 FIRST CHECK APPLICANT SCREENIN 3806 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 163.05 163.05 ** 200.00 Budgeted 36.95 Remaining 82 % Used Account: 135-50070-010-000 Employee Relations 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TX.GOV SERVICEFEE- 18.99 2.00 20.99 TX.GOV SERVICEFEE- PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 DENTON VEHREG 7.50 28.49 DENTON VEHREG PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 134.03 162.52 TOM THUMB #1789 PC 620 12/31/2017 Reclassification Pcard entries (2.00) 160.52 GL 620 12/31/2017 Reclassification Pcard entries (7.50) 153.02 GL 620 12/31/2017 Reclassification Pcard entries (134.03) 18.99 GL _______________ 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ 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 451 12/14/2017 Dec A/P Angle Stops & Bolts 4,083.37 1,368.60 5,451.97 Core & Main LP 3763 AP 451 12/14/2017 Dec A/P AVK Nozzles 170.36 5,622.33 Core & Main LP 3763 AP 488 12/21/2017 December 2017A/P Valve kits 152.88 5,775.21 Core & Main LP 3763 AP 488 12/21/2017 December 2017A/P Valve repair kits 710.65 6,485.86 Core & Main LP 3763 AP 537 12/31/2017 December A/P Remove and replace driveway @ 3,500.00 9,985.86 REY-MAR CONSTRUCTION 3825 AP 537 12/31/2017 December A/P Hand pumps 207.06 10,192.92 Core & Main LP 3798 AP 537 12/31/2017 December A/P Emergency repair & replace dri 8,285.00 18,477.92 REY-MAR CONSTRUCTION 3825 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 14,394.55 18,477.92 ** 100,000.00 Budgeted 81,522.08 Remaining 18 % 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 543 12/31/2017 Pcard 11/28/17 - 12/26/17 KWIK KAR LUBE & TUNE O 1,171.42 7.00 1,178.42 KWIK KAR LUBE & TUNE O PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ROANOKE AUTO SUPPLY LT 27.05 1,205.47 ROANOKE AUTO SUPPLY LT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ROANOKE AUTO SUPPLY LT 41.91 1,247.38 ROANOKE AUTO SUPPLY LT PC 620 12/31/2017 Reclassification Pcard entries 2.00 1,249.38 GL 620 12/31/2017 Reclassification Pcard entries 7.50 1,256.88 GL 620 12/31/2017 Reclassification Pcard entries 8.25 1,265.13 GL 620 12/31/2017 Reclassification Pcard entries 2.00 1,267.13 GL _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 95.71 1,267.13 ** 4,000.00 Budgeted 2,732.87 Remaining 32 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-000 Lab Analysis 451 12/14/2017 Dec A/P Water Samples/MUD 1,130.74 200.00 1,330.74 TARRANT CTY PUBLIC HEALTH LAB 3785 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 200.00 1,330.74 ** 5,500.00 Budgeted 4,169.26 Remaining 24 % Used Account: 135-60010-010-000 Communications/Mobiles 451 12/14/2017 Dec A/P Cells 319.55 320.79 640.34 VERIZON WIRELESS 3793 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 320.79 640.34 ** 4,700.00 Budgeted 4,059.66 Remaining 14 % Used Account: 135-60020-010-000 Electricity 451 12/14/2017 Dec A/P Electricity 11/7-12/7/17 27,304.32 17.33 27,321.65 HUDSON ENERGY SERVICES, LLC 3772 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/18-17 11,208.35 38,530.00 HUDSON ENERGY SERVICES, LLC 3772 AP _______________ Account: 135-60020-010-000 Electricity Totals: 11,225.68 38,530.00 ** 175,356.00 Budgeted 136,826.00 Remaining 22 % 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 .00 .00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 .00 ** 2,785.00 Budgeted 2,785.00 Remaining 0 % Used Account: 135-60090-010-000 Safety Program . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 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 537 12/31/2017 December A/P Wholesale water 208,059.10 166,739.52 374,798.62 CITY OF FORT WORTH 3797 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 166,739.52 374,798.62 ** 2,823,170.00 Budgeted 2,448,371.38 Remaining 13 % 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 214.70 .00 214.70 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 214.70 ** 3,000.00 Budgeted 2,785.30 Remaining 7 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2,250.00 .00 2,250.00 _______________ 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 504 12/27/2017 Texpool Transfers Dec 50,560.62 25,280.31 75,840.93 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 75,840.93 ** 278,084.00 Budgeted 202,243.07 Remaining 27 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 504 12/27/2017 Texpool Transfers Dec 8,166.00 4,083.00 12,249.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 12,249.00 ** 48,996.00 Budgeted 36,747.00 Remaining 25 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 537 12/31/2017 December A/P New testing machine 118.47 118.47 HACH COMPANY 3810 AP 537 12/31/2017 December A/P New testing machine 183.60 302.07 HACH COMPANY 3810 AP 537 12/31/2017 December A/P new testing machine 213.44 515.51 HACH COMPANY 3811 AP 537 12/31/2017 December A/P New testing machine 4,504.15 5,019.66 HACH COMPANY 3810 AP _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 5,019.66 5,019.66 ** 2,500.00 Budgeted (2,519.66) Remaining 201 % Used Account: 135-65005-010-000 Fuel & Lube . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 537 12/31/2017 December A/P fuel 1,419.71 777.27 2,196.98 US Bank Voyager Fleet Systems 3831 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 777.27 2,196.98 ** 15,000.00 Budgeted 12,803.02 Remaining 15 % Used Account: 135-65010-010-000 Uniforms 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TRACTOR SUPPLY COMPANY 497.22 174.75 671.97 TRACTOR SUPPLY COMPANY PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TRACTOR SUPPLY COMPANY (13.32) 658.65 TRACTOR SUPPLY COMPANY PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RED WING SHOES #652 170.99 829.64 RED WING SHOES #652 PC _______________ Account: 135-65010-010-000 Uniforms Totals: 332.42 829.64 ** 4,488.00 Budgeted 3,658.36 Remaining 18 % Used Account: 135-65030-010-000 Chemicals 451 12/14/2017 Dec A/P 55 gal drum LAS 2,607.66 441.16 3,048.82 Valley Solvent Company, INC 3792 AP 537 12/31/2017 December A/P Chlorine 663.72 3,712.54 DPC INDUSTRIES, INC 3802 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,104.88 3,712.54 ** 20,000.00 Budgeted 16,287.46 Remaining 19 % 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 .00 .00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65053-010-000 Meter Change Out Program .00 .00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 .00 ** 84,000.00 Budgeted 84,000.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays 451 12/14/2017 Dec A/P High Speed VFD 54,409.25 7,705.17 62,114.42 CP&Y/WALLACE GROUP, INC. 3765 AP 537 12/31/2017 December A/P 2017 Capital outlay VFD-Water 1,868.44 63,982.86 Star-Telegram Media 3826 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 9,573.61 63,982.86 ** 810,012.00 Budgeted 746,029.14 Remaining 8 % 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 537 12/31/2017 December A/P Annual tank inspection/mainten 65,920.00 41,944.38 107,864.38 UTILITY SERVICE CO, INC. 3832 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 41,944.38 107,864.38 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/2017 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 488 12/21/2017 December 2017A/P Water samples 296.19 80.00 376.19 TARRANT CTY PUBLIC HEALTH LAB 3785 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 376.19 ** 2,000.00 Budgeted 1,623.81 Remaining 19 % Used Department 10 Totals: ----------------------------------- 867,653.23 ** 312,480.33 Monthly Total 5,657,433.00 Budgeted 4,789,779.77 Remaining 15 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 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 327 12/01/2017 MUD PR 12.01.17 Salaries & Wages 46,080.58 15,349.00 61,429.58 PR 434 12/15/2017 MUD PR 12.15.17 Salaries & Wages 15,366.28 76,795.86 PR 501 12/29/2017 MUD PR 12.29.17 Salaries & Wages 15,303.74 92,099.60 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 46,019.02 92,099.60 ** 410,866.00 Budgeted 318,766.40 Remaining 22 % Used Account: 135-50010-020-000 Overtime 327 12/01/2017 MUD PR 12.01.17 Overtime 3,997.04 1,025.12 5,022.16 PR 434 12/15/2017 MUD PR 12.15.17 Overtime 809.41 5,831.57 PR 501 12/29/2017 MUD PR 12.29.17 Overtime 856.80 6,688.37 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,691.33 6,688.37 ** 30,000.00 Budgeted 23,311.63 Remaining 22 % 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 434 12/15/2017 MUD PR 12.15.17 Certification 1,325.00 625.00 1,950.00 PR 456 12/15/2017 Supplemental P/R Run Certification 75.00 2,025.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 2,025.00 ** 8,400.00 Budgeted 6,375.00 Remaining 24 % Used Account: 135-50020-020-000 Retirement 327 12/01/2017 MUD PR 12.01.17 Retirement 6,905.08 1,514.60 8,419.68 PR 434 12/15/2017 MUD PR 12.15.17 Retirement 1,554.08 9,973.76 PR 456 12/15/2017 Supplemental P/R Run Retirement 6.94 9,980.70 PR 501 12/29/2017 MUD PR 12.29.17 Retirement 1,494.84 11,475.54 PR _______________ Account: 135-50020-020-000 Retirement Totals: 4,570.46 11,475.54 ** 42,243.00 Budgeted 30,767.46 Remaining 27 % Used Account: 135-50026-020-000 Medical Insurance . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 327 12/01/2017 MUD PR 12.01.17 Medical Insurance 9,420.40 2,355.10 11,775.50 PR 434 12/15/2017 MUD PR 12.15.17 Medical Insurance 2,355.10 14,130.60 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 14,130.60 ** 62,175.00 Budgeted 48,044.40 Remaining 23 % Used Account: 135-50027-020-000 Dental Insurance 327 12/01/2017 MUD PR 12.01.17 Dental Insurance 798.64 199.69 998.33 PR 434 12/15/2017 MUD PR 12.15.17 Dental Insurance 199.63 1,197.96 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 1,197.96 ** 5,271.00 Budgeted 4,073.04 Remaining 23 % Used Account: 135-50028-020-000 Vision Insurance 327 12/01/2017 MUD PR 12.01.17 Vision Insurance 168.66 42.19 210.85 PR 434 12/15/2017 MUD PR 12.15.17 Vision Insurance 42.14 252.99 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 252.99 ** 1,114.00 Budgeted 861.01 Remaining 23 % Used Account: 135-50029-020-000 Life Insurance & Other 307 12/01/2017 Dec A/P Dec Dental, Vision & other 788.28 361.15 1,149.43 METLIFE GROUP BENEFITS 3708 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 361.15 1,149.43 ** 4,281.00 Budgeted 3,131.57 Remaining 27 % Used Account: 135-50030-020-000 Social Security Taxes 327 12/01/2017 MUD PR 12.01.17 Social Security Taxes 3,440.24 957.79 4,398.03 PR 434 12/15/2017 MUD PR 12.15.17 Social Security Taxes 966.91 5,364.94 PR 456 12/15/2017 Supplemental P/R Run Social Security Taxes 4.65 5,369.59 PR 501 12/29/2017 MUD PR 12.29.17 Social Security Taxes 1,004.55 6,374.14 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,933.90 6,374.14 ** 28,314.00 Budgeted 21,939.86 Remaining 23 % Used Account: 135-50035-020-000 Medicare Taxes 327 12/01/2017 MUD PR 12.01.17 Medicare Taxes 804.57 223.99 1,028.56 PR 434 12/15/2017 MUD PR 12.15.17 Medicare Taxes 226.14 1,254.70 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 456 12/15/2017 Supplemental P/R Run Medicare Taxes 804.57 1.09 1,255.79 PR 501 12/29/2017 MUD PR 12.29.17 Medicare Taxes 234.94 1,490.73 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 686.16 1,490.73 ** 6,622.00 Budgeted 5,131.27 Remaining 23 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 234 12/01/2017 Insurance/Wrk Comp Exp Dec 2,696.00 1,348.00 4,044.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 4,044.00 ** 17,990.00 Budgeted 13,946.00 Remaining 22 % 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 543 12/31/2017 Pcard 11/28/17 - 12/26/17 DENTON VEHREG 8.25 8.25 DENTON VEHREG PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TX.GOV SERVICEFEE- 2.00 10.25 TX.GOV SERVICEFEE- PC 620 12/31/2017 Reclassification Pcard entries (8.25) 2.00 GL 620 12/31/2017 Reclassification Pcard entries (2.00) .00 GL _______________ 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 .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 20,550.00 Budgeted 20,550.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 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-020-000 Maintenance & Repairs 537 12/31/2017 December A/P Replace of rubber 6,356.22 88.00 6,444.22 Huber Technology Inc 3813 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AIR MAC INC 575.60 7,019.82 AIR MAC INC PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ROANOKE AUTO SUPPLY LT 16.86 7,036.68 ROANOKE AUTO SUPPLY LT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 11.93 7,048.61 THE HOME DEPOT #6581 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 17.54 7,066.15 THE HOME DEPOT #6581 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 3.19 7,069.34 THE HOME DEPOT #6581 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ROANOKE AUTO SUPPLY LT .98 7,070.32 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 714.10 7,070.32 ** 86,100.00 Budgeted 79,029.68 Remaining 8 % 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 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR WASH 2,648.72 6.00 2,654.72 MUSTANG ELITE CAR WASH PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR 70.99 2,725.71 MUSTANG ELITE CAR PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR 70.99 2,796.70 MUSTANG ELITE CAR PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR WASH 5.99 2,802.69 MUSTANG ELITE CAR WASH PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR 25.50 2,828.19 MUSTANG ELITE CAR PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 179.47 2,828.19 ** 8,000.00 Budgeted 5,171.81 Remaining 35 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 451 12/14/2017 Dec A/P Sludge haul off 7,899.48 3,052.99 10,952.47 L.H. CHANEY MATERIALS, INC. 3775 AP 537 12/31/2017 December A/P Sludge haul off 1,984.48 12,936.95 L.H. CHANEY MATERIALS, INC. 3819 AP 537 12/31/2017 December A/P sludge haul off 2,176.30 15,113.25 L.H. CHANEY MATERIALS, INC. 3819 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 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: 7,213.77 15,113.25 ** 60,000.00 Budgeted 44,886.75 Remaining 25 % Used Account: 135-55135-020-000 Lab Analysis 451 12/14/2017 Dec A/P Testing 7,827.82 246.00 8,073.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 246.00 8,319.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 176.00 8,495.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 246.00 8,741.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 176.00 8,917.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 246.00 9,163.82 OXIDOR LABORATORIES LLC 3783 AP 537 12/31/2017 December A/P ;ab supplies 176.00 9,339.82 OXIDOR LABORATORIES LLC 3823 AP 537 12/31/2017 December A/P Testing supplies 246.00 9,585.82 OXIDOR LABORATORIES LLC 3823 AP 537 12/31/2017 December A/P Testing supplies 176.00 9,761.82 OXIDOR LABORATORIES LLC 3823 AP 537 12/31/2017 December A/P Testing supplies 246.00 10,007.82 OXIDOR LABORATORIES LLC 3823 AP 537 12/31/2017 December A/P Testing supplies 176.00 10,183.82 OXIDOR LABORATORIES LLC 3823 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,356.00 10,183.82 ** 30,000.00 Budgeted 19,816.18 Remaining 34 % Used Account: 135-60010-020-000 Communications/Mobiles 451 12/14/2017 Dec A/P Cells 381.56 381.81 763.37 VERIZON WIRELESS 3793 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 381.81 763.37 ** 4,700.00 Budgeted 3,936.63 Remaining 16 % Used Account: 135-60020-020-000 Electricity 451 12/14/2017 Dec A/P Electricity 11/7-12/7/17 26,996.29 32.15 27,028.44 HUDSON ENERGY SERVICES, LLC 3772 AP 451 12/14/2017 Dec A/P Electricity 10/24-11/27/17 147.89 27,176.33 TRI COUNTY ELECTRIC 3789 AP 451 12/14/2017 Dec A/P Electricity 10/24-11/27/17 27.86 27,204.19 TRI COUNTY ELECTRIC 3789 AP 451 12/14/2017 Dec A/P Electricity 10/24-11/27/17 281.80 27,485.99 TRI COUNTY ELECTRIC 3789 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/8/17 445.69 27,931.68 HUDSON ENERGY SERVICES, LLC 3772 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/8/17 7,363.73 35,295.41 HUDSON ENERGY SERVICES, LLC 3772 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/7/17 7,954.80 43,250.21 ENGIE Resources LLC 3768 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/8/17 270.95 43,521.16 MP2 ENERGY TEXAS LLC 3782 AP 537 12/31/2017 December A/P Electricity 12/8/17-12/18/17 110.77 43,631.93 MP2 ENERGY TEXAS LLC 3821 AP 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (177.00) 43,454.93 AR _______________ Account: 135-60020-020-000 Electricity Totals: 16,458.64 43,454.93 ** 266,709.00 Budgeted 223,254.07 Remaining 16 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 23.17 .00 23.17 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 23.17 ** 1,635.00 Budgeted 1,611.83 Remaining 1 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 451 12/14/2017 Dec A/P WWTP Permit Renewal TO #4 34,733.77 288.75 35,022.52 CP&Y/WALLACE GROUP, INC. 3765 AP 451 12/14/2017 Dec A/P WWTP Improvements less credit (5,000.00) 30,022.52 CP&Y/WALLACE GROUP, INC. 3765 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: (4,711.25) 30,022.52 ** 85,000.00 Budgeted 54,977.48 Remaining 35 % 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 504 12/27/2017 Texpool Transfers Dec 22,189.62 11,094.81 33,284.43 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 33,284.43 ** 122,043.00 Budgeted 88,758.57 Remaining 27 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 504 12/27/2017 Texpool Transfers Dec 108,861.44 54,430.72 163,292.16 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 163,292.16 ** 598,738.00 Budgeted 435,445.84 Remaining 27 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 504 12/27/2017 Texpool Transfers Dec 20,556.00 10,278.00 30,834.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 30,834.00 ** 123,336.00 Budgeted 92,502.00 Remaining 25 % 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 537 12/31/2017 December A/P fuel 1,533.61 653.58 2,187.19 US Bank Voyager Fleet Systems 3831 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 653.58 2,187.19 ** 12,500.00 Budgeted 10,312.81 Remaining 17 % Used Account: 135-65010-020-000 Uniforms 1,614.63 .00 1,614.63 _______________ 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 543 12/31/2017 Pcard 11/28/17 - 12/26/17 INT*IN *AQUAFIX, INC. 5.35 660.48 665.83 INT*IN *AQUAFIX, INC. PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65030-020-000 Chemicals Totals: 660.48 665.83 ** 27,500.00 Budgeted 26,834.17 Remaining 2 % Used Account: 135-65035-020-000 Small Tools 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 247.76 55.81 303.57 THE HOME DEPOT #6581 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 37.84 341.41 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 93.65 341.41 ** 1,000.00 Budgeted 658.59 Remaining 34 % 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 451 12/14/2017 Dec A/P Lab supplies 2,136.63 279.67 2,416.30 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab supplies 386.98 2,803.28 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab supplies 358.32 3,161.60 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab supplies 57.58 3,219.18 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab supplies 91.30 3,310.48 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab Supplies 333.67 3,644.15 HACH COMPANY 3771 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 5.56 3,649.71 TOM THUMB #1789 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,513.08 3,649.71 ** 14,000.00 Budgeted 10,350.29 Remaining 26 % Used Account: 135-69005-020-000 Capital Outlays 451 12/14/2017 Dec A/P Legal WWTP 9,870.99 1,657.50 11,528.49 Dubois Bryant Campbell LLP 3767 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 1,657.50 11,528.49 ** 547,327.00 Budgeted 535,798.51 Remaining 2 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ 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: ----------------------------------- 537,007.93 ** 167,478.23 Monthly Total 2,981,140.00 Budgeted 2,444,132.07 Remaining 18 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2017 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 234 12/01/2017 Insurance/Wrk Comp Exp Dec 4.84 2.42 7.26 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 7.26 ** 30.00 Budgeted 22.74 Remaining 24 % 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 568 12/31/2017 December AP Directors conference/training 690.00 445.00 1,135.00 ASSOC OF WATER BOARD DIRECTORS 3834 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 445.00 1,135.00 ** 4,000.00 Budgeted 2,865.00 Remaining 28 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 543 12/31/2017 Pcard 11/28/17 - 12/26/17 WALGREENS #6264 1,021.73 1,021.73 WALGREENS #6264 PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 1,021.73 1,021.73 ** 2,000.00 Budgeted 978.27 Remaining 51 % Used Department 26 Totals: ----------------------------------- 2,813.99 ** 1,469.15 Monthly Total 12,980.00 Budgeted 10,166.01 Remaining 22 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 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 327 12/01/2017 MUD PR 12.01.17 Salaries & Wages 46,587.70 16,289.35 62,877.05 PR 434 12/15/2017 MUD PR 12.15.17 Salaries & Wages 16,236.73 79,113.78 PR 501 12/29/2017 MUD PR 12.29.17 Salaries & Wages 26,096.76 105,210.54 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 58,622.84 105,210.54 ** 432,863.00 Budgeted 327,652.46 Remaining 24 % Used Account: 135-50010-030-000 Overtime 327 12/01/2017 MUD PR 12.01.17 Overtime 174.20 .77 174.97 PR 434 12/15/2017 MUD PR 12.15.17 Overtime 7.66 182.63 PR 501 12/29/2017 MUD PR 12.29.17 Overtime 159.79 342.42 PR _______________ Account: 135-50010-030-000 Overtime Totals: 168.22 342.42 ** 2,000.00 Budgeted 1,657.58 Remaining 17 % 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 327 12/01/2017 MUD PR 12.01.17 Retirement 6,960.57 1,506.83 8,467.40 PR 434 12/15/2017 MUD PR 12.15.17 Retirement 1,502.60 9,970.00 PR 501 12/29/2017 MUD PR 12.29.17 Retirement 2,428.73 12,398.73 PR _______________ Account: 135-50020-030-000 Retirement Totals: 5,438.16 12,398.73 ** 40,553.00 Budgeted 28,154.27 Remaining 31 % Used Account: 135-50026-030-000 Medical Insurance 327 12/01/2017 MUD PR 12.01.17 Medical Insurance 6,935.44 1,911.02 8,846.46 PR 434 12/15/2017 MUD PR 12.15.17 Medical Insurance 1,911.03 10,757.49 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,822.05 10,757.49 ** 63,485.00 Budgeted 52,727.51 Remaining 17 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 327 12/01/2017 MUD PR 12.01.17 Dental Insurance 641.50 174.48 815.98 PR 434 12/15/2017 MUD PR 12.15.17 Dental Insurance 174.42 990.40 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 348.90 990.40 ** 5,502.00 Budgeted 4,511.60 Remaining 18 % Used Account: 135-50028-030-000 Vision Insurance 327 12/01/2017 MUD PR 12.01.17 Vision Insurance 138.06 37.94 176.00 PR 434 12/15/2017 MUD PR 12.15.17 Vision Insurance 37.88 213.88 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 75.82 213.88 ** 1,173.00 Budgeted 959.12 Remaining 18 % Used Account: 135-50029-030-000 Life Insurance & Other 307 12/01/2017 Dec A/P Dec Dental, Vision & other 660.65 383.01 1,043.66 METLIFE GROUP BENEFITS 3708 AP 488 12/21/2017 December 2017A/P Flex admin fee 64.00 1,107.66 BenefitMall 3762 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 447.01 1,107.66 ** 5,059.00 Budgeted 3,951.34 Remaining 22 % Used Account: 135-50030-030-000 Social Security Taxes 327 12/01/2017 MUD PR 12.01.17 Social Security Taxes 2,982.39 972.31 3,954.70 PR 434 12/15/2017 MUD PR 12.15.17 Social Security Taxes 957.61 4,912.31 PR 501 12/29/2017 MUD PR 12.29.17 Social Security Taxes 1,627.92 6,540.23 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 3,557.84 6,540.23 ** 27,181.00 Budgeted 20,640.77 Remaining 24 % Used Account: 135-50035-030-000 Medicare Taxes 327 12/01/2017 MUD PR 12.01.17 Medicare Taxes 697.48 227.41 924.89 PR 434 12/15/2017 MUD PR 12.15.17 Medicare Taxes 223.95 1,148.84 PR 501 12/29/2017 MUD PR 12.29.17 Medicare Taxes 380.72 1,529.56 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 832.08 1,529.56 ** 6,357.00 Budgeted 4,827.44 Remaining 24 % Used Account: 135-50040-030-000 Unemployment Taxes 327 12/01/2017 MUD PR 12.01.17 Unemployment Taxes 5.04 2.24 7.28 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 434 12/15/2017 MUD PR 12.15.17 Unemployment Taxes 5.04 2.24 9.52 PR 501 12/29/2017 MUD PR 12.29.17 Unemployment Taxes 2.24 11.76 PR 606 12/31/2017 SUTA Qtrly 4 Adjustment .01 11.77 GL _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 6.73 11.77 ** 1,260.00 Budgeted 1,248.23 Remaining 1 % Used Account: 135-50045-030-000 Workman's Compensation 234 12/01/2017 Insurance/Wrk Comp Exp Dec 247.00 123.50 370.50 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 370.50 ** 1,529.00 Budgeted 1,158.50 Remaining 24 % 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 537 12/31/2017 December A/P Office supplies 314.68 18.99 333.67 COSTCO WHOLESALE 3800 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 10.81 344.48 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 19.66 364.14 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CRISTINA'S MEXICAN 12.45 376.59 CRISTINA'S MEXICAN PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 BABE'S- ROANOKE LLC 282.81 659.40 BABE'S- ROANOKE LLC PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 675.00 1,334.40 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 WM SUPERCENTER #5247 350.00 1,684.40 WM SUPERCENTER #5247 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 340.90 2,025.30 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 33.55 2,058.85 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 3.29 2,062.14 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CHICK-FIL-A #02892 67.01 2,129.15 CHICK-FIL-A #02892 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 12.10 2,141.25 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 26.68 2,167.93 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 16.98 2,184.91 TOM THUMB #1789 PC 620 12/31/2017 Reclassification Pcard entries (12.45) 2,172.46 GL 620 12/31/2017 Reclassification Pcard entries 134.03 2,306.49 GL _______________ Account: 135-50070-030-000 Employee Relations Totals: 1,991.81 2,306.49 ** 4,960.00 Budgeted 2,653.51 Remaining 47 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55030-030-000 Software & Support 451 12/14/2017 Dec A/P Internet 12,461.20 1,038.02 13,499.22 WHOLESALE CARRIER SERVICES INC 3794 AP 488 12/21/2017 December 2017A/P VMWARE-software support-3 year 7,945.33 21,444.55 M3 Networks 3777 AP 488 12/21/2017 December 2017A/P STW support 70.00 21,514.55 STW INC 3784 AP 488 12/21/2017 December 2017A/P STW Support 105.85 21,620.40 STW INC 3784 AP 488 12/21/2017 December 2017A/P Outlook 365 license 168.00 21,788.40 M3 Networks 3777 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ADOBE *IL CREATIVE CLD 19.99 21,808.39 ADOBE *IL CREATIVE CLD PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CANVA FOR WORK MONTHLY 12.95 21,821.34 CANVA FOR WORK MONTHLY PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ADOBE 16.23 21,837.57 ADOBE PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BILL PAYMENT 118.59 21,956.16 ATT*BILL PAYMENT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BILL PAYMENT 85.56 22,041.72 ATT*BILL PAYMENT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ADOBE *PHOTOGPHY PLAN 119.88 22,161.60 ADOBE *PHOTOGPHY PLAN PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CANVA 01814-2780603 20.00 22,181.60 CANVA 01814-2780603 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CANVA 01812-2736145 1.00 22,182.60 CANVA 01812-2736145 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BILL PAYMENT 63.49 22,246.09 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 9,784.89 22,246.09 ** 78,391.00 Budgeted 56,144.91 Remaining 28 % Used Account: 135-55070-030-000 Independent Labor 539 12/31/2017 December AP GM December 26,772.79 8,925.00 35,697.79 Carman Consulting LLC. 3833 AP 539 12/31/2017 December AP GM December 9.63 35,707.42 Carman Consulting LLC. 3833 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 8,934.63 35,707.42 ** 154,000.00 Budgeted 118,292.58 Remaining 23 % Used Account: 135-55080-030-000 Maintenance & Repairs 451 12/14/2017 Dec A/P Rekey 162.21 303.67 465.88 MICHAEL'S KEYS INC. 3781 AP 451 12/14/2017 Dec A/P Rekey 102.47 568.35 MICHAEL'S KEYS INC. 3780 AP 451 12/14/2017 Dec A/P Rug Service 66.47 634.82 G & K SERVICES 3770 AP 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (66.47) 568.35 AR _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 406.14 568.35 ** 14,000.00 Budgeted 13,431.65 Remaining 4 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55100-030-000 Building Maint & Supplies 537 12/31/2017 December A/P FIre Alarm monitoring 360.00 360.00 PRO FIRE & SPRINKLER LLC 3824 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 360.00 360.00 ** .00 Budgeted (360.00) Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 488 12/21/2017 December 2017A/P Cleaning services 486.15 869.06 1,355.21 MEMBER'S BUILDING MAINTENANCE 3779 AP 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (196.32) 1,158.89 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 672.74 1,158.89 ** 10,000.00 Budgeted 8,841.11 Remaining 12 % 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 451 12/14/2017 Dec A/P Water Billing/November 573.93 626.16 1,200.09 DATAPROSE LLC 3766 AP 568 12/31/2017 December AP Billing-December 604.36 1,804.45 DATAPROSE LLC 3835 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,230.52 1,804.45 ** 9,000.00 Budgeted 7,195.55 Remaining 20 % Used Account: 135-60005-030-000 Telephone 392 12/05/2017 Dec A/P Answering Service 1,519.22 200.00 1,719.22 KEYSTONE PARK SECRETARIAL 3737 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BUS PHONE PMT 851.57 2,570.79 ATT*BUS PHONE PMT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RINGCENTRAL, INC 13.96 2,584.75 RINGCENTRAL, INC PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BUS PHONE PMT 384.59 2,969.34 ATT*BUS PHONE PMT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BILL PAYMENT 199.65 3,168.99 ATT*BILL PAYMENT PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: 1,519.22 (425.78) 2,743.21 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,223.99 2,743.21 ** 27,300.00 Budgeted 24,556.79 Remaining 10 % Used Account: 135-60010-030-000 Communications/Mobiles 451 12/14/2017 Dec A/P Cells 487.99 136.75 624.74 VERIZON WIRELESS 3793 AP 434 12/15/2017 MUD PR 12.15.17 Communications/Mobiles 225.00 849.74 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 361.75 849.74 ** 4,000.00 Budgeted 3,150.26 Remaining 21 % Used Account: 135-60020-030-000 Electricity/Gas 644.52 .00 644.52 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 644.52 ** 16,261.00 Budgeted 15,616.48 Remaining 4 % Used Account: 135-60025-030-000 Water 537 12/31/2017 December A/P Water 11/27-12/27/17 116.20 116.19 232.39 TROPHY CLUB MUD (WATER BILLS) 3830 AP 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (58.09) 174.30 AR _______________ Account: 135-60025-030-000 Water Totals: 58.10 174.30 ** 2,500.00 Budgeted 2,325.70 Remaining 7 % Used Account: 135-60030-030-000 Rent And/Or Usage 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RENAISSANCE HOTELS 616.40 616.40 RENAISSANCE HOTELS PC _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 616.40 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage 451 12/14/2017 Dec A/P Overnight letter 1,702.91 7.18 1,710.09 FEDERAL EXPRESS CORP 3760 AP 451 12/14/2017 Dec A/P Water Billing/November 1,575.78 3,285.87 DATAPROSE LLC 3766 AP 488 12/21/2017 December 2017A/P PPD Postage for meter 1,500.00 4,785.87 U.S. Postal Service (CMRS-FP) 3791 AP 568 12/31/2017 December AP Billing-December 1,597.24 6,383.11 DATAPROSE LLC 3835 AP _______________ Account: 135-60035-030-000 Postage Totals: 4,680.20 6,383.11 ** 30,000.00 Budgeted 23,616.89 Remaining 21 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 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 328 12/01/2017 Child Support Fee 11,161.29 1.50 11,162.79 GL 435 12/15/2017 Child Support Fee 1.50 11,164.29 GL 502 12/29/2017 Child Support Fee 1.50 11,165.79 GL 544 12/31/2017 Pace Credit Card Fees 5,115.73 16,281.52 GL 544 12/31/2017 Pace Credit Card Fees 122.78 16,404.30 GL 557 12/31/2017 December A/P Direct Send Fees-November 50.00 16,454.30 Fiserv Solutions, LLC 3805 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,293.01 16,454.30 ** 55,560.00 Budgeted 39,105.70 Remaining 30 % 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 234 12/01/2017 Insurance/Wrk Comp Exp Dec 12,200.72 6,100.36 18,301.08 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 18,301.08 ** 56,000.00 Budgeted 37,698.92 Remaining 33 % 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 451 12/14/2017 Dec A/P Tx Social Security Program 100.00 35.00 135.00 TX SOCIAL SECURITY PROGRAM 3790 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 35.00 135.00 ** 6,000.00 Budgeted 5,865.00 Remaining 2 % Used Account: 135-60075-030-000 Meetings 48.62 .00 48.62 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ 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 _______________ 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 327 12/01/2017 MUD PR 12.01.17 Travel & per diem 76.68 24.30 100.98 PR 434 12/15/2017 MUD PR 12.15.17 Travel & per diem 33.75 134.73 PR 501 12/29/2017 MUD PR 12.29.17 Travel & per diem 94.77 229.50 PR 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 109.18 338.68 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RENAISSANCE HOTELS 16.57 355.25 RENAISSANCE HOTELS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 BLUE BAKER 003 11.00 366.25 BLUE BAKER 003 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 7-ELEVEN 32921 28.49 394.74 7-ELEVEN 32921 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RENAISSANCE HOTELS 14.11 408.85 RENAISSANCE HOTELS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HYDE PARK BAR & GRILL 19.22 428.07 HYDE PARK BAR & GRILL PC 620 12/31/2017 Reclassification Pcard entries 12.45 440.52 GL _______________ Account: 135-60100-030-000 Travel & per diem Totals: 363.84 440.52 ** 4,885.00 Budgeted 4,444.48 Remaining 9 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 451 12/14/2017 Dec A/P Election translation 45.00 100.00 145.00 Teneo Linquistics Company, LLC 3787 AP _______________ Account: 135-60115-030-000 Elections Totals: 100.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 .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 2,700.00 Budgeted 2,700.00 Remaining 0 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 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-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 537 12/31/2017 December A/P Office supplies 1,820.01 31.99 1,852.00 OFFICE DEPOT, INC 3822 AP 537 12/31/2017 December A/P Office supplies 28.50 1,880.50 OFFICE DEPOT, INC 3822 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS 55.25 1,935.75 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON.COM 27.05 1,962.80 AMAZON.COM PC _______________ Account: 135-65085-030-000 Office Supplies Totals: 142.79 1,962.80 ** 7,000.00 Budgeted 5,037.20 Remaining 28 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 543 12/31/2017 Pcard 11/28/17 - 12/26/17 OFFICE DEPOT #1079 1,560.00 98.06 1,658.06 OFFICE DEPOT #1079 PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 98.06 1,658.06 ** 2,000.00 Budgeted 341.94 Remaining 83 % Used Account: 135-65095-030-000 Maintenance Supplies 537 12/31/2017 December A/P Office supplies 663.67 17.56 681.23 COSTCO WHOLESALE 3800 AP 537 12/31/2017 December A/P Office supplies 50.07 731.30 OFFICE DEPOT, INC 3822 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS (25.26) 706.04 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS 104.70 810.74 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TARGET 00008763 21.64 832.38 TARGET 00008763 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 10.88 843.26 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 KEURIG GREEN MOUNTAIN 47.99 891.25 KEURIG GREEN MOUNTAIN PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 STAPLES 00116533 77.90 969.15 STAPLES 00116533 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS 131.92 1,101.07 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 5.98 1,107.05 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS (32.95) 1,074.10 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS (48.38) 1,025.72 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 OFFICE DEPOT #1079 14.99 1,040.71 OFFICE DEPOT #1079 PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS 663.67 81.33 1,122.04 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 OFFICE DEPOT #1079 35.24 1,157.28 OFFICE DEPOT #1079 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 493.61 1,157.28 ** 4,000.00 Budgeted 2,842.72 Remaining 29 % 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 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 451 12/14/2017 Dec A/P Copier lease 414.01 165.00 579.01 EVERBANK COMMERCIAL FINANCE 3769 AP 537 12/31/2017 December A/P Copies 65.66 644.67 KYOCERA DOCUMENT SOLUTIONS 3818 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 230.66 644.67 ** 4,600.00 Budgeted 3,955.33 Remaining 14 % Used Department 30 Totals: ----------------------------------- 327,533.87 ** 116,621.65 Monthly Total 1,227,112.00 Budgeted 899,578.13 Remaining 27 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/2017 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 451 12/14/2017 Dec A/P Legal 8,239.69 6,919.30 15,158.99 McLean & Howard, L.L.P. 3778 AP 451 12/14/2017 Dec A/P Legal 2,100.00 17,258.99 McLean & Howard, L.L.P. 3778 AP _______________ Account: 135-55045-039-000 Legal Totals: 9,019.30 17,258.99 ** 137,000.00 Budgeted 119,741.01 Remaining 13 % Used Account: 135-55055-039-000 Auditing 14,400.00 .00 14,400.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 14,400.00 ** 24,500.00 Budgeted 10,100.00 Remaining 59 % Used Account: 135-55060-039-000 Appraisal 392 12/05/2017 Dec A/P 1st Qtr Budget Allocation 2,648.31 2,011.87 4,660.18 DENTON CENTRAL APPRAISAL DISTR 3727 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,011.87 4,660.18 ** 11,446.00 Budgeted 6,785.82 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 605 12/31/2017 Tax Collection fees/Denton Cty 2,968.40 2,968.40 GL _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 2,968.40 2,968.40 ** 3,800.00 Budgeted 831.60 Remaining 78 % Used Department 39 Totals: ----------------------------------- 39,287.57 ** 13,999.57 Monthly Total 176,746.00 Budgeted 137,458.43 Remaining 22 % Used Fund 135 Totals: ----------------------------------- (370,460.51) (81,384.14) Monthly Total (194,618.00) Budgeted 175,842.51 Remaining 190 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/2017 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 DECEMBER 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 1,322,095 ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,322,095 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 (350,932) TOTAL FUND BALANCE 641,647 TOTAL LIABILITIES AND FUND BALANCE 1,322,095 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 20:22 01/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,353.26- 4,403.58- 4,403.58 Subtotal: 1,353.26- 4,403.58- 4,403.58 Program number: 1,353.26- 4,403.58- 4,403.58 Department number: Revenues 1,353.26- 4,403.58- 4,403.58 Revenues Subtotal ----------- 1,353.26- 4,403.58- 4,403.58 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 20:22 01/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 40,812.03 355,335.78 355,335.78- Subtotal: 40,812.03 355,335.78 355,335.78- Program number: 40,812.03 355,335.78 355,335.78- Department number: Wastewater 40,812.03 355,335.78 355,335.78- Expenditures Subtotal ----------- 40,812.03 355,335.78 355,335.78- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 39,458.77 350,932.20 350,932.20- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/2017 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 603 12/31/2017 December Bank Interest (3,050.32) (1,353.26) (4,403.58) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,353.26) (4,403.58) ** .00 Budgeted 4,403.58 Remaining 0 % Used Department Totals: ----------------------------------- (4,403.58) ** (1,353.26) Monthly Total .00 Budgeted 4,403.58 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2017 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 451 12/14/2017 Dec A/P WWTP Improvements less credit 314,523.75 40,812.03 355,335.78 CP&Y/WALLACE GROUP, INC. 3765 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 40,812.03 355,335.78 ** .00 Budgeted (355,335.78) Remaining 0 % Used Department 20 Totals: ----------------------------------- 355,335.78 ** 40,812.03 Monthly Total .00 Budgeted (355,335.78) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 350,932.20 39,458.77 Monthly Total .00 Budgeted (350,932.20) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET DECEMBER 2017 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 DECEMBER 2017 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 DECEMBER 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 470,876 ACCOUNTS RECEIVABLE - TOTAL ASSETS 470,876 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,578 NET REVENUES / EXPENDITURES 44,298 TOTAL FUND BALANCE 470,876 TOTAL LIABILITIES AND FUND BALANCE 470,876 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 20:22 01/11/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 12/2017 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- 458.18- 1,214.70- 121.470 214.70 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 12,249.00- 25.000 36,747.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 30,834.00- 25.000 92,502.00- Subtotal: 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- Program number: 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- Department number: 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- Revenues Subtotal ----------- 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 12/2017 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 603 12/31/2017 December Bank Interest (756.52) (458.18) (1,214.70) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (458.18) (1,214.70) ** (1,000.00) Budgeted 214.70 Remaining 121 % Used Account: 528-49142-000-000 Interfund transfer in-Water 504 12/27/2017 Texpool Transfers Dec (8,166.00) (4,083.00) (12,249.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (12,249.00) ** (48,996.00) Budgeted (36,747.00) Remaining 25 % Used Account: 528-49143-000-000 Interfund transfer in-WW 504 12/27/2017 Texpool Transfers Dec (20,556.00) (10,278.00) (30,834.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (30,834.00) ** (123,336.00) Budgeted (92,502.00) Remaining 25 % Used Department Totals: ----------------------------------- (44,297.70) ** (14,819.18) Monthly Total (173,332.00) Budgeted (129,034.30) Remaining 26 % Used Fund 528 Totals: ----------------------------------- (44,297.70) (14,819.18) Monthly Total (173,332.00) Budgeted (129,034.30) Remaining 26 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET DECEMBER 2017 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 453,387 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 300,745 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 758,705 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 300,745 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 300,745 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 425,619 TOTAL FUND BALANCE 457,960 TOTAL LIABILITIES AND FUND BALANCE 758,705 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 20:22 01/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2017 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- 360,254.67- 390,151.56- 58.261 279,508.44- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 197.35- 1,692.27- 94.015 107.73- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 69.83- 248.00- 12.400 1,752.00- Subtotal: 673,460.00- 673,460.00- 360,521.85- 392,091.83- 58.221 281,368.17- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 170.08- 243.04- 12.152 1,756.96- 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- 33,284.43- 27.273 88,758.57- Subtotal: 342,997.00- 342,997.00- 11,264.89- 33,527.47- 9.775 309,469.53- Program number: 1,016,457.00- 1,016,457.00- 371,786.74- 425,619.30- 41.873 590,837.70- Department number: Revenues 1,016,457.00- 1,016,457.00- 371,786.74- 425,619.30- 41.873 590,837.70- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 371,786.74- 425,619.30- 41.873 590,837.70- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 20:22 01/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2017 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- 371,786.74- 425,619.30- 7,339.529 419,820.30 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2017 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 576 12/01/2017 Property Taxes (29,896.89) (509.49) (30,406.38) GL 577 12/04/2017 Property Taxes (1,587.34) (31,993.72) GL 578 12/05/2017 Property Taxes (1,809.43) (33,803.15) GL 579 12/06/2017 Property Taxes (4,207.78) (38,010.93) GL 580 12/07/2017 Property Taxes (2,054.08) (40,065.01) GL 617 12/07/2017 Property Taxes (2,054.08) (42,119.09) GL 618 12/07/2017 Reverse Property Taxes 580 2,054.08 (40,065.01) GL 581 12/08/2017 Property Taxes (3,582.45) (43,647.46) GL 582 12/11/2017 Property Taxes (5,418.52) (49,065.98) GL 583 12/12/2017 Property Taxes (4,880.83) (53,946.81) GL 610 12/12/2017 Property Taxes (4,880.83) (58,827.64) GL 611 12/12/2017 Reverse Property Tax 583 4,880.83 (53,946.81) GL 584 12/13/2017 Property Taxes (4,767.33) (58,714.14) GL 585 12/14/2017 Property Taxes (4,587.76) (63,301.90) GL 586 12/15/2017 Property Taxes (4,024.37) (67,326.27) GL 587 12/18/2017 Property Taxes (158,357.09) (225,683.36) GL 614 12/18/2017 Property Taxes (158,357.09) (384,040.45) GL 615 12/18/2017 Reverse Property Tax 587 158,357.09 (225,683.36) GL 588 12/19/2017 Property Taxes (3,089.84) (228,773.20) GL 589 12/20/2017 Property Taxes (7,414.75) (236,187.95) GL 590 12/21/2017 Property Taxes (2,534.31) (238,722.26) GL 591 12/22/2017 Property Taxes (13,889.70) (252,611.96) GL 612 12/22/2017 Property Taxes (13,889.70) (266,501.66) GL 613 12/22/2017 Reverse Property Tax 591 13,889.70 (252,611.96) GL 592 12/27/2017 Property Taxes (66,828.18) (319,440.14) GL 593 12/28/2017 Property Taxes (59,025.36) (378,465.50) GL 594 12/29/2017 Property Taxes (11,686.06) (390,151.56) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (360,254.67) (390,151.56) ** (669,660.00) Budgeted (279,508.44) Remaining 58 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 577 12/04/2017 Property Taxes (1,494.92) (13.35) (1,508.27) GL 578 12/05/2017 Property Taxes (7.96) (1,516.23) GL 579 12/06/2017 Property Taxes (3.01) (1,519.24) GL 585 12/14/2017 Property Taxes 93.74 (1,425.50) GL 589 12/20/2017 Property Taxes (41.35) (1,466.85) GL 591 12/22/2017 Property Taxes (166.52) (1,633.37) GL 612 12/22/2017 Property Taxes (166.52) (1,799.89) GL 613 12/22/2017 Reverse Property Tax 591 166.52 (1,633.37) GL 592 12/27/2017 Property Taxes (58.90) (1,692.27) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (197.35) (1,692.27) ** (1,800.00) Budgeted (107.73) Remaining 94 % Used Account: 533-40015-000-000 Property Taxes/P & I 577 12/04/2017 Property Taxes (178.17) (6.14) (184.31) GL 578 12/05/2017 Property Taxes (2.13) (186.44) GL 579 12/06/2017 Property Taxes (.69) (187.13) GL 589 12/20/2017 Property Taxes (9.55) (196.68) GL 591 12/22/2017 Property Taxes (38.30) (234.98) GL 612 12/22/2017 Property Taxes (38.30) (273.28) GL 613 12/22/2017 Reverse Property Tax 591 38.30 (234.98) GL 592 12/27/2017 Property Taxes (13.02) (248.00) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (69.83) (248.00) ** (2,000.00) Budgeted (1,752.00) Remaining 12 % Used Account: 533-49010-000-000 Interest Income 603 12/31/2017 December Bank Interest (72.96) (170.08) (243.04) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (170.08) (243.04) ** (2,000.00) Budgeted (1,756.96) Remaining 12 % 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 504 12/27/2017 Texpool Transfers Dec (22,189.62) (11,094.81) (33,284.43) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (33,284.43) ** (122,043.00) Budgeted (88,758.57) Remaining 27 % Used Department Totals: ----------------------------------- (425,619.30) ** (371,786.74) Monthly Total (1,016,457.00) Budgeted (590,837.70) Remaining 42 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2017 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: ----------------------------------- (425,619.30) (371,786.74) Monthly Total (5,799.00) Budgeted 419,820.30 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET DECEMBER 2017 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 179,719 ACCOUNTS RECEIVABLE - TOTAL ASSETS 179,719 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 163,509 TOTAL FUND BALANCE 179,719 TOTAL LIABILITIES AND FUND BALANCE 179,719 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 20:22 01/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 12/2017 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-134.53-216.13-21.613 783.87- 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00-54,430.72- 163,292.16-27.273 435,445.84- Subtotal:599,738.00- 599,738.00-54,565.25- 163,508.29-27.263 436,229.71- Program number:599,738.00- 599,738.00-54,565.25- 163,508.29-27.263 436,229.71- Department number: Revenues 599,738.00- 599,738.00-54,565.25- 163,508.29-27.263 436,229.71- Revenues Subtotal ----------- 599,738.00- 599,738.00-54,565.25- 163,508.29-27.263 436,229.71- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 20:22 01/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/2017 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,565.25- 163,508.29- ############### 162,508.29 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 12/2017 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 603 12/31/2017 December Bank Interest (81.60) (134.53) (216.13) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (134.53) (216.13) ** (1,000.00) Budgeted (783.87) Remaining 22 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 504 12/27/2017 Texpool Transfers Dec (108,861.44) (54,430.72) (163,292.16) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (163,292.16) ** (598,738.00) Budgeted (435,445.84) Remaining 27 % Used Department Totals: ----------------------------------- (163,508.29) ** (54,565.25) Monthly Total (599,738.00) Budgeted (436,229.71) Remaining 27 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/2017 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: -----------------------------------(163,508.29) (54,565.25) Monthly Total (1,000.00) Budgeted 162,508.29 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET DECEMBER 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 76,875 ACCOUNTS RECEIVABLE - TOTAL ASSETS 76,875 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 75,923 TOTAL FUND BALANCE 76,875 TOTAL LIABILITIES AND FUND BALANCE 76,875 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 20:22 01/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 12/2017 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-55.89-82.41-13.735 517.59- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00-25,280.31- 75,840.93-27.273 202,243.07- Subtotal:278,684.00- 278,684.00-25,336.20- 75,923.34-27.244 202,760.66- Program number:278,684.00- 278,684.00-25,336.20- 75,923.34-27.244 202,760.66- Department number: Revenues 278,684.00- 278,684.00-25,336.20- 75,923.34-27.244 202,760.66- Revenues Subtotal ----------- 278,684.00- 278,684.00-25,336.20- 75,923.34-27.244 202,760.66- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 20:22 01/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 12/2017 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,336.20- 75,923.34- ############### 75,323.34 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 12/2017 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 603 12/31/2017 December Bank Interest (26.52)(55.89)(82.41)GL _______________ Account: 535-49010-000-000 Interest Income Totals:(55.89)(82.41) ** (600.00) Budgeted (517.59) Remaining 14 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 504 12/27/2017 Texpool Transfers Dec (50,560.62)(25,280.31) (75,840.93)GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals:(25,280.31) (75,840.93) ** (278,084.00) Budgeted (202,243.07) Remaining 27 % Used Department Totals: -----------------------------------(75,923.34) ** (25,336.20) Monthly Total (278,684.00) Budgeted (202,760.66) Remaining 27 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 12/2017 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: -----------------------------------(75,923.34) (25,336.20) Monthly Total (600.00) Budgeted 75,323.34 Remaining ########## Grand Totals: ---------------------------------------------------------------------------------------------------------(1,166,588.35) **** (1,024,139.98) Monthly Total (375,349.00) Budgeted 791,239.35 Remaining 311 % Used ******* End of Report *********