Loading...
HomeMy WebLinkAbout2015-01 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JANUARY 2015 122 ASSETS FIRE DEPT. INVESTMENTS 1,218,051 PREPAID EXPENSES 12,793 ADVALOREM PROPERTY TAXES RECEIVABLE 121,974 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 34,992 UTILITY AND OTHER ACCOUNTS RECEIVABLE 10,561 TOTAL ASSETS 1,398,371 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 156,966 ACCOUNTS AND OTHER PAYABLES 14,803 TOTAL LIABILITIES 171,769 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 697,690 TOTAL FUND BALANCE 1,226,601 TOTAL LIABILITIES AND FUND BALANCE 1,398,371 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 16:39 02/11/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 357,462.00- 357,462.00- 59,599.97- 330,600.17- 92.485 26,861.83- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 108.28- 108.28 122-40010-000-000 Property Taxes/MUD Fire 872,859.00- 872,859.00- 292,602.32- 765,739.73- 87.728 107,119.27- 122-40011-000-000 Property Taxes/Fire-Delinquent 105.45 3,235.89- 3,235.89 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 17.33- 2.311 732.67- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 82.21- 1,037.71- 23.060 3,462.29- Subtotal: 1,235,571.00- 1,235,571.00- 352,179.05- 1,100,739.11- 89.087 134,831.89- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 2,800.00- 4,000.00- 66.667 2,000.00- Subtotal: 6,000.00- 6,000.00- 2,800.00- 4,000.00- 66.667 2,000.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 525.00- 750.00- 107.143 50.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,700.00- 10,700.00- 10,525.00- 10,750.00- 100.467 50.00 122-49035-000-000 Prior Year Reserves 125,669.00- 125,669.00- 125,670.00- 100.001 1.00 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 5,600.00- 8,000.00- 133.333 2,000.00 Subtotal: 131,669.00- 131,669.00- 5,600.00- 133,670.00- 101.520 2,001.00 Program number: 1,383,940.00- 1,383,940.00- 371,104.05- 1,249,159.11- 90.261 134,780.89- Department number: Fire Revenues 1,383,940.00- 1,383,940.00- 371,104.05- 1,249,159.11- 90.261 134,780.89- Revenues Subtotal ----------- 1,383,940.00- 1,383,940.00- 371,104.05- 1,249,159.11- 90.261 134,780.89- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 16:39 02/11/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 469,067.00 469,067.00 53,784.02 147,979.21 31.548 321,087.79 122-50010-045-000 Overtime 46,745.00 46,745.00 2,746.86 10,768.66 23.037 35,976.34 122-50011-045-000 DPS Holiday Pay 14,930.00 14,930.00 14,457.01 96.832 472.99 122-50016-045-000 Longevity 5,505.00 5,505.00 5,318.72 96.616 186.28 122-50017-045-000 Certification 4,800.00 4,800.00 462.50 1,506.50 31.385 3,293.50 122-50020-045-000 Retirement 91,396.00 91,396.00 7,589.91 25,463.18 27.860 65,932.82 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,945.11 17,768.89 30.031 41,400.11 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 378.11 1,376.17 31.348 3,013.83 122-50028-045-000 Vision Insurance 811.00 811.00 66.32 241.33 29.757 569.67 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 330.63 1,203.26 29.858 2,826.74 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 3,302.78 10,320.67 30.881 23,100.33 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 772.30 2,413.07 33.092 4,878.93 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 1,271.05 1,271.05 76.708 385.95 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 659.00 2,636.00 30.327 6,056.00 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 250.00 122-50075-045-000 Tuition Reimbursement 300.00 300.00 300.00 Subtotal: 752,455.00 752,455.00 76,308.59 242,723.72 32.258 509,731.28 122-55030-045-000 Software & Support 7,378.00 7,378.00 462.50 1,880.17 25.483 5,497.83 122-55045-045-000 Legal 1,500.00 1,500.00 1,500.00 122-55080-045-000 Maintenance & Repairs 18,552.00 18,552.00 1,972.87 3,209.88 17.302 15,342.12 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 372.74 1,767.86 14.732 10,232.14 Subtotal: 39,430.00 39,430.00 2,808.11 6,857.91 17.393 32,572.09 122-60005-045-000 Telephone 50.00 50.00 5.71 17.13 34.260 32.87 122-60010-045-000 Communications/Pagers/Mobiles 5,000.00 5,000.00 429.07 2,879.44 57.589 2,120.56 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 709.37 1,487.20 16.477 7,538.80 122-60025-045-000 Water 1,200.00 1,200.00 93.54 419.57 34.964 780.43 122-60026-045-000 Cable 1,920.00 1,920.00 19.94 615.04 32.033 1,304.96 122-60030-045-000 Rent And/Or Usage 211,829.00 211,829.00 211,829.00 122-60035-045-000 Postage 100.00 100.00 .48 8.64 8.640 91.36 122-60055-045-000 Insurance 12,179.00 12,179.00 940.09 3,760.36 30.876 8,418.64 122-60066-045-000 Publications/Books/Subscrips 200.00 200.00 40.05 219.05 109.525 19.05- 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 8,058.00 15,452.85 101.797 272.85- 122-60080-045-000 Schools & Training 4,280.00 4,280.00 865.00 1,181.00 27.593 3,099.00 122-60096-045-000 Emergency Management 1,400.00 1,400.00 220.00 15.714 1,180.00 122-60100-045-000 Travel & per diem 13,577.00 13,577.00 1,445.32 1,445.32 10.645 12,131.68 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 5,100.00 5,100.00 124.15 124.15 2.434 4,975.85 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 500.42 11.120 3,999.58 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 194.00 19.400 806.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 847.10 42.355 1,152.90 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 16:39 02/11/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 570.00 57.000 430.00 Subtotal: 291,541.00 291,541.00 12,730.72 29,941.27 10.270 261,599.73 122-65005-045-000 Fuel & Lube 10,454.00 10,454.00 406.64 2,159.52 20.657 8,294.48 122-65010-045-000 Uniforms 2,000.00 2,000.00 366.30 1,327.12 66.356 672.88 122-65015-045-000 Protective Clothing 5,200.00 15,200.00 405.00 405.00 2.664 14,795.00 122-65030-045-000 Chemicals 200.00 200.00 200.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 46.61 46.61 1.864 2,453.39 122-65055-045-000 Hardware 9,000.00 9,000.00 9,000.00 122-65085-045-000 Office Supplies 500.00 500.00 19.52 19.52 3.904 480.48 122-65105-045-000 Printing 548.00 548.00 38.17 6.965 509.83 Subtotal: 30,402.00 40,402.00 1,244.07 3,995.94 9.890 36,406.06 122-69005-045-000 Capital Outlays 250,000.00 250,000.00- 122-69008-045-000 Short Term Debt-Principal 158,262.00 158,262.00 158,262.00 122-69009-045-000 Short Term Debt-Interest 50,000.00 50,000.00 50,000.00 122-69050-045-000 Radios 23,500.00 23,500.00 23,500.00 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 17,950.00 17,950.00 100.000 122-69255-045-000 Airpacks 20,400.00 10,400.00 10,400.00 Subtotal: 270,112.00 260,112.00 267,950.00 103.013 7,838.00- Program number: 1,383,940.00 1,383,940.00 93,091.49 551,468.84 39.848 832,471.16 Department number: Fire 1,383,940.00 1,383,940.00 93,091.49 551,468.84 39.848 832,471.16 Expenditures Subtotal ----------- 1,383,940.00 1,383,940.00 93,091.49 551,468.84 39.848 832,471.16 Fund number: 122 Trophy Club MUD Fire Dept. 278,012.56- 697,690.27- 697,690.27 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 757 01/02/2015 Property Taxes/Assessments (271,000.20) (3,679.56) (274,679.76) GL 758 01/05/2015 Property Taxes/Assessments (1,651.00) (276,330.76) GL 759 01/06/2015 Property Taxes/Assessments (5,347.68) (281,678.44) GL 760 01/07/2015 Property Taxes/Assessments (753.81) (282,432.25) GL 764 01/08/2015 Property Taxes/Assessments (5,866.06) (288,298.31) GL 765 01/09/2015 Property Taxes/Assessments (1,964.27) (290,262.58) GL 766 01/12/2015 Property Taxes/Assessments (2,208.06) (292,470.64) GL 767 01/13/2015 Property Taxes/Assessments (1,398.70) (293,869.34) GL 768 01/14/2015 Property Taxes/Assessments (2,100.52) (295,969.86) GL 769 01/15/2015 Property Taxes/Assessments (1,851.83) (297,821.69) GL 770 01/16/2015 Property Taxes/Assessments (1,916.72) (299,738.41) GL 771 01/20/2015 Property Taxes/Assessments (766.91) (300,505.32) GL 772 01/21/2015 Property Taxes/Assessments (6,706.96) (307,212.28) GL 773 01/22/2015 Property Taxes/Assessments (2,678.28) (309,890.56) GL 774 01/23/2015 Property Taxes/Assessments (1,886.78) (311,777.34) GL 775 01/26/2015 Property Taxes/Assessments (4,293.84) (316,071.18) GL 776 01/27/2015 Property Taxes/Assessments (2,983.57) (319,054.75) GL 777 01/28/2015 Property Taxes/Assessments (1,682.45) (320,737.20) GL 778 01/29/2015 Property Taxes/Assessments (5,746.06) (326,483.26) GL 779 01/30/2015 Property Taxes/Assessments (4,116.91) (330,600.17) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (59,599.97) (330,600.17) ** (357,462.00) Budgeted (26,861.83) Remaining 92 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (108.28) .00 (108.28) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (108.28) ** .00 Budgeted 108.28 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 757 01/02/2015 Property Taxes/Assessments (473,137.41) (11,721.41) (484,858.82) GL 758 01/05/2015 Property Taxes/Assessments (5,828.20) (490,687.02) GL 759 01/06/2015 Property Taxes/Assessments (10,960.79) (501,647.81) GL 760 01/07/2015 Property Taxes/Assessments (6,585.79) (508,233.60) GL 764 01/08/2015 Property Taxes/Assessments (6,707.59) (514,941.19) GL 765 01/09/2015 Property Taxes/Assessments (5,988.07) (520,929.26) GL 766 01/12/2015 Property Taxes/Assessments (6,105.51) (527,034.77) GL 767 01/13/2015 Property Taxes/Assessments (1,961.21) (528,995.98) GL 768 01/14/2015 Property Taxes/Assessments (5,973.21) (534,969.19) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 769 01/15/2015 Property Taxes/Assessments (473,137.41) (8,569.51) (543,538.70) GL 770 01/16/2015 Property Taxes/Assessments (4,474.84) (548,013.54) GL 771 01/20/2015 Property Taxes/Assessments (2,922.07) (550,935.61) GL 772 01/21/2015 Property Taxes/Assessments (12,213.08) (563,148.69) GL 773 01/22/2015 Property Taxes/Assessments (5,648.87) (568,797.56) GL 774 01/23/2015 Property Taxes/Assessments (10,524.11) (579,321.67) GL 775 01/26/2015 Property Taxes/Assessments (14,853.24) (594,174.91) GL 776 01/27/2015 Property Taxes/Assessments (15,066.88) (609,241.79) GL 777 01/28/2015 Property Taxes/Assessments (115,657.08) (724,898.87) GL 778 01/29/2015 Property Taxes/Assessments (22,043.24) (746,942.11) GL 779 01/30/2015 Property Taxes/Assessments (18,797.62) (765,739.73) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (292,602.32) (765,739.73) ** (872,859.00) Budgeted (107,119.27) Remaining 88 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 758 01/05/2015 Property Taxes/Assessments (3,341.34) 76.18 (3,265.16) GL 759 01/06/2015 Property Taxes/Assessments (.02) (3,265.18) GL 765 01/09/2015 Property Taxes/Assessments 81.29 (3,183.89) GL 767 01/13/2015 Property Taxes/Assessments (52.00) (3,235.89) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 105.45 (3,235.89) ** .00 Budgeted 3,235.89 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I (17.33) .00 (17.33) _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 (17.33) ** (750.00) Budgeted (732.67) Remaining 2 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 757 01/02/2015 Property Taxes/Assessments (955.50) (5.74) (961.24) GL 759 01/06/2015 Property Taxes/Assessments (8.54) (969.78) GL 765 01/09/2015 Property Taxes/Assessments 31.93 (937.85) GL 766 01/12/2015 Property Taxes/Assessments (20.68) (958.53) GL 767 01/13/2015 Property Taxes/Assessments (12.47) (971.00) GL 770 01/16/2015 Property Taxes/Assessments (4.19) (975.19) GL 771 01/20/2015 Property Taxes/Assessments (62.20) (1,037.39) GL 772 01/21/2015 Property Taxes/Assessments (.32) (1,037.71) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (82.21) (1,037.71) ** (4,500.00) Budgeted (3,462.29) Remaining 23 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (1,200.00) (2,800.00) (4,000.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (2,800.00) (4,000.00) ** (6,000.00) Budgeted (2,000.00) Remaining 67 % Used Account: 122-43400-000-000 Fire Inspections 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (225.00) (525.00) (750.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (525.00) (750.00) ** (700.00) Budgeted 50.00 Remaining 107 % Used Account: 122-43415-000-000 Denton County Pledge-Fire 681 01/16/2015 Denton County Fire Pledge (10,000.00) (10,000.00) GL _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: (10,000.00) (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49035-000-000 Prior Year Reserves (125,670.00) .00 (125,670.00) _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 (125,670.00) ** (125,669.00) Budgeted 1.00 Remaining 100 % Used Account: 122-49900-000-000 Miscellaneous Income 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (2,400.00) (5,600.00) (8,000.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (5,600.00) (8,000.00) ** (6,000.00) Budgeted 2,000.00 Remaining 133 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,249,159.11) ** (1,383,940.00) Budgeted (134,780.89) Remaining 90 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 630 01/02/2015 Fire Payroll 1/2/15 94,195.19 17,638.82 111,834.01 GL 649 01/16/2015 FD Payroll 1/16/15 18,441.37 130,275.38 GL 753 01/30/2015 FD Payroll 1/30/15 17,703.83 147,979.21 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 53,784.02 147,979.21 ** 469,067.00 Budgeted 321,087.79 Remaining 32 % Used Account: 122-50010-045-000 Overtime 649 01/16/2015 FD Payroll 1/16/15 8,021.80 2,746.86 10,768.66 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,746.86 10,768.66 ** 46,745.00 Budgeted 35,976.34 Remaining 23 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,457.01 .00 14,457.01 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,457.01 ** 14,930.00 Budgeted 472.99 Remaining 97 % Used Account: 122-50016-045-000 Longevity 5,318.72 .00 5,318.72 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,318.72 ** 5,505.00 Budgeted 186.28 Remaining 97 % Used Account: 122-50017-045-000 Certification 630 01/02/2015 Fire Payroll 1/2/15 1,044.00 462.50 1,506.50 GL _______________ Account: 122-50017-045-000 Certification Totals: 462.50 1,506.50 ** 4,800.00 Budgeted 3,293.50 Remaining 31 % Used Account: 122-50020-045-000 Retirement 630 01/02/2015 Fire Payroll 1/2/15 17,873.27 2,427.92 20,301.19 GL 649 01/16/2015 FD Payroll 1/16/15 2,792.11 23,093.30 GL 753 01/30/2015 FD Payroll 1/30/15 2,369.88 25,463.18 GL _______________ Account: 122-50020-045-000 Retirement Totals: 7,589.91 25,463.18 ** 91,396.00 Budgeted 65,932.82 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 630 01/02/2015 Fire Payroll 1/2/15 12,823.78 2,798.44 15,622.22 GL 649 01/16/2015 FD Payroll 1/16/15 2,146.67 17,768.89 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,945.11 17,768.89 ** 59,169.00 Budgeted 41,400.11 Remaining 30 % Used Account: 122-50027-045-000 Dental Insurance 630 01/02/2015 Fire Payroll 1/2/15 998.06 189.05 1,187.11 GL 649 01/16/2015 FD Payroll 1/16/15 189.06 1,376.17 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 378.11 1,376.17 ** 4,390.00 Budgeted 3,013.83 Remaining 31 % Used Account: 122-50028-045-000 Vision Insurance 630 01/02/2015 Fire Payroll 1/2/15 175.01 33.17 208.18 GL 649 01/16/2015 FD Payroll 1/16/15 33.15 241.33 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 66.32 241.33 ** 811.00 Budgeted 569.67 Remaining 30 % Used Account: 122-50029-045-000 Life Insurance & Other 630 01/02/2015 Fire Payroll 1/2/15 872.63 165.30 1,037.93 GL 649 01/16/2015 FD Payroll 1/16/15 165.33 1,203.26 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 330.63 1,203.26 ** 4,030.00 Budgeted 2,826.74 Remaining 30 % Used Account: 122-50030-045-000 Social Security Taxes 630 01/02/2015 Fire Payroll 1/2/15 7,017.89 1,005.75 8,023.64 GL 649 01/16/2015 FD Payroll 1/16/15 1,199.45 9,223.09 GL 753 01/30/2015 FD Payroll 1/30/15 1,097.58 10,320.67 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,302.78 10,320.67 ** 33,421.00 Budgeted 23,100.33 Remaining 31 % Used Account: 122-50035-045-000 Medicare Taxes 630 01/02/2015 Fire Payroll 1/2/15 1,640.77 235.19 1,875.96 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 649 01/16/2015 FD Payroll 1/16/15 1,640.77 280.47 2,156.43 GL 753 01/30/2015 FD Payroll 1/30/15 256.64 2,413.07 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 772.30 2,413.07 ** 7,292.00 Budgeted 4,878.93 Remaining 33 % Used Account: 122-50040-045-000 Unemployment Taxes 630 01/02/2015 Fire Payroll 1/2/15 415.36 415.36 GL 649 01/16/2015 FD Payroll 1/16/15 487.24 902.60 GL 753 01/30/2015 FD Payroll 1/30/15 368.45 1,271.05 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 1,271.05 1,271.05 ** 1,657.00 Budgeted 385.95 Remaining 77 % Used Account: 122-50045-045-000 Workman's Compensation 194 01/01/2015 Jan TML Ins & Workers Comp 1,977.00 659.00 2,636.00 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 659.00 2,636.00 ** 8,692.00 Budgeted 6,056.00 Remaining 30 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 800 01/31/2015 Jan A/P Nevill, Charter 1,417.67 462.50 1,880.17 TOWN OF TROPHY CLUB AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 1,880.17 ** 7,378.00 Budgeted 5,497.83 Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55045-045-000 Legal .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 625 01/13/2015 Jan A/P Q681 Aerial Insp, 164' ground 1,237.01 921.00 2,158.01 CONSOLIDATED FLEET SERVICES 34512 AP 781 01/26/2015 PCards 12/27/14-1/26/15 SAMS CLUB #4795 161.93 2,319.94 SAMS CLUB #4795 PC 696 01/27/2015 Jan A/P Rug Service 32.29 2,352.23 G & K SERVICES 34596 AP 696 01/27/2015 Jan A/P Rug Service 32.29 2,384.52 G & K SERVICES 34596 AP 696 01/27/2015 Jan A/P Annual Service/Bauer Air Syste 706.87 3,091.39 AUGUST INDUSTRIES, INC 34587 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (32.29) 3,059.10 AR 800 01/31/2015 Jan A/P Supplies 150.78 3,209.88 COSTCO WHOLESALE AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,972.87 3,209.88 ** 18,552.00 Budgeted 15,342.12 Remaining 17 % Used Account: 122-55090-045-000 Vehicle Maintenance 696 01/27/2015 Jan A/P Q681 Remove and Replace hoses 1,395.12 372.74 1,767.86 SIDDONS-MARTIN EMERGENCY GROUP 34615 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 372.74 1,767.86 ** 12,000.00 Budgeted 10,232.14 Remaining 15 % Used Account: 122-60005-045-000 Telephone 696 01/27/2015 Jan A/P IT BOA charges 11.42 5.71 17.13 TOWN OF TROPHY CLUB 34619 AP _______________ Account: 122-60005-045-000 Telephone Totals: 5.71 17.13 ** 50.00 Budgeted 32.87 Remaining 34 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 630 01/02/2015 Fire Payroll 1/2/15 2,450.37 37.50 2,487.87 GL 645 01/16/2015 Void A/P Ck 34205/Denton Cty Communications Agreement/Dispa (4,431.00) (1,943.13) Denton County 34205 AP 662 01/19/2015 Jan A/P Reissue check #34205 lost in m 4,431.00 2,487.87 Denton County 34570 AP 696 01/27/2015 Jan A/P Verizon, GEXA 391.57 2,879.44 TOWN OF TROPHY CLUB 34619 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 429.07 2,879.44 ** 5,000.00 Budgeted 2,120.56 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60020-045-000 Electricity/Gas 666 01/21/2015 Jan A/P Electricity 12/11/14 - 01/12/1 777.83 797.36 1,575.19 HUDSON ENERGY SERVICES, LLC 34577 AP 696 01/27/2015 Jan A/P Electricity 12/19-1/20/15 Fire 621.38 2,196.57 ATMOS ENERGY 34586 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (709.37) 1,487.20 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 709.37 1,487.20 ** 9,026.00 Budgeted 7,538.80 Remaining 16 % Used Account: 122-60025-045-000 Water 732 01/31/2015 January A/P January water 326.03 135.27 461.30 TROPHY CLUB MUD (WATER BILLS) 34620 AP 732 01/31/2015 January A/P January water 51.81 513.11 TROPHY CLUB MUD (WATER BILLS) 34620 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (93.54) 419.57 AR _______________ Account: 122-60025-045-000 Water Totals: 93.54 419.57 ** 1,200.00 Budgeted 780.43 Remaining 35 % Used Account: 122-60026-045-000 Cable 603 01/09/2015 Firefighter Asso/Dec,Jan Cable 595.10 (267.04) 328.06 GL 787 01/09/2015 Corr Dep/Fire Cable (.60) 327.46 GL 781 01/26/2015 PCards 12/27/14-1/26/15 ATT*BILL PAYMENT 158.76 486.22 ATT*BILL PAYMENT PC 781 01/26/2015 PCards 12/27/14-1/26/15 ATT*BILL PAYMENT 128.82 615.04 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 19.94 615.04 ** 1,920.00 Budgeted 1,304.96 Remaining 32 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 211,829.00 Budgeted 211,829.00 Remaining 0 % Used Account: 122-60035-045-000 Postage 657 01/31/2015 Jan 2015 MUD Postage meter 8.16 .48 8.64 UB _______________ Account: 122-60035-045-000 Postage Totals: .48 8.64 ** 100.00 Budgeted 91.36 Remaining 9 % Used Account: 122-60055-045-000 Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 194 01/01/2015 Jan TML Ins & Workers Comp 2,820.27 940.09 3,760.36 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.09 3,760.36 ** 12,179.00 Budgeted 8,418.64 Remaining 31 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 781 01/26/2015 PCards 12/27/14-1/26/15 NFPA NATL FIRE PROTECT 179.00 40.05 219.05 NFPA NATL FIRE PROTECT PC _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: 40.05 219.05 ** 200.00 Budgeted (19.05) Remaining 110 % Used Account: 122-60070-045-000 Dues & Memberships 696 01/27/2015 Jan A/P Annual membership dues 7,394.85 280.00 7,674.85 DENTON CO FIRE CHIEFS ASSOC 34593 AP 696 01/27/2015 Jan A/P FY 14-15 Capital Replacement D 7,778.00 15,452.85 NORTH EAST FIRE DEPT ASSOC 34610 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 8,058.00 15,452.85 ** 15,180.00 Budgeted (272.85) Remaining 102 % Used Account: 122-60080-045-000 Schools & Training 781 01/26/2015 PCards 12/27/14-1/26/15 TEXAS FIRE CHIEFS ASSO 316.00 310.00 626.00 TEXAS FIRE CHIEFS ASSO PC 696 01/27/2015 Jan A/P TCC Life Fire Training 555.00 1,181.00 NORTH EAST FIRE DEPT ASSOC 34610 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 865.00 1,181.00 ** 4,280.00 Budgeted 3,099.00 Remaining 28 % Used Account: 122-60096-045-000 Emergency Management 220.00 .00 220.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 220.00 ** 1,400.00 Budgeted 1,180.00 Remaining 16 % Used Account: 122-60100-045-000 Travel & per diem 781 01/26/2015 PCards 12/27/14-1/26/15 EMBASSY SUITES 633.55 633.55 EMBASSY SUITES PC 781 01/26/2015 PCards 12/27/14-1/26/15 EMBASSY SUITES 641.55 1,275.10 EMBASSY SUITES PC 781 01/26/2015 PCards 12/27/14-1/26/15 OUTBACK 4429 58.12 1,333.22 OUTBACK 4429 PC 781 01/26/2015 PCards 12/27/14-1/26/15 GARCIAS MEXICAN FO 28.19 1,361.41 GARCIAS MEXICAN FO PC 781 01/26/2015 PCards 12/27/14-1/26/15 RED LOBSTER US00008441 56.18 1,417.59 RED LOBSTER US00008441 PC 781 01/26/2015 PCards 12/27/14-1/26/15 EMBASSY-ROCKY RIVER GR 27.73 1,445.32 EMBASSY-ROCKY RIVER GR PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60100-045-000 Travel & per diem Totals: 1,445.32 1,445.32 ** 13,577.00 Budgeted 12,131.68 Remaining 11 % 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 781 01/26/2015 PCards 12/27/14-1/26/15 FASTSIGNS 124.15 124.15 FASTSIGNS PC _______________ Account: 122-60125-045-000 Advertising Totals: 124.15 124.15 ** 5,100.00 Budgeted 4,975.85 Remaining 2 % Used Account: 122-60160-045-000 Programs & Special Projects 500.42 .00 500.42 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 500.42 ** 4,500.00 Budgeted 3,999.58 Remaining 11 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 194.00 .00 194.00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 194.00 ** 1,000.00 Budgeted 806.00 Remaining 19 % Used Account: 122-60195-045-000 Flags & Repair 847.10 .00 847.10 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 847.10 ** 2,000.00 Budgeted 1,152.90 Remaining 42 % Used Account: 122-60245-045-000 Miscellaneous Expense 570.00 .00 570.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 570.00 ** 1,000.00 Budgeted 430.00 Remaining 57 % Used Account: 122-65005-045-000 Fuel & Lube 696 01/27/2015 Jan A/P 12/25-1/14/15 Fuel 1,752.88 406.64 2,159.52 US Bank Voyager Fleet Systems 34622 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 406.64 2,159.52 ** 10,454.00 Budgeted 8,294.48 Remaining 21 % Used Account: 122-65010-045-000 Uniforms 662 01/19/2015 Jan A/P Backordered Belt 960.82 39.99 1,000.81 GST PUBLIC SAFETY SUPPLY 34574 AP 662 01/19/2015 Jan A/P 100 uniform patches 317.21 1,318.02 EMBLEM ENTERPRISES INC 34571 AP 662 01/19/2015 Jan A/P Uniforms 745.66 2,063.68 GST PUBLIC SAFETY SUPPLY 34574 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (736.56) 1,327.12 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 366.30 1,327.12 ** 2,000.00 Budgeted 672.88 Remaining 66 % Used Account: 122-65015-045-000 Protective Clothing 696 01/27/2015 Jan A/P Helmet and Helmet fronts 405.00 405.00 CASCO INDUSTRIES INC 34591 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 405.00 405.00 ** 15,200.00 Budgeted 14,795.00 Remaining 3 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 781 01/26/2015 PCards 12/27/14-1/26/15 THE HOME DEPOT 6581 46.61 46.61 THE HOME DEPOT 6581 PC _______________ Account: 122-65035-045-000 Small Tools Totals: 46.61 46.61 ** 2,500.00 Budgeted 2,453.39 Remaining 2 % Used Account: 122-65055-045-000 Hardware . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-65055-045-000 Hardware Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies 662 01/19/2015 Jan A/P Office supplies 19.52 19.52 OFFICE DEPOT, INC 34579 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 19.52 19.52 ** 500.00 Budgeted 480.48 Remaining 4 % Used Account: 122-65105-045-000 Printing 38.17 .00 38.17 _______________ Account: 122-65105-045-000 Printing Totals: .00 38.17 ** 548.00 Budgeted 509.83 Remaining 7 % Used Account: 122-69005-045-000 Capital Outlays 250,000.00 .00 250,000.00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 250,000.00 ** .00 Budgeted (250,000.00) Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 158,262.00 Budgeted 158,262.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt-Interest .00 .00 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 23,500.00 Budgeted 23,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 .00 17,950.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 17,950.00 ** 17,950.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 10,400.00 Budgeted 10,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 551,468.84 ** 1,383,940.00 Budgeted 832,471.16 Remaining 40 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (697,690.27) .00 Budgeted 697,690.27 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JANUARY 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 1/31/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 333,307 - - 333,307 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,506,272 - - 1,506,272 INVESTMENTS-TEXPOOL 1,556,992 169,600 23,704 1,750,296 PREPAID EXPENSES 53,209 - - 53,209 ADVALOREM PROPERTY TAXES RECEIVABLE 22,562 - - 22,562 UTILITY AND OTHER ACCOUNTS RECEIVABLE 494,058 - - 494,058 - TOTAL ASSETS 3,967,000 169,600 23,704 4,160,304 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 22,562 - - 22,562 ACCOUNTS AND OTHER PAYABLES 468,804 - 15,531 484,335 CUSTOMER DEPOSITS 298,062 - - 298,062 - TOTAL LIABILITIES 789,428 - 15,531 804,959 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 260,697 260,697 NON-SPENDABLE FUND BALANCE 13,980 13,980 ASSIGNED FUND BALANCE 1,409,006 10,268 1,419,274 UNASSIGNED FUND BALANCE 725,069 - - 725,069 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES 1,029,518 (91,097) (2,095) 936,326 - TOTAL FUND BALANCE 3,177,572 169,600 8,173 3,355,345 - TOTAL LIABILITIES AND FUND BALANCE 3,967,000 169,600 23,704 4,160,304 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 167,857.00- 167,857.00- 56,271.14- 147,261.48- 87.730 20,595.52- 135-40002-000-000 Property Taxes/Delinquent 10.77 346.65- 346.65 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 17.47- 139.06- 15.451 760.94- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 11,516.60- 45,737.10- 34.133 88,259.90- Subtotal: 302,754.00- 302,754.00- 67,794.44- 193,484.29- 63.908 109,269.71- 135-47000-000-000 Water 5,286,045.00- 5,286,045.00- 185,028.13- 1,009,054.37- 19.089 4,276,990.63- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 139,816.66- 642,718.03- 28.301 1,628,263.97- 135-47025-000-000 Penalties 63,416.00- 63,416.00- 7,881.32- 34,169.70- 53.882 29,246.30- 135-47030-000-000 Service Charges 8,000.00- 8,000.00- 803.00- 3,637.00- 45.463 4,363.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 600.00- 1,200.00- 60.000 800.00- 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 1,800.00- 3,600.00- 72.000 1,400.00- 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 280.70- 13,078.80- 15.065 73,736.20- Subtotal: 7,722,258.00- 7,722,258.00- 336,209.81- 1,707,457.90- 22.111 6,014,800.10- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 11,500.00- 59,800.00- 32.500 124,200.00- Subtotal: 184,000.00- 184,000.00- 11,500.00- 59,800.00- 32.500 124,200.00- 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 559.58- 2,070.49- 41.410 2,929.51- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 3,642.12- 35.834 6,521.88- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,333.32- 33.333 4,666.68- 135-49030-000-000 Vending Revenue 351.00- 351.00- 351.00- 135-49036-000-000 GASB Reserves 74,706.00- 74,706.00- 74,706.00- 100.000 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 5,831.00- 16,677.57- 19.854 67,322.43- 135-49145-000-000 Intergov Transfer-General Fund 1,074,337.15- 1,074,337.15- 1,074,337.15 135-49900-000-000 Miscellaneous Income 54,000.00- 88,600.00- 23.88- 34,857.09- 39.342 53,742.91- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 12.20- 12.200 87.80- Subtotal: 235,321.00- 269,921.00- 1,082,245.47- 1,208,635.94- 447.774 938,714.94 Program number: 8,444,333.00- 8,478,933.00- 1,497,749.72- 3,169,378.13- 37.379 5,309,554.87- Department number: Revenues 8,444,333.00- 8,478,933.00- 1,497,749.72- 3,169,378.13- 37.379 5,309,554.87- Revenues Subtotal ----------- 8,444,333.00- 8,478,933.00- 1,497,749.72- 3,169,378.13- 37.379 5,309,554.87- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 301,101.00 301,101.00 19,819.72 58,375.75 19.387 242,725.25 135-50010-010-000 Overtime 19,500.00 19,500.00 1,335.77 4,175.16 21.411 15,324.84 135-50016-010-000 Longevity 5,343.00 5,343.00 2,705.00 50.627 2,638.00 135-50017-010-000 Certification 4,800.00 4,800.00 225.00 925.00 19.271 3,875.00 135-50020-010-000 Retirement 29,349.00 29,349.00 1,905.00 5,928.09 20.199 23,420.91 135-50026-010-000 Medical Insurance 44,988.00 44,988.00 2,186.69 7,791.31 17.319 37,196.69 135-50027-010-000 Dental Insurance 3,288.00 3,288.00 178.96 622.78 18.941 2,665.22 135-50028-010-000 Vision Insurance 834.00 834.00 40.41 147.66 17.705 686.34 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 136.48 570.08 18.545 2,503.92 135-50030-010-000 Social Security Taxes 21,135.00 21,135.00 1,321.64 4,068.15 19.248 17,066.85 135-50035-010-000 Medicare Taxes 4,943.00 4,943.00 309.11 951.45 19.248 3,991.55 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 491.75 491.75 39.593 750.25 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 857.91 3,431.64 21.421 12,588.36 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,000.00 207.45 586.85 58.685 413.15 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 456,917.00 456,917.00 29,015.89 90,770.67 19.866 366,146.33 135-55005-010-000 Engineering 10,000.00 10,000.00 10,000.00 135-55080-010-000 Maintenance & Repairs 71,242.00 71,242.00 6,181.54 27,384.96 38.439 43,857.04 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 126.00 2,375.48 29.694 5,624.52 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 243.00 6.943 3,257.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 270.00 1,200.26 21.823 4,299.74 Subtotal: 98,242.00 98,242.00 6,577.54 31,203.70 31.762 67,038.30 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 397.49 1,299.97 26.460 3,613.03 135-60020-010-000 Electricity 170,765.00 170,765.00 8,221.16 36,565.84 21.413 134,199.16 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,138.00 4,138.00 50.00 1.208 4,088.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 1,500.00 1,500.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 3,722.70 20,924.06 42.464 28,350.94 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 125,292.56 463,024.49 15.812 2,465,283.51 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 818.25 23.379 2,681.75 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 3,500.00 3,500.00 Subtotal: 3,169,249.00 3,169,249.00 137,633.91 522,682.61 16.492 2,646,566.39 135-65005-010-000 Fuel & Lube 29,172.00 29,172.00 738.12 4,329.13 14.840 24,842.87 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,620.00 3,620.00 506.48 606.47 16.753 3,013.53 135-65030-010-000 Chemicals 7,000.00 7,000.00 1,038.84 3,754.41 53.634 3,245.59 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 141.75 14.175 858.25 135-65050-010-000 Meter Expense 161,500.00 161,500.00 1,510.00 12,815.00 7.935 148,685.00 Subtotal: 203,492.00 203,492.00 3,793.44 21,646.76 10.638 181,845.24 135-69005-010-000 Capital Outlays 1,089,006.00 1,177,566.00 92,045.56 7.817 1,085,520.44 135-69008-010-000 Short Term Debt-Principal 129,000.00 129,000.00 129,000.00 135-69009-010-000 Short Term Debt-Interest 3,612.00 3,612.00 3,612.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 151,507.00 151,507.00 37,787.73 118,774.42 78.395 32,732.58 Subtotal: 1,448,125.00 1,536,685.00 37,787.73 285,819.98 18.600 1,250,865.02 Program number: 5,376,025.00 5,464,585.00 214,808.51 952,123.72 17.424 4,512,461.28 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 80.00 2,017.63 40.353 2,982.37 Subtotal: 5,000.00 5,000.00 80.00 2,017.63 40.353 2,982.37 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 80.00 2,017.63 20.176 7,982.37 Department number: Water 5,386,025.00 5,474,585.00 214,888.51 954,141.35 17.429 4,520,443.65 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 305,744.00 305,744.00 34,178.10 95,255.85 31.155 210,488.15 135-50010-020-000 Overtime 19,500.00 19,500.00 3,362.77 9,343.90 47.917 10,156.10 135-50016-020-000 Longevity 5,617.00 5,617.00 5,615.00 99.964 2.00 135-50017-020-000 Certification 6,600.00 6,600.00 550.00 2,200.00 33.333 4,400.00 135-50020-020-000 Retirement 29,948.00 29,948.00 3,393.90 10,068.16 33.619 19,879.84 135-50026-020-000 Medical Insurance 61,001.00 61,001.00 5,083.22 18,244.39 29.908 42,756.61 135-50027-020-000 Dental Insurance 4,146.00 4,146.00 335.97 1,167.45 28.158 2,978.55 135-50028-020-000 Vision Insurance 990.00 990.00 74.94 273.39 27.615 716.61 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 286.94 1,089.76 34.119 2,104.24 135-50030-020-000 Social Security Taxes 21,680.00 21,680.00 2,163.38 6,227.64 28.725 15,452.36 135-50035-020-000 Medicare Taxes 5,070.00 5,070.00 505.96 1,456.46 28.727 3,613.54 135-50040-020-000 Unemployment Taxes 1,242.00 1,242.00 876.08 876.08 70.538 365.92 135-50045-020-000 Workman's Compensation 16,020.00 16,020.00 857.91 3,431.64 21.421 12,588.36 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 126.00 126.00 84.000 24.00 135-50070-020-000 Employee Relations 550.00 550.00 129.38 383.19 69.671 166.81 Subtotal: 481,452.00 481,452.00 51,924.55 155,758.91 32.352 325,693.09 135-55005-020-000 Engineering 38.24 38.24 38.24- 135-55080-020-000 Maintenance & Repairs 58,000.00 58,000.00 5,673.29 38,754.73 66.819 19,245.27 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 114.09 1,377.79 45.926 1,622.21 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 3.99 21.27 4.254 478.73 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 11,579.63 22,860.10 41.564 32,139.90 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 3,472.50 9,095.50 36.382 15,904.50 Subtotal: 141,500.00 141,500.00 20,881.74 72,147.63 50.988 69,352.37 135-60010-020-000 Communications/Pagers/Mobiles 4,662.00 4,662.00 741.27 1,763.15 37.820 2,898.85 135-60020-020-000 Electricity 149,292.00 149,292.00 11,368.28 40,712.65 27.270 108,579.35 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 134.85 33.713 265.15 135-60070-020-000 Dues & Memberships 250.00 250.00 250.00 135-60080-020-000 Schools & Training 4,065.00 4,065.00 445.00 796.00 19.582 3,269.00 135-60090-020-000 Safety Program 550.00 550.00 550.00 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 96.47 201.05 12.566 1,398.95 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 9,019.00 52.589 8,131.00 135-60245-020-000 Miscellaneous Expenses 300.00 300.00 300.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 Subtotal: 187,769.00 187,769.00 12,651.02 52,626.70 28.027 135,142.30 135-65005-020-000 Fuel & Lube 36,328.00 36,328.00 696.71 7,721.14 21.254 28,606.86 135-65010-020-000 Uniforms 2,778.00 2,778.00 2,365.97 85.168 412.03 135-65030-020-000 Chemicals 30,000.00 30,000.00 2,348.27 4,507.65 15.026 25,492.35 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-020-000 Small Tools 2,000.00 2,000.00 43.92 502.25 25.113 1,497.75 135-65040-020-000 Safety Equipment 750.00 750.00 162.00 21.600 588.00 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 5,600.04 43.077 7,399.96 Subtotal: 84,856.00 84,856.00 3,088.90 20,859.05 24.582 63,996.95 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 80,942.00 53.961 69,058.00 135-69007-020-000 LTD Payment from WW Sales 357,538.00 295,933.00 295,933.00 135-69008-020-000 Short Term Debt-Principal 56,991.00 56,991.00 56,991.00 135-69009-020-000 Short Term Debt-Interest 2,011.00 2,011.00 2,011.00 Subtotal: 566,540.00 504,935.00 80,942.00 16.030 423,993.00 Program number: 1,462,117.00 1,400,512.00 88,546.21 382,334.29 27.300 1,018,177.71 Department number: Wastewater 1,462,117.00 1,400,512.00 88,546.21 382,334.29 27.300 1,018,177.71 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 2,100.00 4,600.00 46.000 5,400.00 135-50030-026-000 Social Security Taxes 620.00 620.00 130.20 285.20 46.000 334.80 135-50035-026-000 Medicare Taxes 145.00 145.00 30.45 66.70 46.000 78.30 135-50040-026-000 Unemployment Taxes 230.00 230.00 48.30 105.80 46.000 124.20 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 11.76 32.667 24.24 Subtotal: 11,031.00 11,031.00 2,311.89 5,069.46 45.956 5,961.54 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 1,200.00 13.92 124.87 10.406 1,075.13 135-60080-026-000 Schools & Training 4,000.00 4,000.00 975.00 24.375 3,025.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,329.96 1,329.96 26.599 3,670.04 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 50.00 5.000 950.00 Subtotal: 11,850.00 11,850.00 1,343.88 2,514.83 21.222 9,335.17 Program number: 22,881.00 22,881.00 3,655.77 7,584.29 33.147 15,296.71 Department number: Board of Directors 22,881.00 22,881.00 3,655.77 7,584.29 33.147 15,296.71 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 477,578.00 477,578.00 52,845.53 146,165.36 30.606 331,412.64 135-50010-030-000 Overtime 1,000.00 1,000.00 25.40 77.17 7.717 922.83 135-50016-030-000 Longevity 3,283.00 3,283.00 3,282.50 99.985 .50 135-50020-030-000 Retirement 42,840.00 42,840.00 4,710.80 13,390.35 31.257 29,449.65 135-50026-030-000 Medical Insurance 65,015.00 65,015.00 4,915.06 18,215.08 28.017 46,799.92 135-50027-030-000 Dental Insurance 4,944.00 4,944.00 364.24 1,277.80 25.845 3,666.20 135-50028-030-000 Vision Insurance 1,158.00 1,158.00 84.38 303.83 26.237 854.17 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 365.65 1,409.79 32.536 2,923.21 135-50030-030-000 Social Security Taxes 30,079.00 30,079.00 3,165.38 8,808.26 29.284 21,270.74 135-50035-030-000 Medicare Taxes 7,422.00 7,422.00 740.28 2,059.96 27.755 5,362.04 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 1,105.06 1,231.20 84.969 217.80 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 349.20 21.345 1,286.80 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 38.00 7.600 462.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 79.26 2,221.64 44.433 2,778.36 Subtotal: 646,237.00 646,237.00 68,488.34 198,830.14 30.767 447,406.86 135-55030-030-000 Software & Support 75,588.00 87,423.00 3,120.87 68,406.26 78.247 19,016.74 135-55070-030-000 Independent Labor 8,000.00 32,550.00 75.00 9,018.75 27.707 23,531.25 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 4,500.00 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 549.07 2,675.38 41.160 3,824.62 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 627.53 1,882.59 23.242 6,217.41 135-55160-030-000 Professional Outside Services 58,000.00 58,000.00 3,950.00 41,027.95 70.738 16,972.05 135-55161-030-000 Town Personnel Contract 6,170.00 26,170.00 20,000.00 76.423 6,170.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 595.95 2,419.80 29.510 5,780.20 Subtotal: 175,258.00 231,643.00 8,918.42 145,430.73 62.782 86,212.27 135-60005-030-000 Telephone 13,361.00 13,361.00 1,040.67 3,332.81 24.944 10,028.19 135-60010-030-000 Communications/Pagers/Mobiles 4,056.00 4,056.00 315.61 1,328.90 32.764 2,727.10 135-60020-030-000 Electricity/Gas 14,978.00 14,978.00 1,073.02 1,414.47 9.444 13,563.53 135-60025-030-000 Water 1,500.00 1,500.00 53.46 313.48 20.899 1,186.52 135-60035-030-000 Postage 28,500.00 28,500.00 1,945.13 9,594.80 33.666 18,905.20 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 4,407.49 13,968.73 43.652 18,031.27 135-60050-030-000 Bad Debt Expense 6,200.00 6,200.00 303.44 4.894 5,896.56 135-60055-030-000 Insurance 48,751.00 48,751.00 4,063.01 16,285.29 33.405 32,465.71 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 151.00 15.100 849.00 135-60070-030-000 Dues & Memberships 5,000.00 5,000.00 4,055.95 81.119 944.05 135-60075-030-000 Meetings 400.00 400.00 25.11 6.278 374.89 135-60079-030-000 Public Education 5,000.00 5,000.00 5,000.00 135-60080-030-000 Schools & Training 10,235.00 10,235.00 268.00 2.618 9,967.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 133.91 511.74 9.477 4,888.26 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 47.28 239.28 9.571 2,260.72 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 3,366.65 19.238 14,133.35 135-60270-030-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 135-60360-030-000 Furniture/Equipment < $5000 10,475.00 10,475.00 5,035.96 48.076 5,439.04 Subtotal: 218,406.00 218,406.00 13,079.58 60,195.61 27.561 158,210.39 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,043.00 56.226 812.00 135-65055-030-000 Hardware 75,966.00 35,226.00 41,927.16- 31,857.24 90.437 3,368.76 135-65085-030-000 Office Supplies 9,000.00 9,000.00 1,026.32 2,337.27 25.970 6,662.73 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 253.10 5.349 4,478.90 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 332.06 1,621.60 32.432 3,378.40 135-65097-030-000 Vending Machine Supplies 200.00 200.00 200.00 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 Subtotal: 101,553.00 60,813.00 40,568.78- 37,112.21 61.027 23,700.79 135-69005-030-000 Capital Outlays 125,000.00 67,000.00 61,726.66 61,726.66 92.129 5,273.34 135-69170-030-000 Copier Lease Installments 4,236.00 4,236.00 299.70 947.71 22.373 3,288.29 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 16,329.00 16,329.00 100.000 Subtotal: 145,565.00 87,565.00 62,026.36 79,003.37 90.223 8,561.63 Program number: 1,287,019.00 1,244,664.00 111,943.92 520,572.06 41.824 724,091.94 Department number: Administration 1,287,019.00 1,244,664.00 111,943.92 520,572.06 41.824 724,091.94 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 16:39 02/11/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 250,000.00 300,000.00 39,347.56 251,736.35 83.912 48,263.65 135-55055-039-000 Auditing 22,491.00 22,491.00 16,836.00 16,836.00 74.857 5,655.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 40.97 4,199.74 41.997 5,800.26 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,456.40 64.642 1,343.60 Subtotal: 286,291.00 336,291.00 56,224.53 275,228.49 81.842 61,062.51 Program number: 286,291.00 336,291.00 56,224.53 275,228.49 81.842 61,062.51 Department number: Non Departmental 286,291.00 336,291.00 56,224.53 275,228.49 81.842 61,062.51 Expenditures Subtotal ----------- 8,444,333.00 8,478,933.00 475,258.94 2,139,860.48 25.237 6,339,072.52 Fund number: 135 MUD 1 General Fund 1,022,490.78- 1,029,517.65- 1,029,517.65 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 16:39 02/11/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 91,329.00- 91,329.00 137-49146-000-000 Intergov Transfer-Fire Dept 17,950.00- 17,950.00 Subtotal: 109,279.00- 109,279.00 Program number: 109,279.00- 109,279.00 Department number: 109,279.00- 109,279.00 Revenues Subtotal ----------- 109,279.00- 109,279.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 16:39 02/11/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-030-000 GASB Replacement 74,706.00 74,706.00- Subtotal: 74,706.00 74,706.00- Program number: 74,706.00 74,706.00- Department number: Administration 74,706.00 74,706.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 16:39 02/11/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-045-000 GASB Replacement 125,670.00 125,670.00- Subtotal: 125,670.00 125,670.00- Program number: 125,670.00 125,670.00- Department number: Fire Department 125,670.00 125,670.00- Expenditures Subtotal ----------- 200,376.00 200,376.00- Fund number: 137 MUD 1 Consolidated GASB 91,097.00 91,097.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 16:39 02/11/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income .97- 4.99- 4.99 Subtotal: .97- 4.99- 4.99 Program number: .97- 4.99- 4.99 Department number: .97- 4.99- 4.99 Revenues Subtotal ----------- .97- 4.99- 4.99 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 16:39 02/11/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 3,348.00 3,348.00 2,100.00 62.724 1,248.00 Subtotal: 3,348.00 3,348.00 2,100.00 62.724 1,248.00 Program number: 3 Indian Creek Waterline 3,348.00 3,348.00 2,100.00 62.724 1,248.00 Department number: Water 3,348.00 3,348.00 2,100.00 62.724 1,248.00 Expenditures Subtotal ----------- 3,348.00 3,348.00 2,100.00 62.724 1,248.00 Fund number: 507 MUD 1 Capital Projects 3,348.00 3,348.00 .97- 2,095.01 62.575 1,252.99 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 757 01/02/2015 Property Taxes/Assessments (90,990.34) (2,254.17) (93,244.51) GL 758 01/05/2015 Property Taxes/Assessments (1,120.84) (94,365.35) GL 759 01/06/2015 Property Taxes/Assessments (2,107.90) (96,473.25) GL 760 01/07/2015 Property Taxes/Assessments (1,266.53) (97,739.78) GL 764 01/08/2015 Property Taxes/Assessments (1,289.96) (99,029.74) GL 765 01/09/2015 Property Taxes/Assessments (1,151.58) (100,181.32) GL 766 01/12/2015 Property Taxes/Assessments (1,174.17) (101,355.49) GL 767 01/13/2015 Property Taxes/Assessments (377.16) (101,732.65) GL 768 01/14/2015 Property Taxes/Assessments (1,148.72) (102,881.37) GL 769 01/15/2015 Property Taxes/Assessments (1,648.03) (104,529.40) GL 770 01/16/2015 Property Taxes/Assessments (860.57) (105,389.97) GL 771 01/20/2015 Property Taxes/Assessments (561.95) (105,951.92) GL 772 01/21/2015 Property Taxes/Assessments (2,348.73) (108,300.65) GL 773 01/22/2015 Property Taxes/Assessments (1,086.35) (109,387.00) GL 774 01/23/2015 Property Taxes/Assessments (2,023.92) (111,410.92) GL 775 01/26/2015 Property Taxes/Assessments (2,856.47) (114,267.39) GL 776 01/27/2015 Property Taxes/Assessments (2,897.55) (117,164.94) GL 777 01/28/2015 Property Taxes/Assessments (22,242.32) (139,407.26) GL 778 01/29/2015 Property Taxes/Assessments (4,239.20) (143,646.46) GL 779 01/30/2015 Property Taxes/Assessments (3,615.02) (147,261.48) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (56,271.14) (147,261.48) ** (167,857.00) Budgeted (20,595.52) Remaining 88 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 758 01/05/2015 Property Taxes/Assessments (357.42) 7.63 (349.79) GL 765 01/09/2015 Property Taxes/Assessments 8.70 (341.09) GL 767 01/13/2015 Property Taxes/Assessments (5.56) (346.65) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 10.77 (346.65) ** .00 Budgeted 346.65 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 757 01/02/2015 Property Taxes/Assessments (121.59) (1.10) (122.69) GL 759 01/06/2015 Property Taxes/Assessments (1.64) (124.33) GL 765 01/09/2015 Property Taxes/Assessments 3.41 (120.92) GL 766 01/12/2015 Property Taxes/Assessments (3.97) (124.89) GL 797 01/12/2015 1/12 Correction of Tax Receipt Correction of Tax Receipt (.01) (124.90) GL 767 01/13/2015 Property Taxes/Assessments (1.34) (126.24) GL 770 01/16/2015 Property Taxes/Assessments (.80) (127.04) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 771 01/20/2015 Property Taxes/Assessments (121.59) (11.96) (139.00) GL 772 01/21/2015 Property Taxes/Assessments (.06) (139.06) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (17.47) (139.06) ** (900.00) Budgeted (760.94) Remaining 15 % Used Account: 135-40025-000-000 PID Surcharges 710 01/31/2015 UB 1/31/15 Billing UB20150131-20150131 User: (34,220.50) (11,516.60) (45,737.10) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (11,516.60) (45,737.10) ** (133,997.00) Budgeted (88,259.90) Remaining 34 % Used Account: 135-47000-000-000 Water 716 01/08/2015 UB 1/8/15 Adj UB20150108-20150108 User: (824,026.24) 32.40 (823,993.84) UB 710 01/31/2015 UB 1/31/15 Billing UB20150131-20150131 User: (185,060.53) (1,009,054.37) UB _______________ Account: 135-47000-000-000 Water Totals: (185,028.13) (1,009,054.37) ** (5,286,045.00) Budgeted (4,276,990.63) Remaining 19 % Used Account: 135-47005-000-000 Sewer 716 01/08/2015 UB 1/8/15 Adj UB20150108-20150108 User: (502,901.37) 22.50 (502,878.87) UB 710 01/31/2015 UB 1/31/15 Billing UB20150131-20150131 User: (139,839.16) (642,718.03) UB _______________ Account: 135-47005-000-000 Sewer Totals: (139,816.66) (642,718.03) ** (2,270,982.00) Budgeted (1,628,263.97) Remaining 28 % Used Account: 135-47025-000-000 Penalties 720 01/19/2015 UB 1/19/15 Adj UB20150119-20150119 User: (26,288.38) 127.54 (26,160.84) UB 722 01/20/2015 UB 1/20/15-Penalty adj UB20150120-20150120 User: 36.25 (26,124.59) UB 670 01/21/2015 UB 1/21/15 Penalties UB20150121-20150121 User: (8,230.85) (34,355.44) UB 723 01/21/2015 UB 1/21/15 Penalties UB20150121-20150121 User: 49.34 (34,306.10) UB 728 01/26/2015 UB 1/26/15-adj UB20150126-20150126 User: 49.00 (34,257.10) UB 730 01/30/2015 UB 1/30/15 Adj-penalties UB20150130-20150130 User: 87.40 (34,169.70) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,881.32) (34,169.70) ** (63,416.00) Budgeted (29,246.30) Remaining 54 % Used Account: 135-47030-000-000 Service Charges . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 619 01/13/2015 UB 1/13/15 Cut Off Fees UB20150113-20150113 User: (2,834.00) (650.00) (3,484.00) UB 717 01/13/2015 UB 1/13/15 NSF Check fee UB20150113-20150113 User: (25.00) (3,509.00) UB 719 01/14/2015 UB 1/14/15 After Hours fee UB20150114-20150114 User: (100.00) (3,609.00) UB 724 01/21/2015 UB 1/21/15 NSF Check fee UB20150121-20150121 User: (25.00) (3,634.00) UB 710 01/31/2015 UB 1/31/15 Billing UB20150131-20150131 User: (3.00) (3,637.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (803.00) (3,637.00) ** (8,000.00) Budgeted (4,363.00) Remaining 45 % Used Account: 135-47035-000-000 Plumbing Inspections 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (600.00) (600.00) (1,200.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (600.00) (1,200.00) ** (2,000.00) Budgeted (800.00) Remaining 60 % Used Account: 135-47045-000-000 Sewer Inspections 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (1,800.00) (1,800.00) (3,600.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,800.00) (3,600.00) ** (5,000.00) Budgeted (1,400.00) Remaining 72 % Used Account: 135-47070-000-000 TCCC Effluent Charges 710 01/31/2015 UB 1/31/15 Billing UB20150131-20150131 User: (12,798.10) (280.70) (13,078.80) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (280.70) (13,078.80) ** (86,815.00) Budgeted (73,736.20) Remaining 15 % Used Account: 135-48005-000-000 Utility Fees 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (48,300.00) (11,500.00) (59,800.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (11,500.00) (59,800.00) ** (184,000.00) Budgeted (124,200.00) Remaining 33 % Used Account: 135-49010-000-000 Interest Income 749 01/31/2015 Bank Interest/January (1,510.91) (66.84) (1,577.75) GL 749 01/31/2015 Bank Interest/January (96.67) (1,674.42) GL 749 01/31/2015 Bank Interest/January (396.07) (2,070.49) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49010-000-000 Interest Income Totals: (559.58) (2,070.49) ** (5,000.00) Budgeted (2,929.51) Remaining 41 % Used Account: 135-49016-000-000 Cell Tower Revenue 604 01/09/2015 AT&T Antenna Lease (2,731.59) (910.53) (3,642.12) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (3,642.12) ** (10,164.00) Budgeted (6,521.88) Remaining 36 % Used Account: 135-49018-000-000 Building Rent Income 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (1,749.99) (583.33) (2,333.32) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 % Used Account: 135-49030-000-000 Vending Revenue .00 .00 _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 .00 ** (351.00) Budgeted (351.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves (74,706.00) .00 (74,706.00) _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 (74,706.00) ** (74,706.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (10,846.57) (5,831.00) (16,677.57) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,831.00) (16,677.57) ** (84,000.00) Budgeted (67,322.43) Remaining 20 % Used Account: 135-49145-000-000 Intergov Transfer-General Fund 659 01/07/2015 Tax Bond Const Reimb Gen Fund (1,074,337.15) (1,074,337.15) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49145-000-000 Intergov Transfer-General Fund Totals: (1,074,337.15) (1,074,337.15) ** .00 Budgeted 1,074,337.15 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 710 01/31/2015 UB 1/31/15 Billing UB20150131-20150131 User: (34,833.21) (23.88) (34,857.09) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (23.88) (34,857.09) ** (88,600.00) Budgeted (53,742.91) Remaining 39 % Used Account: 135-49901-000-000 Records Management Revenue (12.20) .00 (12.20) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (12.20) ** (100.00) Budgeted (87.80) Remaining 12 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,169,378.13) ** (8,478,933.00) Budgeted (5,309,554.87) Remaining 37 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 517 01/02/2015 PR 01-02-15 Salaries & Wages 38,556.03 5,910.78 44,466.81 PR 621 01/16/2015 MUD Payroll 1/16/15 Salaries & Wages 6,594.47 51,061.28 PR 692 01/30/2015 MUD Payroll 1/30/15 Salaries & Wages 7,314.47 58,375.75 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,819.72 58,375.75 ** 301,101.00 Budgeted 242,725.25 Remaining 19 % Used Account: 135-50010-010-000 Overtime 517 01/02/2015 PR 01-02-15 Overtime 2,839.39 190.26 3,029.65 PR 621 01/16/2015 MUD Payroll 1/16/15 Overtime 644.19 3,673.84 PR 692 01/30/2015 MUD Payroll 1/30/15 Overtime 501.32 4,175.16 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,335.77 4,175.16 ** 19,500.00 Budgeted 15,324.84 Remaining 21 % Used Account: 135-50016-010-000 Longevity 2,705.00 .00 2,705.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,705.00 ** 5,343.00 Budgeted 2,638.00 Remaining 51 % Used Account: 135-50017-010-000 Certification 621 01/16/2015 MUD Payroll 1/16/15 Certification 700.00 225.00 925.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 925.00 ** 4,800.00 Budgeted 3,875.00 Remaining 19 % Used Account: 135-50020-010-000 Retirement 517 01/02/2015 PR 01-02-15 Retirement 4,023.09 543.60 4,566.69 PR 621 01/16/2015 MUD Payroll 1/16/15 Retirement 665.02 5,231.71 PR 692 01/30/2015 MUD Payroll 1/30/15 Retirement 696.38 5,928.09 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,905.00 5,928.09 ** 29,349.00 Budgeted 23,420.91 Remaining 20 % Used Account: 135-50026-010-000 Medical Insurance 517 01/02/2015 PR 01-02-15 Medical Insurance 5,604.62 937.17 6,541.79 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 621 01/16/2015 MUD Payroll 1/16/15 Medical Insurance 5,604.62 1,249.52 7,791.31 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,186.69 7,791.31 ** 44,988.00 Budgeted 37,196.69 Remaining 17 % Used Account: 135-50027-010-000 Dental Insurance 517 01/02/2015 PR 01-02-15 Dental Insurance 443.82 80.72 524.54 PR 621 01/16/2015 MUD Payroll 1/16/15 Dental Insurance 98.24 622.78 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 178.96 622.78 ** 3,288.00 Budgeted 2,665.22 Remaining 19 % Used Account: 135-50028-010-000 Vision Insurance 517 01/02/2015 PR 01-02-15 Vision Insurance 107.25 17.93 125.18 PR 621 01/16/2015 MUD Payroll 1/16/15 Vision Insurance 22.48 147.66 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 40.41 147.66 ** 834.00 Budgeted 686.34 Remaining 18 % Used Account: 135-50029-010-000 Life Insurance & Other 503 01/01/2015 Jan A/P Jan Dental, Vision, Other Ins 433.60 128.04 561.64 METLIFE GROUP BENEFITS 34493 AP 696 01/27/2015 Jan A/P Café 125 Adm fee 8.44 570.08 BenefitMall 34588 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 136.48 570.08 ** 3,074.00 Budgeted 2,503.92 Remaining 19 % Used Account: 135-50030-010-000 Social Security Taxes 517 01/02/2015 PR 01-02-15 Social Security Taxes 2,746.51 372.28 3,118.79 PR 621 01/16/2015 MUD Payroll 1/16/15 Social Security Taxes 462.19 3,580.98 PR 692 01/30/2015 MUD Payroll 1/30/15 Social Security Taxes 487.17 4,068.15 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,321.64 4,068.15 ** 21,135.00 Budgeted 17,066.85 Remaining 19 % Used Account: 135-50035-010-000 Medicare Taxes 517 01/02/2015 PR 01-02-15 Medicare Taxes 642.34 87.06 729.40 PR 621 01/16/2015 MUD Payroll 1/16/15 Medicare Taxes 108.11 837.51 PR 692 01/30/2015 MUD Payroll 1/30/15 Medicare Taxes 113.94 951.45 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 309.11 951.45 ** 4,943.00 Budgeted 3,991.55 Remaining 19 % Used Account: 135-50040-010-000 Unemployment Taxes 517 01/02/2015 PR 01-02-15 Unemployment Taxes 140.32 140.32 PR 621 01/16/2015 MUD Payroll 1/16/15 Unemployment Taxes 171.68 312.00 PR 692 01/30/2015 MUD Payroll 1/30/15 Unemployment Taxes 179.75 491.75 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 491.75 491.75 ** 1,242.00 Budgeted 750.25 Remaining 40 % Used Account: 135-50045-010-000 Workman's Compensation 194 01/01/2015 Jan TML Ins & Workers Comp 2,573.73 857.91 3,431.64 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.91 3,431.64 ** 16,020.00 Budgeted 12,588.36 Remaining 21 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 800 01/31/2015 Jan A/P Testing & pre employment/Crawf 379.40 88.00 467.40 CARENOW CORPORATE AP 802 01/31/2015 Jan A/P Background check/Crawford 119.45 586.85 FIRST CHECK APPLICANT SCREENIN AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 207.45 586.85 ** 1,000.00 Budgeted 413.15 Remaining 59 % Used Account: 135-50070-010-000 Employee Relations .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 616 01/12/2015 Jan A/P Grease fitting, windshield was 21,203.42 85.77 21,289.19 NAPA AUTO PARTS 34539 AP 616 01/12/2015 Jan A/P Repair 2 Overhill main break/h 12,602.35 33,891.54 REY-MAR CONSTRUCTION 34546 AP 682 01/16/2015 Travelers/8" Waterline damage (13,213.35) 20,678.19 GL 662 01/19/2015 Jan A/P Misc parts 1,832.80 22,510.99 HD SUPPLY WATERWORKS, LTD. 34576 AP 666 01/21/2015 Jan A/P Parts 1,507.62 24,018.61 HD SUPPLY WATERWORKS, LTD. 34576 AP 781 01/26/2015 PCards 12/27/14-1/26/15 THE HOME DEPOT 6581 32.90 24,051.51 THE HOME DEPOT 6581 PC 781 01/26/2015 PCards 12/27/14-1/26/15 THE HOME DEPOT 6581 189.80 24,241.31 THE HOME DEPOT 6581 PC 696 01/27/2015 Jan A/P 48" Smart Sticks 144.00 24,385.31 HD SUPPLY WATERWORKS, LTD. 34598 AP 737 01/31/2015 January A/P Parts-Fire lines 1,768.64 26,153.95 HD SUPPLY WATERWORKS, LTD. 34598 AP 737 01/31/2015 January A/P 2" Ball Valves 144.00 26,297.95 HD SUPPLY WATERWORKS, LTD. 34598 AP 737 01/31/2015 January A/P Parts 47.46 26,345.41 HD SUPPLY WATERWORKS, LTD. 34598 AP 737 01/31/2015 January A/P Parts 897.05 27,242.46 HD SUPPLY WATERWORKS, LTD. 34598 AP 800 01/31/2015 Jan A/P Well #4 142.50 27,384.96 CIRCLE R ELECTRIC CO AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 6,181.54 27,384.96 ** 71,242.00 Budgeted 43,857.04 Remaining 38 % Used Account: 135-55090-010-000 Vehicle Maintenance 781 01/26/2015 PCards 12/27/14-1/26/15 IN *GIERISCH BROTHERS 2,249.48 126.00 2,375.48 IN *GIERISCH BROTHERS PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 126.00 2,375.48 ** 8,000.00 Budgeted 5,624.52 Remaining 30 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 243.00 .00 243.00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 243.00 ** 3,500.00 Budgeted 3,257.00 Remaining 7 % Used Account: 135-55135-010-000 Lab Analysis 800 01/31/2015 Jan A/P Water Samples/MUD 930.26 270.00 1,200.26 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 270.00 1,200.26 ** 5,500.00 Budgeted 4,299.74 Remaining 22 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 662 01/19/2015 Jan A/P Cell phones 12/2/14 - 1/1/15 902.48 554.73 1,457.21 VERIZON WIRELESS 34582 AP 696 01/27/2015 Jan A/P Verizon, GEXA (157.24) 1,299.97 TOWN OF TROPHY CLUB 34619 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 397.49 1,299.97 ** 4,913.00 Budgeted 3,613.03 Remaining 26 % Used Account: 135-60020-010-000 Electricity 666 01/21/2015 Jan A/P Electricity 12/11/14 - 01/12/1 28,344.68 3,217.96 31,562.64 HUDSON ENERGY SERVICES, LLC 34577 AP 800 01/31/2015 Jan A/P Electricity 12/11-1/12/15 5,003.20 36,565.84 HUDSON ENERGY SERVICES, LLC AP _______________ Account: 135-60020-010-000 Electricity Totals: 8,221.16 36,565.84 ** 170,765.00 Budgeted 134,199.16 Remaining 21 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 50.00 .00 50.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 50.00 ** 4,138.00 Budgeted 4,088.00 Remaining 1 % 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 .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 800 01/31/2015 Jan A/P Well Water Quarterly 17,201.36 3,722.70 20,924.06 North Texas Groundwater AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 3,722.70 20,924.06 ** 49,275.00 Budgeted 28,350.94 Remaining 42 % Used Account: 135-60150-010-000 Wholesale Water 737 01/31/2015 January A/P December Wholesale Water 337,731.93 125,292.56 463,024.49 CITY OF FORT WORTH 34592 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 125,292.56 463,024.49 ** 2,928,308.00 Budgeted 2,465,283.51 Remaining 16 % 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 818.25 .00 818.25 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 818.25 ** 3,500.00 Budgeted 2,681.75 Remaining 23 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 662 01/19/2015 Jan A/P Pump out tank 3,591.01 300.00 3,891.01 RICOCHET FUEL DISTRIBUTORS,INC 34580 AP 696 01/27/2015 Jan A/P 12/25-1/14/15 Fuel 588.12 4,479.13 US Bank Voyager Fleet Systems 34622 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (150.00) 4,329.13 AR _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 738.12 4,329.13 ** 29,172.00 Budgeted 24,842.87 Remaining 15 % Used Account: 135-65010-010-000 Uniforms 781 01/26/2015 PCards 12/27/14-1/26/15 RED WING SHOES #652 99.99 174.24 274.23 RED WING SHOES #652 PC 781 01/26/2015 PCards 12/27/14-1/26/15 RED WING SHOES #652 175.00 449.23 RED WING SHOES #652 PC 781 01/26/2015 PCards 12/27/14-1/26/15 RED WING SHOES #652 157.24 606.47 RED WING SHOES #652 PC _______________ Account: 135-65010-010-000 Uniforms Totals: 506.48 606.47 ** 3,620.00 Budgeted 3,013.53 Remaining 17 % Used Account: 135-65030-010-000 Chemicals 666 01/21/2015 Jan A/P Testing supplies 2,715.57 417.44 3,133.01 HACH COMPANY 34575 AP 696 01/27/2015 Jan A/P Chlorine 304.95 3,437.96 DPC INDUSTRIES, INC 34594 AP 800 01/31/2015 Jan A/P Chemicals 316.45 3,754.41 HACH COMPANY AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,038.84 3,754.41 ** 7,000.00 Budgeted 3,245.59 Remaining 54 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65040-010-000 Safety Equipment 141.75 .00 141.75 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 141.75 ** 1,000.00 Budgeted 858.25 Remaining 14 % Used Account: 135-65050-010-000 Meter Expense 662 01/19/2015 Jan A/P Fire hydrant meter & backflow 11,305.00 1,155.00 12,460.00 ATLAS UTILITY SUPPLY CO. 34569 AP 662 01/19/2015 Jan A/P Orion heads for pool meter 355.00 12,815.00 ATLAS UTILITY SUPPLY CO. 34569 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 1,510.00 12,815.00 ** 161,500.00 Budgeted 148,685.00 Remaining 8 % Used Account: 135-69005-010-000 Capital Outlays 92,045.56 .00 92,045.56 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 92,045.56 ** 1,177,566.00 Budgeted 1,085,520.44 Remaining 8 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 129,000.00 Budgeted 129,000.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 3,612.00 Budgeted 3,612.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 696 01/27/2015 Jan A/P 2m gst Water Plant East Annual 80,986.69 37,787.73 118,774.42 UTILITY SERVICE CO, INC. 34623 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 37,787.73 118,774.42 ** 151,507.00 Budgeted 32,732.58 Remaining 78 % Used Account: 135-55135-010-001 Lab Analysis for PID 800 01/31/2015 Jan A/P Water Samples/PID 1,937.63 80.00 2,017.63 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 2,017.63 ** 5,000.00 Budgeted 2,982.37 Remaining 40 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 954,141.35 ** 5,474,585.00 Budgeted 4,520,443.65 Remaining 17 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 517 01/02/2015 PR 01-02-15 Salaries & Wages 61,077.75 11,610.44 72,688.19 PR 621 01/16/2015 MUD Payroll 1/16/15 Salaries & Wages 11,308.21 83,996.40 PR 692 01/30/2015 MUD Payroll 1/30/15 Salaries & Wages 11,259.45 95,255.85 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 34,178.10 95,255.85 ** 305,744.00 Budgeted 210,488.15 Remaining 31 % Used Account: 135-50010-020-000 Overtime 517 01/02/2015 PR 01-02-15 Overtime 5,981.13 1,505.65 7,486.78 PR 621 01/16/2015 MUD Payroll 1/16/15 Overtime 901.70 8,388.48 PR 692 01/30/2015 MUD Payroll 1/30/15 Overtime 955.42 9,343.90 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,362.77 9,343.90 ** 19,500.00 Budgeted 10,156.10 Remaining 48 % Used Account: 135-50016-020-000 Longevity 5,615.00 .00 5,615.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 5,615.00 ** 5,617.00 Budgeted 2.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 621 01/16/2015 MUD Payroll 1/16/15 Certification 1,650.00 550.00 2,200.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 2,200.00 ** 6,600.00 Budgeted 4,400.00 Remaining 33 % Used Account: 135-50020-020-000 Retirement 517 01/02/2015 PR 01-02-15 Retirement 6,674.26 1,168.64 7,842.90 PR 621 01/16/2015 MUD Payroll 1/16/15 Retirement 1,136.91 8,979.81 PR 692 01/30/2015 MUD Payroll 1/30/15 Retirement 1,088.35 10,068.16 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,393.90 10,068.16 ** 29,948.00 Budgeted 19,879.84 Remaining 34 % Used Account: 135-50026-020-000 Medical Insurance 517 01/02/2015 PR 01-02-15 Medical Insurance 13,161.17 2,541.63 15,702.80 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 621 01/16/2015 MUD Payroll 1/16/15 Medical Insurance 13,161.17 2,541.59 18,244.39 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,083.22 18,244.39 ** 61,001.00 Budgeted 42,756.61 Remaining 30 % Used Account: 135-50027-020-000 Dental Insurance 517 01/02/2015 PR 01-02-15 Dental Insurance 831.48 167.98 999.46 PR 621 01/16/2015 MUD Payroll 1/16/15 Dental Insurance 167.99 1,167.45 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 335.97 1,167.45 ** 4,146.00 Budgeted 2,978.55 Remaining 28 % Used Account: 135-50028-020-000 Vision Insurance 517 01/02/2015 PR 01-02-15 Vision Insurance 198.45 37.45 235.90 PR 621 01/16/2015 MUD Payroll 1/16/15 Vision Insurance 37.49 273.39 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 74.94 273.39 ** 990.00 Budgeted 716.61 Remaining 28 % Used Account: 135-50029-020-000 Life Insurance & Other 503 01/01/2015 Jan A/P Jan Dental, Vision, Other Ins 802.82 253.16 1,055.98 METLIFE GROUP BENEFITS 34493 AP 696 01/27/2015 Jan A/P Café 125 Adm fee 33.78 1,089.76 BenefitMall 34588 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 286.94 1,089.76 ** 3,194.00 Budgeted 2,104.24 Remaining 34 % Used Account: 135-50030-020-000 Social Security Taxes 517 01/02/2015 PR 01-02-15 Social Security Taxes 4,064.26 714.94 4,779.20 PR 621 01/16/2015 MUD Payroll 1/16/15 Social Security Taxes 688.50 5,467.70 PR 692 01/30/2015 MUD Payroll 1/30/15 Social Security Taxes 759.94 6,227.64 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,163.38 6,227.64 ** 21,680.00 Budgeted 15,452.36 Remaining 29 % Used Account: 135-50035-020-000 Medicare Taxes 517 01/02/2015 PR 01-02-15 Medicare Taxes 950.50 167.21 1,117.71 PR 621 01/16/2015 MUD Payroll 1/16/15 Medicare Taxes 161.02 1,278.73 PR 692 01/30/2015 MUD Payroll 1/30/15 Medicare Taxes 177.73 1,456.46 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 505.96 1,456.46 ** 5,070.00 Budgeted 3,613.54 Remaining 29 % Used Account: 135-50040-020-000 Unemployment Taxes 517 01/02/2015 PR 01-02-15 Unemployment Taxes 301.66 301.66 PR 621 01/16/2015 MUD Payroll 1/16/15 Unemployment Taxes 293.48 595.14 PR 692 01/30/2015 MUD Payroll 1/30/15 Unemployment Taxes 280.94 876.08 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 876.08 876.08 ** 1,242.00 Budgeted 365.92 Remaining 71 % Used Account: 135-50045-020-000 Workman's Compensation 194 01/01/2015 Jan TML Ins & Workers Comp 2,573.73 857.91 3,431.64 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.91 3,431.64 ** 16,020.00 Budgeted 12,588.36 Remaining 21 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 696 01/27/2015 Jan A/P Employee testing 63.00 63.00 CARENOW CORPORATE 34590 AP 800 01/31/2015 Jan A/P Testing & pre employment/Crawf 63.00 126.00 CARENOW CORPORATE AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 126.00 126.00 ** 150.00 Budgeted 24.00 Remaining 84 % Used Account: 135-50070-020-000 Employee Relations 781 01/26/2015 PCards 12/27/14-1/26/15 MR JIM S PIZZA 253.81 51.44 305.25 MR JIM S PIZZA PC 781 01/26/2015 PCards 12/27/14-1/26/15 SALAD BOWL 10 77.94 383.19 SALAD BOWL 10 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 129.38 383.19 ** 550.00 Budgeted 166.81 Remaining 70 % Used Account: 135-55005-020-000 Engineering 781 01/26/2015 PCards 12/27/14-1/26/15 MUSTANG ELITE CAR WASH 38.24 38.24 MUSTANG ELITE CAR WASH PC _______________ Account: 135-55005-020-000 Engineering Totals: 38.24 38.24 ** .00 Budgeted (38.24) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-020-000 Maintenance & Repairs 781 01/26/2015 PCards 12/27/14-1/26/15 THE HOME DEPOT 6581 33,081.44 (11.94) 33,069.50 THE HOME DEPOT 6581 PC 781 01/26/2015 PCards 12/27/14-1/26/15 THE HOME DEPOT 6581 14.06 33,083.56 THE HOME DEPOT 6581 PC 781 01/26/2015 PCards 12/27/14-1/26/15 THE HOME DEPOT 6581 71.72 33,155.28 THE HOME DEPOT 6581 PC 781 01/26/2015 PCards 12/27/14-1/26/15 ASHBROOKSIM 14.72 33,170.00 ASHBROOKSIM PC 781 01/26/2015 PCards 12/27/14-1/26/15 ASHBROOKSIM 120.00 33,290.00 ASHBROOKSIM PC 781 01/26/2015 PCards 12/27/14-1/26/15 USA BLUE BOOK 1,060.55 34,350.55 USA BLUE BOOK PC 781 01/26/2015 PCards 12/27/14-1/26/15 ROANOKE AUTO SUPPLY LT 31.38 34,381.93 ROANOKE AUTO SUPPLY LT PC 781 01/26/2015 PCards 12/27/14-1/26/15 FASTENAL COMPANY01 15.85 34,397.78 FASTENAL COMPANY01 PC 696 01/27/2015 Jan A/P Cuff Boom Suction Hose, clamps 980.40 35,378.18 UNDERGROUND INC 34621 AP 696 01/27/2015 Jan A/P Check Generators 1,195.00 36,573.18 ENTECH SALES AND SERVICE INC 34595 AP 696 01/27/2015 Jan A/P Replace Battery Charger 1,412.05 37,985.23 ENTECH SALES AND SERVICE INC 34595 AP 696 01/27/2015 Jan A/P Instrument calibrations 769.50 38,754.73 Prime Controls, LP 34614 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 5,673.29 38,754.73 ** 58,000.00 Budgeted 19,245.27 Remaining 67 % Used Account: 135-55090-020-000 Vehicle Maintenance 781 01/26/2015 PCards 12/27/14-1/26/15 IN *HOSE TECH 1,263.70 114.09 1,377.79 IN *HOSE TECH PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 114.09 1,377.79 ** 3,000.00 Budgeted 1,622.21 Remaining 46 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 781 01/26/2015 PCards 12/27/14-1/26/15 ROANOKE AUTO SUPPLY LT 17.28 3.99 21.27 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 3.99 21.27 ** 500.00 Budgeted 478.73 Remaining 4 % Used Account: 135-55125-020-000 Dumpster Services 696 01/27/2015 Jan A/P Transportation-Hourly Sludge h 11,280.47 3,040.00 14,320.47 L.H. CHANEY MATERIALS, INC. 34603 AP 696 01/27/2015 Jan A/P Sludge Haul off 5,787.84 20,108.31 L.H. CHANEY MATERIALS, INC. 34603 AP 696 01/27/2015 Jan A/P Roll off delivery 570.00 20,678.31 L.H. CHANEY MATERIALS, INC. 34603 AP 696 01/27/2015 Jan A/P Sludge haul off 2,181.79 22,860.10 L.H. CHANEY MATERIALS, INC. 34603 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 11,579.63 22,860.10 ** 55,000.00 Budgeted 32,139.90 Remaining 42 % Used Account: 135-55135-020-000 Lab Analysis . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 696 01/27/2015 Jan A/P Testing 5,623.00 246.00 5,869.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Testing 176.00 6,045.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Testing 246.00 6,291.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Testing 176.00 6,467.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Testing 246.00 6,713.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Testing 176.00 6,889.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Testing 246.00 7,135.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Testing 176.00 7,311.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Testing 246.00 7,557.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Testing 176.00 7,733.00 OXIDOR LABORATORIES LLC 34613 AP 696 01/27/2015 Jan A/P Annual Sludge Testing 1,362.50 9,095.50 OXIDOR LABORATORIES LLC 34613 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 3,472.50 9,095.50 ** 25,000.00 Budgeted 15,904.50 Remaining 36 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 616 01/12/2015 Jan A/P Lift stations/alarm monitoring 1,021.88 276.00 1,297.88 OMNISITE 34541 AP 662 01/19/2015 Jan A/P Cell phones 12/2/14 - 1/1/15 411.36 1,709.24 VERIZON WIRELESS 34582 AP 781 01/26/2015 PCards 12/27/14-1/26/15 AMERICAN AIRLINES 226.20 1,935.44 AMERICAN AIRLINES PC 696 01/27/2015 Jan A/P Verizon, GEXA (46.91) 1,888.53 TOWN OF TROPHY CLUB 34619 AP 696 01/27/2015 Jan A/P Verizon, GEXA (125.38) 1,763.15 TOWN OF TROPHY CLUB 34619 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 741.27 1,763.15 ** 4,662.00 Budgeted 2,898.85 Remaining 38 % Used Account: 135-60020-020-000 Electricity 625 01/13/2015 Jan A/P Electricity 11/26-12/31/14 29,344.37 28.34 29,372.71 TRI COUNTY ELECTRIC 34560 AP 625 01/13/2015 Jan A/P Electricity 11/26-12/31/14 307.82 29,680.53 TRI COUNTY ELECTRIC 34560 AP 625 01/13/2015 Jan A/P Electricity 11/26-12/31/14 154.18 29,834.71 TRI COUNTY ELECTRIC 34560 AP 662 01/19/2015 Jan A/P Electricity 12/10/14 - 1/9/15 60.86 29,895.57 HUDSON ENERGY SERVICES, LLC 34577 AP 662 01/19/2015 Jan A/P Electricity 12/10/14 - 01/09/1 28.70 29,924.27 HUDSON ENERGY SERVICES, LLC 34577 AP 666 01/21/2015 Jan A/P Electricity 12/11/14 - 01/12/ 477.21 30,401.48 HUDSON ENERGY SERVICES, LLC 34577 AP 666 01/21/2015 Jan A/P Electricity 12/11/14-01/12/15 102.32 30,503.80 HUDSON ENERGY SERVICES, LLC 34577 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (303.95) 30,199.85 AR 800 01/31/2015 Jan A/P Electricity 12/11-1/12/15 10,512.80 40,712.65 HUDSON ENERGY SERVICES, LLC AP _______________ Account: 135-60020-020-000 Electricity Totals: 11,368.28 40,712.65 ** 149,292.00 Budgeted 108,579.35 Remaining 27 % Used Account: 135-60066-020-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 134.85 .00 134.85 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 134.85 ** 400.00 Budgeted 265.15 Remaining 34 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 781 01/26/2015 PCards 12/27/14-1/26/15 AMERICAN WATERWORKS 351.00 445.00 796.00 AMERICAN WATERWORKS PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 445.00 796.00 ** 4,065.00 Budgeted 3,269.00 Remaining 20 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 517 01/02/2015 PR 01-02-15 Travel & per diem 104.58 87.36 191.94 PR 696 01/27/2015 Jan A/P Tolls 9.11 201.05 NTTA 34611 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 96.47 201.05 ** 1,600.00 Budgeted 1,398.95 Remaining 13 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 9,019.00 .00 9,019.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 9,019.00 ** 17,150.00 Budgeted 8,131.00 Remaining 53 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 696 01/27/2015 Jan A/P 12/25-1/14/15 Fuel 7,024.43 696.71 7,721.14 US Bank Voyager Fleet Systems 34622 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 696.71 7,721.14 ** 36,328.00 Budgeted 28,606.86 Remaining 21 % Used Account: 135-65010-020-000 Uniforms 2,365.97 .00 2,365.97 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 2,365.97 ** 2,778.00 Budgeted 412.03 Remaining 85 % Used Account: 135-65030-020-000 Chemicals 781 01/26/2015 PCards 12/27/14-1/26/15 LESLIES POOL SPLY 574 2,159.38 108.27 2,267.65 LESLIES POOL SPLY 574 PC 696 01/27/2015 Jan A/P Freestyle Calc Hypochlorite 2,240.00 4,507.65 HARCROS CHEMICALS INC 34597 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,348.27 4,507.65 ** 30,000.00 Budgeted 25,492.35 Remaining 15 % Used Account: 135-65035-020-000 Small Tools . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 781 01/26/2015 PCards 12/27/14-1/26/15 WM SUPERCENTER #2980 458.33 27.95 486.28 WM SUPERCENTER #2980 PC 781 01/26/2015 PCards 12/27/14-1/26/15 THE HOME DEPOT 6581 15.97 502.25 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 43.92 502.25 ** 2,000.00 Budgeted 1,497.75 Remaining 25 % Used Account: 135-65040-020-000 Safety Equipment 162.00 .00 162.00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 162.00 ** 750.00 Budgeted 588.00 Remaining 22 % Used Account: 135-65045-020-000 Lab Supplies 5,600.04 .00 5,600.04 _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 5,600.04 ** 13,000.00 Budgeted 7,399.96 Remaining 43 % Used Account: 135-69005-020-000 Capital Outlays 80,942.00 .00 80,942.00 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 80,942.00 ** 150,000.00 Budgeted 69,058.00 Remaining 54 % Used Account: 135-69007-020-000 LTD Payment from WW Sales .00 .00 _______________ Account: 135-69007-020-000 LTD Payment from WW Sales Totals: .00 .00 ** 295,933.00 Budgeted 295,933.00 Remaining 0 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 56,991.00 Budgeted 56,991.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 2,011.00 Budgeted 2,011.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 382,334.29 ** 1,400,512.00 Budgeted 1,018,177.71 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 621 01/16/2015 MUD Payroll 1/16/15 Salaries & Wages 2,500.00 1,000.00 3,500.00 PR 692 01/30/2015 MUD Payroll 1/30/15 Salaries & Wages 1,100.00 4,600.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 2,100.00 4,600.00 ** 10,000.00 Budgeted 5,400.00 Remaining 46 % Used Account: 135-50030-026-000 Social Security Taxes 621 01/16/2015 MUD Payroll 1/16/15 Social Security Taxes 155.00 62.00 217.00 PR 692 01/30/2015 MUD Payroll 1/30/15 Social Security Taxes 68.20 285.20 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 130.20 285.20 ** 620.00 Budgeted 334.80 Remaining 46 % Used Account: 135-50035-026-000 Medicare Taxes 621 01/16/2015 MUD Payroll 1/16/15 Medicare Taxes 36.25 14.50 50.75 PR 692 01/30/2015 MUD Payroll 1/30/15 Medicare Taxes 15.95 66.70 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 30.45 66.70 ** 145.00 Budgeted 78.30 Remaining 46 % Used Account: 135-50040-026-000 Unemployment Taxes 621 01/16/2015 MUD Payroll 1/16/15 Unemployment Taxes 57.50 23.00 80.50 PR 692 01/30/2015 MUD Payroll 1/30/15 Unemployment Taxes 25.30 105.80 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 48.30 105.80 ** 230.00 Budgeted 124.20 Remaining 46 % Used Account: 135-50045-026-000 Workman's Compensation 194 01/01/2015 Jan TML Ins & Workers Comp 8.82 2.94 11.76 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 11.76 ** 36.00 Budgeted 24.24 Remaining 33 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 781 01/26/2015 PCards 12/27/14-1/26/15 KROGER #0512 110.95 13.92 124.87 KROGER #0512 PC _______________ Account: 135-60075-026-000 Meetings Totals: 13.92 124.87 ** 1,200.00 Budgeted 1,075.13 Remaining 10 % Used Account: 135-60080-026-000 Schools & Training 975.00 .00 975.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 975.00 ** 4,000.00 Budgeted 3,025.00 Remaining 24 % Used Account: 135-60100-026-000 Travel & per diem 693 01/27/2015 Jan A/P Mileage reimbursement-AWBD 247.25 247.25 KEVIN CARR 34584 AP 696 01/27/2015 Jan A/P Mileage Reimbursement-AWBD 241.50 488.75 Jim Hase 34601 AP 696 01/27/2015 Jan A/P Meeting Waterline relocation 28.75 517.50 Neil Twomey 34609 AP 696 01/27/2015 Jan A/P Reimb AWBD expenses 812.46 1,329.96 Neil Twomey 34609 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 1,329.96 1,329.96 ** 5,000.00 Budgeted 3,670.04 Remaining 27 % Used Account: 135-60245-026-000 Miscellaneous Expenses 50.00 .00 50.00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 50.00 ** 1,000.00 Budgeted 950.00 Remaining 5 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 7,584.29 ** 22,881.00 Budgeted 15,296.71 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 517 01/02/2015 PR 01-02-15 Salaries & Wages 93,319.83 17,615.16 110,934.99 PR 621 01/16/2015 MUD Payroll 1/16/15 Salaries & Wages 17,617.45 128,552.44 PR 692 01/30/2015 MUD Payroll 1/30/15 Salaries & Wages 17,612.92 146,165.36 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 52,845.53 146,165.36 ** 477,578.00 Budgeted 331,412.64 Remaining 31 % Used Account: 135-50010-030-000 Overtime 621 01/16/2015 MUD Payroll 1/16/15 Overtime 51.77 6.56 58.33 PR 692 01/30/2015 MUD Payroll 1/30/15 Overtime 18.84 77.17 PR _______________ Account: 135-50010-030-000 Overtime Totals: 25.40 77.17 ** 1,000.00 Budgeted 922.83 Remaining 8 % Used Account: 135-50016-030-000 Longevity 3,282.50 .00 3,282.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,282.50 ** 3,283.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 517 01/02/2015 PR 01-02-15 Retirement 8,679.55 1,569.51 10,249.06 PR 621 01/16/2015 MUD Payroll 1/16/15 Retirement 1,570.30 11,819.36 PR 692 01/30/2015 MUD Payroll 1/30/15 Retirement 1,570.99 13,390.35 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,710.80 13,390.35 ** 42,840.00 Budgeted 29,449.65 Remaining 31 % Used Account: 135-50026-030-000 Medical Insurance 517 01/02/2015 PR 01-02-15 Medical Insurance 13,300.02 2,457.56 15,757.58 PR 621 01/16/2015 MUD Payroll 1/16/15 Medical Insurance 2,457.50 18,215.08 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,915.06 18,215.08 ** 65,015.00 Budgeted 46,799.92 Remaining 28 % Used Account: 135-50027-030-000 Dental Insurance 517 01/02/2015 PR 01-02-15 Dental Insurance 913.56 182.11 1,095.67 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 621 01/16/2015 MUD Payroll 1/16/15 Dental Insurance 913.56 182.13 1,277.80 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 364.24 1,277.80 ** 4,944.00 Budgeted 3,666.20 Remaining 26 % Used Account: 135-50028-030-000 Vision Insurance 517 01/02/2015 PR 01-02-15 Vision Insurance 219.45 42.16 261.61 PR 621 01/16/2015 MUD Payroll 1/16/15 Vision Insurance 42.22 303.83 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 84.38 303.83 ** 1,158.00 Budgeted 854.17 Remaining 26 % Used Account: 135-50029-030-000 Life Insurance & Other 503 01/01/2015 Jan A/P Jan Dental, Vision, Other Ins 1,044.14 331.92 1,376.06 METLIFE GROUP BENEFITS 34493 AP 696 01/27/2015 Jan A/P Café 125 Adm fee 33.78 1,409.84 BenefitMall 34588 AP 732 01/31/2015 January A/P Rounding adjustment (.05) 1,409.79 Legal Shield 34605 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 365.65 1,409.79 ** 4,333.00 Budgeted 2,923.21 Remaining 33 % Used Account: 135-50030-030-000 Social Security Taxes 517 01/02/2015 PR 01-02-15 Social Security Taxes 5,642.88 1,035.89 6,678.77 PR 621 01/16/2015 MUD Payroll 1/16/15 Social Security Taxes 1,036.32 7,715.09 PR 692 01/30/2015 MUD Payroll 1/30/15 Social Security Taxes 1,093.17 8,808.26 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 3,165.38 8,808.26 ** 30,079.00 Budgeted 21,270.74 Remaining 29 % Used Account: 135-50035-030-000 Medicare Taxes 517 01/02/2015 PR 01-02-15 Medicare Taxes 1,319.68 242.27 1,561.95 PR 621 01/16/2015 MUD Payroll 1/16/15 Medicare Taxes 242.35 1,804.30 PR 692 01/30/2015 MUD Payroll 1/30/15 Medicare Taxes 255.66 2,059.96 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 740.28 2,059.96 ** 7,422.00 Budgeted 5,362.04 Remaining 28 % Used Account: 135-50040-030-000 Unemployment Taxes 517 01/02/2015 PR 01-02-15 Unemployment Taxes 126.14 405.15 531.29 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 621 01/16/2015 MUD Payroll 1/16/15 Unemployment Taxes 126.14 405.34 936.63 PR 692 01/30/2015 MUD Payroll 1/30/15 Unemployment Taxes 294.57 1,231.20 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 1,105.06 1,231.20 ** 1,449.00 Budgeted 217.80 Remaining 85 % Used Account: 135-50045-030-000 Workman's Compensation 194 01/01/2015 Jan TML Ins & Workers Comp 261.90 87.30 349.20 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 349.20 ** 1,636.00 Budgeted 1,286.80 Remaining 21 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 38.00 .00 38.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 500.00 Budgeted 462.00 Remaining 8 % Used Account: 135-50070-030-000 Employee Relations 781 01/26/2015 PCards 12/27/14-1/26/15 TEFFEY FLOWERS 2,142.38 79.26 2,221.64 TEFFEY FLOWERS PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 79.26 2,221.64 ** 5,000.00 Budgeted 2,778.36 Remaining 44 % Used Account: 135-55030-030-000 Software & Support 616 01/12/2015 Jan A/P Vital Care Mobile Client (Annu 65,285.39 1,575.00 66,860.39 M3 Networks 34538 AP 647 01/16/2015 Void A/P CK34538/M3 Networks Vital Care Mobile Client (Annu (1,575.00) 65,285.39 M3 Networks 34538 AP 781 01/26/2015 PCards 12/27/14-1/26/15 M3 NETWORKS 1,575.00 66,860.39 M3 NETWORKS PC 781 01/26/2015 PCards 12/27/14-1/26/15 RINGCENTRAL, INC 9.99 66,870.38 RINGCENTRAL, INC PC 781 01/26/2015 PCards 12/27/14-1/26/15 ATT*BILL PAYMENT 52.25 66,922.63 ATT*BILL PAYMENT PC 781 01/26/2015 PCards 12/27/14-1/26/15 ATT*BILL PAYMENT 68.60 66,991.23 ATT*BILL PAYMENT PC 696 01/27/2015 Jan A/P IT BOA charges 124.97 67,116.20 TOWN OF TROPHY CLUB 34619 AP 696 01/27/2015 Jan A/P Support, Fixed Assets, Vision, 368.00 67,484.20 STW INC 34616 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (149.94) 67,334.26 AR 800 01/31/2015 Jan A/P Nevill, Charter 645.50 67,979.76 TOWN OF TROPHY CLUB AP 800 01/31/2015 Jan A/P Software & Support 426.50 68,406.26 STW INC AP _______________ Account: 135-55030-030-000 Software & Support Totals: 3,120.87 68,406.26 ** 87,423.00 Budgeted 19,016.74 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55070-030-000 Independent Labor 696 01/27/2015 Jan A/P Record MUD Meeting 8,943.75 75.00 9,018.75 MIGUEL CRUZ 34608 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 75.00 9,018.75 ** 32,550.00 Budgeted 23,531.25 Remaining 28 % Used Account: 135-55080-030-000 Maintenance & Repairs .00 .00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 .00 ** 4,500.00 Budgeted 4,500.00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 781 01/26/2015 PCards 12/27/14-1/26/15 AMAZON.COM 2,126.31 58.40 2,184.71 AMAZON.COM PC 781 01/26/2015 PCards 12/27/14-1/26/15 AMAZON MKTPLACE PMTS 299.83 2,484.54 AMAZON MKTPLACE PMTS PC 696 01/27/2015 Jan A/P Rug Service 95.42 2,579.96 G & K SERVICES 34596 AP 696 01/27/2015 Jan A/P Rug Service 95.42 2,675.38 G & K SERVICES 34596 AP 696 01/27/2015 Jan A/P Rug Service 95.42 2,770.80 G & K SERVICES 34596 AP 696 01/27/2015 Jan A/P 95.42 2,866.22 G & K SERVICES 34596 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (190.84) 2,675.38 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 549.07 2,675.38 ** 6,500.00 Budgeted 3,824.62 Remaining 41 % Used Account: 135-55120-030-000 Cleaning Services 732 01/31/2015 January A/P December Janitorial Service 1,255.06 627.53 1,882.59 MEMBER'S BUILDING MAINTENANCE 34606 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 627.53 1,882.59 ** 8,100.00 Budgeted 6,217.41 Remaining 23 % Used Account: 135-55160-030-000 Professional Outside Services 666 01/21/2015 Jan A/P Backflow inventory 37,077.95 3,950.00 41,027.95 SC TRACKING SOLUTIONS LLC 34581 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 3,950.00 41,027.95 ** 58,000.00 Budgeted 16,972.05 Remaining 71 % Used Account: 135-55161-030-000 Town Personnel Contract 20,000.00 .00 20,000.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 20,000.00 ** 26,170.00 Budgeted 6,170.00 Remaining 76 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 802 01/31/2015 Jan A/P Jan Water Billing 1,823.85 595.95 2,419.80 DATAPROSE LLC AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 595.95 2,419.80 ** 8,200.00 Budgeted 5,780.20 Remaining 30 % Used Account: 135-60005-030-000 Telephone 616 01/12/2015 Jan A/P Answering Service 2,292.14 180.00 2,472.14 KEYSTONE PARK SECRETARIAL 34526 AP 696 01/27/2015 Jan A/P IT BOA charges 860.67 3,332.81 TOWN OF TROPHY CLUB 34619 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,040.67 3,332.81 ** 13,361.00 Budgeted 10,028.19 Remaining 25 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 621 01/16/2015 MUD Payroll 1/16/15 Communications/Pagers/Mobiles 1,013.29 300.00 1,313.29 PR 662 01/19/2015 Jan A/P Cell phones 12/2/14 - 1/1/15 37.99 1,351.28 VERIZON WIRELESS 34582 AP 696 01/27/2015 Jan A/P Verizon, GEXA (22.38) 1,328.90 TOWN OF TROPHY CLUB 34619 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 315.61 1,328.90 ** 4,056.00 Budgeted 2,727.10 Remaining 33 % Used Account: 135-60020-030-000 Electricity/Gas 696 01/27/2015 Jan A/P Verizon, GEXA 341.45 1,073.02 1,414.47 TOWN OF TROPHY CLUB 34619 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,073.02 1,414.47 ** 14,978.00 Budgeted 13,563.53 Remaining 9 % Used Account: 135-60025-030-000 Water . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 732 01/31/2015 January A/P January water 260.02 106.93 366.95 TROPHY CLUB MUD (WATER BILLS) 34620 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (53.47) 313.48 AR _______________ Account: 135-60025-030-000 Water Totals: 53.46 313.48 ** 1,500.00 Budgeted 1,186.52 Remaining 21 % Used Account: 135-60035-030-000 Postage 662 01/19/2015 Jan A/P Overnight letters 7,649.67 10.28 7,659.95 FEDERAL EXPRESS CORP 34572 AP 657 01/31/2015 Jan 2015 MUD Postage meter 138.99 7,798.94 UB 800 01/31/2015 Jan A/P Overnight FY2014 Audit to TCEQ 5.77 7,804.71 FEDERAL EXPRESS CORP AP 802 01/31/2015 Jan A/P Jan Water Billing 1,790.09 9,594.80 DATAPROSE LLC AP _______________ Account: 135-60035-030-000 Postage Totals: 1,945.13 9,594.80 ** 28,500.00 Budgeted 18,905.20 Remaining 34 % Used Account: 135-60040-030-000 Service Charges & Fees 752 01/05/2015 Dec 2014 CC Fees 9,561.24 100.32 9,661.56 GL 752 01/05/2015 Dec 2014 CC Fees 108.95 9,770.51 GL 752 01/05/2015 Dec 2014 CC Fees 3,348.22 13,118.73 GL 748 01/13/2015 Bank Analysis Fee- Dec 250.00 13,368.73 GL 781 01/26/2015 PCards 12/27/14-1/26/15 600.00 13,968.73 PC _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,407.49 13,968.73 ** 32,000.00 Budgeted 18,031.27 Remaining 44 % Used Account: 135-60050-030-000 Bad Debt Expense 303.44 .00 303.44 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 303.44 ** 6,200.00 Budgeted 5,896.56 Remaining 5 % Used Account: 135-60055-030-000 Insurance 194 01/01/2015 Jan TML Ins & Workers Comp 12,222.28 4,063.01 16,285.29 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,063.01 16,285.29 ** 48,751.00 Budgeted 32,465.71 Remaining 33 % Used Account: 135-60066-030-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 151.00 .00 151.00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 151.00 ** 1,000.00 Budgeted 849.00 Remaining 15 % Used Account: 135-60070-030-000 Dues & Memberships 4,055.95 .00 4,055.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,055.95 ** 5,000.00 Budgeted 944.05 Remaining 81 % Used Account: 135-60075-030-000 Meetings 25.11 .00 25.11 _______________ Account: 135-60075-030-000 Meetings Totals: .00 25.11 ** 400.00 Budgeted 374.89 Remaining 6 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 268.00 .00 268.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 268.00 ** 10,235.00 Budgeted 9,967.00 Remaining 3 % Used Account: 135-60100-030-000 Travel & per diem 616 01/12/2015 Jan A/P Mileage reimbursement/January 377.83 50.43 428.26 LAURIE SLAGHT 34528 AP 621 01/16/2015 MUD Payroll 1/16/15 Travel & per diem 42.19 470.45 PR 781 01/26/2015 PCards 12/27/14-1/26/15 SUNDANCE SQ G1 B2 10.00 480.45 SUNDANCE SQ G1 B2 PC 692 01/30/2015 MUD Payroll 1/30/15 Travel & per diem 31.29 511.74 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 133.91 511.74 ** 5,400.00 Budgeted 4,888.26 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 781 01/26/2015 PCards 12/27/14-1/26/15 FASTSIGNS 192.00 47.28 239.28 FASTSIGNS PC _______________ Account: 135-60125-030-000 Advertising Totals: 47.28 239.28 ** 2,500.00 Budgeted 2,260.72 Remaining 10 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 3,366.65 .00 3,366.65 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 3,366.65 ** 17,500.00 Budgeted 14,133.35 Remaining 19 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 5,035.96 .00 5,035.96 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 5,035.96 ** 10,475.00 Budgeted 5,439.04 Remaining 48 % Used Account: 135-65010-030-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,043.00 .00 1,043.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 1,043.00 ** 1,855.00 Budgeted 812.00 Remaining 56 % Used Account: 135-65055-030-000 Hardware 660 01/19/2015 Capital Outlay Servers Capital Outlay Servers 73,784.40 (41,927.16) 31,857.24 GL _______________ Account: 135-65055-030-000 Hardware Totals: (41,927.16) 31,857.24 ** 35,226.00 Budgeted 3,368.76 Remaining 90 % Used Account: 135-65085-030-000 Office Supplies 662 01/19/2015 Jan A/P Office Supplies 1,310.95 52.81 1,363.76 OFFICE DEPOT, INC 34579 AP 662 01/19/2015 Jan A/P Office supplies 26.99 1,390.75 OFFICE DEPOT, INC 34579 AP 666 01/21/2015 Jan A/P Office supplies 24.48 1,415.23 OFFICE DEPOT, INC 34579 AP 666 01/21/2015 Jan A/P Office supplies 70.38 1,485.61 OFFICE DEPOT, INC 34579 AP 781 01/26/2015 PCards 12/27/14-1/26/15 MICHAELS STORES 2063 37.57 1,523.18 MICHAELS STORES 2063 PC 781 01/26/2015 PCards 12/27/14-1/26/15 STAPLES 00116533 24.86 1,548.04 STAPLES 00116533 PC 781 01/26/2015 PCards 12/27/14-1/26/15 OFFICE DEPOT #406 46.98 1,595.02 OFFICE DEPOT #406 PC 781 01/26/2015 PCards 12/27/14-1/26/15 DESKTOP SUPPLIES.COM 381.24 1,976.26 DESKTOP SUPPLIES.COM PC 781 01/26/2015 PCards 12/27/14-1/26/15 MICHAELS STORES 2063 38.91 2,015.17 MICHAELS STORES 2063 PC 781 01/26/2015 PCards 12/27/14-1/26/15 STAPLES DIRECT (2.89) 2,012.28 STAPLES DIRECT PC 781 01/26/2015 PCards 12/27/14-1/26/15 OFFICE DEPOT #406 4.17 2,016.45 OFFICE DEPOT #406 PC 781 01/26/2015 PCards 12/27/14-1/26/15 STAPLES DIRECT 37.98 2,054.43 STAPLES DIRECT PC 696 01/27/2015 Jan A/P Office Supplies 48.82 2,103.25 OFFICE DEPOT, INC 34612 AP 696 01/27/2015 Jan A/P Office Supplies 19.78 2,123.03 OFFICE DEPOT, INC 34612 AP 696 01/27/2015 Jan A/P Office Supplies 52.09 2,175.12 OFFICE DEPOT, INC 34612 AP 696 01/27/2015 Jan A/P Office Supplies 4.64 2,179.76 OFFICE DEPOT, INC 34612 AP 732 01/31/2015 January A/P Office Supplies 47.89 2,227.65 OFFICE DEPOT, INC 34612 AP 732 01/31/2015 January A/P Office Supplies 22.99 2,250.64 OFFICE DEPOT, INC 34612 AP 780 01/31/2015 Bill Town Inv 1256-1267 AR 20150131-20150131 User: (45.66) 2,204.98 AR 800 01/31/2015 Jan A/P Copy paper 17.49 2,222.47 TOWN OF TROPHY CLUB AP 800 01/31/2015 Jan A/P Office Supplies 63.28 2,285.75 OFFICE DEPOT, INC AP 800 01/31/2015 Jan A/P Office Supplies 40.09 2,325.84 OFFICE DEPOT, INC AP 800 01/31/2015 Jan A/P Office Supplies 11.43 2,337.27 OFFICE DEPOT, INC AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 1,026.32 2,337.27 ** 9,000.00 Budgeted 6,662.73 Remaining 26 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 253.10 .00 253.10 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 253.10 ** 4,732.00 Budgeted 4,478.90 Remaining 5 % Used Account: 135-65095-030-000 Maintenance Supplies 781 01/26/2015 PCards 12/27/14-1/26/15 THE HOME DEPOT 6581 1,289.54 29.97 1,319.51 THE HOME DEPOT 6581 PC 781 01/26/2015 PCards 12/27/14-1/26/15 WAL-MART #5247 38.92 1,358.43 WAL-MART #5247 PC 781 01/26/2015 PCards 12/27/14-1/26/15 AMAZON.COM 43.56 1,401.99 AMAZON.COM PC 781 01/26/2015 PCards 12/27/14-1/26/15 SAMS CLUB #4795 213.32 1,615.31 SAMS CLUB #4795 PC 800 01/31/2015 Jan A/P Supplies 6.29 1,621.60 COSTCO WHOLESALE AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 332.06 1,621.60 ** 5,000.00 Budgeted 3,378.40 Remaining 32 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays 660 01/19/2015 Capital Outlay Servers Capital Outlay Servers 41,927.16 41,927.16 GL 800 01/31/2015 Jan A/P 2015 Ford Escape 19,799.50 61,726.66 SILSBEE FORD INC AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 61,726.66 61,726.66 ** 67,000.00 Budgeted 5,273.34 Remaining 92 % Used Account: 135-69170-030-000 Copier Lease Installments 800 01/31/2015 Jan A/P Nevill, Charter 648.01 278.33 926.34 TOWN OF TROPHY CLUB AP 800 01/31/2015 Jan A/P Nevill, Charter 21.37 947.71 TOWN OF TROPHY CLUB AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 299.70 947.71 ** 4,236.00 Budgeted 3,288.29 Remaining 22 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 .00 16,329.00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 16,329.00 ** 16,329.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 520,572.06 ** 1,244,664.00 Budgeted 724,091.94 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 662 01/19/2015 Jan A/P Legal - December 212,388.79 602.36 212,991.15 Fulbright & Jaworski LLP 34573 AP 662 01/19/2015 Jan A/P December Legal 4,410.09 217,401.24 WHITAKER CHALK SWINDLE 34583 AP 662 01/19/2015 Jan A/P December Legal 60.90 217,462.14 WHITAKER CHALK SWINDLE 34583 AP 662 01/19/2015 Jan A/P December Legal 13,616.46 231,078.60 WHITAKER CHALK SWINDLE 34583 AP 696 01/27/2015 Jan A/P Dec Legal 3,976.25 235,054.85 THE LISTON LAW FIRM, P.C. 34618 AP 800 01/31/2015 Jan A/P January Legal 8,789.00 243,843.85 THE LISTON LAW FIRM, P.C. AP 800 01/31/2015 Jan A/P Jan Legal 7,892.50 251,736.35 FREEMAN & CORBETT AP _______________ Account: 135-55045-039-000 Legal Totals: 39,347.56 251,736.35 ** 300,000.00 Budgeted 48,263.65 Remaining 84 % Used Account: 135-55055-039-000 Auditing 616 01/12/2015 Jan A/P FYE14 Audit progress bill 10,918.00 10,918.00 LAFOLLETT & ABBOTT PLLC 34527 AP 732 01/31/2015 January A/P 2014 Audit 5,918.00 16,836.00 LAFOLLETT & ABBOTT PLLC 34604 AP _______________ Account: 135-55055-039-000 Auditing Totals: 16,836.00 16,836.00 ** 22,491.00 Budgeted 5,655.00 Remaining 75 % Used Account: 135-55060-039-000 Appraisal 625 01/13/2015 Jan A/P Balance due TAD Annual Apprais 4,158.77 40.97 4,199.74 TARRANT APPRAISAL DISTRICT 34551 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 40.97 4,199.74 ** 10,000.00 Budgeted 5,800.26 Remaining 42 % Used Account: 135-55065-039-000 Tax Admin Fees 2,456.40 .00 2,456.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,456.40 ** 3,800.00 Budgeted 1,343.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 275,228.49 ** 336,291.00 Budgeted 61,062.51 Remaining 82 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (1,029,517.65) .00 Budgeted 1,029,517.65 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (91,329.00) .00 (91,329.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (91,329.00) ** .00 Budgeted 91,329.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (17,950.00) .00 (17,950.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (17,950.00) ** .00 Budgeted 17,950.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (109,279.00) ** .00 Budgeted 109,279.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-030-000 GASB Replacement 74,706.00 .00 74,706.00 _______________ Account: 137-69195-030-000 GASB Replacement Totals: .00 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-045-000 GASB Replacement 125,670.00 .00 125,670.00 _______________ Account: 137-69195-045-000 GASB Replacement Totals: .00 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ 91,097.00 .00 Budgeted (91,097.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 749 01/31/2015 Bank Interest/January (4.02) (.97) (4.99) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (.97) (4.99) ** .00 Budgeted 4.99 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4.99) ** .00 Budgeted 4.99 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 2,100.00 .00 2,100.00 _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: .00 2,100.00 ** 3,348.00 Budgeted 1,248.00 Remaining 63 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,100.00 ** 3,348.00 Budgeted 1,248.00 Remaining 63 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 2,095.01 3,348.00 Budgeted 1,252.99 Remaining 63 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET JANUARY 2015 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,405,023 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,405,023 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 28,194 TOTAL LIABILITIES 28,194 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 4,376,829 TOTAL FUND BALANCE 4,376,829 TOTAL LIABILITIES AND FUND BALANCE 4,405,023 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 16:39 02/11/15 Budget Summary with Amendment Fund: 517 MUD 1 Tax Bond Const WWTP Department: Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 183.75- 244.89- 244.89 517-49105-000-000 Bond Proceeds 5,616,800.00- 5,616,800.00 Subtotal: 183.75- 5,617,044.89- 5,617,044.89 Program number: 183.75- 5,617,044.89- 5,617,044.89 Department number: 183.75- 5,617,044.89- 5,617,044.89 Revenues Subtotal ----------- 183.75- 5,617,044.89- 5,617,044.89 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 16:39 02/11/15 Budget Summary with Amendment Fund: 517 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60135-020-000 TCEQ Permits & Fees 14,376.56 14,376.56- 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 1,074,337.15 1,074,337.15- Subtotal: 1,074,337.15 1,088,713.71 1,088,713.71- 517-69005-020-000 Capital Outlays 13,817.50 151,502.50 151,502.50- Subtotal: 13,817.50 151,502.50 151,502.50- Program number: 1,088,154.65 1,240,216.21 1,240,216.21- Department number: Wastewater 1,088,154.65 1,240,216.21 1,240,216.21- Expenditures Subtotal ----------- 1,088,154.65 1,240,216.21 1,240,216.21- Fund number: 517 MUD 1 Tax Bond Const WWTP 1,087,970.90 4,376,828.68- 4,376,828.68 . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 517 MUD 1 Tax Bond Const WWTP Department: Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 749 01/31/2015 Bank Interest/January (61.14) (183.75) (244.89) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (183.75) (244.89) ** .00 Budgeted 244.89 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds (5,616,800.00) .00 (5,616,800.00) _______________ Account: 517-49105-000-000 Bond Proceeds Totals: .00 (5,616,800.00) ** .00 Budgeted 5,616,800.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,617,044.89) ** .00 Budgeted 5,617,044.89 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 517 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-60135-020-000 TCEQ Permits & Fees 14,376.56 .00 14,376.56 _______________ Account: 517-60135-020-000 TCEQ Permits & Fees Totals: .00 14,376.56 ** .00 Budgeted (14,376.56) Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 659 01/07/2015 Tax Bond Const Reimb Gen Fund 1,074,337.15 1,074,337.15 GL _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: 1,074,337.15 1,074,337.15 ** .00 Budgeted (1,074,337.15) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 800 01/31/2015 Jan A/P WWTP Improvements 137,685.00 13,817.50 151,502.50 THE WALLACE GROUP, INC. AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 13,817.50 151,502.50 ** .00 Budgeted (151,502.50) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,240,216.21 ** .00 Budgeted (1,240,216.21) Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (4,376,828.68) .00 Budgeted 4,376,828.68 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JANUARY 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 428,719 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 66,170 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 499,736 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 66,170 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 66,170 FUND BALANCE ASSIGNED FUND BALANCE 14,753 NET REVENUES / EXPENDITURES 418,813 TOTAL FUND BALANCE 433,566 TOTAL LIABILITIES AND FUND BALANCE 499,736 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 16:39 02/11/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 466,019.00- 466,019.00- 156,241.14- 408,882.91- 87.740 57,136.09- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 34.10 1,365.29- 54.612 1,134.71- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 2.60 295.42- 18.464 1,304.58- Subtotal: 470,119.00- 470,119.00- 156,204.44- 410,543.62- 87.328 59,575.38- 533-48005-000-000 Reserve Funds/PID Utility Fees 100,000.00- 100,000.00- 100,000.00- 533-48015-000-000 WW Sales Rev Trnsf for Debt 357,538.00- 357,538.00- 357,538.00- Subtotal: 457,538.00- 457,538.00- 457,538.00- 533-49010-000-000 Interest Income 375.00- 375.00- 11.70- 3,311.67- 883.112 2,936.67 533-49015-000-000 Lease/Rental Income 211,829.00- 211,829.00- 211,829.00- 533-49110-000-000 Premium on Bonds Sold 4,957.90- 4,957.90 Subtotal: 212,204.00- 212,204.00- 11.70- 8,269.57- 3.897 203,934.43- Program number: 1,139,861.00- 1,139,861.00- 156,216.14- 418,813.19- 36.742 721,047.81- Department number: Revenues 1,139,861.00- 1,139,861.00- 156,216.14- 418,813.19- 36.742 721,047.81- Revenues Subtotal ----------- 1,139,861.00- 1,139,861.00- 156,216.14- 418,813.19- 36.742 721,047.81- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 16:39 02/11/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,550.00 2,550.00 2,550.00 533-70025-051-000 Bond Interest Expense-Tax 403,103.00 403,103.00 403,103.00 533-70035-051-000 Bond Principal Payment-Tax 440,000.00 440,000.00 440,000.00 533-70040-051-000 Bond Interest Expense-Revenue 292,283.00 292,283.00 292,283.00 Subtotal: 1,137,936.00 1,137,936.00 1,137,936.00 Program number: 1,137,936.00 1,137,936.00 1,137,936.00 Department number: Administration 1,137,936.00 1,137,936.00 1,137,936.00 Expenditures Subtotal ----------- 1,137,936.00 1,137,936.00 1,137,936.00 Fund number: 533 MUD 1 I&S Consolidated 1,925.00- 1,925.00- 156,216.14- 418,813.19- ############### 416,888.19 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 757 01/02/2015 Property Taxes/Assessments (252,641.77) (6,258.92) (258,900.69) GL 758 01/05/2015 Property Taxes/Assessments (3,112.07) (262,012.76) GL 759 01/06/2015 Property Taxes/Assessments (5,852.74) (267,865.50) GL 760 01/07/2015 Property Taxes/Assessments (3,516.59) (271,382.09) GL 764 01/08/2015 Property Taxes/Assessments (3,581.65) (274,963.74) GL 765 01/09/2015 Property Taxes/Assessments (3,197.46) (278,161.20) GL 766 01/12/2015 Property Taxes/Assessments (3,260.15) (281,421.35) GL 767 01/13/2015 Property Taxes/Assessments (1,047.24) (282,468.59) GL 768 01/14/2015 Property Taxes/Assessments (3,189.52) (285,658.11) GL 769 01/15/2015 Property Taxes/Assessments (4,575.89) (290,234.00) GL 770 01/16/2015 Property Taxes/Assessments (2,389.44) (292,623.44) GL 771 01/20/2015 Property Taxes/Assessments (1,560.31) (294,183.75) GL 772 01/21/2015 Property Taxes/Assessments (6,521.42) (300,705.17) GL 773 01/22/2015 Property Taxes/Assessments (3,016.29) (303,721.46) GL 774 01/23/2015 Property Taxes/Assessments (5,619.58) (309,341.04) GL 775 01/26/2015 Property Taxes/Assessments (7,931.17) (317,272.21) GL 776 01/27/2015 Property Taxes/Assessments (8,045.25) (325,317.46) GL 777 01/28/2015 Property Taxes/Assessments (61,757.61) (387,075.07) GL 778 01/29/2015 Property Taxes/Assessments (11,770.49) (398,845.56) GL 779 01/30/2015 Property Taxes/Assessments (10,037.35) (408,882.91) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (156,241.14) (408,882.91) ** (466,019.00) Budgeted (57,136.09) Remaining 88 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 758 01/05/2015 Property Taxes/Assessments (1,399.39) 21.81 (1,377.58) GL 759 01/06/2015 Property Taxes/Assessments (.01) (1,377.59) GL 765 01/09/2015 Property Taxes/Assessments 34.11 (1,343.48) GL 767 01/13/2015 Property Taxes/Assessments (21.81) (1,365.29) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 34.10 (1,365.29) ** (2,500.00) Budgeted (1,134.71) Remaining 55 % Used Account: 533-40015-000-000 Property Taxes/P & I 765 01/09/2015 Property Taxes/Assessments (298.02) 7.84 (290.18) GL 767 01/13/2015 Property Taxes/Assessments (5.24) (295.42) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: 2.60 (295.42) ** (1,600.00) Budgeted (1,304.58) Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (100,000.00) Budgeted (100,000.00) Remaining 0 % Used Account: 533-48015-000-000 WW Sales Rev Trnsf for Debt .00 .00 _______________ Account: 533-48015-000-000 WW Sales Rev Trnsf for Debt Totals: .00 .00 ** (357,538.00) Budgeted (357,538.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 749 01/31/2015 Bank Interest/January (3,299.97) (11.70) (3,311.67) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (11.70) (3,311.67) ** (375.00) Budgeted 2,936.67 Remaining 883 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (211,829.00) Budgeted (211,829.00) Remaining 0 % Used Account: 533-49110-000-000 Premium on Bonds Sold (4,957.90) .00 (4,957.90) _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: .00 (4,957.90) ** .00 Budgeted 4,957.90 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (418,813.19) ** (1,139,861.00) Budgeted (721,047.81) Remaining 37 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 16:39 02/11/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 .00 ** 2,550.00 Budgeted 2,550.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 403,103.00 Budgeted 403,103.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 440,000.00 Budgeted 440,000.00 Remaining 0 % Used Account: 533-70040-051-000 Bond Interest Expense-Revenue .00 .00 _______________ Account: 533-70040-051-000 Bond Interest Expense-Revenue Totals: .00 .00 ** 292,283.00 Budgeted 292,283.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 1,137,936.00 Budgeted 1,137,936.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (418,813.19) (1,925.00) Budgeted 416,888.19 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (6,429,657.78) **** 1,423.00 Budgeted 6,431,080.78 Remaining ########## ******* End of Report *********