Loading...
HomeMy WebLinkAboutApril Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET APRIL 2014 122 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 1,074,546 PREPAID EXPENSES 8,360 ADVALOREM PROPERTY TAXES RECEIVABLE 29,800 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 10,710 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,742 TOTAL ASSETS 1,125,158 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 40,509 ACCOUNTS AND OTHER PAYABLES 27,633 TOTAL LIABILITIES 68,142 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE 2,141 UNASSIGNED FUND BALANCE 493,547 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 561,328 TOTAL FUND BALANCE 1,057,016 TOTAL LIABILITIES AND FUND BALANCE 1,125,158 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 15:13 05/12/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 305,445.00- 305,445.00- 2,338.68- 307,492.86- 100.670 2,047.86 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1,580.56- 1,581.21- 1,581.21 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 4,656.36- 910,185.41- 98.127 17,369.59- 122-40011-000-000 Property Taxes/Fire-Delinquent 480.59- 1,206.14- 1,206.14 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 320.46- 545.40- 72.720 204.60- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 778.03- 4,320.79- 96.018 179.21- Subtotal: 1,238,250.00- 1,238,250.00- 10,154.68- 1,225,331.81- 98.957 12,918.19- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 3,200.00- 53.333 2,800.00- Subtotal: 6,000.00- 6,000.00- 400.00- 3,200.00- 53.333 2,800.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 75.00- 600.00- 85.714 100.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,700.00- 10,700.00- 75.00- 600.00- 5.607 10,100.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 525.00- 5,000.00- 83.333 1,000.00- Subtotal: 6,000.00- 6,000.00- 525.00- 5,000.00- 83.333 1,000.00- Program number: 1,260,950.00- 1,260,950.00- 11,154.68- 1,234,131.81- 97.873 26,818.19- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 11,154.68- 1,234,131.81- 97.873 26,818.19- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 11,154.68- 1,234,131.81- 97.873 26,818.19- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 15:13 05/12/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 455,916.00 455,916.00 35,784.00 256,559.08 56.273 199,356.92 122-50010-045-000 Overtime 44,225.00 44,225.00 3,612.40 20,460.13 46.264 23,764.87 122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,289.86 98.232 239.14 122-50016-045-000 Longevity 4,768.00 4,768.00 4,655.00 97.630 113.00 122-50017-045-000 Certification 4,350.00 4,350.00 375.00 2,589.39 59.526 1,760.61 122-50020-045-000 Retirement 70,991.00 70,991.00 5,752.02 42,044.99 59.226 28,946.01 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,316.43 28,825.68 50.600 28,142.32 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 352.84 2,350.48 55.567 1,879.52 122-50028-045-000 Vision Insurance 892.00 892.00 69.48 485.28 54.404 406.72 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 326.56 2,195.97 51.670 2,054.03 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 2,253.83 17,076.38 51.778 15,903.62 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 526.94 3,992.61 51.765 3,720.39 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 31.94 1,567.92 69.408 691.08 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.78 4,639.52 53.279 4,068.48 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 205.72 41.144 294.28 122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 54,064.22 400,938.01 56.242 311,940.99 122-55030-045-000 Software & Support 8,682.00 6,834.00 462.50- 6,834.00 122-55045-045-000 Legal 5,000.00 3,391.00 2,505.51- -73.887 5,896.51 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 1,843.14 11,176.01 54.592 9,295.99 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 1,875.38 4,794.81 32.288 10,055.19 Subtotal: 49,004.00 45,547.00 3,256.02 13,465.31 29.564 32,081.69 122-60005-045-000 Telephone 100.00 100.00 3.34 3.340 96.66 122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 214.52 1,602.79 37.828 2,634.21 122-60020-045-000 Electricity/Gas 6,568.00 9,268.00 458.57 4,138.60 44.655 5,129.40 122-60025-045-000 Water 1,500.00 1,500.00 90.49 497.51 33.167 1,002.49 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 100.000 122-60035-045-000 Postage 100.00 100.00 6.20 36.09 36.090 63.91 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 7,106.75 58.685 5,003.25 122-60066-045-000 Publications/Books/Subscrips 400.00 400.00 112.75 28.188 287.25 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 214.00 8,411.64 55.413 6,768.36 122-60080-045-000 Schools & Training 4,280.00 4,280.00 300.00 2,570.00 60.047 1,710.00 122-60096-045-000 Emergency Management 2,000.00 2,000.00 1,525.41 76.271 474.59 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 1,812.01 39.589 2,764.99 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 200.00 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 339.08 680.25 15.117 3,819.75 122-60180-045-000 Fire Inspection/Enforcement 1,500.00 1,500.00 40.00 190.00 12.667 1,310.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 117.87 950.62 47.531 1,049.38 122-60243-045-000 Prior Year Expense 3,457.00 3,456.54 99.987 .46 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 15:13 05/12/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 359.97 35.997 640.03 Subtotal: 276,531.00 282,488.00 2,789.98 247,733.27 87.697 34,754.73 122-65005-045-000 Fuel & Lube 11,698.00 10,198.00 863.72 4,780.61 46.878 5,417.39 122-65010-045-000 Uniforms 3,360.00 3,360.00 216.36 1,602.51 47.694 1,757.49 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 365.00 2,016.87 26.538 5,583.13 122-65030-045-000 Chemicals 1,000.00 500.00 500.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 173.65 518.38 20.735 1,981.62 122-65085-045-000 Office Supplies 1,000.00 500.00 72.00 233.22 46.644 266.78 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 24,758.00 1,690.73 9,151.59 36.964 15,606.41 122-69008-045-000 Short Term Debt-Principal 70,000.00 70,000.00 70,000.00 122-69009-045-000 Short Term Debt-Interest 3,031.00 3,031.00 1,515.50 50.000 1,515.50 122-69050-045-000 Radios 34,200.00 34,200.00 34,200.00 122-69195-045-000 GASB34/Reserve for Replacement 67,647.00 67,647.00 67,647.00 122-69255-045-000 Airpacks 20,400.00 20,400.00 20,400.00 Subtotal: 195,278.00 195,278.00 1,515.50 .776 193,762.50 Program number: 1,260,950.00 1,260,950.00 61,800.95 672,803.68 53.357 588,146.32 Department number: Fire 1,260,950.00 1,260,950.00 61,800.95 672,803.68 53.357 588,146.32 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 61,800.95 672,803.68 53.357 588,146.32 Fund number: 122 Trophy Club MUD Fire Dept. 50,646.27 561,328.13- 561,328.13 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2014 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 1222 04/01/2014 Property Taxes/Assessments (305,154.18) (183.67) (305,337.85) GL 1226 04/03/2014 Property Taxes / Assessments (477.47) (305,815.32) GL 1227 04/04/2014 Property Taxes/Assessments (257.41) (306,072.73) GL 1237 04/11/2014 Property Taxes/Assessments (304.87) (306,377.60) GL 1239 04/15/2014 Property Taxes/Assessments (33.64) (306,411.24) GL 1240 04/16/2014 Property Taxes/Assessments (1,081.62) (307,492.86) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (2,338.68) (307,492.86) ** (305,445.00) Budgeted 2,047.86 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1291 04/30/2014 Property Taxes/Assessments (.65) (1,580.56) (1,581.21) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (1,580.56) (1,581.21) ** .00 Budgeted 1,581.21 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1222 04/01/2014 Property Taxes/Assessments (905,529.05) (503.46) (906,032.51) GL 1225 04/02/2014 Property Taxes/Assessments (220.06) (906,252.57) GL 1226 04/03/2014 Property Taxes / Assessments (351.17) (906,603.74) GL 1227 04/04/2014 Property Taxes/Assessments (536.63) (907,140.37) GL 1234 04/07/2014 Property Taxes/Assessments (52.53) (907,192.90) GL 1235 04/08/2014 Property Taxes/Assessments (42.46) (907,235.36) GL 1236 04/09/2014 Property Taxes/Assessments (98.69) (907,334.05) GL 1237 04/11/2014 Property Taxes/Assessments (215.53) (907,549.58) GL 1238 04/14/2014 Property Taxes/Assessments 16.07 (907,533.51) GL 1239 04/15/2014 Property Taxes/Assessments 9.84 (907,523.67) GL 1240 04/16/2014 Property Taxes/Assessments (61.73) (907,585.40) GL 1241 04/21/2014 Property Taxes/Assessments (195.78) (907,781.18) GL 1242 04/22/2014 Property Taxes/Assessments (26.57) (907,807.75) GL 1243 04/23/2014 Property Taxes/Assessments (776.81) (908,584.56) GL 1288 04/28/2014 Property Taxes/Assessments (40.66) (908,625.22) GL 1290 04/29/2014 Property Taxes/Assessments (648.84) (909,274.06) GL 1291 04/30/2014 Property Taxes/Assessments (911.35) (910,185.41) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (4,656.36) (910,185.41) ** (927,555.00) Budgeted (17,369.59) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1226 04/03/2014 Property Taxes / Assessments (725.55) (405.29) (1,130.84) GL 1290 04/29/2014 Property Taxes/Assessments (72.30) (1,203.14) GL 1291 04/30/2014 Property Taxes/Assessments (3.00) (1,206.14) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (480.59) (1,206.14) ** .00 Budgeted 1,206.14 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1222 04/01/2014 Property Taxes/Assessments (224.94) (16.54) (241.48) GL 1226 04/03/2014 Property Taxes / Assessments (42.97) (284.45) GL 1227 04/04/2014 Property Taxes/Assessments (23.17) (307.62) GL 1237 04/11/2014 Property Taxes/Assessments (33.54) (341.16) GL 1239 04/15/2014 Property Taxes/Assessments (3.70) (344.86) GL 1240 04/16/2014 Property Taxes/Assessments (200.54) (545.40) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (320.46) (545.40) ** (750.00) Budgeted (204.60) Remaining 73 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1222 04/01/2014 Property Taxes/Assessments (3,542.76) (28.87) (3,571.63) GL 1225 04/02/2014 Property Taxes/Assessments (19.81) (3,591.44) GL 1226 04/03/2014 Property Taxes / Assessments (291.44) (3,882.88) GL 1227 04/04/2014 Property Taxes/Assessments (48.30) (3,931.18) GL 1234 04/07/2014 Property Taxes/Assessments (1.52) (3,932.70) GL 1236 04/09/2014 Property Taxes/Assessments (83.06) (4,015.76) GL 1237 04/11/2014 Property Taxes/Assessments (24.10) (4,039.86) GL 1238 04/14/2014 Property Taxes/Assessments (.63) (4,040.49) GL 1239 04/15/2014 Property Taxes/Assessments (1.48) (4,041.97) GL 1240 04/16/2014 Property Taxes/Assessments (6.79) (4,048.76) GL 1241 04/21/2014 Property Taxes/Assessments (21.54) (4,070.30) GL 1242 04/22/2014 Property Taxes/Assessments (2.92) (4,073.22) GL 1243 04/23/2014 Property Taxes/Assessments (85.45) (4,158.67) GL 1288 04/28/2014 Property Taxes/Assessments 24.82 (4,133.85) GL 1290 04/29/2014 Property Taxes/Assessments (90.88) (4,224.73) GL 1291 04/30/2014 Property Taxes/Assessments (96.06) (4,320.79) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (778.03) (4,320.79) ** (4,500.00) Budgeted (179.21) Remaining 96 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (2,800.00) (400.00) (3,200.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (3,200.00) ** (6,000.00) Budgeted (2,800.00) Remaining 53 % Used Account: 122-43400-000-000 Fire Inspections 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (525.00) (75.00) (600.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (600.00) ** (700.00) Budgeted (100.00) Remaining 86 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (4,475.00) (525.00) (5,000.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (525.00) (5,000.00) ** (6,000.00) Budgeted (1,000.00) Remaining 83 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,234,131.81) ** (1,260,950.00) Budgeted (26,818.19) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 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 1210 04/11/2014 FD Payroll 4/11/14 220,775.08 18,253.85 239,028.93 GL 1212 04/11/2014 FD Supplemental P/R 4/11/14 124.80 239,153.73 GL 1301 04/25/2014 FD Payroll 4/25/14 17,405.35 256,559.08 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 35,784.00 256,559.08 ** 455,916.00 Budgeted 199,356.92 Remaining 56 % Used Account: 122-50010-045-000 Overtime 1210 04/11/2014 FD Payroll 4/11/14 16,847.73 3,612.40 20,460.13 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,612.40 20,460.13 ** 44,225.00 Budgeted 23,764.87 Remaining 46 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,289.86 .00 13,289.86 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,289.86 ** 13,529.00 Budgeted 239.14 Remaining 98 % Used Account: 122-50016-045-000 Longevity 4,655.00 .00 4,655.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,655.00 ** 4,768.00 Budgeted 113.00 Remaining 98 % Used Account: 122-50017-045-000 Certification 1210 04/11/2014 FD Payroll 4/11/14 2,214.39 375.00 2,589.39 GL _______________ Account: 122-50017-045-000 Certification Totals: 375.00 2,589.39 ** 4,350.00 Budgeted 1,760.61 Remaining 60 % Used Account: 122-50020-045-000 Retirement 1210 04/11/2014 FD Payroll 4/11/14 36,292.97 3,196.16 39,489.13 GL 1212 04/11/2014 FD Supplemental P/R 4/11/14 18.36 39,507.49 GL 1301 04/25/2014 FD Payroll 4/25/14 2,537.50 42,044.99 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,752.02 42,044.99 ** 70,991.00 Budgeted 28,946.01 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 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 1210 04/11/2014 FD Payroll 4/11/14 24,509.25 2,488.46 26,997.71 GL 1301 04/25/2014 FD Payroll 4/25/14 1,827.97 28,825.68 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,316.43 28,825.68 ** 56,968.00 Budgeted 28,142.32 Remaining 51 % Used Account: 122-50027-045-000 Dental Insurance 1210 04/11/2014 FD Payroll 4/11/14 1,997.64 176.41 2,174.05 GL 1301 04/25/2014 FD Payroll 4/25/14 176.43 2,350.48 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 352.84 2,350.48 ** 4,230.00 Budgeted 1,879.52 Remaining 56 % Used Account: 122-50028-045-000 Vision Insurance 1210 04/11/2014 FD Payroll 4/11/14 415.80 34.70 450.50 GL 1301 04/25/2014 FD Payroll 4/25/14 34.78 485.28 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 69.48 485.28 ** 892.00 Budgeted 406.72 Remaining 54 % Used Account: 122-50029-045-000 Life Insurance & Other 1210 04/11/2014 FD Payroll 4/11/14 1,869.41 163.24 2,032.65 GL 1301 04/25/2014 FD Payroll 4/25/14 163.32 2,195.97 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 326.56 2,195.97 ** 4,250.00 Budgeted 2,054.03 Remaining 52 % Used Account: 122-50030-045-000 Social Security Taxes 1210 04/11/2014 FD Payroll 4/11/14 14,822.55 1,272.93 16,095.48 GL 1212 04/11/2014 FD Supplemental P/R 4/11/14 7.74 16,103.22 GL 1301 04/25/2014 FD Payroll 4/25/14 973.16 17,076.38 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,253.83 17,076.38 ** 32,980.00 Budgeted 15,903.62 Remaining 52 % Used Account: 122-50035-045-000 Medicare Taxes 1210 04/11/2014 FD Payroll 4/11/14 3,465.67 297.59 3,763.26 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1212 04/11/2014 FD Supplemental P/R 4/11/14 3,465.67 1.81 3,765.07 GL 1301 04/25/2014 FD Payroll 4/25/14 227.54 3,992.61 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 526.94 3,992.61 ** 7,713.00 Budgeted 3,720.39 Remaining 52 % Used Account: 122-50040-045-000 Unemployment Taxes 1210 04/11/2014 FD Payroll 4/11/14 1,535.98 28.38 1,564.36 GL 1301 04/25/2014 FD Payroll 4/25/14 3.56 1,567.92 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 31.94 1,567.92 ** 2,259.00 Budgeted 691.08 Remaining 69 % Used Account: 122-50045-045-000 Workman's Compensation 122 04/01/2014 FD Apr W/C expense 3,976.74 662.78 4,639.52 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.78 4,639.52 ** 8,708.00 Budgeted 4,068.48 Remaining 53 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 205.72 .00 205.72 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 205.72 ** 500.00 Budgeted 294.28 Remaining 41 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 1203 04/22/2014 April A/P AE Annual Maint, Charter 462.50 462.50 925.00 TOWN OF TROPHY CLUB 33691 AP 1347 04/30/2014 Recode FD Mar/Apr Cable (925.00) .00 GL _______________ Account: 122-55030-045-000 Software & Support Totals: (462.50) .00 ** 6,834.00 Budgeted 6,834.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55045-045-000 Legal (2,505.51) .00 (2,505.51) _______________ Account: 122-55045-045-000 Legal Totals: .00 (2,505.51) ** 3,391.00 Budgeted 5,896.51 Remaining -74 % Used Account: 122-55080-045-000 Maintenance & Repairs 1231 04/09/2014 April Firefighter Cable reimb 9,332.87 (133.82) 9,199.05 GL 1312 04/28/2014 3/27/14-4/28/14 PCards THE HOME DEPOT 6581 43.03 9,242.08 THE HOME DEPOT 6581 PC 1312 04/28/2014 3/27/14-4/28/14 PCards THE HOME DEPOT 6581 41.29 9,283.37 THE HOME DEPOT 6581 PC 1312 04/28/2014 3/27/14-4/28/14 PCards SAMSCLUB #4911 225.13 9,508.50 SAMSCLUB #4911 PC 1312 04/28/2014 3/27/14-4/28/14 PCards ATT*BILL PAYMENT 128.82 9,637.32 ATT*BILL PAYMENT PC 1312 04/28/2014 3/27/14-4/28/14 PCards ATT*BILL PAYMENT 157.97 9,795.29 ATT*BILL PAYMENT PC 1312 04/28/2014 3/27/14-4/28/14 PCards FASTSIGNS 68.78 9,864.07 FASTSIGNS PC 1312 04/28/2014 3/27/14-4/28/14 PCards MOTOROLA, INC. - ONLIN 76.50 9,940.57 MOTOROLA, INC. - ONLIN PC 1312 04/28/2014 3/27/14-4/28/14 PCards SAMSCLUB #4795 34.98 9,975.55 SAMSCLUB #4795 PC 1312 04/28/2014 3/27/14-4/28/14 PCards MOTOROLA, INC. - ONLIN 250.95 10,226.50 MOTOROLA, INC. - ONLIN PC 1228 04/29/2014 April A/P Rug Service/Fire Station 24.51 10,251.01 G & K SERVICES 33698 AP 1228 04/29/2014 April A/P Rug Service/Fire Station 24.51 10,275.52 G & K SERVICES 33698 AP 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (24.51) 10,251.01 AR 1347 04/30/2014 Recode FD Mar/Apr Cable 925.00 11,176.01 GL _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,843.14 11,176.01 ** 20,472.00 Budgeted 9,295.99 Remaining 55 % Used Account: 122-55090-045-000 Vehicle Maintenance 1312 04/28/2014 3/27/14-4/28/14 PCards TCI #627 2,919.43 1,875.38 4,794.81 TCI #627 PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 1,875.38 4,794.81 ** 14,850.00 Budgeted 10,055.19 Remaining 32 % Used Account: 122-60005-045-000 Telephone 3.34 .00 3.34 _______________ Account: 122-60005-045-000 Telephone Totals: .00 3.34 ** 100.00 Budgeted 96.66 Remaining 3 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1143 04/08/2014 April A/P Symonds, Acclaim, Verizon 1,388.27 139.52 1,527.79 TOWN OF TROPHY CLUB 33670 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1210 04/11/2014 FD Payroll 4/11/14 1,388.27 75.00 1,602.79 GL _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 214.52 1,602.79 ** 4,237.00 Budgeted 2,634.21 Remaining 38 % Used Account: 122-60020-045-000 Electricity/Gas 1203 04/22/2014 April A/P Electricity 3/12-4/11 3,680.03 801.06 4,481.09 HUDSON ENERGY SERVICES, LLC 33680 AP 1228 04/29/2014 April A/P Gas @ Fire Station 3/21/14-4/1 116.07 4,597.16 ATMOS ENERGY 33695 AP 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (458.56) 4,138.60 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 458.57 4,138.60 ** 9,268.00 Budgeted 5,129.40 Remaining 45 % Used Account: 122-60025-045-000 Water 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: 407.02 (90.49) 316.53 AR 1333 04/30/2014 April A/P April Water 180.98 497.51 TROPHY CLUB MUD (WATER BILLS) 33770 AP _______________ Account: 122-60025-045-000 Water Totals: 90.49 497.51 ** 1,500.00 Budgeted 1,002.49 Remaining 33 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,279.00 .00 214,279.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,279.00 ** 214,279.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 1228 04/29/2014 April A/P Return Boots 29.89 4.28 34.17 FEDERAL EXPRESS CORP 33697 AP 1289 04/30/2014 April Postage Meter usage 1.92 36.09 GL _______________ Account: 122-60035-045-000 Postage Totals: 6.20 36.09 ** 100.00 Budgeted 63.91 Remaining 36 % Used Account: 122-60055-045-000 Insurance 53 04/01/2014 Apr Ins & W/C Expense 6,097.50 1,009.25 7,106.75 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 7,106.75 ** 12,110.00 Budgeted 5,003.25 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60066-045-000 Publications/Books/Subscrips 112.75 .00 112.75 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 112.75 ** 400.00 Budgeted 287.25 Remaining 28 % Used Account: 122-60070-045-000 Dues & Memberships 1312 04/28/2014 3/27/14-4/28/14 PCards INTERNATIONAL ASSOC 8,197.64 214.00 8,411.64 INTERNATIONAL ASSOC PC _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 214.00 8,411.64 ** 15,180.00 Budgeted 6,768.36 Remaining 55 % Used Account: 122-60080-045-000 Schools & Training 1312 04/28/2014 3/27/14-4/28/14 PCards TX DEPT PUBLIC SAFETY 2,270.00 150.00 2,420.00 TX DEPT PUBLIC SAFETY PC 1312 04/28/2014 3/27/14-4/28/14 PCards TX DEPT PUBLIC SAFETY 150.00 2,570.00 TX DEPT PUBLIC SAFETY PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 300.00 2,570.00 ** 4,280.00 Budgeted 1,710.00 Remaining 60 % Used Account: 122-60096-045-000 Emergency Management 1,525.41 .00 1,525.41 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,525.41 ** 2,000.00 Budgeted 474.59 Remaining 76 % Used Account: 122-60100-045-000 Travel & per diem 1,812.01 .00 1,812.01 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 1,812.01 ** 4,577.00 Budgeted 2,764.99 Remaining 40 % 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-60160-045-000 Programs & Special Projects . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1312 04/28/2014 3/27/14-4/28/14 PCards VINNYS ITALIAN RESTAUR 341.17 50.00 391.17 VINNYS ITALIAN RESTAUR PC 1312 04/28/2014 3/27/14-4/28/14 PCards TAGG TEAM SPORTS & MOR 289.08 680.25 TAGG TEAM SPORTS & MOR PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 339.08 680.25 ** 4,500.00 Budgeted 3,819.75 Remaining 15 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 1312 04/28/2014 3/27/14-4/28/14 PCards FEDEXOFFICE 00014241 150.00 40.00 190.00 FEDEXOFFICE 00014241 PC _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 40.00 190.00 ** 1,500.00 Budgeted 1,310.00 Remaining 13 % Used Account: 122-60195-045-000 Flags & Repair 1143 04/08/2014 April A/P Symonds, Acclaim, Verizon 832.75 37.50 870.25 TOWN OF TROPHY CLUB 33670 AP 1143 04/08/2014 April A/P Symonds, Acclaim, Verizon 80.37 950.62 TOWN OF TROPHY CLUB 33670 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 117.87 950.62 ** 2,000.00 Budgeted 1,049.38 Remaining 48 % Used Account: 122-60243-045-000 Prior Year Expense 3,456.54 .00 3,456.54 _______________ Account: 122-60243-045-000 Prior Year Expense Totals: .00 3,456.54 ** 3,457.00 Budgeted .46 Remaining 100 % Used Account: 122-60245-045-000 Miscellaneous Expense 1133 04/04/2014 April A/P Donations for Pancake breakfas 359.97 250.00 609.97 Trophy Club Emer Vol Assoc. 33671 AP 1233 04/09/2014 Pancake Breakfast donation (250.00) 359.97 GL _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 359.97 ** 1,000.00 Budgeted 640.03 Remaining 36 % Used Account: 122-65005-045-000 Fuel & Lube 1299 04/30/2014 April Gas Log 3,916.89 863.72 4,780.61 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 863.72 4,780.61 ** 10,198.00 Budgeted 5,417.39 Remaining 47 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-65010-045-000 Uniforms 1203 04/22/2014 April A/P Uniforms 1,386.15 337.71 1,723.86 MUNICIPAL EMERGENCY SERVICES 33686 AP 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (168.85) 1,555.01 AR 1333 04/30/2014 April A/P Uniform shirt 47.50 1,602.51 MUNICIPAL EMERGENCY SERVICES 33749 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 216.36 1,602.51 ** 3,360.00 Budgeted 1,757.49 Remaining 48 % Used Account: 122-65015-045-000 Protective Clothing 1203 04/22/2014 April A/P Peters Helmet, Hawkins Boots p 1,651.87 280.00 1,931.87 CASCO INDUSTRIES INC 33677 AP 1312 04/28/2014 3/27/14-4/28/14 PCards REDBACK, USA 85.00 2,016.87 REDBACK, USA PC _______________ Account: 122-65015-045-000 Protective Clothing Totals: 365.00 2,016.87 ** 7,600.00 Budgeted 5,583.13 Remaining 27 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 1312 04/28/2014 3/27/14-4/28/14 PCards HOMEDEPOT.COM 344.73 129.00 473.73 HOMEDEPOT.COM PC 1312 04/28/2014 3/27/14-4/28/14 PCards A-PLUS STAMPS & SIGNS 44.65 518.38 A-PLUS STAMPS & SIGNS PC _______________ Account: 122-65035-045-000 Small Tools Totals: 173.65 518.38 ** 2,500.00 Budgeted 1,981.62 Remaining 21 % Used Account: 122-65085-045-000 Office Supplies 1143 04/08/2014 April A/P Office Supplies 161.22 72.00 233.22 OFFICE DEPOT, INC 33663 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 72.00 233.22 ** 500.00 Budgeted 266.78 Remaining 47 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt-Interest 1,515.50 .00 1,515.50 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 1,515.50 ** 3,031.00 Budgeted 1,515.50 Remaining 50 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 34,200.00 Budgeted 34,200.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 67,647.00 Budgeted 67,647.00 Remaining 0 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 20,400.00 Budgeted 20,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 672,803.68 ** 1,260,950.00 Budgeted 588,146.32 Remaining 53 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (561,328.13) .00 Budgeted 561,328.13 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET APRIL 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 4/30/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 293,346 - - 293,346 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,502,685 - - 1,502,685 INVESTMENTS-TEXPOOL 771,080 193,050 282,527 1,246,657 PREPAID EXPENSES 37,357 - - 37,357 ADVALOREM PROPERTY TAXES RECEIVABLE 3,510 - - 3,510 UTILITY AND OTHER ACCOUNTS RECEIVABLE 594,366 - - 594,366 - TOTAL ASSETS 3,202,944 193,050 282,527 3,678,521 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,510 - - 3,510 ACCOUNTS AND OTHER PAYABLES 430,651 - 3,072 433,723 CUSTOMER DEPOSITS 249,287 - - 249,287 - TOTAL LIABILITIES 683,448 - 3,072 686,520 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 193,050 313,050 NON-SPENDABLE FUND BALANCE 29,524 29,524 ASSIGNED FUND BALANCE 276,500 245,101 521,601 UNASSIGNED FUND BALANCE 2,682,452 - - 2,682,452 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (468,980) - 34,354 (434,626) - TOTAL FUND BALANCE 2,519,496 193,050 279,455 2,992,001 - TOTAL LIABILITIES AND FUND BALANCE 3,202,944 193,050 282,527 3,798,521 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,250.00- 99,250.00- 498.24- 97,436.67- 98.173 1,813.33- 135-40002-000-000 Property Taxes/Delinquent 82.62- 116.45- 116.45 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 101.83- 453.25- 50.361 446.75- Subtotal: 100,150.00- 100,150.00- 682.69- 98,006.37- 97.860 2,143.63- 135-43215-000-000 Insurance Settlement 82.36- 82.36 Subtotal: 82.36- 82.36 135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 256,348.13- 1,394,162.60- 37.185 2,355,147.40- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 166,565.65- 1,017,293.23- 59.549 691,027.77- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 3,617.30- 27,944.14- 43.309 36,577.86- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 1,028.00- 5,046.00- 55.603 4,029.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 400.00- 250.00- 1,750.00- 437.500 1,350.00 135-47045-000-000 Sewer Inspections 4,400.00- 3,800.00- 900.00- 5,550.00- 146.053 1,750.00 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 7,609.00- 17,634.78- 22.158 61,951.22- Subtotal: 5,616,414.00- 5,615,014.00- 436,318.08- 2,469,380.75- 43.978 3,145,633.25- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 29,900.00- 216,200.00- 37.141 365,909.00- Subtotal: 582,109.00- 582,109.00- 29,900.00- 216,200.00- 37.141 365,909.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 502.10- 3,546.10- 73.877 1,253.90- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 6,373.71- 62.709 3,790.29- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 4,083.31- 58.333 2,916.69- 135-49030-000-000 Vending Revenue 350.00- 350.00- 146.00- 41.714 204.00- 135-49035-000-000 Prior Year Reserves 880,000.00 880,000.00 135-49036-000-000 GASB Reserves 8,964.00- 8,964.00- 8,964.00- 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 10,352.32- 56,456.80- 67.210 27,543.20- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- 1,158.08- 38.603 1,841.92- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 100.00- 135-49903-000-000 Recovery of Prior Year Expense 4,087.00 4,087.00- -100.000 8,174.00 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 764,823.00 12,348.28- 75,851.00- -9.917 840,674.00 Program number: 6,417,937.00- 5,532,450.00- 479,249.05- 2,859,520.48- 51.686 2,672,929.52- Department number: Revenues 6,417,937.00- 5,532,450.00- 479,249.05- 2,859,520.48- 51.686 2,672,929.52- Revenues Subtotal ----------- 6,417,937.00- 5,532,450.00- 479,249.05- 2,859,520.48- 51.686 2,672,929.52- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 287,709.00 287,709.00 22,138.65 150,943.34 52.464 136,765.66 135-50010-010-000 Overtime 13,391.00 16,391.00 1,286.73 11,813.22 72.071 4,577.78 135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 375.00 2,400.00 47.059 2,700.00 135-50020-010-000 Retirement 27,847.00 27,847.00 2,137.27 15,715.49 56.435 12,131.51 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 3,559.98 22,700.55 46.966 25,633.45 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 249.12 1,676.97 42.649 2,255.03 135-50028-010-000 Vision Insurance 873.00 873.00 63.03 406.99 46.620 466.01 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 234.03 1,470.16 44.469 1,835.84 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,477.91 10,882.77 56.420 8,406.23 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 345.64 2,545.17 56.421 1,965.83 135-50040-010-000 Unemployment Taxes 54.00 1,244.00 1,244.44 100.035 .44- 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 5,617.15 57.149 4,211.85 135-50060-010-000 Pre-emp Physicals/Testing 200.00 350.00 233.90 66.829 116.10 135-50070-010-000 Employee Relations 300.00 300.00 54.00 161.78 53.927 138.22 Subtotal: 429,580.00 433,920.00 32,723.81 232,716.93 53.631 201,203.07 135-55005-010-000 Engineering 3,000.00 6,000.00 6,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 61,000.00 2,857.76 34,624.28 56.761 26,375.72 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 2,479.60 49.592 2,520.40 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 2,500.00 248.33 9.933 2,251.67 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 1,498.91 2,693.91 48.980 2,806.09 Subtotal: 67,000.00 80,000.00 4,356.67 40,046.12 50.058 39,953.88 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 383.37 2,297.93 46.772 2,615.07 135-60020-010-000 Electricity 162,160.00 155,160.00 9,167.16 56,624.41 36.494 98,535.59 135-60066-010-000 Publications/Books/Subscripts 500.00 2,538.00 2,538.00 135-60070-010-000 Dues & Memberships 150.00 300.00 289.00 96.333 11.00 135-60080-010-000 Schools & Training 4,184.00 1,500.00 1,065.00 71.000 435.00 135-60090-010-000 Safety Program 400.00 135-60100-010-000 Travel & per diem 1,450.00 279.00 171.13 61.337 107.87 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 36.00 60.00 12.000 440.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 32,195.79 67.924 15,204.21 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 156,796.58 782,475.27 33.461 1,555,997.73 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 199.35 1,289.55 36.844 2,210.45 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 2,000.00 1,664.20 83.210 335.80 Subtotal: 2,567,580.00 2,557,013.00 166,582.46 878,132.28 34.342 1,678,880.72 135-65005-010-000 Fuel & Lube 23,181.00 22,181.00 1,330.63 7,139.26 32.186 15,041.74 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,270.00 2,500.00 1,938.58 77.543 561.42 135-65030-010-000 Chemicals 5,000.00 5,000.00 1,004.93 3,672.22 73.444 1,327.78 135-65035-010-000 Small Tools 1,200.00 1,200.00 464.94 38.745 735.06 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 322.67 32.267 677.33 135-65050-010-000 Meter Expense 143,550.00 143,550.00 4,193.92 64,481.04 44.919 79,068.96 Subtotal: 177,201.00 175,431.00 6,529.48 78,018.71 44.473 97,412.29 135-69005-010-000 Capital Outlays 37,000.00 35,681.00 35,679.59 99.996 1.41 135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 122,980.00 25.099 367,000.00 135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 11,621.26 60.314 7,646.74 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 135-69280-010-000 Capital Repairs 7,500.00 135-69281-010-000 Water Tank Inspection Contract 106,847.00 100,847.00 100,816.54 99.970 30.46 Subtotal: 690,595.00 645,776.00 271,097.39 41.980 374,678.61 Program number: 3,931,956.00 3,892,140.00 210,192.42 1,500,011.43 38.540 2,392,128.57 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 1,000.00 2,000.00 266.12 964.61 48.231 1,035.39 Subtotal: 1,000.00 2,000.00 266.12 964.61 48.231 1,035.39 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 2,496.19 49.924 2,503.81 Subtotal: 5,000.00 2,496.19 49.924 2,503.81 Program number: 1 Lab Analysis for PID 1,000.00 7,000.00 266.12 3,460.80 49.440 3,539.20 Department number: Water 3,932,956.00 3,899,140.00 210,458.54 1,503,472.23 38.559 2,395,667.77 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 202,894.00 202,894.00 15,571.03 109,470.35 53.954 93,423.65 135-50010-020-000 Overtime 11,965.00 11,965.00 1,430.26 8,534.36 71.328 3,430.64 135-50016-020-000 Longevity 2,998.00 2,998.00 2,997.50 99.983 .50 135-50017-020-000 Certification 4,800.00 4,800.00 400.00 2,800.00 58.333 2,000.00 135-50020-020-000 Retirement 19,905.00 19,905.00 1,562.64 11,585.80 58.205 8,319.20 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,426.76 23,534.56 54.139 19,936.44 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 211.38 1,524.90 51.017 1,464.10 135-50028-020-000 Vision Insurance 658.00 658.00 51.26 354.83 53.926 303.17 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 185.56 1,222.05 53.063 1,080.95 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 932.91 7,085.51 51.326 6,719.49 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 218.17 1,657.08 51.319 1,571.92 135-50040-020-000 Unemployment Taxes 36.00 828.00 828.00 100.000 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 3,745.56 57.167 2,806.44 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 63.00 42.000 87.00 135-50070-020-000 Employee Relations 350.00 350.00 59.99 17.140 290.01 Subtotal: 316,105.00 316,897.00 24,525.05 175,463.49 55.369 141,433.51 135-55070-020-000 Independent Labor 880,000.00 74,117.50 534,983.75 60.794 345,016.25 135-55080-020-000 Maintenance & Repairs 35,000.00 36,120.00 979.82 24,674.29 68.312 11,445.71 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 425.03 1,652.49 82.625 347.51 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 135-55125-020-000 Dumpster Services 52,000.00 47,000.00 8,184.92 32,959.57 70.127 14,040.43 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,688.00 17,539.26 58.464 12,460.74 Subtotal: 119,500.00 995,120.00 85,395.27 611,809.36 61.481 383,310.64 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 306.74 1,536.30 46.149 1,792.70 135-60020-020-000 Electricity 148,227.00 138,227.00 9,414.58 58,056.46 42.001 80,170.54 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 351.00 87.750 49.00 135-60080-020-000 Schools & Training 2,636.00 1,636.00 570.00 1,087.00 66.443 549.00 135-60090-020-000 Safety Program 250.00 500.00 432.07 86.414 67.93 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 292.81 27.887 757.19 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 52.006 8,231.00 135-60243-020-000 Prior Year Expense 3,554.00 3,554.22 100.006 .22- 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 250.00 250.00 135-60360-020-000 Furniture/Equipment < $5000 3,000.00 1,079.00 1,079.10 100.009 .10- Subtotal: 178,242.00 168,875.00 10,291.32 75,607.49 44.771 93,267.51 135-65005-020-000 Fuel & Lube 14,720.00 13,600.00 1,011.45 6,334.35 46.576 7,265.65 135-65010-020-000 Uniforms 1,752.00 1,752.00 1,437.27 82.036 314.73 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-020-000 Chemicals 39,000.00 31,000.00 3,413.98 17,572.10 56.684 13,427.90 135-65035-020-000 Small Tools 1,000.00 300.00 91.00 30.333 209.00 135-65040-020-000 Safety Equipment 250.00 500.00 230.63 46.126 269.37 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 289.05 6,932.13 46.214 8,067.87 Subtotal: 71,722.00 62,152.00 4,714.48 32,597.48 52.448 29,554.52 135-69005-020-000 Capital Outlays 31,000.00 135-69008-020-000 Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 100.000 135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 1,043.70 73.397 378.30 135-69280-020-000 Capital Repairs 30,000.00 Subtotal: 82,442.00 21,442.00 21,063.70 98.236 378.30 Program number: 768,011.00 1,564,486.00 124,926.12 916,541.52 58.584 647,944.48 Department number: Wastewater 768,011.00 1,564,486.00 124,926.12 916,541.52 58.584 647,944.48 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 90,299.00 90,299.00 6,869.29 40,044.93 44.347 50,254.07 135-50010-021-000 Overtime 10,028.00 10,028.00 213.98 2,573.12 25.659 7,454.88 135-50016-021-000 Longevity 17,913.00 2,108.00 2,107.50 99.976 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 1,050.00 58.333 750.00 135-50020-021-000 Retirement 9,025.00 9,025.00 649.55 4,465.65 49.481 4,559.35 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,473.70 11,147.59 47.100 12,520.41 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 102.60 812.79 47.727 890.21 135-50028-021-000 Vision Insurance 314.00 314.00 23.68 170.57 54.322 143.43 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 71.54 611.03 57.320 454.97 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 406.70 2,785.58 37.431 4,656.42 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 95.11 651.46 37.419 1,089.54 135-50040-021-000 Unemployment Taxes 198.00 414.00 69.53 372.68 90.019 41.32 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 1,872.78 57.167 1,403.22 135-50070-021-000 Employee Relations 200.00 200.00 132.02 66.010 67.98 Subtotal: 168,673.00 153,084.00 10,393.22 68,797.70 44.941 84,286.30 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 23,801.00 14,451.00 1,585.78 5,700.26 39.445 8,750.74 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 999.18 49.959 1,000.82 Subtotal: 27,301.00 16,451.00 1,585.78 6,699.44 40.724 9,751.56 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 102.68 789.08 59.196 543.92 135-60020-021-000 Electricity 21,178.00 21,178.00 1,907.41 11,947.04 56.413 9,230.96 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 135-60080-021-000 Schools & Training 1,711.00 911.00 911.00 135-60090-021-000 Safety Program 300.00 300.00 35.34 35.34 11.780 264.66 135-60100-021-000 Travel & per diem 550.00 250.00 38.49 38.49 15.396 211.51 135-60105-021-000 Rent/Lease Equipment 10,000.00 5,000.00 5,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 29,322.00 2,083.92 12,809.95 43.687 16,512.05 135-65005-021-000 Fuel & Lube 22,397.00 21,747.00 1,140.78 7,031.03 32.331 14,715.97 135-65010-021-000 Uniforms 1,040.00 1,040.00 814.23 78.291 225.77 135-65030-021-000 Chemicals 6,000.00 2,000.00 2,000.00 135-65035-021-000 Small Tools 1,000.00 300.00 43.99 14.663 256.01 135-65040-021-000 Safety Equipment 500.00 750.00 586.73 78.231 163.27 Subtotal: 30,937.00 25,837.00 1,140.78 8,475.98 32.806 17,361.02 135-69005-021-000 Capital Outlays 100,000.00 114,000.00 68,300.20 59.912 45,699.80 135-69008-021-000 Short Term Debt-Principal 35,991.00 35,991.00 35,991.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69009-021-000 Short Term Debt-Interest 2,846.00 2,846.00 2,846.00 135-69280-021-000 Capital Repairs 71,000.00 Subtotal: 209,837.00 152,837.00 68,300.20 44.688 84,536.80 Program number: 472,170.00 377,531.00 15,203.70 165,083.27 43.727 212,447.73 Department number: Collection 472,170.00 377,531.00 15,203.70 165,083.27 43.727 212,447.73 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2014 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 400.00 5,600.00 56.000 4,400.00 135-50030-026-000 Social Security Taxes 620.00 620.00 24.80 347.20 56.000 272.80 135-50035-026-000 Medicare Taxes 145.00 145.00 5.80 81.20 56.000 63.80 135-50040-026-000 Unemployment Taxes 10.00 230.00 9.20 73.80 32.087 156.20 135-50045-026-000 Workman's Compensation 36.00 36.00 2.95 20.65 57.361 15.35 Subtotal: 10,811.00 11,031.00 442.75 6,122.85 55.506 4,908.15 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 1,200.00 35.95 2.996 1,164.05 135-60080-026-000 Schools & Training 4,000.00 4,000.00 265.00 6.625 3,735.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 41.66 41.66 .833 4,958.34 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 Subtotal: 11,850.00 11,850.00 41.66 377.61 3.187 11,472.39 Program number: 22,661.00 22,881.00 484.41 6,500.46 28.410 16,380.54 Department number: Board of Directors 22,661.00 22,881.00 484.41 6,500.46 28.410 16,380.54 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 458,721.00 458,721.00 35,083.49 248,617.20 54.198 210,103.80 135-50010-030-000 Overtime 500.00 750.00 20.49 588.02 78.403 161.98 135-50016-030-000 Longevity 3,018.00 3,018.00 3,077.50 101.972 59.50- 135-50020-030-000 Retirement 41,419.00 41,419.00 3,152.35 23,627.73 57.046 17,791.27 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,804.81 32,550.47 56.196 25,372.53 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 340.42 2,520.70 49.425 2,579.30 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 81.62 574.07 52.812 512.93 135-50029-030-000 Life Insurance & Other 4,483.00 5,500.00 348.39 2,887.07 52.492 2,612.93 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 2,054.10 15,449.15 53.907 13,209.85 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 480.38 3,613.11 53.911 3,088.89 135-50040-030-000 Unemployment Taxes 63.00 1,449.00 1,449.00 100.000 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.63 900.41 57.169 674.59 135-50060-030-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 6.38 2,668.93 53.379 2,331.07 Subtotal: 614,450.00 617,103.00 46,501.06 338,523.36 54.857 278,579.64 135-55030-030-000 Software & Support 59,698.00 59,698.00 3,099.99 24,123.81 40.410 35,574.19 135-55070-030-000 Independent Labor 7,700.00 7,000.00 872.00 5,795.48 82.793 1,204.52 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 415.51 428.45 9.521 4,071.55 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 188.84 2,119.27 32.604 4,380.73 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 9,569.82 49.999 9,570.18 135-55160-030-000 Professional Outside Services 15,000.00 10,000.00 10,000.00 135-55161-030-000 Town Personnel Contract 77,048.00 77,048.00 77,048.00 100.000 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 6,808.00 6,808.00 1,997.32 4,897.39 71.936 1,910.61 Subtotal: 196,594.00 190,894.00 6,573.66 123,982.22 64.948 66,911.78 135-60005-030-000 Telephone 11,250.00 11,250.00 299.25 6,506.50 57.836 4,743.50 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 4,057.00 440.67 1,934.26 47.677 2,122.74 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 6,319.18 41.653 8,851.82 135-60025-030-000 Water 1,500.00 1,500.00 97.86 528.02 35.201 971.98 135-60035-030-000 Postage 28,500.00 28,500.00 4,442.70 15,446.73 54.199 13,053.27 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 2,592.79 17,259.27 60.922 11,070.73 135-60050-030-000 Bad Debt Expense 1,500.00 6,200.00 43.87- 4,153.40 66.990 2,046.60 135-60055-030-000 Insurance 53,561.00 53,561.00 4,269.73 30,016.36 56.041 23,544.64 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 401.08 40.108 598.92 135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 4,011.95 89.154 488.05 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 5,000.00 274.83 5.497 4,725.17 135-60080-030-000 Schools & Training 7,500.00 6,800.00 941.00 2,592.30 38.122 4,207.70 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 616.34 1,438.76 28.775 3,561.24 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 2,500.00 2,500.00 281.76 281.76 11.270 2,218.24 135-60125-030-000 Advertising 2,500.00 2,500.00 589.43 23.577 1,910.57 135-60235-030-000 Security 1,350.00 1,350.00 123.56 9.153 1,226.44 135-60245-030-000 Miscellaneous Expenses 22,870.00 17,870.00 376.25 2.105 17,493.75 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 204,221.00 208,689.00 13,938.23 92,253.64 44.206 116,435.36 135-65010-030-000 Uniforms 1,390.00 1,390.00 998.90 71.863 391.10 135-65055-030-000 Hardware 13,562.00 13,562.00 2,178.04 16.060 11,383.96 135-65085-030-000 Office Supplies 9,100.00 9,100.00 405.35 2,773.09 30.474 6,326.91 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 929.72 2,403.47 41.931 3,328.53 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 148.98 1,618.37 64.735 881.63 135-65097-030-000 Vending Machine Supplies 200.00 200.00 76.96 38.480 123.04 135-65105-030-000 Printing 4,000.00 4,000.00 2,348.27 58.707 1,651.73 Subtotal: 36,484.00 36,484.00 1,484.05 12,397.10 33.980 24,086.90 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 128.43 1,412.68 40.947 2,037.32 Subtotal: 3,450.00 3,450.00 128.43 1,412.68 40.947 2,037.32 Program number: 1,055,199.00 1,056,620.00 68,625.43 568,569.00 53.810 488,051.00 Department number: Administration 1,055,199.00 1,056,620.00 68,625.43 568,569.00 53.810 488,051.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 15:13 05/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 131,300.00 347,126.00 23,856.09 138,438.39 39.881 208,687.61 135-55055-039-000 Auditing 21,840.00 21,840.00 21,200.00 97.070 640.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 6,243.84 62.438 3,756.16 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,451.40 64.511 1,348.60 Subtotal: 166,940.00 382,766.00 23,856.09 168,333.63 43.978 214,432.37 Program number: 166,940.00 382,766.00 23,856.09 168,333.63 43.978 214,432.37 Department number: Non Departmental 166,940.00 382,766.00 23,856.09 168,333.63 43.978 214,432.37 Expenditures Subtotal ----------- 6,417,937.00 7,303,424.00 443,554.29 3,328,500.11 45.575 3,974,923.89 Fund number: 135 MUD 1 General Fund 1,770,974.00 35,694.76- 468,979.63 26.481 1,301,994.37 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 15:13 05/12/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 4.57- 55.41- 55.41 507-49036-000-000 GASB Reserves 120,000.00- 120,000.00- 120,000.00 Subtotal: 120,004.57- 120,055.41- 120,055.41 Program number: 120,004.57- 120,055.41- 120,055.41 Department number: 120,004.57- 120,055.41- 120,055.41 Revenues Subtotal ----------- 120,004.57- 120,055.41- 120,055.41 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 15:13 05/12/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 82,629.40- Subtotal: 82,629.40 82,629.40- Program number: 2 Rate of Flow Control-FW Meter 82,629.40 82,629.40- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 15:13 05/12/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 282,245.17 3,072.00 3,072.00 1.088 279,173.17 Subtotal: 282,245.17 3,072.00 3,072.00 1.088 279,173.17 Program number: 3 Indian Creek Waterline 282,245.17 3,072.00 3,072.00 1.088 279,173.17 Department number: Water 282,245.17 3,072.00 85,701.40 30.364 196,543.77 Expenditures Subtotal ----------- 282,245.17 3,072.00 85,701.40 30.364 196,543.77 Fund number: 507 MUD 1 Capital Projects 282,245.17 116,932.57- 34,354.01- -12.172 316,599.18 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2014 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 1222 04/01/2014 Property Taxes/Assessments (96,938.43) (53.87) (96,992.30) GL 1225 04/02/2014 Property Taxes/Assessments (23.55) (97,015.85) GL 1226 04/03/2014 Property Taxes / Assessments (37.58) (97,053.43) GL 1227 04/04/2014 Property Taxes/Assessments (57.42) (97,110.85) GL 1234 04/07/2014 Property Taxes/Assessments (5.62) (97,116.47) GL 1235 04/08/2014 Property Taxes/Assessments (4.54) (97,121.01) GL 1236 04/09/2014 Property Taxes/Assessments (10.56) (97,131.57) GL 1237 04/11/2014 Property Taxes/Assessments (23.06) (97,154.63) GL 1238 04/14/2014 Property Taxes/Assessments 1.72 (97,152.91) GL 1239 04/15/2014 Property Taxes/Assessments 1.05 (97,151.86) GL 1240 04/16/2014 Property Taxes/Assessments (6.60) (97,158.46) GL 1241 04/21/2014 Property Taxes/Assessments (20.95) (97,179.41) GL 1242 04/22/2014 Property Taxes/Assessments (2.84) (97,182.25) GL 1243 04/23/2014 Property Taxes/Assessments (83.12) (97,265.37) GL 1288 04/28/2014 Property Taxes/Assessments (4.35) (97,269.72) GL 1290 04/29/2014 Property Taxes/Assessments (69.43) (97,339.15) GL 1291 04/30/2014 Property Taxes/Assessments (97.52) (97,436.67) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (498.24) (97,436.67) ** (99,250.00) Budgeted (1,813.33) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1226 04/03/2014 Property Taxes / Assessments (33.83) (75.47) (109.30) GL 1290 04/29/2014 Property Taxes/Assessments (6.87) (116.17) GL 1291 04/30/2014 Property Taxes/Assessments (.28) (116.45) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (82.62) (116.45) ** .00 Budgeted 116.45 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1222 04/01/2014 Property Taxes/Assessments (351.42) (3.09) (354.51) GL 1225 04/02/2014 Property Taxes/Assessments (2.12) (356.63) GL 1226 04/03/2014 Property Taxes / Assessments (51.60) (408.23) GL 1227 04/04/2014 Property Taxes/Assessments (5.17) (413.40) GL 1234 04/07/2014 Property Taxes/Assessments (.16) (413.56) GL 1236 04/09/2014 Property Taxes/Assessments (7.27) (420.83) GL 1237 04/11/2014 Property Taxes/Assessments (2.58) (423.41) GL 1238 04/14/2014 Property Taxes/Assessments (.07) (423.48) GL 1239 04/15/2014 Property Taxes/Assessments (.16) (423.64) GL 1240 04/16/2014 Property Taxes/Assessments (.73) (424.37) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1241 04/21/2014 Property Taxes/Assessments (351.42) (2.30) (426.67) GL 1242 04/22/2014 Property Taxes/Assessments (.32) (426.99) GL 1243 04/23/2014 Property Taxes/Assessments (9.15) (436.14) GL 1288 04/28/2014 Property Taxes/Assessments 2.66 (433.48) GL 1290 04/29/2014 Property Taxes/Assessments (9.50) (442.98) GL 1291 04/30/2014 Property Taxes/Assessments (10.27) (453.25) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (101.83) (453.25) ** (900.00) Budgeted (446.75) Remaining 50 % Used Account: 135-43215-000-000 Insurance Settlement (82.36) .00 (82.36) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (82.36) ** .00 Budgeted 82.36 Remaining 0 % Used Account: 135-47000-000-000 Water 1250 04/02/2014 UB 4/2/14 Adjustments UB20140402-20140402 User: (1,137,814.47) 9.77 (1,137,804.70) UB 1285 04/30/2014 UB 4/30/14 Billing UB20140430-20140430 User: (256,357.90) (1,394,162.60) UB _______________ Account: 135-47000-000-000 Water Totals: (256,348.13) (1,394,162.60) ** (3,749,310.00) Budgeted (2,355,147.40) Remaining 37 % Used Account: 135-47005-000-000 Sewer 1250 04/02/2014 UB 4/2/14 Adjustments UB20140402-20140402 User: (850,727.58) 9.78 (850,717.80) UB 1285 04/30/2014 UB 4/30/14 Billing UB20140430-20140430 User: (166,575.43) (1,017,293.23) UB _______________ Account: 135-47005-000-000 Sewer Totals: (166,565.65) (1,017,293.23) ** (1,708,321.00) Budgeted (691,027.77) Remaining 60 % Used Account: 135-47025-000-000 Penalties 1250 04/02/2014 UB 4/2/14 Adjustments UB20140402-20140402 User: (24,326.84) 3.70 (24,323.14) UB 1202 04/22/2014 UB 4/22/2014 Penalties UB20140422-20140422 User: (3,693.08) (28,016.22) UB 1245 04/30/2014 UB 04/30/2014 Adjustments UB20140430-20140430 User: 72.08 (27,944.14) UB _______________ Account: 135-47025-000-000 Penalties Totals: (3,617.30) (27,944.14) ** (64,522.00) Budgeted (36,577.86) Remaining 43 % Used Account: 135-47030-000-000 Service Charges . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1248 04/02/2014 UB 4/2/14 NSF Check Fee UB20140402-20140402 User: (4,018.00) (25.00) (4,043.00) UB 1253 04/04/2014 UB 4/4/14 NSF Check Fee UB20140404-20140404 User: (25.00) (4,068.00) UB 1142 04/08/2014 UB 4/8/14 Cut Off List UB20140408-20140408 User: (875.00) (4,943.00) UB 1256 04/08/2014 UB 4/8/14 NSF Check Fee UB20140408-20140408 User: (25.00) (4,968.00) UB 1259 04/09/2014 UB 4/9/14 NSF CHeck Fee UB20140409-20140409 User: (50.00) (5,018.00) UB 1264 04/14/2014 UB 4/14/14 NSF Check fee UB20140414-20140414 User: (25.00) (5,043.00) UB 1285 04/30/2014 UB 4/30/14 Billing UB20140430-20140430 User: (3.00) (5,046.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,028.00) (5,046.00) ** (9,075.00) Budgeted (4,029.00) Remaining 56 % Used Account: 135-47035-000-000 Plumbing Inspections 1228 04/29/2014 April A/P Refund Duplicate fees collecte (1,500.00) 50.00 (1,450.00) STANDARD PACIFIC HOMES 33707 AP 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (300.00) (1,750.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (1,750.00) ** (400.00) Budgeted 1,350.00 Remaining 438 % Used Account: 135-47045-000-000 Sewer Inspections 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (4,650.00) (900.00) (5,550.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (900.00) (5,550.00) ** (3,800.00) Budgeted 1,750.00 Remaining 146 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1285 04/30/2014 UB 4/30/14 Billing UB20140430-20140430 User: (10,025.78) (7,609.00) (17,634.78) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (7,609.00) (17,634.78) ** (79,586.00) Budgeted (61,951.22) Remaining 22 % Used Account: 135-48005-000-000 Utility Fees 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (186,300.00) (29,900.00) (216,200.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (29,900.00) (216,200.00) ** (582,109.00) Budgeted (365,909.00) Remaining 37 % Used Account: 135-49010-000-000 Interest Income 1298 04/30/2014 Bank Statement Interest/April (3,044.00) (395.12) (3,439.12) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1298 04/30/2014 Bank Statement Interest/April (3,044.00) (61.03) (3,500.15) GL 1298 04/30/2014 Bank Statement Interest/April (45.95) (3,546.10) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (502.10) (3,546.10) ** (4,800.00) Budgeted (1,253.90) Remaining 74 % Used Account: 135-49016-000-000 Cell Tower Revenue 1232 04/09/2014 AT&T Cell Tower Lease (5,463.18) (910.53) (6,373.71) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (6,373.71) ** (10,164.00) Budgeted (3,790.29) Remaining 63 % Used Account: 135-49018-000-000 Building Rent Income 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (3,499.98) (583.33) (4,083.31) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,083.31) ** (7,000.00) Budgeted (2,916.69) Remaining 58 % Used Account: 135-49030-000-000 Vending Revenue (146.00) .00 (146.00) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (146.00) ** (350.00) Budgeted (204.00) Remaining 42 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** 880,000.00 Budgeted 880,000.00 Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (8,964.00) Budgeted (8,964.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1228 04/29/2014 April A/P Refund Duplicate fees collecte (46,104.48) 343.00 (45,761.48) STANDARD PACIFIC HOMES 33707 AP 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (10,695.32) (56,456.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (10,352.32) (56,456.80) ** (84,000.00) Budgeted (27,543.20) Remaining 67 % Used Account: 135-49900-000-000 Miscellaneous Income (1,158.08) .00 (1,158.08) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: .00 (1,158.08) ** (3,000.00) Budgeted (1,841.92) Remaining 39 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (100.00) Budgeted (100.00) Remaining 0 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (4,087.00) .00 (4,087.00) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (4,087.00) ** 4,087.00 Budgeted 8,174.00 Remaining ########## Account: 135-49905-000-000 Gas Well Revenue .00 .00 _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (886.00) Budgeted (886.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,859,520.48) ** (5,532,450.00) Budgeted (2,672,929.52) Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 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 1135 04/11/2014 MUD payroll 4/11/14 Salaries & Wages 128,804.69 11,069.33 139,874.02 PR 1194 04/25/2014 MUD Payroll 4/25/14 Salaries & Wages 11,069.32 150,943.34 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 22,138.65 150,943.34 ** 287,709.00 Budgeted 136,765.66 Remaining 52 % Used Account: 135-50010-010-000 Overtime 1135 04/11/2014 MUD payroll 4/11/14 Overtime 10,526.49 636.11 11,162.60 PR 1194 04/25/2014 MUD Payroll 4/25/14 Overtime 650.62 11,813.22 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,286.73 11,813.22 ** 16,391.00 Budgeted 4,577.78 Remaining 72 % Used Account: 135-50016-010-000 Longevity 4,905.00 .00 4,905.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 4,905.00 ** 4,905.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1194 04/25/2014 MUD Payroll 4/25/14 Certification 2,025.00 375.00 2,400.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 375.00 2,400.00 ** 5,100.00 Budgeted 2,700.00 Remaining 47 % Used Account: 135-50020-010-000 Retirement 1135 04/11/2014 MUD payroll 4/11/14 Retirement 13,578.22 1,051.14 14,629.36 PR 1194 04/25/2014 MUD Payroll 4/25/14 Retirement 1,086.13 15,715.49 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,137.27 15,715.49 ** 27,847.00 Budgeted 12,131.51 Remaining 56 % Used Account: 135-50026-010-000 Medical Insurance 1135 04/11/2014 MUD payroll 4/11/14 Medical Insurance 19,140.57 1,780.02 20,920.59 PR 1194 04/25/2014 MUD Payroll 4/25/14 Medical Insurance 1,779.96 22,700.55 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,559.98 22,700.55 ** 48,334.00 Budgeted 25,633.45 Remaining 47 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 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 1135 04/11/2014 MUD payroll 4/11/14 Dental Insurance 1,427.85 124.54 1,552.39 PR 1194 04/25/2014 MUD Payroll 4/25/14 Dental Insurance 124.58 1,676.97 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 249.12 1,676.97 ** 3,932.00 Budgeted 2,255.03 Remaining 43 % Used Account: 135-50028-010-000 Vision Insurance 1135 04/11/2014 MUD payroll 4/11/14 Vision Insurance 343.96 31.49 375.45 PR 1194 04/25/2014 MUD Payroll 4/25/14 Vision Insurance 31.54 406.99 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 63.03 406.99 ** 873.00 Budgeted 466.01 Remaining 47 % Used Account: 135-50029-010-000 Life Insurance & Other 1093 04/01/2014 Apr A/P April Dental, Vol Life, ST Dis 1,236.13 218.75 1,454.88 METLIFE 33639 AP 1203 04/22/2014 April A/P Flex Adm 15.28 1,470.16 BenefitMall 33676 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 234.03 1,470.16 ** 3,306.00 Budgeted 1,835.84 Remaining 44 % Used Account: 135-50030-010-000 Social Security Taxes 1135 04/11/2014 MUD payroll 4/11/14 Social Security Taxes 9,404.86 734.88 10,139.74 PR 1194 04/25/2014 MUD Payroll 4/25/14 Social Security Taxes 743.03 10,882.77 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,477.91 10,882.77 ** 19,289.00 Budgeted 8,406.23 Remaining 56 % Used Account: 135-50035-010-000 Medicare Taxes 1135 04/11/2014 MUD payroll 4/11/14 Medicare Taxes 2,199.53 171.87 2,371.40 PR 1194 04/25/2014 MUD Payroll 4/25/14 Medicare Taxes 173.77 2,545.17 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 345.64 2,545.17 ** 4,511.00 Budgeted 1,965.83 Remaining 56 % Used Account: 135-50040-010-000 Unemployment Taxes 1,244.44 .00 1,244.44 . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 1,244.44 ** 1,244.00 Budgeted (.44) Remaining 100 % Used Account: 135-50045-010-000 Workman's Compensation 53 04/01/2014 Apr Ins & W/C Expense 4,814.70 802.45 5,617.15 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 5,617.15 ** 9,829.00 Budgeted 4,211.85 Remaining 57 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 233.90 .00 233.90 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 233.90 ** 350.00 Budgeted 116.10 Remaining 67 % Used Account: 135-50070-010-000 Employee Relations 1312 04/28/2014 3/27/14-4/28/14 PCards SALAD BOWL #10 107.78 54.00 161.78 SALAD BOWL #10 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 54.00 161.78 ** 300.00 Budgeted 138.22 Remaining 54 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1312 04/28/2014 3/27/14-4/28/14 PCards THE HOME DEPOT 6581 31,766.52 12.15 31,778.67 THE HOME DEPOT 6581 PC 1312 04/28/2014 3/27/14-4/28/14 PCards ROANOKE AUTO SUPPLY LT 8.55 31,787.22 ROANOKE AUTO SUPPLY LT PC 1312 04/28/2014 3/27/14-4/28/14 PCards ROANOKE AUTO SUPPLY LT 23.58 31,810.80 ROANOKE AUTO SUPPLY LT PC 1312 04/28/2014 3/27/14-4/28/14 PCards THE HOME DEPOT 6581 26.26 31,837.06 THE HOME DEPOT 6581 PC 1228 04/29/2014 April A/P Meter boxes, pumps, saddles 2,128.30 33,965.36 HD SUPPLY WATERWORKS, LTD. 33699 AP 1228 04/29/2014 April A/P Meter boxes 658.92 34,624.28 HD SUPPLY WATERWORKS, LTD. 33699 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,857.76 34,624.28 ** 61,000.00 Budgeted 26,375.72 Remaining 57 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-010-000 Vehicle Maintenance 2,479.60 .00 2,479.60 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 2,479.60 ** 5,000.00 Budgeted 2,520.40 Remaining 50 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 248.33 .00 248.33 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 248.33 ** 2,500.00 Budgeted 2,251.67 Remaining 10 % Used Account: 135-55135-010-000 Lab Analysis 1203 04/22/2014 April A/P Water Analysis/MUD 1,195.00 878.91 2,073.91 LOWER COLORADO RIVER AUTHORITY 33684 AP 1203 04/22/2014 April A/P Bac T Samples/MUD 400.00 2,473.91 TARRANT CTY PUBLIC HEALTH LAB 33688 AP 1334 04/30/2014 April A/P Bac T Samples/MUD 220.00 2,693.91 TARRANT CTY PUBLIC HEALTH LAB 33763 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 1,498.91 2,693.91 ** 5,500.00 Budgeted 2,806.09 Remaining 49 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1143 04/08/2014 April A/P Symonds, Acclaim, Verizon 1,914.56 383.37 2,297.93 TOWN OF TROPHY CLUB 33670 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 383.37 2,297.93 ** 4,913.00 Budgeted 2,615.07 Remaining 47 % Used Account: 135-60020-010-000 Electricity 1203 04/22/2014 April A/P Electricity 3/12-4/11 47,457.25 6,714.85 54,172.10 HUDSON ENERGY SERVICES, LLC 33680 AP 1203 04/22/2014 April A/P Electricity 3/11-4/10 77.69 54,249.79 HUDSON ENERGY SERVICES, LLC 33680 AP 1203 04/22/2014 April A/P Electricity 3/12-4/11 2,374.62 56,624.41 HUDSON ENERGY SERVICES, LLC 33680 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,167.16 56,624.41 ** 155,160.00 Budgeted 98,535.59 Remaining 36 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 2,538.00 Budgeted 2,538.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 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-010-000 Dues & Memberships 289.00 .00 289.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 289.00 ** 300.00 Budgeted 11.00 Remaining 96 % Used Account: 135-60080-010-000 Schools & Training 1,065.00 .00 1,065.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,065.00 ** 1,500.00 Budgeted 435.00 Remaining 71 % Used Account: 135-60100-010-000 Travel & per diem 171.13 .00 171.13 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 171.13 ** 279.00 Budgeted 107.87 Remaining 61 % Used Account: 135-60105-010-000 Rent/Lease Equipment 1203 04/22/2014 April A/P Nitrogen Bottle lease 24.00 36.00 60.00 ALLIED WELDING SUPPLY, INC 33675 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 36.00 60.00 ** 500.00 Budgeted 440.00 Remaining 12 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 32,195.79 .00 32,195.79 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 32,195.79 ** 47,400.00 Budgeted 15,204.21 Remaining 68 % Used Account: 135-60150-010-000 Wholesale Water 1228 04/29/2014 April A/P March Wholesale Water 625,678.69 156,796.58 782,475.27 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 156,796.58 782,475.27 ** 2,338,473.00 Budgeted 1,555,997.73 Remaining 33 % Used Account: 135-60245-010-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 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-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 1312 04/28/2014 3/27/14-4/28/14 PCards TEX-TURF 1,090.20 158.10 1,248.30 TEX-TURF PC 1312 04/28/2014 3/27/14-4/28/14 PCards TEX-TURF 41.25 1,289.55 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 199.35 1,289.55 ** 3,500.00 Budgeted 2,210.45 Remaining 37 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 1,664.20 .00 1,664.20 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 1,664.20 ** 2,000.00 Budgeted 335.80 Remaining 83 % Used Account: 135-65005-010-000 Fuel & Lube 1312 04/28/2014 3/27/14-4/28/14 PCards KWIK KAR LUBE & TUNE O 5,808.63 39.75 5,848.38 KWIK KAR LUBE & TUNE O PC 1299 04/30/2014 April Gas Log 1,181.69 7,030.07 GL 1333 04/30/2014 April A/P Oil & Oil filters 109.19 7,139.26 ROANOKE AUTO SUPPLY 33759 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,330.63 7,139.26 ** 22,181.00 Budgeted 15,041.74 Remaining 32 % Used Account: 135-65010-010-000 Uniforms 1,938.58 .00 1,938.58 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,938.58 ** 2,500.00 Budgeted 561.42 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 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-010-000 Chemicals 1333 04/30/2014 April A/P Chlorine gas 2,667.29 416.35 3,083.64 DPC INDUSTRIES, INC 33724 AP 1333 04/30/2014 April A/P Mono packets, chloride packets 588.58 3,672.22 HACH COMPANY 33731 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,004.93 3,672.22 ** 5,000.00 Budgeted 1,327.78 Remaining 73 % Used Account: 135-65035-010-000 Small Tools 464.94 .00 464.94 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 464.94 ** 1,200.00 Budgeted 735.06 Remaining 39 % Used Account: 135-65040-010-000 Safety Equipment 322.67 .00 322.67 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 322.67 ** 1,000.00 Budgeted 677.33 Remaining 32 % Used Account: 135-65050-010-000 Meter Expense 1228 04/29/2014 April A/P Meters for Holiday Inn 60,287.12 4,193.92 64,481.04 ATLAS UTILITY SUPPLY CO. 33694 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 4,193.92 64,481.04 ** 143,550.00 Budgeted 79,068.96 Remaining 45 % Used Account: 135-69005-010-000 Capital Outlays 35,679.59 .00 35,679.59 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 35,679.59 ** 35,681.00 Budgeted 1.41 Remaining 100 % Used Account: 135-69008-010-000 Short Term Debt-Principal 122,980.00 .00 122,980.00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 122,980.00 ** 489,980.00 Budgeted 367,000.00 Remaining 25 % Used Account: 135-69009-010-000 Short Term Debt-Interest . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 11,621.26 .00 11,621.26 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 11,621.26 ** 19,268.00 Budgeted 7,646.74 Remaining 60 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 100,816.54 ** 100,847.00 Budgeted 30.46 Remaining 100 % Used Account: 135-55135-010-001 Lab Analysis for PID 1203 04/22/2014 April A/P Water Analysis/PID 698.49 106.12 804.61 LOWER COLORADO RIVER AUTHORITY 33685 AP 1203 04/22/2014 April A/P Bac T Samples/PID 80.00 884.61 TARRANT CTY PUBLIC HEALTH LAB 33689 AP 1334 04/30/2014 April A/P Bac T Samples/PID 80.00 964.61 TARRANT CTY PUBLIC HEALTH LAB 33764 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 266.12 964.61 ** 2,000.00 Budgeted 1,035.39 Remaining 48 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID 2,496.19 .00 2,496.19 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 2,496.19 ** 5,000.00 Budgeted 2,503.81 Remaining 50 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,503,472.23 ** 3,899,140.00 Budgeted 2,395,667.77 Remaining 39 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 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 1135 04/11/2014 MUD payroll 4/11/14 Salaries & Wages 93,899.32 7,785.51 101,684.83 PR 1194 04/25/2014 MUD Payroll 4/25/14 Salaries & Wages 7,785.52 109,470.35 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,571.03 109,470.35 ** 202,894.00 Budgeted 93,423.65 Remaining 54 % Used Account: 135-50010-020-000 Overtime 1135 04/11/2014 MUD payroll 4/11/14 Overtime 7,104.10 453.98 7,558.08 PR 1194 04/25/2014 MUD Payroll 4/25/14 Overtime 976.28 8,534.36 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,430.26 8,534.36 ** 11,965.00 Budgeted 3,430.64 Remaining 71 % Used Account: 135-50016-020-000 Longevity 2,997.50 .00 2,997.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,997.50 ** 2,998.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1194 04/25/2014 MUD Payroll 4/25/14 Certification 2,400.00 400.00 2,800.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 2,800.00 ** 4,800.00 Budgeted 2,000.00 Remaining 58 % Used Account: 135-50020-020-000 Retirement 1135 04/11/2014 MUD payroll 4/11/14 Retirement 10,023.16 739.89 10,763.05 PR 1194 04/25/2014 MUD Payroll 4/25/14 Retirement 822.75 11,585.80 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,562.64 11,585.80 ** 19,905.00 Budgeted 8,319.20 Remaining 58 % Used Account: 135-50026-020-000 Medical Insurance 1135 04/11/2014 MUD payroll 4/11/14 Medical Insurance 20,107.80 1,713.39 21,821.19 PR 1194 04/25/2014 MUD Payroll 4/25/14 Medical Insurance 1,713.37 23,534.56 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,426.76 23,534.56 ** 43,471.00 Budgeted 19,936.44 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 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 1135 04/11/2014 MUD payroll 4/11/14 Dental Insurance 1,313.52 105.68 1,419.20 PR 1194 04/25/2014 MUD Payroll 4/25/14 Dental Insurance 105.70 1,524.90 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 211.38 1,524.90 ** 2,989.00 Budgeted 1,464.10 Remaining 51 % Used Account: 135-50028-020-000 Vision Insurance 1135 04/11/2014 MUD payroll 4/11/14 Vision Insurance 303.57 25.61 329.18 PR 1194 04/25/2014 MUD Payroll 4/25/14 Vision Insurance 25.65 354.83 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 51.26 354.83 ** 658.00 Budgeted 303.17 Remaining 54 % Used Account: 135-50029-020-000 Life Insurance & Other 1093 04/01/2014 Apr A/P April Dental, Vol Life, ST Dis 1,036.49 155.00 1,191.49 METLIFE 33639 AP 1203 04/22/2014 April A/P Flex Adm 30.56 1,222.05 BenefitMall 33676 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 185.56 1,222.05 ** 2,303.00 Budgeted 1,080.95 Remaining 53 % Used Account: 135-50030-020-000 Social Security Taxes 1135 04/11/2014 MUD payroll 4/11/14 Social Security Taxes 6,152.60 449.65 6,602.25 PR 1194 04/25/2014 MUD Payroll 4/25/14 Social Security Taxes 483.26 7,085.51 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 932.91 7,085.51 ** 13,805.00 Budgeted 6,719.49 Remaining 51 % Used Account: 135-50035-020-000 Medicare Taxes 1135 04/11/2014 MUD payroll 4/11/14 Medicare Taxes 1,438.91 105.17 1,544.08 PR 1194 04/25/2014 MUD Payroll 4/25/14 Medicare Taxes 113.00 1,657.08 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 218.17 1,657.08 ** 3,229.00 Budgeted 1,571.92 Remaining 51 % Used Account: 135-50040-020-000 Unemployment Taxes 828.00 .00 828.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 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 828.00 ** 828.00 Budgeted .00 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 53 04/01/2014 Apr Ins & W/C Expense 3,210.48 535.08 3,745.56 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 3,745.56 ** 6,552.00 Budgeted 2,806.44 Remaining 57 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 63.00 .00 63.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 63.00 ** 150.00 Budgeted 87.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 59.99 .00 59.99 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 59.99 ** 350.00 Budgeted 290.01 Remaining 17 % Used Account: 135-55070-020-000 Independent Labor 1333 04/30/2014 April A/P WWTP Improvements 460,866.25 74,117.50 534,983.75 THE WALLACE GROUP, INC. 33768 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 74,117.50 534,983.75 ** 880,000.00 Budgeted 345,016.25 Remaining 61 % Used Account: 135-55080-020-000 Maintenance & Repairs 1312 04/28/2014 3/27/14-4/28/14 PCards FERGUSON ENT #788 23,694.47 46.22 23,740.69 FERGUSON ENT #788 PC 1312 04/28/2014 3/27/14-4/28/14 PCards FERGUSON ENT #788 383.28 24,123.97 FERGUSON ENT #788 PC 1333 04/30/2014 April A/P Longofill for bar screen 550.32 24,674.29 ANDRITZ SEPARATION INC 33711 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 979.82 24,674.29 ** 36,120.00 Budgeted 11,445.71 Remaining 68 % Used Account: 135-55090-020-000 Vehicle Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1333 04/30/2014 April A/P Alignment and two tires on 201 1,227.46 425.03 1,652.49 BLAGG TIRE & SERVICE 33713 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 425.03 1,652.49 ** 2,000.00 Budgeted 347.51 Remaining 83 % Used Account: 135-55125-020-000 Dumpster Services 1333 04/30/2014 April A/P Sludge haul off 24,774.65 2,623.95 27,398.60 L.H. CHANEY MATERIALS, INC. 33736 AP 1333 04/30/2014 April A/P Sludge haul off 3,852.25 31,250.85 L.H. CHANEY MATERIALS, INC. 33736 AP 1333 04/30/2014 April A/P Sludge haul off 1,708.72 32,959.57 L.H. CHANEY MATERIALS, INC. 33736 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 8,184.92 32,959.57 ** 47,000.00 Budgeted 14,040.43 Remaining 70 % Used Account: 135-55135-020-000 Lab Analysis 1333 04/30/2014 April A/P Testing 15,851.26 246.00 16,097.26 OXIDOR LABORATORIES LLC 33752 AP 1333 04/30/2014 April A/P Testing 176.00 16,273.26 OXIDOR LABORATORIES LLC 33752 AP 1333 04/30/2014 April A/P Testing 246.00 16,519.26 OXIDOR LABORATORIES LLC 33752 AP 1333 04/30/2014 April A/P Testing 176.00 16,695.26 OXIDOR LABORATORIES LLC 33752 AP 1333 04/30/2014 April A/P Testing 246.00 16,941.26 OXIDOR LABORATORIES LLC 33752 AP 1333 04/30/2014 April A/P Testing 176.00 17,117.26 OXIDOR LABORATORIES LLC 33752 AP 1333 04/30/2014 April A/P Testing 246.00 17,363.26 OXIDOR LABORATORIES LLC 33752 AP 1333 04/30/2014 April A/P Testing 176.00 17,539.26 OXIDOR LABORATORIES LLC 33752 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,688.00 17,539.26 ** 30,000.00 Budgeted 12,460.74 Remaining 58 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1143 04/08/2014 April A/P Symonds, Acclaim, Verizon 1,229.56 306.74 1,536.30 TOWN OF TROPHY CLUB 33670 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 306.74 1,536.30 ** 3,329.00 Budgeted 1,792.70 Remaining 46 % Used Account: 135-60020-020-000 Electricity 1203 04/22/2014 April A/P Electricity 3/12-4/11 48,641.88 9,414.58 58,056.46 HUDSON ENERGY SERVICES, LLC 33680 AP _______________ Account: 135-60020-020-000 Electricity Totals: 9,414.58 58,056.46 ** 138,227.00 Budgeted 80,170.54 Remaining 42 % Used Account: 135-60066-020-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 351.00 .00 351.00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 351.00 ** 400.00 Budgeted 49.00 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training 1133 04/04/2014 April A/P TWUA Water Utility Mgmt Manual 517.00 30.00 547.00 CITY OF FORT WORTH 33653 AP 1145 04/08/2014 Void ck33653/Incorrect address TWUA Water Utility Mgmt Manual (30.00) 517.00 CITY OF FORT WORTH 33653 AP 1146 04/08/2014 April A/P TWUA Water Utility Mgmt Manual 30.00 547.00 CITY OF FORT WORTH 33673 AP 1158 04/08/2014 Void A/P Ck 33673/City of FW TWUA Water Utility Mgmt Manual (30.00) 517.00 CITY OF FORT WORTH 33673 AP 1159 04/09/2014 April A/P TWUA Water Utility Mgmt Manual 30.00 547.00 Fort Worth Water Department 33674 AP 1312 04/28/2014 3/27/14-4/28/14 PCards ACT*TWUA - NCT REGION 540.00 1,087.00 ACT*TWUA - NCT REGION PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 570.00 1,087.00 ** 1,636.00 Budgeted 549.00 Remaining 66 % Used Account: 135-60090-020-000 Safety Program 432.07 .00 432.07 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 432.07 ** 500.00 Budgeted 67.93 Remaining 86 % Used Account: 135-60100-020-000 Travel & per diem 292.81 .00 292.81 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 292.81 ** 1,050.00 Budgeted 757.19 Remaining 28 % Used Account: 135-60105-020-000 Rent/Lease Equipment 299.53 .00 299.53 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 8,919.00 .00 8,919.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 8,919.00 ** 17,150.00 Budgeted 8,231.00 Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60243-020-000 Prior Year Expense 3,554.22 .00 3,554.22 _______________ Account: 135-60243-020-000 Prior Year Expense Totals: .00 3,554.22 ** 3,554.00 Budgeted (.22) Remaining 100 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1,079.10 .00 1,079.10 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,079.10 ** 1,079.00 Budgeted (.10) Remaining 100 % Used Account: 135-65005-020-000 Fuel & Lube 1299 04/30/2014 April Gas Log 5,322.90 1,011.45 6,334.35 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,011.45 6,334.35 ** 13,600.00 Budgeted 7,265.65 Remaining 47 % Used Account: 135-65010-020-000 Uniforms 1,437.27 .00 1,437.27 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,437.27 ** 1,752.00 Budgeted 314.73 Remaining 82 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1312 04/28/2014 3/27/14-4/28/14 PCards THE HOME DEPOT 6581 14,158.12 93.98 14,252.10 THE HOME DEPOT 6581 PC 1333 04/30/2014 April A/P Chemicals 2,240.00 16,492.10 HARCROS CHEMICALS INC 33732 AP 1333 04/30/2014 April A/P 2 55 gals polymer 1,080.00 17,572.10 POLYDYNE, INC 33753 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 3,413.98 17,572.10 ** 31,000.00 Budgeted 13,427.90 Remaining 57 % Used Account: 135-65035-020-000 Small Tools 91.00 .00 91.00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 91.00 ** 300.00 Budgeted 209.00 Remaining 30 % Used Account: 135-65040-020-000 Safety Equipment 230.63 .00 230.63 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 230.63 ** 500.00 Budgeted 269.37 Remaining 46 % Used Account: 135-65045-020-000 Lab Supplies 1312 04/28/2014 3/27/14-4/28/14 PCards WW GRAINGER 6,643.08 19.05 6,662.13 WW GRAINGER PC 1312 04/28/2014 3/27/14-4/28/14 PCards NSI SOLUTIONS INC 387.00 7,049.13 NSI SOLUTIONS INC PC 1333 04/30/2014 April A/P Credit for shipping charges Or (117.00) 6,932.13 HACH COMPANY 33731 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 289.05 6,932.13 ** 15,000.00 Budgeted 8,067.87 Remaining 46 % Used Account: 135-69008-020-000 Short Term Debt-Principal 20,020.00 .00 20,020.00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 20,020.00 ** 20,020.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 1,043.70 .00 1,043.70 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 1,043.70 ** 1,422.00 Budgeted 378.30 Remaining 73 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: ------------------------------------------------------------------------------------------------ 916,541.52 ** 1,564,486.00 Budgeted 647,944.48 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2014 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 1135 04/11/2014 MUD payroll 4/11/14 Salaries & Wages 33,175.64 3,434.64 36,610.28 PR 1194 04/25/2014 MUD Payroll 4/25/14 Salaries & Wages 3,434.65 40,044.93 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 6,869.29 40,044.93 ** 90,299.00 Budgeted 50,254.07 Remaining 44 % Used Account: 135-50010-021-000 Overtime 1135 04/11/2014 MUD payroll 4/11/14 Overtime 2,359.14 183.02 2,542.16 PR 1194 04/25/2014 MUD Payroll 4/25/14 Overtime 30.96 2,573.12 PR _______________ Account: 135-50010-021-000 Overtime Totals: 213.98 2,573.12 ** 10,028.00 Budgeted 7,454.88 Remaining 26 % Used Account: 135-50016-021-000 Longevity 2,107.50 .00 2,107.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 2,107.50 ** 2,108.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 1194 04/25/2014 MUD Payroll 4/25/14 Certification 900.00 150.00 1,050.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,050.00 ** 1,800.00 Budgeted 750.00 Remaining 58 % Used Account: 135-50020-021-000 Retirement 1135 04/11/2014 MUD payroll 4/11/14 Retirement 3,816.10 324.86 4,140.96 PR 1194 04/25/2014 MUD Payroll 4/25/14 Retirement 324.69 4,465.65 PR _______________ Account: 135-50020-021-000 Retirement Totals: 649.55 4,465.65 ** 9,025.00 Budgeted 4,559.35 Remaining 49 % Used Account: 135-50026-021-000 Medical Insurance 1135 04/11/2014 MUD payroll 4/11/14 Medical Insurance 9,673.89 736.86 10,410.75 PR 1194 04/25/2014 MUD Payroll 4/25/14 Medical Insurance 736.84 11,147.59 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,473.70 11,147.59 ** 23,668.00 Budgeted 12,520.41 Remaining 47 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2014 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 1135 04/11/2014 MUD payroll 4/11/14 Dental Insurance 710.19 51.30 761.49 PR 1194 04/25/2014 MUD Payroll 4/25/14 Dental Insurance 51.30 812.79 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 102.60 812.79 ** 1,703.00 Budgeted 890.21 Remaining 48 % Used Account: 135-50028-021-000 Vision Insurance 1135 04/11/2014 MUD payroll 4/11/14 Vision Insurance 146.89 11.84 158.73 PR 1194 04/25/2014 MUD Payroll 4/25/14 Vision Insurance 11.84 170.57 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.68 170.57 ** 314.00 Budgeted 143.43 Remaining 54 % Used Account: 135-50029-021-000 Life Insurance & Other 1093 04/01/2014 Apr A/P April Dental, Vol Life, ST Dis 539.49 71.54 611.03 METLIFE 33639 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 71.54 611.03 ** 1,066.00 Budgeted 454.97 Remaining 57 % Used Account: 135-50030-021-000 Social Security Taxes 1135 04/11/2014 MUD payroll 4/11/14 Social Security Taxes 2,378.88 204.90 2,583.78 PR 1194 04/25/2014 MUD Payroll 4/25/14 Social Security Taxes 201.80 2,785.58 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 406.70 2,785.58 ** 7,442.00 Budgeted 4,656.42 Remaining 37 % Used Account: 135-50035-021-000 Medicare Taxes 1135 04/11/2014 MUD payroll 4/11/14 Medicare Taxes 556.35 47.92 604.27 PR 1194 04/25/2014 MUD Payroll 4/25/14 Medicare Taxes 47.19 651.46 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 95.11 651.46 ** 1,741.00 Budgeted 1,089.54 Remaining 37 % Used Account: 135-50040-021-000 Unemployment Taxes 1135 04/11/2014 MUD payroll 4/11/14 Unemployment Taxes 303.15 35.02 338.17 PR 1194 04/25/2014 MUD Payroll 4/25/14 Unemployment Taxes 34.51 372.68 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2014 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: 69.53 372.68 ** 414.00 Budgeted 41.32 Remaining 90 % Used Account: 135-50045-021-000 Workman's Compensation 53 04/01/2014 Apr Ins & W/C Expense 1,605.24 267.54 1,872.78 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 1,872.78 ** 3,276.00 Budgeted 1,403.22 Remaining 57 % Used Account: 135-50070-021-000 Employee Relations 132.02 .00 132.02 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 132.02 ** 200.00 Budgeted 67.98 Remaining 66 % Used Account: 135-55080-021-000 Maintenance & Repairs 1312 04/28/2014 3/27/14-4/28/14 PCards WW GRAINGER 4,114.48 908.20 5,022.68 WW GRAINGER PC 1333 04/30/2014 April A/P Replace ring on #2 pump at LS 677.58 5,700.26 NORTH TEXAS PUMP CO. 33751 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 1,585.78 5,700.26 ** 14,451.00 Budgeted 8,750.74 Remaining 39 % Used Account: 135-55090-021-000 Vehicle Maintenance 999.18 .00 999.18 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 999.18 ** 2,000.00 Budgeted 1,000.82 Remaining 50 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 1143 04/08/2014 April A/P Symonds, Acclaim, Verizon 686.40 102.68 789.08 TOWN OF TROPHY CLUB 33670 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 102.68 789.08 ** 1,333.00 Budgeted 543.92 Remaining 59 % Used Account: 135-60020-021-000 Electricity 1203 04/22/2014 April A/P Electricity 3/3/14-4/1/14 10,039.63 328.19 10,367.82 TRI COUNTY ELECTRIC 33692 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1203 04/22/2014 April A/P Electricity 3/3/14-4/1/14 10,039.63 169.02 10,536.84 TRI COUNTY ELECTRIC 33692 AP 1203 04/22/2014 April A/P Electricity 3/3/14-4/1/14 28.27 10,565.11 TRI COUNTY ELECTRIC 33692 AP 1203 04/22/2014 April A/P Electricity 3/11-4/11 615.42 11,180.53 HUDSON ENERGY SERVICES, LLC 33680 AP 1203 04/22/2014 April A/P Electricity 3/12-4/11 765.77 11,946.30 HUDSON ENERGY SERVICES, LLC 33680 AP 1203 04/22/2014 April A/P Electricity 3/11-4/10 55.54 12,001.84 HUDSON ENERGY SERVICES, LLC 33680 AP 1203 04/22/2014 April A/P Electricity 3/11-4/10 30.37 12,032.21 HUDSON ENERGY SERVICES, LLC 33680 AP 1203 04/22/2014 April A/P Electricity 3/12-4/11 90.96 12,123.17 HUDSON ENERGY SERVICES, LLC 33680 AP 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (176.13) 11,947.04 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,907.41 11,947.04 ** 21,178.00 Budgeted 9,230.96 Remaining 56 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training .00 .00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 .00 ** 911.00 Budgeted 911.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program 1333 04/30/2014 April A/P first aid cabinet refill 35.34 35.34 CINTAS CORPORATION NO. 2 33717 AP _______________ Account: 135-60090-021-000 Safety Program Totals: 35.34 35.34 ** 300.00 Budgeted 264.66 Remaining 12 % Used Account: 135-60100-021-000 Travel & per diem 1312 04/28/2014 3/27/14-4/28/14 PCards WHICH WICH 0000 16.24 16.24 WHICH WICH 0000 PC 1312 04/28/2014 3/27/14-4/28/14 PCards SCHLOTZSKY'S 1807 11.36 27.60 SCHLOTZSKY'S 1807 PC 1312 04/28/2014 3/27/14-4/28/14 PCards HILTON COUNTER OFFER 10.89 38.49 HILTON COUNTER OFFER PC _______________ Account: 135-60100-021-000 Travel & per diem Totals: 38.49 38.49 ** 250.00 Budgeted 211.51 Remaining 15 % Used Account: 135-60105-021-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2014 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-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 1299 04/30/2014 April Gas Log 5,890.25 1,140.78 7,031.03 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,140.78 7,031.03 ** 21,747.00 Budgeted 14,715.97 Remaining 32 % Used Account: 135-65010-021-000 Uniforms 814.23 .00 814.23 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 814.23 ** 1,040.00 Budgeted 225.77 Remaining 78 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools 43.99 .00 43.99 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 43.99 ** 300.00 Budgeted 256.01 Remaining 15 % Used Account: 135-65040-021-000 Safety Equipment 586.73 .00 586.73 . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 586.73 ** 750.00 Budgeted 163.27 Remaining 78 % Used Account: 135-69005-021-000 Capital Outlays 68,300.20 .00 68,300.20 _______________ Account: 135-69005-021-000 Capital Outlays Totals: .00 68,300.20 ** 114,000.00 Budgeted 45,699.80 Remaining 60 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 35,991.00 Budgeted 35,991.00 Remaining 0 % Used Account: 135-69009-021-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-021-000 Short Term Debt-Interest Totals: .00 .00 ** 2,846.00 Budgeted 2,846.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 165,083.27 ** 377,531.00 Budgeted 212,447.73 Remaining 44 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2014 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 1194 04/25/2014 MUD Payroll 4/25/14 Salaries & Wages 5,200.00 400.00 5,600.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 400.00 5,600.00 ** 10,000.00 Budgeted 4,400.00 Remaining 56 % Used Account: 135-50030-026-000 Social Security Taxes 1194 04/25/2014 MUD Payroll 4/25/14 Social Security Taxes 322.40 24.80 347.20 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 24.80 347.20 ** 620.00 Budgeted 272.80 Remaining 56 % Used Account: 135-50035-026-000 Medicare Taxes 1194 04/25/2014 MUD Payroll 4/25/14 Medicare Taxes 75.40 5.80 81.20 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 5.80 81.20 ** 145.00 Budgeted 63.80 Remaining 56 % Used Account: 135-50040-026-000 Unemployment Taxes 1194 04/25/2014 MUD Payroll 4/25/14 Unemployment Taxes 64.60 9.20 73.80 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 9.20 73.80 ** 230.00 Budgeted 156.20 Remaining 32 % Used Account: 135-50045-026-000 Workman's Compensation 53 04/01/2014 Apr Ins & W/C Expense 17.70 2.95 20.65 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.95 20.65 ** 36.00 Budgeted 15.35 Remaining 57 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 35.95 .00 35.95 _______________ Account: 135-60075-026-000 Meetings Totals: .00 35.95 ** 1,200.00 Budgeted 1,164.05 Remaining 3 % Used Account: 135-60080-026-000 Schools & Training 265.00 .00 265.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 265.00 ** 4,000.00 Budgeted 3,735.00 Remaining 7 % Used Account: 135-60100-026-000 Travel & per diem 1203 04/22/2014 April A/P Meeting/Rep Callegari, Moss an 41.66 41.66 KEVIN CARR 33683 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 41.66 41.66 ** 5,000.00 Budgeted 4,958.34 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 6,500.46 ** 22,881.00 Budgeted 16,380.54 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 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 1135 04/11/2014 MUD payroll 4/11/14 Salaries & Wages 213,533.71 17,540.05 231,073.76 PR 1194 04/25/2014 MUD Payroll 4/25/14 Salaries & Wages 17,543.44 248,617.20 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,083.49 248,617.20 ** 458,721.00 Budgeted 210,103.80 Remaining 54 % Used Account: 135-50010-030-000 Overtime 1135 04/11/2014 MUD payroll 4/11/14 Overtime 567.53 8.57 576.10 PR 1194 04/25/2014 MUD Payroll 4/25/14 Overtime 11.92 588.02 PR _______________ Account: 135-50010-030-000 Overtime Totals: 20.49 588.02 ** 750.00 Budgeted 161.98 Remaining 78 % Used Account: 135-50016-030-000 Longevity 3,077.50 .00 3,077.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,077.50 ** 3,018.00 Budgeted (59.50) Remaining 102 % Used Account: 135-50020-030-000 Retirement 1135 04/11/2014 MUD payroll 4/11/14 Retirement 20,475.38 1,575.87 22,051.25 PR 1194 04/25/2014 MUD Payroll 4/25/14 Retirement 1,576.48 23,627.73 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,152.35 23,627.73 ** 41,419.00 Budgeted 17,791.27 Remaining 57 % Used Account: 135-50026-030-000 Medical Insurance 1135 04/11/2014 MUD payroll 4/11/14 Medical Insurance 27,745.66 2,402.43 30,148.09 PR 1194 04/25/2014 MUD Payroll 4/25/14 Medical Insurance 2,402.38 32,550.47 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,804.81 32,550.47 ** 57,923.00 Budgeted 25,372.53 Remaining 56 % Used Account: 135-50027-030-000 Dental Insurance 1135 04/11/2014 MUD payroll 4/11/14 Dental Insurance 2,180.28 170.19 2,350.47 PR 1194 04/25/2014 MUD Payroll 4/25/14 Dental Insurance 170.23 2,520.70 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 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: 340.42 2,520.70 ** 5,100.00 Budgeted 2,579.30 Remaining 49 % Used Account: 135-50028-030-000 Vision Insurance 1135 04/11/2014 MUD payroll 4/11/14 Vision Insurance 492.45 40.78 533.23 PR 1194 04/25/2014 MUD Payroll 4/25/14 Vision Insurance 40.84 574.07 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.62 574.07 ** 1,087.00 Budgeted 512.93 Remaining 53 % Used Account: 135-50029-030-000 Life Insurance & Other 1093 04/01/2014 Apr A/P April Dental, Vol Life, ST Dis 2,538.68 310.23 2,848.91 METLIFE 33639 AP 1203 04/22/2014 April A/P Flex Adm 38.16 2,887.07 BenefitMall 33676 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 348.39 2,887.07 ** 5,500.00 Budgeted 2,612.93 Remaining 52 % Used Account: 135-50030-030-000 Social Security Taxes 1135 04/11/2014 MUD payroll 4/11/14 Social Security Taxes 13,395.05 1,038.55 14,433.60 PR 1194 04/25/2014 MUD Payroll 4/25/14 Social Security Taxes 1,015.55 15,449.15 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,054.10 15,449.15 ** 28,659.00 Budgeted 13,209.85 Remaining 54 % Used Account: 135-50035-030-000 Medicare Taxes 1135 04/11/2014 MUD payroll 4/11/14 Medicare Taxes 3,132.73 242.88 3,375.61 PR 1194 04/25/2014 MUD Payroll 4/25/14 Medicare Taxes 237.50 3,613.11 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 480.38 3,613.11 ** 6,702.00 Budgeted 3,088.89 Remaining 54 % Used Account: 135-50040-030-000 Unemployment Taxes 1,449.00 .00 1,449.00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 1,449.00 ** 1,449.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 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 53 04/01/2014 Apr Ins & W/C Expense 771.78 128.63 900.41 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.63 900.41 ** 1,575.00 Budgeted 674.59 Remaining 57 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 1312 04/28/2014 3/27/14-4/28/14 PCards RANDALLS STORE00017897 2,662.55 6.38 2,668.93 RANDALLS STORE00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 6.38 2,668.93 ** 5,000.00 Budgeted 2,331.07 Remaining 53 % Used Account: 135-55030-030-000 Software & Support 1143 04/08/2014 April A/P Symonds, Acclaim, Verizon 21,023.82 312.50 21,336.32 TOWN OF TROPHY CLUB 33670 AP 1203 04/22/2014 April A/P AE Annual Maint, Charter 645.50 21,981.82 TOWN OF TROPHY CLUB 33691 AP 1203 04/22/2014 April A/P AE Annual Maint, Charter 1,537.00 23,518.82 TOWN OF TROPHY CLUB 33691 AP 1312 04/28/2014 3/27/14-4/28/14 PCards GOOGLE *WARELEX LLC 4.99 23,523.81 GOOGLE *WARELEX LLC PC 1333 04/30/2014 April A/P Bank Rec annual software renew 600.00 24,123.81 CONWAY CONSULTING 33719 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 3,099.99 24,123.81 ** 59,698.00 Budgeted 35,574.19 Remaining 40 % Used Account: 135-55070-030-000 Independent Labor 1228 04/29/2014 April A/P Record MUD meeting 4,923.48 78.25 5,001.73 MIGUEL CRUZ 33704 AP 1228 04/29/2014 April A/P Shi, Natl Telesystems, D Hall, 33.75 5,035.48 TOWN OF TROPHY CLUB 33709 AP 1228 04/29/2014 April A/P Water/Sewer Rate Study 760.00 5,795.48 NEW GEN STRATEGIES & SOLUTIONS 33705 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 872.00 5,795.48 ** 7,000.00 Budgeted 1,204.52 Remaining 83 % Used Account: 135-55080-030-000 Maintenance & Repairs 1312 04/28/2014 3/27/14-4/28/14 PCards THE HOME DEPOT 6581 12.94 53.45 66.39 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1312 04/28/2014 3/27/14-4/28/14 PCards J & N SUPPLY 12.94 724.12 790.51 J & N SUPPLY PC 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (362.06) 428.45 AR _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 415.51 428.45 ** 4,500.00 Budgeted 4,071.55 Remaining 10 % Used Account: 135-55100-030-000 Building Maint & Supplies 1228 04/29/2014 April A/P Rug Service/MUD & PS Bldg 1,930.43 94.42 2,024.85 G & K SERVICES 33698 AP 1228 04/29/2014 April A/P Rug Service/MUD & PS Bldg 94.42 2,119.27 G & K SERVICES 33698 AP 1228 04/29/2014 April A/P Rug Service/MUD & PS Bldg 94.42 2,213.69 G & K SERVICES 33698 AP 1228 04/29/2014 April A/P Rug Service/MUD & PS Bldg 94.42 2,308.11 G & K SERVICES 33698 AP 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (188.84) 2,119.27 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 188.84 2,119.27 ** 6,500.00 Budgeted 4,380.73 Remaining 33 % Used Account: 135-55120-030-000 Cleaning Services 9,569.82 .00 9,569.82 _______________ Account: 135-55120-030-000 Cleaning Services Totals: .00 9,569.82 ** 19,140.00 Budgeted 9,570.18 Remaining 50 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55161-030-000 Town Personnel Contract 77,048.00 .00 77,048.00 _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 77,048.00 ** 77,048.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55205-030-000 Utility Billing Contract 1333 04/30/2014 April A/P April Utility Billing 2,900.07 567.20 3,467.27 DATAPROSE LLC 33722 AP 1339 04/30/2014 April A/P March Water billing 1,430.12 4,897.39 DATAPROSE LLC 33775 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,997.32 4,897.39 ** 6,808.00 Budgeted 1,910.61 Remaining 72 % Used Account: 135-60005-030-000 Telephone 1228 04/29/2014 April A/P Shi, Natl Telesystems, D Hall, 6,207.25 119.25 6,326.50 TOWN OF TROPHY CLUB 33709 AP 1228 04/29/2014 April A/P Answering Service 180.00 6,506.50 KEYSTONE PARK SECRETARIAL 33700 AP _______________ Account: 135-60005-030-000 Telephone Totals: 299.25 6,506.50 ** 11,250.00 Budgeted 4,743.50 Remaining 58 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1143 04/08/2014 April A/P Symonds, Acclaim, Verizon 1,493.59 140.67 1,634.26 TOWN OF TROPHY CLUB 33670 AP 1194 04/25/2014 MUD Payroll 4/25/14 Communications/Pagers/Mobiles 300.00 1,934.26 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 440.67 1,934.26 ** 4,057.00 Budgeted 2,122.74 Remaining 48 % Used Account: 135-60020-030-000 Electricity/Gas 6,319.18 .00 6,319.18 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 6,319.18 ** 15,171.00 Budgeted 8,851.82 Remaining 42 % Used Account: 135-60025-030-000 Water 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: 430.16 (97.86) 332.30 AR 1333 04/30/2014 April A/P April Water 195.72 528.02 TROPHY CLUB MUD (WATER BILLS) 33770 AP _______________ Account: 135-60025-030-000 Water Totals: 97.86 528.02 ** 1,500.00 Budgeted 971.98 Remaining 35 % Used Account: 135-60035-030-000 Postage 1137 04/07/2014 April A/P Postcards Stage 1 reminder 11,004.03 945.62 11,949.65 U.S. POSTAL SERVICE 33651 AP 1143 04/08/2014 April A/P Overnight letter 7.16 11,956.81 FEDERAL EXPRESS CORP 33655 AP 1289 04/30/2014 April Postage Meter usage 104.67 12,061.48 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1333 04/30/2014 April A/P Overnight letters 11,004.03 15.27 12,076.75 FEDERAL EXPRESS CORP 33726 AP 1333 04/30/2014 April A/P April Utility Billing 1,667.40 13,744.15 DATAPROSE LLC 33722 AP 1339 04/30/2014 April A/P March Water billing 1,702.58 15,446.73 DATAPROSE LLC 33775 AP _______________ Account: 135-60035-030-000 Postage Totals: 4,442.70 15,446.73 ** 28,500.00 Budgeted 13,053.27 Remaining 54 % Used Account: 135-60040-030-000 Service Charges & Fees 1300 04/02/2014 April Credit Card fees 14,666.48 100.10 14,766.58 GL 1300 04/02/2014 April Credit Card fees 45.30 14,811.88 GL 1300 04/02/2014 April Credit Card fees 2,197.39 17,009.27 GL 1303 04/17/2014 March Account analysis FF Bank 250.00 17,259.27 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,592.79 17,259.27 ** 28,330.00 Budgeted 11,070.73 Remaining 61 % Used Account: 135-60050-030-000 Bad Debt Expense 1111 04/01/2014 UB 04/01/2014 Credit Card Pmts UB20140401-20140401 User: 4,197.27 (43.87) 4,153.40 CR _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: (43.87) 4,153.40 ** 6,200.00 Budgeted 2,046.60 Remaining 67 % Used Account: 135-60055-030-000 Insurance 53 04/01/2014 Apr Ins & W/C Expense 25,746.63 4,269.73 30,016.36 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,269.73 30,016.36 ** 53,561.00 Budgeted 23,544.64 Remaining 56 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 401.08 .00 401.08 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 401.08 ** 1,000.00 Budgeted 598.92 Remaining 40 % Used Account: 135-60070-030-000 Dues & Memberships 4,011.95 .00 4,011.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,011.95 ** 4,500.00 Budgeted 488.05 Remaining 89 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education 274.83 .00 274.83 _______________ Account: 135-60079-030-000 Public Education Totals: .00 274.83 ** 5,000.00 Budgeted 4,725.17 Remaining 5 % Used Account: 135-60080-030-000 Schools & Training 1312 04/28/2014 3/27/14-4/28/14 PCards TSBPA IND LIC RENE 1,651.30 251.00 1,902.30 TSBPA IND LIC RENE PC 1312 04/28/2014 3/27/14-4/28/14 PCards WEBUCATOR 690.00 2,592.30 WEBUCATOR PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 941.00 2,592.30 ** 6,800.00 Budgeted 4,207.70 Remaining 38 % Used Account: 135-60100-030-000 Travel & per diem 1135 04/11/2014 MUD payroll 4/11/14 Travel & per diem 822.42 8.96 831.38 PR 1312 04/28/2014 3/27/14-4/28/14 PCards HILTON 9.74 841.12 HILTON PC 1312 04/28/2014 3/27/14-4/28/14 PCards HILTON 252.34 1,093.46 HILTON PC 1228 04/29/2014 April A/P Conf/Local Govt HR Professiona 294.90 1,388.36 Terri Sisk 33708 AP 1228 04/29/2014 April A/P Mileage/Copier Demo 20.72 1,409.08 Terri Sisk 33708 AP 1333 04/30/2014 April A/P Mileage/STW UB Roundtable 29.68 1,438.76 NICOLE D'ANDRIA 33750 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 616.34 1,438.76 ** 5,000.00 Budgeted 3,561.24 Remaining 29 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 1312 04/28/2014 3/27/14-4/28/14 PCards TRANSLATORS 281.76 281.76 TRANSLATORS PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60115-030-000 Elections Totals: 281.76 281.76 ** 2,500.00 Budgeted 2,218.24 Remaining 11 % Used Account: 135-60125-030-000 Advertising 589.43 .00 589.43 _______________ Account: 135-60125-030-000 Advertising Totals: .00 589.43 ** 2,500.00 Budgeted 1,910.57 Remaining 24 % Used Account: 135-60235-030-000 Security 123.56 .00 123.56 _______________ Account: 135-60235-030-000 Security Totals: .00 123.56 ** 1,350.00 Budgeted 1,226.44 Remaining 9 % Used Account: 135-60245-030-000 Miscellaneous Expenses 376.25 .00 376.25 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 376.25 ** 17,870.00 Budgeted 17,493.75 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-60360-030-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms 998.90 .00 998.90 . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-030-000 Uniforms Totals: .00 998.90 ** 1,390.00 Budgeted 391.10 Remaining 72 % Used Account: 135-65055-030-000 Hardware 2,178.04 .00 2,178.04 _______________ Account: 135-65055-030-000 Hardware Totals: .00 2,178.04 ** 13,562.00 Budgeted 11,383.96 Remaining 16 % Used Account: 135-65085-030-000 Office Supplies 1143 04/08/2014 April A/P Office Supplies 2,367.74 28.99 2,396.73 OFFICE DEPOT, INC 33663 AP 1203 04/22/2014 April A/P 124.35 2,521.08 TOWN OF TROPHY CLUB 33691 AP 1203 04/22/2014 April A/P Office Supplies 49.11 2,570.19 OFFICE DEPOT, INC 33687 AP 1203 04/22/2014 April A/P Office Supplies 5.19 2,575.38 OFFICE DEPOT, INC 33687 AP 1203 04/22/2014 April A/P Office Supplies 81.05 2,656.43 OFFICE DEPOT, INC 33687 AP 1312 04/28/2014 3/27/14-4/28/14 PCards STAPLES 00116533 9.98 2,666.41 STAPLES 00116533 PC 1228 04/29/2014 April A/P Office Supplies 38.32 2,704.73 OFFICE DEPOT, INC 33706 AP 1228 04/29/2014 April A/P Office Supplies 12.86 2,717.59 OFFICE DEPOT, INC 33706 AP 1317 04/30/2014 Bill Town Inv 1159-1169 AR 20140430-20140430 User: (43.98) 2,673.61 AR 1333 04/30/2014 April A/P Copier paper 99.48 2,773.09 TOWN OF TROPHY CLUB 33769 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 405.35 2,773.09 ** 9,100.00 Budgeted 6,326.91 Remaining 30 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1228 04/29/2014 April A/P Shi, Natl Telesystems, D Hall, 1,473.75 78.00 1,551.75 TOWN OF TROPHY CLUB 33709 AP 1228 04/29/2014 April A/P Shi, Natl Telesystems, D Hall, 91.00 1,642.75 TOWN OF TROPHY CLUB 33709 AP 1333 04/30/2014 April A/P Shi-Printer Supplies 760.72 2,403.47 TOWN OF TROPHY CLUB 33769 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 929.72 2,403.47 ** 5,732.00 Budgeted 3,328.53 Remaining 42 % Used Account: 135-65095-030-000 Maintenance Supplies 1312 04/28/2014 3/27/14-4/28/14 PCards SAMSCLUB #4795 1,469.39 109.00 1,578.39 SAMSCLUB #4795 PC 1333 04/30/2014 April A/P Gloves 39.98 1,618.37 COSTCO WHOLESALE 33720 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 148.98 1,618.37 ** 2,500.00 Budgeted 881.63 Remaining 65 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65097-030-000 Vending Machine Supplies 76.96 .00 76.96 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 76.96 ** 200.00 Budgeted 123.04 Remaining 38 % Used Account: 135-65105-030-000 Printing 2,348.27 .00 2,348.27 _______________ Account: 135-65105-030-000 Printing Totals: .00 2,348.27 ** 4,000.00 Budgeted 1,651.73 Remaining 59 % Used Account: 135-69170-030-000 Copier Lease Installments 1228 04/29/2014 April A/P Shi, Natl Telesystems, D Hall, 1,284.25 128.43 1,412.68 TOWN OF TROPHY CLUB 33709 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 128.43 1,412.68 ** 3,450.00 Budgeted 2,037.32 Remaining 41 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 568,569.00 ** 1,056,620.00 Budgeted 488,051.00 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2014 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 1143 04/08/2014 April A/P Legal 114,582.30 14,014.79 128,597.09 FREEMAN & CORBETT 33656 AP 1228 04/29/2014 April A/P March legal 2,422.00 131,019.09 WHITAKER CHALK SWINDLE 33710 AP 1228 04/29/2014 April A/P March legal 1,528.80 132,547.89 WHITAKER CHALK SWINDLE 33710 AP 1228 04/29/2014 April A/P March legal 235.20 132,783.09 WHITAKER CHALK SWINDLE 33710 AP 1228 04/29/2014 April A/P March legal 1,932.00 134,715.09 WHITAKER CHALK SWINDLE 33710 AP 1228 04/29/2014 April A/P March legal 258.30 134,973.39 WHITAKER CHALK SWINDLE 33710 AP 1333 04/30/2014 April A/P Legal/March 3,465.00 138,438.39 THE LISTON LAW FIRM, P.C. 33767 AP _______________ Account: 135-55045-039-000 Legal Totals: 23,856.09 138,438.39 ** 347,126.00 Budgeted 208,687.61 Remaining 40 % Used Account: 135-55055-039-000 Auditing 21,200.00 .00 21,200.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 21,200.00 ** 21,840.00 Budgeted 640.00 Remaining 97 % Used Account: 135-55060-039-000 Appraisal 6,243.84 .00 6,243.84 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,243.84 ** 10,000.00 Budgeted 3,756.16 Remaining 62 % Used Account: 135-55065-039-000 Tax Admin Fees 2,451.40 .00 2,451.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,451.40 ** 3,800.00 Budgeted 1,348.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 168,333.63 ** 382,766.00 Budgeted 214,432.37 Remaining 44 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 468,979.63 1,770,974.00 Budgeted 1,301,994.37 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 1298 04/30/2014 Bank Statement Interest/April (50.84) (4.57) (55.41) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (4.57) (55.41) ** .00 Budgeted 55.41 Remaining 0 % Used Account: 507-49036-000-000 GASB Reserves 1270 04/30/2014 Xfer GASB to Cap Proj/Ind Crk Indian Creek Project (120,000.00) (120,000.00) GL _______________ Account: 507-49036-000-000 GASB Reserves Totals: (120,000.00) (120,000.00) ** .00 Budgeted 120,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (120,055.41) ** .00 Budgeted 120,055.41 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 4/2014 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-002 Capital Repairs/ROFC FW Meter 82,629.40 .00 82,629.40 _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: .00 82,629.40 ** .00 Budgeted (82,629.40) Remaining 0 % Used Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 1333 04/30/2014 April A/P Design Meadowbrook Waterline r 3,072.00 3,072.00 TEAGUE, NALL & PERKINS,INC 33766 AP _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: 3,072.00 3,072.00 ** 282,245.17 Budgeted 279,173.17 Remaining 1 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 85,701.40 ** 282,245.17 Budgeted 196,543.77 Remaining 30 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ (34,354.01) 282,245.17 Budgeted 316,599.18 Remaining -12 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET APRIL 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 507,482 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 15,140 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 527,469 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 15,140 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 15,140 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 494,449 TOTAL FUND BALANCE 512,328 TOTAL LIABILITIES AND FUND BALANCE 527,469 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 15:13 05/12/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 389,216.00- 389,216.00- 1,953.55- 382,035.47- 98.155 7,180.53- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 307.36- 433.09- 17.324 2,066.91- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 376.82- 1,820.72- 113.795 220.72 Subtotal: 393,316.00- 393,316.00- 2,637.73- 384,289.28- 97.705 9,026.72- 533-48005-000-000 Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- Subtotal: 16,525.00- 16,525.00- 16,525.00- 533-49010-000-000 Interest Income 375.00- 375.00- 14.00- 47.41- 12.643 327.59- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- 100.000 Subtotal: 214,654.00- 214,654.00- 14.00- 214,326.41- 99.847 327.59- Program number: 624,495.00- 624,495.00- 2,651.73- 598,615.69- 95.856 25,879.31- Department number: Revenues 624,495.00- 624,495.00- 2,651.73- 598,615.69- 95.856 25,879.31- Revenues Subtotal ----------- 624,495.00- 624,495.00- 2,651.73- 598,615.69- 95.856 25,879.31- . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 15:13 05/12/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 1,000.00 1,000.00 43.478 1,300.00 533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 103,166.25 52.317 94,028.75 533-70035-051-000 Bond Principal Payment 425,000.00 425,000.00 425,000.00 Subtotal: 624,495.00 624,495.00 1,000.00 104,166.25 16.680 520,328.75 Program number: 624,495.00 624,495.00 1,000.00 104,166.25 16.680 520,328.75 Department number: Administration 624,495.00 624,495.00 1,000.00 104,166.25 16.680 520,328.75 Expenditures Subtotal ----------- 624,495.00 624,495.00 1,000.00 104,166.25 16.680 520,328.75 Fund number: 533 MUD 1 I&S Consolidated 1,651.73- 494,449.44- 494,449.44 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2014 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 1222 04/01/2014 Property Taxes/Assessments (380,081.92) (211.24) (380,293.16) GL 1225 04/02/2014 Property Taxes/Assessments (92.33) (380,385.49) GL 1226 04/03/2014 Property Taxes / Assessments (147.31) (380,532.80) GL 1227 04/04/2014 Property Taxes/Assessments (225.14) (380,757.94) GL 1234 04/07/2014 Property Taxes/Assessments (22.05) (380,779.99) GL 1235 04/08/2014 Property Taxes/Assessments (17.81) (380,797.80) GL 1236 04/09/2014 Property Taxes/Assessments (41.41) (380,839.21) GL 1237 04/11/2014 Property Taxes/Assessments (90.43) (380,929.64) GL 1238 04/14/2014 Property Taxes/Assessments 6.75 (380,922.89) GL 1239 04/15/2014 Property Taxes/Assessments 4.13 (380,918.76) GL 1240 04/16/2014 Property Taxes/Assessments (25.89) (380,944.65) GL 1241 04/21/2014 Property Taxes/Assessments (82.14) (381,026.79) GL 1242 04/22/2014 Property Taxes/Assessments (11.15) (381,037.94) GL 1243 04/23/2014 Property Taxes/Assessments (325.91) (381,363.85) GL 1288 04/28/2014 Property Taxes/Assessments (17.05) (381,380.90) GL 1290 04/29/2014 Property Taxes/Assessments (272.22) (381,653.12) GL 1291 04/30/2014 Property Taxes/Assessments (382.35) (382,035.47) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,953.55) (382,035.47) ** (389,216.00) Budgeted (7,180.53) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1226 04/03/2014 Property Taxes / Assessments (125.73) (293.24) (418.97) GL 1290 04/29/2014 Property Taxes/Assessments (13.56) (432.53) GL 1291 04/30/2014 Property Taxes/Assessments (.56) (433.09) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (307.36) (433.09) ** (2,500.00) Budgeted (2,066.91) Remaining 17 % Used Account: 533-40015-000-000 Property Taxes/P & I 1222 04/01/2014 Property Taxes/Assessments (1,443.90) (12.11) (1,456.01) GL 1225 04/02/2014 Property Taxes/Assessments (8.31) (1,464.32) GL 1226 04/03/2014 Property Taxes / Assessments (208.49) (1,672.81) GL 1227 04/04/2014 Property Taxes/Assessments (20.26) (1,693.07) GL 1234 04/07/2014 Property Taxes/Assessments (.64) (1,693.71) GL 1236 04/09/2014 Property Taxes/Assessments (4.55) (1,698.26) GL 1237 04/11/2014 Property Taxes/Assessments (9.94) (1,708.20) GL 1238 04/14/2014 Property Taxes/Assessments (.27) (1,708.47) GL 1240 04/16/2014 Property Taxes/Assessments (2.84) (1,711.31) GL 1241 04/21/2014 Property Taxes/Assessments (9.03) (1,720.34) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1242 04/22/2014 Property Taxes/Assessments (1,443.90) (1.22) (1,721.56) GL 1243 04/23/2014 Property Taxes/Assessments (35.85) (1,757.41) GL 1288 04/28/2014 Property Taxes/Assessments 10.42 (1,746.99) GL 1290 04/29/2014 Property Taxes/Assessments (33.61) (1,780.60) GL 1291 04/30/2014 Property Taxes/Assessments (40.12) (1,820.72) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (376.82) (1,820.72) ** (1,600.00) Budgeted 220.72 Remaining 114 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (16,525.00) Budgeted (16,525.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 1298 04/30/2014 Bank Statement Interest/April (33.41) (14.00) (47.41) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (14.00) (47.41) ** (375.00) Budgeted (327.59) Remaining 13 % Used Account: 533-49015-000-000 Lease/Rental Income (214,279.00) .00 (214,279.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,279.00) ** (214,279.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (598,615.69) ** (624,495.00) Budgeted (25,879.31) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 15:13 05/12/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2014 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/Bond Issuance 1208 04/03/2014 Bond Adm Fees Unl Tax Bonds Series 2010 500.00 500.00 GL 1208 04/03/2014 Bond Adm Fees Unl Tax Ref Bonds, Series 2012 500.00 1,000.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: 1,000.00 1,000.00 ** 2,300.00 Budgeted 1,300.00 Remaining 43 % Used Account: 533-70025-051-000 Bond Interest Expense 103,166.25 .00 103,166.25 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 103,166.25 ** 197,195.00 Budgeted 94,028.75 Remaining 52 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 425,000.00 Budgeted 425,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 104,166.25 ** 624,495.00 Budgeted 520,328.75 Remaining 17 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (494,449.44) .00 Budgeted 494,449.44 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (501,151.95) **** 2,053,219.17 Budgeted 2,554,371.12 Remaining -24 % Used ******* End of Report *********