Loading...
HomeMy WebLinkAboutNov Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2014 122 ASSETS FIRE DEPT. INVESTMENTS 328,755 PREPAID EXPENSES 15,991 ADVALOREM PROPERTY TAXES RECEIVABLE 827,162 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 345,138 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,473 TOTAL ASSETS 1,519,519 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,172,300 ACCOUNTS AND OTHER PAYABLES 1,253 TOTAL LIABILITIES 1,173,553 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (182,945) TOTAL FUND BALANCE 345,966 TOTAL LIABILITIES AND FUND BALANCE 1,519,519 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 16:41 12/08/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 357,462.00- 357,462.00- 15,994.87- 20,514.39- 5.739 336,947.61- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 108.28- 108.28 122-40010-000-000 Property Taxes/MUD Fire 872,859.00- 872,859.00- 43,848.43- 55,913.06- 6.406 816,945.94- 122-40011-000-000 Property Taxes/Fire-Delinquent 39.10- 2,914.37- 2,914.37 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 17.33- 2.311 732.67- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 137.12- 824.85- 18.330 3,675.15- Subtotal: 1,235,571.00- 1,235,571.00- 60,019.52- 80,292.28- 6.498 1,155,278.72- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 6.667 5,600.00- Subtotal: 6,000.00- 6,000.00- 400.00- 6.667 5,600.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 75.00- 10.714 625.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,700.00- 10,700.00- 75.00- .701 10,625.00- 122-49035-000-000 Prior Year Reserves 125,669.00- 125,669.00- 125,670.00- 100.001 1.00 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 800.00- 13.333 5,200.00- Subtotal: 131,669.00- 131,669.00- 126,470.00- 96.051 5,199.00- Program number: 1,383,940.00- 1,383,940.00- 60,019.52- 207,237.28- 14.974 1,176,702.72- Department number: Fire Revenues 1,383,940.00- 1,383,940.00- 60,019.52- 207,237.28- 14.974 1,176,702.72- Revenues Subtotal ----------- 1,383,940.00- 1,383,940.00- 60,019.52- 207,237.28- 14.974 1,176,702.72- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 16:41 12/08/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 469,067.00 469,067.00 35,360.88 57,935.75 12.351 411,131.25 122-50010-045-000 Overtime 46,745.00 46,745.00 2,417.48 5,784.92 12.375 40,960.08 122-50011-045-000 DPS Holiday Pay 14,930.00 14,930.00 14,457.01 14,457.01 96.832 472.99 122-50016-045-000 Longevity 5,505.00 5,505.00 5,505.00 122-50017-045-000 Certification 4,800.00 4,800.00 462.50 581.50 12.115 4,218.50 122-50020-045-000 Retirement 91,396.00 91,396.00 7,677.28 11,456.64 12.535 79,939.36 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,945.10 7,878.64 13.315 51,290.36 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 378.07 619.94 14.122 3,770.06 122-50028-045-000 Vision Insurance 811.00 811.00 66.31 108.72 13.406 702.28 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 330.60 542.05 13.450 3,487.95 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 3,036.47 4,503.42 13.475 28,917.58 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 709.96 1,052.84 14.438 6,239.16 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 1,657.00 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 659.00 1,318.00 15.163 7,374.00 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 250.00 122-50075-045-000 Tuition Reimbursement 300.00 300.00 300.00 Subtotal: 752,455.00 752,455.00 70,500.66 106,239.43 14.119 646,215.57 122-55030-045-000 Software & Support 7,378.00 7,378.00 462.50 6.269 6,915.50 122-55045-045-000 Legal 1,500.00 1,500.00 1,500.00 122-55080-045-000 Maintenance & Repairs 18,552.00 18,552.00 250.62 279.02 1.504 18,272.98 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 161.60 355.12 2.959 11,644.88 Subtotal: 39,430.00 39,430.00 412.22 1,096.64 2.781 38,333.36 122-60005-045-000 Telephone 50.00 50.00 50.00 122-60010-045-000 Communications/Pagers/Mobiles 5,000.00 5,000.00 176.37 2,412.87 48.257 2,587.13 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 502.00 202.22 2.240 8,823.78 122-60025-045-000 Water 1,200.00 1,200.00 101.21 215.99 17.999 984.01 122-60026-045-000 Cable 1,920.00 1,920.00 153.76 307.52 16.017 1,612.48 122-60030-045-000 Rent And/Or Usage 211,829.00 211,829.00 211,829.00 122-60035-045-000 Postage 100.00 100.00 .48 .480 99.52 122-60055-045-000 Insurance 12,179.00 12,179.00 940.09 1,880.18 15.438 10,298.82 122-60066-045-000 Publications/Books/Subscrips 200.00 200.00 179.00 179.00 89.500 21.00 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 335.00 7,394.85 48.714 7,785.15 122-60080-045-000 Schools & Training 4,280.00 4,280.00 146.00 231.00 5.397 4,049.00 122-60096-045-000 Emergency Management 1,400.00 1,400.00 1,400.00 122-60100-045-000 Travel & per diem 13,577.00 13,577.00 13,577.00 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 5,100.00 5,100.00 5,100.00 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 500.42 11.120 3,999.58 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 1,000.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 47.50 184.60 9.230 1,815.40 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 16:41 12/08/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 1,000.00 Subtotal: 291,541.00 291,541.00 2,580.93 13,509.13 4.634 278,031.87 122-65005-045-000 Fuel & Lube 10,454.00 10,454.00 199.31 1,211.25 11.586 9,242.75 122-65010-045-000 Uniforms 2,000.00 2,000.00 137.31 137.31 6.866 1,862.69 122-65015-045-000 Protective Clothing 5,200.00 5,200.00 5,200.00 122-65030-045-000 Chemicals 200.00 200.00 200.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 2,500.00 122-65055-045-000 Hardware 9,000.00 9,000.00 9,000.00 122-65085-045-000 Office Supplies 500.00 500.00 500.00 122-65105-045-000 Printing 548.00 548.00 38.17 6.965 509.83 Subtotal: 30,402.00 30,402.00 336.62 1,386.73 4.561 29,015.27 122-69005-045-000 Capital Outlays 250,000.00 250,000.00- 122-69008-045-000 Short Term Debt-Principal 158,262.00 158,262.00 158,262.00 122-69009-045-000 Short Term Debt-Interest 50,000.00 50,000.00 50,000.00 122-69050-045-000 Radios 23,500.00 23,500.00 23,500.00 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 17,950.00 17,950.00 100.000 122-69255-045-000 Airpacks 20,400.00 20,400.00 20,400.00 Subtotal: 270,112.00 270,112.00 267,950.00 99.200 2,162.00 Program number: 1,383,940.00 1,383,940.00 73,830.43 390,181.93 28.194 993,758.07 Department number: Fire 1,383,940.00 1,383,940.00 73,830.43 390,181.93 28.194 993,758.07 Expenditures Subtotal ----------- 1,383,940.00 1,383,940.00 73,830.43 390,181.93 28.194 993,758.07 Fund number: 122 Trophy Club MUD Fire Dept. 13,810.91 182,944.65 182,944.65- . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 398 11/03/2014 Rev Property Taxes/Assessments (4,519.52) 1,044.73 (3,474.79) GL 399 11/03/2014 Property Taxes/Assessments (1,044.73) (4,519.52) GL 371 11/03/2014 Property Taxes/Assessments (1,044.73) (5,564.25) GL 372 11/04/2014 Property Taxes/Assessments (2,216.13) (7,780.38) GL 373 11/05/2014 Property Taxes/Assessments (1,424.41) (9,204.79) GL 374 11/06/2014 Property Taxes/Assessments (673.29) (9,878.08) GL 375 11/07/2014 Property Taxes/Assessments (167.42) (10,045.50) GL 376 11/10/2014 Property Taxes/Assessments (1,479.60) (11,525.10) GL 377 11/12/2014 Property Taxes/Assessments (144.58) (11,669.68) GL 378 11/13/2014 Property Taxes/Assessments (1,261.60) (12,931.28) GL 379 11/14/2014 Property Taxes/Assessments (671.04) (13,602.32) GL 380 11/17/2014 Property Taxes/Assessments (626.70) (14,229.02) GL 386 11/18/2014 Property Taxes/Assessments (281.37) (14,510.39) GL 387 11/19/2014 Property Taxes/Assessments (363.17) (14,873.56) GL 388 11/20/2014 Property Taxes/Assessments (624.78) (15,498.34) GL 389 11/21/2014 Property Taxes/Assessments (906.39) (16,404.73) GL 392 11/24/2014 Property Taxes/Assessments (1,534.26) (17,938.99) GL 393 11/25/2014 Property Taxes/Assessments (1,490.83) (19,429.82) GL 394 11/26/2014 Property Taxes/Assessments (1,084.57) (20,514.39) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (15,994.87) (20,514.39) ** (357,462.00) Budgeted (336,947.61) Remaining 6 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (108.28) .00 (108.28) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (108.28) ** .00 Budgeted 108.28 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 398 11/03/2014 Rev Property Taxes/Assessments (12,064.63) 20,518.52 8,453.89 GL 399 11/03/2014 Property Taxes/Assessments (2,066.98) 6,386.91 GL 371 11/03/2014 Property Taxes/Assessments (20,518.52) (14,131.61) GL 372 11/04/2014 Property Taxes/Assessments (746.62) (14,878.23) GL 373 11/05/2014 Property Taxes/Assessments (1,681.97) (16,560.20) GL 374 11/06/2014 Property Taxes/Assessments (1,200.83) (17,761.03) GL 375 11/07/2014 Property Taxes/Assessments (1,450.17) (19,211.20) GL 376 11/10/2014 Property Taxes/Assessments (18,626.26) (37,837.46) GL 377 11/12/2014 Property Taxes/Assessments (814.36) (38,651.82) GL 378 11/13/2014 Property Taxes/Assessments (1,156.25) (39,808.07) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 379 11/14/2014 Property Taxes/Assessments (12,064.63) (2,078.10) (41,886.17) GL 380 11/17/2014 Property Taxes/Assessments (2,243.51) (44,129.68) GL 386 11/18/2014 Property Taxes/Assessments (5,176.86) (49,306.54) GL 387 11/19/2014 Property Taxes/Assessments (537.54) (49,844.08) GL 388 11/20/2014 Property Taxes/Assessments (162.83) (50,006.91) GL 389 11/21/2014 Property Taxes/Assessments (1,445.78) (51,452.69) GL 392 11/24/2014 Property Taxes/Assessments (1,539.86) (52,992.55) GL 393 11/25/2014 Property Taxes/Assessments (778.97) (53,771.52) GL 394 11/26/2014 Property Taxes/Assessments (2,141.54) (55,913.06) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (43,848.43) (55,913.06) ** (872,859.00) Budgeted (816,945.94) Remaining 6 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 378 11/13/2014 Property Taxes/Assessments (2,875.27) (5.68) (2,880.95) GL 380 11/17/2014 Property Taxes/Assessments (6.57) (2,887.52) GL 386 11/18/2014 Property Taxes/Assessments (26.85) (2,914.37) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (39.10) (2,914.37) ** .00 Budgeted 2,914.37 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I (17.33) .00 (17.33) _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 (17.33) ** (750.00) Budgeted (732.67) Remaining 2 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 378 11/13/2014 Property Taxes/Assessments (687.73) (1.14) (688.87) GL 380 11/17/2014 Property Taxes/Assessments (130.07) (818.94) GL 386 11/18/2014 Property Taxes/Assessments (5.91) (824.85) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (137.12) (824.85) ** (4,500.00) Budgeted (3,675.15) Remaining 18 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (400.00) .00 (400.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (400.00) ** (6,000.00) Budgeted (5,600.00) Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-43400-000-000 Fire Inspections (75.00) .00 (75.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (75.00) ** (700.00) Budgeted (625.00) Remaining 11 % 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-49035-000-000 Prior Year Reserves (125,670.00) .00 (125,670.00) _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 (125,670.00) ** (125,669.00) Budgeted 1.00 Remaining 100 % Used Account: 122-49900-000-000 Miscellaneous Income (800.00) .00 (800.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (800.00) ** (6,000.00) Budgeted (5,200.00) Remaining 13 % Used Department Totals: ------------------------------------------------------------------------------------------------ (207,237.28) ** (1,383,940.00) Budgeted (1,176,702.72) Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 275 11/07/2014 Fire Dept Payroll 11/7/14 22,574.87 17,661.56 40,236.43 GL 314 11/21/2014 FD Payroll 11/21/14 17,699.32 57,935.75 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 35,360.88 57,935.75 ** 469,067.00 Budgeted 411,131.25 Remaining 12 % Used Account: 122-50010-045-000 Overtime 314 11/21/2014 FD Payroll 11/21/14 3,367.44 2,417.48 5,784.92 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,417.48 5,784.92 ** 46,745.00 Budgeted 40,960.08 Remaining 12 % Used Account: 122-50011-045-000 DPS Holiday Pay 311 11/21/2014 FD Holiday Pay 11/21/14 14,457.01 14,457.01 GL _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: 14,457.01 14,457.01 ** 14,930.00 Budgeted 472.99 Remaining 97 % Used Account: 122-50016-045-000 Longevity .00 .00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 .00 ** 5,505.00 Budgeted 5,505.00 Remaining 0 % Used Account: 122-50017-045-000 Certification 275 11/07/2014 Fire Dept Payroll 11/7/14 119.00 462.50 581.50 GL _______________ Account: 122-50017-045-000 Certification Totals: 462.50 581.50 ** 4,800.00 Budgeted 4,218.50 Remaining 12 % Used Account: 122-50020-045-000 Retirement 275 11/07/2014 Fire Dept Payroll 11/7/14 3,779.36 2,614.50 6,393.86 GL 311 11/21/2014 FD Holiday Pay 11/21/14 2,126.61 8,520.47 GL 314 11/21/2014 FD Payroll 11/21/14 2,936.17 11,456.64 GL _______________ Account: 122-50020-045-000 Retirement Totals: 7,677.28 11,456.64 ** 91,396.00 Budgeted 79,939.36 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 275 11/07/2014 Fire Dept Payroll 11/7/14 2,933.54 2,146.70 5,080.24 GL 314 11/21/2014 FD Payroll 11/21/14 2,798.40 7,878.64 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,945.10 7,878.64 ** 59,169.00 Budgeted 51,290.36 Remaining 13 % Used Account: 122-50027-045-000 Dental Insurance 275 11/07/2014 Fire Dept Payroll 11/7/14 241.87 189.05 430.92 GL 314 11/21/2014 FD Payroll 11/21/14 189.02 619.94 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 378.07 619.94 ** 4,390.00 Budgeted 3,770.06 Remaining 14 % Used Account: 122-50028-045-000 Vision Insurance 275 11/07/2014 Fire Dept Payroll 11/7/14 42.41 33.15 75.56 GL 314 11/21/2014 FD Payroll 11/21/14 33.16 108.72 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 66.31 108.72 ** 811.00 Budgeted 702.28 Remaining 13 % Used Account: 122-50029-045-000 Life Insurance & Other 275 11/07/2014 Fire Dept Payroll 11/7/14 211.45 165.28 376.73 GL 314 11/21/2014 FD Payroll 11/21/14 165.32 542.05 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 330.60 542.05 ** 4,030.00 Budgeted 3,487.95 Remaining 13 % Used Account: 122-50030-045-000 Social Security Taxes 275 11/07/2014 Fire Dept Payroll 11/7/14 1,466.95 1,007.11 2,474.06 GL 311 11/21/2014 FD Holiday Pay 11/21/14 896.31 3,370.37 GL 314 11/21/2014 FD Payroll 11/21/14 1,133.05 4,503.42 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,036.47 4,503.42 ** 33,421.00 Budgeted 28,917.58 Remaining 13 % Used Account: 122-50035-045-000 Medicare Taxes 275 11/07/2014 Fire Dept Payroll 11/7/14 342.88 235.46 578.34 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 311 11/21/2014 FD Holiday Pay 11/21/14 342.88 209.59 787.93 GL 314 11/21/2014 FD Payroll 11/21/14 264.91 1,052.84 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 709.96 1,052.84 ** 7,292.00 Budgeted 6,239.16 Remaining 14 % Used Account: 122-50040-045-000 Unemployment Taxes .00 .00 _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .00 .00 ** 1,657.00 Budgeted 1,657.00 Remaining 0 % Used Account: 122-50045-045-000 Workman's Compensation 192 11/01/2014 Nov TML Ins & Workers Comp 659.00 659.00 1,318.00 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 659.00 1,318.00 ** 8,692.00 Budgeted 7,374.00 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 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 462.50 .00 462.50 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 462.50 ** 7,378.00 Budgeted 6,915.50 Remaining 6 % Used Account: 122-55045-045-000 Legal . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 309 11/21/2014 Nov A/P Verizon,GST, Symonds,Ganns 28.40 70.00 98.40 TOWN OF TROPHY CLUB 34406 AP 362 11/27/2014 10/28-11/26/14 PCards LOCKE SUPPLY WE DENTON 106.88 205.28 LOCKE SUPPLY WE DENTON PC 362 11/27/2014 10/28-11/26/14 PCards SAMSCLUB #4795 41.45 246.73 SAMSCLUB #4795 PC 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (32.29) 214.44 AR 416 11/30/2014 Nov A/P Rug Service 32.29 246.73 G & K SERVICES 34426 AP 416 11/30/2014 Nov A/P Rug Service 32.29 279.02 G & K SERVICES 34426 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 250.62 279.02 ** 18,552.00 Budgeted 18,272.98 Remaining 2 % Used Account: 122-55090-045-000 Vehicle Maintenance 362 11/27/2014 10/28-11/26/14 PCards WM SUPERCENTER #5247 193.52 25.58 219.10 WM SUPERCENTER #5247 PC 362 11/27/2014 10/28-11/26/14 PCards TRACTOR SUPPLY COMPANY 5.29 224.39 TRACTOR SUPPLY COMPANY PC 362 11/27/2014 10/28-11/26/14 PCards TRACTOR SUPPLY COMPANY 54.45 278.84 TRACTOR SUPPLY COMPANY PC 362 11/27/2014 10/28-11/26/14 PCards AUTOZONE #4206 76.28 355.12 AUTOZONE #4206 PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 161.60 355.12 ** 12,000.00 Budgeted 11,644.88 Remaining 3 % Used Account: 122-60005-045-000 Telephone .00 .00 _______________ Account: 122-60005-045-000 Telephone Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 275 11/07/2014 Fire Dept Payroll 11/7/14 2,236.50 37.50 2,274.00 GL 309 11/21/2014 Nov A/P Verizon,GST, Symonds,Ganns 138.87 2,412.87 TOWN OF TROPHY CLUB 34406 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 176.37 2,412.87 ** 5,000.00 Budgeted 2,587.13 Remaining 48 % Used Account: 122-60020-045-000 Electricity/Gas . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 309 11/21/2014 Nov A/P Electricity 10/13/14-11/11/14 (299.78) 822.41 522.63 HUDSON ENERGY SERVICES, LLC 34385 AP 309 11/21/2014 Nov A/P FD Gas 10/21/14-11/15/14 181.59 704.22 ATMOS ENERGY 34376 AP 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (502.00) 202.22 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 502.00 202.22 ** 9,026.00 Budgeted 8,823.78 Remaining 2 % Used Account: 122-60025-045-000 Water 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: 114.78 (101.21) 13.57 AR 416 11/30/2014 Nov A/P Nov Water 202.42 215.99 TROPHY CLUB MUD (WATER BILLS) 34450 AP _______________ Account: 122-60025-045-000 Water Totals: 101.21 215.99 ** 1,200.00 Budgeted 984.01 Remaining 18 % Used Account: 122-60026-045-000 Cable 367 11/14/2014 Firefighter Cable 153.76 (133.82) 19.94 GL 362 11/27/2014 10/28-11/26/14 PCards ATT*BILL PAYMENT 158.76 178.70 ATT*BILL PAYMENT PC 362 11/27/2014 10/28-11/26/14 PCards ATT*BILL PAYMENT 128.82 307.52 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 153.76 307.52 ** 1,920.00 Budgeted 1,612.48 Remaining 16 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 211,829.00 Budgeted 211,829.00 Remaining 0 % Used Account: 122-60035-045-000 Postage .48 .00 .48 _______________ Account: 122-60035-045-000 Postage Totals: .00 .48 ** 100.00 Budgeted 99.52 Remaining 0 % Used Account: 122-60055-045-000 Insurance 192 11/01/2014 Nov TML Ins & Workers Comp 940.09 940.09 1,880.18 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.09 1,880.18 ** 12,179.00 Budgeted 10,298.82 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60066-045-000 Publications/Books/Subscrips 255 11/10/2014 Nov A/P Fire Engineering Magazine (48 179.00 179.00 Cascade Subscription Svc, Inc 34340 AP _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: 179.00 179.00 ** 200.00 Budgeted 21.00 Remaining 90 % Used Account: 122-60070-045-000 Dues & Memberships 309 11/21/2014 Nov A/P Dept and Member renewal 7,059.85 335.00 7,394.85 STATE FIREMEN'S FIRE MARSHALS 34402 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 335.00 7,394.85 ** 15,180.00 Budgeted 7,785.15 Remaining 49 % Used Account: 122-60080-045-000 Schools & Training 362 11/27/2014 10/28-11/26/14 PCards FIRE PROTECTION PUB-WE 85.00 121.00 206.00 FIRE PROTECTION PUB-WE PC 362 11/27/2014 10/28-11/26/14 PCards COOK CHILDRENS HLTH CR 25.00 231.00 COOK CHILDRENS HLTH CR PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 146.00 231.00 ** 4,280.00 Budgeted 4,049.00 Remaining 5 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,400.00 Budgeted 1,400.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem .00 .00 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 .00 ** 13,577.00 Budgeted 13,577.00 Remaining 0 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 5,100.00 Budgeted 5,100.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 500.42 .00 500.42 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 500.42 ** 4,500.00 Budgeted 3,999.58 Remaining 11 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement .00 .00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60195-045-000 Flags & Repair 309 11/21/2014 Nov A/P Verizon,GST, Symonds,Ganns 137.10 47.50 184.60 TOWN OF TROPHY CLUB 34406 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 47.50 184.60 ** 2,000.00 Budgeted 1,815.40 Remaining 9 % 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 385 11/30/2014 Nov MUD Gas Log 1,011.94 .34 1,012.28 GL 416 11/30/2014 Nov A/P November fuel 198.97 1,211.25 US Bank Voyager Fleet Systems 34452 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 199.31 1,211.25 ** 10,454.00 Budgeted 9,242.75 Remaining 12 % Used Account: 122-65010-045-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 309 11/21/2014 Nov A/P Verizon,GST, Symonds,Ganns 94.03 94.03 TOWN OF TROPHY CLUB 34406 AP 362 11/27/2014 10/28-11/26/14 PCards GOT YOU COVERED WORKWE 43.28 137.31 GOT YOU COVERED WORKWE PC _______________ Account: 122-65010-045-000 Uniforms Totals: 137.31 137.31 ** 2,000.00 Budgeted 1,862.69 Remaining 7 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 5,200.00 Budgeted 5,200.00 Remaining 0 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 200.00 Budgeted 200.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-65055-045-000 Hardware .00 .00 _______________ Account: 122-65055-045-000 Hardware Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies .00 .00 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-65105-045-000 Printing . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 38.17 .00 38.17 _______________ Account: 122-65105-045-000 Printing Totals: .00 38.17 ** 548.00 Budgeted 509.83 Remaining 7 % Used Account: 122-69005-045-000 Capital Outlays 250,000.00 .00 250,000.00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 250,000.00 ** .00 Budgeted (250,000.00) Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 158,262.00 Budgeted 158,262.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 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 23,500.00 Budgeted 23,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 .00 17,950.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 17,950.00 ** 17,950.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 20,400.00 Budgeted 20,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 390,181.93 ** 1,383,940.00 Budgeted 993,758.07 Remaining 28 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 182,944.65 .00 Budgeted (182,944.65) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET NOVEMBER 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 11/30/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 122,636 - - 122,636 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,505,440 - - 1,505,440 INVESTMENTS-TEXPOOL 575,924 169,600 23,702 769,226 PREPAID EXPENSES 65,693 - - 65,693 ADVALOREM PROPERTY TAXES RECEIVABLE 158,157 - - 158,157 UTILITY AND OTHER ACCOUNTS RECEIVABLE 635,850 - - 635,850 - TOTAL ASSETS 3,064,300 169,600 23,702 3,257,602 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 158,157 - - 158,157 ACCOUNTS AND OTHER PAYABLES 496,127 - 15,531 511,658 CUSTOMER DEPOSITS 301,267 - - 301,267 - TOTAL LIABILITIES 955,551 - 15,531 971,082 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 260,697 260,697 NON-SPENDABLE FUND BALANCE 13,980 13,980 ASSIGNED FUND BALANCE 1,409,006 10,268 1,419,274 UNASSIGNED FUND BALANCE 725,069 - - 725,069 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (39,305) (91,097) (2,097) (132,499) - TOTAL FUND BALANCE 2,108,750 169,600 8,171 2,286,520 - TOTAL LIABILITIES AND FUND BALANCE 3,064,300 169,600 23,702 3,257,602 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 167,857.00- 167,857.00- 8,432.63- 10,752.82- 6.406 157,104.18- 135-40002-000-000 Property Taxes/Delinquent 4.14- 311.72- 311.72 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 25.55- 106.00- 11.778 794.00- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 22,757.30- 22,757.30- 16.983 111,239.70- Subtotal: 302,754.00- 302,754.00- 31,219.62- 33,927.84- 11.206 268,826.16- 135-47000-000-000 Water 5,286,045.00- 5,286,045.00- 266,861.85- 587,336.57- 11.111 4,698,708.43- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 173,642.74- 345,098.73- 15.196 1,925,883.27- 135-47025-000-000 Penalties 63,416.00- 63,416.00- 11,438.62- 20,919.57- 32.988 42,496.43- 135-47030-000-000 Service Charges 8,000.00- 8,000.00- 978.00- 2,181.00- 27.263 5,819.00- 135-47031-000-000 PID Surcharge Revenue 11,347.50 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 450.00- 22.500 1,550.00- 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 450.00- 1,350.00- 27.000 3,650.00- 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 5,047.70- 12,205.20- 14.059 74,609.80- Subtotal: 7,722,258.00- 7,722,258.00- 447,221.41- 969,541.07- 12.555 6,752,716.93- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 13,800.00- 34,500.00- 18.750 149,500.00- Subtotal: 184,000.00- 184,000.00- 13,800.00- 34,500.00- 18.750 149,500.00- 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 464.70- 987.12- 19.742 4,012.88- 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 351.00- 351.00- 351.00- 135-49036-000-000 GASB Reserves 74,706.00- 74,706.00- 74,706.00- 100.000 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 3,087.00- 8,102.57- 9.646 75,897.43- 135-49900-000-000 Miscellaneous Income 54,000.00- 54,000.00- 19,621.78- 19,645.94- 36.381 34,354.06- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 10.20- 12.20- 12.200 87.80- Subtotal: 235,321.00- 235,321.00- 24,677.54- 106,441.55- 45.232 128,879.45- Program number: 8,444,333.00- 8,444,333.00- 516,918.57- 1,144,410.46- 13.552 7,299,922.54- Department number: Revenues 8,444,333.00- 8,444,333.00- 516,918.57- 1,144,410.46- 13.552 7,299,922.54- Revenues Subtotal ----------- 8,444,333.00- 8,444,333.00- 516,918.57- 1,144,410.46- 13.552 7,299,922.54- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 301,101.00 301,101.00 11,529.16 26,807.09 8.903 274,293.91 135-50010-010-000 Overtime 19,500.00 19,500.00 571.80 2,091.88 10.728 17,408.12 135-50016-010-000 Longevity 5,343.00 5,343.00 2,705.00 2,705.00 50.627 2,638.00 135-50017-010-000 Certification 4,800.00 4,800.00 150.00 550.00 11.458 4,250.00 135-50020-010-000 Retirement 29,349.00 29,349.00 1,343.04 2,887.43 9.838 26,461.57 135-50026-010-000 Medical Insurance 44,988.00 44,988.00 1,483.33 3,730.31 8.292 41,257.69 135-50027-010-000 Dental Insurance 3,288.00 3,288.00 134.49 292.95 8.910 2,995.05 135-50028-010-000 Vision Insurance 834.00 834.00 31.35 71.37 8.558 762.63 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 186.33 375.64 12.220 2,698.36 135-50030-010-000 Social Security Taxes 21,135.00 21,135.00 919.77 1,975.12 9.345 19,159.88 135-50035-010-000 Medicare Taxes 4,943.00 4,943.00 215.11 461.93 9.345 4,481.07 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 1,242.00 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 857.91 1,715.82 10.710 14,304.18 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,000.00 63.00 6.300 937.00 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 456,917.00 456,917.00 20,127.29 43,727.54 9.570 413,189.46 135-55005-010-000 Engineering 10,000.00 10,000.00 10,000.00 135-55080-010-000 Maintenance & Repairs 71,242.00 71,242.00 2,892.13 9,040.77 12.690 62,201.23 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 378.75 2,150.68 26.884 5,849.32 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 243.00 6.943 3,257.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 420.26 7.641 5,079.74 Subtotal: 98,242.00 98,242.00 3,270.88 11,854.71 12.067 86,387.29 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 314.22 314.22 6.396 4,598.78 135-60020-010-000 Electricity 170,765.00 170,765.00 9,414.64 18,712.38 10.958 152,052.62 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,138.00 4,138.00 4,138.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 1,500.00 1,500.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 8,898.85 8,898.85 18.060 40,376.15 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 196,537.78 196,537.78 6.712 2,731,770.22 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 39.75 363.75 10.393 3,136.25 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: 3,169,249.00 3,169,249.00 215,205.24 224,826.98 7.094 2,944,422.02 135-65005-010-000 Fuel & Lube 29,172.00 29,172.00 1,360.91 2,886.98 9.896 26,285.02 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,620.00 3,620.00 99.99 99.99 2.762 3,520.01 135-65030-010-000 Chemicals 7,000.00 7,000.00 624.53 2,200.83 31.440 4,799.17 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 141.75 14.175 858.25 135-65050-010-000 Meter Expense 161,500.00 161,500.00 11,305.00 11,305.00 7.000 150,195.00 Subtotal: 203,492.00 203,492.00 13,390.43 16,634.55 8.175 186,857.45 135-69005-010-000 Capital Outlays 1,089,006.00 1,089,006.00 26,007.06 26,007.06 2.388 1,062,998.94 135-69008-010-000 Short Term Debt-Principal 129,000.00 129,000.00 129,000.00 135-69009-010-000 Short Term Debt-Interest 3,612.00 3,612.00 3,612.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 151,507.00 151,507.00 80,986.69 80,986.69 53.454 70,520.31 Subtotal: 1,448,125.00 1,448,125.00 106,993.75 181,993.75 12.568 1,266,131.25 Program number: 5,376,025.00 5,376,025.00 358,987.59 479,037.53 8.911 4,896,987.47 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 1,777.63 35.553 3,222.37 Subtotal: 5,000.00 5,000.00 1,777.63 35.553 3,222.37 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 1,777.63 17.776 8,222.37 Department number: Water 5,386,025.00 5,386,025.00 358,987.59 480,815.16 8.927 4,905,209.84 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 305,744.00 305,744.00 23,097.03 37,888.77 12.392 267,855.23 135-50010-020-000 Overtime 19,500.00 19,500.00 2,974.54 3,981.22 20.417 15,518.78 135-50016-020-000 Longevity 5,617.00 5,617.00 5,615.00 5,615.00 99.964 2.00 135-50017-020-000 Certification 6,600.00 6,600.00 550.00 1,100.00 16.667 5,500.00 135-50020-020-000 Retirement 29,948.00 29,948.00 2,894.85 4,362.92 14.568 25,585.08 135-50026-020-000 Medical Insurance 61,001.00 61,001.00 4,900.46 8,077.95 13.242 52,923.05 135-50027-020-000 Dental Insurance 4,146.00 4,146.00 313.98 517.50 12.482 3,628.50 135-50028-020-000 Vision Insurance 990.00 990.00 74.94 123.51 12.476 866.49 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 272.96 535.00 16.750 2,659.00 135-50030-020-000 Social Security Taxes 21,680.00 21,680.00 1,804.18 2,682.21 12.372 18,997.79 135-50035-020-000 Medicare Taxes 5,070.00 5,070.00 421.93 627.28 12.372 4,442.72 135-50040-020-000 Unemployment Taxes 1,242.00 1,242.00 1,242.00 135-50045-020-000 Workman's Compensation 16,020.00 16,020.00 857.91 1,715.82 10.710 14,304.18 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 150.00 135-50070-020-000 Employee Relations 550.00 550.00 141.97 141.97 25.813 408.03 Subtotal: 481,452.00 481,452.00 43,919.75 67,369.15 13.993 414,082.85 135-55080-020-000 Maintenance & Repairs 58,000.00 58,000.00 27,933.71 29,702.71 51.212 28,297.29 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 3,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 7.29 1.458 492.71 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 5,831.13 7,670.10 13.946 47,329.90 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,087.00 2,755.00 11.020 22,245.00 Subtotal: 141,500.00 141,500.00 35,851.84 40,135.10 28.364 101,364.90 135-60010-020-000 Communications/Pagers/Mobiles 4,662.00 4,662.00 410.92 410.92 8.814 4,251.08 135-60020-020-000 Electricity 149,292.00 149,292.00 11,956.28 16,692.63 11.181 132,599.37 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 54.95 13.738 345.05 135-60070-020-000 Dues & Memberships 250.00 250.00 250.00 135-60080-020-000 Schools & Training 4,065.00 4,065.00 240.00 351.00 8.635 3,714.00 135-60090-020-000 Safety Program 550.00 550.00 550.00 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 92.30 92.30 5.769 1,507.70 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 52.006 8,231.00 135-60245-020-000 Miscellaneous Expenses 300.00 300.00 300.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 Subtotal: 187,769.00 187,769.00 12,699.50 26,520.80 14.124 161,248.20 135-65005-020-000 Fuel & Lube 36,328.00 36,328.00 1,472.73 4,321.80 11.897 32,006.20 135-65010-020-000 Uniforms 2,778.00 2,778.00 971.30 2,365.97 85.168 412.03 135-65030-020-000 Chemicals 30,000.00 30,000.00 1,468.52 1,468.52 4.895 28,531.48 135-65035-020-000 Small Tools 2,000.00 2,000.00 158.82 458.33 22.917 1,541.67 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65040-020-000 Safety Equipment 750.00 750.00 162.00 162.00 21.600 588.00 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 5,102.81 39.252 7,897.19 Subtotal: 84,856.00 84,856.00 4,233.37 13,879.43 16.356 70,976.57 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 73,640.00 73,640.00 49.093 76,360.00 135-69007-020-000 LTD Payment from WW Sales 357,538.00 357,538.00 357,538.00 135-69008-020-000 Short Term Debt-Principal 56,991.00 56,991.00 56,991.00 135-69009-020-000 Short Term Debt-Interest 2,011.00 2,011.00 2,011.00 Subtotal: 566,540.00 566,540.00 73,640.00 73,640.00 12.998 492,900.00 Program number: 1,462,117.00 1,462,117.00 170,344.46 221,544.48 15.152 1,240,572.52 Department number: Wastewater 1,462,117.00 1,462,117.00 170,344.46 221,544.48 15.152 1,240,572.52 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,500.00 1,500.00 15.000 8,500.00 135-50030-026-000 Social Security Taxes 620.00 620.00 93.00 93.00 15.000 527.00 135-50035-026-000 Medicare Taxes 145.00 145.00 21.75 21.75 15.000 123.25 135-50040-026-000 Unemployment Taxes 230.00 230.00 34.50 34.50 15.000 195.50 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 5.88 16.333 30.12 Subtotal: 11,031.00 11,031.00 1,652.19 1,655.13 15.004 9,375.87 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 1,200.00 27.96 27.96 2.330 1,172.04 135-60080-026-000 Schools & Training 4,000.00 4,000.00 975.00 975.00 24.375 3,025.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 50.00 50.00 5.000 950.00 Subtotal: 11,850.00 11,850.00 1,087.96 1,087.96 9.181 10,762.04 Program number: 22,881.00 22,881.00 2,740.15 2,743.09 11.989 20,137.91 Department number: Board of Directors 22,881.00 22,881.00 2,740.15 2,743.09 11.989 20,137.91 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 477,578.00 477,578.00 35,233.81 58,141.12 12.174 419,436.88 135-50010-030-000 Overtime 1,000.00 1,000.00 28.13 35.11 3.511 964.89 135-50016-030-000 Longevity 3,283.00 3,283.00 3,282.50 3,282.50 99.985 .50 135-50020-030-000 Retirement 42,840.00 42,840.00 3,461.30 5,519.01 12.883 37,320.99 135-50026-030-000 Medical Insurance 65,015.00 65,015.00 4,804.81 8,133.69 12.510 56,881.31 135-50027-030-000 Dental Insurance 4,944.00 4,944.00 340.42 573.14 11.593 4,370.86 135-50028-030-000 Vision Insurance 1,158.00 1,158.00 81.62 137.83 11.902 1,020.17 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 374.49 699.19 16.136 3,633.81 135-50030-030-000 Social Security Taxes 30,079.00 30,079.00 2,268.37 3,606.17 11.989 26,472.83 135-50035-030-000 Medicare Taxes 7,422.00 7,422.00 530.51 843.38 11.363 6,578.62 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 48.00 79.15 5.462 1,369.85 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 174.60 10.672 1,461.40 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 38.00 7.600 462.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 30.28- 605.70 12.114 4,394.30 Subtotal: 646,237.00 646,237.00 50,510.98 81,868.59 12.669 564,368.41 135-55030-030-000 Software & Support 75,588.00 75,588.00 7,692.97 27,025.60 35.754 48,562.40 135-55070-030-000 Independent Labor 8,000.00 8,000.00 5,583.75 5,643.75 70.547 2,356.25 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 4,500.00 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 1,026.53 1,800.26 27.696 4,699.74 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 627.53 627.53 7.747 7,472.47 135-55160-030-000 Professional Outside Services 58,000.00 58,000.00 12,400.00 37,077.95 63.928 20,922.05 135-55161-030-000 Town Personnel Contract 6,170.00 6,170.00 20,000.00 20,000.00 324.149 13,830.00- 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 584.60 7.129 7,615.40 Subtotal: 175,258.00 175,258.00 47,330.78 92,759.69 52.928 82,498.31 135-60005-030-000 Telephone 13,361.00 13,361.00 195.00 390.00 2.919 12,971.00 135-60010-030-000 Communications/Pagers/Mobiles 4,056.00 4,056.00 337.99 637.99 15.730 3,418.01 135-60020-030-000 Electricity/Gas 14,978.00 14,978.00 341.45 341.45 2.280 14,636.55 135-60025-030-000 Water 1,500.00 1,500.00 85.65 177.46 11.831 1,322.54 135-60035-030-000 Postage 28,500.00 28,500.00 178.61 2,617.92 9.186 25,882.08 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 5,066.84 5,106.84 15.959 26,893.16 135-60050-030-000 Bad Debt Expense 6,200.00 6,200.00 6,200.00 135-60055-030-000 Insurance 48,751.00 48,751.00 4,096.26 8,159.27 16.737 40,591.73 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 5,000.00 5,000.00 775.00 775.00 15.500 4,225.00 135-60075-030-000 Meetings 400.00 400.00 25.11 6.278 374.89 135-60079-030-000 Public Education 5,000.00 5,000.00 5,000.00 135-60080-030-000 Schools & Training 10,235.00 10,235.00 70.00 .684 10,165.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 133.54 223.65 4.142 5,176.35 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 3,219.65 3,219.65 18.398 14,280.35 135-60270-030-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 135-60360-030-000 Furniture/Equipment < $5000 10,475.00 10,475.00 662.80 5,035.96 48.076 5,439.04 Subtotal: 218,406.00 218,406.00 15,092.79 26,780.30 12.262 191,625.70 135-65010-030-000 Uniforms 1,855.00 1,855.00 943.00 943.00 50.836 912.00 135-65055-030-000 Hardware 75,966.00 75,966.00 9,322.16- 73,329.41 96.529 2,636.59 135-65085-030-000 Office Supplies 9,000.00 9,000.00 443.83 1,017.02 11.300 7,982.98 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 52.10 1.101 4,679.90 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 657.81 927.74 18.555 4,072.26 135-65097-030-000 Vending Machine Supplies 200.00 200.00 200.00 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 Subtotal: 101,553.00 101,553.00 7,277.52- 76,269.27 75.103 25,283.73 135-69005-030-000 Capital Outlays 125,000.00 125,000.00 125,000.00 135-69170-030-000 Copier Lease Installments 4,236.00 4,236.00 40.79 .963 4,195.21 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 16,329.00 16,329.00 100.000 Subtotal: 145,565.00 145,565.00 16,369.79 11.246 129,195.21 Program number: 1,287,019.00 1,287,019.00 105,657.03 294,047.64 22.847 992,971.36 Department number: Administration 1,287,019.00 1,287,019.00 105,657.03 294,047.64 22.847 992,971.36 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 250,000.00 250,000.00 182,288.44 182,288.44 72.915 67,711.56 135-55055-039-000 Auditing 22,491.00 22,491.00 22,491.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 2,276.56 2,276.56 22.766 7,723.44 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 286,291.00 286,291.00 184,565.00 184,565.00 64.468 101,726.00 Program number: 286,291.00 286,291.00 184,565.00 184,565.00 64.468 101,726.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 16:41 12/08/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 3 WWTP Bonds Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-003 Legal/WWTP Bonds 10,279.77- Subtotal: 10,279.77- Program number: 3 WWTP Bonds 10,279.77- Department number: Non Departmental 286,291.00 286,291.00 174,285.23 184,565.00 64.468 101,726.00 Expenditures Subtotal ----------- 8,444,333.00 8,444,333.00 812,014.46 1,183,715.37 14.018 7,260,617.63 Fund number: 135 MUD 1 General Fund 295,095.89 39,304.91 39,304.91- . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 16:41 12/08/14 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 91,329.00- 91,329.00 137-49146-000-000 Intergov Transfer-Fire Dept 17,950.00- 17,950.00 Subtotal: 109,279.00- 109,279.00 Program number: 109,279.00- 109,279.00 Department number: 109,279.00- 109,279.00 Revenues Subtotal ----------- 109,279.00- 109,279.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 16:41 12/08/14 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-030-000 GASB Replacement 74,706.00 74,706.00- Subtotal: 74,706.00 74,706.00- Program number: 74,706.00 74,706.00- Department number: Administration 74,706.00 74,706.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 16:41 12/08/14 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-045-000 GASB Replacement 125,670.00 125,670.00- Subtotal: 125,670.00 125,670.00- Program number: 125,670.00 125,670.00- Department number: Fire Department 125,670.00 125,670.00- Expenditures Subtotal ----------- 200,376.00 200,376.00- Fund number: 137 MUD 1 Consolidated GASB 91,097.00 91,097.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 16:41 12/08/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income .60- 3.13- 3.13 Subtotal: .60- 3.13- 3.13 Program number: .60- 3.13- 3.13 Department number: .60- 3.13- 3.13 Revenues Subtotal ----------- .60- 3.13- 3.13 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 16:41 12/08/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 3,348.00 3,348.00 2,100.00 2,100.00 62.724 1,248.00 Subtotal: 3,348.00 3,348.00 2,100.00 2,100.00 62.724 1,248.00 Program number: 3 Indian Creek Waterline 3,348.00 3,348.00 2,100.00 2,100.00 62.724 1,248.00 Department number: Water 3,348.00 3,348.00 2,100.00 2,100.00 62.724 1,248.00 Expenditures Subtotal ----------- 3,348.00 3,348.00 2,100.00 2,100.00 62.724 1,248.00 Fund number: 507 MUD 1 Capital Projects 3,348.00 3,348.00 2,099.40 2,096.87 62.631 1,251.13 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 398 11/03/2014 Rev Property Taxes/Assessments (2,320.19) 3,945.97 1,625.78 GL 399 11/03/2014 Property Taxes/Assessments (397.51) 1,228.27 GL 371 11/03/2014 Property Taxes/Assessments (3,945.97) (2,717.70) GL 372 11/04/2014 Property Taxes/Assessments (143.59) (2,861.29) GL 373 11/05/2014 Property Taxes/Assessments (323.46) (3,184.75) GL 374 11/06/2014 Property Taxes/Assessments (230.94) (3,415.69) GL 375 11/07/2014 Property Taxes/Assessments (278.89) (3,694.58) GL 376 11/10/2014 Property Taxes/Assessments (3,582.06) (7,276.64) GL 377 11/12/2014 Property Taxes/Assessments (156.61) (7,433.25) GL 378 11/13/2014 Property Taxes/Assessments (222.36) (7,655.61) GL 379 11/14/2014 Property Taxes/Assessments (399.65) (8,055.26) GL 380 11/17/2014 Property Taxes/Assessments (431.45) (8,486.71) GL 386 11/18/2014 Property Taxes/Assessments (995.58) (9,482.29) GL 387 11/19/2014 Property Taxes/Assessments (103.38) (9,585.67) GL 388 11/20/2014 Property Taxes/Assessments (31.31) (9,616.98) GL 389 11/21/2014 Property Taxes/Assessments (278.04) (9,895.02) GL 392 11/24/2014 Property Taxes/Assessments (296.14) (10,191.16) GL 393 11/25/2014 Property Taxes/Assessments (149.81) (10,340.97) GL 394 11/26/2014 Property Taxes/Assessments (411.85) (10,752.82) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (8,432.63) (10,752.82) ** (167,857.00) Budgeted (157,104.18) Remaining 6 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 378 11/13/2014 Property Taxes/Assessments (307.58) (.61) (308.19) GL 380 11/17/2014 Property Taxes/Assessments (.66) (308.85) GL 386 11/18/2014 Property Taxes/Assessments (2.87) (311.72) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (4.14) (311.72) ** .00 Budgeted 311.72 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 378 11/13/2014 Property Taxes/Assessments (80.45) (.12) (80.57) GL 380 11/17/2014 Property Taxes/Assessments (24.80) (105.37) GL 386 11/18/2014 Property Taxes/Assessments (.63) (106.00) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (25.55) (106.00) ** (900.00) Budgeted (794.00) Remaining 12 % Used Account: 135-40025-000-000 PID Surcharges . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 297 11/01/2014 Recode PID Surcharges to 40025 (11,347.50) (11,347.50) GL 330 11/30/2014 UB 11/30/14 Billing UB20141130-20141130 User: (11,409.80) (22,757.30) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (22,757.30) (22,757.30) ** (133,997.00) Budgeted (111,239.70) Remaining 17 % Used Account: 135-47000-000-000 Water 341 11/20/2014 UB 11/20/2014 Billing Adj UB20141120-20141120 User: (320,474.72) 130.17 (320,344.55) UB 330 11/30/2014 UB 11/30/14 Billing UB20141130-20141130 User: (266,992.02) (587,336.57) UB _______________ Account: 135-47000-000-000 Water Totals: (266,861.85) (587,336.57) ** (5,286,045.00) Budgeted (4,698,708.43) Remaining 11 % Used Account: 135-47005-000-000 Sewer 330 11/30/2014 UB 11/30/14 Billing UB20141130-20141130 User: (171,455.99) (173,642.74) (345,098.73) UB _______________ Account: 135-47005-000-000 Sewer Totals: (173,642.74) (345,098.73) ** (2,270,982.00) Budgeted (1,925,883.27) Remaining 15 % Used Account: 135-47025-000-000 Penalties 339 11/19/2014 UB 11/19/14 NSF Check Fee UB20141119-20141119 User: (9,480.95) 25.00 (9,455.95) UB 308 11/21/2014 UB 11/21/14 Penalties UB20141121-20141121 User: (11,735.65) (21,191.60) UB 345 11/25/2014 UB 11/25/14 Penalty removals UB20141125-20141125 User: 272.03 (20,919.57) UB _______________ Account: 135-47025-000-000 Penalties Totals: (11,438.62) (20,919.57) ** (63,416.00) Budgeted (42,496.43) Remaining 33 % Used Account: 135-47030-000-000 Service Charges 208 11/06/2014 UB 11/6/14 Cut Off list UB20141106-20141106 User: (1,203.00) (825.00) (2,028.00) UB 336 11/14/2014 UB 11/14/14 NSF Check Fee UB20141114-20141114 User: (50.00) (2,078.00) UB 339 11/19/2014 UB 11/19/14 NSF Check Fee UB20141119-20141119 User: (25.00) (2,103.00) UB 342 11/21/2014 UB 11/21/14 NSF Check Fee UB20141121-20141121 User: (50.00) (2,153.00) UB 349 11/25/2014 UB 11/25/2014 NSF Check UB20141125-20141125 User: (25.00) (2,178.00) UB 330 11/30/2014 UB 11/30/14 Billing UB20141130-20141130 User: (3.00) (2,181.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (978.00) (2,181.00) ** (8,000.00) Budgeted (5,819.00) Remaining 27 % Used Account: 135-47031-000-000 PID Surcharge Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 297 11/01/2014 Recode PID Surcharges to 40025 (11,347.50) 11,347.50 .00 GL _______________ Account: 135-47031-000-000 PID Surcharge Revenue Totals: 11,347.50 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-47035-000-000 Plumbing Inspections 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (300.00) (150.00) (450.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (450.00) ** (2,000.00) Budgeted (1,550.00) Remaining 23 % Used Account: 135-47045-000-000 Sewer Inspections 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (900.00) (450.00) (1,350.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (1,350.00) ** (5,000.00) Budgeted (3,650.00) Remaining 27 % Used Account: 135-47070-000-000 TCCC Effluent Charges 330 11/30/2014 UB 11/30/14 Billing UB20141130-20141130 User: (7,157.50) (5,047.70) (12,205.20) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (5,047.70) (12,205.20) ** (86,815.00) Budgeted (74,609.80) Remaining 14 % Used Account: 135-48005-000-000 Utility Fees 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (20,700.00) (13,800.00) (34,500.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (13,800.00) (34,500.00) ** (184,000.00) Budgeted (149,500.00) Remaining 19 % Used Account: 135-49010-000-000 Interest Income 396 11/30/2014 Bank Interest/November (522.42) (87.97) (610.39) GL 396 11/30/2014 Bank Interest/November (25.51) (635.90) GL 396 11/30/2014 Bank Interest/November (408.94) (1,044.84) GL 400 11/30/2014 Reverse Bank Interest/November 87.97 (956.87) GL 400 11/30/2014 Reverse Bank Interest/November 25.51 (931.36) GL 400 11/30/2014 Reverse Bank Interest/November 408.94 (522.42) GL 401 11/30/2014 Bank Interest/November (70.50) (592.92) GL 401 11/30/2014 Bank Interest/November (24.74) (617.66) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 401 11/30/2014 Bank Interest/November (522.42) (369.46) (987.12) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (464.70) (987.12) ** (5,000.00) Budgeted (4,012.88) Remaining 20 % Used Account: 135-49016-000-000 Cell Tower Revenue 365 11/14/2014 AT&T Antenna Lease (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 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 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 .00 .00 _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 .00 ** (351.00) Budgeted (351.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves (74,706.00) .00 (74,706.00) _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 (74,706.00) ** (74,706.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (5,015.57) (3,087.00) (8,102.57) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (3,087.00) (8,102.57) ** (84,000.00) Budgeted (75,897.43) Remaining 10 % Used Account: 135-49900-000-000 Miscellaneous Income 301 11/20/2014 Bill Town Invoice 1232 AR 20141120-20141120 User: (24.16) (19,606.50) (19,630.66) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 330 11/30/2014 UB 11/30/14 Billing UB20141130-20141130 User: (24.16) (15.28) (19,645.94) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (19,621.78) (19,645.94) ** (54,000.00) Budgeted (34,354.06) Remaining 36 % Used Account: 135-49901-000-000 Records Management Revenue 366 11/14/2014 Open Records/Rose (2.00) (10.20) (12.20) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (10.20) (12.20) ** (100.00) Budgeted (87.80) Remaining 12 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,144,410.46) ** (8,444,333.00) Budgeted (7,299,922.54) Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 177 11/07/2014 MUD Payroll 11/7/14 Salaries & Wages 15,277.93 5,615.63 20,893.56 PR 283 11/21/2014 MUD Payroll 11/21/14 Salaries & Wages 5,913.53 26,807.09 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 11,529.16 26,807.09 ** 301,101.00 Budgeted 274,293.91 Remaining 9 % Used Account: 135-50010-010-000 Overtime 177 11/07/2014 MUD Payroll 11/7/14 Overtime 1,520.08 571.80 2,091.88 PR _______________ Account: 135-50010-010-000 Overtime Totals: 571.80 2,091.88 ** 19,500.00 Budgeted 17,408.12 Remaining 11 % Used Account: 135-50016-010-000 Longevity 299 11/26/2014 Longevity Check run Longevity 2,705.00 2,705.00 PR _______________ Account: 135-50016-010-000 Longevity Totals: 2,705.00 2,705.00 ** 5,343.00 Budgeted 2,638.00 Remaining 51 % Used Account: 135-50017-010-000 Certification 283 11/21/2014 MUD Payroll 11/21/14 Certification 400.00 150.00 550.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 550.00 ** 4,800.00 Budgeted 4,250.00 Remaining 11 % Used Account: 135-50020-010-000 Retirement 177 11/07/2014 MUD Payroll 11/7/14 Retirement 1,544.39 555.63 2,100.02 PR 283 11/21/2014 MUD Payroll 11/21/14 Retirement 544.50 2,644.52 PR 299 11/26/2014 Longevity Check run Retirement 242.91 2,887.43 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,343.04 2,887.43 ** 29,349.00 Budgeted 26,461.57 Remaining 10 % Used Account: 135-50026-010-000 Medical Insurance 177 11/07/2014 MUD Payroll 11/7/14 Medical Insurance 2,246.98 890.01 3,136.99 PR 283 11/21/2014 MUD Payroll 11/21/14 Medical Insurance 889.98 4,026.97 PR 406 11/30/2014 T Dendish/adj Ins for last pay (296.66) 3,730.31 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,483.33 3,730.31 ** 44,988.00 Budgeted 41,257.69 Remaining 8 % Used Account: 135-50027-010-000 Dental Insurance 177 11/07/2014 MUD Payroll 11/7/14 Dental Insurance 158.46 75.43 233.89 PR 283 11/21/2014 MUD Payroll 11/21/14 Dental Insurance 75.44 309.33 PR 406 11/30/2014 T Dendish/adj Ins for last pay (16.38) 292.95 GL _______________ Account: 135-50027-010-000 Dental Insurance Totals: 134.49 292.95 ** 3,288.00 Budgeted 2,995.05 Remaining 9 % Used Account: 135-50028-010-000 Vision Insurance 177 11/07/2014 MUD Payroll 11/7/14 Vision Insurance 40.02 17.93 57.95 PR 283 11/21/2014 MUD Payroll 11/21/14 Vision Insurance 17.95 75.90 PR 406 11/30/2014 T Dendish/adj Ins for last pay (4.53) 71.37 GL _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.35 71.37 ** 834.00 Budgeted 762.63 Remaining 9 % Used Account: 135-50029-010-000 Life Insurance & Other 96 11/01/2014 Nov A/P Nov Dental, Life, AD&D, Vol li 189.31 179.05 368.36 METLIFE GROUP BENEFITS 34296 AP 309 11/21/2014 Nov A/P Adm fees/CAFE 125 7.28 375.64 BenefitMall 34378 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 186.33 375.64 ** 3,074.00 Budgeted 2,698.36 Remaining 12 % Used Account: 135-50030-010-000 Social Security Taxes 177 11/07/2014 MUD Payroll 11/7/14 Social Security Taxes 1,055.35 384.88 1,440.23 PR 283 11/21/2014 MUD Payroll 11/21/14 Social Security Taxes 367.19 1,807.42 PR 299 11/26/2014 Longevity Check run Social Security Taxes 167.70 1,975.12 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 919.77 1,975.12 ** 21,135.00 Budgeted 19,159.88 Remaining 9 % Used Account: 135-50035-010-000 Medicare Taxes 177 11/07/2014 MUD Payroll 11/7/14 Medicare Taxes 246.82 90.01 336.83 PR 283 11/21/2014 MUD Payroll 11/21/14 Medicare Taxes 85.88 422.71 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 299 11/26/2014 Longevity Check run Medicare Taxes 246.82 39.22 461.93 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 215.11 461.93 ** 4,943.00 Budgeted 4,481.07 Remaining 9 % Used Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 1,242.00 Budgeted 1,242.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 192 11/01/2014 Nov TML Ins & Workers Comp 857.91 857.91 1,715.82 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.91 1,715.82 ** 16,020.00 Budgeted 14,304.18 Remaining 11 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 63.00 .00 63.00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 63.00 ** 1,000.00 Budgeted 937.00 Remaining 6 % Used Account: 135-50070-010-000 Employee Relations .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 309 11/21/2014 Nov A/P Transition Couplings 6,148.64 439.32 6,587.96 HD SUPPLY WATERWORKS, LTD. 34384 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 309 11/21/2014 Nov A/P Fire Hydrant parts 6,148.64 447.27 7,035.23 HD SUPPLY WATERWORKS, LTD. 34384 AP 362 11/27/2014 10/28-11/26/14 PCards FERGUSON ENTERPRISES 1 200.12 7,235.35 FERGUSON ENTERPRISES 1 PC 362 11/27/2014 10/28-11/26/14 PCards FERGUSON ENTERPRISES 1 509.40 7,744.75 FERGUSON ENTERPRISES 1 PC 362 11/27/2014 10/28-11/26/14 PCards THE HOME DEPOT 6581 70.26 7,815.01 THE HOME DEPOT 6581 PC 362 11/27/2014 10/28-11/26/14 PCards THE HOME DEPOT 6581 31.99 7,847.00 THE HOME DEPOT 6581 PC 362 11/27/2014 10/28-11/26/14 PCards THE HOME DEPOT 6581 19.97 7,866.97 THE HOME DEPOT 6581 PC 416 11/30/2014 Nov A/P Swivels for Port Meters 170.00 8,036.97 HD SUPPLY WATERWORKS, LTD. 34428 AP 416 11/30/2014 Nov A/P Iron Pipe 1,003.80 9,040.77 HD SUPPLY WATERWORKS, LTD. 34428 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,892.13 9,040.77 ** 71,242.00 Budgeted 62,201.23 Remaining 13 % Used Account: 135-55090-010-000 Vehicle Maintenance 362 11/27/2014 10/28-11/26/14 PCards KWIK KAR LUBE & TUNE O 1,771.93 39.75 1,811.68 KWIK KAR LUBE & TUNE O PC 362 11/27/2014 10/28-11/26/14 PCards DISCOUNT TIRE TXD 75 339.00 2,150.68 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 378.75 2,150.68 ** 8,000.00 Budgeted 5,849.32 Remaining 27 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 243.00 .00 243.00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 243.00 ** 3,500.00 Budgeted 3,257.00 Remaining 7 % Used Account: 135-55135-010-000 Lab Analysis 420.26 .00 420.26 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 420.26 ** 5,500.00 Budgeted 5,079.74 Remaining 8 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 309 11/21/2014 Nov A/P Verizon,GST, Symonds,Ganns 314.22 314.22 TOWN OF TROPHY CLUB 34406 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 314.22 314.22 ** 4,913.00 Budgeted 4,598.78 Remaining 6 % Used Account: 135-60020-010-000 Electricity . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 309 11/21/2014 Nov A/P Electricity 10/13-11/11/14 9,297.74 9,250.20 18,547.94 HUDSON ENERGY SERVICES, LLC 34385 AP 309 11/21/2014 Nov A/P Electricity 10/10-11/10/14 76.61 18,624.55 HUDSON ENERGY SERVICES, LLC 34385 AP 309 11/21/2014 Nov A/P Electricity 10/13-11/11/14 87.83 18,712.38 HUDSON ENERGY SERVICES, LLC 34385 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,414.64 18,712.38 ** 170,765.00 Budgeted 152,052.62 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 Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training .00 .00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 .00 ** 4,138.00 Budgeted 4,138.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,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 309 11/21/2014 Nov A/P Water System Fee 6,480.10 6,480.10 TX COMMISSION ENVIRONMENTAL QU 34408 AP 416 11/30/2014 Nov A/P Water System Fee 2,418.75 8,898.85 TX COMMISSION ENVIRONMENTAL QU 34451 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 8,898.85 8,898.85 ** 49,275.00 Budgeted 40,376.15 Remaining 18 % Used Account: 135-60150-010-000 Wholesale Water 416 11/30/2014 Nov A/P Wholesale Water 196,537.78 196,537.78 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 196,537.78 196,537.78 ** 2,928,308.00 Budgeted 2,731,770.22 Remaining 7 % 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 362 11/27/2014 10/28-11/26/14 PCards OK SOD INC 324.00 39.75 363.75 OK SOD INC PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 39.75 363.75 ** 3,500.00 Budgeted 3,136.25 Remaining 10 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 383 11/30/2014 Reverse Nov Gas Log JE364 1,526.07 (263.30) 1,262.77 GL 385 11/30/2014 Nov MUD Gas Log 560.63 1,823.40 GL 409 11/30/2014 MUD PPD Fuel write off/in tank 109.48 1,932.88 GL 409 11/30/2014 MUD PPD Fuel write off/in tank 205.71 2,138.59 GL 416 11/30/2014 Nov A/P November fuel 485.09 2,623.68 US Bank Voyager Fleet Systems 34452 AP 364 11/30/2014 Nov Gas Log 263.30 2,886.98 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,360.91 2,886.98 ** 29,172.00 Budgeted 26,285.02 Remaining 10 % Used Account: 135-65010-010-000 Uniforms 362 11/27/2014 10/28-11/26/14 PCards TRACTOR SUPPLY COMPANY 99.99 99.99 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-010-000 Uniforms Totals: 99.99 99.99 ** 3,620.00 Budgeted 3,520.01 Remaining 3 % Used Account: 135-65030-010-000 Chemicals 416 11/30/2014 Nov A/P Chlorine 1,576.30 624.53 2,200.83 DPC INDUSTRIES, INC 34425 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 624.53 2,200.83 ** 7,000.00 Budgeted 4,799.17 Remaining 31 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment 141.75 .00 141.75 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 141.75 ** 1,000.00 Budgeted 858.25 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense 309 11/21/2014 Nov A/P Meters & Meter heads 11,305.00 11,305.00 ATLAS UTILITY SUPPLY CO. 34375 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 11,305.00 11,305.00 ** 161,500.00 Budgeted 150,195.00 Remaining 7 % Used Account: 135-69005-010-000 Capital Outlays 309 11/21/2014 Nov A/P Elevated tank valve repair 21,505.44 21,505.44 REY-MAR CONSTRUCTION 34401 AP 416 11/30/2014 Nov A/P Elev Tank/Valve Repair 1,874.03 23,379.47 HD SUPPLY WATERWORKS, LTD. 34428 AP 416 11/30/2014 Nov A/P Elev Tank/Valve repair 2,627.59 26,007.06 HD SUPPLY WATERWORKS, LTD. 34428 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 26,007.06 26,007.06 ** 1,089,006.00 Budgeted 1,062,998.94 Remaining 2 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 129,000.00 Budgeted 129,000.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 ** 3,612.00 Budgeted 3,612.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 309 11/21/2014 Nov A/P 400,000 TWKing Tank-Annual 35,211.69 35,211.69 UTILITY SERVICE CO, INC. 34411 AP 309 11/21/2014 Nov A/P Water Plant Tank#2 West - Annu 45,775.00 80,986.69 UTILITY SERVICE CO, INC. 34411 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 80,986.69 80,986.69 ** 151,507.00 Budgeted 70,520.31 Remaining 53 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 1,777.63 .00 1,777.63 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 1,777.63 ** 5,000.00 Budgeted 3,222.37 Remaining 36 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 480,815.16 ** 5,386,025.00 Budgeted 4,905,209.84 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 177 11/07/2014 MUD Payroll 11/7/14 Salaries & Wages 14,791.74 11,403.43 26,195.17 PR 283 11/21/2014 MUD Payroll 11/21/14 Salaries & Wages 11,693.60 37,888.77 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 23,097.03 37,888.77 ** 305,744.00 Budgeted 267,855.23 Remaining 12 % Used Account: 135-50010-020-000 Overtime 177 11/07/2014 MUD Payroll 11/7/14 Overtime 1,006.68 1,938.92 2,945.60 PR 283 11/21/2014 MUD Payroll 11/21/14 Overtime 1,035.62 3,981.22 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,974.54 3,981.22 ** 19,500.00 Budgeted 15,518.78 Remaining 20 % Used Account: 135-50016-020-000 Longevity 299 11/26/2014 Longevity Check run Longevity 5,615.00 5,615.00 PR _______________ Account: 135-50016-020-000 Longevity Totals: 5,615.00 5,615.00 ** 5,617.00 Budgeted 2.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 283 11/21/2014 MUD Payroll 11/21/14 Certification 550.00 550.00 1,100.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 1,100.00 ** 6,600.00 Budgeted 5,500.00 Remaining 17 % Used Account: 135-50020-020-000 Retirement 177 11/07/2014 MUD Payroll 11/7/14 Retirement 1,468.07 1,198.14 2,666.21 PR 283 11/21/2014 MUD Payroll 11/21/14 Retirement 1,192.47 3,858.68 PR 299 11/26/2014 Longevity Check run Retirement 504.24 4,362.92 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,894.85 4,362.92 ** 29,948.00 Budgeted 25,585.08 Remaining 15 % Used Account: 135-50026-020-000 Medical Insurance 177 11/07/2014 MUD Payroll 11/7/14 Medical Insurance 3,177.49 2,450.25 5,627.74 PR 283 11/21/2014 MUD Payroll 11/21/14 Medical Insurance 2,450.21 8,077.95 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,900.46 8,077.95 ** 61,001.00 Budgeted 52,923.05 Remaining 13 % Used Account: 135-50027-020-000 Dental Insurance 177 11/07/2014 MUD Payroll 11/7/14 Dental Insurance 203.52 156.98 360.50 PR 283 11/21/2014 MUD Payroll 11/21/14 Dental Insurance 157.00 517.50 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 313.98 517.50 ** 4,146.00 Budgeted 3,628.50 Remaining 12 % Used Account: 135-50028-020-000 Vision Insurance 177 11/07/2014 MUD Payroll 11/7/14 Vision Insurance 48.57 37.45 86.02 PR 283 11/21/2014 MUD Payroll 11/21/14 Vision Insurance 37.49 123.51 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 74.94 123.51 ** 990.00 Budgeted 866.49 Remaining 12 % Used Account: 135-50029-020-000 Life Insurance & Other 96 11/01/2014 Nov A/P Nov Dental, Life, AD&D, Vol li 262.04 236.60 498.64 METLIFE GROUP BENEFITS 34296 AP 309 11/21/2014 Nov A/P Adm fees/CAFE 125 36.36 535.00 BenefitMall 34378 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 272.96 535.00 ** 3,194.00 Budgeted 2,659.00 Remaining 17 % Used Account: 135-50030-020-000 Social Security Taxes 177 11/07/2014 MUD Payroll 11/7/14 Social Security Taxes 878.03 735.96 1,613.99 PR 283 11/21/2014 MUD Payroll 11/21/14 Social Security Taxes 720.09 2,334.08 PR 299 11/26/2014 Longevity Check run Social Security Taxes 348.13 2,682.21 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,804.18 2,682.21 ** 21,680.00 Budgeted 18,997.79 Remaining 12 % Used Account: 135-50035-020-000 Medicare Taxes 177 11/07/2014 MUD Payroll 11/7/14 Medicare Taxes 205.35 172.10 377.45 PR 283 11/21/2014 MUD Payroll 11/21/14 Medicare Taxes 168.41 545.86 PR 299 11/26/2014 Longevity Check run Medicare Taxes 81.42 627.28 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 421.93 627.28 ** 5,070.00 Budgeted 4,442.72 Remaining 12 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,242.00 Budgeted 1,242.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 192 11/01/2014 Nov TML Ins & Workers Comp 857.91 857.91 1,715.82 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.91 1,715.82 ** 16,020.00 Budgeted 14,304.18 Remaining 11 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations 362 11/27/2014 10/28-11/26/14 PCards WHATABURGER 754 Q26 48.87 48.87 WHATABURGER 754 Q26 PC 362 11/27/2014 10/28-11/26/14 PCards SALAD BOWL 10 54.00 102.87 SALAD BOWL 10 PC 362 11/27/2014 10/28-11/26/14 PCards WHATABURGER 754 Q26 39.10 141.97 WHATABURGER 754 Q26 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 141.97 141.97 ** 550.00 Budgeted 408.03 Remaining 26 % Used Account: 135-55080-020-000 Maintenance & Repairs 260 11/11/2014 Nov A/P Sewer Force Main repair 1,769.00 15,712.39 17,481.39 REY-MAR CONSTRUCTION 34372 AP 309 11/21/2014 Nov A/P Put Lift Sta 7 into Scada syst 355.00 17,836.39 DHS AUTOMATION, INC 34381 AP 309 11/21/2014 Nov A/P troubleshoot Heating/AC unit 112.00 17,948.39 NORTH TX HEATING & AIR, INC 34396 AP 362 11/27/2014 10/28-11/26/14 PCards THE HOME DEPOT 6581 280.17 18,228.56 THE HOME DEPOT 6581 PC 362 11/27/2014 10/28-11/26/14 PCards USA BLUE BOOK 42.47 18,271.03 USA BLUE BOOK PC 362 11/27/2014 10/28-11/26/14 PCards THE HOME DEPOT 6581 6.38 18,277.41 THE HOME DEPOT 6581 PC 362 11/27/2014 10/28-11/26/14 PCards FASTENAL COMPANY01 209.95 18,487.36 FASTENAL COMPANY01 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 416 11/30/2014 Nov A/P Install French pit for the con 1,769.00 612.35 19,099.71 NORTH TX HEATING & AIR, INC 34439 AP 416 11/30/2014 Nov A/P Install new A/C unit with air 10,355.00 29,454.71 NORTH TX HEATING & AIR, INC 34439 AP 416 11/30/2014 Nov A/P Auto Gate repair 248.00 29,702.71 CRITICAL ELECTRIC SYSTEMS 34423 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 27,933.71 29,702.71 ** 58,000.00 Budgeted 28,297.29 Remaining 51 % Used Account: 135-55090-020-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 7.29 .00 7.29 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 7.29 ** 500.00 Budgeted 492.71 Remaining 1 % Used Account: 135-55125-020-000 Dumpster Services 309 11/21/2014 Nov A/P Sludge Haul off 1,838.97 3,898.63 5,737.60 L.H. CHANEY MATERIALS, INC. 34389 AP 309 11/21/2014 Nov A/P Sludge Haul off 1,932.50 7,670.10 L.H. CHANEY MATERIALS, INC. 34389 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 5,831.13 7,670.10 ** 55,000.00 Budgeted 47,329.90 Remaining 14 % Used Account: 135-55135-020-000 Lab Analysis 309 11/21/2014 Nov A/P Testing 668.00 590.00 1,258.00 HUTHER AND ASSOCIATES,INC 34386 AP 309 11/21/2014 Nov A/P Testing 176.00 1,434.00 OXIDOR LABORATORIES LLC 34398 AP 309 11/21/2014 Nov A/P Testing 55.00 1,489.00 OXIDOR LABORATORIES LLC 34398 AP 309 11/21/2014 Nov A/P Testing 246.00 1,735.00 OXIDOR LABORATORIES LLC 34398 AP 309 11/21/2014 Nov A/P Testing 176.00 1,911.00 OXIDOR LABORATORIES LLC 34398 AP 309 11/21/2014 Nov A/P Testing 246.00 2,157.00 OXIDOR LABORATORIES LLC 34398 AP 309 11/21/2014 Nov A/P Testing 176.00 2,333.00 OXIDOR LABORATORIES LLC 34398 AP 309 11/21/2014 Nov A/P Testing 246.00 2,579.00 OXIDOR LABORATORIES LLC 34398 AP 309 11/21/2014 Nov A/P Testing 176.00 2,755.00 OXIDOR LABORATORIES LLC 34398 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,087.00 2,755.00 ** 25,000.00 Budgeted 22,245.00 Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-020-000 Communications/Pagers/Mobiles 309 11/21/2014 Nov A/P Verizon,GST, Symonds,Ganns 405.52 405.52 TOWN OF TROPHY CLUB 34406 AP 362 11/27/2014 10/28-11/26/14 PCards AMAZON DIGITAL SERVICE 5.40 410.92 AMAZON DIGITAL SERVICE PC _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 410.92 410.92 ** 4,662.00 Budgeted 4,251.08 Remaining 9 % Used Account: 135-60020-020-000 Electricity 309 11/21/2014 Nov A/P Electricity 9/30-10/28/14 4,736.35 294.22 5,030.57 TRI COUNTY ELECTRIC 34407 AP 309 11/21/2014 Nov A/P Electricity 9/30-10/28/14 157.10 5,187.67 TRI COUNTY ELECTRIC 34407 AP 309 11/21/2014 Nov A/P Electricity 9/30-/10/28/14 27.94 5,215.61 TRI COUNTY ELECTRIC 34407 AP 309 11/21/2014 Nov A/P Electricity 10/13-11/11/14 639.70 5,855.31 HUDSON ENERGY SERVICES, LLC 34385 AP 309 11/21/2014 Nov A/P Electricity 10/13-11/11/14 10,774.34 16,629.65 HUDSON ENERGY SERVICES, LLC 34385 AP 309 11/21/2014 Nov A/P Electricity 10/11-11/11 66.66 16,696.31 HUDSON ENERGY SERVICES, LLC 34385 AP 309 11/21/2014 Nov A/P Electricity 10/10-11/10/14 40.26 16,736.57 HUDSON ENERGY SERVICES, LLC 34385 AP 309 11/21/2014 Nov A/P Electricity 10/13/14-11/11/14 80.42 16,816.99 HUDSON ENERGY SERVICES, LLC 34385 AP 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (124.36) 16,692.63 AR _______________ Account: 135-60020-020-000 Electricity Totals: 11,956.28 16,692.63 ** 149,292.00 Budgeted 132,599.37 Remaining 11 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 54.95 .00 54.95 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 54.95 ** 400.00 Budgeted 345.05 Remaining 14 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 362 11/27/2014 10/28-11/26/14 PCards NCTCOG RTC TRAINING 111.00 240.00 351.00 NCTCOG RTC TRAINING PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 240.00 351.00 ** 4,065.00 Budgeted 3,714.00 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 177 11/07/2014 MUD Payroll 11/7/14 Travel & per diem 87.36 87.36 PR 416 11/30/2014 Nov A/P Toll to pick up Fuel tank/trai 4.94 92.30 NTTA 34440 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 92.30 92.30 ** 1,600.00 Budgeted 1,507.70 Remaining 6 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 8,919.00 .00 8,919.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 8,919.00 ** 17,150.00 Budgeted 8,231.00 Remaining 52 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 300.00 Budgeted 300.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-65005-020-000 Fuel & Lube . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 362 11/27/2014 10/28-11/26/14 PCards TRACTOR SUPPLY COMPANY 2,849.07 85.97 2,935.04 TRACTOR SUPPLY COMPANY PC 362 11/27/2014 10/28-11/26/14 PCards TRACTOR SUPPLY COMPANY (11.00) 2,924.04 TRACTOR SUPPLY COMPANY PC 383 11/30/2014 Reverse Nov Gas Log JE364 (117.73) 2,806.31 GL 385 11/30/2014 Nov MUD Gas Log 447.05 3,253.36 GL 409 11/30/2014 MUD PPD Fuel write off/in tank 109.48 3,362.84 GL 409 11/30/2014 MUD PPD Fuel write off/in tank 205.70 3,568.54 GL 416 11/30/2014 Nov A/P November fuel 635.53 4,204.07 US Bank Voyager Fleet Systems 34452 AP 364 11/30/2014 Nov Gas Log 117.73 4,321.80 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,472.73 4,321.80 ** 36,328.00 Budgeted 32,006.20 Remaining 12 % Used Account: 135-65010-020-000 Uniforms 309 11/21/2014 Nov A/P Uniform shirts 1,394.67 783.50 2,178.17 PANDA EMBROIDERY 34399 AP 362 11/27/2014 10/28-11/26/14 PCards JUSTIN DISCOUNT BOOTS 73.80 2,251.97 JUSTIN DISCOUNT BOOTS PC 362 11/27/2014 10/28-11/26/14 PCards ROANOKE QUICK STOP 114.00 2,365.97 ROANOKE QUICK STOP PC _______________ Account: 135-65010-020-000 Uniforms Totals: 971.30 2,365.97 ** 2,778.00 Budgeted 412.03 Remaining 85 % Used Account: 135-65030-020-000 Chemicals 309 11/21/2014 Nov A/P Chemicals 777.44 777.44 United Laboratories 34410 AP 362 11/27/2014 10/28-11/26/14 PCards AQUAFIX INC. 691.08 1,468.52 AQUAFIX INC. PC _______________ Account: 135-65030-020-000 Chemicals Totals: 1,468.52 1,468.52 ** 30,000.00 Budgeted 28,531.48 Remaining 5 % Used Account: 135-65035-020-000 Small Tools 362 11/27/2014 10/28-11/26/14 PCards BLACK & DECKER SRV #11 299.51 34.85 334.36 BLACK & DECKER SRV #11 PC 362 11/27/2014 10/28-11/26/14 PCards THE HOME DEPOT 6581 123.97 458.33 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 158.82 458.33 ** 2,000.00 Budgeted 1,541.67 Remaining 23 % Used Account: 135-65040-020-000 Safety Equipment 323 11/25/2014 Recode Lou's Gloves per Jennif 162.00 162.00 GL _______________ Account: 135-65040-020-000 Safety Equipment Totals: 162.00 162.00 ** 750.00 Budgeted 588.00 Remaining 22 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65045-020-000 Lab Supplies 309 11/21/2014 Nov A/P Gloves 5,102.81 162.00 5,264.81 LOU'S GLOVES INCORPORATED 34391 AP 323 11/25/2014 Recode Lou's Gloves per Jennif (162.00) 5,102.81 GL _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 5,102.81 ** 13,000.00 Budgeted 7,897.19 Remaining 39 % Used Account: 135-69005-020-000 Capital Outlays 416 11/30/2014 Nov A/P Crane Truck 73,640.00 73,640.00 RELIABLE CHEVROLET 34441 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 73,640.00 73,640.00 ** 150,000.00 Budgeted 76,360.00 Remaining 49 % Used Account: 135-69007-020-000 LTD Payment from WW Sales .00 .00 _______________ Account: 135-69007-020-000 LTD Payment from WW Sales Totals: .00 .00 ** 357,538.00 Budgeted 357,538.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 ** 56,991.00 Budgeted 56,991.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 ** 2,011.00 Budgeted 2,011.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 221,544.48 ** 1,462,117.00 Budgeted 1,240,572.52 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 177 11/07/2014 MUD Payroll 11/7/14 Salaries & Wages 500.00 500.00 PR 283 11/21/2014 MUD Payroll 11/21/14 Salaries & Wages 1,000.00 1,500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,500.00 1,500.00 ** 10,000.00 Budgeted 8,500.00 Remaining 15 % Used Account: 135-50030-026-000 Social Security Taxes 177 11/07/2014 MUD Payroll 11/7/14 Social Security Taxes 31.00 31.00 PR 283 11/21/2014 MUD Payroll 11/21/14 Social Security Taxes 62.00 93.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 93.00 93.00 ** 620.00 Budgeted 527.00 Remaining 15 % Used Account: 135-50035-026-000 Medicare Taxes 177 11/07/2014 MUD Payroll 11/7/14 Medicare Taxes 7.25 7.25 PR 283 11/21/2014 MUD Payroll 11/21/14 Medicare Taxes 14.50 21.75 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 21.75 21.75 ** 145.00 Budgeted 123.25 Remaining 15 % Used Account: 135-50040-026-000 Unemployment Taxes 177 11/07/2014 MUD Payroll 11/7/14 Unemployment Taxes 11.50 11.50 PR 283 11/21/2014 MUD Payroll 11/21/14 Unemployment Taxes 23.00 34.50 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 34.50 34.50 ** 230.00 Budgeted 195.50 Remaining 15 % Used Account: 135-50045-026-000 Workman's Compensation 192 11/01/2014 Nov TML Ins & Workers Comp 2.94 2.94 5.88 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 5.88 ** 36.00 Budgeted 30.12 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships 309 11/21/2014 Nov A/P Annual Adm fee/Tx SS Program 35.00 35.00 TX SOCIAL SECURITY PROGRAM 34409 AP _______________ Account: 135-60070-026-000 Dues & Memberships Totals: 35.00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 416 11/30/2014 Nov A/P Costco Membership, purchases 27.96 27.96 COSTCO WHOLESALE 34421 AP _______________ Account: 135-60075-026-000 Meetings Totals: 27.96 27.96 ** 1,200.00 Budgeted 1,172.04 Remaining 2 % Used Account: 135-60080-026-000 Schools & Training 416 11/30/2014 Nov A/P Mid Winter Conf/Carr 325.00 325.00 AWBD 34415 AP 416 11/30/2014 Nov A/P Mid Winter Conf/Hase 325.00 650.00 AWBD 34415 AP 416 11/30/2014 Nov A/P Mid Winter Conf/Twomey 325.00 975.00 AWBD 34415 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 975.00 975.00 ** 4,000.00 Budgeted 3,025.00 Remaining 24 % 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 362 11/27/2014 10/28-11/26/14 PCards KELLER TROPHY AND AWAR 50.00 50.00 KELLER TROPHY AND AWAR PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 50.00 50.00 ** 1,000.00 Budgeted 950.00 Remaining 5 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 2,743.09 ** 22,881.00 Budgeted 20,137.91 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 177 11/07/2014 MUD Payroll 11/7/14 Salaries & Wages 22,907.31 17,618.08 40,525.39 PR 283 11/21/2014 MUD Payroll 11/21/14 Salaries & Wages 17,615.73 58,141.12 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,233.81 58,141.12 ** 477,578.00 Budgeted 419,436.88 Remaining 12 % Used Account: 135-50010-030-000 Overtime 177 11/07/2014 MUD Payroll 11/7/14 Overtime 6.98 26.06 33.04 PR 283 11/21/2014 MUD Payroll 11/21/14 Overtime 2.07 35.11 PR _______________ Account: 135-50010-030-000 Overtime Totals: 28.13 35.11 ** 1,000.00 Budgeted 964.89 Remaining 4 % Used Account: 135-50016-030-000 Longevity 299 11/26/2014 Longevity Check run Longevity 3,282.50 3,282.50 PR _______________ Account: 135-50016-030-000 Longevity Totals: 3,282.50 3,282.50 ** 3,283.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 177 11/07/2014 MUD Payroll 11/7/14 Retirement 2,057.71 1,584.45 3,642.16 PR 283 11/21/2014 MUD Payroll 11/21/14 Retirement 1,582.08 5,224.24 PR 299 11/26/2014 Longevity Check run Retirement 294.77 5,519.01 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,461.30 5,519.01 ** 42,840.00 Budgeted 37,320.99 Remaining 13 % Used Account: 135-50026-030-000 Medical Insurance 177 11/07/2014 MUD Payroll 11/7/14 Medical Insurance 3,328.88 2,402.43 5,731.31 PR 283 11/21/2014 MUD Payroll 11/21/14 Medical Insurance 2,402.38 8,133.69 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,804.81 8,133.69 ** 65,015.00 Budgeted 56,881.31 Remaining 13 % Used Account: 135-50027-030-000 Dental Insurance 177 11/07/2014 MUD Payroll 11/7/14 Dental Insurance 232.72 170.19 402.91 PR 283 11/21/2014 MUD Payroll 11/21/14 Dental Insurance 170.23 573.14 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 340.42 573.14 ** 4,944.00 Budgeted 4,370.86 Remaining 12 % Used Account: 135-50028-030-000 Vision Insurance 177 11/07/2014 MUD Payroll 11/7/14 Vision Insurance 56.21 40.78 96.99 PR 283 11/21/2014 MUD Payroll 11/21/14 Vision Insurance 40.84 137.83 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.62 137.83 ** 1,158.00 Budgeted 1,020.17 Remaining 12 % Used Account: 135-50029-030-000 Life Insurance & Other 96 11/01/2014 Nov A/P Nov Dental, Life, AD&D, Vol li 324.70 338.13 662.83 METLIFE GROUP BENEFITS 34296 AP 309 11/21/2014 Nov A/P Adm fees/CAFE 125 36.36 699.19 BenefitMall 34378 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 374.49 699.19 ** 4,333.00 Budgeted 3,633.81 Remaining 16 % Used Account: 135-50030-030-000 Social Security Taxes 177 11/07/2014 MUD Payroll 11/7/14 Social Security Taxes 1,337.80 1,038.62 2,376.42 PR 283 11/21/2014 MUD Payroll 11/21/14 Social Security Taxes 1,026.24 3,402.66 PR 299 11/26/2014 Longevity Check run Social Security Taxes 203.51 3,606.17 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,268.37 3,606.17 ** 30,079.00 Budgeted 26,472.83 Remaining 12 % Used Account: 135-50035-030-000 Medicare Taxes 177 11/07/2014 MUD Payroll 11/7/14 Medicare Taxes 312.87 242.89 555.76 PR 283 11/21/2014 MUD Payroll 11/21/14 Medicare Taxes 240.02 795.78 PR 299 11/26/2014 Longevity Check run Medicare Taxes 47.60 843.38 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 530.51 843.38 ** 7,422.00 Budgeted 6,578.62 Remaining 11 % Used Account: 135-50040-030-000 Unemployment Taxes 177 11/07/2014 MUD Payroll 11/7/14 Unemployment Taxes 31.15 24.08 55.23 PR 283 11/21/2014 MUD Payroll 11/21/14 Unemployment Taxes 23.92 79.15 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 48.00 79.15 ** 1,449.00 Budgeted 1,369.85 Remaining 5 % Used Account: 135-50045-030-000 Workman's Compensation 192 11/01/2014 Nov TML Ins & Workers Comp 87.30 87.30 174.60 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 174.60 ** 1,636.00 Budgeted 1,461.40 Remaining 11 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 38.00 .00 38.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 500.00 Budgeted 462.00 Remaining 8 % Used Account: 135-50070-030-000 Employee Relations 362 11/27/2014 10/28-11/26/14 PCards ROANOKE FLORIST 635.98 76.32 712.30 ROANOKE FLORIST PC 362 11/27/2014 10/28-11/26/14 PCards RANDALLS STORE00017897 26.72 739.02 RANDALLS STORE00017897 PC 362 11/27/2014 10/28-11/26/14 PCards WM SUPERCENTER #5247 6.68 745.70 WM SUPERCENTER #5247 PC 368 11/30/2014 Flu Shots Sold (140.00) 605.70 GL _______________ Account: 135-50070-030-000 Employee Relations Totals: (30.28) 605.70 ** 5,000.00 Budgeted 4,394.30 Remaining 12 % Used Account: 135-55030-030-000 Software & Support 258 11/10/2014 Nov A/P Nov Vital Care 19,332.63 4,100.00 23,432.63 M3 Networks 34370 AP 289 11/18/2014 Nov A/P Server Upgrade 2,500.00 25,932.63 STW INC 34373 AP 293 11/18/2014 Correct Coding M3 Oct Invoices (3,077.84) 22,854.79 GL 362 11/27/2014 10/28-11/26/14 PCards ATT*BILL PAYMENT 70.81 22,925.60 ATT*BILL PAYMENT PC 416 11/30/2014 Nov A/P Vital Care/IT Services 4,100.00 27,025.60 M3 Networks 34437 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 7,692.97 27,025.60 ** 75,588.00 Budgeted 48,562.40 Remaining 36 % Used Account: 135-55070-030-000 Independent Labor 289 11/18/2014 Nov A/P Server Upgrade 60.00 5,520.00 5,580.00 STW INC 34373 AP 309 11/21/2014 Nov A/P Record MUD meeting 30.00 5,610.00 MIGUEL CRUZ 34394 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 309 11/21/2014 Nov A/P Record MUD Meeting 60.00 33.75 5,643.75 MIGUEL CRUZ 34394 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 5,583.75 5,643.75 ** 8,000.00 Budgeted 2,356.25 Remaining 71 % Used Account: 135-55080-030-000 Maintenance & Repairs .00 .00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 .00 ** 4,500.00 Budgeted 4,500.00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 309 11/21/2014 Nov A/P Electrical work in server room 773.73 835.69 1,609.42 M3 Networks 34392 AP 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (190.84) 1,418.58 AR 416 11/30/2014 Nov A/P Rug Service 95.42 1,514.00 G & K SERVICES 34426 AP 416 11/30/2014 Nov A/P Rug Service 95.42 1,609.42 G & K SERVICES 34426 AP 416 11/30/2014 Nov A/P Rug Service 95.42 1,704.84 G & K SERVICES 34426 AP 416 11/30/2014 Nov A/P Rug Service 95.42 1,800.26 G & K SERVICES 34426 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 1,026.53 1,800.26 ** 6,500.00 Budgeted 4,699.74 Remaining 28 % Used Account: 135-55120-030-000 Cleaning Services 309 11/21/2014 Nov A/P October Janitorial service 627.53 627.53 MEMBER'S BUILDING MAINTENANCE 34393 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 627.53 627.53 ** 8,100.00 Budgeted 7,472.47 Remaining 8 % Used Account: 135-55160-030-000 Professional Outside Services 293 11/18/2014 Correct Coding M3 Oct Invoices 24,677.95 12,400.00 37,077.95 GL _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 12,400.00 37,077.95 ** 58,000.00 Budgeted 20,922.05 Remaining 64 % Used Account: 135-55161-030-000 Town Personnel Contract 309 11/21/2014 Nov A/P Oct 2014-Jan 2015, IT 20,000.00 20,000.00 TOWN OF TROPHY CLUB 34406 AP _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: 20,000.00 20,000.00 ** 6,170.00 Budgeted (13,830.00) Remaining 324 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-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 584.60 .00 584.60 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 584.60 ** 8,200.00 Budgeted 7,615.40 Remaining 7 % Used Account: 135-60005-030-000 Telephone 255 11/10/2014 Nov A/P Nov Answering Service 195.00 195.00 390.00 KEYSTONE PARK SECRETARIAL 34352 AP _______________ Account: 135-60005-030-000 Telephone Totals: 195.00 390.00 ** 13,361.00 Budgeted 12,971.00 Remaining 3 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 283 11/21/2014 MUD Payroll 11/21/14 Communications/Pagers/Mobiles 300.00 300.00 600.00 PR 309 11/21/2014 Nov A/P Verizon,GST, Symonds,Ganns 37.99 637.99 TOWN OF TROPHY CLUB 34406 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 337.99 637.99 ** 4,056.00 Budgeted 3,418.01 Remaining 16 % Used Account: 135-60020-030-000 Electricity/Gas 292 11/18/2014 Nov A/P Electricity 10/1-10/13/14 MUD 341.45 341.45 TOWN OF TROPHY CLUB 34406 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 341.45 341.45 ** 14,978.00 Budgeted 14,636.55 Remaining 2 % Used Account: 135-60025-030-000 Water 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: 91.81 (85.64) 6.17 AR 416 11/30/2014 Nov A/P Nov Water 171.29 177.46 TROPHY CLUB MUD (WATER BILLS) 34450 AP _______________ Account: 135-60025-030-000 Water Totals: 85.65 177.46 ** 1,500.00 Budgeted 1,322.54 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60035-030-000 Postage 362 11/27/2014 10/28-11/26/14 PCards USPS 48764506630613152 2,439.31 6.49 2,445.80 USPS 48764506630613152 PC 362 11/27/2014 10/28-11/26/14 PCards USPS 48764506630613152 12.65 2,458.45 USPS 48764506630613152 PC 357 11/30/2014 Nov MUD Postage meter usage 159.47 2,617.92 GL _______________ Account: 135-60035-030-000 Postage Totals: 178.61 2,617.92 ** 28,500.00 Budgeted 25,882.08 Remaining 9 % Used Account: 135-60040-030-000 Service Charges & Fees 412 11/04/2014 Credit Card fees/Oct 40.00 109.75 149.75 GL 412 11/04/2014 Credit Card fees/Oct 141.82 291.57 GL 412 11/04/2014 Credit Card fees/Oct 4,565.27 4,856.84 GL 397 11/12/2014 Bank Analysis Fee- Oct 250.00 5,106.84 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,066.84 5,106.84 ** 32,000.00 Budgeted 26,893.16 Remaining 16 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 6,200.00 Budgeted 6,200.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 192 11/01/2014 Nov TML Ins & Workers Comp 4,063.01 4,063.01 8,126.02 GL 309 11/21/2014 Nov A/P Blanket Notary Errors and Omis 33.25 8,159.27 CNA SURETY 34379 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,096.26 8,159.27 ** 48,751.00 Budgeted 40,591.73 Remaining 17 % 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 309 11/21/2014 Nov A/P Membership dues 100.00 100.00 N CENTRAL TX COG 34395 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 309 11/21/2014 Nov A/P Annual Membership dues 565.00 665.00 AWBD 34377 AP 416 11/30/2014 Nov A/P Costco Membership, purchases 110.00 775.00 COSTCO WHOLESALE 34421 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 775.00 775.00 ** 5,000.00 Budgeted 4,225.00 Remaining 16 % Used Account: 135-60075-030-000 Meetings 25.11 .00 25.11 _______________ Account: 135-60075-030-000 Meetings Totals: .00 25.11 ** 400.00 Budgeted 374.89 Remaining 6 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 70.00 .00 70.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 70.00 ** 10,235.00 Budgeted 10,165.00 Remaining 1 % Used Account: 135-60100-030-000 Travel & per diem 177 11/07/2014 MUD Payroll 11/7/14 Travel & per diem 90.11 37.52 127.63 PR 283 11/21/2014 MUD Payroll 11/21/14 Travel & per diem 35.17 162.80 PR 328 11/26/2014 Nov A/P Mileage reimbursement 39.07 201.87 LAURIE SLAGHT 34413 AP 362 11/27/2014 10/28-11/26/14 PCards ABM PARKING 700 LAVACA 18.00 219.87 ABM PARKING 700 LAVACA PC 362 11/27/2014 10/28-11/26/14 PCards STARBUCKS #02832 HILLS 1.89 221.76 STARBUCKS #02832 HILLS PC 362 11/27/2014 10/28-11/26/14 PCards STARBUCKS #14860 GEORG 1.89 223.65 STARBUCKS #14860 GEORG PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 133.54 223.65 ** 5,400.00 Budgeted 5,176.35 Remaining 4 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.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 209 11/06/2014 Nov A/P 250 Gal Fuel trailer with fuel 3,219.65 3,219.65 380 TRAILER SALES & RENTAL 34337 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 3,219.65 3,219.65 ** 17,500.00 Budgeted 14,280.35 Remaining 18 % 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,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 309 11/21/2014 Nov A/P TV for boardroom 4,373.16 1,325.60 5,698.76 PREMIER AUDIO & VIDEO LLC 34400 AP 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (662.80) 5,035.96 AR _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 662.80 5,035.96 ** 10,475.00 Budgeted 5,439.04 Remaining 48 % Used Account: 135-65010-030-000 Uniforms 362 11/27/2014 10/28-11/26/14 PCards PANDA EMBROIDERY 943.00 943.00 PANDA EMBROIDERY PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-030-000 Uniforms Totals: 943.00 943.00 ** 1,855.00 Budgeted 912.00 Remaining 51 % Used Account: 135-65055-030-000 Hardware 293 11/18/2014 Correct Coding M3 Oct Invoices 82,651.57 (9,322.16) 73,329.41 GL _______________ Account: 135-65055-030-000 Hardware Totals: (9,322.16) 73,329.41 ** 75,966.00 Budgeted 2,636.59 Remaining 97 % Used Account: 135-65085-030-000 Office Supplies 309 11/21/2014 Nov A/P Office supplies 573.19 144.78 717.97 OFFICE DEPOT, INC 34397 AP 309 11/21/2014 Nov A/P Office Supplies 35.09 753.06 OFFICE DEPOT, INC 34397 AP 362 11/27/2014 10/28-11/26/14 PCards KELLER TROPHY AND AWAR 7.50 760.56 KELLER TROPHY AND AWAR PC 362 11/27/2014 10/28-11/26/14 PCards I BUY OFFICE SUPPY.COM 226.90 987.46 I BUY OFFICE SUPPY.COM PC 405 11/30/2014 Bill Town Inv 1233-1241 AR 20141130-20141130 User: (30.44) 957.02 AR 416 11/30/2014 Nov A/P Business Cards/McMahon 60.00 1,017.02 SIGMA SIGNS & PRINTING 34444 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 443.83 1,017.02 ** 9,000.00 Budgeted 7,982.98 Remaining 11 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 52.10 .00 52.10 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 52.10 ** 4,732.00 Budgeted 4,679.90 Remaining 1 % Used Account: 135-65095-030-000 Maintenance Supplies 362 11/27/2014 10/28-11/26/14 PCards SAMSCLUB #4795 269.93 118.05 387.98 SAMSCLUB #4795 PC 362 11/27/2014 10/28-11/26/14 PCards THE HOME DEPOT #6840 143.76 531.74 THE HOME DEPOT #6840 PC 362 11/27/2014 10/28-11/26/14 PCards THE HOME DEPOT 6581 169.67 701.41 THE HOME DEPOT 6581 PC 362 11/27/2014 10/28-11/26/14 PCards SAMSCLUB #4795 153.37 854.78 SAMSCLUB #4795 PC 416 11/30/2014 Nov A/P Costco Membership, purchases 59.97 914.75 COSTCO WHOLESALE 34421 AP 416 11/30/2014 Nov A/P Costco Membership, purchases 12.99 927.74 COSTCO WHOLESALE 34421 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 657.81 927.74 ** 5,000.00 Budgeted 4,072.26 Remaining 19 % Used Account: 135-65097-030-000 Vending Machine Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays .00 .00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** 125,000.00 Budgeted 125,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 40.79 .00 40.79 _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: .00 40.79 ** 4,236.00 Budgeted 4,195.21 Remaining 1 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 .00 16,329.00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 16,329.00 ** 16,329.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 294,047.64 ** 1,287,019.00 Budgeted 992,971.36 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 404 11/30/2014 Reclassify Legal Reclassify Legal 182,288.44 182,288.44 GL _______________ Account: 135-55045-039-000 Legal Totals: 182,288.44 182,288.44 ** 250,000.00 Budgeted 67,711.56 Remaining 73 % Used Account: 135-55055-039-000 Auditing .00 .00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 .00 ** 22,491.00 Budgeted 22,491.00 Remaining 0 % Used Account: 135-55060-039-000 Appraisal 309 11/21/2014 Nov A/P TAD Budget allocations FY2015 2,276.56 2,276.56 TARRANT APPRAISAL DISTRICT 34403 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,276.56 2,276.56 ** 10,000.00 Budgeted 7,723.44 Remaining 23 % 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 Account: 135-55045-039-001 Legal/General 309 11/21/2014 Nov A/P Legal/General 1,191.40 1,191.40 WHITAKER CHALK SWINDLE 34412 AP 309 11/21/2014 Nov A/P Oct Legal 8,582.53 9,773.93 THE LISTON LAW FIRM, P.C. 34405 AP 309 11/21/2014 Nov A/P Legal/Waterline relocation 9,104.66 18,878.59 THE LISTON LAW FIRM, P.C. 34405 AP 404 11/30/2014 Reclassify Legal Reclassify Legal (18,878.59) .00 GL _______________ Account: 135-55045-039-001 Legal/General Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-55045-039-002 Legal/Contracts & ILAs 309 11/21/2014 Nov A/P Legal 3,905.00 3,905.00 FREEMAN & CORBETT 34382 AP 404 11/30/2014 Reclassify Legal Reclassify Legal (3,905.00) .00 GL _______________ Account: 135-55045-039-002 Legal/Contracts & ILAs Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 3 WWTP Bonds Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-003 Legal/WWTP Bonds 309 11/21/2014 Nov A/P Legal 10,279.77 2,453.05 12,732.82 FREEMAN & CORBETT 34382 AP 309 11/21/2014 Nov A/P Oct Legal 143,906.33 156,639.15 Fulbright & Jaworski LLP 34383 AP 404 11/30/2014 Reclassify Legal Reclassify Legal (156,639.15) .00 GL _______________ Account: 135-55045-039-003 Legal/WWTP Bonds Totals: (10,279.77) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-55045-039-004 Legal/Land Access WWTP 309 11/21/2014 Nov A/P Legal/Land Access 2,865.70 2,865.70 WHITAKER CHALK SWINDLE 34412 AP 404 11/30/2014 Reclassify Legal Reclassify Legal (2,865.70) .00 GL _______________ Account: 135-55045-039-004 Legal/Land Access WWTP Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 184,565.00 ** 286,291.00 Budgeted 101,726.00 Remaining 64 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 39,304.91 .00 Budgeted (39,304.91) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (91,329.00) .00 (91,329.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (91,329.00) ** .00 Budgeted 91,329.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (17,950.00) .00 (17,950.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (17,950.00) ** .00 Budgeted 17,950.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (109,279.00) ** .00 Budgeted 109,279.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-030-000 GASB Replacement 74,706.00 .00 74,706.00 _______________ Account: 137-69195-030-000 GASB Replacement Totals: .00 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-045-000 GASB Replacement 125,670.00 .00 125,670.00 _______________ Account: 137-69195-045-000 GASB Replacement Totals: .00 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ 91,097.00 .00 Budgeted (91,097.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 396 11/30/2014 Bank Interest/November (2.53) (2.53) (5.06) GL 400 11/30/2014 Reverse Bank Interest/November 2.53 (2.53) GL 401 11/30/2014 Bank Interest/November (.60) (3.13) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (.60) (3.13) ** .00 Budgeted 3.13 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3.13) ** .00 Budgeted 3.13 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 416 11/30/2014 Nov A/P Indian Creek Waterline Replace 2,100.00 2,100.00 TEAGUE, NALL & PERKINS,INC 34449 AP _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: 2,100.00 2,100.00 ** 3,348.00 Budgeted 1,248.00 Remaining 63 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,100.00 ** 3,348.00 Budgeted 1,248.00 Remaining 63 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 2,096.87 3,348.00 Budgeted 1,251.13 Remaining 63 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET NOVEMBER 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 41,240 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 442,690 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 488,776 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 442,690 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 442,690 FUND BALANCE ASSIGNED FUND BALANCE 14,753 NET REVENUES / EXPENDITURES 31,333 TOTAL FUND BALANCE 46,086 TOTAL LIABILITIES AND FUND BALANCE 488,776 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 16:41 12/08/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 466,019.00- 466,019.00- 23,413.88- 29,856.08- 6.407 436,162.92- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 15.58- 1,220.26- 48.810 1,279.74- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 3.47- 255.97- 15.998 1,344.03- Subtotal: 470,119.00- 470,119.00- 23,432.93- 31,332.31- 6.665 438,786.69- 533-48005-000-000 Reserve Funds/PID Utility Fees 100,000.00- 100,000.00- 100,000.00- 533-48015-000-000 WW Sales Rev Trnsf for Debt 357,538.00- 357,538.00- 357,538.00- Subtotal: 457,538.00- 457,538.00- 457,538.00- 533-49010-000-000 Interest Income 375.00- 375.00- .63- .94- .251 374.06- 533-49015-000-000 Lease/Rental Income 211,829.00- 211,829.00- 211,829.00- Subtotal: 212,204.00- 212,204.00- .63- .94- 212,203.06- Program number: 1,139,861.00- 1,139,861.00- 23,433.56- 31,333.25- 2.749 1,108,527.75- Department number: Revenues 1,139,861.00- 1,139,861.00- 23,433.56- 31,333.25- 2.749 1,108,527.75- Revenues Subtotal ----------- 1,139,861.00- 1,139,861.00- 23,433.56- 31,333.25- 2.749 1,108,527.75- . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 16:41 12/08/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,550.00 2,550.00 2,550.00 533-70025-051-000 Bond Interest Expense-Tax 403,103.00 403,103.00 403,103.00 533-70035-051-000 Bond Principal Payment-Tax 440,000.00 440,000.00 440,000.00 533-70040-051-000 Bond Interest Expense-Revenue 292,283.00 292,283.00 292,283.00 Subtotal: 1,137,936.00 1,137,936.00 1,137,936.00 Program number: 1,137,936.00 1,137,936.00 1,137,936.00 Department number: Administration 1,137,936.00 1,137,936.00 1,137,936.00 Expenditures Subtotal ----------- 1,137,936.00 1,137,936.00 1,137,936.00 Fund number: 533 MUD 1 I&S Consolidated 1,925.00- 1,925.00- 23,433.56- 31,333.25- 1,627.701 29,408.25 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 398 11/03/2014 Rev Property Taxes/Assessments (6,442.20) 1,103.72 (5,338.48) GL 399 11/03/2014 Property Taxes/Assessments (1,103.72) (6,442.20) GL 371 11/03/2014 Property Taxes/Assessments (1,103.72) (7,545.92) GL 372 11/04/2014 Property Taxes/Assessments (398.69) (7,944.61) GL 373 11/05/2014 Property Taxes/Assessments (898.10) (8,842.71) GL 374 11/06/2014 Property Taxes/Assessments (641.22) (9,483.93) GL 375 11/07/2014 Property Taxes/Assessments (774.35) (10,258.28) GL 376 11/10/2014 Property Taxes/Assessments (9,945.90) (20,204.18) GL 377 11/12/2014 Property Taxes/Assessments (434.84) (20,639.02) GL 378 11/13/2014 Property Taxes/Assessments (617.39) (21,256.41) GL 379 11/14/2014 Property Taxes/Assessments (1,109.68) (22,366.09) GL 380 11/17/2014 Property Taxes/Assessments (1,197.99) (23,564.08) GL 386 11/18/2014 Property Taxes/Assessments (2,764.28) (26,328.36) GL 387 11/19/2014 Property Taxes/Assessments (287.04) (26,615.40) GL 388 11/20/2014 Property Taxes/Assessments (86.95) (26,702.35) GL 389 11/21/2014 Property Taxes/Assessments (772.02) (27,474.37) GL 392 11/24/2014 Property Taxes/Assessments (822.24) (28,296.61) GL 393 11/25/2014 Property Taxes/Assessments (415.95) (28,712.56) GL 394 11/26/2014 Property Taxes/Assessments (1,143.52) (29,856.08) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (23,413.88) (29,856.08) ** (466,019.00) Budgeted (436,162.92) Remaining 6 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 378 11/13/2014 Property Taxes/Assessments (1,204.68) (2.38) (1,207.06) GL 380 11/17/2014 Property Taxes/Assessments (1.93) (1,208.99) GL 386 11/18/2014 Property Taxes/Assessments (11.27) (1,220.26) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (15.58) (1,220.26) ** (2,500.00) Budgeted (1,279.74) Remaining 49 % Used Account: 533-40015-000-000 Property Taxes/P & I 378 11/13/2014 Property Taxes/Assessments (252.50) (.48) (252.98) GL 380 11/17/2014 Property Taxes/Assessments (.51) (253.49) GL 386 11/18/2014 Property Taxes/Assessments (2.48) (255.97) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (3.47) (255.97) ** (1,600.00) Budgeted (1,344.03) Remaining 16 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (100,000.00) Budgeted (100,000.00) Remaining 0 % Used Account: 533-48015-000-000 WW Sales Rev Trnsf for Debt .00 .00 _______________ Account: 533-48015-000-000 WW Sales Rev Trnsf for Debt Totals: .00 .00 ** (357,538.00) Budgeted (357,538.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 396 11/30/2014 Bank Interest/November (.31) (.31) (.62) GL 400 11/30/2014 Reverse Bank Interest/November .31 (.31) GL 401 11/30/2014 Bank Interest/November (.63) (.94) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (.63) (.94) ** (375.00) Budgeted (374.06) Remaining 0 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (211,829.00) Budgeted (211,829.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (31,333.25) ** (1,139,861.00) Budgeted (1,108,527.75) Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 16:41 12/08/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 .00 ** 2,550.00 Budgeted 2,550.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 403,103.00 Budgeted 403,103.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 440,000.00 Budgeted 440,000.00 Remaining 0 % Used Account: 533-70040-051-000 Bond Interest Expense-Revenue .00 .00 _______________ Account: 533-70040-051-000 Bond Interest Expense-Revenue Totals: .00 .00 ** 292,283.00 Budgeted 292,283.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 1,137,936.00 Budgeted 1,137,936.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (31,333.25) (1,925.00) Budgeted 29,408.25 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 284,110.18 **** 1,423.00 Budgeted (282,687.18) Remaining ########## ******* End of Report *********