Loading...
HomeMy WebLinkAboutSeptember FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER, 2013 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK 120 INVESTMENTS 514,049 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 14,384 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 1 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,918 TOTAL ASSETS 530,472 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 14,385 ACCOUNTS AND OTHER PAYABLES 6,626 TOTAL LIABILITIES 21,011 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - UNASSIGNED FUND BALANCE 350,496 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 158,967 TOTAL FUND BALANCE 509,463 TOTAL LIABILITIES AND FUND BALANCE 530,474 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 18:00 10/09/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/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- 255,124.19- 101.206 3,040.19 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 700.00- 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- 281.81- 1,056,919.69- 100.626 6,570.69 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 2,996.13 -51.657 8,796.13- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 2,490.31- 332.041 1,740.31 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 45.60- 4,549.78- 101.106 49.78 Subtotal: 1,318,183.00- 1,314,183.00- 327.41- 1,325,122.87- 100.832 10,939.87 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 6,800.00- 113.333 800.00 Subtotal: 6,000.00- 6,000.00- 6,800.00- 113.333 800.00 122-43400-000-000 Fire Inspections 500.00- 675.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- 11,350.00- 106.323 675.00 122-49025-000-000 Auction Sales 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- 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- 15,520.22- 146.238 4,907.22 Program number: 1,335,883.00- 1,341,471.00- 327.41- 1,358,793.09- 101.291 17,322.09 Department number: Fire Revenues 1,335,883.00- 1,341,471.00- 327.41- 1,358,793.09- 101.291 17,322.09 Revenues Subtotal ----------- 1,335,883.00- 1,341,471.00- 327.41- 1,358,793.09- 101.291 17,322.09 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 18:00 10/09/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 444,717.00 444,717.00 33,955.56 432,859.50 97.334 11,857.50 122-50010-045-000 Overtime 31,375.00 37,076.00 3,241.77 39,144.83 105.580 2,068.83- 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 339.39 4,924.48 81.748 1,099.52 122-50020-045-000 Retirement 69,242.00 69,242.00 5,086.25 68,676.76 99.184 565.24 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,681.92 41,952.82 86.810 6,374.18 122-50027-045-000 Dental Insurance 3,635.00 3,836.00 328.92 3,856.72 100.540 20.72- 122-50028-045-000 Vision Insurance 824.00 824.00 69.12 799.79 97.062 24.21 122-50029-045-000 Life Insurance & Other 4,250.00 5,974.00 407.82 5,716.53 95.690 257.47 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,127.23 29,026.97 93.948 1,870.03 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 497.51 6,788.49 93.945 437.51 122-50040-045-000 Unemployment Taxes 1,481.00 1,980.00 1.05 140.62 7.102 1,839.38 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 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 49,736.54 660,962.91 96.541 23,684.09 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 247.35 8,798.62 92.017 763.38 122-55090-045-000 Vehicle Maintenance 14,850.00 14,600.00 5,324.02 10,847.00 74.295 3,753.00 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 2,350.00 8,868.15 90.418 939.85 122-55100-045-000 Building Maintenance 6,500.00 5,500.00 594.17 5,020.65 91.285 479.35 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 405.50 856.80 77.679 246.20 122-55160-045-000 Professional Outside Services 2,500.00 Subtotal: 44,323.00 45,573.00 8,921.04 37,446.94 82.169 8,126.06 122-60005-045-000 Telephone 106.00 106.00 22.43 77.05 72.689 28.95 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 3,500.00 354.01 3,867.16 110.490 367.16- 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 633.36 7,198.70 116.729 1,031.70- 122-60025-045-000 Water 1,400.00 1,400.00 308.62 1,506.29 107.592 106.29- 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 32.23 75.27 75.270 24.73 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 490.93 490.93 119.739 80.93- 122-60070-045-000 Dues & Memberships 7,500.00 8,000.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 487.20 3,609.70 72.194 1,390.30 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 1,720.00 1,720.00 86.000 280.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 18:00 10/09/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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 248.75 3,807.41 90.653 392.59 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 857.50 2,452.92 106.974 159.92- 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 84.16 1,400.70 113.234 163.70- Subtotal: 359,088.00 362,676.00 5,239.19 360,628.94 99.436 2,047.06 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 759.39 7,501.28 75.013 2,498.72 122-65010-045-000 Uniforms 4,357.00 3,357.00 1,150.16 2,429.60 72.374 927.40 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 10.95 385.30 32.108 814.70 122-65095-045-000 Maintenance Supplies 2,785.00 1,988.00 357.51 2,224.51 111.897 236.51- 122-65105-045-000 Printing 106.00 Subtotal: 32,048.00 27,545.00 2,278.01 25,613.11 92.986 1,931.89 122-69006-045-000 Grant Match 3,000.00 122-69008-045-000 Short Term Debt-Principal 72,932.00 72,932.00 69,966.05 95.933 2,965.95 122-69009-045-000 Short Term Debt-Interest 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 115,175.23 52.108 105,854.77 Program number: 1,335,883.00 1,341,471.00 66,174.78 1,199,827.13 89.441 141,643.87 Department number: Fire 1,335,883.00 1,341,471.00 66,174.78 1,199,827.13 89.441 141,643.87 Expenditures Subtotal ----------- 1,335,883.00 1,341,471.00 66,174.78 1,199,827.13 89.441 141,643.87 Fund number: 122 Trophy Club MUD Fire Dept. 65,847.37 158,965.96- 158,965.96 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/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 (255,124.19) .00 (255,124.19) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (255,124.19) ** (252,084.00) Budgeted 3,040.19 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (9,035.03) .00 (9,035.03) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (9,035.03) ** (700.00) Budgeted 8,335.03 Remaining ########## Account: 122-40010-000-000 Property Taxes/MUD Fire 2373 09/03/2013 Property Taxes/Assessments (1,056,637.88) (189.29) (1,056,827.17) GL 2374 09/18/2013 Property Taxes/Assessments (73.78) (1,056,900.95) GL 2375 09/19/2013 Property Taxes/Assessments (18.74) (1,056,919.69) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (281.81) (1,056,919.69) ** (1,050,349.00) Budgeted 6,570.69 Remaining 101 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2,996.13 .00 2,996.13 _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: .00 2,996.13 ** (5,800.00) Budgeted (8,796.13) Remaining -52 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I (2,490.31) .00 (2,490.31) _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 (2,490.31) ** (750.00) Budgeted 1,740.31 Remaining 332 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2373 09/03/2013 Property Taxes/Assessments (4,504.18) (35.96) (4,540.14) GL 2374 09/18/2013 Property Taxes/Assessments (5.90) (4,546.04) GL 2375 09/19/2013 Property Taxes/Assessments (3.74) (4,549.78) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (45.60) (4,549.78) ** (4,500.00) Budgeted 49.78 Remaining 101 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/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-42014-000-000 Fire Plan Review>6,000 sq ft (6,800.00) .00 (6,800.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (6,800.00) ** (6,000.00) Budgeted 800.00 Remaining 113 % Used Account: 122-43400-000-000 Fire Inspections (1,350.00) .00 (1,350.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .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 (540.00) .00 (540.00) _______________ Account: 122-49025-000-000 Auction Sales Totals: .00 (540.00) ** .00 Budgeted 540.00 Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (5,413.00) Budgeted (5,413.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income (10,639.26) .00 (10,639.26) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (10,639.26) ** (5,200.00) Budgeted 5,439.26 Remaining 205 % Used Account: 122-49903-000-000 Recovery of Prior Year Expense . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (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,793.09) ** (1,341,471.00) Budgeted 17,322.09 Remaining 101 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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 2365 09/13/2013 FD Payroll 9/13/13 398,903.94 16,865.62 415,769.56 GL 2367 09/27/2013 FD Payroll 9/27/13 17,089.94 432,859.50 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 33,955.56 432,859.50 ** 444,717.00 Budgeted 11,857.50 Remaining 97 % Used Account: 122-50010-045-000 Overtime 2367 09/27/2013 FD Payroll 9/27/13 35,903.06 3,241.77 39,144.83 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,241.77 39,144.83 ** 37,076.00 Budgeted (2,068.83) Remaining 106 % 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 2365 09/13/2013 FD Payroll 9/13/13 4,585.09 339.39 4,924.48 GL _______________ Account: 122-50017-045-000 Certification Totals: 339.39 4,924.48 ** 6,024.00 Budgeted 1,099.52 Remaining 82 % Used Account: 122-50020-045-000 Retirement 2365 09/13/2013 FD Payroll 9/13/13 63,590.51 2,328.65 65,919.16 GL 2367 09/27/2013 FD Payroll 9/27/13 2,757.60 68,676.76 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,086.25 68,676.76 ** 69,242.00 Budgeted 565.24 Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 2365 09/13/2013 FD Payroll 9/13/13 38,270.90 1,840.96 40,111.86 GL 2367 09/27/2013 FD Payroll 9/27/13 1,840.96 41,952.82 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,681.92 41,952.82 ** 48,327.00 Budgeted 6,374.18 Remaining 87 % Used Account: 122-50027-045-000 Dental Insurance 2365 09/13/2013 FD Payroll 9/13/13 3,527.80 164.46 3,692.26 GL 2367 09/27/2013 FD Payroll 9/27/13 164.46 3,856.72 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 328.92 3,856.72 ** 3,836.00 Budgeted (20.72) Remaining 101 % Used Account: 122-50028-045-000 Vision Insurance 2365 09/13/2013 FD Payroll 9/13/13 730.67 34.56 765.23 GL 2367 09/27/2013 FD Payroll 9/27/13 34.56 799.79 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 69.12 799.79 ** 824.00 Budgeted 24.21 Remaining 97 % Used Account: 122-50029-045-000 Life Insurance & Other 2365 09/13/2013 FD Payroll 9/13/13 5,308.71 203.94 5,512.65 GL 2367 09/27/2013 FD Payroll 9/27/13 203.88 5,716.53 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 407.82 5,716.53 ** 5,974.00 Budgeted 257.47 Remaining 96 % Used Account: 122-50030-045-000 Social Security Taxes 2365 09/13/2013 FD Payroll 9/13/13 26,899.74 966.67 27,866.41 GL 2367 09/27/2013 FD Payroll 9/27/13 1,160.56 29,026.97 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,127.23 29,026.97 ** 30,897.00 Budgeted 1,870.03 Remaining 94 % Used Account: 122-50035-045-000 Medicare Taxes 2365 09/13/2013 FD Payroll 9/13/13 6,290.98 226.10 6,517.08 GL 2367 09/27/2013 FD Payroll 9/27/13 271.41 6,788.49 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 497.51 6,788.49 ** 7,226.00 Budgeted 437.51 Remaining 94 % Used Account: 122-50040-045-000 Unemployment Taxes 2365 09/13/2013 FD Payroll 9/13/13 139.57 .49 140.06 GL 2367 09/27/2013 FD Payroll 9/27/13 .56 140.62 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 1.05 140.62 ** 1,980.00 Budgeted 1,839.38 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 454.13 .00 454.13 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 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 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 2284 09/19/2013 Sept A/P Qtrly test on Bauer Air System 8,551.27 187.75 8,739.02 AUGUST INDUSTRIES, INC 32989 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 8,551.27 59.60 8,798.62 THE HOME DEPOT 6581 PC _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 247.35 8,798.62 ** 9,562.00 Budgeted 763.38 Remaining 92 % Used Account: 122-55090-045-000 Vehicle Maintenance 2245 09/10/2013 September A/P vehicle maintenance 5,522.98 4,767.52 10,290.50 SIDDONS-MARTIN EMERGENCY GROUP 32978 AP 2284 09/19/2013 Sept A/P Q681 repair hydraulic leak 527.50 10,818.00 SIDDONS-MARTIN EMERGENCY GROUP 33006 AP 2386 09/26/2013 PCards 8/27-9/26/13 KWIK KAR OF ROANOKE 14.50 10,832.50 KWIK KAR OF ROANOKE PC 2386 09/26/2013 PCards 8/27-9/26/13 KWIK KAR OF ROANOKE 14.50 10,847.00 KWIK KAR OF ROANOKE PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 5,324.02 10,847.00 ** 14,600.00 Budgeted 3,753.00 Remaining 74 % Used Account: 122-55095-045-000 Equipment Maintenance 2386 09/26/2013 PCards 8/27-9/26/13 DFW HONDA 6,518.15 2,350.00 8,868.15 DFW HONDA PC _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: 2,350.00 8,868.15 ** 9,808.00 Budgeted 939.85 Remaining 90 % Used Account: 122-55100-045-000 Building Maintenance 2245 09/10/2013 September A/P mat service 4,426.48 24.51 4,450.99 G & K SERVICES 32960 AP 2370 09/20/2013 Firefighters Sept Cable (120.00) 4,330.99 GL 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 62.72 4,393.71 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 65.92 4,459.63 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 ATT*BILL PAYMENT 157.83 4,617.46 ATT*BILL PAYMENT PC 2386 09/26/2013 PCards 8/27-9/26/13 ATT*BILL PAYMENT 128.68 4,746.14 ATT*BILL PAYMENT PC 2384 09/30/2013 September AP Mat service 24.51 4,770.65 G & K SERVICES 33059 AP 2384 09/30/2013 September AP Mat service 24.51 4,795.16 G & K SERVICES 33059 AP 2384 09/30/2013 September AP Door repair 250.00 5,045.16 OVERHEAD DOOR FORT WORTH 33073 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (24.51) 5,020.65 AR _______________ Account: 122-55100-045-000 Building Maintenance Totals: 594.17 5,020.65 ** 5,500.00 Budgeted 479.35 Remaining 91 % Used Account: 122-55110-045-000 Maintenance-Radios 2384 09/30/2013 September AP Maint-Radio 451.30 405.50 856.80 DFW COMMUNICATIONS, INC 33053 AP _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: 405.50 856.80 ** 1,103.00 Budgeted 246.20 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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-60005-045-000 Telephone 2284 09/19/2013 Sept A/P IT PCards/August 54.62 22.43 77.05 TOWN OF TROPHY CLUB 33011 AP _______________ Account: 122-60005-045-000 Telephone Totals: 22.43 77.05 ** 106.00 Budgeted 28.95 Remaining 73 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 2365 09/13/2013 FD Payroll 9/13/13 3,513.15 75.42 3,588.57 GL 2322 09/26/2013 Sept A/P Direct Energy, Kyocera, Verizo 139.30 3,727.87 TOWN OF TROPHY CLUB 33036 AP 2384 09/30/2013 September AP Verizon-September 139.29 3,867.16 TOWN OF TROPHY CLUB 33083 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 354.01 3,867.16 ** 3,500.00 Budgeted (367.16) Remaining 110 % Used Account: 122-60020-045-000 Electricity/Gas 2284 09/19/2013 Sept A/P Electricity 8/13-9/12 6,565.34 1,201.79 7,767.13 HUDSON ENERGY SERVICES, LLC 32998 AP 2322 09/26/2013 Sept A/P Fire Station Gas 8/20-9/19/13 64.91 7,832.04 ATMOS ENERGY 33014 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (633.34) 7,198.70 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 633.36 7,198.70 ** 6,167.00 Budgeted (1,031.70) Remaining 117 % Used Account: 122-60025-045-000 Water 2245 09/10/2013 September A/P Water fire-Aug 1,197.67 104.22 1,301.89 TROPHY CLUB MUD (WATER BILLS) 32985 AP 2245 09/10/2013 September A/P Water Fire Irrg-Aug 91.06 1,392.95 TROPHY CLUB MUD (WATER BILLS) 32985 AP 2384 09/30/2013 September AP Water-September Fire 142.32 1,535.27 TROPHY CLUB MUD (WATER BILLS) 33085 AP 2384 09/30/2013 September AP Water-September Fire irrg 84.36 1,619.63 TROPHY CLUB MUD (WATER BILLS) 33085 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (113.34) 1,506.29 AR _______________ Account: 122-60025-045-000 Water Totals: 308.62 1,506.29 ** 1,400.00 Budgeted (106.29) Remaining 108 % Used Account: 122-60030-045-000 Rent And/Or Usage 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2245 09/10/2013 September A/P shipping charges 43.04 4.25 47.29 FEDERAL EXPRESS CORP 32956 AP 2284 09/19/2013 Sept A/P Badger, DFW Comm overnight shi 27.52 74.81 FEDERAL EXPRESS CORP 32994 AP 2381 09/30/2013 Sept Postage meter usage .46 75.27 GL _______________ Account: 122-60035-045-000 Postage Totals: 32.23 75.27 ** 100.00 Budgeted 24.73 Remaining 75 % 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 2386 09/26/2013 PCards 8/27-9/26/13 NFPA NATL FIRE PROTECT 490.93 490.93 NFPA NATL FIRE PROTECT PC _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: 490.93 490.93 ** 410.00 Budgeted (80.93) Remaining 120 % Used Account: 122-60070-045-000 Dues & Memberships 8,040.91 .00 8,040.91 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .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 2284 09/19/2013 Sept A/P 2 CRS License Renewals 3,122.50 237.20 3,359.70 NORTH EAST FIRE DEPT ASSOC 33004 AP 2386 09/26/2013 PCards 8/27-9/26/13 TRAININGDIVISION.COM 250.00 3,609.70 TRAININGDIVISION.COM PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 487.20 3,609.70 ** 5,000.00 Budgeted 1,390.30 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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-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 2322 09/26/2013 Sept A/P TCF Assessment 1,720.00 1,720.00 TEXAS HEALTH HUGULEY INC 33035 AP _______________ Account: 122-60110-045-000 Physicals/Testing Totals: 1,720.00 1,720.00 ** 2,000.00 Budgeted 280.00 Remaining 86 % 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 2386 09/26/2013 PCards 8/27-9/26/13 LETS JUMP 3,558.66 148.75 3,707.41 LETS JUMP PC 2386 09/26/2013 PCards 8/27-9/26/13 PAYPAL *HEROESDENTO 100.00 3,807.41 PAYPAL *HEROESDENTO PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 248.75 3,807.41 ** 4,200.00 Budgeted 392.59 Remaining 91 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2284 09/19/2013 Sept A/P Charter,Symonds,SHI,GST,Bandwi 1,595.42 435.00 2,030.42 TOWN OF TROPHY CLUB 33011 AP 2322 09/26/2013 Sept A/P 20'x38' Flag 845.00 2,875.42 SYMONDS FLAGS & POLES 33034 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (422.50) 2,452.92 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 857.50 2,452.92 ** 2,293.00 Budgeted (159.92) Remaining 107 % 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 2386 09/26/2013 PCards 8/27-9/26/13 WAL-MART #5247 1,316.54 84.16 1,400.70 WAL-MART #5247 PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 84.16 1,400.70 ** 1,237.00 Budgeted (163.70) Remaining 113 % Used Account: 122-65005-045-000 Fuel & Lube 2382 09/30/2013 September Gas Log 6,741.89 759.39 7,501.28 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 759.39 7,501.28 ** 10,000.00 Budgeted 2,498.72 Remaining 75 % Used Account: 122-65010-045-000 Uniforms 2245 09/10/2013 September A/P uniforms 1,279.44 343.06 1,622.50 GST PUBLIC SAFETY SUPPLY 32962 AP 2284 09/19/2013 Sept A/P Charter,Symonds,SHI,GST,Bandwi 89.98 1,712.48 TOWN OF TROPHY CLUB 33011 AP 2386 09/26/2013 PCards 8/27-9/26/13 HAIX NORTH AMERICA 55.95 1,768.43 HAIX NORTH AMERICA PC 2384 09/30/2013 September AP Uniforms 11.25 1,779.68 TOWN OF TROPHY CLUB 33083 AP 2384 09/30/2013 September AP Uniforms, Toner 152.85 1,932.53 TOWN OF TROPHY CLUB 33083 AP 2384 09/30/2013 September AP uniforms 367.45 2,299.98 MUNICIPAL EMERGENCY SERVICES 33070 AP 2385 09/30/2013 Sept A/P Uniforms 341.29 2,641.27 Alainavision, Inc 33044 AP 2385 09/30/2013 Sept A/P Uniforms 341.35 2,982.62 Alainavision, Inc 33044 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (553.02) 2,429.60 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 1,150.16 2,429.60 ** 3,357.00 Budgeted 927.40 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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-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 2284 09/19/2013 Sept A/P IT PCards/August 374.35 10.95 385.30 TOWN OF TROPHY CLUB 33011 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 10.95 385.30 ** 1,200.00 Budgeted 814.70 Remaining 32 % Used Account: 122-65095-045-000 Maintenance Supplies 2386 09/26/2013 PCards 8/27-9/26/13 SAMSCLUB #4795 1,867.00 343.00 2,210.00 SAMSCLUB #4795 PC 2384 09/30/2013 September AP Food for open house, kitchen s 14.51 2,224.51 COSTCO WHOLESALE 33049 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 357.51 2,224.51 ** 1,988.00 Budgeted (236.51) Remaining 112 % Used Account: 122-69008-045-000 Short Term Debt-Principal 69,966.05 .00 69,966.05 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 69,966.05 ** 72,932.00 Budgeted 2,965.95 Remaining 96 % Used Account: 122-69009-045-000 Short Term Debt-Interest . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,966.05 .00 2,966.05 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 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,199,827.13 ** 1,341,471.00 Budgeted 141,643.87 Remaining 89 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (158,965.96) .00 Budgeted 158,965.96 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET SEPTEMBER 30, 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 9/30/13 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 414,786 - - 414,786 INVESTMENTS 2,363,777 313,050 330,571 3,007,398 PREPAID EXPENSES 28,022 - - 28,022 ADVALOREM PROPERTY TAXES RECEIVABLE 1,890 - - 1,890 UTILITY AND OTHER ACCOUNTS RECEIVABLE 843,471 - - 843,471 - TOTAL ASSETS 3,652,546 313,050 330,571 4,296,167 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,890 - - 1,890 ACCOUNTS AND OTHER PAYABLES 300,368 - 85,471 385,839 CUSTOMER DEPOSITS 240,852 - - 240,852 - TOTAL LIABILITIES 543,110 - 85,471 628,581 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 (172,684) 98,801 206,999 133,116 - TOTAL FUND BALANCE 3,109,436 313,050 245,101 3,667,587 - TOTAL LIABILITIES AND FUND BALANCE 3,652,546 313,050 330,571 4,296,167 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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- 26.80- 100,512.55- 100.629 628.55 135-40002-000-000 Property Taxes/Delinquent 500.00- 624.00- 299.85 -48.053 923.85- 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 4.34- 849.11- 70.759 350.89- Subtotal: 101,584.00- 101,708.00- 31.14- 101,061.81- 99.365 646.19- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 413,855.41- 3,380,948.49- 95.356 164,660.51- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 188,987.10- 1,832,660.19- 110.819 178,913.19 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- 8,056.69- 59,710.77- 92.460 4,869.23- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 1,003.00- 12,033.88- 103.517 408.88 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 250.00- 1,950.00- 108.333 150.00 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 750.00- 6,300.00- 121.154 1,100.00 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 15,989.40- 80,010.09- 103.139 2,435.09 Subtotal: 5,360,712.00- 5,360,712.00- 628,891.60- 5,373,763.32- 100.243 13,051.32 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 43,700.00- 508,300.00- 78.929 135,700.00- Subtotal: 644,000.00- 644,000.00- 43,700.00- 508,300.00- 78.929 135,700.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 180.64- 4,641.39- 84.389 858.61- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 10,862.83- 106.876 698.83 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.37- 7,000.00- 100.000 135-49025-000-000 Auction Sales 12,200.00- 12,200.00 135-49030-000-000 Vending Revenue 350.00- 350.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- 7,733.57- 84,876.26- 116.269 11,876.26 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- .02- 15,837.33- 119.862 2,624.33 135-49901-000-000 Records Management Revenue 109.00- 1.00- 91.50- 83.945 17.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- 774.66- 270.860 488.66 Subtotal: 402,962.00- 381,737.00- 9,409.13- 186,609.13- 48.884 195,127.87- Program number: 6,509,258.00- 6,488,157.00- 682,031.87- 6,169,734.26- 95.092 318,422.74- Department number: Revenues 6,509,258.00- 6,488,157.00- 682,031.87- 6,169,734.26- 95.092 318,422.74- Revenues Subtotal ----------- 6,509,258.00- 6,488,157.00- 682,031.87- 6,169,734.26- 95.092 318,422.74- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 213,321.00 213,321.00 13,326.24 166,890.62 78.235 46,430.38 135-50010-010-000 Overtime 13,250.00 19,250.00 1,616.15 14,912.05 77.465 4,337.95 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,350.00 85.294 750.00 135-50020-010-000 Retirement 32,725.00 57,748.00 1,371.01 45,181.52 78.239 12,566.48 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 2,113.96 23,813.16 82.341 5,106.84 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 190.78 1,828.29 87.436 262.71 135-50028-010-000 Vision Insurance 519.00 519.00 41.38 418.37 80.611 100.63 135-50029-010-000 Life Insurance & Other 1,204.00 1,532.00 171.23 1,956.14 127.685 424.14- 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 933.62 11,775.03 80.900 2,779.97 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 218.35 2,753.84 80.900 650.16 135-50040-010-000 Unemployment Taxes 945.00 945.00 1.74 54.01 5.715 890.99 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 249.37 71.249 100.63 Subtotal: 325,773.00 357,124.00 20,309.46 281,262.45 78.758 75,861.55 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 3,296.31 45,110.57 90.221 4,889.43 135-55090-010-000 Vehicle Maintenance 3,700.00 4,650.00 916.16 5,088.01 109.420 438.01- 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 362.39 5,142.60 95.516 241.40 Subtotal: 64,100.00 64,934.00 4,574.86 57,108.22 87.948 7,825.78 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 1,119.51 2,668.10 133.405 668.10- 135-60020-010-000 Electricity 162,410.00 162,410.00 20,325.70 137,923.34 84.923 24,486.66 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 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 12.00 48.00 9.600 452.00 135-60135-010-000 TCEQ Fees & Permits 35,800.00 42,743.00 207.70 49,926.95 116.807 7,183.95- 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 247,714.32 1,601,573.19 78.956 426,873.81 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 558.82 2,002.60 47.681 2,197.40 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 269,938.05 1,797,810.86 80.069 447,517.14 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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,128.87 12,107.94 68.557 5,553.06 135-65010-010-000 Uniforms 2,680.00 2,680.00 757.00 2,679.05 99.965 .95 135-65030-010-000 Chemicals 6,200.00 6,200.00 1,748.03 7,066.99 113.984 866.99- 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 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 3,633.90 172,984.15 100.228 393.15- 135-69005-010-000 Capital Expenses 181,800.00 8,000.00 1,094.96- -13.687 9,094.96 135-69008-010-000 Short Term Debt-Principal 387,037.00 366,000.00 366,000.00 100.000 135-69009-010-000 Short Term Debt-Interest 21,037.00 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 576,486.11 98.387 9,450.89 Program number: 3,821,430.00 3,425,914.00 298,456.27 2,885,651.79 84.230 540,262.21 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis 60.00 60.00 60.00- Subtotal: 60.00 60.00 60.00- Program number: 1 Lab Analysis for PID 60.00 60.00 60.00- Department number: Water 3,821,430.00 3,425,914.00 298,516.27 2,885,711.79 84.232 540,202.21 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 14,732.94 180,658.55 91.807 16,122.45 135-50010-020-000 Overtime 10,166.00 17,546.00 604.49 12,760.50 72.726 4,785.50 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 375.00 4,200.00 100.000 135-50020-020-000 Retirement 29,821.00 54,844.00 1,410.98 46,307.92 84.436 8,536.08 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 3,293.23 35,299.74 121.581 6,265.74- 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 226.46 2,486.91 117.751 374.91- 135-50028-020-000 Vision Insurance 552.00 552.00 49.93 587.59 106.447 35.59- 135-50029-020-000 Life Insurance & Other 920.00 1,377.00 183.90 2,103.14 152.733 726.14- 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 838.61 10,993.73 82.859 2,274.27 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 196.13 2,571.10 82.859 531.90 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 166.57 47.591 183.43 Subtotal: 297,010.00 329,870.00 21,911.67 307,187.93 93.124 22,682.07 135-55070-020-000 Independent Labor 1,000.00 84,418.00 95,363.75 186,888.75 221.385 102,470.75- 135-55080-020-000 Maintenance & Repairs 40,000.00 41,205.00 1,299.37 54,875.27 133.176 13,670.27- 135-55090-020-000 Vehicle Maintenance 2,000.00 3,350.00 100.03 5,578.54 166.524 2,228.54- 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 1,603.98 40,805.64 82.251 8,805.36 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 5,941.00 34,108.15 113.694 4,108.15- Subtotal: 89,500.00 210,084.00 104,308.13 323,337.31 153.909 113,253.31- 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 3,981.00 1,694.12 3,911.77 98.261 69.23 135-60020-020-000 Electricity 153,045.00 153,045.00 9,807.59 124,832.10 81.566 28,212.90 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,293.66 39.537 1,978.34 135-60090-020-000 Safety Program 250.00 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 500.00 8,387.19 53.764 7,212.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 29.91 442.14 88.428 57.86 Subtotal: 221,367.00 221,200.00 11,997.26 185,110.30 83.685 36,089.70 135-65005-020-000 Fuel & Lube 8,527.00 10,527.00 1,169.53 11,507.06 109.310 980.06- . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 117.00 1,440.70 91.531 133.30 135-65030-020-000 Chemicals 10,000.00 38,346.00 1,969.01 29,759.91 77.609 8,586.09 135-65035-020-000 Small Tools 1,000.00 1,000.00 543.29 1,012.34 101.234 12.34- 135-65040-020-000 Safety Equipment 250.00 500.00 199.17 1,034.48 206.896 534.48- 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 2.80 14,031.53 140.315 4,031.53- Subtotal: 32,351.00 61,947.00 4,000.80 58,786.02 94.897 3,160.98 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 142,217.86 1,316,616.85 103.705 47,031.85- Department number: Wastewater 1,039,428.00 1,269,585.00 142,217.86 1,316,616.85 103.705 47,031.85- . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 156,475.00 156,475.00 11,782.74 147,926.46 94.537 8,548.54 135-50010-021-000 Overtime 7,297.00 12,158.00 1,088.98 10,637.82 87.496 1,520.18 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,750.00 97.222 50.00 135-50020-021-000 Retirement 23,574.00 42,910.00 1,169.34 36,749.13 85.642 6,160.87 135-50026-021-000 Medical Insurance 20,198.00 25,940.00 2,321.55 25,943.19 100.012 3.19- 135-50027-021-000 Dental Insurance 1,409.00 1,812.00 159.88 1,812.36 100.020 .36- 135-50028-021-000 Vision Insurance 357.00 383.00 32.60 382.52 99.875 .48 135-50029-021-000 Life Insurance & Other 1,008.00 1,223.00 128.47 1,579.51 129.150 356.51- 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 740.02 9,612.52 91.530 889.48 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 173.07 2,248.07 91.534 207.93 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 147.90 59.160 102.10 Subtotal: 233,059.00 263,642.00 17,746.65 247,538.25 93.892 16,103.75 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 20,000.00 4,322.15 24,155.20 120.776 4,155.20- 135-55090-021-000 Vehicle Maintenance 1,900.00 1,600.00 752.99 2,193.46 137.091 593.46- Subtotal: 38,400.00 21,600.00 5,075.14 26,348.66 121.985 4,748.66- 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 764.07 2,995.38 85.582 504.62 135-60020-021-000 Electricity 18,705.00 18,705.00 1,315.25 17,978.51 96.116 726.49 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 2,079.32 24,767.65 71.270 9,984.35 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 1,374.59 10,518.21 86.805 1,598.79 135-65010-021-000 Uniforms 2,220.00 2,220.00 1,276.60 2,210.73 99.582 9.27 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 463.45 533.45 42.676 716.55 135-65040-021-000 Safety Equipment 500.00 500.00 359.95 71.990 140.05 Subtotal: 23,837.00 23,587.00 3,114.64 15,843.34 67.170 7,743.66 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 15,276.00 16.973 74,724.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69008-021-000 Short Term Debt-Principal 40,260.00 40,260.00 35,991.00 89.396 4,269.00 135-69009-021-000 Short Term Debt-Interest 4,238.24 4,238.24- Subtotal: 130,260.00 130,260.00 55,505.24 42.611 74,754.76 Program number: 459,887.00 473,841.00 28,015.75 370,003.14 78.086 103,837.86 Department number: Collection 459,887.00 473,841.00 28,015.75 370,003.14 78.086 103,837.86 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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,000.00 10,900.00 109.000 900.00- 135-50030-026-000 Social Security Taxes 620.00 620.00 62.00 675.80 109.000 55.80- 135-50035-026-000 Medicare Taxes 145.00 145.00 14.50 158.05 109.000 13.05- 135-50040-026-000 Unemployment Taxes 210.00 210.00 1.00 69.70 33.190 140.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,077.50 11,811.43 106.170 686.43- 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 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 473.73 15.791 2,526.27 Subtotal: 15,450.00 15,450.00 11,064.49 71.615 4,385.51 Program number: 26,575.00 26,575.00 1,077.50 22,875.92 86.081 3,699.08 Department number: Board of Directors 26,575.00 26,575.00 1,077.50 22,875.92 86.081 3,699.08 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 444,730.00 444,730.00 33,143.22 423,091.36 95.134 21,638.64 135-50010-030-000 Overtime 1,500.00 1,500.00 110.82 392.27 26.151 1,107.73 135-50016-030-000 Longevity 2,193.00 2,318.00 2,317.50 99.978 .50 135-50020-030-000 Retirement 60,441.00 104,801.00 2,986.21 88,750.22 84.685 16,050.78 135-50026-030-000 Medical Insurance 44,066.00 49,049.00 4,388.10 49,048.80 100.000 .20 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 386.34 4,343.22 128.536 964.22- 135-50028-030-000 Vision Insurance 795.00 945.00 82.53 941.29 99.607 3.71 135-50029-030-000 Life Insurance & Other 2,500.00 2,582.00 373.52 4,187.69 162.188 1,605.69- 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,917.13 25,088.72 90.241 2,713.28 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 448.36 5,867.52 90.242 634.48 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 63.00 102.00 40.800 148.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 112.59 2,964.69 59.294 2,035.31 Subtotal: 601,526.00 651,226.00 44,011.82 608,473.17 93.435 42,752.83 135-55030-030-000 Software & Support 63,555.00 63,555.00 7,237.97 65,275.54 102.707 1,720.54- 135-55070-030-000 Independent Labor 2,700.00 7,700.00 6,441.25 23,732.22 308.211 16,032.22- 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55080-030-000 Maintenance & Repairs 811.00 1,621.04 199.882 810.04- 135-55100-030-000 Building Maint & Supplies 5,000.00 6,500.00 786.48 6,098.47 93.823 401.53 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,290.77 18,703.55 92.592 1,496.45 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 1,543.63 7,842.69 71.297 3,157.31 Subtotal: 203,420.00 210,891.00 17,300.10 215,872.28 102.362 4,981.28- 135-60005-030-000 Telephone 9,000.00 10,500.00 2,070.51 11,604.10 110.515 1,104.10- 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 454.30 3,730.17 104.340 155.17- 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 1,206.73 13,758.49 105.680 739.49- 135-60025-030-000 Water 3,100.00 3,100.00 392.18 1,189.77 38.380 1,910.23 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 12,083.61 91.668 1,098.39 135-60035-030-000 Postage 23,000.00 26,604.00 4,545.69 30,027.74 112.869 3,423.74- 135-60040-030-000 Service Charges & Fees 18,000.00 28,330.00 3,345.06 30,078.58 106.172 1,748.58- 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 287.77 1,289.17 15.167 7,210.83 135-60055-030-000 Insurance 35,000.00 50,694.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 100.00 4,591.95 117.984 699.95- 135-60075-030-000 Meetings 250.00 400.00 28.97 371.43 92.858 28.57 135-60080-030-000 Schools & Training 5,500.00 5,350.00 175.00 3,809.23 71.201 1,540.77 135-60100-030-000 Travel & per diem 3,950.00 3,616.00 13.90 4,544.68 125.683 928.68- . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 1,780.64 7,130.76 178.269 3,130.76- 135-60235-030-000 Security 1,350.00 1,350.00 157.48 662.61 49.082 687.39 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,233.04 17,458.70 129.324 3,958.70- 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) 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 22,791.27 439,141.61 177.281 191,432.61- 135-65010-030-000 Uniforms 1,635.00 1,635.00 255.50 879.62 53.799 755.38 135-65055-030-000 Hardware 20,188.00 20,188.00 4,412.41 16,541.75 81.939 3,646.25 135-65085-030-000 Office Supplies 8,200.00 8,200.00 710.33 8,362.25 101.979 162.25- 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 293.00 3,635.25 63.420 2,096.75 135-65095-030-000 Maintenance Supplies 2,000.00 1,500.00 252.47 3,524.42 234.961 2,024.42- 135-65097-030-000 Vending Machine Supplies 500.00 500.00 94.58 18.916 405.42 135-65105-030-000 Printing 5,200.00 4,200.00 1,098.98 3,234.64 77.015 965.36 Subtotal: 43,455.00 41,955.00 7,022.69 36,272.51 86.456 5,682.49 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 3,082.20 89.339 367.80 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 256.85 29,993.20 98.789 367.80 Program number: 1,051,838.00 1,182,142.00 91,382.73 1,329,752.77 112.487 147,610.77- Department number: Administration 1,051,838.00 1,182,142.00 91,382.73 1,329,752.77 112.487 147,610.77- . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 18:00 10/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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 10,278.90 271,939.01 388.484 201,939.01- 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 1,943.16 10,095.38 66.857 5,004.62 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 12,222.06 305,124.95 277.134 195,024.95- 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 12,222.06 417,458.16 379.163 307,358.16- Department number: Non Departmental 110,100.00 110,100.00 12,222.06 417,458.16 379.163 307,358.16- Expenditures Subtotal ----------- 6,509,258.00 6,488,157.00 573,432.17 6,342,418.63 97.754 145,738.37 Fund number: 135 MUD 1 General Fund 108,599.70- 172,684.37 172,684.37- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 18:00 10/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 9/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- 10.71- 108.19- 108.190 8.19 Subtotal: 445,100.00- 10.71- 445,108.19- 100.002 8.19 Program number: 445,100.00- 10.71- 445,108.19- 100.002 8.19 Department number: 445,100.00- 10.71- 445,108.19- 100.002 8.19 Revenues Subtotal ----------- 445,100.00- 10.71- 445,108.19- 100.002 8.19 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 18:00 10/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 9/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 19 18:00 10/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 9/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 40,611.33 133,032.19 80.626 31,967.81 Subtotal: 165,000.00 40,611.33 133,032.19 80.626 31,967.81 Program number: 2 Rate of Flow Control-FW Meter 165,000.00 40,611.33 133,032.19 80.626 31,967.81 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 18:00 10/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 9/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 40,611.33 154,915.02 40.681 225,884.98 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 18:00 10/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 9/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 22 18:00 10/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 1 Security Cameras Period Ending: 9/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 23 18:00 10/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 4 Sludge Blanket Level Indicator Period Ending: 9/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 24 18:00 10/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 5 Portable Submersible Pump Period Ending: 9/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 25 18:00 10/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 6 Waste Pump Period Ending: 9/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 40,611.33 238,109.06 53.508 206,890.94 Fund number: 507 MUD 1 Capital Projects 100.00- 40,600.62 206,999.13- ############### 206,899.13 . glbase_tbam rgonzale Trophy Club MUD #1 Page 26 18:00 10/09/13 Budget Summary with Amendment Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 9/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 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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 2373 09/03/2013 Property Taxes/Assessments (100,485.75) (18.00) (100,503.75) GL 2374 09/18/2013 Property Taxes/Assessments (7.02) (100,510.77) GL 2375 09/19/2013 Property Taxes/Assessments (1.78) (100,512.55) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (26.80) (100,512.55) ** (99,884.00) Budgeted 628.55 Remaining 101 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 299.85 .00 299.85 _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: .00 299.85 ** (624.00) Budgeted (923.85) Remaining -48 % Used Account: 135-40015-000-000 Property Taxes/P & I 2373 09/03/2013 Property Taxes/Assessments (844.77) (3.42) (848.19) GL 2374 09/18/2013 Property Taxes/Assessments (.56) (848.75) GL 2375 09/19/2013 Property Taxes/Assessments (.36) (849.11) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (4.34) (849.11) ** (1,200.00) Budgeted (350.89) Remaining 71 % Used Account: 135-47000-000-000 Water 2349 09/30/2013 UB 9/30/13 September Billing UB20130930-20130930 User: (2,967,093.08) (419,294.01) (3,386,387.09) UB 2380 09/30/2013 UB 9/30/13 Adjustment UB20130930-20130930 User: 5,438.60 (3,380,948.49) UB _______________ Account: 135-47000-000-000 Water Totals: (413,855.41) (3,380,948.49) ** (3,545,609.00) Budgeted (164,660.51) Remaining 95 % Used Account: 135-47005-000-000 Sewer 2349 09/30/2013 UB 9/30/13 September Billing UB20130930-20130930 User: (1,643,673.09) (188,987.10) (1,832,660.19) UB _______________ Account: 135-47005-000-000 Sewer Totals: (188,987.10) (1,832,660.19) ** (1,653,747.00) Budgeted 178,913.19 Remaining 111 % Used Account: 135-47020-000-000 Standby (149.90) .00 (149.90) . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47020-000-000 Standby Totals: .00 (149.90) ** (576.00) Budgeted (426.10) Remaining 26 % Used Account: 135-47025-000-000 Penalties 2281 09/19/2013 UB 09/19/2013 Adjustments PN UB20130919-20130919 User: (51,654.08) 41.30 (51,612.78) UB 2300 09/23/2013 UB 09/23/2013 Penalties UB20130923-20130923 User: (7,809.20) (59,421.98) UB 2333 09/30/2013 UB 09/30/2013 Adjustments UB20130930-20130930 User: 562.36 (58,859.62) UB 2349 09/30/2013 UB 9/30/13 September Billing UB20130930-20130930 User: (851.15) (59,710.77) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,056.69) (59,710.77) ** (64,580.00) Budgeted (4,869.23) Remaining 92 % Used Account: 135-47030-000-000 Service Charges 2206 09/05/2013 UB 9/5/13 Cut Off List UB20130905-20130905 User: (11,030.88) (925.00) (11,955.88) UB 2310 09/12/2013 UB 9/12/13 NSF Check fee UB20130912-20130912 User: (50.00) (12,005.88) UB 2315 09/18/2013 UB 9/18/13 NSF Check fee UB20130918-20130918 User: (25.00) (12,030.88) UB 2341 09/20/2013 UB 9/20/13 NSF Ck Fee UB20130920-20130920 User: (25.00) (12,055.88) UB 2349 09/30/2013 UB 9/30/13 September Billing UB20130930-20130930 User: 22.00 (12,033.88) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,003.00) (12,033.88) ** (11,625.00) Budgeted 408.88 Remaining 104 % Used Account: 135-47035-000-000 Plumbing Inspections 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (1,700.00) (250.00) (1,950.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (1,950.00) ** (1,800.00) Budgeted 150.00 Remaining 108 % Used Account: 135-47045-000-000 Sewer Inspections 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (5,550.00) (750.00) (6,300.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (750.00) (6,300.00) ** (5,200.00) Budgeted 1,100.00 Remaining 121 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2349 09/30/2013 UB 9/30/13 September Billing UB20130930-20130930 User: (64,020.69) (15,989.40) (80,010.09) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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-47070-000-000 TCCC Effluent Charges Totals: (15,989.40) (80,010.09) ** (77,575.00) Budgeted 2,435.09 Remaining 103 % Used Account: 135-48005-000-000 Utility Fees 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (464,600.00) (43,700.00) (508,300.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (43,700.00) (508,300.00) ** (644,000.00) Budgeted (135,700.00) Remaining 79 % Used Account: 135-49010-000-000 Interest Income 2350 09/30/2013 September bank interest (4,460.75) (103.44) (4,564.19) GL 2350 09/30/2013 September bank interest (77.20) (4,641.39) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (180.64) (4,641.39) ** (5,500.00) Budgeted (858.61) Remaining 84 % Used Account: 135-49016-000-000 Cell Tower Revenue 2369 09/17/2013 AT&T Antenna Lease Sept (9,952.30) (910.53) (10,862.83) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (10,862.83) ** (10,164.00) Budgeted 698.83 Remaining 107 % Used Account: 135-49018-000-000 Building Rent Income 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (6,416.63) (583.37) (7,000.00) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.37) (7,000.00) ** (7,000.00) Budgeted .00 Remaining 100 % Used Account: 135-49025-000-000 Auction Sales (12,200.00) .00 (12,200.00) _______________ Account: 135-49025-000-000 Auction Sales Totals: .00 (12,200.00) ** .00 Budgeted 12,200.00 Remaining 0 % Used Account: 135-49030-000-000 Vending Revenue (434.41) .00 (434.41) . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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-49030-000-000 Vending Revenue Totals: .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 2245 09/10/2013 September A/P 1" meter & impact fee refund-p (77,142.69) 317.00 (76,825.69) Lennar Homes 32972 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (8,050.57) (84,876.26) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (7,733.57) (84,876.26) ** (73,000.00) Budgeted 11,876.26 Remaining 116 % 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 2245 09/10/2013 September A/P petty cash reimbursement (15,837.31) (.02) (15,837.33) TROPHY CLUB MUD PETTY CASH 32986 AP _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (.02) (15,837.33) ** (13,213.00) Budgeted 2,624.33 Remaining 120 % Used Account: 135-49901-000-000 Records Management Revenue 2289 09/03/2013 Open Records/Rose (90.50) (1.00) (91.50) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (1.00) (91.50) ** (109.00) Budgeted (17.50) Remaining 84 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (11,789.33) .00 (11,789.33) . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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-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 (774.66) .00 (774.66) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (774.66) ** (286.00) Budgeted 488.66 Remaining 271 % Used Department Totals: ------------------------------------------------------------------------------------------------ (6,169,734.26) ** (6,488,157.00) Budgeted (318,422.74) Remaining 95 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 2240 09/13/2013 Payroll 9/13/13 Salaries & Wages 153,564.38 6,663.12 160,227.50 PR 2306 09/27/2013 PR 9-27-13 Salaries & Wages 6,663.12 166,890.62 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 13,326.24 166,890.62 ** 213,321.00 Budgeted 46,430.38 Remaining 78 % Used Account: 135-50010-010-000 Overtime 2240 09/13/2013 Payroll 9/13/13 Overtime 13,295.90 1,169.35 14,465.25 PR 2306 09/27/2013 PR 9-27-13 Overtime 446.80 14,912.05 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,616.15 14,912.05 ** 19,250.00 Budgeted 4,337.95 Remaining 77 % 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 2306 09/27/2013 PR 9-27-13 Certification 4,025.00 325.00 4,350.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 325.00 4,350.00 ** 5,100.00 Budgeted 750.00 Remaining 85 % Used Account: 135-50020-010-000 Retirement 2240 09/13/2013 Payroll 9/13/13 Retirement 43,810.51 703.35 44,513.86 PR 2306 09/27/2013 PR 9-27-13 Retirement 667.66 45,181.52 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,371.01 45,181.52 ** 57,748.00 Budgeted 12,566.48 Remaining 78 % Used Account: 135-50026-010-000 Medical Insurance 2240 09/13/2013 Payroll 9/13/13 Medical Insurance 21,699.20 1,057.00 22,756.20 PR 2306 09/27/2013 PR 9-27-13 Medical Insurance 1,056.96 23,813.16 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,113.96 23,813.16 ** 28,920.00 Budgeted 5,106.84 Remaining 82 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 2240 09/13/2013 Payroll 9/13/13 Dental Insurance 1,637.51 95.40 1,732.91 PR 2306 09/27/2013 PR 9-27-13 Dental Insurance 95.38 1,828.29 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 190.78 1,828.29 ** 2,091.00 Budgeted 262.71 Remaining 87 % Used Account: 135-50028-010-000 Vision Insurance 2240 09/13/2013 Payroll 9/13/13 Vision Insurance 376.99 20.70 397.69 PR 2306 09/27/2013 PR 9-27-13 Vision Insurance 20.68 418.37 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 41.38 418.37 ** 519.00 Budgeted 100.63 Remaining 81 % Used Account: 135-50029-010-000 Life Insurance & Other 2156 09/01/2013 Sept A/P Sept Life, AD&D, LTD, STD, Den 1,784.91 139.73 1,924.64 METLIFE 32941 AP 2245 09/10/2013 September A/P discovery benefits 15.75 1,940.39 Discovery Benefits 32952 AP 2384 09/30/2013 September AP FSA admin 15.75 1,956.14 Discovery Benefits 33055 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 171.23 1,956.14 ** 1,532.00 Budgeted (424.14) Remaining 128 % Used Account: 135-50030-010-000 Social Security Taxes 2240 09/13/2013 Payroll 9/13/13 Social Security Taxes 10,841.41 479.81 11,321.22 PR 2306 09/27/2013 PR 9-27-13 Social Security Taxes 453.81 11,775.03 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 933.62 11,775.03 ** 14,555.00 Budgeted 2,779.97 Remaining 81 % Used Account: 135-50035-010-000 Medicare Taxes 2240 09/13/2013 Payroll 9/13/13 Medicare Taxes 2,535.49 112.21 2,647.70 PR 2306 09/27/2013 PR 9-27-13 Medicare Taxes 106.14 2,753.84 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 218.35 2,753.84 ** 3,404.00 Budgeted 650.16 Remaining 81 % Used Account: 135-50040-010-000 Unemployment Taxes 2240 09/13/2013 Payroll 9/13/13 Unemployment Taxes 52.27 1.34 53.61 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2306 09/27/2013 PR 9-27-13 Unemployment Taxes 52.27 .40 54.01 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 1.74 54.01 ** 945.00 Budgeted 890.99 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 249.37 .00 249.37 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 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 Account: 135-55080-010-000 Maintenance & Repairs 2245 09/10/2013 September A/P petty cash reimbursement 41,814.26 40.00 41,854.26 TROPHY CLUB MUD PETTY CASH 32986 AP 2245 09/10/2013 September A/P petty cash reimbursement 4.69 41,858.95 TROPHY CLUB MUD PETTY CASH 32986 AP 2284 09/19/2013 Sept A/P Meter boxes 329.46 42,188.41 HD SUPPLY WATERWORKS, LTD. 32997 AP 2284 09/19/2013 Sept A/P Fire Line parts 1,071.44 43,259.85 HD SUPPLY WATERWORKS, LTD. 32997 AP 2322 09/26/2013 Sept A/P Check valve stuck on pump #5 610.00 43,869.85 Legacy Contracting, LP 33024 AP 2322 09/26/2013 Sept A/P 3/8 ' tubs Kynar union tee, an 84.97 43,954.82 HD SUPPLY FACILITIES MAINT LTD 33021 AP 2322 09/26/2013 Sept A/P Flushing valve at Oak Hill 405.29 44,360.11 HD SUPPLY WATERWORKS, LTD. 33022 AP 2322 09/26/2013 Sept A/P Pipe Inserts 33.00 44,393.11 HD SUPPLY WATERWORKS, LTD. 33022 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2386 09/26/2013 PCards 8/27-9/26/13 ROANOKE AUTO SUPPLY LT 41,814.26 24.30 44,417.41 ROANOKE AUTO SUPPLY LT PC 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 34.26 44,451.67 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 23.57 44,475.24 THE HOME DEPOT 6581 PC 2384 09/30/2013 September AP 3" clamps 187.70 44,662.94 ATLAS UTILITY SUPPLY CO. 33047 AP 2384 09/30/2013 September AP Meter boxes 447.63 45,110.57 HD SUPPLY WATERWORKS, LTD. 33061 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 3,296.31 45,110.57 ** 50,000.00 Budgeted 4,889.43 Remaining 90 % Used Account: 135-55090-010-000 Vehicle Maintenance 2386 09/26/2013 PCards 8/27-9/26/13 INLAND TRUCK PARTS #18 4,171.85 916.16 5,088.01 INLAND TRUCK PARTS #18 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 916.16 5,088.01 ** 4,650.00 Budgeted (438.01) Remaining 109 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,767.04 .00 1,767.04 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,767.04 ** 2,900.00 Budgeted 1,132.96 Remaining 61 % Used Account: 135-55135-010-000 Lab Analysis 2284 09/19/2013 Sept A/P Lab analysis-MUD 4,780.21 360.00 5,140.21 TARRANT CTY PUBLIC HEALTH LAB 33008 AP 2386 09/26/2013 PCards 8/27-9/26/13 TOM THUMB STOR00017897 2.39 5,142.60 TOM THUMB STOR00017897 PC _______________ Account: 135-55135-010-000 Lab Analysis Totals: 362.39 5,142.60 ** 5,384.00 Budgeted 241.40 Remaining 96 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 2322 09/26/2013 Sept A/P Direct Energy, Kyocera, Verizo 1,548.59 172.39 1,720.98 TOWN OF TROPHY CLUB 33036 AP 2384 09/30/2013 September AP Verizon-September 947.12 2,668.10 TOWN OF TROPHY CLUB 33083 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 1,119.51 2,668.10 ** 2,000.00 Budgeted (668.10) Remaining 133 % Used Account: 135-60020-010-000 Electricity 2284 09/19/2013 Sept A/P Electricity 8/12-9/12 117,597.64 17,299.44 134,897.08 HUDSON ENERGY SERVICES, LLC 32998 AP 2284 09/19/2013 Sept A/P Electricity 8/13-9/12 3,026.26 137,923.34 HUDSON ENERGY SERVICES, LLC 32998 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-60020-010-000 Electricity Totals: 20,325.70 137,923.34 ** 162,410.00 Budgeted 24,486.66 Remaining 85 % 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 1,082.00 .00 1,082.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .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 2245 09/10/2013 September A/P Rent/Lease equipment 36.00 6.00 42.00 ALLIED WELDING SUPPLY, INC 32947 AP 2384 09/30/2013 September AP Nitrogen 6.00 48.00 ALLIED WELDING SUPPLY, INC 33045 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-60105-010-000 Rent/Lease Equipment Totals: 12.00 48.00 ** 500.00 Budgeted 452.00 Remaining 10 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 2284 09/19/2013 Sept A/P Qtrly Water samples 49,719.25 207.70 49,926.95 LOWER COLORADO RIVER AUTHORITY 33000 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 207.70 49,926.95 ** 42,743.00 Budgeted (7,183.95) Remaining 117 % Used Account: 135-60150-010-000 Wholesale Water 2322 09/26/2013 Sept A/P August Wholesale Water 1,353,858.87 247,714.32 1,601,573.19 CITY OF FORT WORTH 33018 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 247,714.32 1,601,573.19 ** 2,028,447.00 Budgeted 426,873.81 Remaining 79 % Used Account: 135-60243-010-000 Prior Year Expense 756.00 .00 756.00 _______________ Account: 135-60243-010-000 Prior Year Expense Totals: .00 756.00 ** 756.00 Budgeted .00 Remaining 100 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 2386 09/26/2013 PCards 8/27-9/26/13 DENTON SAND & GRAVEL, 1,443.78 108.00 1,551.78 DENTON SAND & GRAVEL, PC 2386 09/26/2013 PCards 8/27-9/26/13 DENTON SAND & GRAVEL, 108.00 1,659.78 DENTON SAND & GRAVEL, PC 2386 09/26/2013 PCards 8/27-9/26/13 DENTON SAND & GRAVEL, 108.00 1,767.78 DENTON SAND & GRAVEL, PC 2386 09/26/2013 PCards 8/27-9/26/13 DENTON SAND & GRAVEL, 42.00 1,809.78 DENTON SAND & GRAVEL, PC 2386 09/26/2013 PCards 8/27-9/26/13 DENTON SAND & GRAVEL, 108.00 1,917.78 DENTON SAND & GRAVEL, PC 2386 09/26/2013 PCards 8/27-9/26/13 TEX-TURF 8.12 1,925.90 TEX-TURF PC 2386 09/26/2013 PCards 8/27-9/26/13 TEX-TURF 39.00 1,964.90 TEX-TURF PC 2386 09/26/2013 PCards 8/27-9/26/13 TEX-TURF 37.70 2,002.60 TEX-TURF PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-60280-010-000 Property Maintenance Totals: 558.82 2,002.60 ** 4,200.00 Budgeted 2,197.40 Remaining 48 % 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 2382 09/30/2013 September Gas Log 10,979.07 1,128.87 12,107.94 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,128.87 12,107.94 ** 17,661.00 Budgeted 5,553.06 Remaining 69 % Used Account: 135-65010-010-000 Uniforms 2322 09/26/2013 Sept A/P Shirts and sweatshirts 1,922.05 757.00 2,679.05 RON MONTGOMERY & ASSOC INC 33033 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 757.00 2,679.05 ** 2,680.00 Budgeted .95 Remaining 100 % Used Account: 135-65030-010-000 Chemicals 2245 09/10/2013 September A/P chlorine bottles 5,318.96 624.53 5,943.49 DPC INDUSTRIES, INC 32953 AP 2284 09/19/2013 Sept A/P Testing supplies, chemicals 106.18 6,049.67 HACH COMPANY 32996 AP 2322 09/26/2013 Sept A/P Chlorine Testing supplies 392.79 6,442.46 HACH COMPANY 33020 AP 2386 09/26/2013 PCards 8/27-9/26/13 DX SERVICE 624.53 7,066.99 DX SERVICE PC _______________ Account: 135-65030-010-000 Chemicals Totals: 1,748.03 7,066.99 ** 6,200.00 Budgeted (866.99) Remaining 114 % Used Account: 135-65035-010-000 Small Tools . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 760.89 .00 760.89 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 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 366,000.00 .00 366,000.00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 366,000.00 ** 366,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 20,895.53 .00 20,895.53 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-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 Account: 135-55135-010-001 Lab Analysis 2285 09/19/2013 Sept A/P Lab analysis - PID 60.00 60.00 TARRANT CTY PUBLIC HEALTH LAB 33008 AP _______________ Account: 135-55135-010-001 Lab Analysis Totals: 60.00 60.00 ** .00 Budgeted (60.00) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,885,711.79 ** 3,425,914.00 Budgeted 540,202.21 Remaining 84 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 2240 09/13/2013 Payroll 9/13/13 Salaries & Wages 165,925.61 7,366.47 173,292.08 PR 2306 09/27/2013 PR 9-27-13 Salaries & Wages 7,366.47 180,658.55 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,732.94 180,658.55 ** 196,781.00 Budgeted 16,122.45 Remaining 92 % Used Account: 135-50010-020-000 Overtime 2240 09/13/2013 Payroll 9/13/13 Overtime 12,156.01 95.15 12,251.16 PR 2306 09/27/2013 PR 9-27-13 Overtime 509.34 12,760.50 PR _______________ Account: 135-50010-020-000 Overtime Totals: 604.49 12,760.50 ** 17,546.00 Budgeted 4,785.50 Remaining 73 % 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 2306 09/27/2013 PR 9-27-13 Certification 3,825.00 375.00 4,200.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 375.00 4,200.00 ** 4,200.00 Budgeted .00 Remaining 100 % Used Account: 135-50020-020-000 Retirement 2240 09/13/2013 Payroll 9/13/13 Retirement 44,896.94 670.05 45,566.99 PR 2306 09/27/2013 PR 9-27-13 Retirement 740.93 46,307.92 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,410.98 46,307.92 ** 54,844.00 Budgeted 8,536.08 Remaining 84 % Used Account: 135-50026-020-000 Medical Insurance 2240 09/13/2013 Payroll 9/13/13 Medical Insurance 32,006.51 1,646.62 33,653.13 PR 2306 09/27/2013 PR 9-27-13 Medical Insurance 1,646.61 35,299.74 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,293.23 35,299.74 ** 29,034.00 Budgeted (6,265.74) Remaining 122 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 2240 09/13/2013 Payroll 9/13/13 Dental Insurance 2,260.45 113.24 2,373.69 PR 2306 09/27/2013 PR 9-27-13 Dental Insurance 113.22 2,486.91 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 2,486.91 ** 2,112.00 Budgeted (374.91) Remaining 118 % Used Account: 135-50028-020-000 Vision Insurance 2240 09/13/2013 Payroll 9/13/13 Vision Insurance 537.66 24.98 562.64 PR 2306 09/27/2013 PR 9-27-13 Vision Insurance 24.95 587.59 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 49.93 587.59 ** 552.00 Budgeted (35.59) Remaining 106 % Used Account: 135-50029-020-000 Life Insurance & Other 2156 09/01/2013 Sept A/P Sept Life, AD&D, LTD, STD, Den 1,919.24 152.40 2,071.64 METLIFE 32941 AP 2245 09/10/2013 September A/P discovery benefits 15.75 2,087.39 Discovery Benefits 32952 AP 2384 09/30/2013 September AP FSA admin 15.75 2,103.14 Discovery Benefits 33055 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 183.90 2,103.14 ** 1,377.00 Budgeted (726.14) Remaining 153 % Used Account: 135-50030-020-000 Social Security Taxes 2240 09/13/2013 Payroll 9/13/13 Social Security Taxes 10,155.12 396.69 10,551.81 PR 2306 09/27/2013 PR 9-27-13 Social Security Taxes 441.92 10,993.73 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 838.61 10,993.73 ** 13,268.00 Budgeted 2,274.27 Remaining 83 % Used Account: 135-50035-020-000 Medicare Taxes 2240 09/13/2013 Payroll 9/13/13 Medicare Taxes 2,374.97 92.77 2,467.74 PR 2306 09/27/2013 PR 9-27-13 Medicare Taxes 103.36 2,571.10 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 196.13 2,571.10 ** 3,103.00 Budgeted 531.90 Remaining 83 % Used Account: 135-50040-020-000 Unemployment Taxes 45.41 .00 45.41 . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .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 166.57 .00 166.57 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 166.57 ** 350.00 Budgeted 183.43 Remaining 48 % Used Account: 135-55070-020-000 Independent Labor 2284 09/19/2013 Sept A/P WWTP Improvements 91,525.00 61,975.00 153,500.00 THE WALLACE GROUP, INC. 33010 AP 2384 09/30/2013 September AP WWTP Improvements 33,388.75 186,888.75 THE WALLACE GROUP, INC. 33081 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 95,363.75 186,888.75 ** 84,418.00 Budgeted (102,470.75) Remaining 221 % Used Account: 135-55080-020-000 Maintenance & Repairs 2386 09/26/2013 PCards 8/27-9/26/13 WW GRAINGER 53,575.90 (410.59) 53,165.31 WW GRAINGER PC 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 89.94 53,255.25 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 ATLAS UTILITY SUPPLY C 311.38 53,566.63 ATLAS UTILITY SUPPLY C PC 2386 09/26/2013 PCards 8/27-9/26/13 WW GRAINGER 432.20 53,998.83 WW GRAINGER PC 2386 09/26/2013 PCards 8/27-9/26/13 FERGUSON ENT #526 35.60 54,034.43 FERGUSON ENT #526 PC 2386 09/26/2013 PCards 8/27-9/26/13 FERGUSON ENT #61 695.46 54,729.89 FERGUSON ENT #61 PC 2386 09/26/2013 PCards 8/27-9/26/13 WW GRAINGER 434.75 55,164.64 WW GRAINGER PC 2386 09/26/2013 PCards 8/27-9/26/13 GRAYBAR ELECTRIC 187.72 55,352.36 GRAYBAR ELECTRIC PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 53,575.90 65.41 55,417.77 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 WW GRAINGER (542.50) 54,875.27 WW GRAINGER PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 1,299.37 54,875.27 ** 41,205.00 Budgeted (13,670.27) Remaining 133 % Used Account: 135-55090-020-000 Vehicle Maintenance 2384 09/30/2013 September AP Tire repair 2013 Chevy PU 5,478.51 100.03 5,578.54 BLAGG TIRE & SERVICE 33048 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 100.03 5,578.54 ** 3,350.00 Budgeted (2,228.54) Remaining 167 % 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 2322 09/26/2013 Sept A/P Sludge haul off 39,201.66 871.56 40,073.22 L.H. CHANEY MATERIALS, INC. 33023 AP 2322 09/26/2013 Sept A/P Sludge haul off 732.42 40,805.64 L.H. CHANEY MATERIALS, INC. 33023 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 1,603.98 40,805.64 ** 49,611.00 Budgeted 8,805.36 Remaining 82 % Used Account: 135-55135-020-000 Lab Analysis 2245 09/10/2013 September A/P sampling for Wallace Group 28,167.15 3,850.00 32,017.15 EFFECTIVE ENVIRONMENTAL INC 32955 AP 2322 09/26/2013 Sept A/P Lab testing 243.00 32,260.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab testing 176.00 32,436.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab testing 80.00 32,516.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab testing 278.00 32,794.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab testing 211.00 33,005.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab Testing 80.00 33,085.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab testing 278.00 33,363.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab testing 211.00 33,574.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab testing 278.00 33,852.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab testing 211.00 34,063.15 OXIDOR LABORATORIES LLC 33029 AP 2322 09/26/2013 Sept A/P Lab testing 45.00 34,108.15 OXIDOR LABORATORIES LLC 33029 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-55135-020-000 Lab Analysis Totals: 5,941.00 34,108.15 ** 30,000.00 Budgeted (4,108.15) Remaining 114 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 2322 09/26/2013 Sept A/P Direct Energy, Kyocera, Verizo 2,217.65 432.72 2,650.37 TOWN OF TROPHY CLUB 33036 AP 2384 09/30/2013 September AP Verizon-September 1,261.40 3,911.77 TOWN OF TROPHY CLUB 33083 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 1,694.12 3,911.77 ** 3,981.00 Budgeted 69.23 Remaining 98 % Used Account: 135-60020-020-000 Electricity 2284 09/19/2013 Sept A/P Electricity 8/12-9/12 115,024.51 9,807.59 124,832.10 HUDSON ENERGY SERVICES, LLC 32998 AP _______________ Account: 135-60020-020-000 Electricity Totals: 9,807.59 124,832.10 ** 153,045.00 Budgeted 28,212.90 Remaining 82 % 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 2386 09/26/2013 PCards 8/27-9/26/13 TCEQ EPAYMENT 1,182.66 111.00 1,293.66 TCEQ EPAYMENT PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 111.00 1,293.66 ** 3,272.00 Budgeted 1,978.34 Remaining 40 % Used Account: 135-60090-020-000 Safety Program 2320 09/01/2013 Correct coding/Safety Program 145.36 (145.36) .00 GL _______________ Account: 135-60090-020-000 Safety Program Totals: (145.36) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 3,442.80 .00 3,442.80 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-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 2272 09/17/2013 Sept A/P Bond Application 7,887.19 500.00 8,387.19 Texas Commission On 32988 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 500.00 8,387.19 ** 15,600.00 Budgeted 7,212.81 Remaining 54 % Used Account: 135-60136-020-000 TCEQ Environmental Proj (SEP) 40,400.00 .00 40,400.00 _______________ 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 202.10 ** 200.00 Budgeted (2.10) Remaining 101 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 412.23 13.95 426.18 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 AUTOZONE #4206 15.96 442.14 AUTOZONE #4206 PC _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 29.91 442.14 ** 500.00 Budgeted 57.86 Remaining 88 % Used Account: 135-65005-020-000 Fuel & Lube 2382 09/30/2013 September Gas Log 10,337.53 1,169.53 11,507.06 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,169.53 11,507.06 ** 10,527.00 Budgeted (980.06) Remaining 109 % Used Account: 135-65010-020-000 Uniforms 2322 09/26/2013 Sept A/P Uniforms 1,323.70 108.00 1,431.70 PANDA EMBROIDERY 33031 AP 2322 09/26/2013 Sept A/P Names on uniforms 9.00 1,440.70 PANDA EMBROIDERY 33031 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 117.00 1,440.70 ** 1,574.00 Budgeted 133.30 Remaining 92 % Used Account: 135-65030-020-000 Chemicals 2322 09/26/2013 Sept A/P Clarifloc 27,790.90 1,620.00 29,410.90 POLYDYNE, INC 33032 AP 2386 09/26/2013 PCards 8/27-9/26/13 AQUAFIX INC 349.01 29,759.91 AQUAFIX INC PC _______________ Account: 135-65030-020-000 Chemicals Totals: 1,969.01 29,759.91 ** 38,346.00 Budgeted 8,586.09 Remaining 78 % Used Account: 135-65035-020-000 Small Tools 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 469.05 70.32 539.37 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 152.97 692.34 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 WW GRAINGER 320.00 1,012.34 WW GRAINGER PC _______________ Account: 135-65035-020-000 Small Tools Totals: 543.29 1,012.34 ** 1,000.00 Budgeted (12.34) Remaining 101 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-65040-020-000 Safety Equipment 2320 09/01/2013 Correct coding/Safety Program 835.31 145.36 980.67 GL 2322 09/26/2013 Sept A/P Safey cabinet refill 46.84 1,027.51 CINTAS FAS LOCKBOX 636525 33017 AP 2386 09/26/2013 PCards 8/27-9/26/13 WAL-MART #5247 6.97 1,034.48 WAL-MART #5247 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 199.17 1,034.48 ** 500.00 Budgeted (534.48) Remaining 207 % Used Account: 135-65045-020-000 Lab Supplies 2322 09/26/2013 Sept A/P distilled water for lab testin 14,028.73 2.80 14,031.53 OZARKA DIRECT 33030 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2.80 14,031.53 ** 10,000.00 Budgeted (4,031.53) 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,316,616.85 ** 1,269,585.00 Budgeted (47,031.85) Remaining 104 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/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 2240 09/13/2013 Payroll 9/13/13 Salaries & Wages 136,143.72 5,891.37 142,035.09 PR 2306 09/27/2013 PR 9-27-13 Salaries & Wages 5,891.37 147,926.46 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,782.74 147,926.46 ** 156,475.00 Budgeted 8,548.54 Remaining 95 % Used Account: 135-50010-021-000 Overtime 2240 09/13/2013 Payroll 9/13/13 Overtime 9,548.84 930.64 10,479.48 PR 2306 09/27/2013 PR 9-27-13 Overtime 158.34 10,637.82 PR _______________ Account: 135-50010-021-000 Overtime Totals: 1,088.98 10,637.82 ** 12,158.00 Budgeted 1,520.18 Remaining 87 % 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 2306 09/27/2013 PR 9-27-13 Certification 1,600.00 150.00 1,750.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,750.00 ** 1,800.00 Budgeted 50.00 Remaining 97 % Used Account: 135-50020-021-000 Retirement 2240 09/13/2013 Payroll 9/13/13 Retirement 35,579.79 612.61 36,192.40 PR 2306 09/27/2013 PR 9-27-13 Retirement 556.73 36,749.13 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,169.34 36,749.13 ** 42,910.00 Budgeted 6,160.87 Remaining 86 % Used Account: 135-50026-021-000 Medical Insurance 2240 09/13/2013 Payroll 9/13/13 Medical Insurance 23,621.64 1,160.78 24,782.42 PR 2306 09/27/2013 PR 9-27-13 Medical Insurance 1,160.77 25,943.19 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,321.55 25,943.19 ** 25,940.00 Budgeted (3.19) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 2240 09/13/2013 Payroll 9/13/13 Dental Insurance 1,652.48 79.95 1,732.43 PR 2306 09/27/2013 PR 9-27-13 Dental Insurance 79.93 1,812.36 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 159.88 1,812.36 ** 1,812.00 Budgeted (.36) Remaining 100 % Used Account: 135-50028-021-000 Vision Insurance 2240 09/13/2013 Payroll 9/13/13 Vision Insurance 349.92 16.31 366.23 PR 2306 09/27/2013 PR 9-27-13 Vision Insurance 16.29 382.52 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 32.60 382.52 ** 383.00 Budgeted .48 Remaining 100 % Used Account: 135-50029-021-000 Life Insurance & Other 2156 09/01/2013 Sept A/P Sept Life, AD&D, LTD, STD, Den 1,451.04 117.97 1,569.01 METLIFE 32941 AP 2245 09/10/2013 September A/P discovery benefits 5.25 1,574.26 Discovery Benefits 32952 AP 2384 09/30/2013 September AP FSA admin 5.25 1,579.51 Discovery Benefits 33055 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 128.47 1,579.51 ** 1,223.00 Budgeted (356.51) Remaining 129 % Used Account: 135-50030-021-000 Social Security Taxes 2240 09/13/2013 Payroll 9/13/13 Social Security Taxes 8,872.50 390.36 9,262.86 PR 2306 09/27/2013 PR 9-27-13 Social Security Taxes 349.66 9,612.52 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 740.02 9,612.52 ** 10,502.00 Budgeted 889.48 Remaining 92 % Used Account: 135-50035-021-000 Medicare Taxes 2240 09/13/2013 Payroll 9/13/13 Medicare Taxes 2,075.00 91.30 2,166.30 PR 2306 09/27/2013 PR 9-27-13 Medicare Taxes 81.77 2,248.07 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 173.07 2,248.07 ** 2,456.00 Budgeted 207.93 Remaining 92 % Used Account: 135-50040-021-000 Unemployment Taxes 34.39 .00 34.39 . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .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 147.90 .00 147.90 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 147.90 ** 250.00 Budgeted 102.10 Remaining 59 % Used Account: 135-55080-021-000 Maintenance & Repairs 2284 09/19/2013 Sept A/P Alarms for Liftstations (Labor 19,833.05 1,305.00 21,138.05 DHS AUTOMATION, INC 32993 AP 2284 09/19/2013 Sept A/P LS #7 Sign 31.16 21,169.21 DALLAS LITE & BARRICADE, INC 32991 AP 2322 09/26/2013 Sept A/P Hose, gun and nozzle for Vac T 2,139.31 23,308.52 CLS SEWER EQUIPMENT CO INC 33019 AP 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 11.88 23,320.40 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 ALLIED ELECTRONICS INC 822.34 24,142.74 ALLIED ELECTRONICS INC PC 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 12.46 24,155.20 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 4,322.15 24,155.20 ** 20,000.00 Budgeted (4,155.20) Remaining 121 % Used Account: 135-55090-021-000 Vehicle Maintenance 2386 09/26/2013 PCards 8/27-9/26/13 ROANOKE AUTO SUPPLY LT 1,440.47 418.00 1,858.47 ROANOKE AUTO SUPPLY LT PC 2386 09/26/2013 PCards 8/27-9/26/13 ROANOKE AUTO SUPPLY LT (20.00) 1,838.47 ROANOKE AUTO SUPPLY LT PC 2386 09/26/2013 PCards 8/27-9/26/13 ROANOKE AUTO SUPPLY LT 294.00 2,132.47 ROANOKE AUTO SUPPLY LT PC 2386 09/26/2013 PCards 8/27-9/26/13 HOSE TECH 60.99 2,193.46 HOSE TECH PC _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 752.99 2,193.46 ** 1,600.00 Budgeted (593.46) Remaining 137 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 2322 09/26/2013 Sept A/P Direct Energy, Kyocera, Verizo 2,231.31 217.26 2,448.57 TOWN OF TROPHY CLUB 33036 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2384 09/30/2013 September AP Verizon-September 2,231.31 546.81 2,995.38 TOWN OF TROPHY CLUB 33083 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 764.07 2,995.38 ** 3,500.00 Budgeted 504.62 Remaining 86 % Used Account: 135-60020-021-000 Electricity 2284 09/19/2013 Sept A/P Electricity 7/30-8/29 16,663.26 291.89 16,955.15 TRI COUNTY ELECTRIC 33012 AP 2284 09/19/2013 Sept A/P Electricity 7/30-8/29 172.38 17,127.53 TRI COUNTY ELECTRIC 33012 AP 2284 09/19/2013 Sept A/P Electricity 7/30-8/29 27.58 17,155.11 TRI COUNTY ELECTRIC 33012 AP 2284 09/19/2013 Sept A/P Electricity 8/12-9/12 622.34 17,777.45 HUDSON ENERGY SERVICES, LLC 32998 AP 2284 09/19/2013 Sept A/P Electricity 8/12-9/12 275.88 18,053.33 HUDSON ENERGY SERVICES, LLC 32998 AP 2284 09/19/2013 Sept A/P Electricity 8/12-9/11 9.87 18,063.20 HUDSON ENERGY SERVICES, LLC 32998 AP 2284 09/19/2013 Sept A/P Electricity 8/12-9/11 .03 18,063.23 HUDSON ENERGY SERVICES, LLC 32998 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (84.72) 17,978.51 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,315.25 17,978.51 ** 18,705.00 Budgeted 726.49 Remaining 96 % Used Account: 135-60070-021-000 Dues & Memberships 250.00 .00 250.00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 250.00 ** 250.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-021-000 Schools & Training 830.00 .00 830.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 830.00 ** 826.00 Budgeted (4.00) Remaining 100 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 2,092.93 .00 2,092.93 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-021-000 Travel & per diem Totals: .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 2382 09/30/2013 September Gas Log 9,143.62 1,374.59 10,518.21 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,374.59 10,518.21 ** 12,117.00 Budgeted 1,598.79 Remaining 87 % Used Account: 135-65010-021-000 Uniforms 2322 09/26/2013 Sept A/P embroidery on uniform shirts 934.13 276.50 1,210.63 PANDA EMBROIDERY 33031 AP 2322 09/26/2013 Sept A/P Shirts and sweatshirts 1,000.10 2,210.73 RON MONTGOMERY & ASSOC INC 33033 AP _______________ Account: 135-65010-021-000 Uniforms Totals: 1,276.60 2,210.73 ** 2,220.00 Budgeted 9.27 Remaining 100 % Used Account: 135-65030-021-000 Chemicals 2,221.00 .00 2,221.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65030-021-000 Chemicals Totals: .00 2,221.00 ** 7,500.00 Budgeted 5,279.00 Remaining 30 % Used Account: 135-65035-021-000 Small Tools 2386 09/26/2013 PCards 8/27-9/26/13 LOWES #00732* 70.00 383.92 453.92 LOWES #00732* PC 2386 09/26/2013 PCards 8/27-9/26/13 LESLIES POOL SPLY 574 79.53 533.45 LESLIES POOL SPLY 574 PC _______________ Account: 135-65035-021-000 Small Tools Totals: 463.45 533.45 ** 1,250.00 Budgeted 716.55 Remaining 43 % Used Account: 135-65040-021-000 Safety Equipment 359.95 .00 359.95 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 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 35,991.00 .00 35,991.00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 35,991.00 ** 40,260.00 Budgeted 4,269.00 Remaining 89 % Used Account: 135-69009-021-000 Short Term Debt-Interest 4,238.24 .00 4,238.24 _______________ Account: 135-69009-021-000 Short Term Debt-Interest Totals: .00 4,238.24 ** .00 Budgeted (4,238.24) Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 370,003.14 ** 473,841.00 Budgeted 103,837.86 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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 2240 09/13/2013 Payroll 9/13/13 Salaries & Wages 9,900.00 500.00 10,400.00 PR 2306 09/27/2013 PR 9-27-13 Salaries & Wages 500.00 10,900.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,000.00 10,900.00 ** 10,000.00 Budgeted (900.00) Remaining 109 % Used Account: 135-50030-026-000 Social Security Taxes 2240 09/13/2013 Payroll 9/13/13 Social Security Taxes 613.80 31.00 644.80 PR 2306 09/27/2013 PR 9-27-13 Social Security Taxes 31.00 675.80 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 62.00 675.80 ** 620.00 Budgeted (55.80) Remaining 109 % Used Account: 135-50035-026-000 Medicare Taxes 2240 09/13/2013 Payroll 9/13/13 Medicare Taxes 143.55 7.25 150.80 PR 2306 09/27/2013 PR 9-27-13 Medicare Taxes 7.25 158.05 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 14.50 158.05 ** 145.00 Budgeted (13.05) Remaining 109 % Used Account: 135-50040-026-000 Unemployment Taxes 2240 09/13/2013 Payroll 9/13/13 Unemployment Taxes 68.70 .50 69.20 PR 2306 09/27/2013 PR 9-27-13 Unemployment Taxes .50 69.70 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.00 69.70 ** 210.00 Budgeted 140.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 43 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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 2,059.65 .00 2,059.65 _______________ Account: 135-60075-026-000 Meetings Totals: .00 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 473.73 .00 473.73 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 473.73 ** 3,000.00 Budgeted 2,526.27 Remaining 16 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 22,875.92 ** 26,575.00 Budgeted 3,699.08 Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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 2240 09/13/2013 Payroll 9/13/13 Salaries & Wages 389,948.14 16,569.13 406,517.27 PR 2306 09/27/2013 PR 9-27-13 Salaries & Wages 16,574.09 423,091.36 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,143.22 423,091.36 ** 444,730.00 Budgeted 21,638.64 Remaining 95 % Used Account: 135-50010-030-000 Overtime 2240 09/13/2013 Payroll 9/13/13 Overtime 281.45 .81 282.26 PR 2306 09/27/2013 PR 9-27-13 Overtime 110.01 392.27 PR _______________ Account: 135-50010-030-000 Overtime Totals: 110.82 392.27 ** 1,500.00 Budgeted 1,107.73 Remaining 26 % 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 2240 09/13/2013 Payroll 9/13/13 Retirement 85,764.01 1,487.97 87,251.98 PR 2306 09/27/2013 PR 9-27-13 Retirement 1,498.24 88,750.22 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,986.21 88,750.22 ** 104,801.00 Budgeted 16,050.78 Remaining 85 % Used Account: 135-50026-030-000 Medical Insurance 2240 09/13/2013 Payroll 9/13/13 Medical Insurance 44,660.70 2,194.07 46,854.77 PR 2306 09/27/2013 PR 9-27-13 Medical Insurance 2,194.03 49,048.80 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 49,048.80 ** 49,049.00 Budgeted .20 Remaining 100 % Used Account: 135-50027-030-000 Dental Insurance 2240 09/13/2013 Payroll 9/13/13 Dental Insurance 3,956.88 193.19 4,150.07 PR 2306 09/27/2013 PR 9-27-13 Dental Insurance 193.15 4,343.22 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 386.34 4,343.22 ** 3,379.00 Budgeted (964.22) Remaining 129 % Used Account: 135-50028-030-000 Vision Insurance 2240 09/13/2013 Payroll 9/13/13 Vision Insurance 858.76 41.29 900.05 PR 2306 09/27/2013 PR 9-27-13 Vision Insurance 41.24 941.29 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 941.29 ** 945.00 Budgeted 3.71 Remaining 100 % Used Account: 135-50029-030-000 Life Insurance & Other 2156 09/01/2013 Sept A/P Sept Life, AD&D, LTD, STD, Den 3,814.17 300.02 4,114.19 METLIFE 32941 AP 2245 09/10/2013 September A/P discovery benefits 36.75 4,150.94 Discovery Benefits 32952 AP 2384 09/30/2013 September AP FSA admin 36.75 4,187.69 Discovery Benefits 33055 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 373.52 4,187.69 ** 2,582.00 Budgeted (1,605.69) Remaining 162 % Used Account: 135-50030-030-000 Social Security Taxes 2240 09/13/2013 Payroll 9/13/13 Social Security Taxes 23,171.59 957.28 24,128.87 PR 2306 09/27/2013 PR 9-27-13 Social Security Taxes 959.85 25,088.72 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,917.13 25,088.72 ** 27,802.00 Budgeted 2,713.28 Remaining 90 % Used Account: 135-50035-030-000 Medicare Taxes 2240 09/13/2013 Payroll 9/13/13 Medicare Taxes 5,419.16 223.89 5,643.05 PR 2306 09/27/2013 PR 9-27-13 Medicare Taxes 224.47 5,867.52 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 448.36 5,867.52 ** 6,502.00 Budgeted 634.48 Remaining 90 % Used Account: 135-50040-030-000 Unemployment Taxes 439.29 .00 439.29 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 439.29 ** 1,537.00 Budgeted 1,097.71 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 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 2322 09/26/2013 Sept A/P Testing/Roberts 39.00 63.00 102.00 CARENOW CORPORATE 33016 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 63.00 102.00 ** 250.00 Budgeted 148.00 Remaining 41 % Used Account: 135-50070-030-000 Employee Relations 2386 09/26/2013 PCards 8/27-9/26/13 HOT & CREAMY DONUTS 2,852.10 38.98 2,891.08 HOT & CREAMY DONUTS PC 2386 09/26/2013 PCards 8/27-9/26/13 TLF HOLLYS GARDENS AND 73.61 2,964.69 TLF HOLLYS GARDENS AND PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 112.59 2,964.69 ** 5,000.00 Budgeted 2,035.31 Remaining 59 % Used Account: 135-55030-030-000 Software & Support 2245 09/10/2013 September A/P Connect CTY Annual maintenance 58,037.57 2,438.40 60,475.97 TOWN OF TROPHY CLUB 32984 AP 2284 09/19/2013 Sept A/P IT PCards/August 159.97 60,635.94 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 107.28 60,743.22 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 107.88 60,851.10 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 25.00 60,876.10 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 24.99 60,901.09 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 118.37 61,019.46 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P Charter,Symonds,SHI,GST,Bandwi 645.50 61,664.96 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P Charter,Symonds,SHI,GST,Bandwi 24.22 61,689.18 TOWN OF TROPHY CLUB 33011 AP 2384 09/30/2013 September AP STW support 2,751.36 64,440.54 STW INC 33077 AP 2384 09/30/2013 September AP Software support 797.50 65,238.04 STW INC 33077 AP 2385 09/30/2013 Sept A/P IT PCards 12.50 65,250.54 TOWN OF TROPHY CLUB 33083 AP 2385 09/30/2013 Sept A/P IT PCards 25.00 65,275.54 TOWN OF TROPHY CLUB 33083 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 7,237.97 65,275.54 ** 63,555.00 Budgeted (1,720.54) Remaining 103 % Used Account: 135-55070-030-000 Independent Labor 2284 09/19/2013 Sept A/P Record MUD meeting 17,290.97 67.50 17,358.47 MIGUEL CRUZ 33002 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2322 09/26/2013 Sept A/P Professional services 17,290.97 3,270.00 20,628.47 NEW GEN STRATEGIES & SOLUTIONS 33027 AP 2386 09/26/2013 PCards 8/27-9/26/13 LABOR READY 160.00 20,788.47 LABOR READY PC 2384 09/30/2013 September AP Hours worked 300.00 21,088.47 TAMARA THOMAS 33078 AP 2384 09/30/2013 September AP Record MUD open house 33.75 21,122.22 MIGUEL CRUZ 33068 AP 2384 09/30/2013 September AP Professional Fees 2,610.00 23,732.22 NEW GEN STRATEGIES & SOLUTIONS 33071 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 6,441.25 23,732.22 ** 7,700.00 Budgeted (16,032.22) Remaining 308 % Used Account: 135-55075-030-000 Records Management .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 1,621.04 .00 1,621.04 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 1,621.04 ** 811.00 Budgeted (810.04) Remaining 200 % Used Account: 135-55100-030-000 Building Maint & Supplies 2245 09/10/2013 September A/P mat service 5,311.99 84.15 5,396.14 G & K SERVICES 32960 AP 2245 09/10/2013 September A/P mat service 84.15 5,480.29 G & K SERVICES 32960 AP 2245 09/10/2013 September A/P mat service 84.15 5,564.44 G & K SERVICES 32960 AP 2245 09/10/2013 September A/P mat service 84.15 5,648.59 G & K SERVICES 32960 AP 2284 09/19/2013 Sept A/P Re-key doors 102.50 5,751.09 MICHAEL'S KEYS 33001 AP 2322 09/26/2013 Sept A/P AC repair 137.00 5,888.09 NORTH TX HEATING & AIR, INC 33028 AP 2384 09/30/2013 September AP Mat service 84.15 5,972.24 G & K SERVICES 33059 AP 2384 09/30/2013 September AP Mat service 84.15 6,056.39 G & K SERVICES 33059 AP 2384 09/30/2013 September AP Mat service 84.15 6,140.54 G & K SERVICES 33059 AP 2384 09/30/2013 September AP Mat serivce 84.15 6,224.69 G & K SERVICES 33059 AP 2384 09/30/2013 September AP Mat service 84.15 6,308.84 G & K SERVICES 33059 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (210.37) 6,098.47 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 786.48 6,098.47 ** 6,500.00 Budgeted 401.53 Remaining 94 % Used Account: 135-55120-030-000 Cleaning Services . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2322 09/26/2013 Sept A/P Janitorial service August 17,412.78 1,290.77 18,703.55 MEMBER'S BUILDING MAINTENANCE 33025 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,290.77 18,703.55 ** 20,200.00 Budgeted 1,496.45 Remaining 93 % 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 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 2252 09/11/2013 Town billed Inv 1076 AR 20130901-20130911 User: 6,299.06 (37.26) 6,261.80 AR 2284 09/19/2013 Sept A/P Aug Water billing with Town in 609.26 6,871.06 DATAPROSE LLC 32992 AP 2384 09/30/2013 September AP Billing 1,421.71 8,292.77 DATAPROSE LLC 33051 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (450.08) 7,842.69 AR _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,543.63 7,842.69 ** 11,000.00 Budgeted 3,157.31 Remaining 71 % Used Account: 135-60005-030-000 Telephone 2284 09/19/2013 Sept A/P IT PCards/August 9,533.59 (33.00) 9,500.59 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 134.14 9,634.73 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 738.87 10,373.60 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P Answering service 186.67 10,560.27 KEYSTONE PARK SECRETARIAL 32999 AP 2385 09/30/2013 Sept A/P IT PCards 1,043.83 11,604.10 TOWN OF TROPHY CLUB 33083 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-60005-030-000 Telephone Totals: 2,070.51 11,604.10 ** 10,500.00 Budgeted (1,104.10) Remaining 111 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 2322 09/26/2013 Sept A/P Direct Energy, Kyocera, Verizo 3,275.87 176.70 3,452.57 TOWN OF TROPHY CLUB 33036 AP 2306 09/27/2013 PR 9-27-13 Communications/Pagers/Mobiles 150.00 3,602.57 PR 2384 09/30/2013 September AP Verizon-September 127.60 3,730.17 TOWN OF TROPHY CLUB 33083 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 454.30 3,730.17 ** 3,575.00 Budgeted (155.17) Remaining 104 % Used Account: 135-60020-030-000 Electricity/Gas 2322 09/26/2013 Sept A/P Direct Energy, Kyocera, Verizo 12,551.76 1,206.73 13,758.49 TOWN OF TROPHY CLUB 33036 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,206.73 13,758.49 ** 13,019.00 Budgeted (739.49) Remaining 106 % Used Account: 135-60025-030-000 Water 2245 09/10/2013 September A/P Water-July 797.59 263.72 1,061.31 TROPHY CLUB MUD (WATER BILLS) 32985 AP 2384 09/30/2013 September AP Water-September 256.92 1,318.23 TROPHY CLUB MUD (WATER BILLS) 33085 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (128.46) 1,189.77 AR _______________ Account: 135-60025-030-000 Water Totals: 392.18 1,189.77 ** 3,100.00 Budgeted 1,910.23 Remaining 38 % Used Account: 135-60030-030-000 Rent And/Or Usage 12,083.61 .00 12,083.61 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 12,083.61 ** 13,182.00 Budgeted 1,098.39 Remaining 92 % Used Account: 135-60035-030-000 Postage 2245 09/10/2013 September A/P petty cash reimbursement 25,482.05 (3.43) 25,478.62 TROPHY CLUB MUD PETTY CASH 32986 AP 2245 09/10/2013 September A/P overnight letter 5.76 25,484.38 FEDERAL EXPRESS CORP 32956 AP 2245 09/10/2013 September A/P overnight letter 10.44 25,494.82 FEDERAL EXPRESS CORP 32956 AP 2284 09/19/2013 Sept A/P Badger, DFW Comm overnight shi 7.02 25,501.84 FEDERAL EXPRESS CORP 32994 AP 2284 09/19/2013 Sept A/P Print job 1,087.11 26,588.95 COMPUTER EXTENSION SYS. INC 32990 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2284 09/19/2013 Sept A/P Aug Water billing with Town in 25,482.05 1,575.26 28,164.21 DATAPROSE LLC 32992 AP 2386 09/26/2013 PCards 8/27-9/26/13 THE UPS STORE 4772 30.46 28,194.67 THE UPS STORE 4772 PC 2381 09/30/2013 Sept Postage meter usage 196.20 28,390.87 GL 2384 09/30/2013 September AP overnight letter 6.17 28,397.04 FEDERAL EXPRESS CORP 33056 AP 2384 09/30/2013 September AP Billing 1,630.70 30,027.74 DATAPROSE LLC 33051 AP _______________ Account: 135-60035-030-000 Postage Totals: 4,545.69 30,027.74 ** 26,604.00 Budgeted (3,423.74) Remaining 113 % Used Account: 135-60040-030-000 Service Charges & Fees 2372 09/04/2013 Credit Card/Online fees 26,733.52 78.88 26,812.40 GL 2372 09/04/2013 Credit Card/Online fees 87.65 26,900.05 GL 2372 09/04/2013 Credit Card/Online fees 2,928.53 29,828.58 GL 2329 09/23/2013 Sep 1st Financial Analysis fee 250.00 30,078.58 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,345.06 30,078.58 ** 28,330.00 Budgeted (1,748.58) Remaining 106 % Used Account: 135-60050-030-000 Bad Debt Expense 2348 09/30/2013 UB 9/30/13 Write Pffs UB20130930-20130930 User: 1,001.40 287.77 1,289.17 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 287.77 1,289.17 ** 8,500.00 Budgeted 7,210.83 Remaining 15 % Used Account: 135-60055-030-000 Insurance 51,098.77 .00 51,098.77 _______________ Account: 135-60055-030-000 Insurance Totals: .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 2384 09/30/2013 September AP Tx Coop annual membership 4,491.95 100.00 4,591.95 TX COMPTROLLER 33086 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-030-000 Dues & Memberships Totals: 100.00 4,591.95 ** 3,892.00 Budgeted (699.95) Remaining 118 % Used Account: 135-60075-030-000 Meetings 2386 09/26/2013 PCards 8/27-9/26/13 CRISTINA S MEXICAN 342.46 28.97 371.43 CRISTINA S MEXICAN PC _______________ Account: 135-60075-030-000 Meetings Totals: 28.97 371.43 ** 400.00 Budgeted 28.57 Remaining 93 % Used Account: 135-60080-030-000 Schools & Training 2284 09/19/2013 Sept A/P Tx Notary Law & Procedure 3,634.23 140.00 3,774.23 N CENTRAL TX COG 33003 AP 2386 09/26/2013 PCards 8/27-9/26/13 NW METROPORT CHAMBER O 35.00 3,809.23 NW METROPORT CHAMBER O PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 175.00 3,809.23 ** 5,350.00 Budgeted 1,540.77 Remaining 71 % Used Account: 135-60100-030-000 Travel & per diem 2306 09/27/2013 PR 9-27-13 Travel & per diem 4,530.78 13.90 4,544.68 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 13.90 4,544.68 ** 3,616.00 Budgeted (928.68) Remaining 126 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 2284 09/19/2013 Sept A/P Publish Tax notice 5,350.12 451.40 5,801.52 STAR-TELEGRAM OPERATING LTD 33007 AP 2386 09/26/2013 PCards 8/27-9/26/13 STAR TELEGRAM ADVERTIS 1,329.24 7,130.76 STAR TELEGRAM ADVERTIS PC _______________ Account: 135-60125-030-000 Advertising Totals: 1,780.64 7,130.76 ** 4,000.00 Budgeted (3,130.76) Remaining 178 % Used Account: 135-60235-030-000 Security . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2284 09/19/2013 Sept A/P IT PCards/August 505.13 157.48 662.61 TOWN OF TROPHY CLUB 33011 AP _______________ Account: 135-60235-030-000 Security Totals: 157.48 662.61 ** 1,350.00 Budgeted 687.39 Remaining 49 % 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 2386 09/26/2013 PCards 8/27-9/26/13 WAL-MART #5247 9,225.66 58.09 9,283.75 WAL-MART #5247 PC 2386 09/26/2013 PCards 8/27-9/26/13 MICHAELS STORES 2063 98.99 9,382.74 MICHAELS STORES 2063 PC 2386 09/26/2013 PCards 8/27-9/26/13 AMAZON MKTPLACE PMTS 111.70 9,494.44 AMAZON MKTPLACE PMTS PC 2384 09/30/2013 September AP office supplies 152.53 9,646.97 OFFICE DEPOT, INC 33072 AP 2384 09/30/2013 September AP office supplies 86.94 9,733.91 OFFICE DEPOT, INC 33072 AP 2384 09/30/2013 September AP Food for open house, kitchen s 190.59 9,924.50 COSTCO WHOLESALE 33049 AP 2384 09/30/2013 September AP Balance due-video update 7,534.20 17,458.70 PREMIER AUDIO & VIDEO LLC 33074 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 8,233.04 17,458.70 ** 13,500.00 Budgeted (3,958.70) Remaining 129 % 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 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) 195,000.00 .00 195,000.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: .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 2322 09/26/2013 Sept A/P Embroidery on shirts 624.12 255.50 879.62 PANDA EMBROIDERY 33031 AP _______________ Account: 135-65010-030-000 Uniforms Totals: 255.50 879.62 ** 1,635.00 Budgeted 755.38 Remaining 54 % Used Account: 135-65055-030-000 Hardware 2284 09/19/2013 Sept A/P IT PCards/August 12,129.34 149.99 12,279.33 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 90.00 12,369.33 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 535.92 12,905.25 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P IT PCards/August 12.50 12,917.75 TOWN OF TROPHY CLUB 33011 AP 2284 09/19/2013 Sept A/P Charter,Symonds,SHI,GST,Bandwi 3,624.00 16,541.75 TOWN OF TROPHY CLUB 33011 AP _______________ Account: 135-65055-030-000 Hardware Totals: 4,412.41 16,541.75 ** 20,188.00 Budgeted 3,646.25 Remaining 82 % Used Account: 135-65085-030-000 Office Supplies 2245 09/10/2013 September A/P office supplies 7,651.92 104.49 7,756.41 OFFICE DEPOT, INC 32974 AP 2245 09/10/2013 September A/P office supplies 54.98 7,811.39 OFFICE DEPOT, INC 32974 AP 2284 09/19/2013 Sept A/P Trash can for lobby 69.99 7,881.38 OFFICE DEPOT, INC 33005 AP 2284 09/19/2013 Sept A/P Office supplies 107.93 7,989.31 OFFICE DEPOT, INC 33005 AP 2386 09/26/2013 PCards 8/27-9/26/13 FEDEXOFFICE 00019364 13.04 8,002.35 FEDEXOFFICE 00019364 PC 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 31.44 8,033.79 THE HOME DEPOT 6581 PC 2386 09/26/2013 PCards 8/27-9/26/13 THE HOME DEPOT 6581 91.85 8,125.64 THE HOME DEPOT 6581 PC 2384 09/30/2013 September AP office supplies 88.49 8,214.13 OFFICE DEPOT, INC 33072 AP 2384 09/30/2013 September AP Office supplies 83.56 8,297.69 OFFICE DEPOT, INC 33072 AP 2387 09/30/2013 September A/P Water Stickers 92.05 8,389.74 CULVER COMPANY LLC 33050 AP 2388 09/30/2013 Town Billing 1077-81,83-89 AR 20130901-20130930 User: (27.49) 8,362.25 AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/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-65085-030-000 Office Supplies Totals: 710.33 8,362.25 ** 8,200.00 Budgeted (162.25) Remaining 102 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2245 09/10/2013 September A/P Printer supplies 3,342.25 91.00 3,433.25 TOWN OF TROPHY CLUB 32984 AP 2384 09/30/2013 September AP Uniforms, Toner 202.00 3,635.25 TOWN OF TROPHY CLUB 33083 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 293.00 3,635.25 ** 5,732.00 Budgeted 2,096.75 Remaining 63 % Used Account: 135-65095-030-000 Maintenance Supplies 2386 09/26/2013 PCards 8/27-9/26/13 WAL-MART #5247 3,271.95 5.48 3,277.43 WAL-MART #5247 PC 2386 09/26/2013 PCards 8/27-9/26/13 SAMS INTERNET 46.98 3,324.41 SAMS INTERNET PC 2384 09/30/2013 September AP Food for open house, kitchen s 200.01 3,524.42 COSTCO WHOLESALE 33049 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 252.47 3,524.42 ** 1,500.00 Budgeted (2,024.42) Remaining 235 % Used Account: 135-65097-030-000 Vending Machine Supplies 94.58 .00 94.58 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 94.58 ** 500.00 Budgeted 405.42 Remaining 19 % Used Account: 135-65105-030-000 Printing 2284 09/19/2013 Sept A/P Print job 2,135.66 1,098.98 3,234.64 COMPUTER EXTENSION SYS. INC 32990 AP _______________ Account: 135-65105-030-000 Printing Totals: 1,098.98 3,234.64 ** 4,200.00 Budgeted 965.36 Remaining 77 % Used Account: 135-69170-030-000 Copier Lease Installments 2322 09/26/2013 Sept A/P Direct Energy, Kyocera, Verizo 2,825.35 256.85 3,082.20 TOWN OF TROPHY CLUB 33036 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 3,082.20 ** 3,450.00 Budgeted 367.80 Remaining 89 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 Department 30 Totals: ------------------------------------------------------------------------------------------------ 1,329,752.77 ** 1,182,142.00 Budgeted (147,610.77) Remaining 112 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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 2284 09/19/2013 Sept A/P Aug Legal 261,660.11 3,393.60 265,053.71 WHITAKER CHALK SWINDLE 33013 AP 2284 09/19/2013 Sept A/P Aug Legal 739.20 265,792.91 WHITAKER CHALK SWINDLE 33013 AP 2284 09/19/2013 Sept A/P August Legal 453.60 266,246.51 WHITAKER CHALK SWINDLE 33013 AP 2284 09/19/2013 Sept A/P Legal 6,333.09 272,579.60 THE LISTON LAW FIRM, P.C. 33009 AP 2284 09/19/2013 Sept A/P Aug legal 797.50 273,377.10 FREEMAN & CORBETT 32995 AP 2326 09/19/2013 Void ck 33009 Legal (6,333.09) 267,044.01 THE LISTON LAW FIRM, P.C. 33009 AP 2384 09/30/2013 September AP September legal 4,895.00 271,939.01 FREEMAN & CORBETT 33058 AP _______________ Account: 135-55045-039-000 Legal Totals: 10,278.90 271,939.01 ** 70,000.00 Budgeted (201,939.01) Remaining 388 % 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 2245 09/10/2013 September A/P 4th qtr DCAD budget 8,152.22 1,943.16 10,095.38 DENTON CENTRAL APPRAISAL DISTR 32950 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,943.16 10,095.38 ** 15,100.00 Budgeted 5,004.62 Remaining 67 % 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 Department 39 Totals: ------------------------------------------------------------------------------------------------ 417,458.16 ** 110,100.00 Budgeted (307,358.16) Remaining 379 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 172,684.37 .00 Budgeted (172,684.37) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 9/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 2350 09/30/2013 September bank interest (97.48) (10.71) (108.19) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (10.71) (108.19) ** (100.00) Budgeted 8.19 Remaining 108 % Used Department Totals: ------------------------------------------------------------------------------------------------ (445,108.19) ** (445,100.00) Budgeted 8.19 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 9/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 2358 09/25/2013 ReyMar App 4 Retainage 92,420.86 3,982.38 96,403.24 GL 2384 09/30/2013 September AP ROFC Improvements 787.50 97,190.74 DELTATEK ENGINEERING 33052 AP 2384 09/30/2013 September AP ROFC-App 4 35,841.45 133,032.19 REY-MAR CONSTRUCTION 33075 AP _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: 40,611.33 133,032.19 ** 165,000.00 Budgeted 31,967.81 Remaining 81 % 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: ------------------------------------------------------------------------------------------------ 154,915.02 ** 380,800.00 Budgeted 225,884.98 Remaining 41 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 9/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: ------------------------------------------------------------------------------------------------------ (206,999.13) (100.00) Budgeted 206,899.13 Remaining ########## . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 9/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 SEPTEMBER 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 13,033 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 11,863 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 29,742 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 11,863 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 11,863 FUND BALANCE ASSIGNED FUND BALANCE 136,417 NET REVENUES / EXPENDITURES (118,538) TOTAL FUND BALANCE 17,879 TOTAL LIABILITIES AND FUND BALANCE 29,742 . glbase_tbam rgonzale Trophy Club MUD #1 Page 27 18:00 10/09/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/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- 52.83- 198,179.29- 100.629 1,239.29 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- 8.55- 1,687.56- 33.637 3,329.44- Subtotal: 205,857.00- 205,857.00- 61.38- 202,894.25- 98.561 2,962.75- 533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 195,000.00- 56.522 150,000.00- Subtotal: 345,000.00- 345,000.00- 195,000.00- 56.522 150,000.00- 533-49010-000-000 Interest Income 1,700.00- 1,700.00- 11,574.31- 11,899.85- 699.991 10,199.85 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- 11,574.31- 319,899.85- 103.293 10,199.85 Program number: 860,557.00- 860,557.00- 11,635.69- 717,794.10- 83.410 142,762.90- Department number: Revenues 860,557.00- 860,557.00- 11,635.69- 717,794.10- 83.410 142,762.90- Revenues Subtotal ----------- 860,557.00- 860,557.00- 11,635.69- 717,794.10- 83.410 142,762.90- . glbase_tbam rgonzale Trophy Club MUD #1 Page 28 18:00 10/09/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/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 229,032.50 100.000 .50 533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00 100.000 Subtotal: 838,033.00 838,033.00 836,332.50 99.797 1,700.50 Program number: 838,033.00 838,033.00 836,332.50 99.797 1,700.50 Department number: Administration 838,033.00 838,033.00 836,332.50 99.797 1,700.50 Expenditures Subtotal ----------- 838,033.00 838,033.00 836,332.50 99.797 1,700.50 Fund number: 533 MUD 1 I&S Consolidated 22,524.00- 22,524.00- 11,635.69- 118,538.40 -526.276 141,062.40- ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/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 2373 09/03/2013 Property Taxes/Assessments (198,126.46) (35.49) (198,161.95) GL 2374 09/18/2013 Property Taxes/Assessments (13.83) (198,175.78) GL 2375 09/19/2013 Property Taxes/Assessments (3.51) (198,179.29) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (52.83) (198,179.29) ** (196,940.00) Budgeted 1,239.29 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 2373 09/03/2013 Property Taxes/Assessments (1,679.01) (6.74) (1,685.75) GL 2374 09/18/2013 Property Taxes/Assessments (1.11) (1,686.86) GL 2375 09/19/2013 Property Taxes/Assessments (.70) (1,687.56) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (8.55) (1,687.56) ** (5,017.00) Budgeted (3,329.44) Remaining 34 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees (195,000.00) .00 (195,000.00) _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 (195,000.00) ** (345,000.00) Budgeted (150,000.00) Remaining 57 % Used Account: 533-49010-000-000 Interest Income 2376 09/17/2013 2013 Bond Refunding Interest (325.54) (11,574.17) (11,899.71) GL 2350 09/30/2013 September bank interest (.14) (11,899.85) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (11,574.31) (11,899.85) ** (1,700.00) Budgeted 10,199.85 Remaining 700 % Used Account: 533-49015-000-000 Lease/Rental Income (308,000.00) .00 (308,000.00) . glpdatb2 rgonzale Trophy Club MUD #1 Page 64 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/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-49015-000-000 Lease/Rental Income Totals: .00 (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (717,794.10) ** (860,557.00) Budgeted (142,762.90) Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 65 19:15 10/09/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/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 229,032.50 .00 229,032.50 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 229,032.50 ** 229,033.00 Budgeted .50 Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment 605,000.00 .00 605,000.00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .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: ------------------------------------------------------------------------------------------------------ 118,538.40 (22,524.00) Budgeted (141,062.40) Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (285,876.53) **** (22,624.00) Budgeted 263,252.53 Remaining ########## ******* End of Report *********