Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
June 2012 MUD Financials
Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 6/30/2012 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 721,318 INVESTMENTS 2,229,173 RESTRICTED ASSETS: INVESTMENTS 416,896 PREPAID EXPENSES 14,979 ADVALOREM PROPERTY TAXES RECEIVABLE 3,611 UTILITY AND OTHER ACCOUNTS RECEIVABLE 857,937 TOTAL ASSETS 4,244,314$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,611$ ACCOUNTS PAYABLE 475,515 CUSTOMER DEPOSITS 197,482 TOTAL LIABILITIES 676,608 FUND BALANCE NON-SPENDABLE FUND BALANCE 7,755 ASSIGNED/WATER REPLACEMENT 60,000 ASSIGNED/TECHNOLOGY REPLACEMENT 159,414 ASSIGNED FUND BALANCE 578,742 UNASSIGNED FUND BALANCE 2,761,796 TOTAL FUND BALANCE 3,567,707 TOTAL LIABILITIES AND FUND BALANCE 4,244,314$ June 30, 2012 9/12 Months (75% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 4 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 97,495.00- 97,495.00- 317.51- 96,458.76- 98.937 1,036.24- 135-40002-000-000 Property Taxes/Delinquent 451.00- 14.09- 657.55 -145.798 1,108.55- 135-40015-000-000 Property Taxes/P & I 1,334.00- 1,334.00- 68.45- 113.53- 8.510 1,220.47- Subtotal: 98,829.00- 99,280.00- 400.05- 95,914.74- 96.610 3,365.26- 135-43215-000-000 Insurance Settlement 3,999.00- 3,999.00 Subtotal: 3,999.00- 3,999.00 135-47000-000-000 Water 1,990,800.00- 1,990,800.00- 224,634.92- 1,094,329.59- 54.969 896,470.41- 135-47005-000-000 Sewer 1,325,000.00- 1,325,000.00- 106,080.55- 729,114.46- 55.028 595,885.54- 135-47010-000-000 Commercial Water 825,000.00- 825,000.00- 109,218.82- 480,984.45- 58.301 344,015.55- 135-47015-000-000 Commercial Sewer 360,000.00- 360,000.00- 30,542.53- 207,252.29- 57.570 152,747.71- 135-47020-000-000 Standby 775.00- 775.00- 56.35- 517.35- 66.755 257.65- 135-47025-000-000 Penalties 50,500.00- 50,500.00- 4,531.39- 36,146.19- 71.577 14,353.81- 135-47030-000-000 Service Charges 17,500.00- 17,500.00- 597.10- 9,029.48- 51.597 8,470.52- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 100.00- 1,400.00- 116.667 200.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 4,200.00- 93.333 300.00- 135-47070-000-000 TCCC Effluent Charges 57,500.00- 57,500.00- 21,888.37- 30,100.99- 52.350 27,399.01- 135-47270-000-000 Fire Line 5,000.00- 5,000.00- 5,000.00- 135-47400-000-000 Water-Out of Dist/Port Meters 41,595.00- 41,595.00- 3,750.22- 27,834.53- 66.918 13,760.47- 135-47405-000-000 Out of District Sewer 11,807.00- 11,807.00- 1,084.15- 8,367.59- 70.870 3,439.41- 135-47410-000-000 Out of Dist/Portable Penalties 300.00- 300.00- 139.21- 34.03- 11.343 265.97- 135-47600-000-000 PID #1 Water 425,000.00- 425,000.00- 74,733.64- 350,539.67- 82.480 74,460.33- 135-47605-000-000 PID #1 Sewer 185,000.00- 185,000.00- 27,824.42- 179,477.50- 97.015 5,522.50- Subtotal: 5,301,477.00- 5,301,477.00- 605,481.67- 3,159,328.12- 59.593 2,142,148.88- 135-48005-000-000 Utility Fees 338,880.00- 161,000.00- 32,200.00- 502,180.00- 311.913 341,180.00 Subtotal: 338,880.00- 161,000.00- 32,200.00- 502,180.00- 311.913 341,180.00 135-49005-000-000 Loan Proceeds 1,100,000.00- 1,100,000.00- 100.000 135-49010-000-000 Interest Income 4,500.00- 4,500.00- 569.47- 3,953.66- 87.859 546.34- 135-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 135-49016-000-000 Cell Tower Revenue 10,164.00- 847.00- 7,623.00- 75.000 2,541.00- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,249.97- 75.000 1,750.03- 135-49025-000-000 Auction Sales 4,305.00- 4,305.00 135-49030-000-000 Vending Revenue 600.00- 600.00- 406.74- 439.24- 73.207 160.76- 135-49035-000-000 Prior Year Reserves 241,981.00- 265,707.00- 265,707.00- 135-49036-000-000 GASB Reserves 26,911.00- 26,911.00- 26,911.00- 135-49075-000-000 Oversize Meter Reimbursement 64,000.00- 64,000.00- 4,672.00- 77,744.80- 121.476 13,744.80 135-49900-000-000 Miscellaneous Income 10,000.00- 10,000.00- 175.00- 5,418.82- 54.188 4,581.18- . glbase_tbam rgonzale Trophy Club Entities Page 5 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-49905-000-000 Gas Well Revenue 800.00- 800.00- 123.00- 15.375 677.00- Subtotal: 355,792.00- 1,797,682.00- 7,253.54- 1,204,857.49- 67.023 592,824.51- Program number: 6,094,978.00- 7,359,439.00- 645,335.26- 4,966,279.35- 67.482 2,393,159.65- Department number: Revenues 6,094,978.00- 7,359,439.00- 645,335.26- 4,966,279.35- 67.482 2,393,159.65- Revenues Subtotal ----------- 6,094,978.00- 7,359,439.00- 645,335.26- 4,966,279.35- 67.482 2,393,159.65- . glbase_tbam rgonzale Trophy Club Entities Page 6 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 199,759.00 160,600.00 12,853.74 113,206.12 70.489 47,393.88 135-50010-010-000 Overtime 13,250.00 13,250.00 1,184.65 12,410.46 93.664 839.54 135-50016-010-000 Longevity 2,620.00 2,620.00 2,620.00 100.000 135-50017-010-000 Certification 1,800.00 1,800.00 150.00 1,050.00 58.333 750.00 135-50020-010-000 Retirement 25,508.00 25,508.00 1,946.96 18,449.39 72.328 7,058.61 135-50026-010-000 Medical Insurance 22,607.00 22,607.00 1,642.80 15,443.69 68.314 7,163.31 135-50027-010-000 Dental Insurance 2,169.00 2,169.00 125.20 1,134.34 52.298 1,034.66 135-50028-010-000 Vision Insurance 576.00 576.00 31.76 276.85 48.064 299.15 135-50029-010-000 Life Insurance & Other 1,161.00 1,161.00 1,161.00 135-50030-010-000 Social Security Taxes 13,481.00 12,000.00 849.01 7,845.57 65.380 4,154.43 135-50035-010-000 Medicare Taxes 3,153.00 2,700.00 198.56 1,834.84 67.957 865.16 135-50040-010-000 Unemployment Taxes 945.00 945.00 288.00 30.476 657.00 135-50045-010-000 Workman's Compensation 5,581.00 5,581.00 5,581.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 118.64 33.897 231.36 Subtotal: 293,160.00 252,067.00 18,982.68 180,258.90 71.512 71,808.10 135-55005-010-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-010-000 Independent Labor 500.00 500.00 500.00 135-55080-010-000 Maintenance & Repairs 29,500.00 29,500.00 14,563.71 49.369 14,936.29 135-55090-010-000 Vehicle Maintenance 3,380.00 3,380.00 590.60 3,676.33 108.767 296.33- 135-55100-010-000 Building Maint & Supplies 750.00 750.00 471.85 62.913 278.15 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 464.49 16.017 2,435.51 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 1,725.00 38.333 2,775.00 Subtotal: 43,030.00 43,030.00 590.60 20,901.38 48.574 22,128.62 135-60010-010-000 Communications/Pagers/Mobiles 1,599.00 1,599.00 1,362.36 85.201 236.64 135-60020-010-000 Electricity 162,000.00 127,500.00 14,115.20 47,976.30 37.628 79,523.70 135-60035-010-000 Postage 500.00 500.00 658.35 687.40 137.480 187.40- 135-60050-010-000 Bad Debt Expense 4,200.00 4,200.00 4,200.00 135-60066-010-000 Publications/Books/Subscripts 50.00 50.00 85.00 170.000 35.00- 135-60070-010-000 Dues & Memberships 150.00 150.00 111.00 74.000 39.00 135-60080-010-000 Schools & Training 2,800.00 2,800.00 1,082.00 38.643 1,718.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 3,200.00 3,200.00 24.43 1,035.14 32.348 2,164.86 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 Annual Permit Fee 6,600.00 6,600.00 7,965.75 120.693 1,365.75- 135-60150-010-000 Wholesale Water 1,720,000.00 1,720,000.00 187,569.78 978,469.06 56.888 741,530.94 135-60245-010-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 380.38 9.057 3,819.62 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 2,000.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 299.99 19.999 1,200.01 . glbase_tbam rgonzale Trophy Club Entities Page 7 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 1,910,799.00 1,876,299.00 202,367.76 1,039,454.38 55.399 836,844.62 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 50.54 9,698.62 63.740 5,517.38 135-65010-010-000 Uniforms 3,690.00 3,690.00 1,400.99 37.967 2,289.01 135-65030-010-000 Chemicals 6,200.00 6,200.00 2,858.11 46.099 3,341.89 135-65035-010-000 Small Tools 2,500.00 2,500.00 203.00 8.120 2,297.00 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 347.00 13.880 2,153.00 135-65050-010-000 Meter Expense 85,000.00 94,000.00 92,842.07 98.768 1,157.93 135-65055-010-000 Hardware 1,000.00 1,000.00 1,000.00 135-65085-010-000 Office Supplies 30.00 30.00- 135-65095-010-000 Maintenance Supplies 32,000.00 32,000.00 11,678.22 36.494 20,321.78 135-65100-010-000 Copies 50.00 50.00 50.00 135-65105-010-000 Printing 150.00 150.00 58.50 39.000 91.50 Subtotal: 148,306.00 157,306.00 50.54 119,116.51 75.723 38,189.49 135-69005-010-000 Capital Expenses 888,432.00 1,455,600.00 124,612.59- 1,275,786.10 87.647 179,813.90 135-69008-010-000 Short Term Debt Payments 421,050.00 421,050.00 135-69035-010-000 Vehicles 27,000.00 27,000.00 49.72- 30,213.69 111.903 3,213.69- 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 24,000.00 24,000.00 24,000.00 135-69281-010-000 Capital Repair-Ground Storage 124,771.00 108,817.00 100,816.54 92.648 8,000.46 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 11,490.00 10,145.26 88.296 1,344.74 Subtotal: 1,105,943.00 2,078,207.00 124,662.31- 1,416,961.59 68.182 661,245.41 Program number: 3,501,238.00 4,406,909.00 97,329.27 2,776,692.76 63.008 1,630,216.24 Department number: Water 3,501,238.00 4,406,909.00 97,329.27 2,776,692.76 63.008 1,630,216.24 . glbase_tbam rgonzale Trophy Club Entities Page 8 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 182,147.00 182,147.00 11,854.10 141,598.30 77.738 40,548.70 135-50010-020-000 Overtime 10,166.00 10,166.00 944.89 9,184.84 90.349 981.16 135-50016-020-000 Longevity 3,976.00 3,976.00 3,975.00 99.975 1.00 135-50017-020-000 Certification 2,400.00 2,400.00 125.00 950.00 39.583 1,450.00 135-50020-020-000 Retirement 27,816.00 27,816.00 1,773.21 22,179.58 79.737 5,636.42 135-50026-020-000 Medical Insurance 30,805.00 30,805.00 1,734.69 19,396.49 62.965 11,408.51 135-50027-020-000 Dental Insurance 1,981.00 1,981.00 136.94 1,488.72 75.150 492.28 135-50028-020-000 Vision Insurance 552.00 552.00 34.44 370.58 67.134 181.42 135-50029-020-000 Life Insurance & Other 884.00 884.00 884.00 135-50030-020-000 Social Security Taxes 8,597.00 11,293.00 702.39 8,928.45 79.062 2,364.55 135-50035-020-000 Medicare Taxes 2,011.00 2,645.00 164.26 2,088.05 78.943 556.95 135-50040-020-000 Unemployment Taxes 567.00 567.00 17.37 333.21 58.767 233.79 135-50045-020-000 Workman's Compensation 2,685.00 2,685.00 2,685.00 100.000 135-50060-020-000 Pre-emp Physicals/Testing 200.00 85.00 115.45 57.725 84.55 135-50070-020-000 Employee Relations 350.00 350.00 64.45 18.414 285.55 Subtotal: 274,937.00 278,467.00 17,572.29 213,358.12 76.619 65,108.88 135-55070-020-000 Independent Labor 750.00 15,000.00 13,090.67 87.271 1,909.33 135-55080-020-000 Maintenance & Repairs 17,750.00 40,000.00 37,019.23 92.548 2,980.77 135-55090-020-000 Vehicle Maintenance 4,998.00 4,998.00 234.70 4.696 4,763.30 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 116.00 8.286 1,284.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 316.73 10.737 2,633.27 135-55125-020-000 Dumpster Services 35,000.00 35,000.00 28,487.50 81.393 6,512.50 135-55135-020-000 Lab Analysis 22,760.00 35,000.00 1,351.25 14,534.62 41.527 20,465.38 Subtotal: 85,608.00 134,348.00 1,351.25 93,799.45 69.818 40,548.55 135-60005-020-000 Telephone 100.00 18.72 18.720 81.28 135-60010-020-000 Communications/Pagers/Mobiles 3,000.00 3,000.00 1,727.60 57.587 1,272.40 135-60020-020-000 Electricity 205,000.00 161,160.00 10,204.61 54,414.62 33.764 106,745.38 135-60025-020-000 Water 1,900.00 1,900.00 1,647.06 86.687 252.94 135-60035-020-000 Postage 120.00 120.00 120.00 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 438.17 87.634 61.83 135-60080-020-000 Schools & Training 1,320.00 1,320.00 111.00 8.409 1,209.00 135-60090-020-000 Safety Program 200.00 200.00 116.45 58.225 83.55 135-60100-020-000 Travel & per diem 1,750.00 1,750.00 46.62 1,339.22 76.527 410.78 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 901.30 450.650 701.30- 135-60125-020-000 Advertising 1,500.00 987.36 65.824 512.64 135-60135-020-000 Annual Permit Fee 7,500.00 7,500.00 7,432.50 99.100 67.50 135-60245-020-000 Miscellaneous Expenses 525.00 525.00 76.02 14.480 448.98 135-60285-020-000 Lawn Equipment & Maintenance 525.00 525.00 525.00 Subtotal: 222,540.00 180,300.00 10,251.23 69,210.02 38.386 111,089.98 . glbase_tbam rgonzale Trophy Club Entities Page 9 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 6,875.00 6,875.00 133.82 3,190.01 46.400 3,684.99 135-65010-020-000 Uniforms 3,140.00 3,140.00 1,118.93 35.635 2,021.07 135-65030-020-000 Chemicals 13,180.00 13,180.00 6,586.47 49.973 6,593.53 135-65035-020-000 Small Tools 1,260.00 1,260.00 5.94 .471 1,254.06 135-65040-020-000 Safety Equipment 925.00 925.00 22.75 2.459 902.25 135-65045-020-000 Lab Supplies 19,160.00 12,000.00 4,249.03 35.409 7,750.97 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 262.99 362.53 90.633 37.47 135-65095-020-000 Maintenance Supplies 8,860.00 8,860.00 2,250.67 25.403 6,609.33 135-65115-020-000 Other Consumables 110.00 110.00 110.00 Subtotal: 54,435.00 47,275.00 396.81 17,786.33 37.623 29,488.67 135-69005-020-000 Capital Expenses 161,189.00 111,021.00 6,050.00 73,462.56 66.170 37,558.44 135-69008-020-000 Short Term Debt Payments 118,689.00 118,689.00 135-69280-020-000 Capital Repairs 56,000.00 56,000.00 56,000.00 Subtotal: 217,189.00 285,710.00 6,050.00 73,462.56 25.712 212,247.44 Program number: 854,709.00 926,100.00 35,621.58 467,616.48 50.493 458,483.52 Department number: Wastewater 854,709.00 926,100.00 35,621.58 467,616.48 50.493 458,483.52 . glbase_tbam rgonzale Trophy Club Entities Page 10 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 145,481.00 145,481.00 11,171.45 101,135.01 69.518 44,345.99 135-50010-021-000 Overtime 7,297.00 7,297.00 1,018.06 6,927.89 94.942 369.11 135-50016-021-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50017-021-000 Certification 1,500.00 1,500.00 100.00 850.00 56.667 650.00 135-50020-021-000 Retirement 21,074.00 21,074.00 1,695.71 16,076.72 76.287 4,997.28 135-50026-021-000 Medical Insurance 22,983.00 22,983.00 1,702.68 14,687.40 63.905 8,295.60 135-50027-021-000 Dental Insurance 1,533.00 1,533.00 117.38 1,014.93 66.205 518.07 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 257.75 72.199 99.25 135-50029-021-000 Life Insurance & Other 978.00 978.00 978.00 135-50030-021-000 Social Security Taxes 9,785.00 9,785.00 701.78 6,656.93 68.032 3,128.07 135-50035-021-000 Medicare Taxes 2,288.00 2,288.00 164.13 1,556.87 68.045 731.13 135-50040-021-000 Unemployment Taxes 567.00 567.00 216.00 38.095 351.00 135-50045-021-000 Workman's Compensation 3,056.00 3,056.00 3,056.00 100.000 135-50070-021-000 Employee Relations 250.00 250.00 64.43 25.772 185.57 Subtotal: 220,697.00 220,697.00 16,700.91 156,047.43 70.707 64,649.57 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-021-000 Independent Labor 200.00 200.00 200.00 135-55080-021-000 Maintenance & Repairs 23,700.00 23,700.00 4,157.53 17.542 19,542.47 135-55090-021-000 Vehicle Maintenance 1,943.00 1,943.00 49.72 259.22 13.341 1,683.78 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 28,093.00 28,093.00 49.72 4,416.75 15.722 23,676.25 135-60005-021-000 Telephone 50.00 22.37 44.740 27.63 135-60010-021-000 Communications/Pagers/Mobiles 2,796.00 2,796.00 2,160.42 77.268 635.58 135-60020-021-000 Electricity 23,625.00 21,550.00 971.51 8,191.03 38.009 13,358.97 135-60025-021-000 Water 750.00 750.00 750.00 135-60035-021-000 Postage 150.00 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 255.00 135-60080-021-000 Schools & Training 2,818.00 2,818.00 111.00 3.939 2,707.00 135-60090-021-000 Safety Program 750.00 750.00 750.00 135-60100-021-000 Travel & per diem 1,500.00 1,500.00 35.52 500.09 33.339 999.91 135-60105-021-000 Rent/Lease Equipment 44,107.00 76,098.00 76,098.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 1,000.00 Subtotal: 77,851.00 107,817.00 1,007.03 10,984.91 10.188 96,832.09 135-65005-021-000 Fuel & Lube 11,700.00 11,700.00 6,417.27 54.848 5,282.73 135-65010-021-000 Uniforms 2,505.00 2,505.00 832.88 33.249 1,672.12 135-65030-021-000 Chemicals 12,500.00 12,500.00 2,616.00 2,616.00 20.928 9,884.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 . glbase_tbam rgonzale Trophy Club Entities Page 11 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 22.74 1.977 1,127.26 135-65055-021-000 Hardware 750.00 750.00 44.95 5.993 705.05 135-65095-021-000 Maintenance Supplies 16,050.00 16,050.00 352.64 2.197 15,697.36 Subtotal: 46,155.00 46,155.00 2,616.00 10,286.48 22.287 35,868.52 135-69005-021-000 Capital Expenses 15,000.00 15,000.00 31,991.00 213.273 16,991.00- 135-69035-021-000 Vehicles 1,001.25 1,001.25- 135-69280-021-000 Capital Repairs 20,000.00 80,000.00 80,000.00 Subtotal: 35,000.00 95,000.00 32,992.25 34.729 62,007.75 Program number: 407,796.00 497,762.00 20,373.66 214,727.82 43.139 283,034.18 Department number: Collection 407,796.00 497,762.00 20,373.66 214,727.82 43.139 283,034.18 . glbase_tbam rgonzale Trophy Club Entities Page 12 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 6,400.00 64.000 3,600.00 135-50030-026-000 Social Security Taxes 620.00 620.00 396.80 64.000 223.20 135-50035-026-000 Medicare Taxes 145.00 145.00 92.80 64.000 52.20 135-50040-026-000 Unemployment Taxes 210.00 210.00 51.20 24.381 158.80 135-50045-026-000 Workman's Compensation 120.00 120.00 120.00 100.000 Subtotal: 11,095.00 11,095.00 7,060.80 63.639 4,034.20 135-60035-026-000 Postage 50.00 26.11 52.220 23.89 135-60066-026-000 Publications/Books/Subscripts 50.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 685.00 32.619 1,415.00 135-60075-026-000 Meetings 1,278.00 1,278.00 636.56 49.809 641.44 135-60080-026-000 Schools & Training 4,150.00 4,150.00 1,099.87 26.503 3,050.13 135-60100-026-000 Travel & per diem 6,199.00 6,199.00 32.19 .519 6,166.81 135-60245-026-000 Miscellaneous Expenses 3,200.00 3,200.00 1,117.69 34.928 2,082.31 Subtotal: 16,977.00 16,977.00 3,597.42 21.190 13,379.58 135-65085-026-000 Office Supplies 50.00 50.00 23.90 47.800 26.10 Subtotal: 50.00 50.00 23.90 47.800 26.10 Program number: 28,122.00 28,122.00 10,682.12 37.985 17,439.88 Department number: Board of Directors 28,122.00 28,122.00 10,682.12 37.985 17,439.88 . glbase_tbam rgonzale Trophy Club Entities Page 13 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-027-000 Salaries & Wages 236,831.00 236,831.00 13,849.99 201,836.96 85.224 34,994.04 135-50010-027-000 Overtime 1,000.00 1,028.00 33.80 1,110.94 108.068 82.94- 135-50016-027-000 Longevity 1,845.00 1,845.00 3,705.00 200.813 1,860.00- 135-50020-027-000 Retirement 33,471.00 33,471.00 1,890.46 28,812.23 86.081 4,658.77 135-50026-027-000 Medical Insurance 18,798.00 18,798.00 1,358.34 12,796.92 68.076 6,001.08 135-50027-027-000 Dental Insurance 1,242.00 1,242.00 112.25 1,003.13 80.767 238.87 135-50028-027-000 Vision Insurance 341.00 341.00 26.34 245.49 71.991 95.51 135-50029-027-000 Life Insurance & Other 1,337.00 1,337.00 1,337.00 135-50030-027-000 Social Security Taxes 14,860.00 14,860.00 770.86 12,253.88 82.462 2,606.12 135-50035-027-000 Medicare Taxes 3,475.00 3,475.00 180.28 2,903.71 83.560 571.29 135-50040-027-000 Unemployment Taxes 756.00 756.00 1.64 321.94 42.585 434.06 135-50045-027-000 Workman's Compensation 580.00 580.00 580.00 100.000 135-50060-027-000 Pre-emp Physicals/Testing 17.50 52.50 52.50- 135-50070-027-000 Employee Relations 5,000.00 5,000.00 3,622.88 72.458 1,377.12 Subtotal: 319,536.00 319,564.00 18,241.46 269,245.58 84.254 50,318.42 135-55070-027-000 Independent Labor 840.00 840.00 251.25 29.911 588.75 135-55075-027-000 Records Management 500.00 500.00 500.00 135-55160-027-000 Professional Outside Services 176,870.00 190,979.00 191,092.23 100.059 113.23- Subtotal: 178,210.00 192,319.00 191,343.48 99.493 975.52 135-60005-027-000 Telephone 300.00 300.00 199.11 66.370 100.89 135-60010-027-000 Communications/Pagers/Mobiles 2,420.00 2,420.00 75.00 1,289.79 53.297 1,130.21 135-60035-027-000 Postage 1,800.00 851.79 1,847.74 102.652 47.74- 135-60066-027-000 Publications/Books/Subscripts 450.00 450.00 354.15 78.700 95.85 135-60070-027-000 Dues & Memberships 1,742.00 1,742.00 300.00 827.05 47.477 914.95 135-60075-027-000 Meetings 312.00 312.00 42.44 13.603 269.56 135-60080-027-000 Schools & Training 2,555.00 2,555.00 1,405.00 54.990 1,150.00 135-60100-027-000 Travel & per diem 3,851.00 3,851.00 1,074.02 27.889 2,776.98 135-60115-027-000 Elections 2,500.00 2,500.00 612.49 24.500 1,887.51 135-60125-027-000 Advertising 4,700.00 4,700.00 4,700.00 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60270-027-000 4th of July Celebration 10,000.00 10,000.00 105.00 10,105.00 101.050 105.00- 135-60360-027-000 Furniture/Equipment < $5000 2,225.00 2,225.00 1,616.99 72.674 608.01 Subtotal: 31,155.00 32,955.00 1,331.79 19,373.78 58.789 13,581.22 135-65085-027-000 Office Supplies 2,450.00 2,450.00 35.15 2,381.28 97.195 68.72 135-65105-027-000 Printing 515.00 750.00 589.45 78.593 160.55 Subtotal: 2,965.00 3,200.00 35.15 2,970.73 92.835 229.27 . glbase_tbam rgonzale Trophy Club Entities Page 14 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Program number: 531,866.00 548,038.00 19,608.40 482,933.57 88.120 65,104.43 Department number: Manager's Office 531,866.00 548,038.00 19,608.40 482,933.57 88.120 65,104.43 . glbase_tbam rgonzale Trophy Club Entities Page 15 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50070-028-000 Employee Relations 1,967.00 1,967.00 1,478.72 75.176 488.28 135-50075-028-000 Tuition Reimbursement 1,561.00 1,561.00 219.42 14.056 1,341.58 Subtotal: 3,528.00 3,528.00 1,698.14 48.133 1,829.86 135-60005-028-000 Telephone 28.00 28.00 28.00 135-60035-028-000 Postage 106.00 106.00 22.23 20.972 83.77 135-60066-028-000 Publications/Books/Subscripts 485.00 485.00 485.00 135-60070-028-000 Dues & Memberships 555.00 555.00 555.00 135-60075-028-000 Meetings 138.00 138.00 138.00 135-60080-028-000 Schools & Training 594.00 594.00 594.00 135-60100-028-000 Travel & per diem 8.00 135-60110-028-000 Physicals/Testing 1,560.00 1,560.00 165.00 10.577 1,395.00 Subtotal: 3,474.00 3,466.00 187.23 5.402 3,278.77 135-65085-028-000 Office Supplies 437.00 437.00 437.00 135-65105-028-000 Printing 116.00 116.00 116.00 Subtotal: 553.00 553.00 553.00 Program number: 7,555.00 7,547.00 1,885.37 24.982 5,661.63 Department number: Human Resources 7,555.00 7,547.00 1,885.37 24.982 5,661.63 . glbase_tbam rgonzale Trophy Club Entities Page 16 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 94,404.00 94,404.00 6,002.40 60,049.02 63.609 34,354.98 135-50010-029-000 Overtime 1,000.00 1,000.00 946.28 94.628 53.72 135-50016-029-000 Longevity 1,823.00 1,823.00 1,822.50 99.973 .50 135-50020-029-000 Retirement 13,612.00 13,612.00 829.54 9,027.68 66.321 4,584.32 135-50026-029-000 Medical Insurance 11,060.00 11,060.00 410.70 5,363.88 48.498 5,696.12 135-50027-029-000 Dental Insurance 773.00 773.00 49.02 526.93 68.167 246.07 135-50028-029-000 Vision Insurance 207.00 207.00 6.76 80.91 39.087 126.09 135-50029-029-000 Life Insurance & Other 567.00 567.00 567.00 135-50030-029-000 Social Security Taxes 5,386.00 5,386.00 345.84 3,642.05 67.621 1,743.95 135-50035-029-000 Medicare Taxes 1,260.00 1,260.00 80.88 851.77 67.601 408.23 135-50040-029-000 Unemployment Taxes 284.00 284.00 79.54 28.007 204.46 135-50045-029-000 Workman's Compensation 235.00 235.00 211.00 89.787 24.00 Subtotal: 130,611.00 130,611.00 7,725.14 82,601.56 63.242 48,009.44 135-55160-029-000 Professional Outside Services 5,000.00 5,000.00 1,105.50 22.110 3,894.50 Subtotal: 5,000.00 5,000.00 1,105.50 22.110 3,894.50 135-60005-029-000 Telephone 103.00 103.00 56.03 54.398 46.97 135-60010-029-000 Communications/Pagers/Mobiles 683.00 683.00 409.34 59.933 273.66 135-60035-029-000 Postage 700.00 700.00 27.20 230.89 32.984 469.11 135-60040-029-000 Service Charges & Fees 79.00 79.00 32.50 41.139 46.50 135-60066-029-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-029-000 Dues & Memberships 660.00 660.00 660.00 135-60075-029-000 Meetings 300.00 300.00 22.00 7.333 278.00 135-60080-029-000 Schools & Training 2,000.00 2,000.00 225.00 11.250 1,775.00 135-60100-029-000 Travel & per diem 1,500.00 27.81 27.81- 135-60125-029-000 Advertising 1,210.00 1,210.00 1,210.00 135-60245-029-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 7,935.00 6,435.00 27.20 1,003.57 15.595 5,431.43 135-65085-029-000 Office Supplies 849.00 849.00 148.52 17.494 700.48 135-65105-029-000 Printing 515.00 515.00 515.00 Subtotal: 1,364.00 1,364.00 148.52 10.889 1,215.48 Program number: 144,910.00 143,410.00 7,752.34 84,859.15 59.172 58,550.85 Department number: Finance 144,910.00 143,410.00 7,752.34 84,859.15 59.172 58,550.85 . glbase_tbam rgonzale Trophy Club Entities Page 17 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55030-033-000 Software & Support 64,149.00 64,149.00 417.70 56,949.78 88.777 7,199.22 135-55070-033-000 Independent Labor 1,650.00 1,650.00 375.00 22.727 1,275.00 Subtotal: 65,799.00 65,799.00 417.70 57,324.78 87.121 8,474.22 135-60005-033-000 Telephone 6,540.00 6,540.00 6,061.10 92.677 478.90 135-60235-033-000 Security 1,350.00 1,350.00 406.60 30.119 943.40 Subtotal: 7,890.00 7,890.00 6,467.70 81.973 1,422.30 135-65055-033-000 Hardware 83,238.00 83,238.00 70,584.05 84.798 12,653.95 135-65085-033-000 Office Supplies 371.00 371.00 104.00 334.90 90.270 36.10 135-65090-033-000 Printer Supplies & Maintenance 5,732.00 5,732.00 3,572.88 62.332 2,159.12 Subtotal: 89,341.00 89,341.00 104.00 74,491.83 83.379 14,849.17 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 256.85 2,054.80 59.559 1,395.20 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 256.85 2,054.80 6.768 28,306.20 Program number: 193,391.00 193,391.00 778.55 140,339.11 72.568 53,051.89 Department number: Information Systems 193,391.00 193,391.00 778.55 140,339.11 72.568 53,051.89 . glbase_tbam rgonzale Trophy Club Entities Page 18 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-037-000 Salaries & Wages 31,512.00 135-50020-037-000 Retirement 4,412.00 135-50026-037-000 Medical Insurance 9,027.00 135-50027-037-000 Dental Insurance 549.00 135-50028-037-000 Vision Insurance 138.00 135-50029-037-000 Life Insurance & Other 228.00 135-50030-037-000 Social Security Taxes 1,954.00 135-50035-037-000 Medicare Taxes 457.00 46.85 46.85 46.85- 135-50040-037-000 Unemployment Taxes 189.00 135-50045-037-000 Workman's Compensation 861.00 861.00 861.00- 135-50060-037-000 Pre-emp Physicals/Testing 250.00 Subtotal: 49,577.00 46.85 907.85 907.85- 135-55100-037-000 Building Maint & Supplies 5,000.00 20,478.00 1,379.48 6.736 19,098.52 135-55120-037-000 Cleaning Services 25,000.00 1,678.51 13,088.80 52.355 11,911.20 Subtotal: 5,000.00 45,478.00 1,678.51 14,468.28 31.814 31,009.72 135-60020-037-000 Electricity 21,940.00 21,940.00 8,234.74 37.533 13,705.26 135-60025-037-000 Water 1,093.00 1,093.00 381.24 34.880 711.76 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 9,886.59 75.001 3,295.41 135-60055-037-000 Insurance 32,635.00 32,635.00 30,386.73 93.111 2,248.27 135-60360-037-000 Furniture/Equipment < $5000 2,500.00 4,750.00 4,750.00 Subtotal: 71,350.00 73,600.00 1,098.51 48,889.30 66.426 24,710.70 135-65095-037-000 Maintenance Supplies 2,205.00 2,205.00 876.65 39.757 1,328.35 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 80.03 8.003 919.97 Subtotal: 3,205.00 3,205.00 956.68 29.850 2,248.32 Program number: 129,132.00 122,283.00 2,823.87 65,222.11 53.337 57,060.89 Department number: Facilities Maintenance 129,132.00 122,283.00 2,823.87 65,222.11 53.337 57,060.89 . glbase_tbam rgonzale Trophy Club Entities Page 19 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 84,946.00 84,946.00 6,241.39 58,742.75 69.153 26,203.25 135-50010-038-000 Overtime 2,000.00 2,000.00 14.02 275.09 13.755 1,724.91 135-50016-038-000 Longevity 220.00 220.00 220.00 100.000 135-50020-038-000 Retirement 12,203.00 12,203.00 843.83 8,461.80 69.342 3,741.20 135-50026-038-000 Medical Insurance 12,321.00 12,321.00 851.13 8,025.47 65.137 4,295.53 135-50027-038-000 Dental Insurance 1,026.00 1,026.00 84.56 796.42 77.624 229.58 135-50028-038-000 Vision Insurance 260.00 260.00 19.93 187.84 72.246 72.16 135-50029-038-000 Life Insurance & Other 604.00 604.00 604.00 135-50030-038-000 Social Security Taxes 5,404.00 5,404.00 357.54 3,474.87 64.302 1,929.13 135-50035-038-000 Medicare Taxes 1,264.00 1,264.00 36.77 765.84 60.589 498.16 135-50040-038-000 Unemployment Taxes 473.00 473.00 1.19 191.18 40.419 281.82 135-50045-038-000 Workman's Compensation 211.00 211.00 235.00 111.374 24.00- 135-50060-038-000 Pre-emp Physicals/Testing 17.50 17.50 17.50- Subtotal: 120,932.00 120,932.00 8,467.86 81,393.76 67.305 39,538.24 135-55070-038-000 Independent Labor 800.00 800.00 800.00 135-55205-038-000 Utility Billing Contract 11,000.00 11,000.00 7,771.63 70.651 3,228.37 Subtotal: 11,800.00 11,800.00 7,771.63 65.861 4,028.37 135-60005-038-000 Telephone 100.00 100.00 55.02 55.020 44.98 135-60010-038-000 Communications/Pagers/Mobiles 472.00 472.00 289.68 61.373 182.32 135-60035-038-000 Postage 18,000.00 18,000.00 11,189.04 62.161 6,810.96 135-60040-038-000 Service Charges & Fees 18,000.00 29,340.00 1,306.76 18,168.30 61.923 11,171.70 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 225.00 28.125 575.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 22,500.00 22,500.00 25,071.20 111.428 2,571.20- 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 .01 .01 .005 199.99 Subtotal: 60,748.00 72,088.00 1,306.77 54,998.25 76.293 17,089.75 135-65085-038-000 Office Supplies 700.00 700.00 4.09 670.19 95.741 29.81 135-65105-038-000 Printing 3,250.00 3,250.00 3,250.00 Subtotal: 3,950.00 3,950.00 4.09 670.19 16.967 3,279.81 Program number: 197,430.00 208,770.00 9,778.72 144,833.83 69.375 63,936.17 Department number: Utility Billing 197,430.00 208,770.00 9,778.72 144,833.83 69.375 63,936.17 . glbase_tbam rgonzale Trophy Club Entities Page 20 11:37 07/06/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 55,000.00 70,000.00 10,319.50 67,155.04 95.936 2,844.96 135-55055-039-000 Auditing 20,200.00 20,200.00 20,200.00 100.000 135-55060-039-000 Appraisal 20,000.00 20,000.00 2,540.89 13,615.43 68.077 6,384.57 135-55065-039-000 Tax Admin Fees 3,629.00 3,629.00 2,470.09 68.065 1,158.91 Subtotal: 98,829.00 113,829.00 12,860.39 103,440.56 90.874 10,388.44 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,278.00 2,277.85 99.993 .15 Subtotal: 2,278.00 2,277.85 99.993 .15 Program number: 98,829.00 116,107.00 12,860.39 105,718.41 91.053 10,388.59 Department number: Non Departmental 98,829.00 116,107.00 12,860.39 105,718.41 91.053 10,388.59 Expenditures Subtotal ----------- 6,094,978.00 7,198,439.00 206,926.78 4,495,510.73 62.451 2,702,928.27 Fund number: 135 MUD 1 General Fund 161,000.00- 438,408.48- 470,768.62- 292.403 309,768.62 . glpdatb2 rgonzale Trophy Club Entities Page 14 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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 1246 06/01/2012 Property Taxes/Assessments (96,141.25) (36.41) (96,177.66) GL 1247 06/04/2012 Property Taxes/Assessments (64.77) (96,242.43) GL 1248 06/05/2012 Property Taxes/Assessments (68.80) (96,311.23) GL 1249 06/06/2012 Property Taxes/Assessments (32.84) (96,344.07) GL 1252 06/07/2012 Property Taxes/Assessments (20.40) (96,364.47) GL 1279 06/11/2012 Property Taxes/Assessments (1.35) (96,365.82) GL 1280 06/13/2012 Property Taxes/Assessments (.36) (96,366.18) GL 1281 06/14/2012 Property Taxes/Assessments (1.67) (96,367.85) GL 1282 06/15/2012 Property Taxes/Assessments (4.60) (96,372.45) GL 1283 06/18/2012 Property Taxes/Assessments (14.94) (96,387.39) GL 1284 06/19/2012 Property Taxes/Assessments (6.38) (96,393.77) GL 1285 06/20/2012 Property Taxes/Assessments (42.24) (96,436.01) GL 1286 06/22/2012 Property Taxes/Assessments (20.59) (96,456.60) GL 1287 06/25/2012 Property Taxes/Assessments (2.16) (96,458.76) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (317.51) (96,458.76) ** (97,495.00) Budgeted (1,036.24) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1249 06/06/2012 Property Taxes/Assessments 671.64 (.01) 671.63 GL 1251 06/06/2012 Property Taxes/Assessments (11.46) 660.17 GL 1172 06/14/2012 June A/P Refund Credit Balance FKA2 14.68 674.85 DENTON COUNTY TAX OFFICE 31537 AP 1310 06/28/2012 Property Taxes/Assessments (17.30) 657.55 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (14.09) 657.55 ** (451.00) Budgeted (1,108.55) Remaining ########## Account: 135-40015-000-000 Property Taxes/P & I 1246 06/01/2012 Property Taxes/Assessments (45.08) (3.05) (48.13) GL 1247 06/04/2012 Property Taxes/Assessments (7.85) (55.98) GL 1248 06/05/2012 Property Taxes/Assessments (10.41) (66.39) GL 1249 06/06/2012 Property Taxes/Assessments (4.94) (71.33) GL 1251 06/06/2012 Property Taxes/Assessments (8.82) (80.15) GL 1252 06/07/2012 Property Taxes/Assessments (3.06) (83.21) GL 1279 06/11/2012 Property Taxes/Assessments (.20) (83.41) GL 1280 06/13/2012 Property Taxes/Assessments (.06) (83.47) GL 1172 06/14/2012 June A/P Refund Credit Balance FKA2 (13.90) (97.37) DENTON COUNTY TAX OFFICE 31537 AP 1281 06/14/2012 Property Taxes/Assessments (.25) (97.62) GL 1283 06/18/2012 Property Taxes/Assessments (2.24) (99.86) GL 1285 06/20/2012 Property Taxes/Assessments (5.07) (104.93) GL . glpdatb2 rgonzale Trophy Club Entities Page 15 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1286 06/22/2012 Property Taxes/Assessments (45.08) (3.09) (108.02) GL 1287 06/25/2012 Property Taxes/Assessments (.32) (108.34) GL 1310 06/28/2012 Property Taxes/Assessments (5.19) (113.53) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (68.45) (113.53) ** (1,334.00) Budgeted (1,220.47) Remaining 9 % Used Account: 135-43215-000-000 Insurance Settlement (3,999.00) .00 (3,999.00) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (3,999.00) ** .00 Budgeted 3,999.00 Remaining 0 % Used Account: 135-47000-000-000 Water 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (869,694.67) (224,634.92) (1,094,329.59) UB _______________ Account: 135-47000-000-000 Water Totals: (224,634.92) (1,094,329.59) ** (1,990,800.00) Budgeted (896,470.41) Remaining 55 % Used Account: 135-47005-000-000 Sewer 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (623,033.91) (106,080.55) (729,114.46) UB _______________ Account: 135-47005-000-000 Sewer Totals: (106,080.55) (729,114.46) ** (1,325,000.00) Budgeted (595,885.54) Remaining 55 % Used Account: 135-47010-000-000 Commercial Water 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (371,765.63) (109,218.82) (480,984.45) UB _______________ Account: 135-47010-000-000 Commercial Water Totals: (109,218.82) (480,984.45) ** (825,000.00) Budgeted (344,015.55) Remaining 58 % Used Account: 135-47015-000-000 Commercial Sewer 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (176,709.76) (30,542.53) (207,252.29) UB _______________ Account: 135-47015-000-000 Commercial Sewer Totals: (30,542.53) (207,252.29) ** (360,000.00) Budgeted (152,747.71) Remaining 58 % Used Account: 135-47020-000-000 Standby . glpdatb2 rgonzale Trophy Club Entities Page 16 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (461.00) (56.35) (517.35) UB _______________ Account: 135-47020-000-000 Standby Totals: (56.35) (517.35) ** (775.00) Budgeted (257.65) Remaining 67 % Used Account: 135-47025-000-000 Penalties 1208 06/21/2012 UB 6/21/12 Penalties UB20120621-20120621 User: (31,614.80) (4,531.39) (36,146.19) UB 1261 06/29/2012 UB 6/29/12 Adjustments UB20120629-20120629 User: 150.48 (35,995.71) UB 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (150.48) (36,146.19) UB _______________ Account: 135-47025-000-000 Penalties Totals: (4,531.39) (36,146.19) ** (50,500.00) Budgeted (14,353.81) Remaining 72 % Used Account: 135-47030-000-000 Service Charges 1128 06/06/2012 UB 06/06/2012 Adjustments UB20120606-20120606 User: (8,432.38) (500.00) (8,932.38) UB 1170 06/12/2012 UB 6/12/12 Adjustment-NSF Fee UB20120612-20120612 User: (25.00) (8,957.38) UB 1223 06/13/2012 UB 6/13/12 Adjustment UB20120613-20120613 User: (25.00) (8,982.38) UB 1227 06/21/2012 UB 6/21/12 Adjustments UB20120621-20120621 User: (25.00) (9,007.38) UB 1230 06/21/2012 UB 6/21/12 Adjustments UB20120621-20120621 User: (50.00) (9,057.38) UB 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: 27.90 (9,029.48) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (597.10) (9,029.48) ** (17,500.00) Budgeted (8,470.52) Remaining 52 % Used Account: 135-47035-000-000 Plumbing Inspections 1274 06/22/2012 Permits 6/22/12 (1,300.00) (50.00) (1,350.00) GL 1275 06/26/2012 Permits 6/26/12 (50.00) (1,400.00) GL _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,400.00) ** (1,200.00) Budgeted 200.00 Remaining 117 % Used Account: 135-47045-000-000 Sewer Inspections 1274 06/22/2012 Permits 6/22/12 (3,900.00) (150.00) (4,050.00) GL 1275 06/26/2012 Permits 6/26/12 (150.00) (4,200.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (4,200.00) ** (4,500.00) Budgeted (300.00) Remaining 93 % Used Account: 135-47070-000-000 TCCC Effluent Charges . glpdatb2 rgonzale Trophy Club Entities Page 17 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1294 06/25/2012 Club Corp/April Effluent (8,212.62) (4,417.21) (12,629.83) GL 1297 06/27/2012 Club Corp/May Effluent (17,471.16) (30,100.99) GL _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (21,888.37) (30,100.99) ** (57,500.00) Budgeted (27,399.01) Remaining 52 % Used Account: 135-47270-000-000 Fire Line .00 .00 _______________ Account: 135-47270-000-000 Fire Line Totals: .00 .00 ** (5,000.00) Budgeted (5,000.00) Remaining 0 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 1122 06/01/2012 UB 06/01/2012 Adjustments UB20120601-20120601 User: (24,084.31) (300.00) (24,384.31) UB 1175 06/14/2012 UB 06/14/2012 Credit Adj UB20120614-20120614 User: 125.87 (24,258.44) UB 1224 06/22/2012 UB 06/22/2012 Adjustments UB20120622-20120622 User: (100.00) (24,358.44) UB 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (3,476.09) (27,834.53) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (3,750.22) (27,834.53) ** (41,595.00) Budgeted (13,760.47) Remaining 67 % Used Account: 135-47405-000-000 Out of District Sewer 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (7,283.44) (1,084.15) (8,367.59) UB _______________ Account: 135-47405-000-000 Out of District Sewer Totals: (1,084.15) (8,367.59) ** (11,807.00) Budgeted (3,439.41) Remaining 71 % Used Account: 135-47410-000-000 Out of Dist/Portable Penalties 1175 06/14/2012 UB 06/14/2012 Credit Adj UB20120614-20120614 User: 105.18 (125.87) (20.69) UB 1208 06/21/2012 UB 6/21/12 Penalties UB20120621-20120621 User: (13.34) (34.03) UB _______________ Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: (139.21) (34.03) ** (300.00) Budgeted (265.97) Remaining 11 % Used Account: 135-47600-000-000 PID #1 Water 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (275,806.03) (74,733.64) (350,539.67) UB _______________ Account: 135-47600-000-000 PID #1 Water Totals: (74,733.64) (350,539.67) ** (425,000.00) Budgeted (74,460.33) Remaining 82 % Used . glpdatb2 rgonzale Trophy Club Entities Page 18 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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-47605-000-000 PID #1 Sewer 1262 06/30/2012 UB 6/30/12 Billing UB20120630-20120630 User: (151,653.08) (27,824.42) (179,477.50) UB _______________ Account: 135-47605-000-000 PID #1 Sewer Totals: (27,824.42) (179,477.50) ** (185,000.00) Budgeted (5,522.50) Remaining 97 % Used Account: 135-48005-000-000 Utility Fees 1269 06/06/2012 Permits 6/6/12 (469,980.00) (11,500.00) (481,480.00) GL 1270 06/13/2012 Permits 6/13/12 (6,900.00) (488,380.00) GL 1271 06/14/2012 Permits 6/14/12 (4,600.00) (492,980.00) GL 1272 06/15/2012 Permits 6/15/12 (2,300.00) (495,280.00) GL 1273 06/21/2012 Permits 6/21/12 (2,300.00) (497,580.00) GL 1275 06/26/2012 Permits 6/26/12 (2,300.00) (499,880.00) GL 1276 06/27/2012 Permits 6/27/12 (2,300.00) (502,180.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (32,200.00) (502,180.00) ** (161,000.00) Budgeted 341,180.00 Remaining 312 % Used Account: 135-49005-000-000 Loan Proceeds (1,100,000.00) .00 (1,100,000.00) _______________ Account: 135-49005-000-000 Loan Proceeds Totals: .00 (1,100,000.00) ** (1,100,000.00) Budgeted .00 Remaining 100 % Used Account: 135-49010-000-000 Interest Income 1302 06/30/2012 June Bank Interest (3,384.19) (169.80) (3,553.99) GL 1302 06/30/2012 June Bank Interest (399.67) (3,953.66) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (569.47) (3,953.66) ** (4,500.00) Budgeted (546.34) Remaining 88 % Used Account: 135-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 135-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (308,000.00) Budgeted (308,000.00) Remaining 0 % Used Account: 135-49016-000-000 Cell Tower Revenue . glpdatb2 rgonzale Trophy Club Entities Page 19 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1289 06/05/2012 ATT Cell Tower Lease (6,776.00) (847.00) (7,623.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (7,623.00) ** (10,164.00) Budgeted (2,541.00) Remaining 75 % Used Account: 135-49018-000-000 Building Rent Income 1288 06/05/2012 Town Payment Maint Barn rent/June (4,666.64) (583.33) (5,249.97) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,249.97) ** (7,000.00) Budgeted (1,750.03) Remaining 75 % Used Account: 135-49025-000-000 Auction Sales (4,305.00) .00 (4,305.00) _______________ Account: 135-49025-000-000 Auction Sales Totals: .00 (4,305.00) ** .00 Budgeted 4,305.00 Remaining 0 % Used Account: 135-49030-000-000 Vending Revenue 1291 06/20/2012 Vending/Collection Barn & WWTP (32.50) (378.00) (410.50) GL 1298 06/28/2012 Vending/Admin bldg (28.75) (439.25) GL 1312 06/30/2012 Bank Rec adjustments .01 (439.24) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (406.74) (439.24) ** (600.00) Budgeted (160.76) Remaining 73 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (265,707.00) Budgeted (265,707.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (26,911.00) Budgeted (26,911.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement . glpdatb2 rgonzale Trophy Club Entities Page 20 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1269 06/06/2012 Permits 6/6/12 (73,072.80) (1,460.00) (74,532.80) GL 1270 06/13/2012 Permits 6/13/12 (876.00) (75,408.80) GL 1271 06/14/2012 Permits 6/14/12 (584.00) (75,992.80) GL 1272 06/15/2012 Permits 6/15/12 (292.00) (76,284.80) GL 1273 06/21/2012 Permits 6/21/12 (292.00) (76,576.80) GL 1274 06/22/2012 Permits 6/22/12 (292.00) (76,868.80) GL 1275 06/26/2012 Permits 6/26/12 (584.00) (77,452.80) GL 1276 06/27/2012 Permits 6/27/12 (292.00) (77,744.80) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,672.00) (77,744.80) ** (64,000.00) Budgeted 13,744.80 Remaining 121 % Used Account: 135-49900-000-000 Miscellaneous Income 1190 06/15/2012 UB 06/15/2012 Adjustment UB20120615-20120615 User: (5,243.82) (100.00) (5,343.82) UB 1272 06/15/2012 Permits 6/15/12 (75.00) (5,418.82) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (175.00) (5,418.82) ** (10,000.00) Budgeted (4,581.18) Remaining 54 % Used Account: 135-49905-000-000 Gas Well Revenue (123.00) .00 (123.00) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (123.00) ** (800.00) Budgeted (677.00) Remaining 15 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4,966,279.35) ** (7,359,439.00) Budgeted (2,393,159.65) Remaining 67 % Used . glpdatb2 rgonzale Trophy Club Entities Page 21 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 1303 06/08/2012 6/8/12 Payroll 100,352.38 6,517.10 106,869.48 GL 1304 06/22/2012 6/22/12 Payroll 6,336.64 113,206.12 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 12,853.74 113,206.12 ** 160,600.00 Budgeted 47,393.88 Remaining 70 % Used Account: 135-50010-010-000 Overtime 1303 06/08/2012 6/8/12 Payroll 11,225.81 695.94 11,921.75 GL 1304 06/22/2012 6/22/12 Payroll 408.71 12,330.46 GL 1304 06/22/2012 6/22/12 Payroll 80.00 12,410.46 GL _______________ Account: 135-50010-010-000 Overtime Totals: 1,184.65 12,410.46 ** 13,250.00 Budgeted 839.54 Remaining 94 % Used Account: 135-50016-010-000 Longevity 2,620.00 .00 2,620.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,620.00 ** 2,620.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1304 06/22/2012 6/22/12 Payroll 900.00 150.00 1,050.00 GL _______________ Account: 135-50017-010-000 Certification Totals: 150.00 1,050.00 ** 1,800.00 Budgeted 750.00 Remaining 58 % Used Account: 135-50020-010-000 Retirement 1303 06/08/2012 6/8/12 Payroll 16,502.43 982.96 17,485.39 GL 1304 06/22/2012 6/22/12 Payroll 964.00 18,449.39 GL _______________ Account: 135-50020-010-000 Retirement Totals: 1,946.96 18,449.39 ** 25,508.00 Budgeted 7,058.61 Remaining 72 % Used Account: 135-50026-010-000 Medical Insurance 1303 06/08/2012 6/8/12 Payroll 13,800.89 821.40 14,622.29 GL 1304 06/22/2012 6/22/12 Payroll 821.40 15,443.69 GL . glpdatb2 rgonzale Trophy Club Entities Page 22 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-50026-010-000 Medical Insurance Totals: 1,642.80 15,443.69 ** 22,607.00 Budgeted 7,163.31 Remaining 68 % Used Account: 135-50027-010-000 Dental Insurance 1303 06/08/2012 6/8/12 Payroll 1,009.14 62.60 1,071.74 GL 1304 06/22/2012 6/22/12 Payroll 62.60 1,134.34 GL _______________ Account: 135-50027-010-000 Dental Insurance Totals: 125.20 1,134.34 ** 2,169.00 Budgeted 1,034.66 Remaining 52 % Used Account: 135-50028-010-000 Vision Insurance 1303 06/08/2012 6/8/12 Payroll 245.09 15.88 260.97 GL 1304 06/22/2012 6/22/12 Payroll 15.88 276.85 GL _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 276.85 ** 576.00 Budgeted 299.15 Remaining 48 % Used Account: 135-50029-010-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: .00 .00 ** 1,161.00 Budgeted 1,161.00 Remaining 0 % Used Account: 135-50030-010-000 Social Security Taxes 1303 06/08/2012 6/8/12 Payroll 6,996.56 428.76 7,425.32 GL 1304 06/22/2012 6/22/12 Payroll 420.25 7,845.57 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 849.01 7,845.57 ** 12,000.00 Budgeted 4,154.43 Remaining 65 % Used Account: 135-50035-010-000 Medicare Taxes 1303 06/08/2012 6/8/12 Payroll 1,636.28 100.27 1,736.55 GL 1304 06/22/2012 6/22/12 Payroll 98.29 1,834.84 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 198.56 1,834.84 ** 2,700.00 Budgeted 865.16 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club Entities Page 23 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 288.00 .00 288.00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 288.00 ** 945.00 Budgeted 657.00 Remaining 30 % Used Account: 135-50045-010-000 Workman's Compensation 5,581.00 .00 5,581.00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 5,581.00 ** 5,581.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 118.64 .00 118.64 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 118.64 ** 350.00 Budgeted 231.36 Remaining 34 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-010-000 Independent Labor .00 .00 _______________ Account: 135-55070-010-000 Independent Labor Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club Entities Page 24 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 14,563.71 .00 14,563.71 _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: .00 14,563.71 ** 29,500.00 Budgeted 14,936.29 Remaining 49 % Used Account: 135-55090-010-000 Vehicle Maintenance 1140 06/08/2012 June A/P Fuel Gauge Sender, Fuel Sendin 3,085.73 590.60 3,676.33 WATSONS AUTOMOTIVE 31532 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 590.60 3,676.33 ** 3,380.00 Budgeted (296.33) Remaining 109 % Used Account: 135-55100-010-000 Building Maint & Supplies 471.85 .00 471.85 _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: .00 471.85 ** 750.00 Budgeted 278.15 Remaining 63 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 464.49 .00 464.49 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 464.49 ** 2,900.00 Budgeted 2,435.51 Remaining 16 % Used Account: 135-55135-010-000 Lab Analysis 1,725.00 .00 1,725.00 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 1,725.00 ** 4,500.00 Budgeted 2,775.00 Remaining 38 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1,362.36 .00 1,362.36 _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: .00 1,362.36 ** 1,599.00 Budgeted 236.64 Remaining 85 % Used Account: 135-60020-010-000 Electricity 1235 06/27/2012 June A/P Electricity 5/15-6/14 33,861.10 12,465.61 46,326.71 HUDSON ENERGY 31573 AP . glpdatb2 rgonzale Trophy Club Entities Page 25 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1235 06/27/2012 June A/P Electricity 5/15-6/13 BNHS Ele 33,861.10 148.11 46,474.82 HUDSON ENERGY 31573 AP 1235 06/27/2012 June A/P Electricity 5/15-6/14 1,501.48 47,976.30 HUDSON ENERGY 31573 AP _______________ Account: 135-60020-010-000 Electricity Totals: 14,115.20 47,976.30 ** 127,500.00 Budgeted 79,523.70 Remaining 38 % Used Account: 135-60035-010-000 Postage 1196 06/19/2012 June A/P Mailing Water Quality Report 29.05 658.35 687.40 U.S. POSTAL SERVICE 31568 AP _______________ Account: 135-60035-010-000 Postage Totals: 658.35 687.40 ** 500.00 Budgeted (187.40) Remaining 137 % Used Account: 135-60050-010-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: .00 .00 ** 4,200.00 Budgeted 4,200.00 Remaining 0 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 85.00 .00 85.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 85.00 ** 50.00 Budgeted (35.00) Remaining 170 % Used Account: 135-60070-010-000 Dues & Memberships 111.00 .00 111.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 111.00 ** 150.00 Budgeted 39.00 Remaining 74 % Used Account: 135-60080-010-000 Schools & Training 1,082.00 .00 1,082.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,082.00 ** 2,800.00 Budgeted 1,718.00 Remaining 39 % Used Account: 135-60090-010-000 Safety Program . glpdatb2 rgonzale Trophy Club Entities Page 26 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 1304 06/22/2012 6/22/12 Payroll 1,010.71 24.43 1,035.14 GL _______________ Account: 135-60100-010-000 Travel & per diem Totals: 24.43 1,035.14 ** 3,200.00 Budgeted 2,164.86 Remaining 32 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60135-010-000 Annual Permit Fee 7,965.75 .00 7,965.75 _______________ Account: 135-60135-010-000 Annual Permit Fee Totals: .00 7,965.75 ** 6,600.00 Budgeted (1,365.75) Remaining 121 % Used Account: 135-60150-010-000 Wholesale Water 1235 06/27/2012 June A/P 790,899.28 187,569.78 978,469.06 CITY OF FORT WORTH 31572 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 187,569.78 978,469.06 ** 1,720,000.00 Budgeted 741,530.94 Remaining 57 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 380.38 .00 380.38 . glpdatb2 rgonzale Trophy Club Entities Page 27 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-60280-010-000 Property Maintenance Totals: .00 380.38 ** 4,200.00 Budgeted 3,819.62 Remaining 9 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 299.99 .00 299.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 1,500.00 Budgeted 1,200.01 Remaining 20 % Used Account: 135-65005-010-000 Fuel & Lube 1240 06/27/2012 June A/P Fuel purchases 9,648.08 50.54 9,698.62 VALERO MARKETING & SUPPLY 31582 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 50.54 9,698.62 ** 15,216.00 Budgeted 5,517.38 Remaining 64 % Used Account: 135-65010-010-000 Uniforms 1,400.99 .00 1,400.99 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,400.99 ** 3,690.00 Budgeted 2,289.01 Remaining 38 % Used Account: 135-65030-010-000 Chemicals 2,858.11 .00 2,858.11 _______________ Account: 135-65030-010-000 Chemicals Totals: .00 2,858.11 ** 6,200.00 Budgeted 3,341.89 Remaining 46 % Used Account: 135-65035-010-000 Small Tools 203.00 .00 203.00 . glpdatb2 rgonzale Trophy Club Entities Page 28 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-010-000 Small Tools Totals: .00 203.00 ** 2,500.00 Budgeted 2,297.00 Remaining 8 % Used Account: 135-65040-010-000 Safety Equipment 347.00 .00 347.00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 347.00 ** 2,500.00 Budgeted 2,153.00 Remaining 14 % Used Account: 135-65050-010-000 Meter Expense 92,842.07 .00 92,842.07 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 92,842.07 ** 94,000.00 Budgeted 1,157.93 Remaining 99 % Used Account: 135-65055-010-000 Hardware .00 .00 _______________ Account: 135-65055-010-000 Hardware Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65085-010-000 Office Supplies 30.00 .00 30.00 _______________ Account: 135-65085-010-000 Office Supplies Totals: .00 30.00 ** .00 Budgeted (30.00) Remaining 0 % Used Account: 135-65095-010-000 Maintenance Supplies 11,678.22 .00 11,678.22 _______________ Account: 135-65095-010-000 Maintenance Supplies Totals: .00 11,678.22 ** 32,000.00 Budgeted 20,321.78 Remaining 36 % Used Account: 135-65100-010-000 Copies .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 29 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-65100-010-000 Copies Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 135-65105-010-000 Printing 58.50 .00 58.50 _______________ Account: 135-65105-010-000 Printing Totals: .00 58.50 ** 150.00 Budgeted 91.50 Remaining 39 % Used Account: 135-69005-010-000 Capital Expenses 1268 06/01/2012 May Retainage/Round About App 1 1,400,398.69 3,419.90 1,403,818.59 GL 1268 06/01/2012 May Retainage/Round About App 2 2,406.08 1,406,224.67 GL 1288 06/05/2012 Town Payment Roundabout reimb (187,254.00) 1,218,970.67 GL 1140 06/08/2012 June A/P Balance due/VFD for new water 11,100.00 1,230,070.67 DHS AUTOMATION, INC 31509 AP 1266 06/30/2012 June A/P Round About App 2 45,715.43 1,275,786.10 CPS CIVIL, LLC 31586 AP _______________ Account: 135-69005-010-000 Capital Expenses Totals: (124,612.59) 1,275,786.10 ** 1,455,600.00 Budgeted 179,813.90 Remaining 88 % Used Account: 135-69008-010-000 Short Term Debt Payments .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt Payments Totals: .00 .00 ** 421,050.00 Budgeted 421,050.00 Remaining 0 % Used Account: 135-69035-010-000 Vehicles 1238 06/27/2012 Recode JE1169 on May financial P/M, Oil change 30,263.41 (49.72) 30,213.69 GL _______________ Account: 135-69035-010-000 Vehicles Totals: (49.72) 30,213.69 ** 27,000.00 Budgeted (3,213.69) Remaining 112 % 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 . glpdatb2 rgonzale Trophy Club Entities Page 30 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 24,000.00 Budgeted 24,000.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 108,817.00 Budgeted 8,000.46 Remaining 93 % Used Account: 135-69295-010-000 Unexpected Maintenance .00 .00 _______________ Account: 135-69295-010-000 Unexpected Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-69305-010-000 Capital Leases 10,145.26 .00 10,145.26 _______________ Account: 135-69305-010-000 Capital Leases Totals: .00 10,145.26 ** 11,490.00 Budgeted 1,344.74 Remaining 88 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,776,692.76 ** 4,406,909.00 Budgeted 1,630,216.24 Remaining 63 % Used . glpdatb2 rgonzale Trophy Club Entities Page 31 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 1303 06/08/2012 6/8/12 Payroll 129,744.20 4,925.32 134,669.52 GL 1304 06/22/2012 6/22/12 Payroll 6,928.78 141,598.30 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 11,854.10 141,598.30 ** 182,147.00 Budgeted 40,548.70 Remaining 78 % Used Account: 135-50010-020-000 Overtime 1303 06/08/2012 6/8/12 Payroll 8,239.95 543.71 8,783.66 GL 1304 06/22/2012 6/22/12 Payroll 321.18 9,104.84 GL 1304 06/22/2012 6/22/12 Payroll 80.00 9,184.84 GL _______________ Account: 135-50010-020-000 Overtime Totals: 944.89 9,184.84 ** 10,166.00 Budgeted 981.16 Remaining 90 % Used Account: 135-50016-020-000 Longevity 3,975.00 .00 3,975.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 3,975.00 ** 3,976.00 Budgeted 1.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1304 06/22/2012 6/22/12 Payroll 825.00 125.00 950.00 GL _______________ Account: 135-50017-020-000 Certification Totals: 125.00 950.00 ** 2,400.00 Budgeted 1,450.00 Remaining 40 % Used Account: 135-50020-020-000 Retirement 1303 06/08/2012 6/8/12 Payroll 20,406.37 742.94 21,149.31 GL 1304 06/22/2012 6/22/12 Payroll 1,030.27 22,179.58 GL _______________ Account: 135-50020-020-000 Retirement Totals: 1,773.21 22,179.58 ** 27,816.00 Budgeted 5,636.42 Remaining 80 % Used Account: 135-50026-020-000 Medical Insurance 1303 06/08/2012 6/8/12 Payroll 17,661.80 867.35 18,529.15 GL 1304 06/22/2012 6/22/12 Payroll 867.34 19,396.49 GL . glpdatb2 rgonzale Trophy Club Entities Page 32 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-50026-020-000 Medical Insurance Totals: 1,734.69 19,396.49 ** 30,805.00 Budgeted 11,408.51 Remaining 63 % Used Account: 135-50027-020-000 Dental Insurance 1303 06/08/2012 6/8/12 Payroll 1,351.78 68.47 1,420.25 GL 1304 06/22/2012 6/22/12 Payroll 68.47 1,488.72 GL _______________ Account: 135-50027-020-000 Dental Insurance Totals: 136.94 1,488.72 ** 1,981.00 Budgeted 492.28 Remaining 75 % Used Account: 135-50028-020-000 Vision Insurance 1303 06/08/2012 6/8/12 Payroll 336.14 17.22 353.36 GL 1304 06/22/2012 6/22/12 Payroll 17.22 370.58 GL _______________ Account: 135-50028-020-000 Vision Insurance Totals: 34.44 370.58 ** 552.00 Budgeted 181.42 Remaining 67 % Used Account: 135-50029-020-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: .00 .00 ** 884.00 Budgeted 884.00 Remaining 0 % Used Account: 135-50030-020-000 Social Security Taxes 1303 06/08/2012 6/8/12 Payroll 8,226.06 286.80 8,512.86 GL 1304 06/22/2012 6/22/12 Payroll 415.59 8,928.45 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 702.39 8,928.45 ** 11,293.00 Budgeted 2,364.55 Remaining 79 % Used Account: 135-50035-020-000 Medicare Taxes 1303 06/08/2012 6/8/12 Payroll 1,923.79 67.07 1,990.86 GL 1304 06/22/2012 6/22/12 Payroll 97.19 2,088.05 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 164.26 2,088.05 ** 2,645.00 Budgeted 556.95 Remaining 79 % Used . glpdatb2 rgonzale Trophy Club Entities Page 33 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 1304 06/22/2012 6/22/12 Payroll 315.84 17.37 333.21 GL _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 17.37 333.21 ** 567.00 Budgeted 233.79 Remaining 59 % Used Account: 135-50045-020-000 Workman's Compensation 2,685.00 .00 2,685.00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 2,685.00 ** 2,685.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1235 06/27/2012 June A/P Pre-employment testing/Schliel 30.45 85.00 115.45 CARENOW CORPORATE 31571 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 85.00 115.45 ** 200.00 Budgeted 84.55 Remaining 58 % Used Account: 135-50070-020-000 Employee Relations 64.45 .00 64.45 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 64.45 ** 350.00 Budgeted 285.55 Remaining 18 % Used Account: 135-55070-020-000 Independent Labor 13,090.67 .00 13,090.67 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 13,090.67 ** 15,000.00 Budgeted 1,909.33 Remaining 87 % Used Account: 135-55080-020-000 Maintenance & Repairs 37,019.23 .00 37,019.23 _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: .00 37,019.23 ** 40,000.00 Budgeted 2,980.77 Remaining 93 % Used Account: 135-55090-020-000 Vehicle Maintenance . glpdatb2 rgonzale Trophy Club Entities Page 34 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 234.70 .00 234.70 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 234.70 ** 4,998.00 Budgeted 4,763.30 Remaining 5 % Used Account: 135-55100-020-000 Building Maint & Supplies 116.00 .00 116.00 _______________ Account: 135-55100-020-000 Building Maint & Supplies Totals: .00 116.00 ** 1,400.00 Budgeted 1,284.00 Remaining 8 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 316.73 .00 316.73 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 316.73 ** 2,950.00 Budgeted 2,633.27 Remaining 11 % Used Account: 135-55125-020-000 Dumpster Services 28,487.50 .00 28,487.50 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 28,487.50 ** 35,000.00 Budgeted 6,512.50 Remaining 81 % Used Account: 135-55135-020-000 Lab Analysis 1140 06/08/2012 June A/P Weekly Monitoring 13,183.37 1,351.25 14,534.62 TALEM, INC 31523 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,351.25 14,534.62 ** 35,000.00 Budgeted 20,465.38 Remaining 42 % Used Account: 135-60005-020-000 Telephone 18.72 .00 18.72 _______________ Account: 135-60005-020-000 Telephone Totals: .00 18.72 ** 100.00 Budgeted 81.28 Remaining 19 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1,727.60 .00 1,727.60 . glpdatb2 rgonzale Trophy Club Entities Page 35 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-60010-020-000 Communications/Pagers/Mobiles Totals: .00 1,727.60 ** 3,000.00 Budgeted 1,272.40 Remaining 58 % Used Account: 135-60020-020-000 Electricity 1235 06/27/2012 June A/P Electricity 5/15-6/14 44,210.01 10,204.61 54,414.62 HUDSON ENERGY 31573 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,204.61 54,414.62 ** 161,160.00 Budgeted 106,745.38 Remaining 34 % Used Account: 135-60025-020-000 Water 1,647.06 .00 1,647.06 _______________ Account: 135-60025-020-000 Water Totals: .00 1,647.06 ** 1,900.00 Budgeted 252.94 Remaining 87 % Used Account: 135-60035-020-000 Postage .00 .00 _______________ Account: 135-60035-020-000 Postage Totals: .00 .00 ** 120.00 Budgeted 120.00 Remaining 0 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 438.17 .00 438.17 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 438.17 ** 500.00 Budgeted 61.83 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training 111.00 .00 111.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 111.00 ** 1,320.00 Budgeted 1,209.00 Remaining 8 % Used Account: 135-60090-020-000 Safety Program 116.45 .00 116.45 . glpdatb2 rgonzale Trophy Club Entities Page 36 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-60090-020-000 Safety Program Totals: .00 116.45 ** 200.00 Budgeted 83.55 Remaining 58 % Used Account: 135-60100-020-000 Travel & per diem 1304 06/22/2012 6/22/12 Payroll 1,292.60 46.62 1,339.22 GL _______________ Account: 135-60100-020-000 Travel & per diem Totals: 46.62 1,339.22 ** 1,750.00 Budgeted 410.78 Remaining 77 % Used Account: 135-60105-020-000 Rent/Lease Equipment 901.30 .00 901.30 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 901.30 ** 200.00 Budgeted (701.30) Remaining 451 % Used Account: 135-60125-020-000 Advertising 987.36 .00 987.36 _______________ Account: 135-60125-020-000 Advertising Totals: .00 987.36 ** 1,500.00 Budgeted 512.64 Remaining 66 % Used Account: 135-60135-020-000 Annual Permit Fee 7,432.50 .00 7,432.50 _______________ Account: 135-60135-020-000 Annual Permit Fee Totals: .00 7,432.50 ** 7,500.00 Budgeted 67.50 Remaining 99 % Used Account: 135-60245-020-000 Miscellaneous Expenses 76.02 .00 76.02 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 76.02 ** 525.00 Budgeted 448.98 Remaining 14 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 37 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 1240 06/27/2012 June A/P Fuel purchases 3,056.19 133.82 3,190.01 VALERO MARKETING & SUPPLY 31582 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 133.82 3,190.01 ** 6,875.00 Budgeted 3,684.99 Remaining 46 % Used Account: 135-65010-020-000 Uniforms 1,118.93 .00 1,118.93 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,118.93 ** 3,140.00 Budgeted 2,021.07 Remaining 36 % Used Account: 135-65030-020-000 Chemicals 6,586.47 .00 6,586.47 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 6,586.47 ** 13,180.00 Budgeted 6,593.53 Remaining 50 % Used Account: 135-65035-020-000 Small Tools 5.94 .00 5.94 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 5.94 ** 1,260.00 Budgeted 1,254.06 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 22.75 .00 22.75 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 22.75 ** 925.00 Budgeted 902.25 Remaining 2 % Used Account: 135-65045-020-000 Lab Supplies 4,249.03 .00 4,249.03 . glpdatb2 rgonzale Trophy Club Entities Page 38 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-65045-020-000 Lab Supplies Totals: .00 4,249.03 ** 12,000.00 Budgeted 7,750.97 Remaining 35 % Used Account: 135-65055-020-000 Hardware .00 .00 _______________ Account: 135-65055-020-000 Hardware Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65085-020-000 Office Supplies 1235 06/27/2012 June A/P Office supplies 99.54 165.15 264.69 OFFICE DEPOT, INC 31575 AP 1242 06/27/2012 June A/P Office Supplies 97.84 362.53 OFFICE DEPOT, INC 31585 AP _______________ Account: 135-65085-020-000 Office Supplies Totals: 262.99 362.53 ** 400.00 Budgeted 37.47 Remaining 91 % Used Account: 135-65095-020-000 Maintenance Supplies 2,250.67 .00 2,250.67 _______________ Account: 135-65095-020-000 Maintenance Supplies Totals: .00 2,250.67 ** 8,860.00 Budgeted 6,609.33 Remaining 25 % Used Account: 135-65115-020-000 Other Consumables .00 .00 _______________ Account: 135-65115-020-000 Other Consumables Totals: .00 .00 ** 110.00 Budgeted 110.00 Remaining 0 % Used Account: 135-69005-020-000 Capital Expenses 1140 06/08/2012 June A/P Sanitary Sewer Crossing 67,412.56 6,050.00 73,462.56 DELTATEK ENGINEERING 31507 AP _______________ Account: 135-69005-020-000 Capital Expenses Totals: 6,050.00 73,462.56 ** 111,021.00 Budgeted 37,558.44 Remaining 66 % Used Account: 135-69008-020-000 Short Term Debt Payments .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 39 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-69008-020-000 Short Term Debt Payments Totals: .00 .00 ** 118,689.00 Budgeted 118,689.00 Remaining 0 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 56,000.00 Budgeted 56,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 467,616.48 ** 926,100.00 Budgeted 458,483.52 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club Entities Page 40 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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 1303 06/08/2012 6/8/12 Payroll 89,963.56 5,679.53 95,643.09 GL 1304 06/22/2012 6/22/12 Payroll 5,491.92 101,135.01 GL _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,171.45 101,135.01 ** 145,481.00 Budgeted 44,345.99 Remaining 70 % Used Account: 135-50010-021-000 Overtime 1303 06/08/2012 6/8/12 Payroll 5,909.83 369.47 6,279.30 GL 1304 06/22/2012 6/22/12 Payroll 488.59 6,767.89 GL 1304 06/22/2012 6/22/12 Payroll 160.00 6,927.89 GL _______________ Account: 135-50010-021-000 Overtime Totals: 1,018.06 6,927.89 ** 7,297.00 Budgeted 369.11 Remaining 95 % Used Account: 135-50016-021-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 1304 06/22/2012 6/22/12 Payroll 750.00 100.00 850.00 GL _______________ Account: 135-50017-021-000 Certification Totals: 100.00 850.00 ** 1,500.00 Budgeted 650.00 Remaining 57 % Used Account: 135-50020-021-000 Retirement 1303 06/08/2012 6/8/12 Payroll 14,381.01 833.28 15,214.29 GL 1304 06/22/2012 6/22/12 Payroll 862.43 16,076.72 GL _______________ Account: 135-50020-021-000 Retirement Totals: 1,695.71 16,076.72 ** 21,074.00 Budgeted 4,997.28 Remaining 76 % Used Account: 135-50026-021-000 Medical Insurance 1303 06/08/2012 6/8/12 Payroll 12,984.72 851.34 13,836.06 GL 1304 06/22/2012 6/22/12 Payroll 851.34 14,687.40 GL . glpdatb2 rgonzale Trophy Club Entities Page 41 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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-50026-021-000 Medical Insurance Totals: 1,702.68 14,687.40 ** 22,983.00 Budgeted 8,295.60 Remaining 64 % Used Account: 135-50027-021-000 Dental Insurance 1303 06/08/2012 6/8/12 Payroll 897.55 58.69 956.24 GL 1304 06/22/2012 6/22/12 Payroll 58.69 1,014.93 GL _______________ Account: 135-50027-021-000 Dental Insurance Totals: 117.38 1,014.93 ** 1,533.00 Budgeted 518.07 Remaining 66 % Used Account: 135-50028-021-000 Vision Insurance 1303 06/08/2012 6/8/12 Payroll 228.03 14.86 242.89 GL 1304 06/22/2012 6/22/12 Payroll 14.86 257.75 GL _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 257.75 ** 357.00 Budgeted 99.25 Remaining 72 % Used Account: 135-50029-021-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: .00 .00 ** 978.00 Budgeted 978.00 Remaining 0 % Used Account: 135-50030-021-000 Social Security Taxes 1303 06/08/2012 6/8/12 Payroll 5,955.15 344.35 6,299.50 GL 1304 06/22/2012 6/22/12 Payroll 357.43 6,656.93 GL _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 701.78 6,656.93 ** 9,785.00 Budgeted 3,128.07 Remaining 68 % Used Account: 135-50035-021-000 Medicare Taxes 1303 06/08/2012 6/8/12 Payroll 1,392.74 80.53 1,473.27 GL 1304 06/22/2012 6/22/12 Payroll 83.60 1,556.87 GL _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 164.13 1,556.87 ** 2,288.00 Budgeted 731.13 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club Entities Page 42 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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 216.00 .00 216.00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 216.00 ** 567.00 Budgeted 351.00 Remaining 38 % Used Account: 135-50045-021-000 Workman's Compensation 3,056.00 .00 3,056.00 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 3,056.00 ** 3,056.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-021-000 Employee Relations 64.43 .00 64.43 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 64.43 ** 250.00 Budgeted 185.57 Remaining 26 % 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-55070-021-000 Independent Labor .00 .00 _______________ Account: 135-55070-021-000 Independent Labor Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 4,157.53 .00 4,157.53 _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: .00 4,157.53 ** 23,700.00 Budgeted 19,542.47 Remaining 18 % Used Account: 135-55090-021-000 Vehicle Maintenance . glpdatb2 rgonzale Trophy Club Entities Page 43 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1238 06/27/2012 Recode JE1169 on May financial P/M, Oil change 209.50 49.72 259.22 GL _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 49.72 259.22 ** 1,943.00 Budgeted 1,683.78 Remaining 13 % Used Account: 135-55100-021-000 Building Maint & Supplies .00 .00 _______________ Account: 135-55100-021-000 Building Maint & Supplies Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60005-021-000 Telephone 22.37 .00 22.37 _______________ Account: 135-60005-021-000 Telephone Totals: .00 22.37 ** 50.00 Budgeted 27.63 Remaining 45 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 2,160.42 .00 2,160.42 _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: .00 2,160.42 ** 2,796.00 Budgeted 635.58 Remaining 77 % Used Account: 135-60020-021-000 Electricity 1235 06/27/2012 June A/P Electricity 5/15-6/14 7,219.52 687.49 7,907.01 HUDSON ENERGY 31573 AP 1235 06/27/2012 June A/P Electricity 5/15-6/14 230.56 8,137.57 HUDSON ENERGY 31573 AP 1235 06/27/2012 June A/P Electricity 5/11-6/13 53.46 8,191.03 HUDSON ENERGY 31573 AP _______________ Account: 135-60020-021-000 Electricity Totals: 971.51 8,191.03 ** 21,550.00 Budgeted 13,358.97 Remaining 38 % Used Account: 135-60025-021-000 Water .00 .00 _______________ Account: 135-60025-021-000 Water Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60035-021-000 Postage . glpdatb2 rgonzale Trophy Club Entities Page 44 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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-60035-021-000 Postage Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 255.00 Budgeted 255.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training 111.00 .00 111.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 111.00 ** 2,818.00 Budgeted 2,707.00 Remaining 4 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 1304 06/22/2012 6/22/12 Payroll 464.57 35.52 500.09 GL _______________ Account: 135-60100-021-000 Travel & per diem Totals: 35.52 500.09 ** 1,500.00 Budgeted 999.91 Remaining 33 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 76,098.00 Budgeted 76,098.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 45 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-60280-021-000 Property Maintenance .00 .00 _______________ Account: 135-60280-021-000 Property Maintenance Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 6,417.27 .00 6,417.27 _______________ Account: 135-65005-021-000 Fuel & Lube Totals: .00 6,417.27 ** 11,700.00 Budgeted 5,282.73 Remaining 55 % Used Account: 135-65010-021-000 Uniforms 832.88 .00 832.88 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 832.88 ** 2,505.00 Budgeted 1,672.12 Remaining 33 % Used Account: 135-65030-021-000 Chemicals 1242 06/27/2012 June A/P Degreaser, Red Hot Sewer Solve 2,616.00 2,616.00 MICKEY D CARSON DBA/NUSCO 31584 AP _______________ Account: 135-65030-021-000 Chemicals Totals: 2,616.00 2,616.00 ** 12,500.00 Budgeted 9,884.00 Remaining 21 % 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 22.74 .00 22.74 . glpdatb2 rgonzale Trophy Club Entities Page 46 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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-65040-021-000 Safety Equipment Totals: .00 22.74 ** 1,150.00 Budgeted 1,127.26 Remaining 2 % Used Account: 135-65055-021-000 Hardware 44.95 .00 44.95 _______________ Account: 135-65055-021-000 Hardware Totals: .00 44.95 ** 750.00 Budgeted 705.05 Remaining 6 % Used Account: 135-65095-021-000 Maintenance Supplies 352.64 .00 352.64 _______________ Account: 135-65095-021-000 Maintenance Supplies Totals: .00 352.64 ** 16,050.00 Budgeted 15,697.36 Remaining 2 % Used Account: 135-69005-021-000 Capital Expenses 31,991.00 .00 31,991.00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 31,991.00 ** 15,000.00 Budgeted (16,991.00) Remaining 213 % Used Account: 135-69035-021-000 Vehicles 1,001.25 .00 1,001.25 _______________ Account: 135-69035-021-000 Vehicles Totals: .00 1,001.25 ** .00 Budgeted (1,001.25) Remaining 0 % Used Account: 135-69280-021-000 Capital Repairs .00 .00 _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 80,000.00 Budgeted 80,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 214,727.82 ** 497,762.00 Budgeted 283,034.18 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club Entities Page 47 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 6,400.00 .00 6,400.00 _______________ Account: 135-50005-026-000 Salaries & Wages Totals: .00 6,400.00 ** 10,000.00 Budgeted 3,600.00 Remaining 64 % Used Account: 135-50030-026-000 Social Security Taxes 396.80 .00 396.80 _______________ Account: 135-50030-026-000 Social Security Taxes Totals: .00 396.80 ** 620.00 Budgeted 223.20 Remaining 64 % Used Account: 135-50035-026-000 Medicare Taxes 92.80 .00 92.80 _______________ Account: 135-50035-026-000 Medicare Taxes Totals: .00 92.80 ** 145.00 Budgeted 52.20 Remaining 64 % Used Account: 135-50040-026-000 Unemployment Taxes 51.20 .00 51.20 _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .00 51.20 ** 210.00 Budgeted 158.80 Remaining 24 % Used Account: 135-50045-026-000 Workman's Compensation 120.00 .00 120.00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 120.00 ** 120.00 Budgeted .00 Remaining 100 % Used Account: 135-60035-026-000 Postage 26.11 .00 26.11 _______________ Account: 135-60035-026-000 Postage Totals: .00 26.11 ** 50.00 Budgeted 23.89 Remaining 52 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club Entities Page 48 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 685.00 .00 685.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 685.00 ** 2,100.00 Budgeted 1,415.00 Remaining 33 % Used Account: 135-60075-026-000 Meetings 636.56 .00 636.56 _______________ Account: 135-60075-026-000 Meetings Totals: .00 636.56 ** 1,278.00 Budgeted 641.44 Remaining 50 % Used Account: 135-60080-026-000 Schools & Training 1,099.87 .00 1,099.87 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,099.87 ** 4,150.00 Budgeted 3,050.13 Remaining 27 % Used Account: 135-60100-026-000 Travel & per diem 32.19 .00 32.19 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 32.19 ** 6,199.00 Budgeted 6,166.81 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1,117.69 .00 1,117.69 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,117.69 ** 3,200.00 Budgeted 2,082.31 Remaining 35 % Used Account: 135-65085-026-000 Office Supplies 23.90 .00 23.90 _______________ Account: 135-65085-026-000 Office Supplies Totals: .00 23.90 ** 50.00 Budgeted 26.10 Remaining 48 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 10,682.12 ** 28,122.00 Budgeted 17,439.88 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club Entities Page 49 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 6/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-027-000 Salaries & Wages 1303 06/08/2012 6/8/12 Payroll 187,986.97 7,453.03 195,440.00 GL 1304 06/22/2012 6/22/12 Payroll 6,396.96 201,836.96 GL _______________ Account: 135-50005-027-000 Salaries & Wages Totals: 13,849.99 201,836.96 ** 236,831.00 Budgeted 34,994.04 Remaining 85 % Used Account: 135-50010-027-000 Overtime 1303 06/08/2012 6/8/12 Payroll 1,077.14 33.80 1,110.94 GL _______________ Account: 135-50010-027-000 Overtime Totals: 33.80 1,110.94 ** 1,028.00 Budgeted (82.94) Remaining 108 % Used Account: 135-50016-027-000 Longevity 3,705.00 .00 3,705.00 _______________ Account: 135-50016-027-000 Longevity Totals: .00 3,705.00 ** 1,845.00 Budgeted (1,860.00) Remaining 201 % Used Account: 135-50020-027-000 Retirement 1303 06/08/2012 6/8/12 Payroll 26,921.77 1,034.68 27,956.45 GL 1304 06/22/2012 6/22/12 Payroll 855.78 28,812.23 GL _______________ Account: 135-50020-027-000 Retirement Totals: 1,890.46 28,812.23 ** 33,471.00 Budgeted 4,658.77 Remaining 86 % Used Account: 135-50026-027-000 Medical Insurance 1303 06/08/2012 6/8/12 Payroll 11,438.58 752.41 12,190.99 GL 1304 06/22/2012 6/22/12 Payroll 605.93 12,796.92 GL _______________ Account: 135-50026-027-000 Medical Insurance Totals: 1,358.34 12,796.92 ** 18,798.00 Budgeted 6,001.08 Remaining 68 % Used Account: 135-50027-027-000 Dental Insurance 1303 06/08/2012 6/8/12 Payroll 890.88 63.23 954.11 GL 1304 06/22/2012 6/22/12 Payroll 49.02 1,003.13 GL _______________ Account: 135-50027-027-000 Dental Insurance Totals: 112.25 1,003.13 ** 1,242.00 Budgeted 238.87 Remaining 81 % Used . glpdatb2 rgonzale Trophy Club Entities Page 50 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 6/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-50028-027-000 Vision Insurance 1303 06/08/2012 6/8/12 Payroll 219.15 14.86 234.01 GL 1304 06/22/2012 6/22/12 Payroll 11.48 245.49 GL _______________ Account: 135-50028-027-000 Vision Insurance Totals: 26.34 245.49 ** 341.00 Budgeted 95.51 Remaining 72 % Used Account: 135-50029-027-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-027-000 Life Insurance & Other Totals: .00 .00 ** 1,337.00 Budgeted 1,337.00 Remaining 0 % Used Account: 135-50030-027-000 Social Security Taxes 1303 06/08/2012 6/8/12 Payroll 11,483.02 413.75 11,896.77 GL 1304 06/22/2012 6/22/12 Payroll 357.11 12,253.88 GL _______________ Account: 135-50030-027-000 Social Security Taxes Totals: 770.86 12,253.88 ** 14,860.00 Budgeted 2,606.12 Remaining 82 % Used Account: 135-50035-027-000 Medicare Taxes 1303 06/08/2012 6/8/12 Payroll 2,723.43 96.76 2,820.19 GL 1304 06/22/2012 6/22/12 Payroll 83.52 2,903.71 GL _______________ Account: 135-50035-027-000 Medicare Taxes Totals: 180.28 2,903.71 ** 3,475.00 Budgeted 571.29 Remaining 84 % Used Account: 135-50040-027-000 Unemployment Taxes 1304 06/22/2012 6/22/12 Payroll 320.30 1.64 321.94 GL _______________ Account: 135-50040-027-000 Unemployment Taxes Totals: 1.64 321.94 ** 756.00 Budgeted 434.06 Remaining 43 % Used Account: 135-50045-027-000 Workman's Compensation 580.00 .00 580.00 _______________ Account: 135-50045-027-000 Workman's Compensation Totals: .00 580.00 ** 580.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club Entities Page 51 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 6/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-50060-027-000 Pre-emp Physicals/Testing 1235 06/27/2012 June A/P Pre-employment testing/Cook 35.00 17.50 52.50 CARENOW CORPORATE 31571 AP _______________ Account: 135-50060-027-000 Pre-emp Physicals/Testing Totals: 17.50 52.50 ** .00 Budgeted (52.50) Remaining 0 % Used Account: 135-50070-027-000 Employee Relations 3,622.88 .00 3,622.88 _______________ Account: 135-50070-027-000 Employee Relations Totals: .00 3,622.88 ** 5,000.00 Budgeted 1,377.12 Remaining 72 % Used Account: 135-55070-027-000 Independent Labor 251.25 .00 251.25 _______________ Account: 135-55070-027-000 Independent Labor Totals: .00 251.25 ** 840.00 Budgeted 588.75 Remaining 30 % Used Account: 135-55075-027-000 Records Management .00 .00 _______________ Account: 135-55075-027-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55160-027-000 Professional Outside Services 191,092.23 .00 191,092.23 _______________ Account: 135-55160-027-000 Professional Outside Services Totals: .00 191,092.23 ** 190,979.00 Budgeted (113.23) Remaining 100 % Used Account: 135-60005-027-000 Telephone 199.11 .00 199.11 _______________ Account: 135-60005-027-000 Telephone Totals: .00 199.11 ** 300.00 Budgeted 100.89 Remaining 66 % Used Account: 135-60010-027-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club Entities Page 52 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1304 06/22/2012 6/22/12 Payroll 1,214.79 75.00 1,289.79 GL _______________ Account: 135-60010-027-000 Communications/Pagers/Mobiles Totals: 75.00 1,289.79 ** 2,420.00 Budgeted 1,130.21 Remaining 53 % Used Account: 135-60035-027-000 Postage 1209 06/21/2012 June A/P Postage to mail Water restrict 995.95 658.35 1,654.30 U.S. POSTAL SERVICE 31569 AP 1235 06/27/2012 June A/P Postage meter Rental 157.50 1,811.80 PITNEY BOWES INC 31577 AP 1308 06/30/2012 June Postage Meter usage 35.94 1,847.74 GL _______________ Account: 135-60035-027-000 Postage Totals: 851.79 1,847.74 ** 1,800.00 Budgeted (47.74) Remaining 103 % Used Account: 135-60066-027-000 Publications/Books/Subscripts 354.15 .00 354.15 _______________ Account: 135-60066-027-000 Publications/Books/Subscripts Totals: .00 354.15 ** 450.00 Budgeted 95.85 Remaining 79 % Used Account: 135-60070-027-000 Dues & Memberships 1235 06/27/2012 June A/P Assoc Membership/McKnight 527.05 300.00 827.05 TX MUNICIPAL LEAGUE 31581 AP _______________ Account: 135-60070-027-000 Dues & Memberships Totals: 300.00 827.05 ** 1,742.00 Budgeted 914.95 Remaining 47 % Used Account: 135-60075-027-000 Meetings 42.44 .00 42.44 _______________ Account: 135-60075-027-000 Meetings Totals: .00 42.44 ** 312.00 Budgeted 269.56 Remaining 14 % Used Account: 135-60080-027-000 Schools & Training 1,405.00 .00 1,405.00 _______________ Account: 135-60080-027-000 Schools & Training Totals: .00 1,405.00 ** 2,555.00 Budgeted 1,150.00 Remaining 55 % Used Account: 135-60100-027-000 Travel & per diem . glpdatb2 rgonzale Trophy Club Entities Page 53 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,074.02 .00 1,074.02 _______________ Account: 135-60100-027-000 Travel & per diem Totals: .00 1,074.02 ** 3,851.00 Budgeted 2,776.98 Remaining 28 % Used Account: 135-60115-027-000 Elections 612.49 .00 612.49 _______________ Account: 135-60115-027-000 Elections Totals: .00 612.49 ** 2,500.00 Budgeted 1,887.51 Remaining 24 % Used Account: 135-60125-027-000 Advertising .00 .00 _______________ Account: 135-60125-027-000 Advertising Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 135-60245-027-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-027-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-60270-027-000 4th of July Celebration 1266 06/30/2012 June A/P July 4th MUD booth games 10,000.00 105.00 10,105.00 JENNIFER MCKNIGHT 31587 AP _______________ Account: 135-60270-027-000 4th of July Celebration Totals: 105.00 10,105.00 ** 10,000.00 Budgeted (105.00) Remaining 101 % Used Account: 135-60360-027-000 Furniture/Equipment < $5000 1,616.99 .00 1,616.99 _______________ Account: 135-60360-027-000 Furniture/Equipment < $5000 Totals: .00 1,616.99 ** 2,225.00 Budgeted 608.01 Remaining 73 % Used Account: 135-65085-027-000 Office Supplies 1235 06/27/2012 June A/P Office supplies 2,346.13 35.15 2,381.28 OFFICE DEPOT, INC 31575 AP . glpdatb2 rgonzale Trophy Club Entities Page 54 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 6/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-65085-027-000 Office Supplies Totals: 35.15 2,381.28 ** 2,450.00 Budgeted 68.72 Remaining 97 % Used Account: 135-65105-027-000 Printing 589.45 .00 589.45 _______________ Account: 135-65105-027-000 Printing Totals: .00 589.45 ** 750.00 Budgeted 160.55 Remaining 79 % Used Department 27 Totals: ------------------------------------------------------------------------------------------------ 482,933.57 ** 548,038.00 Budgeted 65,104.43 Remaining 88 % Used . glpdatb2 rgonzale Trophy Club Entities Page 55 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 6/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-50070-028-000 Employee Relations 1,478.72 .00 1,478.72 _______________ Account: 135-50070-028-000 Employee Relations Totals: .00 1,478.72 ** 1,967.00 Budgeted 488.28 Remaining 75 % Used Account: 135-50075-028-000 Tuition Reimbursement 219.42 .00 219.42 _______________ Account: 135-50075-028-000 Tuition Reimbursement Totals: .00 219.42 ** 1,561.00 Budgeted 1,341.58 Remaining 14 % Used Account: 135-60005-028-000 Telephone .00 .00 _______________ Account: 135-60005-028-000 Telephone Totals: .00 .00 ** 28.00 Budgeted 28.00 Remaining 0 % Used Account: 135-60035-028-000 Postage 22.23 .00 22.23 _______________ Account: 135-60035-028-000 Postage Totals: .00 22.23 ** 106.00 Budgeted 83.77 Remaining 21 % Used Account: 135-60066-028-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-028-000 Publications/Books/Subscripts Totals: .00 .00 ** 485.00 Budgeted 485.00 Remaining 0 % Used Account: 135-60070-028-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-028-000 Dues & Memberships Totals: .00 .00 ** 555.00 Budgeted 555.00 Remaining 0 % Used Account: 135-60075-028-000 Meetings . glpdatb2 rgonzale Trophy Club Entities Page 56 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 6/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-60075-028-000 Meetings Totals: .00 .00 ** 138.00 Budgeted 138.00 Remaining 0 % Used Account: 135-60080-028-000 Schools & Training .00 .00 _______________ Account: 135-60080-028-000 Schools & Training Totals: .00 .00 ** 594.00 Budgeted 594.00 Remaining 0 % Used Account: 135-60110-028-000 Physicals/Testing 165.00 .00 165.00 _______________ Account: 135-60110-028-000 Physicals/Testing Totals: .00 165.00 ** 1,560.00 Budgeted 1,395.00 Remaining 11 % Used Account: 135-65085-028-000 Office Supplies .00 .00 _______________ Account: 135-65085-028-000 Office Supplies Totals: .00 .00 ** 437.00 Budgeted 437.00 Remaining 0 % Used Account: 135-65105-028-000 Printing .00 .00 _______________ Account: 135-65105-028-000 Printing Totals: .00 .00 ** 116.00 Budgeted 116.00 Remaining 0 % Used Department 28 Totals: ------------------------------------------------------------------------------------------------ 1,885.37 ** 7,547.00 Budgeted 5,661.63 Remaining 25 % Used . glpdatb2 rgonzale Trophy Club Entities Page 57 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 6/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-029-000 Salaries & Wages 1303 06/08/2012 6/8/12 Payroll 54,046.62 3,001.20 57,047.82 GL 1304 06/22/2012 6/22/12 Payroll 3,001.20 60,049.02 GL _______________ Account: 135-50005-029-000 Salaries & Wages Totals: 6,002.40 60,049.02 ** 94,404.00 Budgeted 34,354.98 Remaining 64 % Used Account: 135-50010-029-000 Overtime 946.28 .00 946.28 _______________ Account: 135-50010-029-000 Overtime Totals: .00 946.28 ** 1,000.00 Budgeted 53.72 Remaining 95 % Used Account: 135-50016-029-000 Longevity 1,822.50 .00 1,822.50 _______________ Account: 135-50016-029-000 Longevity Totals: .00 1,822.50 ** 1,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-029-000 Retirement 1303 06/08/2012 6/8/12 Payroll 8,198.14 414.77 8,612.91 GL 1304 06/22/2012 6/22/12 Payroll 414.77 9,027.68 GL _______________ Account: 135-50020-029-000 Retirement Totals: 829.54 9,027.68 ** 13,612.00 Budgeted 4,584.32 Remaining 66 % Used Account: 135-50026-029-000 Medical Insurance 1303 06/08/2012 6/8/12 Payroll 4,953.18 205.35 5,158.53 GL 1304 06/22/2012 6/22/12 Payroll 205.35 5,363.88 GL _______________ Account: 135-50026-029-000 Medical Insurance Totals: 410.70 5,363.88 ** 11,060.00 Budgeted 5,696.12 Remaining 48 % Used Account: 135-50027-029-000 Dental Insurance 1303 06/08/2012 6/8/12 Payroll 477.91 24.51 502.42 GL 1304 06/22/2012 6/22/12 Payroll 24.51 526.93 GL _______________ Account: 135-50027-029-000 Dental Insurance Totals: 49.02 526.93 ** 773.00 Budgeted 246.07 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club Entities Page 58 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 6/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-50028-029-000 Vision Insurance 1303 06/08/2012 6/8/12 Payroll 74.15 3.38 77.53 GL 1304 06/22/2012 6/22/12 Payroll 3.38 80.91 GL _______________ Account: 135-50028-029-000 Vision Insurance Totals: 6.76 80.91 ** 207.00 Budgeted 126.09 Remaining 39 % Used Account: 135-50029-029-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-029-000 Life Insurance & Other Totals: .00 .00 ** 567.00 Budgeted 567.00 Remaining 0 % Used Account: 135-50030-029-000 Social Security Taxes 1303 06/08/2012 6/8/12 Payroll 3,296.21 172.92 3,469.13 GL 1304 06/22/2012 6/22/12 Payroll 172.92 3,642.05 GL _______________ Account: 135-50030-029-000 Social Security Taxes Totals: 345.84 3,642.05 ** 5,386.00 Budgeted 1,743.95 Remaining 68 % Used Account: 135-50035-029-000 Medicare Taxes 1303 06/08/2012 6/8/12 Payroll 770.89 40.44 811.33 GL 1304 06/22/2012 6/22/12 Payroll 40.44 851.77 GL _______________ Account: 135-50035-029-000 Medicare Taxes Totals: 80.88 851.77 ** 1,260.00 Budgeted 408.23 Remaining 68 % Used Account: 135-50040-029-000 Unemployment Taxes 79.54 .00 79.54 _______________ Account: 135-50040-029-000 Unemployment Taxes Totals: .00 79.54 ** 284.00 Budgeted 204.46 Remaining 28 % Used Account: 135-50045-029-000 Workman's Compensation 211.00 .00 211.00 _______________ Account: 135-50045-029-000 Workman's Compensation Totals: .00 211.00 ** 235.00 Budgeted 24.00 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club Entities Page 59 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 6/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-55160-029-000 Professional Outside Services 1,105.50 .00 1,105.50 _______________ Account: 135-55160-029-000 Professional Outside Services Totals: .00 1,105.50 ** 5,000.00 Budgeted 3,894.50 Remaining 22 % Used Account: 135-60005-029-000 Telephone 56.03 .00 56.03 _______________ Account: 135-60005-029-000 Telephone Totals: .00 56.03 ** 103.00 Budgeted 46.97 Remaining 54 % Used Account: 135-60010-029-000 Communications/Pagers/Mobiles 409.34 .00 409.34 _______________ Account: 135-60010-029-000 Communications/Pagers/Mobiles Totals: .00 409.34 ** 683.00 Budgeted 273.66 Remaining 60 % Used Account: 135-60035-029-000 Postage 1308 06/30/2012 June Postage Meter usage 203.69 27.20 230.89 GL _______________ Account: 135-60035-029-000 Postage Totals: 27.20 230.89 ** 700.00 Budgeted 469.11 Remaining 33 % Used Account: 135-60040-029-000 Service Charges & Fees 32.50 .00 32.50 _______________ Account: 135-60040-029-000 Service Charges & Fees Totals: .00 32.50 ** 79.00 Budgeted 46.50 Remaining 41 % Used Account: 135-60066-029-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-029-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-029-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club Entities Page 60 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 6/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-029-000 Dues & Memberships Totals: .00 .00 ** 660.00 Budgeted 660.00 Remaining 0 % Used Account: 135-60075-029-000 Meetings 22.00 .00 22.00 _______________ Account: 135-60075-029-000 Meetings Totals: .00 22.00 ** 300.00 Budgeted 278.00 Remaining 7 % Used Account: 135-60080-029-000 Schools & Training 225.00 .00 225.00 _______________ Account: 135-60080-029-000 Schools & Training Totals: .00 225.00 ** 2,000.00 Budgeted 1,775.00 Remaining 11 % Used Account: 135-60100-029-000 Travel & per diem 27.81 .00 27.81 _______________ Account: 135-60100-029-000 Travel & per diem Totals: .00 27.81 ** .00 Budgeted (27.81) Remaining 0 % Used Account: 135-60125-029-000 Advertising .00 .00 _______________ Account: 135-60125-029-000 Advertising Totals: .00 .00 ** 1,210.00 Budgeted 1,210.00 Remaining 0 % Used Account: 135-60245-029-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-029-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65085-029-000 Office Supplies 148.52 .00 148.52 . glpdatb2 rgonzale Trophy Club Entities Page 61 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 6/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-65085-029-000 Office Supplies Totals: .00 148.52 ** 849.00 Budgeted 700.48 Remaining 17 % Used Account: 135-65105-029-000 Printing .00 .00 _______________ Account: 135-65105-029-000 Printing Totals: .00 .00 ** 515.00 Budgeted 515.00 Remaining 0 % Used Department 29 Totals: ------------------------------------------------------------------------------------------------ 84,859.15 ** 143,410.00 Budgeted 58,550.85 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club Entities Page 62 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 6/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-55030-033-000 Software & Support 1172 06/14/2012 June A/P Annual support/Ghost 56,532.08 125.00 56,657.08 SHI GOVERNMENT SOLUTIONS,INC 31540 AP 1235 06/27/2012 June A/P Adobe for L Slaght 196.70 56,853.78 SHI GOVERNMENT SOLUTIONS,INC 31578 AP 1266 06/30/2012 June A/P SPOT Spam filtering service 96.00 56,949.78 THE FULCRUM GROUP, INC. 31588 AP _______________ Account: 135-55030-033-000 Software & Support Totals: 417.70 56,949.78 ** 64,149.00 Budgeted 7,199.22 Remaining 89 % Used Account: 135-55070-033-000 Independent Labor 375.00 .00 375.00 _______________ Account: 135-55070-033-000 Independent Labor Totals: .00 375.00 ** 1,650.00 Budgeted 1,275.00 Remaining 23 % Used Account: 135-60005-033-000 Telephone 6,061.10 .00 6,061.10 _______________ Account: 135-60005-033-000 Telephone Totals: .00 6,061.10 ** 6,540.00 Budgeted 478.90 Remaining 93 % Used Account: 135-60235-033-000 Security 406.60 .00 406.60 _______________ Account: 135-60235-033-000 Security Totals: .00 406.60 ** 1,350.00 Budgeted 943.40 Remaining 30 % Used Account: 135-65055-033-000 Hardware 70,584.05 .00 70,584.05 _______________ Account: 135-65055-033-000 Hardware Totals: .00 70,584.05 ** 83,238.00 Budgeted 12,653.95 Remaining 85 % Used Account: 135-65085-033-000 Office Supplies 1235 06/27/2012 June A/P DVDR, Toner 230.90 104.00 334.90 SHI GOVERNMENT SOLUTIONS,INC 31578 AP _______________ Account: 135-65085-033-000 Office Supplies Totals: 104.00 334.90 ** 371.00 Budgeted 36.10 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club Entities Page 63 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 6/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-65090-033-000 Printer Supplies & Maintenance 3,572.88 .00 3,572.88 _______________ Account: 135-65090-033-000 Printer Supplies & Maintenance Totals: .00 3,572.88 ** 5,732.00 Budgeted 2,159.12 Remaining 62 % Used Account: 135-69170-033-000 Copier Lease Installments 1235 06/27/2012 June A/P Copier Lease 1,797.95 256.85 2,054.80 KYOCERA MITA AMERICA, INC. 31574 AP _______________ Account: 135-69170-033-000 Copier Lease Installments Totals: 256.85 2,054.80 ** 3,450.00 Budgeted 1,395.20 Remaining 60 % Used Account: 135-69195-033-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-033-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used Department 33 Totals: ------------------------------------------------------------------------------------------------ 140,339.11 ** 193,391.00 Budgeted 53,051.89 Remaining 73 % Used . glpdatb2 rgonzale Trophy Club Entities Page 64 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 6/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-50035-037-000 Medicare Taxes 1304 06/22/2012 6/22/12 Payroll 46.85 46.85 GL _______________ Account: 135-50035-037-000 Medicare Taxes Totals: 46.85 46.85 ** .00 Budgeted (46.85) Remaining 0 % Used Account: 135-50045-037-000 Workman's Compensation 861.00 .00 861.00 _______________ Account: 135-50045-037-000 Workman's Compensation Totals: .00 861.00 ** .00 Budgeted (861.00) Remaining 0 % Used Account: 135-55100-037-000 Building Maint & Supplies 1,379.48 .00 1,379.48 _______________ Account: 135-55100-037-000 Building Maint & Supplies Totals: .00 1,379.48 ** 20,478.00 Budgeted 19,098.52 Remaining 7 % Used Account: 135-55120-037-000 Cleaning Services 1172 06/14/2012 June A/P June Janitorial Service 11,410.29 1,678.51 13,088.80 ABM JANITORIAL SERVICES, INC 31534 AP _______________ Account: 135-55120-037-000 Cleaning Services Totals: 1,678.51 13,088.80 ** 25,000.00 Budgeted 11,911.20 Remaining 52 % Used Account: 135-60020-037-000 Electricity 8,234.74 .00 8,234.74 _______________ Account: 135-60020-037-000 Electricity Totals: .00 8,234.74 ** 21,940.00 Budgeted 13,705.26 Remaining 38 % Used Account: 135-60025-037-000 Water 381.24 .00 381.24 _______________ Account: 135-60025-037-000 Water Totals: .00 381.24 ** 1,093.00 Budgeted 711.76 Remaining 35 % Used Account: 135-60030-037-000 Rent And/Or Usage . glpdatb2 rgonzale Trophy Club Entities Page 65 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1140 06/08/2012 June A/P June Public Svcs Rent 8,788.08 1,098.51 9,886.59 TOWN OF TROPHY CLUB 31529 AP _______________ Account: 135-60030-037-000 Rent And/Or Usage Totals: 1,098.51 9,886.59 ** 13,182.00 Budgeted 3,295.41 Remaining 75 % Used Account: 135-60055-037-000 Insurance 30,386.73 .00 30,386.73 _______________ Account: 135-60055-037-000 Insurance Totals: .00 30,386.73 ** 32,635.00 Budgeted 2,248.27 Remaining 93 % Used Account: 135-60360-037-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-037-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 4,750.00 Budgeted 4,750.00 Remaining 0 % Used Account: 135-65095-037-000 Maintenance Supplies 876.65 .00 876.65 _______________ Account: 135-65095-037-000 Maintenance Supplies Totals: .00 876.65 ** 2,205.00 Budgeted 1,328.35 Remaining 40 % Used Account: 135-65097-037-000 Vending Machine Supplies 80.03 .00 80.03 _______________ Account: 135-65097-037-000 Vending Machine Supplies Totals: .00 80.03 ** 1,000.00 Budgeted 919.97 Remaining 8 % Used Department 37 Totals: ------------------------------------------------------------------------------------------------ 65,222.11 ** 122,283.00 Budgeted 57,060.89 Remaining 53 % Used . glpdatb2 rgonzale Trophy Club Entities Page 66 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 6/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-038-000 Salaries & Wages 1303 06/08/2012 6/8/12 Payroll 52,501.36 2,728.31 55,229.67 GL 1304 06/22/2012 6/22/12 Payroll 3,513.08 58,742.75 GL _______________ Account: 135-50005-038-000 Salaries & Wages Totals: 6,241.39 58,742.75 ** 84,946.00 Budgeted 26,203.25 Remaining 69 % Used Account: 135-50010-038-000 Overtime 1303 06/08/2012 6/8/12 Payroll 261.07 8.11 269.18 GL 1304 06/22/2012 6/22/12 Payroll 5.91 275.09 GL _______________ Account: 135-50010-038-000 Overtime Totals: 14.02 275.09 ** 2,000.00 Budgeted 1,724.91 Remaining 14 % Used Account: 135-50016-038-000 Longevity 220.00 .00 220.00 _______________ Account: 135-50016-038-000 Longevity Totals: .00 220.00 ** 220.00 Budgeted .00 Remaining 100 % Used Account: 135-50020-038-000 Retirement 1303 06/08/2012 6/8/12 Payroll 7,617.97 378.18 7,996.15 GL 1304 06/22/2012 6/22/12 Payroll 465.65 8,461.80 GL _______________ Account: 135-50020-038-000 Retirement Totals: 843.83 8,461.80 ** 12,203.00 Budgeted 3,741.20 Remaining 69 % Used Account: 135-50026-038-000 Medical Insurance 1303 06/08/2012 6/8/12 Payroll 7,174.34 388.94 7,563.28 GL 1304 06/22/2012 6/22/12 Payroll 462.19 8,025.47 GL _______________ Account: 135-50026-038-000 Medical Insurance Totals: 851.13 8,025.47 ** 12,321.00 Budgeted 4,295.53 Remaining 65 % Used Account: 135-50027-038-000 Dental Insurance 1303 06/08/2012 6/8/12 Payroll 711.86 38.72 750.58 GL 1304 06/22/2012 6/22/12 Payroll 45.84 796.42 GL . glpdatb2 rgonzale Trophy Club Entities Page 67 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 6/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-50027-038-000 Dental Insurance Totals: 84.56 796.42 ** 1,026.00 Budgeted 229.58 Remaining 78 % Used Account: 135-50028-038-000 Vision Insurance 1303 06/08/2012 6/8/12 Payroll 167.91 9.12 177.03 GL 1304 06/22/2012 6/22/12 Payroll 10.81 187.84 GL _______________ Account: 135-50028-038-000 Vision Insurance Totals: 19.93 187.84 ** 260.00 Budgeted 72.16 Remaining 72 % Used Account: 135-50029-038-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-038-000 Life Insurance & Other Totals: .00 .00 ** 604.00 Budgeted 604.00 Remaining 0 % Used Account: 135-50030-038-000 Social Security Taxes 1303 06/08/2012 6/8/12 Payroll 3,117.33 157.24 3,274.57 GL 1304 06/22/2012 6/22/12 Payroll 200.30 3,474.87 GL _______________ Account: 135-50030-038-000 Social Security Taxes Totals: 357.54 3,474.87 ** 5,404.00 Budgeted 1,929.13 Remaining 64 % Used Account: 135-50035-038-000 Medicare Taxes 1303 06/08/2012 6/8/12 Payroll 729.07 36.77 765.84 GL _______________ Account: 135-50035-038-000 Medicare Taxes Totals: 36.77 765.84 ** 1,264.00 Budgeted 498.16 Remaining 61 % Used Account: 135-50040-038-000 Unemployment Taxes 1304 06/22/2012 6/22/12 Payroll 189.99 1.19 191.18 GL _______________ Account: 135-50040-038-000 Unemployment Taxes Totals: 1.19 191.18 ** 473.00 Budgeted 281.82 Remaining 40 % Used Account: 135-50045-038-000 Workman's Compensation . glpdatb2 rgonzale Trophy Club Entities Page 68 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 235.00 .00 235.00 _______________ Account: 135-50045-038-000 Workman's Compensation Totals: .00 235.00 ** 211.00 Budgeted (24.00) Remaining 111 % Used Account: 135-50060-038-000 Pre-emp Physicals/Testing 1235 06/27/2012 June A/P Pre-employment testing/Cook 17.50 17.50 CARENOW CORPORATE 31571 AP _______________ Account: 135-50060-038-000 Pre-emp Physicals/Testing Totals: 17.50 17.50 ** .00 Budgeted (17.50) Remaining 0 % Used Account: 135-55070-038-000 Independent Labor .00 .00 _______________ Account: 135-55070-038-000 Independent Labor Totals: .00 .00 ** 800.00 Budgeted 800.00 Remaining 0 % Used Account: 135-55205-038-000 Utility Billing Contract 7,771.63 .00 7,771.63 _______________ Account: 135-55205-038-000 Utility Billing Contract Totals: .00 7,771.63 ** 11,000.00 Budgeted 3,228.37 Remaining 71 % Used Account: 135-60005-038-000 Telephone 55.02 .00 55.02 _______________ Account: 135-60005-038-000 Telephone Totals: .00 55.02 ** 100.00 Budgeted 44.98 Remaining 55 % Used Account: 135-60010-038-000 Communications/Pagers/Mobiles 289.68 .00 289.68 _______________ Account: 135-60010-038-000 Communications/Pagers/Mobiles Totals: .00 289.68 ** 472.00 Budgeted 182.32 Remaining 61 % Used Account: 135-60035-038-000 Postage 11,189.04 .00 11,189.04 . glpdatb2 rgonzale Trophy Club Entities Page 69 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 6/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-60035-038-000 Postage Totals: .00 11,189.04 ** 18,000.00 Budgeted 6,810.96 Remaining 62 % Used Account: 135-60040-038-000 Service Charges & Fees 1305 06/30/2012 Credit Card/Online fees 16,861.54 59.35 16,920.89 GL 1305 06/30/2012 Credit Card/Online fees 65.65 16,986.54 GL 1305 06/30/2012 Credit Card/Online fees 1,167.47 18,154.01 GL 1305 06/30/2012 Credit Card/Online fees 14.29 18,168.30 GL _______________ Account: 135-60040-038-000 Service Charges & Fees Totals: 1,306.76 18,168.30 ** 29,340.00 Budgeted 11,171.70 Remaining 62 % Used Account: 135-60070-038-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-038-000 Dues & Memberships Totals: .00 .00 ** 71.00 Budgeted 71.00 Remaining 0 % Used Account: 135-60080-038-000 Schools & Training 225.00 .00 225.00 _______________ Account: 135-60080-038-000 Schools & Training Totals: .00 225.00 ** 800.00 Budgeted 575.00 Remaining 28 % Used Account: 135-60100-038-000 Travel & per diem .00 .00 _______________ Account: 135-60100-038-000 Travel & per diem Totals: .00 .00 ** 605.00 Budgeted 605.00 Remaining 0 % Used Account: 135-60130-038-000 Reg Assessment Fee (5%) 25,071.20 .00 25,071.20 _______________ Account: 135-60130-038-000 Reg Assessment Fee (5%) Totals: .00 25,071.20 ** 22,500.00 Budgeted (2,571.20) Remaining 111 % Used Account: 135-60245-038-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club Entities Page 70 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1312 06/30/2012 Bank Rec adjustments .01 .01 GL _______________ Account: 135-60245-038-000 Miscellaneous Expenses Totals: .01 .01 ** 200.00 Budgeted 199.99 Remaining 0 % Used Account: 135-65085-038-000 Office Supplies 1235 06/27/2012 June A/P Office supplies 666.10 4.09 670.19 OFFICE DEPOT, INC 31575 AP _______________ Account: 135-65085-038-000 Office Supplies Totals: 4.09 670.19 ** 700.00 Budgeted 29.81 Remaining 96 % Used Account: 135-65105-038-000 Printing .00 .00 _______________ Account: 135-65105-038-000 Printing Totals: .00 .00 ** 3,250.00 Budgeted 3,250.00 Remaining 0 % Used Department 38 Totals: ------------------------------------------------------------------------------------------------ 144,833.83 ** 208,770.00 Budgeted 63,936.17 Remaining 69 % Used . glpdatb2 rgonzale Trophy Club Entities Page 71 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/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 1235 06/27/2012 June A/P May legal 56,835.54 7,308.50 64,144.04 WHITAKER CHALK SWINDLE 31583 AP 1235 06/27/2012 June A/P May legal 263.50 64,407.54 WHITAKER CHALK SWINDLE 31583 AP 1235 06/27/2012 June A/P May legal 2,747.50 67,155.04 THE LISTON LAW FIRM, P.C. 31580 AP _______________ Account: 135-55045-039-000 Legal Totals: 10,319.50 67,155.04 ** 70,000.00 Budgeted 2,844.96 Remaining 96 % Used Account: 135-55055-039-000 Auditing 20,200.00 .00 20,200.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 20,200.00 ** 20,200.00 Budgeted .00 Remaining 100 % Used Account: 135-55060-039-000 Appraisal 1140 06/08/2012 June A/P Third Qtr DCAD Budget 11,074.54 2,540.89 13,615.43 DENTON CENTRAL APPRAISAL DISTR 31508 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,540.89 13,615.43 ** 20,000.00 Budgeted 6,384.57 Remaining 68 % Used Account: 135-55065-039-000 Tax Admin Fees 2,470.09 .00 2,470.09 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,470.09 ** 3,629.00 Budgeted 1,158.91 Remaining 68 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,277.85 .00 2,277.85 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 2,277.85 ** 2,278.00 Budgeted .15 Remaining 100 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 105,718.41 ** 116,107.00 Budgeted 10,388.59 Remaining 91 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (470,768.62) (161,000.00) Budgeted 309,768.62 Remaining 292 % Used Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 6/30/2012 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 842,838 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 29,743 ACCOUNTS RECEIVABLE - PID EMER SERVICES 535 OTHER RECEIVABLES 45,239 TOTAL ASSETS 918,354$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 30,277$ ACCOUNTS PAYABLE 199,013 TOTAL LIABILITIES 229,291$ FUND BALANCE ASSIGNED FUND BALANCE 23,101 UNASSIGNED FUND BALANCE 665,963 TOTAL LIABILITIES AND FUND BALANCE 918,354$ June 30, 2012 9/12 Months (75% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 1 11:37 07/06/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 193,233.00- 193,233.00- 431.09- 191,098.20- 98.895 2,134.80- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,900.00- 6,878.01- 140.368 1,978.01 122-40010-000-000 Property Taxes/MUD Fire 1,076,976.00- 1,076,976.00- 3,507.43- 1,065,533.23- 98.938 11,442.77- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,603.00- 34.10- 5,426.28 -96.846 11,029.28- 122-40015-000-000 Property Taxes/Assessments P&I 725.00- 64.66- 2,245.63- 309.742 1,520.63 122-40020-000-000 Property Taxes/Fire P&I 7,500.00- 7,500.00- 567.53- 3,810.75- 50.810 3,689.25- 122-40970-000-000 Insurance Settlements 9,739.43- 9,739.43- 9,739.43 Subtotal: 1,277,709.00- 1,288,937.00- 14,344.24- 1,273,878.97- 98.832 15,058.03- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 400.00- 7,200.00- 120.000 1,200.00 Subtotal: 6,000.00- 400.00- 7,200.00- 120.000 1,200.00 122-43400-000-000 Fire Inspections 500.00- 75.00- 1,350.00- 270.000 850.00 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 122-43599-000-000 Misc Fire Revenue 1,124.00- Subtotal: 11,124.00- 10,500.00- 75.00- 11,350.00- 108.095 850.00 122-49025-000-000 Auction Sales 1,902.50- 1,902.50 122-49035-000-000 Prior Year Reserves 23,101.00- 122-49900-000-000 Miscellaneous Income 9,122.00- 625.00- 11,196.95- 122.747 2,074.95 122-49901-000-000 Records Management 5.00- 5.00- 5.00 Subtotal: 23,101.00- 9,122.00- 630.00- 13,104.45- 143.658 3,982.45 Program number: 1,311,934.00- 1,314,559.00- 15,449.24- 1,305,533.42- 99.313 9,025.58- Department number: Fire Revenues 1,311,934.00- 1,314,559.00- 15,449.24- 1,305,533.42- 99.313 9,025.58- Revenues Subtotal ----------- 1,311,934.00- 1,314,559.00- 15,449.24- 1,305,533.42- 99.313 9,025.58- . glbase_tbam rgonzale Trophy Club Entities Page 2 11:37 07/06/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 425,748.00 425,748.00 36,317.96 311,158.31 73.085 114,589.69 122-50010-045-000 Overtime 42,000.00 42,000.00 25,295.31 60.227 16,704.69 122-50011-045-000 DPS Holiday Pay 12,133.00 13,773.00 13,773.02 100.000 .02- 122-50016-045-000 Longevity 3,647.00 3,647.00 3,714.46 101.850 67.46- 122-50017-045-000 Certification 4,073.00 4,073.00 200.00 3,253.20 79.872 819.80 122-50020-045-000 Retirement 68,264.00 68,264.00 4,777.09 48,476.34 71.013 19,787.66 122-50026-045-000 Medical Insurance 53,184.00 53,184.00 3,400.33 30,097.19 56.591 23,086.81 122-50027-045-000 Dental Insurance 3,288.00 3,288.00 297.59 2,630.26 79.996 657.74 122-50028-045-000 Vision Insurance 857.00 857.00 67.33 594.24 69.340 262.76 122-50029-045-000 Life Insurance & Other 2,740.00 2,740.00 2,740.00 122-50030-045-000 Social Security Taxes 30,231.00 30,231.00 2,075.29 20,954.73 69.315 9,276.27 122-50035-045-000 Medicare Taxes 7,070.00 7,070.00 485.35 4,900.73 69.317 2,169.27 122-50040-045-000 Unemployment Taxes 1,476.00 1,476.00 15.90 646.89 43.827 829.11 122-50045-045-000 Workman's Compensation 8,793.00 9,209.00 429.67- 8,779.02 95.331 429.98 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 89.00 13.185 586.00 Subtotal: 664,179.00 666,235.00 47,207.17 474,362.70 71.201 191,872.30 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 1,168.50 5,364.89 56.106 4,197.11 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 5,583.67 37.600 9,266.33 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 6,778.10 69.108 3,029.90 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 120.00- 5,975.09 54.319 5,024.91 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 786.00 71.260 317.00 122-55160-045-000 Professional Outside Services 20,000.00 19,623.00 142.69 .727 19,480.31 Subtotal: 66,323.00 65,946.00 1,048.50 24,630.44 37.349 41,315.56 122-60005-045-000 Telephone 106.00 106.00 34.31 32.368 71.69 122-60010-045-000 Communications/Pagers/Mobiles 4,411.00 4,411.00 75.00 1,564.61 35.471 2,846.39 122-60020-045-000 Electricity/Gas 18,270.00 18,270.00 1,091.71 8,743.61 47.858 9,526.39 122-60025-045-000 Water 3,289.00 3,289.00 1,993.97 60.625 1,295.03 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 97.00 97.00 8.55 38.55 39.742 58.45 122-60055-045-000 Insurance 20,974.00 20,974.00 8,078.00 38.514 12,896.00 122-60066-045-000 Publications/Books/Subscrips 401.00 401.00 401.00 122-60070-045-000 Dues & Memberships 8,560.00 8,560.00 85.00 6,650.34 77.691 1,909.66 122-60075-045-000 Meetings 75.00 22.00 29.333 53.00 122-60080-045-000 Schools & Training 6,946.00 6,946.00 1,894.17 27.270 5,051.83 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 6,788.00 6,788.00 2,918.34 42.993 3,869.66 122-60110-045-000 Physicals/Testing 1,918.00 1,918.00 1,918.00 122-60125-045-000 Advertising 156.00 156.00 156.00 122-60160-045-000 Programs & Special Projects 4,162.00 4,162.00 2,017.79 48.481 2,144.21 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 568.26 29.908 1,331.74 . glbase_tbam rgonzale Trophy Club Entities Page 3 11:37 07/06/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 522.60 1,684.85 66.254 858.15 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 821.34 66.398 415.66 Subtotal: 390,758.00 390,833.00 1,782.86 346,030.14 88.537 44,802.86 122-65005-045-000 Fuel & Lube 17,414.00 17,414.00 5,084.81 29.200 12,329.19 122-65010-045-000 Uniforms 4,357.00 4,357.00 34.75 2,911.10 66.814 1,445.90 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 6,473.50 85.178 1,126.50 122-65030-045-000 Chemicals 1,545.00 1,545.00 340.00 22.006 1,205.00 122-65035-045-000 Small Tools 8,371.00 8,371.00 1,696.19 20.263 6,674.81 122-65085-045-000 Office Supplies 329.00 1,200.00 632.64 52.720 567.36 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 1,429.75 51.338 1,355.25 122-65105-045-000 Printing 106.00 106.00 24.77 23.368 81.23 Subtotal: 42,507.00 43,378.00 34.75 18,592.76 42.862 24,785.24 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69035-045-000 Vehicles 13,709.00 13,709.00 13,333.09 97.258 375.91 122-69050-045-000 Radios 2,500.00 2,500.00 248.69 9.948 2,251.31 122-69195-045-000 GASB34/Reserve for Replacement 41,890.00 41,890.00 41,890.00 122-69251-045-000 Engine 681 Payment 73,203.00 73,203.00 4,351.65 5.945 68,851.35 122-69255-045-000 Airpacks 13,865.00 13,865.00 14,526.00 104.767 661.00- Subtotal: 148,167.00 148,167.00 32,459.43 21.907 115,707.57 Program number: 1,311,934.00 1,314,559.00 50,073.28 896,075.47 68.165 418,483.53 Department number: Fire 1,311,934.00 1,314,559.00 50,073.28 896,075.47 68.165 418,483.53 Expenditures Subtotal ----------- 1,311,934.00 1,314,559.00 50,073.28 896,075.47 68.165 418,483.53 Fund number: 122 Trophy Club MUD Fire Dept. 34,624.04 409,457.95- 409,457.95 . glpdatb2 rgonzale Trophy Club Entities Page 1 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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 1284 06/19/2012 Property Taxes/Assessments (190,667.11) (431.09) (191,098.20) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (431.09) (191,098.20) ** (193,233.00) Budgeted (2,134.80) Remaining 99 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (6,878.01) .00 (6,878.01) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (6,878.01) ** (4,900.00) Budgeted 1,978.01 Remaining 140 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1246 06/01/2012 Property Taxes/Assessments (1,062,025.80) (402.26) (1,062,428.06) GL 1247 06/04/2012 Property Taxes/Assessments (715.50) (1,063,143.56) GL 1248 06/05/2012 Property Taxes/Assessments (760.00) (1,063,903.56) GL 1249 06/06/2012 Property Taxes/Assessments (362.82) (1,064,266.38) GL 1252 06/07/2012 Property Taxes/Assessments (225.36) (1,064,491.74) GL 1279 06/11/2012 Property Taxes/Assessments (14.91) (1,064,506.65) GL 1280 06/13/2012 Property Taxes/Assessments (3.99) (1,064,510.64) GL 1281 06/14/2012 Property Taxes/Assessments (18.43) (1,064,529.07) GL 1282 06/15/2012 Property Taxes/Assessments (50.82) (1,064,579.89) GL 1283 06/18/2012 Property Taxes/Assessments (164.99) (1,064,744.88) GL 1284 06/19/2012 Property Taxes/Assessments (70.52) (1,064,815.40) GL 1285 06/20/2012 Property Taxes/Assessments (466.56) (1,065,281.96) GL 1286 06/22/2012 Property Taxes/Assessments (227.45) (1,065,509.41) GL 1287 06/25/2012 Property Taxes/Assessments (23.82) (1,065,533.23) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,507.43) (1,065,533.23) ** (1,076,976.00) Budgeted (11,442.77) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1249 06/06/2012 Property Taxes/Assessments 5,460.38 (.16) 5,460.22 GL 1251 06/06/2012 Property Taxes/Assessments (51.00) 5,409.22 GL 1172 06/14/2012 June A/P Refund Credit Balance FKA2 86.64 5,495.86 DENTON COUNTY TAX OFFICE 31537 AP 1310 06/28/2012 Property Taxes/Assessments (69.58) 5,426.28 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (34.10) 5,426.28 ** (5,603.00) Budgeted (11,029.28) Remaining -97 % Used . glpdatb2 rgonzale Trophy Club Entities Page 2 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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-40015-000-000 Property Taxes/Assessments P&I 1284 06/19/2012 Property Taxes/Assessments (2,180.97) (64.66) (2,245.63) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (64.66) (2,245.63) ** (725.00) Budgeted 1,520.63 Remaining 310 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1246 06/01/2012 Property Taxes/Assessments (3,243.22) (33.65) (3,276.87) GL 1247 06/04/2012 Property Taxes/Assessments (86.71) (3,363.58) GL 1248 06/05/2012 Property Taxes/Assessments (114.99) (3,478.57) GL 1249 06/06/2012 Property Taxes/Assessments (54.46) (3,533.03) GL 1251 06/06/2012 Property Taxes/Assessments (39.27) (3,572.30) GL 1252 06/07/2012 Property Taxes/Assessments (33.81) (3,606.11) GL 1279 06/11/2012 Property Taxes/Assessments (2.19) (3,608.30) GL 1280 06/13/2012 Property Taxes/Assessments (.60) (3,608.90) GL 1172 06/14/2012 June A/P Refund Credit Balance FKA2 (59.68) (3,668.58) DENTON COUNTY TAX OFFICE 31537 AP 1281 06/14/2012 Property Taxes/Assessments (2.77) (3,671.35) GL 1283 06/18/2012 Property Taxes/Assessments (24.75) (3,696.10) GL 1285 06/20/2012 Property Taxes/Assessments (56.08) (3,752.18) GL 1286 06/22/2012 Property Taxes/Assessments (34.11) (3,786.29) GL 1287 06/25/2012 Property Taxes/Assessments (3.58) (3,789.87) GL 1310 06/28/2012 Property Taxes/Assessments (20.88) (3,810.75) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (567.53) (3,810.75) ** (7,500.00) Budgeted (3,689.25) Remaining 51 % Used Account: 122-40970-000-000 Insurance Settlements 1295 06/25/2012 TML Fire Truck Claim (9,739.43) (9,739.43) GL _______________ Account: 122-40970-000-000 Insurance Settlements Totals: (9,739.43) (9,739.43) ** .00 Budgeted 9,739.43 Remaining 0 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1274 06/22/2012 Permits 6/22/12 (6,800.00) (400.00) (7,200.00) GL _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (7,200.00) ** (6,000.00) Budgeted 1,200.00 Remaining 120 % Used Account: 122-43400-000-000 Fire Inspections . glpdatb2 rgonzale Trophy Club Entities Page 3 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1274 06/22/2012 Permits 6/22/12 (1,275.00) (75.00) (1,350.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (1,350.00) ** (500.00) Budgeted 850.00 Remaining 270 % Used Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49025-000-000 Auction Sales (1,902.50) .00 (1,902.50) _______________ Account: 122-49025-000-000 Auction Sales Totals: .00 (1,902.50) ** .00 Budgeted 1,902.50 Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1274 06/22/2012 Permits 6/22/12 (10,571.95) (625.00) (11,196.95) GL _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (625.00) (11,196.95) ** (9,122.00) Budgeted 2,074.95 Remaining 123 % Used Account: 122-49901-000-000 Records Management 1292 06/25/2012 Lexis Nexis/ORR Fire (5.00) (5.00) GL _______________ Account: 122-49901-000-000 Records Management Totals: (5.00) (5.00) ** .00 Budgeted 5.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,305,533.42) ** (1,314,559.00) Budgeted (9,025.58) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club Entities Page 4 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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 1303 06/08/2012 6/8/12 Payroll 274,840.35 19,039.33 293,879.68 GL 1304 06/22/2012 6/22/12 Payroll 17,278.63 311,158.31 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 36,317.96 311,158.31 ** 425,748.00 Budgeted 114,589.69 Remaining 73 % Used Account: 122-50010-045-000 Overtime 25,295.31 .00 25,295.31 _______________ Account: 122-50010-045-000 Overtime Totals: .00 25,295.31 ** 42,000.00 Budgeted 16,704.69 Remaining 60 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,773.02 .00 13,773.02 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,773.02 ** 13,773.00 Budgeted (.02) Remaining 100 % Used Account: 122-50016-045-000 Longevity 3,714.46 .00 3,714.46 _______________ Account: 122-50016-045-000 Longevity Totals: .00 3,714.46 ** 3,647.00 Budgeted (67.46) Remaining 102 % Used Account: 122-50017-045-000 Certification 1304 06/22/2012 6/22/12 Payroll 3,053.20 200.00 3,253.20 GL _______________ Account: 122-50017-045-000 Certification Totals: 200.00 3,253.20 ** 4,073.00 Budgeted 819.80 Remaining 80 % Used Account: 122-50020-045-000 Retirement 1303 06/08/2012 6/8/12 Payroll 43,699.25 2,528.26 46,227.51 GL 1304 06/22/2012 6/22/12 Payroll 2,248.83 48,476.34 GL _______________ Account: 122-50020-045-000 Retirement Totals: 4,777.09 48,476.34 ** 68,264.00 Budgeted 19,787.66 Remaining 71 % Used . glpdatb2 rgonzale Trophy Club Entities Page 5 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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 1303 06/08/2012 6/8/12 Payroll 26,696.86 1,663.55 28,360.41 GL 1304 06/22/2012 6/22/12 Payroll 1,736.78 30,097.19 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,400.33 30,097.19 ** 53,184.00 Budgeted 23,086.81 Remaining 57 % Used Account: 122-50027-045-000 Dental Insurance 1303 06/08/2012 6/8/12 Payroll 2,332.67 145.24 2,477.91 GL 1304 06/22/2012 6/22/12 Payroll 152.35 2,630.26 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 297.59 2,630.26 ** 3,288.00 Budgeted 657.74 Remaining 80 % Used Account: 122-50028-045-000 Vision Insurance 1303 06/08/2012 6/8/12 Payroll 526.91 32.81 559.72 GL 1304 06/22/2012 6/22/12 Payroll 34.52 594.24 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 67.33 594.24 ** 857.00 Budgeted 262.76 Remaining 69 % Used Account: 122-50029-045-000 Life Insurance & Other .00 .00 _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: .00 .00 ** 2,740.00 Budgeted 2,740.00 Remaining 0 % Used Account: 122-50030-045-000 Social Security Taxes 1303 06/08/2012 6/8/12 Payroll 18,879.44 1,087.65 19,967.09 GL 1304 06/22/2012 6/22/12 Payroll 987.64 20,954.73 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,075.29 20,954.73 ** 30,231.00 Budgeted 9,276.27 Remaining 69 % Used Account: 122-50035-045-000 Medicare Taxes 1303 06/08/2012 6/8/12 Payroll 4,415.38 254.38 4,669.76 GL 1304 06/22/2012 6/22/12 Payroll 230.97 4,900.73 GL . glpdatb2 rgonzale Trophy Club Entities Page 6 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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: 485.35 4,900.73 ** 7,070.00 Budgeted 2,169.27 Remaining 69 % Used Account: 122-50040-045-000 Unemployment Taxes 1303 06/08/2012 6/8/12 Payroll 630.99 5.97 636.96 GL 1304 06/22/2012 6/22/12 Payroll 9.93 646.89 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 15.90 646.89 ** 1,476.00 Budgeted 829.11 Remaining 44 % Used Account: 122-50045-045-000 Workman's Compensation 1288 06/05/2012 Town Payment EMS W/C reimb 9,208.69 (429.67) 8,779.02 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: (429.67) 8,779.02 ** 9,209.00 Budgeted 429.98 Remaining 95 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 89.00 .00 89.00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 89.00 ** 675.00 Budgeted 586.00 Remaining 13 % Used Account: 122-55080-045-000 Maintenance & Repairs 1172 06/14/2012 June A/P Hose testing 4,196.39 1,168.50 5,364.89 WATERWAY NORTH TEXAS INC 31543 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,168.50 5,364.89 ** 9,562.00 Budgeted 4,197.11 Remaining 56 % Used Account: 122-55090-045-000 Vehicle Maintenance 5,583.67 .00 5,583.67 _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 5,583.67 ** 14,850.00 Budgeted 9,266.33 Remaining 38 % Used Account: 122-55095-045-000 Equipment Maintenance 6,778.10 .00 6,778.10 . glpdatb2 rgonzale Trophy Club Entities Page 7 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-55095-045-000 Equipment Maintenance Totals: .00 6,778.10 ** 9,808.00 Budgeted 3,029.90 Remaining 69 % Used Account: 122-55100-045-000 Building Maintenance 1290 06/05/2012 Firefighters/June Cable 6,095.09 (120.00) 5,975.09 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: (120.00) 5,975.09 ** 11,000.00 Budgeted 5,024.91 Remaining 54 % Used Account: 122-55110-045-000 Maintenance-Radios 786.00 .00 786.00 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 786.00 ** 1,103.00 Budgeted 317.00 Remaining 71 % Used Account: 122-55160-045-000 Professional Outside Services 142.69 .00 142.69 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 142.69 ** 19,623.00 Budgeted 19,480.31 Remaining 1 % Used Account: 122-60005-045-000 Telephone 34.31 .00 34.31 _______________ Account: 122-60005-045-000 Telephone Totals: .00 34.31 ** 106.00 Budgeted 71.69 Remaining 32 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1304 06/22/2012 6/22/12 Payroll 1,489.61 75.00 1,564.61 GL _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 75.00 1,564.61 ** 4,411.00 Budgeted 2,846.39 Remaining 35 % Used Account: 122-60020-045-000 Electricity/Gas 1235 06/27/2012 June A/P Electricity/Fire Station 5/15- 7,651.90 1,059.37 8,711.27 HUDSON ENERGY 31573 AP 1235 06/27/2012 June A/P Gas/Fire Station 32.34 8,743.61 ATMOS ENERGY 31570 AP . glpdatb2 rgonzale Trophy Club Entities Page 8 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-60020-045-000 Electricity/Gas Totals: 1,091.71 8,743.61 ** 18,270.00 Budgeted 9,526.39 Remaining 48 % Used Account: 122-60025-045-000 Water 1,993.97 .00 1,993.97 _______________ Account: 122-60025-045-000 Water Totals: .00 1,993.97 ** 3,289.00 Budgeted 1,295.03 Remaining 61 % Used Account: 122-60030-045-000 Rent And/Or Usage 308,000.00 .00 308,000.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 1308 06/30/2012 June Postage Meter usage 30.00 8.55 38.55 GL _______________ Account: 122-60035-045-000 Postage Totals: 8.55 38.55 ** 97.00 Budgeted 58.45 Remaining 40 % Used Account: 122-60055-045-000 Insurance 8,078.00 .00 8,078.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 8,078.00 ** 20,974.00 Budgeted 12,896.00 Remaining 39 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 401.00 Budgeted 401.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 1172 06/14/2012 June A/P Higher Cert fee 6,565.34 85.00 6,650.34 GREGORY BOOS 31538 AP . glpdatb2 rgonzale Trophy Club Entities Page 9 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-60070-045-000 Dues & Memberships Totals: 85.00 6,650.34 ** 8,560.00 Budgeted 1,909.66 Remaining 78 % Used Account: 122-60075-045-000 Meetings 22.00 .00 22.00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 22.00 ** 75.00 Budgeted 53.00 Remaining 29 % Used Account: 122-60080-045-000 Schools & Training 1,894.17 .00 1,894.17 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 1,894.17 ** 6,946.00 Budgeted 5,051.83 Remaining 27 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 2,918.34 .00 2,918.34 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 2,918.34 ** 6,788.00 Budgeted 3,869.66 Remaining 43 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 1,918.00 Budgeted 1,918.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 10 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-60125-045-000 Advertising Totals: .00 .00 ** 156.00 Budgeted 156.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 2,017.79 .00 2,017.79 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 2,017.79 ** 4,162.00 Budgeted 2,144.21 Remaining 48 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 568.26 .00 568.26 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 568.26 ** 1,900.00 Budgeted 1,331.74 Remaining 30 % Used Account: 122-60195-045-000 Flags & Repair 1235 06/27/2012 June A/P Flag repair, Wire Core, Stainl 1,162.25 522.60 1,684.85 SYMONDS FLAGS & POLES 31579 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 522.60 1,684.85 ** 2,543.00 Budgeted 858.15 Remaining 66 % Used Account: 122-60245-045-000 Miscellaneous Expense 821.34 .00 821.34 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 821.34 ** 1,237.00 Budgeted 415.66 Remaining 66 % Used Account: 122-65005-045-000 Fuel & Lube 5,084.81 .00 5,084.81 _______________ Account: 122-65005-045-000 Fuel & Lube Totals: .00 5,084.81 ** 17,414.00 Budgeted 12,329.19 Remaining 29 % Used Account: 122-65010-045-000 Uniforms 1235 06/27/2012 June A/P Uniforms 2,876.35 34.75 2,911.10 PANDA EMBROIDERY 31576 AP . glpdatb2 rgonzale Trophy Club Entities Page 11 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-65010-045-000 Uniforms Totals: 34.75 2,911.10 ** 4,357.00 Budgeted 1,445.90 Remaining 67 % Used Account: 122-65015-045-000 Protective Clothing 6,473.50 .00 6,473.50 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 6,473.50 ** 7,600.00 Budgeted 1,126.50 Remaining 85 % Used Account: 122-65030-045-000 Chemicals 340.00 .00 340.00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 340.00 ** 1,545.00 Budgeted 1,205.00 Remaining 22 % Used Account: 122-65035-045-000 Small Tools 1,696.19 .00 1,696.19 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 1,696.19 ** 8,371.00 Budgeted 6,674.81 Remaining 20 % Used Account: 122-65085-045-000 Office Supplies 632.64 .00 632.64 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 632.64 ** 1,200.00 Budgeted 567.36 Remaining 53 % Used Account: 122-65095-045-000 Maintenance Supplies 1,429.75 .00 1,429.75 _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: .00 1,429.75 ** 2,785.00 Budgeted 1,355.25 Remaining 51 % Used Account: 122-65105-045-000 Printing 24.77 .00 24.77 . glpdatb2 rgonzale Trophy Club Entities Page 12 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-65105-045-000 Printing Totals: .00 24.77 ** 106.00 Budgeted 81.23 Remaining 23 % 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-69035-045-000 Vehicles 13,333.09 .00 13,333.09 _______________ Account: 122-69035-045-000 Vehicles Totals: .00 13,333.09 ** 13,709.00 Budgeted 375.91 Remaining 97 % Used Account: 122-69050-045-000 Radios 248.69 .00 248.69 _______________ Account: 122-69050-045-000 Radios Totals: .00 248.69 ** 2,500.00 Budgeted 2,251.31 Remaining 10 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 41,890.00 Budgeted 41,890.00 Remaining 0 % Used Account: 122-69251-045-000 Engine 681 Payment 4,351.65 .00 4,351.65 _______________ Account: 122-69251-045-000 Engine 681 Payment Totals: .00 4,351.65 ** 73,203.00 Budgeted 68,851.35 Remaining 6 % Used Account: 122-69255-045-000 Airpacks 14,526.00 .00 14,526.00 . glpdatb2 rgonzale Trophy Club Entities Page 13 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-69255-045-000 Airpacks Totals: .00 14,526.00 ** 13,865.00 Budgeted (661.00) Remaining 105 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 896,075.47 ** 1,314,559.00 Budgeted 418,483.53 Remaining 68 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (409,457.95) .00 Budgeted 409,457.95 Remaining 0 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 6/30/2012 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 814,489 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 21,987 TOTAL ASSETS 842,596$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 21,987$ TOTAL LIABILITIES 21,987 FUND BALANCE ASSIGNED FUND BALANCE 820,609 TOTAL LIABILITIES AND FUND BALANCE 842,596$ June 30, 2012 9/12 Months (75% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 21 11:37 07/06/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 6/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 550,663.00- 546,716.00- 1,793.38- 544,812.28- 99.652 1,903.72- 533-40002-000-000 Property Taxes/Delinquent 3,947.00- 149.82- 3,136.11 -79.456 7,083.11- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 303.62- 2,346.13- 46.764 2,670.87- Subtotal: 555,680.00- 555,680.00- 2,246.82- 544,022.30- 97.902 11,657.70- 533-48005-000-000 Utility Fees 6,120.00- 345,000.00- 6,120.00- 1.774 338,880.00- Subtotal: 6,120.00- 345,000.00- 6,120.00- 1.774 338,880.00- 533-49010-000-000 Interest Income 500.00- 1,700.00- 93.24- 1,107.26- 65.133 592.74- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00 533-49110-000-000 Premium on Bonds Sold 4,661.84- 4,661.84 Subtotal: 308,500.00- 1,700.00- 93.24- 313,769.10- ############### 312,069.10 Program number: 870,300.00- 902,380.00- 2,340.06- 863,911.40- 95.737 38,468.60- Department number: Revenues 870,300.00- 902,380.00- 2,340.06- 863,911.40- 95.737 38,468.60- Revenues Subtotal ----------- 870,300.00- 902,380.00- 2,340.06- 863,911.40- 95.737 38,468.60- . glbase_tbam rgonzale Trophy Club Entities Page 22 11:37 07/06/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 6/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 500.00 12.500 3,500.00 533-70025-051-000 Bond Interest Expense 301,300.00 301,300.00 150,650.00 50.000 150,650.00 533-70035-051-000 Bond Principal Payment 565,000.00 565,000.00 565,000.00 Subtotal: 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Program number: 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Department number: Administration 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Expenditures Subtotal ----------- 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Fund number: 533 MUD 1 I&S CONSOLIDATED 32,080.00- 2,340.06- 712,761.40- 2,221.825 680,681.40 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club Entities Page 72 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 6/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 1246 06/01/2012 Property Taxes/Assessments (543,018.90) (205.67) (543,224.57) GL 1247 06/04/2012 Property Taxes/Assessments (365.84) (543,590.41) GL 1248 06/05/2012 Property Taxes/Assessments (388.58) (543,978.99) GL 1249 06/06/2012 Property Taxes/Assessments (185.51) (544,164.50) GL 1252 06/07/2012 Property Taxes/Assessments (115.23) (544,279.73) GL 1279 06/11/2012 Property Taxes/Assessments (7.63) (544,287.36) GL 1280 06/13/2012 Property Taxes/Assessments (2.04) (544,289.40) GL 1281 06/14/2012 Property Taxes/Assessments (9.43) (544,298.83) GL 1282 06/15/2012 Property Taxes/Assessments (25.99) (544,324.82) GL 1283 06/18/2012 Property Taxes/Assessments (84.37) (544,409.19) GL 1284 06/19/2012 Property Taxes/Assessments (36.06) (544,445.25) GL 1285 06/20/2012 Property Taxes/Assessments (238.55) (544,683.80) GL 1286 06/22/2012 Property Taxes/Assessments (116.30) (544,800.10) GL 1287 06/25/2012 Property Taxes/Assessments (12.18) (544,812.28) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,793.38) (544,812.28) ** (546,716.00) Budgeted (1,903.72) Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1249 06/06/2012 Property Taxes/Assessments 3,285.93 (.11) 3,285.82 GL 1251 06/06/2012 Property Taxes/Assessments (105.90) 3,179.92 GL 1310 06/28/2012 Property Taxes/Assessments (43.81) 3,136.11 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (149.82) 3,136.11 ** (3,947.00) Budgeted (7,083.11) Remaining -79 % Used Account: 533-40015-000-000 Property Taxes/P & I 1246 06/01/2012 Property Taxes/Assessments (2,042.51) (17.21) (2,059.72) GL 1247 06/04/2012 Property Taxes/Assessments (44.32) (2,104.04) GL 1248 06/05/2012 Property Taxes/Assessments (38.84) (2,142.88) GL 1249 06/06/2012 Property Taxes/Assessments (27.86) (2,170.74) GL 1251 06/06/2012 Property Taxes/Assessments (81.54) (2,252.28) GL 1252 06/07/2012 Property Taxes/Assessments (17.28) (2,269.56) GL 1279 06/11/2012 Property Taxes/Assessments (1.10) (2,270.66) GL 1280 06/13/2012 Property Taxes/Assessments (.30) (2,270.96) GL 1281 06/14/2012 Property Taxes/Assessments (1.41) (2,272.37) GL 1283 06/18/2012 Property Taxes/Assessments (12.66) (2,285.03) GL 1285 06/20/2012 Property Taxes/Assessments (28.68) (2,313.71) GL 1286 06/22/2012 Property Taxes/Assessments (17.45) (2,331.16) GL 1287 06/25/2012 Property Taxes/Assessments (1.83) (2,332.99) GL . glpdatb2 rgonzale Trophy Club Entities Page 73 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 6/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1310 06/28/2012 Property Taxes/Assessments (2,042.51) (13.14) (2,346.13) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (303.62) (2,346.13) ** (5,017.00) Budgeted (2,670.87) Remaining 47 % Used Account: 533-48005-000-000 Utility Fees (6,120.00) .00 (6,120.00) _______________ Account: 533-48005-000-000 Utility Fees Totals: .00 (6,120.00) ** (345,000.00) Budgeted (338,880.00) Remaining 2 % Used Account: 533-49010-000-000 Interest Income 1302 06/30/2012 June Bank Interest (1,014.02) (93.24) (1,107.26) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (93.24) (1,107.26) ** (1,700.00) Budgeted (592.74) Remaining 65 % Used Account: 533-49015-000-000 Lease/Rental Income (308,000.00) .00 (308,000.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (308,000.00) ** .00 Budgeted 308,000.00 Remaining 0 % Used Account: 533-49110-000-000 Premium on Bonds Sold (4,661.84) .00 (4,661.84) _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: .00 (4,661.84) ** .00 Budgeted 4,661.84 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (863,911.40) ** (902,380.00) Budgeted (38,468.60) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club Entities Page 74 11:38 07/06/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 6/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 500.00 .00 500.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 500.00 ** 4,000.00 Budgeted 3,500.00 Remaining 13 % Used Account: 533-70025-051-000 Bond Interest Expense 150,650.00 .00 150,650.00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 150,650.00 ** 301,300.00 Budgeted 150,650.00 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 565,000.00 Budgeted 565,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 151,150.00 ** 870,300.00 Budgeted 719,150.00 Remaining 17 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (712,761.40) (32,080.00) Budgeted 680,681.40 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (1,592,987.97) **** (193,080.00) Budgeted 1,399,907.97 Remaining 825 % Used ******* End of Report *********