Loading...
HomeMy WebLinkAbout2017-05 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MAY 2017 122 ASSETS FIRE DEPT. CASH IN BANK 694 INVESTMENTS 713,095 PREPAID EXPENSES 5,504 ADVALOREM PROPERTY TAXES RECEIVABLE 27,604 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 746,897 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 27,604 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 27,604 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 198,185 TOTAL FUND BALANCE 719,293 TOTAL LIABILITIES AND FUND BALANCE 746,897 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 14:15 06/12/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 112.02- 112.02 122-40010-000-000 Property Taxes/MUD Fire 1,035,810.00- 1,035,810.00- 5,407.65- 1,025,242.12- 98.980 10,567.88- 122-40011-000-000 Property Taxes/Fire-Delinquent 474.85- 2,442.78- 2,442.78 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 507.76- 3,061.51- 68.034 1,438.49- Subtotal: 1,040,310.00- 1,040,310.00- 6,390.26- 1,030,858.43- 99.091 9,451.57- 122-49900-000-000 Miscellaneous Income 149.00- 149.00 Subtotal: 149.00- 149.00 Program number: 1,040,310.00- 1,040,310.00- 6,390.26- 1,031,007.43- 99.106 9,302.57- Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 6,390.26- 1,031,007.43- 99.106 9,302.57- Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 6,390.26- 1,031,007.43- 99.106 9,302.57- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 14:15 06/12/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 10,753.91 10,753.91- Subtotal: 10,753.91 10,753.91- 122-60030-045-000 Rent And/Or Usage 216,754.00 216,754.00 216,754.00 216,754.00 100.000 122-60055-045-000 Insurance 16,513.00 16,513.00 1,376.09 11,008.72 66.667 5,504.28 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 385,737.00 66.319 195,901.00 Subtotal: 814,905.00 814,905.00 267,104.09 613,499.72 75.285 201,405.28 122-69005-045-000 Capital Outlays 16,836.00 16,836.00 16,836.00 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: 225,405.00 225,405.00 208,568.60 92.531 16,836.40 Program number: 1,040,310.00 1,040,310.00 267,104.09 832,822.23 80.055 207,487.77 Department number: Fire 1,040,310.00 1,040,310.00 267,104.09 832,822.23 80.055 207,487.77 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 267,104.09 832,822.23 80.055 207,487.77 Fund number: 122 Trophy Club MUD Fire Dept. 260,713.83 198,185.20- 198,185.20 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs (112.02) .00 (112.02) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (112.02) ** .00 Budgeted 112.02 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1558 05/01/2017 Property Taxes (1,019,834.47) (8.19) (1,019,842.66) GL 1559 05/02/2017 Property Taxes (1,163.85) (1,021,006.51) GL 1560 05/03/2017 Property Taxes (202.47) (1,021,208.98) GL 1561 05/04/2017 Property Taxes (88.79) (1,021,297.77) GL 1562 05/05/2017 Property Taxes (254.63) (1,021,552.40) GL 1563 05/06/2017 Property Taxes (19.80) (1,021,572.20) GL 1564 05/12/2017 Property Taxes (249.09) (1,021,821.29) GL 1566 05/16/2017 Property Taxes (47.08) (1,021,868.37) GL 1567 05/17/2017 Property Taxes (757.73) (1,022,626.10) GL 1568 05/18/2017 Property Taxes (37.26) (1,022,663.36) GL 1569 05/19/2017 Property Taxes (582.33) (1,023,245.69) GL 1576 05/22/2017 Property Taxes (759.85) (1,024,005.54) GL 1593 05/23/2017 Property Taxes (357.89) (1,024,363.43) GL 1596 05/24/2017 Property Taxes (5.08) (1,024,368.51) GL 1597 05/25/2017 Property Taxes (206.57) (1,024,575.08) GL 1608 05/26/2017 Property Taxes (103.35) (1,024,678.43) GL 1651 05/31/2017 Property Taxes (563.69) (1,025,242.12) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (5,407.65) (1,025,242.12) ** (1,035,810.00) Budgeted (10,567.88) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1558 05/01/2017 Property Taxes (1,967.93) (6.73) (1,974.66) GL 1565 05/15/2017 Property Taxes (468.12) (2,442.78) GL 1569 05/19/2017 Property Taxes (334.87) (2,777.65) GL 1593 05/23/2017 Property Taxes 334.87 (2,442.78) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (474.85) (2,442.78) ** .00 Budgeted 2,442.78 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1558 05/01/2017 Property Taxes (2,553.75) (3.32) (2,557.07) GL 1559 05/02/2017 Property Taxes (128.03) (2,685.10) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1560 05/03/2017 Property Taxes (2,553.75) (22.27) (2,707.37) GL 1561 05/04/2017 Property Taxes (9.76) (2,717.13) GL 1562 05/05/2017 Property Taxes (28.00) (2,745.13) GL 1563 05/06/2017 Property Taxes (2.58) (2,747.71) GL 1564 05/12/2017 Property Taxes (20.81) (2,768.52) GL 1565 05/15/2017 Property Taxes (180.18) (2,948.70) GL 1567 05/17/2017 Property Taxes (11.13) (2,959.83) GL 1569 05/19/2017 Property Taxes (37.25) (2,997.08) GL 1576 05/22/2017 Property Taxes (68.07) (3,065.15) GL 1593 05/23/2017 Property Taxes 37.25 (3,027.90) GL 1596 05/24/2017 Property Taxes (.57) (3,028.47) GL 1597 05/25/2017 Property Taxes (8.10) (3,036.57) GL 1651 05/31/2017 Property Taxes (24.94) (3,061.51) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (507.76) (3,061.51) ** (4,500.00) Budgeted (1,438.49) Remaining 68 % Used Account: 122-49900-000-000 Miscellaneous Income (149.00) .00 (149.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (149.00) ** .00 Budgeted 149.00 Remaining 0 % Used Department Totals: ----------------------------------- (1,031,007.43) ** (6,390.26) Monthly Total (1,040,310.00) Budgeted (9,302.57) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 10,753.91 .00 10,753.91 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 10,753.91 ** .00 Budgeted (10,753.91) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage 1625 05/31/2017 Texpool Transfer-FD Rent 216,754.00 216,754.00 GL _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: 216,754.00 216,754.00 ** 216,754.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 467 05/01/2017 Insurance/Wrk Comp Exp May 9,632.63 1,376.09 11,008.72 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.09 11,008.72 ** 16,513.00 Budgeted 5,504.28 Remaining 67 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1555 05/23/2017 May A/P Fire Adm-may 336,763.00 48,974.00 385,737.00 TOWN OF TROPHY CLUB 3168 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 385,737.00 ** 581,638.00 Budgeted 195,901.00 Remaining 66 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 16,836.00 Budgeted 16,836.00 Remaining 0 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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: ----------------------------------- 832,822.23 ** 267,104.09 Monthly Total 1,040,310.00 Budgeted 207,487.77 Remaining 80 % Used Fund 122 Totals: ----------------------------------- (198,185.20) 260,713.83 Monthly Total .00 Budgeted 198,185.20 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MAY 2017 GTBGT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 861,783 - 861,783 CASH IN BANK-SAVINGS-CASH RESERVE 380,412 - 380,412 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 713,335 - 713,335 INVESTMENTS-TEXPOOL 514,101 433,170 947,271 PREPAID EXPENSES 30,740 - 30,740 ADVALOREM PROPERTY TAXES RECEIVABLE 2,394 - 2,394 UTILITY AND OTHER ACCOUNTS RECEIVABLE 957,709 - 957,709 TOTAL ASSETS 3,496,232 433,170 3,929,402 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,394 - 2,394 ACCOUNTS AND OTHER PAYABLES 636,270 - 636,270 CUSTOMER DEPOSITS 314,180 - 314,180 - TOTAL LIABILITIES 952,844 - 952,844 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 727,500 727,500 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 135,000 135,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 90,000 90,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 37,805 37,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 170,365 170,365 UNASSIGNED FUND BALANCE 1,400,622 - 1,400,622 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 411,780 - 411,780 - TOTAL FUND BALANCE 2,543,388 433,170 2,976,558 TOTAL LIABILITIES AND FUND BALANCE 3,496,232 433,170 3,929,402 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 60,977.00- 60,977.00- 318.13- 60,334.89- 98.947 642.11- 135-40002-000-000 Property Taxes/Delinquent 46.72- 210.98- 210.98 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 36.78- 202.54- 31.160 447.46- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 401.63- 60,748.41- 28.939 149,169.59- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 563,485.74- 3,185,609.85- 49.491 3,251,124.15- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 228,545.23- 1,605,398.08- 61.053 1,024,125.92- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 9,319.90- 75,502.05- 63.309 43,757.95- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,075.00- 9,575.00- 83.991 1,825.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 200.00- 1,150.00- 57.500 850.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 600.00- 2,550.00- 46.364 2,950.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 14,019.20- 31,271.45- 51.107 29,916.55- Subtotal: 9,265,606.00- 9,265,606.00- 817,245.07- 4,911,056.43- 53.003 4,354,549.57- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 1,716.70- 10,534.87- 131.669 2,533.87 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 7,284.24- 66.669 3,641.76- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 4,666.64- 66.666 2,333.36- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49035-000-000 Prior Year Reserves 295,408.00- 295,408.00- 135-49075-000-000 Oversize Meter Reimbursement 21,609.00- 21,609.00- 5,104.02- 15,119.02- 69.966 6,489.98- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 493.00- 6,584.98- 32.925 13,415.02- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 32.00- 160.000 12.00 Subtotal: 69,556.00- 364,964.00- 8,807.58- 44,221.75- 12.117 320,742.25- Program number: 9,545,080.00- 9,840,488.00- 826,454.28- 5,016,026.59- 50.973 4,824,461.41- Department number: Revenues 9,545,080.00- 9,840,488.00- 826,454.28- 5,016,026.59- 50.973 4,824,461.41- Revenues Subtotal ----------- 9,545,080.00- 9,840,488.00- 826,454.28- 5,016,026.59- 50.973 4,824,461.41- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 271,143.00 271,143.00 14,913.44 141,253.76 52.096 129,889.24 135-50010-010-000 Overtime 19,500.00 19,500.00 783.82 8,187.14 41.985 11,312.86 135-50016-010-000 Longevity 3,270.00 3,270.00 3,270.00 100.000 135-50017-010-000 Certification 4,800.00 4,800.00 175.00 1,875.00 39.063 2,925.00 135-50020-010-000 Retirement 27,151.00 27,151.00 1,468.18 13,978.53 51.484 13,172.47 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 1,889.77 21,061.28 37.667 34,852.72 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 205.93 2,005.91 48.231 2,153.09 135-50028-010-000 Vision Insurance 910.00 910.00 40.17 390.38 42.899 519.62 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 370.53 1,930.50 68.873 872.50 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 970.79 9,340.00 49.104 9,681.00 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 227.04 2,184.37 49.109 2,263.63 135-50040-010-000 Unemployment Taxes 1,026.00 1,026.00 45.00 4.386 981.00 135-50045-010-000 Workman's Compensation 13,152.00 13,152.00 48.16 7,567.28 57.537 5,584.72 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 1,300.00 135-50070-010-000 Employee Relations 300.00 300.00 187.09 62.363 112.91 Subtotal: 428,897.00 428,897.00 21,092.83 213,276.24 49.727 215,620.76 135-55005-010-000 Engineering 5,000.00 60,000.00 36,224.43 60.374 23,775.57 135-55080-010-000 Maintenance & Repairs 100,000.00 128,500.00 2,927.28 52,676.69 40.994 75,823.31 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 1,350.00 1,350.00 45.000 1,650.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 196.74 1,019.89 12.749 6,980.11 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 225.00 2,535.80 46.105 2,964.20 Subtotal: 125,000.00 208,500.00 4,699.02 93,806.81 44.991 114,693.19 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 346.75 2,466.34 45.673 2,933.66 135-60020-010-000 Electricity 172,737.00 172,737.00 13,084.52 90,187.03 52.211 82,549.97 135-60066-010-000 Publications/Books/Subscripts 750.00 750.00 767.00 102.267 17.00- 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,222.00 4,222.00 300.00 565.00 13.382 3,657.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 1,500.00 124.46 8.297 1,375.54 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 50,176.00 50,176.00 21,940.45 43.727 28,235.55 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 173,823.56 1,032,807.51 34.441 1,965,994.49 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 102.70 51.350 97.30 135-60280-010-000 Property Maintenance 5,000.00 5,000.00 594.60 11.892 4,405.40 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 3,000.00 20.339 11,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 297,011.00 21,892.88 175,143.01 58.969 121,867.99 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 14,361.00 114,888.00 176.969 49,968.00- 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,820,368.00 3,820,368.00 223,808.71 1,442,586.10 37.760 2,377,781.90 135-65005-010-000 Fuel & Lube 33,011.00 24,828.00 678.42 5,585.59 22.497 19,242.41 135-65010-010-000 Uniforms 4,608.00 4,608.00 1,329.48 28.852 3,278.52 135-65030-010-000 Chemicals 20,000.00 20,000.00 633.24 9,529.58 47.648 10,470.42 135-65035-010-000 Small Tools 1,200.00 1,200.00 221.62 18.468 978.38 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 115,000.00 31,500.00 17,069.88 54.190 14,430.12 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 48,264.00 59.220 33,236.00 Subtotal: 256,319.00 164,636.00 1,311.66 82,000.15 49.807 82,635.85 135-69005-010-000 Capital Outlays 502,421.00 690,422.00 14,309.40 302,870.09 43.867 387,551.91 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 126,958.00 126,957.75 100.000 .25 Subtotal: 696,196.00 892,380.00 14,309.40 504,827.84 56.571 387,552.16 Program number: 5,326,780.00 5,514,781.00 265,221.62 2,336,497.14 42.368 3,178,283.86 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 80.00 975.40 19.508 4,024.60 Subtotal: 5,000.00 5,000.00 80.00 975.40 19.508 4,024.60 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 80.00 975.40 9.754 9,024.60 Department number: Water 5,336,780.00 5,524,781.00 265,301.62 2,337,472.54 42.309 3,187,308.46 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 391,102.00 391,102.00 30,019.77 237,467.11 60.717 153,634.89 135-50010-020-000 Overtime 29,500.00 29,500.00 1,758.74 21,285.68 72.155 8,214.32 135-50016-020-000 Longevity 6,635.00 6,635.00 6,635.00 100.000 135-50017-020-000 Certification 7,800.00 7,800.00 1,250.00 5,475.00 70.192 2,325.00 135-50020-020-000 Retirement 39,584.00 39,584.00 3,055.16 24,504.47 61.905 15,079.53 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,710.20 36,294.71 49.704 36,727.29 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 399.32 2,867.04 62.436 1,724.96 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 84.33 616.92 59.837 414.08 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 740.65 3,346.67 74.619 1,138.33 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 1,915.85 15,738.77 56.440 12,147.23 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 448.06 3,680.83 56.437 2,841.17 135-50040-020-000 Unemployment Taxes 1,197.00 1,197.00 63.00 5.263 1,134.00 135-50045-020-000 Workman's Compensation 11,347.00 11,347.00 4,708.75 11,196.00 98.669 151.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 80.00 80.00 26.667 220.00 135-50070-020-000 Employee Relations 650.00 650.00 66.40 391.62 60.249 258.38 Subtotal: 605,653.00 605,653.00 49,237.23 369,642.82 61.032 236,010.18 135-55005-020-000 Engineering 70,000.00 70,000.00 852.48 852.48 1.218 69,147.52 135-55070-020-000 Independent Labor 20,000.00 20,000.00 19,449.39 97.247 550.61 135-55080-020-000 Maintenance & Repairs 83,100.00 79,700.00 14,610.43 50,084.49 62.841 29,615.51 135-55085-020-000 Generator Maint. and Repair 20,000.00 20,000.00 1,566.00 1,566.00 7.830 18,434.00 135-55090-020-000 Vehicle Maintenance 4,000.00 6,600.00 102.99 7,160.52 108.493 560.52- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 23.94 4.788 476.06 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 8,559.43 38,962.29 70.841 16,037.71 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,592.00 18,913.00 75.652 6,087.00 Subtotal: 277,600.00 276,800.00 28,283.33 137,012.11 49.499 139,787.89 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 411.68 3,256.41 60.304 2,143.59 135-60020-020-000 Electricity 158,627.00 158,627.00 13,354.43 89,733.23 56.569 68,893.77 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 143.85 35.963 256.15 135-60070-020-000 Dues & Memberships 250.00 267.00 267.00 100.000 135-60080-020-000 Schools & Training 4,195.00 4,195.00 2,307.81 55.013 1,887.19 135-60090-020-000 Safety Program 550.00 550.00 282.15 51.300 267.85 135-60100-020-000 Travel & per diem 1,600.00 2,400.00 17.09 2,262.59 94.275 137.41 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60125-020-000 Advertising 4,086.37 4,086.37- 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 111.00 14,676.97 85.580 2,473.03 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 6,621.00 6,621.00 6,621.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 2,360.00 20.345 9,240.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 10,953.82 87,630.56 72.727 32,861.44 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 54,148.91 433,191.28 72.727 162,446.72 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60333-020-000 Interfund Transfer Out-Reserve 123,492.00 123,492.00 56,132.70 45.455 67,359.30 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 Subtotal: 1,255,465.00 1,256,282.00 78,996.93 696,330.92 55.428 559,951.08 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 627.59 5,701.64 20.299 22,386.36 135-65010-020-000 Uniforms 4,459.00 4,459.00 3,753.87 84.186 705.13 135-65030-020-000 Chemicals 25,000.00 21,000.00 2,964.66 17,906.95 85.271 3,093.05 135-65035-020-000 Small Tools 2,000.00 2,000.00 37.72 1,405.54 70.277 594.46 135-65040-020-000 Safety Equipment 750.00 750.00 252.64 33.685 497.36 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 4.17 10,672.94 76.235 3,327.06 Subtotal: 74,297.00 70,297.00 3,634.14 39,693.58 56.466 30,603.42 135-69005-020-000 Capital Outlays 485,000.00 462,000.00 4,545.71 200,903.11 43.486 261,096.89 Subtotal: 485,000.00 462,000.00 4,545.71 200,903.11 43.486 261,096.89 Program number: 2,698,015.00 2,671,032.00 164,697.34 1,443,582.54 54.046 1,227,449.46 Department number: Wastewater 2,698,015.00 2,671,032.00 164,697.34 1,443,582.54 54.046 1,227,449.46 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 32.00 32.00 1.61 19.88 62.125 12.12 Subtotal: 32.00 32.00 1.61 19.88 62.125 12.12 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.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 2,725.00 68.125 1,275.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,819.37 36.387 3,180.63 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 12,850.00 12,850.00 4,544.37 35.365 8,305.63 Program number: 12,882.00 12,882.00 1.61 4,564.25 35.431 8,317.75 Department number: Board of Directors 12,882.00 12,882.00 1.61 4,564.25 35.431 8,317.75 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 519,883.00 519,883.00 38,956.97 262,010.62 50.398 257,872.38 135-50010-030-000 Overtime 1,000.00 2,500.00 53.96 3,247.19 129.888 747.19- 135-50016-030-000 Longevity 3,890.00 3,417.00 3,417.50 100.015 .50- 135-50020-030-000 Retirement 47,768.00 47,768.00 3,608.53 24,156.30 50.570 23,611.70 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 4,552.02 29,603.25 35.121 54,685.75 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 416.81 2,586.59 43.247 3,394.41 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 88.84 553.09 42.156 758.91 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 876.24 3,296.79 55.973 2,593.21 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 2,307.14 15,788.62 48.170 16,988.38 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 539.57 3,692.49 45.677 4,391.51 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 293.73 21.471 1,074.27 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 195.53 1,214.24 68.063 569.76 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 402.35 80.470 97.65 135-50070-030-000 Employee Relations 4,960.00 4,960.00 21.94 2,605.40 52.528 2,354.60 Subtotal: 719,486.00 720,513.00 51,617.55 352,868.16 48.975 367,644.84 135-55030-030-000 Software & Support 67,791.00 77,791.00 11,019.59 76,940.04 98.906 850.96 135-55070-030-000 Independent Labor 12,000.00 4,000.00 932.50 23.313 3,067.50 135-55080-030-000 Maintenance & Repairs 7,000.00 2,000.00 551.00 826.00 41.300 1,174.00 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 485.00 4.850 9,515.00 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 263.97 5,938.52 84.836 1,061.48 135-55120-030-000 Cleaning Services 10,429.00 8,000.00 633.06 4,172.42 52.155 3,827.58 135-55160-030-000 Professional Outside Services 63,325.00 60,000.00 57,332.00 95.553 2,668.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 593.10 5,005.64 61.044 3,194.36 Subtotal: 185,945.00 177,191.00 13,060.72 151,632.12 85.576 25,558.88 135-60005-030-000 Telephone 17,532.00 17,532.00 2,570.08 9,272.79 52.891 8,259.21 135-60010-030-000 Communications/Mobiles 4,150.00 3,500.00 337.99 2,140.93 61.169 1,359.07 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 882.09 6.984 11,748.91 135-60025-030-000 Water 1,500.00 1,500.00 249.39 778.14 51.876 721.86 135-60035-030-000 Postage 28,932.00 28,932.00 1,899.85 18,736.07 64.759 10,195.93 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,097.14 32,864.55 59.151 22,695.45 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 526.88 15.054 2,973.12 135-60055-030-000 Insurance 55,692.00 55,692.00 4,556.76 37,208.68 66.812 18,483.32 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 311.88 19.493 1,288.12 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 4,336.25 72.271 1,663.75 135-60075-030-000 Meetings 400.00 400.00 52.50 52.50 13.125 347.50 135-60079-030-000 Public Education 8,754.00 8,754.00 18.98 4,872.32 55.658 3,881.68 135-60080-030-000 Schools & Training 7,840.00 7,840.00 1,000.00 1,675.00 21.365 6,165.00 135-60100-030-000 Travel & per diem 5,400.00 7,500.00 39.80 6,932.27 92.430 567.73 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 7,500.00 7,500.00 2,279.72 2,822.67 37.636 4,677.33 135-60125-030-000 Advertising 7,500.00 7,500.00 598.00 1,698.09 22.641 5,801.91 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 76.00 .434 17,424.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 1,040.00 41.600 1,460.00 Subtotal: 246,041.00 247,491.00 17,700.21 126,227.11 51.003 121,263.89 135-65010-030-000 Uniforms 1,855.00 855.00 142.36 16.650 712.64 135-65055-030-000 Hardware 9,444.00 9,444.00 35.32 2,300.20 24.356 7,143.80 135-65085-030-000 Office Supplies 9,000.00 9,000.00 528.07 4,320.87 48.010 4,679.13 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 478.78 23.939 1,521.22 135-65095-030-000 Maintenance Supplies 5,000.00 4,000.00 789.42 2,383.74 59.594 1,616.26 135-65105-030-000 Printing 4,800.00 2,500.00 58.77 546.77 21.871 1,953.23 Subtotal: 32,099.00 27,799.00 1,411.58 10,172.72 36.594 17,626.28 135-69005-030-000 Capital Outlays 107,001.00 265,424.00 93,748.00 108,193.45 40.762 157,230.55 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 270.25 2,604.33 56.616 1,995.67 Subtotal: 111,601.00 270,024.00 94,018.25 110,797.78 41.033 159,226.22 Program number: 1,295,172.00 1,443,018.00 177,808.31 751,697.89 52.092 691,320.11 Department number: Administration 1,295,172.00 1,443,018.00 177,808.31 751,697.89 52.092 691,320.11 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 14:15 06/12/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 150,000.00 150,000.00 810.00 38,937.01 25.958 111,062.99 135-55055-039-000 Auditing 23,860.00 23,860.00 18,808.92 78.830 5,051.08 135-55060-039-000 Appraisal 11,115.00 11,115.00 6,621.58 59.573 4,493.42 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,561.76 67.415 1,238.24 Subtotal: 188,775.00 188,775.00 810.00 66,929.27 35.455 121,845.73 Program number: 188,775.00 188,775.00 810.00 66,929.27 35.455 121,845.73 Department number: Non Departmental 188,775.00 188,775.00 810.00 66,929.27 35.455 121,845.73 Expenditures Subtotal ----------- 9,531,624.00 9,840,488.00 608,618.88 4,604,246.49 46.789 5,236,241.51 Fund number: 135 MUD 1 General Fund 13,456.00- 217,835.40- 411,780.10- 411,780.10 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 14:15 06/12/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 1558 05/01/2017 Property Taxes (60,016.76) (.48) (60,017.24) GL 1559 05/02/2017 Property Taxes (68.47) (60,085.71) GL 1560 05/03/2017 Property Taxes (11.91) (60,097.62) GL 1561 05/04/2017 Property Taxes (5.22) (60,102.84) GL 1562 05/05/2017 Property Taxes (14.98) (60,117.82) GL 1563 05/06/2017 Property Taxes (1.17) (60,118.99) GL 1564 05/12/2017 Property Taxes (14.65) (60,133.64) GL 1566 05/16/2017 Property Taxes (2.77) (60,136.41) GL 1567 05/17/2017 Property Taxes (44.58) (60,180.99) GL 1568 05/18/2017 Property Taxes (2.19) (60,183.18) GL 1569 05/19/2017 Property Taxes (34.26) (60,217.44) GL 1576 05/22/2017 Property Taxes (44.70) (60,262.14) GL 1593 05/23/2017 Property Taxes (21.06) (60,283.20) GL 1596 05/24/2017 Property Taxes (.30) (60,283.50) GL 1597 05/25/2017 Property Taxes (12.15) (60,295.65) GL 1608 05/26/2017 Property Taxes (6.08) (60,301.73) GL 1651 05/31/2017 Property Taxes (33.16) (60,334.89) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (318.13) (60,334.89) ** (60,977.00) Budgeted (642.11) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1558 05/01/2017 Property Taxes (164.26) (1.29) (165.55) GL 1565 05/15/2017 Property Taxes (45.43) (210.98) GL 1569 05/19/2017 Property Taxes (31.84) (242.82) GL 1593 05/23/2017 Property Taxes 31.84 (210.98) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (46.72) (210.98) ** .00 Budgeted 210.98 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1558 05/01/2017 Property Taxes (165.76) (.52) (166.28) GL 1559 05/02/2017 Property Taxes (7.53) (173.81) GL 1560 05/03/2017 Property Taxes (1.31) (175.12) GL 1561 05/04/2017 Property Taxes (.58) (175.70) GL 1562 05/05/2017 Property Taxes (1.65) (177.35) GL 1563 05/06/2017 Property Taxes (.15) (177.50) GL 1564 05/12/2017 Property Taxes (1.23) (178.73) GL 1565 05/15/2017 Property Taxes (17.17) (195.90) GL 1567 05/17/2017 Property Taxes (.65) (196.55) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1569 05/19/2017 Property Taxes (165.76) (3.55) (200.10) GL 1576 05/22/2017 Property Taxes (4.01) (204.11) GL 1593 05/23/2017 Property Taxes 3.55 (200.56) GL 1596 05/24/2017 Property Taxes (.03) (200.59) GL 1655 05/24/2017 Property Taxes (542.77) (743.36) GL 1597 05/25/2017 Property Taxes (.48) (743.84) GL 1651 05/31/2017 Property Taxes (1.47) (745.31) GL 1687 05/31/2017 May A/P FKA MUD2 Tax Refund Shortage 542.77 (202.54) DENTON COUNTY TAX OFFICE AP _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (36.78) (202.54) ** (650.00) Budgeted (447.46) Remaining 31 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (148,291.00) Budgeted (148,291.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1610 05/03/2017 UB 5/3/17 bill adj-prorate UB20170503-20170503 User: (2,622,124.11) 25.89 (2,622,098.22) UB 1611 05/08/2017 UB 5/8/17 Bill adj-prorate UB20170508-20170508 User: 17.73 (2,622,080.49) UB 1613 05/10/2017 UB 5/10/17 Bill adj-prorate UB20170510-20170510 User: 14.75 (2,622,065.74) UB 1614 05/11/2017 UB 5/11/17 Bill adj-prorate UB20170511-20170511 User: 36.06 (2,622,029.68) UB 1491 05/12/2017 05/12/2017 UB Adjustment UB20170512-20170512 User: 46.81 (2,621,982.87) UB 1645 05/12/2017 05/12/2017 UB Adjustments UB20170512-20170512 User: 52.90 (2,621,929.97) UB 1544 05/22/2017 05/22/2017 UB Bill Adjustment UB20170522-20170522 User: 38.82 (2,621,891.15) UB 1551 05/23/2017 Adjustments on bill per Nicole UB20170523-20170523 User: 18.79 (2,621,872.36) UB 1577 05/24/2017 05/24/2017 UB Adjust to bill UB20170524-20170524 User: 571.84 (2,621,300.52) UB 1619 05/31/2017 UB 5/31/17 PEnalty adj UB20170531-20170531 User: 18.37 (2,621,282.15) UB 1626 05/31/2017 05/31/2017 UB Billing UB20170531-20170531 User: (564,327.70) (3,185,609.85) UB _______________ Account: 135-47000-000-000 Water Totals: (563,485.74) (3,185,609.85) ** (6,436,734.00) Budgeted (3,251,124.15) Remaining 49 % Used Account: 135-47005-000-000 Sewer 1611 05/08/2017 UB 5/8/17 Bill adj-prorate UB20170508-20170508 User: (1,376,852.85) .22 (1,376,852.63) UB 1613 05/10/2017 UB 5/10/17 Bill adj-prorate UB20170510-20170510 User: 35.67 (1,376,816.96) UB 1614 05/11/2017 UB 5/11/17 Bill adj-prorate UB20170511-20170511 User: 38.99 (1,376,777.97) UB 1643 05/12/2017 05/12/2017 UB Adjustments UB20170512-20170512 User: 48.14 (1,376,729.83) UB 1615 05/17/2017 UB 5/17/17 Sewer adj UB20170517-20170517 User: 100.79 (1,376,629.04) UB . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1553 05/23/2017 05/23/17 UB Adj on bill UB20170523-20170523 User: (1,376,852.85) 30.79 (1,376,598.25) UB 1619 05/31/2017 UB 5/31/17 PEnalty adj UB20170531-20170531 User: 24.07 (1,376,574.18) UB 1626 05/31/2017 05/31/2017 UB Billing UB20170531-20170531 User: (228,823.90) (1,605,398.08) UB _______________ Account: 135-47005-000-000 Sewer Totals: (228,545.23) (1,605,398.08) ** (2,629,524.00) Budgeted (1,024,125.92) Remaining 61 % Used Account: 135-47025-000-000 Penalties 1637 05/09/2017 05/09/2017 UB Penalties UB20170509-20170509 User: (66,182.15) 343.77 (65,838.38) UB 1557 05/23/2017 05/23/2017 UB Penalties UB20170523-20170523 User: (9,978.92) (75,817.30) UB 1633 05/23/2017 05/23/2017 Ub Penalties UB20170523-20170523 User: 15.35 (75,801.95) UB 1629 05/30/2017 05/30/2017 UB Penalties UB20170530-20170530 User: 204.11 (75,597.84) UB 1619 05/31/2017 UB 5/31/17 PEnalty adj UB20170531-20170531 User: 95.79 (75,502.05) UB _______________ Account: 135-47025-000-000 Penalties Totals: (9,319.90) (75,502.05) ** (119,260.00) Budgeted (43,757.95) Remaining 63 % Used Account: 135-47030-000-000 Service Charges 1463 05/09/2017 05/09/2017 UB Disconnect Fee UB20170509-20170509 User: (8,500.00) (1,000.00) (9,500.00) UB 1630 05/19/2017 05/19/2017 UB NSF Fees UB20170519-20170519 User: (75.00) (9,575.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,075.00) (9,575.00) ** (11,400.00) Budgeted (1,825.00) Remaining 84 % Used Account: 135-47035-000-000 Plumbing Inspections 1414 05/03/2017 05/03/2017 UB Permits 333 Tenison Trail (950.00) (50.00) (1,000.00) First Texas Homes CR 1468 05/09/2017 05/09/2017 UB Permits 100 Municipal Drive (50.00) (1,050.00) Town of Trophy Club CR 1484 05/11/2017 05/11/2017 UB permits 652 Sheldon Drive (50.00) (1,100.00) Ashton Woods Homes CR 1502 05/15/2017 05/15/2017 UB Permits 656 Sheldon Drive (50.00) (1,150.00) Ashton Dallas Residential CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (1,150.00) ** (2,000.00) Budgeted (850.00) Remaining 58 % Used Account: 135-47045-000-000 Sewer Inspections 1414 05/03/2017 05/03/2017 UB Permits 333 Tenison Trail (1,950.00) (150.00) (2,100.00) First Texas Homes CR 1468 05/09/2017 05/09/2017 UB Permits 100 Municipal Drive (150.00) (2,250.00) Town of Trophy Club CR 1484 05/11/2017 05/11/2017 UB permits 652 Sheldon Drive (150.00) (2,400.00) Ashton Woods Homes CR 1502 05/15/2017 05/15/2017 UB Permits 656 Sheldon Drive (150.00) (2,550.00) Ashton Dallas Residential CR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (2,550.00) ** (5,500.00) Budgeted (2,950.00) Remaining 46 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1626 05/31/2017 05/31/2017 UB Billing UB20170531-20170531 User: (17,252.25) (14,019.20) (31,271.45) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (14,019.20) (31,271.45) ** (61,188.00) Budgeted (29,916.55) Remaining 51 % Used Account: 135-49010-000-000 Interest Income 1691 05/31/2017 Bank Interest/May Prosperity General Fund (8,818.17) (255.90) (9,074.07) GL 1691 05/31/2017 Bank Interest/May Bank of the West (161.20) (9,235.27) GL 1691 05/31/2017 Bank Interest/May Texpool O&M (1,299.60) (10,534.87) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,716.70) (10,534.87) ** (8,001.00) Budgeted 2,533.87 Remaining 132 % Used Account: 135-49016-000-000 Cell Tower Revenue 1466 05/02/2017 AT&T Cell Tower Revenue (6,373.71) (910.53) (7,284.24) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (7,284.24) ** (10,926.00) Budgeted (3,641.76) Remaining 67 % Used Account: 135-49018-000-000 Building Rent Income 1680 05/31/2017 Town Billing May Inv 1567-1573 AR 20170501-20170531 User: (4,083.31) (583.33) (4,666.64) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,666.64) ** (7,000.00) Budgeted (2,333.36) Remaining 67 % 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-49035-000-000 Prior Year Reserves . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (295,408.00) Budgeted (295,408.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1414 05/03/2017 05/03/2017 UB Permits 333 Tenison Trail (10,015.00) (343.00) (10,358.00) First Texas Homes CR 1468 05/09/2017 05/09/2017 UB Permits 100 Municipal Drive (838.56) (11,196.56) Town Of Trophy Club CR 1468 05/09/2017 05/09/2017 UB Permits 100 Muicipal Drive (2,893.46) (14,090.02) Town of Trophy Club CR 1484 05/11/2017 05/11/2017 UB permits 652 Sheldon Drive (343.00) (14,433.02) Ashton Woods Homes CR 1502 05/15/2017 05/15/2017 UB Permits 656 Sheldon Drive (343.00) (14,776.02) Ashton Dallas Residential CR 1533 05/19/2017 05/19/2017 UB Permits 2801 ANNANDALE DRIVE (343.00) (15,119.02) Lennar Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,104.02) (15,119.02) ** (21,609.00) Budgeted (6,489.98) Remaining 70 % Used Account: 135-49900-000-000 Miscellaneous Income 1626 05/31/2017 05/31/2017 UB Billing UB20170531-20170531 User: (6,091.98) (193.00) (6,284.98) UB 1688 05/31/2017 Balance GL to AR module (300.00) (6,584.98) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (493.00) (6,584.98) ** (20,000.00) Budgeted (13,415.02) Remaining 33 % Used Account: 135-49901-000-000 Records Management Revenue (32.00) .00 (32.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (32.00) ** (20.00) Budgeted 12.00 Remaining 160 % Used Department Totals: ----------------------------------- (5,016,026.59) ** (826,454.28) Monthly Total (9,840,488.00) Budgeted (4,824,461.41) Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 1407 05/05/2017 MUD PR 05/05/17 Salaries & Wages 126,340.32 7,658.56 133,998.88 PR 1512 05/19/2017 Mud PR 05/19/17 Salaries & Wages 7,254.88 141,253.76 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 14,913.44 141,253.76 ** 271,143.00 Budgeted 129,889.24 Remaining 52 % Used Account: 135-50010-010-000 Overtime 1407 05/05/2017 MUD PR 05/05/17 Overtime 7,403.32 436.01 7,839.33 PR 1512 05/19/2017 Mud PR 05/19/17 Overtime 347.81 8,187.14 PR _______________ Account: 135-50010-010-000 Overtime Totals: 783.82 8,187.14 ** 19,500.00 Budgeted 11,312.86 Remaining 42 % Used Account: 135-50016-010-000 Longevity 3,270.00 .00 3,270.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,270.00 ** 3,270.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1512 05/19/2017 Mud PR 05/19/17 Certification 1,700.00 175.00 1,875.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 1,875.00 ** 4,800.00 Budgeted 2,925.00 Remaining 39 % Used Account: 135-50020-010-000 Retirement 1407 05/05/2017 MUD PR 05/05/17 Retirement 12,510.35 748.75 13,259.10 PR 1512 05/19/2017 Mud PR 05/19/17 Retirement 719.43 13,978.53 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,468.18 13,978.53 ** 27,151.00 Budgeted 13,172.47 Remaining 51 % Used Account: 135-50026-010-000 Medical Insurance 1407 05/05/2017 MUD PR 05/05/17 Medical Insurance 19,171.51 944.88 20,116.39 PR 1512 05/19/2017 Mud PR 05/19/17 Medical Insurance 944.89 21,061.28 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,889.77 21,061.28 ** 55,914.00 Budgeted 34,852.72 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 1407 05/05/2017 MUD PR 05/05/17 Dental Insurance 1,799.98 102.98 1,902.96 PR 1512 05/19/2017 Mud PR 05/19/17 Dental Insurance 102.95 2,005.91 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 205.93 2,005.91 ** 4,159.00 Budgeted 2,153.09 Remaining 48 % Used Account: 135-50028-010-000 Vision Insurance 1407 05/05/2017 MUD PR 05/05/17 Vision Insurance 350.21 20.10 370.31 PR 1512 05/19/2017 Mud PR 05/19/17 Vision Insurance 20.07 390.38 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 40.17 390.38 ** 910.00 Budgeted 519.62 Remaining 43 % Used Account: 135-50029-010-000 Life Insurance & Other 1465 05/09/2017 May A/P Dental, Vision,misc ins 1,559.97 180.41 1,740.38 METLIFE GROUP BENEFITS 3127 AP 1525 05/18/2017 May A/P Café 125 Admin fees 9.71 1,750.09 BenefitMall 3144 AP 1555 05/23/2017 May A/P Dental, Vision, Misc. Ins-June 180.41 1,930.50 METLIFE GROUP BENEFITS 3163 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 370.53 1,930.50 ** 2,803.00 Budgeted 872.50 Remaining 69 % Used Account: 135-50030-010-000 Social Security Taxes 1407 05/05/2017 MUD PR 05/05/17 Social Security Taxes 8,369.21 496.49 8,865.70 PR 1512 05/19/2017 Mud PR 05/19/17 Social Security Taxes 474.30 9,340.00 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 970.79 9,340.00 ** 19,021.00 Budgeted 9,681.00 Remaining 49 % Used Account: 135-50035-010-000 Medicare Taxes 1407 05/05/2017 MUD PR 05/05/17 Medicare Taxes 1,957.33 116.11 2,073.44 PR 1512 05/19/2017 Mud PR 05/19/17 Medicare Taxes 110.93 2,184.37 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 227.04 2,184.37 ** 4,448.00 Budgeted 2,263.63 Remaining 49 % Used Account: 135-50040-010-000 Unemployment Taxes 45.00 .00 45.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 45.00 ** 1,026.00 Budgeted 981.00 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 467 05/01/2017 Insurance/Wrk Comp Exp May 7,519.12 1,074.16 8,593.28 GL 1700 05/31/2017 May A/P TML (1,026.00) 7,567.28 TML INTERGOVERNMENTAL RISK 3211 AP _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 48.16 7,567.28 ** 13,152.00 Budgeted 5,584.72 Remaining 58 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 1,300.00 Budgeted 1,300.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations 187.09 .00 187.09 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 187.09 ** 300.00 Budgeted 112.91 Remaining 62 % Used Account: 135-55005-010-000 Engineering 36,224.43 .00 36,224.43 _______________ Account: 135-55005-010-000 Engineering Totals: .00 36,224.43 ** 60,000.00 Budgeted 23,775.57 Remaining 60 % Used Account: 135-55080-010-000 Maintenance & Repairs 1409 05/03/2017 May A/P Gate repair 49,749.41 100.00 49,849.41 Alan's Gates, Inc. 3099 AP 1409 05/03/2017 May A/P Water line hit Katie Lane 6,685.00 56,534.41 REY-MAR CONSTRUCTION 3100 AP 1500 05/15/2017 May A/P Pump work 550.00 57,084.41 DHS AUTOMATION, INC 3112 AP 1592 05/22/2017 Drees Waterline Repair/Rey-Mar (6,685.00) 50,399.41 GL 1555 05/23/2017 May A/P Parts 357.54 50,756.95 HD SUPPLY WATERWORKS, LTD. 3153 AP 1650 05/26/2017 PCards 4/27-5/26/17 THE HOME DEPOT #6581 100.73 50,857.68 THE HOME DEPOT #6581 PC 1650 05/26/2017 PCards 4/27-5/26/17 ROANOKE AUTO SUPPLY LT 19.27 50,876.95 ROANOKE AUTO SUPPLY LT PC 1650 05/26/2017 PCards 4/27-5/26/17 FERGUSON ENTERPRISES 1 91.40 50,968.35 FERGUSON ENTERPRISES 1 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1650 05/26/2017 PCards 4/27-5/26/17 ROANOKE AUTO SUPPLY LT 49,749.41 31.07 50,999.42 ROANOKE AUTO SUPPLY LT PC 1650 05/26/2017 PCards 4/27-5/26/17 THE HOME DEPOT #6581 121.29 51,120.71 THE HOME DEPOT #6581 PC 1650 05/26/2017 PCards 4/27-5/26/17 ONLINECOMPONENTS.COM 277.99 51,398.70 ONLINECOMPONENTS.COM PC 1650 05/26/2017 PCards 4/27-5/26/17 AQUA-METRIC SALES INC. 1,000.00 52,398.70 AQUA-METRIC SALES INC. PC 1650 05/26/2017 PCards 4/27-5/26/17 ONLINECOMPONENTS.COM 277.99 52,676.69 ONLINECOMPONENTS.COM PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,927.28 52,676.69 ** 128,500.00 Budgeted 75,823.31 Remaining 41 % Used Account: 135-55085-010-000 Generator Maint. and Repair 1620 05/31/2017 May A/P Generator maintenance 1,350.00 1,350.00 Sluder Emergency Power Service 3200 AP _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: 1,350.00 1,350.00 ** 3,000.00 Budgeted 1,650.00 Remaining 45 % Used Account: 135-55090-010-000 Vehicle Maintenance 1650 05/26/2017 PCards 4/27-5/26/17 ROANOKE AUTO SUPPLY LT 823.15 154.99 978.14 ROANOKE AUTO SUPPLY LT PC 1650 05/26/2017 PCards 4/27-5/26/17 DENTON VEHREG 14.25 992.39 DENTON VEHREG PC 1650 05/26/2017 PCards 4/27-5/26/17 TX.GOV SERVICEFEE 2.00 994.39 TX.GOV SERVICEFEE PC 1650 05/26/2017 PCards 4/27-5/26/17 KWIK KAR LUBE & TUNE O 25.50 1,019.89 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 196.74 1,019.89 ** 8,000.00 Budgeted 6,980.11 Remaining 13 % 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 1500 05/15/2017 May A/P Water samples 2,310.80 225.00 2,535.80 TARRANT CTY PUBLIC HEALTH LAB 3133 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 225.00 2,535.80 ** 5,500.00 Budgeted 2,964.20 Remaining 46 % Used Account: 135-60010-010-000 Communications/Mobiles 1500 05/15/2017 May A/P Cell Phones 2,119.59 346.75 2,466.34 VERIZON WIRELESS 3136 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 346.75 2,466.34 ** 5,400.00 Budgeted 2,933.66 Remaining 46 % Used Account: 135-60020-010-000 Electricity 1500 05/15/2017 May A/P Electricity 4/5-5/9 77,102.51 136.48 77,238.99 HUDSON ENERGY SERVICES, LLC 3117 AP 1525 05/18/2017 May A/P Electricity 4/10-5/10/17 3,786.99 81,025.98 HUDSON ENERGY SERVICES, LLC 3154 AP 1555 05/23/2017 May A/P Electricity 4/10-5/10 9,161.05 90,187.03 HUDSON ENERGY SERVICES, LLC 3154 AP _______________ Account: 135-60020-010-000 Electricity Totals: 13,084.52 90,187.03 ** 172,737.00 Budgeted 82,549.97 Remaining 52 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 767.00 .00 767.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 767.00 ** 750.00 Budgeted (17.00) Remaining 102 % 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 1650 05/26/2017 PCards 4/27-5/26/17 ACT*TWUA - NCT REGION 265.00 300.00 565.00 ACT*TWUA - NCT REGION PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 300.00 565.00 ** 4,222.00 Budgeted 3,657.00 Remaining 13 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 124.46 .00 124.46 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 124.46 ** 1,500.00 Budgeted 1,375.54 Remaining 8 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 21,940.45 .00 21,940.45 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 21,940.45 ** 50,176.00 Budgeted 28,235.55 Remaining 44 % Used Account: 135-60150-010-000 Wholesale Water 1620 05/31/2017 May A/P Wholesale Water 858,983.95 173,823.56 1,032,807.51 CITY OF FORT WORTH 3177 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 173,823.56 1,032,807.51 ** 2,998,802.00 Budgeted 1,965,994.49 Remaining 34 % Used Account: 135-60245-010-000 Miscellaneous Expenses 102.70 .00 102.70 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 102.70 ** 200.00 Budgeted 97.30 Remaining 51 % Used Account: 135-60280-010-000 Property Maintenance 594.60 .00 594.60 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 594.60 ** 5,000.00 Budgeted 4,405.40 Remaining 12 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 3,000.00 .00 3,000.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 3,000.00 ** 14,750.00 Budgeted 11,750.00 Remaining 20 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1550 05/23/2017 Texpool Transfers 153,250.13 21,892.88 175,143.01 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 21,892.88 175,143.01 ** 297,011.00 Budgeted 121,867.99 Remaining 59 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1550 05/23/2017 Texpool Transfers 100,527.00 14,361.00 114,888.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 14,361.00 114,888.00 ** 64,920.00 Budgeted (49,968.00) Remaining 177 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 1620 05/31/2017 May A/P Gas 4,907.17 678.42 5,585.59 US Bank Voyager Fleet Systems 3206 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 678.42 5,585.59 ** 24,828.00 Budgeted 19,242.41 Remaining 22 % Used Account: 135-65010-010-000 Uniforms 1,329.48 .00 1,329.48 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,329.48 ** 4,608.00 Budgeted 3,278.52 Remaining 29 % Used Account: 135-65030-010-000 Chemicals 1555 05/23/2017 May A/P Chlorine 8,896.34 529.71 9,426.05 DPC INDUSTRIES, INC 3148 AP 1620 05/31/2017 May A/P Testing supplies 103.53 9,529.58 HACH COMPANY 3181 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 633.24 9,529.58 ** 20,000.00 Budgeted 10,470.42 Remaining 48 % Used Account: 135-65035-010-000 Small Tools 221.62 .00 221.62 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 221.62 ** 1,200.00 Budgeted 978.38 Remaining 18 % 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 1462 05/02/2017 Void A/P ck 3083/wrong vendor Fireline meter for new town ha 17,069.88 (5,361.62) 11,708.26 ATLAS ENTERPRISES, INC 3083 AP 1499 05/02/2017 May A/P Fire line meter for new town h 5,361.62 17,069.88 ATLAS UTILITY SUPPLY CO. 3104 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 17,069.88 ** 31,500.00 Budgeted 14,430.12 Remaining 54 % Used Account: 135-65053-010-000 Meter Change Out Program 48,264.00 .00 48,264.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 48,264.00 ** 81,500.00 Budgeted 33,236.00 Remaining 59 % Used Account: 135-69005-010-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1526 05/18/2017 May A/P Easement for 16" waterline/FUM 288,560.69 10,000.00 298,560.69 Fellowship United Methodist 3141 AP 1700 05/31/2017 May A/P Retainage 4,309.40 302,870.09 FRYER CONSTRUCTION COMPANY AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 14,309.40 302,870.09 ** 690,422.00 Budgeted 387,551.91 Remaining 44 % 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 126,957.75 .00 126,957.75 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.75 ** 126,958.00 Budgeted .25 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 1500 05/15/2017 May A/P Water samples-PID 895.40 80.00 975.40 TARRANT CTY PUBLIC HEALTH LAB 3133 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 975.40 ** 5,000.00 Budgeted 4,024.60 Remaining 20 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ----------------------------------- 2,337,472.54 ** 265,301.62 Monthly Total 5,524,781.00 Budgeted 3,187,308.46 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 1407 05/05/2017 MUD PR 05/05/17 Salaries & Wages 207,447.34 15,034.07 222,481.41 PR 1512 05/19/2017 Mud PR 05/19/17 Salaries & Wages 14,985.70 237,467.11 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 30,019.77 237,467.11 ** 391,102.00 Budgeted 153,634.89 Remaining 61 % Used Account: 135-50010-020-000 Overtime 1407 05/05/2017 MUD PR 05/05/17 Overtime 19,526.94 736.97 20,263.91 PR 1512 05/19/2017 Mud PR 05/19/17 Overtime 1,021.77 21,285.68 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,758.74 21,285.68 ** 29,500.00 Budgeted 8,214.32 Remaining 72 % Used Account: 135-50016-020-000 Longevity 6,635.00 .00 6,635.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,635.00 ** 6,635.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1407 05/05/2017 MUD PR 05/05/17 Certification 4,225.00 550.00 4,775.00 PR 1512 05/19/2017 Mud PR 05/19/17 Certification 700.00 5,475.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 1,250.00 5,475.00 ** 7,800.00 Budgeted 2,325.00 Remaining 70 % Used Account: 135-50020-020-000 Retirement 1407 05/05/2017 MUD PR 05/05/17 Retirement 21,449.31 1,509.71 22,959.02 PR 1512 05/19/2017 Mud PR 05/19/17 Retirement 1,545.45 24,504.47 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,055.16 24,504.47 ** 39,584.00 Budgeted 15,079.53 Remaining 62 % Used Account: 135-50026-020-000 Medical Insurance 1407 05/05/2017 MUD PR 05/05/17 Medical Insurance 31,584.51 2,355.10 33,939.61 PR 1512 05/19/2017 Mud PR 05/19/17 Medical Insurance 2,355.10 36,294.71 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 36,294.71 ** 73,022.00 Budgeted 36,727.29 Remaining 50 % Used Account: 135-50027-020-000 Dental Insurance 1407 05/05/2017 MUD PR 05/05/17 Dental Insurance 2,467.72 199.69 2,667.41 PR 1512 05/19/2017 Mud PR 05/19/17 Dental Insurance 199.63 2,867.04 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 2,867.04 ** 4,592.00 Budgeted 1,724.96 Remaining 62 % Used Account: 135-50028-020-000 Vision Insurance 1407 05/05/2017 MUD PR 05/05/17 Vision Insurance 532.59 42.19 574.78 PR 1512 05/19/2017 Mud PR 05/19/17 Vision Insurance 42.14 616.92 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 616.92 ** 1,031.00 Budgeted 414.08 Remaining 60 % Used Account: 135-50029-020-000 Life Insurance & Other 1465 05/09/2017 May A/P Dental, Vision,misc ins 2,606.02 356.76 2,962.78 METLIFE GROUP BENEFITS 3127 AP 1525 05/18/2017 May A/P Café 125 Admin fees 27.13 2,989.91 BenefitMall 3144 AP 1555 05/23/2017 May A/P Dental, Vision, Misc. Ins-June 356.76 3,346.67 METLIFE GROUP BENEFITS 3163 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 740.65 3,346.67 ** 4,485.00 Budgeted 1,138.33 Remaining 75 % Used Account: 135-50030-020-000 Social Security Taxes 1407 05/05/2017 MUD PR 05/05/17 Social Security Taxes 13,822.92 955.86 14,778.78 PR 1512 05/19/2017 Mud PR 05/19/17 Social Security Taxes 959.99 15,738.77 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,915.85 15,738.77 ** 27,886.00 Budgeted 12,147.23 Remaining 56 % Used Account: 135-50035-020-000 Medicare Taxes 1407 05/05/2017 MUD PR 05/05/17 Medicare Taxes 3,232.77 223.56 3,456.33 PR 1512 05/19/2017 Mud PR 05/19/17 Medicare Taxes 224.50 3,680.83 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 448.06 3,680.83 ** 6,522.00 Budgeted 2,841.17 Remaining 56 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes 63.00 .00 63.00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 63.00 ** 1,197.00 Budgeted 1,134.00 Remaining 5 % Used Account: 135-50045-020-000 Workman's Compensation 467 05/01/2017 Insurance/Wrk Comp Exp May 6,487.25 926.75 7,414.00 GL 1700 05/31/2017 May A/P TML 3,782.00 11,196.00 TML INTERGOVERNMENTAL RISK 3211 AP _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 4,708.75 11,196.00 ** 11,347.00 Budgeted 151.00 Remaining 99 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1650 05/26/2017 PCards 4/27-5/26/17 CARENOW KELLER 80.00 80.00 CARENOW KELLER PC _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 80.00 80.00 ** 300.00 Budgeted 220.00 Remaining 27 % Used Account: 135-50070-020-000 Employee Relations 1650 05/26/2017 PCards 4/27-5/26/17 HARD 8 BBQ- ROANOKE 325.22 66.40 391.62 HARD 8 BBQ- ROANOKE PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 66.40 391.62 ** 650.00 Budgeted 258.38 Remaining 60 % Used Account: 135-55005-020-000 Engineering 1650 05/26/2017 PCards 4/27-5/26/17 FEDEXOFFICE 00003319 446.64 446.64 FEDEXOFFICE 00003319 PC 1650 05/26/2017 PCards 4/27-5/26/17 FEDEXOFFICE 00003319 405.84 852.48 FEDEXOFFICE 00003319 PC _______________ Account: 135-55005-020-000 Engineering Totals: 852.48 852.48 ** 70,000.00 Budgeted 69,147.52 Remaining 1 % Used Account: 135-55070-020-000 Independent Labor 19,449.39 .00 19,449.39 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 19,449.39 ** 20,000.00 Budgeted 550.61 Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-020-000 Maintenance & Repairs 1650 05/26/2017 PCards 4/27-5/26/17 BATTERIES PLUS # 8 35,474.06 57.95 35,532.01 BATTERIES PLUS # 8 PC 1650 05/26/2017 PCards 4/27-5/26/17 FRYS ELECTRONICS #37 75.99 35,608.00 FRYS ELECTRONICS #37 PC 1650 05/26/2017 PCards 4/27-5/26/17 FRYS ELECTRONICS #37 69.00 35,677.00 FRYS ELECTRONICS #37 PC 1650 05/26/2017 PCards 4/27-5/26/17 THE HOME DEPOT #6581 17.19 35,694.19 THE HOME DEPOT #6581 PC 1650 05/26/2017 PCards 4/27-5/26/17 APPLE STORE #R151 31.39 35,725.58 APPLE STORE #R151 PC 1650 05/26/2017 PCards 4/27-5/26/17 THE HOME DEPOT #6581 138.90 35,864.48 THE HOME DEPOT #6581 PC 1650 05/26/2017 PCards 4/27-5/26/17 THE HOME DEPOT #6581 77.39 35,941.87 THE HOME DEPOT #6581 PC 1650 05/26/2017 PCards 4/27-5/26/17 THE HOME DEPOT #6581 9.98 35,951.85 THE HOME DEPOT #6581 PC 1663 05/31/2017 May A/P Testing supplies 3,084.21 39,036.06 IDEXX DISTRIBUTION, INC 3185 AP 1663 05/31/2017 May A/P Pump #1 LS 9 4,614.00 43,650.06 XYLEM WATER SOLUTIONS USA INC 3208 AP 1663 05/31/2017 May A/P bags 1,185.00 44,835.06 Huber Technology Inc 3183 AP 1663 05/31/2017 May A/P Pump #3 repair 5,238.31 50,073.37 SMITH PUMP COMPANY, INC. 3201 AP 1703 05/31/2017 May A/P Keys for clarifier 11.12 50,084.49 ROANOKE WINNELSON CO. AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 14,610.43 50,084.49 ** 79,700.00 Budgeted 29,615.51 Remaining 63 % Used Account: 135-55085-020-000 Generator Maint. and Repair 1620 05/31/2017 May A/P Generator maintenance 1,566.00 1,566.00 Sluder Emergency Power Service 3200 AP _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: 1,566.00 1,566.00 ** 20,000.00 Budgeted 18,434.00 Remaining 8 % Used Account: 135-55090-020-000 Vehicle Maintenance 1650 05/26/2017 PCards 4/27-5/26/17 MUSTANG ELITE CAR 7,057.53 102.99 7,160.52 MUSTANG ELITE CAR PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 102.99 7,160.52 ** 6,600.00 Budgeted (560.52) Remaining 108 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 23.94 .00 23.94 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 23.94 ** 500.00 Budgeted 476.06 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services 1555 05/23/2017 May A/P Sludge Haul off 30,402.86 4,288.80 34,691.66 L.H. CHANEY MATERIALS, INC. 3159 AP 1703 05/31/2017 May A/P 4,270.63 38,962.29 L.H. CHANEY MATERIALS, INC. AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55125-020-000 Dumpster Services Totals: 8,559.43 38,962.29 ** 55,000.00 Budgeted 16,037.71 Remaining 71 % Used Account: 135-55135-020-000 Lab Analysis 1555 05/23/2017 May A/P Lab supplies 16,321.00 246.00 16,567.00 OXIDOR LABORATORIES LLC 3165 AP 1555 05/23/2017 May A/P labs upplies 176.00 16,743.00 OXIDOR LABORATORIES LLC 3165 AP 1555 05/23/2017 May A/P Lab supplies 246.00 16,989.00 OXIDOR LABORATORIES LLC 3165 AP 1663 05/31/2017 May A/P lab supplies 246.00 17,235.00 OXIDOR LABORATORIES LLC 3197 AP 1663 05/31/2017 May A/P lab supplies 176.00 17,411.00 OXIDOR LABORATORIES LLC 3197 AP 1663 05/31/2017 May A/P Lab supplies 246.00 17,657.00 OXIDOR LABORATORIES LLC 3197 AP 1663 05/31/2017 May A/P Lab supplies 176.00 17,833.00 OXIDOR LABORATORIES LLC 3197 AP 1663 05/31/2017 May A/P 2nd quarter Bio monitoring 1,080.00 18,913.00 HUTHER AND ASSOCIATES,INC 3184 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,592.00 18,913.00 ** 25,000.00 Budgeted 6,087.00 Remaining 76 % Used Account: 135-60010-020-000 Communications/Mobiles 1500 05/15/2017 May A/P Cell Phones 2,844.73 411.68 3,256.41 VERIZON WIRELESS 3136 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 411.68 3,256.41 ** 5,400.00 Budgeted 2,143.59 Remaining 60 % Used Account: 135-60020-020-000 Electricity 1500 05/15/2017 May A/P Electricity 4/7-5/9 76,378.80 2.49 76,381.29 HUDSON ENERGY SERVICES, LLC 3117 AP 1500 05/15/2017 May A/P Electricity 4/7-5/9 92.27 76,473.56 HUDSON ENERGY SERVICES, LLC 3117 AP 1513 05/15/2017 Recode Hudson Dover Ln LS 101.43 76,574.99 GL 1525 05/18/2017 May A/P Electricity 4/10-5/10/17 4,376.66 80,951.65 ENGIE Resources LLC 3149 AP 1555 05/23/2017 May A/P Electricity 4/10-5/10/17 658.95 81,610.60 HUDSON ENERGY SERVICES, LLC 3154 AP 1555 05/23/2017 May A/P Electricity 4/10-5/10/17 7,382.58 88,993.18 HUDSON ENERGY SERVICES, LLC 3154 AP 1555 05/23/2017 May A/P Electricity 4/10-5/10/17 265.79 89,258.97 MP2 ENERGY TEXAS LLC 3164 AP 1680 05/31/2017 Town Billing May Inv 1567-1573 AR 20170501-20170531 User: (140.66) 89,118.31 AR 1700 05/31/2017 May A/P Electricity 4/25-5/24 217.05 89,335.36 TRI COUNTY ELECTRIC AP 1700 05/31/2017 May A/P Electricity 4/25-5/24 369.83 89,705.19 TRI COUNTY ELECTRIC AP 1700 05/31/2017 May A/P Electricity 4/25-5/24 28.04 89,733.23 TRI COUNTY ELECTRIC AP _______________ Account: 135-60020-020-000 Electricity Totals: 13,354.43 89,733.23 ** 158,627.00 Budgeted 68,893.77 Remaining 57 % Used Account: 135-60066-020-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 143.85 .00 143.85 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 143.85 ** 400.00 Budgeted 256.15 Remaining 36 % Used Account: 135-60070-020-000 Dues & Memberships 267.00 .00 267.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 267.00 ** 267.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-020-000 Schools & Training 2,307.81 .00 2,307.81 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 2,307.81 ** 4,195.00 Budgeted 1,887.19 Remaining 55 % Used Account: 135-60090-020-000 Safety Program 282.15 .00 282.15 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 282.15 ** 550.00 Budgeted 267.85 Remaining 51 % Used Account: 135-60100-020-000 Travel & per diem 1663 05/31/2017 May A/P Samples to lab 2,245.50 17.09 2,262.59 NTTA 3196 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 17.09 2,262.59 ** 2,400.00 Budgeted 137.41 Remaining 94 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising 4,086.37 .00 4,086.37 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60125-020-000 Advertising Totals: .00 4,086.37 ** .00 Budgeted (4,086.37) Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 1650 05/26/2017 PCards 4/27-5/26/17 TCEQ IND RENEWAL L 14,565.97 111.00 14,676.97 TCEQ IND RENEWAL L PC _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 111.00 14,676.97 ** 17,150.00 Budgeted 2,473.03 Remaining 86 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 6,621.00 Budgeted 6,621.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 2,360.00 .00 2,360.00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 2,360.00 ** 11,600.00 Budgeted 9,240.00 Remaining 20 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1550 05/23/2017 Texpool Transfers 76,676.74 10,953.82 87,630.56 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,953.82 87,630.56 ** 120,492.00 Budgeted 32,861.44 Remaining 73 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1550 05/23/2017 Texpool Transfers 379,042.37 54,148.91 433,191.28 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,148.91 433,191.28 ** 595,638.00 Budgeted 162,446.72 Remaining 73 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 56,132.70 .00 56,132.70 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 56,132.70 ** 123,492.00 Budgeted 67,359.30 Remaining 45 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 1650 05/26/2017 PCards 4/27-5/26/17 7-ELEVEN 36014 5,074.05 25.50 5,099.55 7-ELEVEN 36014 PC 1620 05/31/2017 May A/P Gas 602.09 5,701.64 US Bank Voyager Fleet Systems 3206 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 627.59 5,701.64 ** 28,088.00 Budgeted 22,386.36 Remaining 20 % Used Account: 135-65010-020-000 Uniforms 3,753.87 .00 3,753.87 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 3,753.87 ** 4,459.00 Budgeted 705.13 Remaining 84 % Used Account: 135-65030-020-000 Chemicals 1555 05/23/2017 May A/P Cehmicals 14,942.29 2,964.66 17,906.95 HARCROS CHEMICALS INC 3152 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,964.66 17,906.95 ** 21,000.00 Budgeted 3,093.05 Remaining 85 % Used Account: 135-65035-020-000 Small Tools 1650 05/26/2017 PCards 4/27-5/26/17 THE HOME DEPOT #6581 1,367.82 37.72 1,405.54 THE HOME DEPOT #6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-020-000 Small Tools Totals: 37.72 1,405.54 ** 2,000.00 Budgeted 594.46 Remaining 70 % Used Account: 135-65040-020-000 Safety Equipment 252.64 .00 252.64 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 252.64 ** 750.00 Budgeted 497.36 Remaining 34 % Used Account: 135-65045-020-000 Lab Supplies 1650 05/26/2017 PCards 4/27-5/26/17 RANDALLS STORE00017897 10,668.77 4.17 10,672.94 RANDALLS STORE00017897 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 4.17 10,672.94 ** 14,000.00 Budgeted 3,327.06 Remaining 76 % Used Account: 135-69005-020-000 Capital Outlays 1555 05/23/2017 May A/P Repair Digestive blower 196,357.40 3,983.21 200,340.61 WALKER ENGINEERING INC 3171 AP 1555 05/23/2017 May A/P Addition to fixed asset 562.50 200,903.11 CP&Y/WALLACE GROUP, INC. 3147 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 4,545.71 200,903.11 ** 462,000.00 Budgeted 261,096.89 Remaining 43 % Used Department 20 Totals: ----------------------------------- 1,443,582.54 ** 164,697.34 Monthly Total 2,671,032.00 Budgeted 1,227,449.46 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 467 05/01/2017 Insurance/Wrk Comp Exp May 18.27 2.61 20.88 GL 1700 05/31/2017 May A/P TML (1.00) 19.88 TML INTERGOVERNMENTAL RISK 3211 AP _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 1.61 19.88 ** 32.00 Budgeted 12.12 Remaining 62 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % 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 2,725.00 .00 2,725.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 2,725.00 ** 4,000.00 Budgeted 1,275.00 Remaining 68 % Used Account: 135-60100-026-000 Travel & per diem 1,819.37 .00 1,819.37 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 1,819.37 ** 5,000.00 Budgeted 3,180.63 Remaining 36 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: ----------------------------------- 4,564.25 ** 1.61 Monthly Total 12,882.00 Budgeted 8,317.75 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 1407 05/05/2017 MUD PR 05/05/17 Salaries & Wages 223,053.65 19,482.47 242,536.12 PR 1512 05/19/2017 Mud PR 05/19/17 Salaries & Wages 19,474.50 262,010.62 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 38,956.97 262,010.62 ** 519,883.00 Budgeted 257,872.38 Remaining 50 % Used Account: 135-50010-030-000 Overtime 1407 05/05/2017 MUD PR 05/05/17 Overtime 3,193.23 10.51 3,203.74 PR 1512 05/19/2017 Mud PR 05/19/17 Overtime 43.45 3,247.19 PR _______________ Account: 135-50010-030-000 Overtime Totals: 53.96 3,247.19 ** 2,500.00 Budgeted (747.19) Remaining 130 % Used Account: 135-50016-030-000 Longevity 3,417.50 .00 3,417.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,417.50 ** 3,417.00 Budgeted (.50) Remaining 100 % Used Account: 135-50020-030-000 Retirement 1407 05/05/2017 MUD PR 05/05/17 Retirement 20,547.77 1,803.11 22,350.88 PR 1512 05/19/2017 Mud PR 05/19/17 Retirement 1,805.42 24,156.30 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,608.53 24,156.30 ** 47,768.00 Budgeted 23,611.70 Remaining 51 % Used Account: 135-50026-030-000 Medical Insurance 1585 05/02/2017 Aetna May premium ACH pmt 25,051.23 .05 25,051.28 GL 1407 05/05/2017 MUD PR 05/05/17 Medical Insurance 2,275.98 27,327.26 PR 1512 05/19/2017 Mud PR 05/19/17 Medical Insurance 2,275.99 29,603.25 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,552.02 29,603.25 ** 84,289.00 Budgeted 54,685.75 Remaining 35 % Used Account: 135-50027-030-000 Dental Insurance 1407 05/05/2017 MUD PR 05/05/17 Dental Insurance 2,169.78 208.44 2,378.22 PR 1512 05/19/2017 Mud PR 05/19/17 Dental Insurance 208.37 2,586.59 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 416.81 2,586.59 ** 5,981.00 Budgeted 3,394.41 Remaining 43 % Used Account: 135-50028-030-000 Vision Insurance 1407 05/05/2017 MUD PR 05/05/17 Vision Insurance 464.25 44.45 508.70 PR 1512 05/19/2017 Mud PR 05/19/17 Vision Insurance 44.39 553.09 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 88.84 553.09 ** 1,312.00 Budgeted 758.91 Remaining 42 % Used Account: 135-50029-030-000 Life Insurance & Other 1465 05/09/2017 May A/P Dental, Vision,misc ins 2,420.55 421.55 2,842.10 METLIFE GROUP BENEFITS 3127 AP 1525 05/18/2017 May A/P Café 125 Admin fees 33.16 2,875.26 BenefitMall 3144 AP 1531 05/19/2017 May A/P Rounding adjustment (.02) 2,875.24 Legal Shield 3160 AP 1555 05/23/2017 May A/P Dental, Vision, Misc. Ins-June 421.55 3,296.79 METLIFE GROUP BENEFITS 3163 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 876.24 3,296.79 ** 5,890.00 Budgeted 2,593.21 Remaining 56 % Used Account: 135-50030-030-000 Social Security Taxes 1407 05/05/2017 MUD PR 05/05/17 Social Security Taxes 13,481.48 1,159.23 14,640.71 PR 1512 05/19/2017 Mud PR 05/19/17 Social Security Taxes 1,147.91 15,788.62 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,307.14 15,788.62 ** 32,777.00 Budgeted 16,988.38 Remaining 48 % Used Account: 135-50035-030-000 Medicare Taxes 1407 05/05/2017 MUD PR 05/05/17 Medicare Taxes 3,152.92 271.11 3,424.03 PR 1512 05/19/2017 Mud PR 05/19/17 Medicare Taxes 268.46 3,692.49 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 539.57 3,692.49 ** 8,084.00 Budgeted 4,391.51 Remaining 46 % Used Account: 135-50040-030-000 Unemployment Taxes 293.73 .00 293.73 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 293.73 ** 1,368.00 Budgeted 1,074.27 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 467 05/01/2017 Insurance/Wrk Comp Exp May 1,018.71 145.53 1,164.24 GL 1700 05/31/2017 May A/P TML 50.00 1,214.24 TML INTERGOVERNMENTAL RISK 3211 AP _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 195.53 1,214.24 ** 1,784.00 Budgeted 569.76 Remaining 68 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 402.35 .00 402.35 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 402.35 ** 500.00 Budgeted 97.65 Remaining 80 % Used Account: 135-50070-030-000 Employee Relations 1650 05/26/2017 PCards 4/27-5/26/17 USPS PO 4876450662 2,583.46 2.95 2,586.41 USPS PO 4876450662 PC 1650 05/26/2017 PCards 4/27-5/26/17 TOM THUMB STOR00036251 18.99 2,605.40 TOM THUMB STOR00036251 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 21.94 2,605.40 ** 4,960.00 Budgeted 2,354.60 Remaining 53 % Used Account: 135-55030-030-000 Software & Support 1500 05/15/2017 May A/P Internet 65,920.45 1,036.77 66,957.22 WHOLESALE CARRIER SERVICES INC 3139 AP 1525 05/18/2017 May A/P Ofc 365 license. 168.00 67,125.22 M3 Networks 3161 AP 1650 05/26/2017 PCards 4/27-5/26/17 CONWAY COMPANY CPAS 595.00 67,720.22 CONWAY COMPANY CPAS PC 1650 05/26/2017 PCards 4/27-5/26/17 ADOBE *IL CREATIVE CLD 19.99 67,740.21 ADOBE *IL CREATIVE CLD PC 1650 05/26/2017 PCards 4/27-5/26/17 DNH*GODADDY.COM 15.17 67,755.38 DNH*GODADDY.COM PC 1650 05/26/2017 PCards 4/27-5/26/17 ATT*BILL PAYMENT 110.98 67,866.36 ATT*BILL PAYMENT PC 1650 05/26/2017 PCards 4/27-5/26/17 ATT*BILL PAYMENT 127.30 67,993.66 ATT*BILL PAYMENT PC 1650 05/26/2017 PCards 4/27-5/26/17 AT&T *PAYMENT 586.38 68,580.04 AT&T *PAYMENT PC 1703 05/31/2017 May A/P Document Mgmt System 8,360.00 76,940.04 MCCI AP _______________ Account: 135-55030-030-000 Software & Support Totals: 11,019.59 76,940.04 ** 77,791.00 Budgeted 850.96 Remaining 99 % Used Account: 135-55070-030-000 Independent Labor 932.50 .00 932.50 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 932.50 ** 4,000.00 Budgeted 3,067.50 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Maintenance & Repairs 1555 05/23/2017 May A/P Building AC Repair 275.00 265.00 540.00 BRANDON R REED 3145 AP 1620 05/31/2017 May A/P Mun bldg. damper installed 151.00 691.00 BRANDON R REED 3175 AP 1620 05/31/2017 May A/P AC work @ mud bldg 135.00 826.00 BRANDON R REED 3175 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 551.00 826.00 ** 2,000.00 Budgeted 1,174.00 Remaining 41 % Used Account: 135-55085-030-000 Generator Maint. and Repair 485.00 .00 485.00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 485.00 ** 10,000.00 Budgeted 9,515.00 Remaining 5 % Used Account: 135-55100-030-000 Building Maint & Supplies 1500 05/15/2017 May A/P Rug Service 5,674.55 66.47 5,741.02 G & K SERVICES 3115 AP 1583 05/25/2017 May A/P Rug service 66.47 5,807.49 G & K SERVICES 3151 AP 1680 05/31/2017 Town Billing May Inv 1567-1573 AR 20170501-20170531 User: (263.97) 5,543.52 AR 1703 05/31/2017 May A/P Server room A/C 395.00 5,938.52 BRANDON R REED AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 263.97 5,938.52 ** 7,000.00 Budgeted 1,061.48 Remaining 85 % Used Account: 135-55120-030-000 Cleaning Services 1555 05/23/2017 May A/P Cleaning Services 3,539.36 869.06 4,408.42 MEMBER'S BUILDING MAINTENANCE 3162 AP 1680 05/31/2017 Town Billing May Inv 1567-1573 AR 20170501-20170531 User: (236.00) 4,172.42 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 4,172.42 ** 8,000.00 Budgeted 3,827.58 Remaining 52 % Used Account: 135-55160-030-000 Professional Outside Services 57,332.00 .00 57,332.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 57,332.00 ** 60,000.00 Budgeted 2,668.00 Remaining 96 % Used Account: 135-55165-030-000 Collection Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 1667 05/31/2017 May A/P May Billing 4,412.54 593.10 5,005.64 DATAPROSE LLC 3179 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 593.10 5,005.64 ** 8,200.00 Budgeted 3,194.36 Remaining 61 % Used Account: 135-60005-030-000 Telephone 1525 05/18/2017 May A/P answering service 6,702.71 194.75 6,897.46 KEYSTONE PARK SECRETARIAL 3157 AP 1650 05/26/2017 PCards 4/27-5/26/17 RINGCENTRAL, INC 13.95 6,911.41 RINGCENTRAL, INC PC 1650 05/26/2017 PCards 4/27-5/26/17 ATT*BUS PHONE PMT 892.73 7,804.14 ATT*BUS PHONE PMT PC 1650 05/26/2017 PCards 4/27-5/26/17 ATT*BUS PHONE PMT 1,694.80 9,498.94 ATT*BUS PHONE PMT PC 1650 05/26/2017 PCards 4/27-5/26/17 AT&T *PAYMENT 683.04 10,181.98 AT&T *PAYMENT PC 1680 05/31/2017 Town Billing May Inv 1567-1573 AR 20170501-20170531 User: (909.19) 9,272.79 AR _______________ Account: 135-60005-030-000 Telephone Totals: 2,570.08 9,272.79 ** 17,532.00 Budgeted 8,259.21 Remaining 53 % Used Account: 135-60010-030-000 Communications/Mobiles 1500 05/15/2017 May A/P Cell Phones 1,802.94 37.99 1,840.93 VERIZON WIRELESS 3136 AP 1512 05/19/2017 Mud PR 05/19/17 Communications/Mobiles 300.00 2,140.93 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 2,140.93 ** 3,500.00 Budgeted 1,359.07 Remaining 61 % Used Account: 135-60020-030-000 Electricity/Gas 1500 05/15/2017 May A/P Electricity 4/10-5/10 882.09 101.43 983.52 HUDSON ENERGY SERVICES, LLC 3117 AP 1513 05/15/2017 Recode Hudson Dover Ln LS (101.43) 882.09 GL _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 882.09 ** 12,631.00 Budgeted 11,748.91 Remaining 7 % Used Account: 135-60025-030-000 Water 1583 05/25/2017 May A/P April Water 528.75 192.64 721.39 TROPHY CLUB MUD (WATER BILLS) 3169 AP 1663 05/31/2017 May A/P Water 113.49 834.88 TROPHY CLUB MUD (WATER BILLS) 3204 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1680 05/31/2017 Town Billing May Inv 1567-1573 AR 20170501-20170531 User: 528.75 (56.74) 778.14 AR _______________ Account: 135-60025-030-000 Water Totals: 249.39 778.14 ** 1,500.00 Budgeted 721.86 Remaining 52 % Used Account: 135-60035-030-000 Postage 1526 05/18/2017 May A/P Wise Guys Top 500 mailing 16,836.22 148.20 16,984.42 U.S. POSTAL SERVICE 3142 AP 1667 05/31/2017 May A/P May Billing 1,751.65 18,736.07 DATAPROSE LLC 3179 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,899.85 18,736.07 ** 28,932.00 Budgeted 10,195.93 Remaining 65 % Used Account: 135-60040-030-000 Service Charges & Fees 1574 05/03/2017 Credit card fees 28,767.41 3,654.63 32,422.04 GL 1574 05/03/2017 Credit card fees 89.51 32,511.55 GL 1412 05/05/2017 Child Support Fee 1.50 32,513.05 GL 1514 05/19/2017 Child Support Fee 1.50 32,514.55 GL 1583 05/25/2017 May A/P Direct send fees 50.00 32,564.55 Fiserv Solutions, LLC 3150 AP 1678 05/31/2017 May A/P Direct send fees 50.00 32,614.55 Fiserv Solutions, LLC 3209 AP 1700 05/31/2017 May A/P Direct send fees 250.00 32,864.55 Fiserv Solutions, LLC AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,097.14 32,864.55 ** 55,560.00 Budgeted 22,695.45 Remaining 59 % Used Account: 135-60050-030-000 Bad Debt Expense 526.88 .00 526.88 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 526.88 ** 3,500.00 Budgeted 2,973.12 Remaining 15 % Used Account: 135-60055-030-000 Insurance 467 05/01/2017 Insurance/Wrk Comp Exp May 32,651.92 4,664.56 37,316.48 GL 1700 05/31/2017 May A/P TML (107.80) 37,208.68 TML INTERGOVERNMENTAL RISK 3211 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,556.76 37,208.68 ** 55,692.00 Budgeted 18,483.32 Remaining 67 % Used Account: 135-60066-030-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 311.88 .00 311.88 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 311.88 ** 1,600.00 Budgeted 1,288.12 Remaining 19 % Used Account: 135-60070-030-000 Dues & Memberships 4,336.25 .00 4,336.25 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,336.25 ** 6,000.00 Budgeted 1,663.75 Remaining 72 % Used Account: 135-60075-030-000 Meetings 1650 05/26/2017 PCards 4/27-5/26/17 VINNYS ITALIAN RESTAUR 52.50 52.50 VINNYS ITALIAN RESTAUR PC _______________ Account: 135-60075-030-000 Meetings Totals: 52.50 52.50 ** 400.00 Budgeted 347.50 Remaining 13 % Used Account: 135-60079-030-000 Public Education 1650 05/26/2017 PCards 4/27-5/26/17 RANDALLS STORE00017897 4,853.34 18.98 4,872.32 RANDALLS STORE00017897 PC _______________ Account: 135-60079-030-000 Public Education Totals: 18.98 4,872.32 ** 8,754.00 Budgeted 3,881.68 Remaining 56 % Used Account: 135-60080-030-000 Schools & Training 1409 05/03/2017 May A/P STW conference-Steven Krolczyk 675.00 400.00 1,075.00 STW INC 3101 AP 1409 05/03/2017 May A/P STW conference-Shane Jeff 400.00 1,475.00 STW INC 3101 AP 1409 05/03/2017 May A/P STW conference-Jana Wright 200.00 1,675.00 STW INC 3101 AP _______________ Account: 135-60080-030-000 Schools & Training Totals: 1,000.00 1,675.00 ** 7,840.00 Budgeted 6,165.00 Remaining 21 % Used Account: 135-60100-030-000 Travel & per diem 1407 05/05/2017 MUD PR 05/05/17 Travel & per diem 6,892.47 39.80 6,932.27 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 39.80 6,932.27 ** 7,500.00 Budgeted 567.73 Remaining 92 % Used Account: 135-60110-030-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 1525 05/18/2017 May A/P May election 542.95 888.00 1,430.95 TARRANT COUNTY ELECTIONS ADMIN 3166 AP 1620 05/31/2017 May A/P Election 1,391.72 2,822.67 DENTON COUNTY ELECTIONS 3180 AP _______________ Account: 135-60115-030-000 Elections Totals: 2,279.72 2,822.67 ** 7,500.00 Budgeted 4,677.33 Remaining 38 % Used Account: 135-60125-030-000 Advertising 1650 05/26/2017 PCards 4/27-5/26/17 FORT WORTH STAR TELEG 1,100.09 299.00 1,399.09 FORT WORTH STAR TELEG PC 1650 05/26/2017 PCards 4/27-5/26/17 FORT WORTH STAR TELEG 299.00 1,698.09 FORT WORTH STAR TELEG PC _______________ Account: 135-60125-030-000 Advertising Totals: 598.00 1,698.09 ** 7,500.00 Budgeted 5,801.91 Remaining 23 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 76.00 .00 76.00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 76.00 ** 17,500.00 Budgeted 17,424.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1,040.00 .00 1,040.00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 1,040.00 ** 2,500.00 Budgeted 1,460.00 Remaining 42 % Used Account: 135-65010-030-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 142.36 .00 142.36 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 142.36 ** 855.00 Budgeted 712.64 Remaining 17 % Used Account: 135-65055-030-000 Hardware 1650 05/26/2017 PCards 4/27-5/26/17 AMAZON.COM 2,264.88 35.32 2,300.20 AMAZON.COM PC _______________ Account: 135-65055-030-000 Hardware Totals: 35.32 2,300.20 ** 9,444.00 Budgeted 7,143.80 Remaining 24 % Used Account: 135-65085-030-000 Office Supplies 1500 05/15/2017 May A/P Office supplies 3,792.80 88.27 3,881.07 OFFICE DEPOT, INC 3129 AP 1500 05/15/2017 May A/P Office supplies 32.04 3,913.11 OFFICE DEPOT, INC 3129 AP 1500 05/15/2017 May A/P Office supplies 48.22 3,961.33 OFFICE DEPOT, INC 3129 AP 1650 05/26/2017 PCards 4/27-5/26/17 DESKTOP SUPPLIES.COM 54.13 4,015.46 DESKTOP SUPPLIES.COM PC 1650 05/26/2017 PCards 4/27-5/26/17 STAPLES DIRECT 62.71 4,078.17 STAPLES DIRECT PC 1650 05/26/2017 PCards 4/27-5/26/17 CARBONLESS FORMS PRINT 89.00 4,167.17 CARBONLESS FORMS PRINT PC 1650 05/26/2017 PCards 4/27-5/26/17 DESKTOP SUPPLIES.COM 34.45 4,201.62 DESKTOP SUPPLIES.COM PC 1650 05/26/2017 PCards 4/27-5/26/17 WALMART.COM 34.69 4,236.31 WALMART.COM PC 1664 05/26/2017 May A/P Transaction MW not on download 19.47 4,255.78 JPMORGAN CHASE BANK NA 3210 AP 1700 05/31/2017 May A/P Office supplies 65.09 4,320.87 OFFICE DEPOT, INC AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 528.07 4,320.87 ** 9,000.00 Budgeted 4,679.13 Remaining 48 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 478.78 .00 478.78 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 478.78 ** 2,000.00 Budgeted 1,521.22 Remaining 24 % Used Account: 135-65095-030-000 Maintenance Supplies 1650 05/26/2017 PCards 4/27-5/26/17 WAL-MART #5247 1,594.32 22.73 1,617.05 WAL-MART #5247 PC 1650 05/26/2017 PCards 4/27-5/26/17 AMAZON MKTPLACE PMTS 58.87 1,675.92 AMAZON MKTPLACE PMTS PC 1650 05/26/2017 PCards 4/27-5/26/17 SAMSCLUB.COM 48.76 1,724.68 SAMSCLUB.COM PC 1650 05/26/2017 PCards 4/27-5/26/17 SAMS CLUB #6781 40.05 1,764.73 SAMS CLUB #6781 PC 1650 05/26/2017 PCards 4/27-5/26/17 AMAZON MKTPLACE PMTS 63.60 1,828.33 AMAZON MKTPLACE PMTS PC 1650 05/26/2017 PCards 4/27-5/26/17 AMAZON MKTPLACE PMTS 152.35 1,980.68 AMAZON MKTPLACE PMTS PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1650 05/26/2017 PCards 4/27-5/26/17 SAMSCLUB.COM 1,594.32 198.91 2,179.59 SAMSCLUB.COM PC 1650 05/26/2017 PCards 4/27-5/26/17 AMAZON MKTPLACE PMTS 50.79 2,230.38 AMAZON MKTPLACE PMTS PC 1650 05/26/2017 PCards 4/27-5/26/17 AMAZON MKTPLACE PMTS 91.76 2,322.14 AMAZON MKTPLACE PMTS PC 1650 05/26/2017 PCards 4/27-5/26/17 AMAZON MKTPLACE PMTS 61.60 2,383.74 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 789.42 2,383.74 ** 4,000.00 Budgeted 1,616.26 Remaining 60 % Used Account: 135-65105-030-000 Printing 1667 05/31/2017 May A/P May Billing 488.00 58.77 546.77 DATAPROSE LLC 3179 AP _______________ Account: 135-65105-030-000 Printing Totals: 58.77 546.77 ** 2,500.00 Budgeted 1,953.23 Remaining 22 % Used Account: 135-69005-030-000 Capital Outlays 1409 05/03/2017 May A/P Restroom remodel 14,445.45 93,748.00 108,193.45 AAA Time Saver Services 3098 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 93,748.00 108,193.45 ** 265,424.00 Budgeted 157,230.55 Remaining 41 % Used Account: 135-69170-030-000 Copier Lease Installments 1500 05/15/2017 May A/P Internet 2,334.08 165.00 2,499.08 EVERBANK COMMERCIAL FINANCE 3114 AP 1583 05/25/2017 May A/P Copies 105.25 2,604.33 KYOCERA DOCUMENT SOLUTIONS 3158 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 270.25 2,604.33 ** 4,600.00 Budgeted 1,995.67 Remaining 57 % Used Department 30 Totals: ----------------------------------- 751,697.89 ** 177,808.31 Monthly Total 1,443,018.00 Budgeted 691,320.11 Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 1500 05/15/2017 May A/P Legal 38,127.01 810.00 38,937.01 McLean & Howard, L.L.P. 3126 AP _______________ Account: 135-55045-039-000 Legal Totals: 810.00 38,937.01 ** 150,000.00 Budgeted 111,062.99 Remaining 26 % Used Account: 135-55055-039-000 Auditing 18,808.92 .00 18,808.92 _______________ Account: 135-55055-039-000 Auditing Totals: .00 18,808.92 ** 23,860.00 Budgeted 5,051.08 Remaining 79 % Used Account: 135-55060-039-000 Appraisal 6,621.58 .00 6,621.58 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,621.58 ** 11,115.00 Budgeted 4,493.42 Remaining 60 % Used Account: 135-55065-039-000 Tax Admin Fees 2,561.76 .00 2,561.76 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,561.76 ** 3,800.00 Budgeted 1,238.24 Remaining 67 % Used Department 39 Totals: ----------------------------------- 66,929.27 ** 810.00 Monthly Total 188,775.00 Budgeted 121,845.73 Remaining 35 % Used Fund 135 Totals: ----------------------------------- (411,780.10) (217,835.40) Monthly Total .00 Budgeted 411,780.10 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,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: ----------------------------------- (156,420.00) ** .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (156,420.00) .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET MAY 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 2,861,456 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,861,456 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 691,249 TOTAL LIABILITIES 691,249 FUND BALANCE ASSIGNED FUND BALANCE 4,433,035 NET REVENUES / EXPENDITURES (2,262,828) TOTAL FUND BALANCE 2,170,207 TOTAL LIABILITIES AND FUND BALANCE 2,861,456 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 14:15 06/12/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 2,477.27- 13,636.36- 13,636.36 Subtotal: 2,477.27- 13,636.36- 13,636.36 Program number: 2,477.27- 13,636.36- 13,636.36 Department number: Revenues 2,477.27- 13,636.36- 13,636.36 Revenues Subtotal ----------- 2,477.27- 13,636.36- 13,636.36 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 14:15 06/12/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 775,503.06 2,276,464.77 2,276,464.77- Subtotal: 775,503.06 2,276,464.77 2,276,464.77- Program number: 775,503.06 2,276,464.77 2,276,464.77- Department number: Wastewater 775,503.06 2,276,464.77 2,276,464.77- Expenditures Subtotal ----------- 775,503.06 2,276,464.77 2,276,464.77- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 773,025.79 2,262,828.41 2,262,828.41- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 1690 05/31/2017 Close 518 Retainage into 517 (11,159.09) (590.72) (11,749.81) GL 1691 05/31/2017 Bank Interest/May Tax Bond Construction (1,886.55) (13,636.36) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (2,477.27) (13,636.36) ** .00 Budgeted 13,636.36 Remaining 0 % Used Department Totals: ----------------------------------- (13,636.36) ** (2,477.27) Monthly Total .00 Budgeted 13,636.36 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 1500 05/15/2017 May A/P WWTP Improvements 1,500,961.71 41,832.68 1,542,794.39 CP&Y/WALLACE GROUP, INC. 3110 AP 1690 05/31/2017 Close 518 Retainage into 517 733,670.38 2,276,464.77 GL _______________ Account: 517-69005-020-000 Capital Outlays Totals: 775,503.06 2,276,464.77 ** .00 Budgeted (2,276,464.77) Remaining 0 % Used Department 20 Totals: ----------------------------------- 2,276,464.77 ** 775,503.06 Monthly Total .00 Budgeted (2,276,464.77) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 2,262,828.41 773,025.79 Monthly Total .00 Budgeted (2,262,828.41) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET APRIL 2017 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE - TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 14:15 06/12/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 590.72 Subtotal: 590.72 Program number: 590.72 Department number: Revenues 590.72 Revenues Subtotal ----------- 590.72 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 14:15 06/12/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 733,670.38- Subtotal: 733,670.38- Program number: 733,670.38- Department number: Wastewater 733,670.38- Expenditures Subtotal ----------- 733,670.38- Fund number: 518 2015 Revenue Bond Const Fund 733,079.66- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 1690 05/31/2017 Close 518 Retainage into 517 (590.72) 590.72 .00 GL _______________ Account: 518-49010-000-000 Interest Income Totals: 590.72 .00 ** .00 Budgeted .00 Remaining 0 % Used Department Totals: ----------------------------------- .00 ** 590.72 Monthly Total .00 Budgeted .00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-69005-020-000 Capital Outlays 1690 05/31/2017 Close 518 Retainage into 517 733,670.38 (733,670.38) .00 GL _______________ Account: 518-69005-020-000 Capital Outlays Totals: (733,670.38) .00 ** .00 Budgeted .00 Remaining 0 % Used Department 20 Totals: ----------------------------------- .00 ** (733,670.38) Monthly Total .00 Budgeted .00 Remaining 0 % Used Fund 518 Totals: ----------------------------------- .00 (733,079.66) Monthly Total .00 Budgeted .00 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET MAY 2017 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 543 TOTAL LIABILITIES 543 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES (543) TOTAL FUND BALANCE (543) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 14:15 06/12/17 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60245-020-000 Miscellaneous Expense 542.95 542.95- Subtotal: 542.95 542.95- Program number: 542.95 542.95- Department number: Wastewater 542.95 542.95- Expenditures Subtotal ----------- 542.95 542.95- Fund number: 519 2016 Rev Bond Const-SWIFT 542.95 542.95- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-60245-020-000 Miscellaneous Expense 542.95 .00 542.95 _______________ Account: 519-60245-020-000 Miscellaneous Expense Totals: .00 542.95 ** .00 Budgeted (542.95) Remaining 0 % Used Department 20 Totals: ----------------------------------- 542.95 ** .00 Monthly Total .00 Budgeted (542.95) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 542.95 .00 Monthly Total .00 Budgeted (542.95) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 252,758 ACCOUNTS RECEIVABLE - TOTAL ASSETS 252,758 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 56,996 TOTAL FUND BALANCE 252,758 TOTAL LIABILITIES AND FUND BALANCE 252,758 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 14:15 06/12/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 300.00- 300.00- 164.96- 863.57- 287.857 563.57 528-49142-000-000 Interfund transfer in-Water 64,920.00- 64,920.00- 64,920.00- 528-49143-000-000 Interfund transfer in-WW 123,492.00- 123,492.00- 56,132.70- 45.455 67,359.30- Subtotal: 188,712.00- 188,712.00- 164.96- 56,996.27- 30.203 131,715.73- Program number: 188,712.00- 188,712.00- 164.96- 56,996.27- 30.203 131,715.73- Department number: 188,712.00- 188,712.00- 164.96- 56,996.27- 30.203 131,715.73- Revenues Subtotal ----------- 188,712.00- 188,712.00- 164.96- 56,996.27- 30.203 131,715.73- Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 164.96- 56,996.27- 30.203 131,715.73- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 1691 05/31/2017 Bank Interest/May Revenue Bond Reserve WWTP (698.61) (164.96) (863.57) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (164.96) (863.57) ** (300.00) Budgeted 563.57 Remaining 288 % Used Account: 528-49142-000-000 Interfund transfer in-Water .00 .00 _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: .00 .00 ** (64,920.00) Budgeted (64,920.00) Remaining 0 % Used Account: 528-49143-000-000 Interfund transfer in-WW (56,132.70) .00 (56,132.70) _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: .00 (56,132.70) ** (123,492.00) Budgeted (67,359.30) Remaining 45 % Used Department Totals: ----------------------------------- (56,996.27) ** (164.96) Monthly Total (188,712.00) Budgeted (131,715.73) Remaining 30 % Used Fund 528 Totals: ----------------------------------- (56,996.27) (164.96) Monthly Total (188,712.00) Budgeted (131,715.73) Remaining 30 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND RESERVE BALANCE SHEET May 2017 529 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 115,099 ACCOUNTS RECEIVABLE - TOTAL ASSETS 115,099 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 115,099 TOTAL FUND BALANCE 115,099 TOTAL LIABILITIES AND FUND BALANCE 115,099 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 14:15 06/12/17 Budget Summary with Amendment Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 529-49010-000-000 Interest Income 68.53- 211.05- 211.05 529-49142-000-000 Interfund transfer in-Water 14,361.00- 114,888.00- 114,888.00 Subtotal: 14,429.53- 115,099.05- 115,099.05 Program number: 14,429.53- 115,099.05- 115,099.05 Department number: 14,429.53- 115,099.05- 115,099.05 Revenues Subtotal ----------- 14,429.53- 115,099.05- 115,099.05 Fund number: 529 2016 Rev Bond Reserve-SWIFT 14,429.53- 115,099.05- 115,099.05 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 529-49010-000-000 Interest Income 1691 05/31/2017 Bank Interest/May Revenue Bond Reserve SWIFT (142.52) (68.53) (211.05) GL _______________ Account: 529-49010-000-000 Interest Income Totals: (68.53) (211.05) ** .00 Budgeted 211.05 Remaining 0 % Used Account: 529-49142-000-000 Interfund transfer in-Water 1550 05/23/2017 Texpool Transfers (100,527.00) (14,361.00) (114,888.00) GL _______________ Account: 529-49142-000-000 Interfund transfer in-Water Totals: (14,361.00) (114,888.00) ** .00 Budgeted 114,888.00 Remaining 0 % Used Department Totals: ----------------------------------- (115,099.05) ** (14,429.53) Monthly Total .00 Budgeted 115,099.05 Remaining 0 % Used Fund 529 Totals: ----------------------------------- (115,099.05) (14,429.53) Monthly Total .00 Budgeted 115,099.05 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET MAY 2017 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 845,294 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 17,830 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 867,970 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 17,830 ACCOUNTS AND OTHER PAYABLES 273 TOTAL LIABILITIES 18,103 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 823,836 TOTAL FUND BALANCE 849,867 TOTAL LIABILITIES AND FUND BALANCE 867,970 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 14:15 06/12/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 673,336.00- 673,336.00- 3,514.74- 666,577.26- 98.996 6,758.74- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 176.73- 1,423.38- 40.656 2,077.62- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 284.13- 1,561.36- 78.068 438.64- Subtotal: 678,837.00- 678,837.00- 3,975.60- 669,562.00- 98.634 9,275.00- 533-49010-000-000 Interest Income 140.00- 140.00- 403.58- 1,630.76- 1,164.829 1,490.76 533-49015-000-000 Lease/Rental Income 216,754.00- 216,754.00- 216,754.00- 216,754.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 120,492.00- 120,492.00- 10,953.82- 87,630.56- 72.727 32,861.44- Subtotal: 337,386.00- 337,386.00- 228,111.40- 306,015.32- 90.702 31,370.68- Program number: 1,016,223.00- 1,016,223.00- 232,087.00- 975,577.32- 96.000 40,645.68- Department number: Revenues 1,016,223.00- 1,016,223.00- 232,087.00- 975,577.32- 96.000 40,645.68- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 232,087.00- 975,577.32- 96.000 40,645.68- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 14:15 06/12/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 1,250.00 49.020 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 300,583.00 300,583.00 150,491.25 50.066 150,091.75 533-70035-051-000 Bond Principal Payment-Tax 710,000.00 710,000.00 710,000.00 Subtotal: 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Program number: 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Department number: Administration 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Expenditures Subtotal ----------- 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Fund number: 533 MUD 1 I&S Consolidated 3,090.00- 3,090.00- 232,087.00- 823,836.07- ############### 820,746.07 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1558 05/01/2017 Property Taxes (663,062.52) (5.32) (663,067.84) GL 1559 05/02/2017 Property Taxes (756.47) (663,824.31) GL 1560 05/03/2017 Property Taxes (131.59) (663,955.90) GL 1561 05/04/2017 Property Taxes (57.72) (664,013.62) GL 1562 05/05/2017 Property Taxes (165.49) (664,179.11) GL 1563 05/06/2017 Property Taxes (12.87) (664,191.98) GL 1564 05/12/2017 Property Taxes (161.89) (664,353.87) GL 1566 05/16/2017 Property Taxes (30.60) (664,384.47) GL 1567 05/17/2017 Property Taxes (492.49) (664,876.96) GL 1568 05/18/2017 Property Taxes (24.22) (664,901.18) GL 1569 05/19/2017 Property Taxes (378.50) (665,279.68) GL 1576 05/22/2017 Property Taxes (493.87) (665,773.55) GL 1593 05/23/2017 Property Taxes (232.62) (666,006.17) GL 1596 05/24/2017 Property Taxes (3.29) (666,009.46) GL 1597 05/25/2017 Property Taxes (134.25) (666,143.71) GL 1608 05/26/2017 Property Taxes (67.18) (666,210.89) GL 1651 05/31/2017 Property Taxes (366.37) (666,577.26) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (3,514.74) (666,577.26) ** (673,336.00) Budgeted (6,758.74) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1558 05/01/2017 Property Taxes (1,246.65) (3.59) (1,250.24) GL 1565 05/15/2017 Property Taxes (173.14) (1,423.38) GL 1569 05/19/2017 Property Taxes (62.79) (1,486.17) GL 1593 05/23/2017 Property Taxes 62.79 (1,423.38) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (176.73) (1,423.38) ** (3,501.00) Budgeted (2,077.62) Remaining 41 % Used Account: 533-40015-000-000 Property Taxes/P & I 1558 05/01/2017 Property Taxes (1,277.23) (1.88) (1,279.11) GL 1559 05/02/2017 Property Taxes (83.21) (1,362.32) GL 1560 05/03/2017 Property Taxes (14.48) (1,376.80) GL 1561 05/04/2017 Property Taxes (6.35) (1,383.15) GL 1562 05/05/2017 Property Taxes (18.21) (1,401.36) GL 1563 05/06/2017 Property Taxes (1.67) (1,403.03) GL 1564 05/12/2017 Property Taxes (13.52) (1,416.55) GL 1565 05/15/2017 Property Taxes (70.49) (1,487.04) GL 1567 05/17/2017 Property Taxes (7.23) (1,494.27) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1576 05/22/2017 Property Taxes (1,277.23) (44.24) (1,538.51) GL 1596 05/24/2017 Property Taxes (.36) (1,538.87) GL 1655 05/24/2017 Property Taxes (273.70) (1,812.57) GL 1597 05/25/2017 Property Taxes (5.26) (1,817.83) GL 1651 05/31/2017 Property Taxes (16.23) (1,834.06) GL 1687 05/31/2017 May A/P FKA MUD2 Tax Refund Shortage 273.70 (1,560.36) DENTON COUNTY TAX OFFICE AP 1699 05/31/2017 Bank Rec Adj-M1 I&S (1.00) (1,561.36) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (284.13) (1,561.36) ** (2,000.00) Budgeted (438.64) Remaining 78 % Used Account: 533-49010-000-000 Interest Income 1691 05/31/2017 Bank Interest/May Texpool I&S (1,227.18) (403.58) (1,630.76) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (403.58) (1,630.76) ** (140.00) Budgeted 1,490.76 Remaining 1.165 % Used Account: 533-49015-000-000 Lease/Rental Income 1625 05/31/2017 Texpool Transfer-FD Rent (216,754.00) (216,754.00) GL _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: (216,754.00) (216,754.00) ** (216,754.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 1550 05/23/2017 Texpool Transfers (76,676.74) (10,953.82) (87,630.56) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,953.82) (87,630.56) ** (120,492.00) Budgeted (32,861.44) Remaining 73 % Used Department Totals: ----------------------------------- (975,577.32) ** (232,087.00) Monthly Total (1,016,223.00) Budgeted (40,645.68) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1,250.00 .00 1,250.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,250.00 ** 2,550.00 Budgeted 1,300.00 Remaining 49 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 150,491.25 .00 150,491.25 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 150,491.25 ** 300,583.00 Budgeted 150,091.75 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 ** 710,000.00 Budgeted 710,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 151,741.25 ** .00 Monthly Total 1,013,133.00 Budgeted 861,391.75 Remaining 15 % Used Fund 533 Totals: ----------------------------------- (823,836.07) (232,087.00) Monthly Total (3,090.00) Budgeted 820,746.07 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MAY 2017 APRIL 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 333,407 ACCOUNTS RECEIVABLE - TOTAL ASSETS 333,407 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 318,309 TOTAL FUND BALANCE 333,407 TOTAL LIABILITIES AND FUND BALANCE 333,407 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 14:15 06/12/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 200.00- 200.00- 192.75- 636.95- 318.475 436.95 534-49142-000-000 Interfund Tran In-Water Sales 297,011.00- 297,011.00- 297,011.00- 534-49143-000-000 Interfund Transfer In-WW Sales 595,638.00- 595,638.00- 54,148.91- 433,191.28- 72.727 162,446.72- Subtotal: 892,849.00- 892,849.00- 54,341.66- 433,828.23- 48.589 459,020.77- Program number: 892,849.00- 892,849.00- 54,341.66- 433,828.23- 48.589 459,020.77- Department number: Revenues 892,849.00- 892,849.00- 54,341.66- 433,828.23- 48.589 459,020.77- Revenues Subtotal ----------- 892,849.00- 892,849.00- 54,341.66- 433,828.23- 48.589 459,020.77- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 14:15 06/12/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 387,649.00 387,649.00 115,518.75 29.800 272,130.25 534-70045-051-000 Revenue Bond Principal Expense 505,000.00 505,000.00 505,000.00 Subtotal: 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Program number: 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Department number: Administration 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Expenditures Subtotal ----------- 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Fund number: 534 2015 Revenue Bond I&S 200.00- 200.00- 54,341.66- 318,309.48- ############### 318,109.48 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 1691 05/31/2017 Bank Interest/May Revenue Bond I&S WWTP (444.20) (192.75) (636.95) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (192.75) (636.95) ** (200.00) Budgeted 436.95 Remaining 318 % Used Account: 534-49142-000-000 Interfund Tran In-Water Sales .00 .00 _______________ Account: 534-49142-000-000 Interfund Tran In-Water Sales Totals: .00 .00 ** (297,011.00) Budgeted (297,011.00) Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1550 05/23/2017 Texpool Transfers (379,042.37) (54,148.91) (433,191.28) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,148.91) (433,191.28) ** (595,638.00) Budgeted (162,446.72) Remaining 73 % Used Department Totals: ----------------------------------- (433,828.23) ** (54,341.66) Monthly Total (892,849.00) Budgeted (459,020.77) Remaining 49 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense 115,518.75 .00 115,518.75 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 115,518.75 ** 387,649.00 Budgeted 272,130.25 Remaining 30 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 505,000.00 Budgeted 505,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 115,518.75 ** .00 Monthly Total 892,649.00 Budgeted 777,130.25 Remaining 13 % Used Fund 534 Totals: ----------------------------------- (318,309.48) (54,341.66) Monthly Total (200.00) Budgeted 318,109.48 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET MAY 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 175,456 ACCOUNTS RECEIVABLE - TOTAL ASSETS 175,456 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 175,456 TOTAL FUND BALANCE 175,456 TOTAL LIABILITIES AND FUND BALANCE 175,456 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 25 14:15 06/12/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 5/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 104.46- 313.10- 313.10 535-49142-000-000 Interfund Tran In-Water Sales 21,892.88- 175,143.01- 175,143.01 Subtotal: 21,997.34- 175,456.11- 175,456.11 Program number: 21,997.34- 175,456.11- 175,456.11 Department number: Revenues 21,997.34- 175,456.11- 175,456.11 Revenues Subtotal ----------- 21,997.34- 175,456.11- 175,456.11 Fund number: 535 2016 Rev Bond I&S-SWIFT 21,997.34- 175,456.11- 175,456.11 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 14:18 06/12/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 5/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 1691 05/31/2017 Bank Interest/May Revenue Bond I&S SWIFT (208.64) (104.46) (313.10) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (104.46) (313.10) ** .00 Budgeted 313.10 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1550 05/23/2017 Texpool Transfers (153,250.13) (21,892.88) (175,143.01) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (21,892.88) (175,143.01) ** .00 Budgeted 175,143.01 Remaining 0 % Used Department Totals: ----------------------------------- (175,456.11) ** (21,997.34) Monthly Total .00 Budgeted 175,456.11 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (175,456.11) (21,997.34) Monthly Total .00 Budgeted 175,456.11 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 7,289.08 **** (240,195.93) Monthly Total (192,002.00) Budgeted (199,291.08) Remaining -4 % Used ******* End of Report *********