Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
April Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET APRIL 30, 2013 FIRE DEPT. ASSETS CASH ON HAND - CASH IN BANK - INVESTMENTS 1,077,155 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 36,150 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 3,301 UTILITY AND OTHER ACCOUNTS RECEIVABLE 13,485 TOTAL ASSETS 1,130,091 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 39,425 ACCOUNTS AND OTHER PAYABLES 190,724 TOTAL LIABILITIES 230,149 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - UNASSIGNED FUND BALANCE 350,496 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 549,446 TOTAL FUND BALANCE 899,942 TOTAL LIABILITIES AND FUND BALANCE 1,130,091 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 16:15 05/08/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/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- 3,621.74- 253,118.93- 100.411 1,034.93 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 700.00- 5.36- .766 694.64- 122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 3,967.93- 1,044,318.75- 99.426 6,030.25- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 7,808.31 3,939.37 -67.920 9,739.37- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 320.81- 513.21- 68.428 236.79- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 398.64- 3,130.77- 69.573 1,369.23- Subtotal: 1,318,183.00- 1,314,183.00- 500.81- 1,297,147.65- 98.704 17,035.35- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 3,600.00- 60.000 2,400.00- Subtotal: 6,000.00- 6,000.00- 3,600.00- 60.000 2,400.00- 122-43400-000-000 Fire Inspections 500.00- 675.00- 675.00- 100.000 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,500.00- 10,675.00- 10,675.00- 100.000 122-49035-000-000 Prior Year Reserves 5,413.00- 5,413.00- 122-49900-000-000 Miscellaneous Income 1,200.00- 5,200.00- 5,239.26- 100.755 39.26 Subtotal: 1,200.00- 10,613.00- 5,239.26- 49.366 5,373.74- Program number: 1,335,883.00- 1,341,471.00- 500.81- 1,316,661.91- 98.151 24,809.09- Department number: Fire Revenues 1,335,883.00- 1,341,471.00- 500.81- 1,316,661.91- 98.151 24,809.09- Revenues Subtotal ----------- 1,335,883.00- 1,341,471.00- 500.81- 1,316,661.91- 98.151 24,809.09- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 16:15 05/08/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 444,717.00 444,717.00 33,097.23 243,369.46 54.725 201,347.54 122-50010-045-000 Overtime 31,375.00 37,076.00 4,104.13 22,642.17 61.070 14,433.83 122-50011-045-000 DPS Holiday Pay 13,083.00 12,083.00 12,080.51 99.979 2.49 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.11 100.003 .11- 122-50017-045-000 Certification 4,896.00 6,024.00 315.84 3,328.09 55.247 2,695.91 122-50020-045-000 Retirement 69,242.00 69,242.00 5,274.93 40,694.47 58.771 28,547.53 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,504.06 24,167.01 50.007 24,159.99 122-50027-045-000 Dental Insurance 3,635.00 3,836.00 322.96 2,240.82 58.416 1,595.18 122-50028-045-000 Vision Insurance 824.00 824.00 66.70 461.56 56.015 362.44 122-50029-045-000 Life Insurance & Other 4,250.00 5,974.00 597.25 3,583.95 59.992 2,390.05 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,138.03 17,109.26 55.375 13,787.74 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 500.01 4,001.33 55.374 3,224.67 122-50040-045-000 Unemployment Taxes 1,481.00 1,980.00 1,980.06 100.003 .06- 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 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 684,647.00 49,921.14 390,207.85 56.994 294,439.15 122-55045-045-000 Legal 5,000.00 2,007.40 40.148 2,992.60 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 187.75 4,704.25 49.197 4,857.75 122-55090-045-000 Vehicle Maintenance 14,850.00 14,600.00 147.93 2,301.98 15.767 12,298.02 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 6,518.15 66.457 3,289.85 122-55100-045-000 Building Maintenance 6,500.00 5,500.00 592.17 2,178.33 39.606 3,321.67 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 405.50 36.763 697.50 122-55160-045-000 Professional Outside Services 2,500.00 Subtotal: 44,323.00 45,573.00 927.85 18,115.61 39.751 27,457.39 122-60005-045-000 Telephone 106.00 106.00 6.91 37.52 35.396 68.48 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 3,500.00 315.70 2,651.29 75.751 848.71 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 909.57 4,185.83 67.875 1,981.17 122-60025-045-000 Water 1,400.00 1,400.00 70.92 694.87 49.634 705.13 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 100.00 100.00 41.20 41.200 58.80 122-60055-045-000 Insurance 10,000.00 10,000.00 10,000.00 100.000 122-60066-045-000 Publications/Books/Subscrips 410.00 410.00 410.00 122-60070-045-000 Dues & Memberships 7,500.00 8,000.00 7,955.91 99.449 44.09 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 1,360.00 3,004.00 60.080 1,996.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 76.37 1,814.95 37.811 2,985.05 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 16:15 05/08/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 188.96 2,387.90 56.855 1,812.10 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 2,150.00 40.00 778.97 36.231 1,371.03 122-60195-045-000 Flags & Repair 2,543.00 2,293.00 659.75 28.772 1,633.25 122-60243-045-000 Prior Year Expense 2,088.00 2,088.44 100.021 .44- 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 70.00 559.63 45.241 677.37 Subtotal: 359,088.00 362,676.00 3,038.43 345,982.61 95.397 16,693.39 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 547.95 4,364.58 43.646 5,635.42 122-65010-045-000 Uniforms 4,357.00 3,357.00 915.32 27.266 2,441.68 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 330.00 1,000.00 13.158 6,600.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 2,400.00 323.06 1,565.98 65.249 834.02 122-65085-045-000 Office Supplies 1,200.00 1,200.00 72.24 175.64 14.637 1,024.36 122-65095-045-000 Maintenance Supplies 2,785.00 1,988.00 461.57 1,167.38 58.721 820.62 122-65105-045-000 Printing 106.00 Subtotal: 32,048.00 27,545.00 1,734.82 9,590.90 34.819 17,954.10 122-69006-045-000 Grant Match 3,000.00 122-69008-045-000 Short Term Debt-Principal 72,932.00 72,932.00 2,966.05 4.067 69,965.95 122-69050-045-000 Radios 2,500.00 2,500.00 353.13 14.125 2,146.87 122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 145,598.00 Subtotal: 224,030.00 221,030.00 3,319.18 1.502 217,710.82 Program number: 1,335,883.00 1,341,471.00 55,622.24 767,216.15 57.192 574,254.85 Department number: Fire 1,335,883.00 1,341,471.00 55,622.24 767,216.15 57.192 574,254.85 Expenditures Subtotal ----------- 1,335,883.00 1,341,471.00 55,622.24 767,216.15 57.192 574,254.85 Fund number: 122 Trophy Club MUD Fire Dept. 55,121.43 549,445.76- 549,445.76 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/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 1353 04/01/2013 Property Taxes/Assessments (249,497.19) (244.45) (249,741.64) GL 1355 04/02/2013 Property Taxes/Assessments (2,133.26) (251,874.90) GL 1398 04/02/2013 Property Taxes/Assessments (2,133.26) (254,008.16) GL 1399 04/02/2013 Reverse JE1398/duplicate entry 2,133.26 (251,874.90) GL 1356 04/05/2013 Property Taxes/Assessments (512.66) (252,387.56) GL 1359 04/11/2013 Property Taxes/Assessments (106.67) (252,494.23) GL 1358 04/16/2013 Property Taxes/Assessments (82.67) (252,576.90) GL 1364 04/24/2013 Property Taxes/Assessments (444.91) (253,021.81) GL 1396 04/30/2013 Property Taxes/Assessments (97.12) (253,118.93) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (3,621.74) (253,118.93) ** (252,084.00) Budgeted 1,034.93 Remaining 100 % 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) ** (700.00) Budgeted (694.64) Remaining 1 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1353 04/01/2013 Property Taxes/Assessments (1,040,350.82) (486.65) (1,040,837.47) GL 1355 04/02/2013 Property Taxes/Assessments (1,109.36) (1,041,946.83) GL 1356 04/05/2013 Property Taxes/Assessments (727.19) (1,042,674.02) GL 1357 04/08/2013 Property Taxes/Assessments (223.83) (1,042,897.85) GL 1359 04/11/2013 Property Taxes/Assessments 731.43 (1,042,166.42) GL 1358 04/16/2013 Property Taxes/Assessments (65.47) (1,042,231.89) GL 1361 04/18/2013 Property Taxes/Assessments (19.51) (1,042,251.40) GL 1362 04/19/2013 Property Taxes/Assessments (326.17) (1,042,577.57) GL 1363 04/23/2013 Property Taxes/Assessments (39.45) (1,042,617.02) GL 1364 04/24/2013 Property Taxes/Assessments (458.09) (1,043,075.11) GL 1394 04/25/2013 Property Taxes/Assessments (141.13) (1,043,216.24) GL 1395 04/29/2013 Property Taxes/Assessments (191.69) (1,043,407.93) GL 1396 04/30/2013 Property Taxes/Assessments (910.82) (1,044,318.75) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,967.93) (1,044,318.75) ** (1,050,349.00) Budgeted (6,030.25) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1356 04/05/2013 Property Taxes/Assessments (3,868.94) (3.70) (3,872.64) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1394 04/25/2013 Property Taxes/Assessments (3,868.94) 8,087.91 4,215.27 GL 1396 04/30/2013 Property Taxes/Assessments (275.90) 3,939.37 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 7,808.31 3,939.37 ** (5,800.00) Budgeted (9,739.37) Remaining -68 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1353 04/01/2013 Property Taxes/Assessments (192.40) (22.00) (214.40) GL 1355 04/02/2013 Property Taxes/Assessments (192.00) (406.40) GL 1398 04/02/2013 Property Taxes/Assessments (192.00) (598.40) GL 1399 04/02/2013 Reverse JE1398/duplicate entry 192.00 (406.40) GL 1356 04/05/2013 Property Taxes/Assessments (46.14) (452.54) GL 1359 04/11/2013 Property Taxes/Assessments (11.73) (464.27) GL 1364 04/24/2013 Property Taxes/Assessments (48.94) (513.21) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (320.81) (513.21) ** (750.00) Budgeted (236.79) Remaining 68 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1355 04/02/2013 Property Taxes/Assessments (2,732.13) (74.98) (2,807.11) GL 1356 04/05/2013 Property Taxes/Assessments (55.99) (2,863.10) GL 1357 04/08/2013 Property Taxes/Assessments (24.61) (2,887.71) GL 1359 04/11/2013 Property Taxes/Assessments (11.53) (2,899.24) GL 1362 04/19/2013 Property Taxes/Assessments (36.28) (2,935.52) GL 1363 04/23/2013 Property Taxes/Assessments (4.35) (2,939.87) GL 1364 04/24/2013 Property Taxes/Assessments (50.40) (2,990.27) GL 1395 04/29/2013 Property Taxes/Assessments (19.32) (3,009.59) GL 1396 04/30/2013 Property Taxes/Assessments (121.18) (3,130.77) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (398.64) (3,130.77) ** (4,500.00) Budgeted (1,369.23) Remaining 70 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (3,600.00) .00 (3,600.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (3,600.00) ** (6,000.00) Budgeted (2,400.00) Remaining 60 % Used Account: 122-43400-000-000 Fire Inspections . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (675.00) .00 (675.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (675.00) ** (675.00) Budgeted .00 Remaining 100 % 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-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (5,413.00) Budgeted (5,413.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income (5,239.26) .00 (5,239.26) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (5,239.26) ** (5,200.00) Budgeted 39.26 Remaining 101 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,316,661.91) ** (1,341,471.00) Budgeted (24,809.09) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 1286 04/12/2013 FD Payroll 4/12/13 210,272.23 16,858.74 227,130.97 GL 1371 04/26/2013 FD Payroll 4/26/13 16,238.49 243,369.46 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 33,097.23 243,369.46 ** 444,717.00 Budgeted 201,347.54 Remaining 55 % Used Account: 122-50010-045-000 Overtime 1286 04/12/2013 FD Payroll 4/12/13 18,538.04 4,104.13 22,642.17 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,104.13 22,642.17 ** 37,076.00 Budgeted 14,433.83 Remaining 61 % Used Account: 122-50011-045-000 DPS Holiday Pay 12,080.51 .00 12,080.51 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 12,080.51 ** 12,083.00 Budgeted 2.49 Remaining 100 % Used Account: 122-50016-045-000 Longevity 4,266.11 .00 4,266.11 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,266.11 ** 4,266.00 Budgeted (.11) Remaining 100 % Used Account: 122-50017-045-000 Certification 1286 04/12/2013 FD Payroll 4/12/13 3,012.25 315.84 3,328.09 GL _______________ Account: 122-50017-045-000 Certification Totals: 315.84 3,328.09 ** 6,024.00 Budgeted 2,695.91 Remaining 55 % Used Account: 122-50020-045-000 Retirement 1286 04/12/2013 FD Payroll 4/12/13 35,419.54 2,991.80 38,411.34 GL 1371 04/26/2013 FD Payroll 4/26/13 2,283.13 40,694.47 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,274.93 40,694.47 ** 69,242.00 Budgeted 28,547.53 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 1286 04/12/2013 FD Payroll 4/12/13 20,662.95 1,752.02 22,414.97 GL 1371 04/26/2013 FD Payroll 4/26/13 1,752.04 24,167.01 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,504.06 24,167.01 ** 48,327.00 Budgeted 24,159.99 Remaining 50 % Used Account: 122-50027-045-000 Dental Insurance 1286 04/12/2013 FD Payroll 4/12/13 1,917.86 161.47 2,079.33 GL 1371 04/26/2013 FD Payroll 4/26/13 161.49 2,240.82 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 322.96 2,240.82 ** 3,836.00 Budgeted 1,595.18 Remaining 58 % Used Account: 122-50028-045-000 Vision Insurance 1286 04/12/2013 FD Payroll 4/12/13 394.86 33.36 428.22 GL 1371 04/26/2013 FD Payroll 4/26/13 33.34 461.56 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 66.70 461.56 ** 824.00 Budgeted 362.44 Remaining 56 % Used Account: 122-50029-045-000 Life Insurance & Other 1286 04/12/2013 FD Payroll 4/12/13 2,986.70 298.58 3,285.28 GL 1371 04/26/2013 FD Payroll 4/26/13 298.67 3,583.95 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 597.25 3,583.95 ** 5,974.00 Budgeted 2,390.05 Remaining 60 % Used Account: 122-50030-045-000 Social Security Taxes 1286 04/12/2013 FD Payroll 4/12/13 14,971.23 1,225.31 16,196.54 GL 1371 04/26/2013 FD Payroll 4/26/13 912.72 17,109.26 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,138.03 17,109.26 ** 30,897.00 Budgeted 13,787.74 Remaining 55 % Used Account: 122-50035-045-000 Medicare Taxes 1286 04/12/2013 FD Payroll 4/12/13 3,501.32 286.55 3,787.87 GL 1371 04/26/2013 FD Payroll 4/26/13 213.46 4,001.33 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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: 500.01 4,001.33 ** 7,226.00 Budgeted 3,224.67 Remaining 55 % Used Account: 122-50040-045-000 Unemployment Taxes 1,980.06 .00 1,980.06 _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .00 1,980.06 ** 1,980.00 Budgeted (.06) Remaining 100 % 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 283.05 .00 283.05 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 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 2,007.40 .00 2,007.40 _______________ Account: 122-55045-045-000 Legal Totals: .00 2,007.40 ** 5,000.00 Budgeted 2,992.60 Remaining 40 % Used Account: 122-55080-045-000 Maintenance & Repairs 1271 04/15/2013 April A/P Qtrly Air test on Bauer UN3 Ai 4,516.50 187.75 4,704.25 AUGUST INDUSTRIES, INC 32418 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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-55080-045-000 Maintenance & Repairs Totals: 187.75 4,704.25 ** 9,562.00 Budgeted 4,857.75 Remaining 49 % Used Account: 122-55090-045-000 Vehicle Maintenance 1409 04/30/2013 3/27/13-4/26/13 PCards AUTOZONE #4206 2,154.05 147.93 2,301.98 AUTOZONE #4206 PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 147.93 2,301.98 ** 14,600.00 Budgeted 12,298.02 Remaining 16 % Used Account: 122-55095-045-000 Equipment Maintenance 6,518.15 .00 6,518.15 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 6,518.15 ** 9,808.00 Budgeted 3,289.85 Remaining 66 % Used Account: 122-55100-045-000 Building Maintenance 1244 04/10/2013 2/26-3/27 PCards ATT*BILL PAYMENT 1,586.16 157.83 1,743.99 ATT*BILL PAYMENT PC 1244 04/10/2013 2/26-3/27 PCards ATT*BILL PAYMENT 128.68 1,872.67 ATT*BILL PAYMENT PC 1304 04/19/2013 Town Billing Inv 1016-1020 AR 20130401-20130419 User: (24.51) 1,848.16 AR 1409 04/30/2013 3/27/13-4/26/13 PCards ATT*BILL PAYMENT 128.68 1,976.84 ATT*BILL PAYMENT PC 1409 04/30/2013 3/27/13-4/26/13 PCards ATT*BILL PAYMENT 157.83 2,134.67 ATT*BILL PAYMENT PC 1409 04/30/2013 3/27/13-4/26/13 PCards THE HOME DEPOT 6581 43.66 2,178.33 THE HOME DEPOT 6581 PC _______________ Account: 122-55100-045-000 Building Maintenance Totals: 592.17 2,178.33 ** 5,500.00 Budgeted 3,321.67 Remaining 40 % Used Account: 122-55110-045-000 Maintenance-Radios 405.50 .00 405.50 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 405.50 ** 1,103.00 Budgeted 697.50 Remaining 37 % Used Account: 122-60005-045-000 Telephone 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 30.61 6.91 37.52 TOWN OF TROPHY CLUB 32479 AP _______________ Account: 122-60005-045-000 Telephone Totals: 6.91 37.52 ** 106.00 Budgeted 68.48 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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-60010-045-000 Communications/Pagers/Mobiles 1286 04/12/2013 FD Payroll 4/12/13 2,335.59 75.80 2,411.39 GL 1271 04/15/2013 April A/P Verizon Invoice 9702057336 239.90 2,651.29 TOWN OF TROPHY CLUB 32479 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 315.70 2,651.29 ** 3,500.00 Budgeted 848.71 Remaining 76 % Used Account: 122-60020-045-000 Electricity/Gas 1304 04/19/2013 Town Billing Inv 1016-1020 AR 20130401-20130419 User: 3,276.26 (58.23) 3,218.03 AR 1328 04/24/2013 April A/P Electricity 3/14-4/15 851.33 4,069.36 HUDSON ENERGY SERVICES, LLC 32499 AP 1328 04/24/2013 April A/P Gas/Fire Station 3/18-4/11 116.47 4,185.83 ATMOS ENERGY 32490 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 909.57 4,185.83 ** 6,167.00 Budgeted 1,981.17 Remaining 68 % Used Account: 122-60025-045-000 Water 1271 04/15/2013 April A/P 623.95 129.12 753.07 TROPHY CLUB MUD (WATER BILLS) 32482 AP 1271 04/15/2013 April A/P Water-March 12.71 765.78 TROPHY CLUB MUD (WATER BILLS) 32482 AP 1304 04/19/2013 Town Billing Inv 1016-1020 AR 20130401-20130419 User: (70.91) 694.87 AR _______________ Account: 122-60025-045-000 Water Totals: 70.92 694.87 ** 1,400.00 Budgeted 705.13 Remaining 50 % Used Account: 122-60030-045-000 Rent And/Or Usage 308,000.00 .00 308,000.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 41.20 .00 41.20 _______________ Account: 122-60035-045-000 Postage Totals: .00 41.20 ** 100.00 Budgeted 58.80 Remaining 41 % Used Account: 122-60055-045-000 Insurance 10,000.00 .00 10,000.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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-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 7,955.91 .00 7,955.91 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 7,955.91 ** 8,000.00 Budgeted 44.09 Remaining 99 % 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 1328 04/24/2013 April A/P EMS/Fire Training Modules 1,644.00 1,190.00 2,834.00 KAPLAN HIGHER EDUCATION CORP 32501 AP 1328 04/24/2013 April A/P EMS/Fire training Modules 170.00 3,004.00 KAPLAN HIGHER EDUCATION CORP 32501 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 1,360.00 3,004.00 ** 5,000.00 Budgeted 1,996.00 Remaining 60 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 1409 04/30/2013 3/27/13-4/26/13 PCards CROWNE PLAZA HOTELS 1,738.58 11.70 1,750.28 CROWNE PLAZA HOTELS PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1409 04/30/2013 3/27/13-4/26/13 PCards CROWNE PLAZA HOTELS 1,738.58 12.89 1,763.17 CROWNE PLAZA HOTELS PC 1409 04/30/2013 3/27/13-4/26/13 PCards CROWNE PLAZA HOTELS 15.89 1,779.06 CROWNE PLAZA HOTELS PC 1409 04/30/2013 3/27/13-4/26/13 PCards CROWNE PLAZA HOTELS 15.89 1,794.95 CROWNE PLAZA HOTELS PC 1409 04/30/2013 3/27/13-4/26/13 PCards GO EXPRESS TRAVEL 20.00 1,814.95 GO EXPRESS TRAVEL PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 76.37 1,814.95 ** 4,800.00 Budgeted 2,985.05 Remaining 38 % 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 1409 04/30/2013 3/27/13-4/26/13 PCards TAGG TEAM SPORTS & MOR 2,198.94 188.96 2,387.90 TAGG TEAM SPORTS & MOR PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 188.96 2,387.90 ** 4,200.00 Budgeted 1,812.10 Remaining 57 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 1409 04/30/2013 3/27/13-4/26/13 PCards FEDEXOFFICE 00014241 738.97 40.00 778.97 FEDEXOFFICE 00014241 PC _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 40.00 778.97 ** 2,150.00 Budgeted 1,371.03 Remaining 36 % Used Account: 122-60195-045-000 Flags & Repair 659.75 .00 659.75 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 659.75 ** 2,293.00 Budgeted 1,633.25 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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-60243-045-000 Prior Year Expense 2,088.44 .00 2,088.44 _______________ Account: 122-60243-045-000 Prior Year Expense Totals: .00 2,088.44 ** 2,088.00 Budgeted (.44) Remaining 100 % Used Account: 122-60245-045-000 Miscellaneous Expense 1409 04/30/2013 3/27/13-4/26/13 PCards VINNYS ITALIAN RESTAUR 489.63 70.00 559.63 VINNYS ITALIAN RESTAUR PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 70.00 559.63 ** 1,237.00 Budgeted 677.37 Remaining 45 % Used Account: 122-65005-045-000 Fuel & Lube 1315 04/01/2013 March Gas Log 3,816.63 547.95 4,364.58 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 547.95 4,364.58 ** 10,000.00 Budgeted 5,635.42 Remaining 44 % Used Account: 122-65010-045-000 Uniforms 915.32 .00 915.32 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 915.32 ** 3,357.00 Budgeted 2,441.68 Remaining 27 % Used Account: 122-65015-045-000 Protective Clothing 1271 04/15/2013 April A/P Boots/Cloud, Hydra Valve for E 670.00 330.00 1,000.00 CASCO INDUSTRIES INC 32422 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 330.00 1,000.00 ** 7,600.00 Budgeted 6,600.00 Remaining 13 % 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 Account: 122-65035-045-000 Small Tools . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1271 04/15/2013 April A/P Boots/Cloud, Hydra Valve for E 1,242.92 185.00 1,427.92 CASCO INDUSTRIES INC 32422 AP 1409 04/30/2013 3/27/13-4/26/13 PCards NEW SIOUX CITY IRON 138.06 1,565.98 NEW SIOUX CITY IRON PC _______________ Account: 122-65035-045-000 Small Tools Totals: 323.06 1,565.98 ** 2,400.00 Budgeted 834.02 Remaining 65 % Used Account: 122-65085-045-000 Office Supplies 1271 04/15/2013 April A/P Office supplies 103.40 72.24 175.64 OFFICE DEPOT, INC 32463 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 72.24 175.64 ** 1,200.00 Budgeted 1,024.36 Remaining 15 % Used Account: 122-65095-045-000 Maintenance Supplies 1271 04/15/2013 April A/P Costco purchases 705.81 79.54 785.35 COSTCO WHOLESALE 32426 AP 1409 04/30/2013 3/27/13-4/26/13 PCards SAMSCLUB #4795 148.11 933.46 SAMSCLUB #4795 PC 1409 04/30/2013 3/27/13-4/26/13 PCards SAMSCLUB #4795 178.16 1,111.62 SAMSCLUB #4795 PC 1409 04/30/2013 3/27/13-4/26/13 PCards SPLIT - 12265095045 (19.96%) 55.76 1,167.38 SAMSCLUB #4795 PC _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 461.57 1,167.38 ** 1,988.00 Budgeted 820.62 Remaining 59 % Used Account: 122-69008-045-000 Short Term Debt-Principal 2,966.05 .00 2,966.05 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 2,966.05 ** 72,932.00 Budgeted 69,965.95 Remaining 4 % Used Account: 122-69050-045-000 Radios 353.13 .00 353.13 _______________ Account: 122-69050-045-000 Radios Totals: .00 353.13 ** 2,500.00 Budgeted 2,146.87 Remaining 14 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 145,598.00 Budgeted 145,598.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 45 Totals: ------------------------------------------------------------------------------------------------ 767,216.15 ** 1,341,471.00 Budgeted 574,254.85 Remaining 57 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (549,445.76) .00 Budgeted 549,445.76 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET APRIL 30, 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 4/30/13 ASSETS CASH ON HAND 400 - - 400 CASH IN BANK 649,254 - - 649,254 INVESTMENTS 2,127,545 214,249 398,397 2,740,191 PREPAID EXPENSES 21,080 - - 21,080 ADVALOREM PROPERTY TAXES RECEIVABLE 4,219 - - 4,219 UTILITY AND OTHER ACCOUNTS RECEIVABLE 649,000 - - 649,000 - TOTAL ASSETS 3,451,498 214,249 398,397 4,064,144 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,219 - - 4,219 ACCOUNTS AND OTHER PAYABLES 291,984 - 2,663 294,647 CUSTOMER DEPOSITS 220,272 - - 220,272 - TOTAL LIABILITIES 516,475 - 2,663 519,138 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 214,249 38,101 252,350 ASSIGNED FUND BALANCE 456,156 UNASSIGNED FUND BALANCE 2,825,965 - - 2,825,965 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (347,097) - 357,633 10,535 - TOTAL FUND BALANCE 2,935,023 214,249 395,734 3,545,006 - TOTAL LIABILITIES AND FUND BALANCE 3,451,498 214,249 398,397 4,064,144 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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- 374.87- 99,308.20- 99.424 575.80- 135-40002-000-000 Property Taxes/Delinquent 500.00- 624.00- 1,005.72 381.99 -61.216 1,005.99- 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 38.10- 695.90- 57.992 504.10- Subtotal: 101,584.00- 101,708.00- 592.75 99,622.11- 97.949 2,085.89- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 228,277.66- 1,493,183.27- 42.114 2,052,425.73- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 147,965.45- 946,337.56- 57.224 707,409.44- 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,162.63- 29,435.15- 45.579 35,144.85- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 928.00- 7,247.94- 62.348 4,377.06- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 50.00 500.00- 27.778 1,300.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 150.00 1,950.00- 37.500 3,250.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 12,578.15- 16.214 64,996.85- Subtotal: 5,360,712.00- 5,360,712.00- 380,133.74- 2,491,381.97- 46.475 2,869,330.03- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 184,000.00- 28.571 460,000.00- Subtotal: 644,000.00- 644,000.00- 184,000.00- 28.571 460,000.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 348.25- 3,112.01- 56.582 2,387.99- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 6,310.18- 62.084 3,853.82- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 1,749.99- 4,083.31- 58.333 2,916.69- 135-49030-000-000 Vending Revenue 350.00- 350.00- 11.97- 48.31- 13.803 301.69- 135-49035-000-000 Prior Year Reserves 305,748.00- 234,014.00- 234,014.00- 135-49075-000-000 Oversize Meter Reimbursement 73,000.00- 73,000.00- 317.00 30,543.69- 41.841 42,456.31- 135-49141-000-000 Interfund Trans In (Cap Proj) 38,101.00- 38,101.42- 100.001 .42 135-49900-000-000 Miscellaneous Income 1,000.00- 13,213.00- 5,533.80- 14,746.44- 111.606 1,533.44 135-49901-000-000 Records Management Revenue 109.00- 109.00- 100.000 135-49903-000-000 Recovery of Prior Year Expense 2,117.50- 2,117.50 135-49905-000-000 Gas Well Revenue 200.00- 286.00- 259.69- 545.71- 190.808 259.71 Subtotal: 402,962.00- 381,737.00- 8,497.23- 99,717.57- 26.122 282,019.43- Program number: 6,509,258.00- 6,488,157.00- 388,038.22- 2,874,721.65- 44.307 3,613,435.35- Department number: Revenues 6,509,258.00- 6,488,157.00- 388,038.22- 2,874,721.65- 44.307 3,613,435.35- Revenues Subtotal ----------- 6,509,258.00- 6,488,157.00- 388,038.22- 2,874,721.65- 44.307 3,613,435.35- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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,431.04 94,153.50 44.137 119,167.50 135-50010-010-000 Overtime 13,250.00 19,250.00 955.75 8,553.65 44.435 10,696.35 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 375.00 2,625.00 51.471 2,475.00 135-50020-010-000 Retirement 32,725.00 57,748.00 1,325.61 37,923.84 65.671 19,824.16 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 2,113.96 13,507.60 46.707 15,412.40 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 145.51 980.38 46.886 1,110.62 135-50028-010-000 Vision Insurance 519.00 519.00 33.91 230.80 44.470 288.20 135-50029-010-000 Life Insurance & Other 1,204.00 1,532.00 90.06 856.31 55.895 675.69 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 895.05 6,838.19 46.982 7,716.81 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 209.32 1,599.25 46.981 1,804.75 135-50040-010-000 Unemployment Taxes 945.00 945.00 .89 297.16 31.446 647.84 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 5,151.35- 6,292.65 103.006 183.65- 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 63.00 31.500 137.00 135-50070-010-000 Employee Relations 350.00 350.00 16.81 99.46 28.417 250.54 Subtotal: 325,773.00 357,124.00 14,441.56 177,100.79 49.591 180,023.21 135-55005-010-000 Engineering 3,000.00 2,000.00 2,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 3,834.32 22,755.10 45.510 27,244.90 135-55090-010-000 Vehicle Maintenance 3,700.00 4,650.00 560.36 2,884.92 62.041 1,765.08 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 1,767.04 60.932 1,132.96 135-55135-010-000 Lab Analysis 4,500.00 5,384.00 657.47 3,348.81 62.199 2,035.19 Subtotal: 64,100.00 64,934.00 5,052.15 30,755.87 47.365 34,178.13 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 175.78 878.96 43.948 1,121.04 135-60020-010-000 Electricity 162,410.00 162,410.00 7,761.99 55,183.94 33.978 107,226.06 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 100.000 135-60080-010-000 Schools & Training 1,672.00 1,472.00 351.00 23.845 1,121.00 135-60090-010-000 Safety Program 500.00 400.00 400.00 135-60100-010-000 Travel & per diem 700.00 800.00 551.69 68.961 248.31 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 12.00 2.400 488.00 135-60135-010-000 TCEQ Fees & Permits 35,800.00 42,743.00 40,524.75 94.810 2,218.25 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 83,161.11 583,010.08 28.742 1,445,436.92 135-60243-010-000 Prior Year Expense 756.00 756.00 100.000 135-60245-010-000 Miscellaneous Expenses 500.00 200.00 200.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 344.59 833.54 19.846 3,366.46 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 500.00 38.99 7.798 461.01 Subtotal: 2,239,129.00 2,245,328.00 91,449.47 682,290.95 30.387 1,563,037.05 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 1,899.72 6,626.70 37.522 11,034.30 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 208.18 2,430.10 39.195 3,769.90 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 1,000.00 256.82 25.682 743.18 135-65050-010-000 Meter Expense 143,550.00 143,550.00 1,840.00 99,233.00 69.128 44,317.00 135-65085-010-000 Office Supplies 109.68 109.68- Subtotal: 173,591.00 172,591.00 3,947.90 110,541.31 64.048 62,049.69 135-69005-010-000 Capital Expenses 181,800.00 8,000.00 3,145.00- 1,094.96- -13.687 9,094.96 135-69008-010-000 Short Term Debt-Principal 387,037.00 366,000.00 366,000.00 135-69009-010-000 Short Term Debt-Interest 21,037.00 10,376.98 49.327 10,660.02 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 60,000.00 59,869.00 99.782 131.00 135-69281-010-000 Capital Repair-Ground Storage 150,000.00 100,900.00 100,816.54 99.917 83.46 Subtotal: 1,018,837.00 585,937.00 3,145.00- 169,967.56 29.008 415,969.44 Program number: 3,821,430.00 3,425,914.00 111,746.08 1,170,656.48 34.171 2,255,257.52 Department number: Water 3,821,430.00 3,425,914.00 111,746.08 1,170,656.48 34.171 2,255,257.52 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 12,065.32 103,628.79 52.662 93,152.21 135-50010-020-000 Overtime 10,166.00 17,546.00 474.67 7,748.44 44.161 9,797.56 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 300.00 2,400.00 57.143 1,800.00 135-50020-020-000 Retirement 29,821.00 54,844.00 1,153.03 38,778.92 70.708 16,065.08 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 2,764.74 19,626.33 67.598 9,407.67 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 195.56 1,400.96 66.333 711.04 135-50028-020-000 Vision Insurance 552.00 552.00 41.15 351.11 63.607 200.89 135-50029-020-000 Life Insurance & Other 920.00 1,377.00 85.17 927.91 67.386 449.09 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 670.71 6,458.19 48.675 6,809.81 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 156.87 1,510.37 48.675 1,592.63 135-50040-020-000 Unemployment Taxes 756.00 756.00 309.05 40.880 446.95 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 2,443.73- 5,409.27 184.051 2,470.27- 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 126.00 84.000 24.00 135-50070-020-000 Employee Relations 350.00 350.00 16.81 79.18 22.623 270.82 Subtotal: 297,010.00 329,870.00 15,480.30 191,612.02 58.087 138,257.98 135-55070-020-000 Independent Labor 1,000.00 84,418.00 20,067.00 66,000.00 78.182 18,418.00 135-55080-020-000 Maintenance & Repairs 40,000.00 41,205.00 4,488.92 40,193.05 97.544 1,011.95 135-55090-020-000 Vehicle Maintenance 2,000.00 3,350.00 284.49 3,633.13 108.452 283.13- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,080.96 72.064 419.04 135-55125-020-000 Dumpster Services 15,000.00 49,611.00 4,711.43 26,248.37 52.908 23,362.63 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,943.15 15,827.65 52.759 14,172.35 Subtotal: 89,500.00 210,084.00 32,494.99 152,983.16 72.820 57,100.84 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 3,981.00 231.09 1,239.63 31.139 2,741.37 135-60020-020-000 Electricity 153,045.00 153,045.00 10,515.20 74,532.53 48.700 78,512.47 135-60066-020-000 Publications/Books/Subscripts 500.00 200.00 161.45 80.725 38.55 135-60080-020-000 Schools & Training 3,272.00 3,272.00 411.00 1,071.66 32.752 2,200.34 135-60090-020-000 Safety Program 250.00 135-60100-020-000 Travel & per diem 1,400.00 1,400.00 1,386.39 2,202.66 157.333 802.66- 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 103.00 1,123.00 74.867 377.00 135-60125-020-000 Advertising 2,000.00 300.00 112.50 37.500 187.50 135-60135-020-000 TCEQ Fees & Permits 56,000.00 15,600.00 7,887.19 50.559 7,712.81 135-60136-020-000 TCEQ Environmental Proj (SEP) 40,400.00 40,400.00 135-60243-020-000 Prior Year Expense 802.00 801.59 99.949 .41 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 67.08 412.23 82.446 87.77 Subtotal: 221,367.00 221,200.00 12,713.76 89,692.54 40.548 131,507.46 135-65005-020-000 Fuel & Lube 8,527.00 10,527.00 1,840.25 7,060.95 67.075 3,466.05 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-020-000 Uniforms 2,574.00 1,574.00 773.70 49.155 800.30 135-65030-020-000 Chemicals 10,000.00 38,346.00 1,685.38 20,030.90 52.237 18,315.10 135-65035-020-000 Small Tools 1,000.00 1,000.00 333.47 33.347 666.53 135-65040-020-000 Safety Equipment 250.00 500.00 31.12 483.26 96.652 16.74 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 3,607.76 11,199.47 111.995 1,199.47- Subtotal: 32,351.00 61,947.00 7,164.51 39,881.75 64.380 22,065.25 135-69005-020-000 Capital Expenses 241,200.00 446,484.00 4,289.00- 442,195.29 99.039 4,288.71 135-69280-020-000 Capital Repairs 158,000.00 27,960.70- Subtotal: 399,200.00 446,484.00 32,249.70- 442,195.29 99.039 4,288.71 Program number: 1,039,428.00 1,269,585.00 35,603.86 916,364.76 72.178 353,220.24 Department number: Wastewater 1,039,428.00 1,269,585.00 35,603.86 916,364.76 72.178 353,220.24 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 156,475.00 156,475.00 11,782.74 83,121.39 53.121 73,353.61 135-50010-021-000 Overtime 7,297.00 12,158.00 641.24 5,722.44 47.067 6,435.56 135-50016-021-000 Longevity 3,818.00 3,818.00 3,817.50 99.987 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 1,000.00 55.556 800.00 135-50020-021-000 Retirement 23,574.00 42,910.00 1,129.13 30,420.88 70.895 12,489.12 135-50026-021-000 Medical Insurance 20,198.00 25,940.00 2,321.55 14,335.44 55.264 11,604.56 135-50027-021-000 Dental Insurance 1,409.00 1,812.00 159.88 1,012.96 55.903 799.04 135-50028-021-000 Vision Insurance 357.00 383.00 32.60 219.52 57.316 163.48 135-50029-021-000 Life Insurance & Other 1,008.00 1,223.00 64.78 675.11 55.201 547.89 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 712.27 5,580.00 53.133 4,922.00 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 166.58 1,304.98 53.134 1,151.02 135-50040-021-000 Unemployment Taxes 567.00 567.00 .15 241.27 42.552 325.73 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 2,794.12- 4,344.88 129.775 996.88- 135-50070-021-000 Employee Relations 250.00 250.00 36.26 95.95 38.380 154.05 Subtotal: 233,059.00 263,642.00 14,403.06 151,892.32 57.613 111,749.68 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 20,000.00 8,224.73 14,946.18 74.731 5,053.82 135-55090-021-000 Vehicle Maintenance 1,900.00 1,600.00 731.03 1,041.26 65.079 558.74 Subtotal: 38,400.00 21,600.00 8,955.76 15,987.44 74.016 5,612.56 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 216.98 1,362.51 38.929 2,137.49 135-60020-021-000 Electricity 18,705.00 18,705.00 2,556.56 10,466.59 55.956 8,238.41 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 100.000 135-60080-021-000 Schools & Training 826.00 826.00 830.00 100.484 4.00- 135-60090-021-000 Safety Program 500.00 300.00 300.00 135-60100-021-000 Travel & per diem 450.00 450.00 1,279.14 1,574.47 349.882 1,124.47- 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60243-021-000 Prior Year Expense 621.00 620.83 99.973 .17 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 34,331.00 34,752.00 4,052.68 15,104.40 43.463 19,647.60 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 874.83 5,576.47 46.022 6,540.53 135-65010-021-000 Uniforms 2,220.00 2,220.00 934.13 42.078 1,285.87 135-65030-021-000 Chemicals 7,500.00 7,500.00 2,221.00 29.613 5,279.00 135-65035-021-000 Small Tools 1,500.00 1,250.00 70.00 5.600 1,180.00 135-65040-021-000 Safety Equipment 500.00 500.00 120.00 24.000 380.00 Subtotal: 23,837.00 23,587.00 874.83 8,921.60 37.824 14,665.40 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 90,000.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69008-021-000 Short Term Debt-Principal 40,260.00 40,260.00 40,260.00 Subtotal: 130,260.00 130,260.00 130,260.00 Program number: 459,887.00 473,841.00 28,286.33 191,905.76 40.500 281,935.24 Department number: Collection 459,887.00 473,841.00 28,286.33 191,905.76 40.500 281,935.24 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,100.00 5,600.00 56.000 4,400.00 135-50030-026-000 Social Security Taxes 620.00 620.00 68.20 347.20 56.000 272.80 135-50035-026-000 Medicare Taxes 145.00 145.00 15.95 81.20 56.000 63.80 135-50040-026-000 Unemployment Taxes 210.00 210.00 1.10 64.40 30.667 145.60 135-50045-026-000 Workman's Compensation 150.00 150.00 15.70 10.467 134.30 Subtotal: 11,125.00 11,125.00 1,185.25 6,108.50 54.908 5,016.50 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 42.00 2.000 2,058.00 135-60075-026-000 Meetings 1,200.00 1,200.00 162.00 434.97 36.248 765.03 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,335.00 2,260.00 56.500 1,740.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,831.60 2,341.88 46.838 2,658.12 135-60243-026-000 Prior Year Expense 107.10 107.10- 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 252.44 8.415 2,747.56 Subtotal: 15,450.00 15,450.00 3,328.60 5,438.39 35.200 10,011.61 Program number: 26,575.00 26,575.00 4,513.85 11,546.89 43.450 15,028.11 Department number: Board of Directors 26,575.00 26,575.00 4,513.85 11,546.89 43.450 15,028.11 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 444,730.00 444,730.00 33,141.85 240,792.66 54.144 203,937.34 135-50010-030-000 Overtime 1,500.00 1,500.00 27.09 200.83 13.389 1,299.17 135-50016-030-000 Longevity 2,193.00 2,318.00 2,317.50 99.978 .50 135-50020-030-000 Retirement 60,441.00 104,801.00 2,978.57 72,362.60 69.048 32,438.40 135-50026-030-000 Medical Insurance 44,066.00 49,049.00 4,388.10 27,108.30 55.268 21,940.70 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 386.34 2,411.52 71.368 967.48 135-50028-030-000 Vision Insurance 795.00 945.00 82.53 528.64 55.941 416.36 135-50029-030-000 Life Insurance & Other 2,500.00 2,582.00 173.08 1,723.09 66.735 858.91 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,911.85 14,497.47 52.145 13,304.53 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 447.12 3,390.54 52.146 3,111.46 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 3.02 954.41 62.096 582.59 135-50045-030-000 Workman's Compensation 831.00 831.00 698.52- 840.48 101.141 9.48- 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 102.49 2,724.17 54.483 2,275.83 Subtotal: 601,526.00 651,226.00 42,943.52 369,891.21 56.799 281,334.79 135-55030-030-000 Software & Support 63,555.00 63,555.00 8,588.53 26,473.29 41.654 37,081.71 135-55070-030-000 Independent Labor 2,700.00 7,700.00 411.25 598.75 7.776 7,101.25 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55080-030-000 Maintenance & Repairs 811.00 810.52 99.941 .48 135-55100-030-000 Building Maint & Supplies 5,000.00 6,500.00 255.80 3,497.52 53.808 3,002.48 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,678.51 12,197.25 60.382 8,002.75 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 149.00 6,974.00 46.493 8,026.00 135-55161-030-000 Outside Services-Town Semo 85,465.00 85,465.00 85,465.00 100.000 135-55165-030-000 Collection Fees 160.00 159.77 99.856 .23 135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 231.40 3,747.21 34.066 7,252.79 Subtotal: 203,420.00 210,891.00 11,314.49 139,923.31 66.349 70,967.69 135-60005-030-000 Telephone 9,000.00 10,500.00 1,069.75 5,598.26 53.317 4,901.74 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 326.95 1,954.90 54.683 1,620.10 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 1,245.13 6,992.94 53.713 6,026.06 135-60025-030-000 Water 3,100.00 3,100.00 46.01 497.28 16.041 2,602.72 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 2,848.50 7,689.57 58.334 5,492.43 135-60035-030-000 Postage 23,000.00 26,604.00 1,740.00 15,041.68 56.539 11,562.32 135-60040-030-000 Service Charges & Fees 18,000.00 28,330.00 2,047.03 16,212.04 57.226 12,117.96 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 85.44 1.005 8,414.56 135-60055-030-000 Insurance 35,000.00 50,694.00 50,693.77 100.000 .23 135-60066-030-000 Publications/Books/Subscripts 750.00 834.00 833.50 99.940 .50 135-60070-030-000 Dues & Memberships 2,400.00 3,892.00 3,891.95 99.999 .05 135-60075-030-000 Meetings 250.00 400.00 77.11 283.85 70.963 116.15 135-60080-030-000 Schools & Training 5,500.00 5,350.00 560.00 2,405.00 44.953 2,945.00 135-60100-030-000 Travel & per diem 3,950.00 3,616.00 1,243.54 2,062.82 57.047 1,553.18 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60110-030-000 Physicals/Testing 500.00 500.00 500.00 135-60125-030-000 Advertising 4,000.00 4,000.00 893.40 893.40 22.335 3,106.60 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60243-030-000 Prior Year Expense 1,263.00 1,263.01 100.001 .01- 135-60245-030-000 Miscellaneous Expenses 15,000.00 13,500.00 159.42 282.12 2.090 13,217.88 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60281-030-000 Park Expenses 42,500.00 4,234.44 28,552.40 67.182 13,947.60 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 832.40 3,157.40 126.296 657.40- Subtotal: 173,076.00 247,709.00 17,323.68 148,391.33 59.906 99,317.67 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,499.24 52.007 9,688.76 135-65085-030-000 Office Supplies 8,200.00 8,200.00 1,182.94 4,684.57 57.129 3,515.43 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 363.68 1,722.08 30.043 4,009.92 135-65095-030-000 Maintenance Supplies 2,000.00 1,500.00 1,105.84 2,169.17 144.611 669.17- 135-65097-030-000 Vending Machine Supplies 500.00 500.00 500.00 135-65105-030-000 Printing 5,200.00 4,200.00 395.00 9.405 3,805.00 Subtotal: 43,455.00 41,955.00 2,652.46 20,094.18 47.895 21,860.82 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 1,541.10 44.670 1,908.90 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,541.10 5.076 28,819.90 Program number: 1,051,838.00 1,182,142.00 74,234.15 679,841.13 57.509 502,300.87 Department number: Administration 1,051,838.00 1,182,142.00 74,234.15 679,841.13 57.509 502,300.87 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 16:15 05/08/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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 24,587.90 135,512.10 193.589 65,512.10- 135-55055-039-000 Auditing 21,200.00 21,200.00 20,700.00 97.642 500.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 6,209.06 41.120 8,890.94 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,356.39 62.010 1,443.61 Subtotal: 110,100.00 110,100.00 24,587.90 164,777.55 149.662 54,677.55- 135-60344-039-000 Intergov Trans Out (Fire CIP) 86,726.39 86,726.39- Subtotal: 86,726.39 86,726.39- Program number: 110,100.00 110,100.00 24,587.90 251,503.94 228.432 141,403.94- Department number: Non Departmental 110,100.00 110,100.00 24,587.90 251,503.94 228.432 141,403.94- Expenditures Subtotal ----------- 6,509,258.00 6,488,157.00 278,972.17 3,221,818.96 49.657 3,266,338.04 Fund number: 135 MUD 1 General Fund 109,066.05- 347,097.31 347,097.31- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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 1353 04/01/2013 Property Taxes/Assessments (98,933.33) (46.28) (98,979.61) GL 1355 04/02/2013 Property Taxes/Assessments (105.50) (99,085.11) GL 1356 04/05/2013 Property Taxes/Assessments (69.15) (99,154.26) GL 1357 04/08/2013 Property Taxes/Assessments (21.28) (99,175.54) GL 1359 04/11/2013 Property Taxes/Assessments 69.56 (99,105.98) GL 1358 04/16/2013 Property Taxes/Assessments (6.23) (99,112.21) GL 1360 04/17/2013 Property Taxes/Assessments 2.47 (99,109.74) GL 1361 04/18/2013 Property Taxes/Assessments (1.86) (99,111.60) GL 1362 04/19/2013 Property Taxes/Assessments (31.02) (99,142.62) GL 1363 04/23/2013 Property Taxes/Assessments (3.75) (99,146.37) GL 1364 04/24/2013 Property Taxes/Assessments (43.56) (99,189.93) GL 1394 04/25/2013 Property Taxes/Assessments (13.42) (99,203.35) GL 1395 04/29/2013 Property Taxes/Assessments (18.23) (99,221.58) GL 1396 04/30/2013 Property Taxes/Assessments (86.62) (99,308.20) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (374.87) (99,308.20) ** (99,884.00) Budgeted (575.80) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1356 04/05/2013 Property Taxes/Assessments (623.73) (.33) (624.06) GL 1394 04/25/2013 Property Taxes/Assessments 1,031.03 406.97 GL 1396 04/30/2013 Property Taxes/Assessments (24.98) 381.99 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 1,005.72 381.99 ** (624.00) Budgeted (1,005.99) Remaining -61 % Used Account: 135-40015-000-000 Property Taxes/P & I 1355 04/02/2013 Property Taxes/Assessments (657.80) (7.13) (664.93) GL 1425 04/05/2013 Property Taxes/Assessments (.41) (665.34) GL 1356 04/05/2013 Property Taxes/Assessments (5.33) (670.67) GL 1357 04/08/2013 Property Taxes/Assessments (2.35) (673.02) GL 1359 04/11/2013 Property Taxes/Assessments (1.10) (674.12) GL 1362 04/19/2013 Property Taxes/Assessments (3.45) (677.57) GL 1363 04/23/2013 Property Taxes/Assessments (.41) (677.98) GL 1364 04/24/2013 Property Taxes/Assessments (4.79) (682.77) GL 1395 04/29/2013 Property Taxes/Assessments (1.84) (684.61) GL 1396 04/30/2013 Property Taxes/Assessments (11.29) (695.90) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (38.10) (695.90) ** (1,200.00) Budgeted (504.10) Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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-47000-000-000 Water 1384 04/30/2013 UB 4/30/2013 Billing UB20130430-20130430 User: (1,264,905.61) (228,277.66) (1,493,183.27) UB _______________ Account: 135-47000-000-000 Water Totals: (228,277.66) (1,493,183.27) ** (3,545,609.00) Budgeted (2,052,425.73) Remaining 42 % Used Account: 135-47005-000-000 Sewer 1384 04/30/2013 UB 4/30/2013 Billing UB20130430-20130430 User: (798,372.11) (147,965.45) (946,337.56) UB _______________ Account: 135-47005-000-000 Sewer Totals: (147,965.45) (946,337.56) ** (1,653,747.00) Budgeted (707,409.44) Remaining 57 % 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 1323 04/23/2013 UB 4/23/13 Penalties UB20130423-20130423 User: (26,272.52) (2,861.12) (29,133.64) UB 1380 04/29/2013 UB 04/29/2013 Adjustments UB20130429-20130429 User: 91.11 (29,042.53) UB 1381 04/30/2013 UB 04/30/2013 Adjustments UB20130430-20130430 User: 13.80 (29,028.73) UB 1384 04/30/2013 UB 4/30/2013 Billing UB20130430-20130430 User: (406.42) (29,435.15) UB _______________ Account: 135-47025-000-000 Penalties Totals: (3,162.63) (29,435.15) ** (64,580.00) Budgeted (35,144.85) Remaining 46 % Used Account: 135-47030-000-000 Service Charges 1283 04/09/2013 UB 4/17/13 Disconnect Fees UB20130409-20130409 User: (6,319.94) (550.00) (6,869.94) UB 1284 04/09/2013 UB 4/9/13 After Hours Fee UB20130409-20130409 User: (300.00) (7,169.94) UB 1321 04/18/2013 UB 4/18/13 Adjustment UB20130418-20130418 User: (25.00) (7,194.94) UB 1405 04/24/2013 UB 4/24/13 Adjustment UB20130424-20130424 User: (25.00) (7,219.94) UB 1407 04/29/2013 UB 4/29/13 Adjustment UB20130429-20130429 User: (25.00) (7,244.94) UB 1384 04/30/2013 UB 4/30/2013 Billing UB20130430-20130430 User: (3.00) (7,247.94) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (928.00) (7,247.94) ** (11,625.00) Budgeted (4,377.06) Remaining 62 % Used Account: 135-47035-000-000 Plumbing Inspections . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1271 04/15/2013 April A/P Refund dupe permit/2002 Church (550.00) 50.00 (500.00) Taylor Fine Homes 32471 AP _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: 50.00 (500.00) ** (1,800.00) Budgeted (1,300.00) Remaining 28 % Used Account: 135-47045-000-000 Sewer Inspections 1271 04/15/2013 April A/P Refund dupe permit/2002 Church (2,100.00) 150.00 (1,950.00) Taylor Fine Homes 32471 AP _______________ Account: 135-47045-000-000 Sewer Inspections Totals: 150.00 (1,950.00) ** (5,200.00) Budgeted (3,250.00) Remaining 38 % 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-48005-000-000 Utility Fees (184,000.00) .00 (184,000.00) _______________ Account: 135-48005-000-000 Utility Fees Totals: .00 (184,000.00) ** (644,000.00) Budgeted (460,000.00) Remaining 29 % Used Account: 135-49010-000-000 Interest Income 1422 04/30/2013 Bank Interest/April (2,763.76) (47.63) (2,811.39) GL 1422 04/30/2013 Bank Interest/April (300.62) (3,112.01) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (348.25) (3,112.01) ** (5,500.00) Budgeted (2,387.99) Remaining 57 % Used Account: 135-49016-000-000 Cell Tower Revenue 1294 04/16/2013 AT&T Antenna Lease/April (5,399.65) (910.53) (6,310.18) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (6,310.18) ** (10,164.00) Budgeted (3,853.82) Remaining 62 % Used Account: 135-49018-000-000 Building Rent Income . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1297 04/18/2013 Recode Maint Barn Rent (2,333.32) (1,749.99) (4,083.31) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (1,749.99) (4,083.31) ** (7,000.00) Budgeted (2,916.69) Remaining 58 % Used Account: 135-49030-000-000 Vending Revenue 1293 04/05/2013 Coffee $ collected (36.34) (10.12) (46.46) GL 1367 04/30/2013 Coffee $ (1.85) (48.31) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (11.97) (48.31) ** (350.00) Budgeted (301.69) Remaining 14 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (234,014.00) Budgeted (234,014.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1271 04/15/2013 April A/P Refund dupe permit/2002 Church (30,860.69) 317.00 (30,543.69) Taylor Fine Homes 32471 AP _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: 317.00 (30,543.69) ** (73,000.00) Budgeted (42,456.31) Remaining 42 % Used Account: 135-49141-000-000 Interfund Trans In (Cap Proj) (38,101.42) .00 (38,101.42) _______________ Account: 135-49141-000-000 Interfund Trans In (Cap Proj) Totals: .00 (38,101.42) ** (38,101.00) Budgeted .42 Remaining 100 % Used Account: 135-49900-000-000 Miscellaneous Income 1291 04/05/2013 Lone Star Metals Recycling (9,212.64) (4,045.10) (13,257.74) GL 1304 04/19/2013 Town Billing Inv 1016-1020 AR 20130401-20130419 User: (77.00) (13,334.74) AR 1352 04/29/2013 Lone Star Metal Recycling (456.00) (13,790.74) GL 1386 04/30/2013 Lone Star Metals/Scrap metals (955.70) (14,746.44) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (5,533.80) (14,746.44) ** (13,213.00) Budgeted 1,533.44 Remaining 112 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49901-000-000 Records Management Revenue (109.00) .00 (109.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (109.00) ** (109.00) Budgeted .00 Remaining 100 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (2,117.50) .00 (2,117.50) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (2,117.50) ** .00 Budgeted 2,117.50 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue 1341 04/25/2013 Vantage Energy/Gas Well revenu (286.02) (102.00) (388.02) GL 1368 04/30/2013 Encana/Gas Well revenue (157.69) (545.71) GL _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: (259.69) (545.71) ** (286.00) Budgeted 259.71 Remaining 191 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,874,721.65) ** (6,488,157.00) Budgeted (3,613,435.35) Remaining 44 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1243 04/12/2013 Payroll 4/12/13 Salaries & Wages 80,722.46 6,715.52 87,437.98 PR 1312 04/26/2013 Payroll 4/26/13 Salaries & Wages 6,715.52 94,153.50 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 13,431.04 94,153.50 ** 213,321.00 Budgeted 119,167.50 Remaining 44 % Used Account: 135-50010-010-000 Overtime 1243 04/12/2013 Payroll 4/12/13 Overtime 7,597.90 464.50 8,062.40 PR 1312 04/26/2013 Payroll 4/26/13 Overtime 491.25 8,553.65 PR _______________ Account: 135-50010-010-000 Overtime Totals: 955.75 8,553.65 ** 19,250.00 Budgeted 10,696.35 Remaining 44 % 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 1312 04/26/2013 Payroll 4/26/13 Certification 2,250.00 375.00 2,625.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 375.00 2,625.00 ** 5,100.00 Budgeted 2,475.00 Remaining 51 % Used Account: 135-50020-010-000 Retirement 1243 04/12/2013 Payroll 4/12/13 Retirement 36,598.23 644.76 37,242.99 PR 1312 04/26/2013 Payroll 4/26/13 Retirement 680.85 37,923.84 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,325.61 37,923.84 ** 57,748.00 Budgeted 19,824.16 Remaining 66 % Used Account: 135-50026-010-000 Medical Insurance 1243 04/12/2013 Payroll 4/12/13 Medical Insurance 11,393.64 1,057.00 12,450.64 PR 1312 04/26/2013 Payroll 4/26/13 Medical Insurance 1,056.96 13,507.60 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,113.96 13,507.60 ** 28,920.00 Budgeted 15,412.40 Remaining 47 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1243 04/12/2013 Payroll 4/12/13 Dental Insurance 834.87 72.76 907.63 PR 1312 04/26/2013 Payroll 4/26/13 Dental Insurance 72.75 980.38 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 145.51 980.38 ** 2,091.00 Budgeted 1,110.62 Remaining 47 % Used Account: 135-50028-010-000 Vision Insurance 1243 04/12/2013 Payroll 4/12/13 Vision Insurance 196.89 16.96 213.85 PR 1312 04/26/2013 Payroll 4/26/13 Vision Insurance 16.95 230.80 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 33.91 230.80 ** 519.00 Budgeted 288.20 Remaining 44 % Used Account: 135-50029-010-000 Life Insurance & Other 1243 04/12/2013 Payroll 4/12/13 Life Insurance & Other 766.25 74.31 840.56 PR 1335 04/24/2013 April A/P May FSA Admin 15.75 856.31 Discovery Benefits 32495 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 90.06 856.31 ** 1,532.00 Budgeted 675.69 Remaining 56 % Used Account: 135-50030-010-000 Social Security Taxes 1243 04/12/2013 Payroll 4/12/13 Social Security Taxes 5,943.14 435.82 6,378.96 PR 1312 04/26/2013 Payroll 4/26/13 Social Security Taxes 459.23 6,838.19 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 895.05 6,838.19 ** 14,555.00 Budgeted 7,716.81 Remaining 47 % Used Account: 135-50035-010-000 Medicare Taxes 1243 04/12/2013 Payroll 4/12/13 Medicare Taxes 1,389.93 101.92 1,491.85 PR 1312 04/26/2013 Payroll 4/26/13 Medicare Taxes 107.40 1,599.25 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 209.32 1,599.25 ** 3,404.00 Budgeted 1,804.75 Remaining 47 % Used Account: 135-50040-010-000 Unemployment Taxes 1243 04/12/2013 Payroll 4/12/13 Unemployment Taxes 296.27 .89 297.16 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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: .89 297.16 ** 945.00 Budgeted 647.84 Remaining 31 % Used Account: 135-50045-010-000 Workman's Compensation 1295 04/17/2013 TML W/C Refund 1st fiscal qtr 11,444.00 (5,151.35) 6,292.65 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: (5,151.35) 6,292.65 ** 6,109.00 Budgeted (183.65) Remaining 103 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 63.00 .00 63.00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 63.00 ** 200.00 Budgeted 137.00 Remaining 32 % Used Account: 135-50070-010-000 Employee Relations 1244 04/10/2013 2/26-3/27 PCards SPLIT - 13550070010 (25%) 82.65 10.32 92.97 DONUT PARADISE PC 1409 04/30/2013 3/27/13-4/26/13 PCards SPLIT - 13550070010 (33.33%) 6.49 99.46 DONUT HAVEN PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 16.81 99.46 ** 350.00 Budgeted 250.54 Remaining 28 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1244 04/10/2013 2/26-3/27 PCards DEALERS ELECTRICAL #08 18,920.78 71.88 18,992.66 DEALERS ELECTRICAL #08 PC 1271 04/15/2013 April A/P Misc Brass water fittings 826.74 19,819.40 HD SUPPLY WATERWORKS, LTD. 32441 AP 1271 04/15/2013 April A/P Gate valve 245.13 20,064.53 HD SUPPLY WATERWORKS, LTD. 32441 AP 1271 04/15/2013 April A/P 3" brass nipples 60.70 20,125.23 HD SUPPLY WATERWORKS, LTD. 32441 AP 1271 04/15/2013 April A/P Gasket 26.40 20,151.63 HD SUPPLY WATERWORKS, LTD. 32441 AP 1271 04/15/2013 April A/P Flange 38.75 20,190.38 HD SUPPLY WATERWORKS, LTD. 32441 AP 1271 04/15/2013 April A/P Gasket 8.64 20,199.02 HD SUPPLY WATERWORKS, LTD. 32441 AP 1271 04/15/2013 April A/P meter boxes, flange, nipples 1,128.75 21,327.77 HD SUPPLY WATERWORKS, LTD. 32441 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1271 04/15/2013 April A/P Meter Testing @ Water plant an 18,920.78 1,215.00 22,542.77 A1A FLOW CHECK LLC 32409 AP 1328 04/24/2013 April A/P Gaskets 12.96 22,555.73 HD SUPPLY WATERWORKS, LTD. 32498 AP 1328 04/24/2013 April A/P Brass nipples 100.36 22,656.09 HD SUPPLY WATERWORKS, LTD. 32498 AP 1409 04/30/2013 3/27/13-4/26/13 PCards THE HOME DEPOT 6581 16.18 22,672.27 THE HOME DEPOT 6581 PC 1409 04/30/2013 3/27/13-4/26/13 PCards THE HOME DEPOT 6581 13.53 22,685.80 THE HOME DEPOT 6581 PC 1409 04/30/2013 3/27/13-4/26/13 PCards MILCOM SUPPLY INC 69.30 22,755.10 MILCOM SUPPLY INC PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 3,834.32 22,755.10 ** 50,000.00 Budgeted 27,244.90 Remaining 46 % Used Account: 135-55090-010-000 Vehicle Maintenance 1244 04/10/2013 2/26-3/27 PCards KWIK KAR OF ROANOKE 2,324.56 395.64 2,720.20 KWIK KAR OF ROANOKE PC 1244 04/10/2013 2/26-3/27 PCards KWIK KAR OF ROANOKE 14.50 2,734.70 KWIK KAR OF ROANOKE PC 1328 04/24/2013 April A/P Alternator, Oil 150.22 2,884.92 ROANOKE AUTO SUPPLY 32512 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 560.36 2,884.92 ** 4,650.00 Budgeted 1,765.08 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 1271 04/15/2013 April A/P TCEQ Water samples test 2,691.34 272.47 2,963.81 DEPT OF STATE HEALTH SVCS 32429 AP 1271 04/15/2013 April A/P March water analysis 385.00 3,348.81 TARRANT CTY PUBLIC HEALTH LAB 32473 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 657.47 3,348.81 ** 5,384.00 Budgeted 2,035.19 Remaining 62 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1271 04/15/2013 April A/P Verizon Invoice 9702057336 703.18 175.78 878.96 TOWN OF TROPHY CLUB 32479 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 175.78 878.96 ** 2,000.00 Budgeted 1,121.04 Remaining 44 % Used Account: 135-60020-010-000 Electricity . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1328 04/24/2013 April A/P Electricity 3/14-4/15 47,421.95 4,504.39 51,926.34 HUDSON ENERGY SERVICES, LLC 32499 AP 1328 04/24/2013 April A/P Electricity 3/13-4/12 81.95 52,008.29 HUDSON ENERGY SERVICES, LLC 32499 AP 1328 04/24/2013 April A/P Electricity 3/14-4/15 3,175.65 55,183.94 HUDSON ENERGY SERVICES, LLC 32499 AP _______________ Account: 135-60020-010-000 Electricity Totals: 7,761.99 55,183.94 ** 162,410.00 Budgeted 107,226.06 Remaining 34 % 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,472.00 Budgeted 1,121.00 Remaining 24 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 551.69 .00 551.69 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 551.69 ** 800.00 Budgeted 248.31 Remaining 69 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1271 04/15/2013 April A/P Cylinder rental 6.00 6.00 12.00 ALLIED WELDING SUPPLY, INC 32412 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 12.00 ** 500.00 Budgeted 488.00 Remaining 2 % 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 ** 42,743.00 Budgeted 2,218.25 Remaining 95 % Used Account: 135-60150-010-000 Wholesale Water 1271 04/15/2013 April A/P Feb Wholesale water 499,848.97 83,161.11 583,010.08 CITY OF FORT WORTH 32425 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 83,161.11 583,010.08 ** 2,028,447.00 Budgeted 1,445,436.92 Remaining 29 % Used Account: 135-60243-010-000 Prior Year Expense 756.00 .00 756.00 _______________ Account: 135-60243-010-000 Prior Year Expense Totals: .00 756.00 ** 756.00 Budgeted .00 Remaining 100 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 1271 04/15/2013 April A/P Superior Water sign 488.95 132.24 621.19 DALLAS LITE & BARRICADE, INC 32427 AP 1409 04/30/2013 3/27/13-4/26/13 PCards DENTON SAND & GRAVEL, 42.00 663.19 DENTON SAND & GRAVEL, PC 1409 04/30/2013 3/27/13-4/26/13 PCards DENTON SAND & GRAVEL, 108.00 771.19 DENTON SAND & GRAVEL, PC 1409 04/30/2013 3/27/13-4/26/13 PCards TEX-TURF 14.07 785.26 TEX-TURF PC 1409 04/30/2013 3/27/13-4/26/13 PCards TEX-TURF 48.28 833.54 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 344.59 833.54 ** 4,200.00 Budgeted 3,366.46 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 38.99 .00 38.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 38.99 ** 500.00 Budgeted 461.01 Remaining 8 % Used Account: 135-65005-010-000 Fuel & Lube 1315 04/01/2013 March Gas Log 4,726.98 1,824.44 6,551.42 GL 1409 04/30/2013 3/27/13-4/26/13 PCards DIAMOND 2618 SHAMROC 75.28 6,626.70 DIAMOND 2618 SHAMROC PC _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,899.72 6,626.70 ** 17,661.00 Budgeted 11,034.30 Remaining 38 % 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 1271 04/15/2013 April A/P Chlorine 2,221.92 208.18 2,430.10 DPC INDUSTRIES, INC 32431 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 208.18 2,430.10 ** 6,200.00 Budgeted 3,769.90 Remaining 39 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 256.82 .00 256.82 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 256.82 ** 1,000.00 Budgeted 743.18 Remaining 26 % Used Account: 135-65050-010-000 Meter Expense 1275 04/15/2013 April A/P 8 Model 70 Orion Heads 97,393.00 1,240.00 98,633.00 ATLAS UTILITY SUPPLY CO. 32488 AP 1275 04/15/2013 April A/P 4 Model 70 meters 600.00 99,233.00 ATLAS UTILITY SUPPLY CO. 32488 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 1,840.00 99,233.00 ** 143,550.00 Budgeted 44,317.00 Remaining 69 % Used Account: 135-65085-010-000 Office Supplies 109.68 .00 109.68 _______________ Account: 135-65085-010-000 Office Supplies Totals: .00 109.68 ** .00 Budgeted (109.68) Remaining 0 % Used Account: 135-69005-010-000 Capital Expenses 1269 04/15/2013 Reimb GF/$445k projects Security Cameras-3rd Eye 2,050.04 (3,145.00) (1,094.96) GL _______________ Account: 135-69005-010-000 Capital Expenses Totals: (3,145.00) (1,094.96) ** 8,000.00 Budgeted 9,094.96 Remaining -14 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 366,000.00 Budgeted 366,000.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest 10,376.98 .00 10,376.98 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 10,376.98 ** 21,037.00 Budgeted 10,660.02 Remaining 49 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 59,869.00 .00 59,869.00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 59,869.00 ** 60,000.00 Budgeted 131.00 Remaining 100 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 100,900.00 Budgeted 83.46 Remaining 100 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,170,656.48 ** 3,425,914.00 Budgeted 2,255,257.52 Remaining 34 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 1243 04/12/2013 Payroll 4/12/13 Salaries & Wages 91,563.47 6,034.07 97,597.54 PR 1312 04/26/2013 Payroll 4/26/13 Salaries & Wages 6,031.25 103,628.79 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 12,065.32 103,628.79 ** 196,781.00 Budgeted 93,152.21 Remaining 53 % Used Account: 135-50010-020-000 Overtime 1243 04/12/2013 Payroll 4/12/13 Overtime 7,273.77 416.51 7,690.28 PR 1312 04/26/2013 Payroll 4/26/13 Overtime 58.16 7,748.44 PR _______________ Account: 135-50010-020-000 Overtime Totals: 474.67 7,748.44 ** 17,546.00 Budgeted 9,797.56 Remaining 44 % 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 1312 04/26/2013 Payroll 4/26/13 Certification 2,100.00 300.00 2,400.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 300.00 2,400.00 ** 4,200.00 Budgeted 1,800.00 Remaining 57 % Used Account: 135-50020-020-000 Retirement 1243 04/12/2013 Payroll 4/12/13 Retirement 37,625.89 579.26 38,205.15 PR 1312 04/26/2013 Payroll 4/26/13 Retirement 573.77 38,778.92 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,153.03 38,778.92 ** 54,844.00 Budgeted 16,065.08 Remaining 71 % Used Account: 135-50026-020-000 Medical Insurance 1243 04/12/2013 Payroll 4/12/13 Medical Insurance 16,861.59 1,382.37 18,243.96 PR 1312 04/26/2013 Payroll 4/26/13 Medical Insurance 1,382.37 19,626.33 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,764.74 19,626.33 ** 29,034.00 Budgeted 9,407.67 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 1243 04/12/2013 Payroll 4/12/13 Dental Insurance 1,205.40 97.79 1,303.19 PR 1312 04/26/2013 Payroll 4/26/13 Dental Insurance 97.77 1,400.96 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 195.56 1,400.96 ** 2,112.00 Budgeted 711.04 Remaining 66 % Used Account: 135-50028-020-000 Vision Insurance 1243 04/12/2013 Payroll 4/12/13 Vision Insurance 309.96 20.59 330.55 PR 1312 04/26/2013 Payroll 4/26/13 Vision Insurance 20.56 351.11 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 41.15 351.11 ** 552.00 Budgeted 200.89 Remaining 64 % Used Account: 135-50029-020-000 Life Insurance & Other 1243 04/12/2013 Payroll 4/12/13 Life Insurance & Other 842.74 64.17 906.91 PR 1335 04/24/2013 April A/P May FSA Admin 21.00 927.91 Discovery Benefits 32495 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 85.17 927.91 ** 1,377.00 Budgeted 449.09 Remaining 67 % Used Account: 135-50030-020-000 Social Security Taxes 1243 04/12/2013 Payroll 4/12/13 Social Security Taxes 5,787.48 338.97 6,126.45 PR 1312 04/26/2013 Payroll 4/26/13 Social Security Taxes 331.74 6,458.19 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 670.71 6,458.19 ** 13,268.00 Budgeted 6,809.81 Remaining 49 % Used Account: 135-50035-020-000 Medicare Taxes 1243 04/12/2013 Payroll 4/12/13 Medicare Taxes 1,353.50 79.29 1,432.79 PR 1312 04/26/2013 Payroll 4/26/13 Medicare Taxes 77.58 1,510.37 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 156.87 1,510.37 ** 3,103.00 Budgeted 1,592.63 Remaining 49 % Used Account: 135-50040-020-000 Unemployment Taxes 309.05 .00 309.05 . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 309.05 ** 756.00 Budgeted 446.95 Remaining 41 % Used Account: 135-50045-020-000 Workman's Compensation 1295 04/17/2013 TML W/C Refund 1st fiscal qtr 7,853.00 (2,443.73) 5,409.27 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: (2,443.73) 5,409.27 ** 2,939.00 Budgeted (2,470.27) Remaining 184 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 126.00 .00 126.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 126.00 ** 150.00 Budgeted 24.00 Remaining 84 % Used Account: 135-50070-020-000 Employee Relations 1244 04/10/2013 2/26-3/27 PCards SPLIT - 13550070020 (25%) 62.37 10.32 72.69 DONUT PARADISE PC 1409 04/30/2013 3/27/13-4/26/13 PCards SPLIT - 13550070020 (33.33%) 6.49 79.18 DONUT HAVEN PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 16.81 79.18 ** 350.00 Budgeted 270.82 Remaining 23 % Used Account: 135-55070-020-000 Independent Labor 1271 04/15/2013 April A/P WWTP Study 45,933.00 20,067.00 66,000.00 THE WALLACE GROUP, INC. 32477 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 20,067.00 66,000.00 ** 84,418.00 Budgeted 18,418.00 Remaining 78 % Used Account: 135-55080-020-000 Maintenance & Repairs 1244 04/10/2013 2/26-3/27 PCards FOX RENTAL 35,704.13 6.95 35,711.08 FOX RENTAL PC 1244 04/10/2013 2/26-3/27 PCards THE HOME DEPOT 6581 31.07 35,742.15 THE HOME DEPOT 6581 PC 1244 04/10/2013 2/26-3/27 PCards THE HOME DEPOT 6581 60.70 35,802.85 THE HOME DEPOT 6581 PC 1244 04/10/2013 2/26-3/27 PCards THREE L WELDING SUPPLY 77.45 35,880.30 THREE L WELDING SUPPLY PC 1244 04/10/2013 2/26-3/27 PCards WW GRAINGER 7.78 35,888.08 WW GRAINGER PC 1244 04/10/2013 2/26-3/27 PCards THE HOME DEPOT 6581 211.63 36,099.71 THE HOME DEPOT 6581 PC 1244 04/10/2013 2/26-3/27 PCards FERGUSON ENT #788 1,524.67 37,624.38 FERGUSON ENT #788 PC 1271 04/15/2013 April A/P install switch on scum pump 508.00 38,132.38 XYLEM WATER SOLUTIONS USA INC 32487 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1271 04/15/2013 April A/P Torsion Spring, Steering Valve 35,704.13 44.00 38,176.38 ASHBROOK SIMON-HARTLEY 32413 AP 1328 04/24/2013 April A/P Digester Blower Motor 1,977.74 40,154.12 HD SUPPLY FACILITIES MAINT LTD 32497 AP 1409 04/30/2013 3/27/13-4/26/13 PCards THE HOME DEPOT 6581 13.94 40,168.06 THE HOME DEPOT 6581 PC 1409 04/30/2013 3/27/13-4/26/13 PCards THE HOME DEPOT 6581 17.02 40,185.08 THE HOME DEPOT 6581 PC 1409 04/30/2013 3/27/13-4/26/13 PCards THE HOME DEPOT 6581 7.97 40,193.05 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 4,488.92 40,193.05 ** 41,205.00 Budgeted 1,011.95 Remaining 98 % Used Account: 135-55090-020-000 Vehicle Maintenance 1409 04/30/2013 3/27/13-4/26/13 PCards ROANOKE AUTO SUPPLY LT 3,348.64 14.49 3,363.13 ROANOKE AUTO SUPPLY LT PC 1409 04/30/2013 3/27/13-4/26/13 PCards BLAGG TIRE SERVICE 270.00 3,633.13 BLAGG TIRE SERVICE PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 284.49 3,633.13 ** 3,350.00 Budgeted (283.13) Remaining 108 % 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 1271 04/15/2013 April A/P Sludge haul off 21,536.94 937.26 22,474.20 L.H. CHANEY MATERIALS, INC. 32445 AP 1328 04/24/2013 April A/P Sludge Haul off 3,774.17 26,248.37 L.H. CHANEY MATERIALS, INC. 32502 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,711.43 26,248.37 ** 49,611.00 Budgeted 23,362.63 Remaining 53 % Used Account: 135-55135-020-000 Lab Analysis 1244 04/10/2013 2/26-3/27 PCards OXIDOR LABORATORIES LL 12,884.50 102.90 12,987.40 OXIDOR LABORATORIES LL PC 1271 04/15/2013 April A/P Wet chem analysis 1,703.25 14,690.65 TALEM, INC 32472 AP 1271 04/15/2013 April A/P Ammonia, Carbonaceous BOD, Tot 176.00 14,866.65 OXIDOR LABORATORIES LLC 32464 AP 1271 04/15/2013 April A/P Carbonaceous BOD, Nitrate-N, P 210.00 15,076.65 OXIDOR LABORATORIES LLC 32464 AP 1271 04/15/2013 April A/P Ammonia, Carbonaceous BOD, Tot 176.00 15,252.65 OXIDOR LABORATORIES LLC 32464 AP 1328 04/24/2013 April A/P Ammonia-N, Carbonaceous BOD, T 176.00 15,428.65 OXIDOR LABORATORIES LLC 32509 AP 1328 04/24/2013 April A/P Copper, Ammonia-N, Carbonaceou 243.00 15,671.65 OXIDOR LABORATORIES LLC 32509 AP 1328 04/24/2013 April A/P Ammonia-N, Carbonaceous BOD, T 176.00 15,847.65 OXIDOR LABORATORIES LLC 32509 AP 1328 04/24/2013 April A/P Credit Memo from 1st invoice (20.00) 15,827.65 OXIDOR LABORATORIES LLC 32509 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,943.15 15,827.65 ** 30,000.00 Budgeted 14,172.35 Remaining 53 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1271 04/15/2013 April A/P Verizon Invoice 9702057336 1,008.54 231.09 1,239.63 TOWN OF TROPHY CLUB 32479 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 231.09 1,239.63 ** 3,981.00 Budgeted 2,741.37 Remaining 31 % Used Account: 135-60020-020-000 Electricity 1328 04/24/2013 April A/P Electricity 3/14-4/15 64,017.33 10,515.20 74,532.53 HUDSON ENERGY SERVICES, LLC 32499 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,515.20 74,532.53 ** 153,045.00 Budgeted 78,512.47 Remaining 49 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 161.45 .00 161.45 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 161.45 ** 200.00 Budgeted 38.55 Remaining 81 % Used Account: 135-60080-020-000 Schools & Training 1244 04/10/2013 2/26-3/27 PCards TCEQ EPAYMENT 660.66 111.00 771.66 TCEQ EPAYMENT PC 1244 04/10/2013 2/26-3/27 PCards NCTCOG PBLCTNS & SRVCS 300.00 1,071.66 NCTCOG PBLCTNS & SRVCS PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 411.00 1,071.66 ** 3,272.00 Budgeted 2,200.34 Remaining 33 % Used Account: 135-60100-020-000 Travel & per diem 1409 04/30/2013 3/27/13-4/26/13 PCards FISH TALES 816.27 36.77 853.04 FISH TALES PC 1409 04/30/2013 3/27/13-4/26/13 PCards IHOP 1447 12.00 865.04 IHOP 1447 PC 1409 04/30/2013 3/27/13-4/26/13 PCards SONIC DRIVE IN #4239 9.37 874.41 SONIC DRIVE IN #4239 PC 1409 04/30/2013 3/27/13-4/26/13 PCards SONIC DRIVE IN #4239 11.00 885.41 SONIC DRIVE IN #4239 PC 1409 04/30/2013 3/27/13-4/26/13 PCards FISH TALES 18.00 903.41 FISH TALES PC 1409 04/30/2013 3/27/13-4/26/13 PCards SCHLOTZSKY'S 1554 14.16 917.57 SCHLOTZSKY'S 1554 PC 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 420.90 1,338.47 AMERICAN AIRLINES PC 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 482.90 1,821.37 AMERICAN AIRLINES PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1409 04/30/2013 3/27/13-4/26/13 PCards SPLIT - 13560100021 (50%) 816.27 449.72 2,271.09 TRAVRES*HOTELSONE.COM PC 1409 04/30/2013 3/27/13-4/26/13 PCards TRAVRES*HOTELSONE.COM (112.43) 2,158.66 TRAVRES*HOTELSONE.COM PC 1409 04/30/2013 3/27/13-4/26/13 PCards BRICKHOUSE-GALVESTON 18.00 2,176.66 BRICKHOUSE-GALVESTON PC 1409 04/30/2013 3/27/13-4/26/13 PCards CHEESECAKE FACTORY #16 26.00 2,202.66 CHEESECAKE FACTORY #16 PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 1,386.39 2,202.66 ** 1,400.00 Budgeted (802.66) Remaining 157 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1244 04/10/2013 2/26-3/27 PCards FOX RENTAL 1,020.00 103.00 1,123.00 FOX RENTAL PC _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 103.00 1,123.00 ** 1,500.00 Budgeted 377.00 Remaining 75 % Used Account: 135-60125-020-000 Advertising 112.50 .00 112.50 _______________ Account: 135-60125-020-000 Advertising Totals: .00 112.50 ** 300.00 Budgeted 187.50 Remaining 38 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 7,887.19 .00 7,887.19 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 7,887.19 ** 15,600.00 Budgeted 7,712.81 Remaining 51 % Used Account: 135-60136-020-000 TCEQ Environmental Proj (SEP) .00 .00 _______________ Account: 135-60136-020-000 TCEQ Environmental Proj (SEP) Totals: .00 .00 ** 40,400.00 Budgeted 40,400.00 Remaining 0 % Used Account: 135-60243-020-000 Prior Year Expense 801.59 .00 801.59 _______________ Account: 135-60243-020-000 Prior Year Expense Totals: .00 801.59 ** 802.00 Budgeted .41 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-020-000 Miscellaneous Expenses 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 1244 04/10/2013 2/26-3/27 PCards AUTOZONE #4206 345.15 67.08 412.23 AUTOZONE #4206 PC _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 67.08 412.23 ** 500.00 Budgeted 87.77 Remaining 82 % Used Account: 135-65005-020-000 Fuel & Lube 1315 04/01/2013 March Gas Log 5,220.70 1,707.19 6,927.89 GL 1409 04/30/2013 3/27/13-4/26/13 PCards EXXONMOBIL 47306360 78.00 7,005.89 EXXONMOBIL 47306360 PC 1409 04/30/2013 3/27/13-4/26/13 PCards SHELL OIL 542160000QPS 55.06 7,060.95 SHELL OIL 542160000QPS PC _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,840.25 7,060.95 ** 10,527.00 Budgeted 3,466.05 Remaining 67 % Used Account: 135-65010-020-000 Uniforms 773.70 .00 773.70 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 773.70 ** 1,574.00 Budgeted 800.30 Remaining 49 % Used Account: 135-65030-020-000 Chemicals 1271 04/15/2013 April A/P Calc Hypochlorite 18,345.52 1,685.38 20,030.90 HARCROS CHEMICALS INC 32439 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 1,685.38 20,030.90 ** 38,346.00 Budgeted 18,315.10 Remaining 52 % Used Account: 135-65035-020-000 Small Tools 333.47 .00 333.47 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 333.47 ** 1,000.00 Budgeted 666.53 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65040-020-000 Safety Equipment 1271 04/15/2013 April A/P Refill safety cabinet 452.14 65.82 517.96 CINTAS FAS LOCKBOX 636525 32423 AP 1409 04/30/2013 3/27/13-4/26/13 PCards CINTAS FAS 487 (34.70) 483.26 CINTAS FAS 487 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 31.12 483.26 ** 500.00 Budgeted 16.74 Remaining 97 % Used Account: 135-65045-020-000 Lab Supplies 1271 04/15/2013 April A/P Stoppers 7,591.71 47.75 7,639.46 HACH COMPANY 32438 AP 1271 04/15/2013 April A/P Lab supplies 616.09 8,255.55 HACH COMPANY 32438 AP 1271 04/15/2013 April A/P Sensor Cap replacement 420.00 8,675.55 HACH COMPANY 32438 AP 1328 04/24/2013 April A/P Distilled Water 20.94 8,696.49 OZARKA DIRECT 32510 AP 1328 04/24/2013 April A/P Gamma Irad Colilert-18 2,285.16 10,981.65 IDEXX DISTRIBUTION, INC 32500 AP 1328 04/24/2013 April A/P Coliform/E. Coli 155.29 11,136.94 IDEXX DISTRIBUTION, INC 32500 AP 1409 04/30/2013 3/27/13-4/26/13 PCards MIDWEST MEDICAL SUPPLY 62.53 11,199.47 MIDWEST MEDICAL SUPPLY PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 3,607.76 11,199.47 ** 10,000.00 Budgeted (1,199.47) Remaining 112 % Used Account: 135-69005-020-000 Capital Expenses 1269 04/15/2013 Reimb GF/$445k projects Security Cameras-3rd Eye 446,484.29 (4,289.00) 442,195.29 GL _______________ Account: 135-69005-020-000 Capital Expenses Totals: (4,289.00) 442,195.29 ** 446,484.00 Budgeted 4,288.71 Remaining 99 % Used Account: 135-69280-020-000 Capital Repairs 1269 04/15/2013 Reimb GF/$445k projects Xylem-Waste Pump 27,960.70 (24,920.70) 3,040.00 GL 1269 04/15/2013 Reimb GF/$445k projects Control Specialists-Waste Pump (3,040.00) .00 GL _______________ Account: 135-69280-020-000 Capital Repairs Totals: (27,960.70) .00 ** .00 Budgeted .00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 916,364.76 ** 1,269,585.00 Budgeted 353,220.24 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/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 1243 04/12/2013 Payroll 4/12/13 Salaries & Wages 71,338.65 5,891.37 77,230.02 PR 1312 04/26/2013 Payroll 4/26/13 Salaries & Wages 5,891.37 83,121.39 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,782.74 83,121.39 ** 156,475.00 Budgeted 73,353.61 Remaining 53 % Used Account: 135-50010-021-000 Overtime 1243 04/12/2013 Payroll 4/12/13 Overtime 5,081.20 120.25 5,201.45 PR 1312 04/26/2013 Payroll 4/26/13 Overtime 520.99 5,722.44 PR _______________ Account: 135-50010-021-000 Overtime Totals: 641.24 5,722.44 ** 12,158.00 Budgeted 6,435.56 Remaining 47 % 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 1312 04/26/2013 Payroll 4/26/13 Certification 850.00 150.00 1,000.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,000.00 ** 1,800.00 Budgeted 800.00 Remaining 56 % Used Account: 135-50020-021-000 Retirement 1243 04/12/2013 Payroll 4/12/13 Retirement 29,291.75 539.84 29,831.59 PR 1312 04/26/2013 Payroll 4/26/13 Retirement 589.29 30,420.88 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,129.13 30,420.88 ** 42,910.00 Budgeted 12,489.12 Remaining 71 % Used Account: 135-50026-021-000 Medical Insurance 1243 04/12/2013 Payroll 4/12/13 Medical Insurance 12,013.89 1,160.78 13,174.67 PR 1312 04/26/2013 Payroll 4/26/13 Medical Insurance 1,160.77 14,335.44 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,321.55 14,335.44 ** 25,940.00 Budgeted 11,604.56 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/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 1243 04/12/2013 Payroll 4/12/13 Dental Insurance 853.08 79.95 933.03 PR 1312 04/26/2013 Payroll 4/26/13 Dental Insurance 79.93 1,012.96 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 159.88 1,012.96 ** 1,812.00 Budgeted 799.04 Remaining 56 % Used Account: 135-50028-021-000 Vision Insurance 1243 04/12/2013 Payroll 4/12/13 Vision Insurance 186.92 16.31 203.23 PR 1312 04/26/2013 Payroll 4/26/13 Vision Insurance 16.29 219.52 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 32.60 219.52 ** 383.00 Budgeted 163.48 Remaining 57 % Used Account: 135-50029-021-000 Life Insurance & Other 1243 04/12/2013 Payroll 4/12/13 Life Insurance & Other 610.33 59.53 669.86 PR 1335 04/24/2013 April A/P May FSA Admin 5.25 675.11 Discovery Benefits 32495 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 64.78 675.11 ** 1,223.00 Budgeted 547.89 Remaining 55 % Used Account: 135-50030-021-000 Social Security Taxes 1243 04/12/2013 Payroll 4/12/13 Social Security Taxes 4,867.73 340.12 5,207.85 PR 1312 04/26/2013 Payroll 4/26/13 Social Security Taxes 372.15 5,580.00 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 712.27 5,580.00 ** 10,502.00 Budgeted 4,922.00 Remaining 53 % Used Account: 135-50035-021-000 Medicare Taxes 1243 04/12/2013 Payroll 4/12/13 Medicare Taxes 1,138.40 79.55 1,217.95 PR 1312 04/26/2013 Payroll 4/26/13 Medicare Taxes 87.03 1,304.98 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 166.58 1,304.98 ** 2,456.00 Budgeted 1,151.02 Remaining 53 % Used Account: 135-50040-021-000 Unemployment Taxes 1243 04/12/2013 Payroll 4/12/13 Unemployment Taxes 241.12 .15 241.27 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/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: .15 241.27 ** 567.00 Budgeted 325.73 Remaining 43 % Used Account: 135-50045-021-000 Workman's Compensation 1295 04/17/2013 TML W/C Refund 1st fiscal qtr 7,139.00 (2,794.12) 4,344.88 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: (2,794.12) 4,344.88 ** 3,348.00 Budgeted (996.88) Remaining 130 % Used Account: 135-50070-021-000 Employee Relations 1244 04/10/2013 2/26-3/27 PCards DONUT HAVEN 59.69 19.46 79.15 DONUT HAVEN PC 1244 04/10/2013 2/26-3/27 PCards SPLIT - 13550070030 (25%) 10.32 89.47 DONUT PARADISE PC 1409 04/30/2013 3/27/13-4/26/13 PCards SPLIT - 13550070021 (33.34%) 6.48 95.95 DONUT HAVEN PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 36.26 95.95 ** 250.00 Budgeted 154.05 Remaining 38 % Used Account: 135-55080-021-000 Maintenance & Repairs 1244 04/10/2013 2/26-3/27 PCards FERGUSON ENTERPRISES 1 6,721.45 153.74 6,875.19 FERGUSON ENTERPRISES 1 PC 1328 04/24/2013 April A/P Alternator, Oil 22.99 6,898.18 ROANOKE AUTO SUPPLY 32512 AP 1335 04/24/2013 April A/P Sewer repair/303 Hill Ln 7,124.00 14,022.18 CPS CIVIL, LLC 32494 AP 1409 04/30/2013 3/27/13-4/26/13 PCards WW GRAINGER 687.00 14,709.18 WW GRAINGER PC 1409 04/30/2013 3/27/13-4/26/13 PCards WW GRAINGER 220.50 14,929.68 WW GRAINGER PC 1409 04/30/2013 3/27/13-4/26/13 PCards ALL BATT CENTER -7127 16.50 14,946.18 ALL BATT CENTER -7127 PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 8,224.73 14,946.18 ** 20,000.00 Budgeted 5,053.82 Remaining 75 % Used Account: 135-55090-021-000 Vehicle Maintenance 1271 04/15/2013 April A/P Bulb, Oil 310.23 47.97 358.20 ROANOKE AUTO BODY 32466 AP 1376 04/15/2013 Void A/P Ck 32466/wrong vendor Bulb, Oil (47.97) 310.23 ROANOKE AUTO BODY 32466 AP 1328 04/24/2013 April A/P 2002 Ford F250 Collection Pick 691.28 1,001.51 MICHAEL G. WATSON 32506 AP 1409 04/30/2013 3/27/13-4/26/13 PCards KWIK KAR OF ROANOKE 39.75 1,041.26 KWIK KAR OF ROANOKE PC _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 731.03 1,041.26 ** 1,600.00 Budgeted 558.74 Remaining 65 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1271 04/15/2013 April A/P Verizon Invoice 9702057336 1,145.53 216.98 1,362.51 TOWN OF TROPHY CLUB 32479 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 216.98 1,362.51 ** 3,500.00 Budgeted 2,137.49 Remaining 39 % Used Account: 135-60020-021-000 Electricity 1271 04/15/2013 April A/P Electricity 2/28-3/28 7,910.03 246.41 8,156.44 TRI COUNTY ELECTRIC 32481 AP 1271 04/15/2013 April A/P Electricity 2/28-3/28 144.94 8,301.38 TRI COUNTY ELECTRIC 32481 AP 1271 04/15/2013 April A/P Electricity 2/28-3/28 27.65 8,329.03 TRI COUNTY ELECTRIC 32481 AP 1271 04/15/2013 April A/P Electricity 2/12-3/14 642.60 8,971.63 HUDSON ENERGY SERVICES, LLC 32443 AP 1328 04/24/2013 April A/P Electricity 3/14-4/15 683.42 9,655.05 HUDSON ENERGY SERVICES, LLC 32499 AP 1328 04/24/2013 April A/P Electricity 3/14-4/15 716.08 10,371.13 HUDSON ENERGY SERVICES, LLC 32499 AP 1328 04/24/2013 April A/P Electricity 3/13-4/12 95.46 10,466.59 HUDSON ENERGY SERVICES, LLC 32499 AP _______________ Account: 135-60020-021-000 Electricity Totals: 2,556.56 10,466.59 ** 18,705.00 Budgeted 8,238.41 Remaining 56 % Used Account: 135-60070-021-000 Dues & Memberships 250.00 .00 250.00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 250.00 ** 250.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-021-000 Schools & Training 830.00 .00 830.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 830.00 ** 826.00 Budgeted (4.00) Remaining 100 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 295.33 420.90 716.23 AMERICAN AIRLINES PC 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 482.90 1,199.13 AMERICAN AIRLINES PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1409 04/30/2013 3/27/13-4/26/13 PCards SPLIT - 13560100020 (50%) 295.33 449.72 1,648.85 TRAVRES*HOTELSONE.COM PC 1409 04/30/2013 3/27/13-4/26/13 PCards TRAVRES*HOTELSONE.COM (112.43) 1,536.42 TRAVRES*HOTELSONE.COM PC 1409 04/30/2013 3/27/13-4/26/13 PCards SALTGRASS-GALVESTON 25.72 1,562.14 SALTGRASS-GALVESTON PC 1409 04/30/2013 3/27/13-4/26/13 PCards GOLDEN CORRAL 629 12.33 1,574.47 GOLDEN CORRAL 629 PC _______________ Account: 135-60100-021-000 Travel & per diem Totals: 1,279.14 1,574.47 ** 450.00 Budgeted (1,124.47) Remaining 350 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60243-021-000 Prior Year Expense 620.83 .00 620.83 _______________ Account: 135-60243-021-000 Prior Year Expense Totals: .00 620.83 ** 621.00 Budgeted .17 Remaining 100 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 1315 04/01/2013 March Gas Log 4,701.64 874.83 5,576.47 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 874.83 5,576.47 ** 12,117.00 Budgeted 6,540.53 Remaining 46 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65030-021-000 Chemicals 2,221.00 .00 2,221.00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 2,221.00 ** 7,500.00 Budgeted 5,279.00 Remaining 30 % Used Account: 135-65035-021-000 Small Tools 70.00 .00 70.00 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 70.00 ** 1,250.00 Budgeted 1,180.00 Remaining 6 % Used Account: 135-65040-021-000 Safety Equipment 120.00 .00 120.00 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .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: ------------------------------------------------------------------------------------------------ 191,905.76 ** 473,841.00 Budgeted 281,935.24 Remaining 41 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 1243 04/12/2013 Payroll 4/12/13 Salaries & Wages 4,500.00 400.00 4,900.00 PR 1312 04/26/2013 Payroll 4/26/13 Salaries & Wages 700.00 5,600.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,100.00 5,600.00 ** 10,000.00 Budgeted 4,400.00 Remaining 56 % Used Account: 135-50030-026-000 Social Security Taxes 1243 04/12/2013 Payroll 4/12/13 Social Security Taxes 279.00 24.80 303.80 PR 1312 04/26/2013 Payroll 4/26/13 Social Security Taxes 43.40 347.20 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 68.20 347.20 ** 620.00 Budgeted 272.80 Remaining 56 % Used Account: 135-50035-026-000 Medicare Taxes 1243 04/12/2013 Payroll 4/12/13 Medicare Taxes 65.25 5.80 71.05 PR 1312 04/26/2013 Payroll 4/26/13 Medicare Taxes 10.15 81.20 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 15.95 81.20 ** 145.00 Budgeted 63.80 Remaining 56 % Used Account: 135-50040-026-000 Unemployment Taxes 1243 04/12/2013 Payroll 4/12/13 Unemployment Taxes 63.30 .40 63.70 PR 1312 04/26/2013 Payroll 4/26/13 Unemployment Taxes .70 64.40 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.10 64.40 ** 210.00 Budgeted 145.60 Remaining 31 % 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 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships 42.00 .00 42.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 42.00 ** 2,100.00 Budgeted 2,058.00 Remaining 2 % Used Account: 135-60075-026-000 Meetings 1244 04/10/2013 2/26-3/27 PCards NORTH TEXAS COMMISSION 272.97 140.00 412.97 NORTH TEXAS COMMISSION PC 1409 04/30/2013 3/27/13-4/26/13 PCards NW METROPORT CHAMBER O 22.00 434.97 NW METROPORT CHAMBER O PC _______________ Account: 135-60075-026-000 Meetings Totals: 162.00 434.97 ** 1,200.00 Budgeted 765.03 Remaining 36 % Used Account: 135-60080-026-000 Schools & Training 1271 04/15/2013 April A/P AWBD Conf-Armstrong 925.00 345.00 1,270.00 AWBD 32419 AP 1271 04/15/2013 April A/P AWBD Conf-Sanders 345.00 1,615.00 AWBD 32419 AP 1328 04/24/2013 April A/P AWBD Conf-McKnight 395.00 2,010.00 AWBD 32491 AP 1409 04/30/2013 3/27/13-4/26/13 PCards NCTCOG PBLCTNS & SRVCS 250.00 2,260.00 NCTCOG PBLCTNS & SRVCS PC _______________ Account: 135-60080-026-000 Schools & Training Totals: 1,335.00 2,260.00 ** 4,000.00 Budgeted 1,740.00 Remaining 57 % Used Account: 135-60100-026-000 Travel & per diem 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 510.28 420.90 931.18 AMERICAN AIRLINES PC 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 482.90 1,414.08 AMERICAN AIRLINES PC 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 420.90 1,834.98 AMERICAN AIRLINES PC 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 24.00 1,858.98 AMERICAN AIRLINES PC 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 482.90 2,341.88 AMERICAN AIRLINES PC _______________ Account: 135-60100-026-000 Travel & per diem Totals: 1,831.60 2,341.88 ** 5,000.00 Budgeted 2,658.12 Remaining 47 % Used Account: 135-60243-026-000 Prior Year Expense 107.10 .00 107.10 _______________ Account: 135-60243-026-000 Prior Year Expense Totals: .00 107.10 ** .00 Budgeted (107.10) Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 252.44 .00 252.44 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 252.44 ** 3,000.00 Budgeted 2,747.56 Remaining 8 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 11,546.89 ** 26,575.00 Budgeted 15,028.11 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 1243 04/12/2013 Payroll 4/12/13 Salaries & Wages 207,650.81 16,576.96 224,227.77 PR 1312 04/26/2013 Payroll 4/26/13 Salaries & Wages 16,564.89 240,792.66 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,141.85 240,792.66 ** 444,730.00 Budgeted 203,937.34 Remaining 54 % Used Account: 135-50010-030-000 Overtime 1243 04/12/2013 Payroll 4/12/13 Overtime 173.74 6.67 180.41 PR 1312 04/26/2013 Payroll 4/26/13 Overtime 20.42 200.83 PR _______________ Account: 135-50010-030-000 Overtime Totals: 27.09 200.83 ** 1,500.00 Budgeted 1,299.17 Remaining 13 % Used Account: 135-50016-030-000 Longevity 2,317.50 .00 2,317.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 2,317.50 ** 2,318.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1243 04/12/2013 Payroll 4/12/13 Retirement 69,384.03 1,489.21 70,873.24 PR 1312 04/26/2013 Payroll 4/26/13 Retirement 1,489.36 72,362.60 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,978.57 72,362.60 ** 104,801.00 Budgeted 32,438.40 Remaining 69 % Used Account: 135-50026-030-000 Medical Insurance 1243 04/12/2013 Payroll 4/12/13 Medical Insurance 22,720.20 2,194.07 24,914.27 PR 1312 04/26/2013 Payroll 4/26/13 Medical Insurance 2,194.03 27,108.30 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 27,108.30 ** 49,049.00 Budgeted 21,940.70 Remaining 55 % Used Account: 135-50027-030-000 Dental Insurance 1243 04/12/2013 Payroll 4/12/13 Dental Insurance 2,025.18 193.19 2,218.37 PR 1312 04/26/2013 Payroll 4/26/13 Dental Insurance 193.15 2,411.52 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 2,411.52 ** 3,379.00 Budgeted 967.48 Remaining 71 % Used Account: 135-50028-030-000 Vision Insurance 1243 04/12/2013 Payroll 4/12/13 Vision Insurance 446.11 41.29 487.40 PR 1312 04/26/2013 Payroll 4/26/13 Vision Insurance 41.24 528.64 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 528.64 ** 945.00 Budgeted 416.36 Remaining 56 % Used Account: 135-50029-030-000 Life Insurance & Other 1243 04/12/2013 Payroll 4/12/13 Life Insurance & Other 1,550.01 136.33 1,686.34 PR 1335 04/24/2013 April A/P May FSA Admin 36.75 1,723.09 Discovery Benefits 32495 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 173.08 1,723.09 ** 2,582.00 Budgeted 858.91 Remaining 67 % Used Account: 135-50030-030-000 Social Security Taxes 1243 04/12/2013 Payroll 4/12/13 Social Security Taxes 12,585.62 958.13 13,543.75 PR 1312 04/26/2013 Payroll 4/26/13 Social Security Taxes 953.72 14,497.47 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,911.85 14,497.47 ** 27,802.00 Budgeted 13,304.53 Remaining 52 % Used Account: 135-50035-030-000 Medicare Taxes 1243 04/12/2013 Payroll 4/12/13 Medicare Taxes 2,943.42 224.07 3,167.49 PR 1312 04/26/2013 Payroll 4/26/13 Medicare Taxes 223.05 3,390.54 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 447.12 3,390.54 ** 6,502.00 Budgeted 3,111.46 Remaining 52 % Used Account: 135-50040-030-000 Unemployment Taxes 1243 04/12/2013 Payroll 4/12/13 Unemployment Taxes 951.39 2.82 954.21 PR 1312 04/26/2013 Payroll 4/26/13 Unemployment Taxes .20 954.41 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 3.02 954.41 ** 1,537.00 Budgeted 582.59 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 1295 04/17/2013 TML W/C Refund 1st fiscal qtr 1,539.00 (698.52) 840.48 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: (698.52) 840.48 ** 831.00 Budgeted (9.48) Remaining 101 % 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 1244 04/10/2013 2/26-3/27 PCards SPLIT - 13550070021 (25%) 2,621.68 10.31 2,631.99 DONUT PARADISE PC 1409 04/30/2013 3/27/13-4/26/13 PCards WAL-MART #5985 58.75 2,690.74 WAL-MART #5985 PC 1409 04/30/2013 3/27/13-4/26/13 PCards TOM THUMB STOR00017897 20.05 2,710.79 TOM THUMB STOR00017897 PC 1409 04/30/2013 3/27/13-4/26/13 PCards CENTRAL MARKET #055 13.38 2,724.17 CENTRAL MARKET #055 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 102.49 2,724.17 ** 5,000.00 Budgeted 2,275.83 Remaining 54 % Used Account: 135-55030-030-000 Software & Support 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 17,884.76 25.00 17,909.76 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 100.00 18,009.76 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 (26.52) 17,983.24 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 53.38 18,036.62 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 65.44 18,102.06 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P ISP Bandwidth 363.30 18,465.36 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P ISP charges 1,721.75 20,187.11 TOWN OF TROPHY CLUB 32479 AP 1328 04/24/2013 April A/P Monthly ISP charges 645.50 20,832.61 TOWN OF TROPHY CLUB 32514 AP 1328 04/24/2013 April A/P Attendance Enterprise Annual M 1,181.00 22,013.61 TOWN OF TROPHY CLUB 32514 AP 1328 04/24/2013 April A/P Legistar annual maint 4,459.68 26,473.29 TOWN OF TROPHY CLUB 32514 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 8,588.53 26,473.29 ** 63,555.00 Budgeted 37,081.71 Remaining 42 % Used Account: 135-55070-030-000 Independent Labor 1328 04/24/2013 April A/P Acclaim Network/Firewall Suppo 187.50 343.75 531.25 TOWN OF TROPHY CLUB 32514 AP 1328 04/24/2013 April A/P Record MUD Meeting 67.50 598.75 MIGUEL CRUZ 32507 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-55070-030-000 Independent Labor Totals: 411.25 598.75 ** 7,700.00 Budgeted 7,101.25 Remaining 8 % Used Account: 135-55075-030-000 Records Management .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 810.52 .00 810.52 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 810.52 ** 811.00 Budgeted .48 Remaining 100 % Used Account: 135-55100-030-000 Building Maint & Supplies 1271 04/15/2013 April A/P Pest Control 3,241.72 87.50 3,329.22 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P March Rug service 336.60 3,665.82 G & K SERVICES 32436 AP 1304 04/19/2013 Town Billing Inv 1016-1020 AR 20130401-20130419 User: (168.30) 3,497.52 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 255.80 3,497.52 ** 6,500.00 Budgeted 3,002.48 Remaining 54 % Used Account: 135-55120-030-000 Cleaning Services 1271 04/15/2013 April A/P April Janitorial service 10,518.74 1,678.51 12,197.25 ABM JANITORIAL SERVICES, INC 32410 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,678.51 12,197.25 ** 20,200.00 Budgeted 8,002.75 Remaining 60 % Used Account: 135-55160-030-000 Professional Outside Services 1244 04/10/2013 2/26-3/27 PCards MCKNIGHT REVIEW SETUP 6,825.00 149.00 6,974.00 ECHOSPANINC PC _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 149.00 6,974.00 ** 15,000.00 Budgeted 8,026.00 Remaining 46 % Used Account: 135-55161-030-000 Outside Services-Town Semo . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 85,465.00 .00 85,465.00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 85,465.00 ** 85,465.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees 159.77 .00 159.77 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 159.77 ** 160.00 Budgeted .23 Remaining 100 % Used Account: 135-55205-030-000 Utility Billing Contract 1271 04/15/2013 April A/P March UB printing of bills 3,515.81 561.40 4,077.21 DP2 BILLING SOLUTIONS, LLC 32430 AP 1271 04/15/2013 April A/P Credit memo (330.00) 3,747.21 DP2 BILLING SOLUTIONS, LLC 32430 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 231.40 3,747.21 ** 11,000.00 Budgeted 7,252.79 Remaining 34 % Used Account: 135-60005-030-000 Telephone 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 4,528.51 177.53 4,706.04 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 123.83 4,829.87 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 395.78 5,225.65 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 372.61 5,598.26 TOWN OF TROPHY CLUB 32479 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,069.75 5,598.26 ** 10,500.00 Budgeted 4,901.74 Remaining 53 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1271 04/15/2013 April A/P Verizon Invoice 9702057336 1,627.95 176.95 1,804.90 TOWN OF TROPHY CLUB 32479 AP 1312 04/26/2013 Payroll 4/26/13 Communications/Pagers/Mobiles 150.00 1,954.90 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 326.95 1,954.90 ** 3,575.00 Budgeted 1,620.10 Remaining 55 % Used Account: 135-60020-030-000 Electricity/Gas 1271 04/15/2013 April A/P Electricity 2/13-3/14 5,747.81 1,245.13 6,992.94 TOWN OF TROPHY CLUB 32479 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,245.13 6,992.94 ** 13,019.00 Budgeted 6,026.06 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-60025-030-000 Water 1271 04/15/2013 April A/P Water 451.27 92.02 543.29 TROPHY CLUB MUD (WATER BILLS) 32482 AP 1304 04/19/2013 Town Billing Inv 1016-1020 AR 20130401-20130419 User: (46.01) 497.28 AR _______________ Account: 135-60025-030-000 Water Totals: 46.01 497.28 ** 3,100.00 Budgeted 2,602.72 Remaining 16 % Used Account: 135-60030-030-000 Rent And/Or Usage 1271 04/15/2013 April A/P April PS Bldg rent 4,841.07 1,098.51 5,939.58 TOWN OF TROPHY CLUB 32479 AP 1297 04/18/2013 Recode Maint Barn Rent 1,749.99 7,689.57 GL _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 2,848.50 7,689.57 ** 13,182.00 Budgeted 5,492.43 Remaining 58 % Used Account: 135-60035-030-000 Postage 1292 04/05/2013 Postage sold 13,301.68 (3.05) 13,298.63 GL 1271 04/15/2013 April A/P March UB printing of bills 1,644.97 14,943.60 DP2 BILLING SOLUTIONS, LLC 32430 AP 1335 04/24/2013 April A/P Overnight letters 16.15 14,959.75 FEDERAL EXPRESS CORP 32496 AP 1342 04/25/2013 Postage (6.62) 14,953.13 GL 1409 04/30/2013 3/27/13-4/26/13 PCards USPS 48764506630613152 19.95 14,973.08 USPS 48764506630613152 PC 1409 04/30/2013 3/27/13-4/26/13 PCards FEDEXOFFICE 00019364 68.60 15,041.68 FEDEXOFFICE 00019364 PC _______________ Account: 135-60035-030-000 Postage Totals: 1,740.00 15,041.68 ** 26,604.00 Budgeted 11,562.32 Remaining 57 % Used Account: 135-60040-030-000 Service Charges & Fees 1250 04/02/2013 April A/P Remove prior month late fee 14,165.01 (29.01) 14,136.00 JPMORGAN CHASE BANK NA 32406 AP 1375 04/02/2013 Bank Charges CC Fees/March 1,697.59 15,833.59 GL 1375 04/02/2013 Bank Charges CC Fees/March 46.35 15,879.94 GL 1375 04/02/2013 Bank Charges Authorize.net fees/March 82.10 15,962.04 GL 1375 04/02/2013 Bank Charges Monthly Maintenance fee/March 250.00 16,212.04 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,047.03 16,212.04 ** 28,330.00 Budgeted 12,117.96 Remaining 57 % Used Account: 135-60050-030-000 Bad Debt Expense 85.44 .00 85.44 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 85.44 ** 8,500.00 Budgeted 8,414.56 Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60055-030-000 Insurance 50,693.77 .00 50,693.77 _______________ Account: 135-60055-030-000 Insurance Totals: .00 50,693.77 ** 50,694.00 Budgeted .23 Remaining 100 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 833.50 .00 833.50 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 833.50 ** 834.00 Budgeted .50 Remaining 100 % Used Account: 135-60070-030-000 Dues & Memberships 3,891.95 .00 3,891.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 3,891.95 ** 3,892.00 Budgeted .05 Remaining 100 % Used Account: 135-60075-030-000 Meetings 1244 04/10/2013 2/26-3/27 PCards JACK IN THE BOX #07QPS 206.74 7.11 213.85 JACK IN THE BOX #07QPS PC 1244 04/10/2013 2/26-3/27 PCards NORTH TEXAS COMMISSION 70.00 283.85 NORTH TEXAS COMMISSION PC _______________ Account: 135-60075-030-000 Meetings Totals: 77.11 283.85 ** 400.00 Budgeted 116.15 Remaining 71 % Used Account: 135-60080-030-000 Schools & Training 1244 04/10/2013 2/26-3/27 PCards NCTCOG PBLCTNS & SRVCS 1,845.00 140.00 1,985.00 NCTCOG PBLCTNS & SRVCS PC 1244 04/10/2013 2/26-3/27 PCards CPEDEPOT/ACCTING CIRCL 49.00 2,034.00 CPEDEPOT/ACCTING CIRCL PC 1409 04/30/2013 3/27/13-4/26/13 PCards NW METROPORT CHAMBER O 40.00 2,074.00 NW METROPORT CHAMBER O PC 1409 04/30/2013 3/27/13-4/26/13 PCards NW METROPORT CHAMBER O 40.00 2,114.00 NW METROPORT CHAMBER O PC 1409 04/30/2013 3/27/13-4/26/13 PCards NW METROPORT CHAMBER O 40.00 2,154.00 NW METROPORT CHAMBER O PC 1409 04/30/2013 3/27/13-4/26/13 PCards TSBPA IND LIC RENEW 251.00 2,405.00 TSBPA IND LIC RENEW PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 560.00 2,405.00 ** 5,350.00 Budgeted 2,945.00 Remaining 45 % Used Account: 135-60100-030-000 Travel & per diem 1271 04/15/2013 April A/P Mileage reimb-STW conf 819.28 29.38 848.66 NICOLE D'ANDRIA 32462 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1271 04/15/2013 April A/P Mileage reimb-STW Conf 819.28 44.07 892.73 Terri Sisk 32474 AP 1271 04/15/2013 April A/P Mileage reimb-STW conf 14.69 907.42 Marsha Schaefer 32459 AP 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 482.90 1,390.32 AMERICAN AIRLINES PC 1409 04/30/2013 3/27/13-4/26/13 PCards AMERICAN AIRLINES 420.90 1,811.22 AMERICAN AIRLINES PC 1409 04/30/2013 3/27/13-4/26/13 PCards SOUTHWEST AIRLINES 251.60 2,062.82 SOUTHWEST AIRLINES PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 1,243.54 2,062.82 ** 3,616.00 Budgeted 1,553.18 Remaining 57 % 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 1271 04/15/2013 April A/P Advertising/Answering service 305.88 305.88 STAR-TELEGRAM OPERATING LTD 32470 AP 1271 04/15/2013 April A/P Advertising/Janitorial service 305.88 611.76 STAR-TELEGRAM OPERATING LTD 32470 AP 1271 04/15/2013 April A/P RFP/Development Plan Review 281.64 893.40 STAR-TELEGRAM OPERATING LTD 32470 AP _______________ Account: 135-60125-030-000 Advertising Totals: 893.40 893.40 ** 4,000.00 Budgeted 3,106.60 Remaining 22 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60243-030-000 Prior Year Expense 1,263.01 .00 1,263.01 _______________ Account: 135-60243-030-000 Prior Year Expense Totals: .00 1,263.01 ** 1,263.00 Budgeted (.01) Remaining 100 % Used Account: 135-60245-030-000 Miscellaneous Expenses 1244 04/10/2013 2/26-3/27 PCards PARKING 122.70 1.25 123.95 CFW PARKING METER PC 1244 04/10/2013 2/26-3/27 PCards CULVER COMPANY INC 74.17 198.12 CULVER COMPANY INC PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1244 04/10/2013 2/26-3/27 PCards VCN*DENTONCOCTR 122.70 84.00 282.12 VCN*DENTONCOCTR PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 159.42 282.12 ** 13,500.00 Budgeted 13,217.88 Remaining 2 % 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 1271 04/15/2013 April A/P March Harmony Park expenses 24,317.96 4,234.44 28,552.40 TOWN OF TROPHY CLUB 32479 AP _______________ Account: 135-60281-030-000 Park Expenses Totals: 4,234.44 28,552.40 ** 42,500.00 Budgeted 13,947.60 Remaining 67 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1271 04/15/2013 April A/P 2,325.00 137.49 2,462.49 OFFICE DEPOT, INC 32463 AP 1271 04/15/2013 April A/P Laserjet 400 color Printer 694.91 3,157.40 SHI GOVERNMENT SOLUTIONS,INC 32468 AP _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 832.40 3,157.40 ** 2,500.00 Budgeted (657.40) Remaining 126 % 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 10,499.24 .00 10,499.24 _______________ Account: 135-65055-030-000 Hardware Totals: .00 10,499.24 ** 20,188.00 Budgeted 9,688.76 Remaining 52 % Used Account: 135-65085-030-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1244 04/10/2013 2/26-3/27 PCards MAILBOXES & MORE 3,501.63 306.00 3,807.63 MAILBOXES & MORE PC 1244 04/10/2013 2/26-3/27 PCards THE HOEFLER TYPE FOUND 297.00 4,104.63 THE HOEFLER TYPE FOUND PC 1271 04/15/2013 April A/P BOA Pcards 2/28-3/27 26.99 4,131.62 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P Office supplies 12.73 4,144.35 OFFICE DEPOT, INC 32463 AP 1271 04/15/2013 April A/P Office supplies 138.09 4,282.44 OFFICE DEPOT, INC 32463 AP 1271 04/15/2013 April A/P Wall calendar 13.42 4,295.86 OFFICE DEPOT, INC 32463 AP 1328 04/24/2013 April A/P Office supplies 63.97 4,359.83 OFFICE DEPOT, INC 32508 AP 1409 04/30/2013 3/27/13-4/26/13 PCards COSTCO.COM *ONLINE 324.74 4,684.57 COSTCO.COM *ONLINE PC _______________ Account: 135-65085-030-000 Office Supplies Totals: 1,182.94 4,684.57 ** 8,200.00 Budgeted 3,515.43 Remaining 57 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1271 04/15/2013 April A/P Shi Invoice GB00076744 1,358.40 296.00 1,654.40 TOWN OF TROPHY CLUB 32479 AP 1271 04/15/2013 April A/P Shi Invoice GB00077509 67.68 1,722.08 TOWN OF TROPHY CLUB 32479 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 363.68 1,722.08 ** 5,732.00 Budgeted 4,009.92 Remaining 30 % Used Account: 135-65095-030-000 Maintenance Supplies 1244 04/10/2013 2/26-3/27 PCards BED BATH & BEYOND #341 1,063.33 20.38 1,083.71 BED BATH & BEYOND #341 PC 1244 04/10/2013 2/26-3/27 PCards SAMSCLUB #4795 592.98 1,676.69 SAMSCLUB #4795 PC 1271 04/15/2013 April A/P Costco purchases 119.94 1,796.63 COSTCO WHOLESALE 32426 AP 1409 04/30/2013 3/27/13-4/26/13 PCards SAMS INTERNET 46.98 1,843.61 SAMS INTERNET PC 1409 04/30/2013 3/27/13-4/26/13 PCards GREAT COFFEES OF AMERI 78.04 1,921.65 GREAT COFFEES OF AMERI PC 1409 04/30/2013 3/27/13-4/26/13 PCards BED BATH & BEYOND #341 23.98 1,945.63 BED BATH & BEYOND #341 PC 1409 04/30/2013 3/27/13-4/26/13 PCards SPLIT - 13565095030 (80.04%) 223.54 2,169.17 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 1,105.84 2,169.17 ** 1,500.00 Budgeted (669.17) Remaining 145 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-65105-030-000 Printing 395.00 .00 395.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 Totals: .00 395.00 ** 4,200.00 Budgeted 3,805.00 Remaining 9 % Used Account: 135-69170-030-000 Copier Lease Installments 1,541.10 .00 1,541.10 _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: .00 1,541.10 ** 3,450.00 Budgeted 1,908.90 Remaining 45 % 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: ------------------------------------------------------------------------------------------------ 679,841.13 ** 1,182,142.00 Budgeted 502,300.87 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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 1271 04/15/2013 April A/P Bond Counsel-Revenue note 2013 110,924.20 7,792.56 118,716.76 MCCALL, PARKHURST & HORTON LLP 32460 AP 1271 04/15/2013 April A/P March legal 1,186.75 119,903.51 THE LISTON LAW FIRM, P.C. 32476 AP 1271 04/15/2013 April A/P Town agreement 3,520.00 123,423.51 FREEMAN & CORBETT 32435 AP 1328 04/24/2013 April A/P Mar Legal-General 3,284.49 126,708.00 WHITAKER CHALK SWINDLE 32515 AP 1328 04/24/2013 April A/P Mar Legal-Prime Construction/S 358.80 127,066.80 WHITAKER CHALK SWINDLE 32515 AP 1328 04/24/2013 April A/P Mar Legal-CCN 345.90 127,412.70 WHITAKER CHALK SWINDLE 32515 AP 1328 04/24/2013 April A/P Mar Legal 67.20 127,479.90 WHITAKER CHALK SWINDLE 32515 AP 1328 04/24/2013 April A/P Mar Legal 1,125.60 128,605.50 WHITAKER CHALK SWINDLE 32515 AP 1335 04/24/2013 April A/P Legal 6,906.60 135,512.10 BOOTH, AHRENS & WERKENTHIN PC 32493 AP _______________ Account: 135-55045-039-000 Legal Totals: 24,587.90 135,512.10 ** 70,000.00 Budgeted (65,512.10) Remaining 194 % Used Account: 135-55055-039-000 Auditing 20,700.00 .00 20,700.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 20,700.00 ** 21,200.00 Budgeted 500.00 Remaining 98 % Used Account: 135-55060-039-000 Appraisal 6,209.06 .00 6,209.06 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,209.06 ** 15,100.00 Budgeted 8,890.94 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 2,356.39 .00 2,356.39 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,356.39 ** 3,800.00 Budgeted 1,443.61 Remaining 62 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 86,726.39 .00 86,726.39 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 86,726.39 ** .00 Budgeted (86,726.39) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 39 Totals: ------------------------------------------------------------------------------------------------ 251,503.94 ** 110,100.00 Budgeted (141,403.94) Remaining 228 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 347,097.31 .00 Budgeted (347,097.31) Remaining 0 % Used . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49005-000-000 Loan Proceeds 445,000.00- 445,000.00- 445,000.00- 100.000 507-49010-000-000 Interest Income 100.00- 25.15- 25.15- 25.150 74.85- Subtotal: 445,100.00- 445,025.15- 445,025.15- 99.983 74.85- Program number: 445,100.00- 445,025.15- 445,025.15- 99.983 74.85- Department number: 445,100.00- 445,025.15- 445,025.15- 99.983 74.85- Revenues Subtotal ----------- 445,100.00- 445,025.15- 445,025.15- 99.983 74.85- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-000 Capital Repairs 2,663.28 2,663.28 2,663.28- Subtotal: 2,663.28 2,663.28 2,663.28- Program number: 2,663.28 2,663.28 2,663.28- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-010-001 Capital Expense 5,800.00 6,289.00 6,289.00 108.431 489.00- Subtotal: 5,800.00 6,289.00 6,289.00 108.431 489.00- Program number: 1 Security Cameras 5,800.00 6,289.00 6,289.00 108.431 489.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Upgrade Yard Piping-FW Meter Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs 165,000.00 165,000.00 Subtotal: 165,000.00 165,000.00 Program number: 2 Upgrade Yard Piping-FW Meter 165,000.00 165,000.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Repairs 210,000.00 3,800.00 3,800.00 1.810 206,200.00 Subtotal: 210,000.00 3,800.00 3,800.00 1.810 206,200.00 Program number: 3 Indian Creek Waterline 210,000.00 3,800.00 3,800.00 1.810 206,200.00 Department number: Water 380,800.00 12,752.28 12,752.28 3.349 368,047.72 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 38,101.42 38,101.42- Subtotal: 38,101.42 38,101.42- Program number: 38,101.42 38,101.42- . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 1 Security Cameras Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-001 Capital Expense 8,200.00 8,578.00 8,578.00 104.610 378.00- Subtotal: 8,200.00 8,578.00 8,578.00 104.610 378.00- Program number: 1 Security Cameras 8,200.00 8,578.00 8,578.00 104.610 378.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 4 Sludge Blanket Level Indicator Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-004 Capital Expense 18,000.00 18,000.00 Subtotal: 18,000.00 18,000.00 Program number: 4 Sludge Blanket Level Indicator 18,000.00 18,000.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 23 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 5 Portable Submersible Pump Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-005 Capital Expense 10,000.00 10,000.00 Subtotal: 10,000.00 10,000.00 Program number: 5 Portable Submersible Pump 10,000.00 10,000.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 24 16:15 05/08/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 6 Waste Pump Period Ending: 4/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-020-006 Capital Repairs 28,000.00 27,960.70 27,960.70 99.860 39.30 Subtotal: 28,000.00 27,960.70 27,960.70 99.860 39.30 Program number: 6 Waste Pump 28,000.00 27,960.70 27,960.70 99.860 39.30 Department number: Wastewater 64,200.00 36,538.70 74,640.12 116.262 10,440.12- Expenditures Subtotal ----------- 445,000.00 49,290.98 87,392.40 19.639 357,607.60 Fund number: 507 MUD 1 Capital Projects 100.00- 395,734.17- 357,632.75- ############### 357,532.75 . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49005-000-000 Loan Proceeds 1268 04/09/2013 Loan Proceeds-$445k CO (445,000.00) (445,000.00) GL _______________ Account: 507-49005-000-000 Loan Proceeds Totals: (445,000.00) (445,000.00) ** (445,000.00) Budgeted .00 Remaining 100 % Used Account: 507-49010-000-000 Interest Income 1422 04/30/2013 Bank Interest/April (25.15) (25.15) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (25.15) (25.15) ** (100.00) Budgeted (74.85) Remaining 25 % Used Department Totals: ------------------------------------------------------------------------------------------------ (445,025.15) ** (445,100.00) Budgeted (74.85) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-000 Capital Repairs 1328 04/24/2013 April A/P Indian Creek Waterline Replace 2,663.28 2,663.28 TEAGUE, NALL & PERKINS,INC 32513 AP _______________ Account: 507-69280-010-000 Capital Repairs Totals: 2,663.28 2,663.28 ** .00 Budgeted (2,663.28) Remaining 0 % Used Account: 507-69005-010-001 Capital Expense 1269 04/15/2013 Reimb GF/$445k projects Security Cameras/3rd Eye 3,145.00 3,145.00 GL 1271 04/15/2013 April A/P Balance due Security Cameras 3,144.00 6,289.00 3RD EYE SURVEILLANCE SYSTEMS 32408 AP _______________ Account: 507-69005-010-001 Capital Expense Totals: 6,289.00 6,289.00 ** 5,800.00 Budgeted (489.00) Remaining 108 % Used Account: 507-69280-010-002 Capital Repairs .00 .00 _______________ Account: 507-69280-010-002 Capital Repairs Totals: .00 .00 ** 165,000.00 Budgeted 165,000.00 Remaining 0 % Used Account: 507-69280-010-003 Capital Repairs 1271 04/15/2013 April A/P Indian Crk Drive Waterline rep 3,800.00 3,800.00 TEAGUE, NALL & PERKINS,INC 32475 AP _______________ Account: 507-69280-010-003 Capital Repairs Totals: 3,800.00 3,800.00 ** 210,000.00 Budgeted 206,200.00 Remaining 2 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 12,752.28 ** 380,800.00 Budgeted 368,047.72 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 4/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 38,101.42 .00 38,101.42 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 38,101.42 ** .00 Budgeted (38,101.42) Remaining 0 % Used Account: 507-69005-020-001 Capital Expense 1269 04/15/2013 Reimb GF/$445k projects Security Cameras/3rd Eye 4,289.00 4,289.00 GL 1271 04/15/2013 April A/P Balance due Security Cameras 4,289.00 8,578.00 3RD EYE SURVEILLANCE SYSTEMS 32408 AP _______________ Account: 507-69005-020-001 Capital Expense Totals: 8,578.00 8,578.00 ** 8,200.00 Budgeted (378.00) Remaining 105 % Used Account: 507-69005-020-004 Capital Expense .00 .00 _______________ Account: 507-69005-020-004 Capital Expense Totals: .00 .00 ** 18,000.00 Budgeted 18,000.00 Remaining 0 % Used Account: 507-69005-020-005 Capital Expense .00 .00 _______________ Account: 507-69005-020-005 Capital Expense Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 507-69280-020-006 Capital Repairs 1269 04/15/2013 Reimb GF/$445k projects Xylem-Waste Pump 24,920.70 24,920.70 GL 1269 04/15/2013 Reimb GF/$445k projects Control Specialists-Waste Pump 3,040.00 27,960.70 GL _______________ Account: 507-69280-020-006 Capital Repairs Totals: 27,960.70 27,960.70 ** 28,000.00 Budgeted 39.30 Remaining 100 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 74,640.12 ** 64,200.00 Budgeted (10,440.12) Remaining 116 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ (357,632.75) (100.00) Budgeted 357,532.75 Remaining ########## TROPHY CLUB MUD #1 - I&S BALANCE SHEET APRIL 30, 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 523,878 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 14,776 UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 543,500 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 14,776 ACCOUNTS AND OTHER PAYABLES - CUSTOMER DEPOSITS - TOTAL LIABILITIES 14,776 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - UNASSIGNED FUND BALANCE 136,417 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 392,307 TOTAL FUND BALANCE 528,724 TOTAL LIABILITIES AND FUND BALANCE 543,500 . glbase_tbam rgonzale Trophy Club MUD #1 Page 25 16:15 05/08/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/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- 739.08- 195,804.76- 99.424 1,135.24- 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 142.96- 2,507.61- 64.298 1,392.39- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 91.05- 1,302.51- 25.962 3,714.49- Subtotal: 205,857.00- 205,857.00- 973.09- 199,614.88- 96.968 6,242.12- 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- 43.97- 208.25- 12.250 1,491.75- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 100.000 Subtotal: 309,700.00- 309,700.00- 43.97- 308,208.25- 99.518 1,491.75- Program number: 860,557.00- 860,557.00- 1,017.06- 507,823.13- 59.011 352,733.87- Department number: Revenues 860,557.00- 860,557.00- 1,017.06- 507,823.13- 59.011 352,733.87- Revenues Subtotal ----------- 860,557.00- 860,557.00- 1,017.06- 507,823.13- 59.011 352,733.87- . glbase_tbam rgonzale Trophy Club MUD #1 Page 26 16:15 05/08/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/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 25.000 3,000.00 533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 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 13.784 722,516.75 Program number: 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Department number: Administration 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Expenditures Subtotal ----------- 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Fund number: 533 MUD 1 I&S Consolidated 22,524.00- 22,524.00- 1,017.06- 392,306.88- 1,741.728 369,782.88 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/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 1353 04/01/2013 Property Taxes/Assessments (195,065.68) (91.23) (195,156.91) GL 1355 04/02/2013 Property Taxes/Assessments (207.99) (195,364.90) GL 1356 04/05/2013 Property Taxes/Assessments (136.34) (195,501.24) GL 1357 04/08/2013 Property Taxes/Assessments (41.97) (195,543.21) GL 1359 04/11/2013 Property Taxes/Assessments 137.14 (195,406.07) GL 1358 04/16/2013 Property Taxes/Assessments (12.28) (195,418.35) GL 1360 04/17/2013 Property Taxes/Assessments 4.87 (195,413.48) GL 1361 04/18/2013 Property Taxes/Assessments (3.66) (195,417.14) GL 1362 04/19/2013 Property Taxes/Assessments (61.15) (195,478.29) GL 1363 04/23/2013 Property Taxes/Assessments (7.40) (195,485.69) GL 1364 04/24/2013 Property Taxes/Assessments (85.89) (195,571.58) GL 1394 04/25/2013 Property Taxes/Assessments (26.46) (195,598.04) GL 1395 04/29/2013 Property Taxes/Assessments (35.95) (195,633.99) GL 1396 04/30/2013 Property Taxes/Assessments (170.77) (195,804.76) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (739.08) (195,804.76) ** (196,940.00) Budgeted (1,135.24) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1356 04/05/2013 Property Taxes/Assessments (2,364.65) (1.89) (2,366.54) GL 1396 04/30/2013 Property Taxes/Assessments (141.07) (2,507.61) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (142.96) (2,507.61) ** (3,900.00) Budgeted (1,392.39) Remaining 64 % Used Account: 533-40015-000-000 Property Taxes/P & I 1355 04/02/2013 Property Taxes/Assessments (1,211.46) (14.08) (1,225.54) GL 1356 04/05/2013 Property Taxes/Assessments (10.77) (1,236.31) GL 1357 04/08/2013 Property Taxes/Assessments (4.62) (1,240.93) GL 1359 04/11/2013 Property Taxes/Assessments (2.17) (1,243.10) GL 1362 04/19/2013 Property Taxes/Assessments (6.79) (1,249.89) GL 1363 04/23/2013 Property Taxes/Assessments (.81) (1,250.70) GL 1364 04/24/2013 Property Taxes/Assessments (9.43) (1,260.13) GL 1395 04/29/2013 Property Taxes/Assessments (3.63) (1,263.76) GL 1396 04/30/2013 Property Taxes/Assessments (38.75) (1,302.51) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (91.05) (1,302.51) ** (5,017.00) Budgeted (3,714.49) Remaining 26 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/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: 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 1422 04/30/2013 Bank Interest/April (164.28) (43.97) (208.25) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (43.97) (208.25) ** (1,700.00) Budgeted (1,491.75) Remaining 12 % Used Account: 533-49015-000-000 Lease/Rental Income (308,000.00) .00 (308,000.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (507,823.13) ** (860,557.00) Budgeted (352,733.87) Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 16:15 05/08/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/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 1,000.00 .00 1,000.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,000.00 ** 4,000.00 Budgeted 3,000.00 Remaining 25 % Used Account: 533-70025-051-000 Bond Interest Expense 114,516.25 .00 114,516.25 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 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: ------------------------------------------------------------------------------------------------------ (392,306.88) (22,524.00) Budgeted 369,782.88 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (952,288.08) **** (22,624.00) Budgeted 929,664.08 Remaining ########## ******* End of Report *********