Loading...
HomeMy WebLinkAbout2018-11 November Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2018 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 122 FIRE DEPT. 56,204 279,877 14,912 1,059,358 TOTAL ASSETS 1,410,351 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 1,059,358 1,059,358 543,884 (192,890) 350,993 1,410,351 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 122-40010-000-000 1 122-40011-000-000 1 122-40020-000-000 Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&i Trophy Club MUD No.1 Page 1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 11/2018 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 56,976.59- 228.38- 88.95- 74,234.73- 502.41- 127.96- 6.646 1,042,765.27- 502.41 127.96 Subtotal: 1,117,000.00- 1,117,000.00- 57,293.92- 74,865.10- 6.702 1,042,134.90- 122-49035-000-000 Prior Year Reserves 75,000.00- 75,000.00- 75,000.00 - Subtotal: 75,000.00- 75,000.00- 75,000.00 - Program number: 1,192,000.00- 1,192,000.00- 57,293.92- 74,865.10- 6.281 1,117,134.90 - Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 57,293.92- 74,865.10- 6.281 1,117,134.90 - Revenues Subtotal 1,192,000.00- 1,192,000.00- 57,293.92- 74,865.10- 6.281 1,117,134.90- glbase_tbam skrolczyk 17:08 12/12/18 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 1 122-60030-045-000 1 122-60055-045-000 1 122-60337-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Program: Period Ending: 11/2018 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 215,979.00 18,000.00 215,979.00 18,000.00 1,491.21 2,982.42 56,204.00 16.569 215,979.00 15,017.58 56,204.00 - Page 2 Subtotal: 233,979.00 233,979.00 1,491.21 59,186.42 25.296 174,792.58 122-69005-045-000 1 122-69195-045-000 Capital Outlays GASB34/Reserve for Replacement 75,000.00 81,420.00 75,000.00 81,420.00 81,420.00 100.000 75,000.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 283,569.00 283,569.00 208,568.60 73.551 75,000.40 Program number: 517,548.00 517,548.00 1,491.21 267,755.02 51.735 249,792.98 Department number: Fire 517,548.00 517,548.00 1,491.21 267,755.02 51.735 249,792.98 Expenditures Subtotal 517,548.00 517,548.00 1,491.21 267,755.02 51.735 249,792.98 Fund number: 122 Trophy Club MUD Fire Dept. 674,452.00- 674,452.00- 55,802.71- 192,889.92 -28.600 867,341.92- glpdatb2 skrolczyk Trophy Club MUD No.1 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 1 Check Source Number Account: 122-40010-000-000 Property Taxes/MUD Fire 342 11/01/2018 Property Taxes 343 11/02/2018 Property Taxes 344 11/05/2018 Property Taxes 345 11/06/2018 Property Taxes 346 11/07/2018 Property Taxes 347 11/08/2018 Property Taxes 348 11/09/2018 Property Taxes 349 11/13/2018 Property Taxes 350 11/14/2018 Property Taxes 351 11/15/2018 Property Taxes 352 11/16/2018 Property Taxes 353 11/19/2018 Property Taxes 354 11/20/2018 Property Taxes 355 11/21/2018 Property Taxes 356 11/26/2018 Property Taxes 357 11/27/2018 Property Taxes 358 11/28/2018 Property Taxes 359 11/29/2018 Property Taxes 360 11/30/2018 Property Taxes (17,258.14) (1,300.14) (3,205.93) (1,568.01) (2,161.16) (3,439.52) (1,564.41) (2,053.24) (758.63) (1,654.09) (3,492.79) (2,475.88) (4,314.03) (2,746.55) (286.83) (4,954.65) (1,698.89) (3,867.22) (13,669.07) (1,765.55) (18,558.28) (21,764.21) (23,332.22) (25,493.38) (28,932.90) (30,497.31) (32,550.55) (33,309.18) (34,963.27) (38,456.06) (40,931.94) (45,245.97) (47,992.52) (48,279.35) (53,234.00) (54,932.89) (58,800.11) (72,469.18) (74,234.73) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (56,976.59) (74,234.73) ** (1,117,000.00) Budgeted (1,042,765.27) Remaining 7 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 343 11/02/2018 Property Taxes 345 11/06/2018 Property Taxes 346 11/07/2018 Property Taxes 350 11/14/2018 Property Taxes 354 11/20/2018 Property Taxes 360 11/30/2018 Property Taxes (274.03) (18.95) 21.56 (158.80) (71.20) 6.59 (7.58) (292.98) (271.42) (430.22) (501.42) (494.83) (502.41) GL GL GL GL GL GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (228.38) (502.41) ** .00 Budgeted 502.41 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 343 11/02/2018 Property Taxes 346 11/07/2018 Property Taxes 347 11/08/2018 Property Taxes 348 11/09/2018 Property Taxes 349 11/13/2018 Property Taxes (39.01) (4.61) (64.08) (.87) (1.24) (6.17) (43.62) (107.70) (108.57) (109.81) (115.98) GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 352 11/16/2018 Property Taxes 353 11/19/2018 Property Taxes 360 11/30/2018 Property Taxes (39.01) (9.52) (125.50) GL (.79) (126.29) GL (1.67) (127.96) GL Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (88.95) (127.96) ** .00 Budgeted 127.96 Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** Department Totals: (75,000.00) Budgeted (57,293.92) Monthly Total (75,000.00) Remaining 0 % Used (74,865.10) ** (1,192,000.00) Budgeted (1,117,134.90) Remaining 6 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 11/2018 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 3 Check Source Number Department 45 Totals: 127,149.00 Budgeted 1,491.21 Monthly Total .40 Remaining 100 % Used 267,755.02 ** 517,548.00 Budgeted 249,792.98 Remaining 52 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 215,979.00 Budgeted 215,979.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 126 11/01/2018 Insurance/Wrk Comp Expense Nov 1,491.21 1,491.21 2,982.42 GL Account: 122-60055-045-000 Insurance Totals: 1,491.21 2,982.42 ** 18,000.00 Budgeted 15,017.58 Remaining 17 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 56,204.00 .00 56,204.00 Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: .00 56,204.00 ** .00 Budgeted (56,204.00) Remaining 0 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 75,000.00 Budgeted 75,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** Department 45 Totals: 127,149.00 Budgeted 1,491.21 Monthly Total .40 Remaining 100 % Used 267,755.02 ** 517,548.00 Budgeted 249,792.98 Remaining 52 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Fund 122 Totals: Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 45 Fire Program: Period Ending: 11/2018 JE Detail Description/Comment Page 4 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) 192,889.92 (55,802.71) Monthly Total (674,452.00) Budgeted (867,341.92) Remaining -29 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET NOVEMBER 2018 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,255,850 2,255,850 CASH IN BANK -SAVINGS -CASH RESERVE 984,482 984,482 INVESTMENTS-TEXPOOL 2,813,018 782,846 3,595,864 CASH- ESCROW 361,026 361,026 PREPAID EXPENSES 88,967 88,967 ADVALOREM PROPERTY TAXES RECEIVABLE 120,517 120,517 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,937,924 1,937,924 TOTAL ASSETS 8,562,384 782,846 9,345,230 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 120,517 120,517 ACCOUNTS AND OTHER PAYABLES 612,690 612,690 CUSTOMER DEPOSITS 311,805 311,805 TOTAL LIABILITIES 1,045,012 1,045,012 FUND BALANCE NON -SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 1,906,543 1,906,543 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 225,000 225,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 150,000 150,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 97,805 97,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 310,041 310,041 UNASSIGNED FUND BALANCE 5,709,156 5,709,156 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES (106,813) (106,813) TOTAL FUND BALANCE 7,517,372 782,846 8,300,218 TOTAL LIABILITIES AND FUND BALANCE 8,562,384 782,846 9,345,230 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 Subtotal: 135-49010-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 20,000.00- 14,146.00- 7,000.00- 10,000.00- 18,522.00- 7,000.00- 76,668.00- 10,613,202.00- 10,613,202.00- 10,613,202.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2018 Amended Total Budget Encumb. 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 20,000.00- 14,146.00- 7,000.00- 10,000.00- 18,522.00- 7,000.00- 76,668.00- 10,613,202.00- 10,613,202.00- 10,613,202.00 - Current Month 6,487.20- 26.43- 10.26- 6,523.89- 325,801.18- 265,819.47- 10,143.60- 1,125.00 - Program: YTD Total 8,452.14- 57.54- 14.49- 8,524.17- 596,566.14- 480,126.48- 20,019.68- 2,550.00- 17.60- 602,889.25- 1,099,279.90- 9,101.45- 17,772.49- 1,178.81- 2,684.29- 583.33- 1,166.66- 303.27- 11,166.86- 620,580.00- 620,580.00- 620,580.00- 788.53- 22,411.97- 1,130,216.04- 1,130,216.04- 1,130,216.04- % of Budget 6.385 19.180 4.830 2.795 9.040 14.069 14.675 15.000 Remaining Budget 123,931.86- 242.46- 285.51- 171,983.00- 296,442.83- 6,002,917.86- 2,932,538.52- 116,398.32- 14,450.00- 1,500.00- 4,500.00- .029 59,982.40- 10.744 9,132,287.10- 88.862 18.976 16.667 11.265 29.232 10.649 10.649 10.649 2,227.51- 11,461.71- 5,833.34- 10,000.00- 18,522.00- 6,211.47- 54,256.03- 9,482,985.96- 9,482,985.96- 9,482,985.96 - Page 3 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund Account 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 Subtotal: 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 Subtotal: 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 Description Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Department: Adopted Budget 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 513,092.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 143,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 10 Water Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 11/2018 Total Encumb. Amended Budget 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 513,092.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 143,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 Current Month 34,365.20 1,290.42 3,620.00 200.00 3,651.49 2,948.80 213.65 35.92 215.61 2,429.98 568.31 930.94 50,470.32 885.91 943.00 61.97 200.00 2,090.88 367.25 291.00 7,685.65 136,507.63 750.00 25,172.81 4,600.00 Program: YTD Total % of Budget 45,741.15 13.999 1,856.04 9.280 3,620.00 100.000 400.00 8.333 5,825.91 17.493 5,897.60 7.883 427.30 9.898 71.84 10.248 413.22 13.198 3,171.34 14.401 741.68 14.402 1,861.88 14.439 70,027.96 13.648 5,317.29 5.317 943.00 31.433 785.43 15.709 607.70 9.349 7,653.42 5.344 738.23 14.765 18,928.67 12.275 411.00 8.837 7,685.65 136,507.63 2,090.00 50,345.62 9,200.00 13.251 4.530 14.169 8.603 16.669 Remaining Budget 281,013.85 18,143.96 4,400.00 27,478.09 68,920.40 3,889.70 629.16 2,717.78 18,849.66 4,408.32 1,080.00 11,033.12 200.00 300.00 443,064.04 20,000.00 94,682.71 2,057.00 4,214.57 3,500.00 5,214.00 5,892.30 135,560.58 4,261.77 135,275.33 1,000.00 500.00 4,240.00 400.00 2,345.00 1,500.00 50,314.35 2,876,986.37 200.00 3,000.00 12,660.00 534,863.38 45,993.00 200,000.00 Page 4 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Subtotal: 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 Subtotal: 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtotal: Description Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Department: Adopted Budget 2,500.00 4,101,946.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 Program number: 5,639,834.00 10 Water Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 11/2018 Total Encumb. Amended Budget 2,500.00 4,101,946.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 Current Month 175,374.34 933.72 1,417.41 1,958.32 55.80 Program: YTD Total 225,906.80 1,576.89 1,417.41 4,682.43 55.80 4,365.25 7,732.53 12,084.25 30,617.60 75,000.00 57,932.73 57,932.73 70,016.98 163,550.33 302,317.77 474,871.04 % of Budget 5.507 10.513 27.310 23.412 .080 3.878 6.759 100.000 48.277 23.974 8.420 Remaining Budget 2,500.00 3,876,039.20 13,423.11 3,772.59 15,317.57 1,200.00 1,000.00 69,944.20 87,000.00 191,657.47 422,382.40 30,068.00 4,124.00 62,067.27 518,641.67 5,164,962.96 Page 5 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund Department: 10 Water Trophy Club MUD No.1 Page 6 Budget Summary with Amendment Program: 1 Lab Analysis for PID Period Ending: 11/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 Subtotal: 2,000.00 2,000.00 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 Department number: Water 5,641,834.00 5,641,834.00 80.00 80.00 80.00 367.70 18.385 367.70 18.385 367.70 302,397.77 475,238.74 18.385 8.423 1,632.30 1,632.30 1,632.30 5,166,595.26 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 421,699.00 421,699.00 39,380.11 52,417.23 12.430 369,281.77 135-50010-020-000 Overtime 30,000.00 30,000.00 5,638.08 6,625.49 22.085 23,374.51 135-50016-020-000 Longevity 7,445.00 7,445.00 7,445.00 7,445.00 100.000 135-50017-020-000 Certification 8,700.00 8,700.00 700.00 1,400.00 16.092 7,300.00 135-50020-020-000 Retirement 43,276.00 43,276.00 4,917.59 7,796.31 18.015 35,479.69 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,215.37 10,725.61 11.706 80,901.39 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 371.89 743.78 14.572 4,360.22 135-50028-020-000 Vision Insurance 826.00 826.00 58.90 117.80 14.262 708.20 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 321.20 606.40 13.491 3,888.60 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 3,147.41 3,968.65 13.682 25,037.35 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 736.09 928.16 13.682 5,855.84 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 2,411.46 14.234 14,529.54 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 667,863.00 667,863.00 69,137.37 95,185.89 14.252 572,677.11 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 10,720.72 14,030.93 15.944 73,969.07 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 99.48 145.96 1.825 7,854.04 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,500.00 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 5,214.00 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 10,280.27 14,775.25 19.700 60,224.75 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 2,864.46 7,491.92 21.405 27,508.08 Subtotal: 267,714.00 267,714.00 23,964.93 36,444.06 13.613 231,269.94 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 371.19 753.68 15.074 4,246.32 135-60020-020-000 Electricity 174,165.00 174,165.00 378.97 25,296.73 14.525 148,868.27 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 69.00 23.000 231.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 111.00 1.551 7,044.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 1,895.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 30,000.00 30,000.00 16,345.22 54.484 13,654.78 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 6.98 .140 4,993.02 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 590.00 590.00 5.086 11,010.00 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 10,913.90 21,827.80 18.182 98,225.20 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund Account 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Subtotal: 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Subtotal: 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Description Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtotal: Program number: Department number: Wastewater Department: Adopted Budget 688,330.00 125,187.00 200,000.00 3,500.00 1,381,335.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 70,395.00 330,000.00 109,858.00 14,917.00 30,000.00 484,775.00 2,872,082.00 2,872,082.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 11/2018 Amended Total Budget Encumb. 688,330.00 125,187.00 200,000.00 3,500.00 1,381,335.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 70,395.00 330,000.00 109,858.00 14,917.00 30,000.00 484,775.00 2,872,082.00 2,872,082.00 Current Month Program: YTD Total % of Budget 54,203.45 108,406.90 15.749 10,432.00 20,864.00 16.666 122,777.00 61.389 76,889.51 317,048.31 22.952 1,254.05 2,590.63 20.725 854.08 1,889.49 34.386 536.00 1.787 14.97 14.97 1.248 370.86 552.18 46.015 1,702.70 2,435.77 12.179 4,196.66 8,019.04 11.391 41,610.74 44,200.32 13.394 30,000.00 100.000 41,610.74 74,200.32 15.306 215,799.21 530,897.62 18.485 215,799.21 530,897.62 18.485 Remaining Budget 579,923.10 104,323.00 77,223.00 3,500.00 1,064,286.69 9,909.37 3,605.51 29,464.00 1,185.03 647.82 17,564.23 62,375.96 285,799.68 109,858.00 14,917.00 410,574.68 2,341,184.38 2,341,184.38 Page 8 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 11/2018 Account Description Adopted Amended Total Current YTD % of Budget Budget Encumb. Month Total Budget Program: 135-50045-026-000 Subtotal: Workman's Compensation 30.00 30.00 30.00 30.00 135-60066-026-000 Publications/Books/Subscripts 150.00 135-60070-026-000 Dues & Memberships 750.00 135-60075-026-000 Meetings 1,300.00 135-60080-026-000 Schools & Training 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 Subtotal: 13,200.00 Program number: 13,230.00 Department number: Board of Directors 13,230.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 13,200.00 13,230.00 13,230.00 2.12 4.24 2.12 4.24 2.12 2.12 295.00 14.133 Remaining Budget 25.76 14.133 25.76 7.375 295.00 2.235 299.24 299.24 2.262 2.262 150.00 750.00 1,300.00 3,705.00 5,000.00 2,000.00 12,905.00 12,930.76 12,930.76 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 441,006.00 441,006.00 42,419.32 55,789.59 12.651 385,216.41 135-50010-030-000 Overtime 2,000.00 2,000.00 3.16 6.32 .316 1,993.68 135-50016-030-000 Longevity 1,833.00 1,833.00 1,832.50 1,832.50 99.973 .50 135-50020-030-000 Retirement 41,148.00 41,148.00 4,093.58 6,690.83 16.260 34,457.17 135-50026-030-000 Medical Insurance 81,895.00 81,895.00 4,145.24 8,290.48 10.123 73,604.52 135-50027-030-000 Dental Insurance 4,291.00 4,291.00 259.52 519.04 12.096 3,771.96 135-50028-030-000 Vision Insurance 701.00 701.00 42.51 85.02 12.128 615.98 135-50029-030-000 Life Insurance & Other 4,495.00 4,495.00 282.49 546.98 12.169 3,948.02 135-50030-030-000 Social Security Taxes 27,580.00 27,580.00 2,665.14 3,453.63 12.522 24,126.37 135-50035-030-000 Medicare Taxes 6,450.00 6,450.00 623.32 807.72 12.523 5,642.28 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-030-000 Workman's Compensation 1,295.00 1,295.00 106.55 213.10 16.456 1,081.90 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 52.39 52.39 1.048 4,947.61 Subtotal: 619,454.00 619,454.00 56,525.72 78,287.60 12.638 541,166.40 135-55030-030-000 Software & Support 77,849.00 77,849.00 135-55070-030-000 Independent Labor 175,000.00 175,000.00 135-55080-030-000 Maintenance & Repairs 20,000.00 20,000.00 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 135-55160-030-000 Professional Outside Services 66,055.00 66,055.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 Subtotal: 367,904.00 367,904.00 135-60005-030-000 Telephone 23,500.00 23,500.00 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 135-60020-030-000 Electricity/Gas 8,690.00 8,690.00 135-60025-030-000 Water 2,000.00 2,000.00 135-60035-030-000 Postage 30,000.00 30,000.00 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 135-60055-030-000 Insurance 65,000.00 65,000.00 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 135-60075-030-000 Meetings 400.00 400.00 135-60079-030-000 Public Education 6,000.00 6,000.00 135-60080-030-000 Schools & Training 8,950.00 8,950.00 135-60100-030-000 Travel & per diem 4,345.00 4,345.00 135-60110-030-000 Physicals/Testing 200.00 200.00 135-60125-030-000 Advertising 25,000.00 25,000.00 135-60235-030-000 Security 1,288.00 1,288.00 7,007.87 11,700.76 869.06 580.27 20,157.96 1,556.38 237.49 59.01 1,617.95 5,333.10 6,302.73 24.00 68,111.95 87.492 9,737.05 23,366.90 13.353 151,633.10 315.00 1.575 19,685.00 10,000.00 869.06 8.691 9,130.94 66,055.00 1,159.56 12.884 7,840.44 93,822.47 25.502 274,081.53 2,979.46 12.679 20,520.54 474.98 11.875 3,525.02 557.71 6.418 8,132.29 107.40 5.370 1,892.60 3,345.39 11.151 26,654.61 12,232.37 22.017 43,327.63 1,500.00 12,605.46 19.393 52,394.54 1,000.00 200.00 3.333 5,800.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 48.00 3.727 1,240.00 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund Account Description 135-60245-030-000 135-60246-030-000 135-60360-030-000 Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 Trophy Club MUD No.1 Page 11 Budget Summary with Amendment Department: 30 Administration Program: Period Ending: 11/2018 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 500.00 17,000.00 2,500.00 500.00 17,000.00 2,500.00 500.00 17,000.00 2,500.00 Subtotal: 263,433.00 263,433.00 15,130.66 32,550.77 12.356 230,882.23 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing 2,050.00 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 1,246.49 750.50 370.71 1,246.49 1,224.56 814.75 17.646 20.409 20.369 2,050.00 5,817.51 4,775.44 3,500.00 3,185.25 2,500.00 Subtotal: 25,114.00 25,114.00 2,367.70 3,285.80 13.084 21,828.20 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 280,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 278.35 572.24 14.306 3,427.76 Subtotal: 284,000.00 284,000.00 278.35 572.24 .201 283,427.76 Program number: 1,559,905.00 1,559,905.00 94,460.39 208,518.88 13.367 1,351,386.12 Department number: Administration 1,559,905.00 1,559,905.00 94,460.39 208,518.88 13.367 1,351,386.12 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund Department: Account Description Adopted Budget 135-55045-039-000 Legal 137,000.00 135-55055-039-000 Auditing 30,800.00 135-55060-039-000 Appraisal 11,714.00 135-55065-039-000 Tax Admin Fees 4,800.00 Trophy Club MUD No.1 Page 12 Budget Summary with Amendment 39 Non Departmental Program: Period Ending: 11/2018 Amended Total Current YTD % of Budget Encumb. Month Total Budget 137,000.00 30,800.00 11,714.00 4,800.00 5,235.00 17,074.68 5,000.00 12.463 16.234 Remaining Budget 119,925.32 25,800.00 11,714.00 4,800.00 Subtotal: 184,314.00 184,314.00 5,235.00 22,074.68 11.977 162,239.32 Program number: 184,314.00 184,314.00 5,235.00 22,074.68 11.977 162,239.32 Department number: Non Departmental 184,314.00 184,314.00 5,235.00 22,074.68 11.977 162,239.32 Expenditures Subtotal 10,271,365.00 10,271,365.00 617,894.49 1,237,029.16 12.043 9,034,335.84 Fund number: 135 MUD 1 General Fund 341,837.00- 341,837.00- 2,685.51- 106,813.12 -31.247 448,650.12- glbase_tbam skrolczyk 17:08 12/12/18 Fund: 137 MUD 1 Consolidated GASB Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 11/2018 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Remaining Budget Page 13 137-49145-000-000 1 137-49146-000-000 Intergov Transfer -General Fund Intergov Transfer -Fire Dept 105,000.00- 81,420.00- 105,000.00 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 11/2018 JE Detail Beginning Transaction Transaction Vendor_Name Description/Comment Balance Detail Detail (SUBTOTAL) Page 5 Check Source Number Account: 135-40000-000-000 Property Taxes 342 11/01/2018 Property Taxes 343 11/02/2018 Property Taxes 344 11/05/2018 Property Taxes 345 11/06/2018 Property Taxes 346 11/07/2018 Property Taxes 347 11/08/2018 Property Taxes 348 11/09/2018 Property Taxes 349 11/13/2018 Property Taxes 350 11/14/2018 Property Taxes 351 11/15/2018 Property Taxes 352 11/16/2018 Property Taxes 353 11/19/2018 Property Taxes 354 11/20/2018 Property Taxes 355 11/21/2018 Property Taxes 356 11/26/2018 Property Taxes 357 11/27/2018 Property Taxes 358 11/28/2018 Property Taxes 359 11/29/2018 Property Taxes 360 11/30/2018 Property Taxes (1,964.94) (148.03) (365.02) (178.53) (246.07) (391.61) (178.12) (233.78) (86.38) (188.33) (397.68) (281.90) (491.18) (312.72) (32.66) (564.12) (193.43) (440.31) (1,556.31) (201.02) (2,112.97) (2,477.99) (2,656.52) (2,902.59) (3,294.20) (3,472.32) (3,706.10) (3,792.48) (3,980.81) (4,378.49) (4,660.39) (5,151.57) (5,464.29) (5,496.95) (6,061.07) (6,254.50) (6,694.81) (8,251.12) (8,452.14) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (6,487.20) (8,452.14) ** (132,384.00) Budgeted (123,931.86) Remaining 6 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 343 11/02/2018 Property Taxes 345 11/06/2018 Property Taxes 346 11/07/2018 Property Taxes 350 11/14/2018 Property Taxes 354 11/20/2018 Property Taxes 360 11/30/2018 Property Taxes (2.17) (33.28) 2.23 (31.05) (18.21) (49.26) (8.17) (57.43) .76 (56.67) (.87) (57.54) GL GL GL GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (26.43) (57.54) ** (300.00) Budgeted (242.46) Remaining 19 % Used Account: 135-40015-000-000 Property Taxes/P & I 343 11/02/2018 Property Taxes 346 11/07/2018 Property Taxes 347 11/08/2018 Property Taxes 348 11/09/2018 Property Taxes 349 11/13/2018 Property Taxes (4.23) (.53) (7.35) (.10) (.14) (.70) (4.76) (12.11) (12.21) (12.35) (13.05) GL GL GL GL GL glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 350 11/14/2018 Property Taxes 352 11/16/2018 Property Taxes 353 11/19/2018 Property Taxes 360 11/30/2018 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment (4.23) Program: Transaction Detail (.08) (1.08) (.09) (.19) Transaction Vendor_Name Detail (SUBTOTAL) (13.13) (14.21) (14.30) (14.49) Page 6 Check Source Number GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (10.26) (14.49) ** (300.00) Budgeted (285.51) Remaining 5 % Used Account: 135-40025-000-000 PID Surcharges ' .00 .00 Account: 135-40025-000-000 PLD Surcharges Totals: .00 ** (171,983.00) Budgeted (171,983.00) Remaining 0 % Used Account: 135-47000-000-000 Water 331 11/30/2018 UB 11/30/2018 Billing UB20181130-20181130 User: (270,764.96) (325,801.18) (596,566.14) UB Account: 135-47000-000-000 Water Totals: (325,801.18) (596,566.14) ** (6,599,484.00) Budgeted (6,002,917.86) Remaining 9 % Used Account: 135-47005-000-000 Sewer 331 11/30/2018 UB 11/30/2018 Billing UB20181130-20181130 User: (214,307.01) (265,819.47) (480,126.48) UB Account: 135-47005-000-000 Sewer Totals: (265,819.47) (480,126.48) ** (3,412,665.00) Budgeted (2,932,538.52) Remaining 14 % Used Account: 135-47025-000-000 Penalties 205 11/05/2018 UB 11/05/2018 Penalty Removal 274 11/19/2018 UB 11/19/2018 Penalty Removal 289 11/21/2018 UB 11/21/2018 Penalties 309 11/27/2018 UB 11/27/2018 Penalty removal 314 11/29/2018 UB 11/29/2018 Penalty removal UB20181105-20181105 User: UB20181119-20181119 User: UB20181121-20181121 User: UB20181127-20181127 User: UE20181129-20181129 User: (9,876.08) 147.59 4,188.92 (14,973.99) 366.63 127.25 (9,728.49) (5,539.57) (20,513.56) (20,146.93) (20,019.68) UB UB UB US UB Account: 135-47025-000-000 Penalties Totals: (10,143.60) (20,019.68) ** (136,418.00) Budgeted (116,398.32) Remaining 15 % Used Account: 135-47030-000-000 Service Charges 204 11/01/2018 UB 11/01/2018 Returned NSF UB20181101-20181101 User: (1,425.00) (25.00) (1,450.00) UB glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 216 11/07/2018 UB 11/07/2018 Disconnect Fees UB20181107-20181107 User: 253 11/15/2018 UB 11/15/2018 DF adjustment UB20181115-20181115 User: 301 11/21/2018 UB 11/21/2018 NSF Checks UB20181121-20181121 User: (1,425.00) (1,100.00) (2,550.00) UB 50.00 (2,500.00) UB (50.00) (2,550.00) UB Account: 135-47030-000-000 Service Charges Totals: (1,125.00) ' (2,550.00) ** (17,000.00) Budgeted (14,450.00) Remaining 15 % Used Account: 135-47035-000-000 Plumbing Inspections Account: 135-47035-000-000 Plumbing Inspections Totals: (1,500.00) Budgeted (1,500.00) Remaining 0 % Used Account: 135-47045-000-000 Sewer Inspections Account: 135-47045-000-000 Sewer Inspections Totals: (4,500.00) Budgeted (4,500.00) Remaining 0 % Used Account: 135-47070-000-000 TCCC Effluent Charges (17.60) 1 .00 .00 .00 1 .00 ** 1 .00 .00 .00 .00 ** .00 (17.60) Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 7.60) ** (60,000.00) Budgeted (59,982.40) Remaining Account: 135-49010-000-000 Interest Income 379 11/30/2018 Bank Interest- November 379 11/30/2018 Bank Interest- November 403 11/30/2018 November Interest Pros Savings 0 % Used (8,671.04) (940.54) (9,611.58) GL (7,193.48) (16,805.06) GL (967.43) (17,772.49) GL Account: 135-49010-000-000 Interest Income Totals: (9,101.45) (17,772.49) ** (20,000.00) Budgeted Account: 135-49016-000-000 Cell Tower Revenue 374 11/20/2018 Cell Tower Rev AT&T November (2,227.51) Remaining 89 % Used (1,505.48) (1,178.81) (2,684.29) GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (2,684.29) ** (14,146.00) Budgeted (11,461.71) Remaining 19 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 11/2018 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 8 Check Source Number Department Totals: (7,000.00) Budgeted (620,580.00) Monthly Total (6,211.47) Remaining 11 % Used (1,130,216.04) ** (10,613,202.00) Budgeted (9,482,985.96) Remaining 11 % Used Account: 135-49018-000-000 II Building Rent Income 400 11/30/2018 Town Billed Invoices 1664-1667 AR 20181130-20181130 User: (583.33) (583.33) (1,166.66) AR Account: 135-49018-000-000 ■ Building Rent Income Totals: (583.33) (1,166.66) ** (7,000.00) Budgeted (5,833.34) Remaining 17 % 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 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement .00 .00 Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 .00 ** (18,522.00) Budgeted (18,522.00) Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income ' 331 11/30/2018 UB 11/30/2018 Billing UB20181130-20181130 User: (485.26) (303.27) (788.53) UB Account: 135-49900-000-000 Miscellaneous Income ' Totals: (303.27) (788.53) ** Department Totals: (7,000.00) Budgeted (620,580.00) Monthly Total (6,211.47) Remaining 11 % Used (1,130,216.04) ** (10,613,202.00) Budgeted (9,482,985.96) Remaining 11 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 11/2018 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 9 Check Source Number 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Retirement Retirement Retirement Retirement 2,174.42 1,123.65 1,092.58 334.84 1,100.42 3,298.07 4,390.65 4,725.49 5,825.91 PR PR PR PR Account: 135-50020-010-000 Retirement Totals: 3,651.49 5,825.91 ** 33,304.00 Budgeted 27,478.09 Remaining 17 % Used Account: 135-50026-010-000 Medical Insurance Account: 135-50005-010-000 ' Salaries & Wages 140 11/02/2018 MUD Payroll 11/02/2018 Salaries 234 11/16/2018 MUD Payroll 11/16/2018 Salaries 304 11/30/2018 MUD Payroll 11/30/2018 Salaries & Wages & Wages & Wages 11,375.95 11,481.88 11,469.75 11,413.57 22,857.83 34,327.58 45,741.15 PR PR PR Account: 135-50005-010-000 ' Salaries & Wages Totals: 34,365.20 45,741.15 ** 326,755.00 Budgeted 281,013.85 Remaining 14 % Used Account: 135-50010-010-000 ' Overtime 140 11/02/2018 MUD Payroll 11/02/2018 Overtime 234 11/16/2018 MUD Payroll 11/16/2018 Overtime 304 11/30/2018 MUD Payroll 11/30/2018 Overtime 565.62 665.67 142.00 482.75 1,231.29 1,373.29 1,856.04 PR PR PR Account: 135-50010-010-000 Overtime Totals: 1,290.42 1,856.04 ** 20,000.00 Budgeted 18,143.96 Remaining 9 % Used Account: 135-50016-010-000 Longevity 248 11/16/2018 Longevity 11/16/2018 Longevity 3,620.00 3,620.00 PR Account: 135-50016-010-000 Longevity Totals: 3,620.00 3,620.00 ** 3,620.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 234 11/16/2018 MUD Payroll 11/16/2018 Certification 200.00 200.00 400.00 PR Account: 135-50017-010-000 Certification Totals: 200.00 400.00 ** 4,800.00 Budgeted 4,400.00 Remaining 8 % Used Account: 135-50020-010-000 Retirement 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Retirement Retirement Retirement Retirement 2,174.42 1,123.65 1,092.58 334.84 1,100.42 3,298.07 4,390.65 4,725.49 5,825.91 PR PR PR PR Account: 135-50020-010-000 Retirement Totals: 3,651.49 5,825.91 ** 33,304.00 Budgeted 27,478.09 Remaining 17 % Used Account: 135-50026-010-000 Medical Insurance glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 140 11/02/2018 MUD Payroll 11/02/2018 Medical Insurance 234 11/16/2018 MUD Payroll 11/16/2018 Medical Insurance 2,948.80 1,474.40 4,423.20 PR 1,474.40 5,897.60 PR Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 5,897.60 ** 74,818.00 Budgeted 68,920.40 Remaining 8 6 Used Account: 135-50027-010-000 ■ Dental Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Dental Insurance 234 11/16/2018 MUD Payroll 11/16/2018 Dental Insurance 213.65 106.85 320.50 PR 106.80 427.30 PR Account: 135-50027-010-000 Dental Insurance Totals: 213.65 427.30 ** 4,317.00 Budgeted 3,889.70 Remaining 10 % Used Account: 135-50028-010-000 Vision Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Vision Insurance 234 11/16/2018 MUD Payroll 11/16/2018 Vision Insurance 35.92 17.98 53.90 PR 17.94 71.84 PR Account: 135-50028-010-000 Vision Insurance Totals: 35.92 71.84 ** 701.00 Budgeted 629.16 Remaining 10 % Used Account: 135-50029-010-000 Life Insurance & Other 124 11/01/2018 November A/P 124 11/01/2018 November A/P 302 11/26/2018 November A/P Employee LTD & STD Employee Benefits Caf 125 197.61 87.01 284.62 METLIFE GROUP BENEFITS 110.60 395.22 Humana Inc 18.00 413.22 BenefitMall 4686 AP 4679 AP 4773 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 215.61 413.22 ** 3,131.00 Budgeted 2,717.78 Remaining 13 % Used Account: 135-50030-010-000 Social Security Taxes 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 741.36 745.78 1,487.14 PR 719.60 2,206.74 PR 224.45 2,431.19 PR 740.15 3,171.34 PR Account: 135-50030-010-000 Social Security Taxes Totals: 2,429.98 3,171.34 ** 22,021.00 Budgeted 18,849.66 Remaining 14 % Used Account: 135-50035-010-000 Medicare Taxes glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Department: 10 Water JE Detail Description/Comment Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Page 11 Period Ending: 11/2018 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) 173.37 174.43 168.29 52.49 173.10 347.80 516.09 568.58 741.68 PR PR PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 568.31 741.68 ** 5,150.00 Budgeted 4,408.32 Remaining 14 % Used Account: 135-50040-010-000 Unemployment Taxes ' .00 .00 Account: 135-50040-010-000 Unemployment Taxes Totals: .00 ** 1,080.00 Budgeted 1,080.00 Remaining 0 % Used Account: 135-50045-0 Workman's Compensation 126 11/01/2018 Insurance/Wrk Comp Expense Nov 930.94 930.94 1,861.88 GL Account: 135-50045-010-000 Workman's Compensation Totals: 930.94 1,861.88 ** 12,895.00 Budgeted 11,033.12 Remaining 14 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.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 .00 .00 Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Account: 135-55080-010-000 255 11/15/2018 November A/P 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 Account: 135-55080-010-000 Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Page 12 Detailed Accounting Trial Balance Period Ending: 11/2018 Beginning Balance Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Check Source Number Maintenance & Repairs sample station valves maintenance &repairs maintenance & repairs maintenance and repairs repair supplies repair supplies pipe repair supplies - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 4,431.38 384.30 4,815.68 KORALEEN ENTERPRISES 42.85 4,858.53 THE HOME DEPOT 66581 31.20 4,889.73 THE HOME DEPOT 66581 77.88 4,967.61 THE HOME DEPOT 66581 161.86 5,129.47 THE HOME DEPOT 66581 86.06 5,215.53 THE HOME DEPOT 6581 101.76 5,317.29 THE HOME DEPOT 66581 4754 AP PC PC PC PC PC PC Maintenance & Repairs Totals: 885.91 5,317.29 ** Account: 135-55085-010-000 371 11/30/2018 November A/P Account: 135-55085-010-000 Account: 135-55090-010-000 324 11/26/2018 Pcard 10/27/18 324 324 324 324 11/26/2018 11/26/2018 11/26/2018 11/26/2018 Account: 135-55090-010-000 Account: 135-55105-010-000 Account: 135-55105-010-000 Account: 135-55120-010-000 Account: 135-55120-010-000 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 100,000.00 Budgeted 94,682.71 Remaining Generator Maint. and Repair Generator repair Generator Maint. and Repair Totals: 3,000.00 Budgeted 2,057.00 Remaining Vehicle - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 Vehicle 5,000.00 Maintenance inspection fee fee for veh reg brakes hardware kit safety inspection Maintenance Budgeted Totals: 4,214.57 Remaining Maintenance-Backhoe/SkidLoader Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 3,500.00 Remaining Cleaning Services Cleaning Services 5,214.00 Budgeted 723.46 5 9 Used 31 % Used 16 9 Used 0 % Used 943.00 943.00 Sluder Emergency Power Service 4804 AP 943.00 7.50 2.00 34.48 10.99 7.00 61.97 .00 .00 .00 Totals: 5,214.00 Remaining 0 o Used .00 943.00 ** 730.96 732.96 767.44 778.43 785.43 DENTON VEHREG TX.GOV SERVICEFEE- AUTOZONE 64206 AUTOZONE 64206 KWIK KAR LUBE & TUNE 0 785.43 ** .00 .00 ** .00 .00 ** PC PC PC PC PC glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 11/2018 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 13 Check Source Number 324 11/26/2018 Pcard 10/27/18 - 11/26/18 324 11/26/2018 Pcard 10/27/18 - 11/26/18 324 11/26/2018 Pcard 10/27/18 - 11/26/18 phone case phone case charger & screen protectors 34.97 657.90 AMZN MKTP US*M85UV3RT1 30.96 688.86 AMAZON.COM*M86R03MY1 49.37 738.23 AMZN MKTP US*M84RT4MF1 PC PC PC Account: 135-60010-010-000 Communications/Mobiles Totals: 367.25 738.23 ** Account: 135-55135-010-000 5,000.00 Budgeted 4,261.77 Remaining Lab Analysis o Used Account: 135-60020-010-000 398 11/30/2018 November A/P water samples 407.70 200.00 607.70 TARRANT CTY PUBLIC HEALTH LAB AP Account: 135-55135-010-000 Lab Analysis Totals: 18,928.67 200.00 607.70 ■■ Electricity Totals: .00 6,500.00 Budgeted 5,892.30 Remaining 9 % Used 154,204.00 Budgeted 135,275.33 Remaining 12 Account: 135-60010-010-000 ' Communications/Mobiles Account: 135-60066-010-000 Publications/Books/Subscripts 255 11/15/2018 November A/P cell phones -November 370.98 251.95 622.93 VERIZON WIRELESS 4769 AP 324 11/26/2018 Pcard 10/27/18 - 11/26/18 324 11/26/2018 Pcard 10/27/18 - 11/26/18 324 11/26/2018 Pcard 10/27/18 - 11/26/18 phone case phone case charger & screen protectors 34.97 657.90 AMZN MKTP US*M85UV3RT1 30.96 688.86 AMAZON.COM*M86R03MY1 49.37 738.23 AMZN MKTP US*M84RT4MF1 PC PC PC Account: 135-60010-010-000 Communications/Mobiles Totals: 367.25 738.23 ** 5,000.00 Budgeted 4,261.77 Remaining 15 o Used Account: 135-60020-010-000 Electricity 18,928.67 .00 18,928.67 Account: 135-60020-010-000 Electricity Totals: .00 18,928.67 ** 154,204.00 Budgeted 135,275.33 Remaining 12 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.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 324 11/26/2018 Pcard 10/27/18 - 11/26/18 drivers license renewal 120.00 69.00 189.00 TX DPS DL OFFICE PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 license renewal 324 11/26/2018 Pcard 10/27/18 - 11/26/18 license renewal 111.00 111.00 300.00 TCEQ IND RENEWAL L 411.00 TCEQ IND RENEWAL L PC PC glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-60080-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 11/2018 JE Detail Description/Comment Schools & Training Totals: 4,651.00 Budgeted Account: 135-60090-010-000 Safety Program Account: 135-60090-010-000 Page 14 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) 4,240.00 Remaining 9 % Used Safety Program Totals: 400.00 Budgeted Account: 135-60100-010-000 Travel & per diem Account: 135-60100-010-000 400.00 Remaining 0 % Used Travel & per diem Totals: 2,345.00 Budgeted Account: 135-60105-010-000 Rent/Lease Equipment Account: 135-60105-010-000 2,345.00 Remaining 0 % Used Rent/Lease Equipment Totals: 1,500.00 Budgeted Account: 135-60135-010-000 TCEQ Fees & Permits 302 11/26/2018 November A/P Water system fee Account: 135-60135-010-000 1,500.00 Remaining 0 % Used TCEQ Fees & Permits Totals: 58,000.00 Budgeted Account: 135-60150-010-000 Wholesale Water 398 11/30/2018 November A/P wholesale water Account: 135-60150-010-000 Account: 135-60245-010-000 Wholesale Water 3,013,494.00 Budgeted Miscellaneous Expenses 50,314.35 Remaining 13 % Used 291.00 411.00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** 7,685.65 7,685.65 TX COMMISSION ENVIRONMENTAL QU 4785 AP 7,685.65 7,685.65 ** 136,507.63 136,507.63 CITY OF FORT WORTH AP Totals: 136,507.63 2,876,986.37 Remaining 5 % Used 136,507.63 ** .00 .00 glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-60245-010-000 Account: 135-60280-010-000 Account: 135-60280-010-000 Trophy Club MUD No.1 Page 15 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 11/2018 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Miscellaneous Expenses 200.00 Budgeted Property Maintenance Property Maintenance 3,000.00 Budgeted Totals: 200.00 Remaining 0 % Used Totals: 3,000.00 Remaining 0 % Used .00 .00 ** .00 .00 .00 .00 ** Account: 135-60285-010-000 Lawn Equipment & Maintenance 371 11/30/2018 November A/P November mowing 1,340.00 750.00 2,090.00 WATTS ELLISON LLC 4813 AP Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 2,090.00 ** 14,750.00 Budgeted 12,660.00 Remaining Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 235 11/30/2018 TexPool Transfers November TexPool O&M to 16Swift Rev I&S Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 585,209.00 Budgeted 534,863.38 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bond Resevr Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted 45,993.00 Remaining 14 % Used 25,172.81 25,172.81 50,345.62 GL 25,172.81 50,345.62 ** 9 % Used 4,600.00 4,600.00 17 % Used 4,600.00 9,200.00 GL 9,200.00 ** 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 glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-60360-010-000 Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Page 16 Detailed Accounting Trial Balance Period Ending: 11/2018 Beginning Balance Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Account: 135-65005-010-000 Fuel & Lube 320 11/30/2018 A/P November Fuel Cards Fuel Account: 135-65005-010-000 Fuel & Lube 15,000.00 Budgeted Totals: 13,423.11 Remaining Program: Transaction Detail .00 O % Used Transaction Vendor_Name Detail (SUBTOTAL) .00 ** Check Source Number 643.17 933.72 1,576.89 US Bank Voyager Fleet Systems 4810 AP 11 % Used 933.72 1,576.89 ** Account: 135-65010-010-000 Uniforms - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 324 324 324 324 324 324 324 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 Account: 135-65010-010-000 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Account: 135-65030-010-000 371 11/30/2018 November A/P 371 11/30/2018 November A/P 371 11/30/2018 November A/P Account: 135-65030-010-000 pants shoes Uniforms shoes shoes shoes Shoes Uniforms 5,190.00 Budgeted Chemicals testing supplies LAS chlorine Chemicals 20,000.00 Budgeted Totals: 3,772.59 Remaining Totals: 15,317.57 Remaining 419.51 166.49 149.93 165.74 165.74 175.00 175.00 1,417.41 27 6 Used 419.51 586.00 735.93 901.67 1,067.41 1,242.41 1,417.41 AMAZON.COM*M86H67Y60 RED WING SHOES #652 ACADEMY SPORTS #141 RED WING SHOES #652 RED WING SHOES #652 RED WING SHOES #652 RED WING SHOES #652 1,417.41 ** 2,724.11 741.91 3,466.02 HACH COMPANY 434.64 3,900.66 Valley Solvent Company, INC 781.77 4,682.43 DPC INDUSTRIES, INC 23 % Used 1,958.32 4,682.43 ** PC PC PC PC PC PC PC 4793 AP 4812 AP 4790 AP Account: 135-65035-010-000 Small Tools Account: 135-65035-010-000 Small Tools 1,200.00 Budgeted Totals: 1,200.00 Remaining O % Used .00 .00 .00 .00 ** Account: 135-65040-010-000 Safety Equipment .00 .00 glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-65040-010-000 Account: 135-65050-010-000 255 11/15/2018 November A/P Account: 135-65050-010-000 Trophy Club MUD No.1 Page 17 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 11/2018 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Safety Equipment 1,000.00 Budgeted Meter Expense meter parts Meter Expense 70,000.00 Budgeted Account: 135-65053-010-000 Meter Change Out Program Account: 135-65053-010-000 Totals: 1,000.00 Remaining 0 % Used Totals: 69,944.20 Remaining 0 % Used Meter Change Out Program Totals: 87,000.00 Budgeted 87,000.00 Remaining Account: 135-69005-010-000 Capital Outlays 399 11/30/2018 November A/P 16" water line phase II Account: 135-69005-010-000 Capital Outlays Totals: 453,000.00 Budgeted O o Used .00 .00 ** 55.80 55.80 ATLAS UTILITY SUPPLY CO. 55.80 55.80 ** .00 .00 .00 .00 ** 18,533.35 12,084.25 422,382.40 Remaining 7 % Used Account: 135-69008-010-000 Short Term Debt -Principal Account: 135-69008-010-000 Short Term Debt -Principal Totals: 30,068.00 Budgeted 30,068.00 Remaining Account: 135-69009-010-000 Short Term Debt -Interest Account: 135-69009-010-000 Short Term Debt -Interest Totals: 4,124.00 Budgeted 4,124.00 Remaining Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 O % Used O 5 Used 4745 AP 30,617.60 Halff Associates, INC AP 12,084.25 30,617.60 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 75,000.00 glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 11/2018 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 18 Check Source Number 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 371 11/30/2018 November A/P Tank inspection 57,932.73 57,932.73 UTILITY SERVICE CO, INC. 4811 AP Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 57,932.73 57,932.73 ** 120,000.00 Budgeted 62,067.27 Remaining 48 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 19 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/2018 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 398 11/30/2018 November A/P water samples-pid 287.70 80.00 367.70 TARRANT CTY PUBLIC HEALTH LAB AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 367.70 ** 2,000.00 Budgeted 1,632.30 Remaining 18 % Used Department 10 Totals: 475,238.74 ** 302,397.77 Monthly Total 5,641,834.00 Budgeted 5,166,595.26 Remaining 8 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 20 Check Source Number 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Retirement Retirement Retirement Retirement 2,878.72 1,483.80 1,425.02 688.67 1,320.10 4,362.52 5,787.54 6,476.21 7,796.31 PR PR PR PR Account: 135-50020-020-000 Retirement Totals: 4,917.59 7,796.31 ** 43,276.00 Budgeted 35,479.69 Remaining 18 % Used Account: 135-50026-020-000 Medical Insurance Account: 135-50005-020-000 ' Salaries & Wages 140 11/02/2018 MUD Payroll 11/02/2018 Salaries 234 11/16/2018 MUD Payroll 11/16/2018 Salaries 304 11/30/2018 MUD Payroll 11/30/2018 Salaries & Wages & Wages & Wages 13,037.12 13,092.68 13,243.59 13,043.84 26,129.80 39,373.39 52,417.23 PR PR PR Account: 135-50005-020-000 ' Salaries & Wages Totals: 39,380.11 52,417.23 ** 421,699.00 Budgeted 369,281.77 Remaining 12 % Used Account: 135-50010-020-000 ' Overtime 140 11/02/2018 MUD Payroll 11/02/2018 Overtime 234 11/16/2018 MUD Payroll 11/16/2018 Overtime 304 11/30/2018 MUD Payroll 11/30/2018 Overtime 987.41 2,948.48 1,462.00 1,227.60 3,935.89 5,397.89 6,625.49 PR PR PR Account: 135-50010-020-000 Overtime Totals: 5,638.08 6,625.49 ** 30,000.00 Budgeted 23,374.51 Remaining 22 % Used Account: 135-50016-020-000 Longevity 248 11/16/2018 Longevity 11/16/2018 Longevity 7,445.00 7,445.00 PR Account: 135-50016-020-000 Longevity Totals: 7,445.00 7,445.00 ** 7,445.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 234 11/16/2018 MUD Payroll 11/16/2018 Certification 700.00 700.00 1,400.00 PR Account: 135-50017-020-000 Certification Totals: 700.00 1,400.00 ** 8,700.00 Budgeted 7,300.00 Remaining 16 % Used Account: 135-50020-020-000 Retirement 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Retirement Retirement Retirement Retirement 2,878.72 1,483.80 1,425.02 688.67 1,320.10 4,362.52 5,787.54 6,476.21 7,796.31 PR PR PR PR Account: 135-50020-020-000 Retirement Totals: 4,917.59 7,796.31 ** 43,276.00 Budgeted 35,479.69 Remaining 18 % Used Account: 135-50026-020-000 Medical Insurance glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 140 11/02/2018 MUD Payroll 11/02/2018 Medical Insurance 234 11/16/2018 MUD Payroll 11/16/2018 Medical Insurance 5,510.24 2,607.70 8,117.94 PR 2,607.67 10,725.61 PR Account: 135-50026-020-000 Medical Insurance Totals: 5,215.37 10,725.61 ** 91,627.00 Budgeted 80,901.39 Remaining 12 6 Used Account: 135-50027-020-000 ■ Dental Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Dental Insurance 234 11/16/2018 MUD Payroll 11/16/2018 Dental Insurance 371.89 185.96 557.85 PR 185.93 743.78 PR Account: 135-50027-020-000 Dental Insurance Totals: 371.89 743.78 ** 5,104.00 Budgeted 4,360.22 Remaining 15 % Used Account: 135-50028-020-000 Vision Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Vision Insurance 234 11/16/2018 MUD Payroll 11/16/2018 Vision Insurance 58.90 29.46 88.36 PR 29.44 117.80 PR Account: 135-50028-020-000 Vision Insurance Totals: 58.90 117.80 ** 826.00 Budgeted 708.20 Remaining 14 6 Used Account: 135-50029-020-000 Life Insurance & Other 124 11/01/2018 November A/P 124 11/01/2018 November A/P 302 11/26/2018 November A/P Employee LTD & STD Employee Benefits Caf 125 285.20 120.84 406.04 METLIFE GROUP BENEFITS 164.36 570.40 Humana Inc 36.00 606.40 BenefitMall 4686 AP 4679 AP 4773 AP Account: 135-50029-020-000 Life Insurance & Other Totals: 321.20 606.40 ** 4,495.00 Budgeted 3,888.60 Remaining 13 % Used Account: 135-50030-020-000 Social Security Taxes 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 821.24 929.06 1,750.30 PR 869.32 2,619.62 PR 461.59 3,081.21 PR 887.44 3,968.65 PR Account: 135-50030-020-000 Social Security Taxes Totals: 3,147.41 3,968.65 ** 29,006.00 Budgeted 25,037.35 Remaining 14 6 Used Account: 135-50035-020-000 Medicare Taxes glpdatb2 skrolczyk Trophy Club MUD No.1 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 22 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 192.07 217.26 203.31 107.96 207.56 409.33 612.64 720.60 928.16 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 736.09 928.16 ** 6,784.00 Budgeted 5,855.84 Remaining 14 % Used Account: 135-50040-020-000 Unemployment Taxes ' .00 .00 Account: 135-50040-020-000 Unemployment Taxes Totals: .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-020-041 Workman's Compensation 126 11/01/2018 Insurance/Wrk Comp Expense Nov 1,205.73 1,205.73 2,411.46 GL Account: 135-50045-020-000 Workman's Compensation Totals: 1,205.73 2,411.46 ** 16,941.00 Budgeted 14,529.54 Remaining 14 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 11/2018 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 23 Check Source Number 302 302 302 324 324 324 324 324 324 371 371 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/30/2018 11/30/2018 November A/P November A/P November A/P Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 November A/P November A/P - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 Socks and oil pads Bags man hole rehab broom, wd 40, echo pb kit tape, faucet covers,bucket,etc clear mint gal 4 drum pump kit filter replacement maintenance & repairs Pump disconnect MBR #2 Shipping for pump to be repair 138.39 1,300.00 4,887.79 55.15 109.35 156.93 431.95 288.43 54.09 490.00 938.64 5,318.60 6,618.60 11,506.39 11,561.54 11,670.89 11,827.82 12,259.77 12,548.20 12,602.29 13,092.29 14,030.93 Ritz Safety, LLC Huber Technology Inc REY-MAR CONSTRUCTION THE HOME DEPOT #6581 THE HOME DEPOT #6581 WAGNER SUPPLY AMAZON.COM*M80XZ5BA2 FILTER ELEMENT STORE THE HOME DEPOT #6581 DHS AUTOMATION, INC PostNet TX193 4782 AP 4775 AP 4781 AP PC PC PC PC PC PC 4788 AP 4803 AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 10,720.72 14,030.93 ** Account: 135-55070-020-000 Independent Labor 16 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** Account: 135-55085-020-000 15,000.00 Budgeted 15,000.00 Remaining 0 % Used .00 .00 ** Account: 135-55080-020-000 Maintenance & Repairs 0 % Used Account: 261 11/16/2018 November A/P Gate repair at WWTP 3,310.21 1,870.00 5,180.21 Alan's Gates, Inc. 4744 AP 302 302 302 324 324 324 324 324 324 371 371 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/30/2018 11/30/2018 November A/P November A/P November A/P Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 November A/P November A/P - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 Socks and oil pads Bags man hole rehab broom, wd 40, echo pb kit tape, faucet covers,bucket,etc clear mint gal 4 drum pump kit filter replacement maintenance & repairs Pump disconnect MBR #2 Shipping for pump to be repair 138.39 1,300.00 4,887.79 55.15 109.35 156.93 431.95 288.43 54.09 490.00 938.64 5,318.60 6,618.60 11,506.39 11,561.54 11,670.89 11,827.82 12,259.77 12,548.20 12,602.29 13,092.29 14,030.93 Ritz Safety, LLC Huber Technology Inc REY-MAR CONSTRUCTION THE HOME DEPOT #6581 THE HOME DEPOT #6581 WAGNER SUPPLY AMAZON.COM*M80XZ5BA2 FILTER ELEMENT STORE THE HOME DEPOT #6581 DHS AUTOMATION, INC PostNet TX193 4782 AP 4775 AP 4781 AP PC PC PC PC PC PC 4788 AP 4803 AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 10,720.72 14,030.93 ** 88,000.00 Budgeted 73,969.07 Remaining 16 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 - 11/26/18 returned battery - 11/26/18 batteries & fule inj hose 46.48 (35.00) 134.48 11.48 145.96 AUTOZONE AUTOZONE #4206 #4206 PC PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 99.48 145.96 ** 8,000.00 Budgeted 7,854.04 Remaining 2 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55120-020-000 Cleaning Services .00 .00 Account: 135-55120-020-000 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 255 11/15/2018 November A/P 302 11/26/2018 November A/P 371 11/30/2018 November A/P 371 11/30/2018 November A/P sludge haul off sludge haul off sludge haul off sludge haul off 4,494.98 3,520.27 2,535.00 3,380.00 845.00 8,015.25 L.H. CHANEY MATERIALS, INC. 10,550.25 L.H. CHANEY MATERIALS, INC. 13,930.25 L.H. CHANEY MATERIALS, INC. 14,775.25 L.H. CHANEY MATERIALS, INC. 4755 AP 4777 AP 4800 AP 4800 AP Account: 135-55125-020-000 Dumpster Services Totals: 10,280.27 14,775.25 ** 75,000.00 Budgeted 60,224.75 Remaining 20 % Used Account: 135-55135-020-000 Lab Analysis 255 11/15/2018 November A/P 255 11/15/2018 November A/P 255 11/15/2018 November A/P 302 11/26/2018 November A/P 302 11/26/2018 November A/P 371 11/30/2018 November A/P 371 11/30/2018 November A/P 371 11/30/2018 November A/P sludge testing effluent testing effluent testing Effluent testing effluent testing Effluent testing Effluent testing lab trays 4,627.46 1,367.50 246.00 176.00 246.00 176.00 246.00 176.00 230.96 5,994.96 OXIDOR LABORATORIES LLC 6,240.96 OXIDOR LABORATORIES LLC 6,416.96 OXIDOR LABORATORIES LLC 6,662.96 OXIDOR LABORATORIES LLC 6,838.96 OXIDOR LABORATORIES LLC 7,084.96 OXIDOR LABORATORIES LLC 7,260.96 OXIDOR LABORATORIES LLC 7,491.92 IDEXX DISTRIBUTION, INC 4764 AP 4764 AP 4764 AP 4780 AP 4780 AP 4802 AP 4802 AP 4795 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,864.46 7,491.92 ** 35,000.00 Budgeted 27,508.08 Remaining 21 % Used Account: 135-60010-020-000 Communications/Mobiles 255 11/15/2018 November A/P cell phones -November 382.49 371.19 753.68 VERIZON WIRELESS 4769 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 371.19 753.68 ** 5,000.00 Budgeted 4,246.32 Remaining 15 % Used Account: 135-60020-020-000 Electricity glpdatb2 skrolczyk Trophy Club MUD No.1 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 25 398 11/30/2018 November A/P 398 11/30/2018 November A/P 398 11/30/2018 November A/P Electricity 10/23-11/27 Electricity 10/23-11/27 Electricity 10/23-11/27 400 11/30/2018 Town Billed Invoices 1664-1667 AR 20181130-20181130 User: 24,917.76 184.64 348.24 28.25 (182.16) 25,102.40 TRI COUNTY ELECTRIC 25,450.64 TRI COUNTY ELECTRIC 25,478.89 TRI COUNTY ELECTRIC 25,296.73 AP AP AP AR Account: 135-60020-020-000 Electricity 11111 Totals: 378.97 25,296.73 ** 174,165.00 Budgeted 148,868.27 Remaining 15 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 69.00 .00 69.00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 69.00 ** 300.00 Budgeted 231.00 Remaining 23 % Used Account: 135-60080-020-000 Schools & Training 111.00 .00 111.00 Account: 135-60080-020-000 Schools & Training Totals: .00 111.00 ** 7,155.00 Budgeted 7,044.00 Remaining 2 % Used Account: 135-60090-020-000 Safety Program .00 .00 Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,895.00 Budgeted 1,895.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 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 Account: 135-60105-020-000 Account: 135-60125-020-000 Account: 135-60125-020-000 Account: 135-60135-020-000 Account: 135-60135-020-000 Account: 135-60245-020-000 Rent/Lease Equipment Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Advertising Advertising Totals: 2,500.00 Budgeted TCEQ Fees & Permits TCEQ Fees & Permits 30,000.00 Budgeted Miscellaneous Expenses 2,500.00 Remaining 16,345.22 0 % Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 16,345.22 Totals: 13,654.78 Remaining 54 % Used .00 16,345.22 ** .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** Account: 135-60280-020-000 Account: 135-60280-020-000 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 450.00 Remaining 0 % Used 6.98 .00 6.98 Totals: 4,993.02 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 371 11/30/2018 November A/P November mowing Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 11,600.00 Budgeted 11,010.00 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax ISS .00 6.98 ** 590.00 590.00 WATTS ELLISON LLC 4813 AP 590.00 590.00 ** 5 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 235 11/30/2018 TexPool Transfers November TexPool O&M to I&S- PID Debt 10,913.90 10,913.90 21,827.80 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,913.90 21,827.80 ** 120,053.00 Budgeted 98,225.20 Remaining 18 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bd WWTP I&S 54,203.45 54,203.45 108,406.90 GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 54,203.45 108,406.90 ** 688,330.00 Budgeted 579,923.10 Remaining 16 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bond Resevr 10,432.00 10,432.00 20,864.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 10,432.00 20,864.00 ** 125,187.00 Budgeted 104,323.00 Remaining 17 % Used Account: 135-60334-020-000 Interfund Transfer Out ' 122,777.00 .00 122,777.00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 122,777.00 ** 200,000.00 Budgeted 77,223.00 Remaining 61 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 324 11/26/2018 Pcard 10/27/18 - 11/26/18 fuel 1,336.58 47.70 1,384.28 7 -ELEVEN 32921 PC 320 11/30/2018 A/P November Fuel Cards Fuel 1,206.35 2,590.63 US Bank Voyager Fleet Systems 4810 AP Account: 135-65005-020-000 Fuel & Lube Totals: 1,254.05 2,590.63 ** 12,500.00 Budgeted 9,909.37 Remaining 21 % Used Account: 135-65010-020-000 Uniforms glpdatb2 skrolczyk Trophy Club MUD No.1 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 28 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 324 11/26/2018 Pcard 10/27/18 - 11/26/18 waders 324 11/26/2018 Pcard 10/27/18 - 11/26/18 boots 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 1,035.41 86.95 1,122.36 ACADEMY SPORTS #81 119.93 1,242.29 ACADEMY SPORTS #81 110.93 1,353.22 ACADEMY SPORTS #81 80.97 1,434.19 *02 DICKIES OUTLET FW 143.49 1,577.68 WAL-MART #4240 59.85 1,637.53 AMAZON.COM*M84SR2GTO 164.99 1,802.52 ACADEMY SPORTS #141 86.97 1,889.49 #02 DICKIES OUTLET FW PC PC PC PC PC PC PC PC Account: 135-65010-020-000 Uniforms Totals: 854.08 1,889.49 ** 5,495.00 Budgeted 3,605.51 Remaining 34 % Used Account: 135-65030-020-000 Chemicals 536.00 .00 536.00 Account: 135-65030-020-000 Chemicals Totals: .00 536.00 ** 30,000.00 Budgeted 29,464.00 Remaining 2 % Used Account: 135-65035-020-000 Small Tools ' 324 11/26/2018 Pcard 10/27/18 - 11/26/18 sprayer 14.97 14.97 THE HOME DEPOT #6581 PC Account: 135-65035-020-000 Small Tools Totals: 14.97 14.97 ** 1,200.00 Budgeted 1,185.03 Remaining 1 % Used Account: 135-65040-020-000 Safety Equipment 302 11/26/2018 November A/P 302 11/26/2018 November A/P 302 11/26/2018 November A/P Raincotas and pants Pads raincoats and pants 181.32 241.64 61.11 68.11 422.96 484.07 552.18 Ritz Safety, LLC Ritz Safety, LLC Ritz Safety, LLC 4782 4782 4782 AP AP AP Account: 135-65040-020-000 Safety Equipment Totals: 370.86 552.18 ** 1,200.00 Budgeted 647.82 Remaining 46 % Used Account: 135-65045-020-000 Lab Supplies 371 11/30/2018 November A/P 371 11/30/2018 November A/P chemicals oven calibration 733.07 75.20 1,627.50 808.27 2,435.77 HACH COMPANY TigerFrog Ventures, LLC 4793 4807 AP AP Account: 135-65045-020-000 Lab Supplies Totals: 1,702.70 2,435.77 ** 20,000.00 Budgeted 17,564.23 Remaining 12 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 29 Check Source Number Account: 135-69005-020-000 Capital Outlays 218 11/07/2018 November A/P 255 11/15/2018 November A/P 371 11/30/2018 November A/P 398 11/30/2018 November A/P 399 11/30/2018 November A/P 399 11/30/2018 November A/P Decal for Vac truck LS upgrades Legal WWTP VFD Publication WWTP watersystem LS #1 easement 2,589.58 95.00 2,684.58 M-KAM LTD. 4729 AP 37,353.00 40,037.58 DHS AUTOMATION, INC 4748 AP 1,530.00 41,567.58 Dubois Bryant Campbell LLP 4791 AP 863.40 42,430.98 Star -Telegram Media AP 394.34 42,825.32 Halff Associates, INC AP 1,375.00 44,200.32 CP&Y/WALLACE GROUP, INC. AP Account: 135-69005-020-000 Capital Outlays Totals: 41,610.74 44,200.32 ** 330,000.00 Budgeted 285,799.68 Remaining 13 % Used Account: 135-69008-020-000 Short Term Debt -Principal .00 .00 Account: 135-69008-020-000 Short Term Debt -Principal Totals: .00 .00 ** 109,858.00 Budgeted 109,858.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt -Interest .00 .00 Account: 135-69009-020-000 Short Term Debt -Interest Totals: .00 .00 ** 14,917.00 Budgeted 14,917.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** Department 20 Totals: 30,000.00 Budgeted 215,799.21 Monthly Total .00 Remaining 100 % Used 530,897.62 ** 2,872,082.00 Budgeted 2,341,184.38 Remaining 18 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2018 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 126 11/01/2018 Insurance/Wrk Comp Expense Nov Account: 135-50045-026-000 Account: 135-60066-026-000 Account: 135-60066-026-000 Account: 135-60070-026-000 Account: 135-60070-026-000 Workman's Compensation Totals: 30.00 Budgeted Publications/Books/Subscripts 2.12 2.12 4.24 GL 25.76 Remaining 14 % Used Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining Dues & Memberships Dues & Memberships 750.00 Budgeted 2.12 4.24 ** .00 0 % Used .00 .00 .00 ** .00 Totals: 750.00 Remaining 0 6 Used .00 .00 .00 ** Account: 135-60075-026-000 Meetings Account: 135-60075-026-000 Meetings 1,300.00 Budgeted Totals: 1,300.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-60080-026-000 Schools & Training Account: 135-60080-026-000 Schools & Training 4,000.00 Budgeted 295.00 Totals: 3,705.00 Remaining 7 % Used .00 295.00 .00 295.00 ** Account: 135-60100-026-000 Travel & per diem .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 5,000.00 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2018 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-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 299.24 ** 2.12 Monthly Total 13,230.00 Budgeted 12,930.76 Remaining 2 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 32 Check Source Number 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Retirement Retirement Retirement Retirement 2,597.25 1,305.42 1,308.96 169.50 1,309.70 3,902.67 5,211.63 5,381.13 6,690.83 PR PR PR PR Account: 135-50020-030-000 Retirement Totals: 4,093.58 6,690.83 ** Account: 135-50005-030-000 ' Salaries & Wages 16 % Used Account: 135-50026-030-000 Medical Insurance 140 11/02/2018 MUD Payroll 234 11/16/2018 MUD Payroll 304 11/30/2018 MUD Payroll 11/02/2018 Salaries 11/16/2018 Salaries 11/30/2018 Salaries & Wages & Wages & Wages 13,370.27 14,112.76 14,150.86 14,155.70 27,483.03 41,633.89 55,789.59 140 11/02/2018 MUD Payroll 234 11/16/2018 MUD Payroll PR PR PR Account: 135-50005-030-000 ' Salaries & Wages 2,072.63 2,072.61 Totals: PR PR 42,419.32 55,789.59 ** Totals: 441,006.00 Budgeted 8,290.48 385,216.41 Remaining 13 % Used 81,895.00 Budgeted 73,604.52 Remaining 10 Account: 135-50010-030-000 Overtime Account: 135-50027-030-000 Dental Insurance 304 11/30/2018 MUD Payroll 11/30/2018 Overtime 3.16 11/02/2018 Dental Insurance 3.16 6.32 PR Account: 135-50010-030-000 Overtime Totals: 6.32 ** 2,000.00 Budgeted 1,993.68 Remaining 0 % Used Account: 135-50016-030-000 Longevity 248 11/16/2018 Longevity 11/16/2018 Longevity 1,832.50 1,832.50 PR Account: 135-50016-030-000 Longevity Totals: 1,832.50 1,832.50 ** 1,833.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Retirement Retirement Retirement Retirement 2,597.25 1,305.42 1,308.96 169.50 1,309.70 3,902.67 5,211.63 5,381.13 6,690.83 PR PR PR PR Account: 135-50020-030-000 Retirement Totals: 4,093.58 6,690.83 ** 41,148.00 Budgeted 34,457.17 Remaining 16 % Used Account: 135-50026-030-000 Medical Insurance 140 11/02/2018 MUD Payroll 234 11/16/2018 MUD Payroll 11/02/2018 Medical Insurance 11/16/2018 Medical Insurance 4,145.24 2,072.63 2,072.61 6,217.87 8,290.48 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 8,290.48 ** 81,895.00 Budgeted 73,604.52 Remaining 10 % Used Account: 135-50027-030-000 Dental Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Dental Insurance 259.52 129.78 389.30 PR glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 234 11/16/2018 MUD Payroll 11/16/2018 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Dental Insurance 259.52 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 129.74 519.04 Page 33 Check Source Number PR 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 788.49 836.99 836.70 113.61 877.84 1,625.48 2,462.18 2,575.79 3,453.63 PR PR PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 2,665.14 3,453.63 ** 27,580.00 Budgeted 24,126.37 Remaining 13 % Used Account: 135-50035-030-000 Medicare Taxes 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 184.40 195.76 195.67 26.57 205.32 380.16 575.83 602.40 807.72 PR PR PR PR Account: 135-50035-030-000 Medicare Taxes Totals: 3.32 807.72 ** 6,450.00 Budgeted 5,642.28 Remaining 13 % Used Account: 135-50040-030-000 Unemployment Taxes Account: 135-50027-030-000 Dental Insurance Totals: 259.52 519.04 ** 4,291.00 Budgeted 3,771.96 Remaining 12 % Used Account: 135-50028-030-000 Vision Insurance 140 11/02/2018 MUD Payroll 234 11/16/2018 MUD Payroll 11/02/2018 Vision Insurance 11/16/2018 Vision Insurance 42.51 21.28 21.23 63.79 85.02 PR PR Account: 135-50028-030-000 Vision Insurance Totals: 42.51 85.02 ** 701.00 Budgeted 615.98 Remaining 12 % Used Account: 135-50029-030-000 Life Insurance & Other 124 11/01/2018 November A/P 124 11/01/2018 November A/P 302 11/26/2018 November A/P Employee LTD & STD Employee Benefits Caf 125 264.49 119.45 145.04 18.00 383.94 528.98 546.98 METLIFE GROUP BENEFITS Humana Inc BenefitMall 4686 4679 4773 AP AP AP Account: 135-50029-030-000 Life Insurance & Other Totals: 282.49 546.98 ** 4,495.00 Budgeted 3,948.02 Remaining 12 % Used Account: 135-50030-030-000 Social Security Taxes 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 788.49 836.99 836.70 113.61 877.84 1,625.48 2,462.18 2,575.79 3,453.63 PR PR PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 2,665.14 3,453.63 ** 27,580.00 Budgeted 24,126.37 Remaining 13 % Used Account: 135-50035-030-000 Medicare Taxes 140 11/02/2018 MUD Payroll 11/02/2018 234 11/16/2018 MUD Payroll 11/16/2018 248 11/16/2018 Longevity 11/16/2018 304 11/30/2018 MUD Payroll 11/30/2018 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 184.40 195.76 195.67 26.57 205.32 380.16 575.83 602.40 807.72 PR PR PR PR Account: 135-50035-030-000 Medicare Taxes Totals: 3.32 807.72 ** 6,450.00 Budgeted 5,642.28 Remaining 13 % Used Account: 135-50040-030-000 Unemployment Taxes glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-50040-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Unemployment Taxes 1,260.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 126 11/01/2018 Insurance/Wrk Comp Expense Nov Account: 135-50045-030-000 Workman's Compensation 1,295.00 Budgeted Totals: 1,260.00 Remaining Totals: 1,081.90 Remaining 106.55 Program: Transaction Detail .00 O % Used .00 106.55 16 6 Used 106.55 Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** 213.10 213.10 ** Page 34 Check Source Number GL Account: 135-50060-030-000 Pre-emp Physicals/Testing Account: 135-50060-030-000 Account: 135-50070-030-000 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 377 11/29/2018 Employee Reimbur Account: 135-50070-030-000 Account: 135-55030-030-000 218 11/07/2018 255 11/15/2018 261 11/16/2018 324 324 324 324 324 11/26/2018 11/26/2018 11/26/2018 11/26/2018 11/26/2018 Account: 135-55030-030-000 November A/P November A/P November A/P Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pcard 10/27/18 Pre-emp Physicals/Testing Totals: 500.00 Budgeted 500.00 Remaining Employee Relations 11/26/18 halloween decor 11/26/18 11/26/18 11/26/18 11/26/18 Pcard Usage halloween halloween halloween halloween Employee Relations 5,000.00 Budgeted Software & Support Internet -November Microsoft exchange Annual software support 2019 internet internet internet internet adobe - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 - 11/26/18 decor decor decor s candy Totals: 4,947.61 Remaining Software & Support Totals: 77,849.00 Budgeted O % Used 1 % Used 61,104.08 9,737.05 Remaining 87 % Used .00 .00 4.87 12.97 7.58 26.97 8.86 (8.86) 52.39 .00 .00 _ 4.87 MICHAELS STORES 5062 17.84 JOANN STORES #2035 25.42 DOLLAR TREE 52.39 WAL-MART #0266 61.25 DOLLAR GENERAL #12244 52.39 903.72 62,007.80 504.00 62,511.80 5,180.75 67,692.55 69.12 67,761.67 107.79 67,869.46 124.34 67,993.80 85.70 68,079.50 32.45 68,111.95 7,007.87 Charter Communications M3 Networks MCCI ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE INC 68,111.95 ** PC PC PC PC PC GL 4713 AP 4758 AP 4760 AP PC PC PC PC PC glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 35 Check Source Number Account: 135-55070-030-000 Independent Labor _ 371 11/30/2018 November A/P 371 11/30/2018 November A/P 371 11/30/2018 November A/P GM November GM November Audist consulting 11,666.14 29.43 9,680.00 1,991.33 11,695.57 21,375.57 23,366.90 Carman Consulting LLC. Carman Consulting LLC. DOROTHY RENAE GONZALES 4786 4786 4789 AP AP AP Account: 135-55070-030-000 Independent Labor Totals: 11,700.76 23,366.90 ** 175,000.00 Budgeted 151,633.10 Remaining 13 % Used Account: 135-55080-030-000 Maintenance & Repairs 315.00 .00 315.00 Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 315.00 ** 20,000.00 Budgeted 19,685.00 Remaining 2 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 302 11/26/2018 November A/P October janitorial 869.06 869.06 MEMBER'S BUILDING MAINTENANCE 4778 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 869.06 ** 10,000.00 Budgeted 9,130.94 Remaining 9 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 66,055.00 Budgeted 66,055.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 398 11/30/2018 November A/P November billings 579.29 580.27 1,159.56 DATAPROSE LLC AP Account: 135-55205-030-000 Utility Billing Contract Totals: 580.27 1,159.56 ** 9,000.00 Budgeted 7,840.44 Remaining 13 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-60005-030-000 218 11/07/2018 324 11/26/2018 324 11/26/2018 324 11/26/2018 324 11/26/2018 400 11/30/2018 Account: 135-60005-030-000 JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Telephone November A/P answering service -November Pcard 10/27/18 - 11/26/18 phone Pcard 10/27/18 - 11/26/18 phone Pcard 10/27/18 - 11/26/18 phone Pcard 10/27/18 - 11/26/18 phone Town Billed Invoices 1664-1667 AR 20181130-20181130 User: Telephone 23,500.00 Budgeted Account: 135-60010-030-000 255 11/15/2018 November A/P 234 11/16/2018 MUD Payroll 11/16/2018 Account: 135-60010-030-000 Totals: 20,520.54 Remaining Communications/Mobiles cell phones -November Communications/Mobiles Communications/Mobiles Totals: 4,000.00 Budgeted 3,525.02 Remaining 1,423.08 237.49 13 % Used 12 % Used Program: Transaction Detail 207.75 192.68 861.43 461.53 12.99 (180.00) 1,556.38 87.49 150.00 237.49 Transaction Vendor_Name Detail (SUBTOTAL) 1,630.83 1,823.51 2,684.94 3,146.47 3,159.46 2,979.46 KEYSTONE PARK SECRETARIAL ATT*SILL PAYMENT ATT*BUS PHONE PMT ATT*SUS PHONE PMT RINGCENTRAL, INC 2,979.46 ** 324.98 VERIZON WIRELESS 474.98 474.98 ** Page 36 Check Source Number 4725 AP PC PC PC PC AR 4769 AP PR Account: 135-60020-030-000 Electricity/Gas Account: 135-60020-030-000 Account: 135-60025-030-000 371 11/30/2018 November A/P Electricity/Gas 8,690.00 Budgeted Totals: 8,132.29 Remaining 557.71 6 % Used .00 .00 557.71 557.71 ** Water Water -November 400 11/30/2018 Town Billed Invoices 1664-1667 AR 20181130-20181130 User: Account: 135-60025-030-000 Account: 135-60035-030-000 398 11/30/2018 November A/P Account: 135-60035-030-000 Account: 135-60040-030-000 2,000.00 Budgeted Postage Postage 30,000.00 Budgeted November billings Service Charges 4 Fees Totals: 1,892.60 Remaining Totals: 26,654.61 Remaining 48.39 118.02 166.41 TROPHY CLUB MUD (WATER BILLS) (59.01) 107.40 1,727.44 5 6 Used 11 % Used 59.01 1,617.95 1,617.95 107.40 ** 3,345.39 DATAPROSE LLC 3,345.39 ** 4808 AP AR AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 143 11/02/2018 Child Support Fee 236 11/16/2018 Child Support Fee 306 11/30/2018 Child Support Fee 371 11/30/2018 November A/P 376 11/30/2018 Pace Credit Card Fees 376 11/30/2018 Pace Credit Card Fees 399 11/30/2018 November A/P Account: 135-60040-030-000 Direct send fees Service fees Service Charges & Fees Totals: 55,560.00 Budgeted 43,327.63 Remaining Account: 135-60050-030-000 Bad Debt Expense 6,899.27 1.50 6,900.77 GL 1.50 6,902.27 GL 1.50 6,903.77 GL 50.00 6,953.77 Fisery Solutions, LLC 4792 AP 4,948.26 11,902.03 GL 138.44 12,040.47 GL 191.90 12,232.37 Texas Excavation Safety System AP 22 % Used Account: 135-60050-030-000 Bad Debt Expense Totals: 1,500.00 Budgeted 1,500.00 Remaining 0 % Used 5,333.10 12,232.37 ** .00 .00 .00 .00 ** Account: 135-60055-030-000 Insurance 126 11/01/2018 Insurance/Nrk Comp Expense Nov 6,302.73 6,302.73 12,605.46 GL Account: 135-60055-030-000 Insurance Totals: 6,302.73 12,605.46 ** 65,000.00 Budgeted 52,394.54 Remaining 19 % Used Account: 135-60066-030-000 Account: 135-60066-030-000 Account: 135-60070-030-000 Account: 135-60070-030-000 Account: 135-60075-030-000 Publications/Books/Subscripts .00 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining 0 % Used .00 .00 .00 ** Dues & Memberships 200.00 .00 200.00 Dues & Memberships Totals: .00 200.00 ** 6,000.00 Budgeted Meetings 5,800.00 Remaining 3 % Used .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60075-030-000 Meetings Totals: 400.00 Budgeted Account: 135-60079-030-000 Public Education Account: 135-60079-030-000 400.00 Remaining 0 % Used Public Education Totals: 6,000.00 Budgeted Account: 135-60080-030-000 Schools & Training Account: 135-60080-030-000 Account: 135-60100-030-000 Account: 135-60100-030-000 6,000.00 Remaining 0 % Used Schools & Training Totals: 8,950.00 Budgeted 8,950.00 Remaining 0 % Used Travel & per diem Travel & per diem Totals: 4,345.00 Budgeted Account: 135-60110-030-000 Physicals/Testing Account: 135-60110-030-000 4,345.00 Remaining 0 8 Used Physicals/Testing Totals: 200.00 Budgeted Account: 135-60125-030-000 Advertising Account: 135-60125-030-000 200.00 Remaining 0 % Used Advertising Totals: 25,000.00 Budgeted 25,000.00 Remaining 0 5 Used Account: 135-60235-030-000 Security 302 11/26/2018 November A/P monitoring service .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** 24.00 24.00 48.00 Digital Air Control, Inc 4774 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60235-030-000 Security Totals: 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 1,240.00 Remaining 4 % Used Miscellaneous Expenses Totals: 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency Account: 135-60246-030-000 General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining 500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Account: 135-65010-030-000 Uniforms Account: 135-65010-030-000 Uniforms Totals: 2,050.00 Budgeted 0 % Used 0 % Used 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 324 11/26/2018 Pcard 10/27/18 - 11/26/18 fans, battery, capacitor 324 11/26/2018 Pcard 10/27/18 - 11/26/18 inspection 324 11/26/2018 Pcard 10/27/18 - 11/26/18 recording server Account: 135-65055-030-000 24.00 .00 48.00 ** .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** 672.76 672.76 LEIGHTRONIX INC PC 250.00 922.76 LEIGHTRONIX INC PC 323.73 1,246.49 THE UPS STORE #3653 PC Hardware Totals: 1,246.49 1,246.49 ** 7,064.00 Budgeted Account: 135-65085-030-000 Office Supplies 5,817.51 Remaining 18 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 302 11/26/2018 November A/P 302 11/26/2018 November A/P 302 11/26/2018 November A/P 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 398 11/30/2018 November A/P 398 11/30/2018 November A/P 398 11/30/2018 November A/P 398 11/30/2018 November A/P Account: 135-65085-030-000 - 11/26/18 - 11/26/18 - 11/26/18 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Business cards -mike, steven, d office supplies Return of file boxes plates lifecam studio for business battery backups office supplies office supplies office supplies office supplies Office Supplies Totals: 6,000.00 Budgeted 9,775.99 Remaining 474.06 20 % Used Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 216.85 690.91 176.05 866.96 (74.16) 792.80 20.00 812.80 49.80 862.60 148.00 1,010.60 94.14 1,104.74 5.86 1,110.60 44.99 1,155.59 68.97 1,224.56 750.50 SIGMA SIGNS & PRINTING OFFICE DEPOT, INC OFFICE DEPOT, INC KELLER TROPHY & AWAR AMZN MKTP US*M81UU3YC1 AMZN MKTP US*M85KN67O2 OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC 1,224.56 ** Page 40 Check Source Number 4783 AP 4779 AP 4779 AP PC PC PC AP AP AP AP Account: 135-65090-030-000 Printer Supplies & Maintenance Account: 135-65090-030-000 Account: 135-65095-030-000 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 324 11/26/2018 Pcard 10/27/18 Account: 135-65095-030-000 Printer Supplies & Maintenance Totals: 3,500.00 Budgeted 3,500.00 Remaining .00 0 % Used .00 .00 .00 Maintenance Supplies 11/26/18 11/26/18 11/26/18 11/26/18 11/26/18 11/26/18 febreeze cleaning supplies, paper goods coffee supplies coffee supplies cleaning supplies coffee supplies Maintenance Supplies Totals: 4,000.00 Budgeted 3,185.25 Remaining 444.04 20 % Used 34.45 175.62 19.23 27.44 12.76 101.21 370.71 478.49 654.11 673.34 700.78 713.54 814.75 SAMSCLUB #6781 SAMSCLUB.COM AMZN MKTP US*M8ONS6Y10 AMZN MKTP US*M854Y9IQ0 WAL-MART #2834 AMZN MKTP US*M88R38M30 814.75 ** PC PC PC PC PC PC Account: 135-65105-030-000 Printing Account: 135-65105-030-000 Printing 2,500.00 Budgeted Totals: 2,500.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-69005-030-000 Capital Outlays .00 .00 glpdatb2 skrolczyk 17:08 12/12/18 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 41 Check Source Number Department 30 Totals: 94,460.39 Monthly Total 208,518.88 ** 1,559,905.00 Budgeted 1,351,386.12 Remaining 13 % Used Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** 280,000.00 Budgeted 280,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 302 11/26/2018 November A/P 302 11/26/2018 November A/P copies Copier Lease -Nov 293.89 84.35 194.00 378.24 572.24 KYOCERA DOCUMENT SOLUTIONS TIAA COMMERCIAL FINANCE 4776 4784 AP AP Account: 135-69170-030-000 Copier Lease Installments Totals: 278.35 572.24 ** 4,000.00 Budgeted 3,427.76 Remaining 14 % Used Department 30 Totals: 94,460.39 Monthly Total 208,518.88 ** 1,559,905.00 Budgeted 1,351,386.12 Remaining 13 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2018 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 398 11/30/2018 November A/P legal 11,839.68 4,110.00 15,949.68 McLean & Howard, L.L.P. AP 398 11/30/2018 November A/P Legal 1,125.00 17,074.68 McLean & Howard, L.L.P. AP Account: 135-55045-039-000 Legal Totals: 5,235.00 17,074.68 ** 137,000.00 Budgeted 119,925.32 Remaining 12 % Used Account: 135-55055-039-000 Auditing Account: 135-55055-039-000 5,000.00 .00 5,000.00 Auditing Totals: .00 5,000.00 ** 30,800.00 Budgeted Account: 135-55060-039-000 Appraisal Account: 135-55060-039-000 Account: 135-55065-039-000 Account: 135-55065-039-000 25,800.00 Remaining 16 % Used .00 .00 Appraisal Totals: .00 .00 ** 11,714.00 Budgeted 11,714.00 Remaining 0 % Used Tax Admin Fees Tax Admin Fees Totals: 4,800.00 Budgeted 4,800.00 Remaining 0 % Used .00 .00 .00 .00 ** Department 39 Totals: 22,074.68 ** Fund 135 Totals: 5,235.00 Monthly Total 184,314.00 Budgeted 162,239.32 Remaining 12 % Used 106,813.12 (2,685.51) Monthly Total (341,837.00) Budgeted (448,650.12) Remaining -31 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 11/2018 Beginning Balance Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 43 Check Source Number Department Totals: Fund 137 Totals: .00 Budgeted .00 Monthly Total .00 Monthly Total 81,420.00 Remaining 0 o Used .00 Budgeted .00 Budgeted (186,420.00) ** 186,420.00 Remaining 0 % Used (186,420.00) 186,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund (105,000.00) .00 (105,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,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) ** Department Totals: Fund 137 Totals: .00 Budgeted .00 Monthly Total .00 Monthly Total 81,420.00 Remaining 0 o Used .00 Budgeted .00 Budgeted (186,420.00) ** 186,420.00 Remaining 0 % Used (186,420.00) 186,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET NOVEMBER 2018 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS 517 CONSTRUCTION FUND LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,434,911 TOTAL LIABILITIES 1,434,911 FUND BALANCE ASSIGNED FUND BALANCE (1,479,465) NET REVENUES / EXPENDITURES 44,554 TOTAL FUND BALANCE (1,434,911) TOTAL LIABILITIES AND FUND BALANCE glbase_tbam skrolczyk 17:08 12/12/18 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2018 Amended Total Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 14 517-49010-000-000 Interest Income 7.29- 7.29 Subtotal: 7.29- 7.29 Program number: 7.29- 7.29 Department number: Revenues 7.29- 7.29 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 11/2018 Adopted Amended Total Budget Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 15 517-49141-020-000 Interfund Transfers In Gen 122,777.00- 122,777.00 Subtotal: 122,777.00- 122,777.00 Program number: 122,777.00- 122,777.00 Department number: Wastewater 122,777.00- 122,777.00 Revenues Subtotal 122,784.29- 122,784.29 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 11/2018 Adopted Amended Total Budget Budget Encumb. Current Month Program: YTD Total % of Budget Remaining Budget Page 16 517-69005-020-000 Capital Outlays 35,568.08 78,230.58 78,230.58 - Subtotal: 35,568.08 78,230.58 78,230.58 - Program number: 35,568.08 78,230.58 78,230.58 - Department number: Wastewater 35,568.08 78,230.58 78,230.58 - Expenditures Subtotal 35,568.08 78,230.58 78,230.58 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 35,568.08 44,553.71- 44,553.71 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/2018 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 Account: 517-49010-000-000 Department Totals: (7.29) .00 (7.29) Interest Income Totals: .00 (7.29) ** .00 Budgeted 7.29 Remaining 0 % Used .00 Monthly Total .00 Budgeted (7.29) ** 7.29 Remaining 0 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 517 2014 MUD 1 Tax Bond Const WWTP JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 11/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 45 Check Source Number Department 20 Totals: Fund 517 Totals: .00 Budgeted 35,568.08 Monthly Total 35,568.08 Monthly Total (78,230.58) Remaining 0 % Used .00 Budgeted .00 Budgeted (44,546.42) ** 44,546.42 Remaining 0 % Used (44,553.71) 44,553.71 Remaining 0 % Used Account: 517-49141-020-000 Interfund Transfers In Gen (122,777.00) .00 (122,777.00) Account: 517-49141-020-000 Interfund Transfers In Gen Totals: .00 (122,777.00) ** .00 Budgeted 122,777.00 Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 371 11/30/2018 November A/P 399 11/30/2018 November A/P WWTP Improvements 42,662.50 WWTP Improvements 24,590.79 10,977.29 67,253.29 78,230.58 WEBBER-CADAGUA PARTNERS CP&Y/WALLACE GROUP, INC. 4814 AP AP Account: 517-69005-020-000 Capital Outlays Totals: 35,568.08 78,230.58 ** Department 20 Totals: Fund 517 Totals: .00 Budgeted 35,568.08 Monthly Total 35,568.08 Monthly Total (78,230.58) Remaining 0 % Used .00 Budgeted .00 Budgeted (44,546.42) ** 44,546.42 Remaining 0 % Used (44,553.71) 44,553.71 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET NOVEMBER 2018 CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 519 REVENUE BOND ASSETS CONSTRUCTION 767,358 TOTAL ASSETS 767,358 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 754,200 NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 754,200 TOTAL LIABILITIES AND FUND BALANCE 767,358 TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET NOVEMBER 2018 MIr Icm.i 1.17«[ n[7rN[T 520 SWIFT REVENUE ASSETS BONDI&S CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 45,000 TOTAL ASSETS 45,000 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 411,246 TOTAL LIABILITIES 411,246 FUND BALANCE ASSIGNED FUND BALANCE (366,246) NET REVENUES / EXPENDITURES TOTAL FUND BALANCE (366,246) TOTAL LIABILITIES AND FUND BALANCE 45,000 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET NOVEMBER 2018 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TRSPry COLIC, nnrnicmAL In:LCTY DE TNC7 528 REVENUE BOND ASSETS RESERVE 639,210 TOTAL ASSETS 639,210 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 606,910 32,300 639,210 TOTAL LIABILITIES AND FUND BALANCE 639,210 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 528 2015 Revenue Bond Reserve Fund Department: Account Description 528-49010-000-000 528-49142-000-000 528-49143-000-000 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund Trophy Club MUD No.1 Page 17 Budget Summary with Amendment Program: Period Ending: 11/2018 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 5,000.00- 5,000.00- 55,193.00- 55,193.00- 125,187.00- 125,187.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 1,129.97- 4,600.00- 10,432.00- 2,235.92- 9,200.00- 20,864.00- 16,161.97- 32,299.92- 16,161.97- 32,299.92- 16,161.97- 16,161.97- 16,161.97- 32,299.92- 32,299.92- 32,299.92- 44.718 16.669 16.666 17.424 2,764.08- 45,993.00- 104,323.00- 153,080.08- 17.424 153,080.08- 17.424 17.424 17.424 153,080.08- 153,080.08- 153,080.08- glpdatb2 skrolczyk 17:08 12/12/18 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 528-49010-000-000 Interest Income 379 11/30/2018 Bank Interest- November Account: 528-49010-000-000 Interest Income (5,000.00) Budgeted Trophy Club MUD No.1 Page 46 Detailed Accounting Trial Balance Program: Period Ending: 11/2018 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (1,105.95) (1,129.97) (2,235.92) GL Totals: (1,129.97) (2,235.92) ** (2,764.08) Remaining 45 6 Used Account: 528-49142-000-000 Interfund transfer in -Water 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (55,193.00) Budgeted (45,993.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 235 11/30/2018 TexPool Transfers November TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (4,600.00) (4,600.00) (9,200.00) GL 17 % Used (10,432.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (104,323.00) Remaining (4,600.00) (9,200.00) ** (10,432.00) (20,864.00) GL 17 % Used (16,161.97) Monthly Total (185,380.00) Budgeted (16,161.97) Monthly Total (185,380.00) Budgeted (10,432.00) (20,864.00) ** (32,299.92) ** (153,080.08) Remaining 17 % Used (32,299.92) (153,080.08) Remaining 17 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET NOVEMBER 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 116,821 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 651,739 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 773,133 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 651,739 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 651,739 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 68,105 TOTAL FUND BALANCE 121,394 TOTAL LIABILITIES AND FUND BALANCE 773,133 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I Trophy Club MUD No.1 Page 18 Budget Summary with Amendment Department: Revenues Program: Period Ending: 11/2018 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 687,175.00- 1,800.00- 2,000.00- 687,175.00- 1,800.00- 2,000.00- 35,056.03- 145.52- 24.88- 45,674.43- 318.36- 46.49- 6.647 17.687 2.325 641,500.57- 1,481.64- 1,953.51 - Subtotal: 690,975.00- 690,975.00- 35,226.43- 46,039.28- 6.663 644,935.72- 533-49010-000-000 1 533-49015-000-000 Interest Income Lease/Rental Income 2,000.00- 215,979.00- 2,000.00- 215,979.00- 146.45- 237.93- 11.897 1,762.07- 215,979.00- 533-49141-000-000 Interfund Trans In -PID Surchg 120,053.00- 120,053.00- 10,913.90- 21,827.80- 18.182 98,225.20 - Subtotal: 338,032.00- 338,032.00- 11,060.35- 22,065.73- 6.528 315,966.27 - Program number: 1,029,007.00- 1,029,007.00- 46,286.78- 68,105.01- 6.619 960,901.99 - Department number: Revenues 1,029,007.00- 1,029,007.00- 46,286.78- 68,105.01- 6.619 960,901.99 - Revenues Subtotal 1,029,007.00- 1,029,007.00- 46,286.78- 68,105.01- 6.619 960,901.99- glbase_tbam skrolczyk 17:08 12/12/18 Fund: 533 MUD 1 I&S Consolidated Account 1 533-70005-051-000 Description Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 11/2018 Adopted Amended Total Budget Budget Encumb. 2,150.00 2,150.00 Current Month Program: YTD Total % of Remaining Budget Budget 2,150.00 Page 19 533-70025-051-000 1 533-70035-051-000 Bond Interest Expense -Tax Bond Principal Payment -Tax 266,058.00 755,000.00 266,058.00 755,000.00 266,058.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 1,023,208.00 1,023,208.00 Department number: Administration 1,023,208.00 1,023,208.00 1,023,208.00 Expenditures Subtotal 1,023,208.00 1,023,208.00 1,023,208.00 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 46,286.78- 68,105.01- 1,174.427 62,306.01 glpdatb2 skrolczyk Trophy Club MUD No.1 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Number Date Description Description/Comment Balance Detail Detail (SUBTOTAL) Page 47 Check Source Number Account: 533-40000-000-000 Property Taxes 342 11/01/2018 Property Taxes 343 11/02/2018 Property Taxes 344 11/05/2018 Property Taxes 345 11/06/2018 Property Taxes 346 11/07/2018 Property Taxes 347 11/08/2018 Property Taxes 348 11/09/2018 Property Taxes 349 11/13/2018 Property Taxes 350 11/14/2018 Property Taxes 351 11/15/2018 Property Taxes 352 11/16/2018 Property Taxes 353 11/19/2018 Property Taxes 354 11/20/2018 Property Taxes 355 11/21/2018 Property Taxes 356 11/26/2018 Property Taxes 357 11/27/2018 Property Taxes 358 11/28/2018 Property Taxes 359 11/29/2018 Property Taxes 360 11/30/2018 Property Taxes (10,618.40) (799.95) (1,972.52) (964.76) (1,329.71) (2,116.22) (962.54) (1,263.30) (466.76) (1,017.70) (2,149.02) (1,523.36) (2,654.29) (1,689.84) (176.48) (3,048.43) (1,045.27) (2,379.40) (8,410.19) (1,086.29) (11,418.35) (13,390.87) (14,355.63) (15,685.34) (17,801.56) (18,764.10) (20,027.40) (20,494.16) (21,511.86) (23,660.88) (25,184.24) (27,838.53) (29,528.37) (29,704.85) (32,753.28) (33,798.55) (36,177.95) (44,588.14) (45,674.43) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (35,056.03) (45,674.43) ** (687,175.00) Budgeted (641,500.57) Remaining 7 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 343 11/02/2018 Property Taxes 345 11/06/2018 Property Taxes 346 11/07/2018 Property Taxes 350 11/14/2018 Property Taxes 354 11/20/2018 Property Taxes 360 11/30/2018 Property Taxes (172.84) (12.04) 13.22 (100.85) (45.22) 4.18 (4.81) (184.88) (171.66) (272.51) (317.73) (313.55) (318.36) GL GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (145.52) (318.36) ** (1,800.00) Budgeted (1,481.64) Remaining 18 % Used Account: 533-40015-000-000 Property Taxes/P & I 343 11/02/2018 346 11/07/2018 360 11/30/2018 Property Property Property Taxes Taxes Taxes (21.61) (2.64) (21.18) (1.06) (24.25) (45.43) (46.49) GL GL GL Account: 533-40015-000-000 ' Property Taxes/P & I Totals: (24.88) (46.49) ** (2,000.00) Budgeted (1,953.51) Remaining 2 % Used glpdatb2 skrolczyk 17:08 12/12/18 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 11/2018 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 48 Check Source Number Department Totals: (120,053.00) Budgeted (46,286.78) Monthly Total (98,225.20) Remaining 18 % Used (1,029,007.00) Budgeted (68,105.01) ** (960,901.99) Remaining 7 % Used Account: 533-49010-000-000 Interest Income 379 11/30/2018 Bank Interest- November (91.48) (146.45) (237.93) GL Account: 533-49010-000-000 Interest Income Totals: (146.45) (237.93) ** (2,000.00) Budgeted (1,762.07) Remaining 12 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (215,979.00) Budgeted (215,979.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 235 11/30/2018 TexPool Transfers November TexPool O&M to I&S- PID Debt (10,913.90) (10,913.90) (21,827.80) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,913.90) (21,827.80) ** Department Totals: (120,053.00) Budgeted (46,286.78) Monthly Total (98,225.20) Remaining 18 % Used (1,029,007.00) Budgeted (68,105.01) ** (960,901.99) Remaining 7 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/2018 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 Account: 533-70005-051-000 Account: 533-70025-051-000 Account: 533-70025-051-000 Paying Agent Fee Totals: 2,150.00 Budgeted 2,150.00 Remaining 0 % Used Bond Interest Expense -Tax Bond Interest Expense -Tax Totals: 266,058.00 Budgeted 266,058.00 Remaining .00 .00 .00 .00 ** .00 0 % Used .00 .00 .00 ** Account: 533-70035-051-000 Bond Principal Payment -Tax Account: 533-70035-051-000 Department 51 Totals: Fund 533 Totals: Bond Principal Payment -Tax Totals: 755,000.00 Budgeted 755,000.00 Remaining .00 Monthly Total (46,286.78) Monthly Total .00 0 % Used .00 .00 .00 ** .00 ** 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used (68,105.01) (5,799.00) Budgeted 62,306.01 Remaining NNNNNNNNNN TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET NOVEMBER 2018 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Tp4PHk [ L LI nmrm [PAL MI T = 534 REVENUE BOND ASSETS I&S 128,148 TOTAL ASSETS 128,148 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 19,562 108,586 128,148 TOTAL LIABILITIES AND FUND BALANCE 128,148 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 17:08 12/12/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 1,000.00- 1,000.00- 140.29- 179.14- 17.914 820.86- 534-49143-000-000 Interfund Transfer In -WW Sales 596,238.00- 596,238.00- 54,203.45- 108,406.90- 18.182 487,831.10 - Subtotal: 597,238.00- 597,238.00- 54,343.74- 108,586.04- 18.181 488,651.96 - Program number: 597,238.00- 597,238.00- 54,343.74- 108,586.04- 18.181 488,651.96 - Department number: Revenues 597,238.00- 597,238.00- 54,343.74- 108,586.04- 18.181 488,651.96 - Revenues Subtotal 597,238.00- 597,238.00- 54,343.74- 108,586.04- 18.181 488,651.96- glbase_tbam skrolczyk 17:08 12/12/18 Fund: 534 2015 Revenue Bond I&S Account 1 534-70005-051-000 Description Rev Bond Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 11/2018 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month Program: YTD Total % of Remaining Budget Budget 400.00 Page 21 534-70040-051-000 1 534-70045-051-000 Revenue Bond Interest Expense Revenue Bond Principal Expense 215,838.00 380,000.00 215,838.00 380,000.00 215,838.00 380,000.00 Subtotal: 596,238.00 596,238.00 596,238.00 Program number: 596,238.00 596,238.00 596,238.00 Department number: Administration 596,238.00 596,238.00 596,238.00 Expenditures Subtotal 596,238.00 596,238.00 596,238.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 54,343.74- 108,586.04- ############### 107,586.04 glpdatb2 skrolczyk 17:08 12/12/18 Fund: 534 2015 Revenue Bond ISS JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 11/2018 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 50 Check Source Number Department Totals: (596,238.00) Budgeted (54,343.74) Monthly Total (487,831.10) Remaining 18 % Used (597,238.00) Budgeted (108,586.04) ** (488,651.96) Remaining 18 % Used Account: 534-49010-000-000 Interest Income 379 11/30/2018 Bank Interest- November (38.85) (140.29) (179.14) GL Account: 534-49010-000-000 Interest Income Totals: (140.29) (179.14) ** (1,000.00) Budgeted (820.86) Remaining 18 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bd WWTP ISS (54,203.45) (54,203.45) (108,406.90) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.45) (108,406.90) ** Department Totals: (596,238.00) Budgeted (54,343.74) Monthly Total (487,831.10) Remaining 18 % Used (597,238.00) Budgeted (108,586.04) ** (488,651.96) Remaining 18 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond IBS Department: 51 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 400.00 Budgeted 400.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 215,838.00 Budgeted 215,838.00 Remaining O % Used .00 .00 .00 .00 ** .00 O % Used .00 .00 .00 ** Account: 534-70045-051-000 Revenue Bond Principal Expense Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: 380,000.00 Budgeted 380,000.00 Remaining Department 51 Totals: Fund 534 Totals: .00 .00 O % Used .00 Monthly Total 596,238.00 Budgeted (54,343.74) Monthly Total .00 .00 ** .00 ** 596,238.00 Remaining 0 % Used (108,586.04) (1,000.00) Budgeted 107,586.04 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET NOVEMBER 2018 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 535 SWIFT REVENUE ASSETS BONDI&S 52,989 TOTAL ASSETS 52,989 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 2,584 50,405 52,989 TOTAL LIABILITIES AND FUND BALANCE 52,989 glbase_tbam skrolczyk 17:08 12/12/18 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49010-000-000 535-49142-000-000 Subtotal: Program number: Department number: Revenues Revenues Description Interest Income Interfund Tran In -Water Sales Subtotal Department: Adopted Budget 600.00- 276,901.00- 277,501.00- 277,501.00- 277,501.00- 277,501.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2018 Amended Total Budget Encumb. 600.00- 276,901.00- 277,501.00- 277,501.00- 277,501.00- 277,501.00 - Program: Current YTD Month Total 53.39- 59.54- 25,172.81- 50,345.62- 25,226.20- 50,405.16- 25,226.20- 50,405.16- 25,226.20- 50,405.16- 25,226.20- 50,405.16- % of Budget Remaining Budget 9.923 540.46- 18.182 226,555.38- 18.164 227,095.84- 18.164 227,095.84- 18.164 227,095.84- 18.164 227,095.84 - Page 22 glbase_tbam skrolczyk Trophy Club MUD No.1 17:08 12/12/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 11/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 23 1 535-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 1 1 535-70040-051-000 Revenue Bond Interest Expense 61,501.00 61,501.00 61,501.00 1 1 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 1 Subtotal: 276,901.00 276,901.00 276,901.00 Program number: 276,901.00 276,901.00 276,901.00 Department number: Administration 276,901.00 276,901.00 276,901.00 Expenditures Subtotal 276,901.00 276,901.00 276,901.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,226.20- 50,405.16- 8,400.860 49,805.16 1 ******* End of Report ********* glpdatb2 skrolczyk 17:08 12/12/18 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 11/2018 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 52 Check Source Number Department Totals: (276,901.00) Budgeted (25,226.20) Monthly Total (226,555.38) Remaining 18 % Used (277,501.00) Budgeted (50,405.16) ** (227,095.84) Remaining 18 % Used Account: 535-49010-000-000 Interest Income 379 11/30/2018 Bank Interest- November (6.15) (53.39) (59.54) GL Account: 535-49010-000-000 Interest Income Totals: (53.39) (59.54) ** (600.00) Budgeted (540.46) Remaining 10 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 235 11/30/2018 TexPool Transfers November TexPool O&M to 16Swift Rev I&S (25,172.81) (25,172.81) (50,345.62) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.81) (50,345.62) ** Department Totals: (276,901.00) Budgeted (25,226.20) Monthly Total (226,555.38) Remaining 18 % Used (277,501.00) Budgeted (50,405.16) ** (227,095.84) Remaining 18 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: 400.00 Budgeted 400.00 Remaining Account: 535-70040-051-000 Revenue Bond Interest Expense Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 61,501.00 Budgeted 61,501.00 Remaining .00 .00 Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 215,000.00 Budgeted 215,000.00 Remaining 0 % Used .00 ** 0 % Used .00 .00 .00 .00 ** .00 .00 Account: 535-70045-051-000 Revenue Bond Principal Expense 0 % Used Department 51 Totals: Fund 535 Totals: Grand Totals: .00 Monthly Total 276,901.00 Budgeted (25,226.20) Monthly Total 276,901.00 Remaining 0 % Used (50,405.16) (600.00) Budgeted 49,805.1.6 Remaining NNNNNNNNNN (164,938.83) Monthly Total ******* End of Report ********* (190,666.80) **** (1,209,068.00) Budgeted (1,018,401.20) Remaining 16 % Used