Loading...
HomeMy WebLinkAbout2015-08 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET AUGUST 2015 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 683,415 PREPAID EXPENSES 1,599 ADVALOREM PROPERTY TAXES RECEIVABLE 14,416 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 603 UTILITY AND OTHER ACCOUNTS RECEIVABLE 3,451 TOTAL ASSETS 703,484 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 15,019 ACCOUNTS AND OTHER PAYABLES 31,321 TOTAL LIABILITIES 46,340 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 128,233 TOTAL FUND BALANCE 657,144 TOTAL LIABILITIES AND FUND BALANCE 703,484 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 15:46 09/09/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 357,462.00- 357,462.00- 10.06- 356,645.66- 99.772 816.34- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 8,401.96- 8,401.96 122-40010-000-000 Property Taxes/MUD Fire 872,859.00- 872,859.00- 752.22- 871,029.36- 99.790 1,829.64- 122-40011-000-000 Property Taxes/Fire-Delinquent 31.15- 4,055.50- 4,055.50 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 1.30- 3,304.02- 440.536 2,554.02 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 112.52- 3,746.33- 83.252 753.67- Subtotal: 1,235,571.00- 1,235,571.00- 907.25- 1,247,182.83- 100.940 11,611.83 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 1,600.00- 6,800.00- 113.333 800.00 Subtotal: 6,000.00- 6,000.00- 1,600.00- 6,800.00- 113.333 800.00 122-43400-000-000 Fire Inspections 700.00- 950.00- 300.00- 1,275.00- 134.211 325.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,700.00- 10,950.00- 300.00- 11,275.00- 102.968 325.00 122-49000-000-000 Capital Lease-Oth Fin Sources 807,316.00- 807,316.14- 100.000 .14 122-49035-000-000 Prior Year Reserves 125,669.00- 171,030.00- 125,670.00- 73.478 45,360.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 9,000.00- 3,300.00- 13,703.99- 152.267 4,703.99 Subtotal: 131,669.00- 987,346.00- 3,300.00- 946,690.13- 95.882 40,655.87- Program number: 1,383,940.00- 2,239,867.00- 6,107.25- 2,211,947.96- 98.754 27,919.04- Department number: Fire Revenues 1,383,940.00- 2,239,867.00- 6,107.25- 2,211,947.96- 98.754 27,919.04- Revenues Subtotal ----------- 1,383,940.00- 2,239,867.00- 6,107.25- 2,211,947.96- 98.754 27,919.04- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 15:46 09/09/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 469,067.00 469,067.00 36,292.19 422,175.15 90.003 46,891.85 122-50010-045-000 Overtime 46,745.00 46,745.00 3,276.33 38,496.44 82.354 8,248.56 122-50011-045-000 DPS Holiday Pay 14,930.00 14,930.00 14,525.69 97.292 404.31 122-50016-045-000 Longevity 5,505.00 5,505.00 5,318.72 96.616 186.28 122-50017-045-000 Certification 4,800.00 4,800.00 362.50 4,481.50 93.365 318.50 122-50020-045-000 Retirement 91,396.00 75,327.00 5,367.55 65,931.25 87.527 9,395.75 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,780.63 50,430.88 85.232 8,738.12 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 353.73 3,858.72 87.898 531.28 122-50028-045-000 Vision Insurance 811.00 811.00 61.33 671.38 82.784 139.62 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 300.43 3,372.33 83.681 657.67 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 2,272.54 27,739.98 83.002 5,681.02 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 531.40 6,486.07 88.948 805.93 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 9.70 271.03- -16.357 1,928.03 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 658.99 7,248.93 83.398 1,443.07 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 35.00 182.50 73.000 67.50 122-50075-045-000 Tuition Reimbursement 300.00 300.00 300.00 Subtotal: 752,455.00 736,386.00 54,302.32 650,648.51 88.357 85,737.49 122-55030-045-000 Software & Support 7,378.00 7,378.00 2,312.50 5,130.66 69.540 2,247.34 122-55045-045-000 Legal 1,500.00 1,500.00 2,040.00 136.000 540.00- 122-55080-045-000 Maintenance & Repairs 18,552.00 18,552.00 2,075.73 10,613.37 57.209 7,938.63 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 469.50 11,005.87 91.716 994.13 122-55160-045-000 Professional Outside Services 1,895.20 1,895.20 1,895.20- Subtotal: 39,430.00 39,430.00 6,752.93 30,685.10 77.822 8,744.90 122-60005-045-000 Telephone 50.00 50.00 51.30 102.600 1.30- 122-60010-045-000 Communications/Mobiles 5,000.00 6,413.00 416.80 4,352.53 67.870 2,060.47 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 617.29 5,081.44 56.298 3,944.56 122-60025-045-000 Water 1,200.00 1,200.00 353.12 1,426.60 118.883 226.60- 122-60026-045-000 Cable 1,920.00 1,920.00 286.92 1,689.10 87.974 230.90 122-60030-045-000 Rent And/Or Usage 211,829.00 211,829.00 211,829.00 100.000 122-60035-045-000 Postage 100.00 100.00 16.43 16.430 83.57 122-60055-045-000 Insurance 12,179.00 12,179.00 940.08 10,340.92 84.908 1,838.08 122-60066-045-000 Publications/Books/Subscrips 200.00 220.00 219.05 99.568 .95 122-60070-045-000 Dues & Memberships 15,180.00 15,689.00 15,632.85 99.642 56.15 122-60080-045-000 Schools & Training 4,280.00 4,280.00 87.50 4,012.59 93.752 267.41 122-60096-045-000 Emergency Management 1,400.00 1,400.00 1,000.00 1,220.00 87.143 180.00 122-60100-045-000 Travel & per diem 13,577.00 13,577.00 1,804.80 7,936.16 58.453 5,640.84 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 5,100.00 5,100.00 702.00 826.15 16.199 4,273.85 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 2,456.45 54.588 2,043.55 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 194.00 19.400 806.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 15:46 09/09/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 665.25 554.85 27.743 1,445.15 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 573.99 57.399 426.01 Subtotal: 291,541.00 293,483.00 6,873.76 268,413.41 91.458 25,069.59 122-65005-045-000 Fuel & Lube 10,454.00 10,454.00 301.25 5,013.65 47.959 5,440.35 122-65010-045-000 Uniforms 2,000.00 3,000.00 2,408.30 80.277 591.70 122-65015-045-000 Protective Clothing 5,200.00 35,200.00 16,177.45 45.959 19,022.55 122-65030-045-000 Chemicals 200.00 200.00 133.51 66.755 66.49 122-65035-045-000 Small Tools 2,500.00 2,500.00 70.65 1,124.38 44.975 1,375.62 122-65055-045-000 Hardware 9,000.00 9,000.00 9,000.00 122-65085-045-000 Office Supplies 500.00 500.00 79.98 15.996 420.02 122-65105-045-000 Printing 548.00 548.00 38.17 6.965 509.83 Subtotal: 30,402.00 61,402.00 371.90 24,975.44 40.675 36,426.56 122-69005-045-000 Capital Outlays 1,057,316.00 1,057,316.14 100.000 .14- 122-69008-045-000 Short Term Debt-Principal 158,262.00 122-69009-045-000 Short Term Debt-Interest 50,000.00 122-69050-045-000 Radios 23,500.00 23,500.00 23,490.76 23,490.76 99.961 9.24 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 17,950.00 17,950.00 100.000 122-69255-045-000 Airpacks 20,400.00 10,400.00 10,235.38 98.417 164.62 Subtotal: 270,112.00 1,109,166.00 23,490.76 1,108,992.28 99.984 173.72 Program number: 1,383,940.00 2,239,867.00 91,791.67 2,083,714.74 93.029 156,152.26 Department number: Fire 1,383,940.00 2,239,867.00 91,791.67 2,083,714.74 93.029 156,152.26 Expenditures Subtotal ----------- 1,383,940.00 2,239,867.00 91,791.67 2,083,714.74 93.029 156,152.26 Fund number: 122 Trophy Club MUD Fire Dept. 85,684.42 128,233.22- 128,233.22 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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 2080 08/20/2015 Property Taxes/Assessments (356,635.60) (10.06) (356,645.66) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (10.06) (356,645.66) ** (357,462.00) Budgeted (816.34) Remaining 100 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (8,401.96) .00 (8,401.96) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (8,401.96) ** .00 Budgeted 8,401.96 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 2073 08/03/2015 Property Taxes/Assessments (870,277.14) (341.41) (870,618.55) GL 2074 08/04/2015 Property Taxes/Assessments (202.77) (870,821.32) GL 2075 08/06/2015 Property Taxes/Assessments (507.21) (871,328.53) GL 2076 08/10/2015 Property Taxes/Assessments (37.26) (871,365.79) GL 2077 08/12/2015 Property Taxes/Assessments (29.67) (871,395.46) GL 2078 08/17/2015 Property Taxes/Assessments (.29) (871,395.75) GL 2079 08/19/2015 Property Taxes/Assessments 38.63 (871,357.12) GL 2080 08/20/2015 Property Taxes/Assessments (56.99) (871,414.11) GL 2081 08/24/2015 Property Taxes/Assessments 408.93 (871,005.18) GL 2082 08/27/2015 Property Taxes/Assessments (13.30) (871,018.48) GL 2083 08/31/2015 Property Taxes/Assessments (10.88) (871,029.36) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (752.22) (871,029.36) ** (872,859.00) Budgeted (1,829.64) Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2074 08/04/2015 Property Taxes/Assessments (4,024.35) (26.48) (4,050.83) GL 2076 08/10/2015 Property Taxes/Assessments (.05) (4,050.88) GL 2083 08/31/2015 Property Taxes/Assessments (4.62) (4,055.50) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (31.15) (4,055.50) ** .00 Budgeted 4,055.50 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 2080 08/20/2015 Property Taxes/Assessments (3,302.72) (1.30) (3,304.02) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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 Totals: (1.30) (3,304.02) ** (750.00) Budgeted 2,554.02 Remaining 441 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2073 08/03/2015 Property Taxes/Assessments (3,633.81) (.02) (3,633.83) GL 2074 08/04/2015 Property Taxes/Assessments (12.11) (3,645.94) GL 2075 08/06/2015 Property Taxes/Assessments (90.26) (3,736.20) GL 2076 08/10/2015 Property Taxes/Assessments (.03) (3,736.23) GL 2077 08/12/2015 Property Taxes/Assessments (2.08) (3,738.31) GL 2078 08/17/2015 Property Taxes/Assessments (.05) (3,738.36) GL 2080 08/20/2015 Property Taxes/Assessments (3.99) (3,742.35) GL 2082 08/27/2015 Property Taxes/Assessments (2.30) (3,744.65) GL 2083 08/31/2015 Property Taxes/Assessments (1.68) (3,746.33) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (112.52) (3,746.33) ** (4,500.00) Budgeted (753.67) Remaining 83 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (5,200.00) (1,600.00) (6,800.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (1,600.00) (6,800.00) ** (6,000.00) Budgeted 800.00 Remaining 113 % Used Account: 122-43400-000-000 Fire Inspections 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (975.00) (300.00) (1,275.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (300.00) (1,275.00) ** (950.00) Budgeted 325.00 Remaining 134 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49000-000-000 Capital Lease-Oth Fin Sources (807,316.14) .00 (807,316.14) . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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-49000-000-000 Capital Lease-Oth Fin Sources Totals: .00 (807,316.14) ** (807,316.00) Budgeted .14 Remaining 100 % Used Account: 122-49035-000-000 Prior Year Reserves (125,670.00) .00 (125,670.00) _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 (125,670.00) ** (171,030.00) Budgeted (45,360.00) Remaining 73 % Used Account: 122-49900-000-000 Miscellaneous Income 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (10,403.99) (3,300.00) (13,703.99) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (3,300.00) (13,703.99) ** (9,000.00) Budgeted 4,703.99 Remaining 152 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,211,947.96) ** (2,239,867.00) Budgeted (27,919.04) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 2018 08/31/2015 FD Payroll 8/14/15 385,882.96 18,241.27 404,124.23 GL 2021 08/31/2015 FD Payroll 8/28/15 18,050.92 422,175.15 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 36,292.19 422,175.15 ** 469,067.00 Budgeted 46,891.85 Remaining 90 % Used Account: 122-50010-045-000 Overtime 2021 08/31/2015 FD Payroll 8/28/15 35,220.11 3,276.33 38,496.44 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,276.33 38,496.44 ** 46,745.00 Budgeted 8,248.56 Remaining 82 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,525.69 .00 14,525.69 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,525.69 ** 14,930.00 Budgeted 404.31 Remaining 97 % Used Account: 122-50016-045-000 Longevity 5,318.72 .00 5,318.72 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,318.72 ** 5,505.00 Budgeted 186.28 Remaining 97 % Used Account: 122-50017-045-000 Certification 2018 08/31/2015 FD Payroll 8/14/15 4,119.00 362.50 4,481.50 GL _______________ Account: 122-50017-045-000 Certification Totals: 362.50 4,481.50 ** 4,800.00 Budgeted 318.50 Remaining 93 % Used Account: 122-50020-045-000 Retirement 2018 08/31/2015 FD Payroll 8/14/15 60,563.70 2,483.05 63,046.75 GL 2021 08/31/2015 FD Payroll 8/28/15 2,884.50 65,931.25 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,367.55 65,931.25 ** 75,327.00 Budgeted 9,395.75 Remaining 88 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-50026-045-000 Medical Insurance 2018 08/31/2015 FD Payroll 8/14/15 45,650.25 2,748.08 48,398.33 GL 2021 08/31/2015 FD Payroll 8/28/15 2,032.55 50,430.88 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,780.63 50,430.88 ** 59,169.00 Budgeted 8,738.12 Remaining 85 % Used Account: 122-50027-045-000 Dental Insurance 2018 08/31/2015 FD Payroll 8/14/15 3,504.99 176.87 3,681.86 GL 2021 08/31/2015 FD Payroll 8/28/15 176.86 3,858.72 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 353.73 3,858.72 ** 4,390.00 Budgeted 531.28 Remaining 88 % Used Account: 122-50028-045-000 Vision Insurance 2018 08/31/2015 FD Payroll 8/14/15 610.05 30.67 640.72 GL 2021 08/31/2015 FD Payroll 8/28/15 30.66 671.38 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 61.33 671.38 ** 811.00 Budgeted 139.62 Remaining 83 % Used Account: 122-50029-045-000 Life Insurance & Other 2018 08/31/2015 FD Payroll 8/14/15 3,071.90 150.23 3,222.13 GL 2021 08/31/2015 FD Payroll 8/28/15 150.20 3,372.33 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 300.43 3,372.33 ** 4,030.00 Budgeted 657.67 Remaining 84 % Used Account: 122-50030-045-000 Social Security Taxes 2018 08/31/2015 FD Payroll 8/14/15 25,467.44 1,052.24 26,519.68 GL 2021 08/31/2015 FD Payroll 8/28/15 1,220.30 27,739.98 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,272.54 27,739.98 ** 33,421.00 Budgeted 5,681.02 Remaining 83 % Used Account: 122-50035-045-000 Medicare Taxes 2018 08/31/2015 FD Payroll 8/14/15 5,954.67 246.04 6,200.71 GL 2021 08/31/2015 FD Payroll 8/28/15 285.36 6,486.07 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-50035-045-000 Medicare Taxes Totals: 531.40 6,486.07 ** 7,292.00 Budgeted 805.93 Remaining 89 % Used Account: 122-50040-045-000 Unemployment Taxes 2018 08/31/2015 FD Payroll 8/14/15 (280.73) 5.84 (274.89) GL 2021 08/31/2015 FD Payroll 8/28/15 3.86 (271.03) GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 9.70 (271.03) ** 1,657.00 Budgeted 1,928.03 Remaining -16 % Used Account: 122-50045-045-000 Workman's Compensation 201 08/01/2015 Aug TML Ins & Workers Comp 6,589.94 658.99 7,248.93 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 658.99 7,248.93 ** 8,692.00 Budgeted 1,443.07 Remaining 83 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 147.50 35.00 182.50 TOWN OF TROPHY CLUB 35342 AP _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: 35.00 182.50 ** 250.00 Budgeted 67.50 Remaining 73 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 2,818.16 925.00 3,743.16 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 462.50 4,205.66 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 462.50 4,668.16 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Charter, Gexa, Nevill, Beck EM 462.50 5,130.66 TOWN OF TROPHY CLUB 35342 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 2,312.50 5,130.66 ** 7,378.00 Budgeted 2,247.34 Remaining 70 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 2,040.00 .00 2,040.00 _______________ Account: 122-55045-045-000 Legal Totals: .00 2,040.00 ** 1,500.00 Budgeted (540.00) Remaining 136 % Used Account: 122-55080-045-000 Maintenance & Repairs 1986 08/20/2015 August A/P Rug cleaning 8,537.64 37.24 8,574.88 G & K SERVICES 35265 AP 1986 08/20/2015 August A/P Rug cleaning 37.24 8,612.12 G & K SERVICES 35265 AP 1986 08/20/2015 August A/P Replace battery in warning fla 870.00 9,482.12 CONSOLIDATED TRAFFIC CONTROL 35261 AP 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ROTO-ROOTER PLUMBING & 639.50 10,121.62 ROTO-ROOTER PLUMBING & PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 SAMSCLUB #4795 195.37 10,316.99 SAMSCLUB #4795 PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 SAMSCLUB #4795 90.00 10,406.99 SAMSCLUB #4795 PC 2058 08/31/2015 August A/P Rug cleaning 37.24 10,444.23 G & K SERVICES 35310 AP 2058 08/31/2015 August A/P Repair bay #3 door 225.00 10,669.23 OVERHEAD DOOR FORT WORTH 35336 AP 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (55.86) 10,613.37 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 2,075.73 10,613.37 ** 18,552.00 Budgeted 7,938.63 Remaining 57 % Used Account: 122-55090-045-000 Vehicle Maintenance 1986 08/20/2015 August A/P Renew vehicle registration on 10,536.37 7.50 10,543.87 DENTON COUNTY TAX OFFICE 35262 AP 1986 08/20/2015 August A/P Valve repair on E681 462.00 11,005.87 SIDDONS-MARTIN EMERGENCY GROUP 35275 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 469.50 11,005.87 ** 12,000.00 Budgeted 994.13 Remaining 92 % Used Account: 122-55160-045-000 Professional Outside Services 2007 08/28/2015 August A/P Fire Dept Operational Assessme 1,895.20 1,895.20 EMERGENCY SERVICES CONSULTING 35287 AP _______________ Account: 122-55160-045-000 Professional Outside Services Totals: 1,895.20 1,895.20 ** .00 Budgeted (1,895.20) Remaining 0 % Used Account: 122-60005-045-000 Telephone 51.30 .00 51.30 _______________ Account: 122-60005-045-000 Telephone Totals: .00 51.30 ** 50.00 Budgeted (1.30) Remaining 103 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-60010-045-000 Communications/Mobiles 2018 08/31/2015 FD Payroll 8/14/15 3,935.73 75.00 4,010.73 GL 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 113.95 4,124.68 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 113.94 4,238.62 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 113.91 4,352.53 TOWN OF TROPHY CLUB 35342 AP _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 416.80 4,352.53 ** 6,413.00 Budgeted 2,060.47 Remaining 68 % Used Account: 122-60020-045-000 Electricity/Gas 1986 08/20/2015 August A/P Electricity 7/13-8/11/15 4,464.15 1,171.13 5,635.28 HUDSON ENERGY SERVICES, LLC 35268 AP 2058 08/31/2015 August A/P Gas 7/18 - 8/19/15 63.44 5,698.72 ATMOS ENERGY 35305 AP 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (617.28) 5,081.44 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 617.29 5,081.44 ** 9,026.00 Budgeted 3,944.56 Remaining 56 % Used Account: 122-60025-045-000 Water 2058 08/31/2015 August A/P August water bills 1,073.48 706.24 1,779.72 TROPHY CLUB MUD (WATER BILLS) 35343 AP 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (353.12) 1,426.60 AR _______________ Account: 122-60025-045-000 Water Totals: 353.12 1,426.60 ** 1,200.00 Budgeted (226.60) Remaining 119 % Used Account: 122-60026-045-000 Cable 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ATT*BILL PAYMENT 1,402.18 128.50 1,530.68 ATT*BILL PAYMENT PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ATT*BILL PAYMENT 158.42 1,689.10 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 286.92 1,689.10 ** 1,920.00 Budgeted 230.90 Remaining 88 % Used Account: 122-60030-045-000 Rent And/Or Usage 211,829.00 .00 211,829.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 211,829.00 ** 211,829.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 16.43 .00 16.43 _______________ Account: 122-60035-045-000 Postage Totals: .00 16.43 ** 100.00 Budgeted 83.57 Remaining 16 % Used Account: 122-60055-045-000 Insurance 201 08/01/2015 Aug TML Ins & Workers Comp 9,400.84 940.08 10,340.92 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.08 10,340.92 ** 12,179.00 Budgeted 1,838.08 Remaining 85 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 219.05 .00 219.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 219.05 ** 220.00 Budgeted .95 Remaining 100 % Used Account: 122-60070-045-000 Dues & Memberships 15,632.85 .00 15,632.85 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 15,632.85 ** 15,689.00 Budgeted 56.15 Remaining 100 % Used Account: 122-60080-045-000 Schools & Training 2066 08/31/2015 August A/P Charter, Gexa, Nevill, Beck EM 3,925.09 87.50 4,012.59 TOWN OF TROPHY CLUB 35342 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 87.50 4,012.59 ** 4,280.00 Budgeted 267.41 Remaining 94 % Used Account: 122-60096-045-000 Emergency Management 2007 08/28/2015 August A/P Emerg Preparedness Memb Dues 2 220.00 1,000.00 1,220.00 TOWN OF TROPHY CLUB 35299 AP _______________ Account: 122-60096-045-000 Emergency Management Totals: 1,000.00 1,220.00 ** 1,400.00 Budgeted 180.00 Remaining 87 % Used Account: 122-60100-045-000 Travel & per diem 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 DELTA 6,131.36 451.20 6,582.56 DELTA PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 DELTA 6,131.36 451.20 7,033.76 DELTA PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 DELTA 451.20 7,484.96 DELTA PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 DELTA 451.20 7,936.16 DELTA PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 1,804.80 7,936.16 ** 13,577.00 Budgeted 5,640.84 Remaining 58 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 FIRESMARTPROMOS.COM 124.15 216.00 340.15 FIRESMARTPROMOS.COM PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 SIGNS PLUS 486.00 826.15 SIGNS PLUS PC _______________ Account: 122-60125-045-000 Advertising Totals: 702.00 826.15 ** 5,100.00 Budgeted 4,273.85 Remaining 16 % Used Account: 122-60160-045-000 Programs & Special Projects 2,456.45 .00 2,456.45 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 2,456.45 ** 4,500.00 Budgeted 2,043.55 Remaining 55 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 194.00 .00 194.00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 194.00 ** 1,000.00 Budgeted 806.00 Remaining 19 % Used Account: 122-60195-045-000 Flags & Repair 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, (110.40) 47.50 (62.90) TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 502.50 439.60 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Charter, Gexa, Nevill, Beck EM 47.50 487.10 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Charter, Gexa, Nevill, Beck EM 67.75 554.85 TOWN OF TROPHY CLUB 35342 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-60195-045-000 Flags & Repair Totals: 665.25 554.85 ** 2,000.00 Budgeted 1,445.15 Remaining 28 % Used Account: 122-60245-045-000 Miscellaneous Expense 573.99 .00 573.99 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 573.99 ** 1,000.00 Budgeted 426.01 Remaining 57 % Used Account: 122-65005-045-000 Fuel & Lube 2007 08/28/2015 August A/P Fuel 4,712.40 301.25 5,013.65 US Bank Voyager Fleet Systems 35300 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 301.25 5,013.65 ** 10,454.00 Budgeted 5,440.35 Remaining 48 % Used Account: 122-65010-045-000 Uniforms 2,408.30 .00 2,408.30 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 2,408.30 ** 3,000.00 Budgeted 591.70 Remaining 80 % Used Account: 122-65015-045-000 Protective Clothing 16,177.45 .00 16,177.45 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 16,177.45 ** 35,200.00 Budgeted 19,022.55 Remaining 46 % Used Account: 122-65030-045-000 Chemicals 133.51 .00 133.51 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 133.51 ** 200.00 Budgeted 66.49 Remaining 67 % Used Account: 122-65035-045-000 Small Tools 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 IN *A-PLUS STAMPS & SI 1,053.73 70.65 1,124.38 IN *A-PLUS STAMPS & SI PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-65035-045-000 Small Tools Totals: 70.65 1,124.38 ** 2,500.00 Budgeted 1,375.62 Remaining 45 % Used Account: 122-65055-045-000 Hardware .00 .00 _______________ Account: 122-65055-045-000 Hardware Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies 79.98 .00 79.98 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 79.98 ** 500.00 Budgeted 420.02 Remaining 16 % Used Account: 122-65105-045-000 Printing 38.17 .00 38.17 _______________ Account: 122-65105-045-000 Printing Totals: .00 38.17 ** 548.00 Budgeted 509.83 Remaining 7 % Used Account: 122-69005-045-000 Capital Outlays 1,057,316.14 .00 1,057,316.14 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 1,057,316.14 ** 1,057,316.00 Budgeted (.14) Remaining 100 % Used Account: 122-69050-045-000 Radios 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 23,490.76 23,490.76 TOWN OF TROPHY CLUB 35342 AP _______________ Account: 122-69050-045-000 Radios Totals: 23,490.76 23,490.76 ** 23,500.00 Budgeted 9.24 Remaining 100 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 .00 17,950.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-69195-045-000 GASB34/Reserve for Replacement Totals: .00 17,950.00 ** 17,950.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks 10,235.38 .00 10,235.38 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 10,235.38 ** 10,400.00 Budgeted 164.62 Remaining 98 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 2,083,714.74 ** 2,239,867.00 Budgeted 156,152.26 Remaining 93 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (128,233.22) .00 Budgeted 128,233.22 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET AUGUST 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 8/31/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 690,013 - - 690,013 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,543,560 - - 1,543,560 INVESTMENTS-TEXPOOL 1,201,860 169,600 21,461 1,392,921 PREPAID EXPENSES 10,839 - - 10,839 ADVALOREM PROPERTY TAXES RECEIVABLE 1,945 - - 1,945 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,056,875 - - 1,056,875 - TOTAL ASSETS 4,505,693 169,600 21,461 4,696,755 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,945 - - 1,945 ACCOUNTS AND OTHER PAYABLES 642,793 - 13,431 656,224 CUSTOMER DEPOSITS 305,052 - - 305,052 - TOTAL LIABILITIES 949,790 - 13,431 963,221 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 260,697 260,697 NON-SPENDABLE FUND BALANCE 13,980 13,980 ASSIGNED FUND BALANCE 1,409,006 10,268 1,419,274 UNASSIGNED FUND BALANCE 725,069 - - 725,069 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES 1,407,849 (91,097) (2,238) 1,314,514 - TOTAL FUND BALANCE 3,555,903 169,600 8,030 3,733,533 - TOTAL LIABILITIES AND FUND BALANCE 4,505,693 169,600 21,461 4,696,755 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 167,857.00- 167,857.00- 144.65- 167,509.97- 99.793 347.03- 135-40002-000-000 Property Taxes/Delinquent 3.02- 442.66- 442.66 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 20.48- 630.03- 70.003 269.97- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 12,148.50- 128,969.90- 96.248 5,027.10- Subtotal: 302,754.00- 302,754.00- 12,316.65- 297,552.56- 98.282 5,201.44- 135-47000-000-000 Water 5,286,045.00- 4,747,789.00- 587,395.61- 3,102,852.26- 65.354 1,644,936.74- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 249,923.23- 1,879,533.46- 82.763 391,448.54- 135-47025-000-000 Penalties 63,416.00- 80,000.00- 11,935.81- 84,891.84- 106.115 4,891.84 135-47030-000-000 Service Charges 8,000.00- 10,000.00- 850.00- 9,574.00- 95.740 426.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 350.00- 2,150.00- 107.500 150.00 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 1,050.00- 6,450.00- 129.000 1,450.00 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 18,895.80- 52,561.60- 60.544 34,253.40- Subtotal: 7,722,258.00- 7,202,586.00- 870,400.45- 5,138,013.16- 71.336 2,064,572.84- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 20,700.00- 223,100.00- 121.250 39,100.00 Subtotal: 184,000.00- 184,000.00- 20,700.00- 223,100.00- 121.250 39,100.00 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 518.03- 5,557.14- 111.143 557.14 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 10,015.83- 98.542 148.17- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 6,416.63- 91.666 583.37- 135-49030-000-000 Vending Revenue 351.00- 135-49035-000-000 Prior Year Reserves 929,603.00- 929,603.00- 135-49036-000-000 GASB Reserves 74,706.00- 74,706.00- 74,706.00- 100.000 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 42,000.00- 5,358.57- 52,878.40- 125.901 10,878.40 135-49141-000-000 Interfund Transfer In 19,607.00- 36,766.50- 187.517 17,159.50 135-49145-000-000 Intergov Transfer In 1,074,337.15- 1,074,337.15 135-49900-000-000 Miscellaneous Income 54,000.00- 68,994.00- 3,558.06- 108,630.52- 157.449 39,636.52 135-49901-000-000 Records Management Revenue 100.00- 100.00- 2.00- 14.20- 14.200 85.80- Subtotal: 235,321.00- 1,157,174.00- 10,930.52- 1,369,322.37- 118.333 212,148.37 Program number: 8,444,333.00- 8,846,514.00- 914,347.62- 7,027,988.09- 79.444 1,818,525.91- Department number: Revenues 8,444,333.00- 8,846,514.00- 914,347.62- 7,027,988.09- 79.444 1,818,525.91- Revenues Subtotal ----------- 8,444,333.00- 8,846,514.00- 914,347.62- 7,027,988.09- 79.444 1,818,525.91- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 301,101.00 244,578.00 19,511.09 195,443.13 79.910 49,134.87 135-50010-010-000 Overtime 19,500.00 19,500.00 1,474.69 13,298.60 68.198 6,201.40 135-50016-010-000 Longevity 5,343.00 2,705.00 2,705.00 100.000 135-50017-010-000 Certification 4,800.00 3,900.00 225.00 2,500.00 64.103 1,400.00 135-50020-010-000 Retirement 29,349.00 23,987.00 1,889.87 19,094.02 79.602 4,892.98 135-50026-010-000 Medical Insurance 44,988.00 51,487.00 3,893.82 31,466.62 61.116 20,020.38 135-50027-010-000 Dental Insurance 3,288.00 4,188.00 303.02 2,514.74 60.046 1,673.26 135-50028-010-000 Vision Insurance 834.00 990.00 68.97 583.79 58.969 406.21 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 220.75 2,010.48 65.403 1,063.52 135-50030-010-000 Social Security Taxes 21,135.00 17,192.00 1,285.12 13,071.59 76.033 4,120.41 135-50035-010-000 Medicare Taxes 4,943.00 4,021.00 300.56 3,057.08 76.028 963.92 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 2.08 23.09 1.859 1,218.91 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 857.91 8,117.01 50.668 7,902.99 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,300.00 1,037.25 79.788 262.75 135-50070-010-000 Employee Relations 300.00 300.00 148.18 49.393 151.82 Subtotal: 456,917.00 394,484.00 30,032.88 295,070.58 74.799 99,413.42 135-55005-010-000 Engineering 10,000.00 10,000.00 3,000.00- 1,290.00- -12.900 11,290.00 135-55080-010-000 Maintenance & Repairs 71,242.00 81,113.00 4,673.24 60,123.07 74.123 20,989.93 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 183.12 7,465.80 93.323 534.20 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 363.69 3,827.16 109.347 327.16- 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 250.00 3,972.50 72.227 1,527.50 Subtotal: 98,242.00 108,113.00 2,470.05 74,098.53 68.538 34,014.47 135-60010-010-000 Communications/Mobiles 4,913.00 4,913.00 397.93 3,598.89 73.252 1,314.11 135-60020-010-000 Electricity 170,765.00 160,765.00 17,914.57 115,724.14 71.983 45,040.86 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 738.50 147.700 238.50- 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,138.00 4,138.00 180.00 1,353.00 32.697 2,785.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 1,500.00 141.20 240.29 16.019 1,259.71 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 3,261.30 23,917.91 48.540 25,357.09 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 242,208.79 1,454,267.73 49.662 1,474,040.27 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 1,446.45 41.327 2,053.55 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 3,500.00 898.98 1,823.49 52.100 1,676.51 Subtotal: 3,169,249.00 3,159,249.00 265,002.77 1,603,110.40 50.743 1,556,138.60 135-65005-010-000 Fuel & Lube 29,172.00 19,173.00 1,068.66 11,383.25 59.371 7,789.75 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,620.00 3,620.00 3,184.80 87.978 435.20 135-65030-010-000 Chemicals 7,000.00 10,000.00 928.80 9,354.74 93.547 645.26 135-65035-010-000 Small Tools 1,200.00 1,200.00 637.64 53.137 562.36 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 457.01 45.701 542.99 135-65050-010-000 Meter Expense 161,500.00 165,000.00 7,250.00 119,269.34 72.284 45,730.66 Subtotal: 203,492.00 199,993.00 9,247.46 144,286.78 72.146 55,706.22 135-69005-010-000 Capital Outlays 1,089,006.00 1,457,597.00 31,328.43 293,474.78 20.134 1,164,122.22 135-69008-010-000 Short Term Debt-Principal 129,000.00 129,000.00 129,000.00 100.000 135-69009-010-000 Short Term Debt-Interest 3,612.00 3,612.00 1,215.96 3,631.54 100.541 19.54- 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 151,507.00 151,507.00 126,957.76 83.797 24,549.24 Subtotal: 1,448,125.00 1,816,716.00 32,544.39 628,064.08 34.571 1,188,651.92 Program number: 5,376,025.00 5,678,555.00 339,297.55 2,744,630.37 48.333 2,933,924.63 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/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 85.00 2,782.60 55.652 2,217.40 Subtotal: 5,000.00 5,000.00 85.00 2,782.60 55.652 2,217.40 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 2,418.75 48.375 2,581.25 Subtotal: 5,000.00 5,000.00 2,418.75 48.375 2,581.25 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 85.00 5,201.35 52.014 4,798.65 Department number: Water 5,386,025.00 5,688,555.00 339,382.55 2,749,831.72 48.340 2,938,723.28 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 305,744.00 307,875.00 23,690.63 272,079.31 88.373 35,795.69 135-50010-020-000 Overtime 19,500.00 24,500.00 1,470.74 24,966.79 101.905 466.79- 135-50016-020-000 Longevity 5,617.00 5,617.00 5,615.00 99.964 2.00 135-50017-020-000 Certification 6,600.00 6,600.00 550.00 6,050.00 91.667 550.00 135-50020-020-000 Retirement 29,948.00 30,317.00 2,290.89 27,558.16 90.900 2,758.84 135-50026-020-000 Medical Insurance 61,001.00 56,244.00 4,686.75 51,051.64 90.768 5,192.36 135-50027-020-000 Dental Insurance 4,146.00 3,696.00 299.51 3,264.02 88.312 431.98 135-50028-020-000 Vision Insurance 990.00 912.00 69.00 756.39 82.938 155.61 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 289.36 3,134.57 98.139 59.43 135-50030-020-000 Social Security Taxes 21,680.00 21,812.00 1,431.53 17,360.15 79.590 4,451.85 135-50035-020-000 Medicare Taxes 5,070.00 5,101.00 334.79 4,045.29 79.304 1,055.71 135-50040-020-000 Unemployment Taxes 1,242.00 1,242.00 13.90 1.119 1,228.10 135-50045-020-000 Workman's Compensation 16,020.00 16,020.00 857.91 8,117.01 50.668 7,902.99 135-50060-020-000 Pre-emp Physicals/Testing 150.00 300.00 63.00 189.00 63.000 111.00 135-50070-020-000 Employee Relations 550.00 650.00 523.15 80.485 126.85 Subtotal: 481,452.00 484,080.00 36,034.11 424,724.38 87.738 59,355.62 135-55080-020-000 Maintenance & Repairs 58,000.00 72,600.00 1,279.50 87,984.08 121.190 15,384.08- 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 198.71 3,523.25 117.442 523.25- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 803.29 160.658 303.29- 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 3,110.87 43,099.62 78.363 11,900.38 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,032.00 24,245.50 96.982 754.50 Subtotal: 141,500.00 156,100.00 6,621.08 159,655.74 102.278 3,555.74- 135-60010-020-000 Communications/Mobiles 4,662.00 4,662.00 499.49 4,913.66 105.398 251.66- 135-60020-020-000 Electricity 149,292.00 139,292.00 39,195.65 134,202.10 96.346 5,089.90 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 134.85 33.713 265.15 135-60070-020-000 Dues & Memberships 250.00 250.00 307.00 122.800 57.00- 135-60080-020-000 Schools & Training 4,065.00 3,065.00 1,526.00 49.788 1,539.00 135-60090-020-000 Safety Program 550.00 550.00 550.00 135-60100-020-000 Travel & per diem 1,600.00 2,000.00 12.66 1,825.89 91.295 174.11 135-60105-020-000 Rent/Lease Equipment 9,000.00 7,500.00 1.00 .013 7,499.00 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 9,019.00 52.589 8,131.00 135-60245-020-000 Miscellaneous Expenses 300.00 300.00 19.47 19.47 6.490 280.53 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 784.59 156.918 284.59- 135-60331-020-000 Interfund Transfer Out-Tax I&S 65,255.00 30,645.00 46.962 34,610.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 136,989.00 136,989.00 100.000 135-60333-020-000 Interfund Transfer Out-Reserve 71,946.00 10,278.00 61,668.00 85.714 10,278.00 Subtotal: 187,769.00 449,859.00 50,005.27 382,035.56 84.923 67,823.44 135-65005-020-000 Fuel & Lube 36,328.00 20,328.00 998.35 16,172.76 79.559 4,155.24 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-020-000 Uniforms 2,778.00 2,778.00 2,598.44 93.536 179.56 135-65030-020-000 Chemicals 30,000.00 24,000.00 3,320.00 18,098.02 75.408 5,901.98 135-65035-020-000 Small Tools 2,000.00 1,500.00 548.00 1,427.20 95.147 72.80 135-65040-020-000 Safety Equipment 750.00 750.00 625.68 83.424 124.32 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 12,341.13 94.932 658.87 Subtotal: 84,856.00 62,356.00 4,866.35 51,263.23 82.211 11,092.77 135-69005-020-000 Capital Outlays 150,000.00 142,000.00 41,765.74 198,660.42 139.902 56,660.42- 135-69007-020-000 LTD Payment from WW Sales 357,538.00 135-69008-020-000 Short Term Debt-Principal 56,991.00 56,991.00 56,991.00 100.000 135-69009-020-000 Short Term Debt-Interest 2,011.00 2,011.00 174.56 1,951.94 97.063 59.06 Subtotal: 566,540.00 201,002.00 41,940.30 257,603.36 128.160 56,601.36- Program number: 1,462,117.00 1,353,397.00 139,467.11 1,275,282.27 94.228 78,114.73 Department number: Wastewater 1,462,117.00 1,353,397.00 139,467.11 1,275,282.27 94.228 78,114.73 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,500.00 12,500.00 125.000 2,500.00- 135-50030-026-000 Social Security Taxes 620.00 620.00 93.00 775.00 125.000 155.00- 135-50035-026-000 Medicare Taxes 145.00 145.00 21.75 181.25 125.000 36.25- 135-50040-026-000 Unemployment Taxes 230.00 230.00 1.50 64.68 28.122 165.32 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 32.34 89.833 3.66 Subtotal: 11,031.00 11,031.00 1,619.19 13,553.27 122.865 2,522.27- 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 950.00 90.42 275.64 29.015 674.36 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,620.00 2,950.00 73.750 1,050.00 135-60100-026-000 Travel & per diem 5,000.00 4,250.00 3,478.88 81.856 771.12 135-60245-026-000 Miscellaneous Expenses 1,000.00 2,000.00 1,644.74 82.237 355.26 Subtotal: 11,850.00 11,850.00 1,710.42 8,384.26 70.753 3,465.74 Program number: 22,881.00 22,881.00 3,329.61 21,937.53 95.877 943.47 Department number: Board of Directors 22,881.00 22,881.00 3,329.61 21,937.53 95.877 943.47 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 477,578.00 470,732.00 35,984.57 413,978.88 87.944 56,753.12 135-50010-030-000 Overtime 1,000.00 1,000.00 516.03 51.603 483.97 135-50016-030-000 Longevity 3,283.00 3,283.00 3,282.50 99.985 .50 135-50020-030-000 Retirement 42,840.00 42,184.00 3,206.23 37,291.65 88.402 4,892.35 135-50026-030-000 Medical Insurance 65,015.00 62,000.00 5,166.33 53,876.85 86.898 8,123.15 135-50027-030-000 Dental Insurance 4,944.00 4,494.00 364.24 3,245.27 72.213 1,248.73 135-50028-030-000 Vision Insurance 1,158.00 1,116.00 84.38 894.49 80.151 221.51 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 369.42 4,016.03 92.685 316.97 135-50030-030-000 Social Security Taxes 30,079.00 29,654.00 2,078.91 24,450.80 82.454 5,203.20 135-50035-030-000 Medicare Taxes 7,422.00 7,317.00 486.20 5,718.31 78.151 1,598.69 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 143.56 9.908 1,305.44 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 960.30 58.698 675.70 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 38.00 7.600 462.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 2,690.29 53.806 2,309.71 Subtotal: 646,237.00 634,698.00 47,827.58 551,102.96 86.829 83,595.04 135-55030-030-000 Software & Support 75,588.00 121,635.00 4,915.77 110,022.58 90.453 11,612.42 135-55070-030-000 Independent Labor 8,000.00 32,550.00 2,112.85 34,211.32 105.104 1,661.32- 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 95.00 534.94 11.888 3,965.06 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 629.84 6,236.72 95.950 263.28 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 627.53 6,275.30 77.473 1,824.70 135-55160-030-000 Professional Outside Services 58,000.00 61,950.00 3,517.50 20,117.45 32.474 41,832.55 135-55161-030-000 Town Personnel Contract 6,170.00 26,170.00 26,170.00 100.000 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.70 6,188.47 75.469 2,011.53 Subtotal: 175,258.00 269,805.00 12,539.19 209,756.78 77.744 60,048.22 135-60005-030-000 Telephone 13,361.00 13,361.00 652.89 10,626.49 79.534 2,734.51 135-60010-030-000 Communications/Mobiles 4,056.00 4,056.00 337.99 3,715.24 91.599 340.76 135-60020-030-000 Electricity/Gas 14,978.00 12,000.00 3,358.27 8,509.62 70.914 3,490.38 135-60025-030-000 Water 1,500.00 1,500.00 114.90 798.11 53.207 701.89 135-60035-030-000 Postage 28,500.00 28,500.00 2,567.72 27,581.76 96.778 918.24 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 4,466.09 40,371.04 126.160 8,371.04- 135-60050-030-000 Bad Debt Expense 6,200.00 6,200.00 1,711.95 27.612 4,488.05 135-60055-030-000 Insurance 48,751.00 48,751.00 4,063.01 45,047.36 92.403 3,703.64 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,600.00 1,223.77 76.486 376.23 135-60070-030-000 Dues & Memberships 5,000.00 6,000.00 4,557.95 75.966 1,442.05 135-60075-030-000 Meetings 400.00 400.00 60.11 15.028 339.89 135-60079-030-000 Public Education 5,000.00 4,078.00 3,384.79 83.001 693.21 135-60080-030-000 Schools & Training 10,235.00 10,235.00 2,938.00 28.705 7,297.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 333.88 1,969.43 36.471 3,430.57 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 1,289.22 1,289.22 1,289.22- 135-60125-030-000 Advertising 2,500.00 2,500.00 124.77 5,755.30 230.212 3,255.30- 135-60235-030-000 Security 1,350.00 1,350.00 59.85 4.433 1,290.15 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 985.25 10,731.70 61.324 6,768.30 135-60270-030-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 100.000 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 14,000.00 14,000.00 100.000 135-60360-030-000 Furniture/Equipment < $5000 10,475.00 10,475.00 5,035.96 48.076 5,439.04 Subtotal: 218,406.00 230,106.00 18,293.99 199,367.65 86.642 30,738.35 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,043.00 56.226 812.00 135-65055-030-000 Hardware 75,966.00 35,226.00 109.02 34,312.29 97.406 913.71 135-65085-030-000 Office Supplies 9,000.00 9,000.00 1,184.63 7,717.06 85.745 1,282.94 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 2,760.80 58.343 1,971.20 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 229.95 3,935.06 78.701 1,064.94 135-65097-030-000 Vending Machine Supplies 200.00 200.00 200.00 135-65105-030-000 Printing 4,800.00 4,800.00 1,332.56 27.762 3,467.44 Subtotal: 101,553.00 60,813.00 1,523.60 51,100.77 84.029 9,712.23 135-69005-030-000 Capital Outlays 125,000.00 62,000.00 61,821.66 99.712 178.34 135-69170-030-000 Copier Lease Installments 4,236.00 4,236.00 380.01 3,407.42 80.440 828.58 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 16,329.00 16,329.00 100.000 Subtotal: 145,565.00 82,565.00 380.01 81,558.08 98.780 1,006.92 Program number: 1,287,019.00 1,277,987.00 80,564.37 1,092,886.24 85.516 185,100.76 Department number: Administration 1,287,019.00 1,277,987.00 80,564.37 1,092,886.24 85.516 185,100.76 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 15:46 09/09/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 250,000.00 467,403.00 7,430.25 452,944.92 96.907 14,458.08 135-55055-039-000 Auditing 22,491.00 22,491.00 16,836.00 74.857 5,655.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 7,964.16 79.642 2,035.84 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,456.40 64.642 1,343.60 Subtotal: 286,291.00 503,694.00 7,430.25 480,201.48 95.336 23,492.52 Program number: 286,291.00 503,694.00 7,430.25 480,201.48 95.336 23,492.52 Department number: Non Departmental 286,291.00 503,694.00 7,430.25 480,201.48 95.336 23,492.52 Expenditures Subtotal ----------- 8,444,333.00 8,846,514.00 570,173.89 5,620,139.24 63.529 3,226,374.76 Fund number: 135 MUD 1 General Fund 344,173.73- 1,407,848.85- 1,407,848.85 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 15:46 09/09/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/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 91,329.00- 91,329.00 137-49146-000-000 Intergov Transfer-Fire Dept 17,950.00- 17,950.00 Subtotal: 109,279.00- 109,279.00 Program number: 109,279.00- 109,279.00 Department number: 109,279.00- 109,279.00 Revenues Subtotal ----------- 109,279.00- 109,279.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 15:46 09/09/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-030-000 GASB Replacement 74,706.00 74,706.00- Subtotal: 74,706.00 74,706.00- Program number: 74,706.00 74,706.00- Department number: Administration 74,706.00 74,706.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 15:46 09/09/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-045-000 GASB Replacement 125,670.00 125,670.00- Subtotal: 125,670.00 125,670.00- Program number: 125,670.00 125,670.00- Department number: Fire Department 125,670.00 125,670.00- Expenditures Subtotal ----------- 200,376.00 200,376.00- Fund number: 137 MUD 1 Consolidated GASB 91,097.00 91,097.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 15:46 09/09/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 1.28- 11.95- 11.95 Subtotal: 1.28- 11.95- 11.95 Program number: 1.28- 11.95- 11.95 Department number: 1.28- 11.95- 11.95 Revenues Subtotal ----------- 1.28- 11.95- 11.95 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 15:46 09/09/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Subtotal: 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Program number: 3 Indian Creek Waterline 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Department number: Water 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Expenditures Subtotal ----------- 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Fund number: 507 MUD 1 Capital Projects 3,348.00 3,348.00 1.28- 2,238.05 66.847 1,109.95 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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 2073 08/03/2015 Property Taxes/Assessments (167,365.32) (65.66) (167,430.98) GL 2074 08/04/2015 Property Taxes/Assessments (38.99) (167,469.97) GL 2075 08/06/2015 Property Taxes/Assessments (97.54) (167,567.51) GL 2076 08/10/2015 Property Taxes/Assessments (7.16) (167,574.67) GL 2077 08/12/2015 Property Taxes/Assessments (5.71) (167,580.38) GL 2078 08/17/2015 Property Taxes/Assessments (.05) (167,580.43) GL 2079 08/19/2015 Property Taxes/Assessments 7.43 (167,573.00) GL 2080 08/20/2015 Property Taxes/Assessments (10.96) (167,583.96) GL 2081 08/24/2015 Property Taxes/Assessments 78.64 (167,505.32) GL 2082 08/27/2015 Property Taxes/Assessments (2.56) (167,507.88) GL 2083 08/31/2015 Property Taxes/Assessments (2.09) (167,509.97) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (144.65) (167,509.97) ** (167,857.00) Budgeted (347.03) Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2074 08/04/2015 Property Taxes/Assessments (439.64) (2.52) (442.16) GL 2076 08/10/2015 Property Taxes/Assessments (.01) (442.17) GL 2083 08/31/2015 Property Taxes/Assessments (.49) (442.66) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (3.02) (442.66) ** .00 Budgeted 442.66 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2074 08/04/2015 Property Taxes/Assessments (609.55) (1.25) (610.80) GL 2075 08/06/2015 Property Taxes/Assessments (17.36) (628.16) GL 2077 08/12/2015 Property Taxes/Assessments (.40) (628.56) GL 2078 08/17/2015 Property Taxes/Assessments (.01) (628.57) GL 2080 08/20/2015 Property Taxes/Assessments (.77) (629.34) GL 2082 08/27/2015 Property Taxes/Assessments (.44) (629.78) GL 2083 08/31/2015 Property Taxes/Assessments (.25) (630.03) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (20.48) (630.03) ** (900.00) Budgeted (269.97) Remaining 70 % Used Account: 135-40025-000-000 PID Surcharges 2029 08/31/2015 UB Billing August UB20150831-20150831 User: (116,821.40) (12,148.50) (128,969.90) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (12,148.50) (128,969.90) ** (133,997.00) Budgeted (5,027.10) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-47000-000-000 Water 2033 08/06/2015 UB 8/6/15 Misread adjustment UB20150806-20150806 User: (2,515,456.65) 197.53 (2,515,259.12) UB 2038 08/28/2015 UB 8/28/15 Read adj UB20150828-20150828 User: 142.39 (2,515,116.73) UB 2029 08/31/2015 UB Billing August UB20150831-20150831 User: (587,735.53) (3,102,852.26) UB _______________ Account: 135-47000-000-000 Water Totals: (587,395.61) (3,102,852.26) ** (4,747,789.00) Budgeted (1,644,936.74) Remaining 65 % Used Account: 135-47005-000-000 Sewer 2029 08/31/2015 UB Billing August UB20150831-20150831 User: (1,629,610.23) (249,923.23) (1,879,533.46) UB _______________ Account: 135-47005-000-000 Sewer Totals: (249,923.23) (1,879,533.46) ** (2,270,982.00) Budgeted (391,448.54) Remaining 83 % Used Account: 135-47025-000-000 Penalties 2030 08/03/2015 UB 8/3/15 peanlty UB20150803-20150803 User: (72,956.03) 25.92 (72,930.11) UB 1992 08/21/2015 UB 08/21/15 Penalties UB20150821-20150821 User: (12,621.50) (85,551.61) UB 2016 08/31/2015 UB 8/31/15 Solana Penalties UB20150831-20150831 User: 410.14 (85,141.47) UB 2039 08/31/2015 UB 8/31/15 Penalty Adjustments UB20150831-20150831 User: 249.63 (84,891.84) UB _______________ Account: 135-47025-000-000 Penalties Totals: (11,935.81) (84,891.84) ** (80,000.00) Budgeted 4,891.84 Remaining 106 % Used Account: 135-47030-000-000 Service Charges 2032 08/04/2015 UB 8/4/15 NSF Check Fee UB20150804-20150804 User: (8,724.00) (25.00) (8,749.00) UB 1916 08/06/2015 UB 8/6/15 Cut Off List Fees UB20150806-20150806 User: (625.00) (9,374.00) UB 2034 08/09/2015 UB 8/9/15 After hours fee UB20150809-20150809 User: (100.00) (9,474.00) UB 2035 08/19/2015 UB 8/19/15 Nsf Check Fee UB20150819-20150819 User: (75.00) (9,549.00) UB 2063 08/24/2015 UB 8/24/15 NSF Check fee UB20150824-20150824 User: (25.00) (9,574.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (850.00) (9,574.00) ** (10,000.00) Budgeted (426.00) Remaining 96 % Used Account: 135-47035-000-000 Plumbing Inspections 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (1,800.00) (350.00) (2,150.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (350.00) (2,150.00) ** (2,000.00) Budgeted 150.00 Remaining 108 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-47045-000-000 Sewer Inspections 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (5,400.00) (1,050.00) (6,450.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,050.00) (6,450.00) ** (5,000.00) Budgeted 1,450.00 Remaining 129 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2029 08/31/2015 UB Billing August UB20150831-20150831 User: (33,665.80) (18,895.80) (52,561.60) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (18,895.80) (52,561.60) ** (86,815.00) Budgeted (34,253.40) Remaining 61 % Used Account: 135-48005-000-000 Utility Fees 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (202,400.00) (20,700.00) (223,100.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (20,700.00) (223,100.00) ** (184,000.00) Budgeted 39,100.00 Remaining 121 % Used Account: 135-49010-000-000 Interest Income 2088 08/31/2015 Bank Interest/August (5,039.11) (72.78) (5,111.89) GL 2088 08/31/2015 Bank Interest/August (125.01) (5,236.90) GL 2088 08/31/2015 Bank Interest/August (320.24) (5,557.14) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (518.03) (5,557.14) ** (5,000.00) Budgeted 557.14 Remaining 111 % Used Account: 135-49016-000-000 Cell Tower Revenue 1883 08/03/2015 Cell Tower Revenue (9,105.30) (910.53) (10,015.83) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (10,015.83) ** (10,164.00) Budgeted (148.17) Remaining 99 % Used Account: 135-49018-000-000 Building Rent Income 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (5,833.30) (583.33) (6,416.63) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (6,416.63) ** (7,000.00) Budgeted (583.37) Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (929,603.00) Budgeted (929,603.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves (74,706.00) .00 (74,706.00) _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 (74,706.00) ** (74,706.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (47,519.83) (5,358.57) (52,878.40) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,358.57) (52,878.40) ** (42,000.00) Budgeted 10,878.40 Remaining 126 % Used Account: 135-49141-000-000 Interfund Transfer In (36,766.50) .00 (36,766.50) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (36,766.50) ** (19,607.00) Budgeted 17,159.50 Remaining 188 % Used Account: 135-49145-000-000 Intergov Transfer In (1,074,337.15) .00 (1,074,337.15) _______________ Account: 135-49145-000-000 Intergov Transfer In Totals: .00 (1,074,337.15) ** .00 Budgeted 1,074,337.15 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1959 08/06/2015 Salvage Cash (105,072.46) (3,437.24) (108,509.70) GL 2029 08/31/2015 UB Billing August UB20150831-20150831 User: (45.82) (108,555.52) UB 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (75.00) (108,630.52) AR _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (3,558.06) (108,630.52) ** (68,994.00) Budgeted 39,636.52 Remaining 157 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-49901-000-000 Records Management Revenue 2044 08/28/2015 Open Records Request (12.20) (2.00) (14.20) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (2.00) (14.20) ** (100.00) Budgeted (85.80) Remaining 14 % Used Department Totals: ------------------------------------------------------------------------------------------------ (7,027,988.09) ** (8,846,514.00) Budgeted (1,818,525.91) Remaining 79 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 1937 08/14/2015 Payroll 08-14-15 Salaries & Wages 175,932.04 9,754.61 185,686.65 PR 1999 08/28/2015 PR 08-28-15 Salaries & Wages 9,756.48 195,443.13 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,511.09 195,443.13 ** 244,578.00 Budgeted 49,134.87 Remaining 80 % Used Account: 135-50010-010-000 Overtime 1937 08/14/2015 Payroll 08-14-15 Overtime 11,823.91 507.93 12,331.84 PR 1999 08/28/2015 PR 08-28-15 Overtime 966.76 13,298.60 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,474.69 13,298.60 ** 19,500.00 Budgeted 6,201.40 Remaining 68 % Used Account: 135-50016-010-000 Longevity 2,705.00 .00 2,705.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,705.00 ** 2,705.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1999 08/28/2015 PR 08-28-15 Certification 2,275.00 225.00 2,500.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 2,500.00 ** 3,900.00 Budgeted 1,400.00 Remaining 64 % Used Account: 135-50020-010-000 Retirement 1937 08/14/2015 Payroll 08-14-15 Retirement 17,204.15 914.39 18,118.54 PR 1999 08/28/2015 PR 08-28-15 Retirement 975.48 19,094.02 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,889.87 19,094.02 ** 23,987.00 Budgeted 4,892.98 Remaining 80 % Used Account: 135-50026-010-000 Medical Insurance 1937 08/14/2015 Payroll 08-14-15 Medical Insurance 27,572.80 1,946.94 29,519.74 PR 1999 08/28/2015 PR 08-28-15 Medical Insurance 1,946.88 31,466.62 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,893.82 31,466.62 ** 51,487.00 Budgeted 20,020.38 Remaining 61 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-50027-010-000 Dental Insurance 1937 08/14/2015 Payroll 08-14-15 Dental Insurance 2,211.72 151.51 2,363.23 PR 1999 08/28/2015 PR 08-28-15 Dental Insurance 151.51 2,514.74 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 303.02 2,514.74 ** 4,188.00 Budgeted 1,673.26 Remaining 60 % Used Account: 135-50028-010-000 Vision Insurance 1937 08/14/2015 Payroll 08-14-15 Vision Insurance 514.82 34.46 549.28 PR 1999 08/28/2015 PR 08-28-15 Vision Insurance 34.51 583.79 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 68.97 583.79 ** 990.00 Budgeted 406.21 Remaining 59 % Used Account: 135-50029-010-000 Life Insurance & Other 1816 08/01/2015 August A/P Dental, vision, other insuranc 1,789.73 212.31 2,002.04 METLIFE GROUP BENEFITS 35185 AP 2007 08/28/2015 August A/P Café 125 Admin Fees 8.44 2,010.48 BenefitMall 35281 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 220.75 2,010.48 ** 3,074.00 Budgeted 1,063.52 Remaining 65 % Used Account: 135-50030-010-000 Social Security Taxes 1937 08/14/2015 Payroll 08-14-15 Social Security Taxes 11,786.47 624.00 12,410.47 PR 1999 08/28/2015 PR 08-28-15 Social Security Taxes 661.12 13,071.59 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,285.12 13,071.59 ** 17,192.00 Budgeted 4,120.41 Remaining 76 % Used Account: 135-50035-010-000 Medicare Taxes 1937 08/14/2015 Payroll 08-14-15 Medicare Taxes 2,756.52 145.95 2,902.47 PR 1999 08/28/2015 PR 08-28-15 Medicare Taxes 154.61 3,057.08 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 300.56 3,057.08 ** 4,021.00 Budgeted 963.92 Remaining 76 % Used Account: 135-50040-010-000 Unemployment Taxes 1937 08/14/2015 Payroll 08-14-15 Unemployment Taxes 21.01 1.03 22.04 PR 1999 08/28/2015 PR 08-28-15 Unemployment Taxes 1.05 23.09 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-010-000 Unemployment Taxes Totals: 2.08 23.09 ** 1,242.00 Budgeted 1,218.91 Remaining 2 % Used Account: 135-50045-010-000 Workman's Compensation 201 08/01/2015 Aug TML Ins & Workers Comp 7,259.10 857.91 8,117.01 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.91 8,117.01 ** 16,020.00 Budgeted 7,902.99 Remaining 51 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1,037.25 .00 1,037.25 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 1,037.25 ** 1,300.00 Budgeted 262.75 Remaining 80 % Used Account: 135-50070-010-000 Employee Relations 148.18 .00 148.18 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 148.18 ** 300.00 Budgeted 151.82 Remaining 49 % Used Account: 135-55005-010-000 Engineering 1930 08/10/2015 Solana Water Line Billing AR 20150810-20150810 User: 1,710.00 (3,000.00) (1,290.00) AR _______________ Account: 135-55005-010-000 Engineering Totals: (3,000.00) (1,290.00) ** 10,000.00 Budgeted 11,290.00 Remaining -13 % Used Account: 135-55080-010-000 Maintenance & Repairs 1986 08/20/2015 August A/P Flanges and bolts 55,449.83 635.82 56,085.65 HD SUPPLY WATERWORKS, LTD. 35267 AP 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 JMS RUSSEL METALS CORP 143.50 56,229.15 JMS RUSSEL METALS CORP PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 SMITH PUMP CO INC 512.08 56,741.23 SMITH PUMP CO INC PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 TCEQ IND RENEWAL L 111.00 56,852.23 TCEQ IND RENEWAL L PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 THE HOME DEPOT 6581 23.88 56,876.11 THE HOME DEPOT 6581 PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 TRACTOR SUPPLY COMPANY 31.98 56,908.09 TRACTOR SUPPLY COMPANY PC 2007 08/28/2015 August A/P Meter boxes 2,059.92 58,968.01 HD SUPPLY WATERWORKS, LTD. 35288 AP 2058 08/31/2015 August A/P Nitrogen Bottle Rent 42.00 59,010.01 ALLIED WELDING SUPPLY, INC 35302 AP 2058 08/31/2015 August A/P 1" meter spuds 843.60 59,853.61 HD SUPPLY WATERWORKS, LTD. 35314 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2058 08/31/2015 August A/P 6" water repair clamps 55,449.83 380.46 60,234.07 HD SUPPLY WATERWORKS, LTD. 35314 AP 2071 08/31/2015 Move License expense Move License expense from M&R (111.00) 60,123.07 GL _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 4,673.24 60,123.07 ** 81,113.00 Budgeted 20,989.93 Remaining 74 % Used Account: 135-55090-010-000 Vehicle Maintenance 1941 08/14/2015 August A/P Vehicle Registration 2007 Dodg 7,282.68 14.25 7,296.93 DENTON COUNTY TAX OFFICE 35245 AP 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ROANOKE AUTO SUPPLY LT 123.39 7,420.32 ROANOKE AUTO SUPPLY LT PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 KWIK KAR LUBE & TUNE O 25.50 7,445.82 KWIK KAR LUBE & TUNE O PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ROANOKE AUTO SUPPLY LT 19.98 7,465.80 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 183.12 7,465.80 ** 8,000.00 Budgeted 534.20 Remaining 93 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1941 08/14/2015 August A/P Balance from used credit 3,463.47 363.69 3,827.16 HOLT CAT 35247 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 363.69 3,827.16 ** 3,500.00 Budgeted (327.16) Remaining 109 % Used Account: 135-55135-010-000 Lab Analysis 1941 08/14/2015 August A/P Water Samples - MUD 3,722.50 250.00 3,972.50 TARRANT CTY PUBLIC HEALTH LAB 35257 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 250.00 3,972.50 ** 5,500.00 Budgeted 1,527.50 Remaining 72 % Used Account: 135-60010-010-000 Communications/Mobiles 1941 08/14/2015 August A/P Cell phones 7/02-8/01/15 3,200.96 397.93 3,598.89 VERIZON WIRELESS 35260 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 397.93 3,598.89 ** 4,913.00 Budgeted 1,314.11 Remaining 73 % Used Account: 135-60020-010-000 Electricity 1986 08/20/2015 August A/P Electricity 7/13-8/11/15 97,809.57 1,504.22 99,313.79 HUDSON ENERGY SERVICES, LLC 35268 AP 1986 08/20/2015 August A/P Electricity 7/13-8/11/15 16,410.35 115,724.14 HUDSON ENERGY SERVICES, LLC 35268 AP _______________ Account: 135-60020-010-000 Electricity Totals: 17,914.57 115,724.14 ** 160,765.00 Budgeted 45,040.86 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-60066-010-000 Publications/Books/Subscripts 738.50 .00 738.50 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 738.50 ** 500.00 Budgeted (238.50) Remaining 148 % 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 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 TX DPS DL OFFICE 1,173.00 69.00 1,242.00 TX DPS DL OFFICE PC 2071 08/31/2015 Move License expense Move License expense from M&R 111.00 1,353.00 GL _______________ Account: 135-60080-010-000 Schools & Training Totals: 180.00 1,353.00 ** 4,138.00 Budgeted 2,785.00 Remaining 33 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 AMERICAN AIRLINES 99.09 141.20 240.29 AMERICAN AIRLINES PC _______________ Account: 135-60100-010-000 Travel & per diem Totals: 141.20 240.29 ** 1,500.00 Budgeted 1,259.71 Remaining 16 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1941 08/14/2015 August A/P NTGCD wells 3/31-6/30/15 20,656.61 3,261.30 23,917.91 North Texas Groundwater 35252 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 3,261.30 23,917.91 ** 49,275.00 Budgeted 25,357.09 Remaining 49 % Used Account: 135-60150-010-000 Wholesale Water 2058 08/31/2015 August A/P Wholesale Water July 1,212,058.94 242,208.79 1,454,267.73 CITY OF FORT WORTH 35306 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 242,208.79 1,454,267.73 ** 2,928,308.00 Budgeted 1,474,040.27 Remaining 50 % 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 1,446.45 .00 1,446.45 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 1,446.45 ** 3,500.00 Budgeted 2,053.55 Remaining 41 % 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 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 AMAZON MKTPLACE PMTS 924.51 898.98 1,823.49 AMAZON MKTPLACE PMTS PC _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 898.98 1,823.49 ** 3,500.00 Budgeted 1,676.51 Remaining 52 % Used Account: 135-65005-010-000 Fuel & Lube 2007 08/28/2015 August A/P Fuel 10,314.59 1,068.66 11,383.25 US Bank Voyager Fleet Systems 35300 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-65005-010-000 Fuel & Lube Totals: 1,068.66 11,383.25 ** 19,173.00 Budgeted 7,789.75 Remaining 59 % Used Account: 135-65010-010-000 Uniforms 3,184.80 .00 3,184.80 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 3,184.80 ** 3,620.00 Budgeted 435.20 Remaining 88 % Used Account: 135-65030-010-000 Chemicals 1986 08/20/2015 August A/P Nitrite test n tube 8,425.94 115.60 8,541.54 HACH COMPANY 35266 AP 2007 08/28/2015 August A/P Chlorine 813.20 9,354.74 DPC INDUSTRIES, INC 35286 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 928.80 9,354.74 ** 10,000.00 Budgeted 645.26 Remaining 94 % Used Account: 135-65035-010-000 Small Tools 637.64 .00 637.64 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 637.64 ** 1,200.00 Budgeted 562.36 Remaining 53 % Used Account: 135-65040-010-000 Safety Equipment 457.01 .00 457.01 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 457.01 ** 1,000.00 Budgeted 542.99 Remaining 46 % Used Account: 135-65050-010-000 Meter Expense 2058 08/31/2015 August A/P Meter heads 112,019.34 6,960.00 118,979.34 ATLAS UTILITY SUPPLY CO. 35304 AP 2058 08/31/2015 August A/P Meter expense 290.00 119,269.34 ATLAS UTILITY SUPPLY CO. 35304 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 7,250.00 119,269.34 ** 165,000.00 Budgeted 45,730.66 Remaining 72 % Used Account: 135-69005-010-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2007 08/28/2015 August A/P Pay application #1 PB, PO, TL 262,146.35 17,100.00 279,246.35 MCCLENDON CONSTRUCTION CO INC 35291 AP 2066 08/31/2015 August A/P 2nd 1/2 Pmt for Water Plant Ge 14,228.43 293,474.78 WORLDWIDE POWER PRODUCTS 35345 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 31,328.43 293,474.78 ** 1,457,597.00 Budgeted 1,164,122.22 Remaining 20 % Used Account: 135-69008-010-000 Short Term Debt-Principal 129,000.00 .00 129,000.00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 129,000.00 ** 129,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 1986 08/20/2015 August A/P Interest on 445K Loan 2,415.58 1,215.96 3,631.54 FIRST FINANCIAL BANK 35264 AP _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: 1,215.96 3,631.54 ** 3,612.00 Budgeted (19.54) Remaining 101 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 126,957.76 .00 126,957.76 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.76 ** 151,507.00 Budgeted 24,549.24 Remaining 84 % Used Account: 135-55135-010-001 Lab Analysis for PID 1941 08/14/2015 August A/P Water Samples - PID 2,697.60 85.00 2,782.60 TARRANT CTY PUBLIC HEALTH LAB 35257 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 85.00 2,782.60 ** 5,000.00 Budgeted 2,217.40 Remaining 56 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,418.75 .00 2,418.75 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 2,418.75 ** 5,000.00 Budgeted 2,581.25 Remaining 48 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,749,831.72 ** 5,688,555.00 Budgeted 2,938,723.28 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 1937 08/14/2015 Payroll 08-14-15 Salaries & Wages 248,388.68 11,849.28 260,237.96 PR 1999 08/28/2015 PR 08-28-15 Salaries & Wages 11,841.35 272,079.31 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 23,690.63 272,079.31 ** 307,875.00 Budgeted 35,795.69 Remaining 88 % Used Account: 135-50010-020-000 Overtime 1937 08/14/2015 Payroll 08-14-15 Overtime 23,496.05 796.63 24,292.68 PR 1999 08/28/2015 PR 08-28-15 Overtime 674.11 24,966.79 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,470.74 24,966.79 ** 24,500.00 Budgeted (466.79) Remaining 102 % Used Account: 135-50016-020-000 Longevity 5,615.00 .00 5,615.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 5,615.00 ** 5,617.00 Budgeted 2.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1999 08/28/2015 PR 08-28-15 Certification 5,500.00 550.00 6,050.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 6,050.00 ** 6,600.00 Budgeted 550.00 Remaining 92 % Used Account: 135-50020-020-000 Retirement 1937 08/14/2015 Payroll 08-14-15 Retirement 25,267.27 1,126.75 26,394.02 PR 1999 08/28/2015 PR 08-28-15 Retirement 1,164.14 27,558.16 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,290.89 27,558.16 ** 30,317.00 Budgeted 2,758.84 Remaining 91 % Used Account: 135-50026-020-000 Medical Insurance 1937 08/14/2015 Payroll 08-14-15 Medical Insurance 46,364.89 2,343.40 48,708.29 PR 1999 08/28/2015 PR 08-28-15 Medical Insurance 2,343.35 51,051.64 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,686.75 51,051.64 ** 56,244.00 Budgeted 5,192.36 Remaining 91 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-50027-020-000 Dental Insurance 1937 08/14/2015 Payroll 08-14-15 Dental Insurance 2,964.51 149.75 3,114.26 PR 1999 08/28/2015 PR 08-28-15 Dental Insurance 149.76 3,264.02 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 299.51 3,264.02 ** 3,696.00 Budgeted 431.98 Remaining 88 % Used Account: 135-50028-020-000 Vision Insurance 1937 08/14/2015 Payroll 08-14-15 Vision Insurance 687.39 34.48 721.87 PR 1999 08/28/2015 PR 08-28-15 Vision Insurance 34.52 756.39 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 69.00 756.39 ** 912.00 Budgeted 155.61 Remaining 83 % Used Account: 135-50029-020-000 Life Insurance & Other 1816 08/01/2015 August A/P Dental, vision, other insuranc 2,845.21 255.58 3,100.79 METLIFE GROUP BENEFITS 35185 AP 2007 08/28/2015 August A/P Café 125 Admin Fees 33.78 3,134.57 BenefitMall 35281 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 289.36 3,134.57 ** 3,194.00 Budgeted 59.43 Remaining 98 % Used Account: 135-50030-020-000 Social Security Taxes 1937 08/14/2015 Payroll 08-14-15 Social Security Taxes 15,928.62 710.34 16,638.96 PR 1999 08/28/2015 PR 08-28-15 Social Security Taxes 721.19 17,360.15 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,431.53 17,360.15 ** 21,812.00 Budgeted 4,451.85 Remaining 80 % Used Account: 135-50035-020-000 Medicare Taxes 1937 08/14/2015 Payroll 08-14-15 Medicare Taxes 3,710.50 166.12 3,876.62 PR 1999 08/28/2015 PR 08-28-15 Medicare Taxes 168.67 4,045.29 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 334.79 4,045.29 ** 5,101.00 Budgeted 1,055.71 Remaining 79 % Used Account: 135-50040-020-000 Unemployment Taxes 13.90 .00 13.90 . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-020-000 Unemployment Taxes Totals: .00 13.90 ** 1,242.00 Budgeted 1,228.10 Remaining 1 % Used Account: 135-50045-020-000 Workman's Compensation 201 08/01/2015 Aug TML Ins & Workers Comp 7,259.10 857.91 8,117.01 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.91 8,117.01 ** 16,020.00 Budgeted 7,902.99 Remaining 51 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 2007 08/28/2015 August A/P Employee testing 126.00 63.00 189.00 CARENOW CORPORATE 35283 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 63.00 189.00 ** 300.00 Budgeted 111.00 Remaining 63 % Used Account: 135-50070-020-000 Employee Relations 523.15 .00 523.15 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 523.15 ** 650.00 Budgeted 126.85 Remaining 80 % Used Account: 135-55080-020-000 Maintenance & Repairs 1986 08/20/2015 August A/P Repair LS3 control panel 86,704.58 893.71 87,598.29 NORTH TEXAS PUMP CO. 35272 AP 2007 08/28/2015 August A/P UV Bulbs 385.79 87,984.08 UV DOCTOR LAMPS LLC 35301 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 1,279.50 87,984.08 ** 72,600.00 Budgeted (15,384.08) Remaining 121 % Used Account: 135-55090-020-000 Vehicle Maintenance 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 BLAGG TIRE & SERVICE 3,324.54 15.00 3,339.54 BLAGG TIRE & SERVICE PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ROANOKE AUTO SUPPLY LT 167.48 3,507.02 ROANOKE AUTO SUPPLY LT PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ROANOKE AUTO SUPPLY LT 16.23 3,523.25 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 198.71 3,523.25 ** 3,000.00 Budgeted (523.25) Remaining 117 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 803.29 .00 803.29 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 803.29 ** 500.00 Budgeted (303.29) Remaining 161 % Used Account: 135-55125-020-000 Dumpster Services 1941 08/14/2015 August A/P Sludge haul off 39,988.75 1,598.74 41,587.49 L.H. CHANEY MATERIALS, INC. 35250 AP 2058 08/31/2015 August A/P Sludge haul off 1,512.13 43,099.62 L.H. CHANEY MATERIALS, INC. 35323 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,110.87 43,099.62 ** 55,000.00 Budgeted 11,900.38 Remaining 78 % Used Account: 135-55135-020-000 Lab Analysis 1941 08/14/2015 August A/P Lab analysis 22,213.50 246.00 22,459.50 OXIDOR LABORATORIES LLC 35254 AP 1941 08/14/2015 August A/P Lab analysis 176.00 22,635.50 OXIDOR LABORATORIES LLC 35254 AP 1941 08/14/2015 August A/P Lab analysis 246.00 22,881.50 OXIDOR LABORATORIES LLC 35254 AP 1986 08/20/2015 August A/P Lab analysis 176.00 23,057.50 OXIDOR LABORATORIES LLC 35273 AP 2007 08/28/2015 August A/P Lab analysis 176.00 23,233.50 OXIDOR LABORATORIES LLC 35295 AP 2007 08/28/2015 August A/P Lab analysis 246.00 23,479.50 OXIDOR LABORATORIES LLC 35295 AP 2007 08/28/2015 August A/P Lab analysis 176.00 23,655.50 OXIDOR LABORATORIES LLC 35295 AP 2058 08/31/2015 August A/P Lab analysis 590.00 24,245.50 HUTHER AND ASSOCIATES,INC 35319 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,032.00 24,245.50 ** 25,000.00 Budgeted 754.50 Remaining 97 % Used Account: 135-60010-020-000 Communications/Mobiles 1941 08/14/2015 August A/P Cell phones 7/02-8/01/15 4,414.17 369.54 4,783.71 VERIZON WIRELESS 35260 AP 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 YAKETY YAK WIRLESS 129.95 4,913.66 YAKETY YAK WIRLESS PC _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 499.49 4,913.66 ** 4,662.00 Budgeted (251.66) Remaining 105 % Used Account: 135-60020-020-000 Electricity 1941 08/14/2015 August A/P Electricity 6/29-7/28/15 95,006.45 341.39 95,347.84 TRI COUNTY ELECTRIC 35259 AP 1941 08/14/2015 August A/P Electricity 6/29-7/28/15 173.71 95,521.55 TRI COUNTY ELECTRIC 35259 AP 1941 08/14/2015 August A/P Electricity 6/29-7/28/15 27.76 95,549.31 TRI COUNTY ELECTRIC 35259 AP 1986 08/20/2015 August A/P Electricity 7/10-8/10/15 57.36 95,606.67 HUDSON ENERGY SERVICES, LLC 35268 AP 1986 08/20/2015 August A/P Electricity 7/10-8/10/15 46.65 95,653.32 HUDSON ENERGY SERVICES, LLC 35268 AP 1986 08/20/2015 August A/P Electricity 7/13-8/11/15 83.17 95,736.49 HUDSON ENERGY SERVICES, LLC 35268 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1986 08/20/2015 August A/P Electricity 7/13-8/11/15 95,006.45 435.43 96,171.92 HUDSON ENERGY SERVICES, LLC 35268 AP 1986 08/20/2015 August A/P Electricity 6/11 & 7/13-8/11/1 38,298.55 134,470.47 HUDSON ENERGY SERVICES, LLC 35268 AP 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (268.37) 134,202.10 AR _______________ Account: 135-60020-020-000 Electricity Totals: 39,195.65 134,202.10 ** 139,292.00 Budgeted 5,089.90 Remaining 96 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 134.85 .00 134.85 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 134.85 ** 400.00 Budgeted 265.15 Remaining 34 % Used Account: 135-60070-020-000 Dues & Memberships 307.00 .00 307.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 307.00 ** 250.00 Budgeted (57.00) Remaining 123 % Used Account: 135-60080-020-000 Schools & Training 1,526.00 .00 1,526.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 1,526.00 ** 3,065.00 Budgeted 1,539.00 Remaining 50 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 2007 08/28/2015 August A/P Tolls 1,813.23 12.66 1,825.89 NTTA 35293 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 12.66 1,825.89 ** 2,000.00 Budgeted 174.11 Remaining 91 % Used Account: 135-60105-020-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1.00 .00 1.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1.00 ** 7,500.00 Budgeted 7,499.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 9,019.00 .00 9,019.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 9,019.00 ** 17,150.00 Budgeted 8,131.00 Remaining 53 % Used Account: 135-60245-020-000 Miscellaneous Expenses 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 WALGREENS #6047 19.47 19.47 WALGREENS #6047 PC _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 19.47 19.47 ** 300.00 Budgeted 280.53 Remaining 6 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 784.59 .00 784.59 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 784.59 ** 500.00 Budgeted (284.59) Remaining 157 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 30,645.00 .00 30,645.00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 30,645.00 ** 65,255.00 Budgeted 34,610.00 Remaining 47 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 136,989.00 .00 136,989.00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 136,989.00 ** 136,989.00 Budgeted .00 Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1958 08/03/2015 Rev Bond Reserve transfer 51,390.00 10,278.00 61,668.00 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 61,668.00 ** 71,946.00 Budgeted 10,278.00 Remaining 86 % Used Account: 135-65005-020-000 Fuel & Lube 2007 08/28/2015 August A/P Fuel 15,174.41 998.35 16,172.76 US Bank Voyager Fleet Systems 35300 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 998.35 16,172.76 ** 20,328.00 Budgeted 4,155.24 Remaining 80 % Used Account: 135-65010-020-000 Uniforms 2,598.44 .00 2,598.44 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 2,598.44 ** 2,778.00 Budgeted 179.56 Remaining 94 % Used Account: 135-65030-020-000 Chemicals 2058 08/31/2015 August A/P Freestyle Calc Hypochlorite 14,778.02 2,240.00 17,018.02 HARCROS CHEMICALS INC 35313 AP 2058 08/31/2015 August A/P Clarafloc 1,080.00 18,098.02 POLYDYNE, INC 35338 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 3,320.00 18,098.02 ** 24,000.00 Budgeted 5,901.98 Remaining 75 % Used Account: 135-65035-020-000 Small Tools 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 THE HOME DEPOT 6581 879.20 289.00 1,168.20 THE HOME DEPOT 6581 PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 THE HOME DEPOT 6581 259.00 1,427.20 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 548.00 1,427.20 ** 1,500.00 Budgeted 72.80 Remaining 95 % Used Account: 135-65040-020-000 Safety Equipment 625.68 .00 625.68 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 625.68 ** 750.00 Budgeted 124.32 Remaining 83 % Used Account: 135-65045-020-000 Lab Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 12,341.13 .00 12,341.13 _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 12,341.13 ** 13,000.00 Budgeted 658.87 Remaining 95 % Used Account: 135-69005-020-000 Capital Outlays 1984 08/20/2015 Retainage Lift Station 2 App 3 156,894.68 4,277.67 161,172.35 GL 1986 08/20/2015 August A/P Engineering Lift Station #2 181.00 161,353.35 THE WALLACE GROUP, INC. 35277 AP 1986 08/20/2015 August A/P Lift Station #2 Application 4 35,407.07 196,760.42 REY-MAR CONSTRUCTION 35274 AP 2006 08/26/2015 Retainage Pebble Beach App 1 1,900.00 198,660.42 GL _______________ Account: 135-69005-020-000 Capital Outlays Totals: 41,765.74 198,660.42 ** 142,000.00 Budgeted (56,660.42) Remaining 140 % Used Account: 135-69008-020-000 Short Term Debt-Principal 56,991.00 .00 56,991.00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 56,991.00 ** 56,991.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 1986 08/20/2015 August A/P Interest on 445K Loan 1,777.38 197.95 1,975.33 FIRST FINANCIAL BANK 35264 AP 2043 08/28/2015 Gap Vax Overpayment (23.39) 1,951.94 GL _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: 174.56 1,951.94 ** 2,011.00 Budgeted 59.06 Remaining 97 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,275,282.27 ** 1,353,397.00 Budgeted 78,114.73 Remaining 94 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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 1937 08/14/2015 Payroll 08-14-15 Salaries & Wages 11,000.00 500.00 11,500.00 PR 1999 08/28/2015 PR 08-28-15 Salaries & Wages 1,000.00 12,500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,500.00 12,500.00 ** 10,000.00 Budgeted (2,500.00) Remaining 125 % Used Account: 135-50030-026-000 Social Security Taxes 1937 08/14/2015 Payroll 08-14-15 Social Security Taxes 682.00 31.00 713.00 PR 1999 08/28/2015 PR 08-28-15 Social Security Taxes 62.00 775.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 93.00 775.00 ** 620.00 Budgeted (155.00) Remaining 125 % Used Account: 135-50035-026-000 Medicare Taxes 1937 08/14/2015 Payroll 08-14-15 Medicare Taxes 159.50 7.25 166.75 PR 1999 08/28/2015 PR 08-28-15 Medicare Taxes 14.50 181.25 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 21.75 181.25 ** 145.00 Budgeted (36.25) Remaining 125 % Used Account: 135-50040-026-000 Unemployment Taxes 1937 08/14/2015 Payroll 08-14-15 Unemployment Taxes 63.18 .50 63.68 PR 1999 08/28/2015 PR 08-28-15 Unemployment Taxes 1.00 64.68 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.50 64.68 ** 230.00 Budgeted 165.32 Remaining 28 % Used Account: 135-50045-026-000 Workman's Compensation 201 08/01/2015 Aug TML Ins & Workers Comp 29.40 2.94 32.34 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 32.34 ** 36.00 Budgeted 3.66 Remaining 90 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 1941 08/14/2015 August A/P AWBD Conference Hase 185.22 810.00 995.22 AWBD 35241 AP 1941 08/14/2015 August A/P AWBD Conference Twomey 810.00 1,805.22 AWBD 35241 AP 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ESCAPE DONUT 31.57 1,836.79 ESCAPE DONUT PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 WEINBERGERS DELI TWO 47.88 1,884.67 WEINBERGERS DELI TWO PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 RANDALLS STORE00017897 10.97 1,895.64 RANDALLS STORE00017897 PC 2094 08/31/2015 Recode AWBD Expenses (1,620.00) 275.64 GL _______________ Account: 135-60075-026-000 Meetings Totals: 90.42 275.64 ** 950.00 Budgeted 674.36 Remaining 29 % Used Account: 135-60080-026-000 Schools & Training 2094 08/31/2015 Recode AWBD Expenses 1,330.00 1,620.00 2,950.00 GL _______________ Account: 135-60080-026-000 Schools & Training Totals: 1,620.00 2,950.00 ** 4,000.00 Budgeted 1,050.00 Remaining 74 % Used Account: 135-60100-026-000 Travel & per diem 3,478.88 .00 3,478.88 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 3,478.88 ** 4,250.00 Budgeted 771.12 Remaining 82 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1,644.74 .00 1,644.74 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,644.74 ** 2,000.00 Budgeted 355.26 Remaining 82 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 21,937.53 ** 22,881.00 Budgeted 943.47 Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 1937 08/14/2015 Payroll 08-14-15 Salaries & Wages 377,994.31 17,993.25 395,987.56 PR 1999 08/28/2015 PR 08-28-15 Salaries & Wages 17,991.32 413,978.88 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,984.57 413,978.88 ** 470,732.00 Budgeted 56,753.12 Remaining 88 % Used Account: 135-50010-030-000 Overtime 516.03 .00 516.03 _______________ Account: 135-50010-030-000 Overtime Totals: .00 516.03 ** 1,000.00 Budgeted 483.97 Remaining 52 % Used Account: 135-50016-030-000 Longevity 3,282.50 .00 3,282.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,282.50 ** 3,283.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1937 08/14/2015 Payroll 08-14-15 Retirement 34,085.42 1,603.19 35,688.61 PR 1999 08/28/2015 PR 08-28-15 Retirement 1,603.04 37,291.65 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,206.23 37,291.65 ** 42,184.00 Budgeted 4,892.35 Remaining 88 % Used Account: 135-50026-030-000 Medical Insurance 1937 08/14/2015 Payroll 08-14-15 Medical Insurance 48,710.52 2,583.19 51,293.71 PR 1999 08/28/2015 PR 08-28-15 Medical Insurance 2,583.14 53,876.85 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,166.33 53,876.85 ** 62,000.00 Budgeted 8,123.15 Remaining 87 % Used Account: 135-50027-030-000 Dental Insurance 1937 08/14/2015 Payroll 08-14-15 Dental Insurance 2,881.03 182.11 3,063.14 PR 1999 08/28/2015 PR 08-28-15 Dental Insurance 182.13 3,245.27 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 364.24 3,245.27 ** 4,494.00 Budgeted 1,248.73 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-50028-030-000 Vision Insurance 1937 08/14/2015 Payroll 08-14-15 Vision Insurance 810.11 42.16 852.27 PR 1999 08/28/2015 PR 08-28-15 Vision Insurance 42.22 894.49 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 84.38 894.49 ** 1,116.00 Budgeted 221.51 Remaining 80 % Used Account: 135-50029-030-000 Life Insurance & Other 1816 08/01/2015 August A/P Dental, vision, other insuranc 3,646.61 335.64 3,982.25 METLIFE GROUP BENEFITS 35185 AP 2007 08/28/2015 August A/P Café 125 Admin Fees 33.78 4,016.03 BenefitMall 35281 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 369.42 4,016.03 ** 4,333.00 Budgeted 316.97 Remaining 93 % Used Account: 135-50030-030-000 Social Security Taxes 1937 08/14/2015 Payroll 08-14-15 Social Security Taxes 22,371.89 1,044.91 23,416.80 PR 1999 08/28/2015 PR 08-28-15 Social Security Taxes 1,034.00 24,450.80 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,078.91 24,450.80 ** 29,654.00 Budgeted 5,203.20 Remaining 82 % Used Account: 135-50035-030-000 Medicare Taxes 1937 08/14/2015 Payroll 08-14-15 Medicare Taxes 5,232.11 244.38 5,476.49 PR 1999 08/28/2015 PR 08-28-15 Medicare Taxes 241.82 5,718.31 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 486.20 5,718.31 ** 7,317.00 Budgeted 1,598.69 Remaining 78 % Used Account: 135-50040-030-000 Unemployment Taxes 143.56 .00 143.56 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 143.56 ** 1,449.00 Budgeted 1,305.44 Remaining 10 % Used Account: 135-50045-030-000 Workman's Compensation 201 08/01/2015 Aug TML Ins & Workers Comp 873.00 87.30 960.30 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 960.30 ** 1,636.00 Budgeted 675.70 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-50060-030-000 Pre-emp Physicals/Testing 38.00 .00 38.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 500.00 Budgeted 462.00 Remaining 8 % Used Account: 135-50070-030-000 Employee Relations 2,690.29 .00 2,690.29 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 2,690.29 ** 5,000.00 Budgeted 2,309.71 Remaining 54 % Used Account: 135-55030-030-000 Software & Support 1986 08/20/2015 August A/P Internet 9/1-9/30/15 105,106.81 1,163.56 106,270.37 WHOLESALE CARRIER SERVICES INC 35279 AP 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ATT*BILL PAYMENT 106.51 106,376.88 ATT*BILL PAYMENT PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ATT*BILL PAYMENT 90.20 106,467.08 ATT*BILL PAYMENT PC 2058 08/31/2015 August A/P Software & Support 126.50 106,593.58 STW INC 35340 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 3,429.00 110,022.58 TOWN OF TROPHY CLUB 35342 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 4,915.77 110,022.58 ** 121,635.00 Budgeted 11,612.42 Remaining 90 % Used Account: 135-55070-030-000 Independent Labor 1986 08/20/2015 August A/P Water Study 32,098.47 1,959.10 34,057.57 THE WALLACE GROUP, INC. 35277 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 153.75 34,211.32 TOWN OF TROPHY CLUB 35342 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 2,112.85 34,211.32 ** 32,550.00 Budgeted (1,661.32) Remaining 105 % Used Account: 135-55080-030-000 Maintenance & Repairs 2007 08/28/2015 August A/P Fix plug in server room 439.94 95.00 534.94 DENNIS SERVICES LLC 35285 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 95.00 534.94 ** 4,500.00 Budgeted 3,965.06 Remaining 12 % Used Account: 135-55100-030-000 Building Maint & Supplies 1941 08/14/2015 August A/P A/C Repair 5,606.88 276.00 5,882.88 BNC AIR 35242 AP 1986 08/20/2015 August A/P Rug cleaning 130.89 6,013.77 G & K SERVICES 35265 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1986 08/20/2015 August A/P Rug cleaning 5,606.88 130.89 6,144.66 G & K SERVICES 35265 AP 2058 08/31/2015 August A/P Rug cleaning 130.89 6,275.55 G & K SERVICES 35310 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 70.00 6,345.55 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 87.50 6,433.05 TOWN OF TROPHY CLUB 35342 AP 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (196.33) 6,236.72 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 629.84 6,236.72 ** 6,500.00 Budgeted 263.28 Remaining 96 % Used Account: 135-55120-030-000 Cleaning Services 1986 08/20/2015 August A/P Cleaning service July 5,647.77 627.53 6,275.30 MEMBER'S BUILDING MAINTENANCE 35271 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 627.53 6,275.30 ** 8,100.00 Budgeted 1,824.70 Remaining 77 % Used Account: 135-55160-030-000 Professional Outside Services 1986 08/20/2015 August A/P Boundary survey of golf course 16,599.95 3,517.50 20,117.45 THE WALLACE GROUP, INC. 35277 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 3,517.50 20,117.45 ** 61,950.00 Budgeted 41,832.55 Remaining 32 % Used Account: 135-55161-030-000 Town Personnel Contract 26,170.00 .00 26,170.00 _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 26,170.00 ** 26,170.00 Budgeted .00 Remaining 100 % 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 1941 08/14/2015 August A/P Utility Billing July 5,547.77 640.70 6,188.47 DATAPROSE LLC 35244 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 640.70 6,188.47 ** 8,200.00 Budgeted 2,011.53 Remaining 75 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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 1986 08/20/2015 August A/P Answering Service 8/24-9/20/15 9,973.60 180.00 10,153.60 KEYSTONE PARK SECRETARIAL 35269 AP 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 RINGCENTRAL, INC 9.99 10,163.59 RINGCENTRAL, INC PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ATT*BUS PHONE PMT 462.90 10,626.49 ATT*BUS PHONE PMT PC _______________ Account: 135-60005-030-000 Telephone Totals: 652.89 10,626.49 ** 13,361.00 Budgeted 2,734.51 Remaining 80 % Used Account: 135-60010-030-000 Communications/Mobiles 1941 08/14/2015 August A/P Cell phones 7/02-8/01/15 3,377.25 37.99 3,415.24 VERIZON WIRELESS 35260 AP 1999 08/28/2015 PR 08-28-15 Communications/Mobiles 300.00 3,715.24 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 3,715.24 ** 4,056.00 Budgeted 340.76 Remaining 92 % Used Account: 135-60020-030-000 Electricity/Gas 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 5,151.35 694.70 5,846.05 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 787.15 6,633.20 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Charter, Gexa, Nevill, Beck EM 1,126.44 7,759.64 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Charter, Gexa, Nevill, Beck EM 749.98 8,509.62 TOWN OF TROPHY CLUB 35342 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 3,358.27 8,509.62 ** 12,000.00 Budgeted 3,490.38 Remaining 71 % Used Account: 135-60025-030-000 Water 2058 08/31/2015 August A/P August water bills 683.21 229.79 913.00 TROPHY CLUB MUD (WATER BILLS) 35343 AP 2091 08/31/2015 Town August Billing Inv1340-47 AR 20150801-20150831 User: (114.89) 798.11 AR _______________ Account: 135-60025-030-000 Water Totals: 114.90 798.11 ** 1,500.00 Budgeted 701.89 Remaining 53 % Used Account: 135-60035-030-000 Postage 1941 08/14/2015 August A/P Overnight Letter 25,014.04 4.99 25,019.03 FEDERAL EXPRESS CORP 35246 AP 1941 08/14/2015 August A/P Utility Billing July 1,786.16 26,805.19 DATAPROSE LLC 35244 AP 1986 08/20/2015 August A/P Ground service - meter return 3.52 26,808.71 FEDERAL EXPRESS CORP 35263 AP 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 FP MAILING SOLUTIONS 515.50 27,324.21 FP MAILING SOLUTIONS PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 FP MAILING SOLUTIONS 206.50 27,530.71 FP MAILING SOLUTIONS PC 2017 08/31/2015 Postage meter used/August 51.05 27,581.76 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60035-030-000 Postage Totals: 2,567.72 27,581.76 ** 28,500.00 Budgeted 918.24 Remaining 97 % Used Account: 135-60040-030-000 Service Charges & Fees 2070 08/04/2015 Credit Card Fees/UB 35,904.95 95.14 36,000.09 GL 2070 08/04/2015 Credit Card Fees/UB 4,120.95 40,121.04 GL 2069 08/25/2015 Bank Analysis Fee- July 250.00 40,371.04 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,466.09 40,371.04 ** 32,000.00 Budgeted (8,371.04) Remaining 126 % Used Account: 135-60050-030-000 Bad Debt Expense 1,711.95 .00 1,711.95 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 1,711.95 ** 6,200.00 Budgeted 4,488.05 Remaining 28 % Used Account: 135-60055-030-000 Insurance 201 08/01/2015 Aug TML Ins & Workers Comp 40,984.35 4,063.01 45,047.36 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,063.01 45,047.36 ** 48,751.00 Budgeted 3,703.64 Remaining 92 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1,223.77 .00 1,223.77 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 1,223.77 ** 1,600.00 Budgeted 376.23 Remaining 76 % Used Account: 135-60070-030-000 Dues & Memberships 4,557.95 .00 4,557.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,557.95 ** 6,000.00 Budgeted 1,442.05 Remaining 76 % Used Account: 135-60075-030-000 Meetings . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 60.11 .00 60.11 _______________ Account: 135-60075-030-000 Meetings Totals: .00 60.11 ** 400.00 Budgeted 339.89 Remaining 15 % Used Account: 135-60079-030-000 Public Education 3,384.79 .00 3,384.79 _______________ Account: 135-60079-030-000 Public Education Totals: .00 3,384.79 ** 4,078.00 Budgeted 693.21 Remaining 83 % Used Account: 135-60080-030-000 Schools & Training 2,938.00 .00 2,938.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,938.00 ** 10,235.00 Budgeted 7,297.00 Remaining 29 % Used Account: 135-60100-030-000 Travel & per diem 1937 08/14/2015 Payroll 08-14-15 Travel & per diem 1,635.55 35.08 1,670.63 PR 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 ORANGEWOOD SUITES 229.32 1,899.95 ORANGEWOOD SUITES PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 HENRIS 43.89 1,943.84 HENRIS PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 DOS SALSAS CAFE 21.39 1,965.23 DOS SALSAS CAFE PC 1999 08/28/2015 PR 08-28-15 Travel & per diem 4.20 1,969.43 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 333.88 1,969.43 ** 5,400.00 Budgeted 3,430.57 Remaining 36 % 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 1941 08/14/2015 August A/P May 2014 Election 1,289.22 1,289.22 TARRANT COUNTY ELECTIONS ADMIN 35256 AP _______________ Account: 135-60115-030-000 Elections Totals: 1,289.22 1,289.22 ** .00 Budgeted (1,289.22) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-60125-030-000 Advertising 1941 08/14/2015 August A/P Notice of Public Hearing - Rat 5,630.53 124.77 5,755.30 STAR-TELEGRAM OPERATING LTD 35255 AP 2012 08/27/2015 Maguire Invoice Star Telegram AR 20150827-20150827 User: (715.84) 5,039.46 AR 2007 08/28/2015 August A/P Advertising Solana Waterline R 715.84 5,755.30 STAR-TELEGRAM OPERATING LTD 35296 AP _______________ Account: 135-60125-030-000 Advertising Totals: 124.77 5,755.30 ** 2,500.00 Budgeted (3,255.30) Remaining 230 % Used Account: 135-60235-030-000 Security 59.85 .00 59.85 _______________ Account: 135-60235-030-000 Security Totals: .00 59.85 ** 1,350.00 Budgeted 1,290.15 Remaining 4 % Used Account: 135-60245-030-000 Miscellaneous Expenses 2058 08/31/2015 August A/P Professional fees 9,746.45 985.25 10,731.70 NEW GEN STRATEGIES & SOLUTIONS 35333 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 985.25 10,731.70 ** 17,500.00 Budgeted 6,768.30 Remaining 61 % Used Account: 135-60270-030-000 4th of July Celebration 10,000.00 .00 10,000.00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 14,000.00 .00 14,000.00 _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: .00 14,000.00 ** 14,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 5,035.96 .00 5,035.96 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 5,035.96 ** 10,475.00 Budgeted 5,439.04 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-65010-030-000 Uniforms 1,043.00 .00 1,043.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 1,043.00 ** 1,855.00 Budgeted 812.00 Remaining 56 % Used Account: 135-65055-030-000 Hardware 1941 08/14/2015 August A/P Battery for meter reading lapt 34,203.27 59.79 34,263.06 M3 Networks 35251 AP 1986 08/20/2015 August A/P 5 port gigabit switch for post 49.23 34,312.29 M3 Networks 35270 AP _______________ Account: 135-65055-030-000 Hardware Totals: 109.02 34,312.29 ** 35,226.00 Budgeted 913.71 Remaining 97 % Used Account: 135-65085-030-000 Office Supplies 1941 08/14/2015 August A/P Office supplies 6,532.43 3.95 6,536.38 OFFICE DEPOT, INC 35253 AP 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 SIGMA SIGNS & PRINTING 653.80 7,190.18 SIGMA SIGNS & PRINTING PC 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 AMAZON MKTPLACE PMTS 126.27 7,316.45 AMAZON MKTPLACE PMTS PC 2007 08/28/2015 August A/P Office Supplies 93.11 7,409.56 OFFICE DEPOT, INC 35294 AP 2058 08/31/2015 August A/P Ink & labels for postage meter 132.90 7,542.46 ASI BUSINESS SOLUTIONS LTD 35303 AP 2066 08/31/2015 August A/P Office Supplies 7.04 7,549.50 OFFICE DEPOT, INC 35335 AP 2066 08/31/2015 August A/P Office supplies 49.43 7,598.93 OFFICE DEPOT, INC 35335 AP 2066 08/31/2015 August A/P Office supplies 44.69 7,643.62 OFFICE DEPOT, INC 35335 AP 2066 08/31/2015 August A/P Office supplies 62.64 7,706.26 OFFICE DEPOT, INC 35335 AP 2066 08/31/2015 August A/P Office supplies 10.80 7,717.06 OFFICE DEPOT, INC 35335 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 1,184.63 7,717.06 ** 9,000.00 Budgeted 1,282.94 Remaining 86 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2,760.80 .00 2,760.80 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 2,760.80 ** 4,732.00 Budgeted 1,971.20 Remaining 58 % Used Account: 135-65095-030-000 Maintenance Supplies 2057 08/26/2015 P Cards 7/28/15 to 8/26/15 SAMSCLUB #4795 3,705.11 111.27 3,816.38 SAMSCLUB #4795 PC 2066 08/31/2015 August A/P Supplies - Gatorade 118.68 3,935.06 COSTCO WHOLESALE 35307 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 229.95 3,935.06 ** 5,000.00 Budgeted 1,064.94 Remaining 79 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/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-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65105-030-000 Printing 1,332.56 .00 1,332.56 _______________ Account: 135-65105-030-000 Printing Totals: .00 1,332.56 ** 4,800.00 Budgeted 3,467.44 Remaining 28 % Used Account: 135-69005-030-000 Capital Outlays 61,821.66 .00 61,821.66 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 61,821.66 ** 62,000.00 Budgeted 178.34 Remaining 100 % Used Account: 135-69170-030-000 Copier Lease Installments 2066 08/31/2015 August A/P Motorola, BB Connect, Nevill, 3,027.41 53.41 3,080.82 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Charter, Gexa, Nevill, Beck EM 278.33 3,359.15 TOWN OF TROPHY CLUB 35342 AP 2066 08/31/2015 August A/P Charter, Gexa, Nevill, Beck EM 48.27 3,407.42 TOWN OF TROPHY CLUB 35342 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 380.01 3,407.42 ** 4,236.00 Budgeted 828.58 Remaining 80 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 .00 16,329.00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 16,329.00 ** 16,329.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 1,092,886.24 ** 1,277,987.00 Budgeted 185,100.76 Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 1986 08/20/2015 August A/P Legal July 445,514.67 336.00 445,850.67 WHITAKER CHALK SWINDLE 35278 AP 1986 08/20/2015 August A/P Legal July 456.50 446,307.17 WHITAKER CHALK SWINDLE 35278 AP 1986 08/20/2015 August A/P July Legal 6,637.75 452,944.92 THE LISTON LAW FIRM, P.C. 35276 AP _______________ Account: 135-55045-039-000 Legal Totals: 7,430.25 452,944.92 ** 467,403.00 Budgeted 14,458.08 Remaining 97 % Used Account: 135-55055-039-000 Auditing 16,836.00 .00 16,836.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 16,836.00 ** 22,491.00 Budgeted 5,655.00 Remaining 75 % Used Account: 135-55060-039-000 Appraisal 7,964.16 .00 7,964.16 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 7,964.16 ** 10,000.00 Budgeted 2,035.84 Remaining 80 % Used Account: 135-55065-039-000 Tax Admin Fees 2,456.40 .00 2,456.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,456.40 ** 3,800.00 Budgeted 1,343.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 480,201.48 ** 503,694.00 Budgeted 23,492.52 Remaining 95 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (1,407,848.85) .00 Budgeted 1,407,848.85 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 8/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 (91,329.00) .00 (91,329.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (91,329.00) ** .00 Budgeted 91,329.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (17,950.00) .00 (17,950.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (17,950.00) ** .00 Budgeted 17,950.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (109,279.00) ** .00 Budgeted 109,279.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 8/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-69195-030-000 GASB Replacement 74,706.00 .00 74,706.00 _______________ Account: 137-69195-030-000 GASB Replacement Totals: .00 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 8/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-69195-045-000 GASB Replacement 125,670.00 .00 125,670.00 _______________ Account: 137-69195-045-000 GASB Replacement Totals: .00 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ 91,097.00 .00 Budgeted (91,097.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 8/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 2088 08/31/2015 Bank Interest/August (10.67) (1.28) (11.95) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (1.28) (11.95) ** .00 Budgeted 11.95 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (11.95) ** .00 Budgeted 11.95 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 8/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-69280-010-003 Capital Rep/Ind Crk Waterline 2,250.00 .00 2,250.00 _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: .00 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 2,238.05 3,348.00 Budgeted 1,109.95 Remaining 67 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET AUGUST 2015 517 ASSETS TAX BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 4,378,257 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,378,257 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 4,378,257 TOTAL FUND BALANCE 4,378,257 TOTAL LIABILITIES AND FUND BALANCE 4,378,257 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 15:46 09/09/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 266.22- 1,673.10- 1,673.10 517-49105-000-000 Bond Proceeds 5,765,000.00- 5,765,000.00 Subtotal: 266.22- 5,766,673.10- 5,766,673.10 Program number: 266.22- 5,766,673.10- 5,766,673.10 Department number: Revenues 266.22- 5,766,673.10- 5,766,673.10 Revenues Subtotal ----------- 266.22- 5,766,673.10- 5,766,673.10 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 15:46 09/09/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60135-020-000 TCEQ Permits & Fees 14,376.56 14,376.56- 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 1,074,337.15- Subtotal: 1,088,713.71 1,088,713.71- 517-69005-020-000 Capital Outlays 151,502.50 151,502.50- Subtotal: 151,502.50 151,502.50- 517-70020-020-000 Bond Issuance 148,200.00 148,200.00- Subtotal: 148,200.00 148,200.00- Program number: 1,388,416.21 1,388,416.21- Department number: Wastewater 1,388,416.21 1,388,416.21- Expenditures Subtotal ----------- 1,388,416.21 1,388,416.21- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 266.22- 4,378,256.89- 4,378,256.89 . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 8/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 2088 08/31/2015 Bank Interest/August (1,406.88) (266.22) (1,673.10) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (266.22) (1,673.10) ** .00 Budgeted 1,673.10 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds (5,765,000.00) .00 (5,765,000.00) _______________ Account: 517-49105-000-000 Bond Proceeds Totals: .00 (5,765,000.00) ** .00 Budgeted 5,765,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,766,673.10) ** .00 Budgeted 5,766,673.10 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 8/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-60135-020-000 TCEQ Permits & Fees 14,376.56 .00 14,376.56 _______________ Account: 517-60135-020-000 TCEQ Permits & Fees Totals: .00 14,376.56 ** .00 Budgeted (14,376.56) Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 .00 1,074,337.15 _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 1,074,337.15 ** .00 Budgeted (1,074,337.15) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 151,502.50 .00 151,502.50 _______________ Account: 517-69005-020-000 Capital Outlays Totals: .00 151,502.50 ** .00 Budgeted (151,502.50) Remaining 0 % Used Account: 517-70020-020-000 Bond Issuance 148,200.00 .00 148,200.00 _______________ Account: 517-70020-020-000 Bond Issuance Totals: .00 148,200.00 ** .00 Budgeted (148,200.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,388,416.21 ** .00 Budgeted (1,388,416.21) Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (4,378,256.89) .00 Budgeted 4,378,256.89 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET AUGUST 2015 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 8,958,304 ACCOUNTS RECEIVABLE 570 TOTAL ASSETS 8,958,874 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 30,173 TOTAL LIABILITIES 30,173 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 8,928,701 TOTAL FUND BALANCE 8,928,701 TOTAL LIABILITIES AND FUND BALANCE 8,958,874 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 15:46 09/09/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 544.69- 2,760.02- 2,760.02 518-49105-000-000 Bond Proceeds 9,230,000.00- 9,230,000.00 Subtotal: 544.69- 9,232,760.02- 9,232,760.02 Program number: 544.69- 9,232,760.02- 9,232,760.02 Department number: Revenues 544.69- 9,232,760.02- 9,232,760.02 Revenues Subtotal ----------- 544.69- 9,232,760.02- 9,232,760.02 . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 15:46 09/09/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-60125-020-000 Advertising 660.99 660.99- 518-60135-020-000 TCEQ Fees & Permits 23,017.46 23,017.46- Subtotal: 23,678.45 23,678.45- 518-69005-020-000 Capital Outlays 30,172.69 90,111.19 90,111.19- Subtotal: 30,172.69 90,111.19 90,111.19- 518-70020-020-000 Bond Issuance Costs 190,269.00 190,269.00- Subtotal: 190,269.00 190,269.00- Program number: 30,172.69 304,058.64 304,058.64- Department number: Wastewater 30,172.69 304,058.64 304,058.64- Expenditures Subtotal ----------- 30,172.69 304,058.64 304,058.64- Fund number: 518 2015 Revenue Bond Const Fund 29,628.00 8,928,701.38- 8,928,701.38 . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 8/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 2088 08/31/2015 Bank Interest/August (2,215.33) (544.69) (2,760.02) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (544.69) (2,760.02) ** .00 Budgeted 2,760.02 Remaining 0 % Used Account: 518-49105-000-000 Bond Proceeds (9,230,000.00) .00 (9,230,000.00) _______________ Account: 518-49105-000-000 Bond Proceeds Totals: .00 (9,230,000.00) ** .00 Budgeted 9,230,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (9,232,760.02) ** .00 Budgeted 9,232,760.02 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 8/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-60125-020-000 Advertising 660.99 .00 660.99 _______________ Account: 518-60125-020-000 Advertising Totals: .00 660.99 ** .00 Budgeted (660.99) Remaining 0 % Used Account: 518-60135-020-000 TCEQ Fees & Permits 23,017.46 .00 23,017.46 _______________ Account: 518-60135-020-000 TCEQ Fees & Permits Totals: .00 23,017.46 ** .00 Budgeted (23,017.46) Remaining 0 % Used Account: 518-69005-020-000 Capital Outlays 1986 08/20/2015 August A/P Engineering WWTP 59,938.50 24,472.69 84,411.19 THE WALLACE GROUP, INC. 35277 AP 1986 08/20/2015 August A/P Engineering access road WWTP 5,700.00 90,111.19 THE WALLACE GROUP, INC. 35277 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 30,172.69 90,111.19 ** .00 Budgeted (90,111.19) Remaining 0 % Used Account: 518-70020-020-000 Bond Issuance Costs 190,269.00 .00 190,269.00 _______________ Account: 518-70020-020-000 Bond Issuance Costs Totals: .00 190,269.00 ** .00 Budgeted (190,269.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 304,058.64 ** .00 Budgeted (304,058.64) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ (8,928,701.38) .00 Budgeted 8,928,701.38 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET AUGUST 2015 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 61,679 ACCOUNTS RECEIVABLE - TOTAL ASSETS 61,679 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 61,679 TOTAL FUND BALANCE 61,679 TOTAL LIABILITIES AND FUND BALANCE 61,679 . glbase_tbam rgonzale Trophy Club MUD #1 Page 23 15:46 09/09/15 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 3.67- 10.98- 10.98 528-49141-000-000 Interfund Transfer In-Gen Fund 71,946.00- 10,278.00- 61,668.00- 85.714 10,278.00- Subtotal: 71,946.00- 10,281.67- 61,678.98- 85.730 10,267.02- Program number: 71,946.00- 10,281.67- 61,678.98- 85.730 10,267.02- Department number: 71,946.00- 10,281.67- 61,678.98- 85.730 10,267.02- Revenues Subtotal ----------- 71,946.00- 10,281.67- 61,678.98- 85.730 10,267.02- Fund number: 528 2015 Revenue Bond Reserve Fund 71,946.00- 10,281.67- 61,678.98- 85.730 10,267.02- . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 8/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 2088 08/31/2015 Bank Interest/August (7.31) (3.67) (10.98) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (3.67) (10.98) ** .00 Budgeted 10.98 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 1958 08/03/2015 Rev Bond Reserve transfer (51,390.00) (10,278.00) (61,668.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (10,278.00) (61,668.00) ** (71,946.00) Budgeted (10,278.00) Remaining 86 % Used Department Totals: ------------------------------------------------------------------------------------------------ (61,678.98) ** (71,946.00) Budgeted (10,267.02) Remaining 86 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (61,678.98) (71,946.00) Budgeted (10,267.02) Remaining 86 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET AUGUST 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 18,278 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 8,736 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 31,860 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 8,736 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 8,736 FUND BALANCE ASSIGNED FUND BALANCE 14,752 NET REVENUES / EXPENDITURES 8,372 TOTAL FUND BALANCE 23,124 TOTAL LIABILITIES AND FUND BALANCE 31,860 . glbase_tbam rgonzale Trophy Club MUD #1 Page 24 15:46 09/09/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 466,019.00- 466,019.00- 401.69- 465,104.59- 99.804 914.41- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 6.92- 1,817.82- 72.713 682.18- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 56.12- 1,745.51- 109.094 145.51 Subtotal: 470,119.00- 470,119.00- 464.73- 468,667.92- 99.691 1,451.08- 533-48005-000-000 Reserve Funds/PID Utility Fees 100,000.00- 14,000.00- 14,000.00- 100.000 533-48015-000-000 WW Sales Rev Trnsf for Debt 357,538.00- Subtotal: 457,538.00- 14,000.00- 14,000.00- 100.000 533-49010-000-000 Interest Income 375.00- 375.00- 30.86- 3,505.33- 934.755 3,130.33 533-49015-000-000 Lease/Rental Income 211,829.00- 211,829.00- 211,829.00- 100.000 533-49110-000-000 Premium on Bonds Sold 4,957.90- 4,957.90 533-49141-000-000 Interfund Trans In-PID Surchg 65,255.00- 30,645.00- 46.962 34,610.00- Subtotal: 212,204.00- 277,459.00- 30.86- 250,937.23- 90.441 26,521.77- Program number: 1,139,861.00- 761,578.00- 495.59- 733,605.15- 96.327 27,972.85- Department number: Revenues 1,139,861.00- 761,578.00- 495.59- 733,605.15- 96.327 27,972.85- Revenues Subtotal ----------- 1,139,861.00- 761,578.00- 495.59- 733,605.15- 96.327 27,972.85- . glbase_tbam rgonzale Trophy Club MUD #1 Page 25 15:46 09/09/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/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 1,250.00 49.020 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 403,103.00 283,984.00 194,729.31 283,983.06 100.000 .94 533-70035-051-000 Bond Principal Payment-Tax 440,000.00 440,000.00 440,000.00 440,000.00 100.000 533-70040-051-000 Bond Interest Expense-Revenue 292,283.00 Subtotal: 1,137,936.00 726,534.00 634,729.31 725,233.06 99.821 1,300.94 Program number: 1,137,936.00 726,534.00 634,729.31 725,233.06 99.821 1,300.94 Department number: Administration 1,137,936.00 726,534.00 634,729.31 725,233.06 99.821 1,300.94 Expenditures Subtotal ----------- 1,137,936.00 726,534.00 634,729.31 725,233.06 99.821 1,300.94 Fund number: 533 MUD 1 I&S Consolidated 1,925.00- 35,044.00- 634,233.72 8,372.09- 23.890 26,671.91- . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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 2073 08/03/2015 Property Taxes/Assessments (464,702.90) (182.31) (464,885.21) GL 2074 08/04/2015 Property Taxes/Assessments (108.28) (464,993.49) GL 2075 08/06/2015 Property Taxes/Assessments (270.83) (465,264.32) GL 2076 08/10/2015 Property Taxes/Assessments (19.89) (465,284.21) GL 2077 08/12/2015 Property Taxes/Assessments (15.85) (465,300.06) GL 2078 08/17/2015 Property Taxes/Assessments (.15) (465,300.21) GL 2079 08/19/2015 Property Taxes/Assessments 20.62 (465,279.59) GL 2080 08/20/2015 Property Taxes/Assessments (30.43) (465,310.02) GL 2081 08/24/2015 Property Taxes/Assessments 218.36 (465,091.66) GL 2082 08/27/2015 Property Taxes/Assessments (7.11) (465,098.77) GL 2083 08/31/2015 Property Taxes/Assessments (5.82) (465,104.59) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (401.69) (465,104.59) ** (466,019.00) Budgeted (914.41) Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2074 08/04/2015 Property Taxes/Assessments (1,810.90) (4.97) (1,815.87) GL 2076 08/10/2015 Property Taxes/Assessments (.01) (1,815.88) GL 2083 08/31/2015 Property Taxes/Assessments (1.94) (1,817.82) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (6.92) (1,817.82) ** (2,500.00) Budgeted (682.18) Remaining 73 % Used Account: 533-40015-000-000 Property Taxes/P & I 2073 08/03/2015 Property Taxes/Assessments (1,689.39) (.01) (1,689.40) GL 2074 08/04/2015 Property Taxes/Assessments (2.62) (1,692.02) GL 2075 08/06/2015 Property Taxes/Assessments (48.20) (1,740.22) GL 2077 08/12/2015 Property Taxes/Assessments (1.11) (1,741.33) GL 2078 08/17/2015 Property Taxes/Assessments (.03) (1,741.36) GL 2080 08/20/2015 Property Taxes/Assessments (2.12) (1,743.48) GL 2082 08/27/2015 Property Taxes/Assessments (1.23) (1,744.71) GL 2083 08/31/2015 Property Taxes/Assessments (.80) (1,745.51) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (56.12) (1,745.51) ** (1,600.00) Budgeted 145.51 Remaining 109 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees (14,000.00) .00 (14,000.00) . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/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-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 (14,000.00) ** (14,000.00) Budgeted .00 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 2088 08/31/2015 Bank Interest/August (3,474.47) (30.86) (3,505.33) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (30.86) (3,505.33) ** (375.00) Budgeted 3,130.33 Remaining 935 % Used Account: 533-49015-000-000 Lease/Rental Income (211,829.00) .00 (211,829.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (211,829.00) ** (211,829.00) Budgeted .00 Remaining 100 % Used Account: 533-49110-000-000 Premium on Bonds Sold (4,957.90) .00 (4,957.90) _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: .00 (4,957.90) ** .00 Budgeted 4,957.90 Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg (30,645.00) .00 (30,645.00) _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 (30,645.00) ** (65,255.00) Budgeted (34,610.00) Remaining 47 % Used Department Totals: ------------------------------------------------------------------------------------------------ (733,605.15) ** (761,578.00) Budgeted (27,972.85) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/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 1,250.00 .00 1,250.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,250.00 ** 2,550.00 Budgeted 1,300.00 Remaining 49 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 2085 08/25/2015 9/1/15 Bond Payments TCMUD1 UNL Tax Series 2014 89,253.75 105,475.56 194,729.31 GL 2085 08/25/2015 9/1/15 Bond Payments TCMUD1 UNL Tax Series 2010 36,866.25 231,595.56 GL 2085 08/25/2015 9/1/15 Bond Payments TCMUD UNL Ref Series 2012 26,625.00 258,220.56 GL 2085 08/25/2015 9/1/15 Bond Payments TCMUD1 UNL Ref Series 2013 25,762.50 283,983.06 GL _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: 194,729.31 283,983.06 ** 283,984.00 Budgeted .94 Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 2085 08/25/2015 9/1/15 Bond Payments TCMUD1 UNL Tax Series 2010 70,000.00 70,000.00 GL 2085 08/25/2015 9/1/15 Bond Payments TCMUD UNL Ref Series 2012 195,000.00 265,000.00 GL 2085 08/25/2015 9/1/15 Bond Payments TCMUD1 UNL Ref Series 2013 175,000.00 440,000.00 GL _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: 440,000.00 440,000.00 ** 440,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 725,233.06 ** 726,534.00 Budgeted 1,300.94 Remaining 100 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (8,372.09) (35,044.00) Budgeted (26,671.91) Remaining 24 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET AUGUST 2015 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,067 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,067 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 15,067 TOTAL FUND BALANCE 15,067 TOTAL LIABILITIES AND FUND BALANCE 15,067 . glbase_tbam rgonzale Trophy Club MUD #1 Page 26 15:46 09/09/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 8/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 7.33- 10,451.92- 10,451.92 534-49110-000-000 Bond Premium 4,615.00- 4,615.00 534-49143-000-000 Interfund Transfer In-WW Sales 136,989.00- 136,989.00- 100.000 Subtotal: 136,989.00- 7.33- 152,055.92- 110.999 15,066.92 Program number: 136,989.00- 7.33- 152,055.92- 110.999 15,066.92 Department number: Revenues 136,989.00- 7.33- 152,055.92- 110.999 15,066.92 Revenues Subtotal ----------- 136,989.00- 7.33- 152,055.92- 110.999 15,066.92 . glbase_tbam rgonzale Trophy Club MUD #1 Page 27 15:46 09/09/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/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 136,989.00 136,988.54 136,988.54 100.000 .46 Subtotal: 136,989.00 136,988.54 136,988.54 100.000 .46 Program number: 136,989.00 136,988.54 136,988.54 100.000 .46 Department number: Administration 136,989.00 136,988.54 136,988.54 100.000 .46 Expenditures Subtotal ----------- 136,989.00 136,988.54 136,988.54 100.000 .46 Fund number: 534 2015 Revenue Bond I&S 136,981.21 15,067.38- 15,067.38 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 8/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 2088 08/31/2015 Bank Interest/August (10,444.59) (7.33) (10,451.92) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (7.33) (10,451.92) ** .00 Budgeted 10,451.92 Remaining 0 % Used Account: 534-49110-000-000 Bond Premium (4,615.00) .00 (4,615.00) _______________ Account: 534-49110-000-000 Bond Premium Totals: .00 (4,615.00) ** .00 Budgeted 4,615.00 Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales (136,989.00) .00 (136,989.00) _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 (136,989.00) ** (136,989.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (152,055.92) ** (136,989.00) Budgeted 15,066.92 Remaining 111 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 15:46 09/09/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 8/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 2085 08/25/2015 9/1/15 Bond Payments Rev Bond Series 2015 136,988.54 136,988.54 GL _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 136,988.54 136,988.54 ** 136,989.00 Budgeted .46 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 136,988.54 ** 136,989.00 Budgeted .46 Remaining 100 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (15,067.38) .00 Budgeted 15,067.38 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (14,834,823.74) **** (103,642.00) Budgeted 14,731,181.74 Remaining ########## ******* End of Report *********