Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Dec Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET DECEMBER 2014 122 ASSETS FIRE DEPT. INVESTMENTS 996,023 PREPAID EXPENSES 14,392 ADVALOREM PROPERTY TAXES RECEIVABLE 414,471 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 94,592 UTILITY AND OTHER ACCOUNTS RECEIVABLE 7,121 TOTAL ASSETS 1,526,599 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 509,063 ACCOUNTS AND OTHER PAYABLES 68,947 TOTAL LIABILITIES 578,009 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 419,678 TOTAL FUND BALANCE 948,589 TOTAL LIABILITIES AND FUND BALANCE 1,526,599 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 09:35 01/14/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/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- 250,485.81- 271,000.20- 75.812 86,461.80- 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- 417,224.35- 473,137.41- 54.205 399,721.59- 122-40011-000-000 Property Taxes/Fire-Delinquent 426.97- 3,341.34- 3,341.34 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- 130.65- 955.50- 21.233 3,544.50- Subtotal: 1,235,571.00- 1,235,571.00- 668,267.78- 748,560.06- 60.584 487,010.94- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 800.00- 1,200.00- 20.000 4,800.00- Subtotal: 6,000.00- 6,000.00- 800.00- 1,200.00- 20.000 4,800.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 150.00- 225.00- 32.143 475.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,700.00- 10,700.00- 150.00- 225.00- 2.103 10,475.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- 1,600.00- 2,400.00- 40.000 3,600.00- Subtotal: 131,669.00- 131,669.00- 1,600.00- 128,070.00- 97.267 3,599.00- Program number: 1,383,940.00- 1,383,940.00- 670,817.78- 878,055.06- 63.446 505,884.94- Department number: Fire Revenues 1,383,940.00- 1,383,940.00- 670,817.78- 878,055.06- 63.446 505,884.94- Revenues Subtotal ----------- 1,383,940.00- 1,383,940.00- 670,817.78- 878,055.06- 63.446 505,884.94- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 09:35 01/14/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 36,259.44 94,195.19 20.081 374,871.81 122-50010-045-000 Overtime 46,745.00 46,745.00 2,236.88 8,021.80 17.161 38,723.20 122-50011-045-000 DPS Holiday Pay 14,930.00 14,930.00 14,457.01 96.832 472.99 122-50016-045-000 Longevity 5,505.00 5,505.00 5,318.72 5,318.72 96.616 186.28 122-50017-045-000 Certification 4,800.00 4,800.00 462.50 1,044.00 21.750 3,756.00 122-50020-045-000 Retirement 91,396.00 91,396.00 6,416.63 17,873.27 19.556 73,522.73 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,945.14 12,823.78 21.673 46,345.22 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 378.12 998.06 22.735 3,391.94 122-50028-045-000 Vision Insurance 811.00 811.00 66.29 175.01 21.580 635.99 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 330.58 872.63 21.653 3,157.37 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 2,514.47 7,017.89 20.998 26,403.11 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 587.93 1,640.77 22.501 5,651.23 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,977.00 22.745 6,715.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 60,175.70 166,415.13 22.116 586,039.87 122-55030-045-000 Software & Support 7,378.00 7,378.00 955.17 1,417.67 19.215 5,960.33 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 957.99 1,237.01 6.668 17,314.99 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 1,040.00 1,395.12 11.626 10,604.88 Subtotal: 39,430.00 39,430.00 2,953.16 4,049.80 10.271 35,380.20 122-60005-045-000 Telephone 50.00 50.00 11.42 11.42 22.840 38.58 122-60010-045-000 Communications/Pagers/Mobiles 5,000.00 5,000.00 37.50 2,450.37 49.007 2,549.63 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 575.61 777.83 8.618 8,248.17 122-60025-045-000 Water 1,200.00 1,200.00 110.04 326.03 27.169 873.97 122-60026-045-000 Cable 1,920.00 1,920.00 287.58 595.10 30.995 1,324.90 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 7.68 8.16 8.160 91.84 122-60055-045-000 Insurance 12,179.00 12,179.00 940.09 2,820.27 23.157 9,358.73 122-60066-045-000 Publications/Books/Subscrips 200.00 200.00 179.00 89.500 21.00 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 7,394.85 48.714 7,785.15 122-60080-045-000 Schools & Training 4,280.00 4,280.00 85.00 316.00 7.383 3,964.00 122-60096-045-000 Emergency Management 1,400.00 1,400.00 220.00 220.00 15.714 1,180.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 194.00 194.00 19.400 806.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 662.50 847.10 42.355 1,152.90 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 09:35 01/14/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 570.00 570.00 57.000 430.00 Subtotal: 291,541.00 291,541.00 3,701.42 17,210.55 5.903 274,330.45 122-65005-045-000 Fuel & Lube 10,454.00 10,454.00 541.63 1,752.88 16.768 8,701.12 122-65010-045-000 Uniforms 2,000.00 2,000.00 823.51 960.82 48.041 1,039.18 122-65015-045-000 Protective Clothing 5,200.00 15,200.00 15,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 40,402.00 1,365.14 2,751.87 6.811 37,650.13 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 10,400.00 10,400.00 Subtotal: 270,112.00 260,112.00 267,950.00 103.013 7,838.00- Program number: 1,383,940.00 1,383,940.00 68,195.42 458,377.35 33.121 925,562.65 Department number: Fire 1,383,940.00 1,383,940.00 68,195.42 458,377.35 33.121 925,562.65 Expenditures Subtotal ----------- 1,383,940.00 1,383,940.00 68,195.42 458,377.35 33.121 925,562.65 Fund number: 122 Trophy Club MUD Fire Dept. 602,622.36- 419,677.71- 419,677.71 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/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 561 12/01/2014 Property Taxes/Assessments (20,514.39) (2,142.95) (22,657.34) GL 562 12/02/2014 Property Taxes/Assessments (1,170.37) (23,827.71) GL 563 12/03/2014 Property Taxes/Assessments (896.87) (24,724.58) GL 564 12/04/2014 Property Taxes/Assessments (1,384.36) (26,108.94) GL 565 12/05/2014 Property Taxes/Assessments (1,292.37) (27,401.31) GL 566 12/08/2014 Property Taxes/Assessments (1,487.68) (28,888.99) GL 567 12/09/2014 Property Taxes/Assessments (1,880.74) (30,769.73) GL 568 12/10/2014 Property Taxes/Assessments (729.40) (31,499.13) GL 569 12/11/2014 Property Taxes/Assessments (715.34) (32,214.47) GL 570 12/12/2014 Property Taxes/Assessments (1,707.06) (33,921.53) GL 571 12/15/2014 Property Taxes/Assessments (1,408.05) (35,329.58) GL 572 12/16/2014 Property Taxes/Assessments (2,594.83) (37,924.41) GL 573 12/17/2014 Property Taxes/Assessments (1,308.46) (39,232.87) GL 574 12/18/2014 Property Taxes/Assessments (1,864.05) (41,096.92) GL 575 12/19/2014 Property Taxes/Assessments (831.14) (41,928.06) GL 576 12/22/2014 Property Taxes/Assessments (3,481.62) (45,409.68) GL 581 12/23/2014 Property Taxes/Assessments (186,854.57) (232,264.25) GL 577 12/24/2014 Property Taxes/Assessments (5,043.40) (237,307.65) GL 578 12/29/2014 Property Taxes/Assessments (5,630.14) (242,937.79) GL 579 12/30/2014 Property Taxes/Assessments (23,752.22) (266,690.01) GL 580 12/31/2014 Property Taxes/Assessments (4,310.19) (271,000.20) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (250,485.81) (271,000.20) ** (357,462.00) Budgeted (86,461.80) Remaining 76 % 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 561 12/01/2014 Property Taxes/Assessments (55,913.06) (7,203.85) (63,116.91) GL 562 12/02/2014 Property Taxes/Assessments (3,832.35) (66,949.26) GL 563 12/03/2014 Property Taxes/Assessments (3,285.72) (70,234.98) GL 564 12/04/2014 Property Taxes/Assessments (3,366.53) (73,601.51) GL 565 12/05/2014 Property Taxes/Assessments (3,331.89) (76,933.40) GL 566 12/08/2014 Property Taxes/Assessments (5,281.59) (82,214.99) GL 567 12/09/2014 Property Taxes/Assessments (4,528.71) (86,743.70) GL 568 12/10/2014 Property Taxes/Assessments (3,496.20) (90,239.90) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 569 12/11/2014 Property Taxes/Assessments (55,913.06) (2,605.27) (92,845.17) GL 570 12/12/2014 Property Taxes/Assessments (7,946.98) (100,792.15) GL 571 12/15/2014 Property Taxes/Assessments (9,491.70) (110,283.85) GL 572 12/16/2014 Property Taxes/Assessments (7,049.19) (117,333.04) GL 573 12/17/2014 Property Taxes/Assessments (6,619.32) (123,952.36) GL 574 12/18/2014 Property Taxes/Assessments (3,792.27) (127,744.63) GL 575 12/19/2014 Property Taxes/Assessments (6,832.53) (134,577.16) GL 576 12/22/2014 Property Taxes/Assessments (9,150.74) (143,727.90) GL 581 12/23/2014 Property Taxes/Assessments (237,525.56) (381,253.46) GL 577 12/24/2014 Property Taxes/Assessments (7,939.81) (389,193.27) GL 578 12/29/2014 Property Taxes/Assessments (34,343.89) (423,537.16) GL 579 12/30/2014 Property Taxes/Assessments (38,507.69) (462,044.85) GL 580 12/31/2014 Property Taxes/Assessments (11,092.56) (473,137.41) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (417,224.35) (473,137.41) ** (872,859.00) Budgeted (399,721.59) Remaining 54 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 561 12/01/2014 Property Taxes/Assessments (2,914.37) (10.31) (2,924.68) GL 566 12/08/2014 Property Taxes/Assessments (170.04) (3,094.72) GL 567 12/09/2014 Property Taxes/Assessments 22.93 (3,071.79) GL 571 12/15/2014 Property Taxes/Assessments (7.51) (3,079.30) GL 577 12/24/2014 Property Taxes/Assessments (81.30) (3,160.60) GL 578 12/29/2014 Property Taxes/Assessments (157.20) (3,317.80) GL 580 12/31/2014 Property Taxes/Assessments (23.54) (3,341.34) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (426.97) (3,341.34) ** .00 Budgeted 3,341.34 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 561 12/01/2014 Property Taxes/Assessments (824.85) (2.27) (827.12) GL 566 12/08/2014 Property Taxes/Assessments (39.11) (866.23) GL 567 12/09/2014 Property Taxes/Assessments 3.00 (863.23) GL 568 12/10/2014 Property Taxes/Assessments (2.71) (865.94) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 571 12/15/2014 Property Taxes/Assessments (824.85) (2.96) (868.90) GL 577 12/24/2014 Property Taxes/Assessments (38.84) (907.74) GL 578 12/29/2014 Property Taxes/Assessments (42.34) (950.08) GL 580 12/31/2014 Property Taxes/Assessments (5.42) (955.50) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (130.65) (955.50) ** (4,500.00) Budgeted (3,544.50) Remaining 21 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (400.00) (800.00) (1,200.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (800.00) (1,200.00) ** (6,000.00) Budgeted (4,800.00) Remaining 20 % Used Account: 122-43400-000-000 Fire Inspections 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (75.00) (150.00) (225.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (150.00) (225.00) ** (700.00) Budgeted (475.00) Remaining 32 % 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 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (800.00) (1,600.00) (2,400.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,600.00) (2,400.00) ** (6,000.00) Budgeted (3,600.00) Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ------------------------------------------------------------------------------------------------ (878,055.06) ** (1,383,940.00) Budgeted (505,884.94) Remaining 63 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 461 12/05/2014 FD Payroll 12/5/14 57,935.75 17,661.56 75,597.31 GL 482 12/19/2014 FD Payroll 12/19/14 18,597.88 94,195.19 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 36,259.44 94,195.19 ** 469,067.00 Budgeted 374,871.81 Remaining 20 % Used Account: 122-50010-045-000 Overtime 482 12/19/2014 FD Payroll 12/19/14 5,784.92 2,236.88 8,021.80 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,236.88 8,021.80 ** 46,745.00 Budgeted 38,723.20 Remaining 17 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,457.01 .00 14,457.01 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,457.01 ** 14,930.00 Budgeted 472.99 Remaining 97 % Used Account: 122-50016-045-000 Longevity 455 12/12/2014 Fire Dept Longevity 5,318.72 5,318.72 GL _______________ Account: 122-50016-045-000 Longevity Totals: 5,318.72 5,318.72 ** 5,505.00 Budgeted 186.28 Remaining 97 % Used Account: 122-50017-045-000 Certification 461 12/05/2014 FD Payroll 12/5/14 581.50 462.50 1,044.00 GL _______________ Account: 122-50017-045-000 Certification Totals: 462.50 1,044.00 ** 4,800.00 Budgeted 3,756.00 Remaining 22 % Used Account: 122-50020-045-000 Retirement 461 12/05/2014 FD Payroll 12/5/14 11,456.64 2,614.52 14,071.16 GL 455 12/12/2014 Fire Dept Longevity 782.35 14,853.51 GL 482 12/19/2014 FD Payroll 12/19/14 3,019.76 17,873.27 GL _______________ Account: 122-50020-045-000 Retirement Totals: 6,416.63 17,873.27 ** 91,396.00 Budgeted 73,522.73 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 461 12/05/2014 FD Payroll 12/5/14 7,878.64 2,798.47 10,677.11 GL 482 12/19/2014 FD Payroll 12/19/14 2,146.67 12,823.78 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,945.14 12,823.78 ** 59,169.00 Budgeted 46,345.22 Remaining 22 % Used Account: 122-50027-045-000 Dental Insurance 461 12/05/2014 FD Payroll 12/5/14 619.94 189.06 809.00 GL 482 12/19/2014 FD Payroll 12/19/14 189.06 998.06 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 378.12 998.06 ** 4,390.00 Budgeted 3,391.94 Remaining 23 % Used Account: 122-50028-045-000 Vision Insurance 461 12/05/2014 FD Payroll 12/5/14 108.72 33.15 141.87 GL 482 12/19/2014 FD Payroll 12/19/14 33.14 175.01 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 66.29 175.01 ** 811.00 Budgeted 635.99 Remaining 22 % Used Account: 122-50029-045-000 Life Insurance & Other 461 12/05/2014 FD Payroll 12/5/14 542.05 165.30 707.35 GL 482 12/19/2014 FD Payroll 12/19/14 165.28 872.63 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 330.58 872.63 ** 4,030.00 Budgeted 3,157.37 Remaining 22 % Used Account: 122-50030-045-000 Social Security Taxes 461 12/05/2014 FD Payroll 12/5/14 4,503.42 1,007.17 5,510.59 GL 455 12/12/2014 Fire Dept Longevity 329.76 5,840.35 GL 482 12/19/2014 FD Payroll 12/19/14 1,177.54 7,017.89 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,514.47 7,017.89 ** 33,421.00 Budgeted 26,403.11 Remaining 21 % Used Account: 122-50035-045-000 Medicare Taxes 461 12/05/2014 FD Payroll 12/5/14 1,052.84 235.50 1,288.34 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 455 12/12/2014 Fire Dept Longevity 1,052.84 77.10 1,365.44 GL 482 12/19/2014 FD Payroll 12/19/14 275.33 1,640.77 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 587.93 1,640.77 ** 7,292.00 Budgeted 5,651.23 Remaining 23 % 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 193 12/01/2014 Dec TML Ins & Workers Comp 1,318.00 659.00 1,977.00 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 659.00 1,977.00 ** 8,692.00 Budgeted 6,715.00 Remaining 23 % 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 501 12/23/2014 Dec A/P Nevill,Charter,Symond,Shi,Sung 462.50 955.17 1,417.67 TOWN OF TROPHY CLUB 34500 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 955.17 1,417.67 ** 7,378.00 Budgeted 5,960.33 Remaining 19 % Used Account: 122-55045-045-000 Legal . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 475 12/18/2014 Dec A/P FD Inspection and recharge 279.02 54.50 333.52 KIMBROUGH FIRE EXTINQUISHER CO 34483 AP 460 12/19/2014 Dec A/P Fire Extinquisher Insp-FD 302.00 635.52 KIMBROUGH FIRE EXTINQUISHER CO 34469 AP 593 12/26/2014 11/27-12/26/14 PCards SAMS CLUB #4795 408.96 1,044.48 SAMS CLUB #4795 PC 593 12/26/2014 11/27-12/26/14 PCards WAL-MART #5247 100.82 1,145.30 WAL-MART #5247 PC 593 12/26/2014 11/27-12/26/14 PCards SAMS CLUB #4795 59.42 1,204.72 SAMS CLUB #4795 PC 615 12/31/2014 Dec A/P Rug Service 32.29 1,237.01 G & K SERVICES 34519 AP 615 12/31/2014 Dec A/P Rug Service 32.29 1,269.30 G & K SERVICES 34519 AP 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (32.29) 1,237.01 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 957.99 1,237.01 ** 18,552.00 Budgeted 17,314.99 Remaining 7 % Used Account: 122-55090-045-000 Vehicle Maintenance 501 12/23/2014 Dec A/P Maint/Repairs Q-681 355.12 1,000.25 1,355.37 SIDDONS-MARTIN EMERGENCY GROUP 34497 AP 593 12/26/2014 11/27-12/26/14 PCards KWIK KAR LUBE & TUNE O 39.75 1,395.12 KWIK KAR LUBE & TUNE O PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 1,040.00 1,395.12 ** 12,000.00 Budgeted 10,604.88 Remaining 12 % Used Account: 122-60005-045-000 Telephone 460 12/19/2014 Dec A/P Nov BOA (IT Pcards) 5.71 5.71 TOWN OF TROPHY CLUB 34476 AP 501 12/23/2014 Dec A/P BOA Pcard Purchases 5.71 11.42 TOWN OF TROPHY CLUB 34500 AP _______________ Account: 122-60005-045-000 Telephone Totals: 11.42 11.42 ** 50.00 Budgeted 38.58 Remaining 23 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 461 12/05/2014 FD Payroll 12/5/14 2,412.87 37.50 2,450.37 GL _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 37.50 2,450.37 ** 5,000.00 Budgeted 2,549.63 Remaining 49 % Used Account: 122-60020-045-000 Electricity/Gas . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 473 12/18/2014 Dec A/P Electricity 11/11-12/15/14 202.22 819.57 1,021.79 HUDSON ENERGY SERVICES, LLC 34479 AP 501 12/23/2014 Dec A/P Gas Fire Station 11/16-12/18/1 331.63 1,353.42 ATMOS ENERGY 34487 AP 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (575.59) 777.83 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 575.61 777.83 ** 9,026.00 Budgeted 8,248.17 Remaining 9 % Used Account: 122-60025-045-000 Water 615 12/31/2014 Dec A/P December Water 215.99 220.07 436.06 TROPHY CLUB MUD (WATER BILLS) 34561 AP 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (110.03) 326.03 AR _______________ Account: 122-60025-045-000 Water Totals: 110.04 326.03 ** 1,200.00 Budgeted 873.97 Remaining 27 % Used Account: 122-60026-045-000 Cable 593 12/26/2014 11/27-12/26/14 PCards ATT*BILL PAYMENT 307.52 128.82 436.34 ATT*BILL PAYMENT PC 593 12/26/2014 11/27-12/26/14 PCards ATT*BILL PAYMENT 158.76 595.10 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 287.58 595.10 ** 1,920.00 Budgeted 1,324.90 Remaining 31 % 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 588 12/31/2014 Dec MUD Postage meter used .48 7.68 8.16 GL _______________ Account: 122-60035-045-000 Postage Totals: 7.68 8.16 ** 100.00 Budgeted 91.84 Remaining 8 % Used Account: 122-60055-045-000 Insurance 193 12/01/2014 Dec TML Ins & Workers Comp 1,880.18 940.09 2,820.27 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.09 2,820.27 ** 12,179.00 Budgeted 9,358.73 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 179.00 .00 179.00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 179.00 ** 200.00 Budgeted 21.00 Remaining 90 % Used Account: 122-60070-045-000 Dues & Memberships 7,394.85 .00 7,394.85 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 7,394.85 ** 15,180.00 Budgeted 7,785.15 Remaining 49 % Used Account: 122-60080-045-000 Schools & Training 501 12/23/2014 Dec A/P S Rusk/Cert for Fire Insp. 231.00 85.00 316.00 TX COMM ON FIRE PROTECTION 34501 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 316.00 ** 4,280.00 Budgeted 3,964.00 Remaining 7 % Used Account: 122-60096-045-000 Emergency Management 615 12/31/2014 Dec A/P TCCC,Amer Comm, P Bowes, Nevil 220.00 220.00 TOWN OF TROPHY CLUB 34559 AP _______________ Account: 122-60096-045-000 Emergency Management Totals: 220.00 220.00 ** 1,400.00 Budgeted 1,180.00 Remaining 16 % 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 11 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 615 12/31/2014 Dec A/P TCLEDDS Subscription renewal 194.00 194.00 THE PRODUCTIVITY CENTER 34557 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 194.00 194.00 ** 1,000.00 Budgeted 806.00 Remaining 19 % Used Account: 122-60195-045-000 Flags & Repair 501 12/23/2014 Dec A/P Nevill,Charter,Symond,Shi,Sung 184.60 662.50 847.10 TOWN OF TROPHY CLUB 34500 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 662.50 847.10 ** 2,000.00 Budgeted 1,152.90 Remaining 42 % Used Account: 122-60245-045-000 Miscellaneous Expense 581 12/23/2014 Property Taxes/Assessments 992.22 992.22 GL 593 12/26/2014 11/27-12/26/14 PCards WALGREENS #2020 125.00 1,117.22 WALGREENS #2020 PC 615 12/31/2014 Dec A/P TCCC,Amer Comm, P Bowes, Nevil 270.00 1,387.22 TOWN OF TROPHY CLUB 34559 AP 615 12/31/2014 Dec A/P Richards Catering,Exclusive pe 175.00 1,562.22 TOWN OF TROPHY CLUB 34559 AP 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (992.22) 570.00 AR _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 570.00 570.00 ** 1,000.00 Budgeted 430.00 Remaining 57 % Used Account: 122-65005-045-000 Fuel & Lube 593 12/26/2014 11/27-12/26/14 PCards ROANOKE QUICK STOP 1,211.25 64.58 1,275.83 ROANOKE QUICK STOP PC 615 12/31/2014 Dec A/P Fuel purchases 11/25-12/24/14 541.63 1,817.46 US Bank Voyager Fleet Systems 34564 AP 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (64.58) 1,752.88 AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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-65005-045-000 Fuel & Lube Totals: 541.63 1,752.88 ** 10,454.00 Budgeted 8,701.12 Remaining 17 % Used Account: 122-65010-045-000 Uniforms 460 12/19/2014 Dec A/P Fire fighter Nomex pant 137.31 913.06 1,050.37 GST PUBLIC SAFETY SUPPLY 34465 AP 593 12/26/2014 11/27-12/26/14 PCards GOT YOU COVERED WORKWE (3.30) 1,047.07 GOT YOU COVERED WORKWE PC 615 12/31/2014 Dec A/P Uniforms 370.28 1,417.35 GST PUBLIC SAFETY SUPPLY 34520 AP 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (456.53) 960.82 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 823.51 960.82 ** 2,000.00 Budgeted 1,039.18 Remaining 48 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 15,200.00 Budgeted 15,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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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-65085-045-000 Office Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-65105-045-000 Printing 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 17,950.00 ** 17,950.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 10,400.00 Budgeted 10,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 458,377.35 ** 1,383,940.00 Budgeted 925,562.65 Remaining 33 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (419,677.71) .00 Budgeted 419,677.71 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET DECEMBER 2014 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 12/31/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 288,044 - - 288,044 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,505,875 - - 1,505,875 INVESTMENTS-TEXPOOL 353,812 169,600 23,703 547,114 PREPAID EXPENSES 59,473 - - 59,473 ADVALOREM PROPERTY TAXES RECEIVABLE 78,823 - - 78,823 UTILITY AND OTHER ACCOUNTS RECEIVABLE 652,384 - - 652,384 - TOTAL ASSETS 2,939,011 169,600 23,703 3,132,314 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 78,823 - - 78,823 ACCOUNTS AND OTHER PAYABLES 406,655 - 15,531 422,186 CUSTOMER DEPOSITS 298,452 - - 298,452 - TOTAL LIABILITIES 783,930 - 15,531 799,461 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 7,027 (91,097) (2,096) (86,166) - TOTAL FUND BALANCE 2,155,081 169,600 8,172 2,332,853 - TOTAL LIABILITIES AND FUND BALANCE 2,939,011 169,600 23,703 3,132,314 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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- 80,237.52- 90,990.34- 54.207 76,866.66- 135-40002-000-000 Property Taxes/Delinquent 45.70- 357.42- 357.42 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 15.59- 121.59- 13.510 778.41- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 11,463.20- 34,220.50- 25.538 99,776.50- Subtotal: 302,754.00- 302,754.00- 91,762.01- 125,689.85- 41.516 177,064.15- 135-47000-000-000 Water 5,286,045.00- 5,286,045.00- 236,689.67- 824,026.24- 15.589 4,462,018.76- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 157,802.64- 502,901.37- 22.145 1,768,080.63- 135-47025-000-000 Penalties 63,416.00- 63,416.00- 5,368.81- 26,288.38- 41.454 37,127.62- 135-47030-000-000 Service Charges 8,000.00- 8,000.00- 653.00- 2,834.00- 35.425 5,166.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 600.00- 30.000 1,400.00- 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 450.00- 1,800.00- 36.000 3,200.00- 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 592.90- 12,798.10- 14.742 74,016.90- Subtotal: 7,722,258.00- 7,722,258.00- 401,707.02- 1,371,248.09- 17.757 6,351,009.91- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 13,800.00- 48,300.00- 26.250 135,700.00- Subtotal: 184,000.00- 184,000.00- 13,800.00- 48,300.00- 26.250 135,700.00- 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 523.79- 1,510.91- 30.218 3,489.09- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 2,731.59- 26.875 7,432.41- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,749.99- 25.000 5,250.01- 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- 2,744.00- 10,846.57- 12.913 73,153.43- 135-49900-000-000 Miscellaneous Income 54,000.00- 88,600.00- 15,187.27- 34,833.21- 39.315 53,766.79- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 12.20- 12.200 87.80- Subtotal: 235,321.00- 269,921.00- 19,948.92- 126,390.47- 46.825 143,530.53- Program number: 8,444,333.00- 8,478,933.00- 527,217.95- 1,671,628.41- 19.715 6,807,304.59- Department number: Revenues 8,444,333.00- 8,478,933.00- 527,217.95- 1,671,628.41- 19.715 6,807,304.59- Revenues Subtotal ----------- 8,444,333.00- 8,478,933.00- 527,217.95- 1,671,628.41- 19.715 6,807,304.59- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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,748.94 38,556.03 12.805 262,544.97 135-50010-010-000 Overtime 19,500.00 19,500.00 747.51 2,839.39 14.561 16,660.61 135-50016-010-000 Longevity 5,343.00 5,343.00 2,705.00 50.627 2,638.00 135-50017-010-000 Certification 4,800.00 4,800.00 150.00 700.00 14.583 4,100.00 135-50020-010-000 Retirement 29,349.00 29,349.00 1,135.66 4,023.09 13.708 25,325.91 135-50026-010-000 Medical Insurance 44,988.00 44,988.00 1,874.31 5,604.62 12.458 39,383.38 135-50027-010-000 Dental Insurance 3,288.00 3,288.00 150.87 443.82 13.498 2,844.18 135-50028-010-000 Vision Insurance 834.00 834.00 35.88 107.25 12.860 726.75 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 57.96 433.60 14.105 2,640.40 135-50030-010-000 Social Security Taxes 21,135.00 21,135.00 771.39 2,746.51 12.995 18,388.49 135-50035-010-000 Medicare Taxes 4,943.00 4,943.00 180.41 642.34 12.995 4,300.66 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 2,573.73 16.066 13,446.27 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,000.00 316.40 379.40 37.940 620.60 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 456,917.00 456,917.00 18,027.24 61,754.78 13.516 395,162.22 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 12,162.65 21,203.42 29.763 50,038.58 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 98.80 2,249.48 28.119 5,750.52 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 510.00 930.26 16.914 4,569.74 Subtotal: 98,242.00 98,242.00 12,771.45 24,626.16 25.067 73,615.84 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 588.26 902.48 18.369 4,010.52 135-60020-010-000 Electricity 170,765.00 170,765.00 9,632.30 28,344.68 16.599 142,420.32 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 50.00 50.00 1.208 4,088.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,302.51 17,201.36 34.909 32,073.64 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 141,194.15 337,731.93 11.533 2,590,576.07 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 454.50 818.25 23.379 2,681.75 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 160,221.72 385,048.70 12.150 2,784,200.30 135-65005-010-000 Fuel & Lube 29,172.00 29,172.00 704.03 3,591.01 12.310 25,580.99 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 2.762 3,520.01 135-65030-010-000 Chemicals 7,000.00 7,000.00 514.74 2,715.57 38.794 4,284.43 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 7.000 150,195.00 Subtotal: 203,492.00 203,492.00 1,218.77 17,853.32 8.773 185,638.68 135-69005-010-000 Capital Outlays 1,089,006.00 1,177,566.00 66,038.50 92,045.56 7.817 1,085,520.44 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 53.454 70,520.31 Subtotal: 1,448,125.00 1,536,685.00 66,038.50 248,032.25 16.141 1,288,652.75 Program number: 5,376,025.00 5,464,585.00 258,277.68 737,315.21 13.493 4,727,269.79 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/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 160.00 1,937.63 38.753 3,062.37 Subtotal: 5,000.00 5,000.00 160.00 1,937.63 38.753 3,062.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 160.00 1,937.63 19.376 8,062.37 Department number: Water 5,386,025.00 5,474,585.00 258,437.68 739,252.84 13.503 4,735,332.16 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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,188.98 61,077.75 19.977 244,666.25 135-50010-020-000 Overtime 19,500.00 19,500.00 1,999.91 5,981.13 30.672 13,518.87 135-50016-020-000 Longevity 5,617.00 5,617.00 5,615.00 99.964 2.00 135-50017-020-000 Certification 6,600.00 6,600.00 550.00 1,650.00 25.000 4,950.00 135-50020-020-000 Retirement 29,948.00 29,948.00 2,311.34 6,674.26 22.286 23,273.74 135-50026-020-000 Medical Insurance 61,001.00 61,001.00 5,083.22 13,161.17 21.575 47,839.83 135-50027-020-000 Dental Insurance 4,146.00 4,146.00 313.98 831.48 20.055 3,314.52 135-50028-020-000 Vision Insurance 990.00 990.00 74.94 198.45 20.045 791.55 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 267.82 802.82 25.135 2,391.18 135-50030-020-000 Social Security Taxes 21,680.00 21,680.00 1,382.05 4,064.26 18.747 17,615.74 135-50035-020-000 Medicare Taxes 5,070.00 5,070.00 323.22 950.50 18.748 4,119.50 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 2,573.73 16.066 13,446.27 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 150.00 135-50070-020-000 Employee Relations 550.00 550.00 111.84 253.81 46.147 296.19 Subtotal: 481,452.00 481,452.00 36,465.21 103,834.36 21.567 377,617.64 135-55080-020-000 Maintenance & Repairs 58,000.00 58,000.00 3,378.73 33,081.44 57.037 24,918.56 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 1,263.70 1,263.70 42.123 1,736.30 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 9.99 17.28 3.456 482.72 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 3,610.37 11,280.47 20.510 43,719.53 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,868.00 5,623.00 22.492 19,377.00 Subtotal: 141,500.00 141,500.00 11,130.79 51,265.89 36.230 90,234.11 135-60010-020-000 Communications/Pagers/Mobiles 4,662.00 4,662.00 610.96 1,021.88 21.919 3,640.12 135-60020-020-000 Electricity 149,292.00 149,292.00 12,651.74 29,344.37 19.656 119,947.63 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 79.90 134.85 33.713 265.15 135-60070-020-000 Dues & Memberships 250.00 250.00 250.00 135-60080-020-000 Schools & Training 4,065.00 4,065.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 12.28 104.58 6.536 1,495.42 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 100.00 9,019.00 52.589 8,131.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 13,454.88 39,975.68 21.290 147,793.32 135-65005-020-000 Fuel & Lube 36,328.00 36,328.00 2,702.63 7,024.43 19.336 29,303.57 135-65010-020-000 Uniforms 2,778.00 2,778.00 2,365.97 85.168 412.03 135-65030-020-000 Chemicals 30,000.00 30,000.00 690.86 2,159.38 7.198 27,840.62 135-65035-020-000 Small Tools 2,000.00 2,000.00 458.33 22.917 1,541.67 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 21.600 588.00 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 497.23 5,600.04 43.077 7,399.96 Subtotal: 84,856.00 84,856.00 3,890.72 17,770.15 20.942 67,085.85 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 7,302.00 80,942.00 53.961 69,058.00 135-69007-020-000 LTD Payment from WW Sales 357,538.00 295,933.00 295,933.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 504,935.00 7,302.00 80,942.00 16.030 423,993.00 Program number: 1,462,117.00 1,400,512.00 72,243.60 293,788.08 20.977 1,106,723.92 Department number: Wastewater 1,462,117.00 1,400,512.00 72,243.60 293,788.08 20.977 1,106,723.92 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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,000.00 2,500.00 25.000 7,500.00 135-50030-026-000 Social Security Taxes 620.00 620.00 62.00 155.00 25.000 465.00 135-50035-026-000 Medicare Taxes 145.00 145.00 14.50 36.25 25.000 108.75 135-50040-026-000 Unemployment Taxes 230.00 230.00 23.00 57.50 25.000 172.50 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 8.82 24.500 27.18 Subtotal: 11,031.00 11,031.00 1,102.44 2,757.57 24.998 8,273.43 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 1,200.00 82.99 110.95 9.246 1,089.05 135-60080-026-000 Schools & Training 4,000.00 4,000.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 5.000 950.00 Subtotal: 11,850.00 11,850.00 82.99 1,170.95 9.881 10,679.05 Program number: 22,881.00 22,881.00 1,185.43 3,928.52 17.169 18,952.48 Department number: Board of Directors 22,881.00 22,881.00 1,185.43 3,928.52 17.169 18,952.48 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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,178.71 93,319.83 19.540 384,258.17 135-50010-030-000 Overtime 1,000.00 1,000.00 16.66 51.77 5.177 948.23 135-50016-030-000 Longevity 3,283.00 3,283.00 3,282.50 99.985 .50 135-50020-030-000 Retirement 42,840.00 42,840.00 3,160.54 8,679.55 20.260 34,160.45 135-50026-030-000 Medical Insurance 65,015.00 65,015.00 5,166.33 13,300.02 20.457 51,714.98 135-50027-030-000 Dental Insurance 4,944.00 4,944.00 340.42 913.56 18.478 4,030.44 135-50028-030-000 Vision Insurance 1,158.00 1,158.00 81.62 219.45 18.951 938.55 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 344.95 1,044.14 24.097 3,288.86 135-50030-030-000 Social Security Taxes 30,079.00 30,079.00 2,036.71 5,642.88 18.760 24,436.12 135-50035-030-000 Medicare Taxes 7,422.00 7,422.00 476.30 1,319.68 17.781 6,102.32 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 46.99 126.14 8.705 1,322.86 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 261.90 16.009 1,374.10 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 1,536.68 2,142.38 42.848 2,857.62 Subtotal: 646,237.00 646,237.00 48,473.21 130,341.80 20.169 515,895.20 135-55030-030-000 Software & Support 75,588.00 87,423.00 38,259.79 65,285.39 74.678 22,137.61 135-55070-030-000 Independent Labor 8,000.00 32,550.00 3,300.00 8,943.75 27.477 23,606.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 326.05 2,126.31 32.712 4,373.69 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 627.53 1,255.06 15.495 6,844.94 135-55160-030-000 Professional Outside Services 58,000.00 58,000.00 37,077.95 63.928 20,922.05 135-55161-030-000 Town Personnel Contract 6,170.00 26,170.00 20,000.00 76.423 6,170.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 1,239.25 1,823.85 22.242 6,376.15 Subtotal: 175,258.00 231,643.00 43,752.62 136,512.31 58.932 95,130.69 135-60005-030-000 Telephone 13,361.00 13,361.00 1,902.14 2,292.14 17.155 11,068.86 135-60010-030-000 Communications/Pagers/Mobiles 4,056.00 4,056.00 375.30 1,013.29 24.982 3,042.71 135-60020-030-000 Electricity/Gas 14,978.00 14,978.00 341.45 2.280 14,636.55 135-60025-030-000 Water 1,500.00 1,500.00 82.56 260.02 17.335 1,239.98 135-60035-030-000 Postage 28,500.00 28,500.00 5,031.75 7,649.67 26.841 20,850.33 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 4,454.40 9,561.24 29.879 22,438.76 135-60050-030-000 Bad Debt Expense 6,200.00 6,200.00 303.44 303.44 4.894 5,896.56 135-60055-030-000 Insurance 48,751.00 48,751.00 4,063.01 12,222.28 25.071 36,528.72 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 151.00 151.00 15.100 849.00 135-60070-030-000 Dues & Memberships 5,000.00 5,000.00 3,280.95 4,055.95 81.119 944.05 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 198.00 268.00 2.618 9,967.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 154.18 377.83 6.997 5,022.17 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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 192.00 192.00 7.680 2,308.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 147.00 3,366.65 19.238 14,133.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 5,035.96 48.076 5,439.04 Subtotal: 218,406.00 218,406.00 20,335.73 47,116.03 21.573 171,289.97 135-65010-030-000 Uniforms 1,855.00 1,855.00 100.00 1,043.00 56.226 812.00 135-65055-030-000 Hardware 75,966.00 35,226.00 454.99 73,784.40 209.460 38,558.40- 135-65085-030-000 Office Supplies 9,000.00 9,000.00 293.93 1,310.95 14.566 7,689.05 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 201.00 253.10 5.349 4,478.90 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 361.80 1,289.54 25.791 3,710.46 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 60,813.00 1,411.72 77,680.99 127.737 16,867.99- 135-69005-030-000 Capital Outlays 125,000.00 67,000.00 67,000.00 135-69170-030-000 Copier Lease Installments 4,236.00 4,236.00 607.22 648.01 15.298 3,587.99 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 16,329.00 16,329.00 100.000 Subtotal: 145,565.00 87,565.00 607.22 16,977.01 19.388 70,587.99 Program number: 1,287,019.00 1,244,664.00 114,580.50 408,628.14 32.830 836,035.86 Department number: Administration 1,287,019.00 1,244,664.00 114,580.50 408,628.14 32.830 836,035.86 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 09:35 01/14/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/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 300,000.00 30,100.35 212,388.79 70.796 87,611.21 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 1,882.21 4,158.77 41.588 5,841.23 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,456.40 2,456.40 64.642 1,343.60 Subtotal: 286,291.00 336,291.00 34,438.96 219,003.96 65.123 117,287.04 Program number: 286,291.00 336,291.00 34,438.96 219,003.96 65.123 117,287.04 Department number: Non Departmental 286,291.00 336,291.00 34,438.96 219,003.96 65.123 117,287.04 Expenditures Subtotal ----------- 8,444,333.00 8,478,933.00 480,886.17 1,664,601.54 19.632 6,814,331.46 Fund number: 135 MUD 1 General Fund 46,331.78- 7,026.87- 7,026.87 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 09:35 01/14/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/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 15 09:35 01/14/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 12/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 16 09:35 01/14/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 12/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 17 09:35 01/14/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 12/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income .89- 4.02- 4.02 Subtotal: .89- 4.02- 4.02 Program number: .89- 4.02- 4.02 Department number: .89- 4.02- 4.02 Revenues Subtotal ----------- .89- 4.02- 4.02 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 09:35 01/14/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 12/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 62.724 1,248.00 Subtotal: 3,348.00 3,348.00 2,100.00 62.724 1,248.00 Program number: 3 Indian Creek Waterline 3,348.00 3,348.00 2,100.00 62.724 1,248.00 Department number: Water 3,348.00 3,348.00 2,100.00 62.724 1,248.00 Expenditures Subtotal ----------- 3,348.00 3,348.00 2,100.00 62.724 1,248.00 Fund number: 507 MUD 1 Capital Projects 3,348.00 3,348.00 .89- 2,095.98 62.604 1,252.02 . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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 561 12/01/2014 Property Taxes/Assessments (10,752.82) (1,385.39) (12,138.21) GL 562 12/02/2014 Property Taxes/Assessments (737.01) (12,875.22) GL 563 12/03/2014 Property Taxes/Assessments (631.88) (13,507.10) GL 564 12/04/2014 Property Taxes/Assessments (647.43) (14,154.53) GL 565 12/05/2014 Property Taxes/Assessments (640.76) (14,795.29) GL 566 12/08/2014 Property Taxes/Assessments (1,015.72) (15,811.01) GL 567 12/09/2014 Property Taxes/Assessments (870.93) (16,681.94) GL 568 12/10/2014 Property Taxes/Assessments (672.36) (17,354.30) GL 569 12/11/2014 Property Taxes/Assessments (501.03) (17,855.33) GL 570 12/12/2014 Property Taxes/Assessments (1,528.30) (19,383.63) GL 571 12/15/2014 Property Taxes/Assessments (1,825.37) (21,209.00) GL 572 12/16/2014 Property Taxes/Assessments (1,355.65) (22,564.65) GL 573 12/17/2014 Property Taxes/Assessments (1,272.98) (23,837.63) GL 574 12/18/2014 Property Taxes/Assessments (729.30) (24,566.93) GL 575 12/19/2014 Property Taxes/Assessments (1,313.98) (25,880.91) GL 576 12/22/2014 Property Taxes/Assessments (1,759.80) (27,640.71) GL 581 12/23/2014 Property Taxes/Assessments (45,679.18) (73,319.89) GL 577 12/24/2014 Property Taxes/Assessments (1,526.93) (74,846.82) GL 578 12/29/2014 Property Taxes/Assessments (6,604.76) (81,451.58) GL 579 12/30/2014 Property Taxes/Assessments (7,405.52) (88,857.10) GL 580 12/31/2014 Property Taxes/Assessments (2,133.24) (90,990.34) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (80,237.52) (90,990.34) ** (167,857.00) Budgeted (76,866.66) Remaining 54 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 561 12/01/2014 Property Taxes/Assessments (311.72) (1.11) (312.83) GL 566 12/08/2014 Property Taxes/Assessments (18.20) (331.03) GL 567 12/09/2014 Property Taxes/Assessments 2.46 (328.57) GL 571 12/15/2014 Property Taxes/Assessments (.81) (329.38) GL 577 12/24/2014 Property Taxes/Assessments (8.69) (338.07) GL 578 12/29/2014 Property Taxes/Assessments (16.83) (354.90) GL 580 12/31/2014 Property Taxes/Assessments (2.52) (357.42) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (45.70) (357.42) ** .00 Budgeted 357.42 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 561 12/01/2014 Property Taxes/Assessments (106.00) (.24) (106.24) GL 566 12/08/2014 Property Taxes/Assessments (4.18) (110.42) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 567 12/09/2014 Property Taxes/Assessments (106.00) .32 (110.10) GL 568 12/10/2014 Property Taxes/Assessments (.52) (110.62) GL 571 12/15/2014 Property Taxes/Assessments (.32) (110.94) GL 577 12/24/2014 Property Taxes/Assessments (4.75) (115.69) GL 578 12/29/2014 Property Taxes/Assessments (5.32) (121.01) GL 580 12/31/2014 Property Taxes/Assessments (.58) (121.59) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (15.59) (121.59) ** (900.00) Budgeted (778.41) Remaining 14 % Used Account: 135-40025-000-000 PID Surcharges 551 12/29/2014 UB 12/29/14 Adj UB20141229-20141229 User: (22,757.30) 17.80 (22,739.50) UB 528 12/31/2014 UB 12/31/14 Billing UB20141231-20141231 User: (11,481.00) (34,220.50) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (11,463.20) (34,220.50) ** (133,997.00) Budgeted (99,776.50) Remaining 26 % Used Account: 135-47000-000-000 Water 528 12/31/2014 UB 12/31/14 Billing UB20141231-20141231 User: (587,336.57) (236,689.67) (824,026.24) UB _______________ Account: 135-47000-000-000 Water Totals: (236,689.67) (824,026.24) ** (5,286,045.00) Budgeted (4,462,018.76) Remaining 16 % Used Account: 135-47005-000-000 Sewer 528 12/31/2014 UB 12/31/14 Billing UB20141231-20141231 User: (345,098.73) (157,802.64) (502,901.37) UB _______________ Account: 135-47005-000-000 Sewer Totals: (157,802.64) (502,901.37) ** (2,270,982.00) Budgeted (1,768,080.63) Remaining 22 % Used Account: 135-47025-000-000 Penalties 532 12/01/2014 UB 12/1/14 Adjustments UB20141201-20141201 User: (20,919.57) 202.86 (20,716.71) UB 533 12/02/2014 UB 12/2/14 Penalty removal UB20141202-20141202 User: 44.78 (20,671.93) UB 536 12/08/2014 UB 12/8/14 Penalty removal UB20141208-20141208 User: 629.26 (20,042.67) UB 542 12/10/2014 UB 12/10/14 adj UB20141210-20141210 User: 223.71 (19,818.96) UB 546 12/15/2014 UB 12/15/14 Penalty removals UB20141215-20141215 User: 58.98 (19,759.98) UB 498 12/23/2014 UB 12/23/14 Penalties UB20141223-20141223 User: (6,615.65) (26,375.63) UB 551 12/29/2014 UB 12/29/14 Adj UB20141229-20141229 User: 87.25 (26,288.38) UB _______________ Account: 135-47025-000-000 Penalties Totals: (5,368.81) (26,288.38) ** (63,416.00) Budgeted (37,127.62) Remaining 41 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 537 12/09/2014 UB 12/9/14 NSF Cehck fee UB20141209-20141209 User: (2,181.00) (25.00) (2,206.00) UB 432 12/10/2014 UB 12/10/14 Cut Off List UB20141210-20141210 User: (625.00) (2,831.00) UB 542 12/10/2014 UB 12/10/14 adj UB20141210-20141210 User: 25.00 (2,806.00) UB 543 12/10/2014 UB 12/10/14 NSF Check fee UB20141210-20141210 User: (25.00) (2,831.00) UB 528 12/31/2014 UB 12/31/14 Billing UB20141231-20141231 User: (3.00) (2,834.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (653.00) (2,834.00) ** (8,000.00) Budgeted (5,166.00) Remaining 35 % Used Account: 135-47035-000-000 Plumbing Inspections 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (450.00) (150.00) (600.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (600.00) ** (2,000.00) Budgeted (1,400.00) Remaining 30 % Used Account: 135-47045-000-000 Sewer Inspections 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (1,350.00) (450.00) (1,800.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (1,800.00) ** (5,000.00) Budgeted (3,200.00) Remaining 36 % Used Account: 135-47070-000-000 TCCC Effluent Charges 528 12/31/2014 UB 12/31/14 Billing UB20141231-20141231 User: (12,205.20) (592.90) (12,798.10) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (592.90) (12,798.10) ** (86,815.00) Budgeted (74,016.90) Remaining 15 % Used Account: 135-48005-000-000 Utility Fees 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (34,500.00) (13,800.00) (48,300.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (13,800.00) (48,300.00) ** (184,000.00) Budgeted (135,700.00) Remaining 26 % Used Account: 135-49010-000-000 Interest Income 559 12/31/2014 Bank Interest/December (987.12) (51.06) (1,038.18) GL 559 12/31/2014 Bank Interest/December (37.18) (1,075.36) GL 559 12/31/2014 Bank Interest/December (435.55) (1,510.91) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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-49010-000-000 Interest Income Totals: (523.79) (1,510.91) ** (5,000.00) Budgeted (3,489.09) Remaining 30 % Used Account: 135-49016-000-000 Cell Tower Revenue 589 12/05/2014 AT&T Antenna Lease (1,821.06) (910.53) (2,731.59) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (2,731.59) ** (10,164.00) Budgeted (7,432.41) Remaining 27 % Used Account: 135-49018-000-000 Building Rent Income 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (1,166.66) (583.33) (1,749.99) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,749.99) ** (7,000.00) Budgeted (5,250.01) Remaining 25 % 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 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (8,102.57) (2,744.00) (10,846.57) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (2,744.00) (10,846.57) ** (84,000.00) Budgeted (73,153.43) Remaining 13 % Used Account: 135-49900-000-000 Miscellaneous Income 590 12/09/2014 Tri County-Patronage/1997 (19,645.94) (144.53) (19,790.47) GL 528 12/31/2014 UB 12/31/14 Billing UB20141231-20141231 User: (42.74) (19,833.21) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (19,645.94) (15,000.00) (34,833.21) AR _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (15,187.27) (34,833.21) ** (88,600.00) Budgeted (53,766.79) Remaining 39 % Used Account: 135-49901-000-000 Records Management Revenue (12.20) .00 (12.20) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (12.20) ** (100.00) Budgeted (87.80) Remaining 12 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,671,628.41) ** (8,478,933.00) Budgeted (6,807,304.59) Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 353 12/05/2014 MUD Payroll 12/5/14 Salaries & Wages 26,807.09 5,874.47 32,681.56 PR 454 12/19/2014 MUD Payroll 12/19/14 Salaries & Wages 5,874.47 38,556.03 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 11,748.94 38,556.03 ** 301,101.00 Budgeted 262,544.97 Remaining 13 % Used Account: 135-50010-010-000 Overtime 353 12/05/2014 MUD Payroll 12/5/14 Overtime 2,091.88 730.84 2,822.72 PR 454 12/19/2014 MUD Payroll 12/19/14 Overtime 16.67 2,839.39 PR _______________ Account: 135-50010-010-000 Overtime Totals: 747.51 2,839.39 ** 19,500.00 Budgeted 16,660.61 Remaining 15 % Used Account: 135-50016-010-000 Longevity 2,705.00 .00 2,705.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,705.00 ** 5,343.00 Budgeted 2,638.00 Remaining 51 % Used Account: 135-50017-010-000 Certification 454 12/19/2014 MUD Payroll 12/19/14 Certification 550.00 150.00 700.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 700.00 ** 4,800.00 Budgeted 4,100.00 Remaining 15 % Used Account: 135-50020-010-000 Retirement 353 12/05/2014 MUD Payroll 12/5/14 Retirement 2,887.43 593.16 3,480.59 PR 454 12/19/2014 MUD Payroll 12/19/14 Retirement 542.50 4,023.09 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,135.66 4,023.09 ** 29,349.00 Budgeted 25,325.91 Remaining 14 % Used Account: 135-50026-010-000 Medical Insurance 353 12/05/2014 MUD Payroll 12/5/14 Medical Insurance 3,730.31 937.17 4,667.48 PR 454 12/19/2014 MUD Payroll 12/19/14 Medical Insurance 937.14 5,604.62 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,874.31 5,604.62 ** 44,988.00 Budgeted 39,383.38 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 353 12/05/2014 MUD Payroll 12/5/14 Dental Insurance 292.95 75.43 368.38 PR 454 12/19/2014 MUD Payroll 12/19/14 Dental Insurance 75.44 443.82 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 150.87 443.82 ** 3,288.00 Budgeted 2,844.18 Remaining 13 % Used Account: 135-50028-010-000 Vision Insurance 353 12/05/2014 MUD Payroll 12/5/14 Vision Insurance 71.37 17.93 89.30 PR 454 12/19/2014 MUD Payroll 12/19/14 Vision Insurance 17.95 107.25 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.88 107.25 ** 834.00 Budgeted 726.75 Remaining 13 % Used Account: 135-50029-010-000 Life Insurance & Other 419 12/08/2014 Dec A/P Dec Dental, Life, Vol Life, AD 375.64 49.52 425.16 METLIFE GROUP BENEFITS 34438 AP 460 12/19/2014 Dec A/P Café 125 Adm fee 8.44 433.60 BenefitMall 34459 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 57.96 433.60 ** 3,074.00 Budgeted 2,640.40 Remaining 14 % Used Account: 135-50030-010-000 Social Security Taxes 353 12/05/2014 MUD Payroll 12/5/14 Social Security Taxes 1,975.12 405.59 2,380.71 PR 454 12/19/2014 MUD Payroll 12/19/14 Social Security Taxes 365.80 2,746.51 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 771.39 2,746.51 ** 21,135.00 Budgeted 18,388.49 Remaining 13 % Used Account: 135-50035-010-000 Medicare Taxes 353 12/05/2014 MUD Payroll 12/5/14 Medicare Taxes 461.93 94.86 556.79 PR 454 12/19/2014 MUD Payroll 12/19/14 Medicare Taxes 85.55 642.34 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 180.41 642.34 ** 4,943.00 Budgeted 4,300.66 Remaining 13 % Used Account: 135-50040-010-000 Unemployment Taxes .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 1,242.00 Budgeted 1,242.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 193 12/01/2014 Dec TML Ins & Workers Comp 1,715.82 857.91 2,573.73 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.91 2,573.73 ** 16,020.00 Budgeted 13,446.27 Remaining 16 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 615 12/31/2014 Dec A/P Pre-employment testing/Baker, 63.00 140.40 203.40 FIRST CHECK APPLICANT SCREENIN 34517 AP 615 12/31/2014 Dec A/P Pre-employment testing, Baker, 176.00 379.40 CARENOW CORPORATE 34508 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 316.40 379.40 ** 1,000.00 Budgeted 620.60 Remaining 38 % 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 477 12/18/2014 Dec A/P Repair waterline @ #7 Campus C 9,040.77 11,326.98 20,367.75 REY-MAR CONSTRUCTION 34484 AP 477 12/18/2014 Dec A/P Replace valve bolts/99 TC Dr 200.00 20,567.75 REY-MAR CONSTRUCTION 34484 AP 460 12/19/2014 Dec A/P Fire Extinquisher Inspection/W 81.50 20,649.25 KIMBROUGH FIRE EXTINQUISHER CO 34469 AP 593 12/26/2014 11/27-12/26/14 PCards ROANOKE WINNELSON CO 78.18 20,727.43 ROANOKE WINNELSON CO PC 593 12/26/2014 11/27-12/26/14 PCards MILCOM SUPPLY INC 104.40 20,831.83 MILCOM SUPPLY INC PC 593 12/26/2014 11/27-12/26/14 PCards THE HOME DEPOT 6581 26.57 20,858.40 THE HOME DEPOT 6581 PC 593 12/26/2014 11/27-12/26/14 PCards FERGUSON ENTERPRISES 1 253.62 21,112.02 FERGUSON ENTERPRISES 1 PC 593 12/26/2014 11/27-12/26/14 PCards FERGUSON ENTERPRISES 1 91.40 21,203.42 FERGUSON ENTERPRISES 1 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-55080-010-000 Maintenance & Repairs Totals: 12,162.65 21,203.42 ** 71,242.00 Budgeted 50,038.58 Remaining 30 % Used Account: 135-55090-010-000 Vehicle Maintenance 593 12/26/2014 11/27-12/26/14 PCards ROANOKE AUTO SUPPLY LT 2,150.68 98.80 2,249.48 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 98.80 2,249.48 ** 8,000.00 Budgeted 5,750.52 Remaining 28 % 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 460 12/19/2014 Dec A/P Water Samples 420.26 230.00 650.26 TARRANT CTY PUBLIC HEALTH LAB 34473 AP 615 12/31/2014 Dec A/P Lab analysis 280.00 930.26 TARRANT CTY PUBLIC HEALTH LAB 34552 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 510.00 930.26 ** 5,500.00 Budgeted 4,569.74 Remaining 17 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 465 12/17/2014 Dec A/P Cell Phones 314.22 588.26 902.48 VERIZON WIRELESS 34478 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 588.26 902.48 ** 4,913.00 Budgeted 4,010.52 Remaining 18 % Used Account: 135-60020-010-000 Electricity 460 12/19/2014 Dec A/P Electricity 11/10-12/10/14 18,712.38 74.55 18,786.93 HUDSON ENERGY SERVICES, LLC 34466 AP 501 12/23/2014 Dec A/P Electricity 11/11-12/11/14 3,717.73 22,504.66 HUDSON ENERGY SERVICES, LLC 34491 AP 502 12/23/2014 Dec A/P Electricity 11/11-12/11/14 5,840.02 28,344.68 HUDSON ENERGY SERVICES, LLC 34491 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,632.30 28,344.68 ** 170,765.00 Budgeted 142,420.32 Remaining 17 % Used Account: 135-60066-010-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-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 615 12/31/2014 Dec A/P Petty Cash Reimbursement-RG 50.00 50.00 TROPHY CLUB MUD PETTY CASH 34562 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 50.00 50.00 ** 4,138.00 Budgeted 4,088.00 Remaining 1 % 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 .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 615 12/31/2014 Dec A/P Rev & Regulatory Assessment 8,898.85 8,302.51 17,201.36 TX COMMISSION ENVIRONMENTAL QU 34563 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-60135-010-000 TCEQ Fees & Permits Totals: 8,302.51 17,201.36 ** 49,275.00 Budgeted 32,073.64 Remaining 35 % Used Account: 135-60150-010-000 Wholesale Water 615 12/31/2014 Dec A/P Wholesale Water/Nov 196,537.78 141,194.15 337,731.93 CITY OF FORT WORTH 34509 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 141,194.15 337,731.93 ** 2,928,308.00 Budgeted 2,590,576.07 Remaining 12 % 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 501 12/23/2014 Dec A/P Reset Thermal Overload 363.75 95.00 458.75 Alan's Gates, Inc. 34486 AP 593 12/26/2014 11/27-12/26/14 PCards HD SUPPLY FACILITIES M 359.50 818.25 HD SUPPLY FACILITIES M PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 454.50 818.25 ** 3,500.00 Budgeted 2,681.75 Remaining 23 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 593 12/26/2014 11/27-12/26/14 PCards MUSTANG ELITE CAR WASH 2,886.98 38.24 2,925.22 MUSTANG ELITE CAR WASH PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 593 12/26/2014 11/27-12/26/14 PCards MUSTANG ELITE CAR WASH 2,886.98 (40.26) 2,884.96 MUSTANG ELITE CAR WASH PC 593 12/26/2014 11/27-12/26/14 PCards MUSTANG ELITE CAR WASH 40.26 2,925.22 MUSTANG ELITE CAR WASH PC 615 12/31/2014 Dec A/P Fuel purchases 11/25-12/24/14 665.79 3,591.01 US Bank Voyager Fleet Systems 34564 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 704.03 3,591.01 ** 29,172.00 Budgeted 25,580.99 Remaining 12 % Used Account: 135-65010-010-000 Uniforms 99.99 .00 99.99 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 99.99 ** 3,620.00 Budgeted 3,520.01 Remaining 3 % Used Account: 135-65030-010-000 Chemicals 419 12/08/2014 Dec A/P Chemicals 2,200.83 410.65 2,611.48 HACH COMPANY 34427 AP 501 12/23/2014 Dec A/P Chlorine 104.09 2,715.57 DPC INDUSTRIES, INC 34489 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 514.74 2,715.57 ** 7,000.00 Budgeted 4,284.43 Remaining 39 % 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 Account: 135-65050-010-000 Meter Expense 11,305.00 .00 11,305.00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 11,305.00 ** 161,500.00 Budgeted 150,195.00 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-69005-010-000 Capital Outlays 475 12/18/2014 Dec A/P ILA/Route Study 26,007.06 32,593.00 58,600.06 City of Fort Worth 34482 AP 615 12/31/2014 Dec A/P Ford F350 1 ton Water Truck 33,445.50 92,045.56 SILSBEE FORD INC 34547 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 66,038.50 92,045.56 ** 1,177,566.00 Budgeted 1,085,520.44 Remaining 8 % 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 80,986.69 .00 80,986.69 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 80,986.69 ** 151,507.00 Budgeted 70,520.31 Remaining 53 % Used Account: 135-55135-010-001 Lab Analysis for PID 460 12/19/2014 Dec A/P Water Samples/PID 1,777.63 80.00 1,857.63 TARRANT CTY PUBLIC HEALTH LAB 34473 AP 624 12/31/2014 Dec A/P Water Testing/PID 80.00 1,937.63 TARRANT CTY PUBLIC HEALTH LAB 34553 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 160.00 1,937.63 ** 5,000.00 Budgeted 3,062.37 Remaining 39 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/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-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: ------------------------------------------------------------------------------------------------ 739,252.84 ** 5,474,585.00 Budgeted 4,735,332.16 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 353 12/05/2014 MUD Payroll 12/5/14 Salaries & Wages 37,888.77 11,594.03 49,482.80 PR 454 12/19/2014 MUD Payroll 12/19/14 Salaries & Wages 11,594.95 61,077.75 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 23,188.98 61,077.75 ** 305,744.00 Budgeted 244,666.25 Remaining 20 % Used Account: 135-50010-020-000 Overtime 353 12/05/2014 MUD Payroll 12/5/14 Overtime 3,981.22 1,102.10 5,083.32 PR 454 12/19/2014 MUD Payroll 12/19/14 Overtime 897.81 5,981.13 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,999.91 5,981.13 ** 19,500.00 Budgeted 13,518.87 Remaining 31 % Used Account: 135-50016-020-000 Longevity 5,615.00 .00 5,615.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 5,615.00 ** 5,617.00 Budgeted 2.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 454 12/19/2014 MUD Payroll 12/19/14 Certification 1,100.00 550.00 1,650.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 1,650.00 ** 6,600.00 Budgeted 4,950.00 Remaining 25 % Used Account: 135-50020-020-000 Retirement 353 12/05/2014 MUD Payroll 12/5/14 Retirement 4,362.92 1,140.10 5,503.02 PR 454 12/19/2014 MUD Payroll 12/19/14 Retirement 1,171.24 6,674.26 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,311.34 6,674.26 ** 29,948.00 Budgeted 23,273.74 Remaining 22 % Used Account: 135-50026-020-000 Medical Insurance 353 12/05/2014 MUD Payroll 12/5/14 Medical Insurance 8,077.95 2,541.63 10,619.58 PR 454 12/19/2014 MUD Payroll 12/19/14 Medical Insurance 2,541.59 13,161.17 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,083.22 13,161.17 ** 61,001.00 Budgeted 47,839.83 Remaining 22 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 353 12/05/2014 MUD Payroll 12/5/14 Dental Insurance 517.50 156.98 674.48 PR 454 12/19/2014 MUD Payroll 12/19/14 Dental Insurance 157.00 831.48 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 313.98 831.48 ** 4,146.00 Budgeted 3,314.52 Remaining 20 % Used Account: 135-50028-020-000 Vision Insurance 353 12/05/2014 MUD Payroll 12/5/14 Vision Insurance 123.51 37.45 160.96 PR 454 12/19/2014 MUD Payroll 12/19/14 Vision Insurance 37.49 198.45 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 74.94 198.45 ** 990.00 Budgeted 791.55 Remaining 20 % Used Account: 135-50029-020-000 Life Insurance & Other 419 12/08/2014 Dec A/P Dec Dental, Life, Vol Life, AD 535.00 234.04 769.04 METLIFE GROUP BENEFITS 34438 AP 460 12/19/2014 Dec A/P Café 125 Adm fee 33.78 802.82 BenefitMall 34459 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 267.82 802.82 ** 3,194.00 Budgeted 2,391.18 Remaining 25 % Used Account: 135-50030-020-000 Social Security Taxes 353 12/05/2014 MUD Payroll 12/5/14 Social Security Taxes 2,682.21 685.60 3,367.81 PR 454 12/19/2014 MUD Payroll 12/19/14 Social Security Taxes 696.45 4,064.26 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,382.05 4,064.26 ** 21,680.00 Budgeted 17,615.74 Remaining 19 % Used Account: 135-50035-020-000 Medicare Taxes 353 12/05/2014 MUD Payroll 12/5/14 Medicare Taxes 627.28 160.34 787.62 PR 454 12/19/2014 MUD Payroll 12/19/14 Medicare Taxes 162.88 950.50 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 323.22 950.50 ** 5,070.00 Budgeted 4,119.50 Remaining 19 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,242.00 Budgeted 1,242.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 193 12/01/2014 Dec TML Ins & Workers Comp 1,715.82 857.91 2,573.73 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.91 2,573.73 ** 16,020.00 Budgeted 13,446.27 Remaining 16 % 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 593 12/26/2014 11/27-12/26/14 PCards HOBBY-LOBBY #256 141.97 24.13 166.10 HOBBY-LOBBY #256 PC 593 12/26/2014 11/27-12/26/14 PCards HOBBY-LOBBY #256 87.71 253.81 HOBBY-LOBBY #256 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 111.84 253.81 ** 550.00 Budgeted 296.19 Remaining 46 % Used Account: 135-55070-020-000 Independent Labor 615 12/31/2014 Dec A/P Lift Station 2 Drainage 7,302.00 7,302.00 THE WALLACE GROUP, INC. 34558 AP 634 12/31/2014 Recode Wallace LS2 Drainage (7,302.00) .00 GL _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 421 12/08/2014 Dec A/P Troubleshoot Scada controls 29,702.71 508.00 30,210.71 XYLEM WATER SOLUTIONS USA INC 34455 AP 421 12/08/2014 Dec A/P Removed oil from Stator 508.00 30,718.71 XYLEM WATER SOLUTIONS USA INC 34455 AP 475 12/18/2014 Dec A/P WWTP Inspections and recharge 111.50 30,830.21 KIMBROUGH FIRE EXTINQUISHER CO 34483 AP 501 12/23/2014 Dec A/P Chisel and Red Dawg Nozzles 982.28 31,812.49 UNDERGROUND INC 34504 AP 501 12/23/2014 Dec A/P Troubleshooting/Fixing UV Syst 961.60 32,774.09 NEWMAN REGENCY GROUP, INC 34494 AP 501 12/23/2014 Dec A/P Roto Float Switch 140.92 32,915.01 HD SUPPLY FACILITIES MAINT LTD 34490 AP 501 12/23/2014 Dec A/P Flange Gasket kit 206.47 33,121.48 HD SUPPLY FACILITIES MAINT LTD 34490 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 501 12/23/2014 Dec A/P Conery 4' HD Full Gasket 29,702.71 43.09 33,164.57 HD SUPPLY FACILITIES MAINT LTD 34490 AP 501 12/23/2014 Dec A/P Flange Gasket kit returned (175.90) 32,988.67 HD SUPPLY FACILITIES MAINT LTD 34490 AP 501 12/23/2014 Dec A/P HD Sealing gasket returned (42.47) 32,946.20 HD SUPPLY FACILITIES MAINT LTD 34490 AP 593 12/26/2014 11/27-12/26/14 PCards ASHBROOKSIM 120.00 33,066.20 ASHBROOKSIM PC 593 12/26/2014 11/27-12/26/14 PCards ASHBROOKSIM 15.24 33,081.44 ASHBROOKSIM PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 3,378.73 33,081.44 ** 58,000.00 Budgeted 24,918.56 Remaining 57 % Used Account: 135-55090-020-000 Vehicle Maintenance 593 12/26/2014 11/27-12/26/14 PCards BLAGG TIRE SERVICE 307.70 307.70 BLAGG TIRE SERVICE PC 593 12/26/2014 11/27-12/26/14 PCards MUSTANG ELITE CAR WASH 11.00 318.70 MUSTANG ELITE CAR WASH PC 593 12/26/2014 11/27-12/26/14 PCards AG VAN AND TRUCK E 850.00 1,168.70 AG VAN AND TRUCK E PC 615 12/31/2014 Dec A/P Logos for new crane truck 95.00 1,263.70 M-KAM LTD. 34537 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 1,263.70 1,263.70 ** 3,000.00 Budgeted 1,736.30 Remaining 42 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 593 12/26/2014 11/27-12/26/14 PCards ROANOKE AUTO SUPPLY LT 7.29 9.99 17.28 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 9.99 17.28 ** 500.00 Budgeted 482.72 Remaining 3 % Used Account: 135-55125-020-000 Dumpster Services 421 12/08/2014 Dec A/P Sludge Haul off 7,670.10 1,497.30 9,167.40 L.H. CHANEY MATERIALS, INC. 34453 AP 421 12/08/2014 Dec A/P Sludge Hauling 380.00 9,547.40 L.H. CHANEY MATERIALS, INC. 34453 AP 501 12/23/2014 Dec A/P Sludge haul off 900.55 10,447.95 L.H. CHANEY MATERIALS, INC. 34492 AP 501 12/23/2014 Dec A/P Sludge haul off 832.52 11,280.47 L.H. CHANEY MATERIALS, INC. 34492 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,610.37 11,280.47 ** 55,000.00 Budgeted 43,719.53 Remaining 21 % Used Account: 135-55135-020-000 Lab Analysis 421 12/08/2014 Dec A/P Testing 2,755.00 246.00 3,001.00 OXIDOR LABORATORIES LLC 34454 AP 421 12/08/2014 Dec A/P Testing 176.00 3,177.00 OXIDOR LABORATORIES LLC 34454 AP 421 12/08/2014 Dec A/P testing 246.00 3,423.00 OXIDOR LABORATORIES LLC 34454 AP 421 12/08/2014 Dec A/P Testing 176.00 3,599.00 OXIDOR LABORATORIES LLC 34454 AP 421 12/08/2014 Dec A/P Testing 246.00 3,845.00 OXIDOR LABORATORIES LLC 34454 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 421 12/08/2014 Dec A/P Testing 2,755.00 176.00 4,021.00 OXIDOR LABORATORIES LLC 34454 AP 421 12/08/2014 Dec A/P Testing 176.00 4,197.00 OXIDOR LABORATORIES LLC 34454 AP 421 12/08/2014 Dec A/P Total Suspended Solids 40.00 4,237.00 OXIDOR LABORATORIES LLC 34454 AP 501 12/23/2014 Dec A/P Testing 246.00 4,483.00 OXIDOR LABORATORIES LLC 34496 AP 501 12/23/2014 Dec A/P Testing 176.00 4,659.00 OXIDOR LABORATORIES LLC 34496 AP 501 12/23/2014 Dec A/P Testing 296.00 4,955.00 OXIDOR LABORATORIES LLC 34496 AP 501 12/23/2014 Dec A/P Testing 246.00 5,201.00 OXIDOR LABORATORIES LLC 34496 AP 501 12/23/2014 Dec A/P Testing 246.00 5,447.00 OXIDOR LABORATORIES LLC 34496 AP 501 12/23/2014 Dec A/P Testing 176.00 5,623.00 OXIDOR LABORATORIES LLC 34496 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,868.00 5,623.00 ** 25,000.00 Budgeted 19,377.00 Remaining 22 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 465 12/17/2014 Dec A/P Cell Phones 410.92 610.96 1,021.88 VERIZON WIRELESS 34478 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 610.96 1,021.88 ** 4,662.00 Budgeted 3,640.12 Remaining 22 % Used Account: 135-60020-020-000 Electricity 460 12/19/2014 Dec A/P Electricity 10/28-11/26/14 16,692.63 306.48 16,999.11 TRI COUNTY ELECTRIC 34477 AP 460 12/19/2014 Dec A/P Electricity 10/28-11/26/14 161.73 17,160.84 TRI COUNTY ELECTRIC 34477 AP 460 12/19/2014 Dec A/P Electricity 10/28-11/26/14 28.09 17,188.93 TRI COUNTY ELECTRIC 34477 AP 460 12/19/2014 Dec A/P Electricity 11/10-12/11/14 504.13 17,693.06 HUDSON ENERGY SERVICES, LLC 34466 AP 460 12/19/2014 Dec A/P Electricity 11/10-12/10/14 62.39 17,755.45 HUDSON ENERGY SERVICES, LLC 34466 AP 460 12/19/2014 Dec A/P Electricity 11/10-12/10/14 40.26 17,795.71 HUDSON ENERGY SERVICES, LLC 34466 AP 501 12/23/2014 Dec A/P Electricity 11/11-12/11/14 11,710.00 29,505.71 HUDSON ENERGY SERVICES, LLC 34491 AP 501 12/23/2014 Dec A/P Electricity 11/11-12/11/14 95.46 29,601.17 HUDSON ENERGY SERVICES, LLC 34491 AP 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (256.80) 29,344.37 AR _______________ Account: 135-60020-020-000 Electricity Totals: 12,651.74 29,344.37 ** 149,292.00 Budgeted 119,947.63 Remaining 20 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 417 12/05/2014 Dec A/P Textbooks/Water Util Calcs/Rob 54.95 79.90 134.85 City of Fort Worth 34418 AP _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 79.90 134.85 ** 400.00 Budgeted 265.15 Remaining 34 % Used Account: 135-60070-020-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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-60070-020-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 351.00 .00 351.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 351.00 ** 4,065.00 Budgeted 3,714.00 Remaining 9 % Used 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 501 12/23/2014 Dec A/P Toll to pick up fuel tank/trai 92.30 12.28 104.58 NTTA 34495 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 12.28 104.58 ** 1,600.00 Budgeted 1,495.42 Remaining 7 % 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 402 12/04/2014 Dec A/P Bond Approval Extension applic 8,919.00 100.00 9,019.00 TX COMMISSION ENVIRONMENTAL QU 34414 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 100.00 9,019.00 ** 17,150.00 Budgeted 8,131.00 Remaining 53 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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-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 593 12/26/2014 11/27-12/26/14 PCards AUTOZONE #4206 4,321.80 43.69 4,365.49 AUTOZONE #4206 PC 593 12/26/2014 11/27-12/26/14 PCards ROANOKE AUTO SUPPLY LT 21.63 4,387.12 ROANOKE AUTO SUPPLY LT PC 593 12/26/2014 11/27-12/26/14 PCards 7-ELEVEN 39142 50.00 4,437.12 7-ELEVEN 39142 PC 593 12/26/2014 11/27-12/26/14 PCards PILOT 00004341 100.30 4,537.42 PILOT 00004341 PC 593 12/26/2014 11/27-12/26/14 PCards MUSTANG ELITE CAR WASH 265.96 4,803.38 MUSTANG ELITE CAR WASH PC 593 12/26/2014 11/27-12/26/14 PCards MUSTANG ELITE CAR WASH 265.96 5,069.34 MUSTANG ELITE CAR WASH PC 593 12/26/2014 11/27-12/26/14 PCards PILOT 00004341 79.59 5,148.93 PILOT 00004341 PC 615 12/31/2014 Dec A/P Fuel purchases 11/25-12/24/14 1,875.50 7,024.43 US Bank Voyager Fleet Systems 34564 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 2,702.63 7,024.43 ** 36,328.00 Budgeted 29,303.57 Remaining 19 % Used Account: 135-65010-020-000 Uniforms 2,365.97 .00 2,365.97 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 2,365.97 ** 2,778.00 Budgeted 412.03 Remaining 85 % Used Account: 135-65030-020-000 Chemicals 593 12/26/2014 11/27-12/26/14 PCards AQUAFIX INC. 1,468.52 690.86 2,159.38 AQUAFIX INC. PC _______________ Account: 135-65030-020-000 Chemicals Totals: 690.86 2,159.38 ** 30,000.00 Budgeted 27,840.62 Remaining 7 % Used Account: 135-65035-020-000 Small Tools 458.33 .00 458.33 . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-020-000 Small Tools Totals: .00 458.33 ** 2,000.00 Budgeted 1,541.67 Remaining 23 % Used Account: 135-65040-020-000 Safety Equipment 162.00 .00 162.00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 162.00 ** 750.00 Budgeted 588.00 Remaining 22 % Used Account: 135-65045-020-000 Lab Supplies 593 12/26/2014 11/27-12/26/14 PCards HACH COMPANY 5,102.81 174.54 5,277.35 HACH COMPANY PC 593 12/26/2014 11/27-12/26/14 PCards HACH COMPANY 322.69 5,600.04 HACH COMPANY PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 497.23 5,600.04 ** 13,000.00 Budgeted 7,399.96 Remaining 43 % Used Account: 135-69005-020-000 Capital Outlays 634 12/31/2014 Recode Wallace LS2 Drainage 73,640.00 7,302.00 80,942.00 GL _______________ Account: 135-69005-020-000 Capital Outlays Totals: 7,302.00 80,942.00 ** 150,000.00 Budgeted 69,058.00 Remaining 54 % 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 ** 295,933.00 Budgeted 295,933.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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 2,011.00 Budgeted 2,011.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 293,788.08 ** 1,400,512.00 Budgeted 1,106,723.92 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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 353 12/05/2014 MUD Payroll 12/5/14 Salaries & Wages 1,500.00 500.00 2,000.00 PR 454 12/19/2014 MUD Payroll 12/19/14 Salaries & Wages 500.00 2,500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,000.00 2,500.00 ** 10,000.00 Budgeted 7,500.00 Remaining 25 % Used Account: 135-50030-026-000 Social Security Taxes 353 12/05/2014 MUD Payroll 12/5/14 Social Security Taxes 93.00 31.00 124.00 PR 454 12/19/2014 MUD Payroll 12/19/14 Social Security Taxes 31.00 155.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 62.00 155.00 ** 620.00 Budgeted 465.00 Remaining 25 % Used Account: 135-50035-026-000 Medicare Taxes 353 12/05/2014 MUD Payroll 12/5/14 Medicare Taxes 21.75 7.25 29.00 PR 454 12/19/2014 MUD Payroll 12/19/14 Medicare Taxes 7.25 36.25 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 14.50 36.25 ** 145.00 Budgeted 108.75 Remaining 25 % Used Account: 135-50040-026-000 Unemployment Taxes 353 12/05/2014 MUD Payroll 12/5/14 Unemployment Taxes 34.50 11.50 46.00 PR 454 12/19/2014 MUD Payroll 12/19/14 Unemployment Taxes 11.50 57.50 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 23.00 57.50 ** 230.00 Budgeted 172.50 Remaining 25 % Used Account: 135-50045-026-000 Workman's Compensation 193 12/01/2014 Dec TML Ins & Workers Comp 5.88 2.94 8.82 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 8.82 ** 36.00 Budgeted 27.18 Remaining 25 % 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 39 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 593 12/26/2014 11/27-12/26/14 PCards RANDALLS STORE00017897 27.96 6.99 34.95 RANDALLS STORE00017897 PC 593 12/26/2014 11/27-12/26/14 PCards SUBWAY 03217791 76.00 110.95 SUBWAY 03217791 PC _______________ Account: 135-60075-026-000 Meetings Totals: 82.99 110.95 ** 1,200.00 Budgeted 1,089.05 Remaining 9 % Used Account: 135-60080-026-000 Schools & Training 975.00 .00 975.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .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 50.00 .00 50.00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 50.00 ** 1,000.00 Budgeted 950.00 Remaining 5 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 3,928.52 ** 22,881.00 Budgeted 18,952.48 Remaining 17 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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 353 12/05/2014 MUD Payroll 12/5/14 Salaries & Wages 58,141.12 17,580.29 75,721.41 PR 454 12/19/2014 MUD Payroll 12/19/14 Salaries & Wages 17,598.42 93,319.83 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,178.71 93,319.83 ** 477,578.00 Budgeted 384,258.17 Remaining 20 % Used Account: 135-50010-030-000 Overtime 353 12/05/2014 MUD Payroll 12/5/14 Overtime 35.11 .98 36.09 PR 454 12/19/2014 MUD Payroll 12/19/14 Overtime 15.68 51.77 PR _______________ Account: 135-50010-030-000 Overtime Totals: 16.66 51.77 ** 1,000.00 Budgeted 948.23 Remaining 5 % Used Account: 135-50016-030-000 Longevity 3,282.50 .00 3,282.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,282.50 ** 3,283.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 353 12/05/2014 MUD Payroll 12/5/14 Retirement 5,519.01 1,578.81 7,097.82 PR 454 12/19/2014 MUD Payroll 12/19/14 Retirement 1,581.73 8,679.55 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,160.54 8,679.55 ** 42,840.00 Budgeted 34,160.45 Remaining 20 % Used Account: 135-50026-030-000 Medical Insurance 353 12/05/2014 MUD Payroll 12/5/14 Medical Insurance 8,133.69 2,583.19 10,716.88 PR 454 12/19/2014 MUD Payroll 12/19/14 Medical Insurance 2,583.14 13,300.02 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,166.33 13,300.02 ** 65,015.00 Budgeted 51,714.98 Remaining 20 % Used Account: 135-50027-030-000 Dental Insurance 353 12/05/2014 MUD Payroll 12/5/14 Dental Insurance 573.14 170.19 743.33 PR 454 12/19/2014 MUD Payroll 12/19/14 Dental Insurance 170.23 913.56 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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 913.56 ** 4,944.00 Budgeted 4,030.44 Remaining 18 % Used Account: 135-50028-030-000 Vision Insurance 353 12/05/2014 MUD Payroll 12/5/14 Vision Insurance 137.83 40.78 178.61 PR 454 12/19/2014 MUD Payroll 12/19/14 Vision Insurance 40.84 219.45 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.62 219.45 ** 1,158.00 Budgeted 938.55 Remaining 19 % Used Account: 135-50029-030-000 Life Insurance & Other 419 12/08/2014 Dec A/P Dec Dental, Life, Vol Life, AD 699.19 311.36 1,010.55 METLIFE GROUP BENEFITS 34438 AP 460 12/19/2014 Dec A/P Café 125 Adm fee 33.78 1,044.33 BenefitMall 34459 AP 615 12/31/2014 Dec A/P Adjustment due to rounding (.05) 1,044.28 Legal Shield 34529 AP 598 12/31/2014 Clear Ins due to Rounding (.14) 1,044.14 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 344.95 1,044.14 ** 4,333.00 Budgeted 3,288.86 Remaining 24 % Used Account: 135-50030-030-000 Social Security Taxes 353 12/05/2014 MUD Payroll 12/5/14 Social Security Taxes 3,606.17 1,022.71 4,628.88 PR 454 12/19/2014 MUD Payroll 12/19/14 Social Security Taxes 1,014.00 5,642.88 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,036.71 5,642.88 ** 30,079.00 Budgeted 24,436.12 Remaining 19 % Used Account: 135-50035-030-000 Medicare Taxes 353 12/05/2014 MUD Payroll 12/5/14 Medicare Taxes 843.38 239.17 1,082.55 PR 454 12/19/2014 MUD Payroll 12/19/14 Medicare Taxes 237.13 1,319.68 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 476.30 1,319.68 ** 7,422.00 Budgeted 6,102.32 Remaining 18 % Used Account: 135-50040-030-000 Unemployment Taxes 353 12/05/2014 MUD Payroll 12/5/14 Unemployment Taxes 79.15 23.11 102.26 PR 454 12/19/2014 MUD Payroll 12/19/14 Unemployment Taxes 23.88 126.14 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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: 46.99 126.14 ** 1,449.00 Budgeted 1,322.86 Remaining 9 % Used Account: 135-50045-030-000 Workman's Compensation 193 12/01/2014 Dec TML Ins & Workers Comp 174.60 87.30 261.90 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 261.90 ** 1,636.00 Budgeted 1,374.10 Remaining 16 % 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 487 12/19/2014 Dec A/P Rental for Christmas party 605.70 75.00 680.70 TROPHY CLUB MUD PETTY CASH 34485 AP 593 12/26/2014 11/27-12/26/14 PCards RANDALLS STORE00017897 29.17 709.87 RANDALLS STORE00017897 PC 593 12/26/2014 11/27-12/26/14 PCards PARTY CITY 39.99 749.86 PARTY CITY PC 593 12/26/2014 11/27-12/26/14 PCards KELLER TROPHY AND AWAR 35.00 784.86 KELLER TROPHY AND AWAR PC 593 12/26/2014 11/27-12/26/14 PCards BABE'S ROANOKE LLC 281.03 1,065.89 BABE'S ROANOKE LLC PC 593 12/26/2014 11/27-12/26/14 PCards BIG LOTS STORES - #452 21.65 1,087.54 BIG LOTS STORES - #452 PC 593 12/26/2014 11/27-12/26/14 PCards RANDALLS STORE00017897 811.91 1,899.45 RANDALLS STORE00017897 PC 593 12/26/2014 11/27-12/26/14 PCards MICHAELS STORES 2733 30.09 1,929.54 MICHAELS STORES 2733 PC 593 12/26/2014 11/27-12/26/14 PCards BIG LOTS STORES - #413 50.88 1,980.42 BIG LOTS STORES - #413 PC 593 12/26/2014 11/27-12/26/14 PCards HOT & CREAMY DONUTS 84.47 2,064.89 HOT & CREAMY DONUTS PC 593 12/26/2014 11/27-12/26/14 PCards RANDALLS STORE00017897 17.07 2,081.96 RANDALLS STORE00017897 PC 593 12/26/2014 11/27-12/26/14 PCards WM SUPERCENTER #5247 10.75 2,092.71 WM SUPERCENTER #5247 PC 593 12/26/2014 11/27-12/26/14 PCards RANDALLS STORE00017897 31.25 2,123.96 RANDALLS STORE00017897 PC 593 12/26/2014 11/27-12/26/14 PCards OFFICE DEPOT #406 17.98 2,141.94 OFFICE DEPOT #406 PC 593 12/26/2014 11/27-12/26/14 PCards WAL-MART #0266 3.97 2,145.91 WAL-MART #0266 PC 615 12/31/2014 Dec A/P Petty Cash Reimbursement-RG 21.47 2,167.38 TROPHY CLUB MUD PETTY CASH 34562 AP 615 12/31/2014 Dec A/P Petty Cash Reimbursement-RG (25.00) 2,142.38 TROPHY CLUB MUD PETTY CASH 34562 AP _______________ Account: 135-50070-030-000 Employee Relations Totals: 1,536.68 2,142.38 ** 5,000.00 Budgeted 2,857.62 Remaining 43 % Used Account: 135-55030-030-000 Software & Support . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 424 12/08/2014 Dec A/P Bal due on Annual Service fees 27,025.60 35,055.00 62,080.60 M3 Networks 34456 AP 465 12/17/2014 Dec A/P Record 12/16/14 MUD meeting 45.00 62,125.60 MIGUEL CRUZ 34471 AP 460 12/19/2014 Dec A/P Nov BOA (IT Pcards) 131.36 62,256.96 TOWN OF TROPHY CLUB 34476 AP 501 12/23/2014 Dec A/P Nevill,Charter,Symond,Shi,Sung 645.50 62,902.46 TOWN OF TROPHY CLUB 34500 AP 501 12/23/2014 Dec A/P BOA Pcard Purchases 203.24 63,105.70 TOWN OF TROPHY CLUB 34500 AP 501 12/23/2014 Dec A/P Annual Maint. UB Check Reader 577.50 63,683.20 TECHNIQUE DATA SYSTEMS INC 34498 AP 593 12/26/2014 11/27-12/26/14 PCards ATT*BILL PAYMENT 53.92 63,737.12 ATT*BILL PAYMENT PC 593 12/26/2014 11/27-12/26/14 PCards ATT*BILL PAYMENT 68.60 63,805.72 ATT*BILL PAYMENT PC 615 12/31/2014 Dec A/P Petty Cash Reimbursement-RG 4.99 63,810.71 TROPHY CLUB MUD PETTY CASH 34562 AP 615 12/31/2014 Dec A/P Software and support 1,474.68 65,285.39 STW INC 34549 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 38,259.79 65,285.39 ** 87,423.00 Budgeted 22,137.61 Remaining 75 % Used Account: 135-55070-030-000 Independent Labor 473 12/18/2014 Dec A/P Lift Station 2 Drainage 5,643.75 3,300.00 8,943.75 THE WALLACE GROUP, INC. 34480 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 3,300.00 8,943.75 ** 32,550.00 Budgeted 23,606.25 Remaining 27 % 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 615 12/31/2014 Dec A/P Richards Catering,Exclusive pe 1,800.26 87.50 1,887.76 TOWN OF TROPHY CLUB 34559 AP 615 12/31/2014 Dec A/P Rug Service 95.42 1,983.18 G & K SERVICES 34519 AP 615 12/31/2014 Dec A/P Rug Service 95.42 2,078.60 G & K SERVICES 34519 AP 615 12/31/2014 Dec A/P Rug Service 95.42 2,174.02 G & K SERVICES 34519 AP 615 12/31/2014 Dec A/P Rug Service 95.42 2,269.44 G & K SERVICES 34519 AP 615 12/31/2014 Dec A/P Rug Service 95.42 2,364.86 G & K SERVICES 34519 AP 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (238.55) 2,126.31 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 326.05 2,126.31 ** 6,500.00 Budgeted 4,373.69 Remaining 33 % Used Account: 135-55120-030-000 Cleaning Services . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 460 12/19/2014 Dec A/P Janitorial Service/Nov 627.53 627.53 1,255.06 MEMBER'S BUILDING MAINTENANCE 34470 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 627.53 1,255.06 ** 8,100.00 Budgeted 6,844.94 Remaining 15 % Used Account: 135-55160-030-000 Professional Outside Services 37,077.95 .00 37,077.95 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 37,077.95 ** 58,000.00 Budgeted 20,922.05 Remaining 64 % Used Account: 135-55161-030-000 Town Personnel Contract 20,000.00 .00 20,000.00 _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 20,000.00 ** 26,170.00 Budgeted 6,170.00 Remaining 76 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 460 12/19/2014 Dec A/P Nov Utility billing and mailin 584.60 639.95 1,224.55 DATAPROSE LLC 34462 AP 615 12/31/2014 Dec A/P Utility Billings December 599.30 1,823.85 DATAPROSE LLC 34515 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,239.25 1,823.85 ** 8,200.00 Budgeted 6,376.15 Remaining 22 % Used Account: 135-60005-030-000 Telephone 417 12/05/2014 Dec A/P Answering Service 390.00 180.00 570.00 KEYSTONE PARK SECRETARIAL 34433 AP 460 12/19/2014 Dec A/P Nov BOA (IT Pcards) 870.09 1,440.09 TOWN OF TROPHY CLUB 34476 AP 501 12/23/2014 Dec A/P BOA Pcard Purchases 852.05 2,292.14 TOWN OF TROPHY CLUB 34500 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,902.14 2,292.14 ** 13,361.00 Budgeted 11,068.86 Remaining 17 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-030-000 Communications/Pagers/Mobiles 465 12/17/2014 Dec A/P Cell Phones 637.99 64.58 702.57 VERIZON WIRELESS 34478 AP 454 12/19/2014 MUD Payroll 12/19/14 Communications/Pagers/Mobiles 300.00 1,002.57 PR 593 12/26/2014 11/27-12/26/14 PCards RINGCENTRAL, INC 10.72 1,013.29 RINGCENTRAL, INC PC _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 375.30 1,013.29 ** 4,056.00 Budgeted 3,042.71 Remaining 25 % Used Account: 135-60020-030-000 Electricity/Gas 341.45 .00 341.45 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 341.45 ** 14,978.00 Budgeted 14,636.55 Remaining 2 % Used Account: 135-60025-030-000 Water 615 12/31/2014 Dec A/P December Water 177.46 165.12 342.58 TROPHY CLUB MUD (WATER BILLS) 34561 AP 607 12/31/2014 Bill Town Inv 1242-43,45-55 AR 20141231-20141231 User: (82.56) 260.02 AR _______________ Account: 135-60025-030-000 Water Totals: 82.56 260.02 ** 1,500.00 Budgeted 1,239.98 Remaining 17 % Used Account: 135-60035-030-000 Postage 445 12/12/2014 Dec A/P Mailing of postcards for bank 2,617.92 956.94 3,574.86 U.S. POSTAL SERVICE 34457 AP 460 12/19/2014 Dec A/P Nov Utility billing and mailin 1,817.80 5,392.66 DATAPROSE LLC 34462 AP 593 12/26/2014 11/27-12/26/14 PCards FEDEX 898707657868 23.48 5,416.14 FEDEX 898707657868 PC 615 12/31/2014 Dec A/P TCCC,Amer Comm, P Bowes, Nevil 145.50 5,561.64 TOWN OF TROPHY CLUB 34559 AP 615 12/31/2014 Dec A/P Overnight letter 8.01 5,569.65 FEDERAL EXPRESS CORP 34516 AP 615 12/31/2014 Dec A/P Overnight letter 5.29 5,574.94 FEDERAL EXPRESS CORP 34516 AP 615 12/31/2014 Dec A/P Overnight letter 4.99 5,579.93 FEDERAL EXPRESS CORP 34516 AP 615 12/31/2014 Dec A/P Overnight letter 13.28 5,593.21 FEDERAL EXPRESS CORP 34516 AP 615 12/31/2014 Dec A/P Overnight letter 10.48 5,603.69 FEDERAL EXPRESS CORP 34516 AP 615 12/31/2014 Dec A/P Overnight letter 4.99 5,608.68 FEDERAL EXPRESS CORP 34516 AP 615 12/31/2014 Dec A/P Overnight letter 11.21 5,619.89 FEDERAL EXPRESS CORP 34516 AP 615 12/31/2014 Dec A/P Petty Cash Reimbursement-RG 6.49 5,626.38 TROPHY CLUB MUD PETTY CASH 34562 AP 615 12/31/2014 Dec A/P Utility Billings December 1,877.77 7,504.15 DATAPROSE LLC 34515 AP 588 12/31/2014 Dec MUD Postage meter used 145.52 7,649.67 GL _______________ Account: 135-60035-030-000 Postage Totals: 5,031.75 7,649.67 ** 28,500.00 Budgeted 20,850.33 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-60040-030-000 Service Charges & Fees 426 12/02/2014 Credit Card Fees/Nov 5,106.84 4,004.80 9,111.64 GL 426 12/02/2014 Credit Card Fees/Nov 108.60 9,220.24 GL 426 12/02/2014 Credit Card Fees/Nov 91.00 9,311.24 GL 558 12/12/2014 Bank Analysis Fee- Nov 250.00 9,561.24 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,454.40 9,561.24 ** 32,000.00 Budgeted 22,438.76 Remaining 30 % Used Account: 135-60050-030-000 Bad Debt Expense 554 12/31/2014 UB 12/31/14 Write offs UB20141231-20141231 User: 303.44 303.44 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 303.44 303.44 ** 6,200.00 Budgeted 5,896.56 Remaining 5 % Used Account: 135-60055-030-000 Insurance 193 12/01/2014 Dec TML Ins & Workers Comp 8,159.27 4,063.01 12,222.28 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,063.01 12,222.28 ** 48,751.00 Budgeted 36,528.72 Remaining 25 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 593 12/26/2014 11/27-12/26/14 PCards AMER CHAMBER OF COMM 151.00 151.00 AMER CHAMBER OF COMM PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 151.00 151.00 ** 1,000.00 Budgeted 849.00 Remaining 15 % Used Account: 135-60070-030-000 Dues & Memberships 460 12/19/2014 Dec A/P 2015 membership dues 775.00 3,280.95 4,055.95 Texas Rural Water Assoc 34475 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 3,280.95 4,055.95 ** 5,000.00 Budgeted 944.05 Remaining 81 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-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 593 12/26/2014 11/27-12/26/14 PCards THE CPE STORE, INC. 70.00 198.00 268.00 THE CPE STORE, INC. PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 198.00 268.00 ** 10,235.00 Budgeted 9,967.00 Remaining 3 % Used Account: 135-60100-030-000 Travel & per diem 353 12/05/2014 MUD Payroll 12/5/14 Travel & per diem 223.65 10.58 234.23 PR 454 12/19/2014 MUD Payroll 12/19/14 Travel & per diem 55.39 289.62 PR 615 12/31/2014 Dec A/P Mileage reimbursement/December 84.30 373.92 LAURIE SLAGHT 34528 AP 615 12/31/2014 Dec A/P Tolls/Jennifer 3.91 377.83 Texas Tollways/TxTag 34555 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 154.18 377.83 ** 5,400.00 Budgeted 5,022.17 Remaining 7 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 501 12/23/2014 Dec A/P Employment Classified 192.00 192.00 TX WATER UTILITIES ASSOC 34503 AP _______________ Account: 135-60125-030-000 Advertising Totals: 192.00 192.00 ** 2,500.00 Budgeted 2,308.00 Remaining 8 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-60245-030-000 Miscellaneous Expenses 593 12/26/2014 11/27-12/26/14 PCards VCN*DENTONRECCTR 3,219.65 147.00 3,366.65 VCN*DENTONRECCTR PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 147.00 3,366.65 ** 17,500.00 Budgeted 14,133.35 Remaining 19 % 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 5,035.96 .00 5,035.96 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 5,035.96 ** 10,475.00 Budgeted 5,439.04 Remaining 48 % Used Account: 135-65010-030-000 Uniforms 593 12/26/2014 11/27-12/26/14 PCards PANDA EMBROIDERY 943.00 100.00 1,043.00 PANDA EMBROIDERY PC _______________ Account: 135-65010-030-000 Uniforms Totals: 100.00 1,043.00 ** 1,855.00 Budgeted 812.00 Remaining 56 % Used Account: 135-65055-030-000 Hardware 460 12/19/2014 Dec A/P Nov BOA (IT Pcards) 73,329.41 104.99 73,434.40 TOWN OF TROPHY CLUB 34476 AP 615 12/31/2014 Dec A/P TCCC,Amer Comm, P Bowes, Nevil 350.00 73,784.40 TOWN OF TROPHY CLUB 34559 AP _______________ Account: 135-65055-030-000 Hardware Totals: 454.99 73,784.40 ** 35,226.00 Budgeted (38,558.40) Remaining 209 % Used Account: 135-65085-030-000 Office Supplies 460 12/19/2014 Dec A/P Office Supplies 1,017.02 93.48 1,110.50 OFFICE DEPOT, INC 34472 AP 501 12/23/2014 Dec A/P Office Supplies 118.07 1,228.57 TOWN OF TROPHY CLUB 34500 AP 615 12/31/2014 Dec A/P Office supplies 82.38 1,310.95 OFFICE DEPOT, INC 34540 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 293.93 1,310.95 ** 9,000.00 Budgeted 7,689.05 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-65090-030-000 Printer Supplies & Maintenance 501 12/23/2014 Dec A/P Nevill,Charter,Symond,Shi,Sung 52.10 201.00 253.10 TOWN OF TROPHY CLUB 34500 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 201.00 253.10 ** 4,732.00 Budgeted 4,478.90 Remaining 5 % Used Account: 135-65095-030-000 Maintenance Supplies 593 12/26/2014 11/27-12/26/14 PCards BED BATH & BEYOND #341 927.74 39.46 967.20 BED BATH & BEYOND #341 PC 593 12/26/2014 11/27-12/26/14 PCards SAMS CLUB #4795 241.38 1,208.58 SAMS CLUB #4795 PC 593 12/26/2014 11/27-12/26/14 PCards WAL-MART #0266 11.98 1,220.56 WAL-MART #0266 PC 615 12/31/2014 Dec A/P Supplies for kitchens 68.98 1,289.54 COSTCO WHOLESALE 34513 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 361.80 1,289.54 ** 5,000.00 Budgeted 3,710.46 Remaining 26 % Used Account: 135-65097-030-000 Vending Machine Supplies .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 ** 67,000.00 Budgeted 67,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 501 12/23/2014 Dec A/P Nevill,Charter,Symond,Shi,Sung 40.79 607.22 648.01 TOWN OF TROPHY CLUB 34500 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 607.22 648.01 ** 4,236.00 Budgeted 3,587.99 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-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: ------------------------------------------------------------------------------------------------ 408,628.14 ** 1,244,664.00 Budgeted 836,035.86 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/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 473 12/18/2014 Dec A/P Nov Legal 182,288.44 88.50 182,376.94 WHITAKER CHALK SWINDLE 34481 AP 473 12/18/2014 Dec A/P Nov Legal 470.40 182,847.34 WHITAKER CHALK SWINDLE 34481 AP 473 12/18/2014 Dec A/P Nov Legal 604.80 183,452.14 WHITAKER CHALK SWINDLE 34481 AP 473 12/18/2014 Dec A/P Nov Legal 118.00 183,570.14 WHITAKER CHALK SWINDLE 34481 AP 460 12/19/2014 Dec A/P Nov Legal 2,490.53 186,060.67 FREEMAN & CORBETT 34463 AP 460 12/19/2014 Dec A/P Nov Legal 13,502.12 199,562.79 Fulbright & Jaworski LLP 34464 AP 501 12/23/2014 Dec A/P Nov Legal 7,782.00 207,344.79 THE LISTON LAW FIRM, P.C. 34499 AP 615 12/31/2014 Dec A/P Legal-Litigation Nov/Dec 3,394.00 210,738.79 THE LISTON LAW FIRM, P.C. 34556 AP 624 12/31/2014 Dec A/P Dec Legal 1,650.00 212,388.79 FREEMAN & CORBETT 34518 AP _______________ Account: 135-55045-039-000 Legal Totals: 30,100.35 212,388.79 ** 300,000.00 Budgeted 87,611.21 Remaining 71 % 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 417 12/05/2014 Dec A/P 1st Qtr Denton County Budget 2,276.56 1,882.21 4,158.77 DENTON CENTRAL APPRAISAL DISTR 34424 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,882.21 4,158.77 ** 10,000.00 Budgeted 5,841.23 Remaining 42 % Used Account: 135-55065-039-000 Tax Admin Fees 581 12/23/2014 Property Taxes/Assessments 2,456.40 2,456.40 GL _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 2,456.40 2,456.40 ** 3,800.00 Budgeted 1,343.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 219,003.96 ** 336,291.00 Budgeted 117,287.04 Remaining 65 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (7,026.87) .00 Budgeted 7,026.87 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/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 53 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 12/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 54 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 12/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 55 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 12/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 559 12/31/2014 Bank Interest/December (3.13) (.89) (4.02) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (.89) (4.02) ** .00 Budgeted 4.02 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4.02) ** .00 Budgeted 4.02 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 12/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 2,100.00 .00 2,100.00 _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: .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,095.98 3,348.00 Budgeted 1,252.02 Remaining 63 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET DECEMBER 2014 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 5,616,861 ACCOUNTS RECEIVABLE - TOTAL ASSETS 5,616,861 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 152,061 TOTAL LIABILITIES 152,061 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 5,464,800 TOTAL FUND BALANCE 5,464,800 TOTAL LIABILITIES AND FUND BALANCE 5,616,861 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 09:35 01/14/15 Budget Summary with Amendment Fund: 517 MUD 1 Tax Bond Const WWTP Department: Program: Period Ending: 12/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 61.14- 61.14- 61.14 517-49105-000-000 Bond Proceeds 5,616,800.00- 5,616,800.00- 5,616,800.00 Subtotal: 5,616,861.14- 5,616,861.14- 5,616,861.14 Program number: 5,616,861.14- 5,616,861.14- 5,616,861.14 Department number: 5,616,861.14- 5,616,861.14- 5,616,861.14 Revenues Subtotal ----------- 5,616,861.14- 5,616,861.14- 5,616,861.14 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 09:35 01/14/15 Budget Summary with Amendment Fund: 517 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60135-020-000 TCEQ Permits & Fees 14,376.56 14,376.56 14,376.56- Subtotal: 14,376.56 14,376.56 14,376.56- 517-69005-020-000 Capital Outlays 137,685.00 137,685.00 137,685.00- Subtotal: 137,685.00 137,685.00 137,685.00- Program number: 152,061.56 152,061.56 152,061.56- Department number: Wastewater 152,061.56 152,061.56 152,061.56- Expenditures Subtotal ----------- 152,061.56 152,061.56 152,061.56- Fund number: 517 MUD 1 Tax Bond Const WWTP 5,464,799.58- 5,464,799.58- 5,464,799.58 . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 517 MUD 1 Tax Bond Const WWTP Department: Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 559 12/31/2014 Bank Interest/December (61.14) (61.14) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (61.14) (61.14) ** .00 Budgeted 61.14 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds 594 12/23/2014 Tax Bond Sale (5,616,800.00) (5,616,800.00) GL _______________ Account: 517-49105-000-000 Bond Proceeds Totals: (5,616,800.00) (5,616,800.00) ** .00 Budgeted 5,616,800.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,616,861.14) ** .00 Budgeted 5,616,861.14 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 517 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-60135-020-000 TCEQ Permits & Fees 501 12/23/2014 Dec A/P Bond Application Processing Fe 14,376.56 14,376.56 TX COMMISSION ENVIRONMENTAL QU 34502 AP _______________ Account: 517-60135-020-000 TCEQ Permits & Fees Totals: 14,376.56 14,376.56 ** .00 Budgeted (14,376.56) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 615 12/31/2014 Dec A/P Engineering WWTP Expansion 103,130.00 103,130.00 THE WALLACE GROUP, INC. 34558 AP 615 12/31/2014 Dec A/P WWTP Improvements 34,555.00 137,685.00 THE WALLACE GROUP, INC. 34558 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 137,685.00 137,685.00 ** .00 Budgeted (137,685.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 152,061.56 ** .00 Budgeted (152,061.56) Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (5,464,799.58) .00 Budgeted 5,464,799.58 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET DECEMBER 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 272,503 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 222,377 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 499,726 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 222,377 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 222,377 FUND BALANCE ASSIGNED FUND BALANCE 14,753 NET REVENUES / EXPENDITURES 262,597 TOTAL FUND BALANCE 277,350 TOTAL LIABILITIES AND FUND BALANCE 499,726 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 09:35 01/14/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/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- 222,785.69- 252,641.77- 54.213 213,377.23- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 179.13- 1,399.39- 55.976 1,100.61- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 42.05- 298.02- 18.626 1,301.98- Subtotal: 470,119.00- 470,119.00- 223,006.87- 254,339.18- 54.101 215,779.82- 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- 3,299.03- 3,299.97- 879.992 2,924.97 533-49015-000-000 Lease/Rental Income 211,829.00- 211,829.00- 211,829.00- 533-49110-000-000 Premium on Bonds Sold 4,957.90- 4,957.90- 4,957.90 Subtotal: 212,204.00- 212,204.00- 8,256.93- 8,257.87- 3.891 203,946.13- Program number: 1,139,861.00- 1,139,861.00- 231,263.80- 262,597.05- 23.038 877,263.95- Department number: Revenues 1,139,861.00- 1,139,861.00- 231,263.80- 262,597.05- 23.038 877,263.95- Revenues Subtotal ----------- 1,139,861.00- 1,139,861.00- 231,263.80- 262,597.05- 23.038 877,263.95- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 09:35 01/14/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/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- 231,263.80- 262,597.05- ############### 260,672.05 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/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 561 12/01/2014 Property Taxes/Assessments (29,856.08) (3,846.66) (33,702.74) GL 562 12/02/2014 Property Taxes/Assessments (2,046.36) (35,749.10) GL 563 12/03/2014 Property Taxes/Assessments (1,754.48) (37,503.58) GL 564 12/04/2014 Property Taxes/Assessments (1,797.63) (39,301.21) GL 565 12/05/2014 Property Taxes/Assessments (1,779.12) (41,080.33) GL 566 12/08/2014 Property Taxes/Assessments (2,820.20) (43,900.53) GL 567 12/09/2014 Property Taxes/Assessments (2,418.18) (46,318.71) GL 568 12/10/2014 Property Taxes/Assessments (1,866.87) (48,185.58) GL 569 12/11/2014 Property Taxes/Assessments (1,391.13) (49,576.71) GL 570 12/12/2014 Property Taxes/Assessments (4,243.48) (53,820.19) GL 571 12/15/2014 Property Taxes/Assessments (5,068.29) (58,888.48) GL 572 12/16/2014 Property Taxes/Assessments (3,764.01) (62,652.49) GL 573 12/17/2014 Property Taxes/Assessments (3,534.53) (66,187.02) GL 574 12/18/2014 Property Taxes/Assessments (2,024.97) (68,211.99) GL 575 12/19/2014 Property Taxes/Assessments (3,648.35) (71,860.34) GL 576 12/22/2014 Property Taxes/Assessments (4,886.24) (76,746.58) GL 581 12/23/2014 Property Taxes/Assessments (126,831.81) (203,578.39) GL 577 12/24/2014 Property Taxes/Assessments (4,239.63) (207,818.02) GL 578 12/29/2014 Property Taxes/Assessments (18,338.70) (226,156.72) GL 579 12/30/2014 Property Taxes/Assessments (20,561.92) (246,718.64) GL 580 12/31/2014 Property Taxes/Assessments (5,923.13) (252,641.77) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (222,785.69) (252,641.77) ** (466,019.00) Budgeted (213,377.23) Remaining 54 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 561 12/01/2014 Property Taxes/Assessments (1,220.26) (4.33) (1,224.59) GL 566 12/08/2014 Property Taxes/Assessments (71.34) (1,295.93) GL 567 12/09/2014 Property Taxes/Assessments 9.62 (1,286.31) GL 571 12/15/2014 Property Taxes/Assessments (3.15) (1,289.46) GL 577 12/24/2014 Property Taxes/Assessments (34.11) (1,323.57) GL 578 12/29/2014 Property Taxes/Assessments (65.95) (1,389.52) GL 580 12/31/2014 Property Taxes/Assessments (9.87) (1,399.39) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (179.13) (1,399.39) ** (2,500.00) Budgeted (1,100.61) Remaining 56 % Used Account: 533-40015-000-000 Property Taxes/P & I 561 12/01/2014 Property Taxes/Assessments (255.97) (.95) (256.92) GL 566 12/08/2014 Property Taxes/Assessments (16.41) (273.33) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 571 12/15/2014 Property Taxes/Assessments (255.97) (.73) (274.06) GL 577 12/24/2014 Property Taxes/Assessments (7.84) (281.90) GL 578 12/29/2014 Property Taxes/Assessments (13.85) (295.75) GL 580 12/31/2014 Property Taxes/Assessments (2.27) (298.02) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (42.05) (298.02) ** (1,600.00) Budgeted (1,301.98) Remaining 19 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (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 594 12/23/2014 Tax Bond Sale Accrued Interest 12/15-12/23 (.94) (3,296.11) (3,297.05) GL 559 12/31/2014 Bank Interest/December (2.92) (3,299.97) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (3,299.03) (3,299.97) ** (375.00) Budgeted 2,924.97 Remaining 880 % 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 Account: 533-49110-000-000 Premium on Bonds Sold 594 12/23/2014 Tax Bond Sale Bidder's Premium (4,957.90) (4,957.90) GL _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: (4,957.90) (4,957.90) ** .00 Budgeted 4,957.90 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ------------------------------------------------------------------------------------------------ (262,597.05) ** (1,139,861.00) Budgeted (877,263.95) Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 09:36 01/14/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/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: ------------------------------------------------------------------------------------------------------ (262,597.05) (1,925.00) Budgeted 260,672.05 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (6,060,908.23) **** 1,423.00 Budgeted 6,062,331.23 Remaining ########## ******* End of Report *********