Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
August Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET AUGUST 31, 2013 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 703,032 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 14,666 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 1 UTILITY AND OTHER ACCOUNTS RECEIVABLE 5,176 TOTAL ASSETS 722,875 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 14,667 ACCOUNTS AND OTHER PAYABLES 132,898 TOTAL LIABILITIES 147,565 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - UNASSIGNED FUND BALANCE 350,496 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 224,814 TOTAL FUND BALANCE 575,310 TOTAL LIABILITIES AND FUND BALANCE 722,875 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 13:02 09/12/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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- 120.29- 255,124.19- 101.206 3,040.19 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 700.00- 445.88- 9,035.03- 1,290.719 8,335.03 122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 1,836.18- 1,056,637.88- 100.599 6,288.88 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 10.35 2,996.13 -51.657 8,796.13- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 104.87- 2,490.31- 332.041 1,740.31 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 211.47- 4,504.18- 100.093 4.18 Subtotal: 1,318,183.00- 1,314,183.00- 2,708.34- 1,324,795.46- 100.808 10,612.46 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 1,600.00- 6,800.00- 113.333 800.00 Subtotal: 6,000.00- 6,000.00- 1,600.00- 6,800.00- 113.333 800.00 122-43400-000-000 Fire Inspections 500.00- 675.00- 300.00- 1,350.00- 200.000 675.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- 300.00- 11,350.00- 106.323 675.00 122-49025-000-000 Auction Sales 540.00- 540.00- 540.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- 2,200.00- 10,639.26- 204.601 5,439.26 122-49903-000-000 Recovery of Prior Year Expense 4,340.96- 4,340.96 Subtotal: 1,200.00- 10,613.00- 2,740.00- 15,520.22- 146.238 4,907.22 Program number: 1,335,883.00- 1,341,471.00- 7,348.34- 1,358,465.68- 101.267 16,994.68 Department number: Fire Revenues 1,335,883.00- 1,341,471.00- 7,348.34- 1,358,465.68- 101.267 16,994.68 Revenues Subtotal ----------- 1,335,883.00- 1,341,471.00- 7,348.34- 1,358,465.68- 101.267 16,994.68 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 13:02 09/12/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 51,867.87 398,903.94 89.698 45,813.06 122-50010-045-000 Overtime 31,375.00 37,076.00 4,299.09 35,903.06 96.836 1,172.94 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 4,585.09 76.114 1,438.91 122-50020-045-000 Retirement 69,242.00 69,242.00 7,588.35 63,590.51 91.838 5,651.49 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,681.88 38,270.90 79.192 10,056.10 122-50027-045-000 Dental Insurance 3,635.00 3,836.00 328.94 3,527.80 91.966 308.20 122-50028-045-000 Vision Insurance 824.00 824.00 69.12 730.67 88.674 93.33 122-50029-045-000 Life Insurance & Other 4,250.00 5,974.00 390.50 5,308.71 88.864 665.29 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 3,301.79 26,899.74 87.063 3,997.26 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 772.18 6,290.98 87.060 935.02 122-50040-045-000 Unemployment Taxes 1,481.00 1,980.00 2.68 139.57 7.049 1,840.43 122-50045-045-000 Workman's Compensation 10,000.00 10,000.00 10,274.65 102.747 274.65- 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 171.08 454.13 67.279 220.87 122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 Subtotal: 676,394.00 684,647.00 72,787.73 611,226.37 89.276 73,420.63 122-55045-045-000 Legal 5,000.00 3,055.72 61.114 1,944.28 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 810.52 8,551.27 89.430 1,010.73 122-55090-045-000 Vehicle Maintenance 14,850.00 14,600.00 5,522.98 37.829 9,077.02 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 439.06 4,426.48 80.481 1,073.52 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 451.30 40.916 651.70 122-55160-045-000 Professional Outside Services 2,500.00 Subtotal: 44,323.00 45,573.00 1,249.58 28,525.90 62.594 17,047.10 122-60005-045-000 Telephone 106.00 106.00 54.62 51.528 51.38 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 3,500.00 214.71 3,513.15 100.376 13.15- 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 60.06 6,565.34 106.459 398.34- 122-60025-045-000 Water 1,400.00 1,400.00 4.75 1,197.67 85.548 202.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 1.38 43.04 43.040 56.96 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 85.00 8,040.91 100.511 40.91- 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 340.00 3,122.50 62.450 1,877.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 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 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 13:02 09/12/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 1,143.00 3,558.66 84.730 641.34 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 2,150.00 2,381.92 110.787 231.92- 122-60195-045-000 Flags & Repair 2,543.00 2,293.00 37.50 1,595.42 69.578 697.58 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 132.03 1,316.54 106.430 79.54- Subtotal: 359,088.00 362,676.00 2,018.43 355,389.75 97.991 7,286.25 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 939.46 6,741.89 67.419 3,258.11 122-65010-045-000 Uniforms 4,357.00 3,357.00 171.53- 1,279.44 38.113 2,077.56 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 7,060.00 92.895 540.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 843.28 84.328 156.72 122-65035-045-000 Small Tools 5,000.00 2,400.00 5,169.14 215.381 2,769.14- 122-65085-045-000 Office Supplies 1,200.00 1,200.00 4.26 374.35 31.196 825.65 122-65095-045-000 Maintenance Supplies 2,785.00 1,988.00 143.10 1,867.00 93.913 121.00 122-65105-045-000 Printing 106.00 Subtotal: 32,048.00 27,545.00 915.29 23,335.10 84.716 4,209.90 122-69006-045-000 Grant Match 3,000.00 122-69008-045-000 Short Term Debt-Principal 72,932.00 72,932.00 67,000.00 69,966.05 95.933 2,965.95 122-69009-045-000 Short Term Debt-Interest 2,966.05 2,966.05 2,966.05- 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 28.771 103,708.00 Subtotal: 224,030.00 221,030.00 69,966.05 115,175.23 52.108 105,854.77 Program number: 1,335,883.00 1,341,471.00 146,937.08 1,133,652.35 84.508 207,818.65 Department number: Fire 1,335,883.00 1,341,471.00 146,937.08 1,133,652.35 84.508 207,818.65 Expenditures Subtotal ----------- 1,335,883.00 1,341,471.00 146,937.08 1,133,652.35 84.508 207,818.65 Fund number: 122 Trophy Club MUD Fire Dept. 139,588.74 224,813.33- 224,813.33 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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 2198 08/09/2013 Property Taxes/Assessments (255,003.90) (120.29) (255,124.19) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (120.29) (255,124.19) ** (252,084.00) Budgeted 3,040.19 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 2198 08/09/2013 Property Taxes/Assessments (8,589.15) (445.88) (9,035.03) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (445.88) (9,035.03) ** (700.00) Budgeted 8,335.03 Remaining ########## Account: 122-40010-000-000 Property Taxes/MUD Fire 2195 08/01/2013 Property Tax/Assessments (1,054,801.70) (654.69) (1,055,456.39) GL 2196 08/02/2013 Property Taxes/Assessments (180.34) (1,055,636.73) GL 2197 08/08/2013 Property Taxes/Assessments (209.92) (1,055,846.65) GL 2199 08/12/2013 Property Taxes/Assessments (296.95) (1,056,143.60) GL 2200 08/15/2013 Property Taxes/Assessments 8.06 (1,056,135.54) GL 2203 08/16/2013 Property Taxes/Assessments (277.28) (1,056,412.82) GL 2201 08/20/2013 Property Taxes/Assessments (218.76) (1,056,631.58) GL 2202 08/22/2013 Property Taxes/Assessments (6.30) (1,056,637.88) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (1,836.18) (1,056,637.88) ** (1,050,349.00) Budgeted 6,288.88 Remaining 101 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2111 08/21/2013 August A/P Refund Tax overpayment 2,985.78 10.35 2,996.13 DENTON COUNTY TAX OFFICE 32901 AP _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 10.35 2,996.13 ** (5,800.00) Budgeted (8,796.13) Remaining -52 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 2198 08/09/2013 Property Taxes/Assessments (2,385.44) (104.87) (2,490.31) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (104.87) (2,490.31) ** (750.00) Budgeted 1,740.31 Remaining 332 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2195 08/01/2013 Property Tax/Assessments (4,292.71) (65.14) (4,357.85) GL 2196 08/02/2013 Property Taxes/Assessments (34.26) (4,392.11) GL 2197 08/08/2013 Property Taxes/Assessments (2.14) (4,394.25) GL 2199 08/12/2013 Property Taxes/Assessments (42.20) (4,436.45) GL 2203 08/16/2013 Property Taxes/Assessments (24.96) (4,461.41) GL 2201 08/20/2013 Property Taxes/Assessments (41.56) (4,502.97) GL 2202 08/22/2013 Property Taxes/Assessments (1.21) (4,504.18) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (211.47) (4,504.18) ** (4,500.00) Budgeted 4.18 Remaining 100 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: (5,200.00) (1,600.00) (6,800.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (1,600.00) (6,800.00) ** (6,000.00) Budgeted 800.00 Remaining 113 % Used Account: 122-43400-000-000 Fire Inspections 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: (1,050.00) (300.00) (1,350.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (300.00) (1,350.00) ** (675.00) Budgeted 675.00 Remaining 200 % 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-49025-000-000 Auction Sales 2188 08/21/2013 Lone Star Auctioneers (540.00) (540.00) GL _______________ Account: 122-49025-000-000 Auction Sales Totals: (540.00) (540.00) ** .00 Budgeted 540.00 Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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-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 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: (8,439.26) (2,200.00) (10,639.26) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (2,200.00) (10,639.26) ** (5,200.00) Budgeted 5,439.26 Remaining 205 % Used Account: 122-49903-000-000 Recovery of Prior Year Expense (4,340.96) .00 (4,340.96) _______________ Account: 122-49903-000-000 Recovery of Prior Year Expense Totals: .00 (4,340.96) ** .00 Budgeted 4,340.96 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,358,465.68) ** (1,341,471.00) Budgeted 16,994.68 Remaining 101 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 2093 08/02/2013 FD Payroll 8/2/13 347,036.07 17,583.93 364,620.00 GL 2095 08/16/2013 FD Payroll 8/16/13 16,222.98 380,842.98 GL 2217 08/30/2013 Fire 8/30/13 Payroll 18,060.96 398,903.94 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 51,867.87 398,903.94 ** 444,717.00 Budgeted 45,813.06 Remaining 90 % Used Account: 122-50010-045-000 Overtime 2093 08/02/2013 FD Payroll 8/2/13 31,603.97 2,107.07 33,711.04 GL 2217 08/30/2013 Fire 8/30/13 Payroll 2,192.02 35,903.06 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,299.09 35,903.06 ** 37,076.00 Budgeted 1,172.94 Remaining 97 % 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 2093 08/02/2013 FD Payroll 8/2/13 4,270.84 314.25 4,585.09 GL _______________ Account: 122-50017-045-000 Certification Totals: 314.25 4,585.09 ** 6,024.00 Budgeted 1,438.91 Remaining 76 % Used Account: 122-50020-045-000 Retirement 2093 08/02/2013 FD Payroll 8/2/13 56,002.16 2,572.97 58,575.13 GL 2095 08/16/2013 FD Payroll 8/16/13 2,280.96 60,856.09 GL 2217 08/30/2013 Fire 8/30/13 Payroll 2,734.42 63,590.51 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-50020-045-000 Retirement Totals: 7,588.35 63,590.51 ** 69,242.00 Budgeted 5,651.49 Remaining 92 % Used Account: 122-50026-045-000 Medical Insurance 2093 08/02/2013 FD Payroll 8/2/13 34,589.02 1,655.83 36,244.85 GL 2095 08/16/2013 FD Payroll 8/16/13 1,840.94 38,085.79 GL 2217 08/30/2013 Fire 8/30/13 Payroll 185.11 38,270.90 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,681.88 38,270.90 ** 48,327.00 Budgeted 10,056.10 Remaining 79 % Used Account: 122-50027-045-000 Dental Insurance 2093 08/02/2013 FD Payroll 8/2/13 3,198.86 151.23 3,350.09 GL 2095 08/16/2013 FD Payroll 8/16/13 164.46 3,514.55 GL 2217 08/30/2013 Fire 8/30/13 Payroll 13.25 3,527.80 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 328.94 3,527.80 ** 3,836.00 Budgeted 308.20 Remaining 92 % Used Account: 122-50028-045-000 Vision Insurance 2093 08/02/2013 FD Payroll 8/2/13 661.55 31.65 693.20 GL 2095 08/16/2013 FD Payroll 8/16/13 34.54 727.74 GL 2217 08/30/2013 Fire 8/30/13 Payroll 2.93 730.67 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 69.12 730.67 ** 824.00 Budgeted 93.33 Remaining 89 % Used Account: 122-50029-045-000 Life Insurance & Other 2093 08/02/2013 FD Payroll 8/2/13 4,918.21 193.74 5,111.95 GL 2095 08/16/2013 FD Payroll 8/16/13 196.76 5,308.71 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 390.50 5,308.71 ** 5,974.00 Budgeted 665.29 Remaining 89 % Used Account: 122-50030-045-000 Social Security Taxes 2093 08/02/2013 FD Payroll 8/2/13 23,597.95 1,149.18 24,747.13 GL 2095 08/16/2013 FD Payroll 8/16/13 905.79 25,652.92 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2217 08/30/2013 Fire 8/30/13 Payroll 23,597.95 1,246.82 26,899.74 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,301.79 26,899.74 ** 30,897.00 Budgeted 3,997.26 Remaining 87 % Used Account: 122-50035-045-000 Medicare Taxes 2093 08/02/2013 FD Payroll 8/2/13 5,518.80 268.73 5,787.53 GL 2095 08/16/2013 FD Payroll 8/16/13 211.85 5,999.38 GL 2217 08/30/2013 Fire 8/30/13 Payroll 291.60 6,290.98 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 772.18 6,290.98 ** 7,226.00 Budgeted 935.02 Remaining 87 % Used Account: 122-50040-045-000 Unemployment Taxes 2093 08/02/2013 FD Payroll 8/2/13 136.89 1.55 138.44 GL 2095 08/16/2013 FD Payroll 8/16/13 .33 138.77 GL 2217 08/30/2013 Fire 8/30/13 Payroll .80 139.57 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 2.68 139.57 ** 1,980.00 Budgeted 1,840.43 Remaining 7 % Used Account: 122-50045-045-000 Workman's Compensation 10,274.65 .00 10,274.65 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 10,274.65 ** 10,000.00 Budgeted (274.65) Remaining 103 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 2111 08/21/2013 August A/P Symonds, 1st Check, Carenow, P 283.05 171.08 454.13 TOWN OF TROPHY CLUB 32911 AP _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: 171.08 454.13 ** 675.00 Budgeted 220.87 Remaining 67 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-55045-045-000 Legal 3,055.72 .00 3,055.72 _______________ Account: 122-55045-045-000 Legal Totals: .00 3,055.72 ** 5,000.00 Budgeted 1,944.28 Remaining 61 % Used Account: 122-55080-045-000 Maintenance & Repairs 2076 08/15/2013 August AP Generator Maintenance 7,740.75 810.52 8,551.27 ENTECH SALES AND SERVICE INC 32856 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 810.52 8,551.27 ** 9,562.00 Budgeted 1,010.73 Remaining 89 % Used Account: 122-55090-045-000 Vehicle Maintenance 5,522.98 .00 5,522.98 _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 5,522.98 ** 14,600.00 Budgeted 9,077.02 Remaining 38 % 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 2185 08/09/2013 Firefighters Aug Cable 3,987.42 (120.00) 3,867.42 GL 2078 08/15/2013 August AP Bay door repair 220.00 4,087.42 OVERHEAD DOOR FORT WORTH 32877 AP 2111 08/21/2013 August A/P Pest Control Fire Station 140.00 4,227.42 GANN'S PEST CONTROL 32902 AP 2228 08/26/2013 7/27/13-8/26/13 PCards THE HOME DEPOT 6581 44.08 4,271.50 THE HOME DEPOT 6581 PC 2228 08/26/2013 7/27/13-8/26/13 PCards ATT*BILL PAYMENT 133.68 4,405.18 ATT*BILL PAYMENT PC 2228 08/26/2013 7/27/13-8/26/13 PCards ATT*BILL PAYMENT 152.83 4,558.01 ATT*BILL PAYMENT PC 2155 08/29/2013 August A/P FD Rug Service 24.51 4,582.52 G & K SERVICES 32938 AP 2155 08/29/2013 August A/P FD Rug Service 24.51 4,607.03 G & K SERVICES 32938 AP 2155 08/29/2013 August A/P FD Rug service 24.51 4,631.54 G & K SERVICES 32938 AP 2166 08/30/2013 Town billed Inv 1069-1070 AR 20130801-20130830 User: (36.76) 4,594.78 AR 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: (168.30) 4,426.48 AR _______________ Account: 122-55100-045-000 Building Maintenance Totals: 439.06 4,426.48 ** 5,500.00 Budgeted 1,073.52 Remaining 80 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-55110-045-000 Maintenance-Radios 451.30 .00 451.30 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 451.30 ** 1,103.00 Budgeted 651.70 Remaining 41 % Used Account: 122-60005-045-000 Telephone 54.62 .00 54.62 _______________ Account: 122-60005-045-000 Telephone Totals: .00 54.62 ** 106.00 Budgeted 51.38 Remaining 52 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 2093 08/02/2013 FD Payroll 8/2/13 3,298.44 75.42 3,373.86 GL 2078 08/15/2013 August AP Verizon 139.29 3,513.15 TOWN OF TROPHY CLUB 32891 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 214.71 3,513.15 ** 3,500.00 Budgeted (13.15) Remaining 100 % Used Account: 122-60020-045-000 Electricity/Gas 2111 08/21/2013 August A/P Elec 7/15-8/13 6,505.28 1,259.16 7,764.44 HUDSON ENERGY SERVICES, LLC 32905 AP 2115 08/21/2013 Bill Town Inv 1063-1067 AR 20130801-20130821 User: (661.81) 7,102.63 AR 2139 08/27/2013 A/P August gas 64.47 7,167.10 ATMOS ENERGY 32913 AP 2141 08/27/2013 Town Bill Inv #1068 AR 20130827-20130827 User: (601.76) 6,565.34 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 60.06 6,565.34 ** 6,167.00 Budgeted (398.34) Remaining 106 % Used Account: 122-60025-045-000 Water 2076 08/15/2013 August AP Water-Fire july 1,192.92 94.46 1,287.38 TROPHY CLUB MUD (WATER BILLS) 32894 AP 2076 08/15/2013 August AP Water-Fire July 110.32 1,397.70 TROPHY CLUB MUD (WATER BILLS) 32894 AP 2115 08/21/2013 Bill Town Inv 1063-1067 AR 20130801-20130821 User: (102.39) 1,295.31 AR 2251 08/31/2013 Town billed Inv 1075 AR 20130801-20130831 User: (97.64) 1,197.67 AR _______________ Account: 122-60025-045-000 Water Totals: 4.75 1,197.67 ** 1,400.00 Budgeted 202.33 Remaining 86 % Used Account: 122-60030-045-000 Rent And/Or Usage . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 308,000.00 .00 308,000.00 _______________ 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 2239 08/31/2013 August Postage Meter usage 41.66 1.38 43.04 GL _______________ Account: 122-60035-045-000 Postage Totals: 1.38 43.04 ** 100.00 Budgeted 56.96 Remaining 43 % 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 2076 08/15/2013 August AP advance certification-tackett 7,955.91 85.00 8,040.91 TX COMM ON FIRE PROTECTION 32895 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 85.00 8,040.91 ** 8,000.00 Budgeted (40.91) Remaining 101 % 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 2228 08/26/2013 7/27/13-8/26/13 PCards PAYPAL *TEXASFIREMA 2,782.50 170.00 2,952.50 PAYPAL *TEXASFIREMA PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2228 08/26/2013 7/27/13-8/26/13 PCards PAYPAL *TEXASFIREMA 2,782.50 170.00 3,122.50 PAYPAL *TEXASFIREMA PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 340.00 3,122.50 ** 5,000.00 Budgeted 1,877.50 Remaining 62 % 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 2,789.19 .00 2,789.19 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 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 2076 08/15/2013 August AP Fire Prevention Public Ed Pack 2,415.66 688.00 3,103.66 NATIONAL FIRE SAFETY COUNCIL 32874 AP 2078 08/15/2013 August AP Junior FF helmets 455.00 3,558.66 ARTCRAFT & FOREMOST INC 32847 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 1,143.00 3,558.66 ** 4,200.00 Budgeted 641.34 Remaining 85 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,381.92 .00 2,381.92 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 2,381.92 ** 2,150.00 Budgeted (231.92) Remaining 111 % Used Account: 122-60195-045-000 Flags & Repair 2111 08/21/2013 August A/P Symonds, 1st Check, Carenow, P 1,557.92 37.50 1,595.42 TOWN OF TROPHY CLUB 32911 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 37.50 1,595.42 ** 2,293.00 Budgeted 697.58 Remaining 70 % 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 2228 08/26/2013 7/27/13-8/26/13 PCards TLF ROORBACH FLOWERS 1,184.51 57.00 1,241.51 TLF ROORBACH FLOWERS PC 2228 08/26/2013 7/27/13-8/26/13 PCards TOM THUMB STOR00017897 41.49 1,283.00 TOM THUMB STOR00017897 PC 2228 08/26/2013 7/27/13-8/26/13 PCards VINNYS ITALIAN RESTAUR 33.54 1,316.54 VINNYS ITALIAN RESTAUR PC 2228 08/26/2013 7/27/13-8/26/13 PCards Fraudulent charge (62.51) 1,254.03 PC 2228 08/26/2013 7/27/13-8/26/13 PCards Fraudulent charge (504.94) 749.09 PC 2228 08/26/2013 7/27/13-8/26/13 PCards Fraudulent charge 62.51 811.60 WAL-MART #3809 PC 2228 08/26/2013 7/27/13-8/26/13 PCards Fraudulent charge 504.94 1,316.54 WAL-MART #3809 PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 132.03 1,316.54 ** 1,237.00 Budgeted (79.54) Remaining 106 % Used Account: 122-65005-045-000 Fuel & Lube 2236 08/31/2013 August Gas Log 5,802.43 939.46 6,741.89 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 939.46 6,741.89 ** 10,000.00 Budgeted 3,258.11 Remaining 67 % Used Account: 122-65010-045-000 Uniforms 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: 1,450.97 (171.53) 1,279.44 AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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: (171.53) 1,279.44 ** 3,357.00 Budgeted 2,077.56 Remaining 38 % Used Account: 122-65015-045-000 Protective Clothing 7,060.00 .00 7,060.00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 7,060.00 ** 7,600.00 Budgeted 540.00 Remaining 93 % Used Account: 122-65030-045-000 Chemicals 843.28 .00 843.28 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 843.28 ** 1,000.00 Budgeted 156.72 Remaining 84 % Used Account: 122-65035-045-000 Small Tools 5,169.14 .00 5,169.14 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 5,169.14 ** 2,400.00 Budgeted (2,769.14) Remaining 215 % Used Account: 122-65085-045-000 Office Supplies 2076 08/15/2013 August AP office supplies 370.09 4.26 374.35 OFFICE DEPOT, INC 32876 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 4.26 374.35 ** 1,200.00 Budgeted 825.65 Remaining 31 % Used Account: 122-65095-045-000 Maintenance Supplies 2228 08/26/2013 7/27/13-8/26/13 PCards ROANOKE AUTO SUPPLY LT 1,723.90 17.18 1,741.08 ROANOKE AUTO SUPPLY LT PC 2228 08/26/2013 7/27/13-8/26/13 PCards SAMSCLUB #4795 125.92 1,867.00 SAMSCLUB #4795 PC _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 143.10 1,867.00 ** 1,988.00 Budgeted 121.00 Remaining 94 % Used Account: 122-69008-045-000 Short Term Debt-Principal 2179 08/27/2013 Fire Truck CO Payment 2,966.05 67,000.00 69,966.05 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-69008-045-000 Short Term Debt-Principal Totals: 67,000.00 69,966.05 ** 72,932.00 Budgeted 2,965.95 Remaining 96 % Used Account: 122-69009-045-000 Short Term Debt-Interest 2179 08/27/2013 Fire Truck CO Payment 2,966.05 2,966.05 GL _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: 2,966.05 2,966.05 ** .00 Budgeted (2,966.05) Remaining 0 % 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 41,890.00 .00 41,890.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 41,890.00 ** 145,598.00 Budgeted 103,708.00 Remaining 29 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 1,133,652.35 ** 1,341,471.00 Budgeted 207,818.65 Remaining 85 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (224,813.33) .00 Budgeted 224,813.33 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET AUGUST 31, 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 8/31/13 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 362,465 - - 362,465 INVESTMENTS 2,174,333 313,050 330,561 2,817,944 PREPAID EXPENSES 13,350 - - 13,350 ADVALOREM PROPERTY TAXES RECEIVABLE 1,917 - - 1,917 UTILITY AND OTHER ACCOUNTS RECEIVABLE 976,649 - - 976,649 - TOTAL ASSETS 3,529,314 313,050 330,561 4,172,925 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,917 - - 1,917 ACCOUNTS AND OTHER PAYABLES 288,318 - 44,860 333,178 CUSTOMER DEPOSITS 238,242 - - 238,242 - TOTAL LIABILITIES 528,477 - 44,860 573,337 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 (281,284) 98,801 247,600 65,117 - TOTAL FUND BALANCE 3,000,837 313,050 285,701 3,599,588 - TOTAL LIABILITIES AND FUND BALANCE 3,529,314 313,050 330,561 4,172,925 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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- 174.61- 100,485.75- 100.602 601.75 135-40002-000-000 Property Taxes/Delinquent 500.00- 624.00- 2.57 299.85 -48.053 923.85- 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 20.11- 844.77- 70.398 355.23- Subtotal: 101,584.00- 101,708.00- 192.15- 101,030.67- 99.334 677.33- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 470,447.44- 2,967,093.08- 83.684 578,515.92- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 182,747.06- 1,643,673.09- 99.391 10,073.91- 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- 5,656.66- 51,654.08- 79.985 12,925.92- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 728.00- 11,030.88- 94.889 594.12- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 250.00- 1,700.00- 94.444 100.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 750.00- 5,550.00- 106.731 350.00 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 16,758.00- 64,020.69- 82.527 13,554.31- Subtotal: 5,360,712.00- 5,360,712.00- 677,337.16- 4,744,871.72- 88.512 615,840.28- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 20,700.00- 464,600.00- 72.143 179,400.00- Subtotal: 644,000.00- 644,000.00- 20,700.00- 464,600.00- 72.143 179,400.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 611.05- 4,460.75- 81.105 1,039.25- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 9,952.30- 97.917 211.70- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 6,416.63- 91.666 583.37- 135-49025-000-000 Auction Sales 12,200.00- 12,200.00- 12,200.00 135-49030-000-000 Vending Revenue 350.00- 350.00- 36.00- 434.41- 124.117 84.41 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- 4,438.00- 77,142.69- 105.675 4,142.69 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- 275.03- 15,837.31- 119.862 2,624.31 135-49901-000-000 Records Management Revenue 109.00- 90.50- 83.028 18.50- 135-49903-000-000 Recovery of Prior Year Expense 11,789.33- 11,789.33 135-49905-000-000 Gas Well Revenue 200.00- 286.00- 111.31- 774.66- 270.860 488.66 Subtotal: 402,962.00- 381,737.00- 19,165.25- 177,200.00- 46.419 204,537.00- Program number: 6,509,258.00- 6,488,157.00- 717,394.56- 5,487,702.39- 84.580 1,000,454.61- Department number: Revenues 6,509,258.00- 6,488,157.00- 717,394.56- 5,487,702.39- 84.580 1,000,454.61- Revenues Subtotal ----------- 6,509,258.00- 6,488,157.00- 717,394.56- 5,487,702.39- 84.580 1,000,454.61- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 19,914.96 153,564.38 71.987 59,756.62 135-50010-010-000 Overtime 13,250.00 19,250.00 2,659.51 13,295.90 69.070 5,954.10 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 325.00 4,025.00 78.922 1,075.00 135-50020-010-000 Retirement 32,725.00 57,748.00 2,056.37 43,810.51 75.865 13,937.49 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 2,113.96 21,699.20 75.032 7,220.80 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 190.78 1,637.51 78.312 453.49 135-50028-010-000 Vision Insurance 519.00 519.00 41.38 376.99 72.638 142.01 135-50029-010-000 Life Insurance & Other 1,204.00 1,532.00 168.10 1,784.91 116.508 252.91- 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 1,406.81 10,841.41 74.486 3,713.59 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 329.01 2,535.49 74.486 868.51 135-50040-010-000 Unemployment Taxes 945.00 945.00 4.01 52.27 5.531 892.73 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 3,760.65 61.559 2,348.35 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 239.40 119.700 39.40- 135-50070-010-000 Employee Relations 350.00 350.00 89.23 249.37 71.249 100.63 Subtotal: 325,773.00 357,124.00 29,299.12 260,952.99 73.071 96,171.01 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 14,573.76 41,814.26 83.629 8,185.74 135-55090-010-000 Vehicle Maintenance 3,700.00 4,650.00 383.75 4,171.85 89.717 478.15 135-55100-010-000 Building Maint & Supplies 55.30 55.30- 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 240.00 4,780.21 88.785 603.79 Subtotal: 64,100.00 64,934.00 15,197.51 52,588.66 80.988 12,345.34 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 171.95 1,548.59 77.430 451.41 135-60020-010-000 Electricity 162,410.00 162,410.00 18,015.17 117,597.64 72.408 44,812.36 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 620.00 1,082.00 73.505 390.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 36.00 7.200 464.00 135-60135-010-000 TCEQ Fees & Permits 35,800.00 42,743.00 6,425.50 49,719.25 116.321 6,976.25- 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 203,011.74 1,353,858.87 66.744 674,588.13 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 108.00 1,443.78 34.376 2,756.22 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 1,128.99 225.798 628.99- Subtotal: 2,239,129.00 2,245,328.00 228,358.36 1,527,872.81 68.047 717,455.19 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 1,408.39 10,979.07 62.166 6,681.93 135-65010-010-000 Uniforms 2,680.00 2,680.00 1,922.05 71.718 757.95 135-65030-010-000 Chemicals 6,200.00 6,200.00 848.27 5,318.96 85.790 881.04 135-65035-010-000 Small Tools 1,500.00 1,500.00 626.03 41.735 873.97 135-65040-010-000 Safety Equipment 2,000.00 1,000.00 504.07 760.89 76.089 239.11 135-65050-010-000 Meter Expense 143,550.00 143,550.00 149,743.25 104.314 6,193.25- Subtotal: 173,591.00 172,591.00 2,760.73 169,350.25 98.122 3,240.75 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 330,009.00 366,000.00 100.000 135-69009-010-000 Short Term Debt-Interest 21,037.00 6,280.31 20,895.53 99.328 141.47 135-69195-010-000 Gasb34/Reserve for Replacement 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 336,289.31 576,486.11 98.387 9,450.89 Program number: 3,821,430.00 3,425,914.00 611,905.03 2,587,250.82 75.520 838,663.18 Department number: Water 3,821,430.00 3,425,914.00 611,905.03 2,587,250.82 75.520 838,663.18 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 22,096.91 165,925.61 84.320 30,855.39 135-50010-020-000 Overtime 10,166.00 17,546.00 1,937.96 12,156.01 69.281 5,389.99 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 425.00 3,825.00 91.071 375.00 135-50020-020-000 Retirement 29,821.00 54,844.00 2,196.49 44,896.94 81.863 9,947.06 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 3,293.23 32,006.51 110.238 2,972.51- 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 226.46 2,260.45 107.029 148.45- 135-50028-020-000 Vision Insurance 552.00 552.00 49.93 537.66 97.402 14.34 135-50029-020-000 Life Insurance & Other 920.00 1,377.00 168.15 1,919.24 139.378 542.24- 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 1,380.94 10,155.12 76.538 3,112.88 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 322.96 2,374.97 76.538 728.03 135-50040-020-000 Unemployment Taxes 756.00 756.00 45.41 6.007 710.59 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 5,960.27 202.799 3,021.27- 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 189.00 126.000 39.00- 135-50070-020-000 Employee Relations 350.00 350.00 55.68 166.57 47.591 183.43 Subtotal: 297,010.00 329,870.00 32,153.71 285,276.26 86.481 44,593.74 135-55070-020-000 Independent Labor 1,000.00 84,418.00 14,025.00 91,525.00 108.419 7,107.00- 135-55080-020-000 Maintenance & Repairs 40,000.00 41,205.00 5,780.51 53,575.90 130.023 12,370.90- 135-55090-020-000 Vehicle Maintenance 2,000.00 3,350.00 785.12 5,478.51 163.538 2,128.51- 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 2,484.42 39,201.66 79.018 10,409.34 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 3,750.50 28,167.15 93.891 1,832.85 Subtotal: 89,500.00 210,084.00 26,825.55 219,029.18 104.258 8,945.18- 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 3,981.00 342.47 2,217.65 55.706 1,763.35 135-60020-020-000 Electricity 153,045.00 153,045.00 10,108.08 115,024.51 75.157 38,020.49 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 111.00 1,182.66 36.145 2,089.34 135-60090-020-000 Safety Program 250.00 73.89 145.36 145.36- 135-60100-020-000 Travel & per diem 1,400.00 1,400.00 3,442.80 245.914 2,042.80- 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 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 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 10,635.44 173,113.04 78.261 48,086.96 135-65005-020-000 Fuel & Lube 8,527.00 10,527.00 1,210.49 10,337.53 98.200 189.47 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 1,323.70 84.098 250.30 135-65030-020-000 Chemicals 10,000.00 38,346.00 2,240.00 27,790.90 72.474 10,555.10 135-65035-020-000 Small Tools 1,000.00 1,000.00 469.05 46.905 530.95 135-65040-020-000 Safety Equipment 250.00 500.00 12.82 835.31 167.062 335.31- 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 682.45 14,028.73 140.287 4,028.73- Subtotal: 32,351.00 61,947.00 4,145.76 54,785.22 88.439 7,161.78 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 73,760.46 1,174,398.99 92.503 95,186.01 Department number: Wastewater 1,039,428.00 1,269,585.00 73,760.46 1,174,398.99 92.503 95,186.01 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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 17,674.11 136,143.72 87.007 20,331.28 135-50010-021-000 Overtime 7,297.00 12,158.00 1,343.11 9,548.84 78.540 2,609.16 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,600.00 88.889 200.00 135-50020-021-000 Retirement 23,574.00 42,910.00 1,721.22 35,579.79 82.917 7,330.21 135-50026-021-000 Medical Insurance 20,198.00 25,940.00 2,321.55 23,621.64 91.063 2,318.36 135-50027-021-000 Dental Insurance 1,409.00 1,812.00 159.88 1,652.48 91.196 159.52 135-50028-021-000 Vision Insurance 357.00 383.00 32.60 349.92 91.363 33.08 135-50029-021-000 Life Insurance & Other 1,008.00 1,223.00 123.22 1,451.04 118.646 228.04- 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 1,121.04 8,872.50 84.484 1,629.50 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 262.18 2,075.00 84.487 381.00 135-50040-021-000 Unemployment Taxes 567.00 567.00 34.39 6.065 532.61 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 4,896.88 146.263 1,548.88- 135-50070-021-000 Employee Relations 250.00 250.00 20.25 147.90 59.160 102.10 Subtotal: 233,059.00 263,642.00 24,929.16 229,791.60 87.160 33,850.40 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 20,000.00 1,683.27 19,833.05 99.165 166.95 135-55090-021-000 Vehicle Maintenance 1,900.00 1,600.00 17.21 1,440.47 90.029 159.53 135-55100-021-000 Building Maint & Supplies 65.44 65.44 65.44- Subtotal: 38,400.00 21,600.00 1,765.92 21,338.96 98.791 261.04 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 217.16 2,231.31 63.752 1,268.69 135-60020-021-000 Electricity 18,705.00 18,705.00 1,516.03 16,663.26 89.085 2,041.74 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 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 1,733.19 22,688.33 65.286 12,063.67 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 1,659.88 9,143.62 75.461 2,973.38 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 239.95 359.95 71.990 140.05 Subtotal: 23,837.00 23,587.00 1,899.83 12,728.70 53.965 10,858.30 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 15,276.00 16.973 74,724.00 135-69008-021-000 Short Term Debt-Principal 40,260.00 40,260.00 35,991.00 35,991.00 89.396 4,269.00 135-69009-021-000 Short Term Debt-Interest 4,238.24 4,238.24 4,238.24- Subtotal: 130,260.00 130,260.00 40,229.24 55,505.24 42.611 74,754.76 Program number: 459,887.00 473,841.00 70,557.34 342,052.83 72.187 131,788.17 Department number: Collection 459,887.00 473,841.00 70,557.34 342,052.83 72.187 131,788.17 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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,200.00 9,900.00 99.000 100.00 135-50030-026-000 Social Security Taxes 620.00 620.00 74.40 613.80 99.000 6.20 135-50035-026-000 Medicare Taxes 145.00 145.00 17.40 143.55 99.000 1.45 135-50040-026-000 Unemployment Taxes 210.00 210.00 1.20 68.70 32.714 141.30 135-50045-026-000 Workman's Compensation 150.00 150.00 7.88 5.253 142.12 Subtotal: 11,125.00 11,125.00 1,293.00 10,733.93 96.485 391.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 1,602.68 2,059.65 171.638 859.65- 135-60080-026-000 Schools & Training 4,000.00 4,000.00 2,655.00 66.375 1,345.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,727.01 114.540 727.01- 135-60243-026-000 Prior Year Expense 107.10 107.10- 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 205.85 473.73 15.791 2,526.27 Subtotal: 15,450.00 15,450.00 1,808.53 11,064.49 71.615 4,385.51 Program number: 26,575.00 26,575.00 3,101.53 21,798.42 82.026 4,776.58 Department number: Board of Directors 26,575.00 26,575.00 3,101.53 21,798.42 82.026 4,776.58 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 49,712.95 389,948.14 87.682 54,781.86 135-50010-030-000 Overtime 1,500.00 1,500.00 16.84 281.45 18.763 1,218.55 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 4,465.74 85,764.01 81.835 19,036.99 135-50026-030-000 Medical Insurance 44,066.00 49,049.00 4,388.10 44,660.70 91.053 4,388.30 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 386.34 3,956.88 117.102 577.88- 135-50028-030-000 Vision Insurance 795.00 945.00 82.53 858.76 90.874 86.24 135-50029-030-000 Life Insurance & Other 2,500.00 2,582.00 336.77 3,814.17 147.722 1,232.17- 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 2,938.62 23,171.59 83.345 4,630.41 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 687.24 5,419.16 83.346 1,082.84 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 439.29 28.581 1,097.71 135-50045-030-000 Workman's Compensation 831.00 831.00 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 20.25 2,852.10 57.042 2,147.90 Subtotal: 601,526.00 651,226.00 63,035.38 564,461.35 86.677 86,764.65 135-55030-030-000 Software & Support 63,555.00 63,555.00 2,139.80 58,037.57 91.319 5,517.43 135-55070-030-000 Independent Labor 2,700.00 7,700.00 11,818.30 17,290.97 224.558 9,590.97- 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55080-030-000 Maintenance & Repairs 811.00 810.52 1,621.04 199.882 810.04- 135-55100-030-000 Building Maint & Supplies 5,000.00 6,500.00 699.87 5,191.25 79.865 1,308.75 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,858.51 17,412.78 86.202 2,787.22 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 560.32 6,299.06 57.264 4,700.94 Subtotal: 203,420.00 210,891.00 17,887.32 198,451.44 94.101 12,439.56 135-60005-030-000 Telephone 9,000.00 10,500.00 9,533.59 90.796 966.41 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 326.70 3,275.87 91.633 299.13 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 1,260.50 12,551.76 96.411 467.24 135-60025-030-000 Water 3,100.00 3,100.00 40.80- 797.59 25.729 2,302.41 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 12,083.61 91.668 1,098.39 135-60035-030-000 Postage 23,000.00 26,604.00 2,599.06 25,482.05 95.783 1,121.95 135-60040-030-000 Service Charges & Fees 18,000.00 28,330.00 3,059.35 26,733.52 94.365 1,596.48 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 1,001.40 11.781 7,498.60 135-60055-030-000 Insurance 35,000.00 50,694.00 105.00 51,098.77 100.798 404.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 220.00 4,491.95 115.415 599.95- 135-60075-030-000 Meetings 250.00 400.00 58.61 342.46 85.615 57.54 135-60080-030-000 Schools & Training 5,500.00 5,350.00 125.00- 3,634.23 67.930 1,715.77 135-60100-030-000 Travel & per diem 3,950.00 3,616.00 70.34 4,530.78 125.298 914.78- . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 2,658.48 5,350.12 133.753 1,350.12- 135-60235-030-000 Security 1,350.00 1,350.00 505.13 37.417 844.87 135-60243-030-000 Prior Year Expense 1,263.00 3,290.58 260.537 2,027.58- 135-60245-030-000 Miscellaneous Expenses 15,000.00 13,500.00 8,035.07 9,225.66 68.338 4,274.34 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,099.01 96.181 400.99 135-60281-030-000 Park Expenses 42,500.00 32,502.00 76.475 9,998.00 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 34,000.00 195,000.00 195,000.00- 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 3,986.76 159.470 1,486.76- Subtotal: 173,076.00 247,709.00 53,325.82 416,350.34 168.080 168,641.34- 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 12,129.34 60.082 8,058.66 135-65085-030-000 Office Supplies 8,200.00 8,200.00 179.52 7,651.92 93.316 548.08 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 263.50 3,342.25 58.309 2,389.75 135-65095-030-000 Maintenance Supplies 2,000.00 1,500.00 367.55 3,271.95 218.130 1,771.95- 135-65097-030-000 Vending Machine Supplies 500.00 500.00 15.88 94.58 18.916 405.42 135-65105-030-000 Printing 5,200.00 4,200.00 2,135.66 50.849 2,064.34 Subtotal: 43,455.00 41,955.00 826.45 29,249.82 69.717 12,705.18 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 513.70 2,825.35 81.894 624.65 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 100.000 Subtotal: 30,361.00 30,361.00 513.70 29,736.35 97.943 624.65 Program number: 1,051,838.00 1,182,142.00 135,588.67 1,238,249.30 104.746 56,107.30- Department number: Administration 1,051,838.00 1,182,142.00 135,588.67 1,238,249.30 104.746 56,107.30- . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 13:02 09/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 71,777.70 261,660.11 373.800 191,660.11- 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 8,152.22 53.988 6,947.78 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,390.56 62.909 1,409.44 Subtotal: 110,100.00 110,100.00 71,777.70 292,902.89 266.034 182,802.89- 135-60344-039-000 Intergov Trans Out (Fire CIP) 112,333.21 112,333.21- Subtotal: 112,333.21 112,333.21- Program number: 110,100.00 110,100.00 71,777.70 405,236.10 368.062 295,136.10- Department number: Non Departmental 110,100.00 110,100.00 71,777.70 405,236.10 368.062 295,136.10- Expenditures Subtotal ----------- 6,509,258.00 6,488,157.00 966,690.73 5,768,986.46 88.916 719,170.54 Fund number: 135 MUD 1 General Fund 249,296.17 281,284.07 281,284.07- . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 13:02 09/12/13 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 56,911.00- 56,911.00 137-49146-000-000 Intergov Transfer-Fire Dept 41,890.00- 41,890.00 Subtotal: 98,801.00- 98,801.00 Program number: 98,801.00- 98,801.00 Department number: 98,801.00- 98,801.00 Revenues Subtotal ----------- 98,801.00- 98,801.00 Fund number: 137 MUD 1 Consolidated GASB 98,801.00- 98,801.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 13:02 09/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 8/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- 12.25- 97.48- 97.480 2.52- Subtotal: 445,100.00- 12.25- 445,097.48- 99.999 2.52- Program number: 445,100.00- 12.25- 445,097.48- 99.999 2.52- Department number: 445,100.00- 12.25- 445,097.48- 99.999 2.52- Revenues Subtotal ----------- 445,100.00- 12.25- 445,097.48- 99.999 2.52- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 13:02 09/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 8/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-010-001 Capital Exp/Security Cameras 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- . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 13:02 09/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: 8/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs/ROFC FW Meter 165,000.00 38,545.36 92,420.86 56.013 72,579.14 Subtotal: 165,000.00 38,545.36 92,420.86 56.013 72,579.14 Program number: 2 Rate of Flow Control-FW Meter 165,000.00 38,545.36 92,420.86 56.013 72,579.14 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 13:02 09/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 8/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 210,000.00 15,593.83 7.426 194,406.17 Subtotal: 210,000.00 15,593.83 7.426 194,406.17 Program number: 3 Indian Creek Waterline 210,000.00 15,593.83 7.426 194,406.17 Department number: Water 380,800.00 38,545.36 114,303.69 30.017 266,496.31 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 13:02 09/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 8/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- . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 13:02 09/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 1 Security Cameras Period Ending: 8/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-001 Capital Exp/Security Cameras 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- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 13:02 09/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 4 Sludge Blanket Level Indicator Period Ending: 8/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-004 Capital Exp/Sludge Blanket Ind 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 . glbase_tbam rgonzale Trophy Club MUD #1 Page 23 13:02 09/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 5 Portable Submersible Pump Period Ending: 8/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-005 Capital Exp/Port Sub Pump 10,000.00 8,553.92 85.539 1,446.08 Subtotal: 10,000.00 8,553.92 85.539 1,446.08 Program number: 5 Portable Submersible Pump 10,000.00 8,553.92 85.539 1,446.08 . glbase_tbam rgonzale Trophy Club MUD #1 Page 24 13:02 09/12/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 6 Waste Pump Period Ending: 8/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-020-006 Capital Repairs/Waste Pump 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 83,194.04 129.586 18,994.04- Expenditures Subtotal ----------- 445,000.00 38,545.36 197,497.73 44.382 247,502.27 Fund number: 507 MUD 1 Capital Projects 100.00- 38,533.11 247,599.75- ############### 247,499.75 . glbase_tbam rgonzale Trophy Club MUD #1 Page 25 13:02 09/12/13 Budget Summary with Amendment Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 8/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 112,333.21- 112,333.21 Subtotal: 112,333.21- 112,333.21 Program number: 112,333.21- 112,333.21 Department number: Revenues 112,333.21- 112,333.21 Revenues Subtotal ----------- 112,333.21- 112,333.21 Fund number: 522 2010 GO/Fire Station 112,333.21- 112,333.21 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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 2195 08/01/2013 Property Tax/Assessments (100,311.14) (62.26) (100,373.40) GL 2196 08/02/2013 Property Taxes/Assessments (17.15) (100,390.55) GL 2197 08/08/2013 Property Taxes/Assessments (19.96) (100,410.51) GL 2199 08/12/2013 Property Taxes/Assessments (28.24) (100,438.75) GL 2200 08/15/2013 Property Taxes/Assessments .77 (100,437.98) GL 2203 08/16/2013 Property Taxes/Assessments (26.37) (100,464.35) GL 2201 08/20/2013 Property Taxes/Assessments (20.80) (100,485.15) GL 2202 08/22/2013 Property Taxes/Assessments (.60) (100,485.75) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (174.61) (100,485.75) ** (99,884.00) Budgeted 601.75 Remaining 101 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2111 08/21/2013 August A/P Refund Tax overpayment 297.28 2.57 299.85 DENTON COUNTY TAX OFFICE 32901 AP _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 2.57 299.85 ** (624.00) Budgeted (923.85) Remaining -48 % Used Account: 135-40015-000-000 Property Taxes/P & I 2195 08/01/2013 Property Tax/Assessments (824.66) (6.19) (830.85) GL 2196 08/02/2013 Property Taxes/Assessments (3.26) (834.11) GL 2197 08/08/2013 Property Taxes/Assessments (.21) (834.32) GL 2199 08/12/2013 Property Taxes/Assessments (4.01) (838.33) GL 2203 08/16/2013 Property Taxes/Assessments (2.37) (840.70) GL 2201 08/20/2013 Property Taxes/Assessments (3.96) (844.66) GL 2202 08/22/2013 Property Taxes/Assessments (.11) (844.77) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (20.11) (844.77) ** (1,200.00) Budgeted (355.23) Remaining 70 % Used Account: 135-47000-000-000 Water 2072 08/13/2013 UB 8/13/13 PM connect Fee UB20130813-20130813 User: (2,496,645.64) (200.00) (2,496,845.64) UB 2178 08/31/2013 UB 8/31/13 Billing UB20130831-20130831 User: (470,247.44) (2,967,093.08) UB _______________ Account: 135-47000-000-000 Water Totals: (470,447.44) (2,967,093.08) ** (3,545,609.00) Budgeted (578,515.92) Remaining 84 % Used Account: 135-47005-000-000 Sewer . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2178 08/31/2013 UB 8/31/13 Billing UB20130831-20130831 User: (1,460,926.03) (182,747.06) (1,643,673.09) UB _______________ Account: 135-47005-000-000 Sewer Totals: (182,747.06) (1,643,673.09) ** (1,653,747.00) Budgeted (10,073.91) Remaining 99 % Used Account: 135-47020-000-000 Standby (149.90) .00 (149.90) _______________ Account: 135-47020-000-000 Standby Totals: .00 (149.90) ** (576.00) Budgeted (426.10) Remaining 26 % Used Account: 135-47025-000-000 Penalties 2110 08/21/2013 UB 8/21/13 Penalties UB20130821-20130821 User: (45,997.42) (5,682.15) (51,679.57) UB 2164 08/29/2013 UB 08/29/2013 Adjustments UB20130829-20130829 User: 538.60 (51,140.97) UB 2178 08/31/2013 UB 8/31/13 Billing UB20130831-20130831 User: (513.11) (51,654.08) UB _______________ Account: 135-47025-000-000 Penalties Totals: (5,656.66) (51,654.08) ** (64,580.00) Budgeted (12,925.92) Remaining 80 % Used Account: 135-47030-000-000 Service Charges 2041 08/08/2013 UB 8/8/2013 Disconnect Fees UB20130808-20130808 User: (10,302.88) (600.00) (10,902.88) UB 2124 08/09/2013 UB 8/9/13 Adjustment NSF UB20130809-20130809 User: (25.00) (10,927.88) UB 2127 08/14/2013 UB 8/14/13 Adjustment NSF UB20130814-20130814 User: (25.00) (10,952.88) UB 2145 08/15/2013 UB 8/15/13 adjustment-NSF UB20130815-20130815 User: (25.00) (10,977.88) UB 2149 08/21/2013 UB 8/21/13 Adjustment-NSF UB20130821-20130821 User: (25.00) (11,002.88) UB 2173 08/26/2013 UB 8/26/13 Adjustment-NSF fee UB20130826-20130826 User: (25.00) (11,027.88) UB 2178 08/31/2013 UB 8/31/13 Billing UB20130831-20130831 User: (3.00) (11,030.88) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (728.00) (11,030.88) ** (11,625.00) Budgeted (594.12) Remaining 95 % Used Account: 135-47035-000-000 Plumbing Inspections 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: (1,450.00) (250.00) (1,700.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (1,700.00) ** (1,800.00) Budgeted (100.00) Remaining 94 % Used Account: 135-47045-000-000 Sewer Inspections . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: (4,800.00) (750.00) (5,550.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (750.00) (5,550.00) ** (5,200.00) Budgeted 350.00 Remaining 107 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2178 08/31/2013 UB 8/31/13 Billing UB20130831-20130831 User: (47,262.69) (16,758.00) (64,020.69) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (16,758.00) (64,020.69) ** (77,575.00) Budgeted (13,554.31) Remaining 83 % Used Account: 135-48005-000-000 Utility Fees 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: (443,900.00) (20,700.00) (464,600.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (20,700.00) (464,600.00) ** (644,000.00) Budgeted (179,400.00) Remaining 72 % Used Account: 135-49010-000-000 Interest Income 2184 08/08/2013 Prosperity Bank CD redemption (3,849.70) (247.95) (4,097.65) GL 2186 08/21/2013 Bank of the West CD interest (118.36) (4,216.01) GL 2213 08/30/2013 August Bank interest (123.48) (4,339.49) GL 2213 08/30/2013 August Bank interest (121.26) (4,460.75) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (611.05) (4,460.75) ** (5,500.00) Budgeted (1,039.25) Remaining 81 % Used Account: 135-49016-000-000 Cell Tower Revenue 2182 08/06/2013 AT&T Antenna lease (9,041.77) (910.53) (9,952.30) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (9,952.30) ** (10,164.00) Budgeted (211.70) Remaining 98 % Used Account: 135-49018-000-000 Building Rent Income 2166 08/30/2013 Town billed Inv 1069-1070 AR 20130801-20130830 User: (5,833.30) (583.33) (6,416.63) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (6,416.63) ** (7,000.00) Budgeted (583.37) Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-49025-000-000 Auction Sales 2188 08/21/2013 Lone Star Auctioneers (12,200.00) (12,200.00) GL _______________ Account: 135-49025-000-000 Auction Sales Totals: (12,200.00) (12,200.00) ** .00 Budgeted 12,200.00 Remaining 0 % Used Account: 135-49030-000-000 Vending Revenue 2189 08/30/2013 WWTP Vending (398.41) (36.00) (434.41) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (36.00) (434.41) ** (350.00) Budgeted 84.41 Remaining 124 % 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 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: (72,704.69) (4,438.00) (77,142.69) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,438.00) (77,142.69) ** (73,000.00) Budgeted 4,142.69 Remaining 106 % 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 Account: 135-49900-000-000 Miscellaneous Income 2220 08/01/2013 Expert Pay verification amt (15,562.28) (.03) (15,562.31) GL 2126 08/14/2013 UB 8/14/13 Backflow Test Fee UB20130814-20130814 User: (50.00) (15,612.31) UB 2234 08/31/2013 Town Inv 1071-72 AR 20130801-20130831 User: (225.00) (15,837.31) AR _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (275.03) (15,837.31) ** (13,213.00) Budgeted 2,624.31 Remaining 120 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-49901-000-000 Records Management Revenue (90.50) .00 (90.50) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (90.50) ** (109.00) Budgeted (18.50) Remaining 83 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (11,789.33) .00 (11,789.33) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (11,789.33) ** .00 Budgeted 11,789.33 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue 2187 08/21/2013 Vantage Energy-Gas well revenu (663.35) (111.31) (774.66) GL _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: (111.31) (774.66) ** (286.00) Budgeted 488.66 Remaining 271 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,487,702.39) ** (6,488,157.00) Budgeted (1,000,454.61) Remaining 85 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 1991 08/02/2013 Payroll 8/2/13 Salaries & Wages 133,649.42 6,615.12 140,264.54 PR 2061 08/16/2013 Payroll 8/16/13 Salaries & Wages 6,636.72 146,901.26 PR 2138 08/30/2013 Payroll 8/30/13 Salaries & Wages 6,663.12 153,564.38 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,914.96 153,564.38 ** 213,321.00 Budgeted 59,756.62 Remaining 72 % Used Account: 135-50010-010-000 Overtime 1991 08/02/2013 Payroll 8/2/13 Overtime 10,636.39 506.64 11,143.03 PR 2061 08/16/2013 Payroll 8/16/13 Overtime 482.97 11,626.00 PR 2138 08/30/2013 Payroll 8/30/13 Overtime 1,669.90 13,295.90 PR _______________ Account: 135-50010-010-000 Overtime Totals: 2,659.51 13,295.90 ** 19,250.00 Budgeted 5,954.10 Remaining 69 % 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 2061 08/16/2013 Payroll 8/16/13 Certification 3,700.00 350.00 4,050.00 PR 2138 08/30/2013 Payroll 8/30/13 Certification (25.00) 4,025.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 325.00 4,025.00 ** 5,100.00 Budgeted 1,075.00 Remaining 79 % Used Account: 135-50020-010-000 Retirement 1991 08/02/2013 Payroll 8/2/13 Retirement 41,754.14 639.53 42,393.67 PR 2061 08/16/2013 Payroll 8/16/13 Retirement 670.78 43,064.45 PR 2138 08/30/2013 Payroll 8/30/13 Retirement 746.06 43,810.51 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,056.37 43,810.51 ** 57,748.00 Budgeted 13,937.49 Remaining 76 % Used Account: 135-50026-010-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1991 08/02/2013 Payroll 8/2/13 Medical Insurance 19,585.24 1,057.00 20,642.24 PR 2061 08/16/2013 Payroll 8/16/13 Medical Insurance 1,056.96 21,699.20 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,113.96 21,699.20 ** 28,920.00 Budgeted 7,220.80 Remaining 75 % Used Account: 135-50027-010-000 Dental Insurance 1991 08/02/2013 Payroll 8/2/13 Dental Insurance 1,446.73 95.40 1,542.13 PR 2061 08/16/2013 Payroll 8/16/13 Dental Insurance 95.38 1,637.51 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 190.78 1,637.51 ** 2,091.00 Budgeted 453.49 Remaining 78 % Used Account: 135-50028-010-000 Vision Insurance 1991 08/02/2013 Payroll 8/2/13 Vision Insurance 335.61 20.70 356.31 PR 2061 08/16/2013 Payroll 8/16/13 Vision Insurance 20.68 376.99 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 41.38 376.99 ** 519.00 Budgeted 142.01 Remaining 73 % Used Account: 135-50029-010-000 Life Insurance & Other 1943 08/01/2013 August A/P August Dental, Life, AD&D, LTD 1,616.81 152.35 1,769.16 METLIFE 32818 AP 2076 08/15/2013 August AP FSA-Admin 15.75 1,784.91 Discovery Benefits 32852 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 168.10 1,784.91 ** 1,532.00 Budgeted (252.91) Remaining 117 % Used Account: 135-50030-010-000 Social Security Taxes 1991 08/02/2013 Payroll 8/2/13 Social Security Taxes 9,434.60 435.74 9,870.34 PR 2061 08/16/2013 Payroll 8/16/13 Social Security Taxes 455.98 10,326.32 PR 2138 08/30/2013 Payroll 8/30/13 Social Security Taxes 515.09 10,841.41 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,406.81 10,841.41 ** 14,555.00 Budgeted 3,713.59 Remaining 74 % Used Account: 135-50035-010-000 Medicare Taxes 1991 08/02/2013 Payroll 8/2/13 Medicare Taxes 2,206.48 101.90 2,308.38 PR 2061 08/16/2013 Payroll 8/16/13 Medicare Taxes 106.65 2,415.03 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2138 08/30/2013 Payroll 8/30/13 Medicare Taxes 2,206.48 120.46 2,535.49 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 329.01 2,535.49 ** 3,404.00 Budgeted 868.51 Remaining 74 % Used Account: 135-50040-010-000 Unemployment Taxes 1991 08/02/2013 Payroll 8/2/13 Unemployment Taxes 48.26 1.23 49.49 PR 2061 08/16/2013 Payroll 8/16/13 Unemployment Taxes 1.28 50.77 PR 2138 08/30/2013 Payroll 8/30/13 Unemployment Taxes 1.50 52.27 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 4.01 52.27 ** 945.00 Budgeted 892.73 Remaining 6 % Used Account: 135-50045-010-000 Workman's Compensation 3,760.65 .00 3,760.65 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 3,760.65 ** 6,109.00 Budgeted 2,348.35 Remaining 62 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 239.40 .00 239.40 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 239.40 ** 200.00 Budgeted (39.40) Remaining 120 % Used Account: 135-50070-010-000 Employee Relations 2228 08/26/2013 7/27/13-8/26/13 PCards WENDYS #9724 160.14 44.95 205.09 WENDYS #9724 PC 2228 08/26/2013 7/27/13-8/26/13 PCards DONUT HAVEN 24.03 229.12 DONUT HAVEN PC 2228 08/26/2013 7/27/13-8/26/13 PCards CHICK-FIL-A #02892 20.25 249.37 CHICK-FIL-A #02892 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 89.23 249.37 ** 350.00 Budgeted 100.63 Remaining 71 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-55080-010-000 Maintenance & Repairs 2076 08/15/2013 August AP Generator Maintenance 27,240.50 810.52 28,051.02 ENTECH SALES AND SERVICE INC 32856 AP 2076 08/15/2013 August AP Corp stop 56.71 28,107.73 HD SUPPLY WATERWORKS, LTD. 32860 AP 2076 08/15/2013 August AP Bullheads 109.60 28,217.33 HD SUPPLY WATERWORKS, LTD. 32860 AP 2076 08/15/2013 August AP Replacement of 6" valve on Pho 1,041.45 29,258.78 HD SUPPLY WATERWORKS, LTD. 32860 AP 2076 08/15/2013 August AP 6X12 Quantum 172.00 29,430.78 HD SUPPLY WATERWORKS, LTD. 32860 AP 2076 08/15/2013 August AP Parts returned (1,168.50) 28,262.28 HD SUPPLY WATERWORKS, LTD. 32860 AP 2111 08/21/2013 August A/P Repair of Omni Valve 837.41 29,099.69 SCOOP 32909 AP 2111 08/21/2013 August A/P Superior Water Signs 180.16 29,279.85 DALLAS LITE & BARRICADE, INC 32900 AP 2111 08/21/2013 August A/P Waterline Tee repair-Timberlin 8,425.00 37,704.85 CPS CIVIL, LLC 32899 AP 2111 08/21/2013 August A/P Angles 183.60 37,888.45 HD SUPPLY WATERWORKS, LTD. 32904 AP 2111 08/21/2013 August A/P U Branch 284.96 38,173.41 HD SUPPLY WATERWORKS, LTD. 32904 AP 2111 08/21/2013 August A/P 10" Tee Replacement 1,821.24 39,994.65 HD SUPPLY WATERWORKS, LTD. 32904 AP 2111 08/21/2013 August A/P Flanges 62.85 40,057.50 HD SUPPLY WATERWORKS, LTD. 32904 AP 2228 08/26/2013 7/27/13-8/26/13 PCards KORALEEN ENTERPRISES 1,402.14 41,459.64 KORALEEN ENTERPRISES PC 2228 08/26/2013 7/27/13-8/26/13 PCards MACARTHUR GAUGE INC 38.00 41,497.64 MACARTHUR GAUGE INC PC 2228 08/26/2013 7/27/13-8/26/13 PCards THE HOME DEPOT 6581 30.91 41,528.55 THE HOME DEPOT 6581 PC 2228 08/26/2013 7/27/13-8/26/13 PCards THE HOME DEPOT 6581 46.61 41,575.16 THE HOME DEPOT 6581 PC 2228 08/26/2013 7/27/13-8/26/13 PCards THE HOME DEPOT 6581 54.75 41,629.91 THE HOME DEPOT 6581 PC 2228 08/26/2013 7/27/13-8/26/13 PCards FERGUSON ENTERPRISES 1 163.40 41,793.31 FERGUSON ENTERPRISES 1 PC 2139 08/27/2013 A/P August Well Flanges 20.95 41,814.26 HD SUPPLY WATERWORKS, LTD. 32921 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 14,573.76 41,814.26 ** 50,000.00 Budgeted 8,185.74 Remaining 84 % Used Account: 135-55090-010-000 Vehicle Maintenance 2228 08/26/2013 7/27/13-8/26/13 PCards DISCOUNT TIRE TXD 75 3,788.10 344.00 4,132.10 DISCOUNT TIRE TXD 75 PC 2228 08/26/2013 7/27/13-8/26/13 PCards KWIK KAR OF ROANOKE 39.75 4,171.85 KWIK KAR OF ROANOKE PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 383.75 4,171.85 ** 4,650.00 Budgeted 478.15 Remaining 90 % Used Account: 135-55100-010-000 Building Maint & Supplies 55.30 .00 55.30 _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: .00 55.30 ** .00 Budgeted (55.30) Remaining 0 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,767.04 .00 1,767.04 . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-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 2076 08/15/2013 August AP Colilert Culture test for Bac- 4,540.21 240.00 4,780.21 TARRANT CTY PUBLIC HEALTH LAB 32887 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 240.00 4,780.21 ** 5,384.00 Budgeted 603.79 Remaining 89 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 2078 08/15/2013 August AP Verizon 1,376.64 171.95 1,548.59 TOWN OF TROPHY CLUB 32891 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 171.95 1,548.59 ** 2,000.00 Budgeted 451.41 Remaining 77 % Used Account: 135-60020-010-000 Electricity 2076 08/15/2013 August AP Elec-Elev tank 99,582.47 79.24 99,661.71 HUDSON ENERGY SERVICES, LLC 32862 AP 2111 08/21/2013 August A/P Elec 7/15-8/13 15,252.77 114,914.48 HUDSON ENERGY SERVICES, LLC 32905 AP 2111 08/21/2013 August A/P Elec 7/15-8/13 160.24 115,074.72 HUDSON ENERGY SERVICES, LLC 32905 AP 2111 08/21/2013 August A/P Elec 7/15-8/13 2,522.92 117,597.64 HUDSON ENERGY SERVICES, LLC 32905 AP _______________ Account: 135-60020-010-000 Electricity Totals: 18,015.17 117,597.64 ** 162,410.00 Budgeted 44,812.36 Remaining 72 % 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 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2228 08/26/2013 7/27/13-8/26/13 PCards ASSOCIATED PLUMBING 462.00 90.00 552.00 ASSOCIATED PLUMBING PC 2228 08/26/2013 7/27/13-8/26/13 PCards METROPLEX TRAINING CEN 200.00 752.00 METROPLEX TRAINING CEN PC 2228 08/26/2013 7/27/13-8/26/13 PCards METROPLEX TRAINING CEN 200.00 952.00 METROPLEX TRAINING CEN PC 2228 08/26/2013 7/27/13-8/26/13 PCards TX DPS DL OFFICE 61.00 1,013.00 TX DPS DL OFFICE PC 2228 08/26/2013 7/27/13-8/26/13 PCards TX DPS DL OFFICE 69.00 1,082.00 TX DPS DL OFFICE PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 620.00 1,082.00 ** 1,472.00 Budgeted 390.00 Remaining 74 % 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 2076 08/15/2013 August AP Nitrogen Bottle Lease 30.00 6.00 36.00 ALLIED WELDING SUPPLY, INC 32845 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 36.00 ** 500.00 Budgeted 464.00 Remaining 7 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 2076 08/15/2013 August AP North Texas Groundwater Fee 43,293.75 5,825.50 49,119.25 North Texas Groundwater 32875 AP 2139 08/27/2013 A/P August lead & copper sampling 600.00 49,719.25 LOWER COLORADO RIVER AUTHORITY 32927 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 6,425.50 49,719.25 ** 42,743.00 Budgeted (6,976.25) Remaining 116 % Used Account: 135-60150-010-000 Wholesale Water 2139 08/27/2013 A/P August wholesale water-july 1,150,847.13 203,011.74 1,353,858.87 CITY OF FORT WORTH 32936 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 203,011.74 1,353,858.87 ** 2,028,447.00 Budgeted 674,588.13 Remaining 67 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-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 2228 08/26/2013 7/27/13-8/26/13 PCards DENTON SAND & GRAVEL, 1,335.78 108.00 1,443.78 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 108.00 1,443.78 ** 4,200.00 Budgeted 2,756.22 Remaining 34 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 1,128.99 .00 1,128.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 1,128.99 ** 500.00 Budgeted (628.99) Remaining 226 % Used Account: 135-65005-010-000 Fuel & Lube 2236 08/31/2013 August Gas Log 9,570.68 1,408.39 10,979.07 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,408.39 10,979.07 ** 17,661.00 Budgeted 6,681.93 Remaining 62 % Used Account: 135-65010-010-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,922.05 .00 1,922.05 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,922.05 ** 2,680.00 Budgeted 757.95 Remaining 72 % Used Account: 135-65030-010-000 Chemicals 2076 08/15/2013 August AP chemicals 4,470.69 78.20 4,548.89 HACH COMPANY 32859 AP 2076 08/15/2013 August AP chlorine 520.44 5,069.33 DPC INDUSTRIES, INC 32854 AP 2111 08/21/2013 August A/P Monochlor F Reagent 249.63 5,318.96 HACH COMPANY 32903 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 848.27 5,318.96 ** 6,200.00 Budgeted 881.04 Remaining 86 % Used Account: 135-65035-010-000 Small Tools 626.03 .00 626.03 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 626.03 ** 1,500.00 Budgeted 873.97 Remaining 42 % Used Account: 135-65040-010-000 Safety Equipment 2139 08/27/2013 A/P August safety equipment 256.82 504.07 760.89 HD SUPPLY FACILITIES MAINT LTD 32920 AP _______________ Account: 135-65040-010-000 Safety Equipment Totals: 504.07 760.89 ** 1,000.00 Budgeted 239.11 Remaining 76 % Used Account: 135-65050-010-000 Meter Expense 149,743.25 .00 149,743.25 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 149,743.25 ** 143,550.00 Budgeted (6,193.25) Remaining 104 % Used Account: 135-69005-010-000 Capital Expenses (1,094.96) .00 (1,094.96) _______________ 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2114 08/21/2013 Correct JE1945/Gap Vax Pmt 35,991.00 (35,991.00) .00 GL 2139 08/27/2013 A/P August Ground storage P & I 366,000.00 366,000.00 FIRST FINANCIAL BANK 32918 AP _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: 330,009.00 366,000.00 ** 366,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 2114 08/21/2013 Correct JE1945/Gap Vax Pmt 14,615.22 (4,238.24) 10,376.98 GL 2139 08/27/2013 A/P August Ground storage P & I 10,518.55 20,895.53 FIRST FINANCIAL BANK 32918 AP _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: 6,280.31 20,895.53 ** 21,037.00 Budgeted 141.47 Remaining 99 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69280-010-000 Capital Repairs 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: ------------------------------------------------------------------------------------------------ 2,587,250.82 ** 3,425,914.00 Budgeted 838,663.18 Remaining 76 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 1991 08/02/2013 Payroll 8/2/13 Salaries & Wages 143,828.70 7,366.47 151,195.17 PR 2061 08/16/2013 Payroll 8/16/13 Salaries & Wages 7,366.47 158,561.64 PR 2138 08/30/2013 Payroll 8/30/13 Salaries & Wages 7,363.97 165,925.61 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 22,096.91 165,925.61 ** 196,781.00 Budgeted 30,855.39 Remaining 84 % Used Account: 135-50010-020-000 Overtime 1991 08/02/2013 Payroll 8/2/13 Overtime 10,218.05 473.42 10,691.47 PR 2061 08/16/2013 Payroll 8/16/13 Overtime 1,200.29 11,891.76 PR 2138 08/30/2013 Payroll 8/30/13 Overtime 264.25 12,156.01 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,937.96 12,156.01 ** 17,546.00 Budgeted 5,389.99 Remaining 69 % 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 1991 08/02/2013 Payroll 8/2/13 Certification 3,400.00 50.00 3,450.00 PR 2061 08/16/2013 Payroll 8/16/13 Certification 375.00 3,825.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 425.00 3,825.00 ** 4,200.00 Budgeted 375.00 Remaining 91 % Used Account: 135-50020-020-000 Retirement 1991 08/02/2013 Payroll 8/2/13 Retirement 42,700.45 708.51 43,408.96 PR 2061 08/16/2013 Payroll 8/16/13 Retirement 802.97 44,211.93 PR 2138 08/30/2013 Payroll 8/30/13 Retirement 685.01 44,896.94 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,196.49 44,896.94 ** 54,844.00 Budgeted 9,947.06 Remaining 82 % Used Account: 135-50026-020-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1991 08/02/2013 Payroll 8/2/13 Medical Insurance 28,713.28 1,646.62 30,359.90 PR 2061 08/16/2013 Payroll 8/16/13 Medical Insurance 1,646.61 32,006.51 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,293.23 32,006.51 ** 29,034.00 Budgeted (2,972.51) Remaining 110 % Used Account: 135-50027-020-000 Dental Insurance 1991 08/02/2013 Payroll 8/2/13 Dental Insurance 2,033.99 113.24 2,147.23 PR 2061 08/16/2013 Payroll 8/16/13 Dental Insurance 113.22 2,260.45 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 2,260.45 ** 2,112.00 Budgeted (148.45) Remaining 107 % Used Account: 135-50028-020-000 Vision Insurance 1991 08/02/2013 Payroll 8/2/13 Vision Insurance 487.73 24.98 512.71 PR 2061 08/16/2013 Payroll 8/16/13 Vision Insurance 24.95 537.66 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 49.93 537.66 ** 552.00 Budgeted 14.34 Remaining 97 % Used Account: 135-50029-020-000 Life Insurance & Other 1943 08/01/2013 August A/P August Dental, Life, AD&D, LTD 1,751.09 152.40 1,903.49 METLIFE 32818 AP 2076 08/15/2013 August AP FSA-Admin 15.75 1,919.24 Discovery Benefits 32852 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 168.15 1,919.24 ** 1,377.00 Budgeted (542.24) Remaining 139 % Used Account: 135-50030-020-000 Social Security Taxes 1991 08/02/2013 Payroll 8/2/13 Social Security Taxes 8,774.18 423.24 9,197.42 PR 2061 08/16/2013 Payroll 8/16/13 Social Security Taxes 484.76 9,682.18 PR 2138 08/30/2013 Payroll 8/30/13 Social Security Taxes 472.94 10,155.12 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,380.94 10,155.12 ** 13,268.00 Budgeted 3,112.88 Remaining 77 % Used Account: 135-50035-020-000 Medicare Taxes 1991 08/02/2013 Payroll 8/2/13 Medicare Taxes 2,052.01 98.98 2,150.99 PR 2061 08/16/2013 Payroll 8/16/13 Medicare Taxes 113.37 2,264.36 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2138 08/30/2013 Payroll 8/30/13 Medicare Taxes 2,052.01 110.61 2,374.97 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 322.96 2,374.97 ** 3,103.00 Budgeted 728.03 Remaining 77 % Used Account: 135-50040-020-000 Unemployment Taxes 45.41 .00 45.41 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 45.41 ** 756.00 Budgeted 710.59 Remaining 6 % Used Account: 135-50045-020-000 Workman's Compensation 5,960.27 .00 5,960.27 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 5,960.27 ** 2,939.00 Budgeted (3,021.27) Remaining 203 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 189.00 .00 189.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 189.00 ** 150.00 Budgeted (39.00) Remaining 126 % Used Account: 135-50070-020-000 Employee Relations 2228 08/26/2013 7/27/13-8/26/13 PCards DONUT HAVEN 110.89 35.43 146.32 DONUT HAVEN PC 2228 08/26/2013 7/27/13-8/26/13 PCards CHICK-FIL-A #02892 20.25 166.57 CHICK-FIL-A #02892 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 55.68 166.57 ** 350.00 Budgeted 183.43 Remaining 48 % Used Account: 135-55070-020-000 Independent Labor 2076 08/15/2013 August AP WWTP Improvements 77,500.00 14,025.00 91,525.00 THE WALLACE GROUP, INC. 32890 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 14,025.00 91,525.00 ** 84,418.00 Budgeted (7,107.00) Remaining 108 % Used Account: 135-55080-020-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2076 08/15/2013 August AP repairs-#2 Return pump 47,795.39 4,525.70 52,321.09 XYLEM WATER SOLUTIONS USA INC 32898 AP 2076 08/15/2013 August AP Generator Maintenance 810.52 53,131.61 ENTECH SALES AND SERVICE INC 32856 AP 2228 08/26/2013 7/27/13-8/26/13 PCards WW GRAINGER (100.75) 53,030.86 WW GRAINGER PC 2228 08/26/2013 7/27/13-8/26/13 PCards SEW EURODRIVE (611.53) 52,419.33 SEW EURODRIVE PC 2228 08/26/2013 7/27/13-8/26/13 PCards THE HOME DEPOT 6581 30.10 52,449.43 THE HOME DEPOT 6581 PC 2228 08/26/2013 7/27/13-8/26/13 PCards THE HOME DEPOT 6581 24.30 52,473.73 THE HOME DEPOT 6581 PC 2228 08/26/2013 7/27/13-8/26/13 PCards WW GRAINGER 37.79 52,511.52 WW GRAINGER PC 2228 08/26/2013 7/27/13-8/26/13 PCards WW GRAINGER 514.00 53,025.52 WW GRAINGER PC 2228 08/26/2013 7/27/13-8/26/13 PCards WW GRAINGER 542.50 53,568.02 WW GRAINGER PC 2228 08/26/2013 7/27/13-8/26/13 PCards THE HOME DEPOT 6581 7.88 53,575.90 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 5,780.51 53,575.90 ** 41,205.00 Budgeted (12,370.90) Remaining 130 % Used Account: 135-55090-020-000 Vehicle Maintenance 2076 08/15/2013 August AP tires-Vac truck 4,693.39 785.12 5,478.51 BLAGG TIRE & SERVICE 32849 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 785.12 5,478.51 ** 3,350.00 Budgeted (2,128.51) Remaining 164 % 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 2076 08/15/2013 August AP sludge haul off 36,717.24 1,740.41 38,457.65 L.H. CHANEY MATERIALS, INC. 32867 AP 2139 08/27/2013 A/P August sludge haul off 744.01 39,201.66 L.H. CHANEY MATERIALS, INC. 32925 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,484.42 39,201.66 ** 49,611.00 Budgeted 10,409.34 Remaining 79 % Used Account: 135-55135-020-000 Lab Analysis 2076 08/15/2013 August AP lab testing 24,416.65 176.00 24,592.65 OXIDOR LABORATORIES LLC 32878 AP 2076 08/15/2013 August AP lab testing 243.00 24,835.65 OXIDOR LABORATORIES LLC 32878 AP 2076 08/15/2013 August AP lab testing 176.00 25,011.65 OXIDOR LABORATORIES LLC 32878 AP 2076 08/15/2013 August AP lab testing 243.00 25,254.65 OXIDOR LABORATORIES LLC 32878 AP 2076 08/15/2013 August AP lab testing 88.00 25,342.65 OXIDOR LABORATORIES LLC 32878 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2076 08/15/2013 August AP lab testing 24,416.65 132.50 25,475.15 OXIDOR LABORATORIES LLC 32878 AP 2076 08/15/2013 August AP lab testing 88.00 25,563.15 OXIDOR LABORATORIES LLC 32878 AP 2139 08/27/2013 A/P August lab testing 98.00 25,661.15 OXIDOR LABORATORIES LLC 32930 AP 2139 08/27/2013 A/P August lab testing 176.00 25,837.15 OXIDOR LABORATORIES LLC 32930 AP 2139 08/27/2013 A/P August lab testing 243.00 26,080.15 OXIDOR LABORATORIES LLC 32930 AP 2139 08/27/2013 A/P August lab testing 243.00 26,323.15 OXIDOR LABORATORIES LLC 32930 AP 2139 08/27/2013 A/P August lab testing 176.00 26,499.15 OXIDOR LABORATORIES LLC 32930 AP 2139 08/27/2013 A/P August lab testing 243.00 26,742.15 OXIDOR LABORATORIES LLC 32930 AP 2155 08/29/2013 August A/P Lab testing 243.00 26,985.15 OXIDOR LABORATORIES LLC 32943 AP 2155 08/29/2013 August A/P Lab testing 176.00 27,161.15 OXIDOR LABORATORIES LLC 32943 AP 2155 08/29/2013 August A/P Lab testing 80.00 27,241.15 OXIDOR LABORATORIES LLC 32943 AP 2155 08/29/2013 August A/P Lab testing 80.00 27,321.15 OXIDOR LABORATORIES LLC 32943 AP 2155 08/29/2013 August A/P Lab testing 80.00 27,401.15 OXIDOR LABORATORIES LLC 32943 AP 2155 08/29/2013 August A/P Bio-monitoring 590.00 27,991.15 HUTHER AND ASSOCIATES,INC 32939 AP 2159 08/29/2013 August A/P Lab testing 176.00 28,167.15 OXIDOR LABORATORIES LLC 32943 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 3,750.50 28,167.15 ** 30,000.00 Budgeted 1,832.85 Remaining 94 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 2078 08/15/2013 August AP Verizon 1,875.18 232.49 2,107.67 TOWN OF TROPHY CLUB 32891 AP 2228 08/26/2013 7/27/13-8/26/13 PCards VERIZON WIRELESS 15160 109.98 2,217.65 VERIZON WIRELESS 15160 PC _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 342.47 2,217.65 ** 3,981.00 Budgeted 1,763.35 Remaining 56 % Used Account: 135-60020-020-000 Electricity 2111 08/21/2013 August A/P Elec 7/15-8/13 104,916.43 10,108.08 115,024.51 HUDSON ENERGY SERVICES, LLC 32905 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,108.08 115,024.51 ** 153,045.00 Budgeted 38,020.49 Remaining 75 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2228 08/26/2013 7/27/13-8/26/13 PCards TCEQ EPAYMENT 1,071.66 111.00 1,182.66 TCEQ EPAYMENT PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 111.00 1,182.66 ** 3,272.00 Budgeted 2,089.34 Remaining 36 % Used Account: 135-60090-020-000 Safety Program 2139 08/27/2013 A/P August safety supplies 71.47 73.89 145.36 CINTAS FAS LOCKBOX 636525 32915 AP _______________ Account: 135-60090-020-000 Safety Program Totals: 73.89 145.36 ** .00 Budgeted (145.36) Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 3,442.80 .00 3,442.80 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 3,442.80 ** 1,400.00 Budgeted (2,042.80) Remaining 246 % 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) 40,400.00 .00 40,400.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-60136-020-000 TCEQ Environmental Proj (SEP) Totals: .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 Account: 135-60245-020-000 Miscellaneous Expenses 202.10 .00 202.10 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .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 2236 08/31/2013 August Gas Log 9,127.04 1,210.49 10,337.53 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,210.49 10,337.53 ** 10,527.00 Budgeted 189.47 Remaining 98 % Used Account: 135-65010-020-000 Uniforms 1,323.70 .00 1,323.70 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,323.70 ** 1,574.00 Budgeted 250.30 Remaining 84 % Used Account: 135-65030-020-000 Chemicals 2139 08/27/2013 A/P August chemicals 25,550.90 2,240.00 27,790.90 HARCROS CHEMICALS INC 32919 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-020-000 Chemicals Totals: 2,240.00 27,790.90 ** 38,346.00 Budgeted 10,555.10 Remaining 72 % Used Account: 135-65035-020-000 Small Tools 469.05 .00 469.05 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 469.05 ** 1,000.00 Budgeted 530.95 Remaining 47 % Used Account: 135-65040-020-000 Safety Equipment 2228 08/26/2013 7/27/13-8/26/13 PCards WAL-MART #5247 822.49 12.82 835.31 WAL-MART #5247 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 12.82 835.31 ** 500.00 Budgeted (335.31) Remaining 167 % Used Account: 135-65045-020-000 Lab Supplies 2139 08/27/2013 A/P August lab supplies 13,346.28 371.88 13,718.16 IDEXX DISTRIBUTION, INC 32922 AP 2139 08/27/2013 A/P August lab supplies 310.57 14,028.73 IDEXX DISTRIBUTION, INC 32922 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 682.45 14,028.73 ** 10,000.00 Budgeted (4,028.73) Remaining 140 % 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,174,398.99 ** 1,269,585.00 Budgeted 95,186.01 Remaining 93 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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 1991 08/02/2013 Payroll 8/2/13 Salaries & Wages 118,469.61 5,891.37 124,360.98 PR 2061 08/16/2013 Payroll 8/16/13 Salaries & Wages 5,891.37 130,252.35 PR 2138 08/30/2013 Payroll 8/30/13 Salaries & Wages 5,891.37 136,143.72 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 17,674.11 136,143.72 ** 156,475.00 Budgeted 20,331.28 Remaining 87 % Used Account: 135-50010-021-000 Overtime 1991 08/02/2013 Payroll 8/2/13 Overtime 8,205.73 157.86 8,363.59 PR 2061 08/16/2013 Payroll 8/16/13 Overtime 59.76 8,423.35 PR 2138 08/30/2013 Payroll 8/30/13 Overtime 1,125.49 9,548.84 PR _______________ Account: 135-50010-021-000 Overtime Totals: 1,343.11 9,548.84 ** 12,158.00 Budgeted 2,609.16 Remaining 79 % 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 2061 08/16/2013 Payroll 8/16/13 Certification 1,450.00 150.00 1,600.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,600.00 ** 1,800.00 Budgeted 200.00 Remaining 89 % Used Account: 135-50020-021-000 Retirement 1991 08/02/2013 Payroll 8/2/13 Retirement 33,858.57 543.21 34,401.78 PR 2061 08/16/2013 Payroll 8/16/13 Retirement 547.89 34,949.67 PR 2138 08/30/2013 Payroll 8/30/13 Retirement 630.12 35,579.79 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,721.22 35,579.79 ** 42,910.00 Budgeted 7,330.21 Remaining 83 % Used Account: 135-50026-021-000 Medical Insurance 1991 08/02/2013 Payroll 8/2/13 Medical Insurance 21,300.09 1,160.78 22,460.87 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2061 08/16/2013 Payroll 8/16/13 Medical Insurance 21,300.09 1,160.77 23,621.64 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,321.55 23,621.64 ** 25,940.00 Budgeted 2,318.36 Remaining 91 % Used Account: 135-50027-021-000 Dental Insurance 1991 08/02/2013 Payroll 8/2/13 Dental Insurance 1,492.60 79.95 1,572.55 PR 2061 08/16/2013 Payroll 8/16/13 Dental Insurance 79.93 1,652.48 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 159.88 1,652.48 ** 1,812.00 Budgeted 159.52 Remaining 91 % Used Account: 135-50028-021-000 Vision Insurance 1991 08/02/2013 Payroll 8/2/13 Vision Insurance 317.32 16.31 333.63 PR 2061 08/16/2013 Payroll 8/16/13 Vision Insurance 16.29 349.92 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 32.60 349.92 ** 383.00 Budgeted 33.08 Remaining 91 % Used Account: 135-50029-021-000 Life Insurance & Other 1943 08/01/2013 August A/P August Dental, Life, AD&D, LTD 1,327.82 117.97 1,445.79 METLIFE 32818 AP 2076 08/15/2013 August AP FSA-Admin 5.25 1,451.04 Discovery Benefits 32852 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 123.22 1,451.04 ** 1,223.00 Budgeted (228.04) Remaining 119 % Used Account: 135-50030-021-000 Social Security Taxes 1991 08/02/2013 Payroll 8/2/13 Social Security Taxes 7,751.46 342.45 8,093.91 PR 2061 08/16/2013 Payroll 8/16/13 Social Security Taxes 343.54 8,437.45 PR 2138 08/30/2013 Payroll 8/30/13 Social Security Taxes 435.05 8,872.50 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 1,121.04 8,872.50 ** 10,502.00 Budgeted 1,629.50 Remaining 84 % Used Account: 135-50035-021-000 Medicare Taxes 1991 08/02/2013 Payroll 8/2/13 Medicare Taxes 1,812.82 80.09 1,892.91 PR 2061 08/16/2013 Payroll 8/16/13 Medicare Taxes 80.34 1,973.25 PR 2138 08/30/2013 Payroll 8/30/13 Medicare Taxes 101.75 2,075.00 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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-50035-021-000 Medicare Taxes Totals: 262.18 2,075.00 ** 2,456.00 Budgeted 381.00 Remaining 84 % Used Account: 135-50040-021-000 Unemployment Taxes 34.39 .00 34.39 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 34.39 ** 567.00 Budgeted 532.61 Remaining 6 % Used Account: 135-50045-021-000 Workman's Compensation 4,896.88 .00 4,896.88 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 4,896.88 ** 3,348.00 Budgeted (1,548.88) Remaining 146 % Used Account: 135-50070-021-000 Employee Relations 2228 08/26/2013 7/27/13-8/26/13 PCards CHICK-FIL-A #02892 127.65 20.25 147.90 CHICK-FIL-A #02892 PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 20.25 147.90 ** 250.00 Budgeted 102.10 Remaining 59 % Used Account: 135-55080-021-000 Maintenance & Repairs 2076 08/15/2013 August AP Generator Maintenance 18,149.78 810.52 18,960.30 ENTECH SALES AND SERVICE INC 32856 AP 2228 08/26/2013 7/27/13-8/26/13 PCards THREE WAY ELECTRIC 30.00 18,990.30 THREE WAY ELECTRIC PC 2228 08/26/2013 7/27/13-8/26/13 PCards FERGUSON ENTERPRISES 1 63.50 19,053.80 FERGUSON ENTERPRISES 1 PC 2139 08/27/2013 A/P August maple display L.S. #2 779.25 19,833.05 DHS AUTOMATION, INC 32916 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 1,683.27 19,833.05 ** 20,000.00 Budgeted 166.95 Remaining 99 % Used Account: 135-55090-021-000 Vehicle Maintenance 2228 08/26/2013 7/27/13-8/26/13 PCards ROANOKE AUTO SUPPLY LT 1,423.26 17.21 1,440.47 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 17.21 1,440.47 ** 1,600.00 Budgeted 159.53 Remaining 90 % Used Account: 135-55100-021-000 Building Maint & Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2228 08/26/2013 7/27/13-8/26/13 PCards ROANOKE AUTO SUPPLY LT 65.44 65.44 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55100-021-000 Building Maint & Supplies Totals: 65.44 65.44 ** .00 Budgeted (65.44) Remaining 0 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 2078 08/15/2013 August AP Verizon 2,014.15 217.16 2,231.31 TOWN OF TROPHY CLUB 32891 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 217.16 2,231.31 ** 3,500.00 Budgeted 1,268.69 Remaining 64 % Used Account: 135-60020-021-000 Electricity 2076 08/15/2013 August AP Electricity 15,147.23 304.13 15,451.36 TRI COUNTY ELECTRIC 32893 AP 2076 08/15/2013 August AP Electricity 189.42 15,640.78 TRI COUNTY ELECTRIC 32893 AP 2076 08/15/2013 August AP Electricity 27.78 15,668.56 TRI COUNTY ELECTRIC 32893 AP 2076 08/15/2013 August AP Elec0LS8 44.45 15,713.01 HUDSON ENERGY SERVICES, LLC 32862 AP 2076 08/15/2013 August AP Elec-LS9 20.38 15,733.39 HUDSON ENERGY SERVICES, LLC 32862 AP 2111 08/21/2013 August A/P Elec 7/15-8/13 605.73 16,339.12 HUDSON ENERGY SERVICES, LLC 32905 AP 2111 08/21/2013 August A/P Elec 7/15-8/13 277.76 16,616.88 HUDSON ENERGY SERVICES, LLC 32905 AP 2111 08/21/2013 August A/P Elec 7/15-8/13 92.67 16,709.55 HUDSON ENERGY SERVICES, LLC 32905 AP 2111 08/21/2013 August A/P Elec 7/15-8/13 50.71 16,760.26 HUDSON ENERGY SERVICES, LLC 32905 AP 2115 08/21/2013 Bill Town Inv 1063-1067 AR 20130801-20130821 User: (97.00) 16,663.26 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,516.03 16,663.26 ** 18,705.00 Budgeted 2,041.74 Remaining 89 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 2,092.93 .00 2,092.93 _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 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 2236 08/31/2013 August Gas Log 7,483.74 1,659.88 9,143.62 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,659.88 9,143.62 ** 12,117.00 Budgeted 2,973.38 Remaining 75 % Used Account: 135-65010-021-000 Uniforms 934.13 .00 934.13 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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-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 _______________ 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 2139 08/27/2013 A/P August eyewash stations 120.00 239.95 359.95 HD SUPPLY FACILITIES MAINT LTD 32920 AP _______________ Account: 135-65040-021-000 Safety Equipment Totals: 239.95 359.95 ** 500.00 Budgeted 140.05 Remaining 72 % Used Account: 135-69005-021-000 Capital Expenses 15,276.00 .00 15,276.00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 15,276.00 ** 90,000.00 Budgeted 74,724.00 Remaining 17 % Used Account: 135-69008-021-000 Short Term Debt-Principal 2114 08/21/2013 Correct JE1945/Gap Vax Pmt 35,991.00 35,991.00 GL _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: 35,991.00 35,991.00 ** 40,260.00 Budgeted 4,269.00 Remaining 89 % Used Account: 135-69009-021-000 Short Term Debt-Interest 2114 08/21/2013 Correct JE1945/Gap Vax Pmt 4,238.24 4,238.24 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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-69009-021-000 Short Term Debt-Interest Totals: 4,238.24 4,238.24 ** .00 Budgeted (4,238.24) Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 342,052.83 ** 473,841.00 Budgeted 131,788.17 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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 1991 08/02/2013 Payroll 8/2/13 Salaries & Wages 8,700.00 700.00 9,400.00 PR 2138 08/30/2013 Payroll 8/30/13 Salaries & Wages 500.00 9,900.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,200.00 9,900.00 ** 10,000.00 Budgeted 100.00 Remaining 99 % Used Account: 135-50030-026-000 Social Security Taxes 1991 08/02/2013 Payroll 8/2/13 Social Security Taxes 539.40 43.40 582.80 PR 2138 08/30/2013 Payroll 8/30/13 Social Security Taxes 31.00 613.80 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 74.40 613.80 ** 620.00 Budgeted 6.20 Remaining 99 % Used Account: 135-50035-026-000 Medicare Taxes 1991 08/02/2013 Payroll 8/2/13 Medicare Taxes 126.15 10.15 136.30 PR 2138 08/30/2013 Payroll 8/30/13 Medicare Taxes 7.25 143.55 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 17.40 143.55 ** 145.00 Budgeted 1.45 Remaining 99 % Used Account: 135-50040-026-000 Unemployment Taxes 1991 08/02/2013 Payroll 8/2/13 Unemployment Taxes 67.50 .70 68.20 PR 2138 08/30/2013 Payroll 8/30/13 Unemployment Taxes .50 68.70 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.20 68.70 ** 210.00 Budgeted 141.30 Remaining 33 % Used Account: 135-50045-026-000 Workman's Compensation 7.88 .00 7.88 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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 2111 08/21/2013 August A/P Town Hall Moderator 456.97 1,500.00 1,956.97 Strategic Government Resources 32910 AP 2228 08/26/2013 7/27/13-8/26/13 PCards WEINBERGERS DELI TWO 59.99 2,016.96 WEINBERGERS DELI TWO PC 2228 08/26/2013 7/27/13-8/26/13 PCards TOM THUMB STOR00017897 10.25 2,027.21 TOM THUMB STOR00017897 PC 2228 08/26/2013 7/27/13-8/26/13 PCards SAMSCLUB #4795 10.44 2,037.65 SAMSCLUB #4795 PC 2228 08/26/2013 7/27/13-8/26/13 PCards NW METROPORT CHAMBER O 22.00 2,059.65 NW METROPORT CHAMBER O PC _______________ Account: 135-60075-026-000 Meetings Totals: 1,602.68 2,059.65 ** 1,200.00 Budgeted (859.65) Remaining 172 % Used Account: 135-60080-026-000 Schools & Training 2,655.00 .00 2,655.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 2,655.00 ** 4,000.00 Budgeted 1,345.00 Remaining 66 % Used Account: 135-60100-026-000 Travel & per diem 5,727.01 .00 5,727.01 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 5,727.01 ** 5,000.00 Budgeted (727.01) Remaining 115 % 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 2076 08/15/2013 August AP sign for girls golf 267.88 205.85 473.73 DALLAS LITE & BARRICADE, INC 32851 AP _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 205.85 473.73 ** 3,000.00 Budgeted 2,526.27 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 26 Totals: ------------------------------------------------------------------------------------------------ 21,798.42 ** 26,575.00 Budgeted 4,776.58 Remaining 82 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 1991 08/02/2013 Payroll 8/2/13 Salaries & Wages 340,235.19 16,562.82 356,798.01 PR 2061 08/16/2013 Payroll 8/16/13 Salaries & Wages 16,578.13 373,376.14 PR 2138 08/30/2013 Payroll 8/30/13 Salaries & Wages 16,572.00 389,948.14 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 49,712.95 389,948.14 ** 444,730.00 Budgeted 54,781.86 Remaining 88 % Used Account: 135-50010-030-000 Overtime 1991 08/02/2013 Payroll 8/2/13 Overtime 264.61 1.34 265.95 PR 2061 08/16/2013 Payroll 8/16/13 Overtime 9.81 275.76 PR 2138 08/30/2013 Payroll 8/30/13 Overtime 5.69 281.45 PR _______________ Account: 135-50010-030-000 Overtime Totals: 16.84 281.45 ** 1,500.00 Budgeted 1,218.55 Remaining 19 % 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 1991 08/02/2013 Payroll 8/2/13 Retirement 81,298.27 1,487.46 82,785.73 PR 2061 08/16/2013 Payroll 8/16/13 Retirement 1,489.62 84,275.35 PR 2138 08/30/2013 Payroll 8/30/13 Retirement 1,488.66 85,764.01 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,465.74 85,764.01 ** 104,801.00 Budgeted 19,036.99 Remaining 82 % Used Account: 135-50026-030-000 Medical Insurance 1991 08/02/2013 Payroll 8/2/13 Medical Insurance 40,272.60 2,194.07 42,466.67 PR 2061 08/16/2013 Payroll 8/16/13 Medical Insurance 2,194.03 44,660.70 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 44,660.70 ** 49,049.00 Budgeted 4,388.30 Remaining 91 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1991 08/02/2013 Payroll 8/2/13 Dental Insurance 3,570.54 193.19 3,763.73 PR 2061 08/16/2013 Payroll 8/16/13 Dental Insurance 193.15 3,956.88 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 386.34 3,956.88 ** 3,379.00 Budgeted (577.88) Remaining 117 % Used Account: 135-50028-030-000 Vision Insurance 1991 08/02/2013 Payroll 8/2/13 Vision Insurance 776.23 41.29 817.52 PR 2061 08/16/2013 Payroll 8/16/13 Vision Insurance 41.24 858.76 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 858.76 ** 945.00 Budgeted 86.24 Remaining 91 % Used Account: 135-50029-030-000 Life Insurance & Other 1943 08/01/2013 August A/P August Dental, Life, AD&D, LTD 3,477.40 300.02 3,777.42 METLIFE 32818 AP 2076 08/15/2013 August AP FSA-Admin 36.75 3,814.17 Discovery Benefits 32852 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 336.77 3,814.17 ** 2,582.00 Budgeted (1,232.17) Remaining 148 % Used Account: 135-50030-030-000 Social Security Taxes 1991 08/02/2013 Payroll 8/2/13 Social Security Taxes 20,232.97 956.93 21,189.90 PR 2061 08/16/2013 Payroll 8/16/13 Social Security Taxes 953.87 22,143.77 PR 2138 08/30/2013 Payroll 8/30/13 Social Security Taxes 1,027.82 23,171.59 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,938.62 23,171.59 ** 27,802.00 Budgeted 4,630.41 Remaining 83 % Used Account: 135-50035-030-000 Medicare Taxes 1991 08/02/2013 Payroll 8/2/13 Medicare Taxes 4,731.92 223.79 4,955.71 PR 2061 08/16/2013 Payroll 8/16/13 Medicare Taxes 223.08 5,178.79 PR 2138 08/30/2013 Payroll 8/30/13 Medicare Taxes 240.37 5,419.16 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 687.24 5,419.16 ** 6,502.00 Budgeted 1,082.84 Remaining 83 % Used Account: 135-50040-030-000 Unemployment Taxes 439.29 .00 439.29 . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-030-000 Unemployment Taxes Totals: .00 439.29 ** 1,537.00 Budgeted 1,097.71 Remaining 29 % Used Account: 135-50045-030-000 Workman's Compensation 938.60 .00 938.60 _______________ Account: 135-50045-030-000 Workman's Compensation Totals: .00 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 2228 08/26/2013 7/27/13-8/26/13 PCards CHICK-FIL-A #02892 2,831.85 20.25 2,852.10 CHICK-FIL-A #02892 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 20.25 2,852.10 ** 5,000.00 Budgeted 2,147.90 Remaining 57 % Used Account: 135-55030-030-000 Software & Support 2076 08/15/2013 August AP STW services through 4/30/2013 55,897.77 1,776.50 57,674.27 STW INC 32886 AP 2111 08/21/2013 August A/P Symonds, 1st Check, Carenow, P 363.30 58,037.57 TOWN OF TROPHY CLUB 32911 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 2,139.80 58,037.57 ** 63,555.00 Budgeted 5,517.43 Remaining 91 % Used Account: 135-55070-030-000 Independent Labor 2111 08/21/2013 August A/P Record MUD Budget Meeting 5,472.67 116.25 5,588.92 JOHN CHARLES HALL 32906 AP 2139 08/27/2013 A/P August A/C repair, Toner 62.50 5,651.42 TOWN OF TROPHY CLUB 32935 AP 2139 08/27/2013 A/P August Rate study 11,639.55 17,290.97 NEW GEN STRATEGIES & SOLUTIONS 32928 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 11,818.30 17,290.97 ** 7,700.00 Budgeted (9,590.97) Remaining 225 % Used Account: 135-55075-030-000 Records Management . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 2076 08/15/2013 August AP Generator Maintenance 810.52 810.52 1,621.04 ENTECH SALES AND SERVICE INC 32856 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 810.52 1,621.04 ** 811.00 Budgeted (810.04) Remaining 200 % Used Account: 135-55100-030-000 Building Maint & Supplies 2076 08/15/2013 August AP mat service 4,491.38 84.15 4,575.53 G & K SERVICES 32858 AP 2076 08/15/2013 August AP mat service 84.15 4,659.68 G & K SERVICES 32858 AP 2076 08/15/2013 August AP Mat service 84.15 4,743.83 G & K SERVICES 32858 AP 2076 08/15/2013 August AP Mat service 84.15 4,827.98 G & K SERVICES 32858 AP 2076 08/15/2013 August AP Mat service 84.15 4,912.13 G & K SERVICES 32858 AP 2076 08/15/2013 August AP mat service 84.15 4,996.28 G & K SERVICES 32858 AP 2111 08/21/2013 August A/P A/C Repair 666.50 5,662.78 NORTH TX HEATING & AIR, INC 32907 AP 2115 08/21/2013 Bill Town Inv 1063-1067 AR 20130801-20130821 User: (585.70) 5,077.08 AR 2139 08/27/2013 A/P August A/C repair, Toner 114.17 5,191.25 TOWN OF TROPHY CLUB 32935 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 699.87 5,191.25 ** 6,500.00 Budgeted 1,308.75 Remaining 80 % Used Account: 135-55120-030-000 Cleaning Services 2078 08/15/2013 August AP July janitorial service 15,554.27 1,678.51 17,232.78 ABM JANITORIAL SERVICES, INC 32843 AP 2078 08/15/2013 August AP answering service 180.00 17,412.78 KEYSTONE PARK SECRETARIAL 32866 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,858.51 17,412.78 ** 20,200.00 Budgeted 2,787.22 Remaining 86 % Used Account: 135-55160-030-000 Professional Outside Services 6,974.00 .00 6,974.00 _______________ 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 2076 08/15/2013 August AP Billing-July 5,738.74 560.32 6,299.06 DP2 BILLING SOLUTIONS, LLC 32853 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 560.32 6,299.06 ** 11,000.00 Budgeted 4,700.94 Remaining 57 % Used Account: 135-60005-030-000 Telephone 9,533.59 .00 9,533.59 _______________ Account: 135-60005-030-000 Telephone Totals: .00 9,533.59 ** 10,500.00 Budgeted 966.41 Remaining 91 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 2078 08/15/2013 August AP Verizon 2,949.17 176.70 3,125.87 TOWN OF TROPHY CLUB 32891 AP 2061 08/16/2013 Payroll 8/16/13 Communications/Pagers/Mobiles 150.00 3,275.87 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 326.70 3,275.87 ** 3,575.00 Budgeted 299.13 Remaining 92 % Used Account: 135-60020-030-000 Electricity/Gas 2078 08/15/2013 August AP electricity 6/13-7/15 11,291.26 1,260.50 12,551.76 TOWN OF TROPHY CLUB 32891 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,260.50 12,551.76 ** 13,019.00 Budgeted 467.24 Remaining 96 % Used Account: 135-60025-030-000 Water . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2076 08/15/2013 August AP Water-July 838.39 182.12 1,020.51 TROPHY CLUB MUD (WATER BILLS) 32894 AP 2115 08/21/2013 Bill Town Inv 1063-1067 AR 20130801-20130821 User: (91.06) 929.45 AR 2251 08/31/2013 Town billed Inv 1075 AR 20130801-20130831 User: (131.86) 797.59 AR _______________ Account: 135-60025-030-000 Water Totals: (40.80) 797.59 ** 3,100.00 Budgeted 2,302.41 Remaining 26 % Used Account: 135-60030-030-000 Rent And/Or Usage 2076 08/15/2013 August AP PS Bldg Rent/Aug 10,985.10 1,098.51 12,083.61 TOWN OF TROPHY CLUB 32891 AP _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 1,098.51 12,083.61 ** 13,182.00 Budgeted 1,098.39 Remaining 92 % Used Account: 135-60035-030-000 Postage 2183 08/06/2013 Postage purchased 22,882.99 (1.58) 22,881.41 GL 2059 08/12/2013 Aug A/P Water intake shutoff postcard 859.09 23,740.50 U.S. POSTAL SERVICE 32842 AP 2076 08/15/2013 August AP overnight letter 17.30 23,757.80 FEDERAL EXPRESS CORP 32857 AP 2076 08/15/2013 August AP overnight letters 11.16 23,768.96 FEDERAL EXPRESS CORP 32857 AP 2076 08/15/2013 August AP Billing-July 1,514.14 25,283.10 DP2 BILLING SOLUTIONS, LLC 32853 AP 2239 08/31/2013 August Postage Meter usage 198.95 25,482.05 GL _______________ Account: 135-60035-030-000 Postage Totals: 2,599.06 25,482.05 ** 26,604.00 Budgeted 1,121.95 Remaining 96 % Used Account: 135-60040-030-000 Service Charges & Fees 2076 08/15/2013 August AP safety dep box 23,674.17 32.50 23,706.67 TOWN OF TROPHY CLUB 32891 AP 2214 08/30/2013 Credit card/online fees 2,601.05 26,307.72 GL 2214 08/30/2013 Credit card/online fees 89.50 26,397.22 GL 2214 08/30/2013 Credit card/online fees 86.30 26,483.52 GL 2241 08/31/2013 Monthly Bank Analysis charge 250.00 26,733.52 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,059.35 26,733.52 ** 28,330.00 Budgeted 1,596.48 Remaining 94 % Used Account: 135-60050-030-000 Bad Debt Expense 1,001.40 .00 1,001.40 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 1,001.40 ** 8,500.00 Budgeted 7,498.60 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60055-030-000 Insurance 2076 08/15/2013 August AP Notary-Schafer 50,993.77 105.00 51,098.77 AMERICAN SURETY BOND 32846 AP _______________ Account: 135-60055-030-000 Insurance Totals: 105.00 51,098.77 ** 50,694.00 Budgeted (404.77) Remaining 101 % 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 2078 08/15/2013 August AP Annual membership renewal 4,271.95 220.00 4,491.95 COSTCO WHOLESALE 32850 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 220.00 4,491.95 ** 3,892.00 Budgeted (599.95) Remaining 115 % Used Account: 135-60075-030-000 Meetings 2228 08/26/2013 7/27/13-8/26/13 PCards STARBUCKS #06552 TROPH 283.85 14.61 298.46 STARBUCKS #06552 TROPH PC 2228 08/26/2013 7/27/13-8/26/13 PCards NW METROPORT CHAMBER O 44.00 342.46 NW METROPORT CHAMBER O PC _______________ Account: 135-60075-030-000 Meetings Totals: 58.61 342.46 ** 400.00 Budgeted 57.54 Remaining 86 % Used Account: 135-60080-030-000 Schools & Training 2228 08/26/2013 7/27/13-8/26/13 PCards NCTCOG PBLCTNS & SRVCS 3,759.23 (125.00) 3,634.23 NCTCOG PBLCTNS & SRVCS PC _______________ Account: 135-60080-030-000 Schools & Training Totals: (125.00) 3,634.23 ** 5,350.00 Budgeted 1,715.77 Remaining 68 % Used Account: 135-60100-030-000 Travel & per diem 1991 08/02/2013 Payroll 8/2/13 Travel & per diem 4,460.44 15.37 4,475.81 PR 2155 08/29/2013 August A/P Mileage-Notary Training 23.73 4,499.54 Marsha Schaefer 32940 AP 2138 08/30/2013 Payroll 8/30/13 Travel & per diem 31.24 4,530.78 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 70.34 4,530.78 ** 3,616.00 Budgeted (914.78) Remaining 125 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-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 2228 08/26/2013 7/27/13-8/26/13 PCards STAR TELEGRAM ADVERTIS 2,691.64 2,658.48 5,350.12 STAR TELEGRAM ADVERTIS PC _______________ Account: 135-60125-030-000 Advertising Totals: 2,658.48 5,350.12 ** 4,000.00 Budgeted (1,350.12) Remaining 134 % Used Account: 135-60235-030-000 Security 505.13 .00 505.13 _______________ Account: 135-60235-030-000 Security Totals: .00 505.13 ** 1,350.00 Budgeted 844.87 Remaining 37 % Used Account: 135-60243-030-000 Prior Year Expense 3,290.58 .00 3,290.58 _______________ Account: 135-60243-030-000 Prior Year Expense Totals: .00 3,290.58 ** 1,263.00 Budgeted (2,027.58) Remaining 261 % Used Account: 135-60245-030-000 Miscellaneous Expenses 2111 08/21/2013 August A/P Audio/Video upgrade deposit 1,190.59 7,971.23 9,161.82 PREMIER AUDIO & VIDEO LLC 32908 AP 2228 08/26/2013 7/27/13-8/26/13 PCards SAMSCLUB #4795 3.84 9,165.66 SAMSCLUB #4795 PC 2228 08/26/2013 7/27/13-8/26/13 PCards ROANOKE FLORIST 60.00 9,225.66 ROANOKE FLORIST PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 8,035.07 9,225.66 ** 13,500.00 Budgeted 4,274.34 Remaining 68 % Used Account: 135-60270-030-000 4th of July Celebration 10,099.01 .00 10,099.01 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 10,099.01 ** 10,500.00 Budgeted 400.99 Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60281-030-000 Park Expenses 32,502.00 .00 32,502.00 _______________ Account: 135-60281-030-000 Park Expenses Totals: .00 32,502.00 ** 42,500.00 Budgeted 9,998.00 Remaining 76 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 2215 08/20/2013 Texpool Xfer-PID Conn to I&S 161,000.00 34,000.00 195,000.00 GL _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: 34,000.00 195,000.00 ** .00 Budgeted (195,000.00) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 3,986.76 .00 3,986.76 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 3,986.76 ** 2,500.00 Budgeted (1,486.76) Remaining 159 % 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 12,129.34 .00 12,129.34 _______________ Account: 135-65055-030-000 Hardware Totals: .00 12,129.34 ** 20,188.00 Budgeted 8,058.66 Remaining 60 % Used Account: 135-65085-030-000 Office Supplies 2076 08/15/2013 August AP office supplies 7,472.40 108.22 7,580.62 OFFICE DEPOT, INC 32876 AP 2115 08/21/2013 Bill Town Inv 1063-1067 AR 20130801-20130821 User: (27.49) 7,553.13 AR 2139 08/27/2013 A/P August copy paper 54.98 7,608.11 OFFICE DEPOT, INC 32929 AP 2159 08/29/2013 August A/P Town JPChase-Copy Paper 71.30 7,679.41 TOWN OF TROPHY CLUB 32945 AP 2251 08/31/2013 Town billed Inv 1075 AR 20130801-20130831 User: (27.49) 7,651.92 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 179.52 7,651.92 ** 8,200.00 Budgeted 548.08 Remaining 93 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-65090-030-000 Printer Supplies & Maintenance 2111 08/21/2013 August A/P Symonds, 1st Check, Carenow, P 3,078.75 30.00 3,108.75 TOWN OF TROPHY CLUB 32911 AP 2139 08/27/2013 A/P August A/C repair, Toner 233.50 3,342.25 TOWN OF TROPHY CLUB 32935 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 263.50 3,342.25 ** 5,732.00 Budgeted 2,389.75 Remaining 58 % Used Account: 135-65095-030-000 Maintenance Supplies 2228 08/26/2013 7/27/13-8/26/13 PCards GREAT COFFEES OF AMERI 2,904.40 122.24 3,026.64 GREAT COFFEES OF AMERI PC 2228 08/26/2013 7/27/13-8/26/13 PCards SAMSCLUB #4795 245.31 3,271.95 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 367.55 3,271.95 ** 1,500.00 Budgeted (1,771.95) Remaining 218 % Used Account: 135-65097-030-000 Vending Machine Supplies 2189 08/30/2013 WWTP Vending 78.70 15.88 94.58 GL _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: 15.88 94.58 ** 500.00 Budgeted 405.42 Remaining 19 % Used Account: 135-65105-030-000 Printing 2,135.66 .00 2,135.66 _______________ Account: 135-65105-030-000 Printing Totals: .00 2,135.66 ** 4,200.00 Budgeted 2,064.34 Remaining 51 % Used Account: 135-69170-030-000 Copier Lease Installments 2076 08/15/2013 August AP copier lease 2,311.65 256.85 2,568.50 TOWN OF TROPHY CLUB 32891 AP 2139 08/27/2013 A/P August A/C repair, Toner 256.85 2,825.35 TOWN OF TROPHY CLUB 32935 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 513.70 2,825.35 ** 3,450.00 Budgeted 624.65 Remaining 82 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 .00 26,911.00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 26,911.00 ** 26,911.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 30 Totals: ------------------------------------------------------------------------------------------------ 1,238,249.30 ** 1,182,142.00 Budgeted (56,107.30) Remaining 105 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 2076 08/15/2013 August AP Legal 189,882.41 84.00 189,966.41 WHITAKER CHALK SWINDLE 32897 AP 2076 08/15/2013 August AP Legal 67.20 190,033.61 WHITAKER CHALK SWINDLE 32897 AP 2076 08/15/2013 August AP Legal 99.18 190,132.79 WHITAKER CHALK SWINDLE 32897 AP 2076 08/15/2013 August AP Legal 1,008.00 191,140.79 WHITAKER CHALK SWINDLE 32897 AP 2076 08/15/2013 August AP Legal 285.60 191,426.39 WHITAKER CHALK SWINDLE 32897 AP 2076 08/15/2013 August AP Legal 302.40 191,728.79 WHITAKER CHALK SWINDLE 32897 AP 2076 08/15/2013 August AP July legal 3,678.57 195,407.36 THE LISTON LAW FIRM, P.C. 32889 AP 2142 08/27/2013 August A/P Legal 57,500.00 252,907.36 THE LISTON LAW FIRM, P.C. 32934 AP 2244 08/31/2013 August A/P August legal 8,752.75 261,660.11 THE LISTON LAW FIRM, P.C. 32983 AP _______________ Account: 135-55045-039-000 Legal Totals: 71,777.70 261,660.11 ** 70,000.00 Budgeted (191,660.11) Remaining 374 % 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 8,152.22 .00 8,152.22 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,152.22 ** 15,100.00 Budgeted 6,947.78 Remaining 54 % Used Account: 135-55065-039-000 Tax Admin Fees 2,390.56 .00 2,390.56 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,390.56 ** 3,800.00 Budgeted 1,409.44 Remaining 63 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 112,333.21 .00 112,333.21 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 112,333.21 ** .00 Budgeted (112,333.21) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 39 Totals: ------------------------------------------------------------------------------------------------ 405,236.10 ** 110,100.00 Budgeted (295,136.10) Remaining 368 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 281,284.07 .00 Budgeted (281,284.07) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (56,911.00) .00 (56,911.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (56,911.00) ** .00 Budgeted 56,911.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (41,890.00) .00 (41,890.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (41,890.00) ** .00 Budgeted 41,890.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (98,801.00) ** .00 Budgeted 98,801.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (98,801.00) .00 Budgeted 98,801.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 8/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 2213 08/30/2013 August Bank interest (85.23) (12.25) (97.48) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (12.25) (97.48) ** (100.00) Budgeted (2.52) Remaining 97 % Used Department Totals: ------------------------------------------------------------------------------------------------ (445,097.48) ** (445,100.00) Budgeted (2.52) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 8/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-69005-010-001 Capital Exp/Security Cameras 6,289.00 .00 6,289.00 _______________ Account: 507-69005-010-001 Capital Exp/Security Cameras Totals: .00 6,289.00 ** 5,800.00 Budgeted (489.00) Remaining 108 % Used Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter 2054 08/01/2013 Rey-Mar App 2 retainage/ROFC 53,875.50 1,814.76 55,690.26 GL 2076 08/15/2013 August AP ROFC FW Meter 16,332.82 72,023.08 REY-MAR CONSTRUCTION 32881 AP 2158 08/25/2013 ROFC Retainage APP 3 1,751.03 73,774.11 GL 2159 08/29/2013 August A/P ROFC Improvements 2,887.50 76,661.61 DELTATEK ENGINEERING 32937 AP 2159 08/29/2013 August A/P App 3 ROFC Project 15,759.25 92,420.86 REY-MAR CONSTRUCTION 32944 AP _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: 38,545.36 92,420.86 ** 165,000.00 Budgeted 72,579.14 Remaining 56 % Used Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 15,593.83 .00 15,593.83 _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: .00 15,593.83 ** 210,000.00 Budgeted 194,406.17 Remaining 7 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 114,303.69 ** 380,800.00 Budgeted 266,496.31 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 8/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 Exp/Security Cameras 8,578.00 .00 8,578.00 _______________ Account: 507-69005-020-001 Capital Exp/Security Cameras Totals: .00 8,578.00 ** 8,200.00 Budgeted (378.00) Remaining 105 % Used Account: 507-69005-020-004 Capital Exp/Sludge Blanket Ind .00 .00 _______________ Account: 507-69005-020-004 Capital Exp/Sludge Blanket Ind Totals: .00 .00 ** 18,000.00 Budgeted 18,000.00 Remaining 0 % Used Account: 507-69005-020-005 Capital Exp/Port Sub Pump 8,553.92 .00 8,553.92 _______________ Account: 507-69005-020-005 Capital Exp/Port Sub Pump Totals: .00 8,553.92 ** 10,000.00 Budgeted 1,446.08 Remaining 86 % Used Account: 507-69280-020-006 Capital Repairs/Waste Pump 27,960.70 .00 27,960.70 _______________ Account: 507-69280-020-006 Capital Repairs/Waste Pump 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: ------------------------------------------------------------------------------------------------------ (247,599.75) (100.00) Budgeted 247,499.75 Remaining ########## . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 8/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 (112,333.21) .00 (112,333.21) _______________ Account: 522-49145-000-000 Intergov Transfer-General Fund Totals: .00 (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 TROPHY CLUB MUD #1 - I&S BALANCE SHEET AUGUST 31, 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 1,397 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 11,916 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 18,159 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 11,916 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 11,916 FUND BALANCE ASSIGNED FUND BALANCE 136,417 NET REVENUES / EXPENDITURES (130,174) TOTAL FUND BALANCE 6,243 TOTAL LIABILITIES AND FUND BALANCE 18,159 . glbase_tbam rgonzale Trophy Club MUD #1 Page 26 13:02 09/12/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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- 344.28- 198,126.46- 100.602 1,186.46 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 3,027.40- 77.626 872.60- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 39.63- 1,679.01- 33.466 3,337.99- Subtotal: 205,857.00- 205,857.00- 383.91- 202,832.87- 98.531 3,024.13- 533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 34,000.00- 195,000.00- 56.522 150,000.00- Subtotal: 345,000.00- 345,000.00- 34,000.00- 195,000.00- 56.522 150,000.00- 533-49010-000-000 Interest Income 1,700.00- 1,700.00- 21.64- 325.54- 19.149 1,374.46- 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- 21.64- 308,325.54- 99.556 1,374.46- Program number: 860,557.00- 860,557.00- 34,405.55- 706,158.41- 82.058 154,398.59- Department number: Revenues 860,557.00- 860,557.00- 34,405.55- 706,158.41- 82.058 154,398.59- Revenues Subtotal ----------- 860,557.00- 860,557.00- 34,405.55- 706,158.41- 82.058 154,398.59- . glbase_tbam rgonzale Trophy Club MUD #1 Page 27 13:02 09/12/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/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 2,300.00 57.500 1,700.00 533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 114,516.25 229,032.50 100.000 .50 533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00 605,000.00 100.000 Subtotal: 838,033.00 838,033.00 719,516.25 836,332.50 99.797 1,700.50 Program number: 838,033.00 838,033.00 719,516.25 836,332.50 99.797 1,700.50 Department number: Administration 838,033.00 838,033.00 719,516.25 836,332.50 99.797 1,700.50 Expenditures Subtotal ----------- 838,033.00 838,033.00 719,516.25 836,332.50 99.797 1,700.50 Fund number: 533 MUD 1 I&S Consolidated 22,524.00- 22,524.00- 685,110.70 130,174.09 -577.935 152,698.09- ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 64 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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 2195 08/01/2013 Property Tax/Assessments (197,782.18) (122.76) (197,904.94) GL 2196 08/02/2013 Property Taxes/Assessments (33.81) (197,938.75) GL 2197 08/08/2013 Property Taxes/Assessments (39.36) (197,978.11) GL 2199 08/12/2013 Property Taxes/Assessments (55.67) (198,033.78) GL 2200 08/15/2013 Property Taxes/Assessments 1.51 (198,032.27) GL 2203 08/16/2013 Property Taxes/Assessments (51.99) (198,084.26) GL 2201 08/20/2013 Property Taxes/Assessments (41.02) (198,125.28) GL 2202 08/22/2013 Property Taxes/Assessments (1.18) (198,126.46) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (344.28) (198,126.46) ** (196,940.00) Budgeted 1,186.46 Remaining 101 % Used Account: 533-40002-000-000 Property Taxes/Delinquent (3,027.40) .00 (3,027.40) _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 (3,027.40) ** (3,900.00) Budgeted (872.60) Remaining 78 % Used Account: 533-40015-000-000 Property Taxes/P & I 2195 08/01/2013 Property Tax/Assessments (1,639.38) (12.21) (1,651.59) GL 2196 08/02/2013 Property Taxes/Assessments (6.43) (1,658.02) GL 2197 08/08/2013 Property Taxes/Assessments (.40) (1,658.42) GL 2199 08/12/2013 Property Taxes/Assessments (7.90) (1,666.32) GL 2203 08/16/2013 Property Taxes/Assessments (4.68) (1,671.00) GL 2201 08/20/2013 Property Taxes/Assessments (7.79) (1,678.79) GL 2202 08/22/2013 Property Taxes/Assessments (.22) (1,679.01) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (39.63) (1,679.01) ** (5,017.00) Budgeted (3,337.99) Remaining 33 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees 2215 08/20/2013 Texpool Xfer-PID Conn to I&S (161,000.00) (34,000.00) (195,000.00) GL _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: (34,000.00) (195,000.00) ** (345,000.00) Budgeted (150,000.00) Remaining 57 % Used Account: 533-49010-000-000 Interest Income 2213 08/30/2013 August Bank interest (303.90) (21.64) (325.54) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 65 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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-49010-000-000 Interest Income Totals: (21.64) (325.54) ** (1,700.00) Budgeted (1,374.46) Remaining 19 % 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: ------------------------------------------------------------------------------------------------ (706,158.41) ** (860,557.00) Budgeted (154,398.59) Remaining 82 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 66 13:02 09/12/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/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 2,300.00 .00 2,300.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 2,300.00 ** 4,000.00 Budgeted 1,700.00 Remaining 58 % Used Account: 533-70025-051-000 Bond Interest Expense 2180 08/27/2013 9/1/13 Bond Payments Bond Payment Series 2003 114,516.25 15,645.00 130,161.25 GL 2180 08/27/2013 9/1/13 Bond Payments Bond Payment Series 2005 29,267.50 159,428.75 GL 2180 08/27/2013 9/1/13 Bond Payments Bond Payment Series 2010 39,228.75 198,657.50 GL 2180 08/27/2013 9/1/13 Bond Payments Bond Payment Series 2012 30,375.00 229,032.50 GL _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: 114,516.25 229,032.50 ** 229,033.00 Budgeted .50 Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment 2180 08/27/2013 9/1/13 Bond Payments Bond Payment Series 2003 60,000.00 60,000.00 GL 2180 08/27/2013 9/1/13 Bond Payments Bond Payment Series 2005 295,000.00 355,000.00 GL 2180 08/27/2013 9/1/13 Bond Payments Bond Payment Series 2010 65,000.00 420,000.00 GL 2180 08/27/2013 9/1/13 Bond Payments Bond Payment Series 2012 185,000.00 605,000.00 GL _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: 605,000.00 605,000.00 ** 605,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 836,332.50 ** 838,033.00 Budgeted 1,700.50 Remaining 100 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ 130,174.09 (22,524.00) Budgeted (152,698.09) Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (272,089.13) **** (22,624.00) Budgeted 249,465.13 Remaining ########## ******* End of Report *********