Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Sept Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER 2014 122 ASSETS FIRE DEPT. INVESTMENTS 578,250 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 17,458 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 8,402 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,108 TOTAL ASSETS 606,219 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 25,861 ACCOUNTS AND OTHER PAYABLES 50,425 TOTAL LIABILITIES 76,286 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 495,688 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 34,246 TOTAL FUND BALANCE 529,934 TOTAL LIABILITIES AND FUND BALANCE 606,219 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 09:30 10/15/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 305,445.00- 305,445.00- 47.80- 309,800.59- 101.426 4,355.59 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1,581.21- 1,581.21 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 601.60- 921,999.74- 99.401 5,555.26- 122-40011-000-000 Property Taxes/Fire-Delinquent 1,346.42- 1,346.42 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 7.20- 745.78- 99.437 4.22- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 198.63- 5,606.06- 124.579 1,106.06 Subtotal: 1,238,250.00- 1,238,250.00- 855.23- 1,241,079.80- 100.229 2,829.80 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 5,600.00- 93.333 400.00- Subtotal: 6,000.00- 6,000.00- 400.00- 5,600.00- 93.333 400.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 75.00- 975.00- 139.286 275.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,700.00- 10,700.00- 75.00- 10,975.00- 102.570 275.00 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 2,100.00- 10,355.00- 172.583 4,355.00 Subtotal: 6,000.00- 6,000.00- 2,100.00- 10,355.00- 172.583 4,355.00 Program number: 1,260,950.00- 1,260,950.00- 3,430.23- 1,268,009.80- 100.560 7,059.80 Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 3,430.23- 1,268,009.80- 100.560 7,059.80 Revenues Subtotal -------- 1,260,950.00- 1,260,950.00- 3,430.23- 1,268,009.80- 100.560 7,059.80 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 09:30 10/15/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 455,916.00 455,916.00 48,256.88 464,087.26 101.792 8,171.26- 122-50010-045-000 Overtime 44,225.00 44,225.00 2,794.17 40,195.48 90.889 4,029.52 122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,289.86 98.232 239.14 122-50016-045-000 Longevity 4,768.00 4,768.00 4,655.00 97.630 113.00 122-50017-045-000 Certification 4,350.00 4,350.00 731.00 4,895.39 112.538 545.39- 122-50020-045-000 Retirement 70,991.00 70,991.00 7,464.83 75,238.86 105.984 4,247.86- 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 6,339.92 52,431.00 92.036 4,537.00 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 488.85 4,250.58 100.487 20.58- 122-50028-045-000 Vision Insurance 892.00 892.00 93.29 856.60 96.031 35.40 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 445.38 3,947.40 92.880 302.60 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 2,915.76 30,166.83 91.470 2,813.17 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 681.68 7,053.22 91.446 659.78 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 14.91 1,648.88 72.992 610.12 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.78 7,953.42 91.335 754.58 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 205.72 41.144 294.28 122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 70,889.45 710,875.50 99.719 2,003.50 122-55030-045-000 Software & Support 8,682.00 6,834.00 462.50 925.00 13.535 5,909.00 122-55045-045-000 Legal 5,000.00 3,391.00 2,505.51- -73.887 5,896.51 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 940.83 17,426.26 85.122 3,045.74 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 1,936.01 13,644.05 91.879 1,205.95 Subtotal: 49,004.00 45,547.00 3,339.34 29,489.80 64.746 16,057.20 122-60005-045-000 Telephone 100.00 100.00 11.47 43.44 43.440 56.56 122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 329.15 4,201.97 99.173 35.03 122-60020-045-000 Electricity/Gas 6,568.00 9,268.00 658.10 7,084.55 76.441 2,183.45 122-60025-045-000 Water 1,500.00 1,500.00 138.22 1,148.59 76.573 351.41 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 100.000 122-60035-045-000 Postage 100.00 100.00 15.38 68.89 68.890 31.11 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 12,153.00 100.355 43.00- 122-60066-045-000 Publications/Books/Subscrips 400.00 400.00 112.75 28.188 287.25 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 16,086.64 105.973 906.64- 122-60080-045-000 Schools & Training 4,280.00 4,280.00 100.00 4,752.01 111.028 472.01- 122-60096-045-000 Emergency Management 2,000.00 2,000.00 188.85 1,797.55 89.878 202.45 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 2,990.18 65.331 1,586.82 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 1,535.00 1,535.00 76.750 465.00 122-60125-045-000 Advertising 200.00 200.00 200.00- 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 2,686.53 59.701 1,813.47 122-60180-045-000 Fire Inspection/Enforcement 1,500.00 1,500.00 632.45 42.163 867.55 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 85.00 1,672.12 83.606 327.88 122-60243-045-000 Prior Year Expense 3,457.00 3,456.54 99.987 .46 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 09:30 10/15/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 8.99 866.89 86.689 133.11 Subtotal: 276,531.00 282,488.00 4,079.41 275,768.10 97.621 6,719.90 122-65005-045-000 Fuel & Lube 11,698.00 10,198.00 572.91 8,386.19 82.234 1,811.81 122-65010-045-000 Uniforms 3,360.00 3,360.00 172.63 3,274.37 97.451 85.63 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 706.50 8,529.27 112.227 929.27- 122-65030-045-000 Chemicals 1,000.00 500.00 420.00 84.000 80.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 2,330.00 3,035.21 121.408 535.21- 122-65085-045-000 Office Supplies 1,000.00 500.00 233.22 46.644 266.78 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 24,758.00 3,782.04 23,878.26 96.447 879.74 122-69008-045-000 Short Term Debt-Principal 70,000.00 70,000.00 70,000.00 100.000 122-69009-045-000 Short Term Debt-Interest 3,031.00 3,031.00 3,031.00 100.000 122-69050-045-000 Radios 34,200.00 34,200.00 32,693.40 95.595 1,506.60 122-69195-045-000 GASB34/Reserve for Replacement 67,647.00 67,647.00 25,757.00 67,647.00 100.000 122-69255-045-000 Airpacks 20,400.00 20,400.00 415.25 20,380.84 99.906 19.16 Subtotal: 195,278.00 195,278.00 26,172.25 193,752.24 99.219 1,525.76 Program number: 1,260,950.00 1,260,950.00 108,262.49 1,233,763.90 97.844 27,186.10 Department number: Fire 1,260,950.00 1,260,950.00 108,262.49 1,233,763.90 97.844 27,186.10 Expenditures Subtotal -------- 1,260,950.00 1,260,950.00 108,262.49 1,233,763.90 97.844 27,186.10 Fund number: 122 Trophy Club MUD Fire Dept. 104,832.26 34,245.90- 34,245.90 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 2185 09/09/2014 Property Taxes/Assessments (309,752.79) (23.49) (309,776.28) GL 2188 09/26/2014 Property Taxes/Assessments (.82) (309,777.10) GL 2190 09/30/2014 Property Taxes/Assessments (23.49) (309,800.59) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (47.80) (309,800.59) ** (305,445.00) Budgeted 4,355.59 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (1,581.21) .00 (1,581.21) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (1,581.21) ** .00 Budgeted 1,581.21 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 2181 09/02/2014 Property Taxes/Assessments (921,398.14) (27.52) (921,425.66) GL 2182 09/04/2014 Property Taxes/Assessments (35.63) (921,461.29) GL 2184 09/08/2014 Property Taxes/Assessments (93.21) (921,554.50) GL 2186 09/12/2014 Property Taxes/Assessments (98.97) (921,653.47) GL 2187 09/16/2014 Property Taxes/Assessments (335.01) (921,988.48) GL 2188 09/26/2014 Property Taxes/Assessments (.78) (921,989.26) GL 2189 09/29/2014 Property Taxes/Assessments (10.48) (921,999.74) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (601.60) (921,999.74) ** (927,555.00) Budgeted (5,555.26) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent (1,346.42) .00 (1,346.42) _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: .00 (1,346.42) ** .00 Budgeted 1,346.42 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 2185 09/09/2014 Property Taxes/Assessments (738.58) (3.52) (742.10) GL 2188 09/26/2014 Property Taxes/Assessments (.16) (742.26) GL 2190 09/30/2014 Property Taxes/Assessments (3.52) (745.78) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (7.20) (745.78) ** (750.00) Budgeted (4.22) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40020-000-000 Property Taxes/Fire P&I 2181 09/02/2014 Property Taxes/Assessments (5,407.43) (5.22) (5,412.65) GL 2182 09/04/2014 Property Taxes/Assessments (2.48) (5,415.13) GL 2183 09/05/2014 Property Taxes/Assessments (104.09) (5,519.22) GL 2184 09/08/2014 Property Taxes/Assessments (17.60) (5,536.82) GL 2187 09/16/2014 Property Taxes/Assessments (66.99) (5,603.81) GL 2188 09/26/2014 Property Taxes/Assessments (.15) (5,603.96) GL 2189 09/29/2014 Property Taxes/Assessments (2.10) (5,606.06) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (198.63) (5,606.06) ** (4,500.00) Budgeted 1,106.06 Remaining 125 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (5,200.00) (400.00) (5,600.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (5,600.00) ** (6,000.00) Budgeted (400.00) Remaining 93 % Used Account: 122-43400-000-000 Fire Inspections 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (900.00) (75.00) (975.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (975.00) ** (700.00) Budgeted 275.00 Remaining 139 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49900-000-000 Miscellaneous Income 2144 09/18/2014 Atmos-Fire Grant For gas detector (8,255.00) (1,300.00) (9,555.00) GL 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (800.00) (10,355.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (2,100.00) (10,355.00) ** (6,000.00) Budgeted 4,355.00 Remaining 173 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,268,009.80) ** (1,260,950.00) Budgeted 7,059.80 Remaining 101 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 2106 09/12/2014 FD Payroll 9/12/14 415,830.38 17,417.68 433,248.06 GL 2195 09/26/2014 FD Payroll 9/26/14 18,204.98 451,453.04 GL 2205 09/30/2014 FD Accrued Payroll 12,634.22 464,087.26 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 48,256.88 464,087.26 ** 455,916.00 Budgeted (8,171.26) Remaining 102 % Used Account: 122-50010-045-000 Overtime 2106 09/12/2014 FD Payroll 9/12/14 37,401.31 57.19 37,458.50 GL 2195 09/26/2014 FD Payroll 9/26/14 2,736.98 40,195.48 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,794.17 40,195.48 ** 44,225.00 Budgeted 4,029.52 Remaining 91 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,289.86 .00 13,289.86 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,289.86 ** 13,529.00 Budgeted 239.14 Remaining 98 % Used Account: 122-50016-045-000 Longevity 4,655.00 .00 4,655.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,655.00 ** 4,768.00 Budgeted 113.00 Remaining 98 % Used Account: 122-50017-045-000 Certification 2106 09/12/2014 FD Payroll 9/12/14 4,164.39 425.00 4,589.39 GL 2205 09/30/2014 FD Accrued Payroll 306.00 4,895.39 GL _______________ Account: 122-50017-045-000 Certification Totals: 731.00 4,895.39 ** 4,350.00 Budgeted (545.39) Remaining 113 % Used Account: 122-50020-045-000 Retirement 2106 09/12/2014 FD Payroll 9/12/14 67,774.03 2,611.20 70,385.23 GL 2195 09/26/2014 FD Payroll 9/26/14 2,971.17 73,356.40 GL 2205 09/30/2014 FD Accrued Payroll 1,882.46 75,238.86 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50020-045-000 Retirement Totals: 7,464.83 75,238.86 ** 70,991.00 Budgeted (4,247.86) Remaining 106 % Used Account: 122-50026-045-000 Medical Insurance 2106 09/12/2014 FD Payroll 9/12/14 46,091.08 2,488.46 48,579.54 GL 2195 09/26/2014 FD Payroll 9/26/14 1,827.91 50,407.45 GL 2205 09/30/2014 FD Accrued Payroll 2,023.55 52,431.00 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 6,339.92 52,431.00 ** 56,968.00 Budgeted 4,537.00 Remaining 92 % Used Account: 122-50027-045-000 Dental Insurance 2106 09/12/2014 FD Payroll 9/12/14 3,761.73 176.39 3,938.12 GL 2195 09/26/2014 FD Payroll 9/26/14 176.40 4,114.52 GL 2205 09/30/2014 FD Accrued Payroll 136.06 4,250.58 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 488.85 4,250.58 ** 4,230.00 Budgeted (20.58) Remaining 100 % Used Account: 122-50028-045-000 Vision Insurance 2106 09/12/2014 FD Payroll 9/12/14 763.31 34.74 798.05 GL 2195 09/26/2014 FD Payroll 9/26/14 34.74 832.79 GL 2205 09/30/2014 FD Accrued Payroll 23.81 856.60 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 93.29 856.60 ** 892.00 Budgeted 35.40 Remaining 96 % Used Account: 122-50029-045-000 Life Insurance & Other 2106 09/12/2014 FD Payroll 9/12/14 3,502.02 163.23 3,665.25 GL 2195 09/26/2014 FD Payroll 9/26/14 163.26 3,828.51 GL 2205 09/30/2014 FD Accrued Payroll 118.89 3,947.40 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 445.38 3,947.40 ** 4,250.00 Budgeted 302.60 Remaining 93 % Used Account: 122-50030-045-000 Social Security Taxes 2106 09/12/2014 FD Payroll 9/12/14 27,251.07 1,001.46 28,252.53 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2195 09/26/2014 FD Payroll 9/26/14 27,251.07 1,192.41 29,444.94 GL 2205 09/30/2014 FD Accrued Payroll 721.89 30,166.83 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,915.76 30,166.83 ** 32,980.00 Budgeted 2,813.17 Remaining 91 % Used Account: 122-50035-045-000 Medicare Taxes 2106 09/12/2014 FD Payroll 9/12/14 6,371.54 234.16 6,605.70 GL 2195 09/26/2014 FD Payroll 9/26/14 278.78 6,884.48 GL 2205 09/30/2014 FD Accrued Payroll 168.74 7,053.22 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 681.68 7,053.22 ** 7,713.00 Budgeted 659.78 Remaining 91 % Used Account: 122-50040-045-000 Unemployment Taxes 2106 09/12/2014 FD Payroll 9/12/14 1,633.97 2.54 1,636.51 GL 2195 09/26/2014 FD Payroll 9/26/14 12.37 1,648.88 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 14.91 1,648.88 ** 2,259.00 Budgeted 610.12 Remaining 73 % Used Account: 122-50045-045-000 Workman's Compensation 127 09/01/2014 FD Sep W/C expense 7,290.64 662.78 7,953.42 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.78 7,953.42 ** 8,708.00 Budgeted 754.58 Remaining 91 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 205.72 .00 205.72 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 205.72 ** 500.00 Budgeted 294.28 Remaining 41 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55030-045-000 Software & Support 2120 09/19/2014 Sept A/P Charter, Gexa, Verizon 462.50 462.50 925.00 TOWN OF TROPHY CLUB 34197 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 925.00 ** 6,834.00 Budgeted 5,909.00 Remaining 14 % Used Account: 122-55045-045-000 Legal (2,505.51) .00 (2,505.51) _______________ Account: 122-55045-045-000 Legal Totals: .00 (2,505.51) ** 3,391.00 Budgeted 5,896.51 Remaining -74 % Used Account: 122-55080-045-000 Maintenance & Repairs 2142 09/18/2014 Firefighters Sept Cable 16,485.43 (133.82) 16,351.61 GL 2120 09/19/2014 Sept A/P Rug Service FD 24.51 16,376.12 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Rug Service FD 24.51 16,400.63 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Repair Vehicle charger on E681 314.30 16,714.93 Kussmaul Electronics Co., Inc. 34183 AP 2193 09/26/2014 8/27-9/26/14 PCards BATTERY UNIVERSE 158.10 16,873.03 BATTERY UNIVERSE PC 2193 09/26/2014 8/27-9/26/14 PCards ATT*BILL PAYMENT 128.82 17,001.85 ATT*BILL PAYMENT PC 2193 09/26/2014 8/27-9/26/14 PCards ATT*BILL PAYMENT 158.76 17,160.61 ATT*BILL PAYMENT PC 2193 09/26/2014 8/27-9/26/14 PCards SAMS CLUB #4795 277.90 17,438.51 SAMS CLUB #4795 PC 2204 09/30/2014 Sept A/P Rug Service 24.51 17,463.02 G & K SERVICES 34232 AP 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (36.76) 17,426.26 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 940.83 17,426.26 ** 20,472.00 Budgeted 3,045.74 Remaining 85 % Used Account: 122-55090-045-000 Vehicle Maintenance 2204 09/30/2014 Sept A/P PM-Quint 681 11,708.04 1,763.86 13,471.90 SIDDONS-MARTIN EMERGENCY GROUP 34256 AP 2204 09/30/2014 Sept A/P Oil, lube, Diesel additive, Fr 172.15 13,644.05 AutoZone 34220 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 1,936.01 13,644.05 ** 14,850.00 Budgeted 1,205.95 Remaining 92 % Used Account: 122-60005-045-000 Telephone 2204 09/30/2014 Sept A/P BOA PCards 31.97 5.74 37.71 TOWN OF TROPHY CLUB 34264 AP 2204 09/30/2014 Sept A/P BOA PCards 2/28-3/27, Credit 1 5.73 43.44 TOWN OF TROPHY CLUB 34264 AP _______________ Account: 122-60005-045-000 Telephone Totals: 11.47 43.44 ** 100.00 Budgeted 56.56 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60010-045-000 Communications/Pagers/Mobiles 2106 09/12/2014 FD Payroll 9/12/14 3,872.82 37.50 3,910.32 GL 2120 09/19/2014 Sept A/P Charter, Gexa, Verizon 237.65 4,147.97 TOWN OF TROPHY CLUB 34197 AP 2205 09/30/2014 FD Accrued Payroll 54.00 4,201.97 GL _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 329.15 4,201.97 ** 4,237.00 Budgeted 35.03 Remaining 99 % Used Account: 122-60020-045-000 Electricity/Gas 2120 09/19/2014 Sept A/P Electricity 8/13-9/12/14 6,426.45 1,242.76 7,669.21 HUDSON ENERGY SERVICES, LLC 34178 AP 2161 09/30/2014 Sept A/P Electricity 8/20-9/19/14 73.43 7,742.64 ATMOS ENERGY 34219 AP 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (658.09) 7,084.55 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 658.10 7,084.55 ** 9,268.00 Budgeted 2,183.45 Remaining 76 % Used Account: 122-60025-045-000 Water 2204 09/30/2014 Sept A/P UB Sept water 1,010.37 123.93 1,134.30 TROPHY CLUB MUD (WATER BILLS) 34266 AP 2204 09/30/2014 Sept A/P UB Sept water 152.51 1,286.81 TROPHY CLUB MUD (WATER BILLS) 34266 AP 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (138.22) 1,148.59 AR _______________ Account: 122-60025-045-000 Water Totals: 138.22 1,148.59 ** 1,500.00 Budgeted 351.41 Remaining 77 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,279.00 .00 214,279.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,279.00 ** 214,279.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 2120 09/19/2014 Sept A/P FD Repair to Kussmaul Electron 53.51 6.00 59.51 FEDERAL EXPRESS CORP 34171 AP 2206 09/30/2014 MUD Postage Meter usage/Sept 9.38 68.89 GL _______________ Account: 122-60035-045-000 Postage Totals: 15.38 68.89 ** 100.00 Budgeted 31.11 Remaining 69 % Used Account: 122-60055-045-000 Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 59 09/01/2014 Sep Ins & W/C Expense 11,143.75 1,009.25 12,153.00 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 12,153.00 ** 12,110.00 Budgeted (43.00) Remaining 100 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 112.75 .00 112.75 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 112.75 ** 400.00 Budgeted 287.25 Remaining 28 % Used Account: 122-60070-045-000 Dues & Memberships 16,086.64 .00 16,086.64 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 16,086.64 ** 15,180.00 Budgeted (906.64) Remaining 106 % Used Account: 122-60080-045-000 Schools & Training 2193 09/26/2014 8/27-9/26/14 PCards TRAININGDIVISION.COM 4,652.01 100.00 4,752.01 TRAININGDIVISION.COM PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 100.00 4,752.01 ** 4,280.00 Budgeted (472.01) Remaining 111 % Used Account: 122-60096-045-000 Emergency Management 2193 09/26/2014 8/27-9/26/14 PCards THE HOME DEPOT 6581 1,608.70 188.85 1,797.55 THE HOME DEPOT 6581 PC _______________ Account: 122-60096-045-000 Emergency Management Totals: 188.85 1,797.55 ** 2,000.00 Budgeted 202.45 Remaining 90 % Used Account: 122-60100-045-000 Travel & per diem 2,990.18 .00 2,990.18 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 2,990.18 ** 4,577.00 Budgeted 1,586.82 Remaining 65 % Used Account: 122-60110-045-000 Physicals/Testing 2120 09/19/2014 Sept A/P Hazmat Physicals for Staff per 1,535.00 1,535.00 TEXAS HEALTH HUGULEY INC 34196 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60110-045-000 Physicals/Testing Totals: 1,535.00 1,535.00 ** 2,000.00 Budgeted 465.00 Remaining 77 % Used Account: 122-60125-045-000 Advertising 200.00 .00 200.00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 200.00 ** .00 Budgeted (200.00) Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 2,686.53 .00 2,686.53 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 2,686.53 ** 4,500.00 Budgeted 1,813.47 Remaining 60 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 632.45 .00 632.45 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 632.45 ** 1,500.00 Budgeted 867.55 Remaining 42 % Used Account: 122-60195-045-000 Flags & Repair 2066 09/09/2014 Sept A/P Symonds, SHI, Acclaim 1,587.12 85.00 1,672.12 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 85.00 1,672.12 ** 2,000.00 Budgeted 327.88 Remaining 84 % Used Account: 122-60243-045-000 Prior Year Expense 3,456.54 .00 3,456.54 _______________ Account: 122-60243-045-000 Prior Year Expense Totals: .00 3,456.54 ** 3,457.00 Budgeted .46 Remaining 100 % Used Account: 122-60245-045-000 Miscellaneous Expense 2193 09/26/2014 8/27-9/26/14 PCards H2C 857.90 8.99 866.89 H2C PC 2193 09/26/2014 8/27-9/26/14 PCards H2C (9.93) 856.96 H2C PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2193 09/26/2014 8/27-9/26/14 PCards H2C 857.90 9.93 866.89 H2C PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 8.99 866.89 ** 1,000.00 Budgeted 133.11 Remaining 87 % Used Account: 122-65005-045-000 Fuel & Lube 2207 09/30/2014 Sept MUD Gas log 7,813.28 572.91 8,386.19 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 572.91 8,386.19 ** 10,198.00 Budgeted 1,811.81 Remaining 82 % Used Account: 122-65010-045-000 Uniforms 2120 09/19/2014 Sept A/P 3 Shirts and Misc Uniform pins 3,101.74 172.63 3,274.37 GST PUBLIC SAFETY SUPPLY 34174 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 172.63 3,274.37 ** 3,360.00 Budgeted 85.63 Remaining 97 % Used Account: 122-65015-045-000 Protective Clothing 2120 09/19/2014 Sept A/P Replacement helmet due to expi 7,822.77 291.00 8,113.77 CASCO INDUSTRIES INC 34167 AP 2161 09/30/2014 Sept A/P Repair Protective clothing 415.50 8,529.27 Lion Apparel Inc. 34244 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 706.50 8,529.27 ** 7,600.00 Budgeted (929.27) Remaining 112 % Used Account: 122-65030-045-000 Chemicals 420.00 .00 420.00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 420.00 ** 500.00 Budgeted 80.00 Remaining 84 % Used Account: 122-65035-045-000 Small Tools 2120 09/19/2014 Sept A/P Gas Detector & Charger (Atmos 705.21 2,330.00 3,035.21 CASCO INDUSTRIES INC 34167 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 2,330.00 3,035.21 ** 2,500.00 Budgeted (535.21) Remaining 121 % Used Account: 122-65085-045-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 233.22 .00 233.22 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 233.22 ** 500.00 Budgeted 266.78 Remaining 47 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal 70,000.00 .00 70,000.00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 70,000.00 ** 70,000.00 Budgeted .00 Remaining 100 % Used Account: 122-69009-045-000 Short Term Debt-Interest 3,031.00 .00 3,031.00 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 3,031.00 ** 3,031.00 Budgeted .00 Remaining 100 % Used Account: 122-69050-045-000 Radios 32,693.40 .00 32,693.40 _______________ Account: 122-69050-045-000 Radios Totals: .00 32,693.40 ** 34,200.00 Budgeted 1,506.60 Remaining 96 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 2075 09/09/2014 Transfer-Fire Truck Reserve 41,890.00 25,757.00 67,647.00 GL _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 25,757.00 67,647.00 ** 67,647.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks 2161 09/30/2014 Sept A/P Airpaks, Replacement Voice amp 19,965.59 415.25 20,380.84 MUNICIPAL EMERGENCY SERVICES 34248 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69255-045-000 Airpacks Totals: 415.25 20,380.84 ** 20,400.00 Budgeted 19.16 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 1,233,763.90 ** 1,260,950.00 Budgeted 27,186.10 Remaining 98 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (34,245.90) .00 Budgeted 34,245.90 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET SEPTEMBER 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 9/30/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 587,297 - - 587,297 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,504,702 - - 1,504,702 INVESTMENTS-TEXPOOL 332,560 260,697 152,090 745,347 PREPAID EXPENSES 13,980 - - 13,980 ADVALOREM PROPERTY TAXES RECEIVABLE 2,191 - - 2,191 UTILITY AND OTHER ACCOUNTS RECEIVABLE 938,073 - - 938,073 - TOTAL ASSETS 3,379,401 260,697 152,090 3,792,188 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,191 - - 2,191 ACCOUNTS AND OTHER PAYABLES 594,735 - 141,822 736,557 CUSTOMER DEPOSITS 299,997 - - 299,997 - TOTAL LIABILITIES 896,923 - 141,822 1,038,745 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 313,050 313,050 NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 276,500 245,101 521,601 UNASSIGNED FUND BALANCE 2,708,490 - - 2,708,490 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (505,997) (52,353) (234,832) (793,183) - TOTAL FUND BALANCE 2,482,478 260,697 10,268 2,753,443 - TOTAL LIABILITIES AND FUND BALANCE 3,379,401 260,697 152,090 3,792,188 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,250.00- 99,250.00- 64.37- 98,700.79- 99.447 549.21- 135-40002-000-000 Property Taxes/Delinquent 129.78- 129.78 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 18.50- 591.91- 65.768 308.09- Subtotal: 100,150.00- 100,150.00- 82.87- 99,422.48- 99.274 727.52- 135-43215-000-000 Insurance Settlement 82.36- 82.36 Subtotal: 82.36- 82.36 135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 471,791.90- 3,375,404.18- 90.027 373,905.82- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 226,890.02- 2,071,635.68- 121.267 363,314.68 135-47025-000-000 Penalties 64,522.00- 64,522.00- 7,896.83- 62,916.96- 97.512 1,605.04- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 1,103.00- 9,986.00- 110.039 911.00 135-47035-000-000 Plumbing Inspections 1,200.00- 2,000.00- 100.00- 2,400.00- 120.000 400.00 135-47045-000-000 Sewer Inspections 4,400.00- 5,000.00- 300.00- 7,350.00- 147.000 2,350.00 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 16,592.10- 81,314.48- 102.172 1,728.48 Subtotal: 5,616,414.00- 5,617,814.00- 724,673.85- 5,611,007.30- 99.879 6,806.70- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 9,200.00- 331,200.00- 56.897 250,909.00- Subtotal: 582,109.00- 582,109.00- 9,200.00- 331,200.00- 56.897 250,909.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 523.13- 6,071.03- 126.480 1,271.03 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 10,926.36- 107.501 762.36 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.37- 7,000.00- 100.000 135-49030-000-000 Vending Revenue 350.00- 350.00- 226.85- 64.814 123.15- 135-49035-000-000 Prior Year Reserves 880,000.00- 880,000.00- 135-49036-000-000 GASB Reserves 8,964.00- 8,964.00- 8,964.00- 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 2,058.00- 77,379.80- 92.119 6,620.20- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- 24.94- 76,620.18- 2,554.006 73,620.18 135-49901-000-000 Records Management Revenue 100.00- 100.00- 53.39- 53.390 46.61- 135-49903-000-000 Recovery of Prior Year Expense 4,087.00- 4,087.00- 100.000 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 1,003,351.00- 4,099.97- 182,364.61- 18.176 820,986.39- Program number: 6,417,937.00- 7,303,424.00- 738,056.69- 6,224,076.75- 85.221 1,079,347.25- Department number: Revenues 6,417,937.00- 7,303,424.00- 738,056.69- 6,224,076.75- 85.221 1,079,347.25- Revenues Subtotal -------- 6,417,937.00- 7,303,424.00- 738,056.69- 6,224,076.75- 85.221 1,079,347.25- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 287,709.00 287,709.00 32,494.46 283,055.98 98.383 4,653.02 135-50010-010-000 Overtime 13,391.00 16,391.00 2,162.65 19,966.49 121.814 3,575.49- 135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 375.00 4,386.00 86.000 714.00 135-50020-010-000 Retirement 27,847.00 27,847.00 3,145.89 28,479.74 102.272 632.74- 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 4,576.31 41,516.78 85.896 6,817.22 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 323.41 2,996.86 76.217 935.14 135-50028-010-000 Vision Insurance 873.00 873.00 81.52 740.63 84.837 132.37 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 239.53 2,630.14 79.557 675.86 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 2,162.82 19,687.95 102.068 398.95- 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 505.80 4,604.43 102.071 93.43- 135-50040-010-000 Unemployment Taxes 54.00 1,244.00 1,244.44 100.035 .44- 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 9,629.40 97.969 199.60 135-50060-010-000 Pre-emp Physicals/Testing 200.00 350.00 359.90 102.829 9.90- 135-50070-010-000 Employee Relations 300.00 300.00 180.53 60.177 119.47 Subtotal: 429,580.00 433,920.00 46,869.84 424,384.27 97.802 9,535.73 135-55005-010-000 Engineering 3,000.00 6,000.00 6,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 61,000.00 833.13 58,478.71 95.867 2,521.29 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 382.44 4,971.81 99.436 28.19 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 2,500.00 2,251.65 2,499.98 99.999 .02 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 3,821.02 69.473 1,678.98 Subtotal: 67,000.00 80,000.00 3,467.22 69,771.52 87.214 10,228.48 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 324.00 4,535.41 92.314 377.59 135-60020-010-000 Electricity 162,160.00 155,160.00 21,241.03 147,667.50 95.171 7,492.50 135-60066-010-000 Publications/Books/Subscripts 500.00 2,538.00 2,715.66 107.000 177.66- 135-60070-010-000 Dues & Memberships 150.00 300.00 289.00 96.333 11.00 135-60080-010-000 Schools & Training 4,184.00 1,500.00 1,782.00 118.800 282.00- 135-60090-010-000 Safety Program 400.00 27.83 27.83- 135-60100-010-000 Travel & per diem 1,450.00 279.00 7.00 244.48 87.627 34.52 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 96.00 19.200 404.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 37,077.89 78.223 10,322.11 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 233,800.10 1,749,068.77 74.795 589,404.23 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 1,986.11 3,666.96 104.770 166.96- 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 2,000.00 1,664.20 83.210 335.80 Subtotal: 2,567,580.00 2,557,013.00 257,358.24 1,948,835.70 76.215 608,177.30 135-65005-010-000 Fuel & Lube 23,181.00 22,181.00 745.97 13,786.79 62.156 8,394.21 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,270.00 2,500.00 376.00 2,314.58 92.583 185.42 135-65030-010-000 Chemicals 5,000.00 5,000.00 1,123.43 9,040.45 180.809 4,040.45- 135-65035-010-000 Small Tools 1,200.00 1,200.00 588.00 49.000 612.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 359.06 703.61 70.361 296.39 135-65050-010-000 Meter Expense 143,550.00 143,550.00 33,770.00 125,505.04 87.429 18,044.96 Subtotal: 177,201.00 175,431.00 36,374.46 151,938.47 86.609 23,492.53 135-69005-010-000 Capital Outlays 37,000.00 35,681.00 35,679.59 99.996 1.41 135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 367,000.00 489,980.00 100.000 135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 7,735.40 19,356.66 100.460 88.66- 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 135-69280-010-000 Capital Repairs 7,500.00 135-69281-010-000 Water Tank Inspection Contract 106,847.00 100,847.00 6,029.82 106,846.36 105.949 5,999.36- Subtotal: 690,595.00 645,776.00 380,765.22 651,862.61 100.943 6,086.61- Program number: 3,931,956.00 3,892,140.00 724,834.98 3,246,792.57 83.419 645,347.43 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 1,000.00 2,000.00 80.00 3,359.87 167.994 1,359.87- Subtotal: 1,000.00 2,000.00 80.00 3,359.87 167.994 1,359.87- 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 2,496.19 49.924 2,503.81 Subtotal: 5,000.00 2,496.19 49.924 2,503.81 Program number: 1 Lab Analysis for PID 1,000.00 7,000.00 80.00 5,856.06 83.658 1,143.94 Department number: Water 3,932,956.00 3,899,140.00 724,914.98 3,252,648.63 83.420 646,491.37 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 202,894.00 202,894.00 23,466.85 202,992.11 100.048 98.11- 135-50010-020-000 Overtime 11,965.00 11,965.00 1,426.05 13,917.81 116.321 1,952.81- 135-50016-020-000 Longevity 2,998.00 2,998.00 2,997.50 99.983 .50 135-50017-020-000 Certification 4,800.00 4,800.00 400.00 4,800.00 100.000 135-50020-020-000 Retirement 19,905.00 19,905.00 2,271.32 20,647.10 103.728 742.10- 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 5,149.73 42,391.33 97.516 1,079.67 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 321.84 2,692.26 90.072 296.74 135-50028-020-000 Vision Insurance 658.00 658.00 77.63 637.50 96.884 20.50 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 191.45 2,212.16 96.056 90.84 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 1,354.98 12,556.99 90.960 1,248.01 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 316.90 2,936.72 90.948 292.28 135-50040-020-000 Unemployment Taxes 36.00 828.00 828.00 100.000 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 6,420.96 98.000 131.04 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 63.00 42.000 87.00 135-50070-020-000 Employee Relations 350.00 350.00 320.34 91.526 29.66 Subtotal: 316,105.00 316,897.00 35,511.83 316,413.78 99.848 483.22 135-55070-020-000 Independent Labor 880,000.00 31,273.25 886,330.90 100.719 6,330.90- 135-55080-020-000 Maintenance & Repairs 35,000.00 36,120.00 2,784.48 37,952.25 105.073 1,832.25- 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 1,972.08 98.604 27.92 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 41.20 41.20 41.20- 135-55125-020-000 Dumpster Services 52,000.00 47,000.00 45,681.04 97.194 1,318.96 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,110.00 26,166.08 87.220 3,833.92 Subtotal: 119,500.00 995,120.00 36,208.93 998,143.55 100.304 3,023.55- 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 304.08 3,383.51 101.637 54.51- 135-60020-020-000 Electricity 148,227.00 138,227.00 10,427.76 109,187.00 78.991 29,040.00 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 351.00 87.750 49.00 135-60080-020-000 Schools & Training 2,636.00 1,636.00 1,347.00 82.335 289.00 135-60090-020-000 Safety Program 250.00 500.00 474.07 94.814 25.93 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 1,093.55 104.148 43.55- 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 52.006 8,231.00 135-60243-020-000 Prior Year Expense 3,554.00 3,554.22 100.006 .22- 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 49.21 53.88 26.940 146.12 135-60285-020-000 Lawn Equipment & Maintenance 500.00 250.00 250.00 135-60360-020-000 Furniture/Equipment < $5000 3,000.00 1,079.00 1,079.10 100.009 .10- Subtotal: 178,242.00 168,875.00 10,781.05 129,741.86 76.827 39,133.14 135-65005-020-000 Fuel & Lube 14,720.00 13,600.00 950.71 12,143.50 89.290 1,456.50 135-65010-020-000 Uniforms 1,752.00 1,752.00 60.00 1,727.77 98.617 24.23 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-020-000 Chemicals 39,000.00 31,000.00 25,292.10 81.587 5,707.90 135-65035-020-000 Small Tools 1,000.00 300.00 346.09 115.363 46.09- 135-65040-020-000 Safety Equipment 250.00 500.00 277.86 55.572 222.14 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 11,815.89 78.773 3,184.11 Subtotal: 71,722.00 62,152.00 1,010.71 51,603.21 83.027 10,548.79 135-69005-020-000 Capital Outlays 31,000.00 135-69008-020-000 Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 100.000 135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 401.92 1,445.62 101.661 23.62- 135-69280-020-000 Capital Repairs 30,000.00 Subtotal: 82,442.00 21,442.00 401.92 21,465.62 100.110 23.62- Program number: 768,011.00 1,564,486.00 83,914.44 1,517,368.02 96.988 47,117.98 Department number: Wastewater 768,011.00 1,564,486.00 83,914.44 1,517,368.02 96.988 47,117.98 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 90,299.00 90,299.00 6,869.30 77,826.01 86.187 12,472.99 135-50010-021-000 Overtime 10,028.00 10,028.00 1,301.88 8,887.57 88.628 1,140.43 135-50016-021-000 Longevity 17,913.00 2,108.00 2,107.50 99.976 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 1,800.00 100.000 135-50020-021-000 Retirement 9,025.00 9,025.00 747.24 8,492.77 94.103 532.23 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,473.70 18,516.09 78.233 5,151.91 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 102.60 1,325.79 77.850 377.21 135-50028-021-000 Vision Insurance 314.00 314.00 23.68 288.97 92.029 25.03 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 72.75 975.99 91.556 90.01 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 478.07 5,452.73 73.270 1,989.27 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 111.81 1,275.24 73.248 465.76 135-50040-021-000 Unemployment Taxes 198.00 414.00 414.00 100.000 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 3,210.48 98.000 65.52 135-50070-021-000 Employee Relations 200.00 200.00 230.28 115.140 30.28- Subtotal: 168,673.00 153,084.00 11,598.57 130,803.42 85.446 22,280.58 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 23,801.00 14,451.00 674.79 14,011.00 96.955 440.00 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 124.52 1,937.94 96.897 62.06 Subtotal: 27,301.00 16,451.00 799.31 15,948.94 96.948 502.06 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 101.36 1,402.48 105.212 69.48- 135-60020-021-000 Electricity 21,178.00 21,178.00 2,049.87 20,807.19 98.249 370.81 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 135-60080-021-000 Schools & Training 1,711.00 911.00 561.00 61.581 350.00 135-60090-021-000 Safety Program 300.00 300.00 35.34 11.780 264.66 135-60100-021-000 Travel & per diem 550.00 250.00 621.24 248.496 371.24- 135-60105-021-000 Rent/Lease Equipment 10,000.00 5,000.00 5,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 29,322.00 2,151.23 23,427.25 79.896 5,894.75 135-65005-021-000 Fuel & Lube 22,397.00 21,747.00 668.75 12,525.20 57.595 9,221.80 135-65010-021-000 Uniforms 1,040.00 1,040.00 51.00 1,037.73 99.782 2.27 135-65030-021-000 Chemicals 6,000.00 2,000.00 300.89 15.045 1,699.11 135-65035-021-000 Small Tools 1,000.00 300.00 242.99 80.997 57.01 135-65040-021-000 Safety Equipment 500.00 750.00 586.73 78.231 163.27 Subtotal: 30,937.00 25,837.00 719.75 14,693.54 56.870 11,143.46 135-69005-021-000 Capital Outlays 100,000.00 114,000.00 68,300.20 59.912 45,699.80 135-69008-021-000 Short Term Debt-Principal 35,991.00 35,991.00 35,991.00 100.000 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69009-021-000 Short Term Debt-Interest 2,846.00 2,846.00 2,822.90 99.188 23.10 135-69280-021-000 Capital Repairs 71,000.00 Subtotal: 209,837.00 152,837.00 107,114.10 70.084 45,722.90 Program number: 472,170.00 377,531.00 15,268.86 291,987.25 77.341 85,543.75 Department number: Collection 472,170.00 377,531.00 15,268.86 291,987.25 77.341 85,543.75 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 900.00 9,400.00 94.000 600.00 135-50030-026-000 Social Security Taxes 620.00 620.00 55.80 582.80 94.000 37.20 135-50035-026-000 Medicare Taxes 145.00 145.00 13.05 136.30 94.000 8.70 135-50040-026-000 Unemployment Taxes 10.00 230.00 20.70 161.20 70.087 68.80 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 35.35 98.194 .65 Subtotal: 10,811.00 11,031.00 992.49 10,315.65 93.515 715.35 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 1,200.00 26.93 422.72 35.227 777.28 135-60080-026-000 Schools & Training 4,000.00 4,000.00 125.00- 832.00 20.800 3,168.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 41.66 .833 4,958.34 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 75.00 254.40 25.440 745.60 Subtotal: 11,850.00 11,850.00 23.07- 1,585.78 13.382 10,264.22 Program number: 22,661.00 22,881.00 969.42 11,901.43 52.014 10,979.57 Department number: Board of Directors 22,661.00 22,881.00 969.42 11,901.43 52.014 10,979.57 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 458,721.00 458,721.00 46,119.97 454,442.04 99.067 4,278.96 135-50010-030-000 Overtime 500.00 750.00 39.02 923.30 123.107 173.30- 135-50016-030-000 Longevity 3,018.00 3,018.00 3,077.50 101.972 59.50- 135-50020-030-000 Retirement 41,419.00 41,419.00 3,926.67 41,462.71 100.106 43.71- 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 5,687.41 56,863.79 98.171 1,059.21 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 415.37 4,170.91 81.783 929.09 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 97.98 989.48 91.029 97.52 135-50029-030-000 Life Insurance & Other 4,483.00 5,500.00 325.43 4,602.23 83.677 897.77 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 2,562.65 27,164.77 94.786 1,494.23 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 599.33 6,353.07 94.794 348.93 135-50040-030-000 Unemployment Taxes 63.00 1,449.00 .30 1,449.30 100.021 .30- 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.62 1,543.51 98.001 31.49 135-50060-030-000 Pre-emp Physicals/Testing 200.00 200.00 88.45 88.45 44.225 111.55 135-50070-030-000 Employee Relations 5,000.00 5,000.00 181.07 2,913.75 58.275 2,086.25 Subtotal: 614,450.00 617,103.00 60,172.27 606,044.81 98.208 11,058.19 135-55030-030-000 Software & Support 59,698.00 59,698.00 1,245.23 47,046.45 78.807 12,651.55 135-55070-030-000 Independent Labor 7,700.00 7,000.00 148.75 8,603.53 122.908 1,603.53- 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 1,482.36 1,985.81 44.129 2,514.19 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 1,115.75 3,816.54 58.716 2,683.46 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 1,594.97 17,544.67 91.665 1,595.33 135-55160-030-000 Professional Outside Services 15,000.00 10,000.00 7,490.00 7,990.00 79.900 2,010.00 135-55161-030-000 Town Personnel Contract 77,048.00 77,048.00 77,048.00 100.000 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 6,808.00 6,808.00 994.15 7,738.39 113.666 930.39- Subtotal: 196,594.00 190,894.00 14,071.21 171,773.39 89.984 19,120.61 135-60005-030-000 Telephone 11,250.00 11,250.00 975.77 12,669.17 112.615 1,419.17- 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 4,057.00 337.99 3,678.57 90.672 378.43 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 877.36 13,627.86 89.828 1,543.14 135-60025-030-000 Water 1,500.00 1,500.00 104.75 1,053.64 70.243 446.36 135-60035-030-000 Postage 28,500.00 28,500.00 2,124.23 24,587.65 86.272 3,912.35 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 4,914.91 35,741.57 126.162 7,411.57- 135-60050-030-000 Bad Debt Expense 1,500.00 6,200.00 97.63 4,449.27 71.762 1,750.73 135-60055-030-000 Insurance 53,561.00 53,561.00 4,269.73 51,565.01 96.273 1,995.99 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 401.08 40.108 598.92 135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 4,571.95 101.599 71.95- 135-60075-030-000 Meetings 400.00 400.00 27.26 6.815 372.74 135-60079-030-000 Public Education 5,000.00 274.83 5.497 4,725.17 135-60080-030-000 Schools & Training 7,500.00 6,800.00 2,614.25 38.445 4,185.75 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 142.46 3,352.42 67.048 1,647.58 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 2,500.00 2,500.00 5.00 3,714.19 148.568 1,214.19- 135-60125-030-000 Advertising 2,500.00 2,500.00 150.00 1,928.93 77.157 571.07 135-60235-030-000 Security 1,350.00 1,350.00 123.56 9.153 1,226.44 135-60245-030-000 Miscellaneous Expenses 22,870.00 17,870.00 1,851.56 3,917.96 21.925 13,952.04 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 16,525.00 16,525.00- 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,563.55 102.542 63.55- Subtotal: 204,221.00 208,689.00 15,851.39 187,387.72 89.793 21,301.28 135-65010-030-000 Uniforms 1,390.00 1,390.00 998.90 71.863 391.10 135-65055-030-000 Hardware 13,562.00 13,562.00 318.97 8,214.07 60.567 5,347.93 135-65085-030-000 Office Supplies 9,100.00 9,100.00 447.82 6,326.73 69.525 2,773.27 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 4,323.06 75.420 1,408.94 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 369.44 3,219.40 128.776 719.40- 135-65097-030-000 Vending Machine Supplies 200.00 200.00 76.96 38.480 123.04 135-65105-030-000 Printing 4,000.00 4,000.00 3,424.27 85.607 575.73 Subtotal: 36,484.00 36,484.00 1,136.23 26,583.39 72.863 9,900.61 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 278.33 2,650.28 76.820 799.72 Subtotal: 3,450.00 3,450.00 278.33 2,650.28 76.820 799.72 Program number: 1,055,199.00 1,056,620.00 91,509.43 994,439.59 94.115 62,180.41 Department number: Administration 1,055,199.00 1,056,620.00 91,509.43 994,439.59 94.115 62,180.41 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 131,300.00 347,126.00 518,486.18- 347,126.00 135-55055-039-000 Auditing 21,840.00 21,840.00 5,000.00 26,200.00 119.963 4,360.00- 135-55060-039-000 Appraisal 10,000.00 10,000.00 1,914.46 10,072.76 100.728 72.76- 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,451.40 64.511 1,348.60 Subtotal: 166,940.00 382,766.00 511,571.72- 38,724.16 10.117 344,041.84 Program number: 166,940.00 382,766.00 511,571.72- 38,724.16 10.117 344,041.84 . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 1 General Legal Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-001 Legal/General 26,127.34 26,127.34 26,127.34- Subtotal: 26,127.34 26,127.34 26,127.34- Program number: 1 General Legal 26,127.34 26,127.34 26,127.34- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 2 Contracts & ILAs Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-002 Legal/Contracts & ILAs 10,045.30 10,045.30 10,045.30- Subtotal: 10,045.30 10,045.30 10,045.30- Program number: 2 Contracts & ILAs 10,045.30 10,045.30 10,045.30- . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 3 WWTP Bonds Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-003 Legal/WWTP Bonds 463,638.03 463,638.03 463,638.03- Subtotal: 463,638.03 463,638.03 463,638.03- Program number: 3 WWTP Bonds 463,638.03 463,638.03 463,638.03- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 4 Land Access-WWTP Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-004 Legal/Land Access WWTP 34,593.49 34,593.49 34,593.49- Subtotal: 34,593.49 34,593.49 34,593.49- Program number: 4 Land Access-WWTP 34,593.49 34,593.49 34,593.49- . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 5 PID Contract Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-005 Legal/PID Contract 29,800.40 29,800.40 29,800.40- Subtotal: 29,800.40 29,800.40 29,800.40- Program number: 5 PID Contract 29,800.40 29,800.40 29,800.40- . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 6 Open Records Requests Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-006 Legal/Open Records Requests 8,152.20 8,152.20 8,152.20- Subtotal: 8,152.20 8,152.20 8,152.20- Program number: 6 Open Records Requests 8,152.20 8,152.20 8,152.20- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 7 Consolidation & Westlake Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-007 Legal/Consolidation & Westlake 31,116.90 31,116.90 31,116.90- Subtotal: 31,116.90 31,116.90 31,116.90- Program number: 7 Consolidation & Westlake 31,116.90 31,116.90 31,116.90- . glbase_tbam rgonzale Trophy Club MUD #1 Page 23 09:30 10/15/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 8 CCN Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-008 Legal/CCN 19,531.47 19,531.47 19,531.47- Subtotal: 19,531.47 19,531.47 19,531.47- Program number: 8 CCN 19,531.47 19,531.47 19,531.47- Department number: Non Departmental 166,940.00 382,766.00 111,433.41 661,729.29 172.881 278,963.29- Expenditures Subtotal -------- 6,417,937.00 7,303,424.00 1,028,010.54 6,730,074.21 92.150 573,349.79 Fund number: 135 MUD 1 General Fund 289,953.85 505,997.46 505,997.46- . glbase_tbam rgonzale Trophy Club MUD #1 Page 26 09:30 10/15/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 4.18- 87.01- 87.01 507-49036-000-000 GASB Reserves 120,000.00- 120,000.00 Subtotal: 4.18- 120,087.01- 120,087.01 Program number: 4.18- 120,087.01- 120,087.01 Department number: 4.18- 120,087.01- 120,087.01 Revenues Subtotal ----------- 4.18- 120,087.01- 120,087.01 . glbase_tbam rgonzale Trophy Club MUD #1 Page 27 09:30 10/15/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 82,629.40- Subtotal: 82,629.40 82,629.40- Program number: 2 Rate of Flow Control-FW Meter 82,629.40 82,629.40- . glbase_tbam rgonzale Trophy Club MUD #1 Page 28 09:30 10/15/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 282,245.17 135,148.00 272,290.00 96.473 9,955.17 Subtotal: 282,245.17 135,148.00 272,290.00 96.473 9,955.17 Program number: 3 Indian Creek Waterline 282,245.17 135,148.00 272,290.00 96.473 9,955.17 Department number: Water 282,245.17 135,148.00 354,919.40 125.749 72,674.23- Expenditures Subtotal ----------- 282,245.17 135,148.00 354,919.40 125.749 72,674.23- Fund number: 507 MUD 1 Capital Projects 282,245.17 135,143.82 234,832.39 83.202 47,412.78 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 2181 09/02/2014 Property Taxes/Assessments (98,636.42) (2.95) (98,639.37) GL 2182 09/04/2014 Property Taxes/Assessments (3.81) (98,643.18) GL 2184 09/08/2014 Property Taxes/Assessments (9.97) (98,653.15) GL 2186 09/12/2014 Property Taxes/Assessments (10.59) (98,663.74) GL 2187 09/16/2014 Property Taxes/Assessments (35.85) (98,699.59) GL 2188 09/26/2014 Property Taxes/Assessments (.08) (98,699.67) GL 2189 09/29/2014 Property Taxes/Assessments (1.12) (98,700.79) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (64.37) (98,700.79) ** (99,250.00) Budgeted (549.21) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent (129.78) .00 (129.78) _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: .00 (129.78) ** .00 Budgeted 129.78 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2181 09/02/2014 Property Taxes/Assessments (573.41) (.56) (573.97) GL 2182 09/04/2014 Property Taxes/Assessments (.27) (574.24) GL 2183 09/05/2014 Property Taxes/Assessments (8.38) (582.62) GL 2184 09/08/2014 Property Taxes/Assessments (1.88) (584.50) GL 2187 09/16/2014 Property Taxes/Assessments (7.17) (591.67) GL 2188 09/26/2014 Property Taxes/Assessments (.02) (591.69) GL 2189 09/29/2014 Property Taxes/Assessments (.22) (591.91) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (18.50) (591.91) ** (900.00) Budgeted (308.09) Remaining 66 % Used Account: 135-43215-000-000 Insurance Settlement (82.36) .00 (82.36) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (82.36) ** .00 Budgeted 82.36 Remaining 0 % Used Account: 135-47000-000-000 Water 2165 09/30/2014 UB 9/30/14 Billing UB20140930-20140930 User: (2,903,612.28) (471,791.90) (3,375,404.18) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47000-000-000 Water Totals: (471,791.90) (3,375,404.18) ** (3,749,310.00) Budgeted (373,905.82) Remaining 90 % Used Account: 135-47005-000-000 Sewer 2165 09/30/2014 UB 9/30/14 Billing UB20140930-20140930 User: (1,844,745.66) (226,890.02) (2,071,635.68) UB _______________ Account: 135-47005-000-000 Sewer Totals: (226,890.02) (2,071,635.68) ** (1,708,321.00) Budgeted 363,314.68 Remaining 121 % Used Account: 135-47025-000-000 Penalties 2172 09/08/2014 UB 9/8/14 Adjustments UB20140908-20140908 User: (55,020.13) 43.23 (54,976.90) UB 2134 09/23/2014 UB 9/23/14 Penalties UB20140923-20140923 User: (8,285.09) (63,261.99) UB 2157 09/29/2014 UB 9/29/14 Penalty Adj UB20140929-20140929 User: 345.03 (62,916.96) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,896.83) (62,916.96) ** (64,522.00) Budgeted (1,605.04) Remaining 98 % Used Account: 135-47030-000-000 Service Charges 2071 09/09/2014 UB 9/9/14 Cut Off List UB20140909-20140909 User: (8,883.00) (900.00) (9,783.00) UB 2139 09/09/2014 UB 9/9/14 Afer Hours fee UB20140909-20140909 User: (200.00) (9,983.00) UB 2140 09/09/2014 UB 9/9/14 NSF Check fee UB20140909-20140909 User: (25.00) (10,008.00) UB 2163 09/10/2014 UB 9/10/14 Adjustment UB20140910-20140910 User: 25.00 (9,983.00) UB 2165 09/30/2014 UB 9/30/14 Billing UB20140930-20140930 User: (3.00) (9,986.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,103.00) (9,986.00) ** (9,075.00) Budgeted 911.00 Remaining 110 % Used Account: 135-47035-000-000 Plumbing Inspections 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (2,300.00) (100.00) (2,400.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (2,400.00) ** (2,000.00) Budgeted 400.00 Remaining 120 % Used Account: 135-47045-000-000 Sewer Inspections 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (7,050.00) (300.00) (7,350.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (7,350.00) ** (5,000.00) Budgeted 2,350.00 Remaining 147 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47070-000-000 TCCC Effluent Charges 2165 09/30/2014 UB 9/30/14 Billing UB20140930-20140930 User: (64,722.38) (16,592.10) (81,314.48) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (16,592.10) (81,314.48) ** (79,586.00) Budgeted 1,728.48 Remaining 102 % Used Account: 135-48005-000-000 Utility Fees 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (322,000.00) (9,200.00) (331,200.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (9,200.00) (331,200.00) ** (582,109.00) Budgeted (250,909.00) Remaining 57 % Used Account: 135-49010-000-000 Interest Income 2192 09/30/2014 Bank Interest/September (5,547.90) (63.78) (5,611.68) GL 2192 09/30/2014 Bank Interest/September (37.33) (5,649.01) GL 2192 09/30/2014 Bank Interest/September (422.02) (6,071.03) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (523.13) (6,071.03) ** (4,800.00) Budgeted 1,271.03 Remaining 126 % Used Account: 135-49016-000-000 Cell Tower Revenue 2143 09/18/2014 AT&T Antenna Lease (10,015.83) (910.53) (10,926.36) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (10,926.36) ** (10,164.00) Budgeted 762.36 Remaining 108 % Used Account: 135-49018-000-000 Building Rent Income 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (6,416.63) (583.37) (7,000.00) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.37) (7,000.00) ** (7,000.00) Budgeted .00 Remaining 100 % Used Account: 135-49030-000-000 Vending Revenue (226.85) .00 (226.85) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (226.85) ** (350.00) Budgeted (123.15) Remaining 65 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (880,000.00) Budgeted (880,000.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (8,964.00) Budgeted (8,964.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (75,321.80) (2,058.00) (77,379.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (2,058.00) (77,379.80) ** (84,000.00) Budgeted (6,620.20) Remaining 92 % Used Account: 135-49900-000-000 Miscellaneous Income 2165 09/30/2014 UB 9/30/14 Billing UB20140930-20140930 User: (76,595.24) (24.94) (76,620.18) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (24.94) (76,620.18) ** (3,000.00) Budgeted 73,620.18 Remaining ########## Account: 135-49901-000-000 Records Management Revenue (53.39) .00 (53.39) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (53.39) ** (100.00) Budgeted (46.61) Remaining 53 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (4,087.00) .00 (4,087.00) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (4,087.00) ** (4,087.00) Budgeted .00 Remaining 100 % Used Account: 135-49905-000-000 Gas Well Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (886.00) Budgeted (886.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (6,224,076.75) ** (7,303,424.00) Budgeted (1,079,347.25) Remaining 85 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 2088 09/11/2014 Supplemental PR 9/11/14 Salaries & Wages 250,561.52 7,163.41 257,724.93 PR 2062 09/12/2014 MUD Payroll 9/12/14 Salaries & Wages 11,069.33 268,794.26 PR 2135 09/26/2014 MUD Payroll 9/26/14 Salaries & Wages 8,326.96 277,121.22 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 5,934.76 283,055.98 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 32,494.46 283,055.98 ** 287,709.00 Budgeted 4,653.02 Remaining 98 % Used Account: 135-50010-010-000 Overtime 2062 09/12/2014 MUD Payroll 9/12/14 Overtime 17,803.84 601.82 18,405.66 PR 2135 09/26/2014 MUD Payroll 9/26/14 Overtime 736.88 19,142.54 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 823.95 19,966.49 PR _______________ Account: 135-50010-010-000 Overtime Totals: 2,162.65 19,966.49 ** 16,391.00 Budgeted (3,575.49) Remaining 122 % Used Account: 135-50016-010-000 Longevity 4,905.00 .00 4,905.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 4,905.00 ** 4,905.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 2135 09/26/2014 MUD Payroll 9/26/14 Certification 4,011.00 375.00 4,386.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 375.00 4,386.00 ** 5,100.00 Budgeted 714.00 Remaining 86 % Used Account: 135-50020-010-000 Retirement 2088 09/11/2014 Supplemental PR 9/11/14 Retirement 25,333.85 643.27 25,977.12 PR 2062 09/12/2014 MUD Payroll 9/12/14 Retirement 1,048.09 27,025.21 PR 2135 09/26/2014 MUD Payroll 9/26/14 Retirement 847.61 27,872.82 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 606.92 28,479.74 PR _______________ Account: 135-50020-010-000 Retirement Totals: 3,145.89 28,479.74 ** 27,847.00 Budgeted (632.74) Remaining 102 % Used Account: 135-50026-010-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2088 09/11/2014 Supplemental PR 9/11/14 Medical Insurance 36,940.47 296.66 37,237.13 PR 2062 09/12/2014 MUD Payroll 9/12/14 Medical Insurance 1,780.02 39,017.15 PR 2135 09/26/2014 MUD Payroll 9/26/14 Medical Insurance 1,483.30 40,500.45 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 1,016.33 41,516.78 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 4,576.31 41,516.78 ** 48,334.00 Budgeted 6,817.22 Remaining 86 % Used Account: 135-50027-010-000 Dental Insurance 2088 09/11/2014 Supplemental PR 9/11/14 Dental Insurance 2,673.45 16.38 2,689.83 PR 2062 09/12/2014 MUD Payroll 9/12/14 Dental Insurance 124.54 2,814.37 PR 2135 09/26/2014 MUD Payroll 9/26/14 Dental Insurance 108.20 2,922.57 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 74.29 2,996.86 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 323.41 2,996.86 ** 3,932.00 Budgeted 935.14 Remaining 76 % Used Account: 135-50028-010-000 Vision Insurance 2088 09/11/2014 Supplemental PR 9/11/14 Vision Insurance 659.11 4.53 663.64 PR 2062 09/12/2014 MUD Payroll 9/12/14 Vision Insurance 31.49 695.13 PR 2135 09/26/2014 MUD Payroll 9/26/14 Vision Insurance 27.01 722.14 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 18.49 740.63 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 81.52 740.63 ** 873.00 Budgeted 132.37 Remaining 85 % Used Account: 135-50029-010-000 Life Insurance & Other 1974 09/01/2014 Sept A/P September Dental, Life, ADD, S 2,390.61 223.17 2,613.78 METLIFE 34137 AP 2161 09/30/2014 Sept A/P Café 125 admin 16.36 2,630.14 BenefitMall 34221 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 239.53 2,630.14 ** 3,306.00 Budgeted 675.86 Remaining 80 % Used Account: 135-50030-010-000 Social Security Taxes 2088 09/11/2014 Supplemental PR 9/11/14 Social Security Taxes 17,525.13 450.83 17,975.96 PR 2062 09/12/2014 MUD Payroll 9/12/14 Social Security Taxes 720.47 18,696.43 PR 2135 09/26/2014 MUD Payroll 9/26/14 Social Security Taxes 575.75 19,272.18 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 415.77 19,687.95 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 2,162.82 19,687.95 ** 19,289.00 Budgeted (398.95) Remaining 102 % Used Account: 135-50035-010-000 Medicare Taxes 2088 09/11/2014 Supplemental PR 9/11/14 Medicare Taxes 4,098.63 105.44 4,204.07 PR 2062 09/12/2014 MUD Payroll 9/12/14 Medicare Taxes 168.47 4,372.54 PR 2135 09/26/2014 MUD Payroll 9/26/14 Medicare Taxes 134.66 4,507.20 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 97.23 4,604.43 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 505.80 4,604.43 ** 4,511.00 Budgeted (93.43) Remaining 102 % Used Account: 135-50040-010-000 Unemployment Taxes 1,244.44 .00 1,244.44 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 1,244.44 ** 1,244.00 Budgeted (.44) Remaining 100 % Used Account: 135-50045-010-000 Workman's Compensation 59 09/01/2014 Sep Ins & W/C Expense 8,826.95 802.45 9,629.40 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 9,629.40 ** 9,829.00 Budgeted 199.60 Remaining 98 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 359.90 .00 359.90 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 359.90 ** 350.00 Budgeted (9.90) Remaining 103 % Used Account: 135-50070-010-000 Employee Relations 180.53 .00 180.53 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 180.53 ** 300.00 Budgeted 119.47 Remaining 60 % Used Account: 135-55005-010-000 Engineering . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 2193 09/26/2014 8/27-9/26/14 PCards THE HOME DEPOT 6581 57,645.58 73.00 57,718.58 THE HOME DEPOT 6581 PC 2193 09/26/2014 8/27-9/26/14 PCards THE HOME DEPOT 6581 16.70 57,735.28 THE HOME DEPOT 6581 PC 2193 09/26/2014 8/27-9/26/14 PCards THE HOME DEPOT 6581 27.16 57,762.44 THE HOME DEPOT 6581 PC 2193 09/26/2014 8/27-9/26/14 PCards THE HOME DEPOT 6581 4.99 57,767.43 THE HOME DEPOT 6581 PC 2161 09/30/2014 Sept A/P 6" Mushroom Lid 52.44 57,819.87 HD SUPPLY WATERWORKS, LTD. 34234 AP 2204 09/30/2014 Sept A/P Meter couplings 103.25 57,923.12 HD SUPPLY WATERWORKS, LTD. 34234 AP 2204 09/30/2014 Sept A/P Valve box with lid 105.96 58,029.08 HD SUPPLY WATERWORKS, LTD. 34234 AP 2204 09/30/2014 Sept A/P Resetters 600.00 58,629.08 HD SUPPLY WATERWORKS, LTD. 34234 AP 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (150.37) 58,478.71 AR _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 833.13 58,478.71 ** 61,000.00 Budgeted 2,521.29 Remaining 96 % Used Account: 135-55090-010-000 Vehicle Maintenance 2120 09/19/2014 Sept A/P Oil and oil filters 4,589.37 242.85 4,832.22 ROANOKE AUTO SUPPLY 34190 AP 2193 09/26/2014 8/27-9/26/14 PCards THE HOME DEPOT 6581 139.59 4,971.81 THE HOME DEPOT 6581 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 382.44 4,971.81 ** 5,000.00 Budgeted 28.19 Remaining 99 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2120 09/19/2014 Sept A/P Backhoe repair 248.33 2,251.65 2,499.98 HOLT CAT 34177 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 2,251.65 2,499.98 ** 2,500.00 Budgeted .02 Remaining 100 % Used Account: 135-55135-010-000 Lab Analysis 3,821.02 .00 3,821.02 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 3,821.02 ** 5,500.00 Budgeted 1,678.98 Remaining 69 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2120 09/19/2014 Sept A/P Charter, Gexa, Verizon 4,211.41 324.00 4,535.41 TOWN OF TROPHY CLUB 34197 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 324.00 4,535.41 ** 4,913.00 Budgeted 377.59 Remaining 92 % Used Account: 135-60020-010-000 Electricity 2120 09/19/2014 Sept A/P Electricity 8/13-9/12/14 126,426.47 16,661.82 143,088.29 HUDSON ENERGY SERVICES, LLC 34178 AP 2120 09/19/2014 Sept A/P Electricity 8/12-9/11/14 73.82 143,162.11 HUDSON ENERGY SERVICES, LLC 34178 AP 2161 09/30/2014 Sept A/P Electricity 8/13-9/12/14 4,505.39 147,667.50 HUDSON ENERGY SERVICES, LLC 34236 AP _______________ Account: 135-60020-010-000 Electricity Totals: 21,241.03 147,667.50 ** 155,160.00 Budgeted 7,492.50 Remaining 95 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 2,715.66 .00 2,715.66 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 2,715.66 ** 2,538.00 Budgeted (177.66) Remaining 107 % Used Account: 135-60070-010-000 Dues & Memberships 289.00 .00 289.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 289.00 ** 300.00 Budgeted 11.00 Remaining 96 % Used Account: 135-60080-010-000 Schools & Training 1,782.00 .00 1,782.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,782.00 ** 1,500.00 Budgeted (282.00) Remaining 119 % Used Account: 135-60090-010-000 Safety Program 27.83 .00 27.83 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 27.83 ** .00 Budgeted (27.83) Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2161 09/30/2014 Sept A/P Reimburse Petty Cash RG 237.48 7.00 244.48 TROPHY CLUB MUD PETTY CASH 34267 AP _______________ Account: 135-60100-010-000 Travel & per diem Totals: 7.00 244.48 ** 279.00 Budgeted 34.52 Remaining 88 % Used Account: 135-60105-010-000 Rent/Lease Equipment 96.00 .00 96.00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 96.00 ** 500.00 Budgeted 404.00 Remaining 19 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 37,077.89 .00 37,077.89 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 37,077.89 ** 47,400.00 Budgeted 10,322.11 Remaining 78 % Used Account: 135-60150-010-000 Wholesale Water 2161 09/30/2014 Sept A/P Wholesale Water 1,515,268.67 233,800.10 1,749,068.77 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 233,800.10 1,749,068.77 ** 2,338,473.00 Budgeted 589,404.23 Remaining 75 % 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 2120 09/19/2014 Sept A/P Backhoe repair 1,680.85 838.07 2,518.92 HOLT CAT 34177 AP 2120 09/19/2014 Sept A/P PVC pipe, couplings, water par 986.38 3,505.30 HD SUPPLY WATERWORKS, LTD. 34176 AP 2193 09/26/2014 8/27-9/26/14 PCards TEX-TURF 161.66 3,666.96 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 1,986.11 3,666.96 ** 3,500.00 Budgeted (166.96) Remaining 105 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 1,664.20 .00 1,664.20 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 1,664.20 ** 2,000.00 Budgeted 335.80 Remaining 83 % Used Account: 135-65005-010-000 Fuel & Lube 2207 09/30/2014 Sept MUD Gas log 13,040.82 745.97 13,786.79 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 745.97 13,786.79 ** 22,181.00 Budgeted 8,394.21 Remaining 62 % Used Account: 135-65010-010-000 Uniforms 2193 09/26/2014 8/27-9/26/14 PCards PANDA EMBROIDERY 1,938.58 376.00 2,314.58 PANDA EMBROIDERY PC _______________ Account: 135-65010-010-000 Uniforms Totals: 376.00 2,314.58 ** 2,500.00 Budgeted 185.42 Remaining 93 % Used Account: 135-65030-010-000 Chemicals 2120 09/19/2014 Sept A/P Chemicals 7,917.02 467.05 8,384.07 HACH COMPANY 34175 AP 2120 09/19/2014 Sept A/P Chemicals 31.85 8,415.92 HACH COMPANY 34175 AP 2161 09/30/2014 Sept A/P Chlorine 624.53 9,040.45 DPC INDUSTRIES, INC 34229 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,123.43 9,040.45 ** 5,000.00 Budgeted (4,040.45) Remaining 181 % Used Account: 135-65035-010-000 Small Tools 588.00 .00 588.00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 588.00 ** 1,200.00 Budgeted 612.00 Remaining 49 % Used Account: 135-65040-010-000 Safety Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2193 09/26/2014 8/27-9/26/14 PCards TX AMERICA SAFETY 344.55 359.06 703.61 TX AMERICA SAFETY PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 359.06 703.61 ** 1,000.00 Budgeted 296.39 Remaining 70 % Used Account: 135-65050-010-000 Meter Expense 2204 09/30/2014 Sept A/P Meters 91,735.04 32,275.00 124,010.04 ATLAS UTILITY SUPPLY CO. 34218 AP 2214 09/30/2014 Sept A/P Completes 9/3/14 Backorder/Met 1,495.00 125,505.04 ATLAS UTILITY SUPPLY CO. AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 33,770.00 125,505.04 ** 143,550.00 Budgeted 18,044.96 Remaining 87 % Used Account: 135-69005-010-000 Capital Outlays 35,679.59 .00 35,679.59 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 35,679.59 ** 35,681.00 Budgeted 1.41 Remaining 100 % Used Account: 135-69008-010-000 Short Term Debt-Principal 1974 09/01/2014 Sept A/P Ground Storage Final Payment 122,980.00 367,000.00 489,980.00 FIRST FINANCIAL BANK 34092 AP _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: 367,000.00 489,980.00 ** 489,980.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 1974 09/01/2014 Sept A/P Ground Storage Final Payment 11,621.26 5,266.45 16,887.71 FIRST FINANCIAL BANK 34092 AP 1974 09/01/2014 Sept A/P Interest payment/$445K loan 2,468.95 19,356.66 FIRST FINANCIAL BANK 34093 AP _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: 7,735.40 19,356.66 ** 19,268.00 Budgeted (88.66) Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 2161 09/30/2014 Sept A/P Bal due Water tank Maint 100,816.54 3,015.34 103,831.88 UTILITY SERVICE CO, INC. 34270 AP 2161 09/30/2014 Sept A/P Bal due Water tank/Maintenance 3,014.48 106,846.36 UTILITY SERVICE CO, INC. 34270 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 6,029.82 106,846.36 ** 100,847.00 Budgeted (5,999.36) Remaining 106 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 2120 09/19/2014 Sept A/P Lab Analysis for PID 3,279.87 80.00 3,359.87 TARRANT CTY PUBLIC HEALTH LAB 34193 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 3,359.87 ** 2,000.00 Budgeted (1,359.87) Remaining 168 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID 2,496.19 .00 2,496.19 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 2,496.19 ** 5,000.00 Budgeted 2,503.81 Remaining 50 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 3,252,648.63 ** 3,899,140.00 Budgeted 646,491.37 Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 2062 09/12/2014 MUD Payroll 9/12/14 Salaries & Wages 179,525.26 7,785.51 187,310.77 PR 2135 09/26/2014 MUD Payroll 9/26/14 Salaries & Wages 7,785.51 195,096.28 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 7,895.83 202,992.11 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 23,466.85 202,992.11 ** 202,894.00 Budgeted (98.11) Remaining 100 % Used Account: 135-50010-020-000 Overtime 2062 09/12/2014 MUD Payroll 9/12/14 Overtime 12,491.76 727.60 13,219.36 PR 2135 09/26/2014 MUD Payroll 9/26/14 Overtime 251.72 13,471.08 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 446.73 13,917.81 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,426.05 13,917.81 ** 11,965.00 Budgeted (1,952.81) Remaining 116 % Used Account: 135-50016-020-000 Longevity 2,997.50 .00 2,997.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,997.50 ** 2,998.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 2135 09/26/2014 MUD Payroll 9/26/14 Certification 4,400.00 400.00 4,800.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 4,800.00 ** 4,800.00 Budgeted .00 Remaining 100 % Used Account: 135-50020-020-000 Retirement 2062 09/12/2014 MUD Payroll 9/12/14 Retirement 18,375.78 764.47 19,140.25 PR 2135 09/26/2014 MUD Payroll 9/26/14 Retirement 757.67 19,897.92 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 749.18 20,647.10 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,271.32 20,647.10 ** 19,905.00 Budgeted (742.10) Remaining 104 % Used Account: 135-50026-020-000 Medical Insurance 2062 09/12/2014 MUD Payroll 9/12/14 Medical Insurance 37,241.60 1,713.39 38,954.99 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2135 09/26/2014 MUD Payroll 9/26/14 Medical Insurance 37,241.60 1,713.37 40,668.36 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 1,722.97 42,391.33 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,149.73 42,391.33 ** 43,471.00 Budgeted 1,079.67 Remaining 98 % Used Account: 135-50027-020-000 Dental Insurance 2062 09/12/2014 MUD Payroll 9/12/14 Dental Insurance 2,370.42 105.68 2,476.10 PR 2135 09/26/2014 MUD Payroll 9/26/14 Dental Insurance 105.70 2,581.80 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 110.46 2,692.26 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 321.84 2,692.26 ** 2,989.00 Budgeted 296.74 Remaining 90 % Used Account: 135-50028-020-000 Vision Insurance 2062 09/12/2014 MUD Payroll 9/12/14 Vision Insurance 559.87 25.61 585.48 PR 2135 09/26/2014 MUD Payroll 9/26/14 Vision Insurance 25.65 611.13 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 26.37 637.50 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 77.63 637.50 ** 658.00 Budgeted 20.50 Remaining 97 % Used Account: 135-50029-020-000 Life Insurance & Other 1974 09/01/2014 Sept A/P September Dental, Life, ADD, S 2,020.71 158.73 2,179.44 METLIFE 34137 AP 2161 09/30/2014 Sept A/P Café 125 admin 32.72 2,212.16 BenefitMall 34221 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 191.45 2,212.16 ** 2,303.00 Budgeted 90.84 Remaining 96 % Used Account: 135-50030-020-000 Social Security Taxes 2062 09/12/2014 MUD Payroll 9/12/14 Social Security Taxes 11,202.01 453.21 11,655.22 PR 2135 09/26/2014 MUD Payroll 9/26/14 Social Security Taxes 438.36 12,093.58 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 463.41 12,556.99 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,354.98 12,556.99 ** 13,805.00 Budgeted 1,248.01 Remaining 91 % Used Account: 135-50035-020-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2062 09/12/2014 MUD Payroll 9/12/14 Medicare Taxes 2,619.82 105.99 2,725.81 PR 2135 09/26/2014 MUD Payroll 9/26/14 Medicare Taxes 102.51 2,828.32 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 108.40 2,936.72 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 316.90 2,936.72 ** 3,229.00 Budgeted 292.28 Remaining 91 % Used Account: 135-50040-020-000 Unemployment Taxes 828.00 .00 828.00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 828.00 ** 828.00 Budgeted .00 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 59 09/01/2014 Sep Ins & W/C Expense 5,885.88 535.08 6,420.96 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 6,420.96 ** 6,552.00 Budgeted 131.04 Remaining 98 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 63.00 .00 63.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 63.00 ** 150.00 Budgeted 87.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 320.34 .00 320.34 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 320.34 ** 350.00 Budgeted 29.66 Remaining 92 % Used Account: 135-55070-020-000 Independent Labor 2204 09/30/2014 Sept A/P WWTP Improvements 855,057.65 31,273.25 886,330.90 THE WALLACE GROUP, INC. 34262 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 31,273.25 886,330.90 ** 880,000.00 Budgeted (6,330.90) Remaining 101 % Used Account: 135-55080-020-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2120 09/19/2014 Sept A/P Repair to Lift station 2 and 7 35,167.77 681.40 35,849.17 DHS AUTOMATION, INC 34169 AP 2193 09/26/2014 8/27-9/26/14 PCards AUTOMATIC GATE EQUIPME 16.50 35,865.67 AUTOMATIC GATE EQUIPME PC 2193 09/26/2014 8/27-9/26/14 PCards FASTENAL COMPANY01 36.58 35,902.25 FASTENAL COMPANY01 PC 2198 09/30/2014 Sept A/P Worked on Bar Screen 1,435.00 37,337.25 Zachary M. Sterling 34211 AP 2199 09/30/2014 Void A/P Check 34203 Worked on Bar Screen (1,435.00) 35,902.25 Sterling & Sons 34203 AP 2161 09/30/2014 Sept A/P Worked on Bar Screen 1,435.00 37,337.25 Sterling & Sons 34203 AP 2204 09/30/2014 Sept A/P Replace circuit board and surg 615.00 37,952.25 Alan's Gates, Inc. 34217 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 2,784.48 37,952.25 ** 36,120.00 Budgeted (1,832.25) Remaining 105 % Used Account: 135-55090-020-000 Vehicle Maintenance 1,972.08 .00 1,972.08 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 1,972.08 ** 2,000.00 Budgeted 27.92 Remaining 99 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2204 09/30/2014 Sept A/P Tire for water backhoe 81.20 81.20 BLAGG TIRE & SERVICE 34222 AP 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (40.00) 41.20 AR _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 41.20 41.20 ** .00 Budgeted (41.20) Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 45,681.04 .00 45,681.04 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 45,681.04 ** 47,000.00 Budgeted 1,318.96 Remaining 97 % Used Account: 135-55135-020-000 Lab Analysis 2120 09/19/2014 Sept A/P Testing 24,056.08 176.00 24,232.08 OXIDOR LABORATORIES LLC 34188 AP 2120 09/19/2014 Sept A/P Testing 246.00 24,478.08 OXIDOR LABORATORIES LLC 34188 AP 2120 09/19/2014 Sept A/P Testing 176.00 24,654.08 OXIDOR LABORATORIES LLC 34188 AP 2120 09/19/2014 Sept A/P Testing 246.00 24,900.08 OXIDOR LABORATORIES LLC 34188 AP 2204 09/30/2014 Sept A/P Testing 246.00 25,146.08 OXIDOR LABORATORIES LLC 34252 AP 2204 09/30/2014 Sept A/P Testing 176.00 25,322.08 OXIDOR LABORATORIES LLC 34252 AP 2204 09/30/2014 Sept A/P Testing 246.00 25,568.08 OXIDOR LABORATORIES LLC 34252 AP 2204 09/30/2014 Sept A/P Testing 176.00 25,744.08 OXIDOR LABORATORIES LLC 34252 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2204 09/30/2014 Sept A/P Testing 24,056.08 246.00 25,990.08 OXIDOR LABORATORIES LLC 34252 AP 2204 09/30/2014 Sept A/P Testing 176.00 26,166.08 OXIDOR LABORATORIES LLC 34252 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,110.00 26,166.08 ** 30,000.00 Budgeted 3,833.92 Remaining 87 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 2120 09/19/2014 Sept A/P Charter, Gexa, Verizon 3,079.43 304.08 3,383.51 TOWN OF TROPHY CLUB 34197 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 304.08 3,383.51 ** 3,329.00 Budgeted (54.51) Remaining 102 % Used Account: 135-60020-020-000 Electricity 2120 09/19/2014 Sept A/P Electricity 8/13-9/12/14 98,759.24 10,427.76 109,187.00 HUDSON ENERGY SERVICES, LLC 34178 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,427.76 109,187.00 ** 138,227.00 Budgeted 29,040.00 Remaining 79 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 351.00 .00 351.00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 351.00 ** 400.00 Budgeted 49.00 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training 1,347.00 .00 1,347.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 1,347.00 ** 1,636.00 Budgeted 289.00 Remaining 82 % Used Account: 135-60090-020-000 Safety Program 474.07 .00 474.07 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 474.07 ** 500.00 Budgeted 25.93 Remaining 95 % Used Account: 135-60100-020-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,093.55 .00 1,093.55 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 1,093.55 ** 1,050.00 Budgeted (43.55) Remaining 104 % Used Account: 135-60105-020-000 Rent/Lease Equipment 299.53 .00 299.53 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 8,919.00 .00 8,919.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 8,919.00 ** 17,150.00 Budgeted 8,231.00 Remaining 52 % Used Account: 135-60243-020-000 Prior Year Expense 3,554.22 .00 3,554.22 _______________ Account: 135-60243-020-000 Prior Year Expense Totals: .00 3,554.22 ** 3,554.00 Budgeted (.22) Remaining 100 % Used Account: 135-60245-020-000 Miscellaneous Expenses 2193 09/26/2014 8/27-9/26/14 PCards FUZZYS TACO SHOP-ROANO 4.67 49.21 53.88 FUZZYS TACO SHOP-ROANO PC _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 49.21 53.88 ** 200.00 Budgeted 146.12 Remaining 27 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1,079.10 .00 1,079.10 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,079.10 ** 1,079.00 Budgeted (.10) Remaining 100 % Used Account: 135-65005-020-000 Fuel & Lube 2207 09/30/2014 Sept MUD Gas log 11,192.79 950.71 12,143.50 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 950.71 12,143.50 ** 13,600.00 Budgeted 1,456.50 Remaining 89 % Used Account: 135-65010-020-000 Uniforms 2120 09/19/2014 Sept A/P Caps 1,667.77 60.00 1,727.77 PANDA EMBROIDERY 34189 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 60.00 1,727.77 ** 1,752.00 Budgeted 24.23 Remaining 99 % Used Account: 135-65030-020-000 Chemicals 25,292.10 .00 25,292.10 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 25,292.10 ** 31,000.00 Budgeted 5,707.90 Remaining 82 % Used Account: 135-65035-020-000 Small Tools 346.09 .00 346.09 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 346.09 ** 300.00 Budgeted (46.09) Remaining 115 % Used Account: 135-65040-020-000 Safety Equipment 277.86 .00 277.86 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 277.86 ** 500.00 Budgeted 222.14 Remaining 56 % Used Account: 135-65045-020-000 Lab Supplies 11,815.89 .00 11,815.89 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 11,815.89 ** 15,000.00 Budgeted 3,184.11 Remaining 79 % Used Account: 135-69008-020-000 Short Term Debt-Principal 20,020.00 .00 20,020.00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 20,020.00 ** 20,020.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 1974 09/01/2014 Sept A/P Interest payment/$445K loan 1,043.70 401.92 1,445.62 FIRST FINANCIAL BANK 34093 AP _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: 401.92 1,445.62 ** 1,422.00 Budgeted (23.62) Remaining 102 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,517,368.02 ** 1,564,486.00 Budgeted 47,117.98 Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-021-000 Salaries & Wages 2062 09/12/2014 MUD Payroll 9/12/14 Salaries & Wages 70,956.71 3,434.65 74,391.36 PR 2135 09/26/2014 MUD Payroll 9/26/14 Salaries & Wages 3,434.65 77,826.01 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 6,869.30 77,826.01 ** 90,299.00 Budgeted 12,472.99 Remaining 86 % Used Account: 135-50010-021-000 Overtime 2062 09/12/2014 MUD Payroll 9/12/14 Overtime 7,585.69 569.08 8,154.77 PR 2135 09/26/2014 MUD Payroll 9/26/14 Overtime 732.80 8,887.57 PR _______________ Account: 135-50010-021-000 Overtime Totals: 1,301.88 8,887.57 ** 10,028.00 Budgeted 1,140.43 Remaining 89 % Used Account: 135-50016-021-000 Longevity 2,107.50 .00 2,107.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 2,107.50 ** 2,108.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 2135 09/26/2014 MUD Payroll 9/26/14 Certification 1,650.00 150.00 1,800.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,800.00 ** 1,800.00 Budgeted .00 Remaining 100 % Used Account: 135-50020-021-000 Retirement 2062 09/12/2014 MUD Payroll 9/12/14 Retirement 7,745.53 359.54 8,105.07 PR 2135 09/26/2014 MUD Payroll 9/26/14 Retirement 387.70 8,492.77 PR _______________ Account: 135-50020-021-000 Retirement Totals: 747.24 8,492.77 ** 9,025.00 Budgeted 532.23 Remaining 94 % Used Account: 135-50026-021-000 Medical Insurance 2062 09/12/2014 MUD Payroll 9/12/14 Medical Insurance 17,042.39 736.86 17,779.25 PR 2135 09/26/2014 MUD Payroll 9/26/14 Medical Insurance 736.84 18,516.09 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,473.70 18,516.09 ** 23,668.00 Budgeted 5,151.91 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 2062 09/12/2014 MUD Payroll 9/12/14 Dental Insurance 1,223.19 51.30 1,274.49 PR 2135 09/26/2014 MUD Payroll 9/26/14 Dental Insurance 51.30 1,325.79 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 102.60 1,325.79 ** 1,703.00 Budgeted 377.21 Remaining 78 % Used Account: 135-50028-021-000 Vision Insurance 2062 09/12/2014 MUD Payroll 9/12/14 Vision Insurance 265.29 11.84 277.13 PR 2135 09/26/2014 MUD Payroll 9/26/14 Vision Insurance 11.84 288.97 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.68 288.97 ** 314.00 Budgeted 25.03 Remaining 92 % Used Account: 135-50029-021-000 Life Insurance & Other 1974 09/01/2014 Sept A/P September Dental, Life, ADD, S 903.24 72.75 975.99 METLIFE 34137 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 72.75 975.99 ** 1,066.00 Budgeted 90.01 Remaining 92 % Used Account: 135-50030-021-000 Social Security Taxes 2062 09/12/2014 MUD Payroll 9/12/14 Social Security Taxes 4,974.66 230.15 5,204.81 PR 2135 09/26/2014 MUD Payroll 9/26/14 Social Security Taxes 247.92 5,452.73 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 478.07 5,452.73 ** 7,442.00 Budgeted 1,989.27 Remaining 73 % Used Account: 135-50035-021-000 Medicare Taxes 2062 09/12/2014 MUD Payroll 9/12/14 Medicare Taxes 1,163.43 53.83 1,217.26 PR 2135 09/26/2014 MUD Payroll 9/26/14 Medicare Taxes 57.98 1,275.24 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 111.81 1,275.24 ** 1,741.00 Budgeted 465.76 Remaining 73 % Used Account: 135-50040-021-000 Unemployment Taxes 414.00 .00 414.00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 414.00 ** 414.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-021-000 Workman's Compensation 59 09/01/2014 Sep Ins & W/C Expense 2,942.94 267.54 3,210.48 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 3,210.48 ** 3,276.00 Budgeted 65.52 Remaining 98 % Used Account: 135-50070-021-000 Employee Relations 230.28 .00 230.28 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 230.28 ** 200.00 Budgeted (30.28) Remaining 115 % Used Account: 135-55080-021-000 Maintenance & Repairs 2120 09/19/2014 Sept A/P Lift Station #9 13,336.21 381.00 13,717.21 XYLEM WATER SOLUTIONS USA INC 34201 AP 2204 09/30/2014 Sept A/P 30' suspended floats 293.79 14,011.00 HD SUPPLY FACILITIES MAINT LTD 34233 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 674.79 14,011.00 ** 14,451.00 Budgeted 440.00 Remaining 97 % Used Account: 135-55090-021-000 Vehicle Maintenance 2120 09/19/2014 Sept A/P 1 Tire & Balance Unit 301 Ford 1,813.42 124.52 1,937.94 BLAGG TIRE & SERVICE 34166 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 124.52 1,937.94 ** 2,000.00 Budgeted 62.06 Remaining 97 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 2120 09/19/2014 Sept A/P Charter, Gexa, Verizon 1,301.12 101.36 1,402.48 TOWN OF TROPHY CLUB 34197 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 101.36 1,402.48 ** 1,333.00 Budgeted (69.48) Remaining 105 % Used Account: 135-60020-021-000 Electricity 2120 09/19/2014 Sept A/P Electricity 7/29-8/28/14 18,757.32 364.15 19,121.47 TRI COUNTY ELECTRIC 34198 AP 2120 09/19/2014 Sept A/P Electricity 7/29-8/28/14 203.56 19,325.03 TRI COUNTY ELECTRIC 34198 AP 2120 09/19/2014 Sept A/P Electricity 7/29-8/28/14 28.15 19,353.18 TRI COUNTY ELECTRIC 34198 AP 2120 09/19/2014 Sept A/P Electricity 8/13-9/12/14 269.83 19,623.01 HUDSON ENERGY SERVICES, LLC 34178 AP 2120 09/19/2014 Sept A/P Electricity 8/13-9/12/14 556.67 20,179.68 HUDSON ENERGY SERVICES, LLC 34178 AP 2120 09/19/2014 Sept A/P Electricity 8/12-9/11/14 63.62 20,243.30 HUDSON ENERGY SERVICES, LLC 34178 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2120 09/19/2014 Sept A/P Electricity 8/12-9/11/14 18,757.32 30.25 20,273.55 HUDSON ENERGY SERVICES, LLC 34178 AP 2120 09/19/2014 Sept A/P Electricity 8/13-9/12/14 85.48 20,359.03 HUDSON ENERGY SERVICES, LLC 34178 AP 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (103.92) 20,255.11 AR 2214 09/30/2014 Sept A/P Electricity 8/28-9/30/14 341.23 20,596.34 TRI COUNTY ELECTRIC AP 2214 09/30/2014 Sept A/P Electricity 8/28-9/30/14 182.44 20,778.78 TRI COUNTY ELECTRIC AP 2214 09/30/2014 Sept A/P Electricity 8/28-9/30 28.41 20,807.19 TRI COUNTY ELECTRIC AP _______________ Account: 135-60020-021-000 Electricity Totals: 2,049.87 20,807.19 ** 21,178.00 Budgeted 370.81 Remaining 98 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training 561.00 .00 561.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 561.00 ** 911.00 Budgeted 350.00 Remaining 62 % Used Account: 135-60090-021-000 Safety Program 35.34 .00 35.34 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 35.34 ** 300.00 Budgeted 264.66 Remaining 12 % Used Account: 135-60100-021-000 Travel & per diem 621.24 .00 621.24 _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 621.24 ** 250.00 Budgeted (371.24) Remaining 248 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 2207 09/30/2014 Sept MUD Gas log 11,856.45 668.75 12,525.20 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 668.75 12,525.20 ** 21,747.00 Budgeted 9,221.80 Remaining 58 % Used Account: 135-65010-021-000 Uniforms 2204 09/30/2014 Sept A/P Caps 986.73 51.00 1,037.73 PANDA EMBROIDERY 34253 AP _______________ Account: 135-65010-021-000 Uniforms Totals: 51.00 1,037.73 ** 1,040.00 Budgeted 2.27 Remaining 100 % Used Account: 135-65030-021-000 Chemicals 300.89 .00 300.89 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 300.89 ** 2,000.00 Budgeted 1,699.11 Remaining 15 % Used Account: 135-65035-021-000 Small Tools 242.99 .00 242.99 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 242.99 ** 300.00 Budgeted 57.01 Remaining 81 % Used Account: 135-65040-021-000 Safety Equipment 586.73 .00 586.73 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 586.73 ** 750.00 Budgeted 163.27 Remaining 78 % Used Account: 135-69005-021-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 68,300.20 .00 68,300.20 _______________ Account: 135-69005-021-000 Capital Outlays Totals: .00 68,300.20 ** 114,000.00 Budgeted 45,699.80 Remaining 60 % Used Account: 135-69008-021-000 Short Term Debt-Principal 35,991.00 .00 35,991.00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 35,991.00 ** 35,991.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-021-000 Short Term Debt-Interest 2,822.90 .00 2,822.90 _______________ Account: 135-69009-021-000 Short Term Debt-Interest Totals: .00 2,822.90 ** 2,846.00 Budgeted 23.10 Remaining 99 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 291,987.25 ** 377,531.00 Budgeted 85,543.75 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 2062 09/12/2014 MUD Payroll 9/12/14 Salaries & Wages 8,500.00 500.00 9,000.00 PR 2135 09/26/2014 MUD Payroll 9/26/14 Salaries & Wages 400.00 9,400.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 900.00 9,400.00 ** 10,000.00 Budgeted 600.00 Remaining 94 % Used Account: 135-50030-026-000 Social Security Taxes 2062 09/12/2014 MUD Payroll 9/12/14 Social Security Taxes 527.00 31.00 558.00 PR 2135 09/26/2014 MUD Payroll 9/26/14 Social Security Taxes 24.80 582.80 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 55.80 582.80 ** 620.00 Budgeted 37.20 Remaining 94 % Used Account: 135-50035-026-000 Medicare Taxes 2062 09/12/2014 MUD Payroll 9/12/14 Medicare Taxes 123.25 7.25 130.50 PR 2135 09/26/2014 MUD Payroll 9/26/14 Medicare Taxes 5.80 136.30 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 13.05 136.30 ** 145.00 Budgeted 8.70 Remaining 94 % Used Account: 135-50040-026-000 Unemployment Taxes 2062 09/12/2014 MUD Payroll 9/12/14 Unemployment Taxes 140.50 11.50 152.00 PR 2135 09/26/2014 MUD Payroll 9/26/14 Unemployment Taxes 9.20 161.20 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 20.70 161.20 ** 230.00 Budgeted 68.80 Remaining 70 % Used Account: 135-50045-026-000 Workman's Compensation 59 09/01/2014 Sep Ins & W/C Expense 32.41 2.94 35.35 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 35.35 ** 36.00 Budgeted .65 Remaining 98 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 2193 09/26/2014 8/27-9/26/14 PCards RANDALLS STORE00017897 395.79 26.93 422.72 RANDALLS STORE00017897 PC _______________ Account: 135-60075-026-000 Meetings Totals: 26.93 422.72 ** 1,200.00 Budgeted 777.28 Remaining 35 % Used Account: 135-60080-026-000 Schools & Training 2193 09/26/2014 8/27-9/26/14 PCards NCTCOG RTC TRAINING 957.00 (125.00) 832.00 NCTCOG RTC TRAINING PC _______________ Account: 135-60080-026-000 Schools & Training Totals: (125.00) 832.00 ** 4,000.00 Budgeted 3,168.00 Remaining 21 % Used Account: 135-60100-026-000 Travel & per diem 41.66 .00 41.66 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 41.66 ** 5,000.00 Budgeted 4,958.34 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses 2066 09/09/2014 Sept A/P Reimb for Director Fire T-shir 179.40 75.00 254.40 JENNIFER MCKNIGHT 34127 AP _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 75.00 254.40 ** 1,000.00 Budgeted 745.60 Remaining 25 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 11,901.43 ** 22,881.00 Budgeted 10,979.57 Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 2062 09/12/2014 MUD Payroll 9/12/14 Salaries & Wages 408,322.07 16,179.37 424,501.44 PR 2120 09/19/2014 Sept A/P Temp Receptionist 512.00 425,013.44 TRINITY EMPLOYMENT SOLUTIONS 34199 AP 2120 09/19/2014 Sept A/P Temp Receptionist 640.00 425,653.44 TRINITY EMPLOYMENT SOLUTIONS 34199 AP 2135 09/26/2014 MUD Payroll 9/26/14 Salaries & Wages 16,173.51 441,826.95 PR 2161 09/30/2014 Sept A/P Temp Receptionist 640.00 442,466.95 TRINITY EMPLOYMENT SOLUTIONS 34265 AP 2203 09/30/2014 Payroll Accrual @ 9/30/14 11,335.09 453,802.04 PR 2204 09/30/2014 Sept A/P Temp Receptionist 384.00 454,186.04 TRINITY EMPLOYMENT SOLUTIONS 34265 AP 2204 09/30/2014 Sept A/P Temp Receptionist 256.00 454,442.04 TRINITY EMPLOYMENT SOLUTIONS 34265 AP _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 46,119.97 454,442.04 ** 458,721.00 Budgeted 4,278.96 Remaining 99 % Used Account: 135-50010-030-000 Overtime 2062 09/12/2014 MUD Payroll 9/12/14 Overtime 884.28 19.29 903.57 PR 2135 09/26/2014 MUD Payroll 9/26/14 Overtime 3.68 907.25 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 16.05 923.30 PR _______________ Account: 135-50010-030-000 Overtime Totals: 39.02 923.30 ** 750.00 Budgeted (173.30) Remaining 123 % Used Account: 135-50016-030-000 Longevity 3,077.50 .00 3,077.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,077.50 ** 3,018.00 Budgeted (59.50) Remaining 102 % Used Account: 135-50020-030-000 Retirement 2062 09/12/2014 MUD Payroll 9/12/14 Retirement 37,536.04 1,454.65 38,990.69 PR 2135 09/26/2014 MUD Payroll 9/26/14 Retirement 1,452.71 40,443.40 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 1,019.31 41,462.71 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,926.67 41,462.71 ** 41,419.00 Budgeted (43.71) Remaining 100 % Used Account: 135-50026-030-000 Medical Insurance 2062 09/12/2014 MUD Payroll 9/12/14 Medical Insurance 51,176.38 2,105.76 53,282.14 PR 2135 09/26/2014 MUD Payroll 9/26/14 Medical Insurance 2,105.72 55,387.86 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 1,475.93 56,863.79 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,687.41 56,863.79 ** 57,923.00 Budgeted 1,059.21 Remaining 98 % Used Account: 135-50027-030-000 Dental Insurance 2062 09/12/2014 MUD Payroll 9/12/14 Dental Insurance 3,755.54 153.82 3,909.36 PR 2135 09/26/2014 MUD Payroll 9/26/14 Dental Insurance 153.85 4,063.21 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 107.70 4,170.91 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 415.37 4,170.91 ** 5,100.00 Budgeted 929.09 Remaining 82 % Used Account: 135-50028-030-000 Vision Insurance 2062 09/12/2014 MUD Payroll 9/12/14 Vision Insurance 891.50 36.26 927.76 PR 2135 09/26/2014 MUD Payroll 9/26/14 Vision Insurance 36.31 964.07 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 25.41 989.48 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 97.98 989.48 ** 1,087.00 Budgeted 97.52 Remaining 91 % Used Account: 135-50029-030-000 Life Insurance & Other 1974 09/01/2014 Sept A/P September Dental, Life, ADD, S 4,276.80 284.59 4,561.39 METLIFE 34137 AP 2161 09/30/2014 Sept A/P Café 125 admin 40.92 4,602.31 BenefitMall 34221 AP 2194 09/30/2014 Sept A/P Rounding adjustment (.06) 4,602.25 Legal Shield 34240 AP 2212 09/30/2014 Adj Insur Bal due to rounding (.02) 4,602.23 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 325.43 4,602.23 ** 5,500.00 Budgeted 897.77 Remaining 84 % Used Account: 135-50030-030-000 Social Security Taxes 2062 09/12/2014 MUD Payroll 9/12/14 Social Security Taxes 24,602.12 948.95 25,551.07 PR 2135 09/26/2014 MUD Payroll 9/26/14 Social Security Taxes 936.93 26,488.00 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 676.77 27,164.77 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,562.65 27,164.77 ** 28,659.00 Budgeted 1,494.23 Remaining 95 % Used Account: 135-50035-030-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2062 09/12/2014 MUD Payroll 9/12/14 Medicare Taxes 5,753.74 221.93 5,975.67 PR 2135 09/26/2014 MUD Payroll 9/26/14 Medicare Taxes 219.11 6,194.78 PR 2203 09/30/2014 Payroll Accrual @ 9/30/14 158.29 6,353.07 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 599.33 6,353.07 ** 6,702.00 Budgeted 348.93 Remaining 95 % Used Account: 135-50040-030-000 Unemployment Taxes 2203 09/30/2014 Payroll Accrual @ 9/30/14 1,449.00 .30 1,449.30 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .30 1,449.30 ** 1,449.00 Budgeted (.30) Remaining 100 % Used Account: 135-50045-030-000 Workman's Compensation 59 09/01/2014 Sep Ins & W/C Expense 1,414.89 128.62 1,543.51 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.62 1,543.51 ** 1,575.00 Budgeted 31.49 Remaining 98 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 2204 09/30/2014 Sept A/P Pre-employment testing 88.45 88.45 FIRST CHECK APPLICANT SCREENIN 34230 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 88.45 88.45 ** 200.00 Budgeted 111.55 Remaining 44 % Used Account: 135-50070-030-000 Employee Relations 2193 09/26/2014 8/27-9/26/14 PCards CHICK-FIL-A #02892 2,732.68 114.50 2,847.18 CHICK-FIL-A #02892 PC 2193 09/26/2014 8/27-9/26/14 PCards AMAZON.COM 37.61 2,884.79 AMAZON.COM PC 2193 09/26/2014 8/27-9/26/14 PCards RANDALLS STORE00017897 28.96 2,913.75 RANDALLS STORE00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 181.07 2,913.75 ** 5,000.00 Budgeted 2,086.25 Remaining 58 % Used Account: 135-55030-030-000 Software & Support 2120 09/19/2014 Sept A/P Charter, Gexa, Verizon 45,801.22 645.50 46,446.72 TOWN OF TROPHY CLUB 34197 AP 2120 09/19/2014 Sept A/P Support 659.38 47,106.10 STW INC 34192 AP 2204 09/30/2014 Sept A/P BOA PCards 166.35 47,272.45 TOWN OF TROPHY CLUB 34264 AP 2204 09/30/2014 Sept A/P BOA PCards 2/28-3/27, Credit 1 356.37 47,628.82 TOWN OF TROPHY CLUB 34264 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2204 09/30/2014 Sept A/P BOA PCards 2/28-3/27, Credit 1 45,801.22 (582.37) 47,046.45 TOWN OF TROPHY CLUB 34264 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 1,245.23 47,046.45 ** 59,698.00 Budgeted 12,651.55 Remaining 79 % Used Account: 135-55070-030-000 Independent Labor 2066 09/09/2014 Sept A/P Symonds, SHI, Acclaim 8,454.78 62.50 8,517.28 TOWN OF TROPHY CLUB 34158 AP 2120 09/19/2014 Sept A/P Record MUD meeting 37.50 8,554.78 JOHN CHARLES HALL 34181 AP 2120 09/19/2014 Sept A/P Record MUD meeting 48.75 8,603.53 MIGUEL CRUZ 34186 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 148.75 8,603.53 ** 7,000.00 Budgeted (1,603.53) Remaining 123 % Used Account: 135-55080-030-000 Maintenance & Repairs 2120 09/19/2014 Sept A/P Rug Service 503.45 94.42 597.87 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Rug Service 95.42 693.29 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Rug Service 95.42 788.71 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Rug Service 95.42 884.13 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Rug Service 95.42 979.55 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Rug Service 95.42 1,074.97 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Rug Service 95.42 1,170.39 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Rug Service 95.42 1,265.81 G & K SERVICES 34173 AP 2120 09/19/2014 Sept A/P Service call-MUD bldg Generato 495.00 1,760.81 ENTECH SALES AND SERVICE INC 34170 AP 2120 09/19/2014 Sept A/P Fuel tanks calibration 225.00 1,985.81 TesTank, Inc. 34195 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 1,482.36 1,985.81 ** 4,500.00 Budgeted 2,514.19 Remaining 44 % Used Account: 135-55100-030-000 Building Maint & Supplies 2120 09/19/2014 Sept A/P Keys, change out codes 2,700.79 325.00 3,025.79 MICHAEL'S KEYS 34185 AP 2193 09/26/2014 8/27-9/26/14 PCards THE HOME DEPOT 6581 136.85 3,162.64 THE HOME DEPOT 6581 PC 2193 09/26/2014 8/27-9/26/14 PCards JOHN DEERE LANDSCAPES2 323.35 3,485.99 JOHN DEERE LANDSCAPES2 PC 2161 09/30/2014 Sept A/P A/C repair 92.00 3,577.99 NORTH TX HEATING & AIR, INC 34250 AP 2204 09/30/2014 Sept A/P Rug Service 95.42 3,673.41 G & K SERVICES 34232 AP 2204 09/30/2014 Sept A/P Rug Service 95.42 3,768.83 G & K SERVICES 34232 AP 2204 09/30/2014 Sept A/P Rug Service 95.42 3,864.25 G & K SERVICES 34232 AP 2204 09/30/2014 Sept A/P Rug Service 95.42 3,959.67 G & K SERVICES 34232 AP 2204 09/30/2014 Sept A/P Rug Service 95.42 4,055.09 G & K SERVICES 34232 AP 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (238.55) 3,816.54 AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 1,115.75 3,816.54 ** 6,500.00 Budgeted 2,683.46 Remaining 59 % Used Account: 135-55120-030-000 Cleaning Services 2120 09/19/2014 Sept A/P August Janitorial Services 15,949.70 1,594.97 17,544.67 MEMBER'S BUILDING MAINTENANCE 34184 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 17,544.67 ** 19,140.00 Budgeted 1,595.33 Remaining 92 % Used Account: 135-55160-030-000 Professional Outside Services 2120 09/19/2014 Sept A/P Analytical Svcs/WWTP Bond 500.00 7,490.00 7,990.00 Standard & Poor's 34191 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 7,490.00 7,990.00 ** 10,000.00 Budgeted 2,010.00 Remaining 80 % Used Account: 135-55161-030-000 Town Personnel Contract 77,048.00 .00 77,048.00 _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 77,048.00 ** 77,048.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 2120 09/19/2014 Sept A/P August Late notices 6,744.24 200.30 6,944.54 DATAPROSE LLC 34168 AP 2204 09/30/2014 Sept A/P September water billing 793.85 7,738.39 DATAPROSE LLC 34227 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 994.15 7,738.39 ** 6,808.00 Budgeted (930.39) Remaining 114 % Used Account: 135-60005-030-000 Telephone 2120 09/19/2014 Sept A/P Answering service 11,693.40 180.00 11,873.40 KEYSTONE PARK SECRETARIAL 34182 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2204 09/30/2014 Sept A/P BOA PCards 11,693.40 860.86 12,734.26 TOWN OF TROPHY CLUB 34264 AP 2204 09/30/2014 Sept A/P BOA PCards 2/28-3/27, Credit 1 871.80 13,606.06 TOWN OF TROPHY CLUB 34264 AP 2204 09/30/2014 Sept A/P BOA PCards 2/28-3/27, Credit 1 (936.89) 12,669.17 TOWN OF TROPHY CLUB 34264 AP _______________ Account: 135-60005-030-000 Telephone Totals: 975.77 12,669.17 ** 11,250.00 Budgeted (1,419.17) Remaining 113 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 2120 09/19/2014 Sept A/P Charter, Gexa, Verizon 3,340.58 37.99 3,378.57 TOWN OF TROPHY CLUB 34197 AP 2135 09/26/2014 MUD Payroll 9/26/14 Communications/Pagers/Mobiles 300.00 3,678.57 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 337.99 3,678.57 ** 4,057.00 Budgeted 378.43 Remaining 91 % Used Account: 135-60020-030-000 Electricity/Gas 2120 09/19/2014 Sept A/P Charter, Gexa, Verizon 12,750.50 877.36 13,627.86 TOWN OF TROPHY CLUB 34197 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 877.36 13,627.86 ** 15,171.00 Budgeted 1,543.14 Remaining 90 % Used Account: 135-60025-030-000 Water 2204 09/30/2014 Sept A/P UB Sept water 948.89 209.50 1,158.39 TROPHY CLUB MUD (WATER BILLS) 34266 AP 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (104.75) 1,053.64 AR _______________ Account: 135-60025-030-000 Water Totals: 104.75 1,053.64 ** 1,500.00 Budgeted 446.36 Remaining 70 % Used Account: 135-60035-030-000 Postage 2120 09/19/2014 Sept A/P ofc supplies return 22,463.42 4.43 22,467.85 FEDERAL EXPRESS CORP 34171 AP 2120 09/19/2014 Sept A/P August Late notices 237.60 22,705.45 DATAPROSE LLC 34168 AP 2193 09/26/2014 8/27-9/26/14 PCards USPS 48764506630613152 22.69 22,728.14 USPS 48764506630613152 PC 2161 09/30/2014 Sept A/P Reimburse Petty Cash RG 7.33 22,735.47 TROPHY CLUB MUD PETTY CASH 34267 AP 2194 09/30/2014 Sept A/P Pitney Bowes, Nevill 145.50 22,880.97 TOWN OF TROPHY CLUB 34264 AP 2204 09/30/2014 Sept A/P September water billing 1,536.53 24,417.50 DATAPROSE LLC 34227 AP 2206 09/30/2014 MUD Postage Meter usage/Sept 170.15 24,587.65 GL _______________ Account: 135-60035-030-000 Postage Totals: 2,124.23 24,587.65 ** 28,500.00 Budgeted 3,912.35 Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees 2120 09/19/2014 Sept A/P P/R Taxes penalty 30,826.66 702.97 31,529.63 INTERNAL REVENUE SERVICE 34179 AP 2159 09/19/2014 FF Bank Aug Account Analysis 250.00 31,779.63 GL 2200 09/30/2014 Sep UB Online Credit Card fees 52.34 31,831.97 GL 2200 09/30/2014 Sep UB Online Credit Card fees 103.90 31,935.87 GL 2200 09/30/2014 Sep UB Online Credit Card fees 3,805.70 35,741.57 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,914.91 35,741.57 ** 28,330.00 Budgeted (7,411.57) Remaining 126 % Used Account: 135-60050-030-000 Bad Debt Expense 2179 09/30/2014 UB 9/30/14 Write Offs UB20140930-20140930 User: 4,351.64 97.63 4,449.27 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 97.63 4,449.27 ** 6,200.00 Budgeted 1,750.73 Remaining 72 % Used Account: 135-60055-030-000 Insurance 59 09/01/2014 Sep Ins & W/C Expense 47,295.28 4,269.73 51,565.01 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,269.73 51,565.01 ** 53,561.00 Budgeted 1,995.99 Remaining 96 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 401.08 .00 401.08 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 401.08 ** 1,000.00 Budgeted 598.92 Remaining 40 % Used Account: 135-60070-030-000 Dues & Memberships 4,571.95 .00 4,571.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,571.95 ** 4,500.00 Budgeted (71.95) Remaining 102 % Used Account: 135-60075-030-000 Meetings 27.26 .00 27.26 _______________ Account: 135-60075-030-000 Meetings Totals: .00 27.26 ** 400.00 Budgeted 372.74 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60079-030-000 Public Education 274.83 .00 274.83 _______________ Account: 135-60079-030-000 Public Education Totals: .00 274.83 ** 5,000.00 Budgeted 4,725.17 Remaining 5 % Used Account: 135-60080-030-000 Schools & Training 2,614.25 .00 2,614.25 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,614.25 ** 6,800.00 Budgeted 4,185.75 Remaining 38 % Used Account: 135-60100-030-000 Travel & per diem 2062 09/12/2014 MUD Payroll 9/12/14 Travel & per diem 3,209.96 30.58 3,240.54 PR 2135 09/26/2014 MUD Payroll 9/26/14 Travel & per diem 6.72 3,247.26 PR 2161 09/30/2014 Sept A/P Reimburse Petty Cash RG 30.12 3,277.38 TROPHY CLUB MUD PETTY CASH 34267 AP 2201 09/30/2014 Sept A/P Mileage reimbursement 49.95 3,327.33 LAURIE SLAGHT 34215 AP 2203 09/30/2014 Payroll Accrual @ 9/30/14 25.09 3,352.42 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 142.46 3,352.42 ** 5,000.00 Budgeted 1,647.58 Remaining 67 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 2161 09/30/2014 Sept A/P Reimburse Petty Cash RG 3,709.19 5.00 3,714.19 TROPHY CLUB MUD PETTY CASH 34267 AP _______________ Account: 135-60115-030-000 Elections Totals: 5.00 3,714.19 ** 2,500.00 Budgeted (1,214.19) Remaining 149 % Used Account: 135-60125-030-000 Advertising 2161 09/30/2014 Sept A/P Online Classified Ad, Water Su 1,778.93 150.00 1,928.93 TX MUNICIPAL LEAGUE 34269 AP _______________ Account: 135-60125-030-000 Advertising Totals: 150.00 1,928.93 ** 2,500.00 Budgeted 571.07 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60235-030-000 Security 123.56 .00 123.56 _______________ Account: 135-60235-030-000 Security Totals: .00 123.56 ** 1,350.00 Budgeted 1,226.44 Remaining 9 % Used Account: 135-60245-030-000 Miscellaneous Expenses 2120 09/19/2014 Sept A/P Shredder 2,066.40 1,757.56 3,823.96 OFFICE DEPOT, INC 34187 AP 2193 09/26/2014 8/27-9/26/14 PCards TARRANTCOTX CLERK GRMC 1.00 3,824.96 TARRANTCOTX CLERK GRMC PC 2193 09/26/2014 8/27-9/26/14 PCards TARRANTCOTX CC GRM CNT 32.00 3,856.96 TARRANTCOTX CC GRM CNT PC 2193 09/26/2014 8/27-9/26/14 PCards VCN*DENTONRECCTR 61.00 3,917.96 VCN*DENTONRECCTR PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 1,851.56 3,917.96 ** 17,870.00 Budgeted 13,952.04 Remaining 22 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 16,525.00 .00 16,525.00 _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: .00 16,525.00 ** .00 Budgeted (16,525.00) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 2,563.55 .00 2,563.55 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 2,563.55 ** 2,500.00 Budgeted (63.55) Remaining 103 % Used Account: 135-65010-030-000 Uniforms 998.90 .00 998.90 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 998.90 ** 1,390.00 Budgeted 391.10 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65055-030-000 Hardware 2066 09/09/2014 Sept A/P Symonds, SHI, Acclaim 7,895.10 4.10 7,899.20 TOWN OF TROPHY CLUB 34158 AP 2204 09/30/2014 Sept A/P BOA PCards 548.45 8,447.65 TOWN OF TROPHY CLUB 34264 AP 2204 09/30/2014 Sept A/P BOA PCards 2/28-3/27, Credit 1 (233.58) 8,214.07 TOWN OF TROPHY CLUB 34264 AP _______________ Account: 135-65055-030-000 Hardware Totals: 318.97 8,214.07 ** 13,562.00 Budgeted 5,347.93 Remaining 61 % Used Account: 135-65085-030-000 Office Supplies 2120 09/19/2014 Sept A/P Office Supplies 5,878.91 125.48 6,004.39 OFFICE DEPOT, INC 34187 AP 2120 09/19/2014 Sept A/P Office Supplies 5.89 6,010.28 OFFICE DEPOT, INC 34187 AP 2120 09/19/2014 Sept A/P Office supplies 90.75 6,101.03 OFFICE DEPOT, INC 34187 AP 2193 09/26/2014 8/27-9/26/14 PCards WEXLER PACKAGING PRODU 136.58 6,237.61 WEXLER PACKAGING PRODU PC 2193 09/26/2014 8/27-9/26/14 PCards AMAZON.COM 23.42 6,261.03 AMAZON.COM PC 2204 09/30/2014 Sept A/P Chase PCards-Copy paper 49.74 6,310.77 TOWN OF TROPHY CLUB 34264 AP 2204 09/30/2014 Sept A/P Office Supplies 95.00 6,405.77 OFFICE DEPOT, INC 34251 AP 2204 09/30/2014 Sept A/P Office supplies 9.66 6,415.43 OFFICE DEPOT, INC 34251 AP 2210 09/30/2014 Town Billing Inv 1206-1216 AR 20140901-20141001 User: (88.70) 6,326.73 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 447.82 6,326.73 ** 9,100.00 Budgeted 2,773.27 Remaining 70 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 4,323.06 .00 4,323.06 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 4,323.06 ** 5,732.00 Budgeted 1,408.94 Remaining 75 % Used Account: 135-65095-030-000 Maintenance Supplies 2193 09/26/2014 8/27-9/26/14 PCards WAL-MART #0266 2,849.96 110.24 2,960.20 WAL-MART #0266 PC 2193 09/26/2014 8/27-9/26/14 PCards SAMS CLUB #4795 149.85 3,110.05 SAMS CLUB #4795 PC 2193 09/26/2014 8/27-9/26/14 PCards AMAZON.COM 3.55 3,113.60 AMAZON.COM PC 2193 09/26/2014 8/27-9/26/14 PCards GREAT COFFEES OF AMERI 77.04 3,190.64 GREAT COFFEES OF AMERI PC 2193 09/26/2014 8/27-9/26/14 PCards AMAZON.COM 28.76 3,219.40 AMAZON.COM PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 369.44 3,219.40 ** 2,500.00 Budgeted (719.40) Remaining 129 % Used Account: 135-65097-030-000 Vending Machine Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 76.96 .00 76.96 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 76.96 ** 200.00 Budgeted 123.04 Remaining 38 % Used Account: 135-65105-030-000 Printing 3,424.27 .00 3,424.27 _______________ Account: 135-65105-030-000 Printing Totals: .00 3,424.27 ** 4,000.00 Budgeted 575.73 Remaining 86 % Used Account: 135-69170-030-000 Copier Lease Installments 2194 09/30/2014 Sept A/P Pitney Bowes, Nevill 2,371.95 278.33 2,650.28 TOWN OF TROPHY CLUB 34264 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 278.33 2,650.28 ** 3,450.00 Budgeted 799.72 Remaining 77 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 994,439.59 ** 1,056,620.00 Budgeted 62,180.41 Remaining 94 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 2146 09/01/2014 Reclassify Legal Reclassify Legal 518,486.18 (58,270.97) 460,215.21 GL 2146 09/01/2014 Reclassify Legal Reclassify Legal (8,477.80) 451,737.41 GL 2146 09/01/2014 Reclassify Legal Reclassify Legal (333,679.95) 118,057.46 GL 2146 09/01/2014 Reclassify Legal Reclassify Legal (29,456.49) 88,600.97 GL 2146 09/01/2014 Reclassify Legal Reclassify Legal (29,800.40) 58,800.57 GL 2146 09/01/2014 Reclassify Legal Reclassify Legal (8,152.20) 50,648.37 GL 2146 09/01/2014 Reclassify Legal Reclassify Legal (31,116.90) 19,531.47 GL 2146 09/01/2014 Reclassify Legal Reclassify Legal (19,531.47) .00 GL 2178 09/30/2014 Liston/Unused Legal Retainer (35,239.28) (35,239.28) GL 2213 09/30/2014 Recode Liston Unused Retainer 35,239.28 .00 GL _______________ Account: 135-55045-039-000 Legal Totals: (518,486.18) .00 ** 347,126.00 Budgeted 347,126.00 Remaining 0 % Used Account: 135-55055-039-000 Auditing 2057 09/08/2014 Sept A/P 2013-14 Audit Retainer 21,200.00 5,000.00 26,200.00 LAFOLLETT & ABBOTT PLLC 34133 AP _______________ Account: 135-55055-039-000 Auditing Totals: 5,000.00 26,200.00 ** 21,840.00 Budgeted (4,360.00) Remaining 120 % Used Account: 135-55060-039-000 Appraisal 2057 09/08/2014 Sept A/P Final payment 4th qtr 2014 bud 8,158.30 1,914.46 10,072.76 DENTON CENTRAL APPRAISAL DISTR 34117 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,914.46 10,072.76 ** 10,000.00 Budgeted (72.76) Remaining 101 % Used Account: 135-55065-039-000 Tax Admin Fees 2,451.40 .00 2,451.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,451.40 ** 3,800.00 Budgeted 1,348.60 Remaining 65 % Used Account: 135-55045-039-001 Legal/General 2146 09/01/2014 Reclassify Legal Reclassify Legal- General 58,270.97 58,270.97 GL 2120 09/19/2014 Sept A/P August legal/General 103.10 58,374.07 WHITAKER CHALK SWINDLE 34200 AP 2204 09/30/2014 Sept A/P Legal 100.80 58,474.87 WHITAKER CHALK SWINDLE 34271 AP 2204 09/30/2014 Sept A/P Sept Legal 302.50 58,777.37 FREEMAN & CORBETT 34231 AP 2213 09/30/2014 Recode Liston Unused Retainer (35,239.28) 23,538.09 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 1 General Legal Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2214 09/30/2014 Sept A/P September legal 2,589.25 26,127.34 THE LISTON LAW FIRM, P.C. AP _______________ Account: 135-55045-039-001 Legal/General Totals: 26,127.34 26,127.34 ** .00 Budgeted (26,127.34) Remaining 0 % Used Account: 135-55045-039-002 Legal/Contracts & ILAs 2146 09/01/2014 Reclassify Legal Reclassify Legal/Contracts 8,477.80 8,477.80 GL 2204 09/30/2014 Sept A/P Sept Legal 1,485.00 9,962.80 FREEMAN & CORBETT 34231 AP 2214 09/30/2014 Sept A/P September legal 82.50 10,045.30 THE LISTON LAW FIRM, P.C. AP _______________ Account: 135-55045-039-002 Legal/Contracts & ILAs Totals: 10,045.30 10,045.30 ** .00 Budgeted (10,045.30) Remaining 0 % Used Account: 135-55045-039-003 Legal/WWTP Bonds 2146 09/01/2014 Reclassify Legal Reclassify Legal/ WWTP Bonds 333,679.95 333,679.95 GL 2120 09/19/2014 Sept A/P Legal/WWTP Bonds 67.20 333,747.15 WHITAKER CHALK SWINDLE 34200 AP 2120 09/19/2014 Sept A/P Legal 125,518.38 459,265.53 Fulbright & Jaworski LLP 34172 AP 2204 09/30/2014 Sept A/P Sept Legal 3,795.00 463,060.53 FREEMAN & CORBETT 34231 AP 2214 09/30/2014 Sept A/P September legal 577.50 463,638.03 THE LISTON LAW FIRM, P.C. AP _______________ Account: 135-55045-039-003 Legal/WWTP Bonds Totals: 463,638.03 463,638.03 ** .00 Budgeted (463,638.03) Remaining 0 % Used Account: 135-55045-039-004 Legal/Land Access WWTP 2146 09/01/2014 Reclassify Legal Reclassify Legal/Land Access 29,456.49 29,456.49 GL 2120 09/19/2014 Sept A/P Legal/Land Access WWTP 994.00 30,450.49 WHITAKER CHALK SWINDLE 34200 AP 2204 09/30/2014 Sept A/P Legal 4,033.00 34,483.49 WHITAKER CHALK SWINDLE 34271 AP 2214 09/30/2014 Sept A/P September legal 110.00 34,593.49 THE LISTON LAW FIRM, P.C. AP _______________ Account: 135-55045-039-004 Legal/Land Access WWTP Totals: 34,593.49 34,593.49 ** .00 Budgeted (34,593.49) Remaining 0 % Used Account: 135-55045-039-005 Legal/PID Contract 2146 09/01/2014 Reclassify Legal Reclassify Legal/PID Contract 29,800.40 29,800.40 GL _______________ Account: 135-55045-039-005 Legal/PID Contract Totals: 29,800.40 29,800.40 ** .00 Budgeted (29,800.40) Remaining 0 % Used Account: 135-55045-039-006 Legal/Open Records Requests . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 6 Open Records Requests Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2146 09/01/2014 Reclassify Legal Reclassify Legal/ORR 8,152.20 8,152.20 GL _______________ Account: 135-55045-039-006 Legal/Open Records Requests Totals: 8,152.20 8,152.20 ** .00 Budgeted (8,152.20) Remaining 0 % Used Account: 135-55045-039-007 Legal/Consolidation & Westlake 2146 09/01/2014 Reclassify Legal Reclassify Legal/Westlake 31,116.90 31,116.90 GL _______________ Account: 135-55045-039-007 Legal/Consolidation & Westlake Totals: 31,116.90 31,116.90 ** .00 Budgeted (31,116.90) Remaining 0 % Used Account: 135-55045-039-008 Legal/CCN 2146 09/01/2014 Reclassify Legal Reclassify Legal/CCN 19,531.47 19,531.47 GL _______________ Account: 135-55045-039-008 Legal/CCN Totals: 19,531.47 19,531.47 ** .00 Budgeted (19,531.47) Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 661,729.29 ** 382,766.00 Budgeted (278,963.29) Remaining 173 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 505,997.46 .00 Budgeted (505,997.46) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 2192 09/30/2014 Bank Interest/September (82.83) (4.18) (87.01) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (4.18) (87.01) ** .00 Budgeted 87.01 Remaining 0 % Used Account: 507-49036-000-000 GASB Reserves (120,000.00) .00 (120,000.00) _______________ Account: 507-49036-000-000 GASB Reserves Totals: .00 (120,000.00) ** .00 Budgeted 120,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (120,087.01) ** .00 Budgeted 120,087.01 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 .00 82,629.40 _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: .00 82,629.40 ** .00 Budgeted (82,629.40) Remaining 0 % Used Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 2110 09/11/2014 Retainage App 3/Ind Crk/Meadow 137,142.00 4,539.95 141,681.95 GL 2120 09/19/2014 Sept A/P App 3 Indian Crk to Meadowbroo 86,259.05 227,941.00 The Fain Group, Inc 34202 AP 2208 09/30/2014 Fain Group/Retainage App 4 2,217.45 230,158.45 GL 2209 09/30/2014 Sept A/P Indian Creek/Meadowbrook App 4 42,131.55 272,290.00 The Fain Group, Inc AP _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: 135,148.00 272,290.00 ** 282,245.17 Budgeted 9,955.17 Remaining 96 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 354,919.40 ** 282,245.17 Budgeted (72,674.23) Remaining 126 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 234,832.39 282,245.17 Budgeted 47,412.78 Remaining 83 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET SEPTEMBER 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 10,406 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 9,995 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 25,247 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 9,995 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 9,995 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES (2,626) TOTAL FUND BALANCE 15,253 TOTAL LIABILITIES AND FUND BALANCE 25,247 . glbase_tbam rgonzale Trophy Club MUD #1 Page 29 09:30 10/15/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 389,216.00- 389,216.00- 252.41- 386,992.15- 99.429 2,223.85- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 459.76- 18.390 2,040.24- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 39.68- 2,215.86- 138.491 615.86 Subtotal: 393,316.00- 393,316.00- 292.09- 389,667.77- 99.072 3,648.23- 533-48005-000-000 Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- 100.000 Subtotal: 16,525.00- 16,525.00- 16,525.00- 100.000 533-49010-000-000 Interest Income 375.00- 375.00- .30- 96.93- 25.848 278.07- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- 100.000 Subtotal: 214,654.00- 214,654.00- .30- 214,375.93- 99.870 278.07- Program number: 624,495.00- 624,495.00- 292.39- 620,568.70- 99.371 3,926.30- Department number: Revenues 624,495.00- 624,495.00- 292.39- 620,568.70- 99.371 3,926.30- Revenues Subtotal -------- 624,495.00- 624,495.00- 292.39- 620,568.70- 99.371 3,926.30- . glbase_tbam rgonzale Trophy Club MUD #1 Page 30 09:30 10/15/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 1,000.00 43.478 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 197,195.00 197,195.00 197,195.00 100.000 533-70035-051-000 Bond Principal Payment-Tax 425,000.00 425,000.00 425,000.00 100.000 Subtotal: 624,495.00 624,495.00 623,195.00 99.792 1,300.00 Program number: 624,495.00 624,495.00 623,195.00 99.792 1,300.00 Department number: Administration 624,495.00 624,495.00 623,195.00 99.792 1,300.00 Expenditures Subtotal -------- 624,495.00 624,495.00 623,195.00 99.792 1,300.00 Fund number: 533 MUD 1 I&S Consolidated 292.39- 2,626.30 2,626.30- ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 2181 09/02/2014 Property Taxes/Assessments (386,739.74) (11.55) (386,751.29) GL 2182 09/04/2014 Property Taxes/Assessments (14.95) (386,766.24) GL 2191 09/08/2014 Property Taxes/Assessments (39.11) (386,805.35) GL 2186 09/12/2014 Property Taxes/Assessments (41.53) (386,846.88) GL 2187 09/16/2014 Property Taxes/Assessments (140.55) (386,987.43) GL 2188 09/26/2014 Property Taxes/Assessments (.32) (386,987.75) GL 2189 09/29/2014 Property Taxes/Assessments (4.40) (386,992.15) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (252.41) (386,992.15) ** (389,216.00) Budgeted (2,223.85) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent (459.76) .00 (459.76) _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 (459.76) ** (2,500.00) Budgeted (2,040.24) Remaining 18 % Used Account: 533-40015-000-000 Property Taxes/P & I 2181 09/02/2014 Property Taxes/Assessments (2,176.18) (2.20) (2,178.38) GL 2182 09/04/2014 Property Taxes/Assessments (1.05) (2,179.43) GL 2191 09/08/2014 Property Taxes/Assessments (7.38) (2,186.81) GL 2187 09/16/2014 Property Taxes/Assessments (28.11) (2,214.92) GL 2188 09/26/2014 Property Taxes/Assessments (.06) (2,214.98) GL 2189 09/29/2014 Property Taxes/Assessments (.88) (2,215.86) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (39.68) (2,215.86) ** (1,600.00) Budgeted 615.86 Remaining 138 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees (16,525.00) .00 (16,525.00) _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 (16,525.00) ** (16,525.00) Budgeted .00 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 2192 09/30/2014 Bank Interest/September (96.63) (.30) (96.93) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (.30) (96.93) ** (375.00) Budgeted (278.07) Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49015-000-000 Lease/Rental Income (214,279.00) .00 (214,279.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,279.00) ** (214,279.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (620,568.70) ** (624,495.00) Budgeted (3,926.30) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 09:30 10/15/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance 1,000.00 .00 1,000.00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 1,000.00 ** 2,300.00 Budgeted 1,300.00 Remaining 43 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 197,195.00 .00 197,195.00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 197,195.00 ** 197,195.00 Budgeted .00 Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 425,000.00 .00 425,000.00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 425,000.00 ** 425,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 623,195.00 ** 624,495.00 Budgeted 1,300.00 Remaining 100 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ 2,626.30 .00 Budgeted (2,626.30) Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 761,563.25 **** 282,245.17 Budgeted (479,318.08) Remaining 270 % Used ******* End of Report *********