Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-03 Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MARCH 2017 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,014,302 PREPAID EXPENSES 8,256 ADVALOREM PROPERTY TAXES RECEIVABLE 39,293 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 694 TOTAL ASSETS 1,062,545 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 39,293 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 39,293 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 502,144 TOTAL FUND BALANCE 1,023,252 TOTAL LIABILITIES AND FUND BALANCE 1,062,545 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 20:08 04/11/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/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- 8,145.45- 1,013,176.41- 97.815 22,633.59- 122-40011-000-000 Property Taxes/Fire-Delinquent 451.30- 1,960.91- 1,960.91 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 1,194.66- 2,114.34- 46.985 2,385.66- Subtotal: 1,040,310.00- 1,040,310.00- 9,791.41- 1,017,363.68- 97.794 22,946.32- 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- 9,791.41- 1,017,512.68- 97.809 22,797.32- Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 9,791.41- 1,017,512.68- 97.809 22,797.32- Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 9,791.41- 1,017,512.68- 97.809 22,797.32- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 20:08 04/11/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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 122-60055-045-000 Insurance 16,513.00 16,513.00 1,376.09 8,256.54 50.000 8,256.46 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 287,789.00 49.479 293,849.00 Subtotal: 814,905.00 814,905.00 50,350.09 296,045.54 36.329 518,859.46 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 50,350.09 515,368.05 49.540 524,941.95 Department number: Fire 1,040,310.00 1,040,310.00 50,350.09 515,368.05 49.540 524,941.95 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 50,350.09 515,368.05 49.540 524,941.95 Fund number: 122 Trophy Club MUD Fire Dept. 40,558.68 502,144.63- 502,144.63 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/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 1258 03/01/2017 Property Taxes (1,005,030.96) (755.77) (1,005,786.73) GL 1259 03/03/2017 Property Taxes (72.29) (1,005,859.02) GL 1260 03/06/2017 Property Taxes (4,757.07) (1,010,616.09) GL 1261 03/07/2017 Property Taxes (835.51) (1,011,451.60) GL 1262 03/08/2017 Property Taxes (1,293.68) (1,012,745.28) GL 1263 03/09/2017 Property Taxes (2,073.38) (1,014,818.66) GL 1264 03/10/2017 Property Taxes (282.21) (1,015,100.87) GL 1265 03/13/2017 Property Taxes (71.32) (1,015,172.19) GL 1266 03/14/2017 Property Taxes (398.00) (1,015,570.19) GL 1267 03/15/2017 Property Taxes (147.08) (1,015,717.27) GL 1268 03/16/2017 Property Taxes (1,116.73) (1,016,834.00) GL 1269 03/17/2017 Property Taxes (431.73) (1,017,265.73) GL 1271 03/21/2017 Property Taxes (1,286.63) (1,018,552.36) GL 1272 03/22/2017 Property Taxes (92.76) (1,018,645.12) GL 1273 03/23/2017 Property Taxes (290.36) (1,018,935.48) GL 1274 03/24/2017 Property Taxes (223.19) (1,019,158.67) GL 1275 03/27/2017 Property Taxes (272.33) (1,019,431.00) GL 1276 03/28/2017 Property Taxes (231.33) (1,019,662.33) GL 1277 03/29/2017 Property Taxes 6,920.25 (1,012,742.08) GL 1278 03/30/2017 Property Taxes (385.02) (1,013,127.10) GL 1279 03/31/2017 Property Taxes (49.31) (1,013,176.41) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (8,145.45) (1,013,176.41) ** (1,035,810.00) Budgeted (22,633.59) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1260 03/06/2017 Property Taxes (1,509.61) (264.08) (1,773.69) GL 1261 03/07/2017 Property Taxes (3.87) (1,777.56) GL 1262 03/08/2017 Property Taxes (20.58) (1,798.14) GL 1266 03/14/2017 Property Taxes (207.96) (2,006.10) GL 1277 03/29/2017 Property Taxes 45.40 (1,960.70) GL 1278 03/30/2017 Property Taxes (.21) (1,960.91) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (451.30) (1,960.91) ** .00 Budgeted 1,960.91 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/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-40020-000-000 Property Taxes/Fire P&I 1258 03/01/2017 Property Taxes (919.68) (52.90) (972.58) GL 1259 03/03/2017 Property Taxes (1.60) (974.18) GL 1260 03/06/2017 Property Taxes (73.98) (1,048.16) GL 1261 03/07/2017 Property Taxes (61.51) (1,109.67) GL 1262 03/08/2017 Property Taxes (98.27) (1,207.94) GL 1263 03/09/2017 Property Taxes (171.77) (1,379.71) GL 1264 03/10/2017 Property Taxes (33.01) (1,412.72) GL 1265 03/13/2017 Property Taxes (.86) (1,413.58) GL 1266 03/14/2017 Property Taxes (61.46) (1,475.04) GL 1267 03/15/2017 Property Taxes (9.10) (1,484.14) GL 1268 03/16/2017 Property Taxes (57.81) (1,541.95) GL 1269 03/17/2017 Property Taxes (30.86) (1,572.81) GL 1270 03/20/2017 Property Taxes (314.19) (1,887.00) GL 1270 03/20/2017 Property Taxes (17.03) (1,904.03) GL 1271 03/21/2017 Property Taxes (93.09) (1,997.12) GL 1272 03/22/2017 Property Taxes (8.35) (2,005.47) GL 1274 03/24/2017 Property Taxes (16.55) (2,022.02) GL 1275 03/27/2017 Property Taxes (71.80) (2,093.82) GL 1276 03/28/2017 Property Taxes (1.16) (2,094.98) GL 1277 03/29/2017 Property Taxes (1.19) (2,096.17) GL 1278 03/30/2017 Property Taxes (18.17) (2,114.34) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,194.66) (2,114.34) ** (4,500.00) Budgeted (2,385.66) Remaining 47 % 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,017,512.68) ** (9,791.41) Monthly Total (1,040,310.00) Budgeted (22,797.32) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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-60020-045-000 Electricity/Gas 1291 03/31/2017 Town billed Inv 1555-1561 AR 20170331-20170331 User: (694.12) (694.12) AR 1295 03/31/2017 Due to/from Fire Electricity 694.12 .00 GL _______________ Account: 122-60020-045-000 Electricity/Gas Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 216,754.00 Budgeted 216,754.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 465 03/01/2017 Insurance/Wrk Comp Exp Mar 6,880.45 1,376.09 8,256.54 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.09 8,256.54 ** 16,513.00 Budgeted 8,256.46 Remaining 50 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1116 03/16/2017 March AP March fire Adm Services 238,815.00 48,974.00 287,789.00 TOWN OF TROPHY CLUB 2983 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 287,789.00 ** 581,638.00 Budgeted 293,849.00 Remaining 49 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 515,368.05 ** 50,350.09 Monthly Total 1,040,310.00 Budgeted 524,941.95 Remaining 50 % Used Fund 122 Totals: ----------------------------------- (502,144.63) 40,558.68 Monthly Total .00 Budgeted 502,144.63 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MARCH 2017 GENERAL FUND GASB 3/31/2017 ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 413,113 - 413,113 CASH IN BANK-SAVINGS-CASH RESERVE 180,412 - 180,412 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 713,038 - 713,038 INVESTMENTS-TEXPOOL 712,892 433,170 1,146,062 PREPAID EXPENSES 44,368 - 44,368 ADVALOREM PROPERTY TAXES RECEIVABLE 3,101 - 3,101 UTILITY AND OTHER ACCOUNTS RECEIVABLE 678,988 - 678,988 TOTAL ASSETS 2,781,669 433,170 3,214,839 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,101 - 3,101 ACCOUNTS AND OTHER PAYABLES 384,629 - 384,629 CUSTOMER DEPOSITS 313,810 - 313,810 - TOTAL LIABILITIES 701,540 - 701,540 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,276,319 1,276,319 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 851,803 - 851,803 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES (51,479) - (51,479) - TOTAL FUND BALANCE 2,080,129 433,170 2,513,299 TOTAL LIABILITIES AND FUND BALANCE 2,781,669 433,170 3,214,839 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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- 497.68- 59,625.07- 97.783 1,351.93- 135-40002-000-000 Property Taxes/Delinquent 31.43- 162.94- 162.94 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 53.60- 139.59- 21.475 510.41- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 582.71- 59,927.60- 28.548 149,990.40- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 423,729.20- 2,222,142.52- 34.523 4,214,591.48- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 105,938.69- 1,044,935.90- 39.739 1,584,588.10- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 8,722.06- 56,728.95- 47.567 62,531.05- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,300.00- 6,875.00- 60.307 4,525.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 950.00- 47.500 1,050.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 450.00- 1,950.00- 35.455 3,550.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 8,488.50- 16,500.00- 26.966 44,688.00- Subtotal: 9,265,606.00- 9,265,606.00- 548,778.45- 3,350,082.37- 36.156 5,915,523.63- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 1,602.57- 7,246.68- 90.572 754.32- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 5,463.18- 50.002 5,462.82- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,916.65- 41.666 4,083.35- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 21,609.00- 21,609.00- 943.00- 7,756.00- 35.892 13,853.00- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 1,198.61- 5,885.29- 29.426 14,114.71- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 30.00- 150.000 10.00 Subtotal: 69,556.00- 69,556.00- 5,238.04- 29,297.80- 42.121 40,258.20- Program number: 9,545,080.00- 9,545,080.00- 554,599.20- 3,439,307.77- 36.032 6,105,772.23- Department number: Revenues 9,545,080.00- 9,545,080.00- 554,599.20- 3,439,307.77- 36.032 6,105,772.23- Revenues Subtotal ----------- 9,545,080.00- 9,545,080.00- 554,599.20- 3,439,307.77- 36.032 6,105,772.23- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 18,009.56 108,216.88 39.911 162,926.12 135-50010-010-000 Overtime 19,500.00 19,500.00 554.48 5,669.73 29.076 13,830.27 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 250.00 1,450.00 30.208 3,350.00 135-50020-010-000 Retirement 27,151.00 27,151.00 1,740.30 10,650.45 39.227 16,500.55 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 2,922.03 16,249.48 29.062 39,664.52 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 299.27 1,500.71 36.083 2,658.29 135-50028-010-000 Vision Insurance 910.00 910.00 53.76 296.45 32.577 613.55 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 230.01 1,329.96 47.448 1,473.04 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,116.41 7,162.04 37.653 11,858.96 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 261.07 1,674.99 37.657 2,773.01 135-50040-010-000 Unemployment Taxes 1,026.00 1,026.00 630.24- 43.67 4.256 982.33 135-50045-010-000 Workman's Compensation 13,152.00 13,152.00 1,074.16 6,444.96 49.004 6,707.04 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 300.00 Subtotal: 428,897.00 428,897.00 25,880.81 163,959.32 38.228 264,937.68 135-55005-010-000 Engineering 5,000.00 5,000.00 19,539.18 390.784 14,539.18- 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 29,216.88 43,819.18 43.819 56,180.82 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 32.84 720.26 9.003 7,279.74 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 1,828.10 33.238 3,671.90 Subtotal: 125,000.00 125,000.00 29,249.72 65,906.72 52.725 59,093.28 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 19.98 1,772.84 32.830 3,627.16 135-60020-010-000 Electricity 172,737.00 172,737.00 858.53- 62,810.25 36.362 109,926.75 135-60066-010-000 Publications/Books/Subscripts 750.00 750.00 750.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 265.00 6.277 3,957.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 18,063.95 36.001 32,112.05 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 114,066.90 699,524.87 23.327 2,299,277.13 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 5,000.00 5,000.00 216.00 966.00 19.320 4,034.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 14,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 297,011.00 43,785.76 131,357.25 44.226 165,653.75 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 14,361.00 86,166.00 132.726 21,246.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 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 171,591.11 1,001,050.62 26.203 2,819,317.38 135-65005-010-000 Fuel & Lube 33,011.00 33,011.00 3,400.14 10.300 29,610.86 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 1,651.63 7,373.33 36.867 12,626.67 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 115,000.00 11,708.26 10.181 103,291.74 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 256,319.00 1,651.63 72,296.83 28.206 184,022.17 135-69005-010-000 Capital Outlays 502,421.00 502,421.00 13,145.60 288,470.69 57.416 213,950.31 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 8,183.33 126,957.75 106.889 8,182.75- Subtotal: 696,196.00 696,196.00 21,328.93 490,428.44 70.444 205,767.56 Program number: 5,326,780.00 5,326,780.00 249,702.20 1,793,641.93 33.672 3,533,138.07 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/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 207.70 607.70 12.154 4,392.30 Subtotal: 5,000.00 5,000.00 207.70 607.70 12.154 4,392.30 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 207.70 607.70 6.077 9,392.30 Department number: Water 5,336,780.00 5,336,780.00 249,909.90 1,794,249.63 33.620 3,542,530.37 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 29,716.99 177,420.53 45.364 213,681.47 135-50010-020-000 Overtime 29,500.00 29,500.00 2,674.76 17,100.67 57.968 12,399.33 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 625.00 3,750.00 48.077 4,050.00 135-50020-020-000 Retirement 39,584.00 39,584.00 3,054.06 18,403.47 46.492 21,180.53 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,710.20 26,874.31 36.803 46,147.69 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 399.32 2,068.40 45.044 2,523.60 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 84.33 448.26 43.478 582.74 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 383.89 2,222.13 49.546 2,262.87 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 1,915.06 11,904.21 42.689 15,981.79 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 447.88 2,784.04 42.687 3,737.96 135-50040-020-000 Unemployment Taxes 1,197.00 1,197.00 1,075.69- 63.00 5.263 1,134.00 135-50045-020-000 Workman's Compensation 11,347.00 11,347.00 926.75 5,560.50 49.004 5,786.50 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 650.00 650.00 122.20 325.22 50.034 324.78 Subtotal: 605,653.00 605,653.00 43,984.75 275,559.74 45.498 330,093.26 135-55005-020-000 Engineering 70,000.00 70,000.00 70,000.00 135-55070-020-000 Independent Labor 20,000.00 20,000.00 1,297.50 19,449.39 97.247 550.61 135-55080-020-000 Maintenance & Repairs 83,100.00 83,100.00 1,176.28 30,373.34 36.550 52,726.66 135-55085-020-000 Generator Maint. and Repair 20,000.00 20,000.00 20,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 5,395.39 134.885 1,395.39- 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 3,696.20 27,851.38 50.639 27,148.62 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,114.00 13,613.00 54.452 11,387.00 Subtotal: 277,600.00 277,600.00 8,283.98 96,706.44 34.837 180,893.56 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 39.96 2,433.05 45.056 2,966.95 135-60020-020-000 Electricity 158,627.00 158,627.00 21,046.16 62,646.29 39.493 95,980.71 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 250.00 206.00 267.00 106.800 17.00- 135-60080-020-000 Schools & Training 4,195.00 4,195.00 555.45 2,307.81 55.013 1,887.19 135-60090-020-000 Safety Program 550.00 550.00 46.62 257.16 46.756 292.84 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 1,580.36 2,130.21 133.138 530.21- 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 14,565.97 84.933 2,584.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 590.00 8.911 6,031.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 11,600.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 10,953.82 65,722.92 54.545 54,769.08 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 54,148.91 324,893.46 54.545 270,744.54 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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,255,465.00 88,577.28 536,176.79 42.707 719,288.21 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 3,445.02 12.265 24,642.98 135-65010-020-000 Uniforms 4,459.00 4,459.00 199.95 3,753.87 84.186 705.13 135-65030-020-000 Chemicals 25,000.00 25,000.00 14,942.29 59.769 10,057.71 135-65035-020-000 Small Tools 2,000.00 2,000.00 243.46 1,100.18 55.009 899.82 135-65040-020-000 Safety Equipment 750.00 750.00 81.96 252.64 33.685 497.36 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 440.43 7,789.25 55.638 6,210.75 Subtotal: 74,297.00 74,297.00 965.80 31,283.25 42.106 43,013.75 135-69005-020-000 Capital Outlays 485,000.00 485,000.00 33,184.50 196,357.40 40.486 288,642.60 Subtotal: 485,000.00 485,000.00 33,184.50 196,357.40 40.486 288,642.60 Program number: 2,698,015.00 2,698,015.00 174,996.31 1,136,083.62 42.108 1,561,931.38 Department number: Wastewater 2,698,015.00 2,698,015.00 174,996.31 1,136,083.62 42.108 1,561,931.38 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/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 2.61 15.66 48.938 16.34 Subtotal: 32.00 32.00 2.61 15.66 48.938 16.34 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 1,560.00 39.000 2,440.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 3,379.37 26.299 9,470.63 Program number: 12,882.00 12,882.00 2.61 3,395.03 26.355 9,486.97 Department number: Board of Directors 12,882.00 12,882.00 2.61 3,395.03 26.355 9,486.97 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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,176.29 183,998.85 35.392 335,884.15 135-50010-030-000 Overtime 1,000.00 1,000.00 629.11 1,778.63 177.863 778.63- 135-50016-030-000 Longevity 3,890.00 3,890.00 3,417.50 87.853 472.50 135-50020-030-000 Retirement 47,768.00 47,768.00 3,589.50 16,804.36 35.179 30,963.64 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 4,551.97 20,499.26 24.320 63,789.74 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 416.81 1,752.97 29.309 4,228.03 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 88.84 375.41 28.614 936.59 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 378.20 1,895.37 32.179 3,994.63 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 2,293.40 11,083.91 33.816 21,693.09 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 536.35 2,592.18 32.066 5,491.82 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 936.40- 288.75 21.107 1,079.25 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 145.53 873.18 48.945 910.82 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 339.35 67.870 160.65 135-50070-030-000 Employee Relations 4,960.00 4,960.00 238.22 2,571.46 51.844 2,388.54 Subtotal: 719,486.00 719,486.00 50,107.82 248,271.18 34.507 471,214.82 135-55030-030-000 Software & Support 67,791.00 67,791.00 2,899.65 56,763.19 83.733 11,027.81 135-55070-030-000 Independent Labor 12,000.00 12,000.00 217.50 932.50 7.771 11,067.50 135-55080-030-000 Maintenance & Repairs 7,000.00 7,000.00 275.00 3.929 6,725.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 1,436.85 5,738.97 81.985 1,261.03 135-55120-030-000 Cleaning Services 10,429.00 10,429.00 633.06 3,142.30 30.130 7,286.70 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 57,332.00 90.536 5,993.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 3,219.04 39.257 4,980.96 Subtotal: 185,945.00 185,945.00 5,187.06 127,888.00 68.777 58,057.00 135-60005-030-000 Telephone 17,532.00 17,532.00 1,041.51 6,889.22 39.295 10,642.78 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 300.00 1,464.95 35.300 2,685.05 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 292.28 734.70 48.980 765.30 135-60035-030-000 Postage 28,932.00 28,932.00 8.74 11,826.69 40.878 17,105.31 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 3,457.09 24,955.46 44.916 30,604.54 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,664.56 27,987.36 50.254 27,704.64 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 261.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 400.00 135-60079-030-000 Public Education 8,754.00 8,754.00 3,590.43 4,853.34 55.441 3,900.66 135-60080-030-000 Schools & Training 7,840.00 7,840.00 675.00 8.610 7,165.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 5,253.47 6,692.08 123.927 1,292.08- 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 7,500.00 135-60125-030-000 Advertising 7,500.00 7,500.00 950.09 12.668 6,549.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 17,500.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 246,041.00 18,869.08 94,125.99 38.256 151,915.01 135-65010-030-000 Uniforms 1,855.00 1,855.00 142.36 7.674 1,712.64 135-65055-030-000 Hardware 9,444.00 9,444.00 2,239.88 23.717 7,204.12 135-65085-030-000 Office Supplies 9,000.00 9,000.00 305.39 2,967.65 32.974 6,032.35 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 2,000.00 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 140.41 1,454.86 29.097 3,545.14 135-65105-030-000 Printing 4,800.00 4,800.00 123.00 2.563 4,677.00 Subtotal: 32,099.00 32,099.00 445.80 6,927.75 21.582 25,171.25 135-69005-030-000 Capital Outlays 107,001.00 107,001.00 875.00 13,852.95 12.947 93,148.05 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 302.98 2,033.51 44.207 2,566.49 Subtotal: 111,601.00 111,601.00 1,177.98 15,886.46 14.235 95,714.54 Program number: 1,295,172.00 1,295,172.00 75,787.74 493,099.38 38.072 802,072.62 Department number: Administration 1,295,172.00 1,295,172.00 75,787.74 493,099.38 38.072 802,072.62 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 20:08 04/11/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/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 35,967.01 23.978 114,032.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 2,045.87 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 2,045.87 63,959.27 33.881 124,815.73 Program number: 188,775.00 188,775.00 2,045.87 63,959.27 33.881 124,815.73 Department number: Non Departmental 188,775.00 188,775.00 2,045.87 63,959.27 33.881 124,815.73 Expenditures Subtotal ----------- 9,531,624.00 9,531,624.00 502,742.43 3,490,786.93 36.623 6,040,837.07 Fund number: 135 MUD 1 General Fund 13,456.00- 13,456.00- 51,856.77- 51,479.16 -382.574 64,935.16- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 20:08 04/11/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/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 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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 1258 03/01/2017 Property Taxes (59,127.39) (44.46) (59,171.85) GL 1259 03/03/2017 Property Taxes (4.25) (59,176.10) GL 1260 03/06/2017 Property Taxes (279.87) (59,455.97) GL 1261 03/07/2017 Property Taxes (49.15) (59,505.12) GL 1262 03/08/2017 Property Taxes (76.11) (59,581.23) GL 1263 03/09/2017 Property Taxes (121.98) (59,703.21) GL 1264 03/10/2017 Property Taxes (16.60) (59,719.81) GL 1265 03/13/2017 Property Taxes (4.20) (59,724.01) GL 1266 03/14/2017 Property Taxes (23.42) (59,747.43) GL 1267 03/15/2017 Property Taxes (8.65) (59,756.08) GL 1268 03/16/2017 Property Taxes (65.70) (59,821.78) GL 1269 03/17/2017 Property Taxes (25.40) (59,847.18) GL 1270 03/20/2017 Property Taxes (18.48) (59,865.66) GL 1271 03/21/2017 Property Taxes (75.69) (59,941.35) GL 1272 03/22/2017 Property Taxes (5.46) (59,946.81) GL 1273 03/23/2017 Property Taxes (17.08) (59,963.89) GL 1274 03/24/2017 Property Taxes (13.13) (59,977.02) GL 1275 03/27/2017 Property Taxes (16.02) (59,993.04) GL 1276 03/28/2017 Property Taxes (13.61) (60,006.65) GL 1277 03/29/2017 Property Taxes 407.13 (59,599.52) GL 1278 03/30/2017 Property Taxes (22.65) (59,622.17) GL 1279 03/31/2017 Property Taxes (2.90) (59,625.07) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (497.68) (59,625.07) ** (60,977.00) Budgeted (1,351.93) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1260 03/06/2017 Property Taxes (131.51) (17.26) (148.77) GL 1261 03/07/2017 Property Taxes (.75) (149.52) GL 1262 03/08/2017 Property Taxes (3.96) (153.48) GL 1266 03/14/2017 Property Taxes (13.59) (167.07) GL 1277 03/29/2017 Property Taxes 4.14 (162.93) GL 1278 03/30/2017 Property Taxes (.01) (162.94) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (31.43) (162.94) ** .00 Budgeted 162.94 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1258 03/01/2017 Property Taxes (85.99) (3.12) (89.11) GL 1259 03/03/2017 Property Taxes (.10) (89.21) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1260 03/06/2017 Property Taxes (85.99) (4.76) (93.97) GL 1261 03/07/2017 Property Taxes (3.71) (97.68) GL 1262 03/08/2017 Property Taxes (6.70) (104.38) GL 1263 03/09/2017 Property Taxes (10.11) (114.49) GL 1264 03/10/2017 Property Taxes (1.95) (116.44) GL 1265 03/13/2017 Property Taxes (.05) (116.49) GL 1266 03/14/2017 Property Taxes (3.95) (120.44) GL 1267 03/15/2017 Property Taxes (.54) (120.98) GL 1268 03/16/2017 Property Taxes (3.40) (124.38) GL 1269 03/17/2017 Property Taxes (1.82) (126.20) GL 1270 03/20/2017 Property Taxes (1.01) (127.21) GL 1271 03/21/2017 Property Taxes (5.48) (132.69) GL 1272 03/22/2017 Property Taxes (.49) (133.18) GL 1274 03/24/2017 Property Taxes (.97) (134.15) GL 1275 03/27/2017 Property Taxes (4.23) (138.38) GL 1276 03/28/2017 Property Taxes (.07) (138.45) GL 1277 03/29/2017 Property Taxes (.07) (138.52) GL 1278 03/30/2017 Property Taxes (1.07) (139.59) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (53.60) (139.59) ** (650.00) Budgeted (510.41) Remaining 21 % 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 1214 03/31/2017 03/31/2017 UB Billing UB20170331-20170331 User: (1,798,413.32) (423,729.20) (2,222,142.52) UB _______________ Account: 135-47000-000-000 Water Totals: (423,729.20) (2,222,142.52) ** (6,436,734.00) Budgeted (4,214,591.48) Remaining 35 % Used Account: 135-47005-000-000 Sewer 1214 03/31/2017 03/31/2017 UB Billing UB20170331-20170331 User: (938,997.21) (105,938.69) (1,044,935.90) UB _______________ Account: 135-47005-000-000 Sewer Totals: (105,938.69) (1,044,935.90) ** (2,629,524.00) Budgeted (1,584,588.10) Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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-47025-000-000 Penalties 1204 03/07/2017 03/07/2017 UB penalties UB20170307-20170307 User: (48,006.89) 76.51 (47,930.38) UB 1177 03/10/2017 03/10/2017 UB Penalty removal UB20170310-20170310 User: 102.23 (47,828.15) UB 1205 03/17/2017 03/17/2017 UB Penalties UB20170317-20170317 User: 208.86 (47,619.29) UB 1140 03/21/2017 03/21/2017 UB Penalties UB20170321-20170321 User: (10,809.27) (58,428.56) UB 1206 03/21/2017 03/21/2017 Ub Penalties UB20170321-20170321 User: 626.83 (57,801.73) UB 1207 03/27/2017 03/27/2017 UB Penalties UB20170327-20170327 User: 28.75 (57,772.98) UB 1208 03/28/2017 03/28/2017 Ub Penalties UB20170328-20170328 User: 1,044.03 (56,728.95) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,722.06) (56,728.95) ** (119,260.00) Budgeted (62,531.05) Remaining 48 % Used Account: 135-47030-000-000 Service Charges 1051 03/08/2017 03/08/2017 UB Cut Off List Fee UB20170308-20170308 User: (5,575.00) (1,275.00) (6,850.00) UB 1176 03/10/2017 3/10/2017 UB Disconnect fee UB20170310-20170310 User: 25.00 (6,825.00) UB 1182 03/13/2017 03/13/2017 UB NSF Fee UB20170313-20170313 User: (25.00) (6,850.00) UB 1184 03/20/2017 03/20/2017 UB NSF Fee UB20170320-20170320 User: (25.00) (6,875.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,300.00) (6,875.00) ** (11,400.00) Budgeted (4,525.00) Remaining 60 % Used Account: 135-47035-000-000 Plumbing Inspections 1083 03/10/2017 03/10/2017 UB PERMIT FEES 661 INDIAN CREEK DRIVE (800.00) (50.00) (850.00) FIRST TEXAS HOMES CR 1159 03/23/2017 03/23/2017 UB Permit Fees 43 MEADOWBROOK LANE (50.00) (900.00) Our Country Homes CR 1189 03/29/2017 03/29/2017 UB Permits 341 Tenison Trail (50.00) (950.00) First Texas Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (950.00) ** (2,000.00) Budgeted (1,050.00) Remaining 48 % Used Account: 135-47045-000-000 Sewer Inspections 1083 03/10/2017 03/10/2017 UB PERMIT FEES 661 INDIAN CREEK DRIVE (1,500.00) (150.00) (1,650.00) FIRST TEXAS HOMES CR 1159 03/23/2017 03/23/2017 UB Permit Fees 43 MEADOWBROOK LANE (150.00) (1,800.00) Our Country Homes CR 1189 03/29/2017 03/29/2017 UB Permits 341 Tenison Trail (150.00) (1,950.00) First Texas Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (1,950.00) ** (5,500.00) Budgeted (3,550.00) Remaining 35 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1214 03/31/2017 03/31/2017 UB Billing UB20170331-20170331 User: (8,011.50) (8,488.50) (16,500.00) UB . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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-47070-000-000 TCCC Effluent Charges Totals: (8,488.50) (16,500.00) ** (61,188.00) Budgeted (44,688.00) Remaining 27 % Used Account: 135-49010-000-000 Interest Income 1256 03/31/2017 Bank Interest March 2017 (5,644.11) (1,164.99) (6,809.10) GL 1256 03/31/2017 Bank Interest March 2017 (174.54) (6,983.64) GL 1256 03/31/2017 Bank Interest March 2017 (111.67) (7,095.31) GL 1256 03/31/2017 Bank Interest March 2017 (151.37) (7,246.68) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,602.57) (7,246.68) ** (8,001.00) Budgeted (754.32) Remaining 91 % Used Account: 135-49016-000-000 Cell Tower Revenue 1105 03/03/2017 AT&T Cell Tower Revenue (4,552.65) (910.53) (5,463.18) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (5,463.18) ** (10,926.00) Budgeted (5,462.82) Remaining 50 % Used Account: 135-49018-000-000 Building Rent Income 1291 03/31/2017 Town billed Inv 1555-1561 AR 20170331-20170331 User: (2,333.32) (583.33) (2,916.65) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,916.65) ** (7,000.00) Budgeted (4,083.35) Remaining 42 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1083 03/10/2017 03/10/2017 UB PERMIT FEES 661 INDIAN CREEK DRIVE (6,813.00) (343.00) (7,156.00) FIRST TEXAS HOMES CR 1159 03/23/2017 03/23/2017 UB Permit Fees 43 MEADOWBROOK LANE (257.00) (7,413.00) Our Country Homes CR 1189 03/29/2017 03/29/2017 UB Permits 341 Tenison Trail (343.00) (7,756.00) First Texas Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (943.00) (7,756.00) ** (21,609.00) Budgeted (13,853.00) Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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-49900-000-000 Miscellaneous Income 1106 03/14/2017 COOP Buyboard Rebate 15-16 (4,686.68) (146.50) (4,833.18) GL 1189 03/29/2017 03/29/2017 UB Permits 341 Tenison Trail (800.00) (5,633.18) First Texas Homes CR 1193 03/30/2017 UB Adj UB20170330-20170330 User: 40.00 (5,593.18) UB 1214 03/31/2017 03/31/2017 UB Billing UB20170331-20170331 User: (292.11) (5,885.29) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,198.61) (5,885.29) ** (20,000.00) Budgeted (14,114.71) Remaining 29 % Used Account: 135-49901-000-000 Records Management Revenue (30.00) .00 (30.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (30.00) ** (20.00) Budgeted 10.00 Remaining 150 % Used Department Totals: ----------------------------------- (3,439,307.77) ** (554,599.20) Monthly Total (9,545,080.00) Budgeted (6,105,772.23) Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 1039 03/10/2017 Mud P/R 03/10/17 Salaries & Wages 90,207.32 9,002.89 99,210.21 PR 1151 03/24/2017 P/R 03.24.17 Salaries & Wages 9,006.67 108,216.88 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 18,009.56 108,216.88 ** 271,143.00 Budgeted 162,926.12 Remaining 40 % Used Account: 135-50010-010-000 Overtime 1039 03/10/2017 Mud P/R 03/10/17 Overtime 5,115.25 253.55 5,368.80 PR 1151 03/24/2017 P/R 03.24.17 Overtime 300.93 5,669.73 PR _______________ Account: 135-50010-010-000 Overtime Totals: 554.48 5,669.73 ** 19,500.00 Budgeted 13,830.27 Remaining 29 % 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 1151 03/24/2017 P/R 03.24.17 Certification 1,200.00 250.00 1,450.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 250.00 1,450.00 ** 4,800.00 Budgeted 3,350.00 Remaining 30 % Used Account: 135-50020-010-000 Retirement 1039 03/10/2017 Mud P/R 03/10/17 Retirement 8,910.15 856.22 9,766.37 PR 1151 03/24/2017 P/R 03.24.17 Retirement 884.08 10,650.45 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,740.30 10,650.45 ** 27,151.00 Budgeted 16,500.55 Remaining 39 % Used Account: 135-50026-010-000 Medical Insurance 1039 03/10/2017 Mud P/R 03/10/17 Medical Insurance 13,327.45 1,461.01 14,788.46 PR 1151 03/24/2017 P/R 03.24.17 Medical Insurance 1,461.02 16,249.48 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,922.03 16,249.48 ** 55,914.00 Budgeted 39,664.52 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 1039 03/10/2017 Mud P/R 03/10/17 Dental Insurance 1,201.44 149.65 1,351.09 PR 1151 03/24/2017 P/R 03.24.17 Dental Insurance 149.62 1,500.71 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 299.27 1,500.71 ** 4,159.00 Budgeted 2,658.29 Remaining 36 % Used Account: 135-50028-010-000 Vision Insurance 1039 03/10/2017 Mud P/R 03/10/17 Vision Insurance 242.69 26.90 269.59 PR 1151 03/24/2017 P/R 03.24.17 Vision Insurance 26.86 296.45 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.76 296.45 ** 910.00 Budgeted 613.55 Remaining 33 % Used Account: 135-50029-010-000 Life Insurance & Other 1018 03/01/2017 March A/P Misc Insurance 1,099.95 220.30 1,320.25 METLIFE GROUP BENEFITS 2929 AP 1191 03/29/2017 March AP Café 125 Adm Fee 9.71 1,329.96 BenefitMall 2992 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 230.01 1,329.96 ** 2,803.00 Budgeted 1,473.04 Remaining 47 % Used Account: 135-50030-010-000 Social Security Taxes 1039 03/10/2017 Mud P/R 03/10/17 Social Security Taxes 6,045.63 550.98 6,596.61 PR 1151 03/24/2017 P/R 03.24.17 Social Security Taxes 565.43 7,162.04 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,116.41 7,162.04 ** 19,021.00 Budgeted 11,858.96 Remaining 38 % Used Account: 135-50035-010-000 Medicare Taxes 1039 03/10/2017 Mud P/R 03/10/17 Medicare Taxes 1,413.92 128.87 1,542.79 PR 1151 03/24/2017 P/R 03.24.17 Medicare Taxes 132.20 1,674.99 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 261.07 1,674.99 ** 4,448.00 Budgeted 2,773.01 Remaining 38 % Used Account: 135-50040-010-000 Unemployment Taxes 1039 03/10/2017 Mud P/R 03/10/17 Unemployment Taxes 673.91 92.56 766.47 PR 1151 03/24/2017 P/R 03.24.17 Unemployment Taxes (722.80) 43.67 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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: (630.24) 43.67 ** 1,026.00 Budgeted 982.33 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 465 03/01/2017 Insurance/Wrk Comp Exp Mar 5,370.80 1,074.16 6,444.96 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,074.16 6,444.96 ** 13,152.00 Budgeted 6,707.04 Remaining 49 % 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 .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering 19,539.18 .00 19,539.18 _______________ Account: 135-55005-010-000 Engineering Totals: .00 19,539.18 ** 5,000.00 Budgeted (14,539.18) Remaining 391 % Used Account: 135-55080-010-000 Maintenance & Repairs 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 TEX-TURF 14,602.30 510.00 15,112.30 TEX-TURF PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 THE HOME DEPOT #6581 20.80 15,133.10 THE HOME DEPOT #6581 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 MACARTHUR GAUGE INC 50.00 15,183.10 MACARTHUR GAUGE INC PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 THE HOME DEPOT #6581 9.09 15,192.19 THE HOME DEPOT #6581 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 TRACTOR SUPPLY COMPANY 17.99 15,210.18 TRACTOR SUPPLY COMPANY PC 1191 03/29/2017 March AP Repair at #1 Michelle Court 28,609.00 43,819.18 REY-MAR CONSTRUCTION 3003 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 29,216.88 43,819.18 ** 100,000.00 Budgeted 56,180.82 Remaining 44 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 ROANOKE AUTO SUPPLY LT 687.42 8.86 696.28 ROANOKE AUTO SUPPLY LT PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 ROANOKE AUTO SUPPLY LT 23.98 720.26 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 32.84 720.26 ** 8,000.00 Budgeted 7,279.74 Remaining 9 % 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 1,828.10 .00 1,828.10 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 1,828.10 ** 5,500.00 Budgeted 3,671.90 Remaining 33 % Used Account: 135-60010-010-000 Communications/Mobiles 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WAL-MART #5247 1,752.86 19.98 1,772.84 WAL-MART #5247 PC _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 19.98 1,772.84 ** 5,400.00 Budgeted 3,627.16 Remaining 33 % Used Account: 135-60020-010-000 Electricity 1116 03/16/2017 March AP Electricity 2/8-3/9 63,668.78 57.67 63,726.45 HUDSON ENERGY SERVICES, LLC 2972 AP 1191 03/29/2017 March AP Electricity 2/8-3/9 694.12 64,420.57 HUDSON ENERGY SERVICES, LLC 2997 AP 1191 03/29/2017 March AP Electricity 2/8-3/9 511.77 64,932.34 HUDSON ENERGY SERVICES, LLC 2997 AP 1191 03/29/2017 March AP Electricity 2/8-3/9 8,502.18 73,434.52 HUDSON ENERGY SERVICES, LLC 2997 AP 1191 03/29/2017 March AP Electricity 2/8-3/9 9,683.99 83,118.51 HUDSON ENERGY SERVICES, LLC 2997 AP 1295 03/31/2017 Due to/from Fire Electricity (694.12) 82,424.39 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1296 03/31/2017 Recode Sewer Elec 12/9-1/10/17 63,668.78 (11,111.96) 71,312.43 GL 1297 03/31/2017 Recode Sewer Elec 2/8-3/9/17 (8,502.18) 62,810.25 GL _______________ Account: 135-60020-010-000 Electricity Totals: (858.53) 62,810.25 ** 172,737.00 Budgeted 109,926.75 Remaining 36 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 265.00 .00 265.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 265.00 ** 4,222.00 Budgeted 3,957.00 Remaining 6 % 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 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-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 18,063.95 .00 18,063.95 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 18,063.95 ** 50,176.00 Budgeted 32,112.05 Remaining 36 % Used Account: 135-60150-010-000 Wholesale Water 1191 03/29/2017 March AP Wholesale water-Feb 585,457.97 114,066.90 699,524.87 CITY OF FORT WORTH 2993 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 114,066.90 699,524.87 ** 2,998,802.00 Budgeted 2,299,277.13 Remaining 23 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 DENTON SAND & GRAVEL, 750.00 108.00 858.00 DENTON SAND & GRAVEL, PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 DENTON SAND & GRAVEL, 108.00 966.00 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 216.00 966.00 ** 5,000.00 Budgeted 4,034.00 Remaining 19 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,750.00 Budgeted 14,750.00 Remaining 0 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1282 03/24/2017 Texpool Transfers Feb & March Swift transfer 87,571.49 43,785.76 131,357.25 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 43,785.76 131,357.25 ** 297,011.00 Budgeted 165,653.75 Remaining 44 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1282 03/24/2017 Texpool Transfers 71,805.00 14,361.00 86,166.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 14,361.00 86,166.00 ** 64,920.00 Budgeted (21,246.00) Remaining 133 % 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 3,400.14 .00 3,400.14 _______________ Account: 135-65005-010-000 Fuel & Lube Totals: .00 3,400.14 ** 33,011.00 Budgeted 29,610.86 Remaining 10 % Used Account: 135-65010-010-000 Uniforms 1,329.48 .00 1,329.48 _______________ 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 1141 03/21/2017 March AP Testing supplies 5,721.70 375.84 6,097.54 HACH COMPANY 2970 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1191 03/29/2017 March AP Testing supplies 5,721.70 165.10 6,262.64 HACH COMPANY 2996 AP 1191 03/29/2017 March AP Testing supplies 123.30 6,385.94 HACH COMPANY 2996 AP 1191 03/29/2017 March AP Testing supplies 245.80 6,631.74 HACH COMPANY 2996 AP 1191 03/29/2017 March AP Chlorine 741.59 7,373.33 DPC INDUSTRIES, INC 2994 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,651.63 7,373.33 ** 20,000.00 Budgeted 12,626.67 Remaining 37 % 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 11,708.26 .00 11,708.26 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 11,708.26 ** 115,000.00 Budgeted 103,291.74 Remaining 10 % 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 1019 03/03/2017 March AP VFD Repair Pump #1 275,325.09 2,265.60 277,590.69 DHS AUTOMATION, INC 2913 AP 1116 03/16/2017 March AP Apple 9,630.00 287,220.69 FRYER CONSTRUCTION COMPANY 2969 AP 1130 03/20/2017 March AP 2.42 m waterline 1,250.00 288,470.69 LanguageUSA, Inc 2974 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 13,145.60 288,470.69 ** 502,421.00 Budgeted 213,950.31 Remaining 57 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-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 1019 03/03/2017 March AP Final Pax Mixer pymt 118,774.42 8,183.33 126,957.75 UTILITY SERVICE CO, INC. 2937 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 8,183.33 126,957.75 ** 118,775.00 Budgeted (8,182.75) Remaining 107 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/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 1116 03/16/2017 March AP Testing 400.00 207.70 607.70 LOWER COLORADO RIVER AUTHORITY 2976 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 207.70 607.70 ** 5,000.00 Budgeted 4,392.30 Remaining 12 % 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: ----------------------------------- 1,794,249.63 ** 249,909.90 Monthly Total 5,336,780.00 Budgeted 3,542,530.37 Remaining 34 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 1039 03/10/2017 Mud P/R 03/10/17 Salaries & Wages 147,703.54 14,882.35 162,585.89 PR 1151 03/24/2017 P/R 03.24.17 Salaries & Wages 14,834.64 177,420.53 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 29,716.99 177,420.53 ** 391,102.00 Budgeted 213,681.47 Remaining 45 % Used Account: 135-50010-020-000 Overtime 1039 03/10/2017 Mud P/R 03/10/17 Overtime 14,425.91 1,764.51 16,190.42 PR 1151 03/24/2017 P/R 03.24.17 Overtime 910.25 17,100.67 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,674.76 17,100.67 ** 29,500.00 Budgeted 12,399.33 Remaining 58 % 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 1151 03/24/2017 P/R 03.24.17 Certification 3,125.00 625.00 3,750.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 3,750.00 ** 7,800.00 Budgeted 4,050.00 Remaining 48 % Used Account: 135-50020-020-000 Retirement 1039 03/10/2017 Mud P/R 03/10/17 Retirement 15,349.41 1,539.83 16,889.24 PR 1151 03/24/2017 P/R 03.24.17 Retirement 1,514.23 18,403.47 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,054.06 18,403.47 ** 39,584.00 Budgeted 21,180.53 Remaining 46 % Used Account: 135-50026-020-000 Medical Insurance 1039 03/10/2017 Mud P/R 03/10/17 Medical Insurance 22,164.11 2,355.10 24,519.21 PR 1151 03/24/2017 P/R 03.24.17 Medical Insurance 2,355.10 26,874.31 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 26,874.31 ** 73,022.00 Budgeted 46,147.69 Remaining 37 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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-020-000 Dental Insurance 1039 03/10/2017 Mud P/R 03/10/17 Dental Insurance 1,669.08 199.69 1,868.77 PR 1151 03/24/2017 P/R 03.24.17 Dental Insurance 199.63 2,068.40 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 2,068.40 ** 4,592.00 Budgeted 2,523.60 Remaining 45 % Used Account: 135-50028-020-000 Vision Insurance 1039 03/10/2017 Mud P/R 03/10/17 Vision Insurance 363.93 42.19 406.12 PR 1151 03/24/2017 P/R 03.24.17 Vision Insurance 42.14 448.26 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 448.26 ** 1,031.00 Budgeted 582.74 Remaining 43 % Used Account: 135-50029-020-000 Life Insurance & Other 1018 03/01/2017 March A/P Misc Insurance 1,838.24 356.76 2,195.00 METLIFE GROUP BENEFITS 2929 AP 1191 03/29/2017 March AP Café 125 Adm Fee 27.13 2,222.13 BenefitMall 2992 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 383.89 2,222.13 ** 4,485.00 Budgeted 2,262.87 Remaining 50 % Used Account: 135-50030-020-000 Social Security Taxes 1039 03/10/2017 Mud P/R 03/10/17 Social Security Taxes 9,989.15 976.00 10,965.15 PR 1151 03/24/2017 P/R 03.24.17 Social Security Taxes 939.06 11,904.21 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,915.06 11,904.21 ** 27,886.00 Budgeted 15,981.79 Remaining 43 % Used Account: 135-50035-020-000 Medicare Taxes 1039 03/10/2017 Mud P/R 03/10/17 Medicare Taxes 2,336.16 228.26 2,564.42 PR 1151 03/24/2017 P/R 03.24.17 Medicare Taxes 219.62 2,784.04 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 447.88 2,784.04 ** 6,522.00 Budgeted 3,737.96 Remaining 43 % Used Account: 135-50040-020-000 Unemployment Taxes 1039 03/10/2017 Mud P/R 03/10/17 Unemployment Taxes 1,138.69 49.68 1,188.37 PR 1151 03/24/2017 P/R 03.24.17 Unemployment Taxes (1,125.37) 63.00 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 Totals: (1,075.69) 63.00 ** 1,197.00 Budgeted 1,134.00 Remaining 5 % Used Account: 135-50045-020-000 Workman's Compensation 465 03/01/2017 Insurance/Wrk Comp Exp Mar 4,633.75 926.75 5,560.50 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 926.75 5,560.50 ** 11,347.00 Budgeted 5,786.50 Remaining 49 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 KROGER #0512 203.02 122.20 325.22 KROGER #0512 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 122.20 325.22 ** 650.00 Budgeted 324.78 Remaining 50 % Used Account: 135-55005-020-000 Engineering .00 .00 _______________ Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 1019 03/03/2017 March AP Wiring well pump 18,151.89 1,297.50 19,449.39 WALKER ENGINEERING INC 2938 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 1,297.50 19,449.39 ** 20,000.00 Budgeted 550.61 Remaining 97 % Used Account: 135-55080-020-000 Maintenance & Repairs 1018 03/01/2017 March A/P Aerator blowers 29,197.06 76.12 29,273.18 WALKER ENGINEERING INC 2938 AP 1149 03/22/2017 March AP Repairs 5,653.20 34,926.38 XYLEM WATER SOLUTIONS USA INC 2988 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 THE HOME DEPOT #6581 29,197.06 33.92 34,960.30 THE HOME DEPOT #6581 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 MCDONNELL BUILDING MAT 8.36 34,968.66 MCDONNELL BUILDING MAT PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 FERGUSON ENT #61 29.39 34,998.05 FERGUSON ENT #61 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 THE HOME DEPOT #6581 28.49 35,026.54 THE HOME DEPOT #6581 PC 1244 03/31/2017 TML/lightning strike/pump (4,653.20) 30,373.34 GL _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 1,176.28 30,373.34 ** 83,100.00 Budgeted 52,726.66 Remaining 37 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 5,395.39 .00 5,395.39 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 5,395.39 ** 4,000.00 Budgeted (1,395.39) Remaining 135 % 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 1018 03/01/2017 March A/P Sludge Haul off 24,155.18 871.20 25,026.38 L.H. CHANEY MATERIALS, INC. 2925 AP 1116 03/16/2017 March AP Sludge Haul off 845.00 25,871.38 L.H. CHANEY MATERIALS, INC. 2973 AP 1116 03/16/2017 March AP Dumpster Bags 1,135.00 27,006.38 Huber Technology Inc 2971 AP 1191 03/29/2017 March AP Sludge Haul Off 845.00 27,851.38 L.H. CHANEY MATERIALS, INC. 3000 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,696.20 27,851.38 ** 55,000.00 Budgeted 27,148.62 Remaining 51 % Used Account: 135-55135-020-000 Lab Analysis 1116 03/16/2017 March AP Lab supplies 11,499.00 208.00 11,707.00 OXIDOR LABORATORIES LLC 2982 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1116 03/16/2017 March AP Lab supplies 11,499.00 176.00 11,883.00 OXIDOR LABORATORIES LLC 2982 AP 1116 03/16/2017 March AP Lab supplies 405.00 12,288.00 OXIDOR LABORATORIES LLC 2982 AP 1116 03/16/2017 March AP Lab supplies 405.00 12,693.00 OXIDOR LABORATORIES LLC 2982 AP 1116 03/16/2017 March AP Chemicals 246.00 12,939.00 OXIDOR LABORATORIES LLC 2982 AP 1116 03/16/2017 March AP Lab supplies 38.00 12,977.00 OXIDOR LABORATORIES LLC 2982 AP 1191 03/29/2017 March AP Lab supplies 38.00 13,015.00 OXIDOR LABORATORIES LLC 3002 AP 1191 03/29/2017 March AP Lab supplies 176.00 13,191.00 OXIDOR LABORATORIES LLC 3002 AP 1191 03/29/2017 March AP Lab suppliesLab supplies 246.00 13,437.00 OXIDOR LABORATORIES LLC 3002 AP 1191 03/29/2017 March AP Lab supplies 176.00 13,613.00 OXIDOR LABORATORIES LLC 3002 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,114.00 13,613.00 ** 25,000.00 Budgeted 11,387.00 Remaining 54 % Used Account: 135-60010-020-000 Communications/Mobiles 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WAL-MART #0266 2,393.09 39.96 2,433.05 WAL-MART #0266 PC _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 39.96 2,433.05 ** 5,400.00 Budgeted 2,966.95 Remaining 45 % Used Account: 135-60020-020-000 Electricity 1116 03/16/2017 March AP Electricity 2/8-3/9 41,600.13 101.09 41,701.22 HUDSON ENERGY SERVICES, LLC 2972 AP 1116 03/16/2017 March AP Electricity 2/8-3/9 1,229.87 42,931.09 ENGIE Resources LLC 2966 AP 1130 03/20/2017 March AP Electricity 2/8/17-3/9/17 375.22 43,306.31 MP2 ENERGY TEXAS LLC 2979 AP 1291 03/31/2017 Town billed Inv 1555-1561 AR 20170331-20170331 User: (274.16) 43,032.15 AR 1296 03/31/2017 Recode Sewer Elec 12/9-1/10/17 11,111.96 54,144.11 GL 1297 03/31/2017 Recode Sewer Elec 2/8-3/9/17 8,502.18 62,646.29 GL _______________ Account: 135-60020-020-000 Electricity Totals: 21,046.16 62,646.29 ** 158,627.00 Budgeted 95,980.71 Remaining 39 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 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 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 LEVIS OUTLET 322 61.00 199.95 260.95 LEVIS OUTLET 322 PC 1302 03/27/2017 Correct KS Pcard/Levi's Unifor (199.95) 61.00 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1303 03/27/2017 Correct KS PCard/AWWA 61.00 206.00 267.00 GL _______________ Account: 135-60070-020-000 Dues & Memberships Totals: 206.00 267.00 ** 250.00 Budgeted (17.00) Remaining 107 % Used Account: 135-60080-020-000 Schools & Training 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 OMNI HOTELS 1,752.36 555.45 2,307.81 OMNI HOTELS PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 555.45 2,307.81 ** 4,195.00 Budgeted 1,887.19 Remaining 55 % Used Account: 135-60090-020-000 Safety Program 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WHATABURGER 754 Q26 210.54 46.62 257.16 WHATABURGER 754 Q26 PC _______________ Account: 135-60090-020-000 Safety Program Totals: 46.62 257.16 ** 550.00 Budgeted 292.84 Remaining 47 % Used Account: 135-60100-020-000 Travel & per diem 1130 03/20/2017 March AP Tolls to lab 549.85 14.57 564.42 NTTA 2980 AP 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 GLASS PAVILION 57.34 621.76 GLASS PAVILION PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 GLASS PAVILION 94.27 716.03 GLASS PAVILION PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 YO SOUTH PHILLY CHEESE 38.94 754.97 YO SOUTH PHILLY CHEESE PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 STRIPES 0629045600 QPS 13.47 768.44 STRIPES 0629045600 QPS PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 GLASS PAVILION 17.07 785.51 GLASS PAVILION PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 OMNI HOTELS 555.45 1,340.96 OMNI HOTELS PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 OMNI HOTELS 555.45 1,896.41 OMNI HOTELS PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 GLASS PAVILION 57.09 1,953.50 GLASS PAVILION PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 GLASS PAVILION 14.99 1,968.49 GLASS PAVILION PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 LANDRYS CORPUS CHRISTI 111.31 2,079.80 LANDRYS CORPUS CHRISTI PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 CHILI'S WACO RELO 50.41 2,130.21 CHILI'S WACO RELO PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 1,580.36 2,130.21 ** 1,600.00 Budgeted (530.21) Remaining 133 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 4,086.37 .00 4,086.37 _______________ 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 14,565.97 .00 14,565.97 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 14,565.97 ** 17,150.00 Budgeted 2,584.03 Remaining 85 % 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 590.00 .00 590.00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 590.00 ** 6,621.00 Budgeted 6,031.00 Remaining 9 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 11,600.00 Budgeted 11,600.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1282 03/24/2017 Texpool Transfers 54,769.10 10,953.82 65,722.92 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,953.82 65,722.92 ** 120,492.00 Budgeted 54,769.08 Remaining 55 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1282 03/24/2017 Texpool Transfers 270,744.55 54,148.91 324,893.46 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,148.91 324,893.46 ** 595,638.00 Budgeted 270,744.54 Remaining 55 % 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 3,445.02 .00 3,445.02 _______________ Account: 135-65005-020-000 Fuel & Lube Totals: .00 3,445.02 ** 28,088.00 Budgeted 24,642.98 Remaining 12 % Used Account: 135-65010-020-000 Uniforms 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 AWWA.ORG 3,553.92 206.00 3,759.92 AWWA.ORG PC 1302 03/27/2017 Correct KS Pcard/Levi's Unifor 199.95 3,959.87 GL 1303 03/27/2017 Correct KS PCard/AWWA (206.00) 3,753.87 GL _______________ Account: 135-65010-020-000 Uniforms Totals: 199.95 3,753.87 ** 4,459.00 Budgeted 705.13 Remaining 84 % Used Account: 135-65030-020-000 Chemicals 14,942.29 .00 14,942.29 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 14,942.29 ** 25,000.00 Budgeted 10,057.71 Remaining 60 % Used Account: 135-65035-020-000 Small Tools . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 THE HOME DEPOT #6581 856.72 10.93 867.65 THE HOME DEPOT #6581 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 THE HOME DEPOT #6581 164.81 1,032.46 THE HOME DEPOT #6581 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 THE HOME DEPOT #6581 67.72 1,100.18 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 243.46 1,100.18 ** 2,000.00 Budgeted 899.82 Remaining 55 % Used Account: 135-65040-020-000 Safety Equipment 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 THE HOME DEPOT #6581 170.68 81.96 252.64 THE HOME DEPOT #6581 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 81.96 252.64 ** 750.00 Budgeted 497.36 Remaining 34 % Used Account: 135-65045-020-000 Lab Supplies 1018 03/01/2017 March A/P Lab supplies 7,348.82 162.00 7,510.82 LOU'S GLOVES INCORPORATED 2927 AP 1116 03/16/2017 March AP lab supplies 235.89 7,746.71 HACH COMPANY 2970 AP 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 USA BLUE BOOK 42.54 7,789.25 USA BLUE BOOK PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 440.43 7,789.25 ** 14,000.00 Budgeted 6,210.75 Remaining 56 % Used Account: 135-69005-020-000 Capital Outlays 1019 03/03/2017 March AP Blower #4 installation 163,172.90 17,994.50 181,167.40 AIR MAC 2906 AP 1116 03/16/2017 March AP Plant influent pump #2 15,190.00 196,357.40 XYLEM WATER SOLUTIONS USA INC 2988 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 33,184.50 196,357.40 ** 485,000.00 Budgeted 288,642.60 Remaining 40 % Used Department 20 Totals: ----------------------------------- 1,136,083.62 ** 174,996.31 Monthly Total 2,698,015.00 Budgeted 1,561,931.38 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/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 465 03/01/2017 Insurance/Wrk Comp Exp Mar 13.05 2.61 15.66 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.61 15.66 ** 32.00 Budgeted 16.34 Remaining 49 % 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 1,560.00 .00 1,560.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,560.00 ** 4,000.00 Budgeted 2,440.00 Remaining 39 % 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 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/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: ----------------------------------- 3,395.03 ** 2.61 Monthly Total 12,882.00 Budgeted 9,486.97 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 1039 03/10/2017 Mud P/R 03/10/17 Salaries & Wages 145,822.56 19,063.25 164,885.81 PR 1151 03/24/2017 P/R 03.24.17 Salaries & Wages 19,113.04 183,998.85 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 38,176.29 183,998.85 ** 519,883.00 Budgeted 335,884.15 Remaining 35 % Used Account: 135-50010-030-000 Overtime 1039 03/10/2017 Mud P/R 03/10/17 Overtime 1,149.52 466.58 1,616.10 PR 1151 03/24/2017 P/R 03.24.17 Overtime 162.53 1,778.63 PR _______________ Account: 135-50010-030-000 Overtime Totals: 629.11 1,778.63 ** 1,000.00 Budgeted (778.63) Remaining 178 % 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,890.00 Budgeted 472.50 Remaining 88 % Used Account: 135-50020-030-000 Retirement 1039 03/10/2017 Mud P/R 03/10/17 Retirement 13,214.86 1,806.52 15,021.38 PR 1151 03/24/2017 P/R 03.24.17 Retirement 1,782.98 16,804.36 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,589.50 16,804.36 ** 47,768.00 Budgeted 30,963.64 Remaining 35 % Used Account: 135-50026-030-000 Medical Insurance 1039 03/10/2017 Mud P/R 03/10/17 Medical Insurance 15,947.29 2,275.98 18,223.27 PR 1151 03/24/2017 P/R 03.24.17 Medical Insurance 2,275.99 20,499.26 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,551.97 20,499.26 ** 84,289.00 Budgeted 63,789.74 Remaining 24 % Used Account: 135-50027-030-000 Dental Insurance 1039 03/10/2017 Mud P/R 03/10/17 Dental Insurance 1,336.16 208.44 1,544.60 PR 1151 03/24/2017 P/R 03.24.17 Dental Insurance 208.37 1,752.97 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 1,752.97 ** 5,981.00 Budgeted 4,228.03 Remaining 29 % Used Account: 135-50028-030-000 Vision Insurance 1039 03/10/2017 Mud P/R 03/10/17 Vision Insurance 286.57 44.45 331.02 PR 1151 03/24/2017 P/R 03.24.17 Vision Insurance 44.39 375.41 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 88.84 375.41 ** 1,312.00 Budgeted 936.59 Remaining 29 % Used Account: 135-50029-030-000 Life Insurance & Other 1018 03/01/2017 March A/P Misc Insurance 1,517.17 351.06 1,868.23 METLIFE GROUP BENEFITS 2929 AP 1191 03/29/2017 March AP Café 125 Adm Fee 27.16 1,895.39 BenefitMall 2992 AP 1227 03/31/2017 Mar A/P Rounding adjustment (.02) 1,895.37 Legal Shield AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 378.20 1,895.37 ** 5,890.00 Budgeted 3,994.63 Remaining 32 % Used Account: 135-50030-030-000 Social Security Taxes 1039 03/10/2017 Mud P/R 03/10/17 Social Security Taxes 8,790.51 1,161.45 9,951.96 PR 1151 03/24/2017 P/R 03.24.17 Social Security Taxes 1,131.95 11,083.91 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,293.40 11,083.91 ** 32,777.00 Budgeted 21,693.09 Remaining 34 % Used Account: 135-50035-030-000 Medicare Taxes 1039 03/10/2017 Mud P/R 03/10/17 Medicare Taxes 2,055.83 271.64 2,327.47 PR 1151 03/24/2017 P/R 03.24.17 Medicare Taxes 264.71 2,592.18 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 536.35 2,592.18 ** 8,084.00 Budgeted 5,491.82 Remaining 32 % Used Account: 135-50040-030-000 Unemployment Taxes 1039 03/10/2017 Mud P/R 03/10/17 Unemployment Taxes 1,225.15 153.90 1,379.05 PR 1151 03/24/2017 P/R 03.24.17 Unemployment Taxes (1,090.30) 288.75 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: (936.40) 288.75 ** 1,368.00 Budgeted 1,079.25 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 465 03/01/2017 Insurance/Wrk Comp Exp Mar 727.65 145.53 873.18 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 145.53 873.18 ** 1,784.00 Budgeted 910.82 Remaining 49 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 339.35 .00 339.35 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 339.35 ** 500.00 Budgeted 160.65 Remaining 68 % Used Account: 135-50070-030-000 Employee Relations 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WM SUPERCENTER #5247 2,333.24 20.42 2,353.66 WM SUPERCENTER #5247 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 CHICK-FIL-A #03226 30.85 2,384.51 CHICK-FIL-A #03226 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 DONUT HAVEN 18.90 2,403.41 DONUT HAVEN PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 SALAD BOWL 10 59.70 2,463.11 SALAD BOWL 10 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 DONUT HAVEN 8.85 2,471.96 DONUT HAVEN PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 SALAD BOWL 10 99.50 2,571.46 SALAD BOWL 10 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 238.22 2,571.46 ** 4,960.00 Budgeted 2,388.54 Remaining 52 % Used Account: 135-55030-030-000 Software & Support 1018 03/01/2017 March A/P Software and support 53,863.54 1,004.56 54,868.10 STW INC 2935 AP 1116 03/16/2017 March AP Email license 168.00 55,036.10 M3 Networks 2977 AP 1116 03/16/2017 March AP internet 1,036.77 56,072.87 WHOLESALE CARRIER SERVICES INC 2986 AP 1143 03/16/2017 Void M Cruz Inv/wrong coding Meeting recording (90.00) 55,982.87 MIGUEL CRUZ AP 1130 03/20/2017 March AP Scada software 495.00 56,477.87 WIN-911 SOFTWARE 2987 AP 1130 03/20/2017 March AP Meeting recording 90.00 56,567.87 MIGUEL CRUZ AP 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 ATT*BILL PAYMENT 60.37 56,628.24 ATT*BILL PAYMENT PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 ATT*BILL PAYMENT 79.96 56,708.20 ATT*BILL PAYMENT PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 FOTOLIA - NKKLLTJ5QCB5 35.00 56,743.20 FOTOLIA - NKKLLTJ5QCB5 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 ADOBE *IL CREATIVE CLD 19.99 56,763.19 ADOBE *IL CREATIVE CLD PC _______________ Account: 135-55030-030-000 Software & Support Totals: 2,899.65 56,763.19 ** 67,791.00 Budgeted 11,027.81 Remaining 84 % Used Account: 135-55070-030-000 Independent Labor . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1130 03/20/2017 March AP Meeting recording 715.00 127.50 842.50 MIGUEL CRUZ 2963 AP 1145 03/21/2017 Mar A/P Meeting recording 90.00 932.50 MIGUEL CRUZ 2963 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 217.50 932.50 ** 12,000.00 Budgeted 11,067.50 Remaining 8 % Used Account: 135-55080-030-000 Maintenance & Repairs 275.00 .00 275.00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 275.00 ** 7,000.00 Budgeted 6,725.00 Remaining 4 % 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 1018 03/01/2017 March A/P Rug service 4,302.12 130.89 4,433.01 G & K SERVICES 2917 AP 1018 03/01/2017 March A/P Rug service 66.47 4,499.48 G & K SERVICES 2917 AP 1160 03/23/2017 March AP Impact fee-maintenance barn 1,173.00 5,672.48 TROPHY CLUB MUD 2989 AP 1191 03/29/2017 March AP Rug Service 66.47 5,738.95 G & K SERVICES 2995 AP 1191 03/29/2017 March AP Rug service 66.47 5,805.42 G & K SERVICES 2995 AP 1173 03/31/2017 Town A/R Adj/short pay AR 20170331-20170331 User: .02 5,805.44 AR 1291 03/31/2017 Town billed Inv 1555-1561 AR 20170331-20170331 User: (66.47) 5,738.97 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 1,436.85 5,738.97 ** 7,000.00 Budgeted 1,261.03 Remaining 82 % Used Account: 135-55120-030-000 Cleaning Services 1116 03/16/2017 March AP CLeaning services 2,509.24 869.06 3,378.30 MEMBER'S BUILDING MAINTENANCE 2978 AP 1291 03/31/2017 Town billed Inv 1555-1561 AR 20170331-20170331 User: (236.00) 3,142.30 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 3,142.30 ** 10,429.00 Budgeted 7,286.70 Remaining 30 % Used Account: 135-55160-030-000 Professional Outside Services . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 57,332.00 .00 57,332.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 57,332.00 ** 63,325.00 Budgeted 5,993.00 Remaining 91 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 3,219.04 .00 3,219.04 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 3,219.04 ** 8,200.00 Budgeted 4,980.96 Remaining 39 % Used Account: 135-60005-030-000 Telephone 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 ATT*BUS PHONE PMT 5,847.71 846.46 6,694.17 ATT*BUS PHONE PMT PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 ATT*BUS PHONE PMT 440.44 7,134.61 ATT*BUS PHONE PMT PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 RINGCENTRAL, INC 13.94 7,148.55 RINGCENTRAL, INC PC 1191 03/29/2017 March AP Answering service 194.75 7,343.30 KEYSTONE PARK SECRETARIAL 2998 AP 1291 03/31/2017 Town billed Inv 1555-1561 AR 20170331-20170331 User: (454.08) 6,889.22 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,041.51 6,889.22 ** 17,532.00 Budgeted 10,642.78 Remaining 39 % Used Account: 135-60010-030-000 Communications/Mobiles 1151 03/24/2017 P/R 03.24.17 Communications/Mobiles 1,164.95 300.00 1,464.95 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 300.00 1,464.95 ** 4,150.00 Budgeted 2,685.05 Remaining 35 % Used Account: 135-60020-030-000 Electricity/Gas 882.09 .00 882.09 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 882.09 ** 12,631.00 Budgeted 11,748.91 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-60025-030-000 Water 1191 03/29/2017 March AP Water bills 1/26-2/23 442.42 193.27 635.69 TROPHY CLUB MUD (WATER BILLS) 3004 AP 1291 03/31/2017 Town billed Inv 1555-1561 AR 20170331-20170331 User: (99.00) 536.69 AR 1299 03/31/2017 March A/P March Water 198.01 734.70 TROPHY CLUB MUD (WATER BILLS) AP _______________ Account: 135-60025-030-000 Water Totals: 292.28 734.70 ** 1,500.00 Budgeted 765.30 Remaining 49 % Used Account: 135-60035-030-000 Postage 1116 03/16/2017 March AP Overnight letter 11,817.95 8.74 11,826.69 FEDERAL EXPRESS CORP 2968 AP _______________ Account: 135-60035-030-000 Postage Totals: 8.74 11,826.69 ** 28,932.00 Budgeted 17,105.31 Remaining 41 % Used Account: 135-60040-030-000 Service Charges & Fees 1252 03/02/2017 Credit card fees 21,498.37 109.61 21,607.98 GL 1252 03/02/2017 Credit card fees 3,344.48 24,952.46 GL 1040 03/10/2017 Child Support Fee 1.50 24,953.96 GL 1152 03/24/2017 Child Support Fee 1.50 24,955.46 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,457.09 24,955.46 ** 55,560.00 Budgeted 30,604.54 Remaining 45 % 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 465 03/01/2017 Insurance/Wrk Comp Exp Mar 23,322.80 4,664.56 27,987.36 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,664.56 27,987.36 ** 55,692.00 Budgeted 27,704.64 Remaining 50 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 AWWA.ORG 50.88 261.00 311.88 AWWA.ORG PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-60066-030-000 Publications/Books/Subscripts Totals: 261.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 .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education 1116 03/16/2017 March AP Waterfest 1,262.91 550.00 1,812.91 Balance Out Inc 2964 AP 1165 03/25/2017 March A/P Tip for In-N-Out Burger worker 100.00 1,912.91 TROPHY CLUB MUD PETTY CASH 2990 AP 1172 03/27/2017 March A/P Face painting-Water Fest 180.00 2,092.91 Tracy Henry 2991 AP 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 STAPLES 00116533 274.22 2,367.13 STAPLES 00116533 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 PUCKER POWDER 75.80 2,442.93 PUCKER POWDER PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WAL-MART #3286 216.45 2,659.38 WAL-MART #3286 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM (2.04) 2,657.34 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 SAMSCLUB.COM 34.90 2,692.24 SAMSCLUB.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 HOBBY LOBBY #388 6.48 2,698.72 HOBBY LOBBY #388 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WAL-MART #0807 3.76 2,702.48 WAL-MART #0807 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WM SUPERCENTER #2980 1.88 2,704.36 WM SUPERCENTER #2980 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 CUSTOMINK LLC 94.07 2,798.43 CUSTOMINK LLC PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 KELLER TROPHY AND AWAR 71.25 2,869.68 KELLER TROPHY AND AWAR PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM (4.07) 2,865.61 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM (2.04) 2,863.57 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 8.13 2,871.70 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 6.10 2,877.80 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 8.13 2,885.93 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 8.13 2,894.06 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 6.10 2,900.16 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 6.10 2,906.26 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 2.04 2,908.30 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 4.07 2,912.37 WALMART.COM PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 1,262.91 8.13 2,920.50 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 4.07 2,924.57 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 6.10 2,930.67 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 8.13 2,938.80 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 8.12 2,946.92 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 4.07 2,950.99 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WM SUPERCENTER #5247 3.76 2,954.75 WM SUPERCENTER #5247 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 2.04 2,956.79 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 10.16 2,966.95 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 12.19 2,979.14 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WALMART.COM 10.16 2,989.30 WALMART.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WAL-MART #5764 5.64 2,994.94 WAL-MART #5764 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WM SUPERCENTER #940 1.88 2,996.82 WM SUPERCENTER #940 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 NETBRANDS MEDIA CORP. 179.84 3,176.66 NETBRANDS MEDIA CORP. PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 CUSTOMINK LLC 252.44 3,429.10 CUSTOMINK LLC PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 KELLER TROPHY AND AWAR 7.48 3,436.58 KELLER TROPHY AND AWAR PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 RANDALLS STORE00017897 100.00 3,536.58 RANDALLS STORE00017897 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 AMAZON MKTPLACE PMTS 132.68 3,669.26 AMAZON MKTPLACE PMTS PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 NETBRANDS MEDIA CORP. 23.20 3,692.46 NETBRANDS MEDIA CORP. PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 CABELA'S RETAIL 011 109.00 3,801.46 CABELA'S RETAIL 011 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 NETBRANDS MEDIA CORP. 367.78 4,169.24 NETBRANDS MEDIA CORP. PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WM SUPERCENTER #1062 15.04 4,184.28 WM SUPERCENTER #1062 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 BANNERSONTHECHEAP.COM 39.02 4,223.30 BANNERSONTHECHEAP.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 HOBBY LOBBY #388 18.16 4,241.46 HOBBY LOBBY #388 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 SAMS CLUB #4795 15.48 4,256.94 SAMS CLUB #4795 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 TARGET 00017657 25.00 4,281.94 TARGET 00017657 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 AMAZON MKTPLACE PMTS 45.91 4,327.85 AMAZON MKTPLACE PMTS PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 AMAZON MKTPLACE PMTS 49.31 4,377.16 AMAZON MKTPLACE PMTS PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WAL-MART #0807 3.76 4,380.92 WAL-MART #0807 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WAL-MART #0266 9.40 4,390.32 WAL-MART #0266 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WM SUPERCENTER #5080 5.64 4,395.96 WM SUPERCENTER #5080 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WM SUPERCENTER #2980 9.40 4,405.36 WM SUPERCENTER #2980 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 TX WATER DEV BOARD ACC 103.83 4,509.19 TX WATER DEV BOARD ACC PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WAL-MART #3274 69.06 4,578.25 WAL-MART #3274 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WM SUPERCENTER #5247 18.32 4,596.57 WM SUPERCENTER #5247 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 RANDALLS STORE00017897 1.98 4,598.55 RANDALLS STORE00017897 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 OFFICE DEPOT #406 139.98 4,738.53 OFFICE DEPOT #406 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 OFFICE DEPOT #406 61.64 4,800.17 OFFICE DEPOT #406 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 FEDEXOFFICE 00003319 48.16 4,848.33 FEDEXOFFICE 00003319 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 FEDEXOFFICE 00003319 5.01 4,853.34 FEDEXOFFICE 00003319 PC _______________ Account: 135-60079-030-000 Public Education Totals: 3,590.43 4,853.34 ** 8,754.00 Budgeted 3,900.66 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-60080-030-000 Schools & Training 675.00 .00 675.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 675.00 ** 7,840.00 Budgeted 7,165.00 Remaining 9 % Used Account: 135-60100-030-000 Travel & per diem 1042 03/07/2017 March A/P Relocation 1,438.61 5,000.00 6,438.61 Shane Jeff 2939 AP 1039 03/10/2017 Mud P/R 03/10/17 Travel & per diem 132.51 6,571.12 PR 1151 03/24/2017 P/R 03.24.17 Travel & per diem 120.96 6,692.08 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 5,253.47 6,692.08 ** 5,400.00 Budgeted (1,292.08) Remaining 124 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 950.09 .00 950.09 _______________ Account: 135-60125-030-000 Advertising Totals: .00 950.09 ** 7,500.00 Budgeted 6,549.91 Remaining 13 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-60245-030-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 17,500.00 Budgeted 17,500.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 142.36 .00 142.36 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 142.36 ** 1,855.00 Budgeted 1,712.64 Remaining 8 % Used Account: 135-65055-030-000 Hardware 2,239.88 .00 2,239.88 _______________ Account: 135-65055-030-000 Hardware Totals: .00 2,239.88 ** 9,444.00 Budgeted 7,204.12 Remaining 24 % Used Account: 135-65085-030-000 Office Supplies 1116 03/16/2017 March AP Office supplies 2,662.26 75.23 2,737.49 OFFICE DEPOT, INC 2981 AP 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 KELLER TROPHY AND AWAR 20.00 2,757.49 KELLER TROPHY AND AWAR PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 AMAZON MKTPLACE PMTS 53.84 2,811.33 AMAZON MKTPLACE PMTS PC 1191 03/29/2017 March AP Office supplies 101.59 2,912.92 OFFICE DEPOT, INC 3001 AP 1191 03/29/2017 March AP Office supplies 13.99 2,926.91 OFFICE DEPOT, INC 3001 AP 1191 03/29/2017 March AP Office supplies 40.74 2,967.65 OFFICE DEPOT, INC 3001 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 305.39 2,967.65 ** 9,000.00 Budgeted 6,032.35 Remaining 33 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 WAL-MART #5247 1,314.45 30.44 1,344.89 WAL-MART #5247 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 AMAZON MKTPLACE PMTS 29.19 1,374.08 AMAZON MKTPLACE PMTS PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 SAMSCLUB.COM 56.34 1,430.42 SAMSCLUB.COM PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 STAPLES 00116533 6.48 1,436.90 STAPLES 00116533 PC 1234 03/27/2017 Pcard 02/28/17 - 03/27/17 AMAZON MKTPLACE PMTS 17.96 1,454.86 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 140.41 1,454.86 ** 5,000.00 Budgeted 3,545.14 Remaining 29 % Used Account: 135-65105-030-000 Printing 123.00 .00 123.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 123.00 ** 4,800.00 Budgeted 4,677.00 Remaining 3 % Used Account: 135-69005-030-000 Capital Outlays 1299 03/31/2017 March A/P Restroom Renovation 12,977.95 875.00 13,852.95 CP&Y/WALLACE GROUP, INC. AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 875.00 13,852.95 ** 107,001.00 Budgeted 93,148.05 Remaining 13 % Used Account: 135-69170-030-000 Copier Lease Installments 1116 03/16/2017 March AP copier lease 1,730.53 165.00 1,895.53 EVERBANK COMMERCIAL FINANCE 2967 AP 1191 03/29/2017 March AP Copies 137.98 2,033.51 KYOCERA DOCUMENT SOLUTIONS 2999 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 302.98 2,033.51 ** 4,600.00 Budgeted 2,566.49 Remaining 44 % Used Department 30 Totals: ----------------------------------- 493,099.38 ** 75,787.74 Monthly Total 1,295,172.00 Budgeted 802,072.62 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/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 35,967.01 .00 35,967.01 _______________ Account: 135-55045-039-000 Legal Totals: .00 35,967.01 ** 150,000.00 Budgeted 114,032.99 Remaining 24 % 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 1019 03/03/2017 March AP 2nd Qtr DCAD Budget 4,575.71 2,045.87 6,621.58 DENTON CENTRAL APPRAISAL DISTR 2912 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,045.87 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: ----------------------------------- 63,959.27 ** 2,045.87 Monthly Total 188,775.00 Budgeted 124,815.73 Remaining 34 % Used Fund 135 Totals: ----------------------------------- 51,479.16 (51,856.77) Monthly Total (13,456.00) Budgeted (64,935.16) Remaining ########## . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/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 MARCH 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 3,055,554 ACCOUNTS RECEIVABLE - TOTAL ASSETS 3,055,554 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,391,204 NET REVENUES / EXPENDITURES (1,335,650) TOTAL FUND BALANCE 3,055,554 TOTAL LIABILITIES AND FUND BALANCE 3,055,554 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 20:08 04/11/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,691.41- 9,380.10- 9,380.10 Subtotal: 1,691.41- 9,380.10- 9,380.10 Program number: 1,691.41- 9,380.10- 9,380.10 Department number: Revenues 1,691.41- 9,380.10- 9,380.10 Revenues Subtotal ----------- 1,691.41- 9,380.10- 9,380.10 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 20:08 04/11/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 28,248.90 1,345,030.52 1,345,030.52- Subtotal: 28,248.90 1,345,030.52 1,345,030.52- Program number: 28,248.90 1,345,030.52 1,345,030.52- Department number: Wastewater 28,248.90 1,345,030.52 1,345,030.52- Expenditures Subtotal ----------- 28,248.90 1,345,030.52 1,345,030.52- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 26,557.49 1,335,650.42 1,335,650.42- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/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 1256 03/31/2017 Bank Interest March 2017 (7,688.69) (1,691.41) (9,380.10) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,691.41) (9,380.10) ** .00 Budgeted 9,380.10 Remaining 0 % Used Department Totals: ----------------------------------- (9,380.10) ** (1,691.41) Monthly Total .00 Budgeted 9,380.10 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/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 1149 03/22/2017 March AP WWTP App 17 1,316,781.62 28,248.90 1,345,030.52 WEBBER-CADAGUA PARTNERS 2985 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 28,248.90 1,345,030.52 ** .00 Budgeted (1,345,030.52) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,345,030.52 ** 28,248.90 Monthly Total .00 Budgeted (1,345,030.52) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,335,650.42 26,557.49 Monthly Total .00 Budgeted (1,335,650.42) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET MARCH 2017 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 691,249 TOTAL LIABILITIES 691,249 FUND BALANCE ASSIGNED FUND BALANCE 41,831 NET REVENUES / EXPENDITURES (733,080) TOTAL FUND BALANCE (691,249) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 20:08 04/11/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 3/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- 590.72 Subtotal: 590.72- 590.72 Program number: 590.72- 590.72 Department number: Revenues 590.72- 590.72 Revenues Subtotal ----------- 590.72- 590.72 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 20:08 04/11/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 3/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 733,670.38- Subtotal: 733,670.38 733,670.38- Program number: 733,670.38 733,670.38- Department number: Wastewater 733,670.38 733,670.38- Expenditures Subtotal ----------- 733,670.38 733,670.38- Fund number: 518 2015 Revenue Bond Const Fund 733,079.66 733,079.66- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 3/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 (590.72) .00 (590.72) _______________ Account: 518-49010-000-000 Interest Income Totals: .00 (590.72) ** .00 Budgeted 590.72 Remaining 0 % Used Department Totals: ----------------------------------- (590.72) ** .00 Monthly Total .00 Budgeted 590.72 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 3/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 733,670.38 .00 733,670.38 _______________ Account: 518-69005-020-000 Capital Outlays Totals: .00 733,670.38 ** .00 Budgeted (733,670.38) Remaining 0 % Used Department 20 Totals: ----------------------------------- 733,670.38 ** .00 Monthly Total .00 Budgeted (733,670.38) Remaining 0 % Used Fund 518 Totals: ----------------------------------- 733,079.66 .00 Monthly Total .00 Budgeted (733,079.66) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MARCH 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 252,446 ACCOUNTS RECEIVABLE - TOTAL ASSETS 252,446 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 56,684 TOTAL FUND BALANCE 252,446 TOTAL LIABILITIES AND FUND BALANCE 252,446 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 20:08 04/11/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/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- 133.38- 550.86- 183.620 250.86 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- 133.38- 56,683.56- 30.037 132,028.44- Program number: 188,712.00- 188,712.00- 133.38- 56,683.56- 30.037 132,028.44- Department number: 188,712.00- 188,712.00- 133.38- 56,683.56- 30.037 132,028.44- Revenues Subtotal ----------- 188,712.00- 188,712.00- 133.38- 56,683.56- 30.037 132,028.44- Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 133.38- 56,683.56- 30.037 132,028.44- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/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 1256 03/31/2017 Bank Interest March 2017 (417.48) (133.38) (550.86) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (133.38) (550.86) ** (300.00) Budgeted 250.86 Remaining 184 % 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,683.56) ** (133.38) Monthly Total (188,712.00) Budgeted (132,028.44) Remaining 30 % Used Fund 528 Totals: ----------------------------------- (56,683.56) (133.38) Monthly Total (188,712.00) Budgeted (132,028.44) Remaining 30 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND RESERVE BALANCE SHEET MARCH 2017 529 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 86,257 ACCOUNTS RECEIVABLE - TOTAL ASSETS 86,257 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 86,257 TOTAL FUND BALANCE 86,257 TOTAL LIABILITIES AND FUND BALANCE 86,257 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 20:08 04/11/17 Budget Summary with Amendment Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 3/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 529-49010-000-000 Interest Income 40.09- 91.16- 91.16 529-49142-000-000 Interfund transfer in-Water 14,361.00- 86,166.00- 86,166.00 Subtotal: 14,401.09- 86,257.16- 86,257.16 Program number: 14,401.09- 86,257.16- 86,257.16 Department number: 14,401.09- 86,257.16- 86,257.16 Revenues Subtotal ----------- 14,401.09- 86,257.16- 86,257.16 Fund number: 529 2016 Rev Bond Reserve-SWIFT 14,401.09- 86,257.16- 86,257.16 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 3/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 1256 03/31/2017 Bank Interest March 2017 (51.07) (40.09) (91.16) GL _______________ Account: 529-49010-000-000 Interest Income Totals: (40.09) (91.16) ** .00 Budgeted 91.16 Remaining 0 % Used Account: 529-49142-000-000 Interfund transfer in-Water 1282 03/24/2017 Texpool Transfers (71,805.00) (14,361.00) (86,166.00) GL _______________ Account: 529-49142-000-000 Interfund transfer in-Water Totals: (14,361.00) (86,166.00) ** .00 Budgeted 86,166.00 Remaining 0 % Used Department Totals: ----------------------------------- (86,257.16) ** (14,401.09) Monthly Total .00 Budgeted 86,257.16 Remaining 0 % Used Fund 529 Totals: ----------------------------------- (86,257.16) (14,401.09) Monthly Total .00 Budgeted 86,257.16 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET MARCH 2017 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 597,019 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 25,295 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 627,160 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 25,295 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 25,295 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 575,835 TOTAL FUND BALANCE 601,866 TOTAL LIABILITIES AND FUND BALANCE 627,160 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 20:08 04/11/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/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- 5,498.53- 658,734.96- 97.832 14,601.04- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 335.41- 1,242.85- 35.500 2,258.15- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 533.15- 1,000.57- 50.029 999.43- Subtotal: 678,837.00- 678,837.00- 6,367.09- 660,978.38- 97.369 17,858.62- 533-49010-000-000 Interest Income 140.00- 140.00- 311.07- 874.61- 624.721 734.61 533-49015-000-000 Lease/Rental Income 216,754.00- 216,754.00- 216,754.00- 533-49141-000-000 Interfund Trans In-PID Surchg 120,492.00- 120,492.00- 10,953.82- 65,722.92- 54.545 54,769.08- Subtotal: 337,386.00- 337,386.00- 11,264.89- 66,597.53- 19.739 270,788.47- Program number: 1,016,223.00- 1,016,223.00- 17,631.98- 727,575.91- 71.596 288,647.09- Department number: Revenues 1,016,223.00- 1,016,223.00- 17,631.98- 727,575.91- 71.596 288,647.09- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 17,631.98- 727,575.91- 71.596 288,647.09- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 20:08 04/11/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/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- 17,631.98- 575,834.66- ############### 572,744.66 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/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 1258 03/01/2017 Property Taxes (653,236.43) (491.21) (653,727.64) GL 1259 03/03/2017 Property Taxes (46.98) (653,774.62) GL 1260 03/06/2017 Property Taxes (3,091.95) (656,866.57) GL 1261 03/07/2017 Property Taxes (543.05) (657,409.62) GL 1262 03/08/2017 Property Taxes (840.85) (658,250.47) GL 1263 03/09/2017 Property Taxes (1,347.64) (659,598.11) GL 1264 03/10/2017 Property Taxes (183.42) (659,781.53) GL 1265 03/13/2017 Property Taxes (46.36) (659,827.89) GL 1266 03/14/2017 Property Taxes (258.68) (660,086.57) GL 1267 03/15/2017 Property Taxes (95.61) (660,182.18) GL 1268 03/16/2017 Property Taxes (725.86) (660,908.04) GL 1269 03/17/2017 Property Taxes (280.61) (661,188.65) GL 1270 03/20/2017 Property Taxes (204.21) (661,392.86) GL 1271 03/21/2017 Property Taxes (836.25) (662,229.11) GL 1272 03/22/2017 Property Taxes (60.29) (662,289.40) GL 1273 03/23/2017 Property Taxes (188.73) (662,478.13) GL 1274 03/24/2017 Property Taxes (145.08) (662,623.21) GL 1275 03/27/2017 Property Taxes (177.00) (662,800.21) GL 1276 03/28/2017 Property Taxes (150.37) (662,950.58) GL 1277 03/29/2017 Property Taxes 4,497.94 (658,452.64) GL 1278 03/30/2017 Property Taxes (250.27) (658,702.91) GL 1279 03/31/2017 Property Taxes (32.05) (658,734.96) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (5,498.53) (658,734.96) ** (673,336.00) Budgeted (14,601.04) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1260 03/06/2017 Property Taxes (907.44) (198.19) (1,105.63) GL 1261 03/07/2017 Property Taxes (2.07) (1,107.70) GL 1262 03/08/2017 Property Taxes (10.98) (1,118.68) GL 1266 03/14/2017 Property Taxes (156.07) (1,274.75) GL 1277 03/29/2017 Property Taxes 32.05 (1,242.70) GL 1278 03/30/2017 Property Taxes (.15) (1,242.85) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (335.41) (1,242.85) ** (3,501.00) Budgeted (2,258.15) Remaining 35 % Used Account: 533-40015-000-000 Property Taxes/P & I 1258 03/01/2017 Property Taxes (467.42) (34.37) (501.79) GL 1259 03/03/2017 Property Taxes (1.04) (502.83) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1260 03/06/2017 Property Taxes (467.42) (54.46) (557.29) GL 1261 03/07/2017 Property Taxes (39.88) (597.17) GL 1262 03/08/2017 Property Taxes (63.07) (660.24) GL 1263 03/09/2017 Property Taxes (111.67) (771.91) GL 1264 03/10/2017 Property Taxes (13.85) (785.76) GL 1265 03/13/2017 Property Taxes (.56) (786.32) GL 1266 03/14/2017 Property Taxes (45.18) (831.50) GL 1267 03/15/2017 Property Taxes (2.07) (833.57) GL 1268 03/16/2017 Property Taxes (37.57) (871.14) GL 1269 03/17/2017 Property Taxes (20.06) (891.20) GL 1270 03/20/2017 Property Taxes (11.08) (902.28) GL 1271 03/21/2017 Property Taxes (60.49) (962.77) GL 1272 03/22/2017 Property Taxes (5.42) (968.19) GL 1274 03/24/2017 Property Taxes (10.75) (978.94) GL 1275 03/27/2017 Property Taxes (8.31) (987.25) GL 1276 03/28/2017 Property Taxes (.74) (987.99) GL 1277 03/29/2017 Property Taxes (.76) (988.75) GL 1278 03/30/2017 Property Taxes (11.82) (1,000.57) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (533.15) (1,000.57) ** (2,000.00) Budgeted (999.43) Remaining 50 % Used Account: 533-49010-000-000 Interest Income 1256 03/31/2017 Bank Interest March 2017 (563.54) (311.07) (874.61) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (311.07) (874.61) ** (140.00) Budgeted 734.61 Remaining 625 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (216,754.00) Budgeted (216,754.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 1282 03/24/2017 Texpool Transfers (54,769.10) (10,953.82) (65,722.92) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,953.82) (65,722.92) ** (120,492.00) Budgeted (54,769.08) Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ----------------------------------- (727,575.91) ** (17,631.98) Monthly Total (1,016,223.00) Budgeted (288,647.09) Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/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: ----------------------------------- (575,834.66) (17,631.98) Monthly Total (3,090.00) Budgeted 572,744.66 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MARCH 2017 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 224,781 ACCOUNTS RECEIVABLE - TOTAL ASSETS 224,781 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 209,684 TOTAL FUND BALANCE 224,781 TOTAL LIABILITIES AND FUND BALANCE 224,781 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 20:08 04/11/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/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- 98.18- 309.35- 154.675 109.35 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- 324,893.46- 54.545 270,744.54- Subtotal: 892,849.00- 892,849.00- 54,247.09- 325,202.81- 36.423 567,646.19- Program number: 892,849.00- 892,849.00- 54,247.09- 325,202.81- 36.423 567,646.19- Department number: Revenues 892,849.00- 892,849.00- 54,247.09- 325,202.81- 36.423 567,646.19- Revenues Subtotal ----------- 892,849.00- 892,849.00- 54,247.09- 325,202.81- 36.423 567,646.19- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 20:08 04/11/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/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,247.09- 209,684.06- ############### 209,484.06 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/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 1256 03/31/2017 Bank Interest March 2017 (211.17) (98.18) (309.35) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (98.18) (309.35) ** (200.00) Budgeted 109.35 Remaining 155 % 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 1282 03/24/2017 Texpool Transfers (270,744.55) (54,148.91) (324,893.46) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,148.91) (324,893.46) ** (595,638.00) Budgeted (270,744.54) Remaining 55 % Used Department Totals: ----------------------------------- (325,202.81) ** (54,247.09) Monthly Total (892,849.00) Budgeted (567,646.19) Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/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: ----------------------------------- (209,684.06) (54,247.09) Monthly Total (200.00) Budgeted 209,484.06 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET MARCH 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 131,488 ACCOUNTS RECEIVABLE - TOTAL ASSETS 131,488 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 131,488 TOTAL FUND BALANCE 131,488 TOTAL LIABILITIES AND FUND BALANCE 131,488 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 20:08 04/11/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 3/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 52.82- 130.32- 130.32 535-49142-000-000 Interfund Tran In-Water Sales 43,785.76- 131,357.25- 131,357.25 Subtotal: 43,838.58- 131,487.57- 131,487.57 Program number: 43,838.58- 131,487.57- 131,487.57 Department number: Revenues 43,838.58- 131,487.57- 131,487.57 Revenues Subtotal ----------- 43,838.58- 131,487.57- 131,487.57 Fund number: 535 2016 Rev Bond I&S-SWIFT 43,838.58- 131,487.57- 131,487.57 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 20:42 04/11/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 3/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 1256 03/31/2017 Bank Interest March 2017 (77.50) (52.82) (130.32) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (52.82) (130.32) ** .00 Budgeted 130.32 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1282 03/24/2017 Texpool Transfers Feb & Mar Swift Transfer (87,571.49) (43,785.76) (131,357.25) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (43,785.76) (131,357.25) ** .00 Budgeted 131,357.25 Remaining 0 % Used Department Totals: ----------------------------------- (131,487.57) ** (43,838.58) Monthly Total .00 Budgeted 131,487.57 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (131,487.57) (43,838.58) Monthly Total .00 Budgeted 131,487.57 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 401,697.60 **** (114,992.72) Monthly Total (205,458.00) Budgeted (607,155.60) Remaining ########## ******* End of Report *********