Loading...
HomeMy WebLinkAbout2016-03 March Combined FinancialTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MARCH 2016 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 992,720 PREPAID EXPENSES 7,038 ADVALOREM PROPERTY TAXES RECEIVABLE 51,048 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,260 TOTAL ASSETS 1,053,066 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 51,048 ACCOUNTS AND OTHER PAYABLES 1,872 TOTAL LIABILITIES 52,920 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 466,649 TOTAL FUND BALANCE 1,000,146 TOTAL LIABILITIES AND FUND BALANCE 1,053,066 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 15:34 04/08/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 371,290.86- 91.825 33,055.14- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 345.54- 345.54 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 10,546.60- 871,635.48- 97.941 18,327.52- 122-40011-000-000 Property Taxes/Fire-Delinquent 5.66- 2,228.38- 2,228.38 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 836.12- 2,964.33- 65.874 1,535.67- Subtotal: 1,299,559.00- 1,299,559.00- 11,388.38- 1,248,464.59- 96.068 51,094.41- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 400.00- 4,000.00- 80.000 1,000.00- Subtotal: 5,000.00- 5,000.00- 400.00- 4,000.00- 80.000 1,000.00- 122-43400-000-000 Fire Inspections 825.00- 825.00- 75.00- 850.00- 103.030 25.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,825.00- 10,825.00- 10,075.00- 10,850.00- 100.231 25.00 122-49026-000-000 Proceeds from Sale of Assets 4,200.00- 60,000.00- 60,000.00 122-49900-000-000 Miscellaneous Income 50,000.00- 50,000.00- 800.00- 8,500.00- 17.000 41,500.00- Subtotal: 50,000.00- 50,000.00- 5,000.00- 68,500.00- 137.000 18,500.00 Program number: 1,365,384.00- 1,365,384.00- 26,863.38- 1,331,814.59- 97.541 33,569.41- Department number: Fire Revenues 1,365,384.00- 1,365,384.00- 26,863.38- 1,331,814.59- 97.541 33,569.41- Revenues Subtotal ----------- 1,365,384.00- 1,365,384.00- 26,863.38- 1,331,814.59- 97.541 33,569.41- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 15:34 04/08/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 508,226.00 508,226.00 35,376.65 223,161.49 43.910 285,064.51 122-50010-045-000 Overtime 48,735.00 48,735.00 4,292.44 30,031.38 61.622 18,703.62 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 14,717.53 92.843 1,134.47 122-50016-045-000 Longevity 5,761.00 5,761.00 5,730.00 99.462 31.00 122-50017-045-000 Certification 4,200.00 4,200.00 400.00 1,590.13 37.860 2,609.87 122-50020-045-000 Retirement 75,571.00 75,571.00 4,595.09 34,424.43 45.552 41,146.57 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 4,584.93 25,737.84 39.267 39,808.16 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 373.71 2,528.66 51.764 2,356.34 122-50028-045-000 Vision Insurance 859.00 859.00 70.77 520.14 60.552 338.86 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 328.09 1,796.14 39.174 2,788.86 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 2,282.91 15,972.14 44.205 20,159.86 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 533.75 3,734.47 44.195 4,715.53 122-50040-045-000 Unemployment Taxes 1,724.00 1,724.00 1,733.87 1,939.96 112.527 215.96- 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 9,379.00 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 54.00 21.600 196.00 Subtotal: 790,155.00 790,155.00 54,572.21 361,938.31 45.806 428,216.69 122-55030-045-000 Software & Support 6,661.00 6,661.00 462.50 2,775.00 41.660 3,886.00 122-55045-045-000 Legal 2,000.00 2,000.00 2,000.00 122-55080-045-000 Maintenance & Repairs 16,370.00 16,370.00 2,531.02 15,819.42 96.637 550.58 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 5,698.95 56.990 4,301.05 Subtotal: 35,031.00 35,031.00 2,993.52 24,293.37 69.348 10,737.63 122-60005-045-000 Telephone 50.00 50.00 5.22 22.60 45.200 27.40 122-60010-045-000 Communications/Mobiles 6,653.00 6,653.00 334.14 5,232.87 78.654 1,420.13 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 385.55 2,151.63 29.029 5,260.37 122-60025-045-000 Water 1,200.00 1,200.00 125.75 797.81 66.484 402.19 122-60026-045-000 Cable 1,920.00 1,920.00 287.45 1,053.28 54.858 866.72 122-60030-045-000 Rent And/Or Usage 214,379.00 214,379.00 214,379.00 100.000 122-60035-045-000 Postage 50.00 50.00 7.97 15.940 42.03 122-60055-045-000 Insurance 14,077.00 14,077.00 1,173.08 11,412.26 81.070 2,664.74 122-60066-045-000 Publications/Books/Subscrips 350.00 350.00 172.05 49.157 177.95 122-60070-045-000 Dues & Memberships 15,582.00 15,582.00 15,456.59 99.195 125.41 122-60080-045-000 Schools & Training 7,880.00 7,880.00 85.00 2,383.39 30.246 5,496.61 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 122-60100-045-000 Travel & per diem 4,081.00 4,081.00 25.00 958.34 23.483 3,122.66 122-60110-045-000 Physicals/Testing 4,700.00 4,700.00 4,700.00 122-60125-045-000 Advertising 500.00 500.00 4,200.00 4,200.00 840.000 3,700.00- 122-60160-045-000 Programs & Special Projects 7,500.00 7,500.00 688.39 9.179 6,811.61 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 359.29 71.858 140.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 132.50 389.50 12.233 2,794.50 122-60245-045-000 Miscellaneous Expense 1,001.00 1,001.00 99.50 491.14 49.065 509.86 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 15:34 04/08/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 292,019.00 292,019.00 6,853.19 260,156.11 89.089 31,862.89 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 326.72 2,194.53 14.512 12,927.47 122-65010-045-000 Uniforms 3,140.00 3,140.00 284.10 3,011.32 95.902 128.68 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 429.00 2,885.76 32.064 6,114.24 122-65030-045-000 Chemicals 600.00 600.00 600.00 122-65035-045-000 Small Tools 2,000.00 2,000.00 32.58 1,862.37 93.119 137.63 122-65055-045-000 Hardware 750.00 750.00 195.42 26.056 554.58 122-65085-045-000 Office Supplies 500.00 500.00 60.26 12.052 439.74 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 31,610.00 1,072.40 10,209.66 32.299 21,400.34 122-69050-045-000 Radios 8,000.00 8,000.00 8,000.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69255-045-000 Airpacks 285.81- 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 216,569.00 216,569.00 285.81- 208,568.60 96.306 8,000.40 Program number: 1,365,384.00 1,365,384.00 65,205.51 865,166.05 63.364 500,217.95 Department number: Fire 1,365,384.00 1,365,384.00 65,205.51 865,166.05 63.364 500,217.95 Expenditures Subtotal ----------- 1,365,384.00 1,365,384.00 65,205.51 865,166.05 63.364 500,217.95 Fund number: 122 Trophy Club MUD Fire Dept. 38,342.13 466,648.54- 466,648.54 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2016 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 (371,290.86) .00 (371,290.86) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (371,290.86) ** (404,346.00) Budgeted (33,055.14) Remaining 92 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (345.54) .00 (345.54) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (345.54) ** .00 Budgeted 345.54 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1295 03/02/2016 Property Taxes/Assessments (861,088.88) (911.68) (862,000.56) GL 1296 03/03/2016 Property Taxes/Assessments 1,617.65 (860,382.91) GL 1297 03/04/2016 Property Taxes/Assessments (4,516.68) (864,899.59) GL 1298 03/07/2016 Property Taxes/Assessments (14.61) (864,914.20) GL 1299 03/08/2016 Property Taxes/Assessments (236.12) (865,150.32) GL 1300 03/09/2016 Property Taxes/Assessments (273.53) (865,423.85) GL 1301 03/10/2016 Property Taxes/Assessments (288.70) (865,712.55) GL 1302 03/11/2016 Property Taxes/Assessments (98.77) (865,811.32) GL 1303 03/14/2016 Property Taxes/Assessments (326.68) (866,138.00) GL 1304 03/16/2016 Property Taxes/Assessments (693.82) (866,831.82) GL 1305 03/17/2016 Property Taxes/Assessments (547.85) (867,379.67) GL 1307 03/18/2016 Property Taxes/Assessments (611.26) (867,990.93) GL 1306 03/21/2016 Property Taxes/Assessments (549.94) (868,540.87) GL 1308 03/22/2016 Property Taxes/Assessments (32.29) (868,573.16) GL 1309 03/24/2016 Property Taxes/Assessments (109.16) (868,682.32) GL 1310 03/28/2016 Property Taxes/Assessments (973.60) (869,655.92) GL 1311 03/29/2016 Property Taxes/Assessments (413.47) (870,069.39) GL 1312 03/30/2016 Property Taxes/Assessments (172.05) (870,241.44) GL 1313 03/31/2016 Property Taxes/Assessments (1,394.04) (871,635.48) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (10,546.60) (871,635.48) ** (889,963.00) Budgeted (18,327.52) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1295 03/02/2016 Property Taxes/Assessments (2,222.72) (7.50) (2,230.22) GL 1298 03/07/2016 Property Taxes/Assessments 9.28 (2,220.94) GL 1306 03/21/2016 Property Taxes/Assessments (7.44) (2,228.38) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (5.66) (2,228.38) ** .00 Budgeted 2,228.38 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I .00 .00 _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 .00 ** (750.00) Budgeted (750.00) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1295 03/02/2016 Property Taxes/Assessments (2,128.21) (67.51) (2,195.72) GL 1296 03/03/2016 Property Taxes/Assessments (2.85) (2,198.57) GL 1297 03/04/2016 Property Taxes/Assessments (395.07) (2,593.64) GL 1298 03/07/2016 Property Taxes/Assessments (2.73) (2,596.37) GL 1299 03/08/2016 Property Taxes/Assessments (18.35) (2,614.72) GL 1300 03/09/2016 Property Taxes/Assessments (22.25) (2,636.97) GL 1301 03/10/2016 Property Taxes/Assessments (7.64) (2,644.61) GL 1302 03/11/2016 Property Taxes/Assessments (1.39) (2,646.00) GL 1303 03/14/2016 Property Taxes/Assessments 15.41 (2,630.59) GL 1304 03/16/2016 Property Taxes/Assessments (56.81) (2,687.40) GL 1305 03/17/2016 Property Taxes/Assessments (38.55) (2,725.95) GL 1307 03/18/2016 Property Taxes/Assessments (51.61) (2,777.56) GL 1306 03/21/2016 Property Taxes/Assessments (26.40) (2,803.96) GL 1309 03/24/2016 Property Taxes/Assessments (.09) (2,804.05) GL 1310 03/28/2016 Property Taxes/Assessments (30.10) (2,834.15) GL 1311 03/29/2016 Property Taxes/Assessments (13.01) (2,847.16) GL 1312 03/30/2016 Property Taxes/Assessments (15.48) (2,862.64) GL 1313 03/31/2016 Property Taxes/Assessments (101.69) (2,964.33) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (836.12) (2,964.33) ** (4,500.00) Budgeted (1,535.67) Remaining 66 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (3,600.00) (400.00) (4,000.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (4,000.00) ** (5,000.00) Budgeted (1,000.00) Remaining 80 % Used Account: 122-43400-000-000 Fire Inspections . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (775.00) (75.00) (850.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (850.00) ** (825.00) Budgeted 25.00 Remaining 103 % Used Account: 122-43415-000-000 Denton County Pledge-Fire 1229 03/08/2016 Denton County Fire Pledge (10,000.00) (10,000.00) GL _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: (10,000.00) (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49026-000-000 Proceeds from Sale of Assets 1343 03/31/2016 Recode FT Advertising Recode FT Advertising (55,800.00) (4,200.00) (60,000.00) GL _______________ Account: 122-49026-000-000 Proceeds from Sale of Assets Totals: (4,200.00) (60,000.00) ** .00 Budgeted 60,000.00 Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (7,700.00) (800.00) (8,500.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (800.00) (8,500.00) ** (50,000.00) Budgeted (41,500.00) Remaining 17 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,331,814.59) ** (1,365,384.00) Budgeted (33,569.41) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 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 1145 03/11/2016 FD Payroll 3/11/16 187,784.84 17,962.51 205,747.35 GL 1212 03/25/2016 FD Payroll 3/25/16 17,414.14 223,161.49 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 35,376.65 223,161.49 ** 508,226.00 Budgeted 285,064.51 Remaining 44 % Used Account: 122-50010-045-000 Overtime 1145 03/11/2016 FD Payroll 3/11/16 25,738.94 4,292.44 30,031.38 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,292.44 30,031.38 ** 48,735.00 Budgeted 18,703.62 Remaining 62 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,717.53 .00 14,717.53 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,717.53 ** 15,852.00 Budgeted 1,134.47 Remaining 93 % Used Account: 122-50016-045-000 Longevity 5,730.00 .00 5,730.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,730.00 ** 5,761.00 Budgeted 31.00 Remaining 99 % Used Account: 122-50017-045-000 Certification 1145 03/11/2016 FD Payroll 3/11/16 1,190.13 400.00 1,590.13 GL _______________ Account: 122-50017-045-000 Certification Totals: 400.00 1,590.13 ** 4,200.00 Budgeted 2,609.87 Remaining 38 % Used Account: 122-50020-045-000 Retirement 1145 03/11/2016 FD Payroll 3/11/16 29,829.34 2,491.68 32,321.02 GL 1212 03/25/2016 FD Payroll 3/25/16 2,103.41 34,424.43 GL _______________ Account: 122-50020-045-000 Retirement Totals: 4,595.09 34,424.43 ** 75,571.00 Budgeted 41,146.57 Remaining 46 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 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 1145 03/11/2016 FD Payroll 3/11/16 21,152.91 2,680.34 23,833.25 GL 1212 03/25/2016 FD Payroll 3/25/16 1,904.59 25,737.84 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,584.93 25,737.84 ** 65,546.00 Budgeted 39,808.16 Remaining 39 % Used Account: 122-50027-045-000 Dental Insurance 1145 03/11/2016 FD Payroll 3/11/16 2,154.95 186.81 2,341.76 GL 1212 03/25/2016 FD Payroll 3/25/16 186.90 2,528.66 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 373.71 2,528.66 ** 4,885.00 Budgeted 2,356.34 Remaining 52 % Used Account: 122-50028-045-000 Vision Insurance 1145 03/11/2016 FD Payroll 3/11/16 449.37 35.33 484.70 GL 1212 03/25/2016 FD Payroll 3/25/16 35.44 520.14 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 70.77 520.14 ** 859.00 Budgeted 338.86 Remaining 61 % Used Account: 122-50029-045-000 Life Insurance & Other 1145 03/11/2016 FD Payroll 3/11/16 1,468.05 163.98 1,632.03 GL 1212 03/25/2016 FD Payroll 3/25/16 164.11 1,796.14 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 328.09 1,796.14 ** 4,585.00 Budgeted 2,788.86 Remaining 39 % Used Account: 122-50030-045-000 Social Security Taxes 1145 03/11/2016 FD Payroll 3/11/16 13,689.23 1,303.90 14,993.13 GL 1212 03/25/2016 FD Payroll 3/25/16 979.01 15,972.14 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,282.91 15,972.14 ** 36,132.00 Budgeted 20,159.86 Remaining 44 % Used Account: 122-50035-045-000 Medicare Taxes 1145 03/11/2016 FD Payroll 3/11/16 3,200.72 304.84 3,505.56 GL 1212 03/25/2016 FD Payroll 3/25/16 228.91 3,734.47 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 533.75 3,734.47 ** 8,450.00 Budgeted 4,715.53 Remaining 44 % Used Account: 122-50040-045-000 Unemployment Taxes 1145 03/11/2016 FD Payroll 3/11/16 206.09 4.41 210.50 GL 1212 03/25/2016 FD Payroll 3/25/16 1,729.46 1,939.96 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 1,733.87 1,939.96 ** 1,724.00 Budgeted (215.96) Remaining 113 % Used Account: 122-50045-045-000 Workman's Compensation .00 .00 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 .00 ** 9,379.00 Budgeted 9,379.00 Remaining 0 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 54.00 .00 54.00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 54.00 ** 250.00 Budgeted 196.00 Remaining 22 % Used Account: 122-55030-045-000 Software & Support 1235 03/30/2016 March A/P Charter, Verizon 2,312.50 462.50 2,775.00 TOWN OF TROPHY CLUB 1732 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 2,775.00 ** 6,661.00 Budgeted 3,886.00 Remaining 42 % Used Account: 122-55045-045-000 Legal .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 1332 03/01/2016 Recode MES/Airpacks 13,288.40 285.81 13,574.21 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1147 03/11/2016 Mar A/P Air test/System Cascade 13,288.40 233.75 13,807.96 AUGUST INDUSTRIES, INC 1682 AP 1147 03/11/2016 Mar A/P Repair Back Kitchen door 1,569.99 15,377.95 MICHAEL'S KEYS INC. 1700 AP 1191 03/22/2016 Mar A/P Annual Backflow Test 50.00 15,427.95 RESCOM FIRE SYSTEMS, INC. 1709 AP 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 96.46 15,524.41 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P WAREHOUSE LIGHTING COM 217.20 15,741.61 WAREHOUSE LIGHTING COM PC 1294 03/28/2016 Mar A/P SAMS CLUB #4795 21.95 15,763.56 SAMS CLUB #4795 PC 1326 03/31/2016 Mar A/P Rug Service-Fire Dept 37.24 15,800.80 G & K SERVICES AP 1326 03/31/2016 Mar A/P Rug Service-Fire Dept 37.24 15,838.04 G & K SERVICES AP 1326 03/31/2016 Mar A/P Rug Service-Fire Dept 37.24 15,875.28 G & K SERVICES AP 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (55.86) 15,819.42 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 2,531.02 15,819.42 ** 16,370.00 Budgeted 550.58 Remaining 97 % Used Account: 122-55090-045-000 Vehicle Maintenance 5,698.95 .00 5,698.95 _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 5,698.95 ** 10,000.00 Budgeted 4,301.05 Remaining 57 % Used Account: 122-60005-045-000 Telephone 1294 03/28/2016 Mar A/P ATT*BUS PHONE PMT 17.38 5.22 22.60 ATT*BUS PHONE PMT PC _______________ Account: 122-60005-045-000 Telephone Totals: 5.22 22.60 ** 50.00 Budgeted 27.40 Remaining 45 % Used Account: 122-60010-045-000 Communications/Mobiles 1145 03/11/2016 FD Payroll 3/11/16 4,898.73 75.00 4,973.73 GL 1235 03/30/2016 March A/P Charter, Verizon 259.14 5,232.87 TOWN OF TROPHY CLUB 1732 AP _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 334.14 5,232.87 ** 6,653.00 Budgeted 1,420.13 Remaining 79 % Used Account: 122-60020-045-000 Electricity/Gas 1147 03/11/2016 Mar A/P Electricity 2/10-3/10/16 1,766.08 681.48 2,447.56 HUDSON ENERGY SERVICES, LLC 1692 AP 1191 03/22/2016 Mar A/P Fire station Gas 2/16-3/16/16 89.62 2,537.18 ATMOS ENERGY 1681 AP 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (385.55) 2,151.63 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 385.55 2,151.63 ** 7,412.00 Budgeted 5,260.37 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60025-045-000 Water 1326 03/31/2016 Mar A/P March Water Fire Station 672.06 204.84 876.90 TROPHY CLUB MUD (WATER BILLS) AP 1326 03/31/2016 Mar A/P March Water/Fire Station irrig 46.66 923.56 TROPHY CLUB MUD (WATER BILLS) AP 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (125.75) 797.81 AR _______________ Account: 122-60025-045-000 Water Totals: 125.75 797.81 ** 1,200.00 Budgeted 402.19 Remaining 66 % Used Account: 122-60026-045-000 Cable 1294 03/28/2016 Mar A/P ATT*BILL PAYMENT 765.83 128.76 894.59 ATT*BILL PAYMENT PC 1294 03/28/2016 Mar A/P ATT*BILL PAYMENT 158.69 1,053.28 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 287.45 1,053.28 ** 1,920.00 Budgeted 866.72 Remaining 55 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,379.00 .00 214,379.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,379.00 ** 214,379.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 7.97 .00 7.97 _______________ Account: 122-60035-045-000 Postage Totals: .00 7.97 ** 50.00 Budgeted 42.03 Remaining 16 % Used Account: 122-60055-045-000 Insurance 137 03/01/2016 Prepaid Insurance, W/C Mar 10,239.18 1,173.08 11,412.26 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,173.08 11,412.26 ** 14,077.00 Budgeted 2,664.74 Remaining 81 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 172.05 .00 172.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 172.05 ** 350.00 Budgeted 177.95 Remaining 49 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60070-045-000 Dues & Memberships 15,456.59 .00 15,456.59 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 15,456.59 ** 15,582.00 Budgeted 125.41 Remaining 99 % Used Account: 122-60080-045-000 Schools & Training 1147 03/11/2016 Mar A/P Tackett-Basic Incident Safety 2,298.39 85.00 2,383.39 TX COMM ON FIRE PROTECTION 1715 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 2,383.39 ** 7,880.00 Budgeted 5,496.61 Remaining 30 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem 1294 03/28/2016 Mar A/P VINNYS ITALIAN RESTAUR 933.34 25.00 958.34 VINNYS ITALIAN RESTAUR PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 25.00 958.34 ** 4,081.00 Budgeted 3,122.66 Remaining 23 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 1343 03/31/2016 Recode FT Advertising Recode FT Advertising 4,200.00 4,200.00 GL _______________ Account: 122-60125-045-000 Advertising Totals: 4,200.00 4,200.00 ** 500.00 Budgeted (3,700.00) Remaining 840 % Used Account: 122-60160-045-000 Programs & Special Projects . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 688.39 .00 688.39 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 688.39 ** 7,500.00 Budgeted 6,811.61 Remaining 9 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 359.29 .00 359.29 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 359.29 ** 500.00 Budgeted 140.71 Remaining 72 % Used Account: 122-60195-045-000 Flags & Repair 1191 03/22/2016 Mar A/P Flag repair 257.00 265.00 522.00 SYMONDS FLAGS & POLES 1711 AP 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (132.50) 389.50 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 132.50 389.50 ** 3,184.00 Budgeted 2,794.50 Remaining 12 % Used Account: 122-60245-045-000 Miscellaneous Expense 1326 03/31/2016 Mar A/P Badge 391.64 99.50 491.14 ENTENMANN-ROVIN CO AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 99.50 491.14 ** 1,001.00 Budgeted 509.86 Remaining 49 % Used Account: 122-65005-045-000 Fuel & Lube 1326 03/31/2016 Mar A/P 1/25/16-2/24/16 Fuel purchases 1,867.81 326.72 2,194.53 US Bank Voyager Fleet Systems AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 326.72 2,194.53 ** 15,122.00 Budgeted 12,927.47 Remaining 15 % Used Account: 122-65010-045-000 Uniforms 1235 03/30/2016 March A/P Shirts, pants, emblems 2,727.22 568.20 3,295.42 RED THE UNIFORM TAILOR 1730 AP 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (284.10) 3,011.32 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 284.10 3,011.32 ** 3,140.00 Budgeted 128.68 Remaining 96 % Used Account: 122-65015-045-000 Protective Clothing . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1326 03/31/2016 Mar A/P Cleaning/Thomas, Peters, Hawki 2,456.76 429.00 2,885.76 Gear Cleaning Solutions, LLC AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 429.00 2,885.76 ** 9,000.00 Budgeted 6,114.24 Remaining 32 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 1191 03/22/2016 Mar A/P Air Pack epic bracket 1,829.79 32.58 1,862.37 MUNICIPAL EMERGENCY SERVICES 1703 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 32.58 1,862.37 ** 2,000.00 Budgeted 137.63 Remaining 93 % Used Account: 122-65055-045-000 Hardware 195.42 .00 195.42 _______________ Account: 122-65055-045-000 Hardware Totals: .00 195.42 ** 750.00 Budgeted 554.58 Remaining 26 % Used Account: 122-65085-045-000 Office Supplies 60.26 .00 60.26 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 60.26 ** 500.00 Budgeted 439.74 Remaining 12 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 498.00 Budgeted 498.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 8,000.00 Budgeted 8,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks 1332 03/01/2016 Recode MES/Airpacks 285.81 (285.81) .00 GL _______________ Account: 122-69255-045-000 Airpacks Totals: (285.81) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 865,166.05 ** 1,365,384.00 Budgeted 500,217.95 Remaining 63 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (466,648.54) .00 Budgeted 466,648.54 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MARCH 2016 0 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 3/31/16 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 252,179 - - 252,179 CD-BANK OF THE WEST/THB DEPOSIT 35,000 35,000 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,510,722 - - 1,510,722 INVESTMENTS-TEXPOOL 1,370,240 326,020 - 1,696,260 PREPAID EXPENSES 32,963 - - 32,963 ADVALOREM PROPERTY TAXES RECEIVABLE 1,593 - - 1,593 UTILITY AND OTHER ACCOUNTS RECEIVABLE 554,819 - - 554,819 - TOTAL ASSETS 3,758,116 326,020 - 4,084,136 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,593 - - 1,593 ACCOUNTS AND OTHER PAYABLES 818,372 - - 818,372 CUSTOMER DEPOSITS 315,312 - - 315,312 - TOTAL LIABILITIES 1,135,277 - - 1,135,277 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 326,020 326,020 NON-SPENDABLE FUND BALANCE 30,686 30,686 ASSIGNED FUND BALANCE 407,000 - 407,000 UNASSIGNED FUND BALANCE 1,592,494 - 8,032 1,600,526 COMMITTED FUND BALANCE 1,159,233 - - 1,159,233 NET REVENUES / EXPENDITURES (566,574) - (8,032) (574,606) - TOTAL FUND BALANCE 2,622,839 326,020 - 2,948,859 - TOTAL LIABILITIES AND FUND BALANCE 3,758,116 326,020 - 4,084,136 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 58,181.00- 58,181.00- 689.27- 56,966.45- 97.912 1,214.55- 135-40002-000-000 Property Taxes/Delinquent 1.09- 276.31- 276.31 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 55.07- 237.93- 36.605 412.07- 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 24,739.19- 16.930 121,385.81- Subtotal: 204,956.00- 204,956.00- 745.43- 82,219.88- 40.116 122,736.12- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 266,463.37- 1,646,998.05- 32.420 3,433,245.95- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 175,148.06- 1,009,110.77- 41.806 1,404,665.23- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 7,784.48- 54,468.12- 59.865 36,516.88- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 975.00- 7,925.00- 88.056 1,075.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 1,650.00- 82.500 350.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 450.00- 4,800.00- 87.273 700.00- 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 812.00- 7,399.70- 12.065 53,930.30- Subtotal: 7,662,835.00- 7,662,835.00- 451,782.91- 2,732,351.64- 35.657 4,930,483.36- 135-48005-000-000 Utility Fees 69,000.00- 69,000.00- 55,200.00- 80.000 13,800.00- Subtotal: 69,000.00- 69,000.00- 55,200.00- 80.000 13,800.00- 135-49010-000-000 Interest Income 6,000.00- 6,000.00- 1,272.88- 5,932.89- 98.882 67.11- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 5,463.18- 50.002 5,462.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-49026-000-000 Proceeds from Sale of Assets 15,865.00- 30,935.00- 30,935.00 135-49035-000-000 Prior Year Reserves 8,020.00- 8,020.00- 8,020.00- 135-49075-000-000 Oversize Meter Reimbursement 15,778.00- 15,778.00- 1,715.00- 33,962.80- 215.254 18,184.80 135-49141-000-000 Interfund Transfer In 8,034.36- 8,034.36 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 75.47- 1,161.47- 1.836 62,087.53- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.40- 102.000 .40 Subtotal: 110,993.00- 110,993.00- 20,422.21- 89,010.08- 80.194 21,982.92- Program number: 8,047,784.00- 8,047,784.00- 472,950.55- 2,958,781.60- 36.765 5,089,002.40- Department number: Revenues 8,047,784.00- 8,047,784.00- 472,950.55- 2,958,781.60- 36.765 5,089,002.40- Revenues Subtotal ----------- 8,047,784.00- 8,047,784.00- 472,950.55- 2,958,781.60- 36.765 5,089,002.40- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 265,614.00 16,415.52 100,808.75 37.953 164,805.25 135-50010-010-000 Overtime 19,500.00 19,500.00 707.31 6,061.39 31.084 13,438.61 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 100.000 135-50017-010-000 Certification 4,200.00 4,200.00 200.00 1,125.00 26.786 3,075.00 135-50020-010-000 Retirement 25,558.00 25,558.00 1,512.30 9,790.19 38.306 15,767.81 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,161.15 18,459.76 35.915 32,938.24 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 240.77 1,380.10 34.511 2,618.90 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 311.24 34.202 598.76 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 196.85 1,157.60 41.299 1,645.40 135-50030-010-000 Social Security Taxes 18,565.00 18,565.00 1,062.55 6,815.93 36.714 11,749.07 135-50035-010-000 Medicare Taxes 4,341.00 4,341.00 248.50 1,594.03 36.720 2,746.97 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 727.17 764.27 61.535 477.73 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,229.35 5,061.58 34.306 9,692.42 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 236.45 18.188 1,063.55 135-50070-010-000 Employee Relations 300.00 300.00 75.22 75.22 25.073 224.78 Subtotal: 417,429.00 417,429.00 25,830.67 156,586.51 37.512 260,842.49 135-55005-010-000 Engineering 5,000.00 5,000.00 13,395.00 267.900 8,395.00- 135-55080-010-000 Maintenance & Repairs 85,000.00 85,000.00 5,074.61 56,408.33 66.363 28,591.67 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 54.36 2,867.58 35.845 5,132.42 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 2,408.55 2,892.77 82.651 607.23 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 315.00 2,009.17 36.530 3,490.83 Subtotal: 107,000.00 107,000.00 7,852.52 77,572.85 72.498 29,427.15 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 347.05 2,184.05 40.445 3,215.95 135-60020-010-000 Electricity 166,823.00 166,823.00 8,405.62 58,090.93 34.822 108,732.07 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 500.00 500.00 11.00 2.200 489.00 135-60080-010-000 Schools & Training 5,773.00 5,773.00 1,075.00 18.621 4,698.00 135-60090-010-000 Safety Program 400.00 400.00 248.97 62.243 151.03 135-60100-010-000 Travel & per diem 1,400.00 1,400.00 63.93 78.18 5.584 1,321.82 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 10,501.40 21.312 38,773.60 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 130,501.45 717,770.53 24.342 2,230,971.47 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 709.79 2,199.64 62.847 1,300.36 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 3,186,763.00 3,186,763.00 140,027.84 792,159.70 24.858 2,394,603.30 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 559.89 7,620.23 21.199 28,326.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 4,608.00 4,608.00 2,006.73 43.549 2,601.27 135-65030-010-000 Chemicals 12,000.00 12,000.00 1,089.59 6,447.42 53.729 5,552.58 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 255.50 443.49 44.349 556.51 135-65050-010-000 Meter Expense 115,000.00 115,000.00 300.00 87,305.34 75.918 27,694.66 135-65053-010-000 Meter Change Out Program 50,000.00 50,000.00 77,325.00 154.650 27,325.00- Subtotal: 219,755.00 219,755.00 2,204.98 181,148.21 82.432 38,606.79 135-69005-010-000 Capital Outlays 201,000.00 201,000.00 75,569.00 306,980.64 152.727 105,980.64- 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,700.34 99.985 19.66 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 44.86- 1,177.54 97.398 31.46 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 126,958.00 126,958.00 8,183.33 126,957.75 100.000 .25 Subtotal: 534,887.00 534,887.00 83,707.47 640,816.27 119.804 105,929.27- Program number: 4,465,834.00 4,465,834.00 259,623.48 1,848,283.54 41.387 2,617,550.46 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2016 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 208.85 736.55 14.731 4,263.45 Subtotal: 5,000.00 5,000.00 208.85 736.55 14.731 4,263.45 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 208.85 736.55 7.366 9,263.45 Department number: Water 4,475,834.00 4,475,834.00 259,832.33 1,849,020.09 41.311 2,626,813.91 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 27,607.28 167,357.46 47.589 184,313.54 135-50010-020-000 Overtime 19,500.00 19,500.00 2,942.22 16,283.79 83.507 3,216.21 135-50016-020-000 Longevity 6,125.00 6,125.00 6,125.00 100.000 135-50017-020-000 Certification 7,200.00 7,200.00 625.00 3,600.00 50.000 3,600.00 135-50020-020-000 Retirement 33,652.00 33,652.00 2,721.53 17,056.40 50.685 16,595.60 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 5,531.97 30,732.72 46.572 35,256.28 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 347.91 1,858.35 44.416 2,325.65 135-50028-020-000 Vision Insurance 972.00 972.00 78.05 422.80 43.498 549.20 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 352.90 1,985.99 54.336 1,669.01 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 1,735.55 10,946.97 44.383 13,718.03 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 405.90 2,560.16 44.386 3,207.84 135-50040-020-000 Unemployment Taxes 1,449.00 1,449.00 1,137.45 1,203.57 83.062 245.43 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 776.43 2,344.09 25.159 6,972.91 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 238.45 79.483 61.55 135-50070-020-000 Employee Relations 650.00 650.00 102.40 283.28 43.582 366.72 Subtotal: 535,097.00 535,097.00 44,364.59 262,999.03 49.150 272,097.97 135-55070-020-000 Independent Labor 50,000.00 50,000.00 81,943.24 81,943.24 163.886 31,943.24- 135-55080-020-000 Maintenance & Repairs 72,600.00 72,600.00 26,621.30 58,933.47 81.176 13,666.53 135-55090-020-000 Vehicle Maintenance 5,000.00 5,000.00 2,921.96 4,151.34 83.027 848.66 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 291.00 291.00 58.200 209.00 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 4,774.68 19,476.84 35.412 35,523.16 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 8,411.63 22,682.40 64.807 12,317.60 Subtotal: 218,100.00 218,100.00 124,963.81 187,478.29 85.960 30,621.71 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 412.08 2,868.05 53.112 2,531.95 135-60020-020-000 Electricity 161,582.00 161,582.00 10,353.49 57,181.09 35.388 104,400.91 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 300.00 300.00 200.00 200.00 66.667 100.00 135-60080-020-000 Schools & Training 3,771.00 3,771.00 1,412.00 2,242.00 59.454 1,529.00 135-60090-020-000 Safety Program 550.00 550.00 103.88 296.67 53.940 253.33 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 4.65- 619.70 38.731 980.30 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 19,109.46 34,468.74 92.783 2,681.26 135-60245-020-000 Miscellaneous Expenses 297.00 297.00 150.00 150.00 50.505 147.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706.00 119,706.00 19,951.00 19,951.00 16.667 99,755.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 43,220.32 228,735.92 51.421 216,095.08 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 61,668.00 50.000 61,668.00 Subtotal: 908,423.00 908,423.00 94,907.58 408,381.17 44.955 500,041.83 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 32,021.00 32,021.00 426.15 5,814.17 18.157 26,206.83 135-65010-020-000 Uniforms 4,241.00 4,241.00 2,503.53 59.032 1,737.47 135-65030-020-000 Chemicals 27,000.00 27,000.00 5,890.00 17,698.25 65.549 9,301.75 135-65035-020-000 Small Tools 2,000.00 2,000.00 220.50 11.025 1,779.50 135-65040-020-000 Safety Equipment 750.00 750.00 576.59 76.879 173.41 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 5,191.26 10,480.41 80.619 2,519.59 Subtotal: 79,012.00 79,012.00 11,507.41 37,293.45 47.200 41,718.55 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 24,742.00 57,940.75 38.627 92,059.25 135-69008-020-000 Short Term Debt-Principal 21,280.00 21,280.00 21,276.80 99.985 3.20 135-69009-020-000 Short Term Debt-Interest 197.00 197.00 2.00- 197.00 100.000 Subtotal: 171,477.00 171,477.00 24,740.00 79,414.55 46.312 92,062.45 Program number: 1,912,109.00 1,912,109.00 300,483.39 975,566.49 51.020 936,542.51 Department number: Wastewater 1,912,109.00 1,912,109.00 300,483.39 975,566.49 51.020 936,542.51 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 12,500.00 12,500.00 200.00 3,300.00 26.400 9,200.00 135-50030-026-000 Social Security Taxes 775.00 775.00 12.40 204.60 26.400 570.40 135-50035-026-000 Medicare Taxes 181.00 181.00 2.90 47.85 26.436 133.15 135-50040-026-000 Unemployment Taxes 230.00 230.00 9.20 12.30 5.348 217.70 135-50045-026-000 Workman's Compensation 37.00 37.00 3.08 31.49 85.108 5.51 Subtotal: 13,723.00 13,723.00 227.58 3,596.24 26.206 10,126.76 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 10.98 2.196 489.02 135-60075-026-000 Meetings 1,200.00 1,200.00 15.67 21.67 1.806 1,178.33 135-60080-026-000 Schools & Training 4,000.00 4,000.00 355.00 905.00 22.625 3,095.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,602.43 32.049 3,397.57 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 50.48 2.524 1,949.52 Subtotal: 12,850.00 12,850.00 370.67 2,590.56 20.160 10,259.44 Program number: 26,573.00 26,573.00 598.25 6,186.80 23.282 20,386.20 Department number: Board of Directors 26,573.00 26,573.00 598.25 6,186.80 23.282 20,386.20 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 488,508.00 488,508.00 37,241.77 227,283.97 46.526 261,224.03 135-50010-030-000 Overtime 1,000.00 1,000.00 24.16 151.76 15.176 848.24 135-50016-030-000 Longevity 3,823.00 3,823.00 3,822.50 99.987 .50 135-50020-030-000 Retirement 43,202.00 43,202.00 3,253.32 20,403.79 47.229 22,798.21 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 5,310.72 30,595.79 44.864 37,600.21 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 378.79 2,084.20 43.358 2,722.80 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 87.14 481.05 43.182 632.95 135-50029-030-000 Life Insurance & Other 4,431.00 4,431.00 393.35 2,326.27 52.500 2,104.73 135-50030-030-000 Social Security Taxes 30,823.00 30,823.00 2,124.38 13,374.34 43.391 17,448.66 135-50035-030-000 Medicare Taxes 7,599.00 7,599.00 496.83 3,127.86 41.161 4,471.14 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 1,096.79 1,150.65 79.410 298.35 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.89 1,179.34 75.891 374.66 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 19.66 2,880.22 57.604 2,119.78 Subtotal: 662,006.00 662,006.00 50,574.80 308,861.74 46.655 353,144.26 135-55030-030-000 Software & Support 78,483.00 78,483.00 19,199.27 31,477.16 40.107 47,005.84 135-55070-030-000 Independent Labor 12,000.00 12,000.00 48.75 12,971.98 108.100 971.98- 135-55080-030-000 Maintenance & Repairs 29,500.00 29,500.00 1,438.69 11,128.35 37.723 18,371.65 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 210.09 4,326.92 61.813 2,673.08 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 584.75 2,664.75 26.319 7,460.25 135-55160-030-000 Professional Outside Services 61,075.00 61,075.00 53,072.50 86.897 8,002.50 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 581.60 3,122.47 38.079 5,077.53 Subtotal: 206,583.00 206,583.00 22,063.15 118,764.13 57.490 87,818.87 135-60005-030-000 Telephone 16,349.00 16,349.00 1,016.92 6,396.03 39.122 9,952.97 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 337.99 2,027.94 48.866 2,122.06 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 3,711.28 34.466 7,056.72 135-60025-030-000 Water 1,500.00 1,500.00 69.78 458.67 30.578 1,041.33 135-60035-030-000 Postage 28,932.00 28,932.00 2,886.87 12,192.00 42.140 16,740.00 135-60040-030-000 Service Charges & Fees 44,000.00 44,000.00 4,086.19 31,060.94 70.593 12,939.06 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 940.30 2,015.35 57.581 1,484.65 135-60055-030-000 Insurance 52,797.00 52,797.00 2,806.00 16,837.00 31.890 35,960.00 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 5,006.25 83.438 993.75 135-60075-030-000 Meetings 400.00 400.00 29.00 7.250 371.00 135-60079-030-000 Public Education 5,000.00 5,000.00 2,162.04 3,646.23 72.925 1,353.77 135-60080-030-000 Schools & Training 9,935.00 9,935.00 851.00 3,272.50 32.939 6,662.50 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 235.76 2,468.00 45.704 2,932.00 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 7,500.00 7,500.00 6.00 6.00 .080 7,494.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 7,500.00 7,500.00 61.74 .823 7,438.26 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,501.00 17,501.00 4,073.98 23.279 13,427.02 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 656.38 26.255 1,843.62 Subtotal: 226,882.00 226,882.00 15,398.85 93,919.29 41.396 132,962.71 135-65010-030-000 Uniforms 1,855.00 1,855.00 23.00 1.240 1,832.00 135-65055-030-000 Hardware 29,594.00 29,594.00 5,871.85 19.841 23,722.15 135-65085-030-000 Office Supplies 9,000.00 9,000.00 450.45 3,424.20 38.047 5,575.80 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 185.14 406.44 10.153 3,596.56 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 220.05 2,092.04 41.841 2,907.96 135-65105-030-000 Printing 4,800.00 4,800.00 59.88 59.88 1.248 4,740.12 Subtotal: 54,252.00 54,252.00 915.52 11,877.41 21.893 42,374.59 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 6,158.00 10.996 49,842.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 230.50 1,672.85 36.366 2,927.15 Subtotal: 60,600.00 60,600.00 230.50 7,830.85 12.922 52,769.15 Program number: 1,210,323.00 1,210,323.00 89,182.82 541,253.42 44.720 669,069.58 Department number: Administration 1,210,323.00 1,210,323.00 89,182.82 541,253.42 44.720 669,069.58 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 15:34 04/08/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 386,130.00 386,130.00 120,596.39 31.232 265,533.61 135-55055-039-000 Auditing 22,750.00 22,750.00 24,039.38 105.668 1,289.38- 135-55060-039-000 Appraisal 10,265.00 10,265.00 1,994.51 6,224.41 60.637 4,040.59 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,468.82 64.969 1,331.18 Subtotal: 422,945.00 422,945.00 1,994.51 153,329.00 36.253 269,616.00 Program number: 422,945.00 422,945.00 1,994.51 153,329.00 36.253 269,616.00 Department number: Non Departmental 422,945.00 422,945.00 1,994.51 153,329.00 36.253 269,616.00 Expenditures Subtotal ----------- 8,047,784.00 8,047,784.00 652,091.30 3,525,355.80 43.805 4,522,428.20 Fund number: 135 MUD 1 General Fund 179,140.75 566,574.20 566,574.20- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 15:34 04/08/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 15:34 04/08/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 2.77- 2.77 Subtotal: 2.77- 2.77 Program number: 2.77- 2.77 Department number: 2.77- 2.77 Revenues Subtotal ----------- 2.77- 2.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 15:34 04/08/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 8,034.36- Subtotal: 8,034.36 8,034.36- Program number: 8,034.36 8,034.36- Department number: Wastewater 8,034.36 8,034.36- Expenditures Subtotal ----------- 8,034.36 8,034.36- Fund number: 507 MUD 1 Capital Projects 8,031.59 8,031.59- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2016 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 1295 03/02/2016 Property Taxes/Assessments (56,277.18) (59.58) (56,336.76) GL 1296 03/03/2016 Property Taxes/Assessments 105.72 (56,231.04) GL 1297 03/04/2016 Property Taxes/Assessments (295.19) (56,526.23) GL 1298 03/07/2016 Property Taxes/Assessments (.95) (56,527.18) GL 1299 03/08/2016 Property Taxes/Assessments (15.43) (56,542.61) GL 1300 03/09/2016 Property Taxes/Assessments (17.88) (56,560.49) GL 1301 03/10/2016 Property Taxes/Assessments (18.87) (56,579.36) GL 1302 03/11/2016 Property Taxes/Assessments (6.46) (56,585.82) GL 1303 03/14/2016 Property Taxes/Assessments (21.35) (56,607.17) GL 1304 03/16/2016 Property Taxes/Assessments (45.34) (56,652.51) GL 1305 03/17/2016 Property Taxes/Assessments (35.81) (56,688.32) GL 1307 03/18/2016 Property Taxes/Assessments (39.95) (56,728.27) GL 1306 03/21/2016 Property Taxes/Assessments (35.94) (56,764.21) GL 1308 03/22/2016 Property Taxes/Assessments (2.11) (56,766.32) GL 1309 03/24/2016 Property Taxes/Assessments (7.13) (56,773.45) GL 1310 03/28/2016 Property Taxes/Assessments (63.63) (56,837.08) GL 1311 03/29/2016 Property Taxes/Assessments (27.02) (56,864.10) GL 1312 03/30/2016 Property Taxes/Assessments (11.24) (56,875.34) GL 1313 03/31/2016 Property Taxes/Assessments (91.11) (56,966.45) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (689.27) (56,966.45) ** (58,181.00) Budgeted (1,214.55) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1295 03/02/2016 Property Taxes/Assessments (275.22) (1.44) (276.66) GL 1298 03/07/2016 Property Taxes/Assessments 1.78 (274.88) GL 1306 03/21/2016 Property Taxes/Assessments (1.43) (276.31) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.09) (276.31) ** .00 Budgeted 276.31 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1295 03/02/2016 Property Taxes/Assessments (182.86) (4.63) (187.49) GL 1296 03/03/2016 Property Taxes/Assessments (.18) (187.67) GL 1297 03/04/2016 Property Taxes/Assessments (25.82) (213.49) GL 1298 03/07/2016 Property Taxes/Assessments (.18) (213.67) GL 1299 03/08/2016 Property Taxes/Assessments (1.20) (214.87) GL 1300 03/09/2016 Property Taxes/Assessments (1.45) (216.32) GL 1301 03/10/2016 Property Taxes/Assessments (.50) (216.82) GL 1302 03/11/2016 Property Taxes/Assessments (.09) (216.91) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1303 03/14/2016 Property Taxes/Assessments (182.86) 1.01 (215.90) GL 1304 03/16/2016 Property Taxes/Assessments (3.72) (219.62) GL 1305 03/17/2016 Property Taxes/Assessments (2.51) (222.13) GL 1307 03/18/2016 Property Taxes/Assessments (3.37) (225.50) GL 1306 03/21/2016 Property Taxes/Assessments (1.94) (227.44) GL 1309 03/24/2016 Property Taxes/Assessments (.01) (227.45) GL 1310 03/28/2016 Property Taxes/Assessments (1.97) (229.42) GL 1311 03/29/2016 Property Taxes/Assessments (.85) (230.27) GL 1312 03/30/2016 Property Taxes/Assessments (1.02) (231.29) GL 1313 03/31/2016 Property Taxes/Assessments (6.64) (237.93) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (55.07) (237.93) ** (650.00) Budgeted (412.07) Remaining 37 % Used Account: 135-40025-000-000 PID Surcharges (24,739.19) .00 (24,739.19) _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 (24,739.19) ** (146,125.00) Budgeted (121,385.81) Remaining 17 % Used Account: 135-47000-000-000 Water 1250 03/31/2016 UB Billing March UB20160331-20160331 User: (1,380,534.68) (266,463.37) (1,646,998.05) UB _______________ Account: 135-47000-000-000 Water Totals: (266,463.37) (1,646,998.05) ** (5,080,244.00) Budgeted (3,433,245.95) Remaining 32 % Used Account: 135-47005-000-000 Sewer 1250 03/31/2016 UB Billing March UB20160331-20160331 User: (833,962.71) (175,148.06) (1,009,110.77) UB _______________ Account: 135-47005-000-000 Sewer Totals: (175,148.06) (1,009,110.77) ** (2,413,776.00) Budgeted (1,404,665.23) Remaining 42 % Used Account: 135-47025-000-000 Penalties 1183 03/22/2016 UB 3/22/2016 Penalties UB20160322-20160322 User: (46,683.64) (8,033.88) (54,717.52) UB 1258 03/28/2016 UB 3/28/16 Penalty removal UB20160328-20160328 User: 73.92 (54,643.60) UB 1268 03/31/2016 UB 3/31/16 Penalty adjustments UB20160331-20160331 User: 175.48 (54,468.12) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,784.48) (54,468.12) ** (90,985.00) Budgeted (36,516.88) Remaining 60 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 1130 03/09/2016 UB 3/9/16 Cut off list UB20160309-20160309 User: (6,950.00) (1,025.00) (7,975.00) UB 1256 03/22/2016 UB 3/22/16 NSF Check fee UB20160322-20160322 User: (25.00) (8,000.00) UB 1258 03/28/2016 UB 3/28/16 Penalty removal UB20160328-20160328 User: 50.00 (7,950.00) UB 1259 03/29/2016 UB 3/2916 Penalty removal UB20160329-20160329 User: 25.00 (7,925.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (975.00) (7,925.00) ** (9,000.00) Budgeted (1,075.00) Remaining 88 % Used Account: 135-47035-000-000 Plumbing Inspections 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (1,500.00) (150.00) (1,650.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (1,650.00) ** (2,000.00) Budgeted (350.00) Remaining 83 % Used Account: 135-47045-000-000 Sewer Inspections 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (4,350.00) (450.00) (4,800.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (4,800.00) ** (5,500.00) Budgeted (700.00) Remaining 87 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1250 03/31/2016 UB Billing March UB20160331-20160331 User: (6,587.70) (812.00) (7,399.70) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (812.00) (7,399.70) ** (61,330.00) Budgeted (53,930.30) Remaining 12 % Used Account: 135-48005-000-000 Utility Fees (55,200.00) .00 (55,200.00) _______________ Account: 135-48005-000-000 Utility Fees Totals: .00 (55,200.00) ** (69,000.00) Budgeted (13,800.00) Remaining 80 % Used Account: 135-49010-000-000 Interest Income 1314 03/31/2016 Bank Interest/Month (4,660.01) (188.48) (4,848.49) GL 1314 03/31/2016 Bank Interest/Month (320.70) (5,169.19) GL 1314 03/31/2016 Bank Interest/Month (763.70) (5,932.89) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49010-000-000 Interest Income Totals: (1,272.88) (5,932.89) ** (6,000.00) Budgeted (67.11) Remaining 99 % Used Account: 135-49016-000-000 Cell Tower Revenue 1230 03/08/2016 AT&T Cell Tower Revenue (4,552.65) (910.53) (5,463.18) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (5,463.18) ** (10,926.00) Budgeted (5,462.82) Remaining 50 % Used Account: 135-49018-000-000 Building Rent Income 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 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-49026-000-000 Proceeds from Sale of Assets 1231 03/24/2016 Lone Star Auc/Sale of Assets (15,070.00) (1,865.00) (16,935.00) GL 1341 03/31/2016 Feb 16 Adjust FA CAT Backhoe Feb 16 Adjust FA CAT Backhoe (14,000.00) (30,935.00) GL _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: (15,865.00) (30,935.00) ** .00 Budgeted 30,935.00 Remaining 0 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (8,020.00) Budgeted (8,020.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (32,247.80) (1,715.00) (33,962.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,715.00) (33,962.80) ** (15,778.00) Budgeted 18,184.80 Remaining 215 % Used Account: 135-49141-000-000 Interfund Transfer In (8,034.36) .00 (8,034.36) . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (8,034.36) ** .00 Budgeted 8,034.36 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1266 03/18/2016 UB 3/18/16 Credit adjustments UB20160318-20160318 User: (1,086.00) (1.46) (1,087.46) UB 1250 03/31/2016 UB Billing March UB20160331-20160331 User: (74.01) (1,161.47) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (75.47) (1,161.47) ** (63,249.00) Budgeted (62,087.53) Remaining 2 % Used Account: 135-49901-000-000 Records Management Revenue (20.40) .00 (20.40) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (20.40) ** (20.00) Budgeted .40 Remaining 102 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,958,781.60) ** (8,047,784.00) Budgeted (5,089,002.40) Remaining 37 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 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 1120 03/11/2016 MUD Payroll 3/11/16 Salaries & Wages 84,393.23 8,207.76 92,600.99 PR 1177 03/25/2016 MUD Payroll 3/25/16 Salaries & Wages 8,207.76 100,808.75 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,415.52 100,808.75 ** 265,614.00 Budgeted 164,805.25 Remaining 38 % Used Account: 135-50010-010-000 Overtime 1120 03/11/2016 MUD Payroll 3/11/16 Overtime 5,354.08 184.59 5,538.67 PR 1177 03/25/2016 MUD Payroll 3/25/16 Overtime 522.72 6,061.39 PR _______________ Account: 135-50010-010-000 Overtime Totals: 707.31 6,061.39 ** 19,500.00 Budgeted 13,438.61 Remaining 31 % Used Account: 135-50016-010-000 Longevity 2,945.00 .00 2,945.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,945.00 ** 2,945.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1177 03/25/2016 MUD Payroll 3/25/16 Certification 925.00 200.00 1,125.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 1,125.00 ** 4,200.00 Budgeted 3,075.00 Remaining 27 % Used Account: 135-50020-010-000 Retirement 1120 03/11/2016 MUD Payroll 3/11/16 Retirement 8,277.89 732.67 9,010.56 PR 1177 03/25/2016 MUD Payroll 3/25/16 Retirement 779.63 9,790.19 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,512.30 9,790.19 ** 25,558.00 Budgeted 15,767.81 Remaining 38 % Used Account: 135-50026-010-000 Medical Insurance 1120 03/11/2016 MUD Payroll 3/11/16 Medical Insurance 15,298.61 1,580.60 16,879.21 PR 1177 03/25/2016 MUD Payroll 3/25/16 Medical Insurance 1,580.55 18,459.76 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,161.15 18,459.76 ** 51,398.00 Budgeted 32,938.24 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 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 1120 03/11/2016 MUD Payroll 3/11/16 Dental Insurance 1,139.33 120.39 1,259.72 PR 1177 03/25/2016 MUD Payroll 3/25/16 Dental Insurance 120.38 1,380.10 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.77 1,380.10 ** 3,999.00 Budgeted 2,618.90 Remaining 35 % Used Account: 135-50028-010-000 Vision Insurance 1120 03/11/2016 MUD Payroll 3/11/16 Vision Insurance 257.26 27.01 284.27 PR 1177 03/25/2016 MUD Payroll 3/25/16 Vision Insurance 26.97 311.24 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 311.24 ** 910.00 Budgeted 598.76 Remaining 34 % Used Account: 135-50029-010-000 Life Insurance & Other 987 03/01/2016 March A/P Dental, Vision, STD, Life, Vli 960.75 186.85 1,147.60 METLIFE GROUP BENEFITS 1581 AP 1191 03/22/2016 Mar A/P FSA Admin/February 10.00 1,157.60 BenefitMall 1683 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 196.85 1,157.60 ** 2,803.00 Budgeted 1,645.40 Remaining 41 % Used Account: 135-50030-010-000 Social Security Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Social Security Taxes 5,753.38 515.88 6,269.26 PR 1177 03/25/2016 MUD Payroll 3/25/16 Social Security Taxes 546.67 6,815.93 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,062.55 6,815.93 ** 18,565.00 Budgeted 11,749.07 Remaining 37 % Used Account: 135-50035-010-000 Medicare Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Medicare Taxes 1,345.53 120.66 1,466.19 PR 1177 03/25/2016 MUD Payroll 3/25/16 Medicare Taxes 127.84 1,594.03 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 248.50 1,594.03 ** 4,341.00 Budgeted 2,746.97 Remaining 37 % Used Account: 135-50040-010-000 Unemployment Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Unemployment Taxes 37.10 665.99 703.09 PR 1177 03/25/2016 MUD Payroll 3/25/16 Unemployment Taxes 61.18 764.27 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 727.17 764.27 ** 1,242.00 Budgeted 477.73 Remaining 62 % Used Account: 135-50045-010-000 Workman's Compensation 137 03/01/2016 Prepaid Insurance, W/C Mar 3,832.23 1,229.35 5,061.58 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.35 5,061.58 ** 14,754.00 Budgeted 9,692.42 Remaining 34 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 236.45 .00 236.45 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 236.45 ** 1,300.00 Budgeted 1,063.55 Remaining 18 % Used Account: 135-50070-010-000 Employee Relations 1294 03/28/2016 Mar A/P PRAIRIE HOUSE 75.22 75.22 PRAIRIE HOUSE PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 75.22 75.22 ** 300.00 Budgeted 224.78 Remaining 25 % Used Account: 135-55005-010-000 Engineering 13,395.00 .00 13,395.00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 13,395.00 ** 5,000.00 Budgeted (8,395.00) Remaining 268 % Used Account: 135-55080-010-000 Maintenance & Repairs 1147 03/11/2016 Mar A/P 2" angle stops 51,333.72 550.00 51,883.72 HD SUPPLY WATERWORKS, LTD. 1691 AP 1191 03/22/2016 Mar A/P Meter head screwdrivers 28.75 51,912.47 ATLAS UTILITY SUPPLY CO. 1680 AP 1191 03/22/2016 Mar A/P Meter O rings 18.00 51,930.47 ATLAS UTILITY SUPPLY CO. 1680 AP 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 216.32 52,146.79 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P WW GRAINGER 815.40 52,962.19 WW GRAINGER PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 31.66 52,993.85 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P ROANOKE AUTO SUPPLY LT 4.29 52,998.14 ROANOKE AUTO SUPPLY LT PC 1294 03/28/2016 Mar A/P SC TRACKING SOLUTIONS 54.75 53,052.89 SC TRACKING SOLUTIONS PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 38.99 53,091.88 AMAZON MKTPLACE PMTS PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1235 03/30/2016 March A/P Welding 51,333.72 400.00 53,491.88 MENA'S WELDING SERVICES, LLC 1728 AP 1235 03/30/2016 March A/P Flags, meter spuds 923.40 54,415.28 HD SUPPLY WATERWORKS, LTD. 1723 AP 1326 03/31/2016 Mar A/P Rebuild chlorinators, repair k 1,018.05 55,433.33 SCOOP AP 1326 03/31/2016 Mar A/P New Chlorine Door 975.00 56,408.33 TK CONTRACTORS LLC AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 5,074.61 56,408.33 ** 85,000.00 Budgeted 28,591.67 Remaining 66 % Used Account: 135-55090-010-000 Vehicle Maintenance 1294 03/28/2016 Mar A/P INLAND TRUCK PARTS # 2,813.22 40.00 2,853.22 INLAND TRUCK PARTS # PC 1294 03/28/2016 Mar A/P ROANOKE AUTO SUPPLY LT 14.36 2,867.58 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 54.36 2,867.58 ** 8,000.00 Budgeted 5,132.42 Remaining 36 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1326 03/31/2016 Mar A/P Vac truck repair 484.22 2,408.55 2,892.77 CLS SEWER EQUIPMENT CO., INC AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 2,408.55 2,892.77 ** 3,500.00 Budgeted 607.23 Remaining 83 % Used Account: 135-55135-010-000 Lab Analysis 1147 03/11/2016 Mar A/P Water samples-MUD 1,694.17 315.00 2,009.17 TARRANT CTY PUBLIC HEALTH LAB 1712 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 315.00 2,009.17 ** 5,500.00 Budgeted 3,490.83 Remaining 37 % Used Account: 135-60010-010-000 Communications/Mobiles 1191 03/22/2016 Mar A/P Cells 2/2-3/1 1,837.00 347.05 2,184.05 VERIZON WIRELESS 1716 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 347.05 2,184.05 ** 5,400.00 Budgeted 3,215.95 Remaining 40 % Used Account: 135-60020-010-000 Electricity 1191 03/22/2016 Mar A/P Elec 2/9-3/9/16 49,685.31 92.33 49,777.64 HUDSON ENERGY SERVICES, LLC 1692 AP 1191 03/22/2016 Mar A/P Elec 2/10-3/10/16 8,313.29 58,090.93 HUDSON ENERGY SERVICES, LLC 1692 AP _______________ Account: 135-60020-010-000 Electricity Totals: 8,405.62 58,090.93 ** 166,823.00 Budgeted 108,732.07 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-010-000 Publications/Books/Subscripts .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 11.00 .00 11.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 11.00 ** 500.00 Budgeted 489.00 Remaining 2 % Used Account: 135-60080-010-000 Schools & Training 1,075.00 .00 1,075.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,075.00 ** 5,773.00 Budgeted 4,698.00 Remaining 19 % Used Account: 135-60090-010-000 Safety Program 248.97 .00 248.97 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 248.97 ** 400.00 Budgeted 151.03 Remaining 62 % Used Account: 135-60100-010-000 Travel & per diem 1191 03/22/2016 Mar A/P Travel Exp/Water class 3/29-3/ 14.25 62.40 76.65 Paul Sayre 1708 AP 1249 03/23/2016 Void A/P Check 1708 Travel Exp/Water class 3/29-3/ (62.40) 14.25 Paul Sayre 1708 AP 1326 03/31/2016 Mar A/P TOLL 5.69 19.94 NTTA AP 1326 03/31/2016 Mar A/P Basic Water Class/Sayre 58.24 78.18 Paul Sayre AP _______________ Account: 135-60100-010-000 Travel & per diem Totals: 63.93 78.18 ** 1,400.00 Budgeted 1,321.82 Remaining 6 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60135-010-000 TCEQ Fees & Permits 10,501.40 .00 10,501.40 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 10,501.40 ** 49,275.00 Budgeted 38,773.60 Remaining 21 % Used Account: 135-60150-010-000 Wholesale Water 1326 03/31/2016 Mar A/P Feb Wholesale Water 587,269.08 130,501.45 717,770.53 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 130,501.45 717,770.53 ** 2,948,742.00 Budgeted 2,230,971.47 Remaining 24 % 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 1294 03/28/2016 Mar A/P DENTON SAND & GRAVEL, 1,489.85 84.00 1,573.85 DENTON SAND & GRAVEL, PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 434.00 2,007.85 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 29.94 2,037.79 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 68.01 2,105.80 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 (5.17) 2,100.63 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 70.21 2,170.84 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 28.80 2,199.64 THE HOME DEPOT 6581 PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 709.79 2,199.64 ** 3,500.00 Budgeted 1,300.36 Remaining 63 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 1326 03/31/2016 Mar A/P 1/25/16-2/24/16 Fuel purchases 7,060.34 559.89 7,620.23 US Bank Voyager Fleet Systems AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 559.89 7,620.23 ** 35,947.00 Budgeted 28,326.77 Remaining 21 % Used Account: 135-65010-010-000 Uniforms 2,006.73 .00 2,006.73 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 2,006.73 ** 4,608.00 Budgeted 2,601.27 Remaining 44 % Used Account: 135-65030-010-000 Chemicals 1235 03/30/2016 March A/P Chlorine 5,357.83 529.71 5,887.54 DPC INDUSTRIES, INC 1721 AP 1326 03/31/2016 Mar A/P Chemicals 559.88 6,447.42 HACH COMPANY AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,089.59 6,447.42 ** 12,000.00 Budgeted 5,552.58 Remaining 54 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment 1294 03/28/2016 Mar A/P TX AMERICA SAFETY 187.99 255.50 443.49 TX AMERICA SAFETY PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 255.50 443.49 ** 1,000.00 Budgeted 556.51 Remaining 44 % Used Account: 135-65050-010-000 Meter Expense 1156 03/15/2016 Void AP ck#1570 lost in mail Meters for Wonderland Plaza 87,005.34 (8,710.44) 78,294.90 ATLAS UTILITY SUPPLY CO. 1570 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1156 03/15/2016 Void AP ck#1570 lost in mail Meter heads 87,005.34 (1,700.00) 76,594.90 ATLAS UTILITY SUPPLY CO. 1570 AP 1156 03/15/2016 Void AP ck#1570 lost in mail Meter heads (170.00) 76,424.90 ATLAS UTILITY SUPPLY CO. 1570 AP 1157 03/15/2016 A/P Check Run Meters for Wonderland Plaza 8,710.44 85,135.34 ATLAS UTILITY SUPPLY CO. 1678 AP 1157 03/15/2016 A/P Check Run Meter heads 1,700.00 86,835.34 ATLAS UTILITY SUPPLY CO. 1678 AP 1157 03/15/2016 A/P Check Run Meter head 170.00 87,005.34 ATLAS UTILITY SUPPLY CO. 1678 AP 1191 03/22/2016 Mar A/P Meter testing 300.00 87,305.34 ATLAS UTILITY SUPPLY CO. 1680 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 300.00 87,305.34 ** 115,000.00 Budgeted 27,694.66 Remaining 76 % Used Account: 135-65053-010-000 Meter Change Out Program 1156 03/15/2016 Void AP ck#1570 lost in mail 5/8" meters and profile heads 77,325.00 (32,625.00) 44,700.00 ATLAS UTILITY SUPPLY CO. 1570 AP 1157 03/15/2016 A/P Check Run HRE Heads & CE Endpoints 32,625.00 77,325.00 ATLAS UTILITY SUPPLY CO. 1678 AP _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 77,325.00 ** 50,000.00 Budgeted (27,325.00) Remaining 155 % Used Account: 135-69005-010-000 Capital Outlays 1075 03/04/2016 Mar A/P Dodge truck decals 231,411.64 30.00 231,441.64 M-KAM LTD. 1629 AP 1191 03/22/2016 Mar A/P Ammonia System 2,530.00 233,971.64 CP&Y/WALLACE GROUP, INC. 1685 AP 1191 03/22/2016 Mar A/P Pebble Beach, Pin Oak Ct, Timb 53,108.10 287,079.74 MCCLENDON CONSTRUCTION CO INC 1697 AP 1196 03/22/2016 McClendon Est 6 retainage 5,900.90 292,980.64 GL 1341 03/31/2016 Feb 16 Adjust FA CAT Backhoe Feb 16 Adjust FA CAT Backhoe 14,000.00 306,980.64 GL _______________ Account: 135-69005-010-000 Capital Outlays Totals: 75,569.00 306,980.64 ** 201,000.00 Budgeted (105,980.64) Remaining 153 % Used Account: 135-69008-010-000 Short Term Debt-Principal 130,700.34 .00 130,700.34 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 130,700.34 ** 130,720.00 Budgeted 19.66 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 1228 03/08/2016 FF Bank-Refund 445K payoff 1,222.40 (44.86) 1,177.54 GL _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: (44.86) 1,177.54 ** 1,209.00 Budgeted 31.46 Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 1126 03/08/2016 March A/P Pax Mixer payment 2 of 3 118,774.42 8,183.33 126,957.75 UTILITY SERVICE CO, INC. 1672 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 8,183.33 126,957.75 ** 126,958.00 Budgeted .25 Remaining 100 % Used Account: 135-55135-010-001 Lab Analysis for PID 1147 03/11/2016 Mar A/P Water Samples-PID 527.70 105.00 632.70 TARRANT CTY PUBLIC HEALTH LAB 1712 AP 1235 03/30/2016 March A/P PID TCEQ samples 103.85 736.55 LOWER COLORADO RIVER AUTHORITY 1727 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 208.85 736.55 ** 5,000.00 Budgeted 4,263.45 Remaining 15 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,849,020.09 ** 4,475,834.00 Budgeted 2,626,813.91 Remaining 41 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 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 1120 03/11/2016 MUD Payroll 3/11/16 Salaries & Wages 139,750.18 14,222.79 153,972.97 PR 1177 03/25/2016 MUD Payroll 3/25/16 Salaries & Wages 13,384.49 167,357.46 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 27,607.28 167,357.46 ** 351,671.00 Budgeted 184,313.54 Remaining 48 % Used Account: 135-50010-020-000 Overtime 1120 03/11/2016 MUD Payroll 3/11/16 Overtime 13,341.57 1,745.36 15,086.93 PR 1177 03/25/2016 MUD Payroll 3/25/16 Overtime 1,196.86 16,283.79 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,942.22 16,283.79 ** 19,500.00 Budgeted 3,216.21 Remaining 84 % Used Account: 135-50016-020-000 Longevity 6,125.00 .00 6,125.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,125.00 ** 6,125.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1177 03/25/2016 MUD Payroll 3/25/16 Certification 2,975.00 625.00 3,600.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 3,600.00 ** 7,200.00 Budgeted 3,600.00 Remaining 50 % Used Account: 135-50020-020-000 Retirement 1120 03/11/2016 MUD Payroll 3/11/16 Retirement 14,334.87 1,394.02 15,728.89 PR 1177 03/25/2016 MUD Payroll 3/25/16 Retirement 1,327.51 17,056.40 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,721.53 17,056.40 ** 33,652.00 Budgeted 16,595.60 Remaining 51 % Used Account: 135-50026-020-000 Medical Insurance 1120 03/11/2016 MUD Payroll 3/11/16 Medical Insurance 25,200.75 2,765.99 27,966.74 PR 1177 03/25/2016 MUD Payroll 3/25/16 Medical Insurance 2,765.98 30,732.72 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,531.97 30,732.72 ** 65,989.00 Budgeted 35,256.28 Remaining 47 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 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 1120 03/11/2016 MUD Payroll 3/11/16 Dental Insurance 1,510.44 173.97 1,684.41 PR 1177 03/25/2016 MUD Payroll 3/25/16 Dental Insurance 173.94 1,858.35 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.91 1,858.35 ** 4,184.00 Budgeted 2,325.65 Remaining 44 % Used Account: 135-50028-020-000 Vision Insurance 1120 03/11/2016 MUD Payroll 3/11/16 Vision Insurance 344.75 39.05 383.80 PR 1177 03/25/2016 MUD Payroll 3/25/16 Vision Insurance 39.00 422.80 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 422.80 ** 972.00 Budgeted 549.20 Remaining 43 % Used Account: 135-50029-020-000 Life Insurance & Other 987 03/01/2016 March A/P Dental, Vision, STD, Life, Vli 1,633.09 322.90 1,955.99 METLIFE GROUP BENEFITS 1581 AP 1191 03/22/2016 Mar A/P FSA Admin/February 30.00 1,985.99 BenefitMall 1683 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 352.90 1,985.99 ** 3,655.00 Budgeted 1,669.01 Remaining 54 % Used Account: 135-50030-020-000 Social Security Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Social Security Taxes 9,211.42 901.23 10,112.65 PR 1177 03/25/2016 MUD Payroll 3/25/16 Social Security Taxes 834.32 10,946.97 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,735.55 10,946.97 ** 24,665.00 Budgeted 13,718.03 Remaining 44 % Used Account: 135-50035-020-000 Medicare Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Medicare Taxes 2,154.26 210.76 2,365.02 PR 1177 03/25/2016 MUD Payroll 3/25/16 Medicare Taxes 195.14 2,560.16 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 405.90 2,560.16 ** 5,768.00 Budgeted 3,207.84 Remaining 44 % Used Account: 135-50040-020-000 Unemployment Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Unemployment Taxes 66.12 1,135.85 1,201.97 PR 1177 03/25/2016 MUD Payroll 3/25/16 Unemployment Taxes 1.60 1,203.57 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 1,137.45 1,203.57 ** 1,449.00 Budgeted 245.43 Remaining 83 % Used Account: 135-50045-020-000 Workman's Compensation 137 03/01/2016 Prepaid Insurance, W/C Mar 1,567.66 776.43 2,344.09 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.43 2,344.09 ** 9,317.00 Budgeted 6,972.91 Remaining 25 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 238.45 .00 238.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 238.45 ** 300.00 Budgeted 61.55 Remaining 79 % Used Account: 135-50070-020-000 Employee Relations 1294 03/28/2016 Mar A/P SALAD BOWL 10 180.88 39.00 219.88 SALAD BOWL 10 PC 1294 03/28/2016 Mar A/P CRISTINA'S MEXICAN 63.40 283.28 CRISTINA'S MEXICAN PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 102.40 283.28 ** 650.00 Budgeted 366.72 Remaining 44 % Used Account: 135-55070-020-000 Independent Labor 1326 03/31/2016 Mar A/P Sewer Spill 81,943.24 81,943.24 TAS Environmental Services, LP AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 81,943.24 81,943.24 ** 50,000.00 Budgeted (31,943.24) Remaining 164 % Used Account: 135-55080-020-000 Maintenance & Repairs 1126 03/08/2016 March A/P Repair Sewer line/install fenc 32,312.17 15,092.84 47,405.01 REY-MAR CONSTRUCTION 1668 AP 1191 03/22/2016 Mar A/P repair Lift station #6, pump # 7,213.33 54,618.34 NORTH TEXAS PUMP CO. 1704 AP 1191 03/22/2016 Mar A/P Repair sewer plant lift sta VF 355.00 54,973.34 DHS AUTOMATION, INC 1688 AP 1294 03/28/2016 Mar A/P THE HOME DEPOT 587 41.19 55,014.53 THE HOME DEPOT 587 PC 1294 03/28/2016 Mar A/P STEAGALL OIL CO 218.90 55,233.43 STEAGALL OIL CO PC 1294 03/28/2016 Mar A/P AUTOZONE #4206 91.98 55,325.41 AUTOZONE #4206 PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 20.21 55,345.62 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P ALFA LAVAL 2,539.94 57,885.56 ALFA LAVAL PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1294 03/28/2016 Mar A/P USA BLUE BOOK 32,312.17 479.80 58,365.36 USA BLUE BOOK PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 74.85 58,440.21 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P MICHAELS STORES 9964 5.94 58,446.15 MICHAELS STORES 9964 PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 342.06 58,788.21 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 110.86 58,899.07 THE HOME DEPOT 6581 PC 1294 03/28/2016 Mar A/P THE HOME DEPOT 6581 34.40 58,933.47 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 26,621.30 58,933.47 ** 72,600.00 Budgeted 13,666.53 Remaining 81 % Used Account: 135-55090-020-000 Vehicle Maintenance 1294 03/28/2016 Mar A/P MUSTANG ELITE CAR WASH 1,229.38 10.99 1,240.37 MUSTANG ELITE CAR WASH PC 1294 03/28/2016 Mar A/P MUSTANG ELITE CAR WASH 16.99 1,257.36 MUSTANG ELITE CAR WASH PC 1294 03/28/2016 Mar A/P MUSTANG ELITE CAR 75.99 1,333.35 MUSTANG ELITE CAR PC 1294 03/28/2016 Mar A/P NTB 759 409.45 1,742.80 NTB 759 PC 1326 03/31/2016 Mar A/P Vac truck repair 2,408.54 4,151.34 CLS SEWER EQUIPMENT CO., INC AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 2,921.96 4,151.34 ** 5,000.00 Budgeted 848.66 Remaining 83 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1326 03/31/2016 Mar A/P Tire for backhoe 291.00 291.00 BLAGG TIRE & SERVICE AP _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 291.00 291.00 ** 500.00 Budgeted 209.00 Remaining 58 % Used Account: 135-55125-020-000 Dumpster Services 1191 03/22/2016 Mar A/P Sludge haul off 14,702.16 2,294.60 16,996.76 L.H. CHANEY MATERIALS, INC. 1695 AP 1326 03/31/2016 Mar A/P Sludge haul off 2,480.08 19,476.84 L.H. CHANEY MATERIALS, INC. AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,774.68 19,476.84 ** 55,000.00 Budgeted 35,523.16 Remaining 35 % Used Account: 135-55135-020-000 Lab Analysis 1126 03/08/2016 March A/P Testing 14,270.77 176.00 14,446.77 OXIDOR LABORATORIES LLC 1665 AP 1126 03/08/2016 March A/P Testing 246.00 14,692.77 OXIDOR LABORATORIES LLC 1665 AP 1191 03/22/2016 Mar A/P Testing 246.00 14,938.77 OXIDOR LABORATORIES LLC 1707 AP 1191 03/22/2016 Mar A/P Testing 176.00 15,114.77 OXIDOR LABORATORIES LLC 1707 AP 1191 03/22/2016 Mar A/P Testing 246.00 15,360.77 OXIDOR LABORATORIES LLC 1707 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1191 03/22/2016 Mar A/P Testing 14,270.77 176.00 15,536.77 OXIDOR LABORATORIES LLC 1707 AP 1191 03/22/2016 Mar A/P Testing 90.00 15,626.77 OXIDOR LABORATORIES LLC 1707 AP 1326 03/31/2016 Mar A/P Sludge testing 2,075.75 17,702.52 OXIDOR LABORATORIES LLC AP 1326 03/31/2016 Mar A/P Testing 3,291.88 20,994.40 OXIDOR LABORATORIES LLC AP 1326 03/31/2016 Mar A/P Testing 246.00 21,240.40 OXIDOR LABORATORIES LLC AP 1326 03/31/2016 Mar A/P Testing 176.00 21,416.40 OXIDOR LABORATORIES LLC AP 1326 03/31/2016 Mar A/P Testing 176.00 21,592.40 OXIDOR LABORATORIES LLC AP 1326 03/31/2016 Mar A/P Testing 246.00 21,838.40 OXIDOR LABORATORIES LLC AP 1326 03/31/2016 Mar A/P Testing 176.00 22,014.40 OXIDOR LABORATORIES LLC AP 1326 03/31/2016 Mar A/P Testing 246.00 22,260.40 OXIDOR LABORATORIES LLC AP 1326 03/31/2016 Mar A/P Testing 176.00 22,436.40 OXIDOR LABORATORIES LLC AP 1326 03/31/2016 Mar A/P Testing 246.00 22,682.40 OXIDOR LABORATORIES LLC AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 8,411.63 22,682.40 ** 35,000.00 Budgeted 12,317.60 Remaining 65 % Used Account: 135-60010-020-000 Communications/Mobiles 1191 03/22/2016 Mar A/P Cells 2/2-3/1 2,455.97 412.08 2,868.05 VERIZON WIRELESS 1716 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 412.08 2,868.05 ** 5,400.00 Budgeted 2,531.95 Remaining 53 % Used Account: 135-60020-020-000 Electricity 1147 03/11/2016 Mar A/P Electricity 2/9-3/9/16 46,827.60 56.06 46,883.66 HUDSON ENERGY SERVICES, LLC 1692 AP 1147 03/11/2016 Mar A/P Electricity 2/9-3/9/16 64.23 46,947.89 HUDSON ENERGY SERVICES, LLC 1692 AP 1147 03/11/2016 Mar A/P Electricity 2/10-3/10/16 88.20 47,036.09 HUDSON ENERGY SERVICES, LLC 1692 AP 1191 03/22/2016 Mar A/P Elec 2/10-3/10/16 9,679.38 56,715.47 HUDSON ENERGY SERVICES, LLC 1692 AP 1191 03/22/2016 Mar A/P Elec 2/10-3/10/16 597.24 57,312.71 HUDSON ENERGY SERVICES, LLC 1692 AP 1326 03/31/2016 Mar A/P Electricity 2/10/16-3/10/16 266.69 57,579.40 MP2 ENERGY TEXAS LLC AP 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (398.31) 57,181.09 AR _______________ Account: 135-60020-020-000 Electricity Totals: 10,353.49 57,181.09 ** 161,582.00 Budgeted 104,400.91 Remaining 35 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 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-020-000 Dues & Memberships 1294 03/28/2016 Mar A/P AWWA.ORG 200.00 200.00 AWWA.ORG PC _______________ Account: 135-60070-020-000 Dues & Memberships Totals: 200.00 200.00 ** 300.00 Budgeted 100.00 Remaining 67 % Used Account: 135-60080-020-000 Schools & Training 1294 03/28/2016 Mar A/P TCEQ EPAYMENT 830.00 111.00 941.00 TCEQ EPAYMENT PC 1294 03/28/2016 Mar A/P NCTCOG RTC TRAINING 240.00 1,181.00 NCTCOG RTC TRAINING PC 1294 03/28/2016 Mar A/P TRAINING 400.00 1,581.00 TRAINING PC 1294 03/28/2016 Mar A/P ACT*TWUA - NCT REGION 550.00 2,131.00 ACT*TWUA - NCT REGION PC 1294 03/28/2016 Mar A/P TCEQ IND RENEWAL L 111.00 2,242.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 1,412.00 2,242.00 ** 3,771.00 Budgeted 1,529.00 Remaining 59 % Used Account: 135-60090-020-000 Safety Program 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 192.79 38.08 230.87 AMAZON MKTPLACE PMTS PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 65.80 296.67 AMAZON MKTPLACE PMTS PC _______________ Account: 135-60090-020-000 Safety Program Totals: 103.88 296.67 ** 550.00 Budgeted 253.33 Remaining 54 % Used Account: 135-60100-020-000 Travel & per diem 1113 03/07/2016 Void NTTA A/P ck 1561 Replace lost check # 33642 624.35 (11.48) 612.87 NTTA 1561 AP 1191 03/22/2016 Mar A/P Tolls WW truck 203 6.83 619.70 NTTA 1705 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: (4.65) 619.70 ** 1,600.00 Budgeted 980.30 Remaining 39 % 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-60125-020-000 Advertising 1326 03/31/2016 Mar A/P Notice of Receipt of Applicati 1,520.27 1,520.27 STAR-TELEGRAM OPERATING LTD AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1326 03/31/2016 Mar A/P Notice of Receipt of Applicati 1,504.19 3,024.46 STAR-TELEGRAM OPERATING LTD AP 1334 03/31/2016 Recode Star Tel/WWTP Permit (3,024.46) .00 GL _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 1191 03/22/2016 Mar A/P WWTP Permit renewal applicatio 15,359.28 16,085.00 31,444.28 CP&Y/WALLACE GROUP, INC. 1685 AP 1334 03/31/2016 Recode Star Tel/WWTP Permit 3,024.46 34,468.74 GL _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 19,109.46 34,468.74 ** 37,150.00 Budgeted 2,681.26 Remaining 93 % Used Account: 135-60245-020-000 Miscellaneous Expenses 1294 03/28/2016 Mar A/P BCS*TOWN OF TROPHY CLU 75.00 75.00 BCS*TOWN OF TROPHY CLU PC 1294 03/28/2016 Mar A/P BCS*TOWN OF TROPHY CLU 75.00 150.00 BCS*TOWN OF TROPHY CLU PC _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 150.00 150.00 ** 297.00 Budgeted 147.00 Remaining 51 % 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-60331-020-000 Interfund Transfer Out-Tax I&S 1200 03/23/2016 Transfer PID Surcharge/March 19,951.00 19,951.00 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 19,951.00 19,951.00 ** 119,706.00 Budgeted 99,755.00 Remaining 17 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1197 03/03/2016 Transfer to Rev Bond I&S 185,515.60 43,220.32 228,735.92 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 43,220.32 228,735.92 ** 444,831.00 Budgeted 216,095.08 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60333-020-000 Interfund Transfer Out-Reserve 61,668.00 .00 61,668.00 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 61,668.00 ** 123,336.00 Budgeted 61,668.00 Remaining 50 % Used Account: 135-65005-020-000 Fuel & Lube 1326 03/31/2016 Mar A/P 1/25/16-2/24/16 Fuel purchases 5,388.02 426.15 5,814.17 US Bank Voyager Fleet Systems AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 426.15 5,814.17 ** 32,021.00 Budgeted 26,206.83 Remaining 18 % Used Account: 135-65010-020-000 Uniforms 2,503.53 .00 2,503.53 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 2,503.53 ** 4,241.00 Budgeted 1,737.47 Remaining 59 % Used Account: 135-65030-020-000 Chemicals 1191 03/22/2016 Mar A/P Freestyle Calc Hypochlorite 11,808.25 1,850.00 13,658.25 HARCROS CHEMICALS INC 1690 AP 1326 03/31/2016 Mar A/P Clarifloc 1,080.00 14,738.25 POLYDYNE, INC AP 1326 03/31/2016 Mar A/P Hydrochlorite 2,960.00 17,698.25 HARCROS CHEMICALS INC AP _______________ Account: 135-65030-020-000 Chemicals Totals: 5,890.00 17,698.25 ** 27,000.00 Budgeted 9,301.75 Remaining 66 % Used Account: 135-65035-020-000 Small Tools 220.50 .00 220.50 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 220.50 ** 2,000.00 Budgeted 1,779.50 Remaining 11 % Used Account: 135-65040-020-000 Safety Equipment 576.59 .00 576.59 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 576.59 ** 750.00 Budgeted 173.41 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65045-020-000 Lab Supplies 1294 03/28/2016 Mar A/P UNITEDSCOPE 5,289.15 1,119.98 6,409.13 UNITEDSCOPE PC 1294 03/28/2016 Mar A/P HACH COMPANY 1,599.54 8,008.67 HACH COMPANY PC 1326 03/31/2016 Mar A/P E Coli powder 2,471.74 10,480.41 IDEXX DISTRIBUTION, INC AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 5,191.26 10,480.41 ** 13,000.00 Budgeted 2,519.59 Remaining 81 % Used Account: 135-69005-020-000 Capital Outlays 1192 03/22/2016 Mar A/P 24" Wastewater Aerial Crossing 33,198.75 15,832.00 49,030.75 CP&Y/WALLACE GROUP, INC. 1685 AP 1235 03/30/2016 March A/P 24 trees planted 8,910.00 57,940.75 FORT WORTH ARBORIST CO. 1722 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 24,742.00 57,940.75 ** 150,000.00 Budgeted 92,059.25 Remaining 39 % Used Account: 135-69008-020-000 Short Term Debt-Principal 21,276.80 .00 21,276.80 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 21,276.80 ** 21,280.00 Budgeted 3.20 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 1228 03/08/2016 FF Bank-Refund 445K payoff 199.00 (2.00) 197.00 GL _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: (2.00) 197.00 ** 197.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 975,566.49 ** 1,912,109.00 Budgeted 936,542.51 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2016 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 1120 03/11/2016 MUD Payroll 3/11/16 Salaries & Wages 3,100.00 200.00 3,300.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 200.00 3,300.00 ** 12,500.00 Budgeted 9,200.00 Remaining 26 % Used Account: 135-50030-026-000 Social Security Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Social Security Taxes 192.20 12.40 204.60 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 12.40 204.60 ** 775.00 Budgeted 570.40 Remaining 26 % Used Account: 135-50035-026-000 Medicare Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Medicare Taxes 44.95 2.90 47.85 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 2.90 47.85 ** 181.00 Budgeted 133.15 Remaining 26 % Used Account: 135-50040-026-000 Unemployment Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Unemployment Taxes 3.10 9.20 12.30 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 9.20 12.30 ** 230.00 Budgeted 217.70 Remaining 5 % Used Account: 135-50045-026-000 Workman's Compensation 137 03/01/2016 Prepaid Insurance, W/C Mar 28.41 3.08 31.49 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.08 31.49 ** 37.00 Budgeted 5.51 Remaining 85 % 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 No.1 Page 37 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 10.98 .00 10.98 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 10.98 ** 500.00 Budgeted 489.02 Remaining 2 % Used Account: 135-60075-026-000 Meetings 1294 03/28/2016 Mar A/P MINYARD FOOD STORE # 6.00 15.67 21.67 MINYARD FOOD STORE # PC _______________ Account: 135-60075-026-000 Meetings Totals: 15.67 21.67 ** 1,200.00 Budgeted 1,178.33 Remaining 2 % Used Account: 135-60080-026-000 Schools & Training 1075 03/04/2016 Mar A/P AWBD Conf/K Carr 550.00 355.00 905.00 AWBD 1600 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 355.00 905.00 ** 4,000.00 Budgeted 3,095.00 Remaining 23 % Used Account: 135-60100-026-000 Travel & per diem 1,602.43 .00 1,602.43 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 1,602.43 ** 5,000.00 Budgeted 3,397.57 Remaining 32 % Used Account: 135-60245-026-000 Miscellaneous Expenses 50.48 .00 50.48 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 50.48 ** 2,000.00 Budgeted 1,949.52 Remaining 3 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 6,186.80 ** 26,573.00 Budgeted 20,386.20 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 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 1120 03/11/2016 MUD Payroll 3/11/16 Salaries & Wages 190,042.20 18,626.68 208,668.88 PR 1177 03/25/2016 MUD Payroll 3/25/16 Salaries & Wages 18,615.09 227,283.97 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 37,241.77 227,283.97 ** 488,508.00 Budgeted 261,224.03 Remaining 47 % Used Account: 135-50010-030-000 Overtime 1120 03/11/2016 MUD Payroll 3/11/16 Overtime 127.60 7.87 135.47 PR 1177 03/25/2016 MUD Payroll 3/25/16 Overtime 16.29 151.76 PR _______________ Account: 135-50010-030-000 Overtime Totals: 24.16 151.76 ** 1,000.00 Budgeted 848.24 Remaining 15 % Used Account: 135-50016-030-000 Longevity 3,822.50 .00 3,822.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,822.50 ** 3,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1120 03/11/2016 MUD Payroll 3/11/16 Retirement 17,150.47 1,626.81 18,777.28 PR 1177 03/25/2016 MUD Payroll 3/25/16 Retirement 1,626.51 20,403.79 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,253.32 20,403.79 ** 43,202.00 Budgeted 22,798.21 Remaining 47 % Used Account: 135-50026-030-000 Medical Insurance 1120 03/11/2016 MUD Payroll 3/11/16 Medical Insurance 25,285.07 2,655.37 27,940.44 PR 1177 03/25/2016 MUD Payroll 3/25/16 Medical Insurance 2,655.35 30,595.79 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,310.72 30,595.79 ** 68,196.00 Budgeted 37,600.21 Remaining 45 % Used Account: 135-50027-030-000 Dental Insurance 1120 03/11/2016 MUD Payroll 3/11/16 Dental Insurance 1,705.41 189.41 1,894.82 PR 1177 03/25/2016 MUD Payroll 3/25/16 Dental Insurance 189.38 2,084.20 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 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: 378.79 2,084.20 ** 4,807.00 Budgeted 2,722.80 Remaining 43 % Used Account: 135-50028-030-000 Vision Insurance 1120 03/11/2016 MUD Payroll 3/11/16 Vision Insurance 393.91 43.60 437.51 PR 1177 03/25/2016 MUD Payroll 3/25/16 Vision Insurance 43.54 481.05 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 87.14 481.05 ** 1,114.00 Budgeted 632.95 Remaining 43 % Used Account: 135-50029-030-000 Life Insurance & Other 987 03/01/2016 March A/P Dental, Vision, STD, Life, Vli 1,932.92 363.39 2,296.31 METLIFE GROUP BENEFITS 1581 AP 1191 03/22/2016 Mar A/P FSA Admin/February 30.00 2,326.31 BenefitMall 1683 AP 1242 03/31/2016 Rounding adjustment (.04) 2,326.27 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 393.35 2,326.27 ** 4,431.00 Budgeted 2,104.73 Remaining 52 % Used Account: 135-50030-030-000 Social Security Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Social Security Taxes 11,249.96 1,068.40 12,318.36 PR 1177 03/25/2016 MUD Payroll 3/25/16 Social Security Taxes 1,055.98 13,374.34 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,124.38 13,374.34 ** 30,823.00 Budgeted 17,448.66 Remaining 43 % Used Account: 135-50035-030-000 Medicare Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Medicare Taxes 2,631.03 249.88 2,880.91 PR 1177 03/25/2016 MUD Payroll 3/25/16 Medicare Taxes 246.95 3,127.86 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 496.83 3,127.86 ** 7,599.00 Budgeted 4,471.14 Remaining 41 % Used Account: 135-50040-030-000 Unemployment Taxes 1120 03/11/2016 MUD Payroll 3/11/16 Unemployment Taxes 53.86 1,054.01 1,107.87 PR 1177 03/25/2016 MUD Payroll 3/25/16 Unemployment Taxes 42.78 1,150.65 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 1,096.79 1,150.65 ** 1,449.00 Budgeted 298.35 Remaining 79 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 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 137 03/01/2016 Prepaid Insurance, W/C Mar 1,031.45 147.89 1,179.34 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 1,179.34 ** 1,554.00 Budgeted 374.66 Remaining 76 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 1294 03/28/2016 Mar A/P ESCAPE DONUT 2,860.56 19.66 2,880.22 ESCAPE DONUT PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 19.66 2,880.22 ** 5,000.00 Budgeted 2,119.78 Remaining 58 % Used Account: 135-55030-030-000 Software & Support 1147 03/11/2016 Mar A/P Internet 12,277.89 1,101.17 13,379.06 WHOLESALE CARRIER SERVICES INC 1717 AP 1192 03/22/2016 Mar A/P Software renewals 13,365.00 26,744.06 STW INC 1710 AP 1294 03/28/2016 Mar A/P ATT*BILL PAYMENT 166.46 26,910.52 ATT*BILL PAYMENT PC 1294 03/28/2016 Mar A/P ATT*BILL PAYMENT 150.14 27,060.66 ATT*BILL PAYMENT PC 1235 03/30/2016 March A/P Payroll Time Update 2,614.00 29,674.66 Data Management Inc. 1720 AP 1326 03/31/2016 Mar A/P Annual Maint-Remit Plus 1,802.50 31,477.16 JACK HENRY & ASSOC, INC AP _______________ Account: 135-55030-030-000 Software & Support Totals: 19,199.27 31,477.16 ** 78,483.00 Budgeted 47,005.84 Remaining 40 % Used Account: 135-55070-030-000 Independent Labor 1191 03/22/2016 Mar A/P Record 1/20 MUD Meeting 12,923.23 48.75 12,971.98 MIGUEL CRUZ 1701 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 48.75 12,971.98 ** 12,000.00 Budgeted (971.98) Remaining 108 % Used Account: 135-55080-030-000 Maintenance & Repairs 1294 03/28/2016 Mar A/P ROANOKE AUTO SUPPLY LT 9,689.66 148.69 9,838.35 ROANOKE AUTO SUPPLY LT PC 1340 03/30/2016 Mar A/P Mowing/March 1,290.00 11,128.35 WATTS ELLISON LLC AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 1,438.69 11,128.35 ** 29,500.00 Budgeted 18,371.65 Remaining 38 % Used Account: 135-55100-030-000 Building Maint & Supplies 1191 03/22/2016 Mar A/P Check receptacle in Board room 4,116.83 27.50 4,144.33 DENNIS SERVICES LLC 1687 AP 1326 03/31/2016 Mar A/P Rug Service-MUD & PS Bldgs 130.89 4,275.22 G & K SERVICES AP 1326 03/31/2016 Mar A/P Rug Service-MUD & PS Bldgs 130.89 4,406.11 G & K SERVICES AP 1326 03/31/2016 Mar A/P Rug Service-MUD & PS Bldgs 130.89 4,537.00 G & K SERVICES AP 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (210.08) 4,326.92 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 210.09 4,326.92 ** 7,000.00 Budgeted 2,673.08 Remaining 62 % Used Account: 135-55120-030-000 Cleaning Services 1191 03/22/2016 Mar A/P Feb Janitorial service 2,080.00 843.75 2,923.75 MEMBER'S BUILDING MAINTENANCE 1698 AP 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (259.00) 2,664.75 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 584.75 2,664.75 ** 10,125.00 Budgeted 7,460.25 Remaining 26 % Used Account: 135-55160-030-000 Professional Outside Services 53,072.50 .00 53,072.50 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 53,072.50 ** 61,075.00 Budgeted 8,002.50 Remaining 87 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 1147 03/11/2016 Mar A/P February printing of Water bil 2,540.87 581.60 3,122.47 DATAPROSE LLC 1686 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 581.60 3,122.47 ** 8,200.00 Budgeted 5,077.53 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-000 Telephone 1075 03/04/2016 Mar A/P 3/7-4/3 Answering service 5,379.11 194.30 5,573.41 KEYSTONE PARK SECRETARIAL 1620 AP 1294 03/28/2016 Mar A/P RINGCENTRAL, INC 9.99 5,583.40 RINGCENTRAL, INC PC 1294 03/28/2016 Mar A/P ATT*BUS PHONE PMT 431.04 6,014.44 ATT*BUS PHONE PMT PC 1294 03/28/2016 Mar A/P ATT*BUS PHONE PMT 820.63 6,835.07 ATT*BUS PHONE PMT PC 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (439.04) 6,396.03 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,016.92 6,396.03 ** 16,349.00 Budgeted 9,952.97 Remaining 39 % Used Account: 135-60010-030-000 Communications/Mobiles 1191 03/22/2016 Mar A/P Cells 2/2-3/1 1,689.95 37.99 1,727.94 VERIZON WIRELESS 1716 AP 1177 03/25/2016 MUD Payroll 3/25/16 Communications/Mobiles 300.00 2,027.94 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 2,027.94 ** 4,150.00 Budgeted 2,122.06 Remaining 49 % Used Account: 135-60020-030-000 Electricity/Gas 3,711.28 .00 3,711.28 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 3,711.28 ** 10,768.00 Budgeted 7,056.72 Remaining 34 % Used Account: 135-60025-030-000 Water 1326 03/31/2016 Mar A/P March Water MUD/PS Bldgs 388.89 139.55 528.44 TROPHY CLUB MUD (WATER BILLS) AP 1331 03/31/2016 Bill Town/March Invoices AR 20160331-20160331 User: (69.77) 458.67 AR _______________ Account: 135-60025-030-000 Water Totals: 69.78 458.67 ** 1,500.00 Budgeted 1,041.33 Remaining 31 % Used Account: 135-60035-030-000 Postage 1063 03/03/2016 March A/P Fix a leak postcards 9,305.13 1,056.64 10,361.77 U.S. POSTAL SERVICE 1596 AP 1147 03/11/2016 Mar A/P February printing of Water bil 1,741.84 12,103.61 DATAPROSE LLC 1686 AP 1294 03/28/2016 Mar A/P USPS 48764506630613152 16.33 12,119.94 USPS 48764506630613152 PC 1294 03/28/2016 Mar A/P USPS 48323795520601514 9.90 12,129.84 USPS 48323795520601514 PC 1326 03/31/2016 Mar A/P Overnight letter 6.95 12,136.79 FEDERAL EXPRESS CORP AP 1326 03/31/2016 Mar A/P Shipment to Scoop 55.21 12,192.00 FEDERAL EXPRESS CORP AP _______________ Account: 135-60035-030-000 Postage Totals: 2,886.87 12,192.00 ** 28,932.00 Budgeted 16,740.00 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees 1315 03/02/2016 Credit card fees 26,974.75 52.91 27,027.66 GL 1315 03/02/2016 Credit card fees 3,380.28 30,407.94 GL 1121 03/11/2016 Child support fee 3/11/16 1.50 30,409.44 GL 1178 03/25/2016 Child support fee 1.50 30,410.94 GL 1326 03/31/2016 Mar A/P Dec-Feb fees 650.00 31,060.94 Fiserv Solutions, LLC AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,086.19 31,060.94 ** 44,000.00 Budgeted 12,939.06 Remaining 71 % Used Account: 135-60050-030-000 Bad Debt Expense 1271 03/31/2016 UB 3/31/16 Write offs UB20160331-20160331 User: 1,075.05 940.30 2,015.35 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 940.30 2,015.35 ** 3,500.00 Budgeted 1,484.65 Remaining 58 % Used Account: 135-60055-030-000 Insurance 137 03/01/2016 Prepaid Insurance, W/C Mar 14,031.00 2,756.00 16,787.00 GL 1326 03/31/2016 Mar A/P Notary/McKnight 50.00 16,837.00 VICTOR O SCHINNERER & CO, INC AP _______________ Account: 135-60055-030-000 Insurance Totals: 2,806.00 16,837.00 ** 52,797.00 Budgeted 35,960.00 Remaining 32 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 5,006.25 .00 5,006.25 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 5,006.25 ** 6,000.00 Budgeted 993.75 Remaining 83 % Used Account: 135-60075-030-000 Meetings 29.00 .00 29.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60075-030-000 Meetings Totals: .00 29.00 ** 400.00 Budgeted 371.00 Remaining 7 % Used Account: 135-60079-030-000 Public Education 1191 03/22/2016 Mar A/P Children lab coats for Waterfe 1,484.19 296.00 1,780.19 MR DISPOSABLE INC 1702 AP 1232 03/24/2016 DataProse/Waterfest donation (150.00) 1,630.19 GL 1294 03/28/2016 Mar A/P BCS*TOWN OF TROPHY CLU 75.00 1,705.19 BCS*TOWN OF TROPHY CLU PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 20.98 1,726.17 AMAZON MKTPLACE PMTS PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 115.39 1,841.56 AMAZON MKTPLACE PMTS PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 43.13 1,884.69 AMAZON MKTPLACE PMTS PC 1294 03/28/2016 Mar A/P SIGNSONTHECHEAP.COM 144.72 2,029.41 SIGNSONTHECHEAP.COM PC 1294 03/28/2016 Mar A/P IN-N-OUT BURGER #283 60.00 2,089.41 IN-N-OUT BURGER #283 PC 1294 03/28/2016 Mar A/P PANDA EMBROIDERY 126.00 2,215.41 PANDA EMBROIDERY PC 1294 03/28/2016 Mar A/P AMAZON.COM 140.89 2,356.30 AMAZON.COM PC 1294 03/28/2016 Mar A/P AGRILIFE RESEARCH DALL 700.00 3,056.30 AGRILIFE RESEARCH DALL PC 1294 03/28/2016 Mar A/P KELLER TROPHY AND AWAR 66.57 3,122.87 KELLER TROPHY AND AWAR PC 1294 03/28/2016 Mar A/P CANVA.COM 2.00 3,124.87 CANVA.COM PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 152.14 3,277.01 AMAZON MKTPLACE PMTS PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 108.97 3,385.98 AMAZON MKTPLACE PMTS PC 1294 03/28/2016 Mar A/P MY BRANDS 43.73 3,429.71 MY BRANDS PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 10.98 3,440.69 AMAZON MKTPLACE PMTS PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 205.54 3,646.23 AMAZON MKTPLACE PMTS PC _______________ Account: 135-60079-030-000 Public Education Totals: 2,162.04 3,646.23 ** 5,000.00 Budgeted 1,353.77 Remaining 73 % Used Account: 135-60080-030-000 Schools & Training 1294 03/28/2016 Mar A/P TEXAS WATER 2,421.50 590.00 3,011.50 TEXAS WATER PC 1294 03/28/2016 Mar A/P TSBPA IND LIC RENE 66.00 3,077.50 TSBPA IND LIC RENE PC 1294 03/28/2016 Mar A/P ACFE 195.00 3,272.50 ACFE PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 851.00 3,272.50 ** 9,935.00 Budgeted 6,662.50 Remaining 33 % Used Account: 135-60100-030-000 Travel & per diem 1120 03/11/2016 MUD Payroll 3/11/16 Travel & per diem 2,232.24 47.74 2,279.98 PR 1177 03/25/2016 MUD Payroll 3/25/16 Travel & per diem 66.31 2,346.29 PR 1294 03/28/2016 Mar A/P SUBWAY 03217791 63.33 2,409.62 SUBWAY 03217791 PC 1294 03/28/2016 Mar A/P FOUR STAR CAFE DOWNTOW 18.29 2,427.91 FOUR STAR CAFE DOWNTOW PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1294 03/28/2016 Mar A/P CFW COMMERCE ST GARAGE 2,232.24 30.00 2,457.91 CFW COMMERCE ST GARAGE PC 1294 03/28/2016 Mar A/P STARBUCKS OMNI FT WORT 10.09 2,468.00 STARBUCKS OMNI FT WORT PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 235.76 2,468.00 ** 5,400.00 Budgeted 2,932.00 Remaining 46 % 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-60115-030-000 Elections 1294 03/28/2016 Mar A/P RANDALLS STORE00017897 6.00 6.00 RANDALLS STORE00017897 PC _______________ Account: 135-60115-030-000 Elections Totals: 6.00 6.00 ** 7,500.00 Budgeted 7,494.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 61.74 .00 61.74 _______________ Account: 135-60125-030-000 Advertising Totals: .00 61.74 ** 7,500.00 Budgeted 7,438.26 Remaining 1 % 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 4,073.98 .00 4,073.98 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 4,073.98 ** 17,501.00 Budgeted 13,427.02 Remaining 23 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 656.38 .00 656.38 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 656.38 ** 2,500.00 Budgeted 1,843.62 Remaining 26 % Used Account: 135-65010-030-000 Uniforms 23.00 .00 23.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 23.00 ** 1,855.00 Budgeted 1,832.00 Remaining 1 % Used Account: 135-65055-030-000 Hardware 5,871.85 .00 5,871.85 _______________ Account: 135-65055-030-000 Hardware Totals: .00 5,871.85 ** 29,594.00 Budgeted 23,722.15 Remaining 20 % Used Account: 135-65085-030-000 Office Supplies 1294 03/28/2016 Mar A/P OFFICE DEPOT #406 2,973.75 10.49 2,984.24 OFFICE DEPOT #406 PC 1294 03/28/2016 Mar A/P SIGMA SIGNS & PRINTING 360.00 3,344.24 SIGMA SIGNS & PRINTING PC 1235 03/30/2016 March A/P Office Supplies 79.96 3,424.20 OFFICE DEPOT, INC 1729 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 450.45 3,424.20 ** 9,000.00 Budgeted 5,575.80 Remaining 38 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1191 03/22/2016 Mar A/P Surge Protector, Maint kit Ren 221.30 185.14 406.44 M3 Networks 1696 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 185.14 406.44 ** 4,003.00 Budgeted 3,596.56 Remaining 10 % Used Account: 135-65095-030-000 Maintenance Supplies 1294 03/28/2016 Mar A/P SAMS CLUB #4795 1,871.99 176.13 2,048.12 SAMS CLUB #4795 PC 1294 03/28/2016 Mar A/P AMAZON MKTPLACE PMTS 43.92 2,092.04 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 220.05 2,092.04 ** 5,000.00 Budgeted 2,907.96 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65105-030-000 Printing 1294 03/28/2016 Mar A/P FEDEXOFFICE 00003319 59.88 59.88 FEDEXOFFICE 00003319 PC _______________ Account: 135-65105-030-000 Printing Totals: 59.88 59.88 ** 4,800.00 Budgeted 4,740.12 Remaining 1 % Used Account: 135-69005-030-000 Capital Outlays 6,158.00 .00 6,158.00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 6,158.00 ** 56,000.00 Budgeted 49,842.00 Remaining 11 % Used Account: 135-69170-030-000 Copier Lease Installments 1147 03/11/2016 Mar A/P Copier lease 1,442.35 165.00 1,607.35 EVERBANK COMMERCIAL FINANCE 1689 AP 1235 03/30/2016 March A/P Copies from Kyocera Adm 2/23-3 65.50 1,672.85 KYOCERA DOCUMENT SOLUTIONS 1725 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 230.50 1,672.85 ** 4,600.00 Budgeted 2,927.15 Remaining 36 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 541,253.42 ** 1,210,323.00 Budgeted 669,069.58 Remaining 45 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2016 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 120,596.39 .00 120,596.39 _______________ Account: 135-55045-039-000 Legal Totals: .00 120,596.39 ** 386,130.00 Budgeted 265,533.61 Remaining 31 % Used Account: 135-55055-039-000 Auditing 24,039.38 .00 24,039.38 _______________ Account: 135-55055-039-000 Auditing Totals: .00 24,039.38 ** 22,750.00 Budgeted (1,289.38) Remaining 106 % Used Account: 135-55060-039-000 Appraisal 1126 03/08/2016 March A/P DCAD budget second qtr 4,229.90 1,994.51 6,224.41 DENTON CENTRAL APPRAISAL DISTR 1655 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,994.51 6,224.41 ** 10,265.00 Budgeted 4,040.59 Remaining 61 % Used Account: 135-55065-039-000 Tax Admin Fees 2,468.82 .00 2,468.82 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,468.82 ** 3,800.00 Budgeted 1,331.18 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 153,329.00 ** 422,945.00 Budgeted 269,616.00 Remaining 36 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 566,574.20 .00 Budgeted (566,574.20) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/2016 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 (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (156,420.00) ** .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (156,420.00) .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 3/2016 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 (2.77) .00 (2.77) _______________ Account: 507-49010-000-000 Interest Income Totals: .00 (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 .00 8,034.36 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 8,031.59 .00 Budgeted (8,031.59) Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET MARCH 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,383,273 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,383,273 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 4,710 TOTAL FUND BALANCE 4,383,273 TOTAL LIABILITIES AND FUND BALANCE 4,383,273 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 15:34 04/08/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,218.09- 4,710.51- 4,710.51 Subtotal: 1,218.09- 4,710.51- 4,710.51 Program number: 1,218.09- 4,710.51- 4,710.51 Department number: Revenues 1,218.09- 4,710.51- 4,710.51 Revenues Subtotal ----------- 1,218.09- 4,710.51- 4,710.51 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,218.09- 4,710.51- 4,710.51 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2016 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 1314 03/31/2016 Bank Interest/Month (3,492.42) (1,218.09) (4,710.51) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,218.09) (4,710.51) ** .00 Budgeted 4,710.51 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4,710.51) ** .00 Budgeted 4,710.51 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (4,710.51) .00 Budgeted 4,710.51 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET MARCH 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 6,938,041 ACCOUNTS RECEIVABLE - TOTAL ASSETS 6,938,041 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 204,321 TOTAL LIABILITIES 204,321 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (1,600,384) TOTAL FUND BALANCE 6,733,720 TOTAL LIABILITIES AND FUND BALANCE 6,938,041 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 15:34 04/08/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 2,052.99- 8,593.77- 8,593.77 Subtotal: 2,052.99- 8,593.77- 8,593.77 Program number: 2,052.99- 8,593.77- 8,593.77 Department number: Revenues 2,052.99- 8,593.77- 8,593.77 Revenues Subtotal ----------- 2,052.99- 8,593.77- 8,593.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 15:34 04/08/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 674,756.39 1,608,978.15 1,608,978.15- Subtotal: 674,756.39 1,608,978.15 1,608,978.15- Program number: 674,756.39 1,608,978.15 1,608,978.15- Department number: Wastewater 674,756.39 1,608,978.15 1,608,978.15- Expenditures Subtotal ----------- 674,756.39 1,608,978.15 1,608,978.15- Fund number: 518 2015 Revenue Bond Const Fund 672,703.40 1,600,384.38 1,600,384.38- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 3/2016 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 1314 03/31/2016 Bank Interest/Month (6,540.78) (2,052.99) (8,593.77) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (2,052.99) (8,593.77) ** .00 Budgeted 8,593.77 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (8,593.77) ** .00 Budgeted 8,593.77 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-69005-020-000 Capital Outlays 1319 03/18/2016 App 5, Webber Cadauga retainag 934,221.76 62,352.27 996,574.03 GL 1191 03/22/2016 Mar A/P WWTP Improvements 54,233.74 1,050,807.77 CP&Y/WALLACE GROUP, INC. 1685 AP 1206 03/24/2016 Mar A/P WWTP App #5 558,170.38 1,608,978.15 WEBBER-CADAGUA PARTNERS 1718 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 674,756.39 1,608,978.15 ** .00 Budgeted (1,608,978.15) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,608,978.15 ** .00 Budgeted (1,608,978.15) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 1,600,384.38 .00 Budgeted (1,600,384.38) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MARCH 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 133,771 ACCOUNTS RECEIVABLE - TOTAL ASSETS 133,771 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 61,809 TOTAL FUND BALANCE 133,771 TOTAL LIABILITIES AND FUND BALANCE 133,771 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 15:34 04/08/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 37.17- 140.66- 140.66 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 61,668.00- 50.000 61,668.00- Subtotal: 123,336.00- 123,336.00- 37.17- 61,808.66- 50.114 61,527.34- Program number: 123,336.00- 123,336.00- 37.17- 61,808.66- 50.114 61,527.34- Department number: 123,336.00- 123,336.00- 37.17- 61,808.66- 50.114 61,527.34- Revenues Subtotal ----------- 123,336.00- 123,336.00- 37.17- 61,808.66- 50.114 61,527.34- Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 37.17- 61,808.66- 50.114 61,527.34- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/2016 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 1314 03/31/2016 Bank Interest/Month (103.49) (37.17) (140.66) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (37.17) (140.66) ** .00 Budgeted 140.66 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund (61,668.00) .00 (61,668.00) _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (61,668.00) ** (123,336.00) Budgeted (61,668.00) Remaining 50 % Used Department Totals: ------------------------------------------------------------------------------------------------ (61,808.66) ** (123,336.00) Budgeted (61,527.34) Remaining 50 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (61,808.66) (123,336.00) Budgeted (61,527.34) Remaining 50 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET MARCH 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 750,524 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 30,276 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 785,647 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 30,276 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 30,276 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 731,198 TOTAL FUND BALANCE 755,371 TOTAL LIABILITIES AND FUND BALANCE 785,647 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 15:34 04/08/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 667,898.00- 667,898.00- 7,915.08- 654,149.28- 97.941 13,748.72- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 3.02- 933.53- 40.588 1,366.47- 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 636.04- 1,217.47- 67.637 582.53- Subtotal: 671,998.00- 671,998.00- 8,554.14- 656,300.28- 97.664 15,697.72- 533-49010-000-000 Interest Income 140.00- 140.00- 203.44- 509.02- 363.586 369.02 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 19,951.00- 19,951.00- 16.667 99,755.00- Subtotal: 334,225.00- 334,225.00- 20,154.44- 234,839.02- 70.264 99,385.98- Program number: 1,006,223.00- 1,006,223.00- 28,708.58- 891,139.30- 88.563 115,083.70- Department number: Revenues 1,006,223.00- 1,006,223.00- 28,708.58- 891,139.30- 88.563 115,083.70- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 28,708.58- 891,139.30- 88.563 115,083.70- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 15:34 04/08/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 1,250.00- 1,250.00 49.020 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 158,691.25 50.063 158,291.75 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 685,000.00 685,000.00 Subtotal: 1,004,533.00 1,004,533.00 1,250.00- 159,941.25 15.922 844,591.75 Program number: 1,004,533.00 1,004,533.00 1,250.00- 159,941.25 15.922 844,591.75 Department number: Administration 1,004,533.00 1,004,533.00 1,250.00- 159,941.25 15.922 844,591.75 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 1,250.00- 159,941.25 15.922 844,591.75 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 29,958.58- 731,198.05- ############### 729,508.05 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2016 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 1295 03/02/2016 Property Taxes/Assessments (646,234.20) (684.20) (646,918.40) GL 1296 03/03/2016 Property Taxes/Assessments 1,214.02 (645,704.38) GL 1297 03/04/2016 Property Taxes/Assessments (3,389.70) (649,094.08) GL 1298 03/07/2016 Property Taxes/Assessments (10.96) (649,105.04) GL 1299 03/08/2016 Property Taxes/Assessments (177.19) (649,282.23) GL 1300 03/09/2016 Property Taxes/Assessments (205.28) (649,487.51) GL 1301 03/10/2016 Property Taxes/Assessments (216.66) (649,704.17) GL 1302 03/11/2016 Property Taxes/Assessments (74.12) (649,778.29) GL 1303 03/14/2016 Property Taxes/Assessments (245.18) (650,023.47) GL 1304 03/16/2016 Property Taxes/Assessments (520.71) (650,544.18) GL 1305 03/17/2016 Property Taxes/Assessments (411.16) (650,955.34) GL 1307 03/18/2016 Property Taxes/Assessments (458.75) (651,414.09) GL 1306 03/21/2016 Property Taxes/Assessments (412.76) (651,826.85) GL 1308 03/22/2016 Property Taxes/Assessments (24.23) (651,851.08) GL 1309 03/24/2016 Property Taxes/Assessments (81.93) (651,933.01) GL 1310 03/28/2016 Property Taxes/Assessments (730.68) (652,663.69) GL 1311 03/29/2016 Property Taxes/Assessments (310.29) (652,973.98) GL 1312 03/30/2016 Property Taxes/Assessments (129.11) (653,103.09) GL 1313 03/31/2016 Property Taxes/Assessments (1,046.19) (654,149.28) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (7,915.08) (654,149.28) ** (667,898.00) Budgeted (13,748.72) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1295 03/02/2016 Property Taxes/Assessments (930.51) (4.00) (934.51) GL 1298 03/07/2016 Property Taxes/Assessments 4.95 (929.56) GL 1306 03/21/2016 Property Taxes/Assessments (3.97) (933.53) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (3.02) (933.53) ** (2,300.00) Budgeted (1,366.47) Remaining 41 % Used Account: 533-40015-000-000 Property Taxes/P & I 1295 03/02/2016 Property Taxes/Assessments (581.43) (50.29) (631.72) GL 1296 03/03/2016 Property Taxes/Assessments (.61) (632.33) GL 1297 03/04/2016 Property Taxes/Assessments (296.49) (928.82) GL 1298 03/07/2016 Property Taxes/Assessments (2.04) (930.86) GL 1299 03/08/2016 Property Taxes/Assessments (13.75) (944.61) GL 1300 03/09/2016 Property Taxes/Assessments (16.71) (961.32) GL 1301 03/10/2016 Property Taxes/Assessments (5.74) (967.06) GL 1302 03/11/2016 Property Taxes/Assessments (.30) (967.36) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1304 03/16/2016 Property Taxes/Assessments (581.43) (42.65) (1,010.01) GL 1305 03/17/2016 Property Taxes/Assessments (28.94) (1,038.95) GL 1307 03/18/2016 Property Taxes/Assessments (38.73) (1,077.68) GL 1306 03/21/2016 Property Taxes/Assessments (19.44) (1,097.12) GL 1309 03/24/2016 Property Taxes/Assessments (.07) (1,097.19) GL 1310 03/28/2016 Property Taxes/Assessments (22.60) (1,119.79) GL 1311 03/29/2016 Property Taxes/Assessments (9.76) (1,129.55) GL 1312 03/30/2016 Property Taxes/Assessments (11.62) (1,141.17) GL 1313 03/31/2016 Property Taxes/Assessments (76.30) (1,217.47) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (636.04) (1,217.47) ** (1,800.00) Budgeted (582.53) Remaining 68 % Used Account: 533-49010-000-000 Interest Income 1314 03/31/2016 Bank Interest/Month (305.58) (203.44) (509.02) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (203.44) (509.02) ** (140.00) Budgeted 369.02 Remaining 364 % Used Account: 533-49015-000-000 Lease/Rental Income (214,379.00) .00 (214,379.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,379.00) ** (214,379.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 1200 03/23/2016 Transfer PID Surcharge/March (19,951.00) (19,951.00) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (19,951.00) (19,951.00) ** (119,706.00) Budgeted (99,755.00) Remaining 17 % Used Department Totals: ------------------------------------------------------------------------------------------------ (891,139.30) ** (1,006,223.00) Budgeted (115,083.70) Remaining 89 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2016 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 1318 03/01/2016 Cancel of WD Paying Agent Fees Cancel of WD Paying Agent Fees 2,500.00 (500.00) 2,000.00 GL 1318 03/01/2016 Cancel of WD Paying Agent Fees Cancel of WD Paying Agent Fees (750.00) 1,250.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: (1,250.00) 1,250.00 ** 2,550.00 Budgeted 1,300.00 Remaining 49 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 158,691.25 .00 158,691.25 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 158,691.25 ** 316,983.00 Budgeted 158,291.75 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 685,000.00 Budgeted 685,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 159,941.25 ** 1,004,533.00 Budgeted 844,591.75 Remaining 16 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (731,198.05) (1,690.00) Budgeted 729,508.05 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MARCH 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 126,260 ACCOUNTS RECEIVABLE - TOTAL ASSETS 126,260 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 111,192 TOTAL FUND BALANCE 126,260 TOTAL LIABILITIES AND FUND BALANCE 126,260 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 15:34 04/08/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 7.00- 7.00- 34.33- 74.70- 1,067.143 67.70 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 43,220.32- 228,735.92- 51.421 216,095.08- Subtotal: 444,838.00- 444,838.00- 43,254.65- 228,810.62- 51.437 216,027.38- Program number: 444,838.00- 444,838.00- 43,254.65- 228,810.62- 51.437 216,027.38- Department number: Revenues 444,838.00- 444,838.00- 43,254.65- 228,810.62- 51.437 216,027.38- Revenues Subtotal ----------- 444,838.00- 444,838.00- 43,254.65- 228,810.62- 51.437 216,027.38- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 15:34 04/08/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 234,838.00 234,838.00 117,618.75 50.085 117,219.25 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 210,000.00 210,000.00 Subtotal: 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Program number: 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Department number: Administration 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Expenditures Subtotal ----------- 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Fund number: 534 2015 Revenue Bond I&S 43,254.65- 111,191.87- 111,191.87 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/2016 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 1314 03/31/2016 Bank Interest/Month (40.37) (34.33) (74.70) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (34.33) (74.70) ** (7.00) Budgeted 67.70 Remaining 1.067 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1197 03/03/2016 Transfer to Rev Bond I&S (185,515.60) (43,220.32) (228,735.92) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (43,220.32) (228,735.92) ** (444,831.00) Budgeted (216,095.08) Remaining 51 % Used Department Totals: ------------------------------------------------------------------------------------------------ (228,810.62) ** (444,838.00) Budgeted (216,027.38) Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 15:34 04/08/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense 117,618.75 .00 117,618.75 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 117,618.75 ** 234,838.00 Budgeted 117,219.25 Remaining 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 210,000.00 Budgeted 210,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 117,618.75 ** 444,838.00 Budgeted 327,219.25 Remaining 26 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (111,191.87) .00 Budgeted 111,191.87 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 643,012.54 **** (125,026.00) Budgeted (768,038.54) Remaining ########## ******* End of Report *********