Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2015-02 Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET FEBRUARY 2015 122 ASSETS FIRE DEPT. CASH IN BANK 25,082 INVESTMENTS 1,016,710 PREPAID EXPENSES 11,193 ADVALOREM PROPERTY TAXES RECEIVABLE 50,688 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 16,657 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,987 TOTAL ASSETS 1,122,317 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 67,345 ACCOUNTS AND OTHER PAYABLES 5,593 TOTAL LIABILITIES 72,938 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 520,468 TOTAL FUND BALANCE 1,049,379 TOTAL LIABILITIES AND FUND BALANCE 1,122,317 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 17:59 03/06/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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- 18,339.03- 348,939.20- 97.616 8,522.80- 122-40003-000-000 Emer Svcs Assessmen/Delinquent .01- 108.29- 108.29 122-40010-000-000 Property Taxes/MUD Fire 872,859.00- 872,859.00- 75,901.19- 841,640.92- 96.423 31,218.08- 122-40011-000-000 Property Taxes/Fire-Delinquent 359.04- 3,594.93- 3,594.93 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 65.04- 82.37- 10.983 667.63- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 744.75- 1,782.46- 39.610 2,717.54- Subtotal: 1,235,571.00- 1,235,571.00- 95,409.06- 1,196,148.17- 96.809 39,422.83- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 4,400.00- 73.333 1,600.00- Subtotal: 6,000.00- 6,000.00- 400.00- 4,400.00- 73.333 1,600.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 75.00- 825.00- 117.857 125.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,700.00- 10,700.00- 75.00- 10,825.00- 101.168 125.00 122-49000-000-000 Capital Lease-Oth Fin Sources 807,316.14- 807,316.14 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- 800.00- 8,800.00- 146.667 2,800.00 Subtotal: 131,669.00- 131,669.00- 800.00- 941,786.14- 715.268 810,117.14 Program number: 1,383,940.00- 1,383,940.00- 96,684.06- 2,153,159.31- 155.582 769,219.31 Department number: Fire Revenues 1,383,940.00- 1,383,940.00- 96,684.06- 2,153,159.31- 155.582 769,219.31 Revenues Subtotal ----------- 1,383,940.00- 1,383,940.00- 96,684.06- 2,153,159.31- 155.582 769,219.31 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 17:59 03/06/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 36,512.41 184,491.62 39.332 284,575.38 122-50010-045-000 Overtime 46,745.00 46,745.00 2,290.53 13,059.19 27.937 33,685.81 122-50011-045-000 DPS Holiday Pay 14,930.00 14,930.00 68.68 14,525.69 97.292 404.31 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,969.00 41.021 2,831.00 122-50020-045-000 Retirement 91,396.00 91,396.00 5,251.01 30,714.19 33.606 60,681.81 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,945.14 22,714.03 38.388 36,454.97 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 378.16 1,754.33 39.962 2,635.67 122-50028-045-000 Vision Insurance 811.00 811.00 66.30 307.63 37.932 503.37 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 330.56 1,533.82 38.060 2,496.18 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 2,207.98 12,528.65 37.487 20,892.35 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 516.30 2,929.37 40.172 4,362.63 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 336.91 1,607.96 97.040 49.04 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 658.99 3,294.99 37.908 5,397.01 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 54,025.47 296,749.19 39.437 455,705.81 122-55030-045-000 Software & Support 7,378.00 7,378.00 462.50 2,342.67 31.752 5,035.33 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,034.40 4,244.28 22.878 14,307.72 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 2,113.00 3,880.86 32.341 8,119.14 Subtotal: 39,430.00 39,430.00 3,609.90 10,467.81 26.548 28,962.19 122-60005-045-000 Telephone 50.00 50.00 5.68 22.81 45.620 27.19 122-60010-045-000 Communications/Pagers/Mobiles 5,000.00 5,000.00 177.65 3,057.09 61.142 1,942.91 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 501.90 1,989.10 22.037 7,036.90 122-60025-045-000 Water 1,200.00 1,200.00 112.98 532.55 44.379 667.45 122-60026-045-000 Cable 1,920.00 1,920.00 287.10 902.14 46.986 1,017.86 122-60030-045-000 Rent And/Or Usage 211,829.00 211,829.00 211,829.00 211,829.00 100.000 122-60035-045-000 Postage 100.00 100.00 8.64 8.640 91.36 122-60055-045-000 Insurance 12,179.00 12,179.00 940.08 4,700.44 38.595 7,478.56 122-60066-045-000 Publications/Books/Subscrips 200.00 200.00 219.05 109.525 19.05- 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 15,452.85 101.797 272.85- 122-60080-045-000 Schools & Training 4,280.00 4,280.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 2,061.66 3,506.98 25.830 10,070.02 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 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 85.00 932.10 46.605 1,067.90 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 17:59 03/06/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 216,001.05 245,942.32 84.359 45,598.68 122-65005-045-000 Fuel & Lube 10,454.00 10,454.00 270.00 2,429.52 23.240 8,024.48 122-65010-045-000 Uniforms 2,000.00 2,000.00 1,327.12 66.356 672.88 122-65015-045-000 Protective Clothing 5,200.00 15,200.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 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 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 270.00 4,265.94 10.559 36,136.06 122-69005-045-000 Capital Outlays 1,057,316.14 1,057,316.14- 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 1,075,266.14 413.386 815,154.14- Program number: 1,383,940.00 1,383,940.00 273,906.42 1,632,691.40 117.974 248,751.40- Department number: Fire 1,383,940.00 1,383,940.00 273,906.42 1,632,691.40 117.974 248,751.40- Expenditures Subtotal ----------- 1,383,940.00 1,383,940.00 273,906.42 1,632,691.40 117.974 248,751.40- Fund number: 122 Trophy Club MUD Fire Dept. 177,222.36 520,467.91- 520,467.91 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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 910 02/02/2015 Property Taxes/Assessments (330,600.17) (6,143.82) (336,743.99) GL 909 02/03/2015 Property Taxes/Assessments (2,425.58) (339,169.57) GL 911 02/04/2015 Property Taxes/Assessments (2,723.99) (341,893.56) GL 912 02/05/2015 Property Taxes/Assessments (2,361.00) (344,254.56) GL 913 02/06/2015 Property Taxes/Assessments (3,562.27) (347,816.83) GL 915 02/10/2015 Property Taxes/Assessments (642.09) (348,458.92) GL 918 02/13/2015 Property Taxes/Assessments (10.62) (348,469.54) GL 919 02/17/2015 Property Taxes/Assessments (358.85) (348,828.39) GL 906 02/20/2015 Property Taxes/Assessments (110.81) (348,939.20) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (18,339.03) (348,939.20) ** (357,462.00) Budgeted (8,522.80) Remaining 98 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 910 02/02/2015 Property Taxes/Assessments (108.28) (.01) (108.29) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (.01) (108.29) ** .00 Budgeted 108.29 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 910 02/02/2015 Property Taxes/Assessments (765,739.73) (14,538.85) (780,278.58) GL 909 02/03/2015 Property Taxes/Assessments (4,209.15) (784,487.73) GL 911 02/04/2015 Property Taxes/Assessments (11,473.52) (795,961.25) GL 912 02/05/2015 Property Taxes/Assessments (5,385.23) (801,346.48) GL 913 02/06/2015 Property Taxes/Assessments (30,214.94) (831,561.42) GL 914 02/09/2015 Property Taxes/Assessments (4,896.98) (836,458.40) GL 915 02/10/2015 Property Taxes/Assessments (1,229.56) (837,687.96) GL 916 02/11/2015 Property Taxes/Assessments (177.36) (837,865.32) GL 917 02/12/2015 Property Taxes/Assessments (124.78) (837,990.10) GL 918 02/13/2015 Property Taxes/Assessments (1,005.55) (838,995.65) GL 919 02/17/2015 Property Taxes/Assessments (1,095.27) (840,090.92) GL 908 02/18/2015 Property Taxes/Assessments (339.47) (840,430.39) GL 907 02/19/2015 Property Taxes/Assessments (300.63) (840,731.02) GL 906 02/20/2015 Property Taxes/Assessments (405.03) (841,136.05) GL 905 02/25/2015 Property Taxes/Assessments (339.02) (841,475.07) GL 904 02/26/2015 Property Taxes/Assessments (165.85) (841,640.92) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (75,901.19) (841,640.92) ** (872,859.00) Budgeted (31,218.08) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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-40011-000-000 Property Taxes/Fire-Delinquent 910 02/02/2015 Property Taxes/Assessments (3,235.89) (29.44) (3,265.33) GL 909 02/03/2015 Property Taxes/Assessments (10.14) (3,275.47) GL 913 02/06/2015 Property Taxes/Assessments (675.11) (3,950.58) GL 908 02/18/2015 Property Taxes/Assessments 355.65 (3,594.93) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (359.04) (3,594.93) ** .00 Budgeted 3,594.93 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 913 02/06/2015 Property Taxes/Assessments (17.33) (5.20) (22.53) GL 915 02/10/2015 Property Taxes/Assessments (26.23) (48.76) GL 918 02/13/2015 Property Taxes/Assessments (.74) (49.50) GL 919 02/17/2015 Property Taxes/Assessments (25.11) (74.61) GL 906 02/20/2015 Property Taxes/Assessments (7.76) (82.37) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (65.04) (82.37) ** (750.00) Budgeted (667.63) Remaining 11 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 910 02/02/2015 Property Taxes/Assessments (1,037.71) (7.06) (1,044.77) GL 909 02/03/2015 Property Taxes/Assessments (2.44) (1,047.21) GL 912 02/05/2015 Property Taxes/Assessments (2.58) (1,049.79) GL 913 02/06/2015 Property Taxes/Assessments (273.95) (1,323.74) GL 914 02/09/2015 Property Taxes/Assessments (176.71) (1,500.45) GL 916 02/11/2015 Property Taxes/Assessments (12.41) (1,512.86) GL 917 02/12/2015 Property Taxes/Assessments (14.06) (1,526.92) GL 918 02/13/2015 Property Taxes/Assessments (70.38) (1,597.30) GL 919 02/17/2015 Property Taxes/Assessments (76.67) (1,673.97) GL 908 02/18/2015 Property Taxes/Assessments (23.75) (1,697.72) GL 907 02/19/2015 Property Taxes/Assessments (21.05) (1,718.77) GL 906 02/20/2015 Property Taxes/Assessments (28.35) (1,747.12) GL 905 02/25/2015 Property Taxes/Assessments (23.73) (1,770.85) GL 904 02/26/2015 Property Taxes/Assessments (11.61) (1,782.46) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (744.75) (1,782.46) ** (4,500.00) Budgeted (2,717.54) Remaining 40 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (4,000.00) (400.00) (4,400.00) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (4,400.00) ** (6,000.00) Budgeted (1,600.00) Remaining 73 % Used Account: 122-43400-000-000 Fire Inspections 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (750.00) (75.00) (825.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (825.00) ** (700.00) Budgeted 125.00 Remaining 118 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49000-000-000 Capital Lease-Oth Fin Sources (807,316.14) .00 (807,316.14) _______________ Account: 122-49000-000-000 Capital Lease-Oth Fin Sources Totals: .00 (807,316.14) ** .00 Budgeted 807,316.14 Remaining 0 % 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 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (8,000.00) (800.00) (8,800.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (800.00) (8,800.00) ** (6,000.00) Budgeted 2,800.00 Remaining 147 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,153,159.31) ** (1,383,940.00) Budgeted 769,219.31 Remaining 156 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 834 02/13/2015 FD Payroll 02/13/15 147,979.21 18,017.02 165,996.23 GL 867 02/27/2015 FD Payroll 2/27/15 18,495.39 184,491.62 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 36,512.41 184,491.62 ** 469,067.00 Budgeted 284,575.38 Remaining 39 % Used Account: 122-50010-045-000 Overtime 834 02/13/2015 FD Payroll 02/13/15 10,768.66 2,290.53 13,059.19 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,290.53 13,059.19 ** 46,745.00 Budgeted 33,685.81 Remaining 28 % Used Account: 122-50011-045-000 DPS Holiday Pay 867 02/27/2015 FD Payroll 2/27/15 14,457.01 68.68 14,525.69 GL _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: 68.68 14,525.69 ** 14,930.00 Budgeted 404.31 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 834 02/13/2015 FD Payroll 02/13/15 1,506.50 462.50 1,969.00 GL _______________ Account: 122-50017-045-000 Certification Totals: 462.50 1,969.00 ** 4,800.00 Budgeted 2,831.00 Remaining 41 % Used Account: 122-50020-045-000 Retirement 834 02/13/2015 FD Payroll 02/13/15 25,463.18 2,789.33 28,252.51 GL 867 02/27/2015 FD Payroll 2/27/15 2,461.68 30,714.19 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,251.01 30,714.19 ** 91,396.00 Budgeted 60,681.81 Remaining 34 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 834 02/13/2015 FD Payroll 02/13/15 17,768.89 2,798.43 20,567.32 GL 867 02/27/2015 FD Payroll 2/27/15 2,146.71 22,714.03 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,945.14 22,714.03 ** 59,169.00 Budgeted 36,454.97 Remaining 38 % Used Account: 122-50027-045-000 Dental Insurance 834 02/13/2015 FD Payroll 02/13/15 1,376.17 189.04 1,565.21 GL 867 02/27/2015 FD Payroll 2/27/15 189.12 1,754.33 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 378.16 1,754.33 ** 4,390.00 Budgeted 2,635.67 Remaining 40 % Used Account: 122-50028-045-000 Vision Insurance 834 02/13/2015 FD Payroll 02/13/15 241.33 33.11 274.44 GL 867 02/27/2015 FD Payroll 2/27/15 33.19 307.63 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 66.30 307.63 ** 811.00 Budgeted 503.37 Remaining 38 % Used Account: 122-50029-045-000 Life Insurance & Other 834 02/13/2015 FD Payroll 02/13/15 1,203.26 165.22 1,368.48 GL 867 02/27/2015 FD Payroll 2/27/15 165.34 1,533.82 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 330.56 1,533.82 ** 4,030.00 Budgeted 2,496.18 Remaining 38 % Used Account: 122-50030-045-000 Social Security Taxes 834 02/13/2015 FD Payroll 02/13/15 10,320.67 1,171.19 11,491.86 GL 867 02/27/2015 FD Payroll 2/27/15 1,036.79 12,528.65 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,207.98 12,528.65 ** 33,421.00 Budgeted 20,892.35 Remaining 37 % Used Account: 122-50035-045-000 Medicare Taxes 834 02/13/2015 FD Payroll 02/13/15 2,413.07 273.84 2,686.91 GL 867 02/27/2015 FD Payroll 2/27/15 242.46 2,929.37 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 516.30 2,929.37 ** 7,292.00 Budgeted 4,362.63 Remaining 40 % Used Account: 122-50040-045-000 Unemployment Taxes 834 02/13/2015 FD Payroll 02/13/15 1,271.05 266.61 1,537.66 GL 867 02/27/2015 FD Payroll 2/27/15 70.30 1,607.96 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 336.91 1,607.96 ** 1,657.00 Budgeted 49.04 Remaining 97 % Used Account: 122-50045-045-000 Workman's Compensation 195 02/01/2015 Feb TML Ins & Workers Comp 2,636.00 658.99 3,294.99 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 658.99 3,294.99 ** 8,692.00 Budgeted 5,397.01 Remaining 38 % 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 845 02/19/2015 Feb A/P Ganns, Charter, Verizon 1,880.17 462.50 2,342.67 TOWN OF TROPHY CLUB 34676 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 2,342.67 ** 7,378.00 Budgeted 5,035.33 Remaining 32 % Used Account: 122-55045-045-000 Legal .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 845 02/19/2015 Feb A/P Ganns, Charter, Verizon 3,209.88 70.00 3,279.88 TOWN OF TROPHY CLUB 34676 AP 872 02/26/2015 Feb A/P Rug service 32.29 3,312.17 G & K SERVICES 34704 AP 872 02/26/2015 Feb A/P Rug service 32.29 3,344.46 G & K SERVICES 34704 AP 941 02/26/2015 1/27/15-2/26/15 PCards THE HOME DEPOT 6581 86.17 3,430.63 THE HOME DEPOT 6581 PC 941 02/26/2015 1/27/15-2/26/15 PCards SAMSCLUB #4795 34.74 3,465.37 SAMSCLUB #4795 PC 942 02/28/2015 Feb A/P Annual SCBA Inspection & Repai 811.20 4,276.57 MUNICIPAL EMERGENCY SERVICES 34718 AP 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (32.29) 4,244.28 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,034.40 4,244.28 ** 18,552.00 Budgeted 14,307.72 Remaining 23 % Used Account: 122-55090-045-000 Vehicle Maintenance 872 02/26/2015 Feb A/P Quint 681 Hydraulic Leak @ Ext 1,767.86 2,113.00 3,880.86 SIDDONS-MARTIN EMERGENCY GROUP 34724 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 2,113.00 3,880.86 ** 12,000.00 Budgeted 8,119.14 Remaining 32 % Used Account: 122-60005-045-000 Telephone 872 02/26/2015 Feb A/P BOA PCards 17.13 5.68 22.81 TOWN OF TROPHY CLUB 34732 AP _______________ Account: 122-60005-045-000 Telephone Totals: 5.68 22.81 ** 50.00 Budgeted 27.19 Remaining 46 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 834 02/13/2015 FD Payroll 02/13/15 2,879.44 37.50 2,916.94 GL 845 02/19/2015 Feb A/P Ganns, Charter, Verizon 140.15 3,057.09 TOWN OF TROPHY CLUB 34676 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 177.65 3,057.09 ** 5,000.00 Budgeted 1,942.91 Remaining 61 % Used Account: 122-60020-045-000 Electricity/Gas 872 02/26/2015 Feb A/P 1/21/15-2/17/15 Gas, Fire Stat 1,487.20 273.66 1,760.86 ATMOS ENERGY 34693 AP 942 02/28/2015 Feb A/P Electricity 1/12-2/11/15 730.15 2,491.01 HUDSON ENERGY SERVICES, LLC 34706 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: 1,487.20 (501.91) 1,989.10 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 501.90 1,989.10 ** 9,026.00 Budgeted 7,036.90 Remaining 22 % Used Account: 122-60025-045-000 Water 942 02/28/2015 Feb A/P February water 419.57 225.96 645.53 TROPHY CLUB MUD (WATER BILLS) 34733 AP 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (112.98) 532.55 AR _______________ Account: 122-60025-045-000 Water Totals: 112.98 532.55 ** 1,200.00 Budgeted 667.45 Remaining 44 % Used Account: 122-60026-045-000 Cable 941 02/26/2015 1/27/15-2/26/15 PCards ATT*BILL PAYMENT 615.04 128.59 743.63 ATT*BILL PAYMENT PC 941 02/26/2015 1/27/15-2/26/15 PCards ATT*BILL PAYMENT 158.51 902.14 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 287.10 902.14 ** 1,920.00 Budgeted 1,017.86 Remaining 47 % Used Account: 122-60030-045-000 Rent And/Or Usage 956 02/02/2015 FD Rent to I&S 211,829.00 211,829.00 GL _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: 211,829.00 211,829.00 ** 211,829.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 8.64 .00 8.64 _______________ Account: 122-60035-045-000 Postage Totals: .00 8.64 ** 100.00 Budgeted 91.36 Remaining 9 % Used Account: 122-60055-045-000 Insurance 195 02/01/2015 Feb TML Ins & Workers Comp 3,760.36 940.08 4,700.44 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.08 4,700.44 ** 12,179.00 Budgeted 7,478.56 Remaining 39 % Used Account: 122-60066-045-000 Publications/Books/Subscrips . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 219.05 .00 219.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 219.05 ** 200.00 Budgeted (19.05) Remaining 110 % Used Account: 122-60070-045-000 Dues & Memberships 15,452.85 .00 15,452.85 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 15,452.85 ** 15,180.00 Budgeted (272.85) Remaining 102 % Used Account: 122-60080-045-000 Schools & Training 1,181.00 .00 1,181.00 _______________ Account: 122-60080-045-000 Schools & Training Totals: .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 733 02/03/2015 Feb A/P Travel expenses/Pierce Mfg 1,445.32 1,455.60 2,900.92 SIDDONS-MARTIN EMERGENCY GROUP 34615 AP 941 02/26/2015 1/27/15-2/26/15 PCards RADISSON 606.06 3,506.98 RADISSON PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 2,061.66 3,506.98 ** 13,577.00 Budgeted 10,070.02 Remaining 26 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 124.15 .00 124.15 _______________ Account: 122-60125-045-000 Advertising Totals: .00 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 872 02/26/2015 Feb A/P Nevill, Symonds, Gexa 847.10 85.00 932.10 TOWN OF TROPHY CLUB 34732 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 85.00 932.10 ** 2,000.00 Budgeted 1,067.90 Remaining 47 % Used Account: 122-60245-045-000 Miscellaneous Expense 570.00 .00 570.00 _______________ 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 945 02/28/2015 Feb A/P Feb Fuel 2,159.52 270.00 2,429.52 US Bank Voyager Fleet Systems 34734 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 270.00 2,429.52 ** 10,454.00 Budgeted 8,024.48 Remaining 23 % Used Account: 122-65010-045-000 Uniforms 1,327.12 .00 1,327.12 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65010-045-000 Uniforms Totals: .00 1,327.12 ** 2,000.00 Budgeted 672.88 Remaining 66 % Used Account: 122-65015-045-000 Protective Clothing 405.00 .00 405.00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .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 46.61 .00 46.61 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 46.61 ** 2,500.00 Budgeted 2,453.39 Remaining 2 % Used Account: 122-65055-045-000 Hardware .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 19.52 .00 19.52 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 19.52 ** 500.00 Budgeted 480.48 Remaining 4 % Used Account: 122-65105-045-000 Printing 38.17 .00 38.17 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-65105-045-000 Printing Totals: .00 38.17 ** 548.00 Budgeted 509.83 Remaining 7 % Used Account: 122-69005-045-000 Capital Outlays 1,057,316.14 .00 1,057,316.14 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 1,057,316.14 ** .00 Budgeted (1,057,316.14) 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 _______________ 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-69255-045-000 Airpacks Totals: .00 .00 ** 10,400.00 Budgeted 10,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 1,632,691.40 ** 1,383,940.00 Budgeted (248,751.40) Remaining 118 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (520,467.91) .00 Budgeted 520,467.91 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET FEBRUARY 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 2/28/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 38,383 - - 38,383 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,506,641 - - 1,506,641 INVESTMENTS-TEXPOOL 1,588,345 169,600 21,605 1,779,550 PREPAID EXPENSES 47,137 - - 47,137 ADVALOREM PROPERTY TAXES RECEIVABLE 8,870 - - 8,870 UTILITY AND OTHER ACCOUNTS RECEIVABLE 514,749 - - 514,749 - TOTAL ASSETS 3,704,725 169,600 21,605 3,895,930 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 8,870 - - 8,870 ACCOUNTS AND OTHER PAYABLES 187,958 - 13,581 201,539 CUSTOMER DEPOSITS 300,927 - - 300,927 - TOTAL LIABILITIES 497,755 - 13,581 511,336 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,059,176 (91,097) (2,244) 965,835 - TOTAL FUND BALANCE 3,207,230 169,600 8,024 3,384,854 - TOTAL LIABILITIES AND FUND BALANCE 3,704,725 169,600 21,605 3,895,930 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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- 14,596.74- 161,858.22- 96.426 5,998.78- 135-40002-000-000 Property Taxes/Delinquent 52.51- 399.16- 399.16 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 133.12- 272.18- 30.242 627.82- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 11,570.00- 57,307.10- 42.767 76,689.90- Subtotal: 302,754.00- 302,754.00- 26,352.37- 219,836.66- 72.612 82,917.34- 135-47000-000-000 Water 5,286,045.00- 5,286,045.00- 196,521.04- 1,205,575.41- 22.807 4,080,469.59- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 143,596.42- 786,314.45- 34.624 1,484,667.55- 135-47025-000-000 Penalties 63,416.00- 63,416.00- 7,049.42- 41,219.12- 64.998 22,196.88- 135-47030-000-000 Service Charges 8,000.00- 8,000.00- 1,403.00- 5,040.00- 63.000 2,960.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 100.00- 1,300.00- 65.000 700.00- 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 300.00- 3,900.00- 78.000 1,100.00- 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 876.40- 13,955.20- 16.075 72,859.80- Subtotal: 7,722,258.00- 7,722,258.00- 349,846.28- 2,057,304.18- 26.641 5,664,953.82- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 18,400.00- 78,200.00- 42.500 105,800.00- Subtotal: 184,000.00- 184,000.00- 18,400.00- 78,200.00- 42.500 105,800.00- 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 508.57- 2,579.06- 51.581 2,420.94- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 4,552.65- 44.792 5,611.35- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,916.65- 41.666 4,083.35- 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- 7,518.26- 24,195.83- 28.805 59,804.17- 135-49145-000-000 Intergov Transfer-General Fund 1,074,337.15- 1,074,337.15 135-49900-000-000 Miscellaneous Income 54,000.00- 88,600.00- 16,077.66- 50,934.75- 57.488 37,665.25- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 12.20- 12.200 87.80- Subtotal: 235,321.00- 269,921.00- 25,598.35- 1,234,234.29- 457.258 964,313.29 Program number: 8,444,333.00- 8,478,933.00- 420,197.00- 3,589,575.13- 42.335 4,889,357.87- Department number: Revenues 8,444,333.00- 8,478,933.00- 420,197.00- 3,589,575.13- 42.335 4,889,357.87- Revenues Subtotal ----------- 8,444,333.00- 8,478,933.00- 420,197.00- 3,589,575.13- 42.335 4,889,357.87- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 16,548.94 74,924.69 24.884 226,176.31 135-50010-010-000 Overtime 19,500.00 19,500.00 838.78 5,013.94 25.713 14,486.06 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 1,150.00 23.958 3,650.00 135-50020-010-000 Retirement 29,349.00 29,349.00 1,569.29 7,497.38 25.546 21,851.62 135-50026-010-000 Medical Insurance 44,988.00 44,988.00 2,499.08 10,290.39 22.874 34,697.61 135-50027-010-000 Dental Insurance 3,288.00 3,288.00 196.48 819.26 24.917 2,468.74 135-50028-010-000 Vision Insurance 834.00 834.00 44.93 192.59 23.092 641.41 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 164.43 734.51 23.894 2,339.49 135-50030-010-000 Social Security Taxes 21,135.00 21,135.00 1,082.27 5,150.42 24.369 15,984.58 135-50035-010-000 Medicare Taxes 4,943.00 4,943.00 253.10 1,204.55 24.369 3,738.45 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 262.29 754.04 60.712 487.96 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 462.09- 2,969.55 18.537 13,050.45 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,000.00 586.85 58.685 413.15 135-50070-010-000 Employee Relations 300.00 300.00 22.86 22.86 7.620 277.14 Subtotal: 456,917.00 456,917.00 23,245.36 114,016.03 24.953 342,900.97 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 370.28 27,755.24 38.959 43,486.76 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 63.98 2,439.46 30.493 5,560.54 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 60.00 1,260.26 22.914 4,239.74 Subtotal: 98,242.00 98,242.00 494.26 31,697.96 32.265 66,544.04 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 206.94 1,506.91 30.672 3,406.09 135-60020-010-000 Electricity 170,765.00 170,765.00 8,533.24 45,099.08 26.410 125,665.92 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 435.00 485.00 11.721 3,653.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 100.00 21,024.06 42.667 28,250.94 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 113,140.46 576,164.95 19.676 2,352,143.05 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 63.46 881.71 25.192 2,618.29 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 122,479.10 645,161.71 20.357 2,524,087.29 135-65005-010-000 Fuel & Lube 29,172.00 29,172.00 765.23 5,094.36 17.463 24,077.64 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 753.67 1,360.14 37.573 2,259.86 135-65030-010-000 Chemicals 7,000.00 7,000.00 304.95 4,059.36 57.991 2,940.64 135-65035-010-000 Small Tools 1,200.00 1,200.00 68.37 68.37 5.698 1,131.63 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 135.26 277.01 27.701 722.99 135-65050-010-000 Meter Expense 161,500.00 161,500.00 4,933.84 17,748.84 10.990 143,751.16 Subtotal: 203,492.00 203,492.00 6,961.32 28,608.08 14.059 174,883.92 135-69005-010-000 Capital Outlays 1,089,006.00 1,177,566.00 33,315.89 125,361.45 10.646 1,052,204.55 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 118,774.42 78.395 32,732.58 Subtotal: 1,448,125.00 1,536,685.00 33,315.89 319,135.87 20.768 1,217,549.13 Program number: 5,376,025.00 5,464,585.00 186,495.93 1,138,619.65 20.836 4,325,965.35 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/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 2,017.63 40.353 2,982.37 Subtotal: 5,000.00 5,000.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 2,017.63 20.176 7,982.37 Department number: Water 5,386,025.00 5,474,585.00 186,495.93 1,140,637.28 20.835 4,333,947.72 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 23,189.72 118,445.57 38.740 187,298.43 135-50010-020-000 Overtime 19,500.00 19,500.00 2,387.11 11,731.01 60.159 7,768.99 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,750.00 41.667 3,850.00 135-50020-020-000 Retirement 29,948.00 29,948.00 2,327.90 12,396.06 41.392 17,551.94 135-50026-020-000 Medical Insurance 61,001.00 61,001.00 4,686.75 22,931.14 37.591 38,069.86 135-50027-020-000 Dental Insurance 4,146.00 4,146.00 299.51 1,466.96 35.383 2,679.04 135-50028-020-000 Vision Insurance 990.00 990.00 69.00 342.39 34.585 647.61 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 287.71 1,377.47 43.127 1,816.53 135-50030-020-000 Social Security Taxes 21,680.00 21,680.00 1,459.74 7,687.38 35.458 13,992.62 135-50035-020-000 Medicare Taxes 5,070.00 5,070.00 341.38 1,797.84 35.460 3,272.16 135-50040-020-000 Unemployment Taxes 1,242.00 1,242.00 332.70 1,208.78 97.325 33.22 135-50045-020-000 Workman's Compensation 16,020.00 16,020.00 462.09- 2,969.55 18.537 13,050.45 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 126.00 84.000 24.00 135-50070-020-000 Employee Relations 550.00 550.00 61.58 444.77 80.867 105.23 Subtotal: 481,452.00 481,452.00 35,531.01 191,289.92 39.732 290,162.08 135-55005-020-000 Engineering 38.24- 135-55080-020-000 Maintenance & Repairs 58,000.00 58,000.00 7,828.08 46,582.81 80.315 11,417.19 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 620.55 1,998.34 66.611 1,001.66 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 21.27 4.254 478.73 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 22,860.10 41.564 32,139.90 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 9,095.50 36.382 15,904.50 Subtotal: 141,500.00 141,500.00 8,410.39 80,558.02 56.931 60,941.98 135-60010-020-000 Communications/Pagers/Mobiles 4,662.00 4,662.00 216.43 1,979.58 42.462 2,682.42 135-60020-020-000 Electricity 149,292.00 149,292.00 611.75 41,324.40 27.680 107,967.60 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 351.00 1,147.00 28.216 2,918.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 242.85 443.90 27.744 1,156.10 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 1,422.03 54,048.73 28.785 133,720.27 135-65005-020-000 Fuel & Lube 36,328.00 36,328.00 1,077.26 8,798.40 24.219 27,529.60 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 4,507.65 15.026 25,492.35 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 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 1,077.26 21,936.31 25.851 62,919.69 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 46,440.69 428,774.98 30.616 971,737.02 Department number: Wastewater 1,462,117.00 1,400,512.00 46,440.69 428,774.98 30.616 971,737.02 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 1,200.00 5,800.00 58.000 4,200.00 135-50030-026-000 Social Security Taxes 620.00 620.00 74.40 359.60 58.000 260.40 135-50035-026-000 Medicare Taxes 145.00 145.00 17.40 84.10 58.000 60.90 135-50040-026-000 Unemployment Taxes 230.00 230.00 27.60 133.40 58.000 96.60 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 14.70 40.833 21.30 Subtotal: 11,031.00 11,031.00 1,322.34 6,391.80 57.944 4,639.20 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 51.37 176.24 14.687 1,023.76 135-60080-026-000 Schools & Training 4,000.00 4,000.00 505.00 1,480.00 37.000 2,520.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,329.96 26.599 3,670.04 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,574.74 1,624.74 162.474 624.74- Subtotal: 11,850.00 11,850.00 2,131.11 4,645.94 39.206 7,204.06 Program number: 22,881.00 22,881.00 3,453.45 11,037.74 48.240 11,843.26 Department number: Board of Directors 22,881.00 22,881.00 3,453.45 11,037.74 48.240 11,843.26 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 35,234.09 181,399.45 37.983 296,178.55 135-50010-030-000 Overtime 1,000.00 1,000.00 10.62 87.79 8.779 912.21 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 3,140.31 16,530.66 38.587 26,309.34 135-50026-030-000 Medical Insurance 65,015.00 65,015.00 4,915.06 23,130.14 35.577 41,884.86 135-50027-030-000 Dental Insurance 4,944.00 4,944.00 364.24 1,642.04 33.213 3,301.96 135-50028-030-000 Vision Insurance 1,158.00 1,158.00 84.38 388.21 33.524 769.79 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 368.28 1,778.07 41.036 2,554.93 135-50030-030-000 Social Security Taxes 30,079.00 30,079.00 2,061.94 10,870.20 36.139 19,208.80 135-50035-030-000 Medicare Taxes 7,422.00 7,422.00 482.24 2,542.20 34.252 4,879.80 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 213.02 1,444.22 99.670 4.78 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 436.50 26.681 1,199.50 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 40.00 2,261.64 45.233 2,738.36 Subtotal: 646,237.00 646,237.00 47,001.48 245,831.62 38.040 400,405.38 135-55030-030-000 Software & Support 75,588.00 87,423.00 3,265.14 71,671.40 81.982 15,751.60 135-55070-030-000 Independent Labor 8,000.00 32,550.00 26.25 9,045.00 27.788 23,505.00 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 385.63 3,061.01 47.092 3,438.99 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 627.53 2,510.12 30.989 5,589.88 135-55160-030-000 Professional Outside Services 58,000.00 58,000.00 147.00 41,174.95 70.991 16,825.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 2,419.80 29.510 5,780.20 Subtotal: 175,258.00 231,643.00 4,451.55 149,882.28 64.704 81,760.72 135-60005-030-000 Telephone 13,361.00 13,361.00 1,321.24 4,654.05 34.833 8,706.95 135-60010-030-000 Communications/Pagers/Mobiles 4,056.00 4,056.00 348.71 1,677.61 41.361 2,378.39 135-60020-030-000 Electricity/Gas 14,978.00 14,978.00 1,204.12 2,618.59 17.483 12,359.41 135-60025-030-000 Water 1,500.00 1,500.00 64.80 378.28 25.219 1,121.72 135-60035-030-000 Postage 28,500.00 28,500.00 154.10 9,748.90 34.207 18,751.10 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 3,799.89 17,768.62 55.527 14,231.38 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,113.01 20,398.30 41.842 28,352.70 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,072.77 1,223.77 122.377 223.77- 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 35.00 60.11 15.028 339.89 135-60079-030-000 Public Education 5,000.00 5,000.00 633.19 633.19 12.664 4,366.81 135-60080-030-000 Schools & Training 10,235.00 10,235.00 2,420.00 2,688.00 26.263 7,547.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 70.44 582.18 10.781 4,817.82 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 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 69.73 3,436.38 19.636 14,063.62 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 15,307.00 75,502.61 34.570 142,903.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 2,027.99 33,885.23 96.194 1,340.77 135-65085-030-000 Office Supplies 9,000.00 9,000.00 575.40 2,912.67 32.363 6,087.33 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 886.20 1,139.30 24.077 3,592.70 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 219.27 1,840.87 36.817 3,159.13 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 3,708.86 40,821.07 67.126 19,991.93 135-69005-030-000 Capital Outlays 125,000.00 67,000.00 61,726.66 92.129 5,273.34 135-69170-030-000 Copier Lease Installments 4,236.00 4,236.00 338.76 1,286.47 30.370 2,949.53 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 338.76 79,342.13 90.609 8,222.87 Program number: 1,287,019.00 1,244,664.00 70,807.65 591,379.71 47.513 653,284.29 Department number: Administration 1,287,019.00 1,244,664.00 70,807.65 591,379.71 47.513 653,284.29 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 17:59 03/06/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/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 83,340.90 335,077.25 111.692 35,077.25- 135-55055-039-000 Auditing 22,491.00 22,491.00 16,836.00 74.857 5,655.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 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 83,340.90 358,569.39 106.625 22,278.39- Program number: 286,291.00 336,291.00 83,340.90 358,569.39 106.625 22,278.39- Department number: Non Departmental 286,291.00 336,291.00 83,340.90 358,569.39 106.625 22,278.39- Expenditures Subtotal ----------- 8,444,333.00 8,478,933.00 390,538.62 2,530,399.10 29.843 5,948,533.90 Fund number: 135 MUD 1 General Fund 29,658.38- 1,059,176.03- 1,059,176.03 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 17:59 03/06/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 2/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 17:59 03/06/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 2/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 17:59 03/06/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 2/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 17:59 03/06/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 2/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income .84- 5.83- 5.83 Subtotal: .84- 5.83- 5.83 Program number: .84- 5.83- 5.83 Department number: .84- 5.83- 5.83 Revenues Subtotal ----------- .84- 5.83- 5.83 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 17:59 03/06/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 2/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 150.00 2,250.00 67.204 1,098.00 Subtotal: 3,348.00 3,348.00 150.00 2,250.00 67.204 1,098.00 Program number: 3 Indian Creek Waterline 3,348.00 3,348.00 150.00 2,250.00 67.204 1,098.00 Department number: Water 3,348.00 3,348.00 150.00 2,250.00 67.204 1,098.00 Expenditures Subtotal ----------- 3,348.00 3,348.00 150.00 2,250.00 67.204 1,098.00 Fund number: 507 MUD 1 Capital Projects 3,348.00 3,348.00 149.16 2,244.17 67.030 1,103.83 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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 910 02/02/2015 Property Taxes/Assessments (147,261.48) (2,796.00) (150,057.48) GL 909 02/03/2015 Property Taxes/Assessments (809.47) (150,866.95) GL 911 02/04/2015 Property Taxes/Assessments (2,206.50) (153,073.45) GL 912 02/05/2015 Property Taxes/Assessments (1,035.65) (154,109.10) GL 913 02/06/2015 Property Taxes/Assessments (5,810.72) (159,919.82) GL 914 02/09/2015 Property Taxes/Assessments (941.75) (160,861.57) GL 915 02/10/2015 Property Taxes/Assessments (236.46) (161,098.03) GL 916 02/11/2015 Property Taxes/Assessments (34.11) (161,132.14) GL 917 02/12/2015 Property Taxes/Assessments (24.00) (161,156.14) GL 918 02/13/2015 Property Taxes/Assessments (193.38) (161,349.52) GL 919 02/17/2015 Property Taxes/Assessments (210.63) (161,560.15) GL 908 02/18/2015 Property Taxes/Assessments (65.28) (161,625.43) GL 907 02/19/2015 Property Taxes/Assessments (57.81) (161,683.24) GL 906 02/20/2015 Property Taxes/Assessments (77.89) (161,761.13) GL 905 02/25/2015 Property Taxes/Assessments (65.20) (161,826.33) GL 904 02/26/2015 Property Taxes/Assessments (31.89) (161,858.22) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (14,596.74) (161,858.22) ** (167,857.00) Budgeted (5,998.78) Remaining 96 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 910 02/02/2015 Property Taxes/Assessments (346.65) (3.15) (349.80) GL 909 02/03/2015 Property Taxes/Assessments (1.09) (350.89) GL 913 02/06/2015 Property Taxes/Assessments (86.33) (437.22) GL 908 02/18/2015 Property Taxes/Assessments 38.06 (399.16) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (52.51) (399.16) ** .00 Budgeted 399.16 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 910 02/02/2015 Property Taxes/Assessments (139.06) (.76) (139.82) GL 909 02/03/2015 Property Taxes/Assessments (.26) (140.08) GL 912 02/05/2015 Property Taxes/Assessments (.50) (140.58) GL 913 02/06/2015 Property Taxes/Assessments (43.34) (183.92) GL 914 02/09/2015 Property Taxes/Assessments (33.99) (217.91) GL 916 02/11/2015 Property Taxes/Assessments (2.39) (220.30) GL 917 02/12/2015 Property Taxes/Assessments (2.70) (223.00) GL 918 02/13/2015 Property Taxes/Assessments (13.54) (236.54) GL 919 02/17/2015 Property Taxes/Assessments (14.75) (251.29) GL 908 02/18/2015 Property Taxes/Assessments (4.58) (255.87) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 907 02/19/2015 Property Taxes/Assessments (139.06) (4.05) (259.92) GL 906 02/20/2015 Property Taxes/Assessments (5.46) (265.38) GL 905 02/25/2015 Property Taxes/Assessments (4.56) (269.94) GL 904 02/26/2015 Property Taxes/Assessments (2.24) (272.18) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (133.12) (272.18) ** (900.00) Budgeted (627.82) Remaining 30 % Used Account: 135-40025-000-000 PID Surcharges 902 02/28/2015 UB 2/28/15 Billing UB20150228-20150228 User: (45,737.10) (11,570.00) (57,307.10) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (11,570.00) (57,307.10) ** (133,997.00) Budgeted (76,689.90) Remaining 43 % Used Account: 135-47000-000-000 Water 924 02/10/2015 UB 2/10/15 misread adj UB20150210-20150210 User: (1,009,054.37) 76.22 (1,008,978.15) UB 928 02/13/2015 UB 2/13/15 Adj billing error UB20150213-20150213 User: 12.71 (1,008,965.44) UB 902 02/28/2015 UB 2/28/15 Billing UB20150228-20150228 User: (196,609.97) (1,205,575.41) UB _______________ Account: 135-47000-000-000 Water Totals: (196,521.04) (1,205,575.41) ** (5,286,045.00) Budgeted (4,080,469.59) Remaining 23 % Used Account: 135-47005-000-000 Sewer 924 02/10/2015 UB 2/10/15 misread adj UB20150210-20150210 User: (642,718.03) 45.00 (642,673.03) UB 928 02/13/2015 UB 2/13/15 Adj billing error UB20150213-20150213 User: 14.58 (642,658.45) UB 902 02/28/2015 UB 2/28/15 Billing UB20150228-20150228 User: (143,656.00) (786,314.45) UB _______________ Account: 135-47005-000-000 Sewer Totals: (143,596.42) (786,314.45) ** (2,270,982.00) Budgeted (1,484,667.55) Remaining 35 % Used Account: 135-47025-000-000 Penalties 928 02/13/2015 UB 2/13/15 Adj billing error UB20150213-20150213 User: (34,169.70) 24.62 (34,145.08) UB 861 02/24/2015 UB 2/24/15 Penalties UB20150224-20150224 User: (7,176.36) (41,321.44) UB 935 02/27/2015 UB 2/27/15 Adj-penalties UB20150227-20150227 User: 102.32 (41,219.12) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,049.42) (41,219.12) ** (63,416.00) Budgeted (22,196.88) Remaining 65 % Used Account: 135-47030-000-000 Service Charges . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 747 02/05/2015 UB 2/5/15 Cut Off list Fees UB20150205-20150205 User: (3,637.00) (875.00) (4,512.00) UB 922 02/06/2015 UB 2/6/15 After Hours Fee UB20150206-20150206 User: (400.00) (4,912.00) UB 931 02/19/2015 UB 2/19/15 NSF Check UB20150219-20150219 User: (25.00) (4,937.00) UB 932 02/22/2015 UB 2/22/15-adj after hours fee UB20150222-20150222 User: (100.00) (5,037.00) UB 934 02/26/2015 UB 2/26/15 NSF Check UB20150226-20150226 User: (25.00) (5,062.00) UB 935 02/27/2015 UB 2/27/15 Adj-penalties UB20150227-20150227 User: 25.00 (5,037.00) UB 902 02/28/2015 UB 2/28/15 Billing UB20150228-20150228 User: (3.00) (5,040.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,403.00) (5,040.00) ** (8,000.00) Budgeted (2,960.00) Remaining 63 % Used Account: 135-47035-000-000 Plumbing Inspections 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (1,200.00) (100.00) (1,300.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,300.00) ** (2,000.00) Budgeted (700.00) Remaining 65 % Used Account: 135-47045-000-000 Sewer Inspections 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (3,600.00) (300.00) (3,900.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (3,900.00) ** (5,000.00) Budgeted (1,100.00) Remaining 78 % Used Account: 135-47070-000-000 TCCC Effluent Charges 902 02/28/2015 UB 2/28/15 Billing UB20150228-20150228 User: (13,078.80) (876.40) (13,955.20) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (876.40) (13,955.20) ** (86,815.00) Budgeted (72,859.80) Remaining 16 % Used Account: 135-48005-000-000 Utility Fees 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (59,800.00) (18,400.00) (78,200.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (18,400.00) (78,200.00) ** (184,000.00) Budgeted (105,800.00) Remaining 43 % Used Account: 135-49010-000-000 Interest Income 890 02/28/2015 Bank Interest/February (2,070.49) (44.57) (2,115.06) GL 890 02/28/2015 Bank Interest/February (94.24) (2,209.30) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 890 02/28/2015 Bank Interest/February (2,070.49) (369.76) (2,579.06) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (508.57) (2,579.06) ** (5,000.00) Budgeted (2,420.94) Remaining 52 % Used Account: 135-49016-000-000 Cell Tower Revenue 878 02/05/2015 AT&T Cell Tower Revenue (3,642.12) (910.53) (4,552.65) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (4,552.65) ** (10,164.00) Budgeted (5,611.35) Remaining 45 % Used Account: 135-49018-000-000 Building Rent Income 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (2,333.32) (583.33) (2,916.65) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,916.65) ** (7,000.00) Budgeted (4,083.35) Remaining 42 % 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 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (16,677.57) (7,518.26) (24,195.83) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (7,518.26) (24,195.83) ** (84,000.00) Budgeted (59,804.17) Remaining 29 % Used Account: 135-49145-000-000 Intergov Transfer-General Fund (1,074,337.15) .00 (1,074,337.15) . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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: .00 (1,074,337.15) ** .00 Budgeted 1,074,337.15 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 879 02/11/2015 SW Securities-Waterfest donati (34,857.09) (1,000.00) (35,857.09) GL 880 02/12/2015 Wallace Grp-Waterfest donation (250.00) (36,107.09) GL 929 02/17/2015 UB 2/17/15 adj-cc chargeback UB20150217-20150217 User: (131.10) (36,238.19) UB 948 02/17/2015 Recode JE929/cc chargeback 131.10 (36,107.09) GL 881 02/20/2015 TML-Damage to Crane truck (11,946.58) (48,053.67) GL 883 02/25/2015 Progressive-2006 Dakota damage (2,857.38) (50,911.05) GL 902 02/28/2015 UB 2/28/15 Billing UB20150228-20150228 User: (23.70) (50,934.75) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (16,077.66) (50,934.75) ** (88,600.00) Budgeted (37,665.25) Remaining 57 % 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,589,575.13) ** (8,478,933.00) Budgeted (4,889,357.87) Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 799 02/13/2015 MUD Payroll 2/13/15 Salaries & Wages 58,375.75 7,954.47 66,330.22 PR 862 02/27/2015 MUD Payroll 2/27/15 Salaries & Wages 8,594.47 74,924.69 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,548.94 74,924.69 ** 301,101.00 Budgeted 226,176.31 Remaining 25 % Used Account: 135-50010-010-000 Overtime 799 02/13/2015 MUD Payroll 2/13/15 Overtime 4,175.16 461.78 4,636.94 PR 862 02/27/2015 MUD Payroll 2/27/15 Overtime 377.00 5,013.94 PR _______________ Account: 135-50010-010-000 Overtime Totals: 838.78 5,013.94 ** 19,500.00 Budgeted 14,486.06 Remaining 26 % 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 862 02/27/2015 MUD Payroll 2/27/15 Certification 925.00 225.00 1,150.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 1,150.00 ** 4,800.00 Budgeted 3,650.00 Remaining 24 % Used Account: 135-50020-010-000 Retirement 799 02/13/2015 MUD Payroll 2/13/15 Retirement 5,928.09 749.89 6,677.98 PR 862 02/27/2015 MUD Payroll 2/27/15 Retirement 819.40 7,497.38 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,569.29 7,497.38 ** 29,349.00 Budgeted 21,851.62 Remaining 26 % Used Account: 135-50026-010-000 Medical Insurance 799 02/13/2015 MUD Payroll 2/13/15 Medical Insurance 7,791.31 1,249.56 9,040.87 PR 862 02/27/2015 MUD Payroll 2/27/15 Medical Insurance 1,249.52 10,290.39 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,499.08 10,290.39 ** 44,988.00 Budgeted 34,697.61 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-50027-010-000 Dental Insurance 799 02/13/2015 MUD Payroll 2/13/15 Dental Insurance 622.78 98.24 721.02 PR 862 02/27/2015 MUD Payroll 2/27/15 Dental Insurance 98.24 819.26 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 196.48 819.26 ** 3,288.00 Budgeted 2,468.74 Remaining 25 % Used Account: 135-50028-010-000 Vision Insurance 799 02/13/2015 MUD Payroll 2/13/15 Vision Insurance 147.66 22.45 170.11 PR 862 02/27/2015 MUD Payroll 2/27/15 Vision Insurance 22.48 192.59 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 44.93 192.59 ** 834.00 Budgeted 641.41 Remaining 23 % Used Account: 135-50029-010-000 Life Insurance & Other 697 02/01/2015 Feb A/P Dental, LTD, STD, Life/Feb 570.08 157.15 727.23 METLIFE GROUP BENEFITS 34607 AP 845 02/19/2015 Feb A/P Admin Fee 7.28 734.51 BenefitMall 34666 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 164.43 734.51 ** 3,074.00 Budgeted 2,339.49 Remaining 24 % Used Account: 135-50030-010-000 Social Security Taxes 799 02/13/2015 MUD Payroll 2/13/15 Social Security Taxes 4,068.15 517.68 4,585.83 PR 862 02/27/2015 MUD Payroll 2/27/15 Social Security Taxes 564.59 5,150.42 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,082.27 5,150.42 ** 21,135.00 Budgeted 15,984.58 Remaining 24 % Used Account: 135-50035-010-000 Medicare Taxes 799 02/13/2015 MUD Payroll 2/13/15 Medicare Taxes 951.45 121.04 1,072.49 PR 862 02/27/2015 MUD Payroll 2/27/15 Medicare Taxes 132.06 1,204.55 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 253.10 1,204.55 ** 4,943.00 Budgeted 3,738.45 Remaining 24 % Used Account: 135-50040-010-000 Unemployment Taxes 799 02/13/2015 MUD Payroll 2/13/15 Unemployment Taxes 491.75 152.88 644.63 PR 882 02/25/2015 TML W/C Audit refund FY14 (1,320.00) (675.37) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 862 02/27/2015 MUD Payroll 2/27/15 Unemployment Taxes 491.75 109.41 (565.96) PR 964 02/28/2015 Correct coding on TML WC refnd 1,320.00 754.04 GL _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 262.29 754.04 ** 1,242.00 Budgeted 487.96 Remaining 61 % Used Account: 135-50045-010-000 Workman's Compensation 195 02/01/2015 Feb TML Ins & Workers Comp 3,431.64 857.91 4,289.55 GL 964 02/28/2015 Correct coding on TML WC refnd (1,320.00) 2,969.55 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: (462.09) 2,969.55 ** 16,020.00 Budgeted 13,050.45 Remaining 19 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 586.85 .00 586.85 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 586.85 ** 1,000.00 Budgeted 413.15 Remaining 59 % Used Account: 135-50070-010-000 Employee Relations 941 02/26/2015 1/27/15-2/26/15 PCards WHATABURGER 754 Q26 22.86 22.86 WHATABURGER 754 Q26 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 22.86 22.86 ** 300.00 Budgeted 277.14 Remaining 8 % 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 941 02/26/2015 1/27/15-2/26/15 PCards TRACTOR SUPPLY COMPANY 27,384.96 134.99 27,519.95 TRACTOR SUPPLY COMPANY PC 941 02/26/2015 1/27/15-2/26/15 PCards THE HOME DEPOT 6581 62.35 27,582.30 THE HOME DEPOT 6581 PC 945 02/28/2015 Feb A/P Credit/wrong parts (ball curb) (218.16) 27,364.14 HD SUPPLY WATERWORKS, LTD. 34705 AP 945 02/28/2015 Feb A/P Tee and gaskets 171.25 27,535.39 HD SUPPLY WATERWORKS, LTD. 34705 AP 945 02/28/2015 Feb A/P Flushing elbow, chlorine test 219.85 27,755.24 HD SUPPLY WATERWORKS, LTD. 34705 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 370.28 27,755.24 ** 71,242.00 Budgeted 43,486.76 Remaining 39 % Used Account: 135-55090-010-000 Vehicle Maintenance 942 02/28/2015 Feb A/P Motor oil 2,375.48 63.98 2,439.46 NAPA AUTO PARTS 34719 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 63.98 2,439.46 ** 8,000.00 Budgeted 5,560.54 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 872 02/26/2015 Feb A/P Balance due 1,200.26 60.00 1,260.26 TARRANT CTY PUBLIC HEALTH LAB 34730 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 60.00 1,260.26 ** 5,500.00 Budgeted 4,239.74 Remaining 23 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 845 02/19/2015 Feb A/P Cell phones 1,299.97 206.94 1,506.91 VERIZON WIRELESS 34677 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 206.94 1,506.91 ** 4,913.00 Budgeted 3,406.09 Remaining 31 % Used Account: 135-60020-010-000 Electricity 942 02/28/2015 Feb A/P Electricity 1/12-2/11 36,565.84 5,737.73 42,303.57 HUDSON ENERGY SERVICES, LLC 34706 AP 942 02/28/2015 Feb A/P Electricity 1/12-2/11/15 2,795.51 45,099.08 HUDSON ENERGY SERVICES, LLC 34706 AP _______________ Account: 135-60020-010-000 Electricity Totals: 8,533.24 45,099.08 ** 170,765.00 Budgeted 125,665.92 Remaining 26 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60066-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 941 02/26/2015 1/27/15-2/26/15 PCards SUNCOAST LEARNING SYST 50.00 235.00 285.00 SUNCOAST LEARNING SYST PC 941 02/26/2015 1/27/15-2/26/15 PCards METROPLEX TRAINING CEN 200.00 485.00 METROPLEX TRAINING CEN PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 435.00 485.00 ** 4,138.00 Budgeted 3,653.00 Remaining 12 % 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 _______________ 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 872 02/26/2015 Feb A/P Tier Two/2 facilities 20,924.06 100.00 21,024.06 TIER TWO CHEMICAL REPORTING 34689 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-60135-010-000 TCEQ Fees & Permits Totals: 100.00 21,024.06 ** 49,275.00 Budgeted 28,250.94 Remaining 43 % Used Account: 135-60150-010-000 Wholesale Water 872 02/26/2015 Feb A/P January Wholesale Water 463,024.49 113,140.46 576,164.95 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 113,140.46 576,164.95 ** 2,928,308.00 Budgeted 2,352,143.05 Remaining 20 % 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 941 02/26/2015 1/27/15-2/26/15 PCards OK SOD INC 818.25 21.51 839.76 OK SOD INC PC 941 02/26/2015 1/27/15-2/26/15 PCards THE HOME DEPOT 6581 39.00 878.76 THE HOME DEPOT 6581 PC 941 02/26/2015 1/27/15-2/26/15 PCards WAL-MART #5247 2.95 881.71 WAL-MART #5247 PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 63.46 881.71 ** 3,500.00 Budgeted 2,618.29 Remaining 25 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 945 02/28/2015 Feb A/P Feb Fuel 4,329.13 765.23 5,094.36 US Bank Voyager Fleet Systems 34734 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 765.23 5,094.36 ** 29,172.00 Budgeted 24,077.64 Remaining 17 % Used Account: 135-65010-010-000 Uniforms 941 02/26/2015 1/27/15-2/26/15 PCards TRACTOR SUPPLY COMPANY 606.47 628.72 1,235.19 TRACTOR SUPPLY COMPANY PC 941 02/26/2015 1/27/15-2/26/15 PCards TRACTOR SUPPLY COMPANY 74.97 1,310.16 TRACTOR SUPPLY COMPANY PC 941 02/26/2015 1/27/15-2/26/15 PCards TRACTOR SUPPLY COMPANY 49.98 1,360.14 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-010-000 Uniforms Totals: 753.67 1,360.14 ** 3,620.00 Budgeted 2,259.86 Remaining 38 % Used Account: 135-65030-010-000 Chemicals 872 02/26/2015 Feb A/P Chlorine 3,754.41 304.95 4,059.36 DPC INDUSTRIES, INC 34700 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 304.95 4,059.36 ** 7,000.00 Budgeted 2,940.64 Remaining 58 % Used Account: 135-65035-010-000 Small Tools 941 02/26/2015 1/27/15-2/26/15 PCards THE HOME DEPOT 6581 68.37 68.37 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-010-000 Small Tools Totals: 68.37 68.37 ** 1,200.00 Budgeted 1,131.63 Remaining 6 % Used Account: 135-65040-010-000 Safety Equipment 941 02/26/2015 1/27/15-2/26/15 PCards TX AMERICA SAFETY 141.75 135.26 277.01 TX AMERICA SAFETY PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 135.26 277.01 ** 1,000.00 Budgeted 722.99 Remaining 28 % Used Account: 135-65050-010-000 Meter Expense 872 02/26/2015 Feb A/P 1 Fire hydrant meter, adapter, 12,815.00 845.58 13,660.58 ATLAS UTILITY SUPPLY CO. 34692 AP 872 02/26/2015 Feb A/P Meter for Homewood Suites 4,088.26 17,748.84 ATLAS UTILITY SUPPLY CO. 34692 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 4,933.84 17,748.84 ** 161,500.00 Budgeted 143,751.16 Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-010-000 Capital Outlays 741 02/03/2015 Feb A/P 2015 Custom Ford F3B Reg Cab C 92,045.56 6,912.00 98,957.56 Fortress Resources, LLC 34624 AP 809 02/12/2015 Feb A/P Decals-2015 F350 95.00 99,052.56 M-KAM LTD. 34647 AP 809 02/12/2015 Feb A/P Drain at TWKing Elevated Tank 25,773.89 124,826.45 REY-MAR CONSTRUCTION 34654 AP 941 02/26/2015 1/27/15-2/26/15 PCards RHINO LININGS OF NW TA 535.00 125,361.45 RHINO LININGS OF NW TA PC _______________ Account: 135-69005-010-000 Capital Outlays Totals: 33,315.89 125,361.45 ** 1,177,566.00 Budgeted 1,052,204.55 Remaining 11 % 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 118,774.42 .00 118,774.42 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 118,774.42 ** 151,507.00 Budgeted 32,732.58 Remaining 78 % Used Account: 135-55135-010-001 Lab Analysis for PID 2,017.63 .00 2,017.63 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 2,017.63 ** 5,000.00 Budgeted 2,982.37 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/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-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: ------------------------------------------------------------------------------------------------ 1,140,637.28 ** 5,474,585.00 Budgeted 4,333,947.72 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 799 02/13/2015 MUD Payroll 2/13/15 Salaries & Wages 95,255.85 11,594.95 106,850.80 PR 862 02/27/2015 MUD Payroll 2/27/15 Salaries & Wages 11,594.77 118,445.57 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 23,189.72 118,445.57 ** 305,744.00 Budgeted 187,298.43 Remaining 39 % Used Account: 135-50010-020-000 Overtime 799 02/13/2015 MUD Payroll 2/13/15 Overtime 9,343.90 1,478.23 10,822.13 PR 862 02/27/2015 MUD Payroll 2/27/15 Overtime 908.88 11,731.01 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,387.11 11,731.01 ** 19,500.00 Budgeted 7,768.99 Remaining 60 % 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 862 02/27/2015 MUD Payroll 2/27/15 Certification 2,200.00 550.00 2,750.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 2,750.00 ** 6,600.00 Budgeted 3,850.00 Remaining 42 % Used Account: 135-50020-020-000 Retirement 799 02/13/2015 MUD Payroll 2/13/15 Retirement 10,068.16 1,164.82 11,232.98 PR 862 02/27/2015 MUD Payroll 2/27/15 Retirement 1,163.08 12,396.06 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,327.90 12,396.06 ** 29,948.00 Budgeted 17,551.94 Remaining 41 % Used Account: 135-50026-020-000 Medical Insurance 799 02/13/2015 MUD Payroll 2/13/15 Medical Insurance 18,244.39 2,343.40 20,587.79 PR 862 02/27/2015 MUD Payroll 2/27/15 Medical Insurance 2,343.35 22,931.14 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,686.75 22,931.14 ** 61,001.00 Budgeted 38,069.86 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-50027-020-000 Dental Insurance 799 02/13/2015 MUD Payroll 2/13/15 Dental Insurance 1,167.45 149.75 1,317.20 PR 862 02/27/2015 MUD Payroll 2/27/15 Dental Insurance 149.76 1,466.96 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 299.51 1,466.96 ** 4,146.00 Budgeted 2,679.04 Remaining 35 % Used Account: 135-50028-020-000 Vision Insurance 799 02/13/2015 MUD Payroll 2/13/15 Vision Insurance 273.39 34.48 307.87 PR 862 02/27/2015 MUD Payroll 2/27/15 Vision Insurance 34.52 342.39 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 69.00 342.39 ** 990.00 Budgeted 647.61 Remaining 35 % Used Account: 135-50029-020-000 Life Insurance & Other 697 02/01/2015 Feb A/P Dental, LTD, STD, Life/Feb 1,089.76 251.35 1,341.11 METLIFE GROUP BENEFITS 34607 AP 845 02/19/2015 Feb A/P Admin Fee 36.36 1,377.47 BenefitMall 34666 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 287.71 1,377.47 ** 3,194.00 Budgeted 1,816.53 Remaining 43 % Used Account: 135-50030-020-000 Social Security Taxes 799 02/13/2015 MUD Payroll 2/13/15 Social Security Taxes 6,227.64 739.28 6,966.92 PR 862 02/27/2015 MUD Payroll 2/27/15 Social Security Taxes 720.46 7,687.38 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,459.74 7,687.38 ** 21,680.00 Budgeted 13,992.62 Remaining 35 % Used Account: 135-50035-020-000 Medicare Taxes 799 02/13/2015 MUD Payroll 2/13/15 Medicare Taxes 1,456.46 172.89 1,629.35 PR 862 02/27/2015 MUD Payroll 2/27/15 Medicare Taxes 168.49 1,797.84 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 341.38 1,797.84 ** 5,070.00 Budgeted 3,272.16 Remaining 35 % Used Account: 135-50040-020-000 Unemployment Taxes 799 02/13/2015 MUD Payroll 2/13/15 Unemployment Taxes 876.08 242.82 1,118.90 PR 882 02/25/2015 TML W/C Audit refund FY14 (1,320.00) (201.10) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 862 02/27/2015 MUD Payroll 2/27/15 Unemployment Taxes 876.08 89.88 (111.22) PR 964 02/28/2015 Correct coding on TML WC refnd 1,320.00 1,208.78 GL _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 332.70 1,208.78 ** 1,242.00 Budgeted 33.22 Remaining 97 % Used Account: 135-50045-020-000 Workman's Compensation 195 02/01/2015 Feb TML Ins & Workers Comp 3,431.64 857.91 4,289.55 GL 958 02/28/2015 Correct coding/TML W/C Refund (1,320.00) 2,969.55 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: (462.09) 2,969.55 ** 16,020.00 Budgeted 13,050.45 Remaining 19 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 126.00 .00 126.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 126.00 ** 150.00 Budgeted 24.00 Remaining 84 % Used Account: 135-50070-020-000 Employee Relations 941 02/26/2015 1/27/15-2/26/15 PCards WHATABURGER 754 Q26 383.19 22.86 406.05 WHATABURGER 754 Q26 PC 941 02/26/2015 1/27/15-2/26/15 PCards SALAD BOWL 10 38.72 444.77 SALAD BOWL 10 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 61.58 444.77 ** 550.00 Budgeted 105.23 Remaining 81 % Used Account: 135-55005-020-000 Engineering 836 02/18/2015 Correct coding/Pcards DeWayne Fuel coded to engineer 38.24 (38.24) .00 GL _______________ Account: 135-55005-020-000 Engineering Totals: (38.24) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 845 02/19/2015 Feb A/P Repair Chain 38,754.73 1,056.00 39,810.73 Landers Machine Company 34668 AP 872 02/26/2015 Feb A/P 552 Indian Creek-Sewer 3,426.70 43,237.43 REY-MAR CONSTRUCTION 34687 AP 941 02/26/2015 1/27/15-2/26/15 PCards AUTOZONE #4206 10.99 43,248.42 AUTOZONE #4206 PC 941 02/26/2015 1/27/15-2/26/15 PCards THE HOME DEPOT 6581 24.98 43,273.40 THE HOME DEPOT 6581 PC 941 02/26/2015 1/27/15-2/26/15 PCards THE HOME DEPOT 6581 58.51 43,331.91 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 941 02/26/2015 1/27/15-2/26/15 PCards JOHN DEERE LANDSCAPES2 38,754.73 190.00 43,521.91 JOHN DEERE LANDSCAPES2 PC 941 02/26/2015 1/27/15-2/26/15 PCards AUTOZONE #3137 8.99 43,530.90 AUTOZONE #3137 PC 941 02/26/2015 1/27/15-2/26/15 PCards AUTOZONE #4206 41.99 43,572.89 AUTOZONE #4206 PC 941 02/26/2015 1/27/15-2/26/15 PCards THE HOME DEPOT 6581 265.76 43,838.65 THE HOME DEPOT 6581 PC 941 02/26/2015 1/27/15-2/26/15 PCards FERGUSON ENT #788 1,899.88 45,738.53 FERGUSON ENT #788 PC 941 02/26/2015 1/27/15-2/26/15 PCards FERGUSON ENT #788 308.42 46,046.95 FERGUSON ENT #788 PC 941 02/26/2015 1/27/15-2/26/15 PCards OK SOD INC 12.00 46,058.95 OK SOD INC PC 941 02/26/2015 1/27/15-2/26/15 PCards IN *HOSE TECH 523.86 46,582.81 IN *HOSE TECH PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,828.08 46,582.81 ** 58,000.00 Budgeted 11,417.19 Remaining 80 % Used Account: 135-55090-020-000 Vehicle Maintenance 941 02/26/2015 1/27/15-2/26/15 PCards CLASSIC CHEVROLET LTD 1,377.79 620.55 1,998.34 CLASSIC CHEVROLET LTD PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 620.55 1,998.34 ** 3,000.00 Budgeted 1,001.66 Remaining 67 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 21.27 .00 21.27 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 21.27 ** 500.00 Budgeted 478.73 Remaining 4 % Used Account: 135-55125-020-000 Dumpster Services 22,860.10 .00 22,860.10 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 22,860.10 ** 55,000.00 Budgeted 32,139.90 Remaining 42 % Used Account: 135-55135-020-000 Lab Analysis 9,095.50 .00 9,095.50 _______________ Account: 135-55135-020-000 Lab Analysis Totals: .00 9,095.50 ** 25,000.00 Budgeted 15,904.50 Remaining 36 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 836 02/18/2015 Correct coding/Pcards Karl's travel coded to phone 1,763.15 (226.20) 1,536.95 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 845 02/19/2015 Feb A/P Cell phones 1,763.15 362.66 1,899.61 VERIZON WIRELESS 34677 AP 941 02/26/2015 1/27/15-2/26/15 PCards BEST BUY 00001487 79.97 1,979.58 BEST BUY 00001487 PC _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 216.43 1,979.58 ** 4,662.00 Budgeted 2,682.42 Remaining 42 % Used Account: 135-60020-020-000 Electricity 809 02/12/2015 Feb A/P Electricity 12/31-1/2915 40,712.65 244.52 40,957.17 TRI COUNTY ELECTRIC 34663 AP 809 02/12/2015 Feb A/P Electricity 12/31-1/29/15 122.53 41,079.70 TRI COUNTY ELECTRIC 34663 AP 809 02/12/2015 Feb A/P Electricity 12/31-1/29/15 27.78 41,107.48 TRI COUNTY ELECTRIC 34663 AP 845 02/19/2015 Feb A/P Electricity 1/9/15-2/10/15 69.51 41,176.99 HUDSON ENERGY SERVICES, LLC 34667 AP 845 02/19/2015 Feb A/P Electricity 1/9/15-2/10/15 46.47 41,223.46 HUDSON ENERGY SERVICES, LLC 34667 AP 872 02/26/2015 Feb A/P Electricity 1/12-2/11/15 100.94 41,324.40 HUDSON ENERGY SERVICES, LLC 34706 AP 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (260.18) 41,064.22 AR 962 02/28/2015 Feb A/P Electricity 1/12-2/11/15 260.18 41,324.40 HUDSON ENERGY SERVICES, LLC AP _______________ Account: 135-60020-020-000 Electricity Totals: 611.75 41,324.40 ** 149,292.00 Budgeted 107,967.60 Remaining 28 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 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 941 02/26/2015 1/27/15-2/26/15 PCards TCEQ IND RENEWAL L 796.00 111.00 907.00 TCEQ IND RENEWAL L PC 941 02/26/2015 1/27/15-2/26/15 PCards NCTCOG RTC TRAINING 240.00 1,147.00 NCTCOG RTC TRAINING PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 351.00 1,147.00 ** 4,065.00 Budgeted 2,918.00 Remaining 28 % Used Account: 135-60090-020-000 Safety Program . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-60090-020-000 Safety Program Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 836 02/18/2015 Correct coding/Pcards Karl's travel coded to phone 201.05 226.20 427.25 GL 845 02/19/2015 Feb A/P Toll 16.65 443.90 Texas Tollways/TxTag 34675 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 242.85 443.90 ** 1,600.00 Budgeted 1,156.10 Remaining 28 % 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 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 836 02/18/2015 Correct coding/Pcards DeWayne Fuel coded to engineer 7,721.14 38.24 7,759.38 GL 941 02/26/2015 1/27/15-2/26/15 PCards 7-ELEVEN 32921 23.05 7,782.43 7-ELEVEN 32921 PC 945 02/28/2015 Feb A/P Feb Fuel 1,015.97 8,798.40 US Bank Voyager Fleet Systems 34734 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,077.26 8,798.40 ** 36,328.00 Budgeted 27,529.60 Remaining 24 % 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 4,507.65 .00 4,507.65 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 4,507.65 ** 30,000.00 Budgeted 25,492.35 Remaining 15 % Used Account: 135-65035-020-000 Small Tools 502.25 .00 502.25 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 .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: ------------------------------------------------------------------------------------------------ 428,774.98 ** 1,400,512.00 Budgeted 971,737.02 Remaining 31 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 799 02/13/2015 MUD Payroll 2/13/15 Salaries & Wages 4,600.00 700.00 5,300.00 PR 862 02/27/2015 MUD Payroll 2/27/15 Salaries & Wages 500.00 5,800.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,200.00 5,800.00 ** 10,000.00 Budgeted 4,200.00 Remaining 58 % Used Account: 135-50030-026-000 Social Security Taxes 799 02/13/2015 MUD Payroll 2/13/15 Social Security Taxes 285.20 43.40 328.60 PR 862 02/27/2015 MUD Payroll 2/27/15 Social Security Taxes 31.00 359.60 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 74.40 359.60 ** 620.00 Budgeted 260.40 Remaining 58 % Used Account: 135-50035-026-000 Medicare Taxes 799 02/13/2015 MUD Payroll 2/13/15 Medicare Taxes 66.70 10.15 76.85 PR 862 02/27/2015 MUD Payroll 2/27/15 Medicare Taxes 7.25 84.10 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 17.40 84.10 ** 145.00 Budgeted 60.90 Remaining 58 % Used Account: 135-50040-026-000 Unemployment Taxes 799 02/13/2015 MUD Payroll 2/13/15 Unemployment Taxes 105.80 16.10 121.90 PR 862 02/27/2015 MUD Payroll 2/27/15 Unemployment Taxes 11.50 133.40 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 27.60 133.40 ** 230.00 Budgeted 96.60 Remaining 58 % Used Account: 135-50045-026-000 Workman's Compensation 195 02/01/2015 Feb TML Ins & Workers Comp 11.76 2.94 14.70 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 14.70 ** 36.00 Budgeted 21.30 Remaining 41 % 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 37 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 941 02/26/2015 1/27/15-2/26/15 PCards TOM THUMB STOR00017806 124.87 16.37 141.24 TOM THUMB STOR00017806 PC 941 02/26/2015 1/27/15-2/26/15 PCards NORTHWEST METROPORT CH 35.00 176.24 NORTHWEST METROPORT CH PC _______________ Account: 135-60075-026-000 Meetings Totals: 51.37 176.24 ** 1,200.00 Budgeted 1,023.76 Remaining 15 % Used Account: 135-60080-026-000 Schools & Training 942 02/28/2015 Feb A/P PFIA training/Carr @AWBD June 975.00 150.00 1,125.00 AWBD 34694 AP 942 02/28/2015 Feb A/P AWBD Conference/Carr 355.00 1,480.00 AWBD 34694 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 505.00 1,480.00 ** 4,000.00 Budgeted 2,520.00 Remaining 37 % Used Account: 135-60100-026-000 Travel & per diem 1,329.96 .00 1,329.96 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 1,329.96 ** 5,000.00 Budgeted 3,670.04 Remaining 27 % Used Account: 135-60245-026-000 Miscellaneous Expenses 872 02/26/2015 Feb A/P Board Approved Town Founders D 50.00 1,500.00 1,550.00 TOWN OF TROPHY CLUB 34732 AP 941 02/26/2015 1/27/15-2/26/15 PCards FLOWERSHOPNETWORK.COM 74.74 1,624.74 FLOWERSHOPNETWORK.COM PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 1,574.74 1,624.74 ** 1,000.00 Budgeted (624.74) Remaining 162 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 11,037.74 ** 22,881.00 Budgeted 11,843.26 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 799 02/13/2015 MUD Payroll 2/13/15 Salaries & Wages 146,165.36 17,618.07 163,783.43 PR 862 02/27/2015 MUD Payroll 2/27/15 Salaries & Wages 17,616.02 181,399.45 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,234.09 181,399.45 ** 477,578.00 Budgeted 296,178.55 Remaining 38 % Used Account: 135-50010-030-000 Overtime 799 02/13/2015 MUD Payroll 2/13/15 Overtime 77.17 9.06 86.23 PR 862 02/27/2015 MUD Payroll 2/27/15 Overtime 1.56 87.79 PR _______________ Account: 135-50010-030-000 Overtime Totals: 10.62 87.79 ** 1,000.00 Budgeted 912.21 Remaining 9 % 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 799 02/13/2015 MUD Payroll 2/13/15 Retirement 13,390.35 1,570.58 14,960.93 PR 862 02/27/2015 MUD Payroll 2/27/15 Retirement 1,569.73 16,530.66 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,140.31 16,530.66 ** 42,840.00 Budgeted 26,309.34 Remaining 39 % Used Account: 135-50026-030-000 Medical Insurance 799 02/13/2015 MUD Payroll 2/13/15 Medical Insurance 18,215.08 2,457.56 20,672.64 PR 862 02/27/2015 MUD Payroll 2/27/15 Medical Insurance 2,457.50 23,130.14 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,915.06 23,130.14 ** 65,015.00 Budgeted 41,884.86 Remaining 36 % Used Account: 135-50027-030-000 Dental Insurance 799 02/13/2015 MUD Payroll 2/13/15 Dental Insurance 1,277.80 182.11 1,459.91 PR 862 02/27/2015 MUD Payroll 2/27/15 Dental Insurance 182.13 1,642.04 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-50027-030-000 Dental Insurance Totals: 364.24 1,642.04 ** 4,944.00 Budgeted 3,301.96 Remaining 33 % Used Account: 135-50028-030-000 Vision Insurance 799 02/13/2015 MUD Payroll 2/13/15 Vision Insurance 303.83 42.16 345.99 PR 862 02/27/2015 MUD Payroll 2/27/15 Vision Insurance 42.22 388.21 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 84.38 388.21 ** 1,158.00 Budgeted 769.79 Remaining 34 % Used Account: 135-50029-030-000 Life Insurance & Other 697 02/01/2015 Feb A/P Dental, LTD, STD, Life/Feb 1,409.79 331.92 1,741.71 METLIFE GROUP BENEFITS 34607 AP 845 02/19/2015 Feb A/P Admin Fee 36.36 1,778.07 BenefitMall 34666 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 368.28 1,778.07 ** 4,333.00 Budgeted 2,554.93 Remaining 41 % Used Account: 135-50030-030-000 Social Security Taxes 799 02/13/2015 MUD Payroll 2/13/15 Social Security Taxes 8,808.26 1,036.63 9,844.89 PR 862 02/27/2015 MUD Payroll 2/27/15 Social Security Taxes 1,025.31 10,870.20 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,061.94 10,870.20 ** 30,079.00 Budgeted 19,208.80 Remaining 36 % Used Account: 135-50035-030-000 Medicare Taxes 799 02/13/2015 MUD Payroll 2/13/15 Medicare Taxes 2,059.96 242.46 2,302.42 PR 862 02/27/2015 MUD Payroll 2/27/15 Medicare Taxes 239.78 2,542.20 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 482.24 2,542.20 ** 7,422.00 Budgeted 4,879.80 Remaining 34 % Used Account: 135-50040-030-000 Unemployment Taxes 799 02/13/2015 MUD Payroll 2/13/15 Unemployment Taxes 1,231.20 115.14 1,346.34 PR 862 02/27/2015 MUD Payroll 2/27/15 Unemployment Taxes 97.88 1,444.22 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 213.02 1,444.22 ** 1,449.00 Budgeted 4.78 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-50045-030-000 Workman's Compensation 195 02/01/2015 Feb TML Ins & Workers Comp 349.20 87.30 436.50 GL 964 02/28/2015 Correct coding on TML WC refnd (1,320.00) (883.50) GL 958 02/28/2015 Correct coding/TML W/C Refund 1,320.00 436.50 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 436.50 ** 1,636.00 Budgeted 1,199.50 Remaining 27 % 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 941 02/26/2015 1/27/15-2/26/15 PCards WAL-MART #5247 2,221.64 17.14 2,238.78 WAL-MART #5247 PC 941 02/26/2015 1/27/15-2/26/15 PCards WHATABURGER 754 Q26 22.86 2,261.64 WHATABURGER 754 Q26 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 40.00 2,261.64 ** 5,000.00 Budgeted 2,738.36 Remaining 45 % Used Account: 135-55030-030-000 Software & Support 845 02/19/2015 Feb A/P Internet 1/12-3/31 68,406.26 3,144.47 71,550.73 WHOLESALE CARRIER SERVICES INC 34680 AP 941 02/26/2015 1/27/15-2/26/15 PCards ATT*BILL PAYMENT 52.18 71,602.91 ATT*BILL PAYMENT PC 941 02/26/2015 1/27/15-2/26/15 PCards ATT*BILL PAYMENT 68.49 71,671.40 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 3,265.14 71,671.40 ** 87,423.00 Budgeted 15,751.60 Remaining 82 % Used Account: 135-55070-030-000 Independent Labor 845 02/19/2015 Feb A/P Video MUD meeting 9,018.75 26.25 9,045.00 MIGUEL CRUZ 34671 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 26.25 9,045.00 ** 32,550.00 Budgeted 23,505.00 Remaining 28 % Used Account: 135-55080-030-000 Maintenance & Repairs .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-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 872 02/26/2015 Feb A/P Rug service 2,675.38 95.42 2,770.80 G & K SERVICES 34704 AP 872 02/26/2015 Feb A/P Rug service 95.42 2,866.22 G & K SERVICES 34704 AP 872 02/26/2015 Feb A/P Rug service 95.42 2,961.64 G & K SERVICES 34704 AP 872 02/26/2015 Feb A/P Rug service 95.42 3,057.06 G & K SERVICES 34704 AP 941 02/26/2015 1/27/15-2/26/15 PCards WM SUPERCENTER #266 49.94 3,107.00 WM SUPERCENTER #266 PC 941 02/26/2015 1/27/15-2/26/15 PCards WM SUPERCENTER #266 69.94 3,176.94 WM SUPERCENTER #266 PC 941 02/26/2015 1/27/15-2/26/15 PCards WM SUPERCENTER #2980 74.91 3,251.85 WM SUPERCENTER #2980 PC 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (190.84) 3,061.01 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 385.63 3,061.01 ** 6,500.00 Budgeted 3,438.99 Remaining 47 % Used Account: 135-55120-030-000 Cleaning Services 845 02/19/2015 Feb A/P January Janitorial Service 1,882.59 627.53 2,510.12 MEMBER'S BUILDING MAINTENANCE 34670 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 627.53 2,510.12 ** 8,100.00 Budgeted 5,589.88 Remaining 31 % Used Account: 135-55160-030-000 Professional Outside Services 801 02/11/2015 Feb A/P Certificate of CPA/Revenue Bon 41,027.95 147.00 41,174.95 LAFOLLETT & ABBOTT PLLC 34643 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 147.00 41,174.95 ** 58,000.00 Budgeted 16,825.05 Remaining 71 % Used Account: 135-55161-030-000 Town Personnel Contract 20,000.00 .00 20,000.00 _______________ 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 2,419.80 .00 2,419.80 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 2,419.80 ** 8,200.00 Budgeted 5,780.20 Remaining 30 % Used Account: 135-60005-030-000 Telephone 733 02/03/2015 Feb A/P Feb Answering Service 3,332.81 180.00 3,512.81 KEYSTONE PARK SECRETARIAL 34602 AP 872 02/26/2015 Feb A/P BOA PCards 768.53 4,281.34 TOWN OF TROPHY CLUB 34732 AP 941 02/26/2015 1/27/15-2/26/15 PCards ATT*BUS PHONE PMT 372.71 4,654.05 ATT*BUS PHONE PMT PC _______________ Account: 135-60005-030-000 Telephone Totals: 1,321.24 4,654.05 ** 13,361.00 Budgeted 8,706.95 Remaining 35 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 845 02/19/2015 Feb A/P Cell phones 1,328.90 37.99 1,366.89 VERIZON WIRELESS 34677 AP 941 02/26/2015 1/27/15-2/26/15 PCards RINGCENTRAL, INC 10.72 1,377.61 RINGCENTRAL, INC PC 862 02/27/2015 MUD Payroll 2/27/15 Communications/Pagers/Mobiles 300.00 1,677.61 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 348.71 1,677.61 ** 4,056.00 Budgeted 2,378.39 Remaining 41 % Used Account: 135-60020-030-000 Electricity/Gas 872 02/26/2015 Feb A/P Nevill, Symonds, Gexa 1,414.47 1,204.12 2,618.59 TOWN OF TROPHY CLUB 34732 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,204.12 2,618.59 ** 14,978.00 Budgeted 12,359.41 Remaining 17 % Used Account: 135-60025-030-000 Water 942 02/28/2015 Feb A/P February water 313.48 129.60 443.08 TROPHY CLUB MUD (WATER BILLS) 34733 AP 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (64.80) 378.28 AR _______________ Account: 135-60025-030-000 Water Totals: 64.80 378.28 ** 1,500.00 Budgeted 1,121.72 Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-60035-030-000 Postage 809 02/12/2015 Feb A/P Overnight letters 9,594.80 19.96 9,614.76 FEDERAL EXPRESS CORP 34632 AP 809 02/12/2015 Feb A/P Overnight letters 8.95 9,623.71 FEDERAL EXPRESS CORP 34632 AP 893 02/28/2015 Feb Postage meter usage 92.82 9,716.53 GL 942 02/28/2015 Feb A/P Overnight letters 32.37 9,748.90 FEDERAL EXPRESS CORP 34701 AP _______________ Account: 135-60035-030-000 Postage Totals: 154.10 9,748.90 ** 28,500.00 Budgeted 18,751.10 Remaining 34 % Used Account: 135-60040-030-000 Service Charges & Fees 884 02/03/2015 Credit Card Fees 13,968.73 3,365.06 17,333.79 GL 884 02/03/2015 Credit Card Fees 115.45 17,449.24 GL 884 02/03/2015 Credit Card Fees 69.38 17,518.62 GL 889 02/28/2015 Bank Analysis Fee- Jan 250.00 17,768.62 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,799.89 17,768.62 ** 32,000.00 Budgeted 14,231.38 Remaining 56 % 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 195 02/01/2015 Feb TML Ins & Workers Comp 16,285.29 4,063.01 20,348.30 GL 845 02/19/2015 Feb A/P Bond/McKnight 50.00 20,398.30 VICTOR O SCHINNERER & CO, INC 34678 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,113.01 20,398.30 ** 48,751.00 Budgeted 28,352.70 Remaining 42 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 845 02/19/2015 Feb A/P Notice of Adoption of Rules 151.00 891.27 1,042.27 STAR-TELEGRAM OPERATING LTD 34674 AP 941 02/26/2015 1/27/15-2/26/15 PCards AMERICAN WATERWORKS 181.50 1,223.77 AMERICAN WATERWORKS PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 1,072.77 1,223.77 ** 1,000.00 Budgeted (223.77) Remaining 122 % Used Account: 135-60070-030-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 941 02/26/2015 1/27/15-2/26/15 PCards NORTHWEST METROPORT CH 25.11 35.00 60.11 NORTHWEST METROPORT CH PC _______________ Account: 135-60075-030-000 Meetings Totals: 35.00 60.11 ** 400.00 Budgeted 339.89 Remaining 15 % Used Account: 135-60079-030-000 Public Education 941 02/26/2015 1/27/15-2/26/15 PCards IN *HAPPY JUMPER 400.00 400.00 IN *HAPPY JUMPER PC 941 02/26/2015 1/27/15-2/26/15 PCards LETS JUMP 186.10 586.10 LETS JUMP PC 941 02/26/2015 1/27/15-2/26/15 PCards AMAZON MKTPLACE PMTS 22.34 608.44 AMAZON MKTPLACE PMTS PC 941 02/26/2015 1/27/15-2/26/15 PCards BEADS IN BULK 24.75 633.19 BEADS IN BULK PC _______________ Account: 135-60079-030-000 Public Education Totals: 633.19 633.19 ** 5,000.00 Budgeted 4,366.81 Remaining 13 % Used Account: 135-60080-030-000 Schools & Training 809 02/12/2015 Feb A/P Customer Service Virtual Train 268.00 700.00 968.00 MELISSA KOVACEVIC 34649 AP 872 02/26/2015 Feb A/P 3 day Word Press Training/Schu 1,275.00 2,243.00 WEBUCATOR, INC. 34735 AP 941 02/26/2015 1/27/15-2/26/15 PCards NCTCOG RTC TRAINING 270.00 2,513.00 NCTCOG RTC TRAINING PC 941 02/26/2015 1/27/15-2/26/15 PCards ACFE 175.00 2,688.00 ACFE PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 2,420.00 2,688.00 ** 10,235.00 Budgeted 7,547.00 Remaining 26 % Used Account: 135-60100-030-000 Travel & per diem 799 02/13/2015 MUD Payroll 2/13/15 Travel & per diem 511.74 21.97 533.71 PR 862 02/27/2015 MUD Payroll 2/27/15 Travel & per diem 48.47 582.18 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 70.44 582.18 ** 5,400.00 Budgeted 4,817.82 Remaining 11 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 950 02/28/2015 Feb A/P Advertisement for Bid Lift Sta 239.28 721.59 960.87 STAR-TELEGRAM OPERATING LTD 34729 AP 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (721.59) 239.28 AR _______________ Account: 135-60125-030-000 Advertising Totals: .00 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 941 02/26/2015 1/27/15-2/26/15 PCards FLOWERSHOPNETWORK.COM 3,366.65 69.73 3,436.38 FLOWERSHOPNETWORK.COM PC 941 02/26/2015 1/27/15-2/26/15 PCards (433.76) 3,002.62 PC 941 02/26/2015 1/27/15-2/26/15 PCards (4.34) 2,998.28 PC 941 02/26/2015 1/27/15-2/26/15 PCards 4.34 3,002.62 PC 941 02/26/2015 1/27/15-2/26/15 PCards JPS- ECOMMERCE 433.76 3,436.38 JPS- ECOMMERCE PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 69.73 3,436.38 ** 17,500.00 Budgeted 14,063.62 Remaining 20 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65010-030-000 Uniforms 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 845 02/19/2015 Feb A/P Laptop, Docking Station, Bag 31,857.24 2,106.99 33,964.23 M3 Networks 34669 AP 847 02/19/2015 Void A/P Ck 34669/M3 Chg Amt Laptop, Docking Station, Bag (2,106.99) 31,857.24 M3 Networks 34669 AP 848 02/19/2015 Feb A/P Laptop & Docking Station 2,027.99 33,885.23 M3 Networks 34682 AP _______________ Account: 135-65055-030-000 Hardware Totals: 2,027.99 33,885.23 ** 35,226.00 Budgeted 1,340.77 Remaining 96 % Used Account: 135-65085-030-000 Office Supplies 809 02/12/2015 Feb A/P Office supplies 2,337.27 353.66 2,690.93 OFFICE DEPOT, INC 34652 AP 809 02/12/2015 Feb A/P Office supplies 3.39 2,694.32 OFFICE DEPOT, INC 34652 AP 845 02/19/2015 Feb A/P Office Supplies 41.36 2,735.68 OFFICE DEPOT, INC 34673 AP 845 02/19/2015 Feb A/P Office Supplies 9.95 2,745.63 OFFICE DEPOT, INC 34673 AP 941 02/26/2015 1/27/15-2/26/15 PCards KELLER TROPHY AND AWAR 83.90 2,829.53 KELLER TROPHY AND AWAR PC 941 02/26/2015 1/27/15-2/26/15 PCards AMAZON.COM 26.88 2,856.41 AMAZON.COM PC 941 02/26/2015 1/27/15-2/26/15 PCards AMAZON MKTPLACE PMTS 19.80 2,876.21 AMAZON MKTPLACE PMTS PC 941 02/26/2015 1/27/15-2/26/15 PCards AMAZON MKTPLACE PMTS 66.90 2,943.11 AMAZON MKTPLACE PMTS PC 961 02/28/2015 Town Billing 1268-1276 AR 20150201-20150228 User: (30.44) 2,912.67 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 575.40 2,912.67 ** 9,000.00 Budgeted 6,087.33 Remaining 32 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 941 02/26/2015 1/27/15-2/26/15 PCards SHI GOVERNMENT SOLUTIO 253.10 694.70 947.80 SHI GOVERNMENT SOLUTIO PC 941 02/26/2015 1/27/15-2/26/15 PCards SHI GOVERNMENT SOLUTIO 191.50 1,139.30 SHI GOVERNMENT SOLUTIO PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 886.20 1,139.30 ** 4,732.00 Budgeted 3,592.70 Remaining 24 % Used Account: 135-65095-030-000 Maintenance Supplies 941 02/26/2015 1/27/15-2/26/15 PCards SAMSCLUB #4795 1,621.60 219.27 1,840.87 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 219.27 1,840.87 ** 5,000.00 Budgeted 3,159.13 Remaining 37 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-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 61,726.66 .00 61,726.66 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 61,726.66 ** 67,000.00 Budgeted 5,273.34 Remaining 92 % Used Account: 135-69170-030-000 Copier Lease Installments 872 02/26/2015 Feb A/P Nevill, Symonds, Gexa 947.71 338.76 1,286.47 TOWN OF TROPHY CLUB 34732 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 338.76 1,286.47 ** 4,236.00 Budgeted 2,949.53 Remaining 30 % 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: ------------------------------------------------------------------------------------------------ 591,379.71 ** 1,244,664.00 Budgeted 653,284.29 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/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 845 02/19/2015 Feb A/P Legal 251,736.35 11.85 251,748.20 Norton Rose Fulbright US LLP 34672 AP 845 02/19/2015 Feb A/P Jan Legal 7,621.20 259,369.40 WHITAKER CHALK SWINDLE 34679 AP 845 02/19/2015 Feb A/P Jan Legal 73,253.25 332,622.65 WHITAKER CHALK SWINDLE 34679 AP 845 02/19/2015 Feb A/P Legal 2,454.60 335,077.25 WHITAKER CHALK SWINDLE 34679 AP _______________ Account: 135-55045-039-000 Legal Totals: 83,340.90 335,077.25 ** 300,000.00 Budgeted (35,077.25) Remaining 112 % Used Account: 135-55055-039-000 Auditing 16,836.00 .00 16,836.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 16,836.00 ** 22,491.00 Budgeted 5,655.00 Remaining 75 % Used Account: 135-55060-039-000 Appraisal 4,199.74 .00 4,199.74 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 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: ------------------------------------------------------------------------------------------------ 358,569.39 ** 336,291.00 Budgeted (22,278.39) Remaining 107 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (1,059,176.03) .00 Budgeted 1,059,176.03 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 2/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 50 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 2/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 51 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 2/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 52 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 2/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 890 02/28/2015 Bank Interest/February (4.99) (.84) (5.83) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (.84) (5.83) ** .00 Budgeted 5.83 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5.83) ** .00 Budgeted 5.83 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 2/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 872 02/26/2015 Feb A/P Ind Creek Waterline Replacemen 2,100.00 150.00 2,250.00 TEAGUE, NALL & PERKINS,INC 34731 AP _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: 150.00 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 2,244.17 3,348.00 Budgeted 1,103.83 Remaining 67 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET FEBRUARY 2015 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,376,977 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,376,977 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 4,376,977 TOTAL FUND BALANCE 4,376,977 TOTAL LIABILITIES AND FUND BALANCE 4,376,977 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 17:59 03/06/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 148.58- 393.47- 393.47 517-49105-000-000 Bond Proceeds 148,200.00- 5,765,000.00- 5,765,000.00 Subtotal: 148,348.58- 5,765,393.47- 5,765,393.47 Program number: 148,348.58- 5,765,393.47- 5,765,393.47 Department number: Revenues 148,348.58- 5,765,393.47- 5,765,393.47 Revenues Subtotal ----------- 148,348.58- 5,765,393.47- 5,765,393.47 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 17:59 03/06/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/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- Subtotal: 1,088,713.71 1,088,713.71- 517-69005-020-000 Capital Outlays 151,502.50 151,502.50- Subtotal: 151,502.50 151,502.50- 517-70020-020-000 Bond Issuance 148,200.00 148,200.00 148,200.00- Subtotal: 148,200.00 148,200.00 148,200.00- Program number: 148,200.00 1,388,416.21 1,388,416.21- Department number: Wastewater 148,200.00 1,388,416.21 1,388,416.21- Expenditures Subtotal ----------- 148,200.00 1,388,416.21 1,388,416.21- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 148.58- 4,376,977.26- 4,376,977.26 . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/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 890 02/28/2015 Bank Interest/February (244.89) (148.58) (393.47) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (148.58) (393.47) ** .00 Budgeted 393.47 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds 891 02/28/2015 Additional Bond entries Additional Bond entries (5,616,800.00) (148,200.00) (5,765,000.00) GL _______________ Account: 517-49105-000-000 Bond Proceeds Totals: (148,200.00) (5,765,000.00) ** .00 Budgeted 5,765,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,765,393.47) ** .00 Budgeted 5,765,393.47 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-60135-020-000 TCEQ Permits & Fees 14,376.56 .00 14,376.56 _______________ Account: 517-60135-020-000 TCEQ Permits & Fees Totals: .00 14,376.56 ** .00 Budgeted (14,376.56) Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 .00 1,074,337.15 _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 1,074,337.15 ** .00 Budgeted (1,074,337.15) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 151,502.50 .00 151,502.50 _______________ Account: 517-69005-020-000 Capital Outlays Totals: .00 151,502.50 ** .00 Budgeted (151,502.50) Remaining 0 % Used Account: 517-70020-020-000 Bond Issuance 891 02/28/2015 Additional Bond entries Additional Bond entries 148,200.00 148,200.00 GL _______________ Account: 517-70020-020-000 Bond Issuance Totals: 148,200.00 148,200.00 ** .00 Budgeted (148,200.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,388,416.21 ** .00 Budgeted (1,388,416.21) Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (4,376,977.26) .00 Budgeted 4,376,977.26 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET FEBRUARY 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 591,199 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 28,090 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 624,135 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 28,090 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 28,090 FUND BALANCE ASSIGNED FUND BALANCE 14,752 NET REVENUES / EXPENDITURES 581,293 TOTAL FUND BALANCE 596,045 TOTAL LIABILITIES AND FUND BALANCE 624,135 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 17:59 03/06/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/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- 40,529.05- 449,411.96- 96.436 16,607.04- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 206.79- 1,572.08- 62.883 927.92- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 396.36- 691.78- 43.236 908.22- Subtotal: 470,119.00- 470,119.00- 41,132.20- 451,675.82- 96.077 18,443.18- 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- 22.00- 3,333.67- 888.979 2,958.67 533-49015-000-000 Lease/Rental Income 211,829.00- 211,829.00- 211,829.00- 211,829.00- 100.000 533-49110-000-000 Premium on Bonds Sold 4,957.90- 4,957.90 Subtotal: 212,204.00- 212,204.00- 211,851.00- 220,120.57- 103.731 7,916.57 Program number: 1,139,861.00- 1,139,861.00- 252,983.20- 671,796.39- 58.937 468,064.61- Department number: Revenues 1,139,861.00- 1,139,861.00- 252,983.20- 671,796.39- 58.937 468,064.61- Revenues Subtotal ----------- 1,139,861.00- 1,139,861.00- 252,983.20- 671,796.39- 58.937 468,064.61- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 17:59 03/06/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 1,250.00 1,250.00 49.020 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 403,103.00 403,103.00 89,253.75 89,253.75 22.142 313,849.25 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 90,503.75 90,503.75 7.953 1,047,432.25 Program number: 1,137,936.00 1,137,936.00 90,503.75 90,503.75 7.953 1,047,432.25 Department number: Administration 1,137,936.00 1,137,936.00 90,503.75 90,503.75 7.953 1,047,432.25 Expenditures Subtotal ----------- 1,137,936.00 1,137,936.00 90,503.75 90,503.75 7.953 1,047,432.25 Fund number: 533 MUD 1 I&S Consolidated 1,925.00- 1,925.00- 162,479.45- 581,292.64- ############### 579,367.64 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/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 910 02/02/2015 Property Taxes/Assessments (408,882.91) (7,763.32) (416,646.23) GL 909 02/03/2015 Property Taxes/Assessments (2,247.58) (418,893.81) GL 911 02/04/2015 Property Taxes/Assessments (6,126.52) (425,020.33) GL 912 02/05/2015 Property Taxes/Assessments (2,875.58) (427,895.91) GL 913 02/06/2015 Property Taxes/Assessments (16,133.91) (444,029.82) GL 914 02/09/2015 Property Taxes/Assessments (2,614.84) (446,644.66) GL 915 02/10/2015 Property Taxes/Assessments (656.55) (447,301.21) GL 916 02/11/2015 Property Taxes/Assessments (94.70) (447,395.91) GL 917 02/12/2015 Property Taxes/Assessments (66.63) (447,462.54) GL 918 02/13/2015 Property Taxes/Assessments (536.92) (447,999.46) GL 919 02/17/2015 Property Taxes/Assessments (584.86) (448,584.32) GL 908 02/18/2015 Property Taxes/Assessments (181.27) (448,765.59) GL 907 02/19/2015 Property Taxes/Assessments (160.52) (448,926.11) GL 906 02/20/2015 Property Taxes/Assessments (216.28) (449,142.39) GL 905 02/25/2015 Property Taxes/Assessments (181.02) (449,323.41) GL 904 02/26/2015 Property Taxes/Assessments (88.55) (449,411.96) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (40,529.05) (449,411.96) ** (466,019.00) Budgeted (16,607.04) Remaining 96 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 910 02/02/2015 Property Taxes/Assessments (1,365.29) (12.35) (1,377.64) GL 909 02/03/2015 Property Taxes/Assessments (4.25) (1,381.89) GL 913 02/06/2015 Property Taxes/Assessments (339.41) (1,721.30) GL 908 02/18/2015 Property Taxes/Assessments 149.22 (1,572.08) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (206.79) (1,572.08) ** (2,500.00) Budgeted (927.92) Remaining 63 % Used Account: 533-40015-000-000 Property Taxes/P & I 910 02/02/2015 Property Taxes/Assessments (295.42) (2.96) (298.38) GL 909 02/03/2015 Property Taxes/Assessments (1.02) (299.40) GL 912 02/05/2015 Property Taxes/Assessments (1.38) (300.78) GL 913 02/06/2015 Property Taxes/Assessments (148.92) (449.70) GL 914 02/09/2015 Property Taxes/Assessments (94.36) (544.06) GL 916 02/11/2015 Property Taxes/Assessments (6.63) (550.69) GL 917 02/12/2015 Property Taxes/Assessments (4.65) (555.34) GL 918 02/13/2015 Property Taxes/Assessments (37.58) (592.92) GL 919 02/17/2015 Property Taxes/Assessments (40.94) (633.86) GL 908 02/18/2015 Property Taxes/Assessments (12.69) (646.55) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 907 02/19/2015 Property Taxes/Assessments (295.42) (11.23) (657.78) GL 906 02/20/2015 Property Taxes/Assessments (15.13) (672.91) GL 905 02/25/2015 Property Taxes/Assessments (12.68) (685.59) GL 904 02/26/2015 Property Taxes/Assessments (6.19) (691.78) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (396.36) (691.78) ** (1,600.00) Budgeted (908.22) Remaining 43 % Used 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 890 02/28/2015 Bank Interest/February (3,311.67) (22.00) (3,333.67) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (22.00) (3,333.67) ** (375.00) Budgeted 2,958.67 Remaining 889 % Used Account: 533-49015-000-000 Lease/Rental Income 956 02/02/2015 FD Rent to I&S (211,829.00) (211,829.00) GL _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: (211,829.00) (211,829.00) ** (211,829.00) Budgeted .00 Remaining 100 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ------------------------------------------------------------------------------------------------ (671,796.39) ** (1,139,861.00) Budgeted (468,064.61) Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 17:59 03/06/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/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 885 02/27/2015 Bond Payments 2010 Bond Admin fee 750.00 750.00 GL 885 02/27/2015 Bond Payments 2012 Bond Admin Fee 500.00 1,250.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 1,250.00 1,250.00 ** 2,550.00 Budgeted 1,300.00 Remaining 49 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 885 02/27/2015 Bond Payments 2010 Bond Interest Payment 36,866.25 36,866.25 GL 885 02/27/2015 Bond Payments 2012 Bond Interest Payment 26,625.00 63,491.25 GL 885 02/27/2015 Bond Payments 2013 Bond Interest Payment 25,762.50 89,253.75 GL _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: 89,253.75 89,253.75 ** 403,103.00 Budgeted 313,849.25 Remaining 22 % 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: ------------------------------------------------------------------------------------------------ 90,503.75 ** 1,137,936.00 Budgeted 1,047,432.25 Remaining 8 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (581,292.64) (1,925.00) Budgeted 579,367.64 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (6,444,572.67) **** 1,423.00 Budgeted 6,445,995.67 Remaining ########## ******* End of Report *********