Loading...
HomeMy WebLinkAbout2015-05 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MAY 2015 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 936,668 PREPAID EXPENSES 6,396 ADVALOREM PROPERTY TAXES RECEIVABLE 25,807 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 1,604 UTILITY AND OTHER ACCOUNTS RECEIVABLE 507 TOTAL ASSETS 970,982 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 27,411 ACCOUNTS AND OTHER PAYABLES 39,734 TOTAL LIABILITIES 67,145 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 374,927 TOTAL FUND BALANCE 903,837 TOTAL LIABILITIES AND FUND BALANCE 970,982 . glbase_tsam rgonzale Trophy Club MUD #1 Page 1 15:38 06/10/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 357,462.00- 357,462.00- 564.93- 355,650.00- 99.493 1,812.00- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 8,401.96- 8,401.96 122-40010-000-000 Property Taxes/MUD Fire 872,859.00- 872,859.00- 3,913.21- 866,042.18- 99.219 6,816.82- 122-40011-000-000 Property Taxes/Fire-Delinquent 47.36- 3,672.74- 3,672.74 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 5.41- 3,233.16- 431.088 2,483.16 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 242.73- 3,218.55- 71.523 1,281.45- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 4,400.00- 73.333 1,600.00- 122-43400-000-000 Fire Inspections 700.00- 950.00- 825.00- 86.842 125.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 122-49000-000-000 Capital Lease-Oth Fin Sources 807,316.00- 807,316.14- 100.000 .14 122-49035-000-000 Prior Year Reserves 125,669.00- 171,030.00- 125,670.00- 73.478 45,360.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 9,000.00- 8,803.99- 97.822 196.01- Subtotal: 1,383,940.00- 2,239,867.00- 4,773.64- 2,197,233.72- 98.097 42,633.28- Program number: 1,383,940.00- 2,239,867.00- 4,773.64- 2,197,233.72- 98.097 42,633.28- Department number: Fire Revenues 1,383,940.00- 2,239,867.00- 4,773.64- 2,197,233.72- 98.097 42,633.28- Revenues Subtotal ----------- 1,383,940.00- 2,239,867.00- 4,773.64- 2,197,233.72- 98.097 42,633.28- . glbase_tsam rgonzale Trophy Club MUD #1 Page 2 15:38 06/10/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 469,067.00 469,067.00 37,809.67 291,671.74 62.181 177,395.26 122-50010-045-000 Overtime 46,745.00 46,745.00 3,803.79 23,955.44 51.247 22,789.56 122-50011-045-000 DPS Holiday Pay 14,930.00 14,930.00 14,525.69 97.292 404.31 122-50016-045-000 Longevity 5,505.00 5,505.00 5,318.72 96.616 186.28 122-50017-045-000 Certification 4,800.00 4,800.00 437.50 3,281.50 68.365 1,518.50 122-50020-045-000 Retirement 91,396.00 75,327.00 5,541.50 46,520.26 61.758 28,806.74 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,533.11 36,235.83 61.241 22,933.17 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 349.25 2,790.47 63.564 1,599.53 122-50028-045-000 Vision Insurance 811.00 811.00 60.31 486.18 59.948 324.82 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 309.61 2,452.71 60.861 1,577.29 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 2,395.49 19,305.63 57.765 14,115.37 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 560.16 4,514.02 61.904 2,777.98 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 4.21 294.06- -17.747 1,951.06 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 658.99 5,271.96 60.653 3,420.04 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 250.00 122-50075-045-000 Tuition Reimbursement 300.00 300.00 300.00 122-55030-045-000 Software & Support 7,378.00 7,378.00 2,805.17 38.021 4,572.83 122-55045-045-000 Legal 1,500.00 1,500.00 1,500.00 122-55080-045-000 Maintenance & Repairs 18,552.00 18,552.00 494.03 6,030.41 32.505 12,521.59 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 3,152.77 8,670.68 72.256 3,329.32 Subtotal: 791,885.00 775,816.00 60,110.39 473,542.35 61.038 302,273.65 122-60005-045-000 Telephone 50.00 50.00 5.70 39.89 79.780 10.11 122-60010-045-000 Communications/Pagers/Mobiles 5,000.00 6,413.00 112.32 3,511.30 54.753 2,901.70 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 805.13 3,759.28 41.649 5,266.72 122-60025-045-000 Water 1,200.00 1,200.00 192.75 934.71 77.893 265.29 122-60026-045-000 Cable 1,920.00 1,920.00 1,069.11 55.683 850.89 122-60030-045-000 Rent And/Or Usage 211,829.00 211,829.00 211,829.00 100.000 122-60035-045-000 Postage 100.00 100.00 .96 16.43 16.430 83.57 122-60055-045-000 Insurance 12,179.00 12,179.00 940.08 7,520.68 61.751 4,658.32 122-60066-045-000 Publications/Books/Subscrips 200.00 220.00 219.05 99.568 .95 122-60070-045-000 Dues & Memberships 15,180.00 15,689.00 15,418.85 98.278 270.15 122-60080-045-000 Schools & Training 4,280.00 4,280.00 2,524.08 58.974 1,755.92 122-60096-045-000 Emergency Management 1,400.00 1,400.00 220.00 15.714 1,180.00 122-60100-045-000 Travel & per diem 13,577.00 13,577.00 134.37 3,641.35 26.820 9,935.65 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 5,100.00 5,100.00 124.15 2.434 4,975.85 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 500.42 11.120 3,999.58 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 194.00 19.400 806.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 979.60 48.980 1,020.40 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 573.99 57.399 426.01 122-65005-045-000 Fuel & Lube 10,454.00 10,454.00 439.48 3,656.27 34.975 6,797.73 122-65010-045-000 Uniforms 2,000.00 3,000.00 1,634.05 54.468 1,365.95 . glbase_tsam rgonzale Trophy Club MUD #1 Page 3 15:38 06/10/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-65015-045-000 Protective Clothing 5,200.00 35,200.00 9,711.33 14,776.99 41.980 20,423.01 122-65030-045-000 Chemicals 200.00 200.00 133.51 66.755 66.49 122-65035-045-000 Small Tools 2,500.00 2,500.00 164.22 6.569 2,335.78 122-65055-045-000 Hardware 9,000.00 9,000.00 9,000.00 122-65085-045-000 Office Supplies 500.00 500.00 19.52 3.904 480.48 122-65105-045-000 Printing 548.00 548.00 38.17 6.965 509.83 122-69005-045-000 Capital Outlays 1,057,316.00 1,057,316.14 100.000 .14- 122-69008-045-000 Short Term Debt-Principal 158,262.00 122-69009-045-000 Short Term Debt-Interest 50,000.00 122-69050-045-000 Radios 23,500.00 23,500.00 23,500.00 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 17,950.00 17,950.00 100.000 122-69255-045-000 Airpacks 20,400.00 10,400.00 10,400.00 Subtotal: 592,055.00 1,464,051.00 12,342.12 1,348,764.76 92.126 115,286.24 Program number: 1,383,940.00 2,239,867.00 72,452.51 1,822,307.11 81.358 417,559.89 Department number: Fire 1,383,940.00 2,239,867.00 72,452.51 1,822,307.11 81.358 417,559.89 Expenditures Subtotal ----------- 1,383,940.00 2,239,867.00 72,452.51 1,822,307.11 81.358 417,559.89 Fund number: 122 Trophy Club MUD Fire Dept. 67,678.87 374,926.61- 374,926.61 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2015 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 1505 05/11/2015 Property Taxes/Assessments (355,085.07) (149.89) (355,234.96) GL 1506 05/13/2015 Property Taxes/Assessments (71.88) (355,306.84) GL 1533 05/14/2015 Property Taxes/Assessments-Rev 4.99 (355,301.85) GL 1534 05/14/2015 Property Taxes/Assessments (4.99) (355,306.84) GL 1507 05/14/2015 Property Taxes/Assessments (4.99) (355,311.83) GL 1514 05/26/2015 Property Taxes/Assessments (150.23) (355,462.06) GL 1515 05/27/2015 Property Taxes/Assessments (79.68) (355,541.74) GL 1520 05/28/2015 Property Taxes/Assessments (79.62) (355,621.36) GL 1521 05/29/2015 Property Taxes/Assessments (28.64) (355,650.00) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (564.93) (355,650.00) ** (357,462.00) Budgeted (1,812.00) Remaining 99 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1533 05/14/2015 Property Taxes/Assessments-Rev (8,401.96) .65 (8,401.31) GL 1507 05/14/2015 Property Taxes/Assessments (.65) (8,401.96) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (8,401.96) ** .00 Budgeted 8,401.96 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1499 05/01/2015 Property Taxes/Assessments (862,128.97) (39.37) (862,168.34) GL 1500 05/04/2015 Property Taxes/Assessments (236.19) (862,404.53) GL 1501 05/05/2015 Property Taxes/Assessments (827.79) (863,232.32) GL 1503 05/07/2015 Property Taxes/Assessments (29.12) (863,261.44) GL 1504 05/08/2015 Property Taxes/Assessments (38.27) (863,299.71) GL 1505 05/11/2015 Property Taxes/Assessments (133.38) (863,433.09) GL 1506 05/13/2015 Property Taxes/Assessments (106.08) (863,539.17) GL 1508 05/15/2015 Property Taxes/Assessments (324.71) (863,863.88) GL 1509 05/18/2015 Property Taxes/Assessments (148.07) (864,011.95) GL 1510 05/19/2015 Property Taxes/Assessments (107.41) (864,119.36) GL 1511 05/20/2015 Property Taxes/Assessments (204.28) (864,323.64) GL 1512 05/21/2015 Property Taxes/Assessments (182.13) (864,505.77) GL 1513 05/22/2015 Property Taxes/Assessments (226.81) (864,732.58) GL 1514 05/26/2015 Property Taxes/Assessments (933.12) (865,665.70) GL 1515 05/27/2015 Property Taxes/Assessments (7.98) (865,673.68) GL 1520 05/28/2015 Property Taxes/Assessments (256.52) (865,930.20) GL 1521 05/29/2015 Property Taxes/Assessments (111.98) (866,042.18) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,913.21) (866,042.18) ** (872,859.00) Budgeted (6,816.82) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1500 05/04/2015 Property Taxes/Assessments (3,625.38) (.01) (3,625.39) GL 1502 05/06/2015 Property Taxes/Assessments (43.62) (3,669.01) GL 1504 05/08/2015 Property Taxes/Assessments (3.73) (3,672.74) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (47.36) (3,672.74) ** .00 Budgeted 3,672.74 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1534 05/14/2015 Property Taxes/Assessments (3,227.75) (.65) (3,228.40) GL 1514 05/26/2015 Property Taxes/Assessments (1.03) (3,229.43) GL 1521 05/29/2015 Property Taxes/Assessments (3.73) (3,233.16) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (5.41) (3,233.16) ** (750.00) Budgeted 2,483.16 Remaining 431 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1499 05/01/2015 Property Taxes/Assessments (2,975.82) (4.33) (2,980.15) GL 1500 05/04/2015 Property Taxes/Assessments (31.85) (3,012.00) GL 1501 05/05/2015 Property Taxes/Assessments (91.05) (3,103.05) GL 1502 05/06/2015 Property Taxes/Assessments (11.77) (3,114.82) GL 1503 05/07/2015 Property Taxes/Assessments (3.79) (3,118.61) GL 1504 05/08/2015 Property Taxes/Assessments (1.05) (3,119.66) GL 1506 05/13/2015 Property Taxes/Assessments (3.98) (3,123.64) GL 1508 05/15/2015 Property Taxes/Assessments (29.52) (3,153.16) GL 1512 05/21/2015 Property Taxes/Assessments (6.91) (3,160.07) GL 1514 05/26/2015 Property Taxes/Assessments (57.44) (3,217.51) GL 1515 05/27/2015 Property Taxes/Assessments (1.04) (3,218.55) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (242.73) (3,218.55) ** (4,500.00) Budgeted (1,281.45) Remaining 72 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (4,400.00) .00 (4,400.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (4,400.00) ** (6,000.00) Budgeted (1,600.00) Remaining 73 % Used Account: 122-43400-000-000 Fire Inspections . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (825.00) .00 (825.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (825.00) ** (950.00) Budgeted (125.00) Remaining 87 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49000-000-000 Capital Lease-Oth Fin Sources (807,316.14) .00 (807,316.14) _______________ Account: 122-49000-000-000 Capital Lease-Oth Fin Sources Totals: .00 (807,316.14) ** (807,316.00) Budgeted .14 Remaining 100 % Used Account: 122-49035-000-000 Prior Year Reserves (125,670.00) .00 (125,670.00) _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 (125,670.00) ** (171,030.00) Budgeted (45,360.00) Remaining 73 % Used Account: 122-49900-000-000 Miscellaneous Income (8,803.99) .00 (8,803.99) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (8,803.99) ** (9,000.00) Budgeted (196.01) Remaining 98 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,197,233.72) ** (2,239,867.00) Budgeted (42,633.28) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 1355 05/08/2015 FD Payroll 5/8/15 253,862.07 18,135.55 271,997.62 GL 1536 05/22/2015 FD Payroll 5/22/15 19,674.12 291,671.74 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 37,809.67 291,671.74 ** 469,067.00 Budgeted 177,395.26 Remaining 62 % Used Account: 122-50010-045-000 Overtime 1355 05/08/2015 FD Payroll 5/8/15 20,151.65 3,803.79 23,955.44 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,803.79 23,955.44 ** 46,745.00 Budgeted 22,789.56 Remaining 51 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,525.69 .00 14,525.69 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,525.69 ** 14,930.00 Budgeted 404.31 Remaining 97 % Used Account: 122-50016-045-000 Longevity 5,318.72 .00 5,318.72 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,318.72 ** 5,505.00 Budgeted 186.28 Remaining 97 % Used Account: 122-50017-045-000 Certification 1355 05/08/2015 FD Payroll 5/8/15 2,844.00 437.50 3,281.50 GL _______________ Account: 122-50017-045-000 Certification Totals: 437.50 3,281.50 ** 4,800.00 Budgeted 1,518.50 Remaining 68 % Used Account: 122-50020-045-000 Retirement 1355 05/08/2015 FD Payroll 5/8/15 40,978.76 2,976.64 43,955.40 GL 1536 05/22/2015 FD Payroll 5/22/15 2,564.86 46,520.26 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,541.50 46,520.26 ** 75,327.00 Budgeted 28,806.74 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1355 05/08/2015 FD Payroll 5/8/15 31,702.72 2,575.59 34,278.31 GL 1536 05/22/2015 FD Payroll 5/22/15 1,957.52 36,235.83 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,533.11 36,235.83 ** 59,169.00 Budgeted 22,933.17 Remaining 61 % Used Account: 122-50027-045-000 Dental Insurance 1355 05/08/2015 FD Payroll 5/8/15 2,441.22 174.61 2,615.83 GL 1536 05/22/2015 FD Payroll 5/22/15 174.64 2,790.47 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 349.25 2,790.47 ** 4,390.00 Budgeted 1,599.53 Remaining 64 % Used Account: 122-50028-045-000 Vision Insurance 1355 05/08/2015 FD Payroll 5/8/15 425.87 30.17 456.04 GL 1536 05/22/2015 FD Payroll 5/22/15 30.14 486.18 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 60.31 486.18 ** 811.00 Budgeted 324.82 Remaining 60 % Used Account: 122-50029-045-000 Life Insurance & Other 1355 05/08/2015 FD Payroll 5/8/15 2,143.10 154.75 2,297.85 GL 1536 05/22/2015 FD Payroll 5/22/15 154.86 2,452.71 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 309.61 2,452.71 ** 4,030.00 Budgeted 1,577.29 Remaining 61 % Used Account: 122-50030-045-000 Social Security Taxes 1355 05/08/2015 FD Payroll 5/8/15 16,910.14 1,279.19 18,189.33 GL 1536 05/22/2015 FD Payroll 5/22/15 1,116.30 19,305.63 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,395.49 19,305.63 ** 33,421.00 Budgeted 14,115.37 Remaining 58 % Used Account: 122-50035-045-000 Medicare Taxes 1355 05/08/2015 FD Payroll 5/8/15 3,953.86 299.11 4,252.97 GL 1536 05/22/2015 FD Payroll 5/22/15 261.05 4,514.02 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 560.16 4,514.02 ** 7,292.00 Budgeted 2,777.98 Remaining 62 % Used Account: 122-50040-045-000 Unemployment Taxes 1355 05/08/2015 FD Payroll 5/8/15 (298.27) 1.52 (296.75) GL 1536 05/22/2015 FD Payroll 5/22/15 2.69 (294.06) GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 4.21 (294.06) ** 1,657.00 Budgeted 1,951.06 Remaining -18 % Used Account: 122-50045-045-000 Workman's Compensation 198 05/01/2015 May TML Ins & Workers Comp 4,612.97 658.99 5,271.96 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 658.99 5,271.96 ** 8,692.00 Budgeted 3,420.04 Remaining 61 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 2,805.17 .00 2,805.17 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 2,805.17 ** 7,378.00 Budgeted 4,572.83 Remaining 38 % Used Account: 122-55045-045-000 Legal .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 1400 05/18/2015 May A/P Supplies 5,536.38 95.92 5,632.30 COSTCO WHOLESALE 34924 AP 1400 05/18/2015 May A/P Quarterly pest control/Fire St 140.00 5,772.30 GANN'S PEST CONTROL 34929 AP 1487 05/31/2015 May A/P Sam's purchases 193.53 5,965.83 Kari Schultz 34972 AP 1487 05/31/2015 May A/P Rug Service 32.29 5,998.12 G & K SERVICES 34964 AP 1487 05/31/2015 May A/P Rug Cleaning 32.29 6,030.41 G & K SERVICES 34964 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 494.03 6,030.41 ** 18,552.00 Budgeted 12,521.59 Remaining 33 % Used Account: 122-55090-045-000 Vehicle Maintenance 1487 05/31/2015 May A/P Q681, headlights & outriggers 5,517.91 3,152.77 8,670.68 SIDDONS-MARTIN EMERGENCY GROUP 34990 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 3,152.77 8,670.68 ** 12,000.00 Budgeted 3,329.32 Remaining 72 % Used Account: 122-60005-045-000 Telephone 1487 05/31/2015 May A/P BOA charges/Phone 34.19 5.70 39.89 TOWN OF TROPHY CLUB 34994 AP _______________ Account: 122-60005-045-000 Telephone Totals: 5.70 39.89 ** 50.00 Budgeted 10.11 Remaining 80 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1487 05/31/2015 May A/P Verizon, Nevill 3,398.98 112.32 3,511.30 TOWN OF TROPHY CLUB 34994 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 112.32 3,511.30 ** 6,413.00 Budgeted 2,901.70 Remaining 55 % Used Account: 122-60020-045-000 Electricity/Gas 1487 05/31/2015 May A/P Electricity 4/13-5/12 2,954.15 805.13 3,759.28 HUDSON ENERGY SERVICES, LLC 34968 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 805.13 3,759.28 ** 9,026.00 Budgeted 5,266.72 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60025-045-000 Water 1487 05/31/2015 May A/P May Water 741.96 192.75 934.71 TROPHY CLUB MUD (WATER BILLS) 34995 AP _______________ Account: 122-60025-045-000 Water Totals: 192.75 934.71 ** 1,200.00 Budgeted 265.29 Remaining 78 % Used Account: 122-60026-045-000 Cable 1,069.11 .00 1,069.11 _______________ Account: 122-60026-045-000 Cable Totals: .00 1,069.11 ** 1,920.00 Budgeted 850.89 Remaining 56 % Used Account: 122-60030-045-000 Rent And/Or Usage 211,829.00 .00 211,829.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 211,829.00 ** 211,829.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 1494 05/31/2015 MUD Postage meter/May 15.47 .96 16.43 GL _______________ Account: 122-60035-045-000 Postage Totals: .96 16.43 ** 100.00 Budgeted 83.57 Remaining 16 % Used Account: 122-60055-045-000 Insurance 198 05/01/2015 May TML Ins & Workers Comp 6,580.60 940.08 7,520.68 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.08 7,520.68 ** 12,179.00 Budgeted 4,658.32 Remaining 62 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 219.05 .00 219.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 219.05 ** 220.00 Budgeted .95 Remaining 100 % Used Account: 122-60070-045-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 15,418.85 .00 15,418.85 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 15,418.85 ** 15,689.00 Budgeted 270.15 Remaining 98 % Used Account: 122-60080-045-000 Schools & Training 2,524.08 .00 2,524.08 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 2,524.08 ** 4,280.00 Budgeted 1,755.92 Remaining 59 % Used Account: 122-60096-045-000 Emergency Management 220.00 .00 220.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 220.00 ** 1,400.00 Budgeted 1,180.00 Remaining 16 % Used Account: 122-60100-045-000 Travel & per diem 1340 05/06/2015 May A/P Advance for Homeland Security 3,506.98 264.00 3,770.98 Shawn Garrett 34891 AP 1518 05/20/2015 S Garrett/Homeland Sec Conf (129.63) 3,641.35 GL _______________ Account: 122-60100-045-000 Travel & per diem Totals: 134.37 3,641.35 ** 13,577.00 Budgeted 9,935.65 Remaining 27 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 124.15 .00 124.15 _______________ Account: 122-60125-045-000 Advertising Totals: .00 124.15 ** 5,100.00 Budgeted 4,975.85 Remaining 2 % Used Account: 122-60160-045-000 Programs & Special Projects . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 500.42 .00 500.42 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 500.42 ** 4,500.00 Budgeted 3,999.58 Remaining 11 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 194.00 .00 194.00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 194.00 ** 1,000.00 Budgeted 806.00 Remaining 19 % Used Account: 122-60195-045-000 Flags & Repair 979.60 .00 979.60 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 979.60 ** 2,000.00 Budgeted 1,020.40 Remaining 49 % Used Account: 122-60245-045-000 Miscellaneous Expense 573.99 .00 573.99 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 573.99 ** 1,000.00 Budgeted 426.01 Remaining 57 % Used Account: 122-65005-045-000 Fuel & Lube 1487 05/31/2015 May A/P Fuel 3,216.79 439.48 3,656.27 US Bank Voyager Fleet Systems 34996 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 439.48 3,656.27 ** 10,454.00 Budgeted 6,797.73 Remaining 35 % Used Account: 122-65010-045-000 Uniforms 1,634.05 .00 1,634.05 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 1,634.05 ** 3,000.00 Budgeted 1,365.95 Remaining 54 % Used Account: 122-65015-045-000 Protective Clothing 1400 05/18/2015 May A/P PPE Care and Maint services 5,065.66 446.43 5,512.09 Gear Cleaning Solutions, LLC 34930 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1487 05/31/2015 May A/P Replacement PPE 5,065.66 9,264.90 14,776.99 CASCO INDUSTRIES INC 34954 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 9,711.33 14,776.99 ** 35,200.00 Budgeted 20,423.01 Remaining 42 % Used Account: 122-65030-045-000 Chemicals 133.51 .00 133.51 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 133.51 ** 200.00 Budgeted 66.49 Remaining 67 % Used Account: 122-65035-045-000 Small Tools 164.22 .00 164.22 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 164.22 ** 2,500.00 Budgeted 2,335.78 Remaining 7 % Used Account: 122-65055-045-000 Hardware .00 .00 _______________ Account: 122-65055-045-000 Hardware Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies 19.52 .00 19.52 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 19.52 ** 500.00 Budgeted 480.48 Remaining 4 % Used Account: 122-65105-045-000 Printing 38.17 .00 38.17 _______________ Account: 122-65105-045-000 Printing Totals: .00 38.17 ** 548.00 Budgeted 509.83 Remaining 7 % Used Account: 122-69005-045-000 Capital Outlays 1,057,316.14 .00 1,057,316.14 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 1,057,316.14 ** 1,057,316.00 Budgeted (.14) Remaining 100 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 23,500.00 Budgeted 23,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 .00 17,950.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 17,950.00 ** 17,950.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 10,400.00 Budgeted 10,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 1,822,307.11 ** 2,239,867.00 Budgeted 417,559.89 Remaining 81 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (374,926.61) .00 Budgeted 374,926.61 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MAY 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 5/31/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 590,605 - - 590,605 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,507,589 - - 1,507,589 INVESTMENTS-TEXPOOL 1,319,975 169,600 21,458 1,511,032 PREPAID EXPENSES 29,983 - - 29,983 ADVALOREM PROPERTY TAXES RECEIVABLE 4,093 - - 4,093 UTILITY AND OTHER ACCOUNTS RECEIVABLE 536,362 - - 536,362 - TOTAL ASSETS 3,989,207 169,600 21,458 4,180,265 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,093 - - 4,093 ACCOUNTS AND OTHER PAYABLES 596,648 - 13,431 610,079 CUSTOMER DEPOSITS 302,617 - - 302,617 - TOTAL LIABILITIES 903,358 - 13,431 916,789 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 260,697 260,697 NON-SPENDABLE FUND BALANCE 13,980 13,980 ASSIGNED FUND BALANCE 1,409,006 10,268 1,419,274 UNASSIGNED FUND BALANCE 725,069 - - 725,069 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES 937,795 (91,097) (2,241) 844,456 - TOTAL FUND BALANCE 3,085,849 169,600 8,027 3,263,476 - TOTAL LIABILITIES AND FUND BALANCE 3,989,207 169,600 21,458 4,180,265 . glbase_tsam rgonzale Trophy Club MUD #1 Page 4 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 167,857.00- 167,857.00- 752.56- 166,550.88- 99.222 1,306.12- 135-40002-000-000 Property Taxes/Delinquent 5.07- 407.49- 407.49 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 45.59- 546.16- 60.684 353.84- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 11,961.60- 92,666.80- 69.156 41,330.20- 135-47000-000-000 Water 5,286,045.00- 4,747,789.00- 199,711.85- 1,797,495.46- 37.860 2,950,293.54- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 146,268.36- 1,219,838.66- 53.714 1,051,143.34- 135-47025-000-000 Penalties 63,416.00- 80,000.00- 7,979.14- 59,847.21- 74.809 20,152.79- 135-47030-000-000 Service Charges 8,000.00- 10,000.00- 778.00- 7,499.00- 74.990 2,501.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 1,450.00- 72.500 550.00- 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 4,350.00- 87.000 650.00- 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 15,869.00- 18.279 70,946.00- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 135,700.00- 73.750 48,300.00- 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 481.83- 4,003.72- 80.074 996.28- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 7,284.24- 71.667 2,879.76- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 4,083.31- 58.333 2,916.69- 135-49030-000-000 Vending Revenue 351.00- 135-49035-000-000 Prior Year Reserves 929,603.00- 929,603.00- 135-49036-000-000 GASB Reserves 74,706.00- 74,706.00- 74,706.00- 100.000 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 42,000.00- 34,828.83- 82.926 7,171.17- 135-49141-000-000 Interfund Transfer In 19,607.00- 17,160.00- 36,766.50- 187.517 17,159.50 135-49145-000-000 Intergov Transfer In 1,074,337.15- 1,074,337.15 135-49900-000-000 Miscellaneous Income 54,000.00- 68,994.00- 68,985.78- 110,152.59- 159.655 41,158.59 135-49901-000-000 Records Management Revenue 100.00- 100.00- 12.20- 12.200 87.80- Subtotal: 8,444,333.00- 8,846,514.00- 455,040.31- 4,848,395.20- 54.806 3,998,118.80- Program number: 8,444,333.00- 8,846,514.00- 455,040.31- 4,848,395.20- 54.806 3,998,118.80- Department number: Revenues 8,444,333.00- 8,846,514.00- 455,040.31- 4,848,395.20- 54.806 3,998,118.80- Revenues Subtotal ----------- 8,444,333.00- 8,846,514.00- 455,040.31- 4,848,395.20- 54.806 3,998,118.80- . glbase_tsam rgonzale Trophy Club MUD #1 Page 5 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 301,101.00 244,578.00 17,766.34 127,140.71 51.984 117,437.29 135-50010-010-000 Overtime 19,500.00 19,500.00 1,528.23 9,317.20 47.781 10,182.80 135-50016-010-000 Longevity 5,343.00 2,705.00 2,705.00 100.000 135-50017-010-000 Certification 4,800.00 3,900.00 225.00 1,825.00 46.795 2,075.00 135-50020-010-000 Retirement 29,349.00 23,987.00 1,739.19 12,593.40 52.501 11,393.60 135-50026-010-000 Medical Insurance 44,988.00 51,487.00 3,581.43 20,409.92 39.641 31,077.08 135-50027-010-000 Dental Insurance 3,288.00 4,188.00 285.50 1,640.72 39.177 2,547.28 135-50028-010-000 Vision Insurance 834.00 990.00 64.45 376.88 38.069 613.12 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 198.92 1,310.40 42.628 1,763.60 135-50030-010-000 Social Security Taxes 21,135.00 17,192.00 1,182.00 8,619.37 50.136 8,572.63 135-50035-010-000 Medicare Taxes 4,943.00 4,021.00 276.43 2,015.83 50.133 2,005.17 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 2.53 15.69 1.263 1,226.31 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 857.91 5,543.28 34.602 10,476.72 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,300.00 98.00 1,037.25 79.788 262.75 135-50070-010-000 Employee Relations 300.00 300.00 148.18 49.393 151.82 135-55005-010-000 Engineering 10,000.00 10,000.00 10,000.00 135-55080-010-000 Maintenance & Repairs 71,242.00 81,113.00 12,474.55 47,445.11 58.493 33,667.89 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 264.99 4,386.64 54.833 3,613.36 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 264.82 7.566 3,235.18 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 415.00 2,994.80 54.451 2,505.20 Subtotal: 555,159.00 502,597.00 40,960.47 249,790.20 49.700 252,806.80 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 374.63 2,351.43 47.861 2,561.57 135-60020-010-000 Electricity 170,765.00 160,765.00 9,967.07 73,812.19 45.913 86,952.81 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,138.00 4,138.00 722.00 17.448 3,416.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 1,500.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 2,051.30 20,656.61 41.921 28,618.39 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 129,125.19 926,849.16 31.651 2,001,458.84 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 1,265.45 36.156 2,234.55 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 3,500.00 3,500.00 135-65005-010-000 Fuel & Lube 29,172.00 19,173.00 1,074.13 8,022.83 41.844 11,150.17 135-65010-010-000 Uniforms 3,620.00 3,620.00 2,307.77 63.751 1,312.23 135-65030-010-000 Chemicals 7,000.00 10,000.00 1,354.73 7,110.51 71.105 2,889.49 135-65035-010-000 Small Tools 1,200.00 1,200.00 75.00 193.05 16.087 1,006.95 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 457.01 45.701 542.99 135-65050-010-000 Meter Expense 161,500.00 165,000.00 8,130.00 35,314.34 21.403 129,685.66 135-69005-010-000 Capital Outlays 1,089,006.00 1,457,597.00 54,037.59 222,636.75 15.274 1,234,960.25 . glbase_tsam rgonzale Trophy Club MUD #1 Page 6 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69008-010-000 Short Term Debt-Principal 129,000.00 129,000.00 129,000.00 100.000 135-69009-010-000 Short Term Debt-Interest 3,612.00 3,612.00 2,415.58 66.877 1,196.42 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 151,507.00 151,507.00 126,957.76 83.797 24,549.24 Subtotal: 4,820,866.00 5,175,958.00 206,189.64 1,635,072.44 31.590 3,540,885.56 Program number: 5,376,025.00 5,678,555.00 247,150.11 1,884,862.64 33.193 3,793,692.36 . glbase_tsam rgonzale Trophy Club MUD #1 Page 7 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/2015 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 88.49 2,433.75 48.675 2,566.25 Subtotal: 5,000.00 5,000.00 88.49 2,433.75 48.675 2,566.25 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 2,418.75 48.375 2,581.25 Subtotal: 5,000.00 5,000.00 2,418.75 48.375 2,581.25 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 88.49 4,852.50 48.525 5,147.50 Department number: Water 5,386,025.00 5,688,555.00 247,238.60 1,889,715.14 33.220 3,798,839.86 . glbase_tsam rgonzale Trophy Club MUD #1 Page 8 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 305,744.00 307,875.00 23,682.70 188,996.80 61.388 118,878.20 135-50010-020-000 Overtime 19,500.00 24,500.00 1,604.12 19,793.21 80.789 4,706.79 135-50016-020-000 Longevity 5,617.00 5,617.00 5,615.00 99.964 2.00 135-50017-020-000 Certification 6,600.00 6,600.00 500.00 4,350.00 65.909 2,250.00 135-50020-020-000 Retirement 29,948.00 30,317.00 2,297.61 19,543.07 64.462 10,773.93 135-50026-020-000 Medical Insurance 61,001.00 56,244.00 4,686.75 36,991.39 65.769 19,252.61 135-50027-020-000 Dental Insurance 4,146.00 3,696.00 299.51 2,365.49 64.001 1,330.51 135-50028-020-000 Vision Insurance 990.00 912.00 69.00 549.39 60.240 362.61 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 293.59 2,228.66 69.776 965.34 135-50030-020-000 Social Security Taxes 21,680.00 21,812.00 1,436.06 12,251.80 56.170 9,560.20 135-50035-020-000 Medicare Taxes 5,070.00 5,101.00 335.85 2,850.60 55.883 2,250.40 135-50040-020-000 Unemployment Taxes 1,242.00 1,242.00 13.90 1.119 1,228.10 135-50045-020-000 Workman's Compensation 16,020.00 16,020.00 857.91 5,543.28 34.602 10,476.72 135-50060-020-000 Pre-emp Physicals/Testing 150.00 300.00 126.00 42.000 174.00 135-50070-020-000 Employee Relations 550.00 650.00 451.27 69.426 198.73 135-55080-020-000 Maintenance & Repairs 58,000.00 72,600.00 17,050.39 69,658.65 95.949 2,941.35 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 144.00- 3,324.54 110.818 324.54- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 129.18 25.836 370.82 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 2,819.51 36,715.74 66.756 18,284.26 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 1,688.00 17,861.50 71.446 7,138.50 Subtotal: 622,952.00 640,180.00 57,477.00 429,359.47 67.069 210,820.53 135-60010-020-000 Communications/Mobiles 4,662.00 4,662.00 360.22 3,631.70 77.900 1,030.30 135-60020-020-000 Electricity 149,292.00 139,292.00 10,681.00 83,433.31 59.898 55,858.69 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 134.85 33.713 265.15 135-60070-020-000 Dues & Memberships 250.00 250.00 307.00 122.800 57.00- 135-60080-020-000 Schools & Training 4,065.00 3,065.00 1,129.00 36.835 1,936.00 135-60090-020-000 Safety Program 550.00 550.00 550.00 135-60100-020-000 Travel & per diem 1,600.00 2,000.00 5.25 1,796.50 89.825 203.50 135-60105-020-000 Rent/Lease Equipment 9,000.00 7,500.00 1.00 .013 7,499.00 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 9,019.00 52.589 8,131.00 135-60245-020-000 Miscellaneous Expenses 300.00 300.00 300.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 65,255.00 65,255.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 136,989.00 136,989.00 135-60333-020-000 Interfund Transfer Out-Reserve 71,946.00 10,278.00 30,834.00 42.857 41,112.00 135-65005-020-000 Fuel & Lube 36,328.00 20,328.00 1,293.97 12,953.11 63.721 7,374.89 135-65010-020-000 Uniforms 2,778.00 2,778.00 2,598.44 93.536 179.56 135-65030-020-000 Chemicals 30,000.00 24,000.00 3,320.00 13,006.22 54.193 10,993.78 135-65035-020-000 Small Tools 2,000.00 1,500.00 502.25 33.483 997.75 135-65040-020-000 Safety Equipment 750.00 750.00 625.68 83.424 124.32 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 202.16 9,528.79 73.298 3,471.21 135-69005-020-000 Capital Outlays 150,000.00 142,000.00 15,955.29 119,155.64 83.912 22,844.36 . glbase_tsam rgonzale Trophy Club MUD #1 Page 9 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69007-020-000 LTD Payment from WW Sales 357,538.00 135-69008-020-000 Short Term Debt-Principal 56,991.00 56,991.00 21,000.00 36.848 35,991.00 135-69009-020-000 Short Term Debt-Interest 2,011.00 2,011.00 393.23 19.554 1,617.77 Subtotal: 839,165.00 713,217.00 42,095.89 310,049.72 43.472 403,167.28 Program number: 1,462,117.00 1,353,397.00 99,572.89 739,409.19 54.634 613,987.81 Department number: Wastewater 1,462,117.00 1,353,397.00 99,572.89 739,409.19 54.634 613,987.81 . glbase_tsam rgonzale Trophy Club MUD #1 Page 10 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,000.00 7,900.00 79.000 2,100.00 135-50030-026-000 Social Security Taxes 620.00 620.00 62.00 489.80 79.000 130.20 135-50035-026-000 Medicare Taxes 145.00 145.00 14.50 114.55 79.000 30.45 135-50040-026-000 Unemployment Taxes 230.00 230.00 1.00 60.08 26.122 169.92 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 23.52 65.333 12.48 Subtotal: 11,031.00 11,031.00 1,080.44 8,587.95 77.853 2,443.05 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 950.00 176.24 18.552 773.76 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,330.00 33.250 2,670.00 135-60100-026-000 Travel & per diem 5,000.00 4,250.00 259.33 1,589.29 37.395 2,660.71 135-60245-026-000 Miscellaneous Expenses 1,000.00 2,000.00 1,624.74 81.237 375.26 Subtotal: 11,850.00 11,850.00 259.33 4,755.27 40.129 7,094.73 Program number: 22,881.00 22,881.00 1,339.77 13,343.22 58.316 9,537.78 Department number: Board of Directors 22,881.00 22,881.00 1,339.77 13,343.22 58.316 9,537.78 . glbase_tsam rgonzale Trophy Club MUD #1 Page 11 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 477,578.00 470,732.00 35,713.90 288,031.41 61.188 182,700.59 135-50010-030-000 Overtime 1,000.00 1,000.00 25.47 472.25 47.225 527.75 135-50016-030-000 Longevity 3,283.00 3,283.00 3,282.50 99.985 .50 135-50020-030-000 Retirement 42,840.00 42,184.00 3,184.39 26,065.83 61.791 16,118.17 135-50026-030-000 Medical Insurance 65,015.00 62,000.00 5,166.33 38,377.86 61.900 23,622.14 135-50027-030-000 Dental Insurance 4,944.00 4,494.00 364.24 2,734.76 60.854 1,759.24 135-50028-030-000 Vision Insurance 1,158.00 1,116.00 84.38 641.35 57.469 474.65 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 373.14 2,869.95 66.235 1,463.05 135-50030-030-000 Social Security Taxes 30,079.00 29,654.00 2,063.70 17,086.43 57.619 12,567.57 135-50035-030-000 Medicare Taxes 7,422.00 7,317.00 482.62 3,995.99 54.612 3,321.01 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 143.56 9.908 1,305.44 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 698.40 42.689 937.60 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 38.00 7.600 462.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 2,461.64 49.233 2,538.36 135-55030-030-000 Software & Support 75,588.00 121,635.00 1,117.05 96,833.78 79.610 24,801.22 135-55070-030-000 Independent Labor 8,000.00 32,550.00 2,017.50 27,817.50 85.461 4,732.50 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 439.94 439.94 9.776 4,060.06 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 811.28 4,837.48 74.423 1,662.52 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 627.53 4,392.71 54.231 3,707.29 135-55160-030-000 Professional Outside Services 58,000.00 61,950.00 16,599.95 26.796 45,350.05 135-55161-030-000 Town Personnel Contract 6,170.00 26,170.00 26,170.00 100.000 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 577.10 4,330.50 52.811 3,869.50 Subtotal: 821,495.00 904,503.00 53,135.87 568,321.79 62.832 336,181.21 135-60005-030-000 Telephone 13,361.00 13,361.00 385.38 7,252.23 54.279 6,108.77 135-60010-030-000 Communications/Pagers/Mobiles 4,056.00 4,056.00 337.99 2,717.80 67.007 1,338.20 135-60020-030-000 Electricity/Gas 14,978.00 12,000.00 749.98 4,418.66 36.822 7,581.34 135-60025-030-000 Water 1,500.00 1,500.00 112.60 600.65 40.043 899.35 135-60035-030-000 Postage 28,500.00 28,500.00 1,898.27 17,935.82 62.933 10,564.18 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 3,399.86 28,260.06 88.313 3,739.94 135-60050-030-000 Bad Debt Expense 6,200.00 6,200.00 1,284.11 20.711 4,915.89 135-60055-030-000 Insurance 48,751.00 48,751.00 4,113.01 32,708.33 67.093 16,042.67 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,600.00 1,223.77 76.486 376.23 135-60070-030-000 Dues & Memberships 5,000.00 6,000.00 4,055.95 67.599 1,944.05 135-60075-030-000 Meetings 400.00 400.00 60.11 15.028 339.89 135-60079-030-000 Public Education 5,000.00 4,078.00 3,384.79 83.001 693.21 135-60080-030-000 Schools & Training 10,235.00 10,235.00 2,688.00 26.263 7,547.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 350.76 1,181.10 21.872 4,218.90 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60125-030-000 Advertising 2,500.00 2,500.00 3,793.14 151.726 1,293.14- 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 88.99 5,227.92 29.874 12,272.08 . glbase_tsam rgonzale Trophy Club MUD #1 Page 12 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60270-030-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 14,000.00 14,000.00 135-60360-030-000 Furniture/Equipment < $5000 10,475.00 10,475.00 5,035.96 48.076 5,439.04 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,043.00 56.226 812.00 135-65055-030-000 Hardware 75,966.00 35,226.00 33,885.23 96.194 1,340.77 135-65085-030-000 Office Supplies 9,000.00 9,000.00 537.40 4,891.01 54.345 4,108.99 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 1,413.50 29.871 3,318.50 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 536.22 2,950.01 59.000 2,049.99 135-65097-030-000 Vending Machine Supplies 200.00 200.00 200.00 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 135-69005-030-000 Capital Outlays 125,000.00 62,000.00 61,821.66 99.712 178.34 135-69170-030-000 Copier Lease Installments 4,236.00 4,236.00 992.85 2,709.86 63.972 1,526.14 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 16,329.00 16,329.00 100.000 Subtotal: 465,524.00 373,484.00 13,503.31 246,871.67 66.100 126,612.33 Program number: 1,287,019.00 1,277,987.00 66,639.18 815,193.46 63.787 462,793.54 Department number: Administration 1,287,019.00 1,277,987.00 66,639.18 815,193.46 63.787 462,793.54 . glbase_tsam rgonzale Trophy Club MUD #1 Page 13 15:38 06/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 250,000.00 467,403.00 33,234.85- 427,565.09 91.477 39,837.91 135-55055-039-000 Auditing 22,491.00 22,491.00 16,836.00 74.857 5,655.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 6,081.95 60.820 3,918.05 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,456.40 64.642 1,343.60 Subtotal: 286,291.00 503,694.00 33,234.85- 452,939.44 89.924 50,754.56 Program number: 286,291.00 503,694.00 33,234.85- 452,939.44 89.924 50,754.56 Department number: Non Departmental 286,291.00 503,694.00 33,234.85- 452,939.44 89.924 50,754.56 Expenditures Subtotal ----------- 8,444,333.00 8,846,514.00 381,555.59 3,910,600.45 44.205 4,935,913.55 Fund number: 135 MUD 1 General Fund 73,484.72- 937,794.75- 937,794.75 . glbase_tsam rgonzale Trophy Club MUD #1 Page 14 15:38 06/10/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 91,329.00- 91,329.00 137-49146-000-000 Intergov Transfer-Fire Dept 17,950.00- 17,950.00 Subtotal: 109,279.00- 109,279.00 Program number: 109,279.00- 109,279.00 Department number: 109,279.00- 109,279.00 Revenues Subtotal ----------- 109,279.00- 109,279.00 . glbase_tsam rgonzale Trophy Club MUD #1 Page 15 15:38 06/10/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-030-000 GASB Replacement 74,706.00 74,706.00- Subtotal: 74,706.00 74,706.00- Program number: 74,706.00 74,706.00- Department number: Administration 74,706.00 74,706.00- . glbase_tsam rgonzale Trophy Club MUD #1 Page 16 15:38 06/10/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-045-000 GASB Replacement 125,670.00 125,670.00- Subtotal: 125,670.00 125,670.00- Program number: 125,670.00 125,670.00- Department number: Fire Department 125,670.00 125,670.00- Expenditures Subtotal ----------- 200,376.00 200,376.00- Fund number: 137 MUD 1 Consolidated GASB 91,097.00 91,097.00- . glbase_tsam rgonzale Trophy Club MUD #1 Page 17 15:38 06/10/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income .93- 8.59- 8.59 Subtotal: .93- 8.59- 8.59 Program number: .93- 8.59- 8.59 Department number: .93- 8.59- 8.59 Revenues Subtotal ----------- .93- 8.59- 8.59 . glbase_tsam rgonzale Trophy Club MUD #1 Page 18 15:38 06/10/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Subtotal: 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Program number: 3 Indian Creek Waterline 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Department number: Water 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Expenditures Subtotal ----------- 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Fund number: 507 MUD 1 Capital Projects 3,348.00 3,348.00 .93- 2,241.41 66.948 1,106.59 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2015 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 1499 05/01/2015 Property Taxes/Assessments (165,798.32) (7.57) (165,805.89) GL 1500 05/04/2015 Property Taxes/Assessments (45.42) (165,851.31) GL 1501 05/05/2015 Property Taxes/Assessments (159.19) (166,010.50) GL 1503 05/07/2015 Property Taxes/Assessments (5.60) (166,016.10) GL 1504 05/08/2015 Property Taxes/Assessments (7.36) (166,023.46) GL 1505 05/11/2015 Property Taxes/Assessments (25.65) (166,049.11) GL 1506 05/13/2015 Property Taxes/Assessments (20.40) (166,069.51) GL 1508 05/15/2015 Property Taxes/Assessments (62.45) (166,131.96) GL 1509 05/18/2015 Property Taxes/Assessments (28.48) (166,160.44) GL 1510 05/19/2015 Property Taxes/Assessments (20.66) (166,181.10) GL 1511 05/20/2015 Property Taxes/Assessments (39.29) (166,220.39) GL 1512 05/21/2015 Property Taxes/Assessments (35.03) (166,255.42) GL 1513 05/22/2015 Property Taxes/Assessments (43.62) (166,299.04) GL 1514 05/26/2015 Property Taxes/Assessments (179.45) (166,478.49) GL 1515 05/27/2015 Property Taxes/Assessments (1.53) (166,480.02) GL 1520 05/28/2015 Property Taxes/Assessments (49.33) (166,529.35) GL 1521 05/29/2015 Property Taxes/Assessments (21.53) (166,550.88) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (752.56) (166,550.88) ** (167,857.00) Budgeted (1,306.12) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1502 05/06/2015 Property Taxes/Assessments (402.42) (4.67) (407.09) GL 1504 05/08/2015 Property Taxes/Assessments (.40) (407.49) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (5.07) (407.49) ** .00 Budgeted 407.49 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1499 05/01/2015 Property Taxes/Assessments (500.57) (.83) (501.40) GL 1500 05/04/2015 Property Taxes/Assessments (6.13) (507.53) GL 1501 05/05/2015 Property Taxes/Assessments (17.52) (525.05) GL 1502 05/06/2015 Property Taxes/Assessments (1.26) (526.31) GL 1503 05/07/2015 Property Taxes/Assessments (.73) (527.04) GL 1504 05/08/2015 Property Taxes/Assessments (.11) (527.15) GL 1506 05/13/2015 Property Taxes/Assessments (.77) (527.92) GL 1508 05/15/2015 Property Taxes/Assessments (5.67) (533.59) GL 1512 05/21/2015 Property Taxes/Assessments (1.32) (534.91) GL 1514 05/26/2015 Property Taxes/Assessments (11.05) (545.96) GL 1515 05/27/2015 Property Taxes/Assessments (.20) (546.16) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (45.59) (546.16) ** (900.00) Budgeted (353.84) Remaining 61 % Used Account: 135-40025-000-000 PID Surcharges 1443 05/31/2015 UB 5/31/2015 Billing UB20150531-20150531 User: (80,705.20) (11,961.60) (92,666.80) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (11,961.60) (92,666.80) ** (133,997.00) Budgeted (41,330.20) Remaining 69 % Used Account: 135-47000-000-000 Water 1443 05/31/2015 UB 5/31/2015 Billing UB20150531-20150531 User: (1,597,783.61) (199,711.85) (1,797,495.46) UB _______________ Account: 135-47000-000-000 Water Totals: (199,711.85) (1,797,495.46) ** (4,747,789.00) Budgeted (2,950,293.54) Remaining 38 % Used Account: 135-47005-000-000 Sewer 1443 05/31/2015 UB 5/31/2015 Billing UB20150531-20150531 User: (1,073,570.30) (146,268.36) (1,219,838.66) UB _______________ Account: 135-47005-000-000 Sewer Totals: (146,268.36) (1,219,838.66) ** (2,270,982.00) Budgeted (1,051,143.34) Remaining 54 % Used Account: 135-47025-000-000 Penalties 1418 05/21/2015 UB 5/21/2015 Penalties UB20150521-20150521 User: (51,868.07) (8,422.15) (60,290.22) UB 1463 05/22/2015 UB 5/22/15 NSF Check fee UB20150522-20150522 User: (25.00) (60,315.22) UB 1465 05/27/2015 UB 5/27/15 Penalties UB20150527-20150527 User: 34.63 (60,280.59) UB 1435 05/28/2015 UB 5/28/15 Penaty removals UB20150528-20150528 User: 57.98 (60,222.61) UB 1467 05/29/2015 UB 5/29/15 Penalties-cc draft UB20150529-20150529 User: 375.40 (59,847.21) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,979.14) (59,847.21) ** (80,000.00) Budgeted (20,152.79) Remaining 75 % Used Account: 135-47030-000-000 Service Charges 1335 05/06/2015 UB 5/6/15 Cut Off Fees UB20150506-20150506 User: (6,721.00) (725.00) (7,446.00) UB 1456 05/15/2015 UB 5/15/15 NSF Check fee UB20150515-20150515 User: (25.00) (7,471.00) UB 1458 05/19/2015 UB 5/19/15 NSF Check Fee UB20150519-20150519 User: (25.00) (7,496.00) UB 1443 05/31/2015 UB 5/31/2015 Billing UB20150531-20150531 User: (3.00) (7,499.00) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47030-000-000 Service Charges Totals: (778.00) (7,499.00) ** (10,000.00) Budgeted (2,501.00) Remaining 75 % Used Account: 135-47035-000-000 Plumbing Inspections (1,450.00) .00 (1,450.00) _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (1,450.00) ** (2,000.00) Budgeted (550.00) Remaining 73 % Used Account: 135-47045-000-000 Sewer Inspections (4,350.00) .00 (4,350.00) _______________ Account: 135-47045-000-000 Sewer Inspections Totals: .00 (4,350.00) ** (5,000.00) Budgeted (650.00) Remaining 87 % Used Account: 135-47070-000-000 TCCC Effluent Charges (15,869.00) .00 (15,869.00) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (15,869.00) ** (86,815.00) Budgeted (70,946.00) Remaining 18 % Used Account: 135-48005-000-000 Utility Fees (135,700.00) .00 (135,700.00) _______________ Account: 135-48005-000-000 Utility Fees Totals: .00 (135,700.00) ** (184,000.00) Budgeted (48,300.00) Remaining 74 % Used Account: 135-49010-000-000 Interest Income 1532 05/31/2015 Bank Interest/May (3,521.89) (66.32) (3,588.21) GL 1532 05/31/2015 Bank Interest/May (116.12) (3,704.33) GL 1532 05/31/2015 Bank Interest/May (299.39) (4,003.72) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (481.83) (4,003.72) ** (5,000.00) Budgeted (996.28) Remaining 80 % Used Account: 135-49016-000-000 Cell Tower Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1517 05/19/2015 AT&T Cell Tower/May (6,373.71) (910.53) (7,284.24) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (7,284.24) ** (10,164.00) Budgeted (2,879.76) Remaining 72 % Used Account: 135-49018-000-000 Building Rent Income (4,083.31) .00 (4,083.31) _______________ Account: 135-49018-000-000 Building Rent Income Totals: .00 (4,083.31) ** (7,000.00) Budgeted (2,916.69) Remaining 58 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (929,603.00) Budgeted (929,603.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves (74,706.00) .00 (74,706.00) _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 (74,706.00) ** (74,706.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement (34,828.83) .00 (34,828.83) _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 (34,828.83) ** (42,000.00) Budgeted (7,171.17) Remaining 83 % Used Account: 135-49141-000-000 Interfund Transfer In 1519 05/20/2015 Lone Star Auctioneers (19,606.50) (17,160.00) (36,766.50) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: (17,160.00) (36,766.50) ** (19,607.00) Budgeted 17,159.50 Remaining 188 % Used Account: 135-49145-000-000 Intergov Transfer In (1,074,337.15) .00 (1,074,337.15) . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49145-000-000 Intergov Transfer In Totals: .00 (1,074,337.15) ** .00 Budgeted 1,074,337.15 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1384 05/13/2015 Bill Town Inv 1305 AR 20150501-20150513 User: (41,166.81) (51,680.00) (92,846.81) AR 1460 05/19/2015 UB 5/19/15 credit adj UB20150519-20150519 User: (.19) (92,847.00) UB 1519 05/20/2015 Lone Star Auctioneers (3,080.00) (95,927.00) GL 1523 05/20/2015 BDMR Svc Agrmt/Cant Hills,hoga (7,300.00) (103,227.00) GL 1524 05/29/2015 Lone Star Auc/Dodge Truck (6,903.00) (110,130.00) GL 1443 05/31/2015 UB 5/31/2015 Billing UB20150531-20150531 User: (22.59) (110,152.59) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (68,985.78) (110,152.59) ** (68,994.00) Budgeted 41,158.59 Remaining 160 % Used Account: 135-49901-000-000 Records Management Revenue (12.20) .00 (12.20) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (12.20) ** (100.00) Budgeted (87.80) Remaining 12 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4,848,395.20) ** (8,846,514.00) Budgeted (3,998,118.80) Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 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 1325 05/08/2015 MUD Payroll 5/8/15 Salaries & Wages 109,374.37 8,547.97 117,922.34 PR 1408 05/22/2015 MUD Payroll 5/22/15 Salaries & Wages 9,218.37 127,140.71 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 17,766.34 127,140.71 ** 244,578.00 Budgeted 117,437.29 Remaining 52 % Used Account: 135-50010-010-000 Overtime 1325 05/08/2015 MUD Payroll 5/8/15 Overtime 7,788.97 948.70 8,737.67 PR 1408 05/22/2015 MUD Payroll 5/22/15 Overtime 579.53 9,317.20 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,528.23 9,317.20 ** 19,500.00 Budgeted 10,182.80 Remaining 48 % Used Account: 135-50016-010-000 Longevity 2,705.00 .00 2,705.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,705.00 ** 2,705.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1408 05/22/2015 MUD Payroll 5/22/15 Certification 1,600.00 225.00 1,825.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 1,825.00 ** 3,900.00 Budgeted 2,075.00 Remaining 47 % Used Account: 135-50020-010-000 Retirement 1325 05/08/2015 MUD Payroll 5/8/15 Retirement 10,854.21 846.15 11,700.36 PR 1408 05/22/2015 MUD Payroll 5/22/15 Retirement 893.04 12,593.40 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,739.19 12,593.40 ** 23,987.00 Budgeted 11,393.60 Remaining 53 % Used Account: 135-50026-010-000 Medical Insurance 1325 05/08/2015 MUD Payroll 5/8/15 Medical Insurance 16,828.49 1,634.55 18,463.04 PR 1408 05/22/2015 MUD Payroll 5/22/15 Medical Insurance 1,946.88 20,409.92 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,581.43 20,409.92 ** 51,487.00 Budgeted 31,077.08 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 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 1325 05/08/2015 MUD Payroll 5/8/15 Dental Insurance 1,355.22 133.99 1,489.21 PR 1408 05/22/2015 MUD Payroll 5/22/15 Dental Insurance 151.51 1,640.72 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 285.50 1,640.72 ** 4,188.00 Budgeted 2,547.28 Remaining 39 % Used Account: 135-50028-010-000 Vision Insurance 1325 05/08/2015 MUD Payroll 5/8/15 Vision Insurance 312.43 29.94 342.37 PR 1408 05/22/2015 MUD Payroll 5/22/15 Vision Insurance 34.51 376.88 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 64.45 376.88 ** 990.00 Budgeted 613.12 Remaining 38 % Used Account: 135-50029-010-000 Life Insurance & Other 1293 05/01/2015 May A/P May Dental, Vision & Misc insu 1,111.48 190.48 1,301.96 METLIFE GROUP BENEFITS 34880 AP 1487 05/31/2015 May A/P Café 125 admin 8.44 1,310.40 BenefitMall 34951 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 198.92 1,310.40 ** 3,074.00 Budgeted 1,763.60 Remaining 43 % Used Account: 135-50030-010-000 Social Security Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Social Security Taxes 7,437.37 576.47 8,013.84 PR 1408 05/22/2015 MUD Payroll 5/22/15 Social Security Taxes 605.53 8,619.37 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,182.00 8,619.37 ** 17,192.00 Budgeted 8,572.63 Remaining 50 % Used Account: 135-50035-010-000 Medicare Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Medicare Taxes 1,739.40 134.82 1,874.22 PR 1408 05/22/2015 MUD Payroll 5/22/15 Medicare Taxes 141.61 2,015.83 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 276.43 2,015.83 ** 4,021.00 Budgeted 2,005.17 Remaining 50 % Used Account: 135-50040-010-000 Unemployment Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Unemployment Taxes 13.16 1.23 14.39 PR 1408 05/22/2015 MUD Payroll 5/22/15 Unemployment Taxes 1.30 15.69 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 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: 2.53 15.69 ** 1,242.00 Budgeted 1,226.31 Remaining 1 % Used Account: 135-50045-010-000 Workman's Compensation 198 05/01/2015 May TML Ins & Workers Comp 4,685.37 857.91 5,543.28 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.91 5,543.28 ** 16,020.00 Budgeted 10,476.72 Remaining 35 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1487 05/31/2015 May A/P Pre employment testing 939.25 10.00 949.25 FIRST CHECK APPLICANT SCREENIN 34962 AP 1487 05/31/2015 May A/P Chitty 88.00 1,037.25 CARENOW CORPORATE 34953 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 98.00 1,037.25 ** 1,300.00 Budgeted 262.75 Remaining 80 % Used Account: 135-50070-010-000 Employee Relations 148.18 .00 148.18 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 148.18 ** 300.00 Budgeted 151.82 Remaining 49 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1389 05/14/2015 May A/P 250 hp pump #5 34,970.56 9,137.95 44,108.51 PEMSCO 34920 AP 1400 05/18/2015 May A/P Scada 355.00 44,463.51 DHS AUTOMATION, INC 34926 AP 1487 05/31/2015 May A/P SCBA Packs 1,040.02 45,503.53 MUNICIPAL EMERGENCY SERVICES 34981 AP 1491 05/31/2015 May A/P 2" meter box 422.82 45,926.35 HD SUPPLY WATERWORKS, LTD. 34967 AP 1491 05/31/2015 May A/P meter coupling, Valve box, Lid 859.84 46,786.19 HD SUPPLY WATERWORKS, LTD. 34967 AP 1491 05/31/2015 May A/P meter boxes 658.92 47,445.11 HD SUPPLY WATERWORKS, LTD. 34967 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 12,474.55 47,445.11 ** 81,113.00 Budgeted 33,667.89 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-010-000 Vehicle Maintenance 1400 05/18/2015 May A/P R&R Alternator 2002 Ford F150 4,121.65 264.99 4,386.64 MICHAEL G. WATSON 34932 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 264.99 4,386.64 ** 8,000.00 Budgeted 3,613.36 Remaining 55 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 264.82 .00 264.82 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 264.82 ** 3,500.00 Budgeted 3,235.18 Remaining 8 % Used Account: 135-55135-010-000 Lab Analysis 1400 05/18/2015 May A/P Testing 2,579.80 415.00 2,994.80 TARRANT CTY PUBLIC HEALTH LAB 34935 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 415.00 2,994.80 ** 5,500.00 Budgeted 2,505.20 Remaining 54 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1400 05/18/2015 May A/P Cells 4/2-5/1/15 1,976.80 374.63 2,351.43 VERIZON WIRELESS 34942 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 374.63 2,351.43 ** 4,913.00 Budgeted 2,561.57 Remaining 48 % Used Account: 135-60020-010-000 Electricity 1487 05/31/2015 May A/P Electricity 4/13-5/12 63,845.12 3,051.21 66,896.33 HUDSON ENERGY SERVICES, LLC 34968 AP 1487 05/31/2015 May A/P Electricity 4/13-5/12 6,915.86 73,812.19 HUDSON ENERGY SERVICES, LLC 34968 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,967.07 73,812.19 ** 160,765.00 Budgeted 86,952.81 Remaining 46 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 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-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 722.00 .00 722.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 722.00 ** 4,138.00 Budgeted 3,416.00 Remaining 17 % 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 .00 .00 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 1400 05/18/2015 May A/P Qtrly well report 18,605.31 2,051.30 20,656.61 North Texas Groundwater 34933 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 2,051.30 20,656.61 ** 49,275.00 Budgeted 28,618.39 Remaining 42 % Used Account: 135-60150-010-000 Wholesale Water 1487 05/31/2015 May A/P Wholesale water/April 797,723.97 129,125.19 926,849.16 CITY OF FORT WORTH 34955 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60150-010-000 Wholesale Water Totals: 129,125.19 926,849.16 ** 2,928,308.00 Budgeted 2,001,458.84 Remaining 32 % 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 1,265.45 .00 1,265.45 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 1,265.45 ** 3,500.00 Budgeted 2,234.55 Remaining 36 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.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 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 1487 05/31/2015 May A/P Fuel 6,948.70 1,074.13 8,022.83 US Bank Voyager Fleet Systems 34996 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,074.13 8,022.83 ** 19,173.00 Budgeted 11,150.17 Remaining 42 % Used Account: 135-65010-010-000 Uniforms 2,307.77 .00 2,307.77 . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-010-000 Uniforms Totals: .00 2,307.77 ** 3,620.00 Budgeted 1,312.23 Remaining 64 % Used Account: 135-65030-010-000 Chemicals 1487 05/31/2015 May A/P Chlorine 5,755.78 508.25 6,264.03 DPC INDUSTRIES, INC 34959 AP 1487 05/31/2015 May A/P Chemicals 846.48 7,110.51 HACH COMPANY 34965 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,354.73 7,110.51 ** 10,000.00 Budgeted 2,889.49 Remaining 71 % Used Account: 135-65035-010-000 Small Tools 1491 05/31/2015 May A/P Crimping tool 118.05 75.00 193.05 HD SUPPLY WATERWORKS, LTD. 34967 AP _______________ Account: 135-65035-010-000 Small Tools Totals: 75.00 193.05 ** 1,200.00 Budgeted 1,006.95 Remaining 16 % Used Account: 135-65040-010-000 Safety Equipment 457.01 .00 457.01 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 457.01 ** 1,000.00 Budgeted 542.99 Remaining 46 % Used Account: 135-65050-010-000 Meter Expense 1400 05/18/2015 May A/P 15 1" Water meters 27,184.34 4,650.00 31,834.34 ATLAS UTILITY SUPPLY CO. 34922 AP 1487 05/31/2015 May A/P Meter heads & Orions 3,480.00 35,314.34 ATLAS UTILITY SUPPLY CO. 34950 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 8,130.00 35,314.34 ** 165,000.00 Budgeted 129,685.66 Remaining 21 % Used Account: 135-69005-010-000 Capital Outlays 1400 05/18/2015 May A/P Waterline replacement-Pin Oak, 168,599.16 14,109.48 182,708.64 TEAGUE, NALL & PERKINS,INC 34937 AP 1479 05/26/2015 May A/P Valve Replacement 2600 Hwy 114 25,972.67 208,681.31 REY-MAR CONSTRUCTION 34948 AP 1479 05/26/2015 May A/P #7 Campus Circle repair 13,955.44 222,636.75 REY-MAR CONSTRUCTION 34948 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 54,037.59 222,636.75 ** 1,457,597.00 Budgeted 1,234,960.25 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69008-010-000 Short Term Debt-Principal 129,000.00 .00 129,000.00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 129,000.00 ** 129,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 2,415.58 .00 2,415.58 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 2,415.58 ** 3,612.00 Budgeted 1,196.42 Remaining 67 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 126,957.76 .00 126,957.76 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.76 ** 151,507.00 Budgeted 24,549.24 Remaining 84 % Used Account: 135-55135-010-001 Lab Analysis for PID 1400 05/18/2015 May A/P Testing/PID 2,345.26 80.00 2,425.26 TARRANT CTY PUBLIC HEALTH LAB 34936 AP 1487 05/31/2015 May A/P Balance due 8.49 2,433.75 LOWER COLORADO RIVER AUTHORITY 34976 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 88.49 2,433.75 ** 5,000.00 Budgeted 2,566.25 Remaining 49 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID 2,418.75 .00 2,418.75 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 2,418.75 ** 5,000.00 Budgeted 2,581.25 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,889,715.14 ** 5,688,555.00 Budgeted 3,798,839.86 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 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 1325 05/08/2015 MUD Payroll 5/8/15 Salaries & Wages 165,314.10 11,841.35 177,155.45 PR 1408 05/22/2015 MUD Payroll 5/22/15 Salaries & Wages 11,841.35 188,996.80 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 23,682.70 188,996.80 ** 307,875.00 Budgeted 118,878.20 Remaining 61 % Used Account: 135-50010-020-000 Overtime 1325 05/08/2015 MUD Payroll 5/8/15 Overtime 18,189.09 830.76 19,019.85 PR 1408 05/22/2015 MUD Payroll 5/22/15 Overtime 773.36 19,793.21 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,604.12 19,793.21 ** 24,500.00 Budgeted 4,706.79 Remaining 81 % Used Account: 135-50016-020-000 Longevity 5,615.00 .00 5,615.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 5,615.00 ** 5,617.00 Budgeted 2.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1408 05/22/2015 MUD Payroll 5/22/15 Certification 3,850.00 500.00 4,350.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 500.00 4,350.00 ** 6,600.00 Budgeted 2,250.00 Remaining 66 % Used Account: 135-50020-020-000 Retirement 1325 05/08/2015 MUD Payroll 5/8/15 Retirement 17,245.46 1,129.09 18,374.55 PR 1408 05/22/2015 MUD Payroll 5/22/15 Retirement 1,168.52 19,543.07 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,297.61 19,543.07 ** 30,317.00 Budgeted 10,773.93 Remaining 64 % Used Account: 135-50026-020-000 Medical Insurance 1325 05/08/2015 MUD Payroll 5/8/15 Medical Insurance 32,304.64 2,343.40 34,648.04 PR 1408 05/22/2015 MUD Payroll 5/22/15 Medical Insurance 2,343.35 36,991.39 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,686.75 36,991.39 ** 56,244.00 Budgeted 19,252.61 Remaining 66 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 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 1325 05/08/2015 MUD Payroll 5/8/15 Dental Insurance 2,065.98 149.75 2,215.73 PR 1408 05/22/2015 MUD Payroll 5/22/15 Dental Insurance 149.76 2,365.49 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 299.51 2,365.49 ** 3,696.00 Budgeted 1,330.51 Remaining 64 % Used Account: 135-50028-020-000 Vision Insurance 1325 05/08/2015 MUD Payroll 5/8/15 Vision Insurance 480.39 34.48 514.87 PR 1408 05/22/2015 MUD Payroll 5/22/15 Vision Insurance 34.52 549.39 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 69.00 549.39 ** 912.00 Budgeted 362.61 Remaining 60 % Used Account: 135-50029-020-000 Life Insurance & Other 1293 05/01/2015 May A/P May Dental, Vision & Misc insu 1,935.07 259.81 2,194.88 METLIFE GROUP BENEFITS 34880 AP 1487 05/31/2015 May A/P Café 125 admin 33.78 2,228.66 BenefitMall 34951 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 293.59 2,228.66 ** 3,194.00 Budgeted 965.34 Remaining 70 % Used Account: 135-50030-020-000 Social Security Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Social Security Taxes 10,815.74 711.81 11,527.55 PR 1408 05/22/2015 MUD Payroll 5/22/15 Social Security Taxes 724.25 12,251.80 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,436.06 12,251.80 ** 21,812.00 Budgeted 9,560.20 Remaining 56 % Used Account: 135-50035-020-000 Medicare Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Medicare Taxes 2,514.75 166.48 2,681.23 PR 1408 05/22/2015 MUD Payroll 5/22/15 Medicare Taxes 169.37 2,850.60 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 335.85 2,850.60 ** 5,101.00 Budgeted 2,250.40 Remaining 56 % Used Account: 135-50040-020-000 Unemployment Taxes 13.90 .00 13.90 . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 13.90 ** 1,242.00 Budgeted 1,228.10 Remaining 1 % Used Account: 135-50045-020-000 Workman's Compensation 198 05/01/2015 May TML Ins & Workers Comp 4,685.37 857.91 5,543.28 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.91 5,543.28 ** 16,020.00 Budgeted 10,476.72 Remaining 35 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 126.00 .00 126.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 126.00 ** 300.00 Budgeted 174.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 451.27 .00 451.27 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 451.27 ** 650.00 Budgeted 198.73 Remaining 69 % Used Account: 135-55080-020-000 Maintenance & Repairs 1340 05/06/2015 May A/P Remove & Replace overload rela 52,608.26 1,223.39 53,831.65 NORTH TEXAS PUMP CO. 34882 AP 1340 05/06/2015 May A/P 2 hp pump, LS20 1,508.18 55,339.83 NORTH TEXAS PUMP CO. 34882 AP 1479 05/26/2015 May A/P 110 Oakmont Dr-Sewer repair 9,763.82 65,103.65 REY-MAR CONSTRUCTION 34948 AP 1487 05/31/2015 May A/P Hydromatic pump repair Model 6 3,184.47 68,288.12 NORTH TEXAS PUMP CO. 34984 AP 1491 05/31/2015 May A/P Check valve with flapper, gage 1,370.53 69,658.65 ATLAS UTILITY SUPPLY CO. 34950 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 17,050.39 69,658.65 ** 72,600.00 Budgeted 2,941.35 Remaining 96 % Used Account: 135-55090-020-000 Vehicle Maintenance 1342 05/06/2015 Void A/P Ck 34881/Duplicate Chains for WW truck 3,468.54 (144.00) 3,324.54 NAPA AUTO PARTS 34881 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: (144.00) 3,324.54 ** 3,000.00 Budgeted (324.54) Remaining 111 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 129.18 .00 129.18 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 129.18 ** 500.00 Budgeted 370.82 Remaining 26 % Used Account: 135-55125-020-000 Dumpster Services 1487 05/31/2015 May A/P Sludge haul off 33,896.23 2,223.53 36,119.76 L.H. CHANEY MATERIALS, INC. 34974 AP 1491 05/31/2015 May A/P Sludge haul off 595.98 36,715.74 L.H. CHANEY MATERIALS, INC. 34974 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,819.51 36,715.74 ** 55,000.00 Budgeted 18,284.26 Remaining 67 % Used Account: 135-55135-020-000 Lab Analysis 1487 05/31/2015 May A/P Testing 16,173.50 246.00 16,419.50 OXIDOR LABORATORIES LLC 34988 AP 1487 05/31/2015 May A/P Testing 176.00 16,595.50 OXIDOR LABORATORIES LLC 34988 AP 1487 05/31/2015 May A/P Testing 246.00 16,841.50 OXIDOR LABORATORIES LLC 34988 AP 1487 05/31/2015 May A/P Testing 176.00 17,017.50 OXIDOR LABORATORIES LLC 34988 AP 1487 05/31/2015 May A/P Testing 246.00 17,263.50 OXIDOR LABORATORIES LLC 34988 AP 1487 05/31/2015 May A/P Testing 176.00 17,439.50 OXIDOR LABORATORIES LLC 34988 AP 1491 05/31/2015 May A/P Testing 246.00 17,685.50 OXIDOR LABORATORIES LLC 34988 AP 1491 05/31/2015 May A/P Testing 176.00 17,861.50 OXIDOR LABORATORIES LLC 34988 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,688.00 17,861.50 ** 25,000.00 Budgeted 7,138.50 Remaining 71 % Used Account: 135-60010-020-000 Communications/Mobiles 1400 05/18/2015 May A/P Cells 4/2-5/1/15 3,271.48 360.22 3,631.70 VERIZON WIRELESS 34942 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 360.22 3,631.70 ** 4,662.00 Budgeted 1,030.30 Remaining 78 % Used Account: 135-60020-020-000 Electricity 1400 05/18/2015 May A/P Electricity 3/27-4/28/15 72,752.31 327.51 73,079.82 TRI COUNTY ELECTRIC 34941 AP 1400 05/18/2015 May A/P Electricity 3/27-4/28/15 166.85 73,246.67 TRI COUNTY ELECTRIC 34941 AP 1400 05/18/2015 May A/P Electricity 3/27-4/28/15 29.45 73,276.12 TRI COUNTY ELECTRIC 34941 AP 1487 05/31/2015 May A/P Electricity 4/10-5/11 8.84 73,284.96 HUDSON ENERGY SERVICES, LLC 34968 AP 1487 05/31/2015 May A/P Electricity 4/10-5/11 9.11 73,294.07 HUDSON ENERGY SERVICES, LLC 34968 AP 1487 05/31/2015 May A/P Electricity 4/13-5/12 101.60 73,395.67 HUDSON ENERGY SERVICES, LLC 34968 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1487 05/31/2015 May A/P Electricity 4/13-5/12 72,752.31 9,392.85 82,788.52 HUDSON ENERGY SERVICES, LLC 34968 AP 1487 05/31/2015 May A/P Electricity 4/13-5/12 644.79 83,433.31 HUDSON ENERGY SERVICES, LLC 34968 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,681.00 83,433.31 ** 139,292.00 Budgeted 55,858.69 Remaining 60 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 134.85 .00 134.85 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 134.85 ** 400.00 Budgeted 265.15 Remaining 34 % Used Account: 135-60070-020-000 Dues & Memberships 307.00 .00 307.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 307.00 ** 250.00 Budgeted (57.00) Remaining 123 % Used Account: 135-60080-020-000 Schools & Training 1,129.00 .00 1,129.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 1,129.00 ** 3,065.00 Budgeted 1,936.00 Remaining 37 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 1487 05/31/2015 May A/P Toll 1,791.25 5.25 1,796.50 NTTA 34986 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 5.25 1,796.50 ** 2,000.00 Budgeted 203.50 Remaining 90 % Used Account: 135-60105-020-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1.00 .00 1.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1.00 ** 7,500.00 Budgeted 7,499.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 9,019.00 .00 9,019.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 9,019.00 ** 17,150.00 Budgeted 8,131.00 Remaining 53 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S .00 .00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 .00 ** 65,255.00 Budgeted 65,255.00 Remaining 0 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S .00 .00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 .00 ** 136,989.00 Budgeted 136,989.00 Remaining 0 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1527 05/04/2015 Rev Bond Reserve transfer 20,556.00 10,278.00 30,834.00 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1542 05/04/2015 Rev Bond Res Transr-Duplicate 20,556.00 (10,278.00) 20,556.00 GL 1373 05/04/2015 GF to Rev Bond Reserve 10,278.00 30,834.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 30,834.00 ** 71,946.00 Budgeted 41,112.00 Remaining 43 % Used Account: 135-65005-020-000 Fuel & Lube 1487 05/31/2015 May A/P Fuel 11,659.14 1,293.97 12,953.11 US Bank Voyager Fleet Systems 34996 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,293.97 12,953.11 ** 20,328.00 Budgeted 7,374.89 Remaining 64 % Used Account: 135-65010-020-000 Uniforms 2,598.44 .00 2,598.44 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 2,598.44 ** 2,778.00 Budgeted 179.56 Remaining 94 % Used Account: 135-65030-020-000 Chemicals 1491 05/31/2015 May A/P Clarafloc 9,686.22 1,080.00 10,766.22 POLYDYNE, INC 34989 AP 1491 05/31/2015 May A/P Freestyle Calc Hypochlorite 2,240.00 13,006.22 HARCROS CHEMICALS INC 34966 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 3,320.00 13,006.22 ** 24,000.00 Budgeted 10,993.78 Remaining 54 % Used Account: 135-65035-020-000 Small Tools 502.25 .00 502.25 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 502.25 ** 1,500.00 Budgeted 997.75 Remaining 33 % Used Account: 135-65040-020-000 Safety Equipment 625.68 .00 625.68 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 625.68 ** 750.00 Budgeted 124.32 Remaining 83 % Used Account: 135-65045-020-000 Lab Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1487 05/31/2015 May A/P Calibrate MCC=Onsite 9,326.63 202.16 9,528.79 METTLER TOLEDO INTERNATIONAL 34978 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 202.16 9,528.79 ** 13,000.00 Budgeted 3,471.21 Remaining 73 % Used Account: 135-69005-020-000 Capital Outlays 1478 05/26/2015 Retainage/Lift Sta #2 App 1,2 103,200.35 1,970.43 105,170.78 GL 1479 05/26/2015 May A/P App #2 Lift Station #2 13,224.86 118,395.64 REY-MAR CONSTRUCTION 34948 AP 1487 05/31/2015 May A/P LS2, Construction easement 760.00 119,155.64 THE WALLACE GROUP, INC. 34993 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 15,955.29 119,155.64 ** 142,000.00 Budgeted 22,844.36 Remaining 84 % Used Account: 135-69008-020-000 Short Term Debt-Principal 21,000.00 .00 21,000.00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 21,000.00 ** 56,991.00 Budgeted 35,991.00 Remaining 37 % Used Account: 135-69009-020-000 Short Term Debt-Interest 393.23 .00 393.23 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 393.23 ** 2,011.00 Budgeted 1,617.77 Remaining 20 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 739,409.19 ** 1,353,397.00 Budgeted 613,987.81 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2015 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-026-000 Salaries & Wages 1325 05/08/2015 MUD Payroll 5/8/15 Salaries & Wages 6,900.00 1,000.00 7,900.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,000.00 7,900.00 ** 10,000.00 Budgeted 2,100.00 Remaining 79 % Used Account: 135-50030-026-000 Social Security Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Social Security Taxes 427.80 62.00 489.80 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 62.00 489.80 ** 620.00 Budgeted 130.20 Remaining 79 % Used Account: 135-50035-026-000 Medicare Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Medicare Taxes 100.05 14.50 114.55 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 14.50 114.55 ** 145.00 Budgeted 30.45 Remaining 79 % Used Account: 135-50040-026-000 Unemployment Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Unemployment Taxes 59.08 1.00 60.08 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.00 60.08 ** 230.00 Budgeted 169.92 Remaining 26 % Used Account: 135-50045-026-000 Workman's Compensation 198 05/01/2015 May TML Ins & Workers Comp 20.58 2.94 23.52 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 23.52 ** 36.00 Budgeted 12.48 Remaining 65 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 176.24 .00 176.24 _______________ Account: 135-60075-026-000 Meetings Totals: .00 176.24 ** 950.00 Budgeted 773.76 Remaining 19 % Used Account: 135-60080-026-000 Schools & Training 1,330.00 .00 1,330.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,330.00 ** 4,000.00 Budgeted 2,670.00 Remaining 33 % Used Account: 135-60100-026-000 Travel & per diem 1394 05/15/2015 Quick Check 34921 AWBD-Hotel room 1,329.96 228.85 1,558.81 KEVIN CARR 34921 AP 1487 05/31/2015 May A/P Mileaqe reimb/Hart law firm 30.48 1,589.29 Neil Twomey 34982 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 259.33 1,589.29 ** 4,250.00 Budgeted 2,660.71 Remaining 37 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1,624.74 .00 1,624.74 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,624.74 ** 2,000.00 Budgeted 375.26 Remaining 81 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 13,343.22 ** 22,881.00 Budgeted 9,537.78 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 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 1325 05/08/2015 MUD Payroll 5/8/15 Salaries & Wages 252,317.51 17,859.99 270,177.50 PR 1408 05/22/2015 MUD Payroll 5/22/15 Salaries & Wages 17,853.91 288,031.41 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,713.90 288,031.41 ** 470,732.00 Budgeted 182,700.59 Remaining 61 % Used Account: 135-50010-030-000 Overtime 1325 05/08/2015 MUD Payroll 5/8/15 Overtime 446.78 8.95 455.73 PR 1408 05/22/2015 MUD Payroll 5/22/15 Overtime 16.52 472.25 PR _______________ Account: 135-50010-030-000 Overtime Totals: 25.47 472.25 ** 1,000.00 Budgeted 527.75 Remaining 47 % Used Account: 135-50016-030-000 Longevity 3,282.50 .00 3,282.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,282.50 ** 3,283.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1325 05/08/2015 MUD Payroll 5/8/15 Retirement 22,881.44 1,592.12 24,473.56 PR 1408 05/22/2015 MUD Payroll 5/22/15 Retirement 1,592.27 26,065.83 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,184.39 26,065.83 ** 42,184.00 Budgeted 16,118.17 Remaining 62 % Used Account: 135-50026-030-000 Medical Insurance 1325 05/08/2015 MUD Payroll 5/8/15 Medical Insurance 33,211.53 2,583.19 35,794.72 PR 1408 05/22/2015 MUD Payroll 5/22/15 Medical Insurance 2,583.14 38,377.86 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,166.33 38,377.86 ** 62,000.00 Budgeted 23,622.14 Remaining 62 % Used Account: 135-50027-030-000 Dental Insurance 1325 05/08/2015 MUD Payroll 5/8/15 Dental Insurance 2,370.52 182.11 2,552.63 PR 1408 05/22/2015 MUD Payroll 5/22/15 Dental Insurance 182.13 2,734.76 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 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: 364.24 2,734.76 ** 4,494.00 Budgeted 1,759.24 Remaining 61 % Used Account: 135-50028-030-000 Vision Insurance 1325 05/08/2015 MUD Payroll 5/8/15 Vision Insurance 556.97 42.16 599.13 PR 1408 05/22/2015 MUD Payroll 5/22/15 Vision Insurance 42.22 641.35 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 84.38 641.35 ** 1,116.00 Budgeted 474.65 Remaining 57 % Used Account: 135-50029-030-000 Life Insurance & Other 1293 05/01/2015 May A/P May Dental, Vision & Misc insu 2,496.81 339.36 2,836.17 METLIFE GROUP BENEFITS 34880 AP 1487 05/31/2015 May A/P Café 125 admin 33.78 2,869.95 BenefitMall 34951 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 373.14 2,869.95 ** 4,333.00 Budgeted 1,463.05 Remaining 66 % Used Account: 135-50030-030-000 Social Security Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Social Security Taxes 15,022.73 1,037.19 16,059.92 PR 1408 05/22/2015 MUD Payroll 5/22/15 Social Security Taxes 1,026.51 17,086.43 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,063.70 17,086.43 ** 29,654.00 Budgeted 12,567.57 Remaining 58 % Used Account: 135-50035-030-000 Medicare Taxes 1325 05/08/2015 MUD Payroll 5/8/15 Medicare Taxes 3,513.37 242.54 3,755.91 PR 1408 05/22/2015 MUD Payroll 5/22/15 Medicare Taxes 240.08 3,995.99 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 482.62 3,995.99 ** 7,317.00 Budgeted 3,321.01 Remaining 55 % Used Account: 135-50040-030-000 Unemployment Taxes 143.56 .00 143.56 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 143.56 ** 1,449.00 Budgeted 1,305.44 Remaining 10 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 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 198 05/01/2015 May TML Ins & Workers Comp 611.10 87.30 698.40 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 698.40 ** 1,636.00 Budgeted 937.60 Remaining 43 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 38.00 .00 38.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 500.00 Budgeted 462.00 Remaining 8 % Used Account: 135-50070-030-000 Employee Relations 2,461.64 .00 2,461.64 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 2,461.64 ** 5,000.00 Budgeted 2,538.36 Remaining 49 % Used Account: 135-55030-030-000 Software & Support 1400 05/18/2015 May A/P Internet 6/1/15-6/30/15 95,716.73 1,117.05 96,833.78 WHOLESALE CARRIER SERVICES INC 34943 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 1,117.05 96,833.78 ** 121,635.00 Budgeted 24,801.22 Remaining 80 % Used Account: 135-55070-030-000 Independent Labor 1487 05/31/2015 May A/P Rate Study/Model 25,800.00 1,957.50 27,757.50 NEW GEN STRATEGIES & SOLUTIONS 34983 AP 1491 05/31/2015 May A/P Record MUD meeting 60.00 27,817.50 MIGUEL CRUZ 34980 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 2,017.50 27,817.50 ** 32,550.00 Budgeted 4,732.50 Remaining 85 % Used Account: 135-55080-030-000 Maintenance & Repairs 1487 05/31/2015 May A/P Lights @ front desk 439.94 439.94 DENNIS SERVICES LLC 34958 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 439.94 439.94 ** 4,500.00 Budgeted 4,060.06 Remaining 10 % Used Account: 135-55100-030-000 Building Maint & Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1400 05/18/2015 May A/P Window in office installed 4,026.20 275.00 4,301.20 ROANOKE GLASS & MIRROR 34934 AP 1487 05/31/2015 May A/P Clear drain lines 92.00 4,393.20 NORTH TX HEATING & AIR, INC 34985 AP 1487 05/31/2015 May A/P Dispenser/Air Freshener 61.52 4,454.72 G & K SERVICES 34964 AP 1487 05/31/2015 May A/P Rug Service 127.94 4,582.66 G & K SERVICES 34964 AP 1487 05/31/2015 May A/P Rug Service 127.94 4,710.60 G & K SERVICES 34964 AP 1491 05/31/2015 May A/P Re-key doors 126.88 4,837.48 MICHAEL'S KEYS INC. 34979 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 811.28 4,837.48 ** 6,500.00 Budgeted 1,662.52 Remaining 74 % Used Account: 135-55120-030-000 Cleaning Services 1487 05/31/2015 May A/P April Janitorial Service 3,765.18 627.53 4,392.71 MEMBER'S BUILDING MAINTENANCE 34977 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 627.53 4,392.71 ** 8,100.00 Budgeted 3,707.29 Remaining 54 % Used Account: 135-55160-030-000 Professional Outside Services 16,599.95 .00 16,599.95 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 16,599.95 ** 61,950.00 Budgeted 45,350.05 Remaining 27 % Used Account: 135-55161-030-000 Town Personnel Contract 26,170.00 .00 26,170.00 _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 26,170.00 ** 26,170.00 Budgeted .00 Remaining 100 % 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 1400 05/18/2015 May A/P April Water billing 3,753.40 577.10 4,330.50 DATAPROSE LLC 34925 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 577.10 4,330.50 ** 8,200.00 Budgeted 3,869.50 Remaining 53 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-000 Telephone 1487 05/31/2015 May A/P BOA charges/Phone 6,866.85 385.38 7,252.23 TOWN OF TROPHY CLUB 34994 AP _______________ Account: 135-60005-030-000 Telephone Totals: 385.38 7,252.23 ** 13,361.00 Budgeted 6,108.77 Remaining 54 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1400 05/18/2015 May A/P Cells 4/2-5/1/15 2,379.81 37.99 2,417.80 VERIZON WIRELESS 34942 AP 1408 05/22/2015 MUD Payroll 5/22/15 Communications/Pagers/Mobiles 300.00 2,717.80 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 337.99 2,717.80 ** 4,056.00 Budgeted 1,338.20 Remaining 67 % Used Account: 135-60020-030-000 Electricity/Gas 1487 05/31/2015 May A/P Gexa, Nevill 3,668.68 749.98 4,418.66 TOWN OF TROPHY CLUB 34994 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 749.98 4,418.66 ** 12,000.00 Budgeted 7,581.34 Remaining 37 % Used Account: 135-60025-030-000 Water 1487 05/31/2015 May A/P May Water 488.05 112.60 600.65 TROPHY CLUB MUD (WATER BILLS) 34995 AP _______________ Account: 135-60025-030-000 Water Totals: 112.60 600.65 ** 1,500.00 Budgeted 899.35 Remaining 40 % Used Account: 135-60035-030-000 Postage 1400 05/18/2015 May A/P Overnight letter 16,037.55 5.76 16,043.31 FEDERAL EXPRESS CORP 34927 AP 1400 05/18/2015 May A/P April Water billing 1,755.31 17,798.62 DATAPROSE LLC 34925 AP 1487 05/31/2015 May A/P Overnight letter 6.98 17,805.60 FEDERAL EXPRESS CORP 34961 AP 1487 05/31/2015 May A/P overnight letter 4.99 17,810.59 FEDERAL EXPRESS CORP 34961 AP 1494 05/31/2015 MUD Postage meter/May 125.23 17,935.82 GL _______________ Account: 135-60035-030-000 Postage Totals: 1,898.27 17,935.82 ** 28,500.00 Budgeted 10,564.18 Remaining 63 % Used Account: 135-60040-030-000 Service Charges & Fees 1538 05/04/2015 Credit Card Fees/April 24,860.20 68.63 24,928.83 GL 1538 05/04/2015 Credit Card Fees/April 106.45 25,035.28 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1538 05/04/2015 Credit Card Fees/April 24,860.20 2,974.78 28,010.06 GL 1531 05/19/2015 Bank Analysis Fee- Apr 250.00 28,260.06 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,399.86 28,260.06 ** 32,000.00 Budgeted 3,739.94 Remaining 88 % Used Account: 135-60050-030-000 Bad Debt Expense 1,284.11 .00 1,284.11 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 1,284.11 ** 6,200.00 Budgeted 4,915.89 Remaining 21 % Used Account: 135-60055-030-000 Insurance 198 05/01/2015 May TML Ins & Workers Comp 28,595.32 4,063.01 32,658.33 GL 1487 05/31/2015 May A/P Bond/McIntire 50.00 32,708.33 VICTOR O SCHINNERER & CO, INC 34997 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,113.01 32,708.33 ** 48,751.00 Budgeted 16,042.67 Remaining 67 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1,223.77 .00 1,223.77 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 1,223.77 ** 1,600.00 Budgeted 376.23 Remaining 76 % Used Account: 135-60070-030-000 Dues & Memberships 4,055.95 .00 4,055.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,055.95 ** 6,000.00 Budgeted 1,944.05 Remaining 68 % Used Account: 135-60075-030-000 Meetings 60.11 .00 60.11 _______________ Account: 135-60075-030-000 Meetings Totals: .00 60.11 ** 400.00 Budgeted 339.89 Remaining 15 % Used Account: 135-60079-030-000 Public Education . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 3,384.79 .00 3,384.79 _______________ Account: 135-60079-030-000 Public Education Totals: .00 3,384.79 ** 4,078.00 Budgeted 693.21 Remaining 83 % Used Account: 135-60080-030-000 Schools & Training 2,688.00 .00 2,688.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,688.00 ** 10,235.00 Budgeted 7,547.00 Remaining 26 % Used Account: 135-60100-030-000 Travel & per diem 1325 05/08/2015 MUD Payroll 5/8/15 Travel & per diem 830.34 20.13 850.47 PR 1408 05/22/2015 MUD Payroll 5/22/15 Travel & per diem 30.48 880.95 PR 1487 05/31/2015 May A/P Mileage reimb/HR school 300.15 1,181.10 Terri Sisk 34992 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 350.76 1,181.10 ** 5,400.00 Budgeted 4,218.90 Remaining 22 % 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-60125-030-000 Advertising 3,793.14 .00 3,793.14 _______________ Account: 135-60125-030-000 Advertising Totals: .00 3,793.14 ** 2,500.00 Budgeted (1,293.14) Remaining 152 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1487 05/31/2015 May A/P supplies, cake for ground brea 5,138.93 18.99 5,157.92 COSTCO WHOLESALE 34957 AP 1487 05/31/2015 May A/P Sam's purchases 70.00 5,227.92 Kari Schultz 34972 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 88.99 5,227.92 ** 17,500.00 Budgeted 12,272.08 Remaining 30 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) .00 .00 _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: .00 .00 ** 14,000.00 Budgeted 14,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 5,035.96 .00 5,035.96 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 5,035.96 ** 10,475.00 Budgeted 5,439.04 Remaining 48 % Used Account: 135-65010-030-000 Uniforms 1,043.00 .00 1,043.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 1,043.00 ** 1,855.00 Budgeted 812.00 Remaining 56 % Used Account: 135-65055-030-000 Hardware 33,885.23 .00 33,885.23 _______________ Account: 135-65055-030-000 Hardware Totals: .00 33,885.23 ** 35,226.00 Budgeted 1,340.77 Remaining 96 % Used Account: 135-65085-030-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1400 05/18/2015 May A/P March JPChase 4,353.61 74.92 4,428.53 TOWN OF TROPHY CLUB 34940 AP 1487 05/31/2015 May A/P April JMPC Charges 56.19 4,484.72 TOWN OF TROPHY CLUB 34994 AP 1487 05/31/2015 May A/P Surge outlet 45.49 4,530.21 OFFICE DEPOT, INC 34987 AP 1487 05/31/2015 May A/P Labels 11.99 4,542.20 OFFICE DEPOT, INC 34987 AP 1487 05/31/2015 May A/P Return labels (11.99) 4,530.21 OFFICE DEPOT, INC 34987 AP 1487 05/31/2015 May A/P Cabinet for supplies 309.98 4,840.19 OFFICE DEPOT, INC 34987 AP 1487 05/31/2015 May A/P Office Supplies 50.82 4,891.01 OFFICE DEPOT, INC 34987 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 537.40 4,891.01 ** 9,000.00 Budgeted 4,108.99 Remaining 54 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1,413.50 .00 1,413.50 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 1,413.50 ** 4,732.00 Budgeted 3,318.50 Remaining 30 % Used Account: 135-65095-030-000 Maintenance Supplies 1400 05/18/2015 May A/P Supplies 2,413.79 59.34 2,473.13 COSTCO WHOLESALE 34924 AP 1400 05/18/2015 May A/P Supplies 12.81 2,485.94 COSTCO WHOLESALE 34924 AP 1487 05/31/2015 May A/P supplies, cake for ground brea 119.05 2,604.99 COSTCO WHOLESALE 34957 AP 1487 05/31/2015 May A/P Sam's purchases 345.02 2,950.01 Kari Schultz 34972 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 536.22 2,950.01 ** 5,000.00 Budgeted 2,049.99 Remaining 59 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 61,821.66 .00 61,821.66 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 61,821.66 ** 62,000.00 Budgeted 178.34 Remaining 100 % Used Account: 135-69170-030-000 Copier Lease Installments 1487 05/31/2015 May A/P Verizon, Nevill 1,717.01 714.52 2,431.53 TOWN OF TROPHY CLUB 34994 AP 1487 05/31/2015 May A/P Gexa, Nevill 278.33 2,709.86 TOWN OF TROPHY CLUB 34994 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 992.85 2,709.86 ** 4,236.00 Budgeted 1,526.14 Remaining 64 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 .00 16,329.00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 16,329.00 ** 16,329.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 815,193.46 ** 1,277,987.00 Budgeted 462,793.54 Remaining 64 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2015 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 1400 05/18/2015 May A/P April legal 460,799.94 13,830.00 474,629.94 FREEMAN & CORBETT 34928 AP 1400 05/18/2015 May A/P April Legal 4,275.25 478,905.19 THE LISTON LAW FIRM, P.C. 34938 AP 1400 05/18/2015 May A/P April Legal 7,668.75 486,573.94 THE LISTON LAW FIRM, P.C. 34938 AP 1484 05/18/2015 Void AP check 34928/Freeman April legal (13,830.00) 472,743.94 FREEMAN & CORBETT 34928 AP 1516 05/19/2015 Maguire Partners Solana Land Reimb Legal/Waterline reloc (84,062.00) 388,681.94 GL 1487 05/31/2015 May A/P Legal 5,280.00 393,961.94 FREEMAN & CORBETT 34963 AP 1487 05/31/2015 May A/P Legal/Annex bldg 940.80 394,902.74 WHITAKER CHALK SWINDLE 34998 AP 1487 05/31/2015 May A/P Legal/General 588.00 395,490.74 WHITAKER CHALK SWINDLE 34998 AP 1487 05/31/2015 May A/P Legal/MP Solana Land 29,066.53 424,557.27 WHITAKER CHALK SWINDLE 34998 AP 1487 05/31/2015 May A/P Legal 1,083.00 425,640.27 WHITAKER CHALK SWINDLE 34998 AP 1487 05/31/2015 May A/P Legal/BDMR 1,924.82 427,565.09 WHITAKER CHALK SWINDLE 34998 AP _______________ Account: 135-55045-039-000 Legal Totals: (33,234.85) 427,565.09 ** 467,403.00 Budgeted 39,837.91 Remaining 91 % Used Account: 135-55055-039-000 Auditing 16,836.00 .00 16,836.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 16,836.00 ** 22,491.00 Budgeted 5,655.00 Remaining 75 % Used Account: 135-55060-039-000 Appraisal 6,081.95 .00 6,081.95 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,081.95 ** 10,000.00 Budgeted 3,918.05 Remaining 61 % Used Account: 135-55065-039-000 Tax Admin Fees 2,456.40 .00 2,456.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,456.40 ** 3,800.00 Budgeted 1,343.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 452,939.44 ** 503,694.00 Budgeted 50,754.56 Remaining 90 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (937,794.75) .00 Budgeted 937,794.75 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/2015 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 (91,329.00) .00 (91,329.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (91,329.00) ** .00 Budgeted 91,329.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (17,950.00) .00 (17,950.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (17,950.00) ** .00 Budgeted 17,950.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (109,279.00) ** .00 Budgeted 109,279.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-030-000 GASB Replacement 74,706.00 .00 74,706.00 _______________ Account: 137-69195-030-000 GASB Replacement Totals: .00 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-045-000 GASB Replacement 125,670.00 .00 125,670.00 _______________ Account: 137-69195-045-000 GASB Replacement Totals: .00 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ 91,097.00 .00 Budgeted (91,097.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 1532 05/31/2015 Bank Interest/May (7.66) (.93) (8.59) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (.93) (8.59) ** .00 Budgeted 8.59 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (8.59) ** .00 Budgeted 8.59 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 2,250.00 .00 2,250.00 _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: .00 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 2,241.41 3,348.00 Budgeted 1,106.59 Remaining 67 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET MAY 2015 517 ASSETS TAX BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 4,377,550 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,377,550 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 4,377,550 TOTAL FUND BALANCE 4,377,550 TOTAL LIABILITIES AND FUND BALANCE 4,377,550 . glbase_tsam rgonzale Trophy Club MUD #1 Page 19 15:38 06/10/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 205.51- 965.92- 965.92 517-49105-000-000 Bond Proceeds 5,765,000.00- 5,765,000.00 Subtotal: 205.51- 5,765,965.92- 5,765,965.92 Program number: 205.51- 5,765,965.92- 5,765,965.92 Department number: Revenues 205.51- 5,765,965.92- 5,765,965.92 Revenues Subtotal ----------- 205.51- 5,765,965.92- 5,765,965.92 . glbase_tsam rgonzale Trophy Club MUD #1 Page 20 15:38 06/10/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60135-020-000 TCEQ Permits & Fees 14,376.56 14,376.56- 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 1,074,337.15- 517-69005-020-000 Capital Outlays 151,502.50 151,502.50- Subtotal: 1,240,216.21 1,240,216.21- 517-70020-020-000 Bond Issuance 148,200.00 148,200.00- Subtotal: 148,200.00 148,200.00- Program number: 1,388,416.21 1,388,416.21- Department number: Wastewater 1,388,416.21 1,388,416.21- Expenditures Subtotal ----------- 1,388,416.21 1,388,416.21- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 205.51- 4,377,549.71- 4,377,549.71 . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/2015 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 1532 05/31/2015 Bank Interest/May (760.41) (205.51) (965.92) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (205.51) (965.92) ** .00 Budgeted 965.92 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds (5,765,000.00) .00 (5,765,000.00) _______________ Account: 517-49105-000-000 Bond Proceeds Totals: .00 (5,765,000.00) ** .00 Budgeted 5,765,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,765,965.92) ** .00 Budgeted 5,765,965.92 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-60135-020-000 TCEQ Permits & Fees 14,376.56 .00 14,376.56 _______________ Account: 517-60135-020-000 TCEQ Permits & Fees Totals: .00 14,376.56 ** .00 Budgeted (14,376.56) Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 .00 1,074,337.15 _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 1,074,337.15 ** .00 Budgeted (1,074,337.15) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 151,502.50 .00 151,502.50 _______________ Account: 517-69005-020-000 Capital Outlays Totals: .00 151,502.50 ** .00 Budgeted (151,502.50) Remaining 0 % Used Account: 517-70020-020-000 Bond Issuance 148,200.00 .00 148,200.00 _______________ Account: 517-70020-020-000 Bond Issuance Totals: .00 148,200.00 ** .00 Budgeted (148,200.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,388,416.21 ** .00 Budgeted (1,388,416.21) Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (4,377,549.71) .00 Budgeted 4,377,549.71 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET MAY 2015 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 9,005,139 ACCOUNTS RECEIVABLE - TOTAL ASSETS 9,005,139 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 30,833 TOTAL LIABILITIES 30,833 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 8,974,306 TOTAL FUND BALANCE 8,974,306 TOTAL LIABILITIES AND FUND BALANCE 9,005,139 . glbase_tsam rgonzale Trophy Club MUD #1 Page 21 15:38 06/10/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 422.97- 1,310.98- 1,310.98 518-49105-000-000 Bond Proceeds 9,230,000.00- 9,230,000.00 Subtotal: 422.97- 9,231,310.98- 9,231,310.98 Program number: 422.97- 9,231,310.98- 9,231,310.98 Department number: Revenues 422.97- 9,231,310.98- 9,231,310.98 Revenues Subtotal ----------- 422.97- 9,231,310.98- 9,231,310.98 . glbase_tsam rgonzale Trophy Club MUD #1 Page 22 15:38 06/10/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-60125-020-000 Advertising 660.99 660.99- 518-60135-020-000 TCEQ Fees & Permits 23,017.46 23,017.46- 518-69005-020-000 Capital Outlays 5,095.00 43,057.50 43,057.50- Subtotal: 5,095.00 66,735.95 66,735.95- 518-70020-020-000 Bond Issuance Costs 190,269.00 190,269.00- Subtotal: 190,269.00 190,269.00- Program number: 5,095.00 257,004.95 257,004.95- Department number: Wastewater 5,095.00 257,004.95 257,004.95- Expenditures Subtotal ----------- 5,095.00 257,004.95 257,004.95- Fund number: 518 2015 Revenue Bond Const Fund 4,672.03 8,974,306.03- 8,974,306.03 . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 5/2015 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 1532 05/31/2015 Bank Interest/May (888.01) (422.97) (1,310.98) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (422.97) (1,310.98) ** .00 Budgeted 1,310.98 Remaining 0 % Used Account: 518-49105-000-000 Bond Proceeds (9,230,000.00) .00 (9,230,000.00) _______________ Account: 518-49105-000-000 Bond Proceeds Totals: .00 (9,230,000.00) ** .00 Budgeted 9,230,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (9,231,310.98) ** .00 Budgeted 9,231,310.98 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-60125-020-000 Advertising 660.99 .00 660.99 _______________ Account: 518-60125-020-000 Advertising Totals: .00 660.99 ** .00 Budgeted (660.99) Remaining 0 % Used Account: 518-60135-020-000 TCEQ Fees & Permits 23,017.46 .00 23,017.46 _______________ Account: 518-60135-020-000 TCEQ Fees & Permits Totals: .00 23,017.46 ** .00 Budgeted (23,017.46) Remaining 0 % Used Account: 518-69005-020-000 Capital Outlays 1400 05/18/2015 May A/P WWTP Improvements 37,962.50 5,095.00 43,057.50 THE WALLACE GROUP, INC. 34939 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 5,095.00 43,057.50 ** .00 Budgeted (43,057.50) Remaining 0 % Used Account: 518-70020-020-000 Bond Issuance Costs 190,269.00 .00 190,269.00 _______________ Account: 518-70020-020-000 Bond Issuance Costs Totals: .00 190,269.00 ** .00 Budgeted (190,269.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 257,004.95 ** .00 Budgeted (257,004.95) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ (8,974,306.03) .00 Budgeted 8,974,306.03 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2015 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 30,837 ACCOUNTS RECEIVABLE - TOTAL ASSETS 30,837 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 30,837 TOTAL FUND BALANCE 30,837 TOTAL LIABILITIES AND FUND BALANCE 30,837 . glbase_tsam rgonzale Trophy Club MUD #1 Page 23 15:38 06/10/15 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 1.47- 2.67- 2.67 528-49141-000-000 Interfund Transfer In-Gen Fund 71,946.00- 10,278.00- 30,834.00- 42.857 41,112.00- Subtotal: 71,946.00- 10,279.47- 30,836.67- 42.861 41,109.33- Program number: 71,946.00- 10,279.47- 30,836.67- 42.861 41,109.33- Department number: 71,946.00- 10,279.47- 30,836.67- 42.861 41,109.33- Revenues Subtotal ----------- 71,946.00- 10,279.47- 30,836.67- 42.861 41,109.33- Fund number: 528 2015 Revenue Bond Reserve Fund 71,946.00- 10,279.47- 30,836.67- 42.861 41,109.33- . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/2015 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 1532 05/31/2015 Bank Interest/May (1.20) (1.47) (2.67) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (1.47) (2.67) ** .00 Budgeted 2.67 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 1527 05/04/2015 Rev Bond Reserve transfer (20,556.00) (10,278.00) (30,834.00) GL 1542 05/04/2015 Rev Bond Res Transr-Duplicate 10,278.00 (20,556.00) GL 1373 05/04/2015 GF to Rev Bond Reserve (10,278.00) (30,834.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (10,278.00) (30,834.00) ** (71,946.00) Budgeted (41,112.00) Remaining 43 % Used Department Totals: ------------------------------------------------------------------------------------------------ (30,836.67) ** (71,946.00) Budgeted (41,109.33) Remaining 43 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (30,836.67) (71,946.00) Budgeted (41,109.33) Remaining 43 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET MAY 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 605,098 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 14,816 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 624,760 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 14,816 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 14,816 FUND BALANCE ASSIGNED FUND BALANCE 14,753 NET REVENUES / EXPENDITURES 595,191 TOTAL FUND BALANCE 609,944 TOTAL LIABILITIES AND FUND BALANCE 624,760 . glbase_tsam rgonzale Trophy Club MUD #1 Page 24 15:38 06/10/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 466,019.00- 466,019.00- 2,089.53- 462,441.57- 99.232 3,577.43- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 19.88- 1,604.72- 64.189 895.28- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 124.77- 1,450.62- 90.664 149.38- 533-48005-000-000 Reserve Funds/PID Utility Fees 100,000.00- 14,000.00- 14,000.00- 533-48015-000-000 WW Sales Rev Trnsf for Debt 357,538.00- 533-49010-000-000 Interest Income 375.00- 375.00- 28.34- 3,412.13- 909.901 3,037.13 533-49015-000-000 Lease/Rental Income 211,829.00- 211,829.00- 211,829.00- 100.000 533-49110-000-000 Premium on Bonds Sold 4,957.90- 4,957.90 533-49141-000-000 Interfund Trans In-PID Surchg 65,255.00- 65,255.00- Subtotal: 1,139,861.00- 761,578.00- 2,262.52- 685,695.94- 90.036 75,882.06- Program number: 1,139,861.00- 761,578.00- 2,262.52- 685,695.94- 90.036 75,882.06- Department number: Revenues 1,139,861.00- 761,578.00- 2,262.52- 685,695.94- 90.036 75,882.06- Revenues Subtotal ----------- 1,139,861.00- 761,578.00- 2,262.52- 685,695.94- 90.036 75,882.06- . glbase_tsam rgonzale Trophy Club MUD #1 Page 25 15:38 06/10/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2015 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 403,103.00 283,984.00 89,253.75 31.429 194,730.25 533-70035-051-000 Bond Principal Payment-Tax 440,000.00 440,000.00 440,000.00 533-70040-051-000 Bond Interest Expense-Revenue 292,283.00 Subtotal: 1,137,936.00 726,534.00 90,503.75 12.457 636,030.25 Program number: 1,137,936.00 726,534.00 90,503.75 12.457 636,030.25 Department number: Administration 1,137,936.00 726,534.00 90,503.75 12.457 636,030.25 Expenditures Subtotal ----------- 1,137,936.00 726,534.00 90,503.75 12.457 636,030.25 Fund number: 533 MUD 1 I&S Consolidated 1,925.00- 35,044.00- 2,262.52- 595,192.19- 1,698.414 560,148.19 . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2015 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 1499 05/01/2015 Property Taxes/Assessments (460,352.04) (21.02) (460,373.06) GL 1500 05/04/2015 Property Taxes/Assessments (126.12) (460,499.18) GL 1501 05/05/2015 Property Taxes/Assessments (442.01) (460,941.19) GL 1503 05/07/2015 Property Taxes/Assessments (15.55) (460,956.74) GL 1504 05/08/2015 Property Taxes/Assessments (20.43) (460,977.17) GL 1505 05/11/2015 Property Taxes/Assessments (71.23) (461,048.40) GL 1506 05/13/2015 Property Taxes/Assessments (56.63) (461,105.03) GL 1508 05/15/2015 Property Taxes/Assessments (173.38) (461,278.41) GL 1509 05/18/2015 Property Taxes/Assessments (79.07) (461,357.48) GL 1510 05/19/2015 Property Taxes/Assessments (57.37) (461,414.85) GL 1511 05/20/2015 Property Taxes/Assessments (109.08) (461,523.93) GL 1512 05/21/2015 Property Taxes/Assessments (97.26) (461,621.19) GL 1513 05/22/2015 Property Taxes/Assessments (121.11) (461,742.30) GL 1514 05/26/2015 Property Taxes/Assessments (498.24) (462,240.54) GL 1515 05/27/2015 Property Taxes/Assessments (4.26) (462,244.80) GL 1520 05/28/2015 Property Taxes/Assessments (136.97) (462,381.77) GL 1521 05/29/2015 Property Taxes/Assessments (59.80) (462,441.57) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,089.53) (462,441.57) ** (466,019.00) Budgeted (3,577.43) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1500 05/04/2015 Property Taxes/Assessments (1,584.84) (.01) (1,584.85) GL 1502 05/06/2015 Property Taxes/Assessments (18.30) (1,603.15) GL 1504 05/08/2015 Property Taxes/Assessments (1.57) (1,604.72) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (19.88) (1,604.72) ** (2,500.00) Budgeted (895.28) Remaining 64 % Used Account: 533-40015-000-000 Property Taxes/P & I 1499 05/01/2015 Property Taxes/Assessments (1,325.85) (2.31) (1,328.16) GL 1500 05/04/2015 Property Taxes/Assessments (13.96) (1,342.12) GL 1501 05/05/2015 Property Taxes/Assessments (48.62) (1,390.74) GL 1502 05/06/2015 Property Taxes/Assessments (4.95) (1,395.69) GL 1503 05/07/2015 Property Taxes/Assessments (2.02) (1,397.71) GL 1504 05/08/2015 Property Taxes/Assessments (.44) (1,398.15) GL 1506 05/13/2015 Property Taxes/Assessments (2.13) (1,400.28) GL 1508 05/15/2015 Property Taxes/Assessments (15.77) (1,416.05) GL 1512 05/21/2015 Property Taxes/Assessments (3.69) (1,419.74) GL 1514 05/26/2015 Property Taxes/Assessments (30.33) (1,450.07) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1515 05/27/2015 Property Taxes/Assessments (1,325.85) (.55) (1,450.62) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (124.77) (1,450.62) ** (1,600.00) Budgeted (149.38) Remaining 91 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (14,000.00) Budgeted (14,000.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 1532 05/31/2015 Bank Interest/May (3,383.79) (28.34) (3,412.13) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (28.34) (3,412.13) ** (375.00) Budgeted 3,037.13 Remaining 910 % Used Account: 533-49015-000-000 Lease/Rental Income (211,829.00) .00 (211,829.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (211,829.00) ** (211,829.00) Budgeted .00 Remaining 100 % Used Account: 533-49110-000-000 Premium on Bonds Sold (4,957.90) .00 (4,957.90) _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: .00 (4,957.90) ** .00 Budgeted 4,957.90 Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg .00 .00 _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 .00 ** (65,255.00) Budgeted (65,255.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (685,695.94) ** (761,578.00) Budgeted (75,882.06) Remaining 90 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2015 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 89,253.75 .00 89,253.75 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 89,253.75 ** 283,984.00 Budgeted 194,730.25 Remaining 31 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 440,000.00 Budgeted 440,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 90,503.75 ** 726,534.00 Budgeted 636,030.25 Remaining 12 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (595,192.19) (35,044.00) Budgeted 560,148.19 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MAY 2015 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,054 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,054 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 15,054 TOTAL FUND BALANCE 15,054 TOTAL LIABILITIES AND FUND BALANCE 15,054 . glbase_tsam rgonzale Trophy Club MUD #1 Page 26 15:38 06/10/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income .62- 10,439.30- 10,439.30 534-49110-000-000 Bond Premium 4,615.00- 4,615.00 534-49143-000-000 Interfund Transfer In-WW Sales 136,989.00- 136,989.00- Subtotal: 136,989.00- .62- 15,054.30- 10.989 121,934.70- Program number: 136,989.00- .62- 15,054.30- 10.989 121,934.70- Department number: Revenues 136,989.00- .62- 15,054.30- 10.989 121,934.70- Revenues Subtotal ----------- 136,989.00- .62- 15,054.30- 10.989 121,934.70- . glbase_tsam rgonzale Trophy Club MUD #1 Page 27 15:38 06/10/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 136,989.00 136,989.00 Subtotal: 136,989.00 136,989.00 Program number: 136,989.00 136,989.00 Department number: Administration 136,989.00 136,989.00 Expenditures Subtotal ----------- 136,989.00 136,989.00 Fund number: 534 2015 Revenue Bond I&S .62- 15,054.30- 15,054.30 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/2015 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 1532 05/31/2015 Bank Interest/May (10,438.68) (.62) (10,439.30) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (.62) (10,439.30) ** .00 Budgeted 10,439.30 Remaining 0 % Used Account: 534-49110-000-000 Bond Premium (4,615.00) .00 (4,615.00) _______________ Account: 534-49110-000-000 Bond Premium Totals: .00 (4,615.00) ** .00 Budgeted 4,615.00 Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales .00 .00 _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 .00 ** (136,989.00) Budgeted (136,989.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (15,054.30) ** (136,989.00) Budgeted (121,934.70) Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 15:39 06/10/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/2015 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 .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 136,989.00 Budgeted 136,989.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 136,989.00 Budgeted 136,989.00 Remaining 0 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (15,054.30) .00 Budgeted 15,054.30 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (15,212,321.85) **** (103,642.00) Budgeted 15,108,679.85 Remaining ########## ******* End of Report *********