Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
November Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2013 122 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 581,122 PREPAID EXPENSES 16,720 ADVALOREM PROPERTY TAXES RECEIVABLE 895,461 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 288,836 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,857 TOTAL ASSETS 1,784,996 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,184,297 ACCOUNTS AND OTHER PAYABLES 163,293 TOTAL LIABILITIES 1,347,590 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE 2,141 UNASSIGNED FUND BALANCE 493,547 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (58,282) TOTAL FUND BALANCE 437,406 TOTAL LIABILITIES AND FUND BALANCE 1,784,996 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 10:26 12/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/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- 12,150.13- 17,723.22- 5.802 287,721.78- 122-40003-000-000 Emer Svcs Assessmen/Delinquent .65- .65- .65 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 31,947.38- 49,385.02- 5.324 878,169.98- 122-40011-000-000 Property Taxes/Fire-Delinquent .56- 104.96 104.96- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- .15- .15- .020 749.85- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- .13- 68.49- 1.522 4,431.51- Subtotal: 1,238,250.00- 1,238,250.00- 44,099.00- 67,072.57- 5.417 1,171,177.43- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 800.00- 800.00- 13.333 5,200.00- Subtotal: 6,000.00- 6,000.00- 800.00- 800.00- 13.333 5,200.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 150.00- 150.00- 21.429 550.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- 150.00- 150.00- 1.402 10,550.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 1,250.00- 1,250.00- 20.833 4,750.00- Subtotal: 6,000.00- 6,000.00- 1,250.00- 1,250.00- 20.833 4,750.00- Program number: 1,260,950.00- 1,260,950.00- 46,299.00- 69,272.57- 5.494 1,191,677.43- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 46,299.00- 69,272.57- 5.494 1,191,677.43- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 46,299.00- 69,272.57- 5.494 1,191,677.43- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 10:26 12/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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 43,244.76 67,426.41 14.789 388,489.59 122-50010-045-000 Overtime 44,225.00 44,225.00 2,169.26 5,343.60 12.083 38,881.40 122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,289.86 13,289.86 98.232 239.14 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 350.00 726.89 16.710 3,623.11 122-50020-045-000 Retirement 70,991.00 70,991.00 8,162.31 11,890.49 16.749 59,100.51 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,008.66 8,017.15 14.073 48,950.85 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 326.27 652.46 15.425 3,577.54 122-50028-045-000 Vision Insurance 892.00 892.00 68.41 136.71 15.326 755.29 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 306.95 613.74 14.441 3,636.26 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 3,465.17 5,027.29 15.243 27,952.71 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 810.21 1,175.41 15.239 6,537.59 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 .77 1.58 .070 2,257.42 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.79 1,325.58 15.223 7,382.42 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 76,865.42 115,627.17 16.220 597,251.83 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 497.01 715.41 3.495 19,756.59 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 1,241.83 1,241.83 8.362 13,608.17 Subtotal: 49,004.00 49,004.00 1,738.84 1,957.24 3.994 47,046.76 122-60005-045-000 Telephone 100.00 100.00 3.34 3.34 3.340 96.66 122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 214.36 671.74 15.854 3,565.26 122-60020-045-000 Electricity/Gas 6,568.00 6,568.00 454.87 657.92 10.017 5,910.08 122-60025-045-000 Water 1,500.00 1,500.00 87.94- 20.45 1.363 1,479.55 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.100 96.90 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 2,018.50 16.668 10,091.50 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 10.394 13,602.24 122-60080-045-000 Schools & Training 4,280.00 4,280.00 1,064.00 24.860 3,216.00 122-60096-045-000 Emergency Management 2,000.00 2,000.00 1,000.00 50.000 1,000.00 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 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 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 10:26 12/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 276,531.00 276,531.00 1,593.88 8,422.80 3.046 268,108.20 122-65005-045-000 Fuel & Lube 11,698.00 11,698.00 691.47 1,429.50 12.220 10,268.50 122-65010-045-000 Uniforms 3,360.00 3,360.00 89.83 89.83 2.674 3,270.17 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 27.49 27.49 2.749 972.51 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 27,258.00 808.79 1,546.82 5.675 25,711.18 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 81,006.93 127,554.03 10.116 1,133,395.97 Department number: Fire 1,260,950.00 1,260,950.00 81,006.93 127,554.03 10.116 1,133,395.97 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 81,006.93 127,554.03 10.116 1,133,395.97 Fund number: 122 Trophy Club MUD Fire Dept. 34,707.93 58,281.46 58,281.46- . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/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 394 11/01/2013 Property Taxes/Assessments (5,573.09) (677.60) (6,250.69) GL 395 11/04/2013 Property Taxes/Assessments (468.27) (6,718.96) GL 396 11/05/2013 Property Taxes/Assessments (818.98) (7,537.94) GL 397 11/06/2013 Property Taxes/Assessments (255.41) (7,793.35) GL 398 11/07/2013 Property Taxes/Assessments (316.48) (8,109.83) GL 399 11/08/2013 Property Taxes/Assessments (1,207.99) (9,317.82) GL 400 11/12/2013 Property Taxes/Assessments (672.26) (9,990.08) GL 401 11/13/2013 Property Taxes/Assessments (1,056.14) (11,046.22) GL 402 11/14/2013 Property Taxes/Assessments (341.85) (11,388.07) GL 403 11/15/2013 Property Taxes/Assessments (50.62) (11,438.69) GL 404 11/18/2013 Property Taxes/Assessments (39.20) (11,477.89) GL 405 11/19/2013 Property Taxes/Assessments (1,264.22) (12,742.11) GL 406 11/20/2013 Property Taxes/Assessments (853.41) (13,595.52) GL 407 11/21/2013 Property Taxes/Assessments (333.46) (13,928.98) GL 408 11/22/2013 Property Taxes/Assessments (315.22) (14,244.20) GL 409 11/25/2013 Property Taxes/Assessments (1,026.48) (15,270.68) GL 410 11/26/2013 Property Taxes/Assessments (1,943.72) (17,214.40) GL 411 11/27/2013 Property Taxes/Assessments (508.82) (17,723.22) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (12,150.13) (17,723.22) ** (305,445.00) Budgeted (287,721.78) Remaining 6 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 396 11/05/2013 Property Taxes/Assessments (.65) (.65) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (.65) (.65) ** .00 Budgeted .65 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 394 11/01/2013 Property Taxes/Assessments (17,437.64) (1,256.98) (18,694.62) GL 395 11/04/2013 Property Taxes/Assessments (1,453.41) (20,148.03) GL 396 11/05/2013 Property Taxes/Assessments (2,360.22) (22,508.25) GL 397 11/06/2013 Property Taxes/Assessments (275.39) (22,783.64) GL 398 11/07/2013 Property Taxes/Assessments (185.21) (22,968.85) GL 399 11/08/2013 Property Taxes/Assessments (1,449.94) (24,418.79) GL 400 11/12/2013 Property Taxes/Assessments (1,558.98) (25,977.77) GL 401 11/13/2013 Property Taxes/Assessments (862.30) (26,840.07) GL 402 11/14/2013 Property Taxes/Assessments (814.63) (27,654.70) GL 403 11/15/2013 Property Taxes/Assessments (555.07) (28,209.77) GL 404 11/18/2013 Property Taxes/Assessments (8,858.26) (37,068.03) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 405 11/19/2013 Property Taxes/Assessments (17,437.64) (895.41) (37,963.44) GL 406 11/20/2013 Property Taxes/Assessments (3,587.77) (41,551.21) GL 407 11/21/2013 Property Taxes/Assessments (957.94) (42,509.15) GL 408 11/22/2013 Property Taxes/Assessments (457.44) (42,966.59) GL 409 11/25/2013 Property Taxes/Assessments (3,273.52) (46,240.11) GL 410 11/26/2013 Property Taxes/Assessments (1,954.46) (48,194.57) GL 411 11/27/2013 Property Taxes/Assessments (1,190.45) (49,385.02) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (31,947.38) (49,385.02) ** (927,555.00) Budgeted (878,169.98) Remaining 5 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 396 11/05/2013 Property Taxes/Assessments 105.52 (.56) 104.96 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (.56) 104.96 ** .00 Budgeted (104.96) Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 396 11/05/2013 Property Taxes/Assessments (.15) (.15) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (.15) (.15) ** (750.00) Budgeted (749.85) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 396 11/05/2013 Property Taxes/Assessments (68.36) (.13) (68.49) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (.13) (68.49) ** (4,500.00) Budgeted (4,431.51) Remaining 2 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (800.00) (800.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (800.00) (800.00) ** (6,000.00) Budgeted (5,200.00) Remaining 13 % Used Account: 122-43400-000-000 Fire Inspections 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (150.00) (150.00) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/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-43400-000-000 Fire Inspections Totals: (150.00) (150.00) ** (700.00) Budgeted (550.00) Remaining 21 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (1,250.00) (1,250.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,250.00) (1,250.00) ** (6,000.00) Budgeted (4,750.00) Remaining 21 % Used Department Totals: ------------------------------------------------------------------------------------------------ (69,272.57) ** (1,260,950.00) Budgeted (1,191,677.43) Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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 246 11/08/2013 Fire Dept Payroll 11/8/13 24,181.65 16,926.97 41,108.62 GL 378 11/22/2013 FD Stipend 9,150.00 50,258.62 GL 380 11/22/2013 FD Payroll 11/22/13 17,167.79 67,426.41 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 43,244.76 67,426.41 ** 455,916.00 Budgeted 388,489.59 Remaining 15 % Used Account: 122-50010-045-000 Overtime 380 11/22/2013 FD Payroll 11/22/13 3,174.34 2,169.26 5,343.60 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,169.26 5,343.60 ** 44,225.00 Budgeted 38,881.40 Remaining 12 % Used Account: 122-50011-045-000 DPS Holiday Pay 379 11/22/2013 FD Holiday Pay 13,289.86 13,289.86 GL _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: 13,289.86 13,289.86 ** 13,529.00 Budgeted 239.14 Remaining 98 % 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 246 11/08/2013 Fire Dept Payroll 11/8/13 376.89 350.00 726.89 GL _______________ Account: 122-50017-045-000 Certification Totals: 350.00 726.89 ** 4,350.00 Budgeted 3,623.11 Remaining 17 % Used Account: 122-50020-045-000 Retirement 246 11/08/2013 Fire Dept Payroll 11/8/13 3,728.18 2,353.64 6,081.82 GL 378 11/22/2013 FD Stipend 1,286.49 7,368.31 GL 379 11/22/2013 FD Holiday Pay 1,868.51 9,236.82 GL 380 11/22/2013 FD Payroll 11/22/13 2,653.67 11,890.49 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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: 8,162.31 11,890.49 ** 70,991.00 Budgeted 59,100.51 Remaining 17 % Used Account: 122-50026-045-000 Medical Insurance 246 11/08/2013 Fire Dept Payroll 11/8/13 4,008.49 2,297.55 6,306.04 GL 380 11/22/2013 FD Payroll 11/22/13 1,711.11 8,017.15 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,008.66 8,017.15 ** 56,968.00 Budgeted 48,950.85 Remaining 14 % Used Account: 122-50027-045-000 Dental Insurance 246 11/08/2013 Fire Dept Payroll 11/8/13 326.19 163.13 489.32 GL 380 11/22/2013 FD Payroll 11/22/13 163.14 652.46 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 326.27 652.46 ** 4,230.00 Budgeted 3,577.54 Remaining 15 % Used Account: 122-50028-045-000 Vision Insurance 246 11/08/2013 Fire Dept Payroll 11/8/13 68.30 34.22 102.52 GL 380 11/22/2013 FD Payroll 11/22/13 34.19 136.71 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 68.41 136.71 ** 892.00 Budgeted 755.29 Remaining 15 % Used Account: 122-50029-045-000 Life Insurance & Other 246 11/08/2013 Fire Dept Payroll 11/8/13 306.79 153.48 460.27 GL 380 11/22/2013 FD Payroll 11/22/13 153.47 613.74 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 306.95 613.74 ** 4,250.00 Budgeted 3,636.26 Remaining 14 % Used Account: 122-50030-045-000 Social Security Taxes 246 11/08/2013 Fire Dept Payroll 11/8/13 1,562.12 973.13 2,535.25 GL 378 11/22/2013 FD Stipend 567.30 3,102.55 GL 379 11/22/2013 FD Holiday Pay 823.94 3,926.49 GL 380 11/22/2013 FD Payroll 11/22/13 1,100.80 5,027.29 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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-50030-045-000 Social Security Taxes Totals: 3,465.17 5,027.29 ** 32,980.00 Budgeted 27,952.71 Remaining 15 % Used Account: 122-50035-045-000 Medicare Taxes 246 11/08/2013 Fire Dept Payroll 11/8/13 365.20 227.51 592.71 GL 378 11/22/2013 FD Stipend 132.66 725.37 GL 379 11/22/2013 FD Holiday Pay 192.66 918.03 GL 380 11/22/2013 FD Payroll 11/22/13 257.38 1,175.41 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 810.21 1,175.41 ** 7,713.00 Budgeted 6,537.59 Remaining 15 % Used Account: 122-50040-045-000 Unemployment Taxes 246 11/08/2013 Fire Dept Payroll 11/8/13 .81 .45 1.26 GL 380 11/22/2013 FD Payroll 11/22/13 .32 1.58 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .77 1.58 ** 2,259.00 Budgeted 2,257.42 Remaining 0 % Used Account: 122-50045-045-000 Workman's Compensation 117 11/01/2013 FD Nov W/C expense 662.79 662.79 1,325.58 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.79 1,325.58 ** 8,708.00 Budgeted 7,382.42 Remaining 15 % 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 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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 368 11/07/2013 Firefighters Assoc/Nov Cable 218.40 (120.00) 98.40 GL 324 11/22/2013 Nov A/P Qtrly pest control' 140.00 238.40 GANN'S PEST CONTROL 33189 AP 324 11/22/2013 Nov A/P Fire extinquisher maint Fire S 291.50 529.90 KIMBROUGH FIRE EXTINQUISHER CO 33194 AP 350 11/30/2013 Nov A/P Bauer Air Compressor Repair 161.00 690.90 AUGUST INDUSTRIES, INC 33214 AP 350 11/30/2013 Nov A/P Rug Service/Fire Station 24.51 715.41 G & K SERVICES 33220 AP 350 11/30/2013 Nov A/P Rug Service/Fire Station 24.51 739.92 G & K SERVICES 33220 AP 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (24.51) 715.41 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 497.01 715.41 ** 20,472.00 Budgeted 19,756.59 Remaining 3 % Used Account: 122-55090-045-000 Vehicle Maintenance 324 11/22/2013 Nov A/P 2007 pumper #681/Compressor 1,241.83 1,241.83 SIDDONS-MARTIN EMERGENCY GROUP 33203 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 1,241.83 1,241.83 ** 14,850.00 Budgeted 13,608.17 Remaining 8 % Used Account: 122-60005-045-000 Telephone 324 11/22/2013 Nov A/P BOA PCards IT 3.34 3.34 TOWN OF TROPHY CLUB 33208 AP _______________ Account: 122-60005-045-000 Telephone Totals: 3.34 3.34 ** 100.00 Budgeted 96.66 Remaining 3 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 246 11/08/2013 Fire Dept Payroll 11/8/13 457.38 75.00 532.38 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 324 11/22/2013 Nov A/P Shi, Charter, Verizon 457.38 139.36 671.74 TOWN OF TROPHY CLUB 33208 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 214.36 671.74 ** 4,237.00 Budgeted 3,565.26 Remaining 16 % Used Account: 122-60020-045-000 Electricity/Gas 324 11/22/2013 Nov A/P Electricity 10/11/13-11/11/13 203.05 814.23 1,017.28 HUDSON ENERGY SERVICES, LLC 33191 AP 350 11/30/2013 Nov A/P Gas/Fire Station 95.49 1,112.77 ATMOS ENERGY 33213 AP 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (454.85) 657.92 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 454.87 657.92 ** 6,568.00 Budgeted 5,910.08 Remaining 10 % Used Account: 122-60025-045-000 Water 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: 108.39 (87.94) 20.45 AR _______________ Account: 122-60025-045-000 Water Totals: (87.94) 20.45 ** 1,500.00 Budgeted 1,479.55 Remaining 1 % 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 Account: 122-60035-045-000 Postage 3.10 .00 3.10 _______________ Account: 122-60035-045-000 Postage Totals: .00 3.10 ** 100.00 Budgeted 96.90 Remaining 3 % Used Account: 122-60055-045-000 Insurance 48 11/01/2013 Nov Ins & W/C Expense 1,009.25 1,009.25 2,018.50 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 2,018.50 ** 12,110.00 Budgeted 10,091.50 Remaining 17 % Used Account: 122-60066-045-000 Publications/Books/Subscrips . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 1,577.76 .00 1,577.76 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 1,577.76 ** 15,180.00 Budgeted 13,602.24 Remaining 10 % Used Account: 122-60080-045-000 Schools & Training 1,064.00 .00 1,064.00 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 1,064.00 ** 4,280.00 Budgeted 3,216.00 Remaining 25 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 2,000.00 Budgeted 1,000.00 Remaining 50 % Used Account: 122-60100-045-000 Travel & per diem 1,064.82 .00 1,064.82 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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-60125-045-000 Advertising Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 341.17 .00 341.17 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 341.17 ** 4,500.00 Budgeted 4,158.83 Remaining 8 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement .00 .00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-60195-045-000 Flags & Repair .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 415 11/30/2013 Nov Gaslog 738.03 691.47 1,429.50 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 691.47 1,429.50 ** 11,698.00 Budgeted 10,268.50 Remaining 12 % Used Account: 122-65010-045-000 Uniforms 350 11/30/2013 Nov A/P Uniform pants, shirt 174.35 174.35 Alainavision, Inc 33212 AP 350 11/30/2013 Nov A/P Name ribbon 5.30 179.65 Alainavision, Inc 33212 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (89.82) 89.83 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 89.83 89.83 ** 3,360.00 Budgeted 3,270.17 Remaining 3 % 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 _______________ 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 324 11/22/2013 Nov A/P Office Supplies 27.49 27.49 OFFICE DEPOT, INC 33201 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 27.49 27.49 ** 1,000.00 Budgeted 972.51 Remaining 3 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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-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 _______________ 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: ------------------------------------------------------------------------------------------------ 127,554.03 ** 1,260,950.00 Budgeted 1,133,395.97 Remaining 10 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 58,281.46 .00 Budgeted (58,281.46) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET NOVEMBER 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 11/30/13 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 450,842 - - 450,842 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,500,684 - - 1,500,684 INVESTMENTS-TEXPOOL 869,168 313,050 330,598 1,512,816 PREPAID EXPENSES 62,245 - - 62,245 ADVALOREM PROPERTY TAXES RECEIVABLE 96,163 - - 96,163 UTILITY AND OTHER ACCOUNTS RECEIVABLE 796,591 - - 796,591 - TOTAL ASSETS 3,776,293 313,050 330,598 4,419,941 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 96,163 - - 96,163 ACCOUNTS AND OTHER PAYABLES 224,820 - 138,751 363,571 CUSTOMER DEPOSITS 239,182 - - 239,182 - TOTAL LIABILITIES 560,165 - 138,751 698,916 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 313,050 313,050 NON-SPENDABLE FUND BALANCE 29,524 29,524 ASSIGNED FUND BALANCE 276,500 245,101 521,601 UNASSIGNED FUND BALANCE 2,682,452 - - 2,682,452 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES 227,652 - (53,254) 174,398 - TOTAL FUND BALANCE 3,216,128 313,050 191,847 3,721,025 - TOTAL LIABILITIES AND FUND BALANCE 3,776,293 313,050 330,598 4,419,941 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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- 3,418.50- 5,284.39- 5.324 93,965.61- 135-40002-000-000 Property Taxes/Delinquent .06- 9.97 9.97- 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 3.39- 30.91 -3.434 930.91- Subtotal: 100,150.00- 100,150.00- 3,421.95- 5,243.51- 5.236 94,906.49- 135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 198,627.00- 439,722.25- 11.728 3,309,587.75- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 147,563.41- 287,864.46- 16.851 1,420,456.54- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 5,490.70- 12,664.85- 19.629 51,857.15- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 878.00- 1,656.00- 18.248 7,419.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 250.00- 450.00- 37.500 750.00- 135-47045-000-000 Sewer Inspections 4,400.00- 4,400.00- 600.00- 1,500.00- 34.091 2,900.00- 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 522.90- 7,795.20- 9.795 71,790.80- Subtotal: 5,616,414.00- 5,616,414.00- 353,932.01- 751,652.76- 13.383 4,864,761.24- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 29,900.00- 64,400.00- 11.063 517,709.00- Subtotal: 582,109.00- 582,109.00- 29,900.00- 64,400.00- 11.063 517,709.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 519.66- 988.31- 20.590 3,811.69- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 1,821.06- 17.917 8,342.94- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,166.66- 16.667 5,833.34- 135-49030-000-000 Vending Revenue 350.00- 350.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- 6,174.00- 14,568.20- 17.343 69,431.80- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- .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- 8,187.52- 18,585.24- 15.583 100,678.76- Program number: 6,417,937.00- 6,417,937.00- 395,441.48- 839,881.51- 13.086 5,578,055.49- Department number: Revenues 6,417,937.00- 6,417,937.00- 395,441.48- 839,881.51- 13.086 5,578,055.49- Revenues Subtotal ----------- 6,417,937.00- 6,417,937.00- 395,441.48- 839,881.51- 13.086 5,578,055.49- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 19,115.85 31,033.68 10.786 256,675.32 135-50010-010-000 Overtime 13,391.00 13,391.00 1,260.05 2,033.87 15.188 11,357.13 135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 4,905.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 325.00 650.00 12.745 4,450.00 135-50020-010-000 Retirement 27,847.00 27,847.00 2,299.40 3,912.26 14.049 23,934.74 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 2,642.45 5,020.65 10.387 43,313.35 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 221.68 427.91 10.883 3,504.09 135-50028-010-000 Vision Insurance 873.00 873.00 50.16 95.93 10.989 777.07 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 139.73 295.21 8.930 3,010.79 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,575.38 2,676.00 13.873 16,613.00 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 368.44 625.83 13.873 3,885.17 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 1,604.90 16.328 8,224.10 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 136.00 172.45 86.225 27.55 135-50070-010-000 Employee Relations 300.00 300.00 8.99 2.997 291.01 Subtotal: 429,580.00 429,580.00 33,841.59 53,462.68 12.445 376,117.32 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 561.66 7,036.11 14.072 42,963.89 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 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 245.00 245.00 4.455 5,255.00 Subtotal: 67,000.00 67,000.00 806.66 8,165.26 12.187 58,834.74 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 665.28 665.28 13.541 4,247.72 135-60020-010-000 Electricity 162,160.00 162,160.00 12,017.69 17,735.11 10.937 144,424.89 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 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 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 12,682.97 18,686.99 .728 2,548,893.01 135-65005-010-000 Fuel & Lube 23,181.00 23,181.00 627.40 1,783.84 7.695 21,397.16 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 2.752 3,180.01 135-65030-010-000 Chemicals 5,000.00 5,000.00 43.80 1,027.76 20.555 3,972.24 135-65035-010-000 Small Tools 1,200.00 1,200.00 464.94 38.745 735.06 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 143,550.00 143,550.00 54,740.30 38.133 88,809.70 Subtotal: 177,201.00 177,201.00 671.20 58,106.83 32.791 119,094.17 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 69,788.02 69,788.02 65.316 37,058.98 Subtotal: 690,595.00 690,595.00 69,788.02 69,788.02 10.105 620,806.98 Program number: 3,931,956.00 3,931,956.00 117,790.44 208,209.78 5.295 3,723,746.22 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/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 60.00 60.00 6.000 940.00 Subtotal: 1,000.00 1,000.00 60.00 60.00 6.000 940.00 135-60135-010-001 TCEQ Fees & Permits 4,403.85 4,403.85 4,403.85- Subtotal: 4,403.85 4,403.85 4,403.85- Program number: 1 Lab Analysis for PID 1,000.00 1,000.00 4,463.85 4,463.85 446.385 3,463.85- Department number: Water 3,932,956.00 3,932,956.00 122,254.29 212,673.63 5.407 3,720,282.37 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 15,174.92 25,387.63 12.513 177,506.37 135-50010-020-000 Overtime 11,965.00 11,965.00 1,321.98 2,105.12 17.594 9,859.88 135-50016-020-000 Longevity 2,998.00 2,998.00 2,997.50 2,997.50 99.983 .50 135-50017-020-000 Certification 4,800.00 4,800.00 400.00 800.00 16.667 4,000.00 135-50020-020-000 Retirement 19,905.00 19,905.00 1,786.53 3,278.23 16.469 16,626.77 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,293.23 6,586.46 15.151 36,884.54 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 226.46 452.92 15.153 2,536.08 135-50028-020-000 Vision Insurance 658.00 658.00 49.93 99.86 15.176 558.14 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 152.40 320.55 13.919 1,982.45 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 1,098.01 1,992.35 14.432 11,812.65 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 256.80 465.95 14.430 2,763.05 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 1,070.16 16.333 5,481.84 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 63.00 63.00 42.000 87.00 135-50070-020-000 Employee Relations 350.00 350.00 8.99 2.569 341.01 Subtotal: 316,105.00 316,105.00 27,355.84 45,628.72 14.435 270,476.28 135-55070-020-000 Independent Labor 93,756.25 93,756.25 93,756.25- 135-55080-020-000 Maintenance & Repairs 35,000.00 35,000.00 112.36- 250.66 .716 34,749.34 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 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 9.793 27,062.00 Subtotal: 119,500.00 119,500.00 93,643.89 97,086.89 81.244 22,413.11 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 169.77 169.77 5.100 3,159.23 135-60020-020-000 Electricity 148,227.00 148,227.00 9,536.67 12,792.99 8.631 135,434.01 135-60066-020-000 Publications/Books/Subscripts 400.00 400.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 15.420 211.45 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 85.43 85.43 8.136 964.57 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 17,838.00 17,838.00 104.012 688.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 27,629.87 31,264.27 17.540 146,977.73 135-65005-020-000 Fuel & Lube 14,720.00 14,720.00 762.48 1,734.99 11.787 12,985.01 135-65010-020-000 Uniforms 1,752.00 1,752.00 1,284.28 73.304 467.72 135-65030-020-000 Chemicals 39,000.00 39,000.00 2,949.64 7.563 36,050.36 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-020-000 Small Tools 1,000.00 1,000.00 47.34 4.734 952.66 135-65040-020-000 Safety Equipment 250.00 250.00 56.43 22.572 193.57 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 4,284.43 28.563 10,715.57 Subtotal: 71,722.00 71,722.00 762.48 10,357.11 14.441 61,364.89 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 149,392.08 184,336.99 24.002 583,674.01 Department number: Wastewater 768,011.00 768,011.00 149,392.08 184,336.99 24.002 583,674.01 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/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,859.85 11,318.49 12.534 78,980.51 135-50010-021-000 Overtime 10,028.00 10,028.00 552.24 1,288.56 12.850 8,739.44 135-50016-021-000 Longevity 17,913.00 17,913.00 2,107.50 2,107.50 11.765 15,805.50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 300.00 16.667 1,500.00 135-50020-021-000 Retirement 9,025.00 9,025.00 778.54 1,703.31 18.873 7,321.69 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,793.06 3,850.37 16.268 19,817.63 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 128.98 273.41 16.055 1,429.59 135-50028-021-000 Vision Insurance 314.00 314.00 23.82 52.03 16.570 261.97 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 117.97 241.19 22.626 824.81 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 469.54 1,040.69 13.984 6,401.31 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 109.81 243.38 13.979 1,497.62 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 535.08 16.333 2,740.92 135-50070-021-000 Employee Relations 200.00 200.00 8.99 4.495 191.01 Subtotal: 168,673.00 168,673.00 12,358.85 22,963.00 13.614 145,710.00 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 .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 .102 27,273.03 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 102.52 102.52 7.691 1,230.48 135-60020-021-000 Electricity 21,178.00 21,178.00 1,543.61 1,909.55 9.017 19,268.45 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 1,646.13 2,012.07 5.680 33,409.93 135-65005-021-000 Fuel & Lube 22,397.00 22,397.00 987.71 2,018.55 9.013 20,378.45 135-65010-021-000 Uniforms 1,040.00 1,040.00 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 4.399 956.01 135-65040-021-000 Safety Equipment 500.00 500.00 540.75 108.150 40.75- Subtotal: 30,937.00 30,937.00 987.71 3,179.43 10.277 27,757.57 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 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/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 14,992.69 28,182.47 5.969 443,987.53 Department number: Collection 472,170.00 472,170.00 14,992.69 28,182.47 5.969 443,987.53 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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 2,000.00 20.000 8,000.00 135-50030-026-000 Social Security Taxes 620.00 620.00 62.00 124.00 20.000 496.00 135-50035-026-000 Medicare Taxes 145.00 145.00 14.50 29.00 20.000 116.00 135-50040-026-000 Unemployment Taxes 10.00 10.00 1.00 2.00 20.000 8.00 135-50045-026-000 Workman's Compensation 36.00 36.00 2.95 5.90 16.389 30.10 Subtotal: 10,811.00 10,811.00 1,080.45 2,160.90 19.988 8,650.10 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 .417 1,195.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 265.00 265.00 6.625 3,735.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 Subtotal: 11,850.00 11,850.00 265.00 270.00 2.278 11,580.00 Program number: 22,661.00 22,661.00 1,345.45 2,430.90 10.727 20,230.10 Department number: Board of Directors 22,661.00 22,661.00 1,345.45 2,430.90 10.727 20,230.10 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 34,580.11 57,796.26 12.599 400,924.74 135-50010-030-000 Overtime 500.00 500.00 28.51 239.58 47.916 260.42 135-50016-030-000 Longevity 3,018.00 3,018.00 3,077.50 3,077.50 101.972 59.50- 135-50020-030-000 Retirement 41,419.00 41,419.00 3,384.19 6,460.69 15.598 34,958.31 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,340.60 8,728.70 15.069 49,194.30 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 386.34 772.68 15.151 4,327.32 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 82.53 165.06 15.185 921.94 135-50029-030-000 Life Insurance & Other 4,483.00 4,483.00 300.02 636.79 14.205 3,846.21 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 2,180.51 4,159.94 14.515 24,499.06 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 509.95 972.90 14.517 5,729.10 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 257.26 16.334 1,317.74 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 15.00- 687.85 13.757 4,312.15 Subtotal: 614,450.00 614,450.00 48,983.89 83,955.21 13.663 530,494.79 135-55030-030-000 Software & Support 59,698.00 59,698.00 3,707.10 6,332.60 10.608 53,365.40 135-55070-030-000 Independent Labor 7,700.00 7,700.00 82.50 1,862.95 24.194 5,837.05 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 1,341.21- 1,341.21- -29.805 5,841.21 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 121.50 261.34 4.021 6,238.66 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 1,594.97 1,594.97 8.333 17,545.03 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 15,000.00 135-55161-030-000 Outside Services-Town Semo 77,048.00 77,048.00 38,524.00 50.000 38,524.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 6,808.00 6,808.00 570.00 570.00 8.373 6,238.00 Subtotal: 196,594.00 196,594.00 4,734.86 47,804.65 24.316 148,789.35 135-60005-030-000 Telephone 11,250.00 11,250.00 1,205.06 1,410.06 12.534 9,839.94 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 3,589.00 252.52 402.52 11.215 3,186.48 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 55.16- 46.10 3.073 1,453.90 135-60035-030-000 Postage 28,500.00 28,500.00 1,765.80 3,033.12 10.643 25,466.88 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 3,668.07 3,668.07 12.948 24,661.93 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,269.73 8,572.71 16.006 44,988.29 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 840.00 940.00 20.889 3,560.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 68.48 68.48 1.370 4,931.52 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 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 .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 12,014.50 18,160.76 8.893 186,060.24 135-65010-030-000 Uniforms 1,390.00 1,390.00 521.00 521.00 37.482 869.00 135-65055-030-000 Hardware 13,562.00 13,562.00 1,029.89 1,335.86 9.850 12,226.14 135-65085-030-000 Office Supplies 9,100.00 9,100.00 77.84 751.32 8.256 8,348.68 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 491.50 491.50 8.575 5,240.50 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 94.40 3.776 2,405.60 135-65097-030-000 Vending Machine Supplies 200.00 200.00 27.06 13.530 172.94 135-65105-030-000 Printing 4,000.00 4,000.00 1,401.00 35.025 2,599.00 Subtotal: 36,484.00 36,484.00 2,120.23 4,622.14 12.669 31,861.86 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 7.445 3,193.15 Subtotal: 3,450.00 3,450.00 256.85 7.445 3,193.15 Program number: 1,055,199.00 1,055,199.00 67,853.48 154,799.61 14.670 900,399.39 Department number: Administration 1,055,199.00 1,055,199.00 67,853.48 154,799.61 14.670 900,399.39 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 10:26 12/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/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 26,461.45 26,461.45 20.153 104,838.55 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 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 26,461.45 29,806.15 17.854 137,133.85 Program number: 166,940.00 166,940.00 26,461.45 29,806.15 17.854 137,133.85 Department number: Non Departmental 166,940.00 166,940.00 26,461.45 29,806.15 17.854 137,133.85 Expenditures Subtotal ----------- 6,417,937.00 6,417,937.00 382,299.44 612,229.75 9.539 5,805,707.25 Fund number: 135 MUD 1 General Fund 13,142.04- 227,651.76- 227,651.76 . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 10:26 12/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 11/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 12.10- 26.08- 26.08 Subtotal: 12.10- 26.08- 26.08 Program number: 12.10- 26.08- 26.08 Department number: 12.10- 26.08- 26.08 Revenues Subtotal ----------- 12.10- 26.08- 26.08 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 10:26 12/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: 11/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 50,394.99 53,279.99 53,279.99- Subtotal: 50,394.99 53,279.99 53,279.99- Program number: 2 Rate of Flow Control-FW Meter 50,394.99 53,279.99 53,279.99- Department number: Water 50,394.99 53,279.99 53,279.99- Expenditures Subtotal ----------- 50,394.99 53,279.99 53,279.99- Fund number: 507 MUD 1 Capital Projects 50,382.89 53,253.91 53,253.91- . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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 394 11/01/2013 Property Taxes/Assessments (1,865.89) (134.50) (2,000.39) GL 395 11/04/2013 Property Taxes/Assessments (155.52) (2,155.91) GL 396 11/05/2013 Property Taxes/Assessments (252.55) (2,408.46) GL 397 11/06/2013 Property Taxes/Assessments (29.47) (2,437.93) GL 398 11/07/2013 Property Taxes/Assessments (19.82) (2,457.75) GL 399 11/08/2013 Property Taxes/Assessments (155.15) (2,612.90) GL 400 11/12/2013 Property Taxes/Assessments (166.82) (2,779.72) GL 401 11/13/2013 Property Taxes/Assessments (92.27) (2,871.99) GL 402 11/14/2013 Property Taxes/Assessments (87.17) (2,959.16) GL 403 11/15/2013 Property Taxes/Assessments (59.40) (3,018.56) GL 404 11/18/2013 Property Taxes/Assessments (947.87) (3,966.43) GL 405 11/19/2013 Property Taxes/Assessments (95.81) (4,062.24) GL 406 11/20/2013 Property Taxes/Assessments (383.91) (4,446.15) GL 407 11/21/2013 Property Taxes/Assessments (102.50) (4,548.65) GL 408 11/22/2013 Property Taxes/Assessments (48.95) (4,597.60) GL 409 11/25/2013 Property Taxes/Assessments (350.28) (4,947.88) GL 410 11/26/2013 Property Taxes/Assessments (209.13) (5,157.01) GL 411 11/27/2013 Property Taxes/Assessments (127.38) (5,284.39) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (3,418.50) (5,284.39) ** (99,250.00) Budgeted (93,965.61) Remaining 5 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 396 11/05/2013 Property Taxes/Assessments 10.03 (.06) 9.97 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (.06) 9.97 ** .00 Budgeted (9.97) Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 394 11/01/2013 Property Taxes/Assessments 34.30 (1.42) 32.88 GL 395 11/04/2013 Property Taxes/Assessments (1.11) 31.77 GL 396 11/05/2013 Property Taxes/Assessments (.01) 31.76 GL 398 11/07/2013 Property Taxes/Assessments (.85) 30.91 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (3.39) 30.91 ** (900.00) Budgeted (930.91) Remaining -3 % Used Account: 135-47000-000-000 Water 338 11/01/2013 UB 11/1/13 Portable meter fee UB20131101-20131101 User: (241,095.25) (100.00) (241,195.25) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 346 11/30/2013 UB 11/30/13 November Billing UB20131130-20131130 User: (241,095.25) (198,527.00) (439,722.25) UB _______________ Account: 135-47000-000-000 Water Totals: (198,627.00) (439,722.25) ** (3,749,310.00) Budgeted (3,309,587.75) Remaining 12 % Used Account: 135-47005-000-000 Sewer 346 11/30/2013 UB 11/30/13 November Billing UB20131130-20131130 User: (140,301.05) (147,563.41) (287,864.46) UB _______________ Account: 135-47005-000-000 Sewer Totals: (147,563.41) (287,864.46) ** (1,708,321.00) Budgeted (1,420,456.54) Remaining 17 % Used Account: 135-47025-000-000 Penalties 311 11/21/2013 UB 11/21/13 Penalties UB20131121-20131121 User: (7,174.15) (5,791.40) (12,965.55) UB 319 11/21/2013 UB 11/21/13 Penalty Adjustment UB20131121-20131121 User: 33.13 (12,932.42) UB 339 11/26/2013 UB 11/26/13 Penalty Adjustment UB20131126-20131126 User: 267.57 (12,664.85) UB _______________ Account: 135-47025-000-000 Penalties Totals: (5,490.70) (12,664.85) ** (64,522.00) Budgeted (51,857.15) Remaining 20 % Used Account: 135-47030-000-000 Service Charges 230 11/06/2013 UB 11/6/13 Cut Off List UB20131106-20131106 User: (778.00) (825.00) (1,603.00) UB 278 11/06/2013 UB 11/06/2013 NSF Check Fee UB20131106-20131106 User: (25.00) (1,628.00) UB 346 11/30/2013 UB 11/30/13 November Billing UB20131130-20131130 User: (28.00) (1,656.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (878.00) (1,656.00) ** (9,075.00) Budgeted (7,419.00) Remaining 18 % Used Account: 135-47035-000-000 Plumbing Inspections 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (200.00) (250.00) (450.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (450.00) ** (1,200.00) Budgeted (750.00) Remaining 38 % Used Account: 135-47045-000-000 Sewer Inspections 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (900.00) (600.00) (1,500.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (1,500.00) ** (4,400.00) Budgeted (2,900.00) Remaining 34 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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-47070-000-000 TCCC Effluent Charges 346 11/30/2013 UB 11/30/13 November Billing UB20131130-20131130 User: (7,272.30) (522.90) (7,795.20) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (522.90) (7,795.20) ** (79,586.00) Budgeted (71,790.80) Remaining 10 % Used Account: 135-48005-000-000 Utility Fees 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (34,500.00) (29,900.00) (64,400.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (29,900.00) (64,400.00) ** (582,109.00) Budgeted (517,709.00) Remaining 11 % Used Account: 135-49010-000-000 Interest Income 375 11/30/2013 Bank Statement Interest/Nov (468.65) (74.77) (543.42) GL 375 11/30/2013 Bank Statement Interest/Nov (63.44) (606.86) GL 375 11/30/2013 Bank Statement Interest/Nov (381.45) (988.31) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (519.66) (988.31) ** (4,800.00) Budgeted (3,811.69) Remaining 21 % Used Account: 135-49016-000-000 Cell Tower Revenue 367 11/07/2013 AT&T Antenna Lease/Nov (910.53) (910.53) (1,821.06) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (1,821.06) ** (10,164.00) Budgeted (8,342.94) Remaining 18 % Used Account: 135-49018-000-000 Building Rent Income 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (583.33) (583.33) (1,166.66) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,166.66) ** (7,000.00) Budgeted (5,833.34) Remaining 17 % Used Account: 135-49030-000-000 Vending Revenue (41.00) .00 (41.00) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (41.00) ** (350.00) Budgeted (309.00) Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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-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 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (8,394.20) (6,174.00) (14,568.20) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (6,174.00) (14,568.20) ** (84,000.00) Budgeted (69,431.80) Remaining 17 % Used Account: 135-49900-000-000 Miscellaneous Income (.01) .00 (.01) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: .00 (.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: ------------------------------------------------------------------------------------------------ (839,881.51) ** (6,417,937.00) Budgeted (5,578,055.49) Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 217 11/08/2013 Payroll 11/8/13 Salaries & Wages 11,917.83 9,538.14 21,455.97 PR 306 11/22/2013 MUD Payroll 11/22/13 Salaries & Wages 9,577.71 31,033.68 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,115.85 31,033.68 ** 287,709.00 Budgeted 256,675.32 Remaining 11 % Used Account: 135-50010-010-000 Overtime 217 11/08/2013 Payroll 11/8/13 Overtime 773.82 696.73 1,470.55 PR 306 11/22/2013 MUD Payroll 11/22/13 Overtime 563.32 2,033.87 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,260.05 2,033.87 ** 13,391.00 Budgeted 11,357.13 Remaining 15 % Used Account: 135-50016-010-000 Longevity 307 11/22/2013 MUD Payroll-Longevity Longevity 4,905.00 4,905.00 PR _______________ Account: 135-50016-010-000 Longevity Totals: 4,905.00 4,905.00 ** 4,905.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 306 11/22/2013 MUD Payroll 11/22/13 Certification 325.00 325.00 650.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 325.00 650.00 ** 5,100.00 Budgeted 4,450.00 Remaining 13 % Used Account: 135-50020-010-000 Retirement 217 11/08/2013 Payroll 11/8/13 Retirement 1,612.86 919.09 2,531.95 PR 306 11/22/2013 MUD Payroll 11/22/13 Retirement 939.85 3,471.80 PR 307 11/22/2013 MUD Payroll-Longevity Retirement 440.46 3,912.26 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,299.40 3,912.26 ** 27,847.00 Budgeted 23,934.74 Remaining 14 % Used Account: 135-50026-010-000 Medical Insurance 217 11/08/2013 Payroll 11/8/13 Medical Insurance 2,378.20 1,321.25 3,699.45 PR 306 11/22/2013 MUD Payroll 11/22/13 Medical Insurance 1,321.20 5,020.65 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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,642.45 5,020.65 ** 48,334.00 Budgeted 43,313.35 Remaining 10 % Used Account: 135-50027-010-000 Dental Insurance 217 11/08/2013 Payroll 11/8/13 Dental Insurance 206.23 110.85 317.08 PR 306 11/22/2013 MUD Payroll 11/22/13 Dental Insurance 110.83 427.91 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 221.68 427.91 ** 3,932.00 Budgeted 3,504.09 Remaining 11 % Used Account: 135-50028-010-000 Vision Insurance 217 11/08/2013 Payroll 11/8/13 Vision Insurance 45.77 25.09 70.86 PR 306 11/22/2013 MUD Payroll 11/22/13 Vision Insurance 25.07 95.93 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 50.16 95.93 ** 873.00 Budgeted 777.07 Remaining 11 % Used Account: 135-50029-010-000 Life Insurance & Other 156 11/01/2013 Nov A/P Nov Life, AD&D, LTD, STD, Dent 155.48 139.73 295.21 METLIFE 33129 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 139.73 295.21 ** 3,306.00 Budgeted 3,010.79 Remaining 9 % Used Account: 135-50030-010-000 Social Security Taxes 217 11/08/2013 Payroll 11/8/13 Social Security Taxes 1,100.62 629.51 1,730.13 PR 306 11/22/2013 MUD Payroll 11/22/13 Social Security Taxes 641.76 2,371.89 PR 307 11/22/2013 MUD Payroll-Longevity Social Security Taxes 304.11 2,676.00 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,575.38 2,676.00 ** 19,289.00 Budgeted 16,613.00 Remaining 14 % Used Account: 135-50035-010-000 Medicare Taxes 217 11/08/2013 Payroll 11/8/13 Medicare Taxes 257.39 147.23 404.62 PR 306 11/22/2013 MUD Payroll 11/22/13 Medicare Taxes 150.09 554.71 PR 307 11/22/2013 MUD Payroll-Longevity Medicare Taxes 71.12 625.83 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 368.44 625.83 ** 4,511.00 Budgeted 3,885.17 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 48 11/01/2013 Nov Ins & W/C Expense 802.45 802.45 1,604.90 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 1,604.90 ** 9,829.00 Budgeted 8,224.10 Remaining 16 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 324 11/22/2013 Nov A/P Testing 36.45 63.00 99.45 CARENOW CORPORATE 33185 AP 350 11/30/2013 Nov A/P Pre employment physical/Dendis 73.00 172.45 CARENOW CORPORATE 33215 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 136.00 172.45 ** 200.00 Budgeted 27.55 Remaining 86 % Used Account: 135-50070-010-000 Employee Relations 8.99 .00 8.99 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 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 248 11/07/2013 Nov A/P Parts for Flush Valve 249 Oak 6,474.45 387.17 6,861.62 ATLAS UTILITY SUPPLY CO. 33140 AP 248 11/07/2013 Nov A/P Reimb Petty Cash 1.19 6,862.81 TROPHY CLUB MUD PETTY CASH 33176 AP 350 11/30/2013 Nov A/P Reflectors for Fire hydrant ma 173.30 7,036.11 DALLAS LITE & BARRICADE, INC 33219 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 561.66 7,036.11 ** 50,000.00 Budgeted 42,963.89 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-55090-010-000 Vehicle Maintenance 884.15 .00 884.15 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 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 324 11/22/2013 Nov A/P Bac T Testing 245.00 245.00 TARRANT CTY PUBLIC HEALTH LAB 33205 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 245.00 245.00 ** 5,500.00 Budgeted 5,255.00 Remaining 4 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 324 11/22/2013 Nov A/P Shi, Charter, Verizon 665.28 665.28 TOWN OF TROPHY CLUB 33208 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 665.28 665.28 ** 4,913.00 Budgeted 4,247.72 Remaining 14 % Used Account: 135-60020-010-000 Electricity 324 11/22/2013 Nov A/P Electricity 10/11/13-11/11/13 5,717.42 8,016.54 13,733.96 HUDSON ENERGY SERVICES, LLC 33191 AP 324 11/22/2013 Nov A/P Electricity 10/10/13-11/8/13 77.32 13,811.28 HUDSON ENERGY SERVICES, LLC 33191 AP 324 11/22/2013 Nov A/P Electricity 10/11/13-11/11/13 3,923.83 17,735.11 HUDSON ENERGY SERVICES, LLC 33191 AP _______________ Account: 135-60020-010-000 Electricity Totals: 12,017.69 17,735.11 ** 162,160.00 Budgeted 144,424.89 Remaining 11 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-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 6.00 .00 6.00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-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 280.60 .00 280.60 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 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 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 415 11/30/2013 Nov Gaslog 1,156.44 627.40 1,783.84 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 627.40 1,783.84 ** 23,181.00 Budgeted 21,397.16 Remaining 8 % Used Account: 135-65010-010-000 Uniforms 89.99 .00 89.99 . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-65010-010-000 Uniforms Totals: .00 89.99 ** 3,270.00 Budgeted 3,180.01 Remaining 3 % Used Account: 135-65030-010-000 Chemicals 324 11/22/2013 Nov A/P nitrite standard 983.96 43.80 1,027.76 HACH COMPANY 33190 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 43.80 1,027.76 ** 5,000.00 Budgeted 3,972.24 Remaining 21 % Used Account: 135-65035-010-000 Small Tools 464.94 .00 464.94 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 464.94 ** 1,200.00 Budgeted 735.06 Remaining 39 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 54,740.30 .00 54,740.30 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-010-000 Short Term Debt-Principal Totals: .00 .00 ** 489,980.00 Budgeted 489,980.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 19,268.00 Budgeted 19,268.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 248 11/07/2013 Nov A/P 2mg water plant #2 West Annual 42,759.66 42,759.66 UTILITY SERVICE CO, INC. 33177 AP 248 11/07/2013 Nov A/P 400,000 Elevated Tank Annual 27,028.36 69,788.02 UTILITY SERVICE CO, INC. 33177 AP _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: 69,788.02 69,788.02 ** 106,847.00 Budgeted 37,058.98 Remaining 65 % Used Account: 135-55135-010-001 Lab Analysis 324 11/22/2013 Nov A/P Bac T Testing for PID 60.00 60.00 TARRANT CTY PUBLIC HEALTH LAB 33205 AP _______________ Account: 135-55135-010-001 Lab Analysis Totals: 60.00 60.00 ** 1,000.00 Budgeted 940.00 Remaining 6 % Used Account: 135-60135-010-001 TCEQ Fees & Permits 324 11/22/2013 Nov A/P FY14 Water System Fee/PID FY2 2,150.00 2,150.00 TX COMMISSION ENVIRONMENTAL QU 33210 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 324 11/22/2013 Nov A/P Testing/PID 103.85 2,253.85 LOWER COLORADO RIVER AUTHORITY 33196 AP 349 11/22/2013 Void A/P Check 33210/TCEQ FY14 Water System Fee/PID FY2 (2,150.00) 103.85 TX COMMISSION ENVIRONMENTAL QU 33210 AP 352 11/30/2013 Nov A/P FY14 Water System Fee/PID 2,150.00 2,253.85 TX COMMISSION ENVIRONMENTAL QU 33223 AP 355 11/30/2013 Nov A/P FY14 Water System Fee/PID 2,150.00 4,403.85 TX COMMISSION ENVIRONMENTAL QU 33225 AP _______________ Account: 135-60135-010-001 TCEQ Fees & Permits Totals: 4,403.85 4,403.85 ** .00 Budgeted (4,403.85) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 212,673.63 ** 3,932,956.00 Budgeted 3,720,282.37 Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 217 11/08/2013 Payroll 11/8/13 Salaries & Wages 10,212.71 7,587.46 17,800.17 PR 306 11/22/2013 MUD Payroll 11/22/13 Salaries & Wages 7,587.46 25,387.63 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,174.92 25,387.63 ** 202,894.00 Budgeted 177,506.37 Remaining 13 % Used Account: 135-50010-020-000 Overtime 217 11/08/2013 Payroll 11/8/13 Overtime 783.14 694.82 1,477.96 PR 306 11/22/2013 MUD Payroll 11/22/13 Overtime 627.16 2,105.12 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,321.98 2,105.12 ** 11,965.00 Budgeted 9,859.88 Remaining 18 % Used Account: 135-50016-020-000 Longevity 307 11/22/2013 MUD Payroll-Longevity Longevity 2,997.50 2,997.50 PR _______________ Account: 135-50016-020-000 Longevity Totals: 2,997.50 2,997.50 ** 2,998.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 306 11/22/2013 MUD Payroll 11/22/13 Certification 400.00 400.00 800.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 800.00 ** 4,800.00 Budgeted 4,000.00 Remaining 17 % Used Account: 135-50020-020-000 Retirement 217 11/08/2013 Payroll 11/8/13 Retirement 1,491.70 743.75 2,235.45 PR 306 11/22/2013 MUD Payroll 11/22/13 Retirement 773.59 3,009.04 PR 307 11/22/2013 MUD Payroll-Longevity Retirement 269.19 3,278.23 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,786.53 3,278.23 ** 19,905.00 Budgeted 16,626.77 Remaining 16 % Used Account: 135-50026-020-000 Medical Insurance 217 11/08/2013 Payroll 11/8/13 Medical Insurance 3,293.23 1,646.62 4,939.85 PR 306 11/22/2013 MUD Payroll 11/22/13 Medical Insurance 1,646.61 6,586.46 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 6,586.46 ** 43,471.00 Budgeted 36,884.54 Remaining 15 % Used Account: 135-50027-020-000 Dental Insurance 217 11/08/2013 Payroll 11/8/13 Dental Insurance 226.46 113.24 339.70 PR 306 11/22/2013 MUD Payroll 11/22/13 Dental Insurance 113.22 452.92 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 452.92 ** 2,989.00 Budgeted 2,536.08 Remaining 15 % Used Account: 135-50028-020-000 Vision Insurance 217 11/08/2013 Payroll 11/8/13 Vision Insurance 49.93 24.98 74.91 PR 306 11/22/2013 MUD Payroll 11/22/13 Vision Insurance 24.95 99.86 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 49.93 99.86 ** 658.00 Budgeted 558.14 Remaining 15 % Used Account: 135-50029-020-000 Life Insurance & Other 156 11/01/2013 Nov A/P Nov Life, AD&D, LTD, STD, Dent 168.15 152.40 320.55 METLIFE 33129 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 152.40 320.55 ** 2,303.00 Budgeted 1,982.45 Remaining 14 % Used Account: 135-50030-020-000 Social Security Taxes 217 11/08/2013 Payroll 11/8/13 Social Security Taxes 894.34 447.67 1,342.01 PR 306 11/22/2013 MUD Payroll 11/22/13 Social Security Taxes 464.48 1,806.49 PR 307 11/22/2013 MUD Payroll-Longevity Social Security Taxes 185.86 1,992.35 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,098.01 1,992.35 ** 13,805.00 Budgeted 11,812.65 Remaining 14 % Used Account: 135-50035-020-000 Medicare Taxes 217 11/08/2013 Payroll 11/8/13 Medicare Taxes 209.15 104.71 313.86 PR 306 11/22/2013 MUD Payroll 11/22/13 Medicare Taxes 108.62 422.48 PR 307 11/22/2013 MUD Payroll-Longevity Medicare Taxes 43.47 465.95 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 256.80 465.95 ** 3,229.00 Budgeted 2,763.05 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 48 11/01/2013 Nov Ins & W/C Expense 535.08 535.08 1,070.16 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 1,070.16 ** 6,552.00 Budgeted 5,481.84 Remaining 16 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 324 11/22/2013 Nov A/P Testing 63.00 63.00 CARENOW CORPORATE 33185 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 63.00 63.00 ** 150.00 Budgeted 87.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 8.99 .00 8.99 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 8.99 ** 350.00 Budgeted 341.01 Remaining 3 % Used Account: 135-55070-020-000 Independent Labor 324 11/22/2013 Nov A/P WWTP Improvements 93,756.25 93,756.25 THE WALLACE GROUP, INC. 33207 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 93,756.25 93,756.25 ** .00 Budgeted (93,756.25) Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 369 11/15/2013 Zubras Elec Refund Tax/Pcard 363.02 (112.36) 250.66 GL _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: (112.36) 250.66 ** 35,000.00 Budgeted 34,749.34 Remaining 1 % Used Account: 135-55090-020-000 Vehicle Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 141.98 .00 141.98 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 141.98 ** 2,000.00 Budgeted 1,858.02 Remaining 7 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services .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 2,938.00 .00 2,938.00 _______________ Account: 135-55135-020-000 Lab Analysis Totals: .00 2,938.00 ** 30,000.00 Budgeted 27,062.00 Remaining 10 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 324 11/22/2013 Nov A/P Shi, Charter, Verizon 169.77 169.77 TOWN OF TROPHY CLUB 33208 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 169.77 169.77 ** 3,329.00 Budgeted 3,159.23 Remaining 5 % Used Account: 135-60020-020-000 Electricity 324 11/22/2013 Nov A/P Electricity 10/11/13-11/11/13 3,256.32 9,536.67 12,792.99 HUDSON ENERGY SERVICES, LLC 33191 AP _______________ Account: 135-60020-020-000 Electricity Totals: 9,536.67 12,792.99 ** 148,227.00 Budgeted 135,434.01 Remaining 9 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 40.00 .00 40.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-60066-020-000 Publications/Books/Subscripts Totals: .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 38.55 .00 38.55 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 38.55 ** 250.00 Budgeted 211.45 Remaining 15 % Used Account: 135-60100-020-000 Travel & per diem 306 11/22/2013 MUD Payroll 11/22/13 Travel & per diem 85.43 85.43 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 85.43 85.43 ** 1,050.00 Budgeted 964.57 Remaining 8 % Used Account: 135-60105-020-000 Rent/Lease Equipment 299.53 .00 299.53 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 324 11/22/2013 Nov A/P FY14 Permit CWQ Assessment Fee 8,919.00 8,919.00 TX COMMISSION ENVIRONMENTAL QU 33210 AP 349 11/22/2013 Void A/P Check 33210/TCEQ FY14 Permit CWQ Assessment Fee (8,919.00) .00 TX COMMISSION ENVIRONMENTAL QU 33210 AP 352 11/30/2013 Nov A/P FY14 Permit CWQ Assessment Fee 8,919.00 8,919.00 TX COMMISSION ENVIRONMENTAL QU 33223 AP 355 11/30/2013 Nov A/P FY14 Permit CWQ Assessment Fee 8,919.00 17,838.00 TX COMMISSION ENVIRONMENTAL QU 33224 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 17,838.00 17,838.00 ** 17,150.00 Budgeted (688.00) Remaining 104 % Used Account: 135-60245-020-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-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 415 11/30/2013 Nov Gaslog 972.51 762.48 1,734.99 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 762.48 1,734.99 ** 14,720.00 Budgeted 12,985.01 Remaining 12 % Used Account: 135-65010-020-000 Uniforms 1,284.28 .00 1,284.28 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,284.28 ** 1,752.00 Budgeted 467.72 Remaining 73 % Used Account: 135-65030-020-000 Chemicals 2,949.64 .00 2,949.64 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 2,949.64 ** 39,000.00 Budgeted 36,050.36 Remaining 8 % Used Account: 135-65035-020-000 Small Tools 47.34 .00 47.34 . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-020-000 Small Tools Totals: .00 47.34 ** 1,000.00 Budgeted 952.66 Remaining 5 % Used Account: 135-65040-020-000 Safety Equipment 56.43 .00 56.43 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 56.43 ** 250.00 Budgeted 193.57 Remaining 23 % Used Account: 135-65045-020-000 Lab Supplies 4,284.43 .00 4,284.43 _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 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 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-69280-020-000 Capital Repairs Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 184,336.99 ** 768,011.00 Budgeted 583,674.01 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/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 217 11/08/2013 Payroll 11/8/13 Salaries & Wages 5,458.64 3,354.58 8,813.22 PR 306 11/22/2013 MUD Payroll 11/22/13 Salaries & Wages 2,505.27 11,318.49 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 5,859.85 11,318.49 ** 90,299.00 Budgeted 78,980.51 Remaining 13 % Used Account: 135-50010-021-000 Overtime 217 11/08/2013 Payroll 11/8/13 Overtime 736.32 6.17 742.49 PR 306 11/22/2013 MUD Payroll 11/22/13 Overtime 546.07 1,288.56 PR _______________ Account: 135-50010-021-000 Overtime Totals: 552.24 1,288.56 ** 10,028.00 Budgeted 8,739.44 Remaining 13 % Used Account: 135-50016-021-000 Longevity 307 11/22/2013 MUD Payroll-Longevity Longevity 2,107.50 2,107.50 PR _______________ Account: 135-50016-021-000 Longevity Totals: 2,107.50 2,107.50 ** 17,913.00 Budgeted 15,805.50 Remaining 12 % Used Account: 135-50017-021-000 Certification 306 11/22/2013 MUD Payroll 11/22/13 Certification 150.00 150.00 300.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 300.00 ** 1,800.00 Budgeted 1,500.00 Remaining 17 % Used Account: 135-50020-021-000 Retirement 217 11/08/2013 Payroll 11/8/13 Retirement 924.77 301.80 1,226.57 PR 306 11/22/2013 MUD Payroll 11/22/13 Retirement 287.48 1,514.05 PR 307 11/22/2013 MUD Payroll-Longevity Retirement 189.26 1,703.31 PR _______________ Account: 135-50020-021-000 Retirement Totals: 778.54 1,703.31 ** 9,025.00 Budgeted 7,321.69 Remaining 19 % Used Account: 135-50026-021-000 Medical Insurance 217 11/08/2013 Payroll 11/8/13 Medical Insurance 2,057.31 896.53 2,953.84 PR 306 11/22/2013 MUD Payroll 11/22/13 Medical Insurance 896.53 3,850.37 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/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: 1,793.06 3,850.37 ** 23,668.00 Budgeted 19,817.63 Remaining 16 % Used Account: 135-50027-021-000 Dental Insurance 217 11/08/2013 Payroll 11/8/13 Dental Insurance 144.43 64.50 208.93 PR 306 11/22/2013 MUD Payroll 11/22/13 Dental Insurance 64.48 273.41 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 128.98 273.41 ** 1,703.00 Budgeted 1,429.59 Remaining 16 % Used Account: 135-50028-021-000 Vision Insurance 217 11/08/2013 Payroll 11/8/13 Vision Insurance 28.21 11.92 40.13 PR 306 11/22/2013 MUD Payroll 11/22/13 Vision Insurance 11.90 52.03 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.82 52.03 ** 314.00 Budgeted 261.97 Remaining 17 % Used Account: 135-50029-021-000 Life Insurance & Other 156 11/01/2013 Nov A/P Nov Life, AD&D, LTD, STD, Dent 123.22 117.97 241.19 METLIFE 33129 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 117.97 241.19 ** 1,066.00 Budgeted 824.81 Remaining 23 % Used Account: 135-50030-021-000 Social Security Taxes 217 11/08/2013 Payroll 11/8/13 Social Security Taxes 571.15 175.11 746.26 PR 306 11/22/2013 MUD Payroll 11/22/13 Social Security Taxes 163.76 910.02 PR 307 11/22/2013 MUD Payroll-Longevity Social Security Taxes 130.67 1,040.69 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 469.54 1,040.69 ** 7,442.00 Budgeted 6,401.31 Remaining 14 % Used Account: 135-50035-021-000 Medicare Taxes 217 11/08/2013 Payroll 11/8/13 Medicare Taxes 133.57 40.96 174.53 PR 306 11/22/2013 MUD Payroll 11/22/13 Medicare Taxes 38.29 212.82 PR 307 11/22/2013 MUD Payroll-Longevity Medicare Taxes 30.56 243.38 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 109.81 243.38 ** 1,741.00 Budgeted 1,497.62 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/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 48 11/01/2013 Nov Ins & W/C Expense 267.54 267.54 535.08 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 535.08 ** 3,276.00 Budgeted 2,740.92 Remaining 16 % Used Account: 135-50070-021-000 Employee Relations 8.99 .00 8.99 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 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 27.97 .00 27.97 _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: .00 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 Account: 135-60010-021-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 324 11/22/2013 Nov A/P Shi, Charter, Verizon 102.52 102.52 TOWN OF TROPHY CLUB 33208 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 102.52 102.52 ** 1,333.00 Budgeted 1,230.48 Remaining 8 % Used Account: 135-60020-021-000 Electricity 324 11/22/2013 Nov A/P Electricity 10/1-10/31/13 365.94 298.70 664.64 TRI COUNTY ELECTRIC 33209 AP 324 11/22/2013 Nov A/P Electricity 10/-10/31/13 163.50 828.14 TRI COUNTY ELECTRIC 33209 AP 324 11/22/2013 Nov A/P Electricity 10/1-10/31/13 27.80 855.94 TRI COUNTY ELECTRIC 33209 AP 324 11/22/2013 Nov A/P Electricity 10/11/13-11/11/13 670.05 1,525.99 HUDSON ENERGY SERVICES, LLC 33191 AP 324 11/22/2013 Nov A/P Electricity 10/11/13-11/11/13 356.95 1,882.94 HUDSON ENERGY SERVICES, LLC 33191 AP 324 11/22/2013 Nov A/P Electricity 10/10/13-11/8/13 55.98 1,938.92 HUDSON ENERGY SERVICES, LLC 33191 AP 324 11/22/2013 Nov A/P Electricity 10/10/13-11/8/13 20.41 1,959.33 HUDSON ENERGY SERVICES, LLC 33191 AP 324 11/22/2013 Nov A/P Electricity 10/31/13-11/11/13 87.06 2,046.39 HUDSON ENERGY SERVICES, LLC 33191 AP 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (136.84) 1,909.55 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,543.61 1,909.55 ** 21,178.00 Budgeted 19,268.45 Remaining 9 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/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-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 415 11/30/2013 Nov Gaslog 1,030.84 987.71 2,018.55 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 987.71 2,018.55 ** 22,397.00 Budgeted 20,378.45 Remaining 9 % Used Account: 135-65010-021-000 Uniforms 576.14 .00 576.14 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 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 43.99 .00 43.99 . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-021-000 Small Tools Totals: .00 43.99 ** 1,000.00 Budgeted 956.01 Remaining 4 % Used Account: 135-65040-021-000 Safety Equipment 540.75 .00 540.75 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 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: ------------------------------------------------------------------------------------------------ 28,182.47 ** 472,170.00 Budgeted 443,987.53 Remaining 6 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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 306 11/22/2013 MUD Payroll 11/22/13 Salaries & Wages 1,000.00 1,000.00 2,000.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,000.00 2,000.00 ** 10,000.00 Budgeted 8,000.00 Remaining 20 % Used Account: 135-50030-026-000 Social Security Taxes 306 11/22/2013 MUD Payroll 11/22/13 Social Security Taxes 62.00 62.00 124.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 62.00 124.00 ** 620.00 Budgeted 496.00 Remaining 20 % Used Account: 135-50035-026-000 Medicare Taxes 306 11/22/2013 MUD Payroll 11/22/13 Medicare Taxes 14.50 14.50 29.00 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 14.50 29.00 ** 145.00 Budgeted 116.00 Remaining 20 % Used Account: 135-50040-026-000 Unemployment Taxes 306 11/22/2013 MUD Payroll 11/22/13 Unemployment Taxes 1.00 1.00 2.00 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.00 2.00 ** 10.00 Budgeted 8.00 Remaining 20 % Used Account: 135-50045-026-000 Workman's Compensation 48 11/01/2013 Nov Ins & W/C Expense 2.95 2.95 5.90 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.95 5.90 ** 36.00 Budgeted 30.10 Remaining 16 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 5.00 .00 5.00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 5.00 ** 1,200.00 Budgeted 1,195.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 248 11/07/2013 Nov A/P Mid Winter Conf-Carr 265.00 265.00 AWBD 33141 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 265.00 265.00 ** 4,000.00 Budgeted 3,735.00 Remaining 7 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 2,430.90 ** 22,661.00 Budgeted 20,230.10 Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 217 11/08/2013 Payroll 11/8/13 Salaries & Wages 23,216.15 17,281.42 40,497.57 PR 306 11/22/2013 MUD Payroll 11/22/13 Salaries & Wages 17,298.69 57,796.26 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 34,580.11 57,796.26 ** 458,721.00 Budgeted 400,924.74 Remaining 13 % Used Account: 135-50010-030-000 Overtime 217 11/08/2013 Payroll 11/8/13 Overtime 211.07 18.16 229.23 PR 306 11/22/2013 MUD Payroll 11/22/13 Overtime 10.35 239.58 PR _______________ Account: 135-50010-030-000 Overtime Totals: 28.51 239.58 ** 500.00 Budgeted 260.42 Remaining 48 % Used Account: 135-50016-030-000 Longevity 307 11/22/2013 MUD Payroll-Longevity Longevity 3,077.50 3,077.50 PR _______________ Account: 135-50016-030-000 Longevity Totals: 3,077.50 3,077.50 ** 3,018.00 Budgeted (59.50) Remaining 102 % Used Account: 135-50020-030-000 Retirement 217 11/08/2013 Payroll 11/8/13 Retirement 3,076.50 1,553.48 4,629.98 PR 306 11/22/2013 MUD Payroll 11/22/13 Retirement 1,554.37 6,184.35 PR 307 11/22/2013 MUD Payroll-Longevity Retirement 276.34 6,460.69 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,384.19 6,460.69 ** 41,419.00 Budgeted 34,958.31 Remaining 16 % Used Account: 135-50026-030-000 Medical Insurance 217 11/08/2013 Payroll 11/8/13 Medical Insurance 4,388.10 2,170.32 6,558.42 PR 306 11/22/2013 MUD Payroll 11/22/13 Medical Insurance 2,170.28 8,728.70 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,340.60 8,728.70 ** 57,923.00 Budgeted 49,194.30 Remaining 15 % Used Account: 135-50027-030-000 Dental Insurance 217 11/08/2013 Payroll 11/8/13 Dental Insurance 386.34 193.19 579.53 PR 306 11/22/2013 MUD Payroll 11/22/13 Dental Insurance 193.15 772.68 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 386.34 772.68 ** 5,100.00 Budgeted 4,327.32 Remaining 15 % Used Account: 135-50028-030-000 Vision Insurance 217 11/08/2013 Payroll 11/8/13 Vision Insurance 82.53 41.29 123.82 PR 306 11/22/2013 MUD Payroll 11/22/13 Vision Insurance 41.24 165.06 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 165.06 ** 1,087.00 Budgeted 921.94 Remaining 15 % Used Account: 135-50029-030-000 Life Insurance & Other 156 11/01/2013 Nov A/P Nov Life, AD&D, LTD, STD, Dent 336.77 300.02 636.79 METLIFE 33129 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 300.02 636.79 ** 4,483.00 Budgeted 3,846.21 Remaining 14 % Used Account: 135-50030-030-000 Social Security Taxes 217 11/08/2013 Payroll 11/8/13 Social Security Taxes 1,979.43 996.90 2,976.33 PR 306 11/22/2013 MUD Payroll 11/22/13 Social Security Taxes 992.81 3,969.14 PR 307 11/22/2013 MUD Payroll-Longevity Social Security Taxes 190.80 4,159.94 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,180.51 4,159.94 ** 28,659.00 Budgeted 24,499.06 Remaining 15 % Used Account: 135-50035-030-000 Medicare Taxes 217 11/08/2013 Payroll 11/8/13 Medicare Taxes 462.95 233.14 696.09 PR 306 11/22/2013 MUD Payroll 11/22/13 Medicare Taxes 232.19 928.28 PR 307 11/22/2013 MUD Payroll-Longevity Medicare Taxes 44.62 972.90 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 509.95 972.90 ** 6,702.00 Budgeted 5,729.10 Remaining 15 % 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 44 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 48 11/01/2013 Nov Ins & W/C Expense 128.63 128.63 257.26 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.63 257.26 ** 1,575.00 Budgeted 1,317.74 Remaining 16 % 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 370 11/20/2013 Flu Shot/Adams 702.85 (15.00) 687.85 GL _______________ Account: 135-50070-030-000 Employee Relations Totals: (15.00) 687.85 ** 5,000.00 Budgeted 4,312.15 Remaining 14 % Used Account: 135-55030-030-000 Software & Support 324 11/22/2013 Nov A/P BOA PCards IT 2,625.50 224.35 2,849.85 TOWN OF TROPHY CLUB 33208 AP 324 11/22/2013 Nov A/P Shi, Charter, Verizon 645.50 3,495.35 TOWN OF TROPHY CLUB 33208 AP 324 11/22/2013 Nov A/P P2V Conversion Help (Adridge C 82.50 3,577.85 TOWN OF TROPHY CLUB 33208 AP 324 11/22/2013 Nov A/P 2,304.75 5,882.60 SYN-TECH SYSTEMS, INC 33204 AP 324 11/22/2013 Nov A/P Annual Maintenance 450.00 6,332.60 BADGER METER, INC 33183 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 3,707.10 6,332.60 ** 59,698.00 Budgeted 53,365.40 Remaining 11 % Used Account: 135-55070-030-000 Independent Labor 324 11/22/2013 Nov A/P Record MUD meeting 1,780.45 82.50 1,862.95 MIGUEL CRUZ 33198 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 82.50 1,862.95 ** 7,700.00 Budgeted 5,837.05 Remaining 24 % Used Account: 135-55080-030-000 Maintenance & Repairs 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (1,341.21) (1,341.21) AR _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: (1,341.21) (1,341.21) ** 4,500.00 Budgeted 5,841.21 Remaining -30 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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-55100-030-000 Building Maint & Supplies 324 11/22/2013 Nov A/P Fire Extinquisher maint Water 139.84 121.50 261.34 KIMBROUGH FIRE EXTINQUISHER CO 33194 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 121.50 261.34 ** 6,500.00 Budgeted 6,238.66 Remaining 4 % Used Account: 135-55120-030-000 Cleaning Services 324 11/22/2013 Nov A/P Janitorial service/Oct 1,594.97 1,594.97 MEMBER'S BUILDING MAINTENANCE 33197 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 1,594.97 ** 19,140.00 Budgeted 17,545.03 Remaining 8 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55161-030-000 Outside Services-Town Semo 38,524.00 .00 38,524.00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 38,524.00 ** 77,048.00 Budgeted 38,524.00 Remaining 50 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 324 11/22/2013 Nov A/P October water billing 570.00 570.00 DATAPROSE LLC 33186 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 570.00 570.00 ** 6,808.00 Budgeted 6,238.00 Remaining 8 % Used Account: 135-60005-030-000 Telephone . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 248 11/07/2013 Nov A/P Nov Answering Service 205.00 180.00 385.00 KEYSTONE PARK SECRETARIAL 33162 AP 324 11/22/2013 Nov A/P BOA PCards IT 1,025.06 1,410.06 TOWN OF TROPHY CLUB 33208 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,205.06 1,410.06 ** 11,250.00 Budgeted 9,839.94 Remaining 13 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 306 11/22/2013 MUD Payroll 11/22/13 Communications/Pagers/Mobiles 150.00 150.00 300.00 PR 324 11/22/2013 Nov A/P Shi, Charter, Verizon 102.52 402.52 TOWN OF TROPHY CLUB 33208 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 252.52 402.52 ** 3,589.00 Budgeted 3,186.48 Remaining 11 % 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 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: 101.26 (55.16) 46.10 AR _______________ Account: 135-60025-030-000 Water Totals: (55.16) 46.10 ** 1,500.00 Budgeted 1,453.90 Remaining 3 % Used Account: 135-60035-030-000 Postage 324 11/22/2013 Nov A/P Overnight letters 1,267.32 15.43 1,282.75 FEDERAL EXPRESS CORP 33187 AP 324 11/22/2013 Nov A/P Overnight letter 6.17 1,288.92 FEDERAL EXPRESS CORP 33187 AP 324 11/22/2013 Nov A/P October water billing 1,582.24 2,871.16 DATAPROSE LLC 33186 AP 384 11/30/2013 Nov Postage Meter 161.96 3,033.12 GL _______________ Account: 135-60035-030-000 Postage Totals: 1,765.80 3,033.12 ** 28,500.00 Budgeted 25,466.88 Remaining 11 % Used Account: 135-60040-030-000 Service Charges & Fees 377 11/04/2013 Oct Online/Credit card fees 89.85 89.85 GL 377 11/04/2013 Oct Online/Credit card fees 116.05 205.90 GL 377 11/04/2013 Oct Online/Credit card fees 3,172.17 3,378.07 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 248 11/07/2013 Nov A/P Reimb Petty Cash 40.00 3,418.07 TROPHY CLUB MUD PETTY CASH 33176 AP 376 11/30/2013 FF Nov Analysis charge 250.00 3,668.07 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,668.07 3,668.07 ** 28,330.00 Budgeted 24,661.93 Remaining 13 % 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 48 11/01/2013 Nov Ins & W/C Expense 4,302.98 4,269.73 8,572.71 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,269.73 8,572.71 ** 53,561.00 Budgeted 44,988.29 Remaining 16 % 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 324 11/22/2013 Nov A/P Membership 100.00 275.00 375.00 NORTHWEST METROPORT CHAMBER 33200 AP 324 11/22/2013 Nov A/P Annual Dues 565.00 940.00 AWBD 33182 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 840.00 940.00 ** 4,500.00 Budgeted 3,560.00 Remaining 21 % 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 48 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 193 11/04/2013 Nov A/P Election Law Seminar/McKnight 220.00 220.00 OFC OF THE SECRETARY OF STATE 33138 AP 195 11/04/2013 Void A/P ck33138/pd by pcard Election Law Seminar/McKnight (220.00) .00 OFC OF THE SECRETARY OF STATE 33138 AP _______________ 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 217 11/08/2013 Payroll 11/8/13 Travel & per diem 44.86 44.86 PR 306 11/22/2013 MUD Payroll 11/22/13 Travel & per diem 23.62 68.48 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 68.48 68.48 ** 5,000.00 Budgeted 4,931.52 Remaining 1 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 19.70 .00 19.70 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 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 324 11/22/2013 Nov A/P Shirts & Embroidery 400.50 400.50 PANDA EMBROIDERY 33202 AP 324 11/22/2013 Nov A/P Shirts & Embroidery 60.00 460.50 PANDA EMBROIDERY 33202 AP 324 11/22/2013 Nov A/P Shirts & Embroidery 60.50 521.00 PANDA EMBROIDERY 33202 AP _______________ Account: 135-65010-030-000 Uniforms Totals: 521.00 521.00 ** 1,390.00 Budgeted 869.00 Remaining 37 % Used Account: 135-65055-030-000 Hardware 324 11/22/2013 Nov A/P BOA PCards IT 305.97 1,029.89 1,335.86 TOWN OF TROPHY CLUB 33208 AP _______________ Account: 135-65055-030-000 Hardware Totals: 1,029.89 1,335.86 ** 13,562.00 Budgeted 12,226.14 Remaining 10 % Used Account: 135-65085-030-000 Office Supplies 324 11/22/2013 Nov A/P Office Supplies 673.48 105.33 778.81 OFFICE DEPOT, INC 33201 AP 393 11/30/2013 Town Billing Inv 1103-1113 AR 20131130-20131130 User: (27.49) 751.32 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 77.84 751.32 ** 9,100.00 Budgeted 8,348.68 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 324 11/22/2013 Nov A/P Shi, Charter, Verizon 491.50 491.50 TOWN OF TROPHY CLUB 33208 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 491.50 491.50 ** 5,732.00 Budgeted 5,240.50 Remaining 9 % Used Account: 135-65095-030-000 Maintenance Supplies 94.40 .00 94.40 _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: .00 94.40 ** 2,500.00 Budgeted 2,405.60 Remaining 4 % Used Account: 135-65097-030-000 Vending Machine Supplies 27.06 .00 27.06 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 27.06 ** 200.00 Budgeted 172.94 Remaining 14 % Used Account: 135-65105-030-000 Printing 1,401.00 .00 1,401.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 1,401.00 ** 4,000.00 Budgeted 2,599.00 Remaining 35 % Used Account: 135-69170-030-000 Copier Lease Installments 256.85 .00 256.85 _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: .00 256.85 ** 3,450.00 Budgeted 3,193.15 Remaining 7 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 154,799.61 ** 1,055,199.00 Budgeted 900,399.39 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/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 324 11/22/2013 Nov A/P Legal/General 5,570.25 5,570.25 WHITAKER CHALK SWINDLE 33211 AP 324 11/22/2013 Nov A/P Legal/Prime Construction Inter 518.50 6,088.75 WHITAKER CHALK SWINDLE 33211 AP 324 11/22/2013 Nov A/P Legal CCN 84.00 6,172.75 WHITAKER CHALK SWINDLE 33211 AP 324 11/22/2013 Nov A/P Legal-Svc to Solana 7,456.35 13,629.10 WHITAKER CHALK SWINDLE 33211 AP 324 11/22/2013 Nov A/P Legal-New contract water suppl 470.40 14,099.50 WHITAKER CHALK SWINDLE 33211 AP 324 11/22/2013 Nov A/P Legal/CCN 1,218.53 15,318.03 BOOTH, AHRENS & WERKENTHIN PC 33184 AP 324 11/22/2013 Nov A/P Legal 5,335.00 20,653.03 FREEMAN & CORBETT 33188 AP 350 11/30/2013 Nov A/P October legal 5,808.42 26,461.45 THE LISTON LAW FIRM, P.C. 33222 AP _______________ Account: 135-55045-039-000 Legal Totals: 26,461.45 26,461.45 ** 131,300.00 Budgeted 104,838.55 Remaining 20 % 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 3,344.70 .00 3,344.70 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 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: ------------------------------------------------------------------------------------------------ 29,806.15 ** 166,940.00 Budgeted 137,133.85 Remaining 18 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (227,651.76) .00 Budgeted 227,651.76 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 11/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 375 11/30/2013 Bank Statement Interest/Nov (13.98) (12.10) (26.08) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (12.10) (26.08) ** .00 Budgeted 26.08 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (26.08) ** .00 Budgeted 26.08 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 10:47 12/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: 11/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 288 11/15/2013 Nov A/P ROFC Application #5 2,885.00 50,394.99 53,279.99 REY-MAR CONSTRUCTION 33180 AP _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: 50,394.99 53,279.99 ** .00 Budgeted (53,279.99) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 53,279.99 ** .00 Budgeted (53,279.99) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 53,253.91 .00 Budgeted (53,253.91) Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET NOVEMBER 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 33,747 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 378,375 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 416,968 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 378,375 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 378,375 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 20,714 TOTAL FUND BALANCE 38,593 TOTAL LIABILITIES AND FUND BALANCE 416,968 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 10:26 12/13/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/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- 13,403.45- 20,719.41- 5.323 368,496.59- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- .11- 19.67 -.787 2,519.67- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- .02- 12.83- .802 1,587.17- Subtotal: 393,316.00- 393,316.00- 13,403.58- 20,712.57- 5.266 372,603.43- 533-48005-000-000 Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- Subtotal: 16,525.00- 16,525.00- 16,525.00- 533-49010-000-000 Interest Income 375.00- 375.00- .91- 1.49- .397 373.51- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- Subtotal: 214,654.00- 214,654.00- .91- 1.49- .001 214,652.51- Program number: 624,495.00- 624,495.00- 13,404.49- 20,714.06- 3.317 603,780.94- Department number: Revenues 624,495.00- 624,495.00- 13,404.49- 20,714.06- 3.317 603,780.94- Revenues Subtotal ----------- 624,495.00- 624,495.00- 13,404.49- 20,714.06- 3.317 603,780.94- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 10:26 12/13/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 2,300.00 533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 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 13,404.49- 20,714.06- 20,714.06 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/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 394 11/01/2013 Property Taxes/Assessments (7,315.96) (527.37) (7,843.33) GL 395 11/04/2013 Property Taxes/Assessments (609.76) (8,453.09) GL 396 11/05/2013 Property Taxes/Assessments (990.24) (9,443.33) GL 397 11/06/2013 Property Taxes/Assessments (115.54) (9,558.87) GL 398 11/07/2013 Property Taxes/Assessments (77.71) (9,636.58) GL 399 11/08/2013 Property Taxes/Assessments (608.32) (10,244.90) GL 400 11/12/2013 Property Taxes/Assessments (654.06) (10,898.96) GL 401 11/13/2013 Property Taxes/Assessments (361.79) (11,260.75) GL 402 11/14/2013 Property Taxes/Assessments (341.78) (11,602.53) GL 403 11/15/2013 Property Taxes/Assessments (232.89) (11,835.42) GL 404 11/18/2013 Property Taxes/Assessments (3,716.47) (15,551.89) GL 405 11/19/2013 Property Taxes/Assessments (375.67) (15,927.56) GL 406 11/20/2013 Property Taxes/Assessments (1,505.23) (17,432.79) GL 407 11/21/2013 Property Taxes/Assessments (401.88) (17,834.67) GL 408 11/22/2013 Property Taxes/Assessments (191.92) (18,026.59) GL 409 11/25/2013 Property Taxes/Assessments (1,373.38) (19,399.97) GL 410 11/26/2013 Property Taxes/Assessments (819.98) (20,219.95) GL 411 11/27/2013 Property Taxes/Assessments (499.46) (20,719.41) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (13,403.45) (20,719.41) ** (389,216.00) Budgeted (368,496.59) Remaining 5 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 396 11/05/2013 Property Taxes/Assessments 19.78 (.11) 19.67 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (.11) 19.67 ** (2,500.00) Budgeted (2,519.67) Remaining -1 % Used Account: 533-40015-000-000 Property Taxes/P & I 396 11/05/2013 Property Taxes/Assessments (12.81) (.02) (12.83) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (.02) (12.83) ** (1,600.00) Budgeted (1,587.17) Remaining 1 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (16,525.00) Budgeted (16,525.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/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-49010-000-000 Interest Income 375 11/30/2013 Bank Statement Interest/Nov (.58) (.91) (1.49) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (.91) (1.49) ** (375.00) Budgeted (373.51) 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: ------------------------------------------------------------------------------------------------ (20,714.06) ** (624,495.00) Budgeted (603,780.94) Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 10:47 12/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/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/Bond Issuance .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 .00 ** 2,300.00 Budgeted 2,300.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense .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: ------------------------------------------------------------------------------------------------------ (20,714.06) .00 Budgeted 20,714.06 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (136,830.45) **** .00 Budgeted 136,830.45 Remaining 0 % Used ******* End of Report *********