Loading...
HomeMy WebLinkAbout2018-09 September Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 543,883 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 15,308 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 559,191 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 15,308 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 15,308 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 21,631 TOTAL FUND BALANCE 543,883 TOTAL LIABILITIES AND FUND BALANCE 559,191 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 22:50 10/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 1,054,433.00- 1,054,433.00- 79.09- 1,066,060.62- 101.103 11,627.62 122-40011-000-000 Property Taxes/Fire-Delinquent 3,945.10- 3,945.10 122-40020-000-000 Property Taxes/Fire P&I 8.71- 4,786.64- 4,786.64 Subtotal: 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36 Program number: 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36 Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36 Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 22:50 10/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 1,490.49 1,490.49- Subtotal: 1,490.49 1,490.49- 122-60030-045-000 Rent And/Or Usage 218,954.00 218,954.00 218,954.00 100.000 122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.84 15,238.41 84.658 2,761.59 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 608,910.00 100.000 Subtotal: 845,864.00 845,864.00 52,012.34 843,102.41 99.674 2,761.59 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 52,012.34 1,053,161.50 99.879 1,271.50 Department number: Fire 1,054,433.00 1,054,433.00 52,012.34 1,053,161.50 99.879 1,271.50 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.34 1,053,161.50 99.879 1,271.50 Fund number: 122 Trophy Club MUD Fire Dept. 51,924.54 21,630.86- 21,630.86 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/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 2153 09/04/2018 Property Taxes (1,065,981.53) (54.72) (1,066,036.25) GL 2154 09/28/2018 Property Taxes (24.37) (1,066,060.62) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (79.09) (1,066,060.62) ** (1,054,433.00) Budgeted 11,627.62 Remaining 101 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent (3,945.10) .00 (3,945.10) _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: .00 (3,945.10) ** .00 Budgeted 3,945.10 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2153 09/04/2018 Property Taxes (4,777.93) (3.83) (4,781.76) GL 2154 09/28/2018 Property Taxes (4.88) (4,786.64) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (8.71) (4,786.64) ** .00 Budgeted 4,786.64 Remaining 0 % Used Department Totals: ----------------------------------- (1,074,792.36) ** (87.80) Monthly Total (1,054,433.00) Budgeted 20,359.36 Remaining 102 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 1,490.49 .00 1,490.49 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 1,490.49 ** .00 Budgeted (1,490.49) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage 218,954.00 .00 218,954.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,954.00 ** 218,954.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 243 09/01/2018 Insurance/Wrk Comp Exp Sep 13,968.57 1,269.84 15,238.41 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.84 15,238.41 ** 18,000.00 Budgeted 2,761.59 Remaining 85 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 2034 09/07/2018 September A/P September Fire Admin 558,167.50 50,742.50 608,910.00 TOWN OF TROPHY CLUB 4552 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 608,910.00 ** 608,910.00 Budgeted .00 Remaining 100 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 1,053,161.50 ** 52,012.34 Monthly Total 1,054,433.00 Budgeted 1,271.50 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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: ----------------------------------- (21,630.86) 51,924.54 Monthly Total .00 Budgeted 21,630.86 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET SEPTEMBER 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,379,652 - 1,379,652 CASH IN BANK-SAVINGS-CASH RESERVE 983,515 - 983,515 CD-BANK OF THE WEST/THB DEPOSIT - - - INVESTMENTS-MONEY MARKET-BANK OF THE WEST - - - INVESTMENTS-TEXPOOL 3,227,798 596,426 3,824,224 PREPAID EXPENSES 8,486 - 8,486 ADVALOREM PROPERTY TAXES RECEIVABLE 1,644 - 1,644 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,473,411 - 1,473,411 TOTAL ASSETS 7,075,105 596,426 7,671,531 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,644 - 1,644 ACCOUNTS AND OTHER PAYABLES 308,547 - 308,547 CUSTOMER DEPOSITS 312,115 - 312,115 - TOTAL LIABILITIES 622,306 - 622,306 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,778,760 1,778,760 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 180,000 180,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 120,000 120,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 67,805 67,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 228,621 228,621 UNASSIGNED FUND BALANCE 2,368,122 - 2,368,122 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 2,302,431 - 2,302,431 - TOTAL FUND BALANCE 6,452,799 596,426 7,049,225 TOTAL LIABILITIES AND FUND BALANCE 7,075,105 596,426 7,671,531 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 120,950.00- 120,950.00- 9.08- 122,278.88- 101.099 1,328.88 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 347.07- 173.535 147.07 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- .99- 530.33- 265.165 330.33 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 10.07- 123,156.28- 41.163 176,032.72- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 489,452.77- 5,953,140.59- 92.097 510,878.41- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 258,662.34- 2,992,699.99- 100.491 14,632.99 135-47025-000-000 Penalties 106,279.00- 106,279.00- 16,306.53- 119,593.62- 112.528 13,314.62 135-47030-000-000 Service Charges 21,350.00- 14,350.00- 1,550.00- 13,880.50- 96.728 469.50- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 150.00- 2,200.00- 146.667 700.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 450.00- 5,800.00- 128.889 1,300.00 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 5,025.60- 81,611.20- 136.019 21,611.20 Subtotal: 9,635,715.00- 9,628,715.00- 771,597.24- 9,168,925.90- 95.225 459,789.10- 135-49010-000-000 Interest Income 12,000.00- 50,000.00- 8,443.30- 58,856.46- 117.713 8,856.46 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 1,178.81- 12,077.44- 110.539 1,151.44 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.36- 6,999.99- 100.000 .01- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 15,400.00- 15,400.00- 100.000 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 1,029.00- 14,236.76- 78.314 3,942.24- 135-49141-000-000 Interfund Transfer In 796,145.00- 1,053,935.08 797,834.14- 100.212 1,689.14 135-49900-000-000 Miscellaneous Income 5,000.00- 15,000.00- 419.28 59,047.04- 393.647 44,047.04 135-49901-000-000 Records Management Revenue 20.00- 20.00- 2.00- 10.000 18.00- 135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00- Subtotal: 315,125.00- 1,172,670.00- 1,043,119.89 964,453.83- 82.244 208,216.17- Program number: 10,250,029.00- 11,100,574.00- 271,512.58 10,256,536.01- 92.396 844,037.99- Department number: Revenues 10,250,029.00- 11,100,574.00- 271,512.58 10,256,536.01- 92.396 844,037.99- Revenues Subtotal ----------- 10,250,029.00- 11,100,574.00- 271,512.58 10,256,536.01- 92.396 844,037.99- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 274,279.00 274,279.00 26,095.72 234,283.97 85.418 39,995.03 135-50010-010-000 Overtime 20,000.00 20,000.00 1,191.16 14,133.01 70.665 5,866.99 135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 96.642 115.00 135-50017-010-000 Certification 3,300.00 3,300.00 200.00 2,425.00 73.485 875.00 135-50020-010-000 Retirement 27,843.00 27,843.00 2,542.54 24,919.02 89.498 2,923.98 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 32,815.76 62.870 19,380.24 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 2,589.29 49.967 2,592.71 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 459.83 46.261 534.17 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 215.61 2,555.15 85.686 426.85 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,685.10 15,638.91 83.801 3,023.09 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 394.10 3,657.49 83.791 707.51 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 818.68 75.804 261.32 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.88 10,799.00 91.100 1,055.00 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 285.05 142.525 85.05- 135-50070-010-000 Employee Relations 300.00 300.00 138.84 178.13 59.377 121.87 Subtotal: 426,662.00 426,662.00 36,561.32 348,868.29 81.767 77,793.71 135-55005-010-000 Engineering 275,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 1,111.78 100,900.75 100.901 900.75- 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 4,000.00 4,000.00 147.97 5,216.24 130.406 1,216.24- 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 35.00 1.000 3,465.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 817.70 7,412.86 134.779 1,912.86- Subtotal: 391,000.00 116,000.00 2,077.45 113,564.85 97.901 2,435.15 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 369.91 3,972.63 84.524 727.37 135-60020-010-000 Electricity 175,356.00 150,000.00 15,109.51 140,190.42 93.460 9,809.58 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 767.00 76.700 233.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 2,785.00 2,785.00 680.00 2,888.78 103.726 103.78- 135-60090-010-000 Safety Program 400.00 400.00 8.36 2.090 391.64 135-60100-010-000 Travel & per diem 1,735.00 1,735.00 87.48 5.042 1,647.52 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 55,176.00 55,176.00 24,220.32 43.896 30,955.68 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 291,820.90 2,162,163.82 76.586 661,006.18 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 974.70 32.490 2,025.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 11,250.00 76.271 3,500.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 278,083.50 100.000 .50 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 48,996.00 100.000 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 1,053,935.08- 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,613,852.00 3,588,496.00 741,121.76- 2,678,622.67 74.645 909,873.33 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 993.47 11,207.95 74.720 3,792.05 135-65010-010-000 Uniforms 4,488.00 4,488.00 1,382.63 2,631.77 58.640 1,856.23 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,603.29 18,687.20 93.436 1,312.80 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,080.95 108.095 80.95- 135-65050-010-000 Meter Expense 50,000.00 50,000.00 24,975.75 49.952 25,024.25 135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 82,312.50 97.991 1,687.50 Subtotal: 175,688.00 175,688.00 3,979.39 140,896.12 80.197 34,791.88 135-69005-010-000 Capital Outlays 810,012.00 1,085,012.00 79,244.33- 511,131.56 47.108 573,880.44 135-69008-010-000 Short Term Debt-Principal 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 2,271.24 39.756 3,441.76 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 110,001.00 107,864.38 98.058 2,136.62 Subtotal: 1,048,231.00 1,275,726.00 79,244.33- 696,267.18 54.578 579,458.82 Program number: 5,655,433.00 5,582,572.00 777,747.93- 3,978,219.11 71.261 1,604,352.89 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 367.70 1,752.78 87.639 247.22 Subtotal: 2,000.00 2,000.00 367.70 1,752.78 87.639 247.22 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 367.70 1,752.78 87.639 247.22 Department number: Water 5,657,433.00 5,584,572.00 777,380.23- 3,979,971.89 71.267 1,604,600.11 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 410,866.00 410,866.00 25,205.59 349,759.54 85.127 61,106.46 135-50010-020-000 Overtime 30,000.00 30,000.00 2,706.07 33,380.39 111.268 3,380.39- 135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 100.000 135-50017-020-000 Certification 8,400.00 8,400.00 700.00 8,436.00 100.429 36.00- 135-50020-020-000 Retirement 42,243.00 42,243.00 2,646.58 38,360.85 90.810 3,882.15 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 65,584.02 105.483 3,409.02- 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 371.89 4,691.74 89.010 579.26 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 802.86 72.070 311.14 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 321.20 4,168.88 97.381 112.12 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,593.24 22,807.95 80.554 5,506.05 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 372.62 5,334.11 80.551 1,287.89 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,134.00 90.000 126.00 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 16,176.00 89.917 1,814.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 38.00 273.00 91.000 27.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 40,880.78 558,324.34 89.104 68,276.66 135-55070-020-000 Independent Labor 20,550.00 5,550.00 2,145.00 38.649 3,405.00 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 4,747.50 82,754.50 96.114 3,345.50 135-55085-020-000 Generator Maint. and Repair 14,000.00 14,000.00 28.78 .206 13,971.22 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 149.70 9,821.71 122.771 1,821.71- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 395.40 79.080 104.60 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 3,359.30 68,016.07 113.360 8,016.07- 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,286.00 31,558.02 105.193 1,558.02- Subtotal: 219,150.00 204,150.00 10,542.50 194,719.48 95.381 9,430.52 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 381.26 4,843.51 103.053 143.51- 135-60020-020-000 Electricity 266,709.00 176,709.00 13,857.87 161,570.67 91.433 15,138.33 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 60.00 20.000 240.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 658.00 11.591 5,019.00 135-60090-020-000 Safety Program 550.00 550.00 351.72 63.949 198.28 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 90.46 5.533 1,544.54 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 5,000.00 5,000.00 5,000.00 135-60135-020-000 TCEQ Fees & Permits 85,000.00 85,000.00 30,272.52 35.615 54,727.48 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 .01 .002 449.99 135-60280-020-000 Property Maintenance 4,000.00 4,000.00 231.73 273.61 6.840 3,726.39 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 590.00 8,730.00 75.259 2,870.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 122,043.00 100.000 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 598,738.00 100.000 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 123,336.00 100.000 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60334-020-000 Interfund Transfer Out 200,000.00 944,512.00 27,213.59 671,726.04 71.119 272,785.96 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 1,762.00 44.050 2,238.00 Subtotal: 1,438,938.00 2,093,450.00 52,552.45 1,724,455.54 82.374 368,994.46 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 812.01 8,932.87 71.463 3,567.13 135-65010-020-000 Uniforms 4,459.00 4,459.00 1,075.40 2,929.97 65.709 1,529.03 135-65030-020-000 Chemicals 27,500.00 27,500.00 4,957.86 19,715.59 71.693 7,784.41 135-65035-020-000 Small Tools 1,000.00 1,000.00 1,436.14 143.614 436.14- 135-65040-020-000 Safety Equipment 750.00 750.00 1,157.50 154.333 407.50- 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 1,872.67 20,747.74 148.198 6,747.74- Subtotal: 60,209.00 60,209.00 8,717.94 54,919.81 91.215 5,289.19 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 85.00 108,729.29 19.866 438,597.71 135-69008-020-000 Short Term Debt-Principal 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 3,010.73 39.756 4,562.27 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 636,242.00 584,900.00 85.00 141,740.02 24.233 443,159.98 Program number: 2,981,140.00 3,569,310.00 112,778.67 2,674,159.19 74.921 895,150.81 Department number: Wastewater 2,981,140.00 3,569,310.00 112,778.67 2,674,159.19 74.921 895,150.81 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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.38 29.00 96.667 1.00 Subtotal: 30.00 30.00 2.38 29.00 96.667 1.00 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 600.00 600.00 650.00 108.333 50.00- 135-60075-026-000 Meetings 1,200.00 1,200.00 31.74 135.00 11.250 1,065.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 2,755.00 68.875 1,245.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 4,768.22 95.364 231.78 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,473.98 73.699 526.02 Subtotal: 12,950.00 12,950.00 31.74 9,782.20 75.538 3,167.80 Program number: 12,980.00 12,980.00 34.12 9,811.20 75.587 3,168.80 Department number: Board of Directors 12,980.00 12,980.00 34.12 9,811.20 75.587 3,168.80 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 432,863.00 432,863.00 31,785.74 368,987.21 85.243 63,875.79 135-50010-030-000 Overtime 2,000.00 2,000.00 2.95 566.00 28.300 1,434.00 135-50016-030-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50020-030-000 Retirement 40,553.00 40,553.00 2,940.44 36,818.75 90.792 3,734.25 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 47,490.83 74.806 15,994.17 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 3,276.89 59.558 2,225.11 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 589.88 50.288 583.12 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 282.49 3,716.55 73.464 1,342.45 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,892.22 22,201.40 81.680 4,979.60 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 442.53 5,192.25 81.678 1,164.75 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 6.23 1,145.77 90.934 114.23 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 1,482.00 96.926 47.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 211.90 42.380 288.10 135-50070-030-000 Employee Relations 4,960.00 4,960.00 3,273.18 65.992 1,686.82 Subtotal: 595,970.00 595,970.00 41,923.37 498,500.11 83.645 97,469.89 135-55030-030-000 Software & Support 78,391.00 78,391.00 1,929.11 68,007.47 86.754 10,383.53 135-55070-030-000 Independent Labor 154,000.00 154,000.00 14,150.30 153,669.10 99.785 330.90 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 5,183.13 10,583.61 75.597 3,416.39 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 4,624.58 46.246 5,375.42 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 9,176.75 91.768 823.25 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 3,060.00 62,300.00 98.381 1,025.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 1,170.74 7,062.54 78.473 1,937.46 Subtotal: 338,916.00 338,916.00 26,362.34 315,424.05 93.069 23,491.95 135-60005-030-000 Telephone 27,300.00 17,300.00 3,016.78 18,245.89 105.468 945.89- 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.33 2,986.16 74.654 1,013.84 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 602.05 6,590.97 40.532 9,670.03 135-60025-030-000 Water 2,500.00 2,500.00 58.32 718.83 28.753 1,781.17 135-60035-030-000 Postage 30,000.00 30,000.00 3,270.58 21,120.05 70.400 8,879.95 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 6,639.91 62,305.61 112.141 6,745.61- 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 56,000.00 56,000.00 6,100.33 76,999.29 137.499 20,999.29- 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 153.40 359.78 22.486 1,240.22 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 3,988.42 66.474 2,011.58 135-60075-030-000 Meetings 400.00 400.00 133.56 33.390 266.44 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 7,600.00 7,600.00 3,238.00 42.605 4,362.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 5.78 1,677.10 34.332 3,207.90 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 4,500.00 4,500.00 220.00 4.889 4,280.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 625.00 925.00 37.000 1,575.00 135-60235-030-000 Security 2,700.00 2,700.00 24.00 442.00 16.370 2,258.00 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 124.50 24.900 375.50 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 100.000 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 8.480 2,288.01 Subtotal: 249,506.00 239,506.00 20,733.48 217,287.15 90.723 22,218.85 135-65010-030-000 Uniforms 700.00 700.00 473.72 747.45 106.779 47.45- 135-65055-030-000 Hardware 7,420.00 7,420.00 4,795.74 6,802.42 91.677 617.58 135-65085-030-000 Office Supplies 7,000.00 7,000.00 1,082.36 5,331.03 76.158 1,668.97 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 2,365.05 118.253 365.05- 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 401.91 4,198.62 104.966 198.62- 135-65105-030-000 Printing 4,000.00 4,000.00 144.00 3.600 3,856.00 Subtotal: 25,120.00 25,120.00 6,753.73 19,588.57 77.980 5,531.43 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 48,354.99 371.961 35,354.99- 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 668.74 3,231.05 70.240 1,368.95 Subtotal: 17,600.00 17,600.00 668.74 51,586.04 293.103 33,986.04- Program number: 1,227,112.00 1,217,112.00 96,441.66 1,102,385.92 90.574 114,726.08 Department number: Administration 1,227,112.00 1,217,112.00 96,441.66 1,102,385.92 90.574 114,726.08 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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 26,092.31 148,454.21 108.361 11,454.21- 135-55055-039-000 Auditing 24,500.00 24,500.00 25,658.70 104.729 1,158.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 2,011.87 10,695.79 93.446 750.21 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 78.116 831.60 Subtotal: 176,746.00 176,746.00 28,104.18 187,777.10 106.241 11,031.10- Program number: 176,746.00 176,746.00 28,104.18 187,777.10 106.241 11,031.10- Department number: Non Departmental 176,746.00 176,746.00 28,104.18 187,777.10 106.241 11,031.10- Expenditures Subtotal ----------- 10,055,411.00 10,560,720.00 540,021.60- 7,954,105.30 75.318 2,606,614.70 Fund number: 135 MUD 1 General Fund 194,618.00- 539,854.00- 268,509.02- 2,302,430.71- 426.491 1,762,576.71 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 22:50 10/11/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal ----------- 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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 2153 09/04/2018 Property Taxes (122,269.80) (6.28) (122,276.08) GL 2154 09/28/2018 Property Taxes (2.80) (122,278.88) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (9.08) (122,278.88) ** (120,950.00) Budgeted 1,328.88 Remaining 101 % Used Account: 135-40002-000-000 Property Taxes/Delinquent (347.07) .00 (347.07) _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: .00 (347.07) ** (200.00) Budgeted 147.07 Remaining 174 % Used Account: 135-40015-000-000 Property Taxes/P & I 2153 09/04/2018 Property Taxes (529.34) (.44) (529.78) GL 2154 09/28/2018 Property Taxes (.55) (530.33) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (.99) (530.33) ** (200.00) Budgeted 330.33 Remaining 265 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (177,839.00) Budgeted (177,839.00) Remaining 0 % Used Account: 135-47000-000-000 Water 2103 09/18/2018 UB 09/18/2018 Payment Adjustme UB20180918-20180918 User: (5,463,687.82) 289.03 (5,463,398.79) UB 2115 09/24/2018 UB 09/24/2018 Water adjustment UB20180924-20180924 User: 239.94 (5,463,158.85) UB 2150 09/25/2018 222 oak Hill drive UB20180925-20180925 User: 534.48 (5,462,624.37) UB 2138 09/28/2018 Acct rfd-2850 Sherwood UB20180928-20180928 User: 439.89 (5,462,184.48) UB 2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (490,956.11) (5,953,140.59) UB _______________ Account: 135-47000-000-000 Water Totals: (489,452.77) (5,953,140.59) ** (6,464,019.00) Budgeted (510,878.41) Remaining 92 % Used Account: 135-47005-000-000 Sewer 2150 09/25/2018 222 oak Hill drive UB20180925-20180925 User: (2,734,037.65) 79.12 (2,733,958.53) UB . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (2,734,037.65) (258,741.46) (2,992,699.99) UB _______________ Account: 135-47005-000-000 Sewer Totals: (258,662.34) (2,992,699.99) ** (2,978,067.00) Budgeted 14,632.99 Remaining 100 % Used Account: 135-47025-000-000 Penalties 2026 09/06/2018 UB 09/06/2018 Penalty removal UB20180906-20180906 User: (103,287.09) 88.14 (103,198.95) UB 2109 09/21/2018 UB 09/21/2018 Penalties UB20180921-20180921 User: (22,752.51) (125,951.46) UB 2122 09/25/2018 UB 09/25/2018 Penalty removal UB20180925-20180925 User: 142.27 (125,809.19) UB 2129 09/27/2018 UB 09/27/2018 Penalty removal UB20180927-20180927 User: 6,157.89 (119,651.30) UB 2133 09/27/2018 UB 09/27/2018 Penalty Removal UB20180927-20180927 User: 43.53 (119,607.77) UB 2137 09/28/2018 UB 09/28/2018 Penalty removal UB20180928-20180928 User: 14.15 (119,593.62) UB _______________ Account: 135-47025-000-000 Penalties Totals: (16,306.53) (119,593.62) ** (106,279.00) Budgeted 13,314.62 Remaining 113 % Used Account: 135-47030-000-000 Service Charges 2005 09/05/2018 UB 09/05/2018 Disconnect Fees UB20180905-20180905 User: (12,330.50) (1,500.00) (13,830.50) UB 2107 09/20/2018 UB 09/20/2018 NSF check UB20180920-20180920 User: (25.00) (13,855.50) UB 2106 09/21/2018 UB 09/21/2018 NSF check UB20180921-20180921 User: (25.00) (13,880.50) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,550.00) (13,880.50) ** (14,350.00) Budgeted (469.50) Remaining 97 % Used Account: 135-47035-000-000 Plumbing Inspections 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 650 Sheldon drive (2,050.00) (50.00) (2,100.00) Ashton Wood Homes CR 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 4 Sadie Court (50.00) (2,150.00) Drees Homes CR 2180 09/30/2018 Permits 26 Katie Lane 26 Katie Lane (50.00) (2,200.00) Drees Custom CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (2,200.00) ** (1,500.00) Budgeted 700.00 Remaining 147 % Used Account: 135-47045-000-000 Sewer Inspections 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 650 Sheldon drive (5,350.00) (150.00) (5,500.00) Ashton Wood Homes CR 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 4 Sadie Court (150.00) (5,650.00) Drees Homes CR 2180 09/30/2018 Permits 26 Katie Lane 26 Katie Lane (150.00) (5,800.00) Drees Custom CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (5,800.00) ** (4,500.00) Budgeted 1,300.00 Remaining 129 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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-47070-000-000 TCCC Effluent Charges 2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (76,585.60) (5,025.60) (81,611.20) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (5,025.60) (81,611.20) ** (60,000.00) Budgeted 21,611.20 Remaining 136 % Used Account: 135-49010-000-000 Interest Income 2155 09/30/2018 Bank Interest- September (50,413.16) (457.98) (50,871.14) GL 2155 09/30/2018 Bank Interest- September (7,286.80) (58,157.94) GL 2155 09/30/2018 Bank Interest- September (857.44) (59,015.38) GL 2171 09/30/2018 Recode THB CD Int from 06/18 158.92 (58,856.46) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (8,443.30) (58,856.46) ** (50,000.00) Budgeted 8,856.46 Remaining 118 % Used Account: 135-49016-000-000 Cell Tower Revenue 2158 09/28/2018 Cell Tower Rev AT&T September (10,898.63) (1,178.81) (12,077.44) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (12,077.44) ** (10,926.00) Budgeted 1,151.44 Remaining 111 % Used Account: 135-49018-000-000 Building Rent Income 2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (6,416.63) (583.36) (6,999.99) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.36) (6,999.99) ** (7,000.00) Budgeted (.01) Remaining 100 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (15,400.00) .00 (15,400.00) _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (15,400.00) ** (15,400.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 650 Sheldon drive (13,207.76) (343.00) (13,550.76) Ashton Wood Homes CR 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 4 Sadie Court (343.00) (13,893.76) Drees Homes CR 2180 09/30/2018 Permits 26 Katie Lane 26 Katie Lane (343.00) (14,236.76) Drees Custom CR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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-49075-000-000 Oversize Meter Reimbursement Totals: (1,029.00) (14,236.76) ** (18,179.00) Budgeted (3,942.24) Remaining 78 % Used Account: 135-49141-000-000 Interfund Transfer In 2065 09/30/2018 Correct Intrfd Trnsfr 519/135 (1,851,769.22) 1,053,935.08 (797,834.14) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: 1,053,935.08 (797,834.14) ** (796,145.00) Budgeted 1,689.14 Remaining 100 % Used Account: 135-49900-000-000 Miscellaneous Income 2138 09/28/2018 Acct rfd-2850 Sherwood UB20180928-20180928 User: (59,466.32) 550.00 (58,916.32) UB 2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (130.72) (59,047.04) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: 419.28 (59,047.04) ** (15,000.00) Budgeted 44,047.04 Remaining 394 % Used Account: 135-49901-000-000 Records Management Revenue (2.00) .00 (2.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (2.00) ** (20.00) Budgeted (18.00) Remaining 10 % Used Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (10,256,536.01) ** 271,512.58 Monthly Total (11,100,574.00) Budgeted (844,037.99) Remaining 92 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 2004 09/07/2018 MUD Payroll 09/07/2018 Salaries & Wages 208,188.25 10,140.46 218,328.71 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Salaries & Wages 15,955.26 234,283.97 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 26,095.72 234,283.97 ** 274,279.00 Budgeted 39,995.03 Remaining 85 % Used Account: 135-50010-010-000 Overtime 2004 09/07/2018 MUD Payroll 09/07/2018 Overtime 12,941.85 872.68 13,814.53 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Overtime 318.48 14,133.01 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,191.16 14,133.01 ** 20,000.00 Budgeted 5,866.99 Remaining 71 % Used Account: 135-50016-010-000 Longevity 3,310.00 .00 3,310.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,310.00 ** 3,425.00 Budgeted 115.00 Remaining 97 % Used Account: 135-50017-010-000 Certification 2089 09/21/2018 MUD Payroll 09/21/2018 Certification 2,225.00 200.00 2,425.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 2,425.00 ** 3,300.00 Budgeted 875.00 Remaining 73 % Used Account: 135-50020-010-000 Retirement 2004 09/07/2018 MUD Payroll 09/07/2018 Retirement 22,376.48 1,018.71 23,395.19 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Retirement 1,523.83 24,919.02 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,542.54 24,919.02 ** 27,843.00 Budgeted 2,923.98 Remaining 89 % Used Account: 135-50026-010-000 Medical Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Medical Insurance 29,866.96 1,474.40 31,341.36 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medical Insurance 1,474.40 32,815.76 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 32,815.76 ** 52,196.00 Budgeted 19,380.24 Remaining 63 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Dental Insurance 2,375.64 106.85 2,482.49 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Dental Insurance 106.80 2,589.29 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 2,589.29 ** 5,182.00 Budgeted 2,592.71 Remaining 50 % Used Account: 135-50028-010-000 Vision Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Vision Insurance 423.91 17.98 441.89 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Vision Insurance 17.94 459.83 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 459.83 ** 994.00 Budgeted 534.17 Remaining 46 % Used Account: 135-50029-010-000 Life Insurance & Other 1930 09/01/2018 September A/P Employee benfits 2,339.54 110.60 2,450.14 Humana Inc 4481 AP 1981 09/01/2018 September A/P Employee benefits-September 87.01 2,537.15 METLIFE GROUP BENEFITS 4505 AP 2116 09/24/2018 September A/P Café 125 18.00 2,555.15 BenefitMall 4558 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 215.61 2,555.15 ** 2,982.00 Budgeted 426.85 Remaining 86 % Used Account: 135-50030-010-000 Social Security Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Social Security Taxes 13,953.81 675.78 14,629.59 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Social Security Taxes 1,009.32 15,638.91 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,685.10 15,638.91 ** 18,662.00 Budgeted 3,023.09 Remaining 84 % Used Account: 135-50035-010-000 Medicare Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Medicare Taxes 3,263.39 158.04 3,421.43 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medicare Taxes 236.06 3,657.49 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 394.10 3,657.49 ** 4,365.00 Budgeted 707.51 Remaining 84 % Used Account: 135-50040-010-000 Unemployment Taxes 818.68 .00 818.68 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 818.68 ** 1,080.00 Budgeted 261.32 Remaining 76 % Used Account: 135-50045-010-000 Workman's Compensation 243 09/01/2018 Insurance/Wrk Comp Exp Sep 9,899.12 899.88 10,799.00 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.88 10,799.00 ** 11,854.00 Budgeted 1,055.00 Remaining 91 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 285.05 .00 285.05 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 285.05 ** 200.00 Budgeted (85.05) Remaining 143 % Used Account: 135-50070-010-000 Employee Relations 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #1789 39.29 (1.19) 38.10 TOM THUMB #1789 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #1789 119.49 157.59 TOM THUMB #1789 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 DOLLARTREE 6.50 164.09 DOLLARTREE PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 WM SUPERCENTER #5247 14.04 178.13 WM SUPERCENTER #5247 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 138.84 178.13 ** 300.00 Budgeted 121.87 Remaining 59 % Used Account: 135-55080-010-000 Maintenance & Repairs 2116 09/24/2018 September A/P 15A chlorine nozzle 99,788.97 475.25 100,264.22 SCOOP 4586 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 19.12 100,283.34 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 8.28 100,291.62 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 25.59 100,317.21 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE AUTO SUPPLY LT 4.29 100,321.50 ROANOKE AUTO SUPPLY LT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE AUTO SUPPLY LT 199.99 100,521.49 ROANOKE AUTO SUPPLY LT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE AUTO SUPPLY LT 18.36 100,539.85 ROANOKE AUTO SUPPLY LT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 FERGUSON ENT 1241 (93.01) 100,446.84 FERGUSON ENT 1241 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 8.32 100,455.16 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TEX-TURF 185.60 100,640.76 TEX-TURF PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 6.96 100,647.72 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMAZON.COM*MT1MV3TD2 30.44 100,678.16 AMAZON.COM*MT1MV3TD2 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #3625 7.47 100,685.63 TOM THUMB #3625 PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 HOMEDEPOT.COM 99,788.97 26.24 100,711.87 HOMEDEPOT.COM PC 2152 09/30/2018 September A/P 2" ball valves 188.88 100,900.75 Core & Main LP 4631 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,111.78 100,900.75 ** 100,000.00 Budgeted (900.75) Remaining 101 % 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 2160 09/30/2018 September A/P Battery, washer fluid 5,068.27 147.97 5,216.24 NAPA AUTO PARTS 4643 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 147.97 5,216.24 ** 4,000.00 Budgeted (1,216.24) Remaining 130 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 35.00 .00 35.00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 35.00 ** 3,500.00 Budgeted 3,465.00 Remaining 1 % Used Account: 135-55135-010-000 Lab Analysis 2116 09/24/2018 September A/P Water samples 6,595.16 410.00 7,005.16 TARRANT CTY PUBLIC HEALTH LAB 4588 AP 2116 09/24/2018 September A/P TCEQ sampling 207.70 7,212.86 LOWER COLORADO RIVER AUTHORITY 4580 AP 2173 09/30/2018 September A/P water samples 200.00 7,412.86 TARRANT CTY PUBLIC HEALTH LAB 4657 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 817.70 7,412.86 ** 5,500.00 Budgeted (1,912.86) Remaining 135 % Used Account: 135-60010-010-000 Communications/Mobiles 2116 09/24/2018 September A/P Cell phones 3,602.72 369.91 3,972.63 VERIZON WIRELESS 4595 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 369.91 3,972.63 ** 4,700.00 Budgeted 727.37 Remaining 85 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-60020-010-000 Electricity 2117 09/24/2018 September A/P Electricity 125,080.91 15,109.51 140,190.42 HUDSON ENERGY SERVICES, LLC 4573 AP _______________ Account: 135-60020-010-000 Electricity Totals: 15,109.51 140,190.42 ** 150,000.00 Budgeted 9,809.58 Remaining 93 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 767.00 .00 767.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 767.00 ** 1,000.00 Budgeted 233.00 Remaining 77 % 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 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 NCTCOG RTC TRAINING 2,208.78 165.00 2,373.78 NCTCOG RTC TRAINING PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 NCTCOG RTC TRAINING 165.00 2,538.78 NCTCOG RTC TRAINING PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 PAYPAL *TEXASWATERW 350.00 2,888.78 PAYPAL *TEXASWATERW PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 680.00 2,888.78 ** 2,785.00 Budgeted (103.78) Remaining 104 % Used Account: 135-60090-010-000 Safety Program 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem 87.48 .00 87.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 24,220.32 .00 24,220.32 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 24,220.32 ** 55,176.00 Budgeted 30,955.68 Remaining 44 % Used Account: 135-60150-010-000 Wholesale Water 2116 09/24/2018 September A/P Water 1,870,342.92 291,820.90 2,162,163.82 CITY OF FORT WORTH 4562 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 291,820.90 2,162,163.82 ** 2,823,170.00 Budgeted 661,006.18 Remaining 77 % 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 974.70 .00 974.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 974.70 ** 3,000.00 Budgeted 2,025.30 Remaining 32 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2152 09/30/2018 September A/P September mowing 10,500.00 750.00 11,250.00 WATTS ELLISON LLC 4651 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 11,250.00 ** 14,750.00 Budgeted 3,500.00 Remaining 76 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 278,083.50 .00 278,083.50 _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: .00 278,083.50 ** 278,084.00 Budgeted .50 Remaining 100 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 2161 09/30/2018 Texpool Transfers September 44,913.00 4,083.00 48,996.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 48,996.00 ** 48,996.00 Budgeted .00 Remaining 100 % Used Account: 135-60334-010-000 Interfund Transfer Out 2065 09/30/2018 Correct Intrfd Trnsfr 519/135 1,053,935.08 (1,053,935.08) .00 GL _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: (1,053,935.08) .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 5,019.66 .00 5,019.66 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 5,019.66 ** 2,500.00 Budgeted (2,519.66) Remaining 201 % Used Account: 135-65005-010-000 Fuel & Lube 2139 09/28/2018 September A/p Fuel 10,214.48 993.47 11,207.95 US Bank Voyager Fleet Systems 4607 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 993.47 11,207.95 ** 15,000.00 Budgeted 3,792.05 Remaining 75 % Used Account: 135-65010-010-000 Uniforms 2116 09/24/2018 September A/P uniforms 1,249.14 1,075.41 2,324.55 RON MONTGOMERY & ASSOC INC 4585 AP 2116 09/24/2018 September A/P uniforms 307.22 2,631.77 RON MONTGOMERY & ASSOC INC 4585 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 1,382.63 2,631.77 ** 4,488.00 Budgeted 1,856.23 Remaining 59 % Used Account: 135-65030-010-000 Chemicals . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2116 09/24/2018 September A/P Testing supplies 17,083.91 709.84 17,793.75 HACH COMPANY 4570 AP 2116 09/24/2018 September A/P Chlorine 893.45 18,687.20 DPC INDUSTRIES, INC 4568 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,603.29 18,687.20 ** 20,000.00 Budgeted 1,312.80 Remaining 93 % 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 1,080.95 .00 1,080.95 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 1,080.95 ** 1,000.00 Budgeted (80.95) Remaining 108 % Used Account: 135-65050-010-000 Meter Expense 24,975.75 .00 24,975.75 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 24,975.75 ** 50,000.00 Budgeted 25,024.25 Remaining 50 % Used Account: 135-65053-010-000 Meter Change Out Program 82,312.50 .00 82,312.50 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 82,312.50 ** 84,000.00 Budgeted 1,687.50 Remaining 98 % Used Account: 135-69005-010-000 Capital Outlays 2116 09/24/2018 September A/P 16" water line Phase I 590,375.89 115.26 590,491.15 Halff Associates, INC 4569 AP 2116 09/24/2018 September A/P 16" waterline Phase II 21,954.38 612,445.53 Halff Associates, INC 4569 AP 2116 09/24/2018 September A/P Scada panels 24,767.50 637,213.03 DHS AUTOMATION, INC 4566 AP 2123 09/25/2018 September A/P 16" water line phase I 1,543.00 638,756.03 Star-Telegram Media 4606 AP 2123 09/25/2018 September A/P Credit for double paying invoi (1,868.44) 636,887.59 Star-Telegram Media 4606 AP 2152 09/30/2018 September A/P Capitol projects 5,250.00 642,137.59 TEAGUE, NALL & PERKINS,INC 4647 AP 2174 09/30/2018 Due To/From -Fund 520 Sept 18 (157,313.85) 484,823.74 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2179 09/30/2018 September A/P 16" water line 590,375.89 26,307.82 511,131.56 Halff Associates, INC 4661 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: (79,244.33) 511,131.56 ** 1,085,012.00 Budgeted 573,880.44 Remaining 47 % Used Account: 135-69009-010-000 Short Term Debt-Interest 2,271.24 .00 2,271.24 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 2,271.24 ** 5,713.00 Budgeted 3,441.76 Remaining 40 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 107,864.38 .00 107,864.38 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 ** 110,001.00 Budgeted 2,136.62 Remaining 98 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/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 2116 09/24/2018 September A/P water samples 1,385.08 80.00 1,465.08 TARRANT CTY PUBLIC HEALTH LAB 4588 AP 2116 09/24/2018 September A/P TCEQ samples PID 207.70 1,672.78 LOWER COLORADO RIVER AUTHORITY 4580 AP 2173 09/30/2018 September A/P Water samples-PID 80.00 1,752.78 TARRANT CTY PUBLIC HEALTH LAB 4657 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 367.70 1,752.78 ** 2,000.00 Budgeted 247.22 Remaining 88 % Used Department 10 Totals: ----------------------------------- 3,979,971.89 ** (777,380.23) Monthly Total 5,584,572.00 Budgeted 1,604,600.11 Remaining 71 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 2004 09/07/2018 MUD Payroll 09/07/2018 Salaries & Wages 324,553.95 12,602.79 337,156.74 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Salaries & Wages 12,602.80 349,759.54 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 25,205.59 349,759.54 ** 410,866.00 Budgeted 61,106.46 Remaining 85 % Used Account: 135-50010-020-000 Overtime 2004 09/07/2018 MUD Payroll 09/07/2018 Overtime 30,674.32 1,521.28 32,195.60 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Overtime 1,184.79 33,380.39 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,706.07 33,380.39 ** 30,000.00 Budgeted (3,380.39) Remaining 111 % Used Account: 135-50016-020-000 Longevity 7,415.00 .00 7,415.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 7,415.00 ** 7,415.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 2089 09/21/2018 MUD Payroll 09/21/2018 Certification 7,736.00 700.00 8,436.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 8,436.00 ** 8,400.00 Budgeted (36.00) Remaining 100 % Used Account: 135-50020-020-000 Retirement 2004 09/07/2018 MUD Payroll 09/07/2018 Retirement 35,714.27 1,306.48 37,020.75 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Retirement 1,340.10 38,360.85 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,646.58 38,360.85 ** 42,243.00 Budgeted 3,882.15 Remaining 91 % Used Account: 135-50026-020-000 Medical Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Medical Insurance 60,065.33 2,759.36 62,824.69 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medical Insurance 2,759.33 65,584.02 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,518.69 65,584.02 ** 62,175.00 Budgeted (3,409.02) Remaining 105 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Dental Insurance 4,319.85 185.96 4,505.81 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Dental Insurance 185.93 4,691.74 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 4,691.74 ** 5,271.00 Budgeted 579.26 Remaining 89 % Used Account: 135-50028-020-000 Vision Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Vision Insurance 743.96 29.46 773.42 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Vision Insurance 29.44 802.86 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 802.86 ** 1,114.00 Budgeted 311.14 Remaining 72 % Used Account: 135-50029-020-000 Life Insurance & Other 1930 09/01/2018 September A/P Employee benfits 3,847.68 164.36 4,012.04 Humana Inc 4481 AP 1981 09/01/2018 September A/P Employee benefits-September 120.84 4,132.88 METLIFE GROUP BENEFITS 4505 AP 2116 09/24/2018 September A/P Café 125 36.00 4,168.88 BenefitMall 4558 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 321.20 4,168.88 ** 4,281.00 Budgeted 112.12 Remaining 97 % Used Account: 135-50030-020-000 Social Security Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Social Security Taxes 21,214.71 796.78 22,011.49 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Social Security Taxes 796.46 22,807.95 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,593.24 22,807.95 ** 28,314.00 Budgeted 5,506.05 Remaining 81 % Used Account: 135-50035-020-000 Medicare Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Medicare Taxes 4,961.49 186.36 5,147.85 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medicare Taxes 186.26 5,334.11 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 372.62 5,334.11 ** 6,622.00 Budgeted 1,287.89 Remaining 81 % Used Account: 135-50040-020-000 Unemployment Taxes 1,134.00 .00 1,134.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,134.00 ** 1,260.00 Budgeted 126.00 Remaining 90 % Used Account: 135-50045-020-000 Workman's Compensation 243 09/01/2018 Insurance/Wrk Comp Exp Sep 14,828.00 1,348.00 16,176.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 16,176.00 ** 17,990.00 Budgeted 1,814.00 Remaining 90 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 2116 09/24/2018 September A/P employee drug screen-Frank Iso 235.00 38.00 273.00 CARENOW CORPORATE 4560 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 38.00 273.00 ** 300.00 Budgeted 27.00 Remaining 91 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 2,145.00 .00 2,145.00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 2,145.00 ** 5,550.00 Budgeted 3,405.00 Remaining 39 % Used Account: 135-55080-020-000 Maintenance & Repairs 2034 09/07/2018 September A/P Lift station uPS 78,007.00 492.25 78,499.25 DHS AUTOMATION, INC 4534 AP 2034 09/07/2018 September A/P Lift station UPS 752.25 79,251.50 DHS AUTOMATION, INC 4534 AP 2116 09/24/2018 September A/P Bags for augers 1,200.00 80,451.50 Huber Technology Inc 4571 AP 2116 09/24/2018 September A/P LS #3 pump parts 1,330.16 81,781.66 SMITH PUMP COMPANY, INC. 4587 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TELEDYNE INSTRUMENTS I (3.88) 81,777.78 TELEDYNE INSTRUMENTS I PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE WINNELSON CO 25.28 81,803.06 ROANOKE WINNELSON CO PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMAZON.COM 515.50 82,318.56 AMAZON.COM PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TELEDYNE INSTRUMENTS I (27.78) 82,290.78 TELEDYNE INSTRUMENTS I PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 48.76 82,339.54 THE HOME DEPOT #6581 PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TRACTOR SUPPLY COMPANY 78,007.00 29.99 82,369.53 TRACTOR SUPPLY COMPANY PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT 6581 99.83 82,469.36 THE HOME DEPOT 6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROYAL BRASS AND HOSE 36.62 82,505.98 ROYAL BRASS AND HOSE PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 8.70 82,514.68 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 23.61 82,538.29 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 17.40 82,555.69 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TRACTOR SUPPLY COMPANY 35.79 82,591.48 TRACTOR SUPPLY COMPANY PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 FERGUSON ENT 1241 163.02 82,754.50 FERGUSON ENT 1241 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 4,747.50 82,754.50 ** 86,100.00 Budgeted 3,345.50 Remaining 96 % Used Account: 135-55085-020-000 Generator Maint. and Repair 28.78 .00 28.78 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 28.78 ** 14,000.00 Budgeted 13,971.22 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 2152 09/30/2018 September A/P Clamps for vac truck 9,672.01 149.70 9,821.71 CLS SEWER EQUIPMENT CO., INC 4630 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 149.70 9,821.71 ** 8,000.00 Budgeted (1,821.71) Remaining 123 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 395.40 .00 395.40 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 395.40 ** 500.00 Budgeted 104.60 Remaining 79 % Used Account: 135-55125-020-000 Dumpster Services 2117 09/24/2018 September A/P Dumpster services 64,656.77 914.29 65,571.06 L.H. CHANEY MATERIALS, INC. 4578 AP 2140 09/28/2018 September A/P dumpster services 849.65 66,420.71 L.H. CHANEY MATERIALS, INC. 4599 AP 2152 09/30/2018 September A/P Dumpster service 1,595.36 68,016.07 L.H. CHANEY MATERIALS, INC. 4641 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,359.30 68,016.07 ** 60,000.00 Budgeted (8,016.07) Remaining 113 % Used Account: 135-55135-020-000 Lab Analysis . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2020 09/05/2018 September A/P Effluent testing 29,272.02 246.00 29,518.02 OXIDOR LABORATORIES LLC 4521 AP 2020 09/05/2018 September A/P effluent testing 176.00 29,694.02 OXIDOR LABORATORIES LLC 4521 AP 2116 09/24/2018 September A/P Lab samples 246.00 29,940.02 OXIDOR LABORATORIES LLC 4584 AP 2116 09/24/2018 September A/P lab samples 176.00 30,116.02 OXIDOR LABORATORIES LLC 4584 AP 2116 09/24/2018 September A/P Lab testing 176.00 30,292.02 OXIDOR LABORATORIES LLC 4584 AP 2116 09/24/2018 September A/P Lab testing 246.00 30,538.02 OXIDOR LABORATORIES LLC 4584 AP 2140 09/28/2018 September A/P lab testing 176.00 30,714.02 OXIDOR LABORATORIES LLC 4605 AP 2140 09/28/2018 September A/P Lab testing 221.00 30,935.02 OXIDOR LABORATORIES LLC 4605 AP 2140 09/28/2018 September A/P lab testing 201.00 31,136.02 OXIDOR LABORATORIES LLC 4605 AP 2160 09/30/2018 September A/P lb testing 176.00 31,312.02 OXIDOR LABORATORIES LLC 4645 AP 2160 09/30/2018 September A/P lab testing 246.00 31,558.02 OXIDOR LABORATORIES LLC 4645 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,286.00 31,558.02 ** 30,000.00 Budgeted (1,558.02) Remaining 105 % Used Account: 135-60010-020-000 Communications/Mobiles 2116 09/24/2018 September A/P Cell phones 4,462.25 381.26 4,843.51 VERIZON WIRELESS 4595 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 381.26 4,843.51 ** 4,700.00 Budgeted (143.51) Remaining 103 % Used Account: 135-60020-020-000 Electricity 2116 09/24/2018 September A/P Electricity 7/26-8/24 147,712.80 63.88 147,776.68 TRI COUNTY ELECTRIC 4592 AP 2116 09/24/2018 September A/P Electricity 7/26-8/24 300.10 148,076.78 TRI COUNTY ELECTRIC 4592 AP 2116 09/24/2018 September A/P Electricity 7/26-8/24 27.83 148,104.61 TRI COUNTY ELECTRIC 4592 AP 2117 09/24/2018 September A/P Electricity 13,069.48 161,174.09 HUDSON ENERGY SERVICES, LLC 4573 AP 2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (201.74) 160,972.35 AR 2178 09/30/2018 September A/P Electricity 8/24-9/25 168.73 161,141.08 TRI COUNTY ELECTRIC 4659 AP 2178 09/30/2018 September A/P Electricity 8/24-9/25 400.45 161,541.53 TRI COUNTY ELECTRIC 4659 AP 2178 09/30/2018 September A/P Electricity 8/24-9/25 29.14 161,570.67 TRI COUNTY ELECTRIC 4659 AP _______________ Account: 135-60020-020-000 Electricity Totals: 13,857.87 161,570.67 ** 176,709.00 Budgeted 15,138.33 Remaining 91 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-020-000 Dues & Memberships 60.00 .00 60.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 60.00 ** 300.00 Budgeted 240.00 Remaining 20 % Used Account: 135-60080-020-000 Schools & Training 658.00 .00 658.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 658.00 ** 5,677.00 Budgeted 5,019.00 Remaining 12 % Used Account: 135-60090-020-000 Safety Program 351.72 .00 351.72 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 351.72 ** 550.00 Budgeted 198.28 Remaining 64 % Used Account: 135-60100-020-000 Travel & per diem 90.46 .00 90.46 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 90.46 ** 1,635.00 Budgeted 1,544.54 Remaining 6 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 30,272.52 .00 30,272.52 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 30,272.52 ** 85,000.00 Budgeted 54,727.48 Remaining 36 % Used Account: 135-60245-020-000 Miscellaneous Expenses .01 .00 .01 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .01 ** 450.00 Budgeted 449.99 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 WM SUPERCENTER #5247 41.88 26.80 68.68 WM SUPERCENTER #5247 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TRACTOR SUPPLY COMPANY 204.93 273.61 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-60280-020-000 Property Maintenance Totals: 231.73 273.61 ** 4,000.00 Budgeted 3,726.39 Remaining 7 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 2152 09/30/2018 September A/P September mowing 8,140.00 590.00 8,730.00 WATTS ELLISON LLC 4651 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 8,730.00 ** 11,600.00 Budgeted 2,870.00 Remaining 75 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 .00 122,043.00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 122,043.00 ** 122,043.00 Budgeted .00 Remaining 100 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 .00 598,738.00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 598,738.00 ** 598,738.00 Budgeted .00 Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2161 09/30/2018 Texpool Transfers September 113,058.00 10,278.00 123,336.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 123,336.00 ** 123,336.00 Budgeted .00 Remaining 100 % Used Account: 135-60334-020-000 Interfund Transfer Out 2161 09/30/2018 Texpool Transfers September 644,512.45 27,213.59 671,726.04 GL _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: 27,213.59 671,726.04 ** 944,512.00 Budgeted 272,785.96 Remaining 71 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1,762.00 .00 1,762.00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,762.00 ** 4,000.00 Budgeted 2,238.00 Remaining 44 % Used Account: 135-65005-020-000 Fuel & Lube 2139 09/28/2018 September A/p Fuel 8,120.86 812.01 8,932.87 US Bank Voyager Fleet Systems 4607 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 812.01 8,932.87 ** 12,500.00 Budgeted 3,567.13 Remaining 71 % Used Account: 135-65010-020-000 Uniforms 2116 09/24/2018 September A/P uniforms 1,854.57 1,075.40 2,929.97 RON MONTGOMERY & ASSOC INC 4585 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 1,075.40 2,929.97 ** 4,459.00 Budgeted 1,529.03 Remaining 66 % Used Account: 135-65030-020-000 Chemicals 2116 09/24/2018 September A/P CIP solution 14,757.73 536.00 15,293.73 Valley Solvent Company, INC 4594 AP 2117 09/24/2018 September A/P Collection chemicals 3,379.50 18,673.23 MICKEY D CARSON DBA/NUSCO 4582 AP 2140 09/28/2018 September A/P CIP solution 1,042.36 19,715.59 Valley Solvent Company, INC 4608 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 4,957.86 19,715.59 ** 27,500.00 Budgeted 7,784.41 Remaining 72 % Used Account: 135-65035-020-000 Small Tools . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,436.14 .00 1,436.14 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 1,436.14 ** 1,000.00 Budgeted (436.14) Remaining 144 % Used Account: 135-65040-020-000 Safety Equipment 1,157.50 .00 1,157.50 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 1,157.50 ** 750.00 Budgeted (407.50) Remaining 154 % Used Account: 135-65045-020-000 Lab Supplies 2116 09/24/2018 September A/P Lab supplies 18,875.07 352.74 19,227.81 HACH COMPANY 4570 AP 2116 09/24/2018 September A/P Sampling supplies 1,318.20 20,546.01 IDEXX DISTRIBUTION, INC 4574 AP 2116 09/24/2018 September A/P sampling supplies 197.77 20,743.78 IDEXX DISTRIBUTION, INC 4574 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #1789 3.96 20,747.74 TOM THUMB #1789 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,872.67 20,747.74 ** 14,000.00 Budgeted (6,747.74) Remaining 148 % Used Account: 135-69005-020-000 Capital Outlays 2140 09/28/2018 September A/P Legal WWTP 108,644.29 85.00 108,729.29 Dubois Bryant Campbell LLP 4598 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 85.00 108,729.29 ** 547,327.00 Budgeted 438,597.71 Remaining 20 % Used Account: 135-69009-020-000 Short Term Debt-Interest 3,010.73 .00 3,010.73 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 3,010.73 ** 7,573.00 Budgeted 4,562.27 Remaining 40 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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: ----------------------------------- 2,674,159.19 ** 112,778.67 Monthly Total 3,569,310.00 Budgeted 895,150.81 Remaining 75 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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 243 09/01/2018 Insurance/Wrk Comp Exp Sep 26.62 2.38 29.00 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.38 29.00 ** 30.00 Budgeted 1.00 Remaining 97 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 650.00 .00 650.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 650.00 ** 600.00 Budgeted (50.00) Remaining 108 % Used Account: 135-60075-026-000 Meetings 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #2580 103.26 31.74 135.00 TOM THUMB #2580 PC _______________ Account: 135-60075-026-000 Meetings Totals: 31.74 135.00 ** 1,200.00 Budgeted 1,065.00 Remaining 11 % Used Account: 135-60080-026-000 Schools & Training 2,755.00 .00 2,755.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 2,755.00 ** 4,000.00 Budgeted 1,245.00 Remaining 69 % Used Account: 135-60100-026-000 Travel & per diem 4,768.22 .00 4,768.22 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 4,768.22 ** 5,000.00 Budgeted 231.78 Remaining 95 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,473.98 .00 1,473.98 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,473.98 ** 2,000.00 Budgeted 526.02 Remaining 74 % Used Department 26 Totals: ----------------------------------- 9,811.20 ** 34.12 Monthly Total 12,980.00 Budgeted 3,168.80 Remaining 76 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 2004 09/07/2018 MUD Payroll 09/07/2018 Salaries & Wages 337,201.47 13,385.75 350,587.22 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Salaries & Wages 18,399.99 368,987.21 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 31,785.74 368,987.21 ** 432,863.00 Budgeted 63,875.79 Remaining 85 % Used Account: 135-50010-030-000 Overtime 2004 09/07/2018 MUD Payroll 09/07/2018 Overtime 563.05 2.95 566.00 PR _______________ Account: 135-50010-030-000 Overtime Totals: 2.95 566.00 ** 2,000.00 Budgeted 1,434.00 Remaining 28 % Used Account: 135-50016-030-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 2004 09/07/2018 MUD Payroll 09/07/2018 Retirement 33,878.31 1,238.44 35,116.75 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Retirement 1,702.00 36,818.75 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,940.44 36,818.75 ** 40,553.00 Budgeted 3,734.25 Remaining 91 % Used Account: 135-50026-030-000 Medical Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Medical Insurance 43,345.59 2,072.63 45,418.22 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medical Insurance 2,072.61 47,490.83 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 47,490.83 ** 63,485.00 Budgeted 15,994.17 Remaining 75 % Used Account: 135-50027-030-000 Dental Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Dental Insurance 3,017.37 129.78 3,147.15 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Dental Insurance 129.74 3,276.89 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 259.52 3,276.89 ** 5,502.00 Budgeted 2,225.11 Remaining 60 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-50028-030-000 Vision Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Vision Insurance 547.37 21.28 568.65 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Vision Insurance 21.23 589.88 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 589.88 ** 1,173.00 Budgeted 583.12 Remaining 50 % Used Account: 135-50029-030-000 Life Insurance & Other 1930 09/01/2018 September A/P Employee benfits 3,434.06 145.04 3,579.10 Humana Inc 4481 AP 1981 09/01/2018 September A/P Employee benefits-September 119.45 3,698.55 METLIFE GROUP BENEFITS 4505 AP 2116 09/24/2018 September A/P Café 125 18.00 3,716.55 BenefitMall 4558 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 282.49 3,716.55 ** 5,059.00 Budgeted 1,342.45 Remaining 73 % Used Account: 135-50030-030-000 Social Security Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Social Security Taxes 20,309.18 792.05 21,101.23 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Social Security Taxes 1,100.17 22,201.40 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,892.22 22,201.40 ** 27,181.00 Budgeted 4,979.60 Remaining 82 % Used Account: 135-50035-030-000 Medicare Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Medicare Taxes 4,749.72 185.25 4,934.97 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medicare Taxes 257.28 5,192.25 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 442.53 5,192.25 ** 6,357.00 Budgeted 1,164.75 Remaining 82 % Used Account: 135-50040-030-000 Unemployment Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Unemployment Taxes 1,139.54 6.23 1,145.77 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 6.23 1,145.77 ** 1,260.00 Budgeted 114.23 Remaining 91 % Used Account: 135-50045-030-000 Workman's Compensation 243 09/01/2018 Insurance/Wrk Comp Exp Sep 1,358.50 123.50 1,482.00 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-030-000 Workman's Compensation Totals: 123.50 1,482.00 ** 1,529.00 Budgeted 47.00 Remaining 97 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 211.90 .00 211.90 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 211.90 ** 500.00 Budgeted 288.10 Remaining 42 % Used Account: 135-50070-030-000 Employee Relations 3,273.18 .00 3,273.18 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 3,273.18 ** 4,960.00 Budgeted 1,686.82 Remaining 66 % Used Account: 135-55030-030-000 Software & Support 2116 09/24/2018 September A/P Internet-Sept 66,078.36 903.72 66,982.08 Charter Communications 4561 AP 2116 09/24/2018 September A/P Microsoft exchange 456.00 67,438.08 M3 Networks 4581 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 DNH*GODADDY.COM 149.98 67,588.06 DNH*GODADDY.COM PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 124.34 67,712.40 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 107.79 67,820.19 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 85.71 67,905.90 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 69.12 67,975.02 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ADOBE SYSTEMS INC 32.45 68,007.47 ADOBE SYSTEMS INC PC _______________ Account: 135-55030-030-000 Software & Support Totals: 1,929.11 68,007.47 ** 78,391.00 Budgeted 10,383.53 Remaining 87 % Used Account: 135-55070-030-000 Independent Labor 2140 09/28/2018 September A/P Video MUD meeting 139,518.80 577.50 140,096.30 MIGUEL CRUZ 4602 AP 2152 09/30/2018 September A/P GM September 13,530.80 153,627.10 Carman Consulting LLC. 4628 AP 2160 09/30/2018 September A/P taxes consulting 42.00 153,669.10 DRG ENTERPRISES 4634 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 14,150.30 153,669.10 ** 154,000.00 Budgeted 330.90 Remaining 100 % Used Account: 135-55080-030-000 Maintenance & Repairs . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2034 09/07/2018 September A/P rug cleaning reimbursement 5,400.48 166.29 5,566.77 TOWN OF TROPHY CLUB 4552 AP 2116 09/24/2018 September A/P Storage room building upgrade 4,716.84 10,283.61 3RD EYE SURVEILLANCE SYSTEMS 4555 AP 2116 09/24/2018 September A/P A/C admin 300.00 10,583.61 BRANDON R REED 4559 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 5,183.13 10,583.61 ** 14,000.00 Budgeted 3,416.39 Remaining 76 % Used Account: 135-55085-030-000 Generator Maint. and Repair 4,624.58 .00 4,624.58 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 4,624.58 ** 10,000.00 Budgeted 5,375.42 Remaining 46 % Used Account: 135-55120-030-000 Cleaning Services 2139 09/28/2018 September A/p Janitorial service 8,307.69 869.06 9,176.75 MEMBER'S BUILDING MAINTENANCE 4600 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 9,176.75 ** 10,000.00 Budgeted 823.25 Remaining 92 % Used Account: 135-55160-030-000 Professional Outside Services 2116 09/24/2018 September A/P FY 19 Rate consulting 59,240.00 3,060.00 62,300.00 NEW GEN STRATEGIES & SOLUTIONS 4583 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 3,060.00 62,300.00 ** 63,325.00 Budgeted 1,025.00 Remaining 98 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 2116 09/24/2018 September A/P August billings 5,891.80 585.74 6,477.54 DATAPROSE LLC 4565 AP 2160 09/30/2018 September A/P Water billings 585.00 7,062.54 DATAPROSE LLC 4633 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,170.74 7,062.54 ** 9,000.00 Budgeted 1,937.46 Remaining 78 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-60005-030-000 Telephone 2034 09/07/2018 September A/P Answering service-sept 15,229.11 195.12 15,424.23 KEYSTONE PARK SECRETARIAL 4541 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BUS PHONE PMT 858.55 16,282.78 ATT*BUS PHONE PMT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BUS PHONE PMT 449.92 16,732.70 ATT*BUS PHONE PMT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 190.36 16,923.06 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 RINGCENTRAL, INC 13.95 16,937.01 RINGCENTRAL, INC PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 GOVERNMENT FINANCE OFF 170.00 17,107.01 GOVERNMENT FINANCE OFF PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BUS PHONE PMT 460.33 17,567.34 ATT*BUS PHONE PMT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AT&T *PAYMENT 858.55 18,425.89 AT&T *PAYMENT PC 2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (180.00) 18,245.89 AR _______________ Account: 135-60005-030-000 Telephone Totals: 3,016.78 18,245.89 ** 17,300.00 Budgeted (945.89) Remaining 105 % Used Account: 135-60010-030-000 Communications/Mobiles 2089 09/21/2018 MUD Payroll 09/21/2018 Communications/Mobiles 2,748.83 150.00 2,898.83 PR 2116 09/24/2018 September A/P Cell phones 87.33 2,986.16 VERIZON WIRELESS 4595 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.33 2,986.16 ** 4,000.00 Budgeted 1,013.84 Remaining 75 % Used Account: 135-60020-030-000 Electricity/Gas 2152 09/30/2018 September A/P Electricity admin 7/11-8/10 5,988.92 602.05 6,590.97 TOWN OF TROPHY CLUB 4649 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 602.05 6,590.97 ** 16,261.00 Budgeted 9,670.03 Remaining 41 % Used Account: 135-60025-030-000 Water 2152 09/30/2018 September A/P Water-September 660.51 116.64 777.15 TROPHY CLUB MUD (WATER BILLS) 4650 AP 2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (58.32) 718.83 AR _______________ Account: 135-60025-030-000 Water Totals: 58.32 718.83 ** 2,500.00 Budgeted 1,781.17 Remaining 29 % Used Account: 135-60035-030-000 Postage 2116 09/24/2018 September A/P August billings 17,849.47 1,621.31 19,470.78 DATAPROSE LLC 4565 AP 2152 09/30/2018 September A/P Overnight- AT& T 5.50 19,476.28 FEDERAL EXPRESS CORP 4635 AP 2152 09/30/2018 September A/P Overnight-Denotn county tax 11.00 19,487.28 FEDERAL EXPRESS CORP 4635 AP 2160 09/30/2018 September A/P Water billings 1,632.77 21,120.05 DATAPROSE LLC 4633 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-60035-030-000 Postage Totals: 3,270.58 21,120.05 ** 30,000.00 Budgeted 8,879.95 Remaining 70 % Used Account: 135-60040-030-000 Service Charges & Fees 2006 09/07/2018 Child Support Fee 55,665.70 1.50 55,667.20 GL 2091 09/21/2018 Child Support Fee 1.50 55,668.70 GL 2152 09/30/2018 September A/P direct send fees 50.00 55,718.70 Fiserv Solutions, LLC 4636 AP 2156 09/30/2018 Pace Credit Card Fees 6,271.28 61,989.98 GL 2156 09/30/2018 Pace Credit Card Fees 128.40 62,118.38 GL 2160 09/30/2018 September A/P safety deposit box opening 187.23 62,305.61 Bank of the West 4627 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 6,639.91 62,305.61 ** 55,560.00 Budgeted (6,745.61) Remaining 112 % 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 243 09/01/2018 Insurance/Wrk Comp Exp Sep 70,898.96 6,100.33 76,999.29 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.33 76,999.29 ** 56,000.00 Budgeted (20,999.29) Remaining 137 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 NCTCOG AGENCY SRVCS 206.38 153.40 359.78 NCTCOG AGENCY SRVCS PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 153.40 359.78 ** 1,600.00 Budgeted 1,240.22 Remaining 22 % Used Account: 135-60070-030-000 Dues & Memberships 3,988.42 .00 3,988.42 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 3,988.42 ** 6,000.00 Budgeted 2,011.58 Remaining 66 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-60075-030-000 Meetings 133.56 .00 133.56 _______________ Account: 135-60075-030-000 Meetings Totals: .00 133.56 ** 400.00 Budgeted 266.44 Remaining 33 % 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 3,238.00 .00 3,238.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 3,238.00 ** 7,600.00 Budgeted 4,362.00 Remaining 43 % Used Account: 135-60100-030-000 Travel & per diem 2139 09/28/2018 September A/p Tolls 1,671.32 5.78 1,677.10 NTTA 4603 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 5.78 1,677.10 ** 4,885.00 Budgeted 3,207.90 Remaining 34 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 220.00 .00 220.00 _______________ Account: 135-60115-030-000 Elections Totals: .00 220.00 ** 4,500.00 Budgeted 4,280.00 Remaining 5 % Used Account: 135-60125-030-000 Advertising . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2123 09/25/2018 September A/P Public hearing tax notice 300.00 625.00 925.00 Star-Telegram Media 4606 AP _______________ Account: 135-60125-030-000 Advertising Totals: 625.00 925.00 ** 2,500.00 Budgeted 1,575.00 Remaining 37 % Used Account: 135-60235-030-000 Security 2116 09/24/2018 September A/P Monitoring service 418.00 24.00 442.00 Digital Air Control, Inc 4567 AP _______________ Account: 135-60235-030-000 Security Totals: 24.00 442.00 ** 2,700.00 Budgeted 2,258.00 Remaining 16 % Used Account: 135-60245-030-000 Miscellaneous Expenses 124.50 .00 124.50 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 124.50 ** 500.00 Budgeted 375.50 Remaining 25 % Used Account: 135-60246-030-000 General Manager Contingency 17,000.00 .00 17,000.00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 17,000.00 ** 17,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 211.99 .00 211.99 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 211.99 ** 2,500.00 Budgeted 2,288.01 Remaining 8 % Used Account: 135-65010-030-000 Uniforms 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 RED WING SHOES #652 273.73 169.99 443.72 RED WING SHOES #652 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 RED WING SHOES #652 303.73 747.45 RED WING SHOES #652 PC _______________ Account: 135-65010-030-000 Uniforms Totals: 473.72 747.45 ** 700.00 Budgeted (47.45) Remaining 107 % Used Account: 135-65055-030-000 Hardware . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2116 09/24/2018 September A/P Computer replacement-Bert, rec 2,006.68 4,795.74 6,802.42 M3 Networks 4581 AP _______________ Account: 135-65055-030-000 Hardware Totals: 4,795.74 6,802.42 ** 7,420.00 Budgeted 617.58 Remaining 92 % Used Account: 135-65085-030-000 Office Supplies 2139 09/28/2018 September A/p Office supplies 4,248.67 106.65 4,355.32 OFFICE DEPOT, INC 4604 AP 2139 09/28/2018 September A/p Office supplies' 49.39 4,404.71 OFFICE DEPOT, INC 4604 AP 2139 09/28/2018 September A/p Office supplies 79.98 4,484.69 OFFICE DEPOT, INC 4604 AP 2160 09/30/2018 September A/P Tags for portable meters 20.95 4,505.64 OFFICE DEPOT, INC 4644 AP 2160 09/30/2018 September A/P wall calendars, foot rest, key 643.16 5,148.80 OFFICE DEPOT, INC 4644 AP 2160 09/30/2018 September A/P drafting stool-Timi 118.76 5,267.56 OFFICE DEPOT, INC 4644 AP 2160 09/30/2018 September A/P File rail kit 49.98 5,317.54 OFFICE DEPOT, INC 4644 AP 2160 09/30/2018 September A/P office supplies 13.49 5,331.03 OFFICE DEPOT, INC 4644 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 1,082.36 5,331.03 ** 7,000.00 Budgeted 1,668.97 Remaining 76 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2,365.05 .00 2,365.05 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 2,365.05 ** 2,000.00 Budgeted (365.05) Remaining 118 % Used Account: 135-65095-030-000 Maintenance Supplies 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 SAMSCLUB #4795 3,796.71 6.08 3,802.79 SAMSCLUB #4795 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 SAMSCLUB.COM 42.67 3,845.46 SAMSCLUB.COM PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 SAMSCLUB.COM 254.77 4,100.23 SAMSCLUB.COM PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMAZON.COM*MT5214OE1 43.70 4,143.93 AMAZON.COM*MT5214OE1 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMZN MKTP US*MT6KC44C2 54.69 4,198.62 AMZN MKTP US*MT6KC44C2 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 401.91 4,198.62 ** 4,000.00 Budgeted (198.62) Remaining 105 % Used Account: 135-65105-030-000 Printing 144.00 .00 144.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 48,354.99 .00 48,354.99 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 48,354.99 ** 13,000.00 Budgeted (35,354.99) Remaining 372 % Used Account: 135-69170-030-000 Copier Lease Installments 2116 09/24/2018 September A/P Copier lease 2,562.31 388.00 2,950.31 TIAA COMMERCIAL FINANCE 4590 AP 2116 09/24/2018 September A/P Copier lease 86.74 3,037.05 KYOCERA DOCUMENT SOLUTIONS 4577 AP 2152 09/30/2018 September A/P Copier lease 194.00 3,231.05 TIAA COMMERCIAL FINANCE 4648 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 668.74 3,231.05 ** 4,600.00 Budgeted 1,368.95 Remaining 70 % Used Department 30 Totals: ----------------------------------- 1,102,385.92 ** 96,441.66 Monthly Total 1,217,112.00 Budgeted 114,726.08 Remaining 91 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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 2123 09/25/2018 September A/P Southlake easement legal 122,361.90 22,432.31 144,794.21 WHITAKER CHALK SWINDLE 4609 AP 2173 09/30/2018 September A/P Legal 2,610.00 147,404.21 McLean & Howard, L.L.P. 4655 AP 2173 09/30/2018 September A/P Legal 1,050.00 148,454.21 McLean & Howard, L.L.P. 4655 AP _______________ Account: 135-55045-039-000 Legal Totals: 26,092.31 148,454.21 ** 137,000.00 Budgeted (11,454.21) Remaining 108 % Used Account: 135-55055-039-000 Auditing 25,658.70 .00 25,658.70 _______________ Account: 135-55055-039-000 Auditing Totals: .00 25,658.70 ** 24,500.00 Budgeted (1,158.70) Remaining 105 % Used Account: 135-55060-039-000 Appraisal 2034 09/07/2018 September A/P Appraisel 4th qtr DCAD budget 8,683.92 2,011.87 10,695.79 DENTON CENTRAL APPRAISAL DISTR 4533 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,011.87 10,695.79 ** 11,446.00 Budgeted 750.21 Remaining 93 % Used Account: 135-55065-039-000 Tax Admin Fees 2,968.40 .00 2,968.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,968.40 ** 3,800.00 Budgeted 831.60 Remaining 78 % Used Department 39 Totals: ----------------------------------- 187,777.10 ** 28,104.18 Monthly Total 176,746.00 Budgeted (11,031.10) Remaining 106 % Used Fund 135 Totals: ----------------------------------- (2,302,430.71) (268,509.02) Monthly Total (539,854.00) Budgeted 1,762,576.71 Remaining 426 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (105,000.00) .00 (105,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (186,420.00) ** .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET SEPTEMBER 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 785,925 TOTAL LIABILITIES 785,925 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,778,504) TOTAL FUND BALANCE (785,925) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 22:50 10/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 9,348.16- 9,348.16 Subtotal: 9,348.16- 9,348.16 Program number: 9,348.16- 9,348.16 Department number: Revenues 9,348.16- 9,348.16 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 22:50 10/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/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 27,213.59- 671,726.04- 671,726.04 Subtotal: 27,213.59- 671,726.04- 671,726.04 Program number: 27,213.59- 671,726.04- 671,726.04 Department number: Wastewater 27,213.59- 671,726.04- 671,726.04 Revenues Subtotal ----------- 27,213.59- 681,074.20- 681,074.20 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 22:50 10/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60335-020-000 Intergov Transfer Out (GF) 154.89 154.89- Subtotal: 154.89 154.89- 517-69005-020-000 Capital Outlays 129,440.21 2,459,423.18 2,459,423.18- Subtotal: 129,440.21 2,459,423.18 2,459,423.18- Program number: 129,440.21 2,459,578.07 2,459,578.07- Department number: Wastewater 129,440.21 2,459,578.07 2,459,578.07- Expenditures Subtotal ----------- 129,440.21 2,459,578.07 2,459,578.07- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 102,226.62 1,778,503.87 1,778,503.87- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/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 (9,348.16) .00 (9,348.16) _______________ Account: 517-49010-000-000 Interest Income Totals: .00 (9,348.16) ** .00 Budgeted 9,348.16 Remaining 0 % Used Department Totals: ----------------------------------- (9,348.16) ** .00 Monthly Total .00 Budgeted 9,348.16 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/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 2161 09/30/2018 Texpool Transfers September (644,512.45) (27,213.59) (671,726.04) GL _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (27,213.59) (671,726.04) ** .00 Budgeted 671,726.04 Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 154.89 .00 154.89 _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 154.89 ** .00 Budgeted (154.89) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 2116 09/24/2018 September A/P WWTP Improvement 2,329,982.97 27,213.59 2,357,196.56 CP&Y/WALLACE GROUP, INC. 4564 AP 2152 09/30/2018 September A/P WWTP Improvements 102,226.62 2,459,423.18 WEBBER-CADAGUA PARTNERS 4652 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 129,440.21 2,459,423.18 ** .00 Budgeted (2,459,423.18) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,787,852.03 ** 102,226.62 Monthly Total .00 Budgeted (1,787,852.03) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,778,503.87 102,226.62 Monthly Total .00 Budgeted (1,778,503.87) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET SEPTEMBER 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 4,225,581 NET REVENUES / EXPENDITURES (3,471,381) TOTAL FUND BALANCE 754,200 TOTAL LIABILITIES AND FUND BALANCE 767,358 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 22:50 10/11/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 17,972.75- 19,506.92- 19,506.92 519-49141-000-000 Interfund Transfer In-Gen Fund 1,053,935.08 Subtotal: 1,035,962.33 19,506.92- 19,506.92 Program number: 1,035,962.33 19,506.92- 19,506.92 Department number: Revenues 1,035,962.33 19,506.92- 19,506.92 Revenues Subtotal ----------- 1,035,962.33 19,506.92- 19,506.92 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 22:50 10/11/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60334-010-000 Interfund Transfer Out 1,053,935.08- 797,679.25 797,679.25- Subtotal: 1,053,935.08- 797,679.25 797,679.25- 519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68- Subtotal: 2,693,208.68 2,693,208.68- Program number: 1,053,935.08- 3,490,887.93 3,490,887.93- Department number: Water 1,053,935.08- 3,490,887.93 3,490,887.93- Expenditures Subtotal ----------- 1,053,935.08- 3,490,887.93 3,490,887.93- Fund number: 519 2016 Rev Bond Const-SWIFT 17,972.75- 3,471,381.01 3,471,381.01- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 9/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 2170 09/30/2018 Swift Bond Escrow Int 2018~ Oct 2017 Interest (1,534.17) (1,376.62) (2,910.79) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Nov 2017 Interest (1,480.54) (4,391.33) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Dec 2017 Interest (1,561.42) (5,952.75) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Jan 2018 Interest (2,095.94) (8,048.69) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Feb 2018 Interest (2,491.50) (10,540.19) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Mar 2018 Interest (2,390.02) (12,930.21) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Apr 2018 Interest (2,287.26) (15,217.47) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ May 2018 Interest (1,127.83) (16,345.30) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ June 2018 Interest (711.39) (17,056.69) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ July 2018 Interest (757.25) (17,813.94) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Aug 2018 Interest (838.05) (18,651.99) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Sept 2018 Interest (854.57) (19,506.56) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Realized Gain 2018 (.36) (19,506.92) GL _______________ Account: 519-49010-000-000 Interest Income Totals: (17,972.75) (19,506.92) ** .00 Budgeted 19,506.92 Remaining 0 % Used Account: 519-49141-000-000 Interfund Transfer In-Gen Fund 2065 09/30/2018 Correct Intrfd Trnsfr 519/135 (1,053,935.08) 1,053,935.08 .00 GL _______________ Account: 519-49141-000-000 Interfund Transfer In-Gen Fund Totals: 1,053,935.08 .00 ** .00 Budgeted .00 Remaining 0 % Used Department Totals: ----------------------------------- (19,506.92) ** 1,035,962.33 Monthly Total .00 Budgeted 19,506.92 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 9/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 2065 09/30/2018 Correct Intrfd Trnsfr 519/135 1,851,614.33 (1,053,935.08) 797,679.25 GL _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: (1,053,935.08) 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 ** (1,053,935.08) Monthly Total .00 Budgeted (3,490,887.93) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 3,471,381.01 (17,972.75) Monthly Total .00 Budgeted (3,471,381.01) Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET SEPTEMBER 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 370,772 TOTAL LIABILITIES 370,772 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES (330,873) TOTAL FUND BALANCE (370,772) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 22:50 10/11/18 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 157,313.85 330,872.79 330,872.79- Subtotal: 157,313.85 330,872.79 330,872.79- Program number: 157,313.85 330,872.79 330,872.79- Department number: Water Department 157,313.85 330,872.79 330,872.79- Expenditures Subtotal ----------- 157,313.85 330,872.79 330,872.79- Fund number: 520 Revenue Bond 16" Waterline 157,313.85 330,872.79 330,872.79- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 9/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 2174 09/30/2018 Due To/From -Fund 520 Sept 18 173,558.94 157,313.85 330,872.79 GL _______________ Account: 520-69005-010-000 Capital Outlays Totals: 157,313.85 330,872.79 ** .00 Budgeted (330,872.79) Remaining 0 % Used Department 10 Totals: ----------------------------------- 330,872.79 ** 157,313.85 Monthly Total .00 Budgeted (330,872.79) Remaining 0 % Used Fund 520 Totals: ----------------------------------- 330,872.79 157,313.85 Monthly Total .00 Budgeted (330,872.79) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 606,910 ACCOUNTS RECEIVABLE - TOTAL ASSETS 606,910 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 180,331 TOTAL FUND BALANCE 606,910 TOTAL LIABILITIES AND FUND BALANCE 606,910 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 22:50 10/11/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 1,000.00- 1,000.00- 972.67- 7,999.41- 799.941 6,999.41 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 48,996.00- 100.000 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 123,336.00- 100.000 Subtotal: 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 Program number: 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 Department number: 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/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 2155 09/30/2018 Bank Interest- September (7,026.74) (972.67) (7,999.41) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (972.67) (7,999.41) ** (1,000.00) Budgeted 6,999.41 Remaining 800 % Used Account: 528-49142-000-000 Interfund transfer in-Water 2161 09/30/2018 Texpool Transfers September (44,913.00) (4,083.00) (48,996.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (48,996.00) ** (48,996.00) Budgeted .00 Remaining 100 % Used Account: 528-49143-000-000 Interfund transfer in-WW 2161 09/30/2018 Texpool Transfers September (113,058.00) (10,278.00) (123,336.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (123,336.00) ** (123,336.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (180,331.41) ** (15,333.67) Monthly Total (173,332.00) Budgeted 6,999.41 Remaining 104 % Used Fund 528 Totals: ----------------------------------- (180,331.41) (15,333.67) Monthly Total (173,332.00) Budgeted 6,999.41 Remaining 104 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET SEPTEMBER 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 48,716 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 9,502 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 62,791 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 9,502 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 9,502 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 20,948 TOTAL FUND BALANCE 53,289 TOTAL LIABILITIES AND FUND BALANCE 62,791 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 22:50 10/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 669,660.00- 669,660.00- 50.23- 677,052.35- 101.104 7,392.35 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 2,624.77- 145.821 824.77 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 5.53- 2,009.74- 100.487 9.74 Subtotal: 673,460.00- 673,460.00- 55.76- 681,686.86- 101.222 8,226.86 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 80.24- 8,921.74- 446.087 6,921.74 533-49015-000-000 Lease/Rental Income 218,954.00- 218,954.00- 218,954.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 122,043.00- 122,043.00- 122,043.00- 100.000 Subtotal: 342,997.00- 342,997.00- 80.24- 349,918.74- 102.018 6,921.74 Program number: 1,016,457.00- 1,016,457.00- 136.00- 1,031,605.60- 101.490 15,148.60 Department number: Revenues 1,016,457.00- 1,016,457.00- 136.00- 1,031,605.60- 101.490 15,148.60 Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 136.00- 1,031,605.60- 101.490 15,148.60 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 22:50 10/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/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 500.00 2,150.00 100.000 533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 283,507.50 100.000 .50 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 100.000 Subtotal: 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50 Program number: 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50 Department number: Administration 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 364.00 20,948.10- 361.236 15,149.10 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/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 2153 09/04/2018 Property Taxes (677,002.12) (34.75) (677,036.87) GL 2154 09/28/2018 Property Taxes (15.48) (677,052.35) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (50.23) (677,052.35) ** (669,660.00) Budgeted 7,392.35 Remaining 101 % Used Account: 533-40002-000-000 Property Taxes/Delinquent (2,624.77) .00 (2,624.77) _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 (2,624.77) ** (1,800.00) Budgeted 824.77 Remaining 146 % Used Account: 533-40015-000-000 Property Taxes/P & I 2153 09/04/2018 Property Taxes (2,004.21) (2.43) (2,006.64) GL 2154 09/28/2018 Property Taxes (3.10) (2,009.74) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (5.53) (2,009.74) ** (2,000.00) Budgeted 9.74 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 2155 09/30/2018 Bank Interest- September (8,841.50) (80.24) (8,921.74) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (80.24) (8,921.74) ** (2,000.00) Budgeted 6,921.74 Remaining 446 % Used Account: 533-49015-000-000 Lease/Rental Income (218,954.00) .00 (218,954.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (218,954.00) ** (218,954.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg (122,043.00) .00 (122,043.00) _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 (122,043.00) ** (122,043.00) Budgeted .00 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ----------------------------------- (1,031,605.60) ** (136.00) Monthly Total (1,016,457.00) Budgeted 15,148.60 Remaining 101 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/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 2097 09/21/2018 TCMUD1-13 Paying Agent Fee 1,650.00 500.00 2,150.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 500.00 2,150.00 ** 2,150.00 Budgeted .00 Remaining 100 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 283,507.50 .00 283,507.50 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 283,507.50 ** 283,508.00 Budgeted .50 Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 .00 725,000.00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 725,000.00 ** 725,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 1,010,657.50 ** 500.00 Monthly Total 1,010,658.00 Budgeted .50 Remaining 100 % Used Fund 533 Totals: ----------------------------------- (20,948.10) 364.00 Monthly Total (5,799.00) Budgeted 15,149.10 Remaining 361 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 19,562 ACCOUNTS RECEIVABLE - TOTAL ASSETS 19,562 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,211 NET REVENUES / EXPENDITURES 3,351 TOTAL FUND BALANCE 19,562 TOTAL LIABILITIES AND FUND BALANCE 19,562 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 22:50 10/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/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- 32.05- 3,350.84- 335.084 2,350.84 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 598,738.00- 100.000 Subtotal: 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84 Program number: 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84 Department number: Revenues 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84 Revenues Subtotal ----------- 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 22:50 10/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/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 100.000 534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 223,337.50 100.000 .50 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 100.000 Subtotal: 598,738.00 598,738.00 598,737.50 100.000 .50 Program number: 598,738.00 598,738.00 598,737.50 100.000 .50 Department number: Administration 598,738.00 598,738.00 598,737.50 100.000 .50 Expenditures Subtotal ----------- 598,738.00 598,738.00 598,737.50 100.000 .50 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 32.05- 3,351.34- 335.134 2,351.34 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/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 2155 09/30/2018 Bank Interest- September (3,318.79) (32.05) (3,350.84) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (32.05) (3,350.84) ** (1,000.00) Budgeted 2,350.84 Remaining 335 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales (598,738.00) .00 (598,738.00) _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 (598,738.00) ** (598,738.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (602,088.84) ** (32.05) Monthly Total (599,738.00) Budgeted 2,350.84 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/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 400.00 .00 400.00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 400.00 ** 400.00 Budgeted .00 Remaining 100 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 223,337.50 .00 223,337.50 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 223,337.50 ** 223,338.00 Budgeted .50 Remaining 100 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 .00 375,000.00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 375,000.00 ** 375,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 598,737.50 ** .00 Monthly Total 598,738.00 Budgeted .50 Remaining 100 % Used Fund 534 Totals: ----------------------------------- (3,351.34) (32.05) Monthly Total (1,000.00) Budgeted 2,351.34 Remaining 335 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 2,584 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,584 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 1,632 TOTAL FUND BALANCE 2,584 TOTAL LIABILITIES AND FUND BALANCE 2,584 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 22:50 10/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 9/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- 4.24- 1,632.02- 272.003 1,032.02 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 278,083.50- 100.000 .50- Subtotal: 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52 Program number: 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52 Department number: Revenues 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52 Revenues Subtotal ----------- 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 26 22:50 10/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 9/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 100.000 535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 62,683.50 99.999 .50 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 100.000 Subtotal: 278,084.00 278,084.00 278,083.50 100.000 .50 Program number: 278,084.00 278,084.00 278,083.50 100.000 .50 Department number: Administration 278,084.00 278,084.00 278,083.50 100.000 .50 Expenditures Subtotal ----------- 278,084.00 278,084.00 278,083.50 100.000 .50 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 4.24- 1,632.02- 272.003 1,032.02 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 9/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 2155 09/30/2018 Bank Interest- September (1,627.78) (4.24) (1,632.02) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (4.24) (1,632.02) ** (600.00) Budgeted 1,032.02 Remaining 272 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales (278,083.50) .00 (278,083.50) _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: .00 (278,083.50) ** (278,084.00) Budgeted (.50) Remaining 100 % Used Department Totals: ----------------------------------- (279,715.52) ** (4.24) Monthly Total (278,684.00) Budgeted 1,031.52 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 9/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 400.00 .00 400.00 _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 400.00 ** 400.00 Budgeted .00 Remaining 100 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 62,683.50 .00 62,683.50 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 62,683.50 ** 62,684.00 Budgeted .50 Remaining 100 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 .00 215,000.00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 215,000.00 ** 215,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 278,083.50 ** .00 Monthly Total 278,084.00 Budgeted .50 Remaining 100 % Used Fund 535 Totals: ----------------------------------- (1,632.02) (4.24) Monthly Total (600.00) Budgeted 1,032.02 Remaining 272 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 2,864,013.23 **** 9,977.28 Monthly Total (720,585.00) Budgeted (3,584,598.23) Remaining ########## ******* End of Report *********