Loading...
HomeMy WebLinkAboutMay Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MAY 2014 122 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 997,266 PREPAID EXPENSES 6,688 ADVALOREM PROPERTY TAXES RECEIVABLE 24,965 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 10,246 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,771 TOTAL ASSETS 1,041,936 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 35,211 ACCOUNTS AND OTHER PAYABLES 37,440 TOTAL LIABILITIES 72,651 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE 2,141 UNASSIGNED FUND BALANCE 493,547 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 473,597 TOTAL FUND BALANCE 969,285 TOTAL LIABILITIES AND FUND BALANCE 1,041,936 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 08:23 06/11/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 305,445.00- 305,445.00- 463.38- 307,956.24- 100.822 2,511.24 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1,581.21- 1,581.21 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 4,663.77- 914,849.18- 98.630 12,705.82- 122-40011-000-000 Property Taxes/Fire-Delinquent 137.74- 1,343.88- 1,343.88 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- .53- 545.93- 72.791 204.07- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 380.72- 4,701.51- 104.478 201.51 Subtotal: 1,238,250.00- 1,238,250.00- 5,646.14- 1,230,977.95- 99.413 7,272.05- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 3,600.00- 60.000 2,400.00- Subtotal: 6,000.00- 6,000.00- 400.00- 3,600.00- 60.000 2,400.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 75.00- 675.00- 96.429 25.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,700.00- 10,700.00- 75.00- 675.00- 6.308 10,025.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 525.00- 5,525.00- 92.083 475.00- Subtotal: 6,000.00- 6,000.00- 525.00- 5,525.00- 92.083 475.00- Program number: 1,260,950.00- 1,260,950.00- 6,646.14- 1,240,777.95- 98.400 20,172.05- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 6,646.14- 1,240,777.95- 98.400 20,172.05- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 6,646.14- 1,240,777.95- 98.400 20,172.05- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 08:23 06/11/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 455,916.00 455,916.00 34,822.72 291,381.80 63.911 164,534.20 122-50010-045-000 Overtime 44,225.00 44,225.00 2,660.98 23,121.11 52.281 21,103.89 122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,289.86 98.232 239.14 122-50016-045-000 Longevity 4,768.00 4,768.00 4,655.00 97.630 113.00 122-50017-045-000 Certification 4,350.00 4,350.00 375.00 2,964.39 68.147 1,385.61 122-50020-045-000 Retirement 70,991.00 70,991.00 5,546.31 47,591.30 67.038 23,399.70 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,316.43 33,142.11 58.177 23,825.89 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 352.82 2,703.30 63.908 1,526.70 122-50028-045-000 Vision Insurance 892.00 892.00 69.54 554.82 62.200 337.18 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 326.58 2,522.55 59.354 1,727.45 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 2,135.24 19,211.62 58.252 13,768.38 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 499.24 4,491.85 58.237 3,221.15 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 3.52 1,571.44 69.564 687.56 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.78 5,302.30 60.890 3,405.70 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 205.72 41.144 294.28 122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 51,771.16 452,709.17 63.504 260,169.83 122-55030-045-000 Software & Support 8,682.00 6,834.00 6,834.00 122-55045-045-000 Legal 5,000.00 3,391.00 2,505.51- -73.887 5,896.51 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 457.31 11,633.32 56.826 8,838.68 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 2,181.18 6,975.99 46.976 7,874.01 Subtotal: 49,004.00 45,547.00 2,638.49 16,103.80 35.356 29,443.20 122-60005-045-000 Telephone 100.00 100.00 5.73 9.07 9.070 90.93 122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 214.55 1,817.34 42.892 2,419.66 122-60020-045-000 Electricity/Gas 6,568.00 9,268.00 464.09 4,602.69 49.662 4,665.31 122-60025-045-000 Water 1,500.00 1,500.00 100.17 597.68 39.845 902.32 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 100.000 122-60035-045-000 Postage 100.00 100.00 36.09 36.090 63.91 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 8,116.00 67.019 3,994.00 122-60066-045-000 Publications/Books/Subscrips 400.00 400.00 112.75 28.188 287.25 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 8,411.64 55.413 6,768.36 122-60080-045-000 Schools & Training 4,280.00 4,280.00 1,475.00 4,045.00 94.509 235.00 122-60096-045-000 Emergency Management 2,000.00 2,000.00 1,525.41 76.271 474.59 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 664.36 2,476.37 54.105 2,100.63 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 200.00 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 680.25 15.117 3,819.75 122-60180-045-000 Fire Inspection/Enforcement 1,500.00 1,500.00 59.00 249.00 16.600 1,251.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 589.00 1,539.62 76.981 460.38 122-60243-045-000 Prior Year Expense 3,457.00 3,456.54 99.987 .46 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 08:23 06/11/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 359.97 35.997 640.03 Subtotal: 276,531.00 282,488.00 4,581.15 252,314.42 89.319 30,173.58 122-65005-045-000 Fuel & Lube 11,698.00 10,198.00 786.18 5,566.79 54.587 4,631.21 122-65010-045-000 Uniforms 3,360.00 3,360.00 1,182.13 2,784.64 82.876 575.36 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 200.90 2,217.77 29.181 5,382.23 122-65030-045-000 Chemicals 1,000.00 500.00 420.00 420.00 84.000 80.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 103.93 622.31 24.892 1,877.69 122-65085-045-000 Office Supplies 1,000.00 500.00 233.22 46.644 266.78 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 24,758.00 2,693.14 11,844.73 47.842 12,913.27 122-69008-045-000 Short Term Debt-Principal 70,000.00 70,000.00 70,000.00 122-69009-045-000 Short Term Debt-Interest 3,031.00 3,031.00 1,515.50 50.000 1,515.50 122-69050-045-000 Radios 34,200.00 34,200.00 32,693.40 32,693.40 95.595 1,506.60 122-69195-045-000 GASB34/Reserve for Replacement 67,647.00 67,647.00 67,647.00 122-69255-045-000 Airpacks 20,400.00 20,400.00 20,400.00 Subtotal: 195,278.00 195,278.00 32,693.40 34,208.90 17.518 161,069.10 Program number: 1,260,950.00 1,260,950.00 94,377.34 767,181.02 60.842 493,768.98 Department number: Fire 1,260,950.00 1,260,950.00 94,377.34 767,181.02 60.842 493,768.98 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 94,377.34 767,181.02 60.842 493,768.98 Fund number: 122 Trophy Club MUD Fire Dept. 87,731.20 473,596.93- 473,596.93 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2014 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 1417 05/06/2014 Property Taxes/Assessments (307,492.86) (83.45) (307,576.31) GL 1418 05/07/2014 Property Taxes/Assessments (31.89) (307,608.20) GL 1436 05/16/2014 Property Taxes/Assessments (74.56) (307,682.76) GL 1438 05/20/2014 Property Taxes/Assessments (55.71) (307,738.47) GL 1445 05/23/2014 Property Taxes/Assessments (81.92) (307,820.39) GL 1446 05/27/2014 Property Taxes/Assessments (89.57) (307,909.96) GL 1459 05/29/2014 Property Taxes/Assessments (46.28) (307,956.24) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (463.38) (307,956.24) ** (305,445.00) Budgeted 2,511.24 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (1,581.21) .00 (1,581.21) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (1,581.21) ** .00 Budgeted 1,581.21 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1416 05/05/2014 Property Taxes/Assessments (910,185.41) (14.25) (910,199.66) GL 1417 05/06/2014 Property Taxes/Assessments (121.75) (910,321.41) GL 1418 05/07/2014 Property Taxes/Assessments (133.52) (910,454.93) GL 1432 05/08/2014 Property Taxes/Assessments (453.77) (910,908.70) GL 1433 05/09/2014 Property Taxes/Assessments (111.01) (911,019.71) GL 1434 05/12/2014 Property Taxes/Assessments (676.63) (911,696.34) GL 1465 05/13/2014 Property Taxes/Assessments (381.34) (912,077.68) GL 1435 05/14/2014 Property Taxes/Assessments (24.12) (912,101.80) GL 1436 05/16/2014 Property Taxes/Assessments (3.60) (912,105.40) GL 1437 05/19/2014 Property Taxes/Assessments (333.82) (912,439.22) GL 1438 05/20/2014 Property Taxes/Assessments (161.26) (912,600.48) GL 1439 05/21/2014 Property Taxes/Assessments (43.78) (912,644.26) GL 1444 05/22/2014 Property Taxes/Assessments (73.37) (912,717.63) GL 1445 05/23/2014 Property Taxes/Assessments (163.37) (912,881.00) GL 1446 05/27/2014 Property Taxes/Assessments (423.35) (913,304.35) GL 1447 05/28/2014 Property Taxes/Assessments (468.63) (913,772.98) GL 1459 05/29/2014 Property Taxes/Assessments (680.41) (914,453.39) GL 1460 05/30/2014 Property Taxes/Assessments (395.79) (914,849.18) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (4,663.77) (914,849.18) ** (927,555.00) Budgeted (12,705.82) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1434 05/12/2014 Property Taxes/Assessments (1,206.14) (.59) (1,206.73) GL 1460 05/30/2014 Property Taxes/Assessments (137.15) (1,343.88) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (137.74) (1,343.88) ** .00 Budgeted 1,343.88 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1418 05/07/2014 Property Taxes/Assessments (545.40) (3.51) (548.91) GL 1435 05/14/2014 Property Taxes/Assessments 3.70 (545.21) GL 1459 05/29/2014 Property Taxes/Assessments (.72) (545.93) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (.53) (545.93) ** (750.00) Budgeted (204.07) Remaining 73 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1416 05/05/2014 Property Taxes/Assessments (4,320.79) (1.56) (4,322.35) GL 1418 05/07/2014 Property Taxes/Assessments (2.34) (4,324.69) GL 1432 05/08/2014 Property Taxes/Assessments (58.99) (4,383.68) GL 1434 05/12/2014 Property Taxes/Assessments (78.30) (4,461.98) GL 1465 05/13/2014 Property Taxes/Assessments (32.16) (4,494.14) GL 1436 05/16/2014 Property Taxes/Assessments (.43) (4,494.57) GL 1437 05/19/2014 Property Taxes/Assessments (31.55) (4,526.12) GL 1445 05/23/2014 Property Taxes/Assessments (3.19) (4,529.31) GL 1446 05/27/2014 Property Taxes/Assessments (35.02) (4,564.33) GL 1447 05/28/2014 Property Taxes/Assessments (41.30) (4,605.63) GL 1459 05/29/2014 Property Taxes/Assessments (21.25) (4,626.88) GL 1460 05/30/2014 Property Taxes/Assessments (74.63) (4,701.51) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (380.72) (4,701.51) ** (4,500.00) Budgeted 201.51 Remaining 104 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (3,200.00) (400.00) (3,600.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (3,600.00) ** (6,000.00) Budgeted (2,400.00) Remaining 60 % Used Account: 122-43400-000-000 Fire Inspections . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (600.00) (75.00) (675.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (675.00) ** (700.00) Budgeted (25.00) Remaining 96 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (5,000.00) (525.00) (5,525.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (525.00) (5,525.00) ** (6,000.00) Budgeted (475.00) Remaining 92 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,240,777.95) ** (1,260,950.00) Budgeted (20,172.05) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 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 1321 05/09/2014 FD Payroll 5/9/14 256,559.08 17,612.70 274,171.78 GL 1392 05/23/2014 Fire Dept P/R 5/23/14 17,210.02 291,381.80 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 34,822.72 291,381.80 ** 455,916.00 Budgeted 164,534.20 Remaining 64 % Used Account: 122-50010-045-000 Overtime 1321 05/09/2014 FD Payroll 5/9/14 20,460.13 2,660.98 23,121.11 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,660.98 23,121.11 ** 44,225.00 Budgeted 21,103.89 Remaining 52 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,289.86 .00 13,289.86 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,289.86 ** 13,529.00 Budgeted 239.14 Remaining 98 % Used Account: 122-50016-045-000 Longevity 4,655.00 .00 4,655.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,655.00 ** 4,768.00 Budgeted 113.00 Remaining 98 % Used Account: 122-50017-045-000 Certification 1321 05/09/2014 FD Payroll 5/9/14 2,589.39 375.00 2,964.39 GL _______________ Account: 122-50017-045-000 Certification Totals: 375.00 2,964.39 ** 4,350.00 Budgeted 1,385.61 Remaining 68 % Used Account: 122-50020-045-000 Retirement 1321 05/09/2014 FD Payroll 5/9/14 42,044.99 3,020.34 45,065.33 GL 1392 05/23/2014 Fire Dept P/R 5/23/14 2,525.97 47,591.30 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,546.31 47,591.30 ** 70,991.00 Budgeted 23,399.70 Remaining 67 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1321 05/09/2014 FD Payroll 5/9/14 28,825.68 2,488.45 31,314.13 GL 1392 05/23/2014 Fire Dept P/R 5/23/14 1,827.98 33,142.11 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,316.43 33,142.11 ** 56,968.00 Budgeted 23,825.89 Remaining 58 % Used Account: 122-50027-045-000 Dental Insurance 1321 05/09/2014 FD Payroll 5/9/14 2,350.48 176.39 2,526.87 GL 1392 05/23/2014 Fire Dept P/R 5/23/14 176.43 2,703.30 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 352.82 2,703.30 ** 4,230.00 Budgeted 1,526.70 Remaining 64 % Used Account: 122-50028-045-000 Vision Insurance 1321 05/09/2014 FD Payroll 5/9/14 485.28 34.73 520.01 GL 1392 05/23/2014 Fire Dept P/R 5/23/14 34.81 554.82 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 69.54 554.82 ** 892.00 Budgeted 337.18 Remaining 62 % Used Account: 122-50029-045-000 Life Insurance & Other 1321 05/09/2014 FD Payroll 5/9/14 2,195.97 163.24 2,359.21 GL 1392 05/23/2014 Fire Dept P/R 5/23/14 163.34 2,522.55 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 326.58 2,522.55 ** 4,250.00 Budgeted 1,727.45 Remaining 59 % Used Account: 122-50030-045-000 Social Security Taxes 1321 05/09/2014 FD Payroll 5/9/14 17,076.38 1,174.17 18,250.55 GL 1392 05/23/2014 Fire Dept P/R 5/23/14 961.07 19,211.62 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,135.24 19,211.62 ** 32,980.00 Budgeted 13,768.38 Remaining 58 % Used Account: 122-50035-045-000 Medicare Taxes 1321 05/09/2014 FD Payroll 5/9/14 3,992.61 274.51 4,267.12 GL 1392 05/23/2014 Fire Dept P/R 5/23/14 224.73 4,491.85 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 499.24 4,491.85 ** 7,713.00 Budgeted 3,221.15 Remaining 58 % Used Account: 122-50040-045-000 Unemployment Taxes 1321 05/09/2014 FD Payroll 5/9/14 1,567.92 2.65 1,570.57 GL 1392 05/23/2014 Fire Dept P/R 5/23/14 .87 1,571.44 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 3.52 1,571.44 ** 2,259.00 Budgeted 687.56 Remaining 70 % Used Account: 122-50045-045-000 Workman's Compensation 123 05/01/2014 FD May W/C expense 4,639.52 662.78 5,302.30 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.78 5,302.30 ** 8,708.00 Budgeted 3,405.70 Remaining 61 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 205.72 .00 205.72 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 205.72 ** 500.00 Budgeted 294.28 Remaining 41 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support .00 .00 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 .00 ** 6,834.00 Budgeted 6,834.00 Remaining 0 % Used Account: 122-55045-045-000 Legal (2,505.51) .00 (2,505.51) . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-55045-045-000 Legal Totals: .00 (2,505.51) ** 3,391.00 Budgeted 5,896.51 Remaining -74 % Used Account: 122-55080-045-000 Maintenance & Repairs 1367 05/16/2014 Firefighters Cable/May 11,176.01 (133.82) 11,042.19 GL 1480 05/27/2014 May A/P ATT*BILL PAYMENT 157.97 11,200.16 ATT*BILL PAYMENT PC 1480 05/27/2014 May A/P ATT*BILL PAYMENT 128.82 11,328.98 ATT*BILL PAYMENT PC 1480 05/27/2014 May A/P THE HOME DEPOT 6581 16.20 11,345.18 THE HOME DEPOT 6581 PC 1480 05/27/2014 May A/P SAMSCLUB #4795 33.92 11,379.10 SAMSCLUB #4795 PC 1480 05/27/2014 May A/P 1000BULBS.COM 66.03 11,445.13 1000BULBS.COM PC 1480 05/27/2014 May A/P WILDFIRE TRUCK & EQUIP 43.00 11,488.13 WILDFIRE TRUCK & EQUIP PC 1480 05/27/2014 May A/P WM SUPERCENTER #5247 41.75 11,529.88 WM SUPERCENTER #5247 PC 1480 05/27/2014 May A/P THE HOME DEPOT 6581 9.97 11,539.85 THE HOME DEPOT 6581 PC 1480 05/27/2014 May A/P TRACTOR SUPPLY COMPANY 68.96 11,608.81 TRACTOR SUPPLY COMPANY PC 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (24.51) 11,584.30 AR 1484 05/31/2014 May A/P Rug Service 24.51 11,608.81 G & K SERVICES 33839 AP 1484 05/31/2014 May A/P Rug Service 24.51 11,633.32 G & K SERVICES 33839 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 457.31 11,633.32 ** 20,472.00 Budgeted 8,838.68 Remaining 57 % Used Account: 122-55090-045-000 Vehicle Maintenance 1362 05/16/2014 May A/P Vehicle Maint 2007 Pier Arrow/ 4,794.81 2,101.68 6,896.49 SIDDONS-MARTIN EMERGENCY GROUP 33799 AP 1480 05/27/2014 May A/P KWIK KAR LUBE & TUNE O 14.50 6,910.99 KWIK KAR LUBE & TUNE O PC 1484 05/31/2014 May A/P Tire repair 65.00 6,975.99 BLAGG TIRE & SERVICE 33824 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 2,181.18 6,975.99 ** 14,850.00 Budgeted 7,874.01 Remaining 47 % Used Account: 122-60005-045-000 Telephone 1380 05/20/2014 May A/P IT BOA 3/28-4/27/14 3.34 5.73 9.07 TOWN OF TROPHY CLUB 33802 AP _______________ Account: 122-60005-045-000 Telephone Totals: 5.73 9.07 ** 100.00 Budgeted 90.93 Remaining 9 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1321 05/09/2014 FD Payroll 5/9/14 1,602.79 75.00 1,677.79 GL 1406 05/23/2014 May A/P Verizon, Kyocera 139.55 1,817.34 TOWN OF TROPHY CLUB 33817 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 214.55 1,817.34 ** 4,237.00 Budgeted 2,419.66 Remaining 43 % Used Account: 122-60020-045-000 Electricity/Gas 1405 05/23/2014 May A/P Gas/Fire Station 4/18-5/16/14 4,138.60 61.48 4,200.08 ATMOS ENERGY 33809 AP 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (464.09) 3,735.99 AR 1484 05/31/2014 May A/P FD Electric 4/11-5/13/14 866.70 4,602.69 HUDSON ENERGY SERVICES, LLC 33847 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 464.09 4,602.69 ** 9,268.00 Budgeted 4,665.31 Remaining 50 % Used Account: 122-60025-045-000 Water 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: 497.51 (100.14) 397.37 AR 1484 05/31/2014 May A/P May Water 200.31 597.68 TROPHY CLUB MUD (WATER BILLS) 33877 AP _______________ Account: 122-60025-045-000 Water Totals: 100.17 597.68 ** 1,500.00 Budgeted 902.32 Remaining 40 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,279.00 .00 214,279.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,279.00 ** 214,279.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 36.09 .00 36.09 _______________ Account: 122-60035-045-000 Postage Totals: .00 36.09 ** 100.00 Budgeted 63.91 Remaining 36 % Used Account: 122-60055-045-000 Insurance 54 05/01/2014 May Ins & W/C Expense 7,106.75 1,009.25 8,116.00 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 8,116.00 ** 12,110.00 Budgeted 3,994.00 Remaining 67 % Used Account: 122-60066-045-000 Publications/Books/Subscrips . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 112.75 .00 112.75 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 112.75 ** 400.00 Budgeted 287.25 Remaining 28 % Used Account: 122-60070-045-000 Dues & Memberships 8,411.64 .00 8,411.64 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 8,411.64 ** 15,180.00 Budgeted 6,768.36 Remaining 55 % Used Account: 122-60080-045-000 Schools & Training 1362 05/16/2014 May A/P Cert/Sampson 2,570.00 85.00 2,655.00 TX COMM ON FIRE PROTECTION 33804 AP 1380 05/20/2014 May A/P Steve Rusk Level II Instructor 85.00 2,740.00 TX COMM ON FIRE PROTECTION 33804 AP 1480 05/27/2014 May A/P PAYPAL *TRAININGDIV 700.00 3,440.00 PAYPAL *TRAININGDIV PC 1480 05/27/2014 May A/P SAFE KIDS WORLDWIDE 50.00 3,490.00 SAFE KIDS WORLDWIDE PC 1484 05/31/2014 May A/P TCC live fire training 555.00 4,045.00 NORTH EAST FIRE DEPT ASSOC 33863 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 1,475.00 4,045.00 ** 4,280.00 Budgeted 235.00 Remaining 95 % Used Account: 122-60096-045-000 Emergency Management 1,525.41 .00 1,525.41 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,525.41 ** 2,000.00 Budgeted 474.59 Remaining 76 % Used Account: 122-60100-045-000 Travel & per diem 1480 05/27/2014 May A/P HISTORIC CROCKETT HOTE 1,812.01 600.32 2,412.33 HISTORIC CROCKETT HOTE PC 1480 05/27/2014 May A/P COUNTY LINE RIVERWALK 25.49 2,437.82 COUNTY LINE RIVERWALK PC 1480 05/27/2014 May A/P MICHELINOS OLE LONESTA 11.56 2,449.38 MICHELINOS OLE LONESTA PC 1480 05/27/2014 May A/P LNDRY'S-SA DTWN 26.99 2,476.37 LNDRY'S-SA DTWN PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 664.36 2,476.37 ** 4,577.00 Budgeted 2,100.63 Remaining 54 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 680.25 .00 680.25 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 680.25 ** 4,500.00 Budgeted 3,819.75 Remaining 15 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 1480 05/27/2014 May A/P CARBONLESS FORMS PRINT 190.00 10.00 200.00 CARBONLESS FORMS PRINT PC 1480 05/27/2014 May A/P CARBONLESS FORMS PRINT 49.00 249.00 CARBONLESS FORMS PRINT PC _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 59.00 249.00 ** 1,500.00 Budgeted 1,251.00 Remaining 17 % Used Account: 122-60195-045-000 Flags & Repair 1484 05/31/2014 May A/P Flags and repair 950.62 589.00 1,539.62 TOWN OF TROPHY CLUB 33876 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 589.00 1,539.62 ** 2,000.00 Budgeted 460.38 Remaining 77 % Used Account: 122-60243-045-000 Prior Year Expense 3,456.54 .00 3,456.54 _______________ Account: 122-60243-045-000 Prior Year Expense Totals: .00 3,456.54 ** 3,457.00 Budgeted .46 Remaining 100 % Used Account: 122-60245-045-000 Miscellaneous Expense 359.97 .00 359.97 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 359.97 ** 1,000.00 Budgeted 640.03 Remaining 36 % Used Account: 122-65005-045-000 Fuel & Lube 1480 05/27/2014 May A/P RACEWAY6811 22168116 4,780.61 62.00 4,842.61 RACEWAY6811 22168116 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1470 05/31/2014 May Gaslog 4,780.61 724.18 5,566.79 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 786.18 5,566.79 ** 10,198.00 Budgeted 4,631.21 Remaining 55 % Used Account: 122-65010-045-000 Uniforms 1362 05/16/2014 May A/P Uniform Shirt 1,602.51 95.42 1,697.93 MUNICIPAL EMERGENCY SERVICES 33792 AP 1405 05/23/2014 May A/P Uniforms 620.00 2,317.93 PANDA EMBROIDERY 33815 AP 1405 05/23/2014 May A/P Uniforms 505.00 2,822.93 PANDA EMBROIDERY 33815 AP 1405 05/23/2014 May A/P Uniforms 35.00 2,857.93 PANDA EMBROIDERY 33815 AP 1405 05/23/2014 May A/P Shirts 652.93 3,510.86 Alainavision, Inc 33808 AP 1405 05/23/2014 May A/P Shorts 455.89 3,966.75 Alainavision, Inc 33808 AP 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (1,182.11) 2,784.64 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 1,182.13 2,784.64 ** 3,360.00 Budgeted 575.36 Remaining 83 % Used Account: 122-65015-045-000 Protective Clothing 1480 05/27/2014 May A/P REDBACK, USA 2,016.87 200.90 2,217.77 REDBACK, USA PC _______________ Account: 122-65015-045-000 Protective Clothing Totals: 200.90 2,217.77 ** 7,600.00 Budgeted 5,382.23 Remaining 29 % Used Account: 122-65030-045-000 Chemicals 1380 05/20/2014 May A/P Foam for E681 and B681 420.00 420.00 CASCO INDUSTRIES INC 33779 AP _______________ Account: 122-65030-045-000 Chemicals Totals: 420.00 420.00 ** 500.00 Budgeted 80.00 Remaining 84 % Used Account: 122-65035-045-000 Small Tools 1480 05/27/2014 May A/P CHIEF SUPPLY 518.38 103.93 622.31 CHIEF SUPPLY PC _______________ Account: 122-65035-045-000 Small Tools Totals: 103.93 622.31 ** 2,500.00 Budgeted 1,877.69 Remaining 25 % Used Account: 122-65085-045-000 Office Supplies 233.22 .00 233.22 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 233.22 ** 500.00 Budgeted 266.78 Remaining 47 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt-Interest 1,515.50 .00 1,515.50 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 1,515.50 ** 3,031.00 Budgeted 1,515.50 Remaining 50 % Used Account: 122-69050-045-000 Radios 1484 05/31/2014 May A/P Fire Dept Radios 32,693.40 32,693.40 TOWN OF TROPHY CLUB 33876 AP _______________ Account: 122-69050-045-000 Radios Totals: 32,693.40 32,693.40 ** 34,200.00 Budgeted 1,506.60 Remaining 96 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 67,647.00 Budgeted 67,647.00 Remaining 0 % Used Account: 122-69255-045-000 Airpacks .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 20,400.00 Budgeted 20,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 767,181.02 ** 1,260,950.00 Budgeted 493,768.98 Remaining 61 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (473,596.93) .00 Budgeted 473,596.93 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MAY 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 5/31/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 221,600 - - 221,600 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,503,080 - - 1,503,080 INVESTMENTS-TEXPOOL 857,674 193,050 279,460 1,330,184 PREPAID EXPENSES 39,714 - - 39,714 ADVALOREM PROPERTY TAXES RECEIVABLE 2,994 - - 2,994 UTILITY AND OTHER ACCOUNTS RECEIVABLE 618,455 - - 618,455 - TOTAL ASSETS 3,244,117 193,050 279,460 3,716,627 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,994 - - 2,994 ACCOUNTS AND OTHER PAYABLES 453,886 - - 453,886 CUSTOMER DEPOSITS 255,942 - - 255,942 - TOTAL LIABILITIES 712,822 - - 712,822 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 193,050 193,050 NON-SPENDABLE FUND BALANCE 29,524 29,524 ASSIGNED FUND BALANCE 276,500 245,100 521,600 UNASSIGNED FUND BALANCE 2,682,452 - - 2,682,452 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (457,181) - 34,360 (422,821) - TOTAL FUND BALANCE 2,531,295 193,050 279,460 3,003,805 - TOTAL LIABILITIES AND FUND BALANCE 3,244,117 193,050 279,460 3,716,627 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,250.00- 99,250.00- 499.01- 97,935.68- 98.676 1,314.32- 135-40002-000-000 Property Taxes/Delinquent 13.10- 129.55- 129.55 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 40.30- 493.55- 54.839 406.45- Subtotal: 100,150.00- 100,150.00- 552.41- 98,558.78- 98.411 1,591.22- 135-43215-000-000 Insurance Settlement 82.36- 82.36 Subtotal: 82.36- 82.36 135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 300,063.29- 1,694,225.89- 45.188 2,055,084.11- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 182,853.97- 1,200,147.20- 70.253 508,173.80- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 3,834.68- 31,778.82- 49.253 32,743.18- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 828.00- 5,874.00- 64.727 3,201.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 2,000.00- 100.00- 1,850.00- 92.500 150.00- 135-47045-000-000 Sewer Inspections 4,400.00- 5,000.00- 300.00- 5,850.00- 117.000 850.00 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 9,531.90- 27,166.68- 34.135 52,419.32- Subtotal: 5,616,414.00- 5,617,814.00- 497,511.84- 2,966,892.59- 52.812 2,650,921.41- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 18,400.00- 234,600.00- 40.302 347,509.00- Subtotal: 582,109.00- 582,109.00- 18,400.00- 234,600.00- 40.302 347,509.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 483.61- 4,029.71- 83.952 770.29- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 7,284.24- 71.667 2,879.76- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 4,666.64- 66.666 2,333.36- 135-49030-000-000 Vending Revenue 350.00- 350.00- 146.00- 41.714 204.00- 135-49035-000-000 Prior Year Reserves 880,000.00- 880,000.00- 135-49036-000-000 GASB Reserves 8,964.00- 8,964.00- 8,964.00- 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 3,430.00- 59,886.80- 71.294 24,113.20- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- 1,158.08- 38.603 1,841.92- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 100.00- 135-49903-000-000 Recovery of Prior Year Expense 4,087.00- 4,087.00- 100.000 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 1,003,351.00- 5,407.47- 81,258.47- 8.099 922,092.53- Program number: 6,417,937.00- 7,303,424.00- 521,871.72- 3,381,392.20- 46.299 3,922,031.80- Department number: Revenues 6,417,937.00- 7,303,424.00- 521,871.72- 3,381,392.20- 46.299 3,922,031.80- Revenues Subtotal ----------- 6,417,937.00- 7,303,424.00- 521,871.72- 3,381,392.20- 46.299 3,922,031.80- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 287,709.00 287,709.00 22,134.61 173,077.95 60.157 114,631.05 135-50010-010-000 Overtime 13,391.00 16,391.00 1,295.00 13,108.22 79.972 3,282.78 135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 375.00 2,775.00 54.412 2,325.00 135-50020-010-000 Retirement 27,847.00 27,847.00 2,137.66 17,853.15 64.112 9,993.85 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 3,559.98 26,260.53 54.331 22,073.47 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 249.12 1,926.09 48.985 2,005.91 135-50028-010-000 Vision Insurance 873.00 873.00 63.03 470.02 53.840 402.98 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 205.10 1,675.26 50.673 1,630.74 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,467.19 12,349.96 64.026 6,939.04 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 343.13 2,888.30 64.028 1,622.70 135-50040-010-000 Unemployment Taxes 54.00 1,244.00 1,244.44 100.035 .44- 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 6,419.60 65.313 3,409.40 135-50060-010-000 Pre-emp Physicals/Testing 200.00 350.00 233.90 66.829 116.10 135-50070-010-000 Employee Relations 300.00 300.00 161.78 53.927 138.22 Subtotal: 429,580.00 433,920.00 32,632.27 265,349.20 61.152 168,570.80 135-55005-010-000 Engineering 3,000.00 6,000.00 6,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 61,000.00 11,339.00 45,963.28 75.350 15,036.72 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 2,479.60 49.592 2,520.40 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 2,500.00 248.33 9.933 2,251.67 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 220.00 2,913.91 52.980 2,586.09 Subtotal: 67,000.00 80,000.00 11,559.00 51,605.12 64.506 28,394.88 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 383.52 2,681.45 54.579 2,231.55 135-60020-010-000 Electricity 162,160.00 155,160.00 13,187.32 69,811.73 44.993 85,348.27 135-60066-010-000 Publications/Books/Subscripts 500.00 2,538.00 2,538.00 135-60070-010-000 Dues & Memberships 150.00 300.00 289.00 96.333 11.00 135-60080-010-000 Schools & Training 4,184.00 1,500.00 269.00 1,334.00 88.933 166.00 135-60090-010-000 Safety Program 400.00 135-60100-010-000 Travel & per diem 1,450.00 279.00 1.50 172.63 61.875 106.37 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 60.00 12.000 440.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 267.80 32,463.59 68.489 14,936.41 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 168,637.52 951,112.79 40.672 1,387,360.21 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 1,289.55 36.844 2,210.45 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 2,000.00 1,664.20 83.210 335.80 Subtotal: 2,567,580.00 2,557,013.00 182,746.66 1,060,878.94 41.489 1,496,134.06 135-65005-010-000 Fuel & Lube 23,181.00 22,181.00 1,305.04 8,444.30 38.070 13,736.70 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,270.00 2,500.00 1,938.58 77.543 561.42 135-65030-010-000 Chemicals 5,000.00 5,000.00 305.05 3,977.27 79.545 1,022.73 135-65035-010-000 Small Tools 1,200.00 1,200.00 25.98 490.92 40.910 709.08 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 21.88 344.55 34.455 655.45 135-65050-010-000 Meter Expense 143,550.00 143,550.00 1,860.00 66,341.04 46.215 77,208.96 Subtotal: 177,201.00 175,431.00 3,517.95 81,536.66 46.478 93,894.34 135-69005-010-000 Capital Outlays 37,000.00 35,681.00 35,679.59 99.996 1.41 135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 122,980.00 25.099 367,000.00 135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 11,621.26 60.314 7,646.74 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 135-69280-010-000 Capital Repairs 7,500.00 135-69281-010-000 Water Tank Inspection Contract 106,847.00 100,847.00 100,816.54 99.970 30.46 Subtotal: 690,595.00 645,776.00 271,097.39 41.980 374,678.61 Program number: 3,931,956.00 3,892,140.00 230,455.88 1,730,467.31 44.461 2,161,672.69 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 1,000.00 2,000.00 1,680.00 2,644.61 132.231 644.61- Subtotal: 1,000.00 2,000.00 1,680.00 2,644.61 132.231 644.61- 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 2,496.19 49.924 2,503.81 Subtotal: 5,000.00 2,496.19 49.924 2,503.81 Program number: 1 Lab Analysis for PID 1,000.00 7,000.00 1,680.00 5,140.80 73.440 1,859.20 Department number: Water 3,932,956.00 3,899,140.00 232,135.88 1,735,608.11 44.513 2,163,531.89 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 202,894.00 202,894.00 15,571.02 125,041.37 61.629 77,852.63 135-50010-020-000 Overtime 11,965.00 11,965.00 1,279.03 9,813.39 82.017 2,151.61 135-50016-020-000 Longevity 2,998.00 2,998.00 2,997.50 99.983 .50 135-50017-020-000 Certification 4,800.00 4,800.00 400.00 3,200.00 66.667 1,600.00 135-50020-020-000 Retirement 19,905.00 19,905.00 1,549.05 13,134.85 65.988 6,770.15 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,426.76 26,961.32 62.021 16,509.68 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 211.38 1,736.28 58.089 1,252.72 135-50028-020-000 Vision Insurance 658.00 658.00 51.26 406.09 61.716 251.91 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 230.79 1,452.84 63.085 850.16 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 923.17 8,008.68 58.013 5,796.32 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 215.92 1,873.00 58.006 1,356.00 135-50040-020-000 Unemployment Taxes 36.00 828.00 828.00 100.000 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 4,280.64 65.333 2,271.36 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 63.00 42.000 87.00 135-50070-020-000 Employee Relations 350.00 350.00 59.99 17.140 290.01 Subtotal: 316,105.00 316,897.00 24,393.46 199,856.95 63.067 117,040.05 135-55070-020-000 Independent Labor 880,000.00 71,318.20 606,301.95 68.898 273,698.05 135-55080-020-000 Maintenance & Repairs 35,000.00 36,120.00 3,172.44 27,846.73 77.095 8,273.27 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 1,652.49 82.625 347.51 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 135-55125-020-000 Dumpster Services 52,000.00 47,000.00 1,752.78 34,712.35 73.856 12,287.65 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,266.00 18,805.26 62.684 11,194.74 Subtotal: 119,500.00 995,120.00 77,509.42 689,318.78 69.270 305,801.22 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 389.32 1,925.62 57.844 1,403.38 135-60020-020-000 Electricity 148,227.00 138,227.00 9,938.56 67,995.02 49.191 70,231.98 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 351.00 87.750 49.00 135-60080-020-000 Schools & Training 2,636.00 1,636.00 1,087.00 66.443 549.00 135-60090-020-000 Safety Program 250.00 500.00 42.00 474.07 94.814 25.93 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 792.30 1,085.11 103.344 35.11- 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 52.006 8,231.00 135-60243-020-000 Prior Year Expense 3,554.00 3,554.22 100.006 .22- 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 250.00 250.00 135-60360-020-000 Furniture/Equipment < $5000 3,000.00 1,079.00 1,079.10 100.009 .10- Subtotal: 178,242.00 168,875.00 11,162.18 86,769.67 51.381 82,105.33 135-65005-020-000 Fuel & Lube 14,720.00 13,600.00 853.95 7,188.30 52.855 6,411.70 135-65010-020-000 Uniforms 1,752.00 1,752.00 1,437.27 82.036 314.73 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-020-000 Chemicals 39,000.00 31,000.00 17,572.10 56.684 13,427.90 135-65035-020-000 Small Tools 1,000.00 300.00 86.09 177.09 59.030 122.91 135-65040-020-000 Safety Equipment 250.00 500.00 230.63 46.126 269.37 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 2,587.62 9,519.75 63.465 5,480.25 Subtotal: 71,722.00 62,152.00 3,527.66 36,125.14 58.124 26,026.86 135-69005-020-000 Capital Outlays 31,000.00 135-69008-020-000 Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 100.000 135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 1,043.70 73.397 378.30 135-69280-020-000 Capital Repairs 30,000.00 Subtotal: 82,442.00 21,442.00 21,063.70 98.236 378.30 Program number: 768,011.00 1,564,486.00 116,592.72 1,033,134.24 66.037 531,351.76 Department number: Wastewater 768,011.00 1,564,486.00 116,592.72 1,033,134.24 66.037 531,351.76 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 90,299.00 90,299.00 6,869.28 46,914.21 51.954 43,384.79 135-50010-021-000 Overtime 10,028.00 10,028.00 600.70 3,173.82 31.650 6,854.18 135-50016-021-000 Longevity 17,913.00 2,108.00 2,107.50 99.976 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 1,200.00 66.667 600.00 135-50020-021-000 Retirement 9,025.00 9,025.00 684.27 5,149.92 57.063 3,875.08 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,473.70 12,621.29 53.326 11,046.71 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 102.60 915.39 53.752 787.61 135-50028-021-000 Vision Insurance 314.00 314.00 23.68 194.25 61.863 119.75 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 73.96 684.99 64.258 381.01 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 438.50 3,224.08 43.323 4,217.92 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 102.56 754.02 43.310 986.98 135-50040-021-000 Unemployment Taxes 198.00 414.00 41.32 414.00 100.000 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 2,140.32 65.333 1,135.68 135-50070-021-000 Employee Relations 200.00 200.00 132.02 66.010 67.98 Subtotal: 168,673.00 153,084.00 10,828.11 79,625.81 52.014 73,458.19 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 23,801.00 14,451.00 1,315.98 7,016.24 48.552 7,434.76 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 999.18 49.959 1,000.82 Subtotal: 27,301.00 16,451.00 1,315.98 8,015.42 48.723 8,435.58 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 102.72 891.80 66.902 441.20 135-60020-021-000 Electricity 21,178.00 21,178.00 1,721.56 13,668.60 64.542 7,509.40 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 135-60080-021-000 Schools & Training 1,711.00 911.00 911.00 135-60090-021-000 Safety Program 300.00 300.00 35.34 11.780 264.66 135-60100-021-000 Travel & per diem 550.00 250.00 38.49 15.396 211.51 135-60105-021-000 Rent/Lease Equipment 10,000.00 5,000.00 5,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 29,322.00 1,824.28 14,634.23 49.909 14,687.77 135-65005-021-000 Fuel & Lube 22,397.00 21,747.00 975.97 8,007.00 36.819 13,740.00 135-65010-021-000 Uniforms 1,040.00 1,040.00 814.23 78.291 225.77 135-65030-021-000 Chemicals 6,000.00 2,000.00 300.89 300.89 15.045 1,699.11 135-65035-021-000 Small Tools 1,000.00 300.00 43.99 14.663 256.01 135-65040-021-000 Safety Equipment 500.00 750.00 586.73 78.231 163.27 Subtotal: 30,937.00 25,837.00 1,276.86 9,752.84 37.748 16,084.16 135-69005-021-000 Capital Outlays 100,000.00 114,000.00 68,300.20 59.912 45,699.80 135-69008-021-000 Short Term Debt-Principal 35,991.00 35,991.00 35,991.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69009-021-000 Short Term Debt-Interest 2,846.00 2,846.00 2,846.00 135-69280-021-000 Capital Repairs 71,000.00 Subtotal: 209,837.00 152,837.00 68,300.20 44.688 84,536.80 Program number: 472,170.00 377,531.00 15,245.23 180,328.50 47.765 197,202.50 Department number: Collection 472,170.00 377,531.00 15,245.23 180,328.50 47.765 197,202.50 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2014 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 500.00 6,100.00 61.000 3,900.00 135-50030-026-000 Social Security Taxes 620.00 620.00 31.00 378.20 61.000 241.80 135-50035-026-000 Medicare Taxes 145.00 145.00 7.25 88.45 61.000 56.55 135-50040-026-000 Unemployment Taxes 10.00 230.00 11.50 85.30 37.087 144.70 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 23.59 65.528 12.41 Subtotal: 10,811.00 11,031.00 552.69 6,675.54 60.516 4,355.46 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 1,200.00 35.95 2.996 1,164.05 135-60080-026-000 Schools & Training 4,000.00 4,000.00 367.00 632.00 15.800 3,368.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 41.66 .833 4,958.34 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 179.40 179.40 17.940 820.60 Subtotal: 11,850.00 11,850.00 546.40 924.01 7.798 10,925.99 Program number: 22,661.00 22,881.00 1,099.09 7,599.55 33.213 15,281.45 Department number: Board of Directors 22,661.00 22,881.00 1,099.09 7,599.55 33.213 15,281.45 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 458,721.00 458,721.00 35,093.26 283,710.46 61.848 175,010.54 135-50010-030-000 Overtime 500.00 750.00 88.69 676.71 90.228 73.29 135-50016-030-000 Longevity 3,018.00 3,018.00 3,077.50 101.972 59.50- 135-50020-030-000 Retirement 41,419.00 41,419.00 3,159.32 26,787.05 64.673 14,631.95 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,804.81 37,355.28 64.491 20,567.72 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 246.33 2,767.03 54.255 2,332.97 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 81.62 655.69 60.321 431.31 135-50029-030-000 Life Insurance & Other 4,483.00 5,500.00 362.43 3,249.50 59.082 2,250.50 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 2,047.56 17,496.71 61.051 11,162.29 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 478.87 4,091.98 61.056 2,610.02 135-50040-030-000 Unemployment Taxes 63.00 1,449.00 1,449.00 100.000 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.62 1,029.03 65.335 545.97 135-50060-030-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 45.00 2,713.93 54.279 2,286.07 Subtotal: 614,450.00 617,103.00 46,536.51 385,059.87 62.398 232,043.13 135-55030-030-000 Software & Support 59,698.00 59,698.00 13,376.51 37,500.32 62.817 22,197.68 135-55070-030-000 Independent Labor 7,700.00 7,000.00 1,352.50 7,147.98 102.114 147.98- 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 428.45 9.521 4,071.55 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 188.84 2,308.11 35.509 4,191.89 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 1,594.97 11,164.79 58.332 7,975.21 135-55160-030-000 Professional Outside Services 15,000.00 10,000.00 10,000.00 135-55161-030-000 Town Personnel Contract 77,048.00 77,048.00 77,048.00 100.000 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 6,808.00 6,808.00 928.02 5,825.41 85.567 982.59 Subtotal: 196,594.00 190,894.00 17,440.84 141,423.06 74.085 49,470.94 135-60005-030-000 Telephone 11,250.00 11,250.00 1,139.95 7,646.45 67.968 3,603.55 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 4,057.00 251.85 2,186.11 53.885 1,870.89 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 2,550.37 8,869.55 58.464 6,301.45 135-60025-030-000 Water 1,500.00 1,500.00 91.06 619.08 41.272 880.92 135-60035-030-000 Postage 28,500.00 28,500.00 1,703.32 17,150.05 60.176 11,349.95 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 2,958.25 20,217.52 71.364 8,112.48 135-60050-030-000 Bad Debt Expense 1,500.00 6,200.00 4,153.40 66.990 2,046.60 135-60055-030-000 Insurance 53,561.00 53,561.00 4,269.73 34,286.09 64.013 19,274.91 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 401.08 40.108 598.92 135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 4,011.95 89.154 488.05 135-60075-030-000 Meetings 400.00 400.00 27.26 27.26 6.815 372.74 135-60079-030-000 Public Education 5,000.00 274.83 5.497 4,725.17 135-60080-030-000 Schools & Training 7,500.00 6,800.00 256.95 2,849.25 41.901 3,950.75 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 44.60 1,483.36 29.667 3,516.64 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 2,500.00 2,500.00 1,567.63 1,849.39 73.976 650.61 135-60125-030-000 Advertising 2,500.00 2,500.00 589.43 23.577 1,910.57 135-60235-030-000 Security 1,350.00 1,350.00 123.56 9.153 1,226.44 135-60245-030-000 Miscellaneous Expenses 22,870.00 17,870.00 376.25 2.105 17,493.75 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,563.55 2,563.55 102.542 63.55- Subtotal: 204,221.00 208,689.00 17,424.52 109,678.16 52.556 99,010.84 135-65010-030-000 Uniforms 1,390.00 1,390.00 998.90 71.863 391.10 135-65055-030-000 Hardware 13,562.00 13,562.00 10.98 2,189.02 16.141 11,372.98 135-65085-030-000 Office Supplies 9,100.00 9,100.00 323.21 3,096.30 34.025 6,003.70 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 2,403.47 41.931 3,328.53 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 218.99 1,837.36 73.494 662.64 135-65097-030-000 Vending Machine Supplies 200.00 200.00 76.96 38.480 123.04 135-65105-030-000 Printing 4,000.00 4,000.00 2,348.27 58.707 1,651.73 Subtotal: 36,484.00 36,484.00 553.18 12,950.28 35.496 23,533.72 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 128.43 1,541.11 44.670 1,908.89 Subtotal: 3,450.00 3,450.00 128.43 1,541.11 44.670 1,908.89 Program number: 1,055,199.00 1,056,620.00 82,083.48 650,652.48 61.579 405,967.52 Department number: Administration 1,055,199.00 1,056,620.00 82,083.48 650,652.48 61.579 405,967.52 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 08:23 06/11/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 131,300.00 347,126.00 62,916.66 201,355.05 58.006 145,770.95 135-55055-039-000 Auditing 21,840.00 21,840.00 21,200.00 97.070 640.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 6,243.84 62.438 3,756.16 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,451.40 64.511 1,348.60 Subtotal: 166,940.00 382,766.00 62,916.66 231,250.29 60.416 151,515.71 Program number: 166,940.00 382,766.00 62,916.66 231,250.29 60.416 151,515.71 Department number: Non Departmental 166,940.00 382,766.00 62,916.66 231,250.29 60.416 151,515.71 Expenditures Subtotal ----------- 6,417,937.00 7,303,424.00 510,073.06 3,838,573.17 52.559 3,464,850.83 Fund number: 135 MUD 1 General Fund 11,798.66- 457,180.97 457,180.97- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 08:23 06/11/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 5.85- 61.26- 61.26 507-49036-000-000 GASB Reserves 120,000.00- 120,000.00 Subtotal: 5.85- 120,061.26- 120,061.26 Program number: 5.85- 120,061.26- 120,061.26 Department number: 5.85- 120,061.26- 120,061.26 Revenues Subtotal ----------- 5.85- 120,061.26- 120,061.26 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 08:23 06/11/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 82,629.40- Subtotal: 82,629.40 82,629.40- Program number: 2 Rate of Flow Control-FW Meter 82,629.40 82,629.40- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 08:23 06/11/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 5/2014 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 282,245.17 3,072.00 1.088 279,173.17 Subtotal: 282,245.17 3,072.00 1.088 279,173.17 Program number: 3 Indian Creek Waterline 282,245.17 3,072.00 1.088 279,173.17 Department number: Water 282,245.17 85,701.40 30.364 196,543.77 Expenditures Subtotal ----------- 282,245.17 85,701.40 30.364 196,543.77 Fund number: 507 MUD 1 Capital Projects 282,245.17 5.85- 34,359.86- -12.174 316,605.03 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2014 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 1416 05/05/2014 Property Taxes/Assessments (97,436.67) (1.52) (97,438.19) GL 1417 05/06/2014 Property Taxes/Assessments (13.03) (97,451.22) GL 1418 05/07/2014 Property Taxes/Assessments (14.29) (97,465.51) GL 1432 05/08/2014 Property Taxes/Assessments (48.55) (97,514.06) GL 1433 05/09/2014 Property Taxes/Assessments (11.88) (97,525.94) GL 1434 05/12/2014 Property Taxes/Assessments (72.40) (97,598.34) GL 1465 05/13/2014 Property Taxes/Assessments (40.80) (97,639.14) GL 1435 05/14/2014 Property Taxes/Assessments (2.58) (97,641.72) GL 1436 05/16/2014 Property Taxes/Assessments (.38) (97,642.10) GL 1437 05/19/2014 Property Taxes/Assessments (35.72) (97,677.82) GL 1438 05/20/2014 Property Taxes/Assessments (17.25) (97,695.07) GL 1439 05/21/2014 Property Taxes/Assessments (4.68) (97,699.75) GL 1444 05/22/2014 Property Taxes/Assessments (7.85) (97,707.60) GL 1445 05/23/2014 Property Taxes/Assessments (17.48) (97,725.08) GL 1446 05/27/2014 Property Taxes/Assessments (45.30) (97,770.38) GL 1447 05/28/2014 Property Taxes/Assessments (50.14) (97,820.52) GL 1459 05/29/2014 Property Taxes/Assessments (72.81) (97,893.33) GL 1460 05/30/2014 Property Taxes/Assessments (42.35) (97,935.68) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (499.01) (97,935.68) ** (99,250.00) Budgeted (1,314.32) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1434 05/12/2014 Property Taxes/Assessments (116.45) (.06) (116.51) GL 1460 05/30/2014 Property Taxes/Assessments (13.04) (129.55) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (13.10) (129.55) ** .00 Budgeted 129.55 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1416 05/05/2014 Property Taxes/Assessments (453.25) (.17) (453.42) GL 1418 05/07/2014 Property Taxes/Assessments (.25) (453.67) GL 1432 05/08/2014 Property Taxes/Assessments (6.32) (459.99) GL 1434 05/12/2014 Property Taxes/Assessments (8.37) (468.36) GL 1465 05/13/2014 Property Taxes/Assessments (3.45) (471.81) GL 1436 05/16/2014 Property Taxes/Assessments (.05) (471.86) GL 1437 05/19/2014 Property Taxes/Assessments (3.38) (475.24) GL 1445 05/23/2014 Property Taxes/Assessments (.34) (475.58) GL 1446 05/27/2014 Property Taxes/Assessments (3.75) (479.33) GL 1447 05/28/2014 Property Taxes/Assessments (4.42) (483.75) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1459 05/29/2014 Property Taxes/Assessments (453.25) (2.27) (486.02) GL 1460 05/30/2014 Property Taxes/Assessments (7.53) (493.55) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (40.30) (493.55) ** (900.00) Budgeted (406.45) Remaining 55 % Used Account: 135-43215-000-000 Insurance Settlement (82.36) .00 (82.36) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (82.36) ** .00 Budgeted 82.36 Remaining 0 % Used Account: 135-47000-000-000 Water 1399 05/06/2014 UB 5/6/14 Portable connect fee UB20140506-20140506 User: (1,394,162.60) (100.00) (1,394,262.60) UB 1424 05/19/2014 UB 5/19/14 Portable connect UB20140519-20140519 User: (100.00) (1,394,362.60) UB 1458 05/31/2014 UB 5/31/14 Billing UB20140531-20140531 User: (299,863.29) (1,694,225.89) UB _______________ Account: 135-47000-000-000 Water Totals: (300,063.29) (1,694,225.89) ** (3,749,310.00) Budgeted (2,055,084.11) Remaining 45 % Used Account: 135-47005-000-000 Sewer 1458 05/31/2014 UB 5/31/14 Billing UB20140531-20140531 User: (1,017,293.23) (182,853.97) (1,200,147.20) UB _______________ Account: 135-47005-000-000 Sewer Totals: (182,853.97) (1,200,147.20) ** (1,708,321.00) Budgeted (508,173.80) Remaining 70 % Used Account: 135-47025-000-000 Penalties 1385 05/21/2014 UB 5/21/14 Penalties UB20140521-20140521 User: (27,944.14) (3,961.81) (31,905.95) UB 1428 05/23/2014 UB 5/23/14 Penalty Adjustment UB20140523-20140523 User: 7.13 (31,898.82) UB 1457 05/29/2014 UB 5/29/14 Penalties UB20140529-20140529 User: 120.00 (31,778.82) UB _______________ Account: 135-47025-000-000 Penalties Totals: (3,834.68) (31,778.82) ** (64,522.00) Budgeted (32,743.18) Remaining 49 % Used Account: 135-47030-000-000 Service Charges 1325 05/07/2014 UB 5/7/14 Cut Off Fees UB20140507-20140507 User: (5,046.00) (775.00) (5,821.00) UB 1402 05/12/2014 UB 5/12/14 NSF Check Fee UB20140512-20140512 User: (25.00) (5,846.00) UB 1454 05/21/2014 UB 5/21/14 NSF check fee UB20140521-20140521 User: (25.00) (5,871.00) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1458 05/31/2014 UB 5/31/14 Billing UB20140531-20140531 User: (5,046.00) (3.00) (5,874.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (828.00) (5,874.00) ** (9,075.00) Budgeted (3,201.00) Remaining 65 % Used Account: 135-47035-000-000 Plumbing Inspections 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (1,750.00) (100.00) (1,850.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,850.00) ** (2,000.00) Budgeted (150.00) Remaining 93 % Used Account: 135-47045-000-000 Sewer Inspections 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (5,550.00) (300.00) (5,850.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (5,850.00) ** (5,000.00) Budgeted 850.00 Remaining 117 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1458 05/31/2014 UB 5/31/14 Billing UB20140531-20140531 User: (17,634.78) (9,531.90) (27,166.68) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (9,531.90) (27,166.68) ** (79,586.00) Budgeted (52,419.32) Remaining 34 % Used Account: 135-48005-000-000 Utility Fees 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (216,200.00) (18,400.00) (234,600.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (18,400.00) (234,600.00) ** (582,109.00) Budgeted (347,509.00) Remaining 40 % Used Account: 135-49010-000-000 Interest Income 1467 05/31/2014 Bank Statement Interest/May (3,546.10) (46.07) (3,592.17) GL 1467 05/31/2014 Bank Statement Interest/May (395.23) (3,987.40) GL 1467 05/31/2014 Bank Statement Interest/May (42.31) (4,029.71) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (483.61) (4,029.71) ** (4,800.00) Budgeted (770.29) Remaining 84 % Used Account: 135-49016-000-000 Cell Tower Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1366 05/16/2014 AT&T Antenna Lease (6,373.71) (910.53) (7,284.24) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (7,284.24) ** (10,164.00) Budgeted (2,879.76) Remaining 72 % Used Account: 135-49018-000-000 Building Rent Income 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (4,083.31) (583.33) (4,666.64) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,666.64) ** (7,000.00) Budgeted (2,333.36) Remaining 67 % Used Account: 135-49030-000-000 Vending Revenue (146.00) .00 (146.00) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (146.00) ** (350.00) Budgeted (204.00) Remaining 42 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (880,000.00) Budgeted (880,000.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (8,964.00) Budgeted (8,964.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (56,456.80) (3,430.00) (59,886.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (3,430.00) (59,886.80) ** (84,000.00) Budgeted (24,113.20) Remaining 71 % Used Account: 135-49900-000-000 Miscellaneous Income (1,158.08) .00 (1,158.08) . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: .00 (1,158.08) ** (3,000.00) Budgeted (1,841.92) Remaining 39 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (100.00) Budgeted (100.00) Remaining 0 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (4,087.00) .00 (4,087.00) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (4,087.00) ** (4,087.00) Budgeted .00 Remaining 100 % Used Account: 135-49905-000-000 Gas Well Revenue .00 .00 _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (886.00) Budgeted (886.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,381,392.20) ** (7,303,424.00) Budgeted (3,922,031.80) Remaining 46 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 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 1318 05/09/2014 MUD Payroll 5/9/14 Salaries & Wages 150,943.34 11,069.33 162,012.67 PR 1373 05/23/2014 MUD Payroll 5/23/14 Salaries & Wages 11,065.28 173,077.95 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 22,134.61 173,077.95 ** 287,709.00 Budgeted 114,631.05 Remaining 60 % Used Account: 135-50010-010-000 Overtime 1318 05/09/2014 MUD Payroll 5/9/14 Overtime 11,813.22 210.99 12,024.21 PR 1373 05/23/2014 MUD Payroll 5/23/14 Overtime 1,084.01 13,108.22 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,295.00 13,108.22 ** 16,391.00 Budgeted 3,282.78 Remaining 80 % Used Account: 135-50016-010-000 Longevity 4,905.00 .00 4,905.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 4,905.00 ** 4,905.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1373 05/23/2014 MUD Payroll 5/23/14 Certification 2,400.00 375.00 2,775.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 375.00 2,775.00 ** 5,100.00 Budgeted 2,325.00 Remaining 54 % Used Account: 135-50020-010-000 Retirement 1318 05/09/2014 MUD Payroll 5/9/14 Retirement 15,715.49 1,012.98 16,728.47 PR 1373 05/23/2014 MUD Payroll 5/23/14 Retirement 1,124.68 17,853.15 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,137.66 17,853.15 ** 27,847.00 Budgeted 9,993.85 Remaining 64 % Used Account: 135-50026-010-000 Medical Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Medical Insurance 22,700.55 1,780.02 24,480.57 PR 1373 05/23/2014 MUD Payroll 5/23/14 Medical Insurance 1,779.96 26,260.53 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,559.98 26,260.53 ** 48,334.00 Budgeted 22,073.47 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 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 1318 05/09/2014 MUD Payroll 5/9/14 Dental Insurance 1,676.97 124.54 1,801.51 PR 1373 05/23/2014 MUD Payroll 5/23/14 Dental Insurance 124.58 1,926.09 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 249.12 1,926.09 ** 3,932.00 Budgeted 2,005.91 Remaining 49 % Used Account: 135-50028-010-000 Vision Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Vision Insurance 406.99 31.49 438.48 PR 1373 05/23/2014 MUD Payroll 5/23/14 Vision Insurance 31.54 470.02 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 63.03 470.02 ** 873.00 Budgeted 402.98 Remaining 54 % Used Account: 135-50029-010-000 Life Insurance & Other 1276 05/01/2014 May A/P May Dental & Other Insurances 1,470.16 189.82 1,659.98 METLIFE 33703 AP 1484 05/31/2014 May A/P Admin Fee 15.28 1,675.26 BenefitMall 33823 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 205.10 1,675.26 ** 3,306.00 Budgeted 1,630.74 Remaining 51 % Used Account: 135-50030-010-000 Social Security Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Social Security Taxes 10,882.77 693.62 11,576.39 PR 1373 05/23/2014 MUD Payroll 5/23/14 Social Security Taxes 773.57 12,349.96 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,467.19 12,349.96 ** 19,289.00 Budgeted 6,939.04 Remaining 64 % Used Account: 135-50035-010-000 Medicare Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Medicare Taxes 2,545.17 162.23 2,707.40 PR 1373 05/23/2014 MUD Payroll 5/23/14 Medicare Taxes 180.90 2,888.30 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 343.13 2,888.30 ** 4,511.00 Budgeted 1,622.70 Remaining 64 % Used Account: 135-50040-010-000 Unemployment Taxes 1,244.44 .00 1,244.44 . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 1,244.44 ** 1,244.00 Budgeted (.44) Remaining 100 % Used Account: 135-50045-010-000 Workman's Compensation 54 05/01/2014 May Ins & W/C Expense 5,617.15 802.45 6,419.60 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 6,419.60 ** 9,829.00 Budgeted 3,409.40 Remaining 65 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 233.90 .00 233.90 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 233.90 ** 350.00 Budgeted 116.10 Remaining 67 % Used Account: 135-50070-010-000 Employee Relations 161.78 .00 161.78 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 161.78 ** 300.00 Budgeted 138.22 Remaining 54 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1336 05/08/2014 May A/P Leak repair/Campus Circle/Sola 34,624.28 8,454.79 43,079.07 REY-MAR CONSTRUCTION 33756 AP 1362 05/16/2014 May A/P Parts for wells 382.08 43,461.15 HD SUPPLY WATERWORKS, LTD. 33785 AP 1362 05/16/2014 May A/P Parts for Westlake leak 718.73 44,179.88 HD SUPPLY WATERWORKS, LTD. 33785 AP 1380 05/20/2014 May A/P Credit Memo (122.61) 44,057.27 HD SUPPLY WATERWORKS, LTD. 33785 AP 1405 05/23/2014 May A/P V Notch for Omni Valve 86.50 44,143.77 SCOOP 33816 AP 1405 05/23/2014 May A/P Ejector for Chlorine 592.91 44,736.68 SCOOP 33816 AP 1405 05/23/2014 May A/P Well # 1 repair 555.00 45,291.68 MILLICAN WELL SERVICE, LLC 33813 AP 1480 05/27/2014 May A/P THE HOME DEPOT 6581 47.16 45,338.84 THE HOME DEPOT 6581 PC 1480 05/27/2014 May A/P THE HOME DEPOT 6581 75.20 45,414.04 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1480 05/27/2014 May A/P THE HOME DEPOT 6581 34,624.28 12.87 45,426.91 THE HOME DEPOT 6581 PC 1480 05/27/2014 May A/P WW GRAINGER 17.52 45,444.43 WW GRAINGER PC 1502 05/31/2014 May A/P Quantum Couplings, Gaskets 518.85 45,963.28 HD SUPPLY WATERWORKS, LTD. 33842 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 11,339.00 45,963.28 ** 61,000.00 Budgeted 15,036.72 Remaining 75 % Used Account: 135-55090-010-000 Vehicle Maintenance 2,479.60 .00 2,479.60 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 2,479.60 ** 5,000.00 Budgeted 2,520.40 Remaining 50 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 248.33 .00 248.33 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 248.33 ** 2,500.00 Budgeted 2,251.67 Remaining 10 % Used Account: 135-55135-010-000 Lab Analysis 1502 05/31/2014 May A/P Bac T Samples/MUD 2,693.91 220.00 2,913.91 TARRANT CTY PUBLIC HEALTH LAB 33872 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 220.00 2,913.91 ** 5,500.00 Budgeted 2,586.09 Remaining 53 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1406 05/23/2014 May A/P Verizon, Kyocera 2,297.93 383.52 2,681.45 TOWN OF TROPHY CLUB 33817 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 383.52 2,681.45 ** 4,913.00 Budgeted 2,231.55 Remaining 55 % Used Account: 135-60020-010-000 Electricity 1380 05/20/2014 May A/P Electricity 4/11-5/13/14 56,624.41 9,206.70 65,831.11 HUDSON ENERGY SERVICES, LLC 33786 AP 1380 05/20/2014 May A/P Electricity 4/10-5/12/14 81.32 65,912.43 HUDSON ENERGY SERVICES, LLC 33786 AP 1380 05/20/2014 May A/P Electricity 4/11-5/13/14 3,899.30 69,811.73 HUDSON ENERGY SERVICES, LLC 33786 AP _______________ Account: 135-60020-010-000 Electricity Totals: 13,187.32 69,811.73 ** 155,160.00 Budgeted 85,348.27 Remaining 45 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 2,538.00 Budgeted 2,538.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships 289.00 .00 289.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 289.00 ** 300.00 Budgeted 11.00 Remaining 96 % Used Account: 135-60080-010-000 Schools & Training 1480 05/27/2014 May A/P TX DPS DL OFFICE 1,065.00 69.00 1,134.00 TX DPS DL OFFICE PC 1480 05/27/2014 May A/P METROPLEX TRAINING CEN 200.00 1,334.00 METROPLEX TRAINING CEN PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 269.00 1,334.00 ** 1,500.00 Budgeted 166.00 Remaining 89 % Used Account: 135-60100-010-000 Travel & per diem 1480 05/27/2014 May A/P CFW PARKING METER 171.13 1.50 172.63 CFW PARKING METER PC _______________ Account: 135-60100-010-000 Travel & per diem Totals: 1.50 172.63 ** 279.00 Budgeted 106.37 Remaining 62 % Used Account: 135-60105-010-000 Rent/Lease Equipment 60.00 .00 60.00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 60.00 ** 500.00 Budgeted 440.00 Remaining 12 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 1380 05/20/2014 May A/P NTGC Dist fees 32,195.79 267.80 32,463.59 North Texas Groundwater 33794 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 267.80 32,463.59 ** 47,400.00 Budgeted 14,936.41 Remaining 68 % Used Account: 135-60150-010-000 Wholesale Water . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1484 05/31/2014 May A/P Wholesale Water/April 782,475.27 168,637.52 951,112.79 CITY OF FORT WORTH 33827 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 168,637.52 951,112.79 ** 2,338,473.00 Budgeted 1,387,360.21 Remaining 41 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 1,289.55 .00 1,289.55 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 1,289.55 ** 3,500.00 Budgeted 2,210.45 Remaining 37 % 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 1,664.20 .00 1,664.20 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 1,664.20 ** 2,000.00 Budgeted 335.80 Remaining 83 % Used Account: 135-65005-010-000 Fuel & Lube 1470 05/31/2014 May Gaslog 7,139.26 1,305.04 8,444.30 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,305.04 8,444.30 ** 22,181.00 Budgeted 13,736.70 Remaining 38 % Used Account: 135-65010-010-000 Uniforms 1,938.58 .00 1,938.58 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,938.58 ** 2,500.00 Budgeted 561.42 Remaining 78 % Used Account: 135-65030-010-000 Chemicals 1380 05/20/2014 May A/P Nitrite 3,672.22 160.82 3,833.04 HACH COMPANY 33784 AP 1380 05/20/2014 May A/P Free Ammonia 141.84 3,974.88 HACH COMPANY 33784 AP 1480 05/27/2014 May A/P ALBERTSONS #4149 2.39 3,977.27 ALBERTSONS #4149 PC _______________ Account: 135-65030-010-000 Chemicals Totals: 305.05 3,977.27 ** 5,000.00 Budgeted 1,022.73 Remaining 80 % Used Account: 135-65035-010-000 Small Tools 1480 05/27/2014 May A/P BAKER DISTRIBUTING #22 464.94 25.98 490.92 BAKER DISTRIBUTING #22 PC _______________ Account: 135-65035-010-000 Small Tools Totals: 25.98 490.92 ** 1,200.00 Budgeted 709.08 Remaining 41 % Used Account: 135-65040-010-000 Safety Equipment 1480 05/27/2014 May A/P THE HOME DEPOT 6581 322.67 21.88 344.55 THE HOME DEPOT 6581 PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 21.88 344.55 ** 1,000.00 Budgeted 655.45 Remaining 34 % Used Account: 135-65050-010-000 Meter Expense 1380 05/20/2014 May A/P 12 5/8" Orion Heads 64,481.04 1,860.00 66,341.04 ATLAS UTILITY SUPPLY CO. 33778 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 1,860.00 66,341.04 ** 143,550.00 Budgeted 77,208.96 Remaining 46 % Used Account: 135-69005-010-000 Capital Outlays 35,679.59 .00 35,679.59 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 35,679.59 ** 35,681.00 Budgeted 1.41 Remaining 100 % Used Account: 135-69008-010-000 Short Term Debt-Principal . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 122,980.00 .00 122,980.00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 122,980.00 ** 489,980.00 Budgeted 367,000.00 Remaining 25 % Used Account: 135-69009-010-000 Short Term Debt-Interest 11,621.26 .00 11,621.26 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 11,621.26 ** 19,268.00 Budgeted 7,646.74 Remaining 60 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 100,816.54 ** 100,847.00 Budgeted 30.46 Remaining 100 % Used Account: 135-55135-010-001 Lab Analysis for PID 1484 05/31/2014 May A/P PID Lead & Copper Sampling 964.61 1,600.00 2,564.61 LOWER COLORADO RIVER AUTHORITY 33857 AP 1502 05/31/2014 May A/P Bac T Sample test/PID 80.00 2,644.61 TARRANT CTY PUBLIC HEALTH LAB 33872 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 1,680.00 2,644.61 ** 2,000.00 Budgeted (644.61) Remaining 132 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID 2,496.19 .00 2,496.19 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 2,496.19 ** 5,000.00 Budgeted 2,503.81 Remaining 50 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,735,608.11 ** 3,899,140.00 Budgeted 2,163,531.89 Remaining 45 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 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 1318 05/09/2014 MUD Payroll 5/9/14 Salaries & Wages 109,470.35 7,785.51 117,255.86 PR 1373 05/23/2014 MUD Payroll 5/23/14 Salaries & Wages 7,785.51 125,041.37 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,571.02 125,041.37 ** 202,894.00 Budgeted 77,852.63 Remaining 62 % Used Account: 135-50010-020-000 Overtime 1318 05/09/2014 MUD Payroll 5/9/14 Overtime 8,534.36 776.20 9,310.56 PR 1373 05/23/2014 MUD Payroll 5/23/14 Overtime 502.83 9,813.39 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,279.03 9,813.39 ** 11,965.00 Budgeted 2,151.61 Remaining 82 % Used Account: 135-50016-020-000 Longevity 2,997.50 .00 2,997.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,997.50 ** 2,998.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1373 05/23/2014 MUD Payroll 5/23/14 Certification 2,800.00 400.00 3,200.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 3,200.00 ** 4,800.00 Budgeted 1,600.00 Remaining 67 % Used Account: 135-50020-020-000 Retirement 1318 05/09/2014 MUD Payroll 5/9/14 Retirement 11,585.80 768.83 12,354.63 PR 1373 05/23/2014 MUD Payroll 5/23/14 Retirement 780.22 13,134.85 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,549.05 13,134.85 ** 19,905.00 Budgeted 6,770.15 Remaining 66 % Used Account: 135-50026-020-000 Medical Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Medical Insurance 23,534.56 1,713.39 25,247.95 PR 1373 05/23/2014 MUD Payroll 5/23/14 Medical Insurance 1,713.37 26,961.32 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,426.76 26,961.32 ** 43,471.00 Budgeted 16,509.68 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 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 1318 05/09/2014 MUD Payroll 5/9/14 Dental Insurance 1,524.90 105.68 1,630.58 PR 1373 05/23/2014 MUD Payroll 5/23/14 Dental Insurance 105.70 1,736.28 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 211.38 1,736.28 ** 2,989.00 Budgeted 1,252.72 Remaining 58 % Used Account: 135-50028-020-000 Vision Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Vision Insurance 354.83 25.61 380.44 PR 1373 05/23/2014 MUD Payroll 5/23/14 Vision Insurance 25.65 406.09 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 51.26 406.09 ** 658.00 Budgeted 251.91 Remaining 62 % Used Account: 135-50029-020-000 Life Insurance & Other 1276 05/01/2014 May A/P May Dental & Other Insurances 1,222.05 200.23 1,422.28 METLIFE 33703 AP 1484 05/31/2014 May A/P Admin Fee 30.56 1,452.84 BenefitMall 33823 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 230.79 1,452.84 ** 2,303.00 Budgeted 850.16 Remaining 63 % Used Account: 135-50030-020-000 Social Security Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Social Security Taxes 7,085.51 454.94 7,540.45 PR 1373 05/23/2014 MUD Payroll 5/23/14 Social Security Taxes 468.23 8,008.68 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 923.17 8,008.68 ** 13,805.00 Budgeted 5,796.32 Remaining 58 % Used Account: 135-50035-020-000 Medicare Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Medicare Taxes 1,657.08 106.40 1,763.48 PR 1373 05/23/2014 MUD Payroll 5/23/14 Medicare Taxes 109.52 1,873.00 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 215.92 1,873.00 ** 3,229.00 Budgeted 1,356.00 Remaining 58 % Used Account: 135-50040-020-000 Unemployment Taxes 828.00 .00 828.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 828.00 ** 828.00 Budgeted .00 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 54 05/01/2014 May Ins & W/C Expense 3,745.56 535.08 4,280.64 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 4,280.64 ** 6,552.00 Budgeted 2,271.36 Remaining 65 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 63.00 .00 63.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 63.00 ** 150.00 Budgeted 87.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 59.99 .00 59.99 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 59.99 ** 350.00 Budgeted 290.01 Remaining 17 % Used Account: 135-55070-020-000 Independent Labor 1498 05/31/2014 May A/P WWTP Improvements 534,983.75 71,318.20 606,301.95 THE WALLACE GROUP, INC. 33875 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 71,318.20 606,301.95 ** 880,000.00 Budgeted 273,698.05 Remaining 69 % Used Account: 135-55080-020-000 Maintenance & Repairs 1380 05/20/2014 May A/P Repair Waste pump 24,674.29 1,403.27 26,077.56 XYLEM WATER SOLUTIONS USA INC 33807 AP 1380 05/20/2014 May A/P 25 hp motor recondition, New 2 1,050.00 27,127.56 PETERSON PUMP & MOTOR SERVICE 33797 AP 1380 05/20/2014 May A/P Custom Signage for Land next t 565.00 27,692.56 N.Texas Signs & Routing, Inc 33793 AP 1480 05/27/2014 May A/P THE HOME DEPOT 6581 17.94 27,710.50 THE HOME DEPOT 6581 PC 1480 05/27/2014 May A/P TEXAS RUBBER SUPPLY IN 86.28 27,796.78 TEXAS RUBBER SUPPLY IN PC 1480 05/27/2014 May A/P THE HOME DEPOT 6581 29.97 27,826.75 THE HOME DEPOT 6581 PC 1480 05/27/2014 May A/P AUTOZONE #4206 19.98 27,846.73 AUTOZONE #4206 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 3,172.44 27,846.73 ** 36,120.00 Budgeted 8,273.27 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-020-000 Vehicle Maintenance 1,652.49 .00 1,652.49 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 1,652.49 ** 2,000.00 Budgeted 347.51 Remaining 83 % Used Account: 135-55125-020-000 Dumpster Services 1380 05/20/2014 May A/P Sludge haul off 32,959.57 1,752.78 34,712.35 L.H. CHANEY MATERIALS, INC. 33790 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 1,752.78 34,712.35 ** 47,000.00 Budgeted 12,287.65 Remaining 74 % Used Account: 135-55135-020-000 Lab Analysis 1380 05/20/2014 May A/P Testing 17,539.26 246.00 17,785.26 OXIDOR LABORATORIES LLC 33796 AP 1380 05/20/2014 May A/P Testing 176.00 17,961.26 OXIDOR LABORATORIES LLC 33796 AP 1380 05/20/2014 May A/P Testing 246.00 18,207.26 OXIDOR LABORATORIES LLC 33796 AP 1380 05/20/2014 May A/P Testing 176.00 18,383.26 OXIDOR LABORATORIES LLC 33796 AP 1380 05/20/2014 May A/P Testing 246.00 18,629.26 OXIDOR LABORATORIES LLC 33796 AP 1380 05/20/2014 May A/P Testing 176.00 18,805.26 OXIDOR LABORATORIES LLC 33796 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,266.00 18,805.26 ** 30,000.00 Budgeted 11,194.74 Remaining 63 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1406 05/23/2014 May A/P Verizon, Kyocera 1,536.30 389.32 1,925.62 TOWN OF TROPHY CLUB 33817 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 389.32 1,925.62 ** 3,329.00 Budgeted 1,403.38 Remaining 58 % Used Account: 135-60020-020-000 Electricity 1380 05/20/2014 May A/P Electricity 4/11-5/13/14 58,056.46 9,938.56 67,995.02 HUDSON ENERGY SERVICES, LLC 33786 AP _______________ Account: 135-60020-020-000 Electricity Totals: 9,938.56 67,995.02 ** 138,227.00 Budgeted 70,231.98 Remaining 49 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 351.00 .00 351.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 351.00 ** 400.00 Budgeted 49.00 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training 1,087.00 .00 1,087.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 1,087.00 ** 1,636.00 Budgeted 549.00 Remaining 66 % Used Account: 135-60090-020-000 Safety Program 1380 05/20/2014 May A/P fill first aid cabinet 432.07 42.00 474.07 CINTAS CORPORATION NO. 2 33780 AP _______________ Account: 135-60090-020-000 Safety Program Totals: 42.00 474.07 ** 500.00 Budgeted 25.93 Remaining 95 % Used Account: 135-60100-020-000 Travel & per diem 1480 05/27/2014 May A/P SCHLOTZSKY'S 1149 292.81 21.61 314.42 SCHLOTZSKY'S 1149 PC 1480 05/27/2014 May A/P FLIPS PATIO GRILL FORT 24.03 338.45 FLIPS PATIO GRILL FORT PC 1480 05/27/2014 May A/P RADISSON 319.70 658.15 RADISSON PC 1480 05/27/2014 May A/P RADISSON 319.70 977.85 RADISSON PC 1480 05/27/2014 May A/P DOWNTOWN JOS 24.30 1,002.15 DOWNTOWN JOS PC 1480 05/27/2014 May A/P DOWNTOWN JOS 24.30 1,026.45 DOWNTOWN JOS PC 1480 05/27/2014 May A/P OASIS 58.66 1,085.11 OASIS PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 792.30 1,085.11 ** 1,050.00 Budgeted (35.11) Remaining 103 % Used Account: 135-60105-020-000 Rent/Lease Equipment 299.53 .00 299.53 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 8,919.00 .00 8,919.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 8,919.00 ** 17,150.00 Budgeted 8,231.00 Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60243-020-000 Prior Year Expense 3,554.22 .00 3,554.22 _______________ Account: 135-60243-020-000 Prior Year Expense Totals: .00 3,554.22 ** 3,554.00 Budgeted (.22) Remaining 100 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.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 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1,079.10 .00 1,079.10 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,079.10 ** 1,079.00 Budgeted (.10) Remaining 100 % Used Account: 135-65005-020-000 Fuel & Lube 1470 05/31/2014 May Gaslog 6,334.35 853.95 7,188.30 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 853.95 7,188.30 ** 13,600.00 Budgeted 6,411.70 Remaining 53 % Used Account: 135-65010-020-000 Uniforms 1,437.27 .00 1,437.27 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,437.27 ** 1,752.00 Budgeted 314.73 Remaining 82 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 17,572.10 .00 17,572.10 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 17,572.10 ** 31,000.00 Budgeted 13,427.90 Remaining 57 % Used Account: 135-65035-020-000 Small Tools 1480 05/27/2014 May A/P SHELL OIL 57545579807 91.00 49.79 140.79 SHELL OIL 57545579807 PC 1480 05/27/2014 May A/P 7-ELEVEN 27575 36.30 177.09 7-ELEVEN 27575 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 86.09 177.09 ** 300.00 Budgeted 122.91 Remaining 59 % Used Account: 135-65040-020-000 Safety Equipment 230.63 .00 230.63 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 230.63 ** 500.00 Budgeted 269.37 Remaining 46 % Used Account: 135-65045-020-000 Lab Supplies 1480 05/27/2014 May A/P HACH COMPANY 6,932.13 527.78 7,459.91 HACH COMPANY PC 1480 05/27/2014 May A/P IDEXX DISTRIBUTION INC 1,899.55 9,359.46 IDEXX DISTRIBUTION INC PC 1480 05/27/2014 May A/P IDEXX DISTRIBUTION INC 160.29 9,519.75 IDEXX DISTRIBUTION INC PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,587.62 9,519.75 ** 15,000.00 Budgeted 5,480.25 Remaining 63 % Used Account: 135-69008-020-000 Short Term Debt-Principal 20,020.00 .00 20,020.00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 20,020.00 ** 20,020.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 1,043.70 .00 1,043.70 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 1,043.70 ** 1,422.00 Budgeted 378.30 Remaining 73 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,033,134.24 ** 1,564,486.00 Budgeted 531,351.76 Remaining 66 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2014 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-021-000 Salaries & Wages 1318 05/09/2014 MUD Payroll 5/9/14 Salaries & Wages 40,044.93 3,434.64 43,479.57 PR 1373 05/23/2014 MUD Payroll 5/23/14 Salaries & Wages 3,434.64 46,914.21 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 6,869.28 46,914.21 ** 90,299.00 Budgeted 43,384.79 Remaining 52 % Used Account: 135-50010-021-000 Overtime 1318 05/09/2014 MUD Payroll 5/9/14 Overtime 2,573.12 456.48 3,029.60 PR 1373 05/23/2014 MUD Payroll 5/23/14 Overtime 144.22 3,173.82 PR _______________ Account: 135-50010-021-000 Overtime Totals: 600.70 3,173.82 ** 10,028.00 Budgeted 6,854.18 Remaining 32 % Used Account: 135-50016-021-000 Longevity 2,107.50 .00 2,107.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 2,107.50 ** 2,108.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 1373 05/23/2014 MUD Payroll 5/23/14 Certification 1,050.00 150.00 1,200.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,200.00 ** 1,800.00 Budgeted 600.00 Remaining 67 % Used Account: 135-50020-021-000 Retirement 1318 05/09/2014 MUD Payroll 5/9/14 Retirement 4,465.65 349.42 4,815.07 PR 1373 05/23/2014 MUD Payroll 5/23/14 Retirement 334.85 5,149.92 PR _______________ Account: 135-50020-021-000 Retirement Totals: 684.27 5,149.92 ** 9,025.00 Budgeted 3,875.08 Remaining 57 % Used Account: 135-50026-021-000 Medical Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Medical Insurance 11,147.59 736.86 11,884.45 PR 1373 05/23/2014 MUD Payroll 5/23/14 Medical Insurance 736.84 12,621.29 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,473.70 12,621.29 ** 23,668.00 Budgeted 11,046.71 Remaining 53 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2014 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-021-000 Dental Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Dental Insurance 812.79 51.30 864.09 PR 1373 05/23/2014 MUD Payroll 5/23/14 Dental Insurance 51.30 915.39 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 102.60 915.39 ** 1,703.00 Budgeted 787.61 Remaining 54 % Used Account: 135-50028-021-000 Vision Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Vision Insurance 170.57 11.84 182.41 PR 1373 05/23/2014 MUD Payroll 5/23/14 Vision Insurance 11.84 194.25 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.68 194.25 ** 314.00 Budgeted 119.75 Remaining 62 % Used Account: 135-50029-021-000 Life Insurance & Other 1276 05/01/2014 May A/P May Dental & Other Insurances 611.03 73.96 684.99 METLIFE 33703 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 73.96 684.99 ** 1,066.00 Budgeted 381.01 Remaining 64 % Used Account: 135-50030-021-000 Social Security Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Social Security Taxes 2,785.58 221.87 3,007.45 PR 1373 05/23/2014 MUD Payroll 5/23/14 Social Security Taxes 216.63 3,224.08 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 438.50 3,224.08 ** 7,442.00 Budgeted 4,217.92 Remaining 43 % Used Account: 135-50035-021-000 Medicare Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Medicare Taxes 651.46 51.90 703.36 PR 1373 05/23/2014 MUD Payroll 5/23/14 Medicare Taxes 50.66 754.02 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 102.56 754.02 ** 1,741.00 Budgeted 986.98 Remaining 43 % Used Account: 135-50040-021-000 Unemployment Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Unemployment Taxes 372.68 41.32 414.00 PR _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: 41.32 414.00 ** 414.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2014 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-021-000 Workman's Compensation 54 05/01/2014 May Ins & W/C Expense 1,872.78 267.54 2,140.32 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 2,140.32 ** 3,276.00 Budgeted 1,135.68 Remaining 65 % Used Account: 135-50070-021-000 Employee Relations 132.02 .00 132.02 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 132.02 ** 200.00 Budgeted 67.98 Remaining 66 % Used Account: 135-55080-021-000 Maintenance & Repairs 1380 05/20/2014 May A/P 25 hp motor recondition, New 2 5,700.26 1,250.00 6,950.26 PETERSON PUMP & MOTOR SERVICE 33797 AP 1480 05/27/2014 May A/P ROANOKE AUTO SUPPLY LT 65.98 7,016.24 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 1,315.98 7,016.24 ** 14,451.00 Budgeted 7,434.76 Remaining 49 % Used Account: 135-55090-021-000 Vehicle Maintenance 999.18 .00 999.18 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 999.18 ** 2,000.00 Budgeted 1,000.82 Remaining 50 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 1406 05/23/2014 May A/P Verizon, Kyocera 789.08 102.72 891.80 TOWN OF TROPHY CLUB 33817 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 102.72 891.80 ** 1,333.00 Budgeted 441.20 Remaining 67 % Used Account: 135-60020-021-000 Electricity 1362 05/16/2014 May A/P Electricity 4/1-4/30/14 11,947.04 358.71 12,305.75 TRI COUNTY ELECTRIC 33803 AP 1362 05/16/2014 May A/P Electricity 4/1-4/30/14 176.18 12,481.93 TRI COUNTY ELECTRIC 33803 AP 1362 05/16/2014 May A/P Electricity 4/1-4/30/14 28.27 12,510.20 TRI COUNTY ELECTRIC 33803 AP 1362 05/16/2014 May A/P Electricity 4/10/14-5/12/14 60.87 12,571.07 HUDSON ENERGY SERVICES, LLC 33786 AP 1362 05/16/2014 May A/P Electricity 4/10/14-5/12/14 30.37 12,601.44 HUDSON ENERGY SERVICES, LLC 33786 AP 1380 05/20/2014 May A/P Electricity 4/11-5/13/14 600.92 13,202.36 HUDSON ENERGY SERVICES, LLC 33786 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1380 05/20/2014 May A/P Electricity 4/11-5/13/14 11,947.04 500.46 13,702.82 HUDSON ENERGY SERVICES, LLC 33786 AP 1380 05/20/2014 May A/P Electricity 4/11-5/13/14 90.96 13,793.78 HUDSON ENERGY SERVICES, LLC 33786 AP 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (125.18) 13,668.60 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,721.56 13,668.60 ** 21,178.00 Budgeted 7,509.40 Remaining 65 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training .00 .00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 .00 ** 911.00 Budgeted 911.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program 35.34 .00 35.34 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 35.34 ** 300.00 Budgeted 264.66 Remaining 12 % Used Account: 135-60100-021-000 Travel & per diem 38.49 .00 38.49 _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 38.49 ** 250.00 Budgeted 211.51 Remaining 15 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 1480 05/27/2014 May A/P KWIK KAR LUBE & TUNE O 7,031.03 39.75 7,070.78 KWIK KAR LUBE & TUNE O PC 1470 05/31/2014 May Gaslog 936.22 8,007.00 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 975.97 8,007.00 ** 21,747.00 Budgeted 13,740.00 Remaining 37 % Used Account: 135-65010-021-000 Uniforms 814.23 .00 814.23 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 814.23 ** 1,040.00 Budgeted 225.77 Remaining 78 % Used Account: 135-65030-021-000 Chemicals 1380 05/20/2014 May A/P Lift-Zyme WWT 6 gals 300.89 300.89 United Laboratories 33805 AP _______________ Account: 135-65030-021-000 Chemicals Totals: 300.89 300.89 ** 2,000.00 Budgeted 1,699.11 Remaining 15 % Used Account: 135-65035-021-000 Small Tools 43.99 .00 43.99 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 43.99 ** 300.00 Budgeted 256.01 Remaining 15 % Used Account: 135-65040-021-000 Safety Equipment 586.73 .00 586.73 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 586.73 ** 750.00 Budgeted 163.27 Remaining 78 % Used Account: 135-69005-021-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 68,300.20 .00 68,300.20 _______________ Account: 135-69005-021-000 Capital Outlays Totals: .00 68,300.20 ** 114,000.00 Budgeted 45,699.80 Remaining 60 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 35,991.00 Budgeted 35,991.00 Remaining 0 % Used Account: 135-69009-021-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-021-000 Short Term Debt-Interest Totals: .00 .00 ** 2,846.00 Budgeted 2,846.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 180,328.50 ** 377,531.00 Budgeted 197,202.50 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2014 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 1318 05/09/2014 MUD Payroll 5/9/14 Salaries & Wages 5,600.00 500.00 6,100.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 6,100.00 ** 10,000.00 Budgeted 3,900.00 Remaining 61 % Used Account: 135-50030-026-000 Social Security Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Social Security Taxes 347.20 31.00 378.20 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 378.20 ** 620.00 Budgeted 241.80 Remaining 61 % Used Account: 135-50035-026-000 Medicare Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Medicare Taxes 81.20 7.25 88.45 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 88.45 ** 145.00 Budgeted 56.55 Remaining 61 % Used Account: 135-50040-026-000 Unemployment Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Unemployment Taxes 73.80 11.50 85.30 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 11.50 85.30 ** 230.00 Budgeted 144.70 Remaining 37 % Used Account: 135-50045-026-000 Workman's Compensation 54 05/01/2014 May Ins & W/C Expense 20.65 2.94 23.59 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 23.59 ** 36.00 Budgeted 12.41 Remaining 66 % 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 42 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2014 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 35.95 .00 35.95 _______________ Account: 135-60075-026-000 Meetings Totals: .00 35.95 ** 1,200.00 Budgeted 1,164.05 Remaining 3 % Used Account: 135-60080-026-000 Schools & Training 1480 05/27/2014 May A/P NW METROPORT CHAMBER O 265.00 22.00 287.00 NW METROPORT CHAMBER O PC 1480 05/27/2014 May A/P TRWA 00 OF 00 345.00 632.00 TRWA 00 OF 00 PC _______________ Account: 135-60080-026-000 Schools & Training Totals: 367.00 632.00 ** 4,000.00 Budgeted 3,368.00 Remaining 16 % Used Account: 135-60100-026-000 Travel & per diem 41.66 .00 41.66 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 41.66 ** 5,000.00 Budgeted 4,958.34 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1480 05/27/2014 May A/P KELLER TROPHY AND AWAR 169.40 169.40 KELLER TROPHY AND AWAR PC 1480 05/27/2014 May A/P RANDALLS STORE00017897 10.00 179.40 RANDALLS STORE00017897 PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 179.40 179.40 ** 1,000.00 Budgeted 820.60 Remaining 18 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 7,599.55 ** 22,881.00 Budgeted 15,281.45 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 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 1318 05/09/2014 MUD Payroll 5/9/14 Salaries & Wages 248,617.20 17,546.89 266,164.09 PR 1373 05/23/2014 MUD Payroll 5/23/14 Salaries & Wages 17,546.37 283,710.46 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,093.26 283,710.46 ** 458,721.00 Budgeted 175,010.54 Remaining 62 % Used Account: 135-50010-030-000 Overtime 1318 05/09/2014 MUD Payroll 5/9/14 Overtime 588.02 61.29 649.31 PR 1373 05/23/2014 MUD Payroll 5/23/14 Overtime 27.40 676.71 PR _______________ Account: 135-50010-030-000 Overtime Totals: 88.69 676.71 ** 750.00 Budgeted 73.29 Remaining 90 % Used Account: 135-50016-030-000 Longevity 3,077.50 .00 3,077.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,077.50 ** 3,018.00 Budgeted (59.50) Remaining 102 % Used Account: 135-50020-030-000 Retirement 1318 05/09/2014 MUD Payroll 5/9/14 Retirement 23,627.73 1,581.20 25,208.93 PR 1373 05/23/2014 MUD Payroll 5/23/14 Retirement 1,578.12 26,787.05 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,159.32 26,787.05 ** 41,419.00 Budgeted 14,631.95 Remaining 65 % Used Account: 135-50026-030-000 Medical Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Medical Insurance 32,550.47 2,402.43 34,952.90 PR 1373 05/23/2014 MUD Payroll 5/23/14 Medical Insurance 2,402.38 37,355.28 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,804.81 37,355.28 ** 57,923.00 Budgeted 20,567.72 Remaining 64 % Used Account: 135-50027-030-000 Dental Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Dental Insurance 2,520.70 170.19 2,690.89 PR 1373 05/23/2014 MUD Payroll 5/23/14 Dental Insurance 170.23 2,861.12 PR 1476 05/31/2014 Balance & Clear Ins accruals (94.09) 2,767.03 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 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: 246.33 2,767.03 ** 5,100.00 Budgeted 2,332.97 Remaining 54 % Used Account: 135-50028-030-000 Vision Insurance 1318 05/09/2014 MUD Payroll 5/9/14 Vision Insurance 574.07 40.78 614.85 PR 1373 05/23/2014 MUD Payroll 5/23/14 Vision Insurance 40.84 655.69 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.62 655.69 ** 1,087.00 Budgeted 431.31 Remaining 60 % Used Account: 135-50029-030-000 Life Insurance & Other 1276 05/01/2014 May A/P May Dental & Other Insurances 2,887.07 317.73 3,204.80 METLIFE 33703 AP 1476 05/31/2014 Balance & Clear Ins accruals 6.54 3,211.34 GL 1484 05/31/2014 May A/P Admin Fee 38.16 3,249.50 BenefitMall 33823 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 362.43 3,249.50 ** 5,500.00 Budgeted 2,250.50 Remaining 59 % Used Account: 135-50030-030-000 Social Security Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Social Security Taxes 15,449.15 1,030.88 16,480.03 PR 1373 05/23/2014 MUD Payroll 5/23/14 Social Security Taxes 1,016.68 17,496.71 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,047.56 17,496.71 ** 28,659.00 Budgeted 11,162.29 Remaining 61 % Used Account: 135-50035-030-000 Medicare Taxes 1318 05/09/2014 MUD Payroll 5/9/14 Medicare Taxes 3,613.11 241.09 3,854.20 PR 1373 05/23/2014 MUD Payroll 5/23/14 Medicare Taxes 237.78 4,091.98 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 478.87 4,091.98 ** 6,702.00 Budgeted 2,610.02 Remaining 61 % Used Account: 135-50040-030-000 Unemployment Taxes 1,449.00 .00 1,449.00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 1,449.00 ** 1,449.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 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 54 05/01/2014 May Ins & W/C Expense 900.41 128.62 1,029.03 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.62 1,029.03 ** 1,575.00 Budgeted 545.97 Remaining 65 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 1480 05/27/2014 May A/P INT*C.I. AWESOME BLOSS 2,668.93 45.00 2,713.93 INT*C.I. AWESOME BLOSS PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 45.00 2,713.93 ** 5,000.00 Budgeted 2,286.07 Remaining 54 % Used Account: 135-55030-030-000 Software & Support 1362 05/16/2014 May A/P Annual Software Lease 24,123.81 13,115.00 37,238.81 STW INC 33800 AP 1380 05/20/2014 May A/P IT BOA 3/28-4/27/14 166.51 37,405.32 TOWN OF TROPHY CLUB 33802 AP 1484 05/31/2014 May A/P Fix WWTP Cable 95.00 37,500.32 CINGL TELECOM, LLC 33826 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 13,376.51 37,500.32 ** 59,698.00 Budgeted 22,197.68 Remaining 63 % Used Account: 135-55070-030-000 Independent Labor 1405 05/23/2014 May A/P Record MUD meeting 5,795.48 52.50 5,847.98 MIGUEL CRUZ 33812 AP 1504 05/31/2014 May A/P Professional Fees 1,300.00 7,147.98 NEW GEN STRATEGIES & SOLUTIONS 33861 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 1,352.50 7,147.98 ** 7,000.00 Budgeted (147.98) Remaining 102 % Used Account: 135-55080-030-000 Maintenance & Repairs 428.45 .00 428.45 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 428.45 ** 4,500.00 Budgeted 4,071.55 Remaining 10 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 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 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: 2,119.27 (188.84) 1,930.43 AR 1484 05/31/2014 May A/P Rug Service 94.42 2,024.85 G & K SERVICES 33839 AP 1484 05/31/2014 May A/P Rug Service 94.42 2,119.27 G & K SERVICES 33839 AP 1484 05/31/2014 May A/P Rug Service 94.42 2,213.69 G & K SERVICES 33839 AP 1484 05/31/2014 May A/P Rug Service 94.42 2,308.11 G & K SERVICES 33839 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 188.84 2,308.11 ** 6,500.00 Budgeted 4,191.89 Remaining 36 % Used Account: 135-55120-030-000 Cleaning Services 1362 05/16/2014 May A/P April Janitorial Service 9,569.82 1,594.97 11,164.79 MEMBER'S BUILDING MAINTENANCE 33791 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 11,164.79 ** 19,140.00 Budgeted 7,975.21 Remaining 58 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55161-030-000 Town Personnel Contract 77,048.00 .00 77,048.00 _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 77,048.00 ** 77,048.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 1502 05/31/2014 May A/P Utility billing/insert 4,897.39 928.02 5,825.41 DATAPROSE LLC 33829 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 928.02 5,825.41 ** 6,808.00 Budgeted 982.59 Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-000 Telephone 1380 05/20/2014 May A/P IT BOA 3/28-4/27/14 6,506.50 959.95 7,466.45 TOWN OF TROPHY CLUB 33802 AP 1405 05/23/2014 May A/P Answering service May 180.00 7,646.45 KEYSTONE PARK SECRETARIAL 33811 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,139.95 7,646.45 ** 11,250.00 Budgeted 3,603.55 Remaining 68 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1373 05/23/2014 MUD Payroll 5/23/14 Communications/Pagers/Mobiles 1,934.26 300.00 2,234.26 PR 1406 05/23/2014 May A/P Verizon, Kyocera (48.15) 2,186.11 TOWN OF TROPHY CLUB 33817 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 251.85 2,186.11 ** 4,057.00 Budgeted 1,870.89 Remaining 54 % Used Account: 135-60020-030-000 Electricity/Gas 1380 05/20/2014 May A/P 2/10-5/12/14 Electricity 6,319.18 2,550.37 8,869.55 TOWN OF TROPHY CLUB 33802 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 2,550.37 8,869.55 ** 15,171.00 Budgeted 6,301.45 Remaining 58 % Used Account: 135-60025-030-000 Water 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: 528.02 (91.06) 436.96 AR 1484 05/31/2014 May A/P May Water 182.12 619.08 TROPHY CLUB MUD (WATER BILLS) 33877 AP _______________ Account: 135-60025-030-000 Water Totals: 91.06 619.08 ** 1,500.00 Budgeted 880.92 Remaining 41 % Used Account: 135-60035-030-000 Postage 1484 05/31/2014 May A/P Overnight letter 15,446.73 7.99 15,454.72 FEDERAL EXPRESS CORP 33834 AP 1502 05/31/2014 May A/P Utility billing/insert 1,695.33 17,150.05 DATAPROSE LLC 33829 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,703.32 17,150.05 ** 28,500.00 Budgeted 11,349.95 Remaining 60 % Used Account: 135-60040-030-000 Service Charges & Fees 1469 05/02/2014 Credit Card Fees 17,259.27 64.54 17,323.81 GL 1469 05/02/2014 Credit Card Fees 97.90 17,421.71 GL 1469 05/02/2014 Credit Card Fees 2,545.81 19,967.52 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1379 05/14/2014 April Account analysis FF Bank 17,259.27 250.00 20,217.52 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,958.25 20,217.52 ** 28,330.00 Budgeted 8,112.48 Remaining 71 % Used Account: 135-60050-030-000 Bad Debt Expense 4,153.40 .00 4,153.40 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 4,153.40 ** 6,200.00 Budgeted 2,046.60 Remaining 67 % Used Account: 135-60055-030-000 Insurance 54 05/01/2014 May Ins & W/C Expense 30,016.36 4,269.73 34,286.09 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,269.73 34,286.09 ** 53,561.00 Budgeted 19,274.91 Remaining 64 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 401.08 .00 401.08 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 401.08 ** 1,000.00 Budgeted 598.92 Remaining 40 % Used Account: 135-60070-030-000 Dues & Memberships 4,011.95 .00 4,011.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,011.95 ** 4,500.00 Budgeted 488.05 Remaining 89 % Used Account: 135-60075-030-000 Meetings 1480 05/27/2014 May A/P DOVE CREEK CAFE 27.26 27.26 DOVE CREEK CAFE PC _______________ Account: 135-60075-030-000 Meetings Totals: 27.26 27.26 ** 400.00 Budgeted 372.74 Remaining 7 % Used Account: 135-60079-030-000 Public Education 274.83 .00 274.83 . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60079-030-000 Public Education Totals: .00 274.83 ** 5,000.00 Budgeted 4,725.17 Remaining 5 % Used Account: 135-60080-030-000 Schools & Training 1480 05/27/2014 May A/P CVENT* TCDRS 2,592.30 235.00 2,827.30 CVENT* TCDRS PC 1480 05/27/2014 May A/P BAKER DISTRIBUTING #22 18.29 2,845.59 BAKER DISTRIBUTING #22 PC 1480 05/27/2014 May A/P ROANOKE WINNELSON CO 3.66 2,849.25 ROANOKE WINNELSON CO PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 256.95 2,849.25 ** 6,800.00 Budgeted 3,950.75 Remaining 42 % Used Account: 135-60100-030-000 Travel & per diem 1373 05/23/2014 MUD Payroll 5/23/14 Travel & per diem 1,438.76 41.10 1,479.86 PR 1480 05/27/2014 May A/P CFW PARKING METER 2.25 1,482.11 CFW PARKING METER PC 1480 05/27/2014 May A/P CFW PARKING METER 1.25 1,483.36 CFW PARKING METER PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 44.60 1,483.36 ** 5,000.00 Budgeted 3,516.64 Remaining 30 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 1480 05/27/2014 May A/P RANDALLS STORE00017897 281.76 32.18 313.94 RANDALLS STORE00017897 PC 1484 05/31/2014 May A/P Election 1,535.45 1,849.39 DENTON COUNTY ELECTIONS 33831 AP _______________ Account: 135-60115-030-000 Elections Totals: 1,567.63 1,849.39 ** 2,500.00 Budgeted 650.61 Remaining 74 % Used Account: 135-60125-030-000 Advertising 589.43 .00 589.43 _______________ Account: 135-60125-030-000 Advertising Totals: .00 589.43 ** 2,500.00 Budgeted 1,910.57 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60235-030-000 Security 123.56 .00 123.56 _______________ Account: 135-60235-030-000 Security Totals: .00 123.56 ** 1,350.00 Budgeted 1,226.44 Remaining 9 % Used Account: 135-60245-030-000 Miscellaneous Expenses 376.25 .00 376.25 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 376.25 ** 17,870.00 Budgeted 17,493.75 Remaining 2 % 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,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1480 05/27/2014 May A/P THE HOME DEPOT 6581 78.98 78.98 THE HOME DEPOT 6581 PC 1480 05/27/2014 May A/P PEARCE OFFICE FURNITUR 1,606.00 1,684.98 PEARCE OFFICE FURNITUR PC 1480 05/27/2014 May A/P PEARCE OFFICE FURNITUR 365.00 2,049.98 PEARCE OFFICE FURNITUR PC 1480 05/27/2014 May A/P THE HOME DEPOT 6581 44.48 2,094.46 THE HOME DEPOT 6581 PC 1480 05/27/2014 May A/P HOMEDEPOT.COM 179.00 2,273.46 HOMEDEPOT.COM PC 1484 05/31/2014 May A/P Receptionist chair 290.09 2,563.55 OFFICE DEPOT, INC 33864 AP _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 2,563.55 2,563.55 ** 2,500.00 Budgeted (63.55) Remaining 103 % Used Account: 135-65010-030-000 Uniforms 998.90 .00 998.90 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 998.90 ** 1,390.00 Budgeted 391.10 Remaining 72 % Used Account: 135-65055-030-000 Hardware 1380 05/20/2014 May A/P IT BOA 3/28-4/27/14 2,178.04 10.98 2,189.02 TOWN OF TROPHY CLUB 33802 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65055-030-000 Hardware Totals: 10.98 2,189.02 ** 13,562.00 Budgeted 11,372.98 Remaining 16 % Used Account: 135-65085-030-000 Office Supplies 1362 05/16/2014 May A/P Copy Paper 2,773.09 57.98 2,831.07 OFFICE DEPOT, INC 33795 AP 1362 05/16/2014 May A/P Bags for shredder 21.89 2,852.96 OFFICE DEPOT, INC 33795 AP 1380 05/20/2014 May A/P IT BOA 3/28-4/27/14 8.37 2,861.33 TOWN OF TROPHY CLUB 33802 AP 1405 05/23/2014 May A/P Office supplies 3.89 2,865.22 OFFICE DEPOT, INC 33814 AP 1405 05/23/2014 May A/P Office Supplies 99.85 2,965.07 OFFICE DEPOT, INC 33814 AP 1405 05/23/2014 May A/P Office supplies 10.98 2,976.05 OFFICE DEPOT, INC 33814 AP 1405 05/23/2014 May A/P Office supplies 113.61 3,089.66 OFFICE DEPOT, INC 33814 AP 1481 05/31/2014 Town Billing/May Inv 1170-78 AR 20140501-20140531 User: (57.98) 3,031.68 AR 1484 05/31/2014 May A/P Office supplies 64.62 3,096.30 OFFICE DEPOT, INC 33864 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 323.21 3,096.30 ** 9,100.00 Budgeted 6,003.70 Remaining 34 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2,403.47 .00 2,403.47 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 2,403.47 ** 5,732.00 Budgeted 3,328.53 Remaining 42 % Used Account: 135-65095-030-000 Maintenance Supplies 1480 05/27/2014 May A/P SAMSCLUB #4795 1,618.37 174.79 1,793.16 SAMSCLUB #4795 PC 1480 05/27/2014 May A/P AMAZON.COM 44.20 1,837.36 AMAZON.COM PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 218.99 1,837.36 ** 2,500.00 Budgeted 662.64 Remaining 73 % Used Account: 135-65097-030-000 Vending Machine Supplies 76.96 .00 76.96 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 76.96 ** 200.00 Budgeted 123.04 Remaining 38 % Used Account: 135-65105-030-000 Printing . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,348.27 .00 2,348.27 _______________ Account: 135-65105-030-000 Printing Totals: .00 2,348.27 ** 4,000.00 Budgeted 1,651.73 Remaining 59 % Used Account: 135-69170-030-000 Copier Lease Installments 1406 05/23/2014 May A/P Verizon, Kyocera 1,412.68 128.43 1,541.11 TOWN OF TROPHY CLUB 33817 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 128.43 1,541.11 ** 3,450.00 Budgeted 1,908.89 Remaining 45 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 650,652.48 ** 1,056,620.00 Budgeted 405,967.52 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2014 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 1362 05/16/2014 May A/P Legal 138,438.39 12,460.19 150,898.58 FREEMAN & CORBETT 33782 AP 1362 05/16/2014 May A/P Legal 32,421.90 183,320.48 Fulbright & Jaworski LLP 33783 AP 1362 05/16/2014 May A/P Legal 907.20 184,227.68 WHITAKER CHALK SWINDLE 33806 AP 1362 05/16/2014 May A/P Legal 5,899.38 190,127.06 WHITAKER CHALK SWINDLE 33806 AP 1362 05/16/2014 May A/P Legal 504.00 190,631.06 WHITAKER CHALK SWINDLE 33806 AP 1362 05/16/2014 May A/P Legal 403.20 191,034.26 WHITAKER CHALK SWINDLE 33806 AP 1362 05/16/2014 May A/P Legal 1,019.50 192,053.76 WHITAKER CHALK SWINDLE 33806 AP 1484 05/31/2014 May A/P April Legal 3,217.50 195,271.26 THE LISTON LAW FIRM, P.C. 33874 AP 1498 05/31/2014 May A/P Legal 6,083.79 201,355.05 FREEMAN & CORBETT 33837 AP _______________ Account: 135-55045-039-000 Legal Totals: 62,916.66 201,355.05 ** 347,126.00 Budgeted 145,770.95 Remaining 58 % Used Account: 135-55055-039-000 Auditing 21,200.00 .00 21,200.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 21,200.00 ** 21,840.00 Budgeted 640.00 Remaining 97 % Used Account: 135-55060-039-000 Appraisal 6,243.84 .00 6,243.84 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,243.84 ** 10,000.00 Budgeted 3,756.16 Remaining 62 % Used Account: 135-55065-039-000 Tax Admin Fees 2,451.40 .00 2,451.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,451.40 ** 3,800.00 Budgeted 1,348.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 231,250.29 ** 382,766.00 Budgeted 151,515.71 Remaining 60 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 457,180.97 .00 Budgeted (457,180.97) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 5/2014 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 1467 05/31/2014 Bank Statement Interest/May (55.41) (5.85) (61.26) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (5.85) (61.26) ** .00 Budgeted 61.26 Remaining 0 % Used Account: 507-49036-000-000 GASB Reserves (120,000.00) .00 (120,000.00) _______________ Account: 507-49036-000-000 GASB Reserves Totals: .00 (120,000.00) ** .00 Budgeted 120,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (120,061.26) ** .00 Budgeted 120,061.26 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 5/2014 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-002 Capital Repairs/ROFC FW Meter 82,629.40 .00 82,629.40 _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: .00 82,629.40 ** .00 Budgeted (82,629.40) Remaining 0 % Used Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 3,072.00 .00 3,072.00 _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: .00 3,072.00 ** 282,245.17 Budgeted 279,173.17 Remaining 1 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 85,701.40 ** 282,245.17 Budgeted 196,543.77 Remaining 30 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ (34,359.86) 282,245.17 Budgeted 316,605.03 Remaining -12 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET May 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 509,625 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 13,144 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 527,615 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 13,144 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 13,144 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 496,592 TOTAL FUND BALANCE 514,471 TOTAL LIABILITIES AND FUND BALANCE 527,615 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 08:23 06/11/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 389,216.00- 389,216.00- 1,956.67- 383,992.14- 98.658 5,223.86- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 25.83- 458.92- 18.357 2,041.08- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 149.83- 1,970.55- 123.159 370.55 Subtotal: 393,316.00- 393,316.00- 2,132.33- 386,421.61- 98.247 6,894.39- 533-48005-000-000 Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- Subtotal: 16,525.00- 16,525.00- 16,525.00- 533-49010-000-000 Interest Income 375.00- 375.00- 10.57- 57.98- 15.461 317.02- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- 100.000 Subtotal: 214,654.00- 214,654.00- 10.57- 214,336.98- 99.852 317.02- Program number: 624,495.00- 624,495.00- 2,142.90- 600,758.59- 96.199 23,736.41- Department number: Revenues 624,495.00- 624,495.00- 2,142.90- 600,758.59- 96.199 23,736.41- Revenues Subtotal ----------- 624,495.00- 624,495.00- 2,142.90- 600,758.59- 96.199 23,736.41- . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 08:23 06/11/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 1,000.00 43.478 1,300.00 533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 103,166.25 52.317 94,028.75 533-70035-051-000 Bond Principal Payment 425,000.00 425,000.00 425,000.00 Subtotal: 624,495.00 624,495.00 104,166.25 16.680 520,328.75 Program number: 624,495.00 624,495.00 104,166.25 16.680 520,328.75 Department number: Administration 624,495.00 624,495.00 104,166.25 16.680 520,328.75 Expenditures Subtotal ----------- 624,495.00 624,495.00 104,166.25 16.680 520,328.75 Fund number: 533 MUD 1 I&S Consolidated 2,142.90- 496,592.34- 496,592.34 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2014 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 1416 05/05/2014 Property Taxes/Assessments (382,035.47) (5.98) (382,041.45) GL 1417 05/06/2014 Property Taxes/Assessments (51.09) (382,092.54) GL 1418 05/07/2014 Property Taxes/Assessments (56.03) (382,148.57) GL 1432 05/08/2014 Property Taxes/Assessments (190.37) (382,338.94) GL 1433 05/09/2014 Property Taxes/Assessments (46.58) (382,385.52) GL 1434 05/12/2014 Property Taxes/Assessments (283.88) (382,669.40) GL 1465 05/13/2014 Property Taxes/Assessments (159.99) (382,829.39) GL 1435 05/14/2014 Property Taxes/Assessments (10.12) (382,839.51) GL 1436 05/16/2014 Property Taxes/Assessments (1.51) (382,841.02) GL 1437 05/19/2014 Property Taxes/Assessments (140.06) (382,981.08) GL 1438 05/20/2014 Property Taxes/Assessments (67.66) (383,048.74) GL 1439 05/21/2014 Property Taxes/Assessments (18.37) (383,067.11) GL 1444 05/22/2014 Property Taxes/Assessments (30.77) (383,097.88) GL 1445 05/23/2014 Property Taxes/Assessments (68.54) (383,166.42) GL 1446 05/27/2014 Property Taxes/Assessments (177.61) (383,344.03) GL 1447 05/28/2014 Property Taxes/Assessments (196.60) (383,540.63) GL 1459 05/29/2014 Property Taxes/Assessments (285.46) (383,826.09) GL 1460 05/30/2014 Property Taxes/Assessments (166.05) (383,992.14) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,956.67) (383,992.14) ** (389,216.00) Budgeted (5,223.86) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1434 05/12/2014 Property Taxes/Assessments (433.09) (.11) (433.20) GL 1460 05/30/2014 Property Taxes/Assessments (25.72) (458.92) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (25.83) (458.92) ** (2,500.00) Budgeted (2,041.08) Remaining 18 % Used Account: 533-40015-000-000 Property Taxes/P & I 1416 05/05/2014 Property Taxes/Assessments (1,820.72) (.66) (1,821.38) GL 1418 05/07/2014 Property Taxes/Assessments (.97) (1,822.35) GL 1432 05/08/2014 Property Taxes/Assessments (24.74) (1,847.09) GL 1434 05/12/2014 Property Taxes/Assessments (32.81) (1,879.90) GL 1465 05/13/2014 Property Taxes/Assessments (13.49) (1,893.39) GL 1436 05/16/2014 Property Taxes/Assessments (.18) (1,893.57) GL 1437 05/19/2014 Property Taxes/Assessments (13.23) (1,906.80) GL 1445 05/23/2014 Property Taxes/Assessments (1.34) (1,908.14) GL 1446 05/27/2014 Property Taxes/Assessments (14.68) (1,922.82) GL 1447 05/28/2014 Property Taxes/Assessments (16.40) (1,939.22) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1459 05/29/2014 Property Taxes/Assessments (1,820.72) (8.91) (1,948.13) GL 1460 05/30/2014 Property Taxes/Assessments (22.42) (1,970.55) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (149.83) (1,970.55) ** (1,600.00) Budgeted 370.55 Remaining 123 % 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 ** (16,525.00) Budgeted (16,525.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 1467 05/31/2014 Bank Statement Interest/May (47.41) (10.57) (57.98) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (10.57) (57.98) ** (375.00) Budgeted (317.02) Remaining 15 % Used Account: 533-49015-000-000 Lease/Rental Income (214,279.00) .00 (214,279.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,279.00) ** (214,279.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (600,758.59) ** (624,495.00) Budgeted (23,736.41) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 08:23 06/11/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2014 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/Bond Issuance 1,000.00 .00 1,000.00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 1,000.00 ** 2,300.00 Budgeted 1,300.00 Remaining 43 % Used Account: 533-70025-051-000 Bond Interest Expense 103,166.25 .00 103,166.25 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 103,166.25 ** 197,195.00 Budgeted 94,028.75 Remaining 52 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 425,000.00 Budgeted 425,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 104,166.25 ** 624,495.00 Budgeted 520,328.75 Remaining 17 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (496,592.34) .00 Budgeted 496,592.34 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (427,368.16) **** 282,245.17 Budgeted 709,613.33 Remaining ########## ******* End of Report *********