Loading...
HomeMy WebLinkAbout2015-03 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MARCH 2015 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,033,663 PREPAID EXPENSES 9,594 ADVALOREM PROPERTY TAXES RECEIVABLE 36,794 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 13,906 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,402 TOTAL ASSETS 1,096,359 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 50,700 ACCOUNTS AND OTHER PAYABLES 38,779 TOTAL LIABILITIES 89,479 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 477,969 TOTAL FUND BALANCE 1,006,880 TOTAL LIABILITIES AND FUND BALANCE 1,096,359 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 08:12 04/16/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 357,462.00- 357,462.00- 2,751.21- 351,690.41- 98.385 5,771.59- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 108.29- 108.29 122-40010-000-000 Property Taxes/MUD Fire 872,859.00- 872,859.00- 13,470.46- 855,111.38- 97.967 17,747.62- 122-40011-000-000 Property Taxes/Fire-Delinquent 20.47- 3,615.40- 3,615.40 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 172.53- 254.90- 33.987 495.10- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 538.58- 2,321.04- 51.579 2,178.96- Subtotal: 1,235,571.00- 1,235,571.00- 16,953.25- 1,213,101.42- 98.181 22,469.58- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 4,400.00- 73.333 1,600.00- Subtotal: 6,000.00- 6,000.00- 4,400.00- 73.333 1,600.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 825.00- 117.857 125.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,700.00- 10,700.00- 10,825.00- 101.168 125.00 122-49000-000-000 Capital Lease-Oth Fin Sources 807,316.14- 807,316.14 122-49035-000-000 Prior Year Reserves 125,669.00- 125,669.00- 125,670.00- 100.001 1.00 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 3.99- 8,803.99- 146.733 2,803.99 Subtotal: 131,669.00- 131,669.00- 3.99- 941,790.13- 715.271 810,121.13 Program number: 1,383,940.00- 1,383,940.00- 16,957.24- 2,170,116.55- 156.807 786,176.55 Department number: Fire Revenues 1,383,940.00- 1,383,940.00- 16,957.24- 2,170,116.55- 156.807 786,176.55 Revenues Subtotal ----------- 1,383,940.00- 1,383,940.00- 16,957.24- 2,170,116.55- 156.807 786,176.55 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 08:12 04/16/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 469,067.00 469,067.00 33,545.27 218,036.89 46.483 251,030.11 122-50010-045-000 Overtime 46,745.00 46,745.00 4,019.52 17,078.71 36.536 29,666.29 122-50011-045-000 DPS Holiday Pay 14,930.00 14,930.00 14,525.69 97.292 404.31 122-50016-045-000 Longevity 5,505.00 5,505.00 5,318.72 96.616 186.28 122-50017-045-000 Certification 4,800.00 4,800.00 437.50 2,406.50 50.135 2,393.50 122-50020-045-000 Retirement 91,396.00 91,396.00 5,100.19 35,814.38 39.186 55,581.62 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,548.13 27,262.16 46.075 31,906.84 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 350.36 2,104.69 47.943 2,285.31 122-50028-045-000 Vision Insurance 811.00 811.00 60.57 368.20 45.401 442.80 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 310.69 1,844.51 45.769 2,185.49 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 2,145.95 14,674.60 43.908 18,746.40 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 501.77 3,431.14 47.053 3,860.86 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 1,477.98- 129.98 7.844 1,527.02 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 658.99 3,953.98 45.490 4,738.02 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 50,200.96 346,950.15 46.109 405,504.85 122-55030-045-000 Software & Support 7,378.00 7,378.00 462.50 2,805.17 38.021 4,572.83 122-55045-045-000 Legal 1,500.00 1,500.00 1,500.00 122-55080-045-000 Maintenance & Repairs 18,552.00 18,552.00 553.80 4,798.08 25.863 13,753.92 122-55090-045-000 Vehicle Maintenance 12,000.00 12,000.00 962.68 4,843.54 40.363 7,156.46 Subtotal: 39,430.00 39,430.00 1,978.98 12,446.79 31.567 26,983.21 122-60005-045-000 Telephone 50.00 50.00 5.68 28.49 56.980 21.51 122-60010-045-000 Communications/Pagers/Mobiles 5,000.00 5,000.00 164.21 3,221.30 64.426 1,778.70 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 522.15 2,511.25 27.822 6,514.75 122-60025-045-000 Water 1,200.00 1,200.00 110.20 642.75 53.563 557.25 122-60026-045-000 Cable 1,920.00 1,920.00 13.69 915.83 47.699 1,004.17 122-60030-045-000 Rent And/Or Usage 211,829.00 211,829.00 211,829.00 100.000 122-60035-045-000 Postage 100.00 100.00 6.83 15.47 15.470 84.53 122-60055-045-000 Insurance 12,179.00 12,179.00 940.08 5,640.52 46.313 6,538.48 122-60066-045-000 Publications/Books/Subscrips 200.00 200.00 219.05 109.525 19.05- 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 34.00- 15,418.85 101.573 238.85- 122-60080-045-000 Schools & Training 4,280.00 4,280.00 50.00 1,231.00 28.762 3,049.00 122-60096-045-000 Emergency Management 1,400.00 1,400.00 220.00 15.714 1,180.00 122-60100-045-000 Travel & per diem 13,577.00 13,577.00 3,506.98 25.830 10,070.02 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 5,100.00 5,100.00 124.15 2.434 4,975.85 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 500.42 11.120 3,999.58 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 194.00 19.400 806.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 47.50 979.60 48.980 1,020.40 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 08:12 04/16/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 3.99 573.99 57.399 426.01 Subtotal: 291,541.00 291,541.00 1,830.33 247,772.65 84.987 43,768.35 122-65005-045-000 Fuel & Lube 10,454.00 10,454.00 344.86 2,774.38 26.539 7,679.62 122-65010-045-000 Uniforms 2,000.00 2,000.00 306.93 1,634.05 81.703 365.95 122-65015-045-000 Protective Clothing 5,200.00 15,200.00 4,660.66 5,065.66 33.327 10,134.34 122-65030-045-000 Chemicals 200.00 200.00 133.51 133.51 66.755 66.49 122-65035-045-000 Small Tools 2,500.00 2,500.00 46.61 1.864 2,453.39 122-65055-045-000 Hardware 9,000.00 9,000.00 9,000.00 122-65085-045-000 Office Supplies 500.00 500.00 19.52 3.904 480.48 122-65105-045-000 Printing 548.00 548.00 38.17 6.965 509.83 Subtotal: 30,402.00 40,402.00 5,445.96 9,711.90 24.038 30,690.10 122-69005-045-000 Capital Outlays 1,057,316.14 1,057,316.14- 122-69008-045-000 Short Term Debt-Principal 158,262.00 158,262.00 158,262.00 122-69009-045-000 Short Term Debt-Interest 50,000.00 50,000.00 50,000.00 122-69050-045-000 Radios 23,500.00 23,500.00 23,500.00 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 17,950.00 17,950.00 100.000 122-69255-045-000 Airpacks 20,400.00 10,400.00 10,400.00 Subtotal: 270,112.00 260,112.00 1,075,266.14 413.386 815,154.14- Program number: 1,383,940.00 1,383,940.00 59,456.23 1,692,147.63 122.270 308,207.63- Department number: Fire 1,383,940.00 1,383,940.00 59,456.23 1,692,147.63 122.270 308,207.63- Expenditures Subtotal ----------- 1,383,940.00 1,383,940.00 59,456.23 1,692,147.63 122.270 308,207.63- Fund number: 122 Trophy Club MUD Fire Dept. 42,498.99 477,968.92- 477,968.92 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 1147 03/02/2015 Property Taxes/Assessments (348,939.20) (617.03) (349,556.23) GL 1148 03/03/2015 Property Taxes/Assessments (50.63) (349,606.86) GL 1151 03/09/2015 Property Taxes/Assessments (118.97) (349,725.83) GL 1152 03/10/2015 Property Taxes/Assessments (335.81) (350,061.64) GL 1153 03/11/2015 Property Taxes/Assessments (362.49) (350,424.13) GL 1154 03/12/2015 Property Taxes/Assessments (661.37) (351,085.50) GL 1156 03/16/2015 Property Taxes/Assessments (73.41) (351,158.91) GL 1158 03/18/2015 Property Taxes/Assessments (221.78) (351,380.69) GL 1161 03/20/2015 Property Taxes/Assessments (87.12) (351,467.81) GL 1162 03/23/2015 Property Taxes/Assessments (52.78) (351,520.59) GL 1164 03/25/2015 Property Taxes/Assessments (79.68) (351,600.27) GL 1165 03/26/2015 Property Taxes/Assessments (79.62) (351,679.89) GL 1166 03/27/2015 Property Taxes/Assessments (10.52) (351,690.41) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (2,751.21) (351,690.41) ** (357,462.00) Budgeted (5,771.59) Remaining 98 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (108.29) .00 (108.29) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (108.29) ** .00 Budgeted 108.29 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1147 03/02/2015 Property Taxes/Assessments (841,640.92) (5,085.55) (846,726.47) GL 1148 03/03/2015 Property Taxes/Assessments (854.42) (847,580.89) GL 1149 03/04/2015 Property Taxes/Assessments (933.49) (848,514.38) GL 1150 03/06/2015 Property Taxes/Assessments (107.88) (848,622.26) GL 1151 03/09/2015 Property Taxes/Assessments (49.22) (848,671.48) GL 1152 03/10/2015 Property Taxes/Assessments (97.29) (848,768.77) GL 1153 03/11/2015 Property Taxes/Assessments (910.60) (849,679.37) GL 1154 03/12/2015 Property Taxes/Assessments (897.54) (850,576.91) GL 1155 03/13/2015 Property Taxes/Assessments (356.20) (850,933.11) GL 1156 03/16/2015 Property Taxes/Assessments (764.44) (851,697.55) GL 1157 03/17/2015 Property Taxes/Assessments (86.24) (851,783.79) GL 1158 03/18/2015 Property Taxes/Assessments (547.53) (852,331.32) GL 1160 03/19/2015 Property Taxes/Assessments (217.24) (852,548.56) GL 1161 03/20/2015 Property Taxes/Assessments (32.46) (852,581.02) GL 1173 03/20/2015 Rev Property Taxes/Assessments 32.46 (852,548.56) GL 1174 03/20/2015 Property Taxes/Assessments (13.14) (852,561.70) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1162 03/23/2015 Property Taxes/Assessments (841,640.92) (56.93) (852,618.63) GL 1163 03/24/2015 Property Taxes/Assessments (177.18) (852,795.81) GL 1164 03/25/2015 Property Taxes/Assessments (386.34) (853,182.15) GL 1165 03/26/2015 Property Taxes/Assessments (323.50) (853,505.65) GL 1172 03/26/2015 Rev Property Taxes/Assessments 323.50 (853,182.15) GL 1175 03/26/2015 Property Taxes/Assessments (91.69) (853,273.84) GL 1166 03/27/2015 Property Taxes/Assessments (365.88) (853,639.72) GL 1167 03/30/2015 Property Taxes/Assessments (1,165.78) (854,805.50) GL 1168 03/31/2015 Property Taxes/Assessments (305.88) (855,111.38) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (13,470.46) (855,111.38) ** (872,859.00) Budgeted (17,747.62) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1148 03/03/2015 Property Taxes/Assessments (3,594.93) (10.07) (3,605.00) GL 1154 03/12/2015 Property Taxes/Assessments (32.24) (3,637.24) GL 1174 03/20/2015 Property Taxes/Assessments 21.84 (3,615.40) GL 1162 03/23/2015 Property Taxes/Assessments (43.62) (3,659.02) GL 1163 03/24/2015 Property Taxes/Assessments 43.62 (3,615.40) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (20.47) (3,615.40) ** .00 Budgeted 3,615.40 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1147 03/02/2015 Property Taxes/Assessments (82.37) (43.19) (125.56) GL 1148 03/03/2015 Property Taxes/Assessments (3.55) (129.11) GL 1151 03/09/2015 Property Taxes/Assessments (10.71) (139.82) GL 1152 03/10/2015 Property Taxes/Assessments (29.84) (169.66) GL 1153 03/11/2015 Property Taxes/Assessments (31.49) (201.15) GL 1154 03/12/2015 Property Taxes/Assessments (46.30) (247.45) GL 1156 03/16/2015 Property Taxes/Assessments (6.61) (254.06) GL 1166 03/27/2015 Property Taxes/Assessments (.84) (254.90) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (172.53) (254.90) ** (750.00) Budgeted (495.10) Remaining 34 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1147 03/02/2015 Property Taxes/Assessments (1,782.46) (25.18) (1,807.64) GL 1148 03/03/2015 Property Taxes/Assessments (62.33) (1,869.97) GL 1149 03/04/2015 Property Taxes/Assessments (62.45) (1,932.42) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1151 03/09/2015 Property Taxes/Assessments (1,782.46) (4.43) (1,936.85) GL 1152 03/10/2015 Property Taxes/Assessments (4.34) (1,941.19) GL 1153 03/11/2015 Property Taxes/Assessments (52.14) (1,993.33) GL 1154 03/12/2015 Property Taxes/Assessments (76.44) (2,069.77) GL 1155 03/13/2015 Property Taxes/Assessments (28.62) (2,098.39) GL 1156 03/16/2015 Property Taxes/Assessments (28.80) (2,127.19) GL 1157 03/17/2015 Property Taxes/Assessments (3.07) (2,130.26) GL 1158 03/18/2015 Property Taxes/Assessments (38.43) (2,168.69) GL 1160 03/19/2015 Property Taxes/Assessments (2.04) (2,170.73) GL 1161 03/20/2015 Property Taxes/Assessments 41.16 (2,129.57) GL 1173 03/20/2015 Rev Property Taxes/Assessments (41.16) (2,170.73) GL 1162 03/23/2015 Property Taxes/Assessments (13.30) (2,184.03) GL 1163 03/24/2015 Property Taxes/Assessments 6.03 (2,178.00) GL 1164 03/25/2015 Property Taxes/Assessments (29.21) (2,207.21) GL 1165 03/26/2015 Property Taxes/Assessments 215.86 (1,991.35) GL 1172 03/26/2015 Rev Property Taxes/Assessments (215.86) (2,207.21) GL 1175 03/26/2015 Property Taxes/Assessments (15.95) (2,223.16) GL 1167 03/30/2015 Property Taxes/Assessments (75.08) (2,298.24) GL 1168 03/31/2015 Property Taxes/Assessments (22.80) (2,321.04) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (538.58) (2,321.04) ** (4,500.00) Budgeted (2,178.96) Remaining 52 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (4,400.00) .00 (4,400.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (4,400.00) ** (6,000.00) Budgeted (1,600.00) Remaining 73 % Used Account: 122-43400-000-000 Fire Inspections (825.00) .00 (825.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (825.00) ** (700.00) Budgeted 125.00 Remaining 118 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-49000-000-000 Capital Lease-Oth Fin Sources (807,316.14) .00 (807,316.14) _______________ Account: 122-49000-000-000 Capital Lease-Oth Fin Sources Totals: .00 (807,316.14) ** .00 Budgeted 807,316.14 Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves (125,670.00) .00 (125,670.00) _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 (125,670.00) ** (125,669.00) Budgeted 1.00 Remaining 100 % Used Account: 122-49900-000-000 Miscellaneous Income 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: (8,800.00) (3.99) (8,803.99) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (3.99) (8,803.99) ** (6,000.00) Budgeted 2,803.99 Remaining 147 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,170,116.55) ** (1,383,940.00) Budgeted 786,176.55 Remaining 157 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 1195 03/13/2015 Fire P/R Supplemental 184,491.62 468.00 184,959.62 GL 1019 03/13/2015 FD Payroll 3/13/15 16,618.26 201,577.88 GL 1125 03/27/2015 FD 3/27/15 Payroll 16,459.01 218,036.89 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 33,545.27 218,036.89 ** 469,067.00 Budgeted 251,030.11 Remaining 46 % Used Account: 122-50010-045-000 Overtime 1019 03/13/2015 FD Payroll 3/13/15 13,059.19 4,019.52 17,078.71 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,019.52 17,078.71 ** 46,745.00 Budgeted 29,666.29 Remaining 37 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,525.69 .00 14,525.69 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,525.69 ** 14,930.00 Budgeted 404.31 Remaining 97 % Used Account: 122-50016-045-000 Longevity 5,318.72 .00 5,318.72 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,318.72 ** 5,505.00 Budgeted 186.28 Remaining 97 % Used Account: 122-50017-045-000 Certification 1019 03/13/2015 FD Payroll 3/13/15 1,969.00 437.50 2,406.50 GL _______________ Account: 122-50017-045-000 Certification Totals: 437.50 2,406.50 ** 4,800.00 Budgeted 2,393.50 Remaining 50 % Used Account: 122-50020-045-000 Retirement 1019 03/13/2015 FD Payroll 3/13/15 30,714.19 2,851.90 33,566.09 GL 1125 03/27/2015 FD 3/27/15 Payroll 2,248.29 35,814.38 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,100.19 35,814.38 ** 91,396.00 Budgeted 55,581.62 Remaining 39 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1019 03/13/2015 FD Payroll 3/13/15 22,714.03 2,584.10 25,298.13 GL 1125 03/27/2015 FD 3/27/15 Payroll 1,964.03 27,262.16 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,548.13 27,262.16 ** 59,169.00 Budgeted 31,906.84 Remaining 46 % Used Account: 122-50027-045-000 Dental Insurance 1019 03/13/2015 FD Payroll 3/13/15 1,754.33 175.15 1,929.48 GL 1125 03/27/2015 FD 3/27/15 Payroll 175.21 2,104.69 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 350.36 2,104.69 ** 4,390.00 Budgeted 2,285.31 Remaining 48 % Used Account: 122-50028-045-000 Vision Insurance 1019 03/13/2015 FD Payroll 3/13/15 307.63 30.26 337.89 GL 1125 03/27/2015 FD 3/27/15 Payroll 30.31 368.20 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 60.57 368.20 ** 811.00 Budgeted 442.80 Remaining 45 % Used Account: 122-50029-045-000 Life Insurance & Other 1019 03/13/2015 FD Payroll 3/13/15 1,533.82 155.27 1,689.09 GL 1125 03/27/2015 FD 3/27/15 Payroll 155.42 1,844.51 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 310.69 1,844.51 ** 4,030.00 Budgeted 2,185.49 Remaining 46 % Used Account: 122-50030-045-000 Social Security Taxes 1195 03/13/2015 Fire P/R Supplemental 12,528.65 29.01 12,557.66 GL 1019 03/13/2015 FD Payroll 3/13/15 1,200.35 13,758.01 GL 1125 03/27/2015 FD 3/27/15 Payroll 916.59 14,674.60 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,145.95 14,674.60 ** 33,421.00 Budgeted 18,746.40 Remaining 44 % Used Account: 122-50035-045-000 Medicare Taxes 1195 03/13/2015 Fire P/R Supplemental 2,929.37 6.78 2,936.15 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1019 03/13/2015 FD Payroll 3/13/15 2,929.37 280.64 3,216.79 GL 1125 03/27/2015 FD 3/27/15 Payroll 214.35 3,431.14 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 501.77 3,431.14 ** 7,292.00 Budgeted 3,860.86 Remaining 47 % Used Account: 122-50040-045-000 Unemployment Taxes 1195 03/13/2015 Fire P/R Supplemental 1,607.96 1.40 1,609.36 GL 1019 03/13/2015 FD Payroll 3/13/15 (1,263.03) 346.33 GL 1125 03/27/2015 FD 3/27/15 Payroll (216.35) 129.98 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: (1,477.98) 129.98 ** 1,657.00 Budgeted 1,527.02 Remaining 8 % Used Account: 122-50045-045-000 Workman's Compensation 196 03/01/2015 Mar TML Ins & Workers Comp 3,294.99 658.99 3,953.98 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 658.99 3,953.98 ** 8,692.00 Budgeted 4,738.02 Remaining 45 % 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 1141 03/31/2015 Mar A/P Pitney Bowes, Pest Control, Ge 2,342.67 462.50 2,805.17 TOWN OF TROPHY CLUB 34834 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 2,805.17 ** 7,378.00 Budgeted 4,572.83 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55045-045-000 Legal .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 1042 03/19/2015 Mar A/P Purevia for FD 4,244.28 15.99 4,260.27 COSTCO WHOLESALE 34745 AP 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: (48.43) 4,211.84 AR 1141 03/31/2015 Mar A/P Rug Service 32.29 4,244.13 G & K SERVICES 34806 AP 1141 03/31/2015 Mar A/P Rug service 32.29 4,276.42 G & K SERVICES 34806 AP 1141 03/31/2015 Mar A/P Rug service 32.29 4,308.71 G & K SERVICES 34806 AP 1141 03/31/2015 Mar A/P March supplies 59.95 4,368.66 COSTCO WHOLESALE 34799 AP 1141 03/31/2015 Mar A/P Bauer, Single air test 187.75 4,556.41 AUGUST INDUSTRIES, INC 34791 AP 1141 03/31/2015 Mar A/P Reimb Sam's & Walmart purchase 241.67 4,798.08 Kari Schultz 34811 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 553.80 4,798.08 ** 18,552.00 Budgeted 13,753.92 Remaining 26 % Used Account: 122-55090-045-000 Vehicle Maintenance 1128 03/26/2015 2/27-3/26/15 PCards WILDFIRE TRUCK & EQUIP 3,880.86 225.00 4,105.86 WILDFIRE TRUCK & EQUIP PC 1128 03/26/2015 2/27-3/26/15 PCards TCI #627 737.68 4,843.54 TCI #627 PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 962.68 4,843.54 ** 12,000.00 Budgeted 7,156.46 Remaining 40 % Used Account: 122-60005-045-000 Telephone 1141 03/31/2015 Mar A/P BOA PCards 22.81 5.68 28.49 TOWN OF TROPHY CLUB 34834 AP _______________ Account: 122-60005-045-000 Telephone Totals: 5.68 28.49 ** 50.00 Budgeted 21.51 Remaining 57 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1019 03/13/2015 FD Payroll 3/13/15 3,057.09 37.50 3,094.59 GL 1141 03/31/2015 Mar A/P Pitney Bowes, Pest Control, Ge 126.71 3,221.30 TOWN OF TROPHY CLUB 34834 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 164.21 3,221.30 ** 5,000.00 Budgeted 1,778.70 Remaining 64 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60020-045-000 Electricity/Gas 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: 1,989.10 (522.15) 1,466.95 AR 1141 03/31/2015 Mar A/P Electricity 2/11-3/12/15 734.12 2,201.07 HUDSON ENERGY SERVICES, LLC 34809 AP 1141 03/31/2015 Mar A/P Gas/Fire Station 2/18-3/19/15 310.18 2,511.25 ATMOS ENERGY 34790 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 522.15 2,511.25 ** 9,026.00 Budgeted 6,514.75 Remaining 28 % Used Account: 122-60025-045-000 Water 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: 532.55 (110.19) 422.36 AR 1141 03/31/2015 Mar A/P March water 220.39 642.75 TROPHY CLUB MUD (WATER BILLS) 34835 AP _______________ Account: 122-60025-045-000 Water Totals: 110.20 642.75 ** 1,200.00 Budgeted 557.25 Remaining 54 % Used Account: 122-60026-045-000 Cable 1185 03/04/2015 Firefighters Feb & Mar cable 902.14 (267.64) 634.50 GL 1128 03/26/2015 2/27-3/26/15 PCards ATT*BILL PAYMENT 128.59 763.09 ATT*BILL PAYMENT PC 1128 03/26/2015 2/27-3/26/15 PCards ATT*BILL PAYMENT 152.74 915.83 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 13.69 915.83 ** 1,920.00 Budgeted 1,004.17 Remaining 48 % Used Account: 122-60030-045-000 Rent And/Or Usage 211,829.00 .00 211,829.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 211,829.00 ** 211,829.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 1128 03/26/2015 2/27-3/26/15 PCards USPS 48764506630613152 8.64 2.50 11.14 USPS 48764506630613152 PC 1120 03/31/2015 March MUD Postage meter usage 4.33 15.47 GL _______________ Account: 122-60035-045-000 Postage Totals: 6.83 15.47 ** 100.00 Budgeted 84.53 Remaining 15 % Used Account: 122-60055-045-000 Insurance 196 03/01/2015 Mar TML Ins & Workers Comp 4,700.44 940.08 5,640.52 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60055-045-000 Insurance Totals: 940.08 5,640.52 ** 12,179.00 Budgeted 6,538.48 Remaining 46 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 219.05 .00 219.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 219.05 ** 200.00 Budgeted (19.05) Remaining 110 % Used Account: 122-60070-045-000 Dues & Memberships 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: 15,452.85 (34.00) 15,418.85 AR _______________ Account: 122-60070-045-000 Dues & Memberships Totals: (34.00) 15,418.85 ** 15,180.00 Budgeted (238.85) Remaining 102 % Used Account: 122-60080-045-000 Schools & Training 1128 03/26/2015 2/27-3/26/15 PCards SAFE KIDS WORLDWIDE 1,181.00 50.00 1,231.00 SAFE KIDS WORLDWIDE PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 50.00 1,231.00 ** 4,280.00 Budgeted 3,049.00 Remaining 29 % Used Account: 122-60096-045-000 Emergency Management 220.00 .00 220.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 220.00 ** 1,400.00 Budgeted 1,180.00 Remaining 16 % Used Account: 122-60100-045-000 Travel & per diem 3,506.98 .00 3,506.98 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 3,506.98 ** 13,577.00 Budgeted 10,070.02 Remaining 26 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 124.15 .00 124.15 _______________ Account: 122-60125-045-000 Advertising Totals: .00 124.15 ** 5,100.00 Budgeted 4,975.85 Remaining 2 % Used Account: 122-60160-045-000 Programs & Special Projects 500.42 .00 500.42 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 500.42 ** 4,500.00 Budgeted 3,999.58 Remaining 11 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 194.00 .00 194.00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 194.00 ** 1,000.00 Budgeted 806.00 Remaining 19 % Used Account: 122-60195-045-000 Flags & Repair 1141 03/31/2015 Mar A/P Pitney Bowes, Pest Control, Ge 932.10 47.50 979.60 TOWN OF TROPHY CLUB 34834 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 47.50 979.60 ** 2,000.00 Budgeted 1,020.40 Remaining 49 % Used Account: 122-60245-045-000 Miscellaneous Expense 1141 03/31/2015 Mar A/P Link Clips/TC EMS 570.00 3.99 573.99 NAPA AUTO PARTS 34822 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 3.99 573.99 ** 1,000.00 Budgeted 426.01 Remaining 57 % Used Account: 122-65005-045-000 Fuel & Lube 1141 03/31/2015 Mar A/P March fuel 2,429.52 344.86 2,774.38 US Bank Voyager Fleet Systems 34836 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 344.86 2,774.38 ** 10,454.00 Budgeted 7,679.62 Remaining 27 % Used Account: 122-65010-045-000 Uniforms 1042 03/19/2015 Mar A/P GST (Fire Uniforms) 1,327.12 306.93 1,634.05 TOWN OF TROPHY CLUB 34772 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 306.93 1,634.05 ** 2,000.00 Budgeted 365.95 Remaining 82 % Used Account: 122-65015-045-000 Protective Clothing 1042 03/19/2015 Mar A/P Protective Clothing 405.00 2,155.00 2,560.00 CASCO INDUSTRIES INC 34740 AP 1042 03/19/2015 Mar A/P Protective Clothing 2,210.00 4,770.00 CASCO INDUSTRIES INC 34740 AP 1042 03/19/2015 Mar A/P Inspection/Cleaning per NFPA 1 295.66 5,065.66 Gear Cleaning Solutions, LLC 34748 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 4,660.66 5,065.66 ** 15,200.00 Budgeted 10,134.34 Remaining 33 % Used Account: 122-65030-045-000 Chemicals 1128 03/26/2015 2/27-3/26/15 PCards THE HOME DEPOT 6581 61.54 61.54 THE HOME DEPOT 6581 PC 1128 03/26/2015 2/27-3/26/15 PCards TRACTOR SUPPLY COMPANY 71.97 133.51 TRACTOR SUPPLY COMPANY PC _______________ Account: 122-65030-045-000 Chemicals Totals: 133.51 133.51 ** 200.00 Budgeted 66.49 Remaining 67 % Used Account: 122-65035-045-000 Small Tools 46.61 .00 46.61 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 46.61 ** 2,500.00 Budgeted 2,453.39 Remaining 2 % Used Account: 122-65055-045-000 Hardware .00 .00 _______________ Account: 122-65055-045-000 Hardware Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 19.52 .00 19.52 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 19.52 ** 500.00 Budgeted 480.48 Remaining 4 % Used Account: 122-65105-045-000 Printing 38.17 .00 38.17 _______________ Account: 122-65105-045-000 Printing Totals: .00 38.17 ** 548.00 Budgeted 509.83 Remaining 7 % Used Account: 122-69005-045-000 Capital Outlays 1,057,316.14 .00 1,057,316.14 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 1,057,316.14 ** .00 Budgeted (1,057,316.14) Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 158,262.00 Budgeted 158,262.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt-Interest .00 .00 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 23,500.00 Budgeted 23,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 .00 17,950.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 17,950.00 ** 17,950.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 10,400.00 Budgeted 10,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 1,692,147.63 ** 1,383,940.00 Budgeted (308,207.63) Remaining 122 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (477,968.92) .00 Budgeted 477,968.92 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MARCH 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 3/31/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 188,225 - - 188,225 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,506,980 - - 1,506,980 INVESTMENTS-TEXPOOL 1,450,872 169,600 21,606 1,642,078 PREPAID EXPENSES 40,796 - - 40,796 ADVALOREM PROPERTY TAXES RECEIVABLE 6,201 - - 6,201 UTILITY AND OTHER ACCOUNTS RECEIVABLE 593,620 - - 593,620 - TOTAL ASSETS 3,787,296 169,600 21,606 3,978,501 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 6,201 - - 6,201 ACCOUNTS AND OTHER PAYABLES 514,385 - 13,581 527,966 CUSTOMER DEPOSITS 301,777 - - 301,777 - TOTAL LIABILITIES 822,363 - 13,581 835,944 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 260,697 260,697 NON-SPENDABLE FUND BALANCE 13,980 13,980 ASSIGNED FUND BALANCE 1,409,006 10,268 1,419,274 UNASSIGNED FUND BALANCE 725,069 - - 725,069 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES 816,878 (91,097) (2,243) 723,538 - TOTAL FUND BALANCE 2,964,933 169,600 8,025 3,142,558 - TOTAL LIABILITIES AND FUND BALANCE 3,787,296 169,600 21,606 3,978,502 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 167,857.00- 167,857.00- 2,590.54- 164,448.76- 97.970 3,408.24- 135-40002-000-000 Property Taxes/Delinquent 2.19- 401.35- 401.35 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 102.68- 374.86- 41.651 525.14- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 11,676.80- 68,983.90- 51.482 65,013.10- Subtotal: 302,754.00- 302,754.00- 14,372.21- 234,208.87- 77.359 68,545.13- 135-47000-000-000 Water 5,286,045.00- 5,286,045.00- 168,912.31- 1,374,487.72- 26.002 3,911,557.28- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 128,352.61- 914,667.06- 40.276 1,356,314.94- 135-47025-000-000 Penalties 63,416.00- 63,416.00- 5,199.87- 46,418.99- 73.198 16,997.01- 135-47030-000-000 Service Charges 8,000.00- 8,000.00- 753.00- 5,793.00- 72.413 2,207.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 50.00- 1,350.00- 67.500 650.00- 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 150.00- 4,050.00- 81.000 950.00- 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 590.10- 14,545.30- 16.754 72,269.70- Subtotal: 7,722,258.00- 7,722,258.00- 304,007.89- 2,361,312.07- 30.578 5,360,945.93- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 27,600.00- 105,800.00- 57.500 78,200.00- Subtotal: 184,000.00- 184,000.00- 27,600.00- 105,800.00- 57.500 78,200.00- 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 485.39- 3,064.45- 61.289 1,935.55- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 5,463.18- 53.750 4,700.82- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 3,499.98- 50.000 3,500.02- 135-49030-000-000 Vending Revenue 351.00- 351.00- 351.00- 135-49036-000-000 GASB Reserves 74,706.00- 74,706.00- 74,706.00- 100.000 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 4,802.00- 28,997.83- 34.521 55,002.17- 135-49141-000-000 Interfund Transfer In 19,606.50- 19,606.50- 19,606.50 135-49145-000-000 Intergov Transfer In 1,074,337.15- 1,074,337.15 135-49900-000-000 Miscellaneous Income 54,000.00- 88,600.00- 13,492.86 37,441.89- 42.259 51,158.11- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 12.20- 12.200 87.80- Subtotal: 235,321.00- 269,921.00- 12,894.89- 1,247,129.18- 462.035 977,208.18 Program number: 8,444,333.00- 8,478,933.00- 358,874.99- 3,948,450.12- 46.568 4,530,482.88- Department number: Revenues 8,444,333.00- 8,478,933.00- 358,874.99- 3,948,450.12- 46.568 4,530,482.88- Revenues Subtotal ----------- 8,444,333.00- 8,478,933.00- 358,874.99- 3,948,450.12- 46.568 4,530,482.88- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 301,101.00 301,101.00 17,188.94 92,113.63 30.592 208,987.37 135-50010-010-000 Overtime 19,500.00 19,500.00 1,459.54 6,473.48 33.197 13,026.52 135-50016-010-000 Longevity 5,343.00 5,343.00 2,705.00 50.627 2,638.00 135-50017-010-000 Certification 4,800.00 4,800.00 225.00 1,375.00 28.646 3,425.00 135-50020-010-000 Retirement 29,349.00 29,349.00 1,681.63 9,179.01 31.275 20,169.99 135-50026-010-000 Medical Insurance 44,988.00 44,988.00 3,269.05 13,559.44 30.140 31,428.56 135-50027-010-000 Dental Insurance 3,288.00 3,288.00 267.98 1,087.24 33.067 2,200.76 135-50028-010-000 Vision Insurance 834.00 834.00 59.92 252.51 30.277 581.49 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 194.82 929.33 30.232 2,144.67 135-50030-010-000 Social Security Taxes 21,135.00 21,135.00 1,138.83 6,289.25 29.758 14,845.75 135-50035-010-000 Medicare Taxes 4,943.00 4,943.00 266.33 1,470.88 29.757 3,472.12 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 726.00- 28.04 2.258 1,213.96 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 857.91 3,827.46 23.892 12,192.54 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,000.00 141.45 728.30 72.830 271.70 135-50070-010-000 Employee Relations 300.00 300.00 89.60 112.46 37.487 187.54 Subtotal: 456,917.00 456,917.00 26,115.00 140,131.03 30.669 316,785.97 135-55005-010-000 Engineering 10,000.00 10,000.00 10,000.00 135-55080-010-000 Maintenance & Repairs 71,242.00 71,242.00 5,746.85 33,502.09 47.026 37,739.91 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 1,211.40 3,650.86 45.636 4,349.14 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 243.00 6.943 3,257.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 570.26 1,830.52 33.282 3,669.48 Subtotal: 98,242.00 98,242.00 7,528.51 39,226.47 39.928 59,015.53 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 439.73 1,946.64 39.622 2,966.36 135-60020-010-000 Electricity 170,765.00 170,765.00 9,103.96 54,203.04 31.741 116,561.96 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 237.00 722.00 17.448 3,416.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 2,418.75- 18,605.31 37.758 30,669.69 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 108,302.19 684,467.14 23.374 2,243,840.86 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 299.00 1,180.71 33.735 2,319.29 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 3,500.00 3,500.00 Subtotal: 3,169,249.00 3,169,249.00 115,963.13 761,124.84 24.016 2,408,124.16 135-65005-010-000 Fuel & Lube 29,172.00 29,172.00 761.84 5,856.20 20.075 23,315.80 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,620.00 3,620.00 947.63 2,307.77 63.751 1,312.23 135-65030-010-000 Chemicals 7,000.00 7,000.00 782.27 4,841.63 69.166 2,158.37 135-65035-010-000 Small Tools 1,200.00 1,200.00 68.37 5.698 1,131.63 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 277.01 27.701 722.99 135-65050-010-000 Meter Expense 161,500.00 161,500.00 7,161.00 24,909.84 15.424 136,590.16 Subtotal: 203,492.00 203,492.00 9,652.74 38,260.82 18.802 165,231.18 135-69005-010-000 Capital Outlays 1,089,006.00 1,177,566.00 15,104.64 140,466.09 11.929 1,037,099.91 135-69008-010-000 Short Term Debt-Principal 129,000.00 129,000.00 129,000.00 129,000.00 100.000 135-69009-010-000 Short Term Debt-Interest 3,612.00 3,612.00 2,415.58 2,415.58 66.877 1,196.42 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 151,507.00 151,507.00 8,183.34 126,957.76 83.797 24,549.24 Subtotal: 1,448,125.00 1,536,685.00 154,703.56 473,839.43 30.835 1,062,845.57 Program number: 5,376,025.00 5,464,585.00 313,962.94 1,452,582.59 26.582 4,012,002.41 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 150.00 2,167.63 43.353 2,832.37 Subtotal: 5,000.00 5,000.00 150.00 2,167.63 43.353 2,832.37 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 2,418.75 2,418.75 48.375 2,581.25 Subtotal: 5,000.00 5,000.00 2,418.75 2,418.75 48.375 2,581.25 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 2,568.75 4,586.38 45.864 5,413.62 Department number: Water 5,386,025.00 5,474,585.00 316,531.69 1,457,168.97 26.617 4,017,416.03 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 305,744.00 305,744.00 23,185.84 141,631.41 46.324 164,112.59 135-50010-020-000 Overtime 19,500.00 19,500.00 4,422.07 16,153.08 82.836 3,346.92 135-50016-020-000 Longevity 5,617.00 5,617.00 5,615.00 99.964 2.00 135-50017-020-000 Certification 6,600.00 6,600.00 550.00 3,300.00 50.000 3,300.00 135-50020-020-000 Retirement 29,948.00 29,948.00 2,508.87 14,904.93 49.769 15,043.07 135-50026-020-000 Medical Insurance 61,001.00 61,001.00 4,686.75 27,617.89 45.274 33,383.11 135-50027-020-000 Dental Insurance 4,146.00 4,146.00 299.51 1,766.47 42.607 2,379.53 135-50028-020-000 Vision Insurance 990.00 990.00 69.00 411.39 41.555 578.61 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 285.13 1,662.60 52.054 1,531.40 135-50030-020-000 Social Security Taxes 21,680.00 21,680.00 1,585.68 9,273.06 42.772 12,406.94 135-50035-020-000 Medicare Taxes 5,070.00 5,070.00 370.84 2,168.68 42.775 2,901.32 135-50040-020-000 Unemployment Taxes 1,242.00 1,242.00 1,156.50- 52.28 4.209 1,189.72 135-50045-020-000 Workman's Compensation 16,020.00 16,020.00 857.91 3,827.46 23.892 12,192.54 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 126.00 84.000 24.00 135-50070-020-000 Employee Relations 550.00 550.00 6.50 451.27 82.049 98.73 Subtotal: 481,452.00 481,452.00 37,671.60 228,961.52 47.556 252,490.48 135-55080-020-000 Maintenance & Repairs 58,000.00 58,000.00 5,852.58 52,435.39 90.406 5,564.61 135-55090-020-000 Vehicle Maintenance 3,000.00 3,000.00 790.94 2,789.28 92.976 210.72 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 21.27 4.254 478.73 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 9,316.98 32,177.08 58.504 22,822.92 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 5,214.00 14,309.50 57.238 10,690.50 Subtotal: 141,500.00 141,500.00 21,174.50 101,732.52 71.896 39,767.48 135-60010-020-000 Communications/Mobiles 4,662.00 4,662.00 687.85 2,667.43 57.216 1,994.57 135-60020-020-000 Electricity 149,292.00 149,292.00 20,465.25 61,789.65 41.388 87,502.35 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 134.85 33.713 265.15 135-60070-020-000 Dues & Memberships 250.00 250.00 307.00 307.00 122.800 57.00- 135-60080-020-000 Schools & Training 4,065.00 4,065.00 129.00- 1,018.00 25.043 3,047.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,347.35 1,791.25 111.953 191.25- 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 9,019.00 52.589 8,131.00 135-60245-020-000 Miscellaneous Expenses 300.00 300.00 300.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60333-020-000 Interfund Transfer Out-Reserve 10,278.00 10,278.00 10,278.00- Subtotal: 187,769.00 187,769.00 32,956.45 87,005.18 46.336 100,763.82 135-65005-020-000 Fuel & Lube 36,328.00 36,328.00 1,017.10 9,815.50 27.019 26,512.50 135-65010-020-000 Uniforms 2,778.00 2,778.00 232.47 2,598.44 93.536 179.56 135-65030-020-000 Chemicals 30,000.00 30,000.00 3,320.00 7,827.65 26.092 22,172.35 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-020-000 Small Tools 2,000.00 2,000.00 502.25 25.113 1,497.75 135-65040-020-000 Safety Equipment 750.00 750.00 162.00 21.600 588.00 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 333.21 5,933.25 45.640 7,066.75 Subtotal: 84,856.00 84,856.00 4,902.78 26,839.09 31.629 58,016.91 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 17,749.35 98,691.35 65.794 51,308.65 135-69007-020-000 LTD Payment from WW Sales 357,538.00 295,933.00 295,933.00 135-69008-020-000 Short Term Debt-Principal 56,991.00 56,991.00 21,000.00 21,000.00 36.848 35,991.00 135-69009-020-000 Short Term Debt-Interest 2,011.00 2,011.00 393.23 393.23 19.554 1,617.77 Subtotal: 566,540.00 504,935.00 39,142.58 120,084.58 23.782 384,850.42 Program number: 1,462,117.00 1,400,512.00 135,847.91 564,622.89 40.315 835,889.11 Department number: Wastewater 1,462,117.00 1,400,512.00 135,847.91 564,622.89 40.315 835,889.11 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 500.00 6,300.00 63.000 3,700.00 135-50030-026-000 Social Security Taxes 620.00 620.00 31.00 390.60 63.000 229.40 135-50035-026-000 Medicare Taxes 145.00 145.00 7.25 91.35 63.000 53.65 135-50040-026-000 Unemployment Taxes 230.00 230.00 74.92- 58.48 25.426 171.52 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 17.64 49.000 18.36 Subtotal: 11,031.00 11,031.00 466.27 6,858.07 62.171 4,172.93 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 1,200.00 176.24 14.687 1,023.76 135-60080-026-000 Schools & Training 4,000.00 4,000.00 150.00- 1,330.00 33.250 2,670.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,329.96 26.599 3,670.04 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,624.74 162.474 624.74- Subtotal: 11,850.00 11,850.00 150.00- 4,495.94 37.940 7,354.06 Program number: 22,881.00 22,881.00 316.27 11,354.01 49.622 11,526.99 Department number: Board of Directors 22,881.00 22,881.00 316.27 11,354.01 49.622 11,526.99 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 477,578.00 477,578.00 35,203.72 216,603.17 45.355 260,974.83 135-50010-030-000 Overtime 1,000.00 1,000.00 323.32 411.11 41.111 588.89 135-50016-030-000 Longevity 3,283.00 3,283.00 3,282.50 99.985 .50 135-50020-030-000 Retirement 42,840.00 42,840.00 3,165.45 19,696.11 45.976 23,143.89 135-50026-030-000 Medical Insurance 65,015.00 65,015.00 4,915.06 28,045.20 43.137 36,969.80 135-50027-030-000 Dental Insurance 4,944.00 4,944.00 364.24 2,006.28 40.580 2,937.72 135-50028-030-000 Vision Insurance 1,158.00 1,158.00 84.38 472.59 40.811 685.41 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 365.70 2,143.77 49.475 2,189.23 135-50030-030-000 Social Security Taxes 30,079.00 30,079.00 2,079.46 12,949.66 43.052 17,129.34 135-50035-030-000 Medicare Taxes 7,422.00 7,422.00 486.32 3,028.52 40.805 4,393.48 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 1,240.03- 204.19 14.092 1,244.81 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 523.80 32.017 1,112.20 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 38.00 7.600 462.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 2,261.64 45.233 2,738.36 Subtotal: 646,237.00 646,237.00 45,834.92 291,666.54 45.133 354,570.46 135-55030-030-000 Software & Support 75,588.00 87,423.00 21,108.49 92,779.89 106.128 5,356.89- 135-55070-030-000 Independent Labor 8,000.00 32,550.00 16,755.00 25,800.00 79.263 6,750.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 352.69 3,413.70 52.518 3,086.30 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 1,255.06 3,765.18 46.484 4,334.82 135-55160-030-000 Professional Outside Services 58,000.00 58,000.00 24,575.00- 16,599.95 28.621 41,400.05 135-55161-030-000 Town Personnel Contract 6,170.00 26,170.00 6,170.00 26,170.00 100.000 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 762.50 3,182.30 38.809 5,017.70 Subtotal: 175,258.00 231,643.00 21,828.74 171,711.02 74.127 59,931.98 135-60005-030-000 Telephone 13,361.00 13,361.00 1,000.37 5,654.42 42.320 7,706.58 135-60010-030-000 Communications/Pagers/Mobiles 4,056.00 4,056.00 364.21 2,041.82 50.341 2,014.18 135-60020-030-000 Electricity/Gas 14,978.00 14,978.00 1,050.09 3,668.68 24.494 11,309.32 135-60025-030-000 Water 1,500.00 1,500.00 56.30 434.58 28.972 1,065.42 135-60035-030-000 Postage 28,500.00 28,500.00 4,200.90 13,949.80 48.947 14,550.20 135-60040-030-000 Service Charges & Fees 32,000.00 32,000.00 3,364.15 21,132.77 66.040 10,867.23 135-60050-030-000 Bad Debt Expense 6,200.00 6,200.00 980.67 1,284.11 20.711 4,915.89 135-60055-030-000 Insurance 48,751.00 48,751.00 4,113.01 24,511.31 50.279 24,239.69 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,223.77 122.377 223.77- 135-60070-030-000 Dues & Memberships 5,000.00 5,000.00 4,055.95 81.119 944.05 135-60075-030-000 Meetings 400.00 400.00 60.11 15.028 339.89 135-60079-030-000 Public Education 5,000.00 5,000.00 2,751.60 3,384.79 67.696 1,615.21 135-60080-030-000 Schools & Training 10,235.00 10,235.00 2,688.00 26.263 7,547.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 166.16 748.34 13.858 4,651.66 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 1,764.81 2,004.09 80.164 495.91 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 3,436.38 19.636 14,063.62 135-60270-030-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 135-60360-030-000 Furniture/Equipment < $5000 10,475.00 10,475.00 5,035.96 48.076 5,439.04 Subtotal: 218,406.00 218,406.00 19,812.27 95,314.88 43.641 123,091.12 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,043.00 56.226 812.00 135-65055-030-000 Hardware 75,966.00 35,226.00 33,885.23 96.194 1,340.77 135-65085-030-000 Office Supplies 9,000.00 9,000.00 1,003.72 3,916.39 43.515 5,083.61 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 1,139.30 24.077 3,592.70 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 385.55 2,226.42 44.528 2,773.58 135-65097-030-000 Vending Machine Supplies 200.00 200.00 200.00 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 Subtotal: 101,553.00 60,813.00 1,389.27 42,210.34 69.410 18,602.66 135-69005-030-000 Capital Outlays 125,000.00 67,000.00 95.00 61,821.66 92.271 5,178.34 135-69170-030-000 Copier Lease Installments 4,236.00 4,236.00 371.67 1,658.14 39.144 2,577.86 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 16,329.00 16,329.00 100.000 Subtotal: 145,565.00 87,565.00 466.67 79,808.80 91.142 7,756.20 Program number: 1,287,019.00 1,244,664.00 89,331.87 680,711.58 54.690 563,952.42 Department number: Administration 1,287,019.00 1,244,664.00 89,331.87 680,711.58 54.690 563,952.42 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 08:12 04/16/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 250,000.00 300,000.00 57,263.04 392,340.29 130.780 92,340.29- 135-55055-039-000 Auditing 22,491.00 22,491.00 16,836.00 74.857 5,655.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 1,882.21 6,081.95 60.820 3,918.05 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,456.40 64.642 1,343.60 Subtotal: 286,291.00 336,291.00 59,145.25 417,714.64 124.212 81,423.64- Program number: 286,291.00 336,291.00 59,145.25 417,714.64 124.212 81,423.64- Department number: Non Departmental 286,291.00 336,291.00 59,145.25 417,714.64 124.212 81,423.64- Expenditures Subtotal ----------- 8,444,333.00 8,478,933.00 601,172.99 3,131,572.09 36.934 5,347,360.91 Fund number: 135 MUD 1 General Fund 242,298.00 816,878.03- 816,878.03 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 08:12 04/16/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 91,329.00- 91,329.00 137-49146-000-000 Intergov Transfer-Fire Dept 17,950.00- 17,950.00 Subtotal: 109,279.00- 109,279.00 Program number: 109,279.00- 109,279.00 Department number: 109,279.00- 109,279.00 Revenues Subtotal ----------- 109,279.00- 109,279.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 08:12 04/16/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-030-000 GASB Replacement 74,706.00 74,706.00- Subtotal: 74,706.00 74,706.00- Program number: 74,706.00 74,706.00- Department number: Administration 74,706.00 74,706.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 08:12 04/16/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-045-000 GASB Replacement 125,670.00 125,670.00- Subtotal: 125,670.00 125,670.00- Program number: 125,670.00 125,670.00- Department number: Fire Department 125,670.00 125,670.00- Expenditures Subtotal ----------- 200,376.00 200,376.00- Fund number: 137 MUD 1 Consolidated GASB 91,097.00 91,097.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 08:12 04/16/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income .93- 6.76- 6.76 Subtotal: .93- 6.76- 6.76 Program number: .93- 6.76- 6.76 Department number: .93- 6.76- 6.76 Revenues Subtotal ----------- .93- 6.76- 6.76 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 08:12 04/16/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Subtotal: 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Program number: 3 Indian Creek Waterline 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Department number: Water 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Expenditures Subtotal ----------- 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Fund number: 507 MUD 1 Capital Projects 3,348.00 3,348.00 .93- 2,243.24 67.002 1,104.76 . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 1147 03/02/2015 Property Taxes/Assessments (161,858.22) (978.02) (162,836.24) GL 1148 03/03/2015 Property Taxes/Assessments (164.32) (163,000.56) GL 1149 03/04/2015 Property Taxes/Assessments (179.52) (163,180.08) GL 1150 03/06/2015 Property Taxes/Assessments (20.75) (163,200.83) GL 1151 03/09/2015 Property Taxes/Assessments (9.47) (163,210.30) GL 1152 03/10/2015 Property Taxes/Assessments (18.71) (163,229.01) GL 1153 03/11/2015 Property Taxes/Assessments (175.12) (163,404.13) GL 1154 03/12/2015 Property Taxes/Assessments (172.61) (163,576.74) GL 1155 03/13/2015 Property Taxes/Assessments (68.50) (163,645.24) GL 1156 03/16/2015 Property Taxes/Assessments (147.01) (163,792.25) GL 1157 03/17/2015 Property Taxes/Assessments (16.58) (163,808.83) GL 1158 03/18/2015 Property Taxes/Assessments (105.30) (163,914.13) GL 1160 03/19/2015 Property Taxes/Assessments (41.78) (163,955.91) GL 1161 03/20/2015 Property Taxes/Assessments (6.24) (163,962.15) GL 1173 03/20/2015 Rev Property Taxes/Assessments 6.24 (163,955.91) GL 1174 03/20/2015 Property Taxes/Assessments (2.53) (163,958.44) GL 1162 03/23/2015 Property Taxes/Assessments (10.95) (163,969.39) GL 1163 03/24/2015 Property Taxes/Assessments (34.07) (164,003.46) GL 1164 03/25/2015 Property Taxes/Assessments (74.30) (164,077.76) GL 1165 03/26/2015 Property Taxes/Assessments (62.21) (164,139.97) GL 1172 03/26/2015 Rev Property Taxes/Assessments 62.21 (164,077.76) GL 1175 03/26/2015 Property Taxes/Assessments (17.63) (164,095.39) GL 1166 03/27/2015 Property Taxes/Assessments (70.36) (164,165.75) GL 1167 03/30/2015 Property Taxes/Assessments (224.19) (164,389.94) GL 1168 03/31/2015 Property Taxes/Assessments (58.82) (164,448.76) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (2,590.54) (164,448.76) ** (167,857.00) Budgeted (3,408.24) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1148 03/03/2015 Property Taxes/Assessments (399.16) (1.08) (400.24) GL 1154 03/12/2015 Property Taxes/Assessments (3.45) (403.69) GL 1174 03/20/2015 Property Taxes/Assessments 2.34 (401.35) GL 1162 03/23/2015 Property Taxes/Assessments (4.67) (406.02) GL 1163 03/24/2015 Property Taxes/Assessments 4.67 (401.35) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (2.19) (401.35) ** .00 Budgeted 401.35 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1147 03/02/2015 Property Taxes/Assessments (272.18) (4.84) (277.02) GL 1148 03/03/2015 Property Taxes/Assessments (11.77) (288.79) GL 1149 03/04/2015 Property Taxes/Assessments (12.01) (300.80) GL 1151 03/09/2015 Property Taxes/Assessments (.85) (301.65) GL 1152 03/10/2015 Property Taxes/Assessments (.84) (302.49) GL 1153 03/11/2015 Property Taxes/Assessments (10.03) (312.52) GL 1154 03/12/2015 Property Taxes/Assessments (14.01) (326.53) GL 1155 03/13/2015 Property Taxes/Assessments (5.50) (332.03) GL 1156 03/16/2015 Property Taxes/Assessments (5.54) (337.57) GL 1157 03/17/2015 Property Taxes/Assessments (.59) (338.16) GL 1158 03/18/2015 Property Taxes/Assessments (7.39) (345.55) GL 1160 03/19/2015 Property Taxes/Assessments (.39) (345.94) GL 1161 03/20/2015 Property Taxes/Assessments 6.05 (339.89) GL 1173 03/20/2015 Rev Property Taxes/Assessments (6.05) (345.94) GL 1162 03/23/2015 Property Taxes/Assessments (1.59) (347.53) GL 1163 03/24/2015 Property Taxes/Assessments .19 (347.34) GL 1164 03/25/2015 Property Taxes/Assessments (5.62) (352.96) GL 1165 03/26/2015 Property Taxes/Assessments 41.51 (311.45) GL 1172 03/26/2015 Rev Property Taxes/Assessments (41.51) (352.96) GL 1175 03/26/2015 Property Taxes/Assessments (3.07) (356.03) GL 1167 03/30/2015 Property Taxes/Assessments (14.44) (370.47) GL 1168 03/31/2015 Property Taxes/Assessments (4.39) (374.86) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (102.68) (374.86) ** (900.00) Budgeted (525.14) Remaining 42 % Used Account: 135-40025-000-000 PID Surcharges 1114 03/31/2015 UB 3/31/15 Billing UB20150331-20150331 User: (57,307.10) (11,676.80) (68,983.90) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (11,676.80) (68,983.90) ** (133,997.00) Budgeted (65,013.10) Remaining 51 % Used Account: 135-47000-000-000 Water 1106 03/18/2015 UB 3/18/15 bill adj UB20150318-20150318 User: (1,205,575.41) 51.16 (1,205,524.25) UB 1114 03/31/2015 UB 3/31/15 Billing UB20150331-20150331 User: (168,963.47) (1,374,487.72) UB _______________ Account: 135-47000-000-000 Water Totals: (168,912.31) (1,374,487.72) ** (5,286,045.00) Budgeted (3,911,557.28) Remaining 26 % Used Account: 135-47005-000-000 Sewer . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1106 03/18/2015 UB 3/18/15 bill adj UB20150318-20150318 User: (786,314.45) (45.12) (786,359.57) UB 1114 03/31/2015 UB 3/31/15 Billing UB20150331-20150331 User: (128,307.49) (914,667.06) UB _______________ Account: 135-47005-000-000 Sewer Totals: (128,352.61) (914,667.06) ** (2,270,982.00) Budgeted (1,356,314.94) Remaining 40 % Used Account: 135-47025-000-000 Penalties 1076 03/02/2015 UB 3/2/15 Adj UB20150302-20150302 User: (41,219.12) 234.47 (40,984.65) UB 1104 03/05/2015 UB 3/5/15 adj UB20150305-20150305 User: 129.71 (40,854.94) UB 1091 03/11/2015 UB 3/11/15 UB20150311-20150311 User: 1,252.70 (39,602.24) UB 1092 03/12/2015 UB 3/12/15 Adj UB20150312-20150312 User: 130.16 (39,472.08) UB 1105 03/15/2015 UB 3/15/15 penaltie UB20150315-20150315 User: 237.83 (39,234.25) UB 1108 03/20/2015 UB 3/20/15 penalities UB20150320-20150320 User: 44.99 (39,189.26) UB 1062 03/23/2015 UB 3/23/15 Penalty Removals UB20150323-20150323 User: 91.29 (39,097.97) UB 1065 03/23/2015 03/23/15 UB penalties UB20150323-20150323 User: (7,432.23) (46,530.20) UB 1111 03/27/2015 UB 3/27/15 adj UB20150327-20150327 User: 50.81 (46,479.39) UB 1112 03/31/2015 UB 3/31/15 Penalties UB20150331-20150331 User: 60.40 (46,418.99) UB _______________ Account: 135-47025-000-000 Penalties Totals: (5,199.87) (46,418.99) ** (63,416.00) Budgeted (16,997.01) Remaining 73 % Used Account: 135-47030-000-000 Service Charges 1076 03/02/2015 UB 3/2/15 Adj UB20150302-20150302 User: (5,040.00) 25.00 (5,015.00) UB 980 03/11/2015 UB 03/11/15 Disconnect Fees UB20150311-20150311 User: (750.00) (5,765.00) UB 1199 03/23/2015 UB 3/23/15 NSF Fee UB20150323-20150323 User: (25.00) (5,790.00) UB 1114 03/31/2015 UB 3/31/15 Billing UB20150331-20150331 User: (3.00) (5,793.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (753.00) (5,793.00) ** (8,000.00) Budgeted (2,207.00) Remaining 72 % Used Account: 135-47035-000-000 Plumbing Inspections 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: (1,300.00) (50.00) (1,350.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (50.00) (1,350.00) ** (2,000.00) Budgeted (650.00) Remaining 68 % Used Account: 135-47045-000-000 Sewer Inspections 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: (3,900.00) (150.00) (4,050.00) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (4,050.00) ** (5,000.00) Budgeted (950.00) Remaining 81 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1114 03/31/2015 UB 3/31/15 Billing UB20150331-20150331 User: (13,955.20) (590.10) (14,545.30) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (590.10) (14,545.30) ** (86,815.00) Budgeted (72,269.70) Remaining 17 % Used Account: 135-48005-000-000 Utility Fees 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: (78,200.00) (27,600.00) (105,800.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (27,600.00) (105,800.00) ** (184,000.00) Budgeted (78,200.00) Remaining 58 % Used Account: 135-49010-000-000 Interest Income 1139 03/31/2015 Bank Interest/March (2,579.06) (36.99) (2,616.05) GL 1139 03/31/2015 Bank Interest/March (109.51) (2,725.56) GL 1139 03/31/2015 Bank Interest/March (338.89) (3,064.45) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (485.39) (3,064.45) ** (5,000.00) Budgeted (1,935.55) Remaining 61 % Used Account: 135-49016-000-000 Cell Tower Revenue 1188 03/04/2015 AT&T/Cell tower lease (4,552.65) (910.53) (5,463.18) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (5,463.18) ** (10,164.00) Budgeted (4,700.82) Remaining 54 % Used Account: 135-49018-000-000 Building Rent Income 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: (2,916.65) (583.33) (3,499.98) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (3,499.98) ** (7,000.00) Budgeted (3,500.02) Remaining 50 % Used Account: 135-49030-000-000 Vending Revenue . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 .00 ** (351.00) Budgeted (351.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves (74,706.00) .00 (74,706.00) _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 (74,706.00) ** (74,706.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: (24,195.83) (4,802.00) (28,997.83) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,802.00) (28,997.83) ** (84,000.00) Budgeted (55,002.17) Remaining 35 % Used Account: 135-49141-000-000 Interfund Transfer In 1028 03/17/2015 Recode Hardware sale of assets Recode Hardware sale of assets (19,606.50) (19,606.50) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: (19,606.50) (19,606.50) ** .00 Budgeted 19,606.50 Remaining 0 % Used Account: 135-49145-000-000 Intergov Transfer In (1,074,337.15) .00 (1,074,337.15) _______________ Account: 135-49145-000-000 Intergov Transfer In Totals: .00 (1,074,337.15) ** .00 Budgeted 1,074,337.15 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1187 03/04/2015 Atlas Util/Waterfest donation (50,934.75) (150.00) (51,084.75) GL 1189 03/11/2015 CNA/THB Construction (17,735.88) (68,820.63) GL 1190 03/11/2015 DataProse/Waterfest donation (150.00) (68,970.63) GL 1028 03/17/2015 Recode Hardware sale of assets Recode Hardware sale of assets 19,606.50 (49,364.13) GL 1090 03/30/2015 Mar A/P Crane Truck repair 11,946.58 (37,417.55) Classic Chevrolet Inc. 34780 AP 1114 03/31/2015 UB 3/31/15 Billing UB20150331-20150331 User: (24.34) (37,441.89) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: 13,492.86 (37,441.89) ** (88,600.00) Budgeted (51,158.11) Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49901-000-000 Records Management Revenue (12.20) .00 (12.20) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (12.20) ** (100.00) Budgeted (87.80) Remaining 12 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,948,450.12) ** (8,478,933.00) Budgeted (4,530,482.88) Remaining 47 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 970 03/13/2015 3-13-15 Payroll Salaries & Wages 74,924.69 8,594.47 83,519.16 PR 1069 03/27/2015 MUD Payroll 3/27/15 Salaries & Wages 8,594.47 92,113.63 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 17,188.94 92,113.63 ** 301,101.00 Budgeted 208,987.37 Remaining 31 % Used Account: 135-50010-010-000 Overtime 970 03/13/2015 3-13-15 Payroll Overtime 5,013.94 307.29 5,321.23 PR 1069 03/27/2015 MUD Payroll 3/27/15 Overtime 1,152.25 6,473.48 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,459.54 6,473.48 ** 19,500.00 Budgeted 13,026.52 Remaining 33 % Used Account: 135-50016-010-000 Longevity 2,705.00 .00 2,705.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,705.00 ** 5,343.00 Budgeted 2,638.00 Remaining 51 % Used Account: 135-50017-010-000 Certification 1069 03/27/2015 MUD Payroll 3/27/15 Certification 1,150.00 225.00 1,375.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 1,375.00 ** 4,800.00 Budgeted 3,425.00 Remaining 29 % Used Account: 135-50020-010-000 Retirement 970 03/13/2015 3-13-15 Payroll Retirement 7,497.38 793.15 8,290.53 PR 1069 03/27/2015 MUD Payroll 3/27/15 Retirement 888.48 9,179.01 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,681.63 9,179.01 ** 29,349.00 Budgeted 20,169.99 Remaining 31 % Used Account: 135-50026-010-000 Medical Insurance 970 03/13/2015 3-13-15 Payroll Medical Insurance 10,290.39 1,634.55 11,924.94 PR 1069 03/27/2015 MUD Payroll 3/27/15 Medical Insurance 1,634.50 13,559.44 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,269.05 13,559.44 ** 44,988.00 Budgeted 31,428.56 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 970 03/13/2015 3-13-15 Payroll Dental Insurance 819.26 133.99 953.25 PR 1069 03/27/2015 MUD Payroll 3/27/15 Dental Insurance 133.99 1,087.24 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 267.98 1,087.24 ** 3,288.00 Budgeted 2,200.76 Remaining 33 % Used Account: 135-50028-010-000 Vision Insurance 970 03/13/2015 3-13-15 Payroll Vision Insurance 192.59 29.94 222.53 PR 1069 03/27/2015 MUD Payroll 3/27/15 Vision Insurance 29.98 252.51 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 59.92 252.51 ** 834.00 Budgeted 581.49 Remaining 30 % Used Account: 135-50029-010-000 Life Insurance & Other 873 03/01/2015 Mar A/P 734.51 186.38 920.89 AP 1141 03/31/2015 Mar A/P Café 125 Admin 8.44 929.33 BenefitMall 34792 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 194.82 929.33 ** 3,074.00 Budgeted 2,144.67 Remaining 30 % Used Account: 135-50030-010-000 Social Security Taxes 970 03/13/2015 3-13-15 Payroll Social Security Taxes 5,150.42 538.28 5,688.70 PR 1069 03/27/2015 MUD Payroll 3/27/15 Social Security Taxes 600.55 6,289.25 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,138.83 6,289.25 ** 21,135.00 Budgeted 14,845.75 Remaining 30 % Used Account: 135-50035-010-000 Medicare Taxes 970 03/13/2015 3-13-15 Payroll Medicare Taxes 1,204.55 125.87 1,330.42 PR 1069 03/27/2015 MUD Payroll 3/27/15 Medicare Taxes 140.46 1,470.88 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 266.33 1,470.88 ** 4,943.00 Budgeted 3,472.12 Remaining 30 % Used Account: 135-50040-010-000 Unemployment Taxes 970 03/13/2015 3-13-15 Payroll Unemployment Taxes 754.04 (642.99) 111.05 PR 1070 03/24/2015 P/R run for TWC rate change Unemployment Taxes (53.18) 57.87 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1211 03/31/2015 TWC Adj due to rate change 754.04 (29.83) 28.04 GL _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: (726.00) 28.04 ** 1,242.00 Budgeted 1,213.96 Remaining 2 % Used Account: 135-50045-010-000 Workman's Compensation 196 03/01/2015 Mar TML Ins & Workers Comp 2,969.55 857.91 3,827.46 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.91 3,827.46 ** 16,020.00 Budgeted 12,192.54 Remaining 24 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1042 03/19/2015 Mar A/P Pre-employment testing/Rainey 586.85 141.45 728.30 FIRST CHECK APPLICANT SCREENIN 34747 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 141.45 728.30 ** 1,000.00 Budgeted 271.70 Remaining 73 % Used Account: 135-50070-010-000 Employee Relations 1128 03/26/2015 2/27-3/26/15 PCards WHATABURGER 754 Q26 22.86 19.50 42.36 WHATABURGER 754 Q26 PC 1128 03/26/2015 2/27-3/26/15 PCards WHATABURGER 754 Q26 49.84 92.20 WHATABURGER 754 Q26 PC 1128 03/26/2015 2/27-3/26/15 PCards WHATABURGER 754 Q26 20.26 112.46 WHATABURGER 754 Q26 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 89.60 112.46 ** 300.00 Budgeted 187.54 Remaining 37 % 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 1042 03/19/2015 Mar A/P Resetter, compressions, gasket 27,755.24 731.72 28,486.96 HD SUPPLY WATERWORKS, LTD. 34751 AP 1042 03/19/2015 Mar A/P Repair VFD motor at Water plan 2,475.00 30,961.96 PEMSCO 34765 AP 1128 03/26/2015 2/27-3/26/15 PCards THE HOME DEPOT 6581 149.34 31,111.30 THE HOME DEPOT 6581 PC 1128 03/26/2015 2/27-3/26/15 PCards THE HOME DEPOT 6581 27.81 31,139.11 THE HOME DEPOT 6581 PC 1128 03/26/2015 2/27-3/26/15 PCards HD SUPPLY FACILITIES M (27.40) 31,111.71 HD SUPPLY FACILITIES M PC 1128 03/26/2015 2/27-3/26/15 PCards THE HOME DEPOT 6581 190.00 31,301.71 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1128 03/26/2015 2/27-3/26/15 PCards THE HOME DEPOT 6581 27,755.24 20.54 31,322.25 THE HOME DEPOT 6581 PC 1128 03/26/2015 2/27-3/26/15 PCards SC TRACKING SOLUTIONS 54.75 31,377.00 SC TRACKING SOLUTIONS PC 1128 03/26/2015 2/27-3/26/15 PCards TRACTOR SUPPLY COMPANY 179.98 31,556.98 TRACTOR SUPPLY COMPANY PC 1128 03/26/2015 2/27-3/26/15 PCards ROANOKE WINNELSON CO 48.80 31,605.78 ROANOKE WINNELSON CO PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON MKTPLACE PMTS 47.95 31,653.73 AMAZON MKTPLACE PMTS PC 1141 03/31/2015 Mar A/P Meter boxes 492.16 32,145.89 HD SUPPLY WATERWORKS, LTD. 34808 AP 1141 03/31/2015 Mar A/P Meter Boxes with lids 1,098.20 33,244.09 HD SUPPLY WATERWORKS, LTD. 34808 AP 1141 03/31/2015 Mar A/P Traffic Cones 258.00 33,502.09 HD SUPPLY WATERWORKS, LTD. 34808 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 5,746.85 33,502.09 ** 71,242.00 Budgeted 37,739.91 Remaining 47 % Used Account: 135-55090-010-000 Vehicle Maintenance 1042 03/19/2015 Mar A/P Truck 105/Intake Manifold, Val 2,439.46 962.12 3,401.58 MICHAEL G. WATSON 34760 AP 1128 03/26/2015 2/27-3/26/15 PCards KWIK KAR LUBE & TUNE O 208.83 3,610.41 KWIK KAR LUBE & TUNE O PC 1141 03/31/2015 Mar A/P Fuse pac and fuses 4.20 3,614.61 NAPA AUTO PARTS 34822 AP 1141 03/31/2015 Mar A/P Vehicle Registration Renewal U 22.00 3,636.61 DENTON COUNTY TAX OFFICE 34801 AP 1141 03/31/2015 Mar A/P Vehicle Registration Renewal U 14.25 3,650.86 DENTON COUNTY TAX OFFICE 34800 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,211.40 3,650.86 ** 8,000.00 Budgeted 4,349.14 Remaining 46 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 243.00 .00 243.00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 243.00 ** 3,500.00 Budgeted 3,257.00 Remaining 7 % Used Account: 135-55135-010-000 Lab Analysis 1042 03/19/2015 Mar A/P Testing/MUD 1,260.26 375.00 1,635.26 TARRANT CTY PUBLIC HEALTH LAB 34769 AP 1141 03/31/2015 Mar A/P Testing 195.26 1,830.52 LOWER COLORADO RIVER AUTHORITY 34817 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 570.26 1,830.52 ** 5,500.00 Budgeted 3,669.48 Remaining 33 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1042 03/19/2015 Mar A/P Cell phones 1,506.91 439.73 1,946.64 VERIZON WIRELESS 34776 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 439.73 1,946.64 ** 4,913.00 Budgeted 2,966.36 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 1141 03/31/2015 Mar A/P Electricity 2/11-36/12/15 45,099.08 2,907.04 48,006.12 HUDSON ENERGY SERVICES, LLC 34809 AP 1141 03/31/2015 Mar A/P Electricity 12/10/14-1/9/15 69.41 48,075.53 HUDSON ENERGY SERVICES, LLC 34809 AP 1141 03/31/2015 Mar A/P Electricity 1/9-2/10/15 145.55 48,221.08 HUDSON ENERGY SERVICES, LLC 34809 AP 1141 03/31/2015 Mar A/P Electricity 2/10-3/11/15 282.50 48,503.58 HUDSON ENERGY SERVICES, LLC 34809 AP 1141 03/31/2015 Mar A/P Electricity 2/11-3/12/15 5,699.46 54,203.04 HUDSON ENERGY SERVICES, LLC 34809 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,103.96 54,203.04 ** 170,765.00 Budgeted 116,561.96 Remaining 32 % 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 1128 03/26/2015 2/27-3/26/15 PCards STAR DALLAS LOT 7 485.00 2.00 487.00 STAR DALLAS LOT 7 PC 1128 03/26/2015 2/27-3/26/15 PCards SUNCOAST LEARNING SYST 235.00 722.00 SUNCOAST LEARNING SYST PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 237.00 722.00 ** 4,138.00 Budgeted 3,416.00 Remaining 17 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 1124 03/31/2015 Recode TCEQ PID Water Sys Fee 21,024.06 (2,418.75) 18,605.31 GL _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: (2,418.75) 18,605.31 ** 49,275.00 Budgeted 30,669.69 Remaining 38 % Used Account: 135-60150-010-000 Wholesale Water 1141 03/31/2015 Mar A/P Wholesale Water/February 576,164.95 108,302.19 684,467.14 CITY OF FORT WORTH 34798 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 108,302.19 684,467.14 ** 2,928,308.00 Budgeted 2,243,840.86 Remaining 23 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 1128 03/26/2015 2/27-3/26/15 PCards DENTON SAND & GRAVEL, 881.71 108.00 989.71 DENTON SAND & GRAVEL, PC 1128 03/26/2015 2/27-3/26/15 PCards DENTON SAND & GRAVEL, 48.00 1,037.71 DENTON SAND & GRAVEL, PC 1128 03/26/2015 2/27-3/26/15 PCards MICHAEL'S KEYS 143.00 1,180.71 MICHAEL'S KEYS PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 299.00 1,180.71 ** 3,500.00 Budgeted 2,319.29 Remaining 34 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 1141 03/31/2015 Mar A/P March fuel 5,094.36 761.84 5,856.20 US Bank Voyager Fleet Systems 34836 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 761.84 5,856.20 ** 29,172.00 Budgeted 23,315.80 Remaining 20 % Used Account: 135-65010-010-000 Uniforms 1128 03/26/2015 2/27-3/26/15 PCards RON MONTGOMERY & ASSOC 1,360.14 947.63 2,307.77 RON MONTGOMERY & ASSOC PC _______________ Account: 135-65010-010-000 Uniforms Totals: 947.63 2,307.77 ** 3,620.00 Budgeted 1,312.23 Remaining 64 % Used Account: 135-65030-010-000 Chemicals 1042 03/19/2015 Mar A/P Chlorine, monochlor reagent pa 4,059.36 489.14 4,548.50 HACH COMPANY 34749 AP 1042 03/19/2015 Mar A/P Hardness Treatment 67.77 4,616.27 HACH COMPANY 34749 AP 1141 03/31/2015 Mar A/P Testing Supplies 225.36 4,841.63 HD SUPPLY WATERWORKS, LTD. 34808 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 782.27 4,841.63 ** 7,000.00 Budgeted 2,158.37 Remaining 69 % Used Account: 135-65035-010-000 Small Tools 68.37 .00 68.37 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 68.37 ** 1,200.00 Budgeted 1,131.63 Remaining 6 % Used Account: 135-65040-010-000 Safety Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 277.01 .00 277.01 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 277.01 ** 1,000.00 Budgeted 722.99 Remaining 28 % Used Account: 135-65050-010-000 Meter Expense 1042 03/19/2015 Mar A/P Weill #1 Meter 17,748.84 2,361.00 20,109.84 ATLAS UTILITY SUPPLY CO. 34738 AP 1042 03/19/2015 Mar A/P Change out meters/Golf course, 5,955.00 26,064.84 ATLAS UTILITY SUPPLY CO. 34738 AP 1191 03/20/2015 Willbros T&D/fire hydrant mete (1,155.00) 24,909.84 GL _______________ Account: 135-65050-010-000 Meter Expense Totals: 7,161.00 24,909.84 ** 161,500.00 Budgeted 136,590.16 Remaining 15 % Used Account: 135-69005-010-000 Capital Outlays 1141 03/31/2015 Mar A/P Valve replacement at water pla 125,361.45 13,809.64 139,171.09 REY-MAR CONSTRUCTION 34829 AP 1141 03/31/2015 Mar A/P Lights for Unit 107 F350 1,295.00 140,466.09 PROFESSIONAL SAFETY SYSTEMS 34828 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 15,104.64 140,466.09 ** 1,177,566.00 Budgeted 1,037,099.91 Remaining 12 % Used Account: 135-69008-010-000 Short Term Debt-Principal 873 03/01/2015 Mar A/P Principal/Interest 445K note 129,000.00 129,000.00 FIRST FINANCIAL BANK 34684 AP _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: 129,000.00 129,000.00 ** 129,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 873 03/01/2015 Mar A/P Principal/Interest 445K note 2,415.58 2,415.58 FIRST FINANCIAL BANK 34684 AP _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: 2,415.58 2,415.58 ** 3,612.00 Budgeted 1,196.42 Remaining 67 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69281-010-000 Water Tank Inspection Contract 1042 03/19/2015 Mar A/P Pax Mixers Pmt 1 of 3 118,774.42 8,183.34 126,957.76 UTILITY SERVICE CO, INC. 34775 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 8,183.34 126,957.76 ** 151,507.00 Budgeted 24,549.24 Remaining 84 % Used Account: 135-55135-010-001 Lab Analysis for PID 1042 03/19/2015 Mar A/P Testing/PID 2,017.63 150.00 2,167.63 TARRANT CTY PUBLIC HEALTH LAB 34769 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 150.00 2,167.63 ** 5,000.00 Budgeted 2,832.37 Remaining 43 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID 1124 03/31/2015 Recode TCEQ PID Water Sys Fee 2,418.75 2,418.75 GL _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: 2,418.75 2,418.75 ** 5,000.00 Budgeted 2,581.25 Remaining 48 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,457,168.97 ** 5,474,585.00 Budgeted 4,017,416.03 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 970 03/13/2015 3-13-15 Payroll Salaries & Wages 118,445.57 11,594.95 130,040.52 PR 1069 03/27/2015 MUD Payroll 3/27/15 Salaries & Wages 11,590.89 141,631.41 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 23,185.84 141,631.41 ** 305,744.00 Budgeted 164,112.59 Remaining 46 % Used Account: 135-50010-020-000 Overtime 970 03/13/2015 3-13-15 Payroll Overtime 11,731.01 777.54 12,508.55 PR 1069 03/27/2015 MUD Payroll 3/27/15 Overtime 3,644.53 16,153.08 PR _______________ Account: 135-50010-020-000 Overtime Totals: 4,422.07 16,153.08 ** 19,500.00 Budgeted 3,346.92 Remaining 83 % Used Account: 135-50016-020-000 Longevity 5,615.00 .00 5,615.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 5,615.00 ** 5,617.00 Budgeted 2.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1069 03/27/2015 MUD Payroll 3/27/15 Certification 2,750.00 550.00 3,300.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 3,300.00 ** 6,600.00 Budgeted 3,300.00 Remaining 50 % Used Account: 135-50020-020-000 Retirement 970 03/13/2015 3-13-15 Payroll Retirement 12,396.06 1,102.38 13,498.44 PR 1069 03/27/2015 MUD Payroll 3/27/15 Retirement 1,406.49 14,904.93 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,508.87 14,904.93 ** 29,948.00 Budgeted 15,043.07 Remaining 50 % Used Account: 135-50026-020-000 Medical Insurance 970 03/13/2015 3-13-15 Payroll Medical Insurance 22,931.14 2,343.40 25,274.54 PR 1069 03/27/2015 MUD Payroll 3/27/15 Medical Insurance 2,343.35 27,617.89 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,686.75 27,617.89 ** 61,001.00 Budgeted 33,383.11 Remaining 45 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 970 03/13/2015 3-13-15 Payroll Dental Insurance 1,466.96 149.75 1,616.71 PR 1069 03/27/2015 MUD Payroll 3/27/15 Dental Insurance 149.76 1,766.47 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 299.51 1,766.47 ** 4,146.00 Budgeted 2,379.53 Remaining 43 % Used Account: 135-50028-020-000 Vision Insurance 970 03/13/2015 3-13-15 Payroll Vision Insurance 342.39 34.48 376.87 PR 1069 03/27/2015 MUD Payroll 3/27/15 Vision Insurance 34.52 411.39 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 69.00 411.39 ** 990.00 Budgeted 578.61 Remaining 42 % Used Account: 135-50029-020-000 Life Insurance & Other 873 03/01/2015 Mar A/P 1,377.47 251.35 1,628.82 AP 1141 03/31/2015 Mar A/P Café 125 Admin 33.78 1,662.60 BenefitMall 34792 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 285.13 1,662.60 ** 3,194.00 Budgeted 1,531.40 Remaining 52 % Used Account: 135-50030-020-000 Social Security Taxes 970 03/13/2015 3-13-15 Payroll Social Security Taxes 7,687.38 694.54 8,381.92 PR 1069 03/27/2015 MUD Payroll 3/27/15 Social Security Taxes 891.14 9,273.06 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,585.68 9,273.06 ** 21,680.00 Budgeted 12,406.94 Remaining 43 % Used Account: 135-50035-020-000 Medicare Taxes 970 03/13/2015 3-13-15 Payroll Medicare Taxes 1,797.84 162.44 1,960.28 PR 1069 03/27/2015 MUD Payroll 3/27/15 Medicare Taxes 208.40 2,168.68 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 370.84 2,168.68 ** 5,070.00 Budgeted 2,901.32 Remaining 43 % Used Account: 135-50040-020-000 Unemployment Taxes 970 03/13/2015 3-13-15 Payroll Unemployment Taxes 1,208.78 (1,046.78) 162.00 PR 1070 03/24/2015 P/R run for TWC rate change Unemployment Taxes (69.62) 92.38 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1211 03/31/2015 TWC Adj due to rate change 1,208.78 (40.10) 52.28 GL _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: (1,156.50) 52.28 ** 1,242.00 Budgeted 1,189.72 Remaining 4 % Used Account: 135-50045-020-000 Workman's Compensation 196 03/01/2015 Mar TML Ins & Workers Comp 2,969.55 857.91 3,827.46 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.91 3,827.46 ** 16,020.00 Budgeted 12,192.54 Remaining 24 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 126.00 .00 126.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 126.00 ** 150.00 Budgeted 24.00 Remaining 84 % Used Account: 135-50070-020-000 Employee Relations 1128 03/26/2015 2/27-3/26/15 PCards 7-ELEVEN 32921 444.77 6.50 451.27 7-ELEVEN 32921 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 6.50 451.27 ** 550.00 Budgeted 98.73 Remaining 82 % Used Account: 135-55080-020-000 Maintenance & Repairs 1042 03/19/2015 Mar A/P Emergency Sewer Line repairs 46,582.81 380.00 46,962.81 THE WALLACE GROUP, INC. 34771 AP 1042 03/19/2015 Mar A/P Repair Bay Door 230.00 47,192.81 OVERHEAD DOOR FORT WORTH 34763 AP 1042 03/19/2015 Mar A/P Nozzle, vacuum tube, clamps/Ga 749.85 47,942.66 CLS SEWER EQUIPMENT CO INC 34742 AP 1042 03/19/2015 Mar A/P Auger gearbox replacement 5,960.00 53,902.66 PETERSON PUMP & MOTOR SERVICE 34766 AP 1042 03/19/2015 Mar A/P Digester Blower motor #3 Insta 665.00 54,567.66 PETERSON PUMP & MOTOR SERVICE 34766 AP 1054 03/23/2015 Recode exp to Capital Outlay New AC and Heater (10,355.00) 44,212.66 GL 1054 03/23/2015 Recode exp to Capital Outlay New AC and Heater (612.35) 43,600.31 GL 1128 03/26/2015 2/27-3/26/15 PCards ATLAS UTILITY SUPPLY C 159.00 43,759.31 ATLAS UTILITY SUPPLY C PC 1128 03/26/2015 2/27-3/26/15 PCards ATLAS UTILITY SUPPLY C 528.00 44,287.31 ATLAS UTILITY SUPPLY C PC 1128 03/26/2015 2/27-3/26/15 PCards DAVIS MOTOR CRANE SRV 440.00 44,727.31 DAVIS MOTOR CRANE SRV PC 1141 03/31/2015 Mar A/P troubleshoot LS3 & 5 524.00 45,251.31 XYLEM WATER SOLUTIONS USA INC 34840 AP 1141 03/31/2015 Mar A/P 552 Indian Creek 7,184.08 52,435.39 REY-MAR CONSTRUCTION 34829 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 5,852.58 52,435.39 ** 58,000.00 Budgeted 5,564.61 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-020-000 Vehicle Maintenance 1054 03/23/2015 Recode exp to Capital Outlay Logos for Crane Truck 1,998.34 (95.00) 1,903.34 GL 1054 03/23/2015 Recode exp to Capital Outlay Running Boards for Crane Truck (850.00) 1,053.34 GL 1128 03/26/2015 2/27-3/26/15 PCards BLAGG TIRE & SERVICE 197.21 1,250.55 BLAGG TIRE & SERVICE PC 1128 03/26/2015 2/27-3/26/15 PCards AUTO TRUCK GROUP 1,040.54 2,291.09 AUTO TRUCK GROUP PC 1090 03/30/2015 Mar A/P Crane Truck repair 350.00 2,641.09 Classic Chevrolet Inc. 34780 AP 1141 03/31/2015 Mar A/P Chains for call truck 144.00 2,785.09 NAPA AUTO PARTS 34822 AP 1141 03/31/2015 Mar A/P Fuse pac and fuses 4.19 2,789.28 NAPA AUTO PARTS 34822 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 790.94 2,789.28 ** 3,000.00 Budgeted 210.72 Remaining 93 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 21.27 .00 21.27 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 21.27 ** 500.00 Budgeted 478.73 Remaining 4 % Used Account: 135-55125-020-000 Dumpster Services 1042 03/19/2015 Mar A/P Sludge Haul off 22,860.10 2,268.37 25,128.47 L.H. CHANEY MATERIALS, INC. 34757 AP 1042 03/19/2015 Mar A/P Sludge Haul off 2,396.69 27,525.16 L.H. CHANEY MATERIALS, INC. 34757 AP 1042 03/19/2015 Mar A/P Sludge Haul off 2,322.48 29,847.64 L.H. CHANEY MATERIALS, INC. 34757 AP 1141 03/31/2015 Mar A/P Sludge haul off 1,451.31 31,298.95 L.H. CHANEY MATERIALS, INC. 34812 AP 1141 03/31/2015 Mar A/P Sludge haul off 878.13 32,177.08 L.H. CHANEY MATERIALS, INC. 34812 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 9,316.98 32,177.08 ** 55,000.00 Budgeted 22,822.92 Remaining 59 % Used Account: 135-55135-020-000 Lab Analysis 1042 03/19/2015 Mar A/P Biomonitoring Project 9,095.50 1,080.00 10,175.50 HUTHER AND ASSOCIATES,INC 34753 AP 1042 03/19/2015 Mar A/P Testing 246.00 10,421.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 246.00 10,667.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 176.00 10,843.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 246.00 11,089.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 176.00 11,265.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 246.00 11,511.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 176.00 11,687.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 90.00 11,777.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 176.00 11,953.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 246.00 12,199.50 OXIDOR LABORATORIES LLC 34764 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1042 03/19/2015 Mar A/P Testing 9,095.50 176.00 12,375.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 246.00 12,621.50 OXIDOR LABORATORIES LLC 34764 AP 1042 03/19/2015 Mar A/P Testing 176.00 12,797.50 OXIDOR LABORATORIES LLC 34764 AP 1141 03/31/2015 Mar A/P Testing 246.00 13,043.50 OXIDOR LABORATORIES LLC 34825 AP 1141 03/31/2015 Mar A/P Testing 176.00 13,219.50 OXIDOR LABORATORIES LLC 34825 AP 1141 03/31/2015 Mar A/P Testing 246.00 13,465.50 OXIDOR LABORATORIES LLC 34825 AP 1141 03/31/2015 Mar A/P Testing 176.00 13,641.50 OXIDOR LABORATORIES LLC 34825 AP 1141 03/31/2015 Mar A/P Testing 246.00 13,887.50 OXIDOR LABORATORIES LLC 34825 AP 1141 03/31/2015 Mar A/P Testing 176.00 14,063.50 OXIDOR LABORATORIES LLC 34825 AP 1141 03/31/2015 Mar A/P Testing 246.00 14,309.50 OXIDOR LABORATORIES LLC 34825 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 5,214.00 14,309.50 ** 25,000.00 Budgeted 10,690.50 Remaining 57 % Used Account: 135-60010-020-000 Communications/Mobiles 1042 03/19/2015 Mar A/P Cell phones 1,979.58 659.93 2,639.51 VERIZON WIRELESS 34776 AP 1128 03/26/2015 2/27-3/26/15 PCards WM SUPERCENTER #1178 27.92 2,667.43 WM SUPERCENTER #1178 PC _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 687.85 2,667.43 ** 4,662.00 Budgeted 1,994.57 Remaining 57 % Used Account: 135-60020-020-000 Electricity 1005 03/16/2015 Void Hudson invoice 73607 Electricity 1/12-2/11/15 41,324.40 (260.18) 41,064.22 HUDSON ENERGY SERVICES, LLC AP 1042 03/19/2015 Mar A/P Electricity 1/29-2/27 250.37 41,314.59 TRI COUNTY ELECTRIC 34774 AP 1042 03/19/2015 Mar A/P Electricity 1/29-2/27 128.11 41,442.70 TRI COUNTY ELECTRIC 34774 AP 1042 03/19/2015 Mar A/P Electricity 1/29-2/27 27.78 41,470.48 TRI COUNTY ELECTRIC 34774 AP 1042 03/19/2015 Mar A/P Electricity 1/12-2/11/15 9,382.04 50,852.52 HUDSON ENERGY SERVICES, LLC 34752 AP 1042 03/19/2015 Mar A/P Electricity 1/12-2/11/15 557.14 51,409.66 HUDSON ENERGY SERVICES, LLC 34752 AP 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: (551.69) 50,857.97 AR 1141 03/31/2015 Mar A/P Electricity 2/10-3/11/15 57.39 50,915.36 HUDSON ENERGY SERVICES, LLC 34809 AP 1141 03/31/2015 Mar A/P Electricity 2/10-3/11/15 28.48 50,943.84 HUDSON ENERGY SERVICES, LLC 34809 AP 1141 03/31/2015 Mar A/P Electricity 2/11-3/12/15 92.54 51,036.38 HUDSON ENERGY SERVICES, LLC 34809 AP 1141 03/31/2015 Mar A/P Electricity 2/11-3/12/15 10,096.70 61,133.08 HUDSON ENERGY SERVICES, LLC 34809 AP 1141 03/31/2015 Mar A/P Electricity 2/11-3/12/15 656.57 61,789.65 HUDSON ENERGY SERVICES, LLC 34809 AP _______________ Account: 135-60020-020-000 Electricity Totals: 20,465.25 61,789.65 ** 149,292.00 Budgeted 87,502.35 Remaining 41 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 134.85 .00 134.85 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 134.85 ** 400.00 Budgeted 265.15 Remaining 34 % Used Account: 135-60070-020-000 Dues & Memberships 1128 03/26/2015 2/27-3/26/15 PCards TCEQ IND RENEWAL L 111.00 111.00 TCEQ IND RENEWAL L PC 1128 03/26/2015 2/27-3/26/15 PCards AMERICAN WATERWORKS 196.00 307.00 AMERICAN WATERWORKS PC _______________ Account: 135-60070-020-000 Dues & Memberships Totals: 307.00 307.00 ** 250.00 Budgeted (57.00) Remaining 123 % Used Account: 135-60080-020-000 Schools & Training 1128 03/26/2015 2/27-3/26/15 PCards TCEQ IND RENEWAL L 1,147.00 111.00 1,258.00 TCEQ IND RENEWAL L PC 1128 03/26/2015 2/27-3/26/15 PCards NCTCOG RTC TRAINING (240.00) 1,018.00 NCTCOG RTC TRAINING PC _______________ Account: 135-60080-020-000 Schools & Training Totals: (129.00) 1,018.00 ** 4,065.00 Budgeted 3,047.00 Remaining 25 % 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 1128 03/26/2015 2/27-3/26/15 PCards NATIONAL CAR TOLLS 443.90 11.40 455.30 NATIONAL CAR TOLLS PC 1128 03/26/2015 2/27-3/26/15 PCards FC QUIZNO S MC10154714 10.73 466.03 FC QUIZNO S MC10154714 PC 1128 03/26/2015 2/27-3/26/15 PCards NATIONAL CAR RENTAL 343.41 809.44 NATIONAL CAR RENTAL PC 1128 03/26/2015 2/27-3/26/15 PCards ROSEN HOTELS & RESORTS 607.44 1,416.88 ROSEN HOTELS & RESORTS PC 1128 03/26/2015 2/27-3/26/15 PCards GREAT WESTERN STEAKS 13.16 1,430.04 GREAT WESTERN STEAKS PC 1128 03/26/2015 2/27-3/26/15 PCards ROSEN SHNGL CK PKNG 1 16.00 1,446.04 ROSEN SHNGL CK PKNG 1 PC 1128 03/26/2015 2/27-3/26/15 PCards RED LOBSTER US00001081 18.53 1,464.57 RED LOBSTER US00001081 PC 1128 03/26/2015 2/27-3/26/15 PCards DENNY'S INC 15.99 1,480.56 DENNY'S INC PC 1128 03/26/2015 2/27-3/26/15 PCards TILTED KILT PUB AND EA 35.00 1,515.56 TILTED KILT PUB AND EA PC 1128 03/26/2015 2/27-3/26/15 PCards ROSEN SHNGL CK PKNG 1 16.00 1,531.56 ROSEN SHNGL CK PKNG 1 PC 1128 03/26/2015 2/27-3/26/15 PCards DENNY'S INC 15.99 1,547.55 DENNY'S INC PC 1128 03/26/2015 2/27-3/26/15 PCards TILTED KILT PUB AND EA 16.00 1,563.55 TILTED KILT PUB AND EA PC 1128 03/26/2015 2/27-3/26/15 PCards ROSEN SHNGL CK PKNG 1 16.00 1,579.55 ROSEN SHNGL CK PKNG 1 PC 1128 03/26/2015 2/27-3/26/15 PCards IHOP #36-093 16.08 1,595.63 IHOP #36-093 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1128 03/26/2015 2/27-3/26/15 PCards TWIN PEAKS OF I DRIVE 443.90 13.64 1,609.27 TWIN PEAKS OF I DRIVE PC 1128 03/26/2015 2/27-3/26/15 PCards BOSTON LOBSTER FEAST N 36.00 1,645.27 BOSTON LOBSTER FEAST N PC 1128 03/26/2015 2/27-3/26/15 PCards ROSEN SHNGL CK PKNG 1 16.00 1,661.27 ROSEN SHNGL CK PKNG 1 PC 1128 03/26/2015 2/27-3/26/15 PCards TILTED KILT PUB AND EA 36.00 1,697.27 TILTED KILT PUB AND EA PC 1128 03/26/2015 2/27-3/26/15 PCards DENNY'S INC 16.41 1,713.68 DENNY'S INC PC 1128 03/26/2015 2/27-3/26/15 PCards DENNY'S INC 16.41 1,730.09 DENNY'S INC PC 1128 03/26/2015 2/27-3/26/15 PCards TWIN PEAKS OF I DRIVE 15.70 1,745.79 TWIN PEAKS OF I DRIVE PC 1128 03/26/2015 2/27-3/26/15 PCards RED LOBSTER US00001081 36.00 1,781.79 RED LOBSTER US00001081 PC 1128 03/26/2015 2/27-3/26/15 PCards ALEXANDER RISTORANTE 9.46 1,791.25 ALEXANDER RISTORANTE PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 1,347.35 1,791.25 ** 1,600.00 Budgeted (191.25) Remaining 112 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 9,019.00 .00 9,019.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 9,019.00 ** 17,150.00 Budgeted 8,131.00 Remaining 53 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1203 03/31/2015 Recode Interfund Transfer Out Recode Interfund Transfer Out 10,278.00 10,278.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 10,278.00 ** .00 Budgeted (10,278.00) Remaining 0 % Used Account: 135-60334-020-000 Interfund Transfer Out 903 03/02/2015 MUD 1 GF to Rev Bond Reserve 10,278.00 10,278.00 GL 1203 03/31/2015 Recode Interfund Transfer Out Recode Interfund Transfer Out (10,278.00) .00 GL _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 1141 03/31/2015 Mar A/P March fuel 8,798.40 1,017.10 9,815.50 US Bank Voyager Fleet Systems 34836 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,017.10 9,815.50 ** 36,328.00 Budgeted 26,512.50 Remaining 27 % Used Account: 135-65010-020-000 Uniforms 1128 03/26/2015 2/27-3/26/15 PCards ACADEMY SPORTS #81 2,365.97 119.97 2,485.94 ACADEMY SPORTS #81 PC 1141 03/31/2015 Mar A/P Uniforms 112.50 2,598.44 PANDA EMBROIDERY 34826 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 232.47 2,598.44 ** 2,778.00 Budgeted 179.56 Remaining 94 % Used Account: 135-65030-020-000 Chemicals 1042 03/19/2015 Mar A/P Clarifloc 4,507.65 1,080.00 5,587.65 POLYDYNE, INC 34767 AP 1042 03/19/2015 Mar A/P 100 lb pails HTH 2,240.00 7,827.65 HARCROS CHEMICALS INC 34750 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 3,320.00 7,827.65 ** 30,000.00 Budgeted 22,172.35 Remaining 26 % Used Account: 135-65035-020-000 Small Tools 502.25 .00 502.25 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 502.25 ** 2,000.00 Budgeted 1,497.75 Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65040-020-000 Safety Equipment 162.00 .00 162.00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 162.00 ** 750.00 Budgeted 588.00 Remaining 22 % Used Account: 135-65045-020-000 Lab Supplies 1042 03/19/2015 Mar A/P coliform 5,600.04 171.21 5,771.25 IDEXX DISTRIBUTION, INC 34754 AP 1042 03/19/2015 Mar A/P Latex gloves 162.00 5,933.25 LOU'S GLOVES INCORPORATED 34758 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 333.21 5,933.25 ** 13,000.00 Budgeted 7,066.75 Remaining 46 % Used Account: 135-69005-020-000 Capital Outlays 1042 03/19/2015 Mar A/P Lift Station 2 80,942.00 2,537.00 83,479.00 THE WALLACE GROUP, INC. 34771 AP 1054 03/23/2015 Recode exp to Capital Outlay New AC and Heater 10,355.00 93,834.00 GL 1054 03/23/2015 Recode exp to Capital Outlay New AC and Heater 612.35 94,446.35 GL 1054 03/23/2015 Recode exp to Capital Outlay Lift Station #2 Drainage 3,300.00 97,746.35 GL 1054 03/23/2015 Recode exp to Capital Outlay Logos for Crane Truck 95.00 97,841.35 GL 1054 03/23/2015 Recode exp to Capital Outlay Running Boards for Crane Truck 850.00 98,691.35 GL _______________ Account: 135-69005-020-000 Capital Outlays Totals: 17,749.35 98,691.35 ** 150,000.00 Budgeted 51,308.65 Remaining 66 % Used Account: 135-69007-020-000 LTD Payment from WW Sales .00 .00 _______________ Account: 135-69007-020-000 LTD Payment from WW Sales Totals: .00 .00 ** 295,933.00 Budgeted 295,933.00 Remaining 0 % Used Account: 135-69008-020-000 Short Term Debt-Principal 873 03/01/2015 Mar A/P Principal/Interest 445K note 21,000.00 21,000.00 FIRST FINANCIAL BANK 34684 AP _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: 21,000.00 21,000.00 ** 56,991.00 Budgeted 35,991.00 Remaining 37 % Used Account: 135-69009-020-000 Short Term Debt-Interest 873 03/01/2015 Mar A/P Principal/Interest 445K note 393.23 393.23 FIRST FINANCIAL BANK 34684 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: 393.23 393.23 ** 2,011.00 Budgeted 1,617.77 Remaining 20 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 564,622.89 ** 1,400,512.00 Budgeted 835,889.11 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 1069 03/27/2015 MUD Payroll 3/27/15 Salaries & Wages 5,800.00 500.00 6,300.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 6,300.00 ** 10,000.00 Budgeted 3,700.00 Remaining 63 % Used Account: 135-50030-026-000 Social Security Taxes 1069 03/27/2015 MUD Payroll 3/27/15 Social Security Taxes 359.60 31.00 390.60 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 390.60 ** 620.00 Budgeted 229.40 Remaining 63 % Used Account: 135-50035-026-000 Medicare Taxes 1069 03/27/2015 MUD Payroll 3/27/15 Medicare Taxes 84.10 7.25 91.35 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 91.35 ** 145.00 Budgeted 53.65 Remaining 63 % Used Account: 135-50040-026-000 Unemployment Taxes 1070 03/24/2015 P/R run for TWC rate change Unemployment Taxes 133.40 (72.10) 61.30 PR 1211 03/31/2015 TWC Adj due to rate change (2.82) 58.48 GL _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: (74.92) 58.48 ** 230.00 Budgeted 171.52 Remaining 25 % Used Account: 135-50045-026-000 Workman's Compensation 196 03/01/2015 Mar TML Ins & Workers Comp 14.70 2.94 17.64 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 17.64 ** 36.00 Budgeted 18.36 Remaining 49 % 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 41 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 176.24 .00 176.24 _______________ Account: 135-60075-026-000 Meetings Totals: .00 176.24 ** 1,200.00 Budgeted 1,023.76 Remaining 15 % Used Account: 135-60080-026-000 Schools & Training 957 03/05/2015 Void A/P Check 34694/AWBD PFIA training/Carr @AWBD June 1,480.00 (150.00) 1,330.00 AWBD 34694 AP 957 03/05/2015 Void A/P Check 34694/AWBD AWBD Conference/Carr (355.00) 975.00 AWBD 34694 AP 1042 03/19/2015 Mar A/P AWBD Summer Conf/Carr 355.00 1,330.00 AWBD 34739 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: (150.00) 1,330.00 ** 4,000.00 Budgeted 2,670.00 Remaining 33 % Used Account: 135-60100-026-000 Travel & per diem 1,329.96 .00 1,329.96 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 1,329.96 ** 5,000.00 Budgeted 3,670.04 Remaining 27 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1,624.74 .00 1,624.74 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,624.74 ** 1,000.00 Budgeted (624.74) Remaining 162 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 11,354.01 ** 22,881.00 Budgeted 11,526.99 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 970 03/13/2015 3-13-15 Payroll Salaries & Wages 181,399.45 17,585.66 198,985.11 PR 1069 03/27/2015 MUD Payroll 3/27/15 Salaries & Wages 17,618.06 216,603.17 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 35,203.72 216,603.17 ** 477,578.00 Budgeted 260,974.83 Remaining 45 % Used Account: 135-50010-030-000 Overtime 970 03/13/2015 3-13-15 Payroll Overtime 87.79 9.75 97.54 PR 1069 03/27/2015 MUD Payroll 3/27/15 Overtime 313.57 411.11 PR _______________ Account: 135-50010-030-000 Overtime Totals: 323.32 411.11 ** 1,000.00 Budgeted 588.89 Remaining 41 % Used Account: 135-50016-030-000 Longevity 3,282.50 .00 3,282.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,282.50 ** 3,283.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 970 03/13/2015 3-13-15 Payroll Retirement 16,530.66 1,567.74 18,098.40 PR 1069 03/27/2015 MUD Payroll 3/27/15 Retirement 1,597.71 19,696.11 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,165.45 19,696.11 ** 42,840.00 Budgeted 23,143.89 Remaining 46 % Used Account: 135-50026-030-000 Medical Insurance 970 03/13/2015 3-13-15 Payroll Medical Insurance 23,130.14 2,457.56 25,587.70 PR 1069 03/27/2015 MUD Payroll 3/27/15 Medical Insurance 2,457.50 28,045.20 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,915.06 28,045.20 ** 65,015.00 Budgeted 36,969.80 Remaining 43 % Used Account: 135-50027-030-000 Dental Insurance 970 03/13/2015 3-13-15 Payroll Dental Insurance 1,642.04 182.11 1,824.15 PR 1069 03/27/2015 MUD Payroll 3/27/15 Dental Insurance 182.13 2,006.28 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 364.24 2,006.28 ** 4,944.00 Budgeted 2,937.72 Remaining 41 % Used Account: 135-50028-030-000 Vision Insurance 970 03/13/2015 3-13-15 Payroll Vision Insurance 388.21 42.16 430.37 PR 1069 03/27/2015 MUD Payroll 3/27/15 Vision Insurance 42.22 472.59 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 84.38 472.59 ** 1,158.00 Budgeted 685.41 Remaining 41 % Used Account: 135-50029-030-000 Life Insurance & Other 873 03/01/2015 Mar A/P 1,778.07 331.92 2,109.99 AP 1141 03/31/2015 Mar A/P Café 125 Admin 33.78 2,143.77 BenefitMall 34792 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 365.70 2,143.77 ** 4,333.00 Budgeted 2,189.23 Remaining 49 % Used Account: 135-50030-030-000 Social Security Taxes 970 03/13/2015 3-13-15 Payroll Social Security Taxes 10,870.20 1,034.67 11,904.87 PR 1069 03/27/2015 MUD Payroll 3/27/15 Social Security Taxes 1,044.79 12,949.66 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,079.46 12,949.66 ** 30,079.00 Budgeted 17,129.34 Remaining 43 % Used Account: 135-50035-030-000 Medicare Taxes 970 03/13/2015 3-13-15 Payroll Medicare Taxes 2,542.20 241.99 2,784.19 PR 1069 03/27/2015 MUD Payroll 3/27/15 Medicare Taxes 244.33 3,028.52 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 486.32 3,028.52 ** 7,422.00 Budgeted 4,393.48 Remaining 41 % Used Account: 135-50040-030-000 Unemployment Taxes 970 03/13/2015 3-13-15 Payroll Unemployment Taxes 1,444.22 (1,137.35) 306.87 PR 1070 03/24/2015 P/R run for TWC rate change Unemployment Taxes (57.10) 249.77 PR 1211 03/31/2015 TWC Adj due to rate change (45.58) 204.19 GL _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: (1,240.03) 204.19 ** 1,449.00 Budgeted 1,244.81 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 196 03/01/2015 Mar TML Ins & Workers Comp 436.50 87.30 523.80 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 523.80 ** 1,636.00 Budgeted 1,112.20 Remaining 32 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 38.00 .00 38.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 500.00 Budgeted 462.00 Remaining 8 % Used Account: 135-50070-030-000 Employee Relations 2,261.64 .00 2,261.64 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 2,261.64 ** 5,000.00 Budgeted 2,738.36 Remaining 45 % Used Account: 135-55030-030-000 Software & Support 1042 03/19/2015 Mar A/P Annual software renewal 71,671.40 13,115.00 84,786.40 STW INC 34768 AP 1042 03/19/2015 Mar A/P Bank Rec Software renewal 600.00 85,386.40 CONWAY CONSULTING 34744 AP 1042 03/19/2015 Mar A/P Internet 4/1-4/30/15 1,357.82 86,744.22 WHOLESALE CARRIER SERVICES INC 34779 AP 1128 03/26/2015 2/27-3/26/15 PCards ATT*BILL PAYMENT 68.49 86,812.71 ATT*BILL PAYMENT PC 1128 03/26/2015 2/27-3/26/15 PCards ATT*BILL PAYMENT 52.18 86,864.89 ATT*BILL PAYMENT PC 1127 03/31/2015 Move STW Server Cost Move STW Server Cost 5,520.00 92,384.89 GL 1141 03/31/2015 Mar A/P Callout for scada 395.00 92,779.89 WIN-911 SOFTWARE 34839 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 21,108.49 92,779.89 ** 87,423.00 Budgeted (5,356.89) Remaining 106 % Used Account: 135-55070-030-000 Independent Labor 1042 03/19/2015 Mar A/P Record MUD meeting 9,045.00 52.50 9,097.50 MIGUEL CRUZ 34761 AP 1054 03/23/2015 Recode exp to Capital Outlay Lift Station #2 Drainage (3,300.00) 5,797.50 GL 1097 03/31/2015 Move IT One Time Labor Move IT One Time Labor 24,575.00 30,372.50 GL 1127 03/31/2015 Move STW Server Cost Move STW Server Cost (5,520.00) 24,852.50 GL 1141 03/31/2015 Mar A/P Premier, Nevill 47.50 24,900.00 TOWN OF TROPHY CLUB 34834 AP 1141 03/31/2015 Mar A/P Professional fees 900.00 25,800.00 NEW GEN STRATEGIES & SOLUTIONS 34823 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 16,755.00 25,800.00 ** 32,550.00 Budgeted 6,750.00 Remaining 79 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Maintenance & Repairs .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 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: 3,061.01 (215.19) 2,845.82 AR 1141 03/31/2015 Mar A/P Pitney Bowes, Pest Control, Ge 87.50 2,933.32 TOWN OF TROPHY CLUB 34834 AP 1141 03/31/2015 Mar A/P Pitney Bowes, Pest Control, Ge 50.00 2,983.32 TOWN OF TROPHY CLUB 34834 AP 1141 03/31/2015 Mar A/P Rug service 143.46 3,126.78 G & K SERVICES 34806 AP 1141 03/31/2015 Mar A/P Rug service 143.46 3,270.24 G & K SERVICES 34806 AP 1141 03/31/2015 Mar A/P Rug service 143.46 3,413.70 G & K SERVICES 34806 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 352.69 3,413.70 ** 6,500.00 Budgeted 3,086.30 Remaining 53 % Used Account: 135-55120-030-000 Cleaning Services 1042 03/19/2015 Mar A/P Feb Janitorial Service 2,510.12 627.53 3,137.65 MEMBER'S BUILDING MAINTENANCE 34759 AP 1141 03/31/2015 Mar A/P March Janitorial service 627.53 3,765.18 MEMBER'S BUILDING MAINTENANCE 34819 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,255.06 3,765.18 ** 8,100.00 Budgeted 4,334.82 Remaining 46 % Used Account: 135-55160-030-000 Professional Outside Services 1097 03/31/2015 Move IT One Time Labor Move IT One Time Labor 41,174.95 (24,575.00) 16,599.95 GL _______________ Account: 135-55160-030-000 Professional Outside Services Totals: (24,575.00) 16,599.95 ** 58,000.00 Budgeted 41,400.05 Remaining 29 % Used Account: 135-55161-030-000 Town Personnel Contract 1042 03/19/2015 Mar A/P Semo Balance due/Mowing less J 20,000.00 6,170.00 26,170.00 TOWN OF TROPHY CLUB 34772 AP _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: 6,170.00 26,170.00 ** 26,170.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 1042 03/19/2015 Mar A/P Feb Late notices & regular bil 2,419.80 762.50 3,182.30 DATAPROSE LLC 34746 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 762.50 3,182.30 ** 8,200.00 Budgeted 5,017.70 Remaining 39 % Used Account: 135-60005-030-000 Telephone 873 03/01/2015 Mar A/P March Answering Service 4,654.05 180.00 4,834.05 KEYSTONE PARK SECRETARIAL 34710 AP 1128 03/26/2015 2/27-3/26/15 PCards ATT*BUS PHONE PMT 434.95 5,269.00 ATT*BUS PHONE PMT PC 1141 03/31/2015 Mar A/P BOA PCards 385.42 5,654.42 TOWN OF TROPHY CLUB 34834 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,000.37 5,654.42 ** 13,361.00 Budgeted 7,706.58 Remaining 42 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1042 03/19/2015 Mar A/P Cell phones 1,677.61 37.99 1,715.60 VERIZON WIRELESS 34776 AP 1128 03/26/2015 2/27-3/26/15 PCards COMMUNICATION CONNECTI 16.23 1,731.83 COMMUNICATION CONNECTI PC 1128 03/26/2015 2/27-3/26/15 PCards RINGCENTRAL, INC 9.99 1,741.82 RINGCENTRAL, INC PC 1069 03/27/2015 MUD Payroll 3/27/15 Communications/Pagers/Mobiles 300.00 2,041.82 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 364.21 2,041.82 ** 4,056.00 Budgeted 2,014.18 Remaining 50 % Used Account: 135-60020-030-000 Electricity/Gas 1141 03/31/2015 Mar A/P Pitney Bowes, Pest Control, Ge 2,618.59 1,050.09 3,668.68 TOWN OF TROPHY CLUB 34834 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,050.09 3,668.68 ** 14,978.00 Budgeted 11,309.32 Remaining 24 % Used Account: 135-60025-030-000 Water 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: 378.28 (56.30) 321.98 AR 1141 03/31/2015 Mar A/P March water 112.60 434.58 TROPHY CLUB MUD (WATER BILLS) 34835 AP _______________ Account: 135-60025-030-000 Water Totals: 56.30 434.58 ** 1,500.00 Budgeted 1,065.42 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60035-030-000 Postage 886 03/02/2015 Mar A/P FW Water Violations Post Cards 9,748.90 703.56 10,452.46 U.S. POSTAL SERVICE 34690 AP 900 03/03/2015 Mar A/P FW Water Violations Post Cards 301.10 10,753.56 U.S. POSTAL SERVICE 34691 AP 1030 03/18/2015 Postage for post cards Post cards for FW Vault work o 1,005.16 11,758.72 U.S. POSTAL SERVICE 34736 AP 1042 03/19/2015 Mar A/P Feb Late notices & regular bil 1,746.50 13,505.22 DATAPROSE LLC 34746 AP 1120 03/31/2015 March MUD Postage meter usage 287.58 13,792.80 GL 1141 03/31/2015 Mar A/P Pitney Bowes, Pest Control, Ge 145.50 13,938.30 TOWN OF TROPHY CLUB 34834 AP 1141 03/31/2015 Mar A/P Postage Overnight 4.99 13,943.29 FEDERAL EXPRESS CORP 34803 AP 1141 03/31/2015 Mar A/P Postage Overtight 6.51 13,949.80 FEDERAL EXPRESS CORP 34803 AP _______________ Account: 135-60035-030-000 Postage Totals: 4,200.90 13,949.80 ** 28,500.00 Budgeted 14,550.20 Remaining 49 % Used Account: 135-60040-030-000 Service Charges & Fees 1194 03/03/2015 CC Fees/February 17,768.62 42.45 17,811.07 GL 1194 03/03/2015 CC Fees/February 109.75 17,920.82 GL 1194 03/03/2015 CC Fees/February 2,961.95 20,882.77 GL 1138 03/12/2015 Bank Analysis Fee- Feb 250.00 21,132.77 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,364.15 21,132.77 ** 32,000.00 Budgeted 10,867.23 Remaining 66 % Used Account: 135-60050-030-000 Bad Debt Expense 1113 03/31/2015 UB 3/31/15 Write offs UB20150331-20150331 User: 303.44 980.67 1,284.11 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 980.67 1,284.11 ** 6,200.00 Budgeted 4,915.89 Remaining 21 % Used Account: 135-60055-030-000 Insurance 196 03/01/2015 Mar TML Ins & Workers Comp 20,398.30 4,063.01 24,461.31 GL 1042 03/19/2015 Mar A/P Bond/Slaght 50.00 24,511.31 VICTOR O SCHINNERER & CO, INC 34777 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,113.01 24,511.31 ** 48,751.00 Budgeted 24,239.69 Remaining 50 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1,223.77 .00 1,223.77 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 1,223.77 ** 1,000.00 Budgeted (223.77) Remaining 122 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-030-000 Dues & Memberships 1128 03/26/2015 2/27-3/26/15 PCards RANDALLS STORE00017897 4,055.95 15.62 4,071.57 RANDALLS STORE00017897 PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON MKTPLACE PMTS 69.37 4,140.94 AMAZON MKTPLACE PMTS PC 1218 03/31/2015 Recode Prizes & Punch fixings (84.99) 4,055.95 GL _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,055.95 ** 5,000.00 Budgeted 944.05 Remaining 81 % Used Account: 135-60075-030-000 Meetings 60.11 .00 60.11 _______________ Account: 135-60075-030-000 Meetings Totals: .00 60.11 ** 400.00 Budgeted 339.89 Remaining 15 % Used Account: 135-60079-030-000 Public Education 1042 03/19/2015 Mar A/P Face Painting for Waterfest 633.19 180.00 813.19 TRACY HENRY 34773 AP 1128 03/26/2015 2/27-3/26/15 PCards IN *HAPPY JUMPER 400.00 1,213.19 IN *HAPPY JUMPER PC 1128 03/26/2015 2/27-3/26/15 PCards EXTENSION CONFERENCE S 150.00 1,363.19 EXTENSION CONFERENCE S PC 1128 03/26/2015 2/27-3/26/15 PCards TSBPA IND LIC RENE 257.00 1,620.19 TSBPA IND LIC RENE PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON.COM 54.48 1,674.67 AMAZON.COM PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON.COM 54.48 1,729.15 AMAZON.COM PC 1128 03/26/2015 2/27-3/26/15 PCards HOBBY-LOBBY #256 13.93 1,743.08 HOBBY-LOBBY #256 PC 1128 03/26/2015 2/27-3/26/15 PCards THE HOME DEPOT 6581 100.00 1,843.08 THE HOME DEPOT 6581 PC 1128 03/26/2015 2/27-3/26/15 PCards WM SUPERCENTER #5247 33.01 1,876.09 WM SUPERCENTER #5247 PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON MKTPLACE PMTS 199.48 2,075.57 AMAZON MKTPLACE PMTS PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON MKTPLACE PMTS 29.98 2,105.55 AMAZON MKTPLACE PMTS PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON MKTPLACE PMTS 35.78 2,141.33 AMAZON MKTPLACE PMTS PC 1128 03/26/2015 2/27-3/26/15 PCards SIGNSONTHECHEAP.COM 211.84 2,353.17 SIGNSONTHECHEAP.COM PC 1128 03/26/2015 2/27-3/26/15 PCards JO-ANN ETC #2035 12.45 2,365.62 JO-ANN ETC #2035 PC 1128 03/26/2015 2/27-3/26/15 PCards CUSTOMINK TSHIRTS 878.24 3,243.86 CUSTOMINK TSHIRTS PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON MKTPLACE PMTS 14.88 3,258.74 AMAZON MKTPLACE PMTS PC 1141 03/31/2015 Mar A/P March supplies 41.06 3,299.80 COSTCO WHOLESALE 34799 AP 1218 03/31/2015 Recode Prizes & Punch fixings 84.99 3,384.79 GL _______________ Account: 135-60079-030-000 Public Education Totals: 2,751.60 3,384.79 ** 5,000.00 Budgeted 1,615.21 Remaining 68 % Used Account: 135-60080-030-000 Schools & Training 2,688.00 .00 2,688.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,688.00 ** 10,235.00 Budgeted 7,547.00 Remaining 26 % Used Account: 135-60100-030-000 Travel & per diem 970 03/13/2015 3-13-15 Payroll Travel & per diem 582.18 13.28 595.46 PR 1128 03/26/2015 2/27-3/26/15 PCards MCDONALD'S F7838 3.78 599.24 MCDONALD'S F7838 PC 1069 03/27/2015 MUD Payroll 3/27/15 Travel & per diem 149.10 748.34 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 166.16 748.34 ** 5,400.00 Budgeted 4,651.66 Remaining 14 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 1010 03/16/2015 Rev A/R Inv/BRE AR 20150316-20150316 User: 239.28 721.59 960.87 AR 1141 03/31/2015 Mar A/P Audit Services 503.43 1,464.30 STAR-TELEGRAM OPERATING LTD 34832 AP 1141 03/31/2015 Mar A/P Rules Governing new Service Co 539.79 2,004.09 STAR-TELEGRAM OPERATING LTD 34832 AP _______________ Account: 135-60125-030-000 Advertising Totals: 1,764.81 2,004.09 ** 2,500.00 Budgeted 495.91 Remaining 80 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 3,436.38 .00 3,436.38 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 3,436.38 ** 17,500.00 Budgeted 14,063.62 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 5,035.96 .00 5,035.96 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 5,035.96 ** 10,475.00 Budgeted 5,439.04 Remaining 48 % Used Account: 135-65010-030-000 Uniforms 1,043.00 .00 1,043.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 1,043.00 ** 1,855.00 Budgeted 812.00 Remaining 56 % Used Account: 135-65055-030-000 Hardware 33,885.23 .00 33,885.23 _______________ Account: 135-65055-030-000 Hardware Totals: .00 33,885.23 ** 35,226.00 Budgeted 1,340.77 Remaining 96 % Used Account: 135-65085-030-000 Office Supplies 1042 03/19/2015 Mar A/P Credit for Returned W2's and e 2,912.67 (63.28) 2,849.39 OFFICE DEPOT, INC 34762 AP 1042 03/19/2015 Mar A/P Office Supplies 57.97 2,907.36 OFFICE DEPOT, INC 34762 AP 1042 03/19/2015 Mar A/P Office Supplies 78.76 2,986.12 OFFICE DEPOT, INC 34762 AP 1042 03/19/2015 Mar A/P Office Supplies 7.29 2,993.41 OFFICE DEPOT, INC 34762 AP 1128 03/26/2015 2/27-3/26/15 PCards OLMSTED-KIRK PAPER CO. 370.78 3,364.19 OLMSTED-KIRK PAPER CO. PC 1128 03/26/2015 2/27-3/26/15 PCards OLMSTED-KIRK PAPER CO. 25.00 3,389.19 OLMSTED-KIRK PAPER CO. PC 1128 03/26/2015 2/27-3/26/15 PCards OLMSTED-KIRK PAPER CO. 231.14 3,620.33 OLMSTED-KIRK PAPER CO. PC 1128 03/26/2015 2/27-3/26/15 PCards FEDEXOFFICE 00003319 3.79 3,624.12 FEDEXOFFICE 00003319 PC 1128 03/26/2015 2/27-3/26/15 PCards WAL-MART #5247 1.88 3,626.00 WAL-MART #5247 PC 1128 03/26/2015 2/27-3/26/15 PCards FEDEXOFFICE 00003319 33.65 3,659.65 FEDEXOFFICE 00003319 PC 1128 03/26/2015 2/27-3/26/15 PCards OFFICE DEPOT #406 65.95 3,725.60 OFFICE DEPOT #406 PC 1128 03/26/2015 2/27-3/26/15 PCards CARBONLESS FORMS PRINT 89.00 3,814.60 CARBONLESS FORMS PRINT PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON MKTPLACE PMTS 24.99 3,839.59 AMAZON MKTPLACE PMTS PC 1131 03/31/2015 Mar Billing Inv 1278-1288 AR 20150331-20150331 User: (13.75) 3,825.84 AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1141 03/31/2015 Mar A/P Copy paper 2,912.67 90.55 3,916.39 TOWN OF TROPHY CLUB 34834 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 1,003.72 3,916.39 ** 9,000.00 Budgeted 5,083.61 Remaining 44 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1,139.30 .00 1,139.30 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 1,139.30 ** 4,732.00 Budgeted 3,592.70 Remaining 24 % Used Account: 135-65095-030-000 Maintenance Supplies 1128 03/26/2015 2/27-3/26/15 PCards THE HOME DEPOT 6581 1,840.87 99.96 1,940.83 THE HOME DEPOT 6581 PC 1128 03/26/2015 2/27-3/26/15 PCards AMAZON MKTPLACE PMTS 102.04 2,042.87 AMAZON MKTPLACE PMTS PC 1141 03/31/2015 Mar A/P March supplies 39.56 2,082.43 COSTCO WHOLESALE 34799 AP 1141 03/31/2015 Mar A/P Reimb Sam's & Walmart purchase 143.99 2,226.42 Kari Schultz 34811 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 385.55 2,226.42 ** 5,000.00 Budgeted 2,773.58 Remaining 45 % 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 1141 03/31/2015 Mar A/P Logo for Escape 61,726.66 95.00 61,821.66 M-KAM LTD. 34818 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 95.00 61,821.66 ** 67,000.00 Budgeted 5,178.34 Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69170-030-000 Copier Lease Installments 1141 03/31/2015 Mar A/P Premier, Nevill 1,286.47 93.34 1,379.81 TOWN OF TROPHY CLUB 34834 AP 1141 03/31/2015 Mar A/P Premier, Nevill 278.33 1,658.14 TOWN OF TROPHY CLUB 34834 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 371.67 1,658.14 ** 4,236.00 Budgeted 2,577.86 Remaining 39 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 .00 16,329.00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 16,329.00 ** 16,329.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 680,711.58 ** 1,244,664.00 Budgeted 563,952.42 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 1042 03/19/2015 Mar A/P Legal/General 335,077.25 3,057.60 338,134.85 WHITAKER CHALK SWINDLE 34778 AP 1042 03/19/2015 Mar A/P Legal/BDMR 122.00 338,256.85 WHITAKER CHALK SWINDLE 34778 AP 1042 03/19/2015 Mar A/P Legal/Maguire Solana 45,687.64 383,944.49 WHITAKER CHALK SWINDLE 34778 AP 1042 03/19/2015 Mar A/P Legal/Damage Claim THB 1,510.80 385,455.29 WHITAKER CHALK SWINDLE 34778 AP 1141 03/31/2015 Mar A/P Feb Legal 2,175.00 387,630.29 THE LISTON LAW FIRM, P.C. 34833 AP 1141 03/31/2015 Mar A/P Feb Legal 4,710.00 392,340.29 THE LISTON LAW FIRM, P.C. 34833 AP _______________ Account: 135-55045-039-000 Legal Totals: 57,263.04 392,340.29 ** 300,000.00 Budgeted (92,340.29) Remaining 131 % Used Account: 135-55055-039-000 Auditing 16,836.00 .00 16,836.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 16,836.00 ** 22,491.00 Budgeted 5,655.00 Remaining 75 % Used Account: 135-55060-039-000 Appraisal 951 03/05/2015 Mar A/P 2nd Qtr Allocation for DCAD 20 4,199.74 1,882.21 6,081.95 DENTON CENTRAL APPRAISAL DISTR 34698 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,882.21 6,081.95 ** 10,000.00 Budgeted 3,918.05 Remaining 61 % Used Account: 135-55065-039-000 Tax Admin Fees 2,456.40 .00 2,456.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,456.40 ** 3,800.00 Budgeted 1,343.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 417,714.64 ** 336,291.00 Budgeted (81,423.64) Remaining 124 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (816,878.03) .00 Budgeted 816,878.03 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (91,329.00) .00 (91,329.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (91,329.00) ** .00 Budgeted 91,329.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (17,950.00) .00 (17,950.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (17,950.00) ** .00 Budgeted 17,950.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (109,279.00) ** .00 Budgeted 109,279.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-030-000 GASB Replacement 74,706.00 .00 74,706.00 _______________ Account: 137-69195-030-000 GASB Replacement Totals: .00 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-045-000 GASB Replacement 125,670.00 .00 125,670.00 _______________ Account: 137-69195-045-000 GASB Replacement Totals: .00 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ 91,097.00 .00 Budgeted (91,097.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 1139 03/31/2015 Bank Interest/March (5.83) (.93) (6.76) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (.93) (6.76) ** .00 Budgeted 6.76 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (6.76) ** .00 Budgeted 6.76 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 2,250.00 .00 2,250.00 _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: .00 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 2,243.24 3,348.00 Budgeted 1,104.76 Remaining 67 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET MARCH 2015 517 ASSETS TAX BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 4,377,156 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,377,156 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 4,377,156 TOTAL FUND BALANCE 4,377,156 TOTAL LIABILITIES AND FUND BALANCE 4,377,156 . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 08:12 04/16/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 178.47- 571.94- 571.94 517-49105-000-000 Bond Proceeds 5,765,000.00- 5,765,000.00 Subtotal: 178.47- 5,765,571.94- 5,765,571.94 Program number: 178.47- 5,765,571.94- 5,765,571.94 Department number: Revenues 178.47- 5,765,571.94- 5,765,571.94 Revenues Subtotal ----------- 178.47- 5,765,571.94- 5,765,571.94 . glbase_tbam rgonzale Trophy Club MUD #1 Page 23 08:12 04/16/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60135-020-000 TCEQ Permits & Fees 14,376.56 14,376.56- 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 1,074,337.15- Subtotal: 1,088,713.71 1,088,713.71- 517-69005-020-000 Capital Outlays 151,502.50 151,502.50- Subtotal: 151,502.50 151,502.50- 517-70020-020-000 Bond Issuance 148,200.00 148,200.00- Subtotal: 148,200.00 148,200.00- Program number: 1,388,416.21 1,388,416.21- Department number: Wastewater 1,388,416.21 1,388,416.21- Expenditures Subtotal ----------- 1,388,416.21 1,388,416.21- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 178.47- 4,377,155.73- 4,377,155.73 . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 1139 03/31/2015 Bank Interest/March (393.47) (178.47) (571.94) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (178.47) (571.94) ** .00 Budgeted 571.94 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds (5,765,000.00) .00 (5,765,000.00) _______________ Account: 517-49105-000-000 Bond Proceeds Totals: .00 (5,765,000.00) ** .00 Budgeted 5,765,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,765,571.94) ** .00 Budgeted 5,765,571.94 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-60135-020-000 TCEQ Permits & Fees 14,376.56 .00 14,376.56 _______________ Account: 517-60135-020-000 TCEQ Permits & Fees Totals: .00 14,376.56 ** .00 Budgeted (14,376.56) Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 .00 1,074,337.15 _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 1,074,337.15 ** .00 Budgeted (1,074,337.15) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 151,502.50 .00 151,502.50 _______________ Account: 517-69005-020-000 Capital Outlays Totals: .00 151,502.50 ** .00 Budgeted (151,502.50) Remaining 0 % Used Account: 517-70020-020-000 Bond Issuance 148,200.00 .00 148,200.00 _______________ Account: 517-70020-020-000 Bond Issuance Totals: .00 148,200.00 ** .00 Budgeted (148,200.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,388,416.21 ** .00 Budgeted (1,388,416.21) Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (4,377,155.73) .00 Budgeted 4,377,155.73 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET MARCH 2015 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 9,017,213 ACCOUNTS RECEIVABLE - TOTAL ASSETS 9,017,213 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 12,886 TOTAL LIABILITIES 12,886 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 9,004,327 TOTAL FUND BALANCE 9,004,327 TOTAL LIABILITIES AND FUND BALANCE 9,017,213 . glbase_tbam rgonzale Trophy Club MUD #1 Page 24 08:12 04/16/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 367.67- 499.76- 499.76 518-49105-000-000 Bond Proceeds 9,230,000.00- 9,230,000.00 Subtotal: 367.67- 9,230,499.76- 9,230,499.76 Program number: 367.67- 9,230,499.76- 9,230,499.76 Department number: Revenues 367.67- 9,230,499.76- 9,230,499.76 Revenues Subtotal ----------- 367.67- 9,230,499.76- 9,230,499.76 . glbase_tbam rgonzale Trophy Club MUD #1 Page 25 08:12 04/16/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-60125-020-000 Advertising 660.99 660.99 660.99- 518-60135-020-000 TCEQ Fees & Permits 23,017.46 23,017.46- Subtotal: 660.99 23,678.45 23,678.45- 518-69005-020-000 Capital Outlays 12,225.00 12,225.00 12,225.00- Subtotal: 12,225.00 12,225.00 12,225.00- 518-70020-020-000 Bond Issuance Costs 190,269.00 190,269.00- Subtotal: 190,269.00 190,269.00- Program number: 12,885.99 226,172.45 226,172.45- Department number: Wastewater 12,885.99 226,172.45 226,172.45- Expenditures Subtotal ----------- 12,885.99 226,172.45 226,172.45- Fund number: 518 2015 Revenue Bond Const Fund 12,518.32 9,004,327.31- 9,004,327.31 . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 1139 03/31/2015 Bank Interest/March (132.09) (367.67) (499.76) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (367.67) (499.76) ** .00 Budgeted 499.76 Remaining 0 % Used Account: 518-49105-000-000 Bond Proceeds (9,230,000.00) .00 (9,230,000.00) _______________ Account: 518-49105-000-000 Bond Proceeds Totals: .00 (9,230,000.00) ** .00 Budgeted 9,230,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (9,230,499.76) ** .00 Budgeted 9,230,499.76 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-60125-020-000 Advertising 1141 03/31/2015 Mar A/P WWTP Construction Bids 660.99 660.99 STAR-TELEGRAM OPERATING LTD 34832 AP _______________ Account: 518-60125-020-000 Advertising Totals: 660.99 660.99 ** .00 Budgeted (660.99) Remaining 0 % Used Account: 518-60135-020-000 TCEQ Fees & Permits 23,017.46 .00 23,017.46 _______________ Account: 518-60135-020-000 TCEQ Fees & Permits Totals: .00 23,017.46 ** .00 Budgeted (23,017.46) Remaining 0 % Used Account: 518-69005-020-000 Capital Outlays 1042 03/19/2015 Mar A/P WWTP Improvements 12,225.00 12,225.00 THE WALLACE GROUP, INC. 34771 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 12,225.00 12,225.00 ** .00 Budgeted (12,225.00) Remaining 0 % Used Account: 518-70020-020-000 Bond Issuance Costs 190,269.00 .00 190,269.00 _______________ Account: 518-70020-020-000 Bond Issuance Costs Totals: .00 190,269.00 ** .00 Budgeted (190,269.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 226,172.45 ** .00 Budgeted (226,172.45) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ (9,004,327.31) .00 Budgeted 9,004,327.31 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MARCH 2015 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 10,278 ACCOUNTS RECEIVABLE - TOTAL ASSETS 10,278 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 10,278 TOTAL FUND BALANCE 10,278 TOTAL LIABILITIES AND FUND BALANCE 10,278 . glbase_tbam rgonzale Trophy Club MUD #1 Page 26 08:12 04/16/15 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income .30- .30- .30 528-49141-000-000 Interfund Transfer In-Gen Fund 10,278.00- 10,278.00- 10,278.00 Subtotal: 10,278.30- 10,278.30- 10,278.30 Program number: 10,278.30- 10,278.30- 10,278.30 Department number: 10,278.30- 10,278.30- 10,278.30 Revenues Subtotal ----------- 10,278.30- 10,278.30- 10,278.30 Fund number: 528 2015 Revenue Bond Reserve Fund 10,278.30- 10,278.30- 10,278.30 . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 1139 03/31/2015 Bank Interest/March (.30) (.30) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (.30) (.30) ** .00 Budgeted .30 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 903 03/02/2015 MUD 1 GF to Rev Bond Reserve (10,278.00) (10,278.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (10,278.00) (10,278.00) ** .00 Budgeted 10,278.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (10,278.30) ** .00 Budgeted 10,278.30 Remaining 0 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (10,278.30) .00 Budgeted 10,278.30 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET MARCH 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 598,710 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 20,676 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 624,232 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 20,676 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 20,676 FUND BALANCE ASSIGNED FUND BALANCE 14,753 NET REVENUES / EXPENDITURES 588,803 TOTAL FUND BALANCE 603,556 TOTAL LIABILITIES AND FUND BALANCE 624,232 . glbase_tbam rgonzale Trophy Club MUD #1 Page 27 08:12 04/16/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 466,019.00- 466,019.00- 7,192.87- 456,604.83- 97.980 9,414.17- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 8.57- 1,580.65- 63.226 919.35- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 284.89- 976.67- 61.042 623.33- Subtotal: 470,119.00- 470,119.00- 7,486.33- 459,162.15- 97.669 10,956.85- 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- 24.29- 3,357.96- 895.456 2,982.96 533-49015-000-000 Lease/Rental Income 211,829.00- 211,829.00- 211,829.00- 100.000 533-49110-000-000 Premium on Bonds Sold 4,957.90- 4,957.90 Subtotal: 212,204.00- 212,204.00- 24.29- 220,144.86- 103.742 7,940.86 Program number: 1,139,861.00- 1,139,861.00- 7,510.62- 679,307.01- 59.596 460,553.99- Department number: Revenues 1,139,861.00- 1,139,861.00- 7,510.62- 679,307.01- 59.596 460,553.99- Revenues Subtotal ----------- 1,139,861.00- 1,139,861.00- 7,510.62- 679,307.01- 59.596 460,553.99- . glbase_tbam rgonzale Trophy Club MUD #1 Page 28 08:12 04/16/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 1,250.00 49.020 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 403,103.00 403,103.00 89,253.75 22.142 313,849.25 533-70035-051-000 Bond Principal Payment-Tax 440,000.00 440,000.00 440,000.00 533-70040-051-000 Bond Interest Expense-Revenue 292,283.00 292,283.00 292,283.00 Subtotal: 1,137,936.00 1,137,936.00 90,503.75 7.953 1,047,432.25 Program number: 1,137,936.00 1,137,936.00 90,503.75 7.953 1,047,432.25 Department number: Administration 1,137,936.00 1,137,936.00 90,503.75 7.953 1,047,432.25 Expenditures Subtotal ----------- 1,137,936.00 1,137,936.00 90,503.75 7.953 1,047,432.25 Fund number: 533 MUD 1 I&S Consolidated 1,925.00- 1,925.00- 7,510.62- 588,803.26- ############### 586,878.26 . glpdatb2 rgonzale Trophy Club MUD #1 Page 64 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1147 03/02/2015 Property Taxes/Assessments (449,411.96) (2,715.55) (452,127.51) GL 1148 03/03/2015 Property Taxes/Assessments (456.23) (452,583.74) GL 1149 03/04/2015 Property Taxes/Assessments (498.47) (453,082.21) GL 1150 03/06/2015 Property Taxes/Assessments (57.62) (453,139.83) GL 1151 03/09/2015 Property Taxes/Assessments (26.29) (453,166.12) GL 1152 03/10/2015 Property Taxes/Assessments (51.94) (453,218.06) GL 1153 03/11/2015 Property Taxes/Assessments (486.21) (453,704.27) GL 1154 03/12/2015 Property Taxes/Assessments (479.27) (454,183.54) GL 1155 03/13/2015 Property Taxes/Assessments (190.19) (454,373.73) GL 1156 03/16/2015 Property Taxes/Assessments (408.20) (454,781.93) GL 1157 03/17/2015 Property Taxes/Assessments (46.04) (454,827.97) GL 1158 03/18/2015 Property Taxes/Assessments (292.37) (455,120.34) GL 1160 03/19/2015 Property Taxes/Assessments (116.00) (455,236.34) GL 1161 03/20/2015 Property Taxes/Assessments (17.33) (455,253.67) GL 1173 03/20/2015 Rev Property Taxes/Assessments 17.33 (455,236.34) GL 1174 03/20/2015 Property Taxes/Assessments (7.02) (455,243.36) GL 1162 03/23/2015 Property Taxes/Assessments (30.40) (455,273.76) GL 1163 03/24/2015 Property Taxes/Assessments (94.61) (455,368.37) GL 1164 03/25/2015 Property Taxes/Assessments (206.29) (455,574.66) GL 1165 03/26/2015 Property Taxes/Assessments (172.74) (455,747.40) GL 1172 03/26/2015 Rev Property Taxes/Assessments 172.74 (455,574.66) GL 1175 03/26/2015 Property Taxes/Assessments (48.96) (455,623.62) GL 1166 03/27/2015 Property Taxes/Assessments (195.38) (455,819.00) GL 1167 03/30/2015 Property Taxes/Assessments (622.50) (456,441.50) GL 1168 03/31/2015 Property Taxes/Assessments (163.33) (456,604.83) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (7,192.87) (456,604.83) ** (466,019.00) Budgeted (9,414.17) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1148 03/03/2015 Property Taxes/Assessments (1,572.08) (4.22) (1,576.30) GL 1154 03/12/2015 Property Taxes/Assessments (13.52) (1,589.82) GL 1174 03/20/2015 Property Taxes/Assessments 9.17 (1,580.65) GL 1162 03/23/2015 Property Taxes/Assessments (18.30) (1,598.95) GL 1163 03/24/2015 Property Taxes/Assessments 18.30 (1,580.65) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (8.57) (1,580.65) ** (2,500.00) Budgeted (919.35) Remaining 63 % Used Account: 533-40015-000-000 Property Taxes/P & I . glpdatb2 rgonzale Trophy Club MUD #1 Page 65 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1147 03/02/2015 Property Taxes/Assessments (691.78) (13.45) (705.23) GL 1148 03/03/2015 Property Taxes/Assessments (33.00) (738.23) GL 1149 03/04/2015 Property Taxes/Assessments (33.34) (771.57) GL 1151 03/09/2015 Property Taxes/Assessments (2.37) (773.94) GL 1152 03/10/2015 Property Taxes/Assessments (2.33) (776.27) GL 1153 03/11/2015 Property Taxes/Assessments (27.83) (804.10) GL 1154 03/12/2015 Property Taxes/Assessments (38.87) (842.97) GL 1155 03/13/2015 Property Taxes/Assessments (15.28) (858.25) GL 1156 03/16/2015 Property Taxes/Assessments (15.38) (873.63) GL 1157 03/17/2015 Property Taxes/Assessments (1.63) (875.26) GL 1158 03/18/2015 Property Taxes/Assessments (20.52) (895.78) GL 1160 03/19/2015 Property Taxes/Assessments (1.08) (896.86) GL 1161 03/20/2015 Property Taxes/Assessments 19.48 (877.38) GL 1173 03/20/2015 Rev Property Taxes/Assessments (19.48) (896.86) GL 1162 03/23/2015 Property Taxes/Assessments (5.81) (902.67) GL 1163 03/24/2015 Property Taxes/Assessments 1.93 (900.74) GL 1164 03/25/2015 Property Taxes/Assessments (15.59) (916.33) GL 1165 03/26/2015 Property Taxes/Assessments 115.26 (801.07) GL 1172 03/26/2015 Rev Property Taxes/Assessments (115.26) (916.33) GL 1175 03/26/2015 Property Taxes/Assessments (8.52) (924.85) GL 1167 03/30/2015 Property Taxes/Assessments (40.09) (964.94) GL 1168 03/31/2015 Property Taxes/Assessments (11.73) (976.67) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (284.89) (976.67) ** (1,600.00) Budgeted (623.33) Remaining 61 % 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 1139 03/31/2015 Bank Interest/March (3,333.67) (24.29) (3,357.96) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 66 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-49010-000-000 Interest Income Totals: (24.29) (3,357.96) ** (375.00) Budgeted 2,982.96 Remaining 895 % Used Account: 533-49015-000-000 Lease/Rental Income (211,829.00) .00 (211,829.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (211,829.00) ** (211,829.00) Budgeted .00 Remaining 100 % Used Account: 533-49110-000-000 Premium on Bonds Sold (4,957.90) .00 (4,957.90) _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: .00 (4,957.90) ** .00 Budgeted 4,957.90 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (679,307.01) ** (1,139,861.00) Budgeted (460,553.99) Remaining 60 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 67 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1,250.00 .00 1,250.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,250.00 ** 2,550.00 Budgeted 1,300.00 Remaining 49 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 89,253.75 .00 89,253.75 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 89,253.75 ** 403,103.00 Budgeted 313,849.25 Remaining 22 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 440,000.00 Budgeted 440,000.00 Remaining 0 % Used Account: 533-70040-051-000 Bond Interest Expense-Revenue .00 .00 _______________ Account: 533-70040-051-000 Bond Interest Expense-Revenue Totals: .00 .00 ** 292,283.00 Budgeted 292,283.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 90,503.75 ** 1,137,936.00 Budgeted 1,047,432.25 Remaining 8 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (588,803.26) (1,925.00) Budgeted 586,878.26 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MARCH 2015 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,053 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,053 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 15,053 TOTAL FUND BALANCE 15,053 TOTAL LIABILITIES AND FUND BALANCE 15,053 . glbase_tbam rgonzale Trophy Club MUD #1 Page 29 08:12 04/16/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income .62- 10,438.08- 10,438.08 534-49110-000-000 Bond Premium 4,615.00- 4,615.00 Subtotal: .62- 15,053.08- 15,053.08 Program number: .62- 15,053.08- 15,053.08 Department number: Revenues .62- 15,053.08- 15,053.08 Revenues Subtotal ----------- .62- 15,053.08- 15,053.08 Fund number: 534 2015 Revenue Bond I&S .62- 15,053.08- 15,053.08 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 68 08:13 04/16/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 1139 03/31/2015 Bank Interest/March (10,437.46) (.62) (10,438.08) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (.62) (10,438.08) ** .00 Budgeted 10,438.08 Remaining 0 % Used Account: 534-49110-000-000 Bond Premium (4,615.00) .00 (4,615.00) _______________ Account: 534-49110-000-000 Bond Premium Totals: .00 (4,615.00) ** .00 Budgeted 4,615.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (15,053.08) ** .00 Budgeted 15,053.08 Remaining 0 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (15,053.08) .00 Budgeted 15,053.08 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (15,197,124.39) **** 1,423.00 Budgeted 15,198,547.39 Remaining ########## ******* End of Report *********