Loading...
HomeMy WebLinkAbout2018-10 October Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 278,787 PREPAID EXPENSES 16,403 ADVALOREM PROPERTY TAXES RECEIVABLE 1,117,393 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,412,583 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,117,392 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 1,117,392 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (248,693) TOTAL FUND BALANCE 295,191 TOTAL LIABILITIES AND FUND BALANCE 1,412,583 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 11:31 11/19/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 1,117,000.00- 1,117,000.00- 17,258.14- 17,258.14- 1.545 1,099,741.86- 122-40011-000-000 Property Taxes/Fire-Delinquent 274.03- 274.03- 274.03 122-40020-000-000 Property Taxes/Fire P&I 39.01- 39.01- 39.01 Subtotal: 1,117,000.00- 1,117,000.00- 17,571.18- 17,571.18- 1.573 1,099,428.82- 122-49035-000-000 Prior Year Reserves 75,000.00- 75,000.00- 75,000.00- Subtotal: 75,000.00- 75,000.00- 75,000.00- Program number: 1,192,000.00- 1,192,000.00- 17,571.18- 17,571.18- 1.474 1,174,428.82- Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 17,571.18- 17,571.18- 1.474 1,174,428.82- Revenues Subtotal ----------- 1,192,000.00- 1,192,000.00- 17,571.18- 17,571.18- 1.474 1,174,428.82- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 11:31 11/19/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 Rent And/Or Usage 215,979.00 215,979.00 215,979.00 122-60055-045-000 Insurance 18,000.00 18,000.00 1,491.21 1,491.21 8.285 16,508.79 122-60337-045-000 Transfer to Town/Fire Budget 56,204.00 56,204.00 56,204.00- Subtotal: 233,979.00 233,979.00 57,695.21 57,695.21 24.658 176,283.79 122-69005-045-000 Capital Outlays 75,000.00 75,000.00 75,000.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 127,148.60 100.000 .40 Subtotal: 283,569.00 283,569.00 208,568.60 208,568.60 73.551 75,000.40 Program number: 517,548.00 517,548.00 266,263.81 266,263.81 51.447 251,284.19 Department number: Fire 517,548.00 517,548.00 266,263.81 266,263.81 51.447 251,284.19 Expenditures Subtotal ----------- 517,548.00 517,548.00 266,263.81 266,263.81 51.447 251,284.19 Fund number: 122 Trophy Club MUD Fire Dept. 674,452.00- 674,452.00- 248,692.63 248,692.63 -36.873 923,144.63- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 172 10/01/2018 Property taxes (.40) (.40) GL 175 10/09/2018 Property Taxes (221.38) (221.78) GL 176 10/11/2018 Property Taxes (167.83) (389.61) GL 177 10/12/2018 Property Taxes (319.03) (708.64) GL 178 10/15/2018 Property Taxes (223.44) (932.08) GL 179 10/17/2018 Property Taxes (239.27) (1,171.35) GL 180 10/18/2018 Property Taxes (269.92) (1,441.27) GL 181 10/19/2018 Property Taxes (683.31) (2,124.58) GL 182 10/22/2018 Property Taxes (907.50) (3,032.08) GL 183 10/23/2018 Property Taxes (1,430.70) (4,462.78) GL 184 10/24/2018 Property Taxes (1,370.62) (5,833.40) GL 185 10/25/2018 Property Taxes (3,143.13) (8,976.53) GL 186 10/26/2018 Property Taxes (2,027.60) (11,004.13) GL 187 10/29/2018 Property Taxes (2,363.75) (13,367.88) GL 188 10/30/2018 Property Taxes (2,854.12) (16,222.00) GL 189 10/31/2018 Property Taxes (1,036.14) (17,258.14) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (17,258.14) (17,258.14) ** (1,117,000.00) Budgeted (1,099,741.86) Remaining 2 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 172 10/01/2018 Property taxes (80.01) (80.01) GL 174 10/05/2018 Property Taxes (21.10) (101.11) GL 175 10/09/2018 Property Taxes 15.26 (85.85) GL 180 10/18/2018 Property Taxes (60.61) (146.46) GL 182 10/22/2018 Property Taxes (122.89) (269.35) GL 189 10/31/2018 Property Taxes (4.68) (274.03) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (274.03) (274.03) ** .00 Budgeted 274.03 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 172 10/01/2018 Property taxes (11.84) (11.84) GL 174 10/05/2018 Property Taxes (2.46) (14.30) GL 180 10/18/2018 Property Taxes (5.45) (19.75) GL 182 10/22/2018 Property Taxes (12.51) (32.26) GL 186 10/26/2018 Property Taxes (2.18) (34.44) GL 189 10/31/2018 Property Taxes (4.57) (39.01) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (39.01) (39.01) ** .00 Budgeted 39.01 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (75,000.00) Budgeted (75,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (17,571.18) ** (17,571.18) Monthly Total (1,192,000.00) Budgeted (1,174,428.82) Remaining 1 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 215,979.00 Budgeted 215,979.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 125 10/01/2018 Insurance/Wrk Comp Expense Oct 1,491.21 1,491.21 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,491.21 1,491.21 ** 18,000.00 Budgeted 16,508.79 Remaining 8 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 21 10/05/2018 October A/P October Fire admin 56,204.00 56,204.00 TOWN OF TROPHY CLUB 4649 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 56,204.00 56,204.00 ** .00 Budgeted (56,204.00) Remaining 0 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 75,000.00 Budgeted 75,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 117 10/01/2018 GASB 34 transfers FY 2019 Fire Truck Future Replacement 81,420.00 81,420.00 GL _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 42 10/10/2018 October A/P Lease payment FD ladder- T681 127,148.60 127,148.60 PNC Bank, N.A. 4656 AP _______________ Account: 122-69305-045-000 Capital Leases Totals: 127,148.60 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 266,263.81 ** 266,263.81 Monthly Total 517,548.00 Budgeted 251,284.19 Remaining 51 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ----------------------------------- 248,692.63 248,692.63 Monthly Total (674,452.00) Budgeted (923,144.63) Remaining -37 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET OCTOBER 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 2,094,039 - 2,094,039 CASH IN BANK-SAVINGS-CASH RESERVE 983,515 - 983,515 INVESTMENTS-TEXPOOL 2,904,623 782,846 3,687,469 PREPAID EXPENSES 97,515 - 97,515 ADVALOREM PROPERTY TAXES RECEIVABLE 127,124 - 127,124 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,227,397 - 1,227,397 TOTAL ASSETS 7,434,813 782,846 8,217,659 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 127,124 - 127,124 ACCOUNTS AND OTHER PAYABLES 470,667 - 470,667 CUSTOMER DEPOSITS 311,465 - 311,465 - TOTAL LIABILITIES 909,256 - 909,256 FUND BALANCE NON-SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 1,906,543 1,906,543 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 225,000 225,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 150,000 150,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 97,805 97,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 310,041 310,041 UNASSIGNED FUND BALANCE 4,594,239 - 4,594,239 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 16,289 - 16,289 - TOTAL FUND BALANCE 6,525,557 782,846 7,308,403 TOTAL LIABILITIES AND FUND BALANCE 7,434,813 782,846 8,217,659 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 132,384.00- 132,384.00- 1,964.94- 1,964.94- 1.484 130,419.06- 135-40002-000-000 Property Taxes/Delinquent 300.00- 300.00- 31.11- 31.11- 10.370 268.89- 135-40015-000-000 Property Taxes/P & I 300.00- 300.00- 4.23- 4.23- 1.410 295.77- 135-40025-000-000 PID Surcharges 171,983.00- 171,983.00- 171,983.00- Subtotal: 304,967.00- 304,967.00- 2,000.28- 2,000.28- .656 302,966.72- 135-47000-000-000 Water 6,599,484.00- 6,599,484.00- 353,428.58- 353,428.58- 5.355 6,246,055.42- 135-47005-000-000 Sewer 3,412,665.00- 3,412,665.00- 257,430.59- 257,430.59- 7.543 3,155,234.41- 135-47025-000-000 Penalties 136,418.00- 136,418.00- 9,876.08- 9,876.08- 7.240 126,541.92- 135-47030-000-000 Service Charges 17,000.00- 17,000.00- 1,425.00- 1,425.00- 8.382 15,575.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 1,500.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 4,500.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 17.60- 17.60- .029 59,982.40- Subtotal: 10,231,567.00- 10,231,567.00- 622,177.85- 622,177.85- 6.081 9,609,389.15- 135-49010-000-000 Interest Income 20,000.00- 20,000.00- 8,671.04- 8,671.04- 43.355 11,328.96- 135-49016-000-000 Cell Tower Revenue 14,146.00- 14,146.00- 1,505.48- 1,505.48- 10.642 12,640.52- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67- 135-49026-000-000 Proceeds from Sale of Assets 10,000.00- 10,000.00- 10,000.00- 135-49075-000-000 Oversize Meter Reimbursement 18,522.00- 18,522.00- 18,522.00- 135-49900-000-000 Miscellaneous Income 7,000.00- 7,000.00- 485.26- 485.26- 6.932 6,514.74- Subtotal: 76,668.00- 76,668.00- 11,245.11- 11,245.11- 14.667 65,422.89- Program number: 10,613,202.00- 10,613,202.00- 635,423.24- 635,423.24- 5.987 9,977,778.76- Department number: Revenues 10,613,202.00- 10,613,202.00- 635,423.24- 635,423.24- 5.987 9,977,778.76- Revenues Subtotal ----------- 10,613,202.00- 10,613,202.00- 635,423.24- 635,423.24- 5.987 9,977,778.76- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 326,755.00 326,755.00 11,375.95 11,375.95 3.481 315,379.05 135-50010-010-000 Overtime 20,000.00 20,000.00 565.62 565.62 2.828 19,434.38 135-50016-010-000 Longevity 3,620.00 3,620.00 3,620.00 135-50017-010-000 Certification 4,800.00 4,800.00 200.00 200.00 4.167 4,600.00 135-50020-010-000 Retirement 33,304.00 33,304.00 2,174.42 2,174.42 6.529 31,129.58 135-50026-010-000 Medical Insurance 74,818.00 74,818.00 2,948.80 2,948.80 3.941 71,869.20 135-50027-010-000 Dental Insurance 4,317.00 4,317.00 213.65 213.65 4.949 4,103.35 135-50028-010-000 Vision Insurance 701.00 701.00 35.92 35.92 5.124 665.08 135-50029-010-000 Life Insurance & Other 3,131.00 3,131.00 197.61 197.61 6.311 2,933.39 135-50030-010-000 Social Security Taxes 22,021.00 22,021.00 741.36 741.36 3.367 21,279.64 135-50035-010-000 Medicare Taxes 5,150.00 5,150.00 173.37 173.37 3.366 4,976.63 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 12,895.00 12,895.00 930.94 930.94 7.219 11,964.06 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 513,092.00 513,092.00 19,557.64 19,557.64 3.812 493,534.36 135-55005-010-000 Engineering 20,000.00 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 4,431.38 4,431.38 4.431 95,568.62 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 723.46 723.46 14.469 4,276.54 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55120-010-000 Cleaning Services 5,214.00 5,214.00 5,214.00 135-55135-010-000 Lab Analysis 6,500.00 6,500.00 407.70 407.70 6.272 6,092.30 Subtotal: 143,214.00 143,214.00 5,562.54 5,562.54 3.884 137,651.46 135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00 370.98 370.98 7.420 4,629.02 135-60020-010-000 Electricity 154,204.00 154,204.00 18,928.67 18,928.67 12.275 135,275.33 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 4,651.00 4,651.00 120.00 120.00 2.580 4,531.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 2,345.00 2,345.00 2,345.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 58,000.00 58,000.00 58,000.00 135-60150-010-000 Wholesale Water 3,013,494.00 3,013,494.00 3,013,494.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 3,000.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,340.00 1,340.00 9.085 13,410.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 585,209.00 585,209.00 25,172.81 25,172.81 4.302 560,036.19 135-60333-010-000 Interfund Transfer Out-Reserve 55,193.00 55,193.00 4,600.00 4,600.00 8.334 50,593.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 4,101,946.00 4,101,946.00 50,532.46 50,532.46 1.232 4,051,413.54 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 643.17 643.17 4.288 14,356.83 135-65010-010-000 Uniforms 5,190.00 5,190.00 5,190.00 135-65030-010-000 Chemicals 20,000.00 20,000.00 2,724.11 2,724.11 13.621 17,275.89 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 70,000.00 70,000.00 70,000.00 135-65053-010-000 Meter Change Out Program 87,000.00 87,000.00 87,000.00 Subtotal: 199,390.00 199,390.00 3,367.28 3,367.28 1.689 196,022.72 135-69005-010-000 Capital Outlays 453,000.00 453,000.00 18,533.35 18,533.35 4.091 434,466.65 135-69008-010-000 Short Term Debt-Principal 30,068.00 30,068.00 30,068.00 135-69009-010-000 Short Term Debt-Interest 4,124.00 4,124.00 4,124.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 120,000.00 120,000.00 120,000.00 Subtotal: 682,192.00 682,192.00 93,533.35 93,533.35 13.711 588,658.65 Program number: 5,639,834.00 5,639,834.00 172,553.27 172,553.27 3.060 5,467,280.73 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 287.70 287.70 14.385 1,712.30 Subtotal: 2,000.00 2,000.00 287.70 287.70 14.385 1,712.30 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 287.70 287.70 14.385 1,712.30 Department number: Water 5,641,834.00 5,641,834.00 172,840.97 172,840.97 3.064 5,468,993.03 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 421,699.00 421,699.00 13,037.12 13,037.12 3.092 408,661.88 135-50010-020-000 Overtime 30,000.00 30,000.00 987.41 987.41 3.291 29,012.59 135-50016-020-000 Longevity 7,445.00 7,445.00 7,445.00 135-50017-020-000 Certification 8,700.00 8,700.00 700.00 700.00 8.046 8,000.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,878.72 2,878.72 6.652 40,397.28 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,510.24 5,510.24 6.014 86,116.76 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 371.89 371.89 7.286 4,732.11 135-50028-020-000 Vision Insurance 826.00 826.00 58.90 58.90 7.131 767.10 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 285.20 285.20 6.345 4,209.80 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 821.24 821.24 2.831 28,184.76 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 192.07 192.07 2.831 6,591.93 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 1,205.73 7.117 15,735.27 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 667,863.00 667,863.00 26,048.52 26,048.52 3.900 641,814.48 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 3,310.21 3,310.21 3.762 84,689.79 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 46.48 46.48 .581 7,953.52 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,500.00 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 5,214.00 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 4,494.98 4,494.98 5.993 70,505.02 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 4,627.46 4,627.46 13.221 30,372.54 Subtotal: 267,714.00 267,714.00 12,479.13 12,479.13 4.661 255,234.87 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 382.49 382.49 7.650 4,617.51 135-60020-020-000 Electricity 174,165.00 174,165.00 24,917.76 24,917.76 14.307 149,247.24 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 69.00 69.00 23.000 231.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 111.00 111.00 1.551 7,044.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 1,895.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 30,000.00 30,000.00 16,345.22 16,345.22 54.484 13,654.78 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 6.98 6.98 .140 4,993.02 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 11,600.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,053.00 120,053.00 10,913.90 10,913.90 9.091 109,139.10 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60332-020-000 Interfund Transfer Out-Rev I&S 688,330.00 688,330.00 54,203.45 54,203.45 7.875 634,126.55 135-60333-020-000 Interfund Transfer Out-Reserve 125,187.00 125,187.00 10,432.00 10,432.00 8.333 114,755.00 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 122,777.00 122,777.00 61.389 77,223.00 135-60360-020-000 Furniture/Equipment < $5000 3,500.00 3,500.00 3,500.00 Subtotal: 1,381,335.00 1,381,335.00 240,158.80 240,158.80 17.386 1,141,176.20 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 1,336.58 1,336.58 10.693 11,163.42 135-65010-020-000 Uniforms 5,495.00 5,495.00 1,035.41 1,035.41 18.843 4,459.59 135-65030-020-000 Chemicals 30,000.00 30,000.00 536.00 536.00 1.787 29,464.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 181.32 181.32 15.110 1,018.68 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 733.07 733.07 3.665 19,266.93 Subtotal: 70,395.00 70,395.00 3,822.38 3,822.38 5.430 66,572.62 135-69005-020-000 Capital Outlays 330,000.00 330,000.00 2,589.58 2,589.58 .785 327,410.42 135-69008-020-000 Short Term Debt-Principal 109,858.00 109,858.00 109,858.00 135-69009-020-000 Short Term Debt-Interest 14,917.00 14,917.00 14,917.00 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 484,775.00 484,775.00 32,589.58 32,589.58 6.723 452,185.42 Program number: 2,872,082.00 2,872,082.00 315,098.41 315,098.41 10.971 2,556,983.59 Department number: Wastewater 2,872,082.00 2,872,082.00 315,098.41 315,098.41 10.971 2,556,983.59 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 30.00 30.00 2.12 2.12 7.067 27.88 Subtotal: 30.00 30.00 2.12 2.12 7.067 27.88 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 750.00 750.00 750.00 135-60075-026-000 Meetings 1,300.00 1,300.00 1,300.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 295.00 295.00 7.375 3,705.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: 13,200.00 13,200.00 295.00 295.00 2.235 12,905.00 Program number: 13,230.00 13,230.00 297.12 297.12 2.246 12,932.88 Department number: Board of Directors 13,230.00 13,230.00 297.12 297.12 2.246 12,932.88 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 441,006.00 441,006.00 13,370.27 13,370.27 3.032 427,635.73 135-50010-030-000 Overtime 2,000.00 2,000.00 3.16 3.16 .158 1,996.84 135-50016-030-000 Longevity 1,833.00 1,833.00 1,833.00 135-50020-030-000 Retirement 41,148.00 41,148.00 2,597.25 2,597.25 6.312 38,550.75 135-50026-030-000 Medical Insurance 81,895.00 81,895.00 4,145.24 4,145.24 5.062 77,749.76 135-50027-030-000 Dental Insurance 4,291.00 4,291.00 259.52 259.52 6.048 4,031.48 135-50028-030-000 Vision Insurance 701.00 701.00 42.51 42.51 6.064 658.49 135-50029-030-000 Life Insurance & Other 4,495.00 4,495.00 264.49 264.49 5.884 4,230.51 135-50030-030-000 Social Security Taxes 27,580.00 27,580.00 788.49 788.49 2.859 26,791.51 135-50035-030-000 Medicare Taxes 6,450.00 6,450.00 184.40 184.40 2.859 6,265.60 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-030-000 Workman's Compensation 1,295.00 1,295.00 106.55 106.55 8.228 1,188.45 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 5,000.00 Subtotal: 619,454.00 619,454.00 21,761.88 21,761.88 3.513 597,692.12 135-55030-030-000 Software & Support 77,849.00 77,849.00 61,104.08 61,104.08 78.491 16,744.92 135-55070-030-000 Independent Labor 175,000.00 175,000.00 11,666.14 11,666.14 6.666 163,333.86 135-55080-030-000 Maintenance & Repairs 20,000.00 20,000.00 315.00 315.00 1.575 19,685.00 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 10,000.00 135-55160-030-000 Professional Outside Services 66,055.00 66,055.00 66,055.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 579.29 579.29 6.437 8,420.71 Subtotal: 367,904.00 367,904.00 73,664.51 73,664.51 20.023 294,239.49 135-60005-030-000 Telephone 23,500.00 23,500.00 1,423.08 1,423.08 6.056 22,076.92 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.49 237.49 5.937 3,762.51 135-60020-030-000 Electricity/Gas 8,690.00 8,690.00 557.71 557.71 6.418 8,132.29 135-60025-030-000 Water 2,000.00 2,000.00 48.39 48.39 2.420 1,951.61 135-60035-030-000 Postage 30,000.00 30,000.00 1,727.44 1,727.44 5.758 28,272.56 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 6,899.27 6,899.27 12.418 48,660.73 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 65,000.00 65,000.00 6,302.73 6,302.73 9.697 58,697.27 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 200.00 200.00 3.333 5,800.00 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 8,950.00 8,950.00 8,950.00 135-60100-030-000 Travel & per diem 4,345.00 4,345.00 4,345.00 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60125-030-000 Advertising 25,000.00 25,000.00 25,000.00 135-60235-030-000 Security 1,288.00 1,288.00 24.00 24.00 1.863 1,264.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 263,433.00 263,433.00 17,420.11 17,420.11 6.613 246,012.89 135-65010-030-000 Uniforms 2,050.00 2,050.00 2,050.00 135-65055-030-000 Hardware 7,064.00 7,064.00 7,064.00 135-65085-030-000 Office Supplies 6,000.00 6,000.00 474.06 474.06 7.901 5,525.94 135-65090-030-000 Printer Supplies & Maintenance 3,500.00 3,500.00 3,500.00 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 444.04 444.04 11.101 3,555.96 135-65105-030-000 Printing 2,500.00 2,500.00 2,500.00 Subtotal: 25,114.00 25,114.00 918.10 918.10 3.656 24,195.90 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 280,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 293.89 293.89 7.347 3,706.11 Subtotal: 284,000.00 284,000.00 293.89 293.89 .103 283,706.11 Program number: 1,559,905.00 1,559,905.00 114,058.49 114,058.49 7.312 1,445,846.51 Department number: Administration 1,559,905.00 1,559,905.00 114,058.49 114,058.49 7.312 1,445,846.51 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 137,000.00 11,839.68 11,839.68 8.642 125,160.32 135-55055-039-000 Auditing 30,800.00 30,800.00 5,000.00 5,000.00 16.234 25,800.00 135-55060-039-000 Appraisal 11,714.00 11,714.00 11,714.00 135-55065-039-000 Tax Admin Fees 4,800.00 4,800.00 4,800.00 Subtotal: 184,314.00 184,314.00 16,839.68 16,839.68 9.136 167,474.32 Program number: 184,314.00 184,314.00 16,839.68 16,839.68 9.136 167,474.32 Department number: Non Departmental 184,314.00 184,314.00 16,839.68 16,839.68 9.136 167,474.32 Expenditures Subtotal ----------- 10,271,365.00 10,271,365.00 619,134.67 619,134.67 6.028 9,652,230.33 Fund number: 135 MUD 1 General Fund 341,837.00- 341,837.00- 16,288.57- 16,288.57- 4.765 325,548.43- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 11:31 11/19/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00- 186,420.00 Revenues Subtotal ----------- 186,420.00- 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00- 186,420.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 172 10/01/2018 Property taxes (.05) (.05) GL 175 10/09/2018 Property Taxes (25.20) (25.25) GL 176 10/11/2018 Property Taxes (19.11) (44.36) GL 177 10/12/2018 Property Taxes (36.32) (80.68) GL 178 10/15/2018 Property Taxes (25.44) (106.12) GL 179 10/17/2018 Property Taxes (27.24) (133.36) GL 180 10/18/2018 Property Taxes (30.73) (164.09) GL 181 10/19/2018 Property Taxes (77.80) (241.89) GL 182 10/22/2018 Property Taxes (103.33) (345.22) GL 183 10/23/2018 Property Taxes (162.89) (508.11) GL 184 10/24/2018 Property Taxes (156.05) (664.16) GL 185 10/25/2018 Property Taxes (357.86) (1,022.02) GL 186 10/26/2018 Property Taxes (230.86) (1,252.88) GL 187 10/29/2018 Property Taxes (269.13) (1,522.01) GL 188 10/30/2018 Property Taxes (324.96) (1,846.97) GL 189 10/31/2018 Property Taxes (117.97) (1,964.94) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (1,964.94) (1,964.94) ** (132,384.00) Budgeted (130,419.06) Remaining 1 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 172 10/01/2018 Property taxes (8.91) (8.91) GL 174 10/05/2018 Property Taxes (2.42) (11.33) GL 175 10/09/2018 Property Taxes 1.74 (9.59) GL 180 10/18/2018 Property Taxes (6.95) (16.54) GL 182 10/22/2018 Property Taxes (14.10) (30.64) GL 189 10/31/2018 Property Taxes (.47) (31.11) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (31.11) (31.11) ** (300.00) Budgeted (268.89) Remaining 10 % Used Account: 135-40015-000-000 Property Taxes/P & I 172 10/01/2018 Property taxes (1.25) (1.25) GL 173 10/03/2018 Property Taxes .07 (1.18) GL 174 10/05/2018 Property Taxes (.28) (1.46) GL 180 10/18/2018 Property Taxes (.63) (2.09) GL 182 10/22/2018 Property Taxes (1.43) (3.52) GL 186 10/26/2018 Property Taxes (.24) (3.76) GL 189 10/31/2018 Property Taxes (.47) (4.23) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (4.23) (4.23) ** (300.00) Budgeted (295.77) Remaining 1 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (171,983.00) Budgeted (171,983.00) Remaining 0 % Used Account: 135-47000-000-000 Water 163 10/08/2018 UB 10/08/2018 WT Adjustment UB20181008-20181008 User: 369.17 369.17 UB 164 10/31/2018 UB 10/31/2018 Billing UB20181031-20181031 User: (353,797.75) (353,428.58) UB _______________ Account: 135-47000-000-000 Water Totals: (353,428.58) (353,428.58) ** (6,599,484.00) Budgeted (6,246,055.42) Remaining 5 % Used Account: 135-47005-000-000 Sewer 164 10/31/2018 UB 10/31/2018 Billing UB20181031-20181031 User: (257,430.59) (257,430.59) UB _______________ Account: 135-47005-000-000 Sewer Totals: (257,430.59) (257,430.59) ** (3,412,665.00) Budgeted (3,155,234.41) Remaining 8 % Used Account: 135-47025-000-000 Penalties 14 10/03/2018 UB 10/03/2018 Penalty removal UB20181003-20181003 User: 302.07 302.07 UB 36 10/09/2018 UB 10/09/2018 Penalty removal UB20181009-20181009 User: 31.91 333.98 UB 72 10/17/2018 UB 10/17/2018 Penalty removal UB20181017-20181017 User: 57.78 391.76 UB 95 10/23/2018 UB 10/23/2018 Penalties UB20181023-20181023 User: (10,527.78) (10,136.02) UB 138 10/30/2018 UB 10/30/2018 Penalty removal UB20181030-20181030 User: 199.12 (9,936.90) UB 142 10/30/2018 UB 10/30/2018 Penalty removal UB20181030-20181030 User: 18.33 (9,918.57) UB 153 10/31/2018 UB 10/31/2018 Penalty removal UB20181031-20181031 User: 42.49 (9,876.08) UB _______________ Account: 135-47025-000-000 Penalties Totals: (9,876.08) (9,876.08) ** (136,418.00) Budgeted (126,541.92) Remaining 7 % Used Account: 135-47030-000-000 Service Charges 35 10/09/2018 UB 10/09/2018 Disconnect Fees UB20181009-20181009 User: (1,500.00) (1,500.00) UB 36 10/09/2018 UB 10/09/2018 Penalty removal UB20181009-20181009 User: 150.00 (1,350.00) UB . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 79 10/12/2018 UB 10/12/2018 NSF check UB20181012-20181012 User: (25.00) (1,375.00) UB 123 10/22/2018 UB 10/22/2018 NSF check UB20181022-20181022 User: (25.00) (1,400.00) UB 94 10/23/2018 UB 10/23/2018 NSF check UB20181023-20181023 User: (25.00) (1,425.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,425.00) (1,425.00) ** (17,000.00) Budgeted (15,575.00) Remaining 8 % Used Account: 135-47035-000-000 Plumbing Inspections .00 .00 _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 .00 ** (1,500.00) Budgeted (1,500.00) Remaining 0 % Used Account: 135-47045-000-000 Sewer Inspections .00 .00 _______________ Account: 135-47045-000-000 Sewer Inspections Totals: .00 .00 ** (4,500.00) Budgeted (4,500.00) Remaining 0 % Used Account: 135-47070-000-000 TCCC Effluent Charges 164 10/31/2018 UB 10/31/2018 Billing UB20181031-20181031 User: (17.60) (17.60) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (17.60) (17.60) ** (60,000.00) Budgeted (59,982.40) Remaining 0 % Used Account: 135-49010-000-000 Interest Income 165 10/31/2018 Bank Interest- October (746.77) (746.77) GL 165 10/31/2018 Bank Interest- October (7,924.27) (8,671.04) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (8,671.04) (8,671.04) ** (20,000.00) Budgeted (11,328.96) Remaining 43 % Used Account: 135-49016-000-000 Cell Tower Revenue 157 10/15/2018 Cell Tower Rev AT&T October (1,178.81) (1,178.81) GL 158 10/15/2018 Cell Tower Rev AT&T Oct Supp (326.67) (1,505.48) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,505.48) (1,505.48) ** (14,146.00) Budgeted (12,640.52) Remaining 11 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49018-000-000 Building Rent Income 203 10/31/2018 Town Billed Invoices 1660-1663 AR 20181031-20181031 User: (583.33) (583.33) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (583.33) ** (7,000.00) Budgeted (6,416.67) Remaining 8 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement .00 .00 _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 .00 ** (18,522.00) Budgeted (18,522.00) Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 199 10/15/2018 Recycling of Scrap Metal Sell/recycle of scrap metal (196.65) (196.65) GL 164 10/31/2018 UB 10/31/2018 Billing UB20181031-20181031 User: (288.61) (485.26) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (485.26) (485.26) ** (7,000.00) Budgeted (6,514.74) Remaining 7 % Used Department Totals: ----------------------------------- (635,423.24) ** (635,423.24) Monthly Total (10,613,202.00) Budgeted (9,977,778.76) Remaining 6 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 44 10/05/2018 MUD P/R 10/05/2018 Salaries & Wages 11,027.60 11,027.60 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Salaries & Wages (11,027.60) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Salaries & Wages 11,027.60 11,027.60 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (11,027.60) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Salaries & Wages 11,413.57 11,413.57 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (37.62) 11,375.95 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 11,375.95 11,375.95 ** 326,755.00 Budgeted 315,379.05 Remaining 3 % Used Account: 135-50010-010-000 Overtime 44 10/05/2018 MUD P/R 10/05/2018 Overtime 300.45 300.45 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Overtime (300.45) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Overtime 300.45 300.45 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (300.45) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Overtime 565.62 565.62 PR _______________ Account: 135-50010-010-000 Overtime Totals: 565.62 565.62 ** 20,000.00 Budgeted 19,434.38 Remaining 3 % Used Account: 135-50016-010-000 Longevity .00 .00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 .00 ** 3,620.00 Budgeted 3,620.00 Remaining 0 % Used Account: 135-50017-010-000 Certification 67 10/19/2018 MUD Payroll 10/19/2018 Certification 200.00 200.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 200.00 ** 4,800.00 Budgeted 4,600.00 Remaining 4 % Used Account: 135-50020-010-000 Retirement 44 10/05/2018 MUD P/R 10/05/2018 Retirement 1,047.84 1,047.84 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Retirement (1,047.84) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Retirement 1,047.84 1,047.84 PR 67 10/19/2018 MUD Payroll 10/19/2018 Retirement 1,126.58 2,174.42 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50020-010-000 Retirement Totals: 2,174.42 2,174.42 ** 33,304.00 Budgeted 31,129.58 Remaining 7 % Used Account: 135-50026-010-000 Medical Insurance 44 10/05/2018 MUD P/R 10/05/2018 Medical Insurance 1,474.40 1,474.40 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medical Insurance (1,474.40) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medical Insurance 1,474.40 1,474.40 PR 67 10/19/2018 MUD Payroll 10/19/2018 Medical Insurance 1,474.40 2,948.80 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 2,948.80 ** 74,818.00 Budgeted 71,869.20 Remaining 4 % Used Account: 135-50027-010-000 Dental Insurance 44 10/05/2018 MUD P/R 10/05/2018 Dental Insurance 106.85 106.85 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Dental Insurance (106.85) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Dental Insurance 106.85 106.85 PR 67 10/19/2018 MUD Payroll 10/19/2018 Dental Insurance 106.80 213.65 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 213.65 ** 4,317.00 Budgeted 4,103.35 Remaining 5 % Used Account: 135-50028-010-000 Vision Insurance 44 10/05/2018 MUD P/R 10/05/2018 Vision Insurance 17.98 17.98 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Vision Insurance (17.98) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Vision Insurance 17.98 17.98 PR 67 10/19/2018 MUD Payroll 10/19/2018 Vision Insurance 17.94 35.92 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 35.92 ** 701.00 Budgeted 665.08 Remaining 5 % Used Account: 135-50029-010-000 Life Insurance & Other 2 10/01/2018 October A/P 110.60 110.60 Humana Inc 4572 AP 4 10/01/2018 October A/P 87.01 197.61 METLIFE GROUP BENEFITS 4601 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 197.61 197.61 ** 3,131.00 Budgeted 2,933.39 Remaining 6 % Used Account: 135-50030-010-000 Social Security Taxes . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 44 10/05/2018 MUD P/R 10/05/2018 Social Security Taxes 703.88 703.88 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Social Security Taxes (703.88) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Social Security Taxes 703.88 703.88 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (703.88) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Social Security Taxes 743.69 743.69 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (2.33) 741.36 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 741.36 741.36 ** 22,021.00 Budgeted 21,279.64 Remaining 3 % Used Account: 135-50035-010-000 Medicare Taxes 44 10/05/2018 MUD P/R 10/05/2018 Medicare Taxes 164.61 164.61 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medicare Taxes (164.61) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medicare Taxes 164.61 164.61 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (164.61) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Medicare Taxes 173.92 173.92 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (.55) 173.37 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 173.37 173.37 ** 5,150.00 Budgeted 4,976.63 Remaining 3 % Used Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 1,080.00 Budgeted 1,080.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 125 10/01/2018 Insurance/Wrk Comp Expense Oct 930.94 930.94 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 930.94 930.94 ** 12,895.00 Budgeted 11,964.06 Remaining 7 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50070-010-000 Employee Relations .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 96 10/23/2018 October A/P UFD check 372.00 372.00 SES Group, LLC 4689 AP 96 10/23/2018 October A/P Prts 162.00 534.00 Core & Main LP 4672 AP 96 10/23/2018 October A/P Parts 373.20 907.20 Core & Main LP 4672 AP 114 10/26/2018 October A/P Mater boxes 1,443.12 2,350.32 Core & Main LP 4672 AP 114 10/26/2018 October A/P Repair clamps 256.78 2,607.10 Core & Main LP 4672 AP 121 10/26/2018 Pcards 09/27/18 - 10/26/18 USA BLUE BOOK 240.41 2,847.51 USA BLUE BOOK PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMAZON.COM*MT4F74YJ0 162.26 3,009.77 AMAZON.COM*MT4F74YJ0 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AQUA-METRIC SALES INC. 900.00 3,909.77 AQUA-METRIC SALES INC. PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 75.97 3,985.74 THE HOME DEPOT #6581 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 36.01 4,021.75 THE HOME DEPOT #6581 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 72.77 4,094.52 THE HOME DEPOT #6581 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 HOMEDEPOT.COM 58.92 4,153.44 HOMEDEPOT.COM PC 141 10/30/2018 October A/P De-clor tabs 277.94 4,431.38 Core & Main LP 4672 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 4,431.38 4,431.38 ** 100,000.00 Budgeted 95,568.62 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 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TX.GOV SERVICEFEE- 2.00 2.00 TX.GOV SERVICEFEE- PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 DENTON VEHREG 7.50 9.50 DENTON VEHREG PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ROANOKE AUTO SUPPLY LT 20.48 29.98 ROANOKE AUTO SUPPLY LT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ROANOKE AUTO SUPPLY LT 19.76 49.74 ROANOKE AUTO SUPPLY LT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 KWIK KAR LUBE & TUNE O 7.00 56.74 KWIK KAR LUBE & TUNE O PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 GIERISCH CARE 0050292 130.41 187.15 GIERISCH CARE 0050292 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 DISCOUNT TIRE TXD 75 196.50 383.65 DISCOUNT TIRE TXD 75 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 DISCOUNT TIRE TXD 75 179.76 563.41 DISCOUNT TIRE TXD 75 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 GIERISCH CARE 0050292 91.91 655.32 GIERISCH CARE 0050292 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 GIERISCH CARE 0050292 68.14 723.46 GIERISCH CARE 0050292 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 723.46 723.46 ** 5,000.00 Budgeted 4,276.54 Remaining 14 % 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-55120-010-000 Cleaning Services .00 .00 _______________ Account: 135-55120-010-000 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 217 10/31/2018 October A/P water samples 200.00 200.00 TARRANT CTY PUBLIC HEALTH LAB 4735 AP 217 10/31/2018 October A/P TCEQ samples 207.70 407.70 LOWER COLORADO RIVER AUTHORITY 4728 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 407.70 407.70 ** 6,500.00 Budgeted 6,092.30 Remaining 6 % Used Account: 135-60010-010-000 Communications/Mobiles 96 10/23/2018 October A/P Cell phones-October 370.98 370.98 VERIZON WIRELESS 4694 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 370.98 370.98 ** 5,000.00 Budgeted 4,629.02 Remaining 7 % Used Account: 135-60020-010-000 Electricity . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114 10/26/2018 October A/P Electricity-October 10,557.91 10,557.91 HUDSON ENERGY SERVICES, LLC 4680 AP 260 10/31/2018 October A/P Electricity 10/10-11/8 8,370.76 18,928.67 HUDSON ENERGY SERVICES, LLC 4751 AP _______________ Account: 135-60020-010-000 Electricity Totals: 18,928.67 18,928.67 ** 154,204.00 Budgeted 135,275.33 Remaining 12 % 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 121 10/26/2018 Pcards 09/27/18 - 10/26/18 NCTCOG RTC TRAINING (165.00) (165.00) NCTCOG RTC TRAINING PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 NCTCOG RTC TRAINING (165.00) (330.00) NCTCOG RTC TRAINING PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 PAYPAL *PROLINEPUBL 100.00 (230.00) PAYPAL *PROLINEPUBL PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 PAYPAL *TEXASWATERW 350.00 120.00 PAYPAL *TEXASWATERW PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 120.00 120.00 ** 4,651.00 Budgeted 4,531.00 Remaining 3 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem .00 .00 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 2,345.00 Budgeted 2,345.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-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 .00 .00 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 .00 ** 58,000.00 Budgeted 58,000.00 Remaining 0 % Used Account: 135-60150-010-000 Wholesale Water .00 .00 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 .00 ** 3,013,494.00 Budgeted 3,013,494.00 Remaining 0 % 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 .00 .00 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 217 10/31/2018 October A/P October mowing 750.00 750.00 WATTS ELLISON LLC 4741 AP 217 10/31/2018 October A/P October mowing 590.00 1,340.00 WATTS ELLISON LLC 4741 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,340.00 1,340.00 ** 14,750.00 Budgeted 13,410.00 Remaining 9 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 160 10/31/2018 Texpool Transfers October 25,172.81 25,172.81 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,172.81 25,172.81 ** 585,209.00 Budgeted 560,036.19 Remaining 4 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 160 10/31/2018 Texpool Transfers October 4,600.00 4,600.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,600.00 4,600.00 ** 55,193.00 Budgeted 50,593.00 Remaining 8 % 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 114 10/26/2018 October A/P Fuel-October 643.17 643.17 US Bank Voyager Fleet Systems 4693 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 643.17 643.17 ** 15,000.00 Budgeted 14,356.83 Remaining 4 % Used Account: 135-65010-010-000 Uniforms .00 .00 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 .00 ** 5,190.00 Budgeted 5,190.00 Remaining 0 % Used Account: 135-65030-010-000 Chemicals 96 10/23/2018 October A/P Chemicals 908.30 908.30 HACH COMPANY 4678 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114 10/26/2018 October A/P Chlorine 558.41 1,466.71 DPC INDUSTRIES, INC 4675 AP 141 10/30/2018 October A/P lab supplies 91.80 1,558.51 HACH COMPANY 4678 AP 217 10/31/2018 October A/P Testing supplies 1,165.60 2,724.11 HACH COMPANY 4718 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 2,724.11 2,724.11 ** 20,000.00 Budgeted 17,275.89 Remaining 14 % 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 ** 70,000.00 Budgeted 70,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 ** 87,000.00 Budgeted 87,000.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays 254 10/31/2018 October A/P 16" water line phase II 18,400.85 18,400.85 Halff Associates, INC 4750 AP 254 10/31/2018 October A/P 16" water line bond app fee 132.50 18,533.35 CP&Y/WALLACE GROUP, INC. 4747 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 18,533.35 18,533.35 ** 453,000.00 Budgeted 434,466.65 Remaining 4 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 30,068.00 Budgeted 30,068.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 ** 4,124.00 Budgeted 4,124.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 117 10/01/2018 GASB 34 transfers FY 2019 Town Elevated Tank 45,000.00 45,000.00 GL 117 10/01/2018 GASB 34 transfers FY 2019 Water Replacement 30,000.00 75,000.00 GL _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract .00 .00 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 .00 ** 120,000.00 Budgeted 120,000.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 254 10/31/2018 October A/P TCEQ samples 207.70 207.70 LOWER COLORADO RIVER AUTHORITY 4757 AP 217 10/31/2018 October A/P Water samples-PID 80.00 287.70 TARRANT CTY PUBLIC HEALTH LAB 4735 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 287.70 287.70 ** 2,000.00 Budgeted 1,712.30 Remaining 14 % Used Department 10 Totals: ----------------------------------- 172,840.97 ** 172,840.97 Monthly Total 5,641,834.00 Budgeted 5,468,993.03 Remaining 3 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 44 10/05/2018 MUD P/R 10/05/2018 Salaries & Wages 12,608.29 12,608.29 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Salaries & Wages (12,608.29) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Salaries & Wages 12,608.29 12,608.29 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (12,608.29) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Salaries & Wages 13,158.97 13,158.97 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (121.85) 13,037.12 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 13,037.12 13,037.12 ** 421,699.00 Budgeted 408,661.88 Remaining 3 % Used Account: 135-50010-020-000 Overtime 44 10/05/2018 MUD P/R 10/05/2018 Overtime 3,666.56 3,666.56 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Overtime (3,666.56) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Overtime 3,666.56 3,666.56 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (3,666.56) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Overtime 987.41 987.41 PR _______________ Account: 135-50010-020-000 Overtime Totals: 987.41 987.41 ** 30,000.00 Budgeted 29,012.59 Remaining 3 % Used Account: 135-50016-020-000 Longevity .00 .00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 .00 ** 7,445.00 Budgeted 7,445.00 Remaining 0 % Used Account: 135-50017-020-000 Certification 67 10/19/2018 MUD Payroll 10/19/2018 Certification 700.00 700.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 700.00 ** 8,700.00 Budgeted 8,000.00 Remaining 8 % Used Account: 135-50020-020-000 Retirement 44 10/05/2018 MUD P/R 10/05/2018 Retirement 1,505.42 1,505.42 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Retirement (1,505.42) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Retirement 1,505.42 1,505.42 PR 67 10/19/2018 MUD Payroll 10/19/2018 Retirement 1,373.30 2,878.72 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50020-020-000 Retirement Totals: 2,878.72 2,878.72 ** 43,276.00 Budgeted 40,397.28 Remaining 7 % Used Account: 135-50026-020-000 Medical Insurance 44 10/05/2018 MUD P/R 10/05/2018 Medical Insurance 2,607.69 2,607.69 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medical Insurance (2,607.69) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medical Insurance 2,607.69 2,607.69 PR 67 10/19/2018 MUD Payroll 10/19/2018 Medical Insurance 2,902.55 5,510.24 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,510.24 5,510.24 ** 91,627.00 Budgeted 86,116.76 Remaining 6 % Used Account: 135-50027-020-000 Dental Insurance 44 10/05/2018 MUD P/R 10/05/2018 Dental Insurance 185.96 185.96 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Dental Insurance (185.96) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Dental Insurance 185.96 185.96 PR 67 10/19/2018 MUD Payroll 10/19/2018 Dental Insurance 185.93 371.89 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 371.89 ** 5,104.00 Budgeted 4,732.11 Remaining 7 % Used Account: 135-50028-020-000 Vision Insurance 44 10/05/2018 MUD P/R 10/05/2018 Vision Insurance 29.46 29.46 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Vision Insurance (29.46) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Vision Insurance 29.46 29.46 PR 67 10/19/2018 MUD Payroll 10/19/2018 Vision Insurance 29.44 58.90 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 58.90 ** 826.00 Budgeted 767.10 Remaining 7 % Used Account: 135-50029-020-000 Life Insurance & Other 2 10/01/2018 October A/P 164.36 164.36 Humana Inc 4572 AP 4 10/01/2018 October A/P 120.84 285.20 METLIFE GROUP BENEFITS 4601 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 285.20 285.20 ** 4,495.00 Budgeted 4,209.80 Remaining 6 % Used Account: 135-50030-020-000 Social Security Taxes . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 44 10/05/2018 MUD P/R 10/05/2018 Social Security Taxes 948.39 948.39 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Social Security Taxes (948.39) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Social Security Taxes 948.39 948.39 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (948.39) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Social Security Taxes 828.40 828.40 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (7.16) 821.24 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 821.24 821.24 ** 29,006.00 Budgeted 28,184.76 Remaining 3 % Used Account: 135-50035-020-000 Medicare Taxes 44 10/05/2018 MUD P/R 10/05/2018 Medicare Taxes 221.81 221.81 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medicare Taxes (221.81) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medicare Taxes 221.81 221.81 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (221.81) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Medicare Taxes 193.74 193.74 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (1.67) 192.07 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 192.07 192.07 ** 6,784.00 Budgeted 6,591.93 Remaining 3 % 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 125 10/01/2018 Insurance/Wrk Comp Expense Oct 1,205.73 1,205.73 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,205.73 1,205.73 ** 16,941.00 Budgeted 15,735.27 Remaining 7 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 _______________ Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 121 10/26/2018 Pcards 09/27/18 - 10/26/18 MICHAELS KEYS 19.90 19.90 MICHAELS KEYS PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 15.38 35.28 THE HOME DEPOT #6581 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 FILTER ELEMENT STORE 184.93 220.21 FILTER ELEMENT STORE PC 217 10/31/2018 October A/P repairs 360.00 580.21 DHS AUTOMATION, INC 4717 AP 217 10/31/2018 October A/P repairs 360.00 940.21 DHS AUTOMATION, INC 4717 AP 217 10/31/2018 October A/P Lift Station #3 pump parts 2,370.00 3,310.21 SMITH PUMP COMPANY, INC. 4734 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 3,310.21 3,310.21 ** 88,000.00 Budgeted 84,689.79 Remaining 4 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AUTOZONE #4206 25.00 25.00 AUTOZONE #4206 PC 217 10/31/2018 October A/P wiper blades 21.48 46.48 NAPA AUTO PARTS 4730 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 46.48 46.48 ** 8,000.00 Budgeted 7,953.52 Remaining 1 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55120-020-000 Cleaning Services .00 .00 _______________ Account: 135-55120-020-000 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 96 10/23/2018 October A/P Dumpster Service 992.03 992.03 L.H. CHANEY MATERIALS, INC. 4684 AP 217 10/31/2018 October A/P Sludge haul off 967.10 1,959.13 L.H. CHANEY MATERIALS, INC. 4726 AP 217 10/31/2018 October A/P sludge haul off 2,535.85 4,494.98 L.H. CHANEY MATERIALS, INC. 4726 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,494.98 4,494.98 ** 75,000.00 Budgeted 70,505.02 Remaining 6 % Used Account: 135-55135-020-000 Lab Analysis 96 10/23/2018 October A/P Effluent sampling 246.00 246.00 OXIDOR LABORATORIES LLC 4688 AP 96 10/23/2018 October A/P Effluent sampling 176.00 422.00 OXIDOR LABORATORIES LLC 4688 AP 96 10/23/2018 October A/P Lab testing 246.00 668.00 OXIDOR LABORATORIES LLC 4688 AP 96 10/23/2018 October A/P lab testing 176.00 844.00 OXIDOR LABORATORIES LLC 4688 AP 114 10/26/2018 October A/P 176.00 1,020.00 OXIDOR LABORATORIES LLC 4688 AP 114 10/26/2018 October A/P Lab analysis 246.00 1,266.00 OXIDOR LABORATORIES LLC 4688 AP 141 10/30/2018 October A/P lab testing 226.00 1,492.00 OXIDOR LABORATORIES LLC 4688 AP 141 10/30/2018 October A/P lab testing 176.00 1,668.00 OXIDOR LABORATORIES LLC 4688 AP 217 10/31/2018 October A/P effluent testing 226.00 1,894.00 OXIDOR LABORATORIES LLC 4732 AP 217 10/31/2018 October A/P effluent testing 176.00 2,070.00 OXIDOR LABORATORIES LLC 4732 AP 217 10/31/2018 October A/P Lab supplies 1,477.46 3,547.46 IDEXX DISTRIBUTION, INC 4721 AP 217 10/31/2018 October A/P Lab testing 1,080.00 4,627.46 HUTHER AND ASSOCIATES,INC 4720 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 4,627.46 4,627.46 ** 35,000.00 Budgeted 30,372.54 Remaining 13 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-020-000 Communications/Mobiles 96 10/23/2018 October A/P Cell phones-October 382.49 382.49 VERIZON WIRELESS 4694 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 382.49 382.49 ** 5,000.00 Budgeted 4,617.51 Remaining 8 % Used Account: 135-60020-020-000 Electricity 114 10/26/2018 October A/P Electricity-October 12,030.59 12,030.59 HUDSON ENERGY SERVICES, LLC 4680 AP 254 10/31/2018 October A/P Electricity 9/25-10/23 193.33 12,223.92 TRI COUNTY ELECTRIC 4768 AP 254 10/31/2018 October A/P Electricity 9/25-10/23 274.11 12,498.03 TRI COUNTY ELECTRIC 4768 AP 254 10/31/2018 October A/P Electricity 9/25-10/23 27.62 12,525.65 TRI COUNTY ELECTRIC 4768 AP 260 10/31/2018 October A/P Electricity 10/10-11/8 12,597.79 25,123.44 HUDSON ENERGY SERVICES, LLC 4751 AP 203 10/31/2018 Town Billed Invoices 1660-1663 AR 20181031-20181031 User: (205.68) 24,917.76 AR _______________ Account: 135-60020-020-000 Electricity Totals: 24,917.76 24,917.76 ** 174,165.00 Budgeted 149,247.24 Remaining 14 % 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 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TX DPS DL OFFICE 69.00 69.00 TX DPS DL OFFICE PC _______________ Account: 135-60070-020-000 Dues & Memberships Totals: 69.00 69.00 ** 300.00 Budgeted 231.00 Remaining 23 % Used Account: 135-60080-020-000 Schools & Training 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TCEQ IND RENEWAL L 111.00 111.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 111.00 111.00 ** 7,155.00 Budgeted 7,044.00 Remaining 2 % Used Account: 135-60090-020-000 Safety Program .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,895.00 Budgeted 1,895.00 Remaining 0 % 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 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 114 10/26/2018 October A/P WWTP permit fees 9,888.02 9,888.02 TX COMMISSION ENVIRONMENTAL QU 4692 AP 254 10/31/2018 October A/P Well water 6,457.20 16,345.22 North Texas Groundwater 4761 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 16,345.22 16,345.22 ** 30,000.00 Budgeted 13,654.78 Remaining 54 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TRACTOR SUPPLY COMPANY 6.98 6.98 TRACTOR SUPPLY COMPANY PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60280-020-000 Property Maintenance Totals: 6.98 6.98 ** 5,000.00 Budgeted 4,993.02 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 11,600.00 Budgeted 11,600.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 160 10/31/2018 Texpool Transfers October 10,913.90 10,913.90 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,913.90 10,913.90 ** 120,053.00 Budgeted 109,139.10 Remaining 9 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 160 10/31/2018 Texpool Transfers October 54,203.45 54,203.45 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,203.45 54,203.45 ** 688,330.00 Budgeted 634,126.55 Remaining 8 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 160 10/31/2018 Texpool Transfers October 10,432.00 10,432.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,432.00 10,432.00 ** 125,187.00 Budgeted 114,755.00 Remaining 8 % Used Account: 135-60334-020-000 Interfund Transfer Out 160 10/31/2018 Texpool Transfers October 122,777.00 122,777.00 GL _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: 122,777.00 122,777.00 ** 200,000.00 Budgeted 77,223.00 Remaining 61 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 114 10/26/2018 October A/P Fuel-October 1,307.59 1,307.59 US Bank Voyager Fleet Systems 4693 AP 121 10/26/2018 Pcards 09/27/18 - 10/26/18 OREILLY AUTO # 5521 28.99 1,336.58 OREILLY AUTO # 5521 PC _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,336.58 1,336.58 ** 12,500.00 Budgeted 11,163.42 Remaining 11 % Used Account: 135-65010-020-000 Uniforms 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RED WING SHOES #652 174.99 174.99 RED WING SHOES #652 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RED WING SHOES #652 175.00 349.99 RED WING SHOES #652 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RED WING SHOES #652 175.00 524.99 RED WING SHOES #652 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TRACTOR SUPPLY COMPANY 19.99 544.98 TRACTOR SUPPLY COMPANY PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMAZON.COM*M89H74F10 158.46 703.44 AMAZON.COM*M89H74F10 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RED WING SHOES #652 161.99 865.43 RED WING SHOES #652 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TRACTOR SUPPLY COMPANY 169.98 1,035.41 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-020-000 Uniforms Totals: 1,035.41 1,035.41 ** 5,495.00 Budgeted 4,459.59 Remaining 19 % Used Account: 135-65030-020-000 Chemicals 217 10/31/2018 October A/P MBR cleaning solution 536.00 536.00 Valley Solvent Company, INC 4740 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 536.00 536.00 ** 30,000.00 Budgeted 29,464.00 Remaining 2 % Used Account: 135-65035-020-000 Small Tools .00 .00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 8.49 8.49 THE HOME DEPOT #6581 PC 217 10/31/2018 October A/P gloves 172.83 181.32 HD SUPPLY FACILITIES MAINT LTD 4719 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65040-020-000 Safety Equipment Totals: 181.32 181.32 ** 1,200.00 Budgeted 1,018.68 Remaining 15 % Used Account: 135-65045-020-000 Lab Supplies 42 10/10/2018 October A/P gloves 152.00 152.00 LOU'S GLOVES INCORPORATED 4654 AP 96 10/23/2018 October A/P Lab supplies 131.09 283.09 HACH COMPANY 4678 AP 141 10/30/2018 October A/P lab supplies 449.98 733.07 HACH COMPANY 4678 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 733.07 733.07 ** 20,000.00 Budgeted 19,266.93 Remaining 4 % Used Account: 135-69005-020-000 Capital Outlays 254 10/31/2018 October A/P WWTP legal 1,615.00 1,615.00 Dubois Bryant Campbell LLP 4749 AP 254 10/31/2018 October A/P LS #1 easement survey 974.58 2,589.58 CP&Y/WALLACE GROUP, INC. 4747 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 2,589.58 2,589.58 ** 330,000.00 Budgeted 327,410.42 Remaining 1 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 109,858.00 Budgeted 109,858.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 ** 14,917.00 Budgeted 14,917.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 117 10/01/2018 GASB 34 transfers FY 2019 Sewer Replacement 30,000.00 30,000.00 GL _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 30,000.00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: ----------------------------------- 315,098.41 ** 315,098.41 Monthly Total 2,872,082.00 Budgeted 2,556,983.59 Remaining 11 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 125 10/01/2018 Insurance/Wrk Comp Expense Oct 2.12 2.12 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.12 2.12 ** 30.00 Budgeted 27.88 Remaining 7 % 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 .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,300.00 Budgeted 1,300.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 3 10/01/2018 Ocotber A/P 295.00 295.00 AWBD 4557 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 295.00 295.00 ** 4,000.00 Budgeted 3,705.00 Remaining 7 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2018 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: ----------------------------------- 297.12 ** 297.12 Monthly Total 13,230.00 Budgeted 12,932.88 Remaining 2 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 44 10/05/2018 MUD P/R 10/05/2018 Salaries & Wages 14,704.88 14,704.88 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Salaries & Wages (14,704.88) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Salaries & Wages 14,704.88 14,704.88 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (14,704.88) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Salaries & Wages 13,370.27 13,370.27 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 13,370.27 13,370.27 ** 441,006.00 Budgeted 427,635.73 Remaining 3 % Used Account: 135-50010-030-000 Overtime 67 10/19/2018 MUD Payroll 10/19/2018 Overtime 3.16 3.16 PR _______________ Account: 135-50010-030-000 Overtime Totals: 3.16 3.16 ** 2,000.00 Budgeted 1,996.84 Remaining 0 % Used Account: 135-50016-030-000 Longevity .00 .00 _______________ Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 1,833.00 Budgeted 1,833.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 44 10/05/2018 MUD P/R 10/05/2018 Retirement 1,360.21 1,360.21 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Retirement (1,360.21) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Retirement 1,360.21 1,360.21 PR 67 10/19/2018 MUD Payroll 10/19/2018 Retirement 1,237.04 2,597.25 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,597.25 2,597.25 ** 41,148.00 Budgeted 38,550.75 Remaining 6 % Used Account: 135-50026-030-000 Medical Insurance 44 10/05/2018 MUD P/R 10/05/2018 Medical Insurance 2,072.63 2,072.63 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medical Insurance (2,072.63) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medical Insurance 2,072.63 2,072.63 PR 67 10/19/2018 MUD Payroll 10/19/2018 Medical Insurance 2,072.61 4,145.24 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 4,145.24 ** 81,895.00 Budgeted 77,749.76 Remaining 5 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-030-000 Dental Insurance 44 10/05/2018 MUD P/R 10/05/2018 Dental Insurance 129.78 129.78 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Dental Insurance (129.78) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Dental Insurance 129.78 129.78 PR 67 10/19/2018 MUD Payroll 10/19/2018 Dental Insurance 129.74 259.52 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 259.52 259.52 ** 4,291.00 Budgeted 4,031.48 Remaining 6 % Used Account: 135-50028-030-000 Vision Insurance 44 10/05/2018 MUD P/R 10/05/2018 Vision Insurance 21.28 21.28 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Vision Insurance (21.28) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Vision Insurance 21.28 21.28 PR 67 10/19/2018 MUD Payroll 10/19/2018 Vision Insurance 21.23 42.51 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 42.51 ** 701.00 Budgeted 658.49 Remaining 6 % Used Account: 135-50029-030-000 Life Insurance & Other 2 10/01/2018 October A/P 145.04 145.04 Humana Inc 4572 AP 4 10/01/2018 October A/P 119.45 264.49 METLIFE GROUP BENEFITS 4601 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 264.49 264.49 ** 4,495.00 Budgeted 4,230.51 Remaining 6 % Used Account: 135-50030-030-000 Social Security Taxes 44 10/05/2018 MUD P/R 10/05/2018 Social Security Taxes 873.68 873.68 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Social Security Taxes (873.68) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Social Security Taxes 873.68 873.68 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (873.68) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Social Security Taxes 788.49 788.49 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 788.49 788.49 ** 27,580.00 Budgeted 26,791.51 Remaining 3 % Used Account: 135-50035-030-000 Medicare Taxes 44 10/05/2018 MUD P/R 10/05/2018 Medicare Taxes 204.33 204.33 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medicare Taxes (204.33) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medicare Taxes 204.33 204.33 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 144 10/05/2018 Reverse 1 Accured FY18 Payroll (204.33) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Medicare Taxes 184.40 184.40 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 184.40 184.40 ** 6,450.00 Budgeted 6,265.60 Remaining 3 % Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-030-000 Workman's Compensation 125 10/01/2018 Insurance/Wrk Comp Expense Oct 106.55 106.55 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 106.55 106.55 ** 1,295.00 Budgeted 1,188.45 Remaining 8 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations .00 .00 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-55030-030-000 Software & Support 2 10/01/2018 October A/P 59,205.00 59,205.00 M3 Networks 4581 AP 21 10/05/2018 October A/P Internet-October 903.72 60,108.72 Charter Communications 4629 AP 96 10/23/2018 October A/P Microsoft Exchange 456.00 60,564.72 M3 Networks 4685 AP 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 107.79 60,672.51 ATT*BILL PAYMENT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 192.67 60,865.18 ATT*BILL PAYMENT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 124.34 60,989.52 ATT*BILL PAYMENT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 69.12 61,058.64 ATT*BILL PAYMENT PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ADOBE INC 32.45 61,091.09 ADOBE INC PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RINGCENTRAL, INC 12.99 61,104.08 RINGCENTRAL, INC PC _______________ Account: 135-55030-030-000 Software & Support Totals: 61,104.08 61,104.08 ** 77,849.00 Budgeted 16,744.92 Remaining 78 % Used Account: 135-55070-030-000 Independent Labor 264 10/31/2018 October A/P Audit consulting 98.33 98.33 DOROTHY RENAE GONZALES 4771 AP 217 10/31/2018 October A/P Backflow renewal 2019 595.00 693.33 SC TRACKING SOLUTIONS LLC 4733 AP 217 10/31/2018 October A/P GM-October 12.81 706.14 Carman Consulting LLC. 4712 AP 217 10/31/2018 October A/P GM-October 10,960.00 11,666.14 Carman Consulting LLC. 4712 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 11,666.14 11,666.14 ** 175,000.00 Budgeted 163,333.86 Remaining 7 % Used Account: 135-55080-030-000 Maintenance & Repairs 96 10/23/2018 October A/P Roof repair MUD building 315.00 315.00 TK CONTRACTORS LLC 4691 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 315.00 315.00 ** 20,000.00 Budgeted 19,685.00 Remaining 2 % 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 .00 .00 _______________ Account: 135-55120-030-000 Cleaning Services Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 66,055.00 Budgeted 66,055.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55205-030-000 Utility Billing Contract 217 10/31/2018 October A/P Billings-Oct 579.29 579.29 DATAPROSE LLC 4716 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 579.29 579.29 ** 9,000.00 Budgeted 8,420.71 Remaining 6 % Used Account: 135-60005-030-000 Telephone 21 10/05/2018 October A/P Answering svc-October 194.75 194.75 KEYSTONE PARK SECRETARIAL 4640 AP 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BUS PHONE PMT 461.83 656.58 ATT*BUS PHONE PMT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 85.71 742.29 ATT*BILL PAYMENT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BUS PHONE PMT 860.79 1,603.08 ATT*BUS PHONE PMT PC 203 10/31/2018 Town Billed Invoices 1660-1663 AR 20181031-20181031 User: (180.00) 1,423.08 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,423.08 1,423.08 ** 23,500.00 Budgeted 22,076.92 Remaining 6 % Used Account: 135-60010-030-000 Communications/Mobiles 67 10/19/2018 MUD Payroll 10/19/2018 Communications/Mobiles 150.00 150.00 PR 96 10/23/2018 October A/P Cell phones-October 87.49 237.49 VERIZON WIRELESS 4694 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.49 237.49 ** 4,000.00 Budgeted 3,762.51 Remaining 6 % Used Account: 135-60020-030-000 Electricity/Gas 217 10/31/2018 October A/P Electricity admin 8/10-9/11 557.71 557.71 TOWN OF TROPHY CLUB 4738 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 557.71 557.71 ** 8,690.00 Budgeted 8,132.29 Remaining 6 % Used Account: 135-60025-030-000 Water 203 10/31/2018 Town Billed Invoices 1660-1663 AR 20181031-20181031 User: (58.32) (58.32) AR 217 10/31/2018 October A/P Water-October 106.71 48.39 TROPHY CLUB MUD (WATER BILLS) 4739 AP _______________ Account: 135-60025-030-000 Water Totals: 48.39 48.39 ** 2,000.00 Budgeted 1,951.61 Remaining 2 % Used Account: 135-60035-030-000 Postage 96 10/23/2018 October A/P overnight-TCEQ 20.25 20.25 FEDERAL EXPRESS CORP 4676 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 141 10/30/2018 October A/P Postage lease 97.65 117.90 FRANCOTYP-POSTALIA, INC. 4677 AP 217 10/31/2018 October A/P Billings-Oct 1,609.54 1,727.44 DATAPROSE LLC 4716 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,727.44 1,727.44 ** 30,000.00 Budgeted 28,272.56 Remaining 6 % Used Account: 135-60040-030-000 Service Charges & Fees 15 10/05/2018 Child Support Fee 1.50 1.50 GL 68 10/19/2018 Child Support Fee 1.50 3.00 GL 155 10/31/2018 Pace Credit Card Fees 6,276.89 6,279.89 GL 155 10/31/2018 Pace Credit Card Fees 157.68 6,437.57 GL 217 10/31/2018 October A/P Dig Tess-September 208.05 6,645.62 Texas Excavation Safety System 4737 AP 217 10/31/2018 October A/P Dig Tess-October 253.65 6,899.27 Texas Excavation Safety System 4737 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 6,899.27 6,899.27 ** 55,560.00 Budgeted 48,660.73 Remaining 12 % 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 125 10/01/2018 Insurance/Wrk Comp Expense Oct 6,302.73 6,302.73 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,302.73 6,302.73 ** 65,000.00 Budgeted 58,697.27 Remaining 10 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 2 10/01/2018 October A/P 100.00 100.00 TX COMPTROLLER 4593 AP 260 10/31/2018 October A/P 100.00 200.00 NORTH CENTRAL TX COG 4762 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 200.00 200.00 ** 6,000.00 Budgeted 5,800.00 Remaining 3 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % 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 .00 .00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 .00 ** 8,950.00 Budgeted 8,950.00 Remaining 0 % Used Account: 135-60100-030-000 Travel & per diem .00 .00 _______________ Account: 135-60100-030-000 Travel & per diem Totals: .00 .00 ** 4,345.00 Budgeted 4,345.00 Remaining 0 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 25,000.00 Budgeted 25,000.00 Remaining 0 % Used Account: 135-60235-030-000 Security 96 10/23/2018 October A/P Monitoring service 24.00 24.00 Digital Air Control, Inc 4674 AP _______________ Account: 135-60235-030-000 Security Totals: 24.00 24.00 ** 1,288.00 Budgeted 1,264.00 Remaining 2 % 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 .00 .00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 2,050.00 Budgeted 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65055-030-000 Hardware Totals: .00 .00 ** 7,064.00 Budgeted 7,064.00 Remaining 0 % Used Account: 135-65085-030-000 Office Supplies 42 10/10/2018 October A/P Postage machine ink 107.95 107.95 ASI BUSINESS SOLUTIONS LTD 4653 AP 96 10/23/2018 October A/P Office supplies-Water and WW 168.04 275.99 OFFICE DEPOT, INC 4687 AP 141 10/30/2018 October A/P Office supplies 53.20 329.19 OFFICE DEPOT, INC 4687 AP 141 10/30/2018 October A/P office supplies 11.99 341.18 OFFICE DEPOT, INC 4687 AP 254 10/31/2018 October A/P office supplies 73.38 414.56 OFFICE DEPOT, INC 4763 AP 217 10/31/2018 October A/P office supplies 59.50 474.06 OFFICE DEPOT, INC 4731 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 474.06 474.06 ** 6,000.00 Budgeted 5,525.94 Remaining 8 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 121 10/26/2018 Pcards 09/27/18 - 10/26/18 SAMSCLUB.COM 237.19 237.19 SAMSCLUB.COM PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 SAMSCLUB #4795 18.06 255.25 SAMSCLUB #4795 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 WALMART GROCERY 33.14 288.39 WALMART GROCERY PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 WAL-MART #0266 6.52 294.91 WAL-MART #0266 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMAZON.COM*MT7S82UA0 36.97 331.88 AMAZON.COM*MT7S82UA0 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMZN MKTP US*MT70T19T0 80.99 412.87 AMZN MKTP US*MT70T19T0 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMZN MKTP US*MT1CJ58C2 31.17 444.04 AMZN MKTP US*MT1CJ58C2 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 444.04 444.04 ** 4,000.00 Budgeted 3,555.96 Remaining 11 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-030-000 Capital Outlays .00 .00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** 280,000.00 Budgeted 280,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 114 10/26/2018 October A/P Copies 99.89 99.89 KYOCERA DOCUMENT SOLUTIONS 4683 AP 254 10/31/2018 October A/P Copier lease-OCt 194.00 293.89 TIAA COMMERCIAL FINANCE 4766 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 293.89 293.89 ** 4,000.00 Budgeted 3,706.11 Remaining 7 % Used Department 30 Totals: ----------------------------------- 114,058.49 ** 114,058.49 Monthly Total 1,559,905.00 Budgeted 1,445,846.51 Remaining 7 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 260 10/31/2018 October A/P Legal-Westlake easement 7,954.68 7,954.68 WHITAKER CHALK SWINDLE 4770 AP 260 10/31/2018 October A/P Legal 2,760.00 10,714.68 McLean & Howard, L.L.P. 4759 AP 260 10/31/2018 October A/P Legal 1,125.00 11,839.68 McLean & Howard, L.L.P. 4759 AP _______________ Account: 135-55045-039-000 Legal Totals: 11,839.68 11,839.68 ** 137,000.00 Budgeted 125,160.32 Remaining 9 % Used Account: 135-55055-039-000 Auditing 115 10/01/2018 Reverse PPD Audit Retainer 5,000.00 5,000.00 GL _______________ Account: 135-55055-039-000 Auditing Totals: 5,000.00 5,000.00 ** 30,800.00 Budgeted 25,800.00 Remaining 16 % Used Account: 135-55060-039-000 Appraisal .00 .00 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 .00 ** 11,714.00 Budgeted 11,714.00 Remaining 0 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Department 39 Totals: ----------------------------------- 16,839.68 ** 16,839.68 Monthly Total 184,314.00 Budgeted 167,474.32 Remaining 9 % Used Fund 135 Totals: ----------------------------------- (16,288.57) (16,288.57) Monthly Total (341,837.00) Budgeted (325,548.43) Remaining 5 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund 117 10/01/2018 GASB 34 transfers FY 2019 Town Elevated Tank (45,000.00) (45,000.00) GL 117 10/01/2018 GASB 34 transfers FY 2019 Water Replacement (30,000.00) (75,000.00) GL 117 10/01/2018 GASB 34 transfers FY 2019 Sewer Replacement (30,000.00) (105,000.00) GL _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: (105,000.00) (105,000.00) ** .00 Budgeted 105,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept 117 10/01/2018 GASB 34 transfers FY 2019 Fire Truck Future Replacement (81,420.00) (81,420.00) GL _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: (81,420.00) (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (186,420.00) ** (186,420.00) Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) (186,420.00) Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET OCTOBER 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK 7 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 7 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 727,624 TOTAL LIABILITIES 727,624 FUND BALANCE ASSIGNED FUND BALANCE (807,739) NET REVENUES / EXPENDITURES 80,122 TOTAL FUND BALANCE (727,617) TOTAL LIABILITIES AND FUND BALANCE 7 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 11:31 11/19/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 7.29- 7.29- 7.29 Subtotal: 7.29- 7.29- 7.29 Program number: 7.29- 7.29- 7.29 Department number: Revenues 7.29- 7.29- 7.29 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 11:31 11/19/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49141-020-000 Interfund Transfers In Gen 122,777.00- 122,777.00- 122,777.00 Subtotal: 122,777.00- 122,777.00- 122,777.00 Program number: 122,777.00- 122,777.00- 122,777.00 Department number: Wastewater 122,777.00- 122,777.00- 122,777.00 Revenues Subtotal ----------- 122,784.29- 122,784.29- 122,784.29 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 11:31 11/19/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 42,662.50 42,662.50 42,662.50- Subtotal: 42,662.50 42,662.50 42,662.50- Program number: 42,662.50 42,662.50 42,662.50- Department number: Wastewater 42,662.50 42,662.50 42,662.50- Expenditures Subtotal ----------- 42,662.50 42,662.50 42,662.50- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 80,121.79- 80,121.79- 80,121.79 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 165 10/31/2018 Bank Interest- October (7.29) (7.29) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (7.29) (7.29) ** .00 Budgeted 7.29 Remaining 0 % Used Department Totals: ----------------------------------- (7.29) ** (7.29) Monthly Total .00 Budgeted 7.29 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49141-020-000 Interfund Transfers In Gen 160 10/31/2018 Texpool Transfers October (122,777.00) (122,777.00) GL _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (122,777.00) (122,777.00) ** .00 Budgeted 122,777.00 Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 254 10/31/2018 October A/P WWTP improvements 23,790.06 23,790.06 CP&Y/WALLACE GROUP, INC. 4747 AP 217 10/31/2018 October A/P WWTP Improvements 18,872.44 42,662.50 WEBBER-CADAGUA PARTNERS 4742 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 42,662.50 42,662.50 ** .00 Budgeted (42,662.50) Remaining 0 % Used Department 20 Totals: ----------------------------------- (80,114.50) ** (80,114.50) Monthly Total .00 Budgeted 80,114.50 Remaining 0 % Used Fund 517 Totals: ----------------------------------- (80,121.79) (80,121.79) Monthly Total .00 Budgeted 80,121.79 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET OCTOBER 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 767,358 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 767,358 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 754,200 NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE 754,200 TOTAL LIABILITIES AND FUND BALANCE 767,358 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 11:31 11/19/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 19,506.92- 19,506.92- 19,506.92 Subtotal: 19,506.92- 19,506.92- 19,506.92 Program number: 19,506.92- 19,506.92- 19,506.92 Department number: Revenues 19,506.92- 19,506.92- 19,506.92 Revenues Subtotal ----------- 19,506.92- 19,506.92- 19,506.92 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 11:31 11/19/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60334-010-000 Interfund Transfer Out 797,679.25 797,679.25 797,679.25- Subtotal: 797,679.25 797,679.25 797,679.25- 519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68 2,693,208.68- Subtotal: 2,693,208.68 2,693,208.68 2,693,208.68- Program number: 3,490,887.93 3,490,887.93 3,490,887.93- Department number: Water 3,490,887.93 3,490,887.93 3,490,887.93- Expenditures Subtotal ----------- 3,490,887.93 3,490,887.93 3,490,887.93- Fund number: 519 2016 Rev Bond Const-SWIFT 3,471,381.01 3,471,381.01 3,471,381.01- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49010-000-000 Interest Income (19,506.92) .00 (19,506.92) _______________ Account: 519-49010-000-000 Interest Income Totals: .00 (19,506.92) ** .00 Budgeted 19,506.92 Remaining 0 % Used Department Totals: ----------------------------------- (19,506.92) ** .00 Monthly Total .00 Budgeted 19,506.92 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-60334-010-000 Interfund Transfer Out 797,679.25 .00 797,679.25 _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: .00 797,679.25 ** .00 Budgeted (797,679.25) Remaining 0 % Used Account: 519-69005-010-000 Capital Outlays 2,693,208.68 .00 2,693,208.68 _______________ Account: 519-69005-010-000 Capital Outlays Totals: .00 2,693,208.68 ** .00 Budgeted (2,693,208.68) Remaining 0 % Used Department 10 Totals: ----------------------------------- 3,490,887.93 ** .00 Monthly Total .00 Budgeted (3,490,887.93) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 3,471,381.01 .00 Monthly Total .00 Budgeted (3,471,381.01) Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET OCTOBER 2018 520 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 411,246 TOTAL LIABILITIES 411,246 FUND BALANCE ASSIGNED FUND BALANCE (411,246) NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE (411,246) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 11:31 11/19/18 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 371,346.11 371,346.11 371,346.11- Subtotal: 371,346.11 371,346.11 371,346.11- Program number: 371,346.11 371,346.11 371,346.11- Department number: Water Department 371,346.11 371,346.11 371,346.11- Expenditures Subtotal ----------- 371,346.11 371,346.11 371,346.11- Fund number: 520 Revenue Bond 16" Waterline 371,346.11 371,346.11 371,346.11- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 Capital Outlays 371,346.11 .00 371,346.11 _______________ Account: 520-69005-010-000 Capital Outlays Totals: .00 371,346.11 ** .00 Budgeted (371,346.11) Remaining 0 % Used Department 10 Totals: ----------------------------------- 371,346.11 ** .00 Monthly Total .00 Budgeted (371,346.11) Remaining 0 % Used Fund 520 Totals: ----------------------------------- 371,346.11 .00 Monthly Total .00 Budgeted (371,346.11) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 623,048 ACCOUNTS RECEIVABLE - TOTAL ASSETS 623,048 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 606,910 NET REVENUES / EXPENDITURES 16,138 TOTAL FUND BALANCE 623,048 TOTAL LIABILITIES AND FUND BALANCE 623,048 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 11:31 11/19/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 5,000.00- 5,000.00- 1,105.95- 1,105.95- 22.119 3,894.05- 528-49142-000-000 Interfund transfer in-Water 55,193.00- 55,193.00- 4,600.00- 4,600.00- 8.334 50,593.00- 528-49143-000-000 Interfund transfer in-WW 125,187.00- 125,187.00- 10,432.00- 10,432.00- 8.333 114,755.00- Subtotal: 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- Program number: 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- Department number: 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- Revenues Subtotal ----------- 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- Fund number: 528 2015 Revenue Bond Reserve Fund 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 165 10/31/2018 Bank Interest- October (1,105.95) (1,105.95) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (1,105.95) (1,105.95) ** (5,000.00) Budgeted (3,894.05) Remaining 22 % Used Account: 528-49142-000-000 Interfund transfer in-Water 160 10/31/2018 Texpool Transfers October (4,600.00) (4,600.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,600.00) (4,600.00) ** (55,193.00) Budgeted (50,593.00) Remaining 8 % Used Account: 528-49143-000-000 Interfund transfer in-WW 160 10/31/2018 Texpool Transfers October (10,432.00) (10,432.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,432.00) (10,432.00) ** (125,187.00) Budgeted (114,755.00) Remaining 8 % Used Department Totals: ----------------------------------- (16,137.95) ** (16,137.95) Monthly Total (185,380.00) Budgeted (169,242.05) Remaining 9 % Used Fund 528 Totals: ----------------------------------- (16,137.95) (16,137.95) Monthly Total (185,380.00) Budgeted (169,242.05) Remaining 9 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET OCTOBER 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 70,534 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 687,582 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 762,689 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 687,582 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 687,582 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 21,818 TOTAL FUND BALANCE 75,107 TOTAL LIABILITIES AND FUND BALANCE 762,689 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 11:31 11/19/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 687,175.00- 687,175.00- 10,618.40- 10,618.40- 1.545 676,556.60- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 172.84- 172.84- 9.602 1,627.16- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 21.61- 21.61- 1.081 1,978.39- Subtotal: 690,975.00- 690,975.00- 10,812.85- 10,812.85- 1.565 680,162.15- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 91.48- 91.48- 4.574 1,908.52- 533-49015-000-000 Lease/Rental Income 215,979.00- 215,979.00- 215,979.00- 533-49141-000-000 Interfund Trans In-PID Surchg 120,053.00- 120,053.00- 10,913.90- 10,913.90- 9.091 109,139.10- Subtotal: 338,032.00- 338,032.00- 11,005.38- 11,005.38- 3.256 327,026.62- Program number: 1,029,007.00- 1,029,007.00- 21,818.23- 21,818.23- 2.120 1,007,188.77- Department number: Revenues 1,029,007.00- 1,029,007.00- 21,818.23- 21,818.23- 2.120 1,007,188.77- Revenues Subtotal ----------- 1,029,007.00- 1,029,007.00- 21,818.23- 21,818.23- 2.120 1,007,188.77- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 11:31 11/19/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 2,150.00 533-70025-051-000 Bond Interest Expense-Tax 266,058.00 266,058.00 266,058.00 533-70035-051-000 Bond Principal Payment-Tax 755,000.00 755,000.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 1,023,208.00 1,023,208.00 Department number: Administration 1,023,208.00 1,023,208.00 1,023,208.00 Expenditures Subtotal ----------- 1,023,208.00 1,023,208.00 1,023,208.00 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 21,818.23- 21,818.23- 376.241 16,019.23 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 172 10/01/2018 Property taxes (.25) (.25) GL 175 10/09/2018 Property Taxes (136.21) (136.46) GL 176 10/11/2018 Property Taxes (103.26) (239.72) GL 177 10/12/2018 Property Taxes (196.28) (436.00) GL 178 10/15/2018 Property Taxes (137.47) (573.47) GL 179 10/17/2018 Property Taxes (147.21) (720.68) GL 180 10/18/2018 Property Taxes (166.07) (886.75) GL 181 10/19/2018 Property Taxes (420.42) (1,307.17) GL 182 10/22/2018 Property Taxes (558.37) (1,865.54) GL 183 10/23/2018 Property Taxes (880.27) (2,745.81) GL 184 10/24/2018 Property Taxes (843.30) (3,589.11) GL 185 10/25/2018 Property Taxes (1,933.85) (5,522.96) GL 186 10/26/2018 Property Taxes (1,247.54) (6,770.50) GL 187 10/29/2018 Property Taxes (1,454.33) (8,224.83) GL 188 10/30/2018 Property Taxes (1,756.06) (9,980.89) GL 189 10/31/2018 Property Taxes (637.51) (10,618.40) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (10,618.40) (10,618.40) ** (687,175.00) Budgeted (676,556.60) Remaining 2 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 172 10/01/2018 Property taxes (51.23) (51.23) GL 174 10/05/2018 Property Taxes (13.41) (64.64) GL 175 10/09/2018 Property Taxes 9.68 (54.96) GL 180 10/18/2018 Property Taxes (38.49) (93.45) GL 182 10/22/2018 Property Taxes (78.06) (171.51) GL 189 10/31/2018 Property Taxes (1.33) (172.84) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (172.84) (172.84) ** (1,800.00) Budgeted (1,627.16) Remaining 10 % Used Account: 533-40015-000-000 Property Taxes/P & I 172 10/01/2018 Property taxes (7.68) (7.68) GL 174 10/05/2018 Property Taxes (1.56) (9.24) GL 180 10/18/2018 Property Taxes (3.46) (12.70) GL 182 10/22/2018 Property Taxes (7.93) (20.63) GL 189 10/31/2018 Property Taxes (.98) (21.61) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (21.61) (21.61) ** (2,000.00) Budgeted (1,978.39) Remaining 1 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49010-000-000 Interest Income 165 10/31/2018 Bank Interest- October (91.48) (91.48) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (91.48) (91.48) ** (2,000.00) Budgeted (1,908.52) Remaining 5 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (215,979.00) Budgeted (215,979.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 160 10/31/2018 Texpool Transfers October (10,913.90) (10,913.90) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,913.90) (10,913.90) ** (120,053.00) Budgeted (109,139.10) Remaining 9 % Used Department Totals: ----------------------------------- (21,818.23) ** (21,818.23) Monthly Total (1,029,007.00) Budgeted (1,007,188.77) Remaining 2 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,150.00 Budgeted 2,150.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 266,058.00 Budgeted 266,058.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 ** 755,000.00 Budgeted 755,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used Fund 533 Totals: ----------------------------------- (21,818.23) (21,818.23) Monthly Total (5,799.00) Budgeted 16,019.23 Remaining 376 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET OCTOBER 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 73,804 ACCOUNTS RECEIVABLE - TOTAL ASSETS 73,804 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 19,562 NET REVENUES / EXPENDITURES 54,242 TOTAL FUND BALANCE 73,804 TOTAL LIABILITIES AND FUND BALANCE 73,804 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 11:31 11/19/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 1,000.00- 1,000.00- 38.85- 38.85- 3.885 961.15- 534-49143-000-000 Interfund Transfer In-WW Sales 596,238.00- 596,238.00- 54,203.45- 54,203.45- 9.091 542,034.55- Subtotal: 597,238.00- 597,238.00- 54,242.30- 54,242.30- 9.082 542,995.70- Program number: 597,238.00- 597,238.00- 54,242.30- 54,242.30- 9.082 542,995.70- Department number: Revenues 597,238.00- 597,238.00- 54,242.30- 54,242.30- 9.082 542,995.70- Revenues Subtotal ----------- 597,238.00- 597,238.00- 54,242.30- 54,242.30- 9.082 542,995.70- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 11:31 11/19/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 534-70040-051-000 Revenue Bond Interest Expense 215,838.00 215,838.00 215,838.00 534-70045-051-000 Revenue Bond Principal Expense 380,000.00 380,000.00 380,000.00 Subtotal: 596,238.00 596,238.00 596,238.00 Program number: 596,238.00 596,238.00 596,238.00 Department number: Administration 596,238.00 596,238.00 596,238.00 Expenditures Subtotal ----------- 596,238.00 596,238.00 596,238.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 54,242.30- 54,242.30- 5,424.230 53,242.30 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 165 10/31/2018 Bank Interest- October (38.85) (38.85) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (38.85) (38.85) ** (1,000.00) Budgeted (961.15) Remaining 4 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 160 10/31/2018 Texpool Transfers October (54,203.45) (54,203.45) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,203.45) (54,203.45) ** (596,238.00) Budgeted (542,034.55) Remaining 9 % Used Department Totals: ----------------------------------- (54,242.30) ** (54,242.30) Monthly Total (597,238.00) Budgeted (542,995.70) Remaining 9 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee .00 .00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 215,838.00 Budgeted 215,838.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 ** 380,000.00 Budgeted 380,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 596,238.00 Budgeted 596,238.00 Remaining 0 % Used Fund 534 Totals: ----------------------------------- (54,242.30) (54,242.30) Monthly Total (1,000.00) Budgeted 53,242.30 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET OCTOBER 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 27,763 ACCOUNTS RECEIVABLE - TOTAL ASSETS 27,763 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 2,584 NET REVENUES / EXPENDITURES 25,179 TOTAL FUND BALANCE 27,763 TOTAL LIABILITIES AND FUND BALANCE 27,763 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 11:31 11/19/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 600.00- 600.00- 6.15- 6.15- 1.025 593.85- 535-49142-000-000 Interfund Tran In-Water Sales 276,901.00- 276,901.00- 25,172.81- 25,172.81- 9.091 251,728.19- Subtotal: 277,501.00- 277,501.00- 25,178.96- 25,178.96- 9.073 252,322.04- Program number: 277,501.00- 277,501.00- 25,178.96- 25,178.96- 9.073 252,322.04- Department number: Revenues 277,501.00- 277,501.00- 25,178.96- 25,178.96- 9.073 252,322.04- Revenues Subtotal ----------- 277,501.00- 277,501.00- 25,178.96- 25,178.96- 9.073 252,322.04- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 26 11:31 11/19/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 535-70040-051-000 Revenue Bond Interest Expense 61,501.00 61,501.00 61,501.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: 276,901.00 276,901.00 276,901.00 Program number: 276,901.00 276,901.00 276,901.00 Department number: Administration 276,901.00 276,901.00 276,901.00 Expenditures Subtotal ----------- 276,901.00 276,901.00 276,901.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,178.96- 25,178.96- 4,196.493 24,578.96 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 165 10/31/2018 Bank Interest- October (6.15) (6.15) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (6.15) (6.15) ** (600.00) Budgeted (593.85) Remaining 1 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 160 10/31/2018 Texpool Transfers October (25,172.81) (25,172.81) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,172.81) (25,172.81) ** (276,901.00) Budgeted (251,728.19) Remaining 9 % Used Department Totals: ----------------------------------- (25,178.96) ** (25,178.96) Monthly Total (277,501.00) Budgeted (252,322.04) Remaining 9 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee .00 .00 _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 61,501.00 Budgeted 61,501.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 276,901.00 Budgeted 276,901.00 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (25,178.96) (25,178.96) Monthly Total (600.00) Budgeted 24,578.96 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 3,691,211.95 **** (151,515.17) Monthly Total (1,209,068.00) Budgeted (4,900,279.95) Remaining ########## ******* End of Report *********