Loading...
HomeMy WebLinkAboutFebruary Financials Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 2/28/2013 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 1,138,046 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 42,375 ACCOUNTS RECEIVABLE - PID EMER SERVICES 4,310 OTHER RECEIVABLES 26,736 TOTAL ASSETS 1,211,467$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 46,685$ ACCOUNTS PAYABLE 148,675 TOTAL LIABILITIES 195,360$ FUND BALANCE UNASSIGNED FUND BALANCE 1,016,107 TOTAL LIABILITIES AND FUND BALANCE 1,211,467$ February 28, 2013 5/12 Months (41.67% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 18:34 03/12/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 252,084.00- 252,084.00- 29,941.21- 248,569.61- 98.606 3,514.39- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 4,700.00- 5.36- .114 4,694.64- 122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 241,075.75- 1,031,510.30- 98.206 18,838.70- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 3,675.62- 63.373 2,124.38- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 179.56- 180.64- 24.085 569.36- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 528.57- 2,102.85- 46.730 2,397.15- Subtotal: 1,318,183.00- 1,318,183.00- 271,725.09- 1,286,044.38- 97.562 32,138.62- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 1,200.00- 2,400.00- 40.000 3,600.00- Subtotal: 6,000.00- 6,000.00- 1,200.00- 2,400.00- 40.000 3,600.00- 122-43400-000-000 Fire Inspections 500.00- 500.00- 225.00- 450.00- 90.000 50.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,500.00- 10,500.00- 225.00- 10,450.00- 99.524 50.00- 122-49900-000-000 Miscellaneous Income 1,200.00- 1,200.00- 1,575.00- 3,564.26- 297.022 2,364.26 Subtotal: 1,200.00- 1,200.00- 1,575.00- 3,564.26- 297.022 2,364.26 Program number: 1,335,883.00- 1,335,883.00- 274,725.09- 1,302,458.64- 97.498 33,424.36- Department number: Fire Revenues 1,335,883.00- 1,335,883.00- 274,725.09- 1,302,458.64- 97.498 33,424.36- Revenues Subtotal ----------- 1,335,883.00- 1,335,883.00- 274,725.09- 1,302,458.64- 97.498 33,424.36- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 18:34 03/12/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 444,717.00 444,717.00 34,384.98 160,403.64 36.069 284,313.36 122-50010-045-000 Overtime 31,375.00 31,375.00 3,183.24 16,370.18 52.176 15,004.82 122-50011-045-000 DPS Holiday Pay 13,083.00 13,083.00 12,080.51 92.337 1,002.49 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.11 100.003 .11- 122-50017-045-000 Certification 4,896.00 4,896.00 369.00 2,387.25 48.759 2,508.75 122-50020-045-000 Retirement 69,242.00 69,242.00 5,151.07 28,131.13 40.627 41,110.87 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,551.21 17,111.75 35.408 31,215.25 122-50027-045-000 Dental Insurance 3,635.00 3,635.00 327.31 1,590.53 43.756 2,044.47 122-50028-045-000 Vision Insurance 824.00 824.00 67.52 327.35 39.727 496.65 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 605.45 2,381.25 56.029 1,868.75 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,161.32 11,897.00 38.505 19,000.00 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 505.48 2,782.34 38.505 4,443.66 122-50040-045-000 Unemployment Taxes 1,481.00 1,481.00 802.05 1,903.78 128.547 422.78- 122-50045-045-000 Workman's Compensation 10,000.00 10,000.00 10,000.00 100.000 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 132.60 283.05 41.933 391.95 122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 Subtotal: 676,394.00 676,394.00 51,241.23 271,915.87 40.201 404,478.13 122-55045-045-000 Legal 710.60 710.60 710.60- 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 1,340.52 3,656.97 38.245 5,905.03 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 165.00 2,154.05 14.505 12,695.95 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 6,051.55 6,051.55 61.700 3,756.45 122-55100-045-000 Building Maintenance 6,500.00 6,500.00 1,033.67 1,970.67 30.318 4,529.33 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 405.50 405.50 36.763 697.50 122-55160-045-000 Professional Outside Services 2,500.00 2,500.00 2,500.00 Subtotal: 44,323.00 44,323.00 9,706.84 14,949.34 33.728 29,373.66 122-60005-045-000 Telephone 106.00 106.00 6.54 27.02 25.491 78.98 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 2,500.00 217.50 2,118.52 84.741 381.48 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 513.94 2,789.33 45.230 3,377.67 122-60025-045-000 Water 1,400.00 1,400.00 64.55- 481.91 34.422 918.09 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 100.00 100.00 54.60 54.600 45.40 122-60055-045-000 Insurance 10,000.00 10,000.00 10,000.00 100.000 122-60066-045-000 Publications/Books/Subscrips 410.00 410.00 410.00 122-60070-045-000 Dues & Memberships 7,500.00 7,500.00 100.00 7,785.91 103.812 285.91- 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 225.00 1,644.00 32.880 3,356.00 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 4,800.00 4,800.00 349.71 1,161.90 24.206 3,638.10 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 150.00 150.00 122.35 81.567 27.65 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 18:34 03/12/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60160-045-000 Programs & Special Projects 4,200.00 4,200.00 2,198.94 52.356 2,001.06 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 405.24 738.97 38.893 1,161.03 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 435.00 659.75 25.944 1,883.25 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 37.65 489.63 39.582 747.37 Subtotal: 359,088.00 359,088.00 310,226.03 339,272.83 94.482 19,815.17 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 584.39 3,816.63 38.166 6,183.37 122-65010-045-000 Uniforms 4,357.00 4,357.00 69.69 915.32 21.008 3,441.68 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 605.00 670.00 8.816 6,930.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 402.00 40.200 598.00 122-65035-045-000 Small Tools 5,000.00 5,000.00 519.53 776.91 15.538 4,223.09 122-65085-045-000 Office Supplies 1,200.00 1,200.00 22.95 103.40 8.617 1,096.60 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 51.92 705.81 25.343 2,079.19 122-65105-045-000 Printing 106.00 106.00 106.00 Subtotal: 32,048.00 32,048.00 1,853.48 7,390.07 23.059 24,657.93 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69008-045-000 Short Term Debt-Principal 72,932.00 72,932.00 2,966.05 2,966.05 4.067 69,965.95 122-69050-045-000 Radios 2,500.00 2,500.00 339.52 353.13 14.125 2,146.87 122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 145,598.00 Subtotal: 224,030.00 224,030.00 3,305.57 3,319.18 1.482 220,710.82 Program number: 1,335,883.00 1,335,883.00 376,333.15 636,847.29 47.672 699,035.71 Department number: Fire 1,335,883.00 1,335,883.00 376,333.15 636,847.29 47.672 699,035.71 Expenditures Subtotal ----------- 1,335,883.00 1,335,883.00 376,333.15 636,847.29 47.672 699,035.71 Fund number: 122 Trophy Club MUD Fire Dept. 101,608.06 665,611.35- 665,611.35 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 994 02/01/2013 Property Taxes/Assessments (218,628.40) (.67) (218,629.07) GL 1018 02/01/2013 Property Taxes/Assessments (3,142.33) (221,771.40) GL 995 02/02/2013 Property Taxes/Assessments (2,037.56) (223,808.96) GL 996 02/04/2013 Property Taxes/Assessments (562.13) (224,371.09) GL 997 02/05/2013 Property Taxes/Assessments (3,735.67) (228,106.76) GL 998 02/06/2013 Property Taxes/Assessments (5,817.33) (233,924.09) GL 999 02/07/2013 Property Taxes/Assessments (5,660.68) (239,584.77) GL 1000 02/08/2013 Property Taxes/Assessments (1,360.84) (240,945.61) GL 1001 02/11/2013 Property Taxes/Assessments (29.30) (240,974.91) GL 1002 02/12/2013 Property Taxes/Assessments (3,388.00) (244,362.91) GL 1004 02/13/2013 Property Taxes/Assessments (1,812.51) (246,175.42) GL 1005 02/14/2013 Property Taxes/Assessments (463.69) (246,639.11) GL 1006 02/15/2013 Property Taxes/Assessments (369.35) (247,008.46) GL 1007 02/19/2013 Property Taxes/Assessments (311.52) (247,319.98) GL 1008 02/20/2013 Property Taxes/Assessments (431.75) (247,751.73) GL 1010 02/25/2013 Property Taxes/Assessments (701.10) (248,452.83) GL 1011 02/26/2013 Property Taxes/Assessments (116.78) (248,569.61) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (29,941.21) (248,569.61) ** (252,084.00) Budgeted (3,514.39) Remaining 99 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (5.36) .00 (5.36) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (5.36) ** (4,700.00) Budgeted (4,694.64) Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 994 02/01/2013 Property Taxes/Assessments (790,434.55) (5,228.76) (795,663.31) GL 1018 02/01/2013 Property Taxes/Assessments (15,420.76) (811,084.07) GL 995 02/02/2013 Property Taxes/Assessments (165,630.76) (976,714.83) GL 996 02/04/2013 Property Taxes/Assessments (5,008.59) (981,723.42) GL 997 02/05/2013 Property Taxes/Assessments (4,732.75) (986,456.17) GL 998 02/06/2013 Property Taxes/Assessments (11,785.57) (998,241.74) GL 999 02/07/2013 Property Taxes/Assessments (12,052.09) (1,010,293.83) GL 1000 02/08/2013 Property Taxes/Assessments (1,009.09) (1,011,302.92) GL 1001 02/11/2013 Property Taxes/Assessments (3,464.81) (1,014,767.73) GL 1002 02/12/2013 Property Taxes/Assessments (9,613.44) (1,024,381.17) GL 1004 02/13/2013 Property Taxes/Assessments (1,240.59) (1,025,621.76) GL 1005 02/14/2013 Property Taxes/Assessments (535.12) (1,026,156.88) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1006 02/15/2013 Property Taxes/Assessments (790,434.55) (1,011.56) (1,027,168.44) GL 1007 02/19/2013 Property Taxes/Assessments (29.92) (1,027,198.36) GL 1008 02/20/2013 Property Taxes/Assessments (2,689.66) (1,029,888.02) GL 1009 02/21/2013 Property Taxes/Assessments 347.99 (1,029,540.03) GL 1010 02/25/2013 Property Taxes/Assessments (37.44) (1,029,577.47) GL 1011 02/26/2013 Property Taxes/Assessments (595.87) (1,030,173.34) GL 1012 02/27/2013 Property Taxes/Assessments (75.98) (1,030,249.32) GL 1013 02/28/2013 Property Taxes/Assessments (1,260.98) (1,031,510.30) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (241,075.75) (1,031,510.30) ** (1,050,349.00) Budgeted (18,838.70) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent (3,675.62) .00 (3,675.62) _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: .00 (3,675.62) ** (5,800.00) Budgeted (2,124.38) Remaining 63 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1002 02/12/2013 Property Taxes/Assessments (1.08) (11.97) (13.05) GL 1005 02/14/2013 Property Taxes/Assessments (32.46) (45.51) GL 1006 02/15/2013 Property Taxes/Assessments (25.85) (71.36) GL 1007 02/19/2013 Property Taxes/Assessments (21.80) (93.16) GL 1008 02/20/2013 Property Taxes/Assessments (30.22) (123.38) GL 1010 02/25/2013 Property Taxes/Assessments (49.08) (172.46) GL 1011 02/26/2013 Property Taxes/Assessments (8.18) (180.64) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (179.56) (180.64) ** (750.00) Budgeted (569.36) Remaining 24 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 999 02/07/2013 Property Taxes/Assessments (1,574.28) (20.98) (1,595.26) GL 1005 02/14/2013 Property Taxes/Assessments (18.46) (1,613.72) GL 1006 02/15/2013 Property Taxes/Assessments (70.96) (1,684.68) GL 1007 02/19/2013 Property Taxes/Assessments (2.09) (1,686.77) GL 1008 02/20/2013 Property Taxes/Assessments (183.70) (1,870.47) GL 1009 02/21/2013 Property Taxes/Assessments (99.42) (1,969.89) GL 1011 02/26/2013 Property Taxes/Assessments (38.84) (2,008.73) GL 1012 02/27/2013 Property Taxes/Assessments (5.85) (2,014.58) GL 1013 02/28/2013 Property Taxes/Assessments (88.27) (2,102.85) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (528.57) (2,102.85) ** (4,500.00) Budgeted (2,397.15) Remaining 47 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (1,200.00) (1,200.00) (2,400.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (1,200.00) (2,400.00) ** (6,000.00) Budgeted (3,600.00) Remaining 40 % Used Account: 122-43400-000-000 Fire Inspections 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (225.00) (225.00) (450.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (225.00) (450.00) ** (500.00) Budgeted (50.00) Remaining 90 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49900-000-000 Miscellaneous Income 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (1,989.26) (1,575.00) (3,564.26) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,575.00) (3,564.26) ** (1,200.00) Budgeted 2,364.26 Remaining 297 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,302,458.64) ** (1,335,883.00) Budgeted (33,424.36) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 891 02/01/2013 Fire Dept Payroll 2/1/13 126,018.66 17,118.71 143,137.37 GL 893 02/15/2013 Fire Dept Payroll 2/15/13 17,266.27 160,403.64 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 34,384.98 160,403.64 ** 444,717.00 Budgeted 284,313.36 Remaining 36 % Used Account: 122-50010-045-000 Overtime 893 02/15/2013 Fire Dept Payroll 2/15/13 13,186.94 3,183.24 16,370.18 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,183.24 16,370.18 ** 31,375.00 Budgeted 15,004.82 Remaining 52 % Used Account: 122-50011-045-000 DPS Holiday Pay 12,080.51 .00 12,080.51 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 12,080.51 ** 13,083.00 Budgeted 1,002.49 Remaining 92 % Used Account: 122-50016-045-000 Longevity 4,266.11 .00 4,266.11 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,266.11 ** 4,266.00 Budgeted (.11) Remaining 100 % Used Account: 122-50017-045-000 Certification 891 02/01/2013 Fire Dept Payroll 2/1/13 2,018.25 369.00 2,387.25 GL _______________ Account: 122-50017-045-000 Certification Totals: 369.00 2,387.25 ** 4,896.00 Budgeted 2,508.75 Remaining 49 % Used Account: 122-50020-045-000 Retirement 891 02/01/2013 Fire Dept Payroll 2/1/13 22,980.06 2,358.90 25,338.96 GL 893 02/15/2013 Fire Dept Payroll 2/15/13 2,792.17 28,131.13 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,151.07 28,131.13 ** 69,242.00 Budgeted 41,110.87 Remaining 41 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 891 02/01/2013 Fire Dept Payroll 2/1/13 13,560.54 1,775.63 15,336.17 GL 893 02/15/2013 Fire Dept Payroll 2/15/13 1,775.58 17,111.75 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,551.21 17,111.75 ** 48,327.00 Budgeted 31,215.25 Remaining 35 % Used Account: 122-50027-045-000 Dental Insurance 891 02/01/2013 Fire Dept Payroll 2/1/13 1,263.22 163.67 1,426.89 GL 893 02/15/2013 Fire Dept Payroll 2/15/13 163.64 1,590.53 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 327.31 1,590.53 ** 3,635.00 Budgeted 2,044.47 Remaining 44 % Used Account: 122-50028-045-000 Vision Insurance 891 02/01/2013 Fire Dept Payroll 2/1/13 259.83 33.77 293.60 GL 893 02/15/2013 Fire Dept Payroll 2/15/13 33.75 327.35 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 67.52 327.35 ** 824.00 Budgeted 496.65 Remaining 40 % Used Account: 122-50029-045-000 Life Insurance & Other 891 02/01/2013 Fire Dept Payroll 2/1/13 1,775.80 302.71 2,078.51 GL 893 02/15/2013 Fire Dept Payroll 2/15/13 302.74 2,381.25 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 605.45 2,381.25 ** 4,250.00 Budgeted 1,868.75 Remaining 56 % Used Account: 122-50030-045-000 Social Security Taxes 891 02/01/2013 Fire Dept Payroll 2/1/13 9,735.68 988.83 10,724.51 GL 893 02/15/2013 Fire Dept Payroll 2/15/13 1,172.49 11,897.00 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,161.32 11,897.00 ** 30,897.00 Budgeted 19,000.00 Remaining 39 % Used Account: 122-50035-045-000 Medicare Taxes 891 02/01/2013 Fire Dept Payroll 2/1/13 2,276.86 231.24 2,508.10 GL 893 02/15/2013 Fire Dept Payroll 2/15/13 274.24 2,782.34 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 505.48 2,782.34 ** 7,226.00 Budgeted 4,443.66 Remaining 39 % Used Account: 122-50040-045-000 Unemployment Taxes 891 02/01/2013 Fire Dept Payroll 2/1/13 1,101.73 455.05 1,556.78 GL 893 02/15/2013 Fire Dept Payroll 2/15/13 347.00 1,903.78 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 802.05 1,903.78 ** 1,481.00 Budgeted (422.78) Remaining 129 % Used Account: 122-50045-045-000 Workman's Compensation 10,000.00 .00 10,000.00 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 875 02/13/2013 Feb A/P Psych Screening/Thomas 150.45 114.75 265.20 TOWN OF TROPHY CLUB 32246 AP 928 02/22/2013 Feb A/P CareNow Invoice #895496/Thomas 17.85 283.05 TOWN OF TROPHY CLUB 32274 AP _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: 132.60 283.05 ** 675.00 Budgeted 391.95 Remaining 42 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55045-045-000 Legal 928 02/22/2013 Feb A/P Jan Legal/Prime Const. Contrac 710.60 710.60 WHITAKER CHALK SWINDLE 32276 AP _______________ Account: 122-55045-045-000 Legal Totals: 710.60 710.60 ** .00 Budgeted (710.60) Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 875 02/13/2013 Feb A/P Air Pack testing and parts 2,316.45 1,291.50 3,607.95 MUNICIPAL EMERGENCY SERVICES 32239 AP 928 02/22/2013 Feb A/P Fire Rug Service 24.51 3,632.46 G & K SERVICES 32257 AP 928 02/22/2013 Feb A/P Fire Rug Service 24.51 3,656.97 G & K SERVICES 32257 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,340.52 3,656.97 ** 9,562.00 Budgeted 5,905.03 Remaining 38 % Used Account: 122-55090-045-000 Vehicle Maintenance 1041 02/28/2013 PCards 1/29-2/26/13 CAR SEAT COVERS 1,989.05 165.00 2,154.05 CARID.COM PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 165.00 2,154.05 ** 14,850.00 Budgeted 12,695.95 Remaining 15 % Used Account: 122-55095-045-000 Equipment Maintenance 875 02/13/2013 Feb A/P Batteries for air pack, monito 109.03 109.03 MUNICIPAL EMERGENCY SERVICES 32239 AP 928 02/22/2013 Feb A/P SCBA Cylinders 5,942.52 6,051.55 MUNICIPAL EMERGENCY SERVICES 32267 AP _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: 6,051.55 6,051.55 ** 9,808.00 Budgeted 3,756.45 Remaining 62 % Used Account: 122-55100-045-000 Building Maintenance 814 02/06/2013 Feb A/P Quarterly Pest control FD 937.00 140.00 1,077.00 GANN'S PEST CONTROL 32181 AP 928 02/22/2013 Feb A/P Jan PCards-Hurd 59.88 1,136.88 JPMORGAN CHASE BANK NA 32262 AP 928 02/22/2013 Feb A/P Jan PCards-Thomas 571.79 1,708.67 JPMORGAN CHASE BANK NA 32262 AP 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (24.51) 1,684.16 AR 1041 02/28/2013 PCards 1/29-2/26/13 UVERSE 157.83 1,841.99 ATT*BILL PAYMENT PC 1041 02/28/2013 PCards 1/29-2/26/13 UVERSE 128.68 1,970.67 ATT*BILL PAYMENT PC _______________ Account: 122-55100-045-000 Building Maintenance Totals: 1,033.67 1,970.67 ** 6,500.00 Budgeted 4,529.33 Remaining 30 % Used Account: 122-55110-045-000 Maintenance-Radios 985 02/28/2013 Feb A/P Radio Repair/Garrett 405.50 405.50 DFW COMMUNICATIONS, INC 32314 AP _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: 405.50 405.50 ** 1,103.00 Budgeted 697.50 Remaining 37 % Used Account: 122-55160-045-000 Professional Outside Services . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-60005-045-000 Telephone 875 02/13/2013 Feb A/P IT PCards 12/28-1/27 20.48 6.54 27.02 TOWN OF TROPHY CLUB 32246 AP _______________ Account: 122-60005-045-000 Telephone Totals: 6.54 27.02 ** 106.00 Budgeted 78.98 Remaining 25 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 891 02/01/2013 Fire Dept Payroll 2/1/13 1,901.02 76.50 1,977.52 GL 928 02/22/2013 Feb A/P Cell phones 10-23-12 to 11-22- 141.00 2,118.52 TOWN OF TROPHY CLUB 32274 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 217.50 2,118.52 ** 2,500.00 Budgeted 381.48 Remaining 85 % Used Account: 122-60020-045-000 Electricity/Gas 928 02/22/2013 Feb A/P Electric for 01-14-13 to 02-13 2,275.39 810.94 3,086.33 HUDSON ENERGY SERVICES, LLC 32259 AP 969 02/27/2013 Invoice Town #1009 AR 20130226-20130227 User: (405.47) 2,680.86 AR 985 02/28/2013 Feb A/P Gas Fire Station 1/17-2/18 216.94 2,897.80 ATMOS ENERGY 32307 AP 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (108.47) 2,789.33 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 513.94 2,789.33 ** 6,167.00 Budgeted 3,377.67 Remaining 45 % Used Account: 122-60025-045-000 Water 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: 546.46 (64.55) 481.91 AR _______________ Account: 122-60025-045-000 Water Totals: (64.55) 481.91 ** 1,400.00 Budgeted 918.09 Remaining 34 % Used Account: 122-60030-045-000 Rent And/Or Usage 816 02/06/2013 Fire Rent Xfer to I&S Texpool 308,000.00 308,000.00 GL _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: 308,000.00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60035-045-000 Postage 54.60 .00 54.60 _______________ Account: 122-60035-045-000 Postage Totals: .00 54.60 ** 100.00 Budgeted 45.40 Remaining 55 % Used Account: 122-60055-045-000 Insurance 10,000.00 .00 10,000.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 410.00 Budgeted 410.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 814 02/06/2013 Feb A/P 2013 dues/Chief Thomas 7,685.91 100.00 7,785.91 TARRANT COUNTY FIRE CHIEFS 32196 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 100.00 7,785.91 ** 7,500.00 Budgeted (285.91) Remaining 104 % Used Account: 122-60075-045-000 Meetings .00 .00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 .00 ** 75.00 Budgeted 75.00 Remaining 0 % Used Account: 122-60080-045-000 Schools & Training 1041 02/28/2013 PCards 1/29-2/26/13 SAFE KIDS WORLDWIDE 1,419.00 75.00 1,494.00 SAFE KIDS WORLDWIDE PC 1041 02/28/2013 PCards 1/29-2/26/13 SAFE KIDS WORLDWIDE 75.00 1,569.00 SAFE KIDS WORLDWIDE PC 1041 02/28/2013 PCards 1/29-2/26/13 NATIONAL STANDARDIZED CHILD PA 75.00 1,644.00 SAFE KIDS WORLDWIDE PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 225.00 1,644.00 ** 5,000.00 Budgeted 3,356.00 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 928 02/22/2013 Feb A/P Jan PCards 812.19 12.86 825.05 TOWN OF TROPHY CLUB 32274 AP 928 02/22/2013 Feb A/P Jan PCards-Thomas 315.36 1,140.41 JPMORGAN CHASE BANK NA 32262 AP 1041 02/28/2013 PCards 1/29-2/26/13 TEXAS FIRE CHIEFS CONF MEAL 21.49 1,161.90 GLASS PAVILION PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 349.71 1,161.90 ** 4,800.00 Budgeted 3,638.10 Remaining 24 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 122.35 .00 122.35 _______________ Account: 122-60125-045-000 Advertising Totals: .00 122.35 ** 150.00 Budgeted 27.65 Remaining 82 % Used Account: 122-60160-045-000 Programs & Special Projects 2,198.94 .00 2,198.94 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 2,198.94 ** 4,200.00 Budgeted 2,001.06 Remaining 52 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 1041 02/28/2013 PCards 1/29-2/26/13 TEXAS OURDOORS 333.73 257.70 591.43 TEXAS OURDOORS PC 1041 02/28/2013 PCards 1/29-2/26/13 CHEAPER THAN DIRT 147.54 738.97 CHEAPER THAN DIRT PC _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 405.24 738.97 ** 1,900.00 Budgeted 1,161.03 Remaining 39 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60195-045-000 Flags & Repair 985 02/28/2013 Feb A/P Symonds Inv 6082/Flag repair 224.75 435.00 659.75 TOWN OF TROPHY CLUB 32342 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 435.00 659.75 ** 2,543.00 Budgeted 1,883.25 Remaining 26 % Used Account: 122-60245-045-000 Miscellaneous Expense 928 02/22/2013 Feb A/P Jan PCards-Schultz 451.98 37.65 489.63 JPMORGAN CHASE BANK NA 32262 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 37.65 489.63 ** 1,237.00 Budgeted 747.37 Remaining 40 % Used Account: 122-65005-045-000 Fuel & Lube 1024 02/28/2013 Feb Gaslog 3,232.24 584.39 3,816.63 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 584.39 3,816.63 ** 10,000.00 Budgeted 6,183.37 Remaining 38 % Used Account: 122-65010-045-000 Uniforms 928 02/22/2013 Feb A/P Names on Jackets 845.63 28.29 873.92 RON MONTGOMERY & ASSOC INC 32272 AP 1041 02/28/2013 PCards 1/29-2/26/13 NORTHWEST TERRITORIA 17.88 891.80 NORTHWEST TERRITORIA PC 1041 02/28/2013 PCards 1/29-2/26/13 NORTHWEST TERRITORIA 23.52 915.32 NORTHWEST TERRITORIA PC _______________ Account: 122-65010-045-000 Uniforms Totals: 69.69 915.32 ** 4,357.00 Budgeted 3,441.68 Remaining 21 % Used Account: 122-65015-045-000 Protective Clothing 928 02/22/2013 Feb A/P Protective clothing- Boots for 65.00 330.00 395.00 CASCO INDUSTRIES INC 32252 AP 928 02/22/2013 Feb A/P Protection Clothing- Helmet fo 275.00 670.00 CASCO INDUSTRIES INC 32252 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 605.00 670.00 ** 7,600.00 Budgeted 6,930.00 Remaining 9 % Used Account: 122-65030-045-000 Chemicals 402.00 .00 402.00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 402.00 ** 1,000.00 Budgeted 598.00 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-65035-045-000 Small Tools 928 02/22/2013 Feb A/P Batteries and Bulbs for Flashl 257.38 385.96 643.34 DOOLEY TACKABERRY 32255 AP 1041 02/28/2013 PCards 1/29-2/26/13 STEEL 700 LB HAND TRUCK 79.97 723.31 THE HOME DEPOT 6581 PC 1041 02/28/2013 PCards 1/29-2/26/13 FUEL FOR SAWS 53.60 776.91 THE HOME DEPOT 6581 PC _______________ Account: 122-65035-045-000 Small Tools Totals: 519.53 776.91 ** 5,000.00 Budgeted 4,223.09 Remaining 16 % Used Account: 122-65085-045-000 Office Supplies 928 02/22/2013 Feb A/P Jan PCards-Schultz 80.45 22.95 103.40 JPMORGAN CHASE BANK NA 32262 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 22.95 103.40 ** 1,200.00 Budgeted 1,096.60 Remaining 9 % Used Account: 122-65095-045-000 Maintenance Supplies 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - (18.22%) 653.89 11.94 665.83 THE HOME DEPOT 6581 PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - (15.81%) 39.98 705.81 SAMSCLUB #4795 PC _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 51.92 705.81 ** 2,785.00 Budgeted 2,079.19 Remaining 25 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 106.00 Budgeted 106.00 Remaining 0 % Used Account: 122-69006-045-000 Grant Match .00 .00 _______________ Account: 122-69006-045-000 Grant Match Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal 1016 02/27/2013 Fire Engine CO Interest pmt 2,966.05 2,966.05 GL _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: 2,966.05 2,966.05 ** 72,932.00 Budgeted 69,965.95 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-69050-045-000 Radios 875 02/13/2013 Feb A/P Radio Repair 13.61 339.52 353.13 DFW COMMUNICATIONS, INC 32227 AP _______________ Account: 122-69050-045-000 Radios Totals: 339.52 353.13 ** 2,500.00 Budgeted 2,146.87 Remaining 14 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 145,598.00 Budgeted 145,598.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 636,847.29 ** 1,335,883.00 Budgeted 699,035.71 Remaining 48 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (665,611.35) .00 Budgeted 665,611.35 Remaining 0 % Used Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 2/28/2013 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 123,401 INVESTMENTS-TEXPOOL 2,073,143 INVESTMENTS-CD-BANK OF THE WEST 120,000 INVESTMENTS-CD-PROSPERITY BANK 200,000 RESTRICTED ASSETS: INVESTMENTS 432,296 PREPAID EXPENSES 981 ADVALOREM PROPERTY TAXES RECEIVABLE 4,547 UTILITY AND OTHER ACCOUNTS RECEIVABLE 575,258 TOTAL ASSETS 3,530,026$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,547$ ACCOUNTS PAYABLE 349,510 CUSTOMER DEPOSITS 218,047 TOTAL LIABILITIES 572,104 FUND BALANCE NON-SPENDABLE FUND BALANCE 2,463 ASSIGNED/WATER REPLACEMENT 90,000 ASSIGNED/TECHNOLOGY REPLACEMENT 82,359 ASSIGNED/FIRE DEPT REPLACEMENT 41,890 ASSIGNED FUND BALANCE 555,072 UNASSIGNED FUND BALANCE 2,186,138 TOTAL FUND BALANCE 2,957,922 TOTAL LIABILITIES AND FUND BALANCE 3,530,026$ February 28, 2013 5/12 Months (41.67% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,884.00- 99,884.00- 22,925.38- 98,092.61- 98.207 1,791.39- 135-40002-000-000 Property Taxes/Delinquent 500.00- 500.00- 605.50- 121.100 105.50 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 69.40- 589.56- 49.130 610.44- Subtotal: 101,584.00- 101,584.00- 22,994.78- 99,287.67- 97.739 2,296.33- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 155,074.57- 1,079,126.32- 30.436 2,466,482.68- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 119,942.04- 666,306.59- 40.291 987,440.41- 135-47020-000-000 Standby 576.00- 576.00- 149.90- 26.024 426.10- 135-47025-000-000 Penalties 64,580.00- 64,580.00- 3,821.91- 23,095.03- 35.762 41,484.97- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 1,178.00- 5,581.52- 48.013 6,043.48- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 50.00- 300.00- 16.667 1,500.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 150.00- 1,350.00- 25.962 3,850.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 12,578.15- 16.214 64,996.85- 135-47400-000-000 Water-Out of Dist/Port Meters 27.19- 27.19- 27.19 Subtotal: 5,360,712.00- 5,360,712.00- 280,243.71- 1,788,514.70- 33.363 3,572,197.30- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 25,300.00- 142,600.00- 22.143 501,400.00- Subtotal: 644,000.00- 644,000.00- 25,300.00- 142,600.00- 22.143 501,400.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 322.94- 2,400.82- 43.651 3,099.18- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 4,489.12- 44.167 5,674.88- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 2,333.32- 33.333 4,666.68- 135-49030-000-000 Vending Revenue 350.00- 350.00- 32.84- 9.383 317.16- 135-49035-000-000 Prior Year Reserves 305,748.00- 305,748.00- 305,748.00- 135-49075-000-000 Oversize Meter Reimbursement 73,000.00- 73,000.00- 4,438.00- 22,383.00- 30.662 50,617.00- 135-49900-000-000 Miscellaneous Income 1,000.00- 1,000.00- 1,954.00- 8,077.42- 807.742 7,077.42 135-49901-000-000 Records Management Revenue 109.00- 109.00 135-49905-000-000 Gas Well Revenue 200.00- 200.00- 132.05- 286.02- 143.010 86.02 Subtotal: 402,962.00- 402,962.00- 7,757.52- 40,111.54- 9.954 362,850.46- Program number: 6,509,258.00- 6,509,258.00- 336,296.01- 2,070,513.91- 31.809 4,438,744.09- Department number: Revenues 6,509,258.00- 6,509,258.00- 336,296.01- 2,070,513.91- 31.809 4,438,744.09- Revenues Subtotal ----------- 6,509,258.00- 6,509,258.00- 336,296.01- 2,070,513.91- 31.809 4,438,744.09- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 213,321.00 213,321.00 13,030.86 61,129.32 28.656 152,191.68 135-50010-010-000 Overtime 13,250.00 13,250.00 631.34 6,567.63 49.567 6,682.37 135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 1,875.00 36.765 3,225.00 135-50020-010-000 Retirement 32,725.00 32,725.00 1,226.87 34,712.58 106.074 1,987.58- 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 2,113.96 9,279.68 32.087 19,640.32 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 145.51 689.36 32.968 1,401.64 135-50028-010-000 Vision Insurance 519.00 519.00 33.91 162.98 31.403 356.02 135-50029-010-000 Life Insurance & Other 1,204.00 1,204.00 88.45 677.80 56.296 526.20 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 826.76 4,661.54 32.027 9,893.46 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 193.33 1,090.19 32.027 2,313.81 135-50040-010-000 Unemployment Taxes 945.00 945.00 261.16 27.636 683.84 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 11,444.00 187.330 5,335.00- 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 82.65 82.65 23.614 267.35 Subtotal: 325,773.00 325,773.00 18,373.64 135,713.89 41.659 190,059.11 135-55005-010-000 Engineering 3,000.00 3,000.00 3,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 3,244.66 17,572.10 35.144 32,427.90 135-55090-010-000 Vehicle Maintenance 3,700.00 3,700.00 1,626.70 2,311.28 62.467 1,388.72 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 1,767.04 60.932 1,132.96 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 496.19 2,451.34 54.474 2,048.66 Subtotal: 64,100.00 64,100.00 5,367.55 24,101.76 37.600 39,998.24 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 175.44 527.65 26.383 1,472.35 135-60020-010-000 Electricity 162,410.00 162,410.00 7,175.96 40,271.75 24.796 122,138.25 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 100.000 135-60080-010-000 Schools & Training 1,672.00 1,672.00 351.00 20.993 1,321.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 700.00 700.00 551.69 78.813 148.31 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 TCEQ Fees & Permits 35,800.00 35,800.00 40,524.75 113.198 4,724.75- 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 81,525.57 499,848.97 24.642 1,528,598.03 135-60245-010-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 140.25 488.95 11.642 3,711.05 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 38.99 2.599 1,461.01 Subtotal: 2,239,129.00 2,239,129.00 89,017.22 582,753.75 26.026 1,656,375.25 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 966.38 4,726.98 26.765 12,934.02 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 2,680.00 2,680.00 1,617.82 60.366 1,062.18 135-65030-010-000 Chemicals 6,200.00 6,200.00 473.79 1,805.57 29.122 4,394.43 135-65035-010-000 Small Tools 1,500.00 1,500.00 267.19 17.813 1,232.81 135-65040-010-000 Safety Equipment 2,000.00 2,000.00 256.82 256.82 12.841 1,743.18 135-65050-010-000 Meter Expense 143,550.00 143,550.00 97,393.00 67.846 46,157.00 135-65085-010-000 Office Supplies 109.68 109.68 109.68- Subtotal: 173,591.00 173,591.00 1,806.67 106,177.06 61.165 67,413.94 135-69005-010-000 Capital Expenses 181,800.00 181,800.00 3,145.00 3,145.00 1.730 178,655.00 135-69008-010-000 Short Term Debt-Principal 387,037.00 387,037.00 387,037.00 135-69009-010-000 Short Term Debt-Interest 10,376.98 10,376.98 10,376.98- 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 270,000.00 270,000.00 59,869.00 22.174 210,131.00 135-69281-010-000 Capital Repair-Ground Storage 150,000.00 150,000.00 100,816.54 67.211 49,183.46 Subtotal: 1,018,837.00 1,018,837.00 13,521.98 174,207.52 17.099 844,629.48 Program number: 3,821,430.00 3,821,430.00 128,087.06 1,022,953.98 26.769 2,798,476.02 Department number: Water 3,821,430.00 3,821,430.00 128,087.06 1,022,953.98 26.769 2,798,476.02 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 196,781.00 196,781.00 14,404.94 67,419.34 34.261 129,361.66 135-50010-020-000 Overtime 10,166.00 10,166.00 951.50 5,827.89 57.327 4,338.11 135-50016-020-000 Longevity 2,858.00 2,858.00 2,857.50 99.983 .50 135-50017-020-000 Certification 4,200.00 4,200.00 1,750.00 41.667 2,450.00 135-50020-020-000 Retirement 29,821.00 29,821.00 1,379.01 35,296.48 118.361 5,475.48- 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 3,293.23 13,568.36 46.733 15,465.64 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 226.46 978.94 46.351 1,133.06 135-50028-020-000 Vision Insurance 552.00 552.00 57.40 252.56 45.754 299.44 135-50029-020-000 Life Insurance & Other 920.00 920.00 99.29 743.45 80.810 176.55 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 810.57 4,320.73 32.565 8,947.27 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 189.56 1,010.48 32.565 2,092.52 135-50040-020-000 Unemployment Taxes 756.00 756.00 273.05 36.118 482.95 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 7,853.00 267.200 4,914.00- 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 150.00 135-50070-020-000 Employee Relations 350.00 350.00 62.37 62.37 17.820 287.63 Subtotal: 297,010.00 297,010.00 21,474.33 142,214.15 47.882 154,795.85 135-55070-020-000 Independent Labor 1,000.00 1,000.00 34,875.00 3,487.500 33,875.00- 135-55080-020-000 Maintenance & Repairs 40,000.00 40,000.00 3,702.85 34,893.61 87.234 5,106.39 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 2,537.95 3,700.93 185.047 1,700.93- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,080.96 72.064 419.04 135-55125-020-000 Dumpster Services 15,000.00 15,000.00 5,161.32 21,536.94 143.580 6,536.94- 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 3,270.50 10,608.50 35.362 19,391.50 Subtotal: 89,500.00 89,500.00 14,672.62 106,695.94 119.213 17,195.94- 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 2,700.00 233.43 746.54 27.650 1,953.46 135-60020-020-000 Electricity 153,045.00 153,045.00 12,139.80 51,453.88 33.620 101,591.12 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 161.45 32.290 338.55 135-60080-020-000 Schools & Training 3,272.00 3,272.00 445.00 660.66 20.191 2,611.34 135-60090-020-000 Safety Program 250.00 250.00 250.00 135-60100-020-000 Travel & per diem 1,400.00 1,400.00 816.27 58.305 583.73 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 1,020.00 68.000 480.00 135-60125-020-000 Advertising 2,000.00 2,000.00 112.50 112.50 5.625 1,887.50 135-60135-020-000 TCEQ Fees & Permits 56,000.00 56,000.00 157.39 7,887.19 14.084 48,112.81 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 148.10 74.050 51.90 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 345.15 69.030 154.85 Subtotal: 221,367.00 221,367.00 13,088.12 63,351.74 28.618 158,015.26 135-65005-020-000 Fuel & Lube 8,527.00 8,527.00 1,223.98 5,205.31 61.045 3,321.69 135-65010-020-000 Uniforms 2,574.00 2,574.00 773.70 30.058 1,800.30 135-65030-020-000 Chemicals 10,000.00 10,000.00 3,320.00 18,345.52 183.455 8,345.52- . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-020-000 Small Tools 1,000.00 1,000.00 139.43 333.47 33.347 666.53 135-65040-020-000 Safety Equipment 250.00 250.00 387.07 452.14 180.856 202.14- 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 1,480.75 7,585.54 75.855 2,414.46 Subtotal: 32,351.00 32,351.00 6,551.23 32,695.68 101.065 344.68- 135-69005-020-000 Capital Expenses 241,200.00 241,200.00 4,289.00 404,374.29 167.651 163,174.29- 135-69280-020-000 Capital Repairs 158,000.00 158,000.00 158,000.00 Subtotal: 399,200.00 399,200.00 4,289.00 404,374.29 101.296 5,174.29- Program number: 1,039,428.00 1,039,428.00 60,075.30 749,331.80 72.091 290,096.20 Department number: Wastewater 1,039,428.00 1,039,428.00 60,075.30 749,331.80 72.091 290,096.20 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 156,475.00 156,475.00 11,545.78 54,019.98 34.523 102,455.02 135-50010-021-000 Overtime 7,297.00 7,297.00 329.19 4,380.33 60.029 2,916.67 135-50016-021-000 Longevity 3,818.00 3,818.00 3,817.50 99.987 .50 135-50017-021-000 Certification 1,800.00 1,800.00 700.00 38.889 1,100.00 135-50020-021-000 Retirement 23,574.00 23,574.00 1,066.37 27,660.12 117.333 4,086.12- 135-50026-021-000 Medical Insurance 20,198.00 20,198.00 2,321.55 9,692.34 47.987 10,505.66 135-50027-021-000 Dental Insurance 1,409.00 1,409.00 159.88 693.20 49.198 715.80 135-50028-021-000 Vision Insurance 357.00 357.00 32.60 154.32 43.227 202.68 135-50029-021-000 Life Insurance & Other 1,008.00 1,008.00 63.86 546.47 54.213 461.53 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 668.85 3,808.63 36.266 6,693.37 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 156.43 890.71 36.267 1,565.29 135-50040-021-000 Unemployment Taxes 567.00 567.00 214.27 37.790 352.73 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 7,139.00 213.232 3,791.00- 135-50070-021-000 Employee Relations 250.00 250.00 42.91 59.69 23.876 190.31 Subtotal: 233,059.00 233,059.00 16,387.42 113,776.56 48.819 119,282.44 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 35,000.00 1,191.84 1,445.93 4.131 33,554.07 135-55090-021-000 Vehicle Maintenance 1,900.00 1,900.00 41.85 310.23 16.328 1,589.77 Subtotal: 38,400.00 38,400.00 1,233.69 1,756.16 4.573 36,643.84 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 217.27 928.47 26.528 2,571.53 135-60020-021-000 Electricity 18,705.00 18,705.00 1,331.35 6,677.90 35.701 12,027.10 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 100.000 135-60080-021-000 Schools & Training 826.00 826.00 445.00 830.00 100.484 4.00- 135-60090-021-000 Safety Program 500.00 500.00 500.00 135-60100-021-000 Travel & per diem 450.00 450.00 295.33 65.629 154.67 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 34,331.00 34,331.00 1,993.62 8,981.70 26.162 25,349.30 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 1,211.28 4,701.64 38.802 7,415.36 135-65010-021-000 Uniforms 2,220.00 2,220.00 934.13 42.078 1,285.87 135-65030-021-000 Chemicals 7,500.00 7,500.00 2,221.00 2,221.00 29.613 5,279.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 70.00 4.667 1,430.00 135-65040-021-000 Safety Equipment 500.00 500.00 120.00 120.00 24.000 380.00 Subtotal: 23,837.00 23,837.00 3,552.28 8,046.77 33.757 15,790.23 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 90,000.00 135-69008-021-000 Short Term Debt-Principal 40,260.00 40,260.00 40,260.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 130,260.00 130,260.00 130,260.00 Program number: 459,887.00 459,887.00 23,167.01 132,561.19 28.825 327,325.81 Department number: Collection 459,887.00 459,887.00 23,167.01 132,561.19 28.825 327,325.81 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 900.00 3,000.00 30.000 7,000.00 135-50030-026-000 Social Security Taxes 620.00 620.00 55.80 186.00 30.000 434.00 135-50035-026-000 Medicare Taxes 145.00 145.00 13.05 43.50 30.000 101.50 135-50040-026-000 Unemployment Taxes 210.00 210.00 60.90 29.000 149.10 135-50045-026-000 Workman's Compensation 150.00 150.00 15.70 10.467 134.30 Subtotal: 11,125.00 11,125.00 968.85 3,306.10 29.718 7,818.90 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 7.00 42.00 2.000 2,058.00 135-60075-026-000 Meetings 1,200.00 1,200.00 22.00 244.97 20.414 955.03 135-60080-026-000 Schools & Training 4,000.00 4,000.00 345.00 925.00 23.125 3,075.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 510.28- 510.28 10.206 4,489.72 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 192.44 252.44 8.415 2,747.56 Subtotal: 15,450.00 15,450.00 56.16 1,974.69 12.781 13,475.31 Program number: 26,575.00 26,575.00 1,025.01 5,280.79 19.871 21,294.21 Department number: Board of Directors 26,575.00 26,575.00 1,025.01 5,280.79 19.871 21,294.21 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 444,730.00 444,730.00 32,532.75 158,845.46 35.717 285,884.54 135-50010-030-000 Overtime 1,500.00 1,500.00 13.48 157.66 10.511 1,342.34 135-50016-030-000 Longevity 2,193.00 2,193.00 2,317.50 105.677 124.50- 135-50020-030-000 Retirement 60,441.00 60,441.00 2,922.67 64,999.88 107.543 4,558.88- 135-50026-030-000 Medical Insurance 44,066.00 44,066.00 4,388.10 18,332.10 41.601 25,733.90 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 386.34 1,638.84 48.501 1,740.16 135-50028-030-000 Vision Insurance 795.00 795.00 82.53 363.58 45.733 431.42 135-50029-030-000 Life Insurance & Other 2,500.00 2,500.00 171.71 1,378.30 55.132 1,121.70 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,873.18 9,703.37 34.902 18,098.63 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 438.08 2,269.34 34.902 4,232.66 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 891.41 57.997 645.59 135-50045-030-000 Workman's Compensation 831.00 831.00 1,539.00 185.199 708.00- 135-50060-030-000 Pre-emp Physicals/Testing 250.00 250.00 39.00 15.600 211.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 84.21 2,621.68 52.434 2,378.32 Subtotal: 601,526.00 601,526.00 42,893.05 265,097.12 44.071 336,428.88 135-55030-030-000 Software & Support 63,555.00 63,555.00 1,839.94 16,309.86 25.663 47,245.14 135-55070-030-000 Independent Labor 2,700.00 2,700.00 67.50 187.50 6.944 2,512.50 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55100-030-000 Building Maint & Supplies 5,000.00 5,000.00 624.41 2,862.49 57.250 2,137.51 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,678.51 8,840.23 43.764 11,359.77 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 6,825.00 45.500 8,175.00 135-55161-030-000 Outside Services-Town Semo 85,465.00 85,465.00 25,147.00 85,465.00 100.000 135-55165-030-000 Collection Fees 159.77 159.77- 135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 860.63 2,959.38 26.903 8,040.62 Subtotal: 203,420.00 203,420.00 30,217.99 123,609.23 60.766 79,810.77 135-60005-030-000 Telephone 9,000.00 9,000.00 928.24 3,530.41 39.227 5,469.59 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 196.96 1,301.04 36.393 2,273.96 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 1,540.22 4,552.11 34.965 8,466.89 135-60025-030-000 Water 3,100.00 3,100.00 52.11- 336.63 10.859 2,763.37 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 515.18 4,325.89 32.817 8,856.11 135-60035-030-000 Postage 23,000.00 23,000.00 1,645.98 11,788.94 51.256 11,211.06 135-60040-030-000 Service Charges & Fees 18,000.00 18,000.00 2,177.63 12,191.77 67.732 5,808.23 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 610.03- 85.44 1.005 8,414.56 135-60055-030-000 Insurance 35,000.00 35,000.00 50.00 50,693.77 144.839 15,693.77- 135-60066-030-000 Publications/Books/Subscripts 750.00 750.00 558.22 74.429 191.78 135-60070-030-000 Dues & Memberships 2,400.00 2,400.00 3,891.95 162.165 1,491.95- 135-60075-030-000 Meetings 250.00 250.00 52.85 206.74 82.696 43.26 135-60080-030-000 Schools & Training 5,500.00 5,500.00 1,275.00 1,845.00 33.545 3,655.00 135-60100-030-000 Travel & per diem 3,950.00 3,950.00 52.32 746.51 18.899 3,203.49 135-60110-030-000 Physicals/Testing 500.00 500.00 500.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 4,000.00 4,000.00 4,000.00 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 15,000.00 15,000.00 122.70 .818 14,877.30 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60281-030-000 Park Expenses 3,984.13 20,414.85 20,414.85- 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,325.00 93.000 175.00 Subtotal: 173,076.00 173,076.00 11,756.37 118,916.97 68.708 54,159.03 135-65010-030-000 Uniforms 1,635.00 1,635.00 624.12 38.172 1,010.88 135-65055-030-000 Hardware 20,188.00 20,188.00 10,430.22 51.665 9,757.78 135-65085-030-000 Office Supplies 8,200.00 8,200.00 762.60 3,291.22 40.137 4,908.78 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 458.40 1,358.40 23.699 4,373.60 135-65095-030-000 Maintenance Supplies 2,000.00 2,000.00 303.49 1,018.65 50.933 981.35 135-65097-030-000 Vending Machine Supplies 500.00 500.00 500.00 135-65105-030-000 Printing 5,200.00 5,200.00 395.00 7.596 4,805.00 Subtotal: 43,455.00 43,455.00 1,524.49 17,117.61 39.392 26,337.39 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 1,284.25 37.225 2,165.75 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 1,284.25 4.230 29,076.75 Program number: 1,051,838.00 1,051,838.00 86,391.90 526,025.18 50.010 525,812.82 Department number: Administration 1,051,838.00 1,051,838.00 86,391.90 526,025.18 50.010 525,812.82 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 18:34 03/12/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 70,000.00 70,000.00 41,700.93 96,875.82 138.394 26,875.82- 135-55055-039-000 Auditing 21,200.00 21,200.00 5,175.00 20,700.00 97.642 500.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 4,265.90 28.251 10,834.10 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,340.98 61.605 1,459.02 Subtotal: 110,100.00 110,100.00 46,875.93 124,182.70 112.791 14,082.70- 135-60344-039-000 Intergov Trans Out (Fire CIP) 86,726.39 86,726.39 86,726.39- Subtotal: 86,726.39 86,726.39 86,726.39- Program number: 110,100.00 110,100.00 133,602.32 210,909.09 191.561 100,809.09- Department number: Non Departmental 110,100.00 110,100.00 133,602.32 210,909.09 191.561 100,809.09- Expenditures Subtotal ----------- 6,509,258.00 6,509,258.00 432,348.60 2,647,062.03 40.666 3,862,195.97 Fund number: 135 MUD 1 General Fund 96,052.59 576,548.12 576,548.12- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 994 02/01/2013 Property Taxes/Assessments (75,167.23) (497.24) (75,664.47) GL 1018 02/01/2013 Property Taxes/Assessments (1,466.45) (77,130.92) GL 995 02/02/2013 Property Taxes/Assessments (15,750.85) (92,881.77) GL 996 02/04/2013 Property Taxes/Assessments (476.30) (93,358.07) GL 997 02/05/2013 Property Taxes/Assessments (450.07) (93,808.14) GL 998 02/06/2013 Property Taxes/Assessments (1,120.76) (94,928.90) GL 999 02/07/2013 Property Taxes/Assessments (1,146.11) (96,075.01) GL 1000 02/08/2013 Property Taxes/Assessments (95.96) (96,170.97) GL 1001 02/11/2013 Property Taxes/Assessments (329.49) (96,500.46) GL 1002 02/12/2013 Property Taxes/Assessments (914.20) (97,414.66) GL 1004 02/13/2013 Property Taxes/Assessments (117.97) (97,532.63) GL 1005 02/14/2013 Property Taxes/Assessments (50.89) (97,583.52) GL 1006 02/15/2013 Property Taxes/Assessments (96.19) (97,679.71) GL 1007 02/19/2013 Property Taxes/Assessments (2.85) (97,682.56) GL 1008 02/20/2013 Property Taxes/Assessments (255.78) (97,938.34) GL 1009 02/21/2013 Property Taxes/Assessments 33.09 (97,905.25) GL 1010 02/25/2013 Property Taxes/Assessments (3.56) (97,908.81) GL 1011 02/26/2013 Property Taxes/Assessments (56.66) (97,965.47) GL 1012 02/27/2013 Property Taxes/Assessments (7.23) (97,972.70) GL 1013 02/28/2013 Property Taxes/Assessments (119.91) (98,092.61) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (22,925.38) (98,092.61) ** (99,884.00) Budgeted (1,791.39) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent (605.50) .00 (605.50) _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: .00 (605.50) ** (500.00) Budgeted 105.50 Remaining 121 % Used Account: 135-40015-000-000 Property Taxes/P & I 996 02/04/2013 Property Taxes/Assessments (520.16) 2.58 (517.58) GL 999 02/07/2013 Property Taxes/Assessments (1.99) (519.57) GL 999 02/07/2013 Property Taxes/Assessments (8.97) (528.54) GL 1000 02/08/2013 Property Taxes/Assessments (10.18) (538.72) GL 1005 02/14/2013 Property Taxes/Assessments (1.75) (540.47) GL 1006 02/15/2013 Property Taxes/Assessments (6.75) (547.22) GL 1006 02/15/2013 Property Taxes/Assessments (2.58) (549.80) GL 1007 02/19/2013 Property Taxes/Assessments (.19) (549.99) GL 1008 02/20/2013 Property Taxes/Assessments (17.47) (567.46) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1009 02/21/2013 Property Taxes/Assessments (520.16) (9.45) (576.91) GL 1011 02/26/2013 Property Taxes/Assessments (3.70) (580.61) GL 1012 02/27/2013 Property Taxes/Assessments (.55) (581.16) GL 1013 02/28/2013 Property Taxes/Assessments (8.40) (589.56) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (69.40) (589.56) ** (1,200.00) Budgeted (610.44) Remaining 49 % Used Account: 135-47000-000-000 Water 864 02/11/2013 UB 02/11/2013 Adjustments UB20130211-20130211 User: (924,051.75) 11.65 (924,040.10) UB 970 02/14/2013 UB 2/14/13 Adjustments UB20130214-20130214 User: 473.64 (923,566.46) UB 963 02/28/2013 UB 2/28/13 Billing UB20130228-20130228 User: (155,559.86) (1,079,126.32) UB _______________ Account: 135-47000-000-000 Water Totals: (155,074.57) (1,079,126.32) ** (3,545,609.00) Budgeted (2,466,482.68) Remaining 30 % Used Account: 135-47005-000-000 Sewer 864 02/11/2013 UB 02/11/2013 Adjustments UB20130211-20130211 User: (546,364.55) 10.00 (546,354.55) UB 970 02/14/2013 UB 2/14/13 Adjustments UB20130214-20130214 User: 25.84 (546,328.71) UB 963 02/28/2013 UB 2/28/13 Billing UB20130228-20130228 User: (119,977.88) (666,306.59) UB _______________ Account: 135-47005-000-000 Sewer Totals: (119,942.04) (666,306.59) ** (1,653,747.00) Budgeted (987,440.41) Remaining 40 % Used Account: 135-47020-000-000 Standby (149.90) .00 (149.90) _______________ Account: 135-47020-000-000 Standby Totals: .00 (149.90) ** (576.00) Budgeted (426.10) Remaining 26 % Used Account: 135-47025-000-000 Penalties 864 02/11/2013 UB 02/11/2013 Adjustments UB20130211-20130211 User: (19,273.12) 11.44 (19,261.68) UB 923 02/21/2013 UB 2/21/13 Penalties UB20130221-20130221 User: (3,742.89) (23,004.57) UB 971 02/21/2013 UB 2/21/13 Adjustments UB20130221-20130221 User: 9.85 (22,994.72) UB 956 02/27/2013 UB 02/27/2013 Adjustments UB20130227-20130227 User: 52.96 (22,941.76) UB 963 02/28/2013 UB 2/28/13 Billing UB20130228-20130228 User: (153.27) (23,095.03) UB _______________ Account: 135-47025-000-000 Penalties Totals: (3,821.91) (23,095.03) ** (64,580.00) Budgeted (41,484.97) Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 809 02/06/2013 UB 2/6/13 Cut Off List Fees UB20130206-20130206 User: (4,403.52) (775.00) (5,178.52) UB 857 02/07/2013 UB 2/7/13 After Hours Fee UB20130207-20130207 User: (400.00) (5,578.52) UB 873 02/08/2013 UB 2/8/13 NSF Check Fee UB20130208-20130208 User: (25.00) (5,603.52) UB 963 02/28/2013 UB 2/28/13 Billing UB20130228-20130228 User: 22.00 (5,581.52) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,178.00) (5,581.52) ** (11,625.00) Budgeted (6,043.48) Remaining 48 % Used Account: 135-47035-000-000 Plumbing Inspections 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (250.00) (50.00) (300.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (50.00) (300.00) ** (1,800.00) Budgeted (1,500.00) Remaining 17 % Used Account: 135-47045-000-000 Sewer Inspections 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (1,200.00) (150.00) (1,350.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (1,350.00) ** (5,200.00) Budgeted (3,850.00) Remaining 26 % Used Account: 135-47070-000-000 TCCC Effluent Charges (12,578.15) .00 (12,578.15) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (12,578.15) ** (77,575.00) Budgeted (64,996.85) Remaining 16 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 963 02/28/2013 UB 2/28/13 Billing UB20130228-20130228 User: (27.19) (27.19) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (27.19) (27.19) ** .00 Budgeted 27.19 Remaining 0 % Used Account: 135-48005-000-000 Utility Fees 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (117,300.00) (25,300.00) (142,600.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (25,300.00) (142,600.00) ** (644,000.00) Budgeted (501,400.00) Remaining 22 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49010-000-000 Interest Income 988 02/28/2013 Feb Bank Interest (2,077.88) (270.23) (2,348.11) GL 988 02/28/2013 Feb Bank Interest (52.71) (2,400.82) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (322.94) (2,400.82) ** (5,500.00) Budgeted (3,099.18) Remaining 44 % Used Account: 135-49016-000-000 Cell Tower Revenue 964 02/15/2013 AT&T Cell Tower Lease (3,578.59) (910.53) (4,489.12) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (4,489.12) ** (10,164.00) Budgeted (5,674.88) Remaining 44 % Used Account: 135-49018-000-000 Building Rent Income (2,333.32) .00 (2,333.32) _______________ Account: 135-49018-000-000 Building Rent Income Totals: .00 (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 % Used Account: 135-49030-000-000 Vending Revenue (32.84) .00 (32.84) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (32.84) ** (350.00) Budgeted (317.16) Remaining 9 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (305,748.00) Budgeted (305,748.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (17,945.00) (4,438.00) (22,383.00) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,438.00) (22,383.00) ** (73,000.00) Budgeted (50,617.00) Remaining 31 % Used Account: 135-49900-000-000 Miscellaneous Income . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 965 02/15/2013 Sendera Title-filing fee refun (6,123.42) (4.00) (6,127.42) GL 967 02/28/2013 TML-Insurance claim (1,950.00) (8,077.42) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,954.00) (8,077.42) ** (1,000.00) Budgeted 7,077.42 Remaining 808 % Used Account: 135-49901-000-000 Records Management Revenue (109.00) .00 (109.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (109.00) ** .00 Budgeted 109.00 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue 966 02/28/2013 Vantage Energy-gas well rev (153.97) (132.05) (286.02) GL _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: (132.05) (286.02) ** (200.00) Budgeted 86.02 Remaining 143 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,070,513.91) ** (6,509,258.00) Budgeted (4,438,744.09) Remaining 32 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 730 02/01/2013 2/1/13 Payroll Salaries & Wages 48,098.46 6,515.43 54,613.89 PR 853 02/15/2013 Payroll 2/15/13 Salaries & Wages 6,515.43 61,129.32 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 13,030.86 61,129.32 ** 213,321.00 Budgeted 152,191.68 Remaining 29 % Used Account: 135-50010-010-000 Overtime 730 02/01/2013 2/1/13 Payroll Overtime 5,936.29 466.25 6,402.54 PR 853 02/15/2013 Payroll 2/15/13 Overtime 165.09 6,567.63 PR _______________ Account: 135-50010-010-000 Overtime Totals: 631.34 6,567.63 ** 13,250.00 Budgeted 6,682.37 Remaining 50 % Used Account: 135-50016-010-000 Longevity 3,080.00 .00 3,080.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,080.00 ** 3,080.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1,875.00 .00 1,875.00 _______________ Account: 135-50017-010-000 Certification Totals: .00 1,875.00 ** 5,100.00 Budgeted 3,225.00 Remaining 37 % Used Account: 135-50020-010-000 Retirement 730 02/01/2013 2/1/13 Payroll Retirement 33,485.71 626.95 34,112.66 PR 853 02/15/2013 Payroll 2/15/13 Retirement 599.92 34,712.58 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,226.87 34,712.58 ** 32,725.00 Budgeted (1,987.58) Remaining 106 % Used Account: 135-50026-010-000 Medical Insurance 730 02/01/2013 2/1/13 Payroll Medical Insurance 7,165.72 1,057.00 8,222.72 PR 853 02/15/2013 Payroll 2/15/13 Medical Insurance 1,056.96 9,279.68 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,113.96 9,279.68 ** 28,920.00 Budgeted 19,640.32 Remaining 32 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 730 02/01/2013 2/1/13 Payroll Dental Insurance 543.85 72.76 616.61 PR 853 02/15/2013 Payroll 2/15/13 Dental Insurance 72.75 689.36 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 145.51 689.36 ** 2,091.00 Budgeted 1,401.64 Remaining 33 % Used Account: 135-50028-010-000 Vision Insurance 730 02/01/2013 2/1/13 Payroll Vision Insurance 129.07 16.96 146.03 PR 853 02/15/2013 Payroll 2/15/13 Vision Insurance 16.95 162.98 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 33.91 162.98 ** 519.00 Budgeted 356.02 Remaining 31 % Used Account: 135-50029-010-000 Life Insurance & Other 730 02/01/2013 2/1/13 Payroll Life Insurance & Other 589.35 72.70 662.05 PR 928 02/22/2013 Feb A/P Monthy FSA Admin 15.75 677.80 Discovery Benefits 32254 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 88.45 677.80 ** 1,204.00 Budgeted 526.20 Remaining 56 % Used Account: 135-50030-010-000 Social Security Taxes 730 02/01/2013 2/1/13 Payroll Social Security Taxes 3,834.78 423.42 4,258.20 PR 853 02/15/2013 Payroll 2/15/13 Social Security Taxes 403.34 4,661.54 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 826.76 4,661.54 ** 14,555.00 Budgeted 9,893.46 Remaining 32 % Used Account: 135-50035-010-000 Medicare Taxes 730 02/01/2013 2/1/13 Payroll Medicare Taxes 896.86 99.01 995.87 PR 853 02/15/2013 Payroll 2/15/13 Medicare Taxes 94.32 1,090.19 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 193.33 1,090.19 ** 3,404.00 Budgeted 2,313.81 Remaining 32 % Used Account: 135-50040-010-000 Unemployment Taxes 261.16 .00 261.16 . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 261.16 ** 945.00 Budgeted 683.84 Remaining 28 % Used Account: 135-50045-010-000 Workman's Compensation 11,444.00 .00 11,444.00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 11,444.00 ** 6,109.00 Budgeted (5,335.00) Remaining 187 % 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 928 02/22/2013 Feb A/P Jan PCards-Womack 31.24 31.24 JPMORGAN CHASE BANK NA 32262 AP 1041 02/28/2013 PCards 1/29-2/26/13 TOM THUMB STOR00017897 8.50 39.74 TOM THUMB STOR00017897 PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070010 (25%) 15.92 55.66 FUZZY'S TACO SHOP PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070010 (25%) 1.99 57.65 WM SUPERCENTER#5247 PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070010 (25%) 25.00 82.65 VINNYS ITALIAN RESTAUR PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 82.65 82.65 ** 350.00 Budgeted 267.35 Remaining 24 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 875 02/13/2013 Feb A/P Brass Bushing/Trophy Wood Irri 14,327.44 28.18 14,355.62 HD SUPPLY WATERWORKS, LTD. 32233 AP 875 02/13/2013 Feb A/P Trophy Wood Irrigation Meter 702.68 15,058.30 HD SUPPLY WATERWORKS, LTD. 32233 AP 928 02/22/2013 Feb A/P 2" Threaded Gate Valve 224.08 15,282.38 HD SUPPLY WATERWORKS, LTD. 32258 AP 928 02/22/2013 Feb A/P Brass fitting for water dept 220.92 15,503.30 HD SUPPLY WATERWORKS, LTD. 32258 AP 928 02/22/2013 Feb A/P Jan PCards-Beck 81.00 15,584.30 JPMORGAN CHASE BANK NA 32262 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 928 02/22/2013 Feb A/P Jan PCards-McMahon 14,327.44 369.74 15,954.04 JPMORGAN CHASE BANK NA 32262 AP 928 02/22/2013 Feb A/P Jan PCards-Womack 1,010.53 16,964.57 JPMORGAN CHASE BANK NA 32262 AP 985 02/28/2013 Feb A/P Water line/WWTP 287.48 17,252.05 ROANOKE WINNELSON CO. 32336 AP 1041 02/28/2013 PCards 1/29-2/26/13 JOHN DEERE LANDSCAPES2 100.15 17,352.20 JOHN DEERE LANDSCAPES2 PC 1041 02/28/2013 PCards 1/29-2/26/13 JOHN DEERE LANDSCAPES2 (340.15) 17,012.05 JOHN DEERE LANDSCAPES2 PC 1041 02/28/2013 PCards 1/29-2/26/13 JOHN DEERE LANDSCAPES2 410.00 17,422.05 JOHN DEERE LANDSCAPES2 PC 1041 02/28/2013 PCards 1/29-2/26/13 JOHN DEERE LANDSCAPES2 76.49 17,498.54 JOHN DEERE LANDSCAPES2 PC 1041 02/28/2013 PCards 1/29-2/26/13 THE HOME DEPOT 6581 62.91 17,561.45 THE HOME DEPOT 6581 PC 1041 02/28/2013 PCards 1/29-2/26/13 CRAFTMARK PRODUCTS INC 10.65 17,572.10 CRAFTMARK PRODUCTS INC PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 3,244.66 17,572.10 ** 50,000.00 Budgeted 32,427.90 Remaining 35 % Used Account: 135-55090-010-000 Vehicle Maintenance 928 02/22/2013 Feb A/P Tires for dump truck 684.58 1,426.75 2,111.33 BLAGG TIRE & SERVICE 32250 AP 1041 02/28/2013 PCards 1/29-2/26/13 AUTOZONE #4206 199.95 2,311.28 AUTOZONE #4206 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,626.70 2,311.28 ** 3,700.00 Budgeted 1,388.72 Remaining 62 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,767.04 .00 1,767.04 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,767.04 ** 2,900.00 Budgeted 1,132.96 Remaining 61 % Used Account: 135-55135-010-000 Lab Analysis 875 02/13/2013 Feb A/P Lab analysis 1,955.15 280.00 2,235.15 TARRANT CTY PUBLIC HEALTH LAB 32244 AP 875 02/13/2013 Feb A/P Water test 216.19 2,451.34 LOWER COLORADO RIVER AUTHORITY 32238 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 496.19 2,451.34 ** 4,500.00 Budgeted 2,048.66 Remaining 54 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 928 02/22/2013 Feb A/P Cell phones 10-23-12 to 11-22- 352.21 175.44 527.65 TOWN OF TROPHY CLUB 32274 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 175.44 527.65 ** 2,000.00 Budgeted 1,472.35 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 928 02/22/2013 Feb A/P Electric for 01-14-13 to 02-13 33,095.79 2,550.58 35,646.37 HUDSON ENERGY SERVICES, LLC 32259 AP 928 02/22/2013 Feb A/P Electric 01-11-13 to 02-12-13 101.70 35,748.07 HUDSON ENERGY SERVICES, LLC 32259 AP 985 02/28/2013 Feb A/P Elec 1/14-2/13 4,523.68 40,271.75 HUDSON ENERGY SERVICES, LLC 32318 AP _______________ Account: 135-60020-010-000 Electricity Totals: 7,175.96 40,271.75 ** 162,410.00 Budgeted 122,138.25 Remaining 25 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships 150.00 .00 150.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 150.00 ** 150.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-010-000 Schools & Training 351.00 .00 351.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 351.00 ** 1,672.00 Budgeted 1,321.00 Remaining 21 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 551.69 .00 551.69 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 551.69 ** 700.00 Budgeted 148.31 Remaining 79 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-010-000 Rent/Lease Equipment .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 TCEQ Fees & Permits 40,524.75 .00 40,524.75 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 40,524.75 ** 35,800.00 Budgeted (4,724.75) Remaining 113 % Used Account: 135-60150-010-000 Wholesale Water 985 02/28/2013 Feb A/P Jan Wholesale water 418,323.40 81,525.57 499,848.97 CITY OF FORT WORTH 32313 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 81,525.57 499,848.97 ** 2,028,447.00 Budgeted 1,528,598.03 Remaining 25 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 1041 02/28/2013 PCards 1/29-2/26/13 DENTON SAND & GRAVEL, 348.70 108.00 456.70 DENTON SAND & GRAVEL, PC 1041 02/28/2013 PCards 1/29-2/26/13 TEX-TURF 26.25 482.95 TEX-TURF PC 1041 02/28/2013 PCards 1/29-2/26/13 TEX-TURF 6.00 488.95 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 140.25 488.95 ** 4,200.00 Budgeted 3,711.05 Remaining 12 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60360-010-000 Furniture/Equipment < $5000 38.99 .00 38.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 38.99 ** 1,500.00 Budgeted 1,461.01 Remaining 3 % Used Account: 135-65005-010-000 Fuel & Lube 1024 02/28/2013 Feb Gaslog 3,760.60 966.38 4,726.98 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 966.38 4,726.98 ** 17,661.00 Budgeted 12,934.02 Remaining 27 % Used Account: 135-65010-010-000 Uniforms 1,617.82 .00 1,617.82 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,617.82 ** 2,680.00 Budgeted 1,062.18 Remaining 60 % Used Account: 135-65030-010-000 Chemicals 849 02/11/2013 Feb A/P Chemicals 1,331.78 334.71 1,666.49 HACH COMPANY 32223 AP 928 02/22/2013 Feb A/P Jan PCards-Womack 2.98 1,669.47 JPMORGAN CHASE BANK NA 32262 AP 985 02/28/2013 Feb A/P Nitrite solution, DPD for wate 136.10 1,805.57 HACH COMPANY 32316 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 473.79 1,805.57 ** 6,200.00 Budgeted 4,394.43 Remaining 29 % Used Account: 135-65035-010-000 Small Tools 267.19 .00 267.19 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 267.19 ** 1,500.00 Budgeted 1,232.81 Remaining 18 % Used Account: 135-65040-010-000 Safety Equipment 1041 02/28/2013 PCards 1/29-2/26/13 TX AMERICA SAFETY 256.82 256.82 TX AMERICA SAFETY PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 256.82 256.82 ** 2,000.00 Budgeted 1,743.18 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense 97,393.00 .00 97,393.00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 97,393.00 ** 143,550.00 Budgeted 46,157.00 Remaining 68 % Used Account: 135-65085-010-000 Office Supplies 1041 02/28/2013 PCards 1/29-2/26/13 OFFICE SUPPLIES 109.68 109.68 OFFICE DEPOT #2255 PC _______________ Account: 135-65085-010-000 Office Supplies Totals: 109.68 109.68 ** .00 Budgeted (109.68) Remaining 0 % Used Account: 135-69005-010-000 Capital Expenses 849 02/11/2013 Feb A/P 1/2 down for security at Water 3,145.00 3,145.00 3RD EYE SURVEILLANCE SYSTEMS 32222 AP _______________ Account: 135-69005-010-000 Capital Expenses Totals: 3,145.00 3,145.00 ** 181,800.00 Budgeted 178,655.00 Remaining 2 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 387,037.00 Budgeted 387,037.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest 928 02/22/2013 Feb A/P Ground Storage Revenue Note 10,376.98 10,376.98 FIRST FINANCIAL BANK 32256 AP _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: 10,376.98 10,376.98 ** .00 Budgeted (10,376.98) Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 59,869.00 .00 59,869.00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 59,869.00 ** 270,000.00 Budgeted 210,131.00 Remaining 22 % 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 ** 150,000.00 Budgeted 49,183.46 Remaining 67 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,022,953.98 ** 3,821,430.00 Budgeted 2,798,476.02 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 730 02/01/2013 2/1/13 Payroll Salaries & Wages 53,014.40 7,158.24 60,172.64 PR 853 02/15/2013 Payroll 2/15/13 Salaries & Wages 7,246.70 67,419.34 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,404.94 67,419.34 ** 196,781.00 Budgeted 129,361.66 Remaining 34 % Used Account: 135-50010-020-000 Overtime 730 02/01/2013 2/1/13 Payroll Overtime 4,876.39 454.91 5,331.30 PR 853 02/15/2013 Payroll 2/15/13 Overtime 496.59 5,827.89 PR _______________ Account: 135-50010-020-000 Overtime Totals: 951.50 5,827.89 ** 10,166.00 Budgeted 4,338.11 Remaining 57 % Used Account: 135-50016-020-000 Longevity 2,857.50 .00 2,857.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,857.50 ** 2,858.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1,750.00 .00 1,750.00 _______________ Account: 135-50017-020-000 Certification Totals: .00 1,750.00 ** 4,200.00 Budgeted 2,450.00 Remaining 42 % Used Account: 135-50020-020-000 Retirement 730 02/01/2013 2/1/13 Payroll Retirement 33,917.47 683.67 34,601.14 PR 853 02/15/2013 Payroll 2/15/13 Retirement 695.34 35,296.48 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,379.01 35,296.48 ** 29,821.00 Budgeted (5,475.48) Remaining 118 % Used Account: 135-50026-020-000 Medical Insurance 730 02/01/2013 2/1/13 Payroll Medical Insurance 10,275.13 1,646.62 11,921.75 PR 853 02/15/2013 Payroll 2/15/13 Medical Insurance 1,646.61 13,568.36 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,293.23 13,568.36 ** 29,034.00 Budgeted 15,465.64 Remaining 47 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 730 02/01/2013 2/1/13 Payroll Dental Insurance 752.48 113.24 865.72 PR 853 02/15/2013 Payroll 2/15/13 Dental Insurance 113.22 978.94 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 978.94 ** 2,112.00 Budgeted 1,133.06 Remaining 46 % Used Account: 135-50028-020-000 Vision Insurance 730 02/01/2013 2/1/13 Payroll Vision Insurance 195.16 28.72 223.88 PR 853 02/15/2013 Payroll 2/15/13 Vision Insurance 28.68 252.56 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 57.40 252.56 ** 552.00 Budgeted 299.44 Remaining 46 % Used Account: 135-50029-020-000 Life Insurance & Other 730 02/01/2013 2/1/13 Payroll Life Insurance & Other 644.16 78.29 722.45 PR 928 02/22/2013 Feb A/P Monthy FSA Admin 21.00 743.45 Discovery Benefits 32254 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 99.29 743.45 ** 920.00 Budgeted 176.55 Remaining 81 % Used Account: 135-50030-020-000 Social Security Taxes 730 02/01/2013 2/1/13 Payroll Social Security Taxes 3,510.16 402.97 3,913.13 PR 853 02/15/2013 Payroll 2/15/13 Social Security Taxes 407.60 4,320.73 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 810.57 4,320.73 ** 13,268.00 Budgeted 8,947.27 Remaining 33 % Used Account: 135-50035-020-000 Medicare Taxes 730 02/01/2013 2/1/13 Payroll Medicare Taxes 820.92 94.23 915.15 PR 853 02/15/2013 Payroll 2/15/13 Medicare Taxes 95.33 1,010.48 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 189.56 1,010.48 ** 3,103.00 Budgeted 2,092.52 Remaining 33 % Used Account: 135-50040-020-000 Unemployment Taxes 273.05 .00 273.05 . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 273.05 ** 756.00 Budgeted 482.95 Remaining 36 % Used Account: 135-50045-020-000 Workman's Compensation 7,853.00 .00 7,853.00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 7,853.00 ** 2,939.00 Budgeted (4,914.00) Remaining 267 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations 1041 02/28/2013 PCards 1/29-2/26/13 DONUT HAVEN 19.46 19.46 DONUT HAVEN PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070020 (25%) 15.92 35.38 FUZZY'S TACO SHOP PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070020 (25%) 1.99 37.37 WM SUPERCENTER#5247 PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070020 (25%) 25.00 62.37 VINNYS ITALIAN RESTAUR PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 62.37 62.37 ** 350.00 Budgeted 287.63 Remaining 18 % Used Account: 135-55070-020-000 Independent Labor 34,875.00 .00 34,875.00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 34,875.00 ** 1,000.00 Budgeted (33,875.00) Remaining ########## Account: 135-55080-020-000 Maintenance & Repairs 814 02/06/2013 Feb A/P Battery for welder 31,190.76 90.02 31,280.78 BLAGG TIRE & SERVICE 32172 AP 856 02/11/2013 Void A/P ck31865/USA Bluebook (67.83) 31,212.95 USA BLUEBOOK 31865 AP 875 02/13/2013 Feb A/P Double Check Backflow Prevente 398.25 31,611.20 ATLAS ENTERPRISES, INC 32226 AP 875 02/13/2013 Feb A/P Repair WWTP front gate 2,950.00 34,561.20 AAA QUICK RESPONSE GARAGE DOOR 32224 AP 918 02/13/2013 Void AP ck 32226/wrong vendor Double Check Backflow Prevente (398.25) 34,162.95 ATLAS ENTERPRISES, INC 32226 AP 928 02/22/2013 Feb A/P RPZ at WWTP 398.25 34,561.20 ATLAS UTILITY SUPPLY CO. 32249 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 928 02/22/2013 Feb A/P Jan PCards-Richey 31,190.76 37.00 34,598.20 JPMORGAN CHASE BANK NA 32262 AP 928 02/22/2013 Feb A/P Jan PCards-Schlielig 132.35 34,730.55 JPMORGAN CHASE BANK NA 32262 AP 1041 02/28/2013 PCards 1/29-2/26/13 WW GRAINGER 69.84 34,800.39 WW GRAINGER PC 1041 02/28/2013 PCards 1/29-2/26/13 WW GRAINGER 93.22 34,893.61 WW GRAINGER PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 3,702.85 34,893.61 ** 40,000.00 Budgeted 5,106.39 Remaining 87 % Used Account: 135-55090-020-000 Vehicle Maintenance 928 02/22/2013 Feb A/P Tires for 1998 C35000 PU 1,162.98 883.86 2,046.84 BLAGG TIRE & SERVICE 32250 AP 928 02/22/2013 Feb A/P Jan PCards-Schlielig 1,643.81 3,690.65 JPMORGAN CHASE BANK NA 32262 AP 1041 02/28/2013 PCards 1/29-2/26/13 WM SUPERCENTER#5247 10.28 3,700.93 WM SUPERCENTER#5247 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 2,537.95 3,700.93 ** 2,000.00 Budgeted (1,700.93) Remaining 185 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,080.96 .00 1,080.96 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,080.96 ** 1,500.00 Budgeted 419.04 Remaining 72 % Used Account: 135-55125-020-000 Dumpster Services 928 02/22/2013 Feb A/P Sludge Haul off 16,375.62 1,644.94 18,020.56 L.H. CHANEY MATERIALS, INC. 32263 AP 928 02/22/2013 Feb A/P Sludge Haul off 803.15 18,823.71 L.H. CHANEY MATERIALS, INC. 32263 AP 985 02/28/2013 Feb A/P Sludge haul off 1,826.21 20,649.92 L.H. CHANEY MATERIALS, INC. 32320 AP 985 02/28/2013 Feb A/P Sludge haul off 887.02 21,536.94 L.H. CHANEY MATERIALS, INC. 32320 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 5,161.32 21,536.94 ** 15,000.00 Budgeted (6,536.94) Remaining 144 % Used Account: 135-55135-020-000 Lab Analysis 814 02/06/2013 Feb A/P Wet chem analysis 7,338.00 2,139.50 9,477.50 TALEM, INC 32195 AP 928 02/22/2013 Feb A/P Biomonitoring 1,080.00 10,557.50 HUTHER AND ASSOCIATES,INC 32260 AP 985 02/28/2013 Feb A/P CBOD Lab testing 51.00 10,608.50 TALEM, INC 32340 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 3,270.50 10,608.50 ** 30,000.00 Budgeted 19,391.50 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-020-000 Communications/Pagers/Mobiles 928 02/22/2013 Feb A/P Cell phones 10-23-12 to 11-22- 513.11 233.43 746.54 TOWN OF TROPHY CLUB 32274 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 233.43 746.54 ** 2,700.00 Budgeted 1,953.46 Remaining 28 % Used Account: 135-60020-020-000 Electricity 928 02/22/2013 Feb A/P Electric for 01-14-13 to 02-13 39,314.08 12,139.80 51,453.88 HUDSON ENERGY SERVICES, LLC 32259 AP _______________ Account: 135-60020-020-000 Electricity Totals: 12,139.80 51,453.88 ** 153,045.00 Budgeted 101,591.12 Remaining 34 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 161.45 .00 161.45 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 161.45 ** 500.00 Budgeted 338.55 Remaining 32 % Used Account: 135-60080-020-000 Schools & Training 928 02/22/2013 Feb A/P Jan PCards-Slaght 215.66 445.00 660.66 JPMORGAN CHASE BANK NA 32262 AP _______________ Account: 135-60080-020-000 Schools & Training Totals: 445.00 660.66 ** 3,272.00 Budgeted 2,611.34 Remaining 20 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 816.27 .00 816.27 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 816.27 ** 1,400.00 Budgeted 583.73 Remaining 58 % Used Account: 135-60105-020-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,020.00 .00 1,020.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1,020.00 ** 1,500.00 Budgeted 480.00 Remaining 68 % Used Account: 135-60125-020-000 Advertising 1041 02/28/2013 PCards 1/29-2/26/13 NORTH TEXAS SIGNS ROUT 112.50 112.50 NORTH TEXAS SIGNS ROUT PC _______________ Account: 135-60125-020-000 Advertising Totals: 112.50 112.50 ** 2,000.00 Budgeted 1,887.50 Remaining 6 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 1041 02/28/2013 PCards 1/29-2/26/13 VINNYS ITALIAN RESTAUR 7,729.80 46.39 7,776.19 VINNYS ITALIAN RESTAUR PC 1041 02/28/2013 PCards 1/29-2/26/13 TCEQ IND RENEWAL L 111.00 7,887.19 TCEQ IND RENEWAL L PC _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 157.39 7,887.19 ** 56,000.00 Budgeted 48,112.81 Remaining 14 % Used Account: 135-60245-020-000 Miscellaneous Expenses 148.10 .00 148.10 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 148.10 ** 200.00 Budgeted 51.90 Remaining 74 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 345.15 .00 345.15 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 345.15 ** 500.00 Budgeted 154.85 Remaining 69 % Used Account: 135-65005-020-000 Fuel & Lube 1024 02/28/2013 Feb Gaslog 3,981.33 1,223.98 5,205.31 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,223.98 5,205.31 ** 8,527.00 Budgeted 3,321.69 Remaining 61 % Used Account: 135-65010-020-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 773.70 .00 773.70 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 773.70 ** 2,574.00 Budgeted 1,800.30 Remaining 30 % Used Account: 135-65030-020-000 Chemicals 875 02/13/2013 Feb A/P Clarifloc 15,025.52 1,080.00 16,105.52 POLYDYNE, INC 32242 AP 875 02/13/2013 Feb A/P HTH 2,240.00 18,345.52 HARCROS CHEMICALS INC 32232 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 3,320.00 18,345.52 ** 10,000.00 Budgeted (8,345.52) Remaining 183 % Used Account: 135-65035-020-000 Small Tools 1041 02/28/2013 PCards 1/29-2/26/13 THE HOME DEPOT 6581 194.04 18.45 212.49 THE HOME DEPOT 6581 PC 1041 02/28/2013 PCards 1/29-2/26/13 THE HOME DEPOT 6581 118.00 330.49 THE HOME DEPOT 6581 PC 1041 02/28/2013 PCards 1/29-2/26/13 THE HOME DEPOT 6581 2.98 333.47 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 139.43 333.47 ** 1,000.00 Budgeted 666.53 Remaining 33 % Used Account: 135-65040-020-000 Safety Equipment 928 02/22/2013 Feb A/P Jan PCards-Schlielig 65.07 345.88 410.95 JPMORGAN CHASE BANK NA 32262 AP 1041 02/28/2013 PCards 1/29-2/26/13 TOM THUMB STOR00017897 6.49 417.44 TOM THUMB STOR00017897 PC 1041 02/28/2013 PCards 1/29-2/26/13 CINTAS FIRST AID #0487 34.70 452.14 CINTAS FIRST AID #0487 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 387.07 452.14 ** 250.00 Budgeted (202.14) Remaining 181 % Used Account: 135-65045-020-000 Lab Supplies 849 02/11/2013 Feb A/P Graduated Cylinder 6,104.79 144.00 6,248.79 HACH COMPANY 32223 AP 928 02/22/2013 Feb A/P Lab supplies 47.83 6,296.62 OZARKA DIRECT 32269 AP 928 02/22/2013 Feb A/P Disposable Quanti Trays 712.89 7,009.51 IDEXX DISTRIBUTION, INC 32261 AP 928 02/22/2013 Feb A/P Jan PCards-Beck 62.53 7,072.04 JPMORGAN CHASE BANK NA 32262 AP 928 02/22/2013 Feb A/P Jan PCards-Schlielig 240.00 7,312.04 JPMORGAN CHASE BANK NA 32262 AP 1041 02/28/2013 PCards 1/29-2/26/13 METTLER-TOLEDO INC 273.50 7,585.54 METTLER-TOLEDO INC PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,480.75 7,585.54 ** 10,000.00 Budgeted 2,414.46 Remaining 76 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-020-000 Capital Expenses 849 02/11/2013 Feb A/P 1/2 down for security at Waste 400,085.29 4,289.00 404,374.29 3RD EYE SURVEILLANCE SYSTEMS 32222 AP _______________ Account: 135-69005-020-000 Capital Expenses Totals: 4,289.00 404,374.29 ** 241,200.00 Budgeted (163,174.29) Remaining 168 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 158,000.00 Budgeted 158,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 749,331.80 ** 1,039,428.00 Budgeted 290,096.20 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-021-000 Salaries & Wages 730 02/01/2013 2/1/13 Payroll Salaries & Wages 42,474.20 5,772.89 48,247.09 PR 853 02/15/2013 Payroll 2/15/13 Salaries & Wages 5,772.89 54,019.98 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,545.78 54,019.98 ** 156,475.00 Budgeted 102,455.02 Remaining 35 % Used Account: 135-50010-021-000 Overtime 730 02/01/2013 2/1/13 Payroll Overtime 4,051.14 30.33 4,081.47 PR 853 02/15/2013 Payroll 2/15/13 Overtime 298.86 4,380.33 PR _______________ Account: 135-50010-021-000 Overtime Totals: 329.19 4,380.33 ** 7,297.00 Budgeted 2,916.67 Remaining 60 % Used Account: 135-50016-021-000 Longevity 3,817.50 .00 3,817.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 3,817.50 ** 3,818.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 700.00 .00 700.00 _______________ Account: 135-50017-021-000 Certification Totals: .00 700.00 ** 1,800.00 Budgeted 1,100.00 Remaining 39 % Used Account: 135-50020-021-000 Retirement 730 02/01/2013 2/1/13 Payroll Retirement 26,593.75 521.12 27,114.87 PR 853 02/15/2013 Payroll 2/15/13 Retirement 545.25 27,660.12 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,066.37 27,660.12 ** 23,574.00 Budgeted (4,086.12) Remaining 117 % Used Account: 135-50026-021-000 Medical Insurance 730 02/01/2013 2/1/13 Payroll Medical Insurance 7,370.79 1,160.78 8,531.57 PR 853 02/15/2013 Payroll 2/15/13 Medical Insurance 1,160.77 9,692.34 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,321.55 9,692.34 ** 20,198.00 Budgeted 10,505.66 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 730 02/01/2013 2/1/13 Payroll Dental Insurance 533.32 79.95 613.27 PR 853 02/15/2013 Payroll 2/15/13 Dental Insurance 79.93 693.20 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 159.88 693.20 ** 1,409.00 Budgeted 715.80 Remaining 49 % Used Account: 135-50028-021-000 Vision Insurance 730 02/01/2013 2/1/13 Payroll Vision Insurance 121.72 16.31 138.03 PR 853 02/15/2013 Payroll 2/15/13 Vision Insurance 16.29 154.32 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 32.60 154.32 ** 357.00 Budgeted 202.68 Remaining 43 % Used Account: 135-50029-021-000 Life Insurance & Other 730 02/01/2013 2/1/13 Payroll Life Insurance & Other 482.61 58.61 541.22 PR 928 02/22/2013 Feb A/P Monthy FSA Admin 5.25 546.47 Discovery Benefits 32254 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 63.86 546.47 ** 1,008.00 Budgeted 461.53 Remaining 54 % Used Account: 135-50030-021-000 Social Security Taxes 730 02/01/2013 2/1/13 Payroll Social Security Taxes 3,139.78 327.13 3,466.91 PR 853 02/15/2013 Payroll 2/15/13 Social Security Taxes 341.72 3,808.63 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 668.85 3,808.63 ** 10,502.00 Budgeted 6,693.37 Remaining 36 % Used Account: 135-50035-021-000 Medicare Taxes 730 02/01/2013 2/1/13 Payroll Medicare Taxes 734.28 76.50 810.78 PR 853 02/15/2013 Payroll 2/15/13 Medicare Taxes 79.93 890.71 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 156.43 890.71 ** 2,456.00 Budgeted 1,565.29 Remaining 36 % Used Account: 135-50040-021-000 Unemployment Taxes 214.27 .00 214.27 . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 214.27 ** 567.00 Budgeted 352.73 Remaining 38 % Used Account: 135-50045-021-000 Workman's Compensation 7,139.00 .00 7,139.00 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 7,139.00 ** 3,348.00 Budgeted (3,791.00) Remaining 213 % Used Account: 135-50070-021-000 Employee Relations 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070021 (25%) 16.78 15.92 32.70 FUZZY'S TACO SHOP PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070021 (25%) 1.99 34.69 WM SUPERCENTER#5247 PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070021 (25%) 25.00 59.69 VINNYS ITALIAN RESTAUR PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 42.91 59.69 ** 250.00 Budgeted 190.31 Remaining 24 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 928 02/22/2013 Feb A/P Jan PCards-Womack 254.09 2.99 257.08 JPMORGAN CHASE BANK NA 32262 AP 1041 02/28/2013 PCards 1/29-2/26/13 A-1 ELECTRIC MOTOR SVC 1,123.85 1,380.93 A-1 ELECTRIC MOTOR SVC PC 1041 02/28/2013 PCards 1/29-2/26/13 FERGUSON ENTERPRISES 1 65.00 1,445.93 FERGUSON ENTERPRISES 1 PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 1,191.84 1,445.93 ** 35,000.00 Budgeted 33,554.07 Remaining 4 % Used Account: 135-55090-021-000 Vehicle Maintenance 928 02/22/2013 Feb A/P Misc Tools 268.38 41.85 310.23 ROANOKE AUTO SUPPLY 32271 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 41.85 310.23 ** 1,900.00 Budgeted 1,589.77 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-021-000 Communications/Pagers/Mobiles 928 02/22/2013 Feb A/P Cell phones 10-23-12 to 11-22- 711.20 217.27 928.47 TOWN OF TROPHY CLUB 32274 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 217.27 928.47 ** 3,500.00 Budgeted 2,571.53 Remaining 27 % Used Account: 135-60020-021-000 Electricity 875 02/13/2013 Feb A/P Electricity 12/31-1/29 5,346.55 238.05 5,584.60 TRI COUNTY ELECTRIC 32247 AP 875 02/13/2013 Feb A/P Electricity 12/31-1/29 136.99 5,721.59 TRI COUNTY ELECTRIC 32247 AP 875 02/13/2013 Feb A/P Electricity 12/31-1/29 29.01 5,750.60 TRI COUNTY ELECTRIC 32247 AP 928 02/22/2013 Feb A/P Electric for 01-14-13 to 02-13 325.32 6,075.92 HUDSON ENERGY SERVICES, LLC 32259 AP 928 02/22/2013 Feb A/P Electric for 01-14-13 to 02-13 790.27 6,866.19 HUDSON ENERGY SERVICES, LLC 32259 AP 928 02/22/2013 Feb A/P Electric for 01-11-13 to 02-12 52.67 6,918.86 HUDSON ENERGY SERVICES, LLC 32259 AP 969 02/27/2013 Invoice Town #1009 AR 20130226-20130227 User: (240.96) 6,677.90 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,331.35 6,677.90 ** 18,705.00 Budgeted 12,027.10 Remaining 36 % Used Account: 135-60070-021-000 Dues & Memberships 250.00 .00 250.00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 250.00 ** 250.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-021-000 Schools & Training 928 02/22/2013 Feb A/P Jan PCards-Slaght 385.00 445.00 830.00 JPMORGAN CHASE BANK NA 32262 AP _______________ Account: 135-60080-021-000 Schools & Training Totals: 445.00 830.00 ** 826.00 Budgeted (4.00) Remaining 100 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 295.33 .00 295.33 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 295.33 ** 450.00 Budgeted 154.67 Remaining 66 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 1024 02/28/2013 Feb Gaslog 3,490.36 1,211.28 4,701.64 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,211.28 4,701.64 ** 12,117.00 Budgeted 7,415.36 Remaining 39 % Used Account: 135-65010-021-000 Uniforms 934.13 .00 934.13 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 934.13 ** 2,220.00 Budgeted 1,285.87 Remaining 42 % Used Account: 135-65030-021-000 Chemicals 928 02/22/2013 Feb A/P Breakdown degreaser 2,221.00 2,221.00 MICKEY D CARSON DBA/NUSCO 32265 AP _______________ Account: 135-65030-021-000 Chemicals Totals: 2,221.00 2,221.00 ** 7,500.00 Budgeted 5,279.00 Remaining 30 % Used Account: 135-65035-021-000 Small Tools 70.00 .00 70.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-021-000 Small Tools Totals: .00 70.00 ** 1,500.00 Budgeted 1,430.00 Remaining 5 % Used Account: 135-65040-021-000 Safety Equipment 985 02/28/2013 Feb A/P hip wader boots 120.00 120.00 ATLAS UTILITY SUPPLY CO. 32306 AP _______________ Account: 135-65040-021-000 Safety Equipment Totals: 120.00 120.00 ** 500.00 Budgeted 380.00 Remaining 24 % Used Account: 135-69005-021-000 Capital Expenses .00 .00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 .00 ** 90,000.00 Budgeted 90,000.00 Remaining 0 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 40,260.00 Budgeted 40,260.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 132,561.19 ** 459,887.00 Budgeted 327,325.81 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 730 02/01/2013 2/1/13 Payroll Salaries & Wages 2,100.00 700.00 2,800.00 PR 853 02/15/2013 Payroll 2/15/13 Salaries & Wages 200.00 3,000.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 900.00 3,000.00 ** 10,000.00 Budgeted 7,000.00 Remaining 30 % Used Account: 135-50030-026-000 Social Security Taxes 730 02/01/2013 2/1/13 Payroll Social Security Taxes 130.20 43.40 173.60 PR 853 02/15/2013 Payroll 2/15/13 Social Security Taxes 12.40 186.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 55.80 186.00 ** 620.00 Budgeted 434.00 Remaining 30 % Used Account: 135-50035-026-000 Medicare Taxes 730 02/01/2013 2/1/13 Payroll Medicare Taxes 30.45 10.15 40.60 PR 853 02/15/2013 Payroll 2/15/13 Medicare Taxes 2.90 43.50 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 13.05 43.50 ** 145.00 Budgeted 101.50 Remaining 30 % Used Account: 135-50040-026-000 Unemployment Taxes 60.90 .00 60.90 _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .00 60.90 ** 210.00 Budgeted 149.10 Remaining 29 % Used Account: 135-50045-026-000 Workman's Compensation 15.70 .00 15.70 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 15.70 ** 150.00 Budgeted 134.30 Remaining 10 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships 985 02/28/2013 Feb A/P Balance due 35.00 7.00 42.00 TX SOCIAL SECURITY PROGRAM 32344 AP _______________ Account: 135-60070-026-000 Dues & Memberships Totals: 7.00 42.00 ** 2,100.00 Budgeted 2,058.00 Remaining 2 % Used Account: 135-60075-026-000 Meetings 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13560075026 (33.33%) 222.97 22.00 244.97 NW METROPORT CHAMBER O PC _______________ Account: 135-60075-026-000 Meetings Totals: 22.00 244.97 ** 1,200.00 Budgeted 955.03 Remaining 20 % Used Account: 135-60080-026-000 Schools & Training 985 02/28/2013 Feb A/P AWBD Annual Conf/Carr 580.00 345.00 925.00 AWBD 32308 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 345.00 925.00 ** 4,000.00 Budgeted 3,075.00 Remaining 23 % Used Account: 135-60100-026-000 Travel & per diem 823 02/06/2013 Void A/P ck 32185/K Carr AWBD Conference reimbursement 1,020.56 (510.28) 510.28 KEVIN CARR 32185 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: (510.28) 510.28 ** 5,000.00 Budgeted 4,489.72 Remaining 10 % Used Account: 135-60245-026-000 Miscellaneous Expenses 928 02/22/2013 Feb A/P Jan PCards-Schultz 60.00 180.00 240.00 JPMORGAN CHASE BANK NA 32262 AP 928 02/22/2013 Feb A/P Jan PCards-Slaght 12.44 252.44 JPMORGAN CHASE BANK NA 32262 AP _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 192.44 252.44 ** 3,000.00 Budgeted 2,747.56 Remaining 8 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 5,280.79 ** 26,575.00 Budgeted 21,294.21 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 730 02/01/2013 2/1/13 Payroll Salaries & Wages 126,312.71 16,269.64 142,582.35 PR 853 02/15/2013 Payroll 2/15/13 Salaries & Wages 16,263.11 158,845.46 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 32,532.75 158,845.46 ** 444,730.00 Budgeted 285,884.54 Remaining 36 % Used Account: 135-50010-030-000 Overtime 730 02/01/2013 2/1/13 Payroll Overtime 144.18 9.88 154.06 PR 853 02/15/2013 Payroll 2/15/13 Overtime 3.60 157.66 PR _______________ Account: 135-50010-030-000 Overtime Totals: 13.48 157.66 ** 1,500.00 Budgeted 1,342.34 Remaining 11 % Used Account: 135-50016-030-000 Longevity 2,317.50 .00 2,317.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 2,317.50 ** 2,193.00 Budgeted (124.50) Remaining 106 % Used Account: 135-50020-030-000 Retirement 730 02/01/2013 2/1/13 Payroll Retirement 62,077.21 1,461.91 63,539.12 PR 853 02/15/2013 Payroll 2/15/13 Retirement 1,460.76 64,999.88 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,922.67 64,999.88 ** 60,441.00 Budgeted (4,558.88) Remaining 108 % Used Account: 135-50026-030-000 Medical Insurance 730 02/01/2013 2/1/13 Payroll Medical Insurance 13,944.00 2,194.07 16,138.07 PR 853 02/15/2013 Payroll 2/15/13 Medical Insurance 2,194.03 18,332.10 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 18,332.10 ** 44,066.00 Budgeted 25,733.90 Remaining 42 % Used Account: 135-50027-030-000 Dental Insurance 730 02/01/2013 2/1/13 Payroll Dental Insurance 1,252.50 193.19 1,445.69 PR 853 02/15/2013 Payroll 2/15/13 Dental Insurance 193.15 1,638.84 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 386.34 1,638.84 ** 3,379.00 Budgeted 1,740.16 Remaining 49 % Used Account: 135-50028-030-000 Vision Insurance 730 02/01/2013 2/1/13 Payroll Vision Insurance 281.05 41.29 322.34 PR 853 02/15/2013 Payroll 2/15/13 Vision Insurance 41.24 363.58 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 363.58 ** 795.00 Budgeted 431.42 Remaining 46 % Used Account: 135-50029-030-000 Life Insurance & Other 730 02/01/2013 2/1/13 Payroll Life Insurance & Other 1,206.59 134.96 1,341.55 PR 928 02/22/2013 Feb A/P Monthy FSA Admin 36.75 1,378.30 Discovery Benefits 32254 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 171.71 1,378.30 ** 2,500.00 Budgeted 1,121.70 Remaining 55 % Used Account: 135-50030-030-000 Social Security Taxes 730 02/01/2013 2/1/13 Payroll Social Security Taxes 7,830.19 939.21 8,769.40 PR 853 02/15/2013 Payroll 2/15/13 Social Security Taxes 933.97 9,703.37 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,873.18 9,703.37 ** 27,802.00 Budgeted 18,098.63 Remaining 35 % Used Account: 135-50035-030-000 Medicare Taxes 730 02/01/2013 2/1/13 Payroll Medicare Taxes 1,831.26 219.66 2,050.92 PR 853 02/15/2013 Payroll 2/15/13 Medicare Taxes 218.42 2,269.34 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 438.08 2,269.34 ** 6,502.00 Budgeted 4,232.66 Remaining 35 % Used Account: 135-50040-030-000 Unemployment Taxes 891.41 .00 891.41 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 891.41 ** 1,537.00 Budgeted 645.59 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 1,539.00 .00 1,539.00 _______________ Account: 135-50045-030-000 Workman's Compensation Totals: .00 1,539.00 ** 831.00 Budgeted (708.00) Remaining 185 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 39.00 .00 39.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 39.00 ** 250.00 Budgeted 211.00 Remaining 16 % Used Account: 135-50070-030-000 Employee Relations 928 02/22/2013 Feb A/P Jan PCards-Womack 2,537.47 41.30 2,578.77 JPMORGAN CHASE BANK NA 32262 AP 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070030 (25%) 15.92 2,594.69 FUZZY'S TACO SHOP PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070030 (25%) 1.99 2,596.68 WM SUPERCENTER#5247 PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13550070030 (25%) 25.00 2,621.68 VINNYS ITALIAN RESTAUR PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 84.21 2,621.68 ** 5,000.00 Budgeted 2,378.32 Remaining 52 % Used Account: 135-55030-030-000 Software & Support 875 02/13/2013 Feb A/P IT PCards 12/28-1/27 14,469.92 53.38 14,523.30 TOWN OF TROPHY CLUB 32246 AP 875 02/13/2013 Feb A/P IT PCards 12/28-1/27 55.37 14,578.67 TOWN OF TROPHY CLUB 32246 AP 875 02/13/2013 Feb A/P IT PCards 12/28-1/27 35.94 14,614.61 TOWN OF TROPHY CLUB 32246 AP 875 02/13/2013 Feb A/P IT PCards 12/28-1/27 25.00 14,639.61 TOWN OF TROPHY CLUB 32246 AP 875 02/13/2013 Feb A/P IT PCards 12/28-1/27 224.50 14,864.11 TOWN OF TROPHY CLUB 32246 AP 928 02/22/2013 Feb A/P Monthly ISP-Broadband 302.75 15,166.86 TOWN OF TROPHY CLUB 32274 AP 928 02/22/2013 Feb A/P STW Support 1,143.00 16,309.86 STW INC 32273 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 1,839.94 16,309.86 ** 63,555.00 Budgeted 47,245.14 Remaining 26 % Used Account: 135-55070-030-000 Independent Labor 928 02/22/2013 Feb A/P Record MUD meeting 120.00 67.50 187.50 MIGUEL CRUZ 32266 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 67.50 187.50 ** 2,700.00 Budgeted 2,512.50 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55075-030-000 Records Management .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 875 02/13/2013 Feb A/P Rug Service and supplies 2,238.08 392.75 2,630.83 G & K SERVICES 32231 AP 928 02/22/2013 Feb A/P Jan PCards-Schultz 91.81 2,722.64 JPMORGAN CHASE BANK NA 32262 AP 928 02/22/2013 Feb A/P Jan PCards-Thomas 280.29 3,002.93 JPMORGAN CHASE BANK NA 32262 AP 928 02/22/2013 Feb A/P Jan PCards-McKnight 27.86 3,030.79 JPMORGAN CHASE BANK NA 32262 AP 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: (168.30) 2,862.49 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 624.41 2,862.49 ** 5,000.00 Budgeted 2,137.51 Remaining 57 % Used Account: 135-55120-030-000 Cleaning Services 875 02/13/2013 Feb A/P February Cleaning service 7,161.72 1,678.51 8,840.23 ABM JANITORIAL SERVICES, INC 32225 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,678.51 8,840.23 ** 20,200.00 Budgeted 11,359.77 Remaining 44 % Used Account: 135-55160-030-000 Professional Outside Services 6,825.00 .00 6,825.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 6,825.00 ** 15,000.00 Budgeted 8,175.00 Remaining 46 % Used Account: 135-55161-030-000 Outside Services-Town Semo 875 02/13/2013 Feb A/P Balance due ILA 60,318.00 25,147.00 85,465.00 TOWN OF TROPHY CLUB 32246 AP _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: 25,147.00 85,465.00 ** 85,465.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees 159.77 .00 159.77 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 159.77 ** .00 Budgeted (159.77) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55205-030-000 Utility Billing Contract 875 02/13/2013 Feb A/P Jan Utility billing/Town inser 2,098.75 860.63 2,959.38 DP2 BILLING SOLUTIONS, LLC 32229 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 860.63 2,959.38 ** 11,000.00 Budgeted 8,040.62 Remaining 27 % Used Account: 135-60005-030-000 Telephone 875 02/13/2013 Feb A/P IT PCards 12/28-1/27 2,602.17 396.23 2,998.40 TOWN OF TROPHY CLUB 32246 AP 875 02/13/2013 Feb A/P IT PCards 12/28-1/27 157.05 3,155.45 TOWN OF TROPHY CLUB 32246 AP 875 02/13/2013 Feb A/P IT PCards 12/28-1/27 374.96 3,530.41 TOWN OF TROPHY CLUB 32246 AP _______________ Account: 135-60005-030-000 Telephone Totals: 928.24 3,530.41 ** 9,000.00 Budgeted 5,469.59 Remaining 39 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 928 02/22/2013 Feb A/P Cell phones 10-23-12 to 11-22- 1,104.08 177.04 1,281.12 TOWN OF TROPHY CLUB 32274 AP 928 02/22/2013 Feb A/P Jan PCards-Slaght 19.92 1,301.04 JPMORGAN CHASE BANK NA 32262 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 196.96 1,301.04 ** 3,575.00 Budgeted 2,273.96 Remaining 36 % Used Account: 135-60020-030-000 Electricity/Gas 875 02/13/2013 Feb A/P Direct Energy Electricity/MUD 3,011.89 1,540.22 4,552.11 TOWN OF TROPHY CLUB 32246 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,540.22 4,552.11 ** 13,019.00 Budgeted 8,466.89 Remaining 35 % Used Account: 135-60025-030-000 Water 1039 02/28/2013 Feb Billing to Town AR 20130227-20130228 User: 388.74 (52.11) 336.63 AR _______________ Account: 135-60025-030-000 Water Totals: (52.11) 336.63 ** 3,100.00 Budgeted 2,763.37 Remaining 11 % Used Account: 135-60030-030-000 Rent And/Or Usage 814 02/06/2013 Feb A/P Feb Rent-Public Services Bldg 3,810.71 1,098.51 4,909.22 TOWN OF TROPHY CLUB 32200 AP 896 02/15/2013 Inv Town/Feb Maint Bldg Rent AR 20130215-20130215 User: (583.33) 4,325.89 AR _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 515.18 4,325.89 ** 13,182.00 Budgeted 8,856.11 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60035-030-000 Postage 875 02/13/2013 Feb A/P Overnight shipping 10,142.96 11.97 10,154.93 FEDERAL EXPRESS CORP 32230 AP 875 02/13/2013 Feb A/P Postage 29.73 10,184.66 PURCHASE POWER 32243 AP 875 02/13/2013 Feb A/P Jan Utility billing/Town inser 1,604.28 11,788.94 DP2 BILLING SOLUTIONS, LLC 32229 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,645.98 11,788.94 ** 23,000.00 Budgeted 11,211.06 Remaining 51 % Used Account: 135-60040-030-000 Service Charges & Fees 817 02/01/2013 Expert Pay Child support fee 10,014.14 2.50 10,016.64 GL 990 02/04/2013 Online/CC fees 42.68 10,059.32 GL 990 02/04/2013 Online/CC fees 78.65 10,137.97 GL 990 02/04/2013 Online/CC fees 1,774.79 11,912.76 GL 822 02/06/2013 Void A/P ck 32199/Tier Two Tier Two (50.00) 11,862.76 TIER TWO CHEMICAL REPORTING 32199 AP 825 02/06/2013 Feb A/P Tier Two Chemical Reporting Pr 50.00 11,912.76 Tx Dept of State Health Svcs- 32217 AP 991 02/13/2013 Feb Account Analysis 250.00 12,162.76 GL 1041 02/28/2013 PCards 1/29-2/26/13 29.01 12,191.77 PC _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,177.63 12,191.77 ** 18,000.00 Budgeted 5,808.23 Remaining 68 % Used Account: 135-60050-030-000 Bad Debt Expense 774 02/04/2013 UB 02/04/2013 Remit Payments UB20130204-20130204 User: MSCH 695.47 (86.34) 609.13 UB 838 02/07/2013 UB 02/07/2013 Remit Payments UB20130207-20130207 User: MSCH (475.16) 133.97 UB 937 02/25/2013 UB 02/25/2013 Remit Payments UB20130225-20130225 User: MSCH (48.53) 85.44 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: (610.03) 85.44 ** 8,500.00 Budgeted 8,414.56 Remaining 1 % Used Account: 135-60055-030-000 Insurance 928 02/22/2013 Feb A/P Bond renewal- McKnight 50,643.77 50.00 50,693.77 VICTOR O SCHINNERER & CO, INC 32275 AP _______________ Account: 135-60055-030-000 Insurance Totals: 50.00 50,693.77 ** 35,000.00 Budgeted (15,693.77) Remaining 145 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 558.22 .00 558.22 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 558.22 ** 750.00 Budgeted 191.78 Remaining 74 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-030-000 Dues & Memberships 3,891.95 .00 3,891.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 3,891.95 ** 2,400.00 Budgeted (1,491.95) Remaining 162 % Used Account: 135-60075-030-000 Meetings 1041 02/28/2013 PCards 1/29-2/26/13 MEETING/MCKNIGHT, CARR 153.89 8.85 162.74 LA SCALA PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - 13560075030 (66.67%) 44.00 206.74 NW METROPORT CHAMBER O PC _______________ Account: 135-60075-030-000 Meetings Totals: 52.85 206.74 ** 250.00 Budgeted 43.26 Remaining 83 % Used Account: 135-60080-030-000 Schools & Training 875 02/13/2013 Feb A/P Election Law Seminar, Slaght, 570.00 440.00 1,010.00 Ofc of the Secretary of State 32240 AP 985 02/28/2013 Feb A/P STW Conference, Sisk, D'Andria 555.00 1,565.00 STW INC 32338 AP 1041 02/28/2013 PCards 1/29-2/26/13 NCTCOG NOTARY LAW CLASS/D'ANDR 140.00 1,705.00 NCTCOG PBLCTNS & SRVCS PC 1041 02/28/2013 PCards 1/29-2/26/13 NCTCOG NOTARY LAW CLASS/SCHAEF 140.00 1,845.00 NCTCOG PBLCTNS & SRVCS PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 1,275.00 1,845.00 ** 5,500.00 Budgeted 3,655.00 Remaining 34 % Used Account: 135-60100-030-000 Travel & per diem 853 02/15/2013 Payroll 2/15/13 Travel & per diem 694.19 52.32 746.51 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 52.32 746.51 ** 3,950.00 Budgeted 3,203.49 Remaining 19 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 122.70 .00 122.70 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 122.70 ** 15,000.00 Budgeted 14,877.30 Remaining 1 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60281-030-000 Park Expenses 928 02/22/2013 Feb A/P Jan Harmony Park reimbursement 16,430.72 3,984.13 20,414.85 TOWN OF TROPHY CLUB 32274 AP _______________ Account: 135-60281-030-000 Park Expenses Totals: 3,984.13 20,414.85 ** .00 Budgeted (20,414.85) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 2,325.00 .00 2,325.00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 2,325.00 ** 2,500.00 Budgeted 175.00 Remaining 93 % Used Account: 135-65010-030-000 Uniforms 624.12 .00 624.12 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 624.12 ** 1,635.00 Budgeted 1,010.88 Remaining 38 % Used Account: 135-65055-030-000 Hardware . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 10,430.22 .00 10,430.22 _______________ Account: 135-65055-030-000 Hardware Totals: .00 10,430.22 ** 20,188.00 Budgeted 9,757.78 Remaining 52 % Used Account: 135-65085-030-000 Office Supplies 875 02/13/2013 Feb A/P Office supplies 2,528.62 224.99 2,753.61 OFFICE DEPOT, INC 32241 AP 875 02/13/2013 Feb A/P Office Supplies 22.49 2,776.10 OFFICE DEPOT, INC 32241 AP 875 02/13/2013 Feb A/P Office Supplies 170.81 2,946.91 OFFICE DEPOT, INC 32241 AP 875 02/13/2013 Feb A/P office supplies 56.49 3,003.40 OFFICE DEPOT, INC 32241 AP 928 02/22/2013 Feb A/P Jan PCards 71.30 3,074.70 TOWN OF TROPHY CLUB 32274 AP 928 02/22/2013 Feb A/P Office Supplies 81.82 3,156.52 OFFICE DEPOT, INC 32268 AP 928 02/22/2013 Feb A/P Jan PCards-Schultz 134.70 3,291.22 JPMORGAN CHASE BANK NA 32262 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 762.60 3,291.22 ** 8,200.00 Budgeted 4,908.78 Remaining 40 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 875 02/13/2013 Feb A/P Shi Inv GB00073376 Printer dru 900.00 362.50 1,262.50 TOWN OF TROPHY CLUB 32246 AP 985 02/28/2013 Feb A/P SHI Inv GB00075135/Printer ton 95.90 1,358.40 TOWN OF TROPHY CLUB 32342 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 458.40 1,358.40 ** 5,732.00 Budgeted 4,373.60 Remaining 24 % Used Account: 135-65095-030-000 Maintenance Supplies 928 02/22/2013 Feb A/P Jan PCards-Richey 715.16 53.63 768.79 JPMORGAN CHASE BANK NA 32262 AP 928 02/22/2013 Feb A/P Jan PCards 36.90 805.69 TOWN OF TROPHY CLUB 32274 AP 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - (34.61%) 87.53 893.22 SAMSCLUB #4795 PC 1041 02/28/2013 PCards 1/29-2/26/13 SPLIT - (49.59%) 125.43 1,018.65 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 303.49 1,018.65 ** 2,000.00 Budgeted 981.35 Remaining 51 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65105-030-000 Printing 395.00 .00 395.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 395.00 ** 5,200.00 Budgeted 4,805.00 Remaining 8 % Used Account: 135-69170-030-000 Copier Lease Installments 1,284.25 .00 1,284.25 _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: .00 1,284.25 ** 3,450.00 Budgeted 2,165.75 Remaining 37 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 526,025.18 ** 1,051,838.00 Budgeted 525,812.82 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 928 02/22/2013 Feb A/P CCN 55,174.89 7,439.85 62,614.74 WHITAKER CHALK SWINDLE 32276 AP 928 02/22/2013 Feb A/P Jan Legal/Land Purchase 2,747.75 65,362.49 WHITAKER CHALK SWINDLE 32276 AP 928 02/22/2013 Feb A/P Jan Legal/Solana-Westlake 4,469.50 69,831.99 WHITAKER CHALK SWINDLE 32276 AP 928 02/22/2013 Feb A/P Water supply and WW treatment/ 2,368.80 72,200.79 WHITAKER CHALK SWINDLE 32276 AP 928 02/22/2013 Feb A/P Jan Legal/General 3,939.22 76,140.01 WHITAKER CHALK SWINDLE 32276 AP 985 02/28/2013 Feb A/P Jan legal 20,323.31 96,463.32 BOOTH, AHRENS & WERKENTHIN PC 32310 AP 985 02/28/2013 Feb A/P Jan legal 412.50 96,875.82 THE LISTON LAW FIRM, P.C. 32341 AP _______________ Account: 135-55045-039-000 Legal Totals: 41,700.93 96,875.82 ** 70,000.00 Budgeted (26,875.82) Remaining 138 % Used Account: 135-55055-039-000 Auditing 875 02/13/2013 Feb A/P Final payment/Audit 15,525.00 5,175.00 20,700.00 LAFOLLETT & COMPANY PLLC 32237 AP _______________ Account: 135-55055-039-000 Auditing Totals: 5,175.00 20,700.00 ** 21,200.00 Budgeted 500.00 Remaining 98 % Used Account: 135-55060-039-000 Appraisal 4,265.90 .00 4,265.90 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,265.90 ** 15,100.00 Budgeted 10,834.10 Remaining 28 % Used Account: 135-55065-039-000 Tax Admin Fees 2,340.98 .00 2,340.98 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,340.98 ** 3,800.00 Budgeted 1,459.02 Remaining 62 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 1014 02/28/2013 Transfer/Prime Sub Cont cks 86,726.39 86,726.39 GL _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: 86,726.39 86,726.39 ** .00 Budgeted (86,726.39) Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 210,909.09 ** 110,100.00 Budgeted (100,809.09) Remaining 192 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 576,548.12 .00 Budgeted (576,548.12) Remaining 0 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 2/28/2013 ASSETS ASSETS CASH AND CASH IN BANK 5,846$ INVESTMENTS 520,932 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 17,659 TOTAL ASSETS 544,437$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 1,000$ DEFERRED REVENUE 17,659$ TOTAL LIABILITIES 18,659 FUND BALANCE ASSIGNED FUND BALANCE 525,778 TOTAL LIABILITIES AND FUND BALANCE 544,437$ February 28, 2013 5/12 Months (41.67% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 18:34 03/12/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 196,940.00- 196,940.00- 45,201.79- 193,408.09- 98.207 3,531.91- 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 2,279.88- 58.458 1,620.12- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 98.98- 1,071.05- 21.348 3,945.95- Subtotal: 205,857.00- 205,857.00- 45,300.77- 196,759.02- 95.580 9,097.98- 533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 345,000.00- Subtotal: 345,000.00- 345,000.00- 345,000.00- 533-49010-000-000 Interest Income 1,700.00- 1,700.00- 40.79- 117.85- 6.932 1,582.15- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 308,000.00- 100.000 Subtotal: 309,700.00- 309,700.00- 308,040.79- 308,117.85- 99.489 1,582.15- Program number: 860,557.00- 860,557.00- 353,341.56- 504,876.87- 58.669 355,680.13- Department number: Revenues 860,557.00- 860,557.00- 353,341.56- 504,876.87- 58.669 355,680.13- Revenues Subtotal ----------- 860,557.00- 860,557.00- 353,341.56- 504,876.87- 58.669 355,680.13- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 18:34 03/12/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 2/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 1,000.00 1,000.00 25.000 3,000.00 533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 114,516.25 114,516.25 50.000 114,516.75 533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00 Subtotal: 838,033.00 838,033.00 115,516.25 115,516.25 13.784 722,516.75 Program number: 838,033.00 838,033.00 115,516.25 115,516.25 13.784 722,516.75 Department number: Administration 838,033.00 838,033.00 115,516.25 115,516.25 13.784 722,516.75 Expenditures Subtotal ----------- 838,033.00 838,033.00 115,516.25 115,516.25 13.784 722,516.75 Fund number: 533 MUD 1 I&S CONSOLIDATED 22,524.00- 22,524.00- 237,825.31- 389,360.62- 1,728.648 366,836.62 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 994 02/01/2013 Property Taxes/Assessments (148,206.30) (980.40) (149,186.70) GL 1018 02/01/2013 Property Taxes/Assessments (2,891.38) (152,078.08) GL 995 02/02/2013 Property Taxes/Assessments (31,055.78) (183,133.86) GL 996 02/04/2013 Property Taxes/Assessments (939.10) (184,072.96) GL 997 02/05/2013 Property Taxes/Assessments (887.36) (184,960.32) GL 998 02/06/2013 Property Taxes/Assessments (2,209.80) (187,170.12) GL 999 02/07/2013 Property Taxes/Assessments (2,259.78) (189,429.90) GL 1000 02/08/2013 Property Taxes/Assessments (189.21) (189,619.11) GL 1001 02/11/2013 Property Taxes/Assessments (649.67) (190,268.78) GL 1002 02/12/2013 Property Taxes/Assessments (1,802.52) (192,071.30) GL 1004 02/13/2013 Property Taxes/Assessments (232.63) (192,303.93) GL 1005 02/14/2013 Property Taxes/Assessments (100.35) (192,404.28) GL 1006 02/15/2013 Property Taxes/Assessments (189.69) (192,593.97) GL 1007 02/19/2013 Property Taxes/Assessments (5.61) (192,599.58) GL 1008 02/20/2013 Property Taxes/Assessments (504.32) (193,103.90) GL 1009 02/21/2013 Property Taxes/Assessments 65.25 (193,038.65) GL 1010 02/25/2013 Property Taxes/Assessments (7.02) (193,045.67) GL 1011 02/26/2013 Property Taxes/Assessments (111.74) (193,157.41) GL 1012 02/27/2013 Property Taxes/Assessments (14.25) (193,171.66) GL 1013 02/28/2013 Property Taxes/Assessments (236.43) (193,408.09) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (45,201.79) (193,408.09) ** (196,940.00) Budgeted (3,531.91) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent (2,279.88) .00 (2,279.88) _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 (2,279.88) ** (3,900.00) Budgeted (1,620.12) Remaining 58 % Used Account: 533-40015-000-000 Property Taxes/P & I 999 02/07/2013 Property Taxes/Assessments (972.07) (3.93) (976.00) GL 1005 02/14/2013 Property Taxes/Assessments (3.46) (979.46) GL 1006 02/15/2013 Property Taxes/Assessments (13.30) (992.76) GL 1007 02/19/2013 Property Taxes/Assessments (.40) (993.16) GL 1008 02/20/2013 Property Taxes/Assessments (34.44) (1,027.60) GL 1009 02/21/2013 Property Taxes/Assessments (18.61) (1,046.21) GL 1011 02/26/2013 Property Taxes/Assessments (7.29) (1,053.50) GL 1012 02/27/2013 Property Taxes/Assessments (.99) (1,054.49) GL 1013 02/28/2013 Property Taxes/Assessments (16.56) (1,071.05) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (98.98) (1,071.05) ** (5,017.00) Budgeted (3,945.95) Remaining 21 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (345,000.00) Budgeted (345,000.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 988 02/28/2013 Feb Bank Interest (77.06) (40.79) (117.85) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (40.79) (117.85) ** (1,700.00) Budgeted (1,582.15) Remaining 7 % Used Account: 533-49015-000-000 Lease/Rental Income 816 02/06/2013 Fire Rent Xfer to I&S Texpool (308,000.00) (308,000.00) GL _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: (308,000.00) (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (504,876.87) ** (860,557.00) Budgeted (355,680.13) Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 18:34 03/12/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 2/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 985 02/28/2013 Feb A/P Adm fee/Series 2010 500.00 500.00 BANK OF NEW YORK MELLON 32309 AP 985 02/28/2013 Feb A/P Adm fee/Series 2012 500.00 1,000.00 BANK OF NEW YORK MELLON 32309 AP _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 1,000.00 1,000.00 ** 4,000.00 Budgeted 3,000.00 Remaining 25 % Used Account: 533-70025-051-000 Bond Interest Expense 1017 02/27/2013 Bond Interest Payments M2 Ref CIB Ser 05 29,267.50 29,267.50 GL 1017 02/27/2013 Bond Interest Payments M2 Series 2003 15,645.00 44,912.50 GL 1017 02/27/2013 Bond Interest Payments M1 Series 2010 39,228.75 84,141.25 GL 1017 02/27/2013 Bond Interest Payments M1 Series 2012 30,375.00 114,516.25 GL _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: 114,516.25 114,516.25 ** 229,033.00 Budgeted 114,516.75 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 605,000.00 Budgeted 605,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 115,516.25 ** 838,033.00 Budgeted 722,516.75 Remaining 14 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (389,360.62) (22,524.00) Budgeted 366,836.62 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (478,423.85) **** (22,524.00) Budgeted 455,899.85 Remaining ########## ******* End of Report *********