Loading...
HomeMy WebLinkAbout2015-12 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET DECEMBER 2015 122 ASSETS FIRE DEPT. INVESTMENTS 696,477 PREPAID EXPENSES 10,558 ADVALOREM PROPERTY TAXES RECEIVABLE 319,756 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 346 UTILITY AND OTHER ACCOUNTS RECEIVABLE 6,446 TOTAL ASSETS 1,033,583 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 320,102 ACCOUNTS AND OTHER PAYABLES 23,408 TOTAL LIABILITIES 343,510 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 156,576 TOTAL FUND BALANCE 690,073 TOTAL LIABILITIES AND FUND BALANCE 1,033,583 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 19:08 01/13/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 404,346.00- 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 542,150.53- 592,626.99- 66.590 297,336.01- 122-40011-000-000 Property Taxes/Fire-Delinquent 121.51- 470.42- 470.42 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 52.48- 177.29- 3.940 4,322.71- Subtotal: 1,299,559.00- 1,299,559.00- 542,324.52- 593,274.70- 45.652 706,284.30- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 800.00- 2,000.00- 40.000 3,000.00- Subtotal: 5,000.00- 5,000.00- 800.00- 2,000.00- 40.000 3,000.00- 122-43400-000-000 Fire Inspections 825.00- 825.00- 150.00- 475.00- 57.576 350.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,825.00- 10,825.00- 150.00- 475.00- 4.388 10,350.00- 122-49900-000-000 Miscellaneous Income 50,000.00- 50,000.00- 1,600.00- 4,500.00- 9.000 45,500.00- Subtotal: 50,000.00- 50,000.00- 1,600.00- 4,500.00- 9.000 45,500.00- Program number: 1,365,384.00- 1,365,384.00- 544,874.52- 600,249.70- 43.962 765,134.30- Department number: Fire Revenues 1,365,384.00- 1,365,384.00- 544,874.52- 600,249.70- 43.962 765,134.30- Revenues Subtotal ----------- 1,365,384.00- 1,365,384.00- 544,874.52- 600,249.70- 43.962 765,134.30- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 19:08 01/13/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 508,226.00 508,226.00 52,822.01 112,095.86 22.056 396,130.14 122-50010-045-000 Overtime 48,735.00 48,735.00 6,773.88 16,502.93 33.863 32,232.07 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 14,643.90 92.379 1,208.10 122-50016-045-000 Longevity 5,761.00 5,761.00 5,730.00 5,730.00 99.462 31.00 122-50017-045-000 Certification 4,200.00 4,200.00 362.50 802.63 19.110 3,397.37 122-50020-045-000 Retirement 75,571.00 75,571.00 8,807.29 20,190.25 26.717 55,380.75 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 4,325.97 11,522.55 17.579 54,023.45 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 355.57 973.99 19.938 3,911.01 122-50028-045-000 Vision Insurance 859.00 859.00 68.55 301.28 35.073 557.72 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 326.08 769.81 16.790 3,815.19 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 3,892.14 8,782.34 24.306 27,349.66 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 910.06 2,053.46 24.301 6,396.54 122-50040-045-000 Unemployment Taxes 1,724.00 1,724.00 1.30 2.36 .137 1,721.64 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 9,379.00 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 250.00 Subtotal: 790,155.00 790,155.00 84,375.35 194,371.36 24.599 595,783.64 122-55030-045-000 Software & Support 6,661.00 6,661.00 925.00 1,387.50 20.830 5,273.50 122-55045-045-000 Legal 2,000.00 2,000.00 2,000.00 122-55080-045-000 Maintenance & Repairs 16,370.00 16,370.00 1,658.33 4,893.43 29.893 11,476.57 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 2,907.59 29.076 7,092.41 Subtotal: 35,031.00 35,031.00 2,583.33 9,188.52 26.230 25,842.48 122-60005-045-000 Telephone 50.00 50.00 11.65 23.300 38.35 122-60010-045-000 Communications/Mobiles 6,653.00 6,653.00 1,593.10- 4,444.89 66.810 2,208.11 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 471.70 745.79 10.062 6,666.21 122-60025-045-000 Water 1,200.00 1,200.00 105.49 457.14 38.095 742.86 122-60026-045-000 Cable 1,920.00 1,920.00 440.02 22.918 1,479.98 122-60030-045-000 Rent And/Or Usage 214,379.00 214,379.00 214,379.00 122-60035-045-000 Postage 50.00 50.00 50.00 122-60055-045-000 Insurance 14,077.00 14,077.00 1,173.09 3,519.27 25.000 10,557.73 122-60066-045-000 Publications/Books/Subscrips 350.00 350.00 350.00 122-60070-045-000 Dues & Memberships 15,582.00 15,582.00 13,190.00 14,841.59 95.248 740.41 122-60080-045-000 Schools & Training 7,880.00 7,880.00 940.00 1,365.00 17.322 6,515.00 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 122-60100-045-000 Travel & per diem 4,081.00 4,081.00 163.89 4.016 3,917.11 122-60110-045-000 Physicals/Testing 4,700.00 4,700.00 4,700.00 122-60125-045-000 Advertising 500.00 500.00 500.00 122-60160-045-000 Programs & Special Projects 7,500.00 7,500.00 688.39 9.179 6,811.61 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 194.00 359.29 71.858 140.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 47.50 209.50 6.580 2,974.50 122-60245-045-000 Miscellaneous Expense 1,001.00 1,001.00 7.50 .749 993.50 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 19:08 01/13/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 292,019.00 292,019.00 14,528.68 27,253.92 9.333 264,765.08 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 473.01 1,269.35 8.394 13,852.65 122-65010-045-000 Uniforms 3,140.00 3,140.00 631.14 1,383.97 44.075 1,756.03 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 9,000.00 122-65030-045-000 Chemicals 600.00 600.00 600.00 122-65035-045-000 Small Tools 2,000.00 2,000.00 1,638.50 1,638.50 81.925 361.50 122-65055-045-000 Hardware 750.00 750.00 750.00 122-65085-045-000 Office Supplies 500.00 500.00 500.00 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 31,610.00 2,742.65 4,291.82 13.577 27,318.18 122-69050-045-000 Radios 8,000.00 8,000.00 8,000.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 216,569.00 216,569.00 208,568.60 96.306 8,000.40 Program number: 1,365,384.00 1,365,384.00 104,230.01 443,674.22 32.494 921,709.78 Department number: Fire 1,365,384.00 1,365,384.00 104,230.01 443,674.22 32.494 921,709.78 Expenditures Subtotal ----------- 1,365,384.00 1,365,384.00 104,230.01 443,674.22 32.494 921,709.78 Fund number: 122 Trophy Club MUD Fire Dept. 440,644.51- 156,575.48- 156,575.48 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2015 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 .00 .00 _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 .00 ** (404,346.00) Budgeted (404,346.00) Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 637 12/01/2015 Property Taxes/Assessments (50,476.46) (2,485.93) (52,962.39) GL 638 12/02/2015 Property Taxes/Assessments (3,784.43) (56,746.82) GL 643 12/03/2015 Property Taxes/Assessments (2,769.91) (59,516.73) GL 644 12/04/2015 Property Taxes/Assessments (3,182.50) (62,699.23) GL 645 12/07/2015 Property Taxes/Assessments (5,907.35) (68,606.58) GL 646 12/08/2015 Property Taxes/Assessments (6,378.44) (74,985.02) GL 647 12/09/2015 Property Taxes/Assessments (6,479.95) (81,464.97) GL 648 12/10/2015 Property Taxes/Assessments (3,524.41) (84,989.38) GL 649 12/11/2015 Property Taxes/Assessments (4,713.50) (89,702.88) GL 650 12/14/2015 Property Taxes/Assessments (1,194.99) (90,897.87) GL 651 12/15/2015 Property Taxes/Assessments (6,422.48) (97,320.35) GL 652 12/16/2015 Property Taxes/Assessments (2,124.07) (99,444.42) GL 653 12/17/2015 Property Taxes/Assessments (10,539.91) (109,984.33) GL 654 12/18/2015 Property Taxes/Assessments (7,748.96) (117,733.29) GL 655 12/21/2015 Property Taxes/Assessments (3,516.67) (121,249.96) GL 656 12/22/2015 Property Taxes/Assessments (4,335.20) (125,585.16) GL 657 12/23/2015 Property Taxes/Assessments (83,207.81) (208,792.97) GL 659 12/28/2015 Property Taxes/Assessments (173,771.91) (382,564.88) GL 660 12/29/2015 Property Taxes/Assessments (20,647.04) (403,211.92) GL 661 12/30/2015 Property Taxes/Assessments (134,605.66) (537,817.58) GL 667 12/31/2015 Property Taxes (54,809.41) (592,626.99) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (542,150.53) (592,626.99) ** (889,963.00) Budgeted (297,336.01) Remaining 67 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 638 12/02/2015 Property Taxes/Assessments (348.91) 6.50 (342.41) GL 655 12/21/2015 Property Taxes/Assessments (40.33) (382.74) GL 659 12/28/2015 Property Taxes/Assessments .91 (381.83) GL 660 12/29/2015 Property Taxes/Assessments (88.59) (470.42) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (121.51) (470.42) ** .00 Budgeted 470.42 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40015-000-000 Property Taxes/Assessments P&I .00 .00 _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 .00 ** (750.00) Budgeted (750.00) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 643 12/03/2015 Property Taxes/Assessments (124.81) .29 (124.52) GL 654 12/18/2015 Property Taxes/Assessments (2.95) (127.47) GL 655 12/21/2015 Property Taxes/Assessments (9.28) (136.75) GL 657 12/23/2015 Property Taxes/Assessments (.59) (137.34) GL 659 12/28/2015 Property Taxes/Assessments (3.31) (140.65) GL 660 12/29/2015 Property Taxes/Assessments (36.64) (177.29) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (52.48) (177.29) ** (4,500.00) Budgeted (4,322.71) Remaining 4 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (1,200.00) (800.00) (2,000.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (800.00) (2,000.00) ** (5,000.00) Budgeted (3,000.00) Remaining 40 % Used Account: 122-43400-000-000 Fire Inspections 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (325.00) (150.00) (475.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (150.00) (475.00) ** (825.00) Budgeted (350.00) Remaining 58 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (2,900.00) (1,600.00) (4,500.00) AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,600.00) (4,500.00) ** (50,000.00) Budgeted (45,500.00) Remaining 9 % Used Department Totals: ------------------------------------------------------------------------------------------------ (600,249.70) ** (1,365,384.00) Budgeted (765,134.30) Remaining 44 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 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 550 12/04/2015 Fire Payroll 12/4/15 59,273.85 17,479.71 76,753.56 GL 511 12/18/2015 Fire Payroll 12/18/15 18,553.27 95,306.83 GL 675 12/31/2015 Fire Payroll 12/31/15 16,789.03 112,095.86 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 52,822.01 112,095.86 ** 508,226.00 Budgeted 396,130.14 Remaining 22 % Used Account: 122-50010-045-000 Overtime 511 12/18/2015 Fire Payroll 12/18/15 9,729.05 6,773.88 16,502.93 GL _______________ Account: 122-50010-045-000 Overtime Totals: 6,773.88 16,502.93 ** 48,735.00 Budgeted 32,232.07 Remaining 34 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,643.90 .00 14,643.90 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,643.90 ** 15,852.00 Budgeted 1,208.10 Remaining 92 % Used Account: 122-50016-045-000 Longevity 551 12/04/2015 FD Payroll/Longevity 2015 5,730.00 5,730.00 GL _______________ Account: 122-50016-045-000 Longevity Totals: 5,730.00 5,730.00 ** 5,761.00 Budgeted 31.00 Remaining 99 % Used Account: 122-50017-045-000 Certification 550 12/04/2015 Fire Payroll 12/4/15 440.13 362.50 802.63 GL _______________ Account: 122-50017-045-000 Certification Totals: 362.50 802.63 ** 4,200.00 Budgeted 3,397.37 Remaining 19 % Used Account: 122-50020-045-000 Retirement 550 12/04/2015 Fire Payroll 12/4/15 11,382.96 2,394.55 13,777.51 GL 551 12/04/2015 FD Payroll/Longevity 2015 782.69 14,560.20 GL 511 12/18/2015 Fire Payroll 12/18/15 3,417.13 17,977.33 GL 675 12/31/2015 Fire Payroll 12/31/15 2,212.92 20,190.25 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50020-045-000 Retirement Totals: 8,807.29 20,190.25 ** 75,571.00 Budgeted 55,380.75 Remaining 27 % Used Account: 122-50026-045-000 Medical Insurance 550 12/04/2015 Fire Payroll 12/4/15 7,196.58 2,584.56 9,781.14 GL 511 12/18/2015 Fire Payroll 12/18/15 1,741.41 11,522.55 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,325.97 11,522.55 ** 65,546.00 Budgeted 54,023.45 Remaining 18 % Used Account: 122-50027-045-000 Dental Insurance 550 12/04/2015 Fire Payroll 12/4/15 618.42 177.53 795.95 GL 511 12/18/2015 Fire Payroll 12/18/15 178.04 973.99 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 355.57 973.99 ** 4,885.00 Budgeted 3,911.01 Remaining 20 % Used Account: 122-50028-045-000 Vision Insurance 550 12/04/2015 Fire Payroll 12/4/15 232.73 34.21 266.94 GL 511 12/18/2015 Fire Payroll 12/18/15 34.34 301.28 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 68.55 301.28 ** 859.00 Budgeted 557.72 Remaining 35 % Used Account: 122-50029-045-000 Life Insurance & Other 550 12/04/2015 Fire Payroll 12/4/15 443.73 162.81 606.54 GL 511 12/18/2015 Fire Payroll 12/18/15 163.27 769.81 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 326.08 769.81 ** 4,585.00 Budgeted 3,815.19 Remaining 17 % Used Account: 122-50030-045-000 Social Security Taxes 550 12/04/2015 Fire Payroll 12/4/15 4,890.20 1,015.97 5,906.17 GL 551 12/04/2015 FD Payroll/Longevity 2015 355.26 6,261.43 GL 511 12/18/2015 Fire Payroll 12/18/15 1,480.00 7,741.43 GL 675 12/31/2015 Fire Payroll 12/31/15 1,040.91 8,782.34 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,892.14 8,782.34 ** 36,132.00 Budgeted 27,349.66 Remaining 24 % Used Account: 122-50035-045-000 Medicare Taxes 550 12/04/2015 Fire Payroll 12/4/15 1,143.40 237.56 1,380.96 GL 551 12/04/2015 FD Payroll/Longevity 2015 83.05 1,464.01 GL 511 12/18/2015 Fire Payroll 12/18/15 346.08 1,810.09 GL 675 12/31/2015 Fire Payroll 12/31/15 243.37 2,053.46 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 910.06 2,053.46 ** 8,450.00 Budgeted 6,396.54 Remaining 24 % Used Account: 122-50040-045-000 Unemployment Taxes 550 12/04/2015 Fire Payroll 12/4/15 1.06 .23 1.29 GL 511 12/18/2015 Fire Payroll 12/18/15 .39 1.68 GL 675 12/31/2015 Fire Payroll 12/31/15 .68 2.36 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 1.30 2.36 ** 1,724.00 Budgeted 1,721.64 Remaining 0 % Used Account: 122-50045-045-000 Workman's Compensation .00 .00 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 .00 ** 9,379.00 Budgeted 9,379.00 Remaining 0 % 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-55030-045-000 Software & Support 535 12/22/2015 December A/P Charter, Mercury, Gexa bills 462.50 462.50 925.00 TOWN OF TROPHY CLUB 1334 AP 535 12/22/2015 December A/P Charter, Mercury, Gexa bills 462.50 1,387.50 TOWN OF TROPHY CLUB 1334 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 925.00 1,387.50 ** 6,661.00 Budgeted 5,273.50 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55045-045-000 Legal .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 574 12/31/2015 December A/P Annual maint for cascade syste 3,235.10 698.00 3,933.10 AUGUST INDUSTRIES, INC 1338 AP 574 12/31/2015 December A/P Rug cleaning 37.24 3,970.34 G & K SERVICES 1345 AP 574 12/31/2015 December A/P Rug cleaning 37.24 4,007.58 G & K SERVICES 1345 AP 574 12/31/2015 December A/P Generator maint - Fire 353.09 4,360.67 CANTWELL POWER SOLUTIONS 1341 AP 688 12/31/2015 Dec A/P Service FD Generator 570.00 4,930.67 CANTWELL POWER SOLUTIONS 1370 AP 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (37.24) 4,893.43 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,658.33 4,893.43 ** 16,370.00 Budgeted 11,476.57 Remaining 30 % Used Account: 122-55090-045-000 Vehicle Maintenance 2,907.59 .00 2,907.59 _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 2,907.59 ** 10,000.00 Budgeted 7,092.41 Remaining 29 % Used Account: 122-60005-045-000 Telephone 11.65 .00 11.65 _______________ Account: 122-60005-045-000 Telephone Totals: .00 11.65 ** 50.00 Budgeted 38.35 Remaining 23 % Used Account: 122-60010-045-000 Communications/Mobiles 550 12/04/2015 Fire Payroll 12/4/15 6,037.99 75.00 6,112.99 GL 548 12/23/2015 Bill Town Inv 1388 AR 20151223-20151223 User: (2,472.00) 3,640.99 AR 574 12/31/2015 December A/P Verizon bills 173.91 3,814.90 TOWN OF TROPHY CLUB 1358 AP 707 12/31/2015 Recode FD IPAD 629.99 4,444.89 GL _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: (1,593.10) 4,444.89 ** 6,653.00 Budgeted 2,208.11 Remaining 67 % Used Account: 122-60020-045-000 Electricity/Gas . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 494 12/14/2015 December A/P Electricity 11/9 to 12/10/15 274.09 740.06 1,014.15 HUDSON ENERGY SERVICES, LLC 1294 AP 535 12/22/2015 December A/P Gas for fire station 11/14 -12 203.35 1,217.50 ATMOS ENERGY 1315 AP 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (471.71) 745.79 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 471.70 745.79 ** 7,412.00 Budgeted 6,666.21 Remaining 10 % Used Account: 122-60025-045-000 Water 672 12/31/2015 Dec A/P Dec Water 351.65 210.97 562.62 TROPHY CLUB MUD (WATER BILLS) 1416 AP 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (105.48) 457.14 AR _______________ Account: 122-60025-045-000 Water Totals: 105.49 457.14 ** 1,200.00 Budgeted 742.86 Remaining 38 % Used Account: 122-60026-045-000 Cable 440.02 .00 440.02 _______________ Account: 122-60026-045-000 Cable Totals: .00 440.02 ** 1,920.00 Budgeted 1,479.98 Remaining 23 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 214,379.00 Budgeted 214,379.00 Remaining 0 % Used Account: 122-60035-045-000 Postage .00 .00 _______________ Account: 122-60035-045-000 Postage Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 134 12/01/2015 Prepaid Insurance, W/C Dec 2,346.18 1,173.09 3,519.27 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,173.09 3,519.27 ** 14,077.00 Budgeted 10,557.73 Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 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 .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 535 12/22/2015 December A/P FY16 Membership Dues 1,651.59 5,250.00 6,901.59 NORTH EAST FIRE DEPT ASSOC 1327 AP 535 12/22/2015 December A/P Capital Replacement Dues 7,940.00 14,841.59 NORTH EAST FIRE DEPT ASSOC 1327 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 13,190.00 14,841.59 ** 15,582.00 Budgeted 740.41 Remaining 95 % Used Account: 122-60080-045-000 Schools & Training 494 12/14/2015 December A/P Training 425.00 500.00 925.00 CHAMPION RESPONDERS INC 1287 AP 494 12/14/2015 December A/P Certification - Sipes & Tacket 170.00 1,095.00 TX COMM ON FIRE PROTECTION 1306 AP 535 12/22/2015 December A/P Fire Instructor I Certificatio 85.00 1,180.00 TX COMM ON FIRE PROTECTION 1335 AP 535 12/22/2015 December A/P Fire instructor I - Peters 150.00 1,330.00 TARRANT COUNTY COLLEGE 1331 AP 672 12/31/2015 Dec A/P Tackett Certification 35.00 1,365.00 TX COMM ON FIRE PROTECTION 1417 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 940.00 1,365.00 ** 7,880.00 Budgeted 6,515.00 Remaining 17 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem 163.89 .00 163.89 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 163.89 ** 4,081.00 Budgeted 3,917.11 Remaining 4 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 688.39 .00 688.39 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 688.39 ** 7,500.00 Budgeted 6,811.61 Remaining 9 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 672 12/31/2015 Dec A/P TCLEDDS Subscription renewal 165.29 194.00 359.29 THE PRODUCTIVITY CENTER 1411 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 194.00 359.29 ** 500.00 Budgeted 140.71 Remaining 72 % Used Account: 122-60195-045-000 Flags & Repair 574 12/31/2015 December A/P Flag repair 162.00 95.00 257.00 SYMONDS FLAGS & POLES 1356 AP 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (47.50) 209.50 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 47.50 209.50 ** 3,184.00 Budgeted 2,974.50 Remaining 7 % Used Account: 122-60245-045-000 Miscellaneous Expense 7.50 .00 7.50 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 7.50 ** 1,001.00 Budgeted 993.50 Remaining 1 % Used Account: 122-65005-045-000 Fuel & Lube 670 12/31/2015 Dec A/P 11/25-12/24 Fuel purchases 796.34 473.01 1,269.35 US Bank Voyager Fleet Systems 1418 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 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: 473.01 1,269.35 ** 15,122.00 Budgeted 13,852.65 Remaining 8 % Used Account: 122-65010-045-000 Uniforms 494 12/14/2015 December A/P T-shirts 752.83 592.38 1,345.21 Alainavision, Inc 1286 AP 574 12/31/2015 December A/P Pants 187.00 1,532.21 RED THE UNIFORM TAILOR 1355 AP 574 12/31/2015 December A/P Boots 482.90 2,015.11 RED THE UNIFORM TAILOR 1355 AP 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (631.14) 1,383.97 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 631.14 1,383.97 ** 3,140.00 Budgeted 1,756.03 Remaining 44 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 574 12/31/2015 December A/P Verizon bills 629.99 629.99 TOWN OF TROPHY CLUB 1358 AP 672 12/31/2015 Dec A/P K97 Rescue Saw 1,638.50 2,268.49 SIDDONS-MARTIN EMERGENCY GROUP 1406 AP 707 12/31/2015 Recode FD IPAD (629.99) 1,638.50 GL _______________ Account: 122-65035-045-000 Small Tools Totals: 1,638.50 1,638.50 ** 2,000.00 Budgeted 361.50 Remaining 82 % Used Account: 122-65055-045-000 Hardware .00 .00 _______________ Account: 122-65055-045-000 Hardware Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-65085-045-000 Office Supplies .00 .00 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 498.00 Budgeted 498.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 8,000.00 Budgeted 8,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 443,674.22 ** 1,365,384.00 Budgeted 921,709.78 Remaining 32 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (156,575.48) .00 Budgeted 156,575.48 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET DECEMBER 2015 0 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 12/31/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 424,930 - - 424,930 CD-BANK OF THE WEST/THB DEPOSIT 35,000 35,000 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,509,781 - - 1,509,781 INVESTMENTS-TEXPOOL 1,498,486 326,020 - 1,824,506 PREPAID EXPENSES 47,701 - - 47,701 ADVALOREM PROPERTY TAXES RECEIVABLE 18,482 - - 18,482 UTILITY AND OTHER ACCOUNTS RECEIVABLE 548,665 - - 548,665 - TOTAL ASSETS 4,083,645 326,020 - 4,409,665 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 18,482 - - 18,482 ACCOUNTS AND OTHER PAYABLES 463,739 - - 463,739 CUSTOMER DEPOSITS 310,412 - - 310,412 - TOTAL LIABILITIES 792,633 - - 792,633 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 326,020 326,020 NON-SPENDABLE FUND BALANCE 30,686 30,686 ASSIGNED FUND BALANCE 407,000 - 407,000 UNASSIGNED FUND BALANCE 1,592,494 - 8,032 1,600,526 COMMITTED FUND BALANCE 1,159,233 - - 1,159,233 NET REVENUES / EXPENDITURES 101,599 - (8,032) 93,567 - TOTAL FUND BALANCE 3,291,012 326,020 - 3,617,032 - TOTAL LIABILITIES AND FUND BALANCE 4,083,645 326,020 - 4,409,665 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 58,181.00- 58,181.00- 35,432.72- 38,731.65- 66.571 19,449.35- 135-40002-000-000 Property Taxes/Delinquent 14.79- 87.69- 87.69 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 5.21- 26.62- 4.095 623.38- 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 24,739.19- 16.930 121,385.81- Subtotal: 204,956.00- 204,956.00- 35,452.72- 63,585.15- 31.024 141,370.85- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 226,512.74- 904,545.73- 17.805 4,175,698.27- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 151,746.17- 511,369.25- 21.185 1,902,406.75- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 7,784.94- 32,465.38- 35.682 58,519.62- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 1,225.00- 4,500.00- 50.000 4,500.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 350.00- 1,000.00- 50.000 1,000.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 1,050.00- 2,850.00- 51.818 2,650.00- 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 6.30- 5,964.00- 9.724 55,366.00- Subtotal: 7,662,835.00- 7,662,835.00- 388,675.15- 1,462,694.36- 19.088 6,200,140.64- 135-48005-000-000 Utility Fees 69,000.00- 69,000.00- 9,200.00- 48,300.00- 70.000 20,700.00- Subtotal: 69,000.00- 69,000.00- 9,200.00- 48,300.00- 70.000 20,700.00- 135-49010-000-000 Interest Income 6,000.00- 6,000.00- 878.90- 2,371.04- 39.517 3,628.96- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 2,731.59- 25.001 8,194.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-49035-000-000 Prior Year Reserves 8,020.00- 8,020.00- 8,020.00- 135-49075-000-000 Oversize Meter Reimbursement 15,778.00- 15,778.00- 3,773.00- 17,841.80- 113.080 2,063.80 135-49141-000-000 Interfund Transfer In 8,034.36- 8,034.36 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 146.22- 570.05- .901 62,678.95- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 2.00- 10.000 18.00- Subtotal: 110,993.00- 110,993.00- 6,291.98- 33,300.83- 30.003 77,692.17- Program number: 8,047,784.00- 8,047,784.00- 439,619.85- 1,607,880.34- 19.979 6,439,903.66- Department number: Revenues 8,047,784.00- 8,047,784.00- 439,619.85- 1,607,880.34- 19.979 6,439,903.66- Revenues Subtotal ----------- 8,047,784.00- 8,047,784.00- 439,619.85- 1,607,880.34- 19.979 6,439,903.66- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 265,614.00 24,623.27 51,555.56 19.410 214,058.44 135-50010-010-000 Overtime 19,500.00 19,500.00 1,363.83 3,364.76 17.255 16,135.24 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 100.000 135-50017-010-000 Certification 4,200.00 4,200.00 175.00 525.00 12.500 3,675.00 135-50020-010-000 Retirement 25,558.00 25,558.00 2,331.05 5,202.58 20.356 20,355.42 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,776.25 8,976.31 17.464 42,421.69 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 231.52 657.79 16.449 3,341.21 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 149.30 16.407 760.70 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 190.26 573.78 20.470 2,229.22 135-50030-010-000 Social Security Taxes 18,565.00 18,565.00 1,613.46 3,578.08 19.273 14,986.92 135-50035-010-000 Medicare Taxes 4,341.00 4,341.00 377.34 836.79 19.276 3,504.21 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 3.12 4.06 .327 1,237.94 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,229.35 3,688.03 24.997 11,065.97 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 236.45 18.188 1,063.55 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 417,429.00 417,429.00 35,968.43 82,293.49 19.714 335,135.51 135-55005-010-000 Engineering 5,000.00 5,000.00 25,233.33 25,233.33 504.667 20,233.33- 135-55080-010-000 Maintenance & Repairs 85,000.00 85,000.00 764.77 17,815.23 20.959 67,184.77 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 538.49 2,223.23 27.790 5,776.77 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 400.00 937.70 17.049 4,562.30 Subtotal: 107,000.00 107,000.00 26,936.59 46,209.49 43.186 60,790.51 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 694.79 1,489.95 27.592 3,910.05 135-60020-010-000 Electricity 166,823.00 166,823.00 9,579.12 28,982.69 17.373 137,840.31 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 5,773.00 5,773.00 684.00 11.848 5,089.00 135-60090-010-000 Safety Program 400.00 400.00 21.00 5.250 379.00 135-60100-010-000 Travel & per diem 1,400.00 1,400.00 14.25 1.018 1,385.75 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 6,503.50 13.198 42,771.50 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 119,739.56 354,457.53 12.021 2,594,284.47 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 570.49 16.300 2,929.51 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 3,186,763.00 3,186,763.00 130,013.47 392,723.41 12.324 2,794,039.59 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 1,618.41 3,487.69 9.702 32,459.31 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 4,608.00 4,608.00 651.23 14.133 3,956.77 135-65030-010-000 Chemicals 12,000.00 12,000.00 1,480.28 3,136.06 26.134 8,863.94 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 1,000.00 135-65050-010-000 Meter Expense 115,000.00 115,000.00 32,459.66- 18,805.34 16.352 96,194.66 135-65053-010-000 Meter Change Out Program 50,000.00 50,000.00 44,700.00 44,700.00 89.400 5,300.00 Subtotal: 219,755.00 219,755.00 15,339.03 70,780.32 32.209 148,974.68 135-69005-010-000 Capital Outlays 201,000.00 201,000.00 49,025.85 24.391 151,974.15 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,720.00 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 1,209.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 126,958.00 126,958.00 80,986.69 63.790 45,971.31 Subtotal: 534,887.00 534,887.00 205,012.54 38.328 329,874.46 Program number: 4,465,834.00 4,465,834.00 208,257.52 797,019.25 17.847 3,668,814.75 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/2015 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 240.00 4.800 4,760.00 Subtotal: 5,000.00 5,000.00 160.00 240.00 4.800 4,760.00 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 240.00 2.400 9,760.00 Department number: Water 4,475,834.00 4,475,834.00 208,417.52 797,259.25 17.813 3,678,574.75 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 43,170.29 82,687.76 23.513 268,983.24 135-50010-020-000 Overtime 19,500.00 19,500.00 4,275.98 6,972.87 35.758 12,527.13 135-50016-020-000 Longevity 6,125.00 6,125.00 6,125.00 100.000 135-50017-020-000 Certification 7,200.00 7,200.00 625.00 1,725.00 23.958 5,475.00 135-50020-020-000 Retirement 33,652.00 33,652.00 4,283.15 8,688.20 25.818 24,963.80 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 6,626.59 14,136.81 21.423 51,852.19 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 334.55 814.62 19.470 3,369.38 135-50028-020-000 Vision Insurance 972.00 972.00 78.05 188.65 19.408 783.35 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 292.95 878.85 24.045 2,776.15 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 2,773.71 5,591.24 22.669 19,073.76 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 648.69 1,307.60 22.670 4,460.40 135-50040-020-000 Unemployment Taxes 1,449.00 1,449.00 6.57 6.57 .453 1,442.43 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 776.43 2,329.30 25.001 6,987.70 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 238.45 79.483 61.55 135-50070-020-000 Employee Relations 650.00 650.00 650.00 Subtotal: 535,097.00 535,097.00 63,891.96 131,690.92 24.611 403,406.08 135-55070-020-000 Independent Labor 50,000.00 50,000.00 50,000.00 135-55080-020-000 Maintenance & Repairs 72,600.00 72,600.00 1,248.17 12,845.75 17.694 59,754.25 135-55090-020-000 Vehicle Maintenance 5,000.00 5,000.00 145.88 2.918 4,854.12 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 2,252.77 5,832.20 10.604 49,167.80 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 4,186.00 7,984.00 22.811 27,016.00 Subtotal: 218,100.00 218,100.00 7,686.94 26,807.83 12.292 191,292.17 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 835.17 1,578.81 29.237 3,821.19 135-60020-020-000 Electricity 161,582.00 161,582.00 12,509.91 24,134.85 14.937 137,447.15 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 3,771.00 3,771.00 3,771.00 135-60090-020-000 Safety Program 550.00 550.00 39.00 7.091 511.00 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 1,600.00 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 9,439.28 25.409 27,710.72 135-60245-020-000 Miscellaneous Expenses 297.00 297.00 297.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706.00 119,706.00 119,706.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 444,831.00 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 61,668.00 50.000 61,668.00 Subtotal: 908,423.00 908,423.00 13,345.08 96,859.94 10.662 811,563.06 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 32,021.00 32,021.00 633.71 1,987.09 6.206 30,033.91 135-65010-020-000 Uniforms 4,241.00 4,241.00 326.00 2,207.76 52.058 2,033.24 135-65030-020-000 Chemicals 27,000.00 27,000.00 2,252.05 8,408.42 31.142 18,591.58 135-65035-020-000 Small Tools 2,000.00 2,000.00 2,000.00 135-65040-020-000 Safety Equipment 750.00 750.00 414.59 55.279 335.41 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 314.04 3,255.21 25.040 9,744.79 Subtotal: 79,012.00 79,012.00 3,525.80 16,273.07 20.596 62,738.93 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 23,604.83 23,604.83 15.737 126,395.17 135-69008-020-000 Short Term Debt-Principal 21,280.00 21,280.00 21,280.00 135-69009-020-000 Short Term Debt-Interest 197.00 197.00 197.00 Subtotal: 171,477.00 171,477.00 23,604.83 23,604.83 13.766 147,872.17 Program number: 1,912,109.00 1,912,109.00 112,054.61 295,236.59 15.440 1,616,872.41 Department number: Wastewater 1,912,109.00 1,912,109.00 112,054.61 295,236.59 15.440 1,616,872.41 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60020-021-000 Electricity .01- Subtotal: .01- Program number: .01- Department number: Collection .01- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 12,500.00 12,500.00 1,000.00 1,500.00 12.000 11,000.00 135-50030-026-000 Social Security Taxes 775.00 775.00 62.00 93.00 12.000 682.00 135-50035-026-000 Medicare Taxes 181.00 181.00 14.50 21.75 12.017 159.25 135-50040-026-000 Unemployment Taxes 230.00 230.00 1.00 1.50 .652 228.50 135-50045-026-000 Workman's Compensation 37.00 37.00 3.08 9.25 25.000 27.75 Subtotal: 13,723.00 13,723.00 1,080.58 1,625.50 11.845 12,097.50 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 6.00 .500 1,194.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 550.00 13.750 3,450.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 50.48 2.524 1,949.52 Subtotal: 12,850.00 12,850.00 606.48 4.720 12,243.52 Program number: 26,573.00 26,573.00 1,080.58 2,231.98 8.399 24,341.02 Department number: Board of Directors 26,573.00 26,573.00 1,080.58 2,231.98 8.399 24,341.02 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 488,508.00 488,508.00 55,889.85 115,487.11 23.641 373,020.89 135-50010-030-000 Overtime 1,000.00 1,000.00 32.11 79.69 7.969 920.31 135-50016-030-000 Longevity 3,823.00 3,823.00 3,822.50 99.987 .50 135-50020-030-000 Retirement 43,202.00 43,202.00 4,982.67 10,637.63 24.623 32,564.37 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 6,386.29 14,663.63 21.502 53,532.37 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 364.24 947.83 19.718 3,859.17 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 84.38 219.63 19.715 894.37 135-50029-030-000 Life Insurance & Other 4,431.00 4,431.00 382.84 1,144.08 25.820 3,286.92 135-50030-030-000 Social Security Taxes 30,823.00 30,823.00 3,278.39 6,985.05 22.662 23,837.95 135-50035-030-000 Medicare Taxes 7,599.00 7,599.00 766.71 1,633.59 21.497 5,965.41 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 1,449.00 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.89 443.67 28.550 1,110.33 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 381.44 1,347.55 26.951 3,652.45 Subtotal: 662,006.00 662,006.00 72,696.81 157,411.96 23.778 504,594.04 135-55030-030-000 Software & Support 78,483.00 78,483.00 1,739.56 6,193.72 7.892 72,289.28 135-55070-030-000 Independent Labor 12,000.00 12,000.00 12,230.73 12,825.73 106.881 825.73- 135-55080-030-000 Maintenance & Repairs 29,500.00 29,500.00 3,001.16 7,724.66 26.185 21,775.34 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 130.89 867.67 12.395 6,132.33 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 584.75 910.50 8.993 9,214.50 135-55160-030-000 Professional Outside Services 61,075.00 61,075.00 495.00 51,570.00 84.437 9,505.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 640.15 1,886.75 23.009 6,313.25 Subtotal: 206,583.00 206,583.00 18,822.24 81,979.03 39.683 124,603.97 135-60005-030-000 Telephone 16,349.00 16,349.00 405.40 2,875.91 17.591 13,473.09 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 375.98 1,051.96 25.348 3,098.04 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 814.79 814.79 7.567 9,953.21 135-60025-030-000 Water 1,500.00 1,500.00 54.30 246.24 16.416 1,253.76 135-60035-030-000 Postage 28,932.00 28,932.00 1,774.13 6,081.65 21.020 22,850.35 135-60040-030-000 Service Charges & Fees 44,000.00 44,000.00 5,544.30 18,327.72 41.654 25,672.28 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 3,500.00 135-60055-030-000 Insurance 52,797.00 52,797.00 2,756.00 8,368.00 15.849 44,429.00 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 4,696.25 4,896.25 81.604 1,103.75 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 5,000.00 5,000.00 126.00 187.65 3.753 4,812.35 135-60080-030-000 Schools & Training 9,935.00 9,935.00 459.00 4.620 9,476.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 339.02 730.02 13.519 4,669.98 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 7,500.00 7,500.00 7,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 7,500.00 7,500.00 675.36 9.005 6,824.64 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,501.00 17,501.00 55.07 422.98 2.417 17,078.02 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 226,882.00 226,882.00 16,941.24 45,137.53 19.895 181,744.47 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,855.00 135-65055-030-000 Hardware 29,594.00 29,594.00 5,871.85 5,871.85 19.841 23,722.15 135-65085-030-000 Office Supplies 9,000.00 9,000.00 888.10 1,340.71 14.897 7,659.29 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 221.30 5.528 3,781.70 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 1,020.41 20.408 3,979.59 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 Subtotal: 54,252.00 54,252.00 6,759.95 8,454.27 15.583 45,797.73 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 56,000.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 235.56 762.34 16.573 3,837.66 Subtotal: 60,600.00 60,600.00 235.56 762.34 1.258 59,837.66 Program number: 1,210,323.00 1,210,323.00 115,455.80 293,745.13 24.270 916,577.87 Department number: Administration 1,210,323.00 1,210,323.00 115,455.80 293,745.13 24.270 916,577.87 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 19:08 01/13/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 386,130.00 386,130.00 1,634.49 94,864.49 24.568 291,265.51 135-55055-039-000 Auditing 22,750.00 22,750.00 11,245.50 16,245.50 71.409 6,504.50 135-55060-039-000 Appraisal 10,265.00 10,265.00 1,994.51 4,229.90 41.207 6,035.10 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,468.82 2,468.82 64.969 1,331.18 Subtotal: 422,945.00 422,945.00 17,343.32 117,808.71 27.854 305,136.29 Program number: 422,945.00 422,945.00 17,343.32 117,808.71 27.854 305,136.29 Department number: Non Departmental 422,945.00 422,945.00 17,343.32 117,808.71 27.854 305,136.29 Expenditures Subtotal ----------- 8,047,784.00 8,047,784.00 454,351.82 1,506,281.66 18.717 6,541,502.34 Fund number: 135 MUD 1 General Fund 14,731.97 101,598.68- 101,598.68 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 19:08 01/13/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 19:08 01/13/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 2.77- 2.77 Subtotal: 2.77- 2.77 Program number: 2.77- 2.77 Department number: 2.77- 2.77 Revenues Subtotal ----------- 2.77- 2.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 19:08 01/13/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 8,034.36- Subtotal: 8,034.36 8,034.36- Program number: 8,034.36 8,034.36- Department number: Wastewater 8,034.36 8,034.36- Expenditures Subtotal ----------- 8,034.36 8,034.36- Fund number: 507 MUD 1 Capital Projects 8,031.59 8,031.59- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2015 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 637 12/01/2015 Property Taxes/Assessments (3,298.93) (162.47) (3,461.40) GL 638 12/02/2015 Property Taxes/Assessments (247.33) (3,708.73) GL 643 12/03/2015 Property Taxes/Assessments (181.03) (3,889.76) GL 644 12/04/2015 Property Taxes/Assessments (207.99) (4,097.75) GL 645 12/07/2015 Property Taxes/Assessments (386.08) (4,483.83) GL 646 12/08/2015 Property Taxes/Assessments (416.87) (4,900.70) GL 647 12/09/2015 Property Taxes/Assessments (423.50) (5,324.20) GL 648 12/10/2015 Property Taxes/Assessments (230.34) (5,554.54) GL 649 12/11/2015 Property Taxes/Assessments (308.06) (5,862.60) GL 650 12/14/2015 Property Taxes/Assessments (78.10) (5,940.70) GL 651 12/15/2015 Property Taxes/Assessments (419.75) (6,360.45) GL 652 12/16/2015 Property Taxes/Assessments (138.82) (6,499.27) GL 653 12/17/2015 Property Taxes/Assessments (688.84) (7,188.11) GL 654 12/18/2015 Property Taxes/Assessments (506.44) (7,694.55) GL 655 12/21/2015 Property Taxes/Assessments (229.84) (7,924.39) GL 656 12/22/2015 Property Taxes/Assessments (283.33) (8,207.72) GL 657 12/23/2015 Property Taxes/Assessments (5,438.12) (13,645.84) GL 659 12/28/2015 Property Taxes/Assessments (11,357.01) (25,002.85) GL 660 12/29/2015 Property Taxes/Assessments (1,349.41) (26,352.26) GL 661 12/30/2015 Property Taxes/Assessments (8,797.27) (35,149.53) GL 667 12/31/2015 Property Taxes (3,582.12) (38,731.65) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (35,432.72) (38,731.65) ** (58,181.00) Budgeted (19,449.35) Remaining 67 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 638 12/02/2015 Property Taxes/Assessments (72.90) 1.25 (71.65) GL 655 12/21/2015 Property Taxes/Assessments (7.76) (79.41) GL 659 12/28/2015 Property Taxes/Assessments .14 (79.27) GL 660 12/29/2015 Property Taxes/Assessments (8.42) (87.69) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (14.79) (87.69) ** .00 Budgeted 87.69 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 643 12/03/2015 Property Taxes/Assessments (21.41) .02 (21.39) GL 654 12/18/2015 Property Taxes/Assessments (.19) (21.58) GL 655 12/21/2015 Property Taxes/Assessments (1.78) (23.36) GL 657 12/23/2015 Property Taxes/Assessments (.04) (23.40) GL 659 12/28/2015 Property Taxes/Assessments (.21) (23.61) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 660 12/29/2015 Property Taxes/Assessments (21.41) (3.01) (26.62) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (5.21) (26.62) ** (650.00) Budgeted (623.38) Remaining 4 % Used Account: 135-40025-000-000 PID Surcharges (24,739.19) .00 (24,739.19) _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 (24,739.19) ** (146,125.00) Budgeted (121,385.81) Remaining 17 % Used Account: 135-47000-000-000 Water 589 12/07/2015 UB 12/7/15 Bill adjustments UB20151207-20151207 User: (678,032.99) (30.79) (678,063.78) UB 590 12/18/2015 UB 12/18/15 Billadjt-Fluery UB20151218-20151218 User: 135.32 (677,928.46) UB 597 12/29/2015 UB 12/29/15 read adj UB20151229-20151229 User: 16.65 (677,911.81) UB 598 12/30/2015 UB 12/30/15 Meter misread nov UB20151230-20151230 User: 149.04 (677,762.77) UB 585 12/31/2015 UB 12/31/15 Billing UB20151231-20151231 User: (226,811.46) (904,574.23) UB 599 12/31/2015 UB 12/31/15 Meter misread nov UB20151231-20151231 User: 28.50 (904,545.73) UB _______________ Account: 135-47000-000-000 Water Totals: (226,512.74) (904,545.73) ** (5,080,244.00) Budgeted (4,175,698.27) Remaining 18 % Used Account: 135-47005-000-000 Sewer 589 12/07/2015 UB 12/7/15 Bill adjustments UB20151207-20151207 User: (359,623.08) (26.30) (359,649.38) UB 597 12/29/2015 UB 12/29/15 read adj UB20151229-20151229 User: 13.15 (359,636.23) UB 598 12/30/2015 UB 12/30/15 Meter misread nov UB20151230-20151230 User: 71.01 (359,565.22) UB 585 12/31/2015 UB 12/31/15 Billing UB20151231-20151231 User: (151,828.57) (511,393.79) UB 599 12/31/2015 UB 12/31/15 Meter misread nov UB20151231-20151231 User: 24.54 (511,369.25) UB _______________ Account: 135-47005-000-000 Sewer Totals: (151,746.17) (511,369.25) ** (2,413,776.00) Budgeted (1,902,406.75) Remaining 21 % Used Account: 135-47025-000-000 Penalties 588 12/08/2015 UB 12/8/15 penalty removal UB20151208-20151208 User: (24,680.44) 125.88 (24,554.56) UB 593 12/15/2015 UB 12/15/15 Penalties UB20151215-20151215 User: 145.24 (24,409.32) UB 595 12/20/2015 UB 12/20/15 Penalties UB20151220-20151220 User: 120.51 (24,288.81) UB 534 12/22/2015 UB 12/22/15 Penalties UB20151222-20151222 User: (8,216.57) (32,505.38) UB 596 12/22/2015 UB 12/22/15 Penalty adj UB20151222-20151222 User: 7.00 (32,498.38) UB 598 12/30/2015 UB 12/30/15 Meter misread nov UB20151230-20151230 User: 33.00 (32,465.38) UB . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47025-000-000 Penalties Totals: (7,784.94) (32,465.38) ** (90,985.00) Budgeted (58,519.62) Remaining 36 % Used Account: 135-47030-000-000 Service Charges 467 12/09/2015 UB 12/9/15 Cut Off List UB20151209-20151209 User: (3,275.00) (1,125.00) (4,400.00) UB 591 12/11/2015 UB 12/11/15 NSF Check fee UB20151211-20151211 User: (25.00) (4,425.00) UB 601 12/22/2015 UB 12/22/15 Nsf Check fee UB20151222-20151222 User: (25.00) (4,450.00) UB 603 12/23/2015 UB 12/23/15 NSF Check fee UB20151223-20151223 User: (50.00) (4,500.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,225.00) (4,500.00) ** (9,000.00) Budgeted (4,500.00) Remaining 50 % Used Account: 135-47035-000-000 Plumbing Inspections 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (650.00) (350.00) (1,000.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (350.00) (1,000.00) ** (2,000.00) Budgeted (1,000.00) Remaining 50 % Used Account: 135-47045-000-000 Sewer Inspections 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (1,800.00) (1,050.00) (2,850.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,050.00) (2,850.00) ** (5,500.00) Budgeted (2,650.00) Remaining 52 % Used Account: 135-47070-000-000 TCCC Effluent Charges 585 12/31/2015 UB 12/31/15 Billing UB20151231-20151231 User: (5,957.70) (6.30) (5,964.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (6.30) (5,964.00) ** (61,330.00) Budgeted (55,366.00) Remaining 10 % Used Account: 135-48005-000-000 Utility Fees 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (39,100.00) (9,200.00) (48,300.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (9,200.00) (48,300.00) ** (69,000.00) Budgeted (20,700.00) Remaining 70 % Used Account: 135-49010-000-000 Interest Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 663 12/31/2015 Bank Interest/December (1,492.14) (11.87) (1,504.01) GL 663 12/31/2015 Bank Interest/December (314.19) (1,818.20) GL 663 12/31/2015 Bank Interest/December (320.50) (2,138.70) GL 663 12/31/2015 Bank Interest/December (232.34) (2,371.04) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (878.90) (2,371.04) ** (6,000.00) Budgeted (3,628.96) Remaining 40 % Used Account: 135-49016-000-000 Cell Tower Revenue 539 12/09/2015 AT&T Cell Tower Revenue (1,821.06) (910.53) (2,731.59) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (2,731.59) ** (10,926.00) Budgeted (8,194.41) Remaining 25 % Used Account: 135-49018-000-000 Building Rent Income 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 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-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (8,020.00) Budgeted (8,020.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (14,068.80) (3,773.00) (17,841.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (3,773.00) (17,841.80) ** (15,778.00) Budgeted 2,063.80 Remaining 113 % Used Account: 135-49141-000-000 Interfund Transfer In (8,034.36) .00 (8,034.36) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (8,034.36) ** .00 Budgeted 8,034.36 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49900-000-000 Miscellaneous Income 555 12/23/2015 Tri County Patronage/1998 (423.83) (124.29) (548.12) GL 585 12/31/2015 UB 12/31/15 Billing UB20151231-20151231 User: (21.93) (570.05) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (146.22) (570.05) ** (63,249.00) Budgeted (62,678.95) Remaining 1 % Used Account: 135-49901-000-000 Records Management Revenue (2.00) .00 (2.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (2.00) ** (20.00) Budgeted (18.00) Remaining 10 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,607,880.34) ** (8,047,784.00) Budgeted (6,439,903.66) Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 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 342 12/04/2015 MUD Payroll 12/4/15 Salaries & Wages 26,932.29 8,207.76 35,140.05 PR 502 12/18/2015 MUD Payroll 12/18/15 Salaries & Wages 8,207.75 43,347.80 PR 566 12/31/2015 PR 12-31-15 Salaries & Wages 8,207.76 51,555.56 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 24,623.27 51,555.56 ** 265,614.00 Budgeted 214,058.44 Remaining 19 % Used Account: 135-50010-010-000 Overtime 342 12/04/2015 MUD Payroll 12/4/15 Overtime 2,000.93 546.46 2,547.39 PR 502 12/18/2015 MUD Payroll 12/18/15 Overtime 253.94 2,801.33 PR 566 12/31/2015 PR 12-31-15 Overtime 563.43 3,364.76 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,363.83 3,364.76 ** 19,500.00 Budgeted 16,135.24 Remaining 17 % Used Account: 135-50016-010-000 Longevity 2,945.00 .00 2,945.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,945.00 ** 2,945.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 502 12/18/2015 MUD Payroll 12/18/15 Certification 350.00 175.00 525.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 525.00 ** 4,200.00 Budgeted 3,675.00 Remaining 13 % Used Account: 135-50020-010-000 Retirement 342 12/04/2015 MUD Payroll 12/4/15 Retirement 2,871.53 780.00 3,651.53 PR 502 12/18/2015 MUD Payroll 12/18/15 Retirement 769.54 4,421.07 PR 566 12/31/2015 PR 12-31-15 Retirement 781.51 5,202.58 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,331.05 5,202.58 ** 25,558.00 Budgeted 20,355.42 Remaining 20 % Used Account: 135-50026-010-000 Medical Insurance 342 12/04/2015 MUD Payroll 12/4/15 Medical Insurance 5,200.06 1,888.15 7,088.21 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 502 12/18/2015 MUD Payroll 12/18/15 Medical Insurance 5,200.06 1,888.10 8,976.31 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,776.25 8,976.31 ** 51,398.00 Budgeted 42,421.69 Remaining 17 % Used Account: 135-50027-010-000 Dental Insurance 342 12/04/2015 MUD Payroll 12/4/15 Dental Insurance 426.27 115.76 542.03 PR 502 12/18/2015 MUD Payroll 12/18/15 Dental Insurance 115.76 657.79 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 231.52 657.79 ** 3,999.00 Budgeted 3,341.21 Remaining 16 % Used Account: 135-50028-010-000 Vision Insurance 342 12/04/2015 MUD Payroll 12/4/15 Vision Insurance 95.32 26.97 122.29 PR 502 12/18/2015 MUD Payroll 12/18/15 Vision Insurance 27.01 149.30 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 149.30 ** 910.00 Budgeted 760.70 Remaining 16 % Used Account: 135-50029-010-000 Life Insurance & Other 352 12/01/2015 Dec A/P Dec Dental, Life, ADD, Vision 383.52 181.82 565.34 METLIFE GROUP BENEFITS 1238 AP 574 12/31/2015 December A/P Café 125 admin fees 8.44 573.78 BenefitMall 1339 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 190.26 573.78 ** 2,803.00 Budgeted 2,229.22 Remaining 20 % Used Account: 135-50030-010-000 Social Security Taxes 342 12/04/2015 MUD Payroll 12/4/15 Social Security Taxes 1,964.62 538.46 2,503.08 PR 502 12/18/2015 MUD Payroll 12/18/15 Social Security Taxes 528.58 3,031.66 PR 566 12/31/2015 PR 12-31-15 Social Security Taxes 546.42 3,578.08 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,613.46 3,578.08 ** 18,565.00 Budgeted 14,986.92 Remaining 19 % Used Account: 135-50035-010-000 Medicare Taxes 342 12/04/2015 MUD Payroll 12/4/15 Medicare Taxes 459.45 125.94 585.39 PR 502 12/18/2015 MUD Payroll 12/18/15 Medicare Taxes 123.61 709.00 PR 566 12/31/2015 PR 12-31-15 Medicare Taxes 127.79 836.79 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 377.34 836.79 ** 4,341.00 Budgeted 3,504.21 Remaining 19 % Used Account: 135-50040-010-000 Unemployment Taxes 342 12/04/2015 MUD Payroll 12/4/15 Unemployment Taxes .94 1.04 1.98 PR 502 12/18/2015 MUD Payroll 12/18/15 Unemployment Taxes 1.04 3.02 PR 566 12/31/2015 PR 12-31-15 Unemployment Taxes 1.04 4.06 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 3.12 4.06 ** 1,242.00 Budgeted 1,237.94 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 134 12/01/2015 Prepaid Insurance, W/C Dec 2,458.68 1,229.35 3,688.03 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.35 3,688.03 ** 14,754.00 Budgeted 11,065.97 Remaining 25 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 236.45 .00 236.45 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 236.45 ** 1,300.00 Budgeted 1,063.55 Remaining 18 % 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 535 12/22/2015 December A/P WWTP Permitting 5,260.00 5,260.00 THE WALLACE GROUP, INC. 1333 AP 672 12/31/2015 Dec A/P Solana Water Line Engineering 19,593.33 24,853.33 THE WALLACE GROUP, INC. 1412 AP 688 12/31/2015 Dec A/P Wonderland Plaza Utility Revie 380.00 25,233.33 THE WALLACE GROUP, INC. 1412 AP _______________ Account: 135-55005-010-000 Engineering Totals: 25,233.33 25,233.33 ** 5,000.00 Budgeted (20,233.33) Remaining 505 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 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 495 12/14/2015 December A/P Water parts 17,050.46 385.41 17,435.87 HD SUPPLY WATERWORKS, LTD. 1293 AP 495 12/14/2015 December A/P Water parts 30.36 17,466.23 HD SUPPLY WATERWORKS, LTD. 1293 AP 672 12/31/2015 Dec A/P Chlorinator repair parts 349.00 17,815.23 SCOOP 1405 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 764.77 17,815.23 ** 85,000.00 Budgeted 67,184.77 Remaining 21 % Used Account: 135-55090-010-000 Vehicle Maintenance 494 12/14/2015 December A/P Replace fuel pump on 2007 Dodg 1,684.74 538.49 2,223.23 MICHAEL G. WATSON 1296 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 538.49 2,223.23 ** 8,000.00 Budgeted 5,776.77 Remaining 28 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 494 12/14/2015 December A/P Water Samples - MUD 537.70 200.00 737.70 TARRANT CTY PUBLIC HEALTH LAB 1303 AP 688 12/31/2015 Dec A/P Dec Water samples 200.00 937.70 TARRANT CTY PUBLIC HEALTH LAB 1408 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 400.00 937.70 ** 5,500.00 Budgeted 4,562.30 Remaining 17 % Used Account: 135-60010-010-000 Communications/Mobiles 495 12/14/2015 December A/P Mobile phones 795.16 397.58 1,192.74 VERIZON WIRELESS 1307 AP 688 12/31/2015 Dec A/P Cell phones Dec 297.21 1,489.95 VERIZON WIRELESS 1419 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 694.79 1,489.95 ** 5,400.00 Budgeted 3,910.05 Remaining 28 % Used Account: 135-60020-010-000 Electricity 494 12/14/2015 December A/P Electricity 11/6 - 12/9/15 19,403.57 53.62 19,457.19 HUDSON ENERGY SERVICES, LLC 1294 AP 495 12/14/2015 December A/P Electricity 11/9 - 12/10/15 56.65 19,513.84 HUDSON ENERGY SERVICES, LLC 1294 AP 535 12/22/2015 December A/P Electricity 11/9-12/10/15 9,468.85 28,982.69 HUDSON ENERGY SERVICES, LLC 1321 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60020-010-000 Electricity Totals: 9,579.12 28,982.69 ** 166,823.00 Budgeted 137,840.31 Remaining 17 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 684.00 .00 684.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 684.00 ** 5,773.00 Budgeted 5,089.00 Remaining 12 % Used Account: 135-60090-010-000 Safety Program 21.00 .00 21.00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 21.00 ** 400.00 Budgeted 379.00 Remaining 5 % Used Account: 135-60100-010-000 Travel & per diem 14.25 .00 14.25 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 14.25 ** 1,400.00 Budgeted 1,385.75 Remaining 1 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60105-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 6,503.50 .00 6,503.50 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 6,503.50 ** 49,275.00 Budgeted 42,771.50 Remaining 13 % Used Account: 135-60150-010-000 Wholesale Water 574 12/31/2015 December A/P Wholesale Water 234,717.97 119,739.56 354,457.53 CITY OF FORT WORTH 1342 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 119,739.56 354,457.53 ** 2,948,742.00 Budgeted 2,594,284.47 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 570.49 .00 570.49 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 570.49 ** 3,500.00 Budgeted 2,929.51 Remaining 16 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 492 12/14/2015 Bill Town/Inv 1387 AR 20151214-20151214 User: 1,869.28 (128.65) 1,740.63 AR 609 12/14/2015 Reverse Town Inv 1387 AR 20151214-20151214 User: 128.65 1,869.28 AR 574 12/31/2015 December A/P Generator maint - water/portab 400.00 2,269.28 CANTWELL POWER SOLUTIONS 1341 AP 670 12/31/2015 Dec A/P 11/25-12/24 Fuel purchases 688.41 2,957.69 US Bank Voyager Fleet Systems 1418 AP 688 12/31/2015 Dec A/P Service MUD bldg. generator 530.00 3,487.69 CANTWELL POWER SOLUTIONS 1370 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,618.41 3,487.69 ** 35,947.00 Budgeted 32,459.31 Remaining 10 % Used Account: 135-65010-010-000 Uniforms 651.23 .00 651.23 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 651.23 ** 4,608.00 Budgeted 3,956.77 Remaining 14 % Used Account: 135-65030-010-000 Chemicals 495 12/14/2015 December A/P Chemicals 1,655.78 950.57 2,606.35 HACH COMPANY 1292 AP 574 12/31/2015 December A/P Chlorine 529.71 3,136.06 DPC INDUSTRIES, INC 1343 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,480.28 3,136.06 ** 12,000.00 Budgeted 8,863.94 Remaining 26 % 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 .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense 523 12/21/2015 Recode Atlas Inv 182850 51,265.00 (38,580.00) 12,685.00 GL 535 12/22/2015 December A/P Meters 6,120.34 18,805.34 ATLAS UTILITY SUPPLY CO. 1314 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: (32,459.66) 18,805.34 ** 115,000.00 Budgeted 96,194.66 Remaining 16 % Used Account: 135-65053-010-000 Meter Change Out Program 523 12/21/2015 Recode Atlas Inv 182850 38,580.00 38,580.00 GL 535 12/22/2015 December A/P Meter Change Out 6,120.00 44,700.00 ATLAS UTILITY SUPPLY CO. 1314 AP _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: 44,700.00 44,700.00 ** 50,000.00 Budgeted 5,300.00 Remaining 89 % Used Account: 135-69005-010-000 Capital Outlays 49,025.85 .00 49,025.85 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 49,025.85 ** 201,000.00 Budgeted 151,974.15 Remaining 24 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 130,720.00 Budgeted 130,720.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 ** 1,209.00 Budgeted 1,209.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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69281-010-000 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 ** 126,958.00 Budgeted 45,971.31 Remaining 64 % Used Account: 135-55135-010-001 Lab Analysis for PID 494 12/14/2015 December A/P Water samples - PID 80.00 80.00 160.00 TARRANT CTY PUBLIC HEALTH LAB 1303 AP 688 12/31/2015 Dec A/P Dec Water Samples/PID 80.00 240.00 TARRANT CTY PUBLIC HEALTH LAB 1408 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 160.00 240.00 ** 5,000.00 Budgeted 4,760.00 Remaining 5 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 797,259.25 ** 4,475,834.00 Budgeted 3,678,574.75 Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 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 342 12/04/2015 MUD Payroll 12/4/15 Salaries & Wages 39,517.47 14,222.79 53,740.26 PR 502 12/18/2015 MUD Payroll 12/18/15 Salaries & Wages 14,722.79 68,463.05 PR 566 12/31/2015 PR 12-31-15 Salaries & Wages 14,224.71 82,687.76 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 43,170.29 82,687.76 ** 351,671.00 Budgeted 268,983.24 Remaining 24 % Used Account: 135-50010-020-000 Overtime 342 12/04/2015 MUD Payroll 12/4/15 Overtime 2,696.89 1,818.17 4,515.06 PR 502 12/18/2015 MUD Payroll 12/18/15 Overtime 1,124.29 5,639.35 PR 566 12/31/2015 PR 12-31-15 Overtime 1,333.52 6,972.87 PR _______________ Account: 135-50010-020-000 Overtime Totals: 4,275.98 6,972.87 ** 19,500.00 Budgeted 12,527.13 Remaining 36 % Used Account: 135-50016-020-000 Longevity 6,125.00 .00 6,125.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,125.00 ** 6,125.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 502 12/18/2015 MUD Payroll 12/18/15 Certification 1,100.00 625.00 1,725.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 1,725.00 ** 7,200.00 Budgeted 5,475.00 Remaining 24 % Used Account: 135-50020-020-000 Retirement 342 12/04/2015 MUD Payroll 12/4/15 Retirement 4,405.05 1,429.25 5,834.30 PR 502 12/18/2015 MUD Payroll 12/18/15 Retirement 1,467.65 7,301.95 PR 566 12/31/2015 PR 12-31-15 Retirement 1,386.25 8,688.20 PR _______________ Account: 135-50020-020-000 Retirement Totals: 4,283.15 8,688.20 ** 33,652.00 Budgeted 24,963.80 Remaining 26 % Used Account: 135-50026-020-000 Medical Insurance 342 12/04/2015 MUD Payroll 12/4/15 Medical Insurance 7,510.22 3,313.32 10,823.54 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 502 12/18/2015 MUD Payroll 12/18/15 Medical Insurance 7,510.22 3,313.27 14,136.81 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 6,626.59 14,136.81 ** 65,989.00 Budgeted 51,852.19 Remaining 21 % Used Account: 135-50027-020-000 Dental Insurance 342 12/04/2015 MUD Payroll 12/4/15 Dental Insurance 480.07 167.27 647.34 PR 502 12/18/2015 MUD Payroll 12/18/15 Dental Insurance 167.28 814.62 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 334.55 814.62 ** 4,184.00 Budgeted 3,369.38 Remaining 19 % Used Account: 135-50028-020-000 Vision Insurance 342 12/04/2015 MUD Payroll 12/4/15 Vision Insurance 110.60 39.00 149.60 PR 502 12/18/2015 MUD Payroll 12/18/15 Vision Insurance 39.05 188.65 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 188.65 ** 972.00 Budgeted 783.35 Remaining 19 % Used Account: 135-50029-020-000 Life Insurance & Other 352 12/01/2015 Dec A/P Dec Dental, Life, ADD, Vision 585.90 259.17 845.07 METLIFE GROUP BENEFITS 1238 AP 574 12/31/2015 December A/P Café 125 admin fees 33.78 878.85 BenefitMall 1339 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 292.95 878.85 ** 3,655.00 Budgeted 2,776.15 Remaining 24 % Used Account: 135-50030-020-000 Social Security Taxes 342 12/04/2015 MUD Payroll 12/4/15 Social Security Taxes 2,817.53 900.36 3,717.89 PR 502 12/18/2015 MUD Payroll 12/18/15 Social Security Taxes 906.13 4,624.02 PR 566 12/31/2015 PR 12-31-15 Social Security Taxes 967.22 5,591.24 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,773.71 5,591.24 ** 24,665.00 Budgeted 19,073.76 Remaining 23 % Used Account: 135-50035-020-000 Medicare Taxes 342 12/04/2015 MUD Payroll 12/4/15 Medicare Taxes 658.91 210.57 869.48 PR 502 12/18/2015 MUD Payroll 12/18/15 Medicare Taxes 211.92 1,081.40 PR 566 12/31/2015 PR 12-31-15 Medicare Taxes 226.20 1,307.60 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 648.69 1,307.60 ** 5,768.00 Budgeted 4,460.40 Remaining 23 % Used Account: 135-50040-020-000 Unemployment Taxes 342 12/04/2015 MUD Payroll 12/4/15 Unemployment Taxes 2.16 2.16 PR 502 12/18/2015 MUD Payroll 12/18/15 Unemployment Taxes 2.25 4.41 PR 566 12/31/2015 PR 12-31-15 Unemployment Taxes 2.16 6.57 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 6.57 6.57 ** 1,449.00 Budgeted 1,442.43 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 134 12/01/2015 Prepaid Insurance, W/C Dec 1,552.87 776.43 2,329.30 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.43 2,329.30 ** 9,317.00 Budgeted 6,987.70 Remaining 25 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 238.45 .00 238.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 238.45 ** 300.00 Budgeted 61.55 Remaining 79 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 650.00 Budgeted 650.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 494 12/14/2015 December A/P Replace 3 phase monitor on bel 11,597.58 465.00 12,062.58 DHS AUTOMATION, INC 1290 AP 574 12/31/2015 December A/P Repair for LS#3 control panel 688.17 12,750.75 NORTH TEXAS PUMP CO. 1349 AP 574 12/31/2015 December A/P Repair gate at WWTP 95.00 12,845.75 Alan's Gates, Inc. 1337 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 1,248.17 12,845.75 ** 72,600.00 Budgeted 59,754.25 Remaining 18 % Used Account: 135-55090-020-000 Vehicle Maintenance 145.88 .00 145.88 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 145.88 ** 5,000.00 Budgeted 4,854.12 Remaining 3 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 494 12/14/2015 December A/P Sludge hauling 3,579.43 1,513.82 5,093.25 L.H. CHANEY MATERIALS, INC. 1295 AP 494 12/14/2015 December A/P Sludge hauling 738.95 5,832.20 L.H. CHANEY MATERIALS, INC. 1295 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,252.77 5,832.20 ** 55,000.00 Budgeted 49,167.80 Remaining 11 % Used Account: 135-55135-020-000 Lab Analysis 535 12/22/2015 December A/P Lab analysis 3,798.00 176.00 3,974.00 OXIDOR LABORATORIES LLC 1328 AP 535 12/22/2015 December A/P Lab analysis 246.00 4,220.00 OXIDOR LABORATORIES LLC 1328 AP 535 12/22/2015 December A/P Lab analysis 246.00 4,466.00 OXIDOR LABORATORIES LLC 1328 AP 535 12/22/2015 December A/P Lab analysis 176.00 4,642.00 OXIDOR LABORATORIES LLC 1328 AP 535 12/22/2015 December A/P Lab analysis 246.00 4,888.00 OXIDOR LABORATORIES LLC 1328 AP 535 12/22/2015 December A/P Lab analysis mercury 2,323.00 7,211.00 OXIDOR LABORATORIES LLC 1328 AP 535 12/22/2015 December A/P Lab analysis 176.00 7,387.00 OXIDOR LABORATORIES LLC 1328 AP 574 12/31/2015 December A/P Lab analysis 246.00 7,633.00 OXIDOR LABORATORIES LLC 1352 AP 574 12/31/2015 December A/P Lab analysis 175.00 7,808.00 OXIDOR LABORATORIES LLC 1352 AP 574 12/31/2015 December A/P 176.00 7,984.00 OXIDOR LABORATORIES LLC 1352 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 4,186.00 7,984.00 ** 35,000.00 Budgeted 27,016.00 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-020-000 Communications/Mobiles 495 12/14/2015 December A/P Mobile phones 743.64 573.09 1,316.73 VERIZON WIRELESS 1307 AP 688 12/31/2015 Dec A/P Cell phones Dec 262.08 1,578.81 VERIZON WIRELESS 1419 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 835.17 1,578.81 ** 5,400.00 Budgeted 3,821.19 Remaining 29 % Used Account: 135-60020-020-000 Electricity 494 12/14/2015 December A/P Electricity 11/6 - 12/9/15 11,624.94 67.26 11,692.20 HUDSON ENERGY SERVICES, LLC 1294 AP 494 12/14/2015 December A/P Electricity 11/6 - 12/9/15 46.59 11,738.79 HUDSON ENERGY SERVICES, LLC 1294 AP 495 12/14/2015 December A/P Electricity 11/9 - 12/10/2015 101.28 11,840.07 HUDSON ENERGY SERVICES, LLC 1294 AP 495 12/14/2015 December A/P Electricity 11/9 - 12/10/15 538.65 12,378.72 HUDSON ENERGY SERVICES, LLC 1294 AP 535 12/22/2015 December A/P Electricity 11/09-12/10/15 10,467.76 22,846.48 HUDSON ENERGY SERVICES, LLC 1321 AP 574 12/31/2015 December A/P Electricity for temp trailer W 1,035.10 23,881.58 MP2 ENERGY TEXAS LLC 1348 AP 688 12/31/2015 Dec A/P Electric 11/25-12/29/15 202.28 24,083.86 TRI COUNTY ELECTRIC 1415 AP 688 12/31/2015 Dec A/P Electricity 11/25-12/29/15 28.10 24,111.96 TRI COUNTY ELECTRIC 1415 AP 688 12/31/2015 Dec A/P Electricity 11/25-12/29/15 345.01 24,456.97 TRI COUNTY ELECTRIC 1415 AP 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (322.13) 24,134.84 AR 708 12/31/2015 Correct coding on electricity .01 24,134.85 GL _______________ Account: 135-60020-020-000 Electricity Totals: 12,509.91 24,134.85 ** 161,582.00 Budgeted 137,447.15 Remaining 15 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 3,771.00 Budgeted 3,771.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60090-020-000 Safety Program 39.00 .00 39.00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 39.00 ** 550.00 Budgeted 511.00 Remaining 7 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % 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 9,439.28 .00 9,439.28 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 9,439.28 ** 37,150.00 Budgeted 27,710.72 Remaining 25 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 297.00 Budgeted 297.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-60331-020-000 Interfund Transfer Out-Tax I&S . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 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-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 .00 ** 119,706.00 Budgeted 119,706.00 Remaining 0 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S .00 .00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 .00 ** 444,831.00 Budgeted 444,831.00 Remaining 0 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 61,668.00 .00 61,668.00 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 61,668.00 ** 123,336.00 Budgeted 61,668.00 Remaining 50 % Used Account: 135-65005-020-000 Fuel & Lube 670 12/31/2015 Dec A/P 11/25-12/24 Fuel purchases 1,353.38 633.71 1,987.09 US Bank Voyager Fleet Systems 1418 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 633.71 1,987.09 ** 32,021.00 Budgeted 30,033.91 Remaining 6 % Used Account: 135-65010-020-000 Uniforms 535 12/22/2015 December A/P Shirts 1,881.76 51.00 1,932.76 PANDA EMBROIDERY 1329 AP 574 12/31/2015 December A/P Uniforms 275.00 2,207.76 PANDA EMBROIDERY 1353 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 326.00 2,207.76 ** 4,241.00 Budgeted 2,033.24 Remaining 52 % Used Account: 135-65030-020-000 Chemicals 535 12/22/2015 December A/P Calc Hypochlorite 6,156.37 2,252.05 8,408.42 HARCROS CHEMICALS INC 1319 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,252.05 8,408.42 ** 27,000.00 Budgeted 18,591.58 Remaining 31 % Used Account: 135-65035-020-000 Small Tools . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2015 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-65035-020-000 Small Tools Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 414.59 .00 414.59 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 414.59 ** 750.00 Budgeted 335.41 Remaining 55 % Used Account: 135-65045-020-000 Lab Supplies 535 12/22/2015 December A/P Chlorine test kits 2,941.17 314.04 3,255.21 HD SUPPLY FACILITIES MAINT LTD 1320 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 314.04 3,255.21 ** 13,000.00 Budgeted 9,744.79 Remaining 25 % Used Account: 135-69005-020-000 Capital Outlays 494 12/14/2015 December A/P Pump for LS#5 9,593.16 9,593.16 NORTH TEXAS PUMP CO. 1298 AP 496 12/14/2015 December A/P Pump for LS#3 14,011.67 23,604.83 NORTH TEXAS PUMP CO. 1298 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 23,604.83 23,604.83 ** 150,000.00 Budgeted 126,395.17 Remaining 16 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 21,280.00 Budgeted 21,280.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 197.00 Budgeted 197.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 295,236.59 ** 1,912,109.00 Budgeted 1,616,872.41 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-021-000 Electricity 708 12/31/2015 Correct coding on electricity .01 (.01) .00 GL _______________ Account: 135-60020-021-000 Electricity Totals: (.01) .00 ** .00 Budgeted .00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ .00 ** .00 Budgeted .00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2015 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 342 12/04/2015 MUD Payroll 12/4/15 Salaries & Wages 500.00 500.00 1,000.00 PR 566 12/31/2015 PR 12-31-15 Salaries & Wages 500.00 1,500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,000.00 1,500.00 ** 12,500.00 Budgeted 11,000.00 Remaining 12 % Used Account: 135-50030-026-000 Social Security Taxes 342 12/04/2015 MUD Payroll 12/4/15 Social Security Taxes 31.00 31.00 62.00 PR 566 12/31/2015 PR 12-31-15 Social Security Taxes 31.00 93.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 62.00 93.00 ** 775.00 Budgeted 682.00 Remaining 12 % Used Account: 135-50035-026-000 Medicare Taxes 342 12/04/2015 MUD Payroll 12/4/15 Medicare Taxes 7.25 7.25 14.50 PR 566 12/31/2015 PR 12-31-15 Medicare Taxes 7.25 21.75 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 14.50 21.75 ** 181.00 Budgeted 159.25 Remaining 12 % Used Account: 135-50040-026-000 Unemployment Taxes 342 12/04/2015 MUD Payroll 12/4/15 Unemployment Taxes .50 .50 1.00 PR 566 12/31/2015 PR 12-31-15 Unemployment Taxes .50 1.50 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.00 1.50 ** 230.00 Budgeted 228.50 Remaining 1 % Used Account: 135-50045-026-000 Workman's Compensation 134 12/01/2015 Prepaid Insurance, W/C Dec 6.17 3.08 9.25 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.08 9.25 ** 37.00 Budgeted 27.75 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 No.1 Page 37 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 6.00 .00 6.00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 6.00 ** 1,200.00 Budgeted 1,194.00 Remaining 1 % Used Account: 135-60080-026-000 Schools & Training 550.00 .00 550.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 550.00 ** 4,000.00 Budgeted 3,450.00 Remaining 14 % 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.48 .00 50.48 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 50.48 ** 2,000.00 Budgeted 1,949.52 Remaining 3 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 2,231.98 ** 26,573.00 Budgeted 24,341.02 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 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 342 12/04/2015 MUD Payroll 12/4/15 Salaries & Wages 59,597.26 18,642.80 78,240.06 PR 502 12/18/2015 MUD Payroll 12/18/15 Salaries & Wages 18,617.79 96,857.85 PR 566 12/31/2015 PR 12-31-15 Salaries & Wages 18,629.26 115,487.11 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 55,889.85 115,487.11 ** 488,508.00 Budgeted 373,020.89 Remaining 24 % Used Account: 135-50010-030-000 Overtime 342 12/04/2015 MUD Payroll 12/4/15 Overtime 47.58 10.21 57.79 PR 502 12/18/2015 MUD Payroll 12/18/15 Overtime 12.82 70.61 PR 566 12/31/2015 PR 12-31-15 Overtime 9.08 79.69 PR _______________ Account: 135-50010-030-000 Overtime Totals: 32.11 79.69 ** 1,000.00 Budgeted 920.31 Remaining 8 % Used Account: 135-50016-030-000 Longevity 3,822.50 .00 3,822.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,822.50 ** 3,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 342 12/04/2015 MUD Payroll 12/4/15 Retirement 5,654.96 1,662.01 7,316.97 PR 502 12/18/2015 MUD Payroll 12/18/15 Retirement 1,659.96 8,976.93 PR 566 12/31/2015 PR 12-31-15 Retirement 1,660.70 10,637.63 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,982.67 10,637.63 ** 43,202.00 Budgeted 32,564.37 Remaining 25 % Used Account: 135-50026-030-000 Medical Insurance 342 12/04/2015 MUD Payroll 12/4/15 Medical Insurance 8,277.34 3,193.17 11,470.51 PR 502 12/18/2015 MUD Payroll 12/18/15 Medical Insurance 3,193.12 14,663.63 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 6,386.29 14,663.63 ** 68,196.00 Budgeted 53,532.37 Remaining 22 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 342 12/04/2015 MUD Payroll 12/4/15 Dental Insurance 583.59 182.11 765.70 PR 502 12/18/2015 MUD Payroll 12/18/15 Dental Insurance 182.13 947.83 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 364.24 947.83 ** 4,807.00 Budgeted 3,859.17 Remaining 20 % Used Account: 135-50028-030-000 Vision Insurance 342 12/04/2015 MUD Payroll 12/4/15 Vision Insurance 135.25 42.16 177.41 PR 502 12/18/2015 MUD Payroll 12/18/15 Vision Insurance 42.22 219.63 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 84.38 219.63 ** 1,114.00 Budgeted 894.37 Remaining 20 % Used Account: 135-50029-030-000 Life Insurance & Other 352 12/01/2015 Dec A/P Dec Dental, Life, ADD, Vision 761.24 345.06 1,106.30 METLIFE GROUP BENEFITS 1238 AP 574 12/31/2015 December A/P Café 125 admin fees 37.78 1,144.08 BenefitMall 1339 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 382.84 1,144.08 ** 4,431.00 Budgeted 3,286.92 Remaining 26 % Used Account: 135-50030-030-000 Social Security Taxes 342 12/04/2015 MUD Payroll 12/4/15 Social Security Taxes 3,706.66 1,067.52 4,774.18 PR 502 12/18/2015 MUD Payroll 12/18/15 Social Security Taxes 1,055.30 5,829.48 PR 566 12/31/2015 PR 12-31-15 Social Security Taxes 1,155.57 6,985.05 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 3,278.39 6,985.05 ** 30,823.00 Budgeted 23,837.95 Remaining 23 % Used Account: 135-50035-030-000 Medicare Taxes 342 12/04/2015 MUD Payroll 12/4/15 Medicare Taxes 866.88 249.65 1,116.53 PR 502 12/18/2015 MUD Payroll 12/18/15 Medicare Taxes 246.82 1,363.35 PR 566 12/31/2015 PR 12-31-15 Medicare Taxes 270.24 1,633.59 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 766.71 1,633.59 ** 7,599.00 Budgeted 5,965.41 Remaining 21 % Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 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: .00 .00 ** 1,449.00 Budgeted 1,449.00 Remaining 0 % Used Account: 135-50045-030-000 Workman's Compensation 134 12/01/2015 Prepaid Insurance, W/C Dec 295.78 147.89 443.67 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 443.67 ** 1,554.00 Budgeted 1,110.33 Remaining 29 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 494 12/14/2015 December A/P Dinner for Christmas party 966.11 370.00 1,336.11 PRP FOOD SERVICE INC 1300 AP 672 12/31/2015 Dec A/P Items for Christmas party 11.44 1,347.55 Terri Sisk 1410 AP _______________ Account: 135-50070-030-000 Employee Relations Totals: 381.44 1,347.55 ** 5,000.00 Budgeted 3,652.45 Remaining 27 % Used Account: 135-55030-030-000 Software & Support 495 12/14/2015 December A/P Internet 1/1 - 1/31/16 4,454.16 1,163.56 5,617.72 WHOLESALE CARRIER SERVICES INC 1308 AP 535 12/22/2015 December A/P Support October 576.00 6,193.72 STW INC 1330 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 1,739.56 6,193.72 ** 78,483.00 Budgeted 72,289.28 Remaining 8 % Used Account: 135-55070-030-000 Independent Labor 494 12/14/2015 December A/P M. Pastor recorded MUD meeting 595.00 210.63 805.63 TOWN OF TROPHY CLUB 1305 AP 494 12/14/2015 December A/P Record MUD Meeting October 67.50 873.13 MIGUEL CRUZ 1297 AP 535 12/22/2015 December A/P Water Study 8,075.00 8,948.13 THE WALLACE GROUP, INC. 1333 AP 672 12/31/2015 Dec A/P Water Study 3,877.60 12,825.73 THE WALLACE GROUP, INC. 1412 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 12,230.73 12,825.73 ** 12,000.00 Budgeted (825.73) Remaining 107 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Maintenance & Repairs 574 12/31/2015 December A/P December mowing 4,723.50 1,290.00 6,013.50 WATTS ELLISON LLC 1361 AP 574 12/31/2015 December A/P Replace fire alarm panel, add 1,711.16 7,724.66 PRO FIRE & SPRINKLER LLC 1354 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 3,001.16 7,724.66 ** 29,500.00 Budgeted 21,775.34 Remaining 26 % Used Account: 135-55100-030-000 Building Maint & Supplies 574 12/31/2015 December A/P Rug cleaning 736.78 130.89 867.67 G & K SERVICES 1345 AP 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (130.89) 736.78 AR 706 12/31/2015 Dec A/P MUD P/S bldgs. Rug Service 130.89 867.67 G & K SERVICES AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 130.89 867.67 ** 7,000.00 Budgeted 6,132.33 Remaining 12 % Used Account: 135-55120-030-000 Cleaning Services 535 12/22/2015 December A/P Janitorial Service November 325.75 843.75 1,169.50 MEMBER'S BUILDING MAINTENANCE 1324 AP 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (259.00) 910.50 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 584.75 910.50 ** 10,125.00 Budgeted 9,214.50 Remaining 9 % Used Account: 135-55160-030-000 Professional Outside Services 535 12/22/2015 December A/P Boundary survey 51,075.00 495.00 51,570.00 THE WALLACE GROUP, INC. 1333 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 495.00 51,570.00 ** 61,075.00 Budgeted 9,505.00 Remaining 84 % 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 688 12/31/2015 Dec A/P UB printing of Dec bills 1,246.60 640.15 1,886.75 DATAPROSE LLC 1374 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 640.15 1,886.75 ** 8,200.00 Budgeted 6,313.25 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-000 Telephone 434 12/07/2015 December A/P Answering service 12/14/15 - 1 2,470.51 211.65 2,682.16 KEYSTONE PARK SECRETARIAL 1263 AP 535 12/22/2015 December A/P Charter, Mercury, Gexa bills 111.25 2,793.41 TOWN OF TROPHY CLUB 1334 AP 535 12/22/2015 December A/P Charter, Mercury, Gexa bills 82.50 2,875.91 TOWN OF TROPHY CLUB 1334 AP _______________ Account: 135-60005-030-000 Telephone Totals: 405.40 2,875.91 ** 16,349.00 Budgeted 13,473.09 Remaining 18 % Used Account: 135-60010-030-000 Communications/Mobiles 495 12/14/2015 December A/P Mobile phones 675.98 37.99 713.97 VERIZON WIRELESS 1307 AP 502 12/18/2015 MUD Payroll 12/18/15 Communications/Mobiles 300.00 1,013.97 PR 688 12/31/2015 Dec A/P Cell phones Dec 37.99 1,051.96 VERIZON WIRELESS 1419 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 375.98 1,051.96 ** 4,150.00 Budgeted 3,098.04 Remaining 25 % Used Account: 135-60020-030-000 Electricity/Gas 535 12/22/2015 December A/P Charter, Mercury, Gexa bills 814.79 814.79 TOWN OF TROPHY CLUB 1334 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 814.79 814.79 ** 10,768.00 Budgeted 9,953.21 Remaining 8 % Used Account: 135-60025-030-000 Water 672 12/31/2015 Dec A/P Dec Water 191.94 108.60 300.54 TROPHY CLUB MUD (WATER BILLS) 1416 AP 703 12/31/2015 Bill Town Inv 1391-1401 AR 20151231-20151231 User: (54.30) 246.24 AR _______________ Account: 135-60025-030-000 Water Totals: 54.30 246.24 ** 1,500.00 Budgeted 1,253.76 Remaining 16 % Used Account: 135-60035-030-000 Postage 535 12/22/2015 December A/P Overnight letter 4,307.52 6.48 4,314.00 FEDERAL EXPRESS CORP 1318 AP 574 12/31/2015 December A/P Overnight letter 13.98 4,327.98 FEDERAL EXPRESS CORP 1344 AP 672 12/31/2015 Dec A/P Overnight letter 5.55 4,333.53 FEDERAL EXPRESS CORP 1380 AP 688 12/31/2015 Dec A/P UB printing of Dec bills 1,748.12 6,081.65 DATAPROSE LLC 1374 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,774.13 6,081.65 ** 28,932.00 Budgeted 22,850.35 Remaining 21 % Used Account: 135-60040-030-000 Service Charges & Fees . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 669 12/02/2015 UB Credit Card fees/Nov 12,783.42 86.03 12,869.45 GL 669 12/02/2015 UB Credit Card fees/Nov 5,395.94 18,265.39 GL 517 12/04/2015 Child support fee 12/4/15 P/R 1.50 18,266.89 GL 662 12/15/2015 Bank Analysis Fee- November 57.83 18,324.72 GL 518 12/18/2015 Child support fee 12/18/15 P/R 1.50 18,326.22 GL 549 12/31/2015 Child support pmt fee 1.50 18,327.72 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,544.30 18,327.72 ** 44,000.00 Budgeted 25,672.28 Remaining 42 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 134 12/01/2015 Prepaid Insurance, W/C Dec 5,612.00 2,756.00 8,368.00 GL _______________ Account: 135-60055-030-000 Insurance Totals: 2,756.00 8,368.00 ** 52,797.00 Budgeted 44,429.00 Remaining 16 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 535 12/22/2015 December A/P Annual membership dues for 201 200.00 580.00 780.00 AWBD 1316 AP 535 12/22/2015 December A/P Annual membership dues 4,116.25 4,896.25 Texas Rural Water Assoc 1332 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 4,696.25 4,896.25 ** 6,000.00 Budgeted 1,103.75 Remaining 82 % Used Account: 135-60075-030-000 Meetings .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education 672 12/31/2015 Dec A/P Beck Elem Facility Rental for 61.65 126.00 187.65 NORTHWEST INDEPENDENT SCHOOL 1396 AP _______________ Account: 135-60079-030-000 Public Education Totals: 126.00 187.65 ** 5,000.00 Budgeted 4,812.35 Remaining 4 % Used Account: 135-60080-030-000 Schools & Training 459.00 .00 459.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 459.00 ** 9,935.00 Budgeted 9,476.00 Remaining 5 % Used Account: 135-60100-030-000 Travel & per diem 342 12/04/2015 MUD Payroll 12/4/15 Travel & per diem 391.00 29.15 420.15 PR 502 12/18/2015 MUD Payroll 12/18/15 Travel & per diem 28.52 448.67 PR 535 12/22/2015 December A/P Mileage to and from Austin 258.75 707.42 LAURIE SLAGHT 1323 AP 566 12/31/2015 PR 12-31-15 Travel & per diem 22.60 730.02 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 339.02 730.02 ** 5,400.00 Budgeted 4,669.98 Remaining 14 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 675.36 .00 675.36 _______________ Account: 135-60125-030-000 Advertising Totals: .00 675.36 ** 7,500.00 Budgeted 6,824.64 Remaining 9 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 538 12/09/2015 McKnight/Reimb pcard 367.91 (32.93) 334.98 GL 574 12/31/2015 December A/P Temp to cover phones during Ch 88.00 422.98 TRINITY EMPLOYMENT SOLUTIONS 1359 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 55.07 422.98 ** 17,501.00 Budgeted 17,078.02 Remaining 2 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 1,855.00 Budgeted 1,855.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 434 12/07/2015 December A/P Dell computer and monitor 5,871.85 5,871.85 M3 Networks 1266 AP _______________ Account: 135-65055-030-000 Hardware Totals: 5,871.85 5,871.85 ** 29,594.00 Budgeted 23,722.15 Remaining 20 % Used Account: 135-65085-030-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 434 12/07/2015 December A/P Annual maintenance check scann 452.61 427.00 879.61 TECHNIQUE DATA SYSTEMS INC 1277 AP 494 12/14/2015 December A/P Office supplies 241.36 1,120.97 OFFICE DEPOT, INC 1299 AP 574 12/31/2015 December A/P Office supplies 99.30 1,220.27 OFFICE DEPOT, INC 1350 AP 698 12/31/2015 Dec A/P Office Supplies 106.75 1,327.02 OFFICE DEPOT, INC 1397 AP 698 12/31/2015 Dec A/P Office Supplies 13.69 1,340.71 OFFICE DEPOT, INC 1397 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 888.10 1,340.71 ** 9,000.00 Budgeted 7,659.29 Remaining 15 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 221.30 .00 221.30 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 221.30 ** 4,003.00 Budgeted 3,781.70 Remaining 6 % Used Account: 135-65095-030-000 Maintenance Supplies 1,020.41 .00 1,020.41 _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: .00 1,020.41 ** 5,000.00 Budgeted 3,979.59 Remaining 20 % 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 ** 56,000.00 Budgeted 56,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 535 12/22/2015 December A/P Copier service & supplies 526.78 70.56 597.34 KYOCERA DOCUMENT SOLUTIONS 1322 AP 535 12/22/2015 December A/P Copier lease pmt 165.00 762.34 EVERBANK COMMERCIAL FINANCE 1317 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 235.56 762.34 ** 4,600.00 Budgeted 3,837.66 Remaining 17 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 30 Totals: ------------------------------------------------------------------------------------------------ 293,745.13 ** 1,210,323.00 Budgeted 916,577.87 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/2015 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 535 12/22/2015 December A/P Legal services November 93,230.00 714.49 93,944.49 WHITAKER CHALK SWINDLE 1336 AP 535 12/22/2015 December A/P Legal Services November 920.00 94,864.49 Norton Rose Fulbright US LLP 1326 AP _______________ Account: 135-55045-039-000 Legal Totals: 1,634.49 94,864.49 ** 386,130.00 Budgeted 291,265.51 Remaining 25 % Used Account: 135-55055-039-000 Auditing 434 12/07/2015 December A/P Audit FYE 9/30/15 - Progress b 5,000.00 11,245.50 16,245.50 LAFOLLETT & ABBOTT PLLC 1264 AP _______________ Account: 135-55055-039-000 Auditing Totals: 11,245.50 16,245.50 ** 22,750.00 Budgeted 6,504.50 Remaining 71 % Used Account: 135-55060-039-000 Appraisal 494 12/14/2015 December A/P 1st Qtr DCAD 2016 Budget 2,235.39 1,994.51 4,229.90 DENTON CENTRAL APPRAISAL DISTR 1289 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,994.51 4,229.90 ** 10,265.00 Budgeted 6,035.10 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 606 12/23/2015 Denton Cty/Tax Statements 2,468.82 2,468.82 AR _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 2,468.82 2,468.82 ** 3,800.00 Budgeted 1,331.18 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 117,808.71 ** 422,945.00 Budgeted 305,136.29 Remaining 28 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (101,598.68) .00 Budgeted 101,598.68 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/2015 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 (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (156,420.00) ** .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (156,420.00) .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 12/2015 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 (2.77) .00 (2.77) _______________ Account: 507-49010-000-000 Interest Income Totals: .00 (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 .00 8,034.36 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 8,031.59 .00 Budgeted (8,031.59) Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET DECEMBER 2015 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,380,013 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,380,013 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 1,450 TOTAL FUND BALANCE 4,380,013 TOTAL LIABILITIES AND FUND BALANCE 4,380,013 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 19:08 01/13/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 693.03- 1,449.84- 1,449.84 Subtotal: 693.03- 1,449.84- 1,449.84 Program number: 693.03- 1,449.84- 1,449.84 Department number: Revenues 693.03- 1,449.84- 1,449.84 Revenues Subtotal ----------- 693.03- 1,449.84- 1,449.84 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 693.03- 1,449.84- 1,449.84 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/2015 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 663 12/31/2015 Bank Interest/December (756.81) (693.03) (1,449.84) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (693.03) (1,449.84) ** .00 Budgeted 1,449.84 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,449.84) ** .00 Budgeted 1,449.84 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (1,449.84) .00 Budgeted 1,449.84 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET DECEMBER 2015 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 8,347,685 ACCOUNTS RECEIVABLE - TOTAL ASSETS 8,347,685 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 61,961 TOTAL LIABILITIES 61,961 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (48,380) TOTAL FUND BALANCE 8,285,724 TOTAL LIABILITIES AND FUND BALANCE 8,347,685 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 19:08 01/13/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 1,324.49- 2,795.31- 2,795.31 Subtotal: 1,324.49- 2,795.31- 2,795.31 Program number: 1,324.49- 2,795.31- 2,795.31 Department number: Revenues 1,324.49- 2,795.31- 2,795.31 Revenues Subtotal ----------- 1,324.49- 2,795.31- 2,795.31 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 19:08 01/13/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 8,118.05 51,175.00 51,175.00- Subtotal: 8,118.05 51,175.00 51,175.00- Program number: 8,118.05 51,175.00 51,175.00- Department number: Wastewater 8,118.05 51,175.00 51,175.00- Expenditures Subtotal ----------- 8,118.05 51,175.00 51,175.00- Fund number: 518 2015 Revenue Bond Const Fund 6,793.56 48,379.69 48,379.69- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 663 12/31/2015 Bank Interest/December (1,470.82) (1,324.49) (2,795.31) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (1,324.49) (2,795.31) ** .00 Budgeted 2,795.31 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,795.31) ** .00 Budgeted 2,795.31 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-69005-020-000 Capital Outlays 535 12/22/2015 December A/P WWTP Improvements 43,056.95 8,118.05 51,175.00 THE WALLACE GROUP, INC. 1333 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 8,118.05 51,175.00 ** .00 Budgeted (51,175.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 51,175.00 ** .00 Budgeted (51,175.00) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 48,379.69 .00 Budgeted (48,379.69) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET DECEMBER 2015 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 133,671 ACCOUNTS RECEIVABLE - TOTAL ASSETS 133,671 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 61,709 TOTAL FUND BALANCE 133,671 TOTAL LIABILITIES AND FUND BALANCE 133,671 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 19:08 01/13/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 21.17- 41.19- 41.19 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 61,668.00- 50.000 61,668.00- Subtotal: 123,336.00- 123,336.00- 21.17- 61,709.19- 50.033 61,626.81- Program number: 123,336.00- 123,336.00- 21.17- 61,709.19- 50.033 61,626.81- Department number: 123,336.00- 123,336.00- 21.17- 61,709.19- 50.033 61,626.81- Revenues Subtotal ----------- 123,336.00- 123,336.00- 21.17- 61,709.19- 50.033 61,626.81- Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 21.17- 61,709.19- 50.033 61,626.81- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 663 12/31/2015 Bank Interest/December (20.02) (21.17) (41.19) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (21.17) (41.19) ** .00 Budgeted 41.19 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund (61,668.00) .00 (61,668.00) _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (61,668.00) ** (123,336.00) Budgeted (61,668.00) Remaining 50 % Used Department Totals: ------------------------------------------------------------------------------------------------ (61,709.19) ** (123,336.00) Budgeted (61,626.81) Remaining 50 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (61,709.19) (123,336.00) Budgeted (61,626.81) Remaining 50 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET DECEMBER 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 464,403 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 235,020 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 704,270 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 235,020 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 235,020 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 445,077 TOTAL FUND BALANCE 469,250 TOTAL LIABILITIES AND FUND BALANCE 704,270 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 19:08 01/13/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 667,898.00- 667,898.00- 406,875.81- 444,757.49- 66.591 223,140.51- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 34.23- 228.29- 9.926 2,071.71- 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 8.82- 70.27- 3.904 1,729.73- Subtotal: 671,998.00- 671,998.00- 406,918.86- 445,056.05- 66.229 226,941.95- 533-49010-000-000 Interest Income 140.00- 140.00- 16.03- 20.92- 14.943 119.08- 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 119,706.00- Subtotal: 334,225.00- 334,225.00- 16.03- 20.92- .006 334,204.08- Program number: 1,006,223.00- 1,006,223.00- 406,934.89- 445,076.97- 44.232 561,146.03- Department number: Revenues 1,006,223.00- 1,006,223.00- 406,934.89- 445,076.97- 44.232 561,146.03- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 406,934.89- 445,076.97- 44.232 561,146.03- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 19:08 01/13/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 2,550.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 316,983.00 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 685,000.00 685,000.00 Subtotal: 1,004,533.00 1,004,533.00 1,004,533.00 Program number: 1,004,533.00 1,004,533.00 1,004,533.00 Department number: Administration 1,004,533.00 1,004,533.00 1,004,533.00 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 1,004,533.00 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 406,934.89- 445,076.97- ############### 443,386.97 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2015 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 637 12/01/2015 Property Taxes/Assessments (37,881.68) (1,865.64) (39,747.32) GL 638 12/02/2015 Property Taxes/Assessments (2,840.15) (42,587.47) GL 643 12/03/2015 Property Taxes/Assessments (2,078.76) (44,666.23) GL 644 12/04/2015 Property Taxes/Assessments (2,388.38) (47,054.61) GL 645 12/07/2015 Property Taxes/Assessments (4,433.38) (51,487.99) GL 646 12/08/2015 Property Taxes/Assessments (4,786.92) (56,274.91) GL 647 12/09/2015 Property Taxes/Assessments (4,863.12) (61,138.03) GL 648 12/10/2015 Property Taxes/Assessments (2,645.02) (63,783.05) GL 649 12/11/2015 Property Taxes/Assessments (3,537.38) (67,320.43) GL 650 12/14/2015 Property Taxes/Assessments (896.84) (68,217.27) GL 651 12/15/2015 Property Taxes/Assessments (4,819.98) (73,037.25) GL 652 12/16/2015 Property Taxes/Assessments (1,594.06) (74,631.31) GL 653 12/17/2015 Property Taxes/Assessments (7,910.03) (82,541.34) GL 654 12/18/2015 Property Taxes/Assessments (5,815.50) (88,356.84) GL 655 12/21/2015 Property Taxes/Assessments (2,639.22) (90,996.06) GL 656 12/22/2015 Property Taxes/Assessments (3,253.52) (94,249.58) GL 657 12/23/2015 Property Taxes/Assessments (62,446.20) (156,695.78) GL 659 12/28/2015 Property Taxes/Assessments (130,413.35) (287,109.13) GL 660 12/29/2015 Property Taxes/Assessments (15,495.31) (302,604.44) GL 661 12/30/2015 Property Taxes/Assessments (101,019.47) (403,623.91) GL 667 12/31/2015 Property Taxes (41,133.58) (444,757.49) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (406,875.81) (444,757.49) ** (667,898.00) Budgeted (223,140.51) Remaining 67 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 638 12/02/2015 Property Taxes/Assessments (194.06) 3.47 (190.59) GL 655 12/21/2015 Property Taxes/Assessments (21.54) (212.13) GL 659 12/28/2015 Property Taxes/Assessments .45 (211.68) GL 660 12/29/2015 Property Taxes/Assessments (16.61) (228.29) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (34.23) (228.29) ** (2,300.00) Budgeted (2,071.71) Remaining 10 % Used Account: 533-40015-000-000 Property Taxes/P & I 655 12/21/2015 Property Taxes/Assessments (61.45) (4.96) (66.41) GL 660 12/29/2015 Property Taxes/Assessments (3.86) (70.27) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (8.82) (70.27) ** (1,800.00) Budgeted (1,729.73) Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49010-000-000 Interest Income 663 12/31/2015 Bank Interest/December (4.89) (16.03) (20.92) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (16.03) (20.92) ** (140.00) Budgeted (119.08) Remaining 15 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (214,379.00) Budgeted (214,379.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg .00 .00 _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 .00 ** (119,706.00) Budgeted (119,706.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (445,076.97) ** (1,006,223.00) Budgeted (561,146.03) Remaining 44 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,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 ** 316,983.00 Budgeted 316,983.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 ** 685,000.00 Budgeted 685,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 1,004,533.00 Budgeted 1,004,533.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (445,076.97) (1,690.00) Budgeted 443,386.97 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET DECEMBER 2015 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,073 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,073 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 5 TOTAL FUND BALANCE 15,073 TOTAL LIABILITIES AND FUND BALANCE 15,073 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 19:08 01/13/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 7.00- 7.00- 2.41- 5.09- 72.714 1.91- 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 444,831.00- Subtotal: 444,838.00- 444,838.00- 2.41- 5.09- .001 444,832.91- Program number: 444,838.00- 444,838.00- 2.41- 5.09- .001 444,832.91- Department number: Revenues 444,838.00- 444,838.00- 2.41- 5.09- .001 444,832.91- Revenues Subtotal ----------- 444,838.00- 444,838.00- 2.41- 5.09- .001 444,832.91- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 25 19:08 01/13/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 234,838.00 234,838.00 234,838.00 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 210,000.00 210,000.00 Subtotal: 444,838.00 444,838.00 444,838.00 Program number: 444,838.00 444,838.00 444,838.00 Department number: Administration 444,838.00 444,838.00 444,838.00 Expenditures Subtotal ----------- 444,838.00 444,838.00 444,838.00 Fund number: 534 2015 Revenue Bond I&S 2.41- 5.09- 5.09 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 663 12/31/2015 Bank Interest/December (2.68) (2.41) (5.09) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (2.41) (5.09) ** (7.00) Budgeted (1.91) Remaining 73 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales .00 .00 _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 .00 ** (444,831.00) Budgeted (444,831.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5.09) ** (444,838.00) Budgeted (444,832.91) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 19:09 01/13/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 234,838.00 Budgeted 234,838.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 210,000.00 Budgeted 210,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 444,838.00 Budgeted 444,838.00 Remaining 0 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (5.09) .00 Budgeted 5.09 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (866,423.97) **** (125,026.00) Budgeted 741,397.97 Remaining 693 % Used ******* End of Report *********