Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
December Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET DECEMBER 31, 2013 122 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 1,217,480 PREPAID EXPENSES 15,048 ADVALOREM PROPERTY TAXES RECEIVABLE 472,055 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 77,484 UTILITY AND OTHER ACCOUNTS RECEIVABLE 719 TOTAL ASSETS 1,782,786 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 549,539 ACCOUNTS AND OTHER PAYABLES 223,548 TOTAL LIABILITIES 773,087 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE 2,141 UNASSIGNED FUND BALANCE 493,547 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 514,011 TOTAL FUND BALANCE 1,009,699 TOTAL LIABILITIES AND FUND BALANCE 1,782,786 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 14:27 01/13/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 305,445.00- 305,445.00- 213,669.51- 231,392.73- 75.756 74,052.27- 122-40003-000-000 Emer Svcs Assessmen/Delinquent .65- .65 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 422,631.57- 472,016.59- 50.888 455,538.41- 122-40011-000-000 Property Taxes/Fire-Delinquent 53.56- 51.40 51.40- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- .15- .020 749.85- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 2.91- 71.40- 1.587 4,428.60- Subtotal: 1,238,250.00- 1,238,250.00- 636,357.55- 703,430.12- 56.808 534,819.88- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 800.00- 13.333 5,200.00- Subtotal: 6,000.00- 6,000.00- 800.00- 13.333 5,200.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 150.00- 21.429 550.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,700.00- 10,700.00- 150.00- 1.402 10,550.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 100.00- 1,350.00- 22.500 4,650.00- Subtotal: 6,000.00- 6,000.00- 100.00- 1,350.00- 22.500 4,650.00- Program number: 1,260,950.00- 1,260,950.00- 636,457.55- 705,730.12- 55.968 555,219.88- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 636,457.55- 705,730.12- 55.968 555,219.88- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 636,457.55- 705,730.12- 55.968 555,219.88- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 14:27 01/13/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 455,916.00 455,916.00 33,722.40 101,148.81 22.186 354,767.19 122-50010-045-000 Overtime 44,225.00 44,225.00 3,403.60 8,747.20 19.779 35,477.80 122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,289.86 98.232 239.14 122-50016-045-000 Longevity 4,768.00 4,768.00 4,655.00 4,655.00 97.630 113.00 122-50017-045-000 Certification 4,350.00 4,350.00 350.00 1,076.89 24.756 3,273.11 122-50020-045-000 Retirement 70,991.00 70,991.00 5,827.19 17,717.68 24.958 53,273.32 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,008.69 12,025.84 21.110 44,942.16 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 326.26 978.72 23.138 3,251.28 122-50028-045-000 Vision Insurance 892.00 892.00 68.43 205.14 22.998 686.86 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 306.94 920.68 21.663 3,329.32 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 2,416.04 7,443.33 22.569 25,536.67 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 564.89 1,740.30 22.563 5,972.70 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 .67 2.25 .100 2,256.75 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.79 1,988.37 22.834 6,719.63 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 500.00 122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 56,312.90 171,940.07 24.119 540,938.93 122-55030-045-000 Software & Support 8,682.00 8,682.00 8,682.00 122-55045-045-000 Legal 5,000.00 5,000.00 5,000.00 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 1,698.80 2,414.21 11.793 18,057.79 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 196.43 1,438.26 9.685 13,411.74 122-55095-045-000 Equipment Maintenance 692.83 692.83 692.83- 122-55100-045-000 Building Maintenance 49.02 49.02 49.02- Subtotal: 49,004.00 49,004.00 2,637.08 4,594.32 9.375 44,409.68 122-60005-045-000 Telephone 100.00 100.00 3.34 3.340 96.66 122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 212.47 884.21 20.869 3,352.79 122-60020-045-000 Electricity/Gas 6,568.00 6,568.00 886.08 1,544.00 23.508 5,024.00 122-60025-045-000 Water 1,500.00 1,500.00 321.72 342.17 22.811 1,157.83 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 122-60035-045-000 Postage 100.00 100.00 17.32 20.42 20.420 79.58 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 3,027.75 25.002 9,082.25 122-60066-045-000 Publications/Books/Subscrips 400.00 400.00 112.75 112.75 28.188 287.25 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 1,005.00 2,582.76 17.014 12,597.24 122-60080-045-000 Schools & Training 4,280.00 4,280.00 560.00 1,624.00 37.944 2,656.00 122-60096-045-000 Emergency Management 2,000.00 2,000.00 1,000.00 50.000 1,000.00 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 56.78 1,121.60 24.505 3,455.40 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 200.00 200.00 200.00 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 341.17 7.582 4,158.83 122-60180-045-000 Fire Inspection/Enforcement 1,500.00 1,500.00 1,500.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 14:27 01/13/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 37.50 37.50 1.875 1,962.50 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 87.37 87.37 8.737 912.63 Subtotal: 276,531.00 276,531.00 4,306.24 12,729.04 4.603 263,801.96 122-65005-045-000 Fuel & Lube 11,698.00 11,698.00 664.64 2,094.14 17.902 9,603.86 122-65010-045-000 Uniforms 3,360.00 3,360.00 89.83 2.674 3,270.17 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 7,600.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 1,000.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 76.46 76.46 3.058 2,423.54 122-65085-045-000 Office Supplies 1,000.00 1,000.00 56.95 84.44 8.444 915.56 122-65095-045-000 Maintenance Supplies 111.16 111.16 111.16- 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 27,258.00 909.21 2,456.03 9.010 24,801.97 122-69008-045-000 Short Term Debt-Principal 70,000.00 70,000.00 70,000.00 122-69009-045-000 Short Term Debt-Interest 3,031.00 3,031.00 3,031.00 122-69050-045-000 Radios 34,200.00 34,200.00 34,200.00 122-69195-045-000 GASB34/Reserve for Replacement 67,647.00 67,647.00 67,647.00 122-69255-045-000 Airpacks 20,400.00 20,400.00 20,400.00 Subtotal: 195,278.00 195,278.00 195,278.00 Program number: 1,260,950.00 1,260,950.00 64,165.43 191,719.46 15.204 1,069,230.54 Department number: Fire 1,260,950.00 1,260,950.00 64,165.43 191,719.46 15.204 1,069,230.54 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 64,165.43 191,719.46 15.204 1,069,230.54 Fund number: 122 Trophy Club MUD Fire Dept. 572,292.12- 514,010.66- 514,010.66 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2013 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 538 12/02/2013 Property Taxes & Assessments (17,723.22) (411.21) (18,134.43) GL 545 12/03/2013 Property Taxes & Assessments (1,843.53) (19,977.96) GL 546 12/04/2013 Property Taxes & Assessments (1,286.06) (21,264.02) GL 547 12/05/2013 Property Taxes & Assessments (44.06) (21,308.08) GL 548 12/10/2013 Property Taxes & Assessments (2,414.55) (23,722.63) GL 556 12/11/2013 Property Taxes & Assessments (2,216.78) (25,939.41) GL 557 12/12/2013 Property Taxes & Assessments (9,614.71) (35,554.12) GL 558 12/13/2013 Property Taxes & Assessments (1,343.89) (36,898.01) GL 559 12/16/2013 Property Taxes & Assessments (1,816.65) (38,714.66) GL 560 12/17/2013 Property Taxes & Assessments (2,012.02) (40,726.68) GL 561 12/18/2013 Property Taxes & Assessments (2,722.78) (43,449.46) GL 562 12/19/2013 Property Taxes & Assessments (2,988.03) (46,437.49) GL 563 12/20/2013 Property Taxes & Assessments (3,438.22) (49,875.71) GL 564 12/23/2013 Property Taxes & Assessments (2,239.32) (52,115.03) GL 565 12/26/2013 Property Taxes & Assessments (4,294.86) (56,409.89) GL 566 12/27/2013 Property Taxes & Assessments (150,619.30) (207,029.19) GL 567 12/30/2013 Property Taxes & Assessments (1,062.07) (208,091.26) GL 568 12/31/2013 Property Taxes & Assessments (23,301.47) (231,392.73) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (213,669.51) (231,392.73) ** (305,445.00) Budgeted (74,052.27) Remaining 76 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (.65) .00 (.65) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (.65) ** .00 Budgeted .65 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 538 12/02/2013 Property Taxes & Assessments (49,385.02) (5,279.39) (54,664.41) GL 545 12/03/2013 Property Taxes & Assessments (5,020.47) (59,684.88) GL 546 12/04/2013 Property Taxes & Assessments (3,097.95) (62,782.83) GL 547 12/05/2013 Property Taxes & Assessments (1,684.43) (64,467.26) GL 548 12/10/2013 Property Taxes & Assessments (3,711.99) (68,179.25) GL 556 12/11/2013 Property Taxes & Assessments (6,536.03) (74,715.28) GL 557 12/12/2013 Property Taxes & Assessments (33,130.96) (107,846.24) GL 558 12/13/2013 Property Taxes & Assessments (3,531.97) (111,378.21) GL 559 12/16/2013 Property Taxes & Assessments (6,194.98) (117,573.19) GL 560 12/17/2013 Property Taxes & Assessments (8,667.16) (126,240.35) GL 561 12/18/2013 Property Taxes & Assessments (7,604.62) (133,844.97) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 562 12/19/2013 Property Taxes & Assessments (49,385.02) (6,912.98) (140,757.95) GL 563 12/20/2013 Property Taxes & Assessments (6,372.23) (147,130.18) GL 564 12/23/2013 Property Taxes & Assessments (5,918.97) (153,049.15) GL 565 12/26/2013 Property Taxes & Assessments (15,340.05) (168,389.20) GL 566 12/27/2013 Property Taxes & Assessments (242,895.60) (411,284.80) GL 567 12/30/2013 Property Taxes & Assessments (7,545.48) (418,830.28) GL 568 12/31/2013 Property Taxes & Assessments (53,186.31) (472,016.59) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (422,631.57) (472,016.59) ** (927,555.00) Budgeted (455,538.41) Remaining 51 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 538 12/02/2013 Property Taxes & Assessments 104.96 (.38) 104.58 GL 556 12/11/2013 Property Taxes & Assessments 26.00 130.58 GL 567 12/30/2013 Property Taxes & Assessments (79.18) 51.40 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (53.56) 51.40 ** .00 Budgeted (51.40) Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I (.15) .00 (.15) _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 (.15) ** (750.00) Budgeted (749.85) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 538 12/02/2013 Property Taxes & Assessments (68.49) (.08) (68.57) GL 567 12/30/2013 Property Taxes & Assessments (2.83) (71.40) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (2.91) (71.40) ** (4,500.00) Budgeted (4,428.60) Remaining 2 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (800.00) .00 (800.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (800.00) ** (6,000.00) Budgeted (5,200.00) Remaining 13 % Used Account: 122-43400-000-000 Fire Inspections . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (150.00) .00 (150.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (150.00) ** (700.00) Budgeted (550.00) Remaining 21 % 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 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (1,250.00) (100.00) (1,350.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (100.00) (1,350.00) ** (6,000.00) Budgeted (4,650.00) Remaining 23 % Used Department Totals: ------------------------------------------------------------------------------------------------ (705,730.12) ** (1,260,950.00) Budgeted (555,219.88) Remaining 56 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 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 582 12/06/2013 FD Payroll 67,426.41 16,815.81 84,242.22 GL 584 12/20/2013 FD Payroll 16,906.59 101,148.81 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 33,722.40 101,148.81 ** 455,916.00 Budgeted 354,767.19 Remaining 22 % Used Account: 122-50010-045-000 Overtime 584 12/20/2013 FD Payroll 5,343.60 3,403.60 8,747.20 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,403.60 8,747.20 ** 44,225.00 Budgeted 35,477.80 Remaining 20 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,289.86 .00 13,289.86 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,289.86 ** 13,529.00 Budgeted 239.14 Remaining 98 % Used Account: 122-50016-045-000 Longevity 583 12/20/2013 FD Longevity 4,655.00 4,655.00 GL _______________ Account: 122-50016-045-000 Longevity Totals: 4,655.00 4,655.00 ** 4,768.00 Budgeted 113.00 Remaining 98 % Used Account: 122-50017-045-000 Certification 582 12/06/2013 FD Payroll 726.89 350.00 1,076.89 GL _______________ Account: 122-50017-045-000 Certification Totals: 350.00 1,076.89 ** 4,350.00 Budgeted 3,273.11 Remaining 25 % Used Account: 122-50020-045-000 Retirement 582 12/06/2013 FD Payroll 11,890.49 2,353.63 14,244.12 GL 583 12/20/2013 FD Longevity 654.46 14,898.58 GL 584 12/20/2013 FD Payroll 2,819.10 17,717.68 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,827.19 17,717.68 ** 70,991.00 Budgeted 53,273.32 Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 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 582 12/06/2013 FD Payroll 8,017.15 2,297.53 10,314.68 GL 584 12/20/2013 FD Payroll 1,711.16 12,025.84 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,008.69 12,025.84 ** 56,968.00 Budgeted 44,942.16 Remaining 21 % Used Account: 122-50027-045-000 Dental Insurance 582 12/06/2013 FD Payroll 652.46 163.13 815.59 GL 584 12/20/2013 FD Payroll 163.13 978.72 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 326.26 978.72 ** 4,230.00 Budgeted 3,251.28 Remaining 23 % Used Account: 122-50028-045-000 Vision Insurance 582 12/06/2013 FD Payroll 136.71 34.21 170.92 GL 584 12/20/2013 FD Payroll 34.22 205.14 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 68.43 205.14 ** 892.00 Budgeted 686.86 Remaining 23 % Used Account: 122-50029-045-000 Life Insurance & Other 582 12/06/2013 FD Payroll 613.74 153.49 767.23 GL 584 12/20/2013 FD Payroll 153.45 920.68 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 306.94 920.68 ** 4,250.00 Budgeted 3,329.32 Remaining 22 % Used Account: 122-50030-045-000 Social Security Taxes 582 12/06/2013 FD Payroll 5,027.29 966.24 5,993.53 GL 583 12/20/2013 FD Longevity 288.61 6,282.14 GL 584 12/20/2013 FD Payroll 1,161.19 7,443.33 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,416.04 7,443.33 ** 32,980.00 Budgeted 25,536.67 Remaining 23 % Used Account: 122-50035-045-000 Medicare Taxes 582 12/06/2013 FD Payroll 1,175.41 225.92 1,401.33 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 583 12/20/2013 FD Longevity 1,175.41 67.46 1,468.79 GL 584 12/20/2013 FD Payroll 271.51 1,740.30 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 564.89 1,740.30 ** 7,713.00 Budgeted 5,972.70 Remaining 23 % Used Account: 122-50040-045-000 Unemployment Taxes 582 12/06/2013 FD Payroll 1.58 .42 2.00 GL 584 12/20/2013 FD Payroll .25 2.25 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .67 2.25 ** 2,259.00 Budgeted 2,256.75 Remaining 0 % Used Account: 122-50045-045-000 Workman's Compensation 118 12/01/2013 FD Dec W/C expense 1,325.58 662.79 1,988.37 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.79 1,988.37 ** 8,708.00 Budgeted 6,719.63 Remaining 23 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support .00 .00 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 .00 ** 8,682.00 Budgeted 8,682.00 Remaining 0 % Used Account: 122-55045-045-000 Legal . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 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-55045-045-000 Legal Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 715.41 37.98 753.39 THE HOME DEPOT 6581 PC 438 12/01/2013 PCards 10/29-11/26/13 ATT*BILL PAYMENT 133.71 887.10 ATT*BILL PAYMENT PC 438 12/01/2013 PCards 10/29-11/26/13 ATT*BILL PAYMENT 157.86 1,044.96 ATT*BILL PAYMENT PC 461 12/19/2013 December A/P Building Maint 520.00 1,564.96 OVERHEAD DOOR FORT WORTH 33267 AP 594 12/26/2013 11/27-12/26/13 PCards SAMSCLUB #4795 427.95 1,992.91 SAMSCLUB #4795 PC 594 12/26/2013 11/27-12/26/13 PCards WAL-MART #5247 23.90 2,016.81 WAL-MART #5247 PC 594 12/26/2013 11/27-12/26/13 PCards WAL-MART #5247 29.91 2,046.72 WAL-MART #5247 PC 594 12/26/2013 11/27-12/26/13 PCards AT&T K025 10780 21.65 2,068.37 AT&T K025 10780 PC 594 12/26/2013 11/27-12/26/13 PCards ATT*BILL PAYMENT 133.71 2,202.08 ATT*BILL PAYMENT PC 594 12/26/2013 11/27-12/26/13 PCards ATT*BILL PAYMENT 157.86 2,359.94 ATT*BILL PAYMENT PC 594 12/26/2013 11/27-12/26/13 PCards WAL-MART #5247 39.92 2,399.86 WAL-MART #5247 PC 594 12/26/2013 11/27-12/26/13 PCards THE HOME DEPOT 6581 25.90 2,425.76 THE HOME DEPOT 6581 PC 594 12/26/2013 11/27-12/26/13 PCards THE HOME DEPOT 6581 12.96 2,438.72 THE HOME DEPOT 6581 PC 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (24.51) 2,414.21 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,698.80 2,414.21 ** 20,472.00 Budgeted 18,057.79 Remaining 12 % Used Account: 122-55090-045-000 Vehicle Maintenance 438 12/01/2013 PCards 10/29-11/26/13 ETRAILER 1,241.83 14.99 1,256.82 ETRAILER PC 438 12/01/2013 PCards 10/29-11/26/13 RESPONDER PUBLIC SAFET 48.63 1,305.45 RESPONDER PUBLIC SAFET PC 594 12/26/2013 11/27-12/26/13 PCards KWIK KAR LUBE & TUNE O 82.87 1,388.32 KWIK KAR LUBE & TUNE O PC 594 12/26/2013 11/27-12/26/13 PCards ETRAILER 49.94 1,438.26 ETRAILER PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 196.43 1,438.26 ** 14,850.00 Budgeted 13,411.74 Remaining 10 % Used Account: 122-55095-045-000 Equipment Maintenance 464 12/19/2013 December A/P Annual Maint of cascade system 692.83 692.83 AUGUST INDUSTRIES, INC 33230 AP _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: 692.83 692.83 ** .00 Budgeted (692.83) Remaining 0 % Used Account: 122-55100-045-000 Building Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 549 12/31/2013 Dec A/P Rug service-Dec 24.51 24.51 G & K SERVICES 33309 AP 549 12/31/2013 Dec A/P Rug service-Dec 24.51 49.02 G & K SERVICES 33309 AP _______________ Account: 122-55100-045-000 Building Maintenance Totals: 49.02 49.02 ** .00 Budgeted (49.02) Remaining 0 % Used Account: 122-60005-045-000 Telephone 3.34 .00 3.34 _______________ Account: 122-60005-045-000 Telephone Totals: .00 3.34 ** 100.00 Budgeted 96.66 Remaining 3 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 582 12/06/2013 FD Payroll 671.74 75.00 746.74 GL 464 12/19/2013 December A/P Acclaim and Verizon Wireless 137.47 884.21 TOWN OF TROPHY CLUB 33284 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 212.47 884.21 ** 4,237.00 Budgeted 3,352.79 Remaining 21 % Used Account: 122-60020-045-000 Electricity/Gas 464 12/19/2013 December A/P Electricity 657.92 821.99 1,479.91 HUDSON ENERGY SERVICES, LLC 33248 AP 516 12/31/2013 Dec A/P Gas/Fire Station 475.08 1,954.99 ATMOS ENERGY 33291 AP 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (410.99) 1,544.00 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 886.08 1,544.00 ** 6,568.00 Budgeted 5,024.00 Remaining 24 % Used Account: 122-60025-045-000 Water 461 12/19/2013 December A/P water/Nov 20.45 98.12 118.57 TROPHY CLUB MUD (WATER BILLS) 33286 AP 461 12/19/2013 December A/P Water bills/November 77.76 196.33 TROPHY CLUB MUD (WATER BILLS) 33286 AP 549 12/31/2013 Dec A/P December Water 236.52 432.85 TROPHY CLUB MUD (WATER BILLS) 33348 AP 549 12/31/2013 Dec A/P December Water 55.16 488.01 TROPHY CLUB MUD (WATER BILLS) 33348 AP 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (145.84) 342.17 AR _______________ Account: 122-60025-045-000 Water Totals: 321.72 342.17 ** 1,500.00 Budgeted 1,157.83 Remaining 23 % Used Account: 122-60030-045-000 Rent And/Or Usage . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 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-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 214,279.00 Budgeted 214,279.00 Remaining 0 % Used Account: 122-60035-045-000 Postage 549 12/31/2013 Dec A/P ground package to Etrailer 3.10 3.52 6.62 FEDERAL EXPRESS CORP 33307 AP 604 12/31/2013 December Postage meter 13.80 20.42 GL _______________ Account: 122-60035-045-000 Postage Totals: 17.32 20.42 ** 100.00 Budgeted 79.58 Remaining 20 % Used Account: 122-60055-045-000 Insurance 49 12/01/2013 Dec Ins & W/C Expense 2,018.50 1,009.25 3,027.75 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 3,027.75 ** 12,110.00 Budgeted 9,082.25 Remaining 25 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 594 12/26/2013 11/27-12/26/13 PCards NFPA NATL FIRE PROTECT 112.75 112.75 NFPA NATL FIRE PROTECT PC _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: 112.75 112.75 ** 400.00 Budgeted 287.25 Remaining 28 % Used Account: 122-60070-045-000 Dues & Memberships 438 12/01/2013 PCards 10/29-11/26/13 NFPA NATL FIRE PROTECT 1,577.76 165.00 1,742.76 NFPA NATL FIRE PROTECT PC 461 12/19/2013 December A/P Certification-Jacob Farrell 85.00 1,827.76 TX COMM ON FIRE PROTECTION 33287 AP 461 12/19/2013 December A/P Certification-Eric Sampson 85.00 1,912.76 TX COMM ON FIRE PROTECTION 33287 AP 461 12/19/2013 December A/P dues 305.00 2,217.76 STATE FIREMEN'S FIRE MARSHALS 33274 AP 461 12/19/2013 December A/P Dues & Membership 180.00 2,397.76 THE PRODUCTIVITY CENTER 33282 AP 549 12/31/2013 Dec A/P Training facility renewal 85.00 2,482.76 TX COMM ON FIRE PROTECTION 33349 AP 549 12/31/2013 Dec A/P Dues & Membership 100.00 2,582.76 TARRANT COUNTY FIRE CHIEFS 33345 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 1,005.00 2,582.76 ** 15,180.00 Budgeted 12,597.24 Remaining 17 % Used Account: 122-60080-045-000 Schools & Training 438 12/01/2013 PCards 10/29-11/26/13 TEXAS FIRE CHIEFS ASSO 1,064.00 275.00 1,339.00 TEXAS FIRE CHIEFS ASSO PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 461 12/19/2013 December A/P Reimbursement for state exam-E 1,064.00 85.00 1,424.00 Eric James Sampson 33238 AP 594 12/26/2013 11/27-12/26/13 PCards TRAININGDIVISION.COM 200.00 1,624.00 TRAININGDIVISION.COM PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 560.00 1,624.00 ** 4,280.00 Budgeted 2,656.00 Remaining 38 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 2,000.00 Budgeted 1,000.00 Remaining 50 % Used Account: 122-60100-045-000 Travel & per diem 594 12/26/2013 11/27-12/26/13 PCards MCALISTER'S DELI #520 1,064.82 56.78 1,121.60 MCALISTER'S DELI #520 PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 56.78 1,121.60 ** 4,577.00 Budgeted 3,455.40 Remaining 25 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 341.17 .00 341.17 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 341.17 ** 4,500.00 Budgeted 4,158.83 Remaining 8 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 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-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-60195-045-000 Flags & Repair 461 12/19/2013 December A/P Flag repair 75.00 75.00 SYMONDS FLAGS & POLES 33275 AP 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (37.50) 37.50 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 37.50 37.50 ** 2,000.00 Budgeted 1,962.50 Remaining 2 % Used Account: 122-60245-045-000 Miscellaneous Expense 438 12/01/2013 PCards 10/29-11/26/13 WAL-MART #5247 33.42 33.42 WAL-MART #5247 PC 438 12/01/2013 PCards 10/29-11/26/13 HOUSE OF PETALS 53.95 87.37 HOUSE OF PETALS PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 87.37 87.37 ** 1,000.00 Budgeted 912.63 Remaining 9 % Used Account: 122-65005-045-000 Fuel & Lube 609 12/31/2013 December Gas Log 1,429.50 664.64 2,094.14 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 664.64 2,094.14 ** 11,698.00 Budgeted 9,603.86 Remaining 18 % Used Account: 122-65010-045-000 Uniforms 89.83 .00 89.83 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 89.83 ** 3,360.00 Budgeted 3,270.17 Remaining 3 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 7,600.00 Budgeted 7,600.00 Remaining 0 % Used Account: 122-65030-045-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 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-65030-045-000 Chemicals Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 594 12/26/2013 11/27-12/26/13 PCards WILDFIRE TRUCK & EQUIP 76.46 76.46 WILDFIRE TRUCK & EQUIP PC _______________ Account: 122-65035-045-000 Small Tools Totals: 76.46 76.46 ** 2,500.00 Budgeted 2,423.54 Remaining 3 % Used Account: 122-65085-045-000 Office Supplies 438 12/01/2013 PCards 10/29-11/26/13 LYNN CARD COMPANY 27.49 56.95 84.44 LYNN CARD COMPANY PC _______________ Account: 122-65085-045-000 Office Supplies Totals: 56.95 84.44 ** 1,000.00 Budgeted 915.56 Remaining 8 % Used Account: 122-65095-045-000 Maintenance Supplies 438 12/01/2013 PCards 10/29-11/26/13 SAMSCLUB #4795 79.46 79.46 SAMSCLUB #4795 PC 594 12/26/2013 11/27-12/26/13 PCards SAMSCLUB #4795 31.70 111.16 SAMSCLUB #4795 PC _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 111.16 111.16 ** .00 Budgeted (111.16) Remaining 0 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt-Interest . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2013 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-69009-045-000 Short Term Debt-Interest Totals: .00 .00 ** 3,031.00 Budgeted 3,031.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 34,200.00 Budgeted 34,200.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 67,647.00 Budgeted 67,647.00 Remaining 0 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 20,400.00 Budgeted 20,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 191,719.46 ** 1,260,950.00 Budgeted 1,069,230.54 Remaining 15 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (514,010.66) .00 Budgeted 514,010.66 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET DECEMBER 31, 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 12/31/13 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 245,469 - - 245,469 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,501,105 - - 1,501,105 INVESTMENTS-TEXPOOL 914,471 313,050 330,608 1,558,129 PREPAID EXPENSES 62,328 - - 62,328 ADVALOREM PROPERTY TAXES RECEIVABLE 50,858 - - 50,858 UTILITY AND OTHER ACCOUNTS RECEIVABLE 811,122 - - 811,122 - TOTAL ASSETS 3,585,954 313,050 330,608 4,229,611 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 50,858 - - 50,858 ACCOUNTS AND OTHER PAYABLES 384,257 - 161,531 545,788 CUSTOMER DEPOSITS 241,187 - - 241,187 - TOTAL LIABILITIES 676,302 - 161,531 837,833 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 313,050 313,050 NON-SPENDABLE FUND BALANCE 29,524 29,524 ASSIGNED FUND BALANCE 276,500 245,101 521,601 UNASSIGNED FUND BALANCE 2,682,452 - - 2,682,452 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (78,824) - (76,024) (154,848) - TOTAL FUND BALANCE 2,909,652 313,050 169,077 3,391,779 - TOTAL LIABILITIES AND FUND BALANCE 3,585,954 313,050 330,608 4,229,611 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,250.00- 99,250.00- 45,223.21- 50,507.60- 50.889 48,742.40- 135-40002-000-000 Property Taxes/Delinquent 5.10- 4.87 4.87- 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 17.06- 13.85 -1.539 913.85- Subtotal: 100,150.00- 100,150.00- 45,245.37- 50,488.88- 50.413 49,661.12- 135-43215-000-000 Insurance Settlement 82.36- 82.36- 82.36 Subtotal: 82.36- 82.36- 82.36 135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 153,881.51- 593,603.76- 15.832 3,155,706.24- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 130,988.75- 418,853.21- 24.518 1,289,467.79- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 27.92 12,636.93- 19.585 51,885.07- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 728.00- 2,384.00- 26.270 6,691.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 50.00- 500.00- 41.667 700.00- 135-47045-000-000 Sewer Inspections 4,400.00- 4,400.00- 150.00- 1,650.00- 37.500 2,750.00- 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 101.04- 7,896.24- 9.922 71,689.76- Subtotal: 5,616,414.00- 5,616,414.00- 285,871.38- 1,037,524.14- 18.473 4,578,889.86- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 43,700.00- 108,100.00- 18.570 474,009.00- Subtotal: 582,109.00- 582,109.00- 43,700.00- 108,100.00- 18.570 474,009.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 560.15- 1,548.46- 32.260 3,251.54- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 2,731.59- 26.875 7,432.41- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,749.99- 25.000 5,250.01- 135-49030-000-000 Vending Revenue 350.00- 350.00- 41.00- 11.714 309.00- 135-49036-000-000 GASB Reserves 8,964.00- 8,964.00- 8,964.00- 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 6,730.57- 21,298.77- 25.356 62,701.23- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- 51.60- 51.61- 1.720 2,948.39- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 100.00- 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 119,264.00- 8,836.18- 27,421.42- 22.992 91,842.58- Program number: 6,417,937.00- 6,417,937.00- 383,735.29- 1,223,616.80- 19.066 5,194,320.20- Department number: Revenues 6,417,937.00- 6,417,937.00- 383,735.29- 1,223,616.80- 19.066 5,194,320.20- Revenues Subtotal ----------- 6,417,937.00- 6,417,937.00- 383,735.29- 1,223,616.80- 19.066 5,194,320.20- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 287,709.00 287,709.00 21,764.03 52,797.71 18.351 234,911.29 135-50010-010-000 Overtime 13,391.00 13,391.00 1,004.29 3,038.16 22.688 10,352.84 135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 325.00 975.00 19.118 4,125.00 135-50020-010-000 Retirement 27,847.00 27,847.00 2,073.79 5,986.05 21.496 21,860.95 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 3,439.98 8,460.63 17.505 39,873.37 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 252.58 680.49 17.306 3,251.51 135-50028-010-000 Vision Insurance 873.00 873.00 58.94 154.87 17.740 718.13 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 454.28 749.49 22.671 2,556.51 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,515.44 4,191.44 21.730 15,097.56 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 354.43 980.26 21.730 3,530.74 135-50040-010-000 Unemployment Taxes 54.00 54.00 2.44 2.44 4.519 51.56 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 2,407.35 24.492 7,421.65 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 61.45 233.90 116.950 33.90- 135-50070-010-000 Employee Relations 300.00 300.00 67.79 76.78 25.593 223.22 Subtotal: 429,580.00 429,580.00 32,176.89 85,639.57 19.936 343,940.43 135-55005-010-000 Engineering 3,000.00 3,000.00 3,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 2,713.00 9,749.11 19.498 40,250.89 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 171.18 1,055.33 21.107 3,944.67 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 198.33 198.33 5.667 3,301.67 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 200.00 445.00 8.091 5,055.00 Subtotal: 67,000.00 67,000.00 3,282.51 11,447.77 17.086 55,552.23 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 482.52 1,147.80 23.363 3,765.20 135-60020-010-000 Electricity 162,160.00 162,160.00 9,418.79 27,153.90 16.745 135,006.10 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 289.00 289.00 192.667 139.00- 135-60080-010-000 Schools & Training 4,184.00 4,184.00 589.00 589.00 14.077 3,595.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,450.00 1,450.00 100.57 100.57 6.936 1,349.43 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 12.00 2.400 488.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 6,480.10 6,480.10 13.671 40,919.90 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 283,923.18 283,923.18 12.141 2,054,549.82 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 80.10 360.70 10.306 3,139.30 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 3,500.00 3,500.00 Subtotal: 2,567,580.00 2,567,580.00 301,369.26 320,056.25 12.465 2,247,523.75 135-65005-010-000 Fuel & Lube 23,181.00 23,181.00 955.43 2,739.27 11.817 20,441.73 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,270.00 3,270.00 1,741.64 1,831.63 56.013 1,438.37 135-65030-010-000 Chemicals 5,000.00 5,000.00 1,017.33 2,045.09 40.902 2,954.91 135-65035-010-000 Small Tools 1,200.00 1,200.00 464.94 38.745 735.06 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 16.92 16.92 1.692 983.08 135-65050-010-000 Meter Expense 143,550.00 143,550.00 956.82 55,697.12 38.800 87,852.88 Subtotal: 177,201.00 177,201.00 4,688.14 62,794.97 35.437 114,406.03 135-69005-010-000 Capital Expenses 37,000.00 37,000.00 37,000.00 135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 489,980.00 135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 19,268.00 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 7,500.00 7,500.00 7,500.00 135-69281-010-000 Capital Repair-Ground Storage 106,847.00 106,847.00 69,788.02 65.316 37,058.98 Subtotal: 690,595.00 690,595.00 69,788.02 10.105 620,806.98 Program number: 3,931,956.00 3,931,956.00 341,516.80 549,726.58 13.981 3,382,229.42 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis 1,000.00 1,000.00 60.00 120.00 12.000 880.00 Subtotal: 1,000.00 1,000.00 60.00 120.00 12.000 880.00 135-60135-010-001 TCEQ Fees & Permits 2,150.00- 2,253.85 2,253.85- Subtotal: 2,150.00- 2,253.85 2,253.85- Program number: 1 Lab Analysis for PID 1,000.00 1,000.00 2,090.00- 2,373.85 237.385 1,373.85- Department number: Water 3,932,956.00 3,932,956.00 339,426.80 552,100.43 14.038 3,380,855.57 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 202,894.00 202,894.00 15,409.25 40,796.88 20.107 162,097.12 135-50010-020-000 Overtime 11,965.00 11,965.00 1,636.91 3,742.03 31.275 8,222.97 135-50016-020-000 Longevity 2,998.00 2,998.00 2,997.50 99.983 .50 135-50017-020-000 Certification 4,800.00 4,800.00 400.00 1,200.00 25.000 3,600.00 135-50020-020-000 Retirement 19,905.00 19,905.00 1,566.65 4,844.88 24.340 15,060.12 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,241.09 9,827.55 22.607 33,643.45 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 226.46 679.38 22.729 2,309.62 135-50028-020-000 Vision Insurance 658.00 658.00 49.93 149.79 22.764 508.21 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 328.35 648.90 28.176 1,654.10 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 1,058.54 3,050.89 22.100 10,754.11 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 247.56 713.51 22.097 2,515.49 135-50040-020-000 Unemployment Taxes 36.00 36.00 36.00 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 1,605.24 24.500 4,946.76 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 63.00 42.000 87.00 135-50070-020-000 Employee Relations 350.00 350.00 20.00 28.99 8.283 321.01 Subtotal: 316,105.00 316,105.00 24,719.82 70,348.54 22.255 245,756.46 135-55070-020-000 Independent Labor 152,050.00 245,806.25 245,806.25- 135-55080-020-000 Maintenance & Repairs 35,000.00 35,000.00 3,759.98 4,010.64 11.459 30,989.36 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 539.53 681.51 34.076 1,318.49 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 52,000.00 52,000.00 7,354.32 7,354.32 14.143 44,645.68 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,662.00 5,600.00 18.667 24,400.00 Subtotal: 119,500.00 119,500.00 166,365.83 263,452.72 220.463 143,952.72- 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 546.31 716.08 21.510 2,612.92 135-60020-020-000 Electricity 148,227.00 148,227.00 9,822.72 22,615.71 15.257 125,611.29 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 120.00 160.00 40.000 240.00 135-60080-020-000 Schools & Training 2,636.00 2,636.00 2,636.00 135-60090-020-000 Safety Program 250.00 250.00 332.83 371.38 148.552 121.38- 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 133.62 219.05 20.862 830.95 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00- 8,919.00 52.006 8,231.00 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60360-020-000 Furniture/Equipment < $5000 3,000.00 3,000.00 3,000.00 Subtotal: 178,242.00 178,242.00 2,036.48 33,300.75 18.683 144,941.25 135-65005-020-000 Fuel & Lube 14,720.00 14,720.00 748.70 2,483.69 16.873 12,236.31 135-65010-020-000 Uniforms 1,752.00 1,752.00 1,284.28 73.304 467.72 135-65030-020-000 Chemicals 39,000.00 39,000.00 1,680.00 4,629.64 11.871 34,370.36 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-020-000 Small Tools 1,000.00 1,000.00 43.66 91.00 9.100 909.00 135-65040-020-000 Safety Equipment 250.00 250.00 56.43 22.572 193.57 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 479.30 4,763.73 31.758 10,236.27 Subtotal: 71,722.00 71,722.00 2,951.66 13,308.77 18.556 58,413.23 135-69005-020-000 Capital Expenses 31,000.00 31,000.00 31,000.00 135-69008-020-000 Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 1,422.00 135-69280-020-000 Capital Repairs 30,000.00 30,000.00 30,000.00 Subtotal: 82,442.00 82,442.00 82,442.00 Program number: 768,011.00 768,011.00 196,073.79 380,410.78 49.532 387,600.22 Department number: Wastewater 768,011.00 768,011.00 196,073.79 380,410.78 49.532 387,600.22 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 90,299.00 90,299.00 4,346.15 15,664.64 17.348 74,634.36 135-50010-021-000 Overtime 10,028.00 10,028.00 106.76 1,395.32 13.914 8,632.68 135-50016-021-000 Longevity 17,913.00 17,913.00 2,107.50 11.765 15,805.50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 450.00 25.000 1,350.00 135-50020-021-000 Retirement 9,025.00 9,025.00 413.34 2,116.65 23.453 6,908.35 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,402.39 5,252.76 22.194 18,415.24 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 128.98 402.39 23.628 1,300.61 135-50028-021-000 Vision Insurance 314.00 314.00 23.82 75.85 24.156 238.15 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 149.97 391.16 36.694 674.84 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 286.23 1,326.92 17.830 6,115.08 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 66.95 310.33 17.825 1,430.67 135-50040-021-000 Unemployment Taxes 198.00 198.00 198.00 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 802.62 24.500 2,473.38 135-50070-021-000 Employee Relations 200.00 200.00 21.69 30.68 15.340 169.32 Subtotal: 168,673.00 168,673.00 7,363.82 30,326.82 17.980 138,346.18 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-021-000 Maintenance & Repairs 23,801.00 23,801.00 65.31 93.28 .392 23,707.72 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 2,000.00 Subtotal: 27,301.00 27,301.00 65.31 93.28 .342 27,207.72 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 102.52 205.04 15.382 1,127.96 135-60020-021-000 Electricity 21,178.00 21,178.00 2,092.10 4,001.65 18.895 17,176.35 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 135-60080-021-000 Schools & Training 1,711.00 1,711.00 1,711.00 135-60090-021-000 Safety Program 300.00 300.00 300.00 135-60100-021-000 Travel & per diem 550.00 550.00 550.00 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 35,422.00 2,194.62 4,206.69 11.876 31,215.31 135-65005-021-000 Fuel & Lube 22,397.00 22,397.00 853.85 2,872.40 12.825 19,524.60 135-65010-021-000 Uniforms 1,040.00 1,040.00 238.09 814.23 78.291 225.77 135-65030-021-000 Chemicals 6,000.00 6,000.00 6,000.00 135-65035-021-000 Small Tools 1,000.00 1,000.00 43.99 4.399 956.01 135-65040-021-000 Safety Equipment 500.00 500.00 540.75 108.150 40.75- Subtotal: 30,937.00 30,937.00 1,091.94 4,271.37 13.807 26,665.63 135-69005-021-000 Capital Expenses 100,000.00 100,000.00 100,000.00 135-69008-021-000 Short Term Debt-Principal 35,991.00 35,991.00 35,991.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69009-021-000 Short Term Debt-Interest 2,846.00 2,846.00 2,846.00 135-69280-021-000 Capital Repairs 71,000.00 71,000.00 71,000.00 Subtotal: 209,837.00 209,837.00 209,837.00 Program number: 472,170.00 472,170.00 10,715.69 38,898.16 8.238 433,271.84 Department number: Collection 472,170.00 472,170.00 10,715.69 38,898.16 8.238 433,271.84 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 500.00 2,500.00 25.000 7,500.00 135-50030-026-000 Social Security Taxes 620.00 620.00 31.00 155.00 25.000 465.00 135-50035-026-000 Medicare Taxes 145.00 145.00 7.25 36.25 25.000 108.75 135-50040-026-000 Unemployment Taxes 10.00 10.00 .50 2.50 25.000 7.50 135-50045-026-000 Workman's Compensation 36.00 36.00 2.95 8.85 24.583 27.15 Subtotal: 10,811.00 10,811.00 541.70 2,702.60 24.999 8,108.40 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 1,200.00 30.95 35.95 2.996 1,164.05 135-60080-026-000 Schools & Training 4,000.00 4,000.00 265.00 6.625 3,735.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 Subtotal: 11,850.00 11,850.00 65.95 335.95 2.835 11,514.05 Program number: 22,661.00 22,661.00 607.65 3,038.55 13.409 19,622.45 Department number: Board of Directors 22,661.00 22,661.00 607.65 3,038.55 13.409 19,622.45 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 458,721.00 458,721.00 34,654.65 92,450.91 20.154 366,270.09 135-50010-030-000 Overtime 500.00 500.00 20.29 259.87 51.974 240.13 135-50016-030-000 Longevity 3,018.00 3,018.00 3,077.50 101.972 59.50- 135-50020-030-000 Retirement 41,419.00 41,419.00 3,113.83 9,574.52 23.116 31,844.48 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,602.53 13,331.23 23.015 44,591.77 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 386.34 1,159.02 22.726 3,940.98 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 82.53 247.59 22.777 839.41 135-50029-030-000 Life Insurance & Other 4,483.00 4,483.00 1,164.09 1,800.88 40.171 2,682.12 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 2,109.21 6,269.15 21.875 22,389.85 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 493.28 1,466.18 21.877 5,235.82 135-50040-030-000 Unemployment Taxes 63.00 63.00 63.00 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.63 385.89 24.501 1,189.11 135-50060-030-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 2,123.11 2,810.96 56.219 2,189.04 Subtotal: 614,450.00 614,450.00 48,878.49 132,833.70 21.618 481,616.30 135-55030-030-000 Software & Support 59,698.00 59,698.00 9,113.53 15,446.13 25.874 44,251.87 135-55070-030-000 Independent Labor 7,700.00 7,700.00 252.50 2,115.45 27.473 5,584.55 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 236.05- 1,577.26- -35.050 6,077.26 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 1,254.84 1,516.18 23.326 4,983.82 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 1,594.97 3,189.94 16.666 15,950.06 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 15,000.00 135-55161-030-000 Outside Services-Town Semo 77,048.00 77,048.00 38,524.00 50.000 38,524.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 6,808.00 6,808.00 582.20 1,152.20 16.924 5,655.80 Subtotal: 196,594.00 196,594.00 12,561.99 60,366.64 30.706 136,227.36 135-60005-030-000 Telephone 11,250.00 11,250.00 1,086.33 2,496.39 22.190 8,753.61 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 3,589.00 327.27 729.79 20.334 2,859.21 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 887.96 887.96 5.853 14,283.04 135-60025-030-000 Water 1,500.00 1,500.00 156.33 202.43 13.495 1,297.57 135-60035-030-000 Postage 28,500.00 28,500.00 2,197.66 5,230.78 18.354 23,269.22 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 3,127.57 6,795.64 23.987 21,534.36 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 3,712.56 3,712.56 247.504 2,212.56- 135-60055-030-000 Insurance 53,561.00 53,561.00 4,269.73 12,842.44 23.977 40,718.56 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 126.00 126.00 12.600 874.00 135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 2,991.95 3,931.95 87.377 568.05 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60080-030-000 Schools & Training 7,500.00 7,500.00 190.00 190.00 2.533 7,310.00 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 532.88 601.36 12.027 4,398.64 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 2,500.00 2,500.00 2,500.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 1,350.00 1,350.00 123.56 123.56 9.153 1,226.44 135-60245-030-000 Miscellaneous Expenses 22,870.00 22,870.00 41.68 61.38 .268 22,808.62 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 204,221.00 204,221.00 19,771.48 37,932.24 18.574 166,288.76 135-65010-030-000 Uniforms 1,390.00 1,390.00 477.90 998.90 71.863 391.10 135-65055-030-000 Hardware 13,562.00 13,562.00 336.59 1,672.45 12.332 11,889.55 135-65085-030-000 Office Supplies 9,100.00 9,100.00 449.17 1,200.49 13.192 7,899.51 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 412.62 904.12 15.773 4,827.88 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 662.39 756.79 30.272 1,743.21 135-65097-030-000 Vending Machine Supplies 200.00 200.00 27.06 13.530 172.94 135-65105-030-000 Printing 4,000.00 4,000.00 1,401.00 35.025 2,599.00 Subtotal: 36,484.00 36,484.00 2,338.67 6,960.81 19.079 29,523.19 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 7.445 3,193.15 Subtotal: 3,450.00 3,450.00 256.85 7.445 3,193.15 Program number: 1,055,199.00 1,055,199.00 83,550.63 238,350.24 22.588 816,848.76 Department number: Administration 1,055,199.00 1,055,199.00 83,550.63 238,350.24 22.588 816,848.76 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 14:27 01/13/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 131,300.00 131,300.00 42,951.71 69,413.16 52.866 61,886.84 135-55055-039-000 Auditing 21,840.00 21,840.00 15,900.00 15,900.00 72.802 5,940.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 984.68 4,329.38 43.294 5,670.62 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 166,940.00 166,940.00 59,836.39 89,642.54 53.697 77,297.46 Program number: 166,940.00 166,940.00 59,836.39 89,642.54 53.697 77,297.46 Department number: Non Departmental 166,940.00 166,940.00 59,836.39 89,642.54 53.697 77,297.46 Expenditures Subtotal ----------- 6,417,937.00 6,417,937.00 690,210.95 1,302,440.70 20.294 5,115,496.30 Fund number: 135 MUD 1 General Fund 306,475.66 78,823.90 78,823.90- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 14:27 01/13/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 10.42- 36.50- 36.50 Subtotal: 10.42- 36.50- 36.50 Program number: 10.42- 36.50- 36.50 Department number: 10.42- 36.50- 36.50 Revenues Subtotal ----------- 10.42- 36.50- 36.50 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 14:27 01/13/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs/ROFC FW Meter 22,780.19 76,060.18 76,060.18- Subtotal: 22,780.19 76,060.18 76,060.18- Program number: 2 Rate of Flow Control-FW Meter 22,780.19 76,060.18 76,060.18- Department number: Water 22,780.19 76,060.18 76,060.18- Expenditures Subtotal ----------- 22,780.19 76,060.18 76,060.18- Fund number: 507 MUD 1 Capital Projects 22,769.77 76,023.68 76,023.68- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2013 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 538 12/02/2013 Property Taxes & Assessments (5,284.39) (564.91) (5,849.30) GL 545 12/03/2013 Property Taxes & Assessments (537.21) (6,386.51) GL 546 12/04/2013 Property Taxes & Assessments (331.49) (6,718.00) GL 547 12/05/2013 Property Taxes & Assessments (180.24) (6,898.24) GL 548 12/10/2013 Property Taxes & Assessments (397.20) (7,295.44) GL 556 12/11/2013 Property Taxes & Assessments (699.38) (7,994.82) GL 557 12/12/2013 Property Taxes & Assessments (3,545.14) (11,539.96) GL 558 12/13/2013 Property Taxes & Assessments (377.94) (11,917.90) GL 559 12/16/2013 Property Taxes & Assessments (662.89) (12,580.79) GL 560 12/17/2013 Property Taxes & Assessments (927.42) (13,508.21) GL 561 12/18/2013 Property Taxes & Assessments (813.72) (14,321.93) GL 562 12/19/2013 Property Taxes & Assessments (739.72) (15,061.65) GL 563 12/20/2013 Property Taxes & Assessments (681.85) (15,743.50) GL 564 12/23/2013 Property Taxes & Assessments (633.35) (16,376.85) GL 565 12/26/2013 Property Taxes & Assessments (1,641.44) (18,018.29) GL 566 12/27/2013 Property Taxes & Assessments (25,990.77) (44,009.06) GL 567 12/30/2013 Property Taxes & Assessments (807.40) (44,816.46) GL 568 12/31/2013 Property Taxes & Assessments (5,691.14) (50,507.60) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (45,223.21) (50,507.60) ** (99,250.00) Budgeted (48,742.40) Remaining 51 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 538 12/02/2013 Property Taxes & Assessments 9.97 (.04) 9.93 GL 556 12/11/2013 Property Taxes & Assessments 2.47 12.40 GL 567 12/30/2013 Property Taxes & Assessments (7.53) 4.87 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (5.10) 4.87 ** .00 Budgeted (4.87) Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 538 12/02/2013 Property Taxes & Assessments 30.91 (.01) 30.90 GL 557 12/12/2013 Property Taxes & Assessments (6.87) 24.03 GL 565 12/26/2013 Property Taxes & Assessments (.66) 23.37 GL 566 12/27/2013 Property Taxes & Assessments (9.25) 14.12 GL 567 12/30/2013 Property Taxes & Assessments (.27) 13.85 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (17.06) 13.85 ** (900.00) Budgeted (913.85) Remaining -2 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-43215-000-000 Insurance Settlement 574 12/19/2013 Amica Ins/Hydrant damage claim (82.36) (82.36) GL _______________ Account: 135-43215-000-000 Insurance Settlement Totals: (82.36) (82.36) ** .00 Budgeted 82.36 Remaining 0 % Used Account: 135-47000-000-000 Water 521 12/31/2013 UB 12/31/2013 Billing UB20131231-20131231 User: (439,722.25) (153,881.51) (593,603.76) UB _______________ Account: 135-47000-000-000 Water Totals: (153,881.51) (593,603.76) ** (3,749,310.00) Budgeted (3,155,706.24) Remaining 16 % Used Account: 135-47005-000-000 Sewer 521 12/31/2013 UB 12/31/2013 Billing UB20131231-20131231 User: (287,864.46) (130,988.75) (418,853.21) UB _______________ Account: 135-47005-000-000 Sewer Totals: (130,988.75) (418,853.21) ** (1,708,321.00) Budgeted (1,289,467.79) Remaining 25 % Used Account: 135-47025-000-000 Penalties 501 12/04/2013 UB 12/04/2013 Adjustment UB20131204-20131204 User: (12,664.85) 11.89 (12,652.96) UB 474 12/23/2013 UB 12/23/2013 Adjustments UB20131223-20131223 User: 16.03 (12,636.93) UB _______________ Account: 135-47025-000-000 Penalties Totals: 27.92 (12,636.93) ** (64,522.00) Budgeted (51,885.07) Remaining 20 % Used Account: 135-47030-000-000 Service Charges 449 12/01/2013 UB 12/01/13 NSF Check Fee UB20131201-20131201 User: (1,656.00) (125.00) (1,781.00) UB 440 12/17/2013 UB 12/17/13 CUt Off List UB20131217-20131217 User: (475.00) (2,256.00) UB 495 12/20/2013 UB 12/20/13 NSF Check Fee UB20131220-20131220 User: (25.00) (2,281.00) UB 507 12/20/2013 UB 12/20/13 NSF Check Fee UB20131220-20131220 User: (50.00) (2,331.00) UB 510 12/23/2013 UB 12/23/13 NSF Check Fee UB20131223-20131223 User: (50.00) (2,381.00) UB 521 12/31/2013 UB 12/31/2013 Billing UB20131231-20131231 User: (3.00) (2,384.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (728.00) (2,384.00) ** (9,075.00) Budgeted (6,691.00) Remaining 26 % Used Account: 135-47035-000-000 Plumbing Inspections 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (450.00) (50.00) (500.00) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2013 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: (50.00) (500.00) ** (1,200.00) Budgeted (700.00) Remaining 42 % Used Account: 135-47045-000-000 Sewer Inspections 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (1,500.00) (150.00) (1,650.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (1,650.00) ** (4,400.00) Budgeted (2,750.00) Remaining 38 % Used Account: 135-47070-000-000 TCCC Effluent Charges 514 12/30/2013 UB 12/30/13 Adjustment UB20131230-20131230 User: (7,795.20) 36.16 (7,759.04) UB 521 12/31/2013 UB 12/31/2013 Billing UB20131231-20131231 User: (137.20) (7,896.24) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (101.04) (7,896.24) ** (79,586.00) Budgeted (71,689.76) Remaining 10 % Used Account: 135-48005-000-000 Utility Fees 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (64,400.00) (43,700.00) (108,100.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (43,700.00) (108,100.00) ** (582,109.00) Budgeted (474,009.00) Remaining 19 % Used Account: 135-49010-000-000 Interest Income 578 12/31/2013 Bank Statement Interest/Dec (988.31) (81.40) (1,069.71) GL 578 12/31/2013 Bank Statement Interest/Dec (421.01) (1,490.72) GL 578 12/31/2013 Bank Statement Interest/Dec (57.74) (1,548.46) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (560.15) (1,548.46) ** (4,800.00) Budgeted (3,251.54) Remaining 32 % Used Account: 135-49016-000-000 Cell Tower Revenue 571 12/05/2013 AT&T Antenna Lease (1,821.06) (910.53) (2,731.59) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (2,731.59) ** (10,164.00) Budgeted (7,432.41) Remaining 27 % Used Account: 135-49018-000-000 Building Rent Income . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (1,166.66) (583.33) (1,749.99) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,749.99) ** (7,000.00) Budgeted (5,250.01) Remaining 25 % Used Account: 135-49030-000-000 Vending Revenue (41.00) .00 (41.00) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (41.00) ** (350.00) Budgeted (309.00) Remaining 12 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (8,964.00) Budgeted (8,964.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (14,568.20) (6,730.57) (21,298.77) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (6,730.57) (21,298.77) ** (84,000.00) Budgeted (62,701.23) Remaining 25 % Used Account: 135-49900-000-000 Miscellaneous Income 572 12/05/2013 Wm Scotsman/refund container (.01) (51.60) (51.61) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (51.60) (51.61) ** (3,000.00) Budgeted (2,948.39) Remaining 2 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (100.00) Budgeted (100.00) Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (886.00) Budgeted (886.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,223,616.80) ** (6,417,937.00) Budgeted (5,194,320.20) Remaining 19 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 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 361 12/06/2013 Payroll 12/6/13 Salaries & Wages 31,033.68 10,730.14 41,763.82 PR 451 12/19/2013 Service Awards Salaries & Wages 175.75 41,939.57 PR 448 12/20/2013 12/20/13 Payroll Salaries & Wages 10,858.14 52,797.71 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 21,764.03 52,797.71 ** 287,709.00 Budgeted 234,911.29 Remaining 18 % Used Account: 135-50010-010-000 Overtime 361 12/06/2013 Payroll 12/6/13 Overtime 2,033.87 515.67 2,549.54 PR 448 12/20/2013 12/20/13 Payroll Overtime 488.62 3,038.16 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,004.29 3,038.16 ** 13,391.00 Budgeted 10,352.84 Remaining 23 % Used Account: 135-50016-010-000 Longevity 4,905.00 .00 4,905.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 4,905.00 ** 4,905.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 448 12/20/2013 12/20/13 Payroll Certification 650.00 325.00 975.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 325.00 975.00 ** 5,100.00 Budgeted 4,125.00 Remaining 19 % Used Account: 135-50020-010-000 Retirement 361 12/06/2013 Payroll 12/6/13 Retirement 3,912.26 1,009.88 4,922.14 PR 451 12/19/2013 Service Awards Retirement 15.78 4,937.92 PR 448 12/20/2013 12/20/13 Payroll Retirement 1,048.13 5,986.05 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,073.79 5,986.05 ** 27,847.00 Budgeted 21,860.95 Remaining 21 % Used Account: 135-50026-010-000 Medical Insurance 361 12/06/2013 Payroll 12/6/13 Medical Insurance 5,020.65 1,720.02 6,740.67 PR 448 12/20/2013 12/20/13 Payroll Medical Insurance 1,719.96 8,460.63 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,439.98 8,460.63 ** 48,334.00 Budgeted 39,873.37 Remaining 18 % Used Account: 135-50027-010-000 Dental Insurance 361 12/06/2013 Payroll 12/6/13 Dental Insurance 427.91 126.30 554.21 PR 448 12/20/2013 12/20/13 Payroll Dental Insurance 126.28 680.49 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 252.58 680.49 ** 3,932.00 Budgeted 3,251.51 Remaining 17 % Used Account: 135-50028-010-000 Vision Insurance 361 12/06/2013 Payroll 12/6/13 Vision Insurance 95.93 29.48 125.41 PR 448 12/20/2013 12/20/13 Payroll Vision Insurance 29.46 154.87 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 58.94 154.87 ** 873.00 Budgeted 718.13 Remaining 18 % Used Account: 135-50029-010-000 Life Insurance & Other 351 12/02/2013 Dec A/P Dec Life, ADD, LTD, Dental, Vo 295.21 193.18 488.39 METLIFE 33221 AP 549 12/31/2013 Dec A/P Dental, V life, STD-other life 245.35 733.74 METLIFE 33335 AP 551 12/31/2013 Dec A/P FSA Monthly Adm, Non Discrimin 15.75 749.49 Discovery Benefits 33304 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 454.28 749.49 ** 3,306.00 Budgeted 2,556.51 Remaining 23 % Used Account: 135-50030-010-000 Social Security Taxes 361 12/06/2013 Payroll 12/6/13 Social Security Taxes 2,676.00 692.27 3,368.27 PR 451 12/19/2013 Service Awards Social Security Taxes 10.90 3,379.17 PR 448 12/20/2013 12/20/13 Payroll Social Security Taxes 812.27 4,191.44 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,515.44 4,191.44 ** 19,289.00 Budgeted 15,097.56 Remaining 22 % Used Account: 135-50035-010-000 Medicare Taxes 361 12/06/2013 Payroll 12/6/13 Medicare Taxes 625.83 161.91 787.74 PR 451 12/19/2013 Service Awards Medicare Taxes 2.55 790.29 PR 448 12/20/2013 12/20/13 Payroll Medicare Taxes 189.97 980.26 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 354.43 980.26 ** 4,511.00 Budgeted 3,530.74 Remaining 22 % Used Account: 135-50040-010-000 Unemployment Taxes 361 12/06/2013 Payroll 12/6/13 Unemployment Taxes 1.15 1.15 PR 448 12/20/2013 12/20/13 Payroll Unemployment Taxes 1.29 2.44 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 2.44 2.44 ** 54.00 Budgeted 51.56 Remaining 5 % Used Account: 135-50045-010-000 Workman's Compensation 49 12/01/2013 Dec Ins & W/C Expense 1,604.90 802.45 2,407.35 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 2,407.35 ** 9,829.00 Budgeted 7,421.65 Remaining 24 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 461 12/19/2013 December A/P Pre employment physical 172.45 61.45 233.90 FIRST CHECK APPLICANT SCREENIN 33240 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 61.45 233.90 ** 200.00 Budgeted (33.90) Remaining 117 % Used Account: 135-50070-010-000 Employee Relations 438 12/01/2013 PCards 10/29-11/26/13 DONUT PARADISE 8.99 41.00 49.99 DONUT PARADISE PC 438 12/01/2013 PCards 10/29-11/26/13 ALBERTSONS #4149 6.79 56.78 ALBERTSONS #4149 PC 594 12/26/2013 11/27-12/26/13 PCards FUZZY'S TACO SHOP 20.00 76.78 FUZZY'S TACO SHOP PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 67.79 76.78 ** 300.00 Budgeted 223.22 Remaining 26 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 438 12/01/2013 PCards 10/29-11/26/13 ROANOKE AUTO SUPPLY LT 7,036.11 1.89 7,038.00 ROANOKE AUTO SUPPLY LT PC 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 60.75 7,098.75 THE HOME DEPOT 6581 PC 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 27.12 7,125.87 THE HOME DEPOT 6581 PC 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 100.71 7,226.58 THE HOME DEPOT 6581 PC 594 12/26/2013 11/27-12/26/13 PCards THE HOME DEPOT 6581 18.59 7,245.17 THE HOME DEPOT 6581 PC 549 12/31/2013 Dec A/P Gas chlorinator kit 2,439.56 9,684.73 SCOOP 33343 AP 549 12/31/2013 Dec A/P 2" ball valve 64.38 9,749.11 HD SUPPLY WATERWORKS, LTD. 33313 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,713.00 9,749.11 ** 50,000.00 Budgeted 40,250.89 Remaining 19 % Used Account: 135-55090-010-000 Vehicle Maintenance 438 12/01/2013 PCards 10/29-11/26/13 BLAGG TIRE SERVICE 884.15 16.50 900.65 BLAGG TIRE SERVICE PC 461 12/19/2013 December A/P 1.70 902.35 ROANOKE AUTO SUPPLY 33270 AP 461 12/19/2013 December A/P vehicle maint 6.75 909.10 ROANOKE AUTO SUPPLY 33270 AP 461 12/19/2013 December A/P Vehicle maint 97.99 1,007.09 ROANOKE AUTO SUPPLY 33270 AP 461 12/19/2013 December A/P vehicle maint 8.49 1,015.58 ROANOKE AUTO SUPPLY 33270 AP 594 12/26/2013 11/27-12/26/13 PCards KWIK KAR LUBE & TUNE O 39.75 1,055.33 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 171.18 1,055.33 ** 5,000.00 Budgeted 3,944.67 Remaining 21 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 594 12/26/2013 11/27-12/26/13 PCards BLAGG TIRE SERVICE 198.33 198.33 BLAGG TIRE SERVICE PC _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 198.33 198.33 ** 3,500.00 Budgeted 3,301.67 Remaining 6 % Used Account: 135-55135-010-000 Lab Analysis 461 12/19/2013 December A/P Bact T Samples 245.00 200.00 445.00 TARRANT CTY PUBLIC HEALTH LAB 33276 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 200.00 445.00 ** 5,500.00 Budgeted 5,055.00 Remaining 8 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 464 12/19/2013 December A/P Acclaim and Verizon Wireless 665.28 482.52 1,147.80 TOWN OF TROPHY CLUB 33284 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 482.52 1,147.80 ** 4,913.00 Budgeted 3,765.20 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 465 12/19/2013 Dec A/P Electricity 11/11-12/12/13 17,735.11 7,839.02 25,574.13 HUDSON ENERGY SERVICES, LLC 33248 AP 465 12/19/2013 Dec A/P Electricity 11/11-12/12/13 1,493.59 27,067.72 HUDSON ENERGY SERVICES, LLC 33248 AP 553 12/31/2013 Dec A/P Electricity 11/8-12/11/13 86.18 27,153.90 HUDSON ENERGY SERVICES, LLC 33353 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,418.79 27,153.90 ** 162,160.00 Budgeted 135,006.10 Remaining 17 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships 461 12/19/2013 December A/P Membership dues 289.00 289.00 Texas Rural Water Assoc 33278 AP _______________ Account: 135-60070-010-000 Dues & Memberships Totals: 289.00 289.00 ** 150.00 Budgeted (139.00) Remaining 193 % Used Account: 135-60080-010-000 Schools & Training 438 12/01/2013 PCards 10/29-11/26/13 TX BRD PLUMBING EX 55.00 55.00 TX BRD PLUMBING EX PC 438 12/01/2013 PCards 10/29-11/26/13 NCTCOG RTC TRAINING 240.00 295.00 NCTCOG RTC TRAINING PC 438 12/01/2013 PCards 10/29-11/26/13 TX DPS DL OFFICE 69.00 364.00 TX DPS DL OFFICE PC 594 12/26/2013 11/27-12/26/13 PCards PAYPAL *HARDINASSOC 225.00 589.00 PAYPAL *HARDINASSOC PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 589.00 589.00 ** 4,184.00 Budgeted 3,595.00 Remaining 14 % 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 448 12/20/2013 12/20/13 Payroll Travel & per diem 100.57 100.57 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-010-000 Travel & per diem Totals: 100.57 100.57 ** 1,450.00 Budgeted 1,349.43 Remaining 7 % Used Account: 135-60105-010-000 Rent/Lease Equipment 461 12/19/2013 December A/P Nitrogen bottle lease 6.00 6.00 12.00 ALLIED WELDING SUPPLY, INC 33228 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 12.00 ** 500.00 Budgeted 488.00 Remaining 2 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 467 12/19/2013 Dec A/P Water System Fee - MUD 6,480.10 6,480.10 TX COMMISSION ENVIRONMENTAL QU 33290 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 6,480.10 6,480.10 ** 47,400.00 Budgeted 40,919.90 Remaining 14 % Used Account: 135-60150-010-000 Wholesale Water 461 12/19/2013 December A/P Wholesale water 156,340.34 156,340.34 CITY OF FORT WORTH 33233 AP 549 12/31/2013 Dec A/P Wholesale Water 127,582.84 283,923.18 CITY OF FORT WORTH 33301 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 283,923.18 283,923.18 ** 2,338,473.00 Budgeted 2,054,549.82 Remaining 12 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 438 12/01/2013 PCards 10/29-11/26/13 DENTON SAND & GRAVEL, 280.60 30.00 310.60 DENTON SAND & GRAVEL, PC 438 12/01/2013 PCards 10/29-11/26/13 TEX-TURF 22.00 332.60 TEX-TURF PC 594 12/26/2013 11/27-12/26/13 PCards TEX-TURF 28.10 360.70 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 80.10 360.70 ** 3,500.00 Budgeted 3,139.30 Remaining 10 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 594 12/26/2013 11/27-12/26/13 PCards EXXONMOBIL 47219993 1,783.84 42.62 1,826.46 EXXONMOBIL 47219993 PC 609 12/31/2013 December Gas Log 912.81 2,739.27 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 955.43 2,739.27 ** 23,181.00 Budgeted 20,441.73 Remaining 12 % Used Account: 135-65010-010-000 Uniforms 438 12/01/2013 PCards 10/29-11/26/13 RED WING SHOES #652 89.99 174.24 264.23 RED WING SHOES #652 PC 438 12/01/2013 PCards 10/29-11/26/13 TRACTOR SUPPLY COMPANY 189.98 454.21 TRACTOR SUPPLY COMPANY PC 438 12/01/2013 PCards 10/29-11/26/13 TRACTOR SUPPLY COMPANY 281.86 736.07 TRACTOR SUPPLY COMPANY PC 438 12/01/2013 PCards 10/29-11/26/13 TRACTOR SUPPLY COMPANY 273.86 1,009.93 TRACTOR SUPPLY COMPANY PC 594 12/26/2013 11/27-12/26/13 PCards RED WING SHOES #652 821.70 1,831.63 RED WING SHOES #652 PC _______________ Account: 135-65010-010-000 Uniforms Totals: 1,741.64 1,831.63 ** 3,270.00 Budgeted 1,438.37 Remaining 56 % Used Account: 135-65030-010-000 Chemicals 461 12/19/2013 December A/P Testing supplies 1,027.76 249.07 1,276.83 HACH COMPANY 33245 AP 461 12/19/2013 December A/P Testing supplies 456.00 1,732.83 HACH COMPANY 33245 AP 594 12/26/2013 11/27-12/26/13 PCards DX SERVICE 312.26 2,045.09 DX SERVICE PC _______________ Account: 135-65030-010-000 Chemicals Totals: 1,017.33 2,045.09 ** 5,000.00 Budgeted 2,954.91 Remaining 41 % Used Account: 135-65035-010-000 Small Tools 464.94 .00 464.94 . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-010-000 Small Tools Totals: .00 464.94 ** 1,200.00 Budgeted 735.06 Remaining 39 % Used Account: 135-65040-010-000 Safety Equipment 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 6.96 6.96 THE HOME DEPOT 6581 PC 594 12/26/2013 11/27-12/26/13 PCards THE HOME DEPOT 6581 9.96 16.92 THE HOME DEPOT 6581 PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 16.92 16.92 ** 1,000.00 Budgeted 983.08 Remaining 2 % Used Account: 135-65050-010-000 Meter Expense 461 12/19/2013 December A/P meter spuds 54,740.30 711.15 55,451.45 HD SUPPLY WATERWORKS, LTD. 33246 AP 461 12/19/2013 December A/P meter spuds 245.67 55,697.12 HD SUPPLY WATERWORKS, LTD. 33246 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 956.82 55,697.12 ** 143,550.00 Budgeted 87,852.88 Remaining 39 % Used Account: 135-69005-010-000 Capital Expenses .00 .00 _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 .00 ** 37,000.00 Budgeted 37,000.00 Remaining 0 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 489,980.00 Budgeted 489,980.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 ** 19,268.00 Budgeted 19,268.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2013 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-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 69,788.02 .00 69,788.02 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 69,788.02 ** 106,847.00 Budgeted 37,058.98 Remaining 65 % Used Account: 135-55135-010-001 Lab Analysis 461 12/19/2013 December A/P Bact samples in the PID 60.00 60.00 120.00 TARRANT CTY PUBLIC HEALTH LAB 33276 AP _______________ Account: 135-55135-010-001 Lab Analysis Totals: 60.00 120.00 ** 1,000.00 Budgeted 880.00 Remaining 12 % Used Account: 135-60135-010-001 TCEQ Fees & Permits 354 12/02/2013 Void A/P Check 33223/TCEQ FY14 Water System Fee/PID 4,403.85 (2,150.00) 2,253.85 TX COMMISSION ENVIRONMENTAL QU 33223 AP _______________ Account: 135-60135-010-001 TCEQ Fees & Permits Totals: (2,150.00) 2,253.85 ** .00 Budgeted (2,253.85) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 552,100.43 ** 3,932,956.00 Budgeted 3,380,855.57 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 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 361 12/06/2013 Payroll 12/6/13 Salaries & Wages 25,387.63 7,587.46 32,975.09 PR 451 12/19/2013 Service Awards Salaries & Wages 234.33 33,209.42 PR 448 12/20/2013 12/20/13 Payroll Salaries & Wages 7,587.46 40,796.88 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,409.25 40,796.88 ** 202,894.00 Budgeted 162,097.12 Remaining 20 % Used Account: 135-50010-020-000 Overtime 361 12/06/2013 Payroll 12/6/13 Overtime 2,105.12 927.69 3,032.81 PR 448 12/20/2013 12/20/13 Payroll Overtime 709.22 3,742.03 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,636.91 3,742.03 ** 11,965.00 Budgeted 8,222.97 Remaining 31 % Used Account: 135-50016-020-000 Longevity 2,997.50 .00 2,997.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,997.50 ** 2,998.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 448 12/20/2013 12/20/13 Payroll Certification 800.00 400.00 1,200.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 1,200.00 ** 4,800.00 Budgeted 3,600.00 Remaining 25 % Used Account: 135-50020-020-000 Retirement 361 12/06/2013 Payroll 12/6/13 Retirement 3,278.23 764.64 4,042.87 PR 451 12/19/2013 Service Awards Retirement 21.04 4,063.91 PR 448 12/20/2013 12/20/13 Payroll Retirement 780.97 4,844.88 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,566.65 4,844.88 ** 19,905.00 Budgeted 15,060.12 Remaining 24 % Used Account: 135-50026-020-000 Medical Insurance 361 12/06/2013 Payroll 12/6/13 Medical Insurance 6,586.46 1,620.56 8,207.02 PR 448 12/20/2013 12/20/13 Payroll Medical Insurance 1,620.53 9,827.55 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,241.09 9,827.55 ** 43,471.00 Budgeted 33,643.45 Remaining 23 % Used Account: 135-50027-020-000 Dental Insurance 361 12/06/2013 Payroll 12/6/13 Dental Insurance 452.92 113.24 566.16 PR 448 12/20/2013 12/20/13 Payroll Dental Insurance 113.22 679.38 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 679.38 ** 2,989.00 Budgeted 2,309.62 Remaining 23 % Used Account: 135-50028-020-000 Vision Insurance 361 12/06/2013 Payroll 12/6/13 Vision Insurance 99.86 24.98 124.84 PR 448 12/20/2013 12/20/13 Payroll Vision Insurance 24.95 149.79 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 49.93 149.79 ** 658.00 Budgeted 508.21 Remaining 23 % Used Account: 135-50029-020-000 Life Insurance & Other 351 12/02/2013 Dec A/P Dec Life, ADD, LTD, Dental, Vo 320.55 157.60 478.15 METLIFE 33221 AP 549 12/31/2013 Dec A/P Dental, V life, STD-other life 155.00 633.15 METLIFE 33335 AP 551 12/31/2013 Dec A/P FSA Monthly Adm, Non Discrimin 15.75 648.90 Discovery Benefits 33304 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 328.35 648.90 ** 2,303.00 Budgeted 1,654.10 Remaining 28 % Used Account: 135-50030-020-000 Social Security Taxes 361 12/06/2013 Payroll 12/6/13 Social Security Taxes 1,992.35 447.97 2,440.32 PR 451 12/19/2013 Service Awards Social Security Taxes 14.53 2,454.85 PR 448 12/20/2013 12/20/13 Payroll Social Security Taxes 596.04 3,050.89 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,058.54 3,050.89 ** 13,805.00 Budgeted 10,754.11 Remaining 22 % Used Account: 135-50035-020-000 Medicare Taxes 361 12/06/2013 Payroll 12/6/13 Medicare Taxes 465.95 104.77 570.72 PR 451 12/19/2013 Service Awards Medicare Taxes 3.40 574.12 PR 448 12/20/2013 12/20/13 Payroll Medicare Taxes 139.39 713.51 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 247.56 713.51 ** 3,229.00 Budgeted 2,515.49 Remaining 22 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 36.00 Budgeted 36.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 49 12/01/2013 Dec Ins & W/C Expense 1,070.16 535.08 1,605.24 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 1,605.24 ** 6,552.00 Budgeted 4,946.76 Remaining 25 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 63.00 .00 63.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 63.00 ** 150.00 Budgeted 87.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 594 12/26/2013 11/27-12/26/13 PCards FUZZY'S TACO SHOP 8.99 20.00 28.99 FUZZY'S TACO SHOP PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 20.00 28.99 ** 350.00 Budgeted 321.01 Remaining 8 % Used Account: 135-55070-020-000 Independent Labor 461 12/19/2013 December A/P WWTP Improvements 93,756.25 152,050.00 245,806.25 THE WALLACE GROUP, INC. 33283 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 152,050.00 245,806.25 ** .00 Budgeted (245,806.25) Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 250.66 7.48 258.14 THE HOME DEPOT 6581 PC 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 32.90 291.04 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 438 12/01/2013 PCards 10/29-11/26/13 MOTION INDUSTRIES TX03 250.66 1,156.61 1,447.65 MOTION INDUSTRIES TX03 PC 438 12/01/2013 PCards 10/29-11/26/13 TRACTOR SUPPLY COMPANY 5.97 1,453.62 TRACTOR SUPPLY COMPANY PC 438 12/01/2013 PCards 10/29-11/26/13 FASTENAL COMPANY01 22.27 1,475.89 FASTENAL COMPANY01 PC 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 31.58 1,507.47 THE HOME DEPOT 6581 PC 438 12/01/2013 PCards 10/29-11/26/13 ZUBRAS ELECTRIC INC. 1,474.25 2,981.72 ZUBRAS ELECTRIC INC. PC 594 12/26/2013 11/27-12/26/13 PCards THE HOME DEPOT 6581 84.79 3,066.51 THE HOME DEPOT 6581 PC 549 12/31/2013 Dec A/P WW generator repair 944.13 4,010.64 ENTECH SALES AND SERVICE INC 33305 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 3,759.98 4,010.64 ** 35,000.00 Budgeted 30,989.36 Remaining 11 % Used Account: 135-55090-020-000 Vehicle Maintenance 438 12/01/2013 PCards 10/29-11/26/13 AUTOZONE #4206 141.98 45.99 187.97 AUTOZONE #4206 PC 438 12/01/2013 PCards 10/29-11/26/13 GRAPEVINE GOLF CARS 250.50 438.47 GRAPEVINE GOLF CARS PC 594 12/26/2013 11/27-12/26/13 PCards BLAGG TIRE SERVICE 243.04 681.51 BLAGG TIRE SERVICE PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 539.53 681.51 ** 2,000.00 Budgeted 1,318.49 Remaining 34 % 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 549 12/31/2013 Dec A/P Sludge haul off 1,823.89 1,823.89 L.H. CHANEY MATERIALS, INC. 33324 AP 549 12/31/2013 Dec A/P Sludge haul off 1,766.31 3,590.20 L.H. CHANEY MATERIALS, INC. 33324 AP 549 12/31/2013 Dec A/P Sludge haul off 1,926.70 5,516.90 L.H. CHANEY MATERIALS, INC. 33324 AP 549 12/31/2013 Dec A/P Sludge haul off 910.98 6,427.88 L.H. CHANEY MATERIALS, INC. 33324 AP 549 12/31/2013 Dec A/P sludge haul off 926.44 7,354.32 L.H. CHANEY MATERIALS, INC. 33324 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 7,354.32 7,354.32 ** 52,000.00 Budgeted 44,645.68 Remaining 14 % Used Account: 135-55135-020-000 Lab Analysis 549 12/31/2013 Dec A/P lab testing 2,938.00 176.00 3,114.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 246.00 3,360.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 130.00 3,490.00 OXIDOR LABORATORIES LLC 33338 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 549 12/31/2013 Dec A/P lab testing 2,938.00 246.00 3,736.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 176.00 3,912.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 246.00 4,158.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P Lab testing 176.00 4,334.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 246.00 4,580.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 176.00 4,756.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 246.00 5,002.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 176.00 5,178.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 246.00 5,424.00 OXIDOR LABORATORIES LLC 33338 AP 549 12/31/2013 Dec A/P lab testing 176.00 5,600.00 OXIDOR LABORATORIES LLC 33338 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,662.00 5,600.00 ** 30,000.00 Budgeted 24,400.00 Remaining 19 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 464 12/19/2013 December A/P Acclaim and Verizon Wireless 169.77 436.36 606.13 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 109.95 716.08 TOWN OF TROPHY CLUB 33284 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 546.31 716.08 ** 3,329.00 Budgeted 2,612.92 Remaining 22 % Used Account: 135-60020-020-000 Electricity 464 12/19/2013 December A/P Electric 12,792.99 9,822.72 22,615.71 HUDSON ENERGY SERVICES, LLC 33248 AP _______________ Account: 135-60020-020-000 Electricity Totals: 9,822.72 22,615.71 ** 148,227.00 Budgeted 125,611.29 Remaining 15 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 351 12/02/2013 Dec A/P Text Book for Utilities Calcul 40.00 40.00 80.00 CITY OF FORT WORTH 33216 AP 351 12/02/2013 Dec A/P Text Book for Utilities Calcul 40.00 120.00 CITY OF FORT WORTH 33217 AP 351 12/02/2013 Dec A/P Text book for Utilities Calcul 40.00 160.00 CITY OF FORT WORTH 33218 AP _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 120.00 160.00 ** 400.00 Budgeted 240.00 Remaining 40 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 2,636.00 Budgeted 2,636.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60090-020-000 Safety Program 438 12/01/2013 PCards 10/29-11/26/13 ULINE *SHIP SUPPLIES 38.55 280.00 318.55 ULINE *SHIP SUPPLIES PC 549 12/31/2013 Dec A/P safety supplies 52.83 371.38 CINTAS CORPORATION NO. 2 33300 AP _______________ Account: 135-60090-020-000 Safety Program Totals: 332.83 371.38 ** 250.00 Budgeted (121.38) Remaining 149 % Used Account: 135-60100-020-000 Travel & per diem 448 12/20/2013 12/20/13 Payroll Travel & per diem 85.43 84.75 170.18 PR 594 12/26/2013 11/27-12/26/13 PCards TGI_FRIDAYS #0272 32.04 202.22 TGI_FRIDAYS #0272 PC 594 12/26/2013 11/27-12/26/13 PCards SCHLOTZSKY'S 1525 16.83 219.05 SCHLOTZSKY'S 1525 PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 133.62 219.05 ** 1,050.00 Budgeted 830.95 Remaining 21 % Used Account: 135-60105-020-000 Rent/Lease Equipment 299.53 .00 299.53 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 354 12/02/2013 Void A/P Check 33223/TCEQ FY14 Permit CWQ Assessment Fee 17,838.00 (8,919.00) 8,919.00 TX COMMISSION ENVIRONMENTAL QU 33223 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: (8,919.00) 8,919.00 ** 17,150.00 Budgeted 8,231.00 Remaining 52 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 609 12/31/2013 December Gas Log 1,734.99 748.70 2,483.69 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 748.70 2,483.69 ** 14,720.00 Budgeted 12,236.31 Remaining 17 % Used Account: 135-65010-020-000 Uniforms 1,284.28 .00 1,284.28 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,284.28 ** 1,752.00 Budgeted 467.72 Remaining 73 % Used Account: 135-65030-020-000 Chemicals 549 12/31/2013 Dec A/P Chemicals 2,949.64 1,680.00 4,629.64 HARCROS CHEMICALS INC 33311 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 1,680.00 4,629.64 ** 39,000.00 Budgeted 34,370.36 Remaining 12 % Used Account: 135-65035-020-000 Small Tools 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 47.34 5.74 53.08 THE HOME DEPOT 6581 PC 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 37.92 91.00 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 43.66 91.00 ** 1,000.00 Budgeted 909.00 Remaining 9 % Used Account: 135-65040-020-000 Safety Equipment 56.43 .00 56.43 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 56.43 ** 250.00 Budgeted 193.57 Remaining 23 % Used Account: 135-65045-020-000 Lab Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 438 12/01/2013 PCards 10/29-11/26/13 HACH COMPANY 4,284.43 473.17 4,757.60 HACH COMPANY PC 549 12/31/2013 Dec A/P DI water 6.13 4,763.73 OZARKA DIRECT 33339 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 479.30 4,763.73 ** 15,000.00 Budgeted 10,236.27 Remaining 32 % Used Account: 135-69005-020-000 Capital Expenses .00 .00 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 .00 ** 31,000.00 Budgeted 31,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 ** 20,020.00 Budgeted 20,020.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 1,422.00 Budgeted 1,422.00 Remaining 0 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 380,410.78 ** 768,011.00 Budgeted 387,600.22 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-021-000 Salaries & Wages 361 12/06/2013 Payroll 12/6/13 Salaries & Wages 11,318.49 2,180.37 13,498.86 PR 448 12/20/2013 12/20/13 Payroll Salaries & Wages 2,165.78 15,664.64 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 4,346.15 15,664.64 ** 90,299.00 Budgeted 74,634.36 Remaining 17 % Used Account: 135-50010-021-000 Overtime 361 12/06/2013 Payroll 12/6/13 Overtime 1,288.56 10.75 1,299.31 PR 448 12/20/2013 12/20/13 Payroll Overtime 96.01 1,395.32 PR _______________ Account: 135-50010-021-000 Overtime Totals: 106.76 1,395.32 ** 10,028.00 Budgeted 8,632.68 Remaining 14 % Used Account: 135-50016-021-000 Longevity 2,107.50 .00 2,107.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 2,107.50 ** 17,913.00 Budgeted 15,805.50 Remaining 12 % Used Account: 135-50017-021-000 Certification 448 12/20/2013 12/20/13 Payroll Certification 300.00 150.00 450.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 450.00 ** 1,800.00 Budgeted 1,350.00 Remaining 25 % Used Account: 135-50020-021-000 Retirement 361 12/06/2013 Payroll 12/6/13 Retirement 1,703.31 196.76 1,900.07 PR 448 12/20/2013 12/20/13 Payroll Retirement 216.58 2,116.65 PR _______________ Account: 135-50020-021-000 Retirement Totals: 413.34 2,116.65 ** 9,025.00 Budgeted 6,908.35 Remaining 23 % Used Account: 135-50026-021-000 Medical Insurance 361 12/06/2013 Payroll 12/6/13 Medical Insurance 3,850.37 701.20 4,551.57 PR 448 12/20/2013 12/20/13 Payroll Medical Insurance 701.19 5,252.76 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,402.39 5,252.76 ** 23,668.00 Budgeted 18,415.24 Remaining 22 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 361 12/06/2013 Payroll 12/6/13 Dental Insurance 273.41 64.50 337.91 PR 448 12/20/2013 12/20/13 Payroll Dental Insurance 64.48 402.39 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 128.98 402.39 ** 1,703.00 Budgeted 1,300.61 Remaining 24 % Used Account: 135-50028-021-000 Vision Insurance 361 12/06/2013 Payroll 12/6/13 Vision Insurance 52.03 11.92 63.95 PR 448 12/20/2013 12/20/13 Payroll Vision Insurance 11.90 75.85 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.82 75.85 ** 314.00 Budgeted 238.15 Remaining 24 % Used Account: 135-50029-021-000 Life Insurance & Other 351 12/02/2013 Dec A/P Dec Life, ADD, LTD, Dental, Vo 241.19 73.18 314.37 METLIFE 33221 AP 549 12/31/2013 Dec A/P Dental, V life, STD-other life 71.54 385.91 METLIFE 33335 AP 551 12/31/2013 Dec A/P FSA Monthly Adm, Non Discrimin 5.25 391.16 Discovery Benefits 33304 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 149.97 391.16 ** 1,066.00 Budgeted 674.84 Remaining 37 % Used Account: 135-50030-021-000 Social Security Taxes 361 12/06/2013 Payroll 12/6/13 Social Security Taxes 1,040.69 112.30 1,152.99 PR 448 12/20/2013 12/20/13 Payroll Social Security Taxes 173.93 1,326.92 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 286.23 1,326.92 ** 7,442.00 Budgeted 6,115.08 Remaining 18 % Used Account: 135-50035-021-000 Medicare Taxes 361 12/06/2013 Payroll 12/6/13 Medicare Taxes 243.38 26.27 269.65 PR 448 12/20/2013 12/20/13 Payroll Medicare Taxes 40.68 310.33 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 66.95 310.33 ** 1,741.00 Budgeted 1,430.67 Remaining 18 % Used Account: 135-50040-021-000 Unemployment Taxes .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 .00 ** 198.00 Budgeted 198.00 Remaining 0 % Used Account: 135-50045-021-000 Workman's Compensation 49 12/01/2013 Dec Ins & W/C Expense 535.08 267.54 802.62 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 802.62 ** 3,276.00 Budgeted 2,473.38 Remaining 25 % Used Account: 135-50070-021-000 Employee Relations 594 12/26/2013 11/27-12/26/13 PCards FUZZY'S TACO SHOP 8.99 21.69 30.68 FUZZY'S TACO SHOP PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 21.69 30.68 ** 200.00 Budgeted 169.32 Remaining 15 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 438 12/01/2013 PCards 10/29-11/26/13 THE HOME DEPOT 6581 27.97 65.31 93.28 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 65.31 93.28 ** 23,801.00 Budgeted 23,707.72 Remaining 0 % Used Account: 135-55090-021-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 464 12/19/2013 December A/P Acclaim and Verizon Wireless 102.52 102.52 205.04 TOWN OF TROPHY CLUB 33284 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2013 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-021-000 Communications/Pagers/Mobiles Totals: 102.52 205.04 ** 1,333.00 Budgeted 1,127.96 Remaining 15 % Used Account: 135-60020-021-000 Electricity 461 12/19/2013 December A/P electricity 1,909.55 27.96 1,937.51 TRI COUNTY ELECTRIC 33285 AP 461 12/19/2013 December A/P Electricity 265.53 2,203.04 TRI COUNTY ELECTRIC 33285 AP 461 12/19/2013 December A/P electricity 145.52 2,348.56 TRI COUNTY ELECTRIC 33285 AP 464 12/19/2013 December A/P Electric 1,133.74 3,482.30 HUDSON ENERGY SERVICES, LLC 33248 AP 549 12/31/2013 Dec A/P Electricity 11/11-12/12 75.30 3,557.60 HUDSON ENERGY SERVICES, LLC 33316 AP 553 12/31/2013 Dec A/P Electricity 11/8-12/12/13 636.30 4,193.90 HUDSON ENERGY SERVICES, LLC 33353 AP 553 12/31/2013 Dec A/P Electricity 11/8-12/11/13 58.49 4,252.39 HUDSON ENERGY SERVICES, LLC 33353 AP 553 12/31/2013 Dec A/P Electricity 11/8-12/11/13 30.39 4,282.78 HUDSON ENERGY SERVICES, LLC 33353 AP 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (281.13) 4,001.65 AR _______________ Account: 135-60020-021-000 Electricity Totals: 2,092.10 4,001.65 ** 21,178.00 Budgeted 17,176.35 Remaining 19 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training .00 .00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 .00 ** 1,711.00 Budgeted 1,711.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 609 12/31/2013 December Gas Log 2,018.55 853.85 2,872.40 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 853.85 2,872.40 ** 22,397.00 Budgeted 19,524.60 Remaining 13 % Used Account: 135-65010-021-000 Uniforms 549 12/31/2013 Dec A/P Jacket-Jason Ramirez 576.14 115.65 691.79 HD SUPPLY FACILITIES MAINT LTD 33312 AP 549 12/31/2013 Dec A/P Winter coat-Dewayne 122.44 814.23 HD SUPPLY FACILITIES MAINT LTD 33312 AP _______________ Account: 135-65010-021-000 Uniforms Totals: 238.09 814.23 ** 1,040.00 Budgeted 225.77 Remaining 78 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools 43.99 .00 43.99 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-021-000 Small Tools Totals: .00 43.99 ** 1,000.00 Budgeted 956.01 Remaining 4 % Used Account: 135-65040-021-000 Safety Equipment 540.75 .00 540.75 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 540.75 ** 500.00 Budgeted (40.75) Remaining 108 % Used Account: 135-69005-021-000 Capital Expenses .00 .00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 .00 ** 100,000.00 Budgeted 100,000.00 Remaining 0 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 35,991.00 Budgeted 35,991.00 Remaining 0 % Used Account: 135-69009-021-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-021-000 Short Term Debt-Interest Totals: .00 .00 ** 2,846.00 Budgeted 2,846.00 Remaining 0 % Used Account: 135-69280-021-000 Capital Repairs .00 .00 _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 71,000.00 Budgeted 71,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 38,898.16 ** 472,170.00 Budgeted 433,271.84 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2013 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 448 12/20/2013 12/20/13 Payroll Salaries & Wages 2,000.00 500.00 2,500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 2,500.00 ** 10,000.00 Budgeted 7,500.00 Remaining 25 % Used Account: 135-50030-026-000 Social Security Taxes 448 12/20/2013 12/20/13 Payroll Social Security Taxes 124.00 31.00 155.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 155.00 ** 620.00 Budgeted 465.00 Remaining 25 % Used Account: 135-50035-026-000 Medicare Taxes 448 12/20/2013 12/20/13 Payroll Medicare Taxes 29.00 7.25 36.25 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 36.25 ** 145.00 Budgeted 108.75 Remaining 25 % Used Account: 135-50040-026-000 Unemployment Taxes 448 12/20/2013 12/20/13 Payroll Unemployment Taxes 2.00 .50 2.50 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .50 2.50 ** 10.00 Budgeted 7.50 Remaining 25 % Used Account: 135-50045-026-000 Workman's Compensation 49 12/01/2013 Dec Ins & W/C Expense 5.90 2.95 8.85 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.95 8.85 ** 36.00 Budgeted 27.15 Remaining 25 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 461 12/19/2013 December A/P Adm fee 35.00 35.00 TX SOCIAL SECURITY PROGRAM 33288 AP _______________ Account: 135-60070-026-000 Dues & Memberships Totals: 35.00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 438 12/01/2013 PCards 10/29-11/26/13 NW METROPORT CHAMBER O 5.00 22.00 27.00 NW METROPORT CHAMBER O PC 594 12/26/2013 11/27-12/26/13 PCards RANDALLS STORE00017897 8.95 35.95 RANDALLS STORE00017897 PC _______________ Account: 135-60075-026-000 Meetings Totals: 30.95 35.95 ** 1,200.00 Budgeted 1,164.05 Remaining 3 % Used Account: 135-60080-026-000 Schools & Training 265.00 .00 265.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 265.00 ** 4,000.00 Budgeted 3,735.00 Remaining 7 % 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 .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 3,038.55 ** 22,661.00 Budgeted 19,622.45 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 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 361 12/06/2013 Payroll 12/6/13 Salaries & Wages 57,796.26 17,297.64 75,093.90 PR 451 12/19/2013 Service Awards Salaries & Wages 58.58 75,152.48 PR 448 12/20/2013 12/20/13 Payroll Salaries & Wages 17,298.43 92,450.91 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 34,654.65 92,450.91 ** 458,721.00 Budgeted 366,270.09 Remaining 20 % Used Account: 135-50010-030-000 Overtime 361 12/06/2013 Payroll 12/6/13 Overtime 239.58 11.19 250.77 PR 448 12/20/2013 12/20/13 Payroll Overtime 9.10 259.87 PR _______________ Account: 135-50010-030-000 Overtime Totals: 20.29 259.87 ** 500.00 Budgeted 240.13 Remaining 52 % Used Account: 135-50016-030-000 Longevity 3,077.50 .00 3,077.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,077.50 ** 3,018.00 Budgeted (59.50) Remaining 102 % Used Account: 135-50020-030-000 Retirement 361 12/06/2013 Payroll 12/6/13 Retirement 6,460.69 1,554.35 8,015.04 PR 451 12/19/2013 Service Awards Retirement 5.26 8,020.30 PR 448 12/20/2013 12/20/13 Payroll Retirement 1,554.22 9,574.52 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,113.83 9,574.52 ** 41,419.00 Budgeted 31,844.48 Remaining 23 % Used Account: 135-50026-030-000 Medical Insurance 361 12/06/2013 Payroll 12/6/13 Medical Insurance 8,728.70 2,301.30 11,030.00 PR 448 12/20/2013 12/20/13 Payroll Medical Insurance 2,301.23 13,331.23 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,602.53 13,331.23 ** 57,923.00 Budgeted 44,591.77 Remaining 23 % Used Account: 135-50027-030-000 Dental Insurance 361 12/06/2013 Payroll 12/6/13 Dental Insurance 772.68 193.19 965.87 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 448 12/20/2013 12/20/13 Payroll Dental Insurance 772.68 193.15 1,159.02 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 386.34 1,159.02 ** 5,100.00 Budgeted 3,940.98 Remaining 23 % Used Account: 135-50028-030-000 Vision Insurance 361 12/06/2013 Payroll 12/6/13 Vision Insurance 165.06 41.29 206.35 PR 448 12/20/2013 12/20/13 Payroll Vision Insurance 41.24 247.59 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 247.59 ** 1,087.00 Budgeted 839.41 Remaining 23 % Used Account: 135-50029-030-000 Life Insurance & Other 351 12/02/2013 Dec A/P Dec Life, ADD, LTD, Dental, Vo 636.79 318.22 955.01 METLIFE 33221 AP 549 12/31/2013 Dec A/P Dental, V life, STD-other life 309.12 1,264.13 METLIFE 33335 AP 551 12/31/2013 Dec A/P FSA Monthly Adm, Non Discrimin 536.75 1,800.88 Discovery Benefits 33304 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 1,164.09 1,800.88 ** 4,483.00 Budgeted 2,682.12 Remaining 40 % Used Account: 135-50030-030-000 Social Security Taxes 361 12/06/2013 Payroll 12/6/13 Social Security Taxes 4,159.94 994.72 5,154.66 PR 451 12/19/2013 Service Awards Social Security Taxes 3.63 5,158.29 PR 448 12/20/2013 12/20/13 Payroll Social Security Taxes 1,110.86 6,269.15 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,109.21 6,269.15 ** 28,659.00 Budgeted 22,389.85 Remaining 22 % Used Account: 135-50035-030-000 Medicare Taxes 361 12/06/2013 Payroll 12/6/13 Medicare Taxes 972.90 232.63 1,205.53 PR 451 12/19/2013 Service Awards Medicare Taxes .85 1,206.38 PR 448 12/20/2013 12/20/13 Payroll Medicare Taxes 259.80 1,466.18 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 493.28 1,466.18 ** 6,702.00 Budgeted 5,235.82 Remaining 22 % Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 .00 ** 63.00 Budgeted 63.00 Remaining 0 % Used Account: 135-50045-030-000 Workman's Compensation 49 12/01/2013 Dec Ins & W/C Expense 257.26 128.63 385.89 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.63 385.89 ** 1,575.00 Budgeted 1,189.11 Remaining 25 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 438 12/01/2013 PCards 10/29-11/26/13 DOLLAR-GENERAL #8688 687.85 20.57 708.42 DOLLAR-GENERAL #8688 PC 438 12/01/2013 PCards 10/29-11/26/13 AMAZON MKTPLACE PMTS 24.85 733.27 AMAZON MKTPLACE PMTS PC 438 12/01/2013 PCards 10/29-11/26/13 SAMSCLUB #4795 83.50 816.77 SAMSCLUB #4795 PC 438 12/01/2013 PCards 10/29-11/26/13 HOUSE OF PETALS 59.00 875.77 HOUSE OF PETALS PC 594 12/26/2013 11/27-12/26/13 PCards RANDALLS STORE00017897 5.00 880.77 RANDALLS STORE00017897 PC 594 12/26/2013 11/27-12/26/13 PCards CHEESECAKE SOUTHLAKE 369.25 1,250.02 CHEESECAKE SOUTHLAKE PC 594 12/26/2013 11/27-12/26/13 PCards RANDALLS STORE00017897 46.47 1,296.49 RANDALLS STORE00017897 PC 594 12/26/2013 11/27-12/26/13 PCards WAL-MART #5247 32.84 1,329.33 WAL-MART #5247 PC 594 12/26/2013 11/27-12/26/13 PCards WAL-MART #5247 108.10 1,437.43 WAL-MART #5247 PC 594 12/26/2013 11/27-12/26/13 PCards MICHAELS STORES 2063 11.94 1,449.37 MICHAELS STORES 2063 PC 594 12/26/2013 11/27-12/26/13 PCards LA SCALA 15.00 1,464.37 LA SCALA PC 594 12/26/2013 11/27-12/26/13 PCards FIVE BELOW #1118 95.00 1,559.37 FIVE BELOW #1118 PC 594 12/26/2013 11/27-12/26/13 PCards CONTAINERSTORESOUTHLAK 279.59 1,838.96 CONTAINERSTORESOUTHLAK PC 594 12/26/2013 11/27-12/26/13 PCards CRISTINA S MEXICAN 15.00 1,853.96 CRISTINA S MEXICAN PC 594 12/26/2013 11/27-12/26/13 PCards FISH KNIFE JAPANESE CU 15.00 1,868.96 FISH KNIFE JAPANESE CU PC 594 12/26/2013 11/27-12/26/13 PCards 7-ELEVEN 32921 15.00 1,883.96 7-ELEVEN 32921 PC 594 12/26/2013 11/27-12/26/13 PCards WEINBERGERS DELI TWO 15.00 1,898.96 WEINBERGERS DELI TWO PC 594 12/26/2013 11/27-12/26/13 PCards VINNYS ITALIAN RESTAUR 15.00 1,913.96 VINNYS ITALIAN RESTAUR PC 594 12/26/2013 11/27-12/26/13 PCards SUBWAY 00217794 15.00 1,928.96 SUBWAY 00217794 PC 594 12/26/2013 11/27-12/26/13 PCards DIEGOS TEX-MEX AND KIT 15.00 1,943.96 DIEGOS TEX-MEX AND KIT PC 594 12/26/2013 11/27-12/26/13 PCards WAL-MART #5247 12.00 1,955.96 WAL-MART #5247 PC 594 12/26/2013 11/27-12/26/13 PCards STARBUCKS #06552 TROPH 15.00 1,970.96 STARBUCKS #06552 TROPH PC 549 12/31/2013 Dec A/P Christmas turkey and ham 4,025.00 5,995.96 TEXAS BEST PROTIENS, LP 33347 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: 687.85 (3,185.00) 2,810.96 AR _______________ Account: 135-50070-030-000 Employee Relations Totals: 2,123.11 2,810.96 ** 5,000.00 Budgeted 2,189.04 Remaining 56 % Used Account: 135-55030-030-000 Software & Support 461 12/19/2013 December A/P SHI & Videotape 6,332.60 2,754.35 9,086.95 TOWN OF TROPHY CLUB 33284 AP 461 12/19/2013 December A/P SHI & Videotape 712.50 9,799.45 TOWN OF TROPHY CLUB 33284 AP 461 12/19/2013 December A/P annual maint-check scanner 577.50 10,376.95 TECHNIQUE DATA SYSTEMS INC 33279 AP 464 12/19/2013 December A/P Acclaim and Verizon Wireless 420.00 10,796.95 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 5.99 10,802.94 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 25.00 10,827.94 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 53.38 10,881.32 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 69.99 10,951.31 TOWN OF TROPHY CLUB 33284 AP 553 12/31/2013 Dec A/P Vision Report training and sup 4,494.82 15,446.13 STW INC 33354 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 9,113.53 15,446.13 ** 59,698.00 Budgeted 44,251.87 Remaining 26 % Used Account: 135-55070-030-000 Independent Labor 461 12/19/2013 December A/P Record CAC meeting 1,862.95 37.50 1,900.45 MIGUEL CRUZ 33263 AP 461 12/19/2013 December A/P Record CAC meeting 18.75 1,919.20 MIGUEL CRUZ 33263 AP 464 12/19/2013 December A/P Acclaim and Verizon Wireless 125.00 2,044.20 TOWN OF TROPHY CLUB 33284 AP 464 12/19/2013 December A/P Record MUD Meeting 71.25 2,115.45 MIGUEL CRUZ 33263 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 252.50 2,115.45 ** 7,700.00 Budgeted 5,584.55 Remaining 27 % Used Account: 135-55080-030-000 Maintenance & Repairs 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (1,341.21) (236.05) (1,577.26) AR _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: (236.05) (1,577.26) ** 4,500.00 Budgeted 6,077.26 Remaining -35 % Used Account: 135-55100-030-000 Building Maint & Supplies 461 12/19/2013 December A/P Rug Service-November 261.34 94.42 355.76 G & K SERVICES 33243 AP 461 12/19/2013 December A/P Rug Service-November 94.42 450.18 G & K SERVICES 33243 AP 461 12/19/2013 December A/P Rug Service-November 94.42 544.60 G & K SERVICES 33243 AP 461 12/19/2013 December A/P Rug Service-November 94.42 639.02 G & K SERVICES 33243 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 464 12/19/2013 December A/P Rug Service-October 261.34 94.42 733.44 G & K SERVICES 33243 AP 464 12/19/2013 December A/P Rug Service-October 94.42 827.86 G & K SERVICES 33243 AP 464 12/19/2013 December A/P Rug Service-October 94.42 922.28 G & K SERVICES 33243 AP 464 12/19/2013 December A/P Rug Service-October 94.42 1,016.70 G & K SERVICES 33243 AP 594 12/26/2013 11/27-12/26/13 PCards THE HOME DEPOT 6581 14.91 1,031.61 THE HOME DEPOT 6581 PC 594 12/26/2013 11/27-12/26/13 PCards THE HOME DEPOT 6581 12.47 1,044.08 THE HOME DEPOT 6581 PC 549 12/31/2013 Dec A/P Rug service-Dec 94.42 1,138.50 G & K SERVICES 33309 AP 549 12/31/2013 Dec A/P Rug service-Dec 94.42 1,232.92 G & K SERVICES 33309 AP 549 12/31/2013 Dec A/P Rug service-Dec 94.42 1,327.34 G & K SERVICES 33309 AP 549 12/31/2013 Dec A/P Rug service-Dec 94.42 1,421.76 G & K SERVICES 33309 AP 549 12/31/2013 Dec A/P Rug service-Dec 94.42 1,516.18 G & K SERVICES 33309 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 1,254.84 1,516.18 ** 6,500.00 Budgeted 4,983.82 Remaining 23 % Used Account: 135-55120-030-000 Cleaning Services 461 12/19/2013 December A/P Janitorial/Nov 1,594.97 1,594.97 3,189.94 MEMBER'S BUILDING MAINTENANCE 33262 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 3,189.94 ** 19,140.00 Budgeted 15,950.06 Remaining 17 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55161-030-000 Outside Services-Town Semo 38,524.00 .00 38,524.00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 38,524.00 ** 77,048.00 Budgeted 38,524.00 Remaining 50 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55205-030-000 Utility Billing Contract 553 12/31/2013 Dec A/P November Utility billing 570.00 582.20 1,152.20 DATAPROSE LLC 33352 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 582.20 1,152.20 ** 6,808.00 Budgeted 5,655.80 Remaining 17 % Used Account: 135-60005-030-000 Telephone 461 12/19/2013 December A/P answering service 1,410.06 180.00 1,590.06 KEYSTONE PARK SECRETARIAL 33253 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 3.69 1,593.75 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 500.18 2,093.93 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 402.46 2,496.39 TOWN OF TROPHY CLUB 33284 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,086.33 2,496.39 ** 11,250.00 Budgeted 8,753.61 Remaining 22 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 464 12/19/2013 December A/P Acclaim and Verizon Wireless 402.52 177.27 579.79 TOWN OF TROPHY CLUB 33284 AP 448 12/20/2013 12/20/13 Payroll Communications/Pagers/Mobiles 150.00 729.79 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 327.27 729.79 ** 3,589.00 Budgeted 2,859.21 Remaining 20 % Used Account: 135-60020-030-000 Electricity/Gas 464 12/19/2013 December A/P Electricity 887.96 887.96 TOWN OF TROPHY CLUB 33284 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 887.96 887.96 ** 15,171.00 Budgeted 14,283.04 Remaining 6 % Used Account: 135-60025-030-000 Water 461 12/19/2013 December A/P water bills 46.10 110.32 156.42 TROPHY CLUB MUD (WATER BILLS) 33286 AP 549 12/31/2013 Dec A/P Dec Water 92.02 248.44 TROPHY CLUB MUD (WATER BILLS) 33348 AP 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (46.01) 202.43 AR _______________ Account: 135-60025-030-000 Water Totals: 156.33 202.43 ** 1,500.00 Budgeted 1,297.57 Remaining 13 % Used Account: 135-60035-030-000 Postage 438 12/01/2013 PCards 10/29-11/26/13 USPS POSTAL ST66100207 3,033.12 460.00 3,493.12 USPS POSTAL ST66100207 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 461 12/19/2013 December A/P overnight letter 3,033.12 4.99 3,498.11 FEDERAL EXPRESS CORP 33239 AP 461 12/19/2013 December A/P overnight to Jason ramirez 7.99 3,506.10 FEDERAL EXPRESS CORP 33239 AP 549 12/31/2013 Dec A/P overnight to JP Morgan Chase 6.17 3,512.27 FEDERAL EXPRESS CORP 33307 AP 553 12/31/2013 Dec A/P November Utility billing 1,614.00 5,126.27 DATAPROSE LLC 33352 AP 604 12/31/2013 December Postage meter 104.51 5,230.78 GL _______________ Account: 135-60035-030-000 Postage Totals: 2,197.66 5,230.78 ** 28,500.00 Budgeted 23,269.22 Remaining 18 % Used Account: 135-60040-030-000 Service Charges & Fees 579 12/03/2013 Credit card fees/Nov 3,668.07 49.22 3,717.29 GL 579 12/03/2013 Credit card fees/Nov 90.10 3,807.39 GL 579 12/03/2013 Credit card fees/Nov 2,738.25 6,545.64 GL 580 12/24/2013 Dec FF Account Analysis 250.00 6,795.64 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,127.57 6,795.64 ** 28,330.00 Budgeted 21,534.36 Remaining 24 % Used Account: 135-60050-030-000 Bad Debt Expense 517 12/31/2013 UB 12/31/13 Write Offs UB20131231-20131231 User: 3,712.56 3,712.56 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 3,712.56 3,712.56 ** 1,500.00 Budgeted (2,212.56) Remaining 248 % Used Account: 135-60055-030-000 Insurance 49 12/01/2013 Dec Ins & W/C Expense 8,572.71 4,269.73 12,842.44 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,269.73 12,842.44 ** 53,561.00 Budgeted 40,718.56 Remaining 24 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 594 12/26/2013 11/27-12/26/13 PCards HRSIMPLE 126.00 126.00 HRSIMPLE PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 126.00 126.00 ** 1,000.00 Budgeted 874.00 Remaining 13 % Used Account: 135-60070-030-000 Dues & Memberships 461 12/19/2013 December A/P Membership dues 940.00 2,991.95 3,931.95 Texas Rural Water Assoc 33278 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 2,991.95 3,931.95 ** 4,500.00 Budgeted 568.05 Remaining 87 % 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-60080-030-000 Schools & Training 438 12/01/2013 PCards 10/29-11/26/13 TX SECRETARY OF STATE 190.00 190.00 TX SECRETARY OF STATE PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 190.00 190.00 ** 7,500.00 Budgeted 7,310.00 Remaining 3 % Used Account: 135-60100-030-000 Travel & per diem 361 12/06/2013 Payroll 12/6/13 Travel & per diem 68.48 9.49 77.97 PR 448 12/20/2013 12/20/13 Payroll Travel & per diem 39.15 117.12 PR 594 12/26/2013 11/27-12/26/13 PCards DAVE & BUSTERS #21 20.80 137.92 DAVE & BUSTERS #21 PC 594 12/26/2013 11/27-12/26/13 PCards FIVE GUYS-TX # 045 9.61 147.53 FIVE GUYS-TX # 045 PC 594 12/26/2013 11/27-12/26/13 PCards CANDLEWOOD SUITES 307.02 454.55 CANDLEWOOD SUITES PC 549 12/31/2013 Dec A/P Travel & per diem 146.81 601.36 JENNIFER MCKNIGHT 33321 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 532.88 601.36 ** 5,000.00 Budgeted 4,398.64 Remaining 12 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security 465 12/19/2013 Dec A/P IT Dept BOA PCards 53.56 53.56 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 70.00 123.56 TOWN OF TROPHY CLUB 33284 AP _______________ Account: 135-60235-030-000 Security Totals: 123.56 123.56 ** 1,350.00 Budgeted 1,226.44 Remaining 9 % Used Account: 135-60245-030-000 Miscellaneous Expenses 594 12/26/2013 11/27-12/26/13 PCards BIG LOTS #4622 19.70 41.68 61.38 BIG LOTS #4622 PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 41.68 61.38 ** 22,870.00 Budgeted 22,808.62 Remaining 0 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-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 438 12/01/2013 PCards 10/29-11/26/13 LANDS END BUS OUTFITTE 521.00 49.95 570.95 LANDS END BUS OUTFITTE PC 438 12/01/2013 PCards 10/29-11/26/13 LANDS END BUS OUTFITTE 427.95 998.90 LANDS END BUS OUTFITTE PC _______________ Account: 135-65010-030-000 Uniforms Totals: 477.90 998.90 ** 1,390.00 Budgeted 391.10 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65055-030-000 Hardware 461 12/19/2013 December A/P SHI & Videotape 1,335.86 148.92 1,484.78 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 84.23 1,569.01 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 28.45 1,597.46 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 74.99 1,672.45 TOWN OF TROPHY CLUB 33284 AP _______________ Account: 135-65055-030-000 Hardware Totals: 336.59 1,672.45 ** 13,562.00 Budgeted 11,889.55 Remaining 12 % Used Account: 135-65085-030-000 Office Supplies 438 12/01/2013 PCards 10/29-11/26/13 USPS POSTAL ST66100207 751.32 107.35 858.67 USPS POSTAL ST66100207 PC 461 12/19/2013 December A/P Office supplies 94.15 952.82 OFFICE DEPOT, INC 33266 AP 461 12/19/2013 December A/P Business cards-Terri Sisk 60.00 1,012.82 SIGMA SIGNS & PRINTING 33272 AP 464 12/19/2013 December A/P Office Supplies 3.99 1,016.81 OFFICE DEPOT, INC 33266 AP 549 12/31/2013 Dec A/P Office supplies 141.38 1,158.19 OFFICE DEPOT, INC 33336 AP 549 12/31/2013 Dec A/P Office supplies 97.28 1,255.47 OFFICE DEPOT, INC 33336 AP 610 12/31/2013 Town Billing Inv 1115-1124 AR 20131231-20131231 User: (54.98) 1,200.49 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 449.17 1,200.49 ** 9,100.00 Budgeted 7,899.51 Remaining 13 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 461 12/19/2013 December A/P SHI & Videotape 491.50 128.00 619.50 TOWN OF TROPHY CLUB 33284 AP 465 12/19/2013 Dec A/P IT Dept BOA PCards 284.62 904.12 TOWN OF TROPHY CLUB 33284 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 412.62 904.12 ** 5,732.00 Budgeted 4,827.88 Remaining 16 % Used Account: 135-65095-030-000 Maintenance Supplies 438 12/01/2013 PCards 10/29-11/26/13 SAMSCLUB #4795 94.40 60.83 155.23 SAMSCLUB #4795 PC 438 12/01/2013 PCards 10/29-11/26/13 GREAT COFFEES OF AMERI 75.32 230.55 GREAT COFFEES OF AMERI PC 438 12/01/2013 PCards 10/29-11/26/13 SAMSCLUB #4795 214.07 444.62 SAMSCLUB #4795 PC 461 12/19/2013 December A/P Tea, gloves 53.97 498.59 COSTCO WHOLESALE 33235 AP 594 12/26/2013 11/27-12/26/13 PCards RANDALLS STORE00017897 4.99 503.58 RANDALLS STORE00017897 PC 594 12/26/2013 11/27-12/26/13 PCards SAMSCLUB #4795 247.22 750.80 SAMSCLUB #4795 PC 549 12/31/2013 Dec A/P coffee 5.99 756.79 COSTCO WHOLESALE 33302 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 662.39 756.79 ** 2,500.00 Budgeted 1,743.21 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65097-030-000 Vending Machine Supplies 27.06 .00 27.06 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 27.06 ** 200.00 Budgeted 172.94 Remaining 14 % Used Account: 135-65105-030-000 Printing 1,401.00 .00 1,401.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 1,401.00 ** 4,000.00 Budgeted 2,599.00 Remaining 35 % Used Account: 135-69170-030-000 Copier Lease Installments 256.85 .00 256.85 _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: .00 256.85 ** 3,450.00 Budgeted 3,193.15 Remaining 7 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 238,350.24 ** 1,055,199.00 Budgeted 816,848.76 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/2013 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 461 12/19/2013 December A/P Legal 26,461.45 16,499.79 42,961.24 BOOTH, AHRENS & WERKENTHIN PC 33231 AP 461 12/19/2013 December A/P legal 1,611.55 44,572.79 BOOTH, AHRENS & WERKENTHIN PC 33231 AP 461 12/19/2013 December A/P legal 7,425.00 51,997.79 FREEMAN & CORBETT 33242 AP 462 12/19/2013 Dec A/P Nov Legal 6,576.77 58,574.56 THE LISTON LAW FIRM, P.C. 33281 AP 549 12/31/2013 Dec A/P Legal 840.00 59,414.56 WHITAKER CHALK SWINDLE 33350 AP 549 12/31/2013 Dec A/P Legal 60.00 59,474.56 WHITAKER CHALK SWINDLE 33350 AP 549 12/31/2013 Dec A/P Legal 235.20 59,709.76 WHITAKER CHALK SWINDLE 33350 AP 549 12/31/2013 Dec A/P Legal 9,636.20 69,345.96 WHITAKER CHALK SWINDLE 33350 AP 549 12/31/2013 Dec A/P legal 67.20 69,413.16 WHITAKER CHALK SWINDLE 33350 AP _______________ Account: 135-55045-039-000 Legal Totals: 42,951.71 69,413.16 ** 131,300.00 Budgeted 61,886.84 Remaining 53 % Used Account: 135-55055-039-000 Auditing 461 12/19/2013 December A/P Interim Audit 15,900.00 15,900.00 LAFOLLETT & ABBOTT PLLC 33254 AP _______________ Account: 135-55055-039-000 Auditing Totals: 15,900.00 15,900.00 ** 21,840.00 Budgeted 5,940.00 Remaining 73 % Used Account: 135-55060-039-000 Appraisal 461 12/19/2013 December A/P Budget Allocation 3,344.70 1,913.49 5,258.19 DENTON CENTRAL APPRAISAL DISTR 33237 AP 573 12/19/2013 Denton Cty Tax/Refund tax land (928.81) 4,329.38 GL _______________ Account: 135-55060-039-000 Appraisal Totals: 984.68 4,329.38 ** 10,000.00 Budgeted 5,670.62 Remaining 43 % 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: ------------------------------------------------------------------------------------------------ 89,642.54 ** 166,940.00 Budgeted 77,297.46 Remaining 54 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 78,823.90 .00 Budgeted (78,823.90) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 12/2013 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 578 12/31/2013 Bank Statement Interest/Dec (26.08) (10.42) (36.50) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (10.42) (36.50) ** .00 Budgeted 36.50 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (36.50) ** .00 Budgeted 36.50 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter 458 12/01/2013 Retainage App 5-ROFC 53,279.99 5,599.44 58,879.43 GL 459 12/01/2013 Retainage App 6-ROFC 1,718.08 60,597.51 GL 464 12/19/2013 December A/P App 6-FW Meter 15,462.67 76,060.18 REY-MAR CONSTRUCTION 33269 AP _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: 22,780.19 76,060.18 ** .00 Budgeted (76,060.18) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 76,060.18 ** .00 Budgeted (76,060.18) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 76,023.68 .00 Budgeted (76,023.68) Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET DECEMBER 31, 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 211,073 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 200,757 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 416,676 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 200,757 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 200,757 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 198,040 TOTAL FUND BALANCE 215,919 TOTAL LIABILITIES AND FUND BALANCE 416,676 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 14:27 01/13/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 389,216.00- 389,216.00- 177,313.90- 198,033.31- 50.880 191,182.69- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 10.04- 9.63 -.385 2,509.63- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- .55- 13.38- .836 1,586.62- Subtotal: 393,316.00- 393,316.00- 177,324.49- 198,037.06- 50.351 195,278.94- 533-48005-000-000 Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- Subtotal: 16,525.00- 16,525.00- 16,525.00- 533-49010-000-000 Interest Income 375.00- 375.00- 1.65- 3.14- .837 371.86- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- Subtotal: 214,654.00- 214,654.00- 1.65- 3.14- .001 214,650.86- Program number: 624,495.00- 624,495.00- 177,326.14- 198,040.20- 31.712 426,454.80- Department number: Revenues 624,495.00- 624,495.00- 177,326.14- 198,040.20- 31.712 426,454.80- Revenues Subtotal ----------- 624,495.00- 624,495.00- 177,326.14- 198,040.20- 31.712 426,454.80- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 14:27 01/13/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 2,300.00 533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 197,195.00 533-70035-051-000 Bond Principal Payment 425,000.00 425,000.00 425,000.00 Subtotal: 624,495.00 624,495.00 624,495.00 Program number: 624,495.00 624,495.00 624,495.00 Department number: Administration 624,495.00 624,495.00 624,495.00 Expenditures Subtotal ----------- 624,495.00 624,495.00 624,495.00 Fund number: 533 MUD 1 I&S Consolidated 177,326.14- 198,040.20- 198,040.20 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2013 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 538 12/02/2013 Property Taxes & Assessments (20,719.41) (2,214.95) (22,934.36) GL 545 12/03/2013 Property Taxes & Assessments (2,106.33) (25,040.69) GL 546 12/04/2013 Property Taxes & Assessments (1,299.76) (26,340.45) GL 570 12/05/2013 Property Taxes & Assessments (706.71) (27,047.16) GL 548 12/10/2013 Property Taxes & Assessments (1,557.36) (28,604.52) GL 556 12/11/2013 Property Taxes & Assessments (2,742.19) (31,346.71) GL 557 12/12/2013 Property Taxes & Assessments (13,900.03) (45,246.74) GL 558 12/13/2013 Property Taxes & Assessments (1,481.84) (46,728.58) GL 559 12/16/2013 Property Taxes & Assessments (2,599.09) (49,327.67) GL 560 12/17/2013 Property Taxes & Assessments (3,636.25) (52,963.92) GL 561 12/18/2013 Property Taxes & Assessments (3,190.47) (56,154.39) GL 562 12/19/2013 Property Taxes & Assessments (2,900.31) (59,054.70) GL 563 12/20/2013 Property Taxes & Assessments (2,673.45) (61,728.15) GL 564 12/23/2013 Property Taxes & Assessments (2,483.30) (64,211.45) GL 565 12/26/2013 Property Taxes & Assessments (6,435.82) (70,647.27) GL 566 12/27/2013 Property Taxes & Assessments (101,906.25) (172,553.52) GL 567 12/30/2013 Property Taxes & Assessments (3,165.69) (175,719.21) GL 568 12/31/2013 Property Taxes & Assessments (22,314.10) (198,033.31) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (177,313.90) (198,033.31) ** (389,216.00) Budgeted (191,182.69) Remaining 51 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 538 12/02/2013 Property Taxes & Assessments 19.67 (.07) 19.60 GL 556 12/11/2013 Property Taxes & Assessments 4.87 24.47 GL 567 12/30/2013 Property Taxes & Assessments (14.84) 9.63 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (10.04) 9.63 ** (2,500.00) Budgeted (2,509.63) Remaining 0 % Used Account: 533-40015-000-000 Property Taxes/P & I 538 12/02/2013 Property Taxes & Assessments (12.83) (.02) (12.85) GL 567 12/30/2013 Property Taxes & Assessments (.53) (13.38) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (.55) (13.38) ** (1,600.00) Budgeted (1,586.62) Remaining 1 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (16,525.00) Budgeted (16,525.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 578 12/31/2013 Bank Statement Interest/Dec (1.49) (1.65) (3.14) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1.65) (3.14) ** (375.00) Budgeted (371.86) Remaining 1 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (214,279.00) Budgeted (214,279.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (198,040.20) ** (624,495.00) Budgeted (426,454.80) Remaining 32 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 14:27 01/13/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 .00 ** 2,300.00 Budgeted 2,300.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 .00 ** 197,195.00 Budgeted 197,195.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 425,000.00 Budgeted 425,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 624,495.00 Budgeted 624,495.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (198,040.20) .00 Budgeted 198,040.20 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (557,203.28) **** .00 Budgeted 557,203.28 Remaining 0 % Used ******* End of Report *********