Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
June Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JUNE 30, 2013 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 756,949 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 19,073 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 8,927 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,434 TOTAL ASSETS 786,385 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 28,001 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 28,001 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - UNASSIGNED FUND BALANCE 350,496 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 407,888 TOTAL FUND BALANCE 758,384 TOTAL LIABILITIES AND FUND BALANCE 786,385 . glbase_tbam tsisk Trophy Club MUD #1 Page 1 15:26 07/09/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 252,084.00- 252,084.00- 522.07- 254,600.26- 100.998 2,516.26 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 700.00- 66.21- 9.459 633.79- 122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 2,340.72- 1,052,507.97- 100.206 2,158.97 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 629.50- 3,238.21 -55.831 9,038.21- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 71.70- 703.06- 93.741 46.94- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 481.81- 4,118.37- 91.519 381.63- Subtotal: 1,318,183.00- 1,314,183.00- 4,045.80- 1,308,757.66- 99.587 5,425.34- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 4,800.00- 80.000 1,200.00- Subtotal: 6,000.00- 6,000.00- 400.00- 4,800.00- 80.000 1,200.00- 122-43400-000-000 Fire Inspections 500.00- 675.00- 75.00- 975.00- 144.444 300.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,500.00- 10,675.00- 75.00- 10,975.00- 102.810 300.00 122-49035-000-000 Prior Year Reserves 5,413.00- 5,413.00- 122-49900-000-000 Miscellaneous Income 1,200.00- 5,200.00- 925.00- 7,314.26- 140.659 2,114.26 122-49903-000-000 Recovery of Prior Year Expense 4,340.96- 4,340.96 Subtotal: 1,200.00- 10,613.00- 925.00- 11,655.22- 109.820 1,042.22 Program number: 1,335,883.00- 1,341,471.00- 5,445.80- 1,336,187.88- 99.606 5,283.12- Department number: Fire Revenues 1,335,883.00- 1,341,471.00- 5,445.80- 1,336,187.88- 99.606 5,283.12- Revenues Subtotal ----------- 1,335,883.00- 1,341,471.00- 5,445.80- 1,336,187.88- 99.606 5,283.12- . glbase_tbam tsisk Trophy Club MUD #1 Page 2 15:26 07/09/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 444,717.00 444,717.00 34,336.67 311,183.43 69.973 133,533.57 122-50010-045-000 Overtime 31,375.00 37,076.00 2,616.78 29,663.32 80.007 7,412.68 122-50011-045-000 DPS Holiday Pay 13,083.00 12,083.00 12,080.51 99.979 2.49 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.11 100.003 .11- 122-50017-045-000 Certification 4,896.00 6,024.00 314.25 3,956.59 65.680 2,067.41 122-50020-045-000 Retirement 69,242.00 69,242.00 5,036.85 50,996.59 73.650 18,245.41 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,458.94 31,130.03 64.415 17,196.97 122-50027-045-000 Dental Insurance 3,635.00 3,836.00 317.56 2,881.33 75.113 954.67 122-50028-045-000 Vision Insurance 824.00 824.00 66.67 594.91 72.198 229.09 122-50029-045-000 Life Insurance & Other 4,250.00 5,974.00 414.27 4,503.96 75.393 1,470.04 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,128.30 21,417.59 69.319 9,479.41 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 497.76 5,008.91 69.318 2,217.09 122-50040-045-000 Unemployment Taxes 1,481.00 1,980.00 1.44 134.39 6.787 1,845.61 122-50045-045-000 Workman's Compensation 10,000.00 10,000.00 10,274.65 102.747 274.65- 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 283.05 41.933 391.95 122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 Subtotal: 676,394.00 684,647.00 49,189.49 488,375.37 71.332 196,271.63 122-55045-045-000 Legal 5,000.00 1,048.32 3,055.72 61.114 1,944.28 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 477.00 7,240.00 75.716 2,322.00 122-55090-045-000 Vehicle Maintenance 14,850.00 14,600.00 2,726.89 5,177.43 35.462 9,422.57 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 6,518.15 66.457 3,289.85 122-55100-045-000 Building Maintenance 6,500.00 5,500.00 240.00- 2,967.01 53.946 2,532.99 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 451.30 40.916 651.70 122-55160-045-000 Professional Outside Services 2,500.00 Subtotal: 44,323.00 45,573.00 4,012.21 25,409.61 55.756 20,163.39 122-60005-045-000 Telephone 106.00 106.00 49.78 46.962 56.22 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 3,500.00 214.76 3,080.84 88.024 419.16 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 1,151.74 5,839.55 94.690 327.45 122-60025-045-000 Water 1,400.00 1,400.00 114.99- 910.68 65.049 489.32 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 100.00 100.00 41.20 41.200 58.80 122-60055-045-000 Insurance 10,000.00 10,000.00 10,000.00 100.000 122-60066-045-000 Publications/Books/Subscrips 410.00 410.00 410.00 122-60070-045-000 Dues & Memberships 7,500.00 8,000.00 7,955.91 99.449 44.09 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 85.00 2,697.50 53.950 2,302.50 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 4,800.00 4,800.00 2,789.19 58.108 2,010.81 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 150.00 150.00 122.35 81.567 27.65 . glbase_tbam tsisk Trophy Club MUD #1 Page 3 15:26 07/09/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60160-045-000 Programs & Special Projects 4,200.00 4,200.00 2,415.66 57.516 1,784.34 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 2,150.00 1,391.40 2,381.92 110.787 231.92- 122-60195-045-000 Flags & Repair 2,543.00 2,293.00 475.67 1,557.92 67.942 735.08 122-60243-045-000 Prior Year Expense 2,088.00 2,088.44 100.021 .44- 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 584.51 47.252 652.49 Subtotal: 359,088.00 362,676.00 3,203.58 351,515.45 96.923 11,160.55 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 700.78 5,065.36 50.654 4,934.64 122-65010-045-000 Uniforms 4,357.00 3,357.00 1,739.32 51.812 1,617.68 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 340.00 6,745.00 88.750 855.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 420.00 822.00 82.200 178.00 122-65035-045-000 Small Tools 5,000.00 2,400.00 181.80 1,799.93 74.997 600.07 122-65085-045-000 Office Supplies 1,200.00 1,200.00 52.77 359.38 29.948 840.62 122-65095-045-000 Maintenance Supplies 2,785.00 1,988.00 1,259.35 63.348 728.65 122-65105-045-000 Printing 106.00 Subtotal: 32,048.00 27,545.00 1,695.35 17,790.34 64.586 9,754.66 122-69006-045-000 Grant Match 3,000.00 122-69008-045-000 Short Term Debt-Principal 72,932.00 72,932.00 2,966.05 4.067 69,965.95 122-69050-045-000 Radios 2,500.00 2,500.00 353.13 14.125 2,146.87 122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 41,890.00 28.771 103,708.00 Subtotal: 224,030.00 221,030.00 45,209.18 20.454 175,820.82 Program number: 1,335,883.00 1,341,471.00 58,100.63 928,299.95 69.200 413,171.05 Department number: Fire 1,335,883.00 1,341,471.00 58,100.63 928,299.95 69.200 413,171.05 Expenditures Subtotal ----------- 1,335,883.00 1,341,471.00 58,100.63 928,299.95 69.200 413,171.05 Fund number: 122 Trophy Club MUD Fire Dept. 52,654.83 407,887.93- 407,887.93 . glpdatb2 tsisk Trophy Club MUD #1 Page 1 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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 1795 06/17/2013 Property Taxes/Assessments (254,078.19) (88.21) (254,166.40) GL 1796 06/18/2013 Property Taxes/Assessments (44.09) (254,210.49) GL 1797 06/19/2013 Property Taxes/Assessments (389.77) (254,600.26) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (522.07) (254,600.26) ** (252,084.00) Budgeted 2,516.26 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (66.21) .00 (66.21) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (66.21) ** (700.00) Budgeted (633.79) Remaining 9 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1788 06/03/2013 Property Taxes/Assessments (1,050,167.25) (85.33) (1,050,252.58) GL 1789 06/04/2013 Property Taxes/Assessments (.23) (1,050,252.81) GL 1790 06/05/2013 Property Taxes/Assessments (155.70) (1,050,408.51) GL 1791 06/06/2013 Property Taxes/Assessments (166.55) (1,050,575.06) GL 1792 06/07/2013 Property Taxes/Assessments (634.74) (1,051,209.80) GL 1794 06/11/2013 Property Taxes/Assessments (391.33) (1,051,601.13) GL 1795 06/17/2013 Property Taxes/Assessments (168.84) (1,051,769.97) GL 1798 06/21/2013 Property Taxes/Assessments (177.18) (1,051,947.15) GL 1799 06/24/2013 Property Taxes/Assessments (37.83) (1,051,984.98) GL 1800 06/25/2013 Property Taxes/Assessments (85.33) (1,052,070.31) GL 1801 06/26/2013 Property Taxes/Assessments (348.80) (1,052,419.11) GL 1823 06/27/2013 Property Taxes/Assessments (9.29) (1,052,428.40) GL 1822 06/28/2013 Property Taxes/Assessments (79.57) (1,052,507.97) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (2,340.72) (1,052,507.97) ** (1,050,349.00) Budgeted 2,158.97 Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1793 06/10/2013 Property Taxes/Assessments 3,867.71 (118.79) 3,748.92 GL 1794 06/11/2013 Property Taxes/Assessments (510.71) 3,238.21 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (629.50) 3,238.21 ** (5,800.00) Budgeted (9,038.21) Remaining -56 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I . glpdatb2 tsisk Trophy Club MUD #1 Page 2 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1795 06/17/2013 Property Taxes/Assessments (631.36) (13.23) (644.59) GL 1797 06/19/2013 Property Taxes/Assessments (58.47) (703.06) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (71.70) (703.06) ** (750.00) Budgeted (46.94) Remaining 94 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1789 06/04/2013 Property Taxes/Assessments (3,636.56) (.03) (3,636.59) GL 1791 06/06/2013 Property Taxes/Assessments (24.99) (3,661.58) GL 1792 06/07/2013 Property Taxes/Assessments (59.38) (3,720.96) GL 1793 06/10/2013 Property Taxes/Assessments (34.44) (3,755.40) GL 1794 06/11/2013 Property Taxes/Assessments (244.61) (4,000.01) GL 1795 06/17/2013 Property Taxes/Assessments (12.66) (4,012.67) GL 1798 06/21/2013 Property Taxes/Assessments (26.58) (4,039.25) GL 1800 06/25/2013 Property Taxes/Assessments (13.47) (4,052.72) GL 1801 06/26/2013 Property Taxes/Assessments (52.32) (4,105.04) GL 1823 06/27/2013 Property Taxes/Assessments (1.39) (4,106.43) GL 1822 06/28/2013 Property Taxes/Assessments (11.94) (4,118.37) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (481.81) (4,118.37) ** (4,500.00) Budgeted (381.63) Remaining 92 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (4,400.00) (400.00) (4,800.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (4,800.00) ** (6,000.00) Budgeted (1,200.00) Remaining 80 % Used Account: 122-43400-000-000 Fire Inspections 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (900.00) (75.00) (975.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (975.00) ** (675.00) Budgeted 300.00 Remaining 144 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 3 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (5,413.00) Budgeted (5,413.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (6,389.26) (925.00) (7,314.26) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (925.00) (7,314.26) ** (5,200.00) Budgeted 2,114.26 Remaining 141 % Used Account: 122-49903-000-000 Recovery of Prior Year Expense (4,340.96) .00 (4,340.96) _______________ Account: 122-49903-000-000 Recovery of Prior Year Expense Totals: .00 (4,340.96) ** .00 Budgeted 4,340.96 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,336,187.88) ** (1,341,471.00) Budgeted (5,283.12) Remaining 100 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 4 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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 1662 06/07/2013 Fire Payroll 6/7/13 276,846.76 17,448.69 294,295.45 GL 1726 06/21/2013 FD Payroll 6/21/13 16,887.98 311,183.43 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 34,336.67 311,183.43 ** 444,717.00 Budgeted 133,533.57 Remaining 70 % Used Account: 122-50010-045-000 Overtime 1662 06/07/2013 Fire Payroll 6/7/13 27,046.54 2,616.78 29,663.32 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,616.78 29,663.32 ** 37,076.00 Budgeted 7,412.68 Remaining 80 % Used Account: 122-50011-045-000 DPS Holiday Pay 12,080.51 .00 12,080.51 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 12,080.51 ** 12,083.00 Budgeted 2.49 Remaining 100 % Used Account: 122-50016-045-000 Longevity 4,266.11 .00 4,266.11 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,266.11 ** 4,266.00 Budgeted (.11) Remaining 100 % Used Account: 122-50017-045-000 Certification 1662 06/07/2013 Fire Payroll 6/7/13 3,642.34 314.25 3,956.59 GL _______________ Account: 122-50017-045-000 Certification Totals: 314.25 3,956.59 ** 6,024.00 Budgeted 2,067.41 Remaining 66 % Used Account: 122-50020-045-000 Retirement 1662 06/07/2013 Fire Payroll 6/7/13 45,959.74 2,758.52 48,718.26 GL 1726 06/21/2013 FD Payroll 6/21/13 2,278.33 50,996.59 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,036.85 50,996.59 ** 69,242.00 Budgeted 18,245.41 Remaining 74 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 5 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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 1662 06/07/2013 Fire Payroll 6/7/13 27,671.09 1,729.45 29,400.54 GL 1726 06/21/2013 FD Payroll 6/21/13 1,729.49 31,130.03 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,458.94 31,130.03 ** 48,327.00 Budgeted 17,196.97 Remaining 64 % Used Account: 122-50027-045-000 Dental Insurance 1662 06/07/2013 Fire Payroll 6/7/13 2,563.77 158.75 2,722.52 GL 1726 06/21/2013 FD Payroll 6/21/13 158.81 2,881.33 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 317.56 2,881.33 ** 3,836.00 Budgeted 954.67 Remaining 75 % Used Account: 122-50028-045-000 Vision Insurance 1662 06/07/2013 Fire Payroll 6/7/13 528.24 33.33 561.57 GL 1726 06/21/2013 FD Payroll 6/21/13 33.34 594.91 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 66.67 594.91 ** 824.00 Budgeted 229.09 Remaining 72 % Used Account: 122-50029-045-000 Life Insurance & Other 1662 06/07/2013 Fire Payroll 6/7/13 4,089.69 207.16 4,296.85 GL 1726 06/21/2013 FD Payroll 6/21/13 207.11 4,503.96 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 414.27 4,503.96 ** 5,974.00 Budgeted 1,470.04 Remaining 75 % Used Account: 122-50030-045-000 Social Security Taxes 1662 06/07/2013 Fire Payroll 6/7/13 19,289.29 1,172.39 20,461.68 GL 1726 06/21/2013 FD Payroll 6/21/13 955.91 21,417.59 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,128.30 21,417.59 ** 30,897.00 Budgeted 9,479.41 Remaining 69 % Used Account: 122-50035-045-000 Medicare Taxes 1662 06/07/2013 Fire Payroll 6/7/13 4,511.15 274.21 4,785.36 GL 1726 06/21/2013 FD Payroll 6/21/13 223.55 5,008.91 GL . glpdatb2 tsisk Trophy Club MUD #1 Page 6 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-50035-045-000 Medicare Taxes Totals: 497.76 5,008.91 ** 7,226.00 Budgeted 2,217.09 Remaining 69 % Used Account: 122-50040-045-000 Unemployment Taxes 1662 06/07/2013 Fire Payroll 6/7/13 132.95 .76 133.71 GL 1726 06/21/2013 FD Payroll 6/21/13 .68 134.39 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 1.44 134.39 ** 1,980.00 Budgeted 1,845.61 Remaining 7 % Used Account: 122-50045-045-000 Workman's Compensation 10,274.65 .00 10,274.65 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 10,274.65 ** 10,000.00 Budgeted (274.65) Remaining 103 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 283.05 .00 283.05 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 283.05 ** 675.00 Budgeted 391.95 Remaining 42 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55045-045-000 Legal 1833 06/01/2013 Recode Whitaker Inv to Fire Whitaker May Legal 2,007.40 1,048.32 3,055.72 GL _______________ Account: 122-55045-045-000 Legal Totals: 1,048.32 3,055.72 ** 5,000.00 Budgeted 1,944.28 Remaining 61 % Used Account: 122-55080-045-000 Maintenance & Repairs 1776 06/27/2013 June A/P SCBA repairs 6,763.00 477.00 7,240.00 MUNICIPAL EMERGENCY SERVICES 32725 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 7 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-55080-045-000 Maintenance & Repairs Totals: 477.00 7,240.00 ** 9,562.00 Budgeted 2,322.00 Remaining 76 % Used Account: 122-55090-045-000 Vehicle Maintenance 1776 06/27/2013 June A/P vehicle maintenance for E-681 2,450.54 2,726.89 5,177.43 SIDDONS-MARTIN EMERGENCY GROUP 32731 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 2,726.89 5,177.43 ** 14,600.00 Budgeted 9,422.57 Remaining 35 % Used Account: 122-55095-045-000 Equipment Maintenance 6,518.15 .00 6,518.15 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 6,518.15 ** 9,808.00 Budgeted 3,289.85 Remaining 66 % Used Account: 122-55100-045-000 Building Maintenance 1787 06/20/2013 Firefighter cable, Jun-Jul 3,207.01 (240.00) 2,967.01 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: (240.00) 2,967.01 ** 5,500.00 Budgeted 2,532.99 Remaining 54 % Used Account: 122-55110-045-000 Maintenance-Radios 451.30 .00 451.30 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 451.30 ** 1,103.00 Budgeted 651.70 Remaining 41 % Used Account: 122-60005-045-000 Telephone 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards 49.78 (4.49) 45.29 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1683 06/11/2013 June A/P May IT PCards 4.49 49.78 TOWN OF TROPHY CLUB 32691 AP _______________ Account: 122-60005-045-000 Telephone Totals: .00 49.78 ** 106.00 Budgeted 56.22 Remaining 47 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1662 06/07/2013 Fire Payroll 6/7/13 2,866.08 75.42 2,941.50 GL . glpdatb2 tsisk Trophy Club MUD #1 Page 8 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1776 06/27/2013 June A/P Verizon Inv# 9705375788 2,866.08 139.34 3,080.84 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 214.76 3,080.84 ** 3,500.00 Budgeted 419.16 Remaining 88 % Used Account: 122-60020-045-000 Electricity/Gas 1776 06/27/2013 June A/P elec 5/14-6/13 4,687.81 1,117.30 5,805.11 HUDSON ENERGY SERVICES, LLC 32713 AP 1777 06/27/2013 June A/P Gas/Fire Station 5/18-6/19 68.87 5,873.98 ATMOS ENERGY 32697 AP 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (34.43) 5,839.55 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 1,151.74 5,839.55 ** 6,167.00 Budgeted 327.45 Remaining 95 % Used Account: 122-60025-045-000 Water 1682 06/11/2013 Void A/P ck 32687/wrong vendor May water bills 1,025.67 (162.12) 863.55 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1682 06/11/2013 Void A/P ck 32687/wrong vendor May water bills (67.86) 795.69 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1683 06/11/2013 June A/P May Water 162.12 957.81 TROPHY CLUB MUD (WATER BILLS) 32692 AP 1683 06/11/2013 June A/P May Water 67.86 1,025.67 TROPHY CLUB MUD (WATER BILLS) 32692 AP 1704 06/14/2013 Town Billed Inv 1041-1045 AR 20130614-20130614 User: (114.99) 910.68 AR _______________ Account: 122-60025-045-000 Water Totals: (114.99) 910.68 ** 1,400.00 Budgeted 489.32 Remaining 65 % Used Account: 122-60030-045-000 Rent And/Or Usage 308,000.00 .00 308,000.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 41.20 .00 41.20 _______________ Account: 122-60035-045-000 Postage Totals: .00 41.20 ** 100.00 Budgeted 58.80 Remaining 41 % Used Account: 122-60055-045-000 Insurance 10,000.00 .00 10,000.00 . glpdatb2 tsisk Trophy Club MUD #1 Page 9 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-60055-045-000 Insurance Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 410.00 Budgeted 410.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 7,955.91 .00 7,955.91 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 7,955.91 ** 8,000.00 Budgeted 44.09 Remaining 99 % Used Account: 122-60075-045-000 Meetings .00 .00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 .00 ** 75.00 Budgeted 75.00 Remaining 0 % Used Account: 122-60080-045-000 Schools & Training 1776 06/27/2013 June A/P Fire Officer certification 2,612.50 85.00 2,697.50 TX COMM ON FIRE PROTECTION 32740 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 2,697.50 ** 5,000.00 Budgeted 2,302.50 Remaining 54 % 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 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 2,789.19 .00 2,789.19 . glpdatb2 tsisk Trophy Club MUD #1 Page 10 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-60100-045-000 Travel & per diem Totals: .00 2,789.19 ** 4,800.00 Budgeted 2,010.81 Remaining 58 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 122.35 .00 122.35 _______________ Account: 122-60125-045-000 Advertising Totals: .00 122.35 ** 150.00 Budgeted 27.65 Remaining 82 % Used Account: 122-60160-045-000 Programs & Special Projects 2,415.66 .00 2,415.66 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 2,415.66 ** 4,200.00 Budgeted 1,784.34 Remaining 58 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 1776 06/27/2013 June A/P Fire inspections/Enforcement 990.52 1,391.40 2,381.92 MILLER UNIFORMS & EMBLEMS 32724 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 1,391.40 2,381.92 ** 2,150.00 Budgeted (231.92) Remaining 111 % Used Account: 122-60195-045-000 Flags & Repair 1776 06/27/2013 June A/P Town Billing 1,082.25 149.87 1,232.12 TOWN OF TROPHY CLUB 32738 AP 1776 06/27/2013 June A/P flags & repair 325.80 1,557.92 SYMONDS FLAGS & POLES 32733 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 475.67 1,557.92 ** 2,293.00 Budgeted 735.08 Remaining 68 % Used Account: 122-60243-045-000 Prior Year Expense 2,088.44 .00 2,088.44 . glpdatb2 tsisk Trophy Club MUD #1 Page 11 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-60243-045-000 Prior Year Expense Totals: .00 2,088.44 ** 2,088.00 Budgeted (.44) Remaining 100 % Used Account: 122-60245-045-000 Miscellaneous Expense 584.51 .00 584.51 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 584.51 ** 1,237.00 Budgeted 652.49 Remaining 47 % Used Account: 122-65005-045-000 Fuel & Lube 1834 06/30/2013 June gas log 4,364.58 700.78 5,065.36 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 700.78 5,065.36 ** 10,000.00 Budgeted 4,934.64 Remaining 51 % Used Account: 122-65010-045-000 Uniforms 1,739.32 .00 1,739.32 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 1,739.32 ** 3,357.00 Budgeted 1,617.68 Remaining 52 % Used Account: 122-65015-045-000 Protective Clothing 1777 06/27/2013 June A/P PPE Boots for Matt Tackett 6,405.00 340.00 6,745.00 CASCO INDUSTRIES INC 32701 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 340.00 6,745.00 ** 7,600.00 Budgeted 855.00 Remaining 89 % Used Account: 122-65030-045-000 Chemicals 1777 06/27/2013 June A/P Foam for E-681 402.00 420.00 822.00 CASCO INDUSTRIES INC 32701 AP _______________ Account: 122-65030-045-000 Chemicals Totals: 420.00 822.00 ** 1,000.00 Budgeted 178.00 Remaining 82 % Used Account: 122-65035-045-000 Small Tools 1777 06/27/2013 June A/P Batteries for equipment and fl 1,618.13 181.80 1,799.93 MUNICIPAL EMERGENCY SERVICES 32725 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 12 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-65035-045-000 Small Tools Totals: 181.80 1,799.93 ** 2,400.00 Budgeted 600.07 Remaining 75 % Used Account: 122-65085-045-000 Office Supplies 1777 06/27/2013 June A/P Office supplies 306.61 52.77 359.38 OFFICE DEPOT, INC 32726 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 52.77 359.38 ** 1,200.00 Budgeted 840.62 Remaining 30 % Used Account: 122-65095-045-000 Maintenance Supplies 1,259.35 .00 1,259.35 _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: .00 1,259.35 ** 1,988.00 Budgeted 728.65 Remaining 63 % Used Account: 122-69008-045-000 Short Term Debt-Principal 2,966.05 .00 2,966.05 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 2,966.05 ** 72,932.00 Budgeted 69,965.95 Remaining 4 % Used Account: 122-69050-045-000 Radios 353.13 .00 353.13 _______________ Account: 122-69050-045-000 Radios Totals: .00 353.13 ** 2,500.00 Budgeted 2,146.87 Remaining 14 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 41,890.00 .00 41,890.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 41,890.00 ** 145,598.00 Budgeted 103,708.00 Remaining 29 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 928,299.95 ** 1,341,471.00 Budgeted 413,171.05 Remaining 69 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 13 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (407,887.93) .00 Budgeted 407,887.93 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JUNE 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 6/30/13 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 807,767 - - 807,767 INVESTMENTS 2,207,609 313,050 395,824 2,916,484 PREPAID EXPENSES (1,354) - - (1,354) ADVALOREM PROPERTY TAXES RECEIVABLE 2,335 - - 2,335 UTILITY AND OTHER ACCOUNTS RECEIVABLE 714,036 - - 714,036 - TOTAL ASSETS 3,730,993 313,050 395,824 4,439,868 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,335 - - 2,335 ACCOUNTS AND OTHER PAYABLES 324,457 - 27,951 352,407 CUSTOMER DEPOSITS 230,472 - - 230,472 - TOTAL LIABILITIES 557,263 - 27,951 585,214 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 214,249 214,249 ASSIGNED FUND BALANCE 456,156 456,156 UNASSIGNED FUND BALANCE 2,825,965 - 38,101 2,864,066 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (108,391) 98,801 329,772 320,182 - TOTAL FUND BALANCE 3,173,730 313,050 367,874 3,854,653 - TOTAL LIABILITIES AND FUND BALANCE 3,730,993 313,050 395,824 4,439,868 . glbase_tbam tsisk Trophy Club MUD #1 Page 4 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,884.00- 99,884.00- 222.60- 100,089.44- 100.206 205.44 135-40002-000-000 Property Taxes/Delinquent 500.00- 624.00- 54.47- 316.71 -50.755 940.71- 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 48.50- 805.81- 67.151 394.19- Subtotal: 101,584.00- 101,708.00- 325.57- 100,578.54- 98.890 1,129.46- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 317,305.99- 2,097,483.70- 59.157 1,448,125.30- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 172,341.68- 1,282,331.87- 77.541 371,415.13- 135-47020-000-000 Standby 576.00- 576.00- 149.90- 26.024 426.10- 135-47025-000-000 Penalties 64,580.00- 64,580.00- 7,295.72- 41,514.16- 64.283 23,065.84- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 1,100.54- 9,233.36- 79.427 2,391.64- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 250.00- 950.00- 52.778 850.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 750.00- 3,300.00- 63.462 1,900.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 11,116.00- 31,892.09- 41.111 45,682.91- 135-47400-000-000 Water-Out of Dist/Port Meters 100.00- 100.00- 100.00 Subtotal: 5,360,712.00- 5,360,712.00- 510,259.93- 3,466,955.08- 64.673 1,893,756.92- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 50,600.00- 397,900.00- 61.786 246,100.00- Subtotal: 644,000.00- 644,000.00- 50,600.00- 397,900.00- 61.786 246,100.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 229.09- 3,613.19- 65.694 1,886.81- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 8,131.24- 80.000 2,032.76- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,249.97- 75.000 1,750.03- 135-49030-000-000 Vending Revenue 350.00- 350.00- 317.46- 90.703 32.54- 135-49035-000-000 Prior Year Reserves 305,748.00- 234,014.00- 234,014.00- 135-49075-000-000 Oversize Meter Reimbursement 73,000.00- 73,000.00- 8,559.00- 63,194.69- 86.568 9,805.31- 135-49141-000-000 Interfund Trans In (Cap Proj) 38,101.00- 38,101.42- 100.001 .42 135-49900-000-000 Miscellaneous Income 1,000.00- 13,213.00- 125.00- 14,972.88- 113.319 1,759.88 135-49901-000-000 Records Management Revenue 109.00- 59.20- 90.50- 83.028 18.50- 135-49903-000-000 Recovery of Prior Year Expense 11,789.33- 11,789.33 135-49905-000-000 Gas Well Revenue 200.00- 286.00- 117.64- 663.35- 231.941 377.35 Subtotal: 402,962.00- 381,737.00- 10,583.79- 146,124.03- 38.279 235,612.97- Program number: 6,509,258.00- 6,488,157.00- 571,769.29- 4,111,557.65- 63.370 2,376,599.35- Department number: Revenues 6,509,258.00- 6,488,157.00- 571,769.29- 4,111,557.65- 63.370 2,376,599.35- Revenues Subtotal ----------- 6,509,258.00- 6,488,157.00- 571,769.29- 4,111,557.65- 63.370 2,376,599.35- . glbase_tbam tsisk Trophy Club MUD #1 Page 5 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 213,321.00 213,321.00 12,738.64 120,323.18 56.405 92,997.82 135-50010-010-000 Overtime 13,250.00 19,250.00 1,015.74 10,043.27 52.173 9,206.73 135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 350.00 3,350.00 65.686 1,750.00 135-50020-010-000 Retirement 32,725.00 57,748.00 1,266.58 40,472.75 70.085 17,275.25 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 1,849.72 17,471.28 60.412 11,448.72 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 130.06 1,255.95 60.065 835.05 135-50028-010-000 Vision Insurance 519.00 519.00 29.52 294.23 56.692 224.77 135-50029-010-000 Life Insurance & Other 1,204.00 1,532.00 90.06 1,036.43 67.652 495.57 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 859.51 8,562.86 58.831 5,992.14 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 201.01 2,002.60 58.831 1,401.40 135-50040-010-000 Unemployment Taxes 945.00 945.00 .67 45.68 4.834 899.32 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 3,760.65 61.559 2,348.35 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 73.00 166.95 83.475 33.05 135-50070-010-000 Employee Relations 350.00 350.00 111.51 31.860 238.49 Subtotal: 325,773.00 357,124.00 18,604.51 211,977.34 59.357 145,146.66 135-55005-010-000 Engineering 3,000.00 2,000.00 2,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 1,840.21 25,312.28 50.625 24,687.72 135-55090-010-000 Vehicle Maintenance 3,700.00 4,650.00 43.16 3,680.90 79.159 969.10 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 1,767.04 60.932 1,132.96 135-55135-010-000 Lab Analysis 4,500.00 5,384.00 546.40 4,300.21 79.870 1,083.79 Subtotal: 64,100.00 64,934.00 2,429.77 35,060.43 53.994 29,873.57 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 139.59 1,193.55 59.678 806.45 135-60020-010-000 Electricity 162,410.00 162,410.00 15,633.75 80,769.08 49.732 81,640.92 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 100.000 135-60080-010-000 Schools & Training 1,672.00 1,472.00 351.00 23.845 1,121.00 135-60090-010-000 Safety Program 500.00 400.00 400.00 135-60100-010-000 Travel & per diem 700.00 800.00 551.69 68.961 248.31 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 24.00 4.800 476.00 135-60125-010-000 Advertising 150.00 300.00 300.00- 135-60135-010-000 TCEQ Fees & Permits 35,800.00 42,743.00 43,293.75 101.289 550.75- 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 830,521.44 40.944 1,197,925.56 135-60243-010-000 Prior Year Expense 756.00 756.00 100.000 135-60245-010-000 Miscellaneous Expenses 500.00 200.00 200.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 932.43 22.201 3,267.57 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 500.00 38.99 7.798 461.01 Subtotal: 2,239,129.00 2,245,328.00 15,929.34 958,881.93 42.706 1,286,446.07 . glbase_tbam tsisk Trophy Club MUD #1 Page 6 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 1,001.26 8,602.62 48.710 9,058.38 135-65010-010-000 Uniforms 2,680.00 2,680.00 1,617.82 60.366 1,062.18 135-65030-010-000 Chemicals 6,200.00 6,200.00 279.95 3,484.12 56.195 2,715.88 135-65035-010-000 Small Tools 1,500.00 1,500.00 267.19 17.813 1,232.81 135-65040-010-000 Safety Equipment 2,000.00 1,000.00 256.82 25.682 743.18 135-65050-010-000 Meter Expense 143,550.00 143,550.00 1,206.00 148,263.25 103.283 4,713.25- 135-65085-010-000 Office Supplies 109.68 109.68- Subtotal: 173,591.00 172,591.00 2,487.21 162,601.50 94.212 9,989.50 135-69005-010-000 Capital Expenses 181,800.00 8,000.00 1,094.96- -13.687 9,094.96 135-69008-010-000 Short Term Debt-Principal 387,037.00 366,000.00 366,000.00 135-69009-010-000 Short Term Debt-Interest 21,037.00 10,376.98 49.327 10,660.02 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 135-69280-010-000 Capital Repairs 270,000.00 60,000.00 59,869.00 99.782 131.00 135-69281-010-000 Capital Repair-Ground Storage 150,000.00 100,900.00 100,816.54 99.917 83.46 Subtotal: 1,018,837.00 585,937.00 199,967.56 34.128 385,969.44 Program number: 3,821,430.00 3,425,914.00 39,450.83 1,568,488.76 45.783 1,857,425.24 Department number: Water 3,821,430.00 3,425,914.00 39,450.83 1,568,488.76 45.783 1,857,425.24 . glbase_tbam tsisk Trophy Club MUD #1 Page 7 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 196,781.00 196,781.00 13,398.83 129,095.76 65.604 67,685.24 135-50010-020-000 Overtime 10,166.00 17,546.00 616.49 8,973.85 51.145 8,572.15 135-50016-020-000 Longevity 2,858.00 2,858.00 2,857.50 99.983 .50 135-50017-020-000 Certification 4,200.00 4,200.00 350.00 3,050.00 72.619 1,150.00 135-50020-020-000 Retirement 29,821.00 54,844.00 1,290.01 41,234.27 75.185 13,609.73 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 3,028.98 25,420.05 87.553 3,613.95 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 211.01 1,807.53 85.584 304.47 135-50028-020-000 Vision Insurance 552.00 552.00 45.54 437.80 79.312 114.20 135-50029-020-000 Life Insurance & Other 920.00 1,377.00 79.92 1,087.75 78.994 289.25 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 760.07 7,897.47 59.523 5,370.53 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 177.75 1,846.97 59.522 1,256.03 135-50040-020-000 Unemployment Taxes 756.00 756.00 45.41 6.007 710.59 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 5,960.27 202.799 3,021.27- 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 63.00 189.00 126.000 39.00- 135-50070-020-000 Employee Relations 350.00 350.00 91.23 26.066 258.77 Subtotal: 297,010.00 329,870.00 20,021.60 229,994.86 69.723 99,875.14 135-55070-020-000 Independent Labor 1,000.00 84,418.00 77,500.00 91.805 6,918.00 135-55080-020-000 Maintenance & Repairs 40,000.00 41,205.00 42,088.51 102.144 883.51- 135-55090-020-000 Vehicle Maintenance 2,000.00 3,350.00 4,517.96 134.864 1,167.96- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,080.96 72.064 419.04 135-55125-020-000 Dumpster Services 15,000.00 49,611.00 829.04 34,816.05 70.178 14,794.95 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,065.00 22,583.65 75.279 7,416.35 Subtotal: 89,500.00 210,084.00 2,894.04 182,587.13 86.911 27,496.87 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 3,981.00 233.86 1,642.19 41.251 2,338.81 135-60020-020-000 Electricity 153,045.00 153,045.00 10,495.71 94,721.12 61.891 58,323.88 135-60066-020-000 Publications/Books/Subscripts 500.00 200.00 161.45 80.725 38.55 135-60080-020-000 Schools & Training 3,272.00 3,272.00 1,071.66 32.752 2,200.34 135-60090-020-000 Safety Program 250.00 71.47 71.47- 135-60100-020-000 Travel & per diem 1,400.00 1,400.00 3,256.94 232.639 1,856.94- 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 1,123.00 74.867 377.00 135-60125-020-000 Advertising 2,000.00 300.00 112.50 37.500 187.50 135-60135-020-000 TCEQ Fees & Permits 56,000.00 15,600.00 7,887.19 50.559 7,712.81 135-60136-020-000 TCEQ Environmental Proj (SEP) 40,400.00 40,400.00 100.000 135-60243-020-000 Prior Year Expense 802.00 801.59 99.949 .41 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 202.10 101.050 2.10- 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 412.23 82.446 87.77 Subtotal: 221,367.00 221,200.00 10,729.57 151,863.44 68.654 69,336.56 135-65005-020-000 Fuel & Lube 8,527.00 10,527.00 964.54 8,097.49 76.921 2,429.51 . glbase_tbam tsisk Trophy Club MUD #1 Page 8 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-020-000 Uniforms 2,574.00 1,574.00 120.00 1,323.70 84.098 250.30 135-65030-020-000 Chemicals 10,000.00 38,346.00 22,790.90 59.435 15,555.10 135-65035-020-000 Small Tools 1,000.00 1,000.00 469.05 46.905 530.95 135-65040-020-000 Safety Equipment 250.00 500.00 25.63 552.33 110.466 52.33- 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 29.85 13,025.20 130.252 3,025.20- Subtotal: 32,351.00 61,947.00 1,140.02 46,258.67 74.675 15,688.33 135-69005-020-000 Capital Expenses 241,200.00 446,484.00 442,195.29 99.039 4,288.71 135-69280-020-000 Capital Repairs 158,000.00 Subtotal: 399,200.00 446,484.00 442,195.29 99.039 4,288.71 Program number: 1,039,428.00 1,269,585.00 34,785.23 1,052,899.39 82.933 216,685.61 Department number: Wastewater 1,039,428.00 1,269,585.00 34,785.23 1,052,899.39 82.933 216,685.61 . glbase_tbam tsisk Trophy Club MUD #1 Page 9 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 156,475.00 156,475.00 11,782.74 106,686.87 68.181 49,788.13 135-50010-021-000 Overtime 7,297.00 12,158.00 1,156.01 7,521.47 61.864 4,636.53 135-50016-021-000 Longevity 3,818.00 3,818.00 3,817.50 99.987 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 1,300.00 72.222 500.00 135-50020-021-000 Retirement 23,574.00 42,910.00 1,175.37 32,725.56 76.266 10,184.44 135-50026-021-000 Medical Insurance 20,198.00 25,940.00 2,321.55 18,978.54 73.163 6,961.46 135-50027-021-000 Dental Insurance 1,409.00 1,812.00 159.88 1,332.72 73.550 479.28 135-50028-021-000 Vision Insurance 357.00 383.00 32.60 284.72 74.339 98.28 135-50029-021-000 Life Insurance & Other 1,008.00 1,223.00 64.78 804.67 65.795 418.33 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 744.18 7,036.54 67.002 3,465.46 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 174.03 1,645.61 67.004 810.39 135-50040-021-000 Unemployment Taxes 567.00 567.00 34.39 6.065 532.61 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 4,896.88 146.263 1,548.88- 135-50070-021-000 Employee Relations 250.00 250.00 108.00 43.200 142.00 Subtotal: 233,059.00 263,642.00 17,761.14 187,173.47 70.995 76,468.53 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 20,000.00 1,500.00 17,462.78 87.314 2,537.22 135-55090-021-000 Vehicle Maintenance 1,900.00 1,600.00 61.65 1,405.88 87.868 194.12 Subtotal: 38,400.00 21,600.00 1,561.65 18,868.66 87.355 2,731.34 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 216.91 1,797.36 51.353 1,702.64 135-60020-021-000 Electricity 18,705.00 18,705.00 1,501.71 13,481.07 72.072 5,223.93 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 100.000 135-60080-021-000 Schools & Training 826.00 826.00 830.00 100.484 4.00- 135-60090-021-000 Safety Program 500.00 300.00 300.00 135-60100-021-000 Travel & per diem 450.00 450.00 2,092.93 465.096 1,642.93- 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60243-021-000 Prior Year Expense 621.00 620.83 99.973 .17 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 34,331.00 34,752.00 1,718.62 19,072.19 54.881 15,679.81 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 934.37 6,510.84 53.733 5,606.16 135-65010-021-000 Uniforms 2,220.00 2,220.00 934.13 42.078 1,285.87 135-65030-021-000 Chemicals 7,500.00 7,500.00 2,221.00 29.613 5,279.00 135-65035-021-000 Small Tools 1,500.00 1,250.00 70.00 5.600 1,180.00 135-65040-021-000 Safety Equipment 500.00 500.00 120.00 24.000 380.00 Subtotal: 23,837.00 23,587.00 934.37 9,855.97 41.786 13,731.03 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 15,276.00 16.973 74,724.00 . glbase_tbam tsisk Trophy Club MUD #1 Page 10 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69008-021-000 Short Term Debt-Principal 40,260.00 40,260.00 40,260.00 Subtotal: 130,260.00 130,260.00 15,276.00 11.727 114,984.00 Program number: 459,887.00 473,841.00 21,975.78 250,246.29 52.812 223,594.71 Department number: Collection 459,887.00 473,841.00 21,975.78 250,246.29 52.812 223,594.71 . glbase_tbam tsisk Trophy Club MUD #1 Page 11 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 400.00 7,500.00 75.000 2,500.00 135-50030-026-000 Social Security Taxes 620.00 620.00 24.80 465.00 75.000 155.00 135-50035-026-000 Medicare Taxes 145.00 145.00 5.80 108.75 75.000 36.25 135-50040-026-000 Unemployment Taxes 210.00 210.00 .40 66.30 31.571 143.70 135-50045-026-000 Workman's Compensation 150.00 150.00 7.88 5.253 142.12 Subtotal: 11,125.00 11,125.00 431.00 8,147.93 73.240 2,977.07 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 42.00 2.000 2,058.00 135-60075-026-000 Meetings 1,200.00 1,200.00 434.97 36.248 765.03 135-60080-026-000 Schools & Training 4,000.00 4,000.00 2,655.00 66.375 1,345.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,219.32 5,325.54 106.511 325.54- 135-60243-026-000 Prior Year Expense 107.10 107.10- 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 267.88 8.929 2,732.12 Subtotal: 15,450.00 15,450.00 1,219.32 8,832.49 57.168 6,617.51 Program number: 26,575.00 26,575.00 1,650.32 16,980.42 63.896 9,594.58 Department number: Board of Directors 26,575.00 26,575.00 1,650.32 16,980.42 63.896 9,594.58 . glbase_tbam tsisk Trophy Club MUD #1 Page 12 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 444,730.00 444,730.00 33,142.86 307,088.43 69.051 137,641.57 135-50010-030-000 Overtime 1,500.00 1,500.00 6.01 239.94 15.996 1,260.06 135-50016-030-000 Longevity 2,193.00 2,318.00 2,317.50 99.978 .50 135-50020-030-000 Retirement 60,441.00 104,801.00 2,976.77 78,319.47 74.732 26,481.53 135-50026-030-000 Medical Insurance 44,066.00 49,049.00 4,388.10 35,884.50 73.161 13,164.50 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 386.34 3,184.20 94.235 194.80 135-50028-030-000 Vision Insurance 795.00 945.00 82.53 693.70 73.407 251.30 135-50029-030-000 Life Insurance & Other 2,500.00 2,582.00 173.08 2,069.25 80.141 512.75 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,910.61 18,320.97 65.898 9,481.03 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 446.86 4,284.77 65.899 2,217.23 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 439.29 28.581 1,097.71 135-50045-030-000 Workman's Compensation 831.00 831.00 938.60 112.948 107.60- 135-50060-030-000 Pre-emp Physicals/Testing 250.00 250.00 39.00 15.600 211.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 2,739.99 54.800 2,260.01 Subtotal: 601,526.00 651,226.00 43,513.16 456,559.61 70.108 194,666.39 135-55030-030-000 Software & Support 63,555.00 63,555.00 3,046.80 51,758.74 81.439 11,796.26 135-55070-030-000 Independent Labor 2,700.00 7,700.00 86.87 685.62 8.904 7,014.38 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55080-030-000 Maintenance & Repairs 811.00 810.52 99.941 .48 135-55100-030-000 Building Maint & Supplies 5,000.00 6,500.00 67.02- 4,238.93 65.214 2,261.07 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,678.51 13,875.76 68.692 6,324.24 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 6,974.00 46.493 8,026.00 135-55161-030-000 Outside Services-Town Semo 85,465.00 85,465.00 85,465.00 100.000 135-55165-030-000 Collection Fees 160.00 159.77 99.856 .23 135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 747.57 5,106.06 46.419 5,893.94 Subtotal: 203,420.00 210,891.00 5,492.73 169,074.40 80.171 41,816.60 135-60005-030-000 Telephone 9,000.00 10,500.00 200.29 8,436.87 80.351 2,063.13 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 326.75 2,622.44 73.355 952.56 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 1,018.48 9,150.00 70.282 3,869.00 135-60025-030-000 Water 3,100.00 3,100.00 87.66- 652.80 21.058 2,447.20 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 9,886.59 75.001 3,295.41 135-60035-030-000 Postage 23,000.00 26,604.00 2,736.48 21,162.82 79.548 5,441.18 135-60040-030-000 Service Charges & Fees 18,000.00 28,330.00 2,503.29 20,869.19 73.665 7,460.81 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 915.96 1,001.40 11.781 7,498.60 135-60055-030-000 Insurance 35,000.00 50,694.00 200.00 50,943.77 100.493 249.77- 135-60066-030-000 Publications/Books/Subscripts 750.00 834.00 833.50 99.940 .50 135-60070-030-000 Dues & Memberships 2,400.00 3,892.00 300.00 4,191.95 107.707 299.95- 135-60075-030-000 Meetings 250.00 400.00 283.85 70.963 116.15 135-60080-030-000 Schools & Training 5,500.00 5,350.00 3,394.65 63.451 1,955.35 135-60100-030-000 Travel & per diem 3,950.00 3,616.00 30.09 3,727.10 103.072 111.10- . glbase_tbam tsisk Trophy Club MUD #1 Page 13 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60110-030-000 Physicals/Testing 500.00 500.00 500.00 135-60125-030-000 Advertising 4,000.00 4,000.00 525.50 1,418.90 35.473 2,581.10 135-60235-030-000 Security 1,350.00 1,350.00 505.13 37.417 844.87 135-60243-030-000 Prior Year Expense 1,263.00 3,290.58 260.537 2,027.58- 135-60245-030-000 Miscellaneous Expenses 15,000.00 13,500.00 20.00 1,035.22 7.668 12,464.78 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,000.00 10,000.00 95.238 500.00 135-60281-030-000 Park Expenses 42,500.00 1,176.87 31,727.33 74.653 10,772.67 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 161,000.00 161,000.00- 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 3,537.76 141.510 1,037.76- Subtotal: 173,076.00 247,709.00 20,964.56 349,671.85 141.162 101,962.85- 135-65010-030-000 Uniforms 1,635.00 1,635.00 624.12 38.172 1,010.88 135-65055-030-000 Hardware 20,188.00 20,188.00 187.60 12,129.34 60.082 8,058.66 135-65085-030-000 Office Supplies 8,200.00 8,200.00 404.34 6,895.56 84.092 1,304.44 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 233.50 2,291.08 39.970 3,440.92 135-65095-030-000 Maintenance Supplies 2,000.00 1,500.00 103.53- 2,215.94 147.729 715.94- 135-65097-030-000 Vending Machine Supplies 500.00 500.00 50.32 10.064 449.68 135-65105-030-000 Printing 5,200.00 4,200.00 979.47 2,135.66 50.849 2,064.34 Subtotal: 43,455.00 41,955.00 1,701.38 26,342.02 62.786 15,612.98 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 513.70 2,311.65 67.004 1,138.35 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 100.000 Subtotal: 30,361.00 30,361.00 513.70 29,222.65 96.251 1,138.35 Program number: 1,051,838.00 1,182,142.00 72,185.53 1,030,870.53 87.204 151,271.47 Department number: Administration 1,051,838.00 1,182,142.00 72,185.53 1,030,870.53 87.204 151,271.47 . glbase_tbam tsisk Trophy Club MUD #1 Page 14 15:26 07/09/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 70,000.00 70,000.00 15,371.74 156,887.34 224.125 86,887.34- 135-55055-039-000 Auditing 21,200.00 21,200.00 20,700.00 97.642 500.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 1,943.16 8,152.22 53.988 6,947.78 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 34.17 2,390.56 62.909 1,409.44 Subtotal: 110,100.00 110,100.00 17,349.07 188,130.12 170.872 78,030.12- 135-60344-039-000 Intergov Trans Out (Fire CIP) 112,333.21 112,333.21- Subtotal: 112,333.21 112,333.21- Program number: 110,100.00 110,100.00 17,349.07 300,463.33 272.900 190,363.33- Department number: Non Departmental 110,100.00 110,100.00 17,349.07 300,463.33 272.900 190,363.33- Expenditures Subtotal ----------- 6,509,258.00 6,488,157.00 187,396.76 4,219,948.72 65.041 2,268,208.28 Fund number: 135 MUD 1 General Fund 384,372.53- 108,391.07 108,391.07- . glbase_tbam tsisk Trophy Club MUD #1 Page 15 15:26 07/09/13 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 56,911.00- 56,911.00 137-49146-000-000 Intergov Transfer-Fire Dept 41,890.00- 41,890.00 Subtotal: 98,801.00- 98,801.00 Program number: 98,801.00- 98,801.00 Department number: 98,801.00- 98,801.00 Revenues Subtotal ----------- 98,801.00- 98,801.00 Fund number: 137 MUD 1 Consolidated GASB 98,801.00- 98,801.00 . glbase_tbam tsisk Trophy Club MUD #1 Page 16 15:26 07/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49005-000-000 Loan Proceeds 445,000.00- 445,000.00- 100.000 507-49010-000-000 Interest Income 100.00- 18.76- 68.09- 68.090 31.91- Subtotal: 445,100.00- 18.76- 445,068.09- 99.993 31.91- Program number: 445,100.00- 18.76- 445,068.09- 99.993 31.91- Department number: 445,100.00- 18.76- 445,068.09- 99.993 31.91- Revenues Subtotal ----------- 445,100.00- 18.76- 445,068.09- 99.993 31.91- . glbase_tbam tsisk Trophy Club MUD #1 Page 17 15:26 07/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-010-001 Capital Expense 5,800.00 6,289.00 108.431 489.00- Subtotal: 5,800.00 6,289.00 108.431 489.00- Program number: 1 Security Cameras 5,800.00 6,289.00 108.431 489.00- . glbase_tbam tsisk Trophy Club MUD #1 Page 18 15:26 07/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs 165,000.00 787.50 16,733.50 10.142 148,266.50 Subtotal: 165,000.00 787.50 16,733.50 10.142 148,266.50 Program number: 2 Rate of Flow Control-FW Meter 165,000.00 787.50 16,733.50 10.142 148,266.50 . glbase_tbam tsisk Trophy Club MUD #1 Page 19 15:26 07/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Repairs 210,000.00 9,079.33 4.323 200,920.67 Subtotal: 210,000.00 9,079.33 4.323 200,920.67 Program number: 3 Indian Creek Waterline 210,000.00 9,079.33 4.323 200,920.67 Department number: Water 380,800.00 787.50 32,101.83 8.430 348,698.17 . glbase_tbam tsisk Trophy Club MUD #1 Page 20 15:26 07/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 38,101.42 38,101.42- Subtotal: 38,101.42 38,101.42- Program number: 38,101.42 38,101.42- . glbase_tbam tsisk Trophy Club MUD #1 Page 21 15:26 07/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 1 Security Cameras Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-001 Capital Expense 8,200.00 8,578.00 104.610 378.00- Subtotal: 8,200.00 8,578.00 104.610 378.00- Program number: 1 Security Cameras 8,200.00 8,578.00 104.610 378.00- . glbase_tbam tsisk Trophy Club MUD #1 Page 22 15:26 07/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 4 Sludge Blanket Level Indicator Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-004 Capital Expense 18,000.00 18,000.00 Subtotal: 18,000.00 18,000.00 Program number: 4 Sludge Blanket Level Indicator 18,000.00 18,000.00 . glbase_tbam tsisk Trophy Club MUD #1 Page 23 15:26 07/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 5 Portable Submersible Pump Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-005 Capital Expense 10,000.00 8,553.92 85.539 1,446.08 Subtotal: 10,000.00 8,553.92 85.539 1,446.08 Program number: 5 Portable Submersible Pump 10,000.00 8,553.92 85.539 1,446.08 . glbase_tbam tsisk Trophy Club MUD #1 Page 24 15:26 07/09/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 6 Waste Pump Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-020-006 Capital Repairs 28,000.00 27,960.70 99.860 39.30 Subtotal: 28,000.00 27,960.70 99.860 39.30 Program number: 6 Waste Pump 28,000.00 27,960.70 99.860 39.30 Department number: Wastewater 64,200.00 83,194.04 129.586 18,994.04- Expenditures Subtotal ----------- 445,000.00 787.50 115,295.87 25.909 329,704.13 Fund number: 507 MUD 1 Capital Projects 100.00- 768.74 329,772.22- ############### 329,672.22 . glpdatb2 tsisk Trophy Club MUD #1 Page 14 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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 1788 06/03/2013 Property Taxes/Assessments (99,866.84) (8.12) (99,874.96) GL 1789 06/04/2013 Property Taxes/Assessments (.02) (99,874.98) GL 1790 06/05/2013 Property Taxes/Assessments (14.81) (99,889.79) GL 1791 06/06/2013 Property Taxes/Assessments (15.84) (99,905.63) GL 1792 06/07/2013 Property Taxes/Assessments (60.36) (99,965.99) GL 1794 06/11/2013 Property Taxes/Assessments (37.21) (100,003.20) GL 1795 06/17/2013 Property Taxes/Assessments (16.06) (100,019.26) GL 1798 06/21/2013 Property Taxes/Assessments (16.85) (100,036.11) GL 1799 06/24/2013 Property Taxes/Assessments (3.60) (100,039.71) GL 1800 06/25/2013 Property Taxes/Assessments (8.11) (100,047.82) GL 1801 06/26/2013 Property Taxes/Assessments (33.17) (100,080.99) GL 1823 06/27/2013 Property Taxes/Assessments (.88) (100,081.87) GL 1822 06/28/2013 Property Taxes/Assessments (7.57) (100,089.44) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (222.60) (100,089.44) ** (99,884.00) Budgeted 205.44 Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1793 06/10/2013 Property Taxes/Assessments 371.18 (10.75) 360.43 GL 1794 06/11/2013 Property Taxes/Assessments (43.72) 316.71 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (54.47) 316.71 ** (624.00) Budgeted (940.71) Remaining -51 % Used Account: 135-40015-000-000 Property Taxes/P & I 1789 06/04/2013 Property Taxes/Assessments (757.31) (.01) (757.32) GL 1791 06/06/2013 Property Taxes/Assessments (2.37) (759.69) GL 1792 06/07/2013 Property Taxes/Assessments (5.65) (765.34) GL 1793 06/10/2013 Property Taxes/Assessments (3.12) (768.46) GL 1794 06/11/2013 Property Taxes/Assessments (21.41) (789.87) GL 1795 06/17/2013 Property Taxes/Assessments (1.20) (791.07) GL 1798 06/21/2013 Property Taxes/Assessments (2.53) (793.60) GL 1800 06/25/2013 Property Taxes/Assessments (1.29) (794.89) GL 1800 06/25/2013 Property Taxes/Assessments (4.67) (799.56) GL 1801 06/26/2013 Property Taxes/Assessments (4.98) (804.54) GL 1823 06/27/2013 Property Taxes/Assessments (.14) (804.68) GL 1822 06/28/2013 Property Taxes/Assessments (1.13) (805.81) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (48.50) (805.81) ** (1,200.00) Budgeted (394.19) Remaining 67 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 15 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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-47000-000-000 Water 1687 06/11/2013 UB 6/11/13 Adjustments UB20130611-20130611 User: (1,780,177.71) 25.42 (1,780,152.29) UB 1809 06/30/2013 UB 6/30/13 Billing UB20130630-20130630 User: (317,331.41) (2,097,483.70) UB _______________ Account: 135-47000-000-000 Water Totals: (317,305.99) (2,097,483.70) ** (3,545,609.00) Budgeted (1,448,125.30) Remaining 59 % Used Account: 135-47005-000-000 Sewer 1687 06/11/2013 UB 6/11/13 Adjustments UB20130611-20130611 User: (1,109,990.19) 25.42 (1,109,964.77) UB 1809 06/30/2013 UB 6/30/13 Billing UB20130630-20130630 User: (172,367.10) (1,282,331.87) UB _______________ Account: 135-47005-000-000 Sewer Totals: (172,341.68) (1,282,331.87) ** (1,653,747.00) Budgeted (371,415.13) Remaining 78 % Used Account: 135-47020-000-000 Standby (149.90) .00 (149.90) _______________ Account: 135-47020-000-000 Standby Totals: .00 (149.90) ** (576.00) Budgeted (426.10) Remaining 26 % Used Account: 135-47025-000-000 Penalties 1687 06/11/2013 UB 6/11/13 Adjustments UB20130611-20130611 User: (34,218.44) 4.63 (34,213.81) UB 1741 06/21/2013 UB 6/21/13 Penalties UB20130621-20130621 User: (7,013.62) (41,227.43) UB 1756 06/21/2013 UB 6/21/13 Adjustments UB20130621-20130621 User: 385.48 (40,841.95) UB 1770 06/26/2013 UB 6/26/13 Adjustments UB20130626-20130626 User: 14.76 (40,827.19) UB 1773 06/27/2013 UB 6/27/13 Adjustments UB20130627-20130627 User: 82.86 (40,744.33) UB 1778 06/28/2013 UB 6/28/13 Penalty Removals UB20130628-20130628 User: 217.10 (40,527.23) UB 1803 06/28/2013 UB 6/28/13 Penalty adj UB20130628-20130628 User: 30.28 (40,496.95) UB 1809 06/30/2013 UB 6/30/13 Billing UB20130630-20130630 User: (1,017.21) (41,514.16) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,295.72) (41,514.16) ** (64,580.00) Budgeted (23,065.84) Remaining 64 % Used Account: 135-47030-000-000 Service Charges 1633 06/05/2013 UB 6/5/13 Cut Off List UB20130605-20130605 User: (8,132.82) (750.00) (8,882.82) UB 1685 06/05/2013 UB 6/5/13 Adjustments UB20130605-20130605 User: (300.00) (9,182.82) UB 1751 06/11/2013 UB 6/11/13 Adjustment UB20130611-20130611 User: (25.00) (9,207.82) UB 1764 06/19/2013 UB 6/19/13 Adjustment UB20130619-20130619 User: (25.00) (9,232.82) UB 1809 06/30/2013 UB 6/30/13 Billing UB20130630-20130630 User: (.54) (9,233.36) UB . glpdatb2 tsisk Trophy Club MUD #1 Page 16 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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-47030-000-000 Service Charges Totals: (1,100.54) (9,233.36) ** (11,625.00) Budgeted (2,391.64) Remaining 79 % Used Account: 135-47035-000-000 Plumbing Inspections 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (700.00) (250.00) (950.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (950.00) ** (1,800.00) Budgeted (850.00) Remaining 53 % Used Account: 135-47045-000-000 Sewer Inspections 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (2,550.00) (750.00) (3,300.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (750.00) (3,300.00) ** (5,200.00) Budgeted (1,900.00) Remaining 63 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1809 06/30/2013 UB 6/30/13 Billing UB20130630-20130630 User: (20,776.09) (11,116.00) (31,892.09) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (11,116.00) (31,892.09) ** (77,575.00) Budgeted (45,682.91) Remaining 41 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 1766 06/24/2013 UB 6/24/13 Adjustment UB20130624-20130624 User: (100.00) (100.00) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (100.00) (100.00) ** .00 Budgeted 100.00 Remaining 0 % Used Account: 135-48005-000-000 Utility Fees 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (347,300.00) (50,600.00) (397,900.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (50,600.00) (397,900.00) ** (644,000.00) Budgeted (246,100.00) Remaining 62 % Used Account: 135-49010-000-000 Interest Income 1821 06/28/2013 Bank interest/June (3,384.10) (73.95) (3,458.05) GL 1821 06/28/2013 Bank interest/June (155.14) (3,613.19) GL . glpdatb2 tsisk Trophy Club MUD #1 Page 17 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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-49010-000-000 Interest Income Totals: (229.09) (3,613.19) ** (5,500.00) Budgeted (1,886.81) Remaining 66 % Used Account: 135-49016-000-000 Cell Tower Revenue 1784 06/14/2013 AT&T Antenna Lease (7,220.71) (910.53) (8,131.24) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (8,131.24) ** (10,164.00) Budgeted (2,032.76) Remaining 80 % Used Account: 135-49018-000-000 Building Rent Income 1657 06/06/2013 Town Invoices 1039-40 AR 20130606-20130606 User: (4,666.64) (583.33) (5,249.97) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,249.97) ** (7,000.00) Budgeted (1,750.03) Remaining 75 % Used Account: 135-49030-000-000 Vending Revenue (317.46) .00 (317.46) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (317.46) ** (350.00) Budgeted (32.54) Remaining 91 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (234,014.00) Budgeted (234,014.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (54,635.69) (8,559.00) (63,194.69) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (8,559.00) (63,194.69) ** (73,000.00) Budgeted (9,805.31) Remaining 87 % Used Account: 135-49141-000-000 Interfund Trans In (Cap Proj) (38,101.42) .00 (38,101.42) . glpdatb2 tsisk Trophy Club MUD #1 Page 18 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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-49141-000-000 Interfund Trans In (Cap Proj) Totals: .00 (38,101.42) ** (38,101.00) Budgeted .42 Remaining 100 % Used Account: 135-49900-000-000 Miscellaneous Income 1766 06/24/2013 UB 6/24/13 Adjustment UB20130624-20130624 User: (14,847.88) (50.00) (14,897.88) UB 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (75.00) (14,972.88) AR _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (125.00) (14,972.88) ** (13,213.00) Budgeted 1,759.88 Remaining 113 % Used Account: 135-49901-000-000 Records Management Revenue 1785 06/20/2013 B Newsom Open records (31.30) (59.20) (90.50) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (59.20) (90.50) ** (109.00) Budgeted (18.50) Remaining 83 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (11,789.33) .00 (11,789.33) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (11,789.33) ** .00 Budgeted 11,789.33 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue 1786 06/20/2013 Vantage Energy-Gas Well revenu (545.71) (117.64) (663.35) GL _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: (117.64) (663.35) ** (286.00) Budgeted 377.35 Remaining 232 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4,111,557.65) ** (6,488,157.00) Budgeted (2,376,599.35) Remaining 63 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 19 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 1642 06/07/2013 Payroll 6/7/13 Salaries & Wages 107,584.54 6,715.52 114,300.06 PR 1712 06/21/2013 Payroll 6/21/13 Salaries & Wages 6,023.12 120,323.18 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 12,738.64 120,323.18 ** 213,321.00 Budgeted 92,997.82 Remaining 56 % Used Account: 135-50010-010-000 Overtime 1642 06/07/2013 Payroll 6/7/13 Overtime 9,027.53 324.29 9,351.82 PR 1712 06/21/2013 Payroll 6/21/13 Overtime 691.45 10,043.27 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,015.74 10,043.27 ** 19,250.00 Budgeted 9,206.73 Remaining 52 % Used Account: 135-50016-010-000 Longevity 3,080.00 .00 3,080.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,080.00 ** 3,080.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1712 06/21/2013 Payroll 6/21/13 Certification 3,000.00 350.00 3,350.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 350.00 3,350.00 ** 5,100.00 Budgeted 1,750.00 Remaining 66 % Used Account: 135-50020-010-000 Retirement 1642 06/07/2013 Payroll 6/7/13 Retirement 39,206.17 632.18 39,838.35 PR 1712 06/21/2013 Payroll 6/21/13 Retirement 634.40 40,472.75 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,266.58 40,472.75 ** 57,748.00 Budgeted 17,275.25 Remaining 70 % Used Account: 135-50026-010-000 Medical Insurance 1642 06/07/2013 Payroll 6/7/13 Medical Insurance 15,621.56 1,057.00 16,678.56 PR 1712 06/21/2013 Payroll 6/21/13 Medical Insurance 792.72 17,471.28 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,849.72 17,471.28 ** 28,920.00 Budgeted 11,448.72 Remaining 60 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 20 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-010-000 Dental Insurance 1642 06/07/2013 Payroll 6/7/13 Dental Insurance 1,125.89 72.76 1,198.65 PR 1712 06/21/2013 Payroll 6/21/13 Dental Insurance 57.30 1,255.95 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 130.06 1,255.95 ** 2,091.00 Budgeted 835.05 Remaining 60 % Used Account: 135-50028-010-000 Vision Insurance 1642 06/07/2013 Payroll 6/7/13 Vision Insurance 264.71 16.96 281.67 PR 1712 06/21/2013 Payroll 6/21/13 Vision Insurance 12.56 294.23 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 29.52 294.23 ** 519.00 Budgeted 224.77 Remaining 57 % Used Account: 135-50029-010-000 Life Insurance & Other 1642 06/07/2013 Payroll 6/7/13 Life Insurance & Other 946.37 74.31 1,020.68 PR 1776 06/27/2013 June A/P Flex admin fee 15.75 1,036.43 Discovery Benefits 32707 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 90.06 1,036.43 ** 1,532.00 Budgeted 495.57 Remaining 68 % Used Account: 135-50030-010-000 Social Security Taxes 1642 06/07/2013 Payroll 6/7/13 Social Security Taxes 7,703.35 427.13 8,130.48 PR 1712 06/21/2013 Payroll 6/21/13 Social Security Taxes 432.38 8,562.86 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 859.51 8,562.86 ** 14,555.00 Budgeted 5,992.14 Remaining 59 % Used Account: 135-50035-010-000 Medicare Taxes 1642 06/07/2013 Payroll 6/7/13 Medicare Taxes 1,801.59 99.89 1,901.48 PR 1712 06/21/2013 Payroll 6/21/13 Medicare Taxes 101.12 2,002.60 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 201.01 2,002.60 ** 3,404.00 Budgeted 1,401.40 Remaining 59 % Used Account: 135-50040-010-000 Unemployment Taxes 1712 06/21/2013 Payroll 6/21/13 Unemployment Taxes 45.01 .67 45.68 PR . glpdatb2 tsisk Trophy Club MUD #1 Page 21 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-010-000 Unemployment Taxes Totals: .67 45.68 ** 945.00 Budgeted 899.32 Remaining 5 % Used Account: 135-50045-010-000 Workman's Compensation 3,760.65 .00 3,760.65 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 3,760.65 ** 6,109.00 Budgeted 2,348.35 Remaining 62 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1680 06/11/2013 June A/P Pre-employment physical-Clinto 93.95 73.00 166.95 CARENOW CORPORATE 32644 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 73.00 166.95 ** 200.00 Budgeted 33.05 Remaining 83 % Used Account: 135-50070-010-000 Employee Relations 111.51 .00 111.51 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 111.51 ** 350.00 Budgeted 238.49 Remaining 32 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1680 06/11/2013 June A/P funnel 23,472.07 28.79 23,500.86 ROANOKE AUTO SUPPLY 32674 AP 1776 06/27/2013 June A/P Water parts 619.10 24,119.96 HD SUPPLY WATERWORKS, LTD. 32712 AP 1776 06/27/2013 June A/P meter boxes 895.26 25,015.22 HD SUPPLY WATERWORKS, LTD. 32712 AP 1777 06/27/2013 June A/P Branch piece from back order 261.06 25,276.28 HD SUPPLY WATERWORKS, LTD. 32712 AP 1777 06/27/2013 June A/P 3/4 x 1/8 Rubber meter washer 36.00 25,312.28 HD SUPPLY WATERWORKS, LTD. 32712 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,840.21 25,312.28 ** 50,000.00 Budgeted 24,687.72 Remaining 51 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 22 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-55090-010-000 Vehicle Maintenance 1680 06/11/2013 June A/P vehicle maint 3,637.74 43.16 3,680.90 ROANOKE AUTO SUPPLY 32674 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 43.16 3,680.90 ** 4,650.00 Budgeted 969.10 Remaining 79 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,767.04 .00 1,767.04 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,767.04 ** 2,900.00 Budgeted 1,132.96 Remaining 61 % Used Account: 135-55135-010-000 Lab Analysis 1776 06/27/2013 June A/P Bac-T tests 3,753.81 305.00 4,058.81 TARRANT CTY PUBLIC HEALTH LAB 32734 AP 1776 06/27/2013 June A/P hardness packets 33.70 4,092.51 HACH COMPANY 32711 AP 1777 06/27/2013 June A/P Lab analysis 207.70 4,300.21 LOWER COLORADO RIVER AUTHORITY 32720 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 546.40 4,300.21 ** 5,384.00 Budgeted 1,083.79 Remaining 80 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1776 06/27/2013 June A/P Verizon Inv# 9705375788 1,053.96 139.59 1,193.55 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 139.59 1,193.55 ** 2,000.00 Budgeted 806.45 Remaining 60 % Used Account: 135-60020-010-000 Electricity 1776 06/27/2013 June A/P electricty 5/14-6/13 65,135.33 14,526.78 79,662.11 HUDSON ENERGY SERVICES, LLC 32713 AP 1776 06/27/2013 June A/P PID elevated tank 80.91 79,743.02 HUDSON ENERGY SERVICES, LLC 32713 AP 1776 06/27/2013 June A/P elec 5/14-6/13 1,026.06 80,769.08 HUDSON ENERGY SERVICES, LLC 32713 AP _______________ Account: 135-60020-010-000 Electricity Totals: 15,633.75 80,769.08 ** 162,410.00 Budgeted 81,640.92 Remaining 50 % 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 . glpdatb2 tsisk Trophy Club MUD #1 Page 23 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-010-000 Dues & Memberships 150.00 .00 150.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 150.00 ** 150.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-010-000 Schools & Training 351.00 .00 351.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 351.00 ** 1,472.00 Budgeted 1,121.00 Remaining 24 % 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 551.69 .00 551.69 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 551.69 ** 800.00 Budgeted 248.31 Remaining 69 % Used Account: 135-60105-010-000 Rent/Lease Equipment 1776 06/27/2013 June A/P nitrogen bottle 18.00 6.00 24.00 ALLIED WELDING SUPPLY, INC 32695 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 24.00 ** 500.00 Budgeted 476.00 Remaining 5 % Used Account: 135-60125-010-000 Advertising 1777 06/27/2013 June A/P Ad/Water Field worker 150.00 150.00 300.00 TX MUNICIPAL LEAGUE 32741 AP _______________ Account: 135-60125-010-000 Advertising Totals: 150.00 300.00 ** .00 Budgeted (300.00) Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits . glpdatb2 tsisk Trophy Club MUD #1 Page 24 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 43,293.75 .00 43,293.75 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 43,293.75 ** 42,743.00 Budgeted (550.75) Remaining 101 % Used Account: 135-60150-010-000 Wholesale Water 830,521.44 .00 830,521.44 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 830,521.44 ** 2,028,447.00 Budgeted 1,197,925.56 Remaining 41 % Used Account: 135-60243-010-000 Prior Year Expense 756.00 .00 756.00 _______________ Account: 135-60243-010-000 Prior Year Expense Totals: .00 756.00 ** 756.00 Budgeted .00 Remaining 100 % 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 932.43 .00 932.43 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 932.43 ** 4,200.00 Budgeted 3,267.57 Remaining 22 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 38.99 .00 38.99 . glpdatb2 tsisk Trophy Club MUD #1 Page 25 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-010-000 Furniture/Equipment < $5000 Totals: .00 38.99 ** 500.00 Budgeted 461.01 Remaining 8 % Used Account: 135-65005-010-000 Fuel & Lube 1834 06/30/2013 June gas log 7,601.36 1,001.26 8,602.62 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,001.26 8,602.62 ** 17,661.00 Budgeted 9,058.38 Remaining 49 % Used Account: 135-65010-010-000 Uniforms 1,617.82 .00 1,617.82 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,617.82 ** 2,680.00 Budgeted 1,062.18 Remaining 60 % Used Account: 135-65030-010-000 Chemicals 1776 06/27/2013 June A/P testing supplies 3,204.17 279.95 3,484.12 HACH COMPANY 32711 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 279.95 3,484.12 ** 6,200.00 Budgeted 2,715.88 Remaining 56 % Used Account: 135-65035-010-000 Small Tools 267.19 .00 267.19 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 267.19 ** 1,500.00 Budgeted 1,232.81 Remaining 18 % Used Account: 135-65040-010-000 Safety Equipment 256.82 .00 256.82 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 256.82 ** 1,000.00 Budgeted 743.18 Remaining 26 % Used Account: 135-65050-010-000 Meter Expense 1776 06/27/2013 June A/P meter for lakeview school 147,057.25 1,206.00 148,263.25 ATLAS UTILITY SUPPLY CO. 32696 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 26 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-65050-010-000 Meter Expense Totals: 1,206.00 148,263.25 ** 143,550.00 Budgeted (4,713.25) Remaining 103 % Used Account: 135-65085-010-000 Office Supplies 109.68 .00 109.68 _______________ Account: 135-65085-010-000 Office Supplies Totals: .00 109.68 ** .00 Budgeted (109.68) Remaining 0 % Used Account: 135-69005-010-000 Capital Expenses (1,094.96) .00 (1,094.96) _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 (1,094.96) ** 8,000.00 Budgeted 9,094.96 Remaining -14 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 366,000.00 Budgeted 366,000.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest 10,376.98 .00 10,376.98 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 10,376.98 ** 21,037.00 Budgeted 10,660.02 Remaining 49 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69280-010-000 Capital Repairs 59,869.00 .00 59,869.00 . glpdatb2 tsisk Trophy Club MUD #1 Page 27 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-69280-010-000 Capital Repairs Totals: .00 59,869.00 ** 60,000.00 Budgeted 131.00 Remaining 100 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 100,900.00 Budgeted 83.46 Remaining 100 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,568,488.76 ** 3,425,914.00 Budgeted 1,857,425.24 Remaining 46 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 28 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 1642 06/07/2013 Payroll 6/7/13 Salaries & Wages 115,696.93 6,032.36 121,729.29 PR 1712 06/21/2013 Payroll 6/21/13 Salaries & Wages 7,366.47 129,095.76 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 13,398.83 129,095.76 ** 196,781.00 Budgeted 67,685.24 Remaining 66 % Used Account: 135-50010-020-000 Overtime 1642 06/07/2013 Payroll 6/7/13 Overtime 8,357.36 305.76 8,663.12 PR 1712 06/21/2013 Payroll 6/21/13 Overtime 310.73 8,973.85 PR _______________ Account: 135-50010-020-000 Overtime Totals: 616.49 8,973.85 ** 17,546.00 Budgeted 8,572.15 Remaining 51 % Used Account: 135-50016-020-000 Longevity 2,857.50 .00 2,857.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,857.50 ** 2,858.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1712 06/21/2013 Payroll 6/21/13 Certification 2,700.00 350.00 3,050.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 350.00 3,050.00 ** 4,200.00 Budgeted 1,150.00 Remaining 73 % Used Account: 135-50020-020-000 Retirement 1642 06/07/2013 Payroll 6/7/13 Retirement 39,944.26 569.17 40,513.43 PR 1712 06/21/2013 Payroll 6/21/13 Retirement 720.84 41,234.27 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,290.01 41,234.27 ** 54,844.00 Budgeted 13,609.73 Remaining 75 % Used Account: 135-50026-020-000 Medical Insurance 1642 06/07/2013 Payroll 6/7/13 Medical Insurance 22,391.07 1,382.37 23,773.44 PR 1712 06/21/2013 Payroll 6/21/13 Medical Insurance 1,646.61 25,420.05 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,028.98 25,420.05 ** 29,034.00 Budgeted 3,613.95 Remaining 88 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 29 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-020-000 Dental Insurance 1642 06/07/2013 Payroll 6/7/13 Dental Insurance 1,596.52 97.79 1,694.31 PR 1712 06/21/2013 Payroll 6/21/13 Dental Insurance 113.22 1,807.53 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 211.01 1,807.53 ** 2,112.00 Budgeted 304.47 Remaining 86 % Used Account: 135-50028-020-000 Vision Insurance 1642 06/07/2013 Payroll 6/7/13 Vision Insurance 392.26 20.59 412.85 PR 1712 06/21/2013 Payroll 6/21/13 Vision Insurance 24.95 437.80 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 45.54 437.80 ** 552.00 Budgeted 114.20 Remaining 79 % Used Account: 135-50029-020-000 Life Insurance & Other 1642 06/07/2013 Payroll 6/7/13 Life Insurance & Other 1,007.83 64.17 1,072.00 PR 1776 06/27/2013 June A/P Flex admin fee 15.75 1,087.75 Discovery Benefits 32707 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 79.92 1,087.75 ** 1,377.00 Budgeted 289.25 Remaining 79 % Used Account: 135-50030-020-000 Social Security Taxes 1642 06/07/2013 Payroll 6/7/13 Social Security Taxes 7,137.40 332.00 7,469.40 PR 1712 06/21/2013 Payroll 6/21/13 Social Security Taxes 428.07 7,897.47 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 760.07 7,897.47 ** 13,268.00 Budgeted 5,370.53 Remaining 60 % Used Account: 135-50035-020-000 Medicare Taxes 1642 06/07/2013 Payroll 6/7/13 Medicare Taxes 1,669.22 77.64 1,746.86 PR 1712 06/21/2013 Payroll 6/21/13 Medicare Taxes 100.11 1,846.97 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 177.75 1,846.97 ** 3,103.00 Budgeted 1,256.03 Remaining 60 % Used Account: 135-50040-020-000 Unemployment Taxes 45.41 .00 45.41 . glpdatb2 tsisk Trophy Club MUD #1 Page 30 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-020-000 Unemployment Taxes Totals: .00 45.41 ** 756.00 Budgeted 710.59 Remaining 6 % Used Account: 135-50045-020-000 Workman's Compensation 5,960.27 .00 5,960.27 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 5,960.27 ** 2,939.00 Budgeted (3,021.27) Remaining 203 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1777 06/27/2013 June A/P Testing 126.00 63.00 189.00 CARENOW CORPORATE 32700 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 63.00 189.00 ** 150.00 Budgeted (39.00) Remaining 126 % Used Account: 135-50070-020-000 Employee Relations 91.23 .00 91.23 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 91.23 ** 350.00 Budgeted 258.77 Remaining 26 % Used Account: 135-55070-020-000 Independent Labor 77,500.00 .00 77,500.00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 77,500.00 ** 84,418.00 Budgeted 6,918.00 Remaining 92 % Used Account: 135-55080-020-000 Maintenance & Repairs 42,088.51 .00 42,088.51 _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: .00 42,088.51 ** 41,205.00 Budgeted (883.51) Remaining 102 % Used Account: 135-55090-020-000 Vehicle Maintenance 4,517.96 .00 4,517.96 . glpdatb2 tsisk Trophy Club MUD #1 Page 31 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-55090-020-000 Vehicle Maintenance Totals: .00 4,517.96 ** 3,350.00 Budgeted (1,167.96) Remaining 135 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,080.96 .00 1,080.96 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,080.96 ** 1,500.00 Budgeted 419.04 Remaining 72 % Used Account: 135-55125-020-000 Dumpster Services 1776 06/27/2013 June A/P sludge haul off 33,987.01 829.04 34,816.05 L.H. CHANEY MATERIALS, INC. 32718 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 829.04 34,816.05 ** 49,611.00 Budgeted 14,794.95 Remaining 70 % Used Account: 135-55135-020-000 Lab Analysis 1776 06/27/2013 June A/P testing 20,518.65 243.00 20,761.65 OXIDOR LABORATORIES LLC 32727 AP 1776 06/27/2013 June A/P testing 176.00 20,937.65 OXIDOR LABORATORIES LLC 32727 AP 1776 06/27/2013 June A/P testing 88.00 21,025.65 OXIDOR LABORATORIES LLC 32727 AP 1776 06/27/2013 June A/P testing 98.00 21,123.65 OXIDOR LABORATORIES LLC 32727 AP 1776 06/27/2013 June A/P testing 1,010.00 22,133.65 OXIDOR LABORATORIES LLC 32727 AP 1776 06/27/2013 June A/P testing 98.00 22,231.65 OXIDOR LABORATORIES LLC 32727 AP 1776 06/27/2013 June A/P testing 352.00 22,583.65 OXIDOR LABORATORIES LLC 32727 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,065.00 22,583.65 ** 30,000.00 Budgeted 7,416.35 Remaining 75 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1776 06/27/2013 June A/P Verizon Inv# 9705375788 1,408.33 233.86 1,642.19 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 233.86 1,642.19 ** 3,981.00 Budgeted 2,338.81 Remaining 41 % Used Account: 135-60020-020-000 Electricity 1776 06/27/2013 June A/P electric 5/14-6/13 84,225.41 10,495.71 94,721.12 HUDSON ENERGY SERVICES, LLC 32713 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,495.71 94,721.12 ** 153,045.00 Budgeted 58,323.88 Remaining 62 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 32 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-60066-020-000 Publications/Books/Subscripts 161.45 .00 161.45 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 161.45 ** 200.00 Budgeted 38.55 Remaining 81 % Used Account: 135-60080-020-000 Schools & Training 1,071.66 .00 1,071.66 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 1,071.66 ** 3,272.00 Budgeted 2,200.34 Remaining 33 % Used Account: 135-60090-020-000 Safety Program 71.47 .00 71.47 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 71.47 ** .00 Budgeted (71.47) Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 3,256.94 .00 3,256.94 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 3,256.94 ** 1,400.00 Budgeted (1,856.94) Remaining 233 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1,123.00 .00 1,123.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1,123.00 ** 1,500.00 Budgeted 377.00 Remaining 75 % Used Account: 135-60125-020-000 Advertising 112.50 .00 112.50 _______________ Account: 135-60125-020-000 Advertising Totals: .00 112.50 ** 300.00 Budgeted 187.50 Remaining 38 % Used Account: 135-60135-020-000 TCEQ Fees & Permits . glpdatb2 tsisk Trophy Club MUD #1 Page 33 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 7,887.19 .00 7,887.19 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 7,887.19 ** 15,600.00 Budgeted 7,712.81 Remaining 51 % Used Account: 135-60136-020-000 TCEQ Environmental Proj (SEP) 40,400.00 .00 40,400.00 _______________ Account: 135-60136-020-000 TCEQ Environmental Proj (SEP) Totals: .00 40,400.00 ** 40,400.00 Budgeted .00 Remaining 100 % Used Account: 135-60243-020-000 Prior Year Expense 801.59 .00 801.59 _______________ Account: 135-60243-020-000 Prior Year Expense Totals: .00 801.59 ** 802.00 Budgeted .41 Remaining 100 % Used Account: 135-60245-020-000 Miscellaneous Expenses 202.10 .00 202.10 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 202.10 ** 200.00 Budgeted (2.10) Remaining 101 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 412.23 .00 412.23 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 412.23 ** 500.00 Budgeted 87.77 Remaining 82 % Used Account: 135-65005-020-000 Fuel & Lube 1834 06/30/2013 June gas log 7,132.95 964.54 8,097.49 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 964.54 8,097.49 ** 10,527.00 Budgeted 2,429.51 Remaining 77 % Used Account: 135-65010-020-000 Uniforms 1680 06/11/2013 June A/P Hats-staff 1,203.70 120.00 1,323.70 PANDA EMBROIDERY 32671 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 34 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-65010-020-000 Uniforms Totals: 120.00 1,323.70 ** 1,574.00 Budgeted 250.30 Remaining 84 % Used Account: 135-65030-020-000 Chemicals 22,790.90 .00 22,790.90 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 22,790.90 ** 38,346.00 Budgeted 15,555.10 Remaining 59 % Used Account: 135-65035-020-000 Small Tools 469.05 .00 469.05 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 469.05 ** 1,000.00 Budgeted 530.95 Remaining 47 % Used Account: 135-65040-020-000 Safety Equipment 1776 06/27/2013 June A/P first aid supplies 526.70 25.63 552.33 CINTAS FAS LOCKBOX 636525 32702 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 25.63 552.33 ** 500.00 Budgeted (52.33) Remaining 110 % Used Account: 135-65045-020-000 Lab Supplies 1776 06/27/2013 June A/P Water for WWTP 12,995.35 29.85 13,025.20 OZARKA DIRECT 32728 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 29.85 13,025.20 ** 10,000.00 Budgeted (3,025.20) Remaining 130 % Used Account: 135-69005-020-000 Capital Expenses 442,195.29 .00 442,195.29 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 442,195.29 ** 446,484.00 Budgeted 4,288.71 Remaining 99 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,052,899.39 ** 1,269,585.00 Budgeted 216,685.61 Remaining 83 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 35 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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 1642 06/07/2013 Payroll 6/7/13 Salaries & Wages 94,904.13 5,891.37 100,795.50 PR 1712 06/21/2013 Payroll 6/21/13 Salaries & Wages 5,891.37 106,686.87 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,782.74 106,686.87 ** 156,475.00 Budgeted 49,788.13 Remaining 68 % Used Account: 135-50010-021-000 Overtime 1642 06/07/2013 Payroll 6/7/13 Overtime 6,365.46 668.02 7,033.48 PR 1712 06/21/2013 Payroll 6/21/13 Overtime 487.99 7,521.47 PR _______________ Account: 135-50010-021-000 Overtime Totals: 1,156.01 7,521.47 ** 12,158.00 Budgeted 4,636.53 Remaining 62 % Used Account: 135-50016-021-000 Longevity 3,817.50 .00 3,817.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 3,817.50 ** 3,818.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 1712 06/21/2013 Payroll 6/21/13 Certification 1,150.00 150.00 1,300.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,300.00 ** 1,800.00 Budgeted 500.00 Remaining 72 % Used Account: 135-50020-021-000 Retirement 1642 06/07/2013 Payroll 6/7/13 Retirement 31,550.19 589.03 32,139.22 PR 1712 06/21/2013 Payroll 6/21/13 Retirement 586.34 32,725.56 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,175.37 32,725.56 ** 42,910.00 Budgeted 10,184.44 Remaining 76 % Used Account: 135-50026-021-000 Medical Insurance 1642 06/07/2013 Payroll 6/7/13 Medical Insurance 16,656.99 1,160.78 17,817.77 PR 1712 06/21/2013 Payroll 6/21/13 Medical Insurance 1,160.77 18,978.54 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,321.55 18,978.54 ** 25,940.00 Budgeted 6,961.46 Remaining 73 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 36 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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 1642 06/07/2013 Payroll 6/7/13 Dental Insurance 1,172.84 79.95 1,252.79 PR 1712 06/21/2013 Payroll 6/21/13 Dental Insurance 79.93 1,332.72 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 159.88 1,332.72 ** 1,812.00 Budgeted 479.28 Remaining 74 % Used Account: 135-50028-021-000 Vision Insurance 1642 06/07/2013 Payroll 6/7/13 Vision Insurance 252.12 16.31 268.43 PR 1712 06/21/2013 Payroll 6/21/13 Vision Insurance 16.29 284.72 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 32.60 284.72 ** 383.00 Budgeted 98.28 Remaining 74 % Used Account: 135-50029-021-000 Life Insurance & Other 1642 06/07/2013 Payroll 6/7/13 Life Insurance & Other 739.89 59.53 799.42 PR 1776 06/27/2013 June A/P Flex admin fee 5.25 804.67 Discovery Benefits 32707 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 64.78 804.67 ** 1,223.00 Budgeted 418.33 Remaining 66 % Used Account: 135-50030-021-000 Social Security Taxes 1642 06/07/2013 Payroll 6/7/13 Social Security Taxes 6,292.36 374.08 6,666.44 PR 1712 06/21/2013 Payroll 6/21/13 Social Security Taxes 370.10 7,036.54 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 744.18 7,036.54 ** 10,502.00 Budgeted 3,465.46 Remaining 67 % Used Account: 135-50035-021-000 Medicare Taxes 1642 06/07/2013 Payroll 6/7/13 Medicare Taxes 1,471.58 87.48 1,559.06 PR 1712 06/21/2013 Payroll 6/21/13 Medicare Taxes 86.55 1,645.61 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 174.03 1,645.61 ** 2,456.00 Budgeted 810.39 Remaining 67 % Used Account: 135-50040-021-000 Unemployment Taxes 34.39 .00 34.39 . glpdatb2 tsisk Trophy Club MUD #1 Page 37 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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 34.39 ** 567.00 Budgeted 532.61 Remaining 6 % Used Account: 135-50045-021-000 Workman's Compensation 4,896.88 .00 4,896.88 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 4,896.88 ** 3,348.00 Budgeted (1,548.88) Remaining 146 % Used Account: 135-50070-021-000 Employee Relations 108.00 .00 108.00 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 108.00 ** 250.00 Budgeted 142.00 Remaining 43 % Used Account: 135-55080-021-000 Maintenance & Repairs 1776 06/27/2013 June A/P concrete driveway-5 Oak Villag 15,962.78 1,500.00 17,462.78 Robert West Construction, Inc 32729 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 1,500.00 17,462.78 ** 20,000.00 Budgeted 2,537.22 Remaining 87 % Used Account: 135-55090-021-000 Vehicle Maintenance 1776 06/27/2013 June A/P oil filter 1,344.23 61.65 1,405.88 ROANOKE AUTO SUPPLY 32730 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 61.65 1,405.88 ** 1,600.00 Budgeted 194.12 Remaining 88 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 1776 06/27/2013 June A/P Verizon Inv# 9705375788 1,580.45 216.91 1,797.36 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 216.91 1,797.36 ** 3,500.00 Budgeted 1,702.64 Remaining 51 % Used Account: 135-60020-021-000 Electricity 1776 06/27/2013 June A/P elec 5/14-6/13 11,979.36 665.78 12,645.14 HUDSON ENERGY SERVICES, LLC 32713 AP 1776 06/27/2013 June A/P electric 5/14-6/13 255.32 12,900.46 HUDSON ENERGY SERVICES, LLC 32713 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 38 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1776 06/27/2013 June A/P Lift Station 8 11,979.36 50.25 12,950.71 HUDSON ENERGY SERVICES, LLC 32713 AP 1776 06/27/2013 June A/P Elec 5/30-6/12 87.76 13,038.47 HUDSON ENERGY SERVICES, LLC 32713 AP 1776 06/27/2013 June A/P electricity 4/30-5/30 316.60 13,355.07 TRI COUNTY ELECTRIC 32739 AP 1776 06/27/2013 June A/P electricity 4/30-5/30 182.78 13,537.85 TRI COUNTY ELECTRIC 32739 AP 1776 06/27/2013 June A/P electricity 4/30-5/30 27.80 13,565.65 TRI COUNTY ELECTRIC 32739 AP 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (84.58) 13,481.07 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,501.71 13,481.07 ** 18,705.00 Budgeted 5,223.93 Remaining 72 % Used Account: 135-60070-021-000 Dues & Memberships 250.00 .00 250.00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 250.00 ** 250.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-021-000 Schools & Training 830.00 .00 830.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 830.00 ** 826.00 Budgeted (4.00) Remaining 100 % 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 2,092.93 .00 2,092.93 _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 2,092.93 ** 450.00 Budgeted (1,642.93) Remaining 465 % 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 . glpdatb2 tsisk Trophy Club MUD #1 Page 39 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/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-60243-021-000 Prior Year Expense 620.83 .00 620.83 _______________ Account: 135-60243-021-000 Prior Year Expense Totals: .00 620.83 ** 621.00 Budgeted .17 Remaining 100 % 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 1834 06/30/2013 June gas log 5,576.47 934.37 6,510.84 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 934.37 6,510.84 ** 12,117.00 Budgeted 5,606.16 Remaining 54 % Used Account: 135-65010-021-000 Uniforms 934.13 .00 934.13 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 934.13 ** 2,220.00 Budgeted 1,285.87 Remaining 42 % Used Account: 135-65030-021-000 Chemicals 2,221.00 .00 2,221.00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 2,221.00 ** 7,500.00 Budgeted 5,279.00 Remaining 30 % Used Account: 135-65035-021-000 Small Tools 70.00 .00 70.00 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 70.00 ** 1,250.00 Budgeted 1,180.00 Remaining 6 % Used Account: 135-65040-021-000 Safety Equipment . glpdatb2 tsisk Trophy Club MUD #1 Page 40 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 120.00 .00 120.00 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 120.00 ** 500.00 Budgeted 380.00 Remaining 24 % Used Account: 135-69005-021-000 Capital Expenses 15,276.00 .00 15,276.00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 15,276.00 ** 90,000.00 Budgeted 74,724.00 Remaining 17 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 40,260.00 Budgeted 40,260.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 250,246.29 ** 473,841.00 Budgeted 223,594.71 Remaining 53 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 41 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/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 1642 06/07/2013 Payroll 6/7/13 Salaries & Wages 7,100.00 400.00 7,500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 400.00 7,500.00 ** 10,000.00 Budgeted 2,500.00 Remaining 75 % Used Account: 135-50030-026-000 Social Security Taxes 1642 06/07/2013 Payroll 6/7/13 Social Security Taxes 440.20 24.80 465.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 24.80 465.00 ** 620.00 Budgeted 155.00 Remaining 75 % Used Account: 135-50035-026-000 Medicare Taxes 1642 06/07/2013 Payroll 6/7/13 Medicare Taxes 102.95 5.80 108.75 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 5.80 108.75 ** 145.00 Budgeted 36.25 Remaining 75 % Used Account: 135-50040-026-000 Unemployment Taxes 1642 06/07/2013 Payroll 6/7/13 Unemployment Taxes 65.90 .40 66.30 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .40 66.30 ** 210.00 Budgeted 143.70 Remaining 32 % Used Account: 135-50045-026-000 Workman's Compensation 7.88 .00 7.88 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 7.88 ** 150.00 Budgeted 142.12 Remaining 5 % 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 tsisk Trophy Club MUD #1 Page 42 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 42.00 .00 42.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 42.00 ** 2,100.00 Budgeted 2,058.00 Remaining 2 % Used Account: 135-60075-026-000 Meetings 434.97 .00 434.97 _______________ Account: 135-60075-026-000 Meetings Totals: .00 434.97 ** 1,200.00 Budgeted 765.03 Remaining 36 % Used Account: 135-60080-026-000 Schools & Training 2,655.00 .00 2,655.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 2,655.00 ** 4,000.00 Budgeted 1,345.00 Remaining 66 % Used Account: 135-60100-026-000 Travel & per diem 1777 06/27/2013 June A/P Travel-AWBD 4,106.22 962.44 5,068.66 KEVIN CARR 32716 AP 1777 06/27/2013 June A/P Travel WW tours 256.88 5,325.54 KEVIN CARR 32716 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 1,219.32 5,325.54 ** 5,000.00 Budgeted (325.54) Remaining 107 % Used Account: 135-60243-026-000 Prior Year Expense 107.10 .00 107.10 _______________ Account: 135-60243-026-000 Prior Year Expense Totals: .00 107.10 ** .00 Budgeted (107.10) Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses 267.88 .00 267.88 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 267.88 ** 3,000.00 Budgeted 2,732.12 Remaining 9 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 16,980.42 ** 26,575.00 Budgeted 9,594.58 Remaining 64 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 43 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 1642 06/07/2013 Payroll 6/7/13 Salaries & Wages 273,945.57 16,564.73 290,510.30 PR 1712 06/21/2013 Payroll 6/21/13 Salaries & Wages 16,578.13 307,088.43 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,142.86 307,088.43 ** 444,730.00 Budgeted 137,641.57 Remaining 69 % Used Account: 135-50010-030-000 Overtime 1642 06/07/2013 Payroll 6/7/13 Overtime 233.93 3.50 237.43 PR 1712 06/21/2013 Payroll 6/21/13 Overtime 2.51 239.94 PR _______________ Account: 135-50010-030-000 Overtime Totals: 6.01 239.94 ** 1,500.00 Budgeted 1,260.06 Remaining 16 % Used Account: 135-50016-030-000 Longevity 2,317.50 .00 2,317.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 2,317.50 ** 2,318.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1642 06/07/2013 Payroll 6/7/13 Retirement 75,342.70 1,487.84 76,830.54 PR 1712 06/21/2013 Payroll 6/21/13 Retirement 1,488.93 78,319.47 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,976.77 78,319.47 ** 104,801.00 Budgeted 26,481.53 Remaining 75 % Used Account: 135-50026-030-000 Medical Insurance 1642 06/07/2013 Payroll 6/7/13 Medical Insurance 31,496.40 2,194.07 33,690.47 PR 1712 06/21/2013 Payroll 6/21/13 Medical Insurance 2,194.03 35,884.50 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 35,884.50 ** 49,049.00 Budgeted 13,164.50 Remaining 73 % Used Account: 135-50027-030-000 Dental Insurance 1642 06/07/2013 Payroll 6/7/13 Dental Insurance 2,797.86 193.19 2,991.05 PR 1712 06/21/2013 Payroll 6/21/13 Dental Insurance 193.15 3,184.20 PR . glpdatb2 tsisk Trophy Club MUD #1 Page 44 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-030-000 Dental Insurance Totals: 386.34 3,184.20 ** 3,379.00 Budgeted 194.80 Remaining 94 % Used Account: 135-50028-030-000 Vision Insurance 1642 06/07/2013 Payroll 6/7/13 Vision Insurance 611.17 41.29 652.46 PR 1712 06/21/2013 Payroll 6/21/13 Vision Insurance 41.24 693.70 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 693.70 ** 945.00 Budgeted 251.30 Remaining 73 % Used Account: 135-50029-030-000 Life Insurance & Other 1642 06/07/2013 Payroll 6/7/13 Life Insurance & Other 1,896.17 136.33 2,032.50 PR 1776 06/27/2013 June A/P Flex admin fee 36.75 2,069.25 Discovery Benefits 32707 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 173.08 2,069.25 ** 2,582.00 Budgeted 512.75 Remaining 80 % Used Account: 135-50030-030-000 Social Security Taxes 1642 06/07/2013 Payroll 6/7/13 Social Security Taxes 16,410.36 957.18 17,367.54 PR 1712 06/21/2013 Payroll 6/21/13 Social Security Taxes 953.43 18,320.97 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,910.61 18,320.97 ** 27,802.00 Budgeted 9,481.03 Remaining 66 % Used Account: 135-50035-030-000 Medicare Taxes 1642 06/07/2013 Payroll 6/7/13 Medicare Taxes 3,837.91 223.85 4,061.76 PR 1712 06/21/2013 Payroll 6/21/13 Medicare Taxes 223.01 4,284.77 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 446.86 4,284.77 ** 6,502.00 Budgeted 2,217.23 Remaining 66 % Used Account: 135-50040-030-000 Unemployment Taxes 439.29 .00 439.29 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 439.29 ** 1,537.00 Budgeted 1,097.71 Remaining 29 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 45 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-50045-030-000 Workman's Compensation 938.60 .00 938.60 _______________ Account: 135-50045-030-000 Workman's Compensation Totals: .00 938.60 ** 831.00 Budgeted (107.60) Remaining 113 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 39.00 .00 39.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 39.00 ** 250.00 Budgeted 211.00 Remaining 16 % Used Account: 135-50070-030-000 Employee Relations 2,739.99 .00 2,739.99 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 2,739.99 ** 5,000.00 Budgeted 2,260.01 Remaining 55 % Used Account: 135-55030-030-000 Software & Support 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards 48,711.94 (25.00) 48,686.94 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards (95.01) 48,591.93 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1680 06/11/2013 June A/P Annual support for Remit Plus 1,750.00 50,341.93 JACK HENRY & ASSOC, INC 32655 AP 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards (197.00) 50,144.93 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards (53.38) 50,091.55 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards (64.99) 50,026.56 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1683 06/11/2013 June A/P May IT PCards 25.00 50,051.56 TOWN OF TROPHY CLUB 32691 AP 1683 06/11/2013 June A/P May IT PCards 95.01 50,146.57 TOWN OF TROPHY CLUB 32691 AP 1683 06/11/2013 June A/P May IT PCards 197.00 50,343.57 TOWN OF TROPHY CLUB 32691 AP 1683 06/11/2013 June A/P May IT PCards 53.38 50,396.95 TOWN OF TROPHY CLUB 32691 AP 1683 06/11/2013 June A/P May IT PCards 64.99 50,461.94 TOWN OF TROPHY CLUB 32691 AP 1776 06/27/2013 June A/P annual AV maint 288.00 50,749.94 TOWN OF TROPHY CLUB 32738 AP 1776 06/27/2013 June A/P ISP charges 363.30 51,113.24 TOWN OF TROPHY CLUB 32738 AP 1776 06/27/2013 June A/P Town Billing 645.50 51,758.74 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 3,046.80 51,758.74 ** 63,555.00 Budgeted 11,796.26 Remaining 81 % Used Account: 135-55070-030-000 Independent Labor 1776 06/27/2013 June A/P Town Billing 598.75 15.62 614.37 TOWN OF TROPHY CLUB 32738 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 46 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1776 06/27/2013 June A/P Record MUD meeting 598.75 71.25 685.62 MIGUEL CRUZ 32723 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 86.87 685.62 ** 7,700.00 Budgeted 7,014.38 Remaining 9 % Used Account: 135-55075-030-000 Records Management .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 810.52 .00 810.52 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 810.52 ** 811.00 Budgeted .48 Remaining 100 % Used Account: 135-55100-030-000 Building Maint & Supplies 1704 06/14/2013 Town Billed Inv 1041-1045 AR 20130614-20130614 User: 4,305.95 (168.30) 4,137.65 AR 1777 06/27/2013 June A/P Advertising, Pest control, Ton 87.50 4,225.15 TOWN OF TROPHY CLUB 32738 AP 1779 06/28/2013 June A/P Consultation for CL2 Switchove 140.00 4,365.15 Environmental Systems Company 32709 AP 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (126.22) 4,238.93 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: (67.02) 4,238.93 ** 6,500.00 Budgeted 2,261.07 Remaining 65 % Used Account: 135-55120-030-000 Cleaning Services 1777 06/27/2013 June A/P May janitorial service 12,197.25 1,678.51 13,875.76 ABM JANITORIAL SERVICES, INC 32693 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,678.51 13,875.76 ** 20,200.00 Budgeted 6,324.24 Remaining 69 % Used Account: 135-55160-030-000 Professional Outside Services 6,974.00 .00 6,974.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 6,974.00 ** 15,000.00 Budgeted 8,026.00 Remaining 46 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 47 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-55161-030-000 Outside Services-Town Semo 85,465.00 .00 85,465.00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 85,465.00 ** 85,465.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees 159.77 .00 159.77 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 159.77 ** 160.00 Budgeted .23 Remaining 100 % Used Account: 135-55205-030-000 Utility Billing Contract 1776 06/27/2013 June A/P Billing & Inserts 4,358.49 772.01 5,130.50 DP2 BILLING SOLUTIONS, LLC 32708 AP 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (24.44) 5,106.06 AR _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 747.57 5,106.06 ** 11,000.00 Budgeted 5,893.94 Remaining 46 % Used Account: 135-60005-030-000 Telephone 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards 8,236.58 (119.25) 8,117.33 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards (228.34) 7,888.99 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards (392.37) 7,496.62 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards (373.13) 7,123.49 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1683 06/11/2013 June A/P May IT PCards 119.25 7,242.74 TOWN OF TROPHY CLUB 32691 AP 1683 06/11/2013 June A/P May IT PCards 228.34 7,471.08 TOWN OF TROPHY CLUB 32691 AP 1683 06/11/2013 June A/P May IT PCards 392.37 7,863.45 TOWN OF TROPHY CLUB 32691 AP 1683 06/11/2013 June A/P May IT PCards 373.13 8,236.58 TOWN OF TROPHY CLUB 32691 AP 1776 06/27/2013 June A/P answering service 200.29 8,436.87 KEYSTONE PARK SECRETARIAL 32717 AP _______________ Account: 135-60005-030-000 Telephone Totals: 200.29 8,436.87 ** 10,500.00 Budgeted 2,063.13 Remaining 80 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1712 06/21/2013 Payroll 6/21/13 Communications/Pagers/Mobiles 2,295.69 150.00 2,445.69 PR 1776 06/27/2013 June A/P Verizon Inv# 9705375788 176.75 2,622.44 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 326.75 2,622.44 ** 3,575.00 Budgeted 952.56 Remaining 73 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 48 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-030-000 Electricity/Gas 1776 06/27/2013 June A/P electric 8,131.52 1,018.48 9,150.00 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,018.48 9,150.00 ** 13,019.00 Budgeted 3,869.00 Remaining 70 % Used Account: 135-60025-030-000 Water 1682 06/11/2013 Void A/P ck 32687/wrong vendor May water bills 740.46 (175.32) 565.14 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1683 06/11/2013 June A/P May Water 175.32 740.46 TROPHY CLUB MUD (WATER BILLS) 32692 AP 1704 06/14/2013 Town Billed Inv 1041-1045 AR 20130614-20130614 User: (87.66) 652.80 AR _______________ Account: 135-60025-030-000 Water Totals: (87.66) 652.80 ** 3,100.00 Budgeted 2,447.20 Remaining 21 % Used Account: 135-60030-030-000 Rent And/Or Usage 1578 06/01/2013 June A/P Public Services Rent/June 8,788.08 1,098.51 9,886.59 TOWN OF TROPHY CLUB 32635 AP _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 1,098.51 9,886.59 ** 13,182.00 Budgeted 3,295.41 Remaining 75 % Used Account: 135-60035-030-000 Postage 1776 06/27/2013 June A/P overnight payment 18,426.34 6.17 18,432.51 FEDERAL EXPRESS CORP 32710 AP 1776 06/27/2013 June A/P CCR 1,017.69 19,450.20 COMPUTER EXTENSION SYS. INC 32703 AP 1776 06/27/2013 June A/P Billing & Inserts 1,567.12 21,017.32 DP2 BILLING SOLUTIONS, LLC 32708 AP 1777 06/27/2013 June A/P Postage meter lease 145.50 21,162.82 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-60035-030-000 Postage Totals: 2,736.48 21,162.82 ** 26,604.00 Budgeted 5,441.18 Remaining 80 % Used Account: 135-60040-030-000 Service Charges & Fees 1651 06/04/2013 Online/CC fees 18,365.90 2,104.43 20,470.33 GL 1651 06/04/2013 Online/CC fees 84.20 20,554.53 GL 1651 06/04/2013 Online/CC fees 64.66 20,619.19 GL 1820 06/10/2013 Bank monthly analysis charge 250.00 20,869.19 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,503.29 20,869.19 ** 28,330.00 Budgeted 7,460.81 Remaining 74 % Used Account: 135-60050-030-000 Bad Debt Expense . glpdatb2 tsisk Trophy Club MUD #1 Page 49 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1808 06/30/2013 UB 6/30/13 Write offs UB20130630-20130630 User: 85.44 915.96 1,001.40 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 915.96 1,001.40 ** 8,500.00 Budgeted 7,498.60 Remaining 12 % Used Account: 135-60055-030-000 Insurance 1776 06/27/2013 June A/P Director Bonds 50,743.77 200.00 50,943.77 VICTOR O SCHINNERER & CO, INC 32742 AP _______________ Account: 135-60055-030-000 Insurance Totals: 200.00 50,943.77 ** 50,694.00 Budgeted (249.77) Remaining 100 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 833.50 .00 833.50 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 833.50 ** 834.00 Budgeted .50 Remaining 100 % Used Account: 135-60070-030-000 Dues & Memberships 1680 06/11/2013 June A/P membership 3,891.95 300.00 4,191.95 TML INTERGOVERNMENTAL RISK 32686 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 300.00 4,191.95 ** 3,892.00 Budgeted (299.95) Remaining 108 % Used Account: 135-60075-030-000 Meetings 283.85 .00 283.85 _______________ Account: 135-60075-030-000 Meetings Totals: .00 283.85 ** 400.00 Budgeted 116.15 Remaining 71 % Used Account: 135-60080-030-000 Schools & Training 3,394.65 .00 3,394.65 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 3,394.65 ** 5,350.00 Budgeted 1,955.35 Remaining 63 % Used Account: 135-60100-030-000 Travel & per diem 1642 06/07/2013 Payroll 6/7/13 Travel & per diem 3,697.01 24.86 3,721.87 PR . glpdatb2 tsisk Trophy Club MUD #1 Page 50 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1776 06/27/2013 June A/P tolls 3,697.01 5.23 3,727.10 Texas Tollways 32736 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 30.09 3,727.10 ** 3,616.00 Budgeted (111.10) Remaining 103 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 1777 06/27/2013 June A/P Advertising, Pest control, Ton 893.40 155.50 1,048.90 TOWN OF TROPHY CLUB 32738 AP 1776 06/27/2013 June A/P magnets 370.00 1,418.90 SIGMA SIGNS & PRINTING 32732 AP _______________ Account: 135-60125-030-000 Advertising Totals: 525.50 1,418.90 ** 4,000.00 Budgeted 2,581.10 Remaining 35 % Used Account: 135-60235-030-000 Security 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards 505.13 (505.13) .00 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1683 06/11/2013 June A/P May IT PCards 505.13 505.13 TOWN OF TROPHY CLUB 32691 AP _______________ Account: 135-60235-030-000 Security Totals: .00 505.13 ** 1,350.00 Budgeted 844.87 Remaining 37 % Used Account: 135-60243-030-000 Prior Year Expense 3,290.58 .00 3,290.58 _______________ Account: 135-60243-030-000 Prior Year Expense Totals: .00 3,290.58 ** 1,263.00 Budgeted (2,027.58) Remaining 261 % Used Account: 135-60245-030-000 Miscellaneous Expenses 1819 06/28/2013 Bank adj/Counterfeit $20 dep 1,015.22 20.00 1,035.22 GL _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 20.00 1,035.22 ** 13,500.00 Budgeted 12,464.78 Remaining 8 % Used Account: 135-60270-030-000 4th of July Celebration . glpdatb2 tsisk Trophy Club MUD #1 Page 51 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1777 06/27/2013 June A/P 4th of July donation 10,000.00 10,000.00 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-60270-030-000 4th of July Celebration Totals: 10,000.00 10,000.00 ** 10,500.00 Budgeted 500.00 Remaining 95 % Used Account: 135-60281-030-000 Park Expenses 1776 06/27/2013 June A/P Harmony Park Expenses 30,550.46 1,176.87 31,727.33 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-60281-030-000 Park Expenses Totals: 1,176.87 31,727.33 ** 42,500.00 Budgeted 10,772.67 Remaining 75 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 161,000.00 .00 161,000.00 _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: .00 161,000.00 ** .00 Budgeted (161,000.00) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 3,537.76 .00 3,537.76 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 3,537.76 ** 2,500.00 Budgeted (1,037.76) Remaining 142 % Used Account: 135-65010-030-000 Uniforms 624.12 .00 624.12 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 624.12 ** 1,635.00 Budgeted 1,010.88 Remaining 38 % Used Account: 135-65055-030-000 Hardware 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards 11,941.74 (33.08) 11,908.66 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards (365.17) 11,543.49 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1683 06/11/2013 June A/P May IT PCards 33.08 11,576.57 TOWN OF TROPHY CLUB 32691 AP 1683 06/11/2013 June A/P May IT PCards 365.17 11,941.74 TOWN OF TROPHY CLUB 32691 AP 1776 06/27/2013 June A/P toner & replacement battery ca 157.50 12,099.24 TOWN OF TROPHY CLUB 32738 AP 1776 06/27/2013 June A/P coax wire stripper 8.80 12,108.04 TOWN OF TROPHY CLUB 32738 AP 1776 06/27/2013 June A/P Town Billing 21.30 12,129.34 TOWN OF TROPHY CLUB 32738 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 52 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 Totals: 187.60 12,129.34 ** 20,188.00 Budgeted 8,058.66 Remaining 60 % Used Account: 135-65085-030-000 Office Supplies 1682 06/11/2013 Void A/P ck 32687/wrong vendor IT May PCards 6,491.22 (59.99) 6,431.23 TROPHY CLUB MUD (WATER BILLS) 32687 AP 1683 06/11/2013 June A/P May IT PCards 59.99 6,491.22 TOWN OF TROPHY CLUB 32691 AP 1704 06/14/2013 Town Billed Inv 1041-1045 AR 20130614-20130614 User: (18.06) 6,473.16 AR 1777 06/27/2013 June A/P 77.92 6,551.08 OFFICE DEPOT, INC 32726 AP 1777 06/27/2013 June A/P Office supplies 153.18 6,704.26 OFFICE DEPOT, INC 32726 AP 1777 06/27/2013 June A/P Office supplies 27.50 6,731.76 OFFICE DEPOT, INC 32726 AP 1776 06/27/2013 June A/P pcards-office supplies 181.86 6,913.62 TOWN OF TROPHY CLUB 32738 AP 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: (18.06) 6,895.56 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 404.34 6,895.56 ** 8,200.00 Budgeted 1,304.44 Remaining 84 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1777 06/27/2013 June A/P Advertising, Pest control, Ton 2,057.58 142.50 2,200.08 TOWN OF TROPHY CLUB 32738 AP 1776 06/27/2013 June A/P toner & replacement battery ca 91.00 2,291.08 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 233.50 2,291.08 ** 5,732.00 Budgeted 3,440.92 Remaining 40 % Used Account: 135-65095-030-000 Maintenance Supplies 1838 06/30/2013 Bill Town Inv 1046-1054 AR 20130601-20130630 User: 2,319.47 (103.53) 2,215.94 AR _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: (103.53) 2,215.94 ** 1,500.00 Budgeted (715.94) Remaining 148 % Used Account: 135-65097-030-000 Vending Machine Supplies 50.32 .00 50.32 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 50.32 ** 500.00 Budgeted 449.68 Remaining 10 % Used Account: 135-65105-030-000 Printing 1776 06/27/2013 June A/P CCR 1,156.19 979.47 2,135.66 COMPUTER EXTENSION SYS. INC 32703 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 53 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-65105-030-000 Printing Totals: 979.47 2,135.66 ** 4,200.00 Budgeted 2,064.34 Remaining 51 % Used Account: 135-69170-030-000 Copier Lease Installments 1777 06/27/2013 June A/P Copier lease Kyocera # 5899189 1,797.95 256.85 2,054.80 TOWN OF TROPHY CLUB 32738 AP 1776 06/27/2013 June A/P copier lease 256.85 2,311.65 TOWN OF TROPHY CLUB 32738 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 513.70 2,311.65 ** 3,450.00 Budgeted 1,138.35 Remaining 67 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 .00 26,911.00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 26,911.00 ** 26,911.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 1,030,870.53 ** 1,182,142.00 Budgeted 151,271.47 Remaining 87 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 54 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/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 1833 06/01/2013 Recode Whitaker Inv to Fire Whitaker May Legal 141,515.60 (1,048.32) 140,467.28 GL 1680 06/11/2013 June A/P may legal 2,145.00 142,612.28 FREEMAN & CORBETT 32650 AP 1776 06/27/2013 June A/P legal-may 3,238.61 145,850.89 BOOTH, AHRENS & WERKENTHIN PC 32699 AP 1776 06/27/2013 June A/P legal-may 440.00 146,290.89 THE LISTON LAW FIRM, P.C. 32737 AP 1777 06/27/2013 June A/P May legal/General 6,577.28 152,868.17 WHITAKER CHALK SWINDLE 32743 AP 1777 06/27/2013 June A/P May legal/Prime Construction 1,048.32 153,916.49 WHITAKER CHALK SWINDLE 32743 AP 1777 06/27/2013 June A/P May Legal CCN 888.55 154,805.04 WHITAKER CHALK SWINDLE 32743 AP 1777 06/27/2013 June A/P May legal/Service to Solana 537.60 155,342.64 WHITAKER CHALK SWINDLE 32743 AP 1777 06/27/2013 June A/P May legal/New Town contract fo 1,544.70 156,887.34 WHITAKER CHALK SWINDLE 32743 AP _______________ Account: 135-55045-039-000 Legal Totals: 15,371.74 156,887.34 ** 70,000.00 Budgeted (86,887.34) Remaining 224 % Used Account: 135-55055-039-000 Auditing 20,700.00 .00 20,700.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 20,700.00 ** 21,200.00 Budgeted 500.00 Remaining 98 % Used Account: 135-55060-039-000 Appraisal 1776 06/27/2013 June A/P Third qtr DCAD budget 6,209.06 1,943.16 8,152.22 DENTON CENTRAL APPRAISAL DISTR 32705 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,943.16 8,152.22 ** 15,100.00 Budgeted 6,947.78 Remaining 54 % Used Account: 135-55065-039-000 Tax Admin Fees 1680 06/11/2013 June A/P tax statements 2,356.39 34.17 2,390.56 DENTON COUNTY TAX OFFICE 32647 AP _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 34.17 2,390.56 ** 3,800.00 Budgeted 1,409.44 Remaining 63 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 112,333.21 .00 112,333.21 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 112,333.21 ** .00 Budgeted (112,333.21) Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 55 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 39 Totals: ------------------------------------------------------------------------------------------------ 300,463.33 ** 110,100.00 Budgeted (190,363.33) Remaining 273 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 108,391.07 .00 Budgeted (108,391.07) Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 56 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (56,911.00) .00 (56,911.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (56,911.00) ** .00 Budgeted 56,911.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (41,890.00) .00 (41,890.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (41,890.00) ** .00 Budgeted 41,890.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (98,801.00) ** .00 Budgeted 98,801.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (98,801.00) .00 Budgeted 98,801.00 Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 57 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 6/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-49005-000-000 Loan Proceeds (445,000.00) .00 (445,000.00) _______________ Account: 507-49005-000-000 Loan Proceeds Totals: .00 (445,000.00) ** (445,000.00) Budgeted .00 Remaining 100 % Used Account: 507-49010-000-000 Interest Income 1821 06/28/2013 Bank interest/June (49.33) (18.76) (68.09) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (18.76) (68.09) ** (100.00) Budgeted (31.91) Remaining 68 % Used Department Totals: ------------------------------------------------------------------------------------------------ (445,068.09) ** (445,100.00) Budgeted (31.91) Remaining 100 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 58 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 6/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-69005-010-001 Capital Expense 6,289.00 .00 6,289.00 _______________ Account: 507-69005-010-001 Capital Expense Totals: .00 6,289.00 ** 5,800.00 Budgeted (489.00) Remaining 108 % Used Account: 507-69280-010-002 Capital Repairs 1777 06/27/2013 June A/P Rate of Flow improvements 15,946.00 787.50 16,733.50 DELTATEK ENGINEERING 32704 AP _______________ Account: 507-69280-010-002 Capital Repairs Totals: 787.50 16,733.50 ** 165,000.00 Budgeted 148,266.50 Remaining 10 % Used Account: 507-69280-010-003 Capital Repairs 9,079.33 .00 9,079.33 _______________ Account: 507-69280-010-003 Capital Repairs Totals: .00 9,079.33 ** 210,000.00 Budgeted 200,920.67 Remaining 4 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 32,101.83 ** 380,800.00 Budgeted 348,698.17 Remaining 8 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 59 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 6/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-60335-020-000 Interfund Transfer Out (GF) 38,101.42 .00 38,101.42 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 38,101.42 ** .00 Budgeted (38,101.42) Remaining 0 % Used Account: 507-69005-020-001 Capital Expense 8,578.00 .00 8,578.00 _______________ Account: 507-69005-020-001 Capital Expense Totals: .00 8,578.00 ** 8,200.00 Budgeted (378.00) Remaining 105 % Used Account: 507-69005-020-004 Capital Expense .00 .00 _______________ Account: 507-69005-020-004 Capital Expense Totals: .00 .00 ** 18,000.00 Budgeted 18,000.00 Remaining 0 % Used Account: 507-69005-020-005 Capital Expense 8,553.92 .00 8,553.92 _______________ Account: 507-69005-020-005 Capital Expense Totals: .00 8,553.92 ** 10,000.00 Budgeted 1,446.08 Remaining 86 % Used Account: 507-69280-020-006 Capital Repairs 27,960.70 .00 27,960.70 _______________ Account: 507-69280-020-006 Capital Repairs Totals: .00 27,960.70 ** 28,000.00 Budgeted 39.30 Remaining 100 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 83,194.04 ** 64,200.00 Budgeted (18,994.04) Remaining 130 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ (329,772.22) (100.00) Budgeted 329,672.22 Remaining ########## TROPHY CLUB MUD #1 - I&S BALANCE SHEET JUNE 30, 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 687,176 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 12,812 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 704,834 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 12,812 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 12,812 FUND BALANCE ASSIGNED FUND BALANCE 136,417 NET REVENUES / EXPENDITURES 555,605 TOTAL FUND BALANCE 692,022 TOTAL LIABILITIES AND FUND BALANCE 704,834 . glbase_tbam tsisk Trophy Club MUD #1 Page 26 15:26 07/09/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 196,940.00- 196,940.00- 438.86- 197,345.03- 100.206 405.03 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 370.16- 2,917.64- 74.811 982.36- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 178.83- 1,585.91- 31.611 3,431.09- Subtotal: 205,857.00- 205,857.00- 987.85- 201,848.58- 98.053 4,008.42- 533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 161,000.00- 46.667 184,000.00- Subtotal: 345,000.00- 345,000.00- 161,000.00- 46.667 184,000.00- 533-49010-000-000 Interest Income 1,700.00- 1,700.00- 32.56- 272.90- 16.053 1,427.10- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 100.000 Subtotal: 309,700.00- 309,700.00- 32.56- 308,272.90- 99.539 1,427.10- Program number: 860,557.00- 860,557.00- 1,020.41- 671,121.48- 77.987 189,435.52- Department number: Revenues 860,557.00- 860,557.00- 1,020.41- 671,121.48- 77.987 189,435.52- Revenues Subtotal ----------- 860,557.00- 860,557.00- 1,020.41- 671,121.48- 77.987 189,435.52- . glbase_tbam tsisk Trophy Club MUD #1 Page 27 15:26 07/09/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 1,000.00 25.000 3,000.00 533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 114,516.25 50.000 114,516.75 533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00 Subtotal: 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Program number: 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Department number: Administration 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Expenditures Subtotal ----------- 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Fund number: 533 MUD 1 I&S Consolidated 22,524.00- 22,524.00- 1,020.41- 555,605.23- 2,466.725 533,081.23 ******* End of Report ********* . glpdatb2 tsisk Trophy Club MUD #1 Page 61 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/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 1788 06/03/2013 Property Taxes/Assessments (196,906.17) (16.00) (196,922.17) GL 1789 06/04/2013 Property Taxes/Assessments (.04) (196,922.21) GL 1790 06/05/2013 Property Taxes/Assessments (29.20) (196,951.41) GL 1791 06/06/2013 Property Taxes/Assessments (31.23) (196,982.64) GL 1792 06/07/2013 Property Taxes/Assessments (119.00) (197,101.64) GL 1794 06/11/2013 Property Taxes/Assessments (73.36) (197,175.00) GL 1795 06/17/2013 Property Taxes/Assessments (31.65) (197,206.65) GL 1798 06/21/2013 Property Taxes/Assessments (33.22) (197,239.87) GL 1799 06/24/2013 Property Taxes/Assessments (7.09) (197,246.96) GL 1800 06/25/2013 Property Taxes/Assessments (16.00) (197,262.96) GL 1801 06/26/2013 Property Taxes/Assessments (65.41) (197,328.37) GL 1823 06/27/2013 Property Taxes/Assessments (1.74) (197,330.11) GL 1822 06/28/2013 Property Taxes/Assessments (14.92) (197,345.03) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (438.86) (197,345.03) ** (196,940.00) Budgeted 405.03 Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1793 06/10/2013 Property Taxes/Assessments (2,547.48) (60.74) (2,608.22) GL 1794 06/11/2013 Property Taxes/Assessments (309.42) (2,917.64) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (370.16) (2,917.64) ** (3,900.00) Budgeted (982.36) Remaining 75 % Used Account: 533-40015-000-000 Property Taxes/P & I 1791 06/06/2013 Property Taxes/Assessments (1,407.08) (4.68) (1,411.76) GL 1792 06/07/2013 Property Taxes/Assessments (11.14) (1,422.90) GL 1793 06/10/2013 Property Taxes/Assessments (17.62) (1,440.52) GL 1794 06/11/2013 Property Taxes/Assessments (123.33) (1,563.85) GL 1795 06/17/2013 Property Taxes/Assessments (2.38) (1,566.23) GL 1798 06/21/2013 Property Taxes/Assessments (4.98) (1,571.21) GL 1800 06/25/2013 Property Taxes/Assessments (2.40) (1,573.61) GL 1801 06/26/2013 Property Taxes/Assessments (9.80) (1,583.41) GL 1823 06/27/2013 Property Taxes/Assessments (.26) (1,583.67) GL 1822 06/28/2013 Property Taxes/Assessments (2.24) (1,585.91) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (178.83) (1,585.91) ** (5,017.00) Budgeted (3,431.09) Remaining 32 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees . glpdatb2 tsisk Trophy Club MUD #1 Page 62 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (161,000.00) .00 (161,000.00) _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 (161,000.00) ** (345,000.00) Budgeted (184,000.00) Remaining 47 % Used Account: 533-49010-000-000 Interest Income 1821 06/28/2013 Bank interest/June (240.34) (32.56) (272.90) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (32.56) (272.90) ** (1,700.00) Budgeted (1,427.10) Remaining 16 % Used Account: 533-49015-000-000 Lease/Rental Income (308,000.00) .00 (308,000.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (671,121.48) ** (860,557.00) Budgeted (189,435.52) Remaining 78 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 63 15:33 07/09/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/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 1,000.00 .00 1,000.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,000.00 ** 4,000.00 Budgeted 3,000.00 Remaining 25 % Used Account: 533-70025-051-000 Bond Interest Expense 114,516.25 .00 114,516.25 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 114,516.25 ** 229,033.00 Budgeted 114,516.75 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 605,000.00 Budgeted 605,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 115,516.25 ** 838,033.00 Budgeted 722,516.75 Remaining 14 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (555,605.23) (22,524.00) Budgeted 533,081.23 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (1,396,008.52) **** (22,624.00) Budgeted 1,373,384.52 Remaining ########## ******* End of Report *********