Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
May Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MAY 31, 2013 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 811,359 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 22,028 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 9,449 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,100 TOTAL ASSETS 844,936 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 31,477 ACCOUNTS AND OTHER PAYABLES 2,421 TOTAL LIABILITIES 33,898 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - UNASSIGNED FUND BALANCE 350,496 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 460,543 TOTAL FUND BALANCE 811,039 TOTAL LIABILITIES AND FUND BALANCE 844,936 TCMUD#1 Page 119 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 20:09 06/12/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 252,084.00- 252,084.00- 959.26- 254,078.19- 100.791 1,994.19 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 700.00- 60.85- 66.21- 9.459 633.79- 122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 5,848.50- 1,050,167.25- 99.983 181.75- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 71.66- 3,867.71 -66.685 9,667.71- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 118.15- 631.36- 84.181 118.64- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 505.79- 3,636.56- 80.812 863.44- Subtotal: 1,318,183.00- 1,314,183.00- 7,564.21- 1,304,711.86- 99.279 9,471.14- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 800.00- 4,400.00- 73.333 1,600.00- Subtotal: 6,000.00- 6,000.00- 800.00- 4,400.00- 73.333 1,600.00- 122-43400-000-000 Fire Inspections 500.00- 675.00- 225.00- 900.00- 133.333 225.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,500.00- 10,675.00- 225.00- 10,900.00- 102.108 225.00 122-49035-000-000 Prior Year Reserves 5,413.00- 5,413.00- 122-49900-000-000 Miscellaneous Income 1,200.00- 5,200.00- 1,150.00- 6,389.26- 122.870 1,189.26 122-49903-000-000 Recovery of Prior Year Expense 4,340.96- 4,340.96- 4,340.96 Subtotal: 1,200.00- 10,613.00- 5,490.96- 10,730.22- 101.104 117.22 Program number: 1,335,883.00- 1,341,471.00- 14,080.17- 1,330,742.08- 99.200 10,728.92- Department number: Fire Revenues 1,335,883.00- 1,341,471.00- 14,080.17- 1,330,742.08- 99.200 10,728.92- Revenues Subtotal ----------- 1,335,883.00- 1,341,471.00- 14,080.17- 1,330,742.08- 99.200 10,728.92- TCMUD#1 Page 120 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 20:09 06/12/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 444,717.00 444,717.00 33,477.30 276,846.76 62.252 167,870.24 122-50010-045-000 Overtime 31,375.00 37,076.00 4,404.37 27,046.54 72.949 10,029.46 122-50011-045-000 DPS Holiday Pay 13,083.00 12,083.00 12,080.51 99.979 2.49 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.11 100.003 .11- 122-50017-045-000 Certification 4,896.00 6,024.00 314.25 3,642.34 60.464 2,381.66 122-50020-045-000 Retirement 69,242.00 69,242.00 5,265.27 45,959.74 66.376 23,282.26 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,504.08 27,671.09 57.258 20,655.91 122-50027-045-000 Dental Insurance 3,635.00 3,836.00 322.95 2,563.77 66.834 1,272.23 122-50028-045-000 Vision Insurance 824.00 824.00 66.68 528.24 64.107 295.76 122-50029-045-000 Life Insurance & Other 4,250.00 5,974.00 505.74 4,089.69 68.458 1,884.31 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,180.03 19,289.29 62.431 11,607.71 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 509.82 4,511.15 62.429 2,714.85 122-50040-045-000 Unemployment Taxes 1,481.00 1,980.00 1,847.11- 132.95 6.715 1,847.05 122-50045-045-000 Workman's Compensation 10,000.00 10,000.00 274.65 10,274.65 102.747 274.65- 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 283.05 41.933 391.95 122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 Subtotal: 676,394.00 684,647.00 48,978.03 439,185.88 64.148 245,461.12 122-55045-045-000 Legal 5,000.00 2,007.40 40.148 2,992.60 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 2,058.75 6,763.00 70.728 2,799.00 122-55090-045-000 Vehicle Maintenance 14,850.00 14,600.00 148.56 2,450.54 16.785 12,149.46 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 6,518.15 66.457 3,289.85 122-55100-045-000 Building Maintenance 6,500.00 5,500.00 1,028.68 3,207.01 58.309 2,292.99 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 45.80 451.30 40.916 651.70 122-55160-045-000 Professional Outside Services 2,500.00 Subtotal: 44,323.00 45,573.00 3,281.79 21,397.40 46.952 24,175.60 122-60005-045-000 Telephone 106.00 106.00 12.26 49.78 46.962 56.22 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 3,500.00 214.79 2,866.08 81.888 633.92 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 501.98 4,687.81 76.014 1,479.19 122-60025-045-000 Water 1,400.00 1,400.00 330.80 1,025.67 73.262 374.33 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 100.00 100.00 41.20 41.200 58.80 122-60055-045-000 Insurance 10,000.00 10,000.00 10,000.00 100.000 122-60066-045-000 Publications/Books/Subscrips 410.00 410.00 410.00 122-60070-045-000 Dues & Memberships 7,500.00 8,000.00 7,955.91 99.449 44.09 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 391.50- 2,612.50 52.250 2,387.50 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 4,800.00 4,800.00 974.24 2,789.19 58.108 2,010.81 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 150.00 150.00 122.35 81.567 27.65 TCMUD#1 Page 121 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 20:09 06/12/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60160-045-000 Programs & Special Projects 4,200.00 4,200.00 27.76 2,415.66 57.516 1,784.34 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 2,150.00 211.55 990.52 46.071 1,159.48 122-60195-045-000 Flags & Repair 2,543.00 2,293.00 422.50 1,082.25 47.198 1,210.75 122-60243-045-000 Prior Year Expense 2,088.00 2,088.44 100.021 .44- 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 24.88 584.51 47.252 652.49 Subtotal: 359,088.00 362,676.00 2,329.26 348,311.87 96.039 14,364.13 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 4,364.58 43.646 5,635.42 122-65010-045-000 Uniforms 4,357.00 3,357.00 824.00 1,739.32 51.812 1,617.68 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 5,405.00 6,405.00 84.276 1,195.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 402.00 40.200 598.00 122-65035-045-000 Small Tools 5,000.00 2,400.00 52.15 1,618.13 67.422 781.87 122-65085-045-000 Office Supplies 1,200.00 1,200.00 130.97 306.61 25.551 893.39 122-65095-045-000 Maintenance Supplies 2,785.00 1,988.00 91.97 1,259.35 63.348 728.65 122-65105-045-000 Printing 106.00 Subtotal: 32,048.00 27,545.00 6,504.09 16,094.99 58.432 11,450.01 122-69006-045-000 Grant Match 3,000.00 122-69008-045-000 Short Term Debt-Principal 72,932.00 72,932.00 2,966.05 4.067 69,965.95 122-69050-045-000 Radios 2,500.00 2,500.00 353.13 14.125 2,146.87 122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 41,890.00 41,890.00 28.771 103,708.00 Subtotal: 224,030.00 221,030.00 41,890.00 45,209.18 20.454 175,820.82 Program number: 1,335,883.00 1,341,471.00 102,983.17 870,199.32 64.869 471,271.68 Department number: Fire 1,335,883.00 1,341,471.00 102,983.17 870,199.32 64.869 471,271.68 Expenditures Subtotal ----------- 1,335,883.00 1,341,471.00 102,983.17 870,199.32 64.869 471,271.68 Fund number: 122 Trophy Club MUD Fire Dept. 88,903.00 460,542.76- 460,542.76 TCMUD#1 Page 122 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2013 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 1592 05/06/2013 Property Taxes/Assessments (253,118.93) (165.47) (253,284.40) GL 1593 05/07/2013 Property Taxes/Assessments (174.83) (253,459.23) GL 1594 05/08/2013 Property Taxes/Assessments 44.08 (253,415.15) GL 1597 05/13/2013 Property Taxes/Assessments (19.39) (253,434.54) GL 1598 05/14/2013 Property Taxes/Assessments (25.85) (253,460.39) GL 1599 05/15/2013 Property Taxes/Assessments (201.11) (253,661.50) GL 1602 05/20/2013 Property Taxes/Assessments (35.01) (253,696.51) GL 1607 05/28/2013 Property Taxes/Assessments (381.67) (254,078.18) GL 1609 05/30/2013 Property Taxes/Assessments (.01) (254,078.19) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (959.26) (254,078.19) ** (252,084.00) Budgeted 1,994.19 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1597 05/13/2013 Property Taxes/Assessments (5.36) (60.85) (66.21) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (60.85) (66.21) ** (700.00) Budgeted (633.79) Remaining 9 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1589 05/01/2013 Property Taxes/Assessments (1,044,318.75) (334.88) (1,044,653.63) GL 1590 05/02/2013 Property Taxes/Assessments (57.15) (1,044,710.78) GL 1591 05/03/2013 Property Taxes/Assessments (39.99) (1,044,750.77) GL 1592 05/06/2013 Property Taxes/Assessments (120.19) (1,044,870.96) GL 1593 05/07/2013 Property Taxes/Assessments (420.40) (1,045,291.36) GL 1594 05/08/2013 Property Taxes/Assessments (19.45) (1,045,310.81) GL 1595 05/09/2013 Property Taxes/Assessments (5.84) (1,045,316.65) GL 1596 05/10/2013 Property Taxes/Assessments (73.13) (1,045,389.78) GL 1446 05/13/2013 May A/P MUD 1 Tax shortage due to an o (1,675.66) (1,047,065.44) DENTON COUNTY TAX OFFICE 32531 AP 1599 05/15/2013 Property Taxes/Assessments (41.60) (1,047,107.04) GL 1600 05/16/2013 Property Taxes/Assessments (278.51) (1,047,385.55) GL 1601 05/17/2013 Property Taxes/Assessments (735.19) (1,048,120.74) GL 1602 05/20/2013 Property Taxes/Assessments (440.36) (1,048,561.10) GL 1603 05/21/2013 Property Taxes/Assessments (117.64) (1,048,678.74) GL 1604 05/22/2013 Property Taxes/Assessments (305.31) (1,048,984.05) GL 1605 05/23/2013 Property Taxes/Assessments (209.10) (1,049,193.15) GL 1606 05/24/2013 Property Taxes/Assessments (444.59) (1,049,637.74) GL 1607 05/28/2013 Property Taxes/Assessments (1,265.52) (1,050,903.26) GL 1608 05/29/2013 Property Taxes/Assessments (506.41) (1,051,409.67) GL 1609 05/30/2013 Property Taxes/Assessments (142.15) (1,051,551.82) GL TCMUD#1 Page 123 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1610 05/31/2013 Property Taxes/Assessments (1,044,318.75) (317.09) (1,051,868.91) GL 1678 05/31/2013 Overpmt tax refund 1,675.66 (1,050,193.25) GL 1689 05/31/2013 Correct JE1360/April 2013 26.00 (1,050,167.25) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (5,848.50) (1,050,167.25) ** (1,050,349.00) Budgeted (181.75) Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1590 05/02/2013 Property Taxes/Assessments 3,939.37 (42.59) 3,896.78 GL 1446 05/13/2013 May A/P MUD 1 Tax shortage due to an o 7,769.42 11,666.20 DENTON COUNTY TAX OFFICE 32531 AP 1604 05/22/2013 Property Taxes/Assessments (23.48) 11,642.72 GL 1609 05/30/2013 Property Taxes/Assessments (5.59) 11,637.13 GL 1678 05/31/2013 Overpmt tax refund (7,769.42) 3,867.71 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (71.66) 3,867.71 ** (5,800.00) Budgeted (9,667.71) Remaining -67 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1592 05/06/2013 Property Taxes/Assessments (513.21) (21.51) (534.72) GL 1597 05/13/2013 Property Taxes/Assessments (21.77) (556.49) GL 1598 05/14/2013 Property Taxes/Assessments (3.36) (559.85) GL 1599 05/15/2013 Property Taxes/Assessments (26.14) (585.99) GL 1602 05/20/2013 Property Taxes/Assessments (4.55) (590.54) GL 1607 05/28/2013 Property Taxes/Assessments (40.82) (631.36) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (118.15) (631.36) ** (750.00) Budgeted (118.64) Remaining 84 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1589 05/01/2013 Property Taxes/Assessments (3,130.77) (36.85) (3,167.62) GL 1590 05/02/2013 Property Taxes/Assessments (25.61) (3,193.23) GL 1593 05/07/2013 Property Taxes/Assessments (26.77) (3,220.00) GL 1446 05/13/2013 May A/P MUD 1 Tax shortage due to an o (202.96) (3,422.96) DENTON COUNTY TAX OFFICE 32531 AP 1599 05/15/2013 Property Taxes/Assessments (5.41) (3,428.37) GL 1600 05/16/2013 Property Taxes/Assessments (13.00) (3,441.37) GL 1601 05/17/2013 Property Taxes/Assessments (76.49) (3,517.86) GL 1602 05/20/2013 Property Taxes/Assessments (44.96) (3,562.82) GL 1604 05/22/2013 Property Taxes/Assessments (33.41) (3,596.23) GL 1606 05/24/2013 Property Taxes/Assessments (43.95) (3,640.18) GL 1607 05/28/2013 Property Taxes/Assessments (153.26) (3,793.44) GL TCMUD#1 Page 124 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1608 05/29/2013 Property Taxes/Assessments (3,130.77) (27.37) (3,820.81) GL 1609 05/30/2013 Property Taxes/Assessments (1.81) (3,822.62) GL 1610 05/31/2013 Property Taxes/Assessments (16.90) (3,839.52) GL 1678 05/31/2013 Overpmt tax refund 202.96 (3,636.56) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (505.79) (3,636.56) ** (4,500.00) Budgeted (863.44) Remaining 81 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1656 05/31/2013 Town Invoice 1036-38 AR 20130531-20130531 User: (3,600.00) (800.00) (4,400.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (800.00) (4,400.00) ** (6,000.00) Budgeted (1,600.00) Remaining 73 % Used Account: 122-43400-000-000 Fire Inspections 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (675.00) (75.00) (750.00) AR 1656 05/31/2013 Town Invoice 1036-38 AR 20130531-20130531 User: (150.00) (900.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (225.00) (900.00) ** (675.00) Budgeted 225.00 Remaining 133 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (5,413.00) Budgeted (5,413.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1656 05/31/2013 Town Invoice 1036-38 AR 20130531-20130531 User: (5,239.26) (1,150.00) (6,389.26) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,150.00) (6,389.26) ** (5,200.00) Budgeted 1,189.26 Remaining 123 % Used TCMUD#1 Page 125 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-49903-000-000 Recovery of Prior Year Expense 1451 05/01/2013 Correct P/Y Due to Town/Medica True up 9/30/10 PPD Insurance (4,340.96) (4,340.96) GL _______________ Account: 122-49903-000-000 Recovery of Prior Year Expense Totals: (4,340.96) (4,340.96) ** .00 Budgeted 4,340.96 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,330,742.08) ** (1,341,471.00) Budgeted (10,728.92) Remaining 99 % Used TCMUD#1 Page 126 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 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 1428 05/10/2013 FD Payroll 5/10/13 243,369.46 16,801.91 260,171.37 GL 1532 05/24/2013 FD Payroll 5/24/13 16,675.39 276,846.76 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 33,477.30 276,846.76 ** 444,717.00 Budgeted 167,870.24 Remaining 62 % Used Account: 122-50010-045-000 Overtime 1428 05/10/2013 FD Payroll 5/10/13 22,642.17 4,404.37 27,046.54 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,404.37 27,046.54 ** 37,076.00 Budgeted 10,029.46 Remaining 73 % Used Account: 122-50011-045-000 DPS Holiday Pay 12,080.51 .00 12,080.51 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 12,080.51 ** 12,083.00 Budgeted 2.49 Remaining 100 % Used Account: 122-50016-045-000 Longevity 4,266.11 .00 4,266.11 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,266.11 ** 4,266.00 Budgeted (.11) Remaining 100 % Used Account: 122-50017-045-000 Certification 1428 05/10/2013 FD Payroll 5/10/13 3,328.09 314.25 3,642.34 GL _______________ Account: 122-50017-045-000 Certification Totals: 314.25 3,642.34 ** 6,024.00 Budgeted 2,381.66 Remaining 60 % Used Account: 122-50020-045-000 Retirement 1428 05/10/2013 FD Payroll 5/10/13 40,694.47 2,986.92 43,681.39 GL 1532 05/24/2013 FD Payroll 5/24/13 2,278.35 45,959.74 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,265.27 45,959.74 ** 69,242.00 Budgeted 23,282.26 Remaining 66 % Used TCMUD#1 Page 127 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 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 1428 05/10/2013 FD Payroll 5/10/13 24,167.01 1,752.02 25,919.03 GL 1532 05/24/2013 FD Payroll 5/24/13 1,752.06 27,671.09 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,504.08 27,671.09 ** 48,327.00 Budgeted 20,655.91 Remaining 57 % Used Account: 122-50027-045-000 Dental Insurance 1428 05/10/2013 FD Payroll 5/10/13 2,240.82 161.47 2,402.29 GL 1532 05/24/2013 FD Payroll 5/24/13 161.48 2,563.77 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 322.95 2,563.77 ** 3,836.00 Budgeted 1,272.23 Remaining 67 % Used Account: 122-50028-045-000 Vision Insurance 1428 05/10/2013 FD Payroll 5/10/13 461.56 33.36 494.92 GL 1532 05/24/2013 FD Payroll 5/24/13 33.32 528.24 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 66.68 528.24 ** 824.00 Budgeted 295.76 Remaining 64 % Used Account: 122-50029-045-000 Life Insurance & Other 1428 05/10/2013 FD Payroll 5/10/13 3,583.95 298.64 3,882.59 GL 1532 05/24/2013 FD Payroll 5/24/13 207.10 4,089.69 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 505.74 4,089.69 ** 5,974.00 Budgeted 1,884.31 Remaining 68 % Used Account: 122-50030-045-000 Social Security Taxes 1428 05/10/2013 FD Payroll 5/10/13 17,109.26 1,240.21 18,349.47 GL 1532 05/24/2013 FD Payroll 5/24/13 939.82 19,289.29 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,180.03 19,289.29 ** 30,897.00 Budgeted 11,607.71 Remaining 62 % Used Account: 122-50035-045-000 Medicare Taxes 1428 05/10/2013 FD Payroll 5/10/13 4,001.33 290.03 4,291.36 GL 1532 05/24/2013 FD Payroll 5/24/13 219.79 4,511.15 GL TCMUD#1 Page 128 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 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: 509.82 4,511.15 ** 7,226.00 Budgeted 2,714.85 Remaining 62 % Used Account: 122-50040-045-000 Unemployment Taxes 1428 05/10/2013 FD Payroll 5/10/13 1,980.06 .28 1,980.34 GL 1485 05/17/2013 1st Qtr Town TWC Correction (1,847.86) 132.48 GL 1532 05/24/2013 FD Payroll 5/24/13 .47 132.95 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: (1,847.11) 132.95 ** 1,980.00 Budgeted 1,847.05 Remaining 7 % Used Account: 122-50045-045-000 Workman's Compensation 1495 05/14/2013 Town Bill-W/C Audit Refnd 2012 10,000.00 274.65 10,274.65 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 274.65 10,274.65 ** 10,000.00 Budgeted (274.65) Remaining 103 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 283.05 .00 283.05 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 283.05 ** 675.00 Budgeted 391.95 Remaining 42 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55045-045-000 Legal 2,007.40 .00 2,007.40 _______________ Account: 122-55045-045-000 Legal Totals: .00 2,007.40 ** 5,000.00 Budgeted 2,992.60 Remaining 40 % Used Account: 122-55080-045-000 Maintenance & Repairs TCMUD#1 Page 129 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1447 05/13/2013 May A/P annaul hose testing 4,704.25 1,163.75 5,868.00 WATERWAY NORTH TEXAS INC 32574 AP 1525 05/22/2013 May A/P Holmatro base system-Preventat 895.00 6,763.00 METRO FIRE APPARATUS 32607 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 2,058.75 6,763.00 ** 9,562.00 Budgeted 2,799.00 Remaining 71 % Used Account: 122-55090-045-000 Vehicle Maintenance 1447 05/13/2013 May A/P vehicle maint 2,301.98 34.32 2,336.30 SIDDONS-MARTIN EMERGENCY GROUP 32559 AP 1644 05/26/2013 4/27-5/26 PCards INLAND TRUCK PARTS #22 79.07 2,415.37 INLAND TRUCK PARTS #22 PC 1644 05/26/2013 4/27-5/26 PCards AUTOZONE #4206 20.67 2,436.04 AUTOZONE #4206 PC 1644 05/26/2013 4/27-5/26 PCards KWIK KAR OF ROANOKE 14.50 2,450.54 KWIK KAR OF ROANOKE PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 148.56 2,450.54 ** 14,600.00 Budgeted 12,149.46 Remaining 17 % Used Account: 122-55095-045-000 Equipment Maintenance 6,518.15 .00 6,518.15 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 6,518.15 ** 9,808.00 Budgeted 3,289.85 Remaining 66 % Used Account: 122-55100-045-000 Building Maintenance 1496 05/09/2013 Firefighter's May Cable 2,178.33 (120.00) 2,058.33 GL 1447 05/13/2013 May A/P rug service 24.51 2,082.84 G & K SERVICES 32536 AP 1447 05/13/2013 May A/P rug service 24.51 2,107.35 G & K SERVICES 32536 AP 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (24.51) 2,082.84 AR 1525 05/22/2013 May A/P Quarterly pest control 140.00 2,222.84 GANN'S PEST CONTROL 32601 AP 1525 05/22/2013 May A/P Rug Services 24.51 2,247.35 G & K SERVICES 32600 AP 1525 05/22/2013 May A/P Rug Services 24.51 2,271.86 G & K SERVICES 32600 AP 1553 05/24/2013 Bill Town Inv 1032-1035 AR 20130524-20130524 User: (24.51) 2,247.35 AR 1644 05/26/2013 4/27-5/26 PCards ATT*BILL PAYMENT 133.68 2,381.03 ATT*BILL PAYMENT PC 1644 05/26/2013 4/27-5/26 PCards ATT*BILL PAYMENT 157.83 2,538.86 ATT*BILL PAYMENT PC 1644 05/26/2013 4/27-5/26 PCards SPLIT - 12255100045 (17.38%) 10.97 2,549.83 THE HOME DEPOT 6581 PC 1644 05/26/2013 4/27-5/26 PCards NOR*NORTHERN TOOL 277.18 2,827.01 NOR*NORTHERN TOOL PC 1577 05/31/2013 May A/P Alarm System Repair and Progra 380.00 3,207.01 DSS FIRE INC 32627 AP _______________ Account: 122-55100-045-000 Building Maintenance Totals: 1,028.68 3,207.01 ** 5,500.00 Budgeted 2,292.99 Remaining 58 % Used Account: 122-55110-045-000 Maintenance-Radios TCMUD#1 Page 130 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1644 05/26/2013 4/27-5/26 PCards JOHN DEERE LANDSCAPES1 405.50 45.80 451.30 JOHN DEERE LANDSCAPES1 PC _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: 45.80 451.30 ** 1,103.00 Budgeted 651.70 Remaining 41 % Used Account: 122-60005-045-000 Telephone 1447 05/13/2013 May A/P april pcard reimbursement-mike 37.52 7.77 45.29 TOWN OF TROPHY CLUB 32569 AP 1673 05/31/2013 May A/P IT May PCards 4.49 49.78 TROPHY CLUB MUD (WATER BILLS) 32687 AP _______________ Account: 122-60005-045-000 Telephone Totals: 12.26 49.78 ** 106.00 Budgeted 56.22 Remaining 47 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1428 05/10/2013 FD Payroll 5/10/13 2,651.29 75.42 2,726.71 GL 1525 05/22/2013 May A/P Verizon Inv#9703714888 139.37 2,866.08 TOWN OF TROPHY CLUB 32615 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 214.79 2,866.08 ** 3,500.00 Budgeted 633.92 Remaining 82 % Used Account: 122-60020-045-000 Electricity/Gas 1525 05/22/2013 May A/P Electricity 4/15-5/14 4,185.83 914.63 5,100.46 HUDSON ENERGY SERVICES, LLC 32602 AP 1528 05/22/2013 May A/P Gas Fire Station 4/12-5/13 89.31 5,189.77 ATMOS ENERGY 32593 AP 1553 05/24/2013 Bill Town Inv 1032-1035 AR 20130524-20130524 User: (501.96) 4,687.81 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 501.98 4,687.81 ** 6,167.00 Budgeted 1,479.19 Remaining 76 % Used Account: 122-60025-045-000 Water 1447 05/13/2013 May A/P april water 694.87 201.63 896.50 TROPHY CLUB MUD (WATER BILLS) 32571 AP 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (100.81) 795.69 AR 1679 05/31/2013 May A/P May water bills 162.12 957.81 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1679 05/31/2013 May A/P May water bills 67.86 1,025.67 TROPHY CLUB MUD (WATER BILLS) 32687 AP _______________ Account: 122-60025-045-000 Water Totals: 330.80 1,025.67 ** 1,400.00 Budgeted 374.33 Remaining 73 % Used Account: 122-60030-045-000 Rent And/Or Usage 308,000.00 .00 308,000.00 TCMUD#1 Page 131 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 41.20 .00 41.20 _______________ Account: 122-60035-045-000 Postage Totals: .00 41.20 ** 100.00 Budgeted 58.80 Remaining 41 % Used Account: 122-60055-045-000 Insurance 10,000.00 .00 10,000.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 410.00 Budgeted 410.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 7,955.91 .00 7,955.91 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 7,955.91 ** 8,000.00 Budgeted 44.09 Remaining 99 % Used Account: 122-60075-045-000 Meetings .00 .00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 .00 ** 75.00 Budgeted 75.00 Remaining 0 % Used Account: 122-60080-045-000 Schools & Training 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: 3,004.00 (680.00) 2,324.00 AR 1644 05/26/2013 4/27-5/26 PCards CLASSEN BUCK-SEMINARS 38.50 2,362.50 CLASSEN BUCK-SEMINARS PC TCMUD#1 Page 132 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1574 05/30/2013 May A/P training-S. Garrett 3,004.00 250.00 2,612.50 TARRANT COUNTY COLLEGE 32633 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: (391.50) 2,612.50 ** 5,000.00 Budgeted 2,387.50 Remaining 52 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 1644 05/26/2013 4/27-5/26 PCards CROWNE PLAZA HOTELS 1,814.95 865.80 2,680.75 CROWNE PLAZA HOTELS PC 1644 05/26/2013 4/27-5/26 PCards CROWNE PLAZA HOTELS 12.04 2,692.79 CROWNE PLAZA HOTELS PC 1644 05/26/2013 4/27-5/26 PCards WEBER GRILL RESTAURANT 24.62 2,717.41 WEBER GRILL RESTAURANT PC 1644 05/26/2013 4/27-5/26 PCards CROWNE PLAZA HOTELS 12.33 2,729.74 CROWNE PLAZA HOTELS PC 1644 05/26/2013 4/27-5/26 PCards WOLFGANG PUCK 20268314 14.16 2,743.90 WOLFGANG PUCK 20268314 PC 1644 05/26/2013 4/27-5/26 PCards DICKS LAST RESORT 19.45 2,763.35 DICKS LAST RESORT PC 1644 05/26/2013 4/27-5/26 PCards CROWNE PLAZA HOTELS 11.04 2,774.39 CROWNE PLAZA HOTELS PC 1644 05/26/2013 4/27-5/26 PCards CLADDAGH IRISH PUB 1 14.80 2,789.19 CLADDAGH IRISH PUB 1 PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 974.24 2,789.19 ** 4,800.00 Budgeted 2,010.81 Remaining 58 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 122.35 .00 122.35 _______________ Account: 122-60125-045-000 Advertising Totals: .00 122.35 ** 150.00 Budgeted 27.65 Remaining 82 % Used Account: 122-60160-045-000 Programs & Special Projects 1644 05/26/2013 4/27-5/26 PCards WAL-MART #5247 2,387.90 27.76 2,415.66 WAL-MART #5247 PC TCMUD#1 Page 133 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 27.76 2,415.66 ** 4,200.00 Budgeted 1,784.34 Remaining 58 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 1644 05/26/2013 4/27-5/26 PCards TEXAS OURDOORS 778.97 211.55 990.52 TEXAS OURDOORS PC _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 211.55 990.52 ** 2,150.00 Budgeted 1,159.48 Remaining 46 % Used Account: 122-60195-045-000 Flags & Repair 1447 05/13/2013 May A/P Symonds invoice #6318 659.75 422.50 1,082.25 TOWN OF TROPHY CLUB 32569 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 422.50 1,082.25 ** 2,293.00 Budgeted 1,210.75 Remaining 47 % Used Account: 122-60243-045-000 Prior Year Expense 2,088.44 .00 2,088.44 _______________ Account: 122-60243-045-000 Prior Year Expense Totals: .00 2,088.44 ** 2,088.00 Budgeted (.44) Remaining 100 % Used Account: 122-60245-045-000 Miscellaneous Expense 1644 05/26/2013 4/27-5/26 PCards WAL-MART #5247 559.63 24.88 584.51 WAL-MART #5247 PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 24.88 584.51 ** 1,237.00 Budgeted 652.49 Remaining 47 % Used Account: 122-65005-045-000 Fuel & Lube 4,364.58 .00 4,364.58 _______________ Account: 122-65005-045-000 Fuel & Lube Totals: .00 4,364.58 ** 10,000.00 Budgeted 5,635.42 Remaining 44 % Used Account: 122-65010-045-000 Uniforms 1525 05/22/2013 May A/P Uniform-T shirts 915.32 824.00 1,739.32 ALL STAR SCREEN PRINTING & TEE 32592 AP TCMUD#1 Page 134 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65010-045-000 Uniforms Totals: 824.00 1,739.32 ** 3,357.00 Budgeted 1,617.68 Remaining 52 % Used Account: 122-65015-045-000 Protective Clothing 1447 05/13/2013 May A/P bunker gear 1,000.00 5,405.00 6,405.00 CASCO INDUSTRIES INC 32523 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 5,405.00 6,405.00 ** 7,600.00 Budgeted 1,195.00 Remaining 84 % Used Account: 122-65030-045-000 Chemicals 402.00 .00 402.00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 402.00 ** 1,000.00 Budgeted 598.00 Remaining 40 % Used Account: 122-65035-045-000 Small Tools 1644 05/26/2013 4/27-5/26 PCards SPLIT - 12265035045 (82.62%) 1,565.98 52.15 1,618.13 THE HOME DEPOT 6581 PC _______________ Account: 122-65035-045-000 Small Tools Totals: 52.15 1,618.13 ** 2,400.00 Budgeted 781.87 Remaining 67 % Used Account: 122-65085-045-000 Office Supplies 1525 05/22/2013 May A/P Paper 175.64 36.12 211.76 OFFICE DEPOT, INC 32609 AP 1528 05/22/2013 May A/P Office and maintenance supplie 48.67 260.43 OFFICE DEPOT, INC 32609 AP 1644 05/26/2013 4/27-5/26 PCards AMAZON.COM 25.28 285.71 AMAZON.COM PC 1577 05/31/2013 May A/P Office supplies 20.90 306.61 OFFICE DEPOT, INC 32630 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 130.97 306.61 ** 1,200.00 Budgeted 893.39 Remaining 26 % Used Account: 122-65095-045-000 Maintenance Supplies 1644 05/26/2013 4/27-5/26 PCards SPLIT -12265095045 (35.34%) 1,167.38 91.97 1,259.35 SAMSCLUB #4795 PC _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 91.97 1,259.35 ** 1,988.00 Budgeted 728.65 Remaining 63 % Used Account: 122-69008-045-000 Short Term Debt-Principal TCMUD#1 Page 135 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,966.05 .00 2,966.05 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 2,966.05 ** 72,932.00 Budgeted 69,965.95 Remaining 4 % Used Account: 122-69050-045-000 Radios 353.13 .00 353.13 _______________ Account: 122-69050-045-000 Radios Totals: .00 353.13 ** 2,500.00 Budgeted 2,146.87 Remaining 14 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 1588 05/31/2013 Transfer GASB 34 Replacement Ladder truck 41,890.00 41,890.00 GL _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 41,890.00 41,890.00 ** 145,598.00 Budgeted 103,708.00 Remaining 29 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 870,199.32 ** 1,341,471.00 Budgeted 471,271.68 Remaining 65 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (460,542.76) .00 Budgeted 460,542.76 Remaining 0 % Used TCMUD#1 Page 136 of 294 Meeting Date: June 18, 2013 TROPHY CLUB MUD #1 - O&M BALANCE SHEET MAY 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 5/31/13 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 524,575 - - 524,575 INVESTMENTS 2,148,673 313,050 395,806 2,857,529 PREPAID EXPENSES 20,960 - - 20,960 ADVALOREM PROPERTY TAXES RECEIVABLE 2,610 - - 2,610 UTILITY AND OTHER ACCOUNTS RECEIVABLE 726,690 - - 726,690 - TOTAL ASSETS 3,424,108 313,050 395,806 4,132,964 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,610 - - 2,610 ACCOUNTS AND OTHER PAYABLES 405,144 - 27,163 432,307 CUSTOMER DEPOSITS 226,997 - - 226,997 - TOTAL LIABILITIES 634,751 - 27,163 661,914 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 214,249 214,249 ASSIGNED FUND BALANCE 456,156 456,156 UNASSIGNED FUND BALANCE 2,825,965 - 38,101 2,864,066 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (492,764) 98,801 330,541 (63,422) - TOTAL FUND BALANCE 2,789,357 313,050 368,642 3,471,049 - TOTAL LIABILITIES AND FUND BALANCE 3,424,108 313,050 395,806 4,132,964 TCMUD#1 Page 137 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,884.00- 99,884.00- 558.64- 99,866.84- 99.983 17.16- 135-40002-000-000 Property Taxes/Delinquent 500.00- 624.00- 10.81- 371.18 -59.484 995.18- 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 61.41- 757.31- 63.109 442.69- Subtotal: 101,584.00- 101,708.00- 630.86- 100,252.97- 98.569 1,455.03- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 286,994.44- 1,780,177.71- 50.208 1,765,431.29- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 163,652.63- 1,109,990.19- 67.120 543,756.81- 135-47020-000-000 Standby 576.00- 576.00- 149.90- 26.024 426.10- 135-47025-000-000 Penalties 64,580.00- 64,580.00- 4,783.29- 34,218.44- 52.986 30,361.56- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 884.88- 8,132.82- 69.960 3,492.18- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 200.00- 700.00- 38.889 1,100.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 600.00- 2,550.00- 49.038 2,650.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 8,197.94- 20,776.09- 26.782 56,798.91- Subtotal: 5,360,712.00- 5,360,712.00- 465,313.18- 2,956,695.15- 55.155 2,404,016.85- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 163,300.00- 347,300.00- 53.929 296,700.00- Subtotal: 644,000.00- 644,000.00- 163,300.00- 347,300.00- 53.929 296,700.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 272.09- 3,384.10- 61.529 2,115.90- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 7,220.71- 71.042 2,943.29- 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- 269.15- 317.46- 90.703 32.54- 135-49035-000-000 Prior Year Reserves 305,748.00- 234,014.00- 234,014.00- 135-49075-000-000 Oversize Meter Reimbursement 73,000.00- 73,000.00- 24,092.00- 54,635.69- 74.843 18,364.31- 135-49141-000-000 Interfund Trans In (Cap Proj) 38,101.00- 38,101.42- 100.001 .42 135-49900-000-000 Miscellaneous Income 1,000.00- 13,213.00- 101.44- 14,847.88- 112.373 1,634.88 135-49901-000-000 Records Management Revenue 109.00- 77.70 31.30- 28.716 77.70- 135-49903-000-000 Recovery of Prior Year Expense 9,671.83- 11,789.33- 11,789.33 135-49905-000-000 Gas Well Revenue 200.00- 286.00- 545.71- 190.808 259.71 Subtotal: 402,962.00- 381,737.00- 35,822.67- 135,540.24- 35.506 246,196.76- Program number: 6,509,258.00- 6,488,157.00- 665,066.71- 3,539,788.36- 54.558 2,948,368.64- Department number: Revenues 6,509,258.00- 6,488,157.00- 665,066.71- 3,539,788.36- 54.558 2,948,368.64- Revenues Subtotal ----------- 6,509,258.00- 6,488,157.00- 665,066.71- 3,539,788.36- 54.558 2,948,368.64- TCMUD#1 Page 138 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 213,321.00 213,321.00 13,431.04 107,584.54 50.433 105,736.46 135-50010-010-000 Overtime 13,250.00 19,250.00 473.88 9,027.53 46.896 10,222.47 135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 375.00 3,000.00 58.824 2,100.00 135-50020-010-000 Retirement 32,725.00 57,748.00 1,282.33 39,206.17 67.892 18,541.83 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 2,113.96 15,621.56 54.016 13,298.44 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 145.51 1,125.89 53.845 965.11 135-50028-010-000 Vision Insurance 519.00 519.00 33.91 264.71 51.004 254.29 135-50029-010-000 Life Insurance & Other 1,204.00 1,532.00 90.06 946.37 61.773 585.63 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 865.16 7,703.35 52.926 6,851.65 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 202.34 1,801.59 52.926 1,602.41 135-50040-010-000 Unemployment Taxes 945.00 945.00 252.15- 45.01 4.763 899.99 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 2,532.00- 3,760.65 61.559 2,348.35 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 30.95 93.95 46.975 106.05 135-50070-010-000 Employee Relations 350.00 350.00 12.05 111.51 31.860 238.49 Subtotal: 325,773.00 357,124.00 16,272.04 193,372.83 54.147 163,751.17 135-55005-010-000 Engineering 3,000.00 2,000.00 2,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 716.97 23,472.07 46.944 26,527.93 135-55090-010-000 Vehicle Maintenance 3,700.00 4,650.00 752.82 3,637.74 78.231 1,012.26 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 1,767.04 60.932 1,132.96 135-55135-010-000 Lab Analysis 4,500.00 5,384.00 405.00 3,753.81 69.722 1,630.19 Subtotal: 64,100.00 64,934.00 1,874.79 32,630.66 50.252 32,303.34 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 175.00 1,053.96 52.698 946.04 135-60020-010-000 Electricity 162,410.00 162,410.00 9,951.39 65,135.33 40.105 97,274.67 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 100.000 135-60080-010-000 Schools & Training 1,672.00 1,472.00 351.00 23.845 1,121.00 135-60090-010-000 Safety Program 500.00 400.00 400.00 135-60100-010-000 Travel & per diem 700.00 800.00 551.69 68.961 248.31 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 18.00 3.600 482.00 135-60125-010-000 Advertising 150.00 150.00 150.00- 135-60135-010-000 TCEQ Fees & Permits 35,800.00 42,743.00 2,769.00 43,293.75 101.289 550.75- 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 247,511.36 830,521.44 40.944 1,197,925.56 135-60243-010-000 Prior Year Expense 756.00 756.00 100.000 135-60245-010-000 Miscellaneous Expenses 500.00 200.00 200.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 98.89 932.43 22.201 3,267.57 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 500.00 38.99 7.798 461.01 Subtotal: 2,239,129.00 2,245,328.00 260,661.64 942,952.59 41.996 1,302,375.41 TCMUD#1 Page 139 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 974.66 7,601.36 43.040 10,059.64 135-65010-010-000 Uniforms 2,680.00 2,680.00 1,617.82 60.366 1,062.18 135-65030-010-000 Chemicals 6,200.00 6,200.00 774.07 3,204.17 51.680 2,995.83 135-65035-010-000 Small Tools 1,500.00 1,500.00 267.19 17.813 1,232.81 135-65040-010-000 Safety Equipment 2,000.00 1,000.00 256.82 25.682 743.18 135-65050-010-000 Meter Expense 143,550.00 143,550.00 47,824.25 147,057.25 102.443 3,507.25- 135-65085-010-000 Office Supplies 109.68 109.68- Subtotal: 173,591.00 172,591.00 49,572.98 160,114.29 92.771 12,476.71 135-69005-010-000 Capital Expenses 181,800.00 8,000.00 1,094.96- -13.687 9,094.96 135-69008-010-000 Short Term Debt-Principal 387,037.00 366,000.00 366,000.00 135-69009-010-000 Short Term Debt-Interest 21,037.00 10,376.98 49.327 10,660.02 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 30,000.00 100.000 135-69280-010-000 Capital Repairs 270,000.00 60,000.00 59,869.00 99.782 131.00 135-69281-010-000 Capital Repair-Ground Storage 150,000.00 100,900.00 100,816.54 99.917 83.46 Subtotal: 1,018,837.00 585,937.00 30,000.00 199,967.56 34.128 385,969.44 Program number: 3,821,430.00 3,425,914.00 358,381.45 1,529,037.93 44.632 1,896,876.07 Department number: Water 3,821,430.00 3,425,914.00 358,381.45 1,529,037.93 44.632 1,896,876.07 TCMUD#1 Page 140 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 196,781.00 196,781.00 12,068.14 115,696.93 58.795 81,084.07 135-50010-020-000 Overtime 10,166.00 17,546.00 608.92 8,357.36 47.631 9,188.64 135-50016-020-000 Longevity 2,858.00 2,858.00 2,857.50 99.983 .50 135-50017-020-000 Certification 4,200.00 4,200.00 300.00 2,700.00 64.286 1,500.00 135-50020-020-000 Retirement 29,821.00 54,844.00 1,165.34 39,944.26 72.833 14,899.74 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 2,764.74 22,391.07 77.120 6,642.93 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 195.56 1,596.52 75.593 515.48 135-50028-020-000 Vision Insurance 552.00 552.00 41.15 392.26 71.062 159.74 135-50029-020-000 Life Insurance & Other 920.00 1,377.00 79.92 1,007.83 73.190 369.17 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 679.21 7,137.40 53.794 6,130.60 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 158.85 1,669.22 53.794 1,433.78 135-50040-020-000 Unemployment Taxes 756.00 756.00 263.64- 45.41 6.007 710.59 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 551.00 5,960.27 202.799 3,021.27- 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 126.00 84.000 24.00 135-50070-020-000 Employee Relations 350.00 350.00 12.05 91.23 26.066 258.77 Subtotal: 297,010.00 329,870.00 18,361.24 209,973.26 63.653 119,896.74 135-55070-020-000 Independent Labor 1,000.00 84,418.00 11,500.00 77,500.00 91.805 6,918.00 135-55080-020-000 Maintenance & Repairs 40,000.00 41,205.00 1,895.46 42,088.51 102.144 883.51- 135-55090-020-000 Vehicle Maintenance 2,000.00 3,350.00 884.83 4,517.96 134.864 1,167.96- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,080.96 72.064 419.04 135-55125-020-000 Dumpster Services 15,000.00 49,611.00 7,738.64 33,987.01 68.507 15,623.99 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 4,691.00 20,518.65 68.396 9,481.35 Subtotal: 89,500.00 210,084.00 26,709.93 179,693.09 85.534 30,390.91 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 3,981.00 168.70 1,408.33 35.376 2,572.67 135-60020-020-000 Electricity 153,045.00 153,045.00 9,692.88 84,225.41 55.033 68,819.59 135-60066-020-000 Publications/Books/Subscripts 500.00 200.00 161.45 80.725 38.55 135-60080-020-000 Schools & Training 3,272.00 3,272.00 1,071.66 32.752 2,200.34 135-60090-020-000 Safety Program 250.00 71.47 71.47 71.47- 135-60100-020-000 Travel & per diem 1,400.00 1,400.00 1,054.28 3,256.94 232.639 1,856.94- 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 1,123.00 74.867 377.00 135-60125-020-000 Advertising 2,000.00 300.00 112.50 37.500 187.50 135-60135-020-000 TCEQ Fees & Permits 56,000.00 15,600.00 7,887.19 50.559 7,712.81 135-60136-020-000 TCEQ Environmental Proj (SEP) 40,400.00 40,400.00 40,400.00 100.000 135-60243-020-000 Prior Year Expense 802.00 801.59 99.949 .41 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 54.00 202.10 101.050 2.10- 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 412.23 82.446 87.77 Subtotal: 221,367.00 221,200.00 51,441.33 141,133.87 63.804 80,066.13 135-65005-020-000 Fuel & Lube 8,527.00 10,527.00 72.00 7,132.95 67.759 3,394.05 TCMUD#1 Page 141 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-020-000 Uniforms 2,574.00 1,574.00 430.00 1,203.70 76.474 370.30 135-65030-020-000 Chemicals 10,000.00 38,346.00 2,760.00 22,790.90 59.435 15,555.10 135-65035-020-000 Small Tools 1,000.00 1,000.00 135.58 469.05 46.905 530.95 135-65040-020-000 Safety Equipment 250.00 500.00 43.44 526.70 105.340 26.70- 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 1,795.88 12,995.35 129.953 2,995.35- Subtotal: 32,351.00 61,947.00 5,236.90 45,118.65 72.834 16,828.35 135-69005-020-000 Capital Expenses 241,200.00 446,484.00 442,195.29 99.039 4,288.71 135-69280-020-000 Capital Repairs 158,000.00 Subtotal: 399,200.00 446,484.00 442,195.29 99.039 4,288.71 Program number: 1,039,428.00 1,269,585.00 101,749.40 1,018,114.16 80.193 251,470.84 Department number: Wastewater 1,039,428.00 1,269,585.00 101,749.40 1,018,114.16 80.193 251,470.84 TCMUD#1 Page 142 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 156,475.00 156,475.00 11,782.74 94,904.13 60.651 61,570.87 135-50010-021-000 Overtime 7,297.00 12,158.00 643.02 6,365.46 52.356 5,792.54 135-50016-021-000 Longevity 3,818.00 3,818.00 3,817.50 99.987 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 1,150.00 63.889 650.00 135-50020-021-000 Retirement 23,574.00 42,910.00 1,129.31 31,550.19 73.526 11,359.81 135-50026-021-000 Medical Insurance 20,198.00 25,940.00 2,321.55 16,656.99 64.214 9,283.01 135-50027-021-000 Dental Insurance 1,409.00 1,812.00 159.88 1,172.84 64.726 639.16 135-50028-021-000 Vision Insurance 357.00 383.00 32.60 252.12 65.828 130.88 135-50029-021-000 Life Insurance & Other 1,008.00 1,223.00 64.78 739.89 60.498 483.11 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 712.36 6,292.36 59.916 4,209.64 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 166.60 1,471.58 59.918 984.42 135-50040-021-000 Unemployment Taxes 567.00 567.00 206.88- 34.39 6.065 532.61 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 552.00 4,896.88 146.263 1,548.88- 135-50070-021-000 Employee Relations 250.00 250.00 12.05 108.00 43.200 142.00 Subtotal: 233,059.00 263,642.00 17,520.01 169,412.33 64.258 94,229.67 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 20,000.00 1,016.60 15,962.78 79.814 4,037.22 135-55090-021-000 Vehicle Maintenance 1,900.00 1,600.00 302.97 1,344.23 84.014 255.77 Subtotal: 38,400.00 21,600.00 1,319.57 17,307.01 80.125 4,292.99 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 217.94 1,580.45 45.156 1,919.55 135-60020-021-000 Electricity 18,705.00 18,705.00 1,512.77 11,979.36 64.044 6,725.64 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 100.000 135-60080-021-000 Schools & Training 826.00 826.00 830.00 100.484 4.00- 135-60090-021-000 Safety Program 500.00 300.00 300.00 135-60100-021-000 Travel & per diem 450.00 450.00 518.46 2,092.93 465.096 1,642.93- 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60243-021-000 Prior Year Expense 621.00 620.83 99.973 .17 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 34,331.00 34,752.00 2,249.17 17,353.57 49.935 17,398.43 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 5,576.47 46.022 6,540.53 135-65010-021-000 Uniforms 2,220.00 2,220.00 934.13 42.078 1,285.87 135-65030-021-000 Chemicals 7,500.00 7,500.00 2,221.00 29.613 5,279.00 135-65035-021-000 Small Tools 1,500.00 1,250.00 70.00 5.600 1,180.00 135-65040-021-000 Safety Equipment 500.00 500.00 120.00 24.000 380.00 Subtotal: 23,837.00 23,587.00 8,921.60 37.824 14,665.40 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 15,276.00 15,276.00 16.973 74,724.00 TCMUD#1 Page 143 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69008-021-000 Short Term Debt-Principal 40,260.00 40,260.00 40,260.00 Subtotal: 130,260.00 130,260.00 15,276.00 15,276.00 11.727 114,984.00 Program number: 459,887.00 473,841.00 36,364.75 228,270.51 48.174 245,570.49 Department number: Collection 459,887.00 473,841.00 36,364.75 228,270.51 48.174 245,570.49 TCMUD#1 Page 144 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,500.00 7,100.00 71.000 2,900.00 135-50030-026-000 Social Security Taxes 620.00 620.00 93.00 440.20 71.000 179.80 135-50035-026-000 Medicare Taxes 145.00 145.00 21.75 102.95 71.000 42.05 135-50040-026-000 Unemployment Taxes 210.00 210.00 1.50 65.90 31.381 144.10 135-50045-026-000 Workman's Compensation 150.00 150.00 7.82- 7.88 5.253 142.12 Subtotal: 11,125.00 11,125.00 1,608.43 7,716.93 69.366 3,408.07 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 42.00 2.000 2,058.00 135-60075-026-000 Meetings 1,200.00 1,200.00 434.97 36.248 765.03 135-60080-026-000 Schools & Training 4,000.00 4,000.00 395.00 2,655.00 66.375 1,345.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,764.34 4,106.22 82.124 893.78 135-60243-026-000 Prior Year Expense 107.10 107.10- 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 15.44 267.88 8.929 2,732.12 Subtotal: 15,450.00 15,450.00 2,174.78 7,613.17 49.276 7,836.83 Program number: 26,575.00 26,575.00 3,783.21 15,330.10 57.686 11,244.90 Department number: Board of Directors 26,575.00 26,575.00 3,783.21 15,330.10 57.686 11,244.90 TCMUD#1 Page 145 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 444,730.00 444,730.00 33,152.91 273,945.57 61.598 170,784.43 135-50010-030-000 Overtime 1,500.00 1,500.00 33.10 233.93 15.595 1,266.07 135-50016-030-000 Longevity 2,193.00 2,318.00 2,317.50 99.978 .50 135-50020-030-000 Retirement 60,441.00 104,801.00 2,980.10 75,342.70 71.891 29,458.30 135-50026-030-000 Medical Insurance 44,066.00 49,049.00 4,388.10 31,496.40 64.214 17,552.60 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 386.34 2,797.86 82.801 581.14 135-50028-030-000 Vision Insurance 795.00 945.00 82.53 611.17 64.674 333.83 135-50029-030-000 Life Insurance & Other 2,500.00 2,582.00 173.08 1,896.17 73.438 685.83 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,912.89 16,410.36 59.026 11,391.64 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 447.37 3,837.91 59.027 2,664.09 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 515.12- 439.29 28.581 1,097.71 135-50045-030-000 Workman's Compensation 831.00 831.00 98.12 938.60 112.948 107.60- 135-50060-030-000 Pre-emp Physicals/Testing 250.00 250.00 39.00 15.600 211.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 15.82 2,739.99 54.800 2,260.01 Subtotal: 601,526.00 651,226.00 43,155.24 413,046.45 63.426 238,179.55 135-55030-030-000 Software & Support 63,555.00 63,555.00 22,238.65 48,711.94 76.645 14,843.06 135-55070-030-000 Independent Labor 2,700.00 7,700.00 598.75 7.776 7,101.25 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55080-030-000 Maintenance & Repairs 811.00 810.52 99.941 .48 135-55100-030-000 Building Maint & Supplies 5,000.00 6,500.00 808.43 4,305.95 66.245 2,194.05 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 12,197.25 60.382 8,002.75 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 6,974.00 46.493 8,026.00 135-55161-030-000 Outside Services-Town Semo 85,465.00 85,465.00 85,465.00 100.000 135-55165-030-000 Collection Fees 160.00 159.77 99.856 .23 135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 611.28 4,358.49 39.623 6,641.51 Subtotal: 203,420.00 210,891.00 23,658.36 163,581.67 77.567 47,309.33 135-60005-030-000 Telephone 9,000.00 10,500.00 2,638.32 8,236.58 78.444 2,263.42 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 340.79 2,295.69 64.215 1,279.31 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 1,138.58 8,131.52 62.459 4,887.48 135-60025-030-000 Water 3,100.00 3,100.00 243.18 740.46 23.886 2,359.54 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 8,788.08 66.667 4,393.92 135-60035-030-000 Postage 23,000.00 26,604.00 3,384.66 18,426.34 69.262 8,177.66 135-60040-030-000 Service Charges & Fees 18,000.00 28,330.00 2,153.86 18,365.90 64.828 9,964.10 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 85.44 1.005 8,414.56 135-60055-030-000 Insurance 35,000.00 50,694.00 50.00 50,743.77 100.098 49.77- 135-60066-030-000 Publications/Books/Subscripts 750.00 834.00 833.50 99.940 .50 135-60070-030-000 Dues & Memberships 2,400.00 3,892.00 3,891.95 99.999 .05 135-60075-030-000 Meetings 250.00 400.00 283.85 70.963 116.15 135-60080-030-000 Schools & Training 5,500.00 5,350.00 989.65 3,394.65 63.451 1,955.35 135-60100-030-000 Travel & per diem 3,950.00 3,616.00 1,634.19 3,697.01 102.240 81.01- TCMUD#1 Page 146 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60110-030-000 Physicals/Testing 500.00 500.00 500.00 135-60125-030-000 Advertising 4,000.00 4,000.00 893.40 22.335 3,106.60 135-60235-030-000 Security 1,350.00 1,350.00 505.13 505.13 37.417 844.87 135-60243-030-000 Prior Year Expense 1,263.00 2,027.57 3,290.58 260.537 2,027.58- 135-60245-030-000 Miscellaneous Expenses 15,000.00 13,500.00 733.10 1,015.22 7.520 12,484.78 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60281-030-000 Park Expenses 42,500.00 1,998.06 30,550.46 71.883 11,949.54 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 161,000.00 161,000.00 161,000.00- 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 380.36 3,537.76 141.510 1,037.76- Subtotal: 173,076.00 247,709.00 180,315.96 328,707.29 132.699 80,998.29- 135-65010-030-000 Uniforms 1,635.00 1,635.00 624.12 38.172 1,010.88 135-65055-030-000 Hardware 20,188.00 20,188.00 1,442.50 11,941.74 59.153 8,246.26 135-65085-030-000 Office Supplies 8,200.00 8,200.00 1,806.65 6,491.22 79.161 1,708.78 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 335.50 2,057.58 35.896 3,674.42 135-65095-030-000 Maintenance Supplies 2,000.00 1,500.00 150.30 2,319.47 154.631 819.47- 135-65097-030-000 Vending Machine Supplies 500.00 500.00 50.32 50.32 10.064 449.68 135-65105-030-000 Printing 5,200.00 4,200.00 761.19 1,156.19 27.528 3,043.81 Subtotal: 43,455.00 41,955.00 4,546.46 24,640.64 58.731 17,314.36 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 1,797.95 52.114 1,652.05 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 26,911.00 100.000 Subtotal: 30,361.00 30,361.00 27,167.85 28,708.95 94.559 1,652.05 Program number: 1,051,838.00 1,182,142.00 278,843.87 958,685.00 81.097 223,457.00 Department number: Administration 1,051,838.00 1,182,142.00 278,843.87 958,685.00 81.097 223,457.00 TCMUD#1 Page 147 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 20:09 06/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 70,000.00 70,000.00 6,003.50 141,515.60 202.165 71,515.60- 135-55055-039-000 Auditing 21,200.00 21,200.00 20,700.00 97.642 500.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 6,209.06 41.120 8,890.94 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,356.39 62.010 1,443.61 Subtotal: 110,100.00 110,100.00 6,003.50 170,781.05 155.114 60,681.05- 135-60344-039-000 Intergov Trans Out (Fire CIP) 25,606.82 112,333.21 112,333.21- Subtotal: 25,606.82 112,333.21 112,333.21- Program number: 110,100.00 110,100.00 31,610.32 283,114.26 257.143 173,014.26- Department number: Non Departmental 110,100.00 110,100.00 31,610.32 283,114.26 257.143 173,014.26- Expenditures Subtotal ----------- 6,509,258.00 6,488,157.00 810,733.00 4,032,551.96 62.153 2,455,605.04 Fund number: 135 MUD 1 General Fund 145,666.29 492,763.60 492,763.60- TCMUD#1 Page 148 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49005-000-000 Loan Proceeds 445,000.00- 445,000.00- 100.000 507-49010-000-000 Interest Income 100.00- 24.18- 49.33- 49.330 50.67- Subtotal: 445,100.00- 24.18- 445,049.33- 99.989 50.67- Program number: 445,100.00- 24.18- 445,049.33- 99.989 50.67- Department number: 445,100.00- 24.18- 445,049.33- 99.989 50.67- Revenues Subtotal ----------- 445,100.00- 24.18- 445,049.33- 99.989 50.67- TCMUD#1 Page 149 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-000 Capital Repairs 2,663.28- Subtotal: 2,663.28- Program number: 2,663.28- TCMUD#1 Page 150 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-010-001 Capital Expense 5,800.00 6,289.00 108.431 489.00- Subtotal: 5,800.00 6,289.00 108.431 489.00- Program number: 1 Security Cameras 5,800.00 6,289.00 108.431 489.00- TCMUD#1 Page 151 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs 165,000.00 15,946.00 15,946.00 9.664 149,054.00 Subtotal: 165,000.00 15,946.00 15,946.00 9.664 149,054.00 Program number: 2 Rate of Flow Control-FW Meter 165,000.00 15,946.00 15,946.00 9.664 149,054.00 TCMUD#1 Page 152 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Repairs 210,000.00 5,279.33 9,079.33 4.323 200,920.67 Subtotal: 210,000.00 5,279.33 9,079.33 4.323 200,920.67 Program number: 3 Indian Creek Waterline 210,000.00 5,279.33 9,079.33 4.323 200,920.67 Department number: Water 380,800.00 18,562.05 31,314.33 8.223 349,485.67 TCMUD#1 Page 153 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 38,101.42 38,101.42- Subtotal: 38,101.42 38,101.42- Program number: 38,101.42 38,101.42- TCMUD#1 Page 154 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 1 Security Cameras Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-001 Capital Expense 8,200.00 8,578.00 104.610 378.00- Subtotal: 8,200.00 8,578.00 104.610 378.00- Program number: 1 Security Cameras 8,200.00 8,578.00 104.610 378.00- TCMUD#1 Page 155 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 23 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 4 Sludge Blanket Level Indicator Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-004 Capital Expense 18,000.00 18,000.00 Subtotal: 18,000.00 18,000.00 Program number: 4 Sludge Blanket Level Indicator 18,000.00 18,000.00 TCMUD#1 Page 156 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 24 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 5 Portable Submersible Pump Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-005 Capital Expense 10,000.00 8,553.92 8,553.92 85.539 1,446.08 Subtotal: 10,000.00 8,553.92 8,553.92 85.539 1,446.08 Program number: 5 Portable Submersible Pump 10,000.00 8,553.92 8,553.92 85.539 1,446.08 TCMUD#1 Page 157 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 25 20:09 06/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 6 Waste Pump Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-020-006 Capital Repairs 28,000.00 27,960.70 99.860 39.30 Subtotal: 28,000.00 27,960.70 99.860 39.30 Program number: 6 Waste Pump 28,000.00 27,960.70 99.860 39.30 Department number: Wastewater 64,200.00 8,553.92 83,194.04 129.586 18,994.04- Expenditures Subtotal ----------- 445,000.00 27,115.97 114,508.37 25.732 330,491.63 Fund number: 507 MUD 1 Capital Projects 100.00- 27,091.79 330,540.96- ############### 330,440.96 TCMUD#1 Page 158 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 26 20:09 06/12/13 Budget Summary with Amendment Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 522-49145-000-000 Intergov Transfer-General Fund 25,606.82- 112,333.21- 112,333.21 Subtotal: 25,606.82- 112,333.21- 112,333.21 Program number: 25,606.82- 112,333.21- 112,333.21 Department number: Revenues 25,606.82- 112,333.21- 112,333.21 Revenues Subtotal ----------- 25,606.82- 112,333.21- 112,333.21 Fund number: 522 2010 GO/Fire Station 25,606.82- 112,333.21- 112,333.21 TCMUD#1 Page 159 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2013 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 1589 05/01/2013 Property Taxes/Assessments (99,308.20) (31.85) (99,340.05) GL 1590 05/02/2013 Property Taxes/Assessments (5.43) (99,345.48) GL 1591 05/03/2013 Property Taxes/Assessments (3.80) (99,349.28) GL 1592 05/06/2013 Property Taxes/Assessments (11.43) (99,360.71) GL 1593 05/07/2013 Property Taxes/Assessments (39.98) (99,400.69) GL 1594 05/08/2013 Property Taxes/Assessments (1.85) (99,402.54) GL 1595 05/09/2013 Property Taxes/Assessments (.55) (99,403.09) GL 1596 05/10/2013 Property Taxes/Assessments (6.95) (99,410.04) GL 1446 05/13/2013 May A/P MUD 1 Tax shortage due to an o (159.35) (99,569.39) DENTON COUNTY TAX OFFICE 32531 AP 1599 05/15/2013 Property Taxes/Assessments (3.96) (99,573.35) GL 1600 05/16/2013 Property Taxes/Assessments (26.49) (99,599.84) GL 1601 05/17/2013 Property Taxes/Assessments (69.91) (99,669.75) GL 1602 05/20/2013 Property Taxes/Assessments (41.88) (99,711.63) GL 1603 05/21/2013 Property Taxes/Assessments (11.19) (99,722.82) GL 1604 05/22/2013 Property Taxes/Assessments (29.03) (99,751.85) GL 1605 05/23/2013 Property Taxes/Assessments (19.88) (99,771.73) GL 1606 05/24/2013 Property Taxes/Assessments (42.28) (99,814.01) GL 1607 05/28/2013 Property Taxes/Assessments (120.35) (99,934.36) GL 1608 05/29/2013 Property Taxes/Assessments (48.16) (99,982.52) GL 1609 05/30/2013 Property Taxes/Assessments (13.52) (99,996.04) GL 1610 05/31/2013 Property Taxes/Assessments (30.15) (100,026.19) GL 1678 05/31/2013 Overpmt tax refund 159.35 (99,866.84) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (558.64) (99,866.84) ** (99,884.00) Budgeted (17.16) Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1590 05/02/2013 Property Taxes/Assessments 381.99 (8.17) 373.82 GL 1446 05/13/2013 May A/P MUD 1 Tax shortage due to an o 997.88 1,371.70 DENTON COUNTY TAX OFFICE 32531 AP 1604 05/22/2013 Property Taxes/Assessments (2.13) 1,369.57 GL 1609 05/30/2013 Property Taxes/Assessments (.51) 1,369.06 GL 1678 05/31/2013 Overpmt tax refund (997.88) 371.18 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (10.81) 371.18 ** (624.00) Budgeted (995.18) Remaining -59 % Used Account: 135-40015-000-000 Property Taxes/P & I 1589 05/01/2013 Property Taxes/Assessments (695.90) (3.50) (699.40) GL 1590 05/02/2013 Property Taxes/Assessments (4.56) (703.96) GL 1590 05/02/2013 Property Taxes/Assessments (4.11) (708.07) GL TCMUD#1 Page 160 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1593 05/07/2013 Property Taxes/Assessments (695.90) (2.54) (710.61) GL 1446 05/13/2013 May A/P MUD 1 Tax shortage due to an o (21.18) (731.79) DENTON COUNTY TAX OFFICE 32531 AP 1446 05/13/2013 May A/P MUD 1 Tax shortage due to an o (4.12) (735.91) DENTON COUNTY TAX OFFICE 32531 AP 1599 05/15/2013 Property Taxes/Assessments (.51) (736.42) GL 1600 05/16/2013 Property Taxes/Assessments (1.23) (737.65) GL 1601 05/17/2013 Property Taxes/Assessments (7.28) (744.93) GL 1602 05/20/2013 Property Taxes/Assessments (4.27) (749.20) GL 1604 05/22/2013 Property Taxes/Assessments (3.14) (752.34) GL 1604 05/22/2013 Property Taxes/Assessments (6.30) (758.64) GL 1606 05/24/2013 Property Taxes/Assessments (4.18) (762.82) GL 1607 05/28/2013 Property Taxes/Assessments (14.57) (777.39) GL 1608 05/29/2013 Property Taxes/Assessments (2.60) (779.99) GL 1609 05/30/2013 Property Taxes/Assessments (.16) (780.15) GL 1609 05/30/2013 Property Taxes/Assessments (.85) (781.00) GL 1610 05/31/2013 Property Taxes/Assessments (1.61) (782.61) GL 1678 05/31/2013 Overpmt tax refund 25.30 (757.31) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (61.41) (757.31) ** (1,200.00) Budgeted (442.69) Remaining 63 % Used Account: 135-47000-000-000 Water 1506 05/17/2013 Recode Feb-Apr Effluent CC (1,493,183.27) 4,808.70 (1,488,374.57) GL 1618 05/31/2013 UB 5/31/13 Charges UB20130531-20130531 User: (284,687.66) (1,773,062.23) UB 1619 05/31/2013 UB 5/31/13 Credit Adjustments UB20130531-20130531 User: (6,805.97) (1,779,868.20) UB 1695 05/31/2013 Recode Water/Out of District 309.51 (1,779,558.69) GL 1696 05/31/2013 Rev Recode Water/Out of Dist (309.51) (1,779,868.20) GL 1697 05/31/2013 Corr Recode Water/Out of Dist (309.51) (1,780,177.71) GL _______________ Account: 135-47000-000-000 Water Totals: (286,994.44) (1,780,177.71) ** (3,545,609.00) Budgeted (1,765,431.29) Remaining 50 % Used Account: 135-47005-000-000 Sewer 1618 05/31/2013 UB 5/31/13 Charges UB20130531-20130531 User: (946,337.56) (167,500.77) (1,113,838.33) UB 1619 05/31/2013 UB 5/31/13 Credit Adjustments UB20130531-20130531 User: 3,848.14 (1,109,990.19) UB _______________ Account: 135-47005-000-000 Sewer Totals: (163,652.63) (1,109,990.19) ** (1,653,747.00) Budgeted (543,756.81) Remaining 67 % Used Account: 135-47020-000-000 Standby (149.90) .00 (149.90) TCMUD#1 Page 161 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47020-000-000 Standby Totals: .00 (149.90) ** (576.00) Budgeted (426.10) Remaining 26 % Used Account: 135-47025-000-000 Penalties 1467 05/14/2013 UB 5/14/13 Adjustments UB20130514-20130514 User: (29,435.15) 28.98 (29,406.17) UB 1519 05/21/2013 UB 5/21/13 Penalties UB20130521-20130521 User: (4,361.67) (33,767.84) UB 1520 05/21/2013 UB 5/21/13 Penalties UB20130521-20130521 User: (4,819.66) (38,587.50) UB 1537 05/21/2013 UB 5/21/13 Penalty Reversals UB20130521-20130521 User: 4,361.67 (34,225.83) UB 1566 05/29/2013 UB 05/29/2013 Adjustments UB20130529-20130529 User: 140.44 (34,085.39) UB 1616 05/30/2013 UB 5/30/13 Adjustments UB20130530-20130530 User: 265.11 (33,820.28) UB 1618 05/31/2013 UB 5/31/13 Charges UB20130531-20130531 User: (244.76) (34,065.04) UB 1619 05/31/2013 UB 5/31/13 Credit Adjustments UB20130531-20130531 User: (153.40) (34,218.44) UB _______________ Account: 135-47025-000-000 Penalties Totals: (4,783.29) (34,218.44) ** (64,580.00) Budgeted (30,361.56) Remaining 53 % Used Account: 135-47030-000-000 Service Charges 1489 05/03/2013 UB 5/3/13 Adjustments UB20130503-20130503 User: (7,247.94) (25.00) (7,272.94) UB 1491 05/06/2013 UB 5/6/13 Adjustments UB20130506-20130506 User: (25.00) (7,297.94) UB 1427 05/08/2013 UB 5/8/13 Cut Off Fees UB20130508-20130508 User: (750.00) (8,047.94) UB 1472 05/08/2013 UB 5/8/13 After hours Fee UB20130508-20130508 User: (100.00) (8,147.94) UB 1467 05/14/2013 UB 5/14/13 Adjustments UB20130514-20130514 User: 75.00 (8,072.94) UB 1567 05/20/2013 UB 5/20/13 Adjustment UB20130520-20130520 User: (25.00) (8,097.94) UB 1569 05/23/2013 UB 5/23/13 Adjustments UB20130523-20130523 User: (25.00) (8,122.94) UB 1618 05/31/2013 UB 5/31/13 Charges UB20130531-20130531 User: (28.00) (8,150.94) UB 1619 05/31/2013 UB 5/31/13 Credit Adjustments UB20130531-20130531 User: 18.12 (8,132.82) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (884.88) (8,132.82) ** (11,625.00) Budgeted (3,492.18) Remaining 70 % Used Account: 135-47035-000-000 Plumbing Inspections 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (500.00) (50.00) (550.00) AR 1656 05/31/2013 Town Invoice 1036-38 AR 20130531-20130531 User: (150.00) (700.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (700.00) ** (1,800.00) Budgeted (1,100.00) Remaining 39 % Used Account: 135-47045-000-000 Sewer Inspections TCMUD#1 Page 162 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (1,950.00) (150.00) (2,100.00) AR 1656 05/31/2013 Town Invoice 1036-38 AR 20130531-20130531 User: (450.00) (2,550.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (2,550.00) ** (5,200.00) Budgeted (2,650.00) Remaining 49 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1504 05/17/2013 UB 5/17/13 Adjustment UB20130517-20130517 User: (12,578.15) 4,417.21 (8,160.94) UB 1506 05/17/2013 Recode Feb-Apr Effluent CC (4,808.70) (12,969.64) GL 1618 05/31/2013 UB 5/31/13 Charges UB20130531-20130531 User: (9,390.50) (22,360.14) UB 1619 05/31/2013 UB 5/31/13 Credit Adjustments UB20130531-20130531 User: 1,584.05 (20,776.09) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (8,197.94) (20,776.09) ** (77,575.00) Budgeted (56,798.91) Remaining 27 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 1612 05/30/2013 UB 5/30/2013 Adjustment UB20130530-20130530 User: (300.00) (300.00) UB 1619 05/31/2013 UB 5/31/13 Credit Adjustments UB20130531-20130531 User: (9.51) (309.51) UB 1695 05/31/2013 Recode Water/Out of District (309.51) (619.02) GL 1696 05/31/2013 Rev Recode Water/Out of Dist 309.51 (309.51) GL 1697 05/31/2013 Corr Recode Water/Out of Dist 309.51 .00 GL _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-48005-000-000 Utility Fees 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (184,000.00) (66,700.00) (250,700.00) AR 1656 05/31/2013 Town Invoice 1036-38 AR 20130531-20130531 User: (96,600.00) (347,300.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (163,300.00) (347,300.00) ** (644,000.00) Budgeted (296,700.00) Remaining 54 % Used Account: 135-49010-000-000 Interest Income 1583 05/31/2013 May bank interest (3,112.01) (64.26) (3,176.27) GL 1583 05/31/2013 May bank interest (207.83) (3,384.10) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (272.09) (3,384.10) ** (5,500.00) Budgeted (2,115.90) Remaining 62 % Used TCMUD#1 Page 163 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49016-000-000 Cell Tower Revenue 1497 05/09/2013 AT&T Antenna Lease/May (6,310.18) (910.53) (7,220.71) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (7,220.71) ** (10,164.00) Budgeted (2,943.29) Remaining 71 % Used Account: 135-49018-000-000 Building Rent Income 1481 05/16/2013 Town Billing Inv. # 1030 AR 20130516-20130516 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 1498 05/09/2013 WWTP Vending (48.31) (79.40) (127.71) GL 1540 05/23/2013 Vending-collection barn (189.75) (317.46) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (269.15) (317.46) ** (350.00) Budgeted (32.54) Remaining 91 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (234,014.00) Budgeted (234,014.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (30,543.69) (9,827.00) (40,370.69) AR 1656 05/31/2013 Town Invoice 1036-38 AR 20130531-20130531 User: (14,265.00) (54,635.69) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (24,092.00) (54,635.69) ** (73,000.00) Budgeted (18,364.31) Remaining 75 % Used Account: 135-49141-000-000 Interfund Trans In (Cap Proj) (38,101.42) .00 (38,101.42) _______________ Account: 135-49141-000-000 Interfund Trans In (Cap Proj) Totals: .00 (38,101.42) ** (38,101.00) Budgeted .42 Remaining 100 % Used TCMUD#1 Page 164 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2013 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 1629 05/09/2013 Deposit correction UB (14,746.44) (.10) (14,746.54) GL 1499 05/16/2013 UB Cash drawer/Misc income (3.84) (14,750.38) GL 1541 05/23/2013 WWTP Salvage (97.50) (14,847.88) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (101.44) (14,847.88) ** (13,213.00) Budgeted 1,634.88 Remaining 112 % Used Account: 135-49901-000-000 Records Management Revenue 1501 05/17/2013 Bernard Newsom/Open Records (109.00) (20.00) (129.00) GL 1525 05/22/2013 May A/P Refund-Public Information requ 101.40 (27.60) Bill Rose 32595 AP 1534 05/23/2013 Open Records/D Mayer (3.70) (31.30) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: 77.70 (31.30) ** (109.00) Budgeted (77.70) Remaining 29 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense 1451 05/01/2013 Correct P/Y Due to Town/Medica True up 9/30/10 PPD Medical (2,117.50) (9,671.83) (11,789.33) GL _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: (9,671.83) (11,789.33) ** .00 Budgeted 11,789.33 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue (545.71) .00 (545.71) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (545.71) ** (286.00) Budgeted 259.71 Remaining 191 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,539,788.36) ** (6,488,157.00) Budgeted (2,948,368.64) Remaining 55 % Used TCMUD#1 Page 165 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 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 1420 05/10/2013 Payroll 5/10/13 Salaries & Wages 94,153.50 6,715.52 100,869.02 PR 1521 05/24/2013 Payroll 5/24/13 Salaries & Wages 6,715.52 107,584.54 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 13,431.04 107,584.54 ** 213,321.00 Budgeted 105,736.46 Remaining 50 % Used Account: 135-50010-010-000 Overtime 1420 05/10/2013 Payroll 5/10/13 Overtime 8,553.65 179.05 8,732.70 PR 1521 05/24/2013 Payroll 5/24/13 Overtime 294.83 9,027.53 PR _______________ Account: 135-50010-010-000 Overtime Totals: 473.88 9,027.53 ** 19,250.00 Budgeted 10,222.47 Remaining 47 % Used Account: 135-50016-010-000 Longevity 3,080.00 .00 3,080.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,080.00 ** 3,080.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1521 05/24/2013 Payroll 5/24/13 Certification 2,625.00 375.00 3,000.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 375.00 3,000.00 ** 5,100.00 Budgeted 2,100.00 Remaining 59 % Used Account: 135-50020-010-000 Retirement 1420 05/10/2013 Payroll 5/10/13 Retirement 37,923.84 619.14 38,542.98 PR 1521 05/24/2013 Payroll 5/24/13 Retirement 663.19 39,206.17 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,282.33 39,206.17 ** 57,748.00 Budgeted 18,541.83 Remaining 68 % Used Account: 135-50026-010-000 Medical Insurance 1420 05/10/2013 Payroll 5/10/13 Medical Insurance 13,507.60 1,057.00 14,564.60 PR 1521 05/24/2013 Payroll 5/24/13 Medical Insurance 1,056.96 15,621.56 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,113.96 15,621.56 ** 28,920.00 Budgeted 13,298.44 Remaining 54 % Used TCMUD#1 Page 166 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 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 1420 05/10/2013 Payroll 5/10/13 Dental Insurance 980.38 72.76 1,053.14 PR 1521 05/24/2013 Payroll 5/24/13 Dental Insurance 72.75 1,125.89 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 145.51 1,125.89 ** 2,091.00 Budgeted 965.11 Remaining 54 % Used Account: 135-50028-010-000 Vision Insurance 1420 05/10/2013 Payroll 5/10/13 Vision Insurance 230.80 16.96 247.76 PR 1521 05/24/2013 Payroll 5/24/13 Vision Insurance 16.95 264.71 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 33.91 264.71 ** 519.00 Budgeted 254.29 Remaining 51 % Used Account: 135-50029-010-000 Life Insurance & Other 1420 05/10/2013 Payroll 5/10/13 Life Insurance & Other 856.31 74.31 930.62 PR 1525 05/22/2013 May A/P FSA-Monthly Adm 15.75 946.37 Discovery Benefits 32599 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 90.06 946.37 ** 1,532.00 Budgeted 585.63 Remaining 62 % Used Account: 135-50030-010-000 Social Security Taxes 1420 05/10/2013 Payroll 5/10/13 Social Security Taxes 6,838.19 418.11 7,256.30 PR 1521 05/24/2013 Payroll 5/24/13 Social Security Taxes 447.05 7,703.35 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 865.16 7,703.35 ** 14,555.00 Budgeted 6,851.65 Remaining 53 % Used Account: 135-50035-010-000 Medicare Taxes 1420 05/10/2013 Payroll 5/10/13 Medicare Taxes 1,599.25 97.78 1,697.03 PR 1521 05/24/2013 Payroll 5/24/13 Medicare Taxes 104.56 1,801.59 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 202.34 1,801.59 ** 3,404.00 Budgeted 1,602.41 Remaining 53 % Used Account: 135-50040-010-000 Unemployment Taxes 1485 05/17/2013 1st Qtr Town TWC Correction 297.16 (252.15) 45.01 GL TCMUD#1 Page 167 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 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: (252.15) 45.01 ** 945.00 Budgeted 899.99 Remaining 5 % Used Account: 135-50045-010-000 Workman's Compensation 1495 05/14/2013 Town Bill-W/C Audit Refnd 2012 6,292.65 (2,532.00) 3,760.65 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: (2,532.00) 3,760.65 ** 6,109.00 Budgeted 2,348.35 Remaining 62 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1679 05/31/2013 May A/P Pre-employment background chec 63.00 30.95 93.95 FIRST CHECK APPLICANT SCREENIN 32649 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 30.95 93.95 ** 200.00 Budgeted 106.05 Remaining 47 % Used Account: 135-50070-010-000 Employee Relations 1644 05/26/2013 4/27-5/26 PCards SPLIT - 13550070010 (25%) 99.46 12.05 111.51 FUZZY'S TACO SHOP PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 12.05 111.51 ** 350.00 Budgeted 238.49 Remaining 32 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1447 05/13/2013 May A/P bolt 22,755.10 75.00 22,830.10 HD SUPPLY WATERWORKS, LTD. 32540 AP 1455 05/14/2013 May A/P softwarer for generator at wat 641.97 23,472.07 WAUKESHA-PEARCE INDUSTRIES INC 32587 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 716.97 23,472.07 ** 50,000.00 Budgeted 26,527.93 Remaining 47 % Used Account: 135-55090-010-000 Vehicle Maintenance 1526 05/22/2013 May A/P MUD logos on vehicles 2,884.92 595.00 3,479.92 AUTO DESIGNS 32594 AP TCMUD#1 Page 168 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1679 05/31/2013 May A/P Tire for Jennifer's truck 2,884.92 157.82 3,637.74 BLAGG TIRE & SERVICE 32643 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 752.82 3,637.74 ** 4,650.00 Budgeted 1,012.26 Remaining 78 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,767.04 .00 1,767.04 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,767.04 ** 2,900.00 Budgeted 1,132.96 Remaining 61 % Used Account: 135-55135-010-000 Lab Analysis 1447 05/13/2013 May A/P bac t sample test 3,348.81 405.00 3,753.81 TARRANT CTY PUBLIC HEALTH LAB 32564 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 405.00 3,753.81 ** 5,384.00 Budgeted 1,630.19 Remaining 70 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1525 05/22/2013 May A/P Verizon Inv#9703714888 878.96 175.00 1,053.96 TOWN OF TROPHY CLUB 32615 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 175.00 1,053.96 ** 2,000.00 Budgeted 946.04 Remaining 53 % Used Account: 135-60020-010-000 Electricity 1525 05/22/2013 May A/P Electricity 4/15-5/14 55,183.94 5,876.02 61,059.96 HUDSON ENERGY SERVICES, LLC 32602 AP 1525 05/22/2013 May A/P Town elevated tank electricity 83.62 61,143.58 HUDSON ENERGY SERVICES, LLC 32602 AP 1525 05/22/2013 May A/P Electricity 4/15-5/14 3,991.75 65,135.33 HUDSON ENERGY SERVICES, LLC 32602 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,951.39 65,135.33 ** 162,410.00 Budgeted 97,274.67 Remaining 40 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships TCMUD#1 Page 169 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 150.00 .00 150.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 150.00 ** 150.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-010-000 Schools & Training 351.00 .00 351.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 351.00 ** 1,472.00 Budgeted 1,121.00 Remaining 24 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 551.69 .00 551.69 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 551.69 ** 800.00 Budgeted 248.31 Remaining 69 % Used Account: 135-60105-010-000 Rent/Lease Equipment 1455 05/14/2013 May A/P nitrogen bottle 12.00 6.00 18.00 ALLIED WELDING SUPPLY, INC 32577 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 18.00 ** 500.00 Budgeted 482.00 Remaining 4 % Used Account: 135-60125-010-000 Advertising 1447 05/13/2013 May A/P employemnt ad-utility field wo 150.00 150.00 TX MUNICIPAL LEAGUE 32572 AP _______________ Account: 135-60125-010-000 Advertising Totals: 150.00 150.00 ** .00 Budgeted (150.00) Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 1447 05/13/2013 May A/P july 2012 well water tax 40,524.75 2,769.00 43,293.75 North Texas Groundwater 32551 AP TCMUD#1 Page 170 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 2,769.00 43,293.75 ** 42,743.00 Budgeted (550.75) Remaining 101 % Used Account: 135-60150-010-000 Wholesale Water 1447 05/13/2013 May A/P wholesale water-april 583,010.08 121,968.86 704,978.94 CITY OF FORT WORTH 32525 AP 1577 05/31/2013 May A/P April Wholesale Water 125,542.50 830,521.44 CITY OF FORT WORTH 32646 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 247,511.36 830,521.44 ** 2,028,447.00 Budgeted 1,197,925.56 Remaining 41 % Used Account: 135-60243-010-000 Prior Year Expense 756.00 .00 756.00 _______________ Account: 135-60243-010-000 Prior Year Expense Totals: .00 756.00 ** 756.00 Budgeted .00 Remaining 100 % 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 1644 05/26/2013 4/27-5/26 PCards THE HOME DEPOT 6581 833.54 32.58 866.12 THE HOME DEPOT 6581 PC 1644 05/26/2013 4/27-5/26 PCards TEX-TURF 15.00 881.12 TEX-TURF PC 1574 05/30/2013 May A/P fence repair 51.31 932.43 SAV ON FENCE INC 32632 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 98.89 932.43 ** 4,200.00 Budgeted 3,267.57 Remaining 22 % 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 TCMUD#1 Page 171 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 38.99 .00 38.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 38.99 ** 500.00 Budgeted 461.01 Remaining 8 % Used Account: 135-65005-010-000 Fuel & Lube 1525 05/22/2013 May A/P Oil for pumps @ water plant 6,626.70 869.80 7,496.50 LUBRICATION ENGINEERS, INC 32606 AP 1644 05/26/2013 4/27-5/26 PCards SHELL OIL 57545832404 57.87 7,554.37 SHELL OIL 57545832404 PC 1644 05/26/2013 4/27-5/26 PCards CHEVRON 0204503 46.99 7,601.36 CHEVRON 0204503 PC _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 974.66 7,601.36 ** 17,661.00 Budgeted 10,059.64 Remaining 43 % Used Account: 135-65010-010-000 Uniforms 1,617.82 .00 1,617.82 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,617.82 ** 2,680.00 Budgeted 1,062.18 Remaining 60 % Used Account: 135-65030-010-000 Chemicals 1447 05/13/2013 May A/P testing supplies 2,430.10 565.89 2,995.99 HACH COMPANY 32538 AP 1644 05/26/2013 4/27-5/26 PCards DX SERVICE 208.18 3,204.17 DX SERVICE PC _______________ Account: 135-65030-010-000 Chemicals Totals: 774.07 3,204.17 ** 6,200.00 Budgeted 2,995.83 Remaining 52 % Used Account: 135-65035-010-000 Small Tools 267.19 .00 267.19 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 267.19 ** 1,500.00 Budgeted 1,232.81 Remaining 18 % Used Account: 135-65040-010-000 Safety Equipment 256.82 .00 256.82 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 256.82 ** 1,000.00 Budgeted 743.18 Remaining 26 % Used TCMUD#1 Page 172 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense 1455 05/14/2013 May A/P 1" meters w/ orions 99,233.00 47,824.25 147,057.25 ATLAS UTILITY SUPPLY CO. 32578 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 47,824.25 147,057.25 ** 143,550.00 Budgeted (3,507.25) Remaining 102 % Used Account: 135-65085-010-000 Office Supplies 109.68 .00 109.68 _______________ Account: 135-65085-010-000 Office Supplies Totals: .00 109.68 ** .00 Budgeted (109.68) Remaining 0 % Used Account: 135-69005-010-000 Capital Expenses 1525 05/22/2013 May A/P Roundabout engineering (1,094.96) 2,194.16 1,099.20 TEAGUE, NALL & PERKINS,INC 32614 AP 1547 05/22/2013 Void A/P Check 32614/TN&P Roundabout engineering (2,194.16) (1,094.96) TEAGUE, NALL & PERKINS,INC 32614 AP _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 (1,094.96) ** 8,000.00 Budgeted 9,094.96 Remaining -14 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 366,000.00 Budgeted 366,000.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest 10,376.98 .00 10,376.98 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 10,376.98 ** 21,037.00 Budgeted 10,660.02 Remaining 49 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 1588 05/31/2013 Transfer GASB 34 Replacement Water replacement 30,000.00 30,000.00 GL _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 30,000.00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69280-010-000 Capital Repairs TCMUD#1 Page 173 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 59,869.00 .00 59,869.00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 59,869.00 ** 60,000.00 Budgeted 131.00 Remaining 100 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 100,900.00 Budgeted 83.46 Remaining 100 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,529,037.93 ** 3,425,914.00 Budgeted 1,896,876.07 Remaining 45 % Used TCMUD#1 Page 174 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 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 1420 05/10/2013 Payroll 5/10/13 Salaries & Wages 103,628.79 6,034.07 109,662.86 PR 1521 05/24/2013 Payroll 5/24/13 Salaries & Wages 6,034.07 115,696.93 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 12,068.14 115,696.93 ** 196,781.00 Budgeted 81,084.07 Remaining 59 % Used Account: 135-50010-020-000 Overtime 1420 05/10/2013 Payroll 5/10/13 Overtime 7,748.44 208.06 7,956.50 PR 1521 05/24/2013 Payroll 5/24/13 Overtime 400.86 8,357.36 PR _______________ Account: 135-50010-020-000 Overtime Totals: 608.92 8,357.36 ** 17,546.00 Budgeted 9,188.64 Remaining 48 % Used Account: 135-50016-020-000 Longevity 2,857.50 .00 2,857.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,857.50 ** 2,858.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1521 05/24/2013 Payroll 5/24/13 Certification 2,400.00 300.00 2,700.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 300.00 2,700.00 ** 4,200.00 Budgeted 1,500.00 Remaining 64 % Used Account: 135-50020-020-000 Retirement 1420 05/10/2013 Payroll 5/10/13 Retirement 38,778.92 560.55 39,339.47 PR 1521 05/24/2013 Payroll 5/24/13 Retirement 604.79 39,944.26 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,165.34 39,944.26 ** 54,844.00 Budgeted 14,899.74 Remaining 73 % Used Account: 135-50026-020-000 Medical Insurance 1420 05/10/2013 Payroll 5/10/13 Medical Insurance 19,626.33 1,382.37 21,008.70 PR 1521 05/24/2013 Payroll 5/24/13 Medical Insurance 1,382.37 22,391.07 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,764.74 22,391.07 ** 29,034.00 Budgeted 6,642.93 Remaining 77 % Used TCMUD#1 Page 175 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 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 1420 05/10/2013 Payroll 5/10/13 Dental Insurance 1,400.96 97.79 1,498.75 PR 1521 05/24/2013 Payroll 5/24/13 Dental Insurance 97.77 1,596.52 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 195.56 1,596.52 ** 2,112.00 Budgeted 515.48 Remaining 76 % Used Account: 135-50028-020-000 Vision Insurance 1420 05/10/2013 Payroll 5/10/13 Vision Insurance 351.11 20.59 371.70 PR 1521 05/24/2013 Payroll 5/24/13 Vision Insurance 20.56 392.26 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 41.15 392.26 ** 552.00 Budgeted 159.74 Remaining 71 % Used Account: 135-50029-020-000 Life Insurance & Other 1420 05/10/2013 Payroll 5/10/13 Life Insurance & Other 927.91 64.17 992.08 PR 1525 05/22/2013 May A/P FSA-Monthly Adm 15.75 1,007.83 Discovery Benefits 32599 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 79.92 1,007.83 ** 1,377.00 Budgeted 369.17 Remaining 73 % Used Account: 135-50030-020-000 Social Security Taxes 1420 05/10/2013 Payroll 5/10/13 Social Security Taxes 6,458.19 326.05 6,784.24 PR 1521 05/24/2013 Payroll 5/24/13 Social Security Taxes 353.16 7,137.40 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 679.21 7,137.40 ** 13,268.00 Budgeted 6,130.60 Remaining 54 % Used Account: 135-50035-020-000 Medicare Taxes 1420 05/10/2013 Payroll 5/10/13 Medicare Taxes 1,510.37 76.25 1,586.62 PR 1521 05/24/2013 Payroll 5/24/13 Medicare Taxes 82.60 1,669.22 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 158.85 1,669.22 ** 3,103.00 Budgeted 1,433.78 Remaining 54 % Used Account: 135-50040-020-000 Unemployment Taxes 1485 05/17/2013 1st Qtr Town TWC Correction 309.05 (263.64) 45.41 GL TCMUD#1 Page 176 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 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: (263.64) 45.41 ** 756.00 Budgeted 710.59 Remaining 6 % Used Account: 135-50045-020-000 Workman's Compensation 1495 05/14/2013 Town Bill-W/C Audit Refnd 2012 5,409.27 551.00 5,960.27 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 551.00 5,960.27 ** 2,939.00 Budgeted (3,021.27) Remaining 203 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 126.00 .00 126.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 126.00 ** 150.00 Budgeted 24.00 Remaining 84 % Used Account: 135-50070-020-000 Employee Relations 1644 05/26/2013 4/27-5/26 PCards SPLIT - 13550070020 (25%) 79.18 12.05 91.23 FUZZY'S TACO SHOP PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 12.05 91.23 ** 350.00 Budgeted 258.77 Remaining 26 % Used Account: 135-55070-020-000 Independent Labor 1447 05/13/2013 May A/P wwtp study and survey 66,000.00 9,560.00 75,560.00 THE WALLACE GROUP, INC. 32568 AP 1679 05/31/2013 May A/P WWTP 1,940.00 77,500.00 THE WALLACE GROUP, INC. 32685 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 11,500.00 77,500.00 ** 84,418.00 Budgeted 6,918.00 Remaining 92 % Used Account: 135-55080-020-000 Maintenance & Repairs 1447 05/13/2013 May A/P belt steering spring 40,193.05 28.22 40,221.27 ASHBROOK SIMON-HARTLEY 32522 AP 1447 05/13/2013 May A/P steering spring 28.22 40,249.49 ASHBROOK SIMON-HARTLEY 32522 AP 1447 05/13/2013 May A/P blower motor and repair 1,830.00 42,079.49 CONTINENTAL RELIABILITY LLC 32527 AP 1644 05/26/2013 4/27-5/26 PCards THE HOME DEPOT 6581 9.02 42,088.51 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 1,895.46 42,088.51 ** 41,205.00 Budgeted (883.51) Remaining 102 % Used TCMUD#1 Page 177 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 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 1447 05/13/2013 May A/P backhoe repair 3,633.13 1,150.77 4,783.90 LANDMARK EQUIPMENT, INC 32545 AP 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (575.37) 4,208.53 AR 1526 05/22/2013 May A/P MUD logos on vehicles 170.00 4,378.53 AUTO DESIGNS 32594 AP 1644 05/26/2013 4/27-5/26 PCards AUTOZONE #4206 11.98 4,390.51 AUTOZONE #4206 PC 1644 05/26/2013 4/27-5/26 PCards KWIK KAR OF GRAPEVINE 127.45 4,517.96 KWIK KAR OF GRAPEVINE PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 884.83 4,517.96 ** 3,350.00 Budgeted (1,167.96) Remaining 135 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,080.96 .00 1,080.96 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,080.96 ** 1,500.00 Budgeted 419.04 Remaining 72 % Used Account: 135-55125-020-000 Dumpster Services 1447 05/13/2013 May A/P sludge haul off 26,248.37 1,862.93 28,111.30 L.H. CHANEY MATERIALS, INC. 32544 AP 1447 05/13/2013 May A/P sludge haul off 2,673.81 30,785.11 L.H. CHANEY MATERIALS, INC. 32544 AP 1679 05/31/2013 May A/P sludge haul off 2,676.90 33,462.01 L.H. CHANEY MATERIALS, INC. 32659 AP 1679 05/31/2013 May A/P longofill bags 525.00 33,987.01 ANDRITZ SEPARATION INC 32640 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 7,738.64 33,987.01 ** 49,611.00 Budgeted 15,623.99 Remaining 69 % Used Account: 135-55135-020-000 Lab Analysis 1447 05/13/2013 May A/P lab testing supplies 15,827.65 176.00 16,003.65 OXIDOR LABORATORIES LLC 32552 AP 1447 05/13/2013 May A/P lab testing supplies 176.00 16,179.65 OXIDOR LABORATORIES LLC 32552 AP 1447 05/13/2013 May A/P lab testing 243.00 16,422.65 OXIDOR LABORATORIES LLC 32552 AP 1447 05/13/2013 May A/P lab testing 243.00 16,665.65 OXIDOR LABORATORIES LLC 32552 AP 1458 05/14/2013 May A/P lab testing 243.00 16,908.65 OXIDOR LABORATORIES LLC 32583 AP 1458 05/14/2013 May A/P lab testing 243.00 17,151.65 OXIDOR LABORATORIES LLC 32583 AP 1458 05/14/2013 May A/P lab testing 243.00 17,394.65 OXIDOR LABORATORIES LLC 32583 AP 1458 05/14/2013 May A/P lab testing 176.00 17,570.65 OXIDOR LABORATORIES LLC 32583 AP 1526 05/22/2013 May A/P Influent/Effluent testing 216.00 17,786.65 OXIDOR LABORATORIES LLC 32610 AP 1526 05/22/2013 May A/P Influent/Effluent testing 243.00 18,029.65 OXIDOR LABORATORIES LLC 32610 AP 1526 05/22/2013 May A/P Influent/Effluent testing 176.00 18,205.65 OXIDOR LABORATORIES LLC 32610 AP 1526 05/22/2013 May A/P Biomonitoring 1,080.00 19,285.65 HUTHER AND ASSOCIATES,INC 32603 AP 1526 05/22/2013 May A/P Effluent/Influent sampling 263.00 19,548.65 OXIDOR LABORATORIES LLC 32610 AP 1679 05/31/2013 May A/P lab testing 243.00 19,791.65 OXIDOR LABORATORIES LLC 32670 AP TCMUD#1 Page 178 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1679 05/31/2013 May A/P lab testing 15,827.65 176.00 19,967.65 OXIDOR LABORATORIES LLC 32670 AP 1679 05/31/2013 May A/P lab testing 375.00 20,342.65 OXIDOR LABORATORIES LLC 32670 AP 1679 05/31/2013 May A/P lab testing 176.00 20,518.65 OXIDOR LABORATORIES LLC 32670 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 4,691.00 20,518.65 ** 30,000.00 Budgeted 9,481.35 Remaining 68 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1525 05/22/2013 May A/P Verizon Inv#9703714888 1,239.63 168.70 1,408.33 TOWN OF TROPHY CLUB 32615 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 168.70 1,408.33 ** 3,981.00 Budgeted 2,572.67 Remaining 35 % Used Account: 135-60020-020-000 Electricity 1525 05/22/2013 May A/P Electricity 4/15-5/14 74,532.53 9,692.88 84,225.41 HUDSON ENERGY SERVICES, LLC 32602 AP _______________ Account: 135-60020-020-000 Electricity Totals: 9,692.88 84,225.41 ** 153,045.00 Budgeted 68,819.59 Remaining 55 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 161.45 .00 161.45 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 161.45 ** 200.00 Budgeted 38.55 Remaining 81 % Used Account: 135-60080-020-000 Schools & Training 1,071.66 .00 1,071.66 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 1,071.66 ** 3,272.00 Budgeted 2,200.34 Remaining 33 % Used Account: 135-60090-020-000 Safety Program 1458 05/14/2013 May A/P first aid supplies 71.47 71.47 CINTAS FAS LOCKBOX 636525 32580 AP _______________ Account: 135-60090-020-000 Safety Program Totals: 71.47 71.47 ** .00 Budgeted (71.47) Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem TCMUD#1 Page 179 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1644 05/26/2013 4/27-5/26 PCards HAMPTON INN HOTELS 2,202.66 166.14 2,368.80 HAMPTON INN HOTELS PC 1644 05/26/2013 4/27-5/26 PCards HOLIDAY INNS 151.42 2,520.22 HOLIDAY INNS PC 1644 05/26/2013 4/27-5/26 PCards SOUTHWEST AIRLINES 200.90 2,721.12 SOUTHWEST AIRLINES PC 1644 05/26/2013 4/27-5/26 PCards AMERICAN AIRLINES 429.80 3,150.92 AMERICAN AIRLINES PC 1644 05/26/2013 4/27-5/26 PCards AMERICAN AIRLINES 106.02 3,256.94 AMERICAN AIRLINES PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 1,054.28 3,256.94 ** 1,400.00 Budgeted (1,856.94) Remaining 233 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1,123.00 .00 1,123.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1,123.00 ** 1,500.00 Budgeted 377.00 Remaining 75 % Used Account: 135-60125-020-000 Advertising 112.50 .00 112.50 _______________ Account: 135-60125-020-000 Advertising Totals: .00 112.50 ** 300.00 Budgeted 187.50 Remaining 38 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 7,887.19 .00 7,887.19 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 7,887.19 ** 15,600.00 Budgeted 7,712.81 Remaining 51 % Used Account: 135-60136-020-000 TCEQ Environmental Proj (SEP) 1673 05/31/2013 May A/P Agreed Order assessing Adm Pen 40,400.00 40,400.00 Tx Assoc of Resource of 32637 AP _______________ Account: 135-60136-020-000 TCEQ Environmental Proj (SEP) Totals: 40,400.00 40,400.00 ** 40,400.00 Budgeted .00 Remaining 100 % Used Account: 135-60243-020-000 Prior Year Expense 801.59 .00 801.59 _______________ Account: 135-60243-020-000 Prior Year Expense Totals: .00 801.59 ** 802.00 Budgeted .41 Remaining 100 % Used TCMUD#1 Page 180 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-020-000 Miscellaneous Expenses 1644 05/26/2013 4/27-5/26 PCards WAL-MART #5247 148.10 58.46 206.56 WAL-MART #5247 PC 1644 05/26/2013 4/27-5/26 PCards WAL-MART #5247 54.00 260.56 WAL-MART #5247 PC 1644 05/26/2013 4/27-5/26 PCards WAL-MART #5247 (58.46) 202.10 WAL-MART #5247 PC _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 54.00 202.10 ** 200.00 Budgeted (2.10) Remaining 101 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 412.23 .00 412.23 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 412.23 ** 500.00 Budgeted 87.77 Remaining 82 % Used Account: 135-65005-020-000 Fuel & Lube 1644 05/26/2013 4/27-5/26 PCards CHEVRON 0302418 7,060.95 72.00 7,132.95 CHEVRON 0302418 PC _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 72.00 7,132.95 ** 10,527.00 Budgeted 3,394.05 Remaining 68 % Used Account: 135-65010-020-000 Uniforms 1447 05/13/2013 May A/P uniform shirts-karl 773.70 150.00 923.70 PANDA EMBROIDERY 32553 AP 1458 05/14/2013 May A/P shirts=lance & jason 280.00 1,203.70 PANDA EMBROIDERY 32584 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 430.00 1,203.70 ** 1,574.00 Budgeted 370.30 Remaining 76 % Used Account: 135-65030-020-000 Chemicals 1447 05/13/2013 May A/P 450 lb drums 20,030.90 1,080.00 21,110.90 POLYDYNE, INC 32554 AP 1679 05/31/2013 May A/P HTH buckets-WWTP 1,680.00 22,790.90 HARCROS CHEMICALS INC 32653 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,760.00 22,790.90 ** 38,346.00 Budgeted 15,555.10 Remaining 59 % Used Account: 135-65035-020-000 Small Tools 1644 05/26/2013 4/27-5/26 PCards THE HOME DEPOT 6581 333.47 65.91 399.38 THE HOME DEPOT 6581 PC 1644 05/26/2013 4/27-5/26 PCards THE HOME DEPOT 6581 69.67 469.05 THE HOME DEPOT 6581 PC TCMUD#1 Page 181 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-020-000 Small Tools Totals: 135.58 469.05 ** 1,000.00 Budgeted 530.95 Remaining 47 % Used Account: 135-65040-020-000 Safety Equipment 1679 05/31/2013 May A/P first aid supplies 483.26 43.44 526.70 CINTAS FAS LOCKBOX 636525 32645 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 43.44 526.70 ** 500.00 Budgeted (26.70) Remaining 105 % Used Account: 135-65045-020-000 Lab Supplies 1447 05/13/2013 May A/P ldo probe 11,199.47 268.04 11,467.51 HACH COMPANY 32538 AP 1447 05/13/2013 May A/P ldo probe 750.00 12,217.51 HACH COMPANY 32538 AP 1526 05/22/2013 May A/P Water for lab 29.89 12,247.40 OZARKA DIRECT 32611 AP 1644 05/26/2013 4/27-5/26 PCards HACH COMPANY 747.95 12,995.35 HACH COMPANY PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,795.88 12,995.35 ** 10,000.00 Budgeted (2,995.35) Remaining 130 % Used Account: 135-69005-020-000 Capital Expenses 442,195.29 .00 442,195.29 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 442,195.29 ** 446,484.00 Budgeted 4,288.71 Remaining 99 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,018,114.16 ** 1,269,585.00 Budgeted 251,470.84 Remaining 80 % Used TCMUD#1 Page 182 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2013 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 1420 05/10/2013 Payroll 5/10/13 Salaries & Wages 83,121.39 5,891.37 89,012.76 PR 1521 05/24/2013 Payroll 5/24/13 Salaries & Wages 5,891.37 94,904.13 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,782.74 94,904.13 ** 156,475.00 Budgeted 61,570.87 Remaining 61 % Used Account: 135-50010-021-000 Overtime 1420 05/10/2013 Payroll 5/10/13 Overtime 5,722.44 425.47 6,147.91 PR 1521 05/24/2013 Payroll 5/24/13 Overtime 217.55 6,365.46 PR _______________ Account: 135-50010-021-000 Overtime Totals: 643.02 6,365.46 ** 12,158.00 Budgeted 5,792.54 Remaining 52 % Used Account: 135-50016-021-000 Longevity 3,817.50 .00 3,817.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 3,817.50 ** 3,818.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 1521 05/24/2013 Payroll 5/24/13 Certification 1,000.00 150.00 1,150.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,150.00 ** 1,800.00 Budgeted 650.00 Remaining 64 % Used Account: 135-50020-021-000 Retirement 1420 05/10/2013 Payroll 5/10/13 Retirement 30,420.88 567.26 30,988.14 PR 1521 05/24/2013 Payroll 5/24/13 Retirement 562.05 31,550.19 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,129.31 31,550.19 ** 42,910.00 Budgeted 11,359.81 Remaining 74 % Used Account: 135-50026-021-000 Medical Insurance 1420 05/10/2013 Payroll 5/10/13 Medical Insurance 14,335.44 1,160.78 15,496.22 PR 1521 05/24/2013 Payroll 5/24/13 Medical Insurance 1,160.77 16,656.99 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,321.55 16,656.99 ** 25,940.00 Budgeted 9,283.01 Remaining 64 % Used TCMUD#1 Page 183 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2013 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 1420 05/10/2013 Payroll 5/10/13 Dental Insurance 1,012.96 79.95 1,092.91 PR 1521 05/24/2013 Payroll 5/24/13 Dental Insurance 79.93 1,172.84 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 159.88 1,172.84 ** 1,812.00 Budgeted 639.16 Remaining 65 % Used Account: 135-50028-021-000 Vision Insurance 1420 05/10/2013 Payroll 5/10/13 Vision Insurance 219.52 16.31 235.83 PR 1521 05/24/2013 Payroll 5/24/13 Vision Insurance 16.29 252.12 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 32.60 252.12 ** 383.00 Budgeted 130.88 Remaining 66 % Used Account: 135-50029-021-000 Life Insurance & Other 1420 05/10/2013 Payroll 5/10/13 Life Insurance & Other 675.11 59.53 734.64 PR 1525 05/22/2013 May A/P FSA-Monthly Adm 5.25 739.89 Discovery Benefits 32599 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 64.78 739.89 ** 1,223.00 Budgeted 483.11 Remaining 60 % Used Account: 135-50030-021-000 Social Security Taxes 1420 05/10/2013 Payroll 5/10/13 Social Security Taxes 5,580.00 359.04 5,939.04 PR 1521 05/24/2013 Payroll 5/24/13 Social Security Taxes 353.32 6,292.36 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 712.36 6,292.36 ** 10,502.00 Budgeted 4,209.64 Remaining 60 % Used Account: 135-50035-021-000 Medicare Taxes 1420 05/10/2013 Payroll 5/10/13 Medicare Taxes 1,304.98 83.97 1,388.95 PR 1521 05/24/2013 Payroll 5/24/13 Medicare Taxes 82.63 1,471.58 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 166.60 1,471.58 ** 2,456.00 Budgeted 984.42 Remaining 60 % Used Account: 135-50040-021-000 Unemployment Taxes 1485 05/17/2013 1st Qtr Town TWC Correction 241.27 (206.88) 34.39 GL TCMUD#1 Page 184 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2013 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-021-000 Unemployment Taxes Totals: (206.88) 34.39 ** 567.00 Budgeted 532.61 Remaining 6 % Used Account: 135-50045-021-000 Workman's Compensation 1495 05/14/2013 Town Bill-W/C Audit Refnd 2012 4,344.88 552.00 4,896.88 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 552.00 4,896.88 ** 3,348.00 Budgeted (1,548.88) Remaining 146 % Used Account: 135-50070-021-000 Employee Relations 1644 05/26/2013 4/27-5/26 PCards SPLIT - 13550070021 (25%) 95.95 12.05 108.00 FUZZY'S TACO SHOP PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 12.05 108.00 ** 250.00 Budgeted 142.00 Remaining 43 % Used Account: 135-55080-021-000 Maintenance & Repairs 1447 05/13/2013 May A/P key pad ls #8 14,946.18 147.11 15,093.29 XYLEM WATER SOLUTIONS USA INC 32576 AP 1447 05/13/2013 May A/P floats for lift station 311.80 15,405.09 HD SUPPLY FACILITIES MAINT LTD 32539 AP 1447 05/13/2013 May A/P floats for lift stations 291.43 15,696.52 HD SUPPLY FACILITIES MAINT LTD 32539 AP 1455 05/14/2013 May A/P ls #8 cover plate 124.00 15,820.52 XYLEM WATER SOLUTIONS USA INC 32588 AP 1644 05/26/2013 4/27-5/26 PCards ALLIED ELECTRONICS INC 82.34 15,902.86 ALLIED ELECTRONICS INC PC 1644 05/26/2013 4/27-5/26 PCards ROANOKE WINNELSON CO 59.92 15,962.78 ROANOKE WINNELSON CO PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 1,016.60 15,962.78 ** 20,000.00 Budgeted 4,037.22 Remaining 80 % Used Account: 135-55090-021-000 Vehicle Maintenance 1447 05/13/2013 May A/P bulb oil 1,041.26 47.97 1,089.23 ROANOKE AUTO SUPPLY 32557 AP 1458 05/14/2013 May A/P Logo-Vac truck 85.00 1,174.23 AUTO DESIGNS 32579 AP 1526 05/22/2013 May A/P MUD logos on vehicles 170.00 1,344.23 AUTO DESIGNS 32594 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 302.97 1,344.23 ** 1,600.00 Budgeted 255.77 Remaining 84 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 1525 05/22/2013 May A/P Verizon Inv#9703714888 1,362.51 217.94 1,580.45 TOWN OF TROPHY CLUB 32615 AP TCMUD#1 Page 185 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 217.94 1,580.45 ** 3,500.00 Budgeted 1,919.55 Remaining 45 % Used Account: 135-60020-021-000 Electricity 1447 05/13/2013 May A/P electric-municipal utility sou 10,466.59 172.99 10,639.58 TRI COUNTY ELECTRIC 32570 AP 1447 05/13/2013 May A/P electricty-tw king road 313.45 10,953.03 TRI COUNTY ELECTRIC 32570 AP 1447 05/13/2013 May A/P 28.12 10,981.15 TRI COUNTY ELECTRIC 32570 AP 1525 05/22/2013 May A/P Electricity 4/15-5/14 627.52 11,608.67 HUDSON ENERGY SERVICES, LLC 32602 AP 1525 05/22/2013 May A/P Electricity 4/15-5/14 467.11 12,075.78 HUDSON ENERGY SERVICES, LLC 32602 AP 1525 05/22/2013 May A/P PID Lift station 8 Electricity 54.42 12,130.20 HUDSON ENERGY SERVICES, LLC 32602 AP 1553 05/24/2013 Bill Town Inv 1032-1035 AR 20130524-20130524 User: (150.84) 11,979.36 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,512.77 11,979.36 ** 18,705.00 Budgeted 6,725.64 Remaining 64 % Used Account: 135-60070-021-000 Dues & Memberships 250.00 .00 250.00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 250.00 ** 250.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-021-000 Schools & Training 830.00 .00 830.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 830.00 ** 826.00 Budgeted (4.00) Remaining 100 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 1644 05/26/2013 4/27-5/26 PCards HAMPTON INN HOTELS 1,574.47 166.14 1,740.61 HAMPTON INN HOTELS PC 1644 05/26/2013 4/27-5/26 PCards HOLIDAY INNS 151.42 1,892.03 HOLIDAY INNS PC 1644 05/26/2013 4/27-5/26 PCards SOUTHWEST AIRLINES 200.90 2,092.93 SOUTHWEST AIRLINES PC TCMUD#1 Page 186 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-021-000 Travel & per diem Totals: 518.46 2,092.93 ** 450.00 Budgeted (1,642.93) Remaining 465 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60243-021-000 Prior Year Expense 620.83 .00 620.83 _______________ Account: 135-60243-021-000 Prior Year Expense Totals: .00 620.83 ** 621.00 Budgeted .17 Remaining 100 % Used Account: 135-60245-021-000 Miscellaneous Expenses .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 5,576.47 .00 5,576.47 _______________ Account: 135-65005-021-000 Fuel & Lube Totals: .00 5,576.47 ** 12,117.00 Budgeted 6,540.53 Remaining 46 % Used Account: 135-65010-021-000 Uniforms 934.13 .00 934.13 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 934.13 ** 2,220.00 Budgeted 1,285.87 Remaining 42 % Used Account: 135-65030-021-000 Chemicals 2,221.00 .00 2,221.00 TCMUD#1 Page 187 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65030-021-000 Chemicals Totals: .00 2,221.00 ** 7,500.00 Budgeted 5,279.00 Remaining 30 % Used Account: 135-65035-021-000 Small Tools 70.00 .00 70.00 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 70.00 ** 1,250.00 Budgeted 1,180.00 Remaining 6 % Used Account: 135-65040-021-000 Safety Equipment 120.00 .00 120.00 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 120.00 ** 500.00 Budgeted 380.00 Remaining 24 % Used Account: 135-69005-021-000 Capital Expenses 1577 05/31/2013 May A/P Scada software upgrade due to 2,276.00 2,276.00 DHS AUTOMATION, INC 32626 AP 1577 05/31/2013 May A/P Scada system for Lift Station 13,000.00 15,276.00 DHS AUTOMATION, INC 32626 AP _______________ Account: 135-69005-021-000 Capital Expenses Totals: 15,276.00 15,276.00 ** 90,000.00 Budgeted 74,724.00 Remaining 17 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 40,260.00 Budgeted 40,260.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 228,270.51 ** 473,841.00 Budgeted 245,570.49 Remaining 48 % Used TCMUD#1 Page 188 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2013 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 1420 05/10/2013 Payroll 5/10/13 Salaries & Wages 5,600.00 900.00 6,500.00 PR 1521 05/24/2013 Payroll 5/24/13 Salaries & Wages 600.00 7,100.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,500.00 7,100.00 ** 10,000.00 Budgeted 2,900.00 Remaining 71 % Used Account: 135-50030-026-000 Social Security Taxes 1420 05/10/2013 Payroll 5/10/13 Social Security Taxes 347.20 55.80 403.00 PR 1521 05/24/2013 Payroll 5/24/13 Social Security Taxes 37.20 440.20 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 93.00 440.20 ** 620.00 Budgeted 179.80 Remaining 71 % Used Account: 135-50035-026-000 Medicare Taxes 1420 05/10/2013 Payroll 5/10/13 Medicare Taxes 81.20 13.05 94.25 PR 1521 05/24/2013 Payroll 5/24/13 Medicare Taxes 8.70 102.95 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 21.75 102.95 ** 145.00 Budgeted 42.05 Remaining 71 % Used Account: 135-50040-026-000 Unemployment Taxes 1420 05/10/2013 Payroll 5/10/13 Unemployment Taxes 64.40 .90 65.30 PR 1521 05/24/2013 Payroll 5/24/13 Unemployment Taxes .60 65.90 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.50 65.90 ** 210.00 Budgeted 144.10 Remaining 31 % Used Account: 135-50045-026-000 Workman's Compensation 1495 05/14/2013 Town Bill-W/C Audit Refnd 2012 15.70 (7.82) 7.88 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: (7.82) 7.88 ** 150.00 Budgeted 142.12 Remaining 5 % 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 TCMUD#1 Page 189 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships 42.00 .00 42.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 42.00 ** 2,100.00 Budgeted 2,058.00 Remaining 2 % Used Account: 135-60075-026-000 Meetings 434.97 .00 434.97 _______________ Account: 135-60075-026-000 Meetings Totals: .00 434.97 ** 1,200.00 Budgeted 765.03 Remaining 36 % Used Account: 135-60080-026-000 Schools & Training 1679 05/31/2013 May A/P 2013 AWBD Annual Conference-Ji 2,260.00 395.00 2,655.00 AWBD 32641 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 395.00 2,655.00 ** 4,000.00 Budgeted 1,345.00 Remaining 66 % Used Account: 135-60100-026-000 Travel & per diem 1644 05/26/2013 4/27-5/26 PCards HAMPTON INN HOTELS 2,341.88 166.14 2,508.02 HAMPTON INN HOTELS PC 1644 05/26/2013 4/27-5/26 PCards HAMPTON INN HOTELS 166.14 2,674.16 HAMPTON INN HOTELS PC 1644 05/26/2013 4/27-5/26 PCards HOLIDAY INNS 151.42 2,825.58 HOLIDAY INNS PC 1644 05/26/2013 4/27-5/26 PCards HOLIDAY INNS 151.42 2,977.00 HOLIDAY INNS PC 1644 05/26/2013 4/27-5/26 PCards SOUTHWEST AIRLINES 200.90 3,177.90 SOUTHWEST AIRLINES PC 1644 05/26/2013 4/27-5/26 PCards SOUTHWEST AIRLINES 200.90 3,378.80 SOUTHWEST AIRLINES PC 1644 05/26/2013 4/27-5/26 PCards AMERICAN AIRLINES 429.80 3,808.60 AMERICAN AIRLINES PC 1644 05/26/2013 4/27-5/26 PCards AMERICAN AIRLINES 106.02 3,914.62 AMERICAN AIRLINES PC 1644 05/26/2013 4/27-5/26 PCards DELTA 191.60 4,106.22 DELTA PC _______________ Account: 135-60100-026-000 Travel & per diem Totals: 1,764.34 4,106.22 ** 5,000.00 Budgeted 893.78 Remaining 82 % Used Account: 135-60243-026-000 Prior Year Expense 107.10 .00 107.10 _______________ Account: 135-60243-026-000 Prior Year Expense Totals: .00 107.10 ** .00 Budgeted (107.10) Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses TCMUD#1 Page 190 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1644 05/26/2013 4/27-5/26 PCards WAL-MART #5985 252.44 15.44 267.88 WAL-MART #5985 PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 15.44 267.88 ** 3,000.00 Budgeted 2,732.12 Remaining 9 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 15,330.10 ** 26,575.00 Budgeted 11,244.90 Remaining 58 % Used TCMUD#1 Page 191 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 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 1420 05/10/2013 Payroll 5/10/13 Salaries & Wages 240,792.66 16,574.78 257,367.44 PR 1521 05/24/2013 Payroll 5/24/13 Salaries & Wages 16,578.13 273,945.57 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,152.91 273,945.57 ** 444,730.00 Budgeted 170,784.43 Remaining 62 % Used Account: 135-50010-030-000 Overtime 1420 05/10/2013 Payroll 5/10/13 Overtime 200.83 10.41 211.24 PR 1521 05/24/2013 Payroll 5/24/13 Overtime 22.69 233.93 PR _______________ Account: 135-50010-030-000 Overtime Totals: 33.10 233.93 ** 1,500.00 Budgeted 1,266.07 Remaining 16 % Used Account: 135-50016-030-000 Longevity 2,317.50 .00 2,317.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 2,317.50 ** 2,318.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1420 05/10/2013 Payroll 5/10/13 Retirement 72,362.60 1,489.35 73,851.95 PR 1521 05/24/2013 Payroll 5/24/13 Retirement 1,490.75 75,342.70 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,980.10 75,342.70 ** 104,801.00 Budgeted 29,458.30 Remaining 72 % Used Account: 135-50026-030-000 Medical Insurance 1420 05/10/2013 Payroll 5/10/13 Medical Insurance 27,108.30 2,194.07 29,302.37 PR 1521 05/24/2013 Payroll 5/24/13 Medical Insurance 2,194.03 31,496.40 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 31,496.40 ** 49,049.00 Budgeted 17,552.60 Remaining 64 % Used Account: 135-50027-030-000 Dental Insurance 1420 05/10/2013 Payroll 5/10/13 Dental Insurance 2,411.52 193.19 2,604.71 PR 1521 05/24/2013 Payroll 5/24/13 Dental Insurance 193.15 2,797.86 PR TCMUD#1 Page 192 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 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: 386.34 2,797.86 ** 3,379.00 Budgeted 581.14 Remaining 83 % Used Account: 135-50028-030-000 Vision Insurance 1420 05/10/2013 Payroll 5/10/13 Vision Insurance 528.64 41.29 569.93 PR 1521 05/24/2013 Payroll 5/24/13 Vision Insurance 41.24 611.17 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 611.17 ** 945.00 Budgeted 333.83 Remaining 65 % Used Account: 135-50029-030-000 Life Insurance & Other 1420 05/10/2013 Payroll 5/10/13 Life Insurance & Other 1,723.09 136.33 1,859.42 PR 1525 05/22/2013 May A/P FSA-Monthly Adm 36.75 1,896.17 Discovery Benefits 32599 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 173.08 1,896.17 ** 2,582.00 Budgeted 685.83 Remaining 73 % Used Account: 135-50030-030-000 Social Security Taxes 1420 05/10/2013 Payroll 5/10/13 Social Security Taxes 14,497.47 958.23 15,455.70 PR 1521 05/24/2013 Payroll 5/24/13 Social Security Taxes 954.66 16,410.36 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,912.89 16,410.36 ** 27,802.00 Budgeted 11,391.64 Remaining 59 % Used Account: 135-50035-030-000 Medicare Taxes 1420 05/10/2013 Payroll 5/10/13 Medicare Taxes 3,390.54 224.10 3,614.64 PR 1521 05/24/2013 Payroll 5/24/13 Medicare Taxes 223.27 3,837.91 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 447.37 3,837.91 ** 6,502.00 Budgeted 2,664.09 Remaining 59 % Used Account: 135-50040-030-000 Unemployment Taxes 1485 05/17/2013 1st Qtr Town TWC Correction 954.41 (515.12) 439.29 GL _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: (515.12) 439.29 ** 1,537.00 Budgeted 1,097.71 Remaining 29 % Used TCMUD#1 Page 193 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 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 1495 05/14/2013 Town Bill-W/C Audit Refnd 2012 840.48 98.12 938.60 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 98.12 938.60 ** 831.00 Budgeted (107.60) Remaining 113 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 39.00 .00 39.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 39.00 ** 250.00 Budgeted 211.00 Remaining 16 % Used Account: 135-50070-030-000 Employee Relations 1644 05/26/2013 4/27-5/26 PCards TOM THUMB STOR00017897 2,724.17 3.79 2,727.96 TOM THUMB STOR00017897 PC 1644 05/26/2013 4/27-5/26 PCards SPLIT - 13550070030 (25%) 12.03 2,739.99 FUZZY'S TACO SHOP PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 15.82 2,739.99 ** 5,000.00 Budgeted 2,260.01 Remaining 55 % Used Account: 135-55030-030-000 Software & Support 1447 05/13/2013 May A/P annual software renew 26,473.29 13,365.00 39,838.29 STW INC 32562 AP 1447 05/13/2013 May A/P april pcard reimbursement-mike 53.38 39,891.67 TOWN OF TROPHY CLUB 32569 AP 1447 05/13/2013 May A/P april pcard reimbursement-mike 65.44 39,957.11 TOWN OF TROPHY CLUB 32569 AP 1447 05/13/2013 May A/P april pcard reimbursement-mike 25.00 39,982.11 TOWN OF TROPHY CLUB 32569 AP 1574 05/30/2013 May A/P monthly isp charges 659.06 40,641.17 TOWN OF TROPHY CLUB 32635 AP 1574 05/30/2013 May A/P clear rec bank rec software 600.00 41,241.17 CONWAY CONSULTING 32625 AP 1574 05/30/2013 May A/P monthly isp fees/bandwith 392.24 41,633.41 TOWN OF TROPHY CLUB 32635 AP 1577 05/31/2013 May A/P Attendance Enterprise upgrade 3,256.50 44,889.91 TOWN OF TROPHY CLUB 32635 AP 1673 05/31/2013 May A/P IT May PCards 25.00 44,914.91 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1673 05/31/2013 May A/P IT May PCards 95.01 45,009.92 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1673 05/31/2013 May A/P IT May PCards 197.00 45,206.92 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1673 05/31/2013 May A/P IT May PCards 53.38 45,260.30 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1673 05/31/2013 May A/P IT May PCards 64.99 45,325.29 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1679 05/31/2013 May A/P STW Support-January 3,386.65 48,711.94 STW INC 32681 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 22,238.65 48,711.94 ** 63,555.00 Budgeted 14,843.06 Remaining 77 % Used Account: 135-55070-030-000 Independent Labor TCMUD#1 Page 194 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 598.75 .00 598.75 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 598.75 ** 7,700.00 Budgeted 7,101.25 Remaining 8 % Used Account: 135-55075-030-000 Records Management .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 810.52 .00 810.52 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 810.52 ** 811.00 Budgeted .48 Remaining 100 % Used Account: 135-55100-030-000 Building Maint & Supplies 1447 05/13/2013 May A/P rug service 3,497.52 420.75 3,918.27 G & K SERVICES 32536 AP 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (210.37) 3,707.90 AR 1525 05/22/2013 May A/P Re-key doors 183.95 3,891.85 MICHAEL'S KEYS 32608 AP 1528 05/22/2013 May A/P Re-key door 77.50 3,969.35 MICHAEL'S KEYS 32608 AP 1679 05/31/2013 May A/P Rug service 84.15 4,053.50 G & K SERVICES 32651 AP 1679 05/31/2013 May A/P rug service 84.15 4,137.65 G & K SERVICES 32651 AP 1679 05/31/2013 May A/P rug service 84.15 4,221.80 G & K SERVICES 32651 AP 1679 05/31/2013 May A/P rug service 84.15 4,305.95 G & K SERVICES 32651 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 808.43 4,305.95 ** 6,500.00 Budgeted 2,194.05 Remaining 66 % Used Account: 135-55120-030-000 Cleaning Services 12,197.25 .00 12,197.25 _______________ Account: 135-55120-030-000 Cleaning Services Totals: .00 12,197.25 ** 20,200.00 Budgeted 8,002.75 Remaining 60 % Used Account: 135-55160-030-000 Professional Outside Services 6,974.00 .00 6,974.00 TCMUD#1 Page 195 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 6,974.00 ** 15,000.00 Budgeted 8,026.00 Remaining 46 % Used Account: 135-55161-030-000 Outside Services-Town Semo 85,465.00 .00 85,465.00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 85,465.00 ** 85,465.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees 159.77 .00 159.77 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 159.77 ** 160.00 Budgeted .23 Remaining 100 % Used Account: 135-55205-030-000 Utility Billing Contract 1447 05/13/2013 May A/P 3,747.21 611.28 4,358.49 DP2 BILLING SOLUTIONS, LLC 32533 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 611.28 4,358.49 ** 11,000.00 Budgeted 6,641.51 Remaining 40 % Used Account: 135-60005-030-000 Telephone 1447 05/13/2013 May A/P april pcard reimbursement-mike 5,598.26 383.44 5,981.70 TOWN OF TROPHY CLUB 32569 AP 1447 05/13/2013 May A/P april pcard reimbursement-mike 217.88 6,199.58 TOWN OF TROPHY CLUB 32569 AP 1447 05/13/2013 May A/P april pcard reimbursement-mike 396.78 6,596.36 TOWN OF TROPHY CLUB 32569 AP 1455 05/14/2013 May A/P answering service 340.29 6,936.65 KEYSTONE PARK SECRETARIAL 32581 AP 1574 05/30/2013 May A/P ansewring service-june 2013 186.84 7,123.49 KEYSTONE PARK SECRETARIAL 32628 AP 1673 05/31/2013 May A/P IT May PCards 119.25 7,242.74 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1673 05/31/2013 May A/P IT May PCards 228.34 7,471.08 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1673 05/31/2013 May A/P IT May PCards 392.37 7,863.45 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1673 05/31/2013 May A/P IT May PCards 373.13 8,236.58 TROPHY CLUB MUD (WATER BILLS) 32687 AP _______________ Account: 135-60005-030-000 Telephone Totals: 2,638.32 8,236.58 ** 10,500.00 Budgeted 2,263.42 Remaining 78 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1525 05/22/2013 May A/P Verizon Inv#9703714888 1,954.90 176.73 2,131.63 TOWN OF TROPHY CLUB 32615 AP TCMUD#1 Page 196 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1521 05/24/2013 Payroll 5/24/13 Communications/Pagers/Mobiles 1,954.90 150.00 2,281.63 PR 1644 05/26/2013 4/27-5/26 PCards SHELL OIL 415072200QPS 14.06 2,295.69 SHELL OIL 415072200QPS PC _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 340.79 2,295.69 ** 3,575.00 Budgeted 1,279.31 Remaining 64 % Used Account: 135-60020-030-000 Electricity/Gas 1525 05/22/2013 May A/P 3/13-4/15 Direct Energy 6,992.94 1,138.58 8,131.52 TOWN OF TROPHY CLUB 32615 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,138.58 8,131.52 ** 13,019.00 Budgeted 4,887.48 Remaining 62 % Used Account: 135-60025-030-000 Water 1447 05/13/2013 May A/P April water 497.28 135.72 633.00 TROPHY CLUB MUD (WATER BILLS) 32571 AP 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (67.86) 565.14 AR 1679 05/31/2013 May A/P May water bills 175.32 740.46 TROPHY CLUB MUD (WATER BILLS) 32687 AP _______________ Account: 135-60025-030-000 Water Totals: 243.18 740.46 ** 3,100.00 Budgeted 2,359.54 Remaining 24 % Used Account: 135-60030-030-000 Rent And/Or Usage 1447 05/13/2013 May A/P ps building rent 7,689.57 1,098.51 8,788.08 TOWN OF TROPHY CLUB 32569 AP _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 1,098.51 8,788.08 ** 13,182.00 Budgeted 4,393.92 Remaining 67 % Used Account: 135-60035-030-000 Postage 1447 05/13/2013 May A/P town shipment 15,041.68 35.53 15,077.21 FEDERAL EXPRESS CORP 32535 AP 1447 05/13/2013 May A/P special edition newsletter 971.17 16,048.38 COMPUTER EXTENSION SYS. INC 32526 AP 1447 05/13/2013 May A/P overnight letter 6.17 16,054.55 FEDERAL EXPRESS CORP 32535 AP 1447 05/13/2013 May A/P overnight letter 4.99 16,059.54 FEDERAL EXPRESS CORP 32535 AP 1447 05/13/2013 May A/P 1,546.44 17,605.98 DP2 BILLING SOLUTIONS, LLC 32533 AP 1477 05/15/2013 May A/P Permit 3 post card mailing/ans 842.00 18,447.98 U.S. POSTAL SERVICE 32590 AP 1482 05/15/2013 Recode Town Inv 1026 Fedex letter (35.53) 18,412.45 GL 1533 05/23/2013 Postage (6.11) 18,406.34 GL 1644 05/26/2013 4/27-5/26 PCards USPS 48764506630613152 20.00 18,426.34 USPS 48764506630613152 PC _______________ Account: 135-60035-030-000 Postage Totals: 3,384.66 18,426.34 ** 26,604.00 Budgeted 8,177.66 Remaining 69 % Used TCMUD#1 Page 197 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees 1625 05/31/2013 Bank and CC charges/May 16,212.04 53.57 16,265.61 GL 1625 05/31/2013 Bank and CC charges/May 78.80 16,344.41 GL 1625 05/31/2013 Bank and CC charges/May 1,771.49 18,115.90 GL 1625 05/31/2013 Bank and CC charges/May 250.00 18,365.90 GL 1626 05/31/2013 Reverse FF May interest Bank posted 6/2 rev from May (64.26) 18,301.64 GL 1627 05/31/2013 Reverse FF May int JE 1626 Bank posted 6/2 rev from May 64.26 18,365.90 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,153.86 18,365.90 ** 28,330.00 Budgeted 9,964.10 Remaining 65 % Used Account: 135-60050-030-000 Bad Debt Expense 85.44 .00 85.44 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 85.44 ** 8,500.00 Budgeted 8,414.56 Remaining 1 % Used Account: 135-60055-030-000 Insurance 1447 05/13/2013 May A/P notary bond 50,693.77 50.00 50,743.77 VICTOR O SCHINNERER & CO, INC 32573 AP _______________ Account: 135-60055-030-000 Insurance Totals: 50.00 50,743.77 ** 50,694.00 Budgeted (49.77) Remaining 100 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 833.50 .00 833.50 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 833.50 ** 834.00 Budgeted .50 Remaining 100 % Used Account: 135-60070-030-000 Dues & Memberships 3,891.95 .00 3,891.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 3,891.95 ** 3,892.00 Budgeted .05 Remaining 100 % Used Account: 135-60075-030-000 Meetings 283.85 .00 283.85 TCMUD#1 Page 198 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60075-030-000 Meetings Totals: .00 283.85 ** 400.00 Budgeted 116.15 Remaining 71 % Used Account: 135-60080-030-000 Schools & Training 1644 05/26/2013 4/27-5/26 PCards NCTCOG RTC TRAINING 2,405.00 250.00 2,655.00 NCTCOG RTC TRAINING PC 1574 05/30/2013 May A/P training on clearrec software 252.15 2,907.15 CONWAY COMPANY CPAs PC 32624 AP 1679 05/31/2013 May A/P Fund Financial Statement Train 487.50 3,394.65 LAFOLLETT & COMPANY PLLC 32660 AP _______________ Account: 135-60080-030-000 Schools & Training Totals: 989.65 3,394.65 ** 5,350.00 Budgeted 1,955.35 Remaining 63 % Used Account: 135-60100-030-000 Travel & per diem 1420 05/10/2013 Payroll 5/10/13 Travel & per diem 2,062.82 30.89 2,093.71 PR 1521 05/24/2013 Payroll 5/24/13 Travel & per diem 21.75 2,115.46 PR 1644 05/26/2013 4/27-5/26 PCards VARONAS 2.10 2,117.56 VARONAS PC 1644 05/26/2013 4/27-5/26 PCards HAMPTON INN HOTELS 166.14 2,283.70 HAMPTON INN HOTELS PC 1644 05/26/2013 4/27-5/26 PCards STARBUCKS TERM12261590 10.24 2,293.94 STARBUCKS TERM12261590 PC 1644 05/26/2013 4/27-5/26 PCards HOLIDAY INNS 151.42 2,445.36 HOLIDAY INNS PC 1644 05/26/2013 4/27-5/26 PCards THE PARKING SPOT 107 37.01 2,482.37 THE PARKING SPOT 107 PC 1644 05/26/2013 4/27-5/26 PCards AQUA TERRA 346.32 2,828.69 AQUA TERRA PC 1644 05/26/2013 4/27-5/26 PCards WENDY'S #5587 5.72 2,834.41 WENDY'S #5587 PC 1644 05/26/2013 4/27-5/26 PCards WAL-MART #5247 34.00 2,868.41 WAL-MART #5247 PC 1644 05/26/2013 4/27-5/26 PCards SOUTHWEST AIRLINES 200.90 3,069.31 SOUTHWEST AIRLINES PC 1644 05/26/2013 4/27-5/26 PCards AMERICAN AIRLINES 429.80 3,499.11 AMERICAN AIRLINES PC 1644 05/26/2013 4/27-5/26 PCards AMERICAN AIRLINES 106.02 3,605.13 AMERICAN AIRLINES PC 1679 05/31/2013 May A/P mileage-Terri Sisk 91.88 3,697.01 Terri Sisk 32684 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 1,634.19 3,697.01 ** 3,616.00 Budgeted (81.01) Remaining 102 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 893.40 .00 893.40 TCMUD#1 Page 199 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60125-030-000 Advertising Totals: .00 893.40 ** 4,000.00 Budgeted 3,106.60 Remaining 22 % Used Account: 135-60235-030-000 Security 1673 05/31/2013 May A/P IT May PCards 505.13 505.13 TROPHY CLUB MUD (WATER BILLS) 32687 AP _______________ Account: 135-60235-030-000 Security Totals: 505.13 505.13 ** 1,350.00 Budgeted 844.87 Remaining 37 % Used Account: 135-60243-030-000 Prior Year Expense 1456 05/14/2013 P/Y Exp from Due to/Froms P/R 1,263.01 2,027.57 3,290.58 GL _______________ Account: 135-60243-030-000 Prior Year Expense Totals: 2,027.57 3,290.58 ** 1,263.00 Budgeted (2,027.58) Remaining 261 % Used Account: 135-60245-030-000 Miscellaneous Expenses 1644 05/26/2013 4/27-5/26 PCards NORTH TEXAS SIGNS ROUT 282.12 650.00 932.12 NORTH TEXAS SIGNS ROUT PC 1644 05/26/2013 4/27-5/26 PCards VCN*DENTONCOCTR 30.50 962.62 VCN*DENTONCOCTR PC 1644 05/26/2013 4/27-5/26 PCards DAVID'S COOKIES - WEB 52.60 1,015.22 DAVID'S COOKIES - WEB PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 733.10 1,015.22 ** 13,500.00 Budgeted 12,484.78 Remaining 8 % 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-60281-030-000 Park Expenses 1525 05/22/2013 May A/P April Harmony Park 28,552.40 1,998.06 30,550.46 TOWN OF TROPHY CLUB 32615 AP _______________ Account: 135-60281-030-000 Park Expenses Totals: 1,998.06 30,550.46 ** 42,500.00 Budgeted 11,949.54 Remaining 72 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) TCMUD#1 Page 200 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1587 05/31/2013 Texpool xfer-PID Conn to I&S 161,000.00 161,000.00 GL _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: 161,000.00 161,000.00 ** .00 Budgeted (161,000.00) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1447 05/13/2013 May A/P color printer cartridges-karis 3,157.40 380.36 3,537.76 SHI GOVERNMENT SOLUTIONS,INC 32558 AP _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 380.36 3,537.76 ** 2,500.00 Budgeted (1,037.76) Remaining 142 % Used Account: 135-65010-030-000 Uniforms 624.12 .00 624.12 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 624.12 ** 1,635.00 Budgeted 1,010.88 Remaining 38 % Used Account: 135-65055-030-000 Hardware 1447 05/13/2013 May A/P acclaim networks inv#1302062 10,499.24 988.75 11,487.99 TOWN OF TROPHY CLUB 32569 AP 1525 05/22/2013 May A/P Shi invoies #GB00080220 & #GB0 55.50 11,543.49 TOWN OF TROPHY CLUB 32615 AP 1673 05/31/2013 May A/P IT May PCards 33.08 11,576.57 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1673 05/31/2013 May A/P IT May PCards 365.17 11,941.74 TROPHY CLUB MUD (WATER BILLS) 32687 AP _______________ Account: 135-65055-030-000 Hardware Totals: 1,442.50 11,941.74 ** 20,188.00 Budgeted 8,246.26 Remaining 59 % Used Account: 135-65085-030-000 Office Supplies 1447 05/13/2013 May A/P BOA pcards 4,684.57 71.30 4,755.87 TOWN OF TROPHY CLUB 32569 AP 1447 05/13/2013 May A/P BOA pcards 293.56 5,049.43 TOWN OF TROPHY CLUB 32569 AP 1455 05/14/2013 May A/P pcard reimbursement-karen moor 47.53 5,096.96 TOWN OF TROPHY CLUB 32586 AP 1455 05/14/2013 May A/P business cards-mike mcmahon 68.15 5,165.11 SIGMA SIGNS & PRINTING 32585 AP 1455 05/14/2013 May A/P reflective stickers 350.00 5,515.11 SIGMA SIGNS & PRINTING 32585 AP 1455 05/14/2013 May A/P office supplies 72.24 5,587.35 OFFICE DEPOT, INC 32582 AP 1455 05/14/2013 May A/P office supplies 56.10 5,643.45 OFFICE DEPOT, INC 32582 AP 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (72.24) 5,571.21 AR 1525 05/22/2013 May A/P Office Supplies 159.90 5,731.11 OFFICE DEPOT, INC 32609 AP 1525 05/22/2013 May A/P Paper 36.12 5,767.23 OFFICE DEPOT, INC 32609 AP 1525 05/22/2013 May A/P Postcards 402.75 6,169.98 DESKTOP PUBLISHING SUPPLIES 32597 AP 1528 05/22/2013 May A/P Office and maintenance supplie 7.13 6,177.11 OFFICE DEPOT, INC 32609 AP TCMUD#1 Page 201 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1553 05/24/2013 Bill Town Inv 1032-1035 AR 20130524-20130524 User: 4,684.57 (18.06) 6,159.05 AR 1644 05/26/2013 4/27-5/26 PCards CARBONLESS FORMS PRINT 111.50 6,270.55 CARBONLESS FORMS PRINT PC 1644 05/26/2013 4/27-5/26 PCards THE HOME DEPOT 6581 2.68 6,273.23 THE HOME DEPOT 6581 PC 1673 05/31/2013 May A/P IT May PCards 59.99 6,333.22 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1577 05/31/2013 May A/P Staples for copiers 55.50 6,388.72 TOWN OF TROPHY CLUB AP 1577 05/31/2013 May A/P Office supplies 60.13 6,448.85 OFFICE DEPOT, INC 32630 AP 1579 05/31/2013 Void Town Inv 05302013 Staples for copiers (55.50) 6,393.35 TOWN OF TROPHY CLUB AP 1580 05/31/2013 May A/P Staples for Copiers 43.69 6,437.04 TOWN OF TROPHY CLUB 32635 AP 1656 05/31/2013 Town Invoice 1036-38 AR 20130531-20130531 User: (18.06) 6,418.98 AR 1679 05/31/2013 May A/P office supplies-paper 72.24 6,491.22 OFFICE DEPOT, INC 32668 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 1,806.65 6,491.22 ** 8,200.00 Budgeted 1,708.78 Remaining 79 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1447 05/13/2013 May A/P shi inv#gb00078641 1,722.08 102.00 1,824.08 TOWN OF TROPHY CLUB 32569 AP 1447 05/13/2013 May A/P shi inv#GB00078941 142.50 1,966.58 TOWN OF TROPHY CLUB 32569 AP 1447 05/13/2013 May A/P shi inv#GB00079172 91.00 2,057.58 TOWN OF TROPHY CLUB 32569 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 335.50 2,057.58 ** 5,732.00 Budgeted 3,674.42 Remaining 36 % Used Account: 135-65095-030-000 Maintenance Supplies 1447 05/13/2013 May A/P BOA pcards 2,169.17 53.68 2,222.85 TOWN OF TROPHY CLUB 32569 AP 1455 05/14/2013 May A/P pcard reimbursement-karen moor 47.58 2,270.43 TOWN OF TROPHY CLUB 32586 AP 1475 05/15/2013 Town Billing Inv 1021-1029 AR 20130501-20130515 User: (140.82) 2,129.61 AR 1528 05/22/2013 May A/P Office and maintenance supplie 9.58 2,139.19 OFFICE DEPOT, INC 32609 AP 1553 05/24/2013 Bill Town Inv 1032-1035 AR 20130524-20130524 User: (4.79) 2,134.40 AR 1644 05/26/2013 4/27-5/26 PCards BIG LOTS STORES - #452 40.00 2,174.40 BIG LOTS STORES - #452 PC 1644 05/26/2013 4/27-5/26 PCards SPLIT - 13565095030 (64.66%) 168.29 2,342.69 SAMSCLUB #4795 PC 1656 05/31/2013 Town Invoice 1036-38 AR 20130531-20130531 User: (23.22) 2,319.47 AR _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 150.30 2,319.47 ** 1,500.00 Budgeted (819.47) Remaining 155 % Used Account: 135-65097-030-000 Vending Machine Supplies 1498 05/09/2013 WWTP Vending 50.32 50.32 GL _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: 50.32 50.32 ** 500.00 Budgeted 449.68 Remaining 10 % Used TCMUD#1 Page 202 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65105-030-000 Printing 1447 05/13/2013 May A/P special edition newsletter 395.00 761.19 1,156.19 COMPUTER EXTENSION SYS. INC 32526 AP _______________ Account: 135-65105-030-000 Printing Totals: 761.19 1,156.19 ** 4,200.00 Budgeted 3,043.81 Remaining 28 % Used Account: 135-69170-030-000 Copier Lease Installments 1447 05/13/2013 May A/P kyocera copier rent 1,541.10 256.85 1,797.95 TOWN OF TROPHY CLUB 32569 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 1,797.95 ** 3,450.00 Budgeted 1,652.05 Remaining 52 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 1588 05/31/2013 Transfer GASB 34 Replacement IT replacement 26,911.00 26,911.00 GL _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: 26,911.00 26,911.00 ** 26,911.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 958,685.00 ** 1,182,142.00 Budgeted 223,457.00 Remaining 81 % Used TCMUD#1 Page 203 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2013 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 1447 05/13/2013 May A/P april legal 135,512.10 2,007.50 137,519.60 THE LISTON LAW FIRM, P.C. 32567 AP 1525 05/22/2013 May A/P Legal-April 337.20 137,856.80 WHITAKER CHALK SWINDLE 32619 AP 1525 05/22/2013 May A/P Legal-April 30.00 137,886.80 WHITAKER CHALK SWINDLE 32619 AP 1525 05/22/2013 May A/P Legal-April 1,663.20 139,550.00 WHITAKER CHALK SWINDLE 32619 AP 1525 05/22/2013 May A/P Legal-April 1,932.00 141,482.00 WHITAKER CHALK SWINDLE 32619 AP 1525 05/22/2013 May A/P Legal-April 33.60 141,515.60 WHITAKER CHALK SWINDLE 32619 AP _______________ Account: 135-55045-039-000 Legal Totals: 6,003.50 141,515.60 ** 70,000.00 Budgeted (71,515.60) Remaining 202 % Used Account: 135-55055-039-000 Auditing 20,700.00 .00 20,700.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 20,700.00 ** 21,200.00 Budgeted 500.00 Remaining 98 % Used Account: 135-55060-039-000 Appraisal 6,209.06 .00 6,209.06 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,209.06 ** 15,100.00 Budgeted 8,890.94 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 2,356.39 .00 2,356.39 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,356.39 ** 3,800.00 Budgeted 1,443.61 Remaining 62 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 1630 05/31/2013 Xfer/Prime Interpl, Clear Fund 86,726.39 25,606.82 112,333.21 GL _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: 25,606.82 112,333.21 ** .00 Budgeted (112,333.21) Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 283,114.26 ** 110,100.00 Budgeted (173,014.26) Remaining 257 % Used TCMUD#1 Page 204 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 492,763.60 .00 Budgeted (492,763.60) Remaining 0 % Used TCMUD#1 Page 205 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49005-000-000 Loan Proceeds (445,000.00) .00 (445,000.00) _______________ Account: 507-49005-000-000 Loan Proceeds Totals: .00 (445,000.00) ** (445,000.00) Budgeted .00 Remaining 100 % Used Account: 507-49010-000-000 Interest Income 1583 05/31/2013 May bank interest (25.15) (24.18) (49.33) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (24.18) (49.33) ** (100.00) Budgeted (50.67) Remaining 49 % Used Department Totals: ------------------------------------------------------------------------------------------------ (445,049.33) ** (445,100.00) Budgeted (50.67) Remaining 100 % Used TCMUD#1 Page 206 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: Period Ending: 5/2013 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-000 Capital Repairs 1473 05/15/2013 Recode TNP inv/Ind Crk Waterli 2,663.28 (2,663.28) .00 GL _______________ Account: 507-69280-010-000 Capital Repairs Totals: (2,663.28) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 507-69005-010-001 Capital Expense 6,289.00 .00 6,289.00 _______________ Account: 507-69005-010-001 Capital Expense Totals: .00 6,289.00 ** 5,800.00 Budgeted (489.00) Remaining 108 % Used Account: 507-69280-010-002 Capital Repairs 1447 05/13/2013 May A/P engineering 12,350.00 12,350.00 DELTATEK ENGINEERING 32530 AP 1525 05/22/2013 May A/P ROFC-advertising of bids 1,096.00 13,446.00 STAR-TELEGRAM OPERATING LTD 32612 AP 1525 05/22/2013 May A/P ROFC Improvements 2,500.00 15,946.00 DELTATEK ENGINEERING 32596 AP _______________ Account: 507-69280-010-002 Capital Repairs Totals: 15,946.00 15,946.00 ** 165,000.00 Budgeted 149,054.00 Remaining 10 % Used Account: 507-69280-010-003 Capital Repairs 1473 05/15/2013 Recode TNP inv/Ind Crk Waterli 3,800.00 2,663.28 6,463.28 GL 1525 05/22/2013 May A/P Indian Creek Waterline Replace 2,616.05 9,079.33 TEAGUE, NALL & PERKINS,INC 32614 AP 1547 05/22/2013 Void A/P Check 32614/TN&P Indian Creek Waterline Replace (2,616.05) 6,463.28 TEAGUE, NALL & PERKINS,INC 32614 AP 1574 05/30/2013 May A/P indian creek waterline replace 2,616.05 9,079.33 TEAGUE, NALL & PERKINS,INC 32634 AP _______________ Account: 507-69280-010-003 Capital Repairs Totals: 5,279.33 9,079.33 ** 210,000.00 Budgeted 200,920.67 Remaining 4 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 31,314.33 ** 380,800.00 Budgeted 349,485.67 Remaining 8 % Used TCMUD#1 Page 207 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 64 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 38,101.42 .00 38,101.42 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 38,101.42 ** .00 Budgeted (38,101.42) Remaining 0 % Used Account: 507-69005-020-001 Capital Expense 8,578.00 .00 8,578.00 _______________ Account: 507-69005-020-001 Capital Expense Totals: .00 8,578.00 ** 8,200.00 Budgeted (378.00) Remaining 105 % Used Account: 507-69005-020-004 Capital Expense .00 .00 _______________ Account: 507-69005-020-004 Capital Expense Totals: .00 .00 ** 18,000.00 Budgeted 18,000.00 Remaining 0 % Used Account: 507-69005-020-005 Capital Expense 1526 05/22/2013 May A/P Portable submersible pump 8,553.92 8,553.92 XYLEM WATER SOLUTIONS USA INC 32620 AP _______________ Account: 507-69005-020-005 Capital Expense Totals: 8,553.92 8,553.92 ** 10,000.00 Budgeted 1,446.08 Remaining 86 % Used Account: 507-69280-020-006 Capital Repairs 27,960.70 .00 27,960.70 _______________ Account: 507-69280-020-006 Capital Repairs Totals: .00 27,960.70 ** 28,000.00 Budgeted 39.30 Remaining 100 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 83,194.04 ** 64,200.00 Budgeted (18,994.04) Remaining 130 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ (330,540.96) (100.00) Budgeted 330,440.96 Remaining ########## TCMUD#1 Page 208 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 65 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 522-49145-000-000 Intergov Transfer-General Fund 1630 05/31/2013 Xfer/Prime Interpl, Clear Fund (86,726.39) (25,606.82) (112,333.21) GL _______________ Account: 522-49145-000-000 Intergov Transfer-General Fund Totals: (25,606.82) (112,333.21) ** .00 Budgeted 112,333.21 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (112,333.21) ** .00 Budgeted 112,333.21 Remaining 0 % Used Fund 522 Totals: ------------------------------------------------------------------------------------------------------ (112,333.21) .00 Budgeted 112,333.21 Remaining 0 % Used TCMUD#1 Page 209 of 294 Meeting Date: June 18, 2013 TROPHY CLUB MUD #1 - I&S BALANCE SHEET MAY 31, 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 686,156 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 13,618 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 704,620 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 13,618 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 13,618 FUND BALANCE ASSIGNED FUND BALANCE 136,417 NET REVENUES / EXPENDITURES 554,585 TOTAL FUND BALANCE 691,002 TOTAL LIABILITIES AND FUND BALANCE 704,620 TCMUD#1 Page 210 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 27 20:09 06/12/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 196,940.00- 196,940.00- 1,101.41- 196,906.17- 99.983 33.83- 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 39.87- 2,547.48- 65.320 1,352.52- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 104.57- 1,407.08- 28.046 3,609.92- Subtotal: 205,857.00- 205,857.00- 1,245.85- 200,860.73- 97.573 4,996.27- 533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 161,000.00- 161,000.00- 46.667 184,000.00- Subtotal: 345,000.00- 345,000.00- 161,000.00- 161,000.00- 46.667 184,000.00- 533-49010-000-000 Interest Income 1,700.00- 1,700.00- 32.09- 240.34- 14.138 1,459.66- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 100.000 Subtotal: 309,700.00- 309,700.00- 32.09- 308,240.34- 99.529 1,459.66- Program number: 860,557.00- 860,557.00- 162,277.94- 670,101.07- 77.868 190,455.93- Department number: Revenues 860,557.00- 860,557.00- 162,277.94- 670,101.07- 77.868 190,455.93- Revenues Subtotal ----------- 860,557.00- 860,557.00- 162,277.94- 670,101.07- 77.868 190,455.93- TCMUD#1 Page 211 of 294 Meeting Date: June 18, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 28 20:09 06/12/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 1,000.00 25.000 3,000.00 533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 114,516.25 50.000 114,516.75 533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00 Subtotal: 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Program number: 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Department number: Administration 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Expenditures Subtotal ----------- 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Fund number: 533 MUD 1 I&S Consolidated 22,524.00- 22,524.00- 162,277.94- 554,584.82- 2,462.195 532,060.82 ******* End of Report ********* TCMUD#1 Page 212 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 66 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2013 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 1589 05/01/2013 Property Taxes/Assessments (195,804.76) (62.79) (195,867.55) GL 1590 05/02/2013 Property Taxes/Assessments (10.72) (195,878.27) GL 1591 05/03/2013 Property Taxes/Assessments (7.50) (195,885.77) GL 1592 05/06/2013 Property Taxes/Assessments (22.53) (195,908.30) GL 1593 05/07/2013 Property Taxes/Assessments (78.82) (195,987.12) GL 1594 05/08/2013 Property Taxes/Assessments (3.64) (195,990.76) GL 1595 05/09/2013 Property Taxes/Assessments (1.09) (195,991.85) GL 1596 05/10/2013 Property Taxes/Assessments (13.71) (196,005.56) GL 1599 05/15/2013 Property Taxes/Assessments (7.80) (196,013.36) GL 1600 05/16/2013 Property Taxes/Assessments (52.23) (196,065.59) GL 1601 05/17/2013 Property Taxes/Assessments (137.84) (196,203.43) GL 1602 05/20/2013 Property Taxes/Assessments (82.57) (196,286.00) GL 1603 05/21/2013 Property Taxes/Assessments (22.06) (196,308.06) GL 1604 05/22/2013 Property Taxes/Assessments (57.24) (196,365.30) GL 1605 05/23/2013 Property Taxes/Assessments (39.20) (196,404.50) GL 1606 05/24/2013 Property Taxes/Assessments (83.36) (196,487.86) GL 1607 05/28/2013 Property Taxes/Assessments (237.29) (196,725.15) GL 1608 05/29/2013 Property Taxes/Assessments (94.93) (196,820.08) GL 1609 05/30/2013 Property Taxes/Assessments (26.64) (196,846.72) GL 1610 05/31/2013 Property Taxes/Assessments (59.46) (196,906.18) GL 1655 05/31/2013 Bank Rec adjustment .01 (196,906.17) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,101.41) (196,906.17) ** (196,940.00) Budgeted (33.83) Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1590 05/02/2013 Property Taxes/Assessments (2,507.61) (25.00) (2,532.61) GL 1604 05/22/2013 Property Taxes/Assessments (12.01) (2,544.62) GL 1609 05/30/2013 Property Taxes/Assessments (2.86) (2,547.48) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (39.87) (2,547.48) ** (3,900.00) Budgeted (1,352.52) Remaining 65 % Used Account: 533-40015-000-000 Property Taxes/P & I 1589 05/01/2013 Property Taxes/Assessments (1,302.51) (6.90) (1,309.41) GL 1590 05/02/2013 Property Taxes/Assessments (12.19) (1,321.60) GL 1593 05/07/2013 Property Taxes/Assessments (5.02) (1,326.62) GL 1599 05/15/2013 Property Taxes/Assessments (1.01) (1,327.63) GL 1600 05/16/2013 Property Taxes/Assessments (2.44) (1,330.07) GL 1601 05/17/2013 Property Taxes/Assessments (14.34) (1,344.41) GL TCMUD#1 Page 213 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 67 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1602 05/20/2013 Property Taxes/Assessments (1,302.51) (8.42) (1,352.83) GL 1604 05/22/2013 Property Taxes/Assessments (8.16) (1,360.99) GL 1606 05/24/2013 Property Taxes/Assessments (8.25) (1,369.24) GL 1607 05/28/2013 Property Taxes/Assessments (28.74) (1,397.98) GL 1608 05/29/2013 Property Taxes/Assessments (5.13) (1,403.11) GL 1609 05/30/2013 Property Taxes/Assessments (.80) (1,403.91) GL 1610 05/31/2013 Property Taxes/Assessments (3.17) (1,407.08) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (104.57) (1,407.08) ** (5,017.00) Budgeted (3,609.92) Remaining 28 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees 1587 05/31/2013 Texpool xfer-PID Conn to I&S (161,000.00) (161,000.00) GL _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: (161,000.00) (161,000.00) ** (345,000.00) Budgeted (184,000.00) Remaining 47 % Used Account: 533-49010-000-000 Interest Income 1583 05/31/2013 May bank interest (208.25) (32.09) (240.34) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (32.09) (240.34) ** (1,700.00) Budgeted (1,459.66) Remaining 14 % Used Account: 533-49015-000-000 Lease/Rental Income (308,000.00) .00 (308,000.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (670,101.07) ** (860,557.00) Budgeted (190,455.93) Remaining 78 % Used TCMUD#1 Page 214 of 294 Meeting Date: June 18, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 68 20:10 06/12/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1,000.00 .00 1,000.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,000.00 ** 4,000.00 Budgeted 3,000.00 Remaining 25 % Used Account: 533-70025-051-000 Bond Interest Expense 114,516.25 .00 114,516.25 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 114,516.25 ** 229,033.00 Budgeted 114,516.75 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 605,000.00 Budgeted 605,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 115,516.25 ** 838,033.00 Budgeted 722,516.75 Remaining 14 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (554,584.82) (22,524.00) Budgeted 532,060.82 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (1,064,039.15) **** (22,624.00) Budgeted 1,041,415.15 Remaining ########## ******* End of Report ********* TCMUD#1 Page 215 of 294 Meeting Date: June 18, 2013