Loading...
HomeMy WebLinkAbout2017-11 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2017 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 245,138 PREPAID EXPENSES 12,699 ADVALOREM PROPERTY TAXES RECEIVABLE 1,039,975 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,297,812 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,039,975 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 1,039,975 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (264,416) TOTAL FUND BALANCE 257,837 TOTAL LIABILITIES AND FUND BALANCE 1,297,812 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 17:30 12/13/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/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- 41,473.79- 47,075.71- 4.465 1,007,357.29- 122-40011-000-000 Property Taxes/Fire-Delinquent 939.25- 2,254.22- 2,254.22 122-40020-000-000 Property Taxes/Fire P&I 100.81- 338.07- 338.07 Subtotal: 1,054,433.00- 1,054,433.00- 42,513.85- 49,668.00- 4.710 1,004,765.00- Program number: 1,054,433.00- 1,054,433.00- 42,513.85- 49,668.00- 4.710 1,004,765.00- Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 42,513.85- 49,668.00- 4.710 1,004,765.00- Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 42,513.85- 49,668.00- 4.710 1,004,765.00- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 17:30 12/13/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 1,490.49 1,490.49- Subtotal: 1,490.49 1,490.49- 122-60030-045-000 Rent And/Or Usage 218,954.00 218,954.00 218,954.00 122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.87 2,539.74 14.110 15,460.26 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 101,485.00 16.667 507,425.00 Subtotal: 845,864.00 845,864.00 52,012.37 104,024.74 12.298 741,839.26 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 52,012.37 314,083.83 29.787 740,349.17 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 314,083.83 29.787 740,349.17 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 314,083.83 29.787 740,349.17 Fund number: 122 Trophy Club MUD Fire Dept. 9,498.52 264,415.83 264,415.83- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 345 11/01/2017 Property Taxes (5,601.92) (269.99) (5,871.91) GL 346 11/02/2017 Property Taxes (603.60) (6,475.51) GL 347 11/03/2017 Property Taxes (5,480.76) (11,956.27) GL 348 11/06/2017 Property Taxes (308.87) (12,265.14) GL 349 11/07/2017 Property Taxes (4,370.53) (16,635.67) GL 350 11/08/2017 Property Taxes (1,263.46) (17,899.13) GL 351 11/09/2017 Property Taxes (2,559.06) (20,458.19) GL 352 11/13/2017 Property Taxes (1,941.34) (22,399.53) GL 353 11/14/2017 Property Taxes (3,701.22) (26,100.75) GL 354 11/15/2017 Property Taxes (1,785.62) (27,886.37) GL 355 11/16/2017 Property Taxes (1,741.19) (29,627.56) GL 356 11/17/2017 Property Taxes (1,812.26) (31,439.82) GL 357 11/20/2017 Property Taxes (1,225.74) (32,665.56) GL 358 11/21/2017 Property Taxes (3,182.65) (35,848.21) GL 359 11/22/2017 Property Taxes (1,532.38) (37,380.59) GL 360 11/27/2017 Property Taxes (3,512.32) (40,892.91) GL 361 11/28/2017 Property Taxes (2,252.76) (43,145.67) GL 362 11/29/2017 Property Taxes (2,397.56) (45,543.23) GL 373 11/30/2017 Property Taxes (1,532.48) (47,075.71) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (41,473.79) (47,075.71) ** (1,054,433.00) Budgeted (1,007,357.29) Remaining 4 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 345 11/01/2017 Property Taxes (1,314.97) (6.45) (1,321.42) GL 347 11/03/2017 Property Taxes (11.67) (1,333.09) GL 348 11/06/2017 Property Taxes (1.71) (1,334.80) GL 357 11/20/2017 Property Taxes (24.74) (1,359.54) GL 358 11/21/2017 Property Taxes (730.70) (2,090.24) GL 360 11/27/2017 Property Taxes (159.53) (2,249.77) GL 361 11/28/2017 Property Taxes (4.45) (2,254.22) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (939.25) (2,254.22) ** .00 Budgeted 2,254.22 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 345 11/01/2017 Property Taxes (237.26) (2.70) (239.96) GL 347 11/03/2017 Property Taxes (1.51) (241.47) GL 348 11/06/2017 Property Taxes (.83) (242.30) GL 351 11/09/2017 Property Taxes (.98) (243.28) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 354 11/15/2017 Property Taxes (237.26) (.62) (243.90) GL 356 11/17/2017 Property Taxes (.95) (244.85) GL 357 11/20/2017 Property Taxes (31.67) (276.52) GL 358 11/21/2017 Property Taxes (17.07) (293.59) GL 359 11/22/2017 Property Taxes (.56) (294.15) GL 360 11/27/2017 Property Taxes (43.92) (338.07) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (100.81) (338.07) ** .00 Budgeted 338.07 Remaining 0 % Used Department Totals: ----------------------------------- (49,668.00) ** (42,513.85) Monthly Total (1,054,433.00) Budgeted (1,004,765.00) Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 1,490.49 .00 1,490.49 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 1,490.49 ** .00 Budgeted (1,490.49) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 218,954.00 Budgeted 218,954.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 233 11/01/2017 Insurance/Wrk Comp Exp Nov 1,269.87 1,269.87 2,539.74 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 2,539.74 ** 18,000.00 Budgeted 15,460.26 Remaining 14 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 188 11/02/2017 Nov A/P Nov Fire Admin 50,742.50 50,742.50 101,485.00 TOWN OF TROPHY CLUB 3667 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 101,485.00 ** 608,910.00 Budgeted 507,425.00 Remaining 17 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 314,083.83 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 740,349.17 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ----------------------------------- 264,415.83 9,498.52 Monthly Total .00 Budgeted (264,415.83) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET NOVEMBER 2017 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,395,023 - 1,395,023 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,190 - 714,190 INVESTMENTS-TEXPOOL 1,345,330 596,426 1,941,756 PREPAID EXPENSES 88,228 - 88,228 ADVALOREM PROPERTY TAXES RECEIVABLE 119,211 - 119,211 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,198,974 - 1,198,974 TOTAL ASSETS 5,477,925 596,426 6,074,351 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 119,211 - 119,211 ACCOUNTS AND OTHER PAYABLES 605,465 - 605,465 CUSTOMER DEPOSITS 313,805 - 313,805 - TOTAL LIABILITIES 1,038,481 - 1,038,481 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,778,760 1,778,760 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 180,000 180,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 120,000 120,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 67,805 67,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 228,621 228,621 UNASSIGNED FUND BALANCE 2,368,122 - 2,368,122 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 289,076 - 289,076 - TOTAL FUND BALANCE 4,439,444 596,426 5,035,870 TOTAL LIABILITIES AND FUND BALANCE 5,477,925 596,426 6,074,351 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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- 4,757.11- 5,399.65- 4.464 115,550.35- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 56.14- 136.15- 68.075 63.85- 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 7.68- 21.99- 10.995 178.01- 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 4,820.93- 5,557.79- 1.858 293,631.21- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 469,357.99- 932,153.38- 14.421 5,531,865.62- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 245,140.14- 471,041.79- 15.817 2,507,025.21- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 11,070.93- 23,100.24- 21.735 83,178.76- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,425.00- 2,150.00- 10.070 19,200.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 350.00- 450.00- 30.000 1,050.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 1,050.00- 1,350.00- 30.000 3,150.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 547.20- 547.20- .912 59,452.80- Subtotal: 9,635,715.00- 9,635,715.00- 728,941.26- 1,430,792.61- 14.849 8,204,922.39- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 2,304.48- 5,154.91- 42.958 6,845.09- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 1,889.34- 17.292 9,036.66- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,166.66- 16.667 5,833.34- 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- 2,401.00- 3,087.00- 16.981 15,092.00- 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 1,604.74- 3,675.72- 73.514 1,324.28- 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,872.36- 14,973.63- 4.752 300,151.37- Program number: 10,250,029.00- 10,250,029.00- 741,634.55- 1,451,324.03- 14.159 8,798,704.97- Department number: Revenues 10,250,029.00- 10,250,029.00- 741,634.55- 1,451,324.03- 14.159 8,798,704.97- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 741,634.55- 1,451,324.03- 14.159 8,798,704.97- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 16,025.31 25,367.85 9.249 248,911.15 135-50010-010-000 Overtime 20,000.00 20,000.00 504.44 610.94 3.055 19,389.06 135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 3,310.00 96.642 115.00 135-50017-010-000 Certification 3,300.00 3,300.00 150.00 400.00 12.121 2,900.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,849.05 4,156.17 14.927 23,686.83 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,125.98 4,960.63 9.504 47,235.37 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 224.70 505.69 9.759 4,676.31 135-50028-010-000 Vision Insurance 994.00 994.00 44.70 102.97 10.359 891.03 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 214.65 492.77 16.525 2,489.23 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,230.02 1,822.13 9.764 16,839.87 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 287.66 426.15 9.763 3,938.85 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 3.14 7.43 .688 1,072.57 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 1,799.84 15.183 10,054.16 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 6.330 281.01 Subtotal: 426,662.00 426,662.00 26,869.57 43,981.56 10.308 382,680.44 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 3,676.67 4,083.37 4.083 95,916.63 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 22.00 1,171.42 29.286 2,828.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 20.559 4,369.26 Subtotal: 391,000.00 391,000.00 3,698.67 6,385.53 1.633 384,614.47 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 319.55 319.55 6.799 4,380.45 135-60020-010-000 Electricity 175,356.00 175,356.00 12,399.24 27,304.32 15.571 148,051.68 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 2,785.00 2,785.00 2,785.00 135-60090-010-000 Safety Program 400.00 400.00 8.36 2.090 391.64 135-60100-010-000 Travel & per diem 1,735.00 1,735.00 87.48 87.48 5.042 1,647.52 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 55,176.00 55,176.00 7,685.65 7,685.65 13.929 47,490.35 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 208,059.10 208,059.10 7.370 2,615,110.90 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 214.70 7.157 2,785.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,500.00 2,250.00 15.254 12,500.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 50,560.62 18.182 227,523.38 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 8,166.00 16.667 40,830.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 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 259,414.33 304,655.78 8.430 3,309,196.22 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 650.59 1,419.71 9.465 13,580.29 135-65010-010-000 Uniforms 4,488.00 4,488.00 497.22 497.22 11.079 3,990.78 135-65030-010-000 Chemicals 20,000.00 20,000.00 884.96 2,607.66 13.038 17,392.34 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,032.77 4,524.59 2.575 171,163.41 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 54,409.25 54,409.25 6.717 755,602.75 135-69008-010-000 Short Term Debt-Principal 38,731.00 38,731.00 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 5,713.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 65,920.00 55.500 52,855.00 Subtotal: 1,048,231.00 1,048,231.00 54,409.25 195,329.25 18.634 852,901.75 Program number: 5,655,433.00 5,655,433.00 346,424.59 554,876.71 9.811 5,100,556.29 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/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 14.810 1,703.81 Subtotal: 2,000.00 2,000.00 296.19 14.810 1,703.81 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 296.19 14.810 1,703.81 Department number: Water 5,657,433.00 5,657,433.00 346,424.59 555,172.90 9.813 5,102,260.10 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 30,611.17 46,080.58 11.215 364,785.42 135-50010-020-000 Overtime 30,000.00 30,000.00 2,520.69 3,997.04 13.323 26,002.96 135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 7,415.00 100.000 135-50017-020-000 Certification 8,400.00 8,400.00 625.00 1,325.00 15.774 7,075.00 135-50020-020-000 Retirement 42,243.00 42,243.00 3,808.39 6,905.08 16.346 35,337.92 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 4,710.20 9,420.40 15.151 52,754.60 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 399.32 798.64 15.152 4,472.36 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 84.33 168.66 15.140 945.34 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 393.14 788.28 18.413 3,492.72 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 2,420.78 3,440.24 12.150 24,873.76 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 566.16 804.57 12.150 5,817.43 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 2,696.00 14.986 15,294.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 54,902.18 83,839.49 13.380 542,761.51 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 6,083.12 6,356.22 7.382 79,743.78 135-55085-020-000 Generator Maint. and Repair 14,000.00 14,000.00 28.78 28.78 .206 13,971.22 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 19.99 2,648.72 33.109 5,351.28 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 2,603.87 7,899.48 13.166 52,100.52 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,390.00 7,827.82 26.093 22,172.18 Subtotal: 219,150.00 219,150.00 11,125.76 24,761.02 11.299 194,388.98 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 381.56 381.56 8.118 4,318.44 135-60020-020-000 Electricity 266,709.00 266,709.00 13,707.53 26,996.29 10.122 239,712.71 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 5,677.00 135-60090-020-000 Safety Program 550.00 550.00 8.37 1.522 541.63 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 23.17 23.17 1.417 1,611.83 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 5,000.00 5,000.00 5,000.00 135-60135-020-000 TCEQ Fees & Permits 85,000.00 85,000.00 24,845.75 34,733.77 40.863 50,266.23 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 4,000.00 4,000.00 4,000.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,180.00 1,770.00 15.259 9,830.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 22,189.62 18.182 99,853.38 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 108,861.44 18.182 489,876.56 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 20,556.00 16.667 102,780.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 115,941.54 215,520.22 14.978 1,223,417.78 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 789.72 1,533.61 12.269 10,966.39 135-65010-020-000 Uniforms 4,459.00 4,459.00 1,614.63 36.211 2,844.37 135-65030-020-000 Chemicals 27,500.00 27,500.00 5.35 5.35 .019 27,494.65 135-65035-020-000 Small Tools 1,000.00 1,000.00 176.23 247.76 24.776 752.24 135-65040-020-000 Safety Equipment 750.00 750.00 750.00 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 1,576.08 2,136.63 15.262 11,863.37 Subtotal: 60,209.00 60,209.00 2,547.38 5,537.98 9.198 54,671.02 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 8,307.50 9,870.99 1.803 537,456.01 135-69008-020-000 Short Term Debt-Principal 51,342.00 51,342.00 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 7,573.00 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 636,242.00 636,242.00 8,307.50 39,870.99 6.267 596,371.01 Program number: 2,981,140.00 2,981,140.00 192,824.36 369,529.70 12.396 2,611,610.30 Department number: Wastewater 2,981,140.00 2,981,140.00 192,824.36 369,529.70 12.396 2,611,610.30 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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 4.84 16.133 25.16 Subtotal: 30.00 30.00 2.42 4.84 16.133 25.16 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 600.00 600.00 650.00 650.00 108.333 50.00- 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 690.00 690.00 17.250 3,310.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 1,340.00 1,340.00 10.347 11,610.00 Program number: 12,980.00 12,980.00 1,342.42 1,344.84 10.361 11,635.16 Department number: Board of Directors 12,980.00 12,980.00 1,342.42 1,344.84 10.361 11,635.16 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 31,400.97 46,587.70 10.763 386,275.30 135-50010-030-000 Overtime 2,000.00 2,000.00 169.37 174.20 8.710 1,825.80 135-50016-030-000 Longevity 3,548.00 3,548.00 3,547.50 3,547.50 99.986 .50 135-50020-030-000 Retirement 40,553.00 40,553.00 3,248.40 6,960.57 17.164 33,592.43 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 3,585.83 6,935.44 10.925 56,549.56 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 330.13 641.50 11.659 4,860.50 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 71.29 138.06 11.770 1,034.94 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 374.95 660.65 13.059 4,398.35 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 2,090.06 2,982.39 10.972 24,198.61 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 488.79 697.48 10.972 5,659.52 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 3.36 5.04 .400 1,254.96 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 247.00 16.154 1,282.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 124.95 24.990 375.05 135-50070-030-000 Employee Relations 4,960.00 4,960.00 222.30 314.68 6.344 4,645.32 Subtotal: 595,970.00 595,970.00 45,656.45 70,017.16 11.748 525,952.84 135-55030-030-000 Software & Support 78,391.00 78,391.00 7,303.22 12,461.20 15.896 65,929.80 135-55070-030-000 Independent Labor 154,000.00 154,000.00 10,257.90 26,772.79 17.385 127,227.21 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 128.97 162.21 1.159 13,837.79 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 672.74 486.15 4.862 9,513.85 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 56,475.00 89.183 6,850.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 573.93 6.377 8,426.07 Subtotal: 338,916.00 338,916.00 18,362.83 96,931.28 28.600 241,984.72 135-60005-030-000 Telephone 27,300.00 27,300.00 858.21 1,519.22 5.565 25,780.78 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 262.99 487.99 12.200 3,512.01 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 644.52 644.52 3.964 15,616.48 135-60025-030-000 Water 2,500.00 2,500.00 58.10 116.20 4.648 2,383.80 135-60035-030-000 Postage 30,000.00 30,000.00 1,702.91 5.676 28,297.09 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 5,591.44 11,161.29 20.089 44,398.71 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 12,200.72 21.787 43,799.28 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 100.00 100.00 1.667 5,900.00 135-60075-030-000 Meetings 400.00 400.00 48.62 48.62 12.155 351.38 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 7,600.00 7,600.00 1,949.00 2,608.00 34.316 4,992.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 48.76 76.68 1.570 4,808.32 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 1.000 4,455.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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- 2,500.00 135-60235-030-000 Security 2,700.00 2,700.00 2,700.00 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 211.99 8.480 2,288.01 Subtotal: 249,506.00 249,506.00 15,671.46 30,923.14 12.394 218,582.86 135-65010-030-000 Uniforms 700.00 700.00 700.00 135-65055-030-000 Hardware 7,420.00 7,420.00 597.95 8.059 6,822.05 135-65085-030-000 Office Supplies 7,000.00 7,000.00 990.54 1,820.01 26.000 5,179.99 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 386.63 1,560.00 78.000 440.00 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 328.75 663.67 16.592 3,336.33 135-65105-030-000 Printing 4,000.00 4,000.00 144.00 144.00 3.600 3,856.00 Subtotal: 25,120.00 25,120.00 1,849.92 4,785.63 19.051 20,334.37 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 7,841.00 7,841.00 60.315 5,159.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 335.59 414.01 9.000 4,185.99 Subtotal: 17,600.00 17,600.00 8,176.59 8,255.01 46.903 9,344.99 Program number: 1,227,112.00 1,227,112.00 89,717.25 210,912.22 17.188 1,016,199.78 Department number: Administration 1,227,112.00 1,227,112.00 89,717.25 210,912.22 17.188 1,016,199.78 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 17:30 12/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/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 39.69 8,239.69 6.014 128,760.31 135-55055-039-000 Auditing 24,500.00 24,500.00 9,400.00 14,400.00 58.776 10,100.00 135-55060-039-000 Appraisal 11,446.00 11,446.00 2,648.31 2,648.31 23.137 8,797.69 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 176,746.00 176,746.00 12,088.00 25,288.00 14.308 151,458.00 Program number: 176,746.00 176,746.00 12,088.00 25,288.00 14.308 151,458.00 Department number: Non Departmental 176,746.00 176,746.00 12,088.00 25,288.00 14.308 151,458.00 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 642,396.62 1,162,247.66 11.558 8,893,163.34 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 99,237.93- 289,076.37- 148.535 94,458.37 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 17:30 12/13/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal ----------- 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 345 11/01/2017 Property Taxes (642.54) (30.97) (673.51) GL 346 11/02/2017 Property Taxes (69.23) (742.74) GL 347 11/03/2017 Property Taxes (628.65) (1,371.39) GL 348 11/06/2017 Property Taxes (35.43) (1,406.82) GL 349 11/07/2017 Property Taxes (501.31) (1,908.13) GL 350 11/08/2017 Property Taxes (144.92) (2,053.05) GL 351 11/09/2017 Property Taxes (293.53) (2,346.58) GL 352 11/13/2017 Property Taxes (222.68) (2,569.26) GL 353 11/14/2017 Property Taxes (424.54) (2,993.80) GL 354 11/15/2017 Property Taxes (204.81) (3,198.61) GL 355 11/16/2017 Property Taxes (199.72) (3,398.33) GL 356 11/17/2017 Property Taxes (207.87) (3,606.20) GL 357 11/20/2017 Property Taxes (140.59) (3,746.79) GL 358 11/21/2017 Property Taxes (365.05) (4,111.84) GL 359 11/22/2017 Property Taxes (175.77) (4,287.61) GL 360 11/27/2017 Property Taxes (402.87) (4,690.48) GL 361 11/28/2017 Property Taxes (258.39) (4,948.87) GL 362 11/29/2017 Property Taxes (275.00) (5,223.87) GL 373 11/30/2017 Property Taxes (175.78) (5,399.65) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (4,757.11) (5,399.65) ** (120,950.00) Budgeted (115,550.35) Remaining 4 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 345 11/01/2017 Property Taxes (80.01) (1.24) (81.25) GL 347 11/03/2017 Property Taxes (.69) (81.94) GL 348 11/06/2017 Property Taxes (.10) (82.04) GL 357 11/20/2017 Property Taxes (1.46) (83.50) GL 358 11/21/2017 Property Taxes (42.99) (126.49) GL 360 11/27/2017 Property Taxes (9.39) (135.88) GL 361 11/28/2017 Property Taxes (.27) (136.15) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (56.14) (136.15) ** (200.00) Budgeted (63.85) Remaining 68 % Used Account: 135-40015-000-000 Property Taxes/P & I 345 11/01/2017 Property Taxes (14.31) (.52) (14.83) GL 347 11/03/2017 Property Taxes (.09) (14.92) GL 348 11/06/2017 Property Taxes (.05) (14.97) GL 351 11/09/2017 Property Taxes (.11) (15.08) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 354 11/15/2017 Property Taxes (14.31) (.08) (15.16) GL 356 11/17/2017 Property Taxes (.11) (15.27) GL 357 11/20/2017 Property Taxes (3.07) (18.34) GL 358 11/21/2017 Property Taxes (1.01) (19.35) GL 359 11/22/2017 Property Taxes (.06) (19.41) GL 360 11/27/2017 Property Taxes (2.58) (21.99) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (7.68) (21.99) ** (200.00) Budgeted (178.01) Remaining 11 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (177,839.00) Budgeted (177,839.00) Remaining 0 % Used Account: 135-47000-000-000 Water 381 11/17/2017 UB 11/17/17 Adj wt Urbina UB20171117-20171117 User: (462,795.39) 386.19 (462,409.20) UB 344 11/30/2017 Billing November 2017 UB20171130-20171130 User: (469,744.18) (932,153.38) UB _______________ Account: 135-47000-000-000 Water Totals: (469,357.99) (932,153.38) ** (6,464,019.00) Budgeted (5,531,865.62) Remaining 14 % Used Account: 135-47005-000-000 Sewer 344 11/30/2017 Billing November 2017 UB20171130-20171130 User: (225,901.65) (245,140.14) (471,041.79) UB _______________ Account: 135-47005-000-000 Sewer Totals: (245,140.14) (471,041.79) ** (2,978,067.00) Budgeted (2,507,025.21) Remaining 16 % Used Account: 135-47025-000-000 Penalties 374 11/01/2017 Penalty removal UB20171101-20171101 User: (12,029.31) 17.07 (12,012.24) UB 377 11/07/2017 Penalty removal UB20171107-20171107 User: 42.86 (11,969.38) UB 382 11/20/2017 Penalty removals UB20171120-20171120 User: 239.48 (11,729.90) UB 305 11/21/2017 Penalties November 2017 UB20171121-20171121 User: (11,944.25) (23,674.15) UB 383 11/29/2017 Penalty removal UB20171129-20171129 User: 514.48 (23,159.67) UB 385 11/30/2017 Penalty removal UB20171130-20171130 User: 59.43 (23,100.24) UB _______________ Account: 135-47025-000-000 Penalties Totals: (11,070.93) (23,100.24) ** (106,279.00) Budgeted (83,178.76) Remaining 22 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 375 11/01/2017 NSF Check fee UB20171101-20171101 User: (725.00) (25.00) (750.00) UB 229 11/08/2017 Cut Off list November 2017 UB20171108-20171108 User: (1,350.00) (2,100.00) UB 378 11/10/2017 NSF CHeck fee-Gurnell UB20171110-20171110 User: (25.00) (2,125.00) UB 380 11/17/2017 NSF Check fee-Nowroozi UB20171117-20171117 User: (25.00) (2,150.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,425.00) (2,150.00) ** (21,350.00) Budgeted (19,200.00) Remaining 10 % Used Account: 135-47035-000-000 Plumbing Inspections 369 11/20/2017 Permitting 20 Sadie Court (100.00) (50.00) (150.00) Drees Homes CR 369 11/20/2017 Permitting 10 Sadie Court (50.00) (200.00) Drees homes CR 371 11/21/2017 Permits 17 Katie Lane (50.00) (250.00) Drees Homes CR 371 11/21/2017 Permits 9 Saide Court (50.00) (300.00) Drees Homes CR 371 11/21/2017 Permits 3 Sadie Court (50.00) (350.00) Frees Homes CR 372 11/29/2017 Permits 23 Katie lane (50.00) (400.00) Drees Homes CR 372 11/29/2017 Permits 609 Hogan's Drive (50.00) (450.00) Drees Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (350.00) (450.00) ** (1,500.00) Budgeted (1,050.00) Remaining 30 % Used Account: 135-47045-000-000 Sewer Inspections 369 11/20/2017 Permitting 20 Sadie Court (300.00) (150.00) (450.00) Drees Homes CR 369 11/20/2017 Permitting 10 Sadie Court (150.00) (600.00) Drees homes CR 371 11/21/2017 Permits 17 Katie Lane (150.00) (750.00) Drees Homes CR 371 11/21/2017 Permits 9 Saide Court (150.00) (900.00) Drees Homes CR 371 11/21/2017 Permits 3 Sadie Court (150.00) (1,050.00) Frees Homes CR 372 11/29/2017 Permits 23 Katie lane (150.00) (1,200.00) Drees Homes CR 372 11/29/2017 Permits 609 Hogan's Drive (150.00) (1,350.00) Drees Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,050.00) (1,350.00) ** (4,500.00) Budgeted (3,150.00) Remaining 30 % Used Account: 135-47070-000-000 TCCC Effluent Charges 344 11/30/2017 Billing November 2017 UB20171130-20171130 User: (547.20) (547.20) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (547.20) (547.20) ** (60,000.00) Budgeted (59,452.80) Remaining 1 % Used Account: 135-49010-000-000 Interest Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 252 11/09/2017 Recode THB CD Int from 9/30 (2,850.43) 158.21 (2,692.22) GL 423 11/30/2017 November Bank Interest (1,982.44) (4,674.66) GL 423 11/30/2017 November Bank Interest (333.53) (5,008.19) GL 423 11/30/2017 November Bank Interest (146.72) (5,154.91) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (2,304.48) (5,154.91) ** (12,000.00) Budgeted (6,845.09) Remaining 43 % Used Account: 135-49016-000-000 Cell Tower Revenue 441 11/02/2017 Cell Tower Rev. AT&T (910.53) (978.81) (1,889.34) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (1,889.34) ** (10,926.00) Budgeted (9,036.66) Remaining 17 % Used Account: 135-49018-000-000 Building Rent Income 418 11/30/2017 Bill Town Inv 1605-1610 AR 20171130-20171130 User: (583.33) (583.33) (1,166.66) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,166.66) ** (7,000.00) Budgeted (5,833.34) Remaining 17 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 369 11/20/2017 Permitting 20 Sadie Court (686.00) (343.00) (1,029.00) Drees Homes CR 369 11/20/2017 Permitting 10 Sadie Court (343.00) (1,372.00) Drees homes CR 371 11/21/2017 Permits 17 Katie Lane (343.00) (1,715.00) Drees Homes CR 371 11/21/2017 Permits 9 Saide Court (343.00) (2,058.00) Drees Homes CR 371 11/21/2017 Permits 3 Sadie Court (343.00) (2,401.00) Frees Homes CR 372 11/29/2017 Permits 23 Katie lane (343.00) (2,744.00) Drees Homes CR 372 11/29/2017 Permits 609 Hogan's Drive (343.00) (3,087.00) Drees Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (2,401.00) (3,087.00) ** (18,179.00) Budgeted (15,092.00) Remaining 17 % Used Account: 135-49900-000-000 Miscellaneous Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 440 11/02/2017 Lone Star Metals Recycling (2,070.98) (443.00) (2,513.98) GL 442 11/10/2017 Lone Star Metals Recycling (207.00) (2,720.98) GL 372 11/29/2017 Permits 609 Hogan's Dr-Fire line (800.00) (3,520.98) Drees Homes CR 344 11/30/2017 Billing November 2017 UB20171130-20171130 User: (154.74) (3,675.72) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,604.74) (3,675.72) ** (5,000.00) Budgeted (1,324.28) Remaining 74 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (20.00) Budgeted (20.00) Remaining 0 % Used Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (1,451,324.03) ** (741,634.55) Monthly Total (10,250,029.00) Budgeted (8,798,704.97) Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 156 11/03/2017 MUD Payroll 11.03.17 Salaries & Wages 9,342.54 8,541.39 17,883.93 PR 268 11/17/2017 MUD PR 11/17/17 Salaries & Wages 7,483.92 25,367.85 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,025.31 25,367.85 ** 274,279.00 Budgeted 248,911.15 Remaining 9 % Used Account: 135-50010-010-000 Overtime 156 11/03/2017 MUD Payroll 11.03.17 Overtime 106.50 398.46 504.96 PR 268 11/17/2017 MUD PR 11/17/17 Overtime 105.98 610.94 PR _______________ Account: 135-50010-010-000 Overtime Totals: 504.44 610.94 ** 20,000.00 Budgeted 19,389.06 Remaining 3 % Used Account: 135-50016-010-000 Longevity 304 11/22/2017 Longevity MUD PR 11.22.17 Longevity 3,310.00 3,310.00 PR _______________ Account: 135-50016-010-000 Longevity Totals: 3,310.00 3,310.00 ** 3,425.00 Budgeted 115.00 Remaining 97 % Used Account: 135-50017-010-000 Certification 268 11/17/2017 MUD PR 11/17/17 Certification 250.00 150.00 400.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 400.00 ** 3,300.00 Budgeted 2,900.00 Remaining 12 % Used Account: 135-50020-010-000 Retirement 156 11/03/2017 MUD Payroll 11.03.17 Retirement 2,307.12 826.94 3,134.06 PR 268 11/17/2017 MUD PR 11/17/17 Retirement 715.94 3,850.00 PR 304 11/22/2017 Longevity MUD PR 11.22.17 Retirement 306.17 4,156.17 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,849.05 4,156.17 ** 27,843.00 Budgeted 23,686.83 Remaining 15 % Used Account: 135-50026-010-000 Medical Insurance 156 11/03/2017 MUD Payroll 11.03.17 Medical Insurance 2,834.65 1,181.10 4,015.75 PR 268 11/17/2017 MUD PR 11/17/17 Medical Insurance 944.88 4,960.63 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,125.98 4,960.63 ** 52,196.00 Budgeted 47,235.37 Remaining 10 % Used Account: 135-50027-010-000 Dental Insurance 156 11/03/2017 MUD Payroll 11.03.17 Dental Insurance 280.99 121.75 402.74 PR 268 11/17/2017 MUD PR 11/17/17 Dental Insurance 102.95 505.69 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 224.70 505.69 ** 5,182.00 Budgeted 4,676.31 Remaining 10 % Used Account: 135-50028-010-000 Vision Insurance 156 11/03/2017 MUD Payroll 11.03.17 Vision Insurance 58.27 24.63 82.90 PR 268 11/17/2017 MUD PR 11/17/17 Vision Insurance 20.07 102.97 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 44.70 102.97 ** 994.00 Budgeted 891.03 Remaining 10 % Used Account: 135-50029-010-000 Life Insurance & Other 134 11/01/2017 November A/P Nov Dental, Vision and other i 278.12 203.98 482.10 METLIFE GROUP BENEFITS 3635 AP 306 11/21/2017 Nov A/P Flex Admin Fee 10.67 492.77 BenefitMall 3692 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 214.65 492.77 ** 2,982.00 Budgeted 2,489.23 Remaining 17 % Used Account: 135-50030-010-000 Social Security Taxes 156 11/03/2017 MUD Payroll 11.03.17 Social Security Taxes 592.11 551.22 1,143.33 PR 268 11/17/2017 MUD PR 11/17/17 Social Security Taxes 473.58 1,616.91 PR 304 11/22/2017 Longevity MUD PR 11.22.17 Social Security Taxes 205.22 1,822.13 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,230.02 1,822.13 ** 18,662.00 Budgeted 16,839.87 Remaining 10 % Used Account: 135-50035-010-000 Medicare Taxes 156 11/03/2017 MUD Payroll 11.03.17 Medicare Taxes 138.49 128.91 267.40 PR 268 11/17/2017 MUD PR 11/17/17 Medicare Taxes 110.76 378.16 PR 304 11/22/2017 Longevity MUD PR 11.22.17 Medicare Taxes 47.99 426.15 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 287.66 426.15 ** 4,365.00 Budgeted 3,938.85 Remaining 10 % Used Account: 135-50040-010-000 Unemployment Taxes 156 11/03/2017 MUD Payroll 11.03.17 Unemployment Taxes 4.29 2.10 6.39 PR 268 11/17/2017 MUD PR 11/17/17 Unemployment Taxes 1.04 7.43 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 3.14 7.43 ** 1,080.00 Budgeted 1,072.57 Remaining 1 % Used Account: 135-50045-010-000 Workman's Compensation 233 11/01/2017 Insurance/Wrk Comp Exp Nov 899.92 899.92 1,799.84 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 1,799.84 ** 11,854.00 Budgeted 10,054.16 Remaining 15 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations 18.99 .00 18.99 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 18.99 ** 300.00 Budgeted 281.01 Remaining 6 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 275,000.00 Budgeted 275,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 250 11/09/2017 Nov A/P Transducer 406.70 988.77 1,395.47 DHS AUTOMATION, INC 3696 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 306 11/21/2017 Nov A/P bolts, angles, couplings, wash 406.70 2,130.30 3,525.77 Core & Main LP 3693 AP 398 11/27/2017 Pcard 10/27/17 - 11/27/17 THE HOME DEPOT #6581 15.16 3,540.93 THE HOME DEPOT #6581 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 HOMEDEPOT.COM 348.00 3,888.93 HOMEDEPOT.COM PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 THE HOME DEPOT #6581 58.24 3,947.17 THE HOME DEPOT #6581 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 THE HOME DEPOT #6581 37.72 3,984.89 THE HOME DEPOT #6581 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 THE HOME DEPOT #6581 13.52 3,998.41 THE HOME DEPOT #6581 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 FERGUSON ENT 1241 84.96 4,083.37 FERGUSON ENT 1241 PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 3,676.67 4,083.37 ** 100,000.00 Budgeted 95,916.63 Remaining 4 % Used Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 398 11/27/2017 Pcard 10/27/17 - 11/27/17 DENTON VEHREG 1,149.42 15.00 1,164.42 DENTON VEHREG PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 KWIK KAR LUBE & TUNE O 7.00 1,171.42 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 22.00 1,171.42 ** 4,000.00 Budgeted 2,828.58 Remaining 29 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 1,130.74 .00 1,130.74 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 1,130.74 ** 5,500.00 Budgeted 4,369.26 Remaining 21 % Used Account: 135-60010-010-000 Communications/Mobiles 308 11/21/2017 Nov A/P Cell Phones 319.55 319.55 VERIZON WIRELESS 3717 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 319.55 319.55 ** 4,700.00 Budgeted 4,380.45 Remaining 7 % Used Account: 135-60020-010-000 Electricity 306 11/21/2017 Nov A/P Electricity 10/11-11/08/17 14,905.08 34.39 14,939.47 HUDSON ENERGY SERVICES, LLC 3702 AP 306 11/21/2017 Nov A/P Electricity 10/11-11/08/17 57.62 14,997.09 HUDSON ENERGY SERVICES, LLC 3702 AP 306 11/21/2017 Nov A/P Electricity 10/11-11/8/17 12,307.23 27,304.32 HUDSON ENERGY SERVICES, LLC 3702 AP _______________ Account: 135-60020-010-000 Electricity Totals: 12,399.24 27,304.32 ** 175,356.00 Budgeted 148,051.68 Remaining 16 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training .00 .00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 .00 ** 2,785.00 Budgeted 2,785.00 Remaining 0 % Used Account: 135-60090-010-000 Safety Program 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 268 11/17/2017 MUD PR 11/17/17 Travel & per diem 87.48 87.48 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 87.48 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 308 11/21/2017 Nov A/P Water System Fee 7,685.65 7,685.65 TX COMMISSION ENVIRONMENTAL QU 3716 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 7,685.65 7,685.65 ** 55,176.00 Budgeted 47,490.35 Remaining 14 % Used Account: 135-60150-010-000 Wholesale Water 391 11/30/2017 Nov A/P Wholesale Water/October 208,059.10 208,059.10 CITY OF FORT WORTH 3725 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 208,059.10 208,059.10 ** 2,823,170.00 Budgeted 2,615,110.90 Remaining 7 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 214.70 .00 214.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 214.70 ** 3,000.00 Budgeted 2,785.30 Remaining 7 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 391 11/30/2017 Nov A/P Nov Mowing 750.00 1,500.00 2,250.00 WATTS ELLISON LLC 3754 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 2,250.00 ** 14,750.00 Budgeted 12,500.00 Remaining 15 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 333 11/28/2017 Texpool transfers 25,280.31 25,280.31 50,560.62 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 50,560.62 ** 278,084.00 Budgeted 227,523.38 Remaining 18 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 333 11/28/2017 Texpool transfers 4,083.00 4,083.00 8,166.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 8,166.00 ** 48,996.00 Budgeted 40,830.00 Remaining 17 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 391 11/30/2017 Nov A/P Fuel 10/25-11/24/17 769.12 650.59 1,419.71 US Bank Voyager Fleet Systems 3753 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 650.59 1,419.71 ** 15,000.00 Budgeted 13,580.29 Remaining 9 % Used Account: 135-65010-010-000 Uniforms 398 11/27/2017 Pcard 10/27/17 - 11/27/17 RED WING SHOES #652 161.49 161.49 RED WING SHOES #652 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 RED WING SHOES #652 161.49 322.98 RED WING SHOES #652 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 398 11/27/2017 Pcard 10/27/17 - 11/27/17 RED WING SHOES #652 174.24 497.22 RED WING SHOES #652 PC _______________ Account: 135-65010-010-000 Uniforms Totals: 497.22 497.22 ** 4,488.00 Budgeted 3,990.78 Remaining 11 % Used Account: 135-65030-010-000 Chemicals 391 11/30/2017 Nov A/P Chlorine 1,722.70 884.96 2,607.66 DPC INDUSTRIES, INC 3728 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 884.96 2,607.66 ** 20,000.00 Budgeted 17,392.34 Remaining 13 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense .00 .00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 135-65053-010-000 Meter Change Out Program .00 .00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 .00 ** 84,000.00 Budgeted 84,000.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays 250 11/09/2017 Nov A/P SCADA Upgrades 24,767.50 24,767.50 DHS AUTOMATION, INC 3696 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 306 11/21/2017 Nov A/P 16" Waterline 2,460.50 27,228.00 Halff Associates, INC 3701 AP 306 11/21/2017 Nov A/P VFD 13,181.25 40,409.25 CP&Y/WALLACE GROUP, INC. 3694 AP 391 11/30/2017 Nov A/P Ind Creek/Phoenix Water Replac 14,000.00 54,409.25 TEAGUE, NALL & PERKINS,INC 3750 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 54,409.25 54,409.25 ** 810,012.00 Budgeted 755,602.75 Remaining 7 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 65,920.00 .00 65,920.00 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 65,920.00 ** 118,775.00 Budgeted 52,855.00 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 296.19 .00 296.19 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 296.19 ** 2,000.00 Budgeted 1,703.81 Remaining 15 % Used Department 10 Totals: ----------------------------------- 555,172.90 ** 346,424.59 Monthly Total 5,657,433.00 Budgeted 5,102,260.10 Remaining 10 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 156 11/03/2017 MUD Payroll 11.03.17 Salaries & Wages 15,469.41 15,307.43 30,776.84 PR 268 11/17/2017 MUD PR 11/17/17 Salaries & Wages 15,303.74 46,080.58 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 30,611.17 46,080.58 ** 410,866.00 Budgeted 364,785.42 Remaining 11 % Used Account: 135-50010-020-000 Overtime 156 11/03/2017 MUD Payroll 11.03.17 Overtime 1,476.35 1,216.33 2,692.68 PR 268 11/17/2017 MUD PR 11/17/17 Overtime 1,304.36 3,997.04 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,520.69 3,997.04 ** 30,000.00 Budgeted 26,002.96 Remaining 13 % Used Account: 135-50016-020-000 Longevity 304 11/22/2017 Longevity MUD PR 11.22.17 Longevity 7,415.00 7,415.00 PR _______________ Account: 135-50016-020-000 Longevity Totals: 7,415.00 7,415.00 ** 7,415.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 268 11/17/2017 MUD PR 11/17/17 Certification 700.00 625.00 1,325.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 1,325.00 ** 8,400.00 Budgeted 7,075.00 Remaining 16 % Used Account: 135-50020-020-000 Retirement 156 11/03/2017 MUD Payroll 11.03.17 Retirement 3,096.69 1,528.44 4,625.13 PR 268 11/17/2017 MUD PR 11/17/17 Retirement 1,594.06 6,219.19 PR 304 11/22/2017 Longevity MUD PR 11.22.17 Retirement 685.89 6,905.08 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,808.39 6,905.08 ** 42,243.00 Budgeted 35,337.92 Remaining 16 % Used Account: 135-50026-020-000 Medical Insurance 156 11/03/2017 MUD Payroll 11.03.17 Medical Insurance 4,710.20 2,355.10 7,065.30 PR 268 11/17/2017 MUD PR 11/17/17 Medical Insurance 2,355.10 9,420.40 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 9,420.40 ** 62,175.00 Budgeted 52,754.60 Remaining 15 % Used Account: 135-50027-020-000 Dental Insurance 156 11/03/2017 MUD Payroll 11.03.17 Dental Insurance 399.32 199.69 599.01 PR 268 11/17/2017 MUD PR 11/17/17 Dental Insurance 199.63 798.64 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 798.64 ** 5,271.00 Budgeted 4,472.36 Remaining 15 % Used Account: 135-50028-020-000 Vision Insurance 156 11/03/2017 MUD Payroll 11.03.17 Vision Insurance 84.33 42.19 126.52 PR 268 11/17/2017 MUD PR 11/17/17 Vision Insurance 42.14 168.66 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 168.66 ** 1,114.00 Budgeted 945.34 Remaining 15 % Used Account: 135-50029-020-000 Life Insurance & Other 134 11/01/2017 November A/P Nov Dental, Vision and other i 395.14 361.15 756.29 METLIFE GROUP BENEFITS 3635 AP 306 11/21/2017 Nov A/P Flex Admin Fee 31.99 788.28 BenefitMall 3692 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 393.14 788.28 ** 4,281.00 Budgeted 3,492.72 Remaining 18 % Used Account: 135-50030-020-000 Social Security Taxes 156 11/03/2017 MUD Payroll 11.03.17 Social Security Taxes 1,019.46 967.20 1,986.66 PR 268 11/17/2017 MUD PR 11/17/17 Social Security Taxes 993.84 2,980.50 PR 304 11/22/2017 Longevity MUD PR 11.22.17 Social Security Taxes 459.74 3,440.24 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,420.78 3,440.24 ** 28,314.00 Budgeted 24,873.76 Remaining 12 % Used Account: 135-50035-020-000 Medicare Taxes 156 11/03/2017 MUD Payroll 11.03.17 Medicare Taxes 238.41 226.22 464.63 PR 268 11/17/2017 MUD PR 11/17/17 Medicare Taxes 232.43 697.06 PR 304 11/22/2017 Longevity MUD PR 11.22.17 Medicare Taxes 107.51 804.57 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 566.16 804.57 ** 6,622.00 Budgeted 5,817.43 Remaining 12 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 233 11/01/2017 Insurance/Wrk Comp Exp Nov 1,348.00 1,348.00 2,696.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 2,696.00 ** 17,990.00 Budgeted 15,294.00 Remaining 15 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 20,550.00 Budgeted 20,550.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 306 11/21/2017 Nov A/P Saw Cutting 273.10 5,735.00 6,008.10 REY-MAR CONSTRUCTION 3713 AP 398 11/27/2017 Pcard 10/27/17 - 11/27/17 THE HOME DEPOT #6581 42.42 6,050.52 THE HOME DEPOT #6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 398 11/27/2017 Pcard 10/27/17 - 11/27/17 BATTERIES PLUS # 8 273.10 23.95 6,074.47 BATTERIES PLUS # 8 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 UV DOCTOR LAMPS 281.75 6,356.22 UV DOCTOR LAMPS PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 6,083.12 6,356.22 ** 86,100.00 Budgeted 79,743.78 Remaining 7 % Used Account: 135-55085-020-000 Generator Maint. and Repair 398 11/27/2017 Pcard 10/27/17 - 11/27/17 THE HOME DEPOT #6581 28.78 28.78 THE HOME DEPOT #6581 PC _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: 28.78 28.78 ** 14,000.00 Budgeted 13,971.22 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 398 11/27/2017 Pcard 10/27/17 - 11/27/17 AUTOZONE #4206 2,628.73 19.99 2,648.72 AUTOZONE #4206 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 19.99 2,648.72 ** 8,000.00 Budgeted 5,351.28 Remaining 33 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 391 11/30/2017 Nov A/P Sludge Haul off 5,295.61 1,755.49 7,051.10 L.H. CHANEY MATERIALS, INC. 3739 AP 391 11/30/2017 Nov A/P Sludge Haul off 848.38 7,899.48 L.H. CHANEY MATERIALS, INC. 3739 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,603.87 7,899.48 ** 60,000.00 Budgeted 52,100.52 Remaining 13 % Used Account: 135-55135-020-000 Lab Analysis 220 11/07/2017 Nov A/P Testing 5,437.82 114.00 5,551.82 OXIDOR LABORATORIES LLC 3684 AP 220 11/07/2017 Nov A/P Testing 176.00 5,727.82 OXIDOR LABORATORIES LLC 3684 AP 391 11/30/2017 Nov A/P Testing 176.00 5,903.82 OXIDOR LABORATORIES LLC 3744 AP 391 11/30/2017 Nov A/P Testing 246.00 6,149.82 OXIDOR LABORATORIES LLC 3744 AP 391 11/30/2017 Nov A/P Testing 176.00 6,325.82 OXIDOR LABORATORIES LLC 3744 AP 391 11/30/2017 Nov A/P Testing 246.00 6,571.82 OXIDOR LABORATORIES LLC 3744 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 391 11/30/2017 Nov A/P Testing 5,437.82 176.00 6,747.82 OXIDOR LABORATORIES LLC 3744 AP 391 11/30/2017 Nov A/P Bio-monitoring 1,080.00 7,827.82 HUTHER AND ASSOCIATES,INC 3732 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,390.00 7,827.82 ** 30,000.00 Budgeted 22,172.18 Remaining 26 % Used Account: 135-60010-020-000 Communications/Mobiles 308 11/21/2017 Nov A/P Cell Phones 381.56 381.56 VERIZON WIRELESS 3717 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 381.56 381.56 ** 4,700.00 Budgeted 4,318.44 Remaining 8 % Used Account: 135-60020-020-000 Electricity 306 11/21/2017 Nov A/P Electricity WWTP 13,288.76 5,398.53 18,687.29 ENGIE Resources LLC 3698 AP 306 11/21/2017 Nov A/P Electricity 10/11-11/8/17 204.21 18,891.50 MP2 ENERGY TEXAS LLC 3709 AP 306 11/21/2017 Nov A/P Electricity 10/11-11/08/17 31.50 18,923.00 HUDSON ENERGY SERVICES, LLC 3702 AP 306 11/21/2017 Nov A/P Electricity 10/11-11/8/17 466.33 19,389.33 HUDSON ENERGY SERVICES, LLC 3702 AP 306 11/21/2017 Nov A/P Electricity 145.96 19,535.29 TRI COUNTY ELECTRIC 3715 AP 306 11/21/2017 Nov A/P Electricity 27.31 19,562.60 TRI COUNTY ELECTRIC 3715 AP 306 11/21/2017 Nov A/P Electricity 347.88 19,910.48 TRI COUNTY ELECTRIC 3715 AP 391 11/30/2017 Nov A/P Electricity 10/11-11/8/17 7,216.59 27,127.07 HUDSON ENERGY SERVICES, LLC 3731 AP 418 11/30/2017 Bill Town Inv 1605-1610 AR 20171130-20171130 User: (130.78) 26,996.29 AR _______________ Account: 135-60020-020-000 Electricity Totals: 13,707.53 26,996.29 ** 266,709.00 Budgeted 239,712.71 Remaining 10 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 5,677.00 Budgeted 5,677.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 8.37 .00 8.37 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 8.37 ** 550.00 Budgeted 541.63 Remaining 2 % Used Account: 135-60100-020-000 Travel & per diem 411 11/30/2017 Nov A/P Samples to Lab 23.17 23.17 NTTA 3759 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 23.17 23.17 ** 1,635.00 Budgeted 1,611.83 Remaining 1 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 306 11/21/2017 Nov A/P SOAH Legal 9,888.02 1,350.00 11,238.02 AL Law Group 3691 AP 306 11/21/2017 Nov A/P SOAH Legal 20,447.00 31,685.02 AL Law Group 3691 AP 306 11/21/2017 Nov A/P SOAH 3,048.75 34,733.77 CP&Y/WALLACE GROUP, INC. 3694 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 24,845.75 34,733.77 ** 85,000.00 Budgeted 50,266.23 Remaining 41 % Used Account: 135-60245-020-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 391 11/30/2017 Nov A/P Nov Mowing 590.00 1,180.00 1,770.00 WATTS ELLISON LLC 3754 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 1,770.00 ** 11,600.00 Budgeted 9,830.00 Remaining 15 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 333 11/28/2017 Texpool transfers 11,094.81 11,094.81 22,189.62 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 22,189.62 ** 122,043.00 Budgeted 99,853.38 Remaining 18 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 333 11/28/2017 Texpool transfers 54,430.72 54,430.72 108,861.44 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 108,861.44 ** 598,738.00 Budgeted 489,876.56 Remaining 18 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 333 11/28/2017 Texpool transfers 10,278.00 10,278.00 20,556.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 20,556.00 ** 123,336.00 Budgeted 102,780.00 Remaining 17 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 391 11/30/2017 Nov A/P Fuel 10/25-11/24/17 743.89 789.72 1,533.61 US Bank Voyager Fleet Systems 3753 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 789.72 1,533.61 ** 12,500.00 Budgeted 10,966.39 Remaining 12 % Used Account: 135-65010-020-000 Uniforms 1,614.63 .00 1,614.63 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,614.63 ** 4,459.00 Budgeted 2,844.37 Remaining 36 % Used Account: 135-65030-020-000 Chemicals 398 11/27/2017 Pcard 10/27/17 - 11/27/17 ROANOKE AUTO SUPPLY LT 5.35 5.35 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-65030-020-000 Chemicals Totals: 5.35 5.35 ** 27,500.00 Budgeted 27,494.65 Remaining 0 % Used Account: 135-65035-020-000 Small Tools 398 11/27/2017 Pcard 10/27/17 - 11/27/17 THE HOME DEPOT #6581 71.53 19.95 91.48 THE HOME DEPOT #6581 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 THE HOME DEPOT #6581 39.66 131.14 THE HOME DEPOT #6581 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 THE HOME DEPOT #6581 116.62 247.76 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 176.23 247.76 ** 1,000.00 Budgeted 752.24 Remaining 25 % Used Account: 135-65040-020-000 Safety Equipment . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-65045-020-000 Lab Supplies 391 11/30/2017 Nov A/P Colilert 560.55 1,576.08 2,136.63 IDEXX DISTRIBUTION, INC 3733 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,576.08 2,136.63 ** 14,000.00 Budgeted 11,863.37 Remaining 15 % Used Account: 135-69005-020-000 Capital Outlays 306 11/21/2017 Nov A/P WWTP Legal 1,563.49 1,827.50 3,390.99 Dubois Bryant Campbell LLP 3697 AP 306 11/21/2017 Nov A/P WWTP Construction Legal 6,480.00 9,870.99 CP&Y/WALLACE GROUP, INC. 3694 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 8,307.50 9,870.99 ** 547,327.00 Budgeted 537,456.01 Remaining 2 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 51,342.00 Budgeted 51,342.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 7,573.00 Budgeted 7,573.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ----------------------------------- 369,529.70 ** 192,824.36 Monthly Total 2,981,140.00 Budgeted 2,611,610.30 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 233 11/01/2017 Insurance/Wrk Comp Exp Nov 2.42 2.42 4.84 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 4.84 ** 30.00 Budgeted 25.16 Remaining 16 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 391 11/30/2017 Nov A/P Annual dues 1/1/18-12/31/18 650.00 650.00 AWBD 3724 AP _______________ Account: 135-60070-026-000 Dues & Memberships Totals: 650.00 650.00 ** 600.00 Budgeted (50.00) Remaining 108 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 391 11/30/2017 Nov A/P Mid Winter Conf-Carr 345.00 345.00 AWBD 3724 AP 391 11/30/2017 Nov A/P Mid Winter Conf-Rose 345.00 690.00 AWBD 3724 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 690.00 690.00 ** 4,000.00 Budgeted 3,310.00 Remaining 17 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: ----------------------------------- 1,344.84 ** 1,342.42 Monthly Total 12,980.00 Budgeted 11,635.16 Remaining 10 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 156 11/03/2017 MUD Payroll 11.03.17 Salaries & Wages 15,186.73 15,136.65 30,323.38 PR 268 11/17/2017 MUD PR 11/17/17 Salaries & Wages 16,264.32 46,587.70 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 31,400.97 46,587.70 ** 432,863.00 Budgeted 386,275.30 Remaining 11 % Used Account: 135-50010-030-000 Overtime 156 11/03/2017 MUD Payroll 11.03.17 Overtime 4.83 169.37 174.20 PR _______________ Account: 135-50010-030-000 Overtime Totals: 169.37 174.20 ** 2,000.00 Budgeted 1,825.80 Remaining 9 % Used Account: 135-50016-030-000 Longevity 304 11/22/2017 Longevity MUD PR 11.22.17 Longevity 3,547.50 3,547.50 PR _______________ Account: 135-50016-030-000 Longevity Totals: 3,547.50 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 156 11/03/2017 MUD Payroll 11.03.17 Retirement 3,712.17 1,415.79 5,127.96 PR 268 11/17/2017 MUD PR 11/17/17 Retirement 1,504.46 6,632.42 PR 304 11/22/2017 Longevity MUD PR 11.22.17 Retirement 328.15 6,960.57 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,248.40 6,960.57 ** 40,553.00 Budgeted 33,592.43 Remaining 17 % Used Account: 135-50026-030-000 Medical Insurance 156 11/03/2017 MUD Payroll 11.03.17 Medical Insurance 3,349.61 1,674.80 5,024.41 PR 268 11/17/2017 MUD PR 11/17/17 Medical Insurance 1,911.03 6,935.44 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,585.83 6,935.44 ** 63,485.00 Budgeted 56,549.56 Remaining 11 % Used Account: 135-50027-030-000 Dental Insurance 156 11/03/2017 MUD Payroll 11.03.17 Dental Insurance 311.37 155.71 467.08 PR 268 11/17/2017 MUD PR 11/17/17 Dental Insurance 174.42 641.50 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 330.13 641.50 ** 5,502.00 Budgeted 4,860.50 Remaining 12 % Used Account: 135-50028-030-000 Vision Insurance 156 11/03/2017 MUD Payroll 11.03.17 Vision Insurance 66.77 33.41 100.18 PR 268 11/17/2017 MUD PR 11/17/17 Vision Insurance 37.88 138.06 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 71.29 138.06 ** 1,173.00 Budgeted 1,034.94 Remaining 12 % Used Account: 135-50029-030-000 Life Insurance & Other 134 11/01/2017 November A/P Nov Dental, Vision and other i 285.70 353.61 639.31 METLIFE GROUP BENEFITS 3635 AP 306 11/21/2017 Nov A/P Flex Admin Fee 21.34 660.65 BenefitMall 3692 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 374.95 660.65 ** 5,059.00 Budgeted 4,398.35 Remaining 13 % Used Account: 135-50030-030-000 Social Security Taxes 156 11/03/2017 MUD Payroll 11.03.17 Social Security Taxes 892.33 911.26 1,803.59 PR 268 11/17/2017 MUD PR 11/17/17 Social Security Taxes 958.86 2,762.45 PR 304 11/22/2017 Longevity MUD PR 11.22.17 Social Security Taxes 219.94 2,982.39 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,090.06 2,982.39 ** 27,181.00 Budgeted 24,198.61 Remaining 11 % Used Account: 135-50035-030-000 Medicare Taxes 156 11/03/2017 MUD Payroll 11.03.17 Medicare Taxes 208.69 213.11 421.80 PR 268 11/17/2017 MUD PR 11/17/17 Medicare Taxes 224.24 646.04 PR 304 11/22/2017 Longevity MUD PR 11.22.17 Medicare Taxes 51.44 697.48 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 488.79 697.48 ** 6,357.00 Budgeted 5,659.52 Remaining 11 % Used Account: 135-50040-030-000 Unemployment Taxes 156 11/03/2017 MUD Payroll 11.03.17 Unemployment Taxes 1.68 1.12 2.80 PR 268 11/17/2017 MUD PR 11/17/17 Unemployment Taxes 2.24 5.04 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 3.36 5.04 ** 1,260.00 Budgeted 1,254.96 Remaining 0 % Used Account: 135-50045-030-000 Workman's Compensation 233 11/01/2017 Insurance/Wrk Comp Exp Nov 123.50 123.50 247.00 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 247.00 ** 1,529.00 Budgeted 1,282.00 Remaining 16 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 124.95 .00 124.95 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 124.95 ** 500.00 Budgeted 375.05 Remaining 25 % Used Account: 135-50070-030-000 Employee Relations 443 11/14/2017 Flu Shot Morgan Gonzales 92.38 (17.00) 75.38 GL 398 11/27/2017 Pcard 10/27/17 - 11/27/17 TOM THUMB #1789 73.05 148.43 TOM THUMB #1789 PC 421 11/30/2017 Nov A/P Gexa, Pest control, Flu shots 166.25 314.68 TOWN OF TROPHY CLUB AP _______________ Account: 135-50070-030-000 Employee Relations Totals: 222.30 314.68 ** 4,960.00 Budgeted 4,645.32 Remaining 6 % Used Account: 135-55030-030-000 Software & Support 188 11/02/2017 Nov A/P License fee 5,157.98 15.50 5,173.48 Data Management Inc. 3649 AP 306 11/21/2017 Nov A/P Office 365 Email licenses 168.00 5,341.48 M3 Networks 3705 AP 308 11/21/2017 Nov A/P New SCADA Computer 495.00 5,836.48 WIN-911 SOFTWARE 3719 AP 308 11/21/2017 Nov A/P Internet 1,038.02 6,874.50 WHOLESALE CARRIER SERVICES INC 3718 AP 398 11/27/2017 Pcard 10/27/17 - 11/27/17 TOM THUMB #1789 3.29 6,877.79 TOM THUMB #1789 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 ADOBE *IL CREATIVE CLD 19.99 6,897.78 ADOBE *IL CREATIVE CLD PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 CANVA FOR WORK MONTHLY 12.95 6,910.73 CANVA FOR WORK MONTHLY PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 ATT*BILL PAYMENT 63.49 6,974.22 ATT*BILL PAYMENT PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 ATT*BILL PAYMENT 118.59 7,092.81 ATT*BILL PAYMENT PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 ATT*BILL PAYMENT 102.08 7,194.89 ATT*BILL PAYMENT PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 ATT*BILL PAYMENT 85.56 7,280.45 ATT*BILL PAYMENT PC 391 11/30/2017 Nov A/P Annual Software Support 1/1/18 5,180.75 12,461.20 MCCI 3742 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 7,303.22 12,461.20 ** 78,391.00 Budgeted 65,929.80 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55070-030-000 Independent Labor 306 11/21/2017 Nov A/P 16,514.89 582.90 17,097.79 Onin Staffing, LLC 3712 AP 391 11/30/2017 Nov A/P Nov GM 9,675.00 26,772.79 Carman Consulting LLC. 3757 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 10,257.90 26,772.79 ** 154,000.00 Budgeted 127,227.21 Remaining 17 % Used Account: 135-55080-030-000 Maintenance & Repairs 306 11/21/2017 Nov A/P Rug Service 33.24 66.47 99.71 G & K SERVICES 3700 AP 418 11/30/2017 Bill Town Inv 1605-1610 AR 20171130-20171130 User: (66.47) 33.24 AR 421 11/30/2017 Nov A/P Gexa, Pest control, Flu shots 62.50 95.74 TOWN OF TROPHY CLUB AP 421 11/30/2017 Nov A/P Rug Service 66.47 162.21 G & K SERVICES AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 128.97 162.21 ** 14,000.00 Budgeted 13,837.79 Remaining 1 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 306 11/21/2017 Nov A/P October Janitorial Service (186.59) 869.06 682.47 MEMBER'S BUILDING MAINTENANCE 3707 AP 418 11/30/2017 Bill Town Inv 1605-1610 AR 20171130-20171130 User: (196.32) 486.15 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 672.74 486.15 ** 10,000.00 Budgeted 9,513.85 Remaining 5 % Used Account: 135-55160-030-000 Professional Outside Services 56,475.00 .00 56,475.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 56,475.00 ** 63,325.00 Budgeted 6,850.00 Remaining 89 % Used Account: 135-55165-030-000 Collection Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 573.93 .00 573.93 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 573.93 ** 9,000.00 Budgeted 8,426.07 Remaining 6 % Used Account: 135-60005-030-000 Telephone 188 11/02/2017 Nov A/P Answering Service 661.01 200.00 861.01 KEYSTONE PARK SECRETARIAL 3657 AP 398 11/27/2017 Pcard 10/27/17 - 11/27/17 RINGCENTRAL, INC 13.96 874.97 RINGCENTRAL, INC PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 ATT*BUS PHONE PMT 454.17 1,329.14 ATT*BUS PHONE PMT PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 ATT*BUS PHONE PMT 851.19 2,180.33 ATT*BUS PHONE PMT PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 ATT*BILL PAYMENT 190.26 2,370.59 ATT*BILL PAYMENT PC 418 11/30/2017 Bill Town Inv 1605-1610 AR 20171130-20171130 User: (851.37) 1,519.22 AR _______________ Account: 135-60005-030-000 Telephone Totals: 858.21 1,519.22 ** 27,300.00 Budgeted 25,780.78 Remaining 6 % Used Account: 135-60010-030-000 Communications/Mobiles 268 11/17/2017 MUD PR 11/17/17 Communications/Mobiles 225.00 225.00 450.00 PR 308 11/21/2017 Nov A/P Cell Phones 37.99 487.99 VERIZON WIRELESS 3717 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 262.99 487.99 ** 4,000.00 Budgeted 3,512.01 Remaining 12 % Used Account: 135-60020-030-000 Electricity/Gas 421 11/30/2017 Nov A/P Gexa, Pest control, Flu shots 644.52 644.52 TOWN OF TROPHY CLUB AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 644.52 644.52 ** 16,261.00 Budgeted 15,616.48 Remaining 4 % Used Account: 135-60025-030-000 Water 391 11/30/2017 Nov A/P Nov Water 58.10 116.19 174.29 TROPHY CLUB MUD (WATER BILLS) 3752 AP 418 11/30/2017 Bill Town Inv 1605-1610 AR 20171130-20171130 User: (58.09) 116.20 AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60025-030-000 Water Totals: 58.10 116.20 ** 2,500.00 Budgeted 2,383.80 Remaining 5 % Used Account: 135-60035-030-000 Postage 1,702.91 .00 1,702.91 _______________ Account: 135-60035-030-000 Postage Totals: .00 1,702.91 ** 30,000.00 Budgeted 28,297.09 Remaining 6 % Used Account: 135-60040-030-000 Service Charges & Fees 310 11/02/2017 Credit card Fees 5,569.85 5,413.57 10,983.42 GL 310 11/02/2017 Credit card Fees 124.87 11,108.29 GL 157 11/03/2017 Child Support Fee 1.50 11,109.79 GL 269 11/17/2017 Child Support Fee 1.50 11,111.29 GL 391 11/30/2017 Nov A/P October Direct Send Fees 50.00 11,161.29 Fiserv Solutions, LLC 3729 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,591.44 11,161.29 ** 55,560.00 Budgeted 44,398.71 Remaining 20 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 233 11/01/2017 Insurance/Wrk Comp Exp Nov 6,100.36 6,100.36 12,200.72 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 12,200.72 ** 56,000.00 Budgeted 43,799.28 Remaining 22 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-030-000 Dues & Memberships 306 11/21/2017 Nov A/P Membership dues FY2018 100.00 100.00 N CENTRAL TX COG 3710 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 100.00 100.00 ** 6,000.00 Budgeted 5,900.00 Remaining 2 % Used Account: 135-60075-030-000 Meetings 398 11/27/2017 Pcard 10/27/17 - 11/27/17 HOT & CREAMY DONUTS 48.62 48.62 HOT & CREAMY DONUTS PC _______________ Account: 135-60075-030-000 Meetings Totals: 48.62 48.62 ** 400.00 Budgeted 351.38 Remaining 12 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 398 11/27/2017 Pcard 10/27/17 - 11/27/17 TEXAS SECRETARY OF STA 659.00 245.00 904.00 TEXAS SECRETARY OF STA PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 TX.GOV SERVICEFEE- 4.00 908.00 TX.GOV SERVICEFEE- PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 Finance Director Training 6m 1,700.00 2,608.00 NCTCOG RTC TRAINING PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 1,949.00 2,608.00 ** 7,600.00 Budgeted 4,992.00 Remaining 34 % Used Account: 135-60100-030-000 Travel & per diem 156 11/03/2017 MUD Payroll 11.03.17 Travel & per diem 27.92 48.76 76.68 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 48.76 76.68 ** 4,885.00 Budgeted 4,808.32 Remaining 2 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60115-030-000 Elections 45.00 .00 45.00 _______________ Account: 135-60115-030-000 Elections Totals: .00 45.00 ** 4,500.00 Budgeted 4,455.00 Remaining 1 % Used Account: 135-60125-030-000 Advertising 398 11/27/2017 Pcard 10/27/17 - 11/27/17 Refund for Water Op Job Post 202.53 (202.53) .00 ZIPRECRUITER, INC. PC _______________ Account: 135-60125-030-000 Advertising Totals: (202.53) .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 2,700.00 Budgeted 2,700.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 398 11/27/2017 Pcard 10/27/17 - 11/27/17 STAPLES 00116533 211.99 211.99 STAPLES 00116533 PC _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 211.99 211.99 ** 2,500.00 Budgeted 2,288.01 Remaining 8 % Used Account: 135-65010-030-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 700.00 Budgeted 700.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 597.95 .00 597.95 _______________ Account: 135-65055-030-000 Hardware Totals: .00 597.95 ** 7,420.00 Budgeted 6,822.05 Remaining 8 % Used Account: 135-65085-030-000 Office Supplies 306 11/21/2017 Nov A/P Office Supplies 829.47 131.55 961.02 OFFICE DEPOT, INC 3711 AP 306 11/21/2017 Nov A/P Office supplies 320.72 1,281.74 OFFICE DEPOT, INC 3711 AP 398 11/27/2017 Pcard 10/27/17 - 11/27/17 OFFICE DEPOT #406 62.45 1,344.19 OFFICE DEPOT #406 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 OFFICE DEPOT #406 15.98 1,360.17 OFFICE DEPOT #406 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 STAPLES 00116533 101.43 1,461.60 STAPLES 00116533 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 OFFICE DEPOT #1079 40.09 1,501.69 OFFICE DEPOT #1079 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 OFFICE DEPOT #1079 45.98 1,547.67 OFFICE DEPOT #1079 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 AMAZON MKTPLACE PMTS (14.14) 1,533.53 AMAZON MKTPLACE PMTS PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 DESKTOP SUPPLIES.COM 190.31 1,723.84 DESKTOP SUPPLIES.COM PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 AMAZON MKTPLACE PMTS (14.14) 1,709.70 AMAZON MKTPLACE PMTS PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 AMAZON MKTPLACE PMTS 110.31 1,820.01 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65085-030-000 Office Supplies Totals: 990.54 1,820.01 ** 7,000.00 Budgeted 5,179.99 Remaining 26 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 398 11/27/2017 Pcard 10/27/17 - 11/27/17 SHI GOVERNMENT SOLUTIO 1,173.37 189.63 1,363.00 SHI GOVERNMENT SOLUTIO PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 SHI GOVERNMENT SOLUTIO 197.00 1,560.00 SHI GOVERNMENT SOLUTIO PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 386.63 1,560.00 ** 2,000.00 Budgeted 440.00 Remaining 78 % Used Account: 135-65095-030-000 Maintenance Supplies 398 11/27/2017 Pcard 10/27/17 - 11/27/17 SAMSCLUB.COM 334.92 118.96 453.88 SAMSCLUB.COM PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 AMAZON MKTPLACE PMTS 111.56 565.44 AMAZON MKTPLACE PMTS PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 SAMS CLUB #4795 55.30 620.74 SAMS CLUB #4795 PC 398 11/27/2017 Pcard 10/27/17 - 11/27/17 TOM THUMB #1789 15.99 636.73 TOM THUMB #1789 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 398 11/27/2017 Pcard 10/27/17 - 11/27/17 TOM THUMB #1789 334.92 26.94 663.67 TOM THUMB #1789 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 328.75 663.67 ** 4,000.00 Budgeted 3,336.33 Remaining 17 % Used Account: 135-65105-030-000 Printing 398 11/27/2017 Pcard 10/27/17 - 11/27/17 STAPLES 00116533 144.00 144.00 STAPLES 00116533 PC _______________ Account: 135-65105-030-000 Printing Totals: 144.00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used Account: 135-69005-030-000 Capital Outlays 289 11/20/2017 Nov A/P Security Project 7,841.00 7,841.00 3RD EYE SURVEILLANCE SYSTEMS 3685 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 7,841.00 7,841.00 ** 13,000.00 Budgeted 5,159.00 Remaining 60 % Used Account: 135-69170-030-000 Copier Lease Installments 306 11/21/2017 Nov A/P Copier Lease 78.42 194.00 272.42 EVERBANK COMMERCIAL FINANCE 3699 AP 391 11/30/2017 Nov A/P Copy charges 141.59 414.01 KYOCERA DOCUMENT SOLUTIONS 3738 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 335.59 414.01 ** 4,600.00 Budgeted 4,185.99 Remaining 9 % Used Department 30 Totals: ----------------------------------- 210,912.22 ** 89,717.25 Monthly Total 1,227,112.00 Budgeted 1,016,199.78 Remaining 17 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 391 11/30/2017 Nov A/P Refund Retainer Overpayment 8,200.00 39.69 8,239.69 THE LISTON LAW FIRM, P.C. 3751 AP _______________ Account: 135-55045-039-000 Legal Totals: 39.69 8,239.69 ** 137,000.00 Budgeted 128,760.31 Remaining 6 % Used Account: 135-55055-039-000 Auditing 391 11/30/2017 Nov A/P Audit Field work 5,000.00 9,400.00 14,400.00 LAFOLLETT & ABBOTT PLLC 3740 AP _______________ Account: 135-55055-039-000 Auditing Totals: 9,400.00 14,400.00 ** 24,500.00 Budgeted 10,100.00 Remaining 59 % Used Account: 135-55060-039-000 Appraisal 391 11/30/2017 Nov A/P TAD Budget Allocation/Annual 2,648.31 2,648.31 TARRANT APPRAISAL DISTRICT 3748 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,648.31 2,648.31 ** 11,446.00 Budgeted 8,797.69 Remaining 23 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 3,800.00 Budgeted 3,800.00 Remaining 0 % Used Department 39 Totals: ----------------------------------- 25,288.00 ** 12,088.00 Monthly Total 176,746.00 Budgeted 151,458.00 Remaining 14 % Used Fund 135 Totals: ----------------------------------- (289,076.37) (99,237.93) Monthly Total (194,618.00) Budgeted 94,458.37 Remaining 149 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (105,000.00) .00 (105,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (186,420.00) ** .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET NOVEMBER 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 1,361,553 ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,361,553 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 680,448 TOTAL LIABILITIES 680,448 FUND BALANCE ASSIGNED FUND BALANCE 992,578 NET REVENUES / EXPENDITURES (311,473) TOTAL FUND BALANCE 681,105 TOTAL LIABILITIES AND FUND BALANCE 1,361,553 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 17:30 12/13/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,418.01- 3,050.32- 3,050.32 Subtotal: 1,418.01- 3,050.32- 3,050.32 Program number: 1,418.01- 3,050.32- 3,050.32 Department number: Revenues 1,418.01- 3,050.32- 3,050.32 Revenues Subtotal ----------- 1,418.01- 3,050.32- 3,050.32 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 17:30 12/13/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 11/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 314,523.75 314,523.75 314,523.75- Subtotal: 314,523.75 314,523.75 314,523.75- Program number: 314,523.75 314,523.75 314,523.75- Department number: Wastewater 314,523.75 314,523.75 314,523.75- Expenditures Subtotal ----------- 314,523.75 314,523.75 314,523.75- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 313,105.74 311,473.43 311,473.43- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 423 11/30/2017 November Bank Interest (1,632.31) (1,418.01) (3,050.32) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,418.01) (3,050.32) ** .00 Budgeted 3,050.32 Remaining 0 % Used Department Totals: ----------------------------------- (3,050.32) ** (1,418.01) Monthly Total .00 Budgeted 3,050.32 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 288 11/01/2017 Webber App 24 Retainage 630.41 630.41 GL 289 11/20/2017 Nov A/P Pay App 24 WWTP Improvements 280,368.84 280,999.25 WEBBER-CADAGUA PARTNERS 3690 AP 306 11/21/2017 Nov A/P WWTP Improvements 33,524.50 314,523.75 CP&Y/WALLACE GROUP, INC. 3694 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 314,523.75 314,523.75 ** .00 Budgeted (314,523.75) Remaining 0 % Used Department 20 Totals: ----------------------------------- 314,523.75 ** 314,523.75 Monthly Total .00 Budgeted (314,523.75) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 311,473.43 313,105.74 Monthly Total .00 Budgeted (311,473.43) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET NOVEMBER 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 NOVEMBER 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 NOVEMBER 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 456,057 ACCOUNTS RECEIVABLE - TOTAL ASSETS 456,057 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,578 NET REVENUES / EXPENDITURES 29,479 TOTAL FUND BALANCE 456,057 TOTAL LIABILITIES AND FUND BALANCE 456,057 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 17:30 12/13/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/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- 382.32- 756.52- 75.652 243.48- 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 8,166.00- 16.667 40,830.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 20,556.00- 16.667 102,780.00- Subtotal: 173,332.00- 173,332.00- 14,743.32- 29,478.52- 17.007 143,853.48- Program number: 173,332.00- 173,332.00- 14,743.32- 29,478.52- 17.007 143,853.48- Department number: 173,332.00- 173,332.00- 14,743.32- 29,478.52- 17.007 143,853.48- Revenues Subtotal ----------- 173,332.00- 173,332.00- 14,743.32- 29,478.52- 17.007 143,853.48- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 14,743.32- 29,478.52- 17.007 143,853.48- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 423 11/30/2017 November Bank Interest (374.20) (382.32) (756.52) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (382.32) (756.52) ** (1,000.00) Budgeted (243.48) Remaining 76 % Used Account: 528-49142-000-000 Interfund transfer in-Water 333 11/28/2017 Texpool transfers (4,083.00) (4,083.00) (8,166.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (8,166.00) ** (48,996.00) Budgeted (40,830.00) Remaining 17 % Used Account: 528-49143-000-000 Interfund transfer in-WW 333 11/28/2017 Texpool transfers (10,278.00) (10,278.00) (20,556.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (20,556.00) ** (123,336.00) Budgeted (102,780.00) Remaining 17 % Used Department Totals: ----------------------------------- (29,478.52) ** (14,743.32) Monthly Total (173,332.00) Budgeted (143,853.48) Remaining 17 % Used Fund 528 Totals: ----------------------------------- (29,478.52) (14,743.32) Monthly Total (173,332.00) Budgeted (143,853.48) Remaining 17 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET NOVEMBER 2017 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,572 INVESTMENTS 81,601 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 660,454 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 746,627 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 660,454 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 660,454 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 53,833 TOTAL FUND BALANCE 86,173 TOTAL LIABILITIES AND FUND BALANCE 746,627 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 17:30 12/13/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/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- 26,339.21- 29,896.89- 4.464 639,763.11- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 609.74- 1,494.92- 83.051 305.08- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 46.15- 178.17- 8.909 1,821.83- Subtotal: 673,460.00- 673,460.00- 26,995.10- 31,569.98- 4.688 641,890.02- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 47.47- 72.96- 3.648 1,927.04- 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- 22,189.62- 18.182 99,853.38- Subtotal: 342,997.00- 342,997.00- 11,142.28- 22,262.58- 6.491 320,734.42- Program number: 1,016,457.00- 1,016,457.00- 38,137.38- 53,832.56- 5.296 962,624.44- Department number: Revenues 1,016,457.00- 1,016,457.00- 38,137.38- 53,832.56- 5.296 962,624.44- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 38,137.38- 53,832.56- 5.296 962,624.44- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 17:30 12/13/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/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- 38,137.38- 53,832.56- 928.308 48,033.56 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 345 11/01/2017 Property Taxes (3,557.68) (171.47) (3,729.15) GL 346 11/02/2017 Property Taxes (383.32) (4,112.47) GL 347 11/03/2017 Property Taxes (3,480.72) (7,593.19) GL 348 11/06/2017 Property Taxes (196.17) (7,789.36) GL 349 11/07/2017 Property Taxes (2,775.65) (10,565.01) GL 350 11/08/2017 Property Taxes (802.40) (11,367.41) GL 351 11/09/2017 Property Taxes (1,625.20) (12,992.61) GL 352 11/13/2017 Property Taxes (1,232.90) (14,225.51) GL 353 11/14/2017 Property Taxes (2,350.59) (16,576.10) GL 354 11/15/2017 Property Taxes (1,134.01) (17,710.11) GL 355 11/16/2017 Property Taxes (1,105.79) (18,815.90) GL 356 11/17/2017 Property Taxes (1,150.93) (19,966.83) GL 357 11/20/2017 Property Taxes (778.43) (20,745.26) GL 358 11/21/2017 Property Taxes (2,021.22) (22,766.48) GL 359 11/22/2017 Property Taxes (973.20) (23,739.68) GL 360 11/27/2017 Property Taxes (2,230.61) (25,970.29) GL 361 11/28/2017 Property Taxes (1,430.68) (27,400.97) GL 362 11/29/2017 Property Taxes (1,522.66) (28,923.63) GL 373 11/30/2017 Property Taxes (973.26) (29,896.89) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (26,339.21) (29,896.89) ** (669,660.00) Budgeted (639,763.11) Remaining 4 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 345 11/01/2017 Property Taxes (885.18) (3.44) (888.62) GL 347 11/03/2017 Property Taxes (7.59) (896.21) GL 348 11/06/2017 Property Taxes (1.12) (897.33) GL 357 11/20/2017 Property Taxes (16.08) (913.41) GL 358 11/21/2017 Property Taxes (474.92) (1,388.33) GL 360 11/27/2017 Property Taxes (103.69) (1,492.02) GL 361 11/28/2017 Property Taxes (2.90) (1,494.92) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (609.74) (1,494.92) ** (1,800.00) Budgeted (305.08) Remaining 83 % Used Account: 533-40015-000-000 Property Taxes/P & I 345 11/01/2017 Property Taxes (132.02) (1.45) (133.47) GL 347 11/03/2017 Property Taxes (.98) (134.45) GL 348 11/06/2017 Property Taxes (.55) (135.00) GL 357 11/20/2017 Property Taxes (3.54) (138.54) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 358 11/21/2017 Property Taxes (132.02) (11.09) (149.63) GL 360 11/27/2017 Property Taxes (28.54) (178.17) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (46.15) (178.17) ** (2,000.00) Budgeted (1,821.83) Remaining 9 % Used Account: 533-49010-000-000 Interest Income 423 11/30/2017 November Bank Interest (25.49) (47.47) (72.96) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (47.47) (72.96) ** (2,000.00) Budgeted (1,927.04) Remaining 4 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (218,954.00) Budgeted (218,954.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 333 11/28/2017 Texpool transfers (11,094.81) (11,094.81) (22,189.62) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (22,189.62) ** (122,043.00) Budgeted (99,853.38) Remaining 18 % Used Department Totals: ----------------------------------- (53,832.56) ** (38,137.38) Monthly Total (1,016,457.00) Budgeted (962,624.44) Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,150.00 Budgeted 2,150.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 283,508.00 Budgeted 283,508.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 725,000.00 Budgeted 725,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 1,010,658.00 Budgeted 1,010,658.00 Remaining 0 % Used Fund 533 Totals: ----------------------------------- (53,832.56) (38,137.38) Monthly Total (5,799.00) Budgeted 48,033.56 Remaining 928 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET NOVEMBER 2017 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 125,153 ACCOUNTS RECEIVABLE - TOTAL ASSETS 125,153 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 108,943 TOTAL FUND BALANCE 125,153 TOTAL LIABILITIES AND FUND BALANCE 125,153 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 17:30 12/13/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/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- 65.79- 81.60- 8.160 918.40- 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 108,861.44- 18.182 489,876.56- Subtotal: 599,738.00- 599,738.00- 54,496.51- 108,943.04- 18.165 490,794.96- Program number: 599,738.00- 599,738.00- 54,496.51- 108,943.04- 18.165 490,794.96- Department number: Revenues 599,738.00- 599,738.00- 54,496.51- 108,943.04- 18.165 490,794.96- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,496.51- 108,943.04- 18.165 490,794.96- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 17:30 12/13/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/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,496.51- 108,943.04- ############### 107,943.04 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 423 11/30/2017 November Bank Interest (15.81) (65.79) (81.60) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (65.79) (81.60) ** (1,000.00) Budgeted (918.40) Remaining 8 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 333 11/28/2017 Texpool transfers (54,430.72) (54,430.72) (108,861.44) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (108,861.44) ** (598,738.00) Budgeted (489,876.56) Remaining 18 % Used Department Totals: ----------------------------------- (108,943.04) ** (54,496.51) Monthly Total (599,738.00) Budgeted (490,794.96) Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee .00 .00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 223,338.00 Budgeted 223,338.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 375,000.00 Budgeted 375,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 598,738.00 Budgeted 598,738.00 Remaining 0 % Used Fund 534 Totals: ----------------------------------- (108,943.04) (54,496.51) Monthly Total (1,000.00) Budgeted 107,943.04 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET NOVEMBER 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 51,539 ACCOUNTS RECEIVABLE - TOTAL ASSETS 51,539 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 50,587 TOTAL FUND BALANCE 51,539 TOTAL LIABILITIES AND FUND BALANCE 51,539 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 17:30 12/13/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 11/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- 24.87- 26.52- 4.420 573.48- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 50,560.62- 18.182 227,523.38- Subtotal: 278,684.00- 278,684.00- 25,305.18- 50,587.14- 18.152 228,096.86- Program number: 278,684.00- 278,684.00- 25,305.18- 50,587.14- 18.152 228,096.86- Department number: Revenues 278,684.00- 278,684.00- 25,305.18- 50,587.14- 18.152 228,096.86- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,305.18- 50,587.14- 18.152 228,096.86- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 17:30 12/13/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 11/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,305.18- 50,587.14- 8,431.190 49,987.14 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 423 11/30/2017 November Bank Interest (1.65) (24.87) (26.52) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (24.87) (26.52) ** (600.00) Budgeted (573.48) Remaining 4 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 333 11/28/2017 Texpool transfers (25,280.31) (25,280.31) (50,560.62) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (50,560.62) ** (278,084.00) Budgeted (227,523.38) Remaining 18 % Used Department Totals: ----------------------------------- (50,587.14) ** (25,305.18) Monthly Total (278,684.00) Budgeted (228,096.86) Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 17:31 12/13/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 11/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee .00 .00 _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 62,684.00 Budgeted 62,684.00 Remaining 0 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 215,000.00 Budgeted 215,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 278,084.00 Budgeted 278,084.00 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (50,587.14) (25,305.18) Monthly Total (600.00) Budgeted 49,987.14 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (142,448.37) **** 90,683.94 Monthly Total (375,349.00) Budgeted (232,900.63) Remaining 38 % Used ******* End of Report *********