Loading...
HomeMy WebLinkAboutOctober 2012 MUD Financials Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 10/31/2012 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 241,497 INVESTMENTS 2,721,890 RESTRICTED ASSETS: INVESTMENTS 424,356 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 98,576 UTILITY AND OTHER ACCOUNTS RECEIVABLE 965,877 TOTAL ASSETS 4,452,596$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 98,576$ ACCOUNTS PAYABLE 329,772 CUSTOMER DEPOSITS 210,107 TOTAL LIABILITIES 638,455 FUND BALANCE NON-SPENDABLE FUND BALANCE 2,463 ASSIGNED/WATER REPLACEMENT 90,000 ASSIGNED/TECHNOLOGY REPLACEMENT 82,359 ASSIGNED/FIRE DEPT REPLACEMENT 41,890 ASSIGNED FUND BALANCE 560,470 UNASSIGNED FUND BALANCE 3,036,959 TOTAL FUND BALANCE 3,814,141 TOTAL LIABILITIES AND FUND BALANCE 4,452,596$ October 31, 2012 1/12 Months (8.33% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2012 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- 2,512.70- 2,512.70- 2.516 97,371.30- 135-40002-000-000 Property Taxes/Delinquent 500.00- 500.00- 254.68- 254.68- 50.936 245.32- 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 78.03- 78.03- 6.503 1,121.97- Subtotal: 101,584.00- 101,584.00- 2,845.41- 2,845.41- 2.801 98,738.59- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 266,584.35- 266,584.35- 7.519 3,279,024.65- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 131,687.66- 131,687.66- 7.963 1,522,059.34- 135-47020-000-000 Standby 576.00- 576.00- 47.90- 47.90- 8.316 528.10- 135-47025-000-000 Penalties 64,580.00- 64,580.00- 5,041.52- 5,041.52- 7.807 59,538.48- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 903.00- 903.00- 7.768 10,722.00- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 1,800.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 150.00- 150.00- 2.885 5,050.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 77,575.00- Subtotal: 5,360,712.00- 5,360,712.00- 404,414.43- 404,414.43- 7.544 4,956,297.57- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 41,400.00- 41,400.00- 6.429 602,600.00- Subtotal: 644,000.00- 644,000.00- 41,400.00- 41,400.00- 6.429 602,600.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 601.85- 601.85- 10.943 4,898.15- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 847.00- 847.00- 8.333 9,317.00- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67- 135-49030-000-000 Vending Revenue 350.00- 350.00- 350.00- 135-49035-000-000 Prior Year Reserves 305,748.00- 305,748.00- 305,748.00- 135-49075-000-000 Oversize Meter Reimbursement 73,000.00- 73,000.00- 5,548.00- 5,548.00- 7.600 67,452.00- 135-49900-000-000 Miscellaneous Income 1,000.00- 1,000.00- 556.07- 556.07- 55.607 443.93- 135-49905-000-000 Gas Well Revenue 200.00- 200.00- 200.00- Subtotal: 402,962.00- 402,962.00- 8,136.25- 8,136.25- 2.019 394,825.75- Program number: 6,509,258.00- 6,509,258.00- 456,796.09- 456,796.09- 7.018 6,052,461.91- Department number: Revenues 6,509,258.00- 6,509,258.00- 456,796.09- 456,796.09- 7.018 6,052,461.91- Revenues Subtotal ----------- 6,509,258.00- 6,509,258.00- 456,796.09- 456,796.09- 7.018 6,052,461.91- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 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 9,102.28 9,102.28 4.267 204,218.72 135-50010-010-000 Overtime 13,250.00 13,250.00 2,212.56 2,212.56 16.699 11,037.44 135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00 135-50017-010-000 Certification 5,100.00 5,100.00 300.00 300.00 5.882 4,800.00 135-50020-010-000 Retirement 32,725.00 32,725.00 2,205.16 2,205.16 6.738 30,519.84 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 1,683.92 1,683.92 5.823 27,236.08 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 132.78 132.78 6.350 1,958.22 135-50028-010-000 Vision Insurance 519.00 519.00 31.76 31.76 6.119 487.24 135-50029-010-000 Life Insurance & Other 1,204.00 1,204.00 1,204.00 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 965.94 965.94 6.636 13,589.06 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 225.91 225.91 6.637 3,178.09 135-50040-010-000 Unemployment Taxes 945.00 945.00 945.00 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 6,109.00 6,109.00 100.000 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 350.00 Subtotal: 325,773.00 325,773.00 22,969.31 22,969.31 7.051 302,803.69 135-55005-010-000 Engineering 3,000.00 3,000.00 3,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 1,037.55 1,037.55 2.075 48,962.45 135-55090-010-000 Vehicle Maintenance 3,700.00 3,700.00 3,700.00 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 2,900.00 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 4,500.00 Subtotal: 64,100.00 64,100.00 1,037.55 1,037.55 1.619 63,062.45 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 2,000.00 135-60020-010-000 Electricity 162,410.00 162,410.00 5,401.93 5,401.93 3.326 157,008.07 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 135-60080-010-000 Schools & Training 1,672.00 1,672.00 1,672.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 700.00 700.00 149.30 149.30 21.329 550.70 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 TCEQ Fees & Permits 35,800.00 35,800.00 35,800.00 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 2,028,447.00 135-60245-010-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 45.00 45.00 1.071 4,155.00 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 1,500.00 Subtotal: 2,239,129.00 2,239,129.00 5,596.23 5,596.23 .250 2,233,532.77 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 27.70 27.70 .157 17,633.30 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 2,680.00 2,680.00 2,680.00 135-65030-010-000 Chemicals 6,200.00 6,200.00 672.30 672.30 10.844 5,527.70 135-65035-010-000 Small Tools 1,500.00 1,500.00 1,500.00 135-65040-010-000 Safety Equipment 2,000.00 2,000.00 2,000.00 135-65050-010-000 Meter Expense 143,550.00 143,550.00 143,550.00 Subtotal: 173,591.00 173,591.00 700.00 700.00 .403 172,891.00 135-69005-010-000 Capital Expenses 181,800.00 181,800.00 181,800.00 135-69008-010-000 Short Term Debt Payments 387,037.00 387,037.00 387,037.00 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 270,000.00 270,000.00 270,000.00 135-69281-010-000 Capital Repair-Ground Storage 150,000.00 150,000.00 150,000.00 Subtotal: 1,018,837.00 1,018,837.00 1,018,837.00 Program number: 3,821,430.00 3,821,430.00 30,303.09 30,303.09 .793 3,791,126.91 Department number: Water 3,821,430.00 3,821,430.00 30,303.09 30,303.09 .793 3,791,126.91 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2012 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 9,902.13 9,902.13 5.032 186,878.87 135-50010-020-000 Overtime 10,166.00 10,166.00 791.99 791.99 7.791 9,374.01 135-50016-020-000 Longevity 2,858.00 2,858.00 2,858.00 135-50017-020-000 Certification 4,200.00 4,200.00 350.00 350.00 8.333 3,850.00 135-50020-020-000 Retirement 29,821.00 29,821.00 2,108.94 2,108.94 7.072 27,712.06 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 2,327.30 2,327.30 8.016 26,706.70 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 175.34 175.34 8.302 1,936.66 135-50028-020-000 Vision Insurance 552.00 552.00 45.92 45.92 8.319 506.08 135-50029-020-000 Life Insurance & Other 920.00 920.00 920.00 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 785.74 785.74 5.922 12,482.26 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 183.78 183.78 5.923 2,919.22 135-50040-020-000 Unemployment Taxes 756.00 756.00 756.00 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 2,939.00 2,939.00 100.000 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 150.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 297,010.00 297,010.00 19,610.14 19,610.14 6.603 277,399.86 135-55070-020-000 Independent Labor 1,000.00 1,000.00 1,000.00 135-55080-020-000 Maintenance & Repairs 40,000.00 40,000.00 7,624.99 7,624.99 19.062 32,375.01 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 2,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,080.96 1,080.96 72.064 419.04 135-55125-020-000 Dumpster Services 15,000.00 15,000.00 15,000.00 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,080.00 1,080.00 3.600 28,920.00 Subtotal: 89,500.00 89,500.00 9,785.95 9,785.95 10.934 79,714.05 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 2,700.00 2,700.00 135-60020-020-000 Electricity 153,045.00 153,045.00 4,596.54 4,596.54 3.003 148,448.46 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60080-020-000 Schools & Training 3,272.00 3,272.00 3,272.00 135-60090-020-000 Safety Program 250.00 250.00 250.00 135-60100-020-000 Travel & per diem 1,400.00 1,400.00 116.55 116.55 8.325 1,283.45 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 1,020.00 1,020.00 68.000 480.00 135-60125-020-000 Advertising 2,000.00 2,000.00 2,000.00 135-60135-020-000 TCEQ Fees & Permits 56,000.00 56,000.00 7,729.80 7,729.80 13.803 48,270.20 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 Subtotal: 221,367.00 221,367.00 13,462.89 13,462.89 6.082 207,904.11 135-65005-020-000 Fuel & Lube 8,527.00 8,527.00 8,527.00 135-65010-020-000 Uniforms 2,574.00 2,574.00 2,574.00 135-65030-020-000 Chemicals 10,000.00 10,000.00 6,248.30 6,248.30 62.483 3,751.70 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-020-000 Small Tools 1,000.00 1,000.00 1,000.00 135-65040-020-000 Safety Equipment 250.00 250.00 250.00 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 3,855.26 3,855.26 38.553 6,144.74 Subtotal: 32,351.00 32,351.00 10,103.56 10,103.56 31.231 22,247.44 135-69005-020-000 Capital Expenses 241,200.00 241,200.00 241,200.00 135-69280-020-000 Capital Repairs 158,000.00 158,000.00 158,000.00 Subtotal: 399,200.00 399,200.00 399,200.00 Program number: 1,039,428.00 1,039,428.00 52,962.54 52,962.54 5.095 986,465.46 Department number: Wastewater 1,039,428.00 1,039,428.00 52,962.54 52,962.54 5.095 986,465.46 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2012 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 8,176.21 8,176.21 5.225 148,298.79 135-50010-021-000 Overtime 7,297.00 7,297.00 598.89 598.89 8.207 6,698.11 135-50016-021-000 Longevity 3,818.00 3,818.00 3,818.00 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 150.00 8.333 1,650.00 135-50020-021-000 Retirement 23,574.00 23,574.00 1,697.63 1,697.63 7.201 21,876.37 135-50026-021-000 Medical Insurance 20,198.00 20,198.00 1,683.08 1,683.08 8.333 18,514.92 135-50027-021-000 Dental Insurance 1,409.00 1,409.00 124.48 124.48 8.835 1,284.52 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 29.72 8.325 327.28 135-50029-021-000 Life Insurance & Other 1,008.00 1,008.00 1,008.00 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 707.03 707.03 6.732 9,794.97 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 165.35 165.35 6.732 2,290.65 135-50040-021-000 Unemployment Taxes 567.00 567.00 567.00 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 3,348.00 3,348.00 100.000 135-50070-021-000 Employee Relations 250.00 250.00 250.00 Subtotal: 233,059.00 233,059.00 16,680.39 16,680.39 7.157 216,378.61 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 35,000.00 168.50 168.50 .481 34,831.50 135-55090-021-000 Vehicle Maintenance 1,900.00 1,900.00 1,900.00 Subtotal: 38,400.00 38,400.00 168.50 168.50 .439 38,231.50 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 3,500.00 135-60020-021-000 Electricity 18,705.00 18,705.00 332.87 332.87 1.780 18,372.13 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 135-60080-021-000 Schools & Training 826.00 826.00 90.00 90.00 10.896 736.00 135-60090-021-000 Safety Program 500.00 500.00 500.00 135-60100-021-000 Travel & per diem 450.00 450.00 19.43 19.43 4.318 430.57 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 34,331.00 34,331.00 442.30 442.30 1.288 33,888.70 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 12,117.00 135-65010-021-000 Uniforms 2,220.00 2,220.00 2,220.00 135-65030-021-000 Chemicals 7,500.00 7,500.00 7,500.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 135-65040-021-000 Safety Equipment 500.00 500.00 500.00 Subtotal: 23,837.00 23,837.00 23,837.00 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 90,000.00 135-69008-021-000 Short Term Debt Payments 40,260.00 40,260.00 40,260.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 130,260.00 130,260.00 130,260.00 Program number: 459,887.00 459,887.00 17,291.19 17,291.19 3.760 442,595.81 Department number: Collection 459,887.00 459,887.00 17,291.19 17,291.19 3.760 442,595.81 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 500.00 500.00 5.000 9,500.00 135-50030-026-000 Social Security Taxes 620.00 620.00 31.00 31.00 5.000 589.00 135-50035-026-000 Medicare Taxes 145.00 145.00 7.25 7.25 5.000 137.75 135-50040-026-000 Unemployment Taxes 210.00 210.00 14.50 14.50 6.905 195.50 135-50045-026-000 Workman's Compensation 150.00 150.00 150.00 Subtotal: 11,125.00 11,125.00 552.75 552.75 4.969 10,572.25 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 2,100.00 135-60075-026-000 Meetings 1,200.00 1,200.00 22.00 22.00 1.833 1,178.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 3,000.00 Subtotal: 15,450.00 15,450.00 22.00 22.00 .142 15,428.00 Program number: 26,575.00 26,575.00 574.75 574.75 2.163 26,000.25 Department number: Board of Directors 26,575.00 26,575.00 574.75 574.75 2.163 26,000.25 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 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 25,870.34 25,870.34 5.817 418,859.66 135-50010-030-000 Overtime 1,500.00 1,500.00 8.94 8.94 .596 1,491.06 135-50016-030-000 Longevity 2,193.00 2,193.00 2,193.00 135-50020-030-000 Retirement 60,441.00 60,441.00 4,525.48 4,525.48 7.487 55,915.52 135-50026-030-000 Medical Insurance 44,066.00 44,066.00 3,185.30 3,185.30 7.228 40,880.70 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 288.72 288.72 8.545 3,090.28 135-50028-030-000 Vision Insurance 795.00 795.00 66.20 66.20 8.327 728.80 135-50029-030-000 Life Insurance & Other 2,500.00 2,500.00 2,500.00 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,937.42 1,937.42 6.969 25,864.58 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 453.11 453.11 6.969 6,048.89 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 195.84 195.84 12.742 1,341.16 135-50045-030-000 Workman's Compensation 831.00 831.00 831.00 831.00 100.000 135-50060-030-000 Pre-emp Physicals/Testing 250.00 250.00 35.00 35.00 14.000 215.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 5,000.00 Subtotal: 601,526.00 601,526.00 37,397.35 37,397.35 6.217 564,128.65 135-55030-030-000 Software & Support 63,555.00 63,555.00 2,961.75 2,961.75 4.660 60,593.25 135-55070-030-000 Independent Labor 2,700.00 2,700.00 2,700.00 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55100-030-000 Building Maint & Supplies 5,000.00 5,000.00 32.36 32.36 .647 4,967.64 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,678.51 1,678.51 8.309 18,521.49 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 15,000.00 135-55161-030-000 Outside Services-Town Semo 85,465.00 85,465.00 85,465.00 135-55165-030-000 Collection Fees 159.77 159.77 159.77- 135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 11,000.00 Subtotal: 203,420.00 203,420.00 4,832.39 4,832.39 2.376 198,587.61 135-60005-030-000 Telephone 9,000.00 9,000.00 1,339.34 1,339.34 14.882 7,660.66 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 150.00 150.00 4.196 3,425.00 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 13,019.00 135-60025-030-000 Water 3,100.00 3,100.00 3,100.00 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 13,182.00 135-60035-030-000 Postage 23,000.00 23,000.00 652.66 652.66 2.838 22,347.34 135-60040-030-000 Service Charges & Fees 18,000.00 18,000.00 2,750.83 2,750.83 15.282 15,249.17 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 1,056.53- 1,056.53- -12.430 9,556.53 135-60055-030-000 Insurance 35,000.00 35,000.00 34,065.48 34,065.48 97.330 934.52 135-60066-030-000 Publications/Books/Subscripts 750.00 750.00 449.22 449.22 59.896 300.78 135-60070-030-000 Dues & Memberships 2,400.00 2,400.00 100.00 100.00 4.167 2,300.00 135-60075-030-000 Meetings 250.00 250.00 88.00 88.00 35.200 162.00 135-60080-030-000 Schools & Training 5,500.00 5,500.00 5,500.00 135-60100-030-000 Travel & per diem 3,950.00 3,950.00 10.05 10.05 .254 3,939.95 135-60110-030-000 Physicals/Testing 500.00 500.00 500.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 4,000.00 4,000.00 4,000.00 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 15,000.00 15,000.00 13.00 13.00 .087 14,987.00 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 265.00 265.00 10.600 2,235.00 Subtotal: 173,076.00 173,076.00 38,827.05 38,827.05 22.434 134,248.95 135-65010-030-000 Uniforms 1,635.00 1,635.00 1,635.00 135-65055-030-000 Hardware 20,188.00 20,188.00 5,738.89 5,738.89 28.427 14,449.11 135-65085-030-000 Office Supplies 8,200.00 8,200.00 816.15 816.15 9.953 7,383.85 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 226.00 226.00 3.943 5,506.00 135-65095-030-000 Maintenance Supplies 2,000.00 2,000.00 2,000.00 135-65097-030-000 Vending Machine Supplies 500.00 500.00 500.00 135-65105-030-000 Printing 5,200.00 5,200.00 5,200.00 Subtotal: 43,455.00 43,455.00 6,781.04 6,781.04 15.605 36,673.96 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 256.85 7.445 3,193.15 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 256.85 256.85 .846 30,104.15 Program number: 1,051,838.00 1,051,838.00 88,094.68 88,094.68 8.375 963,743.32 Department number: Administration 1,051,838.00 1,051,838.00 88,094.68 88,094.68 8.375 963,743.32 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 15:59 11/15/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2012 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 70,000.00 135-55055-039-000 Auditing 21,200.00 21,200.00 21,200.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 2,322.74 2,322.74 15.382 12,777.26 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 110,100.00 110,100.00 2,322.74 2,322.74 2.110 107,777.26 Program number: 110,100.00 110,100.00 2,322.74 2,322.74 2.110 107,777.26 Department number: Non Departmental 110,100.00 110,100.00 2,322.74 2,322.74 2.110 107,777.26 Expenditures Subtotal ----------- 6,509,258.00 6,509,258.00 191,548.99 191,548.99 2.943 6,317,709.01 Fund number: 135 MUD 1 General Fund 265,247.10- 265,247.10- 265,247.10 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2012 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 195 10/02/2012 Property Taxes/Assessments (31.53) (31.53) GL 196 10/08/2012 Property Taxes/Assessments (10.98) (42.51) GL 198 10/10/2012 Property Taxes/Assessments (17.06) (59.57) GL 200 10/15/2012 Property Taxes/Assessments (26.04) (85.61) GL 201 10/16/2012 Property Taxes/Assessments (122.95) (208.56) GL 202 10/17/2012 Property Taxes/Assessments (129.24) (337.80) GL 204 10/18/2012 Property Taxes/Assessments (115.11) (452.91) GL 207 10/19/2012 Property Taxes/Assessments (164.52) (617.43) GL 209 10/22/2012 Property Taxes/Assessments (1,010.82) (1,628.25) GL 216 10/23/2012 Property Taxes/Assessments (172.15) (1,800.40) GL 219 10/23/2012 Property Taxes/Assessments (51.97) (1,852.37) GL 221 10/25/2012 Property Taxes/Assessments (136.48) (1,988.85) GL 223 10/26/2012 Property Taxes/Assessments (108.02) (2,096.87) GL 226 10/29/2012 Property Taxes/Assessments (153.36) (2,250.23) GL 227 10/30/2012 Property Taxes/Assessments (77.00) (2,327.23) GL 228 10/31/2012 Property Taxes/Assessments (185.47) (2,512.70) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (2,512.70) (2,512.70) ** (99,884.00) Budgeted (97,371.30) Remaining 3 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 193 10/01/2012 Property Taxes/Assessments (18.52) (18.52) GL 202 10/17/2012 Property Taxes/Assessments (115.26) (133.78) GL 209 10/22/2012 Property Taxes/Assessments (120.90) (254.68) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (254.68) (254.68) ** (500.00) Budgeted (245.32) Remaining 51 % Used Account: 135-40015-000-000 Property Taxes/P & I 193 10/01/2012 Property Taxes/Assessments (3.71) (3.71) GL 202 10/17/2012 Property Taxes/Assessments (43.32) (47.03) GL 209 10/22/2012 Property Taxes/Assessments (25.39) (72.42) GL 209 10/22/2012 Property Taxes/Assessments (.79) (73.21) GL 216 10/23/2012 Property Taxes/Assessments (2.66) (75.87) GL 228 10/31/2012 Property Taxes/Assessments (2.16) (78.03) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (78.03) (78.03) ** (1,200.00) Budgeted (1,121.97) Remaining 7 % Used Account: 135-47000-000-000 Water . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 234 10/01/2012 Reverse Unbilled WT/SW @ 9/30 52,456.71 52,456.71 GL 151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (317,116.50) (264,659.79) UB 251 10/31/2012 Recodes per J McKnight (466.99) (265,126.78) GL 251 10/31/2012 Recodes per J McKnight (1,457.57) (266,584.35) GL _______________ Account: 135-47000-000-000 Water Totals: (266,584.35) (266,584.35) ** (3,545,609.00) Budgeted (3,279,024.65) Remaining 8 % Used Account: 135-47005-000-000 Sewer 234 10/01/2012 Reverse Unbilled WT/SW @ 9/30 27,002.01 27,002.01 GL 151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (155,070.97) (128,068.96) UB 251 10/31/2012 Recodes per J McKnight (3,618.70) (131,687.66) GL _______________ Account: 135-47005-000-000 Sewer Totals: (131,687.66) (131,687.66) ** (1,653,747.00) Budgeted (1,522,059.34) Remaining 8 % Used Account: 135-47015-000-000 Commercial Sewer 151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (3,618.70) (3,618.70) UB 251 10/31/2012 Recodes per J McKnight 3,618.70 .00 GL _______________ Account: 135-47015-000-000 Commercial Sewer Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-47020-000-000 Standby 234 10/01/2012 Reverse Unbilled WT/SW @ 9/30 12.00 12.00 GL 151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (59.90) (47.90) UB _______________ Account: 135-47020-000-000 Standby Totals: (47.90) (47.90) ** (576.00) Budgeted (528.10) Remaining 8 % Used Account: 135-47025-000-000 Penalties 95 10/23/2012 UB 10/23/12 Penalties UB20121023-20121023 User: (5,021.58) (5,021.58) UB 134 10/29/2012 UB 10/29/2012 Adjustments UB20121029-20121029 User: 320.84 (4,700.74) UB 138 10/30/2012 UB 10/30/12 Adjustments UB20121030-20121030 User: 52.36 (4,648.38) UB 150 10/31/2012 UB 10/31/2012 Adjustments UB20121031-20121031 User: 17.16 (4,631.22) UB 151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (355.46) (4,986.68) UB 251 10/31/2012 Recodes per J McKnight (54.84) (5,041.52) GL _______________ Account: 135-47025-000-000 Penalties Totals: (5,041.52) (5,041.52) ** (64,580.00) Budgeted (59,538.48) Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 25 10/10/2012 UB 10/10/12 Disconnect Fees UB20121010-20121010 User: (800.00) (800.00) UB 73 10/10/2012 UB 10/10/12 Adjustment UB20121010-20121010 User: (25.00) (825.00) UB 139 10/24/2012 UB 10/24/12 NSF Check Fee UB20121024-20121024 User: (25.00) (850.00) UB 142 10/24/2012 UB 10/24/12 Adjustments UB20121024-20121024 User: (50.00) (900.00) UB 151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (3.00) (903.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (903.00) (903.00) ** (11,625.00) Budgeted (10,722.00) Remaining 8 % Used Account: 135-47035-000-000 Plumbing Inspections .00 .00 _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 .00 ** (1,800.00) Budgeted (1,800.00) Remaining 0 % Used Account: 135-47045-000-000 Sewer Inspections 211 10/24/2012 Permits 10/24/12 (150.00) (150.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (150.00) ** (5,200.00) Budgeted (5,050.00) Remaining 3 % Used Account: 135-47070-000-000 TCCC Effluent Charges .00 .00 _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 .00 ** (77,575.00) Budgeted (77,575.00) Remaining 0 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 41 10/12/2012 UB 10/12/12 Adjustments UB20121012-20121012 User: (200.00) (200.00) UB 151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (266.99) (466.99) UB 251 10/31/2012 Recodes per J McKnight 466.99 .00 GL _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-47410-000-000 Out of Dist/Portable Penalties 95 10/23/2012 UB 10/23/12 Penalties UB20121023-20121023 User: (54.84) (54.84) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 251 10/31/2012 Recodes per J McKnight 54.84 .00 GL _______________ Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-47600-000-000 PID #1 Water 151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (1,457.57) (1,457.57) UB 251 10/31/2012 Recodes per J McKnight 1,457.57 .00 GL _______________ Account: 135-47600-000-000 PID #1 Water Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-48005-000-000 Utility Fees 205 10/18/2012 Correct Util Fees coding/Oct 10/1-10/17 coded to I&S (25,300.00) (25,300.00) GL 203 10/19/2012 Permits 10/19/12 (2,300.00) (27,600.00) GL 210 10/23/2012 Permits 10/23/12 (2,300.00) (29,900.00) GL 211 10/24/2012 Permits 10/24/12 (4,600.00) (34,500.00) GL 212 10/25/2012 Permits 10/25/12 (6,900.00) (41,400.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (41,400.00) (41,400.00) ** (644,000.00) Budgeted (602,600.00) Remaining 6 % Used Account: 135-49010-000-000 Interest Income 224 10/31/2012 Oct Bank interest (117.28) (117.28) GL 224 10/31/2012 Oct Bank interest (484.57) (601.85) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (601.85) (601.85) ** (5,500.00) Budgeted (4,898.15) Remaining 11 % Used Account: 135-49016-000-000 Cell Tower Revenue 62 10/17/2012 AT&T Cell Tower/Oct (847.00) (847.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (847.00) ** (10,164.00) Budgeted (9,317.00) Remaining 8 % Used Account: 135-49018-000-000 Building Rent Income 60 10/17/2012 Town Sep/Oct Maint Barn rent (583.33) (583.33) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (583.33) ** (7,000.00) Budgeted (6,416.67) Remaining 8 % Used Account: 135-49030-000-000 Vending Revenue .00 .00 _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 .00 ** (350.00) Budgeted (350.00) Remaining 0 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (305,748.00) Budgeted (305,748.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 63 10/03/2012 Permits 10/3/12 (292.00) (292.00) GL 64 10/04/2012 Permits 10/4/12 (1,168.00) (1,460.00) GL 65 10/11/2012 Permit 10/11/12 (292.00) (1,752.00) GL 66 10/12/2012 Permits 10/12/12 (292.00) (2,044.00) GL 87 10/17/2012 Permits 10/17/12 (1,168.00) (3,212.00) GL 203 10/19/2012 Permits 10/19/12 (292.00) (3,504.00) GL 210 10/23/2012 Permits 10/23/12 (292.00) (3,796.00) GL 211 10/24/2012 Permits 10/24/12 (876.00) (4,672.00) GL 212 10/25/2012 Permits 10/25/12 (876.00) (5,548.00) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,548.00) (5,548.00) ** (73,000.00) Budgeted (67,452.00) Remaining 8 % Used Account: 135-49900-000-000 Miscellaneous Income 66 10/12/2012 Permits 10/12/12 (75.00) (75.00) GL 213 10/23/2012 Costco refund from coupon (1.01) (76.01) GL 211 10/24/2012 Permits 10/24/12 (50.00) (126.01) GL 145 10/31/2012 Oct A/P MUD W/C FY 2013 (429.66) (555.67) TML INTERGOVERNMENTAL RISK 31896 AP 240 10/31/2012 Unidentified Bank rec adj (.40) (556.07) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (556.07) (556.07) ** (1,000.00) Budgeted (443.93) Remaining 56 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49905-000-000 Gas Well Revenue .00 .00 _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (200.00) Budgeted (200.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (456,796.09) ** (6,509,258.00) Budgeted (6,052,461.91) Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 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 232 10/01/2012 Reverse Sept P/R accrual (3,723.15) (3,723.15) GL 103 10/12/2012 Payroll 10/12/12 6,355.52 2,632.37 GL 105 10/26/2012 Payroll 10/26/12 6,469.91 9,102.28 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 9,102.28 9,102.28 ** 213,321.00 Budgeted 204,218.72 Remaining 4 % Used Account: 135-50010-010-000 Overtime 232 10/01/2012 Reverse Sept P/R accrual (618.29) (618.29) GL 103 10/12/2012 Payroll 10/12/12 1,479.62 861.33 GL 103 10/12/2012 Payroll 10/12/12 160.00 1,021.33 GL 105 10/26/2012 Payroll 10/26/12 1,111.23 2,132.56 GL 105 10/26/2012 Payroll 10/26/12 80.00 2,212.56 GL _______________ Account: 135-50010-010-000 Overtime Totals: 2,212.56 2,212.56 ** 13,250.00 Budgeted 11,037.44 Remaining 17 % Used Account: 135-50016-010-000 Longevity .00 .00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 .00 ** 3,080.00 Budgeted 3,080.00 Remaining 0 % Used Account: 135-50017-010-000 Certification 103 10/12/2012 Payroll 10/12/12 300.00 300.00 GL _______________ Account: 135-50017-010-000 Certification Totals: 300.00 300.00 ** 5,100.00 Budgeted 4,800.00 Remaining 6 % Used Account: 135-50020-010-000 Retirement 103 10/12/2012 Payroll 10/12/12 1,146.39 1,146.39 GL 105 10/26/2012 Payroll 10/26/12 1,058.77 2,205.16 GL _______________ Account: 135-50020-010-000 Retirement Totals: 2,205.16 2,205.16 ** 32,725.00 Budgeted 30,519.84 Remaining 7 % Used Account: 135-50026-010-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 103 10/12/2012 Payroll 10/12/12 841.96 841.96 GL 105 10/26/2012 Payroll 10/26/12 841.96 1,683.92 GL _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,683.92 1,683.92 ** 28,920.00 Budgeted 27,236.08 Remaining 6 % Used Account: 135-50027-010-000 Dental Insurance 103 10/12/2012 Payroll 10/12/12 66.39 66.39 GL 105 10/26/2012 Payroll 10/26/12 66.39 132.78 GL _______________ Account: 135-50027-010-000 Dental Insurance Totals: 132.78 132.78 ** 2,091.00 Budgeted 1,958.22 Remaining 6 % Used Account: 135-50028-010-000 Vision Insurance 103 10/12/2012 Payroll 10/12/12 15.88 15.88 GL 105 10/26/2012 Payroll 10/26/12 15.88 31.76 GL _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 31.76 ** 519.00 Budgeted 487.24 Remaining 6 % Used Account: 135-50029-010-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: .00 .00 ** 1,204.00 Budgeted 1,204.00 Remaining 0 % Used Account: 135-50030-010-000 Social Security Taxes 103 10/12/2012 Payroll 10/12/12 502.62 502.62 GL 105 10/26/2012 Payroll 10/26/12 463.32 965.94 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 965.94 965.94 ** 14,555.00 Budgeted 13,589.06 Remaining 7 % Used Account: 135-50035-010-000 Medicare Taxes 103 10/12/2012 Payroll 10/12/12 117.55 117.55 GL 105 10/26/2012 Payroll 10/26/12 108.36 225.91 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 225.91 225.91 ** 3,404.00 Budgeted 3,178.09 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 945.00 Budgeted 945.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 145 10/31/2012 Oct A/P MUD W/C FY 2013 6,109.00 6,109.00 TML INTERGOVERNMENTAL RISK 31896 AP _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 6,109.00 6,109.00 ** 6,109.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 145 10/31/2012 Oct A/P Fire extinguisher PM/Refill 30.00 30.00 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP 145 10/31/2012 Oct A/P Well #1 Electrical 396.50 426.50 CIRCLE R ELECTRIC CO 31878 AP 145 10/31/2012 Oct A/P Oct PCards 547.98 974.48 JPMORGAN CHASE BANK NA 31885 AP 145 10/31/2012 Oct A/P Oct PCards 63.07 1,037.55 JPMORGAN CHASE BANK NA 31885 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,037.55 1,037.55 ** 50,000.00 Budgeted 48,962.45 Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-010-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 .00 ** 3,700.00 Budgeted 3,700.00 Remaining 0 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 2,900.00 Budgeted 2,900.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis .00 .00 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 .00 ** 4,500.00 Budgeted 4,500.00 Remaining 0 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60020-010-000 Electricity 75 10/19/2012 Oct A/P Electricity 10/1-10/11 4,390.00 4,390.00 HUDSON ENERGY 31833 AP 75 10/19/2012 Oct A/P Electricity 10/1-10/11 127.00 4,517.00 HUDSON ENERGY 31833 AP 145 10/31/2012 Oct A/P 10/1-10/11 Electricity 884.93 5,401.93 HUDSON ENERGY 31882 AP _______________ Account: 135-60020-010-000 Electricity Totals: 5,401.93 5,401.93 ** 162,410.00 Budgeted 157,008.07 Remaining 3 % Used Account: 135-60050-010-000 Bad Debt Expense 35 10/11/2012 UB 10/11/2012 Remit Payments UB20121011-20121011 User: MSCH (577.37) (577.37) UB 106 10/24/2012 AMS Collection Check 10/24/12 (37.72) (615.09) GL 109 10/25/2012 UB 10/25/12 AMS Collection Ck UB20121025-20121025 User: (441.44) (1,056.53) CR 251 10/31/2012 Recodes per J McKnight 1,056.53 .00 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training .00 .00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 .00 ** 1,672.00 Budgeted 1,672.00 Remaining 0 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 103 10/12/2012 Payroll 10/12/12 48.84 48.84 GL 105 10/26/2012 Payroll 10/26/12 100.46 149.30 GL _______________ Account: 135-60100-010-000 Travel & per diem Totals: 149.30 149.30 ** 700.00 Budgeted 550.70 Remaining 21 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits .00 .00 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 .00 ** 35,800.00 Budgeted 35,800.00 Remaining 0 % Used Account: 135-60150-010-000 Wholesale Water .00 .00 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 .00 ** 2,028,447.00 Budgeted 2,028,447.00 Remaining 0 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 145 10/31/2012 Oct A/P Oct PCards 27.00 27.00 JPMORGAN CHASE BANK NA 31885 AP 145 10/31/2012 Oct A/P Oct PCards 18.00 45.00 JPMORGAN CHASE BANK NA 31885 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 45.00 45.00 ** 4,200.00 Budgeted 4,155.00 Remaining 1 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 75 10/19/2012 Oct A/P Spare Pro keys for gas tank 27.70 27.70 SYN-TECH SYSTEMS, INC 31856 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 27.70 27.70 ** 17,661.00 Budgeted 17,633.30 Remaining 0 % Used Account: 135-65010-010-000 Uniforms .00 .00 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 .00 ** 2,680.00 Budgeted 2,680.00 Remaining 0 % Used Account: 135-65030-010-000 Chemicals 145 10/31/2012 Oct A/P Cholorine PO 020902 416.35 416.35 DPC INDUSTRIES, INC 31880 AP 145 10/31/2012 Oct A/P Oct PCards 255.95 672.30 JPMORGAN CHASE BANK NA 31885 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 672.30 672.30 ** 6,200.00 Budgeted 5,527.70 Remaining 11 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 .00 ** 143,550.00 Budgeted 143,550.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Expenses .00 .00 _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 .00 ** 181,800.00 Budgeted 181,800.00 Remaining 0 % Used Account: 135-69008-010-000 Short Term Debt Payments .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt Payments Totals: .00 .00 ** 387,037.00 Budgeted 387,037.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 270,000.00 Budgeted 270,000.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage .00 .00 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 .00 ** 150,000.00 Budgeted 150,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 30,303.09 ** 3,821,430.00 Budgeted 3,791,126.91 Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2012 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 232 10/01/2012 Reverse Sept P/R accrual (4,046.53) (4,046.53) GL 103 10/12/2012 Payroll 10/12/12 7,024.79 2,978.26 GL 105 10/26/2012 Payroll 10/26/12 6,923.87 9,902.13 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 9,902.13 9,902.13 ** 196,781.00 Budgeted 186,878.87 Remaining 5 % Used Account: 135-50010-020-000 Overtime 232 10/01/2012 Reverse Sept P/R accrual (169.37) (169.37) GL 103 10/12/2012 Payroll 10/12/12 376.40 207.03 GL 103 10/12/2012 Payroll 10/12/12 80.00 287.03 GL 105 10/26/2012 Payroll 10/26/12 344.96 631.99 GL 105 10/26/2012 Payroll 10/26/12 160.00 791.99 GL _______________ Account: 135-50010-020-000 Overtime Totals: 791.99 791.99 ** 10,166.00 Budgeted 9,374.01 Remaining 8 % Used Account: 135-50016-020-000 Longevity .00 .00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 .00 ** 2,858.00 Budgeted 2,858.00 Remaining 0 % Used Account: 135-50017-020-000 Certification 103 10/12/2012 Payroll 10/12/12 350.00 350.00 GL _______________ Account: 135-50017-020-000 Certification Totals: 350.00 350.00 ** 4,200.00 Budgeted 3,850.00 Remaining 8 % Used Account: 135-50020-020-000 Retirement 103 10/12/2012 Payroll 10/12/12 1,082.28 1,082.28 GL 105 10/26/2012 Payroll 10/26/12 1,026.66 2,108.94 GL _______________ Account: 135-50020-020-000 Retirement Totals: 2,108.94 2,108.94 ** 29,821.00 Budgeted 27,712.06 Remaining 7 % Used Account: 135-50026-020-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 103 10/12/2012 Payroll 10/12/12 1,163.65 1,163.65 GL 105 10/26/2012 Payroll 10/26/12 1,163.65 2,327.30 GL _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,327.30 2,327.30 ** 29,034.00 Budgeted 26,706.70 Remaining 8 % Used Account: 135-50027-020-000 Dental Insurance 103 10/12/2012 Payroll 10/12/12 87.67 87.67 GL 105 10/26/2012 Payroll 10/26/12 87.67 175.34 GL _______________ Account: 135-50027-020-000 Dental Insurance Totals: 175.34 175.34 ** 2,112.00 Budgeted 1,936.66 Remaining 8 % Used Account: 135-50028-020-000 Vision Insurance 103 10/12/2012 Payroll 10/12/12 22.96 22.96 GL 105 10/26/2012 Payroll 10/26/12 22.96 45.92 GL _______________ Account: 135-50028-020-000 Vision Insurance Totals: 45.92 45.92 ** 552.00 Budgeted 506.08 Remaining 8 % Used Account: 135-50029-020-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: .00 .00 ** 920.00 Budgeted 920.00 Remaining 0 % Used Account: 135-50030-020-000 Social Security Taxes 103 10/12/2012 Payroll 10/12/12 405.34 405.34 GL 105 10/26/2012 Payroll 10/26/12 380.40 785.74 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 785.74 785.74 ** 13,268.00 Budgeted 12,482.26 Remaining 6 % Used Account: 135-50035-020-000 Medicare Taxes 103 10/12/2012 Payroll 10/12/12 94.81 94.81 GL 105 10/26/2012 Payroll 10/26/12 88.97 183.78 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 183.78 183.78 ** 3,103.00 Budgeted 2,919.22 Remaining 6 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2012 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 .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 756.00 Budgeted 756.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 145 10/31/2012 Oct A/P MUD W/C FY 2013 2,939.00 2,939.00 TML INTERGOVERNMENTAL RISK 31896 AP _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 2,939.00 2,939.00 ** 2,939.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 75 10/19/2012 Oct A/P Repair Blowers PO 020856 6,839.50 6,839.50 AIR MAC 31818 AP 145 10/31/2012 Oct A/P Fire extinguisher PM/Refill 166.00 7,005.50 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP 145 10/31/2012 Oct A/P Oct PCards 14.49 7,019.99 JPMORGAN CHASE BANK NA 31885 AP 145 10/31/2012 Oct A/P Blower motor #2 alignment PO02 605.00 7,624.99 AIR MAC PO 020865 31874 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,624.99 7,624.99 ** 40,000.00 Budgeted 32,375.01 Remaining 19 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-020-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 75 10/19/2012 Oct A/P 4 Skid Loader Tires PO 020858 1,080.96 1,080.96 BLAGG TIRE & SERVICE 31820 AP _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 1,080.96 1,080.96 ** 1,500.00 Budgeted 419.04 Remaining 72 % Used Account: 135-55125-020-000 Dumpster Services .00 .00 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55135-020-000 Lab Analysis 145 10/31/2012 Oct A/P Bio-monitoring PO020871 1,080.00 1,080.00 HUTHER AND ASSOCIATES,INC 31883 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,080.00 1,080.00 ** 30,000.00 Budgeted 28,920.00 Remaining 4 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 2,700.00 Budgeted 2,700.00 Remaining 0 % Used Account: 135-60020-020-000 Electricity 75 10/19/2012 Oct A/P Electricity 10/1-10/12 4,596.54 4,596.54 HUDSON ENERGY 31833 AP _______________ Account: 135-60020-020-000 Electricity Totals: 4,596.54 4,596.54 ** 153,045.00 Budgeted 148,448.46 Remaining 3 % Used Account: 135-60066-020-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 3,272.00 Budgeted 3,272.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 103 10/12/2012 Payroll 10/12/12 69.93 69.93 GL 105 10/26/2012 Payroll 10/26/12 46.62 116.55 GL _______________ Account: 135-60100-020-000 Travel & per diem Totals: 116.55 116.55 ** 1,400.00 Budgeted 1,283.45 Remaining 8 % Used Account: 135-60105-020-000 Rent/Lease Equipment 75 10/19/2012 Oct A/P Rental 10HP waste pump PO02085 1,020.00 1,020.00 XYLEM WATER SOLUTIONS USA INC 31869 AP _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 1,020.00 1,020.00 ** 1,500.00 Budgeted 480.00 Remaining 68 % Used Account: 135-60125-020-000 Advertising .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 145 10/31/2012 Oct A/P CWQ Assessment fee 7,729.80 7,729.80 TX COMMISSION ENVIRONMENTAL QU 31898 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 7,729.80 7,729.80 ** 56,000.00 Budgeted 48,270.20 Remaining 14 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube .00 .00 _______________ Account: 135-65005-020-000 Fuel & Lube Totals: .00 .00 ** 8,527.00 Budgeted 8,527.00 Remaining 0 % Used Account: 135-65010-020-000 Uniforms .00 .00 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 .00 ** 2,574.00 Budgeted 2,574.00 Remaining 0 % Used Account: 135-65030-020-000 Chemicals 145 10/31/2012 Oct A/P Oct PCards 450.00 450.00 JPMORGAN CHASE BANK NA 31885 AP 145 10/31/2012 Oct A/P Oct PCards 450.00 900.00 JPMORGAN CHASE BANK NA 31885 AP 145 10/31/2012 Oct A/P Oct PCards 5,008.09 5,908.09 JPMORGAN CHASE BANK NA 31885 AP 145 10/31/2012 Oct A/P Non-ammonia polymer solvent PO 340.21 6,248.30 United Laboratories 31900 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 6,248.30 6,248.30 ** 10,000.00 Budgeted 3,751.70 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65035-020-000 Small Tools .00 .00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment .00 .00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-65045-020-000 Lab Supplies 145 10/31/2012 Oct A/P Lab supplies PO020860 3,855.26 3,855.26 IDEXX DISTRIBUTION, INC 31884 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 3,855.26 3,855.26 ** 10,000.00 Budgeted 6,144.74 Remaining 39 % Used Account: 135-69005-020-000 Capital Expenses .00 .00 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 .00 ** 241,200.00 Budgeted 241,200.00 Remaining 0 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 158,000.00 Budgeted 158,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 52,962.54 ** 1,039,428.00 Budgeted 986,465.46 Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2012 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 232 10/01/2012 Reverse Sept P/R accrual (3,298.79) (3,298.79) GL 103 10/12/2012 Payroll 10/12/12 5,702.12 2,403.33 GL 105 10/26/2012 Payroll 10/26/12 5,772.88 8,176.21 GL _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 8,176.21 8,176.21 ** 156,475.00 Budgeted 148,298.79 Remaining 5 % Used Account: 135-50010-021-000 Overtime 232 10/01/2012 Reverse Sept P/R accrual (59.93) (59.93) GL 103 10/12/2012 Payroll 10/12/12 184.87 124.94 GL 103 10/12/2012 Payroll 10/12/12 80.00 204.94 GL 105 10/26/2012 Payroll 10/26/12 393.95 598.89 GL _______________ Account: 135-50010-021-000 Overtime Totals: 598.89 598.89 ** 7,297.00 Budgeted 6,698.11 Remaining 8 % Used Account: 135-50016-021-000 Longevity .00 .00 _______________ Account: 135-50016-021-000 Longevity Totals: .00 .00 ** 3,818.00 Budgeted 3,818.00 Remaining 0 % Used Account: 135-50017-021-000 Certification 103 10/12/2012 Payroll 10/12/12 150.00 150.00 GL _______________ Account: 135-50017-021-000 Certification Totals: 150.00 150.00 ** 1,800.00 Budgeted 1,650.00 Remaining 8 % Used Account: 135-50020-021-000 Retirement 103 10/12/2012 Payroll 10/12/12 845.37 845.37 GL 105 10/26/2012 Payroll 10/26/12 852.26 1,697.63 GL _______________ Account: 135-50020-021-000 Retirement Totals: 1,697.63 1,697.63 ** 23,574.00 Budgeted 21,876.37 Remaining 7 % Used Account: 135-50026-021-000 Medical Insurance 103 10/12/2012 Payroll 10/12/12 841.54 841.54 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 105 10/26/2012 Payroll 10/26/12 841.54 1,683.08 GL _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,683.08 1,683.08 ** 20,198.00 Budgeted 18,514.92 Remaining 8 % Used Account: 135-50027-021-000 Dental Insurance 103 10/12/2012 Payroll 10/12/12 62.24 62.24 GL 105 10/26/2012 Payroll 10/26/12 62.24 124.48 GL _______________ Account: 135-50027-021-000 Dental Insurance Totals: 124.48 124.48 ** 1,409.00 Budgeted 1,284.52 Remaining 9 % Used Account: 135-50028-021-000 Vision Insurance 103 10/12/2012 Payroll 10/12/12 14.86 14.86 GL 105 10/26/2012 Payroll 10/26/12 14.86 29.72 GL _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 29.72 ** 357.00 Budgeted 327.28 Remaining 8 % Used Account: 135-50029-021-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: .00 .00 ** 1,008.00 Budgeted 1,008.00 Remaining 0 % Used Account: 135-50030-021-000 Social Security Taxes 103 10/12/2012 Payroll 10/12/12 351.97 351.97 GL 105 10/26/2012 Payroll 10/26/12 355.06 707.03 GL _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 707.03 707.03 ** 10,502.00 Budgeted 9,794.97 Remaining 7 % Used Account: 135-50035-021-000 Medicare Taxes 103 10/12/2012 Payroll 10/12/12 82.32 82.32 GL 105 10/26/2012 Payroll 10/26/12 83.03 165.35 GL _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 165.35 165.35 ** 2,456.00 Budgeted 2,290.65 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2012 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 .00 .00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 .00 ** 567.00 Budgeted 567.00 Remaining 0 % Used Account: 135-50045-021-000 Workman's Compensation 145 10/31/2012 Oct A/P MUD W/C FY 2013 3,348.00 3,348.00 TML INTERGOVERNMENTAL RISK 31896 AP _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 3,348.00 3,348.00 ** 3,348.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-021-000 Employee Relations .00 .00 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 145 10/31/2012 Oct A/P Fire extinguisher PM/Refill 168.50 168.50 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 168.50 168.50 ** 35,000.00 Budgeted 34,831.50 Remaining 0 % Used Account: 135-55090-021-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 .00 ** 1,900.00 Budgeted 1,900.00 Remaining 0 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-60020-021-000 Electricity 75 10/19/2012 Oct A/P Electricity 10/1-10/11 230.10 230.10 HUDSON ENERGY 31833 AP 75 10/19/2012 Oct A/P Electricity 10/1-10/12 83.80 313.90 HUDSON ENERGY 31833 AP 75 10/19/2012 Oct A/P Electricity 10/1-10/11 18.97 332.87 HUDSON ENERGY 31833 AP _______________ Account: 135-60020-021-000 Electricity Totals: 332.87 332.87 ** 18,705.00 Budgeted 18,372.13 Remaining 2 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training 145 10/31/2012 Oct A/P Oct PCards 90.00 90.00 JPMORGAN CHASE BANK NA 31885 AP _______________ Account: 135-60080-021-000 Schools & Training Totals: 90.00 90.00 ** 826.00 Budgeted 736.00 Remaining 11 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 103 10/12/2012 Payroll 10/12/12 16.10 16.10 GL 105 10/26/2012 Payroll 10/26/12 3.33 19.43 GL _______________ Account: 135-60100-021-000 Travel & per diem Totals: 19.43 19.43 ** 450.00 Budgeted 430.57 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2012 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-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-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 .00 .00 _______________ Account: 135-65005-021-000 Fuel & Lube Totals: .00 .00 ** 12,117.00 Budgeted 12,117.00 Remaining 0 % Used Account: 135-65010-021-000 Uniforms .00 .00 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 .00 ** 2,220.00 Budgeted 2,220.00 Remaining 0 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools .00 .00 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-65040-021-000 Safety Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-69005-021-000 Capital Expenses .00 .00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 .00 ** 90,000.00 Budgeted 90,000.00 Remaining 0 % Used Account: 135-69008-021-000 Short Term Debt Payments .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt Payments Totals: .00 .00 ** 40,260.00 Budgeted 40,260.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 17,291.19 ** 459,887.00 Budgeted 442,595.81 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2012 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 105 10/26/2012 Payroll 10/26/12 500.00 500.00 GL _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 500.00 ** 10,000.00 Budgeted 9,500.00 Remaining 5 % Used Account: 135-50030-026-000 Social Security Taxes 105 10/26/2012 Payroll 10/26/12 31.00 31.00 GL _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 31.00 ** 620.00 Budgeted 589.00 Remaining 5 % Used Account: 135-50035-026-000 Medicare Taxes 105 10/26/2012 Payroll 10/26/12 7.25 7.25 GL _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 7.25 ** 145.00 Budgeted 137.75 Remaining 5 % Used Account: 135-50040-026-000 Unemployment Taxes 105 10/26/2012 Payroll 10/26/12 14.50 14.50 GL _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 14.50 14.50 ** 210.00 Budgeted 195.50 Remaining 7 % Used Account: 135-50045-026-000 Workman's Compensation .00 .00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 2,100.00 Budgeted 2,100.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 75 10/19/2012 Oct A/P Chamber luncheon 22.00 22.00 NORTHWEST METROPORT CHAMBER 31844 AP _______________ Account: 135-60075-026-000 Meetings Totals: 22.00 22.00 ** 1,200.00 Budgeted 1,178.00 Remaining 2 % Used Account: 135-60080-026-000 Schools & Training .00 .00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 574.75 ** 26,575.00 Budgeted 26,000.25 Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 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 232 10/01/2012 Reverse Sept P/R accrual (8,073.48) (8,073.48) GL 103 10/12/2012 Payroll 10/12/12 17,039.38 8,965.90 GL 105 10/26/2012 Payroll 10/26/12 16,904.44 25,870.34 GL _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 25,870.34 25,870.34 ** 444,730.00 Budgeted 418,859.66 Remaining 6 % Used Account: 135-50010-030-000 Overtime 232 10/01/2012 Reverse Sept P/R accrual (7.38) (7.38) GL 103 10/12/2012 Payroll 10/12/12 6.00 (1.38) GL 105 10/26/2012 Payroll 10/26/12 10.32 8.94 GL _______________ Account: 135-50010-030-000 Overtime Totals: 8.94 8.94 ** 1,500.00 Budgeted 1,491.06 Remaining 1 % Used Account: 135-50016-030-000 Longevity .00 .00 _______________ Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 2,193.00 Budgeted 2,193.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 103 10/12/2012 Payroll 10/12/12 2,272.24 2,272.24 GL 105 10/26/2012 Payroll 10/26/12 2,253.24 4,525.48 GL _______________ Account: 135-50020-030-000 Retirement Totals: 4,525.48 4,525.48 ** 60,441.00 Budgeted 55,915.52 Remaining 7 % Used Account: 135-50026-030-000 Medical Insurance 103 10/12/2012 Payroll 10/12/12 1,592.65 1,592.65 GL 105 10/26/2012 Payroll 10/26/12 1,592.65 3,185.30 GL _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,185.30 3,185.30 ** 44,066.00 Budgeted 40,880.70 Remaining 7 % Used Account: 135-50027-030-000 Dental Insurance 103 10/12/2012 Payroll 10/12/12 144.36 144.36 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 105 10/26/2012 Payroll 10/26/12 144.36 288.72 GL _______________ Account: 135-50027-030-000 Dental Insurance Totals: 288.72 288.72 ** 3,379.00 Budgeted 3,090.28 Remaining 9 % Used Account: 135-50028-030-000 Vision Insurance 103 10/12/2012 Payroll 10/12/12 33.10 33.10 GL 105 10/26/2012 Payroll 10/26/12 33.10 66.20 GL _______________ Account: 135-50028-030-000 Vision Insurance Totals: 66.20 66.20 ** 795.00 Budgeted 728.80 Remaining 8 % Used Account: 135-50029-030-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-50030-030-000 Social Security Taxes 103 10/12/2012 Payroll 10/12/12 972.76 972.76 GL 105 10/26/2012 Payroll 10/26/12 964.66 1,937.42 GL _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,937.42 1,937.42 ** 27,802.00 Budgeted 25,864.58 Remaining 7 % Used Account: 135-50035-030-000 Medicare Taxes 103 10/12/2012 Payroll 10/12/12 227.51 227.51 GL 105 10/26/2012 Payroll 10/26/12 225.60 453.11 GL _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 453.11 453.11 ** 6,502.00 Budgeted 6,048.89 Remaining 7 % Used Account: 135-50040-030-000 Unemployment Taxes 103 10/12/2012 Payroll 10/12/12 100.05 100.05 GL 105 10/26/2012 Payroll 10/26/12 95.79 195.84 GL _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 195.84 195.84 ** 1,537.00 Budgeted 1,341.16 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 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 145 10/31/2012 Oct A/P MUD W/C FY 2013 831.00 831.00 TML INTERGOVERNMENTAL RISK 31896 AP _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 831.00 831.00 ** 831.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 145 10/31/2012 Oct A/P Pre-employment-Sisk 35.00 35.00 CARENOW CORPORATE 31876 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 35.00 35.00 ** 250.00 Budgeted 215.00 Remaining 14 % Used Account: 135-50070-030-000 Employee Relations .00 .00 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-55030-030-000 Software & Support 181 10/31/2012 Oct A/P PCards Pastor 25.00 25.00 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Zieverink 55.37 80.37 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Zieverink 53.38 133.75 BANK OF AMERICA 31902 AP 145 10/31/2012 Oct A/P VMWare Annual Maintenance 2,828.00 2,961.75 SHI GOVERNMENT SOLUTIONS,INC 31891 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 2,961.75 2,961.75 ** 63,555.00 Budgeted 60,593.25 Remaining 5 % Used Account: 135-55070-030-000 Independent Labor .00 .00 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 .00 ** 2,700.00 Budgeted 2,700.00 Remaining 0 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55100-030-000 Building Maint & Supplies 145 10/31/2012 Oct A/P Oct PCards 32.36 32.36 JPMORGAN CHASE BANK NA 31885 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 32.36 32.36 ** 5,000.00 Budgeted 4,967.64 Remaining 1 % Used Account: 135-55120-030-000 Cleaning Services 75 10/19/2012 Oct A/P Oct Cleaning services 1,678.51 1,678.51 ABM JANITORIAL SERVICES, INC 31816 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,678.51 1,678.51 ** 20,200.00 Budgeted 18,521.49 Remaining 8 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55161-030-000 Outside Services-Town Semo .00 .00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 .00 ** 85,465.00 Budgeted 85,465.00 Remaining 0 % Used Account: 135-55165-030-000 Collection Fees 106 10/24/2012 AMS Collection Check 10/24/12 21.19 21.19 GL 109 10/25/2012 UB 10/25/12 AMS Collection Ck CR Posting _20121025-20121025 138.58 159.77 CR _______________ Account: 135-55165-030-000 Collection Fees Totals: 159.77 159.77 ** .00 Budgeted (159.77) Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract .00 .00 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 .00 ** 11,000.00 Budgeted 11,000.00 Remaining 0 % Used Account: 135-60005-030-000 Telephone . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 181 10/31/2012 Oct A/P PCards Zieverink 95.66 95.66 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Zieverink 76.30 171.96 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Zieverink 377.41 549.37 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Zieverink 395.49 944.86 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Zieverink 394.48 1,339.34 BANK OF AMERICA 31902 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,339.34 1,339.34 ** 9,000.00 Budgeted 7,660.66 Remaining 15 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 103 10/12/2012 Payroll 10/12/12 150.00 150.00 GL _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 150.00 150.00 ** 3,575.00 Budgeted 3,425.00 Remaining 4 % Used Account: 135-60020-030-000 Electricity/Gas .00 .00 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 13,019.00 Budgeted 13,019.00 Remaining 0 % Used Account: 135-60025-030-000 Water .00 .00 _______________ Account: 135-60025-030-000 Water Totals: .00 .00 ** 3,100.00 Budgeted 3,100.00 Remaining 0 % Used Account: 135-60030-030-000 Rent And/Or Usage .00 .00 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 .00 ** 13,182.00 Budgeted 13,182.00 Remaining 0 % Used Account: 135-60035-030-000 Postage 181 10/31/2012 Oct A/P Leak post cards PO 447908 557.66 557.66 U.S. POSTAL SERVICE 31903 AP 145 10/31/2012 Oct A/P Permit 3 95.00 652.66 U.S. POSTAL SERVICE 31899 AP _______________ Account: 135-60035-030-000 Postage Totals: 652.66 652.66 ** 23,000.00 Budgeted 22,347.34 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees 231 10/02/2012 Credit Card/Online fees 62.22 62.22 GL 231 10/02/2012 Credit Card/Online fees 75.70 137.92 GL 231 10/02/2012 Credit Card/Online fees 2,612.91 2,750.83 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,750.83 2,750.83 ** 18,000.00 Budgeted 15,249.17 Remaining 15 % Used Account: 135-60050-030-000 Bad Debt Expense 251 10/31/2012 Recodes per J McKnight (1,056.53) (1,056.53) GL _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: (1,056.53) (1,056.53) ** 8,500.00 Budgeted 9,556.53 Remaining -12 % Used Account: 135-60055-030-000 Insurance 145 10/31/2012 Oct A/P Insurance for FY 2012 33,965.48 33,965.48 TML INTERGOVERNMENTAL RISK 31897 AP 145 10/31/2012 Oct A/P Bond Womack 50.00 34,015.48 VICTOR O SCHINNERER & CO, INC 31901 AP 145 10/31/2012 Oct A/P Bond G Cook 50.00 34,065.48 VICTOR O SCHINNERER & CO, INC 31901 AP _______________ Account: 135-60055-030-000 Insurance Totals: 34,065.48 34,065.48 ** 35,000.00 Budgeted 934.52 Remaining 97 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 145 10/31/2012 Oct A/P Governmental GAAP Guide 449.22 449.22 CCH 31877 AP _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 449.22 449.22 ** 750.00 Budgeted 300.78 Remaining 60 % Used Account: 135-60070-030-000 Dues & Memberships 114 10/26/2012 Oct A/P Annual Membership-State of Tx 100.00 100.00 TX COMPTROLLER 31870 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 100.00 100.00 ** 2,400.00 Budgeted 2,300.00 Remaining 4 % Used Account: 135-60075-030-000 Meetings 75 10/19/2012 Oct A/P Chamber luncheon 88.00 88.00 NORTHWEST METROPORT CHAMBER 31844 AP _______________ Account: 135-60075-030-000 Meetings Totals: 88.00 88.00 ** 250.00 Budgeted 162.00 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60080-030-000 Schools & Training .00 .00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 .00 ** 5,500.00 Budgeted 5,500.00 Remaining 0 % Used Account: 135-60100-030-000 Travel & per diem 105 10/26/2012 Payroll 10/26/12 10.05 10.05 GL _______________ Account: 135-60100-030-000 Travel & per diem Totals: 10.05 10.05 ** 3,950.00 Budgeted 3,939.95 Remaining 0 % 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 .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 242 10/31/2012 Bank Rec adjustment 13.00 13.00 GL _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 13.00 13.00 ** 15,000.00 Budgeted 14,987.00 Remaining 0 % Used Account: 135-60270-030-000 4th of July Celebration . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 75 10/19/2012 Oct A/P Furniture/Sisk 265.00 265.00 TEXAS FACILITIES COMMISSION 31859 AP _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 265.00 265.00 ** 2,500.00 Budgeted 2,235.00 Remaining 11 % Used Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 1,635.00 Budgeted 1,635.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 75 10/19/2012 Oct A/P Hardware/IT 33.94 33.94 SHI GOVERNMENT SOLUTIONS,INC 31853 AP 181 10/31/2012 Oct A/P PCards Pastor 1,796.41 1,830.35 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Pastor 319.00 2,149.35 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Pastor 1,461.34 3,610.69 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Pastor 974.23 4,584.92 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Zieverink 379.97 4,964.89 BANK OF AMERICA 31902 AP 145 10/31/2012 Oct A/P Intel Gigabit ET2 Quad Port Se 202.00 5,166.89 SHI GOVERNMENT SOLUTIONS,INC 31891 AP 145 10/31/2012 Oct A/P Projector lamp 193.00 5,359.89 SHI GOVERNMENT SOLUTIONS,INC 31891 AP 145 10/31/2012 Oct A/P Printer & toner for Terri Sisk 321.00 5,680.89 SHI GOVERNMENT SOLUTIONS,INC 31891 AP 145 10/31/2012 Oct A/P Fire extinguisher PM/Refill 58.00 5,738.89 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP _______________ Account: 135-65055-030-000 Hardware Totals: 5,738.89 5,738.89 ** 20,188.00 Budgeted 14,449.11 Remaining 28 % Used Account: 135-65085-030-000 Office Supplies 75 10/19/2012 Oct A/P Office supplies 70.92 70.92 OFFICE DEPOT, INC 31845 AP 75 10/19/2012 Oct A/P Office supplies 6.42 77.34 OFFICE DEPOT, INC 31845 AP 75 10/19/2012 Oct A/P PO Books 6.74 84.08 OFFICE DEPOT, INC 31845 AP 75 10/19/2012 Oct A/P Office Supplies 366.08 450.16 OFFICE DEPOT, INC 31845 AP 75 10/19/2012 Oct A/P Metal ruler 1.00 451.16 OFFICE DEPOT, INC 31845 AP 75 10/19/2012 Oct A/P Copier paper PO 447902 18.06 469.22 OFFICE DEPOT, INC 31845 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 145 10/31/2012 Oct A/P Office supplies PO447904 14.96 484.18 OFFICE DEPOT, INC 31890 AP 145 10/31/2012 Oct A/P Office Supplies PO447906 140.71 624.89 OFFICE DEPOT, INC 31890 AP 145 10/31/2012 Oct A/P Credit memo (23.36) 601.53 OFFICE DEPOT, INC 31890 AP 145 10/31/2012 Oct A/P Office supplies PO 447905 159.04 760.57 OFFICE DEPOT, INC 31890 AP 145 10/31/2012 Oct A/P Oct PCards 55.58 816.15 JPMORGAN CHASE BANK NA 31885 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 816.15 816.15 ** 8,200.00 Budgeted 7,383.85 Remaining 10 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 145 10/31/2012 Oct A/P Laserjet 110v fuser kit 78.00 78.00 SHI GOVERNMENT SOLUTIONS,INC 31891 AP 145 10/31/2012 Oct A/P Printer & toner for Terri Sisk 148.00 226.00 SHI GOVERNMENT SOLUTIONS,INC 31891 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 226.00 226.00 ** 5,732.00 Budgeted 5,506.00 Remaining 4 % Used Account: 135-65095-030-000 Maintenance Supplies .00 .00 _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 5,200.00 Budgeted 5,200.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 75 10/19/2012 Oct A/P Copier lease/Oct 256.85 256.85 KYOCERA MITA AMERICA, INC. 31835 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 256.85 ** 3,450.00 Budgeted 3,193.15 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2012 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-030-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 88,094.68 ** 1,051,838.00 Budgeted 963,743.32 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2012 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 .00 .00 _______________ Account: 135-55045-039-000 Legal Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 135-55055-039-000 Auditing .00 .00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 .00 ** 21,200.00 Budgeted 21,200.00 Remaining 0 % Used Account: 135-55060-039-000 Appraisal 145 10/31/2012 Oct A/P Budget allocations annual 2,322.74 2,322.74 TARRANT APPRAISAL DISTRICT 31895 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,322.74 2,322.74 ** 15,100.00 Budgeted 12,777.26 Remaining 15 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 3,800.00 Budgeted 3,800.00 Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 2,322.74 ** 110,100.00 Budgeted 107,777.26 Remaining 2 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (265,247.10) .00 Budgeted 265,247.10 Remaining 0 % Used Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 10/31/2012 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 326,693 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 1,028,199 ACCOUNTS RECEIVABLE - PID EMER SERVICES 246,750 OTHER RECEIVABLES 25,733 TOTAL ASSETS 1,627,375$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 1,274,949$ ACCOUNTS PAYABLE 23,531 TOTAL LIABILITIES 1,298,480$ FUND BALANCE UNASSIGNED FUND BALANCE 328,895 TOTAL LIABILITIES AND FUND BALANCE 1,627,375$ October 31, 2012 1/12 Months (8.33% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 15:59 11/15/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2012 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- 3,671.06- 3,671.06- 1.456 248,412.94- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 4,700.00- 5.36- 5.36- .114 4,694.64- 122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 26,422.94- 26,422.94- 2.516 1,023,926.06- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 2,362.65- 2,362.65- 40.735 3,437.35- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 1.08- 1.08- .144 748.92- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 593.43- 593.43- 13.187 3,906.57- Subtotal: 1,318,183.00- 1,318,183.00- 33,056.52- 33,056.52- 2.508 1,285,126.48- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 6,000.00- Subtotal: 6,000.00- 6,000.00- 6,000.00- 122-43400-000-000 Fire Inspections 500.00- 500.00- 500.00- 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,500.00- 10,500.00- 10,500.00- 122-49900-000-000 Miscellaneous Income 1,200.00- 1,200.00- 1,200.00- Subtotal: 1,200.00- 1,200.00- 1,200.00- Program number: 1,335,883.00- 1,335,883.00- 33,056.52- 33,056.52- 2.475 1,302,826.48- Department number: Fire Revenues 1,335,883.00- 1,335,883.00- 33,056.52- 33,056.52- 2.475 1,302,826.48- Revenues Subtotal ----------- 1,335,883.00- 1,335,883.00- 33,056.52- 33,056.52- 2.475 1,302,826.48- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 15:59 11/15/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 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 22,869.40 22,869.40 5.142 421,847.60 122-50010-045-000 Overtime 31,375.00 31,375.00 2,552.34 2,552.34 8.135 28,822.66 122-50011-045-000 DPS Holiday Pay 13,083.00 13,083.00 13,083.00 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.00 122-50017-045-000 Certification 4,896.00 4,896.00 575.00 575.00 11.744 4,321.00 122-50020-045-000 Retirement 69,242.00 69,242.00 4,687.17 4,687.17 6.769 64,554.83 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,336.51 3,336.51 6.904 44,990.49 122-50027-045-000 Dental Insurance 3,635.00 3,635.00 311.93 311.93 8.581 3,323.07 122-50028-045-000 Vision Insurance 824.00 824.00 64.11 64.11 7.780 759.89 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 4,250.00 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 1,993.94 1,993.94 6.454 28,903.06 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 466.36 466.36 6.454 6,759.64 122-50040-045-000 Unemployment Taxes 1,481.00 1,481.00 22.78 22.78 1.538 1,458.22 122-50045-045-000 Workman's Compensation 10,000.00 10,000.00 10,000.00 10,000.00 100.000 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 675.00 122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 Subtotal: 676,394.00 676,394.00 46,879.54 46,879.54 6.931 629,514.46 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 292.00 292.00 3.054 9,270.00 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 272.57 272.57 1.835 14,577.43 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 9,808.00 122-55100-045-000 Building Maintenance 6,500.00 6,500.00 243.51 243.51 3.746 6,256.49 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 1,103.00 122-55160-045-000 Professional Outside Services 2,500.00 2,500.00 2,500.00 Subtotal: 44,323.00 44,323.00 808.08 808.08 1.823 43,514.92 122-60005-045-000 Telephone 106.00 106.00 13.01 13.01 12.274 92.99 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 2,500.00 1,391.00 1,391.00 55.640 1,109.00 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 382.64 382.64 6.205 5,784.36 122-60025-045-000 Water 1,400.00 1,400.00 1,400.00 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 122-60035-045-000 Postage 100.00 100.00 100.00 122-60055-045-000 Insurance 10,000.00 10,000.00 50.00 50.00 .500 9,950.00 122-60066-045-000 Publications/Books/Subscrips 410.00 410.00 410.00 122-60070-045-000 Dues & Memberships 7,500.00 7,500.00 6,820.91 6,820.91 90.945 679.09 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 5,000.00 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 122-60100-045-000 Travel & per diem 4,800.00 4,800.00 4,800.00 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 150.00 150.00 122.35 122.35 81.567 27.65 122-60160-045-000 Programs & Special Projects 4,200.00 4,200.00 270.00 270.00 6.429 3,930.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 15:59 11/15/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 1,900.00 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 149.75 149.75 5.889 2,393.25 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 43.20 43.20 3.492 1,193.80 Subtotal: 359,088.00 359,088.00 9,242.86 9,242.86 2.574 349,845.14 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 10,000.00 122-65010-045-000 Uniforms 4,357.00 4,357.00 4,357.00 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 7,600.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 1,000.00 122-65035-045-000 Small Tools 5,000.00 5,000.00 5,000.00 122-65085-045-000 Office Supplies 1,200.00 1,200.00 5.56 5.56 .463 1,194.44 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 2,785.00 122-65105-045-000 Printing 106.00 106.00 106.00 Subtotal: 32,048.00 32,048.00 5.56 5.56 .017 32,042.44 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69008-045-000 Short Term Debt Payments 72,932.00 72,932.00 72,932.00 122-69050-045-000 Radios 2,500.00 2,500.00 2,500.00 122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 145,598.00 Subtotal: 224,030.00 224,030.00 224,030.00 Program number: 1,335,883.00 1,335,883.00 56,936.04 56,936.04 4.262 1,278,946.96 Department number: Fire 1,335,883.00 1,335,883.00 56,936.04 56,936.04 4.262 1,278,946.96 Expenditures Subtotal ----------- 1,335,883.00 1,335,883.00 56,936.04 56,936.04 4.262 1,278,946.96 Fund number: 122 Trophy Club MUD Fire Dept. 23,879.52 23,879.52 23,879.52- . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2012 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 197 10/09/2012 Property Taxes/Assessments (136.94) (136.94) GL 199 10/12/2012 Property Taxes/Assessments (331.85) (468.79) GL 206 10/18/2012 Property Taxes/Assessments (321.26) (790.05) GL 208 10/19/2012 Property Taxes/Assessments (435.24) (1,225.29) GL 214 10/22/2012 Property Taxes/Assessments (169.21) (1,394.50) GL 218 10/23/2012 Property Taxes/Assessments (420.36) (1,814.86) GL 220 10/24/2012 Property Taxes/Assessments (104.24) (1,919.10) GL 222 10/25/2012 Property Taxes/Assessments (1,075.63) (2,994.73) GL 225 10/26/2012 Property Taxes/Assessments (640.23) (3,634.96) GL 229 10/31/2012 Property Taxes/Assessments (36.10) (3,671.06) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (3,671.06) (3,671.06) ** (252,084.00) Budgeted (248,412.94) Remaining 1 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 194 10/01/2012 Property Taxes/Assessments (5.36) (5.36) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (5.36) (5.36) ** (4,700.00) Budgeted (4,694.64) Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 195 10/02/2012 Property Taxes/Assessments (331.60) (331.60) GL 196 10/08/2012 Property Taxes/Assessments (115.42) (447.02) GL 198 10/10/2012 Property Taxes/Assessments (179.37) (626.39) GL 200 10/15/2012 Property Taxes/Assessments (273.82) (900.21) GL 201 10/16/2012 Property Taxes/Assessments (1,292.95) (2,193.16) GL 202 10/17/2012 Property Taxes/Assessments (1,359.00) (3,552.16) GL 204 10/18/2012 Property Taxes/Assessments (1,210.49) (4,762.65) GL 207 10/19/2012 Property Taxes/Assessments (1,730.08) (6,492.73) GL 209 10/22/2012 Property Taxes/Assessments (10,629.48) (17,122.21) GL 216 10/23/2012 Property Taxes/Assessments (1,810.33) (18,932.54) GL 219 10/23/2012 Property Taxes/Assessments (546.55) (19,479.09) GL 221 10/25/2012 Property Taxes/Assessments (1,435.18) (20,914.27) GL 223 10/26/2012 Property Taxes/Assessments (1,135.86) (22,050.13) GL 226 10/29/2012 Property Taxes/Assessments (1,612.74) (23,662.87) GL 227 10/30/2012 Property Taxes/Assessments (809.72) (24,472.59) GL 228 10/31/2012 Property Taxes/Assessments (1,950.35) (26,422.94) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (26,422.94) (26,422.94) ** (1,050,349.00) Budgeted (1,023,926.06) Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 193 10/01/2012 Property Taxes/Assessments (204.62) (204.62) GL 202 10/17/2012 Property Taxes/Assessments (822.51) (1,027.13) GL 209 10/22/2012 Property Taxes/Assessments (1,335.52) (2,362.65) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (2,362.65) (2,362.65) ** (5,800.00) Budgeted (3,437.35) Remaining 41 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 194 10/01/2012 Property Taxes/Assessments (1.08) (1.08) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (1.08) (1.08) ** (750.00) Budgeted (748.92) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 193 10/01/2012 Property Taxes/Assessments (40.94) (40.94) GL 202 10/17/2012 Property Taxes/Assessments (272.04) (312.98) GL 209 10/22/2012 Property Taxes/Assessments (280.45) (593.43) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (593.43) (593.43) ** (4,500.00) Budgeted (3,906.57) Remaining 13 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft .00 .00 _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 .00 ** (6,000.00) Budgeted (6,000.00) Remaining 0 % Used Account: 122-43400-000-000 Fire Inspections .00 .00 _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 .00 ** (500.00) Budgeted (500.00) Remaining 0 % Used Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-49900-000-000 Miscellaneous Income .00 .00 _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 .00 ** (1,200.00) Budgeted (1,200.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (33,056.52) ** (1,335,883.00) Budgeted (1,302,826.48) Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 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 232 10/01/2012 Reverse Sept P/R accrual (9,241.15) (9,241.15) GL 103 10/12/2012 Payroll 10/12/12 15,565.98 6,324.83 GL 105 10/26/2012 Payroll 10/26/12 16,544.57 22,869.40 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 22,869.40 22,869.40 ** 444,717.00 Budgeted 421,847.60 Remaining 5 % Used Account: 122-50010-045-000 Overtime 105 10/26/2012 Payroll 10/26/12 2,552.34 2,552.34 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,552.34 2,552.34 ** 31,375.00 Budgeted 28,822.66 Remaining 8 % Used Account: 122-50011-045-000 DPS Holiday Pay .00 .00 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 .00 ** 13,083.00 Budgeted 13,083.00 Remaining 0 % Used Account: 122-50016-045-000 Longevity .00 .00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 .00 ** 4,266.00 Budgeted 4,266.00 Remaining 0 % Used Account: 122-50017-045-000 Certification 103 10/12/2012 Payroll 10/12/12 575.00 575.00 GL _______________ Account: 122-50017-045-000 Certification Totals: 575.00 575.00 ** 4,896.00 Budgeted 4,321.00 Remaining 12 % Used Account: 122-50020-045-000 Retirement 103 10/12/2012 Payroll 10/12/12 2,178.79 2,178.79 GL 105 10/26/2012 Payroll 10/26/12 2,508.38 4,687.17 GL _______________ Account: 122-50020-045-000 Retirement Totals: 4,687.17 4,687.17 ** 69,242.00 Budgeted 64,554.83 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 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 103 10/12/2012 Payroll 10/12/12 1,668.26 1,668.26 GL 105 10/26/2012 Payroll 10/26/12 1,668.25 3,336.51 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,336.51 3,336.51 ** 48,327.00 Budgeted 44,990.49 Remaining 7 % Used Account: 122-50027-045-000 Dental Insurance 103 10/12/2012 Payroll 10/12/12 155.96 155.96 GL 105 10/26/2012 Payroll 10/26/12 155.97 311.93 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 311.93 311.93 ** 3,635.00 Budgeted 3,323.07 Remaining 9 % Used Account: 122-50028-045-000 Vision Insurance 103 10/12/2012 Payroll 10/12/12 32.05 32.05 GL 105 10/26/2012 Payroll 10/26/12 32.06 64.11 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 64.11 64.11 ** 824.00 Budgeted 759.89 Remaining 8 % Used Account: 122-50029-045-000 Life Insurance & Other .00 .00 _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: .00 .00 ** 4,250.00 Budgeted 4,250.00 Remaining 0 % Used Account: 122-50030-045-000 Social Security Taxes 103 10/12/2012 Payroll 10/12/12 902.50 902.50 GL 105 10/26/2012 Payroll 10/26/12 1,091.44 1,993.94 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 1,993.94 1,993.94 ** 30,897.00 Budgeted 28,903.06 Remaining 6 % Used Account: 122-50035-045-000 Medicare Taxes 103 10/12/2012 Payroll 10/12/12 211.06 211.06 GL 105 10/26/2012 Payroll 10/26/12 255.30 466.36 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 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: 466.36 466.36 ** 7,226.00 Budgeted 6,759.64 Remaining 6 % Used Account: 122-50040-045-000 Unemployment Taxes 103 10/12/2012 Payroll 10/12/12 4.63 4.63 GL 105 10/26/2012 Payroll 10/26/12 18.15 22.78 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 22.78 22.78 ** 1,481.00 Budgeted 1,458.22 Remaining 2 % Used Account: 122-50045-045-000 Workman's Compensation 145 10/31/2012 Oct A/P MUD W/C FY 2013 10,000.00 10,000.00 TML INTERGOVERNMENTAL RISK 31896 AP _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 10,000.00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 675.00 Budgeted 675.00 Remaining 0 % 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-55080-045-000 Maintenance & Repairs 145 10/31/2012 Oct A/P Fire Extinguisher PM/Refill PO 292.00 292.00 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 292.00 292.00 ** 9,562.00 Budgeted 9,270.00 Remaining 3 % Used Account: 122-55090-045-000 Vehicle Maintenance 145 10/31/2012 Oct A/P Oct PCards 272.57 272.57 JPMORGAN CHASE BANK NA 31885 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 272.57 272.57 ** 14,850.00 Budgeted 14,577.43 Remaining 2 % Used Account: 122-55095-045-000 Equipment Maintenance .00 .00 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 .00 ** 9,808.00 Budgeted 9,808.00 Remaining 0 % Used Account: 122-55100-045-000 Building Maintenance 61 10/17/2012 Firefighters Assoc/Oct cable (120.00) (120.00) GL 145 10/31/2012 Oct A/P Oct PCards 157.83 37.83 JPMORGAN CHASE BANK NA 31885 AP 145 10/31/2012 Oct A/P Oct PCards 205.68 243.51 JPMORGAN CHASE BANK NA 31885 AP _______________ Account: 122-55100-045-000 Building Maintenance Totals: 243.51 243.51 ** 6,500.00 Budgeted 6,256.49 Remaining 4 % Used Account: 122-55110-045-000 Maintenance-Radios .00 .00 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 .00 ** 1,103.00 Budgeted 1,103.00 Remaining 0 % Used Account: 122-55160-045-000 Professional Outside Services .00 .00 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-60005-045-000 Telephone 181 10/31/2012 Oct A/P PCards Zieverink 7.85 7.85 BANK OF AMERICA 31902 AP 181 10/31/2012 Oct A/P PCards Zieverink 5.16 13.01 BANK OF AMERICA 31902 AP _______________ Account: 122-60005-045-000 Telephone Totals: 13.01 13.01 ** 106.00 Budgeted 92.99 Remaining 12 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 103 10/12/2012 Payroll 10/12/12 76.50 76.50 GL 75 10/19/2012 Oct A/P Dispatch for Fire 1,314.50 1,391.00 Denton County 31825 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 1,391.00 1,391.00 ** 2,500.00 Budgeted 1,109.00 Remaining 56 % Used Account: 122-60020-045-000 Electricity/Gas 75 10/19/2012 Oct A/P Electricity 10/1-10/12 352.21 352.21 HUDSON ENERGY 31833 AP 145 10/31/2012 Oct A/P 10/1-10/17 Gas at Fire Station 30.43 382.64 ATMOS ENERGY 31875 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 382.64 382.64 ** 6,167.00 Budgeted 5,784.36 Remaining 6 % Used Account: 122-60025-045-000 Water .00 .00 _______________ Account: 122-60025-045-000 Water Totals: .00 .00 ** 1,400.00 Budgeted 1,400.00 Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 308,000.00 Budgeted 308,000.00 Remaining 0 % Used Account: 122-60035-045-000 Postage .00 .00 _______________ Account: 122-60035-045-000 Postage Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 145 10/31/2012 Oct A/P Bond D Thomas 50.00 50.00 VICTOR O SCHINNERER & CO, INC 31901 AP _______________ Account: 122-60055-045-000 Insurance Totals: 50.00 50.00 ** 10,000.00 Budgeted 9,950.00 Remaining 1 % Used Account: 122-60066-045-000 Publications/Books/Subscrips . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 410.00 Budgeted 410.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 52 10/16/2012 Tx Fire Comm/ACH Annual Cert renewal 1,445.00 1,445.00 Tx Comptroller of Public Accts 31815 AP 145 10/31/2012 Oct A/P 2012-13 membership dues PO 000 5,100.91 6,545.91 NORTH EAST FIRE DEPT ASSOC 31888 AP 145 10/31/2012 Oct A/P Annual dues PO 000010 275.00 6,820.91 STATE FIREMEN'S FIRE MARSHALS 31892 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 6,820.91 6,820.91 ** 7,500.00 Budgeted 679.09 Remaining 91 % 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 .00 .00 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem .00 .00 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Account: 122-60110-045-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 145 10/31/2012 Oct A/P 2X6 Volunteer banner PO 00000 80.85 80.85 FASTSIGNS 31881 AP 145 10/31/2012 Oct A/P 2 small banners for FD PO 0000 41.50 122.35 FASTSIGNS 31881 AP _______________ Account: 122-60125-045-000 Advertising Totals: 122.35 122.35 ** 150.00 Budgeted 27.65 Remaining 82 % Used Account: 122-60160-045-000 Programs & Special Projects 145 10/31/2012 Oct A/P 2 banners PO 000004 270.00 270.00 LEE LOGO 31887 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 270.00 270.00 ** 4,200.00 Budgeted 3,930.00 Remaining 6 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement .00 .00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 ** 1,900.00 Budgeted 1,900.00 Remaining 0 % Used Account: 122-60195-045-000 Flags & Repair 145 10/31/2012 Oct A/P Flags PO000008 149.75 149.75 SYMONDS FLAGS & POLES 31894 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 149.75 149.75 ** 2,543.00 Budgeted 2,393.25 Remaining 6 % Used Account: 122-60245-045-000 Miscellaneous Expense 75 10/19/2012 Oct A/P Plaques PO 447901 43.20 43.20 OFFICE DEPOT, INC 31845 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 43.20 43.20 ** 1,237.00 Budgeted 1,193.80 Remaining 3 % Used Account: 122-65005-045-000 Fuel & Lube . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-65005-045-000 Fuel & Lube Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 122-65010-045-000 Uniforms .00 .00 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 .00 ** 4,357.00 Budgeted 4,357.00 Remaining 0 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 7,600.00 Budgeted 7,600.00 Remaining 0 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools .00 .00 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies 75 10/19/2012 Oct A/P Office Supplies 5.56 5.56 OFFICE DEPOT, INC 31845 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 5.56 5.56 ** 1,200.00 Budgeted 1,194.44 Remaining 0 % Used Account: 122-65095-045-000 Maintenance Supplies .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: .00 .00 ** 2,785.00 Budgeted 2,785.00 Remaining 0 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 106.00 Budgeted 106.00 Remaining 0 % Used Account: 122-69006-045-000 Grant Match .00 .00 _______________ Account: 122-69006-045-000 Grant Match Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt Payments .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt Payments Totals: .00 .00 ** 72,932.00 Budgeted 72,932.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 145,598.00 Budgeted 145,598.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 56,936.04 ** 1,335,883.00 Budgeted 1,278,946.96 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 23,879.52 .00 Budgeted (23,879.52) Remaining 0 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 10/31/2012 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 136,900 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 204,746 TOTAL ASSETS 347,766$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 204,746$ TOTAL LIABILITIES 204,746 FUND BALANCE ASSIGNED FUND BALANCE 143,020 TOTAL LIABILITIES AND FUND BALANCE 347,766$ October 31, 2012 1/12 Months (8.33% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 15:59 11/15/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 10/2012 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- 4,954.26- 4,954.26- 2.516 191,985.74- 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 1,294.04- 1,294.04- 33.181 2,605.96- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 335.70- 335.70- 6.691 4,681.30- Subtotal: 205,857.00- 205,857.00- 6,584.00- 6,584.00- 3.198 199,273.00- 533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 345,000.00- Subtotal: 345,000.00- 345,000.00- 345,000.00- 533-49010-000-000 Interest Income 1,700.00- 1,700.00- 18.54- 18.54- 1.091 1,681.46- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- Subtotal: 309,700.00- 309,700.00- 18.54- 18.54- .006 309,681.46- Program number: 860,557.00- 860,557.00- 6,602.54- 6,602.54- .767 853,954.46- Department number: Revenues 860,557.00- 860,557.00- 6,602.54- 6,602.54- .767 853,954.46- Revenues Subtotal ----------- 860,557.00- 860,557.00- 6,602.54- 6,602.54- .767 853,954.46- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 15:59 11/15/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 10/2012 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 4,000.00 533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 229,033.00 533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00 Subtotal: 838,033.00 838,033.00 838,033.00 Program number: 838,033.00 838,033.00 838,033.00 Department number: Administration 838,033.00 838,033.00 838,033.00 Expenditures Subtotal ----------- 838,033.00 838,033.00 838,033.00 Fund number: 533 MUD 1 I&S CONSOLIDATED 22,524.00- 22,524.00- 6,602.54- 6,602.54- 29.313 15,921.46- ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 10/2012 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 195 10/02/2012 Property Taxes/Assessments (62.18) (62.18) GL 196 10/08/2012 Property Taxes/Assessments (21.64) (83.82) GL 198 10/10/2012 Property Taxes/Assessments (33.63) (117.45) GL 200 10/15/2012 Property Taxes/Assessments (51.34) (168.79) GL 201 10/16/2012 Property Taxes/Assessments (242.42) (411.21) GL 202 10/17/2012 Property Taxes/Assessments (254.81) (666.02) GL 204 10/18/2012 Property Taxes/Assessments (226.97) (892.99) GL 207 10/19/2012 Property Taxes/Assessments (324.39) (1,217.38) GL 209 10/22/2012 Property Taxes/Assessments (1,993.02) (3,210.40) GL 216 10/23/2012 Property Taxes/Assessments (339.43) (3,549.83) GL 219 10/23/2012 Property Taxes/Assessments (102.47) (3,652.30) GL 221 10/25/2012 Property Taxes/Assessments (269.09) (3,921.39) GL 223 10/26/2012 Property Taxes/Assessments (212.98) (4,134.37) GL 226 10/29/2012 Property Taxes/Assessments (302.38) (4,436.75) GL 227 10/30/2012 Property Taxes/Assessments (151.82) (4,588.57) GL 228 10/31/2012 Property Taxes/Assessments (365.69) (4,954.26) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (4,954.26) (4,954.26) ** (196,940.00) Budgeted (191,985.74) Remaining 3 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 193 10/01/2012 Property Taxes/Assessments (104.63) (104.63) GL 202 10/17/2012 Property Taxes/Assessments (506.56) (611.19) GL 209 10/22/2012 Property Taxes/Assessments (682.85) (1,294.04) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (1,294.04) (1,294.04) ** (3,900.00) Budgeted (2,605.96) Remaining 33 % Used Account: 533-40015-000-000 Property Taxes/P & I 193 10/01/2012 Property Taxes/Assessments (20.92) (20.92) GL 202 10/17/2012 Property Taxes/Assessments (171.38) (192.30) GL 209 10/22/2012 Property Taxes/Assessments (143.40) (335.70) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (335.70) (335.70) ** (5,017.00) Budgeted (4,681.30) Remaining 7 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees 63 10/03/2012 Permits 10/3/12 (2,300.00) (2,300.00) GL 64 10/04/2012 Permits 10/4/12 (9,200.00) (11,500.00) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 10/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 65 10/11/2012 Permit 10/11/12 (2,300.00) (13,800.00) GL 66 10/12/2012 Permits 10/12/12 (2,300.00) (16,100.00) GL 87 10/17/2012 Permits 10/17/12 (9,200.00) (25,300.00) GL 205 10/18/2012 Correct Util Fees coding/Oct 10/1-10/17 coded to I&S 25,300.00 .00 GL _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (345,000.00) Budgeted (345,000.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 224 10/31/2012 Oct Bank interest (18.54) (18.54) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (18.54) (18.54) ** (1,700.00) Budgeted (1,681.46) Remaining 1 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (308,000.00) Budgeted (308,000.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (6,602.54) ** (860,557.00) Budgeted (853,954.46) Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 16:00 11/15/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 10/2012 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 .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 .00 ** 229,033.00 Budgeted 229,033.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 605,000.00 Budgeted 605,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 838,033.00 Budgeted 838,033.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (6,602.54) (22,524.00) Budgeted (15,921.46) Remaining 29 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (247,970.12) **** (22,524.00) Budgeted 225,446.12 Remaining ########## ******* End of Report *********