Loading...
HomeMy WebLinkAbout2015-04 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET APRIL 2015 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 991,102 PREPAID EXPENSES 7,995 ADVALOREM PROPERTY TAXES RECEIVABLE 29,767 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 2,169 UTILITY AND OTHER ACCOUNTS RECEIVABLE 639 TOTAL ASSETS 1,031,672 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 31,937 ACCOUNTS AND OTHER PAYABLES 28,219 TOTAL LIABILITIES 60,156 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 442,605 TOTAL FUND BALANCE 971,516 TOTAL LIABILITIES AND FUND BALANCE 1,031,672 . glbase_tsam rgonzale Trophy Club MUD #1 Page 1 15:39 05/13/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/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- 3,394.66- 355,085.07- 99.335 2,376.93- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 8,293.67- 8,401.96- 8,401.96 122-40010-000-000 Property Taxes/MUD Fire 872,859.00- 872,859.00- 7,017.59- 862,128.97- 98.771 10,730.03- 122-40011-000-000 Property Taxes/Fire-Delinquent 9.98- 3,625.38- 3,625.38 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 2,972.85- 3,227.75- 430.367 2,477.75 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 654.78- 2,975.82- 66.129 1,524.18- 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- 22,343.53- 2,192,460.08- 97.883 47,406.92- Program number: 1,383,940.00- 2,239,867.00- 22,343.53- 2,192,460.08- 97.883 47,406.92- Department number: Fire Revenues 1,383,940.00- 2,239,867.00- 22,343.53- 2,192,460.08- 97.883 47,406.92- Revenues Subtotal ----------- 1,383,940.00- 2,239,867.00- 22,343.53- 2,192,460.08- 97.883 47,406.92- . glbase_tsam rgonzale Trophy Club MUD #1 Page 2 15:39 05/13/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 35,825.18 253,862.07 54.121 215,204.93 122-50010-045-000 Overtime 46,745.00 46,745.00 3,072.94 20,151.65 43.110 26,593.35 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 2,844.00 59.250 1,956.00 122-50020-045-000 Retirement 91,396.00 75,327.00 5,164.38 40,978.76 54.401 34,348.24 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,440.56 31,702.72 53.580 27,466.28 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 336.53 2,441.22 55.609 1,948.78 122-50028-045-000 Vision Insurance 811.00 811.00 57.67 425.87 52.512 385.13 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 298.59 2,143.10 53.179 1,886.90 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 2,235.54 16,910.14 50.597 16,510.86 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 522.72 3,953.86 54.222 3,338.14 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 428.25- 298.27- -18.001 1,955.27 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 658.99 4,612.97 53.071 4,079.03 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 738.30 5,536.38 29.842 13,015.62 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 674.37 5,517.91 45.983 6,482.09 Subtotal: 791,885.00 775,816.00 54,035.02 413,431.96 53.290 362,384.04 122-60005-045-000 Telephone 50.00 50.00 5.70 34.19 68.380 15.81 122-60010-045-000 Communications/Pagers/Mobiles 5,000.00 6,413.00 177.68 3,398.98 53.001 3,014.02 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 442.90 2,954.15 32.729 6,071.85 122-60025-045-000 Water 1,200.00 1,200.00 99.21 741.96 61.830 458.04 122-60026-045-000 Cable 1,920.00 1,920.00 153.28 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 15.47 15.470 84.53 122-60055-045-000 Insurance 12,179.00 12,179.00 940.08 6,580.60 54.032 5,598.40 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 1,293.08 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 3,506.98 25.830 10,070.02 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 442.41 3,216.79 30.771 7,237.21 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:39 05/13/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 5,065.66 14.391 30,134.34 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 117.61 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 3,671.95 1,336,422.64 91.283 127,628.36 Program number: 1,383,940.00 2,239,867.00 57,706.97 1,749,854.60 78.123 490,012.40 Department number: Fire 1,383,940.00 2,239,867.00 57,706.97 1,749,854.60 78.123 490,012.40 Expenditures Subtotal ----------- 1,383,940.00 2,239,867.00 57,706.97 1,749,854.60 78.123 490,012.40 Fund number: 122 Trophy Club MUD Fire Dept. 35,363.44 442,605.48- 442,605.48 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/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 1309 04/01/2015 Property Taxes/Assessments (351,690.41) (2,236.71) (353,927.12) GL 1310 04/02/2015 Property Taxes/Assessments (18.59) (353,945.71) GL 1315 04/10/2015 Property Taxes/Assessments (275.68) (354,221.39) GL 1317 04/14/2015 Property Taxes/Assessments 7.73 (354,213.66) GL 1321 04/22/2015 Property Taxes/Assessments (315.55) (354,529.21) GL 1322 04/24/2015 Property Taxes/Assessments (304.91) (354,834.12) GL 1323 04/28/2015 Property Taxes/Assessments (240.52) (355,074.64) GL 1324 04/29/2015 Property Taxes/Assessments (10.43) (355,085.07) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (3,394.66) (355,085.07) ** (357,462.00) Budgeted (2,376.93) Remaining 99 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1309 04/01/2015 Property Taxes/Assessments (108.29) (8,244.48) (8,352.77) GL 1311 04/06/2015 Property Taxes/Assessments (49.19) (8,401.96) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (8,293.67) (8,401.96) ** .00 Budgeted 8,401.96 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1309 04/01/2015 Property Taxes/Assessments (855,111.38) (627.93) (855,739.31) GL 1310 04/02/2015 Property Taxes/Assessments (483.63) (856,222.94) GL 1311 04/06/2015 Property Taxes/Assessments (439.47) (856,662.41) GL 1312 04/07/2015 Property Taxes/Assessments (255.56) (856,917.97) GL 1313 04/08/2015 Property Taxes/Assessments (940.89) (857,858.86) GL 1314 04/09/2015 Property Taxes/Assessments (530.63) (858,389.49) GL 1315 04/10/2015 Property Taxes/Assessments (379.77) (858,769.26) GL 1316 04/13/2015 Property Taxes/Assessments (.51) (858,769.77) GL 1318 04/15/2015 Property Taxes/Assessments (30.88) (858,800.65) GL 1319 04/16/2015 Property Taxes/Assessments (20.20) (858,820.85) GL 1320 04/17/2015 Property Taxes/Assessments (195.01) (859,015.86) GL 1321 04/22/2015 Property Taxes/Assessments (18.07) (859,033.93) GL 1322 04/24/2015 Property Taxes/Assessments (210.48) (859,244.41) GL 1323 04/28/2015 Property Taxes/Assessments (168.59) (859,413.00) GL 1361 04/30/2015 Property Taxes/Assessments (2,715.97) (862,128.97) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (7,017.59) (862,128.97) ** (872,859.00) Budgeted (10,730.03) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1313 04/08/2015 Property Taxes/Assessments (3,615.40) (9.98) (3,625.38) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (9.98) (3,625.38) ** .00 Budgeted 3,625.38 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1309 04/01/2015 Property Taxes/Assessments (254.90) (2,831.92) (3,086.82) GL 1310 04/02/2015 Property Taxes/Assessments (1.67) (3,088.49) GL 1311 04/06/2015 Property Taxes/Assessments (13.28) (3,101.77) GL 1315 04/10/2015 Property Taxes/Assessments (30.32) (3,132.09) GL 1321 04/22/2015 Property Taxes/Assessments (34.72) (3,166.81) GL 1322 04/24/2015 Property Taxes/Assessments (33.54) (3,200.35) GL 1323 04/28/2015 Property Taxes/Assessments (26.46) (3,226.81) GL 1324 04/29/2015 Property Taxes/Assessments (.94) (3,227.75) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (2,972.85) (3,227.75) ** (750.00) Budgeted 2,477.75 Remaining 430 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1309 04/01/2015 Property Taxes/Assessments (2,321.04) (31.85) (2,352.89) GL 1310 04/02/2015 Property Taxes/Assessments (13.35) (2,366.24) GL 1311 04/06/2015 Property Taxes/Assessments (33.12) (2,399.36) GL 1312 04/07/2015 Property Taxes/Assessments (23.38) (2,422.74) GL 1313 04/08/2015 Property Taxes/Assessments (83.53) (2,506.27) GL 1314 04/09/2015 Property Taxes/Assessments (58.37) (2,564.64) GL 1315 04/10/2015 Property Taxes/Assessments (41.78) (2,606.42) GL 1316 04/13/2015 Property Taxes/Assessments (.04) (2,606.46) GL 1318 04/15/2015 Property Taxes/Assessments (3.40) (2,609.86) GL 1319 04/16/2015 Property Taxes/Assessments (2.23) (2,612.09) GL 1320 04/17/2015 Property Taxes/Assessments (21.45) (2,633.54) GL 1321 04/22/2015 Property Taxes/Assessments (1.86) (2,635.40) GL 1322 04/24/2015 Property Taxes/Assessments (23.16) (2,658.56) GL 1323 04/28/2015 Property Taxes/Assessments (18.53) (2,677.09) GL 1361 04/30/2015 Property Taxes/Assessments (298.73) (2,975.82) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (654.78) (2,975.82) ** (4,500.00) Budgeted (1,524.18) Remaining 66 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (4,400.00) .00 (4,400.00) . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/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-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 (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,192,460.08) ** (2,239,867.00) Budgeted (47,406.92) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 1257 04/10/2015 FD Payroll 4/10/15 218,036.89 17,760.82 235,797.71 GL 1347 04/10/2015 FD Payroll 4/10/15 17,760.82 253,558.53 GL 1381 04/10/2015 Reverse Fire P/R duplicated (17,760.82) 235,797.71 GL 1350 04/24/2015 FD Payroll 4/24/15 18,064.36 253,862.07 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 35,825.18 253,862.07 ** 469,067.00 Budgeted 215,204.93 Remaining 54 % Used Account: 122-50010-045-000 Overtime 1257 04/10/2015 FD Payroll 4/10/15 17,078.71 3,072.94 20,151.65 GL 1347 04/10/2015 FD Payroll 4/10/15 3,072.94 23,224.59 GL 1381 04/10/2015 Reverse Fire P/R duplicated (3,072.94) 20,151.65 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,072.94 20,151.65 ** 46,745.00 Budgeted 26,593.35 Remaining 43 % 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 1257 04/10/2015 FD Payroll 4/10/15 2,406.50 437.50 2,844.00 GL 1347 04/10/2015 FD Payroll 4/10/15 437.50 3,281.50 GL 1381 04/10/2015 Reverse Fire P/R duplicated (437.50) 2,844.00 GL _______________ Account: 122-50017-045-000 Certification Totals: 437.50 2,844.00 ** 4,800.00 Budgeted 1,956.00 Remaining 59 % Used Account: 122-50020-045-000 Retirement . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1257 04/10/2015 FD Payroll 4/10/15 35,814.38 2,777.03 38,591.41 GL 1347 04/10/2015 FD Payroll 4/10/15 2,777.03 41,368.44 GL 1381 04/10/2015 Reverse Fire P/R duplicated (2,777.03) 38,591.41 GL 1350 04/24/2015 FD Payroll 4/24/15 2,387.35 40,978.76 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,164.38 40,978.76 ** 75,327.00 Budgeted 34,348.24 Remaining 54 % Used Account: 122-50026-045-000 Medical Insurance 1257 04/10/2015 FD Payroll 4/10/15 27,262.16 2,651.06 29,913.22 GL 1347 04/10/2015 FD Payroll 4/10/15 2,651.06 32,564.28 GL 1381 04/10/2015 Reverse Fire P/R duplicated (2,651.06) 29,913.22 GL 1350 04/24/2015 FD Payroll 4/24/15 1,789.50 31,702.72 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,440.56 31,702.72 ** 59,169.00 Budgeted 27,466.28 Remaining 54 % Used Account: 122-50027-045-000 Dental Insurance 1257 04/10/2015 FD Payroll 4/10/15 2,104.69 175.10 2,279.79 GL 1347 04/10/2015 FD Payroll 4/10/15 175.10 2,454.89 GL 1381 04/10/2015 Reverse Fire P/R duplicated (175.10) 2,279.79 GL 1350 04/24/2015 FD Payroll 4/24/15 161.43 2,441.22 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 336.53 2,441.22 ** 4,390.00 Budgeted 1,948.78 Remaining 56 % Used Account: 122-50028-045-000 Vision Insurance 1257 04/10/2015 FD Payroll 4/10/15 368.20 30.25 398.45 GL 1347 04/10/2015 FD Payroll 4/10/15 30.25 428.70 GL 1381 04/10/2015 Reverse Fire P/R duplicated (30.25) 398.45 GL 1350 04/24/2015 FD Payroll 4/24/15 27.42 425.87 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 57.67 425.87 ** 811.00 Budgeted 385.13 Remaining 53 % Used Account: 122-50029-045-000 Life Insurance & Other 1257 04/10/2015 FD Payroll 4/10/15 1,844.51 155.27 1,999.78 GL 1347 04/10/2015 FD Payroll 4/10/15 155.27 2,155.05 GL 1381 04/10/2015 Reverse Fire P/R duplicated (155.27) 1,999.78 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1350 04/24/2015 FD Payroll 4/24/15 1,844.51 143.32 2,143.10 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 298.59 2,143.10 ** 4,030.00 Budgeted 1,886.90 Remaining 53 % Used Account: 122-50030-045-000 Social Security Taxes 1257 04/10/2015 FD Payroll 4/10/15 14,674.60 1,212.50 15,887.10 GL 1347 04/10/2015 FD Payroll 4/10/15 1,212.50 17,099.60 GL 1381 04/10/2015 Reverse Fire P/R duplicated (1,212.50) 15,887.10 GL 1350 04/24/2015 FD Payroll 4/24/15 1,023.04 16,910.14 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,235.54 16,910.14 ** 33,421.00 Budgeted 16,510.86 Remaining 51 % Used Account: 122-50035-045-000 Medicare Taxes 1257 04/10/2015 FD Payroll 4/10/15 3,431.14 283.50 3,714.64 GL 1347 04/10/2015 FD Payroll 4/10/15 283.50 3,998.14 GL 1381 04/10/2015 Reverse Fire P/R duplicated (283.50) 3,714.64 GL 1350 04/24/2015 FD Payroll 4/24/15 239.22 3,953.86 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 522.72 3,953.86 ** 7,292.00 Budgeted 3,338.14 Remaining 54 % Used Account: 122-50040-045-000 Unemployment Taxes 1257 04/10/2015 FD Payroll 4/10/15 129.98 (432.70) (302.72) GL 1257 04/10/2015 FD Payroll 4/10/15 2.70 (300.02) GL 1347 04/10/2015 FD Payroll 4/10/15 (430.00) (730.02) GL 1381 04/10/2015 Reverse Fire P/R duplicated 430.00 (300.02) GL 1350 04/24/2015 FD Payroll 4/24/15 1.75 (298.27) GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: (428.25) (298.27) ** 1,657.00 Budgeted 1,955.27 Remaining -18 % Used Account: 122-50045-045-000 Workman's Compensation 197 04/01/2015 Apr TML Ins & Workers Comp 3,953.98 658.99 4,612.97 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 658.99 4,612.97 ** 8,692.00 Budgeted 4,079.03 Remaining 53 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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-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 _______________ 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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 LONE STAR SAFETY & SUP 4,798.08 330.00 5,128.08 LONE STAR SAFETY & SUP PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 NORTHERN TOOL EQUIP 61.92 5,190.00 NORTHERN TOOL EQUIP PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 SAMS CLUB #4795 214.09 5,404.09 SAMS CLUB #4795 PC 1289 04/30/2015 April A/P Rug Service 32.29 5,436.38 G & K SERVICES 34861 AP 1289 04/30/2015 April A/P Rug Service 32.29 5,468.67 G & K SERVICES 34861 AP 1289 04/30/2015 April A/P FD Backflow testing 100.00 5,568.67 RESCOM FIRE SYSTEMS, INC. 34887 AP 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (32.29) 5,536.38 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 738.30 5,536.38 ** 18,552.00 Budgeted 13,015.62 Remaining 30 % Used Account: 122-55090-045-000 Vehicle Maintenance 1378 04/27/2015 PCard 03/27/15 to 04/27/15 WM SUPERCENTER #5247 4,843.54 60.20 4,903.74 WM SUPERCENTER #5247 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1378 04/27/2015 PCard 03/27/15 to 04/27/15 WM SUPERCENTER #3631 4,843.54 30.16 4,933.90 WM SUPERCENTER #3631 PC 1289 04/30/2015 April A/P Repairs for E-681 584.01 5,517.91 SIDDONS-MARTIN EMERGENCY GROUP 34892 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 674.37 5,517.91 ** 12,000.00 Budgeted 6,482.09 Remaining 46 % Used Account: 122-60005-045-000 Telephone 1289 04/30/2015 April A/P BOA PCards 28.49 5.70 34.19 TOWN OF TROPHY CLUB 34905 AP _______________ Account: 122-60005-045-000 Telephone Totals: 5.70 34.19 ** 50.00 Budgeted 15.81 Remaining 68 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1257 04/10/2015 FD Payroll 4/10/15 3,221.30 37.50 3,258.80 GL 1347 04/10/2015 FD Payroll 4/10/15 37.50 3,296.30 GL 1381 04/10/2015 Reverse Fire P/R duplicated (37.50) 3,258.80 GL 1289 04/30/2015 April A/P Verizon, Nevill 140.18 3,398.98 TOWN OF TROPHY CLUB 34905 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 177.68 3,398.98 ** 6,413.00 Budgeted 3,014.02 Remaining 53 % Used Account: 122-60020-045-000 Electricity/Gas 1289 04/30/2015 April A/P Electricity 3/12-4/13/15 2,511.25 810.21 3,321.46 HUDSON ENERGY SERVICES, LLC 34867 AP 1289 04/30/2015 April A/P Gas/Fire Station 3/20-4/21/15 75.57 3,397.03 ATMOS ENERGY 34847 AP 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (442.88) 2,954.15 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 442.90 2,954.15 ** 9,026.00 Budgeted 6,071.85 Remaining 33 % Used Account: 122-60025-045-000 Water 1289 04/30/2015 April A/P April Water 642.75 146.61 789.36 TROPHY CLUB MUD (WATER BILLS) 34907 AP 1289 04/30/2015 April A/P April Water 51.81 841.17 TROPHY CLUB MUD (WATER BILLS) 34907 AP 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (99.21) 741.96 AR _______________ Account: 122-60025-045-000 Water Totals: 99.21 741.96 ** 1,200.00 Budgeted 458.04 Remaining 62 % Used Account: 122-60026-045-000 Cable . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1268 04/01/2015 TC Firefighters Cable/April 915.83 (133.82) 782.01 GL 1378 04/27/2015 PCard 03/27/15 to 04/27/15 ATT*BILL PAYMENT 128.59 910.60 ATT*BILL PAYMENT PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 ATT*BILL PAYMENT 158.51 1,069.11 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 153.28 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 15.47 .00 15.47 _______________ Account: 122-60035-045-000 Postage Totals: .00 15.47 ** 100.00 Budgeted 84.53 Remaining 15 % Used Account: 122-60055-045-000 Insurance 197 04/01/2015 Apr TML Ins & Workers Comp 5,640.52 940.08 6,580.60 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.08 6,580.60 ** 12,179.00 Budgeted 5,598.40 Remaining 54 % 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 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1378 04/27/2015 PCard 03/27/15 to 04/27/15 JONES&BARTLETT LEARNIN 1,231.00 208.08 1,439.08 JONES&BARTLETT LEARNIN PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 IN *TRAININGDIVISION.C 250.00 1,689.08 IN *TRAININGDIVISION.C PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 IN *TRAININGDIVISION.C 250.00 1,939.08 IN *TRAININGDIVISION.C PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 IN *TRAININGDIVISION.C 250.00 2,189.08 IN *TRAININGDIVISION.C PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 IN *TRAININGDIVISION.C 250.00 2,439.08 IN *TRAININGDIVISION.C PC 1339 04/30/2015 April A/P Advanced Structure Fire Protec 85.00 2,524.08 TX COMM ON FIRE PROTECTION 34909 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 1,293.08 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 3,506.98 .00 3,506.98 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 3,506.98 ** 13,577.00 Budgeted 10,070.02 Remaining 26 % 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 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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-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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 573.99 (123.92) 450.07 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 CORNER STORE 1136 123.92 573.99 CORNER STORE 1136 PC _______________ 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 1339 04/30/2015 April A/P April Gas/Diesel 2,774.38 442.41 3,216.79 US Bank Voyager Fleet Systems 34911 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 442.41 3,216.79 ** 10,454.00 Budgeted 7,237.21 Remaining 31 % 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 5,065.66 .00 5,065.66 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 5,065.66 ** 35,200.00 Budgeted 30,134.34 Remaining 14 % Used Account: 122-65030-045-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 THE HOME DEPOT 6581 46.61 117.61 164.22 THE HOME DEPOT 6581 PC _______________ Account: 122-65035-045-000 Small Tools Totals: 117.61 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 _______________ 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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-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,749,854.60 ** 2,239,867.00 Budgeted 490,012.40 Remaining 78 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (442,605.48) .00 Budgeted 442,605.48 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET APRIL 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 4/30/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 302,294 - - 302,294 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,507,290 - - 1,507,290 INVESTMENTS-TEXPOOL 1,507,090 169,600 21,607 1,698,296 PREPAID EXPENSES 34,479 - - 34,479 ADVALOREM PROPERTY TAXES RECEIVABLE 4,851 - - 4,851 UTILITY AND OTHER ACCOUNTS RECEIVABLE 548,864 - - 548,864 - TOTAL ASSETS 3,905,468 169,600 21,607 4,096,675 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,851 - - 4,851 ACCOUNTS AND OTHER PAYABLES 587,470 - 13,581 601,051 CUSTOMER DEPOSITS 300,782 - - 300,782 - TOTAL LIABILITIES 893,103 - 13,581 906,684 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 864,310 (91,097) (2,242) 770,971 - TOTAL FUND BALANCE 3,012,365 169,600 8,026 3,189,991 - TOTAL LIABILITIES AND FUND BALANCE 3,905,468 169,600 21,607 4,096,675 . glbase_tsam rgonzale Trophy Club MUD #1 Page 4 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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- 1,349.56- 165,798.32- 98.774 2,058.68- 135-40002-000-000 Property Taxes/Delinquent 1.07- 402.42- 402.42 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 125.71- 500.57- 55.619 399.43- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 11,721.30- 80,705.20- 60.229 53,291.80- 135-47000-000-000 Water 5,286,045.00- 4,747,789.00- 223,295.89- 1,597,783.61- 33.653 3,150,005.39- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 158,903.24- 1,073,570.30- 47.273 1,197,411.70- 135-47025-000-000 Penalties 63,416.00- 80,000.00- 5,449.08- 51,868.07- 64.835 28,131.93- 135-47030-000-000 Service Charges 8,000.00- 10,000.00- 928.00- 6,721.00- 67.210 3,279.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 100.00- 1,450.00- 72.500 550.00- 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 300.00- 4,350.00- 87.000 650.00- 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 1,323.70- 15,869.00- 18.279 70,946.00- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 29,900.00- 135,700.00- 73.750 48,300.00- 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 457.44- 3,521.89- 70.438 1,478.11- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 6,373.71- 62.709 3,790.29- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 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- 5,831.00- 34,828.83- 82.926 7,171.17- 135-49141-000-000 Interfund Transfer In 19,607.00- 19,606.50- 99.997 .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- 3,724.92- 41,166.81- 59.667 27,827.19- 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- 444,904.77- 4,393,354.89- 49.662 4,453,159.11- Program number: 8,444,333.00- 8,846,514.00- 444,904.77- 4,393,354.89- 49.662 4,453,159.11- Department number: Revenues 8,444,333.00- 8,846,514.00- 444,904.77- 4,393,354.89- 49.662 4,453,159.11- Revenues Subtotal ----------- 8,444,333.00- 8,846,514.00- 444,904.77- 4,393,354.89- 49.662 4,453,159.11- . glbase_tsam rgonzale Trophy Club MUD #1 Page 5 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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,260.74 109,374.37 44.720 135,203.63 135-50010-010-000 Overtime 19,500.00 19,500.00 1,315.49 7,788.97 39.943 11,711.03 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,600.00 41.026 2,300.00 135-50020-010-000 Retirement 29,349.00 23,987.00 1,675.20 10,854.21 45.250 13,132.79 135-50026-010-000 Medical Insurance 44,988.00 51,487.00 3,269.05 16,828.49 32.685 34,658.51 135-50027-010-000 Dental Insurance 3,288.00 4,188.00 267.98 1,355.22 32.360 2,832.78 135-50028-010-000 Vision Insurance 834.00 990.00 59.92 312.43 31.559 677.57 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 182.15 1,111.48 36.157 1,962.52 135-50030-010-000 Social Security Taxes 21,135.00 17,192.00 1,148.12 7,437.37 43.261 9,754.63 135-50035-010-000 Medicare Taxes 4,943.00 4,021.00 268.52 1,739.40 43.258 2,281.60 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 14.88- 13.16 1.060 1,228.84 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 857.91 4,685.37 29.247 11,334.63 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,300.00 210.95 939.25 72.250 360.75 135-50070-010-000 Employee Relations 300.00 300.00 35.72 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 1,468.47 34,970.56 43.113 46,142.44 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 470.79 4,121.65 51.521 3,878.35 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 21.82 264.82 7.566 3,235.18 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 749.28 2,579.80 46.905 2,920.20 Subtotal: 555,159.00 502,597.00 29,472.23 208,829.73 41.550 293,767.27 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 30.16 1,976.80 40.236 2,936.20 135-60020-010-000 Electricity 170,765.00 160,765.00 9,642.08 63,845.12 39.713 96,919.88 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 18,605.31 37.758 30,669.69 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 113,256.83 797,723.97 27.242 2,130,584.03 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 84.74 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,092.50 6,948.70 36.242 12,224.30 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 914.15 5,755.78 57.558 4,244.22 135-65035-010-000 Small Tools 1,200.00 1,200.00 49.68 118.05 9.838 1,081.95 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 180.00 457.01 45.701 542.99 135-65050-010-000 Meter Expense 161,500.00 165,000.00 2,274.50 27,184.34 16.475 137,815.66 135-69005-010-000 Capital Outlays 1,089,006.00 1,457,597.00 28,133.07 168,599.16 11.567 1,288,997.84 . glbase_tsam rgonzale Trophy Club MUD #1 Page 6 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 155,657.71 1,428,882.80 27.606 3,747,075.20 Program number: 5,376,025.00 5,678,555.00 185,129.94 1,637,712.53 28.840 4,040,842.47 . glbase_tsam rgonzale Trophy Club MUD #1 Page 7 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/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 177.63 2,345.26 46.905 2,654.74 Subtotal: 5,000.00 5,000.00 177.63 2,345.26 46.905 2,654.74 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 177.63 4,764.01 47.640 5,235.99 Department number: Water 5,386,025.00 5,688,555.00 185,307.57 1,642,476.54 28.873 4,046,078.46 . glbase_tsam rgonzale Trophy Club MUD #1 Page 8 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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.69 165,314.10 53.695 142,560.90 135-50010-020-000 Overtime 19,500.00 24,500.00 2,036.01 18,189.09 74.241 6,310.91 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 550.00 3,850.00 58.333 2,750.00 135-50020-020-000 Retirement 29,948.00 30,317.00 2,340.53 17,245.46 56.884 13,071.54 135-50026-020-000 Medical Insurance 61,001.00 56,244.00 4,686.75 32,304.64 57.437 23,939.36 135-50027-020-000 Dental Insurance 4,146.00 3,696.00 299.51 2,065.98 55.898 1,630.02 135-50028-020-000 Vision Insurance 990.00 912.00 69.00 480.39 52.674 431.61 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 272.47 1,935.07 60.585 1,258.93 135-50030-020-000 Social Security Taxes 21,680.00 21,812.00 1,542.68 10,815.74 49.586 10,996.26 135-50035-020-000 Medicare Taxes 5,070.00 5,101.00 346.07 2,514.75 49.299 2,586.25 135-50040-020-000 Unemployment Taxes 1,242.00 1,242.00 38.38- 13.90 1.119 1,228.10 135-50045-020-000 Workman's Compensation 16,020.00 16,020.00 857.91 4,685.37 29.247 11,334.63 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 172.87 52,608.26 72.463 19,991.74 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 679.26 3,468.54 115.618 468.54- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 107.91 129.18 25.836 370.82 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 1,719.15 33,896.23 61.630 21,103.77 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 1,864.00 16,173.50 64.694 8,826.50 Subtotal: 622,952.00 640,180.00 41,188.43 371,882.47 58.090 268,297.53 135-60010-020-000 Communications/Mobiles 4,662.00 4,662.00 604.05 3,271.48 70.173 1,390.52 135-60020-020-000 Electricity 149,292.00 139,292.00 10,962.66 72,752.31 52.230 66,539.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 111.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 1,791.25 89.563 208.75 135-60105-020-000 Rent/Lease Equipment 9,000.00 7,500.00 1.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 20,556.00 28.571 51,390.00 135-65005-020-000 Fuel & Lube 36,328.00 20,328.00 1,843.64 11,659.14 57.355 8,668.86 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 1,858.57 9,686.22 40.359 14,313.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 463.68 625.68 83.424 124.32 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 3,393.38 9,326.63 71.743 3,673.37 135-69005-020-000 Capital Outlays 150,000.00 142,000.00 4,509.00 103,200.35 72.676 38,799.65 . glbase_tsam rgonzale Trophy Club MUD #1 Page 9 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 34,024.98 267,953.83 37.570 445,263.17 Program number: 1,462,117.00 1,353,397.00 75,213.41 639,836.30 47.276 713,560.70 Department number: Wastewater 1,462,117.00 1,353,397.00 75,213.41 639,836.30 47.276 713,560.70 . glbase_tsam rgonzale Trophy Club MUD #1 Page 10 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 600.00 6,900.00 69.000 3,100.00 135-50030-026-000 Social Security Taxes 620.00 620.00 37.20 427.80 69.000 192.20 135-50035-026-000 Medicare Taxes 145.00 145.00 8.70 100.05 69.000 44.95 135-50040-026-000 Unemployment Taxes 230.00 230.00 .60 59.08 25.687 170.92 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 20.58 57.167 15.42 Subtotal: 11,031.00 11,031.00 649.44 7,507.51 68.058 3,523.49 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 1,329.96 31.293 2,920.04 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 4,495.94 37.940 7,354.06 Program number: 22,881.00 22,881.00 649.44 12,003.45 52.460 10,877.55 Department number: Board of Directors 22,881.00 22,881.00 649.44 12,003.45 52.460 10,877.55 . glbase_tsam rgonzale Trophy Club MUD #1 Page 11 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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,714.34 252,317.51 53.601 218,414.49 135-50010-030-000 Overtime 1,000.00 1,000.00 35.67 446.78 44.678 553.22 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,185.33 22,881.44 54.242 19,302.56 135-50026-030-000 Medical Insurance 65,015.00 62,000.00 5,166.33 33,211.53 53.567 28,788.47 135-50027-030-000 Dental Insurance 4,944.00 4,494.00 364.24 2,370.52 52.749 2,123.48 135-50028-030-000 Vision Insurance 1,158.00 1,116.00 84.38 556.97 49.908 559.03 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 353.04 2,496.81 57.623 1,836.19 135-50030-030-000 Social Security Taxes 30,079.00 29,654.00 2,073.07 15,022.73 50.660 14,631.27 135-50035-030-000 Medicare Taxes 7,422.00 7,317.00 484.85 3,513.37 48.017 3,803.63 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 60.63- 143.56 9.908 1,305.44 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 611.10 37.353 1,024.90 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 200.00 2,461.64 49.233 2,538.36 135-55030-030-000 Software & Support 75,588.00 121,635.00 2,936.84 95,716.73 78.692 25,918.27 135-55070-030-000 Independent Labor 8,000.00 32,550.00 25,800.00 79.263 6,750.00 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 4,500.00 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 612.50 4,026.20 61.942 2,473.80 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 3,765.18 46.484 4,334.82 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 571.10 3,753.40 45.773 4,446.60 Subtotal: 821,495.00 904,503.00 51,808.36 515,185.92 56.958 389,317.08 135-60005-030-000 Telephone 13,361.00 13,361.00 1,212.43 6,866.85 51.395 6,494.15 135-60010-030-000 Communications/Pagers/Mobiles 4,056.00 4,056.00 337.99 2,379.81 58.674 1,676.19 135-60020-030-000 Electricity/Gas 14,978.00 12,000.00 3,668.68 30.572 8,331.32 135-60025-030-000 Water 1,500.00 1,500.00 53.47 488.05 32.537 1,011.95 135-60035-030-000 Postage 28,500.00 28,500.00 2,087.75 16,037.55 56.272 12,462.45 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 3,727.43 24,860.20 77.688 7,139.80 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,084.01 28,595.32 58.656 20,155.68 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 82.00 830.34 15.377 4,569.66 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60125-030-000 Advertising 2,500.00 2,500.00 1,789.05 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 1,702.55 5,138.93 29.365 12,361.07 . glbase_tsam rgonzale Trophy Club MUD #1 Page 12 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 437.22 4,353.61 48.373 4,646.39 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 274.20 1,413.50 29.871 3,318.50 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 187.37 2,413.79 48.276 2,586.21 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 58.87 1,717.01 40.534 2,518.99 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 16,034.34 233,368.36 62.484 140,115.64 Program number: 1,287,019.00 1,277,987.00 67,842.70 748,554.28 58.573 529,432.72 Department number: Administration 1,287,019.00 1,277,987.00 67,842.70 748,554.28 58.573 529,432.72 . glbase_tsam rgonzale Trophy Club MUD #1 Page 13 15:39 05/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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 68,459.65 460,799.94 98.587 6,603.06 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 68,459.65 486,174.29 96.522 17,519.71 Program number: 286,291.00 503,694.00 68,459.65 486,174.29 96.522 17,519.71 Department number: Non Departmental 286,291.00 503,694.00 68,459.65 486,174.29 96.522 17,519.71 Expenditures Subtotal ----------- 8,444,333.00 8,846,514.00 397,472.77 3,529,044.86 39.892 5,317,469.14 Fund number: 135 MUD 1 General Fund 47,432.00- 864,310.03- 864,310.03 . glbase_tsam rgonzale Trophy Club MUD #1 Page 14 15:39 05/13/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/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:39 05/13/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 4/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:39 05/13/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 4/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:39 05/13/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 4/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income .90- 7.66- 7.66 Subtotal: .90- 7.66- 7.66 Program number: .90- 7.66- 7.66 Department number: .90- 7.66- 7.66 Revenues Subtotal ----------- .90- 7.66- 7.66 . glbase_tsam rgonzale Trophy Club MUD #1 Page 18 15:39 05/13/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 4/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 .90- 2,242.34 66.976 1,105.66 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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 1309 04/01/2015 Property Taxes/Assessments (164,448.76) (120.76) (164,569.52) GL 1310 04/02/2015 Property Taxes/Assessments (93.01) (164,662.53) GL 1311 04/06/2015 Property Taxes/Assessments (84.52) (164,747.05) GL 1312 04/07/2015 Property Taxes/Assessments (49.15) (164,796.20) GL 1313 04/08/2015 Property Taxes/Assessments (180.94) (164,977.14) GL 1314 04/09/2015 Property Taxes/Assessments (102.05) (165,079.19) GL 1315 04/10/2015 Property Taxes/Assessments (73.03) (165,152.22) GL 1316 04/13/2015 Property Taxes/Assessments (.10) (165,152.32) GL 1318 04/15/2015 Property Taxes/Assessments (5.94) (165,158.26) GL 1319 04/16/2015 Property Taxes/Assessments (3.88) (165,162.14) GL 1320 04/17/2015 Property Taxes/Assessments (37.50) (165,199.64) GL 1321 04/22/2015 Property Taxes/Assessments (3.47) (165,203.11) GL 1322 04/24/2015 Property Taxes/Assessments (40.48) (165,243.59) GL 1323 04/28/2015 Property Taxes/Assessments (32.42) (165,276.01) GL 1361 04/30/2015 Property Taxes/Assessments (522.31) (165,798.32) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (1,349.56) (165,798.32) ** (167,857.00) Budgeted (2,058.68) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1313 04/08/2015 Property Taxes/Assessments (401.35) (1.07) (402.42) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.07) (402.42) ** .00 Budgeted 402.42 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1309 04/01/2015 Property Taxes/Assessments (374.86) (6.12) (380.98) GL 1310 04/02/2015 Property Taxes/Assessments (2.57) (383.55) GL 1311 04/06/2015 Property Taxes/Assessments (6.37) (389.92) GL 1312 04/07/2015 Property Taxes/Assessments (4.49) (394.41) GL 1313 04/08/2015 Property Taxes/Assessments (15.85) (410.26) GL 1314 04/09/2015 Property Taxes/Assessments (11.22) (421.48) GL 1315 04/10/2015 Property Taxes/Assessments (8.04) (429.52) GL 1318 04/15/2015 Property Taxes/Assessments (.65) (430.17) GL 1319 04/16/2015 Property Taxes/Assessments (.43) (430.60) GL 1320 04/17/2015 Property Taxes/Assessments (4.13) (434.73) GL 1321 04/22/2015 Property Taxes/Assessments (.36) (435.09) GL 1322 04/24/2015 Property Taxes/Assessments (4.45) (439.54) GL 1323 04/28/2015 Property Taxes/Assessments (3.57) (443.11) GL 1361 04/30/2015 Property Taxes/Assessments (57.46) (500.57) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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: (125.71) (500.57) ** (900.00) Budgeted (399.43) Remaining 56 % Used Account: 135-40025-000-000 PID Surcharges 1274 04/30/2015 UB 4/30/2015 Billing UB20150430-20150430 User: (68,983.90) (11,721.30) (80,705.20) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (11,721.30) (80,705.20) ** (133,997.00) Budgeted (53,291.80) Remaining 60 % Used Account: 135-47000-000-000 Water 1275 04/01/2015 UB 4/1/15 adjustment UB20150401-20150401 User: (1,374,487.72) (28.76) (1,374,516.48) UB 1279 04/10/2015 UB 4/10/15 adj UB20150410-20150410 User: 38.06 (1,374,478.42) UB 1296 04/21/2015 UB 4/21/15 UB20150421-20150421 User: 4.20 (1,374,474.22) UB 1274 04/30/2015 UB 4/30/2015 Billing UB20150430-20150430 User: (223,309.39) (1,597,783.61) UB _______________ Account: 135-47000-000-000 Water Totals: (223,295.89) (1,597,783.61) ** (4,747,789.00) Budgeted (3,150,005.39) Remaining 34 % Used Account: 135-47005-000-000 Sewer 1296 04/21/2015 UB 4/21/15 UB20150421-20150421 User: (914,667.06) 4.90 (914,662.16) UB 1274 04/30/2015 UB 4/30/2015 Billing UB20150430-20150430 User: (158,908.14) (1,073,570.30) UB _______________ Account: 135-47005-000-000 Sewer Totals: (158,903.24) (1,073,570.30) ** (2,270,982.00) Budgeted (1,197,411.70) Remaining 47 % Used Account: 135-47025-000-000 Penalties 1239 04/21/2015 UB 4/21/15 Penalties UB20150421-20150421 User: (46,418.99) (5,623.37) (52,042.36) UB 1301 04/22/2015 UB 4/22/15 Penaltiy UB20150422-20150422 User: 10.45 (52,031.91) UB 1300 04/23/2015 UB 4/23/15 Penalties UB20150423-20150423 User: 20.11 (52,011.80) UB 1295 04/24/2015 UB 4/24/15 Penalties UB20150424-20150424 User: 84.55 (51,927.25) UB 1303 04/27/2015 UB 4/27/15 Adj UB20150427-20150427 User: 14.75 (51,912.50) UB 1304 04/29/2015 UB 4/29/15 Penalties UB20150429-20150429 User: 44.43 (51,868.07) UB _______________ Account: 135-47025-000-000 Penalties Totals: (5,449.08) (51,868.07) ** (80,000.00) Budgeted (28,131.93) Remaining 65 % Used Account: 135-47030-000-000 Service Charges . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1182 04/08/2015 UB 4/8/15 Cut Off Fees UB20150408-20150408 User: (5,793.00) (550.00) (6,343.00) UB 1277 04/08/2015 UB 4/8/15 After Hours Fee UB20150408-20150408 User: (400.00) (6,743.00) UB 1303 04/27/2015 UB 4/27/15 Adj UB20150427-20150427 User: 25.00 (6,718.00) UB 1274 04/30/2015 UB 4/30/2015 Billing UB20150430-20150430 User: (3.00) (6,721.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (928.00) (6,721.00) ** (10,000.00) Budgeted (3,279.00) Remaining 67 % Used Account: 135-47035-000-000 Plumbing Inspections 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (1,350.00) (100.00) (1,450.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,450.00) ** (2,000.00) Budgeted (550.00) Remaining 73 % Used Account: 135-47045-000-000 Sewer Inspections 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (4,050.00) (300.00) (4,350.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (4,350.00) ** (5,000.00) Budgeted (650.00) Remaining 87 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1274 04/30/2015 UB 4/30/2015 Billing UB20150430-20150430 User: (14,545.30) (1,323.70) (15,869.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (1,323.70) (15,869.00) ** (86,815.00) Budgeted (70,946.00) Remaining 18 % Used Account: 135-48005-000-000 Utility Fees 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (105,800.00) (29,900.00) (135,700.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (29,900.00) (135,700.00) ** (184,000.00) Budgeted (48,300.00) Remaining 74 % Used Account: 135-49010-000-000 Interest Income 1338 04/30/2015 Bank Interest/April (3,064.45) (33.34) (3,097.79) GL 1338 04/30/2015 Bank Interest/April (114.45) (3,212.24) GL 1338 04/30/2015 Bank Interest/April (309.65) (3,521.89) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (457.44) (3,521.89) ** (5,000.00) Budgeted (1,478.11) Remaining 70 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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-49016-000-000 Cell Tower Revenue 1269 04/01/2015 AT&T Cell Tower Revenue (5,463.18) (910.53) (6,373.71) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (6,373.71) ** (10,164.00) Budgeted (3,790.29) Remaining 63 % Used Account: 135-49018-000-000 Building Rent Income 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (3,499.98) (583.33) (4,083.31) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (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 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (28,997.83) (5,831.00) (34,828.83) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,831.00) (34,828.83) ** (42,000.00) Budgeted (7,171.17) Remaining 83 % Used Account: 135-49141-000-000 Interfund Transfer In (19,606.50) .00 (19,606.50) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (19,606.50) ** (19,607.00) Budgeted (.50) Remaining 100 % Used Account: 135-49145-000-000 Intergov Transfer In . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (1,074,337.15) .00 (1,074,337.15) _______________ 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 1270 04/23/2015 Drees/Service Application (37,441.89) (3,700.00) (41,141.89) GL 1274 04/30/2015 UB 4/30/2015 Billing UB20150430-20150430 User: (24.92) (41,166.81) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (3,724.92) (41,166.81) ** (68,994.00) Budgeted (27,827.19) Remaining 60 % 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,393,354.89) ** (8,846,514.00) Budgeted (4,453,159.11) Remaining 50 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1178 04/10/2015 MUD Payroll 4/10/15 Salaries & Wages 92,113.63 8,634.37 100,748.00 PR 1236 04/24/2015 MUD Payroll 4/24/15 Salaries & Wages 8,626.37 109,374.37 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 17,260.74 109,374.37 ** 244,578.00 Budgeted 135,203.63 Remaining 45 % Used Account: 135-50010-010-000 Overtime 1178 04/10/2015 MUD Payroll 4/10/15 Overtime 6,473.48 595.37 7,068.85 PR 1236 04/24/2015 MUD Payroll 4/24/15 Overtime 720.12 7,788.97 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,315.49 7,788.97 ** 19,500.00 Budgeted 11,711.03 Remaining 40 % 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 1236 04/24/2015 MUD Payroll 4/24/15 Certification 1,375.00 225.00 1,600.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 1,600.00 ** 3,900.00 Budgeted 2,300.00 Remaining 41 % Used Account: 135-50020-010-000 Retirement 1178 04/10/2015 MUD Payroll 4/10/15 Retirement 9,179.01 822.37 10,001.38 PR 1236 04/24/2015 MUD Payroll 4/24/15 Retirement 852.83 10,854.21 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,675.20 10,854.21 ** 23,987.00 Budgeted 13,132.79 Remaining 45 % Used Account: 135-50026-010-000 Medical Insurance 1178 04/10/2015 MUD Payroll 4/10/15 Medical Insurance 13,559.44 1,634.55 15,193.99 PR 1236 04/24/2015 MUD Payroll 4/24/15 Medical Insurance 1,634.50 16,828.49 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,269.05 16,828.49 ** 51,487.00 Budgeted 34,658.51 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1178 04/10/2015 MUD Payroll 4/10/15 Dental Insurance 1,087.24 133.99 1,221.23 PR 1236 04/24/2015 MUD Payroll 4/24/15 Dental Insurance 133.99 1,355.22 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 267.98 1,355.22 ** 4,188.00 Budgeted 2,832.78 Remaining 32 % Used Account: 135-50028-010-000 Vision Insurance 1178 04/10/2015 MUD Payroll 4/10/15 Vision Insurance 252.51 29.94 282.45 PR 1236 04/24/2015 MUD Payroll 4/24/15 Vision Insurance 29.98 312.43 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 59.92 312.43 ** 990.00 Budgeted 677.57 Remaining 32 % Used Account: 135-50029-010-000 Life Insurance & Other 1143 04/06/2015 Apr A/P Apr Dental, Vol Life, STD Visi 929.33 186.38 1,115.71 METLIFE GROUP BENEFITS 34820 AP 1289 04/30/2015 April A/P Café 125 Admin fee 8.44 1,124.15 BenefitMall 34849 AP 1369 04/30/2015 Adj Insurances (12.67) 1,111.48 GL _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 182.15 1,111.48 ** 3,074.00 Budgeted 1,962.52 Remaining 36 % Used Account: 135-50030-010-000 Social Security Taxes 1178 04/10/2015 MUD Payroll 4/10/15 Social Security Taxes 6,289.25 572.39 6,861.64 PR 1236 04/24/2015 MUD Payroll 4/24/15 Social Security Taxes 575.73 7,437.37 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,148.12 7,437.37 ** 17,192.00 Budgeted 9,754.63 Remaining 43 % Used Account: 135-50035-010-000 Medicare Taxes 1178 04/10/2015 MUD Payroll 4/10/15 Medicare Taxes 1,470.88 133.86 1,604.74 PR 1236 04/24/2015 MUD Payroll 4/24/15 Medicare Taxes 134.66 1,739.40 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 268.52 1,739.40 ** 4,021.00 Budgeted 2,281.60 Remaining 43 % Used Account: 135-50040-010-000 Unemployment Taxes 1178 04/10/2015 MUD Payroll 4/10/15 Unemployment Taxes 28.04 9.24 37.28 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1236 04/24/2015 MUD Payroll 4/24/15 Unemployment Taxes 28.04 (24.12) 13.16 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: (14.88) 13.16 ** 1,242.00 Budgeted 1,228.84 Remaining 1 % Used Account: 135-50045-010-000 Workman's Compensation 197 04/01/2015 Apr TML Ins & Workers Comp 3,827.46 857.91 4,685.37 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.91 4,685.37 ** 16,020.00 Budgeted 11,334.63 Remaining 29 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1289 04/30/2015 April A/P Employee testing 728.30 76.00 804.30 CARENOW CORPORATE 34853 AP 1339 04/30/2015 April A/P Pre-employment testing-Chitty 134.95 939.25 FIRST CHECK APPLICANT SCREENIN 34859 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 210.95 939.25 ** 1,300.00 Budgeted 360.75 Remaining 72 % Used Account: 135-50070-010-000 Employee Relations 1378 04/27/2015 PCard 03/27/15 to 04/27/15 SALAD BOWL 10 112.46 35.72 148.18 SALAD BOWL 10 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 35.72 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 1289 04/30/2015 April A/P Nitrogen bottle lease (6 mos.) 33,502.09 42.00 33,544.09 ALLIED WELDING SUPPLY, INC 34844 AP 1289 04/30/2015 April A/P 10 Qty AVK Hose Nozzle Gasket 41.80 33,585.89 HD SUPPLY WATERWORKS, LTD. 34865 AP 1289 04/30/2015 April A/P Alumminum Cap 2/Chains 134.12 33,720.01 HD SUPPLY WATERWORKS, LTD. 34865 AP 1339 04/30/2015 April A/P Dechlor Tablets 244.28 33,964.29 HD SUPPLY WATERWORKS, LTD. 34865 AP 1339 04/30/2015 April A/P Oil for pumps 878.50 34,842.79 LUBRICATION ENGINEERS, INC 34878 AP 1339 04/30/2015 April A/P 2" meter box 127.77 34,970.56 HD SUPPLY WATERWORKS, LTD. 34865 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-55080-010-000 Maintenance & Repairs Totals: 1,468.47 34,970.56 ** 81,113.00 Budgeted 46,142.44 Remaining 43 % Used Account: 135-55090-010-000 Vehicle Maintenance 1378 04/27/2015 PCard 03/27/15 to 04/27/15 ROANOKE AUTO SUPPLY LT 3,650.86 17.49 3,668.35 ROANOKE AUTO SUPPLY LT PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 INLAND TRUCK PARTS #18 40.00 3,708.35 INLAND TRUCK PARTS #18 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 DISCOUNT TIRE TXD 75 259.00 3,967.35 DISCOUNT TIRE TXD 75 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 BLAGG TIRE & SERVICE 38.00 4,005.35 BLAGG TIRE & SERVICE PC 1339 04/30/2015 April A/P Switch 116.30 4,121.65 GRAPEVINE FORD LINCOLN 34862 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 470.79 4,121.65 ** 8,000.00 Budgeted 3,878.35 Remaining 52 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1289 04/30/2015 April A/P Credit Hub return 243.00 (268.69) (25.69) HOLT CAT 34866 AP 1289 04/30/2015 April A/P Rim for Backhoe 290.51 264.82 HOLT CAT 34866 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 21.82 264.82 ** 3,500.00 Budgeted 3,235.18 Remaining 8 % Used Account: 135-55135-010-000 Lab Analysis 1289 04/30/2015 April A/P Testing/MUD 1,830.52 285.00 2,115.52 TARRANT CTY PUBLIC HEALTH LAB 34900 AP 1289 04/30/2015 April A/P Testing/MUD 464.28 2,579.80 LOWER COLORADO RIVER AUTHORITY 34877 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 749.28 2,579.80 ** 5,500.00 Budgeted 2,920.20 Remaining 47 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1289 04/30/2015 April A/P Cell phones 1,946.64 30.16 1,976.80 VERIZON WIRELESS 34912 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 30.16 1,976.80 ** 4,913.00 Budgeted 2,936.20 Remaining 40 % Used Account: 135-60020-010-000 Electricity 1289 04/30/2015 April A/P Electricity 3/11-4/10/15 54,203.04 420.80 54,623.84 HUDSON ENERGY SERVICES, LLC 34867 AP 1289 04/30/2015 April A/P Electricity 3/12-4/13/15 3,621.52 58,245.36 HUDSON ENERGY SERVICES, LLC 34867 AP 1289 04/30/2015 April A/P Electricity 3/12-4/13/15 5,599.76 63,845.12 HUDSON ENERGY SERVICES, LLC 34867 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-60020-010-000 Electricity Totals: 9,642.08 63,845.12 ** 160,765.00 Budgeted 96,919.88 Remaining 40 % 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 .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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 18,605.31 .00 18,605.31 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 18,605.31 ** 49,275.00 Budgeted 30,669.69 Remaining 38 % Used Account: 135-60150-010-000 Wholesale Water 1339 04/30/2015 April A/P March Wholesale Water 684,467.14 113,256.83 797,723.97 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 113,256.83 797,723.97 ** 2,928,308.00 Budgeted 2,130,584.03 Remaining 27 % 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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 THE HOME DEPOT 6581 1,180.71 59.94 1,240.65 THE HOME DEPOT 6581 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 TEX-TURF 24.80 1,265.45 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 84.74 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-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 1339 04/30/2015 April A/P April Gas/Diesel 5,856.20 1,092.50 6,948.70 US Bank Voyager Fleet Systems 34911 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,092.50 6,948.70 ** 19,173.00 Budgeted 12,224.30 Remaining 36 % Used Account: 135-65010-010-000 Uniforms 2,307.77 .00 2,307.77 _______________ 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 1289 04/30/2015 April A/P Chemicals 4,841.63 405.90 5,247.53 HACH COMPANY 34863 AP 1289 04/30/2015 April A/P Chlorine 508.25 5,755.78 DPC INDUSTRIES, INC 34857 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 914.15 5,755.78 ** 10,000.00 Budgeted 4,244.22 Remaining 58 % Used Account: 135-65035-010-000 Small Tools 1378 04/27/2015 PCard 03/27/15 to 04/27/15 THE HOME DEPOT 6581 68.37 49.68 118.05 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-010-000 Small Tools Totals: 49.68 118.05 ** 1,200.00 Budgeted 1,081.95 Remaining 10 % Used Account: 135-65040-010-000 Safety Equipment 1289 04/30/2015 April A/P 3 pairs Steel Toe hip boots 277.01 180.00 457.01 ATLAS UTILITY SUPPLY CO. 34846 AP _______________ Account: 135-65040-010-000 Safety Equipment Totals: 180.00 457.01 ** 1,000.00 Budgeted 542.99 Remaining 46 % Used Account: 135-65050-010-000 Meter Expense 1289 04/30/2015 April A/P Meter for Village Shops 24,909.84 2,274.50 27,184.34 ATLAS UTILITY SUPPLY CO. 34846 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-65050-010-000 Meter Expense Totals: 2,274.50 27,184.34 ** 165,000.00 Budgeted 137,815.66 Remaining 16 % Used Account: 135-69005-010-000 Capital Outlays 1378 04/27/2015 PCard 03/27/15 to 04/27/15 ROYAL TRUCK BODY 140,466.09 275.00 140,741.09 ROYAL TRUCK BODY PC 1339 04/30/2015 April A/P Valve Replacements 27,858.07 168,599.16 REY-MAR CONSTRUCTION 34890 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 28,133.07 168,599.16 ** 1,457,597.00 Budgeted 1,288,997.84 Remaining 12 % Used 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 1289 04/30/2015 April A/P Testing/PID 2,167.63 80.00 2,247.63 TARRANT CTY PUBLIC HEALTH LAB 34899 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1289 04/30/2015 April A/P Testing/PID 2,167.63 97.63 2,345.26 LOWER COLORADO RIVER AUTHORITY 34876 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 177.63 2,345.26 ** 5,000.00 Budgeted 2,654.74 Remaining 47 % 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 Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,642,476.54 ** 5,688,555.00 Budgeted 4,046,078.46 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 1178 04/10/2015 MUD Payroll 4/10/15 Salaries & Wages 141,631.41 11,841.35 153,472.76 PR 1236 04/24/2015 MUD Payroll 4/24/15 Salaries & Wages 11,841.34 165,314.10 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 23,682.69 165,314.10 ** 307,875.00 Budgeted 142,560.90 Remaining 54 % Used Account: 135-50010-020-000 Overtime 1178 04/10/2015 MUD Payroll 4/10/15 Overtime 16,153.08 954.44 17,107.52 PR 1236 04/24/2015 MUD Payroll 4/24/15 Overtime 1,081.57 18,189.09 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,036.01 18,189.09 ** 24,500.00 Budgeted 6,310.91 Remaining 74 % 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 1236 04/24/2015 MUD Payroll 4/24/15 Certification 3,300.00 550.00 3,850.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 3,850.00 ** 6,600.00 Budgeted 2,750.00 Remaining 58 % Used Account: 135-50020-020-000 Retirement 1178 04/10/2015 MUD Payroll 4/10/15 Retirement 14,904.93 1,140.10 16,045.03 PR 1236 04/24/2015 MUD Payroll 4/24/15 Retirement 1,200.43 17,245.46 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,340.53 17,245.46 ** 30,317.00 Budgeted 13,071.54 Remaining 57 % Used Account: 135-50026-020-000 Medical Insurance 1178 04/10/2015 MUD Payroll 4/10/15 Medical Insurance 27,617.89 2,343.40 29,961.29 PR 1236 04/24/2015 MUD Payroll 4/24/15 Medical Insurance 2,343.35 32,304.64 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,686.75 32,304.64 ** 56,244.00 Budgeted 23,939.36 Remaining 57 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 1178 04/10/2015 MUD Payroll 4/10/15 Dental Insurance 1,766.47 149.75 1,916.22 PR 1236 04/24/2015 MUD Payroll 4/24/15 Dental Insurance 149.76 2,065.98 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 299.51 2,065.98 ** 3,696.00 Budgeted 1,630.02 Remaining 56 % Used Account: 135-50028-020-000 Vision Insurance 1178 04/10/2015 MUD Payroll 4/10/15 Vision Insurance 411.39 34.48 445.87 PR 1236 04/24/2015 MUD Payroll 4/24/15 Vision Insurance 34.52 480.39 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 69.00 480.39 ** 912.00 Budgeted 431.61 Remaining 53 % Used Account: 135-50029-020-000 Life Insurance & Other 1143 04/06/2015 Apr A/P Apr Dental, Vol Life, STD Visi 1,662.60 251.35 1,913.95 METLIFE GROUP BENEFITS 34820 AP 1289 04/30/2015 April A/P Café 125 Admin fee 33.78 1,947.73 BenefitMall 34849 AP 1369 04/30/2015 Adj Insurances (12.66) 1,935.07 GL _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 272.47 1,935.07 ** 3,194.00 Budgeted 1,258.93 Remaining 61 % Used Account: 135-50030-020-000 Social Security Taxes 1178 04/10/2015 MUD Payroll 4/10/15 Social Security Taxes 9,273.06 731.93 10,004.99 PR 1236 04/24/2015 MUD Payroll 4/24/15 Social Security Taxes 747.75 10,752.74 PR 1289 04/30/2015 April A/P Employee testing 63.00 10,815.74 CARENOW CORPORATE 34853 AP _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,542.68 10,815.74 ** 21,812.00 Budgeted 10,996.26 Remaining 50 % Used Account: 135-50035-020-000 Medicare Taxes 1178 04/10/2015 MUD Payroll 4/10/15 Medicare Taxes 2,168.68 171.19 2,339.87 PR 1236 04/24/2015 MUD Payroll 4/24/15 Medicare Taxes 174.88 2,514.75 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 346.07 2,514.75 ** 5,101.00 Budgeted 2,586.25 Remaining 49 % Used Account: 135-50040-020-000 Unemployment Taxes . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1178 04/10/2015 MUD Payroll 4/10/15 Unemployment Taxes 52.28 12.80 65.08 PR 1236 04/24/2015 MUD Payroll 4/24/15 Unemployment Taxes (51.18) 13.90 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: (38.38) 13.90 ** 1,242.00 Budgeted 1,228.10 Remaining 1 % Used Account: 135-50045-020-000 Workman's Compensation 197 04/01/2015 Apr TML Ins & Workers Comp 3,827.46 857.91 4,685.37 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.91 4,685.37 ** 16,020.00 Budgeted 11,334.63 Remaining 29 % 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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 THE HOME DEPOT 6581 52,435.39 27.08 52,462.47 THE HOME DEPOT 6581 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 THE HOME DEPOT 6581 20.56 52,483.03 THE HOME DEPOT 6581 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 ROANOKE AUTO SUPPLY LT 29.68 52,512.71 ROANOKE AUTO SUPPLY LT PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 THE HOME DEPOT 6581 3.98 52,516.69 THE HOME DEPOT 6581 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 FERGUSON ENTERPRISES 1 71.44 52,588.13 FERGUSON ENTERPRISES 1 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 TEX-TURF 20.13 52,608.26 TEX-TURF PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 172.87 52,608.26 ** 72,600.00 Budgeted 19,991.74 Remaining 72 % Used Account: 135-55090-020-000 Vehicle Maintenance 1378 04/27/2015 PCard 03/27/15 to 04/27/15 AUTOZONE #4206 2,789.28 20.48 2,809.76 AUTOZONE #4206 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 MUSTANG ELITE CAR WASH 14.00 2,823.76 MUSTANG ELITE CAR WASH PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1378 04/27/2015 PCard 03/27/15 to 04/27/15 CLASSIC CHEVROLET LTD 2,789.28 500.78 3,324.54 CLASSIC CHEVROLET LTD PC 1289 04/30/2015 April A/P Chains for WW truck 144.00 3,468.54 NAPA AUTO PARTS 34881 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 679.26 3,468.54 ** 3,000.00 Budgeted (468.54) Remaining 116 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1378 04/27/2015 PCard 03/27/15 to 04/27/15 LANDMARK EQUIPMENT, IN 21.27 85.13 106.40 LANDMARK EQUIPMENT, IN PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 AUTOZONE #4206 22.78 129.18 AUTOZONE #4206 PC _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 107.91 129.18 ** 500.00 Budgeted 370.82 Remaining 26 % Used Account: 135-55125-020-000 Dumpster Services 1289 04/30/2015 April A/P Sludge haul off 32,177.08 958.52 33,135.60 L.H. CHANEY MATERIALS, INC. 34873 AP 1339 04/30/2015 April A/P Sludge haul off 760.63 33,896.23 L.H. CHANEY MATERIALS, INC. 34873 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 1,719.15 33,896.23 ** 55,000.00 Budgeted 21,103.77 Remaining 62 % Used Account: 135-55135-020-000 Lab Analysis 1289 04/30/2015 April A/P Testing 14,309.50 176.00 14,485.50 OXIDOR LABORATORIES LLC 34886 AP 1289 04/30/2015 April A/P Testing 246.00 14,731.50 OXIDOR LABORATORIES LLC 34886 AP 1289 04/30/2015 April A/P Testing 176.00 14,907.50 OXIDOR LABORATORIES LLC 34886 AP 1289 04/30/2015 April A/P Testing 246.00 15,153.50 OXIDOR LABORATORIES LLC 34886 AP 1289 04/30/2015 April A/P Testing 176.00 15,329.50 OXIDOR LABORATORIES LLC 34886 AP 1339 04/30/2015 April A/P Testing 246.00 15,575.50 OXIDOR LABORATORIES LLC 34886 AP 1339 04/30/2015 April A/P Testing 176.00 15,751.50 OXIDOR LABORATORIES LLC 34886 AP 1339 04/30/2015 April A/P Testing 246.00 15,997.50 OXIDOR LABORATORIES LLC 34886 AP 1339 04/30/2015 April A/P Testing 176.00 16,173.50 OXIDOR LABORATORIES LLC 34886 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,864.00 16,173.50 ** 25,000.00 Budgeted 8,826.50 Remaining 65 % Used Account: 135-60010-020-000 Communications/Mobiles 1289 04/30/2015 April A/P Cell phones 2,667.43 604.05 3,271.48 VERIZON WIRELESS 34912 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 604.05 3,271.48 ** 4,662.00 Budgeted 1,390.52 Remaining 70 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-60020-020-000 Electricity 1289 04/30/2015 April A/P Electricity 2/27-3/27 61,789.65 263.32 62,052.97 TRI COUNTY ELECTRIC 34906 AP 1289 04/30/2015 April A/P Electricity 2/27-3/27/15 130.06 62,183.03 TRI COUNTY ELECTRIC 34906 AP 1289 04/30/2015 April A/P Electricity 2/27-3/27/15 27.71 62,210.74 TRI COUNTY ELECTRIC 34906 AP 1289 04/30/2015 April A/P Electricity 3/11-4/10/15 120.38 62,331.12 HUDSON ENERGY SERVICES, LLC 34867 AP 1289 04/30/2015 April A/P Electricity 3/11-4/10/15 75.25 62,406.37 HUDSON ENERGY SERVICES, LLC 34867 AP 1289 04/30/2015 April A/P Electricity 3/12-4/13/15 97.10 62,503.47 HUDSON ENERGY SERVICES, LLC 34867 AP 1289 04/30/2015 April A/P Electricity 3/12-4/13/15 9,801.74 72,305.21 HUDSON ENERGY SERVICES, LLC 34867 AP 1289 04/30/2015 April A/P Electricity 3/12-4/13/15 585.78 72,890.99 HUDSON ENERGY SERVICES, LLC 34867 AP 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (138.68) 72,752.31 AR _______________ Account: 135-60020-020-000 Electricity Totals: 10,962.66 72,752.31 ** 139,292.00 Budgeted 66,539.69 Remaining 52 % 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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 TCEQ IND RENEWAL L 1,018.00 111.00 1,129.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 111.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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,791.25 .00 1,791.25 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 1,791.25 ** 2,000.00 Budgeted 208.75 Remaining 90 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1378 04/27/2015 PCard 03/27/15 to 04/27/15 NATIONAL CAR TOLLS 1.00 1.00 NATIONAL CAR TOLLS PC _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 1.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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-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 1372 04/01/2015 GF Transfer/Rev Bond Reserve 10,278.00 10,278.00 20,556.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 20,556.00 ** 71,946.00 Budgeted 51,390.00 Remaining 29 % Used Account: 135-65005-020-000 Fuel & Lube 1378 04/27/2015 PCard 03/27/15 to 04/27/15 MUSTANG ELITE CAR WASH 9,815.50 284.47 10,099.97 MUSTANG ELITE CAR WASH PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 MUSTANG ELITE CAR WASH 96.49 10,196.46 MUSTANG ELITE CAR WASH PC 1339 04/30/2015 April A/P April Gas/Diesel 1,462.68 11,659.14 US Bank Voyager Fleet Systems 34911 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,843.64 11,659.14 ** 20,328.00 Budgeted 8,668.86 Remaining 57 % 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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 POLYDYNE INC 7,827.65 1,080.00 8,907.65 POLYDYNE INC PC 1289 04/30/2015 April A/P Chemicals 778.57 9,686.22 United Laboratories 34910 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 1,858.57 9,686.22 ** 24,000.00 Budgeted 14,313.78 Remaining 40 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1378 04/27/2015 PCard 03/27/15 to 04/27/15 THE HOME DEPOT 6581 162.00 463.68 625.68 THE HOME DEPOT 6581 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 463.68 625.68 ** 750.00 Budgeted 124.32 Remaining 83 % Used Account: 135-65045-020-000 Lab Supplies 1378 04/27/2015 PCard 03/27/15 to 04/27/15 IDEXX DISTRIBUTION INC 5,933.25 171.21 6,104.46 IDEXX DISTRIBUTION INC PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 IDEXX DISTRIBUTION INC 3,222.17 9,326.63 IDEXX DISTRIBUTION INC PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 3,393.38 9,326.63 ** 13,000.00 Budgeted 3,673.37 Remaining 72 % Used Account: 135-69005-020-000 Capital Outlays 1289 04/30/2015 April A/P App 1/Lift Station 2 98,691.35 4,509.00 103,200.35 REY-MAR CONSTRUCTION 34890 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 4,509.00 103,200.35 ** 142,000.00 Budgeted 38,799.65 Remaining 73 % 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: ------------------------------------------------------------------------------------------------ 639,836.30 ** 1,353,397.00 Budgeted 713,560.70 Remaining 47 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 1236 04/24/2015 MUD Payroll 4/24/15 Salaries & Wages 6,300.00 600.00 6,900.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 600.00 6,900.00 ** 10,000.00 Budgeted 3,100.00 Remaining 69 % Used Account: 135-50030-026-000 Social Security Taxes 1236 04/24/2015 MUD Payroll 4/24/15 Social Security Taxes 390.60 37.20 427.80 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 37.20 427.80 ** 620.00 Budgeted 192.20 Remaining 69 % Used Account: 135-50035-026-000 Medicare Taxes 1236 04/24/2015 MUD Payroll 4/24/15 Medicare Taxes 91.35 8.70 100.05 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 8.70 100.05 ** 145.00 Budgeted 44.95 Remaining 69 % Used Account: 135-50040-026-000 Unemployment Taxes 1236 04/24/2015 MUD Payroll 4/24/15 Unemployment Taxes 58.48 .60 59.08 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .60 59.08 ** 230.00 Budgeted 170.92 Remaining 26 % Used Account: 135-50045-026-000 Workman's Compensation 197 04/01/2015 Apr TML Ins & Workers Comp 17.64 2.94 20.58 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 20.58 ** 36.00 Budgeted 15.42 Remaining 57 % 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 37 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 1,329.96 .00 1,329.96 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 1,329.96 ** 4,250.00 Budgeted 2,920.04 Remaining 31 % 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: ------------------------------------------------------------------------------------------------ 12,003.45 ** 22,881.00 Budgeted 10,877.55 Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 1178 04/10/2015 MUD Payroll 4/10/15 Salaries & Wages 216,603.17 17,859.99 234,463.16 PR 1236 04/24/2015 MUD Payroll 4/24/15 Salaries & Wages 17,854.35 252,317.51 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,714.34 252,317.51 ** 470,732.00 Budgeted 218,414.49 Remaining 54 % Used Account: 135-50010-030-000 Overtime 1178 04/10/2015 MUD Payroll 4/10/15 Overtime 411.11 26.22 437.33 PR 1236 04/24/2015 MUD Payroll 4/24/15 Overtime 9.45 446.78 PR _______________ Account: 135-50010-030-000 Overtime Totals: 35.67 446.78 ** 1,000.00 Budgeted 553.22 Remaining 45 % 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 1178 04/10/2015 MUD Payroll 4/10/15 Retirement 19,696.11 1,593.66 21,289.77 PR 1236 04/24/2015 MUD Payroll 4/24/15 Retirement 1,591.67 22,881.44 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,185.33 22,881.44 ** 42,184.00 Budgeted 19,302.56 Remaining 54 % Used Account: 135-50026-030-000 Medical Insurance 1178 04/10/2015 MUD Payroll 4/10/15 Medical Insurance 28,045.20 2,583.19 30,628.39 PR 1236 04/24/2015 MUD Payroll 4/24/15 Medical Insurance 2,583.14 33,211.53 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,166.33 33,211.53 ** 62,000.00 Budgeted 28,788.47 Remaining 54 % Used Account: 135-50027-030-000 Dental Insurance 1178 04/10/2015 MUD Payroll 4/10/15 Dental Insurance 2,006.28 182.11 2,188.39 PR 1236 04/24/2015 MUD Payroll 4/24/15 Dental Insurance 182.13 2,370.52 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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,370.52 ** 4,494.00 Budgeted 2,123.48 Remaining 53 % Used Account: 135-50028-030-000 Vision Insurance 1178 04/10/2015 MUD Payroll 4/10/15 Vision Insurance 472.59 42.16 514.75 PR 1236 04/24/2015 MUD Payroll 4/24/15 Vision Insurance 42.22 556.97 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 84.38 556.97 ** 1,116.00 Budgeted 559.03 Remaining 50 % Used Account: 135-50029-030-000 Life Insurance & Other 1143 04/06/2015 Apr A/P Apr Dental, Vol Life, STD Visi 2,143.77 331.92 2,475.69 METLIFE GROUP BENEFITS 34820 AP 1289 04/30/2015 April A/P Café 125 Admin fee 33.78 2,509.47 BenefitMall 34849 AP 1369 04/30/2015 Adj Insurances (12.66) 2,496.81 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 353.04 2,496.81 ** 4,333.00 Budgeted 1,836.19 Remaining 58 % Used Account: 135-50030-030-000 Social Security Taxes 1178 04/10/2015 MUD Payroll 4/10/15 Social Security Taxes 12,949.66 1,046.99 13,996.65 PR 1236 04/24/2015 MUD Payroll 4/24/15 Social Security Taxes 1,026.08 15,022.73 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,073.07 15,022.73 ** 29,654.00 Budgeted 14,631.27 Remaining 51 % Used Account: 135-50035-030-000 Medicare Taxes 1178 04/10/2015 MUD Payroll 4/10/15 Medicare Taxes 3,028.52 244.86 3,273.38 PR 1236 04/24/2015 MUD Payroll 4/24/15 Medicare Taxes 239.99 3,513.37 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 484.85 3,513.37 ** 7,317.00 Budgeted 3,803.63 Remaining 48 % Used Account: 135-50040-030-000 Unemployment Taxes 1178 04/10/2015 MUD Payroll 4/10/15 Unemployment Taxes 204.19 17.90 222.09 PR 1236 04/24/2015 MUD Payroll 4/24/15 Unemployment Taxes (78.53) 143.56 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: (60.63) 143.56 ** 1,449.00 Budgeted 1,305.44 Remaining 10 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 197 04/01/2015 Apr TML Ins & Workers Comp 523.80 87.30 611.10 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 611.10 ** 1,636.00 Budgeted 1,024.90 Remaining 37 % 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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 CHICK-FIL-A #02892 2,261.64 200.00 2,461.64 CHICK-FIL-A #02892 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 200.00 2,461.64 ** 5,000.00 Budgeted 2,538.36 Remaining 49 % Used Account: 135-55030-030-000 Software & Support 1378 04/27/2015 PCard 03/27/15 to 04/27/15 ATT*BILL PAYMENT 92,779.89 52.18 92,832.07 ATT*BILL PAYMENT PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 ATT*BILL PAYMENT 69.77 92,901.84 ATT*BILL PAYMENT PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 DNH*GODADDY.COM 359.64 93,261.48 DNH*GODADDY.COM PC 1289 04/30/2015 April A/P Software support 1,380.00 94,641.48 STW INC 34897 AP 1289 04/30/2015 April A/P Internet 1,075.25 95,716.73 WHOLESALE CARRIER SERVICES INC 34915 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 2,936.84 95,716.73 ** 121,635.00 Budgeted 25,918.27 Remaining 79 % Used Account: 135-55070-030-000 Independent Labor 25,800.00 .00 25,800.00 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 25,800.00 ** 32,550.00 Budgeted 6,750.00 Remaining 79 % Used Account: 135-55080-030-000 Maintenance & Repairs .00 .00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 .00 ** 4,500.00 Budgeted 4,500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-55100-030-000 Building Maint & Supplies 1143 04/06/2015 Apr A/P Replace TXV on unit for the se 3,413.70 600.00 4,013.70 NORTH TX HEATING & AIR, INC 34824 AP 1289 04/30/2015 April A/P Air freshener 61.52 4,075.22 G & K SERVICES 34861 AP 1289 04/30/2015 April A/P Rug Service 143.46 4,218.68 G & K SERVICES 34861 AP 1289 04/30/2015 April A/P Air Freshener 61.52 4,280.20 G & K SERVICES 34861 AP 1289 04/30/2015 April A/P Rug Service 143.46 4,423.66 G & K SERVICES 34861 AP 1289 04/30/2015 April A/P A/C Server room 92.00 4,515.66 NORTH TX HEATING & AIR, INC 34883 AP 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (489.46) 4,026.20 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 612.50 4,026.20 ** 6,500.00 Budgeted 2,473.80 Remaining 62 % Used Account: 135-55120-030-000 Cleaning Services 3,765.18 .00 3,765.18 _______________ Account: 135-55120-030-000 Cleaning Services Totals: .00 3,765.18 ** 8,100.00 Budgeted 4,334.82 Remaining 46 % 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 1289 04/30/2015 April A/P March Utility Billing, Waterfe 3,182.30 571.10 3,753.40 DATAPROSE LLC 34855 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-55205-030-000 Utility Billing Contract Totals: 571.10 3,753.40 ** 8,200.00 Budgeted 4,446.60 Remaining 46 % Used Account: 135-60005-030-000 Telephone 1378 04/27/2015 PCard 03/27/15 to 04/27/15 RINGCENTRAL, INC 5,654.42 10.73 5,665.15 RINGCENTRAL, INC PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 ATT*BUS PHONE PMT 438.01 6,103.16 ATT*BUS PHONE PMT PC 1289 04/30/2015 April A/P BOA PCards 377.69 6,480.85 TOWN OF TROPHY CLUB 34905 AP 1289 04/30/2015 April A/P Answering Servic 4/6-4/3 206.00 6,686.85 KEYSTONE PARK SECRETARIAL 34872 AP 1289 04/30/2015 April A/P Answering service 5/4-5/31 180.00 6,866.85 KEYSTONE PARK SECRETARIAL 34872 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,212.43 6,866.85 ** 13,361.00 Budgeted 6,494.15 Remaining 51 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1236 04/24/2015 MUD Payroll 4/24/15 Communications/Pagers/Mobiles 2,041.82 300.00 2,341.82 PR 1289 04/30/2015 April A/P Cell phones 37.99 2,379.81 VERIZON WIRELESS 34912 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 337.99 2,379.81 ** 4,056.00 Budgeted 1,676.19 Remaining 59 % Used Account: 135-60020-030-000 Electricity/Gas 3,668.68 .00 3,668.68 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 3,668.68 ** 12,000.00 Budgeted 8,331.32 Remaining 31 % Used Account: 135-60025-030-000 Water 1289 04/30/2015 April A/P April Water 434.58 106.93 541.51 TROPHY CLUB MUD (WATER BILLS) 34907 AP 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (53.46) 488.05 AR _______________ Account: 135-60025-030-000 Water Totals: 53.47 488.05 ** 1,500.00 Budgeted 1,011.95 Remaining 33 % Used Account: 135-60035-030-000 Postage 1258 04/27/2015 Postage for CC Draft Customers Credit Card Customer letter to 13,949.80 138.25 14,088.05 U.S. POSTAL SERVICE 34841 AP 1378 04/27/2015 PCard 03/27/15 to 04/27/15 USPS 48764506630613152 12.98 14,101.03 USPS 48764506630613152 PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 USPS 48323795520601514 28.75 14,129.78 USPS 48323795520601514 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1289 04/30/2015 April A/P Overnight delivery 13,949.80 3.52 14,133.30 FEDERAL EXPRESS CORP 34858 AP 1289 04/30/2015 April A/P Overnight delivery 4.99 14,138.29 FEDERAL EXPRESS CORP 34858 AP 1289 04/30/2015 April A/P March Utility Billing, Waterfe 1,701.70 15,839.99 DATAPROSE LLC 34855 AP 1307 04/30/2015 MUD Postage meter usage/Apr 197.56 16,037.55 GL _______________ Account: 135-60035-030-000 Postage Totals: 2,087.75 16,037.55 ** 28,500.00 Budgeted 12,462.45 Remaining 56 % Used Account: 135-60040-030-000 Service Charges & Fees 1351 04/02/2015 Credit Card Fees 21,132.77 61.33 21,194.10 GL 1351 04/02/2015 Credit Card Fees 115.80 21,309.90 GL 1351 04/02/2015 Credit Card Fees 3,293.41 24,603.31 GL 1143 04/06/2015 Apr A/P Interest charges 6.89 24,610.20 NAPA AUTO PARTS 34822 AP 1337 04/13/2015 Bank Analysis Fee- Mar 250.00 24,860.20 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,727.43 24,860.20 ** 32,000.00 Budgeted 7,139.80 Remaining 78 % 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 197 04/01/2015 Apr TML Ins & Workers Comp 24,511.31 4,063.01 28,574.32 GL 1289 04/30/2015 April A/P Kristen Notary application 21.00 28,595.32 OFC OF THE SECRETARY OF STATE 34884 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,084.01 28,595.32 ** 48,751.00 Budgeted 20,155.68 Remaining 59 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 IN *HAPPY JUMPER 3,384.79 120.00 3,504.79 IN *HAPPY JUMPER PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 FOX RENTAL 175.00 3,679.79 FOX RENTAL PC 1289 04/30/2015 April A/P March Utility Billing, Waterfe 800.02 4,479.81 DATAPROSE LLC 34855 AP 1289 04/30/2015 April A/P Scholarships for Rain Barrel c 375.00 4,854.81 KEEP TROPHY CLUB WILD, INC. 34871 AP 1380 04/30/2015 Correction of Coding Correction of Coding (1,470.02) 3,384.79 GL _______________ 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 1178 04/10/2015 MUD Payroll 4/10/15 Travel & per diem 748.34 5.98 754.32 PR 1236 04/24/2015 MUD Payroll 4/24/15 Travel & per diem 76.02 830.34 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 82.00 830.34 ** 5,400.00 Budgeted 4,569.66 Remaining 15 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-60125-030-000 Advertising 1339 04/30/2015 April A/P Ad for Sludge Hauling 2,004.09 588.27 2,592.36 STAR-TELEGRAM OPERATING LTD 34895 AP 1339 04/30/2015 April A/P Ad for Auditor RFP 551.91 3,144.27 STAR-TELEGRAM OPERATING LTD 34895 AP 1339 04/30/2015 April A/P Notice of Adoption of Order # 648.87 3,793.14 STAR-TELEGRAM OPERATING LTD 34895 AP _______________ Account: 135-60125-030-000 Advertising Totals: 1,789.05 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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 VCN*DENTONRECCTR 3,436.38 153.00 3,589.38 VCN*DENTONRECCTR PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 CFW POLICE RECORDS 6.00 3,595.38 CFW POLICE RECORDS PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 COWTOWN BUS CHARTERS I 73.53 3,668.91 COWTOWN BUS CHARTERS I PC 1380 04/30/2015 Correction of Coding 1,470.02 5,138.93 GL _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 1,702.55 5,138.93 ** 17,500.00 Budgeted 12,361.07 Remaining 29 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-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 1378 04/27/2015 PCard 03/27/15 to 04/27/15 OFFICE DEPOT #406 3,916.39 49.99 3,966.38 OFFICE DEPOT #406 PC 1289 04/30/2015 April A/P JPMC PCards Feb 18.73 3,985.11 TOWN OF TROPHY CLUB 34905 AP 1289 04/30/2015 April A/P Office Supplies 81.77 4,066.88 OFFICE DEPOT, INC 34885 AP 1289 04/30/2015 April A/P Office Supplies 17.58 4,084.46 OFFICE DEPOT, INC 34885 AP 1289 04/30/2015 April A/P Office Supplies 35.85 4,120.31 OFFICE DEPOT, INC 34885 AP 1289 04/30/2015 April A/P Office Supplies 34.46 4,154.77 OFFICE DEPOT, INC 34885 AP 1289 04/30/2015 April A/P Office Supplies 29.99 4,184.76 OFFICE DEPOT, INC 34885 AP 1289 04/30/2015 April A/P Office Supplies 74.63 4,259.39 OFFICE DEPOT, INC 34885 AP 1289 04/30/2015 April A/P Office Supplies 10.17 4,269.56 OFFICE DEPOT, INC 34885 AP 1289 04/30/2015 April A/P Office Supplies 71.69 4,341.25 OFFICE DEPOT, INC 34885 AP 1289 04/30/2015 April A/P Office Supplies 38.97 4,380.22 OFFICE DEPOT, INC 34885 AP 1289 04/30/2015 April A/P Office Supplies 69.64 4,449.86 OFFICE DEPOT, INC 34885 AP 1375 04/30/2015 Town Billing Inv 1290-1304 AR 20150401-20150430 User: (96.25) 4,353.61 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 437.22 4,353.61 ** 9,000.00 Budgeted 4,646.39 Remaining 48 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1378 04/27/2015 PCard 03/27/15 to 04/27/15 SHI GOVERNMENT SOLUTIO 1,139.30 274.20 1,413.50 SHI GOVERNMENT SOLUTIO PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 274.20 1,413.50 ** 4,732.00 Budgeted 3,318.50 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-65095-030-000 Maintenance Supplies 1378 04/27/2015 PCard 03/27/15 to 04/27/15 WALMART.COM 2,226.42 43.26 2,269.68 WALMART.COM PC 1378 04/27/2015 PCard 03/27/15 to 04/27/15 SAMS CLUB #4795 144.11 2,413.79 SAMS CLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 187.37 2,413.79 ** 5,000.00 Budgeted 2,586.21 Remaining 48 % 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 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 1289 04/30/2015 April A/P Verizon, Nevill 1,658.14 58.87 1,717.01 TOWN OF TROPHY CLUB 34905 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 58.87 1,717.01 ** 4,236.00 Budgeted 2,518.99 Remaining 41 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 30 Totals: ------------------------------------------------------------------------------------------------ 748,554.28 ** 1,277,987.00 Budgeted 529,432.72 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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 1289 04/30/2015 April A/P General/Mar legal 392,340.29 840.00 393,180.29 WHITAKER CHALK SWINDLE 34914 AP 1289 04/30/2015 April A/P BDMR Legal 305.00 393,485.29 WHITAKER CHALK SWINDLE 34914 AP 1289 04/30/2015 April A/P McGuire Thomas lawsuit 47,093.30 440,578.59 WHITAKER CHALK SWINDLE 34914 AP 1289 04/30/2015 April A/P Damage claim/BDMR & THB 3,406.80 443,985.39 WHITAKER CHALK SWINDLE 34914 AP 1289 04/30/2015 April A/P Annex Building 3,554.55 447,539.94 WHITAKER CHALK SWINDLE 34914 AP 1289 04/30/2015 April A/P Mar legal 1,500.00 449,039.94 THE LISTON LAW FIRM, P.C. 34902 AP 1289 04/30/2015 April A/P Mar legal 3,210.00 452,249.94 THE LISTON LAW FIRM, P.C. 34902 AP 1289 04/30/2015 April A/P Legal/March 8,550.00 460,799.94 FREEMAN & CORBETT 34860 AP _______________ Account: 135-55045-039-000 Legal Totals: 68,459.65 460,799.94 ** 467,403.00 Budgeted 6,603.06 Remaining 99 % 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: ------------------------------------------------------------------------------------------------ 486,174.29 ** 503,694.00 Budgeted 17,519.71 Remaining 97 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (864,310.03) .00 Budgeted 864,310.03 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/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 51 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 4/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 52 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 4/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 53 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 4/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 1338 04/30/2015 Bank Interest/April (6.76) (.90) (7.66) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (.90) (7.66) ** .00 Budgeted 7.66 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (7.66) ** .00 Budgeted 7.66 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 4/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,242.34 3,348.00 Budgeted 1,105.66 Remaining 67 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET APRIL 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 602,836 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 16,925 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 624,607 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 16,925 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 16,925 FUND BALANCE ASSIGNED FUND BALANCE 14,753 NET REVENUES / EXPENDITURES 592,929 TOTAL FUND BALANCE 607,682 TOTAL LIABILITIES AND FUND BALANCE 624,607 . glbase_tsam rgonzale Trophy Club MUD #1 Page 24 15:39 05/13/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/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- 3,747.21- 460,352.04- 98.784 5,666.96- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 4.19- 1,584.84- 63.394 915.16- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 349.18- 1,325.85- 82.866 274.15- 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- 25.83- 3,383.79- 902.344 3,008.79 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- 4,126.41- 683,433.42- 89.739 78,144.58- Program number: 1,139,861.00- 761,578.00- 4,126.41- 683,433.42- 89.739 78,144.58- Department number: Revenues 1,139,861.00- 761,578.00- 4,126.41- 683,433.42- 89.739 78,144.58- Revenues Subtotal ----------- 1,139,861.00- 761,578.00- 4,126.41- 683,433.42- 89.739 78,144.58- . glbase_tsam rgonzale Trophy Club MUD #1 Page 25 15:39 05/13/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/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- 4,126.41- 592,929.67- 1,691.958 557,885.67 . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/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 1309 04/01/2015 Property Taxes/Assessments (456,604.83) (335.28) (456,940.11) GL 1310 04/02/2015 Property Taxes/Assessments (258.26) (457,198.37) GL 1311 04/06/2015 Property Taxes/Assessments (234.66) (457,433.03) GL 1312 04/07/2015 Property Taxes/Assessments (136.46) (457,569.49) GL 1313 04/08/2015 Property Taxes/Assessments (502.41) (458,071.90) GL 1314 04/09/2015 Property Taxes/Assessments (283.34) (458,355.24) GL 1315 04/10/2015 Property Taxes/Assessments (202.79) (458,558.03) GL 1316 04/13/2015 Property Taxes/Assessments (.27) (458,558.30) GL 1318 04/15/2015 Property Taxes/Assessments (16.49) (458,574.79) GL 1319 04/16/2015 Property Taxes/Assessments (10.79) (458,585.58) GL 1320 04/17/2015 Property Taxes/Assessments (104.13) (458,689.71) GL 1321 04/22/2015 Property Taxes/Assessments (9.64) (458,699.35) GL 1322 04/24/2015 Property Taxes/Assessments (112.40) (458,811.75) GL 1323 04/28/2015 Property Taxes/Assessments (90.04) (458,901.79) GL 1361 04/30/2015 Property Taxes/Assessments (1,450.25) (460,352.04) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (3,747.21) (460,352.04) ** (466,019.00) Budgeted (5,666.96) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1313 04/08/2015 Property Taxes/Assessments (1,580.65) (4.19) (1,584.84) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (4.19) (1,584.84) ** (2,500.00) Budgeted (915.16) Remaining 63 % Used Account: 533-40015-000-000 Property Taxes/P & I 1309 04/01/2015 Property Taxes/Assessments (976.67) (17.01) (993.68) GL 1310 04/02/2015 Property Taxes/Assessments (7.13) (1,000.81) GL 1311 04/06/2015 Property Taxes/Assessments (17.70) (1,018.51) GL 1312 04/07/2015 Property Taxes/Assessments (12.28) (1,030.79) GL 1313 04/08/2015 Property Taxes/Assessments (44.32) (1,075.11) GL 1314 04/09/2015 Property Taxes/Assessments (31.17) (1,106.28) GL 1315 04/10/2015 Property Taxes/Assessments (22.30) (1,128.58) GL 1316 04/13/2015 Property Taxes/Assessments (.02) (1,128.60) GL 1318 04/15/2015 Property Taxes/Assessments (1.81) (1,130.41) GL 1319 04/16/2015 Property Taxes/Assessments (1.18) (1,131.59) GL 1320 04/17/2015 Property Taxes/Assessments (11.45) (1,143.04) GL 1321 04/22/2015 Property Taxes/Assessments (.99) (1,144.03) GL 1322 04/24/2015 Property Taxes/Assessments (12.36) (1,156.39) GL 1323 04/28/2015 Property Taxes/Assessments (9.91) (1,166.30) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1361 04/30/2015 Property Taxes/Assessments (976.67) (159.55) (1,325.85) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (349.18) (1,325.85) ** (1,600.00) Budgeted (274.15) Remaining 83 % 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 1338 04/30/2015 Bank Interest/April (3,357.96) (25.83) (3,383.79) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (25.83) (3,383.79) ** (375.00) Budgeted 3,008.79 Remaining 902 % 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: ------------------------------------------------------------------------------------------------ (683,433.42) ** (761,578.00) Budgeted (78,144.58) Remaining 90 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/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: ------------------------------------------------------------------------------------------------------ (592,929.67) (35,044.00) Budgeted 557,885.67 Remaining ########## TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET APRIL 2015 517 ASSETS TAX BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 4,377,344 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,377,344 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 4,377,344 TOTAL FUND BALANCE 4,377,344 TOTAL LIABILITIES AND FUND BALANCE 4,377,344 . glbase_tsam rgonzale Trophy Club MUD #1 Page 19 15:39 05/13/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 188.47- 760.41- 760.41 517-49105-000-000 Bond Proceeds 5,765,000.00- 5,765,000.00 Subtotal: 188.47- 5,765,760.41- 5,765,760.41 Program number: 188.47- 5,765,760.41- 5,765,760.41 Department number: Revenues 188.47- 5,765,760.41- 5,765,760.41 Revenues Subtotal ----------- 188.47- 5,765,760.41- 5,765,760.41 . glbase_tsam rgonzale Trophy Club MUD #1 Page 20 15:39 05/13/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/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 188.47- 4,377,344.20- 4,377,344.20 . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/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 1338 04/30/2015 Bank Interest/April (571.94) (188.47) (760.41) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (188.47) (760.41) ** .00 Budgeted 760.41 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,760.41) ** .00 Budgeted 5,765,760.41 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/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,344.20) .00 Budgeted 4,377,344.20 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET APRIL 2015 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 9,017,602 ACCOUNTS RECEIVABLE - TOTAL ASSETS 9,017,602 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 38,624 TOTAL LIABILITIES 38,624 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 8,978,978 TOTAL FUND BALANCE 8,978,978 TOTAL LIABILITIES AND FUND BALANCE 9,017,602 . glbase_tsam rgonzale Trophy Club MUD #1 Page 21 15:39 05/13/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 4/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 388.25- 888.01- 888.01 518-49105-000-000 Bond Proceeds 9,230,000.00- 9,230,000.00 Subtotal: 388.25- 9,230,888.01- 9,230,888.01 Program number: 388.25- 9,230,888.01- 9,230,888.01 Department number: Revenues 388.25- 9,230,888.01- 9,230,888.01 Revenues Subtotal ----------- 388.25- 9,230,888.01- 9,230,888.01 . glbase_tsam rgonzale Trophy Club MUD #1 Page 22 15:39 05/13/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 4/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 25,737.50 37,962.50 37,962.50- Subtotal: 25,737.50 61,640.95 61,640.95- 518-70020-020-000 Bond Issuance Costs 190,269.00 190,269.00- Subtotal: 190,269.00 190,269.00- Program number: 25,737.50 251,909.95 251,909.95- Department number: Wastewater 25,737.50 251,909.95 251,909.95- Expenditures Subtotal ----------- 25,737.50 251,909.95 251,909.95- Fund number: 518 2015 Revenue Bond Const Fund 25,349.25 8,978,978.06- 8,978,978.06 . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 4/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 1338 04/30/2015 Bank Interest/April (499.76) (388.25) (888.01) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (388.25) (888.01) ** .00 Budgeted 888.01 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,230,888.01) ** .00 Budgeted 9,230,888.01 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 4/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 1289 04/30/2015 April A/P WWTP Improvements 12,225.00 25,737.50 37,962.50 THE WALLACE GROUP, INC. 34903 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 25,737.50 37,962.50 ** .00 Budgeted (37,962.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: ------------------------------------------------------------------------------------------------ 251,909.95 ** .00 Budgeted (251,909.95) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ (8,978,978.06) .00 Budgeted 8,978,978.06 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET APRIL 2015 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 20,557 ACCOUNTS RECEIVABLE - TOTAL ASSETS 20,557 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 20,557 TOTAL FUND BALANCE 20,557 TOTAL LIABILITIES AND FUND BALANCE 20,557 . glbase_tsam rgonzale Trophy Club MUD #1 Page 23 15:39 05/13/15 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income .90- 1.20- 1.20 528-49141-000-000 Interfund Transfer In-Gen Fund 71,946.00- 10,278.00- 20,556.00- 28.571 51,390.00- Subtotal: 71,946.00- 10,278.90- 20,557.20- 28.573 51,388.80- Program number: 71,946.00- 10,278.90- 20,557.20- 28.573 51,388.80- Department number: 71,946.00- 10,278.90- 20,557.20- 28.573 51,388.80- Revenues Subtotal ----------- 71,946.00- 10,278.90- 20,557.20- 28.573 51,388.80- Fund number: 528 2015 Revenue Bond Reserve Fund 71,946.00- 10,278.90- 20,557.20- 28.573 51,388.80- . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/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 1338 04/30/2015 Bank Interest/April (.30) (.90) (1.20) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (.90) (1.20) ** .00 Budgeted 1.20 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 1372 04/01/2015 GF Transfer/Rev Bond Reserve (10,278.00) (10,278.00) (20,556.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (10,278.00) (20,556.00) ** (71,946.00) Budgeted (51,390.00) Remaining 29 % Used Department Totals: ------------------------------------------------------------------------------------------------ (20,557.20) ** (71,946.00) Budgeted (51,388.80) Remaining 29 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (20,557.20) (71,946.00) Budgeted (51,388.80) Remaining 29 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET APRIL 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:39 05/13/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income .60- 10,438.68- 10,438.68 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- .60- 15,053.68- 10.989 121,935.32- Program number: 136,989.00- .60- 15,053.68- 10.989 121,935.32- Department number: Revenues 136,989.00- .60- 15,053.68- 10.989 121,935.32- Revenues Subtotal ----------- 136,989.00- .60- 15,053.68- 10.989 121,935.32- . glbase_tsam rgonzale Trophy Club MUD #1 Page 27 15:39 05/13/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/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 .60- 15,053.68- 15,053.68 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/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 1338 04/30/2015 Bank Interest/April (10,438.08) (.60) (10,438.68) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (.60) (10,438.68) ** .00 Budgeted 10,438.68 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,053.68) ** (136,989.00) Budgeted (121,935.32) Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 64 15:40 05/13/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/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,053.68) .00 Budgeted 15,053.68 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (15,198,438.98) **** (103,642.00) Budgeted 15,094,796.98 Remaining ########## ******* End of Report *********