Loading...
HomeMy WebLinkAbout2018-02 February Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET FEBRUARY 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 861,313 PREPAID EXPENSES 8,889 ADVALOREM PROPERTY TAXES RECEIVABLE 54,869 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 925,070 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 54,869 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 54,869 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 347,950 TOTAL FUND BALANCE 870,202 TOTAL LIABILITIES AND FUND BALANCE 925,070 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 22:56 03/15/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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- 63,644.94- 1,031,746.08- 97.848 22,686.92- 122-40011-000-000 Property Taxes/Fire-Delinquent 45.76- 2,874.28- 2,874.28 122-40020-000-000 Property Taxes/Fire P&I 541.57- 2,404.11- 2,404.11 Subtotal: 1,054,433.00- 1,054,433.00- 64,232.27- 1,037,024.47- 98.349 17,408.53- Program number: 1,054,433.00- 1,054,433.00- 64,232.27- 1,037,024.47- 98.349 17,408.53- Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 64,232.27- 1,037,024.47- 98.349 17,408.53- Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 64,232.27- 1,037,024.47- 98.349 17,408.53- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 22:56 03/15/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 218,954.00 100.000 122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.87 6,349.35 35.274 11,650.65 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 253,712.50 41.667 355,197.50 Subtotal: 845,864.00 845,864.00 270,966.37 479,015.85 56.630 366,848.15 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 270,966.37 689,074.94 65.350 365,358.06 Department number: Fire 1,054,433.00 1,054,433.00 270,966.37 689,074.94 65.350 365,358.06 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 270,966.37 689,074.94 65.350 365,358.06 Fund number: 122 Trophy Club MUD Fire Dept. 206,734.10 347,949.53- 347,949.53 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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 939 02/01/2018 Property Taxes (968,101.14) (9,199.60) (977,300.74) GL 940 02/02/2018 Property Taxes (25,707.44) (1,003,008.18) GL 941 02/05/2018 Property Taxes (7,357.75) (1,010,365.93) GL 942 02/06/2018 Property Taxes (4,200.85) (1,014,566.78) GL 943 02/07/2018 Property Taxes (11,559.45) (1,026,126.23) GL 944 02/09/2018 Property Taxes (415.91) (1,026,542.14) GL 945 02/13/2018 Property Taxes (202.41) (1,026,744.55) GL 946 02/14/2018 Property Taxes (408.76) (1,027,153.31) GL 947 02/16/2018 Property Taxes (456.91) (1,027,610.22) GL 948 02/20/2018 Property Taxes (1,118.34) (1,028,728.56) GL 949 02/21/2018 Property Taxes (21.01) (1,028,749.57) GL 950 02/22/2018 Property Taxes (24.02) (1,028,773.59) GL 951 02/23/2018 Property Taxes (10.09) (1,028,783.68) GL 952 02/26/2018 Property Taxes (1,533.59) (1,030,317.27) GL 953 02/27/2018 Property Taxes (496.86) (1,030,814.13) GL 954 02/28/2018 Property Taxes (931.95) (1,031,746.08) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (63,644.94) (1,031,746.08) ** (1,054,433.00) Budgeted (22,686.92) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 939 02/01/2018 Property Taxes (2,828.52) (7.09) (2,835.61) GL 940 02/02/2018 Property Taxes (.25) (2,835.86) GL 945 02/13/2018 Property Taxes (29.04) (2,864.90) GL 946 02/14/2018 Property Taxes (9.38) (2,874.28) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (45.76) (2,874.28) ** .00 Budgeted 2,874.28 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 939 02/01/2018 Property Taxes (1,862.54) (20.30) (1,882.84) GL 940 02/02/2018 Property Taxes (2.80) (1,885.64) GL 942 02/06/2018 Property Taxes (51.24) (1,936.88) GL 943 02/07/2018 Property Taxes (37.95) (1,974.83) GL 944 02/09/2018 Property Taxes (21.73) (1,996.56) GL 945 02/13/2018 Property Taxes (21.44) (2,018.00) GL 946 02/14/2018 Property Taxes (30.49) (2,048.49) GL 947 02/16/2018 Property Taxes (41.37) (2,089.86) GL 948 02/20/2018 Property Taxes (78.30) (2,168.16) GL 949 02/21/2018 Property Taxes (1.48) (2,169.64) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 951 02/23/2018 Property Taxes (1,862.54) (1.17) (2,170.81) GL 952 02/26/2018 Property Taxes (107.37) (2,278.18) GL 953 02/27/2018 Property Taxes (34.77) (2,312.95) GL 954 02/28/2018 Property Taxes (91.16) (2,404.11) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (541.57) (2,404.11) ** .00 Budgeted 2,404.11 Remaining 0 % Used Department Totals: ----------------------------------- (1,037,024.47) ** (64,232.27) Monthly Total (1,054,433.00) Budgeted (17,408.53) Remaining 98 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 962 02/28/2018 Texpool Transfers Feb 218,954.00 218,954.00 GL _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: 218,954.00 218,954.00 ** 218,954.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 236 02/01/2018 Insurance/Wrk Comp Exp Feb 5,079.48 1,269.87 6,349.35 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 6,349.35 ** 18,000.00 Budgeted 11,650.65 Remaining 35 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 753 02/07/2018 February A/P Feb fire admin 202,970.00 50,742.50 253,712.50 TOWN OF TROPHY CLUB 3912 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 253,712.50 ** 608,910.00 Budgeted 355,197.50 Remaining 42 % 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: ----------------------------------- 689,074.94 ** 270,966.37 Monthly Total 1,054,433.00 Budgeted 365,358.06 Remaining 65 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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: ----------------------------------- (347,949.53) 206,734.10 Monthly Total .00 Budgeted 347,949.53 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET FEBRUARY 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,491,449 - 1,491,449 CASH IN BANK-SAVINGS-CASH RESERVE 781,493 - 781,493 CD-BANK OF THE WEST/THB DEPOSIT 35,316 - 35,316 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 714,630 - 714,630 INVESTMENTS-TEXPOOL 1,148,492 596,426 1,744,918 PREPAID EXPENSES 62,805 - 62,805 ADVALOREM PROPERTY TAXES RECEIVABLE 6,215 - 6,215 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,037,777 - 1,037,777 TOTAL ASSETS 5,278,778 596,426 5,875,204 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 6,215 - 6,215 ACCOUNTS AND OTHER PAYABLES 407,210 - 407,210 CUSTOMER DEPOSITS 313,815 - 313,815 - TOTAL LIABILITIES 727,240 - 727,240 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 401,170 - 401,170 - TOTAL FUND BALANCE 4,551,538 596,426 5,147,964 TOTAL LIABILITIES AND FUND BALANCE 5,278,778 596,426 5,875,204 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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- 7,300.22- 118,343.00- 97.845 2,607.00- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 3.63- 188.93- 94.465 11.07- 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 61.82- 254.47- 127.235 54.47 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 7,365.67- 118,786.40- 39.703 180,402.60- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 318,712.58- 1,894,035.59- 29.301 4,569,983.41- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 241,762.68- 1,185,209.86- 39.798 1,792,857.14- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 7,246.79- 51,257.82- 48.229 55,021.18- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,100.00- 5,975.00- 27.986 15,375.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 250.00- 1,400.00- 93.333 100.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 750.00- 3,400.00- 75.556 1,100.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 357.60- 9,476.00- 15.793 50,524.00- Subtotal: 9,635,715.00- 9,635,715.00- 570,179.65- 3,150,754.27- 32.699 6,484,960.73- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 3,635.37- 15,887.03- 132.392 3,887.03 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 4,825.77- 44.168 6,100.23- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,916.65- 41.666 4,083.35- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 1,715.00- 8,748.76- 48.126 9,430.24- 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 237.88- 5,853.45- 117.069 853.45 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.00- 135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00- Subtotal: 315,125.00- 315,125.00- 7,150.39- 38,231.66- 12.132 276,893.34- Program number: 10,250,029.00- 10,250,029.00- 584,695.71- 3,307,772.33- 32.271 6,942,256.67- Department number: Revenues 10,250,029.00- 10,250,029.00- 584,695.71- 3,307,772.33- 32.271 6,942,256.67- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 584,695.71- 3,307,772.33- 32.271 6,942,256.67- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 17,803.19 81,990.64 29.893 192,288.36 135-50010-010-000 Overtime 20,000.00 20,000.00 477.08 3,218.16 16.091 16,781.84 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 175.00 900.00 27.273 2,400.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,707.10 9,681.19 34.771 18,161.81 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 12,158.23 23.293 40,037.77 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 207.16 1,093.74 21.107 4,088.26 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 208.39 20.965 785.61 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 181.15 1,026.00 34.406 1,956.00 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,126.64 5,507.77 29.513 13,154.23 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 263.48 1,288.09 29.510 3,076.91 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 15.04 41.08 3.804 1,038.92 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 4,499.60 37.958 7,354.40 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 226.05 113.025 26.05- 135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 25,840.48 125,167.93 29.337 301,494.07 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 1,676.17 32,879.48 32.879 67,120.52 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 239.73 2,817.39 70.435 1,182.61 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 2,093.44 38.063 3,406.56 Subtotal: 391,000.00 391,000.00 1,915.90 37,790.31 9.665 353,209.69 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 370.64 1,381.62 29.396 3,318.38 135-60020-010-000 Electricity 175,356.00 175,356.00 8,182.14 56,280.14 32.095 119,075.86 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 2,785.00 2,785.00 739.78 974.78 35.001 1,810.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 5,122.40 12,808.05 23.213 42,367.95 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 107,996.70 613,489.41 21.731 2,209,680.59 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 322.70 10.757 2,677.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 2,250.00 15.254 12,500.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 126,401.55 45.454 151,682.45 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 20,415.00 41.667 28,581.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 151,774.97 839,438.75 23.228 2,774,413.25 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 949.94 3,933.52 26.223 11,066.48 135-65010-010-000 Uniforms 4,488.00 4,488.00 160.93 990.57 22.072 3,497.43 135-65030-010-000 Chemicals 20,000.00 20,000.00 2,243.01 6,641.39 33.207 13,358.61 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 12,400.00 24.800 37,600.00 135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 48,900.00 58.214 35,100.00 Subtotal: 175,688.00 175,688.00 3,353.88 72,865.48 41.474 102,822.52 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 103,551.95 223,608.22 27.606 586,403.78 135-69008-010-000 Short Term Debt-Principal 38,731.00 38,731.00 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 5,713.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 107,864.38 90.814 10,910.62 Subtotal: 1,048,231.00 1,048,231.00 103,551.95 406,472.60 38.777 641,758.40 Program number: 5,655,433.00 5,655,433.00 286,437.18 1,481,735.07 26.200 4,173,697.93 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/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 743.89 37.195 1,256.11 Subtotal: 2,000.00 2,000.00 743.89 37.195 1,256.11 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 743.89 37.195 1,256.11 Department number: Water 5,657,433.00 5,657,433.00 286,437.18 1,482,478.96 26.204 4,174,954.04 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 30,650.18 153,412.58 37.339 257,453.42 135-50010-020-000 Overtime 30,000.00 30,000.00 2,256.32 12,387.08 41.290 17,612.92 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 811.00 3,536.00 42.095 4,864.00 135-50020-020-000 Retirement 42,243.00 42,243.00 3,108.60 17,803.63 42.146 24,439.37 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 6,108.45 26,347.50 42.376 35,827.50 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 375.10 1,948.16 36.960 3,322.84 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 65.49 383.97 34.468 730.03 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 376.07 1,960.19 45.788 2,320.81 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,909.15 10,278.21 36.301 18,035.79 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 446.49 2,403.77 36.300 4,218.23 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 26.08 60.88 4.832 1,199.12 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 6,740.00 37.465 11,250.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 47,480.93 244,676.97 39.048 381,924.03 135-55070-020-000 Independent Labor 20,550.00 20,550.00 1,069.50 5.204 19,480.50 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 154.34 19,177.69 22.274 66,922.31 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 274.53 3,406.41 42.580 4,593.59 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 289.69 57.938 210.31 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 4,173.87 35,703.37 59.506 24,296.63 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,934.00 16,462.82 54.876 13,537.18 Subtotal: 219,150.00 219,150.00 6,536.74 76,138.26 34.743 143,011.74 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 490.34 2,102.05 44.724 2,597.95 135-60020-020-000 Electricity 266,709.00 266,709.00 13,404.70 73,158.80 27.430 193,550.20 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 5,677.00 135-60090-020-000 Safety Program 550.00 550.00 8.37 1.522 541.63 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 73.06 4.469 1,561.94 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 .01 .002 449.99 135-60280-020-000 Property Maintenance 4,000.00 4,000.00 4,000.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,770.00 15.259 9,830.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 55,474.05 45.455 66,568.95 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 272,153.60 45.455 326,584.40 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 51,390.00 41.667 71,946.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 200,000.00 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 4,000.00 Subtotal: 1,438,938.00 1,438,938.00 89,698.58 486,402.46 33.803 952,535.54 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 743.43 3,731.07 29.849 8,768.93 135-65010-020-000 Uniforms 4,459.00 4,459.00 159.96 1,774.59 39.798 2,684.41 135-65030-020-000 Chemicals 27,500.00 27,500.00 3,892.03 14.153 23,607.97 135-65035-020-000 Small Tools 1,000.00 1,000.00 34.99 1,118.21 111.821 118.21- 135-65040-020-000 Safety Equipment 750.00 750.00 260.00 260.00 34.667 490.00 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 953.09 5,671.38 40.510 8,328.62 Subtotal: 60,209.00 60,209.00 2,151.47 16,447.28 27.317 43,761.72 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 1,657.50 15,054.43 2.751 532,272.57 135-69008-020-000 Short Term Debt-Principal 51,342.00 51,342.00 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 7,573.00 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 636,242.00 636,242.00 1,657.50 45,054.43 7.081 591,187.57 Program number: 2,981,140.00 2,981,140.00 147,525.22 868,719.40 29.141 2,112,420.60 Department number: Wastewater 2,981,140.00 2,981,140.00 147,525.22 868,719.40 29.141 2,112,420.60 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 12.10 40.333 17.90 Subtotal: 30.00 30.00 2.42 12.10 40.333 17.90 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 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,135.00 28.375 2,865.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 670.02 960.00 19.200 4,040.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,021.73 51.087 978.27 Subtotal: 12,950.00 12,950.00 670.02 3,766.73 29.087 9,183.27 Program number: 12,980.00 12,980.00 672.44 3,778.83 29.113 9,201.17 Department number: Board of Directors 12,980.00 12,980.00 672.44 3,778.83 29.113 9,201.17 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 25,071.76 155,434.79 35.909 277,428.21 135-50010-030-000 Overtime 2,000.00 2,000.00 19.18 410.65 20.533 1,589.35 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,320.91 17,050.78 42.046 23,502.22 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 19,047.97 30.004 44,437.03 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 251.50 1,493.40 27.143 4,008.60 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 298.90 25.482 874.10 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 282.27 1,703.90 33.681 3,355.10 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,477.33 9,501.76 34.957 17,679.24 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 345.49 2,222.16 34.956 4,134.84 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 17.72 54.70 4.341 1,205.30 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 617.50 40.386 911.50 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 124.95 24.990 375.05 135-50070-030-000 Employee Relations 4,960.00 4,960.00 49.61- 2,320.79 46.790 2,639.21 Subtotal: 595,970.00 595,970.00 34,047.80 213,829.75 35.879 382,140.25 135-55030-030-000 Software & Support 78,391.00 78,391.00 3,249.19 43,128.59 55.017 35,262.41 135-55070-030-000 Independent Labor 154,000.00 154,000.00 13,028.85 63,070.84 40.955 90,929.16 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 985.00 2,281.50 16.296 11,718.50 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 1,065.38 3,093.33 30.933 6,906.67 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 56,475.00 89.183 6,850.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 581.61 2,974.25 33.047 6,025.75 Subtotal: 338,916.00 338,916.00 18,910.03 171,023.51 50.462 167,892.49 135-60005-030-000 Telephone 27,300.00 27,300.00 1,654.42 7,388.97 27.066 19,911.03 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.44 1,324.62 33.116 2,675.38 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 1,697.60 10.440 14,563.40 135-60025-030-000 Water 2,500.00 2,500.00 58.10 285.76 11.430 2,214.24 135-60030-030-000 Rent And/Or Usage 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 1,627.44 9,651.64 32.172 20,348.36 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,264.65 25,547.54 45.982 30,012.46 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 9,325.36 33,726.80 60.226 22,273.20 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 107.17 3,808.42 63.474 2,191.58 135-60075-030-000 Meetings 400.00 400.00 48.62 12.155 351.38 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 7,600.00 7,600.00 85.00 2,693.00 35.434 4,907.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 112.33 582.17 11.918 4,302.83 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 145.00 3.222 4,355.00 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 2,700.00 2,700.00 24.00 48.00 1.778 2,652.00 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 124.50 124.50 24.900 375.50 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 8.480 2,288.01 Subtotal: 249,506.00 249,506.00 17,620.41 87,901.03 35.230 161,604.97 135-65010-030-000 Uniforms 700.00 700.00 700.00 135-65055-030-000 Hardware 7,420.00 7,420.00 597.95 8.059 6,822.05 135-65085-030-000 Office Supplies 7,000.00 7,000.00 137.14 2,612.69 37.324 4,387.31 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 1,903.05 95.153 96.95 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 332.37 2,061.86 51.547 1,938.14 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 469.51 7,319.55 29.138 17,800.45 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 7,841.00 60.315 5,159.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 257.79 1,229.02 26.718 3,370.98 Subtotal: 17,600.00 17,600.00 257.79 9,070.02 51.534 8,529.98 Program number: 1,227,112.00 1,227,112.00 71,305.54 489,143.86 39.861 737,968.14 Department number: Administration 1,227,112.00 1,227,112.00 71,305.54 489,143.86 39.861 737,968.14 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/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 29,343.55 21.419 107,656.45 135-55055-039-000 Auditing 24,500.00 24,500.00 25,508.70 104.117 1,008.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 4,660.18 40.714 6,785.82 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 62,480.83 35.351 114,265.17 Program number: 176,746.00 176,746.00 62,480.83 35.351 114,265.17 Department number: Non Departmental 176,746.00 176,746.00 62,480.83 35.351 114,265.17 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 505,940.38 2,906,601.88 28.906 7,148,809.12 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 78,755.33- 401,170.45- 206.132 206,552.45 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 22:56 03/15/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 2/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 5 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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 939 02/01/2018 Property Taxes (111,042.78) (1,055.21) (112,097.99) GL 940 02/02/2018 Property Taxes (2,948.69) (115,046.68) GL 941 02/05/2018 Property Taxes (843.95) (115,890.63) GL 942 02/06/2018 Property Taxes (481.84) (116,372.47) GL 943 02/07/2018 Property Taxes (1,325.89) (117,698.36) GL 944 02/09/2018 Property Taxes (47.71) (117,746.07) GL 945 02/13/2018 Property Taxes (23.22) (117,769.29) GL 946 02/14/2018 Property Taxes (46.89) (117,816.18) GL 947 02/16/2018 Property Taxes (52.41) (117,868.59) GL 948 02/20/2018 Property Taxes (128.28) (117,996.87) GL 949 02/21/2018 Property Taxes (2.41) (117,999.28) GL 950 02/22/2018 Property Taxes (2.76) (118,002.04) GL 951 02/23/2018 Property Taxes (1.16) (118,003.20) GL 952 02/26/2018 Property Taxes (175.91) (118,179.11) GL 953 02/27/2018 Property Taxes (56.99) (118,236.10) GL 954 02/28/2018 Property Taxes (106.90) (118,343.00) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (7,300.22) (118,343.00) ** (120,950.00) Budgeted (2,607.00) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 939 02/01/2018 Property Taxes (185.30) (1.36) (186.66) GL 940 02/02/2018 Property Taxes (.01) (186.67) GL 945 02/13/2018 Property Taxes (1.71) (188.38) GL 946 02/14/2018 Property Taxes (.55) (188.93) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (3.63) (188.93) ** (200.00) Budgeted (11.07) Remaining 94 % Used Account: 135-40015-000-000 Property Taxes/P & I 939 02/01/2018 Property Taxes (192.65) (2.57) (195.22) GL 940 02/02/2018 Property Taxes (.32) (195.54) GL 942 02/06/2018 Property Taxes (5.88) (201.42) GL 943 02/07/2018 Property Taxes (4.35) (205.77) GL 944 02/09/2018 Property Taxes (2.49) (208.26) GL 945 02/13/2018 Property Taxes (2.05) (210.31) GL 946 02/14/2018 Property Taxes (3.39) (213.70) GL 947 02/16/2018 Property Taxes (4.74) (218.44) GL 948 02/20/2018 Property Taxes (8.98) (227.42) GL 949 02/21/2018 Property Taxes (.17) (227.59) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 951 02/23/2018 Property Taxes (192.65) (.13) (227.72) GL 952 02/26/2018 Property Taxes (12.31) (240.03) GL 953 02/27/2018 Property Taxes (3.99) (244.02) GL 954 02/28/2018 Property Taxes (10.45) (254.47) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (61.82) (254.47) ** (200.00) Budgeted 54.47 Remaining 127 % 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 2507 02/07/2018 Adj-2224 TC drive UB20180207-20180207 User: (1,575,323.01) 25.84 (1,575,297.17) UB 890 02/28/2018 UB 02/28/2018 Billing UB20180228-20180228 User: (318,738.42) (1,894,035.59) UB _______________ Account: 135-47000-000-000 Water Totals: (318,712.58) (1,894,035.59) ** (6,464,019.00) Budgeted (4,569,983.41) Remaining 29 % Used Account: 135-47005-000-000 Sewer 2507 02/07/2018 Adj-2224 TC drive UB20180207-20180207 User: (943,447.18) 95.43 (943,351.75) UB 890 02/28/2018 UB 02/28/2018 Billing UB20180228-20180228 User: (241,858.11) (1,185,209.86) UB _______________ Account: 135-47005-000-000 Sewer Totals: (241,762.68) (1,185,209.86) ** (2,978,067.00) Budgeted (1,792,857.14) Remaining 40 % Used Account: 135-47025-000-000 Penalties 820 02/14/2018 UB 02/14/2018 Penalties UB20180214-20180214 User: (44,011.03) 14.69 (43,996.34) UB 834 02/19/2018 UB 02/19/2018 Penalties UB20180219-20180219 User: 155.17 (43,841.17) UB 853 02/21/2018 UB February Assess Penalties UB20180221-20180221 User: (7,824.93) (51,666.10) UB 871 02/26/2018 UB 02/26/2018 Penalties UB20180226-20180226 User: 99.70 (51,566.40) UB 876 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 37.01 (51,529.39) UB 877 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 42.29 (51,487.10) UB 878 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 50.03 (51,437.07) UB 879 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 160.53 (51,276.54) UB 880 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 18.72 (51,257.82) UB . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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-47025-000-000 Penalties Totals: (7,246.79) (51,257.82) ** (106,279.00) Budgeted (55,021.18) Remaining 48 % Used Account: 135-47030-000-000 Service Charges 748 02/07/2018 UB 02/07/2018 Disconnect Fees UB20180207-20180207 User: (4,875.00) (1,100.00) (5,975.00) UB 749 02/07/2018 UB 02/07/2018 Disconnect Fees UB20180207-20180207 User: (1,100.00) (7,075.00) UB 894 02/07/2018 Disconnect fee reversals UB20180207-20180207 User: 1,100.00 (5,975.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,100.00) (5,975.00) ** (21,350.00) Budgeted (15,375.00) Remaining 28 % Used Account: 135-47035-000-000 Plumbing Inspections 883 02/19/2018 permits-521 Asheville & 28 Kat 521 Asheville Lane (1,150.00) (50.00) (1,200.00) Ashton Wood Homes CR 883 02/19/2018 permits-521 Asheville & 28 Kat 28 Katie Lane (50.00) (1,250.00) Drees Custom homes CR 900 02/27/2018 Permits & customer deposits 24 Sadie Court (50.00) (1,300.00) Drees CR 900 02/27/2018 Permits & customer deposits 509 Fisher Drive (50.00) (1,350.00) Ashton Woods CR 901 02/28/2018 Permits-8 Saide Court 8 Sadie Court (50.00) (1,400.00) Drees CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (1,400.00) ** (1,500.00) Budgeted (100.00) Remaining 93 % Used Account: 135-47045-000-000 Sewer Inspections 883 02/19/2018 permits-521 Asheville & 28 Kat 521 Asheville Lane (2,650.00) (150.00) (2,800.00) Ashton Wood Homes CR 883 02/19/2018 permits-521 Asheville & 28 Kat 28 Katie Lane (150.00) (2,950.00) Drees Custom homes CR 900 02/27/2018 Permits & customer deposits 24 Sadie Court (150.00) (3,100.00) Drees CR 900 02/27/2018 Permits & customer deposits 509 Fisher Drive (150.00) (3,250.00) Ashton Woods CR 901 02/28/2018 Permits-8 Saide Court 8 Sadie Court (150.00) (3,400.00) Drees CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (750.00) (3,400.00) ** (4,500.00) Budgeted (1,100.00) Remaining 76 % Used Account: 135-47070-000-000 TCCC Effluent Charges 890 02/28/2018 UB 02/28/2018 Billing UB20180228-20180228 User: (9,118.40) (357.60) (9,476.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (357.60) (9,476.00) ** (60,000.00) Budgeted (50,524.00) Remaining 16 % Used Account: 135-49010-000-000 Interest Income . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 978 02/28/2018 Bank Interest- February (12,251.66) (137.03) (12,388.69) GL 978 02/28/2018 Bank Interest- February (468.88) (12,857.57) GL 978 02/28/2018 Bank Interest- February (3,029.46) (15,887.03) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (3,635.37) (15,887.03) ** (12,000.00) Budgeted 3,887.03 Remaining 132 % Used Account: 135-49016-000-000 Cell Tower Revenue 964 02/16/2018 Cell Tower Rev AT&T Feb (3,846.96) (978.81) (4,825.77) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (4,825.77) ** (10,926.00) Budgeted (6,100.23) Remaining 44 % Used Account: 135-49018-000-000 Building Rent Income 991 02/28/2018 Town Billed Invoices 1624-1627 AR 20180228-20180228 User: (2,333.32) (583.33) (2,916.65) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,916.65) ** (7,000.00) Budgeted (4,083.35) Remaining 42 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 883 02/19/2018 permits-521 Asheville & 28 Kat 521 Asheville Lane (7,033.76) (343.00) (7,376.76) Ashton Wood Homes CR 883 02/19/2018 permits-521 Asheville & 28 Kat 28 Katie Lane (343.00) (7,719.76) Drees Custom homes CR 900 02/27/2018 Permits & customer deposits 24 Sadie Court (343.00) (8,062.76) Drees CR 900 02/27/2018 Permits & customer deposits 509 Fisher Drive (343.00) (8,405.76) Ashton Woods CR 901 02/28/2018 Permits-8 Saide Court 8 Sadie Court (343.00) (8,748.76) Drees CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,715.00) (8,748.76) ** (18,179.00) Budgeted (9,430.24) Remaining 48 % Used Account: 135-49900-000-000 Miscellaneous Income 895 02/07/2018 Credit adj UB20180207-20180207 User: (5,615.57) (.73) (5,616.30) UB 890 02/28/2018 UB 02/28/2018 Billing UB20180228-20180228 User: (237.15) (5,853.45) UB . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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-49900-000-000 Miscellaneous Income Totals: (237.88) (5,853.45) ** (5,000.00) Budgeted 853.45 Remaining 117 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (20.00) Budgeted (20.00) Remaining 0 % Used Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (3,307,772.33) ** (584,695.71) Monthly Total (10,250,029.00) Budgeted (6,942,256.67) Remaining 32 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 742 02/09/2018 MUD PR 02.09.18 Salaries & Wages 64,187.45 8,919.27 73,106.72 PR 843 02/23/2018 MUD PR 02.23.18 Salaries & Wages 8,883.92 81,990.64 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 17,803.19 81,990.64 ** 274,279.00 Budgeted 192,288.36 Remaining 30 % Used Account: 135-50010-010-000 Overtime 742 02/09/2018 MUD PR 02.09.18 Overtime 2,741.08 22.86 2,763.94 PR 843 02/23/2018 MUD PR 02.23.18 Overtime 454.22 3,218.16 PR _______________ Account: 135-50010-010-000 Overtime Totals: 477.08 3,218.16 ** 20,000.00 Budgeted 16,781.84 Remaining 16 % 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 843 02/23/2018 MUD PR 02.23.18 Certification 725.00 175.00 900.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 900.00 ** 3,300.00 Budgeted 2,400.00 Remaining 27 % Used Account: 135-50020-010-000 Retirement 742 02/09/2018 MUD PR 02.09.18 Retirement 7,974.09 827.14 8,801.23 PR 843 02/23/2018 MUD PR 02.23.18 Retirement 879.96 9,681.19 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,707.10 9,681.19 ** 27,843.00 Budgeted 18,161.81 Remaining 35 % Used Account: 135-50026-010-000 Medical Insurance 742 02/09/2018 MUD PR 02.09.18 Medical Insurance 9,209.43 1,474.40 10,683.83 PR 843 02/23/2018 MUD PR 02.23.18 Medical Insurance 1,474.40 12,158.23 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 12,158.23 ** 52,196.00 Budgeted 40,037.77 Remaining 23 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 742 02/09/2018 MUD PR 02.09.18 Dental Insurance 886.58 103.58 990.16 PR 843 02/23/2018 MUD PR 02.23.18 Dental Insurance 103.58 1,093.74 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 207.16 1,093.74 ** 5,182.00 Budgeted 4,088.26 Remaining 21 % Used Account: 135-50028-010-000 Vision Insurance 742 02/09/2018 MUD PR 02.09.18 Vision Insurance 172.47 17.98 190.45 PR 843 02/23/2018 MUD PR 02.23.18 Vision Insurance 17.94 208.39 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 208.39 ** 994.00 Budgeted 785.61 Remaining 21 % Used Account: 135-50029-010-000 Life Insurance & Other 682 02/01/2018 February A/P February STD & LTD benefits 844.85 73.43 918.28 METLIFE GROUP BENEFITS 3881 AP 682 02/01/2018 February A/P Life Dental and vision for Feb 90.72 1,009.00 Humana Inc 3880 AP 887 02/28/2018 February AP Flex admin fee 17.00 1,026.00 BenefitMall 3952 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 181.15 1,026.00 ** 2,982.00 Budgeted 1,956.00 Remaining 34 % Used Account: 135-50030-010-000 Social Security Taxes 742 02/09/2018 MUD PR 02.09.18 Social Security Taxes 4,381.13 546.76 4,927.89 PR 843 02/23/2018 MUD PR 02.23.18 Social Security Taxes 579.88 5,507.77 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,126.64 5,507.77 ** 18,662.00 Budgeted 13,154.23 Remaining 30 % Used Account: 135-50035-010-000 Medicare Taxes 742 02/09/2018 MUD PR 02.09.18 Medicare Taxes 1,024.61 127.88 1,152.49 PR 843 02/23/2018 MUD PR 02.23.18 Medicare Taxes 135.60 1,288.09 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 263.48 1,288.09 ** 4,365.00 Budgeted 3,076.91 Remaining 30 % Used Account: 135-50040-010-000 Unemployment Taxes 742 02/09/2018 MUD PR 02.09.18 Unemployment Taxes 26.04 8.84 34.88 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 843 02/23/2018 MUD PR 02.23.18 Unemployment Taxes 26.04 6.20 41.08 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 15.04 41.08 ** 1,080.00 Budgeted 1,038.92 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 236 02/01/2018 Insurance/Wrk Comp Exp Feb 3,599.68 899.92 4,499.60 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 4,499.60 ** 11,854.00 Budgeted 7,354.40 Remaining 38 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 226.05 .00 226.05 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 226.05 ** 200.00 Budgeted (26.05) Remaining 113 % Used Account: 135-50070-010-000 Employee Relations 18.99 .00 18.99 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 18.99 ** 300.00 Budgeted 281.01 Remaining 6 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 275,000.00 Budgeted 275,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 31,203.31 78.25 31,281.56 THE HOME DEPOT #6581 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 47.12 31,328.68 THE HOME DEPOT #6581 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 52.30 31,380.98 THE HOME DEPOT #6581 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 1.94 31,382.92 THE HOME DEPOT #6581 PC 917 02/28/2018 February A/P Bottle lease 42.00 31,424.92 ALLIED WELDING SUPPLY, INC 3974 AP 887 02/28/2018 February AP Fire hydrant parts 1,454.56 32,879.48 ATLAS UTILITY SUPPLY CO. 3951 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,676.17 32,879.48 ** 100,000.00 Budgeted 67,120.52 Remaining 33 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-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 926 02/26/2018 Pcard 01/27/18 - 02/26/18 GIERISCH CARE 0050292 2,577.66 67.23 2,644.89 GIERISCH CARE 0050292 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 DISCOUNT TIRE TXD 75 172.50 2,817.39 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 239.73 2,817.39 ** 4,000.00 Budgeted 1,182.61 Remaining 70 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 2,093.44 .00 2,093.44 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 2,093.44 ** 5,500.00 Budgeted 3,406.56 Remaining 38 % Used Account: 135-60010-010-000 Communications/Mobiles 809 02/13/2018 February A/P Mobile phones 1,010.98 370.64 1,381.62 VERIZON WIRELESS 3946 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 370.64 1,381.62 ** 4,700.00 Budgeted 3,318.38 Remaining 29 % Used Account: 135-60020-010-000 Electricity 809 02/13/2018 February A/P Electricity 1/9-2/7 48,098.00 50.98 48,148.98 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 1/10-2/8 76.28 48,225.26 HUDSON ENERGY SERVICES, LLC 3935 AP 864 02/23/2018 February A/P Electricity 1/10-2/8 8,054.88 56,280.14 HUDSON ENERGY SERVICES, LLC 3961 AP _______________ Account: 135-60020-010-000 Electricity Totals: 8,182.14 56,280.14 ** 175,356.00 Budgeted 119,075.86 Remaining 32 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 926 02/26/2018 Pcard 01/27/18 - 02/26/18 PAYPAL *TEXASWATERW 235.00 325.00 560.00 PAYPAL *TEXASWATERW PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TCEQ IND RENEWAL L 111.00 671.00 TCEQ IND RENEWAL L PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TCEQ EPAYMENT 111.00 782.00 TCEQ EPAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 360 WATER INC 60.00 842.00 360 WATER INC PC 922 02/28/2018 February A/P Schools/training food/miles 132.78 974.78 Frank Isola 3982 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 739.78 974.78 ** 2,785.00 Budgeted 1,810.22 Remaining 35 % Used Account: 135-60090-010-000 Safety Program 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem 87.48 .00 87.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-60135-010-000 TCEQ Fees & Permits 809 02/13/2018 February A/P Groundwater charge 7,685.65 5,122.40 12,808.05 North Texas Groundwater 3940 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 5,122.40 12,808.05 ** 55,176.00 Budgeted 42,367.95 Remaining 23 % Used Account: 135-60150-010-000 Wholesale Water 887 02/28/2018 February AP Wholesale water 505,492.71 107,996.70 613,489.41 CITY OF FORT WORTH 3953 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 107,996.70 613,489.41 ** 2,823,170.00 Budgeted 2,209,680.59 Remaining 22 % 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 322.70 .00 322.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 322.70 ** 3,000.00 Budgeted 2,677.30 Remaining 11 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2,250.00 .00 2,250.00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 2,250.00 ** 14,750.00 Budgeted 12,500.00 Remaining 15 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 962 02/28/2018 Texpool Transfers Feb 101,121.24 25,280.31 126,401.55 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 126,401.55 ** 278,084.00 Budgeted 151,682.45 Remaining 45 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 962 02/28/2018 Texpool Transfers Feb 16,332.00 4,083.00 20,415.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 20,415.00 ** 48,996.00 Budgeted 28,581.00 Remaining 42 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 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 922 02/28/2018 February A/P Fuel 2,983.58 949.94 3,933.52 US Bank Voyager Fleet Systems 4000 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 949.94 3,933.52 ** 15,000.00 Budgeted 11,066.48 Remaining 26 % Used Account: 135-65010-010-000 Uniforms 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON.COM 829.64 160.93 990.57 AMAZON.COM PC _______________ Account: 135-65010-010-000 Uniforms Totals: 160.93 990.57 ** 4,488.00 Budgeted 3,497.43 Remaining 22 % Used Account: 135-65030-010-000 Chemicals 864 02/23/2018 February A/P Buffer solution 4,398.38 72.54 4,470.92 HACH COMPANY 3959 AP 887 02/28/2018 February AP Testing supplies 216.00 4,686.92 HACH COMPANY 3959 AP 887 02/28/2018 February AP Testing supplies 303.00 4,989.92 HACH COMPANY 3959 AP 887 02/28/2018 February AP LAS 434.64 5,424.56 Valley Solvent Company, INC 3973 AP 887 02/28/2018 February AP Chlorine 1,216.83 6,641.39 DPC INDUSTRIES, INC 3956 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 2,243.01 6,641.39 ** 20,000.00 Budgeted 13,358.61 Remaining 33 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 12,400.00 .00 12,400.00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 12,400.00 ** 50,000.00 Budgeted 37,600.00 Remaining 25 % Used Account: 135-65053-010-000 Meter Change Out Program 48,900.00 .00 48,900.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 48,900.00 ** 84,000.00 Budgeted 35,100.00 Remaining 58 % Used Account: 135-69005-010-000 Capital Outlays 790 02/09/2018 Feb A/P Northside II project 120,056.27 2,693,208.68 2,813,264.95 Fort Worth Water Department AP 815 02/14/2018 February A/P 16" water line 17,048.70 2,830,313.65 Halff Associates, INC 3934 AP 838 02/19/2018 February A/P Portland water line 70,000.00 2,900,313.65 REY-MAR CONSTRUCTION 3971 AP 838 02/19/2018 February A/P New VFD Pump 2,542.00 2,902,855.65 CP&Y/WALLACE GROUP, INC. 3954 AP 838 02/19/2018 February A/P TCEQ Bond application 873.75 2,903,729.40 CP&Y/WALLACE GROUP, INC. 3954 AP 838 02/19/2018 February A/P 16" water line modeling 4,837.50 2,908,566.90 CP&Y/WALLACE GROUP, INC. 3954 AP 845 02/20/2018 Direct Pay from TWBD- VOID Northside II project (2,693,208.68) 215,358.22 Fort Worth Water Department AP 917 02/28/2018 February A/P Indian Creek/Phoenix 8,250.00 223,608.22 TEAGUE, NALL & PERKINS,INC 3996 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 103,551.95 223,608.22 ** 810,012.00 Budgeted 586,403.78 Remaining 28 % Used Account: 135-69008-010-000 Short Term Debt-Principal . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 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 19 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/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 743.89 .00 743.89 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 743.89 ** 2,000.00 Budgeted 1,256.11 Remaining 37 % Used Department 10 Totals: ----------------------------------- 1,482,478.96 ** 286,437.18 Monthly Total 5,657,433.00 Budgeted 4,174,954.04 Remaining 26 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 742 02/09/2018 MUD PR 02.09.18 Salaries & Wages 122,762.40 15,346.44 138,108.84 PR 843 02/23/2018 MUD PR 02.23.18 Salaries & Wages 15,303.74 153,412.58 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 30,650.18 153,412.58 ** 410,866.00 Budgeted 257,453.42 Remaining 37 % Used Account: 135-50010-020-000 Overtime 742 02/09/2018 MUD PR 02.09.18 Overtime 10,130.76 1,355.04 11,485.80 PR 843 02/23/2018 MUD PR 02.23.18 Overtime 901.28 12,387.08 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,256.32 12,387.08 ** 30,000.00 Budgeted 17,612.92 Remaining 41 % 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 843 02/23/2018 MUD PR 02.23.18 Certification 2,725.00 700.00 3,425.00 PR 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TCEQ IND RENEWAL L 111.00 3,536.00 TCEQ IND RENEWAL L PC _______________ Account: 135-50017-020-000 Certification Totals: 811.00 3,536.00 ** 8,400.00 Budgeted 4,864.00 Remaining 42 % Used Account: 135-50020-020-000 Retirement 742 02/09/2018 MUD PR 02.09.18 Retirement 14,695.03 1,544.89 16,239.92 PR 843 02/23/2018 MUD PR 02.23.18 Retirement 1,563.71 17,803.63 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,108.60 17,803.63 ** 42,243.00 Budgeted 24,439.37 Remaining 42 % Used Account: 135-50026-020-000 Medical Insurance 742 02/09/2018 MUD PR 02.09.18 Medical Insurance 20,239.05 3,054.24 23,293.29 PR 843 02/23/2018 MUD PR 02.23.18 Medical Insurance 3,054.21 26,347.50 PR . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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: 6,108.45 26,347.50 ** 62,175.00 Budgeted 35,827.50 Remaining 42 % Used Account: 135-50027-020-000 Dental Insurance 742 02/09/2018 MUD PR 02.09.18 Dental Insurance 1,573.06 187.57 1,760.63 PR 843 02/23/2018 MUD PR 02.23.18 Dental Insurance 187.53 1,948.16 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 375.10 1,948.16 ** 5,271.00 Budgeted 3,322.84 Remaining 37 % Used Account: 135-50028-020-000 Vision Insurance 742 02/09/2018 MUD PR 02.09.18 Vision Insurance 318.48 32.76 351.24 PR 843 02/23/2018 MUD PR 02.23.18 Vision Insurance 32.73 383.97 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 65.49 383.97 ** 1,114.00 Budgeted 730.03 Remaining 34 % Used Account: 135-50029-020-000 Life Insurance & Other 682 02/01/2018 February A/P February STD & LTD benefits 1,584.12 149.71 1,733.83 METLIFE GROUP BENEFITS 3881 AP 682 02/01/2018 February A/P Life Dental and vision for Feb 192.36 1,926.19 Humana Inc 3880 AP 887 02/28/2018 February AP Flex admin fee 34.00 1,960.19 BenefitMall 3952 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 376.07 1,960.19 ** 4,281.00 Budgeted 2,320.81 Remaining 46 % Used Account: 135-50030-020-000 Social Security Taxes 742 02/09/2018 MUD PR 02.09.18 Social Security Taxes 8,369.06 960.80 9,329.86 PR 843 02/23/2018 MUD PR 02.23.18 Social Security Taxes 948.35 10,278.21 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,909.15 10,278.21 ** 28,314.00 Budgeted 18,035.79 Remaining 36 % Used Account: 135-50035-020-000 Medicare Taxes 742 02/09/2018 MUD PR 02.09.18 Medicare Taxes 1,957.28 224.70 2,181.98 PR 843 02/23/2018 MUD PR 02.23.18 Medicare Taxes 221.79 2,403.77 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 446.49 2,403.77 ** 6,622.00 Budgeted 4,218.23 Remaining 36 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes 742 02/09/2018 MUD PR 02.09.18 Unemployment Taxes 34.80 16.70 51.50 PR 843 02/23/2018 MUD PR 02.23.18 Unemployment Taxes 9.38 60.88 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 26.08 60.88 ** 1,260.00 Budgeted 1,199.12 Remaining 5 % Used Account: 135-50045-020-000 Workman's Compensation 236 02/01/2018 Insurance/Wrk Comp Exp Feb 5,392.00 1,348.00 6,740.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 6,740.00 ** 17,990.00 Budgeted 11,250.00 Remaining 37 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 1,069.50 .00 1,069.50 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 1,069.50 ** 20,550.00 Budgeted 19,480.50 Remaining 5 % Used Account: 135-55080-020-000 Maintenance & Repairs 840 02/07/2018 Vendor information has changed Maintenance parts for belt pre 19,023.35 (4,302.07) 14,721.28 ALFA LAVAL ASHBROOK 3883 AP 840 02/07/2018 Vendor information has changed Black scraper for belt press (159.50) 14,561.78 ALFA LAVAL ASHBROOK 3883 AP 864 02/23/2018 February A/P Maintenance parts for belt pre 4,302.07 18,863.85 Alfa Laval, Inc 3950 AP 864 02/23/2018 February A/P Black scraper for belt press 159.50 19,023.35 Alfa Laval, Inc 3950 AP 926 02/26/2018 Pcard 01/27/18 - 02/26/18 FERGUSON ENT 1241 53.26 19,076.61 FERGUSON ENT 1241 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 FERGUSON ENT #788 65.50 19,142.11 FERGUSON ENT #788 PC . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 926 02/26/2018 Pcard 01/27/18 - 02/26/18 FERGUSON ENT 1241 19,023.35 20.60 19,162.71 FERGUSON ENT 1241 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ROANOKE AUTO SUPPLY LT 14.98 19,177.69 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 154.34 19,177.69 ** 86,100.00 Budgeted 66,922.31 Remaining 22 % 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 922 02/28/2018 February A/P Tires-trailer 3,131.88 274.53 3,406.41 Jeff Richey 3986 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 274.53 3,406.41 ** 8,000.00 Budgeted 4,593.59 Remaining 43 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 289.69 .00 289.69 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 289.69 ** 500.00 Budgeted 210.31 Remaining 58 % Used Account: 135-55125-020-000 Dumpster Services 838 02/19/2018 February A/P sludge haul off 31,529.50 882.60 32,412.10 L.H. CHANEY MATERIALS, INC. 3965 AP 838 02/19/2018 February A/P sludge haul off 740.64 33,152.74 L.H. CHANEY MATERIALS, INC. 3965 AP 917 02/28/2018 February A/P Sludge haul off 2,550.63 35,703.37 L.H. CHANEY MATERIALS, INC. 3988 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,173.87 35,703.37 ** 60,000.00 Budgeted 24,296.63 Remaining 60 % Used Account: 135-55135-020-000 Lab Analysis 838 02/19/2018 February A/P labs 14,528.82 246.00 14,774.82 OXIDOR LABORATORIES LLC 3970 AP 838 02/19/2018 February A/P labs 176.00 14,950.82 OXIDOR LABORATORIES LLC 3970 AP 838 02/19/2018 February A/P Labs 246.00 15,196.82 OXIDOR LABORATORIES LLC 3970 AP 838 02/19/2018 February A/P Labs 176.00 15,372.82 OXIDOR LABORATORIES LLC 3970 AP 917 02/28/2018 February A/P Lab supplies 176.00 15,548.82 OXIDOR LABORATORIES LLC 3993 AP . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 917 02/28/2018 February A/P Lab supplies 14,528.82 246.00 15,794.82 OXIDOR LABORATORIES LLC 3993 AP 917 02/28/2018 February A/P Lab supplies 246.00 16,040.82 OXIDOR LABORATORIES LLC 3993 AP 917 02/28/2018 February A/P Lab supplies 176.00 16,216.82 OXIDOR LABORATORIES LLC 3993 AP 917 02/28/2018 February A/P Lab supplies 246.00 16,462.82 OXIDOR LABORATORIES LLC 3993 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,934.00 16,462.82 ** 30,000.00 Budgeted 13,537.18 Remaining 55 % Used Account: 135-60010-020-000 Communications/Mobiles 809 02/13/2018 February A/P Mobile phones 1,611.71 490.34 2,102.05 VERIZON WIRELESS 3946 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 490.34 2,102.05 ** 4,700.00 Budgeted 2,597.95 Remaining 45 % Used Account: 135-60020-020-000 Electricity 809 02/13/2018 February A/P Electricity 1/9-2/7 59,754.10 27.83 59,781.93 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 1/9-2/7 56.06 59,837.99 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 1/10-2/8 33.71 59,871.70 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 1/10-2/8 358.16 60,229.86 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 2/5-2/8 981.80 61,211.66 HUDSON ENERGY SERVICES, LLC 3935 AP 838 02/19/2018 February A/P Electricity 1/10-2/4 8,511.29 69,722.95 ENGIE Resources LLC 3958 AP 838 02/19/2018 February A/P Electricity 1/10-2/5 3,416.05 73,139.00 HUDSON ENERGY SERVICES, LLC 3961 AP 864 02/23/2018 February A/P Electricity 1/10-2/8 425.44 73,564.44 HUDSON ENERGY SERVICES, LLC 3961 AP 991 02/28/2018 Town Billed Invoices 1624-1627 AR 20180228-20180228 User: (405.64) 73,158.80 AR _______________ Account: 135-60020-020-000 Electricity Totals: 13,404.70 73,158.80 ** 266,709.00 Budgeted 193,550.20 Remaining 27 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 5,677.00 Budgeted 5,677.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 8.37 .00 8.37 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 8.37 ** 550.00 Budgeted 541.63 Remaining 2 % Used Account: 135-60100-020-000 Travel & per diem 73.06 .00 73.06 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 73.06 ** 1,635.00 Budgeted 1,561.94 Remaining 4 % 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 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 966 02/28/2018 IRS Refund Overpayment Adj due to rounding .01 .01 GL _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .01 .01 ** 450.00 Budgeted 449.99 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1,770.00 .00 1,770.00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 1,770.00 ** 11,600.00 Budgeted 9,830.00 Remaining 15 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 962 02/28/2018 Texpool Transfers Feb 44,379.24 11,094.81 55,474.05 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 55,474.05 ** 122,043.00 Budgeted 66,568.95 Remaining 45 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 962 02/28/2018 Texpool Transfers Feb 217,722.88 54,430.72 272,153.60 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 272,153.60 ** 598,738.00 Budgeted 326,584.40 Remaining 45 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 962 02/28/2018 Texpool Transfers Feb 41,112.00 10,278.00 51,390.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 51,390.00 ** 123,336.00 Budgeted 71,946.00 Remaining 42 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 922 02/28/2018 February A/P Fuel 2,987.64 743.43 3,731.07 US Bank Voyager Fleet Systems 4000 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 743.43 3,731.07 ** 12,500.00 Budgeted 8,768.93 Remaining 30 % Used Account: 135-65010-020-000 Uniforms 926 02/26/2018 Pcard 01/27/18 - 02/26/18 LEVIS OUTLET 322 1,614.63 173.16 1,787.79 LEVIS OUTLET 322 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 LEVIS OUTLET 322 (173.16) 1,614.63 LEVIS OUTLET 322 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 LEVIS OUTLET 322 159.96 1,774.59 LEVIS OUTLET 322 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 159.96 1,774.59 ** 4,459.00 Budgeted 2,684.41 Remaining 40 % Used Account: 135-65030-020-000 Chemicals 3,892.03 .00 3,892.03 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 3,892.03 ** 27,500.00 Budgeted 23,607.97 Remaining 14 % Used Account: 135-65035-020-000 Small Tools 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 1,083.22 34.99 1,118.21 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 34.99 1,118.21 ** 1,000.00 Budgeted (118.21) Remaining 112 % Used Account: 135-65040-020-000 Safety Equipment . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 926 02/26/2018 Pcard 01/27/18 - 02/26/18 RITZ SAFETY DALLAS 260.00 260.00 RITZ SAFETY DALLAS PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 260.00 260.00 ** 750.00 Budgeted 490.00 Remaining 35 % Used Account: 135-65045-020-000 Lab Supplies 926 02/26/2018 Pcard 01/27/18 - 02/26/18 USA BLUE BOOK 4,718.29 (241.50) 4,476.79 USA BLUE BOOK PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 HACH COMPANY 457.25 4,934.04 HACH COMPANY PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 5.67 4,939.71 THE HOME DEPOT #6581 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 USA BLUE BOOK 241.50 5,181.21 USA BLUE BOOK PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 USA BLUE BOOK 241.50 5,422.71 USA BLUE BOOK PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 HACH COMPANY 54.89 5,477.60 HACH COMPANY PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 HACH COMPANY 31.78 5,509.38 HACH COMPANY PC 917 02/28/2018 February A/P Gloves 162.00 5,671.38 LOU'S GLOVES INCORPORATED 3991 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 953.09 5,671.38 ** 14,000.00 Budgeted 8,328.62 Remaining 41 % Used Account: 135-69005-020-000 Capital Outlays 838 02/19/2018 February A/P Legal WWTP 13,396.93 1,657.50 15,054.43 Dubois Bryant Campbell LLP 3957 AP 838 02/19/2018 February A/P WWTP Upgrades 34,557.86 49,612.29 CP&Y/WALLACE GROUP, INC. 3954 AP 884 02/28/2018 Correct Fund Cap Out- 135-517 (34,557.86) 15,054.43 GL _______________ Account: 135-69005-020-000 Capital Outlays Totals: 1,657.50 15,054.43 ** 547,327.00 Budgeted 532,272.57 Remaining 3 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 51,342.00 Budgeted 51,342.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 7,573.00 Budgeted 7,573.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 30,000.00 .00 30,000.00 _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ----------------------------------- 868,719.40 ** 147,525.22 Monthly Total 2,981,140.00 Budgeted 2,112,420.60 Remaining 29 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 236 02/01/2018 Insurance/Wrk Comp Exp Feb 9.68 2.42 12.10 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 12.10 ** 30.00 Budgeted 17.90 Remaining 40 % 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 .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 1,135.00 .00 1,135.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,135.00 ** 4,000.00 Budgeted 2,865.00 Remaining 28 % Used Account: 135-60100-026-000 Travel & per diem 809 02/13/2018 February A/P AWBD mileage, hotel, food 289.98 560.96 850.94 JAMES C. THOMAS 3937 AP 864 02/23/2018 February A/P AWBD mileage & food/Tip & park 109.06 960.00 KEVIN R. CARR 3962 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 670.02 960.00 ** 5,000.00 Budgeted 4,040.00 Remaining 19 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,021.73 .00 1,021.73 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,021.73 ** 2,000.00 Budgeted 978.27 Remaining 51 % Used Department 26 Totals: ----------------------------------- 3,778.83 ** 672.44 Monthly Total 12,980.00 Budgeted 9,201.17 Remaining 29 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 742 02/09/2018 MUD PR 02.09.18 Salaries & Wages 130,363.03 12,588.76 142,951.79 PR 843 02/23/2018 MUD PR 02.23.18 Salaries & Wages 12,483.00 155,434.79 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 25,071.76 155,434.79 ** 432,863.00 Budgeted 277,428.21 Remaining 36 % Used Account: 135-50010-030-000 Overtime 742 02/09/2018 MUD PR 02.09.18 Overtime 391.47 19.18 410.65 PR _______________ Account: 135-50010-030-000 Overtime Totals: 19.18 410.65 ** 2,000.00 Budgeted 1,589.35 Remaining 21 % 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 742 02/09/2018 MUD PR 02.09.18 Retirement 14,729.87 1,166.24 15,896.11 PR 843 02/23/2018 MUD PR 02.23.18 Retirement 1,154.67 17,050.78 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,320.91 17,050.78 ** 40,553.00 Budgeted 23,502.22 Remaining 42 % Used Account: 135-50026-030-000 Medical Insurance 742 02/09/2018 MUD PR 02.09.18 Medical Insurance 14,902.73 2,072.63 16,975.36 PR 843 02/23/2018 MUD PR 02.23.18 Medical Insurance 2,072.61 19,047.97 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 19,047.97 ** 63,485.00 Budgeted 44,437.03 Remaining 30 % Used Account: 135-50027-030-000 Dental Insurance 742 02/09/2018 MUD PR 02.09.18 Dental Insurance 1,241.90 125.76 1,367.66 PR 843 02/23/2018 MUD PR 02.23.18 Dental Insurance 125.74 1,493.40 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 251.50 1,493.40 ** 5,502.00 Budgeted 4,008.60 Remaining 27 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-030-000 Vision Insurance 742 02/09/2018 MUD PR 02.09.18 Vision Insurance 256.39 21.28 277.67 PR 843 02/23/2018 MUD PR 02.23.18 Vision Insurance 21.23 298.90 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 298.90 ** 1,173.00 Budgeted 874.10 Remaining 25 % Used Account: 135-50029-030-000 Life Insurance & Other 682 02/01/2018 February A/P February STD & LTD benefits 1,421.63 120.23 1,541.86 METLIFE GROUP BENEFITS 3881 AP 682 02/01/2018 February A/P Life Dental and vision for Feb 145.04 1,686.90 Humana Inc 3880 AP 887 02/28/2018 February AP Flex admin fee 17.00 1,703.90 BenefitMall 3952 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 282.27 1,703.90 ** 5,059.00 Budgeted 3,355.10 Remaining 34 % Used Account: 135-50030-030-000 Social Security Taxes 742 02/09/2018 MUD PR 02.09.18 Social Security Taxes 8,024.43 743.97 8,768.40 PR 843 02/23/2018 MUD PR 02.23.18 Social Security Taxes 733.36 9,501.76 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,477.33 9,501.76 ** 27,181.00 Budgeted 17,679.24 Remaining 35 % Used Account: 135-50035-030-000 Medicare Taxes 742 02/09/2018 MUD PR 02.09.18 Medicare Taxes 1,876.67 173.99 2,050.66 PR 843 02/23/2018 MUD PR 02.23.18 Medicare Taxes 171.50 2,222.16 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 345.49 2,222.16 ** 6,357.00 Budgeted 4,134.84 Remaining 35 % Used Account: 135-50040-030-000 Unemployment Taxes 742 02/09/2018 MUD PR 02.09.18 Unemployment Taxes 36.98 11.57 48.55 PR 843 02/23/2018 MUD PR 02.23.18 Unemployment Taxes 6.15 54.70 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 17.72 54.70 ** 1,260.00 Budgeted 1,205.30 Remaining 4 % Used Account: 135-50045-030-000 Workman's Compensation 236 02/01/2018 Insurance/Wrk Comp Exp Feb 494.00 123.50 617.50 GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 617.50 ** 1,529.00 Budgeted 911.50 Remaining 40 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 124.95 .00 124.95 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 124.95 ** 500.00 Budgeted 375.05 Remaining 25 % Used Account: 135-50070-030-000 Employee Relations 926 02/26/2018 Pcard 01/27/18 - 02/26/18 HOBBY-LOBBY #256 2,370.40 (75.73) 2,294.67 HOBBY-LOBBY #256 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TOM THUMB #1789 26.12 2,320.79 TOM THUMB #1789 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: (49.61) 2,320.79 ** 4,960.00 Budgeted 2,639.21 Remaining 47 % Used Account: 135-55030-030-000 Software & Support 815 02/14/2018 February A/P Internet 39,879.40 1,051.94 40,931.34 WHOLESALE CARRIER SERVICES INC 3947 AP 838 02/19/2018 February A/P Software 365 outlook license 168.00 41,099.34 M3 Networks 3967 AP 864 02/23/2018 February A/P STW support & Vision License A 1,475.69 42,575.03 STW INC 3972 AP 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ADOBE SYSTEMS, INC. (106.38) 42,468.65 ADOBE SYSTEMS, INC. PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ADOBE SYSTEMS, INC. (19.99) 42,448.66 ADOBE SYSTEMS, INC. PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 CANVA FOR WORK MONTHLY 12.95 42,461.61 CANVA FOR WORK MONTHLY PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ADOBE SYSTEMS, INC. 389.57 42,851.18 ADOBE SYSTEMS, INC. PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 85.71 42,936.89 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 63.59 43,000.48 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 111.88 43,112.36 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ADOBE SYSTEMS INC 16.23 43,128.59 ADOBE SYSTEMS INC PC _______________ Account: 135-55030-030-000 Software & Support Totals: 3,249.19 43,128.59 ** 78,391.00 Budgeted 35,262.41 Remaining 55 % Used Account: 135-55070-030-000 Independent Labor 917 02/28/2018 February A/P GM-February 50,041.99 13,028.85 63,070.84 Carman Consulting LLC. 4003 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 13,028.85 63,070.84 ** 154,000.00 Budgeted 90,929.16 Remaining 41 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-55080-030-000 Maintenance & Repairs 790 02/09/2018 Feb A/P Office heater 1,296.50 825.00 2,121.50 BRANDON R REED 3930 AP 790 02/09/2018 Feb A/P Quarterly maintenance 160.00 2,281.50 BRANDON R REED 3930 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 985.00 2,281.50 ** 14,000.00 Budgeted 11,718.50 Remaining 16 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 838 02/19/2018 February A/P Janitorial services 2,027.95 869.06 2,897.01 MEMBER'S BUILDING MAINTENANCE 3968 AP 994 02/28/2018 Rev Inv 1615/Janitorial DEC AR 20180228-20180228 User: 196.32 3,093.33 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,065.38 3,093.33 ** 10,000.00 Budgeted 6,906.67 Remaining 31 % Used Account: 135-55160-030-000 Professional Outside Services 56,475.00 .00 56,475.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 56,475.00 ** 63,325.00 Budgeted 6,850.00 Remaining 89 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ 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 917 02/28/2018 February A/P February mailings 2,392.64 581.61 2,974.25 DATAPROSE LLC 3979 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 581.61 2,974.25 ** 9,000.00 Budgeted 6,025.75 Remaining 33 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-000 Telephone 864 02/23/2018 February A/P AMswering service 5,734.55 194.75 5,929.30 KEYSTONE PARK SECRETARIAL 3963 AP 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BUS PHONE PMT 453.37 6,382.67 ATT*BUS PHONE PMT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 191.10 6,573.77 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BUS PHONE PMT 852.62 7,426.39 ATT*BUS PHONE PMT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 128.62 7,555.01 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 RINGCENTRAL, INC 13.96 7,568.97 RINGCENTRAL, INC PC 991 02/28/2018 Town Billed Invoices 1624-1627 AR 20180228-20180228 User: (180.00) 7,388.97 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,654.42 7,388.97 ** 27,300.00 Budgeted 19,911.03 Remaining 27 % Used Account: 135-60010-030-000 Communications/Mobiles 809 02/13/2018 February A/P Mobile phones 1,087.18 87.44 1,174.62 VERIZON WIRELESS 3946 AP 843 02/23/2018 MUD PR 02.23.18 Communications/Mobiles 150.00 1,324.62 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.44 1,324.62 ** 4,000.00 Budgeted 2,675.38 Remaining 33 % Used Account: 135-60020-030-000 Electricity/Gas 1,697.60 .00 1,697.60 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 1,697.60 ** 16,261.00 Budgeted 14,563.40 Remaining 10 % Used Account: 135-60025-030-000 Water 917 02/28/2018 February A/P Water-February 227.66 116.19 343.85 TROPHY CLUB MUD (WATER BILLS) 3999 AP 991 02/28/2018 Town Billed Invoices 1624-1627 AR 20180228-20180228 User: (58.09) 285.76 AR _______________ Account: 135-60025-030-000 Water Totals: 58.10 285.76 ** 2,500.00 Budgeted 2,214.24 Remaining 11 % Used Account: 135-60030-030-000 Rent And/Or Usage 616.40 .00 616.40 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 809 02/13/2018 February A/P Overnight letter TCEQ 8,024.20 17.14 8,041.34 FEDERAL EXPRESS CORP 3933 AP 926 02/26/2018 Pcard 01/27/18 - 02/26/18 FEDEX 27259600 5.82 8,047.16 FEDEX 27259600 PC 917 02/28/2018 February A/P February mailings 1,604.48 9,651.64 DATAPROSE LLC 3979 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,627.44 9,651.64 ** 30,000.00 Budgeted 20,348.36 Remaining 32 % Used Account: 135-60040-030-000 Service Charges & Fees 747 02/09/2018 Child Support Fee 21,282.89 1.50 21,284.39 GL 844 02/23/2018 Child Support Fee 1.50 21,285.89 GL 917 02/28/2018 February A/P Direct send fees 50.00 21,335.89 Fiserv Solutions, LLC 3981 AP 961 02/28/2018 Pace Credit Card Fees 4,094.24 25,430.13 GL 961 02/28/2018 Pace Credit Card Fees 117.41 25,547.54 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,264.65 25,547.54 ** 55,560.00 Budgeted 30,012.46 Remaining 46 % 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 236 02/01/2018 Insurance/Wrk Comp Exp Feb 24,401.44 6,100.36 30,501.80 GL 809 02/13/2018 February A/P Bond notary renewal Nicole 201 21.00 30,522.80 OFC OF THE SECRETARY OF STATE 3941 AP 917 02/28/2018 February A/P WC FY 17 adjustment 3,204.00 33,726.80 TML INTERGOVERNMENTAL RISK 3997 AP _______________ Account: 135-60055-030-000 Insurance Totals: 9,325.36 33,726.80 ** 56,000.00 Budgeted 22,273.20 Remaining 60 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZONPRIME MEMBERSHIP 3,701.25 107.17 3,808.42 AMAZONPRIME MEMBERSHIP PC _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 107.17 3,808.42 ** 6,000.00 Budgeted 2,191.58 Remaining 63 % Used Account: 135-60075-030-000 Meetings 48.62 .00 48.62 _______________ Account: 135-60075-030-000 Meetings Totals: .00 48.62 ** 400.00 Budgeted 351.38 Remaining 12 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 926 02/26/2018 Pcard 01/27/18 - 02/26/18 GOVERNMENT FINANCE OFF 2,608.00 85.00 2,693.00 GOVERNMENT FINANCE OFF PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 85.00 2,693.00 ** 7,600.00 Budgeted 4,907.00 Remaining 35 % Used Account: 135-60100-030-000 Travel & per diem 742 02/09/2018 MUD PR 02.09.18 Travel & per diem 469.84 40.61 510.45 PR 843 02/23/2018 MUD PR 02.23.18 Travel & per diem 71.72 582.17 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 112.33 582.17 ** 4,885.00 Budgeted 4,302.83 Remaining 12 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 145.00 .00 145.00 _______________ Account: 135-60115-030-000 Elections Totals: .00 145.00 ** 4,500.00 Budgeted 4,355.00 Remaining 3 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security 838 02/19/2018 February A/P Monthly monitoring for panic b 24.00 24.00 48.00 Digital Air Control, Inc 3955 AP _______________ Account: 135-60235-030-000 Security Totals: 24.00 48.00 ** 2,700.00 Budgeted 2,652.00 Remaining 2 % Used Account: 135-60245-030-000 Miscellaneous Expenses 926 02/26/2018 Pcard 01/27/18 - 02/26/18 VCN*DENTONFLOWERMOUNDC 49.50 49.50 VCN*DENTONFLOWERMOUNDC PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TARRANT CO TX CLERK GR 28.00 77.50 TARRANT CO TX CLERK GR PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TARRANT CO TX CLERK GR 1.00 78.50 TARRANT CO TX CLERK GR PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 VCN*DENTONRECCTR 44.50 123.00 VCN*DENTONRECCTR PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 CFW PARKING METER 1.50 124.50 CFW PARKING METER PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 124.50 124.50 ** 500.00 Budgeted 375.50 Remaining 25 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 211.99 .00 211.99 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 211.99 ** 2,500.00 Budgeted 2,288.01 Remaining 8 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 700.00 Budgeted 700.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 597.95 .00 597.95 _______________ Account: 135-65055-030-000 Hardware Totals: .00 597.95 ** 7,420.00 Budgeted 6,822.05 Remaining 8 % Used Account: 135-65085-030-000 Office Supplies 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON MKTPLACE PMTS 2,475.55 64.44 2,539.99 AMAZON MKTPLACE PMTS PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON MKTPLACE PMTS 10.49 2,550.48 AMAZON MKTPLACE PMTS PC 917 02/28/2018 February A/P Office supplies/Paper 35.63 2,586.11 OFFICE DEPOT, INC 3992 AP 917 02/28/2018 February A/P Carmen office supplies 26.58 2,612.69 OFFICE DEPOT, INC 3992 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 137.14 2,612.69 ** 7,000.00 Budgeted 4,387.31 Remaining 37 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1,903.05 .00 1,903.05 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 1,903.05 ** 2,000.00 Budgeted 96.95 Remaining 95 % Used Account: 135-65095-030-000 Maintenance Supplies 926 02/26/2018 Pcard 01/27/18 - 02/26/18 STAPLES DIRECT 1,729.49 82.21 1,811.70 STAPLES DIRECT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON MKTPLACE PMTS 92.28 1,903.98 AMAZON MKTPLACE PMTS PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TOM THUMB #1789 7.47 1,911.45 TOM THUMB #1789 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 SAMSCLUB #4795 37.23 1,948.68 SAMSCLUB #4795 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 SAMS CLUB #4795 27.84 1,976.52 SAMS CLUB #4795 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON MKTPLACE PMTS 18.67 1,995.19 AMAZON MKTPLACE PMTS PC 917 02/28/2018 February A/P Kitchen supplies 41.68 2,036.87 OFFICE DEPOT, INC 3992 AP 917 02/28/2018 February A/P Office supplies 24.99 2,061.86 OFFICE DEPOT, INC 3992 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 332.37 2,061.86 ** 4,000.00 Budgeted 1,938.14 Remaining 52 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 7,841.00 .00 7,841.00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 7,841.00 ** 13,000.00 Budgeted 5,159.00 Remaining 60 % Used Account: 135-69170-030-000 Copier Lease Installments 809 02/13/2018 February A/P Copier lease payment 971.23 165.00 1,136.23 EVERBANK COMMERCIAL FINANCE 3932 AP 864 02/23/2018 February A/P Copies/Lease 92.79 1,229.02 KYOCERA DOCUMENT SOLUTIONS 3964 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 257.79 1,229.02 ** 4,600.00 Budgeted 3,370.98 Remaining 27 % Used Department 30 Totals: ----------------------------------- 489,143.86 ** 71,305.54 Monthly Total 1,227,112.00 Budgeted 737,968.14 Remaining 40 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/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 29,343.55 .00 29,343.55 _______________ Account: 135-55045-039-000 Legal Totals: .00 29,343.55 ** 137,000.00 Budgeted 107,656.45 Remaining 21 % Used Account: 135-55055-039-000 Auditing 25,508.70 .00 25,508.70 _______________ Account: 135-55055-039-000 Auditing Totals: .00 25,508.70 ** 24,500.00 Budgeted (1,008.70) Remaining 104 % Used Account: 135-55060-039-000 Appraisal 4,660.18 .00 4,660.18 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,660.18 ** 11,446.00 Budgeted 6,785.82 Remaining 41 % 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: ----------------------------------- 62,480.83 ** .00 Monthly Total 176,746.00 Budgeted 114,265.17 Remaining 35 % Used Fund 135 Totals: ----------------------------------- (401,170.45) (78,755.33) Monthly Total (194,618.00) Budgeted 206,552.45 Remaining 206 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 2/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 FEBRUARY 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 1,265,672 ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,265,672 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 915,238 TOTAL LIABILITIES 915,238 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (642,145) TOTAL FUND BALANCE 350,434 TOTAL LIABILITIES AND FUND BALANCE 1,265,672 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 22:56 03/15/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,337.62- 7,198.78- 7,198.78 Subtotal: 1,337.62- 7,198.78- 7,198.78 Program number: 1,337.62- 7,198.78- 7,198.78 Department number: Revenues 1,337.62- 7,198.78- 7,198.78 Revenues Subtotal ----------- 1,337.62- 7,198.78- 7,198.78 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 22:56 03/15/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 269,347.88 649,344.16 649,344.16- Subtotal: 269,347.88 649,344.16 649,344.16- Program number: 269,347.88 649,344.16 649,344.16- Department number: Wastewater 269,347.88 649,344.16 649,344.16- Expenditures Subtotal ----------- 269,347.88 649,344.16 649,344.16- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 268,010.26 642,145.38 642,145.38- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/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 978 02/28/2018 Bank Interest- February (5,861.16) (1,337.62) (7,198.78) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,337.62) (7,198.78) ** .00 Budgeted 7,198.78 Remaining 0 % Used Department Totals: ----------------------------------- (7,198.78) ** (1,337.62) Monthly Total .00 Budgeted 7,198.78 Remaining 0 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/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-69005-020-000 Capital Outlays 917 02/28/2018 February A/P Application 25-WWTP Improvemen 379,996.28 234,790.02 614,786.30 WEBBER-CADAGUA PARTNERS 4001 AP 884 02/28/2018 Correct Fund Cap Out- 135-517 34,557.86 649,344.16 GL _______________ Account: 517-69005-020-000 Capital Outlays Totals: 269,347.88 649,344.16 ** .00 Budgeted (649,344.16) Remaining 0 % Used Department 20 Totals: ----------------------------------- 649,344.16 ** 269,347.88 Monthly Total .00 Budgeted (649,344.16) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 642,145.38 268,010.26 Monthly Total .00 Budgeted (642,145.38) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET FEBRUARY 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 4,496,529 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,496,529 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 270,948 TOTAL LIABILITIES 270,948 FUND BALANCE ASSIGNED FUND BALANCE 4,225,581 NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE 4,225,581 TOTAL LIABILITIES AND FUND BALANCE 4,496,529 TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET FEBRUARY 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 39,899 TOTAL LIABILITIES 39,899 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE (39,899) TOTAL LIABILITIES AND FUND BALANCE 0 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET FEBRUARY 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 500,619 ACCOUNTS RECEIVABLE - TOTAL ASSETS 500,619 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,578 NET REVENUES / EXPENDITURES 74,041 TOTAL FUND BALANCE 500,619 TOTAL LIABILITIES AND FUND BALANCE 500,619 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 22:56 03/15/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/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- 501.27- 2,235.95- 223.595 1,235.95 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 20,415.00- 41.667 28,581.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 51,390.00- 41.667 71,946.00- Subtotal: 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- Program number: 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- Department number: 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- Revenues Subtotal ----------- 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/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 978 02/28/2018 Bank Interest- February (1,734.68) (501.27) (2,235.95) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (501.27) (2,235.95) ** (1,000.00) Budgeted 1,235.95 Remaining 224 % Used Account: 528-49142-000-000 Interfund transfer in-Water 962 02/28/2018 Texpool Transfers Feb (16,332.00) (4,083.00) (20,415.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (20,415.00) ** (48,996.00) Budgeted (28,581.00) Remaining 42 % Used Account: 528-49143-000-000 Interfund transfer in-WW 962 02/28/2018 Texpool Transfers Feb (41,112.00) (10,278.00) (51,390.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (51,390.00) ** (123,336.00) Budgeted (71,946.00) Remaining 42 % Used Department Totals: ----------------------------------- (74,040.95) ** (14,862.27) Monthly Total (173,332.00) Budgeted (99,291.05) Remaining 43 % Used Fund 528 Totals: ----------------------------------- (74,040.95) (14,862.27) Monthly Total (173,332.00) Budgeted (99,291.05) Remaining 43 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET FEBRUARY 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 819,493 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 34,688 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 858,754 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 34,688 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 34,688 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 791,725 TOTAL FUND BALANCE 824,066 TOTAL LIABILITIES AND FUND BALANCE 858,754 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 22:56 03/15/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/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- 40,419.77- 655,242.10- 97.847 14,417.90- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 28.93- 1,883.81- 104.656 83.81 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 313.15- 590.42- 29.521 1,409.58- Subtotal: 673,460.00- 673,460.00- 40,761.85- 657,716.33- 97.662 15,743.67- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 715.01- 1,534.06- 76.703 465.94- 533-49015-000-000 Lease/Rental Income 218,954.00- 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.81- 55,474.05- 45.455 66,568.95- Subtotal: 342,997.00- 342,997.00- 230,763.82- 275,962.11- 80.456 67,034.89- Program number: 1,016,457.00- 1,016,457.00- 271,525.67- 933,678.44- 91.856 82,778.56- Department number: Revenues 1,016,457.00- 1,016,457.00- 271,525.67- 933,678.44- 91.856 82,778.56- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 271,525.67- 933,678.44- 91.856 82,778.56- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 22:56 03/15/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/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 200.00 9.302 1,950.00 533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 141,753.75 141,753.75 50.000 141,754.25 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 Subtotal: 1,010,658.00 1,010,658.00 141,953.75 141,953.75 14.046 868,704.25 Program number: 1,010,658.00 1,010,658.00 141,953.75 141,953.75 14.046 868,704.25 Department number: Administration 1,010,658.00 1,010,658.00 141,953.75 141,953.75 14.046 868,704.25 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 141,953.75 141,953.75 14.046 868,704.25 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 129,571.92- 791,724.69- ############### 785,925.69 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/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 939 02/01/2018 Property Taxes (614,822.33) (5,842.56) (620,664.89) GL 940 02/02/2018 Property Taxes (16,326.31) (636,991.20) GL 941 02/05/2018 Property Taxes (4,672.78) (641,663.98) GL 942 02/06/2018 Property Taxes (2,667.84) (644,331.82) GL 943 02/07/2018 Property Taxes (7,341.19) (651,673.01) GL 944 02/09/2018 Property Taxes (264.14) (651,937.15) GL 945 02/13/2018 Property Taxes (128.55) (652,065.70) GL 946 02/14/2018 Property Taxes (259.60) (652,325.30) GL 947 02/16/2018 Property Taxes (290.18) (652,615.48) GL 948 02/20/2018 Property Taxes (710.22) (653,325.70) GL 949 02/21/2018 Property Taxes (13.34) (653,339.04) GL 950 02/22/2018 Property Taxes (15.26) (653,354.30) GL 951 02/23/2018 Property Taxes (6.41) (653,360.71) GL 952 02/26/2018 Property Taxes (973.97) (654,334.68) GL 953 02/27/2018 Property Taxes (315.56) (654,650.24) GL 954 02/28/2018 Property Taxes (591.86) (655,242.10) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (40,419.77) (655,242.10) ** (669,660.00) Budgeted (14,417.90) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 939 02/01/2018 Property Taxes (1,854.88) (3.80) (1,858.68) GL 940 02/02/2018 Property Taxes (.16) (1,858.84) GL 945 02/13/2018 Property Taxes (18.87) (1,877.71) GL 946 02/14/2018 Property Taxes (6.10) (1,883.81) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (28.93) (1,883.81) ** (1,800.00) Budgeted 83.81 Remaining 105 % Used Account: 533-40015-000-000 Property Taxes/P & I 939 02/01/2018 Property Taxes (277.27) (6.89) (284.16) GL 940 02/02/2018 Property Taxes (.02) (284.18) GL 942 02/06/2018 Property Taxes (32.56) (316.74) GL 943 02/07/2018 Property Taxes (17.46) (334.20) GL 944 02/09/2018 Property Taxes (13.79) (347.99) GL 945 02/13/2018 Property Taxes (13.71) (361.70) GL 946 02/14/2018 Property Taxes (19.40) (381.10) GL 947 02/16/2018 Property Taxes (26.26) (407.36) GL 948 02/20/2018 Property Taxes (49.70) (457.06) GL 949 02/21/2018 Property Taxes (.93) (457.99) GL . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 951 02/23/2018 Property Taxes (277.27) (.75) (458.74) GL 952 02/26/2018 Property Taxes (68.16) (526.90) GL 953 02/27/2018 Property Taxes (22.10) (549.00) GL 954 02/28/2018 Property Taxes (41.42) (590.42) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (313.15) (590.42) ** (2,000.00) Budgeted (1,409.58) Remaining 30 % Used Account: 533-49010-000-000 Interest Income 978 02/28/2018 Bank Interest- February (819.05) (715.01) (1,534.06) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (715.01) (1,534.06) ** (2,000.00) Budgeted (465.94) Remaining 77 % Used Account: 533-49015-000-000 Lease/Rental Income 962 02/28/2018 Texpool Transfers Feb (218,954.00) (218,954.00) GL _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: (218,954.00) (218,954.00) ** (218,954.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 962 02/28/2018 Texpool Transfers Feb (44,379.24) (11,094.81) (55,474.05) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (55,474.05) ** (122,043.00) Budgeted (66,568.95) Remaining 45 % Used Department Totals: ----------------------------------- (933,678.44) ** (271,525.67) Monthly Total (1,016,457.00) Budgeted (82,778.56) Remaining 92 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/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 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 200.00 200.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 200.00 200.00 ** 2,150.00 Budgeted 1,950.00 Remaining 9 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 70,600.00 70,600.00 GL 863 02/23/2018 3/1/18 Bond Payments INTEREST BNY MELLON Unl Tax Series 2010 32,928.75 103,528.75 GL 863 02/23/2018 3/1/18 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2012 19,612.50 123,141.25 GL 863 02/23/2018 3/1/18 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2013 18,612.50 141,753.75 GL _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: 141,753.75 141,753.75 ** 283,508.00 Budgeted 141,754.25 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 725,000.00 Budgeted 725,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 141,953.75 ** 141,953.75 Monthly Total 1,010,658.00 Budgeted 868,704.25 Remaining 14 % Used Fund 533 Totals: ----------------------------------- (791,724.69) (129,571.92) Monthly Total (5,799.00) Budgeted 785,925.69 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET FEBRUARY 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 177,130 ACCOUNTS RECEIVABLE - TOTAL ASSETS 177,130 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 160,920 TOTAL FUND BALANCE 177,130 TOTAL LIABILITIES AND FUND BALANCE 177,130 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 22:56 03/15/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 2/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- 218.38- 634.76- 63.476 365.24- 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 272,153.60- 45.455 326,584.40- Subtotal: 599,738.00- 599,738.00- 54,649.10- 272,788.36- 45.485 326,949.64- Program number: 599,738.00- 599,738.00- 54,649.10- 272,788.36- 45.485 326,949.64- Department number: Revenues 599,738.00- 599,738.00- 54,649.10- 272,788.36- 45.485 326,949.64- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,649.10- 272,788.36- 45.485 326,949.64- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 22:56 03/15/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/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 200.00 50.000 200.00 534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 111,668.75 111,668.75 50.000 111,669.25 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 Subtotal: 598,738.00 598,738.00 111,868.75 111,868.75 18.684 486,869.25 Program number: 598,738.00 598,738.00 111,868.75 111,868.75 18.684 486,869.25 Department number: Administration 598,738.00 598,738.00 111,868.75 111,868.75 18.684 486,869.25 Expenditures Subtotal ----------- 598,738.00 598,738.00 111,868.75 111,868.75 18.684 486,869.25 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 57,219.65 160,919.61- ############### 159,919.61 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 2/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 978 02/28/2018 Bank Interest- February (416.38) (218.38) (634.76) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (218.38) (634.76) ** (1,000.00) Budgeted (365.24) Remaining 63 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 962 02/28/2018 Texpool Transfers Feb (217,722.88) (54,430.72) (272,153.60) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (272,153.60) ** (598,738.00) Budgeted (326,584.40) Remaining 45 % Used Department Totals: ----------------------------------- (272,788.36) ** (54,649.10) Monthly Total (599,738.00) Budgeted (326,949.64) Remaining 45 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/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 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS 200.00 200.00 GL _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS 111,668.75 111,668.75 GL _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 111,668.75 111,668.75 ** 223,338.00 Budgeted 111,669.25 Remaining 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 375,000.00 Budgeted 375,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 111,868.75 ** 111,868.75 Monthly Total 598,738.00 Budgeted 486,869.25 Remaining 19 % Used Fund 534 Totals: ----------------------------------- (160,919.61) 57,219.65 Monthly Total (1,000.00) Budgeted 159,919.61 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET FEBRUARY 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 96,079 ACCOUNTS RECEIVABLE - TOTAL ASSETS 96,079 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 95,127 TOTAL FUND BALANCE 96,079 TOTAL LIABILITIES AND FUND BALANCE 96,079 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 22:56 03/15/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 2/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- 99.20- 267.34- 44.557 332.66- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 126,401.55- 45.454 151,682.45- Subtotal: 278,684.00- 278,684.00- 25,379.51- 126,668.89- 45.453 152,015.11- Program number: 278,684.00- 278,684.00- 25,379.51- 126,668.89- 45.453 152,015.11- Department number: Revenues 278,684.00- 278,684.00- 25,379.51- 126,668.89- 45.453 152,015.11- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,379.51- 126,668.89- 45.453 152,015.11- . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 22:56 03/15/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 2/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 200.00 50.000 200.00 535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 31,341.75 31,341.75 50.000 31,342.25 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: 278,084.00 278,084.00 31,541.75 31,541.75 11.343 246,542.25 Program number: 278,084.00 278,084.00 31,541.75 31,541.75 11.343 246,542.25 Department number: Administration 278,084.00 278,084.00 31,541.75 31,541.75 11.343 246,542.25 Expenditures Subtotal ----------- 278,084.00 278,084.00 31,541.75 31,541.75 11.343 246,542.25 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 6,162.24 95,127.14- ############### 94,527.14 ******* End of Report ********* . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 2/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 978 02/28/2018 Bank Interest- February (168.14) (99.20) (267.34) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (99.20) (267.34) ** (600.00) Budgeted (332.66) Remaining 45 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 962 02/28/2018 Texpool Transfers Feb (101,121.24) (25,280.31) (126,401.55) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (126,401.55) ** (278,084.00) Budgeted (151,682.45) Remaining 45 % Used Department Totals: ----------------------------------- (126,668.89) ** (25,379.51) Monthly Total (278,684.00) Budgeted (152,015.11) Remaining 45 % Used . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 2/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 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS 200.00 200.00 GL _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS 31,341.75 31,341.75 GL _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 31,341.75 31,341.75 ** 62,684.00 Budgeted 31,342.25 Remaining 50 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 215,000.00 Budgeted 215,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 31,541.75 ** 31,541.75 Monthly Total 278,084.00 Budgeted 246,542.25 Remaining 11 % Used Fund 535 Totals: ----------------------------------- (95,127.14) 6,162.24 Monthly Total (600.00) Budgeted 94,527.14 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (1,415,206.99) **** 314,936.73 Monthly Total (375,349.00) Budgeted 1,039,857.99 Remaining 377 % Used ******* End of Report *********