Loading...
HomeMy WebLinkAboutFeb Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET FEBRUARY 28, 2014 122 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 1,179,833 PREPAID EXPENSES 11,704 ADVALOREM PROPERTY TAXES RECEIVABLE 63,113 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 6,121 UTILITY AND OTHER ACCOUNTS RECEIVABLE 938 TOTAL ASSETS 1,261,710 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 69,234 ACCOUNTS AND OTHER PAYABLES 52,443 TOTAL LIABILITIES 121,677 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE 2,141 UNASSIGNED FUND BALANCE 493,547 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 644,344 TOTAL FUND BALANCE 1,140,033 TOTAL LIABILITIES AND FUND BALANCE 1,261,710 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 11:19 03/07/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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- 15,727.63- 302,755.53- 99.119 2,689.47- 122-40003-000-000 Emer Svcs Assessmen/Delinquent .65- .65 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 85,396.09- 878,978.92- 94.763 48,576.08- 122-40011-000-000 Property Taxes/Fire-Delinquent 404.83- 397.34- 397.34 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 65.93- 66.08- 8.811 683.92- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 1,484.14- 1,597.85- 35.508 2,902.15- Subtotal: 1,238,250.00- 1,238,250.00- 103,078.62- 1,183,796.37- 95.602 54,453.63- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 2,000.00- 33.333 4,000.00- Subtotal: 6,000.00- 6,000.00- 2,000.00- 33.333 4,000.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 375.00- 53.571 325.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- 375.00- 3.505 10,325.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 3,425.00- 57.083 2,575.00- Subtotal: 6,000.00- 6,000.00- 3,425.00- 57.083 2,575.00- Program number: 1,260,950.00- 1,260,950.00- 103,078.62- 1,189,596.37- 94.341 71,353.63- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 103,078.62- 1,189,596.37- 94.341 71,353.63- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 103,078.62- 1,189,596.37- 94.341 71,353.63- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 11:19 03/07/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 33,967.28 184,918.09 40.560 270,997.91 122-50010-045-000 Overtime 44,225.00 44,225.00 2,687.71 14,087.02 31.853 30,137.98 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 1,839.39 42.285 2,510.61 122-50020-045-000 Retirement 70,991.00 70,991.00 5,397.69 30,737.94 43.298 40,253.06 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,158.33 20,192.85 35.446 36,775.15 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 339.82 1,644.85 38.885 2,585.15 122-50028-045-000 Vision Insurance 892.00 892.00 72.68 346.25 38.817 545.75 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 301.09 1,528.73 35.970 2,721.27 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 2,095.47 12,618.85 38.262 20,361.15 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 489.98 2,950.41 38.252 4,762.59 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 14.81 67.71 2.997 2,191.29 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.79 3,313.95 38.056 5,394.05 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 205.72 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 50,768.37 292,396.62 41.016 420,482.38 122-55030-045-000 Software & Support 8,682.00 8,682.00 8,682.00 122-55045-045-000 Legal 5,000.00 5,000.00 2,505.51- -50.110 7,505.51 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 1,203.57 4,414.82 21.565 16,057.18 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 980.61 2,580.34 17.376 12,269.66 Subtotal: 49,004.00 49,004.00 2,184.18 4,489.65 9.162 44,514.35 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.54 1,173.75 27.702 3,063.25 122-60020-045-000 Electricity/Gas 6,568.00 6,568.00 660.71 2,887.30 43.960 3,680.70 122-60025-045-000 Water 1,500.00 1,500.00 106.12 354.63 23.642 1,145.37 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 214,279.00 100.000 122-60035-045-000 Postage 100.00 100.00 6.11 26.53 26.530 73.47 122-60055-045-000 Insurance 12,110.00 12,110.00 1,051.25 5,088.25 42.017 7,021.75 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 305.00 8,197.64 54.003 6,982.36 122-60080-045-000 Schools & Training 4,280.00 4,280.00 422.00 2,046.00 47.804 2,234.00 122-60096-045-000 Emergency Management 2,000.00 2,000.00 1,000.00 50.000 1,000.00 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 690.41 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 200.00 200.00 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 341.17 7.582 4,158.83 122-60180-045-000 Fire Inspection/Enforcement 1,500.00 1,500.00 1,500.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 37.50 170.25 8.513 1,829.75 122-60243-045-000 Prior Year Expense 3,456.54 3,456.54- . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 11:19 03/07/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 861.00 1,220.97 122.097 220.97- Subtotal: 276,531.00 276,531.00 218,633.64 242,170.13 87.574 34,360.87 122-65005-045-000 Fuel & Lube 11,698.00 11,698.00 444.39 3,169.34 27.093 8,528.66 122-65010-045-000 Uniforms 3,360.00 3,360.00 171.90- 319.84 9.519 3,040.16 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 718.87 848.87 11.169 6,751.13 122-65030-045-000 Chemicals 1,000.00 1,000.00 1,000.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 69.98 146.44 5.858 2,353.56 122-65085-045-000 Office Supplies 1,000.00 1,000.00 84.44 8.444 915.56 122-65095-045-000 Maintenance Supplies 111.16 111.16- 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 27,258.00 1,061.34 4,680.09 17.170 22,577.91 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 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 1,515.50 .776 193,762.50 Program number: 1,260,950.00 1,260,950.00 274,163.03 545,251.99 43.241 715,698.01 Department number: Fire 1,260,950.00 1,260,950.00 274,163.03 545,251.99 43.241 715,698.01 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 274,163.03 545,251.99 43.241 715,698.01 Fund number: 122 Trophy Club MUD Fire Dept. 171,084.41 644,344.38- 644,344.38 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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 886 02/01/2014 Property Taxes/Assessments (287,027.90) (2,944.65) (289,972.55) GL 887 02/03/2014 Property Taxes/Assessments (2,381.60) (292,354.15) GL 888 02/04/2014 Property Taxes/Assessments (3,147.67) (295,501.82) GL 889 02/05/2014 Property Taxes/Assessments (4,045.16) (299,546.98) GL 890 02/06/2014 Property Taxes/Assessments (1,310.16) (300,857.14) GL 891 02/07/2014 Property Taxes/Assessments (1,380.43) (302,237.57) GL 893 02/12/2014 Property Taxes/Assessments (44.47) (302,282.04) GL 894 02/13/2014 Property Taxes/Assessments (32.88) (302,314.92) GL 897 02/20/2014 Property Taxes/Assessments (431.64) (302,746.56) GL 898 02/24/2014 Property Taxes/Assessments (8.97) (302,755.53) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (15,727.63) (302,755.53) ** (305,445.00) Budgeted (2,689.47) Remaining 99 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (.65) .00 (.65) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (.65) ** .00 Budgeted .65 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 886 02/01/2014 Property Taxes/Assessments (793,582.83) (18,162.10) (811,744.93) GL 887 02/03/2014 Property Taxes/Assessments (8,462.79) (820,207.72) GL 888 02/04/2014 Property Taxes/Assessments (5,885.37) (826,093.09) GL 889 02/05/2014 Property Taxes/Assessments (14,936.94) (841,030.03) GL 890 02/06/2014 Property Taxes/Assessments (3,450.95) (844,480.98) GL 891 02/07/2014 Property Taxes/Assessments (14,129.92) (858,610.90) GL 892 02/10/2014 Property Taxes/Assessments (8.28) (858,619.18) GL 893 02/12/2014 Property Taxes/Assessments (740.90) (859,360.08) GL 894 02/13/2014 Property Taxes/Assessments (1,445.48) (860,805.56) GL 895 02/14/2014 Property Taxes/Assessments (104.63) (860,910.19) GL 896 02/18/2014 Property Taxes/Assessments (17,177.39) (878,087.58) GL 897 02/20/2014 Property Taxes/Assessments (48.78) (878,136.36) GL 898 02/24/2014 Property Taxes/Assessments (528.12) (878,664.48) GL 899 02/25/2014 Property Taxes/Assessments (18.70) (878,683.18) GL 900 02/27/2014 Property Taxes/Assessments (295.74) (878,978.92) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (85,396.09) (878,978.92) ** (927,555.00) Budgeted (48,576.08) Remaining 95 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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-40011-000-000 Property Taxes/Fire-Delinquent 901 02/28/2014 Property Taxes/Assessments 7.49 (404.83) (397.34) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (404.83) (397.34) ** .00 Budgeted 397.34 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 889 02/05/2014 Property Taxes/Assessments (.15) (29.67) (29.82) GL 893 02/12/2014 Property Taxes/Assessments (3.11) (32.93) GL 894 02/13/2014 Property Taxes/Assessments (2.30) (35.23) GL 897 02/20/2014 Property Taxes/Assessments (30.22) (65.45) GL 898 02/24/2014 Property Taxes/Assessments (.63) (66.08) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (65.93) (66.08) ** (750.00) Budgeted (683.92) Remaining 9 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 887 02/03/2014 Property Taxes/Assessments (113.71) (7.32) (121.03) GL 888 02/04/2014 Property Taxes/Assessments (19.59) (140.62) GL 889 02/05/2014 Property Taxes/Assessments (.51) (141.13) GL 890 02/06/2014 Property Taxes/Assessments (13.58) (154.71) GL 892 02/10/2014 Property Taxes/Assessments (12.49) (167.20) GL 893 02/12/2014 Property Taxes/Assessments (47.36) (214.56) GL 894 02/13/2014 Property Taxes/Assessments (92.45) (307.01) GL 895 02/14/2014 Property Taxes/Assessments (7.33) (314.34) GL 896 02/18/2014 Property Taxes/Assessments (1,202.40) (1,516.74) GL 897 02/20/2014 Property Taxes/Assessments (3.42) (1,520.16) GL 898 02/24/2014 Property Taxes/Assessments (36.97) (1,557.13) GL 899 02/25/2014 Property Taxes/Assessments (1.31) (1,558.44) GL 900 02/27/2014 Property Taxes/Assessments (20.70) (1,579.14) GL 901 02/28/2014 Property Taxes/Assessments (18.71) (1,597.85) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,484.14) (1,597.85) ** (4,500.00) Budgeted (2,902.15) Remaining 36 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (2,000.00) .00 (2,000.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (2,000.00) ** (6,000.00) Budgeted (4,000.00) Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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-43400-000-000 Fire Inspections (375.00) .00 (375.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (375.00) ** (700.00) Budgeted (325.00) Remaining 54 % 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 (3,425.00) .00 (3,425.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (3,425.00) ** (6,000.00) Budgeted (2,575.00) Remaining 57 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,189,596.37) ** (1,260,950.00) Budgeted (71,353.63) Remaining 94 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 812 02/14/2014 FD 2/14/14 Payroll 150,950.81 17,697.75 168,648.56 GL 867 02/28/2014 FD Payroll 2/28/14 16,269.53 184,918.09 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 33,967.28 184,918.09 ** 455,916.00 Budgeted 270,997.91 Remaining 41 % Used Account: 122-50010-045-000 Overtime 812 02/14/2014 FD 2/14/14 Payroll 11,399.31 2,687.71 14,087.02 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,687.71 14,087.02 ** 44,225.00 Budgeted 30,137.98 Remaining 32 % 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 812 02/14/2014 FD 2/14/14 Payroll 1,464.39 375.00 1,839.39 GL _______________ Account: 122-50017-045-000 Certification Totals: 375.00 1,839.39 ** 4,350.00 Budgeted 2,510.61 Remaining 42 % Used Account: 122-50020-045-000 Retirement 812 02/14/2014 FD 2/14/14 Payroll 25,340.25 3,036.62 28,376.87 GL 867 02/28/2014 FD Payroll 2/28/14 2,361.07 30,737.94 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,397.69 30,737.94 ** 70,991.00 Budgeted 40,253.06 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 812 02/14/2014 FD 2/14/14 Payroll 16,034.52 2,488.38 18,522.90 GL 867 02/28/2014 FD Payroll 2/28/14 1,669.95 20,192.85 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,158.33 20,192.85 ** 56,968.00 Budgeted 36,775.15 Remaining 35 % Used Account: 122-50027-045-000 Dental Insurance 812 02/14/2014 FD 2/14/14 Payroll 1,305.03 176.38 1,481.41 GL 867 02/28/2014 FD Payroll 2/28/14 163.44 1,644.85 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 339.82 1,644.85 ** 4,230.00 Budgeted 2,585.15 Remaining 39 % Used Account: 122-50028-045-000 Vision Insurance 812 02/14/2014 FD 2/14/14 Payroll 273.57 40.75 314.32 GL 867 02/28/2014 FD Payroll 2/28/14 31.93 346.25 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 72.68 346.25 ** 892.00 Budgeted 545.75 Remaining 39 % Used Account: 122-50029-045-000 Life Insurance & Other 812 02/14/2014 FD 2/14/14 Payroll 1,227.64 156.11 1,383.75 GL 867 02/28/2014 FD Payroll 2/28/14 144.98 1,528.73 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 301.09 1,528.73 ** 4,250.00 Budgeted 2,721.27 Remaining 36 % Used Account: 122-50030-045-000 Social Security Taxes 812 02/14/2014 FD 2/14/14 Payroll 10,523.38 1,181.26 11,704.64 GL 867 02/28/2014 FD Payroll 2/28/14 914.21 12,618.85 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,095.47 12,618.85 ** 32,980.00 Budgeted 20,361.15 Remaining 38 % Used Account: 122-50035-045-000 Medicare Taxes 812 02/14/2014 FD 2/14/14 Payroll 2,460.43 276.19 2,736.62 GL 867 02/28/2014 FD Payroll 2/28/14 213.79 2,950.41 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-50035-045-000 Medicare Taxes Totals: 489.98 2,950.41 ** 7,713.00 Budgeted 4,762.59 Remaining 38 % Used Account: 122-50040-045-000 Unemployment Taxes 812 02/14/2014 FD 2/14/14 Payroll 52.90 11.95 64.85 GL 867 02/28/2014 FD Payroll 2/28/14 2.86 67.71 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 14.81 67.71 ** 2,259.00 Budgeted 2,191.29 Remaining 3 % Used Account: 122-50045-045-000 Workman's Compensation 120 02/01/2014 FD Feb W/C expense 2,651.16 662.79 3,313.95 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.79 3,313.95 ** 8,708.00 Budgeted 5,394.05 Remaining 38 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 23.22 23.22 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 112.50 135.72 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P CareNow, Shi 35.00 170.72 TOWN OF TROPHY CLUB 33503 AP 875 02/27/2014 Feb A/P CareNow, Shi, Premier, Symonds 35.00 205.72 TOWN OF TROPHY CLUB 33507 AP _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: 205.72 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 .00 .00 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 .00 ** 8,682.00 Budgeted 8,682.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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) ** 5,000.00 Budgeted 7,505.51 Remaining -50 % Used Account: 122-55080-045-000 Maintenance & Repairs 817 02/07/2014 Firefighters/Feb Cable 3,211.25 (133.71) 3,077.54 GL 808 02/14/2014 Feb A/P Pest Control/Fire Station 140.00 3,217.54 GANN'S PEST CONTROL 33439 AP 808 02/14/2014 Feb A/P Door repair/Fire Station 170.00 3,387.54 OVERHEAD DOOR FORT WORTH 33457 AP 927 02/26/2014 1/28/14-2/26/14 PCards GARDNER 800-521-6535 22.80 3,410.34 GARDNER 800-521-6535 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 79.40 3,489.74 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 117.50 3,607.24 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards SAMSCLUB #4795 168.85 3,776.09 SAMSCLUB #4795 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 11.98 3,788.07 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 43.27 3,831.34 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards KELLER TROPHY AND AWAR 40.00 3,871.34 KELLER TROPHY AND AWAR PC 927 02/26/2014 1/28/14-2/26/14 PCards SAMSCLUB #4795 178.38 4,049.72 SAMSCLUB #4795 PC 927 02/26/2014 1/28/14-2/26/14 PCards AT&T*BILL PAYMENT 133.71 4,183.43 AT&T*BILL PAYMENT PC 927 02/26/2014 1/28/14-2/26/14 PCards AT&T*BILL PAYMENT 157.86 4,341.29 AT&T*BILL PAYMENT PC 870 02/26/2014 Feb A/P Rug Service 24.51 4,365.80 G & K SERVICES 33489 AP 870 02/26/2014 Feb A/P Rug service 24.51 4,390.31 G & K SERVICES 33489 AP 870 02/26/2014 Feb A/P Rug Service 24.51 4,414.82 G & K SERVICES 33489 AP 870 02/26/2014 Feb A/P Rug Service 24.51 4,439.33 G & K SERVICES 33489 AP 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (24.51) 4,414.82 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,203.57 4,414.82 ** 20,472.00 Budgeted 16,057.18 Remaining 22 % Used Account: 122-55090-045-000 Vehicle Maintenance 808 02/14/2014 Feb A/P Ground ladders, Aerial inspect 1,599.73 921.00 2,520.73 CONSOLIDATED FLEET SERVICES 33427 AP 927 02/26/2014 1/28/14-2/26/14 PCards AMAZON MKTPLACE PMTS 59.61 2,580.34 AMAZON MKTPLACE PMTS PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 980.61 2,580.34 ** 14,850.00 Budgeted 12,269.66 Remaining 17 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-60010-045-000 Communications/Pagers/Mobiles 812 02/14/2014 FD 2/14/14 Payroll 959.21 75.00 1,034.21 GL 870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 139.54 1,173.75 TOWN OF TROPHY CLUB 33503 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 214.54 1,173.75 ** 4,237.00 Budgeted 3,063.25 Remaining 28 % Used Account: 122-60020-045-000 Electricity/Gas 870 02/26/2014 Feb A/P Fire Station electricity 1/13/ 2,226.59 800.90 3,027.49 HUDSON ENERGY SERVICES, LLC 33492 AP 870 02/26/2014 Feb A/P Fire Station gas 1/21/14-2/19/ 520.52 3,548.01 ATMOS ENERGY 33478 AP 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (660.71) 2,887.30 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 660.71 2,887.30 ** 6,568.00 Budgeted 3,680.70 Remaining 44 % Used Account: 122-60025-045-000 Water 808 02/14/2014 Feb A/P Jan water billed 248.51 129.12 377.63 TROPHY CLUB MUD (WATER BILLS) 33473 AP 808 02/14/2014 Feb A/P Jan water billed 58.21 435.84 TROPHY CLUB MUD (WATER BILLS) 33473 AP 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (81.21) 354.63 AR _______________ Account: 122-60025-045-000 Water Totals: 106.12 354.63 ** 1,500.00 Budgeted 1,145.37 Remaining 24 % Used Account: 122-60030-045-000 Rent And/Or Usage 902 02/04/2014 FD Rent to I&S 214,279.00 214,279.00 GL _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: 214,279.00 214,279.00 ** 214,279.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 932 02/28/2014 MUD Postage Meter usage/Feb 20.42 6.11 26.53 GL _______________ Account: 122-60035-045-000 Postage Totals: 6.11 26.53 ** 100.00 Budgeted 73.47 Remaining 27 % Used Account: 122-60055-045-000 Insurance 51 02/01/2014 Feb Ins & W/C Expense 4,037.00 1,009.25 5,046.25 GL 870 02/26/2014 Feb A/P Notary, Schaefer, D'Andria 42.00 5,088.25 VICTOR O SCHINNERER & CO, INC 33504 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-60055-045-000 Insurance Totals: 1,051.25 5,088.25 ** 12,110.00 Budgeted 7,021.75 Remaining 42 % Used 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 808 02/14/2014 Feb A/P 2014 Annual membership dues 7,892.64 280.00 8,172.64 DENTON CO FIRE CHIEFS ASSOC 33429 AP 927 02/26/2014 1/28/14-2/26/14 PCards TEXAS ASSOCIATION OF F 25.00 8,197.64 TEXAS ASSOCIATION OF F PC _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 305.00 8,197.64 ** 15,180.00 Budgeted 6,982.36 Remaining 54 % Used Account: 122-60080-045-000 Schools & Training 927 02/26/2014 1/28/14-2/26/14 PCards FIRE PROTECTION PUB-WE 1,624.00 57.00 1,681.00 FIRE PROTECTION PUB-WE PC 927 02/26/2014 1/28/14-2/26/14 PCards TEEX 979 458 6903 365.00 2,046.00 TEEX 979 458 6903 PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 422.00 2,046.00 ** 4,280.00 Budgeted 2,234.00 Remaining 48 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 2,000.00 Budgeted 1,000.00 Remaining 50 % Used Account: 122-60100-045-000 Travel & per diem 927 02/26/2014 1/28/14-2/26/14 PCards EMBASSY SUITES 1,121.60 677.04 1,798.64 EMBASSY SUITES PC 927 02/26/2014 1/28/14-2/26/14 PCards BJ'S RESTAURANTS 525 13.37 1,812.01 BJ'S RESTAURANTS 525 PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 690.41 1,812.01 ** 4,577.00 Budgeted 2,764.99 Remaining 40 % Used Account: 122-60110-045-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 341.17 .00 341.17 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 341.17 ** 4,500.00 Budgeted 4,158.83 Remaining 8 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement .00 .00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-60195-045-000 Flags & Repair 875 02/27/2014 Feb A/P CareNow, Shi, Premier, Symonds 132.75 37.50 170.25 TOWN OF TROPHY CLUB 33507 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 37.50 170.25 ** 2,000.00 Budgeted 1,829.75 Remaining 9 % 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 ** .00 Budgeted (3,456.54) Remaining 0 % Used Account: 122-60245-045-000 Miscellaneous Expense 860 02/24/2014 Town Pay Inv 1123,1126-1136 AR 20140224-20140224 User: 359.97 861.00 1,220.97 AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-60245-045-000 Miscellaneous Expense Totals: 861.00 1,220.97 ** 1,000.00 Budgeted (220.97) Remaining 122 % Used Account: 122-65005-045-000 Fuel & Lube 904 02/28/2014 February Gas Log 2,724.95 444.39 3,169.34 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 444.39 3,169.34 ** 11,698.00 Budgeted 8,528.66 Remaining 27 % Used Account: 122-65010-045-000 Uniforms 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: 491.74 (171.90) 319.84 AR _______________ Account: 122-65010-045-000 Uniforms Totals: (171.90) 319.84 ** 3,360.00 Budgeted 3,040.16 Remaining 10 % Used Account: 122-65015-045-000 Protective Clothing 927 02/26/2014 1/28/14-2/26/14 PCards WITMER PUBLIC SAFETY G 130.00 206.53 336.53 WITMER PUBLIC SAFETY G PC 927 02/26/2014 1/28/14-2/26/14 PCards HAIX NORTH AMERICA 243.95 580.48 HAIX NORTH AMERICA PC 927 02/26/2014 1/28/14-2/26/14 PCards WARMING COOL STORE 95.96 676.44 WARMING COOL STORE PC 870 02/26/2014 Feb A/P JPChase PCards 172.43 848.87 TOWN OF TROPHY CLUB 33503 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 718.87 848.87 ** 7,600.00 Budgeted 6,751.13 Remaining 11 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 927 02/26/2014 1/28/14-2/26/14 PCards WILDFIRE TRUCK & EQUIP 76.46 69.98 146.44 WILDFIRE TRUCK & EQUIP PC _______________ Account: 122-65035-045-000 Small Tools Totals: 69.98 146.44 ** 2,500.00 Budgeted 2,353.56 Remaining 6 % Used Account: 122-65085-045-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 84.44 .00 84.44 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 84.44 ** 1,000.00 Budgeted 915.56 Remaining 8 % Used Account: 122-65095-045-000 Maintenance Supplies 111.16 .00 111.16 _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: .00 111.16 ** .00 Budgeted (111.16) Remaining 0 % 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 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 880 02/27/2014 Wires for Bond payments MUD1 Public Prop CO 2007 1,515.50 1,515.50 GL _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: 1,515.50 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-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: ------------------------------------------------------------------------------------------------ 545,251.99 ** 1,260,950.00 Budgeted 715,698.01 Remaining 43 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (644,344.38) .00 Budgeted 644,344.38 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET FEBRUARY 28, 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 2/28/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 85,786 - - 85,786 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,501,881 - - 1,501,881 INVESTMENTS-TEXPOOL 1,020,376 313,050 162,518 1,495,943 PREPAID EXPENSES 46,403 - - 46,403 ADVALOREM PROPERTY TAXES RECEIVABLE 7,100 - - 7,100 UTILITY AND OTHER ACCOUNTS RECEIVABLE 488,717 - - 488,717 - TOTAL ASSETS 3,150,864 313,050 162,518 3,626,431 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 7,100 - - 7,100 ACCOUNTS AND OTHER PAYABLES 145,881 - - 145,881 CUSTOMER DEPOSITS 244,337 - - 244,337 - TOTAL LIABILITIES 397,318 - - 397,318 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 313,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 (234,930) - (82,583) (317,513) - TOTAL FUND BALANCE 2,753,546 313,050 162,518 3,229,114 - TOTAL LIABILITIES AND FUND BALANCE 3,150,864 313,050 162,518 3,626,431 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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- 9,181.05- 94,097.48- 94.809 5,152.52- 135-40002-000-000 Property Taxes/Delinquent .79- 1.47- 1.47 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 158.03- 147.23- 16.359 752.77- Subtotal: 100,150.00- 100,150.00- 9,339.87- 94,246.18- 94.105 5,903.82- 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- 161,407.89- 924,314.81- 24.653 2,824,995.19- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 136,445.68- 698,011.88- 40.860 1,010,309.12- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 4,670.65- 20,486.41- 31.751 44,035.59- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 403.00- 3,665.00- 40.386 5,410.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 100.00- 900.00- 75.000 300.00- 135-47045-000-000 Sewer Inspections 4,400.00- 4,400.00- 300.00- 2,850.00- 64.773 1,550.00- 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 228.90- 8,053.18- 10.119 71,532.82- Subtotal: 5,616,414.00- 5,616,414.00- 303,556.12- 1,658,281.28- 29.526 3,958,132.72- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 27,600.00- 174,800.00- 30.029 407,309.00- Subtotal: 582,109.00- 582,109.00- 27,600.00- 174,800.00- 30.029 407,309.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 465.35- 2,542.90- 52.977 2,257.10- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 4,552.65- 44.792 5,611.35- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,916.65- 41.666 4,083.35- 135-49030-000-000 Vending Revenue 350.00- 350.00- 98.00- 28.000 252.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- 4,802.00- 37,028.77- 44.082 46,971.23- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- 1,004.80- 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- 4,087.00 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 119,264.00- 11,853.01- 52,384.05- 43.923 66,879.95- Program number: 6,417,937.00- 6,417,937.00- 352,349.00- 1,979,793.87- 30.848 4,438,143.13- Department number: Revenues 6,417,937.00- 6,417,937.00- 352,349.00- 1,979,793.87- 30.848 4,438,143.13- Revenues Subtotal ----------- 6,417,937.00- 6,417,937.00- 352,349.00- 1,979,793.87- 30.848 4,438,143.13- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 21,716.28 107,088.41 37.221 180,620.59 135-50010-010-000 Overtime 13,391.00 13,391.00 1,371.92 7,907.05 59.047 5,483.95 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 350.00 1,650.00 32.353 3,450.00 135-50020-010-000 Retirement 27,847.00 27,847.00 2,104.75 11,359.20 40.791 16,487.80 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 3,439.98 15,340.59 31.739 32,993.41 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 249.12 1,178.73 29.978 2,753.27 135-50028-010-000 Vision Insurance 873.00 873.00 63.03 280.93 32.180 592.07 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 236.86 1,002.10 30.312 2,303.90 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,441.79 7,884.17 40.874 11,404.83 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 337.18 1,843.88 40.875 2,667.12 135-50040-010-000 Unemployment Taxes 54.00 54.00 13.82 52.65 97.500 1.35 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 4,012.25 40.821 5,816.75 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 233.90 116.950 33.90- 135-50070-010-000 Employee Relations 300.00 300.00 22.01 107.78 35.927 192.22 Subtotal: 429,580.00 429,580.00 32,149.19 164,846.64 38.374 264,733.36 135-55005-010-000 Engineering 3,000.00 3,000.00 3,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 13,433.23 38,635.42 77.271 11,364.58 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 714.14 1,790.95 35.819 3,209.05 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 248.33 7.095 3,251.67 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 310.00 990.00 18.000 4,510.00 Subtotal: 67,000.00 67,000.00 14,457.37 41,664.70 62.186 25,335.30 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 383.39 1,531.19 31.166 3,381.81 135-60020-010-000 Electricity 162,160.00 162,160.00 6,807.48 41,233.51 25.428 120,926.49 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 289.00 192.667 139.00- 135-60080-010-000 Schools & Training 4,184.00 4,184.00 70.00 770.00 18.403 3,414.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,450.00 1,450.00 171.13 11.802 1,278.87 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 24.00 4.800 476.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 2,840.20 32,195.79 67.924 15,204.21 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 114,917.03 504,472.51 21.573 1,834,000.49 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 150.00 678.70 19.391 2,821.30 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 3,500.00 3,500.00 Subtotal: 2,567,580.00 2,567,580.00 125,174.10 581,365.83 22.643 1,986,214.17 135-65005-010-000 Fuel & Lube 23,181.00 23,181.00 921.25 4,770.70 20.580 18,410.30 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 3,270.00 1,831.63 56.013 1,438.37 135-65030-010-000 Chemicals 5,000.00 5,000.00 622.20 2,667.29 53.346 2,332.71 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 137.94 322.67 32.267 677.33 135-65050-010-000 Meter Expense 143,550.00 143,550.00 2,215.00 59,392.12 41.374 84,157.88 Subtotal: 177,201.00 177,201.00 3,896.39 69,449.35 39.192 107,751.65 135-69005-010-000 Capital Expenses 37,000.00 37,000.00 37,000.00 135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 489,980.00 135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 19,268.00 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 7,500.00 7,500.00 7,500.00 135-69281-010-000 Capital Repair-Ground Storage 106,847.00 106,847.00 100,816.54 94.356 6,030.46 Subtotal: 690,595.00 690,595.00 100,816.54 14.599 589,778.46 Program number: 3,931,956.00 3,931,956.00 175,677.05 958,143.06 24.368 2,973,812.94 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis 1,000.00 1,000.00 80.00 598.49 59.849 401.51 Subtotal: 1,000.00 1,000.00 80.00 598.49 59.849 401.51 135-60135-010-001 TCEQ Fees & Permits 112.34 2,366.19 2,366.19- Subtotal: 112.34 2,366.19 2,366.19- Program number: 1 Lab Analysis for PID 1,000.00 1,000.00 192.34 2,964.68 296.468 1,964.68- Department number: Water 3,932,956.00 3,932,956.00 175,869.39 961,107.74 24.437 2,971,848.26 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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,165.14 78,724.40 38.801 124,169.60 135-50010-020-000 Overtime 11,965.00 11,965.00 709.96 5,874.15 49.094 6,090.85 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,000.00 41.667 2,800.00 135-50020-020-000 Retirement 19,905.00 19,905.00 1,461.50 8,514.07 42.774 11,390.93 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,241.09 16,309.73 37.519 27,161.27 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 211.38 1,102.14 36.873 1,886.86 135-50028-020-000 Vision Insurance 658.00 658.00 51.26 252.31 38.345 405.69 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 186.28 850.93 36.949 1,452.07 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 850.85 5,267.62 38.157 8,537.38 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 198.99 1,231.94 38.152 1,997.06 135-50040-020-000 Unemployment Taxes 36.00 36.00 9.92 34.50 95.833 1.50 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 2,675.40 40.833 3,876.60 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 22.01 59.99 17.140 290.01 Subtotal: 316,105.00 316,105.00 23,043.46 125,957.68 39.847 190,147.32 135-55070-020-000 Independent Labor 71,565.00 352,976.25 352,976.25- 135-55080-020-000 Maintenance & Repairs 35,000.00 35,000.00 933.47 19,021.56 54.347 15,978.44 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 278.00 1,217.49 60.875 782.51 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 52,000.00 52,000.00 6,476.97 16,446.74 31.628 35,553.26 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 3,190.00 10,484.13 34.947 19,515.87 Subtotal: 119,500.00 119,500.00 82,443.44 400,146.17 334.850 280,646.17- 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 206.74 922.82 27.721 2,406.18 135-60020-020-000 Electricity 148,227.00 148,227.00 8,479.79 39,865.07 26.895 108,361.93 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 160.00 40.000 240.00 135-60080-020-000 Schools & Training 2,636.00 2,636.00 222.00 222.00 8.422 2,414.00 135-60090-020-000 Safety Program 250.00 250.00 371.38 148.552 121.38- 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 266.09 25.342 783.91 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-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60360-020-000 Furniture/Equipment < $5000 3,000.00 3,000.00 3,000.00 Subtotal: 178,242.00 178,242.00 8,908.53 51,025.89 28.627 127,216.11 135-65005-020-000 Fuel & Lube 14,720.00 14,720.00 710.54 4,071.37 27.659 10,648.63 135-65010-020-000 Uniforms 1,752.00 1,752.00 1,437.27 82.036 314.73 135-65030-020-000 Chemicals 39,000.00 39,000.00 2,240.00 10,318.12 26.457 28,681.88 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-020-000 Small Tools 1,000.00 1,000.00 91.00 9.100 909.00 135-65040-020-000 Safety Equipment 250.00 250.00 116.55 230.63 92.252 19.37 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 5,383.58 35.891 9,616.42 Subtotal: 71,722.00 71,722.00 3,067.09 21,531.97 30.021 50,190.03 135-69005-020-000 Capital Expenses 31,000.00 31,000.00 31,000.00 135-69008-020-000 Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 1,422.00 135-69280-020-000 Capital Repairs 30,000.00 30,000.00 30,000.00 Subtotal: 82,442.00 82,442.00 82,442.00 Program number: 768,011.00 768,011.00 117,462.52 598,661.71 77.950 169,349.29 Department number: Wastewater 768,011.00 768,011.00 117,462.52 598,661.71 77.950 169,349.29 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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 4,319.65 26,469.48 29.313 63,829.52 135-50010-021-000 Overtime 10,028.00 10,028.00 298.47 2,133.51 21.276 7,894.49 135-50016-021-000 Longevity 17,913.00 17,913.00 2,107.50 11.765 15,805.50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 750.00 41.667 1,050.00 135-50020-021-000 Retirement 9,025.00 9,025.00 428.17 3,180.15 35.237 5,844.85 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,402.39 8,057.54 34.044 15,610.46 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 102.60 607.59 35.678 1,095.41 135-50028-021-000 Vision Insurance 314.00 314.00 23.68 123.21 39.239 190.79 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 71.54 467.95 43.898 598.05 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 255.17 1,981.57 26.627 5,460.43 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 59.67 463.43 26.619 1,277.57 135-50040-021-000 Unemployment Taxes 198.00 198.00 3.11 10.18 5.141 187.82 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 1,337.70 40.833 1,938.30 135-50070-021-000 Employee Relations 200.00 200.00 22.01 132.02 66.010 67.98 Subtotal: 168,673.00 168,673.00 7,404.00 47,821.83 28.352 120,851.17 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-021-000 Maintenance & Repairs 23,801.00 23,801.00 2,898.00 2,991.28 12.568 20,809.72 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 999.18 999.18 49.959 1,000.82 Subtotal: 27,301.00 27,301.00 3,897.18 3,990.46 14.617 23,310.54 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 102.68 583.72 43.790 749.28 135-60020-021-000 Electricity 21,178.00 21,178.00 2,169.17 8,149.16 38.479 13,028.84 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 135-60080-021-000 Schools & Training 1,711.00 1,711.00 1,711.00 135-60090-021-000 Safety Program 300.00 300.00 300.00 135-60100-021-000 Travel & per diem 550.00 550.00 550.00 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 35,422.00 2,271.85 8,732.88 24.654 26,689.12 135-65005-021-000 Fuel & Lube 22,397.00 22,397.00 841.37 5,013.60 22.385 17,383.40 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 6,000.00 6,000.00 135-65035-021-000 Small Tools 1,000.00 1,000.00 43.99 4.399 956.01 135-65040-021-000 Safety Equipment 500.00 500.00 45.98 586.73 117.346 86.73- Subtotal: 30,937.00 30,937.00 887.35 6,458.55 20.876 24,478.45 135-69005-021-000 Capital Expenses 100,000.00 100,000.00 68,300.20 68,300.20 68.300 31,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 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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 71,000.00 71,000.00 Subtotal: 209,837.00 209,837.00 68,300.20 68,300.20 32.549 141,536.80 Program number: 472,170.00 472,170.00 82,760.58 135,303.92 28.656 336,866.08 Department number: Collection 472,170.00 472,170.00 82,760.58 135,303.92 28.656 336,866.08 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 500.00 3,700.00 37.000 6,300.00 135-50030-026-000 Social Security Taxes 620.00 620.00 31.00 229.40 37.000 390.60 135-50035-026-000 Medicare Taxes 145.00 145.00 7.25 53.65 37.000 91.35 135-50040-026-000 Unemployment Taxes 10.00 10.00 .50 3.70 37.000 6.30 135-50045-026-000 Workman's Compensation 36.00 36.00 2.95 14.75 40.972 21.25 Subtotal: 10,811.00 10,811.00 541.70 4,001.50 37.013 6,809.50 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 5,000.00 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 Subtotal: 11,850.00 11,850.00 335.95 2.835 11,514.05 Program number: 22,661.00 22,661.00 541.70 4,337.45 19.141 18,323.55 Department number: Board of Directors 22,661.00 22,661.00 541.70 4,337.45 19.141 18,323.55 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 34,592.99 178,933.69 39.007 279,787.31 135-50010-030-000 Overtime 500.00 500.00 28.93 348.64 69.728 151.36 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,109.05 17,348.65 41.886 24,070.35 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,602.53 22,536.29 38.907 35,386.71 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 340.42 1,839.86 36.076 3,260.14 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 81.62 410.83 37.795 676.17 135-50029-030-000 Life Insurance & Other 4,483.00 4,483.00 352.66 2,190.29 48.858 2,292.71 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 2,012.79 11,370.05 39.674 17,288.95 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 470.74 2,659.14 39.677 4,042.86 135-50040-030-000 Unemployment Taxes 63.00 63.00 9.98 58.18 92.349 4.82 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.63 643.15 40.835 931.85 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 173.69 2,634.60 52.692 2,365.40 Subtotal: 614,450.00 614,450.00 45,904.03 244,050.87 39.719 370,399.13 135-55030-030-000 Software & Support 59,698.00 59,698.00 1,695.95 20,352.19 34.092 39,345.81 135-55070-030-000 Independent Labor 7,700.00 7,700.00 142.50 2,377.95 30.882 5,322.05 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 188.84- 1,948.97- -43.310 6,448.97 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 377.68 1,893.86 29.136 4,606.14 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 1,594.97 6,379.88 33.333 12,760.12 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 15,000.00 135-55161-030-000 Outside Services-Town Semo 77,048.00 77,048.00 38,524.00 50.000 38,524.00 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 566.00 2,330.35 34.230 4,477.65 Subtotal: 196,594.00 196,594.00 4,188.26 69,909.26 35.560 126,684.74 135-60005-030-000 Telephone 11,250.00 11,250.00 2,071.25 4,987.36 44.332 6,262.64 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 3,589.00 290.67 1,170.46 32.612 2,418.54 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 7,243.58 47.746 7,927.42 135-60025-030-000 Water 1,500.00 1,500.00 103.41 228.08 15.205 1,271.92 135-60035-030-000 Postage 28,500.00 28,500.00 2,035.09 9,029.29 31.682 19,470.71 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 2,533.53 12,064.32 42.585 16,265.68 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 3,712.56 247.504 2,212.56- 135-60055-030-000 Insurance 53,561.00 53,561.00 4,319.73 21,431.90 40.014 32,129.10 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 126.00 12.600 874.00 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-60080-030-000 Schools & Training 7,500.00 7,500.00 699.00 1,201.30 16.017 6,298.70 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 703.16 14.063 4,296.84 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 2,500.00 2,500.00 2,500.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 508.62 508.62 20.345 1,991.38 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 22,870.00 63.46 346.54 1.515 22,523.46 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 204,221.00 12,624.76 66,888.68 32.753 137,332.32 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 67.71 1,745.66 12.872 11,816.34 135-65085-030-000 Office Supplies 9,100.00 9,100.00 516.50 2,093.44 23.005 7,006.56 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 1,246.33 21.743 4,485.67 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 295.95 1,111.49 44.460 1,388.51 135-65097-030-000 Vending Machine Supplies 200.00 200.00 51.00 25.500 149.00 135-65105-030-000 Printing 4,000.00 4,000.00 1,401.00 35.025 2,599.00 Subtotal: 36,484.00 36,484.00 880.16 8,647.82 23.703 27,836.18 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 1,027.40 29.780 2,422.60 Subtotal: 3,450.00 3,450.00 256.85 1,027.40 29.780 2,422.60 Program number: 1,055,199.00 1,055,199.00 63,854.06 390,524.03 37.010 664,674.97 Department number: Administration 1,055,199.00 1,055,199.00 63,854.06 390,524.03 37.010 664,674.97 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 11:19 03/07/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/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 131,300.00 10,865.25 96,808.47 73.731 34,491.53 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 4,329.38 43.294 5,670.62 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 166,940.00 10,865.25 124,789.25 74.751 42,150.75 Program number: 166,940.00 166,940.00 10,865.25 124,789.25 74.751 42,150.75 Department number: Non Departmental 166,940.00 166,940.00 10,865.25 124,789.25 74.751 42,150.75 Expenditures Subtotal ----------- 6,417,937.00 6,417,937.00 451,353.50 2,214,724.10 34.508 4,203,212.90 Fund number: 135 MUD 1 General Fund 99,004.50 234,930.23 234,930.23- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 11:19 03/07/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 2/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 4.07- 46.69- 46.69 Subtotal: 4.07- 46.69- 46.69 Program number: 4.07- 46.69- 46.69 Department number: 4.07- 46.69- 46.69 Revenues Subtotal ----------- 4.07- 46.69- 46.69 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 11:19 03/07/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 2/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- Department number: Water 82,629.40 82,629.40- Expenditures Subtotal ----------- 82,629.40 82,629.40- Fund number: 507 MUD 1 Capital Projects 4.07- 82,582.71 82,582.71- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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 886 02/01/2014 Property Taxes/Assessments (84,916.43) (1,943.42) (86,859.85) GL 887 02/03/2014 Property Taxes/Assessments (905.55) (87,765.40) GL 888 02/04/2014 Property Taxes/Assessments (629.76) (88,395.16) GL 889 02/05/2014 Property Taxes/Assessments (1,598.31) (89,993.47) GL 890 02/06/2014 Property Taxes/Assessments (369.26) (90,362.73) GL 891 02/07/2014 Property Taxes/Assessments (1,511.96) (91,874.69) GL 892 02/10/2014 Property Taxes/Assessments (.89) (91,875.58) GL 893 02/12/2014 Property Taxes/Assessments (79.28) (91,954.86) GL 894 02/13/2014 Property Taxes/Assessments (154.67) (92,109.53) GL 895 02/14/2014 Property Taxes/Assessments (11.20) (92,120.73) GL 896 02/18/2014 Property Taxes/Assessments (1,838.05) (93,958.78) GL 897 02/20/2014 Property Taxes/Assessments (5.22) (93,964.00) GL 898 02/24/2014 Property Taxes/Assessments (56.51) (94,020.51) GL 899 02/25/2014 Property Taxes/Assessments (2.00) (94,022.51) GL 900 02/27/2014 Property Taxes/Assessments (31.65) (94,054.16) GL 901 02/28/2014 Property Taxes/Assessments (43.32) (94,097.48) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (9,181.05) (94,097.48) ** (99,250.00) Budgeted (5,152.52) Remaining 95 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 887 02/03/2014 Property Taxes/Assessments (.68) (.79) (1.47) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (.79) (1.47) ** .00 Budgeted 1.47 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 888 02/04/2014 Property Taxes/Assessments 10.80 (2.09) 8.71 GL 889 02/05/2014 Property Taxes/Assessments (.06) 8.65 GL 890 02/06/2014 Property Taxes/Assessments (1.46) 7.19 GL 892 02/10/2014 Property Taxes/Assessments (1.33) 5.86 GL 893 02/12/2014 Property Taxes/Assessments (5.07) .79 GL 894 02/13/2014 Property Taxes/Assessments (9.90) (9.11) GL 895 02/14/2014 Property Taxes/Assessments (.78) (9.89) GL 896 02/18/2014 Property Taxes/Assessments (128.66) (138.55) GL 897 02/20/2014 Property Taxes/Assessments (.37) (138.92) GL 898 02/24/2014 Property Taxes/Assessments (3.96) (142.88) GL 899 02/25/2014 Property Taxes/Assessments (.14) (143.02) GL 900 02/27/2014 Property Taxes/Assessments (2.21) (145.23) GL 901 02/28/2014 Property Taxes/Assessments (2.00) (147.23) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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-40015-000-000 Property Taxes/P & I Totals: (158.03) (147.23) ** (900.00) Budgeted (752.77) Remaining 16 % 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 926 02/28/2014 UB 2/28/14 Billing-february UB20140228-20140228 User: (762,906.92) (161,407.89) (924,314.81) UB _______________ Account: 135-47000-000-000 Water Totals: (161,407.89) (924,314.81) ** (3,749,310.00) Budgeted (2,824,995.19) Remaining 25 % Used Account: 135-47005-000-000 Sewer 926 02/28/2014 UB 2/28/14 Billing-february UB20140228-20140228 User: (561,566.20) (136,445.68) (698,011.88) UB _______________ Account: 135-47005-000-000 Sewer Totals: (136,445.68) (698,011.88) ** (1,708,321.00) Budgeted (1,010,309.12) Remaining 41 % Used Account: 135-47025-000-000 Penalties 852 02/21/2014 UB 2/21/14 Late Penalties UB20140221-20140221 User: (15,815.76) (4,737.93) (20,553.69) UB 925 02/28/2014 UB 02/28/2014 Adjustments UB20140228-20140228 User: 67.28 (20,486.41) UB _______________ Account: 135-47025-000-000 Penalties Totals: (4,670.65) (20,486.41) ** (64,522.00) Budgeted (44,035.59) Remaining 32 % Used Account: 135-47030-000-000 Service Charges 832 02/04/2014 UB 2/4/14 NSF Fee UB20140204-20140204 User: (3,262.00) (25.00) (3,287.00) UB 798 02/12/2014 UB 2/12/14 Cut Off List UB20140212-20140212 User: (275.00) (3,562.00) UB 912 02/14/2014 UB 2/14/14 Adjustment NSF Fee UB20140214-20140214 User: (25.00) (3,587.00) UB 915 02/20/2014 UB 2/20/14 NSF Check Fee UB20140220-20140220 User: (25.00) (3,612.00) UB 918 02/21/2014 UB 2/21/14 NSF Check Fee UB20140221-20140221 User: (25.00) (3,637.00) UB 923 02/27/2014 UB 2/27/14 NSF Check Fee UB20140227-20140227 User: (25.00) (3,662.00) UB 926 02/28/2014 UB 2/28/14 Billing-february UB20140228-20140228 User: (3.00) (3,665.00) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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-47030-000-000 Service Charges Totals: (403.00) (3,665.00) ** (9,075.00) Budgeted (5,410.00) Remaining 40 % Used Account: 135-47035-000-000 Plumbing Inspections 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (800.00) (100.00) (900.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (900.00) ** (1,200.00) Budgeted (300.00) Remaining 75 % Used Account: 135-47045-000-000 Sewer Inspections 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (2,550.00) (300.00) (2,850.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (2,850.00) ** (4,400.00) Budgeted (1,550.00) Remaining 65 % Used Account: 135-47070-000-000 TCCC Effluent Charges 926 02/28/2014 UB 2/28/14 Billing-february UB20140228-20140228 User: (7,824.28) (228.90) (8,053.18) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (228.90) (8,053.18) ** (79,586.00) Budgeted (71,532.82) Remaining 10 % Used Account: 135-48005-000-000 Utility Fees 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (147,200.00) (27,600.00) (174,800.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (27,600.00) (174,800.00) ** (582,109.00) Budgeted (407,309.00) Remaining 30 % Used Account: 135-49010-000-000 Interest Income 929 02/28/2014 Bank Statement Interest/Feb (2,077.55) (368.59) (2,446.14) GL 929 02/28/2014 Bank Statement Interest/Feb (53.69) (2,499.83) GL 929 02/28/2014 Bank Statement Interest/Feb (43.07) (2,542.90) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (465.35) (2,542.90) ** (4,800.00) Budgeted (2,257.10) Remaining 53 % Used Account: 135-49016-000-000 Cell Tower Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 814 02/07/2014 AT&T Antenna Lease (3,642.12) (910.53) (4,552.65) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (4,552.65) ** (10,164.00) Budgeted (5,611.35) Remaining 45 % Used Account: 135-49018-000-000 Building Rent Income 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (2,333.32) (583.33) (2,916.65) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,916.65) ** (7,000.00) Budgeted (4,083.35) Remaining 42 % Used Account: 135-49030-000-000 Vending Revenue (98.00) .00 (98.00) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (98.00) ** (350.00) Budgeted (252.00) Remaining 28 % 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 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (32,226.77) (4,802.00) (37,028.77) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,802.00) (37,028.77) ** (84,000.00) Budgeted (46,971.23) Remaining 44 % Used Account: 135-49900-000-000 Miscellaneous Income 818 02/14/2014 Sale of Scrap metal (153.28) (1,004.80) (1,158.08) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,004.80) (1,158.08) ** (3,000.00) Budgeted (1,841.92) Remaining 39 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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-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 816 02/07/2014 TML FY13 W/C Audit refund (4,087.00) (4,087.00) GL _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: (4,087.00) (4,087.00) ** .00 Budgeted 4,087.00 Remaining 0 % Used 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: ------------------------------------------------------------------------------------------------ (1,979,793.87) ** (6,417,937.00) Budgeted (4,438,143.13) Remaining 31 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 794 02/14/2014 PR 02-14-14 Salaries & Wages 85,372.13 10,858.14 96,230.27 PR 864 02/28/2014 Payroll 2/28/14 Salaries & Wages 10,858.14 107,088.41 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 21,716.28 107,088.41 ** 287,709.00 Budgeted 180,620.59 Remaining 37 % Used Account: 135-50010-010-000 Overtime 794 02/14/2014 PR 02-14-14 Overtime 6,535.13 881.65 7,416.78 PR 864 02/28/2014 Payroll 2/28/14 Overtime 490.27 7,907.05 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,371.92 7,907.05 ** 13,391.00 Budgeted 5,483.95 Remaining 59 % 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 864 02/28/2014 Payroll 2/28/14 Certification 1,300.00 350.00 1,650.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 350.00 1,650.00 ** 5,100.00 Budgeted 3,450.00 Remaining 32 % Used Account: 135-50020-010-000 Retirement 794 02/14/2014 PR 02-14-14 Retirement 9,254.45 1,054.23 10,308.68 PR 864 02/28/2014 Payroll 2/28/14 Retirement 1,050.52 11,359.20 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,104.75 11,359.20 ** 27,847.00 Budgeted 16,487.80 Remaining 41 % Used Account: 135-50026-010-000 Medical Insurance 794 02/14/2014 PR 02-14-14 Medical Insurance 11,900.61 1,720.02 13,620.63 PR 864 02/28/2014 Payroll 2/28/14 Medical Insurance 1,719.96 15,340.59 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,439.98 15,340.59 ** 48,334.00 Budgeted 32,993.41 Remaining 32 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 794 02/14/2014 PR 02-14-14 Dental Insurance 929.61 124.54 1,054.15 PR 864 02/28/2014 Payroll 2/28/14 Dental Insurance 124.58 1,178.73 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 249.12 1,178.73 ** 3,932.00 Budgeted 2,753.27 Remaining 30 % Used Account: 135-50028-010-000 Vision Insurance 794 02/14/2014 PR 02-14-14 Vision Insurance 217.90 31.49 249.39 PR 864 02/28/2014 Payroll 2/28/14 Vision Insurance 31.54 280.93 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 63.03 280.93 ** 873.00 Budgeted 592.07 Remaining 32 % Used Account: 135-50029-010-000 Life Insurance & Other 689 02/01/2014 Feb A/P Dental, Life, STD & Other Ins 765.24 221.24 986.48 METLIFE 33414 AP 873 02/27/2014 Feb A/P Jan Admin/FSA 15.62 1,002.10 BenefitMall 33480 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 236.86 1,002.10 ** 3,306.00 Budgeted 2,303.90 Remaining 30 % Used Account: 135-50030-010-000 Social Security Taxes 794 02/14/2014 PR 02-14-14 Social Security Taxes 6,442.38 724.64 7,167.02 PR 864 02/28/2014 Payroll 2/28/14 Social Security Taxes 717.15 7,884.17 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,441.79 7,884.17 ** 19,289.00 Budgeted 11,404.83 Remaining 41 % Used Account: 135-50035-010-000 Medicare Taxes 794 02/14/2014 PR 02-14-14 Medicare Taxes 1,506.70 169.47 1,676.17 PR 864 02/28/2014 Payroll 2/28/14 Medicare Taxes 167.71 1,843.88 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 337.18 1,843.88 ** 4,511.00 Budgeted 2,667.12 Remaining 41 % Used Account: 135-50040-010-000 Unemployment Taxes 794 02/14/2014 PR 02-14-14 Unemployment Taxes 38.83 8.90 47.73 PR 864 02/28/2014 Payroll 2/28/14 Unemployment Taxes 4.92 52.65 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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: 13.82 52.65 ** 54.00 Budgeted 1.35 Remaining 98 % Used Account: 135-50045-010-000 Workman's Compensation 51 02/01/2014 Feb Ins & W/C Expense 3,209.80 802.45 4,012.25 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 4,012.25 ** 9,829.00 Budgeted 5,816.75 Remaining 41 % 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 ** 200.00 Budgeted (33.90) Remaining 117 % Used Account: 135-50070-010-000 Employee Relations 927 02/26/2014 1/28/14-2/26/14 PCards DONUT HAVEN 85.77 8.01 93.78 DONUT HAVEN PC 927 02/26/2014 1/28/14-2/26/14 PCards CHICK-FIL-A #02892 14.00 107.78 CHICK-FIL-A #02892 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 22.01 107.78 ** 300.00 Budgeted 192.22 Remaining 36 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 808 02/14/2014 Feb A/P Cla Valve repair 25,202.19 1,695.00 26,897.19 AXIS CONSTRUCTION 33425 AP 808 02/14/2014 Feb A/P Mag Meter for water plant 9,250.00 36,147.19 ATLAS UTILITY SUPPLY CO. 33424 AP 808 02/14/2014 Feb A/P Gaskets 62.36 36,209.55 ATLAS UTILITY SUPPLY CO. 33424 AP 808 02/14/2014 Feb A/P Dechlor Tablets 259.90 36,469.45 HD SUPPLY FACILITIES MAINT LTD 33441 AP 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 8.37 36,477.82 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 31.88 36,509.70 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 18.46 36,528.16 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 72.17 36,600.33 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 25,202.19 50.24 36,650.57 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards OFFICE DEPOT #406 49.98 36,700.55 OFFICE DEPOT #406 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 9.80 36,710.35 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 45.59 36,755.94 THE HOME DEPOT 6581 PC 870 02/26/2014 Feb A/P 24" Mag Meter install @ water 975.00 37,730.94 DHS AUTOMATION, INC 33485 AP 870 02/26/2014 Feb A/P meter boxes, gaskets, inserts 904.48 38,635.42 HD SUPPLY WATERWORKS, LTD. 33491 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 13,433.23 38,635.42 ** 50,000.00 Budgeted 11,364.58 Remaining 77 % Used Account: 135-55090-010-000 Vehicle Maintenance 808 02/14/2014 Feb A/P Chains for vehicles 1,076.81 695.00 1,771.81 ROANOKE AUTO SUPPLY 33464 AP 870 02/26/2014 Feb A/P Lights, washer fluid 13.85 1,785.66 ROANOKE AUTO SUPPLY 33501 AP 875 02/27/2014 Feb A/P Reimburse Petty Cash 5.29 1,790.95 TROPHY CLUB MUD PETTY CASH 33508 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 714.14 1,790.95 ** 5,000.00 Budgeted 3,209.05 Remaining 36 % 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 ** 3,500.00 Budgeted 3,251.67 Remaining 7 % Used Account: 135-55135-010-000 Lab Analysis 808 02/14/2014 Feb A/P Bac T Samples/MUD 680.00 310.00 990.00 TARRANT CTY PUBLIC HEALTH LAB 33467 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 310.00 990.00 ** 5,500.00 Budgeted 4,510.00 Remaining 18 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 1,147.80 383.39 1,531.19 TOWN OF TROPHY CLUB 33503 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 383.39 1,531.19 ** 4,913.00 Budgeted 3,381.81 Remaining 31 % Used Account: 135-60020-010-000 Electricity 870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 34,426.03 4,706.99 39,133.02 HUDSON ENERGY SERVICES, LLC 33492 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 870 02/26/2014 Feb A/P Electricity 1/11/14-2/9/14 34,426.03 75.18 39,208.20 HUDSON ENERGY SERVICES, LLC 33492 AP 870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 2,025.31 41,233.51 HUDSON ENERGY SERVICES, LLC 33492 AP _______________ Account: 135-60020-010-000 Electricity Totals: 6,807.48 41,233.51 ** 162,160.00 Budgeted 120,926.49 Remaining 25 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships 289.00 .00 289.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 289.00 ** 150.00 Budgeted (139.00) Remaining 193 % Used Account: 135-60080-010-000 Schools & Training 927 02/26/2014 1/28/14-2/26/14 PCards NCTCOG RTC TRAINING 700.00 30.00 730.00 NCTCOG RTC TRAINING PC 875 02/27/2014 Feb A/P Reimburse Petty Cash 40.00 770.00 TROPHY CLUB MUD PETTY CASH 33508 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 70.00 770.00 ** 4,184.00 Budgeted 3,414.00 Remaining 18 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 171.13 .00 171.13 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 171.13 ** 1,450.00 Budgeted 1,278.87 Remaining 12 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 870 02/26/2014 Feb A/P January Nitrogen 18.00 6.00 24.00 ALLIED WELDING SUPPLY, INC 33477 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 24.00 ** 500.00 Budgeted 476.00 Remaining 5 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 808 02/14/2014 Feb A/P Halocetic Acids, Trihalomethan 29,355.59 207.70 29,563.29 LOWER COLORADO RIVER AUTHORITY 33451 AP 808 02/14/2014 Feb A/P 9/30/13-12/31/13 NTGC Dist Fee 2,582.50 32,145.79 North Texas Groundwater 33455 AP 938 02/28/2014 Feb A/P Tier Two Chemical Reporting Pr 50.00 32,195.79 DEPT OF STATE HEALTH SVCS AP 939 02/28/2014 Void A/P Inv-Tier Two Tier Two Chemical Reporting Pr (50.00) 32,145.79 DEPT OF STATE HEALTH SVCS AP 940 02/28/2014 Feb A/P Tier Two Chemical Reporting Ja 50.00 32,195.79 DEPT OF STATE HEALTH SVCS 33510 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 2,840.20 32,195.79 ** 47,400.00 Budgeted 15,204.21 Remaining 68 % Used Account: 135-60150-010-000 Wholesale Water 870 02/26/2014 Feb A/P Jan Wholesale water 389,555.48 114,917.03 504,472.51 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 114,917.03 504,472.51 ** 2,338,473.00 Budgeted 1,834,000.49 Remaining 22 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 927 02/26/2014 1/28/14-2/26/14 PCards DENTON SAND & GRAVEL, 528.70 108.00 636.70 DENTON SAND & GRAVEL, PC 927 02/26/2014 1/28/14-2/26/14 PCards DENTON SAND & GRAVEL, 42.00 678.70 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 150.00 678.70 ** 3,500.00 Budgeted 2,821.30 Remaining 19 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 904 02/28/2014 February Gas Log 3,849.45 921.25 4,770.70 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 921.25 4,770.70 ** 23,181.00 Budgeted 18,410.30 Remaining 21 % Used Account: 135-65010-010-000 Uniforms 1,831.63 .00 1,831.63 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,831.63 ** 3,270.00 Budgeted 1,438.37 Remaining 56 % Used Account: 135-65030-010-000 Chemicals 808 02/14/2014 Feb A/P Chlorine 2,045.09 104.09 2,149.18 DPC INDUSTRIES, INC 33432 AP 808 02/14/2014 Feb A/P testing supplies 309.93 2,459.11 HACH COMPANY 33440 AP 927 02/26/2014 1/28/14-2/26/14 PCards DX SERVICE 208.18 2,667.29 DX SERVICE PC _______________ Account: 135-65030-010-000 Chemicals Totals: 622.20 2,667.29 ** 5,000.00 Budgeted 2,332.71 Remaining 53 % 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 870 02/26/2014 Feb A/P JPChase PCards 184.73 137.94 322.67 TOWN OF TROPHY CLUB 33503 AP _______________ Account: 135-65040-010-000 Safety Equipment Totals: 137.94 322.67 ** 1,000.00 Budgeted 677.33 Remaining 32 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-65050-010-000 Meter Expense 808 02/14/2014 Feb A/P Replacement meter heads 57,177.12 2,215.00 59,392.12 ATLAS UTILITY SUPPLY CO. 33424 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 2,215.00 59,392.12 ** 143,550.00 Budgeted 84,157.88 Remaining 41 % Used Account: 135-69005-010-000 Capital Expenses .00 .00 _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 .00 ** 37,000.00 Budgeted 37,000.00 Remaining 0 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 489,980.00 Budgeted 489,980.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 19,268.00 Budgeted 19,268.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 106,847.00 Budgeted 6,030.46 Remaining 94 % Used Account: 135-55135-010-001 Lab Analysis 808 02/14/2014 Feb A/P Bac T samples/PID 518.49 80.00 598.49 TARRANT CTY PUBLIC HEALTH LAB 33466 AP _______________ Account: 135-55135-010-001 Lab Analysis Totals: 80.00 598.49 ** 1,000.00 Budgeted 401.51 Remaining 60 % Used Account: 135-60135-010-001 TCEQ Fees & Permits 808 02/14/2014 Feb A/P PID testing/Halocetic Acids, T 2,253.85 112.34 2,366.19 LOWER COLORADO RIVER AUTHORITY 33451 AP _______________ Account: 135-60135-010-001 TCEQ Fees & Permits Totals: 112.34 2,366.19 ** .00 Budgeted (2,366.19) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 961,107.74 ** 3,932,956.00 Budgeted 2,971,848.26 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 794 02/14/2014 PR 02-14-14 Salaries & Wages 63,559.26 7,587.46 71,146.72 PR 864 02/28/2014 Payroll 2/28/14 Salaries & Wages 7,577.68 78,724.40 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,165.14 78,724.40 ** 202,894.00 Budgeted 124,169.60 Remaining 39 % Used Account: 135-50010-020-000 Overtime 794 02/14/2014 PR 02-14-14 Overtime 5,164.19 462.43 5,626.62 PR 864 02/28/2014 Payroll 2/28/14 Overtime 247.53 5,874.15 PR _______________ Account: 135-50010-020-000 Overtime Totals: 709.96 5,874.15 ** 11,965.00 Budgeted 6,090.85 Remaining 49 % 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 864 02/28/2014 Payroll 2/28/14 Certification 1,600.00 400.00 2,000.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 2,000.00 ** 4,800.00 Budgeted 2,800.00 Remaining 42 % Used Account: 135-50020-020-000 Retirement 794 02/14/2014 PR 02-14-14 Retirement 7,052.57 722.88 7,775.45 PR 864 02/28/2014 Payroll 2/28/14 Retirement 738.62 8,514.07 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,461.50 8,514.07 ** 19,905.00 Budgeted 11,390.93 Remaining 43 % Used Account: 135-50026-020-000 Medical Insurance 794 02/14/2014 PR 02-14-14 Medical Insurance 13,068.64 1,620.56 14,689.20 PR 864 02/28/2014 Payroll 2/28/14 Medical Insurance 1,620.53 16,309.73 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,241.09 16,309.73 ** 43,471.00 Budgeted 27,161.27 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 794 02/14/2014 PR 02-14-14 Dental Insurance 890.76 105.68 996.44 PR 864 02/28/2014 Payroll 2/28/14 Dental Insurance 105.70 1,102.14 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 211.38 1,102.14 ** 2,989.00 Budgeted 1,886.86 Remaining 37 % Used Account: 135-50028-020-000 Vision Insurance 794 02/14/2014 PR 02-14-14 Vision Insurance 201.05 25.61 226.66 PR 864 02/28/2014 Payroll 2/28/14 Vision Insurance 25.65 252.31 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 51.26 252.31 ** 658.00 Budgeted 405.69 Remaining 38 % Used Account: 135-50029-020-000 Life Insurance & Other 689 02/01/2014 Feb A/P Dental, Life, STD & Other Ins 664.65 155.00 819.65 METLIFE 33414 AP 873 02/27/2014 Feb A/P Jan Admin/FSA 31.28 850.93 BenefitMall 33480 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 186.28 850.93 ** 2,303.00 Budgeted 1,452.07 Remaining 37 % Used Account: 135-50030-020-000 Social Security Taxes 794 02/14/2014 PR 02-14-14 Social Security Taxes 4,416.77 425.64 4,842.41 PR 864 02/28/2014 Payroll 2/28/14 Social Security Taxes 425.21 5,267.62 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 850.85 5,267.62 ** 13,805.00 Budgeted 8,537.38 Remaining 38 % Used Account: 135-50035-020-000 Medicare Taxes 794 02/14/2014 PR 02-14-14 Medicare Taxes 1,032.95 99.55 1,132.50 PR 864 02/28/2014 Payroll 2/28/14 Medicare Taxes 99.44 1,231.94 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 198.99 1,231.94 ** 3,229.00 Budgeted 1,997.06 Remaining 38 % Used Account: 135-50040-020-000 Unemployment Taxes 794 02/14/2014 PR 02-14-14 Unemployment Taxes 24.58 7.29 31.87 PR 864 02/28/2014 Payroll 2/28/14 Unemployment Taxes 2.63 34.50 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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: 9.92 34.50 ** 36.00 Budgeted 1.50 Remaining 96 % Used Account: 135-50045-020-000 Workman's Compensation 51 02/01/2014 Feb Ins & W/C Expense 2,140.32 535.08 2,675.40 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 2,675.40 ** 6,552.00 Budgeted 3,876.60 Remaining 41 % 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 927 02/26/2014 1/28/14-2/26/14 PCards DONUT HAVEN 37.98 8.01 45.99 DONUT HAVEN PC 927 02/26/2014 1/28/14-2/26/14 PCards CHICK-FIL-A #02892 14.00 59.99 CHICK-FIL-A #02892 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 22.01 59.99 ** 350.00 Budgeted 290.01 Remaining 17 % Used Account: 135-55070-020-000 Independent Labor 808 02/14/2014 Feb A/P WWTP Improvements 281,411.25 71,565.00 352,976.25 THE WALLACE GROUP, INC. 33470 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 71,565.00 352,976.25 ** .00 Budgeted (352,976.25) Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 18,088.09 19.97 18,108.06 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 80.32 18,188.38 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 46.20 18,234.58 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 198.73 18,433.31 THE HOME DEPOT 6581 PC 927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 587 80.25 18,513.56 THE HOME DEPOT 587 PC 870 02/26/2014 Feb A/P Pump Station Pump 1 bad wire c 508.00 19,021.56 XYLEM WATER SOLUTIONS USA INC 33505 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 933.47 19,021.56 ** 35,000.00 Budgeted 15,978.44 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-020-000 Vehicle Maintenance 808 02/14/2014 Feb A/P Chains for vehicles 939.49 278.00 1,217.49 ROANOKE AUTO SUPPLY 33464 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 278.00 1,217.49 ** 2,000.00 Budgeted 782.51 Remaining 61 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 870 02/26/2014 Feb A/P Sludge Haul off 9,969.77 2,751.11 12,720.88 L.H. CHANEY MATERIALS, INC. 33497 AP 870 02/26/2014 Feb A/P Sludge Haul off 1,911.24 14,632.12 L.H. CHANEY MATERIALS, INC. 33497 AP 870 02/26/2014 Feb A/P Sludge Haul off 1,814.62 16,446.74 L.H. CHANEY MATERIALS, INC. 33497 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 6,476.97 16,446.74 ** 52,000.00 Budgeted 35,553.26 Remaining 32 % Used Account: 135-55135-020-000 Lab Analysis 870 02/26/2014 Feb A/P Biomonitoring 7,294.13 1,080.00 8,374.13 HUTHER AND ASSOCIATES,INC 33493 AP 870 02/26/2014 Feb A/P Testing 176.00 8,550.13 OXIDOR LABORATORIES LLC 33500 AP 870 02/26/2014 Feb A/P Testing 246.00 8,796.13 OXIDOR LABORATORIES LLC 33500 AP 870 02/26/2014 Feb A/P Testing 246.00 9,042.13 OXIDOR LABORATORIES LLC 33500 AP 870 02/26/2014 Feb A/P Testing 176.00 9,218.13 OXIDOR LABORATORIES LLC 33500 AP 870 02/26/2014 Feb A/P Testing 246.00 9,464.13 OXIDOR LABORATORIES LLC 33500 AP 870 02/26/2014 Feb A/P Testing 176.00 9,640.13 OXIDOR LABORATORIES LLC 33500 AP 870 02/26/2014 Feb A/P Testing 246.00 9,886.13 OXIDOR LABORATORIES LLC 33500 AP 870 02/26/2014 Feb A/P Testing 176.00 10,062.13 OXIDOR LABORATORIES LLC 33500 AP 870 02/26/2014 Feb A/P Testing 246.00 10,308.13 OXIDOR LABORATORIES LLC 33500 AP 870 02/26/2014 Feb A/P Testing 176.00 10,484.13 OXIDOR LABORATORIES LLC 33500 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 3,190.00 10,484.13 ** 30,000.00 Budgeted 19,515.87 Remaining 35 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 716.08 206.74 922.82 TOWN OF TROPHY CLUB 33503 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-60010-020-000 Communications/Pagers/Mobiles Totals: 206.74 922.82 ** 3,329.00 Budgeted 2,406.18 Remaining 28 % Used Account: 135-60020-020-000 Electricity 870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 31,385.28 8,479.79 39,865.07 HUDSON ENERGY SERVICES, LLC 33492 AP _______________ Account: 135-60020-020-000 Electricity Totals: 8,479.79 39,865.07 ** 148,227.00 Budgeted 108,361.93 Remaining 27 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 160.00 .00 160.00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 160.00 ** 400.00 Budgeted 240.00 Remaining 40 % Used Account: 135-60080-020-000 Schools & Training 927 02/26/2014 1/28/14-2/26/14 PCards TCEQ IND RENEWAL L 111.00 111.00 TCEQ IND RENEWAL L PC 927 02/26/2014 1/28/14-2/26/14 PCards TCEQ IND RENEWAL L 111.00 222.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 222.00 222.00 ** 2,636.00 Budgeted 2,414.00 Remaining 8 % Used Account: 135-60090-020-000 Safety Program 371.38 .00 371.38 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 371.38 ** 250.00 Budgeted (121.38) Remaining 149 % Used Account: 135-60100-020-000 Travel & per diem 266.09 .00 266.09 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 266.09 ** 1,050.00 Budgeted 783.91 Remaining 25 % Used Account: 135-60105-020-000 Rent/Lease Equipment 299.53 .00 299.53 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-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 Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 904 02/28/2014 February Gas Log 3,360.83 710.54 4,071.37 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 710.54 4,071.37 ** 14,720.00 Budgeted 10,648.63 Remaining 28 % Used Account: 135-65010-020-000 Uniforms 1,437.27 .00 1,437.27 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-020-000 Uniforms Totals: .00 1,437.27 ** 1,752.00 Budgeted 314.73 Remaining 82 % Used Account: 135-65030-020-000 Chemicals 870 02/26/2014 Feb A/P Chemicals 8,078.12 2,240.00 10,318.12 HARCROS CHEMICALS INC 33490 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,240.00 10,318.12 ** 39,000.00 Budgeted 28,681.88 Remaining 26 % Used Account: 135-65035-020-000 Small Tools 91.00 .00 91.00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 91.00 ** 1,000.00 Budgeted 909.00 Remaining 9 % Used Account: 135-65040-020-000 Safety Equipment 870 02/26/2014 Feb A/P JPChase PCards 114.08 91.96 206.04 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P Items for safety cabinet 24.59 230.63 CINTAS CORPORATION NO. 2 33482 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 116.55 230.63 ** 250.00 Budgeted 19.37 Remaining 92 % Used Account: 135-65045-020-000 Lab Supplies 5,383.58 .00 5,383.58 _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 5,383.58 ** 15,000.00 Budgeted 9,616.42 Remaining 36 % Used Account: 135-69005-020-000 Capital Expenses .00 .00 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 .00 ** 31,000.00 Budgeted 31,000.00 Remaining 0 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 20,020.00 Budgeted 20,020.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 1,422.00 Budgeted 1,422.00 Remaining 0 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 598,661.71 ** 768,011.00 Budgeted 169,349.29 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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 794 02/14/2014 PR 02-14-14 Salaries & Wages 22,149.83 2,185.07 24,334.90 PR 864 02/28/2014 Payroll 2/28/14 Salaries & Wages 2,134.58 26,469.48 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 4,319.65 26,469.48 ** 90,299.00 Budgeted 63,829.52 Remaining 29 % Used Account: 135-50010-021-000 Overtime 794 02/14/2014 PR 02-14-14 Overtime 1,835.04 4.99 1,840.03 PR 864 02/28/2014 Payroll 2/28/14 Overtime 293.48 2,133.51 PR _______________ Account: 135-50010-021-000 Overtime Totals: 298.47 2,133.51 ** 10,028.00 Budgeted 7,894.49 Remaining 21 % 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 ** 17,913.00 Budgeted 15,805.50 Remaining 12 % Used Account: 135-50017-021-000 Certification 864 02/28/2014 Payroll 2/28/14 Certification 600.00 150.00 750.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 750.00 ** 1,800.00 Budgeted 1,050.00 Remaining 42 % Used Account: 135-50020-021-000 Retirement 794 02/14/2014 PR 02-14-14 Retirement 2,751.98 196.66 2,948.64 PR 864 02/28/2014 Payroll 2/28/14 Retirement 231.51 3,180.15 PR _______________ Account: 135-50020-021-000 Retirement Totals: 428.17 3,180.15 ** 9,025.00 Budgeted 5,844.85 Remaining 35 % Used Account: 135-50026-021-000 Medical Insurance 794 02/14/2014 PR 02-14-14 Medical Insurance 6,655.15 701.20 7,356.35 PR 864 02/28/2014 Payroll 2/28/14 Medical Insurance 701.19 8,057.54 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,402.39 8,057.54 ** 23,668.00 Budgeted 15,610.46 Remaining 34 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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 794 02/14/2014 PR 02-14-14 Dental Insurance 504.99 51.30 556.29 PR 864 02/28/2014 Payroll 2/28/14 Dental Insurance 51.30 607.59 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 102.60 607.59 ** 1,703.00 Budgeted 1,095.41 Remaining 36 % Used Account: 135-50028-021-000 Vision Insurance 794 02/14/2014 PR 02-14-14 Vision Insurance 99.53 11.84 111.37 PR 864 02/28/2014 Payroll 2/28/14 Vision Insurance 11.84 123.21 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.68 123.21 ** 314.00 Budgeted 190.79 Remaining 39 % Used Account: 135-50029-021-000 Life Insurance & Other 689 02/01/2014 Feb A/P Dental, Life, STD & Other Ins 396.41 71.54 467.95 METLIFE 33414 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 71.54 467.95 ** 1,066.00 Budgeted 598.05 Remaining 44 % Used Account: 135-50030-021-000 Social Security Taxes 794 02/14/2014 PR 02-14-14 Social Security Taxes 1,726.40 116.40 1,842.80 PR 864 02/28/2014 Payroll 2/28/14 Social Security Taxes 138.77 1,981.57 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 255.17 1,981.57 ** 7,442.00 Budgeted 5,460.43 Remaining 27 % Used Account: 135-50035-021-000 Medicare Taxes 794 02/14/2014 PR 02-14-14 Medicare Taxes 403.76 27.22 430.98 PR 864 02/28/2014 Payroll 2/28/14 Medicare Taxes 32.45 463.43 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 59.67 463.43 ** 1,741.00 Budgeted 1,277.57 Remaining 27 % Used Account: 135-50040-021-000 Unemployment Taxes 794 02/14/2014 PR 02-14-14 Unemployment Taxes 7.07 2.19 9.26 PR 864 02/28/2014 Payroll 2/28/14 Unemployment Taxes .92 10.18 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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: 3.11 10.18 ** 198.00 Budgeted 187.82 Remaining 5 % Used Account: 135-50045-021-000 Workman's Compensation 51 02/01/2014 Feb Ins & W/C Expense 1,070.16 267.54 1,337.70 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 1,337.70 ** 3,276.00 Budgeted 1,938.30 Remaining 41 % Used Account: 135-50070-021-000 Employee Relations 927 02/26/2014 1/28/14-2/26/14 PCards DONUT HAVEN 110.01 8.01 118.02 DONUT HAVEN PC 927 02/26/2014 1/28/14-2/26/14 PCards CHICK-FIL-A #02892 14.00 132.02 CHICK-FIL-A #02892 PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 22.01 132.02 ** 200.00 Budgeted 67.98 Remaining 66 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 878 02/27/2014 Feb A/P Repair sewer line/3 Brook Holl 93.28 2,898.00 2,991.28 William Pratt 33509 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 2,898.00 2,991.28 ** 23,801.00 Budgeted 20,809.72 Remaining 13 % Used Account: 135-55090-021-000 Vehicle Maintenance 808 02/14/2014 Feb A/P Chains for Vac Truck 999.18 999.18 ROANOKE AUTO SUPPLY 33464 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 999.18 999.18 ** 2,000.00 Budgeted 1,000.82 Remaining 50 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 481.04 102.68 583.72 TOWN OF TROPHY CLUB 33503 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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-60010-021-000 Communications/Pagers/Mobiles Totals: 102.68 583.72 ** 1,333.00 Budgeted 749.28 Remaining 44 % Used Account: 135-60020-021-000 Electricity 808 02/14/2014 Feb A/P Electricity 1/3/14-1/31/14 5,979.99 239.76 6,219.75 TRI COUNTY ELECTRIC 33472 AP 808 02/14/2014 Feb A/P Electricity 1/3/14-1/31/14 124.10 6,343.85 TRI COUNTY ELECTRIC 33472 AP 808 02/14/2014 Feb A/P Electricity 1/3/14-1/31/14 27.65 6,371.50 TRI COUNTY ELECTRIC 33472 AP 870 02/26/2014 Feb A/P Electricity 1/11/14-2/11/14 592.30 6,963.80 HUDSON ENERGY SERVICES, LLC 33492 AP 870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 1,372.94 8,336.74 HUDSON ENERGY SERVICES, LLC 33492 AP 870 02/26/2014 Feb A/P Electricity 1/11/14-2/10/14 55.23 8,391.97 HUDSON ENERGY SERVICES, LLC 33492 AP 870 02/26/2014 Feb A/P Electricity 1/11/14-2/10/14 30.39 8,422.36 HUDSON ENERGY SERVICES, LLC 33492 AP 870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 90.28 8,512.64 HUDSON ENERGY SERVICES, LLC 33492 AP 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (363.48) 8,149.16 AR _______________ Account: 135-60020-021-000 Electricity Totals: 2,169.17 8,149.16 ** 21,178.00 Budgeted 13,028.84 Remaining 38 % 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 ** 1,711.00 Budgeted 1,711.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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-60100-021-000 Travel & per diem Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 904 02/28/2014 February Gas Log 4,172.23 841.37 5,013.60 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 841.37 5,013.60 ** 22,397.00 Budgeted 17,383.40 Remaining 22 % 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 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools 43.99 .00 43.99 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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-65035-021-000 Small Tools Totals: .00 43.99 ** 1,000.00 Budgeted 956.01 Remaining 4 % Used Account: 135-65040-021-000 Safety Equipment 870 02/26/2014 Feb A/P JPChase PCards 540.75 45.98 586.73 TOWN OF TROPHY CLUB 33503 AP _______________ Account: 135-65040-021-000 Safety Equipment Totals: 45.98 586.73 ** 500.00 Budgeted (86.73) Remaining 117 % Used Account: 135-69005-021-000 Capital Expenses 808 02/14/2014 Feb A/P Balance due Scada for Lift Sta 6,500.00 6,500.00 DHS AUTOMATION, INC 33430 AP 873 02/27/2014 Feb A/P Final pmt LS4 after acceptance 61,800.20 68,300.20 BDMR DEVELOPMENT LLC 33479 AP _______________ Account: 135-69005-021-000 Capital Expenses Totals: 68,300.20 68,300.20 ** 100,000.00 Budgeted 31,699.80 Remaining 68 % 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 Account: 135-69280-021-000 Capital Repairs .00 .00 _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 71,000.00 Budgeted 71,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 135,303.92 ** 472,170.00 Budgeted 336,866.08 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 864 02/28/2014 Payroll 2/28/14 Salaries & Wages 3,200.00 500.00 3,700.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 3,700.00 ** 10,000.00 Budgeted 6,300.00 Remaining 37 % Used Account: 135-50030-026-000 Social Security Taxes 864 02/28/2014 Payroll 2/28/14 Social Security Taxes 198.40 31.00 229.40 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 229.40 ** 620.00 Budgeted 390.60 Remaining 37 % Used Account: 135-50035-026-000 Medicare Taxes 864 02/28/2014 Payroll 2/28/14 Medicare Taxes 46.40 7.25 53.65 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 53.65 ** 145.00 Budgeted 91.35 Remaining 37 % Used Account: 135-50040-026-000 Unemployment Taxes 864 02/28/2014 Payroll 2/28/14 Unemployment Taxes 3.20 .50 3.70 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .50 3.70 ** 10.00 Budgeted 6.30 Remaining 37 % Used Account: 135-50045-026-000 Workman's Compensation 51 02/01/2014 Feb Ins & W/C Expense 11.80 2.95 14.75 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.95 14.75 ** 36.00 Budgeted 21.25 Remaining 41 % 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 43 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 4,337.45 ** 22,661.00 Budgeted 18,323.55 Remaining 19 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 794 02/14/2014 PR 02-14-14 Salaries & Wages 144,340.70 17,297.05 161,637.75 PR 864 02/28/2014 Payroll 2/28/14 Salaries & Wages 17,295.94 178,933.69 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 34,592.99 178,933.69 ** 458,721.00 Budgeted 279,787.31 Remaining 39 % Used Account: 135-50010-030-000 Overtime 794 02/14/2014 PR 02-14-14 Overtime 319.71 12.33 332.04 PR 864 02/28/2014 Payroll 2/28/14 Overtime 16.60 348.64 PR _______________ Account: 135-50010-030-000 Overtime Totals: 28.93 348.64 ** 500.00 Budgeted 151.36 Remaining 70 % 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 794 02/14/2014 PR 02-14-14 Retirement 14,239.60 1,554.39 15,793.99 PR 864 02/28/2014 Payroll 2/28/14 Retirement 1,554.66 17,348.65 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,109.05 17,348.65 ** 41,419.00 Budgeted 24,070.35 Remaining 42 % Used Account: 135-50026-030-000 Medical Insurance 794 02/14/2014 PR 02-14-14 Medical Insurance 17,933.76 2,301.30 20,235.06 PR 864 02/28/2014 Payroll 2/28/14 Medical Insurance 2,301.23 22,536.29 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,602.53 22,536.29 ** 57,923.00 Budgeted 35,386.71 Remaining 39 % Used Account: 135-50027-030-000 Dental Insurance 794 02/14/2014 PR 02-14-14 Dental Insurance 1,499.44 170.19 1,669.63 PR 864 02/28/2014 Payroll 2/28/14 Dental Insurance 170.23 1,839.86 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 1,839.86 ** 5,100.00 Budgeted 3,260.14 Remaining 36 % Used Account: 135-50028-030-000 Vision Insurance 794 02/14/2014 PR 02-14-14 Vision Insurance 329.21 40.78 369.99 PR 864 02/28/2014 Payroll 2/28/14 Vision Insurance 40.84 410.83 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.62 410.83 ** 1,087.00 Budgeted 676.17 Remaining 38 % Used Account: 135-50029-030-000 Life Insurance & Other 689 02/01/2014 Feb A/P Dental, Life, STD & Other Ins 1,837.63 313.56 2,151.19 METLIFE 33414 AP 873 02/27/2014 Feb A/P Jan Admin/FSA 39.10 2,190.29 BenefitMall 33480 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 352.66 2,190.29 ** 4,483.00 Budgeted 2,292.71 Remaining 49 % Used Account: 135-50030-030-000 Social Security Taxes 794 02/14/2014 PR 02-14-14 Social Security Taxes 9,357.26 1,012.29 10,369.55 PR 864 02/28/2014 Payroll 2/28/14 Social Security Taxes 1,000.50 11,370.05 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,012.79 11,370.05 ** 28,659.00 Budgeted 17,288.95 Remaining 40 % Used Account: 135-50035-030-000 Medicare Taxes 794 02/14/2014 PR 02-14-14 Medicare Taxes 2,188.40 236.75 2,425.15 PR 864 02/28/2014 Payroll 2/28/14 Medicare Taxes 233.99 2,659.14 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 470.74 2,659.14 ** 6,702.00 Budgeted 4,042.86 Remaining 40 % Used Account: 135-50040-030-000 Unemployment Taxes 794 02/14/2014 PR 02-14-14 Unemployment Taxes 48.20 5.54 53.74 PR 864 02/28/2014 Payroll 2/28/14 Unemployment Taxes 4.44 58.18 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 9.98 58.18 ** 63.00 Budgeted 4.82 Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 51 02/01/2014 Feb Ins & W/C Expense 514.52 128.63 643.15 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.63 643.15 ** 1,575.00 Budgeted 931.85 Remaining 41 % 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 927 02/26/2014 1/28/14-2/26/14 PCards A TOUCH OF HEAVEN 2,460.91 90.67 2,551.58 A TOUCH OF HEAVEN PC 927 02/26/2014 1/28/14-2/26/14 PCards CHICK-FIL-A #02892 14.00 2,565.58 CHICK-FIL-A #02892 PC 927 02/26/2014 1/28/14-2/26/14 PCards A TOUCH OF HEAVEN 69.02 2,634.60 A TOUCH OF HEAVEN PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 173.69 2,634.60 ** 5,000.00 Budgeted 2,365.40 Remaining 53 % Used Account: 135-55030-030-000 Software & Support 870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 18,656.24 645.50 19,301.74 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P Pitney Bowes, Kyocera, Acclaim 442.50 19,744.24 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P IT BOA PCards 300.99 20,045.23 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P IT BOA PCards 259.46 20,304.69 TOWN OF TROPHY CLUB 33503 AP 875 02/27/2014 Feb A/P CareNow, Shi, Premier, Symonds 47.50 20,352.19 TOWN OF TROPHY CLUB 33507 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 1,695.95 20,352.19 ** 59,698.00 Budgeted 39,345.81 Remaining 34 % Used Account: 135-55070-030-000 Independent Labor 808 02/14/2014 Feb A/P Record CAC meeting 2,235.45 30.00 2,265.45 MIGUEL CRUZ 33453 AP 808 02/14/2014 Feb A/P Record CAC Meeting 37.50 2,302.95 MIGUEL CRUZ 33453 AP 870 02/26/2014 Feb A/P Record MUD meeting 75.00 2,377.95 MIGUEL CRUZ 33499 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 142.50 2,377.95 ** 7,700.00 Budgeted 5,322.05 Remaining 31 % Used Account: 135-55080-030-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (1,760.13) (188.84) (1,948.97) AR _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: (188.84) (1,948.97) ** 4,500.00 Budgeted 6,448.97 Remaining -43 % Used Account: 135-55100-030-000 Building Maint & Supplies 808 02/14/2014 Feb A/P Rug Service 1,516.18 94.42 1,610.60 G & K SERVICES 33438 AP 808 02/14/2014 Feb A/P Rug Service 94.42 1,705.02 G & K SERVICES 33438 AP 808 02/14/2014 Feb A/P Rug Service 94.42 1,799.44 G & K SERVICES 33438 AP 808 02/14/2014 Feb A/P Rug Service 94.42 1,893.86 G & K SERVICES 33438 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 377.68 1,893.86 ** 6,500.00 Budgeted 4,606.14 Remaining 29 % Used Account: 135-55120-030-000 Cleaning Services 808 02/14/2014 Feb A/P Janitorial Service/Jan 4,784.91 1,594.97 6,379.88 MEMBER'S BUILDING MAINTENANCE 33452 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 6,379.88 ** 19,140.00 Budgeted 12,760.12 Remaining 33 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55161-030-000 Outside Services-Town Semo 38,524.00 .00 38,524.00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 38,524.00 ** 77,048.00 Budgeted 38,524.00 Remaining 50 % 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 48 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 808 02/14/2014 Feb A/P Jan Utility bills 1,764.35 566.00 2,330.35 DATAPROSE LLC 33428 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 566.00 2,330.35 ** 6,808.00 Budgeted 4,477.65 Remaining 34 % Used Account: 135-60005-030-000 Telephone 870 02/26/2014 Feb A/P IT BOA PCards 2,916.11 957.68 3,873.79 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P IT BOA PCards 933.57 4,807.36 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P Answering service 180.00 4,987.36 KEYSTONE PARK SECRETARIAL 33496 AP _______________ Account: 135-60005-030-000 Telephone Totals: 2,071.25 4,987.36 ** 11,250.00 Budgeted 6,262.64 Remaining 44 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 879.79 140.67 1,020.46 TOWN OF TROPHY CLUB 33503 AP 864 02/28/2014 Payroll 2/28/14 Communications/Pagers/Mobiles 150.00 1,170.46 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 290.67 1,170.46 ** 3,589.00 Budgeted 2,418.54 Remaining 33 % Used Account: 135-60020-030-000 Electricity/Gas 7,243.58 .00 7,243.58 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 7,243.58 ** 15,171.00 Budgeted 7,927.42 Remaining 48 % Used Account: 135-60025-030-000 Water 808 02/14/2014 Feb A/P Jan water billed 124.67 155.52 280.19 TROPHY CLUB MUD (WATER BILLS) 33473 AP 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (52.11) 228.08 AR _______________ Account: 135-60025-030-000 Water Totals: 103.41 228.08 ** 1,500.00 Budgeted 1,271.92 Remaining 15 % Used Account: 135-60035-030-000 Postage 808 02/14/2014 Feb A/P Jan Utility bills 6,994.20 1,648.48 8,642.68 DATAPROSE LLC 33428 AP 870 02/26/2014 Feb A/P Pitney Bowes, Kyocera, Acclaim 47.99 8,690.67 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P Overnight letter-Audit to TCEQ 5.77 8,696.44 FEDERAL EXPRESS CORP 33486 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 932 02/28/2014 MUD Postage Meter usage/Feb 6,994.20 332.85 9,029.29 GL _______________ Account: 135-60035-030-000 Postage Totals: 2,035.09 9,029.29 ** 28,500.00 Budgeted 19,470.71 Remaining 32 % Used Account: 135-60040-030-000 Service Charges & Fees 804 02/01/2014 Dec Account analysis FF Bank 9,530.79 250.00 9,780.79 GL 928 02/04/2014 Credit card fees/Jan 96.90 9,877.69 GL 928 02/04/2014 Credit card fees/Jan 2,136.11 12,013.80 GL 928 02/04/2014 Credit card fees/Jan 50.52 12,064.32 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,533.53 12,064.32 ** 28,330.00 Budgeted 16,265.68 Remaining 43 % Used Account: 135-60050-030-000 Bad Debt Expense 3,712.56 .00 3,712.56 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 3,712.56 ** 1,500.00 Budgeted (2,212.56) Remaining 248 % Used Account: 135-60055-030-000 Insurance 51 02/01/2014 Feb Ins & W/C Expense 17,112.17 4,269.73 21,381.90 GL 808 02/14/2014 Feb A/P Bond/Jennifer 50.00 21,431.90 VICTOR O SCHINNERER & CO, INC 33474 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,319.73 21,431.90 ** 53,561.00 Budgeted 32,129.10 Remaining 40 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 126.00 .00 126.00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 126.00 ** 1,000.00 Budgeted 874.00 Remaining 13 % 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 50 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-60080-030-000 Schools & Training 927 02/26/2014 1/28/14-2/26/14 PCards TRWA 502.30 125.00 627.30 TRWA PC 927 02/26/2014 1/28/14-2/26/14 PCards TRWA 399.00 1,026.30 TRWA PC 927 02/26/2014 1/28/14-2/26/14 PCards ACFE 175.00 1,201.30 ACFE PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 699.00 1,201.30 ** 7,500.00 Budgeted 6,298.70 Remaining 16 % Used Account: 135-60100-030-000 Travel & per diem 703.16 .00 703.16 _______________ Account: 135-60100-030-000 Travel & per diem Totals: .00 703.16 ** 5,000.00 Budgeted 4,296.84 Remaining 14 % 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 .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 927 02/26/2014 1/28/14-2/26/14 PCards LETS JUMP 156.25 156.25 LETS JUMP PC 927 02/26/2014 1/28/14-2/26/14 PCards AMAZON MKTPLACE PMTS 32.27 188.52 AMAZON MKTPLACE PMTS PC 927 02/26/2014 1/28/14-2/26/14 PCards NEW RESOURCES GROUP, I 166.20 354.72 NEW RESOURCES GROUP, I PC 870 02/26/2014 Feb A/P Publication 74.50 429.22 DENTON PUBLISHING CO 33484 AP 870 02/26/2014 Feb A/P Publication 79.40 508.62 DENTON PUBLISHING CO 33484 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-60125-030-000 Advertising Totals: 508.62 508.62 ** 2,500.00 Budgeted 1,991.38 Remaining 20 % 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 927 02/26/2014 1/28/14-2/26/14 PCards HOT & CREAMY DONUTS 283.08 16.75 299.83 HOT & CREAMY DONUTS PC 927 02/26/2014 1/28/14-2/26/14 PCards SQ *STARBUCKS #06552 T 17.54 317.37 SQ *STARBUCKS #06552 T PC 927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction (200.00) 117.37 PC 927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction (200.00) (82.63) PC 927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction (200.00) (282.63) PC 927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction 200.00 (82.63) CORNER STORE 2302 PC 927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction 200.00 117.37 CORNER STORE 2091 PC 927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction 200.00 317.37 CORNER STORE 2091 PC 875 02/27/2014 Feb A/P Reimburse Petty Cash 29.17 346.54 TROPHY CLUB MUD PETTY CASH 33508 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 63.46 346.54 ** 22,870.00 Budgeted 22,523.46 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 52 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 870 02/26/2014 Feb A/P IT BOA PCards 1,677.95 32.56 1,710.51 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P CareNow, Shi 13.15 1,723.66 TOWN OF TROPHY CLUB 33503 AP 870 02/26/2014 Feb A/P CareNow, Shi 22.00 1,745.66 TOWN OF TROPHY CLUB 33503 AP _______________ Account: 135-65055-030-000 Hardware Totals: 67.71 1,745.66 ** 13,562.00 Budgeted 11,816.34 Remaining 13 % Used Account: 135-65085-030-000 Office Supplies 808 02/14/2014 Feb A/P Office Supplies 1,576.94 42.70 1,619.64 OFFICE DEPOT, INC 33456 AP 808 02/14/2014 Feb A/P Office Supplies 11.49 1,631.13 OFFICE DEPOT, INC 33456 AP 808 02/14/2014 Feb A/P Office Supplies 58.33 1,689.46 OFFICE DEPOT, INC 33456 AP 927 02/26/2014 1/28/14-2/26/14 PCards KELLER TROPHY AND AWAR 89.85 1,779.31 KELLER TROPHY AND AWAR PC 927 02/26/2014 1/28/14-2/26/14 PCards OFFICE DEPOT #2255 81.13 1,860.44 OFFICE DEPOT #2255 PC 927 02/26/2014 1/28/14-2/26/14 PCards OFFICE DEPOT #406 59.93 1,920.37 OFFICE DEPOT #406 PC 927 02/26/2014 1/28/14-2/26/14 PCards AMAZON MKTPLACE PMTS 13.26 1,933.63 AMAZON MKTPLACE PMTS PC 870 02/26/2014 Feb A/P JPChase PCards 71.29 2,004.92 TOWN OF TROPHY CLUB 33503 AP 875 02/27/2014 Feb A/P CareNow, Shi, Premier, Symonds 132.00 2,136.92 TOWN OF TROPHY CLUB 33507 AP 945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (43.48) 2,093.44 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 516.50 2,093.44 ** 9,100.00 Budgeted 7,006.56 Remaining 23 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1,246.33 .00 1,246.33 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 1,246.33 ** 5,732.00 Budgeted 4,485.67 Remaining 22 % Used Account: 135-65095-030-000 Maintenance Supplies 927 02/26/2014 1/28/14-2/26/14 PCards SAMSCLUB #4795 815.54 88.71 904.25 SAMSCLUB #4795 PC 927 02/26/2014 1/28/14-2/26/14 PCards SAMSCLUB #4795 207.24 1,111.49 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 295.95 1,111.49 ** 2,500.00 Budgeted 1,388.51 Remaining 44 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 51.00 .00 51.00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 51.00 ** 200.00 Budgeted 149.00 Remaining 26 % Used Account: 135-65105-030-000 Printing 1,401.00 .00 1,401.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 1,401.00 ** 4,000.00 Budgeted 2,599.00 Remaining 35 % Used Account: 135-69170-030-000 Copier Lease Installments 870 02/26/2014 Feb A/P Pitney Bowes, Kyocera, Acclaim 770.55 256.85 1,027.40 TOWN OF TROPHY CLUB 33503 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 1,027.40 ** 3,450.00 Budgeted 2,422.60 Remaining 30 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 390,524.03 ** 1,055,199.00 Budgeted 664,674.97 Remaining 37 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/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 808 02/14/2014 Feb A/P Legal 85,943.22 1,350.25 87,293.47 THE LISTON LAW FIRM, P.C. 33469 AP 808 02/14/2014 Feb A/P Legal 9,515.00 96,808.47 FREEMAN & CORBETT 33436 AP _______________ Account: 135-55045-039-000 Legal Totals: 10,865.25 96,808.47 ** 131,300.00 Budgeted 34,491.53 Remaining 74 % 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 4,329.38 .00 4,329.38 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,329.38 ** 10,000.00 Budgeted 5,670.62 Remaining 43 % 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: ------------------------------------------------------------------------------------------------ 124,789.25 ** 166,940.00 Budgeted 42,150.75 Remaining 75 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 234,930.23 .00 Budgeted (234,930.23) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 2/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 929 02/28/2014 Bank Statement Interest/Feb (42.62) (4.07) (46.69) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (4.07) (46.69) ** .00 Budgeted 46.69 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (46.69) ** .00 Budgeted 46.69 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 2/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 Department 10 Totals: ------------------------------------------------------------------------------------------------ 82,629.40 ** .00 Budgeted (82,629.40) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 82,582.71 .00 Budgeted (82,582.71) Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET FEBRUARY 28, 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 493,742 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 29,196 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 527,784 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 29,196 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 29,196 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 480,709 TOTAL FUND BALANCE 498,588 TOTAL LIABILITIES AND FUND BALANCE 527,784 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 11:19 03/07/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/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- 35,997.50- 368,942.90- 94.791 20,273.10- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 1.39 -.056 2,501.39- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 618.87- 634.06- 39.629 965.94- Subtotal: 393,316.00- 393,316.00- 36,616.37- 369,575.57- 93.964 23,740.43- 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- 12.09- 20.67- 5.512 354.33- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- 214,279.00- 100.000 Subtotal: 214,654.00- 214,654.00- 214,291.09- 214,299.67- 99.835 354.33- Program number: 624,495.00- 624,495.00- 250,907.46- 583,875.24- 93.496 40,619.76- Department number: Revenues 624,495.00- 624,495.00- 250,907.46- 583,875.24- 93.496 40,619.76- Revenues Subtotal ----------- 624,495.00- 624,495.00- 250,907.46- 583,875.24- 93.496 40,619.76- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 11:19 03/07/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/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 2,300.00 533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 103,166.25 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 103,166.25 103,166.25 16.520 521,328.75 Program number: 624,495.00 624,495.00 103,166.25 103,166.25 16.520 521,328.75 Department number: Administration 624,495.00 624,495.00 103,166.25 103,166.25 16.520 521,328.75 Expenditures Subtotal ----------- 624,495.00 624,495.00 103,166.25 103,166.25 16.520 521,328.75 Fund number: 533 MUD 1 I&S Consolidated 147,741.21- 480,708.99- 480,708.99 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/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 886 02/01/2014 Property Taxes/Assessments (332,945.40) (7,619.83) (340,565.23) GL 887 02/03/2014 Property Taxes/Assessments (3,550.54) (344,115.77) GL 888 02/04/2014 Property Taxes/Assessments (2,469.18) (346,584.95) GL 889 02/05/2014 Property Taxes/Assessments (6,266.79) (352,851.74) GL 890 02/06/2014 Property Taxes/Assessments (1,447.84) (354,299.58) GL 891 02/07/2014 Property Taxes/Assessments (5,928.14) (360,227.72) GL 892 02/10/2014 Property Taxes/Assessments (3.47) (360,231.19) GL 893 02/12/2014 Property Taxes/Assessments (310.86) (360,542.05) GL 894 02/13/2014 Property Taxes/Assessments (606.42) (361,148.47) GL 895 02/14/2014 Property Taxes/Assessments (43.89) (361,192.36) GL 896 02/18/2014 Property Taxes/Assessments (7,206.72) (368,399.08) GL 897 02/20/2014 Property Taxes/Assessments (20.47) (368,419.55) GL 898 02/24/2014 Property Taxes/Assessments (221.58) (368,641.13) GL 899 02/25/2014 Property Taxes/Assessments (7.85) (368,648.98) GL 900 02/27/2014 Property Taxes/Assessments (124.07) (368,773.05) GL 901 02/28/2014 Property Taxes/Assessments (169.85) (368,942.90) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (35,997.50) (368,942.90) ** (389,216.00) Budgeted (20,273.10) Remaining 95 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1.39 .00 1.39 _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 1.39 ** (2,500.00) Budgeted (2,501.39) Remaining 0 % Used Account: 533-40015-000-000 Property Taxes/P & I 944 02/04/2014 Property Taxes/Assessments (15.19) (8.09) (23.28) GL 890 02/06/2014 Property Taxes/Assessments (5.70) (28.98) GL 892 02/10/2014 Property Taxes/Assessments (5.24) (34.22) GL 893 02/12/2014 Property Taxes/Assessments (19.50) (53.72) GL 894 02/13/2014 Property Taxes/Assessments (38.77) (92.49) GL 895 02/14/2014 Property Taxes/Assessments (3.07) (95.56) GL 896 02/18/2014 Property Taxes/Assessments (504.49) (600.05) GL 897 02/20/2014 Property Taxes/Assessments (1.43) (601.48) GL 898 02/24/2014 Property Taxes/Assessments (15.50) (616.98) GL 899 02/25/2014 Property Taxes/Assessments (.55) (617.53) GL 900 02/27/2014 Property Taxes/Assessments (8.69) (626.22) GL 901 02/28/2014 Property Taxes/Assessments (7.84) (634.06) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/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-40015-000-000 Property Taxes/P & I Totals: (618.87) (634.06) ** (1,600.00) Budgeted (965.94) Remaining 40 % 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 929 02/28/2014 Bank Statement Interest/Feb (8.58) (12.09) (20.67) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (12.09) (20.67) ** (375.00) Budgeted (354.33) Remaining 6 % Used Account: 533-49015-000-000 Lease/Rental Income 902 02/04/2014 FD Rent to I&S (214,279.00) (214,279.00) GL _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: (214,279.00) (214,279.00) ** (214,279.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (583,875.24) ** (624,495.00) Budgeted (40,619.76) Remaining 93 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 11:19 03/07/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/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 .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 .00 ** 2,300.00 Budgeted 2,300.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense 880 02/27/2014 Wires for Bond payments M1 UT Bonds 2010 (Fire Sta) 38,091.25 38,091.25 GL 880 02/27/2014 Wires for Bond payments M1 Series 2012 28,525.00 66,616.25 GL 881 02/28/2014 Wire for Bond Payment M1 Series 2013 36,550.00 103,166.25 GL _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: 103,166.25 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: ------------------------------------------------------------------------------------------------ 103,166.25 ** 624,495.00 Budgeted 521,328.75 Remaining 17 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (480,708.99) .00 Budgeted 480,708.99 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (807,540.43) **** .00 Budgeted 807,540.43 Remaining 0 % Used ******* End of Report *********