Loading...
HomeMy WebLinkAbout2015-10 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2015 122 ASSETS FIRE DEPT. INVESTMENTS 277,140 PREPAID EXPENSES 12,904 ADVALOREM PROPERTY TAXES RECEIVABLE 897,122 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 346 UTILITY AND OTHER ACCOUNTS RECEIVABLE 3,926 TOTAL ASSETS 1,191,438 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 897,468 ACCOUNTS AND OTHER PAYABLES 9,378 TOTAL LIABILITIES 906,846 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (248,905) TOTAL FUND BALANCE 284,592 TOTAL LIABILITIES AND FUND BALANCE 1,191,438 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 10:49 11/12/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 404,346.00- 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 5,250.27- 5,250.27- .590 884,712.73- 122-40011-000-000 Property Taxes/Fire-Delinquent 124.64- 124.64- 124.64 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 67.00- 67.00- 1.489 4,433.00- Subtotal: 1,299,559.00- 1,299,559.00- 5,441.91- 5,441.91- .419 1,294,117.09- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 800.00- 800.00- 16.000 4,200.00- Subtotal: 5,000.00- 5,000.00- 800.00- 800.00- 16.000 4,200.00- 122-43400-000-000 Fire Inspections 825.00- 825.00- 150.00- 150.00- 18.182 675.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,825.00- 10,825.00- 150.00- 150.00- 1.386 10,675.00- 122-49900-000-000 Miscellaneous Income 50,000.00- 50,000.00- 2,100.00- 2,100.00- 4.200 47,900.00- Subtotal: 50,000.00- 50,000.00- 2,100.00- 2,100.00- 4.200 47,900.00- Program number: 1,365,384.00- 1,365,384.00- 8,491.91- 8,491.91- .622 1,356,892.09- Department number: Fire Revenues 1,365,384.00- 1,365,384.00- 8,491.91- 8,491.91- .622 1,356,892.09- Revenues Subtotal ----------- 1,365,384.00- 1,365,384.00- 8,491.91- 8,491.91- .622 1,356,892.09- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 10:49 11/12/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 508,226.00 508,226.00 21,844.96 21,844.96 4.298 486,381.04 122-50010-045-000 Overtime 48,735.00 48,735.00 5,417.16 5,417.16 11.116 43,317.84 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 15,852.00 122-50016-045-000 Longevity 5,761.00 5,761.00 5,761.00 122-50017-045-000 Certification 4,200.00 4,200.00 77.63 77.63 1.848 4,122.37 122-50020-045-000 Retirement 75,571.00 75,571.00 3,701.76 3,701.76 4.898 71,869.24 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 2,512.01 2,512.01 3.832 63,033.99 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 233.60 233.60 4.782 4,651.40 122-50028-045-000 Vision Insurance 859.00 859.00 44.90 44.90 5.227 814.10 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 210.53 210.53 4.592 4,374.47 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 1,572.96 1,572.96 4.353 34,559.04 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 367.75 367.75 4.352 8,082.25 122-50040-045-000 Unemployment Taxes 1,724.00 1,724.00 .45 .45 .026 1,723.55 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 9,379.00 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 250.00 Subtotal: 790,155.00 790,155.00 35,983.71 35,983.71 4.554 754,171.29 122-55030-045-000 Software & Support 6,661.00 6,661.00 462.50 462.50 6.943 6,198.50 122-55045-045-000 Legal 2,000.00 2,000.00 2,000.00 122-55080-045-000 Maintenance & Repairs 16,370.00 16,370.00 2,553.55 2,553.55 15.599 13,816.45 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 34.14 34.14 .341 9,965.86 Subtotal: 35,031.00 35,031.00 3,050.19 3,050.19 8.707 31,980.81 122-60005-045-000 Telephone 50.00 50.00 50.00 122-60010-045-000 Communications/Mobiles 6,653.00 6,653.00 5,246.06 5,246.06 78.853 1,406.94 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 176.65- 176.65- -2.383 7,588.65 122-60025-045-000 Water 1,200.00 1,200.00 258.55- 258.55- -21.546 1,458.55 122-60026-045-000 Cable 1,920.00 1,920.00 153.10 153.10 7.974 1,766.90 122-60030-045-000 Rent And/Or Usage 214,379.00 214,379.00 214,379.00 122-60035-045-000 Postage 50.00 50.00 50.00 122-60055-045-000 Insurance 14,077.00 14,077.00 1,173.09 1,173.09 8.333 12,903.91 122-60066-045-000 Publications/Books/Subscrips 350.00 350.00 350.00 122-60070-045-000 Dues & Memberships 15,582.00 15,582.00 1,651.59 1,651.59 10.599 13,930.41 122-60080-045-000 Schools & Training 7,880.00 7,880.00 340.00 340.00 4.315 7,540.00 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 122-60100-045-000 Travel & per diem 4,081.00 4,081.00 163.89 163.89 4.016 3,917.11 122-60110-045-000 Physicals/Testing 4,700.00 4,700.00 4,700.00 122-60125-045-000 Advertising 500.00 500.00 500.00 122-60160-045-000 Programs & Special Projects 7,500.00 7,500.00 673.62 673.62 8.982 6,826.38 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 165.29 165.29 33.058 334.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 85.00 85.00 2.670 3,099.00 122-60245-045-000 Miscellaneous Expense 1,001.00 1,001.00 7.50 7.50 .749 993.50 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 10:49 11/12/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 292,019.00 292,019.00 9,223.94 9,223.94 3.159 282,795.06 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 489.45 489.45 3.237 14,632.55 122-65010-045-000 Uniforms 3,140.00 3,140.00 81.32 81.32 2.590 3,058.68 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 9,000.00 122-65030-045-000 Chemicals 600.00 600.00 600.00 122-65035-045-000 Small Tools 2,000.00 2,000.00 2,000.00 122-65055-045-000 Hardware 750.00 750.00 750.00 122-65085-045-000 Office Supplies 500.00 500.00 500.00 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 31,610.00 570.77 570.77 1.806 31,039.23 122-69050-045-000 Radios 8,000.00 8,000.00 8,000.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 127,148.60 100.000 .40 Subtotal: 216,569.00 216,569.00 208,568.60 208,568.60 96.306 8,000.40 Program number: 1,365,384.00 1,365,384.00 257,397.21 257,397.21 18.852 1,107,986.79 Department number: Fire 1,365,384.00 1,365,384.00 257,397.21 257,397.21 18.852 1,107,986.79 Expenditures Subtotal ----------- 1,365,384.00 1,365,384.00 257,397.21 257,397.21 18.852 1,107,986.79 Fund number: 122 Trophy Club MUD Fire Dept. 248,905.30 248,905.30 248,905.30- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs .00 .00 _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 .00 ** (404,346.00) Budgeted (404,346.00) Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 188 10/09/2015 Property Taxes (651.82) (651.82) GL 190 10/13/2015 Property Taxes (6.20) (658.02) GL 191 10/15/2015 Property Taxes (401.42) (1,059.44) GL 192 10/16/2015 Property Taxes (417.42) (1,476.86) GL 193 10/19/2015 Property Taxes (223.21) (1,700.07) GL 194 10/20/2015 Property Taxes (240.71) (1,940.78) GL 195 10/21/2015 Property Taxes (534.82) (2,475.60) GL 196 10/26/2015 Property Taxes (940.63) (3,416.23) GL 197 10/27/2015 Property Taxes (135.65) (3,551.88) GL 198 10/28/2015 Property Taxes (179.30) (3,731.18) GL 199 10/29/2015 Property Taxes (909.65) (4,640.83) GL 238 10/30/2015 Property Taxes (609.44) (5,250.27) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (5,250.27) (5,250.27) ** (889,963.00) Budgeted (884,712.73) Remaining 1 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 182 10/02/2015 Property Taxes (334.22) (334.22) GL 187 10/08/2015 Property Taxes (.16) (334.38) GL 189 10/12/2015 Property Taxes 147.54 (186.84) GL 197 10/27/2015 Property Taxes 19.63 (167.21) GL 198 10/28/2015 Property Taxes 42.57 (124.64) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (124.64) (124.64) ** .00 Budgeted 124.64 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I .00 .00 _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 .00 ** (750.00) Budgeted (750.00) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 182 10/02/2015 Property Taxes (66.98) (66.98) GL 187 10/08/2015 Property Taxes (.02) (67.00) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (67.00) (67.00) ** (4,500.00) Budgeted (4,433.00) Remaining 1 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (800.00) (800.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (800.00) (800.00) ** (5,000.00) Budgeted (4,200.00) Remaining 16 % Used Account: 122-43400-000-000 Fire Inspections 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (150.00) (150.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (150.00) (150.00) ** (825.00) Budgeted (675.00) Remaining 18 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (2,100.00) (2,100.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (2,100.00) (2,100.00) ** (50,000.00) Budgeted (47,900.00) Remaining 4 % Used Department Totals: ------------------------------------------------------------------------------------------------ (8,491.91) ** (1,365,384.00) Budgeted (1,356,892.09) Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 48 10/09/2015 FD Payroll Oct 1-3/15 3,828.52 3,828.52 GL 113 10/23/2015 Fire Dept Payroll 10/23/15 18,016.44 21,844.96 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 21,844.96 21,844.96 ** 508,226.00 Budgeted 486,381.04 Remaining 4 % Used Account: 122-50010-045-000 Overtime 113 10/23/2015 Fire Dept Payroll 10/23/15 5,417.16 5,417.16 GL _______________ Account: 122-50010-045-000 Overtime Totals: 5,417.16 5,417.16 ** 48,735.00 Budgeted 43,317.84 Remaining 11 % Used Account: 122-50011-045-000 DPS Holiday Pay .00 .00 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 .00 ** 15,852.00 Budgeted 15,852.00 Remaining 0 % Used Account: 122-50016-045-000 Longevity .00 .00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 .00 ** 5,761.00 Budgeted 5,761.00 Remaining 0 % Used Account: 122-50017-045-000 Certification 48 10/09/2015 FD Payroll Oct 1-3/15 77.63 77.63 GL _______________ Account: 122-50017-045-000 Certification Totals: 77.63 77.63 ** 4,200.00 Budgeted 4,122.37 Remaining 2 % Used Account: 122-50020-045-000 Retirement 48 10/09/2015 FD Payroll Oct 1-3/15 533.54 533.54 GL 113 10/23/2015 Fire Dept Payroll 10/23/15 3,168.22 3,701.76 GL _______________ Account: 122-50020-045-000 Retirement Totals: 3,701.76 3,701.76 ** 75,571.00 Budgeted 71,869.24 Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 48 10/09/2015 FD Payroll Oct 1-3/15 592.38 592.38 GL 113 10/23/2015 Fire Dept Payroll 10/23/15 1,919.63 2,512.01 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 2,512.01 2,512.01 ** 65,546.00 Budgeted 63,033.99 Remaining 4 % Used Account: 122-50027-045-000 Dental Insurance 48 10/09/2015 FD Payroll Oct 1-3/15 41.19 41.19 GL 113 10/23/2015 Fire Dept Payroll 10/23/15 192.41 233.60 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 233.60 233.60 ** 4,885.00 Budgeted 4,651.40 Remaining 5 % Used Account: 122-50028-045-000 Vision Insurance 48 10/09/2015 FD Payroll Oct 1-3/15 7.87 7.87 GL 113 10/23/2015 Fire Dept Payroll 10/23/15 37.03 44.90 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 44.90 44.90 ** 859.00 Budgeted 814.10 Remaining 5 % Used Account: 122-50029-045-000 Life Insurance & Other 48 10/09/2015 FD Payroll Oct 1-3/15 37.04 37.04 GL 113 10/23/2015 Fire Dept Payroll 10/23/15 173.49 210.53 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 210.53 210.53 ** 4,585.00 Budgeted 4,374.47 Remaining 5 % Used Account: 122-50030-045-000 Social Security Taxes 48 10/09/2015 FD Payroll Oct 1-3/15 220.62 220.62 GL 113 10/23/2015 Fire Dept Payroll 10/23/15 1,352.34 1,572.96 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 1,572.96 1,572.96 ** 36,132.00 Budgeted 34,559.04 Remaining 4 % Used Account: 122-50035-045-000 Medicare Taxes 48 10/09/2015 FD Payroll Oct 1-3/15 51.52 51.52 GL 113 10/23/2015 Fire Dept Payroll 10/23/15 316.23 367.75 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 367.75 367.75 ** 8,450.00 Budgeted 8,082.25 Remaining 4 % Used Account: 122-50040-045-000 Unemployment Taxes 48 10/09/2015 FD Payroll Oct 1-3/15 .10 .10 GL 113 10/23/2015 Fire Dept Payroll 10/23/15 .35 .45 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .45 .45 ** 1,724.00 Budgeted 1,723.55 Remaining 0 % Used Account: 122-50045-045-000 Workman's Compensation .00 .00 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 .00 ** 9,379.00 Budgeted 9,379.00 Remaining 0 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 98 10/22/2015 October A/P Charter - fire station interne 462.50 462.50 TOWN OF TROPHY CLUB 1103 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 462.50 ** 6,661.00 Budgeted 6,198.50 Remaining 7 % Used Account: 122-55045-045-000 Legal .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 98 10/22/2015 October A/P Replace master link 175.00 175.00 OVERHEAD DOOR FORT WORTH 1098 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 166 10/26/2015 JPChase 9/29-10/26/15 GUINCO SERVICE 366.30 541.30 GUINCO SERVICE PC 166 10/26/2015 JPChase 9/29-10/26/15 BATTERIES PLUS # 8 153.36 694.66 BATTERIES PLUS # 8 PC 166 10/26/2015 JPChase 9/29-10/26/15 SAMS CLUB #4795 309.87 1,004.53 SAMS CLUB #4795 PC 166 10/26/2015 JPChase 9/29-10/26/15 THE HOME DEPOT 6581 99.18 1,103.71 THE HOME DEPOT 6581 PC 166 10/26/2015 JPChase 9/29-10/26/15 TCI #629 892.70 1,996.41 TCI #629 PC 166 10/26/2015 JPChase 9/29-10/26/15 GUINCO SERVICE 139.90 2,136.31 GUINCO SERVICE PC 116 10/28/2015 October A/P Rug cleaning 37.24 2,173.55 G & K SERVICES 1111 AP 116 10/28/2015 October A/P Rug cleaning 37.24 2,210.79 G & K SERVICES 1111 AP 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (37.24) 2,173.55 AR 202 10/31/2015 October A/P Quarterly Pest Control 140.00 2,313.55 GANN'S PEST CONTROL 1140 AP 202 10/31/2015 October A/P Repair Bay Door 240.00 2,553.55 OVERHEAD DOOR FORT WORTH 1154 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 2,553.55 2,553.55 ** 16,370.00 Budgeted 13,816.45 Remaining 16 % Used Account: 122-55090-045-000 Vehicle Maintenance 166 10/26/2015 JPChase 9/29-10/26/15 ROANOKE AUTO SUPPLY LT 34.14 34.14 ROANOKE AUTO SUPPLY LT PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 34.14 34.14 ** 10,000.00 Budgeted 9,965.86 Remaining 0 % Used Account: 122-60005-045-000 Telephone .00 .00 _______________ Account: 122-60005-045-000 Telephone Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 122-60010-045-000 Communications/Mobiles 151 10/01/2015 Reverse Prepaid Dispatcher 4,944.00 4,944.00 GL 48 10/09/2015 FD Payroll Oct 1-3/15 16.06 4,960.06 GL 166 10/26/2015 JPChase 9/29-10/26/15 PRAETORIAN GROUP INC 286.00 5,246.06 PRAETORIAN GROUP INC PC _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 5,246.06 5,246.06 ** 6,653.00 Budgeted 1,406.94 Remaining 79 % Used Account: 122-60020-045-000 Electricity/Gas 66 10/15/2015 October A/P Electricity 10/1-10/9/15 275.22 275.22 HUDSON ENERGY SERVICES, LLC 1072 AP 98 10/22/2015 October A/P Gas for fire station 10/1 - 10 43.20 318.42 ATMOS ENERGY 1089 AP 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (495.07) (176.65) AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60020-045-000 Electricity/Gas Totals: (176.65) (176.65) ** 7,412.00 Budgeted 7,588.65 Remaining -2 % Used Account: 122-60025-045-000 Water 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (258.55) (258.55) AR _______________ Account: 122-60025-045-000 Water Totals: (258.55) (258.55) ** 1,200.00 Budgeted 1,458.55 Remaining -22 % Used Account: 122-60026-045-000 Cable 121 10/15/2015 Firefighter pd Oct Cable (133.82) (133.82) GL 166 10/26/2015 JPChase 9/29-10/26/15 ATT*BILL PAYMENT 128.50 (5.32) ATT*BILL PAYMENT PC 166 10/26/2015 JPChase 9/29-10/26/15 ATT*BILL PAYMENT 158.42 153.10 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 153.10 153.10 ** 1,920.00 Budgeted 1,766.90 Remaining 8 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 214,379.00 Budgeted 214,379.00 Remaining 0 % Used Account: 122-60035-045-000 Postage .00 .00 _______________ Account: 122-60035-045-000 Postage Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 132 10/01/2015 Prepaid Insurance, W/C Oct 1,173.09 1,173.09 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,173.09 1,173.09 ** 14,077.00 Budgeted 12,903.91 Remaining 8 % Used Account: 122-60066-045-000 Publications/Books/Subscrips . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 166 10/26/2015 JPChase 9/29-10/26/15 TX COMM ON FIRE PR 1,651.59 1,651.59 TX COMM ON FIRE PR PC _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 1,651.59 1,651.59 ** 15,582.00 Budgeted 13,930.41 Remaining 11 % Used Account: 122-60080-045-000 Schools & Training 100 10/22/2015 October A/P State testing/certification Si 340.00 340.00 TX COMM ON FIRE PROTECTION 1104 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 340.00 340.00 ** 7,880.00 Budgeted 7,540.00 Remaining 4 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem 166 10/26/2015 JPChase 9/29-10/26/15 VINNYS ITALIAN RESTAUR 163.89 163.89 VINNYS ITALIAN RESTAUR PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 163.89 163.89 ** 4,081.00 Budgeted 3,917.11 Remaining 4 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 7 10/01/2015 October A/P Face painting 3 hrs for open h 275.00 275.00 CAMMI RATLIFF 1029 AP 35 10/08/2015 October A/P Cupcakes & cake for push-in ce 325.00 600.00 DEBBIE MARY ROMA MUNRO 1046 AP 166 10/26/2015 JPChase 9/29-10/26/15 WAL-MART #5247 73.62 673.62 WAL-MART #5247 PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 673.62 673.62 ** 7,500.00 Budgeted 6,826.38 Remaining 9 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 166 10/26/2015 JPChase 9/29-10/26/15 SAMS CLUB #4795 165.29 165.29 SAMS CLUB #4795 PC _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 165.29 165.29 ** 500.00 Budgeted 334.71 Remaining 33 % Used Account: 122-60195-045-000 Flags & Repair 35 10/08/2015 October A/P On site flag repair 170.00 170.00 SYMONDS FLAGS & POLES 1051 AP 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (85.00) 85.00 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 85.00 85.00 ** 3,184.00 Budgeted 3,099.00 Remaining 3 % Used Account: 122-60245-045-000 Miscellaneous Expense 166 10/26/2015 JPChase 9/29-10/26/15 DENTON CO TX MOTOR VEH 7.50 7.50 DENTON CO TX MOTOR VEH PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 7.50 7.50 ** 1,001.00 Budgeted 993.50 Remaining 1 % Used Account: 122-65005-045-000 Fuel & Lube 166 10/26/2015 JPChase 9/29-10/26/15 ROANOKE QUICK STOP 101.11 101.11 ROANOKE QUICK STOP PC 202 10/31/2015 October A/P Fuel October 388.34 489.45 US Bank Voyager Fleet Systems 1166 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 489.45 489.45 ** 15,122.00 Budgeted 14,632.55 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-65010-045-000 Uniforms 202 10/31/2015 October A/P Job Shirt - Hurd 81.32 81.32 RED THE UNIFORM TAILOR 1158 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 81.32 81.32 ** 3,140.00 Budgeted 3,058.68 Remaining 3 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools .00 .00 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-65055-045-000 Hardware .00 .00 _______________ Account: 122-65055-045-000 Hardware Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies .00 .00 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-65105-045-000 Printing . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 498.00 Budgeted 498.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 8,000.00 Budgeted 8,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 235 10/01/2015 GASB 34 transfers Fiscal 2016 Fire Truck Future Replacement 41,420.00 41,420.00 GL 250 10/01/2015 GASB Xfer FD/realloc unassigne 40,000.00 81,420.00 GL _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 66 10/15/2015 October A/P Ladder truck lease T-681 127,148.60 127,148.60 PNC Bank, N.A. 1077 AP _______________ Account: 122-69305-045-000 Capital Leases Totals: 127,148.60 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 257,397.21 ** 1,365,384.00 Budgeted 1,107,986.79 Remaining 19 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 248,905.30 .00 Budgeted (248,905.30) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET OCTOBER 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 10/31/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 730,471 - - 730,471 CD-BANK OF THE WEST/THB DEPOSIT 35,000 35,000 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,509,140 - - 1,509,140 INVESTMENTS-TEXPOOL 1,420,606 326,020 21,464 1,768,090 PREPAID EXPENSES 57,526 - - 57,526 ADVALOREM PROPERTY TAXES RECEIVABLE 59,873 - - 59,873 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,041,146 - - 1,041,146 - TOTAL ASSETS 4,854,363 326,020 21,464 5,201,847 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 59,873 - - 59,873 ACCOUNTS AND OTHER PAYABLES 838,764 - 13,431 852,194 CUSTOMER DEPOSITS 309,622 - - 309,622 - TOTAL LIABILITIES 1,208,259 - 13,431 1,221,690 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 169,600 169,600 NON-SPENDABLE FUND BALANCE 30,686 30,686 ASSIGNED FUND BALANCE 407,000 10,268 417,268 UNASSIGNED FUND BALANCE 1,572,735 - (2,237) 1,570,499 COMMITTED FUND BALANCE 1,159,233 - - 1,159,233 NET REVENUES / EXPENDITURES 476,449 156,420 2 632,871 - TOTAL FUND BALANCE 3,646,104 326,020 8,033 3,980,157 - TOTAL LIABILITIES AND FUND BALANCE 4,854,363 326,020 21,464 5,201,847 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 58,181.00- 58,181.00- 343.13- 343.13- .590 57,837.87- 135-40002-000-000 Property Taxes/Delinquent 29.76- 29.76- 29.76 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 10.92- 10.92- 1.680 639.08- 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 12,371.00- 12,371.00- 8.466 133,754.00- Subtotal: 204,956.00- 204,956.00- 12,754.81- 12,754.81- 6.223 192,201.19- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 527,972.96- 527,972.96- 10.393 4,552,271.04- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 247,060.37- 247,060.37- 10.235 2,166,715.63- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 12,568.02- 12,568.02- 13.813 78,416.98- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 1,650.00- 1,650.00- 18.333 7,350.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 300.00- 300.00- 15.000 1,700.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 900.00- 900.00- 16.364 4,600.00- 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 5,954.20- 5,954.20- 9.708 55,375.80- Subtotal: 7,662,835.00- 7,662,835.00- 796,405.55- 796,405.55- 10.393 6,866,429.45- 135-48005-000-000 Utility Fees 69,000.00- 69,000.00- 20,700.00- 20,700.00- 30.000 48,300.00- Subtotal: 69,000.00- 69,000.00- 20,700.00- 20,700.00- 30.000 48,300.00- 135-49010-000-000 Interest Income 6,000.00- 6,000.00- 752.61- 752.61- 12.544 5,247.39- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 910.53- 8.334 10,015.47- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67- 135-49035-000-000 Prior Year Reserves 8,020.00- 8,020.00- 8,020.00- 135-49075-000-000 Oversize Meter Reimbursement 15,778.00- 15,778.00- 5,145.00- 5,145.00- 32.609 10,633.00- 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 327.72- 327.72- .518 62,921.28- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 2.00- 2.00- 10.000 18.00- Subtotal: 110,993.00- 110,993.00- 7,721.19- 7,721.19- 6.956 103,271.81- Program number: 8,047,784.00- 8,047,784.00- 837,581.55- 837,581.55- 10.408 7,210,202.45- Department number: Revenues 8,047,784.00- 8,047,784.00- 837,581.55- 837,581.55- 10.408 7,210,202.45- Revenues Subtotal ----------- 8,047,784.00- 8,047,784.00- 837,581.55- 837,581.55- 10.408 7,210,202.45- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 265,614.00 10,071.91 10,071.91 3.792 255,542.09 135-50010-010-000 Overtime 19,500.00 19,500.00 453.21 453.21 2.324 19,046.79 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 135-50017-010-000 Certification 4,200.00 4,200.00 175.00 175.00 4.167 4,025.00 135-50020-010-000 Retirement 25,558.00 25,558.00 953.38 953.38 3.730 24,604.62 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 1,931.01 1,931.01 3.757 49,466.99 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 158.29 158.29 3.958 3,840.71 135-50028-010-000 Vision Insurance 910.00 910.00 35.40 35.40 3.890 874.60 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 220.75 220.75 7.875 2,582.25 135-50030-010-000 Social Security Taxes 18,565.00 18,565.00 659.18 659.18 3.551 17,905.82 135-50035-010-000 Medicare Taxes 4,341.00 4,341.00 154.15 154.15 3.551 4,186.85 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 1,242.00 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,229.33 1,229.33 8.332 13,524.67 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 236.45 236.45 18.188 1,063.55 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 417,429.00 417,429.00 16,278.06 16,278.06 3.900 401,150.94 135-55005-010-000 Engineering 5,000.00 5,000.00 5,000.00 135-55080-010-000 Maintenance & Repairs 85,000.00 85,000.00 11,186.57 11,186.57 13.161 73,813.43 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 885.24 885.24 11.066 7,114.76 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 330.00 330.00 6.000 5,170.00 Subtotal: 107,000.00 107,000.00 12,401.81 12,401.81 11.590 94,598.19 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 397.58 397.58 7.363 5,002.42 135-60020-010-000 Electricity 166,823.00 166,823.00 4,871.41 4,871.41 2.920 161,951.59 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 5,773.00 5,773.00 351.00 351.00 6.080 5,422.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,400.00 1,400.00 14.25 14.25 1.018 1,385.75 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 49,275.00 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 2,948,742.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 303.41 303.41 8.669 3,196.59 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 3,186,763.00 3,186,763.00 5,937.65 5,937.65 .186 3,180,825.35 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 1,216.64 1,216.64 3.385 34,730.36 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 4,608.00 4,608.00 4,608.00 135-65030-010-000 Chemicals 12,000.00 12,000.00 1,337.95 1,337.95 11.150 10,662.05 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 115,000.00 115,000.00 12,685.00 12,685.00 11.030 102,315.00 135-65053-010-000 Meter Change Out Program 50,000.00 50,000.00 50,000.00 Subtotal: 219,755.00 219,755.00 15,239.59 15,239.59 6.935 204,515.41 135-69005-010-000 Capital Outlays 201,000.00 201,000.00 43,248.85 43,248.85 21.517 157,751.15 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,720.00 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 1,209.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 126,958.00 126,958.00 126,958.00 Subtotal: 534,887.00 534,887.00 118,248.85 118,248.85 22.107 416,638.15 Program number: 4,465,834.00 4,465,834.00 168,105.96 168,105.96 3.764 4,297,728.04 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 80.00 80.00 1.600 4,920.00 Subtotal: 5,000.00 5,000.00 80.00 80.00 1.600 4,920.00 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 80.00 80.00 .800 9,920.00 Department number: Water 4,475,834.00 4,475,834.00 168,185.96 168,185.96 3.758 4,307,648.04 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 14,720.22 14,720.22 4.186 336,950.78 135-50010-020-000 Overtime 19,500.00 19,500.00 777.73 777.73 3.988 18,722.27 135-50016-020-000 Longevity 6,125.00 6,125.00 6,125.00 135-50017-020-000 Certification 7,200.00 7,200.00 550.00 550.00 7.639 6,650.00 135-50020-020-000 Retirement 33,652.00 33,652.00 1,429.86 1,429.86 4.249 32,222.14 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 2,823.47 2,823.47 4.279 63,165.53 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 180.56 180.56 4.315 4,003.44 135-50028-020-000 Vision Insurance 972.00 972.00 41.60 41.60 4.280 930.40 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 289.36 289.36 7.917 3,365.64 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 909.85 909.85 3.689 23,755.15 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 212.77 212.77 3.689 5,555.23 135-50040-020-000 Unemployment Taxes 1,449.00 1,449.00 1,449.00 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 776.44 776.44 8.334 8,540.56 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 238.45 238.45 79.483 61.55 135-50070-020-000 Employee Relations 650.00 650.00 650.00 Subtotal: 535,097.00 535,097.00 22,950.31 22,950.31 4.289 512,146.69 135-55070-020-000 Independent Labor 50,000.00 50,000.00 50,000.00 135-55080-020-000 Maintenance & Repairs 72,600.00 72,600.00 7,249.61 7,249.61 9.986 65,350.39 135-55090-020-000 Vehicle Maintenance 5,000.00 5,000.00 44.72 44.72 .894 4,955.28 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 2,812.59 2,812.59 5.114 52,187.41 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 1,934.00 1,934.00 5.526 33,066.00 Subtotal: 218,100.00 218,100.00 12,040.92 12,040.92 5.521 206,059.08 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 258.56 258.56 4.788 5,141.44 135-60020-020-000 Electricity 161,582.00 161,582.00 447.05 447.05 .277 161,134.95 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 3,771.00 3,771.00 3,771.00 135-60090-020-000 Safety Program 550.00 550.00 550.00 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 1,600.00 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 9,439.28 9,439.28 25.409 27,710.72 135-60245-020-000 Miscellaneous Expenses 297.00 297.00 297.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706.00 119,706.00 119,706.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 444,831.00 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 30,834.00 30,834.00 25.000 92,502.00 Subtotal: 908,423.00 908,423.00 40,978.89 40,978.89 4.511 867,444.11 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 32,021.00 32,021.00 667.71 667.71 2.085 31,353.29 135-65010-020-000 Uniforms 4,241.00 4,241.00 1,097.02 1,097.02 25.867 3,143.98 135-65030-020-000 Chemicals 27,000.00 27,000.00 2,944.49 2,944.49 10.906 24,055.51 135-65035-020-000 Small Tools 2,000.00 2,000.00 2,000.00 135-65040-020-000 Safety Equipment 750.00 750.00 750.00 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 2,662.21 2,662.21 20.479 10,337.79 Subtotal: 79,012.00 79,012.00 7,371.43 7,371.43 9.330 71,640.57 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 150,000.00 135-69008-020-000 Short Term Debt-Principal 21,280.00 21,280.00 21,280.00 135-69009-020-000 Short Term Debt-Interest 197.00 197.00 197.00 Subtotal: 171,477.00 171,477.00 171,477.00 Program number: 1,912,109.00 1,912,109.00 83,341.55 83,341.55 4.359 1,828,767.45 Department number: Wastewater 1,912,109.00 1,912,109.00 83,341.55 83,341.55 4.359 1,828,767.45 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 12,500.00 12,500.00 500.00 500.00 4.000 12,000.00 135-50030-026-000 Social Security Taxes 775.00 775.00 31.00 31.00 4.000 744.00 135-50035-026-000 Medicare Taxes 181.00 181.00 7.25 7.25 4.006 173.75 135-50040-026-000 Unemployment Taxes 230.00 230.00 .50 .50 .217 229.50 135-50045-026-000 Workman's Compensation 37.00 37.00 3.09 3.09 8.351 33.91 Subtotal: 13,723.00 13,723.00 541.84 541.84 3.948 13,181.16 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 50.48 50.48 2.524 1,949.52 Subtotal: 12,850.00 12,850.00 50.48 50.48 .393 12,799.52 Program number: 26,573.00 26,573.00 592.32 592.32 2.229 25,980.68 Department number: Board of Directors 26,573.00 26,573.00 592.32 592.32 2.229 25,980.68 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 488,508.00 488,508.00 22,354.17 22,354.17 4.576 466,153.83 135-50010-030-000 Overtime 1,000.00 1,000.00 33.64 33.64 3.364 966.36 135-50016-030-000 Longevity 3,823.00 3,823.00 3,823.00 135-50020-030-000 Retirement 43,202.00 43,202.00 1,994.79 1,994.79 4.617 41,207.21 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 3,111.01 3,111.01 4.562 65,084.99 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 219.35 219.35 4.563 4,587.65 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 50.87 50.87 4.566 1,063.13 135-50029-030-000 Life Insurance & Other 4,431.00 4,431.00 369.42 369.42 8.337 4,061.58 135-50030-030-000 Social Security Taxes 30,823.00 30,823.00 1,311.85 1,311.85 4.256 29,511.15 135-50035-030-000 Medicare Taxes 7,599.00 7,599.00 306.79 306.79 4.037 7,292.21 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 1,449.00 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.89 147.89 9.517 1,406.11 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 747.06 747.06 14.941 4,252.94 Subtotal: 662,006.00 662,006.00 30,646.84 30,646.84 4.629 631,359.16 135-55030-030-000 Software & Support 78,483.00 78,483.00 2,813.90 2,813.90 3.585 75,669.10 135-55070-030-000 Independent Labor 12,000.00 12,000.00 595.00 595.00 4.958 11,405.00 135-55080-030-000 Maintenance & Repairs 29,500.00 29,500.00 1,380.50 1,380.50 4.680 28,119.50 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 455.89 455.89 6.513 6,544.11 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 584.75 584.75 5.775 9,540.25 135-55160-030-000 Professional Outside Services 61,075.00 61,075.00 51,075.00 51,075.00 83.627 10,000.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 654.50 654.50 7.982 7,545.50 Subtotal: 206,583.00 206,583.00 57,559.54 57,559.54 27.863 149,023.46 135-60005-030-000 Telephone 16,349.00 16,349.00 595.50 595.50 3.642 15,753.50 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 337.99 337.99 8.144 3,812.01 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 10,768.00 135-60025-030-000 Water 1,500.00 1,500.00 112.88- 112.88- -7.525 1,612.88 135-60035-030-000 Postage 28,932.00 28,932.00 2,531.54 2,531.54 8.750 26,400.46 135-60040-030-000 Service Charges & Fees 44,000.00 44,000.00 6,704.08 6,704.08 15.237 37,295.92 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 3,500.00 135-60055-030-000 Insurance 52,797.00 52,797.00 2,789.25 2,789.25 5.283 50,007.75 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 100.00 100.00 1.667 5,900.00 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 5,000.00 5,000.00 5,000.00 135-60080-030-000 Schools & Training 9,935.00 9,935.00 9,935.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 113.91 113.91 2.109 5,286.09 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 7,500.00 7,500.00 7,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 7,500.00 7,500.00 675.36 675.36 9.005 6,824.64 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,501.00 17,501.00 324.99 324.99 1.857 17,176.01 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 226,882.00 226,882.00 14,059.74 14,059.74 6.197 212,822.26 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,855.00 135-65055-030-000 Hardware 29,594.00 29,594.00 29,594.00 135-65085-030-000 Office Supplies 9,000.00 9,000.00 9,000.00 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 221.30 221.30 5.528 3,781.70 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 684.50 684.50 13.690 4,315.50 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 Subtotal: 54,252.00 54,252.00 905.80 905.80 1.670 53,346.20 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 56,000.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 156.94 156.94 3.412 4,443.06 Subtotal: 60,600.00 60,600.00 156.94 156.94 .259 60,443.06 Program number: 1,210,323.00 1,210,323.00 103,328.86 103,328.86 8.537 1,106,994.14 Department number: Administration 1,210,323.00 1,210,323.00 103,328.86 103,328.86 8.537 1,106,994.14 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 10:49 11/12/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 386,130.00 386,130.00 683.50 683.50 .177 385,446.50 135-55055-039-000 Auditing 22,750.00 22,750.00 5,000.00 5,000.00 21.978 17,750.00 135-55060-039-000 Appraisal 10,265.00 10,265.00 10,265.00 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 422,945.00 422,945.00 5,683.50 5,683.50 1.344 417,261.50 Program number: 422,945.00 422,945.00 5,683.50 5,683.50 1.344 417,261.50 Department number: Non Departmental 422,945.00 422,945.00 5,683.50 5,683.50 1.344 417,261.50 Expenditures Subtotal ----------- 8,047,784.00 8,047,784.00 361,132.19 361,132.19 4.487 7,686,651.81 Fund number: 135 MUD 1 General Fund 476,449.36- 476,449.36- 476,449.36 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 10:49 11/12/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00- 156,420.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 10:49 11/12/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 1.75- 1.75- 1.75 Subtotal: 1.75- 1.75- 1.75 Program number: 1.75- 1.75- 1.75 Department number: 1.75- 1.75- 1.75 Revenues Subtotal ----------- 1.75- 1.75- 1.75 Fund number: 507 MUD 1 Capital Projects 1.75- 1.75- 1.75 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 188 10/09/2015 Property Taxes (42.60) (42.60) GL 190 10/13/2015 Property Taxes (.41) (43.01) GL 191 10/15/2015 Property Taxes (26.23) (69.24) GL 192 10/16/2015 Property Taxes (27.28) (96.52) GL 193 10/19/2015 Property Taxes (14.59) (111.11) GL 194 10/20/2015 Property Taxes (15.73) (126.84) GL 195 10/21/2015 Property Taxes (34.95) (161.79) GL 196 10/26/2015 Property Taxes (61.48) (223.27) GL 197 10/27/2015 Property Taxes (8.86) (232.13) GL 198 10/28/2015 Property Taxes (11.72) (243.85) GL 199 10/29/2015 Property Taxes (59.45) (303.30) GL 238 10/30/2015 Property Taxes (39.83) (343.13) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (343.13) (343.13) ** (58,181.00) Budgeted (57,837.87) Remaining 1 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 182 10/02/2015 Property Taxes (58.14) (58.14) GL 187 10/08/2015 Property Taxes (.03) (58.17) GL 189 10/12/2015 Property Taxes 16.45 (41.72) GL 197 10/27/2015 Property Taxes 3.77 (37.95) GL 198 10/28/2015 Property Taxes 8.19 (29.76) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (29.76) (29.76) ** .00 Budgeted 29.76 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 182 10/02/2015 Property Taxes (10.92) (10.92) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (10.92) (10.92) ** (650.00) Budgeted (639.08) Remaining 2 % Used Account: 135-40025-000-000 PID Surcharges 153 10/31/2015 UB 10/31/2015 Billing UB20151031-20151031 User: (12,371.00) (12,371.00) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (12,371.00) (12,371.00) ** (146,125.00) Budgeted (133,754.00) Remaining 8 % Used Account: 135-47000-000-000 Water . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 159 10/09/2015 UB 10/09/2015 usage billed inc UB20151009-20151009 User: (61.10) (61.10) UB 160 10/12/2015 UB 10/12/15-billing errors UB20151012-20151012 User: 46.04 (15.06) UB 171 10/16/2015 UB 10/16/15 Sdjustment UB20151016-20151016 User: 279.34 264.28 UB 164 10/28/2015 UB 10/28/15 Meter misread Sept UB20151028-20151028 User: 452.41 716.69 UB 153 10/31/2015 UB 10/31/2015 Billing UB20151031-20151031 User: (528,689.65) (527,972.96) UB _______________ Account: 135-47000-000-000 Water Totals: (527,972.96) (527,972.96) ** (5,080,244.00) Budgeted (4,552,271.04) Remaining 10 % Used Account: 135-47005-000-000 Sewer 159 10/09/2015 UB 10/09/2015 usage billed inc UB20151009-20151009 User: (47.34) (47.34) UB 160 10/12/2015 UB 10/12/15-billing errors UB20151012-20151012 User: (10.52) (57.86) UB 164 10/28/2015 UB 10/28/15 Meter misread Sept UB20151028-20151028 User: 228.81 170.95 UB 153 10/31/2015 UB 10/31/2015 Billing UB20151031-20151031 User: (247,231.32) (247,060.37) UB _______________ Account: 135-47005-000-000 Sewer Totals: (247,060.37) (247,060.37) ** (2,413,776.00) Budgeted (2,166,715.63) Remaining 10 % Used Account: 135-47025-000-000 Penalties 161 10/06/2015 UB 10/6/15 penalty removals UB20151006-20151006 User: 154.05 154.05 UB 158 10/07/2015 UB 10/07/2015 adjustments UB20151007-20151007 User: 78.21 232.26 UB 91 10/21/2015 UB 10/21/15 Penalties UB20151021-20151021 User: (13,106.13) (12,873.87) UB 167 10/21/2015 UB 10/21/15 Penalty adj UB20151021-20151021 User: 305.85 (12,568.02) UB _______________ Account: 135-47025-000-000 Penalties Totals: (12,568.02) (12,568.02) ** (90,985.00) Budgeted (78,416.98) Remaining 14 % Used Account: 135-47030-000-000 Service Charges 27 10/07/2015 UB 10/7/15 Cut off list UB20151007-20151007 User: (1,600.00) (1,600.00) UB 158 10/07/2015 UB 10/07/2015 adjustments UB20151007-20151007 User: 50.00 (1,550.00) UB 162 10/13/2015 UB 10/13/15 NSF check fees UB20151013-20151013 User: (50.00) (1,600.00) UB 169 10/19/2015 UB 10/19/15 NSF Check fee UB20151019-20151019 User: (50.00) (1,650.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,650.00) (1,650.00) ** (9,000.00) Budgeted (7,350.00) Remaining 18 % Used Account: 135-47035-000-000 Plumbing Inspections 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (300.00) (300.00) AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (300.00) (300.00) ** (2,000.00) Budgeted (1,700.00) Remaining 15 % Used Account: 135-47045-000-000 Sewer Inspections 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (900.00) (900.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (900.00) (900.00) ** (5,500.00) Budgeted (4,600.00) Remaining 16 % Used Account: 135-47070-000-000 TCCC Effluent Charges 153 10/31/2015 UB 10/31/2015 Billing UB20151031-20151031 User: (5,954.20) (5,954.20) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (5,954.20) (5,954.20) ** (61,330.00) Budgeted (55,375.80) Remaining 10 % Used Account: 135-48005-000-000 Utility Fees 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (20,700.00) (20,700.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (20,700.00) (20,700.00) ** (69,000.00) Budgeted (48,300.00) Remaining 30 % Used Account: 135-49010-000-000 Interest Income 209 10/31/2015 Bank Interest/October (13.04) (13.04) GL 209 10/31/2015 Bank Interest/October (166.04) (179.08) GL 209 10/31/2015 Bank Interest/October (310.04) (489.12) GL 209 10/31/2015 Bank Interest/October (263.49) (752.61) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (752.61) (752.61) ** (6,000.00) Budgeted (5,247.39) Remaining 13 % Used Account: 135-49016-000-000 Cell Tower Revenue 125 10/16/2015 AT&T Cell Tower Revenue (910.53) (910.53) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (910.53) ** (10,926.00) Budgeted (10,015.47) Remaining 8 % Used Account: 135-49018-000-000 Building Rent Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (583.33) (583.33) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (583.33) ** (7,000.00) Budgeted (6,416.67) Remaining 8 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (8,020.00) Budgeted (8,020.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (5,145.00) (5,145.00) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,145.00) (5,145.00) ** (15,778.00) Budgeted (10,633.00) Remaining 33 % Used Account: 135-49900-000-000 Miscellaneous Income 155 10/01/2015 UB 10/01/2015-misapp payment UB20151001-20151001 User: (419.04) (419.04) UB 244 10/01/2015 UB 10/01/2015-misapp payment UB20151001-20151001 User: 419.04 .00 GL 159 10/09/2015 UB 10/09/2015 usage billed inc UB20151009-20151009 User: (300.90) (300.90) UB 243 10/16/2015 Expert Pay bank acct test (.11) (301.01) GL 153 10/31/2015 UB 10/31/2015 Billing UB20151031-20151031 User: (26.71) (327.72) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (327.72) (327.72) ** (63,249.00) Budgeted (62,921.28) Remaining 1 % Used Account: 135-49901-000-000 Records Management Revenue 124 10/16/2015 ORR-Mayer (2.00) (2.00) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (2.00) (2.00) ** (20.00) Budgeted (18.00) Remaining 10 % Used Department Totals: ------------------------------------------------------------------------------------------------ (837,581.55) ** (8,047,784.00) Budgeted (7,210,202.45) Remaining 10 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 29 10/01/2015 Reverse Accrued Sept Wages (6,745.07) (6,745.07) GL 22 10/09/2015 MUD Payroll 10/9/15 Salaries & Wages 8,337.22 1,592.15 PR 80 10/23/2015 MUD Payroll 10/23/15 Salaries & Wages 8,479.76 10,071.91 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 10,071.91 10,071.91 ** 265,614.00 Budgeted 255,542.09 Remaining 4 % Used Account: 135-50010-010-000 Overtime 29 10/01/2015 Reverse Accrued Sept Wages (866.60) (866.60) GL 22 10/09/2015 MUD Payroll 10/9/15 Overtime 978.52 111.92 PR 80 10/23/2015 MUD Payroll 10/23/15 Overtime 341.29 453.21 PR _______________ Account: 135-50010-010-000 Overtime Totals: 453.21 453.21 ** 19,500.00 Budgeted 19,046.79 Remaining 2 % Used Account: 135-50016-010-000 Longevity .00 .00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 .00 ** 2,945.00 Budgeted 2,945.00 Remaining 0 % Used Account: 135-50017-010-000 Certification 80 10/23/2015 MUD Payroll 10/23/15 Certification 175.00 175.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 175.00 ** 4,200.00 Budgeted 4,025.00 Remaining 4 % Used Account: 135-50020-010-000 Retirement 29 10/01/2015 Reverse Accrued Sept Wages (678.20) (678.20) GL 22 10/09/2015 MUD Payroll 10/9/15 Retirement 830.03 151.83 PR 80 10/23/2015 MUD Payroll 10/23/15 Retirement 801.55 953.38 PR _______________ Account: 135-50020-010-000 Retirement Totals: 953.38 953.38 ** 25,558.00 Budgeted 24,604.62 Remaining 4 % Used Account: 135-50026-010-000 Medical Insurance 29 10/01/2015 Reverse Accrued Sept Wages (1,338.04) (1,338.04) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 22 10/09/2015 MUD Payroll 10/9/15 Medical Insurance 1,634.55 296.51 PR 80 10/23/2015 MUD Payroll 10/23/15 Medical Insurance 1,634.50 1,931.01 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,931.01 1,931.01 ** 51,398.00 Budgeted 49,466.99 Remaining 4 % Used Account: 135-50027-010-000 Dental Insurance 29 10/01/2015 Reverse Accrued Sept Wages (109.69) (109.69) GL 22 10/09/2015 MUD Payroll 10/9/15 Dental Insurance 133.99 24.30 PR 80 10/23/2015 MUD Payroll 10/23/15 Dental Insurance 133.99 158.29 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 158.29 158.29 ** 3,999.00 Budgeted 3,840.71 Remaining 4 % Used Account: 135-50028-010-000 Vision Insurance 29 10/01/2015 Reverse Accrued Sept Wages (24.52) (24.52) GL 22 10/09/2015 MUD Payroll 10/9/15 Vision Insurance 29.94 5.42 PR 80 10/23/2015 MUD Payroll 10/23/15 Vision Insurance 29.98 35.40 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.40 35.40 ** 910.00 Budgeted 874.60 Remaining 4 % Used Account: 135-50029-010-000 Life Insurance & Other 2 10/01/2015 Reverse Prepaids Oct Metlife paid Sept 212.31 212.31 GL 98 10/22/2015 October A/P Café 125 Admin Fee 8.44 220.75 BenefitMall 1090 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 220.75 220.75 ** 2,803.00 Budgeted 2,582.25 Remaining 8 % Used Account: 135-50030-010-000 Social Security Taxes 29 10/01/2015 Reverse Accrued Sept Wages (458.92) (458.92) GL 22 10/09/2015 MUD Payroll 10/9/15 Social Security Taxes 564.64 105.72 PR 80 10/23/2015 MUD Payroll 10/23/15 Social Security Taxes 553.46 659.18 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 659.18 659.18 ** 18,565.00 Budgeted 17,905.82 Remaining 4 % Used Account: 135-50035-010-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 29 10/01/2015 Reverse Accrued Sept Wages (107.35) (107.35) GL 22 10/09/2015 MUD Payroll 10/9/15 Medicare Taxes 132.06 24.71 PR 80 10/23/2015 MUD Payroll 10/23/15 Medicare Taxes 129.44 154.15 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 154.15 154.15 ** 4,341.00 Budgeted 4,186.85 Remaining 4 % Used Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 1,242.00 Budgeted 1,242.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 132 10/01/2015 Prepaid Insurance, W/C Oct 1,229.35 1,229.35 GL 145 10/01/2015 Prepaid Ins, W/C rounding (.02) 1,229.33 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.33 1,229.33 ** 14,754.00 Budgeted 13,524.67 Remaining 8 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 252 10/31/2015 October A/P New Hire Testing 148.45 148.45 FIRST CHECK APPLICANT SCREENIN 1182 AP 252 10/31/2015 October A/P New hire Physicals exam 88.00 236.45 CARENOW CORPORATE 1179 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 236.45 236.45 ** 1,300.00 Budgeted 1,063.55 Remaining 18 % Used Account: 135-50070-010-000 Employee Relations .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering 232 10/15/2015 Recode Solana waterline pmt 4,397.25 4,397.25 GL 69 10/15/2015 Maguire Invoice 1359 billed AR 20151015-20151015 User: (4,397.25) .00 AR _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-010-000 Maintenance & Repairs 98 10/22/2015 October A/P 1" compression nuts 62.50 62.50 HD SUPPLY WATERWORKS, LTD. 1093 AP 166 10/26/2015 JPChase 9/29-10/26/15 THE HOME DEPOT 6581 152.27 214.77 THE HOME DEPOT 6581 PC 116 10/28/2015 October A/P Emergency repairs 1,800.00 2,014.77 REY-MAR CONSTRUCTION 1122 AP 116 10/28/2015 October A/P Water parts 599.28 2,614.05 ATLAS UTILITY SUPPLY CO. 1107 AP 116 10/28/2015 October A/P Water parts 7,810.88 10,424.93 HD SUPPLY WATERWORKS, LTD. 1114 AP 202 10/31/2015 October A/P Repair clamps 546.70 10,971.63 HD SUPPLY WATERWORKS, LTD. 1143 AP 252 10/31/2015 October A/P Maintenance parts 214.94 11,186.57 HD SUPPLY FACILITIES MAINT LTD 1183 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 11,186.57 11,186.57 ** 85,000.00 Budgeted 73,813.43 Remaining 13 % Used Account: 135-55090-010-000 Vehicle Maintenance 98 10/22/2015 October A/P Inspection & repair on 2002 Fo 138.00 138.00 MICHAEL G. WATSON 1097 AP 166 10/26/2015 JPChase 9/29-10/26/15 KWIK KAR LUBE & TUNE O 176.05 314.05 KWIK KAR LUBE & TUNE O PC 166 10/26/2015 JPChase 9/29-10/26/15 ROANOKE AUTO SUPPLY LT 156.70 470.75 ROANOKE AUTO SUPPLY LT PC 166 10/26/2015 JPChase 9/29-10/26/15 DISCOUNT TIRE TXD 75 309.00 779.75 DISCOUNT TIRE TXD 75 PC 166 10/26/2015 JPChase 9/29-10/26/15 ROANOKE AUTO SUPPLY LT 65.91 845.66 ROANOKE AUTO SUPPLY LT PC 166 10/26/2015 JPChase 9/29-10/26/15 KWIK KAR LUBE & TUNE O 39.58 885.24 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 885.24 885.24 ** 8,000.00 Budgeted 7,114.76 Remaining 11 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 116 10/28/2015 October A/P Water analysis - bacteriologic 20.00 20.00 CITY OF DENTON 1109 AP 252 10/31/2015 October A/P Oct Water Samples/MUD 310.00 330.00 TARRANT CTY PUBLIC HEALTH LAB 1188 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 330.00 330.00 ** 5,500.00 Budgeted 5,170.00 Remaining 6 % Used Account: 135-60010-010-000 Communications/Mobiles 66 10/15/2015 October A/P Cell phones 10/02-11/1/15 397.58 397.58 VERIZON WIRELESS 1078 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 397.58 397.58 ** 5,400.00 Budgeted 5,002.42 Remaining 7 % Used Account: 135-60020-010-000 Electricity 66 10/15/2015 October A/P Electricity 10/1-10/9/15 17.05 17.05 HUDSON ENERGY SERVICES, LLC 1072 AP 98 10/22/2015 October A/P Electricity 10/1 - 10/9/15 4,854.36 4,871.41 HUDSON ENERGY SERVICES, LLC 1094 AP _______________ Account: 135-60020-010-000 Electricity Totals: 4,871.41 4,871.41 ** 166,823.00 Budgeted 161,951.59 Remaining 3 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 166 10/26/2015 JPChase 9/29-10/26/15 NCTCOG RTC TRAINING 240.00 240.00 NCTCOG RTC TRAINING PC 116 10/28/2015 October A/P Application Fee - Chitty 111.00 351.00 TX COMMISSION ENVIRONMENTAL QU 1123 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 351.00 351.00 ** 5,773.00 Budgeted 5,422.00 Remaining 6 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 116 10/28/2015 October A/P Meals during training class 14.25 14.25 MATTHEW CHITTY 1119 AP _______________ Account: 135-60100-010-000 Travel & per diem Totals: 14.25 14.25 ** 1,400.00 Budgeted 1,385.75 Remaining 1 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits .00 .00 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 .00 ** 49,275.00 Budgeted 49,275.00 Remaining 0 % Used Account: 135-60150-010-000 Wholesale Water .00 .00 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 .00 ** 2,948,742.00 Budgeted 2,948,742.00 Remaining 0 % 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 35 10/08/2015 October A/P Reset motors on gate 95.00 95.00 Alan's Gates, Inc. 1045 AP 166 10/26/2015 JPChase 9/29-10/26/15 TEX-TURF 64.41 159.41 TEX-TURF PC 166 10/26/2015 JPChase 9/29-10/26/15 DENTON SAND & GRAVEL, 72.00 231.41 DENTON SAND & GRAVEL, PC 166 10/26/2015 JPChase 9/29-10/26/15 DENTON SAND & GRAVEL, 72.00 303.41 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 303.41 303.41 ** 3,500.00 Budgeted 3,196.59 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 202 10/31/2015 October A/P Fuel October 1,216.64 1,216.64 US Bank Voyager Fleet Systems 1166 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,216.64 1,216.64 ** 35,947.00 Budgeted 34,730.36 Remaining 3 % Used Account: 135-65010-010-000 Uniforms .00 .00 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 .00 ** 4,608.00 Budgeted 4,608.00 Remaining 0 % Used Account: 135-65030-010-000 Chemicals 116 10/28/2015 October A/P Chlorine 529.71 529.71 DPC INDUSTRIES, INC 1110 AP 116 10/28/2015 October A/P Chemicals 808.24 1,337.95 HACH COMPANY 1112 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,337.95 1,337.95 ** 12,000.00 Budgeted 10,662.05 Remaining 11 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 116 10/28/2015 October A/P 6" and 8" mag meters 6,085.00 6,085.00 ATLAS UTILITY SUPPLY CO. 1107 AP 202 10/31/2015 October A/P Meter supplies 6,600.00 12,685.00 ATLAS UTILITY SUPPLY CO. 1134 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 12,685.00 12,685.00 ** 115,000.00 Budgeted 102,315.00 Remaining 11 % Used Account: 135-65053-010-000 Meter Change Out Program .00 .00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays 66 10/15/2015 October A/P Transfer switch at water plant 13,000.00 13,000.00 DHS AUTOMATION, INC 1069 AP 98 10/22/2015 October A/P Loop plugged water line Valley 30,248.85 43,248.85 REY-MAR CONSTRUCTION 1101 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 43,248.85 43,248.85 ** 201,000.00 Budgeted 157,751.15 Remaining 22 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 130,720.00 Budgeted 130,720.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 1,209.00 Budgeted 1,209.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 235 10/01/2015 GASB 34 transfers Fiscal 2016 Town Elevated Tank 45,000.00 45,000.00 GL 235 10/01/2015 GASB 34 transfers Fiscal 2016 Water Replacement 30,000.00 75,000.00 GL _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract .00 .00 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 .00 ** 126,958.00 Budgeted 126,958.00 Remaining 0 % Used Account: 135-55135-010-001 Lab Analysis for PID 252 10/31/2015 October A/P October Water samples/PID 80.00 80.00 TARRANT CTY PUBLIC HEALTH LAB 1188 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 80.00 ** 5,000.00 Budgeted 4,920.00 Remaining 2 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 168,185.96 ** 4,475,834.00 Budgeted 4,307,648.04 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 29 10/01/2015 Reverse Accrued Sept Wages (9,789.49) (9,789.49) GL 22 10/09/2015 MUD Payroll 10/9/15 Salaries & Wages 12,190.84 2,401.35 PR 80 10/23/2015 MUD Payroll 10/23/15 Salaries & Wages 12,318.87 14,720.22 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,720.22 14,720.22 ** 351,671.00 Budgeted 336,950.78 Remaining 4 % Used Account: 135-50010-020-000 Overtime 29 10/01/2015 Reverse Accrued Sept Wages (300.31) (300.31) GL 22 10/09/2015 MUD Payroll 10/9/15 Overtime 489.61 189.30 PR 80 10/23/2015 MUD Payroll 10/23/15 Overtime 588.43 777.73 PR _______________ Account: 135-50010-020-000 Overtime Totals: 777.73 777.73 ** 19,500.00 Budgeted 18,722.27 Remaining 4 % Used Account: 135-50016-020-000 Longevity .00 .00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 .00 ** 6,125.00 Budgeted 6,125.00 Remaining 0 % Used Account: 135-50017-020-000 Certification 80 10/23/2015 MUD Payroll 10/23/15 Certification 550.00 550.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 550.00 ** 7,200.00 Budgeted 6,650.00 Remaining 8 % Used Account: 135-50020-020-000 Retirement 29 10/01/2015 Reverse Accrued Sept Wages (899.01) (899.01) GL 22 10/09/2015 MUD Payroll 10/9/15 Retirement 1,129.83 230.82 PR 80 10/23/2015 MUD Payroll 10/23/15 Retirement 1,199.04 1,429.86 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,429.86 1,429.86 ** 33,652.00 Budgeted 32,222.14 Remaining 4 % Used Account: 135-50026-020-000 Medical Insurance 29 10/01/2015 Reverse Accrued Sept Wages (1,863.28) (1,863.28) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 22 10/09/2015 MUD Payroll 10/9/15 Medical Insurance 2,343.40 480.12 PR 80 10/23/2015 MUD Payroll 10/23/15 Medical Insurance 2,343.35 2,823.47 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,823.47 2,823.47 ** 65,989.00 Budgeted 63,165.53 Remaining 4 % Used Account: 135-50027-020-000 Dental Insurance 29 10/01/2015 Reverse Accrued Sept Wages (118.95) (118.95) GL 22 10/09/2015 MUD Payroll 10/9/15 Dental Insurance 149.75 30.80 PR 80 10/23/2015 MUD Payroll 10/23/15 Dental Insurance 149.76 180.56 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 180.56 180.56 ** 4,184.00 Budgeted 4,003.44 Remaining 4 % Used Account: 135-50028-020-000 Vision Insurance 29 10/01/2015 Reverse Accrued Sept Wages (27.40) (27.40) GL 22 10/09/2015 MUD Payroll 10/9/15 Vision Insurance 34.48 7.08 PR 80 10/23/2015 MUD Payroll 10/23/15 Vision Insurance 34.52 41.60 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 41.60 41.60 ** 972.00 Budgeted 930.40 Remaining 4 % Used Account: 135-50029-020-000 Life Insurance & Other 2 10/01/2015 Reverse Prepaids Oct Metlife paid Sept 255.58 255.58 GL 98 10/22/2015 October A/P Café 125 Admin Fee 33.78 289.36 BenefitMall 1090 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 289.36 289.36 ** 3,655.00 Budgeted 3,365.64 Remaining 8 % Used Account: 135-50030-020-000 Social Security Taxes 29 10/01/2015 Reverse Accrued Sept Wages (557.06) (557.06) GL 22 10/09/2015 MUD Payroll 10/9/15 Social Security Taxes 712.49 155.43 PR 80 10/23/2015 MUD Payroll 10/23/15 Social Security Taxes 754.42 909.85 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 909.85 909.85 ** 24,665.00 Budgeted 23,755.15 Remaining 4 % Used Account: 135-50035-020-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 29 10/01/2015 Reverse Accrued Sept Wages (130.31) (130.31) GL 22 10/09/2015 MUD Payroll 10/9/15 Medicare Taxes 166.64 36.33 PR 80 10/23/2015 MUD Payroll 10/23/15 Medicare Taxes 176.44 212.77 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 212.77 212.77 ** 5,768.00 Budgeted 5,555.23 Remaining 4 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,449.00 Budgeted 1,449.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 132 10/01/2015 Prepaid Insurance, W/C Oct 776.43 776.43 GL 145 10/01/2015 Prepaid Ins, W/C rounding .01 776.44 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.44 776.44 ** 9,317.00 Budgeted 8,540.56 Remaining 8 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 252 10/31/2015 October A/P New Hire Testing 150.45 150.45 FIRST CHECK APPLICANT SCREENIN 1182 AP 252 10/31/2015 October A/P New hire Physicals exam 88.00 238.45 CARENOW CORPORATE 1179 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 238.45 238.45 ** 300.00 Budgeted 61.55 Remaining 79 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 650.00 Budgeted 650.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-020-000 Maintenance & Repairs 166 10/26/2015 JPChase 9/29-10/26/15 IN *ACTION GARAGE DOOR 307.00 307.00 IN *ACTION GARAGE DOOR PC 166 10/26/2015 JPChase 9/29-10/26/15 THE HOME DEPOT 6581 5.94 312.94 THE HOME DEPOT 6581 PC 166 10/26/2015 JPChase 9/29-10/26/15 GATE DEPOT 34.84 347.78 GATE DEPOT PC 166 10/26/2015 JPChase 9/29-10/26/15 THE HOME DEPOT 6581 89.94 437.72 THE HOME DEPOT 6581 PC 166 10/26/2015 JPChase 9/29-10/26/15 WW GRAINGER 41.33 479.05 WW GRAINGER PC 116 10/28/2015 October A/P Emergency repairs 1,200.00 1,679.05 REY-MAR CONSTRUCTION 1122 AP 116 10/28/2015 October A/P Repairs to gate 572.50 2,251.55 Alan's Gates, Inc. 1106 AP 202 10/31/2015 October A/P 10 HP Wasting Pump 4,998.06 7,249.61 NORTH TEXAS PUMP CO. 1153 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,249.61 7,249.61 ** 72,600.00 Budgeted 65,350.39 Remaining 10 % Used Account: 135-55090-020-000 Vehicle Maintenance 166 10/26/2015 JPChase 9/29-10/26/15 ROANOKE AUTO SUPPLY LT 44.72 44.72 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 44.72 44.72 ** 5,000.00 Budgeted 4,955.28 Remaining 1 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 116 10/28/2015 October A/P Sludge hauling 1,344.82 1,344.82 L.H. CHANEY MATERIALS, INC. 1117 AP 202 10/31/2015 October A/P Sludge Hauling 1,467.77 2,812.59 L.H. CHANEY MATERIALS, INC. 1145 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,812.59 2,812.59 ** 55,000.00 Budgeted 52,187.41 Remaining 5 % Used Account: 135-55135-020-000 Lab Analysis 35 10/08/2015 October A/P Lab analysis 246.00 246.00 OXIDOR LABORATORIES LLC 1049 AP 35 10/08/2015 October A/P Lab analysis 176.00 422.00 OXIDOR LABORATORIES LLC 1049 AP 66 10/15/2015 October A/P Lab analysis 246.00 668.00 OXIDOR LABORATORIES LLC 1076 AP 66 10/15/2015 October A/P Lab analysis 176.00 844.00 OXIDOR LABORATORIES LLC 1076 AP 98 10/22/2015 October A/P Lab analysis 246.00 1,090.00 OXIDOR LABORATORIES LLC 1099 AP 98 10/22/2015 October A/P Lab analysis 176.00 1,266.00 OXIDOR LABORATORIES LLC 1099 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 116 10/28/2015 October A/P Lab analysis 246.00 1,512.00 OXIDOR LABORATORIES LLC 1121 AP 116 10/28/2015 October A/P Lab analysis 176.00 1,688.00 OXIDOR LABORATORIES LLC 1121 AP 202 10/31/2015 October A/P Lab analysis 246.00 1,934.00 OXIDOR LABORATORIES LLC 1155 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,934.00 1,934.00 ** 35,000.00 Budgeted 33,066.00 Remaining 6 % Used Account: 135-60010-020-000 Communications/Mobiles 66 10/15/2015 October A/P Cell phones 10/02-11/1/15 258.56 258.56 VERIZON WIRELESS 1078 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 258.56 258.56 ** 5,400.00 Budgeted 5,141.44 Remaining 5 % Used Account: 135-60020-020-000 Electricity 66 10/15/2015 October A/P Electricity 10/1-10/8/15 14.96 14.96 HUDSON ENERGY SERVICES, LLC 1072 AP 66 10/15/2015 October A/P Electricity 10/1-10/8 10.03 24.99 HUDSON ENERGY SERVICES, LLC 1072 AP 66 10/15/2015 October A/P Electricity 10/1-10/9/15 23.64 48.63 HUDSON ENERGY SERVICES, LLC 1072 AP 98 10/22/2015 October A/P Electricity 10/1 - 10/9/15 124.91 173.54 HUDSON ENERGY SERVICES, LLC 1094 AP 98 10/22/2015 October A/P Electricity 10/1 - 10/9/15 188.99 362.53 HUDSON ENERGY SERVICES, LLC 1094 AP 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (422.75) (60.22) AR 252 10/31/2015 October A/P Electricity/Oct 156.90 96.68 TRI COUNTY ELECTRIC 1189 AP 252 10/31/2015 October A/P Electricity /Oct 27.69 124.37 TRI COUNTY ELECTRIC 1189 AP 252 10/31/2015 October A/P Electricity/Oct 322.68 447.05 TRI COUNTY ELECTRIC 1189 AP _______________ Account: 135-60020-020-000 Electricity Totals: 447.05 447.05 ** 161,582.00 Budgeted 161,134.95 Remaining 0 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 3,771.00 Budgeted 3,771.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 202 10/31/2015 October A/P Permit WQ 0011593001 9,439.28 9,439.28 TX COMMISSION ENVIRONMENTAL QU 1165 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 9,439.28 9,439.28 ** 37,150.00 Budgeted 27,710.72 Remaining 25 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 297.00 Budgeted 297.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S .00 .00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 .00 ** 119,706.00 Budgeted 119,706.00 Remaining 0 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S .00 .00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 .00 ** 444,831.00 Budgeted 444,831.00 Remaining 0 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 51 10/06/2015 O&M to Rev Bond Res-3 mos 30,834.00 30,834.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 30,834.00 30,834.00 ** 123,336.00 Budgeted 92,502.00 Remaining 25 % Used Account: 135-65005-020-000 Fuel & Lube 202 10/31/2015 October A/P Fuel October 667.71 667.71 US Bank Voyager Fleet Systems 1166 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 667.71 667.71 ** 32,021.00 Budgeted 31,353.29 Remaining 2 % Used Account: 135-65010-020-000 Uniforms 166 10/26/2015 JPChase 9/29-10/26/15 RED WING SHOES #652 164.99 164.99 RED WING SHOES #652 PC 166 10/26/2015 JPChase 9/29-10/26/15 ACADEMY SPORTS #81 214.90 379.89 ACADEMY SPORTS #81 PC 166 10/26/2015 JPChase 9/29-10/26/15 ACADEMY SPORTS #81 205.90 585.79 ACADEMY SPORTS #81 PC 166 10/26/2015 JPChase 9/29-10/26/15 RED WING SHOES #652 161.99 747.78 RED WING SHOES #652 PC 166 10/26/2015 JPChase 9/29-10/26/15 RED WING SHOES #652 349.24 1,097.02 RED WING SHOES #652 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 1,097.02 1,097.02 ** 4,241.00 Budgeted 3,143.98 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65030-020-000 Chemicals 166 10/26/2015 JPChase 9/29-10/26/15 AQUAFIX INC. 691.34 691.34 AQUAFIX INC. PC 116 10/28/2015 October A/P Chemicals 2,253.15 2,944.49 HARCROS CHEMICALS INC 1113 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,944.49 2,944.49 ** 27,000.00 Budgeted 24,055.51 Remaining 11 % Used Account: 135-65035-020-000 Small Tools .00 .00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment .00 .00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-65045-020-000 Lab Supplies 66 10/15/2015 October A/P Polyvinyl alcohol disprsng rgt 37.89 37.89 HACH COMPANY 1071 AP 166 10/26/2015 JPChase 9/29-10/26/15 MMS 52.99 90.88 MMS PC 116 10/28/2015 October A/P Lab supplies 2,400.12 2,491.00 IDEXX DISTRIBUTION, INC 1115 AP 116 10/28/2015 October A/P Lab supplies 171.21 2,662.21 IDEXX DISTRIBUTION, INC 1115 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,662.21 2,662.21 ** 13,000.00 Budgeted 10,337.79 Remaining 20 % Used Account: 135-69005-020-000 Capital Outlays .00 .00 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 .00 ** 150,000.00 Budgeted 150,000.00 Remaining 0 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 21,280.00 Budgeted 21,280.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 197.00 Budgeted 197.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 83,341.55 ** 1,912,109.00 Budgeted 1,828,767.45 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 29 10/01/2015 Reverse Accrued Sept Wages (900.00) (900.00) GL 22 10/09/2015 MUD Payroll 10/9/15 Salaries & Wages 900.00 .00 PR 80 10/23/2015 MUD Payroll 10/23/15 Salaries & Wages 500.00 500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 500.00 ** 12,500.00 Budgeted 12,000.00 Remaining 4 % Used Account: 135-50030-026-000 Social Security Taxes 29 10/01/2015 Reverse Accrued Sept Wages (55.80) (55.80) GL 22 10/09/2015 MUD Payroll 10/9/15 Social Security Taxes 55.80 .00 PR 80 10/23/2015 MUD Payroll 10/23/15 Social Security Taxes 31.00 31.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 31.00 ** 775.00 Budgeted 744.00 Remaining 4 % Used Account: 135-50035-026-000 Medicare Taxes 29 10/01/2015 Reverse Accrued Sept Wages (13.05) (13.05) GL 22 10/09/2015 MUD Payroll 10/9/15 Medicare Taxes 13.05 .00 PR 80 10/23/2015 MUD Payroll 10/23/15 Medicare Taxes 7.25 7.25 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 7.25 ** 181.00 Budgeted 173.75 Remaining 4 % Used Account: 135-50040-026-000 Unemployment Taxes 29 10/01/2015 Reverse Accrued Sept Wages (.90) (.90) GL 22 10/09/2015 MUD Payroll 10/9/15 Unemployment Taxes .90 .00 PR 80 10/23/2015 MUD Payroll 10/23/15 Unemployment Taxes .50 .50 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .50 .50 ** 230.00 Budgeted 229.50 Remaining 0 % Used Account: 135-50045-026-000 Workman's Compensation 132 10/01/2015 Prepaid Insurance, W/C Oct 3.08 3.08 GL 145 10/01/2015 Prepaid Ins, W/C rounding .01 3.09 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.09 3.09 ** 37.00 Budgeted 33.91 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-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 Account: 135-60070-026-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training .00 .00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses 166 10/26/2015 JPChase 9/29-10/26/15 PROFLOWERS.COM 50.48 50.48 PROFLOWERS.COM PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 50.48 50.48 ** 2,000.00 Budgeted 1,949.52 Remaining 3 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 592.32 ** 26,573.00 Budgeted 25,980.68 Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 29 10/01/2015 Reverse Accrued Sept Wages (14,410.72) (14,410.72) GL 22 10/09/2015 MUD Payroll 10/9/15 Salaries & Wages 18,128.97 3,718.25 PR 80 10/23/2015 MUD Payroll 10/23/15 Salaries & Wages 18,635.92 22,354.17 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 22,354.17 22,354.17 ** 488,508.00 Budgeted 466,153.83 Remaining 5 % Used Account: 135-50010-030-000 Overtime 29 10/01/2015 Reverse Accrued Sept Wages (29.72) (29.72) GL 22 10/09/2015 MUD Payroll 10/9/15 Overtime 32.37 2.65 PR 80 10/23/2015 MUD Payroll 10/23/15 Overtime 30.99 33.64 PR _______________ Account: 135-50010-030-000 Overtime Totals: 33.64 33.64 ** 1,000.00 Budgeted 966.36 Remaining 3 % Used Account: 135-50016-030-000 Longevity .00 .00 _______________ Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 3,823.00 Budgeted 3,823.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 29 10/01/2015 Reverse Accrued Sept Wages (1,286.61) (1,286.61) GL 22 10/09/2015 MUD Payroll 10/9/15 Retirement 1,618.17 331.56 PR 80 10/23/2015 MUD Payroll 10/23/15 Retirement 1,663.23 1,994.79 PR _______________ Account: 135-50020-030-000 Retirement Totals: 1,994.79 1,994.79 ** 43,202.00 Budgeted 41,207.21 Remaining 5 % Used Account: 135-50026-030-000 Medical Insurance 29 10/01/2015 Reverse Accrued Sept Wages (2,055.32) (2,055.32) GL 22 10/09/2015 MUD Payroll 10/9/15 Medical Insurance 2,583.19 527.87 PR 80 10/23/2015 MUD Payroll 10/23/15 Medical Insurance 2,583.14 3,111.01 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,111.01 3,111.01 ** 68,196.00 Budgeted 65,084.99 Remaining 5 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 29 10/01/2015 Reverse Accrued Sept Wages (144.89) (144.89) GL 22 10/09/2015 MUD Payroll 10/9/15 Dental Insurance 182.11 37.22 PR 80 10/23/2015 MUD Payroll 10/23/15 Dental Insurance 182.13 219.35 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 219.35 219.35 ** 4,807.00 Budgeted 4,587.65 Remaining 5 % Used Account: 135-50028-030-000 Vision Insurance 29 10/01/2015 Reverse Accrued Sept Wages (33.51) (33.51) GL 22 10/09/2015 MUD Payroll 10/9/15 Vision Insurance 42.16 8.65 PR 80 10/23/2015 MUD Payroll 10/23/15 Vision Insurance 42.22 50.87 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 50.87 50.87 ** 1,114.00 Budgeted 1,063.13 Remaining 5 % Used Account: 135-50029-030-000 Life Insurance & Other 2 10/01/2015 Reverse Prepaids Oct Metlife paid Sept 335.64 335.64 GL 98 10/22/2015 October A/P Café 125 Admin Fee 33.78 369.42 BenefitMall 1090 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 369.42 369.42 ** 4,431.00 Budgeted 4,061.58 Remaining 8 % Used Account: 135-50030-030-000 Social Security Taxes 29 10/01/2015 Reverse Accrued Sept Wages (831.27) (831.27) GL 22 10/09/2015 MUD Payroll 10/9/15 Social Security Taxes 1,055.31 224.04 PR 80 10/23/2015 MUD Payroll 10/23/15 Social Security Taxes 1,087.81 1,311.85 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,311.85 1,311.85 ** 30,823.00 Budgeted 29,511.15 Remaining 4 % Used Account: 135-50035-030-000 Medicare Taxes 29 10/01/2015 Reverse Accrued Sept Wages (194.42) (194.42) GL 22 10/09/2015 MUD Payroll 10/9/15 Medicare Taxes 246.81 52.39 PR 80 10/23/2015 MUD Payroll 10/23/15 Medicare Taxes 254.40 306.79 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 306.79 306.79 ** 7,599.00 Budgeted 7,292.21 Remaining 4 % Used Account: 135-50040-030-000 Unemployment Taxes . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 .00 ** 1,449.00 Budgeted 1,449.00 Remaining 0 % Used Account: 135-50045-030-000 Workman's Compensation 132 10/01/2015 Prepaid Insurance, W/C Oct 147.89 147.89 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 147.89 ** 1,554.00 Budgeted 1,406.11 Remaining 10 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 166 10/26/2015 JPChase 9/29-10/26/15 RECEPT PHARMACY 01 572.28 572.28 RECEPT PHARMACY 01 PC 166 10/26/2015 JPChase 9/29-10/26/15 LA SCALA 36.55 608.83 LA SCALA PC 166 10/26/2015 JPChase 9/29-10/26/15 ROANOKE FLORIST 62.50 671.33 ROANOKE FLORIST PC 166 10/26/2015 JPChase 9/29-10/26/15 PROFLOWERS.COM 75.73 747.06 PROFLOWERS.COM PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 747.06 747.06 ** 5,000.00 Budgeted 4,252.94 Remaining 15 % Used Account: 135-55030-030-000 Software & Support 7 10/01/2015 October A/P Systems support contract renew 486.78 486.78 Data Management Inc. 1030 AP 89 10/01/2015 Reverse Prepaids Wholesale Carrier Svcs 1,163.56 1,650.34 GL 35 10/08/2015 October A/P Annual pmt for IT support 10/1 1,875.00 3,525.34 M3 Networks 1048 AP 58 10/08/2015 Recode M3 Cell phone support (1,875.00) 1,650.34 GL 66 10/15/2015 October A/P Internet 11/1-11/30/15 1,163.56 2,813.90 WHOLESALE CARRIER SERVICES INC 1079 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 2,813.90 2,813.90 ** 78,483.00 Budgeted 75,669.10 Remaining 4 % Used Account: 135-55070-030-000 Independent Labor 35 10/08/2015 October A/P Backflow Tracking Annual Fee F 595.00 595.00 SC TRACKING SOLUTIONS LLC 1050 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55070-030-000 Independent Labor Totals: 595.00 595.00 ** 12,000.00 Budgeted 11,405.00 Remaining 5 % Used Account: 135-55080-030-000 Maintenance & Repairs 202 10/31/2015 October A/P Duplicate keys, rekey, repair 90.50 90.50 MICHAEL'S KEYS INC. 1151 AP 252 10/31/2015 October A/P Oct Mowing 1,290.00 1,380.50 WATTS ELLISON LLC 1193 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 1,380.50 1,380.50 ** 29,500.00 Budgeted 28,119.50 Remaining 5 % Used Account: 135-55100-030-000 Building Maint & Supplies 98 10/22/2015 October A/P Fix thermostat message 125.00 125.00 BRANDON R REED 1091 AP 98 10/22/2015 October A/P Annual inspection - fire alarm 200.00 325.00 PRO FIRE & SPRINKLER LLC 1100 AP 116 10/28/2015 October A/P Rug cleaning 130.89 455.89 G & K SERVICES 1111 AP 116 10/28/2015 October A/P Rug cleaning 130.89 586.78 G & K SERVICES 1111 AP 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (130.89) 455.89 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 455.89 455.89 ** 7,000.00 Budgeted 6,544.11 Remaining 7 % Used Account: 135-55120-030-000 Cleaning Services 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (259.00) (259.00) AR 252 10/31/2015 October A/P Oct Janitorial Service 843.75 584.75 MEMBER'S BUILDING MAINTENANCE 1185 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 584.75 584.75 ** 10,125.00 Budgeted 9,540.25 Remaining 6 % Used Account: 135-55160-030-000 Professional Outside Services 58 10/08/2015 Recode M3 Cell phone support 1,875.00 1,875.00 GL 66 10/15/2015 October A/P Annual IT Contract 49,200.00 51,075.00 M3 Networks 1074 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 51,075.00 51,075.00 ** 61,075.00 Budgeted 10,000.00 Remaining 84 % Used Account: 135-55165-030-000 Collection Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 252 10/31/2015 October A/P October Utility Billing 654.50 654.50 DATAPROSE LLC 1180 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 654.50 654.50 ** 8,200.00 Budgeted 7,545.50 Remaining 8 % Used Account: 135-60005-030-000 Telephone 35 10/08/2015 October A/P Answering service 10/19-11/15/ 206.73 206.73 KEYSTONE PARK SECRETARIAL 1047 AP 166 10/26/2015 JPChase 9/29-10/26/15 ATT*BUS PHONE PMT 834.62 1,041.35 ATT*BUS PHONE PMT PC 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (445.85) 595.50 AR _______________ Account: 135-60005-030-000 Telephone Totals: 595.50 595.50 ** 16,349.00 Budgeted 15,753.50 Remaining 4 % Used Account: 135-60010-030-000 Communications/Mobiles 66 10/15/2015 October A/P Cell phones 10/02-11/1/15 37.99 37.99 VERIZON WIRELESS 1078 AP 80 10/23/2015 MUD Payroll 10/23/15 Communications/Mobiles 300.00 337.99 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 337.99 ** 4,150.00 Budgeted 3,812.01 Remaining 8 % Used Account: 135-60020-030-000 Electricity/Gas .00 .00 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 10,768.00 Budgeted 10,768.00 Remaining 0 % Used Account: 135-60025-030-000 Water 156 10/31/2015 Bill Town Inv 1362-1371 AR 20151031-20151031 User: (112.88) (112.88) AR _______________ Account: 135-60025-030-000 Water Totals: (112.88) (112.88) ** 1,500.00 Budgeted 1,612.88 Remaining -8 % Used Account: 135-60035-030-000 Postage . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 66 10/15/2015 October A/P Prepaid postage for meter 500.00 500.00 CMRS-FP 1068 AP 66 10/15/2015 October A/P Overnight letter 5.24 505.24 FEDERAL EXPRESS CORP 1070 AP 116 10/28/2015 October A/P Annual Fee - Permit#3 225.00 730.24 U.S. POSTAL SERVICE 1125 AP 252 10/31/2015 October A/P October Utility Billing 1,801.30 2,531.54 DATAPROSE LLC 1180 AP _______________ Account: 135-60035-030-000 Postage Totals: 2,531.54 2,531.54 ** 28,932.00 Budgeted 26,400.46 Remaining 9 % Used Account: 135-60040-030-000 Service Charges & Fees 223 10/02/2015 Credit card fees/Oct 93.12 93.12 GL 223 10/02/2015 Credit card fees/Oct 6,320.96 6,414.08 GL 81 10/09/2015 Safe Deposit Box-Bank of West 40.00 6,454.08 GL 208 10/14/2015 Bank Analysis Fee- September 250.00 6,704.08 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 6,704.08 6,704.08 ** 44,000.00 Budgeted 37,295.92 Remaining 15 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 132 10/01/2015 Prepaid Insurance, W/C Oct 2,756.00 2,756.00 GL 202 10/31/2015 October A/P Notary Bond - Slaght 33.25 2,789.25 CNA SURETY 1135 AP _______________ Account: 135-60055-030-000 Insurance Totals: 2,789.25 2,789.25 ** 52,797.00 Budgeted 50,007.75 Remaining 5 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 7 10/01/2015 October A/P AWWA dues 11/1/15-10/31/16 325.00 325.00 AMERICAN WATER WORKS ASSOC AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 57 10/01/2015 Void AWWA Invoice AWWA dues 11/1/15-10/31/16 (325.00) .00 AMERICAN WATER WORKS ASSOC AP 116 10/28/2015 October A/P Annual membership fee CO-OP 100.00 100.00 TX COMPTROLLER 1124 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 100.00 100.00 ** 6,000.00 Budgeted 5,900.00 Remaining 2 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training .00 .00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 .00 ** 9,935.00 Budgeted 9,935.00 Remaining 0 % Used Account: 135-60100-030-000 Travel & per diem 29 10/01/2015 Reverse Accrued Sept Wages (29.32) (29.32) GL 22 10/09/2015 MUD Payroll 10/9/15 Travel & per diem 29.32 .00 PR 66 10/15/2015 October A/P Mileage to Denton County offic 103.27 103.27 LAURIE SLAGHT 1073 AP 80 10/23/2015 MUD Payroll 10/23/15 Travel & per diem 10.64 113.91 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 113.91 113.91 ** 5,400.00 Budgeted 5,286.09 Remaining 2 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60115-030-000 Elections .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 202 10/31/2015 October A/P Notice of Adoption of Rules - 675.36 675.36 STAR-TELEGRAM OPERATING LTD 1161 AP _______________ Account: 135-60125-030-000 Advertising Totals: 675.36 675.36 ** 7,500.00 Budgeted 6,824.64 Remaining 9 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 66 10/15/2015 October A/P Notary bonds - Laurie Slaght, 42.00 42.00 OFC OF THE SECRETARY OF STATE 1075 AP 166 10/26/2015 JPChase 9/29-10/26/15 DENTON CO TX MOTOR VEH 1.00 43.00 DENTON CO TX MOTOR VEH PC 166 10/26/2015 JPChase 9/29-10/26/15 VCN*DENTONRECCTR 108.00 151.00 VCN*DENTONRECCTR PC 166 10/26/2015 JPChase 9/29-10/26/15 VCN*DENTONRECCTR 129.00 280.00 VCN*DENTONRECCTR PC 166 10/26/2015 JPChase 9/29-10/26/15 RINGCENTRAL, INC 9.99 289.99 RINGCENTRAL, INC PC 252 10/31/2015 October A/P Misc Admin Fee 35.00 324.99 TX SOCIAL SECURITY PROGRAM 1190 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 324.99 324.99 ** 17,501.00 Budgeted 17,176.01 Remaining 2 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 1,855.00 Budgeted 1,855.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware .00 .00 _______________ Account: 135-65055-030-000 Hardware Totals: .00 .00 ** 29,594.00 Budgeted 29,594.00 Remaining 0 % Used Account: 135-65085-030-000 Office Supplies .00 .00 _______________ Account: 135-65085-030-000 Office Supplies Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 166 10/26/2015 JPChase 9/29-10/26/15 SHI GOVERNMENT SOLUTIO 221.30 221.30 SHI GOVERNMENT SOLUTIO PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 221.30 221.30 ** 4,003.00 Budgeted 3,781.70 Remaining 6 % Used Account: 135-65095-030-000 Maintenance Supplies 166 10/26/2015 JPChase 9/29-10/26/15 AMAZON MKTPLACE PMTS 10.68 10.68 AMAZON MKTPLACE PMTS PC 166 10/26/2015 JPChase 9/29-10/26/15 AMAZON MKTPLACE PMTS 80.07 90.75 AMAZON MKTPLACE PMTS PC 166 10/26/2015 JPChase 9/29-10/26/15 AMAZON MKTPLACE PMTS 359.00 449.75 AMAZON MKTPLACE PMTS PC 166 10/26/2015 JPChase 9/29-10/26/15 AMAZON MKTPLACE PMTS 37.88 487.63 AMAZON MKTPLACE PMTS PC 166 10/26/2015 JPChase 9/29-10/26/15 SAMS CLUB #4795 196.87 684.50 SAMS CLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 684.50 684.50 ** 5,000.00 Budgeted 4,315.50 Remaining 14 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-030-000 Capital Outlays .00 .00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** 56,000.00 Budgeted 56,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 116 10/28/2015 October A/P Copier maintenance 156.94 156.94 KYOCERA DOCUMENT SOLUTIONS 1116 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 156.94 156.94 ** 4,600.00 Budgeted 4,443.06 Remaining 3 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 103,328.86 ** 1,210,323.00 Budgeted 1,106,994.14 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 84 10/21/2015 Bill OTD Legal fees AR 20151021-20151021 User: (1,296.50) (1,296.50) AR 111 10/21/2015 Rev A/R Inv1360/OTD AR 20151021-20151021 User: 1,296.50 .00 AR 173 10/21/2015 Legal/OTD (1,296.50) (1,296.50) GL 202 10/31/2015 October A/P October Legal Services 1,980.00 683.50 FREEMAN & CORBETT 1139 AP _______________ Account: 135-55045-039-000 Legal Totals: 683.50 683.50 ** 386,130.00 Budgeted 385,446.50 Remaining 0 % Used Account: 135-55055-039-000 Auditing 89 10/01/2015 Reverse Prepaids Lafollett Retainer 5,000.00 5,000.00 GL _______________ Account: 135-55055-039-000 Auditing Totals: 5,000.00 5,000.00 ** 22,750.00 Budgeted 17,750.00 Remaining 22 % Used Account: 135-55060-039-000 Appraisal .00 .00 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 .00 ** 10,265.00 Budgeted 10,265.00 Remaining 0 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 3,800.00 Budgeted 3,800.00 Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 5,683.50 ** 422,945.00 Budgeted 417,261.50 Remaining 1 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (476,449.36) .00 Budgeted 476,449.36 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund 235 10/01/2015 GASB 34 transfers Fiscal 2016 Town Elevated Tank (45,000.00) (45,000.00) GL 235 10/01/2015 GASB 34 transfers Fiscal 2016 Water Replacement (30,000.00) (75,000.00) GL _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: (75,000.00) (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept 235 10/01/2015 GASB 34 transfers Fiscal 2016 Fire Truck Future Replacement (41,420.00) (41,420.00) GL 250 10/01/2015 GASB Xfer FD/realloc unassigne (40,000.00) (81,420.00) GL _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: (81,420.00) (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (156,420.00) ** .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (156,420.00) .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 209 10/31/2015 Bank Interest/October (1.75) (1.75) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (1.75) (1.75) ** .00 Budgeted 1.75 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1.75) ** .00 Budgeted 1.75 Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ (1.75) .00 Budgeted 1.75 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET OCTOBER 2015 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,378,922 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,378,922 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 359 TOTAL FUND BALANCE 4,378,922 TOTAL LIABILITIES AND FUND BALANCE 4,378,922 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 10:49 11/12/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 2,338.31- 2,338.31- 2,338.31 517-49105-000-000 Bond Proceeds 5,765,000.00- 5,765,000.00- 5,765,000.00 Subtotal: 5,767,338.31- 5,767,338.31- 5,767,338.31 Program number: 5,767,338.31- 5,767,338.31- 5,767,338.31 Department number: Revenues 5,767,338.31- 5,767,338.31- 5,767,338.31 Revenues Subtotal ----------- 5,767,338.31- 5,767,338.31- 5,767,338.31 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 10:49 11/12/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60135-020-000 TCEQ Permits & Fees 14,376.56 14,376.56 14,376.56- 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 1,074,337.15 1,074,337.15- Subtotal: 1,088,713.71 1,088,713.71 1,088,713.71- 517-69005-020-000 Capital Outlays 151,502.50 151,502.50 151,502.50- Subtotal: 151,502.50 151,502.50 151,502.50- 517-70020-020-000 Bond Issuance 148,200.00 148,200.00 148,200.00- Subtotal: 148,200.00 148,200.00 148,200.00- Program number: 1,388,416.21 1,388,416.21 1,388,416.21- Department number: Wastewater 1,388,416.21 1,388,416.21 1,388,416.21- Expenditures Subtotal ----------- 1,388,416.21 1,388,416.21 1,388,416.21- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 4,378,922.10- 4,378,922.10- 4,378,922.10 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 209 10/31/2015 Bank Interest/October (1,979.06) (359.25) (2,338.31) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (359.25) (2,338.31) ** .00 Budgeted 2,338.31 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds (5,765,000.00) .00 (5,765,000.00) _______________ Account: 517-49105-000-000 Bond Proceeds Totals: .00 (5,765,000.00) ** .00 Budgeted 5,765,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,767,338.31) ** .00 Budgeted 5,767,338.31 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-60135-020-000 TCEQ Permits & Fees 14,376.56 .00 14,376.56 _______________ Account: 517-60135-020-000 TCEQ Permits & Fees Totals: .00 14,376.56 ** .00 Budgeted (14,376.56) Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 .00 1,074,337.15 _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 1,074,337.15 ** .00 Budgeted (1,074,337.15) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 151,502.50 .00 151,502.50 _______________ Account: 517-69005-020-000 Capital Outlays Totals: .00 151,502.50 ** .00 Budgeted (151,502.50) Remaining 0 % Used Account: 517-70020-020-000 Bond Issuance 148,200.00 .00 148,200.00 _______________ Account: 517-70020-020-000 Bond Issuance Totals: .00 148,200.00 ** .00 Budgeted (148,200.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,388,416.21 ** .00 Budgeted (1,388,416.21) Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (4,378,922.10) .00 Budgeted 4,378,922.10 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET OCTOBER 2015 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 8,535,893 ACCOUNTS RECEIVABLE 570 TOTAL ASSETS 8,536,463 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 201,659 TOTAL LIABILITIES 201,659 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES 700 TOTAL FUND BALANCE 8,334,804 TOTAL LIABILITIES AND FUND BALANCE 8,536,463 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 10:49 11/12/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 700.26- 700.26- 700.26 Subtotal: 700.26- 700.26- 700.26 Program number: 700.26- 700.26- 700.26 Department number: Revenues 700.26- 700.26- 700.26 Revenues Subtotal ----------- 700.26- 700.26- 700.26 Fund number: 518 2015 Revenue Bond Const Fund 700.26- 700.26- 700.26 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 209 10/31/2015 Bank Interest/October (700.26) (700.26) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (700.26) (700.26) ** .00 Budgeted 700.26 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (700.26) ** .00 Budgeted 700.26 Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ (700.26) .00 Budgeted 700.26 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2015 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 102,804 ACCOUNTS RECEIVABLE - TOTAL ASSETS 102,804 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 30,842 TOTAL FUND BALANCE 102,804 TOTAL LIABILITIES AND FUND BALANCE 102,804 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 10:49 11/12/15 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 8.07- 8.07- 8.07 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 30,834.00- 30,834.00- 25.000 92,502.00- Subtotal: 123,336.00- 123,336.00- 30,842.07- 30,842.07- 25.007 92,493.93- Program number: 123,336.00- 123,336.00- 30,842.07- 30,842.07- 25.007 92,493.93- Department number: 123,336.00- 123,336.00- 30,842.07- 30,842.07- 25.007 92,493.93- Revenues Subtotal ----------- 123,336.00- 123,336.00- 30,842.07- 30,842.07- 25.007 92,493.93- Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 30,842.07- 30,842.07- 25.007 92,493.93- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 209 10/31/2015 Bank Interest/October (8.07) (8.07) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (8.07) (8.07) ** .00 Budgeted 8.07 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 51 10/06/2015 O&M to Rev Bond Res-3 mos (30,834.00) (30,834.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (30,834.00) (30,834.00) ** (123,336.00) Budgeted (92,502.00) Remaining 25 % Used Department Totals: ------------------------------------------------------------------------------------------------ (30,842.07) ** (123,336.00) Budgeted (92,493.93) Remaining 25 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (30,842.07) (123,336.00) Budgeted (92,493.93) Remaining 25 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET OCTOBER 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 23,375 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 670,853 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 699,074 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 670,853 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 670,853 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 4,049 TOTAL FUND BALANCE 28,222 TOTAL LIABILITIES AND FUND BALANCE 699,074 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 10:49 11/12/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 667,898.00- 667,898.00- 3,940.07- 3,940.07- .590 663,957.93- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 74.30- 74.30- 3.230 2,225.70- 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 33.14- 33.14- 1.841 1,766.86- Subtotal: 671,998.00- 671,998.00- 4,047.51- 4,047.51- .602 667,950.49- 533-49010-000-000 Interest Income 140.00- 140.00- 1.65- 1.65- 1.179 138.35- 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 119,706.00- Subtotal: 334,225.00- 334,225.00- 1.65- 1.65- 334,223.35- Program number: 1,006,223.00- 1,006,223.00- 4,049.16- 4,049.16- .402 1,002,173.84- Department number: Revenues 1,006,223.00- 1,006,223.00- 4,049.16- 4,049.16- .402 1,002,173.84- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 4,049.16- 4,049.16- .402 1,002,173.84- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 10:49 11/12/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 2,550.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 316,983.00 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 685,000.00 685,000.00 Subtotal: 1,004,533.00 1,004,533.00 1,004,533.00 Program number: 1,004,533.00 1,004,533.00 1,004,533.00 Department number: Administration 1,004,533.00 1,004,533.00 1,004,533.00 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 1,004,533.00 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 4,049.16- 4,049.16- 239.595 2,359.16 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 188 10/09/2015 Property Taxes (489.18) (489.18) GL 190 10/13/2015 Property Taxes (4.65) (493.83) GL 191 10/15/2015 Property Taxes (301.23) (795.06) GL 192 10/16/2015 Property Taxes (313.26) (1,108.32) GL 193 10/19/2015 Property Taxes (167.41) (1,275.73) GL 194 10/20/2015 Property Taxes (180.64) (1,456.37) GL 195 10/21/2015 Property Taxes (401.37) (1,857.74) GL 196 10/26/2015 Property Taxes (705.92) (2,563.66) GL 197 10/27/2015 Property Taxes (101.79) (2,665.45) GL 198 10/28/2015 Property Taxes (134.57) (2,800.02) GL 199 10/29/2015 Property Taxes (682.67) (3,482.69) GL 238 10/30/2015 Property Taxes (457.38) (3,940.07) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (3,940.07) (3,940.07) ** (667,898.00) Budgeted (663,957.93) Remaining 1 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 182 10/02/2015 Property Taxes (170.22) (170.22) GL 187 10/08/2015 Property Taxes (.08) (170.30) GL 189 10/12/2015 Property Taxes 62.79 (107.51) GL 197 10/27/2015 Property Taxes 10.48 (97.03) GL 198 10/28/2015 Property Taxes 22.73 (74.30) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (74.30) (74.30) ** (2,300.00) Budgeted (2,225.70) Remaining 3 % Used Account: 533-40015-000-000 Property Taxes/P & I 182 10/02/2015 Property Taxes (33.13) (33.13) GL 187 10/08/2015 Property Taxes (.01) (33.14) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (33.14) (33.14) ** (1,800.00) Budgeted (1,766.86) Remaining 2 % Used Account: 533-49010-000-000 Interest Income 209 10/31/2015 Bank Interest/October (1.65) (1.65) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1.65) (1.65) ** (140.00) Budgeted (138.35) Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (214,379.00) Budgeted (214,379.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg .00 .00 _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 .00 ** (119,706.00) Budgeted (119,706.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4,049.16) ** (1,006,223.00) Budgeted (1,002,173.84) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,550.00 Budgeted 2,550.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 316,983.00 Budgeted 316,983.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 685,000.00 Budgeted 685,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 1,004,533.00 Budgeted 1,004,533.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (4,049.16) (1,690.00) Budgeted 2,359.16 Remaining 240 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET OCTOBER 2015 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,070 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,070 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,069 NET REVENUES / EXPENDITURES 1 TOTAL FUND BALANCE 15,070 TOTAL LIABILITIES AND FUND BALANCE 15,070 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 10:49 11/12/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 7.00- 7.00- 1.27- 1.27- 18.143 5.73- 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 444,831.00- Subtotal: 444,838.00- 444,838.00- 1.27- 1.27- 444,836.73- Program number: 444,838.00- 444,838.00- 1.27- 1.27- 444,836.73- Department number: Revenues 444,838.00- 444,838.00- 1.27- 1.27- 444,836.73- Revenues Subtotal ----------- 444,838.00- 444,838.00- 1.27- 1.27- 444,836.73- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 209 10/31/2015 Bank Interest/October (1.27) (1.27) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (1.27) (1.27) ** (7.00) Budgeted (5.73) Remaining 18 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales .00 .00 _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 .00 ** (444,831.00) Budgeted (444,831.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1.27) ** (444,838.00) Budgeted (444,836.73) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 10:49 11/12/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 234,838.00 Budgeted 234,838.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 210,000.00 Budgeted 210,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 444,838.00 Budgeted 444,838.00 Remaining 0 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (1.27) .00 Budgeted 1.27 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (4,798,480.67) **** (125,026.00) Budgeted 4,673,454.67 Remaining ########## ******* End of Report *********