Loading...
HomeMy WebLinkAbout2018-12 December Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET DECEMBER 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 801,219 PREPAID EXPENSES 13,421 ADVALOREM PROPERTY TAXES RECEIVABLE 480,806 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,295,446 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 480,806 TOTAL LIABILITIES 480,806 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 543,884 270,756 814,640 1,295,446 glbase_tbam skrolczyk 14:57 01/17/19 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: 12/2018 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,117,000.00- 1,117,000.00- 577,538.60- 63.06 70.48- 651,773.33- 439.35- 198.44- 58.350 465,226.67- 439.35 198.44 Subtotal: 1,117,000.00- 1,117,000.00- 577,546.02- 652,411.12- 58.407 464,588.88- 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- 577,546.02- 652,411.12- 54.732 539,588.88 - Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 577,546.02- 652,411.12- 54.732 539,588.88 - Revenues Subtotal 1,192,000.00- 1,192,000.00- 577,546.02- 652,411.12- 54.732 539,588.88- glbase_tbam skrolczyk 14:57 01/17/19 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: 12/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 112,408.66 4,473.63 168,612.66 24.854 215,979.00 13,526.37 168,612.66 - Page 2 Subtotal: 233,979.00 233,979.00 113,899.87 173,086.29 73.975 60,892.71 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 113,899.87 381,654.89 73.743 135,893.11 Department number: Fire 517,548.00 517,548.00 113,899.87 381,654.89 73.743 135,893.11 Expenditures Subtotal 517,548.00 517,548.00 113,899.87 381,654.89 73.743 135,893.11 Fund number: 122 Trophy Club MUD Fire Dept. 674,452.00- 674,452.00- 463,646.15- 270,756.23- 40.145 403,695.77- glpdatb2 skrolczyk Trophy Club MUD No.1 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/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 513 12/03/2018 Property Taxes 514 12/04/2018 Property Taxes 515 12/05/2018 Property Taxes 516 12/06/2018 Property Taxes 517 12/07/2018 Property Taxes 518 12/10/2018 Property Taxes 519 12/11/2018 Property Taxes 520 12/12/2018 Property Taxes 521 12/13/2018 Property Taxes 522 12/14/2018 Property Taxes 523 12/17/2018 Property Taxes 524 12/18/2018 Property Taxes 525 12/19/2018 Property Taxes 526 12/20/2018 Property Taxes 527 12/21/2018 Property Taxes 528 12/26/2018 Property Taxes 529 12/27/2018 Property Taxes 530 12/28/2018 Property Taxes 531 12/31/2018 Property Taxes (74,234.73) (3,232.47) (5,288.25) (1,128.93) (5,413.37) (2,182.47) (6,457.86) (5,697.65) (4,589.32) (35,910.54) (210,876.91) (8,277.10) (9,341.71) (11,684.22) (109,439.12) (10,153.21) (11,100.44) (106,865.96) (17,586.39) (12,312.68) (77,467.20) (82,755.45) (83,884.38) (89,297.75) (91,480.22) (97,938.08) (103,635.73) (108,225.05) (144,135.59) (355,012.50) (363,289.60) (372,631.31) (384,315.53) (493,754.65) (503,907.86) (515,008.30) (621,874.26) (639,460.65) (651,773.33) 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: (577,538.60) (651,773.33) ** (1,117,000.00) Budgeted (465,226.67) Remaining 58 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 517 12/07/2018 Property Taxes 519 12/11/2018 Property Taxes 522 12/14/2018 Property Taxes 527 12/21/2018 Property Taxes 529 12/27/2018 Property Taxes 531 12/31/2018 Property Taxes (502.41) (3.83) (.40) 59.00 76.96 (.06) (68.61) (506.24) (506.64) (447.64) (370.68) (370.74) (439.35) GL GL GL GL GL GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 63.06 (439.35) ** .00 Budgeted 439.35 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 519 12/11/2018 Property Taxes 521 12/13/2018 Property Taxes 522 12/14/2018 Property Taxes 527 12/21/2018 Property Taxes 529 12/27/2018 Property Taxes (127.96) (.51) (17.15) (13.08) (3.35) (13.38) (128.47) (145.62) (158.70) (162.05) (175.43) GL GL GL GL GL glpdatb2 skrolczyk 14:58 01/17/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Period Ending: 12/2018 Beginning Balance JE Detail Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 2 Check Source Number I I 530 12/28/2018 531 12/31/2018 Property Taxes Property Taxes (127.96) (7.23) (15.78) (182.66) (198.44) GL GL Account: 122-40020-000-000 . Property Taxes/Fire P8I Totals: (70.48) (198.44) ** .00 Budgeted 198.44 Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (75,000.00) Budgeted (75,000.00) Remaining 0 % Used Department Totals: (577,546.02) Monthly Total (1,192,000.00) Budgeted (652,411.12) ** (539,588.88) Remaining 55 % Used glpdatb2 skrolczyk 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club HUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Trophy Club MUD No.1 Page 3 Account: 122-60030-045-000 Rent And/Or Usage Account: 122-60030-045-000 Rent And/Or Usage Totals: 215,979.00 Budgeted Account: 122-60055-045-000 Insurance 127 12/01/2018 Insurance/Wrk Comp Expense Dec Account: 122-60055-045-000 Account: 122-60337-045-000 420 12/17/2018 December A/P 420 12/17/2018 December A/P 215,979.00 Remaining 0 % Used .00 .00 .00 .00 ** 2,982.42 1,491.21 4,473.63 GL Insurance Totals: 1,491.21 4,473.63 ** 18,000.00 Budgeted 13,526.37 Remaining 25 % Used Transfer to Town/Fire Budget November Fire Admin -not billed December Fire Admin Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: .00 Budgeted (168,612.66) Remaining 56,204.00 56,204.33 56,204.33 112,408.33 TOWN OF TROPHY CLUB 4854 AP 168,612.66 TOWN OF TROPHY CLUB 4854 AP 112,408.66 168,612.66 ** 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 o Used Account: 122-69195-045-000 GASB34/Reserve for Replacement Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 Budgeted .00 Remaining 81,420.00 .00 81,420.00 100 8 Used .00 81,420.00 ** Account: 122-69305-045-000 Capital Leases Account: 122-69305-045-000 Capital Leases 127,149.00 Budgeted 127,148.60 .00 127,148.60 Totals: .00 127,148.60 ** .40 Remaining 100 5 Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 45 Totals: 381,654.89 ** 113,899.87 Monthly Total 517,548.00 Budgeted 135,893.11 Remaining 74 % Used Fund 122 Totals: (270,756.23) (463,646.15) Monthly Total (674,452.00) Budgeted (403,695.77) Remaining 40 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET DECEMBER 2018 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,506,321 2,506,321 CASH IN BANK -SAVINGS -CASH RESERVE 985,235 985,235 INVESTMENTS-TEXPOOL 2,777,568 782,846 3,560,414 CASH- ESCROW 361,026 361,026 PREPAID EXPENSES 80,419 80,419 ADVALOREM PROPERTY TAXES RECEIVABLE 54,642 54,642 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,988,631 1,988,631 TOTAL ASSETS 8,754,442 782,846 9,537,288 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 54,642 54,642 ACCOUNTS AND OTHER PAYABLES 594,104 594,104 CUSTOMER DEPOSITS 312,050 312,050 TOTAL LIABILITIES 960,796 960,796 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 169,461 169,461 TOTAL FUND BALANCE 7,793,646 782,846 8,576,492 TOTAL LIABILITIES AND FUND BALANCE 8,754,442 782,846 9,537,288 glbase_tbam skrolczyk 14:57 01/17/19 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 135-49901-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 Records Management Revenue 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: 12/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 65,756.37- 1.70 8.04- 65,762.71- 296,662.36- 257,963.45- 8,203.25- 1,675.00- 250.00- 750.00- 565,504.06- 9,578.67- 1,178.81- 583.33- 1,715.00- 2,168.06- 2.00- 15,225.87- 646,492.64- 646,492.64- 646,492.64 - Program: YTD Total 74,208.51- 55.84- 22.53- 74,286.88- 893,228.50- 738,089.93- 28,222.93- 4,225.00- 250.00- 750.00- 17.60- 1,664,783.96- 27,351.16- 3,863.10- 1,749.99- 1,715.00- 2,956.59- 2.00- 37,637.84- 1,776,708.68- 1,776,708.68- 1,776,708.68- % of Budget 56.055 18.613 7.510 24.359 13.535 21.628 20.689 24.853 16.667 16.667 .029 Remaining Budget 58,175.49- 244.16- 277.47- 171,983.00- 230,680.12- 5,706,255.50- 2,674,575.07- 108,195.07- 12,775.00- 1,250.00- 3,750.00- 59,982.40- 16.271 8,566,783.04- 136.756 27.309 25.000 9.259 42.237 49.092 16.741 16.741 16.741 7,351.16 10,282.90- 5,250.01- 10,000.00- 16,807.00- 4,043.41- 2.00 0,282.90 -5,250.01-10,000.00-16,807.00- 4,043.41- 2.00 39,030.16- 8,836,493.32- 8,836,493.32- 8,836,493.32- Page 9,030.16-8,836,493.32-8,836,493.32- 8,836,493.32- Page 3 glbase_tbam skrolczyk 14:57 01/17/19 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: 12/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 22,827.14 658.00 175.00 2,188.56 2,948.80 213.65 35.92 444.22 1,446.86 338.38 930.94 32,207.47 7,650.32 68.75 220.00 7,939.07 285.54 7,272.32 118,137.74 25,172.81 4,600.00 Program: YTD Total % of Budget 68,568.29 20.985 2,514.04 12.570 3,620.00 100.000 575.00 11.979 8,014.47 24.065 8,846.40 11.824 640.95 14.847 107.76 15.372 857.44 27.385 4,618.20 20.972 1,080.06 20.972 2,792.82 21.658 102,235.43 19.925 12,967.61 12.968 943.00 31.433 854.18 17.084 827.70 12.734 15,592.49 10.888 1,023.77 20.475 26,200.99 16.991 411.00 8.837 7,685.65 13.251 254,645.37 8.450 2,090.00 14.169 75,518.43 12.905 13,800.00 25.003 Remaining Budget 258,186.71 17,485.96 4,225.00 25,289.53 65,971.60 3,676.05 593.24 2,273.56 17,402.80 4,069.94 1,080.00 10,102.18 200.00 300.00 410,856.57 20,000.00 87,032.39 2,057.00 4,145.82 3,500.00 5,214.00 5,672.30 127,621.51 3,976.23 128,003.01 1,000.00 500.00 4,240.00 400.00 2,345.00 1,500.00 50,314.35 2,758,848.63 200.00 3,000.00 12,660.00 509,690.57 41,393.00 200,000.00 Page 4 glbase_tbam skrolczyk 14:57 01/17/19 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: 12/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 Program: YTD Total 155,468.41 381,375.21 716.01 2,292.90 1,417.41 893.45 5,575.88 11,250.00 11,305.80 12,859.46 20,591.99 26,575.00 57,192.60 75,000.00 57,932.73 26,575.00 190,125.33 235,049.41 709,920.45 % of Budget 9.297 15.286 27.310 27.879 16.151 10.327 12.625 100.000 48.277 27.870 12.588 Remaining Budget 2,500.00 3,720,570.79 12,707.10 3,772.59 14,424.12 1,200.00 1,000.00 58,694.20 87,000.00 178,798.01 395,807.40 30,068.00 4,124.00 62,067.27 492,066.67 4,929,913.55 Page 5 glbase_tbam skrolczyk 14:57 01/17/19 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: 12/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 447.70 22.385 447.70 22.385 447.70 235,129.41 710,368.15 22.385 12.591 1,552.30 1,552.30 1,552.30 4,931,465.85 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 14:57 01/17/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 26,221.22 78,638.45 18.648 343,060.55 135-50010-020-000 Overtime 30,000.00 30,000.00 1,818.30 8,443.79 28.146 21,556.21 135-50016-020-000 Longevity 7,445.00 7,445.00 7,445.00 100.000 135-50017-020-000 Certification 8,700.00 8,700.00 650.00 2,050.00 23.563 6,650.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,653.78 10,450.09 24.148 32,825.91 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,215.37 15,940.98 17.398 75,686.02 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 371.89 1,115.67 21.859 3,988.33 135-50028-020-000 Vision Insurance 826.00 826.00 58.90 176.70 21.392 649.30 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 400.31 1,006.71 22.396 3,488.29 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 1,627.42 5,596.07 19.293 23,409.93 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 380.60 1,308.76 19.292 5,475.24 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 3,617.19 21.352 13,323.81 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 38.00 38.00 9.500 362.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 667,863.00 667,863.00 40,641.52 135,827.41 20.338 532,035.59 135-55005-020-000 Engineering 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 6,362.15 623.50 10.24 27.77 6,814.93 3,283.65 20,393.08 623.50 156.20 27.77 21,590.18 10,775.57 23.174 6.235 1.953 1.851 28.787 30.787 30,000.00 15,000.00 67,606.92 9,376.50 7,843.80 1,472.23 5,214.00 53,409.82 24,224.43 Subtotal: 267,714.00 267,714.00 17,122.24 53,566.30 20.009 214,147.70 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 135-60020-020-000 Electricity 174,165.00 174,165.00 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 30,000.00 30,000.00 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 368.98 12,433.67 200.00 218.20 10,913.90 1,122.66 37,730.40 22.453 21.664 69.00 23.000 111.00 1.551 16,545.22 225.18 590.00 32,741.70 55.151 4.504 5.086 27.273 3,877.34 136,434.60 200.00 231.00 7,044.00 1,000.00 1,895.00 5,000.00 2,500.00 13,454.78 450.00 4,774.82 11,010.00 87,311.30 glbase_tbam skrolczyk 14:57 01/17/19 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: 12/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 162,610.35 23.624 10,432.00 31,296.00 24.999 122,777.00- 34,006.80- 283,041.51 20.490 792.33 3,382.96 27.064 89.24 1,978.73 36.010 1,055.82 1,591.82 5.306 14.97 1.248 552.18 46.015 24.46 2,460.23 12.301 1,961.85 9,980.89 14.178 44,200.32 13.394 30,000.00 100.000 74,200.32 15.306 25,718.81 556,616.43 19.380 25,718.81 556,616.43 19.380 Remaining Budget 525,719.65 93,891.00 200,000.00 3,500.00 1,098,293.49 9,117.04 3,516.27 28,408.18 1,185.03 647.82 17,539.77 60,414.11 285,799.68 109,858.00 14,917.00 410,574.68 2,315,465.57 2,315,465.57 Page 8 glbase_tbam skrolczyk 14:57 01/17/19 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 12/2018 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 2.12 Program: YTD Total 6.36 % of Remaining Budget Budget 21.200 23.64 Page 9 Subtotal: 30.00 30.00 2.12 6.36 21.200 23.64 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem 150.00 750.00 1,300.00 4,000.00 5,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 650.00 270.00 650.00 565.00 86.667 14.125 150.00 100.00 1,300.00 3,435.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 920.00 1,215.00 9.205 11,985.00 Program number: 13,230.00 13,230.00 922.12 1,221.36 9.232 12,008.64 Department number: Board of Directors 13,230.00 13,230.00 922.12 1,221.36 9.232 12,008.64 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 14:57 01/17/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 135-50010-030-000 135-50016-030-000 135-50020-030-000 135-50026-030-000 135-50027-030-000 135-50028-030-000 135-50029-030-000 135-50030-030-000 135-50035-030-000 135-50040-030-000 135-50045-030-000 135-50060-030-000 135-50070-030-000 Salaries & Wages Overtime Longevity 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 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 28,288.94 4.13 2,617.11 4,145.24 259.52 42.51 588.64 1,675.51 391.84 106.55 2,767.66 84,078.53 10.45 1,832.50 9,307.94 12,435.72 778.56 127.53 1,135.62 5,129.14 1,199.56 319.65 2,820.05 19.065 356,927.47 .523 1,989.55 99.973 .50 22.621 31,840.06 15.185 69,459.28 18.144 3,512.44 18.193 573.47 25.264 3,359.38 18.597 22,450.86 18.598 5,250.44 1,260.00 975.35 500.00 2,179.95 24.683 56.401 Subtotal: 619,454.00 619,454.00 40,887.65 119,175.25 19.239 500,278.75 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleaning Services Professional Outside Services Utility Billing Contract 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 49,991.36- 11,811.99 480.00 869.06 59,205.00 582.83 18,120.59 35,178.89 795.00 1,738.12 59,205.00 1,742.39 23.277 20.102 3.975 17.381 89.630 19.360 59,728.41 139,821.11 19,205.00 10,000.00 8,261.88 6,850.00 7,257.61 Subtotal: 367,904.00 367,904.00 22,957.52 116,779.99 31.742 251,124.01 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60125-030-000 135-60235-030-000 Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Advertising Security 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 1,519.50 237.49 53.86 1,618.98 5,922.16 6,302.73 3,601.25 24.00 4,498.96 712.47 557.71 161.26 4,964.37 18,154.53 19.145 17.812 6.418 8.063 16.548 32.676 18,908.19 29.090 3,801.25 63.354 72.00 5.590 19,001.04 3,287.53 8,132.29 1,838.74 25,035.63 37,405.47 1,500.00 46,091.81 1,000.00 2,198.75 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,216.00 glbase_tbam skrolczyk 14:57 01/17/19 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: 12/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 19,279.97 51,830.74 19.675 211,602.26 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 671.56 189.01 1,246.49 1,896.12 1,003.76 17.646 31.602 25.094 2,050.00 5,817.51 4,103.88 3,500.00 2,996.24 2,500.00 Subtotal: 25,114.00 25,114.00 860.57 4,146.37 16.510 20,967.63 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 261.72 833.96 20.849 3,166.04 Subtotal: 284,000.00 284,000.00 261.72 833.96 .294 283,166.04 Program number: 1,559,905.00 1,559,905.00 84,247.43 292,766.31 18.768 1,267,138.69 Department number: Administration 1,559,905.00 1,559,905.00 84,247.43 292,766.31 18.768 1,267,138.69 glbase_tbam skrolczyk 14:57 01/17/19 Fund: 135 MUD 1 General Fund Account 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Description Legal Auditing,. Appraisal Tax Admin Fees Subtotal: Program number: Department number: Non Departmental Expenditures Subtotal Fund number: 135 MUD 1 General Fund Department: Adopted Budget 137,000.00 30,800.00 11,714.00 4,800.00 Trophy Club MUD No.1 Budget Summary with Amendment 39 Non Departmental Period Ending: 12/2018 Amended Total Budget Encumb. 137,000.00 30,800.00 11,714.00 4,800.00 184,314.00 184,314.00 184,314.00 184,314.00 184,314.00 184,314.00 10,271,365.00 10,271,365.00 341,837.00- 341,837.00 - Current Month 6,075.00 9,750.00 4,723.22 3,653.00 24,201.22 24,201.22 24,201.22 370,218.99 276,273.65 - Program: YTD Total 23,149.68 14,750.00 4,723.22 3,653.00 46,275.90 46,275.90 46,275.90 1,607,248.15 169,460.53- % of Budget 16.898 47.890 40.321 76.104 25.107 25.107 25.107 15.648 49.573 Remaining Budget 113,850.32 16,050.00 6,990.78 1,147.00 138,038.10 138,038.10 138,038.10 8,664,116.85 172,376.47 - Page 12 glbase_tbam skrolczyk 14:57 01/17/19 Fund: 137 MUD 1 Consolidated GASB Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 12/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 14:58 01/17/19 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: 12/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 513 12/03/2018 Property Taxes 514 12/04/2018 Property Taxes 515 12/05/2018 Property Taxes 516 12/06/2018 Property Taxes 517 12/07/2018 Property Taxes 518 12/10/2018 Property Taxes 519 12/11/2018 Property Taxes 520 12/12/2018 Property Taxes 521 12/13/2018 Property Taxes 522 12/14/2018 Property Taxes 523 12/17/2018 Property Taxes 524 12/18/2018 Property Taxes 525 12/19/2018 Property Taxes 526 12/20/2018 Property Taxes 527 12/21/2018 Property Taxes 528 12/26/2018 Property Taxes 529 12/27/2018 Property Taxes 530 12/28/2018 Property Taxes 531 12/31/2018 Property Taxes (8,452.14) (368.04) (602.10) (128.54) (616.35) (248.49) (735.27) (648.71) (522.52) (4,088.64) (24,009.65) (942.40) (1,063.61) (1,330.32) (12,460.32) (1,156.01) (1,263.85) (12,167.36) (2,002.32) (1,401.87) (8,820.18) (9,422.28) (9,550.82) (10,167.17) (10,415.66) (11,150.93) (11,799.64) (12,322.16) (16,410.80) (40,420.45) (41,362.85) (42,426.46) (43,756.78) (56,217.10) (57,373.11) (58,636.96) (70,804.32) (72,806.64) (74,208.51) 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: (65,756.37) (74,208.51) ** (132,384.00) Budgeted (58,175.49) Remaining 56 6 Used Account: 135-40002-000-000 Property Taxes/Delinquent 517 12/07/2018 Property Taxes 519 12/11/2018 Property Taxes 522 12/14/2018 Property Taxes 527 12/21/2018 Property Taxes 529 12/27/2018 Property Taxes 531 12/31/2018 Property Taxes (57.54) (.44) (.05) 3.47 6.60 (.01) (7.87) (57.98) (58.03) (54.56) (47.96) (47.97) (55.84) GL GL GL GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 1.70 (55.84) ** (300.00) Budgeted (244.16) Remaining 19 % Used Account: 135-40015-000-000 Property Taxes/P & I 519 12/11/2018 Property Taxes 521 12/13/2018 Property Taxes 522 12/14/2018 Property Taxes 527 12/21/2018 Property Taxes 529 12/27/2018 Property Taxes (14.49) (.06) (14.55) (1.95) (16.50) (1.49) (17.99) (.38) (18.37) (1.52) (19.89) GL GL GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 530 12/28/2018 Property Taxes 531 12/31/2018 Property Taxes Account: 135-40015-000-000 , Account: 135-40025-000-000 Account: 135-40025-000-000 (14.49) Property Taxes/P & I Totals: (300.00) Budgeted (277.47) Remaining 8 % Used PID Surcharges PID Surcharges Totals: (171,983.00) Budgeted (171,983.00) Remaining Account: 135-47000-000-000 Water 492 12/31/2018 UB 01/03/2018 Billing UB20181231-20181231 User: Account: 135-47000-000-000 (596,566.14) 0 % Used (.82) (20.71) (1.82) (8.04) .00 (22.53) (22.53) ** .00 .00 .00 ** GL GL (296,662.36) (893,228.50) UB Water Totals: (296,662.36) (893,228.50) ** (6,599,484.00) Budgeted (5,706,255.50) Remaining 14 % Used Account: 135-47005-000-000 Sewer 427 12/18/2018 UB 12/18/2018 Penalty Removal UB20181218-20181218 User: 492 12/31/2018 UB 01/03/2018 Billing UB20181231-20181231 User: (480,126.48) 35.69 (480,090.79) UB (257,999.14) (738,089.93) UB Account: 135-47005-000-000 Sewer Totals: (257,963.45) (738,089.93) ** (3,412,665.00) Budgeted (2,674,575.07) Remaining 22 % Used Account: 135-47025-000-000 Penalties 339 12/05/2018 UB 12/05/2018 Penalty Removal UB20181205-20181205 User: 427 12/18/2018 UB 12/18/2018 Penalty Removal UB20181218-20181218 User: 451 12/21/2018 UB 12/21/2018 Penalties UB20181221-20181221 User: 452 12/21/2018 UB 12/21/2018 Penalty Removal UB20181221-20181221 User: 475 12/28/2018 UB 12/28/2018 Penalty Removal UB20181228-20181228 User: Account: 135-47025-000-000 Penalties (136,418.00) Budgeted (20,019.68) 2,076.28 (17,943.40) UB 50.24 (17,893.16) UB (10,817.96) (28,711.12) UB 259.91 (28,451.21) UB 228.28 (28,222.93) UB Totals: (8,203.25) (108,195.07) Remaining Account: 135-47030-000-000 Service Charges 365 12/06/2018 UB 12/06/2018 Disconnect Fees UB20181206-20181206 User: 366 12/06/2018 UB 12/06/2018 DF Removal UB20181206-20181206 User: 21 % Used (2,550.00) (28,222.93) ** (1,750.00) (4,300.00) 100.00 (4,200.00) UB UB glpdatb2 skrolczyk 14:58 01/17/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description 469 12/20/2018 UB 12/20/2018 NSF Check Account: 135-47030-000-000 Account: 135-47035-000-000 458 12/02/2018 Permits -513 458 12/02/2018 Permits -513 460 12/04/2018 Permits -651 462 12/20/2018 Permits -655 462 12/20/2018 Permits -655 Account: 135-47035-000-000 Account: 135-47045-000-000 Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance Revenues Period Ending: 12/2018 Beginning Balance JE Detail Description/Comment UB20181220-20181220 User: Service Charges (17,000.00) Budgeted Plumbing Inspections Asheville 26 Sadie 513 Asheville Asheville 26 Sadie 26 Sadie Court Sheldon 651 Sheldon & 659 Sheldon 655 Sheldon & 659 Sheldon 659 SHeldon Plumbing Inspections (1,500.00) Budgeted Sewer Inspections 458 12/02/2018 Permits -513 Asheville 26 Sadie 513 Asheville 458 12/02/2018 Permits -513 Asheville 26 Sadie 26 Sadie Court 460 12/04/2018 Permits -651 Sheldon 462 12/20/2018 Permits -655 & 659 Sheldon 462 12/20/2018 Permits -655 & 659 Sheldon Account: 135-47045-000-000 Account: 135-47070-000-000 Account: 135-47070-000-000 651 Sheldon 655 Sheldon 659 SHeldon Sewer Inspections (4,500.00) Budgeted TCCC Effluent Charges Totals: (12,775.00) Remaining Totals: (1,250.00) Remaining Totals: (3,750.00) Remaining TCCC Effluent Charges Totals: (60,000.00) Budgeted (59,982.40) Remaining Account: 135-49010-000-000 Interest Income 582 12/31/2018 Bank Interest- December 582 12/31/2018 Bank Interest- December 582 12/31/2018 Bank Interest- December Account: 135-49010-000-000 Interest Income (20,000.00) Budgeted (2,550.00) Program: Transaction Detail (25.00) 25 % Used 17 % Used 17 % Used (17.60) (17,772.49) (1,675.00) (50.00) (50.00) (50.00) (50.00) (50.00) Transaction Vendor_Name Detail (SUBTOTAL) 11111 (150.00) (150.00) (150.00) (150.00) (150.00) (750.00) 0 % Used .00 .00 (1,064.10) (752.52) (7,762.05) Totals: (9,578.67) 7,351.16 Remaining 137 % Used (4,225.00) (4,225.00) ** (50.00) Ashton Woods (100.00) Drees Homes (150.00) Ashton Woods (200.00) Ashton Woods (250.00) Ashton Woods (250.00) ** (150.00) (300.00) (450.00) (600.00) (750.00) Ashton Woods Drees Homes Ashton Woods Ashton Woods Ashton Woods (750.00) ** (17.60) (17.60) ** (18,836.59) (19,589.11) (27,351.16) (27,351.16) ** Page 7 Check Source Number UB CR CR CR CR CR CR CR CR CR CR GL GL GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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-49016-000-000 ' Cell Tower Revenue 561 12/21/2018 Cell Tower Rev AT&T December Account: 135-49016-000-000 ' (2,684.29) (1,178.81) (3,863.10) GL Cell Tower Revenue Totals: (1,178.81) (3,863.10) ** (14,146.00) Budgeted (10,282.90) Remaining 27 % Used Account: 135-49018-000-000 Building Rent - 581 12/31/2018 Town Billed Invoices 1668-1671 AR 20181231-20181231 User: (1,166.66) Account: 135-49018-000-000 Building Rent Income ' Totals: (7,000.00) Budgeted (5,250.01) Remaining (583.33) (1,749.99) AR 25 % Used (583.33) (1,749.99) ** Account: 135-49026-000-000 Proceeds from Sale of Assets Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: (10,000.00) Budgeted (10,000.00) Remaining Account: 135-49075-000-000 Oversize Meter Reimbursement 458 12/02/2018 Permits -513 Asheville 26 Sadie 513 Asheville 458 12/02/2018 Permits -513 Asheville 26 Sadie 26 Sadie Court 460 12/04/2018 Permits -651 Sheldon 462 12/20/2018 Permits -655 & 659 Sheldon 462 12/20/2018 Permits -655 & 659 Sheldon 651 Sheldon 655 Sheldon 659 SHeldon Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (18,522.00) Budgeted (16,807.00) Remaining Account: 135-49900-000-000 Miscellaneous Income 458 12/02/2018 Permits -513 Asheville 26 Sadie 513 Asheville 462 12/20/2018 Permits -655 & 659 Sheldon 651 Sheldon 567 12/21/2018 Co -Op BuyBoard Rebate 492 12/31/2018 UB 01/03/2018 Billing UB20181231-20181231 User: Account: 135-49900-000-000 .00 .00 .00 .00 ** 0 % Used (343.00) (343.00) Ashton Woods CR (343.00) (686.00) Drees Homes CR (343.00) (1,029.00) Ashton Woods CR (343.00) (1,372.00) Ashton Woods CR (343.00) (1,715.00) Ashton Woods CR (1,715.00) (1,715.00) ** 9 % Used (788.53) (800.00) (1,588.53) Ashton Woods CR (800.00) (2,388.53) Ashton Woods CR (247.00) (2,635.53) GL (321.06) (2,956.59) UB Miscellaneous Income Totals: (2,168.06) (2,956.59) ** (7,000.00) Budgeted (4,043.41) Remaining 42 % Used Account: 135-49901-000-000 Records Management Revenue glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 565 12/05/2018 Open Record Request Fee (2.00) (2.00) GL Account: 135-49901-000-000 Records Management Revenue Totals: (2.00) (2.00) ** .00 Budgeted 2.00 Remaining 0 % Used Department Totals: (1,776,708.68) ** (646,492.64) Monthly Total (10,613,202.00) Budgeted (8,836,493.32) Remaining 17 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-50005-010-000 Salaries & Wages 396 12/14/2018 MUD Payroll 12/14/2018 Salaries & Wages 455 12/28/2018 MUD Payroll 12/28/2018 Salaries & Wages Account: 135-50005-010-000 45,741.15 11,413.57 57,154.72 PR 11,413.57 68,568.29 PR Salaries & Wages Totals: 22,827.14 68,568.29 ** 326,755.00 Budgeted Account: 135-50010-010-000 Overtime 396 12/14/2018 MUD Payroll 12/14/2018 Overtime 455 12/28/2018 MUD Payroll 12/28/2018 Overtime 258,186.71 Remaining 21 % Used 1,856.04 69.90 1,925.94 PR 588.10 2,514.04 PR Account: 135-50010-010-000 Overtime Totals: 658.00 2,514.04 ** 20,000.00 Budgeted 17,485.96 Remaining 13 % Used Account: 135-50016-010-000 Longevity 3,620.00 .00 3,620.00 Account: 135-50016-010-000 Longevity Totals: .00 3,620.00 ** 3,620.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 455 12/28/2018 MUD Payroll 12/28/2018 Certification 400.00 175.00 575.00 PR Account: 135-50017-010-000 Certification Totals: 175.00 575.00 ** 4,800.00 Budgeted Account: 135-50020-010-000 ' Retirement 396 12/14/2018 MUD Payroll 12/14/2018 Retirement 455 12/28/2018 MUD Payroll 12/28/2018 Retirement 4,225.00 Remaining 12 6 Used 5,825.91 1,062.24 6,888.15 1,126.32 8,014.47 PR PR Account: 135-50020-010-000 Retirement Totals: 2,188.56 8,014.47 ** 33,304.00 Budgeted Account: 135-50026-010-000 Medical Insurance 396 12/14/2018 MUD Payroll 12/14/2018 Medical Insurance 455 12/28/2018 MUD Payroll 12/28/2018 Medical Insurance Account: 135-50026-010-000 25,289.53 Remaining 24 6 Used 5,897.60 1,474.40 7,372.00 1,474.40 8,846.40 Medical Insurance Totals: 2,948.80 8,846.40 ** 74,818.00 Budgeted 65,971.60 Remaining 12 % Used PR PR glpdatb2 skrolczyk 14:58 01/17/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Department: 10 Water JE Detail Description/Comment Account: 135-50027-010-000 Dental Insurance 396 12/14/2018 MUD Payroll 12/14/2018 Dental Insurance 455 12/28/2018 MUD Payroll 12/28/2018 Dental Insurance Account: 135-50027-010-000 Dental Insurance 4,317.00 Budgeted Account: 135-50028-010-000 Vision Insurance 396 12/14/2018 MUD Payroll 12/14/2018 Vision Insurance 455 12/28/2018 MUD Payroll 12/28/2018 Vision Insurance Account: 135-50028-010-000 Account: 135-50029-010-000 Vision Insurance 701.00 Budgeted Life Insurance & 321 12/01/2018 A/P Dec Employee Benefits 321 12/01/2018 A/P Dec Employee Benefits 372 12/06/2018 December A/P 372 12/06/2018 December A/P 476 12/28/2018 December PR A/P 476 12/28/2018 December PR A/P 478 12/28/2018 December A/P 575 12/31/2018 Invoice already entered-dec 576 12/31/2018 Invoice already entered-dec Account: 135-50029-010-000 Other Employee Benefits Employee LTD & STD Employee benefits employee benefits Employee LTD & STD Employee Benefits Caf 125 employee benefits Employee benefits Trophy Club MUD No.1 Page 11 Detailed Accounting Trial Balance Period Ending: 12/2018 Beginning Balance Totals: 3,676.05 Remaining Life Insurance & Other 3,131.00 Budgeted Totals: 593.24 Remaining Totals: 2,273.56 Remaining Account: 135-50030-010-000 Social Security Taxes 396 12/14/2018 MUD Payroll 12/14/2018 Social Security Taxes 455 12/28/2018 MUD Payroll 12/28/2018 Social Security Taxes Account: 135-50030-010-000 Social Security Taxes 22,021.00 Budgeted Account: 135-50035-010-000 Medicare Taxes 396 12/14/2018 MUD Payroll 12/14/2018 Medicare Taxes 455 12/28/2018 MUD Payroll 12/28/2018 Medicare Taxes Totals: 17,402.80 Remaining 427.30 71.84 413.22 3,171.34 15 % Used 15 % Used 27 % Used 21 % Used Program: Transaction Detail 106.85 106.80 213.65 17.98 17.94 35.92 110.60 87.01 87.01 110.60 103.58 125.03 18.00 (110.60) (87.01) 444.22 703.32 743.54 1,446.86 741.68 164.48 173.90 Transaction Vendor_Name Detail (SUBTOTAL) 534.15 640.95 640.95 ** 89.82 107.76 107.76 ** 523.82 610.83 697.84 808.44 912.02 1,037.05 1,055.05 944.45 857.44 Humana Inc METLIFE GROUP BENEFITS METLIFE GROUP BENEFITS Humana Inc METLIFE GROUP BENEFITS Humana Inc BenefitMall Humana Inc METLIFE GROUP BENEFITS 857.44 ** 3,874.66 4,618.20 4,618.20 ** 906.16 1,080.06 Check Source Number PR PR PR PR 4794 AP 4801 AP AP AP 4891 AP 4879 AP 4864 AP AP AP PR PR PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-50035-010-000 Account: 135-50040-010-000 Account: 135-50040-010-000 Medicare Taxes 5,150.00 Budgeted Unemployment Taxes Unemployment Taxes 1,080.00 Budgeted Totals: 4,069.94 Remaining 21 % Used Totals: 1,080.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 127 12/01/2018 Insurance/Wrk Comp Expense Dec 1,861.88 Account: 135-50045-010-000 Account: 135-50060-010-000 Account: 135-50060-010-000 Workman's Compensation Totals: 12,895.00 Budgeted 10,102.18 Remaining Pre-emp Physicals/Testing Pre-emp Physicals/Testing Totals: 200.00 Budgeted 200.00 Remaining Account: 135-50070-010-000 Employee Relations Account: 135-50070-010-000 Employee Relations Totals: 300.00 Budgeted Account: 135-55005-010-000 Engineering Account: 135-55005-010-000 22 % Used 0 % Used 300.00 Remaining 0 % Used Engineering Totals: 20,000.00 Budgeted 20,000.00 Remaining 0 % Used 338.38 1,080.06 ** .00 .00 .00 .00 ** 930.94 2,792.82 GL 930.94 2,792.82 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** Account: 135-55080-010-000 Maintenance & Repairs 508 12/26/2018 Pcard 11/27/18 - 12/26/18 maintenance supplies 5,317.29 75.23 5,392.52 THE HOME DEPOT #6581 PC 508 12/26/2018 Pcard 11/27/18 - 12/26/18 coupling 7.98 5,400.50 THE HOME DEPOT #6581 PC glpdatb2 skrolczyk 14:58 01/17/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 503 12/31/2018 December A/P 503 12/31/2018 December A/P 503 12/31/2018 December A/P Department: 10 Water JE Detail Description/Comment Flags -parts parts 10" force main repair Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: Page 13 Period Ending: 12/2018 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) 5,317.29 240.00 117.57 7,209.54 5,640.50 Core & Main LP 5,758.07 Core 8 Main LP 12,967.61 REY-MAR CONSTRUCTION 4867 AP 4867 AP 4898 AP Account: 135-55080-010-000 Maintenance & Repairs Totals: 7,650.32 12,967.61 ** 100,000.00 Budgeted 87,032.39 Remaining 13 % Used 17 % Used Account: 135-55085-010-000 Generator Maint. and Repair Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 943.00 .00 943.00 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 .00 943.00 ** Account: 135-55105-010-000 3,000.00 Budgeted 2,057.00 Remaining 31 % Used .00 .00 ** Account: 135-55090-010-000 Vehicle Maintenance 3,500.00 Budgeted 3,500.00 Remaining 0 % Used 508 12/26/2018 Pcard 11/27/18 - 12/26/18 508 12/26/2018 Pcard 11/27/18 - 12/26/18 508 12/26/2018 Pcard 11/27/18 - 12/26/18 508 12/26/2018 Pcard 11/27/18 - 12/26/18 tags for new water truck convience fee for tags state inspection state inspection 785.43 16.75 802.18 DENTON COUNTY, TX SOUT 1.00 803.18 DENTON COUNTY, TX SOUT 25.50 828.68 KWIK KAR LUBE & TUNE 0 25.50 854.18 KWIK KAR LUBE & TUNE 0 PC PC PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 68.75 854.18 ** 5,000.00 Budgeted 4,145.82 Remaining 17 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55120-010-000 Cleaning Services .00 .00 Account: 135-55120-010-000 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 557 12/31/2018 December A/P Water samples 607.70 220.00 827.70 TARRANT CTY PUBLIC HEALTH LAB 4924 AP Account: 135-55135-010-000 Lab Analysis Totals: 220.00 827.70 ** 6,500.00 Budgeted 5,672.30 Remaining 13 % Used glpdatb2 skrolczyk 14:58 01/17/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 14 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 12/2018 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-60010-010-000 Communications/Mobiles 420 12/17/2018 December A/P Account: 135-60010-010-000 Cell phones -December 738.23 Communications/Mobiles Totals: 5,000.00 Budgeted 3,976.23 Remaining 20 % Used 285.54 1,023.77 VERIZON WIRELESS 4858 AP 285.54 1,023.77 ** Account: 135-60020-010-000 Electricity 478 12/28/2018 December A/P Account: 135-60020-010-000 Electricity 11/8-12/10 18,928.67 Electricity Totals: 154,204.00 Budgeted 7,272.32 26,200.99 HUDSON ENERGY SERVICES, LLC 4880 AP 128,003.01 Remaining 17 % Used 7,272.32 26,200.99 ** Account: 135-60066-010-000 Publications/Books/Subscripts Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining .00 0 % Used .00 .00 .00 ** 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 411.00 .00 411.00 Account: 135-60080-010-000 Schools & Training Totals: .00 411.00 ** 4,651.00 Budgeted 4,240.00 Remaining 9 % Used Account: 135-60090-010-000 Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem glpdatb2 skrolczyk 14:58 01/17/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-60100-010-000 Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 12/2018 Beginning Balance Travel & per diem Totals: 2,345.00 Budgeted Account: 135-60105-010-000 Rent/Lease Equipment Account: 135-60105-010-000 Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 2,345.00 Remaining 0 % Used Rent/Lease Equipment Totals: 1,500.00 Budgeted Account: 135-60135-010-000 TCEQ Fees & Permits Account: 135-60135-010-000 .00 .00 ** .00 .00 1,500.00 Remaining 0 6 Used TCEQ Fees & Permits Totals: 58,000.00 Budgeted 7,685.65 50,314.35 Remaining 13 6 Used Account: 135-60150-010-000 Wholesale Water 503 12/31/2018 December A/P December wholesale water Account: 135-60150-010-000 Wholesale Water Totals: 3,013,494.00 Budgeted Account: 135-60245-010-000 Miscellaneous Expenses Account: 135-60245-010-000 .00 .00 ** .00 7,685.65 .00 7,685.65 ** 136,507.63 118,137.74 2,758,848.63 Remaining 8 % Used Miscellaneous Expenses Totals: 200.00 Budgeted Account: 135-60280-010-000 Property Maintenance Account: 135-60280-010-000 200.00 Remaining 0 6 Used Property Maintenance Totals: 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2,090.00 Page 15 Check Source Number 254,645.37 CITY OF FORT WORTH 4865 AP 118,137.74 254,645.37 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 2,090.00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-60285-010-000 Lawn Equipment & Maintenance Totals: .00 2,090.00 ** 14,750.00 Budgeted 12,660.00 Remaining Account: 135-60332-010-000 Interfund Transfer Out -Rev IBS 442 12/31/2018 TexPool Transfers December TexPool O&M to 16Swift Rev I&S Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 585,209.00 Budgeted 509,690.57 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve 442 12/31/2018 TexPool Transfers December TexPool O&M to Rev Bond Resevr Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted 41,393.00 Remaining Account: 135-60334-010-000 Interfund Transfer Out Account: 135-60334-010-000 Account: 135-60360-010-000 50,345.62 9,200.00 14 % Used 13 % Used 25 % Used 25,172.81 25,172.81 4,600.00 4,600.00 .00 Interfund Transfer Out Totals: .00 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Furniture/Equipment < $5000 .00 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Account: 135-65005-010-000 510 12/24/2018 December A/P Account: 135-65005-010-000 0 6 Used 75,518.43 75,518.43 ** 13,800.00 13,800.00 ** .00 .00 ** .00 .00 .00 ** Fuel & Lube Fuel 1,576.89 716.01 Fuel & Lube Totals: 716.01 15,000.00 Budgeted Account: 135-65010-010-000 Uniforms 12,707.10 Remaining 15 % Used 1,417.41 GL GL 2,292.90 US Bank Voyager Fleet Systems 4905 AP 2,292.90 ** .00 1,417.41 glpdatb2 skrolczyk Trophy Club MUD No.1 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 17 Account: 135-65010-010-000 Uniforms Totals: .00 1,417.41 ** 5,190.00 Budgeted Account: 135-65030-010-000 Chemicals 478 12/28/2018 December A/P Account: 135-65030-010-000 3,772.59 Remaining 27 % Used chlorine 4,682.43 Chemicals Totals: 20,000.00 Budgeted Account: 135-65035-010-000 Small Tools Account: 135-65035-010-000 14,424.12 Remaining 28 % Used Small Tools Totals: 1,200.00 Budgeted Account: 135-65040-010-000 Safety Equipment Account: 135-65040-010-000 Account: 135-65050-010-000 420 12/17/2018 December A/P Account: 135-65050-010-000 1,200.00 Remaining 0 % Used Safety Equipment Totals: 1,000.00 Budgeted Meter Expense meters 1,000.00 Remaining 0 % Used 893.45 5,575.88 DPC INDUSTRIES, INC 4871 AP 893.45 .00 5,575.88 ** .00 .00 .00 ** .00 .00 .00 .00 ** 55.80 11,250.00 11,305.80 ATLAS UTILITY SUPPLY CO. 4829 AP Meter Expense Totals: 11,250.00 11,305.80 ** 70,000.00 Budgeted Account: 135-65053-010-000 Meter Change Out Program Account: 135-65053-010-000 58,694.20 Remaining 16 % Used .00 .00 Meter Change Out Program Totals: .00 .00 ** 87,000.00 Budgeted 87,000.00 Remaining Account: 135-69005-010-000 Capital Outlays 478 12/28/2018 December A/P 2019 Dodge 1500 Truck #111 30,617.60 0 % Used 26,575.00 57,192.60 Grapevine Dodge Chrysler Jeep 4877 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-69005-010-000 Capital Outlays Totals: 26,575.00 57,192.60 ** 453,000.00 Budgeted 395,807.40 Remaining 13 % 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 0 % Used .00 .00 .00 .00 ** 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 0 % Used .00 .00 .00 .00 ** Account: 135-69195-010-000 Gasb34/Reserve for Replacement Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 75,000.00 .00 75,000.00 .00 75,000.00 ** 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 57,932.73 .00 57,932.73 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 57,932.73 ** 120,000.00 Budgeted 62,067.27 Remaining 48 % Used glpdatb2 skrolczyk 14:58 01/17/19 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: 12/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 557 12/31/2018 December A/P Water samples 367.70 80.00 447.70 TARRANT CTY PUBLIC HEALTH LAB 4924 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 447.70 ** 2,000.00 Budgeted 1,552.30 Remaining 22 % Used Department 10 Totals: 710,368.15 ** 235,129.41 Monthly Total 5,641,834.00 Budgeted 4,931,465.85 Remaining 13 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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-50005-020-000 Salaries & Wages 396 12/14/2018 MUD Payroll 12/14/2018 Salaries & Wages 455 12/28/2018 MUD Payroll 12/28/2018 Salaries & Wages Account: 135-50005-020-000 Salaries & Wages Totals: 421,699.00 Budgeted Account: 135-50010-020-000 Overtime 396 12/14/2018 MUD Payroll 12/14/2018 Overtime 455 12/28/2018 MUD Payroll 12/28/2018 Overtime 52,417.23 343,060.55 Remaining 19 % Used 6,625.49 13,155.43 65,572.66 13,065.79 78,638.45 26,221.22 78,638.45 ** 1,019.66 798.64 7,645.15 8,443.79 PR PR PR PR Account: 135-50010-020-000 Overtime Totals: 1,818.30 8,443.79 ** Account: 135-50016-020-000 Account: 135-50016-020-000 30,000.00 Budgeted Longevity Longevity 7,445.00 Budgeted Account: 135-50017-020-000 Certification 455 12/28/2018 MUD Payroll 12/28/2018 Certification 21,556.21 Remaining Totals: .00 Remaining 28 % Used 7,445.00 100 % Used .00 .00 7,445.00 1,400.00 650.00 2,050.00 PR Account: 135-50017-020-000 Certification Totals: 650.00 2,050.00 ** 8,700.00 Budgeted Account: 135-50020-020-000 ' Retirement 396 12/14/2018 MUD Payroll 12/14/2018 Retirement 455 12/28/2018 MUD Payroll 12/28/2018 Retirement 6,650.00 Remaining 24 % Used 7,796.31 1,311.20 9,107.51 1,342.58 10,450.09 PR PR Account: 135-50020-020-000 Retirement Totals: 2,653.78 10,450.09 ** 43,276.00 Budgeted Account: 135-50026-020-000 Medical Insurance 396 12/14/2018 MUD Payroll 12/14/2018 Medical Insurance 455 12/28/2018 MUD Payroll 12/28/2018 Medical Insurance Account: 135-50026-020-000 32,825.91 Remaining 24 % Used Medical Insurance Totals: 91,627.00 Budgeted 10,725.61 75,686.02 Remaining 17 % Used 2,607.70 13,333.31 2,607.67 5,215.37 15,940.98 15,940.98 ** PR PR glpdatb2 skrolczyk 14:58 01/17/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance 20 Wastewater Period Ending: 12/2018 Beginning Balance JE Detail Description/Comment Account: 135-50027-020-000 Dental Insurance 396 12/14/2018 MUD Payroll 12/14/2018 Dental Insurance 455 12/28/2018 MUD Payroll 12/28/2018 Dental Insurance Account: 135-50027-020-000 Dental Insurance 5,104.00 Budgeted Account: 135-50028-020-000 Vision Insurance 396 12/14/2018 MUD Payroll 12/14/2018 Vision Insurance 455 12/28/2018 MUD Payroll 12/28/2018 Vision Insurance Account: 135-50028-020-000 Vision Insurance 826.00 Budgeted Account: 135-50029-020-000 Life Insurance & 321 12/01/2018 A/P Dec Employee Benefits 321 12/01/2018 A/P Dec Employee Benefits 372 12/06/2018 December A/P 372 12/06/2018 December A/P 476 12/28/2018 December PR A/P 476 12/28/2018 December PR A/P 478 12/28/2018 December A/P 575 12/31/2018 Invoice already entered-dec 576 12/31/2018 Invoice already entered-dec Account: 135-50029-020-000 Other Employee Benefits Employee LTD & STD Employee benefits employee benefits Employee LTD & STD Employee Benefits Caf 125 employee benefits Employee benefits Totals: 3,988.33 Remaining Life Insurance & Other 4,495.00 Budgeted Totals: 649.30 Remaining Totals: 3,488.29 Remaining Account: 135-50030-020-000 Social Security Taxes 396 12/14/2018 MUD Payroll 12/14/2018 Social Security Taxes 455 12/28/2018 MUD Payroll 12/28/2018 Social Security Taxes Account: 135-50030-020-000 Social Security Taxes 29,006.00 Budgeted Account: 135-50035-020-000 Medicare Taxes 396 12/14/2018 MUD Payroll 12/14/2018 Medicare Taxes 455 12/28/2018 MUD Payroll 12/28/2018 Medicare Taxes Totals: 23,409.93 Remaining 743.78 117.80 606.40 3,968.65 928.16 22 % Used 21 % Used 22 % Used 19 % Used Program: Transaction Detail 185.96 185.93 371.89 29.46 29.44 58.90 Transaction Vendor_Name Detail (SUBTOTAL) 929.74 1,115.67 1,115.67 ** 147.26 176.70 176.70 ** 46.76 653.16 120.84 774.00 120.84 894.84 46.76 941.60 143.85 1,085.45 52.86 1,138.31 36.00 1,174.31 (46.76) 1,127.55 (120.84) 1,006.71 400.31 815.98 811.44 1,627.42 190.83 189.77 Humana Inc METLIFE GROUP BENEFITS METLIFE GROUP BENEFITS Humana Inc METLIFE GROUP BENEFITS Humana Inc BenefitMall Humana Inc METLIFE GROUP BENEFITS 1,006.71 ** 4,784.63 5,596.07 5,596.07 ** 1,118.99 1,308.76 Page 21 Check Source Number PR PR PR PR 4794 AP 4801 AP AP AP 4891 AP 4879 AP 4864 AP AP AP PR PR PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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-50035-020-000 Medicare Taxes Totals: 380.60 1,308.76 ** 6,784.00 Budgeted 5,475.24 Remaining 19 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 6 Used Account: 135-50045-020-000 Workman's Compensation 127 12/01/2018 Insurance/Wrk Comp Expense Dec 2,411.46 1,205.73 3,617.19 GL Account: 135-50045-020-000 Workman's Compensation Totals: 1,205.73 3,617.19 ** 16,941.00 Budgeted 13,323.81 Remaining 21 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 420 12/17/2018 December A/P Employee drug screen -J Ramirez 38.00 38.00 CARENOW CORPORATE 4831 AP Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 38.00 38.00 ** 400.00 Budgeted 362.00 Remaining 10 % Used Account: 135-50070-020-000 Employee Relations .00 Account: 135-50070-020-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining 0 % Used .00 Account: 135-55005-020-000 Engineering .00 .00 .00 ** .00 Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted Account: 135-55070-020-000 Independent Labor 30,000.00 Remaining 0 5 Used .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 23 Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 420 12/17/2018 December A/P steel chain 508 12/26/2018 Pcard 11/27/18 - 12/26/18 belt, windshield wash, etc. 508 12/26/2018 Pcard 11/27/18 - 12/26/18 hose 508 12/26/2018 Pcard 11/27/18 - 12/26/18 pvc cap 508 12/26/2018 Pcard 11/27/18 - 12/26/18 brass fittings 508 12/26/2018 Pcard 11/27/18 - 12/26/18 pipe insulation , duct tape 508 12/26/2018 Pcard 11/27/18 - 12/26/18 3/4x3/4 nbxmh 508 12/26/2018 Pcard 11/27/18 - 12/26/18 clevis hooks 557 12/31/2018 December A/P WAS pump MBR #2 557 12/31/2018 December A/P Exposed sewer pipe in creek/sk 14,030.93 260.00 229.86 180.22 8.62 18.66 31.17 13.40 42.72 1,840.00 3,737.50 14,290.93 NORTH TEXAS PUMP CO. 14,520.79 ROANOKE AUTO SUPPLY LT 14,701.01 INT*IN *HOSE TECH USA 14,709.63 THE HOME DEPOT #6581 14,728.29 THE HOME DEPOT #6581 14,759.46 THE HOME DEPOT #6581 14,772.86 THE HOME DEPOT #6581 14,815.58 THE HOME DEPOT #6581 16,655.58 PUMP SOLUTIONS INC 20,393.08 CP&Y/WALLACE GROUP, INC. 4845 AP PC PC PC PC PC PC PC 4921 AP 4911 AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 6,362.15 20,393.08 ** 88,000.00 Budgeted 67,606.92 Remaining 23 % Used Account: 135-55085-020-000 Generator Maint. and Repair 508 12/26/2018 Pcard 11/27/18 478 12/28/2018 December A/P - 12/26/18 battery oil 447.98 175.52 447.98 623.50 ROANOKE AUTO SUPPLY LT LUBRICATION ENGINEERS, INC 4889 PC AP Account: 135-55085-020-000 Generator Maint. and Repair Totals: 623.50 623.50 ** 10,000.00 Budgeted 9,376.50 Remaining 6 % Used Account: 135-55090-020-000 Vehicle Maintenance 508 12/26/2018 Pcard 11/27/18 - 12/26/18 Chrome Plate 145.96 10.24 156.20 ROANOKE AUTO SUPPLY LT PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 10.24 156.20 ** 8,000.00 Budgeted 7,843.80 Remaining 2 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 508 12/26/2018 Pcard 11/27/18 - 12/26/18 fuel filter 27.77 27.77 ROANOKE AUTO SUPPLY LT PC Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 27.77 27.77 ** 1,500.00 Budgeted 1,472.23 Remaining 2 9 Used Account: 135-55120-020-000 Cleaning Services glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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-55120-020-000 Account: 135-55125-020-000 420 12/17/2018 December A/P 420 12/17/2018 December A/P 478 12/28/2018 December A/P 557 12/31/2018 December A/P Account: 135-55125-020-000 .00 .00 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted Dumpster Services sludge haul off sludge haul off sludge haul off Sludge haul off Dumpster Services 75,000.00 Budgeted 5,214.00 Remaining 0 % Used 14,775.25 Totals: 53,409.82 Remaining 29 % Used 1,690.00 1,690.00 845.00 2,589.93 16,465.25 L.H. CHANEY MATERIALS, INC. 18,155.25 L.H. CHANEY MATERIALS, INC. 19,000.25 L.H. CHANEY MATERIALS, INC. 21,590.18 L.H. CHANEY MATERIALS, INC. 6,814.93 21,590.18 ** 4841 AP 4841 AP 4887 AP 4916 AP Account: 135-55135-020-000 Lab Analysis . 372 12/06/2018 December A/P Effluent testing 7,491.92 176.00 7,667.92 OXIDOR LABORATORIES LLC 4802 AP 372 12/06/2018 December A/P Effluent testing 246.00 7,913.92 OXIDOR LABORATORIES LLC 4802 AP 420 12/17/2018 December A/P Effluent testing 246.00 8,159.92 OXIDOR LABORATORIES LLC 4847 AP 420 12/17/2018 December A/P Effluent testing 176.00 8,335.92 OXIDOR LABORATORIES LLC 4847 AP 478 12/28/2018 December A/P effluent testing 246.00 8,581.92 OXIDOR LABORATORIES LLC 4894 AP 478 12/28/2018 December A/P effluent testing 176.00 8,757.92 OXIDOR LABORATORIES LLC 4894 AP 478 12/28/2018 December A/P effluent testing 246.00 9,003.92 OXIDOR LABORATORIES LLC 4894 AP 478 12/28/2018 December A/P effluent testing 176.00 9,179.92 OXIDOR LABORATORIES LLC 4894 AP 478 12/28/2018 December A/P lab supplies 1,397.88 10,577.80 IDEXX DISTRIBUTION, INC 4881 AP 478 12/28/2018 December A/P coliform 197.77 10,775.57 IDEXX DISTRIBUTION, INC 4881 AP Account: 135-55135-020-000 Account: 135-60010-020-000 420 12/17/2018 December A/P Account: 135-60010-020-000 Account: 135-60020-020-000 Lab Analysis 35,000.00 Budgeted Totals: 3,283.65 10,775.57 ** 24,224.43 Remaining 31 % Used Communications/Mobiles Cell phones -December 753.68 368.98 1,122.66 VERIZON WIRELESS 4858 AP Communications/Mobiles Totals: 368.98 1,122.66 ** 5,000.00 Budgeted 3,877.34 Remaining 22 % Used Electricity 478 12/28/2018 December A/P Electricity 11/8-12/10 25,296.73 12,787.16 581 12/31/2018 Town Billed Invoices 1668-1671 AR 20181231-20181231 User: (353.49) 38,083.89 HUDSON ENERGY SERVICES, LLC 4880 AP 37,730.40 AR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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-60020-020-000 Electricity Totals: 12,433.67 37,730.40 ** 174,165.00 Budgeted 136,434.60 Remaining 22 % 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 Account: 135-60070-020-000 Dues & Memberships Account: 135-60070-020-000 Account: 135-60080-020-000 Account: 135-60080-020-000 0 6 Used 69.00 .00 69.00 Dues & Memberships Totals: .00 69.00 ** 300.00 Budgeted 231.00 Remaining 23 % Used Schools & Training Schools & Training Totals: 7,155.00 Budgeted Account: 135-60090-020-000 Safety Program Account: 135-60090-020-000 111.00 7,044.00 Remaining 2 6 Used Safety Program Totals: 1,000.00 Budgeted Account: 135-60100-020-000 Travel & per diem Account: 135-60100-020-000 1,000.00 Remaining 0 % Used Travel & per diem Totals: 1,895.00 Budgeted Account: 135-60105-020-000 Rent/Lease Equipment 1,895.00 Remaining 0 o Used .00 111.00 .00 111.00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 478 12/28/2018 December A/P stormwater permit FY19 16,345.22 200.00 16,545.22 TX COMMISSION ENVIRONMENTAL QU 4904 AP Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 200.00 16,545.22 ** 30,000.00 Budgeted 13,454.78 Remaining 55 5 Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 508 12/26/2018 Pcard 11/27/18 - 12/26/18 water nozzle,clamps, ironforce 508 12/26/2018 Pcard 11/27/18 - 12/26/18 rug reacher 508 12/26/2018 Pcard 11/27/18 - 12/26/18 hoses 6.98 34.59 41.57 THE HOME DEPOT 86581 PC 55.38 96.95 THE HOME DEPOT 66581 PC 128.23 225.18 THE HOME DEPOT 66581 PC Account: 135-60280-020-000 Property Maintenance Totals: 0 225.18 ** 5,000.00 Budgeted 4,774.82 Remaining 5 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 590.00 .00 590.00 Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 590.00 ** 11,600.00 Budgeted 11,010.00 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 5 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 442 12/31/2018 TexPool Transfers December TexPool O&M to I&S- PID Debt Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 120,053.00 Budgeted 87,311.30 Remaining Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 1 21,827.80 10,913.90 32,741.70 GL 10,913.90 32,741.70 ** 442 12/31/2018 TexPool Transfers December TexPool O&M to Rev Bd WWTP I&S 108,406.90 Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 688,330.00 Budgeted 525,719.65 Remaining Account: 135-60333-020-000 Interfund Transfer Out -Reserve 442 12/31/2018 TexPool Transfers December TexPool O&M to Rev Bond Resevr Account: 135-60333-020-000 27 % Used 54,203.45 162,610.35 GL 54,203.45 162,610.35 ** 24 % Used 20,864.00 10,432.00 31,296.00 GL Interfund Transfer Out -Reserve Totals: 10,432.00 31,296.00 ** 125,187.00 Budgeted 93,891.00 Remaining 25 % Used Account: 135-60334-020-000 Interfund Transfer Out 443 12/20/2018 Cor 517 Due to/Due from 135 Due from/ WWTP Fund 517 122,777.00 (122,777.00) .00 GL Account: 135-60334-020-000 Interfund Transfer Out1 Totals: (122,777.00) .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % 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 510 12/24/2018 December A/P Fuel 2,590.63 792.33 3,382.96 US Bank Voyager Fleet Systems 4905 AP Account: 135-65005-020-000 Fuel & Lube Totals: 792.33 3,382.96 ** 12,500.00 Budgeted Account: 135-65010-020-000 Uniforms 420 12/17/2018 December A/P uniforms -Frank I 9,117.04 Remaining 27 % Used 1,889.49 89.24 1,978.73 RON MONTGOMERY & ASSOC INC 4848 AP glpdatb2 skrolczyk 14:58 01/17/19 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: 12/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 28 Check Source Number Account: 135-65010-020-000 Uniforms Totals: 89.24 1,978.73 ** 5,495.00 Budgeted 3,516.27 Remaining 36 % Used Account: 135-65030-020-000 Chemicals 420 12/17/2018 December A/P 508 12/26/2018 Pcard 11/27/18 478 12/28/2018 December A/P chemicals - 12/26/18 DSF Clear Mint Carroll chemicals 536.00 536.00 88.24 431.58 1,072.00 1,160.24 1,591.82 Valley Solvent Company, WAGNER SUPPLY Valley Solvent Company, INC INC 4857 4906 AP PC AP Account: 135-65030-020-000 , Chemicals Totals: 1,055.82 1,591.82 ** 30,000.00 Budgeted 28,408.18 Remaining 5 % Used Account: 135-65035-020-000 Small Tools 14.97 .00 14.97 Account: 135-65035-020-000 Small Tools Totals: .00 14.97 ** 1,200.00 Budgeted 1,185.03 Remaining 1 % Used Account: 135-65040-020-000 Safety Equipment 552.18 .00 552.18 Account: 135-65040-020-000 Safety Equipment Totals: .00 552.18 ** 1,200.00 Budgeted 647.82 Remaining 46 % Used Account: 135-65045-020-000 Lab Supplies 508 12/26/2018 Pcard 11/27/18 - 12/26/18 alcohol 2,435.77 24.46 2,460.23 THE HOME DEPOT #6581 PC Account: 135-65045-020-000 . Lab Supplies Totals: 24.46 2,460.23 ** 20,000.00 Budgeted 17,539.77 Remaining 12 5 Used Account: 135-69005-020-000 • Capital Outlays 44,200.32 .00 44,200.32 Account: 135-69005-020-000 Capital Outlays Totals: .00 44,200.32 ** 330,000.00 Budgeted 285,799.68 Remaining 13 % Used Account: 135-69008-020-000 Short Term Debt -Principal glpdatb2 skrolczyk 14:58 01/17/19 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: 12/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Page 29 Check Source Number Department 20 Totals: 30,000.00 Budgeted 25,718.81 Monthly Total .00 Remaining 100 % Used 556,616.43 ** 2,872,082.00 Budgeted 2,315,465.57 Remaining 19 % Used 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 25,718.81 Monthly Total .00 Remaining 100 % Used 556,616.43 ** 2,872,082.00 Budgeted 2,315,465.57 Remaining 19 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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 127 12/01/2018 Insurance/Wrk Comp Expense Dec Account: 135-50045-026-000 Account: 135-60066-026-000 Account: 135-60066-026-000 Account: 135-60070-026-000 420 12/17/2018 December A/P Account: 135-60070-026-000 Workman's Compensation Totals: 30.00 Budgeted Publications/Books/Subscripts 4.24 2.12 6.36 GL 23.64 Remaining 21 % Used Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining Dues & Memberships Board annual membership dues -2 Dues & Memberships Totals: 750.00 Budgeted 2.12 6.36 ** .00 0 % Used .00 .00 .00 ** 650.00 650.00 AWED 100.00 Remaining 87 % Used 650.00 650.00 ** 4830 AP Account: 135-60075-026-000 Meetings .00 .00 Account: 135-60075-026-000 Meetings Totals: .00 .00 ** Account: 135-60080-026-000 1,300.00 Budgeted _ Schools & Training 1,300.00 Remaining 0 % Used 508 12/26/2018 Pcard 11/27/18 - 12/26/18 board director training Account: 135-60080-026-000 1 Schools & Training Totals: 4,000.00 Budgeted 295.00 270.00 565.00 NCTCOG RTC TRAINING PC 3,435.00 Remaining 14 % Used 270.00 565.00 ** Account: 135-60100-026-000 1 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 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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: 1,221.36 ** 922.12 Monthly Total 13,230.00 Budgeted 12,008.64 Remaining 9 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-50005-030-000 Salaries & Wages 396 12/14/2018 MUD Payroll 12/14/2018 Salaries & Wages 455 12/28/2018 MUD Payroll 12/28/2018 Salaries & Wages 55,789.59 14,139.21 69,928.80 PR 14,149.73 84,078.53 PR Account: 135-50005-030-000 Salaries & Wages Totals: 28,288.94 84,078.53 ** 441,006.00 Budgeted 356,927.47 Remaining 19 % Used Account: 135-50010-030-000 Overtime 396 12/14/2018 MUD Payroll 12/14/2018 Overtime 6.32 4.13 10.45 PR Account: 135-50010-030-000 Overtime Totals: 4.13 10.45 ** 2,000.00 Budgeted 1,989.55 Remaining 1 % Used Account: 135-50016-030-000 Longevity 1,832.50 Account: 135-50016-030-000 Longevity Totals: 1,833.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 396 12/14/2018 MUD Payroll 12/14/2018 Retirement 455 12/28/2018 MUD Payroll 12/28/2018 Retirement .00 1,832.50 1,832.50 ** 6,690.83 1,308.27 7,999.10 PR 1,308.84 9,307.94 PR Account: 135-50020-030-000 Retirement Totals: 2,617.11 9,307.94 ** 41,148.00 Budgeted Account: 135-50026-030-000 ' Medical Insurance 396 12/14/2018 MUD Payroll 12/14/2018 Medical Insurance 455 12/28/2018 MUD Payroll 12/28/2018 Medical Insurance 31,840.06 Remaining 23 6 Used 8,290.48 2,072.63 10,363.11 PR 2,072.61 12,435.72 PR Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 12,435.72 ** 81,895.00 Budgeted Account: 135-50027-030-000 Dental Insurance 396 12/14/2018 MUD Payroll 12/14/2018 Dental Insurance 455 12/28/2018 MUD Payroll 12/28/2018 Dental Insurance 69,459.28 Remaining 15 % Used 519.04 129.78 648.82 PR 129.74 778.56 PR Account: 135-50027-030-000 Dental Insurance Totals: 259.52 778.56 ** 4,291.00 Budgeted 3,512.44 Remaining 18 5 Used glpdatb2 skrolczyk 14:58 01/17/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 12/2018 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 33 Check Source Number 321 12/01/2018 A/P Dec Employee Benefits 372 12/06/2018 December A/P 372 12/06/2018 December A/P 476 12/28/2018 December PR A/P 476 12/28/2018 December PR A/P 478 12/28/2018 December A/P 575 12/31/2018 Invoice already entered-dec 576 12/31/2018 Invoice already entered-dec Employee LTD & STD Employee benefits employee benefits Employee LTD & STD Employee Benefits Caf 125 employee benefits Employee benefits 119.45 119.45 145.04 142.20 163.95 18.00 (145.04) (119.45) 811.47 930.92 1,075.96 1,218.16 1,382.11 1,400.11 1,255.07 1,135.62 METLIFE GROUP BENEFITS METLIFE GROUP BENEFITS Humana Inc METLIFE GROUP BENEFITS Humana Inc BenefitMall Humana Inc METLIFE GROUP BENEFITS 4801 AP AP AP 4891 AP 4879 AP 4864 AP AP AP Account: 135-50029-030-000 Life Insurance & Other Totals: 588.64 1,135.62 ** Account: 135-50028-030-000 Vision Insurance 25 % Used Account: 135-50030-030-000 Social Security Taxes 396 12/14/2018 MUD Payroll 12/14/2018 Vision Insurance 455 12/28/2018 MUD Payroll 12/28/2018 Vision Insurance 85.02 21.28 21.23 106.30 127.53 396 12/14/2018 MUD Payroll 455 12/28/2018 MUD Payroll PR PR Account: 135-50028-030-000 Vision Insurance Totals: 4,292.51 5,129.14 42.51 127.53 ** ' Social Security Taxes Totals: 701.00 Budgeted 573.47 Remaining 18 9 Used 27,580.00 Budgeted 22,450.86 Remaining 19 % Used Account: 135-50029-030-000 Life Insurance & Other Account: 135-50035-030-000 Medicare Taxes 321 12/01/2018 A/P Dec Employee Benefits Employee Benefits 546.98 396 12/14/2018 MUD Payroll 455 12/28/2018 MUD Payroll 145.04 692.02 Humana Inc 4794 AP 321 12/01/2018 A/P Dec Employee Benefits 372 12/06/2018 December A/P 372 12/06/2018 December A/P 476 12/28/2018 December PR A/P 476 12/28/2018 December PR A/P 478 12/28/2018 December A/P 575 12/31/2018 Invoice already entered-dec 576 12/31/2018 Invoice already entered-dec Employee LTD & STD Employee benefits employee benefits Employee LTD & STD Employee Benefits Caf 125 employee benefits Employee benefits 119.45 119.45 145.04 142.20 163.95 18.00 (145.04) (119.45) 811.47 930.92 1,075.96 1,218.16 1,382.11 1,400.11 1,255.07 1,135.62 METLIFE GROUP BENEFITS METLIFE GROUP BENEFITS Humana Inc METLIFE GROUP BENEFITS Humana Inc BenefitMall Humana Inc METLIFE GROUP BENEFITS 4801 AP AP AP 4891 AP 4879 AP 4864 AP AP AP Account: 135-50029-030-000 Life Insurance & Other Totals: 588.64 1,135.62 ** 4,495.00 Budgeted 3,359.38 Remaining 25 % Used Account: 135-50030-030-000 Social Security Taxes 396 12/14/2018 MUD Payroll 455 12/28/2018 MUD Payroll 12/14/2018 Social Security Taxes 12/28/2018 Social Security Taxes 3,453.63 838.88 836.63 4,292.51 5,129.14 PR PR Account: 135-50030-030-000 ' Social Security Taxes Totals: 1,675.51 5,129.14 ** 27,580.00 Budgeted 22,450.86 Remaining 19 % Used Account: 135-50035-030-000 Medicare Taxes 396 12/14/2018 MUD Payroll 455 12/28/2018 MUD Payroll 12/14/2018 Medicare Taxes 12/28/2018 Medicare Taxes 807.72 196.18 195.66 1,003.90 1,199.56 PR PR Account: 135-50035-030-000 Medicare Taxes Totals: 391.84 1,199.56 ** 6,450.00 Budgeted 5,250.44 Remaining 19 % Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 Account: 135-50040-030-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used glpdatb2 skrolczyk 14:58 01/17/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 12/2018 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) Page 34 Check Source Number 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 holiday party food holiday party food open enrollment breakfast open enrollment breakfast. holiday party supplies gingerbread house supplies return gingerbread house suppl holiday party prize gift cards gift card gift card party supplies gingerbread houses peppermints gift cards gift cards holiday decor decor holiday party prize yeti cooler prize gingerbread houses 52.39 13.98 243.82 18.98 45.43 22.79 18.30 (16.03) 27.27 45.00 12.00 10.00 20.30 3.17 13.96 800.00 1,100.00 25.08 2.17 18.39 292.25 50.80 66.37 TOM THUMB #1789 310.19 CRISTINA'S MEXICAN 329.17 TOM THUMB #1780 374.60 TACO CABANA 20356 OLO 397.39 WM SUPERCENTER #266 415.69 JOANN STORES #2035 399.66 JOANN STORES #2035 426.93 STARBUCKS STORE 23869 471.93 CHICK-FIL-A #01195 483.93 WENDY'S #2597 493.93 PANERA BREAD #601434 514.23 WM SUPERCENTER #2834 517.40 MICHAELS STORES 2733 531.36 SAMSCLUB.COM 1,331.36 SAMSCLUB #6781 2,431.36 TOM THUMB #3625 2,456.44 JOANN STORES #2035 2,458.61 DOLLAR TREE 2,477.00 TARGET 00008763 2,769.25 AMZN MKTP US*M002A2090 2,820.05 MICHAELS STORES 5062 PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC Account: 135-50070-030-000 Employee Relations Totals: 2,767.66 2,820.05 ** 5,000.00 Budgeted 2,179.95 Remaining 56 % Used Account: 135-55030-030-000 Software & Support 372 12/06/2018 December A/P Internet -November 68,111.95 903.72 69,015.67 Charter Communications 4787 AP Account: 135-50045-030-000 Workman's Compensation 127 12/01/2018 Insurance/Wrk Comp Expense Dec 213.10 106.55 319.65 GL Account: 135-50045-030-000 Workman's Compensation Totals: 106.55 319.65 ■■ 1,295.00 Budgeted 975.35 Remaining 25 % Used Account: 135-50060-030-000 ' Pre-emp Physicals/Testing .00 .00 Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 ' Employee Relations 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 508 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 - 12/26/18 holiday party food holiday party food open enrollment breakfast open enrollment breakfast. holiday party supplies gingerbread house supplies return gingerbread house suppl holiday party prize gift cards gift card gift card party supplies gingerbread houses peppermints gift cards gift cards holiday decor decor holiday party prize yeti cooler prize gingerbread houses 52.39 13.98 243.82 18.98 45.43 22.79 18.30 (16.03) 27.27 45.00 12.00 10.00 20.30 3.17 13.96 800.00 1,100.00 25.08 2.17 18.39 292.25 50.80 66.37 TOM THUMB #1789 310.19 CRISTINA'S MEXICAN 329.17 TOM THUMB #1780 374.60 TACO CABANA 20356 OLO 397.39 WM SUPERCENTER #266 415.69 JOANN STORES #2035 399.66 JOANN STORES #2035 426.93 STARBUCKS STORE 23869 471.93 CHICK-FIL-A #01195 483.93 WENDY'S #2597 493.93 PANERA BREAD #601434 514.23 WM SUPERCENTER #2834 517.40 MICHAELS STORES 2733 531.36 SAMSCLUB.COM 1,331.36 SAMSCLUB #6781 2,431.36 TOM THUMB #3625 2,456.44 JOANN STORES #2035 2,458.61 DOLLAR TREE 2,477.00 TARGET 00008763 2,769.25 AMZN MKTP US*M002A2090 2,820.05 MICHAELS STORES 5062 PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC Account: 135-50070-030-000 Employee Relations Totals: 2,767.66 2,820.05 ** 5,000.00 Budgeted 2,179.95 Remaining 56 % Used Account: 135-55030-030-000 Software & Support 372 12/06/2018 December A/P Internet -November 68,111.95 903.72 69,015.67 Charter Communications 4787 AP glpdatb2 skrolczyk 14:58 01/17/19 Fund: 135 MUD 1 General Fund JE Number 420 420 508 508 508 508 508 557 JE Date 12/17/2018 12/17/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/26/2018 12/31/2018 557 12/31/2018 593 12/31/2018 Account: 135-55030-030-000 JE Description December A/P December A/P Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 Pcard 11/27/18 December A/P December A/P Recode M3 Annual Account: 135-55070-030-000 557 12/31/2018 December A/P 557 12/31/2018 December A/P Account: 135-55070-030-000 Account: 135-55080-030-000 557 12/31/2018 December A/P Account: 135-55080-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 12/2018 JE Detail Beginning Balance Description/Comment peak agenda software Microsoft excahnge 12/26/18 internet 12/26/18 internet 12/26/18 internet 12/26/18 internet 12/26/18 acrobat pro FA consulting Code Red renewal -10/27/18-10/2 Soft & Supprt Recode Software & Support Totals: 77,849.00 Budgeted 59,728.41 Remaining Independent Labor GM December GM December Independent Labor Totals: 175,000.00 Budgeted 139,821.11 Remaining Maintenance & Repairs Fire alarm monitoring -Dec 2018 Maintenance & Repairs Totals: 20,000.00 Budgeted 19,205.00 Remaining 68,111.95 23 5 Used Program: Transaction Detail Transaction Vendor_Name Detail (SUBTOTAL) 3,465.00 72,480.67 504.00 72,984.67 32.72 73,017.39 124.34 73,141.73 107.79 73,249.52 69.12 73,318.64 32.45 73,351.09 304.50 73,655.59 3,670.00 77,325.59 (59,205.00) 18,120.59 (49,991.36) GRANICUS, INC M3 Networks ATT*SILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE *ACROPRO SUBS STW INC Onsolve Intermediate Holding 18,120.59 ** 23,366.90 11.99 23,378.89 Carman Consulting LLC. 11,800.00 11,811.99 20 % Used 35,178.89 Carman Consulting LLC. 35,178.89 ** 315.00 480.00 795.00 PRO FIRE & SPRINKLER LLC 4 % Used 480.00 795.00 ** Page 35 Check Source Number 4837 AP 4843 AP PC PC PC PC PC 4923 AP 4919 AP GL 4909 AP 4909 AP 4920 AP Account: 135-55085-030-000 Generator Maint. and Repair Account: 135-55085-030-000 Account: 135-55120-030-000 503 12/31/2018 December A/P Account: 135-55120-030-000 Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining Cleaning Services janitorial service -november .00 .00 0 % Used .00 .00 ** 869.06 869.06 1,738.12 MEMBER'S BUILDING MAINTENANCE 4890 AP Cleaning Services Totals: 869.06 1,738.12 ** 10,000.00 Budgeted 8,261.88 Remaining 17 % Used glpdatb2 skrolczyk 14:58 01/17/19 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: 12/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 36 Check Source Number 372 12/06/2018 December A/P Answering service -December 508 12/26/2018 Pcard 11/27/18 - 12/26/18 office phone 508 12/26/2018 Pcard 11/27/18 - 12/26/18 phone 508 12/26/2018 Pcard 11/27/18 - 12/26/18 phone 508 12/26/2018 Pcard 11/27/18 - 12/26/18 answering service 581 12/31/2018 Town Billed Invoices 1668-1671 AR 20181231-20181231 User: 2,979.46 207.75 155.80 861.43 461.53 12.99 (180.00) 3,187.21 KEYSTONE PARK SECRETARIAL 3,343.01 ATT*BILL PAYMENT 4,204.44 ATT*SUS PHONE PMT 4,665.97 ATT*BUS PHONE PMT 4,678.96 RINGCENTRAL, INC 4,498.96 4799 AP PC PC PC PC AR Account: 135-60005-030-000 Telephone Totals: 1,519.50 4,498.96 ** Account: 135-55160-030-000 Professional Outside Services 23,500.00 Budgeted 19,001.04 Remaining 19 % Used 593 12/31/2018 Recode M3 Annual Soft & Supprt Recode 135-60010-030-000 Communications/Mobiles 59,205.00 59,205.00 GL Account: 135-55160-030-000 Professional Outside Services Totals: 420 12/17/2018 December A/P 455 12/28/2018 MUD Payroll 59,205.00 59,205.00 ** 87.49 150.00 562.47 712.47 VERIZON WIRELESS 66,055.00 Budgeted 6,850.00 Remaining 90 % Used 135-60010-030-000 Communications/Mobiles Totals: 237.49 Account: 135-55205-030-000 Utility Billing Contract 4,000.00 Budgeted 3,287.53 Remaining 18 % Used 557 12/31/2018 December A/P December billings 1,159.56 582.83 1,742.39 DATAPROSE LLC 4912 AP Account: 135-55205-030-000 Utility Billing Contract Totals: 582.83 1,742.39 ** 557.71 9,000.00 Budgeted 7,257.61 Remaining 19 % Used Account: 135-60020-030-000 Account: 135-60005-030-000 Telephone .00 557.71 ** 372 12/06/2018 December A/P Answering service -December 508 12/26/2018 Pcard 11/27/18 - 12/26/18 office phone 508 12/26/2018 Pcard 11/27/18 - 12/26/18 phone 508 12/26/2018 Pcard 11/27/18 - 12/26/18 phone 508 12/26/2018 Pcard 11/27/18 - 12/26/18 answering service 581 12/31/2018 Town Billed Invoices 1668-1671 AR 20181231-20181231 User: 2,979.46 207.75 155.80 861.43 461.53 12.99 (180.00) 3,187.21 KEYSTONE PARK SECRETARIAL 3,343.01 ATT*BILL PAYMENT 4,204.44 ATT*SUS PHONE PMT 4,665.97 ATT*BUS PHONE PMT 4,678.96 RINGCENTRAL, INC 4,498.96 4799 AP PC PC PC PC AR Account: 135-60005-030-000 Telephone Totals: 1,519.50 4,498.96 ** 23,500.00 Budgeted 19,001.04 Remaining 19 % Used Account: 135-60010-030-000 Communications/Mobiles 420 12/17/2018 December A/P 455 12/28/2018 MUD Payroll Cell phones -December 12/28/2018 Communications/Mobiles 474.98 87.49 150.00 562.47 712.47 VERIZON WIRELESS 4858 AP PR Account: 135-60010-030-000 Communications/Mobiles Totals: 237.49 712.47 ** 4,000.00 Budgeted 3,287.53 Remaining 18 % Used Account: 135-60020-030-000 Electricity/Gas 557.71 .00 557.71 Account: 135-60020-030-000 Electricity/Gas Totals: .00 557.71 ** 8,690.00 Budgeted 8,132.29 Remaining 6 % Used Account: 135-60025-030-000 Water 503 12/31/2018 December A/P Water -December 107.40 107.71 215.11 TROPHY CLUB MUD (WATER BILLS) 4903 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 581 12/31/2018 Town Billed Invoices 1668-1671 AR 20181231-20181231 User: Account: 135-60025-030-000 Account: 135-60035-030-000 557 12/31/2018 December A/P Account: 135-60035-030-000 Account: 135-60040-030-000 397 12/14/2018 Child Support Fee 456 12/28/2018 Child Support Fee 503 12/31/2018 December A/P 563 12/31/2018 Pace Credit Card Fees 563 12/31/2018 Pace Credit Card Fees Account: 135-60040-030-000 107.40 (53.85) 161.26 AR Water Totals: 53.86 161.26 ** 2,000.00 Budgeted Postage December billings 1,838.74 Remaining 8 % Used 3,345.39 1,618.98 4,964.37 DATAPROSE LLC 4912 AP Postage Totals: 1,618.98 II1A264.37 ** 30,000.00 Budgeted Service Charges & Fees Direct send fees 25,035.63 Remaining 17 % Used Service Charges & Fees Totals: 55,560.00 Budgeted 37,405.47 Remaining 12,232.37 1.50 12,233.87 GL 1.50 12,235.37 GL 50.00 12,285.37 Fisery Solutions, LLC 4875 AP 5,780.53 18,065.90 GL 88.63 18,154.53 GL 33 % Used 5,922.16 18,154.53 ** Account: 135-60050-030-000 Bad Debt Expense .00 .00 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 127 12/01/2018 Insurance/Wrk Comp Expense Dec 12,605.46 6,302.73 18,908.19 GL Account: 135-60055-030-000 Insurance Totals: 6,302.73 18,908.19 ** Account: 135-60066-030-000 Account: 135-60066-030-000 65,000.00 Budgeted 46,091.81 Remaining 29 % Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining .00 0 % Used .00 .00 .00 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-60070-030-000 420 12/17/2018 December A/P 478 12/28/2018 December A/P Account: 135-60070-030-000 Dues 6 Memberships Social security program fee Dues 2019 Dues & Memberships Totals: 6,000.00 Budgeted 2,198.75 Remaining 200.00 35.00 235.00 TX SOCIAL SECURITY PROGRAM 63 % Used 4856 AP 3,566.25 3,801.25 Texas Rural Water Assoc 4902 AP 3,601.25 3,801.25 ** Account: 135-60075-030-000 Meetings Account: 135-60075-030-000 Meetings 400.00 Budgeted Totals: 400.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-60079-030-000 Public Education .00 .00 Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training .00 .00 Account: 135-60080-030-000 Schools & Training Totals: .00 .00 ** Account: 135-60100-030-000 Account: 135-60100-030-000 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 4,345.00 Remaining 0 % Used .00 .00 .00 .00 ** .00 .00 Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 6 Used Account: 135-60125-030-000 Advertising glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-60125-030-000 Account: 135-60235-030-000 420 12/17/2018 December A/P Account: 135-60235-030-000 .00 .00 Advertising Totals: .00 .00 ** 25,000.00 Budgeted 25,000.00 Remaining 0 % Used Security monitoring service 48.00 24.00 72.00 Digital Air Control, Inc Security Totals: 24.00 72.00 ** 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 Account: 135-60246-030-000 Account: 135-60246-030-000 Account: 135-60360-030-000 Account: 135-60360-030-000 Account: 135-65010-030-000 Account: 135-65010-030-000 Account: 135-65055-030-000 1,216.00 Remaining 6 % Used Miscellaneous Expenses Totals: 500.00 Budgeted 500.00 Remaining 0 % Used General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Furniture/Equipment < $5000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Uniforms Uniforms Totals: 2,050.00 Budgeted Hardware 0 o Used 0 % Used 2,050.00 Remaining 0 % Used 1,246.49 .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 1,246.49 4836 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-65055-030-000 Hardware Totals: .00 1,246.49 ** 7,064.00 Budgeted 5,817.51 Remaining 18 % Used Account: 135-65085-030-000 Office Supplies 508 12/26/2018 Pcard 11/27/18 - 12/26/18 truvia 1,224.56 27.96 1,252.52 SAMSCLUB.COM PC 508 12/26/2018 Pcard 11/27/18 - 12/26/18 toner 162.89 1,415.41 AMAZON.COM*M27OO2HX1 PC 508 12/26/2018 Pcard 11/27/18 - 12/26/18 coffee,coffee cups 81.33 1,496.74 AMZN MKTP US*M26XD8112 PC 508 12/26/2018 Pcard 11/27/18 - 12/26/18 coffee creamer 19.18 1,515.92 AMAZON.COM*M22YA8CB2 PC 508 12/26/2018 Pcard 11/27/18 - 12/26/18 coffee 26.96 1,542.88 AMAZON.COM*M047179W2 PC 508 12/26/2018 Pcard 11/27/18 - 12/26/18 medicine 16.96 1,559.84 SAMSCLUB #4795 PC 508 12/26/2018 Pcard 11/27/18 - 12/26/18 postcards 184.35 1,744.19 SP * DESKTOPSUPPLIES PC 478 12/28/2018 December A/P office supplies 98.72 1,842.91 OFFICE DEPOT, INC 4892 AP 478 12/28/2018 December A/P office supplies 53.21 1,896.12 OFFICE DEPOT, INC 4892 AP Account: 135-65085-030-000 Office Supplies Totals: 671.56 1,896.12 ** 6,000.00 Budgeted 4,103.88 Remaining 32 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 508 12/26/2018 Pcard 11/27/18 - 12/26/18 knife 814.75 11.89 826.64 SAMS CLUB #6781 PC 508 12/26/2018 Pcard 11/27/18 - 12/26/18 water, tables 120.13 946.77 SAMS CLUB #6781 PC 508 12/26/2018 Pcard 11/27/18 - 12/26/18 coffee 56.99 1,003.76 AMZN MKTP US*MO1WY5B22 PC Account: 135-65095-030-000 Maintenance Supplies Totals: 189.01 1,003.76 ** 4,000.00 Budgeted 2,996.24 Remaining 25 % Used Account: 135-65105-030-000 Printing .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays glpdatb2 skrolczyk 14:58 01/17/19 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: 12/2018 JE Detail Beginning Balance Description/Comment Program: Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Page 41 Check Source Number Department 30 Totals: 84,247.43 Monthly Total 292,766.31 ** 1,559,905.00 Budgeted 1,267,138.69 Remaining 19 % Used .00 .00 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 420 12/17/2018 December A/P 478 12/28/2018 December A/P Copier lease -december copies 572.24 194.00 67.72 766.24 833.96 TIAA COMMERCIAL FINANCE KYOCERA DOCUMENT SOLUTIONS 4853 4886 AP AP Account: 135-69170-030-000 Copier Lease Installments Totals: 261.72 833.96 ** 4,000.00 Budgeted 3,166.04 Remaining 21 % Used Department 30 Totals: 84,247.43 Monthly Total 292,766.31 ** 1,559,905.00 Budgeted 1,267,138.69 Remaining 19 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/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 420 12/17/2018 December A/P Legal -Westlake Easement Account: 135-55045-039-000 17,074.68 6,075.00 23,149.68 WHITAKER CHALK SWINDLE 4859 AP Legal Totals: 6,075.00 23,149.68 ** 137,000.00 Budgeted 113,850.32 Remaining 17 % Used Account: 135-55055-039-000 Auditing 420 12/17/2018 December A/P FYE 18 Audit Final Account: 135-55055-039-000 5,000.00 9,750.00 14,750.00 LAFOLLETT & ABBOTT PLLC 4842 AP Auditing Totals: 9,750.00 14,750.00 ** 30,800.00 Budgeted 16,050.00 Remaining 48 % Used Account: 135-55060-039-000 Appraisal 372 12/06/2018 December A/P TAD Budget Allocation -Annual 478 12/28/2018 December A/P 1st quarter 2019 appraisal DCA 2,612.12 2,612.12 TARRANT APPRAISAL DISTRICT 4805 AP 2,111.10 4,723.22 DENTON CENTRAL APPRAISAL DISTR 4869 AP Account: 135-55060-039-000 Appraisal Totals: 4,723.22 4,723.22 ** 11,714.00 Budgeted 6,990.78 Remaining 40 % Used Account: 135-55065-039-000 Tax Admin Fees 587 12/21/2018 Tax Collection fees/Denton Cty 3,653.00 3,653.00 GL Account: 135-55065-039-000 Tax Admin Fees Totals: 3,653.00 3,653.00 ** Department 39 Totals: Fund 135 Totals: 4,800.00 Budgeted 1,147.00 Remaining 76 % Used 24,201.22 Monthly Total 184,314.00 Budgeted (276,273.65) Monthly Total (341,837.00) Budgeted 46,275.90 ** 138,038.10 Remaining 25 % Used (169,460.53) (172,376.47) Remaining 50 % Used glpdatb2 skrolczyk 14:58 01/17/19 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: 12/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 DECEMBER 2018 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 517 CONSTRUCTION FUND 1,595,680 1,595,680 (1,479,465) (116,216) (1,595,680) glbase_tbam skrolczyk 14:57 01/17/19 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: 12/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 Trophy Club MUD No.1 Page 15 14:57 01/17/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49141-020-000 Interfund Transfers In Gen 122,777.00 Subtotal: 122,777.00 Program number: 122,777.00 Department number: Wastewater 122,777.00 Revenues Subtotal 122,777.00 7.29- 7.29 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 14:57 01/17/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 37,992.35 116,222.93 116,222.93 - Subtotal: 37,992.35 116,222.93 116,222.93 - Program number: 37,992.35 116,222.93 116,222.93 - Department number: Wastewater 37,992.35 116,222.93 116,222.93 - Expenditures Subtotal 37,992.35 116,222.93 116,222.93 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 160,769.35 116,215.64 116,215.64- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/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 14:58 01/17/19 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: 12/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 160,769.35 Monthly Total 160,769.35 Monthly Total (116,222.93) Remaining 0 % Used 116,222.93 ** .00 Budgeted (116,222.93) Remaining 0 % Used 116,215.64 .00 Budgeted (116,215.64) Remaining 0 % Used Account: 517-49141-020-000 Interfund Transfers In Gen 443 12/20/2018 Cor 517 Due to/Due from 135 Due from/ WWTP Fund 517 (122,777.00) 122,777.00 .00 GL Account: 517-49141-020-000 Interfund Transfers In Gen Totals: 122,777.00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 503 12/31/2018 December A/P WWTP improvements 557 12/31/2018 December A/P WWTP Imporvements 78,230.58 27,740.00 10,252.35 105,970.58 116,222.93 WEBBER-CADAGUA PARTNERS CP&Y/WALLACE GROUP, INC. 4907 4911 AP AP Account: 517-69005-020-000 Capital Outlays Totals: 37,992.35 116,222.93 ** Department 20 Totals: Fund 517 Totals: .00 Budgeted 160,769.35 Monthly Total 160,769.35 Monthly Total (116,222.93) Remaining 0 % Used 116,222.93 ** .00 Budgeted (116,222.93) Remaining 0 % Used 116,215.64 .00 Budgeted (116,215.64) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET DECEMBER 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 DECEMBER 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 DECEMBER 2018 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TRSPry COLIC, nnrnicmAL In:LCTY DE TNC7 528 REVENUE BOND ASSETS RESERVE 655,494 TOTAL ASSETS 655,494 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 606,910 48,584 655,494 TOTAL LIABILITIES AND FUND BALANCE 655,494 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 14:57 01/17/19 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 12/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 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 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,252.44- 3,488.36- 4,600.00- 13,800.00- 10,432.00- 31,296.00- 16,284.44- 48,584.36- 16,284.44- 48,584.36- 16,284.44- 48,584.36- 16,284.44- 48,584.36- 16,284.44- 48,584.36- 69.767 25.003 24.999 26.208 26.208 26.208 26.208 26.208 1,511.64- 41,393.00- 93,891.00- 136,795.64- 136,795.64- 136,795.64- 136,795.64- 136,795.64- glpdatb2 skrolczyk 14:58 01/17/19 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 582 12/31/2018 Bank Interest- December Account: 528-49010-000-000 Trophy Club MUD No.1 Page 46 Detailed Accounting Trial Balance Program: Period Ending: 12/2018 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (5,000.00) Budgeted (2,235.92) (1,252.44) (3,488.36) GL (1,252.44) (3,488.36) ** (1,511.64) Remaining 70 6 Used Account: 528-49142-000-000 Interfund transfer in -Water 442 12/31/2018 TexPool Transfers December TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (55,193.00) Budgeted (41,393.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 442 12/31/2018 TexPool Transfers December TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (9,200.00) (4,600.00) (13,800.00) GL 25 % Used (20,864.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (93,891.00) Remaining (4,600.00) (13,800.00) ** (10,432.00) (31,296.00) GL 25 8 Used (10,432.00) (31,296.00) ** (48,584.36) ** (16,284.44) Monthly Total (185,380.00) Budgeted (136,795.64) Remaining 26 8 Used (48,584.36) (16,284.44) Monthly Total (185,380.00) Budgeted (136,795.64) Remaining 26 8 Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET DECEMBER 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 483,513 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 295,735 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 783,821 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 295,735 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 295,735 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 434,797 TOTAL FUND BALANCE 488,086 TOTAL LIABILITIES AND FUND BALANCE 783,821 glbase_tbam skrolczyk 14:57 01/17/19 Fund: 533 MUD 1 I&S Consolidated Account 533-40000-000-000 533-40002-000-000 533-40015-000-000 Subtotal: 533-49010-000-000 533-49015-000-000 533-49141-000-000 Description Property Taxes Property Taxes/Delinquent Property Taxes/P & I Interest Income Lease/Rental Income Interfund Trans In -PID Surchg Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 687,175.00- 1,800.00- 2,000.00- 690,975.00- 2,000.00- 215,979.00- 120,053.00- 338,032.00- 1,029,007.00- 1,029,007.00- 1,029,007.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 12/2018 Amended Total Budget Encumb. 687,175.00- 1,800.00- 2,000.00- 690,975.00- 2,000.00- 215,979.00- 120,053.00- 338,032.00- 1,029,007.00- 1,029,007.00- 1,029,007.00 - Current Month Program: YTD Total 355,342.42- 401,016.85- 3.17 315.19- 10.02- 56.51- 355,349.27- 401,388.55- 428.75- 666.68- 10,913.90- 32,741.70- 11,342.65- 33,408.38- 366,691.92- 434,796.93- 366,691.92- 434,796.93- 366,691.92- 434,796.93- % of Budget Remaining Budget 58.357 286,158.15- 17.511 1,484.81- 2.826 1,943.49- 58.090 289,586.45- 33.334 1,333.32- 215,979.00- 27.273 87,311.30- 9.883 304,623.62- 42.254 594,210.07- 42.254 594,210.07- 42.254 594,210.07 - Page 18 glbase_tbam skrolczyk 14:57 01/17/19 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: 12/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- 366,691.92- 434,796.93- 7,497.792 428,997.93 glpdatb2 skrolczyk Trophy Club MUD No.1 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/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 513 12/03/2018 Property Taxes 514 12/04/2018 Property Taxes 515 12/05/2018 Property Taxes 516 12/06/2018 Property Taxes 517 12/07/2018 Property Taxes 518 12/10/2018 Property Taxes 519 12/11/2018 Property Taxes 520 12/12/2018 Property Taxes 521 12/13/2018 Property Taxes 522 12/14/2018 Property Taxes 523 12/17/2018 Property Taxes 524 12/18/2018 Property Taxes 525 12/19/2018 Property Taxes 526 12/20/2018 Property Taxes 527 12/21/2018 Property Taxes 528 12/26/2018 Property Taxes 529 12/27/2018 Property Taxes 530 12/28/2018 Property Taxes 531 12/31/2018 Property Taxes (45,674.43) (1,988.85) (3,253.69) (694.61) (3,330.70) (1,342.79) (3,973.32) (3,505.56) (2,823.69) (22,094.67) (129,746.23) (5,092.64) (5,747.71) (7,189.00) (67,334.68) (6,246.98) (6,829.82) (65,751.47) (10,820.36) (7,575.65) (47,663.28) (50,916.97) (51,611.58) (54,942.28) (56,285.07) (60,258.39) (63,763.95) (66,587.64) (88,682.31) (218,428.54) (223,521.18) (229,268.89) (236,457.89) (303,792.57) (310,039.55) (316,869.37) (382,620.84) (393,441.20) (401,016.85) 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: (355,342.42) (401,016.85) ** (687,175.00) Budgeted (286,158.15) Remaining 58 6 Used Account: 533-40002-000-000 Property Taxes/Delinquent 517 12/07/2018 Property Taxes 519 12/11/2018 Property Taxes 527 12/21/2018 Property Taxes 529 12/27/2018 Property Taxes 531 12/31/2018 Property Taxes (318.36) (2.44) (.26) 49.48 (.04) (43.57) (320.80) (321.06) (271.58) (271.62) (315.19) GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 3.17 (315.19) ** (1,800.00) Budgeted (1,484.81) Remaining 18 % Used Account: 533-40015-000-000 Property Taxes/P 6 I 531 12/31/2018 Property Taxes (46.49) (10.02) (56.51) GL Account: 533-40015-000-000 Property Taxes/P 6 I Totals: (10.02) (56.51) ** (2,000.00) Budgeted (1,943.49) Remaining 3 % Used Account: 533-49010-000-000 Interest Income glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 582 12/31/2018 Bank Interest- December (237.93) (428.75) (666.68) GL Account: 533-49010-000-000 Interest Income Totals: (428.75) (666.68) ** (2,000.00) Budgeted (1,333.32) Remaining 33 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 Account: 533-49015-000-000 Lease/Rental Income Totals: .00 ** (215,979.00) Budgeted (215,979.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 442 12/31/2018 TexPool Transfers December TexPool O&M to I&S- PID Debt (21,827.80) Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (120,053.00) Budgeted (87,311.30) Remaining 27 % Used (10,913.90) (32,741.70) GL (10,913.90) (32,741.70) ** Department Totals: (434,796.93) ** (366,691.92) Monthly Total (1,029,007.00) Budgeted (594,210.07) Remaining 42 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/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 Paying Agent Fee Totals: 2,150.00 Budgeted 2,150.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 533-70025-051-000 Bond Interest Expense -Tax Account: 533-70025-051-000 Account: 533-70035-051-000 Department 51 Totals: .00 .00 Bond Interest Expense -Tax Totals: .00 .00 ** 266,058.00 Budgeted 266,058.00 Remaining .00 .00 Bond Principal Payment -Tax Totals: .00 .00 ** 755,000.00 Budgeted 755,000.00 Remaining 0 6 Used .00 ** Account: 533-70035-051-000 Bond Principal Payment -Tax 0 % Used .00 Monthly Total 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used Fund 533 Totals: (434,796.93) (366,691.92) Monthly Total (5,799.00) Budgeted 428,997.93 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET DECEMBER 2018 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Tp4PHk [ L LI nmrm [PAL MI T = 534 REVENUE BOND ASSETS I&S 182,639 TOTAL ASSETS 182,639 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 19,562 163,077 182,639 TOTAL LIABILITIES AND FUND BALANCE 182,639 glbase_tbam skrolczyk 14:57 01/17/19 Fund: 534 2015 Revenue Bond I&S Account 534-49010-000-000 534-49143-000-000 Description Interest Income Interfund Transfer In -WW Sales Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 12/2018 Amended Total Budget Encumb. 1,000.00- 596,238.00- 597,238.00- 597,238.00- 597,238.00- 597,238.00 - Program: Current YTD Month Total 287.59- 466.73- 54,203.45- 162,610.35- 54,491.04- 163,077.08- 54,491.04- 163,077.08- 54,491.04- 163,077.08- 54,491.04- 163,077.08- % of Budget Remaining Budget 46.673 533.27- 27.273 433,627.65- 27.305 434,160.92- 27.305 434,160.92- 27.305 434,160.92- 27.305 434,160.92 - Page 20 glbase_tbam skrolczyk 14:57 01/17/19 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: 12/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,491.04- 163,077.08- ############### 162,077.08 glpdatb2 skrolczyk 14:58 01/17/19 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 12/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,491.04) Monthly Total (433,627.65) Remaining 27 % Used (597,238.00) Budgeted (163,077.08) ** (434,160.92) Remaining 27 % Used Account: 534-49010-000-000 Interest Income 582 12/31/2018 Bank Interest- December (179.14) (287.59) (466.73) GL Account: 534-49010-000-000 Interest Income Totals: (287.59) (466.73) ** (1,000.00) Budgeted (533.27) Remaining 47 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 442 12/31/2018 TexPool Transfers December TexPool O&M to Rev Bd WWTP I&S (108,406.90) (54,203.45) (162,610.35) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.45) (162,610.35) ** Department Totals: (596,238.00) Budgeted (54,491.04) Monthly Total (433,627.65) Remaining 27 % Used (597,238.00) Budgeted (163,077.08) ** (434,160.92) Remaining 27 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/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 .00 .00 ** .00 ** 596,238.00 Remaining 0 % Used (163,077.08) (54,491.04) Monthly Total (1,000.00) Budgeted 162,077.08 Remaining (MMMMMNNNN TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET DECEMBER 2018 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 535 SWIFT REVENUE ASSETS BONDI&S 78,283 TOTAL ASSETS 78,283 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 2,584 75,699 78,283 TOTAL LIABILITIES AND FUND BALANCE 78,283 glbase_tbam skrolczyk 14:57 01/17/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 1 535-49010-000-000 1 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 12/2018 Adopted Amended Total Budget Budget Encumb. 600.00- 600.00 - Current Month 120.86 - Program: YTD Total 180.40- % of Remaining Budget Budget 30.067 419.60 - Page 22 535-49142-000-000 Interfund Tran In -Water Sales 276,901.00- 276,901.00- 25,172.81- 75,518.43- 27.273 201,382.57 - Subtotal: 277,501.00- 277,501.00- 25,293.67- 75,698.83- 27.279 201,802.17 - Program number: 277,501.00- 277,501.00- 25,293.67- 75,698.83- 27.279 201,802.17 - Department number: Revenues 277,501.00- 277,501.00- 25,293.67- 75,698.83- 27.279 201,802.17 - Revenues Subtotal 277,501.00- 277,501.00- 25,293.67- 75,698.83- 27.279 201,802.17- glbase_tbam skrolczyk 14:57 01/17/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 535-70005-051-000 Description Rev Bond Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 12/2018 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month Program: YTD Total % of Remaining Budget Budget 400.00 Page 23 535-70040-051-000 Revenue Bond Interest Expense 1 535-70045-051-000 Revenue Bond Principal Expense 61,501.00 215,000.00 61,501.00 215,000.00 61,501.00 215,000.00 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,293.67- 75,698.83- ############### 75,098.83 ******* End of Report ********* glpdatb2 skrolczyk 14:58 01/17/19 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: 12/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,293.67) Monthly Total (201,382.57) Remaining 27 % Used (277,501.00) Budgeted (75,698.83) ** (201,802.17) Remaining 27 % Used Account: 535-49010-000-000 Interest Income 582 12/31/2018 Bank Interest- December (59.54) (120.86) (180.40) GL Account: 535-49010-000-000 = Interest Income Totals: (120.86) (180.40) ** (600.00) Budgeted (419.60) Remaining 30 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 442 12/31/2018 TexPool Transfers December TexPool O&M to 16Swift Rev I&S (50,345.62) (25,172.81) (75,518.43) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.81) (75,518.43) ** Department Totals: (276,901.00) Budgeted (25,293.67) Monthly Total (201,382.57) Remaining 27 % Used (277,501.00) Budgeted (75,698.83) ** (201,802.17) Remaining 27 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 14:58 01/17/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: Period Ending: 12/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: 61,501.00 Budgeted 61,501.00 Remaining O % Used .00 .00 .00 .00 ** .00 O % Used Account: 535-70045-051-000 Revenue Bond Principal Expense Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining Department 51 Totals: Fund 535 Totals: Grand Totals: O % Used .00 Monthly Total 276,901.00 Budgeted (25,293.67) Monthly Total .00 .00 .00 ** .00 .00 .00 .00 ** .00 ** 276,901.00 Remaining 0 % Used (75,698.83) (600.00) Budgeted 75,098.83 Remaining NNNNNNNNNN (1,041,911.52) Monthly Total ******* End of Report ********* (1,232,578.32) **** (1,209,068.00) Budgeted 23,510.32 Remaining 102 % Used