Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2015-07 Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JULY 2015 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 739,567 PREPAID EXPENSES 3,198 ADVALOREM PROPERTY TAXES RECEIVABLE 20,703 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 613 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,248 TOTAL ASSETS 765,328 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 20,703 ACCOUNTS AND OTHER PAYABLES 1,184 TOTAL LIABILITIES 22,499 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 213,918 TOTAL FUND BALANCE 742,828 TOTAL LIABILITIES AND FUND BALANCE 765,328 . glbase_tsam tsisk Trophy Club MUD #1 Page 1 08:50 08/13/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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- 567.26- 356,635.60- 99.769 826.40- 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- 2,277.95- 870,277.14- 99.704 2,581.86- 122-40011-000-000 Property Taxes/Fire-Delinquent 145.62- 4,024.35- 4,024.35 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 7.50- 3,302.72- 440.363 2,552.72 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 48.47- 3,633.81- 80.751 866.19- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 5,200.00- 86.667 800.00- 122-43400-000-000 Fire Inspections 700.00- 950.00- 975.00- 102.632 25.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 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- 10,403.99- 115.600 1,403.99 Subtotal: 1,383,940.00- 2,239,867.00- 3,046.80- 2,205,840.71- 98.481 34,026.29- Program number: 1,383,940.00- 2,239,867.00- 3,046.80- 2,205,840.71- 98.481 34,026.29- Department number: Fire Revenues 1,383,940.00- 2,239,867.00- 3,046.80- 2,205,840.71- 98.481 34,026.29- Revenues Subtotal ----------- 1,383,940.00- 2,239,867.00- 3,046.80- 2,205,840.71- 98.481 34,026.29- . glbase_tsam tsisk Trophy Club MUD #1 Page 2 08:50 08/13/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 58,030.14 385,882.96 82.266 83,184.04 122-50010-045-000 Overtime 46,745.00 46,745.00 7,615.63 35,220.11 75.345 11,524.89 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 387.50 4,119.00 85.813 681.00 122-50020-045-000 Retirement 91,396.00 75,327.00 8,709.94 60,563.70 80.401 14,763.30 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,881.48 45,650.25 77.152 13,518.75 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 365.30 3,504.99 79.840 885.01 122-50028-045-000 Vision Insurance 811.00 811.00 63.63 610.05 75.222 200.95 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 309.61 3,071.90 76.226 958.10 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 3,876.22 25,467.44 76.202 7,953.56 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 906.28 5,954.67 81.660 1,337.33 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 12.61 280.73- -16.942 1,937.73 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 658.99 6,589.94 75.816 2,102.06 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 147.50 59.000 102.50 122-50075-045-000 Tuition Reimbursement 300.00 300.00 300.00 122-55030-045-000 Software & Support 7,378.00 7,378.00 2,818.16 38.197 4,559.84 122-55045-045-000 Legal 1,500.00 1,500.00 240.00 2,040.00 136.000 540.00- 122-55080-045-000 Maintenance & Repairs 18,552.00 18,552.00 1,972.81 8,537.64 46.020 10,014.36 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 703.47 10,536.37 87.803 1,463.63 Subtotal: 791,885.00 775,816.00 88,733.61 620,278.36 79.952 155,537.64 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 75.00 3,935.73 61.371 2,477.27 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 607.31 4,464.15 49.459 4,561.85 122-60025-045-000 Water 1,200.00 1,200.00 108.31 1,073.48 89.457 126.52 122-60026-045-000 Cable 1,920.00 1,920.00 14.09 1,402.18 73.030 517.82 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 9,400.84 77.189 2,778.16 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 214.00 15,632.85 99.642 56.15 122-60080-045-000 Schools & Training 4,280.00 4,280.00 1,411.80 3,925.09 91.708 354.91 122-60096-045-000 Emergency Management 1,400.00 1,400.00 220.00 15.714 1,180.00 122-60100-045-000 Travel & per diem 13,577.00 13,577.00 937.40 6,131.36 45.160 7,445.64 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 124.15 2.434 4,975.85 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 1,131.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 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 110.40- -5.520 2,110.40 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 573.99 57.399 426.01 122-65005-045-000 Fuel & Lube 10,454.00 10,454.00 528.34 4,712.40 45.077 5,741.60 122-65010-045-000 Uniforms 2,000.00 3,000.00 358.89 2,408.30 80.277 591.70 . glbase_tsam tsisk Trophy Club MUD #1 Page 3 08:50 08/13/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-65015-045-000 Protective Clothing 5,200.00 35,200.00 1,400.46 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 204.56 1,053.73 42.149 1,446.27 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 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,500.00 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 17,950.00 17,950.00 100.000 122-69255-045-000 Airpacks 20,400.00 10,400.00 10,235.38 98.417 164.62 Subtotal: 592,055.00 1,464,051.00 7,931.24 1,371,644.71 93.688 92,406.29 Program number: 1,383,940.00 2,239,867.00 96,664.85 1,991,923.07 88.930 247,943.93 Department number: Fire 1,383,940.00 2,239,867.00 96,664.85 1,991,923.07 88.930 247,943.93 Expenditures Subtotal ----------- 1,383,940.00 2,239,867.00 96,664.85 1,991,923.07 88.930 247,943.93 Fund number: 122 Trophy Club MUD Fire Dept. 93,618.05 213,917.64- 213,917.64 . glpdatb2 tsisk Trophy Club MUD #1 Page 1 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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 1892 07/06/2015 Property Taxes/Assessments (356,068.34) (36.07) (356,104.41) GL 1894 07/13/2015 Property Taxes/Assessments (141.20) (356,245.61) GL 1897 07/16/2015 Property Taxes/Assessments (80.60) (356,326.21) GL 1899 07/20/2015 Property Taxes/Assessments (132.48) (356,458.69) GL 1903 07/24/2015 Property Taxes/Assessments (97.28) (356,555.97) GL 1904 07/27/2015 Property Taxes/Assessments (79.63) (356,635.60) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (567.26) (356,635.60) ** (357,462.00) Budgeted (826.40) 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 1886 07/01/2015 Property Taxes/Assessments (867,999.19) (7.91) (868,007.10) GL 1892 07/06/2015 Property Taxes/Assessments 21.43 (867,985.67) GL 1893 07/10/2015 Property Taxes/Assessments (78.54) (868,064.21) GL 1894 07/13/2015 Property Taxes/Assessments (201.66) (868,265.87) GL 1895 07/14/2015 Property Taxes/Assessments (154.13) (868,420.00) GL 1896 07/15/2015 Property Taxes/Assessments (174.25) (868,594.25) GL 1898 07/16/2015 Property Taxes/Assessments (174.85) (868,769.10) GL 1899 07/20/2015 Property Taxes/Assessments (168.73) (868,937.83) GL 1900 07/21/2015 Property Taxes/Assessments (31.28) (868,969.11) GL 1901 07/22/2015 Property Taxes/Assessments (215.37) (869,184.48) GL 1902 07/23/2015 Property Taxes/Assessments (25.78) (869,210.26) GL 1903 07/24/2015 Property Taxes/Assessments (79.26) (869,289.52) GL 1904 07/27/2015 Property Taxes/Assessments (318.07) (869,607.59) GL 1905 07/29/2015 Property Taxes/Assessments (75.04) (869,682.63) GL 1906 07/30/2015 Property Taxes/Assessments (273.00) (869,955.63) GL 1907 07/31/2015 Property Taxes/Assessments (321.51) (870,277.14) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (2,277.95) (870,277.14) ** (872,859.00) Budgeted (2,581.86) Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1907 07/31/2015 Property Taxes/Assessments (3,878.73) (145.62) (4,024.35) GL . glpdatb2 tsisk Trophy Club MUD #1 Page 2 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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-40011-000-000 Property Taxes/Fire-Delinquent Totals: (145.62) (4,024.35) ** .00 Budgeted 4,024.35 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1892 07/06/2015 Property Taxes/Assessments (3,295.22) (6.28) (3,301.50) GL 1903 07/24/2015 Property Taxes/Assessments (1.22) (3,302.72) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (7.50) (3,302.72) ** (750.00) Budgeted 2,552.72 Remaining 440 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1886 07/01/2015 Property Taxes/Assessments (3,585.34) (1.11) (3,586.45) GL 1892 07/06/2015 Property Taxes/Assessments (2.75) (3,589.20) GL 1895 07/14/2015 Property Taxes/Assessments (4.61) (3,593.81) GL 1901 07/22/2015 Property Taxes/Assessments (.04) (3,593.85) GL 1905 07/29/2015 Property Taxes/Assessments (1.89) (3,595.74) GL 1906 07/30/2015 Property Taxes/Assessments (15.15) (3,610.89) GL 1907 07/31/2015 Property Taxes/Assessments (22.92) (3,633.81) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (48.47) (3,633.81) ** (4,500.00) Budgeted (866.19) Remaining 81 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (5,200.00) .00 (5,200.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (5,200.00) ** (6,000.00) Budgeted (800.00) Remaining 87 % Used Account: 122-43400-000-000 Fire Inspections (975.00) .00 (975.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (975.00) ** (950.00) Budgeted 25.00 Remaining 103 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) . glpdatb2 tsisk Trophy Club MUD #1 Page 3 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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-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) _______________ 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 (10,403.99) .00 (10,403.99) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (10,403.99) ** (9,000.00) Budgeted 1,403.99 Remaining 116 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,205,840.71) ** (2,239,867.00) Budgeted (34,026.29) Remaining 98 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 4 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 1731 07/03/2015 FD Payroll 7/3/15 327,852.82 18,313.17 346,165.99 GL 1732 07/03/2015 FD Supplemental P/R 7/3/15 878.42 347,044.41 GL 1865 07/17/2015 FD Payroll 7/17/15 18,274.35 365,318.76 GL 1866 07/17/2015 FD Payroll 7/17/15 Supplementa 247.00 365,565.76 GL 1867 07/31/2015 FD Payroll 7/31/15 20,317.20 385,882.96 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 58,030.14 385,882.96 ** 469,067.00 Budgeted 83,184.04 Remaining 82 % Used Account: 122-50010-045-000 Overtime 1731 07/03/2015 FD Payroll 7/3/15 27,604.48 3,837.62 31,442.10 GL 1732 07/03/2015 FD Supplemental P/R 7/3/15 93.10 31,535.20 GL 1867 07/31/2015 FD Payroll 7/31/15 3,684.91 35,220.11 GL _______________ Account: 122-50010-045-000 Overtime Totals: 7,615.63 35,220.11 ** 46,745.00 Budgeted 11,524.89 Remaining 75 % 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 1731 07/03/2015 FD Payroll 7/3/15 3,731.50 387.50 4,119.00 GL _______________ Account: 122-50017-045-000 Certification Totals: 387.50 4,119.00 ** 4,800.00 Budgeted 681.00 Remaining 86 % Used Account: 122-50020-045-000 Retirement 1731 07/03/2015 FD Payroll 7/3/15 51,853.76 3,035.52 54,889.28 GL . glpdatb2 tsisk Trophy Club MUD #1 Page 5 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1732 07/03/2015 FD Supplemental P/R 7/3/15 51,853.76 33.26 54,922.54 GL 1865 07/17/2015 FD Payroll 7/17/15 2,447.79 57,370.33 GL 1867 07/31/2015 FD Payroll 7/31/15 3,193.37 60,563.70 GL _______________ Account: 122-50020-045-000 Retirement Totals: 8,709.94 60,563.70 ** 75,327.00 Budgeted 14,763.30 Remaining 80 % Used Account: 122-50026-045-000 Medical Insurance 1731 07/03/2015 FD Payroll 7/3/15 40,768.77 2,782.67 43,551.44 GL 1865 07/17/2015 FD Payroll 7/17/15 2,098.81 45,650.25 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,881.48 45,650.25 ** 59,169.00 Budgeted 13,518.75 Remaining 77 % Used Account: 122-50027-045-000 Dental Insurance 1731 07/03/2015 FD Payroll 7/3/15 3,139.69 182.66 3,322.35 GL 1865 07/17/2015 FD Payroll 7/17/15 182.64 3,504.99 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 365.30 3,504.99 ** 4,390.00 Budgeted 885.01 Remaining 80 % Used Account: 122-50028-045-000 Vision Insurance 1731 07/03/2015 FD Payroll 7/3/15 546.42 31.80 578.22 GL 1865 07/17/2015 FD Payroll 7/17/15 31.83 610.05 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 63.63 610.05 ** 811.00 Budgeted 200.95 Remaining 75 % Used Account: 122-50029-045-000 Life Insurance & Other 1731 07/03/2015 FD Payroll 7/3/15 2,762.29 154.78 2,917.07 GL 1865 07/17/2015 FD Payroll 7/17/15 154.83 3,071.90 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 309.61 3,071.90 ** 4,030.00 Budgeted 958.10 Remaining 76 % Used Account: 122-50030-045-000 Social Security Taxes 1731 07/03/2015 FD Payroll 7/3/15 21,591.22 1,288.12 22,879.34 GL 1732 07/03/2015 FD Supplemental P/R 7/3/15 60.22 22,939.56 GL . glpdatb2 tsisk Trophy Club MUD #1 Page 6 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1865 07/17/2015 FD Payroll 7/17/15 21,591.22 1,024.53 23,964.09 GL 1866 07/17/2015 FD Payroll 7/17/15 Supplementa 15.31 23,979.40 GL 1867 07/31/2015 FD Payroll 7/31/15 1,488.04 25,467.44 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,876.22 25,467.44 ** 33,421.00 Budgeted 7,953.56 Remaining 76 % Used Account: 122-50035-045-000 Medicare Taxes 1731 07/03/2015 FD Payroll 7/3/15 5,048.39 301.20 5,349.59 GL 1732 07/03/2015 FD Supplemental P/R 7/3/15 14.07 5,363.66 GL 1865 07/17/2015 FD Payroll 7/17/15 239.53 5,603.19 GL 1866 07/17/2015 FD Payroll 7/17/15 Supplementa 3.58 5,606.77 GL 1867 07/31/2015 FD Payroll 7/31/15 347.90 5,954.67 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 906.28 5,954.67 ** 7,292.00 Budgeted 1,337.33 Remaining 82 % Used Account: 122-50040-045-000 Unemployment Taxes 1731 07/03/2015 FD Payroll 7/3/15 (293.34) 4.09 (289.25) GL 1865 07/17/2015 FD Payroll 7/17/15 2.75 (286.50) GL 1866 07/17/2015 FD Payroll 7/17/15 Supplementa .74 (285.76) GL 1867 07/31/2015 FD Payroll 7/31/15 5.03 (280.73) GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 12.61 (280.73) ** 1,657.00 Budgeted 1,937.73 Remaining -17 % Used Account: 122-50045-045-000 Workman's Compensation 200 07/01/2015 Jul TML Ins & Workers Comp 5,930.95 658.99 6,589.94 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 658.99 6,589.94 ** 8,692.00 Budgeted 2,102.06 Remaining 76 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 147.50 .00 147.50 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 147.50 ** 250.00 Budgeted 102.50 Remaining 59 % Used Account: 122-50075-045-000 Tuition Reimbursement . glpdatb2 tsisk Trophy Club MUD #1 Page 7 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 2,818.16 .00 2,818.16 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 2,818.16 ** 7,378.00 Budgeted 4,559.84 Remaining 38 % Used Account: 122-55045-045-000 Legal 1872 07/31/2015 July A/P Legal June 1,800.00 240.00 2,040.00 THE LISTON LAW FIRM, P.C. 35214 AP _______________ Account: 122-55045-045-000 Legal Totals: 240.00 2,040.00 ** 1,500.00 Budgeted (540.00) Remaining 136 % Used Account: 122-55080-045-000 Maintenance & Repairs 1815 07/23/2015 July A/P Rug cleaning 6,564.83 32.29 6,597.12 G & K SERVICES 35180 AP 1815 07/23/2015 July A/P Rug cleaning 32.29 6,629.41 G & K SERVICES 35180 AP 1815 07/23/2015 July A/P Rug cleaning 32.29 6,661.70 G & K SERVICES 35180 AP 1815 07/23/2015 July A/P Rug cleaning 32.29 6,693.99 G & K SERVICES 35180 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 KELLER OUTDOOR POWER I 82.30 6,776.29 KELLER OUTDOOR POWER I PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 PARTSELECT.COM XXXXXXX 195.57 6,971.86 PARTSELECT.COM XXXXXXX PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SAMS CLUB #4795 42.98 7,014.84 SAMS CLUB #4795 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SAMSCLUB #4795 127.38 7,142.22 SAMSCLUB #4795 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ROYAL SLEEP PRODUCTS L 1,460.00 8,602.22 ROYAL SLEEP PRODUCTS L PC 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (64.58) 8,537.64 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,972.81 8,537.64 ** 18,552.00 Budgeted 10,014.36 Remaining 46 % Used Account: 122-55090-045-000 Vehicle Maintenance 1790 07/17/2015 July A/P Vehicle Maintenance 9,832.90 266.50 10,099.40 SIDDONS-MARTIN EMERGENCY GROUP 35167 AP 1815 07/23/2015 July A/P Vehicle maintenance 399.94 10,499.34 SIDDONS-MARTIN EMERGENCY GROUP 35188 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ROANOKE AUTO SUPPLY LT 20.07 10,519.41 ROANOKE AUTO SUPPLY LT PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ROANOKE AUTO SUPPLY LT 16.96 10,536.37 ROANOKE AUTO SUPPLY LT PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 703.47 10,536.37 ** 12,000.00 Budgeted 1,463.63 Remaining 88 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 8 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-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 Account: 122-60010-045-000 Communications/Mobiles 1731 07/03/2015 FD Payroll 7/3/15 3,860.73 75.00 3,935.73 GL _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 75.00 3,935.73 ** 6,413.00 Budgeted 2,477.27 Remaining 61 % Used Account: 122-60020-045-000 Electricity/Gas 1815 07/23/2015 July A/P Electricity 06/11/2015 - 07/13 3,856.84 1,143.76 5,000.60 HUDSON ENERGY SERVICES, LLC 35183 AP 1857 07/31/2015 July A/P Gas - Fire Station 6/19 - 7/17 70.86 5,071.46 ATMOS ENERGY 35199 AP 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (607.31) 4,464.15 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 607.31 4,464.15 ** 9,026.00 Budgeted 4,561.85 Remaining 49 % Used Account: 122-60025-045-000 Water 1909 07/31/2015 July A/P July Water Bills 965.17 216.63 1,181.80 TROPHY CLUB MUD (WATER BILLS) 35238 AP 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (108.32) 1,073.48 AR _______________ Account: 122-60025-045-000 Water Totals: 108.31 1,073.48 ** 1,200.00 Budgeted 126.52 Remaining 89 % Used Account: 122-60026-045-000 Cable 1842 07/29/2015 Fire Fighter cable July, Aug 1,388.09 (267.64) 1,120.45 GL 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ATT*BILL PAYMENT 123.00 1,243.45 ATT*BILL PAYMENT PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ATT*BILL PAYMENT 158.73 1,402.18 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 14.09 1,402.18 ** 1,920.00 Budgeted 517.82 Remaining 73 % Used Account: 122-60030-045-000 Rent And/Or Usage 211,829.00 .00 211,829.00 . glpdatb2 tsisk Trophy Club MUD #1 Page 9 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-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 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 200 07/01/2015 Jul TML Ins & Workers Comp 8,460.76 940.08 9,400.84 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.08 9,400.84 ** 12,179.00 Budgeted 2,778.16 Remaining 77 % 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 1871 07/31/2015 PCards 06/27/15 - 07/27/15 INT'L ASSOC OF FIRE CH 15,418.85 214.00 15,632.85 INT'L ASSOC OF FIRE CH PC _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 214.00 15,632.85 ** 15,689.00 Budgeted 56.15 Remaining 100 % Used Account: 122-60080-045-000 Schools & Training 1871 07/31/2015 PCards 06/27/15 - 07/27/15 STATE FIREMEN'S & FIRE 2,513.29 191.80 2,705.09 STATE FIREMEN'S & FIRE PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 TEEX 979 458 6903 1,220.00 3,925.09 TEEX 979 458 6903 PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 1,411.80 3,925.09 ** 4,280.00 Budgeted 354.91 Remaining 92 % Used Account: 122-60096-045-000 Emergency Management 220.00 .00 220.00 . glpdatb2 tsisk Trophy Club MUD #1 Page 10 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-60096-045-000 Emergency Management Totals: .00 220.00 ** 1,400.00 Budgeted 1,180.00 Remaining 16 % Used Account: 122-60100-045-000 Travel & per diem 1871 07/31/2015 PCards 06/27/15 - 07/27/15 HOLIDAY INNS 5,193.96 377.40 5,571.36 HOLIDAY INNS PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 TEEX 979 458 6903 560.00 6,131.36 TEEX 979 458 6903 PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 937.40 6,131.36 ** 13,577.00 Budgeted 7,445.64 Remaining 45 % 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 124.15 .00 124.15 _______________ Account: 122-60125-045-000 Advertising Totals: .00 124.15 ** 5,100.00 Budgeted 4,975.85 Remaining 2 % Used Account: 122-60160-045-000 Programs & Special Projects 1871 07/31/2015 PCards 06/27/15 - 07/27/15 PROMOTIONS NOW 1,325.45 596.00 1,921.45 PROMOTIONS NOW PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 FIRESMARTPROMOS.COM 535.00 2,456.45 FIRESMARTPROMOS.COM PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 1,131.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 . glpdatb2 tsisk Trophy Club MUD #1 Page 11 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (110.40) .00 (110.40) _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 (110.40) ** 2,000.00 Budgeted 2,110.40 Remaining -6 % 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 1824 07/27/2015 July A/P Fuel 4,184.06 528.34 4,712.40 US Bank Voyager Fleet Systems 35198 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 528.34 4,712.40 ** 10,454.00 Budgeted 5,741.60 Remaining 45 % Used Account: 122-65010-045-000 Uniforms 1790 07/17/2015 July A/P Uniforms 2,049.41 94.15 2,143.56 RED THE UNIFORM TAILOR 35166 AP 1857 07/31/2015 July A/P Uniforms 542.31 2,685.87 RED THE UNIFORM TAILOR 35210 AP 1857 07/31/2015 July A/P Uniforms 81.32 2,767.19 RED THE UNIFORM TAILOR 35210 AP 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (358.89) 2,408.30 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 358.89 2,408.30 ** 3,000.00 Budgeted 591.70 Remaining 80 % Used Account: 122-65015-045-000 Protective Clothing 1909 07/31/2015 July A/P Protective clothing 14,776.99 553.46 15,330.45 CASCO INDUSTRIES INC 35219 AP 1909 07/31/2015 July A/P Protective clothing 847.00 16,177.45 CASCO INDUSTRIES INC 35219 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 1,400.46 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 . glpdatb2 tsisk Trophy Club MUD #1 Page 12 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 1871 07/31/2015 PCards 06/27/15 - 07/27/15 WITMER PUBLIC SAFETY G 849.17 204.56 1,053.73 WITMER PUBLIC SAFETY G PC _______________ Account: 122-65035-045-000 Small Tools Totals: 204.56 1,053.73 ** 2,500.00 Budgeted 1,446.27 Remaining 42 % 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 .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 23,500.00 Budgeted 23,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement . glpdatb2 tsisk Trophy Club MUD #1 Page 13 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 17,950.00 .00 17,950.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 17,950.00 ** 17,950.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks 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: ------------------------------------------------------------------------------------------------ 1,991,923.07 ** 2,239,867.00 Budgeted 247,943.93 Remaining 89 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (213,917.64) .00 Budgeted 213,917.64 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JULY 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 6/30/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 254,329 - - 254,329 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,543,240 - - 1,543,240 INVESTMENTS-TEXPOOL 1,154,786 169,600 21,460 1,345,845 PREPAID EXPENSES 17,112 - - 17,112 ADVALOREM PROPERTY TAXES RECEIVABLE 3,147 - - 3,147 UTILITY AND OTHER ACCOUNTS RECEIVABLE 801,374 - - 801,374 - TOTAL ASSETS 3,774,587 169,600 21,460 3,965,648 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,147 - - 3,147 ACCOUNTS AND OTHER PAYABLES 251,504 - 13,431 264,936 CUSTOMER DEPOSITS 308,207 - - 308,207 - TOTAL LIABILITIES 562,858 - 13,431 576,289 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,063,675 (91,097) (2,239) 970,339 - TOTAL FUND BALANCE 3,211,730 169,600 8,029 3,389,358 - TOTAL LIABILITIES AND FUND BALANCE 3,774,587 169,600 21,460 3,965,648 . glbase_tsam tsisk Trophy Club MUD #1 Page 4 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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- 438.08- 167,365.32- 99.707 491.68- 135-40002-000-000 Property Taxes/Delinquent 15.58- 439.64- 439.64 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 7.84- 609.55- 67.728 290.45- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 12,112.90- 116,821.40- 87.182 17,175.60- 135-47000-000-000 Water 5,286,045.00- 4,747,789.00- 428,812.13- 2,515,456.65- 52.982 2,232,332.35- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 222,102.64- 1,629,610.23- 71.758 641,371.77- 135-47025-000-000 Penalties 63,416.00- 80,000.00- 7,823.79- 72,956.03- 91.195 7,043.97- 135-47030-000-000 Service Charges 8,000.00- 10,000.00- 750.00- 8,724.00- 87.240 1,276.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 100.00- 1,800.00- 90.000 200.00- 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 300.00- 5,400.00- 108.000 400.00 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 15,248.10- 33,665.80- 38.779 53,149.20- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 13,800.00- 202,400.00- 110.000 18,400.00 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 516.44- 5,039.11- 100.782 39.11 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 9,105.30- 89.584 1,058.70- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,833.30- 83.333 1,166.70- 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- 2,744.00- 47,519.83- 113.142 5,519.83 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- 340.30- 105,072.46- 152.292 36,078.46 135-49901-000-000 Records Management Revenue 100.00- 100.00- 12.20- 12.200 87.80- Subtotal: 8,444,333.00- 8,846,514.00- 706,605.66- 6,113,640.47- 69.108 2,732,873.53- Program number: 8,444,333.00- 8,846,514.00- 706,605.66- 6,113,640.47- 69.108 2,732,873.53- Department number: Revenues 8,444,333.00- 8,846,514.00- 706,605.66- 6,113,640.47- 69.108 2,732,873.53- Revenues Subtotal ----------- 8,444,333.00- 8,846,514.00- 706,605.66- 6,113,640.47- 69.108 2,732,873.53- . glbase_tsam tsisk Trophy Club MUD #1 Page 5 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 29,274.63 175,932.04 71.933 68,645.96 135-50010-010-000 Overtime 19,500.00 19,500.00 1,500.72 11,823.91 60.635 7,676.09 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,275.00 58.333 1,625.00 135-50020-010-000 Retirement 29,349.00 23,987.00 2,762.13 17,204.15 71.723 6,782.85 135-50026-010-000 Medical Insurance 44,988.00 51,487.00 3,893.82 27,572.80 53.553 23,914.20 135-50027-010-000 Dental Insurance 3,288.00 4,188.00 303.02 2,211.72 52.811 1,976.28 135-50028-010-000 Vision Insurance 834.00 990.00 68.97 514.82 52.002 475.18 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 220.75 1,789.73 58.222 1,284.27 135-50030-010-000 Social Security Taxes 21,135.00 17,192.00 1,904.17 11,786.47 68.558 5,405.53 135-50035-010-000 Medicare Taxes 4,943.00 4,021.00 445.32 2,756.52 68.553 1,264.48 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 3.24 21.01 1.692 1,220.99 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 857.91 7,259.10 45.313 8,760.90 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 135-55005-010-000 Engineering 10,000.00 10,000.00 3,800.00 1,710.00 17.100 8,290.00 135-55080-010-000 Maintenance & Repairs 71,242.00 81,113.00 520.58 55,449.83 68.361 25,663.17 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 1,760.01 7,282.68 91.034 717.32 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,463.47 98.956 36.53 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 432.70 3,722.50 67.682 1,777.50 Subtotal: 555,159.00 502,597.00 47,972.97 336,666.18 66.985 165,930.82 135-60010-010-000 Communications/Mobiles 4,913.00 4,913.00 397.93 3,200.96 65.153 1,712.04 135-60020-010-000 Electricity 170,765.00 160,765.00 13,129.19 97,809.57 60.840 62,955.43 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 1,173.00 28.347 2,965.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 99.09 6.606 1,400.91 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 20,656.61 41.921 28,618.39 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 172,133.28 1,212,058.94 41.391 1,716,249.06 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 181.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 924.51 26.415 2,575.49 135-65005-010-000 Fuel & Lube 29,172.00 19,173.00 1,279.73 10,314.59 53.797 8,858.41 135-65010-010-000 Uniforms 3,620.00 3,620.00 109.50 3,184.80 87.978 435.20 135-65030-010-000 Chemicals 7,000.00 10,000.00 858.15 8,425.94 84.259 1,574.06 135-65035-010-000 Small Tools 1,200.00 1,200.00 347.75 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 19,355.00 112,019.34 67.891 52,980.66 135-69005-010-000 Capital Outlays 1,089,006.00 1,457,597.00 27,995.20 262,146.35 17.985 1,195,450.65 . glbase_tsam tsisk Trophy Club MUD #1 Page 6 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 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 2,415.58 66.877 1,196.42 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: 4,820,866.00 5,175,958.00 235,786.73 2,068,666.64 39.967 3,107,291.36 Program number: 5,376,025.00 5,678,555.00 283,759.70 2,405,332.82 42.358 3,273,222.18 . glbase_tsam tsisk Trophy Club MUD #1 Page 7 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 7/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 183.85 2,697.60 53.952 2,302.40 Subtotal: 5,000.00 5,000.00 183.85 2,697.60 53.952 2,302.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 183.85 5,116.35 51.164 4,883.65 Department number: Water 5,386,025.00 5,688,555.00 283,943.55 2,410,449.17 42.374 3,278,105.83 . glbase_tsam tsisk Trophy Club MUD #1 Page 8 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 35,718.51 248,388.68 80.678 59,486.32 135-50010-020-000 Overtime 19,500.00 24,500.00 2,199.55 23,496.05 95.902 1,003.95 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 5,500.00 83.333 1,100.00 135-50020-020-000 Retirement 29,948.00 30,317.00 3,427.49 25,267.27 83.344 5,049.73 135-50026-020-000 Medical Insurance 61,001.00 56,244.00 4,686.75 46,364.89 82.435 9,879.11 135-50027-020-000 Dental Insurance 4,146.00 3,696.00 299.51 2,964.51 80.209 731.49 135-50028-020-000 Vision Insurance 990.00 912.00 69.00 687.39 75.372 224.61 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 289.36 2,845.21 89.080 348.79 135-50030-020-000 Social Security Taxes 21,680.00 21,812.00 2,236.04 15,928.62 73.027 5,883.38 135-50035-020-000 Medicare Taxes 5,070.00 5,101.00 522.94 3,710.50 72.741 1,390.50 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 7,259.10 45.313 8,760.90 135-50060-020-000 Pre-emp Physicals/Testing 150.00 300.00 126.00 42.000 174.00 135-50070-020-000 Employee Relations 550.00 650.00 71.88 523.15 80.485 126.85 135-55080-020-000 Maintenance & Repairs 58,000.00 72,600.00 15,073.96 86,704.58 119.428 14,104.58- 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 3,324.54 110.818 324.54- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 674.11 803.29 160.658 303.29- 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 3,273.01 39,988.75 72.707 15,011.25 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 3,534.00 22,213.50 88.854 2,786.50 Subtotal: 622,952.00 640,180.00 73,484.02 541,724.93 84.621 98,455.07 135-60010-020-000 Communications/Mobiles 4,662.00 4,662.00 422.53 4,414.17 94.684 247.83 135-60020-020-000 Electricity 149,292.00 139,292.00 929.39 95,006.45 68.207 44,285.55 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 200.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 16.73 1,813.23 90.662 186.77 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 300.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 511.97 784.59 156.918 284.59- 135-60331-020-000 Interfund Transfer Out-Tax I&S 65,255.00 30,645.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 136,989.00 100.000 135-60333-020-000 Interfund Transfer Out-Reserve 71,946.00 10,278.00 51,390.00 71.429 20,556.00 135-65005-020-000 Fuel & Lube 36,328.00 20,328.00 1,148.51 15,174.41 74.648 5,153.59 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 691.80 14,778.02 61.575 9,221.98 135-65035-020-000 Small Tools 2,000.00 1,500.00 879.20 58.613 620.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 2,190.45 12,341.13 94.932 658.87 135-69005-020-000 Capital Outlays 150,000.00 142,000.00 38,499.04 156,894.68 110.489 14,894.68- . glbase_tsam tsisk Trophy Club MUD #1 Page 9 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 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 35,991.00 56,991.00 100.000 135-69009-020-000 Short Term Debt-Interest 2,011.00 2,011.00 1,384.15 1,777.38 88.383 233.62 Subtotal: 839,165.00 713,217.00 259,897.57 594,090.23 83.297 119,126.77 Program number: 1,462,117.00 1,353,397.00 333,381.59 1,135,815.16 83.923 217,581.84 Department number: Wastewater 1,462,117.00 1,353,397.00 333,381.59 1,135,815.16 83.923 217,581.84 . glbase_tsam tsisk Trophy Club MUD #1 Page 10 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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,600.00 11,000.00 110.000 1,000.00- 135-50030-026-000 Social Security Taxes 620.00 620.00 99.20 682.00 110.000 62.00- 135-50035-026-000 Medicare Taxes 145.00 145.00 23.20 159.50 110.000 14.50- 135-50040-026-000 Unemployment Taxes 230.00 230.00 1.60 63.18 27.470 166.82 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 29.40 81.667 6.60 Subtotal: 11,031.00 11,031.00 1,726.94 11,934.08 108.187 903.08- 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 8.98 185.22 19.497 764.78 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,330.00 33.250 2,670.00 135-60100-026-000 Travel & per diem 5,000.00 4,250.00 920.86 3,478.88 81.856 771.12 135-60245-026-000 Miscellaneous Expenses 1,000.00 2,000.00 20.00 1,644.74 82.237 355.26 Subtotal: 11,850.00 11,850.00 949.84 6,673.84 56.319 5,176.16 Program number: 22,881.00 22,881.00 2,676.78 18,607.92 81.325 4,273.08 Department number: Board of Directors 22,881.00 22,881.00 2,676.78 18,607.92 81.325 4,273.08 . glbase_tsam tsisk Trophy Club MUD #1 Page 11 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 53,982.47 377,994.31 80.299 92,737.69 135-50010-030-000 Overtime 1,000.00 1,000.00 20.65 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 4,811.69 34,085.42 80.802 8,098.58 135-50026-030-000 Medical Insurance 65,015.00 62,000.00 5,166.33 48,710.52 78.565 13,289.48 135-50027-030-000 Dental Insurance 4,944.00 4,494.00 364.24 2,881.03 64.108 1,612.97 135-50028-030-000 Vision Insurance 1,158.00 1,116.00 84.38 810.11 72.591 305.89 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 369.42 3,646.61 84.159 686.39 135-50030-030-000 Social Security Taxes 30,079.00 29,654.00 3,205.37 22,371.89 75.443 7,282.11 135-50035-030-000 Medicare Taxes 7,422.00 7,317.00 749.65 5,232.11 71.506 2,084.89 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 873.00 53.362 763.00 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 228.65 2,690.29 53.806 2,309.71 135-55030-030-000 Software & Support 75,588.00 121,635.00 3,882.40 105,106.81 86.412 16,528.19 135-55070-030-000 Independent Labor 8,000.00 32,550.00 1,984.72 32,098.47 98.613 451.53 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 439.94 9.776 4,060.06 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 159.60 5,606.88 86.260 893.12 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 627.53 5,647.77 69.726 2,452.23 135-55160-030-000 Professional Outside Services 58,000.00 61,950.00 16,599.95 26.796 45,350.05 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 632.67 5,547.77 67.656 2,652.23 Subtotal: 821,495.00 904,503.00 76,357.07 700,492.97 77.445 204,010.03 135-60005-030-000 Telephone 13,361.00 13,361.00 889.73 9,973.60 74.647 3,387.40 135-60010-030-000 Communications/Mobiles 4,056.00 4,056.00 300.00 3,377.25 83.266 678.75 135-60020-030-000 Electricity/Gas 14,978.00 12,000.00 37.99 5,151.35 42.928 6,848.65 135-60025-030-000 Water 1,500.00 1,500.00 82.56 683.21 45.547 816.79 135-60035-030-000 Postage 28,500.00 28,500.00 3,704.84 25,014.04 87.769 3,485.96 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 3,907.21 35,904.95 112.203 3,904.95- 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 40,984.35 84.069 7,766.65 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 223.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 89.76 1,635.55 30.288 3,764.45 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60125-030-000 Advertising 2,500.00 2,500.00 5,630.53 225.221 3,130.53- 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 3,658.25 9,746.45 55.694 7,753.55 . glbase_tsam tsisk Trophy Club MUD #1 Page 12 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60270-030-000 4th of July Celebration 10,000.00 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 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 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 34,203.27 97.097 1,022.73 135-65085-030-000 Office Supplies 9,000.00 9,000.00 562.08 6,532.43 72.583 2,467.57 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 31.20 2,760.80 58.343 1,971.20 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 433.54 3,705.11 74.102 1,294.89 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 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 3,027.41 71.469 1,208.59 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 16,329.00 16,329.00 100.000 Subtotal: 465,524.00 373,484.00 41,983.17 311,828.90 83.492 61,655.10 Program number: 1,287,019.00 1,277,987.00 118,340.24 1,012,321.87 79.212 265,665.13 Department number: Administration 1,287,019.00 1,277,987.00 118,340.24 1,012,321.87 79.212 265,665.13 . glbase_tsam tsisk Trophy Club MUD #1 Page 13 08:50 08/13/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/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 11,926.35 445,514.67 95.317 21,888.33 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 11,926.35 472,771.23 93.861 30,922.77 Program number: 286,291.00 503,694.00 11,926.35 472,771.23 93.861 30,922.77 Department number: Non Departmental 286,291.00 503,694.00 11,926.35 472,771.23 93.861 30,922.77 Expenditures Subtotal ----------- 8,444,333.00 8,846,514.00 750,268.51 5,049,965.35 57.084 3,796,548.65 Fund number: 135 MUD 1 General Fund 43,662.85 1,063,675.12- 1,063,675.12 . glbase_tsam tsisk Trophy Club MUD #1 Page 19 08:50 08/13/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/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_tsam tsisk Trophy Club MUD #1 Page 20 08:50 08/13/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 7/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_tsam tsisk Trophy Club MUD #1 Page 21 08:50 08/13/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 7/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_tsam tsisk Trophy Club MUD #1 Page 22 08:50 08/13/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 7/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 1.17- 10.67- 10.67 Subtotal: 1.17- 10.67- 10.67 Program number: 1.17- 10.67- 10.67 Department number: 1.17- 10.67- 10.67 Revenues Subtotal ----------- 1.17- 10.67- 10.67 . glbase_tsam tsisk Trophy Club MUD #1 Page 23 08:50 08/13/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 7/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.17- 2,239.33 66.886 1,108.67 . glpdatb2 tsisk Trophy Club MUD #1 Page 14 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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 1886 07/01/2015 Property Taxes/Assessments (166,927.24) (1.52) (166,928.76) GL 1892 07/06/2015 Property Taxes/Assessments 4.12 (166,924.64) GL 1893 07/10/2015 Property Taxes/Assessments (15.10) (166,939.74) GL 1894 07/13/2015 Property Taxes/Assessments (38.78) (166,978.52) GL 1895 07/14/2015 Property Taxes/Assessments (29.64) (167,008.16) GL 1896 07/15/2015 Property Taxes/Assessments (33.51) (167,041.67) GL 1898 07/16/2015 Property Taxes/Assessments (33.63) (167,075.30) GL 1899 07/20/2015 Property Taxes/Assessments (32.45) (167,107.75) GL 1900 07/21/2015 Property Taxes/Assessments (6.02) (167,113.77) GL 1901 07/22/2015 Property Taxes/Assessments (41.42) (167,155.19) GL 1902 07/23/2015 Property Taxes/Assessments (4.96) (167,160.15) GL 1903 07/24/2015 Property Taxes/Assessments (15.24) (167,175.39) GL 1904 07/27/2015 Property Taxes/Assessments (61.17) (167,236.56) GL 1905 07/29/2015 Property Taxes/Assessments (14.43) (167,250.99) GL 1906 07/30/2015 Property Taxes/Assessments (52.50) (167,303.49) GL 1907 07/31/2015 Property Taxes/Assessments (61.83) (167,365.32) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (438.08) (167,365.32) ** (167,857.00) Budgeted (491.68) Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1907 07/31/2015 Property Taxes/Assessments (424.06) (15.58) (439.64) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (15.58) (439.64) ** .00 Budgeted 439.64 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1886 07/01/2015 Property Taxes/Assessments (601.71) (.21) (601.92) GL 1892 07/06/2015 Property Taxes/Assessments (.53) (602.45) GL 1895 07/14/2015 Property Taxes/Assessments (.89) (603.34) GL 1901 07/22/2015 Property Taxes/Assessments (.01) (603.35) GL 1905 07/29/2015 Property Taxes/Assessments (.36) (603.71) GL 1906 07/30/2015 Property Taxes/Assessments (2.91) (606.62) GL 1907 07/31/2015 Property Taxes/Assessments (2.93) (609.55) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (7.84) (609.55) ** (900.00) Budgeted (290.45) Remaining 68 % Used Account: 135-40025-000-000 PID Surcharges . glpdatb2 tsisk Trophy Club MUD #1 Page 15 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1861 07/31/2015 UB 7/31/15 Billing UB20150731-20150731 User: (104,708.50) (12,112.90) (116,821.40) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (12,112.90) (116,821.40) ** (133,997.00) Budgeted (17,175.60) Remaining 87 % Used Account: 135-47000-000-000 Water 1862 07/30/2015 UB 7/30/15 ADj for 55 Sonora UB20150730-20150730 User: (2,086,644.52) 70.20 (2,086,574.32) UB 1861 07/31/2015 UB 7/31/15 Billing UB20150731-20150731 User: (428,882.33) (2,515,456.65) UB _______________ Account: 135-47000-000-000 Water Totals: (428,812.13) (2,515,456.65) ** (4,747,789.00) Budgeted (2,232,332.35) Remaining 53 % Used Account: 135-47005-000-000 Sewer 1861 07/31/2015 UB 7/31/15 Billing UB20150731-20150731 User: (1,407,507.59) (222,102.64) (1,629,610.23) UB _______________ Account: 135-47005-000-000 Sewer Totals: (222,102.64) (1,629,610.23) ** (2,270,982.00) Budgeted (641,371.77) Remaining 72 % Used Account: 135-47025-000-000 Penalties 1805 07/21/2015 UB 7/21/15 Penalties UB20150721-20150721 User: (65,132.24) (8,144.46) (73,276.70) UB 1835 07/24/2015 UB 7/24/15 Penalties UB20150724-20150724 User: 54.51 (73,222.19) UB 1860 07/29/2015 UB 7/29/15 Penalty adjustments UB20150729-20150729 User: 247.35 (72,974.84) UB 1862 07/30/2015 UB 7/30/15 ADj for 55 Sonora UB20150730-20150730 User: 18.81 (72,956.03) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,823.79) (72,956.03) ** (80,000.00) Budgeted (7,043.97) Remaining 91 % Used Account: 135-47030-000-000 Service Charges 1737 07/08/2015 UB 7/8/15 Cut off list UB20150708-20150708 User: (7,974.00) (600.00) (8,574.00) UB 1830 07/08/2015 UB 7/8/15 NSF check fee UB20150708-20150708 User: (25.00) (8,599.00) UB 1846 07/23/2015 UB 7/23/15 NSF Check fee UB20150723-20150723 User: (25.00) (8,624.00) UB 1848 07/24/2015 UB 7/24/15 NSF Check fee UB20150724-20150724 User: (100.00) (8,724.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (750.00) (8,724.00) ** (10,000.00) Budgeted (1,276.00) Remaining 87 % Used Account: 135-47035-000-000 Plumbing Inspections 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (1,700.00) (100.00) (1,800.00) AR . glpdatb2 tsisk Trophy Club MUD #1 Page 16 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-47035-000-000 Plumbing Inspections Totals: (100.00) (1,800.00) ** (2,000.00) Budgeted (200.00) Remaining 90 % Used Account: 135-47045-000-000 Sewer Inspections 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (5,100.00) (300.00) (5,400.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (5,400.00) ** (5,000.00) Budgeted 400.00 Remaining 108 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1861 07/31/2015 UB 7/31/15 Billing UB20150731-20150731 User: (18,417.70) (15,248.10) (33,665.80) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (15,248.10) (33,665.80) ** (86,815.00) Budgeted (53,149.20) Remaining 39 % Used Account: 135-48005-000-000 Utility Fees 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (188,600.00) (13,800.00) (202,400.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (13,800.00) (202,400.00) ** (184,000.00) Budgeted 18,400.00 Remaining 110 % Used Account: 135-49010-000-000 Interest Income 1924 07/31/2015 Bank Interest/July (4,522.67) (76.95) (4,599.62) GL 1924 07/31/2015 Bank Interest/July (119.32) (4,718.94) GL 1924 07/31/2015 Bank Interest/July (320.17) (5,039.11) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (516.44) (5,039.11) ** (5,000.00) Budgeted 39.11 Remaining 101 % Used Account: 135-49016-000-000 Cell Tower Revenue 1765 07/01/2015 Cell Tower Revenue (8,194.77) (910.53) (9,105.30) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (9,105.30) ** (10,164.00) Budgeted (1,058.70) Remaining 90 % Used Account: 135-49018-000-000 Building Rent Income . glpdatb2 tsisk Trophy Club MUD #1 Page 17 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (5,249.97) (583.33) (5,833.30) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,833.30) ** (7,000.00) Budgeted (1,166.70) Remaining 83 % Used 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 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (44,775.83) (2,744.00) (47,519.83) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (2,744.00) (47,519.83) ** (42,000.00) Budgeted 5,519.83 Remaining 113 % 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 1861 07/31/2015 UB 7/31/15 Billing UB20150731-20150731 User: (104,732.16) (25.40) (104,757.56) UB . glpdatb2 tsisk Trophy Club MUD #1 Page 18 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1917 07/31/2015 Lennar Billing July AR 20150701-20150731 User: (104,732.16) (314.90) (105,072.46) AR _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (340.30) (105,072.46) ** (68,994.00) Budgeted 36,078.46 Remaining 152 % Used Account: 135-49901-000-000 Records Management Revenue (12.20) .00 (12.20) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (12.20) ** (100.00) Budgeted (87.80) Remaining 12 % Used Department Totals: ------------------------------------------------------------------------------------------------ (6,113,640.47) ** (8,846,514.00) Budgeted (2,732,873.53) Remaining 69 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 19 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 1677 07/03/2015 MUD Payroll 7/3/15 Salaries & Wages 146,657.41 9,738.37 156,395.78 PR 1775 07/17/2015 MUD Payroll 7/17/15 Salaries & Wages 9,738.37 166,134.15 PR 1828 07/31/2015 Payroll 07-31-15 Salaries & Wages 9,797.89 175,932.04 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 29,274.63 175,932.04 ** 244,578.00 Budgeted 68,645.96 Remaining 72 % Used Account: 135-50010-010-000 Overtime 1677 07/03/2015 MUD Payroll 7/3/15 Overtime 10,323.19 441.22 10,764.41 PR 1775 07/17/2015 MUD Payroll 7/17/15 Overtime 494.88 11,259.29 PR 1828 07/31/2015 Payroll 07-31-15 Overtime 564.62 11,823.91 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,500.72 11,823.91 ** 19,500.00 Budgeted 7,676.09 Remaining 61 % 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 1775 07/17/2015 MUD Payroll 7/17/15 Certification 2,050.00 225.00 2,275.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 2,275.00 ** 3,900.00 Budgeted 1,625.00 Remaining 58 % Used Account: 135-50020-010-000 Retirement 1677 07/03/2015 MUD Payroll 7/3/15 Retirement 14,442.02 906.99 15,349.01 PR 1775 07/17/2015 MUD Payroll 7/17/15 Retirement 931.83 16,280.84 PR 1828 07/31/2015 Payroll 07-31-15 Retirement 923.31 17,204.15 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,762.13 17,204.15 ** 23,987.00 Budgeted 6,782.85 Remaining 72 % Used Account: 135-50026-010-000 Medical Insurance 1677 07/03/2015 MUD Payroll 7/3/15 Medical Insurance 23,678.98 1,946.94 25,625.92 PR . glpdatb2 tsisk Trophy Club MUD #1 Page 20 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1775 07/17/2015 MUD Payroll 7/17/15 Medical Insurance 23,678.98 1,946.88 27,572.80 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,893.82 27,572.80 ** 51,487.00 Budgeted 23,914.20 Remaining 54 % Used Account: 135-50027-010-000 Dental Insurance 1677 07/03/2015 MUD Payroll 7/3/15 Dental Insurance 1,908.70 151.51 2,060.21 PR 1775 07/17/2015 MUD Payroll 7/17/15 Dental Insurance 151.51 2,211.72 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 303.02 2,211.72 ** 4,188.00 Budgeted 1,976.28 Remaining 53 % Used Account: 135-50028-010-000 Vision Insurance 1677 07/03/2015 MUD Payroll 7/3/15 Vision Insurance 445.85 34.46 480.31 PR 1775 07/17/2015 MUD Payroll 7/17/15 Vision Insurance 34.51 514.82 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 68.97 514.82 ** 990.00 Budgeted 475.18 Remaining 52 % Used Account: 135-50029-010-000 Life Insurance & Other 1645 07/01/2015 July A/P Dental, Vision, Other insuranc 1,568.98 212.31 1,781.29 METLIFE GROUP BENEFITS 35079 AP 1824 07/27/2015 July A/P Cafe 125 Admin Fees 8.44 1,789.73 BenefitMall 35192 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 220.75 1,789.73 ** 3,074.00 Budgeted 1,284.27 Remaining 58 % Used Account: 135-50030-010-000 Social Security Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Social Security Taxes 9,882.30 618.88 10,501.18 PR 1775 07/17/2015 MUD Payroll 7/17/15 Social Security Taxes 640.20 11,141.38 PR 1828 07/31/2015 Payroll 07-31-15 Social Security Taxes 645.09 11,786.47 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,904.17 11,786.47 ** 17,192.00 Budgeted 5,405.53 Remaining 69 % Used Account: 135-50035-010-000 Medicare Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Medicare Taxes 2,311.20 144.74 2,455.94 PR 1775 07/17/2015 MUD Payroll 7/17/15 Medicare Taxes 149.72 2,605.66 PR 1828 07/31/2015 Payroll 07-31-15 Medicare Taxes 150.86 2,756.52 PR . glpdatb2 tsisk Trophy Club MUD #1 Page 21 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 445.32 2,756.52 ** 4,021.00 Budgeted 1,264.48 Remaining 69 % Used Account: 135-50040-010-000 Unemployment Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Unemployment Taxes 17.77 1.04 18.81 PR 1775 07/17/2015 MUD Payroll 7/17/15 Unemployment Taxes 1.14 19.95 PR 1828 07/31/2015 Payroll 07-31-15 Unemployment Taxes 1.06 21.01 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 3.24 21.01 ** 1,242.00 Budgeted 1,220.99 Remaining 2 % Used Account: 135-50045-010-000 Workman's Compensation 200 07/01/2015 Jul TML Ins & Workers Comp 6,401.19 857.91 7,259.10 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.91 7,259.10 ** 16,020.00 Budgeted 8,760.90 Remaining 45 % 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 1761 07/10/2015 July A/P Solana Waterline Relocation En (2,090.00) 3,800.00 1,710.00 THE WALLACE GROUP, INC. 35145 AP 1763 07/10/2015 July billing Inv1325/Waterline AR 20150710-20150710 User: (3,800.00) (2,090.00) AR 1815 07/23/2015 July A/P Solana water line engineering 3,800.00 1,710.00 THE WALLACE GROUP, INC. 35189 AP _______________ Account: 135-55005-010-000 Engineering Totals: 3,800.00 1,710.00 ** 10,000.00 Budgeted 8,290.00 Remaining 17 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 22 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-010-000 Maintenance & Repairs 1790 07/17/2015 July A/P 8" couplings 54,929.25 439.32 55,368.57 HD SUPPLY WATERWORKS, LTD. 35154 AP 1815 07/23/2015 July A/P 3" meter gaskets 38.70 55,407.27 HD SUPPLY WATERWORKS, LTD. 35182 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 THE HOME DEPOT 6581 14.97 55,422.24 THE HOME DEPOT 6581 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 THE HOME DEPOT 6581 7.93 55,430.17 THE HOME DEPOT 6581 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 THE HOME DEPOT 6581 19.66 55,449.83 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 520.58 55,449.83 ** 81,113.00 Budgeted 25,663.17 Remaining 68 % Used Account: 135-55090-010-000 Vehicle Maintenance 1857 07/31/2015 July A/P Tire for Dump Truck 5,522.67 1,085.00 6,607.67 BLAGG TIRE & SERVICE 35200 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 GRAPEVINE FORD PARTS & 185.34 6,793.01 GRAPEVINE FORD PARTS & PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 DISCOUNT TIRE TXD 75 263.00 7,056.01 DISCOUNT TIRE TXD 75 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 DISCOUNT TIRE TXD 75 94.67 7,150.68 DISCOUNT TIRE TXD 75 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ROANOKE AUTO SUPPLY LT 132.00 7,282.68 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,760.01 7,282.68 ** 8,000.00 Budgeted 717.32 Remaining 91 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,463.47 .00 3,463.47 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 3,463.47 ** 3,500.00 Budgeted 36.53 Remaining 99 % Used Account: 135-55135-010-000 Lab Analysis 1790 07/17/2015 July A/P Water samples - MUD 3,289.80 225.00 3,514.80 TARRANT CTY PUBLIC HEALTH LAB 35169 AP 1790 07/17/2015 July A/P Lab analysis for MUD 207.70 3,722.50 LOWER COLORADO RIVER AUTHORITY 35161 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 432.70 3,722.50 ** 5,500.00 Budgeted 1,777.50 Remaining 68 % Used Account: 135-60010-010-000 Communications/Mobiles 1790 07/17/2015 July A/P Communications/Mobiles 2,803.03 397.93 3,200.96 VERIZON WIRELESS 35174 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 397.93 3,200.96 ** 4,913.00 Budgeted 1,712.04 Remaining 65 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 23 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 1815 07/23/2015 July A/P Electricity 06/11/2015 - 07/13 84,680.38 13,072.43 97,752.81 HUDSON ENERGY SERVICES, LLC 35183 AP 1815 07/23/2015 July A/P Electricity 06/11/2015 - 07/13 56.76 97,809.57 HUDSON ENERGY SERVICES, LLC 35183 AP _______________ Account: 135-60020-010-000 Electricity Totals: 13,129.19 97,809.57 ** 160,765.00 Budgeted 62,955.43 Remaining 61 % Used 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 1,173.00 .00 1,173.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,173.00 ** 4,138.00 Budgeted 2,965.00 Remaining 28 % 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 99.09 .00 99.09 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 99.09 ** 1,500.00 Budgeted 1,400.91 Remaining 7 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 tsisk Trophy Club MUD #1 Page 24 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 20,656.61 .00 20,656.61 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 20,656.61 ** 49,275.00 Budgeted 28,618.39 Remaining 42 % Used Account: 135-60150-010-000 Wholesale Water 1857 07/31/2015 July A/P June Wholesale Water 1,039,925.66 172,133.28 1,212,058.94 CITY OF FORT WORTH 35202 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 172,133.28 1,212,058.94 ** 2,928,308.00 Budgeted 1,716,249.06 Remaining 41 % 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 1871 07/31/2015 PCards 06/27/15 - 07/27/15 DENTON SAND & GRAVEL, 1,265.45 60.00 1,325.45 DENTON SAND & GRAVEL, PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 DENTON SAND & GRAVEL, 90.00 1,415.45 DENTON SAND & GRAVEL, PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 TEX-TURF 31.00 1,446.45 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 181.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 . glpdatb2 tsisk Trophy Club MUD #1 Page 25 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 924.51 .00 924.51 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 924.51 ** 3,500.00 Budgeted 2,575.49 Remaining 26 % Used Account: 135-65005-010-000 Fuel & Lube 1824 07/27/2015 July A/P Fuel 9,034.86 1,279.73 10,314.59 US Bank Voyager Fleet Systems 35198 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,279.73 10,314.59 ** 19,173.00 Budgeted 8,858.41 Remaining 54 % Used Account: 135-65010-010-000 Uniforms 1742 07/08/2015 July A/P Uniforms 3,075.30 109.50 3,184.80 RON MONTGOMERY & ASSOC INC 35131 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 109.50 3,184.80 ** 3,620.00 Budgeted 435.20 Remaining 88 % Used Account: 135-65030-010-000 Chemicals 1857 07/31/2015 July A/P Chlorine 7,567.79 203.30 7,771.09 DPC INDUSTRIES, INC 35203 AP 1909 07/31/2015 July A/P Chemicals 654.85 8,425.94 HACH COMPANY 35222 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 858.15 8,425.94 ** 10,000.00 Budgeted 1,574.06 Remaining 84 % Used Account: 135-65035-010-000 Small Tools 1871 07/31/2015 PCards 06/27/15 - 07/27/15 THE HOME DEPOT 6581 289.89 137.75 427.64 THE HOME DEPOT 6581 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 AMAZON MKTPLACE PMTS 210.00 637.64 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65035-010-000 Small Tools Totals: 347.75 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 . glpdatb2 tsisk Trophy Club MUD #1 Page 26 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1790 07/17/2015 July A/P Beacon Meters 92,664.34 2,500.00 95,164.34 ATLAS UTILITY SUPPLY CO. 35149 AP 1815 07/23/2015 July A/P 3" meters 16,630.00 111,794.34 ATLAS UTILITY SUPPLY CO. 35177 AP 1909 07/31/2015 July A/P Meter testing 225.00 112,019.34 ATLAS UTILITY SUPPLY CO. 35216 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 19,355.00 112,019.34 ** 165,000.00 Budgeted 52,980.66 Remaining 68 % Used Account: 135-69005-010-000 Capital Outlays 1815 07/23/2015 July A/P Trimble Geo 7X Handlheld 234,151.15 5,121.87 239,273.02 WESTERN DATA SYSTEMS 35190 AP 1838 07/23/2015 Void A/P Check #035190 Trimble Geo 7X Handlheld (5,121.87) 234,151.15 WESTERN DATA SYSTEMS 35190 AP 1857 07/31/2015 July A/P Trimble Geo 7X Handheld 10,243.74 244,394.89 WESTERN DATA SYSTEMS 35212 AP 1872 07/31/2015 July A/P Generator - upfront 13,726.57 258,121.46 WORLDWIDE POWER PRODUCTS 35215 AP 1909 07/31/2015 July A/P Waterline Indian Creek 150.00 258,271.46 TEAGUE, NALL & PERKINS,INC 35235 AP 1909 07/31/2015 July A/P Waterline Pin Oak, PB, TB 3,874.89 262,146.35 TEAGUE, NALL & PERKINS,INC 35235 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 27,995.20 262,146.35 ** 1,457,597.00 Budgeted 1,195,450.65 Remaining 18 % 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 2,415.58 .00 2,415.58 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 2,415.58 ** 3,612.00 Budgeted 1,196.42 Remaining 67 % 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 . glpdatb2 tsisk Trophy Club MUD #1 Page 27 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.76 ** 151,507.00 Budgeted 24,549.24 Remaining 84 % Used Account: 135-55135-010-001 Lab Analysis for PID 1790 07/17/2015 July A/P Water Samples - PID 2,513.75 80.00 2,593.75 TARRANT CTY PUBLIC HEALTH LAB 35169 AP 1790 07/17/2015 July A/P Lab analysis for PID 103.85 2,697.60 LOWER COLORADO RIVER AUTHORITY 35161 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 183.85 2,697.60 ** 5,000.00 Budgeted 2,302.40 Remaining 54 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID 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,410,449.17 ** 5,688,555.00 Budgeted 3,278,105.83 Remaining 42 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 28 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 1677 07/03/2015 MUD Payroll 7/3/15 Salaries & Wages 212,670.17 11,841.35 224,511.52 PR 1775 07/17/2015 MUD Payroll 7/17/15 Salaries & Wages 11,841.35 236,352.87 PR 1828 07/31/2015 Payroll 07-31-15 Salaries & Wages 12,035.81 248,388.68 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 35,718.51 248,388.68 ** 307,875.00 Budgeted 59,486.32 Remaining 81 % Used Account: 135-50010-020-000 Overtime 1677 07/03/2015 MUD Payroll 7/3/15 Overtime 21,296.50 880.31 22,176.81 PR 1775 07/17/2015 MUD Payroll 7/17/15 Overtime 839.30 23,016.11 PR 1828 07/31/2015 Payroll 07-31-15 Overtime 479.94 23,496.05 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,199.55 23,496.05 ** 24,500.00 Budgeted 1,003.95 Remaining 96 % 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 1775 07/17/2015 MUD Payroll 7/17/15 Certification 4,950.00 550.00 5,500.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 5,500.00 ** 6,600.00 Budgeted 1,100.00 Remaining 83 % Used Account: 135-50020-020-000 Retirement 1677 07/03/2015 MUD Payroll 7/3/15 Retirement 21,839.78 1,133.49 22,973.27 PR 1775 07/17/2015 MUD Payroll 7/17/15 Retirement 1,178.86 24,152.13 PR 1828 07/31/2015 Payroll 07-31-15 Retirement 1,115.14 25,267.27 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,427.49 25,267.27 ** 30,317.00 Budgeted 5,049.73 Remaining 83 % Used Account: 135-50026-020-000 Medical Insurance 1677 07/03/2015 MUD Payroll 7/3/15 Medical Insurance 41,678.14 2,343.40 44,021.54 PR . glpdatb2 tsisk Trophy Club MUD #1 Page 29 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1775 07/17/2015 MUD Payroll 7/17/15 Medical Insurance 41,678.14 2,343.35 46,364.89 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,686.75 46,364.89 ** 56,244.00 Budgeted 9,879.11 Remaining 82 % Used Account: 135-50027-020-000 Dental Insurance 1677 07/03/2015 MUD Payroll 7/3/15 Dental Insurance 2,665.00 149.75 2,814.75 PR 1775 07/17/2015 MUD Payroll 7/17/15 Dental Insurance 149.76 2,964.51 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 299.51 2,964.51 ** 3,696.00 Budgeted 731.49 Remaining 80 % Used Account: 135-50028-020-000 Vision Insurance 1677 07/03/2015 MUD Payroll 7/3/15 Vision Insurance 618.39 34.48 652.87 PR 1775 07/17/2015 MUD Payroll 7/17/15 Vision Insurance 34.52 687.39 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 69.00 687.39 ** 912.00 Budgeted 224.61 Remaining 75 % Used Account: 135-50029-020-000 Life Insurance & Other 1645 07/01/2015 July A/P Dental, Vision, Other insuranc 2,555.85 255.58 2,811.43 METLIFE GROUP BENEFITS 35079 AP 1824 07/27/2015 July A/P Cafe 125 Admin Fees 33.78 2,845.21 BenefitMall 35192 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 289.36 2,845.21 ** 3,194.00 Budgeted 348.79 Remaining 89 % Used Account: 135-50030-020-000 Social Security Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Social Security Taxes 13,692.58 715.04 14,407.62 PR 1775 07/17/2015 MUD Payroll 7/17/15 Social Security Taxes 742.41 15,150.03 PR 1828 07/31/2015 Payroll 07-31-15 Social Security Taxes 778.59 15,928.62 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,236.04 15,928.62 ** 21,812.00 Budgeted 5,883.38 Remaining 73 % Used Account: 135-50035-020-000 Medicare Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Medicare Taxes 3,187.56 167.21 3,354.77 PR 1775 07/17/2015 MUD Payroll 7/17/15 Medicare Taxes 173.64 3,528.41 PR 1828 07/31/2015 Payroll 07-31-15 Medicare Taxes 182.09 3,710.50 PR . glpdatb2 tsisk Trophy Club MUD #1 Page 30 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 522.94 3,710.50 ** 5,101.00 Budgeted 1,390.50 Remaining 73 % Used Account: 135-50040-020-000 Unemployment Taxes 13.90 .00 13.90 _______________ 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 200 07/01/2015 Jul TML Ins & Workers Comp 6,401.19 857.91 7,259.10 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.91 7,259.10 ** 16,020.00 Budgeted 8,760.90 Remaining 45 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 126.00 .00 126.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 126.00 ** 300.00 Budgeted 174.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 1871 07/31/2015 PCards 06/27/15 - 07/27/15 DOVE CREEK CAFE 451.27 71.88 523.15 DOVE CREEK CAFE PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 71.88 523.15 ** 650.00 Budgeted 126.85 Remaining 80 % Used Account: 135-55080-020-000 Maintenance & Repairs 1761 07/10/2015 July A/P Concrete Repair 552 Indian Cre 71,630.62 3,125.36 74,755.98 Pave-It, Inc. 35144 AP 1761 07/10/2015 July A/P Concrete Repair 552 Indian Cre 3,876.84 78,632.82 Pave-It, Inc. 35144 AP 1790 07/17/2015 July A/P Repairs & Maintenance 1,876.48 80,509.30 ATLAS UTILITY SUPPLY CO. 35149 AP 1790 07/17/2015 July A/P Repair pump 4,934.17 85,443.47 NORTH TEXAS PUMP CO. 35163 AP 1815 07/23/2015 July A/P Bolts & gaskets 63.65 85,507.12 ATLAS UTILITY SUPPLY CO. 35177 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ROANOKE AUTO SUPPLY LT 40.72 85,547.84 ROANOKE AUTO SUPPLY LT PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ROANOKE AUTO SUPPLY LT 40.72 85,588.56 ROANOKE AUTO SUPPLY LT PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SQ *MALYSA LE LLC 1,040.00 86,628.56 SQ *MALYSA LE LLC PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 FERGUSON ENT #788 51.94 86,680.50 FERGUSON ENT #788 PC . glpdatb2 tsisk Trophy Club MUD #1 Page 31 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SUMMIT ELECTRIC SUPPLY 71,630.62 24.08 86,704.58 SUMMIT ELECTRIC SUPPLY PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 15,073.96 86,704.58 ** 72,600.00 Budgeted (14,104.58) Remaining 119 % Used Account: 135-55090-020-000 Vehicle Maintenance 3,324.54 .00 3,324.54 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 3,324.54 ** 3,000.00 Budgeted (324.54) Remaining 111 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1857 07/31/2015 July A/P Backhoe repair 129.18 1,348.22 1,477.40 LANDMARK EQUIPMENT, INC 35207 AP 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (674.11) 803.29 AR _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 674.11 803.29 ** 500.00 Budgeted (303.29) Remaining 161 % Used Account: 135-55125-020-000 Dumpster Services 1790 07/17/2015 July A/P Dumpster services 36,715.74 1,112.35 37,828.09 L.H. CHANEY MATERIALS, INC. 35160 AP 1790 07/17/2015 July A/P Dumpster Services 1,342.28 39,170.37 L.H. CHANEY MATERIALS, INC. 35160 AP 1815 07/23/2015 July A/P Sludge hauling 818.38 39,988.75 L.H. CHANEY MATERIALS, INC. 35184 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,273.01 39,988.75 ** 55,000.00 Budgeted 15,011.25 Remaining 73 % Used Account: 135-55135-020-000 Lab Analysis 1790 07/17/2015 July A/P Lab analysis 18,679.50 246.00 18,925.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P Lab analysis 176.00 19,101.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P Lab analysis 246.00 19,347.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P Lab analysis 176.00 19,523.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P Lab analysis 246.00 19,769.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P Lab analysis 246.00 20,015.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P 176.00 20,191.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P Lab analysis 246.00 20,437.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P Lab analysis 176.00 20,613.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P Lab analysis 246.00 20,859.50 OXIDOR LABORATORIES LLC 35165 AP 1790 07/17/2015 July A/P Lab analysis 176.00 21,035.50 OXIDOR LABORATORIES LLC 35165 AP 1815 07/23/2015 July A/P Lab analysis 176.00 21,211.50 OXIDOR LABORATORIES LLC 35187 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 32 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1815 07/23/2015 July A/P Lab analysis 18,679.50 246.00 21,457.50 OXIDOR LABORATORIES LLC 35187 AP 1815 07/23/2015 July A/P Lab analysis 135.50 21,593.00 OXIDOR LABORATORIES LLC 35187 AP 1857 07/31/2015 July A/P Lab analysis 198.50 21,791.50 OXIDOR LABORATORIES LLC 35209 AP 1857 07/31/2015 July A/P Lab analysis 246.00 22,037.50 OXIDOR LABORATORIES LLC 35209 AP 1857 07/31/2015 July A/P Lab analysis 176.00 22,213.50 OXIDOR LABORATORIES LLC 35209 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 3,534.00 22,213.50 ** 25,000.00 Budgeted 2,786.50 Remaining 89 % Used Account: 135-60010-020-000 Communications/Mobiles 1790 07/17/2015 July A/P Communications/Mobiles 3,991.64 422.53 4,414.17 VERIZON WIRELESS 35174 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 422.53 4,414.17 ** 4,662.00 Budgeted 247.83 Remaining 95 % Used Account: 135-60020-020-000 Electricity 1790 07/17/2015 July A/P Electricity 05/28/2015-06/29/2 94,077.06 412.84 94,489.90 TRI COUNTY ELECTRIC 35173 AP 1790 07/17/2015 July A/P Electricity 05/28/2015-06/29/2 206.69 94,696.59 TRI COUNTY ELECTRIC 35173 AP 1790 07/17/2015 July A/P Electricity 05/28/2015-06/29/2 28.03 94,724.62 TRI COUNTY ELECTRIC 35173 AP 1790 07/17/2015 July A/P Electricity 06/10/15-07/10/15 48.71 94,773.33 HUDSON ENERGY SERVICES, LLC 35155 AP 1790 07/17/2015 July A/P Electricity 06/10/15-07/10/15 28.50 94,801.83 HUDSON ENERGY SERVICES, LLC 35155 AP 1815 07/23/2015 July A/P Electricity 06/11/2015 - 07/13 350.72 95,152.55 HUDSON ENERGY SERVICES, LLC 35183 AP 1815 07/23/2015 July A/P Electricity 06/11/2015 - 07/13 97.07 95,249.62 HUDSON ENERGY SERVICES, LLC 35183 AP 1935 07/31/2015 Move Electric exp to rightdept Move Electric exp to rightdept 142.93 95,392.55 GL 1948 07/31/2015 Reverse Move Electric exp Move Electric exp to rightdept (142.93) 95,249.62 GL 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (243.17) 95,006.45 AR _______________ Account: 135-60020-020-000 Electricity Totals: 929.39 95,006.45 ** 139,292.00 Budgeted 44,285.55 Remaining 68 % 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 . glpdatb2 tsisk Trophy Club MUD #1 Page 33 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-020-000 Dues & Memberships Totals: .00 307.00 ** 250.00 Budgeted (57.00) Remaining 123 % Used Account: 135-60080-020-000 Schools & Training 1871 07/31/2015 PCards 06/27/15 - 07/27/15 UTA DED CVENT 1,326.00 200.00 1,526.00 UTA DED CVENT PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 200.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 1790 07/17/2015 July A/P Travel & Per Diem 1,796.50 5.25 1,801.75 NTTA 35164 AP 1815 07/23/2015 July A/P Travel 11.48 1,813.23 NTTA 35186 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 16.73 1,813.23 ** 2,000.00 Budgeted 186.77 Remaining 91 % Used Account: 135-60105-020-000 Rent/Lease Equipment 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 .00 .00 . glpdatb2 tsisk Trophy Club MUD #1 Page 34 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1871 07/31/2015 PCards 06/27/15 - 07/27/15 KYLE S BIKE&MOWER SHOP 272.62 511.97 784.59 KYLE S BIKE&MOWER SHOP PC _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 511.97 784.59 ** 500.00 Budgeted (284.59) Remaining 157 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1788 07/16/2015 Texpool transfers O&M to Tax I&S(PID Surcharge) 30,645.00 30,645.00 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 30,645.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 1788 07/16/2015 Texpool transfers O&M to Revenue Bond I&S 136,989.00 136,989.00 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 136,989.00 136,989.00 ** 136,989.00 Budgeted .00 Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1743 07/01/2015 Rev Bond Reserve Mo. payment 41,112.00 10,278.00 51,390.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 51,390.00 ** 71,946.00 Budgeted 20,556.00 Remaining 71 % Used Account: 135-65005-020-000 Fuel & Lube 1824 07/27/2015 July A/P Fuel 14,025.90 1,084.60 15,110.50 US Bank Voyager Fleet Systems 35198 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 MUSTANG ELITE CAR WASH 63.91 15,174.41 MUSTANG ELITE CAR WASH PC _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,148.51 15,174.41 ** 20,328.00 Budgeted 5,153.59 Remaining 75 % Used Account: 135-65010-020-000 Uniforms 2,598.44 .00 2,598.44 . glpdatb2 tsisk Trophy Club MUD #1 Page 35 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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-020-000 Uniforms Totals: .00 2,598.44 ** 2,778.00 Budgeted 179.56 Remaining 94 % Used Account: 135-65030-020-000 Chemicals 1871 07/31/2015 PCards 06/27/15 - 07/27/15 AQUAFIX INC. 14,086.22 691.80 14,778.02 AQUAFIX INC. PC _______________ Account: 135-65030-020-000 Chemicals Totals: 691.80 14,778.02 ** 24,000.00 Budgeted 9,221.98 Remaining 62 % Used Account: 135-65035-020-000 Small Tools 879.20 .00 879.20 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 879.20 ** 1,500.00 Budgeted 620.80 Remaining 59 % 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 1790 07/17/2015 July A/P Chemicals 10,150.68 536.67 10,687.35 HACH COMPANY 35153 AP 1790 07/17/2015 July A/P Chemicals 311.18 10,998.53 HACH COMPANY 35153 AP 1790 07/17/2015 July A/P Lab Supplies 806.86 11,805.39 IDEXX DISTRIBUTION, INC 35156 AP 1790 07/17/2015 July A/P Lab Supplies 171.21 11,976.60 IDEXX DISTRIBUTION, INC 35156 AP 1793 07/17/2015 Void A/P Ck 35153/pd by pcard Chemicals (536.67) 11,439.93 HACH COMPANY 35153 AP 1793 07/17/2015 Void A/P Ck 35153/pd by pcard Chemicals (311.18) 11,128.75 HACH COMPANY 35153 AP 1815 07/23/2015 July A/P Chemicals 536.67 11,665.42 HACH COMPANY 35181 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 USA BLUE BOOK 59.64 11,725.06 USA BLUE BOOK PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 HACH COMPANY 304.89 12,029.95 HACH COMPANY PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 HACH COMPANY 311.18 12,341.13 HACH COMPANY PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,190.45 12,341.13 ** 13,000.00 Budgeted 658.87 Remaining 95 % Used Account: 135-69005-020-000 Capital Outlays . glpdatb2 tsisk Trophy Club MUD #1 Page 36 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1783 07/16/2015 July A/P Lift Station #2, Application # 118,395.64 38,499.04 156,894.68 REY-MAR CONSTRUCTION 35147 AP 1815 07/23/2015 July A/P Trimble Geo 7X Handlheld 5,121.87 162,016.55 WESTERN DATA SYSTEMS 35190 AP 1838 07/23/2015 Void A/P Check #035190 Trimble Geo 7X Handlheld (5,121.87) 156,894.68 WESTERN DATA SYSTEMS 35190 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 38,499.04 156,894.68 ** 142,000.00 Budgeted (14,894.68) Remaining 110 % Used Account: 135-69008-020-000 Short Term Debt-Principal 1815 07/23/2015 July A/P Final payment Gap Vac 21,000.00 35,991.00 56,991.00 FIRST FINANCIAL BANK 35179 AP _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: 35,991.00 56,991.00 ** 56,991.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 1815 07/23/2015 July A/P Final payment Gap Vac 393.23 1,384.15 1,777.38 FIRST FINANCIAL BANK 35179 AP _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: 1,384.15 1,777.38 ** 2,011.00 Budgeted 233.62 Remaining 88 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,135,815.16 ** 1,353,397.00 Budgeted 217,581.84 Remaining 84 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 37 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-021-000 Electricity 1935 07/31/2015 Move Electric exp to rightdept Move Electric exp to rightdept (142.93) (142.93) GL 1947 07/31/2015 Rev Town Payment & Adjustment AR 20150701-20150731 User: (142.93) (285.86) GL 1948 07/31/2015 Reverse Move Electric exp Move Electric exp to rightdept 142.93 (142.93) GL 1920 07/31/2015 Town Payment & Adjustment AR 20150701-20150731 User: 142.93 .00 AR _______________ Account: 135-60020-021-000 Electricity Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ .00 ** .00 Budgeted .00 Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 38 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 1677 07/03/2015 MUD Payroll 7/3/15 Salaries & Wages 9,400.00 800.00 10,200.00 PR 1828 07/31/2015 Payroll 07-31-15 Salaries & Wages 800.00 11,000.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,600.00 11,000.00 ** 10,000.00 Budgeted (1,000.00) Remaining 110 % Used Account: 135-50030-026-000 Social Security Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Social Security Taxes 582.80 49.60 632.40 PR 1828 07/31/2015 Payroll 07-31-15 Social Security Taxes 49.60 682.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 99.20 682.00 ** 620.00 Budgeted (62.00) Remaining 110 % Used Account: 135-50035-026-000 Medicare Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Medicare Taxes 136.30 11.60 147.90 PR 1828 07/31/2015 Payroll 07-31-15 Medicare Taxes 11.60 159.50 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 23.20 159.50 ** 145.00 Budgeted (14.50) Remaining 110 % Used Account: 135-50040-026-000 Unemployment Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Unemployment Taxes 61.58 .80 62.38 PR 1828 07/31/2015 Payroll 07-31-15 Unemployment Taxes .80 63.18 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.60 63.18 ** 230.00 Budgeted 166.82 Remaining 27 % Used Account: 135-50045-026-000 Workman's Compensation 200 07/01/2015 Jul TML Ins & Workers Comp 26.46 2.94 29.40 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 29.40 ** 36.00 Budgeted 6.60 Remaining 82 % 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 tsisk Trophy Club MUD #1 Page 39 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 1871 07/31/2015 PCards 06/27/15 - 07/27/15 WM SUPERCENTER #5985 176.24 8.98 185.22 WM SUPERCENTER #5985 PC _______________ Account: 135-60075-026-000 Meetings Totals: 8.98 185.22 ** 950.00 Budgeted 764.78 Remaining 19 % Used Account: 135-60080-026-000 Schools & Training 1,330.00 .00 1,330.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,330.00 ** 4,000.00 Budgeted 2,670.00 Remaining 33 % Used Account: 135-60100-026-000 Travel & per diem 1824 07/27/2015 July A/P AWBD Expenses 2,558.02 920.86 3,478.88 Neil Twomey 35196 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 920.86 3,478.88 ** 4,250.00 Budgeted 771.12 Remaining 82 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1871 07/31/2015 PCards 06/27/15 - 07/27/15 KELLER TROPHY AND AWAR 1,624.74 20.00 1,644.74 KELLER TROPHY AND AWAR PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 20.00 1,644.74 ** 2,000.00 Budgeted 355.26 Remaining 82 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 18,607.92 ** 22,881.00 Budgeted 4,273.08 Remaining 81 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 40 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 1677 07/03/2015 MUD Payroll 7/3/15 Salaries & Wages 324,011.84 17,995.77 342,007.61 PR 1775 07/17/2015 MUD Payroll 7/17/15 Salaries & Wages 17,990.93 359,998.54 PR 1828 07/31/2015 Payroll 07-31-15 Salaries & Wages 17,995.77 377,994.31 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 53,982.47 377,994.31 ** 470,732.00 Budgeted 92,737.69 Remaining 80 % Used Account: 135-50010-030-000 Overtime 1677 07/03/2015 MUD Payroll 7/3/15 Overtime 495.38 5.97 501.35 PR 1775 07/17/2015 MUD Payroll 7/17/15 Overtime 2.58 503.93 PR 1828 07/31/2015 Payroll 07-31-15 Overtime 12.10 516.03 PR _______________ Account: 135-50010-030-000 Overtime Totals: 20.65 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 1677 07/03/2015 MUD Payroll 7/3/15 Retirement 29,273.73 1,603.96 30,877.69 PR 1775 07/17/2015 MUD Payroll 7/17/15 Retirement 1,603.23 32,480.92 PR 1828 07/31/2015 Payroll 07-31-15 Retirement 1,604.50 34,085.42 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,811.69 34,085.42 ** 42,184.00 Budgeted 8,098.58 Remaining 81 % Used Account: 135-50026-030-000 Medical Insurance 1677 07/03/2015 MUD Payroll 7/3/15 Medical Insurance 43,544.19 2,583.19 46,127.38 PR 1775 07/17/2015 MUD Payroll 7/17/15 Medical Insurance 2,583.14 48,710.52 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,166.33 48,710.52 ** 62,000.00 Budgeted 13,289.48 Remaining 79 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 tsisk Trophy Club MUD #1 Page 41 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1677 07/03/2015 MUD Payroll 7/3/15 Dental Insurance 2,516.79 182.11 2,698.90 PR 1775 07/17/2015 MUD Payroll 7/17/15 Dental Insurance 182.13 2,881.03 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 364.24 2,881.03 ** 4,494.00 Budgeted 1,612.97 Remaining 64 % Used Account: 135-50028-030-000 Vision Insurance 1677 07/03/2015 MUD Payroll 7/3/15 Vision Insurance 725.73 42.16 767.89 PR 1775 07/17/2015 MUD Payroll 7/17/15 Vision Insurance 42.22 810.11 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 84.38 810.11 ** 1,116.00 Budgeted 305.89 Remaining 73 % Used Account: 135-50029-030-000 Life Insurance & Other 1645 07/01/2015 July A/P Dental, Vision, Other insuranc 3,277.19 335.64 3,612.83 METLIFE GROUP BENEFITS 35079 AP 1824 07/27/2015 July A/P Cafe 125 Admin Fees 33.78 3,646.61 BenefitMall 35192 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 369.42 3,646.61 ** 4,333.00 Budgeted 686.39 Remaining 84 % Used Account: 135-50030-030-000 Social Security Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Social Security Taxes 19,166.52 1,045.43 20,211.95 PR 1775 07/17/2015 MUD Payroll 7/17/15 Social Security Taxes 1,043.46 21,255.41 PR 1828 07/31/2015 Payroll 07-31-15 Social Security Taxes 1,116.48 22,371.89 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 3,205.37 22,371.89 ** 29,654.00 Budgeted 7,282.11 Remaining 75 % Used Account: 135-50035-030-000 Medicare Taxes 1677 07/03/2015 MUD Payroll 7/3/15 Medicare Taxes 4,482.46 244.49 4,726.95 PR 1775 07/17/2015 MUD Payroll 7/17/15 Medicare Taxes 244.03 4,970.98 PR 1828 07/31/2015 Payroll 07-31-15 Medicare Taxes 261.13 5,232.11 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 749.65 5,232.11 ** 7,317.00 Budgeted 2,084.89 Remaining 72 % Used Account: 135-50040-030-000 Unemployment Taxes 143.56 .00 143.56 . glpdatb2 tsisk Trophy Club MUD #1 Page 42 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 143.56 ** 1,449.00 Budgeted 1,305.44 Remaining 10 % Used Account: 135-50045-030-000 Workman's Compensation 200 07/01/2015 Jul TML Ins & Workers Comp 785.70 87.30 873.00 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 873.00 ** 1,636.00 Budgeted 763.00 Remaining 53 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 38.00 .00 38.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 500.00 Budgeted 462.00 Remaining 8 % Used Account: 135-50070-030-000 Employee Relations 1871 07/31/2015 PCards 06/27/15 - 07/27/15 WALGREENS #5919 2,461.64 8.10 2,469.74 WALGREENS #5919 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 FLOWER DELIVERY EXP 110.22 2,579.96 FLOWER DELIVERY EXP PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 DOVE CREEK CAFE 89.85 2,669.81 DOVE CREEK CAFE PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 RANDALLS STORE00017897 20.48 2,690.29 RANDALLS STORE00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 228.65 2,690.29 ** 5,000.00 Budgeted 2,309.71 Remaining 54 % Used Account: 135-55030-030-000 Software & Support 1790 07/17/2015 July A/P Software & Support 101,224.41 2,337.72 103,562.13 STW INC 35168 AP 1790 07/17/2015 July A/P Software & Support 1,163.56 104,725.69 WHOLESALE CARRIER SERVICES INC 35175 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ATT*BILL PAYMENT 90.39 104,816.08 ATT*BILL PAYMENT PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ATT*BILL PAYMENT 106.73 104,922.81 ATT*BILL PAYMENT PC 1909 07/31/2015 July A/P Software & Support 184.00 105,106.81 STW INC 35234 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 3,882.40 105,106.81 ** 121,635.00 Budgeted 16,528.19 Remaining 86 % Used Account: 135-55070-030-000 Independent Labor 1790 07/17/2015 July A/P Water study 30,113.75 1,984.72 32,098.47 THE WALLACE GROUP, INC. 35172 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 43 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-55070-030-000 Independent Labor Totals: 1,984.72 32,098.47 ** 32,550.00 Budgeted 451.53 Remaining 99 % Used Account: 135-55080-030-000 Maintenance & Repairs 439.94 .00 439.94 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 439.94 ** 4,500.00 Budgeted 4,060.06 Remaining 10 % Used Account: 135-55100-030-000 Building Maint & Supplies 1815 07/23/2015 July A/P credit for invoice 1159697649 5,447.28 (61.52) 5,385.76 G & K SERVICES 35180 AP 1815 07/23/2015 July A/P Credit for invoice 1159711045 (61.52) 5,324.24 G & K SERVICES 35180 AP 1815 07/23/2015 July A/P Credit for invoice 1159724278 (61.52) 5,262.72 G & K SERVICES 35180 AP 1815 07/23/2015 July A/P Rug cleaning 125.94 5,388.66 G & K SERVICES 35180 AP 1815 07/23/2015 July A/P Rug cleaning 125.94 5,514.60 G & K SERVICES 35180 AP 1815 07/23/2015 July A/P Rug cleaning 125.94 5,640.54 G & K SERVICES 35180 AP 1815 07/23/2015 July A/P Rug cleaning 125.94 5,766.48 G & K SERVICES 35180 AP 1909 07/31/2015 July A/P Bathroom freshener refund 92.28 5,858.76 TOWN OF TROPHY CLUB 35237 AP 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (251.88) 5,606.88 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 159.60 5,606.88 ** 6,500.00 Budgeted 893.12 Remaining 86 % Used Account: 135-55120-030-000 Cleaning Services 1790 07/17/2015 July A/P Cleaning Services 5,020.24 627.53 5,647.77 MEMBER'S BUILDING MAINTENANCE 35162 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 627.53 5,647.77 ** 8,100.00 Budgeted 2,452.23 Remaining 70 % Used Account: 135-55160-030-000 Professional Outside Services 16,599.95 .00 16,599.95 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 16,599.95 ** 61,950.00 Budgeted 45,350.05 Remaining 27 % Used Account: 135-55161-030-000 Town Personnel Contract 26,170.00 .00 26,170.00 . glpdatb2 tsisk Trophy Club MUD #1 Page 44 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-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 1815 07/23/2015 July A/P Monthly utility billing 4,915.10 632.67 5,547.77 DATAPROSE LLC 35178 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 632.67 5,547.77 ** 8,200.00 Budgeted 2,652.23 Remaining 68 % Used Account: 135-60005-030-000 Telephone 1596 07/01/2015 July A/P Answering Service/July 9,083.87 180.00 9,263.87 KEYSTONE PARK SECRETARIAL 35026 AP 1790 07/17/2015 July A/P Telephone 180.00 9,443.87 KEYSTONE PARK SECRETARIAL 35159 AP 1857 07/31/2015 July A/P Remote phone to night mode 74.50 9,518.37 NATIONAL TELESYSTEMS, INC. 35208 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 RINGCENTRAL, INC 9.99 9,528.36 RINGCENTRAL, INC PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 ATT*BUS PHONE PMT 445.24 9,973.60 ATT*BUS PHONE PMT PC _______________ Account: 135-60005-030-000 Telephone Totals: 889.73 9,973.60 ** 13,361.00 Budgeted 3,387.40 Remaining 75 % Used Account: 135-60010-030-000 Communications/Mobiles 1775 07/17/2015 MUD Payroll 7/17/15 Communications/Mobiles 3,077.25 300.00 3,377.25 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 300.00 3,377.25 ** 4,056.00 Budgeted 678.75 Remaining 83 % Used Account: 135-60020-030-000 Electricity/Gas 1790 07/17/2015 July A/P Communications/Mobiles 5,113.36 37.99 5,151.35 VERIZON WIRELESS 35174 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 37.99 5,151.35 ** 12,000.00 Budgeted 6,848.65 Remaining 43 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 45 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-60025-030-000 Water 1909 07/31/2015 July A/P July Water Bills 600.65 165.12 765.77 TROPHY CLUB MUD (WATER BILLS) 35238 AP 1922 07/31/2015 Town Billing July Invoices AR 20150731-20150731 User: (82.56) 683.21 AR _______________ Account: 135-60025-030-000 Water Totals: 82.56 683.21 ** 1,500.00 Budgeted 816.79 Remaining 46 % Used Account: 135-60035-030-000 Postage 1766 07/13/2015 July A/P Bulk mail notice of Public Hea 21,309.20 1,045.21 22,354.41 U.S. POSTAL SERVICE 35146 AP 1790 07/17/2015 July A/P Freight for postage machine 30.00 22,384.41 FRANCOTYP-POSTALIA, INC. 35152 AP 1815 07/23/2015 July A/P Monthly utility billing 1,738.41 24,122.82 DATAPROSE LLC 35178 AP 1824 07/27/2015 July A/P Postage Meter Lease 432.00 24,554.82 FRANCOTYP-POSTALIA, INC. 35194 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 USPS POSTAL ST66100207 305.00 24,859.82 USPS POSTAL ST66100207 PC 1885 07/31/2015 Postage meter used/July 154.22 25,014.04 GL _______________ Account: 135-60035-030-000 Postage Totals: 3,704.84 25,014.04 ** 28,500.00 Budgeted 3,485.96 Remaining 88 % Used Account: 135-60040-030-000 Service Charges & Fees 1925 07/10/2015 Bank Analysis Fee- June 31,997.74 250.00 32,247.74 GL 1923 07/31/2015 Credit Card Fees/UB 35.00 32,282.74 GL 1923 07/31/2015 Credit Card Fees/UB 70.61 32,353.35 GL 1923 07/31/2015 Credit Card Fees/UB 3,551.60 35,904.95 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,907.21 35,904.95 ** 32,000.00 Budgeted (3,904.95) Remaining 112 % 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 200 07/01/2015 Jul TML Ins & Workers Comp 36,921.34 4,063.01 40,984.35 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,063.01 40,984.35 ** 48,751.00 Budgeted 7,766.65 Remaining 84 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 46 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-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 1871 07/31/2015 PCards 06/27/15 - 07/27/15 TEXAS MUNICIPAL LEAGUE 4,334.95 80.00 4,414.95 TEXAS MUNICIPAL LEAGUE PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 TEXAS MUNICIPAL LEAGUE 143.00 4,557.95 TEXAS MUNICIPAL LEAGUE PC _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 223.00 4,557.95 ** 6,000.00 Budgeted 1,442.05 Remaining 76 % Used Account: 135-60075-030-000 Meetings 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 1677 07/03/2015 MUD Payroll 7/3/15 Travel & per diem 1,545.79 15.53 1,561.32 PR 1775 07/17/2015 MUD Payroll 7/17/15 Travel & per diem 30.99 1,592.31 PR 1828 07/31/2015 Payroll 07-31-15 Travel & per diem 43.24 1,635.55 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 89.76 1,635.55 ** 5,400.00 Budgeted 3,764.45 Remaining 30 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 47 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 5,630.53 .00 5,630.53 _______________ Account: 135-60125-030-000 Advertising Totals: .00 5,630.53 ** 2,500.00 Budgeted (3,130.53) Remaining 225 % 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 1857 07/31/2015 July A/P Backyard work - sewer 6,088.20 1,000.00 7,088.20 JOHN SNOW 35206 AP 1857 07/31/2015 July A/P Canon Check Scanner 2,586.54 9,674.74 CDW GOVERNMENT, INC 35201 AP 1871 07/31/2015 PCards 06/27/15 - 07/27/15 VCN*DENTONRECCTR 48.50 9,723.24 VCN*DENTONRECCTR PC 1909 07/31/2015 July A/P Ink tank for scanner 23.21 9,746.45 CDW GOVERNMENT, INC 35220 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 3,658.25 9,746.45 ** 17,500.00 Budgeted 7,753.55 Remaining 56 % Used Account: 135-60270-030-000 4th of July Celebration 1824 07/27/2015 July A/P July 4th Fireworks 10,000.00 10,000.00 TOWN OF TROPHY CLUB 35197 AP _______________ Account: 135-60270-030-000 4th of July Celebration Totals: 10,000.00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 1788 07/16/2015 Texpool transfers O&M to Tax I&S(PID Utility) 14,000.00 14,000.00 GL _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: 14,000.00 14,000.00 ** 14,000.00 Budgeted .00 Remaining 100 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 48 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60360-030-000 Furniture/Equipment < $5000 5,035.96 .00 5,035.96 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 5,035.96 ** 10,475.00 Budgeted 5,439.04 Remaining 48 % Used Account: 135-65010-030-000 Uniforms 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 34,203.27 .00 34,203.27 _______________ Account: 135-65055-030-000 Hardware Totals: .00 34,203.27 ** 35,226.00 Budgeted 1,022.73 Remaining 97 % Used Account: 135-65085-030-000 Office Supplies 1871 07/31/2015 PCards 06/27/15 - 07/27/15 CARTOONSTOC 5,970.35 11.00 5,981.35 CARTOONSTOC PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 WM SUPERCENTER #5247 34.78 6,016.13 WM SUPERCENTER #5247 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 OFFICE DEPOT #406 45.99 6,062.12 OFFICE DEPOT #406 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 DESKTOP SUPPLIES.COM 203.68 6,265.80 DESKTOP SUPPLIES.COM PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 AMAZON MKTPLACE PMTS 25.47 6,291.27 AMAZON MKTPLACE PMTS PC 1909 07/31/2015 July A/P Office supplies 129.36 6,420.63 OFFICE DEPOT, INC 35233 AP 1909 07/31/2015 July A/P Office Supplies 111.80 6,532.43 OFFICE DEPOT, INC 35233 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 562.08 6,532.43 ** 9,000.00 Budgeted 2,467.57 Remaining 73 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SHI GOVERNMENT SOLUTIO 2,729.60 (277.80) 2,451.80 SHI GOVERNMENT SOLUTIO PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SHI GOVERNMENT SOLUTIO 103.00 2,554.80 SHI GOVERNMENT SOLUTIO PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SHI GOVERNMENT SOLUTIO 206.00 2,760.80 SHI GOVERNMENT SOLUTIO PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 31.20 2,760.80 ** 4,732.00 Budgeted 1,971.20 Remaining 58 % Used Account: 135-65095-030-000 Maintenance Supplies . glpdatb2 tsisk Trophy Club MUD #1 Page 49 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1871 07/31/2015 PCards 06/27/15 - 07/27/15 WM SUPERCENTER #5247 3,271.57 38.76 3,310.33 WM SUPERCENTER #5247 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SAMS CLUB #4795 36.12 3,346.45 SAMS CLUB #4795 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SAMSCLUB #4795 77.38 3,423.83 SAMSCLUB #4795 PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 AMAZON MKTPLACE PMTS 58.57 3,482.40 AMAZON MKTPLACE PMTS PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 AMAZON.COM 12.00 3,494.40 AMAZON.COM PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 AMAZON MKTPLACE PMTS 36.19 3,530.59 AMAZON MKTPLACE PMTS PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 AMAZON MKTPLACE PMTS 55.80 3,586.39 AMAZON MKTPLACE PMTS PC 1871 07/31/2015 PCards 06/27/15 - 07/27/15 SAMS CLUB #4795 118.72 3,705.11 SAMS CLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 433.54 3,705.11 ** 5,000.00 Budgeted 1,294.89 Remaining 74 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65105-030-000 Printing 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 3,027.41 .00 3,027.41 _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: .00 3,027.41 ** 4,236.00 Budgeted 1,208.59 Remaining 71 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 .00 16,329.00 . glpdatb2 tsisk Trophy Club MUD #1 Page 50 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 16,329.00 ** 16,329.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 1,012,321.87 ** 1,277,987.00 Budgeted 265,665.13 Remaining 79 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 51 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/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 1790 07/17/2015 July A/P Balance due May 433,588.32 2,100.00 435,688.32 THE LISTON LAW FIRM, P.C. 35171 AP 1815 07/23/2015 July A/P Legal 308.10 435,996.42 WHITAKER CHALK SWINDLE 35191 AP 1815 07/23/2015 July A/P Legal 61.00 436,057.42 WHITAKER CHALK SWINDLE 35191 AP 1815 07/23/2015 July A/P Legal 152.50 436,209.92 WHITAKER CHALK SWINDLE 35191 AP 1872 07/31/2015 July A/P June Legal 4,304.75 440,514.67 THE LISTON LAW FIRM, P.C. 35214 AP 1909 07/31/2015 July A/P June deductibles 5,000.00 445,514.67 TML INTERGOVERNMENTAL RISK 35236 AP _______________ Account: 135-55045-039-000 Legal Totals: 11,926.35 445,514.67 ** 467,403.00 Budgeted 21,888.33 Remaining 95 % 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: ------------------------------------------------------------------------------------------------ 472,771.23 ** 503,694.00 Budgeted 30,922.77 Remaining 94 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (1,063,675.12) .00 Budgeted 1,063,675.12 Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 57 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/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 tsisk Trophy Club MUD #1 Page 58 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 7/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 tsisk Trophy Club MUD #1 Page 59 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 7/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 tsisk Trophy Club MUD #1 Page 60 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 7/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 1924 07/31/2015 Bank Interest/July (9.50) (1.17) (10.67) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (1.17) (10.67) ** .00 Budgeted 10.67 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (10.67) ** .00 Budgeted 10.67 Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 61 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 7/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,239.33 3,348.00 Budgeted 1,108.67 Remaining 67 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET JULY 2015 517 ASSETS TAX BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 4,377,991 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,377,991 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 4,377,991 TOTAL FUND BALANCE 4,377,991 TOTAL LIABILITIES AND FUND BALANCE 4,377,991 . glbase_tsam tsisk Trophy Club MUD #1 Page 24 08:50 08/13/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 234.14- 1,406.88- 1,406.88 517-49105-000-000 Bond Proceeds 5,765,000.00- 5,765,000.00 Subtotal: 234.14- 5,766,406.88- 5,766,406.88 Program number: 234.14- 5,766,406.88- 5,766,406.88 Department number: Revenues 234.14- 5,766,406.88- 5,766,406.88 Revenues Subtotal ----------- 234.14- 5,766,406.88- 5,766,406.88 . glbase_tsam tsisk Trophy Club MUD #1 Page 25 08:50 08/13/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 7/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- 517-69005-020-000 Capital Outlays 151,502.50 151,502.50- Subtotal: 1,240,216.21 1,240,216.21- 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 234.14- 4,377,990.67- 4,377,990.67 . glpdatb2 tsisk Trophy Club MUD #1 Page 62 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/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 1924 07/31/2015 Bank Interest/July (1,172.74) (234.14) (1,406.88) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (234.14) (1,406.88) ** .00 Budgeted 1,406.88 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,406.88) ** .00 Budgeted 5,766,406.88 Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 63 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 7/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,377,990.67) .00 Budgeted 4,377,990.67 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET JULY 2015 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 8,957,759 ACCOUNTS RECEIVABLE 570 TOTAL ASSETS 8,958,329 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 8,958,329 TOTAL FUND BALANCE 8,958,329 TOTAL LIABILITIES AND FUND BALANCE 8,958,329 . glbase_tsam tsisk Trophy Club MUD #1 Page 26 08:50 08/13/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 7/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 479.90- 2,215.33- 2,215.33 518-49105-000-000 Bond Proceeds 9,230,000.00- 9,230,000.00 Subtotal: 479.90- 9,232,215.33- 9,232,215.33 Program number: 479.90- 9,232,215.33- 9,232,215.33 Department number: Revenues 479.90- 9,232,215.33- 9,232,215.33 Revenues Subtotal ----------- 479.90- 9,232,215.33- 9,232,215.33 . glbase_tsam tsisk Trophy Club MUD #1 Page 27 08:50 08/13/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 7/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- 518-69005-020-000 Capital Outlays 15,656.00 59,938.50 59,938.50- Subtotal: 15,656.00 83,616.95 83,616.95- 518-70020-020-000 Bond Issuance Costs 190,269.00 190,269.00- Subtotal: 190,269.00 190,269.00- Program number: 15,656.00 273,885.95 273,885.95- Department number: Wastewater 15,656.00 273,885.95 273,885.95- Expenditures Subtotal ----------- 15,656.00 273,885.95 273,885.95- Fund number: 518 2015 Revenue Bond Const Fund 15,176.10 8,958,329.38- 8,958,329.38 . glpdatb2 tsisk Trophy Club MUD #1 Page 64 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 7/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 1924 07/31/2015 Bank Interest/July (1,735.43) (479.90) (2,215.33) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (479.90) (2,215.33) ** .00 Budgeted 2,215.33 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,215.33) ** .00 Budgeted 9,232,215.33 Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 65 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 7/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 1815 07/23/2015 July A/P WWTP Improvements 44,282.50 15,656.00 59,938.50 THE WALLACE GROUP, INC. 35189 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 15,656.00 59,938.50 ** .00 Budgeted (59,938.50) 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: ------------------------------------------------------------------------------------------------ 273,885.95 ** .00 Budgeted (273,885.95) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ (8,958,329.38) .00 Budgeted 8,958,329.38 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JULY 2015 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 51,397 ACCOUNTS RECEIVABLE - TOTAL ASSETS 51,397 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 51,397 TOTAL FUND BALANCE 51,397 TOTAL LIABILITIES AND FUND BALANCE 51,397 . glbase_tsam tsisk Trophy Club MUD #1 Page 28 08:50 08/13/15 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 2.72- 7.31- 7.31 528-49141-000-000 Interfund Transfer In-Gen Fund 71,946.00- 10,278.00- 51,390.00- 71.429 20,556.00- Subtotal: 71,946.00- 10,280.72- 51,397.31- 71.439 20,548.69- Program number: 71,946.00- 10,280.72- 51,397.31- 71.439 20,548.69- Department number: 71,946.00- 10,280.72- 51,397.31- 71.439 20,548.69- Revenues Subtotal ----------- 71,946.00- 10,280.72- 51,397.31- 71.439 20,548.69- Fund number: 528 2015 Revenue Bond Reserve Fund 71,946.00- 10,280.72- 51,397.31- 71.439 20,548.69- . glpdatb2 tsisk Trophy Club MUD #1 Page 66 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/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 1924 07/31/2015 Bank Interest/July (4.59) (2.72) (7.31) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (2.72) (7.31) ** .00 Budgeted 7.31 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 1743 07/01/2015 Rev Bond Reserve Mo. payment (41,112.00) (10,278.00) (51,390.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (10,278.00) (51,390.00) ** (71,946.00) Budgeted (20,556.00) Remaining 71 % Used Department Totals: ------------------------------------------------------------------------------------------------ (51,397.31) ** (71,946.00) Budgeted (20,548.69) Remaining 71 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (51,397.31) (71,946.00) Budgeted (20,548.69) Remaining 71 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JULY 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 652,512 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 12,072 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 669,430 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 12,072 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 12,072 FUND BALANCE ASSIGNED FUND BALANCE 14,753 NET REVENUES / EXPENDITURES 642,606 TOTAL FUND BALANCE 657,358 TOTAL LIABILITIES AND FUND BALANCE 669,430 . glbase_tsam tsisk Trophy Club MUD #1 Page 29 08:50 08/13/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/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- 1,216.36- 464,702.90- 99.718 1,316.10- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 61.08- 1,810.90- 72.436 689.10- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 23.91- 1,689.39- 105.587 89.39 533-48005-000-000 Reserve Funds/PID Utility Fees 100,000.00- 14,000.00- 14,000.00- 14,000.00- 100.000 533-48015-000-000 WW Sales Rev Trnsf for Debt 357,538.00- 533-49010-000-000 Interest Income 375.00- 375.00- 33.73- 3,474.47- 926.525 3,099.47 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- 30,645.00- 46.962 34,610.00- Subtotal: 1,139,861.00- 761,578.00- 45,980.08- 733,109.56- 96.262 28,468.44- Program number: 1,139,861.00- 761,578.00- 45,980.08- 733,109.56- 96.262 28,468.44- Department number: Revenues 1,139,861.00- 761,578.00- 45,980.08- 733,109.56- 96.262 28,468.44- Revenues Subtotal ----------- 1,139,861.00- 761,578.00- 45,980.08- 733,109.56- 96.262 28,468.44- . glbase_tsam tsisk Trophy Club MUD #1 Page 30 08:50 08/13/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/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 89,253.75 31.429 194,730.25 533-70035-051-000 Bond Principal Payment-Tax 440,000.00 440,000.00 440,000.00 533-70040-051-000 Bond Interest Expense-Revenue 292,283.00 Subtotal: 1,137,936.00 726,534.00 90,503.75 12.457 636,030.25 Program number: 1,137,936.00 726,534.00 90,503.75 12.457 636,030.25 Department number: Administration 1,137,936.00 726,534.00 90,503.75 12.457 636,030.25 Expenditures Subtotal ----------- 1,137,936.00 726,534.00 90,503.75 12.457 636,030.25 Fund number: 533 MUD 1 I&S Consolidated 1,925.00- 35,044.00- 45,980.08- 642,605.81- 1,833.711 607,561.81 . glpdatb2 tsisk Trophy Club MUD #1 Page 67 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/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 1886 07/01/2015 Property Taxes/Assessments (463,486.54) (4.22) (463,490.76) GL 1892 07/06/2015 Property Taxes/Assessments 11.46 (463,479.30) GL 1893 07/10/2015 Property Taxes/Assessments (41.94) (463,521.24) GL 1894 07/13/2015 Property Taxes/Assessments (107.69) (463,628.93) GL 1895 07/14/2015 Property Taxes/Assessments (82.30) (463,711.23) GL 1896 07/15/2015 Property Taxes/Assessments (93.04) (463,804.27) GL 1898 07/16/2015 Property Taxes/Assessments (93.37) (463,897.64) GL 1899 07/20/2015 Property Taxes/Assessments (90.11) (463,987.75) GL 1900 07/21/2015 Property Taxes/Assessments (16.70) (464,004.45) GL 1901 07/22/2015 Property Taxes/Assessments (115.01) (464,119.46) GL 1902 07/23/2015 Property Taxes/Assessments (13.76) (464,133.22) GL 1903 07/24/2015 Property Taxes/Assessments (42.32) (464,175.54) GL 1904 07/27/2015 Property Taxes/Assessments (169.85) (464,345.39) GL 1905 07/29/2015 Property Taxes/Assessments (40.07) (464,385.46) GL 1906 07/30/2015 Property Taxes/Assessments (145.77) (464,531.23) GL 1907 07/31/2015 Property Taxes/Assessments (171.67) (464,702.90) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,216.36) (464,702.90) ** (466,019.00) Budgeted (1,316.10) Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1907 07/31/2015 Property Taxes/Assessments (1,749.82) (61.08) (1,810.90) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (61.08) (1,810.90) ** (2,500.00) Budgeted (689.10) Remaining 72 % Used Account: 533-40015-000-000 Property Taxes/P & I 1886 07/01/2015 Property Taxes/Assessments (1,665.48) (.59) (1,666.07) GL 1892 07/06/2015 Property Taxes/Assessments (1.47) (1,667.54) GL 1895 07/14/2015 Property Taxes/Assessments (2.47) (1,670.01) GL 1901 07/22/2015 Property Taxes/Assessments (.03) (1,670.04) GL 1905 07/29/2015 Property Taxes/Assessments (1.00) (1,671.04) GL 1906 07/30/2015 Property Taxes/Assessments (8.10) (1,679.14) GL 1907 07/31/2015 Property Taxes/Assessments (10.25) (1,689.39) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (23.91) (1,689.39) ** (1,600.00) Budgeted 89.39 Remaining 106 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees . glpdatb2 tsisk Trophy Club MUD #1 Page 68 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1788 07/16/2015 Texpool transfers O&M to Tax I&S(PID Utility) (14,000.00) (14,000.00) GL _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: (14,000.00) (14,000.00) ** (14,000.00) Budgeted .00 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 1924 07/31/2015 Bank Interest/July (3,440.74) (33.73) (3,474.47) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (33.73) (3,474.47) ** (375.00) Budgeted 3,099.47 Remaining 927 % 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 1788 07/16/2015 Texpool transfers O&M to Tax I&S(PID Surcharge) (30,645.00) (30,645.00) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (30,645.00) (30,645.00) ** (65,255.00) Budgeted (34,610.00) Remaining 47 % Used Department Totals: ------------------------------------------------------------------------------------------------ (733,109.56) ** (761,578.00) Budgeted (28,468.44) Remaining 96 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 69 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/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 89,253.75 .00 89,253.75 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 89,253.75 ** 283,984.00 Budgeted 194,730.25 Remaining 31 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 440,000.00 Budgeted 440,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 90,503.75 ** 726,534.00 Budgeted 636,030.25 Remaining 12 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (642,605.81) (35,044.00) Budgeted 607,561.81 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JULY 2015 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 152,049 ACCOUNTS RECEIVABLE - TOTAL ASSETS 152,049 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 152,049 TOTAL FUND BALANCE 152,049 TOTAL LIABILITIES AND FUND BALANCE 152,049 . glbase_tsam tsisk Trophy Club MUD #1 Page 31 08:50 08/13/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 7/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 4.69- 10,444.59- 10,444.59 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- 136,989.00- 100.000 Subtotal: 136,989.00- 136,993.69- 152,048.59- 110.993 15,059.59 Program number: 136,989.00- 136,993.69- 152,048.59- 110.993 15,059.59 Department number: Revenues 136,989.00- 136,993.69- 152,048.59- 110.993 15,059.59 Revenues Subtotal ----------- 136,989.00- 136,993.69- 152,048.59- 110.993 15,059.59 . glbase_tsam tsisk Trophy Club MUD #1 Page 32 08:50 08/13/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 7/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,989.00 Subtotal: 136,989.00 136,989.00 Program number: 136,989.00 136,989.00 Department number: Administration 136,989.00 136,989.00 Expenditures Subtotal ----------- 136,989.00 136,989.00 Fund number: 534 2015 Revenue Bond I&S 136,993.69- 152,048.59- 152,048.59 ******* End of Report ********* . glpdatb2 tsisk Trophy Club MUD #1 Page 70 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 7/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 1924 07/31/2015 Bank Interest/July (10,439.90) (4.69) (10,444.59) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (4.69) (10,444.59) ** .00 Budgeted 10,444.59 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 1788 07/16/2015 Texpool transfers O&M to Revenue Bond I&S (136,989.00) (136,989.00) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (136,989.00) (136,989.00) ** (136,989.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (152,048.59) ** (136,989.00) Budgeted 15,059.59 Remaining 111 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 71 08:50 08/13/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 7/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 136,989.00 Budgeted 136,989.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 136,989.00 Budgeted 136,989.00 Remaining 0 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (152,048.59) .00 Budgeted 152,048.59 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (15,298,428.55) **** (103,642.00) Budgeted 15,194,786.55 Remaining ########## ******* End of Report *********