Loading...
HomeMy WebLinkAboutOctober FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 31, 2013 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 537,023 PREPAID EXPENSES 18,392 ADVALOREM PROPERTY TAXES RECEIVABLE 929,195 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 300,987 UTILITY AND OTHER ACCOUNTS RECEIVABLE 676 TOTAL ASSETS 1,786,273 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,230,182 ACCOUNTS AND OTHER PAYABLES 83,977 TOTAL LIABILITIES 1,314,159 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE 2,141 UNASSIGNED FUND BALANCE 493,547 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (23,574) TOTAL FUND BALANCE 472,114 TOTAL LIABILITIES AND FUND BALANCE 1,786,273 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 18:59 11/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2013 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- 5,573.09- 5,573.09- 1.825 299,871.91- 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 17,437.64- 17,437.64- 1.880 910,117.36- 122-40011-000-000 Property Taxes/Fire-Delinquent 105.52 105.52 105.52- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 68.36- 68.36- 1.519 4,431.64- Subtotal: 1,238,250.00- 1,238,250.00- 22,973.57- 22,973.57- 1.855 1,215,276.43- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 6,000.00- Subtotal: 6,000.00- 6,000.00- 6,000.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 700.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- 10,700.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 6,000.00- Subtotal: 6,000.00- 6,000.00- 6,000.00- Program number: 1,260,950.00- 1,260,950.00- 22,973.57- 22,973.57- 1.822 1,237,976.43- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 22,973.57- 22,973.57- 1.822 1,237,976.43- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 22,973.57- 22,973.57- 1.822 1,237,976.43- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 18:59 11/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 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 24,181.65 24,181.65 5.304 431,734.35 122-50010-045-000 Overtime 44,225.00 44,225.00 3,174.34 3,174.34 7.178 41,050.66 122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,529.00 122-50016-045-000 Longevity 4,768.00 4,768.00 4,768.00 122-50017-045-000 Certification 4,350.00 4,350.00 376.89 376.89 8.664 3,973.11 122-50020-045-000 Retirement 70,991.00 70,991.00 3,728.18 3,728.18 5.252 67,262.82 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,008.49 4,008.49 7.036 52,959.51 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 326.19 326.19 7.711 3,903.81 122-50028-045-000 Vision Insurance 892.00 892.00 68.30 68.30 7.657 823.70 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 306.79 306.79 7.219 3,943.21 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 1,562.12 1,562.12 4.737 31,417.88 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 365.20 365.20 4.735 7,347.80 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 .81 .81 .036 2,258.19 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.79 662.79 7.611 8,045.21 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 500.00 122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 38,761.75 38,761.75 5.437 674,117.25 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 5,000.00 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 218.40 218.40 1.067 20,253.60 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 14,850.00 Subtotal: 49,004.00 49,004.00 218.40 218.40 .446 48,785.60 122-60005-045-000 Telephone 100.00 100.00 100.00 122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 457.38 457.38 10.795 3,779.62 122-60020-045-000 Electricity/Gas 6,568.00 6,568.00 203.05 203.05 3.092 6,364.95 122-60025-045-000 Water 1,500.00 1,500.00 108.39 108.39 7.226 1,391.61 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 122-60035-045-000 Postage 100.00 100.00 3.10 3.10 3.100 96.90 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 1,009.25 8.334 11,100.75 122-60066-045-000 Publications/Books/Subscrips 400.00 400.00 400.00 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 1,577.76 1,577.76 10.394 13,602.24 122-60080-045-000 Schools & Training 4,280.00 4,280.00 1,064.00 1,064.00 24.860 3,216.00 122-60096-045-000 Emergency Management 2,000.00 2,000.00 1,000.00 1,000.00 50.000 1,000.00 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 1,064.82 1,064.82 23.265 3,512.18 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 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 2,000.00 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 1,000.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 18:59 11/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 276,531.00 276,531.00 6,828.92 6,828.92 2.469 269,702.08 122-65005-045-000 Fuel & Lube 11,698.00 11,698.00 738.03 738.03 6.309 10,959.97 122-65010-045-000 Uniforms 3,360.00 3,360.00 3,360.00 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 7,600.00 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 2,500.00 122-65085-045-000 Office Supplies 1,000.00 1,000.00 1,000.00 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 27,258.00 738.03 738.03 2.708 26,519.97 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 3,031.00 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 195,278.00 Program number: 1,260,950.00 1,260,950.00 46,547.10 46,547.10 3.691 1,214,402.90 Department number: Fire 1,260,950.00 1,260,950.00 46,547.10 46,547.10 3.691 1,214,402.90 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 46,547.10 46,547.10 3.691 1,214,402.90 Fund number: 122 Trophy Club MUD Fire Dept. 23,573.53 23,573.53 23,573.53- . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 202 10/16/2013 Property Taxes/Assessments (221.26) (221.26) GL 203 10/17/2013 Property Taxes/Assessments (462.84) (684.10) GL 206 10/18/2013 Property Taxes/Assessments (49.44) (733.54) GL 207 10/21/2013 Property Taxes/Assessments (1,623.90) (2,357.44) GL 208 10/22/2013 Property Taxes/Assessments (339.37) (2,696.81) GL 209 10/23/2013 Property Taxes/Assessments (415.49) (3,112.30) GL 210 10/24/2013 Property Taxes/Assessments (112.51) (3,224.81) GL 211 10/25/2013 Property Taxes/Assessments (66.71) (3,291.52) GL 212 10/28/2013 Property Taxes/Assessments (480.52) (3,772.04) GL 213 10/29/2013 Property Taxes/Assessments (1,024.74) (4,796.78) GL 215 10/31/2013 Property Taxes/Assessments (776.31) (5,573.09) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (5,573.09) (5,573.09) ** (305,445.00) Budgeted (299,871.91) Remaining 2 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 199 10/14/2013 Property Taxes/Assessments (330.86) (330.86) GL 200 10/15/2013 Property Taxes/Assessments (175.93) (506.79) GL 202 10/16/2013 Property Taxes/Assessments (694.97) (1,201.76) GL 203 10/17/2013 Property Taxes/Assessments (94.72) (1,296.48) GL 207 10/21/2013 Property Taxes/Assessments (3,399.32) (4,695.80) GL 208 10/22/2013 Property Taxes/Assessments (1,301.81) (5,997.61) GL 209 10/23/2013 Property Taxes/Assessments (2,412.86) (8,410.47) GL 210 10/24/2013 Property Taxes/Assessments (2,727.62) (11,138.09) GL 211 10/25/2013 Property Taxes/Assessments (1,126.17) (12,264.26) GL 212 10/28/2013 Property Taxes/Assessments (1,452.04) (13,716.30) GL 213 10/29/2013 Property Taxes/Assessments (1,037.05) (14,753.35) GL 214 10/30/2013 Property Taxes/Assessments (214.69) (14,968.04) GL 215 10/31/2013 Property Taxes/Assessments (2,469.60) (17,437.64) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (17,437.64) (17,437.64) ** (927,555.00) Budgeted (910,117.36) Remaining 2 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 199 10/14/2013 Property Taxes/Assessments 249.59 249.59 GL 202 10/16/2013 Property Taxes/Assessments (174.69) 74.90 GL 211 10/25/2013 Property Taxes/Assessments (25.85) 49.05 GL 212 10/28/2013 Property Taxes/Assessments (1.46) 47.59 GL 213 10/29/2013 Property Taxes/Assessments 100.19 147.78 GL 215 10/31/2013 Property Taxes/Assessments (42.26) 105.52 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 105.52 105.52 ** .00 Budgeted (105.52) Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I .00 .00 _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 .00 ** (750.00) Budgeted (750.00) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 199 10/14/2013 Property Taxes/Assessments (17.07) (17.07) GL 202 10/16/2013 Property Taxes/Assessments (36.68) (53.75) GL 211 10/25/2013 Property Taxes/Assessments (5.42) (59.17) GL 212 10/28/2013 Property Taxes/Assessments (.31) (59.48) GL 215 10/31/2013 Property Taxes/Assessments (8.88) (68.36) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (68.36) (68.36) ** (4,500.00) Budgeted (4,431.64) Remaining 2 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft .00 .00 _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 .00 ** (6,000.00) Budgeted (6,000.00) Remaining 0 % Used Account: 122-43400-000-000 Fire Inspections .00 .00 _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 .00 ** (700.00) Budgeted (700.00) Remaining 0 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-49900-000-000 Miscellaneous Income .00 .00 _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 .00 ** (6,000.00) Budgeted (6,000.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (22,973.57) ** (1,260,950.00) Budgeted (1,237,976.43) Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 136 10/11/2013 FD P/R 10/1-10/5/13 6,074.77 6,074.77 GL 138 10/11/2013 D Thomas Cola 1,026.93 7,101.70 GL 139 10/25/2013 FD Payroll 10/25/13 17,079.95 24,181.65 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 24,181.65 24,181.65 ** 455,916.00 Budgeted 431,734.35 Remaining 5 % Used Account: 122-50010-045-000 Overtime 139 10/25/2013 FD Payroll 10/25/13 3,174.34 3,174.34 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,174.34 3,174.34 ** 44,225.00 Budgeted 41,050.66 Remaining 7 % Used Account: 122-50011-045-000 DPS Holiday Pay .00 .00 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 .00 ** 13,529.00 Budgeted 13,529.00 Remaining 0 % Used Account: 122-50016-045-000 Longevity .00 .00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 .00 ** 4,768.00 Budgeted 4,768.00 Remaining 0 % Used Account: 122-50017-045-000 Certification 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Cert 363.50 363.50 GL 136 10/11/2013 FD P/R 10/1-10/5/13 13.39 376.89 GL _______________ Account: 122-50017-045-000 Certification Totals: 376.89 376.89 ** 4,350.00 Budgeted 3,973.11 Remaining 9 % Used Account: 122-50020-045-000 Retirement 136 10/11/2013 FD P/R 10/1-10/5/13 840.13 840.13 GL 138 10/11/2013 D Thomas Cola 144.38 984.51 GL 139 10/25/2013 FD Payroll 10/25/13 2,743.67 3,728.18 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50020-045-000 Retirement Totals: 3,728.18 3,728.18 ** 70,991.00 Budgeted 67,262.82 Remaining 5 % Used Account: 122-50026-045-000 Medical Insurance 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Medical Insurance 1,476.96 1,476.96 GL 136 10/11/2013 FD P/R 10/1-10/5/13 820.35 2,297.31 GL 139 10/25/2013 FD Payroll 10/25/13 1,711.18 4,008.49 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,008.49 4,008.49 ** 56,968.00 Budgeted 52,959.51 Remaining 7 % Used Account: 122-50027-045-000 Dental Insurance 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Dental 104.86 104.86 GL 136 10/11/2013 FD P/R 10/1-10/5/13 58.19 163.05 GL 139 10/25/2013 FD Payroll 10/25/13 163.14 326.19 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 326.19 326.19 ** 4,230.00 Budgeted 3,903.81 Remaining 8 % Used Account: 122-50028-045-000 Vision Insurance 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Vision 21.93 21.93 GL 136 10/11/2013 FD P/R 10/1-10/5/13 12.16 34.09 GL 139 10/25/2013 FD Payroll 10/25/13 34.21 68.30 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 68.30 68.30 ** 892.00 Budgeted 823.70 Remaining 8 % Used Account: 122-50029-045-000 Life Insurance & Other 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Life Ins & Other 98.58 98.58 GL 136 10/11/2013 FD P/R 10/1-10/5/13 54.73 153.31 GL 139 10/25/2013 FD Payroll 10/25/13 153.48 306.79 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 306.79 306.79 ** 4,250.00 Budgeted 3,943.21 Remaining 7 % Used Account: 122-50030-045-000 Social Security Taxes 136 10/11/2013 FD P/R 10/1-10/5/13 340.71 340.71 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 138 10/11/2013 D Thomas Cola 63.67 404.38 GL 139 10/25/2013 FD Payroll 10/25/13 1,157.74 1,562.12 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 1,562.12 1,562.12 ** 32,980.00 Budgeted 31,417.88 Remaining 5 % Used Account: 122-50035-045-000 Medicare Taxes 136 10/11/2013 FD P/R 10/1-10/5/13 79.61 79.61 GL 138 10/11/2013 D Thomas Cola 14.89 94.50 GL 139 10/25/2013 FD Payroll 10/25/13 270.70 365.20 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 365.20 365.20 ** 7,713.00 Budgeted 7,347.80 Remaining 5 % Used Account: 122-50040-045-000 Unemployment Taxes 136 10/11/2013 FD P/R 10/1-10/5/13 .08 .08 GL 139 10/25/2013 FD Payroll 10/25/13 .73 .81 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .81 .81 ** 2,259.00 Budgeted 2,258.19 Remaining 0 % Used Account: 122-50045-045-000 Workman's Compensation 116 10/01/2013 FD Oct W/C expense 662.79 662.79 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.79 662.79 ** 8,708.00 Budgeted 8,045.21 Remaining 8 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-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 Account: 122-55045-045-000 Legal .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 255 10/31/2013 Recode Equip & Bldg Maint/Oct 2.87 2.87 GL 255 10/31/2013 Recode Equip & Bldg Maint/Oct 215.53 218.40 GL _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 218.40 218.40 ** 20,472.00 Budgeted 20,253.60 Remaining 1 % Used Account: 122-55090-045-000 Vehicle Maintenance .00 .00 _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 .00 ** 14,850.00 Budgeted 14,850.00 Remaining 0 % Used Account: 122-55095-045-000 Equipment Maintenance 226 10/26/2013 10/1-10/26 PCards AUTOZONE #4206 2.87 2.87 AUTOZONE #4206 PC 255 10/31/2013 Recode Equip & Bldg Maint/Oct (2.87) .00 GL _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-55100-045-000 Building Maintenance 219 10/03/2013 Fire Dept Oct Cable (120.00) (120.00) GL 226 10/26/2013 10/1-10/26 PCards ATT*BILL PAYMENT 133.68 13.68 ATT*BILL PAYMENT PC 226 10/26/2013 10/1-10/26 PCards ATT*BILL PAYMENT 152.83 166.51 ATT*BILL PAYMENT PC 247 10/31/2013 Oct A/P Rug Service Fire Station 24.51 191.02 G & K SERVICES 33154 AP 247 10/31/2013 Oct A/P Rug Service Fire Station 24.51 215.53 G & K SERVICES 33154 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 255 10/31/2013 Recode Equip & Bldg Maint/Oct (215.53) .00 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-60005-045-000 Telephone .00 .00 _______________ Account: 122-60005-045-000 Telephone Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Cells 75.00 75.00 GL 155 10/30/2013 Oct A/P Copier lease, FD Communication 382.38 457.38 TOWN OF TROPHY CLUB 33135 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 457.38 457.38 ** 4,237.00 Budgeted 3,779.62 Remaining 11 % Used Account: 122-60020-045-000 Electricity/Gas 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 363.28 363.28 HUDSON ENERGY SERVICES, LLC 33097 AP 155 10/30/2013 Oct A/P Fire Station Gas-10/1-10/18 42.82 406.10 ATMOS ENERGY 33123 AP 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (203.05) 203.05 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 203.05 203.05 ** 6,568.00 Budgeted 6,364.95 Remaining 3 % Used Account: 122-60025-045-000 Water 247 10/31/2013 Oct A/P October water 216.78 216.78 TROPHY CLUB MUD (WATER BILLS) 33175 AP 234 10/31/2013 Town billed Inv 1101 AR 20131031-20131031 User: (108.39) 108.39 AR _______________ Account: 122-60025-045-000 Water Totals: 108.39 108.39 ** 1,500.00 Budgeted 1,391.61 Remaining 7 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 214,279.00 Budgeted 214,279.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60035-045-000 Postage 235 10/31/2013 October Postage meter usage 3.10 3.10 GL _______________ Account: 122-60035-045-000 Postage Totals: 3.10 3.10 ** 100.00 Budgeted 96.90 Remaining 3 % Used Account: 122-60055-045-000 Insurance 47 10/01/2013 Oct Ins & W/C Expense 1,009.25 1,009.25 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 1,009.25 ** 12,110.00 Budgeted 11,100.75 Remaining 8 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 226 10/26/2013 10/1-10/26 PCards TX COMM ON FIRE PR 1,477.76 1,477.76 TX COMM ON FIRE PR PC 247 10/31/2013 Oct A/P 10/1/13-9/30/14 Membership due 100.00 1,577.76 FIRE INSTRUCTORS ASSOC OF N TX 33151 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 1,577.76 1,577.76 ** 15,180.00 Budgeted 13,602.24 Remaining 10 % Used Account: 122-60080-045-000 Schools & Training 36 10/03/2013 Town Billing Inv 1090 AR 20131001-20131031 User: (680.00) (680.00) AR 130 10/24/2013 October A/P Haz-Mat Cert-hurd 85.00 (595.00) TX COMM ON FIRE PROTECTION 33115 AP 130 10/24/2013 October A/P FD Training 1,360.00 765.00 MEDIC-CE.COM, LLC 33101 AP 226 10/26/2013 10/1-10/26 PCards 1105 MEDIA *EVENTS 299.00 1,064.00 1105 MEDIA *EVENTS PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 1,064.00 1,064.00 ** 4,280.00 Budgeted 3,216.00 Remaining 25 % Used Account: 122-60096-045-000 Emergency Management 130 10/24/2013 October A/P Fire W/C, Charter, NCT COG Eme 1,000.00 1,000.00 TOWN OF TROPHY CLUB 33114 AP _______________ Account: 122-60096-045-000 Emergency Management Totals: 1,000.00 1,000.00 ** 2,000.00 Budgeted 1,000.00 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60100-045-000 Travel & per diem 226 10/26/2013 10/1-10/26 PCards COUNTY LINE ON THE LAK 16.74 16.74 COUNTY LINE ON THE LAK PC 226 10/26/2013 10/1-10/26 PCards SALT LICK 27.84 44.58 SALT LICK PC 226 10/26/2013 10/1-10/26 PCards PAPPADEAUX SEAFOOD KIT 36.15 80.73 PAPPADEAUX SEAFOOD KIT PC 226 10/26/2013 10/1-10/26 PCards CROWN PLAZA HTL - ASTN 13.85 94.58 CROWN PLAZA HTL - ASTN PC 226 10/26/2013 10/1-10/26 PCards PAPPADEAUX SEAFOOD KIT 57.55 152.13 PAPPADEAUX SEAFOOD KIT PC 226 10/26/2013 10/1-10/26 PCards COUNTY LINE ON THE LAK 20.53 172.66 COUNTY LINE ON THE LAK PC 226 10/26/2013 10/1-10/26 PCards PAPPADEAUX SEAFOOD KIT 40.92 213.58 PAPPADEAUX SEAFOOD KIT PC 226 10/26/2013 10/1-10/26 PCards PAPPADEAUX SEAFOOD KIT 55.39 268.97 PAPPADEAUX SEAFOOD KIT PC 227 10/26/2013 10/26 PCards CROWN PLAZA HOTEL 391.00 659.97 CROWN PLAZA HOTEL PC 227 10/26/2013 10/26 PCards CROWN PLAZA HOTEL 404.85 1,064.82 CROWN PLAZA HOTEL PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 1,064.82 1,064.82 ** 4,577.00 Budgeted 3,512.18 Remaining 23 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .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 27 10/08/2013 Oct A/P Fire open house-Sparkle's Spec 150.00 150.00 TRACY HENRY 33084 AP 226 10/26/2013 10/1-10/26 PCards WAL-MART #5247 (3.96) 146.04 WAL-MART #5247 PC 226 10/26/2013 10/1-10/26 PCards WAL-MART #5247 31.20 177.24 WAL-MART #5247 PC 226 10/26/2013 10/1-10/26 PCards SUBWAY 00217794 139.96 317.20 SUBWAY 00217794 PC 226 10/26/2013 10/1-10/26 PCards WAL-MART #5247 23.97 341.17 WAL-MART #5247 PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 341.17 341.17 ** 4,500.00 Budgeted 4,158.83 Remaining 8 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-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 .00 .00 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60245-045-000 Miscellaneous Expense .00 .00 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65005-045-000 Fuel & Lube 226 10/26/2013 10/1-10/26 PCards EXXONMOBIL 47575899 68.25 68.25 EXXONMOBIL 47575899 PC 236 10/31/2013 October Gas Log 669.78 738.03 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 738.03 738.03 ** 11,698.00 Budgeted 10,959.97 Remaining 6 % Used Account: 122-65010-045-000 Uniforms .00 .00 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 .00 ** 3,360.00 Budgeted 3,360.00 Remaining 0 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 7,600.00 Budgeted 7,600.00 Remaining 0 % Used Account: 122-65030-045-000 Chemicals .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools .00 .00 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies .00 .00 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 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 .00 .00 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 .00 ** 3,031.00 Budgeted 3,031.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 34,200.00 Budgeted 34,200.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 67,647.00 Budgeted 67,647.00 Remaining 0 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 20,400.00 Budgeted 20,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 46,547.10 ** 1,260,950.00 Budgeted 1,214,402.90 Remaining 4 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 23,573.53 .00 Budgeted (23,573.53) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET OCTOBER 31, 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 10/31/13 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 439,774 - - 439,774 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,500,302 - - 1,500,302 INVESTMENTS-TEXPOOL 865,683 313,050 330,585 1,509,318 PREPAID EXPENSES 79,677 - - 79,677 ADVALOREM PROPERTY TAXES RECEIVABLE 99,782 - - 99,782 UTILITY AND OTHER ACCOUNTS RECEIVABLE 822,215 - - 822,215 - TOTAL ASSETS 3,808,033 313,050 330,585 4,451,668 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 99,782 - - 99,782 ACCOUNTS AND OTHER PAYABLES 265,569 - 88,356 353,925 CUSTOMER DEPOSITS 239,697 - - 239,697 - TOTAL LIABILITIES 605,048 - 88,356 693,404 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,754 - - 2,682,754 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES 214,207 - (2,871) 211,336 - TOTAL FUND BALANCE 3,202,985 313,050 242,230 3,758,265 - TOTAL LIABILITIES AND FUND BALANCE 3,808,033 313,050 330,585 4,451,668 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 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- 1,865.89- 1,865.89- 1.880 97,384.11- 135-40002-000-000 Property Taxes/Delinquent 10.03 10.03 10.03- 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 34.30 34.30 -3.811 934.30- Subtotal: 100,150.00- 100,150.00- 1,821.56- 1,821.56- 1.819 98,328.44- 135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 241,095.25- 241,095.25- 6.430 3,508,214.75- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 140,301.05- 140,301.05- 8.213 1,568,019.95- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 7,174.15- 7,174.15- 11.119 57,347.85- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 778.00- 778.00- 8.573 8,297.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 200.00- 200.00- 16.667 1,000.00- 135-47045-000-000 Sewer Inspections 4,400.00- 4,400.00- 900.00- 900.00- 20.455 3,500.00- 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 7,272.30- 7,272.30- 9.138 72,313.70- Subtotal: 5,616,414.00- 5,616,414.00- 397,720.75- 397,720.75- 7.081 5,218,693.25- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 34,500.00- 34,500.00- 5.927 547,609.00- Subtotal: 582,109.00- 582,109.00- 34,500.00- 34,500.00- 5.927 547,609.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 166.18- 166.18- 3.462 4,633.82- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 910.53- 8.958 9,253.47- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67- 135-49030-000-000 Vending Revenue 350.00- 350.00- 41.00- 41.00- 11.714 309.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- 8,394.20- 8,394.20- 9.993 75,605.80- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- .01- .01- 2,999.99- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 100.00- 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 119,264.00- 10,095.25- 10,095.25- 8.465 109,168.75- Program number: 6,417,937.00- 6,417,937.00- 444,137.56- 444,137.56- 6.920 5,973,799.44- Department number: Revenues 6,417,937.00- 6,417,937.00- 444,137.56- 444,137.56- 6.920 5,973,799.44- Revenues Subtotal ----------- 6,417,937.00- 6,417,937.00- 444,137.56- 444,137.56- 6.920 5,973,799.44- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 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 11,917.83 11,917.83 4.142 275,791.17 135-50010-010-000 Overtime 13,391.00 13,391.00 773.82 773.82 5.779 12,617.18 135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 135-50017-010-000 Certification 5,100.00 5,100.00 325.00 325.00 6.373 4,775.00 135-50020-010-000 Retirement 27,847.00 27,847.00 1,612.86 1,612.86 5.792 26,234.14 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 2,378.20 2,378.20 4.920 45,955.80 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 206.23 206.23 5.245 3,725.77 135-50028-010-000 Vision Insurance 873.00 873.00 45.77 45.77 5.243 827.23 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 155.48 155.48 4.703 3,150.52 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,100.62 1,100.62 5.706 18,188.38 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 257.39 257.39 5.706 4,253.61 135-50040-010-000 Unemployment Taxes 54.00 54.00 54.00 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 802.45 8.164 9,026.55 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 36.45 36.45 18.225 163.55 135-50070-010-000 Employee Relations 300.00 300.00 8.99 8.99 2.997 291.01 Subtotal: 429,580.00 429,580.00 19,621.09 19,621.09 4.568 409,958.91 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 6,474.45 6,474.45 12.949 43,525.55 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 884.15 884.15 17.683 4,115.85 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 5,500.00 Subtotal: 67,000.00 67,000.00 7,358.60 7,358.60 10.983 59,641.40 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 4,913.00 135-60020-010-000 Electricity 162,160.00 162,160.00 5,717.42 5,717.42 3.526 156,442.58 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 135-60080-010-000 Schools & Training 4,184.00 4,184.00 4,184.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 1,450.00 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 6.00 1.200 494.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 47,400.00 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 2,338,473.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 280.60 280.60 8.017 3,219.40 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 6,004.02 6,004.02 .234 2,561,575.98 135-65005-010-000 Fuel & Lube 23,181.00 23,181.00 1,156.44 1,156.44 4.989 22,024.56 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 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 89.99 89.99 2.752 3,180.01 135-65030-010-000 Chemicals 5,000.00 5,000.00 983.96 983.96 19.679 4,016.04 135-65035-010-000 Small Tools 1,200.00 1,200.00 464.94 464.94 38.745 735.06 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 143,550.00 143,550.00 54,740.30 54,740.30 38.133 88,809.70 Subtotal: 177,201.00 177,201.00 57,435.63 57,435.63 32.413 119,765.37 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 106,847.00 Subtotal: 690,595.00 690,595.00 690,595.00 Program number: 3,931,956.00 3,931,956.00 90,419.34 90,419.34 2.300 3,841,536.66 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2013 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 1,000.00 Subtotal: 1,000.00 1,000.00 1,000.00 Program number: 1 Lab Analysis for PID 1,000.00 1,000.00 1,000.00 Department number: Water 3,932,956.00 3,932,956.00 90,419.34 90,419.34 2.299 3,842,536.66 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 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 10,212.71 10,212.71 5.034 192,681.29 135-50010-020-000 Overtime 11,965.00 11,965.00 783.14 783.14 6.545 11,181.86 135-50016-020-000 Longevity 2,998.00 2,998.00 2,998.00 135-50017-020-000 Certification 4,800.00 4,800.00 400.00 400.00 8.333 4,400.00 135-50020-020-000 Retirement 19,905.00 19,905.00 1,491.70 1,491.70 7.494 18,413.30 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,293.23 3,293.23 7.576 40,177.77 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 226.46 226.46 7.576 2,762.54 135-50028-020-000 Vision Insurance 658.00 658.00 49.93 49.93 7.588 608.07 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 168.15 168.15 7.301 2,134.85 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 894.34 894.34 6.478 12,910.66 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 209.15 209.15 6.477 3,019.85 135-50040-020-000 Unemployment Taxes 36.00 36.00 36.00 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 535.08 8.167 6,016.92 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 150.00 135-50070-020-000 Employee Relations 350.00 350.00 8.99 8.99 2.569 341.01 Subtotal: 316,105.00 316,105.00 18,272.88 18,272.88 5.781 297,832.12 135-55080-020-000 Maintenance & Repairs 35,000.00 35,000.00 363.02 363.02 1.037 34,636.98 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 141.98 141.98 7.099 1,858.02 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 52,000.00 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,938.00 2,938.00 9.793 27,062.00 Subtotal: 119,500.00 119,500.00 3,443.00 3,443.00 2.881 116,057.00 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 3,329.00 135-60020-020-000 Electricity 148,227.00 148,227.00 3,256.32 3,256.32 2.197 144,970.68 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 40.00 40.00 10.000 360.00 135-60080-020-000 Schools & Training 2,636.00 2,636.00 2,636.00 135-60090-020-000 Safety Program 250.00 250.00 38.55 38.55 15.420 211.45 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 1,050.00 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 299.53 19.969 1,200.47 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 17,150.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 3,634.40 3,634.40 2.039 174,607.60 135-65005-020-000 Fuel & Lube 14,720.00 14,720.00 972.51 972.51 6.607 13,747.49 135-65010-020-000 Uniforms 1,752.00 1,752.00 1,284.28 1,284.28 73.304 467.72 135-65030-020-000 Chemicals 39,000.00 39,000.00 2,949.64 2,949.64 7.563 36,050.36 135-65035-020-000 Small Tools 1,000.00 1,000.00 47.34 47.34 4.734 952.66 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65040-020-000 Safety Equipment 250.00 250.00 56.43 56.43 22.572 193.57 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 4,284.43 4,284.43 28.563 10,715.57 Subtotal: 71,722.00 71,722.00 9,594.63 9,594.63 13.378 62,127.37 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 34,944.91 34,944.91 4.550 733,066.09 Department number: Wastewater 768,011.00 768,011.00 34,944.91 34,944.91 4.550 733,066.09 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 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 5,458.64 5,458.64 6.045 84,840.36 135-50010-021-000 Overtime 10,028.00 10,028.00 736.32 736.32 7.343 9,291.68 135-50016-021-000 Longevity 17,913.00 17,913.00 17,913.00 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 150.00 8.333 1,650.00 135-50020-021-000 Retirement 9,025.00 9,025.00 924.77 924.77 10.247 8,100.23 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 2,057.31 2,057.31 8.692 21,610.69 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 144.43 144.43 8.481 1,558.57 135-50028-021-000 Vision Insurance 314.00 314.00 28.21 28.21 8.984 285.79 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 123.22 123.22 11.559 942.78 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 571.15 571.15 7.675 6,870.85 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 133.57 133.57 7.672 1,607.43 135-50040-021-000 Unemployment Taxes 198.00 198.00 198.00 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 267.54 8.167 3,008.46 135-50070-021-000 Employee Relations 200.00 200.00 8.99 8.99 4.495 191.01 Subtotal: 168,673.00 168,673.00 10,604.15 10,604.15 6.287 158,068.85 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 27.97 27.97 .118 23,773.03 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 2,000.00 Subtotal: 27,301.00 27,301.00 27.97 27.97 .102 27,273.03 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 1,333.00 135-60020-021-000 Electricity 21,178.00 21,178.00 365.94 365.94 1.728 20,812.06 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 365.94 365.94 1.033 35,056.06 135-65005-021-000 Fuel & Lube 22,397.00 22,397.00 1,030.84 1,030.84 4.603 21,366.16 135-65010-021-000 Uniforms 1,040.00 1,040.00 576.14 576.14 55.398 463.86 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 43.99 4.399 956.01 135-65040-021-000 Safety Equipment 500.00 500.00 540.75 540.75 108.150 40.75- Subtotal: 30,937.00 30,937.00 2,191.72 2,191.72 7.084 28,745.28 135-69005-021-000 Capital Expenses 100,000.00 100,000.00 100,000.00 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 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 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 209,837.00 Program number: 472,170.00 472,170.00 13,189.78 13,189.78 2.793 458,980.22 Department number: Collection 472,170.00 472,170.00 13,189.78 13,189.78 2.793 458,980.22 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,000.00 1,000.00 10.000 9,000.00 135-50030-026-000 Social Security Taxes 620.00 620.00 62.00 62.00 10.000 558.00 135-50035-026-000 Medicare Taxes 145.00 145.00 14.50 14.50 10.000 130.50 135-50040-026-000 Unemployment Taxes 10.00 10.00 1.00 1.00 10.000 9.00 135-50045-026-000 Workman's Compensation 36.00 36.00 2.95 2.95 8.194 33.05 Subtotal: 10,811.00 10,811.00 1,080.45 1,080.45 9.994 9,730.55 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 5.00 5.00 .417 1,195.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 4,000.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 5.00 5.00 .042 11,845.00 Program number: 22,661.00 22,661.00 1,085.45 1,085.45 4.790 21,575.55 Department number: Board of Directors 22,661.00 22,661.00 1,085.45 1,085.45 4.790 21,575.55 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 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 23,216.15 23,216.15 5.061 435,504.85 135-50010-030-000 Overtime 500.00 500.00 211.07 211.07 42.214 288.93 135-50016-030-000 Longevity 3,018.00 3,018.00 3,018.00 135-50020-030-000 Retirement 41,419.00 41,419.00 3,076.50 3,076.50 7.428 38,342.50 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,388.10 4,388.10 7.576 53,534.90 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 386.34 386.34 7.575 4,713.66 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 82.53 82.53 7.592 1,004.47 135-50029-030-000 Life Insurance & Other 4,483.00 4,483.00 336.77 336.77 7.512 4,146.23 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 1,979.43 1,979.43 6.907 26,679.57 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 462.95 462.95 6.908 6,239.05 135-50040-030-000 Unemployment Taxes 63.00 63.00 63.00 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.63 128.63 8.167 1,446.37 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 702.85 702.85 14.057 4,297.15 Subtotal: 614,450.00 614,450.00 34,971.32 34,971.32 5.691 579,478.68 135-55030-030-000 Software & Support 59,698.00 59,698.00 2,625.50 2,625.50 4.398 57,072.50 135-55070-030-000 Independent Labor 7,700.00 7,700.00 1,780.45 1,780.45 23.123 5,919.55 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 4,500.00 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 139.84 139.84 2.151 6,360.16 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 19,140.00 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 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 6,808.00 Subtotal: 196,594.00 196,594.00 43,069.79 43,069.79 21.908 153,524.21 135-60005-030-000 Telephone 11,250.00 11,250.00 205.00 205.00 1.822 11,045.00 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 3,589.00 150.00 150.00 4.179 3,439.00 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 15,171.00 135-60025-030-000 Water 1,500.00 1,500.00 101.26 101.26 6.751 1,398.74 135-60035-030-000 Postage 28,500.00 28,500.00 1,267.32 1,267.32 4.447 27,232.68 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 28,330.00 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 53,561.00 53,561.00 4,302.98 4,302.98 8.034 49,258.02 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 100.00 100.00 2.222 4,400.00 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60080-030-000 Schools & Training 7,500.00 7,500.00 7,500.00 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 5,000.00 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 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 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 2,500.00 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 22,870.00 22,870.00 19.70 19.70 .086 22,850.30 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 6,146.26 6,146.26 3.010 198,074.74 135-65010-030-000 Uniforms 1,390.00 1,390.00 1,390.00 135-65055-030-000 Hardware 13,562.00 13,562.00 305.97 305.97 2.256 13,256.03 135-65085-030-000 Office Supplies 9,100.00 9,100.00 673.48 673.48 7.401 8,426.52 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 5,732.00 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 94.40 94.40 3.776 2,405.60 135-65097-030-000 Vending Machine Supplies 200.00 200.00 27.06 27.06 13.530 172.94 135-65105-030-000 Printing 4,000.00 4,000.00 1,401.00 1,401.00 35.025 2,599.00 Subtotal: 36,484.00 36,484.00 2,501.91 2,501.91 6.858 33,982.09 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 256.85 7.445 3,193.15 Subtotal: 3,450.00 3,450.00 256.85 256.85 7.445 3,193.15 Program number: 1,055,199.00 1,055,199.00 86,946.13 86,946.13 8.240 968,252.87 Department number: Administration 1,055,199.00 1,055,199.00 86,946.13 86,946.13 8.240 968,252.87 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2013 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 131,300.00 135-55055-039-000 Auditing 21,840.00 21,840.00 21,840.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 3,344.70 3,344.70 33.447 6,655.30 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 166,940.00 166,940.00 3,344.70 3,344.70 2.004 163,595.30 Program number: 166,940.00 166,940.00 3,344.70 3,344.70 2.004 163,595.30 Department number: Non Departmental 166,940.00 166,940.00 3,344.70 3,344.70 2.004 163,595.30 Expenditures Subtotal ----------- 6,417,937.00 6,417,937.00 229,930.31 229,930.31 3.583 6,188,006.69 Fund number: 135 MUD 1 General Fund 214,207.25- 214,207.25- 214,207.25 . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 18:59 11/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 13.98- 13.98- 13.98 Subtotal: 13.98- 13.98- 13.98 Program number: 13.98- 13.98- 13.98 Department number: 13.98- 13.98- 13.98 Revenues Subtotal ----------- 13.98- 13.98- 13.98 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 18:59 11/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 10/2013 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 2,885.00 2,885.00 2,885.00- Subtotal: 2,885.00 2,885.00 2,885.00- Program number: 2 Rate of Flow Control-FW Meter 2,885.00 2,885.00 2,885.00- Department number: Water 2,885.00 2,885.00 2,885.00- Expenditures Subtotal ----------- 2,885.00 2,885.00 2,885.00- Fund number: 507 MUD 1 Capital Projects 2,871.02 2,871.02 2,871.02- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 199 10/14/2013 Property Taxes/Assessments (35.40) (35.40) GL 200 10/15/2013 Property Taxes/Assessments (18.82) (54.22) GL 202 10/16/2013 Property Taxes/Assessments (74.36) (128.58) GL 203 10/17/2013 Property Taxes/Assessments (10.14) (138.72) GL 207 10/21/2013 Property Taxes/Assessments (363.74) (502.46) GL 208 10/22/2013 Property Taxes/Assessments (139.30) (641.76) GL 209 10/23/2013 Property Taxes/Assessments (258.19) (899.95) GL 210 10/24/2013 Property Taxes/Assessments (291.87) (1,191.82) GL 211 10/25/2013 Property Taxes/Assessments (120.50) (1,312.32) GL 212 10/28/2013 Property Taxes/Assessments (155.37) (1,467.69) GL 213 10/29/2013 Property Taxes/Assessments (110.97) (1,578.66) GL 214 10/30/2013 Property Taxes/Assessments (22.97) (1,601.63) GL 215 10/31/2013 Property Taxes/Assessments (264.26) (1,865.89) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (1,865.89) (1,865.89) ** (99,250.00) Budgeted (97,384.11) Remaining 2 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 199 10/14/2013 Property Taxes/Assessments 23.73 23.73 GL 202 10/16/2013 Property Taxes/Assessments (16.61) 7.12 GL 211 10/25/2013 Property Taxes/Assessments (2.46) 4.66 GL 212 10/28/2013 Property Taxes/Assessments (.14) 4.52 GL 213 10/29/2013 Property Taxes/Assessments 9.53 14.05 GL 215 10/31/2013 Property Taxes/Assessments (4.02) 10.03 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 10.03 10.03 ** .00 Budgeted (10.03) Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 199 10/14/2013 Property Taxes/Assessments (1.62) (1.62) GL 199 10/14/2013 Property Taxes/Assessments 40.80 39.18 GL 202 10/16/2013 Property Taxes/Assessments (3.49) 35.69 GL 211 10/25/2013 Property Taxes/Assessments (.52) 35.17 GL 212 10/28/2013 Property Taxes/Assessments (.03) 35.14 GL 215 10/31/2013 Property Taxes/Assessments (.84) 34.30 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: 34.30 34.30 ** (900.00) Budgeted (934.30) Remaining -4 % Used Account: 135-47000-000-000 Water . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 274 10/01/2013 Reverse UB Accrued Sept billin 65,451.01 65,451.01 GL 83 10/09/2013 UB 10/9/13 PM Connect Fee UB20131009-20131009 User: (100.00) 65,351.01 UB 84 10/10/2013 UB 10/10/13 PM Connect Fee UB20131010-20131010 User: (100.00) 65,251.01 UB 185 10/31/2013 UB 10/31/13 Billing UB20131031-20131031 User: (306,346.26) (241,095.25) UB _______________ Account: 135-47000-000-000 Water Totals: (241,095.25) (241,095.25) ** (3,749,310.00) Budgeted (3,508,214.75) Remaining 6 % Used Account: 135-47005-000-000 Sewer 274 10/01/2013 Reverse UB Accrued Sept billin 36,406.75 36,406.75 GL 185 10/31/2013 UB 10/31/13 Billing UB20131031-20131031 User: (176,707.80) (140,301.05) UB _______________ Account: 135-47005-000-000 Sewer Totals: (140,301.05) (140,301.05) ** (1,708,321.00) Budgeted (1,568,019.95) Remaining 8 % Used Account: 135-47025-000-000 Penalties 110 10/22/2013 UB 10/22/13 Penalties UB20131022-20131022 User: (7,531.17) (7,531.17) UB 166 10/22/2013 UB 10/22/13 Penalty Adjustment UB20131022-20131022 User: 190.62 (7,340.55) UB 173 10/31/2013 UB 10/31/13 Penalty Removals UB20131031-20131031 User: 166.40 (7,174.15) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,174.15) (7,174.15) ** (64,522.00) Budgeted (57,347.85) Remaining 11 % Used Account: 135-47030-000-000 Service Charges 29 10/09/2013 UB 10/9/13 Cut Off List Fee UB20131009-20131009 User: (650.00) (650.00) UB 179 10/17/2013 UB 10/17/13 NSF Check Fee UB20131017-20131017 User: (25.00) (675.00) UB 231 10/23/2013 UB 10/23/13 Adjustment NSF UB20131023-20131023 User: (50.00) (725.00) UB 181 10/25/2013 UB 10/25/13 NSF Check Fee UB20131025-20131025 User: (25.00) (750.00) UB 185 10/31/2013 UB 10/31/13 Billing UB20131031-20131031 User: (28.00) (778.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (778.00) (778.00) ** (9,075.00) Budgeted (8,297.00) Remaining 9 % Used Account: 135-47035-000-000 Plumbing Inspections 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (200.00) (200.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (200.00) ** (1,200.00) Budgeted (1,000.00) Remaining 17 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47045-000-000 Sewer Inspections 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (900.00) (900.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (900.00) (900.00) ** (4,400.00) Budgeted (3,500.00) Remaining 20 % Used Account: 135-47070-000-000 TCCC Effluent Charges 185 10/31/2013 UB 10/31/13 Billing UB20131031-20131031 User: (7,272.30) (7,272.30) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (7,272.30) (7,272.30) ** (79,586.00) Budgeted (72,313.70) Remaining 9 % Used Account: 135-48005-000-000 Utility Fees 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (34,500.00) (34,500.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (34,500.00) (34,500.00) ** (582,109.00) Budgeted (547,609.00) Remaining 6 % Used Account: 135-49010-000-000 Interest Income 225 10/31/2013 Bank Interest/Oct (82.27) (82.27) GL 225 10/31/2013 Bank Interest/Oct (83.91) (166.18) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (166.18) (166.18) ** (4,800.00) Budgeted (4,633.82) Remaining 3 % Used Account: 135-49016-000-000 Cell Tower Revenue 218 10/03/2013 Oct AT&T Antenna Lease (910.53) (910.53) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (910.53) ** (10,164.00) Budgeted (9,253.47) Remaining 9 % Used Account: 135-49018-000-000 Building Rent Income 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (583.33) (583.33) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (583.33) ** (7,000.00) Budgeted (6,416.67) Remaining 8 % Used Account: 135-49030-000-000 Vending Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 220 10/15/2013 WWTP Vending (41.00) (41.00) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (41.00) (41.00) ** (350.00) Budgeted (309.00) Remaining 12 % 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 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (8,394.20) (8,394.20) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (8,394.20) (8,394.20) ** (84,000.00) Budgeted (75,605.80) Remaining 10 % Used Account: 135-49900-000-000 Miscellaneous Income 256 10/31/2013 Bank Rec adjustment (.01) (.01) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (.01) (.01) ** (3,000.00) Budgeted (2,999.99) Remaining 0 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (100.00) Budgeted (100.00) Remaining 0 % Used Account: 135-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: ------------------------------------------------------------------------------------------------ (444,137.56) ** (6,417,937.00) Budgeted (5,973,799.44) Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 6,663.12 6,663.12 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (4,283.43) 2,379.69 GL 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 9,538.14 11,917.83 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 11,917.83 11,917.83 ** 287,709.00 Budgeted 275,791.17 Remaining 4 % Used Account: 135-50010-010-000 Overtime 25 10/11/2013 MUD Payroll 10/11/13 Overtime 1,187.43 1,187.43 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (660.49) 526.94 GL 100 10/25/2013 10/25/13 MUD Payroll Overtime 246.88 773.82 PR _______________ Account: 135-50010-010-000 Overtime Totals: 773.82 773.82 ** 13,391.00 Budgeted 12,617.18 Remaining 6 % Used Account: 135-50016-010-000 Longevity .00 .00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 .00 ** 4,905.00 Budgeted 4,905.00 Remaining 0 % Used Account: 135-50017-010-000 Certification 100 10/25/2013 10/25/13 MUD Payroll Certification 325.00 325.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 325.00 325.00 ** 5,100.00 Budgeted 4,775.00 Remaining 6 % Used Account: 135-50020-010-000 Retirement 25 10/11/2013 MUD Payroll 10/11/13 Retirement 704.99 704.99 PR 100 10/25/2013 10/25/13 MUD Payroll Retirement 907.87 1,612.86 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,612.86 1,612.86 ** 27,847.00 Budgeted 26,234.14 Remaining 6 % Used Account: 135-50026-010-000 Medical Insurance 25 10/11/2013 MUD Payroll 10/11/13 Medical Insurance 1,057.00 1,057.00 PR 100 10/25/2013 10/25/13 MUD Payroll Medical Insurance 1,321.20 2,378.20 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,378.20 2,378.20 ** 48,334.00 Budgeted 45,955.80 Remaining 5 % Used Account: 135-50027-010-000 Dental Insurance 25 10/11/2013 MUD Payroll 10/11/13 Dental Insurance 95.40 95.40 PR 100 10/25/2013 10/25/13 MUD Payroll Dental Insurance 110.83 206.23 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 206.23 206.23 ** 3,932.00 Budgeted 3,725.77 Remaining 5 % Used Account: 135-50028-010-000 Vision Insurance 25 10/11/2013 MUD Payroll 10/11/13 Vision Insurance 20.70 20.70 PR 100 10/25/2013 10/25/13 MUD Payroll Vision Insurance 25.07 45.77 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 45.77 45.77 ** 873.00 Budgeted 827.23 Remaining 5 % Used Account: 135-50029-010-000 Life Insurance & Other 2 10/01/2013 Reverse Prepaids Metlife Life, ADD & Other 139.73 139.73 GL 247 10/31/2013 Oct A/P FSA Adm fee/Oct 15.75 155.48 Discovery Benefits 33148 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 155.48 155.48 ** 3,306.00 Budgeted 3,150.52 Remaining 5 % Used Account: 135-50030-010-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 480.93 480.93 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 619.69 1,100.62 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,100.62 1,100.62 ** 19,289.00 Budgeted 18,188.38 Remaining 6 % Used Account: 135-50035-010-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 112.47 112.47 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 144.92 257.39 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 257.39 257.39 ** 4,511.00 Budgeted 4,253.61 Remaining 6 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 54.00 Budgeted 54.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 47 10/01/2013 Oct Ins & W/C Expense 802.45 802.45 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 802.45 ** 9,829.00 Budgeted 9,026.55 Remaining 8 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 247 10/31/2013 Oct A/P Pre-employment/Melancon 36.45 36.45 FIRST CHECK APPLICANT SCREENIN 33152 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 36.45 36.45 ** 200.00 Budgeted 163.55 Remaining 18 % Used Account: 135-50070-010-000 Employee Relations 226 10/26/2013 10/1-10/26 PCards DONUT HAVEN 8.99 8.99 DONUT HAVEN PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 8.99 8.99 ** 300.00 Budgeted 291.01 Remaining 3 % 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 130 10/24/2013 October A/P angle stops 537.00 537.00 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P meter boxes 439.28 976.28 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P Fire line parts 1,575.94 2,552.22 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P comxmale for oak hill fire hyd 124.78 2,677.00 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P compressions and angle stops 276.00 2,953.00 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P meter spuds and gaskets 645.71 3,598.71 HD SUPPLY WATERWORKS, LTD. 33096 AP 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 29.34 3,628.05 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 226 10/26/2013 10/1-10/26 PCards FERGUSON ENTERPRISES 1 450.00 4,078.05 FERGUSON ENTERPRISES 1 PC 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 52.86 4,130.91 THE HOME DEPOT 6581 PC 226 10/26/2013 10/1-10/26 PCards CRAFTMARK PRODUCTS INC 81.00 4,211.91 CRAFTMARK PRODUCTS INC PC 227 10/26/2013 10/26 PCards CRAFTMARK PRODUCTS INC 13.22 4,225.13 CRAFTMARK PRODUCTS INC PC 155 10/30/2013 Oct A/P Flush hydrant 775.00 5,000.13 HD SUPPLY WATERWORKS, LTD. 33128 AP 247 10/31/2013 Oct A/P 2" couplings and poly 234.66 5,234.79 HD SUPPLY WATERWORKS, LTD. 33157 AP 247 10/31/2013 Oct A/P Meter boxes 1,217.58 6,452.37 HD SUPPLY WATERWORKS, LTD. 33157 AP 247 10/31/2013 Oct A/P Pin for Fire Hydrant 22.08 6,474.45 HD SUPPLY WATERWORKS, LTD. 33157 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 6,474.45 6,474.45 ** 50,000.00 Budgeted 43,525.55 Remaining 13 % Used Account: 135-55090-010-000 Vehicle Maintenance 226 10/26/2013 10/1-10/26 PCards KWIK KAR OF ROANOKE 39.75 39.75 KWIK KAR OF ROANOKE PC 155 10/30/2013 Oct A/P Replace Heater core/F150 767.02 806.77 MICHAEL G. WATSON 33130 AP 247 10/31/2013 Oct A/P Parts for 2002 F150 77.38 884.15 ROANOKE AUTO SUPPLY 33168 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 884.15 884.15 ** 5,000.00 Budgeted 4,115.85 Remaining 18 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis .00 .00 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 .00 ** 5,500.00 Budgeted 5,500.00 Remaining 0 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 4,913.00 Budgeted 4,913.00 Remaining 0 % Used Account: 135-60020-010-000 Electricity . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 3,823.16 3,823.16 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/10 25.41 3,848.57 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 1,868.85 5,717.42 HUDSON ENERGY SERVICES, LLC 33097 AP _______________ Account: 135-60020-010-000 Electricity Totals: 5,717.42 5,717.42 ** 162,160.00 Budgeted 156,442.58 Remaining 4 % 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 .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training .00 .00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 .00 ** 4,184.00 Budgeted 4,184.00 Remaining 0 % 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 .00 .00 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 1,450.00 Budgeted 1,450.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 247 10/31/2013 Oct A/P Nitrogen bottle lease 6.00 6.00 ALLIED WELDING SUPPLY, INC 33139 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 6.00 ** 500.00 Budgeted 494.00 Remaining 1 % Used Account: 135-60135-010-000 TCEQ Fees & Permits .00 .00 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 .00 ** 47,400.00 Budgeted 47,400.00 Remaining 0 % Used Account: 135-60150-010-000 Wholesale Water .00 .00 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 .00 ** 2,338,473.00 Budgeted 2,338,473.00 Remaining 0 % 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 226 10/26/2013 10/1-10/26 PCards DENTON SAND & GRAVEL, 108.00 108.00 DENTON SAND & GRAVEL, PC 226 10/26/2013 10/1-10/26 PCards DENTON SAND & GRAVEL, 84.00 192.00 DENTON SAND & GRAVEL, PC 226 10/26/2013 10/1-10/26 PCards DENTON SAND & GRAVEL, 42.00 234.00 DENTON SAND & GRAVEL, PC 226 10/26/2013 10/1-10/26 PCards TEX-TURF 46.60 280.60 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 280.60 280.60 ** 3,500.00 Budgeted 3,219.40 Remaining 8 % 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 24 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60360-010-000 Furniture/Equipment < $5000 .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 236 10/31/2013 October Gas Log 1,156.44 1,156.44 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,156.44 1,156.44 ** 23,181.00 Budgeted 22,024.56 Remaining 5 % Used Account: 135-65010-010-000 Uniforms 226 10/26/2013 10/1-10/26 PCards TRACTOR SUPPLY COMPANY 89.99 89.99 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-010-000 Uniforms Totals: 89.99 89.99 ** 3,270.00 Budgeted 3,180.01 Remaining 3 % Used Account: 135-65030-010-000 Chemicals 155 10/30/2013 Oct A/P Total Chlorine Dispensers 135.77 135.77 HACH COMPANY 33127 AP 247 10/31/2013 Oct A/P Chemicals 520.44 656.21 DPC INDUSTRIES, INC 33149 AP 247 10/31/2013 Oct A/P Chemicals 327.75 983.96 HACH COMPANY 33156 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 983.96 983.96 ** 5,000.00 Budgeted 4,016.04 Remaining 20 % Used Account: 135-65035-010-000 Small Tools 247 10/31/2013 Oct A/P Tools for on-call trucks 464.94 464.94 ATLAS UTILITY SUPPLY CO. 33140 AP _______________ Account: 135-65035-010-000 Small Tools Totals: 464.94 464.94 ** 1,200.00 Budgeted 735.06 Remaining 39 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense 226 10/26/2013 10/1-10/26 PCards ATLAS UTILITY SUPPLY C 942.40 942.40 ATLAS UTILITY SUPPLY C PC 247 10/31/2013 Oct A/P Meters 3,910.00 4,852.40 ATLAS UTILITY SUPPLY CO. 33140 AP 247 10/31/2013 Oct A/P 150 1" meters with Orion heads 49,500.00 54,352.40 ATLAS UTILITY SUPPLY CO. 33140 AP 247 10/31/2013 Oct A/P 1" Meter spuds 387.90 54,740.30 HD SUPPLY WATERWORKS, LTD. 33157 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 54,740.30 54,740.30 ** 143,550.00 Budgeted 88,809.70 Remaining 38 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69281-010-000 Capital Repair-Ground Storage .00 .00 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 .00 ** 106,847.00 Budgeted 106,847.00 Remaining 0 % Used Account: 135-55135-010-001 Lab Analysis .00 .00 _______________ Account: 135-55135-010-001 Lab Analysis Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 90,419.34 ** 3,932,956.00 Budgeted 3,842,536.66 Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 7,360.84 7,360.84 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (4,735.59) 2,625.25 GL 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 7,587.46 10,212.71 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 10,212.71 10,212.71 ** 202,894.00 Budgeted 192,681.29 Remaining 5 % Used Account: 135-50010-020-000 Overtime 25 10/11/2013 MUD Payroll 10/11/13 Overtime 906.55 906.55 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (479.93) 426.62 GL 100 10/25/2013 10/25/13 MUD Payroll Overtime 356.52 783.14 PR _______________ Account: 135-50010-020-000 Overtime Totals: 783.14 783.14 ** 11,965.00 Budgeted 11,181.86 Remaining 7 % Used Account: 135-50016-020-000 Longevity .00 .00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 .00 ** 2,998.00 Budgeted 2,998.00 Remaining 0 % Used Account: 135-50017-020-000 Certification 100 10/25/2013 10/25/13 MUD Payroll Certification 400.00 400.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 400.00 ** 4,800.00 Budgeted 4,400.00 Remaining 8 % Used Account: 135-50020-020-000 Retirement 25 10/11/2013 MUD Payroll 10/11/13 Retirement 742.41 742.41 PR 100 10/25/2013 10/25/13 MUD Payroll Retirement 749.29 1,491.70 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,491.70 1,491.70 ** 19,905.00 Budgeted 18,413.30 Remaining 7 % Used Account: 135-50026-020-000 Medical Insurance 25 10/11/2013 MUD Payroll 10/11/13 Medical Insurance 1,646.62 1,646.62 PR 100 10/25/2013 10/25/13 MUD Payroll Medical Insurance 1,646.61 3,293.23 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,293.23 3,293.23 ** 43,471.00 Budgeted 40,177.77 Remaining 8 % Used Account: 135-50027-020-000 Dental Insurance 25 10/11/2013 MUD Payroll 10/11/13 Dental Insurance 113.24 113.24 PR 100 10/25/2013 10/25/13 MUD Payroll Dental Insurance 113.22 226.46 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 226.46 ** 2,989.00 Budgeted 2,762.54 Remaining 8 % Used Account: 135-50028-020-000 Vision Insurance 25 10/11/2013 MUD Payroll 10/11/13 Vision Insurance 24.98 24.98 PR 100 10/25/2013 10/25/13 MUD Payroll Vision Insurance 24.95 49.93 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 49.93 49.93 ** 658.00 Budgeted 608.07 Remaining 8 % Used Account: 135-50029-020-000 Life Insurance & Other 2 10/01/2013 Reverse Prepaids Metlife Life, ADD & Other 152.40 152.40 GL 247 10/31/2013 Oct A/P FSA Adm fee/Oct 15.75 168.15 Discovery Benefits 33148 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 168.15 168.15 ** 2,303.00 Budgeted 2,134.85 Remaining 7 % Used Account: 135-50030-020-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 446.65 446.65 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 447.69 894.34 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 894.34 894.34 ** 13,805.00 Budgeted 12,910.66 Remaining 6 % Used Account: 135-50035-020-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 104.46 104.46 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 104.69 209.15 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 209.15 209.15 ** 3,229.00 Budgeted 3,019.85 Remaining 6 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 36.00 Budgeted 36.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 47 10/01/2013 Oct Ins & W/C Expense 535.08 535.08 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 535.08 ** 6,552.00 Budgeted 6,016.92 Remaining 8 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations 226 10/26/2013 10/1-10/26 PCards DONUT HAVEN 8.99 8.99 DONUT HAVEN PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 8.99 8.99 ** 350.00 Budgeted 341.01 Remaining 3 % Used Account: 135-55080-020-000 Maintenance & Repairs 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 325.99 325.99 THE HOME DEPOT 6581 PC 227 10/26/2013 10/26 PCards THE HOME DEPOT 6581 37.03 363.02 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 363.02 363.02 ** 35,000.00 Budgeted 34,636.98 Remaining 1 % Used Account: 135-55090-020-000 Vehicle Maintenance 226 10/26/2013 10/1-10/26 PCards MUSTANG ELITE CAR WASH 70.99 70.99 MUSTANG ELITE CAR WASH PC 226 10/26/2013 10/1-10/26 PCards MUSTANG ELITE CAR WASH 70.99 141.98 MUSTANG ELITE CAR WASH PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 141.98 141.98 ** 2,000.00 Budgeted 1,858.02 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-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 .00 .00 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 .00 ** 52,000.00 Budgeted 52,000.00 Remaining 0 % Used Account: 135-55135-020-000 Lab Analysis 130 10/24/2013 October A/P testing 278.00 278.00 OXIDOR LABORATORIES LLC 33106 AP 130 10/24/2013 October A/P Testing 124.00 402.00 OXIDOR LABORATORIES LLC 33106 AP 130 10/24/2013 October A/P Testing 124.00 526.00 OXIDOR LABORATORIES LLC 33106 AP 130 10/24/2013 October A/P Testing 124.00 650.00 OXIDOR LABORATORIES LLC 33106 AP 130 10/24/2013 October A/P Testing 124.00 774.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 278.00 1,052.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 211.00 1,263.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 124.00 1,387.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 211.00 1,598.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 288.00 1,886.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 211.00 2,097.00 OXIDOR LABORATORIES LLC 33106 AP 247 10/31/2013 Oct A/P Testing 243.00 2,340.00 OXIDOR LABORATORIES LLC 33167 AP 247 10/31/2013 Oct A/P Testing 176.00 2,516.00 OXIDOR LABORATORIES LLC 33167 AP 247 10/31/2013 Oct A/P Testing 246.00 2,762.00 OXIDOR LABORATORIES LLC 33167 AP 247 10/31/2013 Oct A/P Testing 176.00 2,938.00 OXIDOR LABORATORIES LLC 33167 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,938.00 2,938.00 ** 30,000.00 Budgeted 27,062.00 Remaining 10 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 3,329.00 Budgeted 3,329.00 Remaining 0 % Used Account: 135-60020-020-000 Electricity . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 3,256.32 3,256.32 HUDSON ENERGY SERVICES, LLC 33097 AP _______________ Account: 135-60020-020-000 Electricity Totals: 3,256.32 3,256.32 ** 148,227.00 Budgeted 144,970.68 Remaining 2 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 114 10/23/2013 Oct A/P Text Book/Utilities Safety Cla 40.00 40.00 CITY OF FORT WORTH 33091 AP _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 40.00 40.00 ** 400.00 Budgeted 360.00 Remaining 10 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 2,636.00 Budgeted 2,636.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 130 10/24/2013 October A/P safety supplies for cabinet 38.55 38.55 CINTAS FAS LOCKBOX 636525 33089 AP _______________ Account: 135-60090-020-000 Safety Program Totals: 38.55 38.55 ** 250.00 Budgeted 211.45 Remaining 15 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,050.00 Budgeted 1,050.00 Remaining 0 % Used Account: 135-60105-020-000 Rent/Lease Equipment 226 10/26/2013 10/1-10/26 PCards FOX RENTAL 299.53 299.53 FOX RENTAL PC _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 299.53 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60135-020-000 TCEQ Fees & Permits .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 .00 ** 17,150.00 Budgeted 17,150.00 Remaining 0 % 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 236 10/31/2013 October Gas Log 972.51 972.51 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 972.51 972.51 ** 14,720.00 Budgeted 13,747.49 Remaining 7 % Used Account: 135-65010-020-000 Uniforms 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #81 228.90 228.90 ACADEMY SPORTS #81 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 199.74 428.64 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 182.74 611.38 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #141 204.90 816.28 ACADEMY SPORTS #141 PC 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #141 (221.80) 594.48 ACADEMY SPORTS #141 PC 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #141 221.80 816.28 ACADEMY SPORTS #141 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 157.24 973.52 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 157.24 1,130.76 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards PANDA EMBROIDERY 186.00 1,316.76 PANDA EMBROIDERY PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 222 10/30/2013 Richey, Valadez Boot reimb (32.48) 1,284.28 GL _______________ Account: 135-65010-020-000 Uniforms Totals: 1,284.28 1,284.28 ** 1,752.00 Budgeted 467.72 Remaining 73 % Used Account: 135-65030-020-000 Chemicals 131 10/24/2013 Oct A/P Chemicals 2,263.62 2,263.62 HARCROS CHEMICALS INC 33094 AP 226 10/26/2013 10/1-10/26 PCards AQUAFIX INC 686.02 2,949.64 AQUAFIX INC PC _______________ Account: 135-65030-020-000 Chemicals Totals: 2,949.64 2,949.64 ** 39,000.00 Budgeted 36,050.36 Remaining 8 % Used Account: 135-65035-020-000 Small Tools 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 47.34 47.34 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 47.34 47.34 ** 1,000.00 Budgeted 952.66 Remaining 5 % Used Account: 135-65040-020-000 Safety Equipment 247 10/31/2013 Oct A/P Stock medicine cabinet 56.43 56.43 CINTAS CORPORATION NO. 2 33144 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 56.43 56.43 ** 250.00 Budgeted 193.57 Remaining 23 % Used Account: 135-65045-020-000 Lab Supplies 131 10/24/2013 Oct A/P PH Buffer 39.54 39.54 HD SUPPLY FACILITIES MAINT LTD 33095 AP 131 10/24/2013 Oct A/P Circular Flow Charts 51.63 91.17 HD SUPPLY FACILITIES MAINT LTD 33095 AP 226 10/26/2013 10/1-10/26 PCards HACH COMPANY 1,152.83 1,244.00 HACH COMPANY PC 226 10/26/2013 10/1-10/26 PCards IDEXX DISTRIBUTION INC 3,027.46 4,271.46 IDEXX DISTRIBUTION INC PC 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 12.97 4,284.43 THE HOME DEPOT 6581 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 4,284.43 4,284.43 ** 15,000.00 Budgeted 10,715.57 Remaining 29 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ 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: ------------------------------------------------------------------------------------------------ 34,944.91 ** 768,011.00 Budgeted 733,066.09 Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-021-000 Salaries & Wages 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 5,891.37 5,891.37 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (3,787.31) 2,104.06 GL 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 3,354.58 5,458.64 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 5,458.64 5,458.64 ** 90,299.00 Budgeted 84,840.36 Remaining 6 % Used Account: 135-50010-021-000 Overtime 25 10/11/2013 MUD Payroll 10/11/13 Overtime 258.03 258.03 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (165.88) 92.15 GL 100 10/25/2013 10/25/13 MUD Payroll Overtime 644.17 736.32 PR _______________ Account: 135-50010-021-000 Overtime Totals: 736.32 736.32 ** 10,028.00 Budgeted 9,291.68 Remaining 7 % Used Account: 135-50016-021-000 Longevity .00 .00 _______________ Account: 135-50016-021-000 Longevity Totals: .00 .00 ** 17,913.00 Budgeted 17,913.00 Remaining 0 % Used Account: 135-50017-021-000 Certification 100 10/25/2013 10/25/13 MUD Payroll Certification 150.00 150.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 150.00 ** 1,800.00 Budgeted 1,650.00 Remaining 8 % Used Account: 135-50020-021-000 Retirement 25 10/11/2013 MUD Payroll 10/11/13 Retirement 552.22 552.22 PR 100 10/25/2013 10/25/13 MUD Payroll Retirement 372.55 924.77 PR _______________ Account: 135-50020-021-000 Retirement Totals: 924.77 924.77 ** 9,025.00 Budgeted 8,100.23 Remaining 10 % Used Account: 135-50026-021-000 Medical Insurance 25 10/11/2013 MUD Payroll 10/11/13 Medical Insurance 1,160.78 1,160.78 PR 100 10/25/2013 10/25/13 MUD Payroll Medical Insurance 896.53 2,057.31 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,057.31 2,057.31 ** 23,668.00 Budgeted 21,610.69 Remaining 9 % Used Account: 135-50027-021-000 Dental Insurance 25 10/11/2013 MUD Payroll 10/11/13 Dental Insurance 79.95 79.95 PR 100 10/25/2013 10/25/13 MUD Payroll Dental Insurance 64.48 144.43 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 144.43 144.43 ** 1,703.00 Budgeted 1,558.57 Remaining 8 % Used Account: 135-50028-021-000 Vision Insurance 25 10/11/2013 MUD Payroll 10/11/13 Vision Insurance 16.31 16.31 PR 100 10/25/2013 10/25/13 MUD Payroll Vision Insurance 11.90 28.21 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 28.21 28.21 ** 314.00 Budgeted 285.79 Remaining 9 % Used Account: 135-50029-021-000 Life Insurance & Other 2 10/01/2013 Reverse Prepaids Metlife Life, ADD & Other 117.97 117.97 GL 247 10/31/2013 Oct A/P FSA Adm fee/Oct 5.25 123.22 Discovery Benefits 33148 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 123.22 123.22 ** 1,066.00 Budgeted 942.78 Remaining 12 % Used Account: 135-50030-021-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 348.65 348.65 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 222.50 571.15 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 571.15 571.15 ** 7,442.00 Budgeted 6,870.85 Remaining 8 % Used Account: 135-50035-021-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 81.53 81.53 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 52.04 133.57 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 133.57 133.57 ** 1,741.00 Budgeted 1,607.43 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-021-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 .00 ** 198.00 Budgeted 198.00 Remaining 0 % Used Account: 135-50045-021-000 Workman's Compensation 47 10/01/2013 Oct Ins & W/C Expense 267.54 267.54 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 267.54 ** 3,276.00 Budgeted 3,008.46 Remaining 8 % Used Account: 135-50070-021-000 Employee Relations 226 10/26/2013 10/1-10/26 PCards DONUT HAVEN 8.99 8.99 DONUT HAVEN PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 8.99 8.99 ** 200.00 Budgeted 191.01 Remaining 4 % 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 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 (33.97) (33.97) THE HOME DEPOT 6581 PC 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 27.97 (6.00) THE HOME DEPOT 6581 PC 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 33.97 27.97 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 27.97 27.97 ** 23,801.00 Budgeted 23,773.03 Remaining 0 % Used Account: 135-55090-021-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-021-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 1,333.00 Budgeted 1,333.00 Remaining 0 % Used Account: 135-60020-021-000 Electricity 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 228.79 228.79 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 92.57 321.36 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/10 18.75 340.11 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 10.13 350.24 HUDSON ENERGY SERVICES, LLC 33097 AP 187 10/31/2013 Oct A/P Electricity 10/1/13 9.22 359.46 TRI COUNTY ELECTRIC 33137 AP 187 10/31/2013 Oct A/P Electricity 10/1/13 5.60 365.06 TRI COUNTY ELECTRIC 33137 AP 187 10/31/2013 Oct A/P Electricity 10/1/13 .88 365.94 TRI COUNTY ELECTRIC 33137 AP _______________ Account: 135-60020-021-000 Electricity Totals: 365.94 365.94 ** 21,178.00 Budgeted 20,812.06 Remaining 2 % 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 39 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 .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 236 10/31/2013 October Gas Log 1,030.84 1,030.84 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,030.84 1,030.84 ** 22,397.00 Budgeted 21,366.16 Remaining 5 % Used Account: 135-65010-021-000 Uniforms 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 157.24 157.24 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 175.00 332.24 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #81 243.90 576.14 ACADEMY SPORTS #81 PC _______________ Account: 135-65010-021-000 Uniforms Totals: 576.14 576.14 ** 1,040.00 Budgeted 463.86 Remaining 55 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 43.99 43.99 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-021-000 Small Tools Totals: 43.99 43.99 ** 1,000.00 Budgeted 956.01 Remaining 4 % Used Account: 135-65040-021-000 Safety Equipment 226 10/26/2013 10/1-10/26 PCards WW GRAINGER 540.75 540.75 WW GRAINGER PC _______________ Account: 135-65040-021-000 Safety Equipment Totals: 540.75 540.75 ** 500.00 Budgeted (40.75) Remaining 108 % Used Account: 135-69005-021-000 Capital Expenses .00 .00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 .00 ** 100,000.00 Budgeted 100,000.00 Remaining 0 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 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: ------------------------------------------------------------------------------------------------ 13,189.78 ** 472,170.00 Budgeted 458,980.22 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 500.00 500.00 PR 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 500.00 1,000.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,000.00 1,000.00 ** 10,000.00 Budgeted 9,000.00 Remaining 10 % Used Account: 135-50030-026-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 31.00 31.00 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 31.00 62.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 62.00 62.00 ** 620.00 Budgeted 558.00 Remaining 10 % Used Account: 135-50035-026-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 7.25 7.25 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 7.25 14.50 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 14.50 14.50 ** 145.00 Budgeted 130.50 Remaining 10 % Used Account: 135-50040-026-000 Unemployment Taxes 25 10/11/2013 MUD Payroll 10/11/13 Unemployment Taxes .50 .50 PR 100 10/25/2013 10/25/13 MUD Payroll Unemployment Taxes .50 1.00 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.00 1.00 ** 10.00 Budgeted 9.00 Remaining 10 % Used Account: 135-50045-026-000 Workman's Compensation 47 10/01/2013 Oct Ins & W/C Expense 2.95 2.95 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.95 2.95 ** 36.00 Budgeted 33.05 Remaining 8 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 226 10/26/2013 10/1-10/26 PCards RANDALLS STORE00017897 5.00 5.00 RANDALLS STORE00017897 PC _______________ Account: 135-60075-026-000 Meetings Totals: 5.00 5.00 ** 1,200.00 Budgeted 1,195.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training .00 .00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % 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: ------------------------------------------------------------------------------------------------ 1,085.45 ** 22,661.00 Budgeted 21,575.55 Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 16,573.51 16,573.51 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (10,657.37) 5,916.14 GL 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 17,300.01 23,216.15 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 23,216.15 23,216.15 ** 458,721.00 Budgeted 435,504.85 Remaining 5 % Used Account: 135-50010-030-000 Overtime 25 10/11/2013 MUD Payroll 10/11/13 Overtime 271.76 271.76 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (174.70) 97.06 GL 100 10/25/2013 10/25/13 MUD Payroll Overtime 114.01 211.07 PR _______________ Account: 135-50010-030-000 Overtime Totals: 211.07 211.07 ** 500.00 Budgeted 288.93 Remaining 42 % Used Account: 135-50016-030-000 Longevity .00 .00 _______________ Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 3,018.00 Budgeted 3,018.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 25 10/11/2013 MUD Payroll 10/11/13 Retirement 1,512.69 1,512.69 PR 100 10/25/2013 10/25/13 MUD Payroll Retirement 1,563.81 3,076.50 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,076.50 3,076.50 ** 41,419.00 Budgeted 38,342.50 Remaining 7 % Used Account: 135-50026-030-000 Medical Insurance 25 10/11/2013 MUD Payroll 10/11/13 Medical Insurance 2,194.07 2,194.07 PR 100 10/25/2013 10/25/13 MUD Payroll Medical Insurance 2,194.03 4,388.10 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 4,388.10 ** 57,923.00 Budgeted 53,534.90 Remaining 8 % Used Account: 135-50027-030-000 Dental Insurance 25 10/11/2013 MUD Payroll 10/11/13 Dental Insurance 193.19 193.19 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 100 10/25/2013 10/25/13 MUD Payroll Dental Insurance 193.15 386.34 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 386.34 386.34 ** 5,100.00 Budgeted 4,713.66 Remaining 8 % Used Account: 135-50028-030-000 Vision Insurance 25 10/11/2013 MUD Payroll 10/11/13 Vision Insurance 41.29 41.29 PR 100 10/25/2013 10/25/13 MUD Payroll Vision Insurance 41.24 82.53 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 82.53 ** 1,087.00 Budgeted 1,004.47 Remaining 8 % Used Account: 135-50029-030-000 Life Insurance & Other 2 10/01/2013 Reverse Prepaids Metlife Life, ADD & Other 300.02 300.02 GL 247 10/31/2013 Oct A/P FSA Adm fee/Oct 36.75 336.77 Discovery Benefits 33148 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 336.77 336.77 ** 4,483.00 Budgeted 4,146.23 Remaining 8 % Used Account: 135-50030-030-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 974.36 974.36 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 1,005.07 1,979.43 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,979.43 1,979.43 ** 28,659.00 Budgeted 26,679.57 Remaining 7 % Used Account: 135-50035-030-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 227.87 227.87 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 235.08 462.95 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 462.95 462.95 ** 6,702.00 Budgeted 6,239.05 Remaining 7 % Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 .00 ** 63.00 Budgeted 63.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 47 10/01/2013 Oct Ins & W/C Expense 128.63 128.63 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.63 128.63 ** 1,575.00 Budgeted 1,446.37 Remaining 8 % 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 221 10/21/2013 Flu Shots (45.00) (45.00) GL 226 10/26/2013 10/1-10/26 PCards MUGS CAFE - BAKERY 42.85 (2.15) MUGS CAFE - BAKERY PC 226 10/26/2013 10/1-10/26 PCards RECEPT PHARMACY 01 705.00 702.85 RECEPT PHARMACY 01 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 702.85 702.85 ** 5,000.00 Budgeted 4,297.15 Remaining 14 % Used Account: 135-55030-030-000 Software & Support 130 10/24/2013 October A/P Fire W/C, Charter, NCT COG Eme 645.50 645.50 TOWN OF TROPHY CLUB 33114 AP 130 10/24/2013 October A/P Annual Maintenance-camera van 1,980.00 2,625.50 PIPELOGIX, INC 33107 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 2,625.50 2,625.50 ** 59,698.00 Budgeted 57,072.50 Remaining 4 % Used Account: 135-55070-030-000 Independent Labor 114 10/23/2013 Oct A/P Rate Study 10/1-10/15 1,667.95 1,667.95 NEW GEN STRATEGIES & SOLUTIONS 33105 AP 130 10/24/2013 October A/P Record CAC meeting 37.50 1,705.45 MIGUEL CRUZ 33103 AP 130 10/24/2013 October A/P Record CAC meeting 45.00 1,750.45 JOHN CHARLES HALL 33098 AP 158 10/30/2013 Oct A/P Record CAC meeting 30.00 1,780.45 MIGUEL CRUZ 33132 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 1,780.45 1,780.45 ** 7,700.00 Budgeted 5,919.55 Remaining 23 % Used Account: 135-55080-030-000 Maintenance & Repairs .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 .00 ** 4,500.00 Budgeted 4,500.00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 31.98 31.98 THE HOME DEPOT 6581 PC 227 10/26/2013 10/26 PCards THE HOME DEPOT 6581 85.41 117.39 THE HOME DEPOT 6581 PC 155 10/30/2013 Oct A/P Re-key Terri's door 211.29 328.68 MICHAEL'S KEYS 33131 AP 261 10/31/2013 Town billed Inv 1102 AR 20131031-20131031 User: (188.84) 139.84 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 139.84 139.84 ** 6,500.00 Budgeted 6,360.16 Remaining 2 % Used Account: 135-55120-030-000 Cleaning Services .00 .00 _______________ Account: 135-55120-030-000 Cleaning Services Totals: .00 .00 ** 19,140.00 Budgeted 19,140.00 Remaining 0 % 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 33 10/09/2013 Oct A/P Contractual Services 1st insta 38,524.00 38,524.00 TOWN OF TROPHY CLUB 33087 AP _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: 38,524.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 Account: 135-55205-030-000 Utility Billing Contract . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 .00 ** 6,808.00 Budgeted 6,808.00 Remaining 0 % Used Account: 135-60005-030-000 Telephone 247 10/31/2013 Oct A/P Oct Answering Service 205.00 205.00 KEYSTONE PARK SECRETARIAL 33162 AP _______________ Account: 135-60005-030-000 Telephone Totals: 205.00 205.00 ** 11,250.00 Budgeted 11,045.00 Remaining 2 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 100 10/25/2013 10/25/13 MUD Payroll Communications/Pagers/Mobiles 150.00 150.00 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 150.00 150.00 ** 3,589.00 Budgeted 3,439.00 Remaining 4 % Used Account: 135-60020-030-000 Electricity/Gas .00 .00 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 15,171.00 Budgeted 15,171.00 Remaining 0 % Used Account: 135-60025-030-000 Water 247 10/31/2013 Oct A/P October water 202.52 202.52 TROPHY CLUB MUD (WATER BILLS) 33175 AP 234 10/31/2013 Town billed Inv 1101 AR 20131031-20131031 User: (101.26) 101.26 AR _______________ Account: 135-60025-030-000 Water Totals: 101.26 101.26 ** 1,500.00 Budgeted 1,398.74 Remaining 7 % Used Account: 135-60035-030-000 Postage 45 10/11/2013 Oct A/P Bulk mailing 868.10 868.10 U.S. POSTAL SERVICE 33088 AP 130 10/24/2013 October A/P Permit 3 200.00 1,068.10 U.S. POSTAL SERVICE 33116 AP 130 10/24/2013 October A/P overnight letter 6.17 1,074.27 FEDERAL EXPRESS CORP 33093 AP 235 10/31/2013 October Postage meter usage 293.05 1,367.32 GL 237 10/31/2013 Recode PPD Postage/Town inv's (100.00) 1,267.32 GL _______________ Account: 135-60035-030-000 Postage Totals: 1,267.32 1,267.32 ** 28,500.00 Budgeted 27,232.68 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees .00 .00 _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: .00 .00 ** 28,330.00 Budgeted 28,330.00 Remaining 0 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 47 10/01/2013 Oct Ins & W/C Expense 4,269.73 4,269.73 GL 247 10/31/2013 Oct A/P Blanket Notary 33.25 4,302.98 CNA SURETY 33145 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,302.98 4,302.98 ** 53,561.00 Budgeted 49,258.02 Remaining 8 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 130 10/24/2013 October A/P Dues/Membership 100.00 100.00 N CENTRAL TX COG 33104 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 100.00 100.00 ** 4,500.00 Budgeted 4,400.00 Remaining 2 % Used 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60100-030-000 Travel & per diem .00 .00 _______________ Account: 135-60100-030-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % 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 .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 226 10/26/2013 10/1-10/26 PCards RANDALLS STORE00017897 5.12 5.12 RANDALLS STORE00017897 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 226 10/26/2013 10/1-10/26 PCards WAL-MART #5247 14.58 19.70 WAL-MART #5247 PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 19.70 19.70 ** 22,870.00 Budgeted 22,850.30 Remaining 0 % 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 .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 1,390.00 Budgeted 1,390.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 226 10/26/2013 10/1-10/26 PCards BEST BUY 00001487 305.97 305.97 BEST BUY 00001487 PC _______________ Account: 135-65055-030-000 Hardware Totals: 305.97 305.97 ** 13,562.00 Budgeted 13,256.03 Remaining 2 % Used Account: 135-65085-030-000 Office Supplies 226 10/26/2013 10/1-10/26 PCards FEDEXOFFICE 00019364 156.16 156.16 FEDEXOFFICE 00019364 PC 226 10/26/2013 10/1-10/26 PCards OFFICE DEPOT #406 94.25 250.41 OFFICE DEPOT #406 PC 158 10/30/2013 Oct A/P Office Supplies 274.97 525.38 OFFICE DEPOT, INC 33133 AP 158 10/30/2013 Oct A/P Office Supplies 21.99 547.37 OFFICE DEPOT, INC 33133 AP 247 10/31/2013 Oct A/P Office supplies 153.60 700.97 OFFICE DEPOT, INC 33166 AP 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (27.49) 673.48 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 673.48 673.48 ** 9,100.00 Budgeted 8,426.52 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 5,732.00 Budgeted 5,732.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 226 10/26/2013 10/1-10/26 PCards SAMSCLUB #4795 94.40 94.40 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 94.40 94.40 ** 2,500.00 Budgeted 2,405.60 Remaining 4 % Used Account: 135-65097-030-000 Vending Machine Supplies 220 10/15/2013 WWTP Vending 27.06 27.06 GL _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: 27.06 27.06 ** 200.00 Budgeted 172.94 Remaining 14 % Used Account: 135-65105-030-000 Printing 130 10/24/2013 October A/P printing 1,401.00 1,401.00 LOGAN GRAPHICS, INC 33100 AP _______________ Account: 135-65105-030-000 Printing Totals: 1,401.00 1,401.00 ** 4,000.00 Budgeted 2,599.00 Remaining 35 % Used Account: 135-69170-030-000 Copier Lease Installments 155 10/30/2013 Oct A/P Copier lease, FD Communication 256.85 256.85 TOWN OF TROPHY CLUB 33135 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 256.85 ** 3,450.00 Budgeted 3,193.15 Remaining 7 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 86,946.13 ** 1,055,199.00 Budgeted 968,252.87 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal .00 .00 _______________ Account: 135-55045-039-000 Legal Totals: .00 .00 ** 131,300.00 Budgeted 131,300.00 Remaining 0 % Used Account: 135-55055-039-000 Auditing .00 .00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 .00 ** 21,840.00 Budgeted 21,840.00 Remaining 0 % Used Account: 135-55060-039-000 Appraisal 247 10/31/2013 Oct A/P Annual Budget Allocation 2,415.89 2,415.89 TARRANT APPRAISAL DISTRICT 33171 AP 187 10/31/2013 Oct A/P 2013 Taxes 3.996 Acres 928.81 3,344.70 DENTON COUNTY TAX OFFICE 33136 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 3,344.70 3,344.70 ** 10,000.00 Budgeted 6,655.30 Remaining 33 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 3,800.00 Budgeted 3,800.00 Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 3,344.70 ** 166,940.00 Budgeted 163,595.30 Remaining 2 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (214,207.25) .00 Budgeted 214,207.25 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 225 10/31/2013 Bank Interest/Oct (13.98) (13.98) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (13.98) (13.98) ** .00 Budgeted 13.98 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (13.98) ** .00 Budgeted 13.98 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter 158 10/30/2013 Oct A/P ROFC Project 2,360.00 2,360.00 DHS AUTOMATION, INC 33126 AP 247 10/31/2013 Oct A/P ROFC Project 525.00 2,885.00 DELTATEK ENGINEERING 33147 AP _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: 2,885.00 2,885.00 ** .00 Budgeted (2,885.00) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,885.00 ** .00 Budgeted (2,885.00) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 2,871.02 .00 Budgeted (2,871.02) Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET OCTOBER 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 20,342 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 395,746 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 420,934 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 395,746 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 395,746 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 7,310 TOTAL FUND BALANCE 25,188 TOTAL LIABILITIES AND FUND BALANCE 420,934 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 18:59 11/13/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2013 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- 7,315.96- 7,315.96- 1.880 381,900.04- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 19.78 19.78 -.791 2,519.78- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 12.81- 12.81- .801 1,587.19- Subtotal: 393,316.00- 393,316.00- 7,308.99- 7,308.99- 1.858 386,007.01- 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- .58- .58- .155 374.42- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- Subtotal: 214,654.00- 214,654.00- .58- .58- 214,653.42- Program number: 624,495.00- 624,495.00- 7,309.57- 7,309.57- 1.170 617,185.43- Department number: Revenues 624,495.00- 624,495.00- 7,309.57- 7,309.57- 1.170 617,185.43- Revenues Subtotal ----------- 624,495.00- 624,495.00- 7,309.57- 7,309.57- 1.170 617,185.43- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 18:59 11/13/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,300.00 2,300.00 2,300.00 533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 197,195.00 533-70035-051-000 Bond Principal Payment 425,000.00 425,000.00 425,000.00 Subtotal: 624,495.00 624,495.00 624,495.00 Program number: 624,495.00 624,495.00 624,495.00 Department number: Administration 624,495.00 624,495.00 624,495.00 Expenditures Subtotal ----------- 624,495.00 624,495.00 624,495.00 Fund number: 533 MUD 1 I&S Consolidated 7,309.57- 7,309.57- 7,309.57 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 199 10/14/2013 Property Taxes/Assessments (138.79) (138.79) GL 200 10/15/2013 Property Taxes/Assessments (73.81) (212.60) GL 202 10/16/2013 Property Taxes/Assessments (291.57) (504.17) GL 203 10/17/2013 Property Taxes/Assessments (39.74) (543.91) GL 207 10/21/2013 Property Taxes/Assessments (1,426.19) (1,970.10) GL 208 10/22/2013 Property Taxes/Assessments (546.19) (2,516.29) GL 209 10/23/2013 Property Taxes/Assessments (1,012.34) (3,528.63) GL 210 10/24/2013 Property Taxes/Assessments (1,144.37) (4,673.00) GL 211 10/25/2013 Property Taxes/Assessments (472.47) (5,145.47) GL 212 10/28/2013 Property Taxes/Assessments (609.20) (5,754.67) GL 213 10/29/2013 Property Taxes/Assessments (435.09) (6,189.76) GL 214 10/30/2013 Property Taxes/Assessments (90.07) (6,279.83) GL 215 10/31/2013 Property Taxes/Assessments (1,036.13) (7,315.96) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (7,315.96) (7,315.96) ** (389,216.00) Budgeted (381,900.04) Remaining 2 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 199 10/14/2013 Property Taxes/Assessments 46.79 46.79 GL 202 10/16/2013 Property Taxes/Assessments (32.75) 14.04 GL 211 10/25/2013 Property Taxes/Assessments (4.85) 9.19 GL 212 10/28/2013 Property Taxes/Assessments (.27) 8.92 GL 213 10/29/2013 Property Taxes/Assessments 18.79 27.71 GL 215 10/31/2013 Property Taxes/Assessments (7.93) 19.78 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 19.78 19.78 ** (2,500.00) Budgeted (2,519.78) Remaining -1 % Used Account: 533-40015-000-000 Property Taxes/P & I 199 10/14/2013 Property Taxes/Assessments (3.20) (3.20) GL 202 10/16/2013 Property Taxes/Assessments (6.88) (10.08) GL 211 10/25/2013 Property Taxes/Assessments (1.02) (11.10) GL 212 10/28/2013 Property Taxes/Assessments (.05) (11.15) GL 215 10/31/2013 Property Taxes/Assessments (1.66) (12.81) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (12.81) (12.81) ** (1,600.00) Budgeted (1,587.19) Remaining 1 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (16,525.00) Budgeted (16,525.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 225 10/31/2013 Bank Interest/Oct (.58) (.58) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (.58) (.58) ** (375.00) Budgeted (374.42) Remaining 0 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (214,279.00) Budgeted (214,279.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (7,309.57) ** (624,495.00) Budgeted (617,185.43) Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,300.00 Budgeted 2,300.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 .00 ** 197,195.00 Budgeted 197,195.00 Remaining 0 % 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: ------------------------------------------------------------------------------------------------ .00 ** 624,495.00 Budgeted 624,495.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (7,309.57) .00 Budgeted 7,309.57 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (195,072.27) **** .00 Budgeted 195,072.27 Remaining 0 % Used ******* End of Report *********