Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Oct Combined Financials
TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2014 122 ASSETS FIRE DEPT. INVESTMENTS 349,851 PREPAID EXPENSES 17,590 ADVALOREM PROPERTY TAXES RECEIVABLE 871,049 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 361,132 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,981 TOTAL ASSETS 1,601,604 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,232,183 ACCOUNTS AND OTHER PAYABLES 9,645 TOTAL LIABILITIES 1,241,828 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (169,134) TOTAL FUND BALANCE 359,777 TOTAL LIABILITIES AND FUND BALANCE 1,601,604 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 17:00 11/12/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2014 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- 4,519.52- 4,519.52- 1.264 352,942.48- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 108.28- 108.28- 108.28 122-40010-000-000 Property Taxes/MUD Fire 872,859.00- 872,859.00- 12,064.63- 12,064.63- 1.382 860,794.37- 122-40011-000-000 Property Taxes/Fire-Delinquent 2,875.27- 2,875.27- 2,875.27 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 17.33- 17.33- 2.311 732.67- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 687.73- 687.73- 15.283 3,812.27- Subtotal: 1,235,571.00- 1,235,571.00- 20,272.76- 20,272.76- 1.641 1,215,298.24- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 400.00- 6.667 5,600.00- Subtotal: 6,000.00- 6,000.00- 400.00- 400.00- 6.667 5,600.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 75.00- 75.00- 10.714 625.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,700.00- 10,700.00- 75.00- 75.00- .701 10,625.00- 122-49035-000-000 Prior Year Reserves 125,669.00- 125,669.00- 125,670.00- 125,670.00- 100.001 1.00 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 800.00- 800.00- 13.333 5,200.00- Subtotal: 131,669.00- 131,669.00- 126,470.00- 126,470.00- 96.051 5,199.00- Program number: 1,383,940.00- 1,383,940.00- 147,217.76- 147,217.76- 10.638 1,236,722.24- Department number: Fire Revenues 1,383,940.00- 1,383,940.00- 147,217.76- 147,217.76- 10.638 1,236,722.24- Revenues Subtotal ----------- 1,383,940.00- 1,383,940.00- 147,217.76- 147,217.76- 10.638 1,236,722.24- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 17:00 11/12/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 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 22,574.87 22,574.87 4.813 446,492.13 122-50010-045-000 Overtime 46,745.00 46,745.00 3,367.44 3,367.44 7.204 43,377.56 122-50011-045-000 DPS Holiday Pay 14,930.00 14,930.00 14,930.00 122-50016-045-000 Longevity 5,505.00 5,505.00 5,505.00 122-50017-045-000 Certification 4,800.00 4,800.00 119.00 119.00 2.479 4,681.00 122-50020-045-000 Retirement 91,396.00 91,396.00 3,779.36 3,779.36 4.135 87,616.64 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 2,933.54 2,933.54 4.958 56,235.46 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 241.87 241.87 5.510 4,148.13 122-50028-045-000 Vision Insurance 811.00 811.00 42.41 42.41 5.229 768.59 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 211.45 211.45 5.247 3,818.55 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 1,466.95 1,466.95 4.389 31,954.05 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 342.88 342.88 4.702 6,949.12 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 1,657.00 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 659.00 659.00 7.582 8,033.00 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 250.00 122-50075-045-000 Tuition Reimbursement 300.00 300.00 300.00 Subtotal: 752,455.00 752,455.00 35,738.77 35,738.77 4.750 716,716.23 122-55030-045-000 Software & Support 7,378.00 7,378.00 462.50 462.50 6.269 6,915.50 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 28.40 28.40 .153 18,523.60 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 193.52 193.52 1.613 11,806.48 Subtotal: 39,430.00 39,430.00 684.42 684.42 1.736 38,745.58 122-60005-045-000 Telephone 50.00 50.00 50.00 122-60010-045-000 Communications/Pagers/Mobiles 5,000.00 5,000.00 2,236.50 2,236.50 44.730 2,763.50 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 299.78- 299.78- -3.321 9,325.78 122-60025-045-000 Water 1,200.00 1,200.00 114.78 114.78 9.565 1,085.22 122-60026-045-000 Cable 1,920.00 1,920.00 153.76 153.76 8.008 1,766.24 122-60030-045-000 Rent And/Or Usage 211,829.00 211,829.00 211,829.00 122-60035-045-000 Postage 100.00 100.00 .48 .48 .480 99.52 122-60055-045-000 Insurance 12,179.00 12,179.00 940.09 940.09 7.719 11,238.91 122-60066-045-000 Publications/Books/Subscrips 200.00 200.00 200.00 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 7,059.85 7,059.85 46.508 8,120.15 122-60080-045-000 Schools & Training 4,280.00 4,280.00 85.00 85.00 1.986 4,195.00 122-60096-045-000 Emergency Management 1,400.00 1,400.00 1,400.00 122-60100-045-000 Travel & per diem 13,577.00 13,577.00 13,577.00 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 5,100.00 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 500.42 500.42 11.120 3,999.58 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 1,000.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 137.10 137.10 6.855 1,862.90 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 17:00 11/12/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 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 1,000.00 Subtotal: 291,541.00 291,541.00 10,928.20 10,928.20 3.748 280,612.80 122-65005-045-000 Fuel & Lube 10,454.00 10,454.00 1,011.94 1,011.94 9.680 9,442.06 122-65010-045-000 Uniforms 2,000.00 2,000.00 2,000.00 122-65015-045-000 Protective Clothing 5,200.00 5,200.00 5,200.00 122-65030-045-000 Chemicals 200.00 200.00 200.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 2,500.00 122-65055-045-000 Hardware 9,000.00 9,000.00 9,000.00 122-65085-045-000 Office Supplies 500.00 500.00 500.00 122-65105-045-000 Printing 548.00 548.00 38.17 38.17 6.965 509.83 Subtotal: 30,402.00 30,402.00 1,050.11 1,050.11 3.454 29,351.89 122-69005-045-000 Capital Outlays 250,000.00 250,000.00 250,000.00- 122-69008-045-000 Short Term Debt-Principal 158,262.00 158,262.00 158,262.00 122-69009-045-000 Short Term Debt-Interest 50,000.00 50,000.00 50,000.00 122-69050-045-000 Radios 23,500.00 23,500.00 23,500.00 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 17,950.00 17,950.00 17,950.00 100.000 122-69255-045-000 Airpacks 20,400.00 20,400.00 20,400.00 Subtotal: 270,112.00 270,112.00 267,950.00 267,950.00 99.200 2,162.00 Program number: 1,383,940.00 1,383,940.00 316,351.50 316,351.50 22.859 1,067,588.50 Department number: Fire 1,383,940.00 1,383,940.00 316,351.50 316,351.50 22.859 1,067,588.50 Expenditures Subtotal ----------- 1,383,940.00 1,383,940.00 316,351.50 316,351.50 22.859 1,067,588.50 Fund number: 122 Trophy Club MUD Fire Dept. 169,133.74 169,133.74 169,133.74- . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2014 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 221 10/09/2014 Property Taxes/Assessments (339.99) (339.99) GL 225 10/15/2014 Property Taxes/Assessments (365.70) (705.69) GL 226 10/16/2014 Property Taxes/Assessments (40.31) (746.00) GL 227 10/20/2014 Property Taxes/Assessments (50.63) (796.63) GL 230 10/22/2014 Property Taxes/Assessments (279.06) (1,075.69) GL 232 10/24/2014 Property Taxes/Assessments (1,308.51) (2,384.20) GL 233 10/27/2014 Property Taxes/Assessments (52.74) (2,436.94) GL 234 10/28/2014 Property Taxes/Assessments (1,244.16) (3,681.10) GL 235 10/29/2014 Property Taxes/Assessments (314.61) (3,995.71) GL 237 10/31/2014 Property Taxes/Assessments (523.81) (4,519.52) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (4,519.52) (4,519.52) ** (357,462.00) Budgeted (352,942.48) Remaining 1 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 225 10/15/2014 Property Taxes/Assessments (108.28) (108.28) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (108.28) (108.28) ** .00 Budgeted 108.28 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 220 10/06/2014 Property Taxes/Assessments (17.81) (17.81) GL 222 10/10/2014 Property Taxes/Assessments (139.08) (156.89) GL 223 10/13/2014 Property Taxes/Assessments (359.84) (516.73) GL 224 10/14/2014 Property Taxes/Assessments (507.51) (1,024.24) GL 225 10/15/2014 Property Taxes/Assessments (192.68) (1,216.92) GL 226 10/16/2014 Property Taxes/Assessments (161.93) (1,378.85) GL 227 10/20/2014 Property Taxes/Assessments (209.91) (1,588.76) GL 229 10/21/2014 Property Taxes/Assessments (154.70) (1,743.46) GL 230 10/22/2014 Property Taxes/Assessments (346.14) (2,089.60) GL 231 10/23/2014 Property Taxes/Assessments (790.92) (2,880.52) GL 232 10/24/2014 Property Taxes/Assessments (963.01) (3,843.53) GL 233 10/27/2014 Property Taxes/Assessments (951.14) (4,794.67) GL 234 10/28/2014 Property Taxes/Assessments (2,543.85) (7,338.52) GL 235 10/29/2014 Property Taxes/Assessments (1,759.07) (9,097.59) GL 236 10/30/2014 Property Taxes/Assessments (1,028.85) (10,126.44) GL 237 10/31/2014 Property Taxes/Assessments (1,938.19) (12,064.63) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (12,064.63) (12,064.63) ** (872,859.00) Budgeted (860,794.37) Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2014 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 219 10/07/2014 Property Taxes/Assessments 6.56 6.56 GL 224 10/14/2014 Property Taxes/Assessments (159.81) (153.25) GL 225 10/15/2014 Property Taxes/Assessments (28.67) (181.92) GL 226 10/16/2014 Property Taxes/Assessments (7.13) (189.05) GL 227 10/20/2014 Property Taxes/Assessments (2,469.99) (2,659.04) GL 231 10/23/2014 Property Taxes/Assessments (181.62) (2,840.66) GL 234 10/28/2014 Property Taxes/Assessments (24.11) (2,864.77) GL 235 10/29/2014 Property Taxes/Assessments (10.40) (2,875.17) GL 236 10/30/2014 Property Taxes/Assessments (.10) (2,875.27) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (2,875.27) (2,875.27) ** .00 Budgeted 2,875.27 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 225 10/15/2014 Property Taxes/Assessments (17.33) (17.33) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (17.33) (17.33) ** (750.00) Budgeted (732.67) Remaining 2 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 224 10/14/2014 Property Taxes/Assessments (33.56) (33.56) GL 225 10/15/2014 Property Taxes/Assessments (9.57) (43.13) GL 226 10/16/2014 Property Taxes/Assessments (2.36) (45.49) GL 227 10/20/2014 Property Taxes/Assessments (518.69) (564.18) GL 231 10/23/2014 Property Taxes/Assessments (38.14) (602.32) GL 234 10/28/2014 Property Taxes/Assessments (3.44) (605.76) GL 235 10/29/2014 Property Taxes/Assessments (2.19) (607.95) GL 236 10/30/2014 Property Taxes/Assessments (.06) (608.01) GL 237 10/31/2014 Property Taxes/Assessments (79.72) (687.73) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (687.73) (687.73) ** (4,500.00) Budgeted (3,812.27) Remaining 15 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (400.00) (400.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (400.00) ** (6,000.00) Budgeted (5,600.00) Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-43400-000-000 Fire Inspections 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (75.00) (75.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (75.00) ** (700.00) Budgeted (625.00) Remaining 11 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves 123 10/01/2014 GASB54 Transfers FY2015 Fire Truck Lease down payment (125,670.00) (125,670.00) GL _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: (125,670.00) (125,670.00) ** (125,669.00) Budgeted 1.00 Remaining 100 % Used Account: 122-49036-000-000 GASB Reserves 119 10/28/2014 TXP FD GASB to FD Operating Fire Truck down pmt (151,427.00) (151,427.00) GL 121 10/28/2014 Reverse TXP FD GASB to FD Oper Fire Truck down pmt (151,427.00) (302,854.00) GL 124 10/28/2014 Reverse JE 119 Fire Truck down pmt 151,427.00 (151,427.00) GL 125 10/28/2014 Reverse JE 121 Fire Truck down pmt 151,427.00 .00 GL _______________ Account: 122-49036-000-000 GASB Reserves Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (800.00) (800.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (800.00) (800.00) ** (6,000.00) Budgeted (5,200.00) Remaining 13 % Used Department Totals: ------------------------------------------------------------------------------------------------ (147,217.76) ** (1,383,940.00) Budgeted (1,236,722.24) Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 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 46 10/10/2014 FD 10/1-10/4/14 Payroll 4,913.29 4,913.29 GL 203 10/24/2014 FD Payroll 10/24 17,661.58 22,574.87 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 22,574.87 22,574.87 ** 469,067.00 Budgeted 446,492.13 Remaining 5 % Used Account: 122-50010-045-000 Overtime 203 10/24/2014 FD Payroll 10/24 3,367.44 3,367.44 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,367.44 3,367.44 ** 46,745.00 Budgeted 43,377.56 Remaining 7 % Used Account: 122-50011-045-000 DPS Holiday Pay .00 .00 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 .00 ** 14,930.00 Budgeted 14,930.00 Remaining 0 % Used Account: 122-50016-045-000 Longevity .00 .00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 .00 ** 5,505.00 Budgeted 5,505.00 Remaining 0 % Used Account: 122-50017-045-000 Certification 46 10/10/2014 FD 10/1-10/4/14 Payroll 119.00 119.00 GL _______________ Account: 122-50017-045-000 Certification Totals: 119.00 119.00 ** 4,800.00 Budgeted 4,681.00 Remaining 2 % Used Account: 122-50020-045-000 Retirement 46 10/10/2014 FD 10/1-10/4/14 Payroll 731.98 731.98 GL 203 10/24/2014 FD Payroll 10/24 3,047.38 3,779.36 GL _______________ Account: 122-50020-045-000 Retirement Totals: 3,779.36 3,779.36 ** 91,396.00 Budgeted 87,616.64 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 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 46 10/10/2014 FD 10/1-10/4/14 Payroll 786.85 786.85 GL 203 10/24/2014 FD Payroll 10/24 2,146.69 2,933.54 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 2,933.54 2,933.54 ** 59,169.00 Budgeted 56,235.46 Remaining 5 % Used Account: 122-50027-045-000 Dental Insurance 46 10/10/2014 FD 10/1-10/4/14 Payroll 52.87 52.87 GL 203 10/24/2014 FD Payroll 10/24 189.00 241.87 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 241.87 241.87 ** 4,390.00 Budgeted 4,148.13 Remaining 6 % Used Account: 122-50028-045-000 Vision Insurance 46 10/10/2014 FD 10/1-10/4/14 Payroll 9.25 9.25 GL 203 10/24/2014 FD Payroll 10/24 33.16 42.41 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 42.41 42.41 ** 811.00 Budgeted 768.59 Remaining 5 % Used Account: 122-50029-045-000 Life Insurance & Other 46 10/10/2014 FD 10/1-10/4/14 Payroll 46.17 46.17 GL 203 10/24/2014 FD Payroll 10/24 165.28 211.45 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 211.45 211.45 ** 4,030.00 Budgeted 3,818.55 Remaining 5 % Used Account: 122-50030-045-000 Social Security Taxes 46 10/10/2014 FD 10/1-10/4/14 Payroll 280.67 280.67 GL 203 10/24/2014 FD Payroll 10/24 1,186.28 1,466.95 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 1,466.95 1,466.95 ** 33,421.00 Budgeted 31,954.05 Remaining 4 % Used Account: 122-50035-045-000 Medicare Taxes 46 10/10/2014 FD 10/1-10/4/14 Payroll 65.54 65.54 GL 203 10/24/2014 FD Payroll 10/24 277.34 342.88 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 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: 342.88 342.88 ** 7,292.00 Budgeted 6,949.12 Remaining 5 % Used Account: 122-50040-045-000 Unemployment Taxes .00 .00 _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .00 .00 ** 1,657.00 Budgeted 1,657.00 Remaining 0 % Used Account: 122-50045-045-000 Workman's Compensation 191 10/01/2014 Oct TML Ins & Workers Comp 659.00 659.00 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 659.00 659.00 ** 8,692.00 Budgeted 8,033.00 Remaining 8 % 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 95 10/21/2014 Oct A/P Charter, TML FD W/C 462.50 462.50 TOWN OF TROPHY CLUB 34306 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 462.50 ** 7,378.00 Budgeted 6,915.50 Remaining 6 % Used Account: 122-55045-045-000 Legal .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 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 161 10/31/2014 Oct A/P Rug Service-Fire Station 24.51 24.51 G & K SERVICES 34316 AP 161 10/31/2014 Oct A/P Rug Service-Fire Station 32.29 56.80 G & K SERVICES 34316 AP 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (28.40) 28.40 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 28.40 28.40 ** 18,552.00 Budgeted 18,523.60 Remaining 0 % Used Account: 122-55090-045-000 Vehicle Maintenance 161 10/31/2014 Oct A/P Batteries 193.52 193.52 AutoZone 34311 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 193.52 193.52 ** 12,000.00 Budgeted 11,806.48 Remaining 2 % Used Account: 122-60005-045-000 Telephone .00 .00 _______________ Account: 122-60005-045-000 Telephone Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 2 10/01/2014 Oct A/P Communications Agreement/Dispa 4,431.00 4,431.00 Denton County 34205 AP 56 10/01/2014 Town Billing Inv 1217 Fire Dispatch 2015 (2,215.50) 2,215.50 GL 46 10/10/2014 FD 10/1-10/4/14 Payroll 21.00 2,236.50 GL _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 2,236.50 2,236.50 ** 5,000.00 Budgeted 2,763.50 Remaining 45 % Used Account: 122-60020-045-000 Electricity/Gas 95 10/21/2014 Oct A/P Electricity 10/1-10/13/14 425.68 425.68 HUDSON ENERGY SERVICES, LLC 34289 AP 101 10/22/2014 Town Inv 1220-1221 AR 20141001-20141022 User: (212.84) 212.84 AR 161 10/31/2014 Oct A/P Electricity 10/1-10/20/14 50.13 262.97 ATMOS ENERGY 34310 AP 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (562.75) (299.78) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60020-045-000 Electricity/Gas Totals: (299.78) (299.78) ** 9,026.00 Budgeted 9,325.78 Remaining -3 % Used Account: 122-60025-045-000 Water 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (114.76) (114.76) AR 254 10/31/2014 Oct A/P Water billing/Oct 82.93 (31.83) TROPHY CLUB MUD (WATER BILLS) 34366 AP 254 10/31/2014 Oct A/P Water billing/Oct 146.61 114.78 TROPHY CLUB MUD (WATER BILLS) 34366 AP _______________ Account: 122-60025-045-000 Water Totals: 114.78 114.78 ** 1,200.00 Budgeted 1,085.22 Remaining 10 % Used Account: 122-60026-045-000 Cable 214 10/14/2014 Firefighter Oct Cable (133.82) (133.82) GL 184 10/27/2014 10/1/14-10/27/14 PCards ATT*BILL PAYMENT 128.82 (5.00) ATT*BILL PAYMENT PC 184 10/27/2014 10/1/14-10/27/14 PCards ATT*BILL PAYMENT 158.76 153.76 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 153.76 153.76 ** 1,920.00 Budgeted 1,766.24 Remaining 8 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 211,829.00 Budgeted 211,829.00 Remaining 0 % Used Account: 122-60035-045-000 Postage 164 10/31/2014 MUD Postage usage/Oct .48 .48 GL _______________ Account: 122-60035-045-000 Postage Totals: .48 .48 ** 100.00 Budgeted 99.52 Remaining 0 % Used Account: 122-60055-045-000 Insurance 191 10/01/2014 Oct TML Ins & Workers Comp 940.09 940.09 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.09 940.09 ** 12,179.00 Budgeted 11,238.91 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 184 10/27/2014 10/1/14-10/27/14 PCards TX COMM ON FIRE PR 1,564.67 1,564.67 TX COMM ON FIRE PR PC 184 10/27/2014 10/1/14-10/27/14 PCards TX COMM ON FIRE PR 87.16 1,651.83 TX COMM ON FIRE PR PC 184 10/27/2014 10/1/14-10/27/14 PCards DSHS REGULATORY PR 34.00 1,685.83 DSHS REGULATORY PR PC 184 10/27/2014 10/1/14-10/27/14 PCards NFPA NATL FIRE PROTECT 165.00 1,850.83 NFPA NATL FIRE PROTECT PC 254 10/31/2014 Oct A/P Membership dues 2014-2015 5,209.02 7,059.85 NORTH EAST FIRE DEPT ASSOC 34357 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 7,059.85 7,059.85 ** 15,180.00 Budgeted 8,120.15 Remaining 47 % Used Account: 122-60080-045-000 Schools & Training 254 10/31/2014 Oct A/P Basic Fire Inspector 85.00 85.00 TX COMM ON FIRE PROTECTION 34367 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 85.00 ** 4,280.00 Budgeted 4,195.00 Remaining 2 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,400.00 Budgeted 1,400.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem .00 .00 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 .00 ** 13,577.00 Budgeted 13,577.00 Remaining 0 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60125-045-000 Advertising .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 5,100.00 Budgeted 5,100.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 184 10/27/2014 10/1/14-10/27/14 PCards FASTSIGNS 86.69 86.69 FASTSIGNS PC 184 10/27/2014 10/1/14-10/27/14 PCards FOX RENTAL 75.00 161.69 FOX RENTAL PC 184 10/27/2014 10/1/14-10/27/14 PCards RANDALLS STORE00017897 5.00 166.69 RANDALLS STORE00017897 PC 184 10/27/2014 10/1/14-10/27/14 PCards SUBWAY 03217791 76.00 242.69 SUBWAY 03217791 PC 184 10/27/2014 10/1/14-10/27/14 PCards WM SUPERCENTER #266 15.91 258.60 WM SUPERCENTER #266 PC 184 10/27/2014 10/1/14-10/27/14 PCards AMAZON MKTPLACE PMTS 19.70 278.30 AMAZON MKTPLACE PMTS PC 184 10/27/2014 10/1/14-10/27/14 PCards AMAZON MKTPLACE PMTS 36.34 314.64 AMAZON MKTPLACE PMTS PC 184 10/27/2014 10/1/14-10/27/14 PCards FIRESMARTPROMOS.COM 174.99 489.63 FIRESMARTPROMOS.COM PC 254 10/31/2014 Oct A/P Purchases 10.79 500.42 COSTCO WHOLESALE 34344 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 500.42 500.42 ** 4,500.00 Budgeted 3,999.58 Remaining 11 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement .00 .00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60195-045-000 Flags & Repair 254 10/31/2014 Oct A/P Nevill, Symonds, SHI 137.10 137.10 TOWN OF TROPHY CLUB 34364 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 137.10 137.10 ** 2,000.00 Budgeted 1,862.90 Remaining 7 % Used Account: 122-60245-045-000 Miscellaneous Expense .00 .00 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65005-045-000 Fuel & Lube . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 95 10/21/2014 Oct A/P Diesel for FD & MUD Bldg Gener 397.91 397.91 RICOCHET FUEL DISTRIBUTORS,INC 34301 AP 246 10/31/2014 Oct Gaslog 614.03 1,011.94 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 1,011.94 1,011.94 ** 10,454.00 Budgeted 9,442.06 Remaining 10 % Used Account: 122-65010-045-000 Uniforms .00 .00 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 5,200.00 Budgeted 5,200.00 Remaining 0 % 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 .00 .00 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-65105-045-000 Printing 254 10/31/2014 Oct A/P Monthly water billing, Fire ne 38.17 38.17 DATAPROSE LLC 34346 AP _______________ Account: 122-65105-045-000 Printing Totals: 38.17 38.17 ** 548.00 Budgeted 509.83 Remaining 7 % Used Account: 122-69005-045-000 Capital Outlays 103 10/23/2014 Oct A/P Down payment/Fire Truck 250,000.00 250,000.00 Oshkosh Capital 34308 AP _______________ Account: 122-69005-045-000 Capital Outlays Totals: 250,000.00 250,000.00 ** .00 Budgeted (250,000.00) Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 158,262.00 Budgeted 158,262.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt-Interest .00 .00 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ 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 123 10/01/2014 GASB54 Transfers FY2015 Fire Truck Future replacement 17,950.00 17,950.00 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 17,950.00 17,950.00 ** 17,950.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 20,400.00 Budgeted 20,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 316,351.50 ** 1,383,940.00 Budgeted 1,067,588.50 Remaining 23 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 169,133.74 .00 Budgeted (169,133.74) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET OCTOBER 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 10/31/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 402,061 - - 402,061 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,505,070 - - 1,505,070 INVESTMENTS-TEXPOOL 511,322 169,600 23,702 704,624 PREPAID EXPENSES 75,134 - - 75,134 ADVALOREM PROPERTY TAXES RECEIVABLE 166,593 - - 166,593 UTILITY AND OTHER ACCOUNTS RECEIVABLE 797,696 - - 797,696 - TOTAL ASSETS 3,458,476 169,600 23,702 3,651,778 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 166,593 - - 166,593 ACCOUNTS AND OTHER PAYABLES 587,601 - 13,431 601,032 CUSTOMER DEPOSITS 299,937 - - 299,937 - TOTAL LIABILITIES 1,054,131 - 13,431 1,067,562 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 260,697 260,697 NON-SPENDABLE FUND BALANCE 13,980 13,980 ASSIGNED FUND BALANCE - 10,268 10,268 UNASSIGNED FUND BALANCE 2,004,959 - - 2,004,959 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES 385,406 (91,097) 3 294,312 - TOTAL FUND BALANCE 2,404,345 169,600 10,271 2,584,216 - TOTAL LIABILITIES AND FUND BALANCE 3,458,476 169,600 23,702 3,651,778 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2014 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- 2,320.19- 2,320.19- 1.382 165,536.81- 135-40002-000-000 Property Taxes/Delinquent 307.58- 307.58- 307.58 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 80.45- 80.45- 8.939 819.55- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 133,997.00- Subtotal: 302,754.00- 302,754.00- 2,708.22- 2,708.22- .895 300,045.78- 135-47000-000-000 Water 5,286,045.00- 5,286,045.00- 406,407.33- 406,407.33- 7.688 4,879,637.67- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 215,138.45- 215,138.45- 9.473 2,055,843.55- 135-47025-000-000 Penalties 63,416.00- 63,416.00- 9,480.95- 9,480.95- 14.950 53,935.05- 135-47030-000-000 Service Charges 8,000.00- 8,000.00- 1,203.00- 1,203.00- 15.038 6,797.00- 135-47031-000-000 PID Surcharge Revenue 11,347.50- 11,347.50- 11,347.50 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 300.00- 300.00- 15.000 1,700.00- 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 900.00- 900.00- 18.000 4,100.00- 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 7,157.50- 7,157.50- 8.245 79,657.50- Subtotal: 7,722,258.00- 7,722,258.00- 651,934.73- 651,934.73- 8.442 7,070,323.27- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 20,700.00- 20,700.00- 11.250 163,300.00- Subtotal: 184,000.00- 184,000.00- 20,700.00- 20,700.00- 11.250 163,300.00- 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 522.42- 522.42- 10.448 4,477.58- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 910.53- 8.958 9,253.47- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67- 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- 74,706.00- 100.000 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 5,015.57- 5,015.57- 5.971 78,984.43- 135-49900-000-000 Miscellaneous Income 54,000.00- 54,000.00- 24.16- 24.16- .045 53,975.84- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 2.00- 2.00- 2.000 98.00- Subtotal: 235,321.00- 235,321.00- 81,764.01- 81,764.01- 34.746 153,556.99- Program number: 8,444,333.00- 8,444,333.00- 757,106.96- 757,106.96- 8.966 7,687,226.04- Department number: Revenues 8,444,333.00- 8,444,333.00- 757,106.96- 757,106.96- 8.966 7,687,226.04- Revenues Subtotal ----------- 8,444,333.00- 8,444,333.00- 757,106.96- 757,106.96- 8.966 7,687,226.04- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 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 15,277.93 15,277.93 5.074 285,823.07 135-50010-010-000 Overtime 19,500.00 19,500.00 1,520.08 1,520.08 7.795 17,979.92 135-50016-010-000 Longevity 5,343.00 5,343.00 5,343.00 135-50017-010-000 Certification 4,800.00 4,800.00 400.00 400.00 8.333 4,400.00 135-50020-010-000 Retirement 29,349.00 29,349.00 1,544.39 1,544.39 5.262 27,804.61 135-50026-010-000 Medical Insurance 44,988.00 44,988.00 2,246.98 2,246.98 4.995 42,741.02 135-50027-010-000 Dental Insurance 3,288.00 3,288.00 158.46 158.46 4.819 3,129.54 135-50028-010-000 Vision Insurance 834.00 834.00 40.02 40.02 4.799 793.98 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 189.31 189.31 6.158 2,884.69 135-50030-010-000 Social Security Taxes 21,135.00 21,135.00 1,055.35 1,055.35 4.993 20,079.65 135-50035-010-000 Medicare Taxes 4,943.00 4,943.00 246.82 246.82 4.993 4,696.18 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 1,242.00 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 857.91 857.91 5.355 15,162.09 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,000.00 63.00 63.00 6.300 937.00 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 456,917.00 456,917.00 23,600.25 23,600.25 5.165 433,316.75 135-55005-010-000 Engineering 10,000.00 10,000.00 10,000.00 135-55080-010-000 Maintenance & Repairs 71,242.00 71,242.00 6,148.64 6,148.64 8.631 65,093.36 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 1,771.93 1,771.93 22.149 6,228.07 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 243.00 243.00 6.943 3,257.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 420.26 420.26 7.641 5,079.74 Subtotal: 98,242.00 98,242.00 8,583.83 8,583.83 8.737 89,658.17 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 4,913.00 135-60020-010-000 Electricity 170,765.00 170,765.00 9,297.74 9,297.74 5.445 161,467.26 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 4,138.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 49,275.00 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 2,928,308.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 324.00 324.00 9.257 3,176.00 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 9,621.74 9,621.74 .304 3,159,627.26 135-65005-010-000 Fuel & Lube 29,172.00 29,172.00 1,526.07 1,526.07 5.231 27,645.93 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 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 3,620.00 135-65030-010-000 Chemicals 7,000.00 7,000.00 1,576.30 1,576.30 22.519 5,423.70 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 141.75 141.75 14.175 858.25 135-65050-010-000 Meter Expense 161,500.00 161,500.00 161,500.00 Subtotal: 203,492.00 203,492.00 3,244.12 3,244.12 1.594 200,247.88 135-69005-010-000 Capital Outlays 1,089,006.00 1,089,006.00 1,089,006.00 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 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 151,507.00 151,507.00 151,507.00 Subtotal: 1,448,125.00 1,448,125.00 75,000.00 75,000.00 5.179 1,373,125.00 Program number: 5,376,025.00 5,376,025.00 120,049.94 120,049.94 2.233 5,255,975.06 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2014 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 1,777.63 1,777.63 35.553 3,222.37 Subtotal: 5,000.00 5,000.00 1,777.63 1,777.63 35.553 3,222.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 1,777.63 1,777.63 17.776 8,222.37 Department number: Water 5,386,025.00 5,386,025.00 121,827.57 121,827.57 2.262 5,264,197.43 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 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 14,791.74 14,791.74 4.838 290,952.26 135-50010-020-000 Overtime 19,500.00 19,500.00 1,006.68 1,006.68 5.162 18,493.32 135-50016-020-000 Longevity 5,617.00 5,617.00 5,617.00 135-50017-020-000 Certification 6,600.00 6,600.00 550.00 550.00 8.333 6,050.00 135-50020-020-000 Retirement 29,948.00 29,948.00 1,468.07 1,468.07 4.902 28,479.93 135-50026-020-000 Medical Insurance 61,001.00 61,001.00 3,177.49 3,177.49 5.209 57,823.51 135-50027-020-000 Dental Insurance 4,146.00 4,146.00 203.52 203.52 4.909 3,942.48 135-50028-020-000 Vision Insurance 990.00 990.00 48.57 48.57 4.906 941.43 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 262.04 262.04 8.204 2,931.96 135-50030-020-000 Social Security Taxes 21,680.00 21,680.00 878.03 878.03 4.050 20,801.97 135-50035-020-000 Medicare Taxes 5,070.00 5,070.00 205.35 205.35 4.050 4,864.65 135-50040-020-000 Unemployment Taxes 1,242.00 1,242.00 1,242.00 135-50045-020-000 Workman's Compensation 16,020.00 16,020.00 857.91 857.91 5.355 15,162.09 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 150.00 135-50070-020-000 Employee Relations 550.00 550.00 550.00 Subtotal: 481,452.00 481,452.00 23,449.40 23,449.40 4.871 458,002.60 135-55080-020-000 Maintenance & Repairs 58,000.00 58,000.00 1,769.00 1,769.00 3.050 56,231.00 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 3,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 7.29 7.29 1.458 492.71 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 1,838.97 1,838.97 3.344 53,161.03 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 668.00 668.00 2.672 24,332.00 Subtotal: 141,500.00 141,500.00 4,283.26 4,283.26 3.027 137,216.74 135-60010-020-000 Communications/Pagers/Mobiles 4,662.00 4,662.00 4,662.00 135-60020-020-000 Electricity 149,292.00 149,292.00 4,736.35 4,736.35 3.173 144,555.65 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 54.95 54.95 13.738 345.05 135-60070-020-000 Dues & Memberships 250.00 250.00 250.00 135-60080-020-000 Schools & Training 4,065.00 4,065.00 111.00 111.00 2.731 3,954.00 135-60090-020-000 Safety Program 550.00 550.00 550.00 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 1,600.00 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 8,919.00 52.006 8,231.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 13,821.30 13,821.30 7.361 173,947.70 135-65005-020-000 Fuel & Lube 36,328.00 36,328.00 2,849.07 2,849.07 7.843 33,478.93 135-65010-020-000 Uniforms 2,778.00 2,778.00 1,394.67 1,394.67 50.204 1,383.33 135-65030-020-000 Chemicals 30,000.00 30,000.00 30,000.00 135-65035-020-000 Small Tools 2,000.00 2,000.00 299.51 299.51 14.976 1,700.49 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65040-020-000 Safety Equipment 750.00 750.00 750.00 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 5,102.81 5,102.81 39.252 7,897.19 Subtotal: 84,856.00 84,856.00 9,646.06 9,646.06 11.368 75,209.94 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 150,000.00 135-69007-020-000 LTD Payment from WW Sales 357,538.00 357,538.00 357,538.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 566,540.00 566,540.00 Program number: 1,462,117.00 1,462,117.00 51,200.02 51,200.02 3.502 1,410,916.98 Department number: Wastewater 1,462,117.00 1,462,117.00 51,200.02 51,200.02 3.502 1,410,916.98 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2014 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 10,000.00 135-50030-026-000 Social Security Taxes 620.00 620.00 620.00 135-50035-026-000 Medicare Taxes 145.00 145.00 145.00 135-50040-026-000 Unemployment Taxes 230.00 230.00 230.00 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 2.94 8.167 33.06 Subtotal: 11,031.00 11,031.00 2.94 2.94 .027 11,028.06 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 Subtotal: 11,850.00 11,850.00 11,850.00 Program number: 22,881.00 22,881.00 2.94 2.94 .013 22,878.06 Department number: Board of Directors 22,881.00 22,881.00 2.94 2.94 .013 22,878.06 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 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 22,907.31 22,907.31 4.797 454,670.69 135-50010-030-000 Overtime 1,000.00 1,000.00 6.98 6.98 .698 993.02 135-50016-030-000 Longevity 3,283.00 3,283.00 3,283.00 135-50020-030-000 Retirement 42,840.00 42,840.00 2,057.71 2,057.71 4.803 40,782.29 135-50026-030-000 Medical Insurance 65,015.00 65,015.00 3,328.88 3,328.88 5.120 61,686.12 135-50027-030-000 Dental Insurance 4,944.00 4,944.00 232.72 232.72 4.707 4,711.28 135-50028-030-000 Vision Insurance 1,158.00 1,158.00 56.21 56.21 4.854 1,101.79 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 324.70 324.70 7.494 4,008.30 135-50030-030-000 Social Security Taxes 30,079.00 30,079.00 1,337.80 1,337.80 4.448 28,741.20 135-50035-030-000 Medicare Taxes 7,422.00 7,422.00 312.87 312.87 4.215 7,109.13 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 31.15 31.15 2.150 1,417.85 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 87.30 5.336 1,548.70 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 38.00 38.00 7.600 462.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 635.98 635.98 12.720 4,364.02 Subtotal: 646,237.00 646,237.00 31,357.61 31,357.61 4.852 614,879.39 135-55030-030-000 Software & Support 75,588.00 75,588.00 19,332.63 19,332.63 25.576 56,255.37 135-55070-030-000 Independent Labor 8,000.00 8,000.00 60.00 60.00 .750 7,940.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 773.73 773.73 11.904 5,726.27 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 8,100.00 135-55160-030-000 Professional Outside Services 58,000.00 58,000.00 24,677.95 24,677.95 42.548 33,322.05 135-55161-030-000 Town Personnel Contract 6,170.00 6,170.00 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 584.60 584.60 7.129 7,615.40 Subtotal: 175,258.00 175,258.00 45,428.91 45,428.91 25.921 129,829.09 135-60005-030-000 Telephone 13,361.00 13,361.00 195.00 195.00 1.459 13,166.00 135-60010-030-000 Communications/Pagers/Mobiles 4,056.00 4,056.00 300.00 300.00 7.396 3,756.00 135-60020-030-000 Electricity/Gas 14,978.00 14,978.00 14,978.00 135-60025-030-000 Water 1,500.00 1,500.00 91.81 91.81 6.121 1,408.19 135-60035-030-000 Postage 28,500.00 28,500.00 2,439.31 2,439.31 8.559 26,060.69 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 40.00 40.00 .125 31,960.00 135-60050-030-000 Bad Debt Expense 6,200.00 6,200.00 6,200.00 135-60055-030-000 Insurance 48,751.00 48,751.00 4,063.01 4,063.01 8.334 44,687.99 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 5,000.00 5,000.00 5,000.00 135-60075-030-000 Meetings 400.00 400.00 25.11 25.11 6.278 374.89 135-60079-030-000 Public Education 5,000.00 5,000.00 5,000.00 135-60080-030-000 Schools & Training 10,235.00 10,235.00 70.00 70.00 .684 10,165.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 90.11 90.11 1.669 5,309.89 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 17,500.00 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 4,373.16 4,373.16 41.749 6,101.84 Subtotal: 218,406.00 218,406.00 11,687.51 11,687.51 5.351 206,718.49 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,855.00 135-65055-030-000 Hardware 75,966.00 75,966.00 82,651.57 82,651.57 108.801 6,685.57- 135-65085-030-000 Office Supplies 9,000.00 9,000.00 573.19 573.19 6.369 8,426.81 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 52.10 52.10 1.101 4,679.90 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 269.93 269.93 5.399 4,730.07 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 101,553.00 83,546.79 83,546.79 82.269 18,006.21 135-69005-030-000 Capital Outlays 125,000.00 125,000.00 125,000.00 135-69170-030-000 Copier Lease Installments 4,236.00 4,236.00 40.79 40.79 .963 4,195.21 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 16,329.00 16,329.00 16,329.00 100.000 Subtotal: 145,565.00 145,565.00 16,369.79 16,369.79 11.246 129,195.21 Program number: 1,287,019.00 1,287,019.00 188,390.61 188,390.61 14.638 1,098,628.39 Department number: Administration 1,287,019.00 1,287,019.00 188,390.61 188,390.61 14.638 1,098,628.39 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 250,000.00 250,000.00 250,000.00 135-55055-039-000 Auditing 22,491.00 22,491.00 22,491.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 10,000.00 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 286,291.00 286,291.00 286,291.00 Program number: 286,291.00 286,291.00 286,291.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 17:00 11/12/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: 3 WWTP Bonds Period Ending: 10/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-003 Legal/WWTP Bonds 10,279.77 10,279.77 10,279.77- Subtotal: 10,279.77 10,279.77 10,279.77- Program number: 3 WWTP Bonds 10,279.77 10,279.77 10,279.77- Department number: Non Departmental 286,291.00 286,291.00 10,279.77 10,279.77 3.591 276,011.23 Expenditures Subtotal ----------- 8,444,333.00 8,444,333.00 371,700.91 371,700.91 4.402 8,072,632.09 Fund number: 135 MUD 1 General Fund 385,406.05- 385,406.05- 385,406.05 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 17:00 11/12/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 10/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 2.53- 2.53- 2.53 Subtotal: 2.53- 2.53- 2.53 Program number: 2.53- 2.53- 2.53 Department number: 2.53- 2.53- 2.53 Revenues Subtotal ----------- 2.53- 2.53- 2.53 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 17:00 11/12/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 10/2014 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 3,348.00 Subtotal: 3,348.00 3,348.00 3,348.00 Program number: 3 Indian Creek Waterline 3,348.00 3,348.00 3,348.00 Department number: Water 3,348.00 3,348.00 3,348.00 Expenditures Subtotal ----------- 3,348.00 3,348.00 3,348.00 Fund number: 507 MUD 1 Capital Projects 3,348.00 3,348.00 2.53- 2.53- -.076 3,350.53 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2014 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 220 10/06/2014 Property Taxes/Assessments (3.43) (3.43) GL 222 10/10/2014 Property Taxes/Assessments (26.75) (30.18) GL 223 10/13/2014 Property Taxes/Assessments (69.20) (99.38) GL 224 10/14/2014 Property Taxes/Assessments (97.60) (196.98) GL 225 10/15/2014 Property Taxes/Assessments (37.05) (234.03) GL 226 10/16/2014 Property Taxes/Assessments (31.14) (265.17) GL 227 10/20/2014 Property Taxes/Assessments (40.37) (305.54) GL 229 10/21/2014 Property Taxes/Assessments (29.75) (335.29) GL 230 10/22/2014 Property Taxes/Assessments (66.57) (401.86) GL 231 10/23/2014 Property Taxes/Assessments (152.10) (553.96) GL 232 10/24/2014 Property Taxes/Assessments (185.20) (739.16) GL 233 10/27/2014 Property Taxes/Assessments (182.92) (922.08) GL 234 10/28/2014 Property Taxes/Assessments (489.22) (1,411.30) GL 235 10/29/2014 Property Taxes/Assessments (338.29) (1,749.59) GL 236 10/30/2014 Property Taxes/Assessments (197.86) (1,947.45) GL 237 10/31/2014 Property Taxes/Assessments (372.74) (2,320.19) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (2,320.19) (2,320.19) ** (167,857.00) Budgeted (165,536.81) Remaining 1 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 219 10/07/2014 Property Taxes/Assessments .70 .70 GL 224 10/14/2014 Property Taxes/Assessments (17.10) (16.40) GL 225 10/15/2014 Property Taxes/Assessments (3.07) (19.47) GL 226 10/16/2014 Property Taxes/Assessments (.68) (20.15) GL 227 10/20/2014 Property Taxes/Assessments (264.30) (284.45) GL 231 10/23/2014 Property Taxes/Assessments (19.43) (303.88) GL 234 10/28/2014 Property Taxes/Assessments (2.58) (306.46) GL 235 10/29/2014 Property Taxes/Assessments (1.11) (307.57) GL 236 10/30/2014 Property Taxes/Assessments (.01) (307.58) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (307.58) (307.58) ** .00 Budgeted 307.58 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 224 10/14/2014 Property Taxes/Assessments (3.59) (3.59) GL 225 10/15/2014 Property Taxes/Assessments (1.02) (4.61) GL 226 10/16/2014 Property Taxes/Assessments (.22) (4.83) GL 227 10/20/2014 Property Taxes/Assessments (55.50) (60.33) GL 231 10/23/2014 Property Taxes/Assessments (4.08) (64.41) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 234 10/28/2014 Property Taxes/Assessments (.48) (64.89) GL 235 10/29/2014 Property Taxes/Assessments (.23) (65.12) GL 237 10/31/2014 Property Taxes/Assessments (15.33) (80.45) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (80.45) (80.45) ** (900.00) Budgeted (819.55) Remaining 9 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (133,997.00) Budgeted (133,997.00) Remaining 0 % Used Account: 135-47000-000-000 Water 142 10/06/2014 UB 10/6/14 Meter misread UB20141006-20141006 User: 189.54 189.54 UB 143 10/07/2014 UB 10/7/14 Meter misread UB20141007-20141007 User: 217.94 407.48 UB 148 10/10/2014 UB 10/10/14 Adjustment UB20141010-20141010 User: (3,669.29) (3,261.81) UB 154 10/15/2014 UB 10/15/14 Meter misread UB20141015-20141015 User: 468.35 (2,793.46) UB 152 10/24/2014 UB 10/24/14 Adj UB20141024-20141024 User: (1,000.00) (3,793.46) UB 170 10/31/2014 UB 10/31/14 Billing UB20141031-20141031 User: (402,613.87) (406,407.33) UB _______________ Account: 135-47000-000-000 Water Totals: (406,407.33) (406,407.33) ** (5,286,045.00) Budgeted (4,879,637.67) Remaining 8 % Used Account: 135-47005-000-000 Sewer 142 10/06/2014 UB 10/6/14 Meter misread UB20141006-20141006 User: 35.00 35.00 UB 143 10/07/2014 UB 10/7/14 Meter misread UB20141007-20141007 User: 10.00 45.00 UB 154 10/15/2014 UB 10/15/14 Meter misread UB20141015-20141015 User: 10.00 55.00 UB 170 10/31/2014 UB 10/31/14 Billing UB20141031-20141031 User: (215,193.45) (215,138.45) UB _______________ Account: 135-47005-000-000 Sewer Totals: (215,138.45) (215,138.45) ** (2,270,982.00) Budgeted (2,055,843.55) Remaining 9 % Used Account: 135-47025-000-000 Penalties 89 10/21/2014 UB 10/21/14 Penalties UB20141021-20141021 User: (9,872.78) (9,872.78) UB 152 10/24/2014 UB 10/24/14 Adj UB20141024-20141024 User: 135.39 (9,737.39) UB 176 10/27/2014 UB 10/27/14 Penalty adjustment UB20141027-20141027 User: 256.44 (9,480.95) UB _______________ Account: 135-47025-000-000 Penalties Totals: (9,480.95) (9,480.95) ** (63,416.00) Budgeted (53,935.05) Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 27 10/08/2014 UB 10/8/14 CUt off Fees UB20141008-20141008 User: (925.00) (925.00) UB 144 10/08/2014 UB 10/8/14 After hours fee UB20141008-20141008 User: (200.00) (1,125.00) UB 146 10/09/2014 UB 10/9/14 NSF check fee UB20141009-20141009 User: (50.00) (1,175.00) UB 165 10/22/2014 UB 10/22/14 NSF ck fee UB20141022-20141022 User: (25.00) (1,200.00) UB 170 10/31/2014 UB 10/31/14 Billing UB20141031-20141031 User: (3.00) (1,203.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,203.00) (1,203.00) ** (8,000.00) Budgeted (6,797.00) Remaining 15 % Used Account: 135-47031-000-000 PID Surcharge Revenue 170 10/31/2014 UB 10/31/14 Billing UB20141031-20141031 User: (11,347.50) (11,347.50) UB _______________ Account: 135-47031-000-000 PID Surcharge Revenue Totals: (11,347.50) (11,347.50) ** .00 Budgeted 11,347.50 Remaining 0 % Used Account: 135-47035-000-000 Plumbing Inspections 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (300.00) (300.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (300.00) (300.00) ** (2,000.00) Budgeted (1,700.00) Remaining 15 % Used Account: 135-47045-000-000 Sewer Inspections 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (900.00) (900.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (900.00) (900.00) ** (5,000.00) Budgeted (4,100.00) Remaining 18 % Used Account: 135-47070-000-000 TCCC Effluent Charges 170 10/31/2014 UB 10/31/14 Billing UB20141031-20141031 User: (7,157.50) (7,157.50) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (7,157.50) (7,157.50) ** (86,815.00) Budgeted (79,657.50) Remaining 8 % Used Account: 135-48005-000-000 Utility Fees 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (20,700.00) (20,700.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (20,700.00) (20,700.00) ** (184,000.00) Budgeted (163,300.00) Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49010-000-000 Interest Income 181 10/31/2014 Bank Interest/October (87.97) (87.97) GL 181 10/31/2014 Bank Interest/October (408.94) (496.91) GL 181 10/31/2014 Bank Interest/October (25.51) (522.42) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (522.42) (522.42) ** (5,000.00) Budgeted (4,477.58) Remaining 10 % Used Account: 135-49016-000-000 Cell Tower Revenue 215 10/14/2014 AT&T Antenna Lease (910.53) (910.53) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (910.53) ** (10,164.00) Budgeted (9,253.47) Remaining 9 % Used Account: 135-49018-000-000 Building Rent Income 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (583.33) (583.33) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (583.33) ** (7,000.00) Budgeted (6,416.67) Remaining 8 % Used Account: 135-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 123 10/01/2014 GASB54 Transfers FY2015 Scheduled Computer replacement (74,706.00) (74,706.00) GL _______________ Account: 135-49036-000-000 GASB Reserves Totals: (74,706.00) (74,706.00) ** (74,706.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (5,015.57) (5,015.57) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,015.57) (5,015.57) ** (84,000.00) Budgeted (78,984.43) Remaining 6 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49900-000-000 Miscellaneous Income 170 10/31/2014 UB 10/31/14 Billing UB20141031-20141031 User: (24.16) (24.16) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (24.16) (24.16) ** (54,000.00) Budgeted (53,975.84) Remaining 0 % Used Account: 135-49901-000-000 Records Management Revenue 213 10/06/2014 Open Records/Rose (2.00) (2.00) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (2.00) (2.00) ** (100.00) Budgeted (98.00) Remaining 2 % Used Department Totals: ------------------------------------------------------------------------------------------------ (757,106.96) ** (8,444,333.00) Budgeted (7,687,226.04) Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 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 26 10/04/2014 MUD Payroll 10/4/14 Salaries & Wages 8,468.84 8,468.84 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (5,934.76) 2,534.08 GL 85 10/24/2014 MUD Payroll 10/24/14 Salaries & Wages 8,568.48 11,102.56 PR 127 10/29/2014 Supplemental Payroll Salaries & Wages 1,485.03 12,587.59 PR 134 10/30/2014 Supplemental Payroll Salaries & Wages 2,690.34 15,277.93 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 15,277.93 15,277.93 ** 301,101.00 Budgeted 285,823.07 Remaining 5 % Used Account: 135-50010-010-000 Overtime 26 10/04/2014 MUD Payroll 10/4/14 Overtime 1,374.15 1,374.15 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (823.95) 550.20 GL 85 10/24/2014 MUD Payroll 10/24/14 Overtime 812.85 1,363.05 PR 134 10/30/2014 Supplemental Payroll Overtime 157.03 1,520.08 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,520.08 1,520.08 ** 19,500.00 Budgeted 17,979.92 Remaining 8 % Used Account: 135-50016-010-000 Longevity .00 .00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 .00 ** 5,343.00 Budgeted 5,343.00 Remaining 0 % Used Account: 135-50017-010-000 Certification 85 10/24/2014 MUD Payroll 10/24/14 Certification 375.00 375.00 PR 127 10/29/2014 Supplemental Payroll Certification 25.00 400.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 400.00 400.00 ** 4,800.00 Budgeted 4,400.00 Remaining 8 % Used Account: 135-50020-010-000 Retirement 26 10/04/2014 MUD Payroll 10/4/14 Retirement 883.90 883.90 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (606.92) 276.98 GL 85 10/24/2014 MUD Payroll 10/24/14 Retirement 876.11 1,153.09 PR 127 10/29/2014 Supplemental Payroll Retirement 135.60 1,288.69 PR 134 10/30/2014 Supplemental Payroll Retirement 255.70 1,544.39 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50020-010-000 Retirement Totals: 1,544.39 1,544.39 ** 29,349.00 Budgeted 27,804.61 Remaining 5 % Used Account: 135-50026-010-000 Medical Insurance 26 10/04/2014 MUD Payroll 10/4/14 Medical Insurance 1,483.35 1,483.35 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (1,016.33) 467.02 GL 85 10/24/2014 MUD Payroll 10/24/14 Medical Insurance 1,483.30 1,950.32 PR 127 10/29/2014 Supplemental Payroll Medical Insurance 296.66 2,246.98 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,246.98 2,246.98 ** 44,988.00 Budgeted 42,741.02 Remaining 5 % Used Account: 135-50027-010-000 Dental Insurance 26 10/04/2014 MUD Payroll 10/4/14 Dental Insurance 108.17 108.17 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (74.29) 33.88 GL 85 10/24/2014 MUD Payroll 10/24/14 Dental Insurance 108.20 142.08 PR 127 10/29/2014 Supplemental Payroll Dental Insurance 16.38 158.46 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 158.46 158.46 ** 3,288.00 Budgeted 3,129.54 Remaining 5 % Used Account: 135-50028-010-000 Vision Insurance 26 10/04/2014 MUD Payroll 10/4/14 Vision Insurance 26.97 26.97 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (18.49) 8.48 GL 85 10/24/2014 MUD Payroll 10/24/14 Vision Insurance 27.01 35.49 PR 127 10/29/2014 Supplemental Payroll Vision Insurance 4.53 40.02 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 40.02 40.02 ** 834.00 Budgeted 793.98 Remaining 5 % Used Account: 135-50029-010-000 Life Insurance & Other 2 10/01/2014 Oct A/P Oct Dental, Life, AD&D, Vision 174.03 174.03 METLIFE 34207 AP 95 10/21/2014 Oct A/P Adm Fees 15.28 189.31 BenefitMall 34280 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 189.31 189.31 ** 3,074.00 Budgeted 2,884.69 Remaining 6 % Used Account: 135-50030-010-000 Social Security Taxes . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 26 10/04/2014 MUD Payroll 10/4/14 Social Security Taxes 605.50 605.50 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (415.77) 189.73 GL 85 10/24/2014 MUD Payroll 10/24/14 Social Security Taxes 594.16 783.89 PR 127 10/29/2014 Supplemental Payroll Social Security Taxes 93.62 877.51 PR 134 10/30/2014 Supplemental Payroll Social Security Taxes 177.84 1,055.35 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,055.35 1,055.35 ** 21,135.00 Budgeted 20,079.65 Remaining 5 % Used Account: 135-50035-010-000 Medicare Taxes 26 10/04/2014 MUD Payroll 10/4/14 Medicare Taxes 141.62 141.62 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (97.23) 44.39 GL 85 10/24/2014 MUD Payroll 10/24/14 Medicare Taxes 138.94 183.33 PR 127 10/29/2014 Supplemental Payroll Medicare Taxes 21.90 205.23 PR 134 10/30/2014 Supplemental Payroll Medicare Taxes 41.59 246.82 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 246.82 246.82 ** 4,943.00 Budgeted 4,696.18 Remaining 5 % Used Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 1,242.00 Budgeted 1,242.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 191 10/01/2014 Oct TML Ins & Workers Comp 857.91 857.91 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.91 857.91 ** 16,020.00 Budgeted 15,162.09 Remaining 5 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 161 10/31/2014 Oct A/P Testing 63.00 63.00 CARENOW CORPORATE 34314 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 63.00 63.00 ** 1,000.00 Budgeted 937.00 Remaining 6 % Used Account: 135-50070-010-000 Employee Relations . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 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-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 95 10/21/2014 Oct A/P Couble Check parts 199.86 199.86 MACARTHUR GAUGE INC 34294 AP 95 10/21/2014 Oct A/P Single meter lids 301.20 501.06 HD SUPPLY WATERWORKS, LTD. 34288 AP 95 10/21/2014 Oct A/P (2) 5x15 Clamps 262.10 763.16 HD SUPPLY WATERWORKS, LTD. 34288 AP 95 10/21/2014 Oct A/P (2) 6x15 Clamps 262.10 1,025.26 HD SUPPLY WATERWORKS, LTD. 34288 AP 184 10/27/2014 10/1/14-10/27/14 PCards IN *HOSE TECH 4.36 1,029.62 IN *HOSE TECH PC 184 10/27/2014 10/1/14-10/27/14 PCards THE HOME DEPOT 6581 39.21 1,068.83 THE HOME DEPOT 6581 PC 184 10/27/2014 10/1/14-10/27/14 PCards ROANOKE AUTO SUPPLY LT 55.31 1,124.14 ROANOKE AUTO SUPPLY LT PC 161 10/31/2014 Oct A/P Concrete repair-Pagosa Ct. 265.00 1,389.14 LATTIMORE MATERIALS CO 34322 AP 161 10/31/2014 Oct A/P 2" Angle stops 530.00 1,919.14 HD SUPPLY WATERWORKS, LTD. 34319 AP 254 10/31/2014 Oct A/P 12x6 tap slv, fire hydrant, lu 3,410.19 5,329.33 HD SUPPLY WATERWORKS, LTD. 34347 AP 254 10/31/2014 Oct A/P Bushings, Couplings 599.65 5,928.98 HD SUPPLY WATERWORKS, LTD. 34347 AP 254 10/31/2014 Oct A/P 8" Quantum Couplings 219.66 6,148.64 HD SUPPLY WATERWORKS, LTD. 34347 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 6,148.64 6,148.64 ** 71,242.00 Budgeted 65,093.36 Remaining 9 % Used Account: 135-55090-010-000 Vehicle Maintenance 41 10/09/2014 Oct A/P R&R Instrument Cluster 751.30 751.30 MICHAEL G. WATSON 34246 AP 95 10/21/2014 Oct A/P Unit 103/Transmission 980.88 1,732.18 MICHAEL G. WATSON 34297 AP 184 10/27/2014 10/1/14-10/27/14 PCards KWIK KAR LUBE & TUNE O 39.75 1,771.93 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,771.93 1,771.93 ** 8,000.00 Budgeted 6,228.07 Remaining 22 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 41 10/09/2014 Oct A/P Backhoe tire 243.00 243.00 BLAGG TIRE & SERVICE 34222 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 243.00 243.00 ** 3,500.00 Budgeted 3,257.00 Remaining 7 % Used Account: 135-55135-010-000 Lab Analysis 254 10/31/2014 Oct A/P DBP2 testing 195.26 195.26 LOWER COLORADO RIVER AUTHORITY 34354 AP 254 10/31/2014 Oct A/P Testing 225.00 420.26 TARRANT CTY PUBLIC HEALTH LAB 34362 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 420.26 420.26 ** 5,500.00 Budgeted 5,079.74 Remaining 8 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 4,913.00 Budgeted 4,913.00 Remaining 0 % Used Account: 135-60020-010-000 Electricity 78 10/17/2014 Oct A/P Electricity 9/11-10/10/14 24.03 24.03 HUDSON ENERGY SERVICES, LLC 34289 AP 95 10/21/2014 Oct A/P Electricity 10/1-10/13/14 5,144.88 5,168.91 HUDSON ENERGY SERVICES, LLC 34289 AP 95 10/21/2014 Oct A/P Electricity 10/1-10/13/14 4,128.83 9,297.74 HUDSON ENERGY SERVICES, LLC 34289 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,297.74 9,297.74 ** 170,765.00 Budgeted 161,467.26 Remaining 5 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 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-60080-010-000 Schools & Training Totals: .00 .00 ** 4,138.00 Budgeted 4,138.00 Remaining 0 % 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 .00 .00 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 .00 ** 49,275.00 Budgeted 49,275.00 Remaining 0 % Used Account: 135-60150-010-000 Wholesale Water .00 .00 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 .00 ** 2,928,308.00 Budgeted 2,928,308.00 Remaining 0 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ 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 184 10/27/2014 10/1/14-10/27/14 PCards DENTON SAND & GRAVEL, 108.00 108.00 DENTON SAND & GRAVEL, PC 184 10/27/2014 10/1/14-10/27/14 PCards DENTON SAND & GRAVEL, 108.00 216.00 DENTON SAND & GRAVEL, PC 184 10/27/2014 10/1/14-10/27/14 PCards DENTON SAND & GRAVEL, 108.00 324.00 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 324.00 324.00 ** 3,500.00 Budgeted 3,176.00 Remaining 9 % 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 95 10/21/2014 Oct A/P Diesel for FD & MUD Bldg Gener 21.60 21.60 RICOCHET FUEL DISTRIBUTORS,INC 34301 AP 184 10/27/2014 10/1/14-10/27/14 PCards KWIK KAR LUBE & TUNE O 39.58 61.18 KWIK KAR LUBE & TUNE O PC 161 10/31/2014 Oct A/P 10/10-10/22/14 Fuel purchases 637.80 698.98 US Bank Voyager Fleet Systems 34336 AP 246 10/31/2014 Oct Gaslog 827.09 1,526.07 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,526.07 1,526.07 ** 29,172.00 Budgeted 27,645.93 Remaining 5 % Used Account: 135-65010-010-000 Uniforms .00 .00 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 .00 ** 3,620.00 Budgeted 3,620.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65030-010-000 Chemicals 161 10/31/2014 Oct A/P Chemicals 743.60 743.60 HACH COMPANY 34317 AP 161 10/31/2014 Oct A/P Chlorine 832.70 1,576.30 DPC INDUSTRIES, INC 34315 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,576.30 1,576.30 ** 7,000.00 Budgeted 5,423.70 Remaining 23 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment 161 10/31/2014 Oct A/P Lockout kits 141.75 141.75 HD SUPPLY FACILITIES MAINT LTD 34318 AP _______________ Account: 135-65040-010-000 Safety Equipment Totals: 141.75 141.75 ** 1,000.00 Budgeted 858.25 Remaining 14 % Used Account: 135-65050-010-000 Meter Expense .00 .00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 .00 ** 161,500.00 Budgeted 161,500.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays .00 .00 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 .00 ** 1,089,006.00 Budgeted 1,089,006.00 Remaining 0 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 129,000.00 Budgeted 129,000.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-69009-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 123 10/01/2014 GASB54 Transfers FY2015 Town Elevated Tank 45,000.00 45,000.00 GL 123 10/01/2014 GASB54 Transfers FY2015 Water replacement 30,000.00 75,000.00 GL _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract .00 .00 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 .00 ** 151,507.00 Budgeted 151,507.00 Remaining 0 % Used Account: 135-55135-010-001 Lab Analysis for PID 161 10/31/2014 Oct A/P Lead/Copper testing-PID 1,600.00 1,600.00 LOWER COLORADO RIVER AUTHORITY 34324 AP 254 10/31/2014 Oct A/P DBP2 testing/PID 97.63 1,697.63 LOWER COLORADO RIVER AUTHORITY 34354 AP 254 10/31/2014 Oct A/P Testing/PID 80.00 1,777.63 TARRANT CTY PUBLIC HEALTH LAB 34362 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 1,777.63 1,777.63 ** 5,000.00 Budgeted 3,222.37 Remaining 36 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 121,827.57 ** 5,386,025.00 Budgeted 5,264,197.43 Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 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 26 10/04/2014 MUD Payroll 10/4/14 Salaries & Wages 11,276.69 11,276.69 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (7,895.83) 3,380.86 GL 85 10/24/2014 MUD Payroll 10/24/14 Salaries & Wages 11,410.88 14,791.74 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,791.74 14,791.74 ** 305,744.00 Budgeted 290,952.26 Remaining 5 % Used Account: 135-50010-020-000 Overtime 26 10/04/2014 MUD Payroll 10/4/14 Overtime 578.99 578.99 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (446.73) 132.26 GL 85 10/24/2014 MUD Payroll 10/24/14 Overtime 874.42 1,006.68 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,006.68 1,006.68 ** 19,500.00 Budgeted 18,493.32 Remaining 5 % Used Account: 135-50016-020-000 Longevity .00 .00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 .00 ** 5,617.00 Budgeted 5,617.00 Remaining 0 % Used Account: 135-50017-020-000 Certification 85 10/24/2014 MUD Payroll 10/24/14 Certification 550.00 550.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 550.00 ** 6,600.00 Budgeted 6,050.00 Remaining 8 % Used Account: 135-50020-020-000 Retirement 26 10/04/2014 MUD Payroll 10/4/14 Retirement 1,064.63 1,064.63 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (749.18) 315.45 GL 85 10/24/2014 MUD Payroll 10/24/14 Retirement 1,152.62 1,468.07 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,468.07 1,468.07 ** 29,948.00 Budgeted 28,479.93 Remaining 5 % Used Account: 135-50026-020-000 Medical Insurance 26 10/04/2014 MUD Payroll 10/4/14 Medical Insurance 2,450.25 2,450.25 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (1,722.97) 727.28 GL 85 10/24/2014 MUD Payroll 10/24/14 Medical Insurance 2,450.21 3,177.49 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,177.49 3,177.49 ** 61,001.00 Budgeted 57,823.51 Remaining 5 % Used Account: 135-50027-020-000 Dental Insurance 26 10/04/2014 MUD Payroll 10/4/14 Dental Insurance 156.98 156.98 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (110.46) 46.52 GL 85 10/24/2014 MUD Payroll 10/24/14 Dental Insurance 157.00 203.52 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 203.52 203.52 ** 4,146.00 Budgeted 3,942.48 Remaining 5 % Used Account: 135-50028-020-000 Vision Insurance 26 10/04/2014 MUD Payroll 10/4/14 Vision Insurance 37.45 37.45 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (26.37) 11.08 GL 85 10/24/2014 MUD Payroll 10/24/14 Vision Insurance 37.49 48.57 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 48.57 48.57 ** 990.00 Budgeted 941.43 Remaining 5 % Used Account: 135-50029-020-000 Life Insurance & Other 2 10/01/2014 Oct A/P Oct Dental, Life, AD&D, Vision 231.48 231.48 METLIFE 34207 AP 95 10/21/2014 Oct A/P Adm Fees 30.56 262.04 BenefitMall 34280 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 262.04 262.04 ** 3,194.00 Budgeted 2,931.96 Remaining 8 % Used Account: 135-50030-020-000 Social Security Taxes 26 10/04/2014 MUD Payroll 10/4/14 Social Security Taxes 654.10 654.10 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (463.41) 190.69 GL 85 10/24/2014 MUD Payroll 10/24/14 Social Security Taxes 687.34 878.03 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 878.03 878.03 ** 21,680.00 Budgeted 20,801.97 Remaining 4 % Used Account: 135-50035-020-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 26 10/04/2014 MUD Payroll 10/4/14 Medicare Taxes 152.99 152.99 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (108.40) 44.59 GL 85 10/24/2014 MUD Payroll 10/24/14 Medicare Taxes 160.76 205.35 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 205.35 205.35 ** 5,070.00 Budgeted 4,864.65 Remaining 4 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,242.00 Budgeted 1,242.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 191 10/01/2014 Oct TML Ins & Workers Comp 857.91 857.91 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.91 857.91 ** 16,020.00 Budgeted 15,162.09 Remaining 5 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 184 10/27/2014 10/1/14-10/27/14 PCards UV DOCTOR 350.00 350.00 UV DOCTOR PC 184 10/27/2014 10/1/14-10/27/14 PCards WW GRAINGER 709.50 1,059.50 WW GRAINGER PC 184 10/27/2014 10/1/14-10/27/14 PCards WW GRAINGER 709.50 1,769.00 WW GRAINGER PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 1,769.00 1,769.00 ** 58,000.00 Budgeted 56,231.00 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-020-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 184 10/27/2014 10/1/14-10/27/14 PCards ROANOKE AUTO SUPPLY LT 7.29 7.29 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 7.29 7.29 ** 500.00 Budgeted 492.71 Remaining 1 % Used Account: 135-55125-020-000 Dumpster Services 95 10/21/2014 Oct A/P Sludge Haul off 1,838.97 1,838.97 L.H. CHANEY MATERIALS, INC. 34293 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 1,838.97 1,838.97 ** 55,000.00 Budgeted 53,161.03 Remaining 3 % Used Account: 135-55135-020-000 Lab Analysis 95 10/21/2014 Oct A/P Testing 246.00 246.00 OXIDOR LABORATORIES LLC 34299 AP 95 10/21/2014 Oct A/P Testing 176.00 422.00 OXIDOR LABORATORIES LLC 34299 AP 95 10/21/2014 Oct A/P Testing 246.00 668.00 OXIDOR LABORATORIES LLC 34299 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 668.00 668.00 ** 25,000.00 Budgeted 24,332.00 Remaining 3 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 4,662.00 Budgeted 4,662.00 Remaining 0 % Used Account: 135-60020-020-000 Electricity 78 10/17/2014 Oct A/P Electricity 10/1-10/13/14 225.25 225.25 HUDSON ENERGY SERVICES, LLC 34289 AP 78 10/17/2014 Oct A/P Electricity 10/1-10/10/14 21.08 246.33 HUDSON ENERGY SERVICES, LLC 34289 AP 78 10/17/2014 Oct A/P Electricity 10/1-10/10/14 10.07 256.40 HUDSON ENERGY SERVICES, LLC 34289 AP 78 10/17/2014 Oct A/P Electricity 10/1-10/13/14 34.73 291.13 HUDSON ENERGY SERVICES, LLC 34289 AP 161 10/31/2014 Oct A/P Electricity 10/1-10/13/14 4,533.09 4,824.22 HUDSON ENERGY SERVICES, LLC 34320 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 266 10/31/2014 Recode Maint Barn Electricity 87.87 4,912.09 GL 268 10/31/2014 Rev/Correct Maint Barn elec (87.87) 4,824.22 GL 268 10/31/2014 Rev/Correct Maint Barn elec (87.87) 4,736.35 GL _______________ Account: 135-60020-020-000 Electricity Totals: 4,736.35 4,736.35 ** 149,292.00 Budgeted 144,555.65 Remaining 3 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 95 10/21/2014 Oct A/P WW Treatment Class/Roberts 54.95 54.95 City of Fort Worth 34281 AP _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 54.95 54.95 ** 400.00 Budgeted 345.05 Remaining 14 % 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 184 10/27/2014 10/1/14-10/27/14 PCards TCEQ IND RENEWAL L 111.00 111.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 111.00 111.00 ** 4,065.00 Budgeted 3,954.00 Remaining 3 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60105-020-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 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-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 161 10/31/2014 Oct A/P WW Permit 8,919.00 8,919.00 TX COMMISSION ENVIRONMENTAL QU 34334 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 8,919.00 8,919.00 ** 17,150.00 Budgeted 8,231.00 Remaining 52 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 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 161 10/31/2014 Oct A/P Diesel for WWTP 1,327.41 1,327.41 RICOCHET FUEL DISTRIBUTORS,INC 34329 AP 161 10/31/2014 Oct A/P 10/10-10/22/14 Fuel purchases 265.40 1,592.81 US Bank Voyager Fleet Systems 34336 AP 246 10/31/2014 Oct Gaslog 1,256.26 2,849.07 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 2,849.07 2,849.07 ** 36,328.00 Budgeted 33,478.93 Remaining 8 % Used Account: 135-65010-020-000 Uniforms 184 10/27/2014 10/1/14-10/27/14 PCards RED WING SHOES #652 175.00 175.00 RED WING SHOES #652 PC 184 10/27/2014 10/1/14-10/27/14 PCards WAL-MART #0266 83.85 258.85 WAL-MART #0266 PC 184 10/27/2014 10/1/14-10/27/14 PCards WAL-MART #0266 108.71 367.56 WAL-MART #0266 PC 184 10/27/2014 10/1/14-10/27/14 PCards RED WING SHOES #652 174.24 541.80 RED WING SHOES #652 PC 184 10/27/2014 10/1/14-10/27/14 PCards ACADEMY SPORTS #81 114.95 656.75 ACADEMY SPORTS #81 PC 184 10/27/2014 10/1/14-10/27/14 PCards ACADEMY SPORTS #141 22.99 679.74 ACADEMY SPORTS #141 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 184 10/27/2014 10/1/14-10/27/14 PCards RED WING SHOES #652 175.00 854.74 RED WING SHOES #652 PC 184 10/27/2014 10/1/14-10/27/14 PCards RED WING SHOES #652 175.00 1,029.74 RED WING SHOES #652 PC 184 10/27/2014 10/1/14-10/27/14 PCards ACADEMY SPORTS #81 364.93 1,394.67 ACADEMY SPORTS #81 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 1,394.67 1,394.67 ** 2,778.00 Budgeted 1,383.33 Remaining 50 % Used Account: 135-65030-020-000 Chemicals .00 .00 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-65035-020-000 Small Tools 184 10/27/2014 10/1/14-10/27/14 PCards THE HOME DEPOT 6581 299.51 299.51 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 299.51 299.51 ** 2,000.00 Budgeted 1,700.49 Remaining 15 % Used Account: 135-65040-020-000 Safety Equipment .00 .00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-65045-020-000 Lab Supplies 95 10/21/2014 Oct A/P Sealer Care Agreement 750.00 750.00 IDEXX DISTRIBUTION, INC 34290 AP 184 10/27/2014 10/1/14-10/27/14 PCards HACH COMPANY 803.50 1,553.50 HACH COMPANY PC 184 10/27/2014 10/1/14-10/27/14 PCards IDEXX DISTRIBUTION INC 3,388.72 4,942.22 IDEXX DISTRIBUTION INC PC 184 10/27/2014 10/1/14-10/27/14 PCards IDEXX DISTRIBUTION INC 160.59 5,102.81 IDEXX DISTRIBUTION INC PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 5,102.81 5,102.81 ** 13,000.00 Budgeted 7,897.19 Remaining 39 % Used Account: 135-69005-020-000 Capital Outlays .00 .00 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 .00 ** 150,000.00 Budgeted 150,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 ** 357,538.00 Budgeted 357,538.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: ------------------------------------------------------------------------------------------------ 51,200.02 ** 1,462,117.00 Budgeted 1,410,916.98 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-021-000 Electricity 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (87.87) (87.87) AR 266 10/31/2014 Recode Maint Barn Electricity (87.87) (175.74) GL 268 10/31/2014 Rev/Correct Maint Barn elec 87.87 (87.87) GL 268 10/31/2014 Rev/Correct Maint Barn elec 87.87 .00 GL _______________ Account: 135-60020-021-000 Electricity Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ .00 ** .00 Budgeted .00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2014 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 .00 .00 _______________ Account: 135-50005-026-000 Salaries & Wages Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-50030-026-000 Social Security Taxes .00 .00 _______________ Account: 135-50030-026-000 Social Security Taxes Totals: .00 .00 ** 620.00 Budgeted 620.00 Remaining 0 % Used Account: 135-50035-026-000 Medicare Taxes .00 .00 _______________ Account: 135-50035-026-000 Medicare Taxes Totals: .00 .00 ** 145.00 Budgeted 145.00 Remaining 0 % Used Account: 135-50040-026-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .00 .00 ** 230.00 Budgeted 230.00 Remaining 0 % Used Account: 135-50045-026-000 Workman's Compensation 191 10/01/2014 Oct TML Ins & Workers Comp 2.94 2.94 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 2.94 ** 36.00 Budgeted 33.06 Remaining 8 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2014 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-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training .00 .00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 2.94 ** 22,881.00 Budgeted 22,878.06 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 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 26 10/04/2014 MUD Payroll 10/4/14 Salaries & Wages 16,624.33 16,624.33 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (11,335.09) 5,289.24 GL 85 10/24/2014 MUD Payroll 10/24/14 Salaries & Wages 17,618.07 22,907.31 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 22,907.31 22,907.31 ** 477,578.00 Budgeted 454,670.69 Remaining 5 % Used Account: 135-50010-030-000 Overtime 26 10/04/2014 MUD Payroll 10/4/14 Overtime 16.05 16.05 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (16.05) .00 GL 85 10/24/2014 MUD Payroll 10/24/14 Overtime 6.98 6.98 PR _______________ Account: 135-50010-030-000 Overtime Totals: 6.98 6.98 ** 1,000.00 Budgeted 993.02 Remaining 1 % Used Account: 135-50016-030-000 Longevity .00 .00 _______________ Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 3,283.00 Budgeted 3,283.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 26 10/04/2014 MUD Payroll 10/4/14 Retirement 1,494.29 1,494.29 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (1,019.31) 474.98 GL 85 10/24/2014 MUD Payroll 10/24/14 Retirement 1,582.73 2,057.71 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,057.71 2,057.71 ** 42,840.00 Budgeted 40,782.29 Remaining 5 % Used Account: 135-50026-030-000 Medical Insurance 26 10/04/2014 MUD Payroll 10/4/14 Medical Insurance 2,402.43 2,402.43 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (1,475.93) 926.50 GL 85 10/24/2014 MUD Payroll 10/24/14 Medical Insurance 2,402.38 3,328.88 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,328.88 3,328.88 ** 65,015.00 Budgeted 61,686.12 Remaining 5 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 26 10/04/2014 MUD Payroll 10/4/14 Dental Insurance 170.19 170.19 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (107.70) 62.49 GL 85 10/24/2014 MUD Payroll 10/24/14 Dental Insurance 170.23 232.72 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 232.72 232.72 ** 4,944.00 Budgeted 4,711.28 Remaining 5 % Used Account: 135-50028-030-000 Vision Insurance 26 10/04/2014 MUD Payroll 10/4/14 Vision Insurance 40.78 40.78 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (25.41) 15.37 GL 85 10/24/2014 MUD Payroll 10/24/14 Vision Insurance 40.84 56.21 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 56.21 56.21 ** 1,158.00 Budgeted 1,101.79 Remaining 5 % Used Account: 135-50029-030-000 Life Insurance & Other 2 10/01/2014 Oct A/P Oct Dental, Life, AD&D, Vision 284.59 284.59 METLIFE 34207 AP 95 10/21/2014 Oct A/P Adm Fees 40.16 324.75 BenefitMall 34280 AP 161 10/31/2014 Oct A/P Rounding adjustment (.05) 324.70 Legal Shield 34323 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 324.70 324.70 ** 4,333.00 Budgeted 4,008.30 Remaining 7 % Used Account: 135-50030-030-000 Social Security Taxes 26 10/04/2014 MUD Payroll 10/4/14 Social Security Taxes 987.88 987.88 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (676.77) 311.11 GL 85 10/24/2014 MUD Payroll 10/24/14 Social Security Taxes 1,026.69 1,337.80 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,337.80 1,337.80 ** 30,079.00 Budgeted 28,741.20 Remaining 4 % Used Account: 135-50035-030-000 Medicare Taxes 26 10/04/2014 MUD Payroll 10/4/14 Medicare Taxes 231.05 231.05 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (158.29) 72.76 GL 85 10/24/2014 MUD Payroll 10/24/14 Medicare Taxes 240.11 312.87 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 312.87 312.87 ** 7,422.00 Budgeted 7,109.13 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-030-000 Unemployment Taxes 26 10/04/2014 MUD Payroll 10/4/14 Unemployment Taxes 7.48 7.48 PR 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (.30) 7.18 GL 85 10/24/2014 MUD Payroll 10/24/14 Unemployment Taxes 23.97 31.15 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 31.15 31.15 ** 1,449.00 Budgeted 1,417.85 Remaining 2 % Used Account: 135-50045-030-000 Workman's Compensation 191 10/01/2014 Oct TML Ins & Workers Comp 87.30 87.30 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 87.30 ** 1,636.00 Budgeted 1,548.70 Remaining 5 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 41 10/09/2014 Oct A/P Pre-employment testing 38.00 38.00 CARENOW CORPORATE 34224 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 38.00 38.00 ** 500.00 Budgeted 462.00 Remaining 8 % Used Account: 135-50070-030-000 Employee Relations 184 10/27/2014 10/1/14-10/27/14 PCards RECEPT PHARMACY 01 603.00 603.00 RECEPT PHARMACY 01 PC 254 10/31/2014 Oct A/P Purchases 32.98 635.98 COSTCO WHOLESALE 34344 AP _______________ Account: 135-50070-030-000 Employee Relations Totals: 635.98 635.98 ** 5,000.00 Budgeted 4,364.02 Remaining 13 % Used Account: 135-55030-030-000 Software & Support 2 10/01/2014 Oct A/P On-boarding Fee (Vital Care Cu 4,200.00 4,200.00 M3 Networks 34206 AP 4 10/01/2014 Oct A/P 50% Down Payment Prior to Equi 57,055.96 61,255.96 M3 Networks 34208 AP 135 10/01/2014 Recode Equip down payment M3 Invoice 29700698 (57,055.96) 4,200.00 GL 7 10/02/2014 Oct A/P October Vital Care All-inclusi 4,100.00 8,300.00 M3 Networks 34209 AP 41 10/09/2014 Oct A/P Payroll time software 3,051.78 11,351.78 Data Management Inc. 34226 AP 95 10/21/2014 Oct A/P Charter, TML FD W/C 645.50 11,997.28 TOWN OF TROPHY CLUB 34306 AP 161 10/31/2014 Oct A/P Annual support renewal 450.00 12,447.28 BADGER METER, INC 34312 AP 267 10/31/2014 Recode M3 10/1 Invoice 6,885.35 19,332.63 GL _______________ Account: 135-55030-030-000 Software & Support Totals: 19,332.63 19,332.63 ** 75,588.00 Budgeted 56,255.37 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55070-030-000 Independent Labor 161 10/31/2014 Oct A/P Record MUD meeting 60.00 60.00 MIGUEL CRUZ 34326 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 60.00 60.00 ** 8,000.00 Budgeted 7,940.00 Remaining 1 % Used Account: 135-55080-030-000 Maintenance & Repairs .00 .00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 .00 ** 4,500.00 Budgeted 4,500.00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 41 10/09/2014 Oct A/P Rekey Water pump room 582.89 582.89 MICHAEL'S KEYS 34247 AP 161 10/31/2014 Oct A/P Rug Service 95.42 678.31 G & K SERVICES 34316 AP 161 10/31/2014 Oct A/P Rug Service 95.42 773.73 G & K SERVICES 34316 AP 161 10/31/2014 Oct A/P Rug Service 95.42 869.15 G & K SERVICES 34316 AP 161 10/31/2014 Oct A/P Rug Service 95.42 964.57 G & K SERVICES 34316 AP 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (190.84) 773.73 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 773.73 773.73 ** 6,500.00 Budgeted 5,726.27 Remaining 12 % Used Account: 135-55120-030-000 Cleaning Services .00 .00 _______________ Account: 135-55120-030-000 Cleaning Services Totals: .00 .00 ** 8,100.00 Budgeted 8,100.00 Remaining 0 % Used Account: 135-55160-030-000 Professional Outside Services 161 10/31/2014 Oct A/P On-site shredding 102.95 102.95 MAGIC SHRED 34325 AP 267 10/31/2014 Recode M3 10/1 Invoice 24,575.00 24,677.95 GL _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 24,677.95 24,677.95 ** 58,000.00 Budgeted 33,322.05 Remaining 43 % Used Account: 135-55161-030-000 Town Personnel Contract .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 .00 ** 6,170.00 Budgeted 6,170.00 Remaining 0 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 254 10/31/2014 Oct A/P Monthly water billing, Fire ne 584.60 584.60 DATAPROSE LLC 34346 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 584.60 584.60 ** 8,200.00 Budgeted 7,615.40 Remaining 7 % Used Account: 135-60005-030-000 Telephone 41 10/09/2014 Oct A/P Answering Service 195.00 195.00 KEYSTONE PARK SECRETARIAL 34239 AP _______________ Account: 135-60005-030-000 Telephone Totals: 195.00 195.00 ** 13,361.00 Budgeted 13,166.00 Remaining 1 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 85 10/24/2014 MUD Payroll 10/24/14 Communications/Pagers/Mobiles 300.00 300.00 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 300.00 300.00 ** 4,056.00 Budgeted 3,756.00 Remaining 7 % Used Account: 135-60020-030-000 Electricity/Gas .00 .00 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 14,978.00 Budgeted 14,978.00 Remaining 0 % Used Account: 135-60025-030-000 Water 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (91.82) (91.82) AR 254 10/31/2014 Oct A/P Water billing/Oct 183.63 91.81 TROPHY CLUB MUD (WATER BILLS) 34366 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60025-030-000 Water Totals: 91.81 91.81 ** 1,500.00 Budgeted 1,408.19 Remaining 6 % Used Account: 135-60035-030-000 Postage 54 10/13/2014 Oct A/P PID Surcharge mailing 288.80 288.80 U.S. POSTAL SERVICE 34276 AP 95 10/21/2014 Oct A/P Conf letters to Auditor 4.99 293.79 FEDERAL EXPRESS CORP 34285 AP 161 10/31/2014 Oct A/P Renew Permit 3 220.00 513.79 U.S. POSTAL SERVICE 34335 AP 164 10/31/2014 MUD Postage usage/Oct 180.99 694.78 GL 254 10/31/2014 Oct A/P Monthly water billing, Fire ne 1,744.53 2,439.31 DATAPROSE LLC 34346 AP _______________ Account: 135-60035-030-000 Postage Totals: 2,439.31 2,439.31 ** 28,500.00 Budgeted 26,060.69 Remaining 9 % Used Account: 135-60040-030-000 Service Charges & Fees 66 10/09/2014 Bank of West Safety Deposit 40.00 40.00 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 40.00 40.00 ** 32,000.00 Budgeted 31,960.00 Remaining 0 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 6,200.00 Budgeted 6,200.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 191 10/01/2014 Oct TML Ins & Workers Comp 4,063.01 4,063.01 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,063.01 4,063.01 ** 48,751.00 Budgeted 44,687.99 Remaining 8 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-030-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60075-030-000 Meetings 184 10/27/2014 10/1/14-10/27/14 PCards CHICK-FIL-A #02892 25.11 25.11 CHICK-FIL-A #02892 PC _______________ Account: 135-60075-030-000 Meetings Totals: 25.11 25.11 ** 400.00 Budgeted 374.89 Remaining 6 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 184 10/27/2014 10/1/14-10/27/14 PCards ACT*TARRANT REGIONAL W 70.00 70.00 ACT*TARRANT REGIONAL W PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 70.00 70.00 ** 10,235.00 Budgeted 10,165.00 Remaining 1 % Used Account: 135-60100-030-000 Travel & per diem 26 10/04/2014 MUD Payroll 10/4/14 Travel & per diem 25.09 25.09 PR 22 10/07/2014 Oct A/P Mileage reimbursement 28.00 53.09 LAURIE SLAGHT 34215 AP 34 10/08/2014 Oct A/P Mileage reimbursement 23.24 76.33 LAURIE SLAGHT 34215 AP 31 10/10/2014 Reverse P/R Accrual @ 9/30/14 (25.09) 51.24 GL 85 10/24/2014 MUD Payroll 10/24/14 Travel & per diem 9.18 60.42 PR 184 10/27/2014 10/1/14-10/27/14 PCards SUBWAY 03430253 5.14 65.56 SUBWAY 03430253 PC 184 10/27/2014 10/1/14-10/27/14 PCards ARAMARK JPMC TOWER STA 4.55 70.11 ARAMARK JPMC TOWER STA PC 184 10/27/2014 10/1/14-10/27/14 PCards PLAT PARKING LOT-188 S 20.00 90.11 PLAT PARKING LOT-188 S PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 90.11 90.11 ** 5,400.00 Budgeted 5,309.89 Remaining 2 % Used Account: 135-60110-030-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 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-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security .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 .00 .00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 17,500.00 Budgeted 17,500.00 Remaining 0 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 60 10/14/2014 Town Billed Inv 1218 AR 20141001-20141014 User: (994.18) (994.18) AR 95 10/21/2014 Oct A/P Boardroom TV Upgrade 1,988.36 994.18 PREMIER AUDIO & VIDEO LLC 34300 AP 101 10/22/2014 Town Inv 1220-1221 AR 20141001-20141022 User: (1,637.00) (642.82) AR 184 10/27/2014 10/1/14-10/27/14 PCards PEARCE OFFICE FURNITUR 1,637.00 994.18 PEARCE OFFICE FURNITUR PC 184 10/27/2014 10/1/14-10/27/14 PCards CLASSROOM ESSENTIALS O 50.00 1,044.18 CLASSROOM ESSENTIALS O PC 184 10/27/2014 10/1/14-10/27/14 PCards CLASSROOM ESSENTIALS O 3,433.95 4,478.13 CLASSROOM ESSENTIALS O PC 184 10/27/2014 10/1/14-10/27/14 PCards PEARCE OFFICE FURNITUR 1,637.00 6,115.13 PEARCE OFFICE FURNITUR PC 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (1,741.97) 4,373.16 AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 4,373.16 4,373.16 ** 10,475.00 Budgeted 6,101.84 Remaining 42 % Used Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 1,855.00 Budgeted 1,855.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 135 10/01/2014 Recode Equip down payment M3 Invoice 29700698 57,055.96 57,055.96 GL 136 10/31/2014 Oct A/P Balance due Computer Equipment 57,055.96 114,111.92 M3 Networks 34309 AP 267 10/31/2014 Recode M3 10/1 Invoice (6,885.35) 107,226.57 GL 267 10/31/2014 Recode M3 10/1 Invoice (24,575.00) 82,651.57 GL _______________ Account: 135-65055-030-000 Hardware Totals: 82,651.57 82,651.57 ** 75,966.00 Budgeted (6,685.57) Remaining 109 % Used Account: 135-65085-030-000 Office Supplies 95 10/21/2014 Oct A/P Office Supplies 193.93 193.93 OFFICE DEPOT, INC 34298 AP 95 10/21/2014 Oct A/P Office Supplies 2.69 196.62 OFFICE DEPOT, INC 34298 AP 184 10/27/2014 10/1/14-10/27/14 PCards SPECIALIST ID INC. 67.10 263.72 SPECIALIST ID INC. PC 184 10/27/2014 10/1/14-10/27/14 PCards CARBONLESS FORMS PRINT 119.00 382.72 CARBONLESS FORMS PRINT PC 161 10/31/2014 Oct A/P Office supplies 40.46 423.18 OFFICE DEPOT, INC 34327 AP 161 10/31/2014 Oct A/P Office supplies 10.92 434.10 OFFICE DEPOT, INC 34327 AP 161 10/31/2014 Oct A/P Office supplies 60.88 494.98 OFFICE DEPOT, INC 34327 AP 252 10/31/2014 Town Billing Inv 1222-1231 AR 20141001-20141031 User: (30.44) 464.54 AR 254 10/31/2014 Oct A/P Office supplies 108.65 573.19 OFFICE DEPOT, INC 34358 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 573.19 573.19 ** 9,000.00 Budgeted 8,426.81 Remaining 6 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 254 10/31/2014 Oct A/P Nevill, Symonds, SHI 52.10 52.10 TOWN OF TROPHY CLUB 34364 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 52.10 52.10 ** 4,732.00 Budgeted 4,679.90 Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65095-030-000 Maintenance Supplies 184 10/27/2014 10/1/14-10/27/14 PCards SAMS CLUB #4795 59.64 59.64 SAMS CLUB #4795 PC 254 10/31/2014 Oct A/P Purchases 210.29 269.93 COSTCO WHOLESALE 34344 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 269.93 269.93 ** 5,000.00 Budgeted 4,730.07 Remaining 5 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays .00 .00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** 125,000.00 Budgeted 125,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 254 10/31/2014 Oct A/P Nevill, Symonds, SHI 40.79 40.79 TOWN OF TROPHY CLUB 34364 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 40.79 40.79 ** 4,236.00 Budgeted 4,195.21 Remaining 1 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 123 10/01/2014 GASB54 Transfers FY2015 IT Future replacement 16,329.00 16,329.00 GL _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: 16,329.00 16,329.00 ** 16,329.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 30 Totals: ------------------------------------------------------------------------------------------------ 188,390.61 ** 1,287,019.00 Budgeted 1,098,628.39 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2014 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 .00 .00 _______________ Account: 135-55045-039-000 Legal Totals: .00 .00 ** 250,000.00 Budgeted 250,000.00 Remaining 0 % Used Account: 135-55055-039-000 Auditing .00 .00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 .00 ** 22,491.00 Budgeted 22,491.00 Remaining 0 % Used Account: 135-55060-039-000 Appraisal .00 .00 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 3,800.00 Budgeted 3,800.00 Remaining 0 % Used Account: 135-55045-039-003 Legal/WWTP Bonds 161 10/31/2014 Oct A/P Oct Legal/Bond Validation Suit 10,279.77 10,279.77 Southwest Securities 34330 AP _______________ Account: 135-55045-039-003 Legal/WWTP Bonds Totals: 10,279.77 10,279.77 ** .00 Budgeted (10,279.77) Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 10,279.77 ** 286,291.00 Budgeted 276,011.23 Remaining 4 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (385,406.05) .00 Budgeted 385,406.05 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 10/2014 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 181 10/31/2014 Bank Interest/October (2.53) (2.53) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (2.53) (2.53) ** .00 Budgeted 2.53 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2.53) ** .00 Budgeted 2.53 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 10/2014 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 .00 .00 _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: .00 .00 ** 3,348.00 Budgeted 3,348.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ .00 ** 3,348.00 Budgeted 3,348.00 Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ (2.53) 3,348.00 Budgeted 3,350.53 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET OCTOBER 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 17,806 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 466,120 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 488,772 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 466,120 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 466,120 FUND BALANCE ASSIGNED FUND BALANCE 14,753 NET REVENUES / EXPENDITURES 7,900 TOTAL FUND BALANCE 22,652 TOTAL LIABILITIES AND FUND BALANCE 488,772 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 17:00 11/12/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2014 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- 6,442.20- 6,442.20- 1.382 459,576.80- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 1,204.68- 1,204.68- 48.187 1,295.32- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 252.50- 252.50- 15.781 1,347.50- Subtotal: 470,119.00- 470,119.00- 7,899.38- 7,899.38- 1.680 462,219.62- 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- .31- .31- .083 374.69- 533-49015-000-000 Lease/Rental Income 211,829.00- 211,829.00- 211,829.00- Subtotal: 212,204.00- 212,204.00- .31- .31- 212,203.69- Program number: 1,139,861.00- 1,139,861.00- 7,899.69- 7,899.69- .693 1,131,961.31- Department number: Revenues 1,139,861.00- 1,139,861.00- 7,899.69- 7,899.69- .693 1,131,961.31- Revenues Subtotal ----------- 1,139,861.00- 1,139,861.00- 7,899.69- 7,899.69- .693 1,131,961.31- . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 17:00 11/12/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee/Bond Issuance 2,550.00 2,550.00 2,550.00 533-70025-051-000 Bond Interest Expense-Tax 403,103.00 403,103.00 403,103.00 533-70035-051-000 Bond Principal Payment-Tax 440,000.00 440,000.00 440,000.00 533-70040-051-000 Bond Interest Expense-Revenue 292,283.00 292,283.00 292,283.00 Subtotal: 1,137,936.00 1,137,936.00 1,137,936.00 Program number: 1,137,936.00 1,137,936.00 1,137,936.00 Department number: Administration 1,137,936.00 1,137,936.00 1,137,936.00 Expenditures Subtotal ----------- 1,137,936.00 1,137,936.00 1,137,936.00 Fund number: 533 MUD 1 I&S Consolidated 1,925.00- 1,925.00- 7,899.69- 7,899.69- 410.374 5,974.69 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2014 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 220 10/06/2014 Property Taxes/Assessments (9.51) (9.51) GL 222 10/10/2014 Property Taxes/Assessments (74.27) (83.78) GL 223 10/13/2014 Property Taxes/Assessments (192.16) (275.94) GL 224 10/14/2014 Property Taxes/Assessments (271.00) (546.94) GL 225 10/15/2014 Property Taxes/Assessments (102.88) (649.82) GL 226 10/16/2014 Property Taxes/Assessments (86.46) (736.28) GL 227 10/20/2014 Property Taxes/Assessments (112.09) (848.37) GL 229 10/21/2014 Property Taxes/Assessments (82.60) (930.97) GL 230 10/22/2014 Property Taxes/Assessments (184.82) (1,115.79) GL 231 10/23/2014 Property Taxes/Assessments (422.32) (1,538.11) GL 232 10/24/2014 Property Taxes/Assessments (514.22) (2,052.33) GL 233 10/27/2014 Property Taxes/Assessments (507.88) (2,560.21) GL 234 10/28/2014 Property Taxes/Assessments (1,358.34) (3,918.55) GL 235 10/29/2014 Property Taxes/Assessments (939.31) (4,857.86) GL 236 10/30/2014 Property Taxes/Assessments (549.38) (5,407.24) GL 237 10/31/2014 Property Taxes/Assessments (1,034.96) (6,442.20) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (6,442.20) (6,442.20) ** (466,019.00) Budgeted (459,576.80) Remaining 1 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 219 10/07/2014 Property Taxes/Assessments 2.75 2.75 GL 224 10/14/2014 Property Taxes/Assessments (67.05) (64.30) GL 225 10/15/2014 Property Taxes/Assessments (12.02) (76.32) GL 226 10/16/2014 Property Taxes/Assessments (1.34) (77.66) GL 227 10/20/2014 Property Taxes/Assessments (1,036.27) (1,113.93) GL 231 10/23/2014 Property Taxes/Assessments (76.20) (1,190.13) GL 234 10/28/2014 Property Taxes/Assessments (10.12) (1,200.25) GL 235 10/29/2014 Property Taxes/Assessments (4.36) (1,204.61) GL 236 10/30/2014 Property Taxes/Assessments (.07) (1,204.68) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (1,204.68) (1,204.68) ** (2,500.00) Budgeted (1,295.32) Remaining 48 % Used Account: 533-40015-000-000 Property Taxes/P & I 224 10/14/2014 Property Taxes/Assessments (14.09) (14.09) GL 225 10/15/2014 Property Taxes/Assessments (2.48) (16.57) GL 226 10/16/2014 Property Taxes/Assessments (.44) (17.01) GL 227 10/20/2014 Property Taxes/Assessments (217.62) (234.63) GL 231 10/23/2014 Property Taxes/Assessments (16.00) (250.63) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 234 10/28/2014 Property Taxes/Assessments (.92) (251.55) GL 235 10/29/2014 Property Taxes/Assessments (.91) (252.46) GL 236 10/30/2014 Property Taxes/Assessments (.04) (252.50) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (252.50) (252.50) ** (1,600.00) Budgeted (1,347.50) Remaining 16 % 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 181 10/31/2014 Bank Interest/October (.31) (.31) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (.31) (.31) ** (375.00) Budgeted (374.69) Remaining 0 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (211,829.00) Budgeted (211,829.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (7,899.69) ** (1,139,861.00) Budgeted (1,131,961.31) Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 17:01 11/12/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 .00 ** 2,550.00 Budgeted 2,550.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 403,103.00 Budgeted 403,103.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 440,000.00 Budgeted 440,000.00 Remaining 0 % Used Account: 533-70040-051-000 Bond Interest Expense-Revenue .00 .00 _______________ Account: 533-70040-051-000 Bond Interest Expense-Revenue Totals: .00 .00 ** 292,283.00 Budgeted 292,283.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 1,137,936.00 Budgeted 1,137,936.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (7,899.69) (1,925.00) Budgeted 5,974.69 Remaining 410 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (133,077.53) **** 1,423.00 Budgeted 134,500.53 Remaining ########## ******* End of Report *********