Loading...
HomeMy WebLinkAbout2017-01 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JANUARY 2017 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,041,684 PREPAID EXPENSES 11,008 ADVALOREM PROPERTY TAXES RECEIVABLE 169,622 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,222,314 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 169,622 ACCOUNTS AND OTHER PAYABLES 54,274 TOTAL LIABILITIES 223,896 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 477,310 TOTAL FUND BALANCE 998,418 TOTAL LIABILITIES AND FUND BALANCE 1,222,314 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 11:03 02/10/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 112.02- 112.02 122-40010-000-000 Property Taxes/MUD Fire 1,035,810.00- 1,035,810.00- 498,258.65- 889,772.81- 85.901 146,037.19- 122-40011-000-000 Property Taxes/Fire-Delinquent 6.94- 1,508.08- 1,508.08 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 33.59- 435.96- 9.688 4,064.04- Subtotal: 1,040,310.00- 1,040,310.00- 498,299.18- 891,828.87- 85.727 148,481.13- 122-49900-000-000 Miscellaneous Income 149.00- 149.00 Subtotal: 149.00- 149.00 Program number: 1,040,310.00- 1,040,310.00- 498,299.18- 891,977.87- 85.742 148,332.13- Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 498,299.18- 891,977.87- 85.742 148,332.13- Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 498,299.18- 891,977.87- 85.742 148,332.13- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 11:03 02/10/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 10,753.91 10,753.91- Subtotal: 10,753.91 10,753.91- 122-60030-045-000 Rent And/Or Usage 216,754.00 216,754.00 216,754.00 122-60055-045-000 Insurance 16,513.00 16,513.00 1,376.09 5,504.36 33.333 11,008.64 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 189,841.00 32.639 391,797.00 Subtotal: 814,905.00 814,905.00 50,350.09 195,345.36 23.972 619,559.64 122-69005-045-000 Capital Outlays 16,836.00 16,836.00 16,836.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 225,405.00 225,405.00 208,568.60 92.531 16,836.40 Program number: 1,040,310.00 1,040,310.00 50,350.09 414,667.87 39.860 625,642.13 Department number: Fire 1,040,310.00 1,040,310.00 50,350.09 414,667.87 39.860 625,642.13 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 50,350.09 414,667.87 39.860 625,642.13 Fund number: 122 Trophy Club MUD Fire Dept. 447,949.09- 477,310.00- 477,310.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2017 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 (112.02) .00 (112.02) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (112.02) ** .00 Budgeted 112.02 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 844 01/03/2017 Property Taxes (391,514.16) (102,806.01) (494,320.17) GL 845 01/04/2017 Property Taxes (5,728.15) (500,048.32) GL 846 01/06/2017 Property Taxes (39,849.33) (539,897.65) GL 847 01/06/2017 Property Taxes (5,413.41) (545,311.06) GL 888 01/06/2017 Reverse JE846/Property Taxes 39,849.33 (505,461.73) GL 889 01/06/2017 Property Taxes (39,849.66) (545,311.39) GL 848 01/07/2017 Property Taxes (9,798.55) (555,109.94) GL 849 01/09/2017 Property Taxes (2,488.86) (557,598.80) GL 850 01/10/2017 Property Taxes (28,211.18) (585,809.98) GL 887 01/10/2017 Reverse JE850/Property Taxes 28,211.18 (557,598.80) GL 890 01/10/2017 Property Taxes (28,211.76) (585,810.56) GL 851 01/11/2017 Property Taxes (107,530.02) (693,340.58) GL 886 01/11/2017 Reverse JE851/Property Taxes 107,530.02 (585,810.56) GL 891 01/11/2017 Property Taxes (107,530.06) (693,340.62) GL 852 01/12/2017 Property Taxes (20,870.59) (714,211.21) GL 885 01/12/2017 Reverse JE852/Property Taxes 20,870.59 (693,340.62) GL 892 01/12/2017 Property Taxes (20,871.02) (714,211.64) GL 853 01/13/2017 Property Taxes (11,669.15) (725,880.79) GL 854 01/17/2017 Property Taxes (11,062.63) (736,943.42) GL 855 01/18/2017 Property Taxes (2,333.22) (739,276.64) GL 856 01/19/2017 Property Taxes (10,626.99) (749,903.63) GL 857 01/20/2017 Property Taxes (11,095.66) (760,999.29) GL 882 01/20/2017 Reverse JE857/Property Taxes 11,095.66 (749,903.63) GL 893 01/20/2017 Property Taxes (11,095.70) (760,999.33) GL 858 01/21/2017 Property Taxes (5,402.22) (766,401.55) GL 894 01/21/2017 Property Taxes (5,402.22) (771,803.77) GL 896 01/21/2017 Reverse JE858/Property Taxes 5,402.22 (766,401.55) GL 859 01/23/2017 Property Taxes (6,094.40) (772,495.95) GL 860 01/24/2017 Property Taxes (18,505.84) (791,001.79) GL 861 01/25/2017 Property Taxes (9,495.91) (800,497.70) GL 863 01/26/2017 Property Taxes (9,771.72) (810,269.42) GL 866 01/27/2017 Property Taxes (56,075.64) (866,345.06) GL 867 01/28/2017 Property Taxes (1,592.90) (867,937.96) GL 869 01/30/2017 Property Taxes (15,792.11) (883,730.07) GL 870 01/31/2017 Property Taxes (6,042.74) (889,772.81) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (498,258.65) (889,772.81) ** (1,035,810.00) Budgeted (146,037.19) Remaining 86 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 844 01/03/2017 Property Taxes (1,501.14) (6.93) (1,508.07) GL 890 01/10/2017 Property Taxes (.01) (1,508.08) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (6.94) (1,508.08) ** .00 Budgeted 1,508.08 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 844 01/03/2017 Property Taxes (402.37) (2.22) (404.59) GL 846 01/06/2017 Property Taxes (6.74) (411.33) GL 888 01/06/2017 Reverse JE846/Property Taxes 6.74 (404.59) GL 889 01/06/2017 Property Taxes (6.41) (411.00) GL 850 01/10/2017 Property Taxes (11.70) (422.70) GL 887 01/10/2017 Reverse JE850/Property Taxes 11.70 (411.00) GL 890 01/10/2017 Property Taxes (11.11) (422.11) GL 851 01/11/2017 Property Taxes (.73) (422.84) GL 886 01/11/2017 Reverse JE851/Property Taxes .73 (422.11) GL 891 01/11/2017 Property Taxes (.69) (422.80) GL 852 01/12/2017 Property Taxes (8.51) (431.31) GL 885 01/12/2017 Reverse JE852/Property Taxes 8.51 (422.80) GL 892 01/12/2017 Property Taxes (8.08) (430.88) GL 857 01/20/2017 Property Taxes (5.33) (436.21) GL 882 01/20/2017 Reverse JE857/Property Taxes 5.33 (430.88) GL 893 01/20/2017 Property Taxes (5.08) (435.96) GL 858 01/21/2017 Property Taxes (5.34) (441.30) GL 896 01/21/2017 Reverse JE858/Property Taxes 5.34 (435.96) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (33.59) (435.96) ** (4,500.00) Budgeted (4,064.04) Remaining 10 % Used Account: 122-49900-000-000 Miscellaneous Income (149.00) .00 (149.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (149.00) ** .00 Budgeted 149.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ----------------------------------- (891,977.87) ** (498,299.18) Monthly Total (1,040,310.00) Budgeted (148,332.13) Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 10,753.91 .00 10,753.91 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 10,753.91 ** .00 Budgeted (10,753.91) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 216,754.00 Budgeted 216,754.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 463 01/01/2017 Insurance/Wrk Comp Exp Jan 4,128.27 1,376.09 5,504.36 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.09 5,504.36 ** 16,513.00 Budgeted 11,008.64 Remaining 33 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 632 01/05/2017 January A/P Fire Budget payment/January 140,867.00 48,974.00 189,841.00 TOWN OF TROPHY CLUB 2710 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 189,841.00 ** 581,638.00 Budgeted 391,797.00 Remaining 33 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 16,836.00 Budgeted 16,836.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-69305-045-000 Capital Leases . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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: ----------------------------------- 414,667.87 ** 50,350.09 Monthly Total 1,040,310.00 Budgeted 625,642.13 Remaining 40 % Used Fund 122 Totals: ----------------------------------- (477,310.00) (447,949.09) Monthly Total .00 Budgeted 477,310.00 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JANUARY 2017 GENERAL FUND GASB 1/31/2017 ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 642,526 - 642,526 CASH IN BANK-SAVINGS-CASH RESERVE 180,300 - 180,300 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 712,749 - 712,749 INVESTMENTS-TEXPOOL 695,712 433,170 1,128,882 PREPAID EXPENSES 57,995 - 57,995 ADVALOREM PROPERTY TAXES RECEIVABLE 10,775 - 10,775 UTILITY AND OTHER ACCOUNTS RECEIVABLE 627,624 - 627,624 TOTAL ASSETS 2,963,439 433,170 3,396,609 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 10,775 - 10,775 ACCOUNTS AND OTHER PAYABLES 649,612 - 649,612 CUSTOMER DEPOSITS 313,775 - 313,775 - TOTAL LIABILITIES 974,162 - 974,162 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,276,319 1,276,319 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 135,000 135,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 90,000 90,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 37,805 37,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 170,365 170,365 UNASSIGNED FUND BALANCE 851,803 - 851,803 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES (142,331) - (142,331) - TOTAL FUND BALANCE 1,989,277 433,170 2,422,447 TOTAL LIABILITIES AND FUND BALANCE 2,963,439 433,170 3,396,609 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 60,977.00- 60,977.00- 29,313.25- 52,346.59- 85.846 8,630.41- 135-40002-000-000 Property Taxes/Delinquent 1.33- 131.40- 131.40 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 2.27- 57.54- 8.852 592.46- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 29,316.85- 52,535.53- 25.027 157,382.47- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 291,750.68- 1,490,462.45- 23.156 4,946,271.55- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 169,250.54- 764,730.92- 29.082 1,864,793.08- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 8,211.19- 40,404.04- 33.879 78,855.96- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,375.00- 4,700.00- 41.228 6,700.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 100.00- 550.00- 27.500 1,450.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 150.00- 750.00- 13.636 4,750.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 6,309.00- 10.311 54,879.00- Subtotal: 9,265,606.00- 9,265,606.00- 470,837.41- 2,307,906.41- 24.908 6,957,699.59- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 1,322.88- 4,396.15- 54.945 3,604.85- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 3,642.12- 33.334 7,283.88- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,749.99- 25.000 5,250.01- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 21,609.00- 21,609.00- 686.00- 4,841.00- 22.403 16,768.00- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 2,050.49- 4,181.37- 20.907 15,818.63- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 30.00- 150.000 10.00 Subtotal: 69,556.00- 69,556.00- 5,553.23- 18,840.63- 27.087 50,715.37- Program number: 9,545,080.00- 9,545,080.00- 505,707.49- 2,379,282.57- 24.927 7,165,797.43- Department number: Revenues 9,545,080.00- 9,545,080.00- 505,707.49- 2,379,282.57- 24.927 7,165,797.43- Revenues Subtotal ----------- 9,545,080.00- 9,545,080.00- 505,707.49- 2,379,282.57- 24.927 7,165,797.43- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 271,143.00 271,143.00 17,901.34 72,145.95 26.608 198,997.05 135-50010-010-000 Overtime 19,500.00 19,500.00 669.78 4,122.94 21.143 15,377.06 135-50016-010-000 Longevity 3,270.00 3,270.00 3,270.00 100.000 135-50017-010-000 Certification 4,800.00 4,800.00 250.00 950.00 19.792 3,850.00 135-50020-010-000 Retirement 27,151.00 27,151.00 1,740.95 7,124.56 26.241 20,026.44 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 2,724.68 10,405.42 18.610 45,508.58 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 299.27 902.17 21.692 3,256.83 135-50028-010-000 Vision Insurance 910.00 910.00 53.76 188.93 20.762 721.07 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 450.31 1,090.24 38.895 1,712.76 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,126.30 4,900.19 25.762 14,120.81 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 263.41 1,146.03 25.765 3,301.97 135-50040-010-000 Unemployment Taxes 1,026.00 1,026.00 357.61 357.61 34.855 668.39 135-50045-010-000 Workman's Compensation 13,152.00 13,152.00 1,074.16 4,296.64 32.669 8,855.36 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 1,300.00 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 428,897.00 428,897.00 26,911.57 110,900.68 25.857 317,996.32 135-55005-010-000 Engineering 5,000.00 5,000.00 705.45 16,717.68 334.354 11,717.68- 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 6,213.13- 11,842.51 11.843 88,157.49 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 463.52 490.52 6.132 7,509.48 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 1,175.40 21.371 4,324.60 Subtotal: 125,000.00 125,000.00 5,044.16- 30,226.11 24.181 94,773.89 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 1,058.85 19.608 4,341.15 135-60020-010-000 Electricity 172,737.00 172,737.00 22,147.35 52,884.76 30.616 119,852.24 135-60066-010-000 Publications/Books/Subscripts 750.00 750.00 750.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,222.00 4,222.00 265.00 6.277 3,957.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 1,500.00 124.46 8.297 1,375.54 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 50,176.00 50,176.00 3,873.00 18,063.95 36.001 32,112.05 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 107,899.97 473,079.82 15.776 2,525,722.18 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 5,000.00 5,000.00 750.00 15.000 4,250.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 14,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 297,011.00 21,892.88 87,571.49 29.484 209,439.51 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 14,361.00 57,444.00 88.484 7,476.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,820,368.00 3,820,368.00 170,174.20 691,242.33 18.094 3,129,125.67 135-65005-010-000 Fuel & Lube 33,011.00 33,011.00 800.71 2,685.97 8.137 30,325.03 135-65010-010-000 Uniforms 4,608.00 4,608.00 1,158.49 25.141 3,449.51 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,348.20 4,711.49 23.557 15,288.51 135-65035-010-000 Small Tools 1,200.00 1,200.00 221.62 18.468 978.38 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 115,000.00 115,000.00 11,708.26 10.181 103,291.74 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 41,464.00 50.876 40,036.00 Subtotal: 256,319.00 256,319.00 2,148.91 61,949.83 24.169 194,369.17 135-69005-010-000 Capital Outlays 502,421.00 502,421.00 47,311.49 246,277.09 49.018 256,143.91 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 118,775.00 118,775.00 37,787.73 118,774.42 100.000 .58 Subtotal: 696,196.00 696,196.00 85,099.22 440,051.51 63.208 256,144.49 Program number: 5,326,780.00 5,326,780.00 279,289.74 1,334,370.46 25.050 3,992,409.54 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/2017 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 240.00 4.800 4,760.00 Subtotal: 5,000.00 5,000.00 240.00 4.800 4,760.00 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 240.00 2.400 9,760.00 Department number: Water 5,336,780.00 5,336,780.00 279,289.74 1,334,610.46 25.008 4,002,169.54 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 391,102.00 391,102.00 29,748.68 118,162.99 30.213 272,939.01 135-50010-020-000 Overtime 29,500.00 29,500.00 3,800.01 12,708.81 43.081 16,791.19 135-50016-020-000 Longevity 6,635.00 6,635.00 6,635.00 100.000 135-50017-020-000 Certification 7,800.00 7,800.00 625.00 2,500.00 32.051 5,300.00 135-50020-020-000 Retirement 39,584.00 39,584.00 3,161.06 12,400.27 31.326 27,183.73 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,433.91 17,453.91 23.902 55,568.09 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 399.32 1,269.76 27.652 3,322.24 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 84.33 279.60 27.119 751.40 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 740.65 1,811.11 40.381 2,673.89 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 1,997.92 8,145.71 29.211 19,740.29 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 467.25 1,905.03 29.209 4,616.97 135-50040-020-000 Unemployment Taxes 1,197.00 1,197.00 649.28 649.28 54.242 547.72 135-50045-020-000 Workman's Compensation 11,347.00 11,347.00 926.75 3,707.00 32.669 7,640.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 650.00 650.00 82.37 203.02 31.234 446.98 Subtotal: 605,653.00 605,653.00 47,116.53 187,831.49 31.013 417,821.51 135-55005-020-000 Engineering 70,000.00 70,000.00 70,000.00 135-55070-020-000 Independent Labor 20,000.00 20,000.00 5,126.74 12,905.86 64.529 7,094.14 135-55080-020-000 Maintenance & Repairs 83,100.00 83,100.00 3,282.88 28,276.07 34.027 54,823.93 135-55085-020-000 Generator Maint. and Repair 20,000.00 20,000.00 20,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 1,697.52 5,355.78 133.895 1,355.78- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 23.94 4.788 476.06 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 5,825.01 18,631.41 33.875 36,368.59 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 1,896.00 8,555.00 34.220 16,445.00 Subtotal: 277,600.00 277,600.00 17,828.15 73,748.06 26.566 203,851.94 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 276.00 1,568.39 29.044 3,831.61 135-60020-020-000 Electricity 158,627.00 158,627.00 1,867.83 29,206.36 18.412 129,420.64 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 143.85 143.85 35.963 256.15 135-60070-020-000 Dues & Memberships 250.00 250.00 250.00 135-60080-020-000 Schools & Training 4,195.00 4,195.00 257.36 1,352.36 32.237 2,842.64 135-60090-020-000 Safety Program 550.00 550.00 3.97 146.16 26.575 403.84 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 271.07 408.81 25.551 1,191.19 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60125-020-000 Advertising 4,086.37 4,086.37- 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 433.00 14,343.97 83.638 2,806.03 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 6,621.00 6,621.00 590.00 8.911 6,031.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 11,600.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 10,953.82 43,815.28 36.364 76,676.72 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 54,148.91 216,595.64 36.364 379,042.36 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60333-020-000 Interfund Transfer Out-Reserve 123,492.00 123,492.00 11,226.55 44,906.15 36.364 78,585.85 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 Subtotal: 1,255,465.00 1,255,465.00 79,582.36 357,163.34 28.449 898,301.66 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 707.77 2,542.54 9.052 25,545.46 135-65010-020-000 Uniforms 4,459.00 4,459.00 3,553.92 79.702 905.08 135-65030-020-000 Chemicals 25,000.00 25,000.00 9,777.29 39.109 15,222.71 135-65035-020-000 Small Tools 2,000.00 2,000.00 782.54 39.127 1,217.46 135-65040-020-000 Safety Equipment 750.00 750.00 49.83 6.644 700.17 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 1,252.27 5,287.64 37.769 8,712.36 Subtotal: 74,297.00 74,297.00 1,960.04 21,993.76 29.602 52,303.24 135-69005-020-000 Capital Outlays 485,000.00 485,000.00 100,282.67 133,104.72 27.444 351,895.28 Subtotal: 485,000.00 485,000.00 100,282.67 133,104.72 27.444 351,895.28 Program number: 2,698,015.00 2,698,015.00 246,769.75 773,841.37 28.682 1,924,173.63 Department number: Wastewater 2,698,015.00 2,698,015.00 246,769.75 773,841.37 28.682 1,924,173.63 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 32.00 32.00 2.61 10.44 32.625 21.56 Subtotal: 32.00 32.00 2.61 10.44 32.625 21.56 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 435.00 1,560.00 39.000 2,440.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,403.86 1,403.86 28.077 3,596.14 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 12,850.00 12,850.00 1,838.86 2,963.86 23.065 9,886.14 Program number: 12,882.00 12,882.00 1,841.47 2,974.30 23.089 9,907.70 Department number: Board of Directors 12,882.00 12,882.00 1,841.47 2,974.30 23.089 9,907.70 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 519,883.00 519,883.00 30,830.24 115,028.99 22.126 404,854.01 135-50010-030-000 Overtime 1,000.00 1,000.00 153.33 754.15 75.415 245.85 135-50016-030-000 Longevity 3,890.00 3,890.00 3,417.50 87.853 472.50 135-50020-030-000 Retirement 47,768.00 47,768.00 2,865.98 10,329.89 21.625 37,438.11 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 3,545.69 12,125.24 14.385 72,163.76 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 348.90 987.26 16.507 4,993.74 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 75.82 210.75 16.063 1,101.25 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 808.08 1,490.03 25.298 4,399.97 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 1,833.33 6,941.66 21.178 25,835.34 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 428.76 1,623.44 20.082 6,460.56 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 588.68 810.41 59.240 557.59 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 145.53 582.12 32.630 1,201.88 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 185.45 339.35 67.870 160.65 135-50070-030-000 Employee Relations 4,960.00 4,960.00 103.98 2,229.72 44.954 2,730.28 Subtotal: 719,486.00 719,486.00 41,913.77 156,870.51 21.803 562,615.49 135-55030-030-000 Software & Support 67,791.00 67,791.00 35,530.94 50,639.98 74.700 17,151.02 135-55070-030-000 Independent Labor 12,000.00 12,000.00 715.00 5.958 11,285.00 135-55080-030-000 Maintenance & Repairs 7,000.00 7,000.00 275.00 3.929 6,725.00 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 485.00 485.00 4.850 9,515.00 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 345.34 3,780.80 54.011 3,219.20 135-55120-030-000 Cleaning Services 10,429.00 10,429.00 633.06 1,876.18 17.990 8,552.82 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 57,332.00 90.536 5,993.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 248.20 2,620.84 31.961 5,579.16 Subtotal: 185,945.00 185,945.00 37,242.54 117,724.80 63.312 68,220.20 135-60005-030-000 Telephone 17,532.00 17,532.00 650.24 4,425.66 25.243 13,106.34 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 225.00 863.97 20.819 3,286.03 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 882.09 6.984 11,748.91 135-60025-030-000 Water 1,500.00 1,500.00 87.78 526.45 35.097 973.55 135-60035-030-000 Postage 28,932.00 28,932.00 1,761.61 10,032.80 34.677 18,899.20 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,419.42 17,803.34 32.043 37,756.66 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 526.88 526.88 15.054 2,973.12 135-60055-030-000 Insurance 55,692.00 55,692.00 4,664.56 18,658.24 33.503 37,033.76 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 50.88 50.88 3.180 1,549.12 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 580.00 4,336.25 72.271 1,663.75 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 8,754.00 8,754.00 51.65 .590 8,702.35 135-60080-030-000 Schools & Training 7,840.00 7,840.00 7,840.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 1,221.46 1,401.24 25.949 3,998.76 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 7,500.00 7,500.00 7,500.00 135-60125-030-000 Advertising 7,500.00 7,500.00 950.09 12.668 6,549.91 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 17,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 1,040.00 41.600 1,460.00 Subtotal: 246,041.00 246,041.00 14,187.83 61,549.54 25.016 184,491.46 135-65010-030-000 Uniforms 1,855.00 1,855.00 142.36 7.674 1,712.64 135-65055-030-000 Hardware 9,444.00 9,444.00 2,239.88 23.717 7,204.12 135-65085-030-000 Office Supplies 9,000.00 9,000.00 428.58 2,093.21 23.258 6,906.79 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 2,000.00 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 120.97 934.11 18.682 4,065.89 135-65105-030-000 Printing 4,800.00 4,800.00 123.00 2.563 4,677.00 Subtotal: 32,099.00 32,099.00 549.55 5,532.56 17.236 26,566.44 135-69005-030-000 Capital Outlays 107,001.00 107,001.00 8,695.45 8.127 98,305.55 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 452.27 1,074.50 23.359 3,525.50 Subtotal: 111,601.00 111,601.00 452.27 9,769.95 8.754 101,831.05 Program number: 1,295,172.00 1,295,172.00 94,345.96 351,447.36 27.135 943,724.64 Department number: Administration 1,295,172.00 1,295,172.00 94,345.96 351,447.36 27.135 943,724.64 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 11:03 02/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 150,000.00 150,000.00 31,022.50 32,793.43 21.862 117,206.57 135-55055-039-000 Auditing 23,860.00 23,860.00 18,808.92 18,808.92 78.830 5,051.08 135-55060-039-000 Appraisal 11,115.00 11,115.00 4,575.71 41.167 6,539.29 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,561.76 67.415 1,238.24 Subtotal: 188,775.00 188,775.00 49,831.42 58,739.82 31.116 130,035.18 Program number: 188,775.00 188,775.00 49,831.42 58,739.82 31.116 130,035.18 Department number: Non Departmental 188,775.00 188,775.00 49,831.42 58,739.82 31.116 130,035.18 Expenditures Subtotal ----------- 9,531,624.00 9,531,624.00 672,078.34 2,521,613.31 26.455 7,010,010.69 Fund number: 135 MUD 1 General Fund 13,456.00- 13,456.00- 166,370.85 142,330.74 -1,057.749 155,786.74- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 11:03 02/10/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 1/2017 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2017 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 844 01/03/2017 Property Taxes (23,033.34) (6,048.22) (29,081.56) GL 845 01/04/2017 Property Taxes (337.00) (29,418.56) GL 846 01/06/2017 Property Taxes (2,344.39) (31,762.95) GL 847 01/06/2017 Property Taxes (318.48) (32,081.43) GL 888 01/06/2017 Reverse JE846/Property Taxes 2,344.39 (29,737.04) GL 889 01/06/2017 Property Taxes (2,344.41) (32,081.45) GL 848 01/07/2017 Property Taxes (576.46) (32,657.91) GL 849 01/09/2017 Property Taxes (146.42) (32,804.33) GL 850 01/10/2017 Property Taxes (1,659.70) (34,464.03) GL 887 01/10/2017 Reverse JE850/Property Taxes 1,659.70 (32,804.33) GL 890 01/10/2017 Property Taxes (1,659.74) (34,464.07) GL 851 01/11/2017 Property Taxes (6,326.15) (40,790.22) GL 886 01/11/2017 Reverse JE851/Property Taxes 6,326.15 (34,464.07) GL 891 01/11/2017 Property Taxes (6,326.15) (40,790.22) GL 852 01/12/2017 Property Taxes (1,227.85) (42,018.07) GL 885 01/12/2017 Reverse JE852/Property Taxes 1,227.85 (40,790.22) GL 892 01/12/2017 Property Taxes (1,227.87) (42,018.09) GL 853 01/13/2017 Property Taxes (686.51) (42,704.60) GL 854 01/17/2017 Property Taxes (650.83) (43,355.43) GL 855 01/18/2017 Property Taxes (137.27) (43,492.70) GL 856 01/19/2017 Property Taxes (625.20) (44,117.90) GL 857 01/20/2017 Property Taxes (652.77) (44,770.67) GL 882 01/20/2017 Reverse JE857/Property Taxes 652.77 (44,117.90) GL 893 01/20/2017 Property Taxes (652.78) (44,770.68) GL 858 01/21/2017 Property Taxes (317.82) (45,088.50) GL 894 01/21/2017 Property Taxes (317.82) (45,406.32) GL 896 01/21/2017 Reverse JE858/Property Taxes 317.82 (45,088.50) GL 859 01/23/2017 Property Taxes (358.54) (45,447.04) GL 860 01/24/2017 Property Taxes (1,088.72) (46,535.76) GL 861 01/25/2017 Property Taxes (558.66) (47,094.42) GL 863 01/26/2017 Property Taxes (574.88) (47,669.30) GL 866 01/27/2017 Property Taxes (3,299.01) (50,968.31) GL 867 01/28/2017 Property Taxes (93.71) (51,062.02) GL 869 01/30/2017 Property Taxes (929.07) (51,991.09) GL 870 01/31/2017 Property Taxes (355.50) (52,346.59) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (29,313.25) (52,346.59) ** (60,977.00) Budgeted (8,630.41) Remaining 86 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 844 01/03/2017 Property Taxes (130.07) (1.33) (131.40) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.33) (131.40) ** .00 Budgeted 131.40 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 844 01/03/2017 Property Taxes (55.27) (.43) (55.70) GL 846 01/06/2017 Property Taxes (.40) (56.10) GL 888 01/06/2017 Reverse JE846/Property Taxes .40 (55.70) GL 889 01/06/2017 Property Taxes (.38) (56.08) GL 850 01/10/2017 Property Taxes (.69) (56.77) GL 887 01/10/2017 Reverse JE850/Property Taxes .69 (56.08) GL 890 01/10/2017 Property Taxes (.65) (56.73) GL 851 01/11/2017 Property Taxes (.04) (56.77) GL 886 01/11/2017 Reverse JE851/Property Taxes .04 (56.73) GL 891 01/11/2017 Property Taxes (.04) (56.77) GL 852 01/12/2017 Property Taxes (.50) (57.27) GL 885 01/12/2017 Reverse JE852/Property Taxes .50 (56.77) GL 892 01/12/2017 Property Taxes (.48) (57.25) GL 857 01/20/2017 Property Taxes (.32) (57.57) GL 882 01/20/2017 Reverse JE857/Property Taxes .32 (57.25) GL 893 01/20/2017 Property Taxes (.29) (57.54) GL 858 01/21/2017 Property Taxes (.31) (57.85) GL 896 01/21/2017 Reverse JE858/Property Taxes .31 (57.54) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (2.27) (57.54) ** (650.00) Budgeted (592.46) Remaining 9 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (148,291.00) Budgeted (148,291.00) Remaining 0 % Used Account: 135-47000-000-000 Water 794 01/05/2017 01/05/2017 UB Adjustments UB20170105-20170105 User: (1,198,711.77) 92.05 (1,198,619.72) UB 797 01/10/2017 N TX Contracting/water main (632.69) (1,199,252.41) GL 798 01/10/2017 01/10/2017 Adjustments UB UB20170110-20170110 User: 24.67 (1,199,227.74) UB 780 01/31/2017 01/31/2017 UB Billing UB20170131-20170131 User: (291,234.71) (1,490,462.45) UB _______________ Account: 135-47000-000-000 Water Totals: (291,750.68) (1,490,462.45) ** (6,436,734.00) Budgeted (4,946,271.55) Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47005-000-000 Sewer 794 01/05/2017 01/05/2017 UB Adjustments UB20170105-20170105 User: (595,480.38) 36.92 (595,443.46) UB 798 01/10/2017 01/10/2017 Adjustments UB UB20170110-20170110 User: 13.37 (595,430.09) UB 780 01/31/2017 01/31/2017 UB Billing UB20170131-20170131 User: (169,300.83) (764,730.92) UB _______________ Account: 135-47005-000-000 Sewer Totals: (169,250.54) (764,730.92) ** (2,629,524.00) Budgeted (1,864,793.08) Remaining 29 % Used Account: 135-47025-000-000 Penalties 801 01/16/2017 01/16/17 UB Penalties UB20170116-20170116 User: (32,192.85) 102.43 (32,090.42) UB 742 01/23/2017 01/23/2017 UB Penalties UB20170123-20170123 User: (8,612.79) (40,703.21) UB 743 01/23/2017 01/23/2017 UB Penalties UB20170123-20170123 User: (8,597.29) (49,300.50) UB 811 01/23/2017 01/23/17 UB Penalties UB20170123-20170123 User: 8,612.79 (40,687.71) UB 814 01/30/2017 01/30/17 UB Penalties UB20170130-20170130 User: 283.67 (40,404.04) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,211.19) (40,404.04) ** (119,260.00) Budgeted (78,855.96) Remaining 34 % Used Account: 135-47030-000-000 Service Charges 607 01/05/2017 UB Disconnect Fees 01/05/2017 UB20170105-20170105 User: (3,325.00) (1,100.00) (4,425.00) UB 783 01/10/2017 01/10/2017 NSF fee UB20170110-20170110 User: (25.00) (4,450.00) UB 799 01/11/2017 01/11/2017 NSF fee UB UB20170111-20170111 User: (25.00) (4,475.00) UB 803 01/17/2017 01/17/2017 Ub NSF fee UB20170117-20170117 User: (25.00) (4,500.00) UB 805 01/18/2017 01/18/17 UB NSF fee UB20170118-20170118 User: (25.00) (4,525.00) UB 807 01/20/2017 01/20/17 UB NSF fee UB20170120-20170120 User: (25.00) (4,550.00) UB 809 01/23/2017 01/23/17 UB NSF fee UB20170123-20170123 User: (50.00) (4,600.00) UB 812 01/25/2017 01/25/17 UB Adjustments UB20170125-20170125 User: (100.00) (4,700.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,375.00) (4,700.00) ** (11,400.00) Budgeted (6,700.00) Remaining 41 % Used Account: 135-47035-000-000 Plumbing Inspections 649 01/04/2017 Builder permits 317 Tenison Trail (450.00) (50.00) (500.00) First Texas Homes CR 660 01/10/2017 01/10/2017 ub deposit 100 Municipal Drive (50.00) (550.00) Town of Trophy Club CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (550.00) ** (2,000.00) Budgeted (1,450.00) Remaining 28 % Used Account: 135-47045-000-000 Sewer Inspections . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 649 01/04/2017 Builder permits 317 Tenison Trail (600.00) (150.00) (750.00) First Texas Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (750.00) ** (5,500.00) Budgeted (4,750.00) Remaining 14 % Used Account: 135-47070-000-000 TCCC Effluent Charges (6,309.00) .00 (6,309.00) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (6,309.00) ** (61,188.00) Budgeted (54,879.00) Remaining 10 % Used Account: 135-49010-000-000 Interest Income 899 01/31/2017 Bank Statement Interest/Jan (3,073.27) (156.18) (3,229.45) GL 899 01/31/2017 Bank Statement Interest/Jan (253.79) (3,483.24) GL 899 01/31/2017 Bank Statement Interest/Jan (912.91) (4,396.15) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,322.88) (4,396.15) ** (8,001.00) Budgeted (3,604.85) Remaining 55 % Used Account: 135-49016-000-000 Cell Tower Revenue 796 01/05/2017 AT&T Cell Tower Revenue (2,731.59) (910.53) (3,642.12) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (3,642.12) ** (10,926.00) Budgeted (7,283.88) Remaining 33 % Used Account: 135-49018-000-000 Building Rent Income 873 01/31/2017 Town Billed Jan AR 20170131-20170131 User: (1,166.66) (583.33) (1,749.99) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,749.99) ** (7,000.00) Budgeted (5,250.01) Remaining 25 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 649 01/04/2017 Builder permits 317 Tenison Trail (4,155.00) (343.00) (4,498.00) First Texas Homes CR 660 01/10/2017 01/10/2017 ub deposit 100 Municipal Drive (343.00) (4,841.00) Town Of Trophy Club CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (4,841.00) ** (21,609.00) Budgeted (16,768.00) Remaining 22 % Used Account: 135-49900-000-000 Miscellaneous Income 786 01/03/2017 UB 1/3/17 Refund UB20170103-20170103 User: (2,130.88) (.75) (2,131.63) UB 649 01/04/2017 Builder permits 2103 veranda Avenue (800.00) (2,931.63) Calatlantic Homes CR 649 01/04/2017 Builder permits 2117 Veranda Avenue (800.00) (3,731.63) Calatlantic Homes CR 812 01/25/2017 01/25/17 UB Adjustments UB20170125-20170125 User: (370.24) (4,101.87) UB 813 01/27/2017 01/27/17 UB Adjustments UB20170127-20170127 User: (40.00) (4,141.87) UB 780 01/31/2017 01/31/2017 UB Billing UB20170131-20170131 User: (39.50) (4,181.37) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (2,050.49) (4,181.37) ** (20,000.00) Budgeted (15,818.63) Remaining 21 % Used Account: 135-49901-000-000 Records Management Revenue (30.00) .00 (30.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (30.00) ** (20.00) Budgeted 10.00 Remaining 150 % Used Department Totals: ----------------------------------- (2,379,282.57) ** (505,707.49) Monthly Total (9,545,080.00) Budgeted (7,165,797.43) Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 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 673 01/13/2017 MUD P/R 01/03/2017 Salaries & Wages 54,244.61 8,875.79 63,120.40 PR 753 01/27/2017 MUD P/R 01/27/2017 Salaries & Wages 9,025.55 72,145.95 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 17,901.34 72,145.95 ** 271,143.00 Budgeted 198,997.05 Remaining 27 % Used Account: 135-50010-010-000 Overtime 673 01/13/2017 MUD P/R 01/03/2017 Overtime 3,453.16 626.69 4,079.85 PR 753 01/27/2017 MUD P/R 01/27/2017 Overtime 43.09 4,122.94 PR _______________ Account: 135-50010-010-000 Overtime Totals: 669.78 4,122.94 ** 19,500.00 Budgeted 15,377.06 Remaining 21 % Used Account: 135-50016-010-000 Longevity 3,270.00 .00 3,270.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,270.00 ** 3,270.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 753 01/27/2017 MUD P/R 01/27/2017 Certification 700.00 250.00 950.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 250.00 950.00 ** 4,800.00 Budgeted 3,850.00 Remaining 20 % Used Account: 135-50020-010-000 Retirement 673 01/13/2017 MUD P/R 01/03/2017 Retirement 5,383.61 878.98 6,262.59 PR 753 01/27/2017 MUD P/R 01/27/2017 Retirement 861.97 7,124.56 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,740.95 7,124.56 ** 27,151.00 Budgeted 20,026.44 Remaining 26 % Used Account: 135-50026-010-000 Medical Insurance 643 01/04/2017 Aetna Health Premium Jan (ACH) Adm fee credit when signed up 7,680.74 (197.35) 7,483.39 GL 673 01/13/2017 MUD P/R 01/03/2017 Medical Insurance 1,461.01 8,944.40 PR 753 01/27/2017 MUD P/R 01/27/2017 Medical Insurance 1,461.02 10,405.42 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,724.68 10,405.42 ** 55,914.00 Budgeted 45,508.58 Remaining 19 % Used Account: 135-50027-010-000 Dental Insurance 673 01/13/2017 MUD P/R 01/03/2017 Dental Insurance 602.90 149.65 752.55 PR 753 01/27/2017 MUD P/R 01/27/2017 Dental Insurance 149.62 902.17 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 299.27 902.17 ** 4,159.00 Budgeted 3,256.83 Remaining 22 % Used Account: 135-50028-010-000 Vision Insurance 673 01/13/2017 MUD P/R 01/03/2017 Vision Insurance 135.17 26.90 162.07 PR 753 01/27/2017 MUD P/R 01/27/2017 Vision Insurance 26.86 188.93 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.76 188.93 ** 910.00 Budgeted 721.07 Remaining 21 % Used Account: 135-50029-010-000 Life Insurance & Other 519 01/01/2017 Jan A/P Dental, Vision, LTD, ADD 639.93 220.30 860.23 METLIFE GROUP BENEFITS 2676 AP 772 01/30/2017 January AP Café 125 Admin Fee 9.71 869.94 BenefitMall 2802 AP 779 01/31/2017 January AP Misc ins/Feb 220.30 1,090.24 METLIFE GROUP BENEFITS 2833 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 450.31 1,090.24 ** 2,803.00 Budgeted 1,712.76 Remaining 39 % Used Account: 135-50030-010-000 Social Security Taxes 673 01/13/2017 MUD P/R 01/03/2017 Social Security Taxes 3,773.89 577.01 4,350.90 PR 753 01/27/2017 MUD P/R 01/27/2017 Social Security Taxes 549.29 4,900.19 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,126.30 4,900.19 ** 19,021.00 Budgeted 14,120.81 Remaining 26 % Used Account: 135-50035-010-000 Medicare Taxes 673 01/13/2017 MUD P/R 01/03/2017 Medicare Taxes 882.62 134.94 1,017.56 PR 753 01/27/2017 MUD P/R 01/27/2017 Medicare Taxes 128.47 1,146.03 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 263.41 1,146.03 ** 4,448.00 Budgeted 3,301.97 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 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 673 01/13/2017 MUD P/R 01/03/2017 Unemployment Taxes 180.54 180.54 PR 753 01/27/2017 MUD P/R 01/27/2017 Unemployment Taxes 177.07 357.61 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 357.61 357.61 ** 1,026.00 Budgeted 668.39 Remaining 35 % Used Account: 135-50045-010-000 Workman's Compensation 463 01/01/2017 Insurance/Wrk Comp Exp Jan 3,222.48 1,074.16 4,296.64 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,074.16 4,296.64 ** 13,152.00 Budgeted 8,855.36 Remaining 33 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 1,300.00 Budgeted 1,300.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering 779 01/31/2017 January AP Water line to PD-30 16,012.23 705.45 16,717.68 Halff Associates, INC 2815 AP _______________ Account: 135-55005-010-000 Engineering Totals: 705.45 16,717.68 ** 5,000.00 Budgeted (11,717.68) Remaining 334 % Used Account: 135-55080-010-000 Maintenance & Repairs 797 01/10/2017 N TX Contracting/water main 18,055.64 (7,209.54) 10,846.10 GL 719 01/18/2017 January AP Pump #1 Project 550.00 11,396.10 DHS AUTOMATION, INC 2777 AP 830 01/26/2017 Jan A/P GIERISCH CARE 0050292 273.69 11,669.79 GIERISCH CARE 0050292 PC 830 01/26/2017 Jan A/P THE HOME DEPOT #6581 36.72 11,706.51 THE HOME DEPOT #6581 PC 772 01/30/2017 January AP Fire Extinguisher Inspection 136.00 11,842.51 KIMBROUGH FIRE EXTINQUISHER CO 2821 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: (6,213.13) 11,842.51 ** 100,000.00 Budgeted 88,157.49 Remaining 12 % Used Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 830 01/26/2017 Jan A/P DENTON CO TX MOTOR VEH 27.00 1.00 28.00 DENTON CO TX MOTOR VEH PC 830 01/26/2017 Jan A/P DENTON CO TX MOTOR VEH 14.25 42.25 DENTON CO TX MOTOR VEH PC 830 01/26/2017 Jan A/P TX.GOV SERVICEFEE 2.00 44.25 TX.GOV SERVICEFEE PC 830 01/26/2017 Jan A/P DENTON VEHREG 14.25 58.50 DENTON VEHREG PC 830 01/26/2017 Jan A/P DENTON CO TX MOTOR VEH 7.50 66.00 DENTON CO TX MOTOR VEH PC 830 01/26/2017 Jan A/P DENTON CO TX MOTOR VEH 1.00 67.00 DENTON CO TX MOTOR VEH PC 830 01/26/2017 Jan A/P DISCOUNT TIRE TXD 75 206.00 273.00 DISCOUNT TIRE TXD 75 PC 830 01/26/2017 Jan A/P THE HOME DEPOT #6581 9.02 282.02 THE HOME DEPOT #6581 PC 830 01/26/2017 Jan A/P DISCOUNT TIRE TXD 75 208.50 490.52 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 463.52 490.52 ** 8,000.00 Budgeted 7,509.48 Remaining 6 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 1,175.40 .00 1,175.40 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 1,175.40 ** 5,500.00 Budgeted 4,324.60 Remaining 21 % Used Account: 135-60010-010-000 Communications/Mobiles 1,058.85 .00 1,058.85 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: .00 1,058.85 ** 5,400.00 Budgeted 4,341.15 Remaining 20 % Used Account: 135-60020-010-000 Electricity 647 01/09/2017 Jan A/P Electricity Town Elev Tank 30,737.41 121.12 30,858.53 HUDSON ENERGY SERVICES, LLC 2748 AP 772 01/30/2017 January AP Electricity 12/9-1/10/17 549.52 31,408.05 HUDSON ENERGY SERVICES, LLC 2799 AP 772 01/30/2017 January AP Electricity 12/9-1/10/2017 11,111.96 42,520.01 HUDSON ENERGY SERVICES, LLC 2799 AP 772 01/30/2017 January AP Electricity 12/9-1/10/17 9,537.94 52,057.95 HUDSON ENERGY SERVICES, LLC 2799 AP 875 01/31/2017 Jan A/P Electricity 12/10-1/10/17 826.81 52,884.76 HUDSON ENERGY SERVICES, LLC 2862 AP _______________ Account: 135-60020-010-000 Electricity Totals: 22,147.35 52,884.76 ** 172,737.00 Budgeted 119,852.24 Remaining 31 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 265.00 .00 265.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 265.00 ** 4,222.00 Budgeted 3,957.00 Remaining 6 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60100-010-000 Travel & per diem 124.46 .00 124.46 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 124.46 ** 1,500.00 Budgeted 1,375.54 Remaining 8 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 862 01/31/2017 Jan A/P Well Water Fee 14,190.95 3,873.00 18,063.95 North Texas Groundwater 2858 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 3,873.00 18,063.95 ** 50,176.00 Budgeted 32,112.05 Remaining 36 % Used Account: 135-60150-010-000 Wholesale Water 772 01/30/2017 January AP wholesale water 365,179.85 107,899.97 473,079.82 CITY OF FORT WORTH 2804 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 107,899.97 473,079.82 ** 2,998,802.00 Budgeted 2,525,722.18 Remaining 16 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 750.00 .00 750.00 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 750.00 ** 5,000.00 Budgeted 4,250.00 Remaining 15 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,750.00 Budgeted 14,750.00 Remaining 0 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 823 01/31/2017 Texpool Transfers 65,678.61 21,892.88 87,571.49 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 21,892.88 87,571.49 ** 297,011.00 Budgeted 209,439.51 Remaining 29 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 823 01/31/2017 Texpool Transfers 43,083.00 14,361.00 57,444.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 14,361.00 57,444.00 ** 64,920.00 Budgeted 7,476.00 Remaining 88 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 830 01/26/2017 Jan A/P 7-ELEVEN 32921 1,885.26 13.00 1,898.26 7-ELEVEN 32921 PC 820 01/31/2017 January AP Fuel 787.71 2,685.97 US Bank Voyager Fleet Systems 2848 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 800.71 2,685.97 ** 33,011.00 Budgeted 30,325.03 Remaining 8 % Used Account: 135-65010-010-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,158.49 .00 1,158.49 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,158.49 ** 4,608.00 Budgeted 3,449.51 Remaining 25 % Used Account: 135-65030-010-000 Chemicals 713 01/18/2017 January AP Testing supplies 3,363.29 287.47 3,650.76 HACH COMPANY 2781 AP 716 01/18/2017 January AP Testing supplies 314.06 3,964.82 HACH COMPANY 2781 AP 724 01/19/2017 January AP LAS 428.84 4,393.66 Valley Solvent Company, INC 2792 AP 772 01/30/2017 January AP Chlorine 317.83 4,711.49 DPC INDUSTRIES, INC 2806 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,348.20 4,711.49 ** 20,000.00 Budgeted 15,288.51 Remaining 24 % Used Account: 135-65035-010-000 Small Tools 221.62 .00 221.62 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 221.62 ** 1,200.00 Budgeted 978.38 Remaining 18 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 11,708.26 .00 11,708.26 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 11,708.26 ** 115,000.00 Budgeted 103,291.74 Remaining 10 % Used Account: 135-65053-010-000 Meter Change Out Program 41,464.00 .00 41,464.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 41,464.00 ** 81,500.00 Budgeted 40,036.00 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-010-000 Capital Outlays 647 01/09/2017 Jan A/P R&R Bed for new 2007 Dodge 198,965.60 187.50 199,153.10 MICHAEL G. WATSON 2750 AP 668 01/11/2017 January AP New Truck-Install bed 940.25 200,093.35 MICHAEL G. WATSON 2762 AP 713 01/18/2017 January AP 2017 Dodge 2500 25,546.00 225,639.35 Grapevine Dodge Chrysler Jeep 2780 AP 713 01/18/2017 January AP 2017 Dodge 2500-Door Decals 55.00 225,694.35 M-KAM LTD. 2784 AP 719 01/18/2017 January AP LAS Project 700.00 226,394.35 DHS AUTOMATION, INC 2777 AP 719 01/18/2017 January AP LAS Project 340.00 226,734.35 DHS AUTOMATION, INC 2777 AP 719 01/18/2017 January AP LAS Project 849.50 227,583.85 DHS AUTOMATION, INC 2777 AP 862 01/31/2017 Jan A/P Waterline to PD30 18,693.24 246,277.09 Halff Associates, INC 2856 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 47,311.49 246,277.09 ** 502,421.00 Budgeted 256,143.91 Remaining 49 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 632 01/05/2017 January A/P Annual tank inspection-WT Plan 80,986.69 37,787.73 118,774.42 UTILITY SERVICE CO, INC. 2714 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 37,787.73 118,774.42 ** 118,775.00 Budgeted .58 Remaining 100 % Used Account: 135-55135-010-001 Lab Analysis for PID 240.00 .00 240.00 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 240.00 ** 5,000.00 Budgeted 4,760.00 Remaining 5 % 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,334,610.46 ** 279,289.74 Monthly Total 5,336,780.00 Budgeted 4,002,169.54 Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 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 673 01/13/2017 MUD P/R 01/03/2017 Salaries & Wages 88,414.31 14,719.26 103,133.57 PR 753 01/27/2017 MUD P/R 01/27/2017 Salaries & Wages 15,029.42 118,162.99 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 29,748.68 118,162.99 ** 391,102.00 Budgeted 272,939.01 Remaining 30 % Used Account: 135-50010-020-000 Overtime 673 01/13/2017 MUD P/R 01/03/2017 Overtime 8,908.80 2,491.15 11,399.95 PR 753 01/27/2017 MUD P/R 01/27/2017 Overtime 1,308.86 12,708.81 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,800.01 12,708.81 ** 29,500.00 Budgeted 16,791.19 Remaining 43 % Used Account: 135-50016-020-000 Longevity 6,635.00 .00 6,635.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,635.00 ** 6,635.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 753 01/27/2017 MUD P/R 01/27/2017 Certification 1,875.00 625.00 2,500.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 2,500.00 ** 7,800.00 Budgeted 5,300.00 Remaining 32 % Used Account: 135-50020-020-000 Retirement 673 01/13/2017 MUD P/R 01/03/2017 Retirement 9,239.21 1,591.97 10,831.18 PR 753 01/27/2017 MUD P/R 01/27/2017 Retirement 1,569.09 12,400.27 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,161.06 12,400.27 ** 39,584.00 Budgeted 27,183.73 Remaining 31 % Used Account: 135-50026-020-000 Medical Insurance 643 01/04/2017 Aetna Health Premium Jan (ACH) Adm fee credit when signed up 13,020.00 (276.29) 12,743.71 GL 673 01/13/2017 MUD P/R 01/03/2017 Medical Insurance 2,355.10 15,098.81 PR 753 01/27/2017 MUD P/R 01/27/2017 Medical Insurance 2,355.10 17,453.91 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,433.91 17,453.91 ** 73,022.00 Budgeted 55,568.09 Remaining 24 % Used Account: 135-50027-020-000 Dental Insurance 673 01/13/2017 MUD P/R 01/03/2017 Dental Insurance 870.44 199.69 1,070.13 PR 753 01/27/2017 MUD P/R 01/27/2017 Dental Insurance 199.63 1,269.76 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 1,269.76 ** 4,592.00 Budgeted 3,322.24 Remaining 28 % Used Account: 135-50028-020-000 Vision Insurance 673 01/13/2017 MUD P/R 01/03/2017 Vision Insurance 195.27 42.19 237.46 PR 753 01/27/2017 MUD P/R 01/27/2017 Vision Insurance 42.14 279.60 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 279.60 ** 1,031.00 Budgeted 751.40 Remaining 27 % Used Account: 135-50029-020-000 Life Insurance & Other 519 01/01/2017 Jan A/P Dental, Vision, LTD, ADD 1,070.46 356.76 1,427.22 METLIFE GROUP BENEFITS 2676 AP 772 01/30/2017 January AP Café 125 Admin Fee 27.13 1,454.35 BenefitMall 2802 AP 779 01/31/2017 January AP Misc ins/Feb 356.76 1,811.11 METLIFE GROUP BENEFITS 2833 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 740.65 1,811.11 ** 4,485.00 Budgeted 2,673.89 Remaining 40 % Used Account: 135-50030-020-000 Social Security Taxes 673 01/13/2017 MUD P/R 01/03/2017 Social Security Taxes 6,147.79 1,020.79 7,168.58 PR 753 01/27/2017 MUD P/R 01/27/2017 Social Security Taxes 977.13 8,145.71 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,997.92 8,145.71 ** 27,886.00 Budgeted 19,740.29 Remaining 29 % Used Account: 135-50035-020-000 Medicare Taxes 673 01/13/2017 MUD P/R 01/03/2017 Medicare Taxes 1,437.78 238.73 1,676.51 PR 753 01/27/2017 MUD P/R 01/27/2017 Medicare Taxes 228.52 1,905.03 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 467.25 1,905.03 ** 6,522.00 Budgeted 4,616.97 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 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 673 01/13/2017 MUD P/R 01/03/2017 Unemployment Taxes 326.99 326.99 PR 753 01/27/2017 MUD P/R 01/27/2017 Unemployment Taxes 322.29 649.28 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 649.28 649.28 ** 1,197.00 Budgeted 547.72 Remaining 54 % Used Account: 135-50045-020-000 Workman's Compensation 463 01/01/2017 Insurance/Wrk Comp Exp Jan 2,780.25 926.75 3,707.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 926.75 3,707.00 ** 11,347.00 Budgeted 7,640.00 Remaining 33 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations 830 01/26/2017 Jan A/P HARD 8 BBQ- ROANOKE 120.65 82.37 203.02 HARD 8 BBQ- ROANOKE PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 82.37 203.02 ** 650.00 Budgeted 446.98 Remaining 31 % Used Account: 135-55005-020-000 Engineering .00 .00 _______________ Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 713 01/18/2017 January AP Aeration blower work 7,779.12 1,010.26 8,789.38 WALKER ENGINEERING INC 2793 AP 713 01/18/2017 January AP Aeration blowers 500.00 9,289.38 WALKER ENGINEERING INC 2793 AP 713 01/18/2017 January AP Electrician Fixing Raw pump #1 2,087.58 11,376.96 WALKER ENGINEERING INC 2793 AP 772 01/30/2017 January AP Lab scale calibration 309.40 11,686.36 METTLER TOLEDO INTERNATIONAL 2834 AP 772 01/30/2017 January AP Meter Calibrations 1,219.50 12,905.86 Prime Controls, LP 2838 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55070-020-000 Independent Labor Totals: 5,126.74 12,905.86 ** 20,000.00 Budgeted 7,094.14 Remaining 65 % Used Account: 135-55080-020-000 Maintenance & Repairs 830 01/26/2017 Jan A/P XYLEM WATER SOLUTIONS 24,993.19 1,806.00 26,799.19 XYLEM WATER SOLUTIONS PC 830 01/26/2017 Jan A/P THE HOME DEPOT #6581 15.97 26,815.16 THE HOME DEPOT #6581 PC 830 01/26/2017 Jan A/P USA BLUE BOOK 447.34 27,262.50 USA BLUE BOOK PC 830 01/26/2017 Jan A/P USA BLUE BOOK 702.50 27,965.00 USA BLUE BOOK PC 830 01/26/2017 Jan A/P FUSECO DALLAS 42.27 28,007.27 FUSECO DALLAS PC 830 01/26/2017 Jan A/P ACADEMY SPORTS #81 23.98 28,031.25 ACADEMY SPORTS #81 PC 830 01/26/2017 Jan A/P THE HOME DEPOT #6581 13.32 28,044.57 THE HOME DEPOT #6581 PC 779 01/31/2017 January AP Fire Extinguisher inspection 231.50 28,276.07 KIMBROUGH FIRE EXTINQUISHER CO 2821 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 3,282.88 28,276.07 ** 83,100.00 Budgeted 54,823.93 Remaining 34 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 830 01/26/2017 Jan A/P MUSTANG ELITE CAR WASH 3,658.26 10.99 3,669.25 MUSTANG ELITE CAR WASH PC 830 01/26/2017 Jan A/P MUSTANG ELITE CAR 96.49 3,765.74 MUSTANG ELITE CAR PC 830 01/26/2017 Jan A/P AUTO TRUCK - FORT WORT 1,477.56 5,243.30 AUTO TRUCK - FORT WORT PC 830 01/26/2017 Jan A/P MUSTANG ELITE CAR WASH 15.99 5,259.29 MUSTANG ELITE CAR WASH PC 830 01/26/2017 Jan A/P MUSTANG ELITE CAR 96.49 5,355.78 MUSTANG ELITE CAR PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 1,697.52 5,355.78 ** 4,000.00 Budgeted (1,355.78) Remaining 134 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 23.94 .00 23.94 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 23.94 ** 500.00 Budgeted 476.06 Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55125-020-000 Dumpster Services 713 01/18/2017 January AP Sludge Haul Off 12,806.40 967.53 13,773.93 L.H. CHANEY MATERIALS, INC. 2783 AP 779 01/31/2017 January AP Sludge hual off 2,156.02 15,929.95 L.H. CHANEY MATERIALS, INC. 2823 AP 862 01/31/2017 Jan A/P Sludge Haul off 1,781.68 17,711.63 L.H. CHANEY MATERIALS, INC. 2857 AP 862 01/31/2017 Jan A/P Sludge Haul off 919.78 18,631.41 L.H. CHANEY MATERIALS, INC. 2857 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 5,825.01 18,631.41 ** 55,000.00 Budgeted 36,368.59 Remaining 34 % Used Account: 135-55135-020-000 Lab Analysis 668 01/11/2017 January AP testing supplies 6,659.00 176.00 6,835.00 OXIDOR LABORATORIES LLC 2763 AP 668 01/11/2017 January AP testing supplies 208.00 7,043.00 OXIDOR LABORATORIES LLC 2763 AP 713 01/18/2017 January AP Chemicals 176.00 7,219.00 OXIDOR LABORATORIES LLC 2789 AP 713 01/18/2017 January AP chemicals 246.00 7,465.00 OXIDOR LABORATORIES LLC 2789 AP 772 01/30/2017 January AP Lab Supplies 221.00 7,686.00 OXIDOR LABORATORIES LLC 2837 AP 772 01/30/2017 January AP Lab supplies 201.00 7,887.00 OXIDOR LABORATORIES LLC 2837 AP 772 01/30/2017 January AP Lab supplies 176.00 8,063.00 OXIDOR LABORATORIES LLC 2837 AP 772 01/30/2017 January AP Lab supplies 246.00 8,309.00 OXIDOR LABORATORIES LLC 2837 AP 862 01/31/2017 Jan A/P Testing 246.00 8,555.00 OXIDOR LABORATORIES LLC 2860 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,896.00 8,555.00 ** 25,000.00 Budgeted 16,445.00 Remaining 34 % Used Account: 135-60010-020-000 Communications/Mobiles 638 01/08/2017 Jan A/P PID Inverted Syphon Alarm moni 1,292.39 276.00 1,568.39 OMNISITE 2706 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 276.00 1,568.39 ** 5,400.00 Budgeted 3,831.61 Remaining 29 % Used Account: 135-60020-020-000 Electricity 713 01/18/2017 January AP Electricity 27,338.53 224.82 27,563.35 HUDSON ENERGY SERVICES, LLC 2782 AP 713 01/18/2017 January AP Electricity 12/09-1/10/17 1,441.64 29,004.99 ENGIE Resources LLC 2778 AP 724 01/19/2017 January AP Electricity 12/9-1/10/17 740.56 29,745.55 MP2 ENERGY TEXAS LLC 2787 AP 873 01/31/2017 Town Billed Jan AR 20170131-20170131 User: (539.19) 29,206.36 AR _______________ Account: 135-60020-020-000 Electricity Totals: 1,867.83 29,206.36 ** 158,627.00 Budgeted 129,420.64 Remaining 18 % Used Account: 135-60066-020-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 701 01/16/2017 Jan A/P Books for Training/Jason, Fran 143.85 143.85 City of Fort Worth Water Dept 2774 AP _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 143.85 143.85 ** 400.00 Budgeted 256.15 Remaining 36 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 830 01/26/2017 Jan A/P DELANYAS SMOKE PIT INC 1,095.00 24.25 1,119.25 DELANYAS SMOKE PIT INC PC 830 01/26/2017 Jan A/P WHATABURGER 754 Q26 62.16 1,181.41 WHATABURGER 754 Q26 PC 830 01/26/2017 Jan A/P FORTWORTHCATERING COM 38.35 1,219.76 FORTWORTHCATERING COM PC 830 01/26/2017 Jan A/P RAILHEAD SMOKEHOUSE 36.43 1,256.19 RAILHEAD SMOKEHOUSE PC 830 01/26/2017 Jan A/P DELANYAS SMOKE PIT INC 28.58 1,284.77 DELANYAS SMOKE PIT INC PC 830 01/26/2017 Jan A/P DICKEYS TX-064 30.85 1,315.62 DICKEYS TX-064 PC 830 01/26/2017 Jan A/P GALLIGASKIN S RESTAURA 36.74 1,352.36 GALLIGASKIN S RESTAURA PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 257.36 1,352.36 ** 4,195.00 Budgeted 2,842.64 Remaining 32 % Used Account: 135-60090-020-000 Safety Program 830 01/26/2017 Jan A/P WM SUPERCENTER #3274 142.19 3.97 146.16 WM SUPERCENTER #3274 PC _______________ Account: 135-60090-020-000 Safety Program Totals: 3.97 146.16 ** 550.00 Budgeted 403.84 Remaining 27 % Used Account: 135-60100-020-000 Travel & per diem 724 01/19/2017 January AP Tolls to lab 137.74 24.83 162.57 NTTA 2788 AP 753 01/27/2017 MUD P/R 01/27/2017 Travel & per diem 246.24 408.81 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 271.07 408.81 ** 1,600.00 Budgeted 1,191.19 Remaining 26 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ 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 4,086.37 .00 4,086.37 _______________ Account: 135-60125-020-000 Advertising Totals: .00 4,086.37 ** .00 Budgeted (4,086.37) Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 830 01/26/2017 Jan A/P TCEQ EPAYMENT 13,910.97 100.00 14,010.97 TCEQ EPAYMENT PC 830 01/26/2017 Jan A/P TCEQ EPAYMENT 111.00 14,121.97 TCEQ EPAYMENT PC 830 01/26/2017 Jan A/P TCEQ EPAYMENT 111.00 14,232.97 TCEQ EPAYMENT PC 830 01/26/2017 Jan A/P TCEQ EPAYMENT 111.00 14,343.97 TCEQ EPAYMENT PC _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 433.00 14,343.97 ** 17,150.00 Budgeted 2,806.03 Remaining 84 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 590.00 .00 590.00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 590.00 ** 6,621.00 Budgeted 6,031.00 Remaining 9 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 11,600.00 Budgeted 11,600.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 823 01/31/2017 Texpool Transfers 32,861.46 10,953.82 43,815.28 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,953.82 43,815.28 ** 120,492.00 Budgeted 76,676.72 Remaining 36 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 823 01/31/2017 Texpool Transfers 162,446.73 54,148.91 216,595.64 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,148.91 216,595.64 ** 595,638.00 Budgeted 379,042.36 Remaining 36 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 823 01/31/2017 Texpool Transfers 33,679.60 11,226.55 44,906.15 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 11,226.55 44,906.15 ** 123,492.00 Budgeted 78,585.85 Remaining 36 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 820 01/31/2017 January AP Fuel 1,834.77 707.77 2,542.54 US Bank Voyager Fleet Systems 2848 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 707.77 2,542.54 ** 28,088.00 Budgeted 25,545.46 Remaining 9 % Used Account: 135-65010-020-000 Uniforms 3,553.92 .00 3,553.92 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 3,553.92 ** 4,459.00 Budgeted 905.08 Remaining 80 % Used Account: 135-65030-020-000 Chemicals 9,777.29 .00 9,777.29 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65030-020-000 Chemicals Totals: .00 9,777.29 ** 25,000.00 Budgeted 15,222.71 Remaining 39 % Used Account: 135-65035-020-000 Small Tools 782.54 .00 782.54 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 782.54 ** 2,000.00 Budgeted 1,217.46 Remaining 39 % Used Account: 135-65040-020-000 Safety Equipment 49.83 .00 49.83 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 49.83 ** 750.00 Budgeted 700.17 Remaining 7 % Used Account: 135-65045-020-000 Lab Supplies 830 01/26/2017 Jan A/P WW GRAINGER 4,035.37 199.80 4,235.17 WW GRAINGER PC 830 01/26/2017 Jan A/P WW GRAINGER 99.90 4,335.07 WW GRAINGER PC 830 01/26/2017 Jan A/P 7-ELEVEN 32921 2.70 4,337.77 7-ELEVEN 32921 PC 830 01/26/2017 Jan A/P RANDALLS STORE00017897 6.97 4,344.74 RANDALLS STORE00017897 PC 772 01/30/2017 January AP Lab supplies 162.00 4,506.74 LOU'S GLOVES INCORPORATED 2829 AP 772 01/30/2017 January AP Lab dupplies 480.82 4,987.56 HACH COMPANY 2816 AP 772 01/30/2017 January AP Testing supplies 300.08 5,287.64 IDEXX DISTRIBUTION, INC 2817 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,252.27 5,287.64 ** 14,000.00 Budgeted 8,712.36 Remaining 38 % Used Account: 135-69005-020-000 Capital Outlays 668 01/11/2017 January AP Digester blower #2 Install 32,822.05 17,994.50 50,816.55 AIR MAC 2755 AP 819 01/31/2017 January AP Backhoe 82,288.17 133,104.72 RDO Construction Equipment Co 2840 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 100,282.67 133,104.72 ** 485,000.00 Budgeted 351,895.28 Remaining 27 % Used Department 20 Totals: ----------------------------------- 773,841.37 ** 246,769.75 Monthly Total 2,698,015.00 Budgeted 1,924,173.63 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2017 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-026-000 Workman's Compensation 463 01/01/2017 Insurance/Wrk Comp Exp Jan 7.83 2.61 10.44 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.61 10.44 ** 32.00 Budgeted 21.56 Remaining 33 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 832 01/31/2017 Jan A/P AWBD Mid Winter Conf/Wilson 1,125.00 435.00 1,560.00 AWBD 2801 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 435.00 1,560.00 ** 4,000.00 Budgeted 2,440.00 Remaining 39 % Used Account: 135-60100-026-000 Travel & per diem 779 01/31/2017 January AP AWBD Expense 453.16 453.16 Gregory Wilson 2814 AP 779 01/31/2017 January AP AWBD Expense 543.14 996.30 Jim Hase 2818 AP 779 01/31/2017 January AP AWBD Expense 407.56 1,403.86 William Rose 2851 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 1,403.86 1,403.86 ** 5,000.00 Budgeted 3,596.14 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: ----------------------------------- 2,974.30 ** 1,841.47 Monthly Total 12,882.00 Budgeted 9,907.70 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 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 673 01/13/2017 MUD P/R 01/03/2017 Salaries & Wages 84,198.75 15,382.44 99,581.19 PR 753 01/27/2017 MUD P/R 01/27/2017 Salaries & Wages 15,447.80 115,028.99 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 30,830.24 115,028.99 ** 519,883.00 Budgeted 404,854.01 Remaining 22 % Used Account: 135-50010-030-000 Overtime 673 01/13/2017 MUD P/R 01/03/2017 Overtime 600.82 120.08 720.90 PR 753 01/27/2017 MUD P/R 01/27/2017 Overtime 33.25 754.15 PR _______________ Account: 135-50010-030-000 Overtime Totals: 153.33 754.15 ** 1,000.00 Budgeted 245.85 Remaining 75 % Used Account: 135-50016-030-000 Longevity 3,417.50 .00 3,417.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,417.50 ** 3,890.00 Budgeted 472.50 Remaining 88 % Used Account: 135-50020-030-000 Retirement 673 01/13/2017 MUD P/R 01/03/2017 Retirement 7,463.91 1,433.99 8,897.90 PR 753 01/27/2017 MUD P/R 01/27/2017 Retirement 1,431.99 10,329.89 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,865.98 10,329.89 ** 47,768.00 Budgeted 37,438.11 Remaining 22 % Used Account: 135-50026-030-000 Medical Insurance 643 01/04/2017 Aetna Health Premium Jan (ACH) Adm fee credit when signed up 8,579.55 (276.36) 8,303.19 GL 673 01/13/2017 MUD P/R 01/03/2017 Medical Insurance 1,911.02 10,214.21 PR 753 01/27/2017 MUD P/R 01/27/2017 Medical Insurance 1,911.03 12,125.24 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,545.69 12,125.24 ** 84,289.00 Budgeted 72,163.76 Remaining 14 % Used Account: 135-50027-030-000 Dental Insurance 673 01/13/2017 MUD P/R 01/03/2017 Dental Insurance 638.36 174.48 812.84 PR 753 01/27/2017 MUD P/R 01/27/2017 Dental Insurance 174.42 987.26 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 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: 348.90 987.26 ** 5,981.00 Budgeted 4,993.74 Remaining 17 % Used Account: 135-50028-030-000 Vision Insurance 673 01/13/2017 MUD P/R 01/03/2017 Vision Insurance 134.93 37.94 172.87 PR 753 01/27/2017 MUD P/R 01/27/2017 Vision Insurance 37.88 210.75 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 75.82 210.75 ** 1,312.00 Budgeted 1,101.25 Remaining 16 % Used Account: 135-50029-030-000 Life Insurance & Other 519 01/01/2017 Jan A/P Dental, Vision, LTD, ADD 681.95 429.88 1,111.83 METLIFE GROUP BENEFITS 2676 AP 772 01/30/2017 January AP Café 125 Admin Fee 27.16 1,138.99 BenefitMall 2802 AP 779 01/31/2017 January AP Misc ins/Feb 351.06 1,490.05 METLIFE GROUP BENEFITS 2833 AP 835 01/31/2017 Jan A/P Rounding adjustment (.02) 1,490.03 Legal Shield 2825 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 808.08 1,490.03 ** 5,890.00 Budgeted 4,399.97 Remaining 25 % Used Account: 135-50030-030-000 Social Security Taxes 673 01/13/2017 MUD P/R 01/03/2017 Social Security Taxes 5,108.33 923.04 6,031.37 PR 753 01/27/2017 MUD P/R 01/27/2017 Social Security Taxes 910.29 6,941.66 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,833.33 6,941.66 ** 32,777.00 Budgeted 25,835.34 Remaining 21 % Used Account: 135-50035-030-000 Medicare Taxes 673 01/13/2017 MUD P/R 01/03/2017 Medicare Taxes 1,194.68 215.88 1,410.56 PR 753 01/27/2017 MUD P/R 01/27/2017 Medicare Taxes 212.88 1,623.44 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 428.76 1,623.44 ** 8,084.00 Budgeted 6,460.56 Remaining 20 % Used Account: 135-50040-030-000 Unemployment Taxes 673 01/13/2017 MUD P/R 01/03/2017 Unemployment Taxes 221.73 294.55 516.28 PR 753 01/27/2017 MUD P/R 01/27/2017 Unemployment Taxes 294.13 810.41 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 588.68 810.41 ** 1,368.00 Budgeted 557.59 Remaining 59 % Used Account: 135-50045-030-000 Workman's Compensation 463 01/01/2017 Insurance/Wrk Comp Exp Jan 436.59 145.53 582.12 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 145.53 582.12 ** 1,784.00 Budgeted 1,201.88 Remaining 33 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 862 01/31/2017 Jan A/P Pre-employment screening 153.90 40.00 193.90 Working Well 2861 AP 862 01/31/2017 Jan A/P Pre-employment screening 145.45 339.35 FIRST CHECK APPLICANT SCREENIN 2855 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 185.45 339.35 ** 500.00 Budgeted 160.65 Remaining 68 % Used Account: 135-50070-030-000 Employee Relations 830 01/26/2017 Jan A/P FLOWERS BY LEGACY 2,125.74 103.98 2,229.72 FLOWERS BY LEGACY PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 103.98 2,229.72 ** 4,960.00 Budgeted 2,730.28 Remaining 45 % Used Account: 135-55030-030-000 Software & Support 713 01/18/2017 January AP Microsoft Office 15,109.04 168.00 15,277.04 M3 Networks 2785 AP 713 01/18/2017 January AP Internet Service 1,120.77 16,397.81 WHOLESALE CARRIER SERVICES INC 2794 AP 830 01/26/2017 Jan A/P AT&T *PAYMENT 172.79 16,570.60 AT&T *PAYMENT PC 830 01/26/2017 Jan A/P ATT*BILL PAYMENT 150.14 16,720.74 ATT*BILL PAYMENT PC 830 01/26/2017 Jan A/P ATT*BILL PAYMENT 176.26 16,897.00 ATT*BILL PAYMENT PC 830 01/26/2017 Jan A/P ADOBE *IL CREATIVE CLD 19.99 16,916.99 ADOBE *IL CREATIVE CLD PC 772 01/30/2017 January AP Software 300.00 17,216.99 STW INC 2843 AP 772 01/30/2017 January AP Software-Annual lease 13,115.00 30,331.99 STW INC 2843 AP 875 01/31/2017 Jan A/P Document System 20,307.99 50,639.98 MCCI 2863 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 35,530.94 50,639.98 ** 67,791.00 Budgeted 17,151.02 Remaining 75 % Used Account: 135-55070-030-000 Independent Labor . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 596 01/04/2017 Void A/P Ck 2552/Cruz/Lost 715.00 (157.50) 557.50 MIGUEL CRUZ 2552 AP 596 01/04/2017 Void A/P Ck 2552/Cruz/Lost (82.50) 475.00 MIGUEL CRUZ 2552 AP 596 01/04/2017 Void A/P Ck 2552/Cruz/Lost (161.25) 313.75 MIGUEL CRUZ 2552 AP 596 01/04/2017 Void A/P Ck 2552/Cruz/Lost (78.75) 235.00 MIGUEL CRUZ 2552 AP 598 01/04/2017 Jan A/P Video MUD meeting 157.50 392.50 MIGUEL CRUZ 2690 AP 598 01/04/2017 Jan A/P Video MUD meeting 82.50 475.00 MIGUEL CRUZ 2690 AP 598 01/04/2017 Jan A/P Video MUD meeting 161.25 636.25 MIGUEL CRUZ 2690 AP 598 01/04/2017 Jan A/P Video MUD meeting 78.75 715.00 MIGUEL CRUZ 2690 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 715.00 ** 12,000.00 Budgeted 11,285.00 Remaining 6 % Used Account: 135-55080-030-000 Maintenance & Repairs 275.00 .00 275.00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 275.00 ** 7,000.00 Budgeted 6,725.00 Remaining 4 % Used Account: 135-55085-030-000 Generator Maint. and Repair 715 01/18/2017 January AP MUD building generator 485.00 485.00 Sluder Emergency Power Service 2790 AP _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: 485.00 485.00 ** 10,000.00 Budgeted 9,515.00 Remaining 5 % Used Account: 135-55100-030-000 Building Maint & Supplies 830 01/26/2017 Jan A/P THE HOME DEPOT #6581 3,435.46 149.00 3,584.46 THE HOME DEPOT #6581 PC 793 01/31/2017 January A/P Rug service 130.89 3,715.35 G & K SERVICES 2813 AP 793 01/31/2017 January A/P Rug service 130.89 3,846.24 G & K SERVICES 2813 AP 793 01/31/2017 January A/P Rug service 130.89 3,977.13 G & K SERVICES 2813 AP 873 01/31/2017 Town Billed Jan AR 20170131-20170131 User: (196.33) 3,780.80 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 345.34 3,780.80 ** 7,000.00 Budgeted 3,219.20 Remaining 54 % Used Account: 135-55120-030-000 Cleaning Services 713 01/18/2017 January AP Janitorial Service 1,243.12 869.06 2,112.18 MEMBER'S BUILDING MAINTENANCE 2786 AP 873 01/31/2017 Town Billed Jan AR 20170131-20170131 User: (236.00) 1,876.18 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 1,876.18 ** 10,429.00 Budgeted 8,552.82 Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55160-030-000 Professional Outside Services 57,332.00 .00 57,332.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 57,332.00 ** 63,325.00 Budgeted 5,993.00 Remaining 91 % 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 862 01/31/2017 Jan A/P January Utility Billing 2,372.64 248.20 2,620.84 DATAPROSE LLC 2854 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 248.20 2,620.84 ** 8,200.00 Budgeted 5,579.16 Remaining 32 % Used Account: 135-60005-030-000 Telephone 830 01/26/2017 Jan A/P ATT*BUS PHONE PMT 3,775.42 441.04 4,216.46 ATT*BUS PHONE PMT PC 830 01/26/2017 Jan A/P RINGCENTRAL, INC 13.95 4,230.41 RINGCENTRAL, INC PC 793 01/31/2017 January A/P Answering service 195.25 4,425.66 KEYSTONE PARK SECRETARIAL 2820 AP _______________ Account: 135-60005-030-000 Telephone Totals: 650.24 4,425.66 ** 17,532.00 Budgeted 13,106.34 Remaining 25 % Used Account: 135-60010-030-000 Communications/Mobiles 753 01/27/2017 MUD P/R 01/27/2017 Communications/Mobiles 638.97 225.00 863.97 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 225.00 863.97 ** 4,150.00 Budgeted 3,286.03 Remaining 21 % Used Account: 135-60020-030-000 Electricity/Gas 882.09 .00 882.09 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 882.09 ** 12,631.00 Budgeted 11,748.91 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60025-030-000 Water 793 01/31/2017 January A/P Water-january 438.67 175.55 614.22 TROPHY CLUB MUD (WATER BILLS) 2846 AP 873 01/31/2017 Town Billed Jan AR 20170131-20170131 User: (87.77) 526.45 AR _______________ Account: 135-60025-030-000 Water Totals: 87.78 526.45 ** 1,500.00 Budgeted 973.55 Remaining 35 % Used Account: 135-60035-030-000 Postage 647 01/09/2017 Jan A/P Postage for meter 8,271.19 1,500.00 9,771.19 U.S. Postal Service (CMRS-FP) 2753 AP 772 01/30/2017 January AP Postage Machine Rental 90.00 9,861.19 FRANCOTYP-POSTALIA, INC. 2812 AP 793 01/31/2017 January A/P Audit to TCEQ 5.55 9,866.74 FEDERAL EXPRESS CORP 2807 AP 862 01/31/2017 Jan A/P January Utility Billing 166.06 10,032.80 DATAPROSE LLC 2854 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,761.61 10,032.80 ** 28,932.00 Budgeted 18,899.20 Remaining 35 % Used Account: 135-60040-030-000 Service Charges & Fees 824 01/03/2017 Credit Card Fees 13,383.92 141.01 13,524.93 GL 824 01/03/2017 Credit Card Fees 4,225.41 17,750.34 GL 676 01/13/2017 Child Support Fee 1.50 17,751.84 GL 754 01/27/2017 Child Support Fee 1.50 17,753.34 GL 793 01/31/2017 January A/P Direct send fees 50.00 17,803.34 Fiserv Solutions, LLC 2808 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,419.42 17,803.34 ** 55,560.00 Budgeted 37,756.66 Remaining 32 % Used Account: 135-60050-030-000 Bad Debt Expense 789 01/03/2017 UB 1/3/17 Write Offs UB20170103-20170103 User: 526.88 526.88 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 526.88 526.88 ** 3,500.00 Budgeted 2,973.12 Remaining 15 % Used Account: 135-60055-030-000 Insurance 463 01/01/2017 Insurance/Wrk Comp Exp Jan 13,993.68 4,664.56 18,658.24 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,664.56 18,658.24 ** 55,692.00 Budgeted 37,033.76 Remaining 34 % Used Account: 135-60066-030-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 830 01/26/2017 Jan A/P AMAZON MKTPLACE PMTS 50.88 50.88 AMAZON MKTPLACE PMTS PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 50.88 50.88 ** 1,600.00 Budgeted 1,549.12 Remaining 3 % Used Account: 135-60070-030-000 Dues & Memberships 713 01/18/2017 January AP Annual membership dues-2017 3,756.25 580.00 4,336.25 AWBD 2776 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 580.00 4,336.25 ** 6,000.00 Budgeted 1,663.75 Remaining 72 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education 51.65 .00 51.65 _______________ Account: 135-60079-030-000 Public Education Totals: .00 51.65 ** 8,754.00 Budgeted 8,702.35 Remaining 1 % Used Account: 135-60080-030-000 Schools & Training .00 .00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 .00 ** 7,840.00 Budgeted 7,840.00 Remaining 0 % Used Account: 135-60100-030-000 Travel & per diem 647 01/09/2017 Jan A/P Airfare GM Position 179.78 489.58 669.36 Darrell Gentry 2745 AP 647 01/09/2017 Jan A/P Rental car 59.50 728.86 Darrell Gentry 2745 AP 684 01/12/2017 Jan A/P Airfare-GM Position 194.35 923.21 Shane Jeff 2764 AP 684 01/12/2017 Jan A/P Car Rental-GM Position 139.83 1,063.04 Shane Jeff 2764 AP 673 01/13/2017 MUD P/R 01/03/2017 Travel & per diem 108.06 1,171.10 PR 830 01/26/2017 Jan A/P HOMEWOOD SUITES 181.54 1,352.64 HOMEWOOD SUITES PC 753 01/27/2017 MUD P/R 01/27/2017 Travel & per diem 48.60 1,401.24 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-030-000 Travel & per diem Totals: 1,221.46 1,401.24 ** 5,400.00 Budgeted 3,998.76 Remaining 26 % 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 .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 950.09 .00 950.09 _______________ Account: 135-60125-030-000 Advertising Totals: .00 950.09 ** 7,500.00 Budgeted 6,549.91 Remaining 13 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 17,500.00 Budgeted 17,500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1,040.00 .00 1,040.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 1,040.00 ** 2,500.00 Budgeted 1,460.00 Remaining 42 % Used Account: 135-65010-030-000 Uniforms 142.36 .00 142.36 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 142.36 ** 1,855.00 Budgeted 1,712.64 Remaining 8 % Used Account: 135-65055-030-000 Hardware 2,239.88 .00 2,239.88 _______________ Account: 135-65055-030-000 Hardware Totals: .00 2,239.88 ** 9,444.00 Budgeted 7,204.12 Remaining 24 % Used Account: 135-65085-030-000 Office Supplies 830 01/26/2017 Jan A/P STAPLES 00116533 1,664.63 49.98 1,714.61 STAPLES 00116533 PC 830 01/26/2017 Jan A/P STAPLES DIRECT 23.78 1,738.39 STAPLES DIRECT PC 779 01/31/2017 January AP Office supplies 104.38 1,842.77 OFFICE DEPOT, INC 2836 AP 779 01/31/2017 January AP Office supplies 39.98 1,882.75 OFFICE DEPOT, INC 2836 AP 779 01/31/2017 January AP Office supplies 28.99 1,911.74 OFFICE DEPOT, INC 2836 AP 862 01/31/2017 Jan A/P Office Supplies 188.46 2,100.20 OFFICE DEPOT, INC 2859 AP 862 01/31/2017 Jan A/P Office Supplies 32.99 2,133.19 OFFICE DEPOT, INC 2859 AP 862 01/31/2017 Jan A/P Office Supplies Credit (39.98) 2,093.21 OFFICE DEPOT, INC 2859 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 428.58 2,093.21 ** 9,000.00 Budgeted 6,906.79 Remaining 23 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 830 01/26/2017 Jan A/P WAL-MART #5247 813.14 40.28 853.42 WAL-MART #5247 PC 830 01/26/2017 Jan A/P AMAZON.COM 49.41 902.83 AMAZON.COM PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 830 01/26/2017 Jan A/P SAMS CLUB #4795 813.14 31.28 934.11 SAMS CLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 120.97 934.11 ** 5,000.00 Budgeted 4,065.89 Remaining 19 % Used Account: 135-65105-030-000 Printing 123.00 .00 123.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 123.00 ** 4,800.00 Budgeted 4,677.00 Remaining 3 % Used Account: 135-69005-030-000 Capital Outlays 8,695.45 .00 8,695.45 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 8,695.45 ** 107,001.00 Budgeted 98,305.55 Remaining 8 % Used Account: 135-69170-030-000 Copier Lease Installments 713 01/18/2017 January AP Kyocera Lease 622.23 388.00 1,010.23 EVERBANK COMMERCIAL FINANCE 2779 AP 772 01/30/2017 January AP Copies 64.27 1,074.50 KYOCERA DOCUMENT SOLUTIONS 2822 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 452.27 1,074.50 ** 4,600.00 Budgeted 3,525.50 Remaining 23 % Used Department 30 Totals: ----------------------------------- 351,447.36 ** 94,345.96 Monthly Total 1,295,172.00 Budgeted 943,724.64 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2017 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 707 01/17/2017 Oct-Dec A/P General Legal/Oct 1,770.93 3,510.00 5,280.93 THE LISTON LAW FIRM, P.C. 2775 AP 707 01/17/2017 Oct-Dec A/P Litigation/Oct 5,767.50 11,048.43 THE LISTON LAW FIRM, P.C. 2775 AP 707 01/17/2017 Oct-Dec A/P PUC/Oct 300.00 11,348.43 THE LISTON LAW FIRM, P.C. 2775 AP 707 01/17/2017 Oct-Dec A/P General Legal/Nov 3,210.00 14,558.43 THE LISTON LAW FIRM, P.C. 2775 AP 707 01/17/2017 Oct-Dec A/P Litigation/Nov 3,375.00 17,933.43 THE LISTON LAW FIRM, P.C. 2775 AP 707 01/17/2017 Oct-Dec A/P Dec Legal/General 4,560.00 22,493.43 THE LISTON LAW FIRM, P.C. 2775 AP 707 01/17/2017 Oct-Dec A/P Dec Legal/PUC 1,050.00 23,543.43 THE LISTON LAW FIRM, P.C. 2775 AP 793 01/31/2017 January A/P Legal/Jan 9,250.00 32,793.43 THE LISTON LAW FIRM, P.C. 2844 AP _______________ Account: 135-55045-039-000 Legal Totals: 31,022.50 32,793.43 ** 150,000.00 Budgeted 117,206.57 Remaining 22 % Used Account: 135-55055-039-000 Auditing 772 01/30/2017 January AP Audit FYE 2016 18,808.92 18,808.92 LAFOLLETT & ABBOTT PLLC 2824 AP _______________ Account: 135-55055-039-000 Auditing Totals: 18,808.92 18,808.92 ** 23,860.00 Budgeted 5,051.08 Remaining 79 % Used Account: 135-55060-039-000 Appraisal 4,575.71 .00 4,575.71 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,575.71 ** 11,115.00 Budgeted 6,539.29 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 2,561.76 .00 2,561.76 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,561.76 ** 3,800.00 Budgeted 1,238.24 Remaining 67 % Used Department 39 Totals: ----------------------------------- 58,739.82 ** 49,831.42 Monthly Total 188,775.00 Budgeted 130,035.18 Remaining 31 % Used Fund 135 Totals: ----------------------------------- 142,330.74 166,370.85 Monthly Total (13,456.00) Budgeted (155,786.74) Remaining ########## . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 1/2017 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 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (156,420.00) .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET JANUARY 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 3,356,826 ACCOUNTS RECEIVABLE - TOTAL ASSETS 3,356,826 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,391,204 NET REVENUES / EXPENDITURES (1,034,378) TOTAL FUND BALANCE 3,356,826 TOTAL LIABILITIES AND FUND BALANCE 3,356,826 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 11:03 02/10/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,693.40- 6,249.11- 6,249.11 Subtotal: 1,693.40- 6,249.11- 6,249.11 Program number: 1,693.40- 6,249.11- 6,249.11 Department number: Revenues 1,693.40- 6,249.11- 6,249.11 Revenues Subtotal ----------- 1,693.40- 6,249.11- 6,249.11 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 11:03 02/10/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 1,040,627.82 1,040,627.82- Subtotal: 1,040,627.82 1,040,627.82- Program number: 1,040,627.82 1,040,627.82- Department number: Wastewater 1,040,627.82 1,040,627.82- Expenditures Subtotal ----------- 1,040,627.82 1,040,627.82- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,693.40- 1,034,378.71 1,034,378.71- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2017 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 899 01/31/2017 Bank Statement Interest/Jan (4,555.71) (1,693.40) (6,249.11) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,693.40) (6,249.11) ** .00 Budgeted 6,249.11 Remaining 0 % Used Department Totals: ----------------------------------- (6,249.11) ** (1,693.40) Monthly Total .00 Budgeted 6,249.11 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 1,040,627.82 .00 1,040,627.82 _______________ Account: 517-69005-020-000 Capital Outlays Totals: .00 1,040,627.82 ** .00 Budgeted (1,040,627.82) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,040,627.82 ** .00 Monthly Total .00 Budgeted (1,040,627.82) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,034,378.71 (1,693.40) Monthly Total .00 Budgeted (1,034,378.71) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET JANUARY 2017 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 691,249 TOTAL LIABILITIES 691,249 FUND BALANCE ASSIGNED FUND BALANCE 41,831 NET REVENUES / EXPENDITURES (733,080) TOTAL FUND BALANCE (691,249) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 11:03 02/10/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 590.72- 590.72 Subtotal: 590.72- 590.72 Program number: 590.72- 590.72 Department number: Revenues 590.72- 590.72 Revenues Subtotal ----------- 590.72- 590.72 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 11:03 02/10/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 733,670.38 733,670.38- Subtotal: 733,670.38 733,670.38- Program number: 733,670.38 733,670.38- Department number: Wastewater 733,670.38 733,670.38- Expenditures Subtotal ----------- 733,670.38 733,670.38- Fund number: 518 2015 Revenue Bond Const Fund 733,079.66 733,079.66- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 1/2017 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 (590.72) .00 (590.72) _______________ Account: 518-49010-000-000 Interest Income Totals: .00 (590.72) ** .00 Budgeted 590.72 Remaining 0 % Used Department Totals: ----------------------------------- (590.72) ** .00 Monthly Total .00 Budgeted 590.72 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 1/2017 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 733,670.38 .00 733,670.38 _______________ Account: 518-69005-020-000 Capital Outlays Totals: .00 733,670.38 ** .00 Budgeted (733,670.38) Remaining 0 % Used Department 20 Totals: ----------------------------------- 733,670.38 ** .00 Monthly Total .00 Budgeted (733,670.38) Remaining 0 % Used Fund 518 Totals: ----------------------------------- 733,079.66 .00 Monthly Total .00 Budgeted (733,079.66) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JANUARY 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 240,982 ACCOUNTS RECEIVABLE - TOTAL ASSETS 240,982 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 45,220 TOTAL FUND BALANCE 240,982 TOTAL LIABILITIES AND FUND BALANCE 240,982 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 11:03 02/10/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 300.00- 300.00- 105.20- 313.95- 104.650 13.95 528-49142-000-000 Interfund transfer in-Water 64,920.00- 64,920.00- 64,920.00- 528-49143-000-000 Interfund transfer in-WW 123,492.00- 123,492.00- 11,226.55- 44,906.15- 36.364 78,585.85- Subtotal: 188,712.00- 188,712.00- 11,331.75- 45,220.10- 23.962 143,491.90- Program number: 188,712.00- 188,712.00- 11,331.75- 45,220.10- 23.962 143,491.90- Department number: 188,712.00- 188,712.00- 11,331.75- 45,220.10- 23.962 143,491.90- Revenues Subtotal ----------- 188,712.00- 188,712.00- 11,331.75- 45,220.10- 23.962 143,491.90- Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 11,331.75- 45,220.10- 23.962 143,491.90- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/2017 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 899 01/31/2017 Bank Statement Interest/Jan (208.75) (105.20) (313.95) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (105.20) (313.95) ** (300.00) Budgeted 13.95 Remaining 105 % Used Account: 528-49142-000-000 Interfund transfer in-Water .00 .00 _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: .00 .00 ** (64,920.00) Budgeted (64,920.00) Remaining 0 % Used Account: 528-49143-000-000 Interfund transfer in-WW 823 01/31/2017 Texpool Transfers (33,679.60) (11,226.55) (44,906.15) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (11,226.55) (44,906.15) ** (123,492.00) Budgeted (78,585.85) Remaining 36 % Used Department Totals: ----------------------------------- (45,220.10) ** (11,331.75) Monthly Total (188,712.00) Budgeted (143,491.90) Remaining 24 % Used Fund 528 Totals: ----------------------------------- (45,220.10) (11,331.75) Monthly Total (188,712.00) Budgeted (143,491.90) Remaining 24 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND RESERVE BALANCE SHEET JANUARY 2017 529 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 57,470 ACCOUNTS RECEIVABLE - TOTAL ASSETS 57,470 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 57,470 TOTAL FUND BALANCE 57,470 TOTAL LIABILITIES AND FUND BALANCE 57,470 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 11:03 02/10/17 Budget Summary with Amendment Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 529-49010-000-000 Interest Income 19.90- 26.19- 26.19 529-49142-000-000 Interfund transfer in-Water 14,361.00- 57,444.00- 57,444.00 Subtotal: 14,380.90- 57,470.19- 57,470.19 Program number: 14,380.90- 57,470.19- 57,470.19 Department number: 14,380.90- 57,470.19- 57,470.19 Revenues Subtotal ----------- 14,380.90- 57,470.19- 57,470.19 Fund number: 529 2016 Rev Bond Reserve-SWIFT 14,380.90- 57,470.19- 57,470.19 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 529-49010-000-000 Interest Income 899 01/31/2017 Bank Statement Interest/Jan (6.29) (19.90) (26.19) GL _______________ Account: 529-49010-000-000 Interest Income Totals: (19.90) (26.19) ** .00 Budgeted 26.19 Remaining 0 % Used Account: 529-49142-000-000 Interfund transfer in-Water 823 01/31/2017 Texpool Transfers (43,083.00) (14,361.00) (57,444.00) GL _______________ Account: 529-49142-000-000 Interfund transfer in-Water Totals: (14,361.00) (57,444.00) ** .00 Budgeted 57,444.00 Remaining 0 % Used Department Totals: ----------------------------------- (57,470.19) ** (14,380.90) Monthly Total .00 Budgeted 57,470.19 Remaining 0 % Used Fund 529 Totals: ----------------------------------- (57,470.19) (14,380.90) Monthly Total .00 Budgeted 57,470.19 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JANUARY 2017 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 644,736 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 110,049 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 759,631 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 110,049 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 110,049 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 623,551 TOTAL FUND BALANCE 649,582 TOTAL LIABILITIES AND FUND BALANCE 759,631 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 11:03 02/10/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 673,336.00- 673,336.00- 323,851.49- 578,322.49- 85.889 95,013.51- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 3.70- 906.28- 25.886 2,594.72- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 1.18- 227.35- 11.368 1,772.65- Subtotal: 678,837.00- 678,837.00- 323,856.37- 579,456.12- 85.360 99,380.88- 533-49010-000-000 Interest Income 140.00- 140.00- 210.67- 279.65- 199.750 139.65 533-49015-000-000 Lease/Rental Income 216,754.00- 216,754.00- 216,754.00- 533-49141-000-000 Interfund Trans In-PID Surchg 120,492.00- 120,492.00- 10,953.82- 43,815.28- 36.364 76,676.72- Subtotal: 337,386.00- 337,386.00- 11,164.49- 44,094.93- 13.070 293,291.07- Program number: 1,016,223.00- 1,016,223.00- 335,020.86- 623,551.05- 61.360 392,671.95- Department number: Revenues 1,016,223.00- 1,016,223.00- 335,020.86- 623,551.05- 61.360 392,671.95- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 335,020.86- 623,551.05- 61.360 392,671.95- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 11:03 02/10/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2017 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 2,550.00 533-70025-051-000 Bond Interest Expense-Tax 300,583.00 300,583.00 300,583.00 533-70035-051-000 Bond Principal Payment-Tax 710,000.00 710,000.00 710,000.00 Subtotal: 1,013,133.00 1,013,133.00 1,013,133.00 Program number: 1,013,133.00 1,013,133.00 1,013,133.00 Department number: Administration 1,013,133.00 1,013,133.00 1,013,133.00 Expenditures Subtotal ----------- 1,013,133.00 1,013,133.00 1,013,133.00 Fund number: 533 MUD 1 I&S Consolidated 3,090.00- 3,090.00- 335,020.86- 623,551.05- ############### 620,461.05 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2017 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 844 01/03/2017 Property Taxes (254,471.00) (66,820.38) (321,291.38) GL 845 01/04/2017 Property Taxes (3,723.11) (325,014.49) GL 846 01/06/2017 Property Taxes (25,900.96) (350,915.45) GL 847 01/06/2017 Property Taxes (3,518.54) (354,433.99) GL 888 01/06/2017 Reverse JE846/Property Taxes 25,900.96 (328,533.03) GL 889 01/06/2017 Property Taxes (25,900.96) (354,433.99) GL 848 01/07/2017 Property Taxes (6,368.71) (360,802.70) GL 849 01/09/2017 Property Taxes (1,617.69) (362,420.39) GL 850 01/10/2017 Property Taxes (18,336.73) (380,757.12) GL 887 01/10/2017 Reverse JE850/Property Taxes 18,336.73 (362,420.39) GL 890 01/10/2017 Property Taxes (18,336.73) (380,757.12) GL 851 01/11/2017 Property Taxes (69,890.95) (450,648.07) GL 886 01/11/2017 Reverse JE851/Property Taxes 69,890.95 (380,757.12) GL 891 01/11/2017 Property Taxes (69,890.95) (450,648.07) GL 852 01/12/2017 Property Taxes (13,565.46) (464,213.53) GL 885 01/12/2017 Reverse JE852/Property Taxes 13,565.46 (450,648.07) GL 892 01/12/2017 Property Taxes (13,565.46) (464,213.53) GL 853 01/13/2017 Property Taxes (7,584.58) (471,798.11) GL 854 01/17/2017 Property Taxes (7,190.34) (478,988.45) GL 855 01/18/2017 Property Taxes (1,516.53) (480,504.98) GL 856 01/19/2017 Property Taxes (6,907.21) (487,412.19) GL 857 01/20/2017 Property Taxes (7,211.90) (494,624.09) GL 882 01/20/2017 Reverse JE857/Property Taxes 7,211.90 (487,412.19) GL 893 01/20/2017 Property Taxes (7,211.90) (494,624.09) GL 858 01/21/2017 Property Taxes (3,511.26) (498,135.35) GL 894 01/21/2017 Property Taxes (3,511.26) (501,646.61) GL 896 01/21/2017 Reverse JE858/Property Taxes 3,511.26 (498,135.35) GL 859 01/23/2017 Property Taxes (3,961.15) (502,096.50) GL 860 01/24/2017 Property Taxes (12,028.14) (514,124.64) GL 861 01/25/2017 Property Taxes (6,172.01) (520,296.65) GL 863 01/26/2017 Property Taxes (6,351.26) (526,647.91) GL 866 01/27/2017 Property Taxes (36,447.24) (563,095.15) GL 867 01/28/2017 Property Taxes (1,035.34) (564,130.49) GL 869 01/30/2017 Property Taxes (10,264.40) (574,394.89) GL 870 01/31/2017 Property Taxes (3,927.60) (578,322.49) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (323,851.49) (578,322.49) ** (673,336.00) Budgeted (95,013.51) Remaining 86 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 844 01/03/2017 Property Taxes (902.58) (3.70) (906.28) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (3.70) (906.28) ** (3,501.00) Budgeted (2,594.72) Remaining 26 % Used Account: 533-40015-000-000 Property Taxes/P & I 844 01/03/2017 Property Taxes (226.17) (1.18) (227.35) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (1.18) (227.35) ** (2,000.00) Budgeted (1,772.65) Remaining 11 % Used Account: 533-49010-000-000 Interest Income 899 01/31/2017 Bank Statement Interest/Jan (68.98) (210.67) (279.65) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (210.67) (279.65) ** (140.00) Budgeted 139.65 Remaining 200 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (216,754.00) Budgeted (216,754.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 823 01/31/2017 Texpool Transfers (32,861.46) (10,953.82) (43,815.28) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,953.82) (43,815.28) ** (120,492.00) Budgeted (76,676.72) Remaining 36 % Used Department Totals: ----------------------------------- (623,551.05) ** (335,020.86) Monthly Total (1,016,223.00) Budgeted (392,671.95) Remaining 61 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/2017 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 .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,550.00 Budgeted 2,550.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 300,583.00 Budgeted 300,583.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 710,000.00 Budgeted 710,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 1,013,133.00 Budgeted 1,013,133.00 Remaining 0 % Used Fund 533 Totals: ----------------------------------- (623,551.05) (335,020.86) Monthly Total (3,090.00) Budgeted 620,461.05 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JANUARY 2017 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 231,815 ACCOUNTS RECEIVABLE - TOTAL ASSETS 231,815 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 216,718 TOTAL FUND BALANCE 231,815 TOTAL LIABILITIES AND FUND BALANCE 231,815 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 11:03 02/10/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 200.00- 200.00- 82.02- 121.57- 60.785 78.43- 534-49142-000-000 Interfund Tran In-Water Sales 297,011.00- 297,011.00- 297,011.00- 534-49143-000-000 Interfund Transfer In-WW Sales 595,638.00- 595,638.00- 54,148.91- 216,595.64- 36.364 379,042.36- Subtotal: 892,849.00- 892,849.00- 54,230.93- 216,717.21- 24.273 676,131.79- Program number: 892,849.00- 892,849.00- 54,230.93- 216,717.21- 24.273 676,131.79- Department number: Revenues 892,849.00- 892,849.00- 54,230.93- 216,717.21- 24.273 676,131.79- Revenues Subtotal ----------- 892,849.00- 892,849.00- 54,230.93- 216,717.21- 24.273 676,131.79- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 11:03 02/10/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 387,649.00 387,649.00 387,649.00 534-70045-051-000 Revenue Bond Principal Expense 505,000.00 505,000.00 505,000.00 Subtotal: 892,649.00 892,649.00 892,649.00 Program number: 892,649.00 892,649.00 892,649.00 Department number: Administration 892,649.00 892,649.00 892,649.00 Expenditures Subtotal ----------- 892,649.00 892,649.00 892,649.00 Fund number: 534 2015 Revenue Bond I&S 200.00- 200.00- 54,230.93- 216,717.21- ############### 216,517.21 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 1/2017 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 899 01/31/2017 Bank Statement Interest/Jan (39.55) (82.02) (121.57) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (82.02) (121.57) ** (200.00) Budgeted (78.43) Remaining 61 % Used Account: 534-49142-000-000 Interfund Tran In-Water Sales .00 .00 _______________ Account: 534-49142-000-000 Interfund Tran In-Water Sales Totals: .00 .00 ** (297,011.00) Budgeted (297,011.00) Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 823 01/31/2017 Texpool Transfers (162,446.73) (54,148.91) (216,595.64) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,148.91) (216,595.64) ** (595,638.00) Budgeted (379,042.36) Remaining 36 % Used Department Totals: ----------------------------------- (216,717.21) ** (54,230.93) Monthly Total (892,849.00) Budgeted (676,131.79) Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 1/2017 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 .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 387,649.00 Budgeted 387,649.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 505,000.00 Budgeted 505,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 892,649.00 Budgeted 892,649.00 Remaining 0 % Used Fund 534 Totals: ----------------------------------- (216,717.21) (54,230.93) Monthly Total (200.00) Budgeted 216,517.21 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JANUARY 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 87,611 ACCOUNTS RECEIVABLE - TOTAL ASSETS 87,611 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 87,611 TOTAL FUND BALANCE 87,611 TOTAL LIABILITIES AND FUND BALANCE 87,611 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 11:03 02/10/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 1/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 30.36- 39.94- 39.94 535-49142-000-000 Interfund Tran In-Water Sales 21,892.88- 87,571.49- 87,571.49 Subtotal: 21,923.24- 87,611.43- 87,611.43 Program number: 21,923.24- 87,611.43- 87,611.43 Department number: Revenues 21,923.24- 87,611.43- 87,611.43 Revenues Subtotal ----------- 21,923.24- 87,611.43- 87,611.43 Fund number: 535 2016 Rev Bond I&S-SWIFT 21,923.24- 87,611.43- 87,611.43 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 11:04 02/10/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 1/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 899 01/31/2017 Bank Statement Interest/Jan (9.58) (30.36) (39.94) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (30.36) (39.94) ** .00 Budgeted 39.94 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 823 01/31/2017 Texpool Transfers (65,678.61) (21,892.88) (87,571.49) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (21,892.88) (87,571.49) ** .00 Budgeted 87,571.49 Remaining 0 % Used Department Totals: ----------------------------------- (87,611.43) ** (21,923.24) Monthly Total .00 Budgeted 87,611.43 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (87,611.43) (21,923.24) Monthly Total .00 Budgeted 87,611.43 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 245,489.13 **** (720,159.32) Monthly Total (205,458.00) Budgeted (450,947.13) Remaining ########## ******* End of Report *********