Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-10 Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2017 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 253,367 PREPAID EXPENSES 13,969 ADVALOREM PROPERTY TAXES RECEIVABLE 1,072,918 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 9 TOTAL ASSETS 1,340,262 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,072,918 ACCOUNTS AND OTHER PAYABLES 9 TOTAL LIABILITIES 1,072,927 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,252 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (254,917) TOTAL FUND BALANCE 267,335 TOTAL LIABILITIES AND FUND BALANCE 1,340,262 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 14:13 11/15/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/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- 5,601.92- 5,601.92- .531 1,048,831.08- 122-40011-000-000 Property Taxes/Fire-Delinquent 1,314.97- 1,314.97- 1,314.97 122-40020-000-000 Property Taxes/Fire P&I 237.26- 237.26- 237.26 Subtotal: 1,054,433.00- 1,054,433.00- 7,154.15- 7,154.15- .678 1,047,278.85- Program number: 1,054,433.00- 1,054,433.00- 7,154.15- 7,154.15- .678 1,047,278.85- Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 7,154.15- 7,154.15- .678 1,047,278.85- Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 7,154.15- 7,154.15- .678 1,047,278.85- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 14:13 11/15/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/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 1,490.49- Subtotal: 1,490.49 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 1,269.87 7.055 16,730.13 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 50,742.50 8.333 558,167.50 Subtotal: 845,864.00 845,864.00 52,012.37 52,012.37 6.149 793,851.63 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 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 127,148.60 100.000 .40 Subtotal: 208,569.00 208,569.00 208,568.60 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 262,071.46 262,071.46 24.854 792,361.54 Department number: Fire 1,054,433.00 1,054,433.00 262,071.46 262,071.46 24.854 792,361.54 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 262,071.46 262,071.46 24.854 792,361.54 Fund number: 122 Trophy Club MUD Fire Dept. 254,917.31 254,917.31 254,917.31- . glpytb2 rgonzale Trophy Club MUD No.1 Page 1 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 122-40010-000-000 Property Taxes/MUD Fire 81 10/02/2017 Property Taxes (41.49) (41.49) GL 82 10/04/2017 Property Taxes (241.43) (282.92) GL 84 10/06/2017 Property Taxes (184.96) (467.88) GL 85 10/10/2017 Property Taxes (421.94) (889.82) GL 162 10/16/2017 Property Taxes (705.83) (1,595.65) GL 163 10/17/2017 Property Taxes (53.91) (1,649.56) GL 164 10/19/2017 Property Taxes (252.98) (1,902.54) GL 166 10/23/2017 Property Taxes (613.51) (2,516.05) GL 168 10/26/2017 Property Taxes (697.16) (3,213.21) GL 169 10/27/2017 Property Taxes (731.07) (3,944.28) GL 170 10/30/2017 Property Taxes (664.06) (4,608.34) GL 172 10/31/2017 Property Taxes (993.58) (5,601.92) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (5,601.92) * _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (5,601.92) ** Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 81 10/02/2017 Property Taxes (13.34) (13.34) GL 83 10/05/2017 Property Taxes (14.52) (27.86) GL 84 10/06/2017 Property Taxes (13.81) (41.67) GL 86 10/12/2017 Property Taxes (17.86) (59.53) GL 162 10/16/2017 Property Taxes (229.28) (288.81) GL 165 10/20/2017 Property Taxes (325.17) (613.98) GL 166 10/23/2017 Property Taxes (697.37) (1,311.35) GL 170 10/30/2017 Property Taxes (3.62) (1,314.97) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (1,314.97) * _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (1,314.97) ** Account: 122-40020-000-000 Property Taxes/Fire P&I 81 10/02/2017 Property Taxes (.03) (.03) GL Account: 122-40020-000-000 Property Taxes/Fire P&I . glpytb2 rgonzale Trophy Club MUD No.1 Page 2 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 83 10/05/2017 Property Taxes (3.68) (3.71) GL 84 10/06/2017 Property Taxes (5.46) (9.17) GL 86 10/12/2017 Property Taxes (4.11) (13.28) GL 162 10/16/2017 Property Taxes (50.24) (63.52) GL 166 10/23/2017 Property Taxes (173.74) (237.26) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (237.26) * _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (237.26) ** Department Totals: (7,154.15) *** . glpytb2 rgonzale Trophy Club MUD No.1 Page 3 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 122-55080-045-000 Maintenance & Repairs 25 10/05/2017 October A/P Clean grease trap at Fire Stat 1,490.49 1,490.49 Above and Beyond Plumbing Svc 3591 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,490.49 * _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,490.49 ** Account: 122-55090-045-000 Vehicle Maintenance 211 10/26/2017 Pcard 09/27/17 - 10/26/17 DENTON CO TX MOTOR VEH 7.50 7.50 DENTON CO TX MOTOR VEH PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 DENTON CO TX MOTOR VEH 1.00 8.50 DENTON CO TX MOTOR VEH PC 256 10/31/2017 Town Billed Invoice #1599-1603 AR 20171031-20171031 User: (8.50) .00 AR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - .00 * _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 ** Account: 122-60055-045-000 Insurance 232 10/01/2017 Insurance/Wrk Comp Exp Oct 1,269.87 1,269.87 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,269.87 * _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 ** Account: 122-60337-045-000 Transfer to Town/Fire Budget 32 10/06/2017 Oct A/P Fire Admin October 2017 50,742.50 50,742.50 TOWN OF TROPHY CLUB 3608 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 50,742.50 * _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 ** Account: 122-69195-045-000 GASB34/Reserve for Replacement . glpytb2 rgonzale Trophy Club MUD No.1 Page 4 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 41 10/01/2017 GASB 34 transfers FY 2018 Fire Truck Future Replacement 81,420.00 81,420.00 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 81,420.00 * _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 ** Account: 122-69305-045-000 Capital Leases 25 10/05/2017 October A/P Lease Payment Fire Ladder Truc 127,148.60 127,148.60 PNC Bank, N.A. 3604 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 127,148.60 * _______________ Account: 122-69305-045-000 Capital Leases Totals: 127,148.60 ** Department 45 Totals: 262,071.46 *** Fund 122 Totals: 254,917.31 **** TROPHY CLUB MUD #1 - O&M BALANCE SHEET OCTOBER 2017 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 939,321 - 939,321 CASH IN BANK-SAVINGS-CASH RESERVE 581,054 - 581,054 CD-BANK OF THE WEST/THB DEPOSIT 35,316 - 35,316 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 714,043 - 714,043 INVESTMENTS-TEXPOOL 1,443,693 596,426 2,040,119 PREPAID EXPENSES 96,702 - 96,702 ADVALOREM PROPERTY TAXES RECEIVABLE 122,940 - 122,940 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,278,205 - 1,278,205 TOTAL ASSETS 5,211,874 596,426 5,808,300 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 122,940 - 122,940 ACCOUNTS AND OTHER PAYABLES 436,283 - 436,283 CUSTOMER DEPOSITS 312,445 - 312,445 - TOTAL LIABILITIES 871,668 - 871,668 FUND BALANCE NON-SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 408,421 408,421 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 3,733,461 - 3,733,461 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 189,838 - 189,838 - TOTAL FUND BALANCE 4,340,206 596,426 4,936,632 TOTAL LIABILITIES AND FUND BALANCE 5,211,874 596,426 5,808,300 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/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- 642.54- 642.54- .531 120,307.46- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 80.01- 80.01- 40.005 119.99- 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 14.31- 14.31- 7.155 185.69- 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 736.86- 736.86- .246 298,452.14- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 462,795.39- 462,795.39- 7.160 6,001,223.61- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 225,901.65- 225,901.65- 7.586 2,752,165.35- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 12,029.31- 12,029.31- 11.319 94,249.69- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 725.00- 725.00- 3.396 20,625.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 100.00- 100.00- 6.667 1,400.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 300.00- 6.667 4,200.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 60,000.00- Subtotal: 9,635,715.00- 9,635,715.00- 701,851.35- 701,851.35- 7.284 8,933,863.65- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 2,850.43- 2,850.43- 23.754 9,149.57- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 910.53- 8.334 10,015.47- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 686.00- 686.00- 3.774 17,493.00- 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 2,070.98- 2,070.98- 41.420 2,929.02- 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- 7,101.27- 7,101.27- 2.253 308,023.73- Program number: 10,250,029.00- 10,250,029.00- 709,689.48- 709,689.48- 6.924 9,540,339.52- Department number: Revenues 10,250,029.00- 10,250,029.00- 709,689.48- 709,689.48- 6.924 9,540,339.52- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 709,689.48- 709,689.48- 6.924 9,540,339.52- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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 9,342.54 9,342.54 3.406 264,936.46 135-50010-010-000 Overtime 20,000.00 20,000.00 106.50 106.50 .533 19,893.50 135-50016-010-000 Longevity 3,425.00 3,425.00 3,425.00 135-50017-010-000 Certification 3,300.00 3,300.00 250.00 250.00 7.576 3,050.00 135-50020-010-000 Retirement 27,843.00 27,843.00 2,307.12 2,307.12 8.286 25,535.88 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,834.65 2,834.65 5.431 49,361.35 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 280.99 280.99 5.422 4,901.01 135-50028-010-000 Vision Insurance 994.00 994.00 58.27 58.27 5.862 935.73 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 278.12 278.12 9.327 2,703.88 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 592.11 592.11 3.173 18,069.89 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 138.49 138.49 3.173 4,226.51 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 4.29 4.29 .397 1,075.71 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 899.92 7.592 10,954.08 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 300.00 300.00 18.99 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 17,111.99 17,111.99 4.011 409,550.01 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 406.70 406.70 .407 99,593.30 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 4,000.00 4,000.00 1,149.42 1,149.42 28.736 2,850.58 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 1,130.74 1,130.74 20.559 4,369.26 Subtotal: 391,000.00 391,000.00 2,686.86 2,686.86 .687 388,313.14 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 4,700.00 135-60020-010-000 Electricity 175,356.00 175,356.00 14,905.08 14,905.08 8.500 160,450.92 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 8.36 2.090 391.64 135-60100-010-000 Travel & per diem 1,735.00 1,735.00 1,735.00 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 55,176.00 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 2,823,170.00 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 214.70 7.157 2,785.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 750.00 5.085 14,000.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 25,280.31 9.091 252,803.69 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 4,083.00 8.333 44,913.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 2,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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 45,241.45 45,241.45 1.252 3,568,610.55 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 769.12 769.12 5.127 14,230.88 135-65010-010-000 Uniforms 4,488.00 4,488.00 4,488.00 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,722.70 1,722.70 8.614 18,277.30 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,491.82 2,491.82 1.418 173,196.18 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 810,012.00 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 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 65,920.00 65,920.00 55.500 52,855.00 Subtotal: 1,048,231.00 1,048,231.00 140,920.00 140,920.00 13.444 907,311.00 Program number: 5,655,433.00 5,655,433.00 208,452.12 208,452.12 3.686 5,446,980.88 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/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 296.19 296.19 14.810 1,703.81 Subtotal: 2,000.00 2,000.00 296.19 296.19 14.810 1,703.81 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 296.19 296.19 14.810 1,703.81 Department number: Water 5,657,433.00 5,657,433.00 208,748.31 208,748.31 3.690 5,448,684.69 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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 15,469.41 15,469.41 3.765 395,396.59 135-50010-020-000 Overtime 30,000.00 30,000.00 1,476.35 1,476.35 4.921 28,523.65 135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 135-50017-020-000 Certification 8,400.00 8,400.00 700.00 700.00 8.333 7,700.00 135-50020-020-000 Retirement 42,243.00 42,243.00 3,096.69 3,096.69 7.331 39,146.31 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 4,710.20 4,710.20 7.576 57,464.80 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 399.32 399.32 7.576 4,871.68 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 84.33 84.33 7.570 1,029.67 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 395.14 395.14 9.230 3,885.86 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,019.46 1,019.46 3.601 27,294.54 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 238.41 238.41 3.600 6,383.59 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 1,348.00 7.493 16,642.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 28,937.31 28,937.31 4.618 597,663.69 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 273.10 273.10 .317 85,826.90 135-55085-020-000 Generator Maint. and Repair 14,000.00 14,000.00 14,000.00 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 2,628.73 2,628.73 32.859 5,371.27 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 5,295.61 5,295.61 8.826 54,704.39 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 5,437.82 5,437.82 18.126 24,562.18 Subtotal: 219,150.00 219,150.00 13,635.26 13,635.26 6.222 205,514.74 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 4,700.00 135-60020-020-000 Electricity 266,709.00 266,709.00 13,288.76 13,288.76 4.982 253,420.24 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 8.37 1.522 541.63 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 1,635.00 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 9,888.02 9,888.02 11.633 75,111.98 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 590.00 590.00 5.086 11,010.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 11,094.81 9.091 110,948.19 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 54,430.72 9.091 544,307.28 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 10,278.00 8.333 113,058.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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 99,578.68 99,578.68 6.920 1,339,359.32 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 743.89 743.89 5.951 11,756.11 135-65010-020-000 Uniforms 4,459.00 4,459.00 1,614.63 1,614.63 36.211 2,844.37 135-65030-020-000 Chemicals 27,500.00 27,500.00 27,500.00 135-65035-020-000 Small Tools 1,000.00 1,000.00 71.53 71.53 7.153 928.47 135-65040-020-000 Safety Equipment 750.00 750.00 750.00 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 560.55 560.55 4.004 13,439.45 Subtotal: 60,209.00 60,209.00 2,990.60 2,990.60 4.967 57,218.40 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 1,563.49 1,563.49 .286 545,763.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 30,000.00 100.000 Subtotal: 636,242.00 636,242.00 31,563.49 31,563.49 4.961 604,678.51 Program number: 2,981,140.00 2,981,140.00 176,705.34 176,705.34 5.927 2,804,434.66 Department number: Wastewater 2,981,140.00 2,981,140.00 176,705.34 176,705.34 5.927 2,804,434.66 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/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 2.42 8.067 27.58 Subtotal: 30.00 30.00 2.42 2.42 8.067 27.58 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 600.00 600.00 600.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 4,000.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 2,000.00 Subtotal: 12,950.00 12,950.00 12,950.00 Program number: 12,980.00 12,980.00 2.42 2.42 .019 12,977.58 Department number: Board of Directors 12,980.00 12,980.00 2.42 2.42 .019 12,977.58 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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 15,186.73 15,186.73 3.508 417,676.27 135-50010-030-000 Overtime 2,000.00 2,000.00 4.83 4.83 .242 1,995.17 135-50016-030-000 Longevity 3,548.00 3,548.00 3,548.00 135-50020-030-000 Retirement 40,553.00 40,553.00 3,712.17 3,712.17 9.154 36,840.83 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 3,349.61 3,349.61 5.276 60,135.39 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 311.37 311.37 5.659 5,190.63 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 66.77 66.77 5.692 1,106.23 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 285.70 285.70 5.647 4,773.30 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 892.33 892.33 3.283 26,288.67 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 208.69 208.69 3.283 6,148.31 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 1.68 1.68 .133 1,258.32 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 123.50 8.077 1,405.50 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 124.95 124.95 24.990 375.05 135-50070-030-000 Employee Relations 4,960.00 4,960.00 92.38 92.38 1.863 4,867.62 Subtotal: 595,970.00 595,970.00 24,360.71 24,360.71 4.088 571,609.29 135-55030-030-000 Software & Support 78,391.00 78,391.00 5,157.98 5,157.98 6.580 73,233.02 135-55070-030-000 Independent Labor 154,000.00 154,000.00 16,514.89 16,514.89 10.724 137,485.11 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 33.24 33.24 .237 13,966.76 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 186.59- 186.59- -1.866 10,186.59 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 56,475.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 573.93 573.93 6.377 8,426.07 Subtotal: 338,916.00 338,916.00 78,568.45 78,568.45 23.182 260,347.55 135-60005-030-000 Telephone 27,300.00 27,300.00 661.01 661.01 2.421 26,638.99 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 225.00 225.00 5.625 3,775.00 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 16,261.00 135-60025-030-000 Water 2,500.00 2,500.00 58.10 58.10 2.324 2,441.90 135-60035-030-000 Postage 30,000.00 30,000.00 1,702.91 1,702.91 5.676 28,297.09 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 5,569.85 5,569.85 10.025 49,990.15 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 6,100.36 10.894 49,899.64 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 6,000.00 135-60075-030-000 Meetings 400.00 400.00 400.00 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 659.00 659.00 8.671 6,941.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 27.92 27.92 .572 4,857.08 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 4,500.00 4,500.00 45.00 45.00 1.000 4,455.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 202.53 202.53 8.101 2,297.47 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 2,500.00 Subtotal: 249,506.00 249,506.00 15,251.68 15,251.68 6.113 234,254.32 135-65010-030-000 Uniforms 700.00 700.00 700.00 135-65055-030-000 Hardware 7,420.00 7,420.00 597.95 597.95 8.059 6,822.05 135-65085-030-000 Office Supplies 7,000.00 7,000.00 829.47 829.47 11.850 6,170.53 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 1,173.37 1,173.37 58.669 826.63 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 334.92 334.92 8.373 3,665.08 135-65105-030-000 Printing 4,000.00 4,000.00 4,000.00 Subtotal: 25,120.00 25,120.00 2,935.71 2,935.71 11.687 22,184.29 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 13,000.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 78.42 78.42 1.705 4,521.58 Subtotal: 17,600.00 17,600.00 78.42 78.42 .446 17,521.58 Program number: 1,227,112.00 1,227,112.00 121,194.97 121,194.97 9.876 1,105,917.03 Department number: Administration 1,227,112.00 1,227,112.00 121,194.97 121,194.97 9.876 1,105,917.03 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 14:13 11/15/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/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 8,200.00 8,200.00 5.985 128,800.00 135-55055-039-000 Auditing 24,500.00 24,500.00 5,000.00 5,000.00 20.408 19,500.00 135-55060-039-000 Appraisal 11,446.00 11,446.00 11,446.00 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 176,746.00 176,746.00 13,200.00 13,200.00 7.468 163,546.00 Program number: 176,746.00 176,746.00 13,200.00 13,200.00 7.468 163,546.00 Department number: Non Departmental 176,746.00 176,746.00 13,200.00 13,200.00 7.468 163,546.00 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 519,851.04 519,851.04 5.170 9,535,559.96 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 189,838.44- 189,838.44- 97.544 4,779.56- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 14:13 11/15/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 10/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- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00- 186,420.00 Revenues Subtotal ----------- 186,420.00- 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00- 186,420.00 . glpytb2 rgonzale Trophy Club MUD No.1 Page 5 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-40000-000-000 Property Taxes 81 10/02/2017 Property Taxes (4.76) (4.76) GL 82 10/04/2017 Property Taxes (27.69) (32.45) GL 84 10/06/2017 Property Taxes (21.21) (53.66) GL 85 10/10/2017 Property Taxes (48.40) (102.06) GL 162 10/16/2017 Property Taxes (80.96) (183.02) GL 163 10/17/2017 Property Taxes (6.18) (189.20) GL 164 10/19/2017 Property Taxes (29.02) (218.22) GL 166 10/23/2017 Property Taxes (70.37) (288.59) GL 168 10/26/2017 Property Taxes (79.96) (368.55) GL 169 10/27/2017 Property Taxes (83.85) (452.40) GL 170 10/30/2017 Property Taxes (76.17) (528.57) GL 172 10/31/2017 Property Taxes (113.97) (642.54) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (642.54) * _______________ Account: 135-40000-000-000 Property Taxes Totals: (642.54) ** Account: 135-40002-000-000 Property Taxes/Delinquent 81 10/02/2017 Property Taxes (.81) (.81) GL 83 10/05/2017 Property Taxes (.85) (1.66) GL 84 10/06/2017 Property Taxes (1.46) (3.12) GL 86 10/12/2017 Property Taxes (1.05) (4.17) GL 162 10/16/2017 Property Taxes (13.49) (17.66) GL 165 10/20/2017 Property Taxes (21.11) (38.77) GL 166 10/23/2017 Property Taxes (41.03) (79.80) GL 170 10/30/2017 Property Taxes (.21) (80.01) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (80.01) * _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (80.01) ** Account: 135-40015-000-000 Property Taxes/P & I 83 10/05/2017 Property Taxes (.22) (.22) GL Account: 135-40015-000-000 Property Taxes/P & I . glpytb2 rgonzale Trophy Club MUD No.1 Page 6 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 84 10/06/2017 Property Taxes (.68) (.90) GL 86 10/12/2017 Property Taxes (.24) (1.14) GL 162 10/16/2017 Property Taxes (2.95) (4.09) GL 166 10/23/2017 Property Taxes (10.22) (14.31) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (14.31) * _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (14.31) ** Account: 135-47000-000-000 Water 245 10/01/2017 Rev Accr Utility Billing 9/30 86,756.20 86,756.20 GL 167 10/31/2017 Billing-October 2017 UB20171031-20171031 User: (549,551.59) (462,795.39) UB OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (462,795.39) * _______________ Account: 135-47000-000-000 Water Totals: (462,795.39) ** Account: 135-47005-000-000 Sewer 245 10/01/2017 Rev Accr Utility Billing 9/30 31,463.61 31,463.61 GL 175 10/06/2017 UB 10/6/17 Sewer adj UB20171006-20171006 User: 602.82 32,066.43 UB 167 10/31/2017 Billing-October 2017 UB20171031-20171031 User: (257,968.08) (225,901.65) UB OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (225,901.65) * _______________ Account: 135-47005-000-000 Sewer Totals: (225,901.65) ** Account: 135-47025-000-000 Penalties 117 10/23/2017 Penalties-october 2017 UB20171023-20171023 User: (12,829.82) (12,829.82) UB 178 10/23/2017 UB 10/23/17-penalty removal UB20171023-20171023 User: 30.47 (12,799.35) UB 180 10/31/2017 UB 10/31/17 Penalty removal UB20171031-20171031 User: 770.04 (12,029.31) UB OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (12,029.31) * Account: 135-47025-000-000 Penalties . glpytb2 rgonzale Trophy Club MUD No.1 Page 7 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id _______________ Account: 135-47025-000-000 Penalties Totals: (12,029.31) ** Account: 135-47030-000-000 Service Charges 48 10/11/2017 Cut Off List-October 2017 UB20171011-20171011 User: (625.00) (625.00) UB 176 10/17/2017 Ub NSF Checks UB20171017-20171017 User: (50.00) (675.00) UB 177 10/20/2017 UB 10/20/17 NSF Checks UB20171020-20171020 User: (50.00) (725.00) UB OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (725.00) * _______________ Account: 135-47030-000-000 Service Charges Totals: (725.00) ** Account: 135-47035-000-000 Plumbing Inspections 12 10/03/2017 Permitting Checks 504 Asheville Lane (50.00) (50.00) Ashton Wood Homes CR 12 10/03/2017 Permitting Checks 657 Sheldon Drive (50.00) (100.00) Ashton Wood Homes CR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (100.00) * _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) ** Account: 135-47045-000-000 Sewer Inspections 12 10/03/2017 Permitting Checks 504 Asheville Lane (150.00) (150.00) Ashton Wood Homes CR 12 10/03/2017 Permitting Checks 657 Sheldon Drive (150.00) (300.00) Ashton Wood Homes CR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (300.00) * _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) ** Account: 135-49010-000-000 Interest Income 230 10/31/2017 October Bank Interest (156.47) (156.47) GL 230 10/31/2017 October Bank Interest (434.41) (590.88) GL Account: 135-49010-000-000 Interest Income . glpytb2 rgonzale Trophy Club MUD No.1 Page 8 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 230 10/31/2017 October Bank Interest (2,259.55) (2,850.43) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (2,850.43) * _______________ Account: 135-49010-000-000 Interest Income Totals: (2,850.43) ** Account: 135-49016-000-000 Cell Tower Revenue 193 10/05/2017 AT&T Cell Tower Revenue (910.53) (910.53) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (910.53) * _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) ** Account: 135-49018-000-000 Building Rent Income 256 10/31/2017 Town Billed Invoice #1599-1603 AR 20171031-20171031 User: (583.33) (583.33) AR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (583.33) * _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) ** Account: 135-49075-000-000 Oversize Meter Reimbursement 12 10/03/2017 Permitting Checks 504 Asheville Lane (343.00) (343.00) Ashton Wood Homes CR 12 10/03/2017 Permitting Checks 657 Sheldon Drive (343.00) (686.00) Ashton Wood Homes CR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (686.00) * _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) ** Account: 135-49900-000-000 Miscellaneous Income 12 10/03/2017 Permitting Checks 657 Sheldon Drive (800.00) (800.00) Ashton Wood Homes CR Account: 135-49900-000-000 Miscellaneous Income . glpytb2 rgonzale Trophy Club MUD No.1 Page 9 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 194 10/27/2017 Ozarka Refund WWTP (6.13) (806.13) GL 195 10/27/2017 Tarrant Cty Elec2014 Refund (1,123.60) (1,929.73) GL 167 10/31/2017 Billing-October 2017 UB20171031-20171031 User: (141.25) (2,070.98) UB OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (2,070.98) * _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (2,070.98) ** Department Totals: (709,689.48) *** . glpytb2 rgonzale Trophy Club MUD No.1 Page 10 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-50005-010-000 Salaries & Wages 129 10/06/2017 Reverse Accrued Payroll (14,736.87) (14,736.87) GL 13 10/06/2017 MUD PR 10.06.17 Salaries & Wages 14,736.87 .00 PR 76 10/20/2017 MUD PR 10.20.17 Salaries & Wages 9,342.54 9,342.54 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 9,342.54 * _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 9,342.54 ** Account: 135-50010-010-000 Overtime 129 10/06/2017 Reverse Accrued Payroll (505.95) (505.95) GL 13 10/06/2017 MUD PR 10.06.17 Overtime 505.95 .00 PR 76 10/20/2017 MUD PR 10.20.17 Overtime 106.50 106.50 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 106.50 * _______________ Account: 135-50010-010-000 Overtime Totals: 106.50 ** Account: 135-50017-010-000 Certification 76 10/20/2017 MUD PR 10.20.17 Certification 250.00 250.00 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 250.00 * _______________ Account: 135-50017-010-000 Certification Totals: 250.00 ** Account: 135-50020-010-000 Retirement 13 10/06/2017 MUD PR 10.06.17 Retirement 1,409.96 1,409.96 PR 76 10/20/2017 MUD PR 10.20.17 Retirement 897.16 2,307.12 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 2,307.12 * _______________ Account: 135-50020-010-000 Retirement Totals: 2,307.12 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 11 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-50026-010-000 Medical Insurance 13 10/06/2017 MUD PR 10.06.17 Medical Insurance 1,417.32 1,417.32 PR 76 10/20/2017 MUD PR 10.20.17 Medical Insurance 1,417.33 2,834.65 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 2,834.65 * _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,834.65 ** Account: 135-50027-010-000 Dental Insurance 13 10/06/2017 MUD PR 10.06.17 Dental Insurance 140.52 140.52 PR 76 10/20/2017 MUD PR 10.20.17 Dental Insurance 140.47 280.99 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 280.99 * _______________ Account: 135-50027-010-000 Dental Insurance Totals: 280.99 ** Account: 135-50028-010-000 Vision Insurance 13 10/06/2017 MUD PR 10.06.17 Vision Insurance 29.16 29.16 PR 76 10/20/2017 MUD PR 10.20.17 Vision Insurance 29.11 58.27 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 58.27 * _______________ Account: 135-50028-010-000 Vision Insurance Totals: 58.27 ** Account: 135-50029-010-000 Life Insurance & Other 11 10/03/2017 Oct A/P Dental, Vision, Life & other 267.45 267.45 METLIFE GROUP BENEFITS 3600 AP 105 10/20/2017 October A/P Café 125 Admin 10.67 278.12 BenefitMall 3621 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 278.12 * _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 278.12 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 12 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-50030-010-000 Social Security Taxes 129 10/06/2017 Reverse Accrued Payroll (951.26) (951.26) GL 13 10/06/2017 MUD PR 10.06.17 Social Security Taxes 951.26 .00 PR 76 10/20/2017 MUD PR 10.20.17 Social Security Taxes 592.11 592.11 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 592.11 * _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 592.11 ** Account: 135-50035-010-000 Medicare Taxes 129 10/06/2017 Reverse Accrued Payroll (222.47) (222.47) GL 13 10/06/2017 MUD PR 10.06.17 Medicare Taxes 222.47 .00 PR 76 10/20/2017 MUD PR 10.20.17 Medicare Taxes 138.49 138.49 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 138.49 * _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 138.49 ** Account: 135-50040-010-000 Unemployment Taxes 13 10/06/2017 MUD PR 10.06.17 Unemployment Taxes 2.10 2.10 PR 76 10/20/2017 MUD PR 10.20.17 Unemployment Taxes 2.19 4.29 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 4.29 * _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 4.29 ** Account: 135-50045-010-000 Workman's Compensation 232 10/01/2017 Insurance/Wrk Comp Exp Oct 899.92 899.92 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 899.92 * _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 13 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-50060-010-000 Pre-emp Physicals/Testing 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ZIPRECRUITER, INC. 202.53 202.53 ZIPRECRUITER, INC. PC 272 10/26/2017 Recode ZipRecrutier Pcard- Adv (202.53) .00 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - .00 * _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 ** Account: 135-50070-010-000 Employee Relations 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TOM THUMB #1789 18.99 18.99 TOM THUMB #1789 PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 18.99 * _______________ Account: 135-50070-010-000 Employee Relations Totals: 18.99 ** Account: 135-55080-010-000 Maintenance & Repairs 211 10/26/2017 Pcard 09/27/17 - 10/26/17 THE HOME DEPOT #6581 12.81 12.81 THE HOME DEPOT #6581 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 THE HOME DEPOT #6581 150.45 163.26 THE HOME DEPOT #6581 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 FERGUSON ENT 1241 47.84 211.10 FERGUSON ENT 1241 PC 187 10/31/2017 October A/P Water parts 195.60 406.70 Core & Main LP 3647 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 406.70 * _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 406.70 ** Account: 135-55090-010-000 Vehicle Maintenance 49 10/11/2017 October A/P Brake work on 2015 F350 611.38 611.38 MICHAEL G. WATSON 3601 AP 79 10/17/2017 October A/P 2011 F150/Brake Repair 538.04 1,149.42 MICHAEL G. WATSON 3636 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,149.42 * _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,149.42 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 14 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-55135-010-000 Lab Analysis 211 10/26/2017 Pcard 09/27/17 - 10/26/17 THE HOME DEPOT #6581 40.99 40.99 THE HOME DEPOT #6581 PC 219 10/31/2017 Oct A/P TCEQ Samples 864.75 905.74 LOWER COLORADO RIVER AUTHORITY 3682 AP 247 10/31/2017 Oct A/P Water Samples 225.00 1,130.74 TARRANT CTY PUBLIC HEALTH LAB AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,130.74 * _______________ Account: 135-55135-010-000 Lab Analysis Totals: 1,130.74 ** Account: 135-60020-010-000 Electricity 79 10/17/2017 October A/P Electricity 9/11-10/10 136.57 136.57 HUDSON ENERGY SERVICES, LLC 3629 AP 79 10/17/2017 October A/P Electricity 52.13 188.70 HUDSON ENERGY SERVICES, LLC 3629 AP 103 10/20/2017 October A/P Electricity 9/12-10/11/17 14,716.38 14,905.08 HUDSON ENERGY SERVICES, LLC 3629 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 14,905.08 * _______________ Account: 135-60020-010-000 Electricity Totals: 14,905.08 ** Account: 135-60090-010-000 Safety Program 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TOM THUMB #1789 8.36 8.36 TOM THUMB #1789 PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 8.36 * _______________ Account: 135-60090-010-000 Safety Program Totals: 8.36 ** Account: 135-60280-010-000 Property Maintenance 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TEX-TURF 214.70 214.70 TEX-TURF PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 214.70 * _______________ Account: 135-60280-010-000 Property Maintenance Totals: 214.70 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 15 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-60285-010-000 Lawn Equipment & Maintenance 187 10/31/2017 October A/P October Mowing 750.00 750.00 WATTS ELLISON LLC 3671 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 750.00 * _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 ** Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 155 10/31/2017 Texpool Transfers 2016 SWIFT Rev Bond I&S 25,280.31 25,280.31 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 25,280.31 * _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 ** Account: 135-60333-010-000 Interfund Transfer Out-Reserve 155 10/31/2017 Texpool Transfers Transfer to Rev Bond Reserve 4,083.00 4,083.00 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 4,083.00 * _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 ** Account: 135-65005-010-000 Fuel & Lube 138 10/27/2017 October A/P Fuel Purchases 9/25-10/24/17 769.12 769.12 US Bank Voyager Fleet Systems 3643 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 769.12 * _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 769.12 ** Account: 135-65030-010-000 Chemicals 138 10/27/2017 October A/P Chlorine 663.72 663.72 DPC INDUSTRIES, INC 3624 AP Account: 135-65030-010-000 Chemicals . glpytb2 rgonzale Trophy Club MUD No.1 Page 16 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 153 10/31/2017 Oct A/P Testing Supplies 109.37 773.09 HACH COMPANY 3652 AP 187 10/31/2017 October A/P Testing Supplies 863.72 1,636.81 HACH COMPANY 3652 AP 217 10/31/2017 Oct A/P Testing Supplies 85.89 1,722.70 HACH COMPANY 3674 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,722.70 * _______________ Account: 135-65030-010-000 Chemicals Totals: 1,722.70 ** Account: 135-69195-010-000 Gasb34/Reserve for Replacement 41 10/01/2017 GASB 34 transfers FY 2018 Town Elevated Tank 45,000.00 45,000.00 GL 41 10/01/2017 GASB 34 transfers FY 2018 Water Replacement 30,000.00 75,000.00 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 75,000.00 * _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 ** Account: 135-69281-010-000 Water Tank Inspection Contract 153 10/31/2017 Oct A/P 2m GST Water Plant #2 West ann 45,775.00 45,775.00 UTILITY SERVICE CO, INC. 3670 AP 153 10/31/2017 Oct A/P TW King Elev Tank annual Maiin 20,145.00 65,920.00 UTILITY SERVICE CO, INC. 3670 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 65,920.00 * _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 65,920.00 ** Account: 135-55135-010-001 Lab Analysis for PID 247 10/31/2017 Oct A/P Water Samples-PID 80.00 80.00 TARRANT CTY PUBLIC HEALTH LAB AP 247 10/31/2017 Oct A/P TCEQ Samples-PID 216.19 296.19 LOWER COLORADO RIVER AUTHORITY AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 296.19 * _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 296.19 ** Account: 135-55135-010-001 Lab Analysis for PID . glpytb2 rgonzale Trophy Club MUD No.1 Page 17 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Department 10 Totals: 208,748.31 *** . glpytb2 rgonzale Trophy Club MUD No.1 Page 18 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-50005-020-000 Salaries & Wages 129 10/06/2017 Reverse Accrued Payroll (15,048.57) (15,048.57) GL 13 10/06/2017 MUD PR 10.06.17 Salaries & Wages 15,048.57 .00 PR 76 10/20/2017 MUD PR 10.20.17 Salaries & Wages 15,469.41 15,469.41 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 15,469.41 * _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,469.41 ** Account: 135-50010-020-000 Overtime 129 10/06/2017 Reverse Accrued Payroll (783.44) (783.44) GL 13 10/06/2017 MUD PR 10.06.17 Overtime 783.44 .00 PR 76 10/20/2017 MUD PR 10.20.17 Overtime 1,476.35 1,476.35 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,476.35 * _______________ Account: 135-50010-020-000 Overtime Totals: 1,476.35 ** Account: 135-50017-020-000 Certification 76 10/20/2017 MUD PR 10.20.17 Certification 700.00 700.00 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 700.00 * _______________ Account: 135-50017-020-000 Certification Totals: 700.00 ** Account: 135-50020-020-000 Retirement 13 10/06/2017 MUD PR 10.06.17 Retirement 1,464.46 1,464.46 PR 76 10/20/2017 MUD PR 10.20.17 Retirement 1,632.23 3,096.69 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 3,096.69 * _______________ Account: 135-50020-020-000 Retirement Totals: 3,096.69 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 19 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-50026-020-000 Medical Insurance 13 10/06/2017 MUD PR 10.06.17 Medical Insurance 2,355.10 2,355.10 PR 76 10/20/2017 MUD PR 10.20.17 Medical Insurance 2,355.10 4,710.20 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 4,710.20 * _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 ** Account: 135-50027-020-000 Dental Insurance 13 10/06/2017 MUD PR 10.06.17 Dental Insurance 199.69 199.69 PR 76 10/20/2017 MUD PR 10.20.17 Dental Insurance 199.63 399.32 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 399.32 * _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 ** Account: 135-50028-020-000 Vision Insurance 13 10/06/2017 MUD PR 10.06.17 Vision Insurance 42.19 42.19 PR 76 10/20/2017 MUD PR 10.20.17 Vision Insurance 42.14 84.33 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 84.33 * _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 ** Account: 135-50029-020-000 Life Insurance & Other 11 10/03/2017 Oct A/P Dental, Vision, Life & other 361.15 361.15 METLIFE GROUP BENEFITS 3600 AP 105 10/20/2017 October A/P Café 125 Admin 33.99 395.14 BenefitMall 3621 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 395.14 * _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 395.14 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 20 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-50030-020-000 Social Security Taxes 129 10/06/2017 Reverse Accrued Payroll (935.02) (935.02) GL 13 10/06/2017 MUD PR 10.06.17 Social Security Taxes 935.02 .00 PR 76 10/20/2017 MUD PR 10.20.17 Social Security Taxes 1,019.46 1,019.46 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,019.46 * _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,019.46 ** Account: 135-50035-020-000 Medicare Taxes 129 10/06/2017 Reverse Accrued Payroll (218.68) (218.68) GL 13 10/06/2017 MUD PR 10.06.17 Medicare Taxes 218.68 .00 PR 76 10/20/2017 MUD PR 10.20.17 Medicare Taxes 238.41 238.41 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 238.41 * _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 238.41 ** Account: 135-50045-020-000 Workman's Compensation 232 10/01/2017 Insurance/Wrk Comp Exp Oct 1,348.00 1,348.00 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,348.00 * _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 ** Account: 135-55080-020-000 Maintenance & Repairs 133 10/26/2017 October A/P Lost communication with SCADA 250.00 250.00 RLC Controls 3641 AP 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ACADEMY SPORTS #81 9.49 259.49 ACADEMY SPORTS #81 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 WAL-MART #5247 13.61 273.10 WAL-MART #5247 PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 273.10 * Account: 135-55080-020-000 Maintenance & Repairs . glpytb2 rgonzale Trophy Club MUD No.1 Page 21 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 273.10 ** Account: 135-55090-020-000 Vehicle Maintenance 211 10/26/2017 Pcard 09/27/17 - 10/26/17 DENTON CO TX MOTOR VEH 1.00 1.00 DENTON CO TX MOTOR VEH PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 DENTON CO TX MOTOR VEH 7.50 8.50 DENTON CO TX MOTOR VEH PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 USA BLUE BOOK 228.00 236.50 USA BLUE BOOK PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 CLASSIC CHEVROLET LT 2,392.23 2,628.73 CLASSIC CHEVROLET LT PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 2,628.73 * _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 2,628.73 ** Account: 135-55125-020-000 Dumpster Services 133 10/26/2017 October A/P Sludge haul off 1,832.38 1,832.38 L.H. CHANEY MATERIALS, INC. 3633 AP 133 10/26/2017 October A/P Sludge haul off 1,735.63 3,568.01 L.H. CHANEY MATERIALS, INC. 3633 AP 219 10/31/2017 Oct A/P Sludge Haul off 845.00 4,413.01 L.H. CHANEY MATERIALS, INC. 3680 AP 219 10/31/2017 Oct A/P Sludge Haul off 882.60 5,295.61 L.H. CHANEY MATERIALS, INC. 3680 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 5,295.61 * _______________ Account: 135-55125-020-000 Dumpster Services Totals: 5,295.61 ** Account: 135-55135-020-000 Lab Analysis 49 10/11/2017 October A/P Testing 246.00 246.00 OXIDOR LABORATORIES LLC 3603 AP 49 10/11/2017 October A/P Testing 176.00 422.00 OXIDOR LABORATORIES LLC 3603 AP 49 10/11/2017 October A/P Testing 205.50 627.50 OXIDOR LABORATORIES LLC 3603 AP 49 10/11/2017 October A/P Testing 246.00 873.50 OXIDOR LABORATORIES LLC 3603 AP 49 10/11/2017 October A/P Testing 176.00 1,049.50 OXIDOR LABORATORIES LLC 3603 AP 49 10/11/2017 October A/P Quanti-Tray Disposable, Gamma 1,940.32 2,989.82 IDEXX DISTRIBUTION, INC 3596 AP 133 10/26/2017 October A/P Testing 150.50 3,140.32 OXIDOR LABORATORIES LLC 3640 AP 133 10/26/2017 October A/P Testing 176.00 3,316.32 OXIDOR LABORATORIES LLC 3640 AP 133 10/26/2017 October A/P Testing 246.00 3,562.32 OXIDOR LABORATORIES LLC 3640 AP Account: 135-55135-020-000 Lab Analysis . glpytb2 rgonzale Trophy Club MUD No.1 Page 22 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 133 10/26/2017 October A/P Testing 176.00 3,738.32 OXIDOR LABORATORIES LLC 3640 AP 133 10/26/2017 October A/P Testing 205.50 3,943.82 OXIDOR LABORATORIES LLC 3640 AP 133 10/26/2017 October A/P Testing 246.00 4,189.82 OXIDOR LABORATORIES LLC 3640 AP 219 10/31/2017 Oct A/P Testing 205.50 4,395.32 OXIDOR LABORATORIES LLC 3684 AP 219 10/31/2017 Oct A/P Testing 510.00 4,905.32 OXIDOR LABORATORIES LLC 3684 AP 219 10/31/2017 Oct A/P Testing 205.50 5,110.82 OXIDOR LABORATORIES LLC 3684 AP 219 10/31/2017 Oct A/P Testing 327.00 5,437.82 OXIDOR LABORATORIES LLC 3684 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 5,437.82 * _______________ Account: 135-55135-020-000 Lab Analysis Totals: 5,437.82 ** Account: 135-60020-020-000 Electricity 79 10/17/2017 October A/P Electricity WWTP 4,719.00 4,719.00 ENGIE Resources LLC 3625 AP 79 10/17/2017 October A/P Electricity 9/11-10/10 32.62 4,751.62 HUDSON ENERGY SERVICES, LLC 3629 AP 79 10/17/2017 October A/P Electricity 9/11-10/10 74.46 4,826.08 HUDSON ENERGY SERVICES, LLC 3629 AP 79 10/17/2017 October A/P Electricity 9/12-10/11 97.56 4,923.64 HUDSON ENERGY SERVICES, LLC 3629 AP 103 10/20/2017 October A/P Electricity 9/12-10/11/17 234.10 5,157.74 MP2 ENERGY TEXAS LLC 3637 AP 103 10/20/2017 October A/P Electricity 9/12--10/11/17 7,848.54 13,006.28 HUDSON ENERGY SERVICES, LLC 3629 AP 103 10/20/2017 October A/P Electricity 9/12-10/11/17 461.05 13,467.33 HUDSON ENERGY SERVICES, LLC 3629 AP 256 10/31/2017 Town Billed Invoice #1599-1603 AR 20171031-20171031 User: (178.57) 13,288.76 AR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 13,288.76 * _______________ Account: 135-60020-020-000 Electricity Totals: 13,288.76 ** Account: 135-60090-020-000 Safety Program 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TOM THUMB #1789 8.37 8.37 TOM THUMB #1789 PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 8.37 * _______________ Account: 135-60090-020-000 Safety Program Totals: 8.37 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 23 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-60135-020-000 TCEQ Fees & Permits 153 10/31/2017 Oct A/P WWTP Permit 9,888.02 9,888.02 TX COMMISSION ENVIRONMENTAL QU 3669 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 9,888.02 * _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 9,888.02 ** Account: 135-60285-020-000 Lawn Equipment & Maintenance 187 10/31/2017 October A/P October Mowing 590.00 590.00 WATTS ELLISON LLC 3671 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 590.00 * _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 ** Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 155 10/31/2017 Texpool Transfers PID Share New Tax Debt 11,094.81 11,094.81 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 11,094.81 * _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 ** Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 155 10/31/2017 Texpool Transfers Rev Bond WWTP I&S 54,430.72 54,430.72 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 54,430.72 * _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 ** Account: 135-60333-020-000 Interfund Transfer Out-Reserve 155 10/31/2017 Texpool Transfers Transfer to Rev Bond Reserve 10,278.00 10,278.00 GL . glpytb2 rgonzale Trophy Club MUD No.1 Page 24 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 10,278.00 * _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 ** Account: 135-65005-020-000 Fuel & Lube 138 10/27/2017 October A/P Fuel Purchases 9/25-10/24/17 743.89 743.89 US Bank Voyager Fleet Systems 3643 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 743.89 * _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 743.89 ** Account: 135-65010-020-000 Uniforms 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ACADEMY SPORTS #81 35.98 35.98 ACADEMY SPORTS #81 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ACADEMY SPORTS #141 232.90 268.88 ACADEMY SPORTS #141 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 RED WING SHOES #652 169.99 438.87 RED WING SHOES #652 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 RED WING SHOES #652 175.00 613.87 RED WING SHOES #652 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 #02 DICKIES OUTLET FW 47.98 661.85 #02 DICKIES OUTLET FW PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 #02 DICKIES OUTLET FW 46.48 708.33 #02 DICKIES OUTLET FW PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 #02 DICKIES OUTLET FW 8.65 716.98 #02 DICKIES OUTLET FW PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 #02 DICKIES OUTLET FW 46.48 763.46 #02 DICKIES OUTLET FW PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 RED WING SHOES #652 159.99 923.45 RED WING SHOES #652 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ACADEMY SPORTS #76 129.99 1,053.44 ACADEMY SPORTS #76 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ACADEMY SPORTS #141 68.97 1,122.41 ACADEMY SPORTS #141 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 #02 DICKIES OUTLET FW (3.87) 1,118.54 #02 DICKIES OUTLET FW PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 #02 DICKIES OUTLET FW 155.80 1,274.34 #02 DICKIES OUTLET FW PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 RED WING SHOES #652 165.29 1,439.63 RED WING SHOES #652 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 RED WING SHOES #652 175.00 1,614.63 RED WING SHOES #652 PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,614.63 * _______________ Account: 135-65010-020-000 Uniforms Totals: 1,614.63 ** Account: 135-65035-020-000 Small Tools . glpytb2 rgonzale Trophy Club MUD No.1 Page 25 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 211 10/26/2017 Pcard 09/27/17 - 10/26/17 THE HOME DEPOT #6581 35.94 35.94 THE HOME DEPOT #6581 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TRACTOR SUPPLY COMPANY 35.59 71.53 TRACTOR SUPPLY COMPANY PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 71.53 * _______________ Account: 135-65035-020-000 Small Tools Totals: 71.53 ** Account: 135-65045-020-000 Lab Supplies 79 10/17/2017 October A/P Lab supplies 205.06 205.06 HACH COMPANY 3628 AP 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TOM THUMB #1789 5.00 210.06 TOM THUMB #1789 PC 219 10/31/2017 Oct A/P Lab Gloves 162.00 372.06 LOU'S GLOVES INCORPORATED 3681 AP 219 10/31/2017 Oct A/P Coliform/E Coli 188.49 560.55 IDEXX DISTRIBUTION, INC 3679 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 560.55 * _______________ Account: 135-65045-020-000 Lab Supplies Totals: 560.55 ** Account: 135-69005-020-000 Capital Outlays 211 10/26/2017 Pcard 09/27/17 - 10/26/17 MARRIOTT 1,563.49 1,563.49 MARRIOTT PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,563.49 * _______________ Account: 135-69005-020-000 Capital Outlays Totals: 1,563.49 ** Account: 135-69195-020-000 Gasb34/Reserve for Replacement 41 10/01/2017 GASB 34 transfers FY 2018 Sewer Replacement 30,000.00 30,000.00 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 30,000.00 * _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 30,000.00 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 26 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Department 20 Totals: 176,705.34 *** . glpytb2 rgonzale Trophy Club MUD No.1 Page 27 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-50045-026-000 Workman's Compensation 232 10/01/2017 Insurance/Wrk Comp Exp Oct 2.42 2.42 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 2.42 * _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 ** Department 26 Totals: 2.42 *** . glpytb2 rgonzale Trophy Club MUD No.1 Page 28 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-50005-030-000 Salaries & Wages 129 10/06/2017 Reverse Accrued Payroll (24,916.22) (24,916.22) GL 13 10/06/2017 MUD PR 10.06.17 Salaries & Wages 24,916.22 .00 PR 76 10/20/2017 MUD PR 10.20.17 Salaries & Wages 15,186.73 15,186.73 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 15,186.73 * _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 15,186.73 ** Account: 135-50010-030-000 Overtime 129 10/06/2017 Reverse Accrued Payroll (23.64) (23.64) GL 13 10/06/2017 MUD PR 10.06.17 Overtime 23.64 .00 PR 76 10/20/2017 MUD PR 10.20.17 Overtime 4.83 4.83 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 4.83 * _______________ Account: 135-50010-030-000 Overtime Totals: 4.83 ** Account: 135-50020-030-000 Retirement 13 10/06/2017 MUD PR 10.06.17 Retirement 2,306.94 2,306.94 PR 76 10/20/2017 MUD PR 10.20.17 Retirement 1,405.23 3,712.17 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 3,712.17 * _______________ Account: 135-50020-030-000 Retirement Totals: 3,712.17 ** Account: 135-50026-030-000 Medical Insurance 13 10/06/2017 MUD PR 10.06.17 Medical Insurance 1,674.80 1,674.80 PR 76 10/20/2017 MUD PR 10.20.17 Medical Insurance 1,674.81 3,349.61 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 3,349.61 * Account: 135-50026-030-000 Medical Insurance . glpytb2 rgonzale Trophy Club MUD No.1 Page 29 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,349.61 ** Account: 135-50027-030-000 Dental Insurance 13 10/06/2017 MUD PR 10.06.17 Dental Insurance 155.71 155.71 PR 76 10/20/2017 MUD PR 10.20.17 Dental Insurance 155.66 311.37 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 311.37 * _______________ Account: 135-50027-030-000 Dental Insurance Totals: 311.37 ** Account: 135-50028-030-000 Vision Insurance 13 10/06/2017 MUD PR 10.06.17 Vision Insurance 33.41 33.41 PR 76 10/20/2017 MUD PR 10.20.17 Vision Insurance 33.36 66.77 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 66.77 * _______________ Account: 135-50028-030-000 Vision Insurance Totals: 66.77 ** Account: 135-50029-030-000 Life Insurance & Other 11 10/03/2017 Oct A/P Dental, Vision, Life & other 264.38 264.38 METLIFE GROUP BENEFITS 3600 AP 105 10/20/2017 October A/P Café 125 Admin 21.34 285.72 BenefitMall 3621 AP 153 10/31/2017 Oct A/P Rounding adjustment (.02) 285.70 Legal Shield 3659 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 285.70 * _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 285.70 ** Account: 135-50030-030-000 Social Security Taxes 129 10/06/2017 Reverse Accrued Payroll (1,508.56) (1,508.56) GL 13 10/06/2017 MUD PR 10.06.17 Social Security Taxes 1,508.56 .00 PR Account: 135-50030-030-000 Social Security Taxes . glpytb2 rgonzale Trophy Club MUD No.1 Page 30 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 76 10/20/2017 MUD PR 10.20.17 Social Security Taxes 892.33 892.33 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 892.33 * _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 892.33 ** Account: 135-50035-030-000 Medicare Taxes 129 10/06/2017 Reverse Accrued Payroll (352.82) (352.82) GL 13 10/06/2017 MUD PR 10.06.17 Medicare Taxes 352.82 .00 PR 76 10/20/2017 MUD PR 10.20.17 Medicare Taxes 208.69 208.69 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 208.69 * _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 208.69 ** Account: 135-50040-030-000 Unemployment Taxes 13 10/06/2017 MUD PR 10.06.17 Unemployment Taxes .56 .56 PR 76 10/20/2017 MUD PR 10.20.17 Unemployment Taxes 1.12 1.68 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1.68 * _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 1.68 ** Account: 135-50045-030-000 Workman's Compensation 232 10/01/2017 Insurance/Wrk Comp Exp Oct 123.50 123.50 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 123.50 * _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 ** Account: 135-50060-030-000 Pre-emp Physicals/Testing . glpytb2 rgonzale Trophy Club MUD No.1 Page 31 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 133 10/26/2017 October A/P Pre-employment testing 38.00 38.00 CARENOW CORPORATE 3622 AP 217 10/31/2017 Oct A/P Pre-employment Testing 86.95 124.95 FIRST CHECK APPLICANT SCREENIN 3673 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 124.95 * _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 124.95 ** Account: 135-50070-030-000 Employee Relations 211 10/26/2017 Pcard 09/27/17 - 10/26/17 PANERA BREAD 601996 35.42 35.42 PANERA BREAD 601996 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TOM THUMB #1789 9.98 45.40 TOM THUMB #1789 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TOM THUMB #1789 8.99 54.39 TOM THUMB #1789 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TOM THUMB #1789 37.99 92.38 TOM THUMB #1789 PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 92.38 * _______________ Account: 135-50070-030-000 Employee Relations Totals: 92.38 ** Account: 135-55030-030-000 Software & Support 11 10/03/2017 Oct A/P Code Red renewal 10/27/17-10/2 3,670.00 3,670.00 Onsolve Intermediate Holding 3602 AP 49 10/11/2017 October A/P Internet Admin 1,036.77 4,706.77 WHOLESALE CARRIER SERVICES INC 3609 AP 79 10/17/2017 October A/P Outlook Email licenses 168.00 4,874.77 M3 Networks 3634 AP 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ADOBE *IL CREATIVE CLD 19.99 4,894.76 ADOBE *IL CREATIVE CLD PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 CANVA 01738-2153058 10.00 4,904.76 CANVA 01738-2153058 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 CANVA FOR WORK MONTHLY 12.95 4,917.71 CANVA FOR WORK MONTHLY PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ATT*BILL PAYMENT 111.88 5,029.59 ATT*BILL PAYMENT PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ATT*BILL PAYMENT 128.39 5,157.98 ATT*BILL PAYMENT PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 5,157.98 * _______________ Account: 135-55030-030-000 Software & Support Totals: 5,157.98 ** Account: 135-55070-030-000 Independent Labor . glpytb2 rgonzale Trophy Club MUD No.1 Page 32 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 25 10/05/2017 October A/P Backflow Renewal 595.00 595.00 SC TRACKING SOLUTIONS LLC 3605 AP 79 10/17/2017 October A/P Temp Receptionist 634.67 1,229.67 Onin Staffing, LLC 3639 AP 133 10/26/2017 October A/P Temp Receptionist 485.08 1,714.75 Onin Staffing, LLC 3639 AP 187 10/31/2017 October A/P Temp Receptionist 687.70 2,402.45 Onin Staffing, LLC 3663 AP 217 10/31/2017 Oct A/P October Contract GM 13,425.00 15,827.45 Carman Consulting LLC. 3672 AP 217 10/31/2017 Oct A/P Temp Receptionist 687.44 16,514.89 Onin Staffing, LLC 3676 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 16,514.89 * _______________ Account: 135-55070-030-000 Independent Labor Totals: 16,514.89 ** Account: 135-55080-030-000 Maintenance & Repairs 49 10/11/2017 October A/P Rug Service 66.47 66.47 G & K SERVICES 3595 AP 256 10/31/2017 Town Billed Invoice #1599-1603 AR 20171031-20171031 User: (33.23) 33.24 AR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 33.24 * _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 33.24 ** Account: 135-55120-030-000 Cleaning Services 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TROPHY CLUB CLEANERS 9.73 9.73 TROPHY CLUB CLEANERS PC 256 10/31/2017 Town Billed Invoice #1599-1603 AR 20171031-20171031 User: (196.32) (186.59) AR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (186.59) * _______________ Account: 135-55120-030-000 Cleaning Services Totals: (186.59) ** Account: 135-55160-030-000 Professional Outside Services 11 10/03/2017 Oct A/P FY 2018 Renewal 56,475.00 56,475.00 M3 Networks 3546 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 56,475.00 * . glpytb2 rgonzale Trophy Club MUD No.1 Page 33 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 56,475.00 ** Account: 135-55205-030-000 Utility Billing Contract 247 10/31/2017 Oct A/P October Utility Billing 573.93 573.93 DATAPROSE LLC AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 573.93 * _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 573.93 ** Account: 135-60005-030-000 Telephone 25 10/05/2017 October A/P Answering Service 194.75 194.75 KEYSTONE PARK SECRETARIAL 3599 AP 211 10/26/2017 Pcard 09/27/17 - 10/26/17 RINGCENTRAL, INC 13.96 208.71 RINGCENTRAL, INC PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 ATT* BILL PAYMENT 452.30 661.01 ATT* BILL PAYMENT PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 661.01 * _______________ Account: 135-60005-030-000 Telephone Totals: 661.01 ** Account: 135-60010-030-000 Communications/Mobiles 76 10/20/2017 MUD PR 10.20.17 Communications/Mobiles 225.00 225.00 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 225.00 * _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 225.00 ** Account: 135-60025-030-000 Water 187 10/31/2017 October A/P Oct Water 116.19 116.19 TROPHY CLUB MUD (WATER BILLS) 3668 AP 256 10/31/2017 Town Billed Invoice #1599-1603 AR 20171031-20171031 User: (58.09) 58.10 AR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 58.10 * Account: 135-60025-030-000 Water . glpytb2 rgonzale Trophy Club MUD No.1 Page 34 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id _______________ Account: 135-60025-030-000 Water Totals: 58.10 ** Account: 135-60035-030-000 Postage 103 10/20/2017 October A/P Overnight letter 5.50 5.50 FEDERAL EXPRESS CORP 3626 AP 105 10/20/2017 October A/P Postage meter lease 93.00 98.50 FRANCOTYP-POSTALIA, INC. 3627 AP 211 10/26/2017 Pcard 09/27/17 - 10/26/17 FEDEX 25896134 41.14 139.64 FEDEX 25896134 PC 247 10/31/2017 Oct A/P October Utility Billing 1,563.27 1,702.91 DATAPROSE LLC AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,702.91 * _______________ Account: 135-60035-030-000 Postage Totals: 1,702.91 ** Account: 135-60040-030-000 Service Charges & Fees 161 10/03/2017 Credit Card fees 5,339.34 5,339.34 GL 161 10/03/2017 Credit Card fees 147.51 5,486.85 GL 25 10/05/2017 October A/P Safety Deposit Box 40.00 5,526.85 Bank of the West 3592 AP 14 10/06/2017 Child Support Fee 1.50 5,528.35 GL 231 10/11/2017 Safety Dep Box/Bank of West 40.00 5,568.35 GL 77 10/20/2017 Child Support Fee 1.50 5,569.85 GL 159 10/31/2017 Void CK 3592/Deposit box ACH Safety Deposit Box (40.00) 5,529.85 Bank of the West 3592 AP 160 10/31/2017 Bank of West Deposit Box ACH Bank drafted from our acct 40.00 5,569.85 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 5,569.85 * _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,569.85 ** Account: 135-60055-030-000 Insurance 232 10/01/2017 Insurance/Wrk Comp Exp Oct 6,100.36 6,100.36 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 6,100.36 * _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 ** . glpytb2 rgonzale Trophy Club MUD No.1 Page 35 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-60080-030-000 Schools & Training 211 10/26/2017 Pcard 09/27/17 - 10/26/17 NCTCOG RTC TRAINING 275.00 275.00 NCTCOG RTC TRAINING PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 AWWA.ORG 249.00 524.00 AWWA.ORG PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 GOVERNMENT FINANCE 135.00 659.00 GOVERNMENT FINANCE PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 659.00 * _______________ Account: 135-60080-030-000 Schools & Training Totals: 659.00 ** Account: 135-60100-030-000 Travel & per diem 13 10/06/2017 MUD PR 10.06.17 Travel & per diem 27.92 27.92 PR OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 27.92 * _______________ Account: 135-60100-030-000 Travel & per diem Totals: 27.92 ** Account: 135-60115-030-000 Elections 211 10/26/2017 Pcard 09/27/17 - 10/26/17 LANGUAGE USA 45.00 45.00 LANGUAGE USA PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 45.00 * _______________ Account: 135-60115-030-000 Elections Totals: 45.00 ** Account: 135-60125-030-000 Advertising 272 10/26/2017 Recode ZipRecrutier Pcard- Adv 202.53 202.53 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 202.53 * _______________ Account: 135-60125-030-000 Advertising Totals: 202.53 ** Account: 135-65055-030-000 Hardware . glpytb2 rgonzale Trophy Club MUD No.1 Page 36 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 103 10/20/2017 October A/P TV, Stand, Webcam 597.95 597.95 M3 Networks 3634 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 597.95 * _______________ Account: 135-65055-030-000 Hardware Totals: 597.95 ** Account: 135-65085-030-000 Office Supplies 79 10/17/2017 October A/P Office Supplies 131.23 131.23 OFFICE DEPOT, INC 3638 AP 211 10/26/2017 Pcard 09/27/17 - 10/26/17 STAPLES 00116533 175.34 306.57 STAPLES 00116533 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 STAPLES 00116533 34.07 340.64 STAPLES 00116533 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 AMAZON MKTPLACE PMTS 61.46 402.10 AMAZON MKTPLACE PMTS PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 WM SUPERCENTER #5247 31.59 433.69 WM SUPERCENTER #5247 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 STAPLES 00116533 68.72 502.41 STAPLES 00116533 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 STAPLES DIRECT 178.96 681.37 STAPLES DIRECT PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 STAPLES 00116533 148.10 829.47 STAPLES 00116533 PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 829.47 * _______________ Account: 135-65085-030-000 Office Supplies Totals: 829.47 ** Account: 135-65090-030-000 Printer Supplies & Maintenance 211 10/26/2017 Pcard 09/27/17 - 10/26/17 SHI GOVERNMENT SOLUTIO 294.71 294.71 SHI GOVERNMENT SOLUTIO PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 AMAZON MKTPLACE PMTS 11.43 306.14 AMAZON MKTPLACE PMTS PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 SHI GOVERNMENT SOLUTIO 345.36 651.50 SHI GOVERNMENT SOLUTIO PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 SHI GOVERNMENT SOLUTIO 387.44 1,038.94 SHI GOVERNMENT SOLUTIO PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 AMAZON MKTPLACE PMTS 134.43 1,173.37 AMAZON MKTPLACE PMTS PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 1,173.37 * _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 1,173.37 ** Account: 135-65095-030-000 Maintenance Supplies . glpytb2 rgonzale Trophy Club MUD No.1 Page 37 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 211 10/26/2017 Pcard 09/27/17 - 10/26/17 AMAZON MKTPLACE PMTS 94.79 94.79 AMAZON MKTPLACE PMTS PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 AMAZON MKTPLACE PMTS 49.98 144.77 AMAZON MKTPLACE PMTS PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 SAMS CLUB #4795 170.17 314.94 SAMS CLUB #4795 PC 211 10/26/2017 Pcard 09/27/17 - 10/26/17 TOM THUMB #1789 19.98 334.92 TOM THUMB #1789 PC OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 334.92 * _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 334.92 ** Account: 135-69170-030-000 Copier Lease Installments 133 10/26/2017 October A/P Copies 78.42 78.42 KYOCERA DOCUMENT SOLUTIONS 3632 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 78.42 * _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 78.42 ** Department 30 Totals: 121,194.97 *** . glpytb2 rgonzale Trophy Club MUD No.1 Page 38 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 135-55045-039-000 Legal 247 10/31/2017 Oct A/P Oct Legal 7,150.00 7,150.00 McLean & Howard, L.L.P. AP 247 10/31/2017 Oct A/P Oct Legal 1,050.00 8,200.00 McLean & Howard, L.L.P. AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 8,200.00 * _______________ Account: 135-55045-039-000 Legal Totals: 8,200.00 ** Account: 135-55055-039-000 Auditing 2 10/01/2017 Reverse PPD Audit Retainer 5,000.00 5,000.00 GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - 5,000.00 * _______________ Account: 135-55055-039-000 Auditing Totals: 5,000.00 ** Department 39 Totals: 13,200.00 *** Fund 135 Totals: (189,838.44) **** . glpytb2 rgonzale Trophy Club MUD No.1 Page 39 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 137-49145-000-000 Intergov Transfer-General Fund 41 10/01/2017 GASB 34 transfers FY 2018 Town Elevated Tank (45,000.00) (45,000.00) GL 41 10/01/2017 GASB 34 transfers FY 2018 Water Replacement (30,000.00) (75,000.00) GL 41 10/01/2017 GASB 34 transfers FY 2018 Sewer Replacement (30,000.00) (105,000.00) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (105,000.00) * _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: (105,000.00) ** Account: 137-49146-000-000 Intergov Transfer-Fire Dept 41 10/01/2017 GASB 34 transfers FY 2018 Fire Truck Future Replacement (81,420.00) (81,420.00) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (81,420.00) * _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: (81,420.00) ** Department Totals: (186,420.00) *** Fund 137 Totals: (186,420.00) **** TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET OCTOBER 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 1,674,029 ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,674,029 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 679,817 TOTAL LIABILITIES 679,817 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES 1,633 TOTAL FUND BALANCE 994,212 TOTAL LIABILITIES AND FUND BALANCE 1,674,029 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 14:13 11/15/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,632.31- 1,632.31- 1,632.31 Subtotal: 1,632.31- 1,632.31- 1,632.31 Program number: 1,632.31- 1,632.31- 1,632.31 Department number: Revenues 1,632.31- 1,632.31- 1,632.31 Revenues Subtotal ----------- 1,632.31- 1,632.31- 1,632.31 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,632.31- 1,632.31- 1,632.31 . glpytb2 rgonzale Trophy Club MUD No.1 Page 40 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 517-49010-000-000 Interest Income 230 10/31/2017 October Bank Interest (1,632.31) (1,632.31) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (1,632.31) * _______________ Account: 517-49010-000-000 Interest Income Totals: (1,632.31) ** Department Totals: (1,632.31) *** . glpytb2 rgonzale Trophy Club MUD No.1 Page 41 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 517-69005-020-000 Capital Outlays 108 10/23/2017 Void Ck 3587/Lost in mail (995,871.80) (995,871.80) WEBBER-CADAGUA PARTNERS 3587 AP 109 10/23/2017 October A/P WWTP App 23-Replacement check 995,871.80 .00 WEBBER-CADAGUA PARTNERS 3611 AP OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - .00 * _______________ Account: 517-69005-020-000 Capital Outlays Totals: .00 ** Department 20 Totals: .00 *** Fund 517 Totals: (1,632.31) **** TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET OCTOBER 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 OCTOBER 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 OCTOBER 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 441,314 ACCOUNTS RECEIVABLE - TOTAL ASSETS 441,314 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 14,735 TOTAL FUND BALANCE 441,314 TOTAL LIABILITIES AND FUND BALANCE 441,314 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 14:13 11/15/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/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- 374.20- 374.20- 37.420 625.80- 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 4,083.00- 8.333 44,913.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 10,278.00- 8.333 113,058.00- Subtotal: 173,332.00- 173,332.00- 14,735.20- 14,735.20- 8.501 158,596.80- Program number: 173,332.00- 173,332.00- 14,735.20- 14,735.20- 8.501 158,596.80- Department number: 173,332.00- 173,332.00- 14,735.20- 14,735.20- 8.501 158,596.80- Revenues Subtotal ----------- 173,332.00- 173,332.00- 14,735.20- 14,735.20- 8.501 158,596.80- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 14,735.20- 14,735.20- 8.501 158,596.80- . glpytb2 rgonzale Trophy Club MUD No.1 Page 42 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 528-49010-000-000 Interest Income 230 10/31/2017 October Bank Interest (374.20) (374.20) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (374.20) * _______________ Account: 528-49010-000-000 Interest Income Totals: (374.20) ** Account: 528-49142-000-000 Interfund transfer in-Water 155 10/31/2017 Texpool Transfers Transfer to Rev Bond Reserve (4,083.00) (4,083.00) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (4,083.00) * _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) ** Account: 528-49143-000-000 Interfund transfer in-WW 155 10/31/2017 Texpool Transfers Transfer to Rev Bond Reserve (10,278.00) (10,278.00) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (10,278.00) * _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) ** Department Totals: (14,735.20) *** Fund 528 Totals: (14,735.20) **** TROPHY CLUB MUD #1 - I&S BALANCE SHEET OCTOBER 2017 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 43,463 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 681,501 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 729,537 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 681,501 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 681,501 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 15,695 TOTAL FUND BALANCE 48,036 TOTAL LIABILITIES AND FUND BALANCE 729,537 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 14:13 11/15/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/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- 3,557.68- 3,557.68- .531 666,102.32- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 885.18- 885.18- 49.177 914.82- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 132.02- 132.02- 6.601 1,867.98- Subtotal: 673,460.00- 673,460.00- 4,574.88- 4,574.88- .679 668,885.12- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 25.49- 25.49- 1.275 1,974.51- 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- 11,094.81- 9.091 110,948.19- Subtotal: 342,997.00- 342,997.00- 11,120.30- 11,120.30- 3.242 331,876.70- Program number: 1,016,457.00- 1,016,457.00- 15,695.18- 15,695.18- 1.544 1,000,761.82- Department number: Revenues 1,016,457.00- 1,016,457.00- 15,695.18- 15,695.18- 1.544 1,000,761.82- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 15,695.18- 15,695.18- 1.544 1,000,761.82- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 14:13 11/15/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/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- 15,695.18- 15,695.18- 270.653 9,896.18 . glpytb2 rgonzale Trophy Club MUD No.1 Page 43 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 533-40000-000-000 Property Taxes 81 10/02/2017 Property Taxes (26.35) (26.35) GL 82 10/04/2017 Property Taxes (153.32) (179.67) GL 84 10/06/2017 Property Taxes (117.49) (297.16) GL 85 10/10/2017 Property Taxes (267.96) (565.12) GL 162 10/16/2017 Property Taxes (448.26) (1,013.38) GL 163 10/17/2017 Property Taxes (34.24) (1,047.62) GL 164 10/19/2017 Property Taxes (160.67) (1,208.29) GL 166 10/23/2017 Property Taxes (389.62) (1,597.91) GL 168 10/26/2017 Property Taxes (442.75) (2,040.66) GL 169 10/27/2017 Property Taxes (464.29) (2,504.95) GL 170 10/30/2017 Property Taxes (421.74) (2,926.69) GL 172 10/31/2017 Property Taxes (630.99) (3,557.68) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (3,557.68) * _______________ Account: 533-40000-000-000 Property Taxes Totals: (3,557.68) ** Account: 533-40002-000-000 Property Taxes/Delinquent 81 10/02/2017 Property Taxes (9.06) (9.06) GL 83 10/05/2017 Property Taxes (9.43) (18.49) GL 84 10/06/2017 Property Taxes (8.53) (27.02) GL 86 10/12/2017 Property Taxes (11.60) (38.62) GL 162 10/16/2017 Property Taxes (149.02) (187.64) GL 165 10/20/2017 Property Taxes (241.92) (429.56) GL 166 10/23/2017 Property Taxes (453.27) (882.83) GL 170 10/30/2017 Property Taxes (2.35) (885.18) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (885.18) * _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (885.18) ** Account: 533-40015-000-000 Property Taxes/P & I 81 10/02/2017 Property Taxes (.02) (.02) GL Account: 533-40015-000-000 Property Taxes/P & I . glpytb2 rgonzale Trophy Club MUD No.1 Page 44 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id 83 10/05/2017 Property Taxes (1.98) (2.00) GL 84 10/06/2017 Property Taxes (3.25) (5.25) GL 86 10/12/2017 Property Taxes (1.97) (7.22) GL 162 10/16/2017 Property Taxes (29.62) (36.84) GL 166 10/23/2017 Property Taxes (95.18) (132.02) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (132.02) * _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (132.02) ** Account: 533-49010-000-000 Interest Income 230 10/31/2017 October Bank Interest (25.49) (25.49) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (25.49) * _______________ Account: 533-49010-000-000 Interest Income Totals: (25.49) ** Account: 533-49141-000-000 Interfund Trans In-PID Surchg 155 10/31/2017 Texpool Transfers PID Share New Tax Debt (11,094.81) (11,094.81) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (11,094.81) * _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) ** Department Totals: (15,695.18) *** Fund 533 Totals: (15,695.18) **** TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET OCTOBER 2017 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 70,657 ACCOUNTS RECEIVABLE - TOTAL ASSETS 70,657 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 54,447 TOTAL FUND BALANCE 70,657 TOTAL LIABILITIES AND FUND BALANCE 70,657 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 14:13 11/15/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/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- 15.81- 15.81- 1.581 984.19- 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 54,430.72- 9.091 544,307.28- Subtotal: 599,738.00- 599,738.00- 54,446.53- 54,446.53- 9.078 545,291.47- Program number: 599,738.00- 599,738.00- 54,446.53- 54,446.53- 9.078 545,291.47- Department number: Revenues 599,738.00- 599,738.00- 54,446.53- 54,446.53- 9.078 545,291.47- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,446.53- 54,446.53- 9.078 545,291.47- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 14:13 11/15/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/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,446.53- 54,446.53- 5,444.653 53,446.53 . glpytb2 rgonzale Trophy Club MUD No.1 Page 45 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 534-49010-000-000 Interest Income 230 10/31/2017 October Bank Interest (15.81) (15.81) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (15.81) * _______________ Account: 534-49010-000-000 Interest Income Totals: (15.81) ** Account: 534-49143-000-000 Interfund Transfer In-WW Sales 155 10/31/2017 Texpool Transfers Rev Bond WWTP I&S (54,430.72) (54,430.72) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (54,430.72) * _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) ** Department Totals: (54,446.53) *** Fund 534 Totals: (54,446.53) **** TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET OCTOBER 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 26,234 ACCOUNTS RECEIVABLE - TOTAL ASSETS 26,234 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 25,282 TOTAL FUND BALANCE 26,234 TOTAL LIABILITIES AND FUND BALANCE 26,234 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 14:13 11/15/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 10/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- 1.65- 1.65- .275 598.35- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 25,280.31- 9.091 252,803.69- Subtotal: 278,684.00- 278,684.00- 25,281.96- 25,281.96- 9.072 253,402.04- Program number: 278,684.00- 278,684.00- 25,281.96- 25,281.96- 9.072 253,402.04- Department number: Revenues 278,684.00- 278,684.00- 25,281.96- 25,281.96- 9.072 253,402.04- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,281.96- 25,281.96- 9.072 253,402.04- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 14:13 11/15/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/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,281.96- 25,281.96- 4,213.660 24,681.96 ******* End of Report ********* . glpytb2 rgonzale Trophy Club MUD No.1 Page 46 14:13 11/15/17 YTD Detailed Account Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 10/2017 JE JE JE JE Detail Beginning Transaction Running Vendor_Name Check Source Number Date Description Description Balance Detail Total Number (SUBTOTAL) Asset id Account: 535-49010-000-000 Interest Income 230 10/31/2017 October Bank Interest (1.65) (1.65) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (1.65) * _______________ Account: 535-49010-000-000 Interest Income Totals: (1.65) ** Account: 535-49142-000-000 Interfund Tran In-Water Sales 155 10/31/2017 Texpool Transfers 2016 SWIFT Rev Bond I&S (25,280.31) (25,280.31) GL OCTOBER Totals: - - - - - - - - - - - - - - - - - _ - - - - - - - - - - - - - - - - - _- - - - - - - - (25,280.31) * _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) ** Department Totals: (25,281.96) *** Fund 535 Totals: (25,281.96) **** Grand Totals: (233,132.31) ***** ******* End of Report *********