Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-08 August Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET AUGUST 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 594,538 PREPAID EXPENSES 1,270 ADVALOREM PROPERTY TAXES RECEIVABLE 15,387 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 611,195 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 15,387 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 15,387 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 73,555 TOTAL FUND BALANCE 595,808 TOTAL LIABILITIES AND FUND BALANCE 611,195 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 20:16 09/08/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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- 1,288.85- 1,065,981.53- 101.095 11,548.53 122-40011-000-000 Property Taxes/Fire-Delinquent 3,945.10- 3,945.10 122-40020-000-000 Property Taxes/Fire P&I 105.92- 4,777.93- 4,777.93 Subtotal: 1,054,433.00- 1,054,433.00- 1,394.77- 1,074,704.56- 101.923 20,271.56 Program number: 1,054,433.00- 1,054,433.00- 1,394.77- 1,074,704.56- 101.923 20,271.56 Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 1,394.77- 1,074,704.56- 101.923 20,271.56 Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 1,394.77- 1,074,704.56- 101.923 20,271.56 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 20:16 09/08/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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.87 13,968.57 77.603 4,031.43 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 558,167.50 91.667 50,742.50 Subtotal: 845,864.00 845,864.00 52,012.37 791,090.07 93.524 54,773.93 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 52,012.37 1,001,149.16 94.947 53,283.84 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 1,001,149.16 94.947 53,283.84 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 1,001,149.16 94.947 53,283.84 Fund number: 122 Trophy Club MUD Fire Dept. 50,617.60 73,555.40- 73,555.40 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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 2007 08/01/2018 Property Taxes (1,064,692.68) (133.13) (1,064,825.81) GL 2008 08/02/2018 Property Taxes (383.86) (1,065,209.67) GL 2009 08/03/2018 Property Taxes (55.45) (1,065,265.12) GL 2010 08/06/2018 Property Taxes (39.10) (1,065,304.22) GL 2011 08/07/2018 Property Taxes (42.15) (1,065,346.37) GL 2012 08/21/2018 Property Taxes (526.85) (1,065,873.22) GL 2013 08/27/2018 Property Taxes (100.91) (1,065,974.13) GL 2014 08/29/2018 Property Taxes (7.40) (1,065,981.53) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (1,288.85) (1,065,981.53) ** (1,054,433.00) Budgeted 11,548.53 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 2008 08/02/2018 Property Taxes (4,672.01) (4.93) (4,676.94) GL 2011 08/07/2018 Property Taxes (.37) (4,677.31) GL 2012 08/21/2018 Property Taxes (100.10) (4,777.41) GL 2014 08/29/2018 Property Taxes (.52) (4,777.93) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (105.92) (4,777.93) ** .00 Budgeted 4,777.93 Remaining 0 % Used Department Totals: ----------------------------------- (1,074,704.56) ** (1,394.77) Monthly Total (1,054,433.00) Budgeted 20,271.56 Remaining 102 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 242 08/01/2018 Insurance/Wrk Comp Exp Aug 12,698.70 1,269.87 13,968.57 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 13,968.57 ** 18,000.00 Budgeted 4,031.43 Remaining 78 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1844 08/03/2018 August A/P August Fire Admin 507,425.00 50,742.50 558,167.50 TOWN OF TROPHY CLUB 4465 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 558,167.50 ** 608,910.00 Budgeted 50,742.50 Remaining 92 % 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,001,149.16 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 53,283.84 Remaining 95 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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: ----------------------------------- (73,555.40) 50,617.60 Monthly Total .00 Budgeted 73,555.40 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET AUGUST 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 667,232 - 667,232 CASH IN BANK-SAVINGS-CASH RESERVE 982,658 - 982,658 CD-BANK OF THE WEST/THB DEPOSIT - - - INVESTMENTS-MONEY MARKET-BANK OF THE WEST 715,532 - 715,532 INVESTMENTS-TEXPOOL 3,262,075 596,426 3,858,501 PREPAID EXPENSES 11,960 - 11,960 ADVALOREM PROPERTY TAXES RECEIVABLE 1,653 - 1,653 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,472,678 - 1,472,678 TOTAL ASSETS 7,114,388 596,426 7,710,814 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,653 - 1,653 ACCOUNTS AND OTHER PAYABLES 613,535 - 613,535 CUSTOMER DEPOSITS 314,910 - 314,910 - TOTAL LIABILITIES 930,098 - 930,098 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,033,922 - 2,033,922 - TOTAL FUND BALANCE 6,184,290 596,426 6,780,716 TOTAL LIABILITIES AND FUND BALANCE 7,114,388 596,426 7,710,814 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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- 147.84- 122,269.80- 101.091 1,319.80 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- 12.15- 529.34- 264.670 329.34 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 159.99- 123,146.21- 41.160 176,042.79- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 787,623.19- 5,463,687.82- 84.525 1,000,331.18- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 263,967.80- 2,734,037.65- 91.806 244,029.35- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 11,904.11- 103,287.09- 97.185 2,991.91- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 925.00- 12,330.50- 57.754 9,019.50- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 100.00- 2,050.00- 136.667 550.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 5,350.00- 118.889 850.00 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 17,472.80- 76,585.60- 127.643 16,585.60 Subtotal: 9,635,715.00- 9,635,715.00- 1,082,292.90- 8,397,328.66- 87.148 1,238,386.34- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 6,234.28- 50,413.16- 420.110 38,413.16 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 1,178.81- 10,898.63- 99.749 27.37- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 6,416.63- 91.666 583.37- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 15,400.00- 770.000 13,400.00 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 686.00- 13,207.76- 72.654 4,971.24- 135-49141-000-000 Interfund Transfer In 1,851,769.22- 1,851,769.22 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 226.22- 59,466.32- 1,189.326 54,466.32 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- 315,125.00- 8,908.64- 2,007,573.72- 637.072 1,692,448.72 Program number: 10,250,029.00- 10,250,029.00- 1,091,361.53- 10,528,048.59- 102.712 278,019.59 Department number: Revenues 10,250,029.00- 10,250,029.00- 1,091,361.53- 10,528,048.59- 102.712 278,019.59 Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 1,091,361.53- 10,528,048.59- 102.712 278,019.59 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 20,273.04 208,188.25 75.904 66,090.75 135-50010-010-000 Overtime 20,000.00 20,000.00 3,143.95 12,941.85 64.709 7,058.15 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 275.00 2,225.00 67.424 1,075.00 135-50020-010-000 Retirement 27,843.00 27,843.00 2,191.50 22,376.48 80.367 5,466.52 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 29,866.96 57.221 22,329.04 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 2,375.64 45.844 2,806.36 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 423.91 42.647 570.09 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 215.61 2,339.54 78.455 642.46 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,453.01 13,953.81 74.771 4,708.19 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 339.82 3,263.39 74.763 1,101.61 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.92 9,899.12 83.509 1,954.88 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 20.30 39.29 13.097 260.71 Subtotal: 426,662.00 426,662.00 32,010.52 312,306.97 73.198 114,355.03 135-55005-010-000 Engineering 275,000.00 275,000.00 275,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 46,797.41 99,788.97 99.789 211.03 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 706.00 5,068.27 126.707 1,068.27- 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 60.00 6,595.16 119.912 1,095.16- Subtotal: 391,000.00 391,000.00 47,563.41 111,487.40 28.513 279,512.60 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 369.91 3,602.72 76.654 1,097.28 135-60020-010-000 Electricity 175,356.00 175,356.00 15,800.48 125,080.91 71.330 50,275.09 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 300.00 2,208.78 79.310 576.22 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 500.00 24,220.32 43.896 30,955.68 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 324,512.48 1,870,342.92 66.250 952,827.08 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 472.00 974.70 32.490 2,025.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,500.00 10,500.00 71.186 4,250.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.40 278,083.50 100.000 .50 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 44,913.00 91.667 4,083.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 1,053,935.08 526.968 853,935.08- 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 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,613,852.00 3,613,852.00 372,818.27 3,419,744.43 94.629 194,107.57 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 1,341.87 10,214.48 68.097 4,785.52 135-65010-010-000 Uniforms 4,488.00 4,488.00 1,249.14 27.833 3,238.86 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,116.81 17,083.91 85.420 2,916.09 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 311.95 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 33,412.50 82,312.50 97.991 1,687.50 Subtotal: 175,688.00 175,688.00 36,183.13 136,916.73 77.932 38,771.27 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 105,240.00 590,375.89 72.885 219,636.11 135-69008-010-000 Short Term Debt-Principal 38,731.00 38,731.00 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 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 118,775.00 107,864.38 90.814 10,910.62 Subtotal: 1,048,231.00 1,048,231.00 105,240.00 775,511.51 73.983 272,719.49 Program number: 5,655,433.00 5,655,433.00 593,815.33 4,755,967.04 84.096 899,465.96 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/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 1,385.08 69.254 614.92 Subtotal: 2,000.00 2,000.00 1,385.08 69.254 614.92 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 1,385.08 69.254 614.92 Department number: Water 5,657,433.00 5,657,433.00 593,815.33 4,757,352.12 84.090 900,080.88 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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,698.35 324,553.95 78.993 86,312.05 135-50010-020-000 Overtime 30,000.00 30,000.00 2,237.36 30,674.32 102.248 674.32- 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 7,736.00 92.095 664.00 135-50020-020-000 Retirement 42,243.00 42,243.00 2,648.81 35,714.27 84.545 6,528.73 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 60,065.33 96.607 2,109.67 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 371.89 4,319.85 81.955 951.15 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 743.96 66.783 370.04 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 269.29 3,847.68 89.878 433.32 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,594.75 21,214.71 74.927 7,099.29 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 372.95 4,961.49 74.924 1,660.51 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 14,828.00 82.424 3,162.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 235.00 78.333 65.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 40,818.99 517,443.56 82.579 109,157.44 135-55070-020-000 Independent Labor 20,550.00 20,550.00 2,145.00 10.438 18,405.00 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 2,553.53 78,007.00 90.600 8,093.00 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 1,364.03 9,672.01 120.900 1,672.01- 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 1,755.07 64,656.77 107.761 4,656.77- 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,768.00 29,272.02 97.573 727.98 Subtotal: 219,150.00 219,150.00 8,440.63 184,176.98 84.042 34,973.02 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 405.14 4,462.25 94.941 237.75 135-60020-020-000 Electricity 266,709.00 266,709.00 12,175.45 147,712.80 55.384 118,996.20 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 41.88 1.047 3,958.12 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,180.00 8,140.00 70.172 3,460.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.90 122,043.00 100.000 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.80 598,738.00 100.000 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 113,058.00 91.667 10,278.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 200,000.00 181,037.39 644,512.45 322.256 444,512.45- 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 1,438,938.00 270,601.68 1,671,903.09 116.190 232,965.09- 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 623.16 8,120.86 64.967 4,379.14 135-65010-020-000 Uniforms 4,459.00 4,459.00 79.98 1,854.57 41.592 2,604.43 135-65030-020-000 Chemicals 27,500.00 27,500.00 5,523.50 14,757.73 53.664 12,742.27 135-65035-020-000 Small Tools 1,000.00 1,000.00 46.26 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 2,278.36 18,875.07 134.822 4,875.07- Subtotal: 60,209.00 60,209.00 8,551.26 46,201.87 76.736 14,007.13 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 2,125.00 108,644.29 19.850 438,682.71 135-69008-020-000 Short Term Debt-Principal 51,342.00 51,342.00 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 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 636,242.00 2,125.00 141,655.02 22.264 494,586.98 Program number: 2,981,140.00 2,981,140.00 330,537.56 2,561,380.52 85.919 419,759.48 Department number: Wastewater 2,981,140.00 2,981,140.00 330,537.56 2,561,380.52 85.919 419,759.48 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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.42 26.62 88.733 3.38 Subtotal: 30.00 30.00 2.42 26.62 88.733 3.38 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 11.98 103.26 8.605 1,096.74 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 415.94 4,768.22 95.364 231.78 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 69.72 1,473.98 73.699 526.02 Subtotal: 12,950.00 12,950.00 497.64 9,750.46 75.293 3,199.54 Program number: 12,980.00 12,980.00 500.06 9,777.08 75.324 3,202.92 Department number: Board of Directors 12,980.00 12,980.00 500.06 9,777.08 75.324 3,202.92 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 26,899.09 337,201.47 77.900 95,661.53 135-50010-030-000 Overtime 2,000.00 2,000.00 563.05 28.153 1,436.95 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,488.19 33,878.31 83.541 6,674.69 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 43,345.59 68.277 20,139.41 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 3,017.37 54.841 2,484.63 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 547.37 46.664 625.63 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 357.70 3,434.06 67.880 1,624.94 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,589.06 20,309.18 74.718 6,871.82 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 371.63 4,749.72 74.716 1,607.28 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 69.23 1,139.54 90.440 120.46 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 1,358.50 88.849 170.50 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 44.71 3,273.18 65.992 1,686.82 Subtotal: 595,970.00 595,970.00 36,390.38 456,576.74 76.611 139,393.26 135-55030-030-000 Software & Support 78,391.00 78,391.00 2,201.49 66,078.36 84.293 12,312.64 135-55070-030-000 Independent Labor 154,000.00 154,000.00 11,569.90 139,518.80 90.597 14,481.20 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 239.79 5,400.48 38.575 8,599.52 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 4,624.58 46.246 5,375.42 135-55100-030-000 Building Maint & Supplies 398.00- 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 8,307.69 83.077 1,692.31 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 59,240.00 93.549 4,085.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 5,891.80 65.464 3,108.20 Subtotal: 338,916.00 338,916.00 14,482.24 289,061.71 85.290 49,854.29 135-60005-030-000 Telephone 27,300.00 27,300.00 1,535.24 15,229.11 55.784 12,070.89 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.33 2,748.83 68.721 1,251.17 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 5,988.92 36.830 10,272.08 135-60025-030-000 Water 2,500.00 2,500.00 68.25 660.51 26.420 1,839.49 135-60035-030-000 Postage 30,000.00 30,000.00 17,849.47 59.498 12,150.53 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 6,607.95 55,665.70 100.190 105.70- 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 56,000.00 56,000.00 6,100.36 70,898.96 126.605 14,898.96- 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 206.38 12.899 1,393.62 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 53.06 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 90.80 1,671.32 34.213 3,213.68 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 4,500.00 4,500.00 220.00 4.889 4,280.00 135-60125-030-000 Advertising 2,500.00 2,500.00 150.00 300.00 12.000 2,200.00 135-60235-030-000 Security 2,700.00 2,700.00 24.00 418.00 15.481 2,282.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 249,506.00 14,866.99 196,553.67 78.777 52,952.33 135-65010-030-000 Uniforms 700.00 700.00 273.73 39.104 426.27 135-65055-030-000 Hardware 7,420.00 7,420.00 2,006.68 27.044 5,413.32 135-65085-030-000 Office Supplies 7,000.00 7,000.00 241.75 4,248.67 60.695 2,751.33 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 316.39 2,365.05 118.253 365.05- 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 3,796.71 94.918 203.29 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 558.14 12,834.84 51.094 12,285.16 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 100.57 2,562.31 55.702 2,037.69 Subtotal: 17,600.00 17,600.00 100.57 50,917.30 289.303 33,317.30- Program number: 1,227,112.00 1,227,112.00 66,398.32 1,005,944.26 81.977 221,167.74 Department number: Administration 1,227,112.00 1,227,112.00 66,398.32 1,005,944.26 81.977 221,167.74 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 20:16 09/08/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 4,440.00 122,361.90 89.315 14,638.10 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 8,683.92 75.869 2,762.08 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 4,440.00 159,672.92 90.340 17,073.08 Program number: 176,746.00 176,746.00 4,440.00 159,672.92 90.340 17,073.08 Department number: Non Departmental 176,746.00 176,746.00 4,440.00 159,672.92 90.340 17,073.08 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 995,691.27 8,494,126.90 84.473 1,561,284.10 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 95,670.26- 2,033,921.69- 1,045.084 1,839,303.69 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 20:16 09/08/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/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 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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 2007 08/01/2018 Property Taxes (122,121.96) (15.27) (122,137.23) GL 2008 08/02/2018 Property Taxes (44.03) (122,181.26) GL 2009 08/03/2018 Property Taxes (6.36) (122,187.62) GL 2010 08/06/2018 Property Taxes (4.49) (122,192.11) GL 2011 08/07/2018 Property Taxes (4.84) (122,196.95) GL 2012 08/21/2018 Property Taxes (60.43) (122,257.38) GL 2013 08/27/2018 Property Taxes (11.57) (122,268.95) GL 2014 08/29/2018 Property Taxes (.85) (122,269.80) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (147.84) (122,269.80) ** (120,950.00) Budgeted 1,319.80 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 2008 08/02/2018 Property Taxes (517.19) (.57) (517.76) GL 2011 08/07/2018 Property Taxes (.04) (517.80) GL 2012 08/21/2018 Property Taxes (11.48) (529.28) GL 2014 08/29/2018 Property Taxes (.06) (529.34) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (12.15) (529.34) ** (200.00) Budgeted 329.34 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 1985 08/31/2018 UB 08/31/2018 Billing UB20180831-20180831 User: (4,676,064.63) (787,623.19) (5,463,687.82) UB _______________ Account: 135-47000-000-000 Water Totals: (787,623.19) (5,463,687.82) ** (6,464,019.00) Budgeted (1,000,331.18) Remaining 85 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-47005-000-000 Sewer 1985 08/31/2018 UB 08/31/2018 Billing UB20180831-20180831 User: (2,470,069.85) (263,967.80) (2,734,037.65) UB _______________ Account: 135-47005-000-000 Sewer Totals: (263,967.80) (2,734,037.65) ** (2,978,067.00) Budgeted (244,029.35) Remaining 92 % Used Account: 135-47025-000-000 Penalties 1928 08/20/2018 UB 08/20/2018 Penalty Removal UB20180820-20180820 User: (91,382.98) 69.19 (91,313.79) UB 1943 08/21/2018 UB 08/21/2018 Penalties UB20180821-20180821 User: (12,566.87) (103,880.66) UB 1965 08/27/2018 UB 08/27/2018 Penalty removal UB20180827-20180827 User: 371.75 (103,508.91) UB 1975 08/30/2018 UB 08/30/2018 Penalty removal UB20180830-20180830 User: 182.41 (103,326.50) UB 1979 08/31/2018 UB 08/31/2018 Penalty removal UB20180831-20180831 User: 39.41 (103,287.09) UB _______________ Account: 135-47025-000-000 Penalties Totals: (11,904.11) (103,287.09) ** (106,279.00) Budgeted (2,991.91) Remaining 97 % Used Account: 135-47030-000-000 Service Charges 1863 08/07/2018 UB 08/07/2018 Disconnect Fees UB20180807-20180807 User: (11,405.50) (850.00) (12,255.50) UB 1916 08/10/2018 UB 08/16/2018 NSF check UB20180810-20180810 User: (25.00) (12,280.50) UB 1950 08/22/2018 UB 08/22/2018 NSF Check UB20180822-20180822 User: (50.00) (12,330.50) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (925.00) (12,330.50) ** (21,350.00) Budgeted (9,019.50) Remaining 58 % Used Account: 135-47035-000-000 Plumbing Inspections 1995 08/28/2018 Permits-403 Abbot, 519 Ashevil 403 Abbot Lane (1,950.00) (50.00) (2,000.00) Ashton Woods Homes CR 1995 08/28/2018 Permits-403 Abbot, 519 Ashevil 519 Asheville Lane (50.00) (2,050.00) Ashton Woods Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (2,050.00) ** (1,500.00) Budgeted 550.00 Remaining 137 % Used Account: 135-47045-000-000 Sewer Inspections 1995 08/28/2018 Permits-403 Abbot, 519 Ashevil 403 Abbot Lane (5,050.00) (150.00) (5,200.00) Ashton Woods Homes CR 1995 08/28/2018 Permits-403 Abbot, 519 Ashevil 519 Asheville Lane (150.00) (5,350.00) Ashton Woods Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (5,350.00) ** (4,500.00) Budgeted 850.00 Remaining 119 % Used Account: 135-47070-000-000 TCCC Effluent Charges . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1971 08/29/2018 UB 08/29/2018 Credit adjustmen UB20180829-20180829 User: (59,112.80) 4,011.20 (55,101.60) UB 1985 08/31/2018 UB 08/31/2018 Billing UB20180831-20180831 User: (21,484.00) (76,585.60) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (17,472.80) (76,585.60) ** (60,000.00) Budgeted 16,585.60 Remaining 128 % Used Account: 135-49010-000-000 Interest Income 2045 08/31/2018 Bank Interest- August (44,178.88) (151.90) (44,330.78) GL 2045 08/31/2018 Bank Interest- August (721.65) (45,052.43) GL 2045 08/31/2018 Bank Interest- August (5,360.73) (50,413.16) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (6,234.28) (50,413.16) ** (12,000.00) Budgeted 38,413.16 Remaining 420 % Used Account: 135-49016-000-000 Cell Tower Revenue 2041 08/10/2018 Cell Tower Rev AT&T August (9,719.82) (1,178.81) (10,898.63) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (10,898.63) ** (10,926.00) Budgeted (27.37) Remaining 100 % Used Account: 135-49018-000-000 Building Rent Income 2044 08/31/2018 Town Billed Invoices 1652-1655 AR 20180831-20180831 User: (5,833.30) (583.33) (6,416.63) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (6,416.63) ** (7,000.00) Budgeted (583.37) Remaining 92 % 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) ** (2,000.00) Budgeted 13,400.00 Remaining 770 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1995 08/28/2018 Permits-403 Abbot, 519 Ashevil 403 Abbot Lane (12,521.76) (343.00) (12,864.76) Ashton Woods Homes CR 1995 08/28/2018 Permits-403 Abbot, 519 Ashevil 519 Asheville Lane (343.00) (13,207.76) Ashton Woods Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (13,207.76) ** (18,179.00) Budgeted (4,971.24) Remaining 73 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-49141-000-000 Interfund Transfer In (1,851,769.22) .00 (1,851,769.22) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (1,851,769.22) ** .00 Budgeted 1,851,769.22 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1985 08/31/2018 UB 08/31/2018 Billing UB20180831-20180831 User: (59,240.10) (226.22) (59,466.32) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (226.22) (59,466.32) ** (5,000.00) Budgeted 54,466.32 Remaining 1.189 % 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,528,048.59) ** (1,091,361.53) Monthly Total (10,250,029.00) Budgeted 278,019.59 Remaining 103 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 1801 08/02/2018 Anniversary Checks 2018 Salaries & Wages 187,915.21 234.33 188,149.54 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Salaries & Wages 9,939.23 198,088.77 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Salaries & Wages 10,099.48 208,188.25 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 20,273.04 208,188.25 ** 274,279.00 Budgeted 66,090.75 Remaining 76 % Used Account: 135-50010-010-000 Overtime 1864 08/10/2018 Mud Payroll 08/10/2018 Overtime 9,797.90 2,365.40 12,163.30 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Overtime 778.55 12,941.85 PR _______________ Account: 135-50010-010-000 Overtime Totals: 3,143.95 12,941.85 ** 20,000.00 Budgeted 7,058.15 Remaining 65 % 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 1940 08/24/2018 MUD Payroll 08/24/2018 Certification 1,950.00 275.00 2,225.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 275.00 2,225.00 ** 3,300.00 Budgeted 1,075.00 Remaining 67 % Used Account: 135-50020-010-000 Retirement 1801 08/02/2018 Anniversary Checks 2018 Retirement 20,184.98 21.68 20,206.66 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Retirement 1,138.16 21,344.82 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Retirement 1,031.66 22,376.48 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,191.50 22,376.48 ** 27,843.00 Budgeted 5,466.52 Remaining 80 % Used Account: 135-50026-010-000 Medical Insurance 1864 08/10/2018 Mud Payroll 08/10/2018 Medical Insurance 26,918.16 1,474.40 28,392.56 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Medical Insurance 1,474.40 29,866.96 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-50026-010-000 Medical Insurance Totals: 2,948.80 29,866.96 ** 52,196.00 Budgeted 22,329.04 Remaining 57 % Used Account: 135-50027-010-000 Dental Insurance 1864 08/10/2018 Mud Payroll 08/10/2018 Dental Insurance 2,161.99 106.85 2,268.84 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Dental Insurance 106.80 2,375.64 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 2,375.64 ** 5,182.00 Budgeted 2,806.36 Remaining 46 % Used Account: 135-50028-010-000 Vision Insurance 1864 08/10/2018 Mud Payroll 08/10/2018 Vision Insurance 387.99 17.98 405.97 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Vision Insurance 17.94 423.91 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 423.91 ** 994.00 Budgeted 570.09 Remaining 43 % Used Account: 135-50029-010-000 Life Insurance & Other 1773 08/01/2018 August A/P Employee benefits 2,123.93 110.60 2,234.53 Humana Inc 4394 AP 1882 08/09/2018 August A/P Employee benefits-August 87.01 2,321.54 METLIFE GROUP BENEFITS 4454 AP 1933 08/20/2018 August A/P Café 18.00 2,339.54 BenefitMall 4476 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 215.61 2,339.54 ** 2,982.00 Budgeted 642.46 Remaining 78 % Used Account: 135-50030-010-000 Social Security Taxes 1801 08/02/2018 Anniversary Checks 2018 Social Security Taxes 12,500.80 14.53 12,515.33 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Social Security Taxes 756.48 13,271.81 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Social Security Taxes 682.00 13,953.81 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,453.01 13,953.81 ** 18,662.00 Budgeted 4,708.19 Remaining 75 % Used Account: 135-50035-010-000 Medicare Taxes 1801 08/02/2018 Anniversary Checks 2018 Medicare Taxes 2,923.57 3.40 2,926.97 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Medicare Taxes 176.91 3,103.88 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Medicare Taxes 159.51 3,263.39 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-50035-010-000 Medicare Taxes Totals: 339.82 3,263.39 ** 4,365.00 Budgeted 1,101.61 Remaining 75 % Used Account: 135-50040-010-000 Unemployment Taxes 818.68 .00 818.68 _______________ 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 242 08/01/2018 Insurance/Wrk Comp Exp Aug 8,999.20 899.92 9,899.12 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 9,899.12 ** 11,854.00 Budgeted 1,954.88 Remaining 84 % 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 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 PIZZA HUT 24623 18.99 20.30 39.29 PIZZA HUT 24623 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 20.30 39.29 ** 300.00 Budgeted 260.71 Remaining 13 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 275,000.00 Budgeted 275,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1929 08/20/2018 August A/P Clamps 52,991.56 2,183.73 55,175.29 Core & Main LP 4479 AP 1929 08/20/2018 August A/P Parts 1,137.34 56,312.63 Core & Main LP 4479 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1934 08/20/2018 August A/P Water removal-1040 Trophy Club 52,991.56 5,170.00 61,482.63 Blackmon Mooring Company 4477 AP 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 THE HOME DEPOT #6581 62.67 61,545.30 THE HOME DEPOT #6581 PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 FERGUSON ENT 1241 1,220.37 62,765.67 FERGUSON ENT 1241 PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 MACARTHUR GAUGE INC 249.51 63,015.18 MACARTHUR GAUGE INC PC 1980 08/31/2018 August A/P Ejector body 133.30 63,148.48 SCOOP 4509 AP 2019 08/31/2018 August A/P Water break repairs-1040 TC Dr 17,701.94 80,850.42 REY-MAR CONSTRUCTION 4522 AP 2019 08/31/2018 August A/P Water Break repairs-Indian cre 10,345.00 91,195.42 REY-MAR CONSTRUCTION 4522 AP 2019 08/31/2018 August A/P Bottle Rental 42.00 91,237.42 ALLIED WELDING SUPPLY, INC 4513 AP 2019 08/31/2018 August A/P water break repairs-Greenhill 682.73 91,920.15 REY-MAR CONSTRUCTION 4522 AP 2019 08/31/2018 August A/P Water break repairs-TC Mud sou 7,868.82 99,788.97 REY-MAR CONSTRUCTION 4522 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 46,797.41 99,788.97 ** 100,000.00 Budgeted 211.03 Remaining 100 % 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 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 DISCOUNT TIRE TXD 75 4,362.27 706.00 5,068.27 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 706.00 5,068.27 ** 4,000.00 Budgeted (1,068.27) Remaining 127 % 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 1976 08/30/2018 August A/P water sample 6,535.16 60.00 6,595.16 Centralized Water & Wastewater 4491 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 60.00 6,595.16 ** 5,500.00 Budgeted (1,095.16) Remaining 120 % Used Account: 135-60010-010-000 Communications/Mobiles . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1898 08/13/2018 August A/P Cell phones 3,232.81 369.91 3,602.72 VERIZON WIRELESS 4471 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 369.91 3,602.72 ** 4,700.00 Budgeted 1,097.28 Remaining 77 % Used Account: 135-60020-010-000 Electricity 1929 08/20/2018 August A/P Electricity 7/11-8/10 109,280.43 15,800.48 125,080.91 HUDSON ENERGY SERVICES, LLC 4482 AP _______________ Account: 135-60020-010-000 Electricity Totals: 15,800.48 125,080.91 ** 175,356.00 Budgeted 50,275.09 Remaining 71 % 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 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 MACARTHUR GAUGE INC 1,908.78 150.00 2,058.78 MACARTHUR GAUGE INC PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 METROPLEX TRAINING CEN 150.00 2,208.78 METROPLEX TRAINING CEN PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 300.00 2,208.78 ** 2,785.00 Budgeted 576.22 Remaining 79 % Used Account: 135-60090-010-000 Safety Program 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 87.48 .00 87.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 TCEQ EPAYMENT 23,720.32 500.00 24,220.32 TCEQ EPAYMENT PC _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 500.00 24,220.32 ** 55,176.00 Budgeted 30,955.68 Remaining 44 % Used Account: 135-60150-010-000 Wholesale Water 1976 08/30/2018 August A/P Ft worth water 1,545,830.44 324,512.48 1,870,342.92 CITY OF FORT WORTH 4493 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 324,512.48 1,870,342.92 ** 2,823,170.00 Budgeted 952,827.08 Remaining 66 % 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 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 DENTON SAND & GRAVEL, 502.70 220.00 722.70 DENTON SAND & GRAVEL, PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 DENTON SAND & GRAVEL, 72.00 794.70 DENTON SAND & GRAVEL, PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 DENTON SAND & GRAVEL, 108.00 902.70 DENTON SAND & GRAVEL, PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 DENTON SAND & GRAVEL, 72.00 974.70 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 472.00 974.70 ** 3,000.00 Budgeted 2,025.30 Remaining 32 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-60285-010-000 Lawn Equipment & Maintenance 2019 08/31/2018 August A/P Mowing 9,000.00 1,500.00 10,500.00 WATTS ELLISON LLC 4525 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 10,500.00 ** 14,750.00 Budgeted 4,250.00 Remaining 71 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1986 08/31/2018 Texpool Transfers August 252,803.10 25,280.40 278,083.50 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.40 278,083.50 ** 278,084.00 Budgeted .50 Remaining 100 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1986 08/31/2018 Texpool Transfers August 40,830.00 4,083.00 44,913.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 44,913.00 ** 48,996.00 Budgeted 4,083.00 Remaining 92 % Used Account: 135-60334-010-000 Interfund Transfer Out 1,053,935.08 .00 1,053,935.08 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 1,053,935.08 ** 200,000.00 Budgeted (853,935.08) Remaining 527 % 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 1976 08/30/2018 August A/P FUEL 8,872.61 1,341.87 10,214.48 US Bank Voyager Fleet Systems 4511 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,341.87 10,214.48 ** 15,000.00 Budgeted 4,785.52 Remaining 68 % Used Account: 135-65010-010-000 Uniforms . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,249.14 .00 1,249.14 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,249.14 ** 4,488.00 Budgeted 3,238.86 Remaining 28 % Used Account: 135-65030-010-000 Chemicals 1976 08/30/2018 August A/P chlorine 15,967.10 1,116.81 17,083.91 DPC INDUSTRIES, INC 4496 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,116.81 17,083.91 ** 20,000.00 Budgeted 2,916.09 Remaining 85 % 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 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 AMZN MKTP US 769.00 311.95 1,080.95 AMZN MKTP US PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 311.95 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 1898 08/13/2018 August A/P HRE meter heads 48,900.00 14,287.50 63,187.50 ATLAS UTILITY SUPPLY CO. 4424 AP 1898 08/13/2018 August A/P Meter endpoints 19,125.00 82,312.50 ATLAS UTILITY SUPPLY CO. 4424 AP _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: 33,412.50 82,312.50 ** 84,000.00 Budgeted 1,687.50 Remaining 98 % Used Account: 135-69005-010-000 Capital Outlays . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1976 08/30/2018 August A/P 16" water line phase 1 485,135.89 99,293.00 584,428.89 La Banda, LLC 4501 AP 1976 08/30/2018 August A/P phoenix drive 5,947.00 590,375.89 Quality Excavation, LTD 4508 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 105,240.00 590,375.89 ** 810,012.00 Budgeted 219,636.11 Remaining 73 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest 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 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/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 1,385.08 .00 1,385.08 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 1,385.08 ** 2,000.00 Budgeted 614.92 Remaining 69 % Used Department 10 Totals: ----------------------------------- 4,757,352.12 ** 593,815.33 Monthly Total 5,657,433.00 Budgeted 900,080.88 Remaining 84 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 1801 08/02/2018 Anniversary Checks 2018 Salaries & Wages 298,855.60 351.48 299,207.08 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Salaries & Wages 12,704.49 311,911.57 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Salaries & Wages 12,642.38 324,553.95 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 25,698.35 324,553.95 ** 410,866.00 Budgeted 86,312.05 Remaining 79 % Used Account: 135-50010-020-000 Overtime 1864 08/10/2018 Mud Payroll 08/10/2018 Overtime 28,436.96 1,301.99 29,738.95 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Overtime 935.37 30,674.32 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,237.36 30,674.32 ** 30,000.00 Budgeted (674.32) Remaining 102 % 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 1940 08/24/2018 MUD Payroll 08/24/2018 Certification 7,036.00 700.00 7,736.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 7,736.00 ** 8,400.00 Budgeted 664.00 Remaining 92 % Used Account: 135-50020-020-000 Retirement 1801 08/02/2018 Anniversary Checks 2018 Retirement 33,065.46 32.52 33,097.98 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Retirement 1,295.61 34,393.59 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Retirement 1,320.68 35,714.27 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,648.81 35,714.27 ** 42,243.00 Budgeted 6,528.73 Remaining 85 % Used Account: 135-50026-020-000 Medical Insurance 1864 08/10/2018 Mud Payroll 08/10/2018 Medical Insurance 54,546.64 2,759.36 57,306.00 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Medical Insurance 2,759.33 60,065.33 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-50026-020-000 Medical Insurance Totals: 5,518.69 60,065.33 ** 62,175.00 Budgeted 2,109.67 Remaining 97 % Used Account: 135-50027-020-000 Dental Insurance 1864 08/10/2018 Mud Payroll 08/10/2018 Dental Insurance 3,947.96 185.96 4,133.92 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Dental Insurance 185.93 4,319.85 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 4,319.85 ** 5,271.00 Budgeted 951.15 Remaining 82 % Used Account: 135-50028-020-000 Vision Insurance 1864 08/10/2018 Mud Payroll 08/10/2018 Vision Insurance 685.06 29.46 714.52 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Vision Insurance 29.44 743.96 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 743.96 ** 1,114.00 Budgeted 370.04 Remaining 67 % Used Account: 135-50029-020-000 Life Insurance & Other 1773 08/01/2018 August A/P Employee benefits 3,578.39 136.36 3,714.75 Humana Inc 4394 AP 1882 08/09/2018 August A/P Employee benefits-August 96.93 3,811.68 METLIFE GROUP BENEFITS 4454 AP 1933 08/20/2018 August A/P Café 36.00 3,847.68 BenefitMall 4476 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 269.29 3,847.68 ** 4,281.00 Budgeted 433.32 Remaining 90 % Used Account: 135-50030-020-000 Social Security Taxes 1801 08/02/2018 Anniversary Checks 2018 Social Security Taxes 19,619.96 21.79 19,641.75 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Social Security Taxes 789.51 20,431.26 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Social Security Taxes 783.45 21,214.71 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,594.75 21,214.71 ** 28,314.00 Budgeted 7,099.29 Remaining 75 % Used Account: 135-50035-020-000 Medicare Taxes 1801 08/02/2018 Anniversary Checks 2018 Medicare Taxes 4,588.54 5.09 4,593.63 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Medicare Taxes 184.65 4,778.28 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Medicare Taxes 183.21 4,961.49 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-50035-020-000 Medicare Taxes Totals: 372.95 4,961.49 ** 6,622.00 Budgeted 1,660.51 Remaining 75 % Used Account: 135-50040-020-000 Unemployment Taxes 1,134.00 .00 1,134.00 _______________ 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 242 08/01/2018 Insurance/Wrk Comp Exp Aug 13,480.00 1,348.00 14,828.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 14,828.00 ** 17,990.00 Budgeted 3,162.00 Remaining 82 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 235.00 .00 235.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 235.00 ** 300.00 Budgeted 65.00 Remaining 78 % 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 ** 20,550.00 Budgeted 18,405.00 Remaining 10 % Used Account: 135-55080-020-000 Maintenance & Repairs 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 THE HOME DEPOT #6581 75,453.47 64.53 75,518.00 THE HOME DEPOT #6581 PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 TELEDYNE INSTRUMENTS I 50.88 75,568.88 TELEDYNE INSTRUMENTS I PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ROANOKE AUTO SUPPLY LT 75,453.47 24.92 75,593.80 ROANOKE AUTO SUPPLY LT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 TELEDYNE INSTRUMENTS I 364.45 75,958.25 TELEDYNE INSTRUMENTS I PC 1976 08/30/2018 August A/P belt press, belt change 2,048.75 78,007.00 Legacy Contracting, LP 4502 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 2,553.53 78,007.00 ** 86,100.00 Budgeted 8,093.00 Remaining 91 % 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 1929 08/20/2018 August A/P Vac truck 8,307.98 269.50 8,577.48 CLS SEWER EQUIPMENT CO., INC 4478 AP 1976 08/30/2018 August A/P Vac truck tire 564.08 9,141.56 BLAGG TIRE & SERVICE 4489 AP 2019 08/31/2018 August A/P GAP Vax 530.45 9,672.01 CLS SEWER EQUIPMENT CO., INC 4515 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 1,364.03 9,672.01 ** 8,000.00 Budgeted (1,672.01) Remaining 121 % 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 1898 08/13/2018 August A/P Dumpster services 62,901.70 845.00 63,746.70 L.H. CHANEY MATERIALS, INC. 4450 AP 1929 08/20/2018 August A/P Dumpster service 910.07 64,656.77 L.H. CHANEY MATERIALS, INC. 4483 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 1,755.07 64,656.77 ** 60,000.00 Budgeted (4,656.77) Remaining 108 % Used Account: 135-55135-020-000 Lab Analysis 1898 08/13/2018 August A/P Lab testing 26,504.02 246.00 26,750.02 OXIDOR LABORATORIES LLC 4457 AP 1898 08/13/2018 August A/P lab testing 176.00 26,926.02 OXIDOR LABORATORIES LLC 4457 AP 1929 08/20/2018 August A/P lab testing 246.00 27,172.02 OXIDOR LABORATORIES LLC 4485 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1929 08/20/2018 August A/P Lab testing 26,504.02 176.00 27,348.02 OXIDOR LABORATORIES LLC 4485 AP 1976 08/30/2018 August A/P lab testing 246.00 27,594.02 OXIDOR LABORATORIES LLC 4507 AP 1976 08/30/2018 August A/P lab testing 176.00 27,770.02 OXIDOR LABORATORIES LLC 4507 AP 1976 08/30/2018 August A/P lab testing 246.00 28,016.02 OXIDOR LABORATORIES LLC 4507 AP 1976 08/30/2018 August A/P lab testing 176.00 28,192.02 OXIDOR LABORATORIES LLC 4507 AP 2019 08/31/2018 August A/P Bio-monitoring 1,080.00 29,272.02 HUTHER AND ASSOCIATES,INC 4517 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,768.00 29,272.02 ** 30,000.00 Budgeted 727.98 Remaining 98 % Used Account: 135-60010-020-000 Communications/Mobiles 1898 08/13/2018 August A/P Cell phones 4,057.11 405.14 4,462.25 VERIZON WIRELESS 4471 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 405.14 4,462.25 ** 4,700.00 Budgeted 237.75 Remaining 95 % Used Account: 135-60020-020-000 Electricity 1929 08/20/2018 August A/P Electricity 7/11-8/10 135,537.35 12,392.94 147,930.29 HUDSON ENERGY SERVICES, LLC 4482 AP 2044 08/31/2018 Town Billed Invoices 1652-1655 AR 20180831-20180831 User: (217.49) 147,712.80 AR _______________ Account: 135-60020-020-000 Electricity Totals: 12,175.45 147,712.80 ** 266,709.00 Budgeted 118,996.20 Remaining 55 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-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 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-60245-020-000 Miscellaneous Expenses Totals: .00 .01 ** 450.00 Budgeted 449.99 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 41.88 .00 41.88 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 41.88 ** 4,000.00 Budgeted 3,958.12 Remaining 1 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 2019 08/31/2018 August A/P Mowing 6,960.00 1,180.00 8,140.00 WATTS ELLISON LLC 4525 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 8,140.00 ** 11,600.00 Budgeted 3,460.00 Remaining 70 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1986 08/31/2018 Texpool Transfers August 110,948.10 11,094.90 122,043.00 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.90 122,043.00 ** 122,043.00 Budgeted .00 Remaining 100 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1986 08/31/2018 Texpool Transfers August 544,307.20 54,430.80 598,738.00 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.80 598,738.00 ** 598,738.00 Budgeted .00 Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1986 08/31/2018 Texpool Transfers August 102,780.00 10,278.00 113,058.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 113,058.00 ** 123,336.00 Budgeted 10,278.00 Remaining 92 % Used Account: 135-60334-020-000 Interfund Transfer Out 1986 08/31/2018 Texpool Transfers August 463,475.06 181,037.39 644,512.45 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-60334-020-000 Interfund Transfer Out Totals: 181,037.39 644,512.45 ** 200,000.00 Budgeted (444,512.45) Remaining 322 % 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 1976 08/30/2018 August A/P FUEL 7,497.70 623.16 8,120.86 US Bank Voyager Fleet Systems 4511 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 623.16 8,120.86 ** 12,500.00 Budgeted 4,379.14 Remaining 65 % Used Account: 135-65010-020-000 Uniforms 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 TRACTOR SUPPLY COMPANY 1,774.59 79.98 1,854.57 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-020-000 Uniforms Totals: 79.98 1,854.57 ** 4,459.00 Budgeted 2,604.43 Remaining 42 % Used Account: 135-65030-020-000 Chemicals 1898 08/13/2018 August A/P CIP solution 9,234.23 536.00 9,770.23 Valley Solvent Company, INC 4469 AP 1933 08/20/2018 August A/P CIP solution 536.00 10,306.23 Valley Solvent Company, INC 4487 AP 2019 08/31/2018 August A/P Chemicals for collection syste 3,379.50 13,685.73 MICKEY D CARSON DBA/NUSCO 4520 AP 2019 08/31/2018 August A/P CIP Solution 536.00 14,221.73 Valley Solvent Company, INC 4524 AP 2019 08/31/2018 August A/P CIP solution 536.00 14,757.73 Valley Solvent Company, INC 4524 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 5,523.50 14,757.73 ** 27,500.00 Budgeted 12,742.27 Remaining 54 % Used Account: 135-65035-020-000 Small Tools 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 THE HOME DEPOT #6581 1,389.88 46.26 1,436.14 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 46.26 1,436.14 ** 1,000.00 Budgeted (436.14) Remaining 144 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65040-020-000 Safety Equipment 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 1844 08/03/2018 August A/P Lab supplies 16,596.71 1,323.28 17,919.99 IDEXX DISTRIBUTION, INC 4442 AP 1882 08/09/2018 August A/P Lab supplies 109.09 18,029.08 HACH COMPANY 4441 AP 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 TOM THUMB #1789 1.98 18,031.06 TOM THUMB #1789 PC 2019 08/31/2018 August A/P Lab supplies 844.01 18,875.07 IDEXX DISTRIBUTION, INC 4518 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,278.36 18,875.07 ** 14,000.00 Budgeted (4,875.07) Remaining 135 % Used Account: 135-69005-020-000 Capital Outlays 1976 08/30/2018 August A/P legal wwtp 106,519.29 1,870.00 108,389.29 Dubois Bryant Campbell LLP 4497 AP 1976 08/30/2018 August A/P Lega WWTP 255.00 108,644.29 Dubois Bryant Campbell LLP 4497 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 2,125.00 108,644.29 ** 547,327.00 Budgeted 438,682.71 Remaining 20 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 51,342.00 Budgeted 51,342.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest 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 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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,561,380.52 ** 330,537.56 Monthly Total 2,981,140.00 Budgeted 419,759.48 Remaining 86 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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 242 08/01/2018 Insurance/Wrk Comp Exp Aug 24.20 2.42 26.62 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 26.62 ** 30.00 Budgeted 3.38 Remaining 89 % 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 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 TOM THUMB #1789 91.28 11.98 103.26 TOM THUMB #1789 PC _______________ Account: 135-60075-026-000 Meetings Totals: 11.98 103.26 ** 1,200.00 Budgeted 1,096.74 Remaining 9 % 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 1929 08/20/2018 August A/P New director Meeting 4,352.28 415.94 4,768.22 Steve Flynn 4486 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 415.94 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 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 1-800-FLOWERS.COM,INC. 1,404.26 69.72 1,473.98 1-800-FLOWERS.COM,INC. PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 69.72 1,473.98 ** 2,000.00 Budgeted 526.02 Remaining 74 % Used Department 26 Totals: ----------------------------------- 9,777.08 ** 500.06 Monthly Total 12,980.00 Budgeted 3,202.92 Remaining 75 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 1801 08/02/2018 Anniversary Checks 2018 Salaries & Wages 310,302.38 117.17 310,419.55 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Salaries & Wages 13,395.65 323,815.20 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Salaries & Wages 13,386.27 337,201.47 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 26,899.09 337,201.47 ** 432,863.00 Budgeted 95,661.53 Remaining 78 % Used Account: 135-50010-030-000 Overtime 563.05 .00 563.05 _______________ Account: 135-50010-030-000 Overtime Totals: .00 563.05 ** 2,000.00 Budgeted 1,436.95 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 1801 08/02/2018 Anniversary Checks 2018 Retirement 31,390.12 10.84 31,400.96 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Retirement 1,239.11 32,640.07 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Retirement 1,238.24 33,878.31 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,488.19 33,878.31 ** 40,553.00 Budgeted 6,674.69 Remaining 84 % Used Account: 135-50026-030-000 Medical Insurance 1864 08/10/2018 Mud Payroll 08/10/2018 Medical Insurance 39,200.35 2,072.63 41,272.98 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Medical Insurance 2,072.61 43,345.59 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 43,345.59 ** 63,485.00 Budgeted 20,139.41 Remaining 68 % Used Account: 135-50027-030-000 Dental Insurance 1864 08/10/2018 Mud Payroll 08/10/2018 Dental Insurance 2,757.85 129.78 2,887.63 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Dental Insurance 129.74 3,017.37 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 259.52 3,017.37 ** 5,502.00 Budgeted 2,484.63 Remaining 55 % Used Account: 135-50028-030-000 Vision Insurance 1864 08/10/2018 Mud Payroll 08/10/2018 Vision Insurance 504.86 21.28 526.14 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Vision Insurance 21.23 547.37 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 547.37 ** 1,173.00 Budgeted 625.63 Remaining 47 % Used Account: 135-50029-030-000 Life Insurance & Other 1773 08/01/2018 August A/P Employee benefits 3,076.36 201.04 3,277.40 Humana Inc 4394 AP 1882 08/09/2018 August A/P Employee benefits-August 138.66 3,416.06 METLIFE GROUP BENEFITS 4454 AP 1933 08/20/2018 August A/P Café 18.00 3,434.06 BenefitMall 4476 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 357.70 3,434.06 ** 5,059.00 Budgeted 1,624.94 Remaining 68 % Used Account: 135-50030-030-000 Social Security Taxes 1801 08/02/2018 Anniversary Checks 2018 Social Security Taxes 18,720.12 7.27 18,727.39 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Social Security Taxes 792.49 19,519.88 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Social Security Taxes 789.30 20,309.18 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,589.06 20,309.18 ** 27,181.00 Budgeted 6,871.82 Remaining 75 % Used Account: 135-50035-030-000 Medicare Taxes 1801 08/02/2018 Anniversary Checks 2018 Medicare Taxes 4,378.09 1.70 4,379.79 PR 1864 08/10/2018 Mud Payroll 08/10/2018 Medicare Taxes 185.33 4,565.12 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Medicare Taxes 184.60 4,749.72 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 371.63 4,749.72 ** 6,357.00 Budgeted 1,607.28 Remaining 75 % Used Account: 135-50040-030-000 Unemployment Taxes 1864 08/10/2018 Mud Payroll 08/10/2018 Unemployment Taxes 1,070.31 34.61 1,104.92 PR 1940 08/24/2018 MUD Payroll 08/24/2018 Unemployment Taxes 34.62 1,139.54 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-030-000 Unemployment Taxes Totals: 69.23 1,139.54 ** 1,260.00 Budgeted 120.46 Remaining 90 % Used Account: 135-50045-030-000 Workman's Compensation 242 08/01/2018 Insurance/Wrk Comp Exp Aug 1,235.00 123.50 1,358.50 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 1,358.50 ** 1,529.00 Budgeted 170.50 Remaining 89 % 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 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 1-800-FLOWERS.COM,INC. 3,228.47 44.71 3,273.18 1-800-FLOWERS.COM,INC. PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 44.71 3,273.18 ** 4,960.00 Budgeted 1,686.82 Remaining 66 % Used Account: 135-55030-030-000 Software & Support 1929 08/20/2018 August A/P Microsoft exchange 63,876.87 456.00 64,332.87 M3 Networks 4484 AP 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 DNH*GODADDY.COM 15.17 64,348.04 DNH*GODADDY.COM PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 69.12 64,417.16 ATT*BILL PAYMENT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 107.79 64,524.95 ATT*BILL PAYMENT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 124.34 64,649.29 ATT*BILL PAYMENT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 85.71 64,735.00 ATT*BILL PAYMENT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ADOBE SYSTEMS INC 16.23 64,751.23 ADOBE SYSTEMS INC PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 105.57 64,856.80 ATT*BILL PAYMENT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 85.71 64,942.51 ATT*BILL PAYMENT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 107.79 65,050.30 ATT*BILL PAYMENT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 124.34 65,174.64 ATT*BILL PAYMENT PC 1978 08/30/2018 August A/P internet 903.72 66,078.36 Charter Communications 4492 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 2,201.49 66,078.36 ** 78,391.00 Budgeted 12,312.64 Remaining 84 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-55070-030-000 Independent Labor 2019 08/31/2018 August A/P GM-August 127,948.90 11,520.00 139,468.90 Carman Consulting LLC. 4514 AP 2019 08/31/2018 August A/P GM-August 16.90 139,485.80 Carman Consulting LLC. 4514 AP 2035 08/31/2018 August A/P FY19 Fire budget consulting 33.00 139,518.80 DRG ENTERPRISES 4536 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 11,569.90 139,518.80 ** 154,000.00 Budgeted 14,481.20 Remaining 91 % Used Account: 135-55080-030-000 Maintenance & Repairs 1976 08/30/2018 August A/P cups/binder 5,160.69 14.38 5,175.07 OFFICE DEPOT, INC 4506 AP 1976 08/30/2018 August A/P ac maintenance-quarter 160.00 5,335.07 BRANDON R REED 4490 AP 2042 08/31/2018 Refund/Clearing G&K Rug Serv (332.59) 5,002.48 GL 2022 08/31/2018 Recode Bld Main/Repairs 398.00 5,400.48 GL _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 239.79 5,400.48 ** 14,000.00 Budgeted 8,599.52 Remaining 39 % 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-55100-030-000 Building Maint & Supplies 2022 08/31/2018 Recode Bld Main/Repairs 398.00 (398.00) .00 GL _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: (398.00) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 1976 08/30/2018 August A/P Janitorial service 7,438.63 869.06 8,307.69 MEMBER'S BUILDING MAINTENANCE 4504 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 8,307.69 ** 10,000.00 Budgeted 1,692.31 Remaining 83 % Used Account: 135-55160-030-000 Professional Outside Services 59,240.00 .00 59,240.00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-55160-030-000 Professional Outside Services Totals: .00 59,240.00 ** 63,325.00 Budgeted 4,085.00 Remaining 94 % 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 5,891.80 .00 5,891.80 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 5,891.80 ** 9,000.00 Budgeted 3,108.20 Remaining 65 % Used Account: 135-60005-030-000 Telephone 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 13,693.87 190.36 13,884.23 ATT*BILL PAYMENT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 RINGCENTRAL, INC 13.95 13,898.18 RINGCENTRAL, INC PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BUS PHONE PMT 461.23 14,359.41 ATT*BUS PHONE PMT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BUS PHONE PMT 859.34 15,218.75 ATT*BUS PHONE PMT PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 ATT*BILL PAYMENT 190.36 15,409.11 ATT*BILL PAYMENT PC 2044 08/31/2018 Town Billed Invoices 1652-1655 AR 20180831-20180831 User: (180.00) 15,229.11 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,535.24 15,229.11 ** 27,300.00 Budgeted 12,070.89 Remaining 56 % Used Account: 135-60010-030-000 Communications/Mobiles 1898 08/13/2018 August A/P Cell phones 2,511.50 87.33 2,598.83 VERIZON WIRELESS 4471 AP 1940 08/24/2018 MUD Payroll 08/24/2018 Communications/Mobiles 150.00 2,748.83 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.33 2,748.83 ** 4,000.00 Budgeted 1,251.17 Remaining 69 % Used Account: 135-60020-030-000 Electricity/Gas 5,988.92 .00 5,988.92 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 5,988.92 ** 16,261.00 Budgeted 10,272.08 Remaining 37 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60025-030-000 Water 2019 08/31/2018 August A/P Water-August 592.26 136.50 728.76 TROPHY CLUB MUD (WATER BILLS) 4523 AP 2044 08/31/2018 Town Billed Invoices 1652-1655 AR 20180831-20180831 User: (68.25) 660.51 AR _______________ Account: 135-60025-030-000 Water Totals: 68.25 660.51 ** 2,500.00 Budgeted 1,839.49 Remaining 26 % Used Account: 135-60035-030-000 Postage 17,849.47 .00 17,849.47 _______________ Account: 135-60035-030-000 Postage Totals: .00 17,849.47 ** 30,000.00 Budgeted 12,150.53 Remaining 59 % Used Account: 135-60040-030-000 Service Charges & Fees 1865 08/10/2018 Child Support Fee 49,057.75 1.50 49,059.25 GL 1942 08/24/2018 Child Support Fee 1.50 49,060.75 GL 1996 08/31/2018 Pace Credit Card Fees 6,426.67 55,487.42 GL 1996 08/31/2018 Pace Credit Card Fees 128.28 55,615.70 GL 2019 08/31/2018 August A/P Direct send fees 50.00 55,665.70 Fiserv Solutions, LLC 4516 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 6,607.95 55,665.70 ** 55,560.00 Budgeted (105.70) Remaining 100 % 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 242 08/01/2018 Insurance/Wrk Comp Exp Aug 64,798.60 6,100.36 70,898.96 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 70,898.96 ** 56,000.00 Budgeted (14,898.96) Remaining 127 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 206.38 .00 206.38 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60066-030-000 Publications/Books/Subscripts Totals: .00 206.38 ** 1,600.00 Budgeted 1,393.62 Remaining 13 % 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 Account: 135-60075-030-000 Meetings 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 SALAD BOWL 10 80.50 43.08 123.58 SALAD BOWL 10 PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 TOM THUMB #1789 9.98 133.56 TOM THUMB #1789 PC _______________ Account: 135-60075-030-000 Meetings Totals: 53.06 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 1864 08/10/2018 Mud Payroll 08/10/2018 Travel & per diem 1,580.52 90.80 1,671.32 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 90.80 1,671.32 ** 4,885.00 Budgeted 3,213.68 Remaining 34 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-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 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 YOURMEMBER-CAREERS 150.00 150.00 300.00 YOURMEMBER-CAREERS PC _______________ Account: 135-60125-030-000 Advertising Totals: 150.00 300.00 ** 2,500.00 Budgeted 2,200.00 Remaining 12 % Used Account: 135-60235-030-000 Security 1976 08/30/2018 August A/P monitoring service 394.00 24.00 418.00 Digital Air Control, Inc 4495 AP _______________ Account: 135-60235-030-000 Security Totals: 24.00 418.00 ** 2,700.00 Budgeted 2,282.00 Remaining 15 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-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 273.73 .00 273.73 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 273.73 ** 700.00 Budgeted 426.27 Remaining 39 % Used Account: 135-65055-030-000 Hardware 2,006.68 .00 2,006.68 _______________ Account: 135-65055-030-000 Hardware Totals: .00 2,006.68 ** 7,420.00 Budgeted 5,413.32 Remaining 27 % Used Account: 135-65085-030-000 Office Supplies 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 AMZN MKTP US 4,006.92 46.19 4,053.11 AMZN MKTP US PC 2039 08/27/2018 Pcard 07/27/18 - 08/27/18 SP * DESKTOPSUPPLIES 55.98 4,109.09 SP * DESKTOPSUPPLIES PC 1976 08/30/2018 August A/P cups/binder 41.99 4,151.08 OFFICE DEPOT, INC 4506 AP 1976 08/30/2018 August A/P office supplies 30.49 4,181.57 OFFICE DEPOT, INC 4506 AP 1976 08/30/2018 August A/P office supplies 7.12 4,188.69 OFFICE DEPOT, INC 4506 AP 1976 08/30/2018 August A/P paper 59.98 4,248.67 OFFICE DEPOT, INC 4506 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 241.75 4,248.67 ** 7,000.00 Budgeted 2,751.33 Remaining 61 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2036 08/31/2018 August A/P Printer toner for WW 2,048.66 316.39 2,365.05 OFFICE DEPOT, INC 4547 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 316.39 2,365.05 ** 2,000.00 Budgeted (365.05) Remaining 118 % Used Account: 135-65095-030-000 Maintenance Supplies 3,796.71 .00 3,796.71 _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: .00 3,796.71 ** 4,000.00 Budgeted 203.29 Remaining 95 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-65105-030-000 Printing 144.00 .00 144.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used Account: 135-69005-030-000 Capital Outlays 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 1976 08/30/2018 August A/P copier lease 2,461.74 100.57 2,562.31 KYOCERA DOCUMENT SOLUTIONS 4500 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 100.57 2,562.31 ** 4,600.00 Budgeted 2,037.69 Remaining 56 % Used Department 30 Totals: ----------------------------------- 1,005,944.26 ** 66,398.32 Monthly Total 1,227,112.00 Budgeted 221,167.74 Remaining 82 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 2036 08/31/2018 August A/P Legal 117,921.90 3,390.00 121,311.90 McLean & Howard, L.L.P. 4546 AP 2036 08/31/2018 August A/P legal 1,050.00 122,361.90 McLean & Howard, L.L.P. 4546 AP _______________ Account: 135-55045-039-000 Legal Totals: 4,440.00 122,361.90 ** 137,000.00 Budgeted 14,638.10 Remaining 89 % 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 8,683.92 .00 8,683.92 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,683.92 ** 11,446.00 Budgeted 2,762.08 Remaining 76 % 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: ----------------------------------- 159,672.92 ** 4,440.00 Monthly Total 176,746.00 Budgeted 17,073.08 Remaining 90 % Used Fund 135 Totals: ----------------------------------- (2,033,921.69) (95,670.26) Monthly Total (194,618.00) Budgeted 1,839,303.69 Remaining ########## . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/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 AUGUST 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 683,698 TOTAL LIABILITIES 683,698 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,676,277) TOTAL FUND BALANCE (683,698) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 20:16 09/08/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/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 20:16 09/08/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/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 181,037.39- 644,512.45- 644,512.45 Subtotal: 181,037.39- 644,512.45- 644,512.45 Program number: 181,037.39- 644,512.45- 644,512.45 Department number: Wastewater 181,037.39- 644,512.45- 644,512.45 Revenues Subtotal ----------- 181,037.39- 653,860.61- 653,860.61 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 20:16 09/08/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/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 64,443.38 2,329,982.97 2,329,982.97- Subtotal: 64,443.38 2,329,982.97 2,329,982.97- Program number: 64,443.38 2,330,137.86 2,330,137.86- Department number: Wastewater 64,443.38 2,330,137.86 2,330,137.86- Expenditures Subtotal ----------- 64,443.38 2,330,137.86 2,330,137.86- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 116,594.01- 1,676,277.25 1,676,277.25- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/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 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/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 1986 08/31/2018 Texpool Transfers August (463,475.06) (181,037.39) (644,512.45) GL _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (181,037.39) (644,512.45) ** .00 Budgeted 644,512.45 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 1976 08/30/2018 August A/P WWTP improvements 2,265,539.59 64,443.38 2,329,982.97 WEBBER-CADAGUA PARTNERS 4512 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 64,443.38 2,329,982.97 ** .00 Budgeted (2,329,982.97) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,685,625.41 ** (116,594.01) Monthly Total .00 Budgeted (1,685,625.41) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,676,277.25 (116,594.01) Monthly Total .00 Budgeted (1,676,277.25) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET AUGUST 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 749,385 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 749,385 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,489,354) TOTAL FUND BALANCE 736,227 TOTAL LIABILITIES AND FUND BALANCE 749,385 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 20:16 09/08/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 8/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 1,534.17- 1,534.17 519-49141-000-000 Interfund Transfer In-Gen Fund 1,053,935.08- 1,053,935.08 Subtotal: 1,055,469.25- 1,055,469.25 Program number: 1,055,469.25- 1,055,469.25 Department number: Revenues 1,055,469.25- 1,055,469.25 Revenues Subtotal ----------- 1,055,469.25- 1,055,469.25 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 20:16 09/08/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 8/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,851,614.33 1,851,614.33- Subtotal: 1,851,614.33 1,851,614.33- 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: 4,544,823.01 4,544,823.01- Department number: Water 4,544,823.01 4,544,823.01- Expenditures Subtotal ----------- 4,544,823.01 4,544,823.01- Fund number: 519 2016 Rev Bond Const-SWIFT 3,489,353.76 3,489,353.76- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 8/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 (1,534.17) .00 (1,534.17) _______________ Account: 519-49010-000-000 Interest Income Totals: .00 (1,534.17) ** .00 Budgeted 1,534.17 Remaining 0 % Used Account: 519-49141-000-000 Interfund Transfer In-Gen Fund (1,053,935.08) .00 (1,053,935.08) _______________ Account: 519-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (1,053,935.08) ** .00 Budgeted 1,053,935.08 Remaining 0 % Used Department Totals: ----------------------------------- (1,055,469.25) ** .00 Monthly Total .00 Budgeted 1,055,469.25 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 8/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 1,851,614.33 .00 1,851,614.33 _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: .00 1,851,614.33 ** .00 Budgeted (1,851,614.33) 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: ----------------------------------- 4,544,823.01 ** .00 Monthly Total .00 Budgeted (4,544,823.01) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 3,489,353.76 .00 Monthly Total .00 Budgeted (3,489,353.76) Remaining 0 % Used TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET AUGUST 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 213,458 TOTAL LIABILITIES 213,458 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES (173,559) TOTAL FUND BALANCE (213,458) TOTAL LIABILITIES AND FUND BALANCE 0 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 20:16 09/08/18 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 8/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 173,558.94 173,558.94- Subtotal: 173,558.94 173,558.94- Program number: 173,558.94 173,558.94- Department number: Water Department 173,558.94 173,558.94- Expenditures Subtotal ----------- 173,558.94 173,558.94- Fund number: 520 Revenue Bond 16" Waterline 173,558.94 173,558.94- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 8/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 173,558.94 .00 173,558.94 _______________ Account: 520-69005-010-000 Capital Outlays Totals: .00 173,558.94 ** .00 Budgeted (173,558.94) Remaining 0 % Used Department 10 Totals: ----------------------------------- 173,558.94 ** .00 Monthly Total .00 Budgeted (173,558.94) Remaining 0 % Used Fund 520 Totals: ----------------------------------- 173,558.94 .00 Monthly Total .00 Budgeted (173,558.94) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET AUGUST 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 591,576 ACCOUNTS RECEIVABLE - TOTAL ASSETS 591,576 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 164,997 TOTAL FUND BALANCE 591,576 TOTAL LIABILITIES AND FUND BALANCE 591,576 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 20:16 09/08/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 8/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- 946.07- 7,026.74- 702.674 6,026.74 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 44,913.00- 91.667 4,083.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 113,058.00- 91.667 10,278.00- Subtotal: 173,332.00- 173,332.00- 15,307.07- 164,997.74- 95.192 8,334.26- Program number: 173,332.00- 173,332.00- 15,307.07- 164,997.74- 95.192 8,334.26- Department number: 173,332.00- 173,332.00- 15,307.07- 164,997.74- 95.192 8,334.26- Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,307.07- 164,997.74- 95.192 8,334.26- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,307.07- 164,997.74- 95.192 8,334.26- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 8/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 2045 08/31/2018 Bank Interest- August (6,080.67) (946.07) (7,026.74) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (946.07) (7,026.74) ** (1,000.00) Budgeted 6,026.74 Remaining 703 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1986 08/31/2018 Texpool Transfers August (40,830.00) (4,083.00) (44,913.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (44,913.00) ** (48,996.00) Budgeted (4,083.00) Remaining 92 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1986 08/31/2018 Texpool Transfers August (102,780.00) (10,278.00) (113,058.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (113,058.00) ** (123,336.00) Budgeted (10,278.00) Remaining 92 % Used Department Totals: ----------------------------------- (164,997.74) ** (15,307.07) Monthly Total (173,332.00) Budgeted (8,334.26) Remaining 95 % Used Fund 528 Totals: ----------------------------------- (164,997.74) (15,307.07) Monthly Total (173,332.00) Budgeted (8,334.26) Remaining 95 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET AUGUST 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 49,080 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 9,552 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 63,205 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 9,552 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 9,552 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 21,312 TOTAL FUND BALANCE 53,653 TOTAL LIABILITIES AND FUND BALANCE 63,205 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 20:16 09/08/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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- 818.53- 677,002.12- 101.096 7,342.12 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- 67.27- 2,004.21- 100.211 4.21 Subtotal: 673,460.00- 673,460.00- 885.80- 681,631.10- 101.213 8,171.10 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,108.69- 8,841.50- 442.075 6,841.50 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- 11,094.90- 122,043.00- 100.000 Subtotal: 342,997.00- 342,997.00- 12,203.59- 349,838.50- 101.995 6,841.50 Program number: 1,016,457.00- 1,016,457.00- 13,089.39- 1,031,469.60- 101.477 15,012.60 Department number: Revenues 1,016,457.00- 1,016,457.00- 13,089.39- 1,031,469.60- 101.477 15,012.60 Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 13,089.39- 1,031,469.60- 101.477 15,012.60 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 20:16 09/08/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/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 200.00 1,650.00 76.744 500.00 533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 141,753.75 283,507.50 100.000 .50 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 725,000.00 100.000 Subtotal: 1,010,658.00 1,010,658.00 866,953.75 1,010,157.50 99.950 500.50 Program number: 1,010,658.00 1,010,658.00 866,953.75 1,010,157.50 99.950 500.50 Department number: Administration 1,010,658.00 1,010,658.00 866,953.75 1,010,157.50 99.950 500.50 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 866,953.75 1,010,157.50 99.950 500.50 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 853,864.36 21,312.10- 367.513 15,513.10 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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 2007 08/01/2018 Property Taxes (676,183.59) (84.55) (676,268.14) GL 2008 08/02/2018 Property Taxes (243.79) (676,511.93) GL 2009 08/03/2018 Property Taxes (35.22) (676,547.15) GL 2010 08/06/2018 Property Taxes (24.83) (676,571.98) GL 2011 08/07/2018 Property Taxes (26.77) (676,598.75) GL 2012 08/21/2018 Property Taxes (334.59) (676,933.34) GL 2013 08/27/2018 Property Taxes (64.08) (676,997.42) GL 2014 08/29/2018 Property Taxes (4.70) (677,002.12) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (818.53) (677,002.12) ** (669,660.00) Budgeted 7,342.12 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 2008 08/02/2018 Property Taxes (1,936.94) (3.14) (1,940.08) GL 2011 08/07/2018 Property Taxes (.23) (1,940.31) GL 2012 08/21/2018 Property Taxes (63.57) (2,003.88) GL 2014 08/29/2018 Property Taxes (.33) (2,004.21) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (67.27) (2,004.21) ** (2,000.00) Budgeted 4.21 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 2045 08/31/2018 Bank Interest- August (7,732.81) (1,108.69) (8,841.50) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1,108.69) (8,841.50) ** (2,000.00) Budgeted 6,841.50 Remaining 442 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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-49141-000-000 Interfund Trans In-PID Surchg 1986 08/31/2018 Texpool Transfers August (110,948.10) (11,094.90) (122,043.00) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.90) (122,043.00) ** (122,043.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (1,031,469.60) ** (13,089.39) Monthly Total (1,016,457.00) Budgeted 15,012.60 Remaining 101 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/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 2046 08/24/2018 9/1/18 Bond Payments BOKF Unl Tax Bond, 1TROP1214UT 1,450.00 200.00 1,650.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 200.00 1,650.00 ** 2,150.00 Budgeted 500.00 Remaining 77 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 2046 08/24/2018 9/1/18 Bond Payments BOKF Unl Tax Bond, 1TROP1214UT 141,753.75 70,600.00 212,353.75 GL 2046 08/24/2018 9/1/18 Bond Payments BNY MELLON Unl Tax Series 2010 32,928.75 245,282.50 GL 2046 08/24/2018 9/1/18 Bond Payments BNYMELLON Unl Tax Ref Ser 2012 19,612.50 264,895.00 GL 2046 08/24/2018 9/1/18 Bond Payments BNYMELLON Unl Tax Ref Ser 2013 18,612.50 283,507.50 GL _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: 141,753.75 283,507.50 ** 283,508.00 Budgeted .50 Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 2046 08/24/2018 9/1/18 Bond Payments BOKF Unl Tax Bond, 1TROP1214UT 245,000.00 245,000.00 GL 2046 08/24/2018 9/1/18 Bond Payments BNY MELLON Unl Tax Series 2010 85,000.00 330,000.00 GL 2046 08/24/2018 9/1/18 Bond Payments BNYMELLON Unl Tax Ref Ser 2012 210,000.00 540,000.00 GL 2046 08/24/2018 9/1/18 Bond Payments BNYMELLON Unl Tax Ref Ser 2013 185,000.00 725,000.00 GL _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: 725,000.00 725,000.00 ** 725,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 1,010,157.50 ** 866,953.75 Monthly Total 1,010,658.00 Budgeted 500.50 Remaining 100 % Used Fund 533 Totals: ----------------------------------- (21,312.10) 853,864.36 Monthly Total (5,799.00) Budgeted 15,513.10 Remaining 368 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET AUGUST 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 19,530 ACCOUNTS RECEIVABLE - TOTAL ASSETS 19,530 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,211 NET REVENUES / EXPENDITURES 3,319 TOTAL FUND BALANCE 19,530 TOTAL LIABILITIES AND FUND BALANCE 19,530 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 20:16 09/08/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 8/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- 552.01- 3,318.79- 331.879 2,318.79 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.80- 598,738.00- 100.000 Subtotal: 599,738.00- 599,738.00- 54,982.81- 602,056.79- 100.387 2,318.79 Program number: 599,738.00- 599,738.00- 54,982.81- 602,056.79- 100.387 2,318.79 Department number: Revenues 599,738.00- 599,738.00- 54,982.81- 602,056.79- 100.387 2,318.79 Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,982.81- 602,056.79- 100.387 2,318.79 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 20:16 09/08/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/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 200.00 400.00 100.000 534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 111,668.75 223,337.50 100.000 .50 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 375,000.00 100.000 Subtotal: 598,738.00 598,738.00 486,868.75 598,737.50 100.000 .50 Program number: 598,738.00 598,738.00 486,868.75 598,737.50 100.000 .50 Department number: Administration 598,738.00 598,738.00 486,868.75 598,737.50 100.000 .50 Expenditures Subtotal ----------- 598,738.00 598,738.00 486,868.75 598,737.50 100.000 .50 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 431,885.94 3,319.29- 331.929 2,319.29 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 8/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 2045 08/31/2018 Bank Interest- August (2,766.78) (552.01) (3,318.79) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (552.01) (3,318.79) ** (1,000.00) Budgeted 2,318.79 Remaining 332 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1986 08/31/2018 Texpool Transfers August (544,307.20) (54,430.80) (598,738.00) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.80) (598,738.00) ** (598,738.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (602,056.79) ** (54,982.81) Monthly Total (599,738.00) Budgeted 2,318.79 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/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 2046 08/24/2018 9/1/18 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS 200.00 200.00 400.00 GL _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 400.00 ** 400.00 Budgeted .00 Remaining 100 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 2046 08/24/2018 9/1/18 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS 111,668.75 111,668.75 223,337.50 GL _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 111,668.75 223,337.50 ** 223,338.00 Budgeted .50 Remaining 100 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense 2046 08/24/2018 9/1/18 Bond Payments BOKF Rev Bond WWTP 1TROP215WSS 375,000.00 375,000.00 GL _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: 375,000.00 375,000.00 ** 375,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 598,737.50 ** 486,868.75 Monthly Total 598,738.00 Budgeted .50 Remaining 100 % Used Fund 534 Totals: ----------------------------------- (3,319.29) 431,885.94 Monthly Total (1,000.00) Budgeted 2,319.29 Remaining 332 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET AUGUST 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 2,580 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,580 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 1,628 TOTAL FUND BALANCE 2,580 TOTAL LIABILITIES AND FUND BALANCE 2,580 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 20:16 09/08/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 8/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- 270.34- 1,627.78- 271.297 1,027.78 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.40- 278,083.50- 100.000 .50- Subtotal: 278,684.00- 278,684.00- 25,550.74- 279,711.28- 100.369 1,027.28 Program number: 278,684.00- 278,684.00- 25,550.74- 279,711.28- 100.369 1,027.28 Department number: Revenues 278,684.00- 278,684.00- 25,550.74- 279,711.28- 100.369 1,027.28 Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,550.74- 279,711.28- 100.369 1,027.28 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 26 20:16 09/08/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 8/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 200.00 400.00 100.000 535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 31,341.75 62,683.50 99.999 .50 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 215,000.00 100.000 Subtotal: 278,084.00 278,084.00 246,541.75 278,083.50 100.000 .50 Program number: 278,084.00 278,084.00 246,541.75 278,083.50 100.000 .50 Department number: Administration 278,084.00 278,084.00 246,541.75 278,083.50 100.000 .50 Expenditures Subtotal ----------- 278,084.00 278,084.00 246,541.75 278,083.50 100.000 .50 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 220,991.01 1,627.78- 271.297 1,027.78 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 8/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 2045 08/31/2018 Bank Interest- August (1,357.44) (270.34) (1,627.78) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (270.34) (1,627.78) ** (600.00) Budgeted 1,027.78 Remaining 271 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1986 08/31/2018 Texpool Transfers August (252,803.10) (25,280.40) (278,083.50) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.40) (278,083.50) ** (278,084.00) Budgeted (.50) Remaining 100 % Used Department Totals: ----------------------------------- (279,711.28) ** (25,550.74) Monthly Total (278,684.00) Budgeted 1,027.28 Remaining 100 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 20:17 09/08/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 8/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 2046 08/24/2018 9/1/18 Bond Payments BOKF SWIFT 1TROP1116WSS 200.00 200.00 400.00 GL _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 400.00 ** 400.00 Budgeted .00 Remaining 100 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 2046 08/24/2018 9/1/18 Bond Payments BOKF SWIFT 1TROP1116WSS 31,341.75 31,341.75 62,683.50 GL _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 31,341.75 62,683.50 ** 62,684.00 Budgeted .50 Remaining 100 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense 2046 08/24/2018 9/1/18 Bond Payments BOKF SWIFT 1TROP1116WSS 215,000.00 215,000.00 GL _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: 215,000.00 215,000.00 ** 215,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 278,083.50 ** 246,541.75 Monthly Total 278,084.00 Budgeted .50 Remaining 100 % Used Fund 535 Totals: ----------------------------------- (1,627.78) 220,991.01 Monthly Total (600.00) Budgeted 1,027.78 Remaining 271 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 2,854,035.95 **** 1,329,787.57 Monthly Total (375,349.00) Budgeted (3,229,384.95) Remaining ########## ******* End of Report *********